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 501: oe_debug_pub.add(' entered create_in_src_orgs: model ' || pModelId

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 637: oe_debug_pub.add('create_in_src_orgs: '

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

Line 655: oe_debug_pub.add('create_in_src_orgs: '

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1463: oe_debug_pub.add('Deleted from bici, rows::'||lCnt);

1459: and batch_id = cto_msutil_pub.bom_batch_id;
1460:
1461: lCnt := sql%rowcount;
1462: IF PG_DEBUG <> 0 THEN
1463: oe_debug_pub.add('Deleted from bici, rows::'||lCnt);
1464: END IF;
1465:
1466: --Bugfix 11056452
1467: delete from bom_bill_of_mtls_interface

Line 1473: oe_debug_pub.add('Deleted from bmi, rows::'||lCnt);

1469: and batch_id = cto_msutil_pub.bom_batch_id;
1470:
1471: lCnt := sql%rowcount;
1472: IF PG_DEBUG <> 0 THEN
1473: oe_debug_pub.add('Deleted from bmi, rows::'||lCnt);
1474: END IF;
1475:
1476:
1477: EXCEPTION /* exception for stmt 112 , 115 and 116 */

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

1477: EXCEPTION /* exception for stmt 112 , 115 and 116 */
1478:
1479: when others then
1480: IF PG_DEBUG <> 0 THEN
1481: oe_debug_pub.add ('Failed in stmt ' || lStmtNum || ' with error: '||sqlerrm);
1482: END IF;
1483: raise fnd_api.g_exc_error;
1484: END ;
1485:

Line 1510: oe_debug_pub.add('create_in_src_orgs: '

1506:
1507:
1508:
1509: IF PG_DEBUG <> 0 THEN
1510: oe_debug_pub.add('create_in_src_orgs: '
1511: || 'Returned from Create_bom_ml with status: '
1512: || to_char(lStatus), 1);
1513: END IF;
1514:

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

1517: /*----------------------------+
1518: BOM Creation failed
1519: +----------------------------*/
1520: IF PG_DEBUG <> 0 THEN
1521: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in Create_bom.', 1);
1522: END IF;
1523:
1524: /* Clean up bom_inventory_comps_interface */
1525: delete from bom_inventory_comps_interface

Line 1530: oe_debug_pub.add('Deleted from bici, rows::'||lCnt);

1526: where bill_sequence_id = lCfgBillId;
1527:
1528: lCnt := sql%rowcount;
1529: IF PG_DEBUG <> 0 THEN
1530: oe_debug_pub.add('Deleted from bici, rows::'||lCnt);
1531: END IF;
1532:
1533: --Bugfix 11056452
1534: delete from bom_bill_of_mtls_interface

Line 1539: oe_debug_pub.add('Deleted from bmi, rows::'||lCnt);

1535: where bill_sequence_id = lCfgBillId;
1536:
1537: lCnt := sql%rowcount;
1538: IF PG_DEBUG <> 0 THEN
1539: oe_debug_pub.add('Deleted from bmi, rows::'||lCnt);
1540: END IF;
1541:
1542:
1543: if( lStatus = -1) then /* add a message for unexpected errors(-1), expected errors(0) already have a message */

Line 1573: oe_debug_pub.add('create_in_src_orgs: '

1569: xMessageName => lXMessageName,
1570: xTableName => lXTableName );
1571:
1572: IF PG_DEBUG <> 0 THEN
1573: oe_debug_pub.add('create_in_src_orgs: '
1574: || 'Returned from Create_routing_ml with status: '
1575: || to_char(lStatus), 1);
1576: END IF;
1577:

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

1581: /*----------------------------+
1582: Routing Creation failed
1583: +----------------------------*/
1584: IF PG_DEBUG <> 0 THEN
1585: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in create_routing.');
1586: END IF;
1587:
1588: /* Clean up bom_inventory_comps_interface */
1589: delete from bom_inventory_comps_interface

Line 1594: oe_debug_pub.add('Deleted from bici, rows::'||lCnt);

1590: where bill_sequence_id = lCfgBillId;
1591:
1592: lCnt := sql%rowcount;
1593: IF PG_DEBUG <> 0 THEN
1594: oe_debug_pub.add('Deleted from bici, rows::'||lCnt);
1595: END IF;
1596:
1597: --Bugfix 11056452
1598: delete from bom_bill_of_mtls_interface

Line 1603: oe_debug_pub.add('Deleted from bmi, rows::'||lCnt);

1599: where bill_sequence_id = lCfgBillId;
1600:
1601: lCnt := sql%rowcount;
1602: IF PG_DEBUG <> 0 THEN
1603: oe_debug_pub.add('Deleted from bmi, rows::'||lCnt);
1604: END IF;
1605:
1606: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_ROUTING_ERROR');
1607: raise fnd_api.g_exc_error;

Line 1624: oe_debug_pub.add('create_in_src_orgs: '

1620: lXMessageName,
1621: lXTableName);
1622:
1623: IF PG_DEBUG <> 0 THEN
1624: oe_debug_pub.add('create_in_src_orgs: '
1625: || 'Returned from Create_bom with status: '
1626: || to_char(lStatus), 1);
1627: END IF;
1628:

Line 1632: oe_debug_pub.add('create_in_src_orgs: '

1628:
1629: if (lStatus <> 1) then
1630:
1631: IF PG_DEBUG <> 0 THEN
1632: oe_debug_pub.add('create_in_src_orgs: '
1633: || ' Failed in Create_bom_data', 1);
1634: END IF;
1635:
1636: /* Clean up bom_inventory_comps_interface */

Line 1642: oe_debug_pub.add('Deleted from bici, rows::'||lCnt);

1638: where bill_sequence_id = lCfgBillId;
1639:
1640: lCnt := sql%rowcount;
1641: IF PG_DEBUG <> 0 THEN
1642: oe_debug_pub.add('Deleted from bici, rows::'||lCnt);
1643: END IF;
1644:
1645: --Bugfix 11056452
1646: delete from bom_bill_of_mtls_interface

Line 1651: oe_debug_pub.add('Deleted from bmi, rows::'||lCnt);

1647: where bill_sequence_id = lCfgBillId;
1648:
1649: lCnt := sql%rowcount;
1650: IF PG_DEBUG <> 0 THEN
1651: oe_debug_pub.add('Deleted from bmi, rows::'||lCnt);
1652: END IF;
1653:
1654: if( lXMessageName is not null ) then
1655: xMsgData := lXMessageName ;

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

1661:
1662:
1663:
1664: IF PG_DEBUG <> 0 THEN
1665: oe_debug_pub.add('added club_comp_error ' , 1) ;
1666: end if ;
1667:
1668: raise fnd_api.g_exc_error;
1669:

Line 1680: oe_debug_pub.add('create_in_src_orgs: '

1676:
1677: else
1678: -- Added by Renga Kannan to handle the exception
1679: IF PG_DEBUG <> 0 THEN
1680: oe_debug_pub.add('create_in_src_orgs: '
1681: || 'There is no bill for this model in this org',1);
1682:
1683: oe_debug_pub.add('create_in_src_orgs: '
1684: || 'Model id :'||to_char(pModelId),1);

Line 1683: oe_debug_pub.add('create_in_src_orgs: '

1679: IF PG_DEBUG <> 0 THEN
1680: oe_debug_pub.add('create_in_src_orgs: '
1681: || 'There is no bill for this model in this org',1);
1682:
1683: oe_debug_pub.add('create_in_src_orgs: '
1684: || 'Model id :'||to_char(pModelId),1);
1685: oe_debug_pub.add('Org id ;'||to_char(lNextRec.organization_id),1);
1686: END IF;
1687:

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

1681: || 'There is no bill for this model in this org',1);
1682:
1683: oe_debug_pub.add('create_in_src_orgs: '
1684: || 'Model id :'||to_char(pModelId),1);
1685: oe_debug_pub.add('Org id ;'||to_char(lNextRec.organization_id),1);
1686: END IF;
1687:
1688: /*
1689:

Line 1728: oe_debug_pub.add('create_in_src_orgs: '

1724:
1725: else /* create_config_bom = 'N' */
1726:
1727: IF PG_DEBUG <> 0 THEN
1728: oe_debug_pub.add('create_in_src_orgs: '
1729: || 'create_config_bom parameter is set to N in this org',1);
1730:
1731: oe_debug_pub.add('create_in_src_orgs: '
1732: || 'Model id :'||to_char(pModelId),1);

Line 1731: oe_debug_pub.add('create_in_src_orgs: '

1727: IF PG_DEBUG <> 0 THEN
1728: oe_debug_pub.add('create_in_src_orgs: '
1729: || 'create_config_bom parameter is set to N in this org',1);
1730:
1731: oe_debug_pub.add('create_in_src_orgs: '
1732: || 'Model id :'||to_char(pModelId),1);
1733: oe_debug_pub.add('Org id ;'||to_char(lNextRec.organization_id),1);
1734: END IF;
1735:

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

1729: || 'create_config_bom parameter is set to N in this org',1);
1730:
1731: oe_debug_pub.add('create_in_src_orgs: '
1732: || 'Model id :'||to_char(pModelId),1);
1733: oe_debug_pub.add('Org id ;'||to_char(lNextRec.organization_id),1);
1734: END IF;
1735:
1736: -- bugfix 2294708: Replaced msg CTO_CREATE_BOM_ERROR with more specific
1737: -- error CTO_BOM_NOT_DEFINED.

Line 1777: oe_debug_pub.add('create_in_src_orgs: '

1773: EXCEPTION
1774:
1775: WHEN fnd_api.g_exc_error THEN
1776: IF PG_DEBUG <> 0 THEN
1777: oe_debug_pub.add('create_in_src_orgs: '
1778: || 'expected error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1779: END IF;
1780:
1781: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

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

1789: , p_msg_data => xMsgData
1790: );
1791:
1792: IF PG_DEBUG <> 0 THEN
1793: oe_debug_pub.add('create_in_src_orgs: ' || xMsgData , 1 ) ;
1794: oe_debug_pub.add('create_in_src_orgs: ' || xMsgCount , 1 ) ;
1795:
1796: END IF;
1797:

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

1790: );
1791:
1792: IF PG_DEBUG <> 0 THEN
1793: oe_debug_pub.add('create_in_src_orgs: ' || xMsgData , 1 ) ;
1794: oe_debug_pub.add('create_in_src_orgs: ' || xMsgCount , 1 ) ;
1795:
1796: END IF;
1797:
1798: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1812: oe_debug_pub.add('create_in_src_orgs: '

1808: );
1809:
1810: WHEN OTHERS then
1811: IF PG_DEBUG <> 0 THEN
1812: oe_debug_pub.add('create_in_src_orgs: '
1813: || 'create_in_src_orgs::others::'||to_char(lStmtNum)
1814: ||'::'||sqlerrm, 1);
1815: END IF;
1816:

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

1948: and oel1.link_to_line_id = pLineId
1949: and oel1.ordered_quantity > 0 ;
1950:
1951: IF PG_DEBUG <> 0 THEN
1952: oe_debug_pub.add('update_atp: ' || ' Line Id ' || p_atp_table.identifier(1));
1953:
1954: oe_debug_pub.add('update_atp: ' || ' Inventory Id ' || p_atp_table.inventory_item_id(1));
1955:
1956: oe_debug_pub.add('update_atp: ' || ' Req Date ' || p_atp_table.requested_ship_date(1));

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

1950:
1951: IF PG_DEBUG <> 0 THEN
1952: oe_debug_pub.add('update_atp: ' || ' Line Id ' || p_atp_table.identifier(1));
1953:
1954: oe_debug_pub.add('update_atp: ' || ' Inventory Id ' || p_atp_table.inventory_item_id(1));
1955:
1956: oe_debug_pub.add('update_atp: ' || ' Req Date ' || p_atp_table.requested_ship_date(1));
1957:
1958: oe_debug_pub.add('update_atp: ' || ' qty ' || p_atp_table.quantity_ordered(1));

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

1952: oe_debug_pub.add('update_atp: ' || ' Line Id ' || p_atp_table.identifier(1));
1953:
1954: oe_debug_pub.add('update_atp: ' || ' Inventory Id ' || p_atp_table.inventory_item_id(1));
1955:
1956: oe_debug_pub.add('update_atp: ' || ' Req Date ' || p_atp_table.requested_ship_date(1));
1957:
1958: oe_debug_pub.add('update_atp: ' || ' qty ' || p_atp_table.quantity_ordered(1));
1959: END IF;
1960:

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

1954: oe_debug_pub.add('update_atp: ' || ' Inventory Id ' || p_atp_table.inventory_item_id(1));
1955:
1956: oe_debug_pub.add('update_atp: ' || ' Req Date ' || p_atp_table.requested_ship_date(1));
1957:
1958: oe_debug_pub.add('update_atp: ' || ' qty ' || p_atp_table.quantity_ordered(1));
1959: END IF;
1960:
1961:
1962: /*--------------------------------------+

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

1985:
1986: if i is not null then
1987:
1988: IF PG_DEBUG <> 0 THEN
1989: oe_debug_pub.add('update_atp: ' || 'From output record ---> ',1);
1990: END IF;
1991:
1992: while i is not null
1993: loop

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

1992: while i is not null
1993: loop
1994:
1995: IF PG_DEBUG <> 0 THEN
1996: oe_debug_pub.add('update_atp: ' || ' Line Id '
1997: || l_smc_table.identifier(i));
1998:
1999: oe_debug_pub.add('update_atp: ' || ' Inventory Id '
2000: || l_smc_table.inventory_item_id(i));

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

1995: IF PG_DEBUG <> 0 THEN
1996: oe_debug_pub.add('update_atp: ' || ' Line Id '
1997: || l_smc_table.identifier(i));
1998:
1999: oe_debug_pub.add('update_atp: ' || ' Inventory Id '
2000: || l_smc_table.inventory_item_id(i));
2001:
2002: oe_debug_pub.add('update_atp: ' || ' Req Date '
2003: || l_smc_table.requested_ship_date(i));

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

1998:
1999: oe_debug_pub.add('update_atp: ' || ' Inventory Id '
2000: || l_smc_table.inventory_item_id(i));
2001:
2002: oe_debug_pub.add('update_atp: ' || ' Req Date '
2003: || l_smc_table.requested_ship_date(i));
2004:
2005: oe_debug_pub.add('update_atp: ' || ' qty '
2006: || l_smc_table.quantity_ordered(i));

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

2001:
2002: oe_debug_pub.add('update_atp: ' || ' Req Date '
2003: || l_smc_table.requested_ship_date(i));
2004:
2005: oe_debug_pub.add('update_atp: ' || ' qty '
2006: || l_smc_table.quantity_ordered(i));
2007: END IF;
2008:
2009: i := l_smc_table.inventory_item_id.NEXT(i);

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

2009: i := l_smc_table.inventory_item_id.NEXT(i);
2010: end loop;
2011:
2012: IF PG_DEBUG <> 0 THEN
2013: oe_debug_pub.add('update_atp: ' || 'Calling ATP ---> ',1);
2014: END IF;
2015:
2016: /*----------------------------+
2017: Call ATP

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

2028: l_msg_data,
2029: l_msg_count);
2030:
2031: IF PG_DEBUG <> 0 THEN
2032: oe_debug_pub.add('update_atp: ' || 'ATP returned ' || l_return_status);
2033: END IF;
2034:
2035: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2036: or l_return_status = FND_API.G_RET_STS_ERROR ) then

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

2037: raise atp_error;
2038: END IF;
2039: else
2040: IF PG_DEBUG <> 0 THEN
2041: oe_debug_pub.add('update_atp: ' || 'No Mandatory components for ATP found' );
2042: END IF;
2043:
2044: end if;
2045:

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

2125: -- fnd_message.Set_Name('BOM', 'CST_ITEM_USED_IN_TXN');
2126: RetVal := TRUE;
2127: ELSE
2128: IF PG_DEBUG <> 0 THEN
2129: oe_debug_pub.add( ' is_item_transacted is null -> true ' ) ;
2130: END IF;
2131:
2132: RetVal := FALSE ;
2133: END IF;

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

2133: END IF;
2134:
2135: ELSE
2136: IF PG_DEBUG <> 0 THEN
2137: oe_debug_pub.add( ' cost type id not 1 ' ) ;
2138: END IF;
2139:
2140: RetVal := FALSE ;
2141: END IF;

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

2142:
2143: IF PG_DEBUG <> 0 THEN
2144:
2145: if( RetVal = TRUE ) then
2146: oe_debug_pub.add( ' is_item_transacted is true ' ) ;
2147: elsif( RetVal = False ) then
2148: oe_debug_pub.add( ' is_item_transacted is false' ) ;
2149: elsif( RetVal is null ) then
2150: oe_debug_pub.add( ' is_item_transacted is null ' ) ;

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

2144:
2145: if( RetVal = TRUE ) then
2146: oe_debug_pub.add( ' is_item_transacted is true ' ) ;
2147: elsif( RetVal = False ) then
2148: oe_debug_pub.add( ' is_item_transacted is false' ) ;
2149: elsif( RetVal is null ) then
2150: oe_debug_pub.add( ' is_item_transacted is null ' ) ;
2151: end if ;
2152: END IF;

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

2146: oe_debug_pub.add( ' is_item_transacted is true ' ) ;
2147: elsif( RetVal = False ) then
2148: oe_debug_pub.add( ' is_item_transacted is false' ) ;
2149: elsif( RetVal is null ) then
2150: oe_debug_pub.add( ' is_item_transacted is null ' ) ;
2151: end if ;
2152: END IF;
2153:
2154:

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

2229: -- check if model bom exists in src org
2230:
2231: lStmtNum := 10;
2232: IF PG_DEBUG <> 0 THEN
2233: oe_debug_pub.add('create_in_src_orgs: ' || 'In create_in_src_orgs. Item: ' ||
2234: to_char(pConfigId) || '. Costing Org ' || -- 3116778
2235: to_char(p_cost_organization_id) || '. Source Org ' || -- 3116778
2236: to_char(p_organization_id), 1);
2237: END IF;

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

2301: from cst_cost_types
2302: where cost_type = lBuyCostType ;
2303:
2304: IF PG_DEBUG <> 0 THEN
2305: oe_debug_pub.add('Buy Cost Type id ::'|| v_buy_cost_type_id , 2);
2306: END IF;
2307:
2308: exception
2309: when no_data_found then

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

2321: else
2322: v_buy_cost_type_id := v_cto_cost_type_id ;
2323:
2324: IF PG_DEBUG <> 0 THEN
2325: oe_debug_pub.add('defaulting buy cost = cto cost ' , 2);
2326: END IF;
2327:
2328: end if ;
2329:

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

2344: and rollup_source_type = 3 ; -- bugfix 2808704
2345:
2346:
2347: IF PG_DEBUG <> 0 THEN
2348: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2349: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2350: END IF;
2351:
2352:

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

2345:
2346:
2347: IF PG_DEBUG <> 0 THEN
2348: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2349: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2350: END IF;
2351:
2352:
2353: exception

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

2414:
2415:
2416:
2417: IF PG_DEBUG <> 0 THEN
2418: oe_debug_pub.add('going for stmt 40 ' || pConfigId
2419: || ' org ' || p_organization_id
2420: || ' cost org ' || p_cost_organization_id -- 3116778
2421: || ' pri ' || v_primary_cost_method
2422: || ' buy ' || v_buy_cost_type_id

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

2438:
2439:
2440:
2441: IF PG_DEBUG <> 0 THEN
2442: oe_debug_pub.add('v_buy_cost ' || v_buy_cost , 1);
2443: oe_debug_pub.add('org ' || p_organization_id , 1);
2444: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2445: oe_debug_pub.add('cost id ' || v_buy_cost_type_id, 1);
2446: END IF;

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

2439:
2440:
2441: IF PG_DEBUG <> 0 THEN
2442: oe_debug_pub.add('v_buy_cost ' || v_buy_cost , 1);
2443: oe_debug_pub.add('org ' || p_organization_id , 1);
2444: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2445: oe_debug_pub.add('cost id ' || v_buy_cost_type_id, 1);
2446: END IF;
2447:

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

2440:
2441: IF PG_DEBUG <> 0 THEN
2442: oe_debug_pub.add('v_buy_cost ' || v_buy_cost , 1);
2443: oe_debug_pub.add('org ' || p_organization_id , 1);
2444: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2445: oe_debug_pub.add('cost id ' || v_buy_cost_type_id, 1);
2446: END IF;
2447:
2448: exception

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

2441: IF PG_DEBUG <> 0 THEN
2442: oe_debug_pub.add('v_buy_cost ' || v_buy_cost , 1);
2443: oe_debug_pub.add('org ' || p_organization_id , 1);
2444: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2445: oe_debug_pub.add('cost id ' || v_buy_cost_type_id, 1);
2446: END IF;
2447:
2448: exception
2449: when no_data_found then

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

2450:
2451: v_buy_cost := null ;
2452:
2453: IF PG_DEBUG <> 0 THEN
2454: oe_debug_pub.add('v_buy_cost null ' , 1);
2455: oe_debug_pub.add('org ' || p_organization_id , 1);
2456: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2457: END IF;
2458:

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

2451: v_buy_cost := null ;
2452:
2453: IF PG_DEBUG <> 0 THEN
2454: oe_debug_pub.add('v_buy_cost null ' , 1);
2455: oe_debug_pub.add('org ' || p_organization_id , 1);
2456: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2457: END IF;
2458:
2459: when others then

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

2452:
2453: IF PG_DEBUG <> 0 THEN
2454: oe_debug_pub.add('v_buy_cost null ' , 1);
2455: oe_debug_pub.add('org ' || p_organization_id , 1);
2456: oe_debug_pub.add('cost org ' || p_cost_organization_id , 1); -- 3116778
2457: END IF;
2458:
2459: when others then
2460:

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

2465:
2466: else
2467:
2468: IF PG_DEBUG <> 0 THEN
2469: oe_debug_pub.add('v_buy_cost null as buy cost profile is not set ' , 1);
2470: END IF;
2471:
2472: v_buy_cost := null ;
2473:

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

2475:
2476:
2477:
2478: IF PG_DEBUG <> 0 THEN
2479: oe_debug_pub.add('going for stmt 45 ' , 1);
2480: END IF;
2481:
2482:
2483: lStmtNum := 45;

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

2482:
2483: lStmtNum := 45;
2484:
2485: IF PG_DEBUG <> 0 THEN
2486: oe_debug_pub.add('line ' || pLineId , 1);
2487: END IF;
2488:
2489:
2490:

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

2504:
2505: exception
2506: when too_many_rows then -- added for bug 3877317
2507: IF PG_DEBUG <> 0 THEN
2508: oe_debug_pub.add('others ' || SQLERRM , 1);
2509: oe_debug_pub.add('going to check whether make organization for too_many_rows ' , 1);
2510: END IF;
2511:
2512: /*

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

2505: exception
2506: when too_many_rows then -- added for bug 3877317
2507: IF PG_DEBUG <> 0 THEN
2508: oe_debug_pub.add('others ' || SQLERRM , 1);
2509: oe_debug_pub.add('going to check whether make organization for too_many_rows ' , 1);
2510: END IF;
2511:
2512: /*
2513: BUG 3877317

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

2527: and organization_type = '2'
2528: and cost_rollup = 'Y' ;
2529:
2530: IF PG_DEBUG <> 0 THEN
2531: oe_debug_pub.add( p_organization_id || ' is make organization ' , 1);
2532: END IF;
2533: exception
2534: when no_data_found then
2535: v_organization_type := 1 ;

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

2540:
2541:
2542: when others then
2543: IF PG_DEBUG <> 0 THEN
2544: oe_debug_pub.add('others ' || SQLERRM , 1);
2545: oe_debug_pub.add('defaulting organization type = 4 ' , 1);
2546: END IF;
2547:
2548: v_organization_type := 4 ;

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

2541:
2542: when others then
2543: IF PG_DEBUG <> 0 THEN
2544: oe_debug_pub.add('others ' || SQLERRM , 1);
2545: oe_debug_pub.add('defaulting organization type = 4 ' , 1);
2546: END IF;
2547:
2548: v_organization_type := 4 ;
2549: /* cost rollup is 'N' for child models of drop ship or buy */

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

2556:
2557:
2558:
2559: IF PG_DEBUG <> 0 THEN
2560: oe_debug_pub.add('organization_type ' || v_organization_type , 1);
2561:
2562: oe_debug_pub.add('valuation cost ' || v_valuation_cost , 1);
2563: oe_debug_pub.add('primary cost method ' || v_primary_cost_method , 1);
2564: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;

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

2558:
2559: IF PG_DEBUG <> 0 THEN
2560: oe_debug_pub.add('organization_type ' || v_organization_type , 1);
2561:
2562: oe_debug_pub.add('valuation cost ' || v_valuation_cost , 1);
2563: oe_debug_pub.add('primary cost method ' || v_primary_cost_method , 1);
2564: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2565: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2566: oe_debug_pub.add('buy cost ' || v_buy_cost ) ;

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

2559: IF PG_DEBUG <> 0 THEN
2560: oe_debug_pub.add('organization_type ' || v_organization_type , 1);
2561:
2562: oe_debug_pub.add('valuation cost ' || v_valuation_cost , 1);
2563: oe_debug_pub.add('primary cost method ' || v_primary_cost_method , 1);
2564: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2565: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2566: oe_debug_pub.add('buy cost ' || v_buy_cost ) ;
2567:

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

2560: oe_debug_pub.add('organization_type ' || v_organization_type , 1);
2561:
2562: oe_debug_pub.add('valuation cost ' || v_valuation_cost , 1);
2563: oe_debug_pub.add('primary cost method ' || v_primary_cost_method , 1);
2564: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2565: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2566: oe_debug_pub.add('buy cost ' || v_buy_cost ) ;
2567:
2568:

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

2561:
2562: oe_debug_pub.add('valuation cost ' || v_valuation_cost , 1);
2563: oe_debug_pub.add('primary cost method ' || v_primary_cost_method , 1);
2564: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2565: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2566: oe_debug_pub.add('buy cost ' || v_buy_cost ) ;
2567:
2568:
2569: oe_debug_pub.add('going for stmt 50 ' , 1);

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

2562: oe_debug_pub.add('valuation cost ' || v_valuation_cost , 1);
2563: oe_debug_pub.add('primary cost method ' || v_primary_cost_method , 1);
2564: oe_debug_pub.add('cto cost ' || v_cto_cost ) ;
2565: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2566: oe_debug_pub.add('buy cost ' || v_buy_cost ) ;
2567:
2568:
2569: oe_debug_pub.add('going for stmt 50 ' , 1);
2570: END IF;

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

2565: oe_debug_pub.add('cto cost xudc ' || v_cto_cost_xudc ) ;
2566: oe_debug_pub.add('buy cost ' || v_buy_cost ) ;
2567:
2568:
2569: oe_debug_pub.add('going for stmt 50 ' , 1);
2570: END IF;
2571:
2572:
2573: lStmtNum := 50;

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

2590:
2591: if( v_item_transacted ) then
2592:
2593: IF PG_DEBUG <> 0 THEN
2594: oe_debug_pub.add( ' came into item transacted ' , 1 ) ;
2595: END IF;
2596:
2597: if( v_valuation_cost <> v_cto_cost or v_cto_cost is null ) then
2598:

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

2596:
2597: if( v_valuation_cost <> v_cto_cost or v_cto_cost is null ) then
2598:
2599: IF PG_DEBUG <> 0 THEN
2600: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2601: v_primary_cost_method , 1 ) ;
2602: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2603: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2604: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;

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

2598:
2599: IF PG_DEBUG <> 0 THEN
2600: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2601: v_primary_cost_method , 1 ) ;
2602: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2603: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2604: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2605: oe_debug_pub.add( 'cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2606:

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

2599: IF PG_DEBUG <> 0 THEN
2600: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2601: v_primary_cost_method , 1 ) ;
2602: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2603: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2604: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2605: oe_debug_pub.add( 'cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2606:
2607: END IF;

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

2600: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2601: v_primary_cost_method , 1 ) ;
2602: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2603: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2604: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2605: oe_debug_pub.add( 'cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2606:
2607: END IF;
2608:

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

2601: v_primary_cost_method , 1 ) ;
2602: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2603: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2604: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2605: oe_debug_pub.add( 'cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2606:
2607: END IF;
2608:
2609:

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

2618:
2619: else
2620:
2621: IF PG_DEBUG <> 0 THEN
2622: oe_debug_pub.add( ' cto cost is same as valuation cost no need to synch up ' , 1 ) ;
2623: END IF;
2624:
2625: end if ;
2626:

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

2634: and organization_id = p_organization_id ;
2635:
2636:
2637: IF PG_DEBUG <> 0 THEN
2638: oe_debug_pub.add( ' updated bcso cost rollup N for line ' || pLineId
2639: || ' org ' || p_organization_id
2640: || ' count ' || to_char(sql%rowcount)
2641: , 1 ) ;
2642: END IF;

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

2650: and organization_id = p_organization_id ;
2651:
2652:
2653: IF PG_DEBUG <> 0 THEN
2654: oe_debug_pub.add( ' updated bcmo cost rollup N for group_ref ' || p_group_reference_id
2655: || ' org ' || p_organization_id
2656: || ' count ' || to_char(sql%rowcount)
2657: , 1 ) ;
2658: END IF;

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

2662: end if ;
2663:
2664:
2665: IF PG_DEBUG <> 0 THEN
2666: oe_debug_pub.add( ' going to indicate no cost rollup due to transacted condition 1 '
2667: , 1 ) ;
2668: END IF;
2669:
2670:

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

2679:
2680: if( v_organization_type = '2' ) then /* make */
2681:
2682: IF PG_DEBUG <> 0 THEN
2683: oe_debug_pub.add( ' came into make organization type ' , 1 ) ;
2684: END IF;
2685:
2686: if( v_rolledup_cost_count > 0 and
2687: ( v_rolledup_cost <> v_buy_cost or v_buy_cost is null ) ) then

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

2691:
2692: if( v_valuation_cost <> v_cto_cost or v_cto_cost is null ) then
2693:
2694: IF PG_DEBUG <> 0 THEN
2695: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2696: v_primary_cost_method , 1 ) ;
2697: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2698: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2699: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;

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

2693:
2694: IF PG_DEBUG <> 0 THEN
2695: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2696: v_primary_cost_method , 1 ) ;
2697: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2698: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2699: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2700: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2701: END IF;

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

2694: IF PG_DEBUG <> 0 THEN
2695: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2696: v_primary_cost_method , 1 ) ;
2697: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2698: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2699: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2700: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2701: END IF;
2702:

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

2695: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2696: v_primary_cost_method , 1 ) ;
2697: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2698: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2699: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2700: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2701: END IF;
2702:
2703:

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

2696: v_primary_cost_method , 1 ) ;
2697: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2698: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2699: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2700: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2701: END IF;
2702:
2703:
2704: /* copy_valuation_cost_to_cto_cost() ; */

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

2712:
2713: else
2714:
2715: IF PG_DEBUG <> 0 THEN
2716: oe_debug_pub.add( ' cto cost is same as valuation cost no need to synch up ' , 1 ) ;
2717: END IF;
2718:
2719: end if ;
2720:

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

2726: where line_id = pLineId
2727: and organization_id = p_organization_id ;
2728:
2729: IF PG_DEBUG <> 0 THEN
2730: oe_debug_pub.add( ' updated bcso cost rollup N for line ' || pLineId
2731: || ' org ' || p_organization_id
2732: || ' count ' || to_char(sql%rowcount)
2733: , 1 ) ;
2734: END IF;

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

2740: where group_reference_id = p_group_reference_id
2741: and organization_id = p_organization_id ;
2742:
2743: IF PG_DEBUG <> 0 THEN
2744: oe_debug_pub.add( ' updated bcmo cost rollup N for group_ref ' || p_group_reference_id
2745: || ' org ' || p_organization_id
2746: || ' count ' || to_char(sql%rowcount)
2747: , 1 ) ;
2748:

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

2751:
2752: end if ;
2753:
2754: IF PG_DEBUG <> 0 THEN
2755: oe_debug_pub.add( ' going to indicate no cost rollup due to std make condition 1 '
2756: , 1 ) ;
2757: END IF;
2758:
2759:

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

2764:
2765: elsif( v_organization_type in ( '3', '5')) then /* buy, dropship */
2766:
2767: IF PG_DEBUG <> 0 THEN
2768: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2769: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2770: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2771: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2772: END IF ;

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

2765: elsif( v_organization_type in ( '3', '5')) then /* buy, dropship */
2766:
2767: IF PG_DEBUG <> 0 THEN
2768: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2769: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2770: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2771: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2772: END IF ;
2773:

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

2766:
2767: IF PG_DEBUG <> 0 THEN
2768: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2769: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2770: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2771: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2772: END IF ;
2773:
2774:

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

2767: IF PG_DEBUG <> 0 THEN
2768: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2769: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2770: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2771: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2772: END IF ;
2773:
2774:
2775: end if ; /* costing for matched items logic */

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

2789:
2790:
2791: if( v_valuation_cost <> v_cto_cost or v_cto_cost is null ) then
2792: IF PG_DEBUG <> 0 THEN
2793: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2794: v_primary_cost_method , 1 ) ;
2795: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2796: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2797: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;

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

2791: if( v_valuation_cost <> v_cto_cost or v_cto_cost is null ) then
2792: IF PG_DEBUG <> 0 THEN
2793: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2794: v_primary_cost_method , 1 ) ;
2795: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2796: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2797: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2798: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2799: END IF;

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

2792: IF PG_DEBUG <> 0 THEN
2793: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2794: v_primary_cost_method , 1 ) ;
2795: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2796: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2797: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2798: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2799: END IF;
2800:

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

2793: oe_debug_pub.add( ' going to copy cost valuation cost ' ||
2794: v_primary_cost_method , 1 ) ;
2795: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2796: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2797: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2798: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2799: END IF;
2800:
2801:

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

2794: v_primary_cost_method , 1 ) ;
2795: oe_debug_pub.add( ' cto cost ' || v_cto_cost_type_id , 1 ) ;
2796: oe_debug_pub.add( ' config id ' || pConfigId , 1 ) ;
2797: oe_debug_pub.add( ' organization id ' || p_organization_id , 1 ) ;
2798: oe_debug_pub.add( ' cost organization id ' || p_cost_organization_id , 1 ) ; -- 3116778
2799: END IF;
2800:
2801:
2802: /* copy_valuation_cost_to_cto_cost() ; */

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

2809:
2810: else
2811:
2812: IF PG_DEBUG <> 0 THEN
2813: oe_debug_pub.add( ' cto cost is same as valuation cost no need to synch up ' , 1 ) ;
2814: END IF;
2815:
2816: end if ;
2817:

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

2827: where line_id = pLineId
2828: and organization_id = p_organization_id ;
2829:
2830: IF PG_DEBUG <> 0 THEN
2831: oe_debug_pub.add( ' updated bcso cost rollup N for line ' || pLineId
2832: || ' org ' || p_organization_id
2833: || ' count ' || to_char(sql%rowcount)
2834: , 1 ) ;
2835: END IF;

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

2841: where group_reference_id = p_group_reference_id
2842: and organization_id = p_organization_id ;
2843:
2844: IF PG_DEBUG <> 0 THEN
2845: oe_debug_pub.add( ' updated bcmo cost rollup N for group_ref ' || p_group_reference_id
2846: || ' org ' || p_organization_id
2847: || ' count ' || to_char(sql%rowcount)
2848: , 1 ) ;
2849:

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

2854: end if ;
2855:
2856:
2857: IF PG_DEBUG <> 0 THEN
2858: oe_debug_pub.add( ' going to indicate no cost rollup due to avg make condition 1 '
2859: , 1 ) ;
2860: END IF;
2861:
2862:

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

2881: where line_id = pLineId
2882: and organization_id = p_organization_id ;
2883:
2884: IF PG_DEBUG <> 0 THEN
2885: oe_debug_pub.add( ' updated bcso cost rollup N for line ' || pLineId
2886: || ' org ' || p_organization_id
2887: || ' count ' || to_char(sql%rowcount)
2888: , 1 ) ;
2889: END IF;

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

2895: where group_reference_id = p_group_reference_id
2896: and organization_id = p_organization_id ;
2897:
2898: IF PG_DEBUG <> 0 THEN
2899: oe_debug_pub.add( ' updated bcmo cost rollup N for group_ref ' || p_group_reference_id
2900: || ' org ' || p_organization_id
2901: || ' count ' || to_char(sql%rowcount)
2902: , 1 ) ;
2903:

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

2908: end if ;
2909:
2910:
2911: IF PG_DEBUG <> 0 THEN
2912: oe_debug_pub.add( ' going to indicate no cost rollup due to avg make condition 2 '
2913: , 1 ) ;
2914: END IF;
2915:
2916:

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

2919:
2920: elsif( v_organization_type in ( '3', '5')) then /* buy, dropship */
2921:
2922: IF PG_DEBUG <> 0 THEN
2923: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2924: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2925: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2926: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2927: END IF ;

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

2920: elsif( v_organization_type in ( '3', '5')) then /* buy, dropship */
2921:
2922: IF PG_DEBUG <> 0 THEN
2923: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2924: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2925: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2926: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2927: END IF ;
2928:

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

2921:
2922: IF PG_DEBUG <> 0 THEN
2923: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2924: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2925: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2926: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2927: END IF ;
2928:
2929:

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

2922: IF PG_DEBUG <> 0 THEN
2923: oe_debug_pub.add( ' came into buy organization type ' , 1 ) ;
2924: oe_debug_pub.add( ' cto ' || v_cto_cost , 1 ) ;
2925: oe_debug_pub.add( ' cto xudc ' || v_cto_cost_xudc , 1 ) ;
2926: oe_debug_pub.add( ' cto buy ' || v_buy_cost , 1 ) ;
2927: END IF ;
2928:
2929:
2930: end if ; /* costing for make or buy logic */

Line 2957: oe_debug_pub.add('create_in_src_orgs: '

2953:
2954: Exception
2955: WHEN fnd_api.g_exc_error THEN
2956: IF PG_DEBUG <> 0 THEN
2957: oe_debug_pub.add('create_in_src_orgs: '
2958: || 'expected error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2959: END IF;
2960:
2961: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

Line 2986: oe_debug_pub.add('create_in_src_orgs: '

2982: );
2983:
2984: WHEN OTHERS then
2985: IF PG_DEBUG <> 0 THEN
2986: oe_debug_pub.add('create_in_src_orgs: '
2987: || 'create_in_src_orgs::others::'||to_char(lStmtNum)
2988: ||'::'||sqlerrm, 1);
2989: END IF;
2990: