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 290: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting infinite_time_fence_date, MSC_ATP_PVT.G_INV_CTP = 4');

286: BEGIN
287: /* for 1478110. please refer to the BUG
288: IF p_plan_id <> -1 THEN
289: IF PG_DEBUG in ('Y', 'C') THEN
290: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting infinite_time_fence_date, MSC_ATP_PVT.G_INV_CTP = 4');
291: END IF;
292:
293: SELECT curr_cutoff_date
294: INTO l_infinite_time_fence_date

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

294: INTO l_infinite_time_fence_date
295: FROM msc_plans
296: WHERE plan_id = p_plan_id;
297: IF PG_DEBUG in ('Y', 'C') THEN
298: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'l_infinite_time_fence_date'||l_infinite_time_fence_date);
299: END IF;
300: ELSE
301:
302: IF PG_DEBUG in ('Y', 'C') THEN

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

299: END IF;
300: ELSE
301:
302: IF PG_DEBUG in ('Y', 'C') THEN
303: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting infinite_time_fence_date, MSC_ATP_PVT.G_INV_CTP = 5');
304: END IF;
305: */
306:
307: -- Bug 1566260, in case of modle or option class for PDS ATP, return null.

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

310: -- demand entries could be stored for planning purposes.
311:
312: IF p_plan_id <> -1 THEN
313: IF PG_DEBUG in ('Y', 'C') THEN
314: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting item type for PDS');
315: END IF;
316: SELECT i.bom_item_type
317: INTO l_item_type
318: FROM msc_system_items i

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

323: END IF;
324:
325: IF nvl(l_item_type, -1) IN (1,2) THEN
326: IF PG_DEBUG in ('Y', 'C') THEN
327: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'PDS item type is model(1) or option class(2) : '||l_item_type);
328: END IF;
329: l_infinite_time_fence_date := null;
330: ELSE
331:

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

332: -- Bug 2877340, 2746213
333: -- Read the Profile option to pad the user defined days
334: -- to infinite Supply fence.
335: IF PG_DEBUG in ('Y', 'C') THEN
336: msc_sch_wb.atp_debug('get_infinite_time_fence_date: Profile value for Infinite Supply Pad');
337: 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);
338: END IF;
339: -- End Bug 2877340, 2746213
340: SELECT c2.calendar_date

Line 337: 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);

333: -- Read the Profile option to pad the user defined days
334: -- to infinite Supply fence.
335: IF PG_DEBUG in ('Y', 'C') THEN
336: msc_sch_wb.atp_debug('get_infinite_time_fence_date: Profile value for Infinite Supply Pad');
337: 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);
338: END IF;
339: -- End Bug 2877340, 2746213
340: SELECT c2.calendar_date
341: INTO l_infinite_time_fence_date

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

382: AND c2.exception_set_id = -1;
383: END IF;
384:
385: IF PG_DEBUG in ('Y', 'C') THEN
386: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'l_infinite_time_fence_date '||l_infinite_time_fence_date);
387: END IF;
388: return l_infinite_time_fence_date;
389:
390: EXCEPTION

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

408: FROM msc_plans
409: WHERE plan_id = p_plan_id;
410:
411: IF PG_DEBUG in ('Y', 'C') THEN
412: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'l_infinite_time_fence_date'||l_infinite_time_fence_date);
413: END IF;
414: return l_infinite_time_fence_date;
415: END IF;
416:

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

483: AND plan_id = -1
484: AND sr_instance_id = p_instance_id;
485: */
486: IF PG_DEBUG in ('Y', 'C') THEN
487: msc_sch_wb.atp_debug('Inside get_inv_item_id');
488: msc_sch_wb.atp_debug('p_instance_id := ' || p_instance_id);
489: msc_sch_wb.atp_debug('p_inventory_item_id := ' || p_inventory_item_id);
490: msc_sch_wb.atp_debug('p_match_item_id := ' || p_match_item_id);
491: END IF;

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

484: AND sr_instance_id = p_instance_id;
485: */
486: IF PG_DEBUG in ('Y', 'C') THEN
487: msc_sch_wb.atp_debug('Inside get_inv_item_id');
488: msc_sch_wb.atp_debug('p_instance_id := ' || p_instance_id);
489: msc_sch_wb.atp_debug('p_inventory_item_id := ' || p_inventory_item_id);
490: msc_sch_wb.atp_debug('p_match_item_id := ' || p_match_item_id);
491: END IF;
492: IF p_match_item_id is not null THEN

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

485: */
486: IF PG_DEBUG in ('Y', 'C') THEN
487: msc_sch_wb.atp_debug('Inside get_inv_item_id');
488: msc_sch_wb.atp_debug('p_instance_id := ' || p_instance_id);
489: msc_sch_wb.atp_debug('p_inventory_item_id := ' || p_inventory_item_id);
490: msc_sch_wb.atp_debug('p_match_item_id := ' || p_match_item_id);
491: END IF;
492: IF p_match_item_id is not null THEN
493:

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

486: IF PG_DEBUG in ('Y', 'C') THEN
487: msc_sch_wb.atp_debug('Inside get_inv_item_id');
488: msc_sch_wb.atp_debug('p_instance_id := ' || p_instance_id);
489: msc_sch_wb.atp_debug('p_inventory_item_id := ' || p_inventory_item_id);
490: msc_sch_wb.atp_debug('p_match_item_id := ' || p_match_item_id);
491: END IF;
492: IF p_match_item_id is not null THEN
493:
494: IF PG_DEBUG in ('Y', 'C') THEN

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

491: END IF;
492: IF p_match_item_id is not null THEN
493:
494: IF PG_DEBUG in ('Y', 'C') THEN
495: msc_sch_wb.atp_debug('Match item exists');
496: END IF;
497: --bug 4091487 Added the if condition to drive query from msc_system_items in case organization id is passed
498: -- else go through msc_item_id_lid
499: IF(p_organization_id is not null) THEN

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

521: IF l_inv_item_ids.count = 0 THEN
522:
523: RAISE NO_DATA_FOUND;
524: IF PG_DEBUG in ('Y', 'C') THEN
525: msc_sch_wb.atp_debug('Exception no data found');
526: END IF;
527: END IF;
528:
529: IF PG_DEBUG in ('Y', 'C') THEN

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

526: END IF;
527: END IF;
528:
529: IF PG_DEBUG in ('Y', 'C') THEN
530: msc_sch_wb.atp_debug('Number of item found := ' || l_sr_inv_item_id.count);
531:
532: END IF;
533:
534: FOR l_item_count in 1..l_sr_inv_item_id.count LOOP

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

532: END IF;
533:
534: FOR l_item_count in 1..l_sr_inv_item_id.count LOOP
535: IF PG_DEBUG in ('Y', 'C') THEN
536: msc_sch_wb.atp_debug('Item # := ' || l_item_count);
537: msc_sch_wb.atp_debug('Sr inv id := ' || l_sr_inv_item_id(l_item_count));
538: msc_sch_wb.atp_debug('Inv Id := ' || l_inv_item_ids(l_item_count));
539: END IF;
540: l_inv_item_id := l_inv_item_ids(l_item_count);

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

533:
534: FOR l_item_count in 1..l_sr_inv_item_id.count LOOP
535: IF PG_DEBUG in ('Y', 'C') THEN
536: msc_sch_wb.atp_debug('Item # := ' || l_item_count);
537: msc_sch_wb.atp_debug('Sr inv id := ' || l_sr_inv_item_id(l_item_count));
538: msc_sch_wb.atp_debug('Inv Id := ' || l_inv_item_ids(l_item_count));
539: END IF;
540: l_inv_item_id := l_inv_item_ids(l_item_count);
541: EXIT WHEN l_sr_inv_item_id(l_item_count) = p_match_item_id;

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

534: FOR l_item_count in 1..l_sr_inv_item_id.count LOOP
535: IF PG_DEBUG in ('Y', 'C') THEN
536: msc_sch_wb.atp_debug('Item # := ' || l_item_count);
537: msc_sch_wb.atp_debug('Sr inv id := ' || l_sr_inv_item_id(l_item_count));
538: msc_sch_wb.atp_debug('Inv Id := ' || l_inv_item_ids(l_item_count));
539: END IF;
540: l_inv_item_id := l_inv_item_ids(l_item_count);
541: EXIT WHEN l_sr_inv_item_id(l_item_count) = p_match_item_id;
542: END LOOP;

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

564: END IF;
565: END IF;
566:
567: IF PG_DEBUG in ('Y', 'C') THEN
568: msc_sch_wb.atp_debug('l_inv_item_id := ' || l_inv_item_id);
569: msc_sch_wb.atp_debug('End get_inv_item_id');
570: END IF;
571:
572: return l_inv_item_id;

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

565: END IF;
566:
567: IF PG_DEBUG in ('Y', 'C') THEN
568: msc_sch_wb.atp_debug('l_inv_item_id := ' || l_inv_item_id);
569: msc_sch_wb.atp_debug('End get_inv_item_id');
570: END IF;
571:
572: return l_inv_item_id;
573: EXCEPTION

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

588: END IF;
589:
590: WHEN OTHERS THEN
591: IF PG_DEBUG in ('Y', 'C') THEN
592: msc_sch_wb.atp_debug('error in get_inv_item_id');
593: msc_sch_wb.atp_debug('get_inv_item_id: ' || 'sqlerrm : '||sqlerrm);
594: END IF;
595: return null;
596: END get_inv_item_id;

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

589:
590: WHEN OTHERS THEN
591: IF PG_DEBUG in ('Y', 'C') THEN
592: msc_sch_wb.atp_debug('error in get_inv_item_id');
593: msc_sch_wb.atp_debug('get_inv_item_id: ' || 'sqlerrm : '||sqlerrm);
594: END IF;
595: return null;
596: END get_inv_item_id;
597:

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

1006: ) RETURN NUMBER
1007: IS
1008: l_process_seq_id NUMBER;
1009: BEGIN
1010: msc_sch_wb.atp_debug('Selecting Process Sequence ID');
1011: Select process_sequence_id
1012: into l_process_seq_id
1013: from msc_process_effectivity prc
1014: where prc.plan_id = p_plan_id

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

1021: and prc.preference = 1;
1022: RETURN l_process_seq_id;
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: msc_sch_wb.atp_debug('Get_Process_Seq_Id: ' || 'could not find process seq id,returning null');
1026: return NULL;
1027: END get_process_seq_id;
1028: -- rajjain 02/19/2003 Bug 2788302 End
1029:

Line 1043: msc_sch_wb.atp_debug('inside check_alloc_exists');

1039:
1040: BEGIN
1041:
1042: IF PG_DEBUG in ('Y', 'C') THEN
1043: msc_sch_wb.atp_debug('inside check_alloc_exists');
1044: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
1045: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'organization_id = '||p_organization_id);
1046: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'plan_id = '||p_plan_id);
1047: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_instance_id = '||p_instance_id);

Line 1044: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_inventory_item_id = '||p_inventory_item_id);

1040: BEGIN
1041:
1042: IF PG_DEBUG in ('Y', 'C') THEN
1043: msc_sch_wb.atp_debug('inside check_alloc_exists');
1044: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
1045: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'organization_id = '||p_organization_id);
1046: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'plan_id = '||p_plan_id);
1047: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_instance_id = '||p_instance_id);
1048: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'p_requested_date = '||p_requested_date);

Line 1045: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'organization_id = '||p_organization_id);

1041:
1042: IF PG_DEBUG in ('Y', 'C') THEN
1043: msc_sch_wb.atp_debug('inside check_alloc_exists');
1044: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
1045: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'organization_id = '||p_organization_id);
1046: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'plan_id = '||p_plan_id);
1047: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_instance_id = '||p_instance_id);
1048: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'p_requested_date = '||p_requested_date);
1049: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'MSC_ATP_PVT.G_ALLOCATED_ATP = '||MSC_ATP_PVT.G_ALLOCATED_ATP);

Line 1046: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'plan_id = '||p_plan_id);

1042: IF PG_DEBUG in ('Y', 'C') THEN
1043: msc_sch_wb.atp_debug('inside check_alloc_exists');
1044: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
1045: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'organization_id = '||p_organization_id);
1046: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'plan_id = '||p_plan_id);
1047: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_instance_id = '||p_instance_id);
1048: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'p_requested_date = '||p_requested_date);
1049: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'MSC_ATP_PVT.G_ALLOCATED_ATP = '||MSC_ATP_PVT.G_ALLOCATED_ATP);
1050: END IF;

Line 1047: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_instance_id = '||p_instance_id);

1043: msc_sch_wb.atp_debug('inside check_alloc_exists');
1044: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
1045: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'organization_id = '||p_organization_id);
1046: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'plan_id = '||p_plan_id);
1047: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_instance_id = '||p_instance_id);
1048: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'p_requested_date = '||p_requested_date);
1049: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'MSC_ATP_PVT.G_ALLOCATED_ATP = '||MSC_ATP_PVT.G_ALLOCATED_ATP);
1050: END IF;
1051:

Line 1048: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'p_requested_date = '||p_requested_date);

1044: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
1045: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'organization_id = '||p_organization_id);
1046: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'plan_id = '||p_plan_id);
1047: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_instance_id = '||p_instance_id);
1048: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'p_requested_date = '||p_requested_date);
1049: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'MSC_ATP_PVT.G_ALLOCATED_ATP = '||MSC_ATP_PVT.G_ALLOCATED_ATP);
1050: END IF;
1051:
1052: SELECT Count(1)

Line 1049: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'MSC_ATP_PVT.G_ALLOCATED_ATP = '||MSC_ATP_PVT.G_ALLOCATED_ATP);

1045: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'organization_id = '||p_organization_id);
1046: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'plan_id = '||p_plan_id);
1047: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sr_instance_id = '||p_instance_id);
1048: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'p_requested_date = '||p_requested_date);
1049: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'MSC_ATP_PVT.G_ALLOCATED_ATP = '||MSC_ATP_PVT.G_ALLOCATED_ATP);
1050: END IF;
1051:
1052: SELECT Count(1)
1053: INTO l_count

Line 1067: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'l_count = '||l_count);

1063: and greatest(p_requested_date,trunc(sysdate)) between mv.effective_date and mv.disable_date
1064: and rownum=1;
1065:
1066: IF PG_DEBUG in ('Y', 'C') THEN
1067: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'l_count = '||l_count);
1068: END IF;
1069:
1070: IF l_count > 0 THEN
1071: return 'Y';

Line 1079: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sqlcode : '||sqlcode);

1075:
1076: EXCEPTION
1077: WHEN OTHERS THEN
1078: IF PG_DEBUG in ('Y', 'C') THEN
1079: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sqlcode : '||sqlcode);
1080: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sqlerr : '||sqlerrm);
1081: END IF;
1082: return 'N';
1083: END check_alloc_exists;

Line 1080: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sqlerr : '||sqlerrm);

1076: EXCEPTION
1077: WHEN OTHERS THEN
1078: IF PG_DEBUG in ('Y', 'C') THEN
1079: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sqlcode : '||sqlcode);
1080: msc_sch_wb.atp_debug('check_alloc_exists: ' || 'sqlerr : '||sqlerrm);
1081: END IF;
1082: return 'N';
1083: END check_alloc_exists;
1084: