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.IGS_DA_PURGE_RQST_PKG dependencies on FND_MESSAGE

Line 50: FND_MESSAGE.Set_Name ('IGS', 'IGS_DA_BTCH_ID_NOT_FND');

46: --
47: BEGIN
48: --
49: IF (p_batch_id IS NULL) THEN
50: FND_MESSAGE.Set_Name ('IGS', 'IGS_DA_BTCH_ID_NOT_FND');
51: FND_MESSAGE.Set_Token ('BATCH_ID', p_batch_id);
52: FND_MSG_PUB.ADD;
53: RAISE FND_API.G_EXC_ERROR;
54: ELSE

Line 51: FND_MESSAGE.Set_Token ('BATCH_ID', p_batch_id);

47: BEGIN
48: --
49: IF (p_batch_id IS NULL) THEN
50: FND_MESSAGE.Set_Name ('IGS', 'IGS_DA_BTCH_ID_NOT_FND');
51: FND_MESSAGE.Set_Token ('BATCH_ID', p_batch_id);
52: FND_MSG_PUB.ADD;
53: RAISE FND_API.G_EXC_ERROR;
54: ELSE
55: --

Line 217: FND_MESSAGE.Set_Name('IGS','IGS_DA_JOB');

213: SAVEPOINT s_before_delete;
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);

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 220: FND_MESSAGE.Set_Name('IGS','IGS_DA_START_DT');

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);
223: --
224: FND_MESSAGE.Set_Name('IGS','IGS_DA_END_DT');

Line 221: FND_MESSAGE.SET_TOKEN('START',p_c_start_date);

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);
223: --
224: FND_MESSAGE.Set_Name('IGS','IGS_DA_END_DT');
225: FND_MESSAGE.SET_TOKEN('END',p_c_end_date);

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 224: FND_MESSAGE.Set_Name('IGS','IGS_DA_END_DT');

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);
227: --
228: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_NUM');

Line 225: FND_MESSAGE.SET_TOKEN('END',p_c_end_date);

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);
227: --
228: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_NUM');
229: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_c_request_number);

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 228: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_NUM');

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);
231: --
232: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQUESTER');

Line 229: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_c_request_number);

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);
231: --
232: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQUESTER');
233: FND_MESSAGE.SET_TOKEN('REQ',p_requestor_id);

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 232: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQUESTER');

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);
235: --
236: FND_MESSAGE.Set_Name('IGS','IGS_DA_RESP');

Line 233: FND_MESSAGE.SET_TOKEN('REQ',p_requestor_id);

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);
235: --
236: FND_MESSAGE.Set_Name('IGS','IGS_DA_RESP');
237: FND_MESSAGE.SET_TOKEN('RESP',p_responsibility);

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 236: FND_MESSAGE.Set_Name('IGS','IGS_DA_RESP');

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);
239: --
240: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_STATUS');

Line 237: FND_MESSAGE.SET_TOKEN('RESP',p_responsibility);

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);
239: --
240: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_STATUS');
241: FND_MESSAGE.SET_TOKEN('REQ',p_request_status);

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 240: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_STATUS');

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);
243: --
244: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_TYPE');

Line 241: FND_MESSAGE.SET_TOKEN('REQ',p_request_status);

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);
243: --
244: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_TYPE');
245: FND_MESSAGE.SET_TOKEN('REQ',p_request_type);

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 244: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_TYPE');

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);
247: --
248: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

Line 245: FND_MESSAGE.SET_TOKEN('REQ',p_request_type);

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);
247: --
248: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
249: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

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 302: FND_MESSAGE.Set_Name('IGS','IGS_DA_BATCH_ID');

298: OPEN cur_request_type(l_cur_request.request_type_id);
299: FETCH cur_request_type INTO l_cur_request_type;
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');

Line 303: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_cur_request.batch_id);

299: FETCH cur_request_type INTO l_cur_request_type;
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);

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 306: FND_MESSAGE.Set_Name('IGS','IGS_DA_REP_NAME');

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);
309: --
310: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_TYPE');

Line 307: FND_MESSAGE.SET_TOKEN('REP',l_cur_request_type.request_name);

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);
309: --
310: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_TYPE');
311: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request_type.request_type_meaning);

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 310: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_TYPE');

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);
313: --
314: FND_MESSAGE.Set_Name('IGS','IGS_DA_SEL_MODE');

Line 311: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request_type.request_type_meaning);

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);
313: --
314: FND_MESSAGE.Set_Name('IGS','IGS_DA_SEL_MODE');
315: FND_MESSAGE.SET_TOKEN('SEL',l_cur_request_type.request_mode_meaning);

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 314: FND_MESSAGE.Set_Name('IGS','IGS_DA_SEL_MODE');

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);
317: --
318: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_STATUS');

Line 315: FND_MESSAGE.SET_TOKEN('SEL',l_cur_request_type.request_mode_meaning);

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);
317: --
318: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_STATUS');
319: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.request_status_meaning);

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 318: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_STATUS');

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);
321: --
322: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQUESTER');

Line 319: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.request_status_meaning);

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);
321: --
322: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQUESTER');
323: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.requestor_full_name);

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 322: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQUESTER');

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);
325: --
326: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_DT');

Line 323: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.requestor_full_name);

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);
325: --
326: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_DT');
327: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.creation_date);

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 326: FND_MESSAGE.Set_Name('IGS','IGS_DA_REQ_DT');

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);
329: --
330: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

Line 327: FND_MESSAGE.SET_TOKEN('REQ',l_cur_request.creation_date);

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);
329: --
330: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
331: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

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 347: FND_MESSAGE.Set_Name ('IGS', 'IGS_DA_TOTAL_REQ');

343: );
344: END LOOP;
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

Line 348: FND_MESSAGE.SET_TOKEN ('COUNT', l_count);

344: END LOOP;
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

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 353: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_DA_NO_PARAM');

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');
354: retcode := 2;
355: ROLLBACK TO s_before_delete;
356: WHEN OTHERS THEN
357: ROLLBACK TO s_before_delete;

Line 358: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

354: retcode := 2;
355: ROLLBACK TO s_before_delete;
356: WHEN OTHERS THEN
357: ROLLBACK TO s_before_delete;
358: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
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));

Line 360: FND_MESSAGE.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

356: WHEN OTHERS THEN
357: ROLLBACK TO s_before_delete;
358: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
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;

Line 361: FND_MESSAGE.SET_TOKEN ('NAME', 'igs_da_purge_rqst_pkg.purge_request(): '

357: ROLLBACK TO s_before_delete;
358: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
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;

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;