DBA Data[Home] [Help]

APPS.MRP_ATP_UTILS dependencies on MSC_SCH_WB

Line 34: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Error in MRPUATPB.pls '||substr(sqlerrm,1,100));

30: x_msg_count);
31: EXCEPTION
32: WHEN OTHERS THEN
33: IF PG_DEBUG in ('Y', 'C') THEN
34: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Error in MRPUATPB.pls '||substr(sqlerrm,1,100));
35: END IF;
36: x_msg_data := substr(sqlerrm,1,100);
37: x_return_status := FND_API.G_RET_STS_ERROR;
38: END put_into_temp_table;

Line 135: msc_sch_wb.atp_debug('Excp in extend_mast : '||Substr(Sqlerrm,1,100));

131: mast_rec.task_number.extend(1);
132: EXCEPTION
133: WHEN OTHERS THEN
134: IF PG_DEBUG in ('Y', 'C') THEN
135: msc_sch_wb.atp_debug('Excp in extend_mast : '||Substr(Sqlerrm,1,100));
136: END IF;
137: END extend_mast;
138:
139:

Line 173: msc_sch_wb.atp_debug('Excp in trim_mast : '||Substr(Sqlerrm,1,100));

169: mast_rec.task_number.trim(1);
170: EXCEPTION
171: WHEN OTHERS THEN
172: IF PG_DEBUG in ('Y', 'C') THEN
173: msc_sch_wb.atp_debug('Excp in trim_mast : '||Substr(Sqlerrm,1,100));
174: END IF;
175: END trim_mast;
176:
177: PROCEDURE test(x_session_id NUMBER) IS

Line 218: msc_sch_wb.atp_debug('test: ' || ' Retrieved record from mast ');

214: OPEN mast_cursor FOR sql_stmt using x_session_id;
215:
216: LOOP
217: IF PG_DEBUG in ('Y', 'C') THEN
218: msc_sch_wb.atp_debug('test: ' || ' Retrieved record from mast ');
219: END IF;
220: extend_mast(mast_rec, x_ret_code, x_ret_status);
221: IF PG_DEBUG in ('Y', 'C') THEN
222: msc_sch_wb.atp_debug('test: ' || ' error code '||x_ret_status||' '||x_ret_code);

Line 222: msc_sch_wb.atp_debug('test: ' || ' error code '||x_ret_status||' '||x_ret_code);

218: msc_sch_wb.atp_debug('test: ' || ' Retrieved record from mast ');
219: END IF;
220: extend_mast(mast_rec, x_ret_code, x_ret_status);
221: IF PG_DEBUG in ('Y', 'C') THEN
222: msc_sch_wb.atp_debug('test: ' || ' error code '||x_ret_status||' '||x_ret_code);
223: END IF;
224: FETCH mast_cursor INTO
225: mast_rec.rowid_char(j),
226: mast_rec.sequence_number(j),

Line 246: msc_sch_wb.atp_debug('test: ' || ' Count '||mast_rec.rowid_char.COUNT);

242: EXIT WHEN mast_cursor%notfound;
243: END LOOP;
244: trim_mast(mast_rec,x_ret_code, x_ret_status);
245: IF PG_DEBUG in ('Y', 'C') THEN
246: msc_sch_wb.atp_debug('test: ' || ' Count '||mast_rec.rowid_char.COUNT);
247: END IF;
248:
249: END test;
250: