Laddawn.com : Programming Specs - Website Changes for Atlanta Production

Created by Judy Ascensao, last modified on Mar 20, 2014

The following changes are needed for the new site to recognize Atlanta as a Production Facility for MOD items: 

 

BP WEB.BSEAL.SWELD Changes (timeline 35-2):

Add new Variables:

Note: While you are working on this, the site will be broken for MOD items (until all programs have the correct argument passing to this program).  Please alert everyone.

GA.2UP=0  ;* Georgia 2up pass/fail flag

GA.1UP=0  ;* Georgia 1up pass/fail flag

GA.BS=0    ;* Georgia Bottomseal pass/fail

Add 3 new sections to this program for Atlanta 2up Sideweld, Atlanta 1up Sideweld, and Atlanta Bottomseal.  Follow the logic that you see for the other 4 plants.  Add 2up and 1up under the other plant's 2up/1up, then add bottomseal to the end of the bottomseal section.

ATLANTA 2-UP SIDEWELD RULES:

  • CASE FURNBAG or SHEETING or SHEETS or TUBING; set GA.2UP = 0 (these products can never be made sideweld)
  • CASE SHOP.SHOP.GAUGE < 1.50; set GA.2UP = 0    ;* Georgia cannot make this product

 

IF ANY OF THE BELOW STATEMENTS ARE TRUE, SET GA.2UP = 1 (means Georgia can make this product 2up):

  • CASE SHOP.LENGTH >= 12.00 &  SHOP.LENGTH <= 18.00 & SHOP.WIDTH >=6.00 & SHOP.WIDTH <=18.00 & SHOP.GAUGE >= 1.00 & SHOP.GAUGE < 1.25
  • CASE SHOP.LENGTH >= 12.00 & SHOP.LENGTH <= 18.00 & SHOP.WIDTH >= 6.00 & SHOP.WIDTH <= 20.00 & SHOP.GAUGE >= 1.25 & SHOP.GAUGE < 1.50
  • CASE SHOP.LENGTH >= 10.00 & SHOP.LENGTH <= 18.00 & SHOP.WIDTH >= 6.00 & SHOP.WIDTH <=24.00 & SHOP.GAUGE >=1.50 & SHOP.GAUGE < 2.00
  • CASE SHOP.LENGTH >= 10.00 & SHOP.LENGTH <=18.00 & SHOP.WIDTH  >=6.00 & SHOP.WIDTH <=24.00 & SHOP.GAUGE >= 2.00 & SHOP.GAUGE <  2.50
  • CASE SHOP.LENGTH >= 10.00 & SHOP.LENGTH < 12.00 & SHOP.WIDTH  >= 5.00 & SHOP.WIDTH <= 24.00 & SHOP.GAUGE >= 2.50 & SHOP.GAUGE <= 4.00
  • CASE SHOP.LENGTH >= 12.00 & SHOP.LENGTH <= 15.00 & SHOP.WIDTH >= 6.00 & SHOP.WIDTH <= 14.00 & SHOP.GAUGE >= 2.50 & SHOP.GAUGE <= 3.00
  • CASE SHOP.LENGTH >  15.00 & SHOP.LENGTH <= 16.00 & SHOP.WIDTH >  10.00 & SHOP.WIDTH <= 12.00 & SHOP.GAUGE >= 2.50 SHOP.GAUGE <= 3.00
  • CASE SHOP.LENGTH > 15.00 & SHOP.LENGTH <= 18.00 & SHOP.WIDTH >= 6.00 & SHOP.WIDTH <= 10.00 & SHOP.GAUGE >= 2.50 & SHOP.GAUGE <= 3.00
  • CASE SHOP.LENGTH >= 12.00 & SHOP.LENGTH <= 15.00 & SHOP.WIDTH >= 5.00 & SHOP.WIDTH <= 12.00 & SHOP.GAUGE > 3.00 & SHOP.GAUGE <= 4.00
  • CASE SHOP.LENGTH >  15.00 & SHOP.LENGTH <= 18.00 & SHOP.WIDTH >= 6.00 & SHOP.WIDTH <  10.00 & SHOP.GAUGE >  3.00 & SHOP.GAUGE <= 4.00

 

ATLANTA 1-UP SIDEWELD RULES:

  • CASE FURNBAG or SHEETING or SHEETS or TUBING; set GA.1UP = 0 (these products can never be made sideweld)
  • CASE SHOP.GAUGE < 1.50; set GA.1UP = 0    ;* Georgia cannot make this product

IF ANY OF THE BELOW STATEMENTS ARE TRUE, SET GA.1UP = 1 (means Georgia can make this product 1up):

  • CASE SHOP.LENGTH >= 24.00 & SHOP.LENGTH <= 36.00 & SHOP.WIDTH >= 6.00 & SHOP.WIDTH <= 18.00 & SHOP.GAUGE >= 1.00 & SHOP.GAUGE < 1.25
  • CASE SHOP.LENGTH >=  24.00 & SHOP.LENGTH <= 36.00 & SHOP.WIDTH >= 6.00 & SHOP.WIDTH <= 20.00  & SHOP.GAUGE >=  1.25 & SHOP.GAUGE < 1.50C
  • CASE SHOP.LENGTH > 20.00 & SHOP.LENGTH <= 36.00 & SHOP.WIDTH >= 6.00 & SHOP.WIDTH <=  24.00 & SHOP.GAUGE >= 1.50 & SHOP.GAUGE <  2.00
  • CASE SHOP.LENGTH >  20.00  & SHOP.LENGTH <=  36.00 & SHOP.WIDTH >= 6.00 & SHOP.WIDTH <= 24.00 & SHOP.GAUGE >=  2.00 & SHOP.GAUGE <  2.50       
  • CASE SHOP.LENGTH > 20.00 & SHOP.LENGTH <=  24.00  & SHOP.WIDTH >=  6.00  & SHOP.WIDTH <= 10.00 & SHOP.GAUGE >=  2.50 & SHOP.GAUGE <  3.00
  • CASE SHOP.LENGTH > 24.00 & SHOP.LENGTH <= 36.00 & SHOP.WIDTH >= 6.00 & SHOP.WIDTH <= 8.00 & SHOP.GAUGE >=  2.50 & SHOP.GAUGE <=  3.00
  • CASE SHOP.LENGTH > 24.00 & SHOP.LENGTH <=  30.00  & SHOP.WIDTH >= 5.00  & SHOP.WIDTH <= 8.00 & SHOP.GAUGE >  3.00 & SHOP.GAUGE <= 4.00
  • CASE SHOP.LENGTH > 30.00  & SHOP.LENGTH <=  36.00 & SHOP.WIDTH >= 6.00 & SHOP.WIDTH <=  8.00 & SHOP.GAUGE >  3.00 & SHOP.GAUGE <=   4.00
  • CASE SHOP.LENGTH > 19.00 & SHOP.LENGTH <=  20.00 & SHOP.WIDTH >= 5.00 & SHOP.WIDTH <= 9.00 & SHOP.GAUGE >= 3.00 & SHOP.GAUGE <=  4.00
  • CASE SHOP.LENGTH > 20.00  & SHOP.LENGTH <=  24.00 & SHOP.WIDTH >=  5.00  & SHOP.WIDTH <=  8.00  & SHOP.GAUGE >=  3.00 & SHOP.GAUGE <= 4.00

 

ATLANTA BOTTOMSEAL RULES:

IF ANY OF THE BELOW STATEMENTS ARE TRUE, SET GA.BS = 0 (cannot be produced in Atlanta as bottomseal):                                                                             

  • CASE FURNBAG and SHOP.LENGTH < 50.00
  • CASE (SHEETS or TUBING or SHEETING) AND WIDTH.DEPTH < 50.00
  • CASE WIDTH.DEPTH <  50.00
  • CASE NOT(BOR) & WIDTH.DEPTH >= 50.00

IF ANY OF THE BELOW STATEMENTS ARE TRUE, SET GA.BS = 1 (means Georgia can make this product as bottomseal):

  • CASE FURNBAG & NOT(SHOP.FOLDED) & NOT(SHOP.PRINTED) & SHOP.LENGTH >= 28.00
  • CASE SHEETS & NOT(SHOP.PRINTED) & SHOP.DEPTH <= 0.00 & CFOLD & SHOP.WIDTH >= 10.00
  • CASE SHEETS & NOT(SHOP.PRINTED) & SHOP.DEPTH <= 0.00 & SHOP.WIDTH >= 50.00
  • CASE SHEETS & NOT(SHOP.PRINTED) & SHOP.DEPTH > 0.00 & WIDTH.DEPTH >= 10.00 & WIDTH.DEPTH <= 104.00 
  • CASE TUBING & NOT(SHOP.PRINTED) & WIDTH.DEPTH >= 10.00 & WIDTH.DEPTH <= 104.00
  • CASE SHEETING &  NOT(SHOP.PRINTED) & SHOP.DEPTH = 0.00 & CFOLD & SHOP.WIDTH >= 10.00
  • CASE SHEETING & NOT(SHOP.PRINTED) & SHOP.DEPTH <= 0.00 & SHOP.WIDTH  >= 50.00
  • CASE SHEETING & NOT(SHOP.PRINTED) & SHOP.DEPTH > 0.00 & WIDTH.DEPTH >= 10.00 & WIDTH.DEPTH <= 104.00  
  • CASE NOT(SHOP.FOLDED) & NOT(SHOP.PRINTED) & SHOP.WIDTH >= 10.00 & SHOP.DEPTH <= 0.00
  • CASE NOT(SHOP.FOLDED) & NOT(SHOP.PRINTED) & SHOP.DEPTH > 0.00 & WIDTH.DEPTH >= 10.00 & WIDTH.DEPTH <= 55.00
  • CASE NOT(SHOP.FOLDED) & NOT(SHOP.PRINTED) & SHOP.DEPTH > 0.00 & WIDTH.DEPTH >= 10.00 & WIDTH.DEPTH <= 104.00 & BOR

DETERMINE SIDEWELD OR BOTTOMSEAL:

At the bottom of the program after all CASE statements, it sets variable BS.OR.SW.  Add "GA.1UP" and "GA.2UP" to the sideweld test (where it sets BS.OR.SW = "SW").

Argument list of all calling progams:

Modify the following BP's to initialize the GA variables and pass in the argument list:

  • FCT.BTWNHOLES.DEFAULT.VALUE
  • FCT.BTWNHOLES.ENABLED
  • FCT.FORCE.BOR
  • FCT.MINIMUM.MODQTY
  • WEB.ASSIGN.MFGPLANT  *** I had to re-write this program, but it won't work because it's argument list doesn't match WEB.BSEAL.SWELD.  When you are ready to work on this, please overlay this version with WEB.ASSIGN.MFGPLANT.NEW.  This has the new logic and should already have GA in the argument list.
  • WEB.BTWNHOLES.VALIDATE
  • WEB.HOLETYPE.OPTIONS
  • WEB.MODITEM.CHECK
  • WEB.MODITEM.GETPRICE
  • WEB.NBRHOLES.VALIDATE
  • WEB.OPER.TABLEINFO
  • WEB.PACKOUT.RANGES
  • WEB.VALIDATE.ALL

Modify the following LDLIB's:

  • RPC$CONFIGGROUP_GETB YPARTNBR
  • RPC$ITEMSCRIPTELEMENT_GETBYFILTER
  • RPC$MODITEM_GETPRICE

BP WEB.MODITEM.GETPRICE:

The following changes are needed in the WEB.MODITEM.GETPRICE program:

  1. When the MFG.FAC = "02" and vented, get the upcharge flat rate from PKG_CHARGES, column name "FLAT RATE-GA"
  2. Resin Table Row assignment for MFG.FAC = "02":
    1. CASE FURN: Add Atlanta to the following line: 1940: CASE SHOP.MATERIAL = "Standard" AND SHOP.COLOR = "Clear" AND (MFG.FA C = "06" OR MFG.FAC = "05" OR MFG.FAC = "02"); RESIN.TBL.ROW.NBR = 5
    2. CASE FURN: Add Atlanta to the following line: 1946: CASE SHOP.MATERIAL = "Standard" AND COLOR.JOB AND (MFG.FAC = "06" OR  MFG.FAC = "05" OR MFG.FAC = "02"); RESIN.TBL.ROW.NBR = 5
    3. CASE FURN: I think this line has a typo - it should apply to all MFG.FAC, so remove MFG.FAC = "01": 1948: CASE SHOP.MATERIAL = "LLD" AND SHOP.SPECLLD = "Std Hexene Blend" AND  MFG.FAC = "01"; 1949: RESIN.TBL.ROW.NBR = 20
    4. CASE FURN: Add Atlanta to the following line: 1954: CASE SHOP.MATERIAL = "LLD" AND SHOP.SPECLLD = "Octene" AND (MFG.FAC = "06" OR MFG.FAC = "05" OR MFG.FAC = "02"); 1955: RESIN.TBL.ROW.NBR = 8
    5. CASE SOR OR ROLLSHEET OR ROLLTUBE - Add Atlanta: 2015: CASE SHOP.MATERIAL = "Standard" AND SHOP.COLOR = "Clear" AND WIDTH.DEPTH >= 18.00 AND BOTTOMSEAL AND (MFG.FAC = "06" OR MFG.FAC = "05" OR MFG.FAC = "02" ); 2016: RESIN.TBL.ROW.NBR = 5
    6. CASE SOR OR ROLLSHEET OR ROLLTUBE - Add Atlanta: 2031: CASE SHOP.MATERIAL = "Standard" AND COLOR.JOB AND WIDTH.DEPTH >= 18. 00 AND BOTTOMSEAL AND (MFG.FAC = "06" OR MFG.FAC = "05" OR MFG.FAC = "02"); RESIN.TBL.ROW.NBR = 5
    7. CASE SOR OR ROLLSHEET OR ROLLTUBE - Add Atlanta: 2039: CASE SHOP.MATERIAL = "LLD" AND SHOP.SPECLLD = "Octene" AND (MFG.FAC = "06" OR MFG.FAC = "05" OR MFG.FAC = "02"); RESIN.TBL.ROW.NBR = 8
    8. CASE 1 (BAGS):  Add Atlanta to the following line:  2108: CASE SHOP.MATERIAL = "Standard" AND SHOP.COLOR = "Clear" AND WIDTH.DEPTH >= 18.00 AND BOTTOMSEAL AND (MFG.FAC = "06" OR MFG.FAC = "05" OR MFG.FAC = "02");  2109: RESIN.TBL.ROW.NBR = 5
    9. CASE 1 (BAGS): Add Atlanta to the following line:  2124: CASE SHOP.MATERIAL = "Standard" AND COLOR.JOB AND WIDTH.DEPTH >= 18. 00 AND BOTTOMSEAL AND (MFG.FAC = "06" OR MFG.FAC = "05" OR MFG.FAC = "02" ) ; 2125: RESIN.TBL.ROW.NBR = 5
    10. CASE 1 (BAGS): Add Atlanta to the following line:  2132: CASE SHOP.MATERIAL = "LLD" AND SHOP.SPECLLD = "Octene" AND (MFG.FAC = "06" OR MFG.FAC = "05" OR MFG.FAC = "02" ); 2133: RESIN.TBL.ROW.NBR = 8
  3. Additional operation number swapping rules for Atlanta:  add the following logic in the area starting at line 2376:
    1. CASE BUBBLESIZE >= "50.00" AND NOT(BOR.FLAG) AND PRIMARY.OPER="GA06" -> Set Primary Operation Info = Alternate Operation Info then null out Alternate
    2. CASE BUBBLESIZE >= "60.00" AND NOT(BOR.FLAG) AND (PRIMARY.OPER="EX1600" OR PRIMARY.OPER="IA01") -> Set Primary Operation Info = Alternate Operation Info then null out Alternate
  4. Note: Atlanta does not need any logic for EXCLUDE.LLDPE or Resin Swaps

 BP WEB.OPER.TABLEINFO:

Make the following Operation Table changes to add Atlanta:

Add new lines in 'Table Prefix - Plant' area:

  • CASE MFG.FAC = "02" AND SWND.SHEET; TABLE.PREFIX = "SWSG"
  • CASE MFG.FAC = "02" AND BS.OR.SW = "BS"; TABLE.PREFIX = "BG"
  • CASE MFG.FAC = "02" AND BS.OR.SW = "SW"; TABLE.PREFIX = "SWG"