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 313: oe_debug_pub.add ('create_routing_ml: ' || 'Config Routing' || lCfgRtgId || ' Already Exists ',1);

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

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

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

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

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

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

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

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

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

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

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

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

455: raise FND_API.G_EXC_ERROR;
456: end if;
457:
458: IF PG_DEBUG <> 0 THEN
459: oe_debug_pub.add('create_routing_ml: ' || 'Validation Org is :' || lOEValidationOrg,2);
460: END IF;
461:
462:
463: lStmtNum := 11;

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

469: from bom_cto_order_lines bcol
470: where bcol.line_id = lParentAtoLineId;
471:
472: IF PG_DEBUG <> 0 THEN
473: oe_debug_pub.add('create_routing_ml: ' || 'lLineId: ' || to_char(lLineId), 2);
474:
475: oe_debug_pub.add('create_routing_ml: ' || 'lModelId: ' || to_char(lModelId), 2);
476:
477: oe_debug_pub.add('create_routing_ml: ' || 'lParentAtoLineId: ' || to_char(lParentAtoLineId), 2);

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

471:
472: IF PG_DEBUG <> 0 THEN
473: oe_debug_pub.add('create_routing_ml: ' || 'lLineId: ' || to_char(lLineId), 2);
474:
475: oe_debug_pub.add('create_routing_ml: ' || 'lModelId: ' || to_char(lModelId), 2);
476:
477: oe_debug_pub.add('create_routing_ml: ' || 'lParentAtoLineId: ' || to_char(lParentAtoLineId), 2);
478: END IF;
479:

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

473: oe_debug_pub.add('create_routing_ml: ' || 'lLineId: ' || to_char(lLineId), 2);
474:
475: oe_debug_pub.add('create_routing_ml: ' || 'lModelId: ' || to_char(lModelId), 2);
476:
477: oe_debug_pub.add('create_routing_ml: ' || 'lParentAtoLineId: ' || to_char(lParentAtoLineId), 2);
478: END IF;
479:
480: lStmtNum := 12;
481: lStatus := CTO_CONFIG_BOM_PK.get_model_lead_time(

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

486: pErrBuf => lErrBuf);
487:
488: if (lStatus = 0) then
489: IF PG_DEBUG <> 0 THEN
490: oe_debug_pub.add('create_routing_ml: ' || 'Failed in get_model_lead_time.', 1);
491: END IF;
492: return 0;
493:
494: else

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

500:
501: end loop;
502:
503: IF PG_DEBUG <> 0 THEN
504: oe_debug_pub.add('create_routing_ml: ' || 'Total lead time is: ' || to_char(lTotLeadTime), 2);
505: END IF;
506:
507: xTableName := 'OE_ORDER_LINES ';
508: lStmtNum := 13;

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

528: and cal2.exception_set_id = mp.calendar_exception_set_id
529: and cal2.calendar_date = trunc(bcol.schedule_ship_date));
530:
531: IF PG_DEBUG <> 0 THEN
532: oe_debug_pub.add ('create_routing_ml: ' || 'Estimated Release Date is : ' || to_char(lEstRelDate,'dd-mon-yy::hh24:mi:ss'), 2);
533: END IF;
534:
535:
536: /*---------------------------------------------------------------+

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

550: lStmtNum := 30;
551:
552:
553: IF PG_DEBUG <> 0 THEN
554: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting the routing header information into bom_operational_routings..',5);
555: END IF;
556: insert into bom_operational_routings
557: (
558: routing_sequence_id,

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

651: and bor.alternate_routing_designator is null
652: and mp.organization_id = pOrgId;
653:
654: IF PG_DEBUG <> 0 THEN
655: oe_debug_pub.add ('create_routing_ml: ' || 'Inserted Routing Header :' || lCfgRtgId,2 );
656: END IF;
657:
658: /*---------------------------------------------------------------+
659: Udpate the mixed_model_map_flag. If the cfm_routing_flag

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

868: )
869: );
870:
871: If PG_DEBUG <> 0 Then
872: oe_debug_pub.add('Number of Model option independent operations selected = '||sql%rowcount,1);
873: End if;
874:
875: --2nd insert
876: lStmtNum := 52;

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

1082: and operation_sequence_id not in(select operation_sequence_id
1083: from bom_operation_sequences_temp);
1084:
1085: If PG_DEBUG <> 0 Then
1086: oe_debug_pub.add('Number of Model option dependent operations selected = '||sql%rowcount,1);
1087: End if;
1088: --3rdnd insert
1089: lStmtNum := 53;
1090: insert into bom_operation_sequences_temp

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

1271:
1272:
1273:
1274: If PG_DEBUG <> 0 Then
1275: oe_debug_pub.add('Number of Model mandatory independent operations selected = '||sql%rowcount,1);
1276: End if;
1277:
1278: IF PG_DEBUG <> 0 THEN
1279: oe_debug_pub.add ('create_routing_ml: ' || ' Model Routing : Inserted ' || sql%rowcount || ' records in temp table',2 );

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

1275: oe_debug_pub.add('Number of Model mandatory independent operations selected = '||sql%rowcount,1);
1276: End if;
1277:
1278: IF PG_DEBUG <> 0 THEN
1279: oe_debug_pub.add ('create_routing_ml: ' || ' Model Routing : Inserted ' || sql%rowcount || ' records in temp table',2 );
1280: END IF;
1281:
1282: IF PG_DEBUG <> 0 THEN
1283: open bos_temp(lCfgRtgId);

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

1284:
1285: loop
1286: fetch bos_temp into d_op_seq_id,d_rtg_seq_id,d_op_seq_num,d_cfg_rtg_id;
1287: exit when bos_temp%notfound;
1288: oe_debug_pub.add ('create_routing_ml: ' || 'TempTable after insert :Op Seq Id: ' || d_op_seq_id
1289: || 'Rtg Seq Id: ' ||d_rtg_seq_id
1290: || 'Op Seq #: ' || d_op_seq_num
1291: || 'Cfg Rtg Id: ' ||d_cfg_rtg_id ,2);
1292: end loop;

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

1314: fetch get_op_seq_num into lmodseqnum,lmodtyp;
1315: exit when get_op_seq_num%notfound;
1316:
1317: IF PG_DEBUG <> 0 THEN
1318: oe_debug_pub.add ('create_routing_ml: ' || ' Op Seq # : ' || lmodseqnum || ' Op Type : ' || lmodtyp ,2);
1319: oe_debug_pub.add ('create_routing_ml: ' || 'Esitmated release date lEstRelDate '|| to_char(lEstRelDate,'mm-dd-yy:hh:mi:ss'),2 );
1320: END IF;
1321:
1322: select max(routing_sequence_id) into lmodrtgseqid

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

1315: exit when get_op_seq_num%notfound;
1316:
1317: IF PG_DEBUG <> 0 THEN
1318: oe_debug_pub.add ('create_routing_ml: ' || ' Op Seq # : ' || lmodseqnum || ' Op Type : ' || lmodtyp ,2);
1319: oe_debug_pub.add ('create_routing_ml: ' || 'Esitmated release date lEstRelDate '|| to_char(lEstRelDate,'mm-dd-yy:hh:mi:ss'),2 );
1320: END IF;
1321:
1322: select max(routing_sequence_id) into lmodrtgseqid
1323: from bom_operation_sequences_temp -- 5336292

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

1326: and config_routing_id = lCfgRtgId -- bugfix 3239267: replaced last_update_login
1327: and last_update_date = glast_update_date; -- 3180827
1328:
1329: IF PG_DEBUG <> 0 THEN
1330: oe_debug_pub.add ('create_routing_ml: ' || ' Max. Routing Seq Id : ' || lmodrtgseqid,2);
1331: END IF;
1332:
1333: update bom_operation_sequences_temp -- 5336292
1334: set config_routing_id = lmodnewCfgRtgId -- bugfix 3239267: replaced last_update_login

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

1349: and ( disable_date is null or (disable_date is not null and disable_date >= sysdate ));
1350: /* Bugfix 2177101/2143014 */
1351:
1352: IF PG_DEBUG <> 0 THEN
1353: oe_debug_pub.add ('create_routing_ml: ' || 'Update login to ' || lmodnewCfgRtgId ||' where routing seq Id is '||lmodrtgseqid,2);
1354: END IF;
1355:
1356: end loop;
1357:

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

1357:
1358: close get_op_seq_num;
1359:
1360: IF PG_DEBUG <> 0 THEN
1361: oe_debug_pub.add ('create_routing_ml: ' || ' Model Routing : Marked Finally ' || sql%rowcount || ' rows for insertion' ,2);
1362: END IF;
1363: IF PG_DEBUG <> 0 THEN
1364:
1365: open bos_temp(lmodnewCfgRtgId);

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

1366:
1367: loop
1368: fetch bos_temp into d_op_seq_id,d_rtg_seq_id,d_op_seq_num,d_cfg_rtg_id;
1369: exit when bos_temp%notfound;
1370: oe_debug_pub.add ('create_routing_ml: ' || ' TempTable after update :Op Seq Id: ' || d_op_seq_id
1371: || 'Rtg Seq Id: ' ||d_rtg_seq_id
1372: || 'Op Seq# : ' || d_op_seq_num
1373: || 'Cfg Rtg Id: ' ||d_cfg_rtg_id ,2);
1374: end loop;

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

1387:
1388: lStmtNum := 60;
1389:
1390: IF PG_DEBUG <> 0 THEN
1391: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_sequences - 1st insert ..',5);
1392: END IF;
1393:
1394: insert into bom_operation_sequences
1395: (

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

1512:
1513:
1514:
1515: IF PG_DEBUG <> 0 THEN
1516: oe_debug_pub.add('create_routing_ml: ' || 'Inserted ' || sql%rowcount || ' rows in BOS',2);
1517: END IF;
1518:
1519:
1520: /*--------------------------------------------------------------+

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

1527: delete from bom_operation_sequences_temp
1528: where config_routing_id in (lCfgRtgId, lmodnewcfgrtgid);
1529:
1530: IF PG_DEBUG <> 0 THEN
1531: oe_debug_pub.add('create_routing_ml: ' || 'Deleted ' || sql%rowcount || ' rows from temp table',2);
1532: -- bugfix 3239267: replaced last_update_login
1533: END IF;
1534:
1535:

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

1720: )
1721: );
1722:
1723: If PG_DEBUG <> 0 Then
1724: oe_debug_pub.add('Number of option class option independent operations selected = '||sql%rowcount,1);
1725: End if;
1726: --2nd insert
1727: lStmtNum := 82;
1728:

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

1927: from bom_operation_sequences_temp);
1928:
1929:
1930: If PG_DEBUG <> 0 Then
1931: oe_debug_pub.add('Number of option class option dependent operations selected = '||sql%rowcount,1);
1932: End if;
1933: --3rd insert
1934: lStmtNum := 83;
1935:

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

2117: and operation_sequence_id not in(select operation_sequence_id
2118: from bom_operation_sequences_temp);
2119:
2120: If PG_DEBUG <> 0 Then
2121: oe_debug_pub.add('Number of option class mandatory comps dependent operations selected = '||sql%rowcount,1);
2122: End if;
2123:
2124:
2125: lStmtNum := 84;

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

2123:
2124:
2125: lStmtNum := 84;
2126: IF PG_DEBUG <> 0 THEN
2127: oe_debug_pub.add ('create_routing_ml: ' || ' Option Class outing : Inserted ' || sql%rowcount || ' records in temp table',2 );
2128: END IF;
2129:
2130: open bos_temp(lCfgRtgId);
2131:

Line 2137: 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);

2133: fetch bos_temp into d_op_seq_id,d_rtg_seq_id,d_op_seq_num,d_cfg_rtg_id;
2134: exit when bos_temp%notfound;
2135:
2136: IF PG_DEBUG <> 0 THEN
2137: 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);
2138: 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);
2139: END IF;
2140: end loop;
2141: close bos_temp;

Line 2138: 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);

2134: exit when bos_temp%notfound;
2135:
2136: IF PG_DEBUG <> 0 THEN
2137: 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);
2138: 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);
2139: END IF;
2140: end loop;
2141: close bos_temp;
2142:

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

2157: fetch get_op_seq_num into lopseqnum,loptyp;
2158: exit when get_op_seq_num%notfound;
2159:
2160: IF PG_DEBUG <> 0 THEN
2161: oe_debug_pub.add ('create_routing_ml: ' || ' Op Seq # : ' || lopseqnum || ' Op Type : ' || loptyp ,2);
2162: END IF;
2163:
2164: select max(routing_sequence_id) into lrtgseqid
2165: from bom_operation_sequences_temp -- 5336292

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

2169: and last_update_date = glast_update_date; -- 3180827
2170:
2171:
2172: IF PG_DEBUG <> 0 THEN
2173: oe_debug_pub.add ('create_routing_ml: ' || ' Max. Routing Seq Id : ' || lrtgseqid,2);
2174: END IF;
2175:
2176: update bom_operation_sequences_temp -- 5336292
2177: set config_routing_id = lnewCfgRtgId -- bugfix 3239267: replaced last_update_login

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

2192: and ( disable_date is null or (disable_date is not null and disable_date >= sysdate ));
2193: /* Bugfix 2177101/2143014 */
2194:
2195: IF PG_DEBUG <> 0 THEN
2196: oe_debug_pub.add ('create_routing_ml: ' || 'Update login to ' || lnewCfgRtgId ||' where routing seq Id is '||lrtgseqid,2);
2197: END IF;
2198:
2199: end loop;
2200:

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

2200:
2201: close get_op_seq_num;
2202:
2203: IF PG_DEBUG <> 0 THEN
2204: oe_debug_pub.add ('create_routing_ml: ' || ' Option Routing : Marked Finally ' || sql%rowcount || ' rows for insertion' ,2);
2205: END IF;
2206:
2207: open bos_temp(lnewCfgRtgId);
2208:

Line 2214: 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);

2210: fetch bos_temp into d_op_seq_id,d_rtg_seq_id,d_op_seq_num,d_cfg_rtg_id;
2211: exit when bos_temp%notfound;
2212:
2213: IF PG_DEBUG <> 0 THEN
2214: 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);
2215: 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);
2216: END IF;
2217: end loop;
2218: close bos_temp;

Line 2215: 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);

2211: exit when bos_temp%notfound;
2212:
2213: IF PG_DEBUG <> 0 THEN
2214: 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);
2215: 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);
2216: END IF;
2217: end loop;
2218: close bos_temp;
2219: /*-------------------------+

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

2230:
2231: lStmtNum := 90;
2232:
2233: IF PG_DEBUG <> 0 THEN
2234: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_sequences - 2nd insert ..',5);
2235: END IF;
2236:
2237: insert into bom_operation_sequences
2238: (

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

2360: and nvl(bos1.operation_type,1) = nvl(os1.operation_type,1));
2361:
2362: -- 3093686
2363: IF PG_DEBUG <> 0 THEN
2364: oe_debug_pub.add ('create_routing_ml: ' || ' Inserted ' || sql%rowcount || 'Records ',2 );
2365: END IF;
2366:
2367:
2368: -- New update of 3180827

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

2445: and b1.routing_sequence_id = lCfgRtgId;
2446:
2447: if sql%rowcount > 0 then
2448: IF PG_DEBUG <> 0 THEN
2449: oe_debug_pub.add ('create_routing_ml: ' || 'No operations were copied, config routing deleted. ',2);
2450: END IF;
2451: return(1);
2452: end if;
2453:

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

2482: lStmtNum := 70;
2483: xTableName := 'MTL_RTG_ITEM_REVISIONS';
2484:
2485: IF PG_DEBUG <> 0 THEN
2486: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into mtl_rtg_item_revisions..',5);
2487: END IF;
2488: insert into MTL_RTG_ITEM_REVISIONS
2489: (
2490: inventory_item_id,

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

2560: xTableName := 'BOM_OPERATION_RESOURCES';
2561: lStmtNum := 150;
2562:
2563: IF PG_DEBUG <> 0 THEN
2564: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_resources..',5);
2565: END IF;
2566: insert into BOM_OPERATION_RESOURCES
2567: (
2568: operation_sequence_id,

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

2666: xTableName := 'BOM_SUB_OPERATION_RESOURCES';
2667: lStmtNum := 155;
2668:
2669: IF PG_DEBUG <> 0 THEN
2670: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_sub_operation_resources ..',5);
2671: END IF;
2672: insert into BOM_SUB_OPERATION_RESOURCES
2673: (operation_sequence_id,
2674: substitute_group_num,

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

2772: lStmtNum := 380;
2773: xTableName := 'BOM_OPERATION_NETWORKS';
2774:
2775: IF PG_DEBUG <> 0 THEN
2776: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_networks ..',5);
2777: END IF;
2778: INSERT INTO bom_operation_networks
2779: ( FROM_OP_SEQ_ID,
2780: TO_OP_SEQ_ID,

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

2861: and bor.alternate_routing_designator is null );
2862:
2863:
2864: IF PG_DEBUG <> 0 THEN
2865: oe_debug_pub.add ('create_routing_ml: ' || xTableName || '-'|| lStmtNum || ': ' || sql%rowcount,2 );
2866: END IF;
2867:
2868: lstmtNum := 390;
2869:

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

2968: where inventory_item_id = pModelId
2969: and organization_id =pOrgId;
2970:
2971: IF PG_DEBUG <> 0 THEN
2972: oe_debug_pub.add('create_routing_ml: ' || 'serial_number_control_code of model is '||l_ser_code , 4);
2973: END IF;
2974:
2975: if ( l_ser_code = 2) then --serialized ,pre-defined
2976:

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

2976:
2977: lstmtNum := 412;
2978:
2979: IF PG_DEBUG <> 0 THEN
2980: oe_debug_pub.add('create_routing_ml: ' || 'select serial start op from model ' , 4);
2981: END IF;
2982:
2983:
2984: BEGIN

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

3000: l_ser_start_op := NULL;
3001: END;
3002:
3003: IF PG_DEBUG <> 0 THEN
3004: oe_debug_pub.add('create_routing_ml: ' || 'l_ser_start_op ie serialization_start_op from model is '|| l_ser_start_op, 4);
3005: END IF;
3006:
3007: if(l_ser_start_op is null)then
3008:

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

3007: if(l_ser_start_op is null)then
3008:
3009: lstmtNum := 413;
3010: IF PG_DEBUG <> 0 THEN
3011: oe_debug_pub.add('create_routing_ml: ' || 'before updating config routing with serial start op of option class', 4);
3012: END IF;
3013:
3014: begin
3015: update bom_operational_routings

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

3038: exception
3039: when no_data_found then
3040:
3041: IF PG_DEBUG <> 0 THEN
3042: oe_debug_pub.add('create_routing_ml: ' || 'No option classes chosen while creating coonfiguration ', 4);
3043: END IF;
3044:
3045: end;
3046:

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

3044:
3045: end;
3046:
3047: IF PG_DEBUG <> 0 THEN
3048: oe_debug_pub.add('create_routing_ml: ' || 'no# config rows rows updated with OC serial start opseq->'||l_row_count, 4);
3049: END IF;
3050:
3051: else --model has serial start op seq
3052:

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

3055: set serialization_start_op = l_ser_start_op
3056: where routing_sequence_id = lCfgRtgId ;
3057:
3058: IF PG_DEBUG <> 0 THEN
3059: oe_debug_pub.add('create_routing_ml: ' || 'updated with serial start op of model, serial start op =>'||l_ser_start_op , 4);
3060: END IF;
3061:
3062:
3063: end if;--l_ser_start_op

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

3078: xErrorMessage := 'CTOCRTGB:'||to_char(lStmtNum)||'raised NDF ';
3079: xMessageName := 'CTO_CREATE_ROUTING_ERROR';
3080: xRtgId := 0;
3081: IF PG_DEBUG <> 0 THEN
3082: oe_debug_pub.add('create_routing_ml: ' || xErrorMessage, 1);
3083: END IF;
3084: return(0);
3085:
3086: when FND_API.G_EXC_ERROR then

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

3088: xErrorMessage := 'CTOCRTGB:'||to_char(lStmtNum)||' raised expected error.';
3089: xMessageName := 'CTO_CREATE_ROUTING_ERROR';
3090: xRtgId := 0;
3091: IF PG_DEBUG <> 0 THEN
3092: oe_debug_pub.add('create_routing_ml: ' || xErrorMessage, 1);
3093: END IF;
3094: return(0);
3095:
3096: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

3098: xErrorMessage := 'CTOCRTGB:'||to_char(lStmtNum)||' raised unexpected error.';
3099: xMessageName := 'CTO_CREATE_ROUTING_ERROR';
3100: xRtgId := 0;
3101: IF PG_DEBUG <> 0 THEN
3102: oe_debug_pub.add('create_routing_ml: ' || xErrorMessage, 1);
3103: END IF;
3104: return(0);
3105:
3106: when others then

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

3106: when others then
3107: xErrorMessage := 'CTOCRTGB:'||to_char(lStmtNum)||'raised OTHERS exception.';
3108: xMessageName := 'CTO_CREATE_ROUTING_ERROR';
3109: IF PG_DEBUG <> 0 THEN
3110: oe_debug_pub.add ('create_routing_ml: ' || xErrorMessage, 1);
3111:
3112: oe_debug_pub.add ('create_routing_ml: ' || 'Error Message : '||sqlerrm);
3113: END IF;
3114: return(0);

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

3108: xMessageName := 'CTO_CREATE_ROUTING_ERROR';
3109: IF PG_DEBUG <> 0 THEN
3110: oe_debug_pub.add ('create_routing_ml: ' || xErrorMessage, 1);
3111:
3112: oe_debug_pub.add ('create_routing_ml: ' || 'Error Message : '||sqlerrm);
3113: END IF;
3114: return(0);
3115:
3116: END create_routing_ml;