DBA Data[Home] [Help]

APPS.OE_PROCESS_REQUISITION_PVT dependencies on OE_GLOBALS

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

691: into g_sales_order_number, g_order_cancellation_date
692: from oe_order_headers_all
693: where header_id = p_header_id;
694:
695: g_reason := OE_GLOBALS.G_REASON_CODE;
696: -- 'OE_GLOBALS.G_REASON_COMMENTS'
697:
698: -- Added for 8583903
699: open Cancel_Lines;

Line 696: -- 'OE_GLOBALS.G_REASON_COMMENTS'

692: from oe_order_headers_all
693: where header_id = p_header_id;
694:
695: g_reason := OE_GLOBALS.G_REASON_CODE;
696: -- 'OE_GLOBALS.G_REASON_COMMENTS'
697:
698: -- Added for 8583903
699: open Cancel_Lines;
700: loop

Line 787: g_reason := OE_GLOBALS.G_REASON_CODE;

783: and fsp.inventory_organization_id = items.organization_id
784: and prl.item_id = items.inventory_item_id
785: and prl.requisition_line_id = P_Req_Line_id;
786:
787: g_reason := OE_GLOBALS.G_REASON_CODE;
788: -- 'OE_GLOBALS.G_REASON_COMMENTS'
789:
790: -- Added for 8583903
791: l_req_line_id_tbl(1) := p_req_line_id;

Line 788: -- 'OE_GLOBALS.G_REASON_COMMENTS'

784: and prl.item_id = items.inventory_item_id
785: and prl.requisition_line_id = P_Req_Line_id;
786:
787: g_reason := OE_GLOBALS.G_REASON_CODE;
788: -- 'OE_GLOBALS.G_REASON_COMMENTS'
789:
790: -- Added for 8583903
791: l_req_line_id_tbl(1) := p_req_line_id;
792: l_req_can_qty_tbl(1) := -P_Quantity_Change ; --Bug12970870

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

900: OR (P_Quantity2_Change IS NOT NULL AND P_Quantity2_Change <> 0))
901: AND (P_New_Schedule_Ship_Date IS NOT NULL) THEN
902:
903:
904: -- IF oe_globals.equal(P_New_Schedule_Ship_Date , l_Req_Line_NeedByDate) THEN
905: IF oe_globals.equal(g_schedule_arrival_date, l_Req_Line_NeedByDate) THEN
906: l_New_Schedule_Ship_Date := NULL;
907: g_schedule_ship_date := NULL;
908: g_schedule_arrival_date := NULL;

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

901: AND (P_New_Schedule_Ship_Date IS NOT NULL) THEN
902:
903:
904: -- IF oe_globals.equal(P_New_Schedule_Ship_Date , l_Req_Line_NeedByDate) THEN
905: IF oe_globals.equal(g_schedule_arrival_date, l_Req_Line_NeedByDate) THEN
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

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

933: g_schedule_arrival_date := NULL;
934: l_call_po_api_for_update := TRUE;
935:
936: ELSIF P_New_Schedule_Ship_Date IS NOT NULL THEN
937: -- IF oe_globals.equal(P_New_Schedule_Ship_Date , l_Req_Line_NeedByDate) THEN
938: IF oe_globals.equal(g_schedule_arrival_date, l_Req_Line_NeedByDate) THEN
939: l_New_Schedule_Ship_Date := NULL;
940: g_schedule_ship_date := NULL;
941: g_schedule_arrival_date := NULL;

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

934: l_call_po_api_for_update := TRUE;
935:
936: ELSIF P_New_Schedule_Ship_Date IS NOT NULL THEN
937: -- IF oe_globals.equal(P_New_Schedule_Ship_Date , l_Req_Line_NeedByDate) THEN
938: IF oe_globals.equal(g_schedule_arrival_date, l_Req_Line_NeedByDate) THEN
939: l_New_Schedule_Ship_Date := NULL;
940: g_schedule_ship_date := NULL;
941: g_schedule_arrival_date := NULL;
942: g_updated_quantity := NULL;

Line 990: g_reason := OE_GLOBALS.G_REASON_CODE;

986: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
987: IF L_change = 'Q' THEN -- Q => Quantity
988: -- Ordered quantity, Supply picture, and corresponding internal
989: -- requisition line have been updated
990: g_reason := OE_GLOBALS.G_REASON_CODE;
991: -- 'OE_GLOBALS.G_REASON_COMMENTS'
992: FND_Message.Set_Name('ONT', 'OE_IRCMS_QTY_UDPATE');
993: OE_MSG_PUB.Add;
994: ELSIF L_change = 'D' THEN -- D => Date

Line 991: -- 'OE_GLOBALS.G_REASON_COMMENTS'

987: IF L_change = 'Q' THEN -- Q => Quantity
988: -- Ordered quantity, Supply picture, and corresponding internal
989: -- requisition line have been updated
990: g_reason := OE_GLOBALS.G_REASON_CODE;
991: -- 'OE_GLOBALS.G_REASON_COMMENTS'
992: FND_Message.Set_Name('ONT', 'OE_IRCMS_QTY_UDPATE');
993: OE_MSG_PUB.Add;
994: ELSIF L_change = 'D' THEN -- D => Date
995: -- Schedule Ship/Arrival date and corresponding internal

Line 997: g_reason := OE_GLOBALS.G_REASON_CODE;

993: OE_MSG_PUB.Add;
994: ELSIF L_change = 'D' THEN -- D => Date
995: -- Schedule Ship/Arrival date and corresponding internal
996: -- requisition line have been updated
997: g_reason := OE_GLOBALS.G_REASON_CODE;
998: -- 'OE_GLOBALS.G_REASON_COMMENTS'
999: FND_Message.Set_Name('ONT', 'OE_IRCMS_DATE_UDPATE');
1000: OE_MSG_PUB.Add;
1001: ELSIF L_change = 'B' THEN -- B => Both Date and Quantity

Line 998: -- 'OE_GLOBALS.G_REASON_COMMENTS'

994: ELSIF L_change = 'D' THEN -- D => Date
995: -- Schedule Ship/Arrival date and corresponding internal
996: -- requisition line have been updated
997: g_reason := OE_GLOBALS.G_REASON_CODE;
998: -- 'OE_GLOBALS.G_REASON_COMMENTS'
999: FND_Message.Set_Name('ONT', 'OE_IRCMS_DATE_UDPATE');
1000: OE_MSG_PUB.Add;
1001: ELSIF L_change = 'B' THEN -- B => Both Date and Quantity
1002: -- Schedule Ship/Arrival date, Ordered quantity, Supply picture,

Line 1004: g_reason := OE_GLOBALS.G_REASON_CODE;

1000: OE_MSG_PUB.Add;
1001: ELSIF L_change = 'B' THEN -- B => Both Date and Quantity
1002: -- Schedule Ship/Arrival date, Ordered quantity, Supply picture,
1003: -- and corresponding internal requisition line have been updated
1004: g_reason := OE_GLOBALS.G_REASON_CODE;
1005: -- 'OE_GLOBALS.G_REASON_COMMENTS'
1006: FND_Message.Set_Name('ONT', 'OE_IRCMS_QTY_DATE_UDPATE');
1007: OE_MSG_PUB.Add;
1008: END IF;

Line 1005: -- 'OE_GLOBALS.G_REASON_COMMENTS'

1001: ELSIF L_change = 'B' THEN -- B => Both Date and Quantity
1002: -- Schedule Ship/Arrival date, Ordered quantity, Supply picture,
1003: -- and corresponding internal requisition line have been updated
1004: g_reason := OE_GLOBALS.G_REASON_CODE;
1005: -- 'OE_GLOBALS.G_REASON_COMMENTS'
1006: FND_Message.Set_Name('ONT', 'OE_IRCMS_QTY_DATE_UDPATE');
1007: OE_MSG_PUB.Add;
1008: END IF;
1009: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN