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

APPS.CTO_ITEM_PK dependencies on OE_DEBUG_PUB

Line 22: | since we are using oe_debug_pub.

Line 230: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;

226:
227: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
228: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
229:
230: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
231:
232:
233: begin
234:

Line 264: oe_debug_pub.add('Create_And_Link_Item: ' || 'pTopAtoLineId::'||to_char(pTopAtoLineId), 2);

260: --
261:
262: lStmtNum := 5;
263: IF PG_DEBUG <> 0 THEN
264: oe_debug_pub.add('Create_And_Link_Item: ' || 'pTopAtoLineId::'||to_char(pTopAtoLineId), 2);
265: END IF;
266:
267:
268:

Line 277: oe_debug_pub.add('Create_And_Link_Item: ' || ' deleted ' || SQL%ROWCOUNT ||

273:
274: -- delete from bom_cto_order_lines where ato_line_id = pTopAtoLineId ;
275:
276: IF PG_DEBUG <> 0 THEN
277: oe_debug_pub.add('Create_And_Link_Item: ' || ' deleted ' || SQL%ROWCOUNT ||
278: ' from bcol ' || to_char(pTopAtoLineId), 2);
279: END IF;
280:
281: CTO_UTILITY_PK.Populate_Bcol(

Line 294: oe_debug_pub.add ('Create_And_Link_Item: ' ||

290:
291: if XReturnStatus = FND_API.G_RET_STS_ERROR then
292:
293: IF PG_DEBUG <> 0 THEN
294: oe_debug_pub.add ('Create_And_Link_Item: ' ||
295: 'Failed in populate_bcol with expected error.', 1);
296: END IF;
297:
298: raise FND_API.G_EXC_ERROR;

Line 303: oe_debug_pub.add ('Create_And_Link_Item: ' ||

299:
300: elsif XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR then
301:
302: IF PG_DEBUG <> 0 THEN
303: oe_debug_pub.add ('Create_And_Link_Item: ' ||
304: 'Failed in populate_bcol with unexpected error.', 1);
305: END IF;
306:
307: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 311: oe_debug_pub.add('Create_And_Link_Item: ' || 'After Populate_Bcol', 5);

307: raise FND_API.G_EXC_UNEXPECTED_ERROR;
308: end if;
309:
310: IF PG_DEBUG <> 0 THEN
311: oe_debug_pub.add('Create_And_Link_Item: ' || 'After Populate_Bcol', 5);
312: END IF;
313:
314:
315:

Line 327: oe_debug_pub.add( 'came into PRECONFIG UPDATE BCOL QUERY ' , 1 ) ;

323:
324: lStmtNum := 10 ;
325:
326:
327: oe_debug_pub.add( 'came into PRECONFIG UPDATE BCOL QUERY ' , 1 ) ;
328:
329: update bom_cto_order_lines
330: set perform_match = 'Y'
331: where ato_line_id = pTopAtoLineId

Line 344: oe_debug_pub.add( 'PRECONFIG Similar Instance UPDATE BCOL QUERY count ' || SQL%ROWCOUNT , 1 ) ;

340: having count(*) > 1
341: );
342:
343:
344: oe_debug_pub.add( 'PRECONFIG Similar Instance UPDATE BCOL QUERY count ' || SQL%ROWCOUNT , 1 ) ;
345:
346:
347:
348: end if; /* check for autoconfig or preconfig */

Line 358: oe_debug_pub.add('Create_And_Link_Item: ' || 'REUSE Section ', 5);

354: -- Step 2) Call Reuse for current configuration
355: --
356:
357:
358: oe_debug_pub.add('Create_And_Link_Item: ' || 'REUSE Section ', 5);
359:
360:
361: lStmtNum := 20 ;
362:

Line 370: oe_debug_pub.add('Create_And_Link_Item: ' ||

366:
367: lReuseProfile := FND_PROFILE.Value('CTO_REUSE_CONFIG'); --Bugfix 6642016
368:
369: IF PG_DEBUG <> 0 THEN
370: oe_debug_pub.add('Create_And_Link_Item: ' ||
371: ' Reuse Configuration profile: ' || to_char(lReuseProfile) , 5);
372: END IF; --Bugfix 6642016
373:
374: if ( nvl(lReuseProfile,1) = 1 ) then ----Bugfix 6642016

Line 381: oe_debug_pub.add('Create_And_Link_Item: ' ||

377: where ato_line_id = pTopAtoLineId ;
378:
379:
380: IF PG_DEBUG <> 0 THEN
381: oe_debug_pub.add('Create_And_Link_Item: ' ||
382: ' calling reuse config' || to_char(v_reuse_bcol_count) , 5);
383: END IF;
384:
385: /* call reuse config api */

Line 397: oe_debug_pub.add('Create_And_Link_Item: done reuse. ' , 5);

393:
394:
395:
396: IF PG_DEBUG <> 0 THEN
397: oe_debug_pub.add('Create_And_Link_Item: done reuse. ' , 5);
398: END IF;
399:
400: end if; --lReuseProfile = 1 Bugfix 6642016
401:

Line 420: oe_debug_pub.add('Create_And_Link_Item: ' ||

416: end ;
417:
418:
419: IF PG_DEBUG <> 0 THEN
420: oe_debug_pub.add('Create_And_Link_Item: ' ||
421: ' v_bcol_ship_from_org_id : ' || v_bcol_ship_from_org_id ||
422: ' v_bcolgt_ship_from_org_id : ' || v_bcolgt_ship_from_org_id
423: , 5);
424: END IF;

Line 441: oe_debug_pub.add('Create_And_Link_Item: done oss flag update for reuse. ' , 5);

437:
438:
439:
440: IF PG_DEBUG <> 0 THEN
441: oe_debug_pub.add('Create_And_Link_Item: done oss flag update for reuse. ' , 5);
442: END IF;
443:
444:
445: /* delete from bcol */

Line 450: oe_debug_pub.add('Create_And_Link_Item: ' ||

446:
447: delete from bom_cto_order_lines where ato_line_id = pTopAtoLineId ;
448:
449: IF PG_DEBUG <> 0 THEN
450: oe_debug_pub.add('Create_And_Link_Item: ' ||
451: ' deleting from bcol ' || to_char(sql%rowcount) , 5);
452: END IF;
453:
454: lStmtNum := 30 ;

Line 529: oe_debug_pub.add('Create_And_Link_Item: ' || SQL%ROWCOUNT ||

525: where ato_line_id = pTopAtoLineId ;
526: /* add ods and reuse flag */
527:
528: IF PG_DEBUG <> 0 THEN
529: oe_debug_pub.add('Create_And_Link_Item: ' || SQL%ROWCOUNT ||
530: ' copied from bcol_gt to bcol ', 5);
531: END IF;
532:
533:

Line 540: oe_debug_pub.add('Create_And_Link_Item: ' || 'copy bcol to bcol_gt ', 5);

536:
537:
538: lStmtNum := 40 ;
539:
540: oe_debug_pub.add('Create_And_Link_Item: ' || 'copy bcol to bcol_gt ', 5);
541: /* copy bcol data to bcol_temp for matching */
542:
543: insert into bom_cto_order_lines_gt (
544: LINE_ID

Line 614: oe_debug_pub.add('Create_And_Link_Item: ' || ' copied bcol to bcol gt rows ' || SQL%ROWCOUNT , 5);

610: ,SHIP_FROM_ORG_ID --for bugfix3555026
611: from bom_cto_order_lines
612: where ato_line_id = pTopAtoLineId ;
613:
614: oe_debug_pub.add('Create_And_Link_Item: ' || ' copied bcol to bcol gt rows ' || SQL%ROWCOUNT , 5);
615: end if ; /* bcol data exists */
616: end if ; /* p_mode = AUTOCONFIG */
617:
618:

Line 620: oe_debug_pub.add('Create_And_Link_Item: ' ||

616: end if ; /* p_mode = AUTOCONFIG */
617:
618:
619: IF PG_DEBUG <> 0 THEN
620: oe_debug_pub.add('Create_And_Link_Item: ' ||
621: ' querying Reuse Flag ' , 2);
622: END IF;
623:
624: lStmtNum := 50 ;

Line 634: oe_debug_pub.add('Create_And_Link_Item: ' ||

630: from bom_cto_order_lines
631: where line_id = pTopAtoLineId ;
632:
633: IF PG_DEBUG <> 0 THEN
634: oe_debug_pub.add('Create_And_Link_Item: ' ||
635: 'Reuse item ' || v_reuse_config_item_id ||
636: ' Reuse Flag ' || v_reuse_config_flag ||
637: ' Config Creation ' || v_reuse_config_creation
638: , 2);

Line 664: oe_debug_pub.add('create_and_link_item: ' || 'going to call validate_oe_data ', 1 );

660: -- 2) Line_id's in OE and BCOL matches for specific ato_line_id in question
661:
662:
663: IF PG_DEBUG <> 0 THEN
664: oe_debug_pub.add('create_and_link_item: ' || 'going to call validate_oe_data ', 1 );
665: END IF;
666:
667: CTO_UTILITY_PK.validate_oe_data(p_bcol_line_id => pTopAtoLineId,
668: x_return_status => xReturnStatus);

Line 672: oe_debug_pub.add('create_and_link_item: ' || 'Error in OE BCOL Validation',5);

668: x_return_status => xReturnStatus);
669:
670:
671: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS THEN
672: oe_debug_pub.add('create_and_link_item: ' || 'Error in OE BCOL Validation',5);
673: raise FND_API.G_EXC_UNEXPECTED_ERROR;
674: end if;
675:
676:

Line 687: oe_debug_pub.add('create_and_link_item: BCOL DATA ' || ' line_id ' ||

683:
684:
685:
686:
687: oe_debug_pub.add('create_and_link_item: BCOL DATA ' || ' line_id ' ||
688: ' inventory_item_id ' || ' ship_org ' || ' match ' ||
689: ' config item ' || ' CIB ' || ' level ' || ' link ' , 1 ) ;
690: FOR v_debug IN c_debug LOOP
691: IF PG_DEBUG <> 0 THEN

Line 692: oe_debug_pub.add('create_and_link_item: ' || to_char(v_debug.line_id)||' '||

688: ' inventory_item_id ' || ' ship_org ' || ' match ' ||
689: ' config item ' || ' CIB ' || ' level ' || ' link ' , 1 ) ;
690: FOR v_debug IN c_debug LOOP
691: IF PG_DEBUG <> 0 THEN
692: oe_debug_pub.add('create_and_link_item: ' || to_char(v_debug.line_id)||' '||
693: to_char(v_debug.inventory_item_id)||' '||
694: nvl(to_char(v_debug.ship_from_org_id),null)||' '||
695: to_char(v_debug.perform_match)||' '||
696: nvl(v_debug.config_item_id, null)||' '||

Line 742: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);

738:
739: lStmtNum := 1003;
740: IF (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
741: IF PG_DEBUG <> 0 THEN
742: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);
743: END IF;
744: raise FND_API.G_EXC_ERROR;
745:
746: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 748: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);

744: raise FND_API.G_EXC_ERROR;
745:
746: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
747: IF PG_DEBUG <> 0 THEN
748: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);
749: END IF;
750: raise FND_API.G_EXC_UNEXPECTED_ERROR;
751:
752: END IF;

Line 755: oe_debug_pub.add('Create_And_Link_Item: ' || 'After process_oss_configurations ', 2);

751:
752: END IF;
753:
754: IF PG_DEBUG <> 0 THEN
755: oe_debug_pub.add('Create_And_Link_Item: ' || 'After process_oss_configurations ', 2);
756: END IF;
757:
758: end if;
759:

Line 763: oe_debug_pub.add('Create_And_Link_Item: ' ||

759:
760: lStmtNum := 1004;
761:
762: IF PG_DEBUG <> 0 THEN
763: oe_debug_pub.add('Create_And_Link_Item: ' ||
764: 'Will Not Perform Any Item processing as it is reuse case ', 2);
765: END IF;
766:
767:

Line 779: oe_debug_pub.add('Create_And_Link_Item: ' ||

775:
776: delete from bom_cto_src_orgs_b where top_model_line_id = pTopAtoLineId ;
777:
778: IF PG_DEBUG <> 0 THEN
779: oe_debug_pub.add('Create_And_Link_Item: ' ||
780: ' deleted from bcso_b as reuse is not applicable or doesnt exist '
781: || to_char(sql%rowcount) , 5);
782: END IF;
783:

Line 793: oe_debug_pub.add('Create_And_Link_Item: ' || 'Match section ', 5);

789: --
790: -- Step 3) Call Match for current configuration
791: --
792:
793: oe_debug_pub.add('Create_And_Link_Item: ' || 'Match section ', 5);
794:
795:
796: lStmtNum := 50 ;
797:

Line 800: oe_debug_pub.add('Create_And_Link_Item: ' || ' Done Match section ', 5);

796: lStmtNum := 50 ;
797:
798: lMatchProfile := FND_PROFILE.Value('BOM:MATCH_CONFIG');
799:
800: oe_debug_pub.add('Create_And_Link_Item: ' || ' Done Match section ', 5);
801: oe_debug_pub.add('Create_And_Link_Item: ' || ' Done Match section ' || lMatchProfile , 5);
802:
803: if( lMatchProfile = 1 and p_mode = 'AUTOCONFIG' ) then
804:

Line 801: oe_debug_pub.add('Create_And_Link_Item: ' || ' Done Match section ' || lMatchProfile , 5);

797:
798: lMatchProfile := FND_PROFILE.Value('BOM:MATCH_CONFIG');
799:
800: oe_debug_pub.add('Create_And_Link_Item: ' || ' Done Match section ', 5);
801: oe_debug_pub.add('Create_And_Link_Item: ' || ' Done Match section ' || lMatchProfile , 5);
802:
803: if( lMatchProfile = 1 and p_mode = 'AUTOCONFIG' ) then
804:
805:

Line 806: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || ' going to call CTO_MATCH_CONFIG perform_match ' , 1 ) ;

802:
803: if( lMatchProfile = 1 and p_mode = 'AUTOCONFIG' ) then
804:
805:
806: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || ' going to call CTO_MATCH_CONFIG perform_match ' , 1 ) ;
807:
808:
809: CTO_MATCH_CONFIG.perform_match( pTopAtoLineId ,
810: x_return_status ,

Line 815: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || ' done perform_match ' , 1 ) ;

811: x_msg_count,
812: x_msg_data
813: ) ;
814:
815: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || ' done perform_match ' , 1 ) ;
816:
817:
818:
819: lStmtNum := 55 ;

Line 827: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM:: perform match data ' ||

823: from bom_cto_order_lines_gt
824: where line_id = pTopAtoLineId ;
825:
826:
827: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM:: perform match data ' ||
828: 'x_match_found ' || x_match_found ||
829: 'x_top_matched_item_id ' || to_char( x_top_matched_item_id )
830: , 1 ) ;
831:

Line 834: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || 'Top Model Match Success ' , 1 ) ;

830: , 1 ) ;
831:
832:
833: if( x_match_found = 'Y' ) then
834: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || 'Top Model Match Success ' , 1 ) ;
835: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || 'Top Match '|| to_char( x_top_matched_item_id ) , 1 ) ;
836:
837: null ;
838:

Line 835: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || 'Top Match '|| to_char( x_top_matched_item_id ) , 1 ) ;

831:
832:
833: if( x_match_found = 'Y' ) then
834: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || 'Top Model Match Success ' , 1 ) ;
835: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || 'Top Match '|| to_char( x_top_matched_item_id ) , 1 ) ;
836:
837: null ;
838:
839: end if ;

Line 847: oe_debug_pub.add('Create_And_Link_Item: ' || ' Going to Synch up BCOL with data from BCOL_GT for matched info ' , 5);

843:
844:
845:
846: lStmtNum := 60 ;
847: oe_debug_pub.add('Create_And_Link_Item: ' || ' Going to Synch up BCOL with data from BCOL_GT for matched info ' , 5);
848:
849:
850:
851: update bom_cto_order_lines bcol

Line 860: oe_debug_pub.add('Create_And_Link_Item: ' || ' Synch up BCOL with data from BCOL_GT for matched info rows ' || SQL%ROWCOUNT , 5);

856: where bcol.line_id = bcol_gt.line_id )
857: where bcol.ato_line_id = pTopAtoLineId ;
858:
859:
860: oe_debug_pub.add('Create_And_Link_Item: ' || ' Synch up BCOL with data from BCOL_GT for matched info rows ' || SQL%ROWCOUNT , 5);
861:
862:
863: --
864: --

Line 881: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);

877:
878:
879: IF (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
880: IF PG_DEBUG <> 0 THEN
881: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);
882: END IF;
883: raise FND_API.G_EXC_ERROR;
884:
885: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 887: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);

883: raise FND_API.G_EXC_ERROR;
884:
885: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
886: IF PG_DEBUG <> 0 THEN
887: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);
888: END IF;
889: raise FND_API.G_EXC_UNEXPECTED_ERROR;
890:
891: END IF;

Line 894: oe_debug_pub.add('Create_And_Link_Item: ' || 'After process_oss_configurations ', 2);

890:
891: END IF;
892:
893: IF PG_DEBUG <> 0 THEN
894: oe_debug_pub.add('Create_And_Link_Item: ' || 'After process_oss_configurations ', 2);
895: END IF;
896:
897:
898:

Line 923: oe_debug_pub.add('Create_And_Link_Item: ' || 'Before CTO_MSUTIL_PUB.Populate_Src_Orgs', 2);

919:
920:
921:
922: IF PG_DEBUG <> 0 THEN
923: oe_debug_pub.add('Create_And_Link_Item: ' || 'Before CTO_MSUTIL_PUB.Populate_Src_Orgs', 2);
924: END IF;
925: lStatus := CTO_MSUTIL_PUB.Populate_Src_Orgs(
926: pTopAtoLineId => pTopAtoLineId,
927: x_return_status => XReturnStatus,

Line 933: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with exp error',1);

929: x_msg_data => XMsgData);
930:
931: IF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
932: IF PG_DEBUG <> 0 THEN
933: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with exp error',1);
934: END IF;
935: raise FND_API.G_EXC_ERROR;
936:
937: ELSIF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 939: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with unexp error',1);

935: raise FND_API.G_EXC_ERROR;
936:
937: ELSIF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
938: IF PG_DEBUG <> 0 THEN
939: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with unexp error',1);
940: END IF;
941: raise FND_API.G_EXC_UNEXPECTED_ERROR;
942:
943: END IF;

Line 946: oe_debug_pub.add('Create_And_Link_Item: ' || 'After Populate_Src_Orgs', 2);

942:
943: END IF;
944:
945: IF PG_DEBUG <> 0 THEN
946: oe_debug_pub.add('Create_And_Link_Item: ' || 'After Populate_Src_Orgs', 2);
947: END IF;
948:
949:
950:

Line 968: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error: Length of delimiter <> 1', 1);

964: end if;
965:
966: if (length(lCiDel )<> 1 ) then
967: IF PG_DEBUG <> 0 THEN
968: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error: Length of delimiter <> 1', 1);
969: END IF;
970: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
971: raise FND_API.G_EXC_ERROR;
972: end if;

Line 974: oe_debug_pub.add('Create_And_Link_Item: ' || 'Delimiter is : ' || lCiDel,2);

970: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
971: raise FND_API.G_EXC_ERROR;
972: end if;
973: IF PG_DEBUG <> 0 THEN
974: oe_debug_pub.add('Create_And_Link_Item: ' || 'Delimiter is : ' || lCiDel,2);
975: END IF;
976:
977:
978: --

Line 991: oe_debug_pub.add('Create_And_Link_Item: ' || 'Items FF segment Separator is : ' || lSegDel,2);

987: and id_flex_code = 'MSTK'
988: and id_flex_num = 101;
989:
990: IF PG_DEBUG <> 0 THEN
991: oe_debug_pub.add('Create_And_Link_Item: ' || 'Items FF segment Separator is : ' || lSegDel,2);
992: END IF;
993:
994: if ( lSegDel = lCiDel ) then
995: IF PG_DEBUG <> 0 THEN

Line 996: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error : Config Item delimiter = System Items FF segment separator. Not a valid setup.', 1);

992: END IF;
993:
994: if ( lSegDel = lCiDel ) then
995: IF PG_DEBUG <> 0 THEN
996: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error : Config Item delimiter = System Items FF segment separator. Not a valid setup.', 1);
997:
998: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Please set a different value for profile BOM:Configuration Item Delimiter.',1);
999: END IF;
1000: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');

Line 998: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Please set a different value for profile BOM:Configuration Item Delimiter.',1);

994: if ( lSegDel = lCiDel ) then
995: IF PG_DEBUG <> 0 THEN
996: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error : Config Item delimiter = System Items FF segment separator. Not a valid setup.', 1);
997:
998: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Please set a different value for profile BOM:Configuration Item Delimiter.',1);
999: END IF;
1000: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
1001: raise FND_API.G_EXC_ERROR;
1002: end if;

Line 1017: oe_debug_pub.add('Create_And_Link_Item: ' || 'SRS Calling Create_All_Items', 2);

1013: --
1014:
1015: lStmtNum := 110 ;
1016: IF PG_DEBUG <> 0 THEN
1017: oe_debug_pub.add('Create_And_Link_Item: ' || 'SRS Calling Create_All_Items', 2);
1018: END IF;
1019:
1020: lStatus := Create_All_Items(
1021: pTopAtoLineId,

Line 1028: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Create_All_Items returned with 0', 1);

1024: XMsgData,
1025: p_mode);
1026: IF lStatus <> 1 then
1027: IF PG_DEBUG <> 0 THEN
1028: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Create_All_Items returned with 0', 1);
1029: END IF;
1030: --cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
1031: raise FND_API.G_EXC_ERROR;
1032: end if;

Line 1038: oe_debug_pub.add ('Create_And_Link_Item: ' || 'calling oss processing ', 1);

1034:
1035:
1036:
1037:
1038: oe_debug_pub.add ('Create_And_Link_Item: ' || 'calling oss processing ', 1);
1039:
1040:
1041:
1042:

Line 1063: oe_debug_pub.add('Create_And_Link_Item: ' || 'New Msg:: Opening the c_copy_src_rules cursor.');

1059: --
1060:
1061: lStmtNum := 130 ;
1062: IF PG_DEBUG <> 0 THEN
1063: oe_debug_pub.add('Create_And_Link_Item: ' || 'New Msg:: Opening the c_copy_src_rules cursor.');
1064: END IF;
1065:
1066: FOR v_src_rule IN c_copy_src_rules LOOP
1067: --

Line 1074: oe_debug_pub.add ('Create_Item: ' || ' c_copy_src_rules LOOP ' || v_src_rule.config_creation , 1 );

1070: --
1071:
1072: lStmtNum:= 110;
1073:
1074: oe_debug_pub.add ('Create_Item: ' || ' c_copy_src_rules LOOP ' || v_src_rule.config_creation , 1 );
1075:
1076:
1077: if( v_src_rule.create_src_rules = 'Y' and v_src_rule.config_creation in ( 1, 2) ) then
1078:

Line 1082: oe_debug_pub.add ('Create_Item: ' || 'Copying src rule for cfg item '

1078:
1079:
1080:
1081: IF PG_DEBUG <> 0 THEN
1082: oe_debug_pub.add ('Create_Item: ' || 'Copying src rule for cfg item '
1083: ||to_char(v_src_rule.config_item_id)||' in org '||
1084: to_char(v_src_rule.organization_id), 2);
1085: END IF;
1086:

Line 1100: oe_debug_pub.add ('Create_Item: ' ||

1096: x_msg_data => xMsgData);
1097:
1098: IF (lStatus = fnd_api.G_RET_STS_ERROR) THEN
1099: IF PG_DEBUG <> 0 THEN
1100: oe_debug_pub.add ('Create_Item: ' ||
1101: 'Create_Sourcing_Rules returned with expected error.');
1102: END IF;
1103: raise FND_API.G_EXC_ERROR;
1104:

Line 1107: oe_debug_pub.add ('Create_Item: ' ||

1103: raise FND_API.G_EXC_ERROR;
1104:
1105: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
1106: IF PG_DEBUG <> 0 THEN
1107: oe_debug_pub.add ('Create_Item: ' ||
1108: 'Create_Sourcing_Rules returned with unexp error.');
1109: END IF;
1110: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1111:

Line 1117: oe_debug_pub.add ('Create_Item: ' || 'Copying src rule for cfg item '

1113:
1114: elsif( v_src_rule.config_creation = 3 ) then
1115:
1116: IF PG_DEBUG <> 0 THEN
1117: oe_debug_pub.add ('Create_Item: ' || 'Copying src rule for cfg item '
1118: ||to_char(v_src_rule.config_item_id)||' in org '||
1119: to_char(v_src_rule.organization_id), 2);
1120: END IF;
1121:

Line 1132: oe_debug_pub.add ('Create_Item: type3 sourcing rules done ' , 1) ;

1128: x_return_status => lStatus,
1129: x_msg_count => xMsgCount,
1130: x_msg_data => xMsgData);
1131:
1132: oe_debug_pub.add ('Create_Item: type3 sourcing rules done ' , 1) ;
1133:
1134: IF (lStatus = fnd_api.G_RET_STS_ERROR) THEN
1135: IF PG_DEBUG <> 0 THEN
1136: oe_debug_pub.add ('Create_Item: ' ||

Line 1136: oe_debug_pub.add ('Create_Item: ' ||

1132: oe_debug_pub.add ('Create_Item: type3 sourcing rules done ' , 1) ;
1133:
1134: IF (lStatus = fnd_api.G_RET_STS_ERROR) THEN
1135: IF PG_DEBUG <> 0 THEN
1136: oe_debug_pub.add ('Create_Item: ' ||
1137: 'Create_Sourcing_Rules returned with expected error.');
1138: END IF;
1139: raise FND_API.G_EXC_ERROR;
1140:

Line 1143: oe_debug_pub.add ('Create_Item: ' ||

1139: raise FND_API.G_EXC_ERROR;
1140:
1141: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
1142: IF PG_DEBUG <> 0 THEN
1143: oe_debug_pub.add ('Create_Item: ' ||
1144: 'Create_Sourcing_Rules returned with unexp error.');
1145: END IF;
1146: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1147:

Line 1155: oe_debug_pub.add ('Create_Item: next iteration ' , 1) ;

1151:
1152:
1153: end if;
1154:
1155: oe_debug_pub.add ('Create_Item: next iteration ' , 1) ;
1156:
1157: END LOOP;
1158:
1159:

Line 1166: oe_debug_pub.add ('Create_And_Link_Item: ' ||

1162: end if; /* Check for Reuse Flag */
1163:
1164:
1165: IF PG_DEBUG <> 0 THEN
1166: oe_debug_pub.add ('Create_And_Link_Item: ' ||
1167: 'Success in Item Creation function', 1);
1168: END IF;
1169:
1170: return(1);

Line 1175: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::ndf::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);

1171:
1172: EXCEPTION
1173: when NO_DATA_FOUND then
1174: IF PG_DEBUG <> 0 THEN
1175: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::ndf::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1176: END IF;
1177: cto_msg_pub.count_and_get
1178: ( p_msg_count => xMsgCount
1179: , p_msg_data => xMsgData

Line 1186: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::exp error in stmt '||to_char(lStmtNum), 1);

1182: return(0);
1183:
1184: when FND_API.G_EXC_ERROR then
1185: IF PG_DEBUG <> 0 THEN
1186: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::exp error in stmt '||to_char(lStmtNum), 1);
1187: END IF;
1188: cto_msg_pub.count_and_get
1189: ( p_msg_count => xMsgCount
1190: , p_msg_data => xMsgData

Line 1197: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::unexp error in stmt '||to_char(lStmtNum)||'::'||sqlerrm, 1);

1193: return(0);
1194:
1195: when FND_API.G_EXC_UNEXPECTED_ERROR then
1196: IF PG_DEBUG <> 0 THEN
1197: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::unexp error in stmt '||to_char(lStmtNum)||'::'||sqlerrm, 1);
1198: END IF;
1199: cto_msg_pub.count_and_get
1200: ( p_msg_count => xMsgCount
1201: , p_msg_data => xMsgData

Line 1208: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::others::'||to_char(lStmtNum)||'::'||sqlerrm, 1);

1204: return(0);
1205:
1206: when OTHERS then
1207: IF PG_DEBUG <> 0 THEN
1208: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::others::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1209: END IF;
1210: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1211: FND_MSG_PUB.Add_Exc_Msg
1212: ('CTO_ITEM_PK'

Line 1299: oe_debug_pub.add ('Create_All_items: ' || 'Entered ', 1);

1295:
1296: BEGIN
1297:
1298:
1299: oe_debug_pub.add ('Create_All_items: ' || 'Entered ', 1);
1300:
1301: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
1302: lUserId := nvl(Fnd_Global.USER_ID, -1) ;
1303: lLoginId := nvl(Fnd_Global.LOGIN_ID, -1);

Line 1310: oe_debug_pub.add ('Create_All_items: ' || 'Entered 1 ', 1);

1306:
1307:
1308:
1309:
1310: oe_debug_pub.add ('Create_All_items: ' || 'Entered 1 ', 1);
1311:
1312:
1313:
1314:

Line 1329: oe_debug_pub.add ('Create_All_items: ' || 'Entered 2 ', 1);

1325:
1326: FOR v_model_lines IN c_model_lines
1327: LOOP
1328:
1329: oe_debug_pub.add ('Create_All_items: ' || 'Entered 2 ', 1);
1330: v_match_found := FALSE ;
1331:
1332:
1333:

Line 1335: oe_debug_pub.add('Create_All_Items: ' || 'loop::'||

1331:
1332:
1333:
1334: IF PG_DEBUG <> 0 THEN
1335: oe_debug_pub.add('Create_All_Items: ' || 'loop::'||
1336: to_char(v_model_lines.line_id)||'::'||
1337: to_char(v_model_lines.inventory_item_id), 2);
1338: END IF;
1339:

Line 1346: oe_debug_pub.add('Create_All_Items: ' ||

1342: --
1343:
1344: xConfigId := v_model_lines.config_item_id;
1345: IF PG_DEBUG <> 0 THEN
1346: oe_debug_pub.add('Create_All_Items: ' ||
1347: 'Before calling create_item::config_id is::'||to_char(xConfigId), 2);
1348: END IF;
1349:
1350:

Line 1352: oe_debug_pub.add ('Create_All_items: ' || 'Entered 3' , 1);

1348: END IF;
1349:
1350:
1351:
1352: oe_debug_pub.add ('Create_All_items: ' || 'Entered 3' , 1);
1353:
1354:
1355: /* check for perform match flag */
1356:

Line 1363: oe_debug_pub.add ('Create_All_items: ' || 'perform_match ' || v_perform_match , 1);

1359: from bom_cto_order_lines
1360: where line_id = v_model_lines.line_id;
1361:
1362:
1363: oe_debug_pub.add ('Create_All_items: ' || 'perform_match ' || v_perform_match , 1);
1364:
1365: lXConfigId := v_model_lines.config_item_id ;
1366:
1367: if( v_perform_match in ( 'Y' , 'C' ) and lXConfigId is null ) then /* Reattempt Match for preconfigured Scenario */

Line 1392: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');

1388: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: end time: ' ||
1389: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));
1390:
1391: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then
1392: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1393: raise fnd_api.g_exc_unexpected_error;
1394: end if;
1395:
1396: --check for error cases

Line 1399: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');

1395:
1396: --check for error cases
1397: if ( l_lock_status <> 0 ) THEN
1398: if (l_lock_status = 1) then -- timeout
1399: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');
1400: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
1401: raise fnd_api.g_exc_unexpected_error;
1402:
1403: elsif (l_lock_status = 2) then -- deadlock

Line 1404: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');

1400: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
1401: raise fnd_api.g_exc_unexpected_error;
1402:
1403: elsif (l_lock_status = 2) then -- deadlock
1404: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
1405: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
1406: raise fnd_api.g_exc_unexpected_error;
1407:
1408: elsif (l_lock_status = 3) then -- parameter error

Line 1409: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');

1405: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
1406: raise fnd_api.g_exc_unexpected_error;
1407:
1408: elsif (l_lock_status = 3) then -- parameter error
1409: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
1410: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
1411: raise fnd_api.g_exc_unexpected_error;
1412:
1413: elsif (l_lock_status = 4) then -- already locked.

Line 1414: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');

1410: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
1411: raise fnd_api.g_exc_unexpected_error;
1412:
1413: elsif (l_lock_status = 4) then -- already locked.
1414: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');
1415: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');
1416: -- we shall not raise an error if we are already holding the lock.
1417:
1418: else -- internal error - not fault of user

Line 1419: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');

1415: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');
1416: -- we shall not raise an error if we are already holding the lock.
1417:
1418: else -- internal error - not fault of user
1419: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');
1420: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');
1421: raise fnd_api.g_exc_unexpected_error;
1422: end if;
1423: else

Line 1425: oe_debug_pub.add('match_and_create_all_items: ' || 'Successfully obtained lock for match.');

1421: raise fnd_api.g_exc_unexpected_error;
1422: end if;
1423: else
1424: IF PG_DEBUG <> 0 THEN
1425: oe_debug_pub.add('match_and_create_all_items: ' || 'Successfully obtained lock for match.');
1426: END IF;
1427:
1428: end if;
1429: --

Line 1455: oe_debug_pub.add('match_and_create_all_items: v_perform_match = '||v_perform_match);

1451:
1452: end if ;
1453: -- bug 5859780 : need to handle error from match function.
1454: if lStatus <> 1 then
1455: oe_debug_pub.add('match_and_create_all_items: v_perform_match = '||v_perform_match);
1456: oe_debug_pub.add('match_and_create_all_items: '|| 'match returned error: '||l_x_error_msg);
1457: raise fnd_api.g_exc_error;
1458: end if;
1459: -- end bug 5859780

Line 1456: oe_debug_pub.add('match_and_create_all_items: '|| 'match returned error: '||l_x_error_msg);

1452: end if ;
1453: -- bug 5859780 : need to handle error from match function.
1454: if lStatus <> 1 then
1455: oe_debug_pub.add('match_and_create_all_items: v_perform_match = '||v_perform_match);
1456: oe_debug_pub.add('match_and_create_all_items: '|| 'match returned error: '||l_x_error_msg);
1457: raise fnd_api.g_exc_error;
1458: end if;
1459: -- end bug 5859780
1460:

Line 1476: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');

1472: x_Msg_Data => xMsgData,
1473: p_hash_value => l_hash_value);
1474:
1475: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then
1476: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1477: raise fnd_api.g_exc_unexpected_error;
1478: end if;
1479:
1480: --

Line 1488: oe_debug_pub.add ('Create_All_items: ' || 'no match found ' , 1);

1484: end if;
1485:
1486: if (lXConfigId is null) then
1487:
1488: oe_debug_pub.add ('Create_All_items: ' || 'no match found ' , 1);
1489:
1490: /* Sushant is Testig Important
1491: v_parent_ato_line_id := v_model_lines.parent_ato_line_id ;
1492: */

Line 1517: oe_debug_pub.add ('Create_All_items: ' || ' v_parent_ato ' || v_parent_ato_line_id

1513: into v_parent_ato_line_id , v_ato_line_id ;
1514:
1515: v_update_count := SQL%rowcount ;
1516:
1517: oe_debug_pub.add ('Create_All_items: ' || ' v_parent_ato ' || v_parent_ato_line_id
1518: || ' v_ato ' || v_ato_line_id
1519: || ' upd count ' || v_update_count , 1);
1520:
1521:

Line 1538: oe_debug_pub.add('Create_All_Items: ' ||

1534: set config_item_id = lXConfigId
1535: where line_id = v_model_lines.line_id
1536: returning config_creation into v_bcmo_config_orgs ;
1537:
1538: oe_debug_pub.add('Create_All_Items: ' ||
1539: 'update bcol count::'||
1540: SQL%ROWCOUNT , 1);
1541:
1542: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId

Line 1542: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId

1538: oe_debug_pub.add('Create_All_Items: ' ||
1539: 'update bcol count::'||
1540: SQL%ROWCOUNT , 1);
1541:
1542: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId
1543: || ' for ' || v_model_lines.line_id
1544: || ' config_orgs ' || v_bcmo_config_orgs
1545: || ' rows ' || SQL%ROWCOUNT, 1);
1546:

Line 1553: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId

1549: bom_cto_order_lines_gt
1550: set config_item_id = lXConfigId
1551: where line_id = v_model_lines.line_id ;
1552:
1553: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId
1554: || ' for ' || v_model_lines.line_id
1555: || ' rows ' || SQL%ROWCOUNT, 1);
1556:
1557:

Line 1571: oe_debug_pub.add ('Create_All_items: matched item ' || 'updated bcmo ' || lXConfigId

1567: where group_reference_id = v_bcso_group_reference_id ;
1568:
1569:
1570:
1571: oe_debug_pub.add ('Create_All_items: matched item ' || 'updated bcmo ' || lXConfigId
1572: || ' line id info ' || v_model_lines.line_id
1573: || ' for ' || v_bcso_group_reference_id
1574: || ' rows ' || SQL%ROWCOUNT, 1);
1575:

Line 1587: oe_debug_pub.add ('Create_All_items: ' || 'updated bcso_b ' || lXConfigId

1583: set config_item_id = lXConfigId
1584: where line_id = v_model_lines.line_id ;
1585:
1586:
1587: oe_debug_pub.add ('Create_All_items: ' || 'updated bcso_b ' || lXConfigId
1588: || ' for ' || v_model_lines.line_id
1589: || ' rows ' || SQL%ROWCOUNT, 1);
1590:
1591:

Line 1612: oe_debug_pub.add('Create_All_Items: Handle Item Creation for Type 1 , 2 , Preconfig or no match/reuse ' , 1 ) ;

1608: or
1609: ( p_mode = 'PRECONFIG' )
1610: ) then
1611:
1612: oe_debug_pub.add('Create_All_Items: Handle Item Creation for Type 1 , 2 , Preconfig or no match/reuse ' , 1 ) ;
1613:
1614: lStatus := CTO_CONFIG_ITEM_PK.create_item(
1615: pModelId => v_model_lines.inventory_item_id,
1616: pLineId => v_model_lines.line_id,

Line 1624: oe_debug_pub.add('Create_All_Items: ' ||

1620: p_mode => p_mode );
1621:
1622: IF lStatus <> 1 THEN
1623: IF PG_DEBUG <> 0 THEN
1624: oe_debug_pub.add('Create_All_Items: ' ||
1625: 'Create_Item returned 0::item::'||
1626: to_char(v_model_lines.inventory_item_id), 1);
1627: END IF;
1628:

Line 1639: oe_debug_pub.add('Create_All_Items: ' || 'conifg item id passed to ENI=>'||

1635:
1636: l_eni_star_record.inventory_item_id := lxConfigId;
1637:
1638: IF PG_DEBUG <> 0 THEN
1639: oe_debug_pub.add('Create_All_Items: ' || 'conifg item id passed to ENI=>'||
1640: l_eni_star_record.inventory_item_id , 5);
1641: END IF;
1642:
1643: --follwoing API is maintained by PLM,DBI team present in Bom source control

Line 1662: oe_debug_pub.add('Cto_Eni_Wrapper_Api:' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'

1658: --CTO has decided not to fail for error messages but just log messages
1659: --refer bug 3124169 for more info
1660: IF eni_return_status = 'S' THEN
1661: IF PG_DEBUG <> 0 THEN
1662: oe_debug_pub.add('Cto_Eni_Wrapper_Api:' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
1663: ||eni_return_status, 5);
1664: END IF;
1665: ELSE
1666: IF PG_DEBUG <> 0 THEN

Line 1667: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'

1663: ||eni_return_status, 5);
1664: END IF;
1665: ELSE
1666: IF PG_DEBUG <> 0 THEN
1667: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
1668: ||eni_return_status, 1);
1669: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'IGNORING ABOVE ERROR', 1);
1670: END IF;
1671:

Line 1669: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'IGNORING ABOVE ERROR', 1);

1665: ELSE
1666: IF PG_DEBUG <> 0 THEN
1667: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
1668: ||eni_return_status, 1);
1669: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'IGNORING ABOVE ERROR', 1);
1670: END IF;
1671:
1672: END IF;
1673:

Line 1683: oe_debug_pub.add('Create_All_Items: ' ||

1679: END IF;
1680:
1681:
1682: IF PG_DEBUG <> 0 THEN
1683: oe_debug_pub.add('Create_All_Items: ' ||
1684: 'Create_Item returned with lStatus::'||to_char(lStatus), 2);
1685:
1686: oe_debug_pub.add('Create_All_Items: ' || 'ITEM CREATED IS ::'||
1687: to_char(lxConfigId), 1);

Line 1686: oe_debug_pub.add('Create_All_Items: ' || 'ITEM CREATED IS ::'||

1682: IF PG_DEBUG <> 0 THEN
1683: oe_debug_pub.add('Create_All_Items: ' ||
1684: 'Create_Item returned with lStatus::'||to_char(lStatus), 2);
1685:
1686: oe_debug_pub.add('Create_All_Items: ' || 'ITEM CREATED IS ::'||
1687: to_char(lxConfigId), 1);
1688:
1689:
1690:

Line 1691: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);

1687: to_char(lxConfigId), 1);
1688:
1689:
1690:
1691: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);
1692: END IF;
1693:
1694:
1695: /* update newly created config in bcol and bcol_temp */

Line 1703: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId

1699: where line_id = v_model_lines.line_id
1700: returning perform_match into v_perform_match;
1701:
1702:
1703: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId
1704: || ' for ' || v_model_lines.line_id , 1);
1705:
1706:
1707: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);

Line 1707: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);

1703: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId
1704: || ' for ' || v_model_lines.line_id , 1);
1705:
1706:
1707: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);
1708:
1709: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1710: bom_cto_order_lines_gt
1711: set config_item_id = lXConfigId

Line 1715: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId

1711: set config_item_id = lXConfigId
1712: where line_id = v_model_lines.line_id ;
1713:
1714:
1715: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId
1716: || ' for ' || v_model_lines.line_id , 1);
1717:
1718: IF( NVL(v_model_lines.config_creation, 1) IN (1,2) OR
1719: (v_model_lines.config_creation = 3 AND v_perform_match = 'N')) THEN --Bugfix 7640680

Line 1727: oe_debug_pub.add ('Create_All_items: ' || 'updated bcso ' || lXConfigId

1723: where line_id = v_model_lines.line_id ;
1724:
1725: END IF;
1726:
1727: oe_debug_pub.add ('Create_All_items: ' || 'updated bcso ' || lXConfigId
1728: || ' for ' || v_model_lines.line_id
1729: || ' config_creation ' || v_model_lines.config_creation
1730: || ' rows ' || SQL%ROWCOUNT, 1);
1731:

Line 1748: oe_debug_pub.add ('Create_All_items: ' || 'updated bcmo ' || lXConfigId

1744: where group_reference_id = v_bcso_group_reference_id ;
1745:
1746:
1747:
1748: oe_debug_pub.add ('Create_All_items: ' || 'updated bcmo ' || lXConfigId
1749: || ' for ' || v_bcso_group_reference_id
1750: || ' rows ' || SQL%ROWCOUNT, 1);
1751:
1752:

Line 1765: oe_debug_pub.add ('Create_All_items: ' || 'canning configuration' || v_model_lines.line_id, 1);

1761:
1762:
1763: IF( v_perform_match = 'U') then
1764:
1765: oe_debug_pub.add ('Create_All_items: ' || 'canning configuration' || v_model_lines.line_id, 1);
1766:
1767: /* CAN configuration for items created when match profile = 'Yes' */
1768:
1769: lStatus := CTO_MATCH_CONFIG.can_configurations(

Line 1828: oe_debug_pub.add ('Create_All_Items: ' ||

1824: end ;
1825:
1826:
1827: IF PG_DEBUG <> 0 THEN
1828: oe_debug_pub.add ('Create_All_Items: ' ||
1829: 'v_model_item_status ' || to_char(v_model_item_status) ||
1830: 'v_config_item_status ' || to_char(v_config_item_status) , 1);
1831: END IF;
1832:

Line 1838: oe_debug_pub.add ('Create_All_Items: ' || 'Error: Item Not Enabled in some orgs', 1);

1834: if( v_model_item_status = 1 or v_config_item_status = 1 ) then
1835:
1836:
1837: IF PG_DEBUG <> 0 THEN
1838: oe_debug_pub.add ('Create_All_Items: ' || 'Error: Item Not Enabled in some orgs', 1);
1839: END IF;
1840:
1841: select concatenated_segments into v_model_item_name
1842: from mtl_system_items_kfv

Line 1870: oe_debug_pub.add ('Create_All_Items: ' || 'Item Enabled in all orgs', 1);

1866:
1867: else
1868:
1869: IF PG_DEBUG <> 0 THEN
1870: oe_debug_pub.add ('Create_All_Items: ' || 'Item Enabled in all orgs', 1);
1871: END IF;
1872:
1873:
1874: end if;

Line 1877: oe_debug_pub.add('Create_All_Items: No need to Handle Item Creation for Type 3 matched AutoConfig ' , 1 ) ;

1873:
1874: end if;
1875:
1876:
1877: oe_debug_pub.add('Create_All_Items: No need to Handle Item Creation for Type 3 matched AutoConfig ' , 1 ) ;
1878:
1879:
1880:
1881:

Line 1891: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId

1887: set config_item_id = lXConfigId
1888: where line_id = v_model_lines.line_id ;
1889:
1890:
1891: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId
1892: || ' for ' || v_model_lines.line_id , 1);
1893:
1894:
1895:

Line 1902: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId

1898: set config_item_id = lXConfigId
1899: where line_id = v_model_lines.line_id ;
1900:
1901:
1902: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId
1903: || ' for ' || v_model_lines.line_id , 1);
1904:
1905:
1906: select group_reference_id into v_bcso_group_reference_id from bom_cto_src_orgs_b

Line 1917: oe_debug_pub.add ('Create_All_items: ' || 'updated bcmo ' || lXConfigId

1913: where group_reference_id = v_bcso_group_reference_id ;
1914:
1915:
1916:
1917: oe_debug_pub.add ('Create_All_items: ' || 'updated bcmo ' || lXConfigId
1918: || ' for ' || v_bcso_group_reference_id
1919: || ' rows ' || SQL%ROWCOUNT, 1);
1920:
1921:

Line 1929: oe_debug_pub.add ('Create_All_items: ' || 'updated bcso ' || lXConfigId

1925: where line_id = v_model_lines.line_id ;
1926:
1927:
1928:
1929: oe_debug_pub.add ('Create_All_items: ' || 'updated bcso ' || lXConfigId
1930: || ' for ' || v_model_lines.line_id
1931: || ' rows ' || SQL%ROWCOUNT, 1);
1932:
1933:

Line 1937: oe_debug_pub.add('Create_All_Items: Handle Item Creation for Type 3 reuse ' , 1 ) ;

1933:
1934:
1935: elsif ( lXConfigId is not null and nvl(v_model_lines.config_creation, 1) = 3 and v_perform_match = 'N' ) then
1936:
1937: oe_debug_pub.add('Create_All_Items: Handle Item Creation for Type 3 reuse ' , 1 ) ;
1938:
1939: lStatus := CTO_CONFIG_ITEM_PK.create_item(
1940: pModelId => v_model_lines.inventory_item_id,
1941: pLineId => v_model_lines.line_id,

Line 1949: oe_debug_pub.add('Create_All_Items: ' ||

1945: p_mode => p_mode );
1946:
1947: IF lStatus <> 1 THEN
1948: IF PG_DEBUG <> 0 THEN
1949: oe_debug_pub.add('Create_All_Items: ' ||
1950: 'Create_Item returned 0::item::'||
1951: to_char(v_model_lines.inventory_item_id), 1);
1952: END IF;
1953:

Line 1964: oe_debug_pub.add('Create_All_Items: ' || 'conifg item id passed to ENI=>'||

1960:
1961: l_eni_star_record.inventory_item_id := lxConfigId;
1962:
1963: IF PG_DEBUG <> 0 THEN
1964: oe_debug_pub.add('Create_All_Items: ' || 'conifg item id passed to ENI=>'||
1965: l_eni_star_record.inventory_item_id , 5);
1966: END IF;
1967:
1968: --follwoing API is maintained by PLM,DBI team present in Bom source control

Line 1987: oe_debug_pub.add('Cto_Eni_Wrapper_Api:' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'

1983: --CTO has decided not to fail for error messages but just log messages
1984: --refer bug 3124169 for more info
1985: IF eni_return_status = 'S' THEN
1986: IF PG_DEBUG <> 0 THEN
1987: oe_debug_pub.add('Cto_Eni_Wrapper_Api:' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
1988: ||eni_return_status, 5);
1989: END IF;
1990: ELSE
1991: IF PG_DEBUG <> 0 THEN

Line 1992: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'

1988: ||eni_return_status, 5);
1989: END IF;
1990: ELSE
1991: IF PG_DEBUG <> 0 THEN
1992: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
1993: ||eni_return_status, 1);
1994: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'IGNORING ABOVE ERROR', 1);
1995: END IF;
1996:

Line 1994: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'IGNORING ABOVE ERROR', 1);

1990: ELSE
1991: IF PG_DEBUG <> 0 THEN
1992: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
1993: ||eni_return_status, 1);
1994: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'IGNORING ABOVE ERROR', 1);
1995: END IF;
1996:
1997: END IF;
1998:

Line 2008: oe_debug_pub.add('Create_All_Items: ' ||

2004: END IF;
2005:
2006:
2007: IF PG_DEBUG <> 0 THEN
2008: oe_debug_pub.add('Create_All_Items: ' ||
2009: 'Create_Item returned with lStatus::'||to_char(lStatus), 2);
2010:
2011: oe_debug_pub.add('Create_All_Items: ' || 'ITEM CREATED IS ::'||
2012: to_char(lxConfigId), 1);

Line 2011: oe_debug_pub.add('Create_All_Items: ' || 'ITEM CREATED IS ::'||

2007: IF PG_DEBUG <> 0 THEN
2008: oe_debug_pub.add('Create_All_Items: ' ||
2009: 'Create_Item returned with lStatus::'||to_char(lStatus), 2);
2010:
2011: oe_debug_pub.add('Create_All_Items: ' || 'ITEM CREATED IS ::'||
2012: to_char(lxConfigId), 1);
2013: END IF;
2014:
2015:

Line 2023: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId

2019: set config_item_id = lXConfigId
2020: where line_id = v_model_lines.line_id ;
2021:
2022:
2023: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId
2024: || ' for ' || v_model_lines.line_id , 1);
2025:
2026:
2027:

Line 2034: oe_debug_pub.add ('Create_All_items: ' || 'updated bcso ' || lXConfigId

2030: where line_id = v_model_lines.line_id ;
2031:
2032:
2033:
2034: oe_debug_pub.add ('Create_All_items: ' || 'updated bcso ' || lXConfigId
2035: || ' for ' || v_model_lines.line_id
2036: || ' config_creation ' || v_model_lines.config_creation
2037: || ' rows ' || SQL%ROWCOUNT, 1);
2038:

Line 2051: oe_debug_pub.add('Count Wt:' || CTO_CONFIG_ITEM_PK.g_wt_tbl.count ||

2047: --Bugfix 9223554: Clear the global collection g_wt_tbl and g_vol_tbl
2048: CTO_CONFIG_ITEM_PK.g_wt_tbl.delete;
2049: CTO_CONFIG_ITEM_PK.g_vol_tbl.delete;
2050: IF PG_DEBUG <> 0 THEN
2051: oe_debug_pub.add('Count Wt:' || CTO_CONFIG_ITEM_PK.g_wt_tbl.count ||
2052: 'Count Vol:' || CTO_CONFIG_ITEM_PK.g_vol_tbl.count, 1);
2053: END IF;
2054:
2055: return(1);

Line 2060: oe_debug_pub.add('Create_All_Items: ' || 'create_all_items::ndf::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);

2056:
2057: EXCEPTION
2058: when NO_DATA_FOUND then
2059: IF PG_DEBUG <> 0 THEN
2060: oe_debug_pub.add('Create_All_Items: ' || 'create_all_items::ndf::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2061: END IF;
2062: xReturnStatus := fnd_api.g_ret_sts_error;
2063: cto_msg_pub.count_and_get
2064: ( p_msg_count => xMsgCount

Line 2071: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::exp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);

2067: return(0);
2068:
2069: when FND_API.G_EXC_ERROR then
2070: IF PG_DEBUG <> 0 THEN
2071: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::exp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2072: END IF;
2073: xReturnStatus := fnd_api.g_ret_sts_error;
2074: cto_msg_pub.count_and_get
2075: ( p_msg_count => xMsgCount

Line 2082: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);

2078: return(0);
2079:
2080: when FND_API.G_EXC_UNEXPECTED_ERROR then
2081: IF PG_DEBUG <> 0 THEN
2082: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2083: END IF;
2084: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2085: cto_msg_pub.count_and_get
2086: ( p_msg_count => xMsgCount

Line 2093: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::others::'||to_char(lStmtNum)||'::'||sqlerrm, 1);

2089: return(0);
2090:
2091: when OTHERS then
2092: IF PG_DEBUG <> 0 THEN
2093: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::others::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2094: END IF;
2095: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2096: cto_msg_pub.count_and_get
2097: ( p_msg_count => xMsgCount

Line 2176: oe_debug_pub.add( ' perform_match bcol count ' || v_bcol_count , 1 ) ;

2172: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt
2173: where ato_line_id = p_ato_line_id ;
2174:
2175:
2176: oe_debug_pub.add( ' perform_match bcol count ' || v_bcol_count , 1 ) ;
2177: oe_debug_pub.add( ' perform_match bcol_gt count ' || v_bcol_gt_count , 1 ) ;
2178:
2179: l_stmt_num := 1;
2180:

Line 2177: oe_debug_pub.add( ' perform_match bcol_gt count ' || v_bcol_gt_count , 1 ) ;

2173: where ato_line_id = p_ato_line_id ;
2174:
2175:
2176: oe_debug_pub.add( ' perform_match bcol count ' || v_bcol_count , 1 ) ;
2177: oe_debug_pub.add( ' perform_match bcol_gt count ' || v_bcol_gt_count , 1 ) ;
2178:
2179: l_stmt_num := 1;
2180:
2181: x_match_found := 'N' ;

Line 2200: oe_debug_pub.add( ' perform_match: line_id ' || l_next_rec.line_id || ' match ' || l_perform_match , 1 ) ;

2196: from bom_cto_order_lines
2197: where line_id = l_next_rec.line_id ;
2198:
2199:
2200: oe_debug_pub.add( ' perform_match: line_id ' || l_next_rec.line_id || ' match ' || l_perform_match , 1 ) ;
2201:
2202:
2203: if( l_perform_match = 'U' ) then
2204:

Line 2227: oe_debug_pub.add('Standard Match.', 1);

2223: elsif( l_perform_match in( 'Y' , 'C' ) ) then
2224:
2225: if ( l_perform_match = 'Y' ) then
2226: l_stmt_num := 10;
2227: oe_debug_pub.add('Standard Match.', 1);
2228: l_status := cto_match_config.check_config_match(
2229: l_next_rec.line_id,
2230: l_x_config_id,
2231: l_x_error_msg,

Line 2234: oe_debug_pub.add(' done Check Config Match ' , 1 ) ;

2230: l_x_config_id,
2231: l_x_error_msg,
2232: l_x_error_msg_name);
2233:
2234: oe_debug_pub.add(' done Check Config Match ' , 1 ) ;
2235:
2236:
2237: elsif ( l_perform_match = 'C' ) then
2238: l_stmt_num := 15;

Line 2250: oe_debug_pub.add('Failed in Check Config Match for line id '

2246:
2247: l_stmt_num := 20;
2248:
2249: if (l_status = 0) then
2250: oe_debug_pub.add('Failed in Check Config Match for line id '
2251: || to_char(l_next_rec.line_id), 1);
2252:
2253: raise PROCESS_ERROR;
2254:

Line 2321: oe_debug_pub.add('Match for line id '

2317:
2318: l_stmt_num := 35;
2319:
2320:
2321: oe_debug_pub.add('Match for line id '
2322: || to_char(l_next_rec.line_id)
2323: || ' is ' || to_char(l_x_config_id) ,1);
2324:
2325:

Line 2332: oe_debug_pub.add( 'perform_match: bcol update ' || SQL%rowcount , 1 ) ;

2328: where line_id = l_next_rec.line_id;
2329:
2330:
2331:
2332: oe_debug_pub.add( 'perform_match: bcol update ' || SQL%rowcount , 1 ) ;
2333:
2334: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2335: bom_cto_order_lines_gt
2336: set config_item_id = l_x_config_id

Line 2340: oe_debug_pub.add( 'perform_match: bcol_gt update ' || SQL%rowcount , 1 ) ;

2336: set config_item_id = l_x_config_id
2337: where line_id = l_next_rec.line_id;
2338:
2339:
2340: oe_debug_pub.add( 'perform_match: bcol_gt update ' || SQL%rowcount , 1 ) ;
2341:
2342: l_stmt_num := 40 ;
2343:
2344: x_matching_config_id := l_x_config_id ;

Line 2359: oe_debug_pub.add(' Match OFF for line id '

2355: end if;
2356:
2357: else
2358:
2359: oe_debug_pub.add(' Match OFF for line id '
2360: || to_char(l_next_rec.line_id) ,1);
2361:
2362:
2363: x_match_found := 'N' ;

Line 2375: oe_debug_pub.add ( ' exception in match at step ' || to_char( l_stmt_num ) ) ;

2371:
2372: exception
2373: when others then
2374: V_SQLCODE := SQLCODE ;
2375: oe_debug_pub.add ( ' exception in match at step ' || to_char( l_stmt_num ) ) ;
2376: -- insert into my_debug_messages values ( ' exception in match at step ' || to_char( l_stmt_num ) ) ;
2377: -- insert into my_debug_messages values ( ' exception in match SQL ' || to_char( V_SQLCODE ) ) ;
2378:
2379: end perform_match ;

Line 2419: oe_debug_pub.add ( ' entered evaluate item behavior ' , 1 ) ;

2415: i number ;
2416:
2417: begin
2418:
2419: oe_debug_pub.add ( ' entered evaluate item behavior ' , 1 ) ;
2420:
2421:
2422:
2423: open c_item_behavior ;

Line 2454: oe_debug_pub.add( 'evaluate_item_behavior:' || ' item behavior violated for line id ' || t_bcol(i).line_id

2450:
2451:
2452: if( t_bcol(i).config_creation in ( 1, 2 ) and t_bcol(t_bcol(i).parent_ato_line_id).config_creation = 3 ) then
2453:
2454: oe_debug_pub.add( 'evaluate_item_behavior:' || ' item behavior violated for line id ' || t_bcol(i).line_id
2455: || ' behavior ' || t_bcol(i).config_creation
2456: || ' parent ato line ' || t_bcol(i).parent_ato_line_id
2457: || ' parent behavior ' || t_bcol(t_bcol(i).parent_ato_line_id).config_creation , 1 ) ;
2458:

Line 2473: oe_debug_pub.add( 'evaluate_item_behavior:' || ' item behavior violated ' , 1 ) ;

2469:
2470: exception
2471: when item_behavior_violated then
2472:
2473: oe_debug_pub.add( 'evaluate_item_behavior:' || ' item behavior violated ' , 1 ) ;
2474:
2475:
2476: end evaluate_item_behavior;
2477: