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

Line 258: oe_debug_pub.add('MATCH_CONFIG: ' || l_match_profile, 1);

254: l_match_profile := FND_PROFILE.Value('BOM:MATCH_CONFIG');
255: l_custom_match_profile := FND_PROFILE.Value('BOM:CUSTOM_MATCH');
256:
257: IF PG_DEBUG <> 0 THEN
258: oe_debug_pub.add('MATCH_CONFIG: ' || l_match_profile, 1);
259: oe_debug_pub.add('CUSTOM_MATCH: ' || l_custom_match_profile, 1);
260: END IF;
261:
262:

Line 259: oe_debug_pub.add('CUSTOM_MATCH: ' || l_custom_match_profile, 1);

255: l_custom_match_profile := FND_PROFILE.Value('BOM:CUSTOM_MATCH');
256:
257: IF PG_DEBUG <> 0 THEN
258: oe_debug_pub.add('MATCH_CONFIG: ' || l_match_profile, 1);
259: oe_debug_pub.add('CUSTOM_MATCH: ' || l_custom_match_profile, 1);
260: END IF;
261:
262:
263: --

Line 272: oe_debug_pub.add('Config Line Already Exists.', 1);

268: l_config_line_id,
269: l_x_config_id) = TRUE)
270: then
271: IF PG_DEBUG <> 0 THEN
272: oe_debug_pub.add('Config Line Already Exists.', 1);
273: END IF;
274:
275: x_message_name := 'CTO_CONFIG_ITEM_EXISTS';
276: return FALSE;

Line 300: oe_debug_pub.add('Top Model Line Id: ' || to_char(l_top_model_line_id));

296: from oe_order_lines_all
297: where line_id = p_model_line_id;
298:
299: IF PG_DEBUG <> 0 THEN
300: oe_debug_pub.add('Top Model Line Id: ' || to_char(l_top_model_line_id));
301: END IF;
302:
303:
304: l_stmt_num := 102;

Line 307: oe_debug_pub.add('Before populate_bcol.', 1);

303:
304: l_stmt_num := 102;
305:
306: IF PG_DEBUG <> 0 THEN
307: oe_debug_pub.add('Before populate_bcol.', 1);
308: END IF;
309:
310: delete from bom_cto_order_lines where ato_line_id = p_model_line_id ;
311:

Line 313: oe_debug_pub.add('CTOMCRSB: deleted bcol: ' || to_char(SQL%ROWCOUNT));

309:
310: delete from bom_cto_order_lines where ato_line_id = p_model_line_id ;
311:
312: IF PG_DEBUG <> 0 THEN
313: oe_debug_pub.add('CTOMCRSB: deleted bcol: ' || to_char(SQL%ROWCOUNT));
314: END IF;
315:
316: delete from bom_cto_src_orgs_b where top_model_line_id = p_model_line_id ;
317:

Line 319: oe_debug_pub.add('CTOMCRSB: deleted bcso_b : ' || to_char(SQL%ROWCOUNT));

315:
316: delete from bom_cto_src_orgs_b where top_model_line_id = p_model_line_id ;
317:
318: IF PG_DEBUG <> 0 THEN
319: oe_debug_pub.add('CTOMCRSB: deleted bcso_b : ' || to_char(SQL%ROWCOUNT));
320: END IF;
321:
322:
323:

Line 331: oe_debug_pub.add ('Failed in populate_bcol with expected error.', 1);

327: x_msg_data => X_Msg_Data);
328:
329: if x_return_status = FND_API.G_RET_STS_ERROR then
330: IF PG_DEBUG <> 0 THEN
331: oe_debug_pub.add ('Failed in populate_bcol with expected error.', 1);
332: END IF;
333:
334: cto_msg_pub.cto_message('BOM','CTO_MATCH_AND_RESERVE');
335: raise FND_API.G_EXC_ERROR;

Line 339: oe_debug_pub.add ('Failed in populate_bcol with unexpected error.', 1);

335: raise FND_API.G_EXC_ERROR;
336:
337: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
338: IF PG_DEBUG <> 0 THEN
339: oe_debug_pub.add ('Failed in populate_bcol with unexpected error.', 1);
340: END IF;
341:
342: cto_msg_pub.cto_message('BOM','CTO_MATCH_AND_RESERVE');
343: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 347: oe_debug_pub.add('After populate_bcol.', 1);

343: raise FND_API.G_EXC_UNEXPECTED_ERROR;
344: end if;
345:
346: IF PG_DEBUG <> 0 THEN
347: oe_debug_pub.add('After populate_bcol.', 1);
348: END IF;
349:
350:
351: l_stmt_num := 105;

Line 365: oe_debug_pub.add('Configuration Line does not exist.', 1);

361: --
362:
363: l_stmt_num := 120;
364: IF PG_DEBUG <> 0 THEN
365: oe_debug_pub.add('Configuration Line does not exist.', 1);
366: END IF;
367:
368: CTO_WORKFLOW_API_PK.get_activity_status(
369: itemtype => 'OEOL',

Line 375: oe_debug_pub.add('Workflow Status is: ' ||

371: linetype => 'MODEL',
372: activity_name => l_active_activity);
373:
374: IF PG_DEBUG <> 0 THEN
375: oe_debug_pub.add('Workflow Status is: ' ||
376: l_active_activity, 1);
377: END IF;
378:
379:

Line 383: oe_debug_pub.add('Model Workflow Status not Eligible for MR.', 1);

379:
380: /*
381: if (l_active_activity = 'NULL') then
382: IF PG_DEBUG <> 0 THEN
383: oe_debug_pub.add('Model Workflow Status not Eligible for MR.', 1);
384: END IF;
385:
386: raise INVALID_WORKFLOW_STATUS;
387: end if;

Line 416: oe_debug_pub.add('Top Model is not Eligible for MR as match is ' || l_perform_match , 1);

412:
413:
414: if( l_perform_match = 'N' ) then
415:
416: oe_debug_pub.add('Top Model is not Eligible for MR as match is ' || l_perform_match , 1);
417: oe_debug_pub.add('Top Model is not Eligible for MR iid is ' || l_top_model_item_id , 1);
418:
419:
420: select concatenated_segments into v_model_item_name

Line 417: oe_debug_pub.add('Top Model is not Eligible for MR iid is ' || l_top_model_item_id , 1);

413:
414: if( l_perform_match = 'N' ) then
415:
416: oe_debug_pub.add('Top Model is not Eligible for MR as match is ' || l_perform_match , 1);
417: oe_debug_pub.add('Top Model is not Eligible for MR iid is ' || l_top_model_item_id , 1);
418:
419:
420: select concatenated_segments into v_model_item_name
421: from mtl_system_items_kfv

Line 425: oe_debug_pub.add('Top Model is not Eligible for MR name is ' || v_model_item_name , 1);

421: from mtl_system_items_kfv
422: where inventory_item_id = l_top_model_item_id
423: and rownum = 1 ;
424:
425: oe_debug_pub.add('Top Model is not Eligible for MR name is ' || v_model_item_name , 1);
426:
427: -- l_token(1).token_name := 'MODEL_NAME' ;
428: -- l_token(1).token_value := v_model_item_name ;
429:

Line 437: oe_debug_pub.add(x_error_message,1);

433: delete from bom_cto_order_lines
434: where top_model_line_id = l_top_model_line_id;
435:
436: IF PG_DEBUG <> 0 THEN
437: oe_debug_pub.add(x_error_message,1);
438: END IF;
439:
440:
441: return TRUE ;

Line 499: oe_debug_pub.add ('match_inquiry: GOING TO CALL CTO_CONFIGURED_ITEM_GRP.match_configured_item ' , 1) ;

495: order by plan_level ;
496:
497:
498:
499: oe_debug_pub.add ('match_inquiry: GOING TO CALL CTO_CONFIGURED_ITEM_GRP.match_configured_item ' , 1) ;
500:
501: CTO_CONFIGURED_ITEM_GRP.match_configured_item (
502: p_api_version => 1.0,
503: /*

Line 518: oe_debug_pub.add ('match_inquiry: CTO_CONFIGURED_ITEM_GRP.match_configured_item done ' , 1) ;

514:
515:
516:
517:
518: oe_debug_pub.add ('match_inquiry: CTO_CONFIGURED_ITEM_GRP.match_configured_item done ' , 1) ;
519:
520: IF ( x_return_status = fnd_api.G_RET_STS_ERROR) THEN
521: IF PG_DEBUG <> 0 THEN
522: oe_debug_pub.add ('Create_Item: ' ||

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

518: oe_debug_pub.add ('match_inquiry: CTO_CONFIGURED_ITEM_GRP.match_configured_item done ' , 1) ;
519:
520: IF ( x_return_status = fnd_api.G_RET_STS_ERROR) THEN
521: IF PG_DEBUG <> 0 THEN
522: oe_debug_pub.add ('Create_Item: ' ||
523: 'CTO_CONFIGURED_ITEM_GRP.match_configured_item returned with expected error.');
524: END IF;
525: raise FND_API.G_EXC_ERROR;
526:

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

525: raise FND_API.G_EXC_ERROR;
526:
527: ELSIF ( x_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
528: IF PG_DEBUG <> 0 THEN
529: oe_debug_pub.add ('Create_Item: ' ||
530: 'CTO_CONFIGURED_ITEM_GRP.match_configured_item returned with unexp error.');
531: END IF;
532: raise FND_API.G_EXC_UNEXPECTED_ERROR;
533:

Line 572: oe_debug_pub.add(x_error_message,1);

568: delete from bom_cto_order_lines
569: where top_model_line_id = l_top_model_line_id;
570:
571: IF PG_DEBUG <> 0 THEN
572: oe_debug_pub.add(x_error_message,1);
573: END IF;
574:
575:
576:

Line 579: oe_debug_pub.add('CTOMCRSB: ' || 'Getting Profile Values ' , 1);

575:
576:
577: else
578:
579: oe_debug_pub.add('CTOMCRSB: ' || 'Getting Profile Values ' , 1);
580:
581: lPerformPPRollup := nvl( FND_PROFILE.Value('CTO_PERFORM_PURCHASE_PRICE_ROLLUP'), 1 ) ;
582: lPerformCSTRollup := nvl( FND_PROFILE.Value('CTO_PERFORM_COST_ROLLUP') , 1 ) ;
583: --Bugfix 6716677

Line 587: oe_debug_pub.add('CTOMCRSB: ' || 'Done Getting Profile Values ' , 1);

583: --Bugfix 6716677
584: --lPerformFWCalc := nvl( FND_PROFILE.Value('CTO_PERFORM_FLOW_CALC') , 1 );
585: lPerformFWCalc := nvl( FND_PROFILE.Value('CTO_PERFORM_FLOW_CALC') , 2 );
586:
587: oe_debug_pub.add('CTOMCRSB: ' || 'Done Getting Profile Values ' , 1);
588:
589: IF PG_DEBUG <> 0 THEN
590: oe_debug_pub.add('CTOMCRSB: ' || 'Profile Perform Purchase Price Rollup
591: ' || lPerformPPRollup , 1);

Line 590: oe_debug_pub.add('CTOMCRSB: ' || 'Profile Perform Purchase Price Rollup

586:
587: oe_debug_pub.add('CTOMCRSB: ' || 'Done Getting Profile Values ' , 1);
588:
589: IF PG_DEBUG <> 0 THEN
590: oe_debug_pub.add('CTOMCRSB: ' || 'Profile Perform Purchase Price Rollup
591: ' || lPerformPPRollup , 1);
592: oe_debug_pub.add('CTOMCRSB: ' || 'Profile Perform Cost Rollup ' || lPerformCSTRollup , 1);
593: oe_debug_pub.add('CTOMCRSB: ' || 'Profile Perform Flow Calculations ' || lPerformFWCalc , 1);
594: END IF;

Line 592: oe_debug_pub.add('CTOMCRSB: ' || 'Profile Perform Cost Rollup ' || lPerformCSTRollup , 1);

588:
589: IF PG_DEBUG <> 0 THEN
590: oe_debug_pub.add('CTOMCRSB: ' || 'Profile Perform Purchase Price Rollup
591: ' || lPerformPPRollup , 1);
592: oe_debug_pub.add('CTOMCRSB: ' || 'Profile Perform Cost Rollup ' || lPerformCSTRollup , 1);
593: oe_debug_pub.add('CTOMCRSB: ' || 'Profile Perform Flow Calculations ' || lPerformFWCalc , 1);
594: END IF;
595:
596:

Line 593: oe_debug_pub.add('CTOMCRSB: ' || 'Profile Perform Flow Calculations ' || lPerformFWCalc , 1);

589: IF PG_DEBUG <> 0 THEN
590: oe_debug_pub.add('CTOMCRSB: ' || 'Profile Perform Purchase Price Rollup
591: ' || lPerformPPRollup , 1);
592: oe_debug_pub.add('CTOMCRSB: ' || 'Profile Perform Cost Rollup ' || lPerformCSTRollup , 1);
593: oe_debug_pub.add('CTOMCRSB: ' || 'Profile Perform Flow Calculations ' || lPerformFWCalc , 1);
594: END IF;
595:
596:
597:

Line 602: oe_debug_pub.add('CTOMCSRB: ' || 'Flow Calc is 1 ' , 1);

598:
599:
600: if( lPerformFWCalc = 1 ) then
601: l_perform_flow_calc := 1;
602: oe_debug_pub.add('CTOMCSRB: ' || 'Flow Calc is 1 ' , 1);
603: else
604: --Begin Bugfix 6716677
605: if( lPerformFWCalc = 2 ) then
606: l_perform_flow_calc := 2;

Line 607: oe_debug_pub.add('CTOMCRSB: ' || 'Flow Calc is 2 ' , 1);

603: else
604: --Begin Bugfix 6716677
605: if( lPerformFWCalc = 2 ) then
606: l_perform_flow_calc := 2;
607: oe_debug_pub.add('CTOMCRSB: ' || 'Flow Calc is 2 ' , 1);
608: else
609: l_perform_flow_calc := 3;
610: oe_debug_pub.add('CTOMCRSB: ' || 'Flow Calc is 3 ' , 1);
611: end if;

Line 610: oe_debug_pub.add('CTOMCRSB: ' || 'Flow Calc is 3 ' , 1);

606: l_perform_flow_calc := 2;
607: oe_debug_pub.add('CTOMCRSB: ' || 'Flow Calc is 2 ' , 1);
608: else
609: l_perform_flow_calc := 3;
610: oe_debug_pub.add('CTOMCRSB: ' || 'Flow Calc is 3 ' , 1);
611: end if;
612: --End Bugfix 6716677
613: end if ;
614:

Line 618: oe_debug_pub.add('Before Populate_Src_Orgs');

614:
615:
616: -- populate bom_cto_src_orgs to create items and boms
617: IF PG_DEBUG <> 0 THEN
618: oe_debug_pub.add('Before Populate_Src_Orgs');
619: END IF;
620:
621: l_stmt_num := 140;
622:

Line 631: oe_debug_pub.add('CTO_MSUTIL_PUB.Populate_src_orgs returned with exp error',1);

627: x_msg_data => x_msg_data);
628:
629: IF ( l_Status <> 1 and X_Return_Status = FND_API.G_RET_STS_ERROR) THEN
630: IF PG_DEBUG <> 0 THEN
631: oe_debug_pub.add('CTO_MSUTIL_PUB.Populate_src_orgs returned with exp error',1);
632: END IF;
633:
634: raise FND_API.G_EXC_ERROR;
635:

Line 638: oe_debug_pub.add('CTO_MSUTIL_PUB.Populate_src_orgs returned with unexp error',1);

634: raise FND_API.G_EXC_ERROR;
635:
636: ELSIF ( l_Status <> 1 and X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
637: IF PG_DEBUG <> 0 THEN
638: oe_debug_pub.add('CTO_MSUTIL_PUB.Populate_src_orgs returned with unexp error',1);
639: END IF;
640:
641: raise FND_API.G_EXC_UNEXPECTED_ERROR;
642:

Line 647: oe_debug_pub.add('Ater CTO_MSUTIL_PUB.Populate_Src_Orgs', 2);

643: END IF;
644:
645:
646: IF PG_DEBUG <> 0 THEN
647: oe_debug_pub.add('Ater CTO_MSUTIL_PUB.Populate_Src_Orgs', 2);
648: END IF;
649:
650:
651: -- call create_all_items, which will go through

Line 655: oe_debug_pub.add('Calling Create_All_Items');

651: -- call create_all_items, which will go through
652: -- bom_cto_order_lines and create all items in all src orgs
653:
654: IF PG_DEBUG <> 0 THEN
655: oe_debug_pub.add('Calling Create_All_Items');
656: END IF;
657:
658:
659: l_stmt_num := 145;

Line 669: oe_debug_pub.add ('Create_All_Items returned with 0', 1);

665: XMsgData => x_msg_data);
666:
667: IF (l_status <> 1 and x_Return_Status = fnd_api.g_ret_sts_error ) then
668: IF PG_DEBUG <> 0 THEN
669: oe_debug_pub.add ('Create_All_Items returned with 0', 1);
670: END IF;
671:
672:
673: --cto_msg_pub.cto_message('BOM','CTO_MATCH_AND_RESERVE');

Line 678: oe_debug_pub.add ('Create_All_Items returned with 0', 1);

674: raise FND_API.G_EXC_ERROR;
675:
676: ELSIF (l_status <> 1 and x_Return_Status = fnd_api.g_ret_sts_unexp_error ) then
677: IF PG_DEBUG <> 0 THEN
678: oe_debug_pub.add ('Create_All_Items returned with 0', 1);
679: END IF ;
680:
681:
682: --cto_msg_pub.cto_message('BOM','CTO_MATCH_AND_RESERVE');

Line 706: oe_debug_pub.add('Matching Final Assy Item is: ' ||

702: xMsgCount => x_msg_count,
703: xMsgData => x_msg_data);
704:
705: IF PG_DEBUG <> 0 THEN
706: oe_debug_pub.add('Matching Final Assy Item is: ' ||
707: to_char(l_x_config_id),1);
708: END IF;
709:
710:

Line 725: oe_debug_pub.add ('Failed in link_item function', 1);

721:
722: if (l_status <> 1) then
723:
724: IF PG_DEBUG <> 0 THEN
725: oe_debug_pub.add ('Failed in link_item function', 1);
726: END IF;
727:
728: raise PROCESS_ERROR;
729:

Line 732: oe_debug_pub.add ('Success in link_item function', 1);

728: raise PROCESS_ERROR;
729:
730: end if;
731: IF PG_DEBUG <> 0 THEN
732: oe_debug_pub.add ('Success in link_item function', 1);
733: END IF;
734:
735:
736:

Line 741: oe_debug_pub.add('Failed in call to start_model_workflow',1);

737:
738: if (CTO_WORKFLOW_API_PK.start_model_workflow(p_model_line_id) = FALSE)
739: then
740: IF PG_DEBUG <> 0 THEN
741: oe_debug_pub.add('Failed in call to start_model_workflow',1);
742: END IF;
743:
744: raise PROCESS_ERROR;
745: end if;

Line 763: oe_debug_pub.add('Calling flow status API ',1);

759: and item_type_code = 'CONFIG';
760:
761:
762: IF PG_DEBUG <> 0 THEN
763: oe_debug_pub.add('Calling flow status API ',1);
764: END IF;
765:
766:
767: /*

Line 781: oe_debug_pub.add('CTOMCRSB: ' || 'return value from display_wf_status' ||return_value ,5);

777: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(l_config_line_id);
778:
779:
780: IF PG_DEBUG <> 0 THEN
781: oe_debug_pub.add('CTOMCRSB: ' || 'return value from display_wf_status' ||return_value ,5);
782: END IF;
783:
784: if return_value <> 1 then
785: IF PG_DEBUG <> 0 THEN

Line 786: oe_debug_pub.add('CTOMCRSB: ' || 'return value from display_wf_status' ||return_value ,1);

782: END IF;
783:
784: if return_value <> 1 then
785: IF PG_DEBUG <> 0 THEN
786: oe_debug_pub.add('CTOMCRSB: ' || 'return value from display_wf_status' ||return_value ,1);
787: END IF;
788: cto_msg_pub.cto_message('CTO', 'CTO_ERROR_FROM_DISPLAY_STATUS');
789: raise FND_API.G_EXC_UNEXPECTED_ERROR;
790: end if;

Line 804: oe_debug_pub.add('Return from flow status API ' ||l_return_status,1);

800: p_flow_status_code => 'BOM_AND_RTG_CREATED',
801: x_return_status => l_return_status);
802:
803: IF PG_DEBUG <> 0 THEN
804: oe_debug_pub.add('Return from flow status API ' ||l_return_status,1);
805: END IF;
806:
807:
808: */

Line 841: oe_debug_pub.add('Failed in create_tree with status: ' ||

837: , x_tree_id => l_tree_id);
838:
839: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
840: IF PG_DEBUG <> 0 THEN
841: oe_debug_pub.add('Failed in create_tree with status: ' ||
842: l_return_status, 1);
843: END IF;
844:
845: raise PROCESS_ERROR;

Line 848: oe_debug_pub.add('Success in create_tree.',1);

844:
845: raise PROCESS_ERROR;
846: ELSE
847: IF PG_DEBUG <> 0 THEN
848: oe_debug_pub.add('Success in create_tree.',1);
849: oe_debug_pub.add('Tree ID:' || to_char(l_tree_id),1);
850: END IF;
851:
852: END IF;

Line 849: oe_debug_pub.add('Tree ID:' || to_char(l_tree_id),1);

845: raise PROCESS_ERROR;
846: ELSE
847: IF PG_DEBUG <> 0 THEN
848: oe_debug_pub.add('Success in create_tree.',1);
849: oe_debug_pub.add('Tree ID:' || to_char(l_tree_id),1);
850: END IF;
851:
852: END IF;
853:

Line 878: oe_debug_pub.add('Failed in create_tree with status: ' ||

874: x_atr => x_available_qty);
875:
876: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
877: IF PG_DEBUG <> 0 THEN
878: oe_debug_pub.add('Failed in create_tree with status: ' ||
879: l_return_status, 1);
880: END IF;
881: raise PROCESS_ERROR;
882: end if;

Line 885: oe_debug_pub.add('Success in query_tree.', 1);

881: raise PROCESS_ERROR;
882: end if;
883:
884: IF PG_DEBUG <> 0 THEN
885: oe_debug_pub.add('Success in query_tree.', 1);
886: oe_debug_pub.add('l_x_qoh: ' || to_char(l_x_qoh));
887: oe_debug_pub.add('l_x_rqoh: ' || to_char(l_x_rqoh));
888: oe_debug_pub.add('x_available_qty: ' || to_char(x_available_qty));
889: END IF;

Line 886: oe_debug_pub.add('l_x_qoh: ' || to_char(l_x_qoh));

882: end if;
883:
884: IF PG_DEBUG <> 0 THEN
885: oe_debug_pub.add('Success in query_tree.', 1);
886: oe_debug_pub.add('l_x_qoh: ' || to_char(l_x_qoh));
887: oe_debug_pub.add('l_x_rqoh: ' || to_char(l_x_rqoh));
888: oe_debug_pub.add('x_available_qty: ' || to_char(x_available_qty));
889: END IF;
890:

Line 887: oe_debug_pub.add('l_x_rqoh: ' || to_char(l_x_rqoh));

883:
884: IF PG_DEBUG <> 0 THEN
885: oe_debug_pub.add('Success in query_tree.', 1);
886: oe_debug_pub.add('l_x_qoh: ' || to_char(l_x_qoh));
887: oe_debug_pub.add('l_x_rqoh: ' || to_char(l_x_rqoh));
888: oe_debug_pub.add('x_available_qty: ' || to_char(x_available_qty));
889: END IF;
890:
891:

Line 888: oe_debug_pub.add('x_available_qty: ' || to_char(x_available_qty));

884: IF PG_DEBUG <> 0 THEN
885: oe_debug_pub.add('Success in query_tree.', 1);
886: oe_debug_pub.add('l_x_qoh: ' || to_char(l_x_qoh));
887: oe_debug_pub.add('l_x_rqoh: ' || to_char(l_x_rqoh));
888: oe_debug_pub.add('x_available_qty: ' || to_char(x_available_qty));
889: END IF;
890:
891:
892: l_stmt_num := 170;

Line 927: oe_debug_pub.add('Entering Create Reservation. ',1);

923: p_automatic_reservation = TRUE)
924: then
925: l_stmt_num := 180;
926: IF PG_DEBUG <> 0 THEN
927: oe_debug_pub.add('Entering Create Reservation. ',1);
928: oe_debug_pub.add('Quantity Available to Rsrv: '
929: || to_char(x_available_qty),1);
930: END IF;
931:

Line 928: oe_debug_pub.add('Quantity Available to Rsrv: '

924: then
925: l_stmt_num := 180;
926: IF PG_DEBUG <> 0 THEN
927: oe_debug_pub.add('Entering Create Reservation. ',1);
928: oe_debug_pub.add('Quantity Available to Rsrv: '
929: || to_char(x_available_qty),1);
930: END IF;
931:
932:

Line 942: oe_debug_pub.add('Success in Create Reservation. ',1);

938: l_x_error_msg,
939: l_x_error_msg_name) = TRUE)
940: then
941: IF PG_DEBUG <> 0 THEN
942: oe_debug_pub.add('Success in Create Reservation. ',1);
943: END IF;
944: else
945: IF PG_DEBUG <> 0 THEN
946: oe_debug_pub.add('Failed in Create Reservation. ',1);

Line 946: oe_debug_pub.add('Failed in Create Reservation. ',1);

942: oe_debug_pub.add('Success in Create Reservation. ',1);
943: END IF;
944: else
945: IF PG_DEBUG <> 0 THEN
946: oe_debug_pub.add('Failed in Create Reservation. ',1);
947: END IF;
948:
949: raise RESERVATION_ERROR;
950: end if;

Line 963: oe_debug_pub.add('Not Enough Qty to reserve. ',1);

959: +--------------------------------------------------*/
960: if (x_available_qty <= 0) then
961: l_stmt_num := 190;
962: IF PG_DEBUG <> 0 THEN
963: oe_debug_pub.add('Not Enough Qty to reserve. ',1);
964: oe_debug_pub.add('Quantity Available to Rsrv: '
965: || to_char(x_available_qty),1);
966: END IF;
967:

Line 964: oe_debug_pub.add('Quantity Available to Rsrv: '

960: if (x_available_qty <= 0) then
961: l_stmt_num := 190;
962: IF PG_DEBUG <> 0 THEN
963: oe_debug_pub.add('Not Enough Qty to reserve. ',1);
964: oe_debug_pub.add('Quantity Available to Rsrv: '
965: || to_char(x_available_qty),1);
966: END IF;
967:
968:

Line 975: oe_debug_pub.add

971: --return TRUE;
972:
973: else
974: IF PG_DEBUG <> 0 THEN
975: oe_debug_pub.add
976: ('Matching Config Item: ' || to_char(x_config_id),1 );
977: oe_debug_pub.add
978: ('Quantity On-Hand: ' || to_char(x_available_qty),1);
979: END IF ;

Line 977: oe_debug_pub.add

973: else
974: IF PG_DEBUG <> 0 THEN
975: oe_debug_pub.add
976: ('Matching Config Item: ' || to_char(x_config_id),1 );
977: oe_debug_pub.add
978: ('Quantity On-Hand: ' || to_char(x_available_qty),1);
979: END IF ;
980:
981:

Line 992: oe_debug_pub.add

988: else
989:
990: /* IMPORTANT!! */
991:
992: oe_debug_pub.add
993: ('Matching Config Item: ' || ' Will Not attempt Reservation as Order is either not booked or is Dropship ' ,1 );
994:
995:
996: /* BUG#2367720 */

Line 1016: oe_debug_pub.add('Calling Purchase doc creation..',1);

1012:
1013: -- Added by Renga Kannan on 04/01/02 to call the Purchase price rollup API
1014:
1015: IF PG_DEBUG <> 0 THEN
1016: oe_debug_pub.add('Calling Purchase doc creation..',1);
1017: END IF;
1018:
1019:
1020:

Line 1040: oe_debug_pub.add(' Failed in Create_purchasing_doc call...',1);

1036:
1037:
1038: if x_return_status = FND_API.G_RET_STS_ERROR then
1039: IF PG_DEBUG <> 0 THEN
1040: oe_debug_pub.add(' Failed in Create_purchasing_doc call...',1);
1041: END IF ;
1042:
1043:
1044: -- raise FND_API.G_EXC_ERROR;

Line 1047: oe_debug_pub.add(' Failed in Create_purchasing_doc call...',1);

1043:
1044: -- raise FND_API.G_EXC_ERROR;
1045: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1046: IF PG_DEBUG <> 0 THEN
1047: oe_debug_pub.add(' Failed in Create_purchasing_doc call...',1);
1048: END IF;
1049:
1050:
1051: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1058: oe_debug_pub.add('CTOMCRSB: ' || 'Will Not perform PP Rollup as profile is No ', 1);

1054:
1055: else
1056:
1057: IF PG_DEBUG <> 0 THEN
1058: oe_debug_pub.add('CTOMCRSB: ' || 'Will Not perform PP Rollup as profile is No ', 1);
1059: END IF;
1060:
1061:
1062:

Line 1077: oe_debug_pub.add('going to call cost rollup in CTOMCRSB for matched items.',1);

1073:
1074: /* Changes for enhanced cost rollup */
1075:
1076: IF PG_DEBUG <> 0 THEN
1077: oe_debug_pub.add('going to call cost rollup in CTOMCRSB for matched items.',1);
1078: END IF;
1079:
1080:
1081: l_status := CTO_CONFIG_COST_PK.cost_rollup_ml(

Line 1088: oe_debug_pub.add('Failure in cost_rollup ', 1);

1084: x_msg_data => x_msg_data);
1085:
1086: if (l_status = 0) then
1087: IF PG_DEBUG <> 0 THEN
1088: oe_debug_pub.add('Failure in cost_rollup ', 1);
1089: END IF;
1090:
1091: cto_msg_pub.cto_message('BOM', x_msg_data);
1092: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1095: oe_debug_pub.add('Success in cost_rollup ', 1);

1091: cto_msg_pub.cto_message('BOM', x_msg_data);
1092: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1093: else
1094: IF PG_DEBUG <> 0 THEN
1095: oe_debug_pub.add('Success in cost_rollup ', 1);
1096: END IF;
1097:
1098: end if;
1099:

Line 1105: oe_debug_pub.add('CTOMCRSB: ' || 'Will Not perform Cost Rollup as profile is No ', 1);

1101:
1102: else
1103:
1104: IF PG_DEBUG <> 0 THEN
1105: oe_debug_pub.add('CTOMCRSB: ' || 'Will Not perform Cost Rollup as profile is No ', 1);
1106: END IF;
1107:
1108:
1109:

Line 1140: oe_debug_pub.add(x_error_message, 1);

1136: x_error_message := 'CTOMCRSB:match_inquiry: ' ||
1137: to_char(l_stmt_num) || ':' ||
1138: substrb(sqlerrm,1,100);
1139: IF PG_DEBUG <> 0 THEN
1140: oe_debug_pub.add(x_error_message, 1);
1141: END IF;
1142:
1143: return FALSE;
1144:

Line 1151: oe_debug_pub.add(x_error_message, 1);

1147: x_error_message := 'CTOMCRSB:match_inquiry: ' ||
1148: to_char(l_stmt_num) || ':' ||
1149: substrb(sqlerrm,1,100);
1150: IF PG_DEBUG <> 0 THEN
1151: oe_debug_pub.add(x_error_message, 1);
1152: END IF;
1153:
1154: return FALSE;
1155:

Line 1162: oe_debug_pub.add(x_error_message, 1);

1158: x_error_message := 'CTOMCRSB:match_inquiry: ' ||
1159: to_char(l_stmt_num) || ':' ||
1160: substrb(sqlerrm,1,100);
1161: IF PG_DEBUG <> 0 THEN
1162: oe_debug_pub.add(x_error_message, 1);
1163: END IF;
1164:
1165: return FALSE;
1166:

Line 1173: oe_debug_pub.add(x_error_message, 1);

1169: x_error_message := 'CTOMCRSB:match_inquiry: ' ||
1170: to_char(l_stmt_num) || ':' ||
1171: substrb(sqlerrm,1,100);
1172: IF PG_DEBUG <> 0 THEN
1173: oe_debug_pub.add(x_error_message, 1);
1174: END IF;
1175:
1176: return FALSE;
1177:

Line 1184: oe_debug_pub.add(x_error_message, 1);

1180: x_error_message := 'CTOMCRSB:match_inquiry: ' ||
1181: to_char(l_stmt_num) || ':' ||
1182: substrb(sqlerrm,1,100);
1183: IF PG_DEBUG <> 0 THEN
1184: oe_debug_pub.add(x_error_message, 1);
1185: END IF;
1186:
1187: return FALSE;
1188:

Line 1193: oe_debug_pub.add ('match_inquiry: exp_error ' || to_char(l_stmt_num) ||sqlerrm,1);

1189: WHEN FND_API.G_EXC_ERROR THEN
1190: x_error_message := 'CTOMCRSB:match_inquiry failed with expected error in stmt '
1191: ||to_char(l_stmt_num);
1192: IF PG_DEBUG <> 0 THEN
1193: oe_debug_pub.add ('match_inquiry: exp_error ' || to_char(l_stmt_num) ||sqlerrm,1);
1194: END IF;
1195:
1196: return FALSE;
1197:

Line 1202: oe_debug_pub.add ('match_inquiry: unexp_error ' || to_char(l_stmt_num) ||sqlerrm,1);

1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: x_error_message := 'CTOMCRSB:match_inquiry failed with unexpected error in stmt '
1200: ||to_char(l_stmt_num);
1201: IF PG_DEBUG <> 0 THEN
1202: oe_debug_pub.add ('match_inquiry: unexp_error ' || to_char(l_stmt_num) ||sqlerrm,1);
1203: END IF;
1204:
1205: return FALSE;
1206:

Line 1214: oe_debug_pub.add(x_error_message, 1);

1210: x_error_message := 'CTOMCRSB:match_inquiry: '
1211: || to_char(l_stmt_num) || ':' ||
1212: substrb(sqlerrm,1,100);
1213: IF PG_DEBUG <> 0 THEN
1214: oe_debug_pub.add(x_error_message, 1);
1215: END IF;
1216:
1217: return FALSE;
1218: END match_inquiry ;

Line 1311: oe_debug_pub.add('create_config_reservation: ' || 'Config line does not exist. ', 1);

1307: /*----------------------------------------------+
1308: Config line does not exist. Raise error.
1309: +-----------------------------------------------*/
1310: IF PG_DEBUG <> 0 THEN
1311: oe_debug_pub.add('create_config_reservation: ' || 'Config line does not exist. ', 1);
1312: END IF;
1313: l_stmt_num := 115;
1314: raise PROCESS_ERROR;
1315:

Line 1363: oe_debug_pub.add('create_config_reservation: ' || 'lSourceCode is '||lSourceCode, 2);

1359: +------------------------------------------------------------------*/
1360: l_stmt_num := 140;
1361: lSourceCode := fnd_profile.value('ONT_SOURCE_CODE');
1362: IF PG_DEBUG <> 0 THEN
1363: oe_debug_pub.add('create_config_reservation: ' || 'lSourceCode is '||lSourceCode, 2);
1364: END IF;
1365: select mso.sales_order_id,
1366: oel.line_id, -- config line id
1367: oel.ship_from_org_id,

Line 1425: oe_debug_pub.add

1421:
1422: if (l_x_status = FND_API.g_ret_sts_success) then
1423: l_stmt_num := 160;
1424: IF PG_DEBUG <> 0 THEN
1425: oe_debug_pub.add
1426: ('create_config_reservation: ' || 'Success in reserve_config with reservation id:' ||
1427: to_char(l_x_reservation_id),1);
1428: END IF;
1429: else

Line 1431: oe_debug_pub.add('create_config_reservation: ' || 'Failed in reserve_config.',1);

1427: to_char(l_x_reservation_id),1);
1428: END IF;
1429: else
1430: IF PG_DEBUG <> 0 THEN
1431: oe_debug_pub.add('create_config_reservation: ' || 'Failed in reserve_config.',1);
1432: END IF;
1433: raise PROCESS_ERROR;
1434:
1435: end if;

Line 1456: oe_debug_pub.add('create_config_reservation: ' || x_error_msg, 1);

1452: x_error_msg := 'CTOMCRSB:create_config_reservation: ' ||
1453: l_x_status || ': ' ||
1454: l_x_error_msg;
1455: IF PG_DEBUG <> 0 THEN
1456: oe_debug_pub.add('create_config_reservation: ' || x_error_msg, 1);
1457: END IF;
1458: return FALSE;
1459:
1460: when OTHERS then

Line 1466: oe_debug_pub.add('create_config_reservation: ' || x_error_msg, 1);

1462: x_error_msg := 'CTOMCRSB:create_config_reservation: ' ||
1463: to_char(l_stmt_num) || ':' ||
1464: substrb(sqlerrm,1,100);
1465: IF PG_DEBUG <> 0 THEN
1466: oe_debug_pub.add('create_config_reservation: ' || x_error_msg, 1);
1467: END IF;
1468: return FALSE;
1469:
1470: END create_config_reservation;