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

Line 336: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

332: END IF;
333:
334: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visa.val_exception' || l_error;
335:
336: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
337: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);
338: fnd_message.set_token('ERROR_CD',l_error);
339:
340: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 337: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);

333:
334: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visa.val_exception' || l_error;
335:
336: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
337: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);
338: fnd_message.set_token('ERROR_CD',l_error);
339:
340: l_debug_str := fnd_message.get || ' ' || SQLERRM;
341:

Line 338: fnd_message.set_token('ERROR_CD',l_error);

334: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visa.val_exception' || l_error;
335:
336: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
337: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);
338: fnd_message.set_token('ERROR_CD',l_error);
339:
340: l_debug_str := fnd_message.get || ' ' || SQLERRM;
341:
342: fnd_log.string_with_context( fnd_log.level_exception,

Line 340: l_debug_str := fnd_message.get || ' ' || SQLERRM;

336: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
337: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);
338: fnd_message.set_token('ERROR_CD',l_error);
339:
340: l_debug_str := fnd_message.get || ' ' || SQLERRM;
341:
342: fnd_log.string_with_context( fnd_log.level_exception,
343: l_label,
344: l_debug_str, NULL,

Line 480: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

476: EXCEPTION
477: WHEN OTHERS THEN
478:
479: ROLLBACK TO before_insert;
480: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
481:
482: IF l_message_name = 'IGS_PE_VISA_DATE_OVERLAP' THEN
483: l_error:='E558';
484: ELSIF l_message_name = 'IGS_PE_VIS_ASOC_PASS_EXP' THEN

Line 496: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

492: END IF;
493:
494: l_label := 'igs.plsql.igs_ad_imp_026.crt_pe_visa.exception' || l_error;
495:
496: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
497: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);
498: fnd_message.set_token('ERROR_CD',l_error);
499:
500: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 497: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);

493:
494: l_label := 'igs.plsql.igs_ad_imp_026.crt_pe_visa.exception' || l_error;
495:
496: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
497: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);
498: fnd_message.set_token('ERROR_CD',l_error);
499:
500: l_debug_str := fnd_message.get || ' ' || SQLERRM;
501:

Line 498: fnd_message.set_token('ERROR_CD',l_error);

494: l_label := 'igs.plsql.igs_ad_imp_026.crt_pe_visa.exception' || l_error;
495:
496: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
497: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);
498: fnd_message.set_token('ERROR_CD',l_error);
499:
500: l_debug_str := fnd_message.get || ' ' || SQLERRM;
501:
502: fnd_log.string_with_context( fnd_log.level_exception,

Line 500: l_debug_str := fnd_message.get || ' ' || SQLERRM;

496: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
497: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);
498: fnd_message.set_token('ERROR_CD',l_error);
499:
500: l_debug_str := fnd_message.get || ' ' || SQLERRM;
501:
502: fnd_log.string_with_context( fnd_log.level_exception,
503: l_label,
504: l_debug_str, NULL,

Line 607: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: ROLLBACK TO before_update;
607: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
608: IF l_message_name = 'IGS_PE_VISA_DATE_OVERLAP' THEN
609: UPDATE igs_pe_visa_int
610: SET status = '3',
611: error_code = 'E558'

Line 644: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

640: END IF;
641:
642: l_label := 'igs.plsql.igs_ad_imp_026.upd_pe_visa.exception' || 'E014';
643:
644: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
645: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);
646: fnd_message.set_token('ERROR_CD','E014');
647:
648: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 645: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);

641:
642: l_label := 'igs.plsql.igs_ad_imp_026.upd_pe_visa.exception' || 'E014';
643:
644: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
645: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);
646: fnd_message.set_token('ERROR_CD','E014');
647:
648: l_debug_str := fnd_message.get || ' ' || SQLERRM;
649:

Line 646: fnd_message.set_token('ERROR_CD','E014');

642: l_label := 'igs.plsql.igs_ad_imp_026.upd_pe_visa.exception' || 'E014';
643:
644: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
645: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);
646: fnd_message.set_token('ERROR_CD','E014');
647:
648: l_debug_str := fnd_message.get || ' ' || SQLERRM;
649:
650: fnd_log.string_with_context( fnd_log.level_exception,

Line 648: l_debug_str := fnd_message.get || ' ' || SQLERRM;

644: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
645: fnd_message.set_token('INTERFACE_ID',visa_rec.interface_visa_id);
646: fnd_message.set_token('ERROR_CD','E014');
647:
648: l_debug_str := fnd_message.get || ' ' || SQLERRM;
649:
650: fnd_log.string_with_context( fnd_log.level_exception,
651: l_label,
652: l_debug_str, NULL,

Line 1008: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1004: END IF;
1005:
1006: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.val_exception' || p_err_code;
1007:
1008: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1009: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1010: fnd_message.set_token('ERROR_CD',p_err_code);
1011:
1012: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1009: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);

1005:
1006: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.val_exception' || p_err_code;
1007:
1008: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1009: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1010: fnd_message.set_token('ERROR_CD',p_err_code);
1011:
1012: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1013:

Line 1010: fnd_message.set_token('ERROR_CD',p_err_code);

1006: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.val_exception' || p_err_code;
1007:
1008: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1009: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1010: fnd_message.set_token('ERROR_CD',p_err_code);
1011:
1012: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1013:
1014: fnd_log.string_with_context( fnd_log.level_exception,

Line 1012: l_debug_str := fnd_message.get || ' ' || SQLERRM;

1008: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1009: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1010: fnd_message.set_token('ERROR_CD',p_err_code);
1011:
1012: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1013:
1014: fnd_log.string_with_context( fnd_log.level_exception,
1015: l_label,
1016: l_debug_str, NULL,

Line 1168: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1164: END IF;
1165:
1166: l_label := 'igs.plsql.igs_ad_imp_026.crt_pe_pass.exception' || l_error;
1167:
1168: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1169: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1170: fnd_message.set_token('ERROR_CD',l_error);
1171:
1172: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1169: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);

1165:
1166: l_label := 'igs.plsql.igs_ad_imp_026.crt_pe_pass.exception' || l_error;
1167:
1168: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1169: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1170: fnd_message.set_token('ERROR_CD',l_error);
1171:
1172: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1173:

Line 1170: fnd_message.set_token('ERROR_CD',l_error);

1166: l_label := 'igs.plsql.igs_ad_imp_026.crt_pe_pass.exception' || l_error;
1167:
1168: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1169: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1170: fnd_message.set_token('ERROR_CD',l_error);
1171:
1172: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1173:
1174: fnd_log.string_with_context( fnd_log.level_exception,

Line 1172: l_debug_str := fnd_message.get || ' ' || SQLERRM;

1168: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1169: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1170: fnd_message.set_token('ERROR_CD',l_error);
1171:
1172: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1173:
1174: fnd_log.string_with_context( fnd_log.level_exception,
1175: l_label,
1176: l_debug_str, NULL,

Line 1241: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

1237:
1238: EXCEPTION
1239: WHEN OTHERS THEN
1240:
1241: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
1242:
1243: IF l_message_name = 'IGS_PE_VIS_ASOC_PASS_EXP' THEN
1244: p_error_code := 'E288';
1245: p_status := '3';

Line 1263: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1259: END IF;
1260:
1261: l_label := 'igs.plsql.igs_ad_imp_026.upd_pe_pass.exception' || p_error_code;
1262:
1263: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1264: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1265: fnd_message.set_token('ERROR_CD',p_error_code);
1266:
1267: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1264: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);

1260:
1261: l_label := 'igs.plsql.igs_ad_imp_026.upd_pe_pass.exception' || p_error_code;
1262:
1263: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1264: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1265: fnd_message.set_token('ERROR_CD',p_error_code);
1266:
1267: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1268:

Line 1265: fnd_message.set_token('ERROR_CD',p_error_code);

1261: l_label := 'igs.plsql.igs_ad_imp_026.upd_pe_pass.exception' || p_error_code;
1262:
1263: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1264: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1265: fnd_message.set_token('ERROR_CD',p_error_code);
1266:
1267: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1268:
1269: fnd_log.string_with_context( fnd_log.level_exception,

Line 1267: l_debug_str := fnd_message.get || ' ' || SQLERRM;

1263: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1264: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1265: fnd_message.set_token('ERROR_CD',p_error_code);
1266:
1267: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1268:
1269: fnd_log.string_with_context( fnd_log.level_exception,
1270: l_label,
1271: l_debug_str, NULL,

Line 1469: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1465: END IF;
1466:
1467: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.exception' || 'E014';
1468:
1469: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1470: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1471: fnd_message.set_token('ERROR_CD','E014');
1472:
1473: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1470: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);

1466:
1467: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.exception' || 'E014';
1468:
1469: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1470: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1471: fnd_message.set_token('ERROR_CD','E014');
1472:
1473: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1474:

Line 1471: fnd_message.set_token('ERROR_CD','E014');

1467: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.exception' || 'E014';
1468:
1469: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1470: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1471: fnd_message.set_token('ERROR_CD','E014');
1472:
1473: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1474:
1475: fnd_log.string_with_context( fnd_log.level_exception,

Line 1473: l_debug_str := fnd_message.get || ' ' || SQLERRM;

1469: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1470: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1471: fnd_message.set_token('ERROR_CD','E014');
1472:
1473: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1474:
1475: fnd_log.string_with_context( fnd_log.level_exception,
1476: l_label,
1477: l_debug_str, NULL,

Line 1516: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1512: END IF;
1513:
1514: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.exception1' || 'E014';
1515:
1516: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1517: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1518: fnd_message.set_token('ERROR_CD','E014');
1519:
1520: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1517: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);

1513:
1514: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.exception1' || 'E014';
1515:
1516: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1517: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1518: fnd_message.set_token('ERROR_CD','E014');
1519:
1520: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1521:

Line 1518: fnd_message.set_token('ERROR_CD','E014');

1514: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_passport.exception1' || 'E014';
1515:
1516: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1517: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1518: fnd_message.set_token('ERROR_CD','E014');
1519:
1520: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1521:
1522: fnd_log.string_with_context( fnd_log.level_exception,

Line 1520: l_debug_str := fnd_message.get || ' ' || SQLERRM;

1516: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1517: fnd_message.set_token('INTERFACE_ID',pass_rec.interface_passport_id);
1518: fnd_message.set_token('ERROR_CD','E014');
1519:
1520: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1521:
1522: fnd_log.string_with_context( fnd_log.level_exception,
1523: l_label,
1524: l_debug_str, NULL,

Line 1691: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1687: END IF;
1688:
1689: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.val_exception' || p_err_code;
1690:
1691: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1692: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
1693: fnd_message.set_token('ERROR_CD',p_err_code);
1694:
1695: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1692: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);

1688:
1689: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.val_exception' || p_err_code;
1690:
1691: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1692: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
1693: fnd_message.set_token('ERROR_CD',p_err_code);
1694:
1695: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1696:

Line 1693: fnd_message.set_token('ERROR_CD',p_err_code);

1689: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.val_exception' || p_err_code;
1690:
1691: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1692: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
1693: fnd_message.set_token('ERROR_CD',p_err_code);
1694:
1695: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1696:
1697: fnd_log.string_with_context( fnd_log.level_exception,

Line 1695: l_debug_str := fnd_message.get || ' ' || SQLERRM;

1691: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1692: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
1693: fnd_message.set_token('ERROR_CD',p_err_code);
1694:
1695: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1696:
1697: fnd_log.string_with_context( fnd_log.level_exception,
1698: l_label,
1699: l_debug_str, NULL,

Line 1736: fnd_message.set_name ('IGS', 'IGS_EN_INV');

1732: l_visit_rec.issue_date := visit_visa_rec.issue_date;
1733: l_visit_rec.expiry_date := visit_visa_rec.expiry_date;
1734: l_visit_rec.person_id := visit_visa_rec.person_id;
1735: ELSE
1736: fnd_message.set_name ('IGS', 'IGS_EN_INV');
1737: fnd_message.set_token('PARAM','VISA_ID');
1738: igs_ge_msg_stack.add;
1739: app_exception.raise_exception;
1740: END IF;

Line 1737: fnd_message.set_token('PARAM','VISA_ID');

1733: l_visit_rec.expiry_date := visit_visa_rec.expiry_date;
1734: l_visit_rec.person_id := visit_visa_rec.person_id;
1735: ELSE
1736: fnd_message.set_name ('IGS', 'IGS_EN_INV');
1737: fnd_message.set_token('PARAM','VISA_ID');
1738: igs_ge_msg_stack.add;
1739: app_exception.raise_exception;
1740: END IF;
1741:

Line 1866: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

1862:
1863: EXCEPTION
1864: WHEN OTHERS THEN
1865: ROLLBACK TO before_insert;
1866: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
1867:
1868: IF l_message_name = 'IGS_PE_PORT_DATE_OVERLAP' THEN
1869: l_error:='E564';
1870: ELSE

Line 1883: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1879: END IF;
1880:
1881: l_label := 'igs.plsql.igs_ad_imp_026.crt_pe_visit_histry.exception' || l_error;
1882:
1883: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1884: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
1885: fnd_message.set_token('ERROR_CD',l_error);
1886:
1887: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1884: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);

1880:
1881: l_label := 'igs.plsql.igs_ad_imp_026.crt_pe_visit_histry.exception' || l_error;
1882:
1883: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1884: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
1885: fnd_message.set_token('ERROR_CD',l_error);
1886:
1887: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1888:

Line 1885: fnd_message.set_token('ERROR_CD',l_error);

1881: l_label := 'igs.plsql.igs_ad_imp_026.crt_pe_visit_histry.exception' || l_error;
1882:
1883: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1884: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
1885: fnd_message.set_token('ERROR_CD',l_error);
1886:
1887: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1888:
1889: fnd_log.string_with_context( fnd_log.level_exception,

Line 1887: l_debug_str := fnd_message.get || ' ' || SQLERRM;

1883: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1884: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
1885: fnd_message.set_token('ERROR_CD',l_error);
1886:
1887: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1888:
1889: fnd_log.string_with_context( fnd_log.level_exception,
1890: l_label,
1891: l_debug_str, NULL,

Line 1970: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

1966:
1967: EXCEPTION
1968: WHEN OTHERS THEN
1969: ROLLBACK TO before_update;
1970: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
1971:
1972: IF l_message_name = 'IGS_PE_PORT_DATE_OVERLAP' THEN
1973: p_error_code := 'E564';
1974: p_status := '3';

Line 2000: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1996: END IF;
1997:
1998: l_label := 'igs.plsql.igs_ad_imp_026.upd_pe_visit_histry.exception' || 'E014';
1999:
2000: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2001: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
2002: fnd_message.set_token('ERROR_CD','E014');
2003:
2004: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 2001: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);

1997:
1998: l_label := 'igs.plsql.igs_ad_imp_026.upd_pe_visit_histry.exception' || 'E014';
1999:
2000: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2001: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
2002: fnd_message.set_token('ERROR_CD','E014');
2003:
2004: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2005:

Line 2002: fnd_message.set_token('ERROR_CD','E014');

1998: l_label := 'igs.plsql.igs_ad_imp_026.upd_pe_visit_histry.exception' || 'E014';
1999:
2000: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2001: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
2002: fnd_message.set_token('ERROR_CD','E014');
2003:
2004: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2005:
2006: fnd_log.string_with_context( fnd_log.level_exception,

Line 2004: l_debug_str := fnd_message.get || ' ' || SQLERRM;

2000: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2001: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
2002: fnd_message.set_token('ERROR_CD','E014');
2003:
2004: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2005:
2006: fnd_log.string_with_context( fnd_log.level_exception,
2007: l_label,
2008: l_debug_str, NULL,

Line 2204: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

2200: END IF;
2201:
2202: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.exception' || 'E014';
2203:
2204: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2205: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
2206: fnd_message.set_token('ERROR_CD','E014');
2207:
2208: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 2205: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);

2201:
2202: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.exception' || 'E014';
2203:
2204: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2205: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
2206: fnd_message.set_token('ERROR_CD','E014');
2207:
2208: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2209:

Line 2206: fnd_message.set_token('ERROR_CD','E014');

2202: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.exception' || 'E014';
2203:
2204: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2205: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
2206: fnd_message.set_token('ERROR_CD','E014');
2207:
2208: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2209:
2210: fnd_log.string_with_context( fnd_log.level_exception,

Line 2208: l_debug_str := fnd_message.get || ' ' || SQLERRM;

2204: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2205: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
2206: fnd_message.set_token('ERROR_CD','E014');
2207:
2208: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2209:
2210: fnd_log.string_with_context( fnd_log.level_exception,
2211: l_label,
2212: l_debug_str, NULL,

Line 2252: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

2248: END IF;
2249:
2250: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.exception1' || 'E014';
2251:
2252: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2253: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
2254: fnd_message.set_token('ERROR_CD','E014');
2255:
2256: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 2253: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);

2249:
2250: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.exception1' || 'E014';
2251:
2252: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2253: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
2254: fnd_message.set_token('ERROR_CD','E014');
2255:
2256: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2257:

Line 2254: fnd_message.set_token('ERROR_CD','E014');

2250: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.exception1' || 'E014';
2251:
2252: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2253: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
2254: fnd_message.set_token('ERROR_CD','E014');
2255:
2256: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2257:
2258: fnd_log.string_with_context( fnd_log.level_exception,

Line 2256: l_debug_str := fnd_message.get || ' ' || SQLERRM;

2252: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2253: fnd_message.set_token('INTERFACE_ID',visit_rec.interface_visit_histry_id);
2254: fnd_message.set_token('ERROR_CD','E014');
2255:
2256: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2257:
2258: fnd_log.string_with_context( fnd_log.level_exception,
2259: l_label,
2260: l_debug_str, NULL,

Line 2452: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

2448: END IF;
2449:
2450: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.val_exception' || l_error;
2451:
2452: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2453: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2454: fnd_message.set_token('ERROR_CD',l_error);
2455:
2456: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 2453: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);

2449:
2450: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.val_exception' || l_error;
2451:
2452: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2453: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2454: fnd_message.set_token('ERROR_CD',l_error);
2455:
2456: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2457:

Line 2454: fnd_message.set_token('ERROR_CD',l_error);

2450: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.val_exception' || l_error;
2451:
2452: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2453: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2454: fnd_message.set_token('ERROR_CD',l_error);
2455:
2456: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2457:
2458: fnd_log.string_with_context( fnd_log.level_exception,

Line 2456: l_debug_str := fnd_message.get || ' ' || SQLERRM;

2452: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2453: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2454: fnd_message.set_token('ERROR_CD',l_error);
2455:
2456: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2457:
2458: fnd_log.string_with_context( fnd_log.level_exception,
2459: l_label,
2460: l_debug_str, NULL,

Line 2558: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

2554: END IF;
2555:
2556: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.crt_exception' || l_error;
2557:
2558: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2559: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2560: fnd_message.set_token('ERROR_CD',l_error);
2561:
2562: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 2559: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);

2555:
2556: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.crt_exception' || l_error;
2557:
2558: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2559: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2560: fnd_message.set_token('ERROR_CD',l_error);
2561:
2562: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2563:

Line 2560: fnd_message.set_token('ERROR_CD',l_error);

2556: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.crt_exception' || l_error;
2557:
2558: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2559: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2560: fnd_message.set_token('ERROR_CD',l_error);
2561:
2562: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2563:
2564: fnd_log.string_with_context( fnd_log.level_exception,

Line 2562: l_debug_str := fnd_message.get || ' ' || SQLERRM;

2558: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2559: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2560: fnd_message.set_token('ERROR_CD',l_error);
2561:
2562: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2563:
2564: fnd_log.string_with_context( fnd_log.level_exception,
2565: l_label,
2566: l_debug_str, NULL,

Line 2669: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

2665: END IF;
2666:
2667: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.upd_exception' || 'E014';
2668:
2669: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2670: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2671: fnd_message.set_token('ERROR_CD','E014');
2672:
2673: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 2670: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);

2666:
2667: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.upd_exception' || 'E014';
2668:
2669: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2670: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2671: fnd_message.set_token('ERROR_CD','E014');
2672:
2673: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2674:

Line 2671: fnd_message.set_token('ERROR_CD','E014');

2667: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.upd_exception' || 'E014';
2668:
2669: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2670: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2671: fnd_message.set_token('ERROR_CD','E014');
2672:
2673: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2674:
2675: fnd_log.string_with_context( fnd_log.level_exception,

Line 2673: l_debug_str := fnd_message.get || ' ' || SQLERRM;

2669: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2670: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2671: fnd_message.set_token('ERROR_CD','E014');
2672:
2673: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2674:
2675: fnd_log.string_with_context( fnd_log.level_exception,
2676: l_label,
2677: l_debug_str, NULL,

Line 2854: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

2850: END IF;
2851:
2852: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.exception1 ' || 'E014';
2853:
2854: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2855: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2856: fnd_message.set_token('ERROR_CD','E014');
2857:
2858: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 2855: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);

2851:
2852: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.exception1 ' || 'E014';
2853:
2854: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2855: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2856: fnd_message.set_token('ERROR_CD','E014');
2857:
2858: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2859:

Line 2856: fnd_message.set_token('ERROR_CD','E014');

2852: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.exception1 ' || 'E014';
2853:
2854: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2855: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2856: fnd_message.set_token('ERROR_CD','E014');
2857:
2858: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2859:
2860: fnd_log.string_with_context( fnd_log.level_exception,

Line 2858: l_debug_str := fnd_message.get || ' ' || SQLERRM;

2854: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2855: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2856: fnd_message.set_token('ERROR_CD','E014');
2857:
2858: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2859:
2860: fnd_log.string_with_context( fnd_log.level_exception,
2861: l_label,
2862: l_debug_str, NULL,

Line 2904: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

2900: END IF;
2901:
2902: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.exception2 ' || 'E014';
2903:
2904: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2905: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2906: fnd_message.set_token('ERROR_CD','E014');
2907:
2908: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 2905: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);

2901:
2902: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.exception2 ' || 'E014';
2903:
2904: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2905: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2906: fnd_message.set_token('ERROR_CD','E014');
2907:
2908: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2909:

Line 2906: fnd_message.set_token('ERROR_CD','E014');

2902: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_eit.exception2 ' || 'E014';
2903:
2904: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2905: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2906: fnd_message.set_token('ERROR_CD','E014');
2907:
2908: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2909:
2910: fnd_log.string_with_context( fnd_log.level_exception,

Line 2908: l_debug_str := fnd_message.get || ' ' || SQLERRM;

2904: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2905: fnd_message.set_token('INTERFACE_ID',eit_rec.interface_eit_id);
2906: fnd_message.set_token('ERROR_CD','E014');
2907:
2908: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2909:
2910: fnd_log.string_with_context( fnd_log.level_exception,
2911: l_label,
2912: l_debug_str, NULL,