[Home] [Help]
201:
202: BEGIN
203:
204: IF PG_DEBUG <> 0 THEN
205: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::pTopAtoLineId::'||to_char(pTopAtoLineId),1);
206: END IF;
207:
208: --
209: -- For each model item in all possible receiving orgs, call
211: --
212:
213: lStmtNumber := 20;
214: IF PG_DEBUG <> 0 THEN
215: oe_debug_pub.add('populate_plan_level: ' || 'before loop',2);
216: END IF;
217:
218:
219: FOR v_model_lines IN c_model_lines LOOP
220:
221: if( v_model_lines.config_creation in ( 1, 2 ) ) then
222:
223: IF PG_DEBUG <> 0 THEN
224: oe_debug_pub.add('populate_plan_level: ' || 'loop::item::'||to_char(v_model_lines.inventory_item_id)||
225: '::line_id::'||to_char(v_model_lines.line_id),2);
226: END IF;
227: lStmtNumber := 30;
228:
227: lStmtNumber := 30;
228:
229: IF v_model_lines.ato_line_id = v_model_lines.line_id THEN
230: IF PG_DEBUG <> 0 THEN
231: oe_debug_pub.add('populate_plan_level: ' || 'ato_line_id = line_id',2);
232: END IF;
233:
234:
235: lStmtNumber := 40;
239: where line_id = v_model_lines.line_id;
240:
241: lStmtNumber := 50;
242: IF PG_DEBUG <> 0 THEN
243: oe_debug_pub.add('populate_plan_level: ' || 'before calling GAIO',2);
244:
245: oe_debug_pub.add('populate_plan_level: ' || 'line_id::'||to_char(v_model_lines.line_id)||
246: '::inv_id::'||to_char(v_model_lines.inventory_item_id)||
247: '::ship_from_org::'||to_char(lShipFromOrgId),2);
241: lStmtNumber := 50;
242: IF PG_DEBUG <> 0 THEN
243: oe_debug_pub.add('populate_plan_level: ' || 'before calling GAIO',2);
244:
245: oe_debug_pub.add('populate_plan_level: ' || 'line_id::'||to_char(v_model_lines.line_id)||
246: '::inv_id::'||to_char(v_model_lines.inventory_item_id)||
247: '::ship_from_org::'||to_char(lShipFromOrgId),2);
248: END IF;
249:
256: x_msg_data);
257:
258: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
259: IF PG_DEBUG <> 0 THEN
260: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
261: END IF;
262: raise FND_API.G_EXC_UNEXPECTED_ERROR;
263:
264: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
262: raise FND_API.G_EXC_UNEXPECTED_ERROR;
263:
264: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
265: IF PG_DEBUG <> 0 THEN
266: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
267: END IF;
268: raise FND_API.G_EXC_ERROR;
269: END IF;
270: IF PG_DEBUG <> 0 THEN
267: END IF;
268: raise FND_API.G_EXC_ERROR;
269: END IF;
270: IF PG_DEBUG <> 0 THEN
271: oe_debug_pub.add('populate_plan_level: ' || 'after calling GAIO::lStatus::'||to_char(lStatus),2);
272: END IF;
273: ELSE
274: IF PG_DEBUG <> 0 THEN
275: oe_debug_pub.add('populate_plan_level: ' || 'ato_line_id <> line_id',2);
271: oe_debug_pub.add('populate_plan_level: ' || 'after calling GAIO::lStatus::'||to_char(lStatus),2);
272: END IF;
273: ELSE
274: IF PG_DEBUG <> 0 THEN
275: oe_debug_pub.add('populate_plan_level: ' || 'ato_line_id <> line_id',2);
276: END IF;
277: lStmtNumber := 60;
278: lLineId := v_model_lines.line_id;
279: IF PG_DEBUG <> 0 THEN
276: END IF;
277: lStmtNumber := 60;
278: lLineId := v_model_lines.line_id;
279: IF PG_DEBUG <> 0 THEN
280: oe_debug_pub.add('populate_plan_level: ' || 'before PSO loop',2);
281: END IF;
282:
283: FOR v_parent_src_ogs IN c_parent_src_orgs LOOP
284: IF PG_DEBUG <> 0 THEN
281: END IF;
282:
283: FOR v_parent_src_ogs IN c_parent_src_orgs LOOP
284: IF PG_DEBUG <> 0 THEN
285: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::rcv org::'||
286: to_char(v_parent_src_ogs.organization_id),2);
287:
288: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::item id::'||
289: to_char(v_model_lines.inventory_item_id),2);
284: IF PG_DEBUG <> 0 THEN
285: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::rcv org::'||
286: to_char(v_parent_src_ogs.organization_id),2);
287:
288: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::item id::'||
289: to_char(v_model_lines.inventory_item_id),2);
290:
291: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::line id::'||
292: to_char(v_model_lines.line_id),2);
287:
288: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::item id::'||
289: to_char(v_model_lines.inventory_item_id),2);
290:
291: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::line id::'||
292: to_char(v_model_lines.line_id),2);
293: END IF;
294: lStmtNumber := 70;
295: lStatus := get_all_item_orgs(v_model_lines.line_id,
300: x_msg_data);
301:
302: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
303: IF PG_DEBUG <> 0 THEN
304: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
305: END IF;
306: raise FND_API.G_EXC_UNEXPECTED_ERROR;
307:
308: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
306: raise FND_API.G_EXC_UNEXPECTED_ERROR;
307:
308: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
309: IF PG_DEBUG <> 0 THEN
310: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
311: END IF;
312: raise FND_API.G_EXC_ERROR;
313: END IF;
314:
317:
318:
319: else
320:
321: oe_debug_pub.add( 'config creation 3 not yet implemented ' , 1) ;
322:
323:
324: oe_debug_pub.add( '$$$$$$$$ TYPE 3 model line ' || v_model_lines.line_id , 1 ) ;
325:
320:
321: oe_debug_pub.add( 'config creation 3 not yet implemented ' , 1) ;
322:
323:
324: oe_debug_pub.add( '$$$$$$$$ TYPE 3 model line ' || v_model_lines.line_id , 1 ) ;
325:
326:
327: if( v_model_lines.perform_match = 'N' ) then
328:
326:
327: if( v_model_lines.perform_match = 'N' ) then
328:
329:
330: oe_debug_pub.add( '$$$$$$$$ GOING TO CALL insert_type3_bcso ' || v_model_lines.line_id , 1 ) ;
331:
332: CTO_MSUTIL_PUB.insert_type3_bcso( pTopAtoLineId
333: , v_model_lines.line_id
334: , v_model_lines.inventory_item_id ) ;
335:
336: elsif( v_model_lines.perform_match in ( 'Y' , 'C' ) ) then
337:
338:
339: oe_debug_pub.add( '$$$$$$$$ GOING TO CALL insert_type3_referenced_bcso ' || v_model_lines.line_id , 1 ) ;
340:
341: CTO_MSUTIL_PUB.insert_type3_referenced_bcso( pTopAtoLineId
342: , v_model_lines.line_id
343: , v_model_lines.inventory_item_id
348:
349: elsif( v_model_lines.perform_match = 'U' ) then
350:
351:
352: oe_debug_pub.add( '$$$$$$$$ GOING TO CALL insert_type3_bcmo_bcso ' || v_model_lines.line_id , 1 ) ;
353:
354: CTO_MSUTIL_PUB.insert_type3_bcmo_bcso( pTopAtoLineId
355: , v_model_lines.line_id
356: , v_model_lines.inventory_item_id ) ;
367:
368:
369:
370:
371: oe_debug_pub.add( '$$$$$$$$$$$$Going to START GET OSS BOM ORGS for Create BOM Indication ' || to_char( v_model_lines.line_id ) , 1 ) ;
372: oe_debug_pub.add( '$$$$$$$$$$$$Going to START GET OSS BOM ORGS for Create BOM Indication ' || v_model_lines.option_specific , 1 ) ;
373:
374: if( v_model_lines.option_specific in ( '1' , '2', '3' ) ) then /* do not execute this code as we will be changing it tomorrow */
375:
368:
369:
370:
371: oe_debug_pub.add( '$$$$$$$$$$$$Going to START GET OSS BOM ORGS for Create BOM Indication ' || to_char( v_model_lines.line_id ) , 1 ) ;
372: oe_debug_pub.add( '$$$$$$$$$$$$Going to START GET OSS BOM ORGS for Create BOM Indication ' || v_model_lines.option_specific , 1 ) ;
373:
374: if( v_model_lines.option_specific in ( '1' , '2', '3' ) ) then /* do not execute this code as we will be changing it tomorrow */
375:
376: oe_debug_pub.add( 'Going to Call GET OSS BOM ORGS for Create BOM Indication ' || to_char( v_model_lines.line_id) , 1 ) ;
372: oe_debug_pub.add( '$$$$$$$$$$$$Going to START GET OSS BOM ORGS for Create BOM Indication ' || v_model_lines.option_specific , 1 ) ;
373:
374: if( v_model_lines.option_specific in ( '1' , '2', '3' ) ) then /* do not execute this code as we will be changing it tomorrow */
375:
376: oe_debug_pub.add( 'Going to Call GET OSS BOM ORGS for Create BOM Indication ' || to_char( v_model_lines.line_id) , 1 ) ;
377:
378:
379: cto_oss_source_pk.get_oss_bom_orgs( p_line_id => v_model_lines.line_id
380: ,x_orgs_list => v_orgs_list
389:
390: if x_return_status = FND_API.G_RET_STS_ERROR then
391:
392: IF PG_DEBUG <> 0 THEN
393: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
394: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with expected error.', 1);
395: END IF;
396:
397: raise FND_API.G_EXC_ERROR;
398:
399: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
400:
401: IF PG_DEBUG <> 0 THEN
402: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
403: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with unexpected error.', 1);
404: END IF;
405:
406: raise FND_API.G_EXC_UNEXPECTED_ERROR;
407:
408: end if;
409:
410: IF PG_DEBUG <> 0 THEN
411: oe_debug_pub.add('Create_And_Link_Item: ' || 'Ater Populate_Bcol', 5);
412: END IF;
413:
414:
415:
412: END IF;
413:
414:
415:
416: oe_debug_pub.add( 'OSS ORGS for Create BOM list size ' || v_orgs_list.count , 1 ) ;
417:
418: oe_debug_pub.add( 'OSS ORGS for Create BOM UPDATE ' , 1 ) ;
419:
420:
414:
415:
416: oe_debug_pub.add( 'OSS ORGS for Create BOM list size ' || v_orgs_list.count , 1 ) ;
417:
418: oe_debug_pub.add( 'OSS ORGS for Create BOM UPDATE ' , 1 ) ;
419:
420:
421: if( v_orgs_list.count > 0 ) then
422:
428:
429: update bom_cto_model_orgs set create_bom = 'N'
430: where group_reference_id = v_group_reference_id ;
431:
432: oe_debug_pub.add( 'UPDATED BCMO create_bom = N for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;
433: else
434:
435:
436: update bom_cto_src_orgs_b set create_bom = 'N'
435:
436: update bom_cto_src_orgs_b set create_bom = 'N'
437: where line_id = v_model_lines.line_id ;
438:
439: oe_debug_pub.add( 'UPDATED BCSO create_bom = N for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;
440:
441: end if;
442:
443:
444:
445: for i in 1..v_orgs_list.count
446: loop
447:
448: oe_debug_pub.add( 'OSS ORGS for Create BOM ' || v_orgs_list(i) , 1 ) ;
449:
450: if( v_model_lines.config_creation = 3 and v_model_lines.perform_match in ( 'Y', 'U' ) ) then
451:
452: select group_reference_id into v_group_reference_id from bom_cto_src_orgs_b
459: ( select 1 from bom_parameters
460: where organization_id = v_orgs_list(i)
461: and nvl(create_config_bom,'N') = 'Y' );
462:
463: oe_debug_pub.add( 'UPDATED BCMO create_bom = Y for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;
464:
465: else
466:
467:
472: ( select 1 from bom_parameters
473: where organization_id = v_orgs_list(i)
474: and nvl(create_config_bom,'N') = 'Y' );
475:
476: oe_debug_pub.add( 'UPDATED BCSO create_bom = Y for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;
477:
478: end if;
479:
480:
489:
490:
491:
492:
493: oe_debug_pub.add( '$$$$$$$$$$$$ DONE GET OSS BOM ORGS for Create BOM Indication ' || v_model_lines.line_id , 1 ) ;
494:
495:
496:
497:
499:
500: END LOOP;
501:
502: IF PG_DEBUG <> 0 THEN
503: oe_debug_pub.add('populate_plan_level: ' || 'end of loop',1);
504:
505: oe_debug_pub.add('populate_plan_level: ' || 'printing out bcso :', 2);
506:
507: oe_debug_pub.add('populate_plan_level: ' || 'line_id model_item_id rcv_org_id org_id create_bom create_src_rules organization_type group_reference_id ', 2);
501:
502: IF PG_DEBUG <> 0 THEN
503: oe_debug_pub.add('populate_plan_level: ' || 'end of loop',1);
504:
505: oe_debug_pub.add('populate_plan_level: ' || 'printing out bcso :', 2);
506:
507: oe_debug_pub.add('populate_plan_level: ' || 'line_id model_item_id rcv_org_id org_id create_bom create_src_rules organization_type group_reference_id ', 2);
508: END IF;
509:
503: oe_debug_pub.add('populate_plan_level: ' || 'end of loop',1);
504:
505: oe_debug_pub.add('populate_plan_level: ' || 'printing out bcso :', 2);
506:
507: oe_debug_pub.add('populate_plan_level: ' || 'line_id model_item_id rcv_org_id org_id create_bom create_src_rules organization_type group_reference_id ', 2);
508: END IF;
509:
510: FOR v_debug IN c_debug LOOP
511: IF PG_DEBUG <> 0 THEN
508: END IF;
509:
510: FOR v_debug IN c_debug LOOP
511: IF PG_DEBUG <> 0 THEN
512: oe_debug_pub.add('populate_plan_level: ' || to_char(v_debug.line_id)||' '||
513: to_char(v_debug.model_item_id)||' '||
514: nvl(to_char(v_debug.rcv_org_id),null)||' '||
515: to_char(v_debug.organization_id)||' '||
516: nvl(v_debug.create_bom, null)||' '||
523:
524:
525: /* make a call to get validation orgs and purchasing related orgs */
526:
527: oe_debug_pub.add( '$$$$$$$$ Additional Type 1 and 2 Processing ' , 1 ) ;
528:
529: open get_each_type1_model ;
530:
531: loop
533: fetch get_each_type1_model into v_current_model_line_id , v_current_model_item_id , v_config_creation ;
534:
535: exit when get_each_type1_model%notfound ;
536:
537: oe_debug_pub.add( '$$$$$$$$ calling ORg List for model line ' || v_current_model_line_id , 1 ) ;
538:
539: if( v_config_creation = 1) then
540:
541: oe_debug_pub.add( '$$$$$$$$ TYPE 1 model line ' || v_current_model_line_id , 1 ) ;
537: oe_debug_pub.add( '$$$$$$$$ calling ORg List for model line ' || v_current_model_line_id , 1 ) ;
538:
539: if( v_config_creation = 1) then
540:
541: oe_debug_pub.add( '$$$$$$$$ TYPE 1 model line ' || v_current_model_line_id , 1 ) ;
542:
543: CTO_MSUTIL_PUB.get_other_orgs( pmodellineid => v_current_model_line_id ,
544: xorglst => v_t_org_list ,
545: x_return_status => x_return_status ,
549: /* bugfix 4227127 fp for bug 4162642 :added return status check */
550: if x_return_status = FND_API.G_RET_STS_ERROR then
551:
552: if PG_DEBUG <> 0 then
553: oe_debug_pub.add( 'ERROR: get_other_orgs api return expected error' , 1 ) ;
554: end if;
555:
556: Raise FND_API.G_EXC_ERROR;
557:
557:
558: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
559:
560: if PG_DEBUG <> 0 then
561: oe_debug_pub.add( 'ERROR: get_other_orgs api return unexpected error' , 1 ) ;
562: end if;
563:
564: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
565:
566: end if;
567:
568:
569:
570: oe_debug_pub.add( '$$$$$$$$ ORg List for model line ' || v_current_model_line_id , 1 ) ;
571:
572:
573: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id, v_t_org_list ) ;
574:
572:
573: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id, v_t_org_list ) ;
574:
575:
576: oe_debug_pub.add( '$$$$$$$$ ORg List DONE for model line ' || v_current_model_line_id , 1 ) ;
577:
578: -- Added by Renga Kannan on 15-Sep-2005
579: -- Added for ATG performance Project
580:
587:
588: if x_return_status = FND_API.G_RET_STS_ERROR then
589:
590: if PG_DEBUG <> 0 then
591: oe_debug_pub.add( 'ERROR: get_Master_orgs api return expected error' , 1 ) ;
592: end if;
593:
594: Raise FND_API.G_EXC_ERROR;
595:
595:
596: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
597:
598: if PG_DEBUG <> 0 then
599: oe_debug_pub.add( 'ERROR: get_Master_orgs api return unexpected error' , 1 ) ;
600: end if;
601:
602: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
603:
610: End if;
611:
612: elsif( v_config_creation = 2 ) then
613:
614: oe_debug_pub.add( '$$$$$$$$ TYPE 2 model line ' || v_current_model_line_id , 1 ) ;
615:
616: CTO_MSUTIL_PUB.insert_all_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id ) ;
617:
618: end if;
624:
625:
626:
627:
628: oe_debug_pub.add( '$$$$$$$$ Going to update Create BOM flag for Shared Costing Organizations ' , 1 ) ;
629:
630: /*Update Create_BOM Flag for Shared Costing Organizations */
631: update bom_cto_src_orgs_b bcso_b1 set create_bom = 'Y'
632: where ( organization_id , line_id ) in ( select mp.cost_organization_id , bcso_b.line_id
643: and bp.create_config_bom = 'Y' ) ;
644:
645:
646:
647: oe_debug_pub.add( '$$$$$$$$ Create BOM flag updated for Shared Costing Organizations ' || to_char(sql%rowcount) , 1 ) ;
648:
649:
650:
651: /* print debug output for Shared Cost update */
651: /* print debug output for Shared Cost update */
652: if( sql%rowcount > 0 ) then
653: FOR v_debug IN c_debug LOOP
654: IF PG_DEBUG <> 0 THEN
655: oe_debug_pub.add('populate_plan_level: ' || to_char(v_debug.line_id)||' '||
656: to_char(v_debug.model_item_id)||' '||
657: nvl(to_char(v_debug.rcv_org_id),null)||' '||
658: to_char(v_debug.organization_id)||' '||
659: nvl(v_debug.create_bom, null)||' '||
672: EXCEPTION
673:
674: when FND_API.G_EXC_UNEXPECTED_ERROR then
675: IF PG_DEBUG <> 0 THEN
676: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::unexp error::'||lStmtNumber||sqlerrm,1);
677: END IF;
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: CTO_MSG_PUB.Count_And_Get
680: (p_msg_count => x_msg_count
683: return(0);
684:
685: when FND_API.G_EXC_ERROR then
686: IF PG_DEBUG <> 0 THEN
687: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::exp error::'||lStmtNumber||sqlerrm,1);
688: END IF;
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: CTO_MSG_PUB.Count_And_Get
691: (p_msg_count => x_msg_count
693: return(0);
694:
695: when others then
696: IF PG_DEBUG <> 0 THEN
697: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::others::'||lStmtNumber||sqlerrm,1);
698: END IF;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
701: FND_MSG_PUB.Add_Exc_Msg
791: --Bugfix 13362916
792: x_return_status := FND_API.G_RET_STS_SUCCESS;
793:
794: IF PG_DEBUG <> 0 THEN
795: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::pTopAtoLineId::'||to_char(pTopAtoLineId),1);
796: END IF;
797:
798: --
799: -- For each model item in all possible receiving orgs, call
801: --
802:
803: lStmtNumber := 20;
804: IF PG_DEBUG <> 0 THEN
805: oe_debug_pub.add('populate_plan_level: ' || 'before loop',2);
806: END IF;
807:
808:
809: FOR v_model_lines IN c_model_lines LOOP
810:
811: if( v_model_lines.config_creation in ( 1, 2 ) ) then
812:
813: IF PG_DEBUG <> 0 THEN
814: oe_debug_pub.add('populate_plan_level: ' || 'loop::item::'||to_char(v_model_lines.inventory_item_id)||
815: '::line_id::'||to_char(v_model_lines.line_id),2);
816: END IF;
817: lStmtNumber := 30;
818:
817: lStmtNumber := 30;
818:
819: IF v_model_lines.ato_line_id = v_model_lines.line_id THEN
820: IF PG_DEBUG <> 0 THEN
821: oe_debug_pub.add('populate_plan_level: ' || 'ato_line_id = line_id',2);
822: END IF;
823:
824:
825: lStmtNumber := 40;
829: where line_id = v_model_lines.line_id;
830:
831: lStmtNumber := 50;
832: IF PG_DEBUG <> 0 THEN
833: oe_debug_pub.add('populate_plan_level: ' || 'before calling GAIO',2);
834:
835: oe_debug_pub.add('populate_plan_level: ' || 'line_id::'||to_char(v_model_lines.line_id)||
836: '::inv_id::'||to_char(v_model_lines.inventory_item_id)||
837: '::ship_from_org::'||to_char(lShipFromOrgId),2);
831: lStmtNumber := 50;
832: IF PG_DEBUG <> 0 THEN
833: oe_debug_pub.add('populate_plan_level: ' || 'before calling GAIO',2);
834:
835: oe_debug_pub.add('populate_plan_level: ' || 'line_id::'||to_char(v_model_lines.line_id)||
836: '::inv_id::'||to_char(v_model_lines.inventory_item_id)||
837: '::ship_from_org::'||to_char(lShipFromOrgId),2);
838: END IF;
839:
848: v_model_lines.config_item_id);
849:
850: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
851: IF PG_DEBUG <> 0 THEN
852: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
853: END IF;
854: raise FND_API.G_EXC_UNEXPECTED_ERROR;
855:
856: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
854: raise FND_API.G_EXC_UNEXPECTED_ERROR;
855:
856: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
857: IF PG_DEBUG <> 0 THEN
858: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
859: END IF;
860: raise FND_API.G_EXC_ERROR;
861: END IF;
862: IF PG_DEBUG <> 0 THEN
859: END IF;
860: raise FND_API.G_EXC_ERROR;
861: END IF;
862: IF PG_DEBUG <> 0 THEN
863: oe_debug_pub.add('populate_plan_level: ' || 'after calling GAIO::lStatus::'||to_char(lStatus),2);
864: END IF;
865: ELSE
866: IF PG_DEBUG <> 0 THEN
867: oe_debug_pub.add('populate_plan_level: ' || 'ato_line_id <> line_id',2);
863: oe_debug_pub.add('populate_plan_level: ' || 'after calling GAIO::lStatus::'||to_char(lStatus),2);
864: END IF;
865: ELSE
866: IF PG_DEBUG <> 0 THEN
867: oe_debug_pub.add('populate_plan_level: ' || 'ato_line_id <> line_id',2);
868: END IF;
869: lStmtNumber := 60;
870: lLineId := v_model_lines.line_id;
871: IF PG_DEBUG <> 0 THEN
868: END IF;
869: lStmtNumber := 60;
870: lLineId := v_model_lines.line_id;
871: IF PG_DEBUG <> 0 THEN
872: oe_debug_pub.add('populate_plan_level: ' || 'before PSO loop',2);
873: END IF;
874:
875: FOR v_parent_src_ogs IN c_parent_src_orgs LOOP
876: IF PG_DEBUG <> 0 THEN
873: END IF;
874:
875: FOR v_parent_src_ogs IN c_parent_src_orgs LOOP
876: IF PG_DEBUG <> 0 THEN
877: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::rcv org::'||
878: to_char(v_parent_src_ogs.organization_id),2);
879:
880: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::item id::'||
881: to_char(v_model_lines.inventory_item_id),2);
876: IF PG_DEBUG <> 0 THEN
877: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::rcv org::'||
878: to_char(v_parent_src_ogs.organization_id),2);
879:
880: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::item id::'||
881: to_char(v_model_lines.inventory_item_id),2);
882:
883: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::line id::'||
884: to_char(v_model_lines.line_id),2);
879:
880: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::item id::'||
881: to_char(v_model_lines.inventory_item_id),2);
882:
883: oe_debug_pub.add('populate_plan_level: ' || 'in PSO loop::line id::'||
884: to_char(v_model_lines.line_id),2);
885: END IF;
886: lStmtNumber := 70;
887: lStatus := get_all_item_orgs(v_model_lines.line_id,
894: v_model_lines.config_item_id);
895:
896: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
897: IF PG_DEBUG <> 0 THEN
898: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
899: END IF;
900: raise FND_API.G_EXC_UNEXPECTED_ERROR;
901:
902: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
900: raise FND_API.G_EXC_UNEXPECTED_ERROR;
901:
902: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
903: IF PG_DEBUG <> 0 THEN
904: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
905: END IF;
906: raise FND_API.G_EXC_ERROR;
907: END IF;
908:
911:
912:
913: else
914:
915: oe_debug_pub.add( '$$$$$$$$ TYPE 3 model line ' || v_model_lines.line_id , 1 ) ;
916:
917: /* Fixed bug 3472654 */
918: if( v_model_lines.perform_match in ( 'Y' , 'U') ) then
919: CTO_MSUTIL_PUB.insert_type3_referenced_bcso( pTopAtoLineId
939:
940: end if ; /* config_creation check */
941:
942:
943: oe_debug_pub.add( '$$$$$$$$$$$$Going to START GET OSS BOM ORGS for Create BOM Indication ' || to_char( v_model_lines.line_id ) , 1 ) ;
944: oe_debug_pub.add( '$$$$$$$$$$$$Going to START GET OSS BOM ORGS for Create BOM Indication ' || v_model_lines.option_specific , 1 ) ;
945:
946: if( v_model_lines.option_specific in ( '1' , '2', '3' ) ) then
947:
940: end if ; /* config_creation check */
941:
942:
943: oe_debug_pub.add( '$$$$$$$$$$$$Going to START GET OSS BOM ORGS for Create BOM Indication ' || to_char( v_model_lines.line_id ) , 1 ) ;
944: oe_debug_pub.add( '$$$$$$$$$$$$Going to START GET OSS BOM ORGS for Create BOM Indication ' || v_model_lines.option_specific , 1 ) ;
945:
946: if( v_model_lines.option_specific in ( '1' , '2', '3' ) ) then
947:
948: oe_debug_pub.add( 'Going to Call GET OSS BOM ORGS for Create BOM Indication ' || to_char( v_model_lines.line_id) , 1 ) ;
944: oe_debug_pub.add( '$$$$$$$$$$$$Going to START GET OSS BOM ORGS for Create BOM Indication ' || v_model_lines.option_specific , 1 ) ;
945:
946: if( v_model_lines.option_specific in ( '1' , '2', '3' ) ) then
947:
948: oe_debug_pub.add( 'Going to Call GET OSS BOM ORGS for Create BOM Indication ' || to_char( v_model_lines.line_id) , 1 ) ;
949:
950:
951: cto_oss_source_pk.get_oss_bom_orgs( p_line_id => v_model_lines.line_id
952: ,x_orgs_list => v_orgs_list
961:
962: if x_return_status = FND_API.G_RET_STS_ERROR then
963:
964: IF PG_DEBUG <> 0 THEN
965: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
966: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with expected error.', 1);
967: END IF;
968:
969: raise FND_API.G_EXC_ERROR;
970:
971: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
972:
973: IF PG_DEBUG <> 0 THEN
974: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
975: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with unexpected error.', 1);
976: END IF;
977:
978: raise FND_API.G_EXC_UNEXPECTED_ERROR;
979:
980: end if;
981:
982: IF PG_DEBUG <> 0 THEN
983: oe_debug_pub.add('Create_And_Link_Item: ' || 'Ater Populate_Bcol', 5);
984: END IF;
985:
986:
987:
984: END IF;
985:
986:
987:
988: oe_debug_pub.add( 'OSS ORGS for Create BOM list size ' || v_orgs_list.count , 1 ) ;
989:
990: oe_debug_pub.add( 'OSS ORGS for Create BOM UPDATE ' , 1 ) ;
991:
992:
986:
987:
988: oe_debug_pub.add( 'OSS ORGS for Create BOM list size ' || v_orgs_list.count , 1 ) ;
989:
990: oe_debug_pub.add( 'OSS ORGS for Create BOM UPDATE ' , 1 ) ;
991:
992:
993: if( v_orgs_list.count > 0 ) then
994:
1000:
1001: update bom_cto_model_orgs set create_bom = 'N'
1002: where group_reference_id = v_group_reference_id ;
1003:
1004: oe_debug_pub.add( 'UPDATED BCMO create_bom = N for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;
1005: else
1006:
1007:
1008: update bom_cto_src_orgs_b set create_bom = 'N'
1007:
1008: update bom_cto_src_orgs_b set create_bom = 'N'
1009: where line_id = v_model_lines.line_id ;
1010:
1011: oe_debug_pub.add( 'UPDATED BCSO create_bom = N for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;
1012:
1013: end if;
1014:
1015:
1016:
1017: for i in 1..v_orgs_list.count
1018: loop
1019:
1020: oe_debug_pub.add( 'OSS ORGS for Create BOM ' || v_orgs_list(i) , 1 ) ;
1021:
1022: if( v_model_lines.config_creation = 3 and v_model_lines.perform_match in ( 'Y', 'U' ) ) then
1023:
1024: select group_reference_id into v_group_reference_id from bom_cto_src_orgs_b
1031: ( select 1 from bom_parameters
1032: where organization_id = v_orgs_list(i)
1033: and nvl(create_config_bom,'N') = 'Y' );
1034:
1035: oe_debug_pub.add( 'UPDATED BCMO create_bom = Y for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;
1036:
1037: else
1038:
1039:
1044: ( select 1 from bom_parameters
1045: where organization_id = v_orgs_list(i)
1046: and nvl(create_config_bom,'N') = 'Y' );
1047:
1048: oe_debug_pub.add( 'UPDATED BCSO create_bom = Y for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;
1049:
1050: end if;
1051:
1052:
1061:
1062:
1063:
1064:
1065: oe_debug_pub.add( '$$$$$$$$$$$$ DONE GET OSS BOM ORGS for Create BOM Indication ' || v_model_lines.line_id , 1 ) ;
1066:
1067:
1068:
1069: END LOOP;
1068:
1069: END LOOP;
1070:
1071: IF PG_DEBUG <> 0 THEN
1072: oe_debug_pub.add('populate_plan_level: ' || 'end of loop',1);
1073:
1074: oe_debug_pub.add('populate_plan_level: ' || 'printing out bcso :', 2);
1075:
1076: oe_debug_pub.add('populate_plan_level: ' || 'line_id model_item_id rcv_org_id org_id create_bom create_src_rules', 2);
1070:
1071: IF PG_DEBUG <> 0 THEN
1072: oe_debug_pub.add('populate_plan_level: ' || 'end of loop',1);
1073:
1074: oe_debug_pub.add('populate_plan_level: ' || 'printing out bcso :', 2);
1075:
1076: oe_debug_pub.add('populate_plan_level: ' || 'line_id model_item_id rcv_org_id org_id create_bom create_src_rules', 2);
1077: END IF;
1078:
1072: oe_debug_pub.add('populate_plan_level: ' || 'end of loop',1);
1073:
1074: oe_debug_pub.add('populate_plan_level: ' || 'printing out bcso :', 2);
1075:
1076: oe_debug_pub.add('populate_plan_level: ' || 'line_id model_item_id rcv_org_id org_id create_bom create_src_rules', 2);
1077: END IF;
1078:
1079: FOR v_debug IN c_debug LOOP
1080: IF PG_DEBUG <> 0 THEN
1077: END IF;
1078:
1079: FOR v_debug IN c_debug LOOP
1080: IF PG_DEBUG <> 0 THEN
1081: oe_debug_pub.add('populate_plan_level: ' || to_char(v_debug.line_id)||' '||
1082: to_char(v_debug.model_item_id)||' '||
1083: nvl(to_char(v_debug.rcv_org_id),null)||' '||
1084: to_char(v_debug.organization_id)||' '||
1085: nvl(v_debug.create_bom, null)||' '||
1090:
1091:
1092:
1093:
1094: oe_debug_pub.add( '$$$$$$$$ Going to update Create BOM flag for Shared Costing Organizations ' , 1 ) ;
1095:
1096: /*Update Create_BOM Flag for Shared Costing Organizations */
1097: update bom_cto_src_orgs_b bcso_b1 set create_bom = 'Y'
1098: where ( organization_id , line_id ) in ( select mp.cost_organization_id , bcso_b.line_id
1109: and bp.create_config_bom = 'Y' ) ;
1110:
1111:
1112:
1113: oe_debug_pub.add( '$$$$$$$$ Create BOM flag updated for Shared Costing Organizations ' || to_char(sql%rowcount) , 1 ) ;
1114:
1115:
1116:
1117: /* print debug output for Shared Cost update */
1117: /* print debug output for Shared Cost update */
1118: if( sql%rowcount > 0 ) then
1119: FOR v_debug IN c_debug LOOP
1120: IF PG_DEBUG <> 0 THEN
1121: oe_debug_pub.add('populate_plan_level: ' || to_char(v_debug.line_id)||' '||
1122: to_char(v_debug.model_item_id)||' '||
1123: nvl(to_char(v_debug.rcv_org_id),null)||' '||
1124: to_char(v_debug.organization_id)||' '||
1125: nvl(v_debug.create_bom, null)||' '||
1132:
1133:
1134: /* make a call to get validation orgs and purchasing related orgs */
1135:
1136: oe_debug_pub.add( '$$$$$$$$ Additional Type 1 and 2 Processing ' , 1 ) ;
1137:
1138: open get_each_type1_model ;
1139:
1140: loop
1142: fetch get_each_type1_model into v_current_model_line_id , v_current_model_item_id , v_config_creation , v_current_config_item_id;
1143:
1144: exit when get_each_type1_model%notfound ;
1145:
1146: oe_debug_pub.add( '$$$$$$$$ calling ORg List for model line ' || v_current_model_line_id , 1 ) ;
1147:
1148: if( v_config_creation = 1) then
1149:
1150: oe_debug_pub.add( '$$$$$$$$ TYPE 1 model line ' || v_current_model_line_id , 1 ) ;
1146: oe_debug_pub.add( '$$$$$$$$ calling ORg List for model line ' || v_current_model_line_id , 1 ) ;
1147:
1148: if( v_config_creation = 1) then
1149:
1150: oe_debug_pub.add( '$$$$$$$$ TYPE 1 model line ' || v_current_model_line_id , 1 ) ;
1151:
1152: CTO_MSUTIL_PUB.get_other_orgs( pmodellineid => v_current_model_line_id ,
1153: p_mode => 'UPG',
1154: xorglst => v_t_org_list ,
1160: /* bugfix 4162642 :added return status check */
1161: if x_return_status = FND_API.G_RET_STS_ERROR then
1162:
1163: if PG_DEBUG <> 0 then
1164: oe_debug_pub.add( 'ERROR: get_other_orgs api return expected error' , 1 ) ;
1165: end if;
1166:
1167: Raise FND_API.G_EXC_ERROR;
1168:
1168:
1169: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1170:
1171: if PG_DEBUG <> 0 then
1172: oe_debug_pub.add( 'ERROR: get_other_orgs api return unexpected error' , 1 ) ;
1173: end if;
1174:
1175: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1176:
1176:
1177: end if;
1178:
1179:
1180: oe_debug_pub.add( '$$$$$$$$ ORg List for model line ' || v_current_model_line_id , 1 ) ;
1181:
1182:
1183: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id, v_t_org_list , v_current_config_item_id) ;
1184:
1182:
1183: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id, v_t_org_list , v_current_config_item_id) ;
1184:
1185:
1186: oe_debug_pub.add( '$$$$$$$$ ORg List DONE for model line ' || v_current_model_line_id , 1 ) ;
1187: -- Added by Renga Kannan on 15-Sep-2005
1188: -- Added for ATG performance Project
1189:
1190: CTO_MSUTIL_PUB.Get_Master_orgs(
1196:
1197: if x_return_status = FND_API.G_RET_STS_ERROR then
1198:
1199: if PG_DEBUG <> 0 then
1200: oe_debug_pub.add( 'ERROR: get_Master_orgs api return expected error' , 1 ) ;
1201: end if;
1202:
1203: Raise FND_API.G_EXC_ERROR;
1204:
1204:
1205: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1206:
1207: if PG_DEBUG <> 0 then
1208: oe_debug_pub.add( 'ERROR: get_Master_orgs api return unexpected error' , 1 ) ;
1209: end if;
1210:
1211: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1212:
1220:
1221:
1222: elsif( v_config_creation = 2 ) then
1223:
1224: oe_debug_pub.add( '$$$$$$$$ TYPE 2 model line ' || v_current_model_line_id , 1 ) ;
1225:
1226: CTO_MSUTIL_PUB.insert_all_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id , v_current_config_item_id) ;
1227:
1228: end if;
1237: EXCEPTION
1238:
1239: when FND_API.G_EXC_UNEXPECTED_ERROR then
1240: IF PG_DEBUG <> 0 THEN
1241: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::unexp error::'||lStmtNumber||sqlerrm,1);
1242: END IF;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1244: CTO_MSG_PUB.Count_And_Get
1245: (p_msg_count => x_msg_count
1248: return(0);
1249:
1250: when FND_API.G_EXC_ERROR then
1251: IF PG_DEBUG <> 0 THEN
1252: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::exp error::'||lStmtNumber||sqlerrm,1);
1253: END IF;
1254: x_return_status := FND_API.G_RET_STS_ERROR;
1255: CTO_MSG_PUB.Count_And_Get
1256: (p_msg_count => x_msg_count
1258: return(0);
1259:
1260: when others then
1261: IF PG_DEBUG <> 0 THEN
1262: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::others::'||lStmtNumber||sqlerrm,1);
1263: END IF;
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1265: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1266: FND_MSG_PUB.Add_Exc_Msg
1428: Null;
1429:
1430: when too_many_rows then
1431: IF PG_DEBUG <> 0 THEN
1432: oe_debug_pub.add('get_all_item_orgs: ' || 'too_many_rows happens when make and buy exist' ||
1433: to_char(l_parent_ato_line_id ),2);
1434:
1435: END IF;
1436:
1437: l_source_type := 2 ;
1438: END;
1439:
1440: IF PG_DEBUG <> 0 THEN
1441: oe_debug_pub.add('populate_plan_level: ' || 'top ato line id::'||to_char(lTopAtoLineId),2);
1442: oe_debug_pub.add('populate_plan_level: ' || 'rcv org id::'||to_char(pRcvOrgId),2);
1443: oe_debug_pub.add('populate_plan_level: ' || 'model item id::'||to_char(pModelItemId),2);
1444: END IF;
1445:
1438: END;
1439:
1440: IF PG_DEBUG <> 0 THEN
1441: oe_debug_pub.add('populate_plan_level: ' || 'top ato line id::'||to_char(lTopAtoLineId),2);
1442: oe_debug_pub.add('populate_plan_level: ' || 'rcv org id::'||to_char(pRcvOrgId),2);
1443: oe_debug_pub.add('populate_plan_level: ' || 'model item id::'||to_char(pModelItemId),2);
1444: END IF;
1445:
1446: -- Added by Renga Kannan on 08/23/01 for procuring configuration
1439:
1440: IF PG_DEBUG <> 0 THEN
1441: oe_debug_pub.add('populate_plan_level: ' || 'top ato line id::'||to_char(lTopAtoLineId),2);
1442: oe_debug_pub.add('populate_plan_level: ' || 'rcv org id::'||to_char(pRcvOrgId),2);
1443: oe_debug_pub.add('populate_plan_level: ' || 'model item id::'||to_char(pModelItemId),2);
1444: END IF;
1445:
1446: -- Added by Renga Kannan on 08/23/01 for procuring configuration
1447:
1445:
1446: -- Added by Renga Kannan on 08/23/01 for procuring configuration
1447:
1448: IF PG_DEBUG <> 0 THEN
1449: oe_debug_pub.add('populate_plan_level: ' || 'Parent ATO line id = '||l_parent_ato_line_id,1);
1450: oe_debug_pub.add('populate_plan_level: ' || 'Parent source type = '||l_source_type,1);
1451: END IF;
1452:
1453: lStmtNumber := 28 ;
1446: -- Added by Renga Kannan on 08/23/01 for procuring configuration
1447:
1448: IF PG_DEBUG <> 0 THEN
1449: oe_debug_pub.add('populate_plan_level: ' || 'Parent ATO line id = '||l_parent_ato_line_id,1);
1450: oe_debug_pub.add('populate_plan_level: ' || 'Parent source type = '||l_source_type,1);
1451: END IF;
1452:
1453: lStmtNumber := 28 ;
1454:
1455: if( lProgramId = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
1456: v_source_type_code := 'INTERNAL' ;
1457:
1458: IF PG_DEBUG <> 0 THEN
1459: oe_debug_pub.add('populate_plan_level: ' || ' pc bom source type code = '|| v_source_type_code ,1);
1460: END IF;
1461: else
1462: select source_type_code
1463: into v_source_type_code
1464: from oe_order_lines_all
1465: where line_id = pLineId ;
1466:
1467: IF PG_DEBUG <> 0 THEN
1468: oe_debug_pub.add('populate_plan_level: ' || ' non pc bom source type code = '|| v_source_type_code ,1);
1469: END IF;
1470:
1471: end if ;
1472:
1470:
1471: end if ;
1472:
1473: IF PG_DEBUG <> 0 THEN
1474: oe_debug_pub.add('populate_plan_level: ' || 'source type code = '|| v_source_type_code ,1);
1475: END IF;
1476:
1477:
1478: lStmtNumber := 30;
1495: lStmtNumber := 35;
1496: l_source_type := 4;
1497:
1498: IF PG_DEBUG <> 0 THEN
1499: oe_debug_pub.add('populate_plan_level: ' || ' This is part of Buy model... No need to look for sourcing...',1);
1500: END IF;
1501:
1502:
1503:
1560: and rcv_org_id = pRcvOrgId
1561: and model_item_id = pModelItemId);
1562:
1563: IF PG_DEBUG <> 0 THEN
1564: oe_debug_pub.add('Get_All_Item_Orgs: ' || 'Inserted in BCSO for procured child model same org id, rcv org id ' || SQL%rowcount
1565: || ' at stmt ' || to_char(lStmtNumber) ,2);
1566: oe_debug_pub.add('Get_All_Iitem_Orgs: ' || 'Inserted into BCSO ' || ' for model ' || to_char( pmodelitemid )
1567: || ' line ' || to_char(pLineId) ,2);
1568: END IF;
1562:
1563: IF PG_DEBUG <> 0 THEN
1564: oe_debug_pub.add('Get_All_Item_Orgs: ' || 'Inserted in BCSO for procured child model same org id, rcv org id ' || SQL%rowcount
1565: || ' at stmt ' || to_char(lStmtNumber) ,2);
1566: oe_debug_pub.add('Get_All_Iitem_Orgs: ' || 'Inserted into BCSO ' || ' for model ' || to_char( pmodelitemid )
1567: || ' line ' || to_char(pLineId) ,2);
1568: END IF;
1569:
1570: ELSE
1571: lStmtNumber := 40;
1572:
1573: IF lMrpAssignmentSet is null THEN
1574: IF PG_DEBUG <> 0 THEN
1575: oe_debug_pub.add('populate_plan_level: ' || 'Default assignment set is null',1);
1576: END IF;
1577:
1578: -- added by Renga Kannan on 08/21/01
1579: -- When there is no sourcing rule defined we need to check for the make_buy_type of the
1590: where inventory_item_id = pModelItemId
1591: and organization_id = pRcvOrgId;
1592:
1593: IF PG_DEBUG <> 0 THEN
1594: oe_debug_pub.add('populate_plan_level: ' || 'Make buy code:: 1 means make 2 means buy',1);
1595: oe_debug_pub.add('populate_plan_level: ' || 'Planning make buy code for this item is ='||to_char(l_make_buy_code),1);
1596: END IF;
1597:
1598: IF l_make_buy_code = 2 then
1591: and organization_id = pRcvOrgId;
1592:
1593: IF PG_DEBUG <> 0 THEN
1594: oe_debug_pub.add('populate_plan_level: ' || 'Make buy code:: 1 means make 2 means buy',1);
1595: oe_debug_pub.add('populate_plan_level: ' || 'Planning make buy code for this item is ='||to_char(l_make_buy_code),1);
1596: END IF;
1597:
1598: IF l_make_buy_code = 2 then
1599: l_source_type := 3; ----- Buy Type
1670: and organization_id = pRcvOrgId
1671: and model_item_id = pModelItemId);
1672:
1673: IF PG_DEBUG <> 0 THEN
1674: oe_debug_pub.add('Get_All_Iitem_Orgs: ' || 'Inserted into BCSO ' || SQL%ROWCOUNT || ' at stmt ' || to_char(lStmtNumber) ,2);
1675: oe_debug_pub.add('Get_All_Iitem_Orgs: ' || 'Inserted into BCSO ' || ' for model ' || to_char( pmodelitemid )
1676: || ' line ' || to_char(plineid) , 2 );
1677: END IF;
1678:
1671: and model_item_id = pModelItemId);
1672:
1673: IF PG_DEBUG <> 0 THEN
1674: oe_debug_pub.add('Get_All_Iitem_Orgs: ' || 'Inserted into BCSO ' || SQL%ROWCOUNT || ' at stmt ' || to_char(lStmtNumber) ,2);
1675: oe_debug_pub.add('Get_All_Iitem_Orgs: ' || 'Inserted into BCSO ' || ' for model ' || to_char( pmodelitemid )
1676: || ' line ' || to_char(plineid) , 2 );
1677: END IF;
1678:
1679: ELSE
1679: ELSE
1680: lStmtNumber := 80;
1681:
1682: IF PG_DEBUG <> 0 THEN
1683: oe_debug_pub.add('Get_All_Iitem_Orgs: ' || 'Default assignment set is '||to_char(lMrpAssignmentSet),2);
1684: END IF;
1685:
1686: vx_concat_org_id := to_char( pRcvOrgId ) ;
1687:
1699: , x_msg_data );
1700:
1701: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1702: IF PG_DEBUG <> 0 THEN
1703: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with unexp error',1);
1704: END IF;
1705: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1706:
1707: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1705: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1706:
1707: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1708: IF PG_DEBUG <> 0 THEN
1709: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with exp error',1);
1710: END IF;
1711: raise FND_API.G_EXC_ERROR;
1712: END IF;
1713:
1711: raise FND_API.G_EXC_ERROR;
1712: END IF;
1713:
1714: IF PG_DEBUG <> 0 THEN
1715: oe_debug_pub.add('get_all_item_orgs: ' || 'after calling process_sourcing_chain::x_return_status::'||x_return_status,2);
1716: END IF;
1717:
1718: END IF; /* MRP profile is not null */
1719:
1787: and rcv_org_id = pRcvOrgId
1788: and model_item_id = pModelItemId);
1789:
1790: IF PG_DEBUG <> 0 THEN
1791: oe_debug_pub.add('Get_All_Item_Orgs: ' || 'Inserted in BCSO for transfer same org id, rcv org id ' || SQL%rowcount
1792: || ' at stmt ' || to_char(lStmtNumber) ,2);
1793: oe_debug_pub.add('Get_All_Iitem_Orgs: ' || 'Inserted into BCSO ' || ' for model ' || to_char( pmodelitemid )
1794: || ' line ' || to_char(plineid) ,2);
1795: END IF;
1789:
1790: IF PG_DEBUG <> 0 THEN
1791: oe_debug_pub.add('Get_All_Item_Orgs: ' || 'Inserted in BCSO for transfer same org id, rcv org id ' || SQL%rowcount
1792: || ' at stmt ' || to_char(lStmtNumber) ,2);
1793: oe_debug_pub.add('Get_All_Iitem_Orgs: ' || 'Inserted into BCSO ' || ' for model ' || to_char( pmodelitemid )
1794: || ' line ' || to_char(plineid) ,2);
1795: END IF;
1796:
1797: lStmtNumber := 180;
1795: END IF;
1796:
1797: lStmtNumber := 180;
1798: IF PG_DEBUG <> 0 THEN
1799: oe_debug_pub.add('get_all_item_orgs : ' || 'done recursive chain for model '||to_char(pmodelitemid ), 1);
1800: END IF;
1801:
1802: -- Bugfix 16315202: Putting an end if here so that procured_model_bcso_override gets called in cases
1803: -- when the MRP: Default Sourcing Assignment Set is null.
1811: -- to go into procured_model_bcso_override() function even if assignment set is not set.
1812: END IF;
1813:
1814: IF PG_DEBUG <> 0 THEN
1815: oe_debug_pub.add( ' procured_model_bcso_override mode ' || p_mode , 1);
1816: END IF;
1817:
1818: if ( p_mode = 'AUTOCONFIG' ) then
1819: oe_debug_pub.add( ' going to call procured_model_bcso_override ' , 1);
1815: oe_debug_pub.add( ' procured_model_bcso_override mode ' || p_mode , 1);
1816: END IF;
1817:
1818: if ( p_mode = 'AUTOCONFIG' ) then
1819: oe_debug_pub.add( ' going to call procured_model_bcso_override ' , 1);
1820:
1821: lStmtNumber := 200;
1822: procured_model_bcso_override( p_model_item_id => pModelItemId
1823: ,p_line_id => pLineId
1839:
1840: EXCEPTION
1841: when FND_API.G_EXC_ERROR then
1842: IF PG_DEBUG <> 0 THEN
1843: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::exp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1844: END IF;
1845: x_return_status := FND_API.G_RET_STS_ERROR;
1846: CTO_MSG_PUB.Count_And_Get
1847: (p_msg_count => x_msg_count
1850: return(0);
1851:
1852: when FND_API.G_EXC_UNEXPECTED_ERROR then
1853: IF PG_DEBUG <> 0 THEN
1854: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::unexp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1855: END IF;
1856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1857: CTO_MSG_PUB.Count_And_Get (
1858: p_msg_count => x_msg_count
1861: return(0);
1862:
1863: when OTHERS then
1864: IF PG_DEBUG <> 0 THEN
1865: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::others::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1866: END IF;
1867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1868: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1869: FND_MSG_PUB.Add_Exc_Msg
1941:
1942:
1943:
1944: IF PG_DEBUG <> 0 THEN
1945: oe_debug_pub.add( 'Entered process sourcing chain ' , 1 ) ;
1946: oe_debug_pub.add( 'Entered process sourcing chain line ' || p_line_id , 1 ) ;
1947: oe_debug_pub.add( 'Entered process sourcing chain org' || p_organization_id , 1 ) ;
1948: oe_debug_pub.add( 'Entered process sourcing chain model item ' || p_model_item_id , 1 ) ;
1949: END IF ;
1942:
1943:
1944: IF PG_DEBUG <> 0 THEN
1945: oe_debug_pub.add( 'Entered process sourcing chain ' , 1 ) ;
1946: oe_debug_pub.add( 'Entered process sourcing chain line ' || p_line_id , 1 ) ;
1947: oe_debug_pub.add( 'Entered process sourcing chain org' || p_organization_id , 1 ) ;
1948: oe_debug_pub.add( 'Entered process sourcing chain model item ' || p_model_item_id , 1 ) ;
1949: END IF ;
1950:
1943:
1944: IF PG_DEBUG <> 0 THEN
1945: oe_debug_pub.add( 'Entered process sourcing chain ' , 1 ) ;
1946: oe_debug_pub.add( 'Entered process sourcing chain line ' || p_line_id , 1 ) ;
1947: oe_debug_pub.add( 'Entered process sourcing chain org' || p_organization_id , 1 ) ;
1948: oe_debug_pub.add( 'Entered process sourcing chain model item ' || p_model_item_id , 1 ) ;
1949: END IF ;
1950:
1951:
1944: IF PG_DEBUG <> 0 THEN
1945: oe_debug_pub.add( 'Entered process sourcing chain ' , 1 ) ;
1946: oe_debug_pub.add( 'Entered process sourcing chain line ' || p_line_id , 1 ) ;
1947: oe_debug_pub.add( 'Entered process sourcing chain org' || p_organization_id , 1 ) ;
1948: oe_debug_pub.add( 'Entered process sourcing chain model item ' || p_model_item_id , 1 ) ;
1949: END IF ;
1950:
1951:
1952: if( to_char(p_organization_id ) = px_concat_org_id ) then
1959: l_orgs_index := p_organization_id;
1960: x_orgs_tbl(l_orgs_index) := p_organization_id;
1961:
1962: IF PG_DEBUG <> 0 THEN
1963: oe_debug_pub.add( 'Printing values in x_orgs_tbl' , 1 ) ;
1964:
1965: if x_orgs_tbl.count > 0 then
1966: IF PG_DEBUG <> 0 THEN
1967: oe_debug_pub.add('Count '|| x_orgs_tbl.Count, 5);
1963: oe_debug_pub.add( 'Printing values in x_orgs_tbl' , 1 ) ;
1964:
1965: if x_orgs_tbl.count > 0 then
1966: IF PG_DEBUG <> 0 THEN
1967: oe_debug_pub.add('Count '|| x_orgs_tbl.Count, 5);
1968: END IF;
1969:
1970: j := x_orgs_tbl.first;
1971: WHILE j IS NOT null LOOP
1969:
1970: j := x_orgs_tbl.first;
1971: WHILE j IS NOT null LOOP
1972: IF PG_DEBUG <> 0 THEN
1973: oe_debug_pub.add('x_sparse_tbl(j) '|| x_orgs_tbl(j));
1974: END IF;
1975: j := x_orgs_tbl.NEXT(j);
1976: END LOOP;
1977: end if;
1982: v_buy_traversed := FALSE ;
1983:
1984:
1985: IF PG_DEBUG <> 0 THEN
1986: oe_debug_pub.add( 'calling query sourcing org ' , 1 ) ;
1987: END IF;
1988:
1989:
1990: if( p_mode = 'AUTOCONFIG' ) then
2058:
2059:
2060:
2061: IF PG_DEBUG <> 0 THEN
2062: oe_debug_pub.add( 'output query sourcing org rule ' || v_t_sourcing_info.sourcing_rule_id.count , 1 ) ;
2063: oe_debug_pub.add( 'output query sourcing org src org ' || v_t_sourcing_info.source_organization_id.count , 1 ) ;
2064: oe_debug_pub.add( 'output query sourcing org src type' || v_t_sourcing_info.source_type.count , 1 ) ;
2065: END IF;
2066:
2059:
2060:
2061: IF PG_DEBUG <> 0 THEN
2062: oe_debug_pub.add( 'output query sourcing org rule ' || v_t_sourcing_info.sourcing_rule_id.count , 1 ) ;
2063: oe_debug_pub.add( 'output query sourcing org src org ' || v_t_sourcing_info.source_organization_id.count , 1 ) ;
2064: oe_debug_pub.add( 'output query sourcing org src type' || v_t_sourcing_info.source_type.count , 1 ) ;
2065: END IF;
2066:
2067:
2060:
2061: IF PG_DEBUG <> 0 THEN
2062: oe_debug_pub.add( 'output query sourcing org rule ' || v_t_sourcing_info.sourcing_rule_id.count , 1 ) ;
2063: oe_debug_pub.add( 'output query sourcing org src org ' || v_t_sourcing_info.source_organization_id.count , 1 ) ;
2064: oe_debug_pub.add( 'output query sourcing org src type' || v_t_sourcing_info.source_type.count , 1 ) ;
2065: END IF;
2066:
2067:
2068:
2071: FOR i in 1..v_t_sourcing_info.source_type.count
2072: LOOP
2073:
2074: IF PG_DEBUG <> 0 THEN
2075: oe_debug_pub.add( 'output query sourcing org type ' || v_t_sourcing_info.source_type(i) , 1 ) ;
2076: END IF;
2077:
2078: /* Reinitialize variables */
2079: l_curr_src_org := null ;
2082:
2083: IF PG_DEBUG <> 0 THEN
2084: if( v_t_sourcing_info.source_type(i) = 1 ) then
2085:
2086: oe_debug_pub.add( 'output query sourcing org type 1 ' , 1) ;
2087:
2088: elsif ( v_t_sourcing_info.source_type(i) = 2 ) then
2089: oe_debug_pub.add( 'output query sourcing org type 2 ' , 1) ;
2090:
2085:
2086: oe_debug_pub.add( 'output query sourcing org type 1 ' , 1) ;
2087:
2088: elsif ( v_t_sourcing_info.source_type(i) = 2 ) then
2089: oe_debug_pub.add( 'output query sourcing org type 2 ' , 1) ;
2090:
2091:
2092: elsif ( v_t_sourcing_info.source_type(i) = 3 ) then
2093:
2090:
2091:
2092: elsif ( v_t_sourcing_info.source_type(i) = 3 ) then
2093:
2094: oe_debug_pub.add( 'output query sourcing org type 3 ' , 1) ;
2095:
2096:
2097: else
2098:
2095:
2096:
2097: else
2098:
2099: oe_debug_pub.add( 'output query sourcing org type else ' , 1) ;
2100:
2101: end if ;
2102: END IF;
2103:
2106: if( v_t_sourcing_info.source_type(i) in ( 1, 2 ) ) then
2107:
2108:
2109: IF PG_DEBUG <> 0 THEN
2110: oe_debug_pub.add( ' came into type 1,2 ' , 1 ) ;
2111: END IF;
2112:
2113:
2114: begin
2124: exception
2125: when others then
2126:
2127: IF PG_DEBUG <> 0 THEN
2128: oe_debug_pub.add( ' errored into type 1,2 at ' || lStmtNum || ' err ' || SQLERRM , 1 ) ;
2129: END IF;
2130: end ;
2131:
2132: IF PG_DEBUG <> 0 THEN
2129: END IF;
2130: end ;
2131:
2132: IF PG_DEBUG <> 0 THEN
2133: oe_debug_pub.add( ' value for l_curr_src_org ' || l_curr_src_org , 1 ) ;
2134: oe_debug_pub.add( ' value for l_source_type ' || l_source_type , 1 ) ;
2135: oe_debug_pub.add( ' value for l_curr_rank ' || l_curr_rank , 1 ) ;
2136: END IF;
2137:
2130: end ;
2131:
2132: IF PG_DEBUG <> 0 THEN
2133: oe_debug_pub.add( ' value for l_curr_src_org ' || l_curr_src_org , 1 ) ;
2134: oe_debug_pub.add( ' value for l_source_type ' || l_source_type , 1 ) ;
2135: oe_debug_pub.add( ' value for l_curr_rank ' || l_curr_rank , 1 ) ;
2136: END IF;
2137:
2138:
2131:
2132: IF PG_DEBUG <> 0 THEN
2133: oe_debug_pub.add( ' value for l_curr_src_org ' || l_curr_src_org , 1 ) ;
2134: oe_debug_pub.add( ' value for l_source_type ' || l_source_type , 1 ) ;
2135: oe_debug_pub.add( ' value for l_curr_rank ' || l_curr_rank , 1 ) ;
2136: END IF;
2137:
2138:
2139:
2141:
2142: if( l_source_type = 1 ) then
2143:
2144: IF PG_DEBUG <> 0 THEN
2145: oe_debug_pub.add( 'going to check for circular sourcing ' , 1 ) ;
2146: /* check for circular sourcing in bcso */
2147: oe_debug_pub.add( 'CIRCULAR SOURCE CHECK ' || px_concat_org_id ) ;
2148: END IF;
2149:
2143:
2144: IF PG_DEBUG <> 0 THEN
2145: oe_debug_pub.add( 'going to check for circular sourcing ' , 1 ) ;
2146: /* check for circular sourcing in bcso */
2147: oe_debug_pub.add( 'CIRCULAR SOURCE CHECK ' || px_concat_org_id ) ;
2148: END IF;
2149:
2150:
2151: v_org_check := to_char(l_curr_src_org) ;
2150:
2151: v_org_check := to_char(l_curr_src_org) ;
2152:
2153: IF PG_DEBUG <> 0 THEN
2154: oe_debug_pub.add( 'CIRCULAR SOURCE CHECK px_concat_org_id ' || px_concat_org_id || ' v_org_check ' || v_org_check ) ;
2155: END IF;
2156:
2157:
2158: /* Commenting as part of Bugfix 7522447/7410091
2158: /* Commenting as part of Bugfix 7522447/7410091
2159: if( instr( px_concat_org_id , v_org_check ) > 0 ) then
2160: v_circular_src_exists := 'Y' ;
2161: IF PG_DEBUG <> 0 THEN
2162: oe_debug_pub.add( 'CIRCULAR SOURCE DETECTED ' ) ;
2163: END IF;
2164:
2165: else
2166:
2172: if (x_orgs_tbl.exists(l_curr_src_org)) then
2173: lStmtNum := 6;
2174: v_circular_src_exists := 'Y';
2175: IF PG_DEBUG <> 0 THEN
2176: oe_debug_pub.add( 'CIRCULAR SOURCE DETECTED ' ) ;
2177: END IF;
2178:
2179: else
2180: v_circular_src_exists := 'N' ;
2185: if( v_circular_src_exists = 'Y' OR ( l_source_type = 1 and p_organization_id = l_curr_src_org) ) then
2186:
2187: lStmtNum := 5;
2188: IF PG_DEBUG <> 0 THEN
2189: oe_debug_pub.add('process_sourcing_chain: ' || 'Circular sourcing defined for model '
2190: || to_char(p_model_item_id)
2191: || ' in org '
2192: ||to_char(l_curr_src_org) || ' via org ' || to_char(p_organization_id ) , 1);
2193:
2191: || ' in org '
2192: ||to_char(l_curr_src_org) || ' via org ' || to_char(p_organization_id ) , 1);
2193:
2194:
2195: oe_debug_pub.add('process_sourcing_chain: ' || 'Circular sourcing additional info '
2196: || px_concat_org_id || '::' || to_char(l_curr_src_org) , 1) ;
2197:
2198: END IF;
2199:
2207: end if; /* l_source_type = 1 */
2208:
2209:
2210: IF PG_DEBUG <> 0 THEN
2211: oe_debug_pub.add( 'going to insert bcso for type 1,2 ' , 1 ) ;
2212: END IF;
2213:
2214: lStmtNum := 10 ;
2215: insert into bom_cto_src_orgs_b
2270:
2271:
2272:
2273: IF PG_DEBUG <> 0 THEN
2274: oe_debug_pub.add( 'inserted bcso for type 1,2 ' || SQL%rowcount , 1 ) ;
2275: oe_debug_pub.add( 'inserted bcso for type 1,2 rcv ' || p_organization_id || ' org ' || l_curr_src_org , 1 ) ;
2276: END IF;
2277:
2278:
2271:
2272:
2273: IF PG_DEBUG <> 0 THEN
2274: oe_debug_pub.add( 'inserted bcso for type 1,2 ' || SQL%rowcount , 1 ) ;
2275: oe_debug_pub.add( 'inserted bcso for type 1,2 rcv ' || p_organization_id || ' org ' || l_curr_src_org , 1 ) ;
2276: END IF;
2277:
2278:
2279:
2281: elsif( v_t_sourcing_info.source_type(i) = 3 and NOT v_buy_traversed ) then
2282:
2283: v_buy_traversed := TRUE ;
2284:
2285: oe_debug_pub.add( ' came into type 3 ' , 1 ) ;
2286:
2287: lStmtNum := 20 ;
2288:
2289: begin
2299: exception
2300: when others then
2301:
2302: IF PG_DEBUG <> 0 THEN
2303: oe_debug_pub.add( ' errored into type 3 at ' || lStmtNum || ' err ' || SQLERRM , 1 ) ;
2304: END IF;
2305:
2306: end ;
2307:
2367:
2368:
2369:
2370: IF PG_DEBUG <> 0 THEN
2371: oe_debug_pub.add( 'inserted bcso for type 3 ' || SQL%rowcount , 1 ) ;
2372: oe_debug_pub.add( 'inserted bcso for type 3 rcv ' || p_organization_id || ' org ' || l_curr_src_org , 1 ) ;
2373: END IF;
2374:
2375:
2368:
2369:
2370: IF PG_DEBUG <> 0 THEN
2371: oe_debug_pub.add( 'inserted bcso for type 3 ' || SQL%rowcount , 1 ) ;
2372: oe_debug_pub.add( 'inserted bcso for type 3 rcv ' || p_organization_id || ' org ' || l_curr_src_org , 1 ) ;
2373: END IF;
2374:
2375:
2376:
2382:
2383: if( v_t_sourcing_info.source_type(i) = 1 ) then
2384:
2385:
2386: oe_debug_pub.add( 'calling process sourcing chain recursive ' , 1 ) ;
2387:
2388: lStmtNum := 50 ;
2389:
2390: /* implemented using another variable as it is a multipath tree recursion */
2406:
2407:
2408: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2409: IF PG_DEBUG <> 0 THEN
2410: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with unexp error',1);
2411: END IF;
2412: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2413:
2414: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2412: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2413:
2414: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2415: IF PG_DEBUG <> 0 THEN
2416: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with exp error',1);
2417: END IF;
2418: raise FND_API.G_EXC_ERROR;
2419: END IF;
2420:
2419: END IF;
2420:
2421:
2422: IF PG_DEBUG <> 0 THEN
2423: oe_debug_pub.add('process_sourcing_chain: ' || 'after calling process_sourcing_chain::x_return_status::'||x_return_status,2);
2424: END IF;
2425:
2426:
2427: end if;
2438: -- if( v_source_type_code = 'INTERNAL' ) then
2439:
2440:
2441: IF PG_DEBUG <> 0 THEN
2442: oe_debug_pub.add('process_sourcing_chain : ' || 'NDF::End of chain for model '||to_char(p_model_item_id), 1);
2443: oe_debug_pub.add('process_sourcing_chain : ' || 'NDF::End of chain in org '|| p_organization_id , 1);
2444: END IF;
2445:
2446:
2439:
2440:
2441: IF PG_DEBUG <> 0 THEN
2442: oe_debug_pub.add('process_sourcing_chain : ' || 'NDF::End of chain for model '||to_char(p_model_item_id), 1);
2443: oe_debug_pub.add('process_sourcing_chain : ' || 'NDF::End of chain in org '|| p_organization_id , 1);
2444: END IF;
2445:
2446:
2447: lStmtNumber := 70;
2460: EXCEPTION
2461: WHEN NO_DATA_FOUND THEN
2462:
2463: IF PG_DEBUG <> 0 THEN
2464: oe_debug_pub.add('process_sourcing_chain: ' || 'Inventory_item_id = '|| to_char(p_model_item_id ),1);
2465:
2466: oe_debug_pub.add('process_sourcing_chain: ' || 'Organization id = '|| to_char(p_organization_id),1);
2467:
2468: oe_debug_pub.add('process_sourcing_chain: ' || 'ERROR::The item is not defined in the sourcing org',1);
2462:
2463: IF PG_DEBUG <> 0 THEN
2464: oe_debug_pub.add('process_sourcing_chain: ' || 'Inventory_item_id = '|| to_char(p_model_item_id ),1);
2465:
2466: oe_debug_pub.add('process_sourcing_chain: ' || 'Organization id = '|| to_char(p_organization_id),1);
2467:
2468: oe_debug_pub.add('process_sourcing_chain: ' || 'ERROR::The item is not defined in the sourcing org',1);
2469: END IF;
2470:
2464: oe_debug_pub.add('process_sourcing_chain: ' || 'Inventory_item_id = '|| to_char(p_model_item_id ),1);
2465:
2466: oe_debug_pub.add('process_sourcing_chain: ' || 'Organization id = '|| to_char(p_organization_id),1);
2467:
2468: oe_debug_pub.add('process_sourcing_chain: ' || 'ERROR::The item is not defined in the sourcing org',1);
2469: END IF;
2470:
2471:
2472: -- The following message handling is modified by Renga Kannan
2566: and model_item_id = p_model_item_id ) ;
2567:
2568:
2569: IF PG_DEBUG <> 0 THEN
2570: oe_debug_pub.add( 'inserted bcso for end of chain ' || SQL%rowcount , 1 ) ;
2571: oe_debug_pub.add( 'inserted bcso for end of chain ' || p_organization_id ||
2572: ' org ' || p_organization_id
2573: , 1 ) ;
2574: END IF;
2567:
2568:
2569: IF PG_DEBUG <> 0 THEN
2570: oe_debug_pub.add( 'inserted bcso for end of chain ' || SQL%rowcount , 1 ) ;
2571: oe_debug_pub.add( 'inserted bcso for end of chain ' || p_organization_id ||
2572: ' org ' || p_organization_id
2573: , 1 ) ;
2574: END IF;
2575:
2579:
2580:
2581:
2582: IF PG_DEBUG <> 0 THEN
2583: oe_debug_pub.add('process_sourcing_chain: ' || 'end p_organization_id '||to_char(p_organization_id), 1);
2584: oe_debug_pub.add('process_sourcing_chain: ' || 'end px_concat_org_id '|| px_concat_org_id , 1);
2585: END IF;
2586:
2587: x_orgs_tbl.delete(p_organization_id); --Bugfix 7522447/7410091
2580:
2581:
2582: IF PG_DEBUG <> 0 THEN
2583: oe_debug_pub.add('process_sourcing_chain: ' || 'end p_organization_id '||to_char(p_organization_id), 1);
2584: oe_debug_pub.add('process_sourcing_chain: ' || 'end px_concat_org_id '|| px_concat_org_id , 1);
2585: END IF;
2586:
2587: x_orgs_tbl.delete(p_organization_id); --Bugfix 7522447/7410091
2588: IF PG_DEBUG <> 0 THEN
2585: END IF;
2586:
2587: x_orgs_tbl.delete(p_organization_id); --Bugfix 7522447/7410091
2588: IF PG_DEBUG <> 0 THEN
2589: oe_debug_pub.add('process_sourcing_chain: ' || 'Org deleted from collection: '||to_char(p_organization_id), 1);
2590: END IF;
2591:
2592:
2593:
2594:
2595: EXCEPTION
2596: WHEN fnd_api.g_exc_error THEN
2597: IF PG_DEBUG <> 0 THEN
2598: oe_debug_pub.add('process_sourcing_chain: ' || 'Exception in stmt num: '
2599: || to_char(lStmtNum), 1);
2600: END IF;
2601: x_return_status := FND_API.G_RET_STS_ERROR;
2602: -- Get message count and data
2605: , p_msg_data => x_msg_data
2606: );
2607: WHEN fnd_api.g_exc_unexpected_error THEN
2608: IF PG_DEBUG <> 0 THEN
2609: oe_debug_pub.add('process_sourcing_chain: ' || ' Unexpected Exception in stmt num: '
2610: || to_char(lStmtNum), 1);
2611: END IF;
2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2613: -- Get message count and data
2617: );
2618: WHEN OTHERS then
2619: IF PG_DEBUG <> 0 THEN
2620:
2621: oe_debug_pub.add('process_sourcing_chain: ' || 'Others Exception in stmt num: '
2622: || to_char(lStmtNum), 1);
2623: oe_debug_pub.add('process_sourcing_chain: ' || 'errormsg='||sqlerrm, 1);
2624: END IF;
2625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2619: IF PG_DEBUG <> 0 THEN
2620:
2621: oe_debug_pub.add('process_sourcing_chain: ' || 'Others Exception in stmt num: '
2622: || to_char(lStmtNum), 1);
2623: oe_debug_pub.add('process_sourcing_chain: ' || 'errormsg='||sqlerrm, 1);
2624: END IF;
2625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2626: -- Get message count and data
2627: cto_msg_pub.count_and_get
2687: -- The following initialize_assignment_set is used to initialize the global variable
2688:
2689: IF gMrpAssignmentSet is null THEN
2690: IF PG_DEBUG <> 0 THEN
2691: oe_debug_pub.add('query_sourcing_org_ms: ' || 'Initializing the assignment set',5);
2692: END IF;
2693: initialize_assignment_set(x_return_status);
2694: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2695: IF PG_DEBUG <> 0 THEN
2692: END IF;
2693: initialize_assignment_set(x_return_status);
2694: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2695: IF PG_DEBUG <> 0 THEN
2696: oe_debug_pub.add('query_sourcing_org_ms: ' || 'Error in initializing assignment set',5);
2697: END IF;
2698: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2699: end if;
2700: End IF;
2772:
2773: close item_sources ;
2774:
2775:
2776: oe_debug_pub.add('query_sourcing_org_ms: ' || '****$$$$ count ' || p_t_sourcing_info.source_organization_id.count , 1 ) ;
2777:
2778:
2779: for i in 1..p_t_sourcing_info.sourcing_rule_id.count
2780: loop
2778:
2779: for i in 1..p_t_sourcing_info.sourcing_rule_id.count
2780: loop
2781:
2782: oe_debug_pub.add('query_sourcing_org_ms: ' || '****$$$$ org ' || p_t_sourcing_info.source_organization_id(i)
2783: || '****$$$$ rule ' || p_t_sourcing_info.sourcing_rule_id(i)
2784: || '****$$$$ type ' || p_t_sourcing_info.source_type(i)
2785: || '****$$$$ rank ' || p_t_sourcing_info.rank(i)
2786: || '****$$$$ assig id ' || p_t_sourcing_info.assignment_id(i) , 1 ) ;
2806:
2807: EXCEPTION
2808: WHEN NO_DATA_FOUND THEN
2809: IF PG_DEBUG <> 0 THEN
2810: oe_debug_pub.add('query_sourcing_org_ms: ' || ' came into no data when finding source ' || to_char(l_stmt_num ) , 1 );
2811: END IF;
2812: /* removed no sourcing flag as cascading of sourcing rules will
2813: ** be continued till no more sourcing rules can be cascaded
2814: */
2838:
2839:
2840: WHEN OTHERS THEN
2841: IF PG_DEBUG <> 0 THEN
2842: oe_debug_pub.add('query_sourcing_org_ms: ' || 'query_sourcing_org_ms::others:: ' ||
2843: to_char(l_stmt_num) || '::' ||
2844: ' came into others when finding source ' , 1 );
2845:
2846: oe_debug_pub.add('query_sourcing_org_ms: ' || ' SQLCODE ' || SQLCODE , 1 );
2842: oe_debug_pub.add('query_sourcing_org_ms: ' || 'query_sourcing_org_ms::others:: ' ||
2843: to_char(l_stmt_num) || '::' ||
2844: ' came into others when finding source ' , 1 );
2845:
2846: oe_debug_pub.add('query_sourcing_org_ms: ' || ' SQLCODE ' || SQLCODE , 1 );
2847:
2848: oe_debug_pub.add('query_sourcing_org_ms: ' || ' SQLERRM ' || SQLERRM , 1 );
2849:
2850: oe_debug_pub.add('query_sourcing_org_ms: ' || ' came into others when finding source ' , 1 );
2844: ' came into others when finding source ' , 1 );
2845:
2846: oe_debug_pub.add('query_sourcing_org_ms: ' || ' SQLCODE ' || SQLCODE , 1 );
2847:
2848: oe_debug_pub.add('query_sourcing_org_ms: ' || ' SQLERRM ' || SQLERRM , 1 );
2849:
2850: oe_debug_pub.add('query_sourcing_org_ms: ' || ' came into others when finding source ' , 1 );
2851: END IF;
2852:
2846: oe_debug_pub.add('query_sourcing_org_ms: ' || ' SQLCODE ' || SQLCODE , 1 );
2847:
2848: oe_debug_pub.add('query_sourcing_org_ms: ' || ' SQLERRM ' || SQLERRM , 1 );
2849:
2850: oe_debug_pub.add('query_sourcing_org_ms: ' || ' came into others when finding source ' , 1 );
2851: END IF;
2852:
2853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2854:
2928:
2929:
2930: IF lMrpAssignmentSet is null THEN
2931: IF PG_DEBUG <> 0 THEN
2932: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Default assignment set is null, returning from create_sourcing_rules procedure',1);
2933: END IF;
2934: return;
2935: ELSE
2936: IF PG_DEBUG <> 0 THEN
2933: END IF;
2934: return;
2935: ELSE
2936: IF PG_DEBUG <> 0 THEN
2937: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Default assignment set is '||to_char(lMrpAssignmentSet),2);
2938: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Upgrade assignment set is '||to_char(lUPGAssignmentSet),2);
2939: END IF;
2940: END IF;
2941:
2934: return;
2935: ELSE
2936: IF PG_DEBUG <> 0 THEN
2937: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Default assignment set is '||to_char(lMrpAssignmentSet),2);
2938: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Upgrade assignment set is '||to_char(lUPGAssignmentSet),2);
2939: END IF;
2940: END IF;
2941:
2942: --
2985: EXCEPTION
2986: WHEN NO_DATA_FOUND THEN
2987:
2988: IF PG_DEBUG <> 0 THEN
2989: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'There is no sourcing rule defined ',1);
2990: END IF;
2991: raise no_sourcing_defined;
2992:
2993: END;
2993: END;
2994:
2995:
2996: IF PG_DEBUG <> 0 THEN
2997: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'lAssnType::'||to_char(lAssignmentType)||'::lAssnId::'||to_char(lAssignmentId),2);
2998: END IF;
2999:
3000: --
3001: -- copy assignment into lAssignmentRec
3285: EXCEPTION
3286: WHEN NO_DATA_FOUND THEN
3287:
3288: IF PG_DEBUG <> 0 THEN
3289: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment exists already, do not recreate go to end of loop',2);
3290: END IF;
3291:
3292: RETURN;
3293:
3292: RETURN;
3293:
3294: WHEN OTHERS THEN
3295: IF PG_DEBUG <> 0 THEN
3296: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'others exception while checking ifassignment exists, not handling, creating assignment:: '||sqlerrm,2);
3297: END IF;
3298: END;
3299:
3300: IF PG_DEBUG <> 0 THEN
3297: END IF;
3298: END;
3299:
3300: IF PG_DEBUG <> 0 THEN
3301: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'after query row',2);
3302: END IF;
3303:
3304: --
3305: -- check if this assignment already exists for config item
3307: lStmtNum := 35;
3308: -- BEGIN
3309: --
3310: -- IF PG_DEBUG <> 0 THEN
3311: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);
3312: --
3313: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
3314: --
3315: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
3309: --
3310: -- IF PG_DEBUG <> 0 THEN
3311: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);
3312: --
3313: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
3314: --
3315: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
3316: --
3317: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
3311: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);
3312: --
3313: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
3314: --
3315: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
3316: --
3317: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
3318: --
3319: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
3313: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
3314: --
3315: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
3316: --
3317: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
3318: --
3319: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
3320: --
3321: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
3315: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
3316: --
3317: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
3318: --
3319: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
3320: --
3321: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
3322: --
3323: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
3317: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
3318: --
3319: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
3320: --
3321: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
3322: --
3323: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
3324: --
3325: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);
3319: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
3320: --
3321: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
3322: --
3323: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
3324: --
3325: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);
3326: -- END IF;
3327: --
3321: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
3322: --
3323: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
3324: --
3325: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);
3326: -- END IF;
3327: --
3328: -- -- bug 6617686
3329: -- IF pConfigId IS NOT NULL THEN
3354: -- -- end: bug 6617686
3355: --
3356: -- IF lAssignmentExists = 1 THEN
3357: -- IF PG_DEBUG <> 0 THEN
3358: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment exists already, do not recreate',2);
3359: -- END IF;
3360: -- return;
3361: -- END IF;
3362: --
3362: --
3363: -- EXCEPTION
3364: -- when NO_DATA_FOUND then
3365: -- IF PG_DEBUG <> 0 THEN
3366: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment does not exist, create it',2);
3367: -- END IF;
3368: -- when OTHERS then
3369: -- IF PG_DEBUG <> 0 THEN
3370: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'others exception while checking ifassignment exists, not handling, creating assignment:: '||sqlerrm,2);
3366: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment does not exist, create it',2);
3367: -- END IF;
3368: -- when OTHERS then
3369: -- IF PG_DEBUG <> 0 THEN
3370: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'others exception while checking ifassignment exists, not handling, creating assignment:: '||sqlerrm,2);
3371: -- END IF;
3372: -- END;
3373:
3374: --
3423: lAssignmentTbl(1).db_flag := NULL;
3424: lAssignmentTbl(1).operation := MRP_Globals.G_OPR_CREATE;
3425:
3426: IF PG_DEBUG <> 0 THEN
3427: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'after forming lAssignmentTbl',2);
3428: END IF;
3429:
3430: --
3431: -- form lAssignmentSetRec
3432: --
3433: lStmtNum := 50;
3434: lAssignmentSetRec.operation := MRP_Globals.G_OPR_NONE;
3435: IF PG_DEBUG <> 0 THEN
3436: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'after forming lAssignmentSetRec',2);
3437: END IF;
3438:
3439: --
3440: -- call mrp API to insert rec into assignment set
3440: -- call mrp API to insert rec into assignment set
3441: --
3442: lStmtNum := 60;
3443: IF PG_DEBUG <> 0 THEN
3444: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'before Process_Assignment',2);
3445: END IF;
3446:
3447: -- currently, not passing commented out parameters, need to
3448: -- confirm with raghu, confirmed with stupe
3466: );
3467:
3468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3469: IF PG_DEBUG <> 0 THEN
3470: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
3471: END IF;
3472: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3473:
3474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3472: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3473:
3474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3475: IF PG_DEBUG <> 0 THEN
3476: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);
3477: END IF;
3478:
3479: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: count:'||l_msg_count , 1 );
3480:
3475: IF PG_DEBUG <> 0 THEN
3476: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);
3477: END IF;
3478:
3479: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: count:'||l_msg_count , 1 );
3480:
3481: IF l_msg_count > 0 THEN
3482: FOR l_index IN 1..l_msg_count LOOP
3483: l_msg_data := fnd_msg_pub.get(
3483: l_msg_data := fnd_msg_pub.get(
3484: p_msg_index => l_index,
3485: p_encoded => FND_API.G_FALSE);
3486:
3487: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );
3488: END LOOP;
3489:
3490: oe_debug_pub.add(' CTO_MSUTIL_PUB.create_sourcing_rules: MSG:'|| xAssignmentSetRec.return_status);
3491: END IF;
3486:
3487: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );
3488: END LOOP;
3489:
3490: oe_debug_pub.add(' CTO_MSUTIL_PUB.create_sourcing_rules: MSG:'|| xAssignmentSetRec.return_status);
3491: END IF;
3492:
3493: oe_debug_pub.add('Failure!' , 1 );
3494:
3489:
3490: oe_debug_pub.add(' CTO_MSUTIL_PUB.create_sourcing_rules: MSG:'|| xAssignmentSetRec.return_status);
3491: END IF;
3492:
3493: oe_debug_pub.add('Failure!' , 1 );
3494:
3495:
3496: raise FND_API.G_EXC_ERROR;
3497:
3496: raise FND_API.G_EXC_ERROR;
3497:
3498: END IF;
3499: IF PG_DEBUG <> 0 THEN
3500: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'success in process_assignment',2);
3501: END IF;
3502:
3503: EXCEPTION
3504: When NO_sourcing_defined THEN
3505: null;
3506:
3507: when FND_API.G_EXC_ERROR then
3508: IF PG_DEBUG <> 0 THEN
3509: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3510: END IF;
3511: x_return_status := FND_API.G_RET_STS_ERROR;
3512: CTO_MSG_PUB.Count_And_Get
3513: (p_msg_count => x_msg_count
3515: );
3516:
3517: when FND_API.G_EXC_UNEXPECTED_ERROR then
3518: IF PG_DEBUG <> 0 THEN
3519: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3520: END IF;
3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: CTO_MSG_PUB.Count_And_Get
3523: (p_msg_count => x_msg_count
3525: );
3526:
3527: when OTHERS then
3528: IF PG_DEBUG <> 0 THEN
3529: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3530: END IF;
3531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3532: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3533: FND_MSG_PUB.Add_Exc_Msg
3661:
3662:
3663: IF lMrpAssignmentSet is null THEN
3664: IF PG_DEBUG <> 0 THEN
3665: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Default assignment set is null, returning from create_sourcing_rules procedure',1);
3666: END IF;
3667: return;
3668: ELSE
3669: IF PG_DEBUG <> 0 THEN
3666: END IF;
3667: return;
3668: ELSE
3669: IF PG_DEBUG <> 0 THEN
3670: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Default assignment set is '||to_char(lMrpAssignmentSet),2);
3671: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'UPG assignment set is '||to_char(lUPGAssignmentSet),2);
3672: END IF;
3673: END IF;
3674:
3667: return;
3668: ELSE
3669: IF PG_DEBUG <> 0 THEN
3670: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Default assignment set is '||to_char(lMrpAssignmentSet),2);
3671: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'UPG assignment set is '||to_char(lUPGAssignmentSet),2);
3672: END IF;
3673: END IF;
3674:
3675: --
3713: EXCEPTION
3714: WHEN NO_DATA_FOUND THEN
3715:
3716: IF PG_DEBUG <> 0 THEN
3717: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'There is no sourcing rule defined ',1);
3718: END IF;
3719: raise no_sourcing_defined;
3720:
3721: END;
3741: exit when c_type3_assignments%notfound ;
3742:
3743:
3744: IF PG_DEBUG <> 0 THEN
3745: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'lAssnType::'||to_char(lAssignmentType)||'::lAssnId::'||to_char(lAssignmentId),2);
3746: END IF;
3747:
3748: --
3749: -- copy assignment into lAssignmentRec
4034:
4035: EXCEPTION
4036: WHEN NO_DATA_FOUND THEN
4037: IF PG_DEBUG <> 0 THEN
4038: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment exists already, do not recreate',2);
4039: END IF;
4040: goto END_OF_LOOP;
4041:
4042: WHEN OTHERS THEN
4040: goto END_OF_LOOP;
4041:
4042: WHEN OTHERS THEN
4043: IF PG_DEBUG <> 0 THEN
4044: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'others exception while checking ifassignment exists, not handling, creating assignment:: '||sqlerrm,2);
4045: END IF;
4046: END;
4047:
4048: IF PG_DEBUG <> 0 THEN
4045: END IF;
4046: END;
4047:
4048: IF PG_DEBUG <> 0 THEN
4049: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after query row',2);
4050: END IF;
4051:
4052: --
4053: -- check if this assignment already exists for config item
4055: lStmtNum := 35;
4056: -- BEGIN
4057: --
4058: -- IF PG_DEBUG <> 0 THEN
4059: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);
4060: --
4061: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Source assignment_set_id::'||to_char(lMrpAssignmentSet),2);
4062: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Destination assignment_set_id::'||to_char(lUPGAssignmentSet),2);
4063: --
4057: --
4058: -- IF PG_DEBUG <> 0 THEN
4059: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);
4060: --
4061: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Source assignment_set_id::'||to_char(lMrpAssignmentSet),2);
4062: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Destination assignment_set_id::'||to_char(lUPGAssignmentSet),2);
4063: --
4064: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
4065: --
4058: -- IF PG_DEBUG <> 0 THEN
4059: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);
4060: --
4061: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Source assignment_set_id::'||to_char(lMrpAssignmentSet),2);
4062: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Destination assignment_set_id::'||to_char(lUPGAssignmentSet),2);
4063: --
4064: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
4065: --
4066: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
4060: --
4061: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Source assignment_set_id::'||to_char(lMrpAssignmentSet),2);
4062: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Destination assignment_set_id::'||to_char(lUPGAssignmentSet),2);
4063: --
4064: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
4065: --
4066: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
4067: --
4068: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
4062: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Destination assignment_set_id::'||to_char(lUPGAssignmentSet),2);
4063: --
4064: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
4065: --
4066: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
4067: --
4068: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
4069: --
4070: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
4064: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
4065: --
4066: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
4067: --
4068: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
4069: --
4070: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
4071: --
4072: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
4066: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
4067: --
4068: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
4069: --
4070: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
4071: --
4072: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
4073: --
4074: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
4068: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
4069: --
4070: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
4071: --
4072: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
4073: --
4074: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
4075: --
4076: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);
4070: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
4071: --
4072: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
4073: --
4074: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
4075: --
4076: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);
4077: -- END IF;
4078: --
4072: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
4073: --
4074: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
4075: --
4076: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);
4077: -- END IF;
4078: --
4079: -- -- bug 6617686
4080: -- IF pConfigId IS NOT NULL THEN
4105: -- -- end : bug 6617686
4106: --
4107: -- IF lAssignmentExists = 1 THEN
4108: -- IF PG_DEBUG <> 0 THEN
4109: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment exists already, do not recreate',2);
4110: -- END IF;
4111: --
4112: --
4113: --
4118: --
4119: -- EXCEPTION
4120: -- when NO_DATA_FOUND then
4121: -- IF PG_DEBUG <> 0 THEN
4122: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment does not exist, create it',2);
4123: -- END IF;
4124: -- when OTHERS then
4125: -- IF PG_DEBUG <> 0 THEN
4126: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' ||
4122: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment does not exist, create it',2);
4123: -- END IF;
4124: -- when OTHERS then
4125: -- IF PG_DEBUG <> 0 THEN
4126: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' ||
4127: -- 'others exception while checking ifassignment exists, not handling, creating assignment:: '||sqlerrm,2);
4128: -- END IF;
4129: -- END;
4130:
4183: lAssignmentTbl(1).db_flag := NULL;
4184: lAssignmentTbl(1).operation := MRP_Globals.G_OPR_CREATE;
4185:
4186: IF PG_DEBUG <> 0 THEN
4187: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after forming lAssignmentTbl',2);
4188: END IF;
4189:
4190: --
4191: -- form lAssignmentSetRec
4192: --
4193: lStmtNum := 50;
4194: lAssignmentSetRec.operation := MRP_Globals.G_OPR_NONE;
4195: IF PG_DEBUG <> 0 THEN
4196: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after forming lAssignmentSetRec',2);
4197: END IF;
4198:
4199: --
4200: -- call mrp API to insert rec into assignment set
4200: -- call mrp API to insert rec into assignment set
4201: --
4202: lStmtNum := 60;
4203: IF PG_DEBUG <> 0 THEN
4204: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before Process_Assignment',2);
4205: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4206: oe_debug_pub.add('--------------------------------------------------------------------------');
4207: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_ID:' || lAssignmentRec.ASSIGNMENT_ID );
4208: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_SET_ID:' || lAssignmentRec.ASSIGNMENT_SET_ID );
4201: --
4202: lStmtNum := 60;
4203: IF PG_DEBUG <> 0 THEN
4204: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before Process_Assignment',2);
4205: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4206: oe_debug_pub.add('--------------------------------------------------------------------------');
4207: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_ID:' || lAssignmentRec.ASSIGNMENT_ID );
4208: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_SET_ID:' || lAssignmentRec.ASSIGNMENT_SET_ID );
4209: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_TYPE:' || lAssignmentRec.ASSIGNMENT_TYPE );
4202: lStmtNum := 60;
4203: IF PG_DEBUG <> 0 THEN
4204: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before Process_Assignment',2);
4205: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4206: oe_debug_pub.add('--------------------------------------------------------------------------');
4207: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_ID:' || lAssignmentRec.ASSIGNMENT_ID );
4208: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_SET_ID:' || lAssignmentRec.ASSIGNMENT_SET_ID );
4209: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_TYPE:' || lAssignmentRec.ASSIGNMENT_TYPE );
4210: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE1:' || lAssignmentRec.ATTRIBUTE1 );
4203: IF PG_DEBUG <> 0 THEN
4204: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before Process_Assignment',2);
4205: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4206: oe_debug_pub.add('--------------------------------------------------------------------------');
4207: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_ID:' || lAssignmentRec.ASSIGNMENT_ID );
4208: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_SET_ID:' || lAssignmentRec.ASSIGNMENT_SET_ID );
4209: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_TYPE:' || lAssignmentRec.ASSIGNMENT_TYPE );
4210: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE1:' || lAssignmentRec.ATTRIBUTE1 );
4211: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE2:' || lAssignmentRec.ATTRIBUTE2 );
4204: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before Process_Assignment',2);
4205: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4206: oe_debug_pub.add('--------------------------------------------------------------------------');
4207: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_ID:' || lAssignmentRec.ASSIGNMENT_ID );
4208: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_SET_ID:' || lAssignmentRec.ASSIGNMENT_SET_ID );
4209: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_TYPE:' || lAssignmentRec.ASSIGNMENT_TYPE );
4210: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE1:' || lAssignmentRec.ATTRIBUTE1 );
4211: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE2:' || lAssignmentRec.ATTRIBUTE2 );
4212: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE3:' || lAssignmentRec.ATTRIBUTE3 );
4205: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4206: oe_debug_pub.add('--------------------------------------------------------------------------');
4207: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_ID:' || lAssignmentRec.ASSIGNMENT_ID );
4208: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_SET_ID:' || lAssignmentRec.ASSIGNMENT_SET_ID );
4209: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_TYPE:' || lAssignmentRec.ASSIGNMENT_TYPE );
4210: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE1:' || lAssignmentRec.ATTRIBUTE1 );
4211: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE2:' || lAssignmentRec.ATTRIBUTE2 );
4212: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE3:' || lAssignmentRec.ATTRIBUTE3 );
4213: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE4:' || lAssignmentRec.ATTRIBUTE4 );
4206: oe_debug_pub.add('--------------------------------------------------------------------------');
4207: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_ID:' || lAssignmentRec.ASSIGNMENT_ID );
4208: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_SET_ID:' || lAssignmentRec.ASSIGNMENT_SET_ID );
4209: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_TYPE:' || lAssignmentRec.ASSIGNMENT_TYPE );
4210: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE1:' || lAssignmentRec.ATTRIBUTE1 );
4211: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE2:' || lAssignmentRec.ATTRIBUTE2 );
4212: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE3:' || lAssignmentRec.ATTRIBUTE3 );
4213: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE4:' || lAssignmentRec.ATTRIBUTE4 );
4214: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE5:' || lAssignmentRec.ATTRIBUTE5 );
4207: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_ID:' || lAssignmentRec.ASSIGNMENT_ID );
4208: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_SET_ID:' || lAssignmentRec.ASSIGNMENT_SET_ID );
4209: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_TYPE:' || lAssignmentRec.ASSIGNMENT_TYPE );
4210: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE1:' || lAssignmentRec.ATTRIBUTE1 );
4211: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE2:' || lAssignmentRec.ATTRIBUTE2 );
4212: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE3:' || lAssignmentRec.ATTRIBUTE3 );
4213: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE4:' || lAssignmentRec.ATTRIBUTE4 );
4214: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE5:' || lAssignmentRec.ATTRIBUTE5 );
4215: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE6:' || lAssignmentRec.ATTRIBUTE6 );
4208: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_SET_ID:' || lAssignmentRec.ASSIGNMENT_SET_ID );
4209: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_TYPE:' || lAssignmentRec.ASSIGNMENT_TYPE );
4210: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE1:' || lAssignmentRec.ATTRIBUTE1 );
4211: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE2:' || lAssignmentRec.ATTRIBUTE2 );
4212: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE3:' || lAssignmentRec.ATTRIBUTE3 );
4213: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE4:' || lAssignmentRec.ATTRIBUTE4 );
4214: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE5:' || lAssignmentRec.ATTRIBUTE5 );
4215: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE6:' || lAssignmentRec.ATTRIBUTE6 );
4216: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE7:' || lAssignmentRec.ATTRIBUTE7 );
4209: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_TYPE:' || lAssignmentRec.ASSIGNMENT_TYPE );
4210: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE1:' || lAssignmentRec.ATTRIBUTE1 );
4211: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE2:' || lAssignmentRec.ATTRIBUTE2 );
4212: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE3:' || lAssignmentRec.ATTRIBUTE3 );
4213: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE4:' || lAssignmentRec.ATTRIBUTE4 );
4214: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE5:' || lAssignmentRec.ATTRIBUTE5 );
4215: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE6:' || lAssignmentRec.ATTRIBUTE6 );
4216: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE7:' || lAssignmentRec.ATTRIBUTE7 );
4217: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE8:' || lAssignmentRec.ATTRIBUTE8 );
4210: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE1:' || lAssignmentRec.ATTRIBUTE1 );
4211: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE2:' || lAssignmentRec.ATTRIBUTE2 );
4212: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE3:' || lAssignmentRec.ATTRIBUTE3 );
4213: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE4:' || lAssignmentRec.ATTRIBUTE4 );
4214: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE5:' || lAssignmentRec.ATTRIBUTE5 );
4215: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE6:' || lAssignmentRec.ATTRIBUTE6 );
4216: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE7:' || lAssignmentRec.ATTRIBUTE7 );
4217: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE8:' || lAssignmentRec.ATTRIBUTE8 );
4218: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE9:' || lAssignmentRec.ATTRIBUTE9 );
4211: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE2:' || lAssignmentRec.ATTRIBUTE2 );
4212: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE3:' || lAssignmentRec.ATTRIBUTE3 );
4213: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE4:' || lAssignmentRec.ATTRIBUTE4 );
4214: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE5:' || lAssignmentRec.ATTRIBUTE5 );
4215: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE6:' || lAssignmentRec.ATTRIBUTE6 );
4216: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE7:' || lAssignmentRec.ATTRIBUTE7 );
4217: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE8:' || lAssignmentRec.ATTRIBUTE8 );
4218: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE9:' || lAssignmentRec.ATTRIBUTE9 );
4219: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE10:' || lAssignmentRec.ATTRIBUTE10 );
4212: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE3:' || lAssignmentRec.ATTRIBUTE3 );
4213: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE4:' || lAssignmentRec.ATTRIBUTE4 );
4214: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE5:' || lAssignmentRec.ATTRIBUTE5 );
4215: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE6:' || lAssignmentRec.ATTRIBUTE6 );
4216: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE7:' || lAssignmentRec.ATTRIBUTE7 );
4217: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE8:' || lAssignmentRec.ATTRIBUTE8 );
4218: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE9:' || lAssignmentRec.ATTRIBUTE9 );
4219: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE10:' || lAssignmentRec.ATTRIBUTE10 );
4220: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE11:' || lAssignmentRec.ATTRIBUTE11 );
4213: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE4:' || lAssignmentRec.ATTRIBUTE4 );
4214: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE5:' || lAssignmentRec.ATTRIBUTE5 );
4215: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE6:' || lAssignmentRec.ATTRIBUTE6 );
4216: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE7:' || lAssignmentRec.ATTRIBUTE7 );
4217: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE8:' || lAssignmentRec.ATTRIBUTE8 );
4218: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE9:' || lAssignmentRec.ATTRIBUTE9 );
4219: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE10:' || lAssignmentRec.ATTRIBUTE10 );
4220: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE11:' || lAssignmentRec.ATTRIBUTE11 );
4221: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE12:' || lAssignmentRec.ATTRIBUTE12 );
4214: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE5:' || lAssignmentRec.ATTRIBUTE5 );
4215: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE6:' || lAssignmentRec.ATTRIBUTE6 );
4216: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE7:' || lAssignmentRec.ATTRIBUTE7 );
4217: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE8:' || lAssignmentRec.ATTRIBUTE8 );
4218: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE9:' || lAssignmentRec.ATTRIBUTE9 );
4219: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE10:' || lAssignmentRec.ATTRIBUTE10 );
4220: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE11:' || lAssignmentRec.ATTRIBUTE11 );
4221: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE12:' || lAssignmentRec.ATTRIBUTE12 );
4222: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE13:' || lAssignmentRec.ATTRIBUTE13 );
4215: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE6:' || lAssignmentRec.ATTRIBUTE6 );
4216: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE7:' || lAssignmentRec.ATTRIBUTE7 );
4217: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE8:' || lAssignmentRec.ATTRIBUTE8 );
4218: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE9:' || lAssignmentRec.ATTRIBUTE9 );
4219: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE10:' || lAssignmentRec.ATTRIBUTE10 );
4220: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE11:' || lAssignmentRec.ATTRIBUTE11 );
4221: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE12:' || lAssignmentRec.ATTRIBUTE12 );
4222: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE13:' || lAssignmentRec.ATTRIBUTE13 );
4223: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE14:' || lAssignmentRec.ATTRIBUTE14 );
4216: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE7:' || lAssignmentRec.ATTRIBUTE7 );
4217: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE8:' || lAssignmentRec.ATTRIBUTE8 );
4218: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE9:' || lAssignmentRec.ATTRIBUTE9 );
4219: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE10:' || lAssignmentRec.ATTRIBUTE10 );
4220: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE11:' || lAssignmentRec.ATTRIBUTE11 );
4221: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE12:' || lAssignmentRec.ATTRIBUTE12 );
4222: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE13:' || lAssignmentRec.ATTRIBUTE13 );
4223: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE14:' || lAssignmentRec.ATTRIBUTE14 );
4224: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE15:' || lAssignmentRec.ATTRIBUTE15 );
4217: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE8:' || lAssignmentRec.ATTRIBUTE8 );
4218: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE9:' || lAssignmentRec.ATTRIBUTE9 );
4219: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE10:' || lAssignmentRec.ATTRIBUTE10 );
4220: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE11:' || lAssignmentRec.ATTRIBUTE11 );
4221: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE12:' || lAssignmentRec.ATTRIBUTE12 );
4222: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE13:' || lAssignmentRec.ATTRIBUTE13 );
4223: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE14:' || lAssignmentRec.ATTRIBUTE14 );
4224: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE15:' || lAssignmentRec.ATTRIBUTE15 );
4225: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE_CATEGORY:' || lAssignmentRec.ATTRIBUTE_CATEGORY );
4218: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE9:' || lAssignmentRec.ATTRIBUTE9 );
4219: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE10:' || lAssignmentRec.ATTRIBUTE10 );
4220: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE11:' || lAssignmentRec.ATTRIBUTE11 );
4221: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE12:' || lAssignmentRec.ATTRIBUTE12 );
4222: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE13:' || lAssignmentRec.ATTRIBUTE13 );
4223: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE14:' || lAssignmentRec.ATTRIBUTE14 );
4224: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE15:' || lAssignmentRec.ATTRIBUTE15 );
4225: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE_CATEGORY:' || lAssignmentRec.ATTRIBUTE_CATEGORY );
4226: oe_debug_pub.add('lAssignmentRec.CATEGORY_ID:' || lAssignmentRec.CATEGORY_ID );
4219: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE10:' || lAssignmentRec.ATTRIBUTE10 );
4220: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE11:' || lAssignmentRec.ATTRIBUTE11 );
4221: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE12:' || lAssignmentRec.ATTRIBUTE12 );
4222: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE13:' || lAssignmentRec.ATTRIBUTE13 );
4223: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE14:' || lAssignmentRec.ATTRIBUTE14 );
4224: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE15:' || lAssignmentRec.ATTRIBUTE15 );
4225: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE_CATEGORY:' || lAssignmentRec.ATTRIBUTE_CATEGORY );
4226: oe_debug_pub.add('lAssignmentRec.CATEGORY_ID:' || lAssignmentRec.CATEGORY_ID );
4227: oe_debug_pub.add('lAssignmentRec.CATEGORY_SET_ID:' || lAssignmentRec.CATEGORY_SET_ID );
4220: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE11:' || lAssignmentRec.ATTRIBUTE11 );
4221: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE12:' || lAssignmentRec.ATTRIBUTE12 );
4222: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE13:' || lAssignmentRec.ATTRIBUTE13 );
4223: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE14:' || lAssignmentRec.ATTRIBUTE14 );
4224: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE15:' || lAssignmentRec.ATTRIBUTE15 );
4225: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE_CATEGORY:' || lAssignmentRec.ATTRIBUTE_CATEGORY );
4226: oe_debug_pub.add('lAssignmentRec.CATEGORY_ID:' || lAssignmentRec.CATEGORY_ID );
4227: oe_debug_pub.add('lAssignmentRec.CATEGORY_SET_ID:' || lAssignmentRec.CATEGORY_SET_ID );
4228: oe_debug_pub.add('lAssignmentRec.CREATED_BY:' || lAssignmentRec.CREATED_BY );
4221: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE12:' || lAssignmentRec.ATTRIBUTE12 );
4222: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE13:' || lAssignmentRec.ATTRIBUTE13 );
4223: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE14:' || lAssignmentRec.ATTRIBUTE14 );
4224: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE15:' || lAssignmentRec.ATTRIBUTE15 );
4225: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE_CATEGORY:' || lAssignmentRec.ATTRIBUTE_CATEGORY );
4226: oe_debug_pub.add('lAssignmentRec.CATEGORY_ID:' || lAssignmentRec.CATEGORY_ID );
4227: oe_debug_pub.add('lAssignmentRec.CATEGORY_SET_ID:' || lAssignmentRec.CATEGORY_SET_ID );
4228: oe_debug_pub.add('lAssignmentRec.CREATED_BY:' || lAssignmentRec.CREATED_BY );
4229: oe_debug_pub.add('lAssignmentRec.CREATION_DATE:' || lAssignmentRec.CREATION_DATE );
4222: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE13:' || lAssignmentRec.ATTRIBUTE13 );
4223: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE14:' || lAssignmentRec.ATTRIBUTE14 );
4224: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE15:' || lAssignmentRec.ATTRIBUTE15 );
4225: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE_CATEGORY:' || lAssignmentRec.ATTRIBUTE_CATEGORY );
4226: oe_debug_pub.add('lAssignmentRec.CATEGORY_ID:' || lAssignmentRec.CATEGORY_ID );
4227: oe_debug_pub.add('lAssignmentRec.CATEGORY_SET_ID:' || lAssignmentRec.CATEGORY_SET_ID );
4228: oe_debug_pub.add('lAssignmentRec.CREATED_BY:' || lAssignmentRec.CREATED_BY );
4229: oe_debug_pub.add('lAssignmentRec.CREATION_DATE:' || lAssignmentRec.CREATION_DATE );
4230: oe_debug_pub.add('lAssignmentRec.CUSTOMER_ID:' || lAssignmentRec.CUSTOMER_ID );
4223: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE14:' || lAssignmentRec.ATTRIBUTE14 );
4224: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE15:' || lAssignmentRec.ATTRIBUTE15 );
4225: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE_CATEGORY:' || lAssignmentRec.ATTRIBUTE_CATEGORY );
4226: oe_debug_pub.add('lAssignmentRec.CATEGORY_ID:' || lAssignmentRec.CATEGORY_ID );
4227: oe_debug_pub.add('lAssignmentRec.CATEGORY_SET_ID:' || lAssignmentRec.CATEGORY_SET_ID );
4228: oe_debug_pub.add('lAssignmentRec.CREATED_BY:' || lAssignmentRec.CREATED_BY );
4229: oe_debug_pub.add('lAssignmentRec.CREATION_DATE:' || lAssignmentRec.CREATION_DATE );
4230: oe_debug_pub.add('lAssignmentRec.CUSTOMER_ID:' || lAssignmentRec.CUSTOMER_ID );
4231: oe_debug_pub.add('lAssignmentRec.INVENTORY_ITEM_ID:' || lAssignmentRec.INVENTORY_ITEM_ID );
4224: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE15:' || lAssignmentRec.ATTRIBUTE15 );
4225: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE_CATEGORY:' || lAssignmentRec.ATTRIBUTE_CATEGORY );
4226: oe_debug_pub.add('lAssignmentRec.CATEGORY_ID:' || lAssignmentRec.CATEGORY_ID );
4227: oe_debug_pub.add('lAssignmentRec.CATEGORY_SET_ID:' || lAssignmentRec.CATEGORY_SET_ID );
4228: oe_debug_pub.add('lAssignmentRec.CREATED_BY:' || lAssignmentRec.CREATED_BY );
4229: oe_debug_pub.add('lAssignmentRec.CREATION_DATE:' || lAssignmentRec.CREATION_DATE );
4230: oe_debug_pub.add('lAssignmentRec.CUSTOMER_ID:' || lAssignmentRec.CUSTOMER_ID );
4231: oe_debug_pub.add('lAssignmentRec.INVENTORY_ITEM_ID:' || lAssignmentRec.INVENTORY_ITEM_ID );
4232: oe_debug_pub.add('lAssignmentRec.LAST_UPDATED_BY:' || lAssignmentRec.LAST_UPDATED_BY );
4225: oe_debug_pub.add('lAssignmentRec.ATTRIBUTE_CATEGORY:' || lAssignmentRec.ATTRIBUTE_CATEGORY );
4226: oe_debug_pub.add('lAssignmentRec.CATEGORY_ID:' || lAssignmentRec.CATEGORY_ID );
4227: oe_debug_pub.add('lAssignmentRec.CATEGORY_SET_ID:' || lAssignmentRec.CATEGORY_SET_ID );
4228: oe_debug_pub.add('lAssignmentRec.CREATED_BY:' || lAssignmentRec.CREATED_BY );
4229: oe_debug_pub.add('lAssignmentRec.CREATION_DATE:' || lAssignmentRec.CREATION_DATE );
4230: oe_debug_pub.add('lAssignmentRec.CUSTOMER_ID:' || lAssignmentRec.CUSTOMER_ID );
4231: oe_debug_pub.add('lAssignmentRec.INVENTORY_ITEM_ID:' || lAssignmentRec.INVENTORY_ITEM_ID );
4232: oe_debug_pub.add('lAssignmentRec.LAST_UPDATED_BY:' || lAssignmentRec.LAST_UPDATED_BY );
4233: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_DATE:' || lAssignmentRec.LAST_UPDATE_DATE );
4226: oe_debug_pub.add('lAssignmentRec.CATEGORY_ID:' || lAssignmentRec.CATEGORY_ID );
4227: oe_debug_pub.add('lAssignmentRec.CATEGORY_SET_ID:' || lAssignmentRec.CATEGORY_SET_ID );
4228: oe_debug_pub.add('lAssignmentRec.CREATED_BY:' || lAssignmentRec.CREATED_BY );
4229: oe_debug_pub.add('lAssignmentRec.CREATION_DATE:' || lAssignmentRec.CREATION_DATE );
4230: oe_debug_pub.add('lAssignmentRec.CUSTOMER_ID:' || lAssignmentRec.CUSTOMER_ID );
4231: oe_debug_pub.add('lAssignmentRec.INVENTORY_ITEM_ID:' || lAssignmentRec.INVENTORY_ITEM_ID );
4232: oe_debug_pub.add('lAssignmentRec.LAST_UPDATED_BY:' || lAssignmentRec.LAST_UPDATED_BY );
4233: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_DATE:' || lAssignmentRec.LAST_UPDATE_DATE );
4234: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_LOGIN:' || lAssignmentRec.LAST_UPDATE_LOGIN );
4227: oe_debug_pub.add('lAssignmentRec.CATEGORY_SET_ID:' || lAssignmentRec.CATEGORY_SET_ID );
4228: oe_debug_pub.add('lAssignmentRec.CREATED_BY:' || lAssignmentRec.CREATED_BY );
4229: oe_debug_pub.add('lAssignmentRec.CREATION_DATE:' || lAssignmentRec.CREATION_DATE );
4230: oe_debug_pub.add('lAssignmentRec.CUSTOMER_ID:' || lAssignmentRec.CUSTOMER_ID );
4231: oe_debug_pub.add('lAssignmentRec.INVENTORY_ITEM_ID:' || lAssignmentRec.INVENTORY_ITEM_ID );
4232: oe_debug_pub.add('lAssignmentRec.LAST_UPDATED_BY:' || lAssignmentRec.LAST_UPDATED_BY );
4233: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_DATE:' || lAssignmentRec.LAST_UPDATE_DATE );
4234: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_LOGIN:' || lAssignmentRec.LAST_UPDATE_LOGIN );
4235: oe_debug_pub.add('lAssignmentRec.ORGANIZATION_ID:' || lAssignmentRec.ORGANIZATION_ID );
4228: oe_debug_pub.add('lAssignmentRec.CREATED_BY:' || lAssignmentRec.CREATED_BY );
4229: oe_debug_pub.add('lAssignmentRec.CREATION_DATE:' || lAssignmentRec.CREATION_DATE );
4230: oe_debug_pub.add('lAssignmentRec.CUSTOMER_ID:' || lAssignmentRec.CUSTOMER_ID );
4231: oe_debug_pub.add('lAssignmentRec.INVENTORY_ITEM_ID:' || lAssignmentRec.INVENTORY_ITEM_ID );
4232: oe_debug_pub.add('lAssignmentRec.LAST_UPDATED_BY:' || lAssignmentRec.LAST_UPDATED_BY );
4233: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_DATE:' || lAssignmentRec.LAST_UPDATE_DATE );
4234: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_LOGIN:' || lAssignmentRec.LAST_UPDATE_LOGIN );
4235: oe_debug_pub.add('lAssignmentRec.ORGANIZATION_ID:' || lAssignmentRec.ORGANIZATION_ID );
4236: oe_debug_pub.add('lAssignmentRec.PROGRAM_APPLICATION_ID:' || lAssignmentRec.PROGRAM_APPLICATION_ID );
4229: oe_debug_pub.add('lAssignmentRec.CREATION_DATE:' || lAssignmentRec.CREATION_DATE );
4230: oe_debug_pub.add('lAssignmentRec.CUSTOMER_ID:' || lAssignmentRec.CUSTOMER_ID );
4231: oe_debug_pub.add('lAssignmentRec.INVENTORY_ITEM_ID:' || lAssignmentRec.INVENTORY_ITEM_ID );
4232: oe_debug_pub.add('lAssignmentRec.LAST_UPDATED_BY:' || lAssignmentRec.LAST_UPDATED_BY );
4233: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_DATE:' || lAssignmentRec.LAST_UPDATE_DATE );
4234: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_LOGIN:' || lAssignmentRec.LAST_UPDATE_LOGIN );
4235: oe_debug_pub.add('lAssignmentRec.ORGANIZATION_ID:' || lAssignmentRec.ORGANIZATION_ID );
4236: oe_debug_pub.add('lAssignmentRec.PROGRAM_APPLICATION_ID:' || lAssignmentRec.PROGRAM_APPLICATION_ID );
4237: oe_debug_pub.add('lAssignmentRec.PROGRAM_ID:' || lAssignmentRec.PROGRAM_ID );
4230: oe_debug_pub.add('lAssignmentRec.CUSTOMER_ID:' || lAssignmentRec.CUSTOMER_ID );
4231: oe_debug_pub.add('lAssignmentRec.INVENTORY_ITEM_ID:' || lAssignmentRec.INVENTORY_ITEM_ID );
4232: oe_debug_pub.add('lAssignmentRec.LAST_UPDATED_BY:' || lAssignmentRec.LAST_UPDATED_BY );
4233: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_DATE:' || lAssignmentRec.LAST_UPDATE_DATE );
4234: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_LOGIN:' || lAssignmentRec.LAST_UPDATE_LOGIN );
4235: oe_debug_pub.add('lAssignmentRec.ORGANIZATION_ID:' || lAssignmentRec.ORGANIZATION_ID );
4236: oe_debug_pub.add('lAssignmentRec.PROGRAM_APPLICATION_ID:' || lAssignmentRec.PROGRAM_APPLICATION_ID );
4237: oe_debug_pub.add('lAssignmentRec.PROGRAM_ID:' || lAssignmentRec.PROGRAM_ID );
4238: oe_debug_pub.add('lAssignmentRec.PROGRAM_UPDATE_DATE:' || lAssignmentRec.PROGRAM_UPDATE_DATE );
4231: oe_debug_pub.add('lAssignmentRec.INVENTORY_ITEM_ID:' || lAssignmentRec.INVENTORY_ITEM_ID );
4232: oe_debug_pub.add('lAssignmentRec.LAST_UPDATED_BY:' || lAssignmentRec.LAST_UPDATED_BY );
4233: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_DATE:' || lAssignmentRec.LAST_UPDATE_DATE );
4234: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_LOGIN:' || lAssignmentRec.LAST_UPDATE_LOGIN );
4235: oe_debug_pub.add('lAssignmentRec.ORGANIZATION_ID:' || lAssignmentRec.ORGANIZATION_ID );
4236: oe_debug_pub.add('lAssignmentRec.PROGRAM_APPLICATION_ID:' || lAssignmentRec.PROGRAM_APPLICATION_ID );
4237: oe_debug_pub.add('lAssignmentRec.PROGRAM_ID:' || lAssignmentRec.PROGRAM_ID );
4238: oe_debug_pub.add('lAssignmentRec.PROGRAM_UPDATE_DATE:' || lAssignmentRec.PROGRAM_UPDATE_DATE );
4239: oe_debug_pub.add('lAssignmentRec.REQUEST_ID:' || lAssignmentRec.REQUEST_ID );
4232: oe_debug_pub.add('lAssignmentRec.LAST_UPDATED_BY:' || lAssignmentRec.LAST_UPDATED_BY );
4233: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_DATE:' || lAssignmentRec.LAST_UPDATE_DATE );
4234: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_LOGIN:' || lAssignmentRec.LAST_UPDATE_LOGIN );
4235: oe_debug_pub.add('lAssignmentRec.ORGANIZATION_ID:' || lAssignmentRec.ORGANIZATION_ID );
4236: oe_debug_pub.add('lAssignmentRec.PROGRAM_APPLICATION_ID:' || lAssignmentRec.PROGRAM_APPLICATION_ID );
4237: oe_debug_pub.add('lAssignmentRec.PROGRAM_ID:' || lAssignmentRec.PROGRAM_ID );
4238: oe_debug_pub.add('lAssignmentRec.PROGRAM_UPDATE_DATE:' || lAssignmentRec.PROGRAM_UPDATE_DATE );
4239: oe_debug_pub.add('lAssignmentRec.REQUEST_ID:' || lAssignmentRec.REQUEST_ID );
4240: oe_debug_pub.add('lAssignmentRec.SECONDARY_INVENTORY:' || lAssignmentRec.SECONDARY_INVENTORY );
4233: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_DATE:' || lAssignmentRec.LAST_UPDATE_DATE );
4234: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_LOGIN:' || lAssignmentRec.LAST_UPDATE_LOGIN );
4235: oe_debug_pub.add('lAssignmentRec.ORGANIZATION_ID:' || lAssignmentRec.ORGANIZATION_ID );
4236: oe_debug_pub.add('lAssignmentRec.PROGRAM_APPLICATION_ID:' || lAssignmentRec.PROGRAM_APPLICATION_ID );
4237: oe_debug_pub.add('lAssignmentRec.PROGRAM_ID:' || lAssignmentRec.PROGRAM_ID );
4238: oe_debug_pub.add('lAssignmentRec.PROGRAM_UPDATE_DATE:' || lAssignmentRec.PROGRAM_UPDATE_DATE );
4239: oe_debug_pub.add('lAssignmentRec.REQUEST_ID:' || lAssignmentRec.REQUEST_ID );
4240: oe_debug_pub.add('lAssignmentRec.SECONDARY_INVENTORY:' || lAssignmentRec.SECONDARY_INVENTORY );
4241: oe_debug_pub.add('lAssignmentRec.SHIP_TO_SITE_ID:' || lAssignmentRec.SHIP_TO_SITE_ID );
4234: oe_debug_pub.add('lAssignmentRec.LAST_UPDATE_LOGIN:' || lAssignmentRec.LAST_UPDATE_LOGIN );
4235: oe_debug_pub.add('lAssignmentRec.ORGANIZATION_ID:' || lAssignmentRec.ORGANIZATION_ID );
4236: oe_debug_pub.add('lAssignmentRec.PROGRAM_APPLICATION_ID:' || lAssignmentRec.PROGRAM_APPLICATION_ID );
4237: oe_debug_pub.add('lAssignmentRec.PROGRAM_ID:' || lAssignmentRec.PROGRAM_ID );
4238: oe_debug_pub.add('lAssignmentRec.PROGRAM_UPDATE_DATE:' || lAssignmentRec.PROGRAM_UPDATE_DATE );
4239: oe_debug_pub.add('lAssignmentRec.REQUEST_ID:' || lAssignmentRec.REQUEST_ID );
4240: oe_debug_pub.add('lAssignmentRec.SECONDARY_INVENTORY:' || lAssignmentRec.SECONDARY_INVENTORY );
4241: oe_debug_pub.add('lAssignmentRec.SHIP_TO_SITE_ID:' || lAssignmentRec.SHIP_TO_SITE_ID );
4242: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_ID:' || lAssignmentRec.SOURCING_RULE_ID );
4235: oe_debug_pub.add('lAssignmentRec.ORGANIZATION_ID:' || lAssignmentRec.ORGANIZATION_ID );
4236: oe_debug_pub.add('lAssignmentRec.PROGRAM_APPLICATION_ID:' || lAssignmentRec.PROGRAM_APPLICATION_ID );
4237: oe_debug_pub.add('lAssignmentRec.PROGRAM_ID:' || lAssignmentRec.PROGRAM_ID );
4238: oe_debug_pub.add('lAssignmentRec.PROGRAM_UPDATE_DATE:' || lAssignmentRec.PROGRAM_UPDATE_DATE );
4239: oe_debug_pub.add('lAssignmentRec.REQUEST_ID:' || lAssignmentRec.REQUEST_ID );
4240: oe_debug_pub.add('lAssignmentRec.SECONDARY_INVENTORY:' || lAssignmentRec.SECONDARY_INVENTORY );
4241: oe_debug_pub.add('lAssignmentRec.SHIP_TO_SITE_ID:' || lAssignmentRec.SHIP_TO_SITE_ID );
4242: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_ID:' || lAssignmentRec.SOURCING_RULE_ID );
4243: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_TYPE:' || lAssignmentRec.SOURCING_RULE_TYPE );
4236: oe_debug_pub.add('lAssignmentRec.PROGRAM_APPLICATION_ID:' || lAssignmentRec.PROGRAM_APPLICATION_ID );
4237: oe_debug_pub.add('lAssignmentRec.PROGRAM_ID:' || lAssignmentRec.PROGRAM_ID );
4238: oe_debug_pub.add('lAssignmentRec.PROGRAM_UPDATE_DATE:' || lAssignmentRec.PROGRAM_UPDATE_DATE );
4239: oe_debug_pub.add('lAssignmentRec.REQUEST_ID:' || lAssignmentRec.REQUEST_ID );
4240: oe_debug_pub.add('lAssignmentRec.SECONDARY_INVENTORY:' || lAssignmentRec.SECONDARY_INVENTORY );
4241: oe_debug_pub.add('lAssignmentRec.SHIP_TO_SITE_ID:' || lAssignmentRec.SHIP_TO_SITE_ID );
4242: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_ID:' || lAssignmentRec.SOURCING_RULE_ID );
4243: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_TYPE:' || lAssignmentRec.SOURCING_RULE_TYPE );
4244: oe_debug_pub.add('lAssignmentRec.OPERATION:' || lAssignmentRec.OPERATION );
4237: oe_debug_pub.add('lAssignmentRec.PROGRAM_ID:' || lAssignmentRec.PROGRAM_ID );
4238: oe_debug_pub.add('lAssignmentRec.PROGRAM_UPDATE_DATE:' || lAssignmentRec.PROGRAM_UPDATE_DATE );
4239: oe_debug_pub.add('lAssignmentRec.REQUEST_ID:' || lAssignmentRec.REQUEST_ID );
4240: oe_debug_pub.add('lAssignmentRec.SECONDARY_INVENTORY:' || lAssignmentRec.SECONDARY_INVENTORY );
4241: oe_debug_pub.add('lAssignmentRec.SHIP_TO_SITE_ID:' || lAssignmentRec.SHIP_TO_SITE_ID );
4242: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_ID:' || lAssignmentRec.SOURCING_RULE_ID );
4243: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_TYPE:' || lAssignmentRec.SOURCING_RULE_TYPE );
4244: oe_debug_pub.add('lAssignmentRec.OPERATION:' || lAssignmentRec.OPERATION );
4245: oe_debug_pub.add('--------------------------------------------------------------------------');
4238: oe_debug_pub.add('lAssignmentRec.PROGRAM_UPDATE_DATE:' || lAssignmentRec.PROGRAM_UPDATE_DATE );
4239: oe_debug_pub.add('lAssignmentRec.REQUEST_ID:' || lAssignmentRec.REQUEST_ID );
4240: oe_debug_pub.add('lAssignmentRec.SECONDARY_INVENTORY:' || lAssignmentRec.SECONDARY_INVENTORY );
4241: oe_debug_pub.add('lAssignmentRec.SHIP_TO_SITE_ID:' || lAssignmentRec.SHIP_TO_SITE_ID );
4242: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_ID:' || lAssignmentRec.SOURCING_RULE_ID );
4243: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_TYPE:' || lAssignmentRec.SOURCING_RULE_TYPE );
4244: oe_debug_pub.add('lAssignmentRec.OPERATION:' || lAssignmentRec.OPERATION );
4245: oe_debug_pub.add('--------------------------------------------------------------------------');
4246: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4239: oe_debug_pub.add('lAssignmentRec.REQUEST_ID:' || lAssignmentRec.REQUEST_ID );
4240: oe_debug_pub.add('lAssignmentRec.SECONDARY_INVENTORY:' || lAssignmentRec.SECONDARY_INVENTORY );
4241: oe_debug_pub.add('lAssignmentRec.SHIP_TO_SITE_ID:' || lAssignmentRec.SHIP_TO_SITE_ID );
4242: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_ID:' || lAssignmentRec.SOURCING_RULE_ID );
4243: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_TYPE:' || lAssignmentRec.SOURCING_RULE_TYPE );
4244: oe_debug_pub.add('lAssignmentRec.OPERATION:' || lAssignmentRec.OPERATION );
4245: oe_debug_pub.add('--------------------------------------------------------------------------');
4246: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4247: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4240: oe_debug_pub.add('lAssignmentRec.SECONDARY_INVENTORY:' || lAssignmentRec.SECONDARY_INVENTORY );
4241: oe_debug_pub.add('lAssignmentRec.SHIP_TO_SITE_ID:' || lAssignmentRec.SHIP_TO_SITE_ID );
4242: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_ID:' || lAssignmentRec.SOURCING_RULE_ID );
4243: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_TYPE:' || lAssignmentRec.SOURCING_RULE_TYPE );
4244: oe_debug_pub.add('lAssignmentRec.OPERATION:' || lAssignmentRec.OPERATION );
4245: oe_debug_pub.add('--------------------------------------------------------------------------');
4246: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4247: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4248: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Id:' || lAssignmentTbl(1).Assignment_Id);
4241: oe_debug_pub.add('lAssignmentRec.SHIP_TO_SITE_ID:' || lAssignmentRec.SHIP_TO_SITE_ID );
4242: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_ID:' || lAssignmentRec.SOURCING_RULE_ID );
4243: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_TYPE:' || lAssignmentRec.SOURCING_RULE_TYPE );
4244: oe_debug_pub.add('lAssignmentRec.OPERATION:' || lAssignmentRec.OPERATION );
4245: oe_debug_pub.add('--------------------------------------------------------------------------');
4246: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4247: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4248: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Id:' || lAssignmentTbl(1).Assignment_Id);
4249: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Set_Id:' || lAssignmentTbl(1).Assignment_Set_Id);
4242: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_ID:' || lAssignmentRec.SOURCING_RULE_ID );
4243: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_TYPE:' || lAssignmentRec.SOURCING_RULE_TYPE );
4244: oe_debug_pub.add('lAssignmentRec.OPERATION:' || lAssignmentRec.OPERATION );
4245: oe_debug_pub.add('--------------------------------------------------------------------------');
4246: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4247: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4248: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Id:' || lAssignmentTbl(1).Assignment_Id);
4249: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Set_Id:' || lAssignmentTbl(1).Assignment_Set_Id);
4250: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Type:' || lAssignmentTbl(1).Assignment_Type);
4243: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_TYPE:' || lAssignmentRec.SOURCING_RULE_TYPE );
4244: oe_debug_pub.add('lAssignmentRec.OPERATION:' || lAssignmentRec.OPERATION );
4245: oe_debug_pub.add('--------------------------------------------------------------------------');
4246: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4247: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4248: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Id:' || lAssignmentTbl(1).Assignment_Id);
4249: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Set_Id:' || lAssignmentTbl(1).Assignment_Set_Id);
4250: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Type:' || lAssignmentTbl(1).Assignment_Type);
4251: oe_debug_pub.add('lAssignmentTbl(1).Attribute1:' || lAssignmentTbl(1).Attribute1);
4244: oe_debug_pub.add('lAssignmentRec.OPERATION:' || lAssignmentRec.OPERATION );
4245: oe_debug_pub.add('--------------------------------------------------------------------------');
4246: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4247: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4248: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Id:' || lAssignmentTbl(1).Assignment_Id);
4249: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Set_Id:' || lAssignmentTbl(1).Assignment_Set_Id);
4250: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Type:' || lAssignmentTbl(1).Assignment_Type);
4251: oe_debug_pub.add('lAssignmentTbl(1).Attribute1:' || lAssignmentTbl(1).Attribute1);
4252: oe_debug_pub.add('lAssignmentTbl(1).Attribute10:' || lAssignmentTbl(1).Attribute10);
4245: oe_debug_pub.add('--------------------------------------------------------------------------');
4246: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4247: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4248: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Id:' || lAssignmentTbl(1).Assignment_Id);
4249: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Set_Id:' || lAssignmentTbl(1).Assignment_Set_Id);
4250: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Type:' || lAssignmentTbl(1).Assignment_Type);
4251: oe_debug_pub.add('lAssignmentTbl(1).Attribute1:' || lAssignmentTbl(1).Attribute1);
4252: oe_debug_pub.add('lAssignmentTbl(1).Attribute10:' || lAssignmentTbl(1).Attribute10);
4253: oe_debug_pub.add('lAssignmentTbl(1).Attribute11:' || lAssignmentTbl(1).Attribute11);
4246: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4247: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4248: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Id:' || lAssignmentTbl(1).Assignment_Id);
4249: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Set_Id:' || lAssignmentTbl(1).Assignment_Set_Id);
4250: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Type:' || lAssignmentTbl(1).Assignment_Type);
4251: oe_debug_pub.add('lAssignmentTbl(1).Attribute1:' || lAssignmentTbl(1).Attribute1);
4252: oe_debug_pub.add('lAssignmentTbl(1).Attribute10:' || lAssignmentTbl(1).Attribute10);
4253: oe_debug_pub.add('lAssignmentTbl(1).Attribute11:' || lAssignmentTbl(1).Attribute11);
4254: oe_debug_pub.add('lAssignmentTbl(1).Attribute12:' || lAssignmentTbl(1).Attribute12);
4247: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4248: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Id:' || lAssignmentTbl(1).Assignment_Id);
4249: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Set_Id:' || lAssignmentTbl(1).Assignment_Set_Id);
4250: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Type:' || lAssignmentTbl(1).Assignment_Type);
4251: oe_debug_pub.add('lAssignmentTbl(1).Attribute1:' || lAssignmentTbl(1).Attribute1);
4252: oe_debug_pub.add('lAssignmentTbl(1).Attribute10:' || lAssignmentTbl(1).Attribute10);
4253: oe_debug_pub.add('lAssignmentTbl(1).Attribute11:' || lAssignmentTbl(1).Attribute11);
4254: oe_debug_pub.add('lAssignmentTbl(1).Attribute12:' || lAssignmentTbl(1).Attribute12);
4255: oe_debug_pub.add('lAssignmentTbl(1).Attribute13:' || lAssignmentTbl(1).Attribute13);
4248: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Id:' || lAssignmentTbl(1).Assignment_Id);
4249: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Set_Id:' || lAssignmentTbl(1).Assignment_Set_Id);
4250: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Type:' || lAssignmentTbl(1).Assignment_Type);
4251: oe_debug_pub.add('lAssignmentTbl(1).Attribute1:' || lAssignmentTbl(1).Attribute1);
4252: oe_debug_pub.add('lAssignmentTbl(1).Attribute10:' || lAssignmentTbl(1).Attribute10);
4253: oe_debug_pub.add('lAssignmentTbl(1).Attribute11:' || lAssignmentTbl(1).Attribute11);
4254: oe_debug_pub.add('lAssignmentTbl(1).Attribute12:' || lAssignmentTbl(1).Attribute12);
4255: oe_debug_pub.add('lAssignmentTbl(1).Attribute13:' || lAssignmentTbl(1).Attribute13);
4256: oe_debug_pub.add('lAssignmentTbl(1).Attribute14:' || lAssignmentTbl(1).Attribute14);
4249: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Set_Id:' || lAssignmentTbl(1).Assignment_Set_Id);
4250: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Type:' || lAssignmentTbl(1).Assignment_Type);
4251: oe_debug_pub.add('lAssignmentTbl(1).Attribute1:' || lAssignmentTbl(1).Attribute1);
4252: oe_debug_pub.add('lAssignmentTbl(1).Attribute10:' || lAssignmentTbl(1).Attribute10);
4253: oe_debug_pub.add('lAssignmentTbl(1).Attribute11:' || lAssignmentTbl(1).Attribute11);
4254: oe_debug_pub.add('lAssignmentTbl(1).Attribute12:' || lAssignmentTbl(1).Attribute12);
4255: oe_debug_pub.add('lAssignmentTbl(1).Attribute13:' || lAssignmentTbl(1).Attribute13);
4256: oe_debug_pub.add('lAssignmentTbl(1).Attribute14:' || lAssignmentTbl(1).Attribute14);
4257: oe_debug_pub.add('lAssignmentTbl(1).Attribute15:' || lAssignmentTbl(1).Attribute15);
4250: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Type:' || lAssignmentTbl(1).Assignment_Type);
4251: oe_debug_pub.add('lAssignmentTbl(1).Attribute1:' || lAssignmentTbl(1).Attribute1);
4252: oe_debug_pub.add('lAssignmentTbl(1).Attribute10:' || lAssignmentTbl(1).Attribute10);
4253: oe_debug_pub.add('lAssignmentTbl(1).Attribute11:' || lAssignmentTbl(1).Attribute11);
4254: oe_debug_pub.add('lAssignmentTbl(1).Attribute12:' || lAssignmentTbl(1).Attribute12);
4255: oe_debug_pub.add('lAssignmentTbl(1).Attribute13:' || lAssignmentTbl(1).Attribute13);
4256: oe_debug_pub.add('lAssignmentTbl(1).Attribute14:' || lAssignmentTbl(1).Attribute14);
4257: oe_debug_pub.add('lAssignmentTbl(1).Attribute15:' || lAssignmentTbl(1).Attribute15);
4258: oe_debug_pub.add('lAssignmentTbl(1).Attribute2:' || lAssignmentTbl(1).Attribute2);
4251: oe_debug_pub.add('lAssignmentTbl(1).Attribute1:' || lAssignmentTbl(1).Attribute1);
4252: oe_debug_pub.add('lAssignmentTbl(1).Attribute10:' || lAssignmentTbl(1).Attribute10);
4253: oe_debug_pub.add('lAssignmentTbl(1).Attribute11:' || lAssignmentTbl(1).Attribute11);
4254: oe_debug_pub.add('lAssignmentTbl(1).Attribute12:' || lAssignmentTbl(1).Attribute12);
4255: oe_debug_pub.add('lAssignmentTbl(1).Attribute13:' || lAssignmentTbl(1).Attribute13);
4256: oe_debug_pub.add('lAssignmentTbl(1).Attribute14:' || lAssignmentTbl(1).Attribute14);
4257: oe_debug_pub.add('lAssignmentTbl(1).Attribute15:' || lAssignmentTbl(1).Attribute15);
4258: oe_debug_pub.add('lAssignmentTbl(1).Attribute2:' || lAssignmentTbl(1).Attribute2);
4259: oe_debug_pub.add('lAssignmentTbl(1).Attribute3:' || lAssignmentTbl(1).Attribute3);
4252: oe_debug_pub.add('lAssignmentTbl(1).Attribute10:' || lAssignmentTbl(1).Attribute10);
4253: oe_debug_pub.add('lAssignmentTbl(1).Attribute11:' || lAssignmentTbl(1).Attribute11);
4254: oe_debug_pub.add('lAssignmentTbl(1).Attribute12:' || lAssignmentTbl(1).Attribute12);
4255: oe_debug_pub.add('lAssignmentTbl(1).Attribute13:' || lAssignmentTbl(1).Attribute13);
4256: oe_debug_pub.add('lAssignmentTbl(1).Attribute14:' || lAssignmentTbl(1).Attribute14);
4257: oe_debug_pub.add('lAssignmentTbl(1).Attribute15:' || lAssignmentTbl(1).Attribute15);
4258: oe_debug_pub.add('lAssignmentTbl(1).Attribute2:' || lAssignmentTbl(1).Attribute2);
4259: oe_debug_pub.add('lAssignmentTbl(1).Attribute3:' || lAssignmentTbl(1).Attribute3);
4260: oe_debug_pub.add('lAssignmentTbl(1).Attribute4:' || lAssignmentTbl(1).Attribute4);
4253: oe_debug_pub.add('lAssignmentTbl(1).Attribute11:' || lAssignmentTbl(1).Attribute11);
4254: oe_debug_pub.add('lAssignmentTbl(1).Attribute12:' || lAssignmentTbl(1).Attribute12);
4255: oe_debug_pub.add('lAssignmentTbl(1).Attribute13:' || lAssignmentTbl(1).Attribute13);
4256: oe_debug_pub.add('lAssignmentTbl(1).Attribute14:' || lAssignmentTbl(1).Attribute14);
4257: oe_debug_pub.add('lAssignmentTbl(1).Attribute15:' || lAssignmentTbl(1).Attribute15);
4258: oe_debug_pub.add('lAssignmentTbl(1).Attribute2:' || lAssignmentTbl(1).Attribute2);
4259: oe_debug_pub.add('lAssignmentTbl(1).Attribute3:' || lAssignmentTbl(1).Attribute3);
4260: oe_debug_pub.add('lAssignmentTbl(1).Attribute4:' || lAssignmentTbl(1).Attribute4);
4261: oe_debug_pub.add('lAssignmentTbl(1).Attribute5:' || lAssignmentTbl(1).Attribute5);
4254: oe_debug_pub.add('lAssignmentTbl(1).Attribute12:' || lAssignmentTbl(1).Attribute12);
4255: oe_debug_pub.add('lAssignmentTbl(1).Attribute13:' || lAssignmentTbl(1).Attribute13);
4256: oe_debug_pub.add('lAssignmentTbl(1).Attribute14:' || lAssignmentTbl(1).Attribute14);
4257: oe_debug_pub.add('lAssignmentTbl(1).Attribute15:' || lAssignmentTbl(1).Attribute15);
4258: oe_debug_pub.add('lAssignmentTbl(1).Attribute2:' || lAssignmentTbl(1).Attribute2);
4259: oe_debug_pub.add('lAssignmentTbl(1).Attribute3:' || lAssignmentTbl(1).Attribute3);
4260: oe_debug_pub.add('lAssignmentTbl(1).Attribute4:' || lAssignmentTbl(1).Attribute4);
4261: oe_debug_pub.add('lAssignmentTbl(1).Attribute5:' || lAssignmentTbl(1).Attribute5);
4262: oe_debug_pub.add('lAssignmentTbl(1).Attribute6:' || lAssignmentTbl(1).Attribute6);
4255: oe_debug_pub.add('lAssignmentTbl(1).Attribute13:' || lAssignmentTbl(1).Attribute13);
4256: oe_debug_pub.add('lAssignmentTbl(1).Attribute14:' || lAssignmentTbl(1).Attribute14);
4257: oe_debug_pub.add('lAssignmentTbl(1).Attribute15:' || lAssignmentTbl(1).Attribute15);
4258: oe_debug_pub.add('lAssignmentTbl(1).Attribute2:' || lAssignmentTbl(1).Attribute2);
4259: oe_debug_pub.add('lAssignmentTbl(1).Attribute3:' || lAssignmentTbl(1).Attribute3);
4260: oe_debug_pub.add('lAssignmentTbl(1).Attribute4:' || lAssignmentTbl(1).Attribute4);
4261: oe_debug_pub.add('lAssignmentTbl(1).Attribute5:' || lAssignmentTbl(1).Attribute5);
4262: oe_debug_pub.add('lAssignmentTbl(1).Attribute6:' || lAssignmentTbl(1).Attribute6);
4263: oe_debug_pub.add('lAssignmentTbl(1).Attribute7:' || lAssignmentTbl(1).Attribute7);
4256: oe_debug_pub.add('lAssignmentTbl(1).Attribute14:' || lAssignmentTbl(1).Attribute14);
4257: oe_debug_pub.add('lAssignmentTbl(1).Attribute15:' || lAssignmentTbl(1).Attribute15);
4258: oe_debug_pub.add('lAssignmentTbl(1).Attribute2:' || lAssignmentTbl(1).Attribute2);
4259: oe_debug_pub.add('lAssignmentTbl(1).Attribute3:' || lAssignmentTbl(1).Attribute3);
4260: oe_debug_pub.add('lAssignmentTbl(1).Attribute4:' || lAssignmentTbl(1).Attribute4);
4261: oe_debug_pub.add('lAssignmentTbl(1).Attribute5:' || lAssignmentTbl(1).Attribute5);
4262: oe_debug_pub.add('lAssignmentTbl(1).Attribute6:' || lAssignmentTbl(1).Attribute6);
4263: oe_debug_pub.add('lAssignmentTbl(1).Attribute7:' || lAssignmentTbl(1).Attribute7);
4264: oe_debug_pub.add('lAssignmentTbl(1).Attribute8:' || lAssignmentTbl(1).Attribute8);
4257: oe_debug_pub.add('lAssignmentTbl(1).Attribute15:' || lAssignmentTbl(1).Attribute15);
4258: oe_debug_pub.add('lAssignmentTbl(1).Attribute2:' || lAssignmentTbl(1).Attribute2);
4259: oe_debug_pub.add('lAssignmentTbl(1).Attribute3:' || lAssignmentTbl(1).Attribute3);
4260: oe_debug_pub.add('lAssignmentTbl(1).Attribute4:' || lAssignmentTbl(1).Attribute4);
4261: oe_debug_pub.add('lAssignmentTbl(1).Attribute5:' || lAssignmentTbl(1).Attribute5);
4262: oe_debug_pub.add('lAssignmentTbl(1).Attribute6:' || lAssignmentTbl(1).Attribute6);
4263: oe_debug_pub.add('lAssignmentTbl(1).Attribute7:' || lAssignmentTbl(1).Attribute7);
4264: oe_debug_pub.add('lAssignmentTbl(1).Attribute8:' || lAssignmentTbl(1).Attribute8);
4265: oe_debug_pub.add('lAssignmentTbl(1).Attribute9:' || lAssignmentTbl(1).Attribute9);
4258: oe_debug_pub.add('lAssignmentTbl(1).Attribute2:' || lAssignmentTbl(1).Attribute2);
4259: oe_debug_pub.add('lAssignmentTbl(1).Attribute3:' || lAssignmentTbl(1).Attribute3);
4260: oe_debug_pub.add('lAssignmentTbl(1).Attribute4:' || lAssignmentTbl(1).Attribute4);
4261: oe_debug_pub.add('lAssignmentTbl(1).Attribute5:' || lAssignmentTbl(1).Attribute5);
4262: oe_debug_pub.add('lAssignmentTbl(1).Attribute6:' || lAssignmentTbl(1).Attribute6);
4263: oe_debug_pub.add('lAssignmentTbl(1).Attribute7:' || lAssignmentTbl(1).Attribute7);
4264: oe_debug_pub.add('lAssignmentTbl(1).Attribute8:' || lAssignmentTbl(1).Attribute8);
4265: oe_debug_pub.add('lAssignmentTbl(1).Attribute9:' || lAssignmentTbl(1).Attribute9);
4266: oe_debug_pub.add('lAssignmentTbl(1).Attribute_Category:' || lAssignmentTbl(1).Attribute_Category);
4259: oe_debug_pub.add('lAssignmentTbl(1).Attribute3:' || lAssignmentTbl(1).Attribute3);
4260: oe_debug_pub.add('lAssignmentTbl(1).Attribute4:' || lAssignmentTbl(1).Attribute4);
4261: oe_debug_pub.add('lAssignmentTbl(1).Attribute5:' || lAssignmentTbl(1).Attribute5);
4262: oe_debug_pub.add('lAssignmentTbl(1).Attribute6:' || lAssignmentTbl(1).Attribute6);
4263: oe_debug_pub.add('lAssignmentTbl(1).Attribute7:' || lAssignmentTbl(1).Attribute7);
4264: oe_debug_pub.add('lAssignmentTbl(1).Attribute8:' || lAssignmentTbl(1).Attribute8);
4265: oe_debug_pub.add('lAssignmentTbl(1).Attribute9:' || lAssignmentTbl(1).Attribute9);
4266: oe_debug_pub.add('lAssignmentTbl(1).Attribute_Category:' || lAssignmentTbl(1).Attribute_Category);
4267: oe_debug_pub.add('lAssignmentTbl(1).Category_Id:' || lAssignmentTbl(1).Category_Id);
4260: oe_debug_pub.add('lAssignmentTbl(1).Attribute4:' || lAssignmentTbl(1).Attribute4);
4261: oe_debug_pub.add('lAssignmentTbl(1).Attribute5:' || lAssignmentTbl(1).Attribute5);
4262: oe_debug_pub.add('lAssignmentTbl(1).Attribute6:' || lAssignmentTbl(1).Attribute6);
4263: oe_debug_pub.add('lAssignmentTbl(1).Attribute7:' || lAssignmentTbl(1).Attribute7);
4264: oe_debug_pub.add('lAssignmentTbl(1).Attribute8:' || lAssignmentTbl(1).Attribute8);
4265: oe_debug_pub.add('lAssignmentTbl(1).Attribute9:' || lAssignmentTbl(1).Attribute9);
4266: oe_debug_pub.add('lAssignmentTbl(1).Attribute_Category:' || lAssignmentTbl(1).Attribute_Category);
4267: oe_debug_pub.add('lAssignmentTbl(1).Category_Id:' || lAssignmentTbl(1).Category_Id);
4268: oe_debug_pub.add('lAssignmentTbl(1).Category_Set_Id:' || lAssignmentTbl(1).Category_Set_Id);
4261: oe_debug_pub.add('lAssignmentTbl(1).Attribute5:' || lAssignmentTbl(1).Attribute5);
4262: oe_debug_pub.add('lAssignmentTbl(1).Attribute6:' || lAssignmentTbl(1).Attribute6);
4263: oe_debug_pub.add('lAssignmentTbl(1).Attribute7:' || lAssignmentTbl(1).Attribute7);
4264: oe_debug_pub.add('lAssignmentTbl(1).Attribute8:' || lAssignmentTbl(1).Attribute8);
4265: oe_debug_pub.add('lAssignmentTbl(1).Attribute9:' || lAssignmentTbl(1).Attribute9);
4266: oe_debug_pub.add('lAssignmentTbl(1).Attribute_Category:' || lAssignmentTbl(1).Attribute_Category);
4267: oe_debug_pub.add('lAssignmentTbl(1).Category_Id:' || lAssignmentTbl(1).Category_Id);
4268: oe_debug_pub.add('lAssignmentTbl(1).Category_Set_Id:' || lAssignmentTbl(1).Category_Set_Id);
4269: oe_debug_pub.add('lAssignmentTbl(1).Created_By:' || lAssignmentTbl(1).Created_By);
4262: oe_debug_pub.add('lAssignmentTbl(1).Attribute6:' || lAssignmentTbl(1).Attribute6);
4263: oe_debug_pub.add('lAssignmentTbl(1).Attribute7:' || lAssignmentTbl(1).Attribute7);
4264: oe_debug_pub.add('lAssignmentTbl(1).Attribute8:' || lAssignmentTbl(1).Attribute8);
4265: oe_debug_pub.add('lAssignmentTbl(1).Attribute9:' || lAssignmentTbl(1).Attribute9);
4266: oe_debug_pub.add('lAssignmentTbl(1).Attribute_Category:' || lAssignmentTbl(1).Attribute_Category);
4267: oe_debug_pub.add('lAssignmentTbl(1).Category_Id:' || lAssignmentTbl(1).Category_Id);
4268: oe_debug_pub.add('lAssignmentTbl(1).Category_Set_Id:' || lAssignmentTbl(1).Category_Set_Id);
4269: oe_debug_pub.add('lAssignmentTbl(1).Created_By:' || lAssignmentTbl(1).Created_By);
4270: oe_debug_pub.add('lAssignmentTbl(1).Creation_Date:' || lAssignmentTbl(1).Creation_Date);
4263: oe_debug_pub.add('lAssignmentTbl(1).Attribute7:' || lAssignmentTbl(1).Attribute7);
4264: oe_debug_pub.add('lAssignmentTbl(1).Attribute8:' || lAssignmentTbl(1).Attribute8);
4265: oe_debug_pub.add('lAssignmentTbl(1).Attribute9:' || lAssignmentTbl(1).Attribute9);
4266: oe_debug_pub.add('lAssignmentTbl(1).Attribute_Category:' || lAssignmentTbl(1).Attribute_Category);
4267: oe_debug_pub.add('lAssignmentTbl(1).Category_Id:' || lAssignmentTbl(1).Category_Id);
4268: oe_debug_pub.add('lAssignmentTbl(1).Category_Set_Id:' || lAssignmentTbl(1).Category_Set_Id);
4269: oe_debug_pub.add('lAssignmentTbl(1).Created_By:' || lAssignmentTbl(1).Created_By);
4270: oe_debug_pub.add('lAssignmentTbl(1).Creation_Date:' || lAssignmentTbl(1).Creation_Date);
4271: oe_debug_pub.add('lAssignmentTbl(1).Customer_Id:' || lAssignmentTbl(1).Customer_Id);
4264: oe_debug_pub.add('lAssignmentTbl(1).Attribute8:' || lAssignmentTbl(1).Attribute8);
4265: oe_debug_pub.add('lAssignmentTbl(1).Attribute9:' || lAssignmentTbl(1).Attribute9);
4266: oe_debug_pub.add('lAssignmentTbl(1).Attribute_Category:' || lAssignmentTbl(1).Attribute_Category);
4267: oe_debug_pub.add('lAssignmentTbl(1).Category_Id:' || lAssignmentTbl(1).Category_Id);
4268: oe_debug_pub.add('lAssignmentTbl(1).Category_Set_Id:' || lAssignmentTbl(1).Category_Set_Id);
4269: oe_debug_pub.add('lAssignmentTbl(1).Created_By:' || lAssignmentTbl(1).Created_By);
4270: oe_debug_pub.add('lAssignmentTbl(1).Creation_Date:' || lAssignmentTbl(1).Creation_Date);
4271: oe_debug_pub.add('lAssignmentTbl(1).Customer_Id:' || lAssignmentTbl(1).Customer_Id);
4272: oe_debug_pub.add('lAssignmentTbl(1).Inventory_Item_Id:' || lAssignmentTbl(1).Inventory_Item_Id);
4265: oe_debug_pub.add('lAssignmentTbl(1).Attribute9:' || lAssignmentTbl(1).Attribute9);
4266: oe_debug_pub.add('lAssignmentTbl(1).Attribute_Category:' || lAssignmentTbl(1).Attribute_Category);
4267: oe_debug_pub.add('lAssignmentTbl(1).Category_Id:' || lAssignmentTbl(1).Category_Id);
4268: oe_debug_pub.add('lAssignmentTbl(1).Category_Set_Id:' || lAssignmentTbl(1).Category_Set_Id);
4269: oe_debug_pub.add('lAssignmentTbl(1).Created_By:' || lAssignmentTbl(1).Created_By);
4270: oe_debug_pub.add('lAssignmentTbl(1).Creation_Date:' || lAssignmentTbl(1).Creation_Date);
4271: oe_debug_pub.add('lAssignmentTbl(1).Customer_Id:' || lAssignmentTbl(1).Customer_Id);
4272: oe_debug_pub.add('lAssignmentTbl(1).Inventory_Item_Id:' || lAssignmentTbl(1).Inventory_Item_Id);
4273: oe_debug_pub.add('lAssignmentTbl(1).Last_Updated_By:' || lAssignmentTbl(1).Last_Updated_By);
4266: oe_debug_pub.add('lAssignmentTbl(1).Attribute_Category:' || lAssignmentTbl(1).Attribute_Category);
4267: oe_debug_pub.add('lAssignmentTbl(1).Category_Id:' || lAssignmentTbl(1).Category_Id);
4268: oe_debug_pub.add('lAssignmentTbl(1).Category_Set_Id:' || lAssignmentTbl(1).Category_Set_Id);
4269: oe_debug_pub.add('lAssignmentTbl(1).Created_By:' || lAssignmentTbl(1).Created_By);
4270: oe_debug_pub.add('lAssignmentTbl(1).Creation_Date:' || lAssignmentTbl(1).Creation_Date);
4271: oe_debug_pub.add('lAssignmentTbl(1).Customer_Id:' || lAssignmentTbl(1).Customer_Id);
4272: oe_debug_pub.add('lAssignmentTbl(1).Inventory_Item_Id:' || lAssignmentTbl(1).Inventory_Item_Id);
4273: oe_debug_pub.add('lAssignmentTbl(1).Last_Updated_By:' || lAssignmentTbl(1).Last_Updated_By);
4274: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Date:' || lAssignmentTbl(1).Last_Update_Date);
4267: oe_debug_pub.add('lAssignmentTbl(1).Category_Id:' || lAssignmentTbl(1).Category_Id);
4268: oe_debug_pub.add('lAssignmentTbl(1).Category_Set_Id:' || lAssignmentTbl(1).Category_Set_Id);
4269: oe_debug_pub.add('lAssignmentTbl(1).Created_By:' || lAssignmentTbl(1).Created_By);
4270: oe_debug_pub.add('lAssignmentTbl(1).Creation_Date:' || lAssignmentTbl(1).Creation_Date);
4271: oe_debug_pub.add('lAssignmentTbl(1).Customer_Id:' || lAssignmentTbl(1).Customer_Id);
4272: oe_debug_pub.add('lAssignmentTbl(1).Inventory_Item_Id:' || lAssignmentTbl(1).Inventory_Item_Id);
4273: oe_debug_pub.add('lAssignmentTbl(1).Last_Updated_By:' || lAssignmentTbl(1).Last_Updated_By);
4274: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Date:' || lAssignmentTbl(1).Last_Update_Date);
4275: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Login:' || lAssignmentTbl(1).Last_Update_Login);
4268: oe_debug_pub.add('lAssignmentTbl(1).Category_Set_Id:' || lAssignmentTbl(1).Category_Set_Id);
4269: oe_debug_pub.add('lAssignmentTbl(1).Created_By:' || lAssignmentTbl(1).Created_By);
4270: oe_debug_pub.add('lAssignmentTbl(1).Creation_Date:' || lAssignmentTbl(1).Creation_Date);
4271: oe_debug_pub.add('lAssignmentTbl(1).Customer_Id:' || lAssignmentTbl(1).Customer_Id);
4272: oe_debug_pub.add('lAssignmentTbl(1).Inventory_Item_Id:' || lAssignmentTbl(1).Inventory_Item_Id);
4273: oe_debug_pub.add('lAssignmentTbl(1).Last_Updated_By:' || lAssignmentTbl(1).Last_Updated_By);
4274: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Date:' || lAssignmentTbl(1).Last_Update_Date);
4275: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Login:' || lAssignmentTbl(1).Last_Update_Login);
4276: oe_debug_pub.add('lAssignmentTbl(1).Organization_Id:' || lAssignmentTbl(1).Organization_Id);
4269: oe_debug_pub.add('lAssignmentTbl(1).Created_By:' || lAssignmentTbl(1).Created_By);
4270: oe_debug_pub.add('lAssignmentTbl(1).Creation_Date:' || lAssignmentTbl(1).Creation_Date);
4271: oe_debug_pub.add('lAssignmentTbl(1).Customer_Id:' || lAssignmentTbl(1).Customer_Id);
4272: oe_debug_pub.add('lAssignmentTbl(1).Inventory_Item_Id:' || lAssignmentTbl(1).Inventory_Item_Id);
4273: oe_debug_pub.add('lAssignmentTbl(1).Last_Updated_By:' || lAssignmentTbl(1).Last_Updated_By);
4274: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Date:' || lAssignmentTbl(1).Last_Update_Date);
4275: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Login:' || lAssignmentTbl(1).Last_Update_Login);
4276: oe_debug_pub.add('lAssignmentTbl(1).Organization_Id:' || lAssignmentTbl(1).Organization_Id);
4277: oe_debug_pub.add('lAssignmentTbl(1).Program_Application_Id:' || lAssignmentTbl(1).Program_Application_Id);
4270: oe_debug_pub.add('lAssignmentTbl(1).Creation_Date:' || lAssignmentTbl(1).Creation_Date);
4271: oe_debug_pub.add('lAssignmentTbl(1).Customer_Id:' || lAssignmentTbl(1).Customer_Id);
4272: oe_debug_pub.add('lAssignmentTbl(1).Inventory_Item_Id:' || lAssignmentTbl(1).Inventory_Item_Id);
4273: oe_debug_pub.add('lAssignmentTbl(1).Last_Updated_By:' || lAssignmentTbl(1).Last_Updated_By);
4274: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Date:' || lAssignmentTbl(1).Last_Update_Date);
4275: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Login:' || lAssignmentTbl(1).Last_Update_Login);
4276: oe_debug_pub.add('lAssignmentTbl(1).Organization_Id:' || lAssignmentTbl(1).Organization_Id);
4277: oe_debug_pub.add('lAssignmentTbl(1).Program_Application_Id:' || lAssignmentTbl(1).Program_Application_Id);
4278: oe_debug_pub.add('lAssignmentTbl(1).Program_Id:' || lAssignmentTbl(1).Program_Id);
4271: oe_debug_pub.add('lAssignmentTbl(1).Customer_Id:' || lAssignmentTbl(1).Customer_Id);
4272: oe_debug_pub.add('lAssignmentTbl(1).Inventory_Item_Id:' || lAssignmentTbl(1).Inventory_Item_Id);
4273: oe_debug_pub.add('lAssignmentTbl(1).Last_Updated_By:' || lAssignmentTbl(1).Last_Updated_By);
4274: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Date:' || lAssignmentTbl(1).Last_Update_Date);
4275: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Login:' || lAssignmentTbl(1).Last_Update_Login);
4276: oe_debug_pub.add('lAssignmentTbl(1).Organization_Id:' || lAssignmentTbl(1).Organization_Id);
4277: oe_debug_pub.add('lAssignmentTbl(1).Program_Application_Id:' || lAssignmentTbl(1).Program_Application_Id);
4278: oe_debug_pub.add('lAssignmentTbl(1).Program_Id:' || lAssignmentTbl(1).Program_Id);
4279: oe_debug_pub.add('lAssignmentTbl(1).Program_Update_Date:' || lAssignmentTbl(1).Program_Update_Date);
4272: oe_debug_pub.add('lAssignmentTbl(1).Inventory_Item_Id:' || lAssignmentTbl(1).Inventory_Item_Id);
4273: oe_debug_pub.add('lAssignmentTbl(1).Last_Updated_By:' || lAssignmentTbl(1).Last_Updated_By);
4274: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Date:' || lAssignmentTbl(1).Last_Update_Date);
4275: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Login:' || lAssignmentTbl(1).Last_Update_Login);
4276: oe_debug_pub.add('lAssignmentTbl(1).Organization_Id:' || lAssignmentTbl(1).Organization_Id);
4277: oe_debug_pub.add('lAssignmentTbl(1).Program_Application_Id:' || lAssignmentTbl(1).Program_Application_Id);
4278: oe_debug_pub.add('lAssignmentTbl(1).Program_Id:' || lAssignmentTbl(1).Program_Id);
4279: oe_debug_pub.add('lAssignmentTbl(1).Program_Update_Date:' || lAssignmentTbl(1).Program_Update_Date);
4280: oe_debug_pub.add('lAssignmentTbl(1).Request_Id:' || lAssignmentTbl(1).Request_Id);
4273: oe_debug_pub.add('lAssignmentTbl(1).Last_Updated_By:' || lAssignmentTbl(1).Last_Updated_By);
4274: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Date:' || lAssignmentTbl(1).Last_Update_Date);
4275: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Login:' || lAssignmentTbl(1).Last_Update_Login);
4276: oe_debug_pub.add('lAssignmentTbl(1).Organization_Id:' || lAssignmentTbl(1).Organization_Id);
4277: oe_debug_pub.add('lAssignmentTbl(1).Program_Application_Id:' || lAssignmentTbl(1).Program_Application_Id);
4278: oe_debug_pub.add('lAssignmentTbl(1).Program_Id:' || lAssignmentTbl(1).Program_Id);
4279: oe_debug_pub.add('lAssignmentTbl(1).Program_Update_Date:' || lAssignmentTbl(1).Program_Update_Date);
4280: oe_debug_pub.add('lAssignmentTbl(1).Request_Id:' || lAssignmentTbl(1).Request_Id);
4281: oe_debug_pub.add('lAssignmentTbl(1).Secondary_Inventory:' || lAssignmentTbl(1).Secondary_Inventory);
4274: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Date:' || lAssignmentTbl(1).Last_Update_Date);
4275: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Login:' || lAssignmentTbl(1).Last_Update_Login);
4276: oe_debug_pub.add('lAssignmentTbl(1).Organization_Id:' || lAssignmentTbl(1).Organization_Id);
4277: oe_debug_pub.add('lAssignmentTbl(1).Program_Application_Id:' || lAssignmentTbl(1).Program_Application_Id);
4278: oe_debug_pub.add('lAssignmentTbl(1).Program_Id:' || lAssignmentTbl(1).Program_Id);
4279: oe_debug_pub.add('lAssignmentTbl(1).Program_Update_Date:' || lAssignmentTbl(1).Program_Update_Date);
4280: oe_debug_pub.add('lAssignmentTbl(1).Request_Id:' || lAssignmentTbl(1).Request_Id);
4281: oe_debug_pub.add('lAssignmentTbl(1).Secondary_Inventory:' || lAssignmentTbl(1).Secondary_Inventory);
4282: oe_debug_pub.add('lAssignmentTbl(1).Ship_To_Site_Id:' || lAssignmentTbl(1).Ship_To_Site_Id);
4275: oe_debug_pub.add('lAssignmentTbl(1).Last_Update_Login:' || lAssignmentTbl(1).Last_Update_Login);
4276: oe_debug_pub.add('lAssignmentTbl(1).Organization_Id:' || lAssignmentTbl(1).Organization_Id);
4277: oe_debug_pub.add('lAssignmentTbl(1).Program_Application_Id:' || lAssignmentTbl(1).Program_Application_Id);
4278: oe_debug_pub.add('lAssignmentTbl(1).Program_Id:' || lAssignmentTbl(1).Program_Id);
4279: oe_debug_pub.add('lAssignmentTbl(1).Program_Update_Date:' || lAssignmentTbl(1).Program_Update_Date);
4280: oe_debug_pub.add('lAssignmentTbl(1).Request_Id:' || lAssignmentTbl(1).Request_Id);
4281: oe_debug_pub.add('lAssignmentTbl(1).Secondary_Inventory:' || lAssignmentTbl(1).Secondary_Inventory);
4282: oe_debug_pub.add('lAssignmentTbl(1).Ship_To_Site_Id:' || lAssignmentTbl(1).Ship_To_Site_Id);
4283: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Id:' || lAssignmentTbl(1).Sourcing_Rule_Id);
4276: oe_debug_pub.add('lAssignmentTbl(1).Organization_Id:' || lAssignmentTbl(1).Organization_Id);
4277: oe_debug_pub.add('lAssignmentTbl(1).Program_Application_Id:' || lAssignmentTbl(1).Program_Application_Id);
4278: oe_debug_pub.add('lAssignmentTbl(1).Program_Id:' || lAssignmentTbl(1).Program_Id);
4279: oe_debug_pub.add('lAssignmentTbl(1).Program_Update_Date:' || lAssignmentTbl(1).Program_Update_Date);
4280: oe_debug_pub.add('lAssignmentTbl(1).Request_Id:' || lAssignmentTbl(1).Request_Id);
4281: oe_debug_pub.add('lAssignmentTbl(1).Secondary_Inventory:' || lAssignmentTbl(1).Secondary_Inventory);
4282: oe_debug_pub.add('lAssignmentTbl(1).Ship_To_Site_Id:' || lAssignmentTbl(1).Ship_To_Site_Id);
4283: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Id:' || lAssignmentTbl(1).Sourcing_Rule_Id);
4284: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Type:' || lAssignmentTbl(1).Sourcing_Rule_Type);
4277: oe_debug_pub.add('lAssignmentTbl(1).Program_Application_Id:' || lAssignmentTbl(1).Program_Application_Id);
4278: oe_debug_pub.add('lAssignmentTbl(1).Program_Id:' || lAssignmentTbl(1).Program_Id);
4279: oe_debug_pub.add('lAssignmentTbl(1).Program_Update_Date:' || lAssignmentTbl(1).Program_Update_Date);
4280: oe_debug_pub.add('lAssignmentTbl(1).Request_Id:' || lAssignmentTbl(1).Request_Id);
4281: oe_debug_pub.add('lAssignmentTbl(1).Secondary_Inventory:' || lAssignmentTbl(1).Secondary_Inventory);
4282: oe_debug_pub.add('lAssignmentTbl(1).Ship_To_Site_Id:' || lAssignmentTbl(1).Ship_To_Site_Id);
4283: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Id:' || lAssignmentTbl(1).Sourcing_Rule_Id);
4284: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Type:' || lAssignmentTbl(1).Sourcing_Rule_Type);
4285: oe_debug_pub.add('lAssignmentTbl(1).return_status:' || lAssignmentTbl(1).return_status);
4278: oe_debug_pub.add('lAssignmentTbl(1).Program_Id:' || lAssignmentTbl(1).Program_Id);
4279: oe_debug_pub.add('lAssignmentTbl(1).Program_Update_Date:' || lAssignmentTbl(1).Program_Update_Date);
4280: oe_debug_pub.add('lAssignmentTbl(1).Request_Id:' || lAssignmentTbl(1).Request_Id);
4281: oe_debug_pub.add('lAssignmentTbl(1).Secondary_Inventory:' || lAssignmentTbl(1).Secondary_Inventory);
4282: oe_debug_pub.add('lAssignmentTbl(1).Ship_To_Site_Id:' || lAssignmentTbl(1).Ship_To_Site_Id);
4283: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Id:' || lAssignmentTbl(1).Sourcing_Rule_Id);
4284: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Type:' || lAssignmentTbl(1).Sourcing_Rule_Type);
4285: oe_debug_pub.add('lAssignmentTbl(1).return_status:' || lAssignmentTbl(1).return_status);
4286: oe_debug_pub.add('lAssignmentTbl(1).db_flag:' || lAssignmentTbl(1).db_flag);
4279: oe_debug_pub.add('lAssignmentTbl(1).Program_Update_Date:' || lAssignmentTbl(1).Program_Update_Date);
4280: oe_debug_pub.add('lAssignmentTbl(1).Request_Id:' || lAssignmentTbl(1).Request_Id);
4281: oe_debug_pub.add('lAssignmentTbl(1).Secondary_Inventory:' || lAssignmentTbl(1).Secondary_Inventory);
4282: oe_debug_pub.add('lAssignmentTbl(1).Ship_To_Site_Id:' || lAssignmentTbl(1).Ship_To_Site_Id);
4283: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Id:' || lAssignmentTbl(1).Sourcing_Rule_Id);
4284: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Type:' || lAssignmentTbl(1).Sourcing_Rule_Type);
4285: oe_debug_pub.add('lAssignmentTbl(1).return_status:' || lAssignmentTbl(1).return_status);
4286: oe_debug_pub.add('lAssignmentTbl(1).db_flag:' || lAssignmentTbl(1).db_flag);
4287: oe_debug_pub.add('lAssignmentTbl(1).operation:' || lAssignmentTbl(1).operation);
4280: oe_debug_pub.add('lAssignmentTbl(1).Request_Id:' || lAssignmentTbl(1).Request_Id);
4281: oe_debug_pub.add('lAssignmentTbl(1).Secondary_Inventory:' || lAssignmentTbl(1).Secondary_Inventory);
4282: oe_debug_pub.add('lAssignmentTbl(1).Ship_To_Site_Id:' || lAssignmentTbl(1).Ship_To_Site_Id);
4283: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Id:' || lAssignmentTbl(1).Sourcing_Rule_Id);
4284: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Type:' || lAssignmentTbl(1).Sourcing_Rule_Type);
4285: oe_debug_pub.add('lAssignmentTbl(1).return_status:' || lAssignmentTbl(1).return_status);
4286: oe_debug_pub.add('lAssignmentTbl(1).db_flag:' || lAssignmentTbl(1).db_flag);
4287: oe_debug_pub.add('lAssignmentTbl(1).operation:' || lAssignmentTbl(1).operation);
4288: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4281: oe_debug_pub.add('lAssignmentTbl(1).Secondary_Inventory:' || lAssignmentTbl(1).Secondary_Inventory);
4282: oe_debug_pub.add('lAssignmentTbl(1).Ship_To_Site_Id:' || lAssignmentTbl(1).Ship_To_Site_Id);
4283: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Id:' || lAssignmentTbl(1).Sourcing_Rule_Id);
4284: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Type:' || lAssignmentTbl(1).Sourcing_Rule_Type);
4285: oe_debug_pub.add('lAssignmentTbl(1).return_status:' || lAssignmentTbl(1).return_status);
4286: oe_debug_pub.add('lAssignmentTbl(1).db_flag:' || lAssignmentTbl(1).db_flag);
4287: oe_debug_pub.add('lAssignmentTbl(1).operation:' || lAssignmentTbl(1).operation);
4288: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4289: END IF;
4282: oe_debug_pub.add('lAssignmentTbl(1).Ship_To_Site_Id:' || lAssignmentTbl(1).Ship_To_Site_Id);
4283: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Id:' || lAssignmentTbl(1).Sourcing_Rule_Id);
4284: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Type:' || lAssignmentTbl(1).Sourcing_Rule_Type);
4285: oe_debug_pub.add('lAssignmentTbl(1).return_status:' || lAssignmentTbl(1).return_status);
4286: oe_debug_pub.add('lAssignmentTbl(1).db_flag:' || lAssignmentTbl(1).db_flag);
4287: oe_debug_pub.add('lAssignmentTbl(1).operation:' || lAssignmentTbl(1).operation);
4288: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4289: END IF;
4290:
4283: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Id:' || lAssignmentTbl(1).Sourcing_Rule_Id);
4284: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Type:' || lAssignmentTbl(1).Sourcing_Rule_Type);
4285: oe_debug_pub.add('lAssignmentTbl(1).return_status:' || lAssignmentTbl(1).return_status);
4286: oe_debug_pub.add('lAssignmentTbl(1).db_flag:' || lAssignmentTbl(1).db_flag);
4287: oe_debug_pub.add('lAssignmentTbl(1).operation:' || lAssignmentTbl(1).operation);
4288: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4289: END IF;
4290:
4291: -- currently, not passing commented out parameters, need to
4284: oe_debug_pub.add('lAssignmentTbl(1).Sourcing_Rule_Type:' || lAssignmentTbl(1).Sourcing_Rule_Type);
4285: oe_debug_pub.add('lAssignmentTbl(1).return_status:' || lAssignmentTbl(1).return_status);
4286: oe_debug_pub.add('lAssignmentTbl(1).db_flag:' || lAssignmentTbl(1).db_flag);
4287: oe_debug_pub.add('lAssignmentTbl(1).operation:' || lAssignmentTbl(1).operation);
4288: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4289: END IF;
4290:
4291: -- currently, not passing commented out parameters, need to
4292: -- confirm with raghu, confirmed with stupe
4310: );
4311:
4312: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4313: IF PG_DEBUG <> 0 THEN
4314: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
4315: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'l_msg_data::'||l_msg_data,1);
4316: END IF;
4317: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4318:
4311:
4312: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4313: IF PG_DEBUG <> 0 THEN
4314: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
4315: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'l_msg_data::'||l_msg_data,1);
4316: END IF;
4317: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4318:
4319: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4317: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4318:
4319: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4320: IF PG_DEBUG <> 0 THEN
4321: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);
4322: END IF;
4323:
4324:
4325: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: count:'||l_msg_count , 1 );
4321: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);
4322: END IF;
4323:
4324:
4325: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: count:'||l_msg_count , 1 );
4326:
4327: IF l_msg_count > 0 THEN
4328: FOR l_index IN 1..l_msg_count LOOP
4329: l_msg_data := fnd_msg_pub.get(
4329: l_msg_data := fnd_msg_pub.get(
4330: p_msg_index => l_index,
4331: p_encoded => FND_API.G_FALSE);
4332:
4333: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );
4334: END LOOP;
4335:
4336: oe_debug_pub.add(' CTO_MSUTIL_PUB.create_sourcing_rules: MSG:'|| xAssignmentSetRec.return_status);
4337: END IF;
4332:
4333: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );
4334: END LOOP;
4335:
4336: oe_debug_pub.add(' CTO_MSUTIL_PUB.create_sourcing_rules: MSG:'|| xAssignmentSetRec.return_status);
4337: END IF;
4338:
4339: oe_debug_pub.add('Failure!' , 1 );
4340:
4335:
4336: oe_debug_pub.add(' CTO_MSUTIL_PUB.create_sourcing_rules: MSG:'|| xAssignmentSetRec.return_status);
4337: END IF;
4338:
4339: oe_debug_pub.add('Failure!' , 1 );
4340:
4341:
4342: raise FND_API.G_EXC_ERROR;
4343:
4342: raise FND_API.G_EXC_ERROR;
4343:
4344: END IF;
4345: IF PG_DEBUG <> 0 THEN
4346: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'success in process_assignment',2);
4347: END IF;
4348:
4349:
4350: lStmtNum := 70;
4348:
4349:
4350: lStmtNum := 70;
4351:
4352: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before end_of_loop',2);
4353: <
4354: null ;
4355: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after end_of_loop',2);
4356: END LOOP;
4351:
4352: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before end_of_loop',2);
4353: <
4354: null ;
4355: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after end_of_loop',2);
4356: END LOOP;
4357:
4358:
4359: if( c_type3_assignments%rowcount = 0 ) then
4357:
4358:
4359: if( c_type3_assignments%rowcount = 0 ) then
4360:
4361: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'no sourcing assignments ',2);
4362:
4363: end if;
4364:
4365: lStmtNum := 80;
4363: end if;
4364:
4365: lStmtNum := 80;
4366:
4367: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before close c_type3_assignments ',2);
4368:
4369: close c_type3_assignments ;
4370:
4371: --debugging for bug 13362916
4368:
4369: close c_type3_assignments ;
4370:
4371: --debugging for bug 13362916
4372: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++');
4373: oe_debug_pub.add('printing config assignment values');
4374: FOR v_config_assignments in c_config_assignments(lMrpAssignmentSet, pConfigId) LOOP
4375: oe_debug_pub.add('set_id:' || v_config_assignments.assignment_set_id ||
4376: '::type::' || v_config_assignments.assignment_type ||
4369: close c_type3_assignments ;
4370:
4371: --debugging for bug 13362916
4372: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++');
4373: oe_debug_pub.add('printing config assignment values');
4374: FOR v_config_assignments in c_config_assignments(lMrpAssignmentSet, pConfigId) LOOP
4375: oe_debug_pub.add('set_id:' || v_config_assignments.assignment_set_id ||
4376: '::type::' || v_config_assignments.assignment_type ||
4377: '::org::' || v_config_assignments.organization_id ||
4371: --debugging for bug 13362916
4372: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++');
4373: oe_debug_pub.add('printing config assignment values');
4374: FOR v_config_assignments in c_config_assignments(lMrpAssignmentSet, pConfigId) LOOP
4375: oe_debug_pub.add('set_id:' || v_config_assignments.assignment_set_id ||
4376: '::type::' || v_config_assignments.assignment_type ||
4377: '::org::' || v_config_assignments.organization_id ||
4378: '::cust::' || v_config_assignments.customer_id ||
4379: '::ship::' || v_config_assignments.ship_to_site_id ||
4379: '::ship::' || v_config_assignments.ship_to_site_id ||
4380: '::rule_type::' || v_config_assignments.sourcing_rule_type ||
4381: '::cat::' || v_config_assignments.category_id);
4382: END LOOP;
4383: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++');
4384: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Exit Create_TYPE3_Sourcing_Rules.');
4385: --end debugging for bug 13051516
4386:
4387: EXCEPTION
4380: '::rule_type::' || v_config_assignments.sourcing_rule_type ||
4381: '::cat::' || v_config_assignments.category_id);
4382: END LOOP;
4383: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++');
4384: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Exit Create_TYPE3_Sourcing_Rules.');
4385: --end debugging for bug 13051516
4386:
4387: EXCEPTION
4388: When NO_sourcing_defined THEN
4389: null;
4390:
4391: when FND_API.G_EXC_ERROR then
4392: IF PG_DEBUG <> 0 THEN
4393: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
4394: END IF;
4395: x_return_status := FND_API.G_RET_STS_ERROR;
4396: CTO_MSG_PUB.Count_And_Get
4397: (p_msg_count => x_msg_count
4399: );
4400:
4401: when FND_API.G_EXC_UNEXPECTED_ERROR then
4402: IF PG_DEBUG <> 0 THEN
4403: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
4404: END IF;
4405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4406: CTO_MSG_PUB.Count_And_Get
4407: (p_msg_count => x_msg_count
4409: );
4410:
4411: when OTHERS then
4412: IF PG_DEBUG <> 0 THEN
4413: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);
4414: END IF;
4415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4417: FND_MSG_PUB.Add_Exc_Msg
4458:
4459: IF( gMrpAssignmentSet is null )
4460: THEN
4461: IF PG_DEBUG <> 0 THEN
4462: oe_debug_pub.add('initialize_assignment_set: ' || '**$$ Default assignment set is null', 1);
4463: END IF;
4464:
4465: ELSE
4466: IF PG_DEBUG <> 0 THEN
4463: END IF;
4464:
4465: ELSE
4466: IF PG_DEBUG <> 0 THEN
4467: oe_debug_pub.add('initialize_assignment_set: ' || 'Default assignment set is '||to_char(gMrpAssignmentSet),2);
4468: END IF;
4469:
4470: l_stmt_num := 10 ;
4471:
4478:
4479: exception
4480: when no_data_found then
4481: IF PG_DEBUG <> 0 THEN
4482: oe_debug_pub.add('initialize_assignment_set: ' || 'The assignment set pointed by the
4483: profile MRP_DEFAULT_ASSIGNMENT_SET
4484: does not exist in the database ' ,1);
4485: END IF;
4486:
4491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4492: end ;
4493:
4494: IF PG_DEBUG <> 0 THEN
4495: oe_debug_pub.add('initialize_assignment_set: ' || 'Default assignment set name is '||
4496: assign_set_name ,2);
4497: END IF;
4498:
4499: END IF;
4503: when INVALID_MRP_ASSIGNMENT_SET then
4504: x_return_status := FND_API.G_RET_STS_ERROR;
4505:
4506: IF PG_DEBUG <> 0 THEN
4507: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::INVALID ASSIGNMENT SET ::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
4508: END IF;
4509:
4510:
4511: when FND_API.G_EXC_UNEXPECTED_ERROR then
4510:
4511: when FND_API.G_EXC_UNEXPECTED_ERROR then
4512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4513: IF PG_DEBUG <> 0 THEN
4514: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
4515: END IF;
4516:
4517:
4518: when OTHERS then
4517:
4518: when OTHERS then
4519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4520: IF PG_DEBUG <> 0 THEN
4521: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::others::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
4522: END IF;
4523:
4524:
4525: END initialize_assignment_set ;
4535: i number ;
4536: v_source_type_code varchar2(20) ;
4537: begin
4538:
4539: oe_debug_pub.add( '$$$ insert val into bcso ' , 1 ) ;
4540: oe_debug_pub.add( '$$$ VAL ORGS count ' || p_t_org_list.count , 1 ) ;
4541:
4542:
4543:
4536: v_source_type_code varchar2(20) ;
4537: begin
4538:
4539: oe_debug_pub.add( '$$$ insert val into bcso ' , 1 ) ;
4540: oe_debug_pub.add( '$$$ VAL ORGS count ' || p_t_org_list.count , 1 ) ;
4541:
4542:
4543:
4544: begin
4549: when others then
4550: v_source_type_code := 'INTERNAL' ;
4551: end ;
4552:
4553: oe_debug_pub.add( '$$$ source type code ' || v_source_type_code , 1 ) ;
4554:
4555:
4556:
4557: if( p_t_org_list.count > 0 ) then
4561:
4562: while i is not null
4563: loop
4564:
4565: oe_debug_pub.add( '$$$ VAL ORGS ' || p_t_org_list(i) , 1 ) ;
4566:
4567: insert into bom_cto_src_orgs_b
4568: (
4569: top_model_line_id,
4637: v_source_type_code varchar2(20) ;
4638:
4639: begin
4640:
4641: oe_debug_pub.add( '$$$ insert all into bcso ' , 1 ) ;
4642:
4643:
4644: begin
4645: select source_type_code into v_source_type_code
4649: when others then
4650: v_source_type_code := 'INTERNAL' ;
4651: end ;
4652:
4653: oe_debug_pub.add( '$$$ source type code ' || v_source_type_code , 1 ) ;
4654:
4655:
4656:
4657:
4711: and organization_id = msi.organization_id );
4712:
4713:
4714:
4715: oe_debug_pub.add( '$$$ insert all into bcso ' || SQL%rowcount , 1 ) ;
4716:
4717: end insert_all_into_bcso ;
4718:
4719:
4725: , p_config_item_id in NUMBER default null )
4726: is
4727: begin
4728:
4729: oe_debug_pub.add( '$$$ insert type3 bcso ' , 1 ) ;
4730:
4731:
4732: insert into bom_cto_src_orgs_b
4733: (
4788:
4789:
4790:
4791:
4792: oe_debug_pub.add( '$$$ insert type3 bcso ' || SQL%rowcount , 1 ) ;
4793:
4794: end insert_type3_bcso ;
4795:
4796:
4802: is
4803: v_group_reference_id number(10);
4804: begin
4805:
4806: oe_debug_pub.add( '$$$ insert type3 bcmo bcso ' , 1 ) ;
4807:
4808: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4809:
4810:
4868: */
4869:
4870:
4871:
4872: oe_debug_pub.add( '$$$ insert type3 bcmo bcmo ' || SQL%rowcount , 1 ) ;
4873:
4874: insert into bom_cto_src_orgs_b
4875: (
4876: top_model_line_id,
4922: where line_id = p_model_line_id );
4923:
4924:
4925:
4926: oe_debug_pub.add( '$$$ insert type3 bcmo bcso ' || SQL%rowcount , 1 ) ;
4927:
4928:
4929:
4930:
4943: v_group_reference_id number(10);
4944: lCnt number; --debug 10240482
4945: begin
4946:
4947: oe_debug_pub.add( '$$$ insert type3 referenced bcso ' , 1 ) ;
4948:
4949: --debug 10240482
4950: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_top_ato_line_id:' || p_top_ato_line_id) ;
4951: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_model_line_id:' || p_model_line_id) ;
4946:
4947: oe_debug_pub.add( '$$$ insert type3 referenced bcso ' , 1 ) ;
4948:
4949: --debug 10240482
4950: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_top_ato_line_id:' || p_top_ato_line_id) ;
4951: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_model_line_id:' || p_model_line_id) ;
4952: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_model_item_id:' || p_model_item_id) ;
4953: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_config_item_id:' || p_config_item_id) ;
4954: --debug end
4947: oe_debug_pub.add( '$$$ insert type3 referenced bcso ' , 1 ) ;
4948:
4949: --debug 10240482
4950: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_top_ato_line_id:' || p_top_ato_line_id) ;
4951: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_model_line_id:' || p_model_line_id) ;
4952: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_model_item_id:' || p_model_item_id) ;
4953: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_config_item_id:' || p_config_item_id) ;
4954: --debug end
4955:
4948:
4949: --debug 10240482
4950: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_top_ato_line_id:' || p_top_ato_line_id) ;
4951: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_model_line_id:' || p_model_line_id) ;
4952: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_model_item_id:' || p_model_item_id) ;
4953: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_config_item_id:' || p_config_item_id) ;
4954: --debug end
4955:
4956: begin
4949: --debug 10240482
4950: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_top_ato_line_id:' || p_top_ato_line_id) ;
4951: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_model_line_id:' || p_model_line_id) ;
4952: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_model_item_id:' || p_model_item_id) ;
4953: oe_debug_pub.add( '$$$ insert type3 referenced bcso: p_config_item_id:' || p_config_item_id) ;
4954: --debug end
4955:
4956: begin
4957: select group_reference_id into v_group_reference_id from bom_cto_model_orgs
4960:
4961: exception
4962: when no_data_found then
4963:
4964: oe_debug_pub.add( '$$$ short circuit for type3 referenced bcso ' , 1 ) ;
4965: select bom_cto_model_orgs_s1.nextval into v_group_reference_id from dual ;
4966:
4967:
4968:
5018: and msi.organization_id = bp.organization_id (+) /* added for bug 3504744 */;
5019:
5020: --debug 10240482
5021: lCnt := sql%rowcount;
5022: oe_debug_pub.add('$$$ insert type3 referenced bcso: Rows in bcmo:' || lCnt , 1 ) ;
5023:
5024:
5025:
5026: when others then
5083: where line_id = p_model_line_id );
5084:
5085: --debug 10240482
5086: lCnt := sql%rowcount;
5087: oe_debug_pub.add('$$$ insert type3 referenced bcso: Rows in bcso:' || lCnt , 1 ) ;
5088: --oe_debug_pub.add( '$$$ insert type3 referenced bcso ' || SQL%rowcount , 1 ) ;
5089:
5090:
5091:
5084:
5085: --debug 10240482
5086: lCnt := sql%rowcount;
5087: oe_debug_pub.add('$$$ insert type3 referenced bcso: Rows in bcso:' || lCnt , 1 ) ;
5088: --oe_debug_pub.add( '$$$ insert type3 referenced bcso ' || SQL%rowcount , 1 ) ;
5089:
5090:
5091:
5092:
5235: if xOrgLst.count > 0 then
5236: for x1 in xOrgLst.FIRST..xOrgLst.LAST loop
5237:
5238: IF PG_DEBUG <> 0 THEN
5239: oe_debug_pub.add ('get_other_orgs:'||'OE and PO Validation Orgs ('||x1||') = '||xOrglst(x1),5);
5240: END IF;
5241:
5242: end loop;
5243: end if;
5296:
5297: while ( z is not null ) loop
5298:
5299: IF PG_DEBUG <> 0 THEN
5300: oe_debug_pub.add ('get_other_orgs:'||'Vendor ID '||l_model_vendors(z).vendor_id,5);
5301: oe_debug_pub.add ('get_other_orgs:'||'Vendor Site ID '||l_model_vendors(z).vendor_site_id,5);
5302: oe_debug_pub.add ('get_other_orgs:'||'ASL ID '||l_model_vendors(z).asl_id,5);
5303:
5304: END IF;
5297: while ( z is not null ) loop
5298:
5299: IF PG_DEBUG <> 0 THEN
5300: oe_debug_pub.add ('get_other_orgs:'||'Vendor ID '||l_model_vendors(z).vendor_id,5);
5301: oe_debug_pub.add ('get_other_orgs:'||'Vendor Site ID '||l_model_vendors(z).vendor_site_id,5);
5302: oe_debug_pub.add ('get_other_orgs:'||'ASL ID '||l_model_vendors(z).asl_id,5);
5303:
5304: END IF;
5305:
5298:
5299: IF PG_DEBUG <> 0 THEN
5300: oe_debug_pub.add ('get_other_orgs:'||'Vendor ID '||l_model_vendors(z).vendor_id,5);
5301: oe_debug_pub.add ('get_other_orgs:'||'Vendor Site ID '||l_model_vendors(z).vendor_site_id,5);
5302: oe_debug_pub.add ('get_other_orgs:'||'ASL ID '||l_model_vendors(z).asl_id,5);
5303:
5304: END IF;
5305:
5306: PO_AUTOSOURCE_SV.blanket_document_sourcing(
5328: x_msg_data => x_msg_data);
5329:
5330: IF PG_DEBUG <> 0 THEN
5331:
5332: oe_debug_pub.add ('get_other_orgs:'||'Doc Header ID '||l_doc_header_id,5);
5333:
5334: END IF;
5335:
5336: if l_doc_return = 'Y' then
5335:
5336: if l_doc_return = 'Y' then
5337:
5338: IF PG_DEBUG <> 0 THEN
5339: oe_debug_pub.add('get_other_orgs:'|| 'Valid Blanket found for config ..',5);
5340: END IF;
5341:
5342: else
5343: IF PG_DEBUG <> 0 THEN
5340: END IF;
5341:
5342: else
5343: IF PG_DEBUG <> 0 THEN
5344: oe_debug_pub.add('get_other_orgs:' || 'Valid Blanket not found for this config',5);
5345: END IF;
5346:
5347: exit;
5348:
5362:
5363:
5364: -- bugfix 3348635
5365: IF PG_DEBUG <> 0 THEN
5366: oe_debug_pub.add('get_other_orgs:' || 'Ga Flag: '||l_ga_flag||' :: Owning Org: '||l_own_org ,5);
5367: END IF;
5368:
5369:
5370:
5400:
5401:
5402: -- bugfix 3348635
5403: IF PG_DEBUG <> 0 THEN
5404: oe_debug_pub.add('get_other_orgs:' || 'Owning Op Unit: '||l_chk_own_oper_unit,5);
5405: END IF;
5406:
5407:
5408:
5423:
5424:
5425: -- bugfix 3348635
5426: IF PG_DEBUG <> 0 THEN
5427: oe_debug_pub.add('get_other_orgs:' || 'Owning POV Org: '||l_own_pov_org,5);
5428: END IF;
5429:
5430:
5431:
5456: if xOrgLst.count > 0 then
5457: for x2 in xOrgLst.FIRST..xOrgLst.LAST loop
5458:
5459: IF PG_DEBUG <> 0 THEN
5460: oe_debug_pub.add ('get_other_orgs:'||'Validation Orgs ('||x2||') = '||xOrglst(x2),5);
5461: END IF;
5462:
5463: end loop;
5464:
5482: if xOrgLst.exists(x4) then
5483: if xOrgLst(x4) = rget_bcso_orgs.bcso_org_id then
5484:
5485: IF PG_DEBUG <> 0 THEN
5486: oe_debug_pub.add ('get_other_orgs:'||'Deleting Org ('||x4||') = '||xOrglst(x4),5);
5487: END IF;
5488:
5489: xOrgLst.delete(x4);
5490:
5507: if( xOrgLst.count > 0 ) then
5508: for x6 in xOrgLst.First..xOrgLst.Last loop
5509:
5510: if xOrgLst.exists(x6) then
5511: oe_debug_pub.add ('get_other_orgs:'||'Copied Org ('||x6||') = '||xOrglst(x6),5);
5512: xOrgLst_copy(xOrgLst_copy.count + 1) := xOrgLst(x6) ;
5513:
5514: end if;
5515:
5535: if xOrgLst.exists(x5) then
5536:
5537:
5538: IF PG_DEBUG <> 0 THEN
5539: oe_debug_pub.add ('get_other_orgs:'||'Final Org List ('||x5||') = '||xOrglst(x5),5);
5540: END IF;
5541:
5542:
5543:
5550:
5551: exception /* added exception handling for expected and unexpected error as part of bug 4227127 (fp for bug 4162642) */
5552: when FND_API.G_EXC_UNEXPECTED_ERROR then
5553: IF PG_DEBUG <> 0 THEN
5554: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5555: END IF;
5556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5557: CTO_MSG_PUB.Count_And_Get
5558: (p_msg_count => x_msg_count
5560: );
5561:
5562: when FND_API.G_EXC_ERROR then
5563: IF PG_DEBUG <> 0 THEN
5564: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5565: END IF;
5566: x_return_status := FND_API.G_RET_STS_ERROR;
5567: CTO_MSG_PUB.Count_And_Get
5568: (p_msg_count => x_msg_count
5570:
5571:
5572: WHEN OTHERS THEN
5573: IF PG_DEBUG <> 0 THEN
5574: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::unexp error:: '||to_char(lstmt_num)||'::'||sqlerrm,5);
5575: END IF;
5576:
5577: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5578:
5607: and model_item_id = p_model_item_id
5608: and nvl(organization_type , 2 ) in( '3' , '4' ) );
5609:
5610:
5611: oe_debug_pub.add( ' atleast one procured/dropship model/child model exist ' , 1);
5612:
5613:
5614: exception
5615: when others then
5612:
5613:
5614: exception
5615: when others then
5616: oe_debug_pub.add( ' No procured/dropship model/child model exist ' , 1);
5617: null ;
5618: end ;
5619:
5620:
5630: and model_item_id = p_model_item_id
5631: and create_bom = 'Y' );
5632:
5633:
5634: oe_debug_pub.add( ' atleast one org has bom flag = Y ' , 1);
5635:
5636:
5637: exception
5638: when others then
5656: from bom_cto_src_orgs
5657: where line_id = p_line_id and organization_id = rcv_org_id
5658: and organization_type in ( '3' , '4' ) and rownum = 1 ;
5659:
5660: oe_debug_pub.add( ' Org to be Updated ' || to_char(v_receiving_org) , 1);
5661:
5662: exception
5663: when others then
5664: null ;
5661:
5662: exception
5663: when others then
5664: null ;
5665: oe_debug_pub.add( ' Got Error ' || SQLERRM , 1);
5666: v_receiving_org := p_ship_org_id ;
5667: oe_debug_pub.add( ' Assigning Ship Org as Org to be Updated ' || to_char(v_receiving_org) , 1);
5668: end ;
5669:
5663: when others then
5664: null ;
5665: oe_debug_pub.add( ' Got Error ' || SQLERRM , 1);
5666: v_receiving_org := p_ship_org_id ;
5667: oe_debug_pub.add( ' Assigning Ship Org as Org to be Updated ' || to_char(v_receiving_org) , 1);
5668: end ;
5669:
5670:
5671:
5668: end ;
5669:
5670:
5671:
5672: oe_debug_pub.add( ' need to create bom in atleast one receiving org as bom flag = Y
5673: does not exist for any org ' , 1);
5674:
5675: lStmtNumber := 140;
5676: update bom_cto_src_orgs_b
5686: and bbom.assembly_item_id = p_model_item_id
5687: and bp.create_config_bom = 'Y' ) ;
5688:
5689:
5690: oe_debug_pub.add( ' updated for org ' || v_receiving_org || ' rcv org ' || v_receiving_org ) ;
5691: oe_debug_pub.add( ' Records updated ' || SQL%ROWCOUNT ) ;
5692:
5693:
5694: v_ship_org_bom_update := SQL%ROWCOUNT ;
5687: and bp.create_config_bom = 'Y' ) ;
5688:
5689:
5690: oe_debug_pub.add( ' updated for org ' || v_receiving_org || ' rcv org ' || v_receiving_org ) ;
5691: oe_debug_pub.add( ' Records updated ' || SQL%ROWCOUNT ) ;
5692:
5693:
5694: v_ship_org_bom_update := SQL%ROWCOUNT ;
5695:
5702:
5703:
5704:
5705:
5706: oe_debug_pub.add( ' need to create bom in any org as shipping org does not have model bom or bom param' , 1);
5707:
5708: lStmtNumber := 140;
5709: update bom_cto_src_orgs_b
5710: set create_bom = 'Y' /* , organization_type = l_source_type */
5718: and bp.create_config_bom = 'Y' )
5719: and rownum = 1 ;
5720:
5721:
5722: oe_debug_pub.add( ' updated in any shipping org Records updated ' || SQL%ROWCOUNT ) ;
5723:
5724:
5725: end if ; /* shipping_org no bom */
5726:
5756: i Number;
5757: Begin
5758:
5759: If PG_DEBUG <> 0 Then
5760: oe_debug_pub.add('Get_Master_orgs: Entering Get_Master_orgs API for Model Line id = '||p_model_line_id,3);
5761: End if;
5762:
5763: Begin
5764: Select distinct mp1.master_organization_id
5776: If PG_DEBUG <> 0 Then
5777: i := x_orgs_list.first;
5778: while (i is not null)
5779: Loop
5780: oe_debug_pub.add('Get_Master_Orgs: Master Org = '||x_orgs_list(i),5);
5781: i := x_orgs_list.next(i);
5782: End Loop;
5783: If i is null Then
5784: oe_debug_pub.add('Get_Master_Orgs: No master orgs insterted..',5);
5780: oe_debug_pub.add('Get_Master_Orgs: Master Org = '||x_orgs_list(i),5);
5781: i := x_orgs_list.next(i);
5782: End Loop;
5783: If i is null Then
5784: oe_debug_pub.add('Get_Master_Orgs: No master orgs insterted..',5);
5785: End if;
5786: End if;
5787: Exception when no_data_found then
5788: If PG_DEBUG <> 0 Then
5785: End if;
5786: End if;
5787: Exception when no_data_found then
5788: If PG_DEBUG <> 0 Then
5789: oe_debug_pub.add('Get_Master_Orgs: No new Masters orgs are added.... ',1);
5790: End if;
5791: End;
5792:
5793: x_return_status := FND_API.G_RET_STS_SUCCESS;
5794:
5795: Exception /* added exception handling for expected and unexpected error as part of bug 4227127 (fp for bug 4162642) */
5796: when FND_API.G_EXC_UNEXPECTED_ERROR then
5797: IF PG_DEBUG <> 0 THEN
5798: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5799: END IF;
5800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5801: CTO_MSG_PUB.Count_And_Get
5802: (p_msg_count => x_msg_count
5804: );
5805:
5806: when FND_API.G_EXC_ERROR then
5807: IF PG_DEBUG <> 0 THEN
5808: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5809: END IF;
5810: x_return_status := FND_API.G_RET_STS_ERROR;
5811: CTO_MSG_PUB.Count_And_Get
5812: (p_msg_count => x_msg_count
5814:
5815:
5816: WHEN OTHERS THEN
5817: IF PG_DEBUG <> 0 THEN
5818: oe_debug_pub.add('get_other_orgs: ' || 'Get_Master_Orgs::unexp error:: '||to_char(lstmt_num)||'::'||sqlerrm,5);
5819: END IF;
5820:
5821: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5822:
5837:
5838: bom_batch_id := Bom_Import_Pub.Get_BatchId;
5839:
5840: if bom_batch_id = 0 then
5841: oe_debug_pub.add('Get_bom_batch_id: batch_id is 0', 1);
5842: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5843: end if;
5844:
5845: IF PG_DEBUG <> 0 THEN
5842: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5843: end if;
5844:
5845: IF PG_DEBUG <> 0 THEN
5846: oe_debug_pub.add('Get_bom_batch_id: Batch_id = ' || bom_batch_id, 1);
5847: END IF;
5848:
5849: Exception
5850:
5849: Exception
5850:
5851: When FND_API.G_EXC_UNEXPECTED_ERROR then
5852: IF PG_DEBUG <> 0 THEN
5853: oe_debug_pub.add('Get_bom_batch_id: unexpected error: ' || sqlerrm, 1);
5854: END IF;
5855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5856:
5857: When others then
5855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5856:
5857: When others then
5858: IF PG_DEBUG <> 0 THEN
5859: oe_debug_pub.add('Get_bom_batch_id: unexpected error: ' || sqlerrm, 1);
5860: END IF;
5861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5862:
5863: End set_bom_batch_id;
5892: x_current_mode := nvl(MO_GLOBAL.get_access_mode,'N');
5893: x_current_org := nvl(MO_GLOBAL.get_current_org_id,-99);
5894:
5895: If PG_DEBUG <> 0 Then
5896: oe_debug_pub.add('Switch_to_oe_Context : Order Line Org Id = '||to_char(p_oe_org_id),5);
5897: oe_debug_pub.add('Switch_to_oe_Context : Current Mode = '||x_current_mode,5);
5898: oe_debug_pub.add('Switch_to_oe_Context : Current Org = '||to_char(x_current_org),5);
5899: cto_wip_workflow_api_pk.cto_debug('Switch_to_oe_Context','Change_status_batch: Order Line Org Id ='||to_char(p_oe_org_id));
5900: cto_wip_workflow_api_pk.cto_debug('Switch_to_oe_Context','Change_Status_batch: Current Mode = '||x_current_mode);
5893: x_current_org := nvl(MO_GLOBAL.get_current_org_id,-99);
5894:
5895: If PG_DEBUG <> 0 Then
5896: oe_debug_pub.add('Switch_to_oe_Context : Order Line Org Id = '||to_char(p_oe_org_id),5);
5897: oe_debug_pub.add('Switch_to_oe_Context : Current Mode = '||x_current_mode,5);
5898: oe_debug_pub.add('Switch_to_oe_Context : Current Org = '||to_char(x_current_org),5);
5899: cto_wip_workflow_api_pk.cto_debug('Switch_to_oe_Context','Change_status_batch: Order Line Org Id ='||to_char(p_oe_org_id));
5900: cto_wip_workflow_api_pk.cto_debug('Switch_to_oe_Context','Change_Status_batch: Current Mode = '||x_current_mode);
5901: cto_wip_workflow_api_pk.cto_debug('Switch_to_oe_Context','Change_status_batch: Current org = '||to_char(x_current_org));
5894:
5895: If PG_DEBUG <> 0 Then
5896: oe_debug_pub.add('Switch_to_oe_Context : Order Line Org Id = '||to_char(p_oe_org_id),5);
5897: oe_debug_pub.add('Switch_to_oe_Context : Current Mode = '||x_current_mode,5);
5898: oe_debug_pub.add('Switch_to_oe_Context : Current Org = '||to_char(x_current_org),5);
5899: cto_wip_workflow_api_pk.cto_debug('Switch_to_oe_Context','Change_status_batch: Order Line Org Id ='||to_char(p_oe_org_id));
5900: cto_wip_workflow_api_pk.cto_debug('Switch_to_oe_Context','Change_Status_batch: Current Mode = '||x_current_mode);
5901: cto_wip_workflow_api_pk.cto_debug('Switch_to_oe_Context','Change_status_batch: Current org = '||to_char(x_current_org));
5902: end if;
5907: If x_current_mode <> 'N' then
5908: x_context_switch_flag := 'Y';
5909: End if;
5910: If PG_DEBUG <> 0 Then
5911: oe_debug_pub.add('Switch_to_oe_Context : Changing the operating unit context to Order Line context',5);
5912: End if;
5913: MO_GLOBAL.set_policy_context(p_access_mode => 'S',
5914: p_org_id => p_oe_org_id);
5915:
5914: p_org_id => p_oe_org_id);
5915:
5916: Else--5446723
5917: If PG_DEBUG <> 0 Then
5918: oe_debug_pub.add('Switch_to_oe_Context : UN-EXPECTED MOAC MODE',5);
5919: End if;
5920: End if;
5921:
5922: If PG_DEBUG <> 0 Then
5919: End if;
5920: End if;
5921:
5922: If PG_DEBUG <> 0 Then
5923: oe_debug_pub.add('SWITCH_TO_OE_CONTEXT : Done with Chaning the context to OE ',5);
5924: cto_wip_workflow_api_pk.cto_Debug('Switch_to_oe_Context:', 'Done with Chaning the context to OE');
5925: End if;
5926: End Switch_to_oe_context;
5927:
5945:
5946: end if; /* l_old_mode = 'S' */
5947:
5948: If PG_DEBUG <> 0 Then
5949: oe_debug_pub.add('Switch_context_back : Done with Chaning the context BAck',5);
5950: cto_wip_workflow_api_pk.cto_Debug('Switch_to_oe_Context:', 'Done with Chaning the context Back');
5951: End if;
5952:
5953: End Switch_context_back;
5967: where inventory_item_id = pConfigId;
5968:
5969: BEGIN
5970: IF PG_DEBUG <> 0 THEN
5971: oe_debug_pub.add('Inside Raise_event_for_seibel',2);
5972: oe_debug_pub.add('Count of configs:: '|| CTO_MSUTIL_PUB.cfg_tbl_var.count,2);
5973: END IF;
5974:
5975: for i in 1..CTO_MSUTIL_PUB.cfg_tbl_var.count loop
5968:
5969: BEGIN
5970: IF PG_DEBUG <> 0 THEN
5971: oe_debug_pub.add('Inside Raise_event_for_seibel',2);
5972: oe_debug_pub.add('Count of configs:: '|| CTO_MSUTIL_PUB.cfg_tbl_var.count,2);
5973: END IF;
5974:
5975: for i in 1..CTO_MSUTIL_PUB.cfg_tbl_var.count loop
5976: for l_org in config_orgs(CTO_MSUTIL_PUB.cfg_tbl_var(i)) loop
5974:
5975: for i in 1..CTO_MSUTIL_PUB.cfg_tbl_var.count loop
5976: for l_org in config_orgs(CTO_MSUTIL_PUB.cfg_tbl_var(i)) loop
5977: IF PG_DEBUG <> 0 THEN
5978: oe_debug_pub.add('Config:: ' || CTO_MSUTIL_PUB.cfg_tbl_var(i),2);
5979: oe_debug_pub.add('Org:: ' || l_org.organization_id,2);
5980: END IF;
5981:
5982: sql_stmt := 'BEGIN '||
5975: for i in 1..CTO_MSUTIL_PUB.cfg_tbl_var.count loop
5976: for l_org in config_orgs(CTO_MSUTIL_PUB.cfg_tbl_var(i)) loop
5977: IF PG_DEBUG <> 0 THEN
5978: oe_debug_pub.add('Config:: ' || CTO_MSUTIL_PUB.cfg_tbl_var(i),2);
5979: oe_debug_pub.add('Org:: ' || l_org.organization_id,2);
5980: END IF;
5981:
5982: sql_stmt := 'BEGIN '||
5983: 'INV_ITEM_EVENTS_PVT.Raise_Events( '||
5996:
5997: EXCEPTION
5998: When others then
5999: IF PG_DEBUG <> 0 THEN
6000: oe_debug_pub.add(G_PKG_NAME || ' Error: '||sqlerrm,5);
6001: oe_debug_pub.add('Not an error');
6002: END IF;
6003:
6004: End Raise_event_for_seibel;
5997: EXCEPTION
5998: When others then
5999: IF PG_DEBUG <> 0 THEN
6000: oe_debug_pub.add(G_PKG_NAME || ' Error: '||sqlerrm,5);
6001: oe_debug_pub.add('Not an error');
6002: END IF;
6003:
6004: End Raise_event_for_seibel;
6005: --End Bugfix 8305535