DBA Data[Home] [Help]

APPS.OE_SCHEDULE_GRP dependencies on OE_SCHEDULE_GRP

Line 1: PACKAGE BODY OE_SCHEDULE_GRP AS

1: PACKAGE BODY OE_SCHEDULE_GRP AS
2: /* $Header: OEXGSCHB.pls 120.7.12010000.5 2009/01/07 05:27:04 vbkapoor ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_SCHEDULE_GRP';
5: G_SCH_TBL sch_tbl_type;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_SCHEDULE_GRP';

1: PACKAGE BODY OE_SCHEDULE_GRP AS
2: /* $Header: OEXGSCHB.pls 120.7.12010000.5 2009/01/07 05:27:04 vbkapoor ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_SCHEDULE_GRP';
5: G_SCH_TBL sch_tbl_type;
6: G_LINE_TBL OE_Order_PUB.Line_Tbl_Type;
7: G_OLD_LINE_TBL OE_Order_PUB.Line_Tbl_Type;
8:

Line 40: oe_debug_pub.add('Entering oe_schedule_grp.update_scheduling_results' || p_x_sch_tbl.count ,1);

36: l_orig_resp_appl_id NUMBER;
37: J NUMBER;
38: BEGIN
39:
40: oe_debug_pub.add('Entering oe_schedule_grp.update_scheduling_results' || p_x_sch_tbl.count ,1);
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42:
43: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL > '110509' THEN
44: l_count := p_x_sch_tbl.count;

Line 120: oe_debug_pub.add('Exiting oe_schedule_grp.update_scheduling_results' ||

116: END IF; -- Code release.
117:
118: oe_msg_pub.save_messages(p_request_id => p_request_id);
119:
120: oe_debug_pub.add('Exiting oe_schedule_grp.update_scheduling_results' ||
121: x_return_status,1);
122:
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN

Line 165: oe_debug_pub.add('Entering oe_schedule_grp.Process_order',1);

161: l_index Number;
162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
163: BEGIN
164:
165: oe_debug_pub.add('Entering oe_schedule_grp.Process_order',1);
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:
168: -- This variable is to track that the Item is being Substituted by Planning Loop Back and not being changed manully by user.
169: -- Initializing to 'N' for current set of Lines. Will set it to Y if any item substitutions are happening.

Line 175: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;

171:
172: -- Bug #7667702: Tracking bug for IR ISO CMS Project
173: -- Since, in this code, caller can only be Planning (Planning Workbench
174: -- or DRP), setting the global with default value FALSE
175: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;
176:
177:
178: Validate_sch_data(x_return_status => l_return_status);
179: l_count := 1;

Line 706: OE_Schedule_GRP.G_ISO_Planning_Update := TRUE;

702: -- This global will even be used to supress the notification to be send
703: -- to Purchasing user for teh corresponding internal requisition, when the
704: -- changes are from Planning user
705: --
706: OE_Schedule_GRP.G_ISO_Planning_Update := TRUE;
707: IF l_debug_level > 0 THEN
708: oe_debug_pub.add(' Setting global OE_Schedule_GRP.G_ISO_Planning_Update to TRUE',5);
709: END IF;
710: --

Line 708: oe_debug_pub.add(' Setting global OE_Schedule_GRP.G_ISO_Planning_Update to TRUE',5);

704: -- changes are from Planning user
705: --
706: OE_Schedule_GRP.G_ISO_Planning_Update := TRUE;
707: IF l_debug_level > 0 THEN
708: oe_debug_pub.add(' Setting global OE_Schedule_GRP.G_ISO_Planning_Update to TRUE',5);
709: END IF;
710: --
711:
712: IF l_ship_from_is_changed

Line 813: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;

809:
810: -- Bug #7576948: For IR ISO CMS Project
811: -- Ressting the global to FALSE
812: --
813: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;
814: IF l_debug_level > 0 THEN
815: oe_debug_pub.add(' Setting global OE_Schedule_GRP.G_ISO_Planning_Update to FALSE',5);
816: END IF;
817: --

Line 815: oe_debug_pub.add(' Setting global OE_Schedule_GRP.G_ISO_Planning_Update to FALSE',5);

811: -- Ressting the global to FALSE
812: --
813: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;
814: IF l_debug_level > 0 THEN
815: oe_debug_pub.add(' Setting global OE_Schedule_GRP.G_ISO_Planning_Update to FALSE',5);
816: END IF;
817: --
818:
819:

Line 843: oe_debug_pub.add('Entering oe_schedule_grp.Process_order',1);

839:
840: g_line_tbl.delete;
841: g_old_line_tbl.delete;
842:
843: oe_debug_pub.add('Entering oe_schedule_grp.Process_order',1);
844: EXCEPTION
845: WHEN FND_API.G_EXC_ERROR THEN
846:
847: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;

Line 847: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;

843: oe_debug_pub.add('Entering oe_schedule_grp.Process_order',1);
844: EXCEPTION
845: WHEN FND_API.G_EXC_ERROR THEN
846:
847: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;
848: -- Added for IR ISO Tracking bug 7667702
849:
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: g_line_tbl.delete;

Line 856: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;

852: g_old_line_tbl.delete;
853:
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855:
856: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;
857: -- Added for IR ISO Tracking bug 7667702
858:
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
860: g_line_tbl.delete;

Line 865: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;

861: g_old_line_tbl.delete;
862:
863: WHEN OTHERS THEN
864:
865: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;
866: -- Added for IR ISO Tracking bug 7667702
867:
868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869: g_line_tbl.delete;

Line 1450: END OE_SCHEDULE_GRP;

1446: );
1447: END IF;
1448: END Update_Reservation;
1449:
1450: END OE_SCHEDULE_GRP;