DBA Data[Home] [Help]

APPS.IGS_DA_PURGE_RQST_PKG dependencies on FND_FILE

Line 218: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

214: --
215: -- Putting Messages in the Log File
216: --
217: FND_MESSAGE.Set_Name('IGS','IGS_DA_JOB');
218: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
219: --
220: FND_MESSAGE.Set_Name('IGS','IGS_DA_START_DT');
221: FND_MESSAGE.SET_TOKEN('START',p_c_start_date);
222: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

Line 222: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

218: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
219: --
220: FND_MESSAGE.Set_Name('IGS','IGS_DA_START_DT');
221: FND_MESSAGE.SET_TOKEN('START',p_c_start_date);
222: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
223: --
224: FND_MESSAGE.Set_Name('IGS','IGS_DA_END_DT');
225: FND_MESSAGE.SET_TOKEN('END',p_c_end_date);
226: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

Line 226: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

222: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
223: --
224: FND_MESSAGE.Set_Name('IGS','IGS_DA_END_DT');
225: FND_MESSAGE.SET_TOKEN('END',p_c_end_date);
226: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
227: --
228: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_NUM');
229: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_c_request_number);
230: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

Line 230: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

226: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
227: --
228: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_NUM');
229: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_c_request_number);
230: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
231: --
232: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQUESTER');
233: FND_MESSAGE.SET_TOKEN('REQ',p_requestor_id);
234: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

Line 234: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

230: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
231: --
232: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQUESTER');
233: FND_MESSAGE.SET_TOKEN('REQ',p_requestor_id);
234: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
235: --
236: FND_MESSAGE.Set_Name('IGS','IGS_DA_RESP');
237: FND_MESSAGE.SET_TOKEN('RESP',p_responsibility);
238: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

Line 238: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

234: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
235: --
236: FND_MESSAGE.Set_Name('IGS','IGS_DA_RESP');
237: FND_MESSAGE.SET_TOKEN('RESP',p_responsibility);
238: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
239: --
240: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_STATUS');
241: FND_MESSAGE.SET_TOKEN('REQ',p_request_status);
242: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

Line 242: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

238: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
239: --
240: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_STATUS');
241: FND_MESSAGE.SET_TOKEN('REQ',p_request_status);
242: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
243: --
244: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_TYPE');
245: FND_MESSAGE.SET_TOKEN('REQ',p_request_type);
246: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

Line 246: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

242: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
243: --
244: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_TYPE');
245: FND_MESSAGE.SET_TOKEN('REQ',p_request_type);
246: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
247: --
248: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
249: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
250: --

Line 248: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

244: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_TYPE');
245: FND_MESSAGE.SET_TOKEN('REQ',p_request_type);
246: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
247: --
248: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
249: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
250: --
251: IF (p_c_start_date IS NULL AND
252: p_c_end_date IS NULL AND

Line 249: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

245: FND_MESSAGE.SET_TOKEN('REQ',p_request_type);
246: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
247: --
248: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
249: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
250: --
251: IF (p_c_start_date IS NULL AND
252: p_c_end_date IS NULL AND
253: p_c_request_number IS NULL AND

Line 304: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

300: CLOSE cur_request_type;
301: --
302: FND_MESSAGE.Set_Name('IGS','IGS_DA_BATCH_ID');
303: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_cur_request.batch_id);
304: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
305: --
306: FND_MESSAGE.Set_Name('IGS','IGS_DA_REP_NAME');
307: FND_MESSAGE.SET_TOKEN('REP',l_cur_request_type.request_name);
308: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

Line 308: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

304: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
305: --
306: FND_MESSAGE.Set_Name('IGS','IGS_DA_REP_NAME');
307: FND_MESSAGE.SET_TOKEN('REP',l_cur_request_type.request_name);
308: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
309: --
310: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_TYPE');
311: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request_type.request_type_meaning);
312: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

Line 312: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

308: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
309: --
310: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_TYPE');
311: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request_type.request_type_meaning);
312: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
313: --
314: FND_MESSAGE.Set_Name('IGS','IGS_DA_SEL_MODE');
315: FND_MESSAGE.SET_TOKEN('SEL',l_cur_request_type.request_mode_meaning);
316: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

Line 316: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

312: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
313: --
314: FND_MESSAGE.Set_Name('IGS','IGS_DA_SEL_MODE');
315: FND_MESSAGE.SET_TOKEN('SEL',l_cur_request_type.request_mode_meaning);
316: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
317: --
318: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_STATUS');
319: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.request_status_meaning);
320: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

Line 320: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

316: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
317: --
318: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_STATUS');
319: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.request_status_meaning);
320: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
321: --
322: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQUESTER');
323: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.requestor_full_name);
324: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

Line 324: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

320: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
321: --
322: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQUESTER');
323: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.requestor_full_name);
324: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
325: --
326: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_DT');
327: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.creation_date);
328: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

Line 328: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

324: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
325: --
326: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_DT');
327: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.creation_date);
328: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
329: --
330: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
331: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
332: --

Line 330: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

326: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_DT');
327: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.creation_date);
328: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
329: --
330: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
331: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
332: --
333: -- Incrementing the Processing Record Counter
334: --

Line 331: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

327: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.creation_date);
328: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
329: --
330: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
331: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
332: --
333: -- Incrementing the Processing Record Counter
334: --
335: l_count := l_count + 1;

Line 349: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.Get);

345: END IF;
346: --
347: FND_MESSAGE.Set_Name ('IGS', 'IGS_DA_TOTAL_REQ');
348: FND_MESSAGE.SET_TOKEN ('COUNT', l_count);
349: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.Get);
350: --
351: EXCEPTION
352: WHEN FND_API.G_EXC_ERROR THEN
353: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_DA_NO_PARAM');

Line 363: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.Get);

359: retcode := 2;
360: FND_MESSAGE.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
361: FND_MESSAGE.SET_TOKEN ('NAME', 'igs_da_purge_rqst_pkg.purge_request(): '
362: || SUBSTR (SQLERRM,1,80));
363: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.Get);
364: IGS_GE_MSG_STACK.ADD;
365: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
366: END purge_request;
367: END igs_da_purge_rqst_pkg;