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 215: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;

211:
212: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
213: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
214:
215: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
216:
217:
218: begin
219:

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

245: --
246:
247: lStmtNum := 5;
248: IF PG_DEBUG <> 0 THEN
249: oe_debug_pub.add('Create_And_Link_Item: ' || 'pTopAtoLineId::'||to_char(pTopAtoLineId), 2);
250: END IF;
251:
252:
253:

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

258:
259: -- delete from bom_cto_order_lines where ato_line_id = pTopAtoLineId ;
260:
261: IF PG_DEBUG <> 0 THEN
262: oe_debug_pub.add('Create_And_Link_Item: ' || ' deleted ' || SQL%ROWCOUNT ||
263: ' from bcol ' || to_char(pTopAtoLineId), 2);
264: END IF;
265:
266: CTO_UTILITY_PK.Populate_Bcol(

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

275:
276: if XReturnStatus = FND_API.G_RET_STS_ERROR then
277:
278: IF PG_DEBUG <> 0 THEN
279: oe_debug_pub.add ('Create_And_Link_Item: ' ||
280: 'Failed in populate_bcol with expected error.', 1);
281: END IF;
282:
283: raise FND_API.G_EXC_ERROR;

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

284:
285: elsif XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR then
286:
287: IF PG_DEBUG <> 0 THEN
288: oe_debug_pub.add ('Create_And_Link_Item: ' ||
289: 'Failed in populate_bcol with unexpected error.', 1);
290: END IF;
291:
292: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

292: raise FND_API.G_EXC_UNEXPECTED_ERROR;
293: end if;
294:
295: IF PG_DEBUG <> 0 THEN
296: oe_debug_pub.add('Create_And_Link_Item: ' || 'After Populate_Bcol', 5);
297: END IF;
298:
299:
300:

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

308:
309: lStmtNum := 10 ;
310:
311:
312: oe_debug_pub.add( 'came into PRECONFIG UPDATE BCOL QUERY ' , 1 ) ;
313:
314: update bom_cto_order_lines
315: set perform_match = 'Y'
316: where ato_line_id = pTopAtoLineId

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

325: having count(*) > 1
326: );
327:
328:
329: oe_debug_pub.add( 'PRECONFIG Similar Instance UPDATE BCOL QUERY count ' || SQL%ROWCOUNT , 1 ) ;
330:
331:
332:
333: end if; /* check for autoconfig or preconfig */

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

339: -- Step 2) Call Reuse for current configuration
340: --
341:
342:
343: oe_debug_pub.add('Create_And_Link_Item: ' || 'REUSE Section ', 5);
344:
345:
346: lStmtNum := 20 ;
347:

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

351:
352: lReuseProfile := FND_PROFILE.Value('CTO_REUSE_CONFIG'); --Bugfix 6642016
353:
354: IF PG_DEBUG <> 0 THEN
355: oe_debug_pub.add('Create_And_Link_Item: ' ||
356: ' Reuse Configuration profile: ' || to_char(lReuseProfile) , 5);
357: END IF; --Bugfix 6642016
358:
359: if ( nvl(lReuseProfile,1) = 1 ) then ----Bugfix 6642016

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

362: where ato_line_id = pTopAtoLineId ;
363:
364:
365: IF PG_DEBUG <> 0 THEN
366: oe_debug_pub.add('Create_And_Link_Item: ' ||
367: ' calling reuse config' || to_char(v_reuse_bcol_count) , 5);
368: END IF;
369:
370: /* call reuse config api */

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

378:
379:
380:
381: IF PG_DEBUG <> 0 THEN
382: oe_debug_pub.add('Create_And_Link_Item: done reuse. ' , 5);
383: END IF;
384:
385: end if; --lReuseProfile = 1 Bugfix 6642016
386:

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

401: end ;
402:
403:
404: IF PG_DEBUG <> 0 THEN
405: oe_debug_pub.add('Create_And_Link_Item: ' ||
406: ' v_bcol_ship_from_org_id : ' || v_bcol_ship_from_org_id ||
407: ' v_bcolgt_ship_from_org_id : ' || v_bcolgt_ship_from_org_id
408: , 5);
409: END IF;

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

417:
418:
419:
420: IF PG_DEBUG <> 0 THEN
421: oe_debug_pub.add('Create_And_Link_Item: done oss flag update for reuse. ' , 5);
422: END IF;
423:
424:
425: /* delete from bcol */

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

426:
427: delete from bom_cto_order_lines where ato_line_id = pTopAtoLineId ;
428:
429: IF PG_DEBUG <> 0 THEN
430: oe_debug_pub.add('Create_And_Link_Item: ' ||
431: ' deleting from bcol ' || to_char(sql%rowcount) , 5);
432: END IF;
433:
434: lStmtNum := 30 ;

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

505: where ato_line_id = pTopAtoLineId ;
506: /* add ods and reuse flag */
507:
508: IF PG_DEBUG <> 0 THEN
509: oe_debug_pub.add('Create_And_Link_Item: ' || SQL%ROWCOUNT ||
510: ' copied from bcol_gt to bcol ', 5);
511: END IF;
512:
513:

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

516:
517:
518: lStmtNum := 40 ;
519:
520: oe_debug_pub.add('Create_And_Link_Item: ' || 'copy bcol to bcol_gt ', 5);
521: /* copy bcol data to bcol_temp for matching */
522:
523: insert into bom_cto_order_lines_gt (
524: LINE_ID

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

590: ,SHIP_FROM_ORG_ID --for bugfix3555026
591: from bom_cto_order_lines
592: where ato_line_id = pTopAtoLineId ;
593:
594: oe_debug_pub.add('Create_And_Link_Item: ' || ' copied bcol to bcol gt rows ' || SQL%ROWCOUNT , 5);
595: end if ; /* bcol data exists */
596: end if ; /* p_mode = AUTOCONFIG */
597:
598:

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

596: end if ; /* p_mode = AUTOCONFIG */
597:
598:
599: IF PG_DEBUG <> 0 THEN
600: oe_debug_pub.add('Create_And_Link_Item: ' ||
601: ' querying Reuse Flag ' , 2);
602: END IF;
603:
604: lStmtNum := 50 ;

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

610: from bom_cto_order_lines
611: where line_id = pTopAtoLineId ;
612:
613: IF PG_DEBUG <> 0 THEN
614: oe_debug_pub.add('Create_And_Link_Item: ' ||
615: 'Reuse item ' || v_reuse_config_item_id ||
616: ' Reuse Flag ' || v_reuse_config_flag ||
617: ' Config Creation ' || v_reuse_config_creation
618: , 2);

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

640: -- 2) Line_id's in OE and BCOL matches for specific ato_line_id in question
641:
642:
643: IF PG_DEBUG <> 0 THEN
644: oe_debug_pub.add('create_and_link_item: ' || 'going to call validate_oe_data ', 1 );
645: END IF;
646:
647: CTO_UTILITY_PK.validate_oe_data(p_bcol_line_id => pTopAtoLineId,
648: x_return_status => xReturnStatus);

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

648: x_return_status => xReturnStatus);
649:
650:
651: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS THEN
652: oe_debug_pub.add('create_and_link_item: ' || 'Error in OE BCOL Validation',5);
653: raise FND_API.G_EXC_UNEXPECTED_ERROR;
654: end if;
655:
656:

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

663:
664:
665:
666:
667: oe_debug_pub.add('create_and_link_item: BCOL DATA ' || ' line_id ' ||
668: ' inventory_item_id ' || ' ship_org ' || ' match ' ||
669: ' config item ' || ' CIB ' || ' level ' || ' link ' , 1 ) ;
670: FOR v_debug IN c_debug LOOP
671: IF PG_DEBUG <> 0 THEN

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

668: ' inventory_item_id ' || ' ship_org ' || ' match ' ||
669: ' config item ' || ' CIB ' || ' level ' || ' link ' , 1 ) ;
670: FOR v_debug IN c_debug LOOP
671: IF PG_DEBUG <> 0 THEN
672: oe_debug_pub.add('create_and_link_item: ' || to_char(v_debug.line_id)||' '||
673: to_char(v_debug.inventory_item_id)||' '||
674: nvl(to_char(v_debug.ship_from_org_id),null)||' '||
675: to_char(v_debug.perform_match)||' '||
676: nvl(v_debug.config_item_id, null)||' '||

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

705: if ( v_reuse_config_item_id is not null and v_reuse_config_flag = 'Y' and v_bcso_data_exists = 'Y') then
706:
707:
708: IF PG_DEBUG <> 0 THEN
709: oe_debug_pub.add('Create_And_Link_Item: ' ||
710: 'Will Not Perform Any Item processing as it is reuse case ', 2);
711: END IF;
712:
713:

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

721:
722: delete from bom_cto_src_orgs_b where top_model_line_id = pTopAtoLineId ;
723:
724: IF PG_DEBUG <> 0 THEN
725: oe_debug_pub.add('Create_And_Link_Item: ' ||
726: ' deleted from bcso_b as reuse is not applicable or doesnt exist '
727: || to_char(sql%rowcount) , 5);
728: END IF;
729:

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

735: --
736: -- Step 3) Call Match for current configuration
737: --
738:
739: oe_debug_pub.add('Create_And_Link_Item: ' || 'Match section ', 5);
740:
741:
742: lStmtNum := 50 ;
743:

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

742: lStmtNum := 50 ;
743:
744: lMatchProfile := FND_PROFILE.Value('BOM:MATCH_CONFIG');
745:
746: oe_debug_pub.add('Create_And_Link_Item: ' || ' Done Match section ', 5);
747: oe_debug_pub.add('Create_And_Link_Item: ' || ' Done Match section ' || lMatchProfile , 5);
748:
749: if( lMatchProfile = 1 and p_mode = 'AUTOCONFIG' ) then
750:

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

743:
744: lMatchProfile := FND_PROFILE.Value('BOM:MATCH_CONFIG');
745:
746: oe_debug_pub.add('Create_And_Link_Item: ' || ' Done Match section ', 5);
747: oe_debug_pub.add('Create_And_Link_Item: ' || ' Done Match section ' || lMatchProfile , 5);
748:
749: if( lMatchProfile = 1 and p_mode = 'AUTOCONFIG' ) then
750:
751:

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

748:
749: if( lMatchProfile = 1 and p_mode = 'AUTOCONFIG' ) then
750:
751:
752: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || ' going to call CTO_MATCH_CONFIG perform_match ' , 1 ) ;
753:
754:
755: CTO_MATCH_CONFIG.perform_match( pTopAtoLineId ,
756: x_return_status ,

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

757: x_msg_count,
758: x_msg_data
759: ) ;
760:
761: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || ' done perform_match ' , 1 ) ;
762:
763:
764:
765: lStmtNum := 55 ;

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

769: from bom_cto_order_lines_gt
770: where line_id = pTopAtoLineId ;
771:
772:
773: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM:: perform match data ' ||
774: 'x_match_found ' || x_match_found ||
775: 'x_top_matched_item_id ' || to_char( x_top_matched_item_id )
776: , 1 ) ;
777:

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

776: , 1 ) ;
777:
778:
779: if( x_match_found = 'Y' ) then
780: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || 'Top Model Match Success ' , 1 ) ;
781: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || 'Top Match '|| to_char( x_top_matched_item_id ) , 1 ) ;
782:
783: null ;
784:

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

777:
778:
779: if( x_match_found = 'Y' ) then
780: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || 'Top Model Match Success ' , 1 ) ;
781: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM ' || 'Top Match '|| to_char( x_top_matched_item_id ) , 1 ) ;
782:
783: null ;
784:
785: end if ;

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

789:
790:
791:
792: lStmtNum := 60 ;
793: oe_debug_pub.add('Create_And_Link_Item: ' || ' Going to Synch up BCOL with data from BCOL_GT for matched info ' , 5);
794:
795:
796:
797: update bom_cto_order_lines bcol

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

802: where bcol.line_id = bcol_gt.line_id )
803: where bcol.ato_line_id = pTopAtoLineId ;
804:
805:
806: oe_debug_pub.add('Create_And_Link_Item: ' || ' Synch up BCOL with data from BCOL_GT for matched info rows ' || SQL%ROWCOUNT , 5);
807:
808:
809: --
810: --

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

823:
824:
825: IF (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
826: IF PG_DEBUG <> 0 THEN
827: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);
828: END IF;
829: raise FND_API.G_EXC_ERROR;
830:
831: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

829: raise FND_API.G_EXC_ERROR;
830:
831: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
832: IF PG_DEBUG <> 0 THEN
833: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);
834: END IF;
835: raise FND_API.G_EXC_UNEXPECTED_ERROR;
836:
837: END IF;

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

836:
837: END IF;
838:
839: IF PG_DEBUG <> 0 THEN
840: oe_debug_pub.add('Create_And_Link_Item: ' || 'After process_oss_configurations ', 2);
841: END IF;
842:
843:
844:

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

865:
866:
867:
868: IF PG_DEBUG <> 0 THEN
869: oe_debug_pub.add('Create_And_Link_Item: ' || 'Before CTO_MSUTIL_PUB.Populate_Src_Orgs', 2);
870: END IF;
871: lStatus := CTO_MSUTIL_PUB.Populate_Src_Orgs(
872: pTopAtoLineId => pTopAtoLineId,
873: x_return_status => XReturnStatus,

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

875: x_msg_data => XMsgData);
876:
877: IF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
878: IF PG_DEBUG <> 0 THEN
879: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with exp error',1);
880: END IF;
881: raise FND_API.G_EXC_ERROR;
882:
883: ELSIF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

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

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

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

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

910: end if;
911:
912: if (length(lCiDel )<> 1 ) then
913: IF PG_DEBUG <> 0 THEN
914: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error: Length of delimiter <> 1', 1);
915: END IF;
916: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
917: raise FND_API.G_EXC_ERROR;
918: end if;

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

916: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
917: raise FND_API.G_EXC_ERROR;
918: end if;
919: IF PG_DEBUG <> 0 THEN
920: oe_debug_pub.add('Create_And_Link_Item: ' || 'Delimiter is : ' || lCiDel,2);
921: END IF;
922:
923:
924: --

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

933: and id_flex_code = 'MSTK'
934: and id_flex_num = 101;
935:
936: IF PG_DEBUG <> 0 THEN
937: oe_debug_pub.add('Create_And_Link_Item: ' || 'Items FF segment Separator is : ' || lSegDel,2);
938: END IF;
939:
940: if ( lSegDel = lCiDel ) then
941: IF PG_DEBUG <> 0 THEN

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

938: END IF;
939:
940: if ( lSegDel = lCiDel ) then
941: IF PG_DEBUG <> 0 THEN
942: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error : Config Item delimiter = System Items FF segment separator. Not a valid setup.', 1);
943:
944: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Please set a different value for profile BOM:Configuration Item Delimiter.',1);
945: END IF;
946: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');

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

940: if ( lSegDel = lCiDel ) then
941: IF PG_DEBUG <> 0 THEN
942: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error : Config Item delimiter = System Items FF segment separator. Not a valid setup.', 1);
943:
944: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Please set a different value for profile BOM:Configuration Item Delimiter.',1);
945: END IF;
946: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
947: raise FND_API.G_EXC_ERROR;
948: end if;

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

959: --
960:
961: lStmtNum := 110 ;
962: IF PG_DEBUG <> 0 THEN
963: oe_debug_pub.add('Create_And_Link_Item: ' || 'SRS Calling Create_All_Items', 2);
964: END IF;
965:
966: lStatus := Create_All_Items(
967: pTopAtoLineId,

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

970: XMsgData,
971: p_mode);
972: IF lStatus <> 1 then
973: IF PG_DEBUG <> 0 THEN
974: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Create_All_Items returned with 0', 1);
975: END IF;
976: --cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
977: raise FND_API.G_EXC_ERROR;
978: end if;

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

980:
981:
982:
983:
984: oe_debug_pub.add ('Create_And_Link_Item: ' || 'calling oss processing ', 1);
985:
986:
987:
988:

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

1013: --
1014:
1015: lStmtNum:= 110;
1016:
1017: oe_debug_pub.add ('Create_Item: ' || ' c_copy_src_rules LOOP ' || v_src_rule.config_creation , 1 );
1018:
1019:
1020: if( v_src_rule.create_src_rules = 'Y' and v_src_rule.config_creation in ( 1, 2) ) then
1021:

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

1021:
1022:
1023:
1024: IF PG_DEBUG <> 0 THEN
1025: oe_debug_pub.add ('Create_Item: ' || 'Copying src rule for cfg item '
1026: ||to_char(v_src_rule.config_item_id)||' in org '||
1027: to_char(v_src_rule.organization_id), 2);
1028: END IF;
1029:

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

1039: x_msg_data => xMsgData);
1040:
1041: IF (lStatus = fnd_api.G_RET_STS_ERROR) THEN
1042: IF PG_DEBUG <> 0 THEN
1043: oe_debug_pub.add ('Create_Item: ' ||
1044: 'Create_Sourcing_Rules returned with expected error.');
1045: END IF;
1046: raise FND_API.G_EXC_ERROR;
1047:

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

1046: raise FND_API.G_EXC_ERROR;
1047:
1048: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
1049: IF PG_DEBUG <> 0 THEN
1050: oe_debug_pub.add ('Create_Item: ' ||
1051: 'Create_Sourcing_Rules returned with unexp error.');
1052: END IF;
1053: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1054:

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

1056:
1057: elsif( v_src_rule.config_creation = 3 ) then
1058:
1059: IF PG_DEBUG <> 0 THEN
1060: oe_debug_pub.add ('Create_Item: ' || 'Copying src rule for cfg item '
1061: ||to_char(v_src_rule.config_item_id)||' in org '||
1062: to_char(v_src_rule.organization_id), 2);
1063: END IF;
1064:

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

1071: x_return_status => lStatus,
1072: x_msg_count => xMsgCount,
1073: x_msg_data => xMsgData);
1074:
1075: oe_debug_pub.add ('Create_Item: type3 sourcing rules done ' , 1) ;
1076:
1077: IF (lStatus = fnd_api.G_RET_STS_ERROR) THEN
1078: IF PG_DEBUG <> 0 THEN
1079: oe_debug_pub.add ('Create_Item: ' ||

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

1075: oe_debug_pub.add ('Create_Item: type3 sourcing rules done ' , 1) ;
1076:
1077: IF (lStatus = fnd_api.G_RET_STS_ERROR) THEN
1078: IF PG_DEBUG <> 0 THEN
1079: oe_debug_pub.add ('Create_Item: ' ||
1080: 'Create_Sourcing_Rules returned with expected error.');
1081: END IF;
1082: raise FND_API.G_EXC_ERROR;
1083:

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

1082: raise FND_API.G_EXC_ERROR;
1083:
1084: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
1085: IF PG_DEBUG <> 0 THEN
1086: oe_debug_pub.add ('Create_Item: ' ||
1087: 'Create_Sourcing_Rules returned with unexp error.');
1088: END IF;
1089: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1090:

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

1094:
1095:
1096: end if;
1097:
1098: oe_debug_pub.add ('Create_Item: next iteration ' , 1) ;
1099:
1100: END LOOP;
1101:
1102:

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

1105: end if; /* Check for Reuse Flag */
1106:
1107:
1108: IF PG_DEBUG <> 0 THEN
1109: oe_debug_pub.add ('Create_And_Link_Item: ' ||
1110: 'Success in Item Creation function', 1);
1111: END IF;
1112:
1113: return(1);

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

1114:
1115: EXCEPTION
1116: when NO_DATA_FOUND then
1117: IF PG_DEBUG <> 0 THEN
1118: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::ndf::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1119: END IF;
1120: cto_msg_pub.count_and_get
1121: ( p_msg_count => xMsgCount
1122: , p_msg_data => xMsgData

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

1125: return(0);
1126:
1127: when FND_API.G_EXC_ERROR then
1128: IF PG_DEBUG <> 0 THEN
1129: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::exp error in stmt '||to_char(lStmtNum), 1);
1130: END IF;
1131: cto_msg_pub.count_and_get
1132: ( p_msg_count => xMsgCount
1133: , p_msg_data => xMsgData

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

1136: return(0);
1137:
1138: when FND_API.G_EXC_UNEXPECTED_ERROR then
1139: IF PG_DEBUG <> 0 THEN
1140: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::unexp error in stmt '||to_char(lStmtNum)||'::'||sqlerrm, 1);
1141: END IF;
1142: cto_msg_pub.count_and_get
1143: ( p_msg_count => xMsgCount
1144: , p_msg_data => xMsgData

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

1147: return(0);
1148:
1149: when OTHERS then
1150: IF PG_DEBUG <> 0 THEN
1151: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::others::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1152: END IF;
1153: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1154: FND_MSG_PUB.Add_Exc_Msg
1155: ('CTO_ITEM_PK'

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

1238:
1239: BEGIN
1240:
1241:
1242: oe_debug_pub.add ('Create_All_items: ' || 'Entered ', 1);
1243:
1244: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
1245: lUserId := nvl(Fnd_Global.USER_ID, -1) ;
1246: lLoginId := nvl(Fnd_Global.LOGIN_ID, -1);

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

1249:
1250:
1251:
1252:
1253: oe_debug_pub.add ('Create_All_items: ' || 'Entered 1 ', 1);
1254:
1255:
1256:
1257:

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

1268:
1269: FOR v_model_lines IN c_model_lines
1270: LOOP
1271:
1272: oe_debug_pub.add ('Create_All_items: ' || 'Entered 2 ', 1);
1273: v_match_found := FALSE ;
1274:
1275:
1276:

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

1274:
1275:
1276:
1277: IF PG_DEBUG <> 0 THEN
1278: oe_debug_pub.add('Create_All_Items: ' || 'loop::'||
1279: to_char(v_model_lines.line_id)||'::'||
1280: to_char(v_model_lines.inventory_item_id), 2);
1281: END IF;
1282:

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

1285: --
1286:
1287: xConfigId := v_model_lines.config_item_id;
1288: IF PG_DEBUG <> 0 THEN
1289: oe_debug_pub.add('Create_All_Items: ' ||
1290: 'Before calling create_item::config_id is::'||to_char(xConfigId), 2);
1291: END IF;
1292:
1293:

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

1291: END IF;
1292:
1293:
1294:
1295: oe_debug_pub.add ('Create_All_items: ' || 'Entered 3' , 1);
1296:
1297:
1298: /* check for perform match flag */
1299:

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

1302: from bom_cto_order_lines
1303: where line_id = v_model_lines.line_id;
1304:
1305:
1306: oe_debug_pub.add ('Create_All_items: ' || 'perform_match ' || v_perform_match , 1);
1307:
1308: lXConfigId := v_model_lines.config_item_id ;
1309:
1310: if( v_perform_match in ( 'Y' , 'C' ) and lXConfigId is null ) then /* Reattempt Match for preconfigured Scenario */

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

1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: end time: ' ||
1332: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));
1333:
1334: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then
1335: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1336: raise fnd_api.g_exc_unexpected_error;
1337: end if;
1338:
1339: --check for error cases

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

1338:
1339: --check for error cases
1340: if ( l_lock_status <> 0 ) THEN
1341: if (l_lock_status = 1) then -- timeout
1342: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');
1343: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
1344: raise fnd_api.g_exc_unexpected_error;
1345:
1346: elsif (l_lock_status = 2) then -- deadlock

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

1343: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
1344: raise fnd_api.g_exc_unexpected_error;
1345:
1346: elsif (l_lock_status = 2) then -- deadlock
1347: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
1348: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
1349: raise fnd_api.g_exc_unexpected_error;
1350:
1351: elsif (l_lock_status = 3) then -- parameter error

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

1348: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
1349: raise fnd_api.g_exc_unexpected_error;
1350:
1351: elsif (l_lock_status = 3) then -- parameter error
1352: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
1353: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
1354: raise fnd_api.g_exc_unexpected_error;
1355:
1356: elsif (l_lock_status = 4) then -- already locked.

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

1353: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
1354: raise fnd_api.g_exc_unexpected_error;
1355:
1356: elsif (l_lock_status = 4) then -- already locked.
1357: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');
1358: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');
1359: -- we shall not raise an error if we are already holding the lock.
1360:
1361: else -- internal error - not fault of user

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

1358: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');
1359: -- we shall not raise an error if we are already holding the lock.
1360:
1361: else -- internal error - not fault of user
1362: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');
1363: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');
1364: raise fnd_api.g_exc_unexpected_error;
1365: end if;
1366: else

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

1364: raise fnd_api.g_exc_unexpected_error;
1365: end if;
1366: else
1367: IF PG_DEBUG <> 0 THEN
1368: oe_debug_pub.add('match_and_create_all_items: ' || 'Successfully obtained lock for match.');
1369: END IF;
1370:
1371: end if;
1372: --

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

1394:
1395: end if ;
1396: -- bug 5859780 : need to handle error from match function.
1397: if lStatus <> 1 then
1398: oe_debug_pub.add('match_and_create_all_items: v_perform_match = '||v_perform_match);
1399: oe_debug_pub.add('match_and_create_all_items: '|| 'match returned error: '||l_x_error_msg);
1400: raise fnd_api.g_exc_error;
1401: end if;
1402: -- end bug 5859780

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

1395: end if ;
1396: -- bug 5859780 : need to handle error from match function.
1397: if lStatus <> 1 then
1398: oe_debug_pub.add('match_and_create_all_items: v_perform_match = '||v_perform_match);
1399: oe_debug_pub.add('match_and_create_all_items: '|| 'match returned error: '||l_x_error_msg);
1400: raise fnd_api.g_exc_error;
1401: end if;
1402: -- end bug 5859780
1403:

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

1415: x_Msg_Data => xMsgData,
1416: p_hash_value => l_hash_value);
1417:
1418: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then
1419: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1420: raise fnd_api.g_exc_unexpected_error;
1421: end if;
1422:
1423: --

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

1427: end if;
1428:
1429: if (lXConfigId is null) then
1430:
1431: oe_debug_pub.add ('Create_All_items: ' || 'no match found ' , 1);
1432:
1433: /* Sushant is Testig Important
1434: v_parent_ato_line_id := v_model_lines.parent_ato_line_id ;
1435: */

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

1456: into v_parent_ato_line_id , v_ato_line_id ;
1457:
1458: v_update_count := SQL%rowcount ;
1459:
1460: oe_debug_pub.add ('Create_All_items: ' || ' v_parent_ato ' || v_parent_ato_line_id
1461: || ' v_ato ' || v_ato_line_id
1462: || ' upd count ' || v_update_count , 1);
1463:
1464:

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

1477: set config_item_id = lXConfigId
1478: where line_id = v_model_lines.line_id
1479: returning config_creation into v_bcmo_config_orgs ;
1480:
1481: oe_debug_pub.add('Create_All_Items: ' ||
1482: 'update bcol count::'||
1483: SQL%ROWCOUNT , 1);
1484:
1485: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId

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

1481: oe_debug_pub.add('Create_All_Items: ' ||
1482: 'update bcol count::'||
1483: SQL%ROWCOUNT , 1);
1484:
1485: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId
1486: || ' for ' || v_model_lines.line_id
1487: || ' config_orgs ' || v_bcmo_config_orgs
1488: || ' rows ' || SQL%ROWCOUNT, 1);
1489:

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

1492: bom_cto_order_lines_gt
1493: set config_item_id = lXConfigId
1494: where line_id = v_model_lines.line_id ;
1495:
1496: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId
1497: || ' for ' || v_model_lines.line_id
1498: || ' rows ' || SQL%ROWCOUNT, 1);
1499:
1500:

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

1510: where group_reference_id = v_bcso_group_reference_id ;
1511:
1512:
1513:
1514: oe_debug_pub.add ('Create_All_items: matched item ' || 'updated bcmo ' || lXConfigId
1515: || ' line id info ' || v_model_lines.line_id
1516: || ' for ' || v_bcso_group_reference_id
1517: || ' rows ' || SQL%ROWCOUNT, 1);
1518:

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

1526: set config_item_id = lXConfigId
1527: where line_id = v_model_lines.line_id ;
1528:
1529:
1530: oe_debug_pub.add ('Create_All_items: ' || 'updated bcso_b ' || lXConfigId
1531: || ' for ' || v_model_lines.line_id
1532: || ' rows ' || SQL%ROWCOUNT, 1);
1533:
1534:

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

1551: or
1552: ( p_mode = 'PRECONFIG' )
1553: ) then
1554:
1555: oe_debug_pub.add('Create_All_Items: Handle Item Creation for Type 1 , 2 , Preconfig or no match/reuse ' , 1 ) ;
1556:
1557: lStatus := CTO_CONFIG_ITEM_PK.create_item(
1558: pModelId => v_model_lines.inventory_item_id,
1559: pLineId => v_model_lines.line_id,

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

1563: p_mode => p_mode );
1564:
1565: IF lStatus <> 1 THEN
1566: IF PG_DEBUG <> 0 THEN
1567: oe_debug_pub.add('Create_All_Items: ' ||
1568: 'Create_Item returned 0::item::'||
1569: to_char(v_model_lines.inventory_item_id), 1);
1570: END IF;
1571:

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

1578:
1579: l_eni_star_record.inventory_item_id := lxConfigId;
1580:
1581: IF PG_DEBUG <> 0 THEN
1582: oe_debug_pub.add('Create_All_Items: ' || 'conifg item id passed to ENI=>'||
1583: l_eni_star_record.inventory_item_id , 5);
1584: END IF;
1585:
1586: --follwoing API is maintained by PLM,DBI team present in Bom source control

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

1601: --CTO has decided not to fail for error messages but just log messages
1602: --refer bug 3124169 for more info
1603: IF eni_return_status = 'S' THEN
1604: IF PG_DEBUG <> 0 THEN
1605: oe_debug_pub.add('Cto_Eni_Wrapper_Api:' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
1606: ||eni_return_status, 5);
1607: END IF;
1608: ELSE
1609: IF PG_DEBUG <> 0 THEN

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

1606: ||eni_return_status, 5);
1607: END IF;
1608: ELSE
1609: IF PG_DEBUG <> 0 THEN
1610: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
1611: ||eni_return_status, 1);
1612: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'IGNORING ABOVE ERROR', 1);
1613: END IF;
1614:

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

1608: ELSE
1609: IF PG_DEBUG <> 0 THEN
1610: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
1611: ||eni_return_status, 1);
1612: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'IGNORING ABOVE ERROR', 1);
1613: END IF;
1614:
1615: END IF;
1616:

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

1622: END IF;
1623:
1624:
1625: IF PG_DEBUG <> 0 THEN
1626: oe_debug_pub.add('Create_All_Items: ' ||
1627: 'Create_Item returned with lStatus::'||to_char(lStatus), 2);
1628:
1629: oe_debug_pub.add('Create_All_Items: ' || 'ITEM CREATED IS ::'||
1630: to_char(lxConfigId), 1);

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

1625: IF PG_DEBUG <> 0 THEN
1626: oe_debug_pub.add('Create_All_Items: ' ||
1627: 'Create_Item returned with lStatus::'||to_char(lStatus), 2);
1628:
1629: oe_debug_pub.add('Create_All_Items: ' || 'ITEM CREATED IS ::'||
1630: to_char(lxConfigId), 1);
1631:
1632:
1633:

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

1630: to_char(lxConfigId), 1);
1631:
1632:
1633:
1634: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);
1635: END IF;
1636:
1637:
1638: /* update newly created config in bcol and bcol_temp */

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

1642: where line_id = v_model_lines.line_id
1643: returning perform_match into v_perform_match;
1644:
1645:
1646: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId
1647: || ' for ' || v_model_lines.line_id , 1);
1648:
1649:
1650: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);

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

1646: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId
1647: || ' for ' || v_model_lines.line_id , 1);
1648:
1649:
1650: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);
1651:
1652: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1653: bom_cto_order_lines_gt
1654: set config_item_id = lXConfigId

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

1654: set config_item_id = lXConfigId
1655: where line_id = v_model_lines.line_id ;
1656:
1657:
1658: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId
1659: || ' for ' || v_model_lines.line_id , 1);
1660:
1661:
1662: update bom_cto_src_orgs_b

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

1664: where line_id = v_model_lines.line_id ;
1665:
1666:
1667:
1668: oe_debug_pub.add ('Create_All_items: ' || 'updated bcso ' || lXConfigId
1669: || ' for ' || v_model_lines.line_id
1670: || ' config_creation ' || v_model_lines.config_creation
1671: || ' rows ' || SQL%ROWCOUNT, 1);
1672:

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

1684: where group_reference_id = v_bcso_group_reference_id ;
1685:
1686:
1687:
1688: oe_debug_pub.add ('Create_All_items: ' || 'updated bcmo ' || lXConfigId
1689: || ' for ' || v_bcso_group_reference_id
1690: || ' rows ' || SQL%ROWCOUNT, 1);
1691:
1692:

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

1701:
1702:
1703: IF( v_perform_match = 'U') then
1704:
1705: oe_debug_pub.add ('Create_All_items: ' || 'canning configuration' || v_model_lines.line_id, 1);
1706:
1707: /* CAN configuration for items created when match profile = 'Yes' */
1708:
1709: lStatus := CTO_MATCH_CONFIG.can_configurations(

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

1764: end ;
1765:
1766:
1767: IF PG_DEBUG <> 0 THEN
1768: oe_debug_pub.add ('Create_All_Items: ' ||
1769: 'v_model_item_status ' || to_char(v_model_item_status) ||
1770: 'v_config_item_status ' || to_char(v_config_item_status) , 1);
1771: END IF;
1772:

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

1774: if( v_model_item_status = 1 or v_config_item_status = 1 ) then
1775:
1776:
1777: IF PG_DEBUG <> 0 THEN
1778: oe_debug_pub.add ('Create_All_Items: ' || 'Error: Item Not Enabled in some orgs', 1);
1779: END IF;
1780:
1781: select concatenated_segments into v_model_item_name
1782: from mtl_system_items_kfv

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

1806:
1807: else
1808:
1809: IF PG_DEBUG <> 0 THEN
1810: oe_debug_pub.add ('Create_All_Items: ' || 'Item Enabled in all orgs', 1);
1811: END IF;
1812:
1813:
1814: end if;

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

1813:
1814: end if;
1815:
1816:
1817: oe_debug_pub.add('Create_All_Items: No need to Handle Item Creation for Type 3 matched AutoConfig ' , 1 ) ;
1818:
1819:
1820:
1821:

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

1827: set config_item_id = lXConfigId
1828: where line_id = v_model_lines.line_id ;
1829:
1830:
1831: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId
1832: || ' for ' || v_model_lines.line_id , 1);
1833:
1834:
1835:

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

1838: set config_item_id = lXConfigId
1839: where line_id = v_model_lines.line_id ;
1840:
1841:
1842: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId
1843: || ' for ' || v_model_lines.line_id , 1);
1844:
1845:
1846: select group_reference_id into v_bcso_group_reference_id from bom_cto_src_orgs_b

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

1853: where group_reference_id = v_bcso_group_reference_id ;
1854:
1855:
1856:
1857: oe_debug_pub.add ('Create_All_items: ' || 'updated bcmo ' || lXConfigId
1858: || ' for ' || v_bcso_group_reference_id
1859: || ' rows ' || SQL%ROWCOUNT, 1);
1860:
1861:

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

1865: where line_id = v_model_lines.line_id ;
1866:
1867:
1868:
1869: oe_debug_pub.add ('Create_All_items: ' || 'updated bcso ' || lXConfigId
1870: || ' for ' || v_model_lines.line_id
1871: || ' rows ' || SQL%ROWCOUNT, 1);
1872:
1873:

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

1873:
1874:
1875: elsif ( lXConfigId is not null and nvl(v_model_lines.config_creation, 1) = 3 and v_perform_match = 'N' ) then
1876:
1877: oe_debug_pub.add('Create_All_Items: Handle Item Creation for Type 3 reuse ' , 1 ) ;
1878:
1879: lStatus := CTO_CONFIG_ITEM_PK.create_item(
1880: pModelId => v_model_lines.inventory_item_id,
1881: pLineId => v_model_lines.line_id,

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

1885: p_mode => p_mode );
1886:
1887: IF lStatus <> 1 THEN
1888: IF PG_DEBUG <> 0 THEN
1889: oe_debug_pub.add('Create_All_Items: ' ||
1890: 'Create_Item returned 0::item::'||
1891: to_char(v_model_lines.inventory_item_id), 1);
1892: END IF;
1893:

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

1900:
1901: l_eni_star_record.inventory_item_id := lxConfigId;
1902:
1903: IF PG_DEBUG <> 0 THEN
1904: oe_debug_pub.add('Create_All_Items: ' || 'conifg item id passed to ENI=>'||
1905: l_eni_star_record.inventory_item_id , 5);
1906: END IF;
1907:
1908: --follwoing API is maintained by PLM,DBI team present in Bom source control

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

1923: --CTO has decided not to fail for error messages but just log messages
1924: --refer bug 3124169 for more info
1925: IF eni_return_status = 'S' THEN
1926: IF PG_DEBUG <> 0 THEN
1927: oe_debug_pub.add('Cto_Eni_Wrapper_Api:' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
1928: ||eni_return_status, 5);
1929: END IF;
1930: ELSE
1931: IF PG_DEBUG <> 0 THEN

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

1928: ||eni_return_status, 5);
1929: END IF;
1930: ELSE
1931: IF PG_DEBUG <> 0 THEN
1932: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
1933: ||eni_return_status, 1);
1934: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'IGNORING ABOVE ERROR', 1);
1935: END IF;
1936:

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

1930: ELSE
1931: IF PG_DEBUG <> 0 THEN
1932: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
1933: ||eni_return_status, 1);
1934: oe_debug_pub.add('Cto_Eni_Wrapper_Api: ' || 'IGNORING ABOVE ERROR', 1);
1935: END IF;
1936:
1937: END IF;
1938:

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

1944: END IF;
1945:
1946:
1947: IF PG_DEBUG <> 0 THEN
1948: oe_debug_pub.add('Create_All_Items: ' ||
1949: 'Create_Item returned with lStatus::'||to_char(lStatus), 2);
1950:
1951: oe_debug_pub.add('Create_All_Items: ' || 'ITEM CREATED IS ::'||
1952: to_char(lxConfigId), 1);

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

1947: IF PG_DEBUG <> 0 THEN
1948: oe_debug_pub.add('Create_All_Items: ' ||
1949: 'Create_Item returned with lStatus::'||to_char(lStatus), 2);
1950:
1951: oe_debug_pub.add('Create_All_Items: ' || 'ITEM CREATED IS ::'||
1952: to_char(lxConfigId), 1);
1953: END IF;
1954:
1955:

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

1959: set config_item_id = lXConfigId
1960: where line_id = v_model_lines.line_id ;
1961:
1962:
1963: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol ' || lXConfigId
1964: || ' for ' || v_model_lines.line_id , 1);
1965:
1966:
1967:

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

1970: where line_id = v_model_lines.line_id ;
1971:
1972:
1973:
1974: oe_debug_pub.add ('Create_All_items: ' || 'updated bcso ' || lXConfigId
1975: || ' for ' || v_model_lines.line_id
1976: || ' config_creation ' || v_model_lines.config_creation
1977: || ' rows ' || SQL%ROWCOUNT, 1);
1978:

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

1988:
1989: EXCEPTION
1990: when NO_DATA_FOUND then
1991: IF PG_DEBUG <> 0 THEN
1992: oe_debug_pub.add('Create_All_Items: ' || 'create_all_items::ndf::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1993: END IF;
1994: xReturnStatus := fnd_api.g_ret_sts_error;
1995: cto_msg_pub.count_and_get
1996: ( p_msg_count => xMsgCount

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

1999: return(0);
2000:
2001: when FND_API.G_EXC_ERROR then
2002: IF PG_DEBUG <> 0 THEN
2003: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::exp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2004: END IF;
2005: xReturnStatus := fnd_api.g_ret_sts_error;
2006: cto_msg_pub.count_and_get
2007: ( p_msg_count => xMsgCount

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

2010: return(0);
2011:
2012: when FND_API.G_EXC_UNEXPECTED_ERROR then
2013: IF PG_DEBUG <> 0 THEN
2014: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2015: END IF;
2016: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2017: cto_msg_pub.count_and_get
2018: ( p_msg_count => xMsgCount

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

2021: return(0);
2022:
2023: when OTHERS then
2024: IF PG_DEBUG <> 0 THEN
2025: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::others::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2026: END IF;
2027: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2028: cto_msg_pub.count_and_get
2029: ( p_msg_count => xMsgCount

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

2104: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt
2105: where ato_line_id = p_ato_line_id ;
2106:
2107:
2108: oe_debug_pub.add( ' perform_match bcol count ' || v_bcol_count , 1 ) ;
2109: oe_debug_pub.add( ' perform_match bcol_gt count ' || v_bcol_gt_count , 1 ) ;
2110:
2111: l_stmt_num := 1;
2112:

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

2105: where ato_line_id = p_ato_line_id ;
2106:
2107:
2108: oe_debug_pub.add( ' perform_match bcol count ' || v_bcol_count , 1 ) ;
2109: oe_debug_pub.add( ' perform_match bcol_gt count ' || v_bcol_gt_count , 1 ) ;
2110:
2111: l_stmt_num := 1;
2112:
2113: x_match_found := 'N' ;

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

2128: from bom_cto_order_lines
2129: where line_id = l_next_rec.line_id ;
2130:
2131:
2132: oe_debug_pub.add( ' perform_match: line_id ' || l_next_rec.line_id || ' match ' || l_perform_match , 1 ) ;
2133:
2134:
2135: if( l_perform_match = 'U' ) then
2136:

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

2155: elsif( l_perform_match in( 'Y' , 'C' ) ) then
2156:
2157: if ( l_perform_match = 'Y' ) then
2158: l_stmt_num := 10;
2159: oe_debug_pub.add('Standard Match.', 1);
2160: l_status := cto_match_config.check_config_match(
2161: l_next_rec.line_id,
2162: l_x_config_id,
2163: l_x_error_msg,

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

2162: l_x_config_id,
2163: l_x_error_msg,
2164: l_x_error_msg_name);
2165:
2166: oe_debug_pub.add(' done Check Config Match ' , 1 ) ;
2167:
2168:
2169: elsif ( l_perform_match = 'C' ) then
2170: l_stmt_num := 15;

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

2178:
2179: l_stmt_num := 20;
2180:
2181: if (l_status = 0) then
2182: oe_debug_pub.add('Failed in Check Config Match for line id '
2183: || to_char(l_next_rec.line_id), 1);
2184:
2185: raise PROCESS_ERROR;
2186:

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

2249:
2250: l_stmt_num := 35;
2251:
2252:
2253: oe_debug_pub.add('Match for line id '
2254: || to_char(l_next_rec.line_id)
2255: || ' is ' || to_char(l_x_config_id) ,1);
2256:
2257:

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

2260: where line_id = l_next_rec.line_id;
2261:
2262:
2263:
2264: oe_debug_pub.add( 'perform_match: bcol update ' || SQL%rowcount , 1 ) ;
2265:
2266: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2267: bom_cto_order_lines_gt
2268: set config_item_id = l_x_config_id

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

2268: set config_item_id = l_x_config_id
2269: where line_id = l_next_rec.line_id;
2270:
2271:
2272: oe_debug_pub.add( 'perform_match: bcol_gt update ' || SQL%rowcount , 1 ) ;
2273:
2274: l_stmt_num := 40 ;
2275:
2276: x_matching_config_id := l_x_config_id ;

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

2287: end if;
2288:
2289: else
2290:
2291: oe_debug_pub.add(' Match OFF for line id '
2292: || to_char(l_next_rec.line_id) ,1);
2293:
2294:
2295: x_match_found := 'N' ;

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

2303:
2304: exception
2305: when others then
2306: V_SQLCODE := SQLCODE ;
2307: oe_debug_pub.add ( ' exception in match at step ' || to_char( l_stmt_num ) ) ;
2308: -- insert into my_debug_messages values ( ' exception in match at step ' || to_char( l_stmt_num ) ) ;
2309: -- insert into my_debug_messages values ( ' exception in match SQL ' || to_char( V_SQLCODE ) ) ;
2310:
2311: end perform_match ;

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

2347: i number ;
2348:
2349: begin
2350:
2351: oe_debug_pub.add ( ' entered evaluate item behavior ' , 1 ) ;
2352:
2353:
2354:
2355: open c_item_behavior ;

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

2382:
2383:
2384: if( t_bcol(i).config_creation in ( 1, 2 ) and t_bcol(t_bcol(i).parent_ato_line_id).config_creation = 3 ) then
2385:
2386: oe_debug_pub.add( 'evaluate_item_behavior:' || ' item behavior violated for line id ' || t_bcol(i).line_id
2387: || ' behavior ' || t_bcol(i).config_creation
2388: || ' parent ato line ' || t_bcol(i).parent_ato_line_id
2389: || ' parent behavior ' || t_bcol(t_bcol(i).parent_ato_line_id).config_creation , 1 ) ;
2390:

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

2401:
2402: exception
2403: when item_behavior_violated then
2404:
2405: oe_debug_pub.add( 'evaluate_item_behavior:' || ' item behavior violated ' , 1 ) ;
2406:
2407:
2408: end evaluate_item_behavior;
2409: