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 34: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

251: , g_reason);
252: */
253: ELSIF p_notify_for = 'D' THEN
254: IF l_debug_level > 0 THEN
255: oe_debug_pub.add( 'Sending notification for requisition line date update', 5);
256: END IF;
257:
258: l_process_name := 'ISO_SCH_DATE_UPDATE';
259:

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

328: , g_reason);
329: */
330: ELSIF p_notify_for = 'B' THEN
331: IF l_debug_level > 0 THEN
332: oe_debug_pub.add( 'Sending notification for requisition line quantity and date update', 5);
333: END IF;
334:
335: l_process_name := 'ISO_QTY_SCH_DATE_UPDATE';
336:

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

411: , g_reason);
412: */
413: ELSIF p_notify_for = 'C' THEN
414: IF l_debug_level > 0 THEN
415: oe_debug_pub.add( 'Sending notification for requisition line cancellation', 5);
416: END IF;
417:
418: l_process_name := 'ISO_LINE_CANCEL';
419:

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

485:
486: IF l_flow_created THEN
487:
488: IF l_debug_level > 0 THEN
489: oe_debug_pub.add(' Starting the workflow process for sending the notification', 5);
490: END IF;
491: BEGIN
492: select user_name
493: into l_user_name

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

506: END IF;
507:
508: WF_ENGINE.StartProcess(l_chgord_item_type, l_wf_item_key);
509: IF l_debug_level > 0 THEN
510: oe_debug_pub.add(' Workflow process is successfully started',5);
511: END IF;
512: END IF;
513:
514: x_return_status := l_return_status;

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

516: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
517: -- P_Data => x_msg_Data);
518:
519: IF l_debug_level > 0 THEN
520: oe_debug_pub.add( 'EXITING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;
521: END IF;
522:
523: Exception
524: WHEN FND_API.G_EXC_ERROR THEN

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

531: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
532: -- P_Data => x_msg_Data);
533:
534: WHEN OTHERS THEN
535: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Prepare_Notification '||sqlerrm,1);
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
538: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Prepare_Notification');
539: -- Pkg Body global variable = OE_Process_Requisition_Pvt

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

583: l_nxt_position integer;
584: l_initial integer;
585: J integer;
586: --
587: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
588: --
589:
590: Begin
591:

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

589:
590: Begin
591:
592: IF l_debug_level > 0 THEN
593: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
594: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
595: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
596: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
597: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;

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

590: Begin
591:
592: IF l_debug_level > 0 THEN
593: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
594: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
595: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
596: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
597: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
598: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;

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

591:
592: IF l_debug_level > 0 THEN
593: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
594: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
595: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
596: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
597: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
598: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
599: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );

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

592: IF l_debug_level > 0 THEN
593: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
594: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
595: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
596: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
597: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
598: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
599: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );
600: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;

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

593: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
594: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
595: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
596: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
597: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
598: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
599: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );
600: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;
601: IF P_Cancel_Order THEN

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

594: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
595: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
596: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
597: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
598: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
599: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );
600: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;
601: IF P_Cancel_Order THEN
602: oe_debug_pub.add( ' Header level cancellation',5);

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

595: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
596: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
597: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
598: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
599: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );
600: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;
601: IF P_Cancel_Order THEN
602: oe_debug_pub.add( ' Header level cancellation',5);
603: ELSE

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

596: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
597: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;
598: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
599: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );
600: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;
601: IF P_Cancel_Order THEN
602: oe_debug_pub.add( ' Header level cancellation',5);
603: ELSE
604: oe_debug_pub.add( ' Not a header level cancellation',5);

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

598: oe_debug_pub.add( ' P_Req_Line_id :'||P_Req_Line_id , 5 ) ;
599: oe_debug_pub.add( ' P_Quantity_Change :'||P_Quantity_Change, 5 );
600: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;
601: IF P_Cancel_Order THEN
602: oe_debug_pub.add( ' Header level cancellation',5);
603: ELSE
604: oe_debug_pub.add( ' Not a header level cancellation',5);
605: END IF;
606: IF P_Cancel_Line THEN

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

600: oe_debug_pub.add( ' P_New_Schedule_Ship_Date :'||P_New_Schedule_Ship_Date, 5 ) ;
601: IF P_Cancel_Order THEN
602: oe_debug_pub.add( ' Header level cancellation',5);
603: ELSE
604: oe_debug_pub.add( ' Not a header level cancellation',5);
605: END IF;
606: IF P_Cancel_Line THEN
607: oe_debug_pub.add( ' Line level cancellation',5);
608: ELSE

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

603: ELSE
604: oe_debug_pub.add( ' Not a header level cancellation',5);
605: END IF;
606: IF P_Cancel_Line THEN
607: oe_debug_pub.add( ' Line level cancellation',5);
608: ELSE
609: oe_debug_pub.add( ' Not a line level cancellation',5);
610: END IF;
611: END IF;

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

605: END IF;
606: IF P_Cancel_Line THEN
607: oe_debug_pub.add( ' Line level cancellation',5);
608: ELSE
609: oe_debug_pub.add( ' Not a line level cancellation',5);
610: END IF;
611: END IF;
612:
613: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

615: IF NOT P_Cancel_Line and NOT P_Cancel_Order
616: AND (P_Quantity_Change is null OR P_Quantity_Change = 0)
617: AND P_New_Schedule_Ship_Date is null THEN
618: IF l_debug_level > 0 THEN
619: oe_debug_pub.add( ' Nothing to update on Requisition', 5 ) ;
620: END IF;
621: -- RAISE FND_API.G_EXC_ERROR;
622: x_return_status := l_return_status;
623: RETURN;

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

629: FROM po_requisition_Headers_all
630: WHERE requisition_header_id = p_req_Header_id;
631:
632: IF l_debug_level > 0 THEN
633: oe_debug_pub.add( ' OE_GLOBALS.G_REASON_CODE for this change is '||OE_GLOBALS.G_REASON_CODE,5);
634: END IF;
635:
636: IF P_Cancel_Order THEN
637: IF l_debug_level > 0 THEN

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

634: END IF;
635:
636: IF P_Cancel_Order THEN
637: IF l_debug_level > 0 THEN
638: oe_debug_pub.add( ' Calling PO_RCO_Validation_GRP.Update_ReqCancel_from_SO', 1 ) ;
639: oe_debug_pub.add( ' Cancelling Requisition Header', 1 ) ;
640: END IF;
641:
642: select order_number, last_update_date

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

635:
636: IF P_Cancel_Order THEN
637: IF l_debug_level > 0 THEN
638: oe_debug_pub.add( ' Calling PO_RCO_Validation_GRP.Update_ReqCancel_from_SO', 1 ) ;
639: oe_debug_pub.add( ' Cancelling Requisition Header', 1 ) ;
640: END IF;
641:
642: select order_number, last_update_date
643: into g_sales_order_number, g_order_cancellation_date

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

658:
659: SET_ORG_CONTEXT(l_original_org_id);
660:
661: IF l_debug_level > 0 THEN
662: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Update_ReqCancel_from_SO '||l_return_status, 1 ) ;
663: END IF;
664:
665: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
666: -- Sales order and corresponding internal requisition has been cancelled

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

680: l_create_notification := TRUE;
681:
682: ELSIF P_Cancel_Line THEN
683: IF l_debug_level > 0 THEN
684: oe_debug_pub.add( ' Calling PO_RCO_Validation_GRP.Update_ReqCancel_from_SO', 1 ) ;
685: oe_debug_pub.add( ' Cancelling Requisition Line', 1 ) ;
686: END IF;
687:
688: select order_number

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

681:
682: ELSIF P_Cancel_Line THEN
683: IF l_debug_level > 0 THEN
684: oe_debug_pub.add( ' Calling PO_RCO_Validation_GRP.Update_ReqCancel_from_SO', 1 ) ;
685: oe_debug_pub.add( ' Cancelling Requisition Line', 1 ) ;
686: END IF;
687:
688: select order_number
689: into g_sales_order_number

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

727:
728: SET_ORG_CONTEXT(l_original_org_id);
729:
730: IF l_debug_level > 0 THEN
731: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Update_ReqCancel_from_SO '||l_return_status, 5 ) ;
732: END IF;
733:
734: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
735: -- Sales order and corresponding internal requisition line has been cancelled

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

752: ELSIF (P_Quantity_Change IS NOT NULL AND P_Quantity_Change <> 0)
753: OR (P_New_Schedule_Ship_Date IS NOT NULL) THEN
754:
755: IF l_debug_level > 0 THEN
756: oe_debug_pub.add( ' Quantity OR Date changed. Req Line has to be updated', 5 ) ;
757: END IF;
758:
759: select order_number
760: into g_sales_order_number

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

795:
796: g_updated_quantity := g_requested_quantity + P_Quantity_Change;
797:
798: IF l_debug_level > 0 THEN
799: oe_debug_pub.add( ' Need By Date on Req Line is '||l_Req_Line_NeedByDate, 5 ) ;
800: END IF;
801:
802: IF (P_Quantity_Change IS NOT NULL AND P_Quantity_Change <> 0)
803: AND (P_New_Schedule_Ship_Date IS NOT NULL) THEN

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

807: l_New_Schedule_Ship_Date := NULL;
808: g_schedule_ship_date := NULL;
809: g_schedule_arrival_date := NULL;
810: IF l_debug_level > 0 THEN
811: oe_debug_pub.add( ' Ordered Quantity is changed. Update Req', 5 ) ;
812: END IF;
813: L_change := 'Q'; -- Quantity change
814: l_call_po_api_for_update := TRUE;
815: ELSE

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

815: ELSE
816: l_New_Schedule_Arrival_Date := g_schedule_arrival_date;
817: -- l_New_Schedule_Ship_Date := P_New_Schedule_Ship_Date;
818: IF l_debug_level > 0 THEN
819: oe_debug_pub.add( ' Ordered Quantity and Schedule Ship/Arrival Date are changed. Update Req', 5 ) ;
820: END IF;
821: L_change := 'B'; -- Both Date and Quantity change
822: l_call_po_api_for_update := TRUE;
823: END IF;

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

823: END IF;
824:
825: ELSIF P_Quantity_Change IS NOT NULL AND P_Quantity_Change <> 0 THEN
826: IF l_debug_level > 0 THEN
827: oe_debug_pub.add( ' Ordered Quantity is changed. Update Req', 5 ) ;
828: END IF;
829: L_change := 'Q'; -- Quantity change
830: g_schedule_ship_date := NULL;
831: g_schedule_arrival_date := NULL;

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

841: l_call_po_api_for_update := FALSE;
842: l_change := NULL; -- No date or quantity change
843:
844: IF l_debug_level > 0 THEN
845: oe_debug_pub.add( ' Neither Quantity nor date has changed', 5 ) ;
846: END IF;
847: ELSE
848: -- l_New_Schedule_Ship_Date := P_New_Schedule_Ship_Date;
849: l_New_Schedule_Arrival_Date := g_schedule_arrival_date;

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

847: ELSE
848: -- l_New_Schedule_Ship_Date := P_New_Schedule_Ship_Date;
849: l_New_Schedule_Arrival_Date := g_schedule_arrival_date;
850: IF l_debug_level > 0 THEN
851: oe_debug_pub.add( ' Schedule Ship/Arrival Date is changed. Update Req', 5 ) ;
852: END IF;
853: g_updated_quantity := NULL;
854: L_change := 'D'; -- Date Change
855: l_call_po_api_for_update := TRUE;

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

859:
860: IF l_call_po_api_for_update THEN
861:
862: IF l_debug_level > 0 THEN
863: oe_debug_pub.add( ' Calling PO_RCO_Validation_GRP.Update_ReqChange_from_SO', 1 ) ;
864: END IF;
865:
866: SET_ORG_CONTEXT(l_target_org_id);
867:

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

875:
876: SET_ORG_CONTEXT(l_original_org_id);
877:
878: IF l_debug_level > 0 THEN
879: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Update_ReqChange_from_SO '||l_return_status, 1);
880: END IF;
881:
882: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
883: IF L_change = 'Q' THEN -- Q => Quantity

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

915:
916: l_create_notification := TRUE;
917: ELSE
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add( ' Update_ReqChange_from_SO is not called as there is no valid change to process', 1);
920: END IF;
921: END IF;
922: END IF; -- p_cancel_order
923:

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

922: END IF; -- p_cancel_order
923:
924: IF OE_Schedule_GRP.G_ISO_Planning_Update THEN
925: IF l_debug_level > 0 THEN
926: oe_debug_pub.add(' The caller for this change is Planning. Hence notification will not be send',5);
927: END IF;
928: l_create_notification := FALSE;
929: END IF;
930:

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

929: END IF;
930:
931: IF l_create_notification THEN
932: IF l_debug_level > 0 THEN
933: oe_debug_pub.add( ' Preparing Notification ', 1 ) ;
934: END IF;
935:
936: IF P_Cancel_Order THEN
937: IF p_num_records > 0 THEN

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

964: ELSE
965: l_line_ids_tbl.Extend(1);
966: l_line_ids_tbl(1) := p_line_id;
967: IF l_debug_level >0 THEN
968: oe_debug_pub.add(' Not a header cancellation. Line is : '||l_line_ids_tbl(1));
969: END IF;
970: END IF;
971:
972: SET_ORG_CONTEXT(l_target_org_id);

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

980:
981: SET_ORG_CONTEXT(l_original_org_id);
982:
983: IF l_debug_level > 0 THEN
984: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Get_Preparer_Name '||l_return_status, 1 ) ;
985: END IF;
986:
987: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
988: -- Unable to save the changes as the corresponding Internal Requisition can not be updated

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

996: END IF;
997:
998: IF l_preparer_name IS NULL THEN
999: IF l_debug_level > 0 THEN
1000: oe_debug_pub.add( ' The preparer name is null. Setting it to SYSADMIN ',1);
1001: END IF;
1002: l_preparer_name := 'SYSADMIN';
1003: ELSE
1004: IF l_debug_level > 0 THEN

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

1001: END IF;
1002: l_preparer_name := 'SYSADMIN';
1003: ELSE
1004: IF l_debug_level > 0 THEN
1005: oe_debug_pub.add( ' The preparer name is '||l_preparer_name);
1006: END IF;
1007: END IF;
1008:
1009: Prepare_Notification

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

1049: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1050: P_Data => x_msg_Data);
1051:
1052: IF l_debug_level > 0 THEN
1053: oe_debug_pub.add( 'EXITING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
1054: END IF;
1055:
1056: Exception
1057: WHEN FND_API.G_EXC_ERROR THEN

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

1064: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1065: P_Data => x_msg_Data);
1066:
1067: WHEN OTHERS THEN
1068: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Update_Internal_Requisition '||sqlerrm,1);
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1071: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Internal_Requisition');
1072: -- Pkg Body global variable = OE_Process_Requisition_Pvt