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 944: oe_debug_pub.add('Success in Create Reservation. ',1);

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

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

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

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

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

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

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

Line 977: oe_debug_pub.add

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

Line 979: oe_debug_pub.add

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

Line 994: oe_debug_pub.add

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1314: /*----------------------------------------------+
1315: Config line does not exist. Raise error.
1316: +-----------------------------------------------*/
1317: IF PG_DEBUG <> 0 THEN
1318: oe_debug_pub.add('create_config_reservation: ' || 'Config line does not exist. ', 1);
1319: END IF;
1320: l_stmt_num := 115;
1321: raise PROCESS_ERROR;
1322:

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

1366: +------------------------------------------------------------------*/
1367: l_stmt_num := 140;
1368: lSourceCode := fnd_profile.value('ONT_SOURCE_CODE');
1369: IF PG_DEBUG <> 0 THEN
1370: oe_debug_pub.add('create_config_reservation: ' || 'lSourceCode is '||lSourceCode, 2);
1371: END IF;
1372: select mso.sales_order_id,
1373: oel.line_id, -- config line id
1374: oel.ship_from_org_id,

Line 1421: oe_debug_pub.add('create_config_reservation:' || 'Count of records::' || l_cnt);

1417:
1418: --Bugfix 12374440
1419: l_cnt := sql%rowcount;
1420: IF PG_DEBUG <> 0 THEN
1421: oe_debug_pub.add('create_config_reservation:' || 'Count of records::' || l_cnt);
1422: oe_debug_pub.add('create_config_reservation:' || 'Subinventory::' || l_rec_reserve.f_subinventory_code);
1423: END IF;
1424:
1425: --Bugfix 12374440

Line 1422: oe_debug_pub.add('create_config_reservation:' || 'Subinventory::' || l_rec_reserve.f_subinventory_code);

1418: --Bugfix 12374440
1419: l_cnt := sql%rowcount;
1420: IF PG_DEBUG <> 0 THEN
1421: oe_debug_pub.add('create_config_reservation:' || 'Count of records::' || l_cnt);
1422: oe_debug_pub.add('create_config_reservation:' || 'Subinventory::' || l_rec_reserve.f_subinventory_code);
1423: END IF;
1424:
1425: --Bugfix 12374440
1426: --if (SQL%ROWCOUNT = 1) then

Line 1442: oe_debug_pub.add

1438:
1439: if (l_x_status = FND_API.g_ret_sts_success) then
1440: l_stmt_num := 160;
1441: IF PG_DEBUG <> 0 THEN
1442: oe_debug_pub.add
1443: ('create_config_reservation: ' || 'Success in reserve_config with reservation id:' ||
1444: to_char(l_x_reservation_id),1);
1445: END IF;
1446: else

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

1444: to_char(l_x_reservation_id),1);
1445: END IF;
1446: else
1447: IF PG_DEBUG <> 0 THEN
1448: oe_debug_pub.add('create_config_reservation: ' || 'Failed in reserve_config.',1);
1449: END IF;
1450: raise PROCESS_ERROR;
1451:
1452: end if;

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

1469: x_error_msg := 'CTOMCRSB:create_config_reservation: ' ||
1470: l_x_status || ': ' ||
1471: l_x_error_msg;
1472: IF PG_DEBUG <> 0 THEN
1473: oe_debug_pub.add('create_config_reservation: ' || x_error_msg, 1);
1474: END IF;
1475: return FALSE;
1476:
1477: when OTHERS then

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

1479: x_error_msg := 'CTOMCRSB:create_config_reservation: ' ||
1480: to_char(l_stmt_num) || ':' ||
1481: substrb(sqlerrm,1,100);
1482: IF PG_DEBUG <> 0 THEN
1483: oe_debug_pub.add('create_config_reservation: ' || x_error_msg, 1);
1484: END IF;
1485: return FALSE;
1486:
1487: END create_config_reservation;