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_AD_IMP_PRBLTY_VAL_PKG dependencies on FND_MESSAGE

Line 220: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');

216: WHERE prblty_val_int_id = prblty_val_rec.prblty_val_int_id;
217:
218: l_error_code := 'E007';
219:
220: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
221: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
222: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
223: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
224: RAISE skip_this_record;

Line 221: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);

217:
218: l_error_code := 'E007';
219:
220: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
221: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
222: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
223: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
224: RAISE skip_this_record;
225: END IF;

Line 222: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);

218: l_error_code := 'E007';
219:
220: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
221: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
222: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
223: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
224: RAISE skip_this_record;
225: END IF;
226: CLOSE person_id_cur;

Line 223: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

219:
220: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
221: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
222: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
223: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
224: RAISE skip_this_record;
225: END IF;
226: CLOSE person_id_cur;
227: END IF;

Line 239: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');

235: match_ind = NULL
236: WHERE prblty_val_int_id = prblty_val_rec.prblty_val_int_id;
237: l_error_code := 'E006';
238:
239: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
240: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
241: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
242: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
243: RAISE skip_this_record;

Line 240: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);

236: WHERE prblty_val_int_id = prblty_val_rec.prblty_val_int_id;
237: l_error_code := 'E006';
238:
239: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
240: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
241: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
242: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
243: RAISE skip_this_record;
244: END IF;

Line 241: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);

237: l_error_code := 'E006';
238:
239: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
240: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
241: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
242: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
243: RAISE skip_this_record;
244: END IF;
245:

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

238:
239: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
240: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
241: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
242: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
243: RAISE skip_this_record;
244: END IF;
245:
246: --Check whether its a duplicate record

Line 320: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');

316: WHERE prblty_val_int_id = prblty_val_rec.prblty_val_int_id;
317:
318: l_error_code := 'E005';
319:
320: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
321: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
322: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
323: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
324: RAISE skip_this_record;

Line 321: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);

317:
318: l_error_code := 'E005';
319:
320: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
321: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
322: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
323: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
324: RAISE skip_this_record;
325: END;

Line 322: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);

318: l_error_code := 'E005';
319:
320: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
321: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
322: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
323: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
324: RAISE skip_this_record;
325: END;
326:

Line 323: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

319:
320: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
321: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
322: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
323: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
324: RAISE skip_this_record;
325: END;
326:
327: ELSE -- Error_code is not NULL after validation.

Line 335: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');

331: status = '3' ,
332: match_ind = NULL
333: WHERE prblty_val_int_id = prblty_val_rec.prblty_val_int_id;
334:
335: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
336: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
337: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
338: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
339: RAISE skip_this_record;

Line 336: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);

332: match_ind = NULL
333: WHERE prblty_val_int_id = prblty_val_rec.prblty_val_int_id;
334:
335: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
336: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
337: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
338: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
339: RAISE skip_this_record;
340: END IF; --error_code comparision

Line 337: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);

333: WHERE prblty_val_int_id = prblty_val_rec.prblty_val_int_id;
334:
335: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
336: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
337: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
338: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
339: RAISE skip_this_record;
340: END IF; --error_code comparision
341:

Line 338: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

334:
335: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
336: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
337: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
338: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
339: RAISE skip_this_record;
340: END IF; --error_code comparision
341:
342: ELSE -- If match_ind <> '21' then make the status 'Error'

Line 351: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');

347: WHERE prblty_val_int_id = prblty_val_rec.prblty_val_int_id;
348:
349: l_error_code := 'E003';
350:
351: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
352: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
353: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
354: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
355: RAISE skip_this_record;

Line 352: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);

348:
349: l_error_code := 'E003';
350:
351: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
352: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
353: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
354: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
355: RAISE skip_this_record;
356:

Line 353: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);

349: l_error_code := 'E003';
350:
351: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
352: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
353: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
354: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
355: RAISE skip_this_record;
356:
357:

Line 354: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

350:
351: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
352: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
353: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
354: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
355: RAISE skip_this_record;
356:
357:
358: END IF; --match_ind comparision

Line 399: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');

395: WHERE prblty_val_int_id = prblty_val_rec.prblty_val_int_id;
396:
397: l_error_code := 'E004';
398:
399: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
400: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
401: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
402: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
403: RAISE skip_this_record;

Line 400: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);

396:
397: l_error_code := 'E004';
398:
399: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
400: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
401: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
402: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
403: RAISE skip_this_record;
404: END;

Line 401: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);

397: l_error_code := 'E004';
398:
399: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
400: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
401: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
402: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
403: RAISE skip_this_record;
404: END;
405: ELSE -- Error_code is not NULL after validation.

Line 402: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

398:
399: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
400: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
401: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
402: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
403: RAISE skip_this_record;
404: END;
405: ELSE -- Error_code is not NULL after validation.
406: -- Make the status 'Error' and error_code as obtained after validation

Line 413: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');

409: status = '3' ,
410: match_ind = NULL
411: WHERE prblty_val_int_id = prblty_val_rec.prblty_val_int_id;
412:
413: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
414: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
415: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
416: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
417: RAISE skip_this_record;

Line 414: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);

410: match_ind = NULL
411: WHERE prblty_val_int_id = prblty_val_rec.prblty_val_int_id;
412:
413: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
414: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
415: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
416: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
417: RAISE skip_this_record;
418: END IF; --error_code comparision

Line 415: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);

411: WHERE prblty_val_int_id = prblty_val_rec.prblty_val_int_id;
412:
413: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
414: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
415: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
416: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
417: RAISE skip_this_record;
418: END IF; --error_code comparision
419:

Line 416: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

412:
413: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
414: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
415: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
416: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
417: RAISE skip_this_record;
418: END IF; --error_code comparision
419:
420: END IF; --duplicate record check condition

Line 439: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TOT_REC_PRC');

435: WHERE status = '1' AND
436: prblty_val_batch_id = p_prblty_val_batch_id;
437:
438: --Display the no of records processed in the log File
439: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TOT_REC_PRC');
440: FND_MESSAGE.SET_TOKEN('RCOUNT',l_records_processed);
441: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
442:
443: EXCEPTION

Line 440: FND_MESSAGE.SET_TOKEN('RCOUNT',l_records_processed);

436: prblty_val_batch_id = p_prblty_val_batch_id;
437:
438: --Display the no of records processed in the log File
439: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TOT_REC_PRC');
440: FND_MESSAGE.SET_TOKEN('RCOUNT',l_records_processed);
441: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
442:
443: EXCEPTION
444: WHEN OTHERS THEN

Line 441: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

437:
438: --Display the no of records processed in the log File
439: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TOT_REC_PRC');
440: FND_MESSAGE.SET_TOKEN('RCOUNT',l_records_processed);
441: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
442:
443: EXCEPTION
444: WHEN OTHERS THEN
445: ROLLBACK;

Line 447: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');

443: EXCEPTION
444: WHEN OTHERS THEN
445: ROLLBACK;
446: RETCODE :=2;
447: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
448: igs_ge_msg_stack.conc_exception_hndl;
449:
450: END prc_prblty_value;
451: