DBA Data[Home] [Help]

APPS.MSC_AATP_PROC dependencies on MSC_SCH_WB

Line 21: msc_sch_wb.atp_debug('**********Begin Add_to_current_atp Procedure************');

17:
18: BEGIN
19:
20: IF PG_DEBUG in ('Y', 'C') THEN
21: msc_sch_wb.atp_debug('**********Begin Add_to_current_atp Procedure************');
22: END IF;
23:
24: -- initialize API return status to success
25: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 32: msc_sch_wb.atp_debug ('Add_to_current_atp: ' || 'we are in loop i = '||i);

28: k := 0;
29: FOR i IN 1..p_steal_atp.atp_period.COUNT LOOP
30:
31: IF PG_DEBUG in ('Y', 'C') THEN
32: msc_sch_wb.atp_debug ('Add_to_current_atp: ' || 'we are in loop i = '||i);
33: END IF;
34: IF p_steal_atp.atp_qty(i) < 0 THEN
35: l_processed := FALSE;
36: WHILE (j IS NOT NULL) LOOP

Line 38: msc_sch_wb.atp_debug ('Add_to_current_atp: ' || 'we are in loop j = '||j);

34: IF p_steal_atp.atp_qty(i) < 0 THEN
35: l_processed := FALSE;
36: WHILE (j IS NOT NULL) LOOP
37: IF PG_DEBUG in ('Y', 'C') THEN
38: msc_sch_wb.atp_debug ('Add_to_current_atp: ' || 'we are in loop j = '||j);
39: END IF;
40: k := k+1;
41: l_current_atp.atp_period.Extend;
42: l_current_atp.atp_qty.Extend;

Line 105: msc_sch_wb.atp_debug('**********End Add_to_current_atp Procedure************');

101: END LOOP;
102:
103: p_current_atp := l_current_atp;
104: IF PG_DEBUG in ('Y', 'C') THEN
105: msc_sch_wb.atp_debug('**********End Add_to_current_atp Procedure************');
106: END IF;
107:
108: EXCEPTION
109: WHEN OTHERS THEN

Line 111: msc_sch_wb.atp_debug('Add_to_current_atp: ' || 'Error code:' || to_char(sqlcode));

107:
108: EXCEPTION
109: WHEN OTHERS THEN
110: IF PG_DEBUG in ('Y', 'C') THEN
111: msc_sch_wb.atp_debug('Add_to_current_atp: ' || 'Error code:' || to_char(sqlcode));
112: END IF;
113: x_return_status := FND_API.G_RET_STS_ERROR;
114:
115: END Add_to_current_atp;

Line 131: msc_sch_wb.atp_debug('**********Begin Atp_Forward_Consume Procedure************');

127: l_fw_nullifying_bucket_index NUMBER := 1;
128: BEGIN
129:
130: IF PG_DEBUG in ('Y', 'C') THEN
131: msc_sch_wb.atp_debug('**********Begin Atp_Forward_Consume Procedure************');
132: END IF;
133:
134: -- initialize API return status to success
135: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 172: msc_sch_wb.atp_debug('**********End Atp_Forward_Consume Procedure************');

168:
169: END LOOP;
170:
171: IF PG_DEBUG in ('Y', 'C') THEN
172: msc_sch_wb.atp_debug('**********End Atp_Forward_Consume Procedure************');
173: END IF;
174:
175: EXCEPTION
176: WHEN OTHERS THEN

Line 178: msc_sch_wb.atp_debug('Atp_Forward_Consume: ' || 'Error code:' || to_char(sqlcode));

174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: IF PG_DEBUG in ('Y', 'C') THEN
178: msc_sch_wb.atp_debug('Atp_Forward_Consume: ' || 'Error code:' || to_char(sqlcode));
179: END IF;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181:
182: END Atp_Forward_Consume;

Line 195: msc_sch_wb.atp_debug('**********Begin Atp_Adjusted_Cum Procedure************');

191: l_counter PLS_INTEGER;
192: BEGIN
193:
194: IF PG_DEBUG in ('Y', 'C') THEN
195: msc_sch_wb.atp_debug('**********Begin Atp_Adjusted_Cum Procedure************');
196: END IF;
197:
198: -- initialize API return status to success
199: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 205: msc_sch_wb.atp_debug ('Atp_Adjusted_Cum: ' || 'i = '||i);

201: i := p_current_atp.atp_period.LAST;
202: While i is not null LOOP
203:
204: IF PG_DEBUG in ('Y', 'C') THEN
205: msc_sch_wb.atp_debug ('Atp_Adjusted_Cum: ' || 'i = '||i);
206: END IF;
207: p_current_atp.atp_qty(i) := GREATEST(LEAST(p_current_atp.atp_qty(i),
208: p_unallocated_atp.atp_qty(i)), 0);
209:

Line 217: msc_sch_wb.atp_debug ('Atp_Adjusted_Cum: ' || 'Unallocated Cum Date:Qty - '||

213: IF i <> p_current_atp.atp_period.LAST
214: AND p_unallocated_atp.atp_qty(i) > p_unallocated_atp.atp_qty(i+1)
215: THEN
216: IF PG_DEBUG in ('Y', 'C') THEN
217: msc_sch_wb.atp_debug ('Atp_Adjusted_Cum: ' || 'Unallocated Cum Date:Qty - '||
218: p_current_atp.atp_period(i) ||' : '|| p_unallocated_atp.atp_qty(i) );
219: END IF;
220: p_unallocated_atp.atp_qty(i) := p_unallocated_atp.atp_qty(i+1);
221: IF PG_DEBUG in ('Y', 'C') THEN

Line 222: msc_sch_wb.atp_debug ('Atp_Adjusted_Cum: ' || 'Updated Unallocated Cum Date:Qty - '||

218: p_current_atp.atp_period(i) ||' : '|| p_unallocated_atp.atp_qty(i) );
219: END IF;
220: p_unallocated_atp.atp_qty(i) := p_unallocated_atp.atp_qty(i+1);
221: IF PG_DEBUG in ('Y', 'C') THEN
222: msc_sch_wb.atp_debug ('Atp_Adjusted_Cum: ' || 'Updated Unallocated Cum Date:Qty - '||
223: p_current_atp.atp_period(i) ||' : '|| p_unallocated_atp.atp_qty(i) );
224: END IF;
225: END IF;
226: --rajjain Bug 2793336 03/10/2003 End

Line 231: msc_sch_wb.atp_debug('**********End Atp_Adjusted_Cum Procedure************');

227: i := p_current_atp.atp_period.Prior(i);
228: END LOOP;
229:
230: IF PG_DEBUG in ('Y', 'C') THEN
231: msc_sch_wb.atp_debug('**********End Atp_Adjusted_Cum Procedure************');
232: END IF;
233:
234: EXCEPTION
235: WHEN OTHERS THEN

Line 237: msc_sch_wb.atp_debug('Atp_Adjusted_Cum: ' || 'Error code:' || to_char(sqlcode));

233:
234: EXCEPTION
235: WHEN OTHERS THEN
236: IF PG_DEBUG in ('Y', 'C') THEN
237: msc_sch_wb.atp_debug('Atp_Adjusted_Cum: ' || 'Error code:' || to_char(sqlcode));
238: END IF;
239: x_return_status := FND_API.G_RET_STS_ERROR;
240:
241: END Atp_Adjusted_Cum;

Line 252: msc_sch_wb.atp_debug('**********Begin Atp_Remove_Negatives Procedure************');

248: l_counter PLS_INTEGER;
249: BEGIN
250:
251: IF PG_DEBUG in ('Y', 'C') THEN
252: msc_sch_wb.atp_debug('**********Begin Atp_Remove_Negatives Procedure************');
253: END IF;
254:
255: -- initialize API return status to success
256: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 266: msc_sch_wb.atp_debug('Atp_Remove_Negatives: ' || 'we are in loop for removing negatives, i='||i);

262: IF (p_atp_qty(i) < 0 ) THEN
263: p_atp_qty(i) := 0;
264:
265: IF PG_DEBUG in ('Y', 'C') THEN
266: msc_sch_wb.atp_debug('Atp_Remove_Negatives: ' || 'we are in loop for removing negatives, i='||i);
267: END IF;
268: END IF;
269:
270: END LOOP;

Line 273: msc_sch_wb.atp_debug('**********End Atp_Remove_Negatives Procedure************');

269:
270: END LOOP;
271:
272: IF PG_DEBUG in ('Y', 'C') THEN
273: msc_sch_wb.atp_debug('**********End Atp_Remove_Negatives Procedure************');
274: END IF;
275:
276: EXCEPTION
277: WHEN OTHERS THEN

Line 279: msc_sch_wb.atp_debug('Atp_Remove_Negatives: ' || 'Error code:' || to_char(sqlcode));

275:
276: EXCEPTION
277: WHEN OTHERS THEN
278: IF PG_DEBUG in ('Y', 'C') THEN
279: msc_sch_wb.atp_debug('Atp_Remove_Negatives: ' || 'Error code:' || to_char(sqlcode));
280: END IF;
281: x_return_status := FND_API.G_RET_STS_ERROR;
282:
283: END Atp_Remove_Negatives;

Line 295: msc_sch_wb.atp_debug('PROCEDURE get_unalloc_data_from_SD_temp');

291: j NUMBER;
292: BEGIN
293:
294: IF PG_DEBUG in ('Y', 'C') THEN
295: msc_sch_wb.atp_debug('PROCEDURE get_unalloc_data_from_SD_temp');
296: END IF;
297:
298: -- initialize API return status to success
299: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 379: msc_sch_wb.atp_debug('get_unalloc_data_from_SD_temp: ' || 'Error code:' || to_char(sqlcode));

375:
376: EXCEPTION
377: WHEN OTHERS THEN
378: IF PG_DEBUG in ('Y', 'C') THEN
379: msc_sch_wb.atp_debug('get_unalloc_data_from_SD_temp: ' || 'Error code:' || to_char(sqlcode));
380: END IF;
381: x_return_status := FND_API.G_RET_STS_ERROR;
382:
383: END get_unalloc_data_from_SD_temp;