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_BOM_RTG_PK dependencies on OE_DEBUG_PUB

Line 14: * Comment out all FND_FILE calls since we are using oe_debug_pub.

10: * the procedure needs to error out
11: *
12: * History : 06/18/01 sbhaskar
13: * bugfix 1835357
14: * Comment out all FND_FILE calls since we are using oe_debug_pub.
15: *
16: *
17: *
18: *

Line 189: oe_debug_pub.add(' CTOBMRTB bcol count ' || v_bcol_count || ' for ' || pAtoLineid , 1);

185:
186: select count(*) into v_bcol_count from bom_cto_order_lines
187: where ato_line_id = pAtoLineId ;
188:
189: oe_debug_pub.add(' CTOBMRTB bcol count ' || v_bcol_count || ' for ' || pAtoLineid , 1);
190:
191:
192: for lNextRec in cAllConfigItems loop
193:

Line 195: oe_debug_pub.add('create_all_boms_and_routings: ' || 'Calling create_in_src_orgs with item ' ||

191:
192: for lNextRec in cAllConfigItems loop
193:
194: IF PG_DEBUG <> 0 THEN
195: oe_debug_pub.add('create_all_boms_and_routings: ' || 'Calling create_in_src_orgs with item ' ||
196: to_char(lNextRec.config_item_id) ||
197: ' and line ' || to_char(lNextRec.line_id), 1);
198: END IF;
199:

Line 210: oe_debug_pub.add('create_all_boms_and_routings: ' || 'Returned from create_in_src_orgs with result '

206: xMsgCount,
207: xMsgData);
208:
209: IF PG_DEBUG <> 0 THEN
210: oe_debug_pub.add('create_all_boms_and_routings: ' || 'Returned from create_in_src_orgs with result '
211: || xReturnStatus, 1);
212: END IF;
213:
214: /* BUG #1957336 Change for preconfigure bom by Sushant Sawant */

Line 232: oe_debug_pub.add('Value of gMatch .. '||CTO_MATCH_CONFIG.gMatch,1);

228:
229: CTO_MATCH_CONFIG.gMatch := 0;
230:
231: IF PG_DEBUG <> 0 THEN
232: oe_debug_pub.add('Value of gMatch .. '||CTO_MATCH_CONFIG.gMatch,1);
233: END IF;
234:
235:
236: --- Added by Renga Kannan on 01/20/04 . Calling the new procedure to Create item attachments

Line 238: oe_debug_pub.add('Create_all_boms_and_routings: Calling Create_item_attachments API',1);

234:
235:
236: --- Added by Renga Kannan on 01/20/04 . Calling the new procedure to Create item attachments
237:
238: oe_debug_pub.add('Create_all_boms_and_routings: Calling Create_item_attachments API',1);
239:
240: CTO_UTILITY_PK.create_item_attachments(
241: p_ato_line_id => pAtoLineId,
242: x_return_status => xReturnStatus,

Line 245: oe_debug_pub.add('Create_all_boms_and_routings: After Create_item_attachments API',1);

241: p_ato_line_id => pAtoLineId,
242: x_return_status => xReturnStatus,
243: x_msg_count => xMsgCount,
244: x_msg_data => xMsgData);
245: oe_debug_pub.add('Create_all_boms_and_routings: After Create_item_attachments API',1);
246:
247:
248:
249: -- Get message count and data

Line 269: oe_debug_pub.add('create_all_boms_and_routings: ' || xMsgData , 1);

265: );
266: end if ;
267:
268: IF PG_DEBUG <> 0 THEN
269: oe_debug_pub.add('create_all_boms_and_routings: ' || xMsgData , 1);
270: END IF;
271:
272: WHEN fnd_api.g_exc_unexpected_error THEN
273: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;

Line 282: oe_debug_pub.add('create_all_boms_and_routings: ' || 'create_all_boms_and_routings::others::'||'::'||sqlerrm, 1);

278: );
279:
280: WHEN OTHERS then
281: IF PG_DEBUG <> 0 THEN
282: oe_debug_pub.add('create_all_boms_and_routings: ' || 'create_all_boms_and_routings::others::'||'::'||sqlerrm, 1);
283: END IF;
284: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
285: -- Get message count and data
286: cto_msg_pub.count_and_get

Line 323: oe_debug_pub.add('get_ato_line_id: ' || 'Queried ato_line_id from bcol for given line_id. exiting...', 5);

319: from bom_cto_order_lines
320: where line_id = p_line_id ;
321:
322: IF PG_DEBUG <> 0 THEN
323: oe_debug_pub.add('get_ato_line_id: ' || 'Queried ato_line_id from bcol for given line_id. exiting...', 5);
324: END IF;
325:
326: Exception
327:

Line 330: oe_debug_pub.add('get_ato_line_id: ' || 'expected error: ' || sqlerrm, 1);

326: Exception
327:
328: when FND_API.G_EXC_ERROR THEN
329: IF PG_DEBUG <> 0 THEN
330: oe_debug_pub.add('get_ato_line_id: ' || 'expected error: ' || sqlerrm, 1);
331: END IF;
332: x_return_status := FND_API.G_RET_STS_ERROR;
333:
334: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 336: oe_debug_pub.add('get_ato_line_id: ' || 'unexpected error: ' || sqlerrm, 1);

332: x_return_status := FND_API.G_RET_STS_ERROR;
333:
334: when FND_API.G_EXC_UNEXPECTED_ERROR then
335: IF PG_DEBUG <> 0 THEN
336: oe_debug_pub.add('get_ato_line_id: ' || 'unexpected error: ' || sqlerrm, 1);
337: END IF;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339:
340: when others then

Line 342: oe_debug_pub.add('get_ato_line_id: ' || 'When others exception ..' || sqlerrm, 1);

338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339:
340: when others then
341: IF PG_DEBUG <> 0 THEN
342: oe_debug_pub.add('get_ato_line_id: ' || 'When others exception ..' || sqlerrm, 1);
343: END IF;
344: x_return_status := fnd_api.g_ret_sts_unexp_error;
345:
346: End get_ato_line_id;

Line 498: oe_debug_pub.add(' entered create_in_src_orgs: model ' || pModelId

494:
495: xReturnStatus := fnd_api.g_ret_sts_success;
496:
497: IF PG_DEBUG <> 0 THEN
498: oe_debug_pub.add(' entered create_in_src_orgs: model ' || pModelId
499: || ' Line ' || pLineId , 1);
500: END IF;
501:
502: -- rkaza. bug 4315973.

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

517:
518: select count(*) into v_bcol_count from bom_cto_order_lines
519: where ato_line_id = pLineId ;
520:
521: oe_debug_pub.add(' bcol count ' || v_bcol_count , 1);
522:
523: select count(*) into v_bcol_count from bom_cto_order_lines
524: where ato_line_id = pLineId and option_specific = 'N' ;
525:

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

522:
523: select count(*) into v_bcol_count from bom_cto_order_lines
524: where ato_line_id = pLineId and option_specific = 'N' ;
525:
526: oe_debug_pub.add(' bcol count ' || v_bcol_count , 1);
527:
528: lStmtNum := 10 ;
529:
530:

Line 533: oe_debug_pub.add(' entered cSrcOrgs loop **********************' , 1);

529:
530:
531: for lNextRec in cSrcOrgs loop
532:
533: oe_debug_pub.add(' ****** entered cSrcOrgs loop ****************************' , 1);
534:
535: lStmtNum := 20 ;
536:
537:

Line 587: oe_debug_pub.add(' entered cSRcOrgs model ' || lNextRec.model_item_id

583:
584: /* end bug 3877317 */
585:
586:
587: oe_debug_pub.add(' entered cSRcOrgs model ' || lNextRec.model_item_id
588: || ' config ' || lNextRec.config_item_id
589: || ' org ' || lNextRec.organization_id , 1);
590:
591: oe_debug_pub.add(' entered cSRcOrgs model bom ' || v_create_bom || ' cost ' || v_perform_cost_rollup || ' option ' || lNextRec.option_specific , 1 ) ;

Line 591: oe_debug_pub.add(' entered cSRcOrgs model bom ' || v_create_bom || ' cost ' || v_perform_cost_rollup || ' option ' || lNextRec.option_specific , 1 ) ;

587: oe_debug_pub.add(' entered cSRcOrgs model ' || lNextRec.model_item_id
588: || ' config ' || lNextRec.config_item_id
589: || ' org ' || lNextRec.organization_id , 1);
590:
591: oe_debug_pub.add(' entered cSRcOrgs model bom ' || v_create_bom || ' cost ' || v_perform_cost_rollup || ' option ' || lNextRec.option_specific , 1 ) ;
592:
593:
594: if( v_perform_cost_rollup = 'Y' ) then -- bug 3877317 replaced variable
595: oe_debug_pub.add(' create_in_src_orgs: ' || ' Going to call override_bcso_cost_rollup ' , 1 ) ;

Line 595: oe_debug_pub.add(' create_in_src_orgs: ' || ' Going to call override_bcso_cost_rollup ' , 1 ) ;

591: oe_debug_pub.add(' entered cSRcOrgs model bom ' || v_create_bom || ' cost ' || v_perform_cost_rollup || ' option ' || lNextRec.option_specific , 1 ) ;
592:
593:
594: if( v_perform_cost_rollup = 'Y' ) then -- bug 3877317 replaced variable
595: oe_debug_pub.add(' create_in_src_orgs: ' || ' Going to call override_bcso_cost_rollup ' , 1 ) ;
596:
597: override_bcso_cost_rollup(
598: pLineId, -- Current Model Line ID
599: pModelId,

Line 608: oe_debug_pub.add(' create_in_src_orgs: ' || ' Done override_bcso_cost_rollup ' , 1 ) ;

604: xReturnStatus,
605: xMsgCount,
606: xMsgData );
607:
608: oe_debug_pub.add(' create_in_src_orgs: ' || ' Done override_bcso_cost_rollup ' , 1 ) ;
609:
610: end if;
611:
612:

Line 620: oe_debug_pub.add('create_in_src_orgs: ' || ' Going to check bom for . Item: ' ||

616: -- check if model bom exists in src org
617:
618: lStmtNum := 40;
619: IF PG_DEBUG <> 0 THEN
620: oe_debug_pub.add('create_in_src_orgs: ' || ' Going to check bom for . Item: ' ||
621: to_char(pConfigId) || '. Org ' ||
622: to_char(lNextRec.organization_id), 1);
623: END IF;
624:

Line 634: oe_debug_pub.add('create_in_src_orgs: '

630: pOrgId => lNextRec.organization_id,
631: xBillId => lItmBillId);
632:
633: IF PG_DEBUG <> 0 THEN
634: oe_debug_pub.add('create_in_src_orgs: '
635: || 'Returned from check_bom for model with result '
636: || to_char(lStatus), 1);
637: END IF;
638:

Line 652: oe_debug_pub.add('create_in_src_orgs: '

648: pOrgId => lNextRec.organization_id,
649: xBillId => lItmBillId);
650:
651: IF PG_DEBUG <> 0 THEN
652: oe_debug_pub.add('create_in_src_orgs: '
653: || 'Returned from check_bom for config with result '
654: || to_char(lStatus), 1);
655: END IF;
656:

Line 661: oe_debug_pub.add('create_in_src_orgs: ' || 'Config BOM ' || lItmBillId || '

657: if (lStatus = 1) then
658: v_config_bom_exists := v_config_bom_exists + 1 ;
659:
660: IF PG_DEBUG <> 0 THEN
661: oe_debug_pub.add('create_in_src_orgs: ' || 'Config BOM ' || lItmBillId || '
662: already exists ' ,1);
663: END IF;
664:
665: /*2986192*/

Line 668: oe_debug_pub.add('Checking for dropped items ... ' ,1);

664:
665: /*2986192*/
666:
667: IF PG_DEBUG <> 0 THEN
668: oe_debug_pub.add('Checking for dropped items ... ' ,1);
669: oe_debug_pub.add('Config id '||pConfigId||' Org '||lNextRec.organization_id, 1);
670: END IF;
671:
672: -- 3543547

Line 669: oe_debug_pub.add('Config id '||pConfigId||' Org '||lNextRec.organization_id, 1);

665: /*2986192*/
666:
667: IF PG_DEBUG <> 0 THEN
668: oe_debug_pub.add('Checking for dropped items ... ' ,1);
669: oe_debug_pub.add('Config id '||pConfigId||' Org '||lNextRec.organization_id, 1);
670: END IF;
671:
672: -- 3543547
673:

Line 680: oe_debug_pub.add('create_in_src_orgs: ' || 'Common Bill Id '

676: from bom_bill_of_materials
677: where bill_sequence_id = lItmBillId;
678:
679: IF PG_DEBUG <> 0 THEN
680: oe_debug_pub.add('create_in_src_orgs: ' || 'Common Bill Id '
681: ||lComItmBillId,1);
682: END IF;
683:
684: -- 3543547

Line 691: oe_debug_pub.add('Inserting into BICI ... ' ,1);

687:
688: begin
689:
690: IF PG_DEBUG <> 0 THEN
691: oe_debug_pub.add('Inserting into BICI ... ' ,1);
692: END IF;
693:
694: -- rkaza. bug 4524248. 11/09/2005.
695: -- bom structure import enhancements. Added batch_id.

Line 705: oe_debug_pub.add('Value of gMatch '||CTO_MATCH_CONFIG.gMatch ,1);

701: from bom_inventory_components
702: where bill_sequence_id = lComItmBillId; -- 3543547 lItmBillId;
703:
704: IF PG_DEBUG <> 0 THEN
705: oe_debug_pub.add('Value of gMatch '||CTO_MATCH_CONFIG.gMatch ,1);
706: oe_debug_pub.add('inserting into bici'|| SQL%ROWCOUNT || ' for bill ' || lItmBillId ,1);
707: END IF;
708:
709:

Line 706: oe_debug_pub.add('inserting into bici'|| SQL%ROWCOUNT || ' for bill ' || lItmBillId ,1);

702: where bill_sequence_id = lComItmBillId; -- 3543547 lItmBillId;
703:
704: IF PG_DEBUG <> 0 THEN
705: oe_debug_pub.add('Value of gMatch '||CTO_MATCH_CONFIG.gMatch ,1);
706: oe_debug_pub.add('inserting into bici'|| SQL%ROWCOUNT || ' for bill ' || lItmBillId ,1);
707: END IF;
708:
709:
710:

Line 726: oe_debug_pub.add('Inserting child base model into BICI for matched cases... ' ,1);

722:
723: lStmtNum := 121;
724:
725: IF PG_DEBUG <> 0 THEN
726: oe_debug_pub.add('Inserting child base model into BICI for matched cases... ' ,1);
727: END IF;
728:
729: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,
730: effectivity_date,disable_date)

Line 742: oe_debug_pub.add('Failed to insert into bom_inventory_comps_interface with error '||sqlerrm);

738:
739: exception
740: when others then
741: IF PG_DEBUG <> 0 THEN
742: oe_debug_pub.add('Failed to insert into bom_inventory_comps_interface with error '||sqlerrm);
743: END IF;
744: raise fnd_api.g_exc_error;
745: end ;
746:

Line 752: oe_debug_pub.add ('Line_id '||pLineId,1);

748:
749: begin
750:
751: IF PG_DEBUG <> 0 THEN
752: oe_debug_pub.add ('Line_id '||pLineId,1);
753: END IF;
754:
755: lcreate_item := nvl(FND_PROFILE.VALUE('CTO_CONFIG_EXCEPTION'), 1);
756:

Line 758: oe_debug_pub.add ('Config exception profile '||lcreate_item);

754:
755: lcreate_item := nvl(FND_PROFILE.VALUE('CTO_CONFIG_EXCEPTION'), 1);
756:
757: IF PG_DEBUG <> 0 THEN
758: oe_debug_pub.add ('Config exception profile '||lcreate_item);
759: END IF;
760:
761: /* Added by Renga Kannan
762: Effectivity date bug fix : 4147224

Line 790: oe_debug_pub.add('create_in_src_orgs: ' || 'Failed in get_model_lead_time. ', 1);

786: and msi.organization_id = oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id);
787: end if;
788: Exception when others then
789: IF PG_DEBUG <> 0 THEN
790: oe_debug_pub.add('create_in_src_orgs: ' || 'Failed in get_model_lead_time. ', 1);
791: END IF;
792: raise FND_API.G_EXC_ERROR;
793: End;
794:

Line 796: oe_debug_pub.add('Create_in_src_orgs: '||' Config item lead time = '||to_char(lLeadTime),1);

792: raise FND_API.G_EXC_ERROR;
793: End;
794:
795: If PG_DEBUG <> 0 Then
796: oe_debug_pub.add('Create_in_src_orgs: '||' Config item lead time = '||to_char(lLeadTime),1);
797: oe_debug_pub.add('Create_in_src_orgs: Going to Calculate Estimated release date for the matched config item',1);
798: End if;
799: lStmtNum := 114;
800: begin

Line 797: oe_debug_pub.add('Create_in_src_orgs: Going to Calculate Estimated release date for the matched config item',1);

793: End;
794:
795: If PG_DEBUG <> 0 Then
796: oe_debug_pub.add('Create_in_src_orgs: '||' Config item lead time = '||to_char(lLeadTime),1);
797: oe_debug_pub.add('Create_in_src_orgs: Going to Calculate Estimated release date for the matched config item',1);
798: End if;
799: lStmtNum := 114;
800: begin
801: select CAL.CALENDAR_DATE

Line 823: oe_debug_pub.add('Create_in_src_orgs: ' || 'Unexpected error while computing estimated relase date',1);

819: and cal2.calendar_date = trunc(bcol.schedule_ship_date));
820: exception
821: when no_data_found then
822: IF PG_DEBUG <> 0 THEN
823: oe_debug_pub.add('Create_in_src_orgs: ' || 'Unexpected error while computing estimated relase date',1);
824: END IF;
825: raise fnd_api.g_exc_unexpected_error;
826: end;
827:

Line 829: oe_debug_pub.add('Create_in_src_orgs: '||' Estimated Release Date = '||to_char(lEstRelDate,'mm/dd/yy:hh:mi:ss'),1);

825: raise fnd_api.g_exc_unexpected_error;
826: end;
827:
828: If PG_DEBUG <> 0 Then
829: oe_debug_pub.add('Create_in_src_orgs: '||' Estimated Release Date = '||to_char(lEstRelDate,'mm/dd/yy:hh:mi:ss'),1);
830: End if;
831: /* End of bug fix 4147224 */
832:
833: Open mismatched_items(pLineId, lComItmBillId,lEstRelDate); -- 3543547 Replace lItmBillId with LComItmBillId

Line 840: oe_debug_pub.add ('Missed item id '||l_missed_item_id,1);

836:
837: fetch mismatched_items into l_missed_item_id;
838:
839: IF PG_DEBUG <> 0 THEN
840: oe_debug_pub.add ('Missed item id '||l_missed_item_id,1);
841: END IF;
842:
843: exit when mismatched_items%NOTFOUND;
844:

Line 852: oe_debug_pub.add('Select missed component details.. ' ,1);

848:
849: begin
850:
851: IF PG_DEBUG <> 0 THEN
852: oe_debug_pub.add('Select missed component details.. ' ,1);
853: END IF;
854:
855: -- Bug Fix 5199775
856: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then

Line 858: oe_debug_pub.add('Pre configured Item .. ' ,1);

854:
855: -- Bug Fix 5199775
856: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
857: IF PG_DEBUG <> 0 THEN
858: oe_debug_pub.add('Pre configured Item .. ' ,1);
859: END IF;
860: IF PG_DEBUG <> 0 THEN
861: oe_debug_pub.add('Pre configured Item .. ' ,1);
862: END IF;

Line 861: oe_debug_pub.add('Pre configured Item .. ' ,1);

857: IF PG_DEBUG <> 0 THEN
858: oe_debug_pub.add('Pre configured Item .. ' ,1);
859: END IF;
860: IF PG_DEBUG <> 0 THEN
861: oe_debug_pub.add('Pre configured Item .. ' ,1);
862: END IF;
863:
864: select substrb(msi.concatenated_segments,1,50),
865: 'Not Available' ,

Line 881: oe_debug_pub.add('Auto configured Item .. ' ,1);

877:
878: else
879:
880: IF PG_DEBUG <> 0 THEN
881: oe_debug_pub.add('Auto configured Item .. ' ,1);
882: END IF;
883:
884: select substrb(concatenated_segments,1,50),
885: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||

Line 925: oe_debug_pub.add('Select model.. ' ,1);

921:
922:
923: lStmtNum := 114;
924: IF PG_DEBUG <> 0 THEN
925: oe_debug_pub.add('Select model.. ' ,1);
926: END IF;
927:
928: select substrb(concatenated_segments,1,50)
929: into l_model

Line 937: oe_debug_pub.add('Select Org.. ' ,1);

933:
934:
935: lStmtNum := 117;
936: IF PG_DEBUG <> 0 THEN
937: oe_debug_pub.add('Select Org.. ' ,1);
938: END IF;
939:
940: select organization_code
941: into lOrg_code

Line 961: oe_debug_pub.add ('Warning: The component '||v_missed_item

957: -- Bug Fix 519975
958:
959: if ( lcreate_item = 1 ) then
960: IF PG_DEBUG <> 0 THEN
961: oe_debug_pub.add ('Warning: The component '||v_missed_item
962: || ' on Line Number '||v_missed_line_number
963: || ' in organization ' || lOrg_code
964: || ' was not included in the configured item''s bill. ',1);
965: oe_debug_pub.add ('Model Name : '||l_model,1);

Line 965: oe_debug_pub.add ('Model Name : '||l_model,1);

961: oe_debug_pub.add ('Warning: The component '||v_missed_item
962: || ' on Line Number '||v_missed_line_number
963: || ' in organization ' || lOrg_code
964: || ' was not included in the configured item''s bill. ',1);
965: oe_debug_pub.add ('Model Name : '||l_model,1);
966: oe_debug_pub.add ('Order Number : '||v_order_number,1);
967: END IF;
968: -- Bug fix 5199775. Commented the following error message
969: -- as we will be raising one message for all components

Line 966: oe_debug_pub.add ('Order Number : '||v_order_number,1);

962: || ' on Line Number '||v_missed_line_number
963: || ' in organization ' || lOrg_code
964: || ' was not included in the configured item''s bill. ',1);
965: oe_debug_pub.add ('Model Name : '||l_model,1);
966: oe_debug_pub.add ('Order Number : '||v_order_number,1);
967: END IF;
968: -- Bug fix 5199775. Commented the following error message
969: -- as we will be raising one message for all components
970: /*

Line 987: oe_debug_pub.add ('Warning: The configured item was not created because component '||v_missed_item

983: cto_msg_pub.cto_message('BOM','CTO_DROP_ITEM_FROM_CONFIG',l_token);
984: */
985: else
986: IF PG_DEBUG <> 0 THEN
987: oe_debug_pub.add ('Warning: The configured item was not created because component '||v_missed_item
988: || ' on Line Number '||v_missed_line_number
989: || ' in organization ' || lOrg_code
990: || ' could not be included in the configured item''s bill. ',1);
991: oe_debug_pub.add ('Model Name : '||l_model,1);

Line 991: oe_debug_pub.add ('Model Name : '||l_model,1);

987: oe_debug_pub.add ('Warning: The configured item was not created because component '||v_missed_item
988: || ' on Line Number '||v_missed_line_number
989: || ' in organization ' || lOrg_code
990: || ' could not be included in the configured item''s bill. ',1);
991: oe_debug_pub.add ('Model Name : '||l_model,1);
992: oe_debug_pub.add ('Order Number : '||v_order_number,1);
993: END IF;
994:
995: -- Bug Fix 5199775

Line 992: oe_debug_pub.add ('Order Number : '||v_order_number,1);

988: || ' on Line Number '||v_missed_line_number
989: || ' in organization ' || lOrg_code
990: || ' could not be included in the configured item''s bill. ',1);
991: oe_debug_pub.add ('Model Name : '||l_model,1);
992: oe_debug_pub.add ('Order Number : '||v_order_number,1);
993: END IF;
994:
995: -- Bug Fix 5199775
996:

Line 1020: oe_debug_pub.add('Others excepn from stmt '||lStmtNum ||':'||sqlerrm);

1016: EXCEPTION /* exception for stmt 113 ,114 and 117*/
1017:
1018: when others then
1019: IF PG_DEBUG <> 0 THEN
1020: oe_debug_pub.add('Others excepn from stmt '||lStmtNum ||':'||sqlerrm);
1021: END IF;
1022: raise fnd_api.g_exc_error;
1023: END ;
1024:

Line 1037: oe_debug_pub.add ('Setting the global var gApplyHold to Y');

1033:
1034:
1035: if ( lcreate_item = 1) then
1036: IF PG_DEBUG <> 0 THEN
1037: oe_debug_pub.add ('Setting the global var gApplyHold to Y');
1038: END IF;
1039: CTO_CONFIG_BOM_PK.gApplyHold := 'Y';
1040:
1041:

Line 1047: oe_debug_pub.add ('Not creating Item...');

1043:
1044:
1045: else
1046: IF PG_DEBUG <> 0 THEN
1047: oe_debug_pub.add ('Not creating Item...');
1048: END IF;
1049:
1050: -- rkaza. 08/25/2005. bug 4315973.
1051: -- Applying hold even for dropped item cases when config bom

Line 1068: oe_debug_pub.add ('Will not go through Hold Logic and Notification as Preconfigured Bom' , 1 );

1064: */
1065:
1066: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
1067: IF PG_DEBUG <> 0 THEN
1068: oe_debug_pub.add ('Will not go through Hold Logic and Notification as Preconfigured Bom' , 1 );
1069: END IF;
1070: if mismatched_items%ROWCOUNT > 0 then
1071: if ( lcreate_item = 1 ) then
1072: IF PG_DEBUG <> 0 THEN

Line 1073: oe_debug_pub.add ('Create Item profile set to Create and Link Item ' , 1 );

1069: END IF;
1070: if mismatched_items%ROWCOUNT > 0 then
1071: if ( lcreate_item = 1 ) then
1072: IF PG_DEBUG <> 0 THEN
1073: oe_debug_pub.add ('Create Item profile set to Create and Link Item ' , 1 );
1074: END IF;
1075:
1076: lxMessageName := 'CTO_DROP_ITEM_FROM_CONFIG';
1077:

Line 1114: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );

1110: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).ERROR_ORG_ID := lNextRec.organization_id ;
1111: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).MFG_REL_DATE := lEstRelDate ;
1112:
1113: IF PG_DEBUG <> 0 THEN
1114: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1115: END IF;
1116:
1117: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1118:

Line 1122: oe_debug_pub.add ('Create Item profile set to Do Not Create Item ' , 1 );

1118:
1119: else /* lcreate_item <> 1 */
1120:
1121: IF PG_DEBUG <> 0 THEN
1122: oe_debug_pub.add ('Create Item profile set to Do Not Create Item ' , 1 );
1123: END IF;
1124:
1125: lxMessageName := 'CTO_DO_NOT_CREATE_ITEM';
1126:

Line 1165: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );

1161: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).ERROR_ORG_ID := lNextRec.organization_id ;
1162: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).MFG_REL_DATE := lEstRelDate ;
1163:
1164: IF PG_DEBUG <> 0 THEN
1165: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1166: END IF;
1167:
1168: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1169:

Line 1185: oe_debug_pub.add ('Setting the global var gApplyHold to Y');

1181:
1182: lStmtNum := 55;
1183: if ( lcreate_item = 1 ) then
1184: IF PG_DEBUG <> 0 THEN
1185: oe_debug_pub.add ('Setting the global var gApplyHold to Y');
1186: END IF;
1187:
1188: CTO_CONFIG_BOM_PK.gApplyHold := 'Y';
1189: select segment1

Line 1214: oe_debug_pub.add( ' DROPPED ITEM INFO: ' ||

1210: into v_problem_model_line_num
1211: from oe_order_lines_all oel
1212: where line_id = pLineId ;
1213: end if;
1214: oe_debug_pub.add( ' DROPPED ITEM INFO: ' ||
1215: ' Problem Model ' || v_problem_model ||
1216: ' Problem CONFIG ' || v_problem_config ||
1217: ' ERROR ORG ' || v_error_org ||
1218: ' PROBLEM MODEL LINE NUM ' || v_problem_model_line_num

Line 1238: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );

1234: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).ERROR_ORG_ID := lNextRec.organization_id ;
1235: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).MFG_REL_DATE := lEstRelDate ;
1236:
1237: IF PG_DEBUG <> 0 THEN
1238: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1239: END IF;
1240:
1241: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).REQUEST_ID := to_char(fnd_global.conc_request_id) ;
1242:

Line 1244: oe_debug_pub.add('create_bom_ml: ' || 'Getting Custom Recipient..',3);

1240:
1241: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).REQUEST_ID := to_char(fnd_global.conc_request_id) ;
1242:
1243: IF PG_DEBUG <> 0 THEN
1244: oe_debug_pub.add('create_bom_ml: ' || 'Getting Custom Recipient..',3);
1245: END IF;
1246:
1247: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_CREATED
1248: ,p_inventory_item_id => pModelId

Line 1257: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK..' || v_recipient ,3);

1253:
1254:
1255: if( v_recipient is not null ) then
1256: IF PG_DEBUG <> 0 THEN
1257: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK..' || v_recipient ,3);
1258: END IF;
1259:
1260: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).NOTIFY_USER := v_recipient ; /* commented 'MFG' */
1261:

Line 1264: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK is null ..' , 3);

1260: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).NOTIFY_USER := v_recipient ; /* commented 'MFG' */
1261:
1262: else
1263: IF PG_DEBUG <> 0 THEN
1264: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK is null ..' , 3);
1265: oe_debug_pub.add('create_bom_ml: ' || 'Getting the planner code ..',3);
1266: END IF;
1267:
1268: BEGIN

Line 1265: oe_debug_pub.add('create_bom_ml: ' || 'Getting the planner code ..',3);

1261:
1262: else
1263: IF PG_DEBUG <> 0 THEN
1264: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK is null ..' , 3);
1265: oe_debug_pub.add('create_bom_ml: ' || 'Getting the planner code ..',3);
1266: END IF;
1267:
1268: BEGIN
1269: SELECT u.user_name

Line 1279: oe_debug_pub.add('create_bom_ml: ' || '****PLANNER CODE DATA' || lplanner_code ,2);

1275: and item.organization_id = lNextRec.organization_id
1276: and p.organization_id = item.organization_id
1277: and p.planner_code = item.planner_code
1278: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.
1279: oe_debug_pub.add('create_bom_ml: ' || '****PLANNER CODE DATA' || lplanner_code ,2);
1280: EXCEPTION
1281: WHEN OTHERS THEN
1282: IF PG_DEBUG <> 0 THEN
1283: oe_debug_pub.add('create_bom_ml: ' || 'Error in getting the planner code data. Defaulting to SYSADMIN.',2);

Line 1283: oe_debug_pub.add('create_bom_ml: ' || 'Error in getting the planner code data. Defaulting to SYSADMIN.',2);

1279: oe_debug_pub.add('create_bom_ml: ' || '****PLANNER CODE DATA' || lplanner_code ,2);
1280: EXCEPTION
1281: WHEN OTHERS THEN
1282: IF PG_DEBUG <> 0 THEN
1283: oe_debug_pub.add('create_bom_ml: ' || 'Error in getting the planner code data. Defaulting to SYSADMIN.',2);
1284:
1285: oe_debug_pub.add('create_bom_ml: ' || 'Error Message : '||sqlerrm,2);
1286:
1287:

Line 1285: oe_debug_pub.add('create_bom_ml: ' || 'Error Message : '||sqlerrm,2);

1281: WHEN OTHERS THEN
1282: IF PG_DEBUG <> 0 THEN
1283: oe_debug_pub.add('create_bom_ml: ' || 'Error in getting the planner code data. Defaulting to SYSADMIN.',2);
1284:
1285: oe_debug_pub.add('create_bom_ml: ' || 'Error Message : '||sqlerrm,2);
1286:
1287:
1288: END IF;
1289: END;

Line 1310: oe_debug_pub.add ('Not creating Item...');

1306:
1307: else
1308:
1309: IF PG_DEBUG <> 0 THEN
1310: oe_debug_pub.add ('Not creating Item...');
1311: END IF;
1312: select segment1
1313: into v_problem_model
1314: from mtl_system_items

Line 1350: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );

1346: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).ERROR_ORG_ID := lNextRec.organization_id ;
1347: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).MFG_REL_DATE := lEstRelDate ;
1348:
1349: IF PG_DEBUG <> 0 THEN
1350: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1351: END IF;
1352:
1353: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1354:

Line 1356: oe_debug_pub.add('create_bom_ml: ' || 'Getting Custom Recipient..',3);

1352:
1353: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1354:
1355: IF PG_DEBUG <> 0 THEN
1356: oe_debug_pub.add('create_bom_ml: ' || 'Getting Custom Recipient..',3);
1357: END IF;
1358:
1359: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_NOT_CREATED
1360: ,p_inventory_item_id => pModelId

Line 1369: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK..' || v_recipient ,3);

1365:
1366:
1367: if( v_recipient is not null ) then
1368: IF PG_DEBUG <> 0 THEN
1369: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK..' || v_recipient ,3);
1370: END IF;
1371:
1372: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).NOTIFY_USER := v_recipient ; /* commented 'MFG' */
1373:

Line 1377: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK is null ..' , 3);

1373:
1374: else
1375:
1376: IF PG_DEBUG <> 0 THEN
1377: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK is null ..' , 3);
1378: oe_debug_pub.add('create_bom_ml: ' || 'Getting the planner code ..',3);
1379: END IF;
1380:
1381: BEGIN

Line 1378: oe_debug_pub.add('create_bom_ml: ' || 'Getting the planner code ..',3);

1374: else
1375:
1376: IF PG_DEBUG <> 0 THEN
1377: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK is null ..' , 3);
1378: oe_debug_pub.add('create_bom_ml: ' || 'Getting the planner code ..',3);
1379: END IF;
1380:
1381: BEGIN
1382: SELECT u.user_name

Line 1394: oe_debug_pub.add('create_bom_ml: ' || '****PLANNER CODE DATA' || lplanner_code ,2);

1390: and p.planner_code = item.planner_code
1391: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.
1392:
1393:
1394: oe_debug_pub.add('create_bom_ml: ' || '****PLANNER CODE DATA' || lplanner_code ,2);
1395:
1396:
1397: EXCEPTION
1398: WHEN OTHERS THEN

Line 1400: oe_debug_pub.add('create_bom_ml: ' || 'Error in getting the planner code data. Defaulting to SYSADMIN.',2);

1396:
1397: EXCEPTION
1398: WHEN OTHERS THEN
1399: IF PG_DEBUG <> 0 THEN
1400: oe_debug_pub.add('create_bom_ml: ' || 'Error in getting the planner code data. Defaulting to SYSADMIN.',2);
1401:
1402: oe_debug_pub.add('create_bom_ml: ' || 'Error Message : '||sqlerrm,2);
1403:
1404:

Line 1402: oe_debug_pub.add('create_bom_ml: ' || 'Error Message : '||sqlerrm,2);

1398: WHEN OTHERS THEN
1399: IF PG_DEBUG <> 0 THEN
1400: oe_debug_pub.add('create_bom_ml: ' || 'Error in getting the planner code data. Defaulting to SYSADMIN.',2);
1401:
1402: oe_debug_pub.add('create_bom_ml: ' || 'Error Message : '||sqlerrm,2);
1403:
1404:
1405: END IF;
1406: END;

Line 1418: oe_debug_pub.add('create_bom_ml: ' || 'fetching information for apply hold on lineid '|| to_char(pLineId) ,2);

1414: -- rkaza. bug 4315973. 08/24/2005.
1415: -- Hold ato line for dropped items when profile is set to do not
1416: -- create item. Removed aps_version restriction.
1417:
1418: oe_debug_pub.add('create_bom_ml: ' || 'fetching information for apply hold on lineid '|| to_char(pLineId) ,2);
1419: oe_debug_pub.add('create_bom_ml: ' || 'going to apply hold on lineid '|| to_char(pLineId) ,2);
1420:
1421: cto_utility_pk.apply_create_config_hold( l_ato_line_id, l_header_id, xReturnStatus, xMsgCount, xMsgData ) ;
1422:

Line 1419: oe_debug_pub.add('create_bom_ml: ' || 'going to apply hold on lineid '|| to_char(pLineId) ,2);

1415: -- Hold ato line for dropped items when profile is set to do not
1416: -- create item. Removed aps_version restriction.
1417:
1418: oe_debug_pub.add('create_bom_ml: ' || 'fetching information for apply hold on lineid '|| to_char(pLineId) ,2);
1419: oe_debug_pub.add('create_bom_ml: ' || 'going to apply hold on lineid '|| to_char(pLineId) ,2);
1420:
1421: cto_utility_pk.apply_create_config_hold( l_ato_line_id, l_header_id, xReturnStatus, xMsgCount, xMsgData ) ;
1422:
1423:

Line 1463: oe_debug_pub.add ('Failed in stmt ' || lStmtNum || ' with error: '||sqlerrm);

1459: EXCEPTION /* exception for stmt 112 , 115 and 116 */
1460:
1461: when others then
1462: IF PG_DEBUG <> 0 THEN
1463: oe_debug_pub.add ('Failed in stmt ' || lStmtNum || ' with error: '||sqlerrm);
1464: END IF;
1465: raise fnd_api.g_exc_error;
1466: END ;
1467:

Line 1492: oe_debug_pub.add('create_in_src_orgs: '

1488:
1489:
1490:
1491: IF PG_DEBUG <> 0 THEN
1492: oe_debug_pub.add('create_in_src_orgs: '
1493: || 'Returned from Create_bom_ml with status: '
1494: || to_char(lStatus), 1);
1495: END IF;
1496:

Line 1503: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in Create_bom.', 1);

1499: /*----------------------------+
1500: BOM Creation failed
1501: +----------------------------*/
1502: IF PG_DEBUG <> 0 THEN
1503: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in Create_bom.', 1);
1504: END IF;
1505:
1506: /* Clean up bom_inventory_comps_interface */
1507: delete from bom_inventory_comps_interface

Line 1541: oe_debug_pub.add('create_in_src_orgs: '

1537: xMessageName => lXMessageName,
1538: xTableName => lXTableName );
1539:
1540: IF PG_DEBUG <> 0 THEN
1541: oe_debug_pub.add('create_in_src_orgs: '
1542: || 'Returned from Create_routing_ml with status: '
1543: || to_char(lStatus), 1);
1544: END IF;
1545:

Line 1553: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in create_routing.');

1549: /*----------------------------+
1550: Routing Creation failed
1551: +----------------------------*/
1552: IF PG_DEBUG <> 0 THEN
1553: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in create_routing.');
1554: END IF;
1555:
1556: /* Clean up bom_inventory_comps_interface */
1557: delete from bom_inventory_comps_interface

Line 1578: oe_debug_pub.add('create_in_src_orgs: '

1574: lXMessageName,
1575: lXTableName);
1576:
1577: IF PG_DEBUG <> 0 THEN
1578: oe_debug_pub.add('create_in_src_orgs: '
1579: || 'Returned from Create_bom with status: '
1580: || to_char(lStatus), 1);
1581: END IF;
1582:

Line 1586: oe_debug_pub.add('create_in_src_orgs: '

1582:
1583: if (lStatus <> 1) then
1584:
1585: IF PG_DEBUG <> 0 THEN
1586: oe_debug_pub.add('create_in_src_orgs: '
1587: || ' Failed in Create_bom_data', 1);
1588: END IF;
1589:
1590: /* Clean up bom_inventory_comps_interface */

Line 1605: oe_debug_pub.add('added club_comp_error ' , 1) ;

1601:
1602:
1603:
1604: IF PG_DEBUG <> 0 THEN
1605: oe_debug_pub.add('added club_comp_error ' , 1) ;
1606: end if ;
1607:
1608: raise fnd_api.g_exc_error;
1609:

Line 1620: oe_debug_pub.add('create_in_src_orgs: '

1616:
1617: else
1618: -- Added by Renga Kannan to handle the exception
1619: IF PG_DEBUG <> 0 THEN
1620: oe_debug_pub.add('create_in_src_orgs: '
1621: || 'There is no bill for this model in this org',1);
1622:
1623: oe_debug_pub.add('create_in_src_orgs: '
1624: || 'Model id :'||to_char(pModelId),1);

Line 1623: oe_debug_pub.add('create_in_src_orgs: '

1619: IF PG_DEBUG <> 0 THEN
1620: oe_debug_pub.add('create_in_src_orgs: '
1621: || 'There is no bill for this model in this org',1);
1622:
1623: oe_debug_pub.add('create_in_src_orgs: '
1624: || 'Model id :'||to_char(pModelId),1);
1625: oe_debug_pub.add('Org id ;'||to_char(lNextRec.organization_id),1);
1626: END IF;
1627:

Line 1625: oe_debug_pub.add('Org id ;'||to_char(lNextRec.organization_id),1);

1621: || 'There is no bill for this model in this org',1);
1622:
1623: oe_debug_pub.add('create_in_src_orgs: '
1624: || 'Model id :'||to_char(pModelId),1);
1625: oe_debug_pub.add('Org id ;'||to_char(lNextRec.organization_id),1);
1626: END IF;
1627:
1628: /*
1629:

Line 1668: oe_debug_pub.add('create_in_src_orgs: '

1664:
1665: else /* create_config_bom = 'N' */
1666:
1667: IF PG_DEBUG <> 0 THEN
1668: oe_debug_pub.add('create_in_src_orgs: '
1669: || 'create_config_bom parameter is set to N in this org',1);
1670:
1671: oe_debug_pub.add('create_in_src_orgs: '
1672: || 'Model id :'||to_char(pModelId),1);

Line 1671: oe_debug_pub.add('create_in_src_orgs: '

1667: IF PG_DEBUG <> 0 THEN
1668: oe_debug_pub.add('create_in_src_orgs: '
1669: || 'create_config_bom parameter is set to N in this org',1);
1670:
1671: oe_debug_pub.add('create_in_src_orgs: '
1672: || 'Model id :'||to_char(pModelId),1);
1673: oe_debug_pub.add('Org id ;'||to_char(lNextRec.organization_id),1);
1674: END IF;
1675:

Line 1673: oe_debug_pub.add('Org id ;'||to_char(lNextRec.organization_id),1);

1669: || 'create_config_bom parameter is set to N in this org',1);
1670:
1671: oe_debug_pub.add('create_in_src_orgs: '
1672: || 'Model id :'||to_char(pModelId),1);
1673: oe_debug_pub.add('Org id ;'||to_char(lNextRec.organization_id),1);
1674: END IF;
1675:
1676: -- bugfix 2294708: Replaced msg CTO_CREATE_BOM_ERROR with more specific
1677: -- error CTO_BOM_NOT_DEFINED.

Line 1717: oe_debug_pub.add('create_in_src_orgs: '

1713: EXCEPTION
1714:
1715: WHEN fnd_api.g_exc_error THEN
1716: IF PG_DEBUG <> 0 THEN
1717: oe_debug_pub.add('create_in_src_orgs: '
1718: || 'expected error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1719: END IF;
1720:
1721: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

Line 1733: oe_debug_pub.add('create_in_src_orgs: ' || xMsgData , 1 ) ;

1729: , p_msg_data => xMsgData
1730: );
1731:
1732: IF PG_DEBUG <> 0 THEN
1733: oe_debug_pub.add('create_in_src_orgs: ' || xMsgData , 1 ) ;
1734: oe_debug_pub.add('create_in_src_orgs: ' || xMsgCount , 1 ) ;
1735:
1736: END IF;
1737:

Line 1734: oe_debug_pub.add('create_in_src_orgs: ' || xMsgCount , 1 ) ;

1730: );
1731:
1732: IF PG_DEBUG <> 0 THEN
1733: oe_debug_pub.add('create_in_src_orgs: ' || xMsgData , 1 ) ;
1734: oe_debug_pub.add('create_in_src_orgs: ' || xMsgCount , 1 ) ;
1735:
1736: END IF;
1737:
1738: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1752: oe_debug_pub.add('create_in_src_orgs: '

1748: );
1749:
1750: WHEN OTHERS then
1751: IF PG_DEBUG <> 0 THEN
1752: oe_debug_pub.add('create_in_src_orgs: '
1753: || 'create_in_src_orgs::others::'||to_char(lStmtNum)
1754: ||'::'||sqlerrm, 1);
1755: END IF;
1756:

Line 1892: oe_debug_pub.add('update_atp: ' || ' Line Id ' || p_atp_table.identifier(1));

1888: and oel1.link_to_line_id = pLineId
1889: and oel1.ordered_quantity > 0 ;
1890:
1891: IF PG_DEBUG <> 0 THEN
1892: oe_debug_pub.add('update_atp: ' || ' Line Id ' || p_atp_table.identifier(1));
1893:
1894: oe_debug_pub.add('update_atp: ' || ' Inventory Id ' || p_atp_table.inventory_item_id(1));
1895:
1896: oe_debug_pub.add('update_atp: ' || ' Req Date ' || p_atp_table.requested_ship_date(1));

Line 1894: oe_debug_pub.add('update_atp: ' || ' Inventory Id ' || p_atp_table.inventory_item_id(1));

1890:
1891: IF PG_DEBUG <> 0 THEN
1892: oe_debug_pub.add('update_atp: ' || ' Line Id ' || p_atp_table.identifier(1));
1893:
1894: oe_debug_pub.add('update_atp: ' || ' Inventory Id ' || p_atp_table.inventory_item_id(1));
1895:
1896: oe_debug_pub.add('update_atp: ' || ' Req Date ' || p_atp_table.requested_ship_date(1));
1897:
1898: oe_debug_pub.add('update_atp: ' || ' qty ' || p_atp_table.quantity_ordered(1));

Line 1896: oe_debug_pub.add('update_atp: ' || ' Req Date ' || p_atp_table.requested_ship_date(1));

1892: oe_debug_pub.add('update_atp: ' || ' Line Id ' || p_atp_table.identifier(1));
1893:
1894: oe_debug_pub.add('update_atp: ' || ' Inventory Id ' || p_atp_table.inventory_item_id(1));
1895:
1896: oe_debug_pub.add('update_atp: ' || ' Req Date ' || p_atp_table.requested_ship_date(1));
1897:
1898: oe_debug_pub.add('update_atp: ' || ' qty ' || p_atp_table.quantity_ordered(1));
1899: END IF;
1900:

Line 1898: oe_debug_pub.add('update_atp: ' || ' qty ' || p_atp_table.quantity_ordered(1));

1894: oe_debug_pub.add('update_atp: ' || ' Inventory Id ' || p_atp_table.inventory_item_id(1));
1895:
1896: oe_debug_pub.add('update_atp: ' || ' Req Date ' || p_atp_table.requested_ship_date(1));
1897:
1898: oe_debug_pub.add('update_atp: ' || ' qty ' || p_atp_table.quantity_ordered(1));
1899: END IF;
1900:
1901:
1902: /*--------------------------------------+

Line 1929: oe_debug_pub.add('update_atp: ' || 'From output record ---> ',1);

1925:
1926: if i is not null then
1927:
1928: IF PG_DEBUG <> 0 THEN
1929: oe_debug_pub.add('update_atp: ' || 'From output record ---> ',1);
1930: END IF;
1931:
1932: while i is not null
1933: loop

Line 1936: oe_debug_pub.add('update_atp: ' || ' Line Id '

1932: while i is not null
1933: loop
1934:
1935: IF PG_DEBUG <> 0 THEN
1936: oe_debug_pub.add('update_atp: ' || ' Line Id '
1937: || l_smc_table.identifier(i));
1938:
1939: oe_debug_pub.add('update_atp: ' || ' Inventory Id '
1940: || l_smc_table.inventory_item_id(i));

Line 1939: oe_debug_pub.add('update_atp: ' || ' Inventory Id '

1935: IF PG_DEBUG <> 0 THEN
1936: oe_debug_pub.add('update_atp: ' || ' Line Id '
1937: || l_smc_table.identifier(i));
1938:
1939: oe_debug_pub.add('update_atp: ' || ' Inventory Id '
1940: || l_smc_table.inventory_item_id(i));
1941:
1942: oe_debug_pub.add('update_atp: ' || ' Req Date '
1943: || l_smc_table.requested_ship_date(i));

Line 1942: oe_debug_pub.add('update_atp: ' || ' Req Date '

1938:
1939: oe_debug_pub.add('update_atp: ' || ' Inventory Id '
1940: || l_smc_table.inventory_item_id(i));
1941:
1942: oe_debug_pub.add('update_atp: ' || ' Req Date '
1943: || l_smc_table.requested_ship_date(i));
1944:
1945: oe_debug_pub.add('update_atp: ' || ' qty '
1946: || l_smc_table.quantity_ordered(i));

Line 1945: oe_debug_pub.add('update_atp: ' || ' qty '

1941:
1942: oe_debug_pub.add('update_atp: ' || ' Req Date '
1943: || l_smc_table.requested_ship_date(i));
1944:
1945: oe_debug_pub.add('update_atp: ' || ' qty '
1946: || l_smc_table.quantity_ordered(i));
1947: END IF;
1948:
1949: i := l_smc_table.inventory_item_id.NEXT(i);

Line 1953: oe_debug_pub.add('update_atp: ' || 'Calling ATP ---> ',1);

1949: i := l_smc_table.inventory_item_id.NEXT(i);
1950: end loop;
1951:
1952: IF PG_DEBUG <> 0 THEN
1953: oe_debug_pub.add('update_atp: ' || 'Calling ATP ---> ',1);
1954: END IF;
1955:
1956: /*----------------------------+
1957: Call ATP

Line 1972: oe_debug_pub.add('update_atp: ' || 'ATP returned ' || l_return_status);

1968: l_msg_data,
1969: l_msg_count);
1970:
1971: IF PG_DEBUG <> 0 THEN
1972: oe_debug_pub.add('update_atp: ' || 'ATP returned ' || l_return_status);
1973: END IF;
1974:
1975: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1976: or l_return_status = FND_API.G_RET_STS_ERROR ) then

Line 1981: oe_debug_pub.add('update_atp: ' || 'No Mandatory components for ATP found' );

1977: raise atp_error;
1978: END IF;
1979: else
1980: IF PG_DEBUG <> 0 THEN
1981: oe_debug_pub.add('update_atp: ' || 'No Mandatory components for ATP found' );
1982: END IF;
1983:
1984: end if;
1985:

Line 2069: oe_debug_pub.add( ' is_item_transacted is null -> true ' ) ;

2065: -- fnd_message.Set_Name('BOM', 'CST_ITEM_USED_IN_TXN');
2066: RetVal := TRUE;
2067: ELSE
2068: IF PG_DEBUG <> 0 THEN
2069: oe_debug_pub.add( ' is_item_transacted is null -> true ' ) ;
2070: END IF;
2071:
2072: RetVal := FALSE ;
2073: END IF;

Line 2077: oe_debug_pub.add( ' cost type id not 1 ' ) ;

2073: END IF;
2074:
2075: ELSE
2076: IF PG_DEBUG <> 0 THEN
2077: oe_debug_pub.add( ' cost type id not 1 ' ) ;
2078: END IF;
2079:
2080: RetVal := FALSE ;
2081: END IF;

Line 2086: oe_debug_pub.add( ' is_item_transacted is true ' ) ;

2082:
2083: IF PG_DEBUG <> 0 THEN
2084:
2085: if( RetVal = TRUE ) then
2086: oe_debug_pub.add( ' is_item_transacted is true ' ) ;
2087: elsif( RetVal = False ) then
2088: oe_debug_pub.add( ' is_item_transacted is false' ) ;
2089: elsif( RetVal is null ) then
2090: oe_debug_pub.add( ' is_item_transacted is null ' ) ;

Line 2088: oe_debug_pub.add( ' is_item_transacted is false' ) ;

2084:
2085: if( RetVal = TRUE ) then
2086: oe_debug_pub.add( ' is_item_transacted is true ' ) ;
2087: elsif( RetVal = False ) then
2088: oe_debug_pub.add( ' is_item_transacted is false' ) ;
2089: elsif( RetVal is null ) then
2090: oe_debug_pub.add( ' is_item_transacted is null ' ) ;
2091: end if ;
2092: END IF;

Line 2090: oe_debug_pub.add( ' is_item_transacted is null ' ) ;

2086: oe_debug_pub.add( ' is_item_transacted is true ' ) ;
2087: elsif( RetVal = False ) then
2088: oe_debug_pub.add( ' is_item_transacted is false' ) ;
2089: elsif( RetVal is null ) then
2090: oe_debug_pub.add( ' is_item_transacted is null ' ) ;
2091: end if ;
2092: END IF;
2093:
2094:

Line 2173: oe_debug_pub.add('create_in_src_orgs: ' || 'In create_in_src_orgs. Item: ' ||

2169: -- check if model bom exists in src org
2170:
2171: lStmtNum := 10;
2172: IF PG_DEBUG <> 0 THEN
2173: oe_debug_pub.add('create_in_src_orgs: ' || 'In create_in_src_orgs. Item: ' ||
2174: to_char(pConfigId) || '. Costing Org ' || -- 3116778
2175: to_char(p_cost_organization_id) || '. Source Org ' || -- 3116778
2176: to_char(p_organization_id), 1);
2177: END IF;

Line 2245: oe_debug_pub.add('Buy Cost Type id ::'|| v_buy_cost_type_id , 2);

2241: from cst_cost_types
2242: where cost_type = lBuyCostType ;
2243:
2244: IF PG_DEBUG <> 0 THEN
2245: oe_debug_pub.add('Buy Cost Type id ::'|| v_buy_cost_type_id , 2);
2246: END IF;
2247:
2248: exception
2249: when no_data_found then

Line 2265: oe_debug_pub.add('defaulting buy cost = cto cost ' , 2);

2261: else
2262: v_buy_cost_type_id := v_cto_cost_type_id ;
2263:
2264: IF PG_DEBUG <> 0 THEN
2265: oe_debug_pub.add('defaulting buy cost = cto cost ' , 2);
2266: END IF;
2267:
2268: end if ;
2269:

Line 2288: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;

2284: and rollup_source_type = 3 ; -- bugfix 2808704
2285:
2286:
2287: IF PG_DEBUG <> 0 THEN
2288: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2289: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2290: END IF;
2291:
2292:

Line 2289: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;

2285:
2286:
2287: IF PG_DEBUG <> 0 THEN
2288: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2289: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2290: END IF;
2291:
2292:
2293: exception

Line 2358: oe_debug_pub.add('going for stmt 40 ' || pConfigId

2354:
2355:
2356:
2357: IF PG_DEBUG <> 0 THEN
2358: oe_debug_pub.add('going for stmt 40 ' || pConfigId
2359: || ' org ' || p_organization_id
2360: || ' cost org ' || p_cost_organization_id -- 3116778
2361: || ' pri ' || v_primary_cost_method
2362: || ' buy ' || v_buy_cost_type_id

Line 2382: oe_debug_pub.add('v_buy_cost ' || v_buy_cost , 1);

2378:
2379:
2380:
2381: IF PG_DEBUG <> 0 THEN
2382: oe_debug_pub.add('v_buy_cost ' || v_buy_cost , 1);
2383: oe_debug_pub.add('org ' || p_organization_id , 1);
2384: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2385: oe_debug_pub.add('cost id ' || v_buy_cost_type_id, 1);
2386: END IF;

Line 2383: oe_debug_pub.add('org ' || p_organization_id , 1);

2379:
2380:
2381: IF PG_DEBUG <> 0 THEN
2382: oe_debug_pub.add('v_buy_cost ' || v_buy_cost , 1);
2383: oe_debug_pub.add('org ' || p_organization_id , 1);
2384: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2385: oe_debug_pub.add('cost id ' || v_buy_cost_type_id, 1);
2386: END IF;
2387:

Line 2384: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778

2380:
2381: IF PG_DEBUG <> 0 THEN
2382: oe_debug_pub.add('v_buy_cost ' || v_buy_cost , 1);
2383: oe_debug_pub.add('org ' || p_organization_id , 1);
2384: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2385: oe_debug_pub.add('cost id ' || v_buy_cost_type_id, 1);
2386: END IF;
2387:
2388: exception

Line 2385: oe_debug_pub.add('cost id ' || v_buy_cost_type_id, 1);

2381: IF PG_DEBUG <> 0 THEN
2382: oe_debug_pub.add('v_buy_cost ' || v_buy_cost , 1);
2383: oe_debug_pub.add('org ' || p_organization_id , 1);
2384: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2385: oe_debug_pub.add('cost id ' || v_buy_cost_type_id, 1);
2386: END IF;
2387:
2388: exception
2389: when no_data_found then

Line 2394: oe_debug_pub.add('v_buy_cost null ' , 1);

2390:
2391: v_buy_cost := null ;
2392:
2393: IF PG_DEBUG <> 0 THEN
2394: oe_debug_pub.add('v_buy_cost null ' , 1);
2395: oe_debug_pub.add('org ' || p_organization_id , 1);
2396: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2397: END IF;
2398:

Line 2395: oe_debug_pub.add('org ' || p_organization_id , 1);

2391: v_buy_cost := null ;
2392:
2393: IF PG_DEBUG <> 0 THEN
2394: oe_debug_pub.add('v_buy_cost null ' , 1);
2395: oe_debug_pub.add('org ' || p_organization_id , 1);
2396: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2397: END IF;
2398:
2399: when others then

Line 2396: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778

2392:
2393: IF PG_DEBUG <> 0 THEN
2394: oe_debug_pub.add('v_buy_cost null ' , 1);
2395: oe_debug_pub.add('org ' || p_organization_id , 1);
2396: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2397: END IF;
2398:
2399: when others then
2400:

Line 2409: oe_debug_pub.add('v_buy_cost null as buy cost profile is not set ' , 1);

2405:
2406: else
2407:
2408: IF PG_DEBUG <> 0 THEN
2409: oe_debug_pub.add('v_buy_cost null as buy cost profile is not set ' , 1);
2410: END IF;
2411:
2412: v_buy_cost := null ;
2413:

Line 2419: oe_debug_pub.add('going for stmt 45 ' , 1);

2415:
2416:
2417:
2418: IF PG_DEBUG <> 0 THEN
2419: oe_debug_pub.add('going for stmt 45 ' , 1);
2420: END IF;
2421:
2422:
2423: lStmtNum := 45;

Line 2426: oe_debug_pub.add('line ' || pLineId , 1);

2422:
2423: lStmtNum := 45;
2424:
2425: IF PG_DEBUG <> 0 THEN
2426: oe_debug_pub.add('line ' || pLineId , 1);
2427: END IF;
2428:
2429:
2430:

Line 2448: oe_debug_pub.add('others ' || SQLERRM , 1);

2444:
2445: exception
2446: when too_many_rows then -- added for bug 3877317
2447: IF PG_DEBUG <> 0 THEN
2448: oe_debug_pub.add('others ' || SQLERRM , 1);
2449: oe_debug_pub.add('going to check whether make organization for too_many_rows ' , 1);
2450: END IF;
2451:
2452: /*

Line 2449: oe_debug_pub.add('going to check whether make organization for too_many_rows ' , 1);

2445: exception
2446: when too_many_rows then -- added for bug 3877317
2447: IF PG_DEBUG <> 0 THEN
2448: oe_debug_pub.add('others ' || SQLERRM , 1);
2449: oe_debug_pub.add('going to check whether make organization for too_many_rows ' , 1);
2450: END IF;
2451:
2452: /*
2453: BUG 3877317

Line 2471: oe_debug_pub.add( p_organization_id || ' is make organization ' , 1);

2467: and organization_type = '2'
2468: and cost_rollup = 'Y' ;
2469:
2470: IF PG_DEBUG <> 0 THEN
2471: oe_debug_pub.add( p_organization_id || ' is make organization ' , 1);
2472: END IF;
2473: exception
2474: when no_data_found then
2475: v_organization_type := 1 ;

Line 2484: oe_debug_pub.add('others ' || SQLERRM , 1);

2480:
2481:
2482: when others then
2483: IF PG_DEBUG <> 0 THEN
2484: oe_debug_pub.add('others ' || SQLERRM , 1);
2485: oe_debug_pub.add('defaulting organization type = 4 ' , 1);
2486: END IF;
2487:
2488: v_organization_type := 4 ;

Line 2485: oe_debug_pub.add('defaulting organization type = 4 ' , 1);

2481:
2482: when others then
2483: IF PG_DEBUG <> 0 THEN
2484: oe_debug_pub.add('others ' || SQLERRM , 1);
2485: oe_debug_pub.add('defaulting organization type = 4 ' , 1);
2486: END IF;
2487:
2488: v_organization_type := 4 ;
2489: /* cost rollup is 'N' for child models of drop ship or buy */

Line 2500: oe_debug_pub.add('organization_type ' || v_organization_type , 1);

2496:
2497:
2498:
2499: IF PG_DEBUG <> 0 THEN
2500: oe_debug_pub.add('organization_type ' || v_organization_type , 1);
2501:
2502: oe_debug_pub.add('valuation cost ' || v_valuation_cost , 1);
2503: oe_debug_pub.add('primary cost method ' || v_primary_cost_method , 1);
2504: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;

Line 2502: oe_debug_pub.add('valuation cost ' || v_valuation_cost , 1);

2498:
2499: IF PG_DEBUG <> 0 THEN
2500: oe_debug_pub.add('organization_type ' || v_organization_type , 1);
2501:
2502: oe_debug_pub.add('valuation cost ' || v_valuation_cost , 1);
2503: oe_debug_pub.add('primary cost method ' || v_primary_cost_method , 1);
2504: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2505: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2506: oe_debug_pub.add('buy cost ' || v_buy_cost ) ;

Line 2503: oe_debug_pub.add('primary cost method ' || v_primary_cost_method , 1);

2499: IF PG_DEBUG <> 0 THEN
2500: oe_debug_pub.add('organization_type ' || v_organization_type , 1);
2501:
2502: oe_debug_pub.add('valuation cost ' || v_valuation_cost , 1);
2503: oe_debug_pub.add('primary cost method ' || v_primary_cost_method , 1);
2504: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2505: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2506: oe_debug_pub.add('buy cost ' || v_buy_cost ) ;
2507:

Line 2504: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;

2500: oe_debug_pub.add('organization_type ' || v_organization_type , 1);
2501:
2502: oe_debug_pub.add('valuation cost ' || v_valuation_cost , 1);
2503: oe_debug_pub.add('primary cost method ' || v_primary_cost_method , 1);
2504: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2505: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2506: oe_debug_pub.add('buy cost ' || v_buy_cost ) ;
2507:
2508:

Line 2505: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;

2501:
2502: oe_debug_pub.add('valuation cost ' || v_valuation_cost , 1);
2503: oe_debug_pub.add('primary cost method ' || v_primary_cost_method , 1);
2504: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2505: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2506: oe_debug_pub.add('buy cost ' || v_buy_cost ) ;
2507:
2508:
2509: oe_debug_pub.add('going for stmt 50 ' , 1);

Line 2506: oe_debug_pub.add('buy cost ' || v_buy_cost ) ;

2502: oe_debug_pub.add('valuation cost ' || v_valuation_cost , 1);
2503: oe_debug_pub.add('primary cost method ' || v_primary_cost_method , 1);
2504: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2505: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2506: oe_debug_pub.add('buy cost ' || v_buy_cost ) ;
2507:
2508:
2509: oe_debug_pub.add('going for stmt 50 ' , 1);
2510: END IF;

Line 2509: oe_debug_pub.add('going for stmt 50 ' , 1);

2505: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2506: oe_debug_pub.add('buy cost ' || v_buy_cost ) ;
2507:
2508:
2509: oe_debug_pub.add('going for stmt 50 ' , 1);
2510: END IF;
2511:
2512:
2513: lStmtNum := 50;

Line 2534: oe_debug_pub.add( ' came into item transacted ' , 1 ) ;

2530:
2531: if( v_item_transacted ) then
2532:
2533: IF PG_DEBUG <> 0 THEN
2534: oe_debug_pub.add( ' came into item transacted ' , 1 ) ;
2535: END IF;
2536:
2537: if( v_valuation_cost <> v_cto_cost or v_cto_cost is null ) then
2538:

Line 2540: oe_debug_pub.add( ' going to copy cost valuation cost ' ||

2536:
2537: if( v_valuation_cost <> v_cto_cost or v_cto_cost is null ) then
2538:
2539: IF PG_DEBUG <> 0 THEN
2540: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2541: v_primary_cost_method , 1 ) ;
2542: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2543: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2544: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;

Line 2542: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;

2538:
2539: IF PG_DEBUG <> 0 THEN
2540: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2541: v_primary_cost_method , 1 ) ;
2542: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2543: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2544: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2545: oe_debug_pub.add( 'cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2546:

Line 2543: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;

2539: IF PG_DEBUG <> 0 THEN
2540: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2541: v_primary_cost_method , 1 ) ;
2542: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2543: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2544: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2545: oe_debug_pub.add( 'cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2546:
2547: END IF;

Line 2544: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;

2540: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2541: v_primary_cost_method , 1 ) ;
2542: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2543: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2544: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2545: oe_debug_pub.add( 'cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2546:
2547: END IF;
2548:

Line 2545: oe_debug_pub.add( 'cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778

2541: v_primary_cost_method , 1 ) ;
2542: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2543: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2544: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2545: oe_debug_pub.add( 'cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2546:
2547: END IF;
2548:
2549:

Line 2562: oe_debug_pub.add( ' cto cost is same as valuation cost no need to synch up ' , 1 ) ;

2558:
2559: else
2560:
2561: IF PG_DEBUG <> 0 THEN
2562: oe_debug_pub.add( ' cto cost is same as valuation cost no need to synch up ' , 1 ) ;
2563: END IF;
2564:
2565: end if ;
2566:

Line 2578: oe_debug_pub.add( ' updated bcso cost rollup N for line ' || pLineId

2574: and organization_id = p_organization_id ;
2575:
2576:
2577: IF PG_DEBUG <> 0 THEN
2578: oe_debug_pub.add( ' updated bcso cost rollup N for line ' || pLineId
2579: || ' org ' || p_organization_id
2580: || ' count ' || to_char(sql%rowcount)
2581: , 1 ) ;
2582: END IF;

Line 2594: oe_debug_pub.add( ' updated bcmo cost rollup N for group_ref ' || p_group_reference_id

2590: and organization_id = p_organization_id ;
2591:
2592:
2593: IF PG_DEBUG <> 0 THEN
2594: oe_debug_pub.add( ' updated bcmo cost rollup N for group_ref ' || p_group_reference_id
2595: || ' org ' || p_organization_id
2596: || ' count ' || to_char(sql%rowcount)
2597: , 1 ) ;
2598: END IF;

Line 2606: oe_debug_pub.add( ' going to indicate no cost rollup due to transacted condition 1 '

2602: end if ;
2603:
2604:
2605: IF PG_DEBUG <> 0 THEN
2606: oe_debug_pub.add( ' going to indicate no cost rollup due to transacted condition 1 '
2607: , 1 ) ;
2608: END IF;
2609:
2610:

Line 2623: oe_debug_pub.add( ' came into make organization type ' , 1 ) ;

2619:
2620: if( v_organization_type = '2' ) then /* make */
2621:
2622: IF PG_DEBUG <> 0 THEN
2623: oe_debug_pub.add( ' came into make organization type ' , 1 ) ;
2624: END IF;
2625:
2626: if( v_rolledup_cost_count > 0 and
2627: ( v_rolledup_cost <> v_buy_cost or v_buy_cost is null ) ) then

Line 2635: oe_debug_pub.add( ' going to copy cost valuation cost ' ||

2631:
2632: if( v_valuation_cost <> v_cto_cost or v_cto_cost is null ) then
2633:
2634: IF PG_DEBUG <> 0 THEN
2635: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2636: v_primary_cost_method , 1 ) ;
2637: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2638: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2639: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;

Line 2637: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;

2633:
2634: IF PG_DEBUG <> 0 THEN
2635: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2636: v_primary_cost_method , 1 ) ;
2637: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2638: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2639: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2640: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2641: END IF;

Line 2638: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;

2634: IF PG_DEBUG <> 0 THEN
2635: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2636: v_primary_cost_method , 1 ) ;
2637: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2638: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2639: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2640: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2641: END IF;
2642:

Line 2639: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;

2635: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2636: v_primary_cost_method , 1 ) ;
2637: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2638: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2639: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2640: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2641: END IF;
2642:
2643:

Line 2640: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778

2636: v_primary_cost_method , 1 ) ;
2637: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2638: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2639: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2640: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2641: END IF;
2642:
2643:
2644: /* copy_valuation_cost_to_cto_cost() ; */

Line 2656: oe_debug_pub.add( ' cto cost is same as valuation cost no need to synch up ' , 1 ) ;

2652:
2653: else
2654:
2655: IF PG_DEBUG <> 0 THEN
2656: oe_debug_pub.add( ' cto cost is same as valuation cost no need to synch up ' , 1 ) ;
2657: END IF;
2658:
2659: end if ;
2660:

Line 2670: oe_debug_pub.add( ' updated bcso cost rollup N for line ' || pLineId

2666: where line_id = pLineId
2667: and organization_id = p_organization_id ;
2668:
2669: IF PG_DEBUG <> 0 THEN
2670: oe_debug_pub.add( ' updated bcso cost rollup N for line ' || pLineId
2671: || ' org ' || p_organization_id
2672: || ' count ' || to_char(sql%rowcount)
2673: , 1 ) ;
2674: END IF;

Line 2684: oe_debug_pub.add( ' updated bcmo cost rollup N for group_ref ' || p_group_reference_id

2680: where group_reference_id = p_group_reference_id
2681: and organization_id = p_organization_id ;
2682:
2683: IF PG_DEBUG <> 0 THEN
2684: oe_debug_pub.add( ' updated bcmo cost rollup N for group_ref ' || p_group_reference_id
2685: || ' org ' || p_organization_id
2686: || ' count ' || to_char(sql%rowcount)
2687: , 1 ) ;
2688:

Line 2695: oe_debug_pub.add( ' going to indicate no cost rollup due to std make condition 1 '

2691:
2692: end if ;
2693:
2694: IF PG_DEBUG <> 0 THEN
2695: oe_debug_pub.add( ' going to indicate no cost rollup due to std make condition 1 '
2696: , 1 ) ;
2697: END IF;
2698:
2699:

Line 2708: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;

2704:
2705: elsif( v_organization_type in ( '3', '5')) then /* buy, dropship */
2706:
2707: IF PG_DEBUG <> 0 THEN
2708: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2709: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2710: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2711: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2712: END IF ;

Line 2709: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;

2705: elsif( v_organization_type in ( '3', '5')) then /* buy, dropship */
2706:
2707: IF PG_DEBUG <> 0 THEN
2708: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2709: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2710: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2711: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2712: END IF ;
2713:

Line 2710: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;

2706:
2707: IF PG_DEBUG <> 0 THEN
2708: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2709: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2710: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2711: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2712: END IF ;
2713:
2714:

Line 2711: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;

2707: IF PG_DEBUG <> 0 THEN
2708: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2709: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2710: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2711: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2712: END IF ;
2713:
2714:
2715: end if ; /* costing for matched items logic */

Line 2733: oe_debug_pub.add( ' going to copy cost valuation cost ' ||

2729:
2730:
2731: if( v_valuation_cost <> v_cto_cost or v_cto_cost is null ) then
2732: IF PG_DEBUG <> 0 THEN
2733: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2734: v_primary_cost_method , 1 ) ;
2735: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2736: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2737: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;

Line 2735: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;

2731: if( v_valuation_cost <> v_cto_cost or v_cto_cost is null ) then
2732: IF PG_DEBUG <> 0 THEN
2733: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2734: v_primary_cost_method , 1 ) ;
2735: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2736: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2737: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2738: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2739: END IF;

Line 2736: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;

2732: IF PG_DEBUG <> 0 THEN
2733: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2734: v_primary_cost_method , 1 ) ;
2735: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2736: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2737: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2738: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2739: END IF;
2740:

Line 2737: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;

2733: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2734: v_primary_cost_method , 1 ) ;
2735: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2736: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2737: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2738: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2739: END IF;
2740:
2741:

Line 2738: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778

2734: v_primary_cost_method , 1 ) ;
2735: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2736: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2737: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2738: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2739: END IF;
2740:
2741:
2742: /* copy_valuation_cost_to_cto_cost() ; */

Line 2753: oe_debug_pub.add( ' cto cost is same as valuation cost no need to synch up ' , 1 ) ;

2749:
2750: else
2751:
2752: IF PG_DEBUG <> 0 THEN
2753: oe_debug_pub.add( ' cto cost is same as valuation cost no need to synch up ' , 1 ) ;
2754: END IF;
2755:
2756: end if ;
2757:

Line 2771: oe_debug_pub.add( ' updated bcso cost rollup N for line ' || pLineId

2767: where line_id = pLineId
2768: and organization_id = p_organization_id ;
2769:
2770: IF PG_DEBUG <> 0 THEN
2771: oe_debug_pub.add( ' updated bcso cost rollup N for line ' || pLineId
2772: || ' org ' || p_organization_id
2773: || ' count ' || to_char(sql%rowcount)
2774: , 1 ) ;
2775: END IF;

Line 2785: oe_debug_pub.add( ' updated bcmo cost rollup N for group_ref ' || p_group_reference_id

2781: where group_reference_id = p_group_reference_id
2782: and organization_id = p_organization_id ;
2783:
2784: IF PG_DEBUG <> 0 THEN
2785: oe_debug_pub.add( ' updated bcmo cost rollup N for group_ref ' || p_group_reference_id
2786: || ' org ' || p_organization_id
2787: || ' count ' || to_char(sql%rowcount)
2788: , 1 ) ;
2789:

Line 2798: oe_debug_pub.add( ' going to indicate no cost rollup due to avg make condition 1 '

2794: end if ;
2795:
2796:
2797: IF PG_DEBUG <> 0 THEN
2798: oe_debug_pub.add( ' going to indicate no cost rollup due to avg make condition 1 '
2799: , 1 ) ;
2800: END IF;
2801:
2802:

Line 2825: oe_debug_pub.add( ' updated bcso cost rollup N for line ' || pLineId

2821: where line_id = pLineId
2822: and organization_id = p_organization_id ;
2823:
2824: IF PG_DEBUG <> 0 THEN
2825: oe_debug_pub.add( ' updated bcso cost rollup N for line ' || pLineId
2826: || ' org ' || p_organization_id
2827: || ' count ' || to_char(sql%rowcount)
2828: , 1 ) ;
2829: END IF;

Line 2839: oe_debug_pub.add( ' updated bcmo cost rollup N for group_ref ' || p_group_reference_id

2835: where group_reference_id = p_group_reference_id
2836: and organization_id = p_organization_id ;
2837:
2838: IF PG_DEBUG <> 0 THEN
2839: oe_debug_pub.add( ' updated bcmo cost rollup N for group_ref ' || p_group_reference_id
2840: || ' org ' || p_organization_id
2841: || ' count ' || to_char(sql%rowcount)
2842: , 1 ) ;
2843:

Line 2852: oe_debug_pub.add( ' going to indicate no cost rollup due to avg make condition 2 '

2848: end if ;
2849:
2850:
2851: IF PG_DEBUG <> 0 THEN
2852: oe_debug_pub.add( ' going to indicate no cost rollup due to avg make condition 2 '
2853: , 1 ) ;
2854: END IF;
2855:
2856:

Line 2863: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;

2859:
2860: elsif( v_organization_type in ( '3', '5')) then /* buy, dropship */
2861:
2862: IF PG_DEBUG <> 0 THEN
2863: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2864: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2865: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2866: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2867: END IF ;

Line 2864: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;

2860: elsif( v_organization_type in ( '3', '5')) then /* buy, dropship */
2861:
2862: IF PG_DEBUG <> 0 THEN
2863: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2864: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2865: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2866: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2867: END IF ;
2868:

Line 2865: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;

2861:
2862: IF PG_DEBUG <> 0 THEN
2863: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2864: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2865: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2866: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2867: END IF ;
2868:
2869:

Line 2866: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;

2862: IF PG_DEBUG <> 0 THEN
2863: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2864: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2865: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2866: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2867: END IF ;
2868:
2869:
2870: end if ; /* costing for make or buy logic */

Line 2897: oe_debug_pub.add('create_in_src_orgs: '

2893:
2894: Exception
2895: WHEN fnd_api.g_exc_error THEN
2896: IF PG_DEBUG <> 0 THEN
2897: oe_debug_pub.add('create_in_src_orgs: '
2898: || 'expected error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2899: END IF;
2900:
2901: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

Line 2926: oe_debug_pub.add('create_in_src_orgs: '

2922: );
2923:
2924: WHEN OTHERS then
2925: IF PG_DEBUG <> 0 THEN
2926: oe_debug_pub.add('create_in_src_orgs: '
2927: || 'create_in_src_orgs::others::'||to_char(lStmtNum)
2928: ||'::'||sqlerrm, 1);
2929: END IF;
2930: