DBA Data[Home] [Help]

APPS.OE_PROCESS_REQUISITION_PVT dependencies on OE_GLOBALS

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 647: g_reason := OE_GLOBALS.G_REASON_CODE;

643: into g_sales_order_number, g_order_cancellation_date
644: from oe_order_headers_all
645: where header_id = p_header_id;
646:
647: g_reason := OE_GLOBALS.G_REASON_CODE;
648: -- 'OE_GLOBALS.G_REASON_COMMENTS'
649:
650: SET_ORG_CONTEXT(l_target_org_id);
651:

Line 648: -- 'OE_GLOBALS.G_REASON_COMMENTS'

644: from oe_order_headers_all
645: where header_id = p_header_id;
646:
647: g_reason := OE_GLOBALS.G_REASON_CODE;
648: -- 'OE_GLOBALS.G_REASON_COMMENTS'
649:
650: SET_ORG_CONTEXT(l_target_org_id);
651:
652: PO_RCO_Validation_GRP.Update_ReqCancel_from_SO

Line 716: g_reason := OE_GLOBALS.G_REASON_CODE;

712: and fsp.inventory_organization_id = items.organization_id
713: and prl.item_id = items.inventory_item_id
714: and prl.requisition_line_id = P_Req_Line_id;
715:
716: g_reason := OE_GLOBALS.G_REASON_CODE;
717: -- 'OE_GLOBALS.G_REASON_COMMENTS'
718:
719: SET_ORG_CONTEXT(l_target_org_id);
720:

Line 717: -- 'OE_GLOBALS.G_REASON_COMMENTS'

713: and prl.item_id = items.inventory_item_id
714: and prl.requisition_line_id = P_Req_Line_id;
715:
716: g_reason := OE_GLOBALS.G_REASON_CODE;
717: -- 'OE_GLOBALS.G_REASON_COMMENTS'
718:
719: SET_ORG_CONTEXT(l_target_org_id);
720:
721: PO_RCO_Validation_GRP.Update_ReqCancel_from_SO

Line 805: -- IF oe_globals.equal(P_New_Schedule_Ship_Date , l_Req_Line_NeedByDate) THEN

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
804:
805: -- IF oe_globals.equal(P_New_Schedule_Ship_Date , l_Req_Line_NeedByDate) THEN
806: IF oe_globals.equal(g_schedule_arrival_date, l_Req_Line_NeedByDate) THEN
807: l_New_Schedule_Ship_Date := NULL;
808: g_schedule_ship_date := NULL;
809: g_schedule_arrival_date := NULL;

Line 806: IF oe_globals.equal(g_schedule_arrival_date, l_Req_Line_NeedByDate) THEN

802: IF (P_Quantity_Change IS NOT NULL AND P_Quantity_Change <> 0)
803: AND (P_New_Schedule_Ship_Date IS NOT NULL) THEN
804:
805: -- IF oe_globals.equal(P_New_Schedule_Ship_Date , l_Req_Line_NeedByDate) THEN
806: IF oe_globals.equal(g_schedule_arrival_date, l_Req_Line_NeedByDate) THEN
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

Line 835: -- IF oe_globals.equal(P_New_Schedule_Ship_Date , l_Req_Line_NeedByDate) THEN

831: g_schedule_arrival_date := NULL;
832: l_call_po_api_for_update := TRUE;
833:
834: ELSIF P_New_Schedule_Ship_Date IS NOT NULL THEN
835: -- IF oe_globals.equal(P_New_Schedule_Ship_Date , l_Req_Line_NeedByDate) THEN
836: IF oe_globals.equal(g_schedule_arrival_date, l_Req_Line_NeedByDate) THEN
837: l_New_Schedule_Ship_Date := NULL;
838: g_schedule_ship_date := NULL;
839: g_schedule_arrival_date := NULL;

Line 836: IF oe_globals.equal(g_schedule_arrival_date, l_Req_Line_NeedByDate) THEN

832: l_call_po_api_for_update := TRUE;
833:
834: ELSIF P_New_Schedule_Ship_Date IS NOT NULL THEN
835: -- IF oe_globals.equal(P_New_Schedule_Ship_Date , l_Req_Line_NeedByDate) THEN
836: IF oe_globals.equal(g_schedule_arrival_date, l_Req_Line_NeedByDate) THEN
837: l_New_Schedule_Ship_Date := NULL;
838: g_schedule_ship_date := NULL;
839: g_schedule_arrival_date := NULL;
840: g_updated_quantity := NULL;

Line 886: g_reason := OE_GLOBALS.G_REASON_CODE;

882: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
883: IF L_change = 'Q' THEN -- Q => Quantity
884: -- Ordered quantity, Supply picture, and corresponding internal
885: -- requisition line have been updated
886: g_reason := OE_GLOBALS.G_REASON_CODE;
887: -- 'OE_GLOBALS.G_REASON_COMMENTS'
888: FND_Message.Set_Name('ONT', 'OE_IRCMS_QTY_UDPATE');
889: OE_MSG_PUB.Add;
890: ELSIF L_change = 'D' THEN -- D => Date

Line 887: -- 'OE_GLOBALS.G_REASON_COMMENTS'

883: IF L_change = 'Q' THEN -- Q => Quantity
884: -- Ordered quantity, Supply picture, and corresponding internal
885: -- requisition line have been updated
886: g_reason := OE_GLOBALS.G_REASON_CODE;
887: -- 'OE_GLOBALS.G_REASON_COMMENTS'
888: FND_Message.Set_Name('ONT', 'OE_IRCMS_QTY_UDPATE');
889: OE_MSG_PUB.Add;
890: ELSIF L_change = 'D' THEN -- D => Date
891: -- Schedule Ship/Arrival date and corresponding internal

Line 893: g_reason := OE_GLOBALS.G_REASON_CODE;

889: OE_MSG_PUB.Add;
890: ELSIF L_change = 'D' THEN -- D => Date
891: -- Schedule Ship/Arrival date and corresponding internal
892: -- requisition line have been updated
893: g_reason := OE_GLOBALS.G_REASON_CODE;
894: -- 'OE_GLOBALS.G_REASON_COMMENTS'
895: FND_Message.Set_Name('ONT', 'OE_IRCMS_DATE_UDPATE');
896: OE_MSG_PUB.Add;
897: ELSIF L_change = 'B' THEN -- B => Both Date and Quantity

Line 894: -- 'OE_GLOBALS.G_REASON_COMMENTS'

890: ELSIF L_change = 'D' THEN -- D => Date
891: -- Schedule Ship/Arrival date and corresponding internal
892: -- requisition line have been updated
893: g_reason := OE_GLOBALS.G_REASON_CODE;
894: -- 'OE_GLOBALS.G_REASON_COMMENTS'
895: FND_Message.Set_Name('ONT', 'OE_IRCMS_DATE_UDPATE');
896: OE_MSG_PUB.Add;
897: ELSIF L_change = 'B' THEN -- B => Both Date and Quantity
898: -- Schedule Ship/Arrival date, Ordered quantity, Supply picture,

Line 900: g_reason := OE_GLOBALS.G_REASON_CODE;

896: OE_MSG_PUB.Add;
897: ELSIF L_change = 'B' THEN -- B => Both Date and Quantity
898: -- Schedule Ship/Arrival date, Ordered quantity, Supply picture,
899: -- and corresponding internal requisition line have been updated
900: g_reason := OE_GLOBALS.G_REASON_CODE;
901: -- 'OE_GLOBALS.G_REASON_COMMENTS'
902: FND_Message.Set_Name('ONT', 'OE_IRCMS_QTY_DATE_UDPATE');
903: OE_MSG_PUB.Add;
904: END IF;

Line 901: -- 'OE_GLOBALS.G_REASON_COMMENTS'

897: ELSIF L_change = 'B' THEN -- B => Both Date and Quantity
898: -- Schedule Ship/Arrival date, Ordered quantity, Supply picture,
899: -- and corresponding internal requisition line have been updated
900: g_reason := OE_GLOBALS.G_REASON_CODE;
901: -- 'OE_GLOBALS.G_REASON_COMMENTS'
902: FND_Message.Set_Name('ONT', 'OE_IRCMS_QTY_DATE_UDPATE');
903: OE_MSG_PUB.Add;
904: END IF;
905: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN