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.MSC_ATP_FUNC dependencies on MSC_SCH_WB

Line 21: msc_sch_wb.atp_debug('inside get_atp_flag');

17:
18: BEGIN
19:
20: IF PG_DEBUG in ('Y', 'C') THEN
21: msc_sch_wb.atp_debug('inside get_atp_flag');
22: msc_sch_wb.atp_debug('get_atp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
23: msc_sch_wb.atp_debug('get_atp_flag: ' || 'organization_id = '||p_organization_id);
24: msc_sch_wb.atp_debug('get_atp_flag: ' || 'plan_id = '||p_plan_id);
25: msc_sch_wb.atp_debug('get_atp_flag: ' || 'sr_instance_id = '||p_instance_id);

Line 22: msc_sch_wb.atp_debug('get_atp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);

18: BEGIN
19:
20: IF PG_DEBUG in ('Y', 'C') THEN
21: msc_sch_wb.atp_debug('inside get_atp_flag');
22: msc_sch_wb.atp_debug('get_atp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
23: msc_sch_wb.atp_debug('get_atp_flag: ' || 'organization_id = '||p_organization_id);
24: msc_sch_wb.atp_debug('get_atp_flag: ' || 'plan_id = '||p_plan_id);
25: msc_sch_wb.atp_debug('get_atp_flag: ' || 'sr_instance_id = '||p_instance_id);
26: END IF;

Line 23: msc_sch_wb.atp_debug('get_atp_flag: ' || 'organization_id = '||p_organization_id);

19:
20: IF PG_DEBUG in ('Y', 'C') THEN
21: msc_sch_wb.atp_debug('inside get_atp_flag');
22: msc_sch_wb.atp_debug('get_atp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
23: msc_sch_wb.atp_debug('get_atp_flag: ' || 'organization_id = '||p_organization_id);
24: msc_sch_wb.atp_debug('get_atp_flag: ' || 'plan_id = '||p_plan_id);
25: msc_sch_wb.atp_debug('get_atp_flag: ' || 'sr_instance_id = '||p_instance_id);
26: END IF;
27:

Line 24: msc_sch_wb.atp_debug('get_atp_flag: ' || 'plan_id = '||p_plan_id);

20: IF PG_DEBUG in ('Y', 'C') THEN
21: msc_sch_wb.atp_debug('inside get_atp_flag');
22: msc_sch_wb.atp_debug('get_atp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
23: msc_sch_wb.atp_debug('get_atp_flag: ' || 'organization_id = '||p_organization_id);
24: msc_sch_wb.atp_debug('get_atp_flag: ' || 'plan_id = '||p_plan_id);
25: msc_sch_wb.atp_debug('get_atp_flag: ' || 'sr_instance_id = '||p_instance_id);
26: END IF;
27:
28: -- Changed on 1/23/2001 by ngoel. In case of multi-level/multi-org CTO

Line 25: msc_sch_wb.atp_debug('get_atp_flag: ' || 'sr_instance_id = '||p_instance_id);

21: msc_sch_wb.atp_debug('inside get_atp_flag');
22: msc_sch_wb.atp_debug('get_atp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
23: msc_sch_wb.atp_debug('get_atp_flag: ' || 'organization_id = '||p_organization_id);
24: msc_sch_wb.atp_debug('get_atp_flag: ' || 'plan_id = '||p_plan_id);
25: msc_sch_wb.atp_debug('get_atp_flag: ' || 'sr_instance_id = '||p_instance_id);
26: END IF;
27:
28: -- Changed on 1/23/2001 by ngoel. In case of multi-level/multi-org CTO
29: -- we need to set this flag to No in case the atp check flag is set to

Line 80: msc_sch_wb.atp_debug('inside get_atp_comp_flag');

76: l_atp_check NUMBER;
77: BEGIN
78:
79: IF PG_DEBUG in ('Y', 'C') THEN
80: msc_sch_wb.atp_debug('inside get_atp_comp_flag');
81: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
82: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'organization_id = '||p_organization_id);
83: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'plan_id = '||p_plan_id);
84: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_instance_id = '||p_instance_id);

Line 81: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);

77: BEGIN
78:
79: IF PG_DEBUG in ('Y', 'C') THEN
80: msc_sch_wb.atp_debug('inside get_atp_comp_flag');
81: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
82: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'organization_id = '||p_organization_id);
83: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'plan_id = '||p_plan_id);
84: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_instance_id = '||p_instance_id);
85: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ORDER_LINE_ID = '||MSC_ATP_PVT.G_ORDER_LINE_ID);

Line 82: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'organization_id = '||p_organization_id);

78:
79: IF PG_DEBUG in ('Y', 'C') THEN
80: msc_sch_wb.atp_debug('inside get_atp_comp_flag');
81: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
82: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'organization_id = '||p_organization_id);
83: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'plan_id = '||p_plan_id);
84: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_instance_id = '||p_instance_id);
85: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ORDER_LINE_ID = '||MSC_ATP_PVT.G_ORDER_LINE_ID);
86: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ASSEMBLY_LINE_ID = '||MSC_ATP_PVT.G_ASSEMBLY_LINE_ID);

Line 83: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'plan_id = '||p_plan_id);

79: IF PG_DEBUG in ('Y', 'C') THEN
80: msc_sch_wb.atp_debug('inside get_atp_comp_flag');
81: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
82: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'organization_id = '||p_organization_id);
83: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'plan_id = '||p_plan_id);
84: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_instance_id = '||p_instance_id);
85: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ORDER_LINE_ID = '||MSC_ATP_PVT.G_ORDER_LINE_ID);
86: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ASSEMBLY_LINE_ID = '||MSC_ATP_PVT.G_ASSEMBLY_LINE_ID);
87: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_COMP_LINE_ID = '||MSC_ATP_PVT.G_COMP_LINE_ID);

Line 84: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_instance_id = '||p_instance_id);

80: msc_sch_wb.atp_debug('inside get_atp_comp_flag');
81: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
82: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'organization_id = '||p_organization_id);
83: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'plan_id = '||p_plan_id);
84: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_instance_id = '||p_instance_id);
85: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ORDER_LINE_ID = '||MSC_ATP_PVT.G_ORDER_LINE_ID);
86: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ASSEMBLY_LINE_ID = '||MSC_ATP_PVT.G_ASSEMBLY_LINE_ID);
87: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_COMP_LINE_ID = '||MSC_ATP_PVT.G_COMP_LINE_ID);
88: END IF;

Line 85: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ORDER_LINE_ID = '||MSC_ATP_PVT.G_ORDER_LINE_ID);

81: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
82: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'organization_id = '||p_organization_id);
83: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'plan_id = '||p_plan_id);
84: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_instance_id = '||p_instance_id);
85: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ORDER_LINE_ID = '||MSC_ATP_PVT.G_ORDER_LINE_ID);
86: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ASSEMBLY_LINE_ID = '||MSC_ATP_PVT.G_ASSEMBLY_LINE_ID);
87: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_COMP_LINE_ID = '||MSC_ATP_PVT.G_COMP_LINE_ID);
88: END IF;
89:

Line 86: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ASSEMBLY_LINE_ID = '||MSC_ATP_PVT.G_ASSEMBLY_LINE_ID);

82: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'organization_id = '||p_organization_id);
83: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'plan_id = '||p_plan_id);
84: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_instance_id = '||p_instance_id);
85: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ORDER_LINE_ID = '||MSC_ATP_PVT.G_ORDER_LINE_ID);
86: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ASSEMBLY_LINE_ID = '||MSC_ATP_PVT.G_ASSEMBLY_LINE_ID);
87: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_COMP_LINE_ID = '||MSC_ATP_PVT.G_COMP_LINE_ID);
88: END IF;
89:
90: -- Fix for Bug 1413039 9/22/00 - NGOEL

Line 87: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_COMP_LINE_ID = '||MSC_ATP_PVT.G_COMP_LINE_ID);

83: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'plan_id = '||p_plan_id);
84: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_instance_id = '||p_instance_id);
85: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ORDER_LINE_ID = '||MSC_ATP_PVT.G_ORDER_LINE_ID);
86: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ASSEMBLY_LINE_ID = '||MSC_ATP_PVT.G_ASSEMBLY_LINE_ID);
87: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_COMP_LINE_ID = '||MSC_ATP_PVT.G_COMP_LINE_ID);
88: END IF;
89:
90: -- Fix for Bug 1413039 9/22/00 - NGOEL
91: -- Since we don't support multi-level ATP for ODS, set

Line 95: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_INV_CTP = '||MSC_ATP_PVT.G_INV_CTP);

91: -- Since we don't support multi-level ATP for ODS, set
92: -- return ATP component flag as N in case of ODS.
93:
94: IF PG_DEBUG in ('Y', 'C') THEN
95: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_INV_CTP = '||MSC_ATP_PVT.G_INV_CTP);
96: END IF;
97: IF MSC_ATP_PVT.G_INV_CTP = 5 THEN
98: l_atp_comp_flag := 'N';
99:

Line 114: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_bom_item_type = '||l_bom_item_type);

110: AND plan_id = -1
111: AND sr_instance_id = p_instance_id;
112:
113: IF PG_DEBUG in ('Y', 'C') THEN
114: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_bom_item_type = '||l_bom_item_type);
115: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_pick_comp_flag = '||l_pick_comp_flag);
116: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_replenish_flag = '||l_replenish_flag);
117: END IF;
118:

Line 115: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_pick_comp_flag = '||l_pick_comp_flag);

111: AND sr_instance_id = p_instance_id;
112:
113: IF PG_DEBUG in ('Y', 'C') THEN
114: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_bom_item_type = '||l_bom_item_type);
115: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_pick_comp_flag = '||l_pick_comp_flag);
116: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_replenish_flag = '||l_replenish_flag);
117: END IF;
118:
119: IF l_bom_item_type in (1, 2) THEN

Line 116: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_replenish_flag = '||l_replenish_flag);

112:
113: IF PG_DEBUG in ('Y', 'C') THEN
114: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_bom_item_type = '||l_bom_item_type);
115: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_pick_comp_flag = '||l_pick_comp_flag);
116: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_replenish_flag = '||l_replenish_flag);
117: END IF;
118:
119: IF l_bom_item_type in (1, 2) THEN
120: -- since bom team does the explosion for the model and option class

Line 153: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_cto_bom = '||l_cto_bom);

149: -- When a BOM exists in MSC_BOM_TEMP table, modify flags to always check for
150: -- material.
151:
152: IF PG_DEBUG in ('Y', 'C') THEN
153: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_cto_bom = '||l_cto_bom);
154: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_CTO_LINE = '||MSC_ATP_PVT.G_CTO_LINE);
155: END IF;
156:
157: IF ((NVL(l_pick_comp_flag, 'N') = 'N') AND (NVL(l_replenish_flag, 'N') = 'Y')) AND

Line 154: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_CTO_LINE = '||MSC_ATP_PVT.G_CTO_LINE);

150: -- material.
151:
152: IF PG_DEBUG in ('Y', 'C') THEN
153: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_cto_bom = '||l_cto_bom);
154: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_CTO_LINE = '||MSC_ATP_PVT.G_CTO_LINE);
155: END IF;
156:
157: IF ((NVL(l_pick_comp_flag, 'N') = 'N') AND (NVL(l_replenish_flag, 'N') = 'Y')) AND
158: (NVL(MSC_ATP_PVT.G_CTO_LINE, 'N') = 'Y') AND (l_bom_item_type = 1) THEN

Line 181: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_atp_check : '||l_atp_check);

177: AND component_identifier = MSC_ATP_PVT.G_COMP_LINE_ID
178: AND session_id = MSC_ATP_PVT.G_SESSION_ID;
179:
180: IF PG_DEBUG in ('Y', 'C') THEN
181: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_atp_check : '||l_atp_check);
182: END IF;
183:
184: IF l_bom_item_type = 4 AND NVL(l_atp_check, -1) = 2 THEN
185: l_atp_comp_flag := 'N';

Line 200: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sqlcode : '||sqlcode);

196: return l_atp_comp_flag;
197: EXCEPTION
198: WHEN NO_DATA_FOUND THEN
199: IF PG_DEBUG in ('Y', 'C') THEN
200: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sqlcode : '||sqlcode);
201: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sqlerr : '||sqlerrm);
202: END IF;
203: return 'N';
204: END get_atp_comp_flag;

Line 201: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sqlerr : '||sqlerrm);

197: EXCEPTION
198: WHEN NO_DATA_FOUND THEN
199: IF PG_DEBUG in ('Y', 'C') THEN
200: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sqlcode : '||sqlcode);
201: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sqlerr : '||sqlerrm);
202: END IF;
203: return 'N';
204: END get_atp_comp_flag;
205:

Line 282: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting infinite_time_fence_date, MSC_ATP_PVT.G_INV_CTP = 4');

278: BEGIN
279: /* for 1478110. please refer to the BUG
280: IF p_plan_id <> -1 THEN
281: IF PG_DEBUG in ('Y', 'C') THEN
282: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting infinite_time_fence_date, MSC_ATP_PVT.G_INV_CTP = 4');
283: END IF;
284:
285: SELECT curr_cutoff_date
286: INTO l_infinite_time_fence_date

Line 290: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'l_infinite_time_fence_date'||l_infinite_time_fence_date);

286: INTO l_infinite_time_fence_date
287: FROM msc_plans
288: WHERE plan_id = p_plan_id;
289: IF PG_DEBUG in ('Y', 'C') THEN
290: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'l_infinite_time_fence_date'||l_infinite_time_fence_date);
291: END IF;
292: ELSE
293:
294: IF PG_DEBUG in ('Y', 'C') THEN

Line 295: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting infinite_time_fence_date, MSC_ATP_PVT.G_INV_CTP = 5');

291: END IF;
292: ELSE
293:
294: IF PG_DEBUG in ('Y', 'C') THEN
295: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting infinite_time_fence_date, MSC_ATP_PVT.G_INV_CTP = 5');
296: END IF;
297: */
298:
299: -- Bug 1566260, in case of modle or option class for PDS ATP, return null.

Line 306: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting item type for PDS');

302: -- demand entries could be stored for planning purposes.
303:
304: IF p_plan_id <> -1 THEN
305: IF PG_DEBUG in ('Y', 'C') THEN
306: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting item type for PDS');
307: END IF;
308: SELECT i.bom_item_type
309: INTO l_item_type
310: FROM msc_system_items i

Line 319: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'PDS item type is model(1) or option class(2) : '||l_item_type);

315: END IF;
316:
317: IF nvl(l_item_type, -1) IN (1,2) THEN
318: IF PG_DEBUG in ('Y', 'C') THEN
319: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'PDS item type is model(1) or option class(2) : '||l_item_type);
320: END IF;
321: l_infinite_time_fence_date := null;
322: ELSE
323:

Line 328: msc_sch_wb.atp_debug('get_infinite_time_fence_date: Profile value for Infinite Supply Pad');

324: -- Bug 2877340, 2746213
325: -- Read the Profile option to pad the user defined days
326: -- to infinite Supply fence.
327: IF PG_DEBUG in ('Y', 'C') THEN
328: msc_sch_wb.atp_debug('get_infinite_time_fence_date: Profile value for Infinite Supply Pad');
329: msc_sch_wb.atp_debug('get_infinite_time_fence_date: MSC_ATP_PVT.G_INF_SUP_TF_PAD ' || MSC_ATP_PVT.G_INF_SUP_TF_PAD);
330: END IF;
331: -- End Bug 2877340, 2746213
332: SELECT c2.calendar_date

Line 329: msc_sch_wb.atp_debug('get_infinite_time_fence_date: MSC_ATP_PVT.G_INF_SUP_TF_PAD ' || MSC_ATP_PVT.G_INF_SUP_TF_PAD);

325: -- Read the Profile option to pad the user defined days
326: -- to infinite Supply fence.
327: IF PG_DEBUG in ('Y', 'C') THEN
328: msc_sch_wb.atp_debug('get_infinite_time_fence_date: Profile value for Infinite Supply Pad');
329: msc_sch_wb.atp_debug('get_infinite_time_fence_date: MSC_ATP_PVT.G_INF_SUP_TF_PAD ' || MSC_ATP_PVT.G_INF_SUP_TF_PAD);
330: END IF;
331: -- End Bug 2877340, 2746213
332: SELECT c2.calendar_date
333: INTO l_infinite_time_fence_date

Line 378: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'l_infinite_time_fence_date '||l_infinite_time_fence_date);

374: AND c2.exception_set_id = -1;
375: END IF;
376:
377: IF PG_DEBUG in ('Y', 'C') THEN
378: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'l_infinite_time_fence_date '||l_infinite_time_fence_date);
379: END IF;
380: return l_infinite_time_fence_date;
381:
382: EXCEPTION

Line 404: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'l_infinite_time_fence_date'||l_infinite_time_fence_date);

400: FROM msc_plans
401: WHERE plan_id = p_plan_id;
402:
403: IF PG_DEBUG in ('Y', 'C') THEN
404: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'l_infinite_time_fence_date'||l_infinite_time_fence_date);
405: END IF;
406: return l_infinite_time_fence_date;
407: END IF;
408:

Line 479: msc_sch_wb.atp_debug('Inside get_inv_item_id');

475: AND plan_id = -1
476: AND sr_instance_id = p_instance_id;
477: */
478: IF PG_DEBUG in ('Y', 'C') THEN
479: msc_sch_wb.atp_debug('Inside get_inv_item_id');
480: msc_sch_wb.atp_debug('p_instance_id := ' || p_instance_id);
481: msc_sch_wb.atp_debug('p_inventory_item_id := ' || p_inventory_item_id);
482: msc_sch_wb.atp_debug('p_match_item_id := ' || p_match_item_id);
483: END IF;

Line 480: msc_sch_wb.atp_debug('p_instance_id := ' || p_instance_id);

476: AND sr_instance_id = p_instance_id;
477: */
478: IF PG_DEBUG in ('Y', 'C') THEN
479: msc_sch_wb.atp_debug('Inside get_inv_item_id');
480: msc_sch_wb.atp_debug('p_instance_id := ' || p_instance_id);
481: msc_sch_wb.atp_debug('p_inventory_item_id := ' || p_inventory_item_id);
482: msc_sch_wb.atp_debug('p_match_item_id := ' || p_match_item_id);
483: END IF;
484: IF p_match_item_id is not null THEN

Line 481: msc_sch_wb.atp_debug('p_inventory_item_id := ' || p_inventory_item_id);

477: */
478: IF PG_DEBUG in ('Y', 'C') THEN
479: msc_sch_wb.atp_debug('Inside get_inv_item_id');
480: msc_sch_wb.atp_debug('p_instance_id := ' || p_instance_id);
481: msc_sch_wb.atp_debug('p_inventory_item_id := ' || p_inventory_item_id);
482: msc_sch_wb.atp_debug('p_match_item_id := ' || p_match_item_id);
483: END IF;
484: IF p_match_item_id is not null THEN
485:

Line 482: msc_sch_wb.atp_debug('p_match_item_id := ' || p_match_item_id);

478: IF PG_DEBUG in ('Y', 'C') THEN
479: msc_sch_wb.atp_debug('Inside get_inv_item_id');
480: msc_sch_wb.atp_debug('p_instance_id := ' || p_instance_id);
481: msc_sch_wb.atp_debug('p_inventory_item_id := ' || p_inventory_item_id);
482: msc_sch_wb.atp_debug('p_match_item_id := ' || p_match_item_id);
483: END IF;
484: IF p_match_item_id is not null THEN
485:
486: IF PG_DEBUG in ('Y', 'C') THEN

Line 487: msc_sch_wb.atp_debug('Match item exists');

483: END IF;
484: IF p_match_item_id is not null THEN
485:
486: IF PG_DEBUG in ('Y', 'C') THEN
487: msc_sch_wb.atp_debug('Match item exists');
488: END IF;
489: --bug 4091487 Added the if condition to drive query from msc_system_items in case organization id is passed
490: -- else go through msc_item_id_lid
491: IF(p_organization_id is not null) THEN

Line 517: msc_sch_wb.atp_debug('Exception no data found');

513: IF l_inv_item_ids.count = 0 THEN
514:
515: RAISE NO_DATA_FOUND;
516: IF PG_DEBUG in ('Y', 'C') THEN
517: msc_sch_wb.atp_debug('Exception no data found');
518: END IF;
519: END IF;
520:
521: IF PG_DEBUG in ('Y', 'C') THEN

Line 522: msc_sch_wb.atp_debug('Number of item found := ' || l_sr_inv_item_id.count);

518: END IF;
519: END IF;
520:
521: IF PG_DEBUG in ('Y', 'C') THEN
522: msc_sch_wb.atp_debug('Number of item found := ' || l_sr_inv_item_id.count);
523:
524: END IF;
525:
526: FOR l_item_count in 1..l_sr_inv_item_id.count LOOP

Line 528: msc_sch_wb.atp_debug('Item # := ' || l_item_count);

524: END IF;
525:
526: FOR l_item_count in 1..l_sr_inv_item_id.count LOOP
527: IF PG_DEBUG in ('Y', 'C') THEN
528: msc_sch_wb.atp_debug('Item # := ' || l_item_count);
529: msc_sch_wb.atp_debug('Sr inv id := ' || l_sr_inv_item_id(l_item_count));
530: msc_sch_wb.atp_debug('Inv Id := ' || l_inv_item_ids(l_item_count));
531: END IF;
532: l_inv_item_id := l_inv_item_ids(l_item_count);

Line 529: msc_sch_wb.atp_debug('Sr inv id := ' || l_sr_inv_item_id(l_item_count));

525:
526: FOR l_item_count in 1..l_sr_inv_item_id.count LOOP
527: IF PG_DEBUG in ('Y', 'C') THEN
528: msc_sch_wb.atp_debug('Item # := ' || l_item_count);
529: msc_sch_wb.atp_debug('Sr inv id := ' || l_sr_inv_item_id(l_item_count));
530: msc_sch_wb.atp_debug('Inv Id := ' || l_inv_item_ids(l_item_count));
531: END IF;
532: l_inv_item_id := l_inv_item_ids(l_item_count);
533: EXIT WHEN l_sr_inv_item_id(l_item_count) = p_match_item_id;

Line 530: msc_sch_wb.atp_debug('Inv Id := ' || l_inv_item_ids(l_item_count));

526: FOR l_item_count in 1..l_sr_inv_item_id.count LOOP
527: IF PG_DEBUG in ('Y', 'C') THEN
528: msc_sch_wb.atp_debug('Item # := ' || l_item_count);
529: msc_sch_wb.atp_debug('Sr inv id := ' || l_sr_inv_item_id(l_item_count));
530: msc_sch_wb.atp_debug('Inv Id := ' || l_inv_item_ids(l_item_count));
531: END IF;
532: l_inv_item_id := l_inv_item_ids(l_item_count);
533: EXIT WHEN l_sr_inv_item_id(l_item_count) = p_match_item_id;
534: END LOOP;

Line 560: msc_sch_wb.atp_debug('l_inv_item_id := ' || l_inv_item_id);

556: END IF;
557: END IF;
558:
559: IF PG_DEBUG in ('Y', 'C') THEN
560: msc_sch_wb.atp_debug('l_inv_item_id := ' || l_inv_item_id);
561: msc_sch_wb.atp_debug('End get_inv_item_id');
562: END IF;
563:
564: return l_inv_item_id;

Line 561: msc_sch_wb.atp_debug('End get_inv_item_id');

557: END IF;
558:
559: IF PG_DEBUG in ('Y', 'C') THEN
560: msc_sch_wb.atp_debug('l_inv_item_id := ' || l_inv_item_id);
561: msc_sch_wb.atp_debug('End get_inv_item_id');
562: END IF;
563:
564: return l_inv_item_id;
565: EXCEPTION

Line 584: msc_sch_wb.atp_debug('error in get_inv_item_id');

580: END IF;
581:
582: WHEN OTHERS THEN
583: IF PG_DEBUG in ('Y', 'C') THEN
584: msc_sch_wb.atp_debug('error in get_inv_item_id');
585: msc_sch_wb.atp_debug('get_inv_item_id: ' || 'sqlerrm : '||sqlerrm);
586: END IF;
587: return null;
588: END get_inv_item_id;

Line 585: msc_sch_wb.atp_debug('get_inv_item_id: ' || 'sqlerrm : '||sqlerrm);

581:
582: WHEN OTHERS THEN
583: IF PG_DEBUG in ('Y', 'C') THEN
584: msc_sch_wb.atp_debug('error in get_inv_item_id');
585: msc_sch_wb.atp_debug('get_inv_item_id: ' || 'sqlerrm : '||sqlerrm);
586: END IF;
587: return null;
588: END get_inv_item_id;
589:

Line 1002: msc_sch_wb.atp_debug('Selecting Process Sequence ID');

998: ) RETURN NUMBER
999: IS
1000: l_process_seq_id NUMBER;
1001: BEGIN
1002: msc_sch_wb.atp_debug('Selecting Process Sequence ID');
1003: Select process_sequence_id
1004: into l_process_seq_id
1005: from msc_process_effectivity prc
1006: where prc.plan_id = p_plan_id

Line 1017: msc_sch_wb.atp_debug('Get_Process_Seq_Id: ' || 'could not find process seq id,returning null');

1013: and prc.preference = 1;
1014: RETURN l_process_seq_id;
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: msc_sch_wb.atp_debug('Get_Process_Seq_Id: ' || 'could not find process seq id,returning null');
1018: return NULL;
1019: END get_process_seq_id;
1020: -- rajjain 02/19/2003 Bug 2788302 End
1021: