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);
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);
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);
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);
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);
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);
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);
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: --
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
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
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);
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);
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);
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);
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);
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);
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: --
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: --
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;
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');
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;