eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_CONFIG_ROUTING_PK dependencies on OE_DEBUG_PUB

Line 170: oe_debug_pub.add ('check_routing: ' || 'Others exception for Check RTG::item id '||to_char(pItemId),1);

166: return (0) ;
167:
168: when others then
169: IF PG_DEBUG <> 0 THEN
170: oe_debug_pub.add ('check_routing: ' || 'Others exception for Check RTG::item id '||to_char(pItemId),1);
171:
172: oe_debug_pub.add ('check_routing: ' || 'Error message is : '||sqlerrm);
173: END IF;
174: return (0) ;

Line 172: oe_debug_pub.add ('check_routing: ' || 'Error message is : '||sqlerrm);

168: when others then
169: IF PG_DEBUG <> 0 THEN
170: oe_debug_pub.add ('check_routing: ' || 'Others exception for Check RTG::item id '||to_char(pItemId),1);
171:
172: oe_debug_pub.add ('check_routing: ' || 'Error message is : '||sqlerrm);
173: END IF;
174: return (0) ;
175:
176: end check_routing;

Line 316: oe_debug_pub.add ('create_routing_ml: ' || 'Config Routing' || lCfgRtgId || ' Already Exists ',1);

312: lItmRtgId,
313: lCfmRtgFlag );
314: if lStatus = 1 then
315: IF PG_DEBUG <> 0 THEN
316: oe_debug_pub.add ('create_routing_ml: ' || 'Config Routing' || lCfgRtgId || ' Already Exists ',1);
317: END IF;
318: return (1) ;
319: end if;
320:

Line 333: oe_debug_pub.add ('create_routing_ml: ' || 'Model Does not have a routing ',1);

329: lItmRtgId,
330: lCfmRtgFlag);
331: if lStatus <> 1 then
332: IF PG_DEBUG <> 0 THEN
333: oe_debug_pub.add ('create_routing_ml: ' || 'Model Does not have a routing ',1);
334:
335: END IF;
336: return (1);
337: end if;

Line 361: oe_debug_pub.add('create_routing_ml: ' || 'Line Id ' || pLineId ||' has Schedule Ship Date of '||g_SchShpDate, 1);

357: ** and hence this line needs to be commented as part of bug 2312199
358: */
359:
360: IF PG_DEBUG <> 0 THEN
361: oe_debug_pub.add('create_routing_ml: ' || 'Line Id ' || pLineId ||' has Schedule Ship Date of '||g_SchShpDate, 1);
362: oe_debug_pub.add (' org id = '||to_char(porgid),1);
363: END IF;
364:
365: -- End Bugfix 1912376

Line 362: oe_debug_pub.add (' org id = '||to_char(porgid),1);

358: */
359:
360: IF PG_DEBUG <> 0 THEN
361: oe_debug_pub.add('create_routing_ml: ' || 'Line Id ' || pLineId ||' has Schedule Ship Date of '||g_SchShpDate, 1);
362: oe_debug_pub.add (' org id = '||to_char(porgid),1);
363: END IF;
364:
365: -- End Bugfix 1912376
366:

Line 407: oe_debug_pub.add('create_routing_ml: ' || 'Before getting validation org',2);

403: -- get oevalidation org
404:
405: lStmtNum := 10;
406: IF PG_DEBUG <> 0 THEN
407: oe_debug_pub.add('create_routing_ml: ' || 'Before getting validation org',2);
408: END IF;
409:
410: -- BUG #1957336 Change for preconfigure bom by Sushant Sawant
411: -- Sushant added this code to check bcol records populated by preconfigure bom module

Line 437: oe_debug_pub.add('create_routing_ml: ' || 'Going to fetch Validation Org ' ,2);

433: and oel.inventory_item_id = pModelId;
434: */
435:
436: IF PG_DEBUG <> 0 THEN
437: oe_debug_pub.add('create_routing_ml: ' || 'Going to fetch Validation Org ' ,2);
438: END IF;
439:
440:
441: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)

Line 453: oe_debug_pub.add('create_routing_ml: ' || 'Validation Org is :' || lOEValidationOrg,2);

449: raise FND_API.G_EXC_ERROR;
450: end if;
451:
452: IF PG_DEBUG <> 0 THEN
453: oe_debug_pub.add('create_routing_ml: ' || 'Validation Org is :' || lOEValidationOrg,2);
454: END IF;
455:
456:
457: lStmtNum := 11;

Line 467: oe_debug_pub.add('create_routing_ml: ' || 'lLineId: ' || to_char(lLineId), 2);

463: from bom_cto_order_lines bcol
464: where bcol.line_id = lParentAtoLineId;
465:
466: IF PG_DEBUG <> 0 THEN
467: oe_debug_pub.add('create_routing_ml: ' || 'lLineId: ' || to_char(lLineId), 2);
468: oe_debug_pub.add('create_routing_ml: ' || 'lModelId: ' || to_char(lModelId), 2);
469: oe_debug_pub.add('create_routing_ml: ' || 'lParentAtoLineId: ' || to_char(lParentAtoLineId), 2);
470: END IF;
471:

Line 468: oe_debug_pub.add('create_routing_ml: ' || 'lModelId: ' || to_char(lModelId), 2);

464: where bcol.line_id = lParentAtoLineId;
465:
466: IF PG_DEBUG <> 0 THEN
467: oe_debug_pub.add('create_routing_ml: ' || 'lLineId: ' || to_char(lLineId), 2);
468: oe_debug_pub.add('create_routing_ml: ' || 'lModelId: ' || to_char(lModelId), 2);
469: oe_debug_pub.add('create_routing_ml: ' || 'lParentAtoLineId: ' || to_char(lParentAtoLineId), 2);
470: END IF;
471:
472: lStmtNum := 12;

Line 469: oe_debug_pub.add('create_routing_ml: ' || 'lParentAtoLineId: ' || to_char(lParentAtoLineId), 2);

465:
466: IF PG_DEBUG <> 0 THEN
467: oe_debug_pub.add('create_routing_ml: ' || 'lLineId: ' || to_char(lLineId), 2);
468: oe_debug_pub.add('create_routing_ml: ' || 'lModelId: ' || to_char(lModelId), 2);
469: oe_debug_pub.add('create_routing_ml: ' || 'lParentAtoLineId: ' || to_char(lParentAtoLineId), 2);
470: END IF;
471:
472: lStmtNum := 12;
473: lStatus := CTO_CONFIG_BOM_PK.get_model_lead_time(

Line 482: oe_debug_pub.add('create_routing_ml: ' || 'Failed in get_model_lead_time.', 1);

478: pErrBuf => lErrBuf);
479:
480: if (lStatus = 0) then
481: IF PG_DEBUG <> 0 THEN
482: oe_debug_pub.add('create_routing_ml: ' || 'Failed in get_model_lead_time.', 1);
483: END IF;
484: return 0;
485: else
486: lTotLeadTime := lLeadTime + lTotLeadTime;

Line 493: oe_debug_pub.add('create_routing_ml: ' || 'Total lead time is: ' || to_char(lTotLeadTime), 2);

489: exit when lLineId = lParentAtoLineId; -- when we reach the top model
490: end loop;
491:
492: IF PG_DEBUG <> 0 THEN
493: oe_debug_pub.add('create_routing_ml: ' || 'Total lead time is: ' || to_char(lTotLeadTime), 2);
494: END IF;
495:
496: xTableName := 'OE_ORDER_LINES ';
497: lStmtNum := 13;

Line 521: oe_debug_pub.add ('create_routing_ml: ' || 'Estimated Release Date is : ' || to_char(lEstRelDate,'dd-mon-yy::hh24:mi:ss'), 2);

517: and cal2.exception_set_id = mp.calendar_exception_set_id
518: and cal2.calendar_date = trunc(bcol.schedule_ship_date));
519:
520: IF PG_DEBUG <> 0 THEN
521: oe_debug_pub.add ('create_routing_ml: ' || 'Estimated Release Date is : ' || to_char(lEstRelDate,'dd-mon-yy::hh24:mi:ss'), 2);
522: END IF;
523:
524:
525: /*---------------------------------------------------------------+

Line 541: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting the routing header information into bom_operational_routings..',5);

537: xTableName := 'BOM_OPERATIONAL_ROUTING';
538: lStmtNum := 30;
539:
540: IF PG_DEBUG <> 0 THEN
541: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting the routing header information into bom_operational_routings..',5);
542: END IF;
543:
544: insert into bom_operational_routings
545: (

Line 643: oe_debug_pub.add ('create_routing_ml: ' || 'Inserted Routing Header :' || lCfgRtgId,2 );

639: and bor.alternate_routing_designator is null
640: and mp.organization_id = pOrgId;
641:
642: IF PG_DEBUG <> 0 THEN
643: oe_debug_pub.add ('create_routing_ml: ' || 'Inserted Routing Header :' || lCfgRtgId,2 );
644: END IF;
645:
646: /*---------------------------------------------------------------+
647: Udpate the mixed_model_map_flag. If the cfm_routing_flag

Line 856: oe_debug_pub.add('Number of Model option independent operations selected = '||sql%rowcount,1);

852: )
853: );
854:
855: If PG_DEBUG <> 0 Then
856: oe_debug_pub.add('Number of Model option independent operations selected = '||sql%rowcount,1);
857: End if;
858:
859: --2nd insert
860: lStmtNum := 52;

Line 1067: oe_debug_pub.add('Number of Model option dependent operations selected = '||sql%rowcount,1);

1063: and operation_sequence_id not in(select operation_sequence_id
1064: from bom_operation_sequences_temp);
1065:
1066: If PG_DEBUG <> 0 Then
1067: oe_debug_pub.add('Number of Model option dependent operations selected = '||sql%rowcount,1);
1068: End if;
1069:
1070: --3rdnd insert
1071: lStmtNum := 53;

Line 1255: oe_debug_pub.add('Number of Model mandatory independent operations selected = '||sql%rowcount,1);

1251: and operation_sequence_id not in(select operation_sequence_id
1252: from bom_operation_sequences_temp);
1253:
1254: If PG_DEBUG <> 0 Then
1255: oe_debug_pub.add('Number of Model mandatory independent operations selected = '||sql%rowcount,1);
1256: End if;
1257:
1258: IF PG_DEBUG <> 0 THEN
1259: oe_debug_pub.add ('create_routing_ml: ' || ' Model Routing : Inserted ' || sql%rowcount || ' records in temp table',2 );

Line 1259: oe_debug_pub.add ('create_routing_ml: ' || ' Model Routing : Inserted ' || sql%rowcount || ' records in temp table',2 );

1255: oe_debug_pub.add('Number of Model mandatory independent operations selected = '||sql%rowcount,1);
1256: End if;
1257:
1258: IF PG_DEBUG <> 0 THEN
1259: oe_debug_pub.add ('create_routing_ml: ' || ' Model Routing : Inserted ' || sql%rowcount || ' records in temp table',2 );
1260: END IF;
1261:
1262: IF PG_DEBUG <> 0 THEN
1263: open bos_temp(lCfgRtgId);

Line 1268: oe_debug_pub.add ('create_routing_ml: ' || 'TempTable after insert :Op Seq Id: ' || d_op_seq_id

1264:
1265: loop
1266: fetch bos_temp into d_op_seq_id,d_rtg_seq_id,d_op_seq_num,d_cfg_rtg_id,d_op_type,d_op_effective_dt ;
1267: exit when bos_temp%notfound;
1268: oe_debug_pub.add ('create_routing_ml: ' || 'TempTable after insert :Op Seq Id: ' || d_op_seq_id
1269: || 'Rtg Seq Id: ' ||d_rtg_seq_id
1270: || 'Op Seq #: ' || d_op_seq_num
1271: || 'Cfg Rtg Id: ' ||d_cfg_rtg_id ,2);
1272: end loop;

Line 1293: oe_debug_pub.add ('create_routing_ml: ' || ' Op Seq # : ' || lmodseqnum || ' Op Type : ' || lmodtyp ,2);

1289: fetch get_op_seq_num into lmodseqnum,lmodtyp;
1290: exit when get_op_seq_num%notfound;
1291:
1292: IF PG_DEBUG <> 0 THEN
1293: oe_debug_pub.add ('create_routing_ml: ' || ' Op Seq # : ' || lmodseqnum || ' Op Type : ' || lmodtyp ,2);
1294: oe_debug_pub.add ('create_routing_ml: ' || 'Esitmated release date lEstRelDate '|| to_char(lEstRelDate,'mm-dd-yy:hh:mi:ss'),2 );
1295: END IF;
1296:
1297: select max(routing_sequence_id) into lmodrtgseqid

Line 1294: oe_debug_pub.add ('create_routing_ml: ' || 'Esitmated release date lEstRelDate '|| to_char(lEstRelDate,'mm-dd-yy:hh:mi:ss'),2 );

1290: exit when get_op_seq_num%notfound;
1291:
1292: IF PG_DEBUG <> 0 THEN
1293: oe_debug_pub.add ('create_routing_ml: ' || ' Op Seq # : ' || lmodseqnum || ' Op Type : ' || lmodtyp ,2);
1294: oe_debug_pub.add ('create_routing_ml: ' || 'Esitmated release date lEstRelDate '|| to_char(lEstRelDate,'mm-dd-yy:hh:mi:ss'),2 );
1295: END IF;
1296:
1297: select max(routing_sequence_id) into lmodrtgseqid
1298: from bom_operation_sequences_temp -- 5336292

Line 1305: oe_debug_pub.add ('create_routing_ml: ' || ' Max. Routing Seq Id : ' || lmodrtgseqid,2);

1301: and config_routing_id = lCfgRtgId -- bugfix 3239267: replaced last_update_login
1302: and last_update_date = glast_update_date; -- 3180827
1303:
1304: IF PG_DEBUG <> 0 THEN
1305: oe_debug_pub.add ('create_routing_ml: ' || ' Max. Routing Seq Id : ' || lmodrtgseqid,2);
1306: END IF;
1307:
1308: update bom_operation_sequences_temp -- 5336292
1309: set config_routing_id = lmodnewCfgRtgId -- bugfix 3239267: replaced last_update_login

Line 1328: oe_debug_pub.add ('create_routing_ml: ' || 'Update login to ' || lmodnewCfgRtgId ||' where routing seq Id is '||lmodrtgseqid,2);

1324: and ( disable_date is null or (disable_date is not null and disable_date >= sysdate ));
1325: /* Bugfix 2177101/2143014 */
1326:
1327: IF PG_DEBUG <> 0 THEN
1328: oe_debug_pub.add ('create_routing_ml: ' || 'Update login to ' || lmodnewCfgRtgId ||' where routing seq Id is '||lmodrtgseqid,2);
1329: END IF;
1330:
1331: end loop;
1332:

Line 1336: oe_debug_pub.add ('create_routing_ml: ' || ' Model Routing : Marked Finally ' || sql%rowcount || ' rows for insertion' ,2);

1332:
1333: close get_op_seq_num;
1334:
1335: IF PG_DEBUG <> 0 THEN
1336: oe_debug_pub.add ('create_routing_ml: ' || ' Model Routing : Marked Finally ' || sql%rowcount || ' rows for insertion' ,2);
1337: END IF;
1338:
1339: IF PG_DEBUG <> 0 THEN
1340:

Line 1347: oe_debug_pub.add ('create_routing_ml: ' || ' TempTable after update :Op Seq Id: ' || d_op_seq_id

1343: loop
1344: fetch bos_temp into d_op_seq_id,d_rtg_seq_id,d_op_seq_num,d_cfg_rtg_id,d_op_type,d_op_effective_dt ;
1345: exit when bos_temp%notfound;
1346:
1347: oe_debug_pub.add ('create_routing_ml: ' || ' TempTable after update :Op Seq Id: ' || d_op_seq_id
1348: || ' Rtg Seq Id: ' ||d_rtg_seq_id
1349: || ' Op Seq# : ' || d_op_seq_num
1350: || ' Cfg Rtg Id: ' ||d_cfg_rtg_id
1351: || ' Op Typ: '||d_op_type

Line 1370: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_sequences - 1st insert ..',5);

1366:
1367: lStmtNum := 60;
1368:
1369: IF PG_DEBUG <> 0 THEN
1370: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_sequences - 1st insert ..',5);
1371: END IF;
1372:
1373: insert into bom_operation_sequences
1374: (

Line 1501: oe_debug_pub.add('create_routing_ml: ' || 'Inserted ' || sql%rowcount || ' rows in BOS',2);

1497: where os1.config_routing_id = lmodnewcfgrtgid ; /*Bugfix 1935580 - change lCfgRtgId to lmodnewCfgRtgId */
1498: -- bugfix 3239267: replaced last_update_login
1499:
1500: IF PG_DEBUG <> 0 THEN
1501: oe_debug_pub.add('create_routing_ml: ' || 'Inserted ' || sql%rowcount || ' rows in BOS',2);
1502: END IF;
1503:
1504: /*--------------------------------------------------------------+
1505: Initialize config_routing_id column so that it can be used -- bugfix 3239267: replaced last_update_login

Line 1515: oe_debug_pub.add('create_routing_ml: ' || 'Deleted ' || sql%rowcount || ' rows from temp table',2);

1511: delete from bom_operation_sequences_temp
1512: where config_routing_id in (lCfgRtgId, lmodnewcfgrtgid);
1513:
1514: IF PG_DEBUG <> 0 THEN
1515: oe_debug_pub.add('create_routing_ml: ' || 'Deleted ' || sql%rowcount || ' rows from temp table',2);
1516: -- bugfix 3239267: replaced last_update_login
1517: END IF;
1518:
1519: /*--------------------------------------------------------------+

Line 1704: oe_debug_pub.add('Number of option class option independent operations selected = '||sql%rowcount,1);

1700: )
1701: );
1702:
1703: If PG_DEBUG <> 0 Then
1704: oe_debug_pub.add('Number of option class option independent operations selected = '||sql%rowcount,1);
1705: End if;
1706:
1707: --2nd insert
1708: lStmtNum := 82;

Line 1912: oe_debug_pub.add('Number of option class option dependent operations selected = '||sql%rowcount,1);

1908: from bom_operation_sequences_temp);
1909:
1910:
1911: If PG_DEBUG <> 0 Then
1912: oe_debug_pub.add('Number of option class option dependent operations selected = '||sql%rowcount,1);
1913: End if;
1914:
1915: --3rd insert
1916: lStmtNum := 83;

Line 2103: oe_debug_pub.add('Number of option class mandatory comps dependent operations selected = '||sql%rowcount,1);

2099: and operation_sequence_id not in(select operation_sequence_id
2100: from bom_operation_sequences_temp);
2101:
2102: If PG_DEBUG <> 0 Then
2103: oe_debug_pub.add('Number of option class mandatory comps dependent operations selected = '||sql%rowcount,1);
2104: End if;
2105:
2106:
2107: lStmtNum := 84;

Line 2109: oe_debug_pub.add ('create_routing_ml: ' || ' Option Class outing : Inserted ' || sql%rowcount || ' records in temp table',2 );

2105:
2106:
2107: lStmtNum := 84;
2108: IF PG_DEBUG <> 0 THEN
2109: oe_debug_pub.add ('create_routing_ml: ' || ' Option Class outing : Inserted ' || sql%rowcount || ' records in temp table',2 );
2110: END IF;
2111:
2112: open bos_temp(lCfgRtgId);
2113:

Line 2119: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after insert :Op Seq Id : ' || d_op_seq_id || ' Rtg Seq Id : ' ||d_rtg_seq_id ,2);

2115: fetch bos_temp into d_op_seq_id,d_rtg_seq_id,d_op_seq_num,d_cfg_rtg_id,d_op_type,d_op_effective_dt;
2116: exit when bos_temp%notfound;
2117:
2118: IF PG_DEBUG <> 0 THEN
2119: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after insert :Op Seq Id : ' || d_op_seq_id || ' Rtg Seq Id : ' ||d_rtg_seq_id ,2);
2120: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after insert :Op Seq # : ' || d_op_seq_num || ' Cfg Rtg Id : ' ||d_cfg_rtg_id ,2);
2121: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after insert :Op Typ : ' || d_op_type || ' Op Effective Dt : ' ||d_op_effective_dt ,2);
2122: END IF;
2123: end loop;

Line 2120: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after insert :Op Seq # : ' || d_op_seq_num || ' Cfg Rtg Id : ' ||d_cfg_rtg_id ,2);

2116: exit when bos_temp%notfound;
2117:
2118: IF PG_DEBUG <> 0 THEN
2119: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after insert :Op Seq Id : ' || d_op_seq_id || ' Rtg Seq Id : ' ||d_rtg_seq_id ,2);
2120: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after insert :Op Seq # : ' || d_op_seq_num || ' Cfg Rtg Id : ' ||d_cfg_rtg_id ,2);
2121: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after insert :Op Typ : ' || d_op_type || ' Op Effective Dt : ' ||d_op_effective_dt ,2);
2122: END IF;
2123: end loop;
2124: close bos_temp;

Line 2121: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after insert :Op Typ : ' || d_op_type || ' Op Effective Dt : ' ||d_op_effective_dt ,2);

2117:
2118: IF PG_DEBUG <> 0 THEN
2119: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after insert :Op Seq Id : ' || d_op_seq_id || ' Rtg Seq Id : ' ||d_rtg_seq_id ,2);
2120: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after insert :Op Seq # : ' || d_op_seq_num || ' Cfg Rtg Id : ' ||d_cfg_rtg_id ,2);
2121: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after insert :Op Typ : ' || d_op_type || ' Op Effective Dt : ' ||d_op_effective_dt ,2);
2122: END IF;
2123: end loop;
2124: close bos_temp;
2125:

Line 2144: oe_debug_pub.add ('create_routing_ml: ' || ' Op Seq # : ' || lopseqnum || ' Op Type : ' || loptyp ,2);

2140: fetch get_op_seq_num into lopseqnum,loptyp;
2141: exit when get_op_seq_num%notfound;
2142:
2143: IF PG_DEBUG <> 0 THEN
2144: oe_debug_pub.add ('create_routing_ml: ' || ' Op Seq # : ' || lopseqnum || ' Op Type : ' || loptyp ,2);
2145: END IF;
2146:
2147: select max(routing_sequence_id) into lrtgseqid
2148: from bom_operation_sequences_temp -- 5336292

Line 2156: oe_debug_pub.add ('create_routing_ml: ' || ' Max. Routing Seq Id : ' || lrtgseqid,2);

2152: and last_update_date = glast_update_date; -- 3180827
2153:
2154:
2155: IF PG_DEBUG <> 0 THEN
2156: oe_debug_pub.add ('create_routing_ml: ' || ' Max. Routing Seq Id : ' || lrtgseqid,2);
2157: END IF;
2158:
2159: update bom_operation_sequences_temp -- 5336292
2160: set config_routing_id = lnewCfgRtgId -- bugfix 3239267: replaced last_update_login

Line 2179: oe_debug_pub.add ('create_routing_ml: ' || 'Update login to ' || lnewCfgRtgId ||' where routing seq Id is '||lrtgseqid,2);

2175: and ( disable_date is null or (disable_date is not null and disable_date >= sysdate ));
2176: /* Bugfix 2177101/2143014 */
2177:
2178: IF PG_DEBUG <> 0 THEN
2179: oe_debug_pub.add ('create_routing_ml: ' || 'Update login to ' || lnewCfgRtgId ||' where routing seq Id is '||lrtgseqid,2);
2180: END IF;
2181:
2182: end loop;
2183:

Line 2187: oe_debug_pub.add ('create_routing_ml: ' || ' Option Routing : Marked Finally ' || sql%rowcount || ' rows for insertion' ,2);

2183:
2184: close get_op_seq_num;
2185:
2186: IF PG_DEBUG <> 0 THEN
2187: oe_debug_pub.add ('create_routing_ml: ' || ' Option Routing : Marked Finally ' || sql%rowcount || ' rows for insertion' ,2);
2188: END IF;
2189:
2190: open bos_temp(lnewCfgRtgId);
2191:

Line 2197: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after update :Op Seq Id : ' || d_op_seq_id || ' Rtg Seq Id : ' ||d_rtg_seq_id ,2);

2193: fetch bos_temp into d_op_seq_id,d_rtg_seq_id,d_op_seq_num,d_cfg_rtg_id,d_op_type,d_op_effective_dt;
2194: exit when bos_temp%notfound;
2195:
2196: IF PG_DEBUG <> 0 THEN
2197: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after update :Op Seq Id : ' || d_op_seq_id || ' Rtg Seq Id : ' ||d_rtg_seq_id ,2);
2198: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after update :Op Seq # : ' || d_op_seq_num || ' Cfg Rtg Id : ' ||d_cfg_rtg_id ,2);
2199: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after update :Op Typ : ' || d_op_type || ' Op Effective Dt : ' ||d_op_effective_dt ,2);
2200: END IF;
2201: end loop;

Line 2198: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after update :Op Seq # : ' || d_op_seq_num || ' Cfg Rtg Id : ' ||d_cfg_rtg_id ,2);

2194: exit when bos_temp%notfound;
2195:
2196: IF PG_DEBUG <> 0 THEN
2197: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after update :Op Seq Id : ' || d_op_seq_id || ' Rtg Seq Id : ' ||d_rtg_seq_id ,2);
2198: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after update :Op Seq # : ' || d_op_seq_num || ' Cfg Rtg Id : ' ||d_cfg_rtg_id ,2);
2199: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after update :Op Typ : ' || d_op_type || ' Op Effective Dt : ' ||d_op_effective_dt ,2);
2200: END IF;
2201: end loop;
2202: close bos_temp;

Line 2199: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after update :Op Typ : ' || d_op_type || ' Op Effective Dt : ' ||d_op_effective_dt ,2);

2195:
2196: IF PG_DEBUG <> 0 THEN
2197: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after update :Op Seq Id : ' || d_op_seq_id || ' Rtg Seq Id : ' ||d_rtg_seq_id ,2);
2198: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after update :Op Seq # : ' || d_op_seq_num || ' Cfg Rtg Id : ' ||d_cfg_rtg_id ,2);
2199: oe_debug_pub.add ('create_routing_ml: ' || ' Temp table after update :Op Typ : ' || d_op_type || ' Op Effective Dt : ' ||d_op_effective_dt ,2);
2200: END IF;
2201: end loop;
2202: close bos_temp;
2203: /*-------------------------+

Line 2218: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_sequences - 2nd insert ..',5);

2214:
2215: lStmtNum := 90;
2216:
2217: IF PG_DEBUG <> 0 THEN
2218: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_sequences - 2nd insert ..',5);
2219: END IF;
2220:
2221: insert into bom_operation_sequences
2222: (

Line 2356: oe_debug_pub.add ('create_routing_ml: ' || ' Inserted ' || sql%rowcount || 'Records ',2 );

2352: and nvl(bos1.operation_type,1) = nvl(os1.operation_type,1));
2353:
2354: -- 3093686
2355: IF PG_DEBUG <> 0 THEN
2356: oe_debug_pub.add ('create_routing_ml: ' || ' Inserted ' || sql%rowcount || 'Records ',2 );
2357: END IF;
2358:
2359:
2360: -- New update of 3180827

Line 2440: oe_debug_pub.add ('create_routing_ml: ' || 'No operations were copied, config routing deleted. ',2);

2436: and b1.routing_sequence_id = lCfgRtgId;
2437:
2438: if sql%rowcount > 0 then
2439: IF PG_DEBUG <> 0 THEN
2440: oe_debug_pub.add ('create_routing_ml: ' || 'No operations were copied, config routing deleted. ',2);
2441: END IF;
2442: return(1);
2443: end if;
2444:

Line 2477: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into mtl_rtg_item_revisions..',5);

2473: lStmtNum := 70;
2474: xTableName := 'MTL_RTG_ITEM_REVISIONS';
2475:
2476: IF PG_DEBUG <> 0 THEN
2477: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into mtl_rtg_item_revisions..',5);
2478: END IF;
2479: insert into MTL_RTG_ITEM_REVISIONS
2480: (
2481: inventory_item_id,

Line 2555: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_resources..',5);

2551: xTableName := 'BOM_OPERATION_RESOURCES';
2552: lStmtNum := 150;
2553:
2554: IF PG_DEBUG <> 0 THEN
2555: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_resources..',5);
2556: END IF;
2557:
2558: insert into BOM_OPERATION_RESOURCES
2559: (

Line 2660: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_sub_operation_resources ..',5);

2656: xTableName := 'BOM_SUB_OPERATION_RESOURCES';
2657: lStmtNum := 155;
2658:
2659: IF PG_DEBUG <> 0 THEN
2660: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_sub_operation_resources ..',5);
2661: END IF;
2662:
2663: insert into BOM_SUB_OPERATION_RESOURCES
2664: (operation_sequence_id,

Line 2767: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_networks ..',5);

2763: lStmtNum := 380;
2764: xTableName := 'BOM_OPERATION_NETWORKS';
2765:
2766: IF PG_DEBUG <> 0 THEN
2767: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_networks ..',5);
2768: END IF;
2769:
2770: INSERT INTO bom_operation_networks
2771: ( FROM_OP_SEQ_ID,

Line 2856: oe_debug_pub.add ('create_routing_ml: ' || xTableName || '-'|| lStmtNum || ': ' || sql%rowcount,2 );

2852: and bor.cfm_routing_flag = 1
2853: and bor.alternate_routing_designator is null );
2854:
2855: IF PG_DEBUG <> 0 THEN
2856: oe_debug_pub.add ('create_routing_ml: ' || xTableName || '-'|| lStmtNum || ': ' || sql%rowcount,2 );
2857: END IF;
2858:
2859: lstmtNum := 390;
2860:

Line 2874: oe_debug_pub.add ('create_routing_ml: Copying the attachment on routing header.', 2);

2870: -- Begin Bugfix 8778162: Copy the attachment on routing header from model
2871: -- to config.
2872: lstmtNum := 395;
2873: IF PG_DEBUG <> 0 THEN
2874: oe_debug_pub.add ('create_routing_ml: Copying the attachment on routing header.', 2);
2875: oe_debug_pub.add ('create_routing_ml: Model routing_sequence_id:' || lItmRtgId, 2);
2876: END IF;
2877:
2878: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(

Line 2875: oe_debug_pub.add ('create_routing_ml: Model routing_sequence_id:' || lItmRtgId, 2);

2871: -- to config.
2872: lstmtNum := 395;
2873: IF PG_DEBUG <> 0 THEN
2874: oe_debug_pub.add ('create_routing_ml: Copying the attachment on routing header.', 2);
2875: oe_debug_pub.add ('create_routing_ml: Model routing_sequence_id:' || lItmRtgId, 2);
2876: END IF;
2877:
2878: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
2879: X_from_entity_name =>'BOM_OPERATIONAL_ROUTINGS',

Line 2992: oe_debug_pub.add('create_routing_ml: ' || 'serial_number_control_code of model is '||l_ser_code , 4);

2988: where inventory_item_id = pModelId
2989: and organization_id =pOrgId;
2990:
2991: IF PG_DEBUG <> 0 THEN
2992: oe_debug_pub.add('create_routing_ml: ' || 'serial_number_control_code of model is '||l_ser_code , 4);
2993: END IF;
2994:
2995: if ( l_ser_code = 2) then --serialized ,pre-defined
2996:

Line 3000: oe_debug_pub.add('create_routing_ml: ' || 'select serial start op from model ' , 4);

2996:
2997: lstmtNum := 412;
2998:
2999: IF PG_DEBUG <> 0 THEN
3000: oe_debug_pub.add('create_routing_ml: ' || 'select serial start op from model ' , 4);
3001: END IF;
3002:
3003:
3004: BEGIN

Line 3024: oe_debug_pub.add('create_routing_ml: ' || 'l_ser_start_op ie serialization_start_op from model is '|| l_ser_start_op, 4);

3020: l_ser_start_op := NULL;
3021: END;
3022:
3023: IF PG_DEBUG <> 0 THEN
3024: oe_debug_pub.add('create_routing_ml: ' || 'l_ser_start_op ie serialization_start_op from model is '|| l_ser_start_op, 4);
3025: END IF;
3026:
3027: if(l_ser_start_op is null)then
3028:

Line 3031: oe_debug_pub.add('create_routing_ml: ' || 'before updating config routing with serial start op of option class', 4);

3027: if(l_ser_start_op is null)then
3028:
3029: lstmtNum := 413;
3030: IF PG_DEBUG <> 0 THEN
3031: oe_debug_pub.add('create_routing_ml: ' || 'before updating config routing with serial start op of option class', 4);
3032: END IF;
3033:
3034: begin
3035: update bom_operational_routings

Line 3062: oe_debug_pub.add('create_routing_ml: ' || 'No option classes chosen while creating coonfiguration ', 4);

3058: exception
3059: when no_data_found then
3060:
3061: IF PG_DEBUG <> 0 THEN
3062: oe_debug_pub.add('create_routing_ml: ' || 'No option classes chosen while creating coonfiguration ', 4);
3063: END IF;
3064:
3065: end;
3066:

Line 3068: oe_debug_pub.add('create_routing_ml: ' || 'no# config rows rows updated with OC serial start opseq->'||l_row_count, 4);

3064:
3065: end;
3066:
3067: IF PG_DEBUG <> 0 THEN
3068: oe_debug_pub.add('create_routing_ml: ' || 'no# config rows rows updated with OC serial start opseq->'||l_row_count, 4);
3069: END IF;
3070:
3071: else --model has serial start op seq
3072:

Line 3079: oe_debug_pub.add('create_routing_ml: ' || 'updated with serial start op of model, serial start op =>'||l_ser_start_op , 4);

3075: set serialization_start_op = l_ser_start_op
3076: where routing_sequence_id = lCfgRtgId ;
3077:
3078: IF PG_DEBUG <> 0 THEN
3079: oe_debug_pub.add('create_routing_ml: ' || 'updated with serial start op of model, serial start op =>'||l_ser_start_op , 4);
3080: END IF;
3081: end if;--l_ser_start_op
3082: end if;--l_ser_code
3083: end if;

Line 3096: oe_debug_pub.add('create_routing_ml: ' || xErrorMessage, 1);

3092: xErrorMessage := 'CTOCRTGB:'||to_char(lStmtNum)||'raised NDF ';
3093: xMessageName := 'CTO_CREATE_ROUTING_ERROR';
3094: xRtgId := 0;
3095: IF PG_DEBUG <> 0 THEN
3096: oe_debug_pub.add('create_routing_ml: ' || xErrorMessage, 1);
3097: END IF;
3098: return(0);
3099:
3100: when FND_API.G_EXC_ERROR then

Line 3106: oe_debug_pub.add('create_routing_ml: ' || xErrorMessage, 1);

3102: xErrorMessage := 'CTOCRTGB:'||to_char(lStmtNum)||' raised expected error.';
3103: xMessageName := 'CTO_CREATE_ROUTING_ERROR';
3104: xRtgId := 0;
3105: IF PG_DEBUG <> 0 THEN
3106: oe_debug_pub.add('create_routing_ml: ' || xErrorMessage, 1);
3107: END IF;
3108: return(0);
3109:
3110: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 3116: oe_debug_pub.add('create_routing_ml: ' || xErrorMessage, 1);

3112: xErrorMessage := 'CTOCRTGB:'||to_char(lStmtNum)||' raised unexpected error.';
3113: xMessageName := 'CTO_CREATE_ROUTING_ERROR';
3114: xRtgId := 0;
3115: IF PG_DEBUG <> 0 THEN
3116: oe_debug_pub.add('create_routing_ml: ' || xErrorMessage, 1);
3117: END IF;
3118: return(0);
3119:
3120: when others then

Line 3124: oe_debug_pub.add ('create_routing_ml: ' || xErrorMessage, 1);

3120: when others then
3121: xErrorMessage := 'CTOCRTGB:'||to_char(lStmtNum)||'raised OTHERS exception.';
3122: xMessageName := 'CTO_CREATE_ROUTING_ERROR';
3123: IF PG_DEBUG <> 0 THEN
3124: oe_debug_pub.add ('create_routing_ml: ' || xErrorMessage, 1);
3125:
3126: oe_debug_pub.add ('create_routing_ml: ' || 'Error Message : '||sqlerrm);
3127: END IF;
3128: return(0);

Line 3126: oe_debug_pub.add ('create_routing_ml: ' || 'Error Message : '||sqlerrm);

3122: xMessageName := 'CTO_CREATE_ROUTING_ERROR';
3123: IF PG_DEBUG <> 0 THEN
3124: oe_debug_pub.add ('create_routing_ml: ' || xErrorMessage, 1);
3125:
3126: oe_debug_pub.add ('create_routing_ml: ' || 'Error Message : '||sqlerrm);
3127: END IF;
3128: return(0);
3129:
3130: END create_routing_ml;