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.OE_PROCESS_REQUISITION_PVT dependencies on OE_DEBUG_PUB

Line 36: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

32: l_access_mode VARCHAR2(1);
33: l_ou_count NUMBER;
34: l_is_mo_init_done VARCHAR2(1);
35: --
36: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
37: --
38:
39: BEGIN
40: l_progress := '00';

Line 75: oe_debug_pub.add(' Set_org_context '||l_progress||' : '||sqlerrm);

71: END IF;
72: EXCEPTION
73: WHEN OTHERS THEN
74: IF l_debug_level > 0 THEN
75: oe_debug_pub.add(' Set_org_context '||l_progress||' : '||sqlerrm);
76: END IF;
77: RAISE;
78: END Set_Org_Context;
79:

Line 102: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

98: l_user_name VARCHAR2(255);
99: l_flow_created BOOLEAN := FALSE;
100:
101: --
102: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
103: --
104:
105: Begin
106:

Line 108: oe_debug_pub.add( ' ENTERING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;

104:
105: Begin
106:
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( ' ENTERING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;
109: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
110: oe_debug_pub.add( ' P_Line_id_tbl Count :'||P_Line_id_tbl.count , 5 ) ;
111: oe_debug_pub.add( ' P_performer :'||p_performer,5);
112: oe_debug_pub.add( ' p_notify_for :'||p_notify_for,5);

Line 109: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;

105: Begin
106:
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( ' ENTERING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;
109: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
110: oe_debug_pub.add( ' P_Line_id_tbl Count :'||P_Line_id_tbl.count , 5 ) ;
111: oe_debug_pub.add( ' P_performer :'||p_performer,5);
112: oe_debug_pub.add( ' p_notify_for :'||p_notify_for,5);
113: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;

Line 110: oe_debug_pub.add( ' P_Line_id_tbl Count :'||P_Line_id_tbl.count , 5 ) ;

106:
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( ' ENTERING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;
109: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
110: oe_debug_pub.add( ' P_Line_id_tbl Count :'||P_Line_id_tbl.count , 5 ) ;
111: oe_debug_pub.add( ' P_performer :'||p_performer,5);
112: oe_debug_pub.add( ' p_notify_for :'||p_notify_for,5);
113: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
114: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;

Line 111: oe_debug_pub.add( ' P_performer :'||p_performer,5);

107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( ' ENTERING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;
109: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
110: oe_debug_pub.add( ' P_Line_id_tbl Count :'||P_Line_id_tbl.count , 5 ) ;
111: oe_debug_pub.add( ' P_performer :'||p_performer,5);
112: oe_debug_pub.add( ' p_notify_for :'||p_notify_for,5);
113: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
114: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
115: IF P_Cancel_Order THEN

Line 112: oe_debug_pub.add( ' p_notify_for :'||p_notify_for,5);

108: oe_debug_pub.add( ' ENTERING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;
109: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
110: oe_debug_pub.add( ' P_Line_id_tbl Count :'||P_Line_id_tbl.count , 5 ) ;
111: oe_debug_pub.add( ' P_performer :'||p_performer,5);
112: oe_debug_pub.add( ' p_notify_for :'||p_notify_for,5);
113: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
114: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
115: IF P_Cancel_Order THEN
116: IF l_debug_level > 0 THEN

Line 113: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;

109: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
110: oe_debug_pub.add( ' P_Line_id_tbl Count :'||P_Line_id_tbl.count , 5 ) ;
111: oe_debug_pub.add( ' P_performer :'||p_performer,5);
112: oe_debug_pub.add( ' p_notify_for :'||p_notify_for,5);
113: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
114: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
115: IF P_Cancel_Order THEN
116: IF l_debug_level > 0 THEN
117: oe_debug_pub.add( ' Header Level cancellation', 5 ) ;

Line 114: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;

110: oe_debug_pub.add( ' P_Line_id_tbl Count :'||P_Line_id_tbl.count , 5 ) ;
111: oe_debug_pub.add( ' P_performer :'||p_performer,5);
112: oe_debug_pub.add( ' p_notify_for :'||p_notify_for,5);
113: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
114: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
115: IF P_Cancel_Order THEN
116: IF l_debug_level > 0 THEN
117: oe_debug_pub.add( ' Header Level cancellation', 5 ) ;
118: END IF;

Line 117: oe_debug_pub.add( ' Header Level cancellation', 5 ) ;

113: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
114: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
115: IF P_Cancel_Order THEN
116: IF l_debug_level > 0 THEN
117: oe_debug_pub.add( ' Header Level cancellation', 5 ) ;
118: END IF;
119: ELSE
120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add( ' Not a header Level cancellation', 5 ) ;

Line 121: oe_debug_pub.add( ' Not a header Level cancellation', 5 ) ;

117: oe_debug_pub.add( ' Header Level cancellation', 5 ) ;
118: END IF;
119: ELSE
120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add( ' Not a header Level cancellation', 5 ) ;
122: END IF;
123: END IF;
124: END IF;
125:

Line 130: oe_debug_pub.add( ' RETURN. No notification will be send as nothing has updated on the requisition', 5);

126: l_return_status := FND_API.G_RET_STS_SUCCESS;
127:
128: IF p_notify_for is NULL AND NOT P_cancel_order THEN
129: IF l_debug_level > 0 THEN
130: oe_debug_pub.add( ' RETURN. No notification will be send as nothing has updated on the requisition', 5);
131: END IF;
132: RETURN;
133: END IF;
134:

Line 140: oe_debug_pub.add( ' WF ITEM KEY IS :'|| L_WF_ITEM_KEY ) ;

136: select to_char(oe_wf_key_s.nextval) into l_wf_item_key
137: from dual;
138:
139: IF l_debug_level > 0 THEN
140: oe_debug_pub.add( ' WF ITEM KEY IS :'|| L_WF_ITEM_KEY ) ;
141: END IF;
142:
143: IF P_cancel_order THEN
144: IF l_debug_level > 0 THEN

Line 145: oe_debug_pub.add( 'Sending notification for requisition header cancellation', 5);

141: END IF;
142:
143: IF P_cancel_order THEN
144: IF l_debug_level > 0 THEN
145: oe_debug_pub.add( 'Sending notification for requisition header cancellation', 5);
146: END IF;
147:
148: l_process_name := 'ISO_CANCEL';
149:

Line 186: oe_debug_pub.add( 'Sending notification for requisition line quantity update', 5);

182: , g_reason);
183: */
184: ELSIF p_notify_for = 'Q' THEN
185: IF l_debug_level > 0 THEN
186: oe_debug_pub.add( 'Sending notification for requisition line quantity update', 5);
187: END IF;
188:
189: l_process_name := 'ISO_QTY_UPDATE';
190:

Line 271: oe_debug_pub.add( 'Sending notification for requisition line date update', 5);

267: , g_reason);
268: */
269: ELSIF p_notify_for = 'D' THEN
270: IF l_debug_level > 0 THEN
271: oe_debug_pub.add( 'Sending notification for requisition line date update', 5);
272: END IF;
273:
274: l_process_name := 'ISO_SCH_DATE_UPDATE';
275:

Line 348: oe_debug_pub.add( 'Sending notification for requisition line quantity and date update', 5);

344: , g_reason);
345: */
346: ELSIF p_notify_for = 'B' THEN
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add( 'Sending notification for requisition line quantity and date update', 5);
349: END IF;
350:
351: l_process_name := 'ISO_QTY_SCH_DATE_UPDATE';
352:

Line 445: oe_debug_pub.add( 'Sending notification for requisition line cancellation', 5);

441: , g_reason);
442: */
443: ELSIF p_notify_for = 'C' THEN
444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add( 'Sending notification for requisition line cancellation', 5);
446: END IF;
447:
448: l_process_name := 'ISO_LINE_CANCEL';
449:

Line 519: oe_debug_pub.add(' Starting the workflow process for sending the notification', 5);

515:
516: IF l_flow_created THEN
517:
518: IF l_debug_level > 0 THEN
519: oe_debug_pub.add(' Starting the workflow process for sending the notification', 5);
520: END IF;
521: BEGIN
522: select user_name
523: into l_user_name

Line 540: oe_debug_pub.add(' Workflow process is successfully started',5);

536: END IF;
537:
538: WF_ENGINE.StartProcess(l_chgord_item_type, l_wf_item_key);
539: IF l_debug_level > 0 THEN
540: oe_debug_pub.add(' Workflow process is successfully started',5);
541: END IF;
542: END IF;
543:
544: x_return_status := l_return_status;

Line 550: oe_debug_pub.add( 'EXITING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;

546: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
547: -- P_Data => x_msg_Data);
548:
549: IF l_debug_level > 0 THEN
550: oe_debug_pub.add( 'EXITING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;
551: END IF;
552:
553: Exception
554: WHEN FND_API.G_EXC_ERROR THEN

Line 565: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Prepare_Notification '||sqlerrm,1);

561: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
562: -- P_Data => x_msg_Data);
563:
564: WHEN OTHERS THEN
565: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Prepare_Notification '||sqlerrm,1);
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
568: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Prepare_Notification');
569: -- Pkg Body global variable = OE_Process_Requisition_Pvt

Line 633: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

629: and open_flag = 'N'
630: and nvl(cancelled_flag, 'N') = 'Y'; -- Cursor added for 8583903
631: --
632:
633: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
634: --
635:
636: Begin
637:

Line 639: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;

635:
636: Begin
637:
638: IF l_debug_level > 0 THEN
639: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
640: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
641: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
642: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
643: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;

Line 640: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;

636: Begin
637:
638: IF l_debug_level > 0 THEN
639: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
640: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
641: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
642: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
643: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
644: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;

Line 641: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;

637:
638: IF l_debug_level > 0 THEN
639: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
640: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
641: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
642: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
643: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
644: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
645: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );

Line 642: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);

638: IF l_debug_level > 0 THEN
639: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
640: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
641: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
642: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
643: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
644: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
645: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );
646: oe_debug_pub.add( ' P_Quantity2_Change :'||P_Quantity2_Change, 5 );

Line 643: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;

639: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
640: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
641: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
642: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
643: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
644: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
645: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );
646: oe_debug_pub.add( ' P_Quantity2_Change :'||P_Quantity2_Change, 5 );
647: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;

Line 644: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;

640: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
641: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
642: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
643: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
644: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
645: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );
646: oe_debug_pub.add( ' P_Quantity2_Change :'||P_Quantity2_Change, 5 );
647: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;
648: IF P_Cancel_Order THEN

Line 645: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );

641: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
642: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
643: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
644: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
645: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );
646: oe_debug_pub.add( ' P_Quantity2_Change :'||P_Quantity2_Change, 5 );
647: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;
648: IF P_Cancel_Order THEN
649: oe_debug_pub.add( ' Header level cancellation',5);

Line 646: oe_debug_pub.add( ' P_Quantity2_Change :'||P_Quantity2_Change, 5 );

642: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
643: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
644: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
645: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );
646: oe_debug_pub.add( ' P_Quantity2_Change :'||P_Quantity2_Change, 5 );
647: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;
648: IF P_Cancel_Order THEN
649: oe_debug_pub.add( ' Header level cancellation',5);
650: ELSE

Line 647: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;

643: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
644: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
645: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );
646: oe_debug_pub.add( ' P_Quantity2_Change :'||P_Quantity2_Change, 5 );
647: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;
648: IF P_Cancel_Order THEN
649: oe_debug_pub.add( ' Header level cancellation',5);
650: ELSE
651: oe_debug_pub.add( ' Not a header level cancellation',5);

Line 649: oe_debug_pub.add( ' Header level cancellation',5);

645: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );
646: oe_debug_pub.add( ' P_Quantity2_Change :'||P_Quantity2_Change, 5 );
647: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;
648: IF P_Cancel_Order THEN
649: oe_debug_pub.add( ' Header level cancellation',5);
650: ELSE
651: oe_debug_pub.add( ' Not a header level cancellation',5);
652: END IF;
653: IF P_Cancel_Line THEN

Line 651: oe_debug_pub.add( ' Not a header level cancellation',5);

647: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;
648: IF P_Cancel_Order THEN
649: oe_debug_pub.add( ' Header level cancellation',5);
650: ELSE
651: oe_debug_pub.add( ' Not a header level cancellation',5);
652: END IF;
653: IF P_Cancel_Line THEN
654: oe_debug_pub.add( ' Line level cancellation',5);
655: ELSE

Line 654: oe_debug_pub.add( ' Line level cancellation',5);

650: ELSE
651: oe_debug_pub.add( ' Not a header level cancellation',5);
652: END IF;
653: IF P_Cancel_Line THEN
654: oe_debug_pub.add( ' Line level cancellation',5);
655: ELSE
656: oe_debug_pub.add( ' Not a line level cancellation',5);
657: END IF;
658: END IF;

Line 656: oe_debug_pub.add( ' Not a line level cancellation',5);

652: END IF;
653: IF P_Cancel_Line THEN
654: oe_debug_pub.add( ' Line level cancellation',5);
655: ELSE
656: oe_debug_pub.add( ' Not a line level cancellation',5);
657: END IF;
658: END IF;
659:
660: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 667: oe_debug_pub.add( ' Nothing to update on Requisition', 5 ) ;

663: AND (P_Quantity_Change is null OR P_Quantity_Change = 0)
664: AND (P_Quantity2_Change is null OR P_Quantity2_Change = 0) --Bug 14211120
665: AND P_New_Schedule_Ship_Date is null THEN
666: IF l_debug_level > 0 THEN
667: oe_debug_pub.add( ' Nothing to update on Requisition', 5 ) ;
668: END IF;
669: -- RAISE FND_API.G_EXC_ERROR;
670: x_return_status := l_return_status;
671: RETURN;

Line 681: oe_debug_pub.add( ' OE_GLOBALS.G_REASON_CODE for this change is '||OE_GLOBALS.G_REASON_CODE,5);

677: FROM po_requisition_Headers_all
678: WHERE requisition_header_id = p_req_Header_id;
679:
680: IF l_debug_level > 0 THEN
681: oe_debug_pub.add( ' OE_GLOBALS.G_REASON_CODE for this change is '||OE_GLOBALS.G_REASON_CODE,5);
682: END IF;
683:
684: IF P_Cancel_Order THEN
685: IF l_debug_level > 0 THEN

Line 686: oe_debug_pub.add( ' Calling PO_RCO_Validation_GRP.Update_ReqCancel_from_SO', 1 ) ;

682: END IF;
683:
684: IF P_Cancel_Order THEN
685: IF l_debug_level > 0 THEN
686: oe_debug_pub.add( ' Calling PO_RCO_Validation_GRP.Update_ReqCancel_from_SO', 1 ) ;
687: oe_debug_pub.add( ' Cancelling Requisition Header', 1 ) ;
688: END IF;
689:
690: select order_number, last_update_date

Line 687: oe_debug_pub.add( ' Cancelling Requisition Header', 1 ) ;

683:
684: IF P_Cancel_Order THEN
685: IF l_debug_level > 0 THEN
686: oe_debug_pub.add( ' Calling PO_RCO_Validation_GRP.Update_ReqCancel_from_SO', 1 ) ;
687: oe_debug_pub.add( ' Cancelling Requisition Header', 1 ) ;
688: END IF;
689:
690: select order_number, last_update_date
691: into g_sales_order_number, g_order_cancellation_date

Line 723: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Update_ReqCancel_from_SO '||l_return_status, 1 ) ;

719:
720: SET_ORG_CONTEXT(l_original_org_id);
721:
722: IF l_debug_level > 0 THEN
723: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Update_ReqCancel_from_SO '||l_return_status, 1 ) ;
724: END IF;
725:
726: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
727: -- Sales order and corresponding internal requisition has been cancelled

Line 745: oe_debug_pub.add( ' Calling PO_RCO_Validation_GRP.Update_ReqCancel_from_SO', 1 ) ;

741: l_create_notification := TRUE;
742:
743: ELSIF P_Cancel_Line THEN
744: IF l_debug_level > 0 THEN
745: oe_debug_pub.add( ' Calling PO_RCO_Validation_GRP.Update_ReqCancel_from_SO', 1 ) ;
746: oe_debug_pub.add( ' Cancelling Requisition Line', 1 ) ;
747: END IF;
748:
749: select order_number

Line 746: oe_debug_pub.add( ' Cancelling Requisition Line', 1 ) ;

742:
743: ELSIF P_Cancel_Line THEN
744: IF l_debug_level > 0 THEN
745: oe_debug_pub.add( ' Calling PO_RCO_Validation_GRP.Update_ReqCancel_from_SO', 1 ) ;
746: oe_debug_pub.add( ' Cancelling Requisition Line', 1 ) ;
747: END IF;
748:
749: select order_number
750: into g_sales_order_number

Line 812: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Update_ReqCancel_from_SO '||l_return_status, 5 ) ;

808:
809: SET_ORG_CONTEXT(l_original_org_id);
810:
811: IF l_debug_level > 0 THEN
812: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Update_ReqCancel_from_SO '||l_return_status, 5 ) ;
813: END IF;
814:
815: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
816: -- Sales order and corresponding internal requisition line has been cancelled

Line 838: oe_debug_pub.add( ' Quantity OR Date changed. Req Line has to be updated', 5 ) ;

834: OR (P_Quantity2_Change IS NOT NULL AND P_Quantity2_Change <> 0) --Bug 14211120
835: OR (P_New_Schedule_Ship_Date IS NOT NULL) THEN
836:
837: IF l_debug_level > 0 THEN
838: oe_debug_pub.add( ' Quantity OR Date changed. Req Line has to be updated', 5 ) ;
839: END IF;
840:
841: select order_number
842: into g_sales_order_number

Line 893: oe_debug_pub.add( ' Need By Date on Req Line is '||l_Req_Line_NeedByDate, 5 ) ;

889: g_updated_quantity2 := g_requested_quantity2 + NVL(P_Quantity2_Change,0); --Bug 14211120
890: -- Added NVL for bug 8920840
891:
892: IF l_debug_level > 0 THEN
893: oe_debug_pub.add( ' Need By Date on Req Line is '||l_Req_Line_NeedByDate, 5 ) ;
894: END IF;
895:
896: --IF (P_Quantity_Change IS NOT NULL AND P_Quantity_Change <> 0)
897: --AND (P_New_Schedule_Ship_Date IS NOT NULL) THEN

Line 910: oe_debug_pub.add( ' Ordered Quantity is changed. Update Req', 5 ) ;

906: l_New_Schedule_Ship_Date := NULL;
907: g_schedule_ship_date := NULL;
908: g_schedule_arrival_date := NULL;
909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( ' Ordered Quantity is changed. Update Req', 5 ) ;
911: END IF;
912: L_change := 'Q'; -- Quantity change
913: l_call_po_api_for_update := TRUE;
914: ELSE

Line 918: oe_debug_pub.add( ' Ordered Quantity and Schedule Ship/Arrival Date are changed. Update Req', 5 ) ;

914: ELSE
915: l_New_Schedule_Arrival_Date := g_schedule_arrival_date;
916: -- l_New_Schedule_Ship_Date := P_New_Schedule_Ship_Date;
917: IF l_debug_level > 0 THEN
918: oe_debug_pub.add( ' Ordered Quantity and Schedule Ship/Arrival Date are changed. Update Req', 5 ) ;
919: END IF;
920: L_change := 'B'; -- Both Date and Quantity change
921: l_call_po_api_for_update := TRUE;
922: END IF;

Line 929: oe_debug_pub.add( ' Ordered Quantity is changed. Update Req', 5 ) ;

925: --ELSIF P_Quantity_Change IS NOT NULL AND P_Quantity_Change <> 0 THEN
926: ELSIF (P_Quantity_Change IS NOT NULL AND P_Quantity_Change <> 0) OR
927: (P_Quantity2_Change IS NOT NULL AND P_Quantity2_Change <> 0) THEN
928: IF l_debug_level > 0 THEN
929: oe_debug_pub.add( ' Ordered Quantity is changed. Update Req', 5 ) ;
930: END IF;
931: L_change := 'Q'; -- Quantity change
932: g_schedule_ship_date := NULL;
933: g_schedule_arrival_date := NULL;

Line 947: oe_debug_pub.add( ' Neither Quantity nor date has changed', 5 ) ;

943: l_call_po_api_for_update := FALSE;
944: l_change := NULL; -- No date or quantity change
945:
946: IF l_debug_level > 0 THEN
947: oe_debug_pub.add( ' Neither Quantity nor date has changed', 5 ) ;
948: END IF;
949: ELSE
950: -- l_New_Schedule_Ship_Date := P_New_Schedule_Ship_Date;
951: l_New_Schedule_Arrival_Date := g_schedule_arrival_date;

Line 953: oe_debug_pub.add( ' Schedule Ship/Arrival Date is changed. Update Req', 5 ) ;

949: ELSE
950: -- l_New_Schedule_Ship_Date := P_New_Schedule_Ship_Date;
951: l_New_Schedule_Arrival_Date := g_schedule_arrival_date;
952: IF l_debug_level > 0 THEN
953: oe_debug_pub.add( ' Schedule Ship/Arrival Date is changed. Update Req', 5 ) ;
954: END IF;
955: g_updated_quantity := NULL;
956: L_change := 'D'; -- Date Change
957: l_call_po_api_for_update := TRUE;

Line 965: oe_debug_pub.add( ' Calling PO_RCO_Validation_GRP.Update_ReqChange_from_SO', 1 ) ;

961:
962: IF l_call_po_api_for_update THEN
963:
964: IF l_debug_level > 0 THEN
965: oe_debug_pub.add( ' Calling PO_RCO_Validation_GRP.Update_ReqChange_from_SO', 1 ) ;
966: END IF;
967:
968: SET_ORG_CONTEXT(l_target_org_id);
969:

Line 983: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Update_ReqChange_from_SO '||l_return_status, 1);

979:
980: SET_ORG_CONTEXT(l_original_org_id);
981:
982: IF l_debug_level > 0 THEN
983: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Update_ReqChange_from_SO '||l_return_status, 1);
984: END IF;
985:
986: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
987: IF L_change = 'Q' THEN -- Q => Quantity

Line 1023: oe_debug_pub.add( ' Update_ReqChange_from_SO is not called as there is no valid change to process', 1);

1019:
1020: l_create_notification := TRUE;
1021: ELSE
1022: IF l_debug_level > 0 THEN
1023: oe_debug_pub.add( ' Update_ReqChange_from_SO is not called as there is no valid change to process', 1);
1024: END IF;
1025: END IF;
1026: END IF; -- p_cancel_order
1027:

Line 1030: oe_debug_pub.add(' The caller for this change is Planning. Hence notification will not be send',5);

1026: END IF; -- p_cancel_order
1027:
1028: IF OE_Schedule_GRP.G_ISO_Planning_Update THEN
1029: IF l_debug_level > 0 THEN
1030: oe_debug_pub.add(' The caller for this change is Planning. Hence notification will not be send',5);
1031: END IF;
1032: l_create_notification := FALSE;
1033: END IF;
1034:

Line 1037: oe_debug_pub.add( ' Preparing Notification ', 1 ) ;

1033: END IF;
1034:
1035: IF l_create_notification THEN
1036: IF l_debug_level > 0 THEN
1037: oe_debug_pub.add( ' Preparing Notification ', 1 ) ;
1038: END IF;
1039:
1040: IF P_Cancel_Order THEN
1041: IF p_num_records > 0 THEN

Line 1072: oe_debug_pub.add(' Not a header cancellation. Line is : '||l_line_ids_tbl(1));

1068: ELSE
1069: l_line_ids_tbl.Extend(1);
1070: l_line_ids_tbl(1) := p_line_id;
1071: IF l_debug_level >0 THEN
1072: oe_debug_pub.add(' Not a header cancellation. Line is : '||l_line_ids_tbl(1));
1073: END IF;
1074: END IF;
1075:
1076: SET_ORG_CONTEXT(l_target_org_id);

Line 1088: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Get_Preparer_Name '||l_return_status, 1 ) ;

1084:
1085: SET_ORG_CONTEXT(l_original_org_id);
1086:
1087: IF l_debug_level > 0 THEN
1088: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Get_Preparer_Name '||l_return_status, 1 ) ;
1089: END IF;
1090:
1091: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1092: -- Unable to save the changes as the corresponding Internal Requisition can not be updated

Line 1104: oe_debug_pub.add( ' The preparer name is null. Setting it to SYSADMIN ',1);

1100: END IF;
1101:
1102: IF l_preparer_name IS NULL THEN
1103: IF l_debug_level > 0 THEN
1104: oe_debug_pub.add( ' The preparer name is null. Setting it to SYSADMIN ',1);
1105: END IF;
1106: l_preparer_name := 'SYSADMIN';
1107: ELSE
1108: IF l_debug_level > 0 THEN

Line 1109: oe_debug_pub.add( ' The preparer name is '||l_preparer_name);

1105: END IF;
1106: l_preparer_name := 'SYSADMIN';
1107: ELSE
1108: IF l_debug_level > 0 THEN
1109: oe_debug_pub.add( ' The preparer name is '||l_preparer_name);
1110: END IF;
1111: END IF;
1112:
1113: Prepare_Notification

Line 1159: oe_debug_pub.add( 'EXITING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;

1155: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1156: P_Data => x_msg_Data);
1157:
1158: IF l_debug_level > 0 THEN
1159: oe_debug_pub.add( 'EXITING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
1160: END IF;
1161:
1162: Exception
1163: WHEN FND_API.G_EXC_ERROR THEN

Line 1174: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Update_Internal_Requisition '||sqlerrm,1);

1170: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1171: P_Data => x_msg_Data);
1172:
1173: WHEN OTHERS THEN
1174: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Update_Internal_Requisition '||sqlerrm,1);
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1177: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Internal_Requisition');
1178: -- Pkg Body global variable = OE_Process_Requisition_Pvt