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

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

157: l_request_id := fnd_global.conc_request_id;
158: END IF;
159: l_label := 'igs.plsql.igs_ad_imp_025.crt_pe_house_status.exception';
160:
161: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
162: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
163: fnd_message.set_token('ERROR_CD',l_error_code);
164:
165: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 162: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);

158: END IF;
159: l_label := 'igs.plsql.igs_ad_imp_025.crt_pe_house_status.exception';
160:
161: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
162: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
163: fnd_message.set_token('ERROR_CD',l_error_code);
164:
165: l_debug_str := fnd_message.get || ' ' || SQLERRM;
166:

Line 163: fnd_message.set_token('ERROR_CD',l_error_code);

159: l_label := 'igs.plsql.igs_ad_imp_025.crt_pe_house_status.exception';
160:
161: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
162: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
163: fnd_message.set_token('ERROR_CD',l_error_code);
164:
165: l_debug_str := fnd_message.get || ' ' || SQLERRM;
166:
167: fnd_log.string_with_context( fnd_log.level_exception,

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

161: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
162: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
163: fnd_message.set_token('ERROR_CD',l_error_code);
164:
165: l_debug_str := fnd_message.get || ' ' || SQLERRM;
166:
167: fnd_log.string_with_context( fnd_log.level_exception,
168: l_label,
169: l_debug_str, NULL,

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

223: l_request_id := fnd_global.conc_request_id;
224: END IF;
225: l_label := 'igs.plsql.igs_ad_imp_025.upd_pe_house_status.exception';
226:
227: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
228: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
229: fnd_message.set_token('ERROR_CD','E114');
230:
231: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 228: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);

224: END IF;
225: l_label := 'igs.plsql.igs_ad_imp_025.upd_pe_house_status.exception';
226:
227: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
228: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
229: fnd_message.set_token('ERROR_CD','E114');
230:
231: l_debug_str := fnd_message.get || ' ' || SQLERRM;
232: fnd_log.string_with_context( fnd_log.level_exception,

Line 229: fnd_message.set_token('ERROR_CD','E114');

225: l_label := 'igs.plsql.igs_ad_imp_025.upd_pe_house_status.exception';
226:
227: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
228: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
229: fnd_message.set_token('ERROR_CD','E114');
230:
231: l_debug_str := fnd_message.get || ' ' || SQLERRM;
232: fnd_log.string_with_context( fnd_log.level_exception,
233: l_label,

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

227: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
228: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
229: fnd_message.set_token('ERROR_CD','E114');
230:
231: l_debug_str := fnd_message.get || ' ' || SQLERRM;
232: fnd_log.string_with_context( fnd_log.level_exception,
233: l_label,
234: l_debug_str, NULL,
235: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

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

330: END IF;
331:
332: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status.exception_validate_record';
333:
334: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
335: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
336: fnd_message.set_token('ERROR_CD',l_error_code);
337:
338: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 335: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);

331:
332: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status.exception_validate_record';
333:
334: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
335: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
336: fnd_message.set_token('ERROR_CD',l_error_code);
337:
338: l_debug_str := fnd_message.get || ' ' || SQLERRM;
339:

Line 336: fnd_message.set_token('ERROR_CD',l_error_code);

332: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status.exception_validate_record';
333:
334: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
335: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
336: fnd_message.set_token('ERROR_CD',l_error_code);
337:
338: l_debug_str := fnd_message.get || ' ' || SQLERRM;
339:
340: fnd_log.string_with_context( fnd_log.level_exception,

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

334: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
335: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
336: fnd_message.set_token('ERROR_CD',l_error_code);
337:
338: l_debug_str := fnd_message.get || ' ' || SQLERRM;
339:
340: fnd_log.string_with_context( fnd_log.level_exception,
341: l_label,
342: l_debug_str, NULL,

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

630:
631: EXCEPTION
632: WHEN OTHERS THEN
633:
634: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
635:
636: IF l_message_name = 'IGS_PE_INT_DT_LT_BRDT' THEN
637: p_status :='3';
638: p_error_code := 'E579';

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

654: END IF;
655:
656: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception_crt_pe_felony_dtls';
657:
658: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
659: fnd_message.set_token('INTERFACE_ID',p_felony_dtls_rec.interface_felony_dtls_id);
660: fnd_message.set_token('ERROR_CD',p_error_code);
661:
662: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 659: fnd_message.set_token('INTERFACE_ID',p_felony_dtls_rec.interface_felony_dtls_id);

655:
656: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception_crt_pe_felony_dtls';
657:
658: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
659: fnd_message.set_token('INTERFACE_ID',p_felony_dtls_rec.interface_felony_dtls_id);
660: fnd_message.set_token('ERROR_CD',p_error_code);
661:
662: l_debug_str := fnd_message.get || ' ' || SQLERRM;
663:

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

656: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception_crt_pe_felony_dtls';
657:
658: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
659: fnd_message.set_token('INTERFACE_ID',p_felony_dtls_rec.interface_felony_dtls_id);
660: fnd_message.set_token('ERROR_CD',p_error_code);
661:
662: l_debug_str := fnd_message.get || ' ' || SQLERRM;
663:
664: fnd_log.string_with_context( fnd_log.level_exception,

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

658: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
659: fnd_message.set_token('INTERFACE_ID',p_felony_dtls_rec.interface_felony_dtls_id);
660: fnd_message.set_token('ERROR_CD',p_error_code);
661:
662: l_debug_str := fnd_message.get || ' ' || SQLERRM;
663:
664: fnd_log.string_with_context( fnd_log.level_exception,
665: l_label,
666: l_debug_str, NULL,

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

843: match_ind='18'
844: WHERE interface_felony_dtls_id = felony_dtls_rec.interface_felony_dtls_id;
845: EXCEPTION
846: WHEN OTHERS THEN
847: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
848: IF l_message_name = 'IGS_PE_INT_DT_LT_BRDT' THEN
849: l_status :='3';
850: l_error_code := 'E579';
851:

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

863: END IF;
864:
865: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception';
866:
867: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
868: fnd_message.set_token('INTERFACE_ID',felony_dtls_rec.interface_felony_dtls_id);
869: fnd_message.set_token('ERROR_CD',l_error_code);
870:
871: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 868: fnd_message.set_token('INTERFACE_ID',felony_dtls_rec.interface_felony_dtls_id);

864:
865: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception';
866:
867: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
868: fnd_message.set_token('INTERFACE_ID',felony_dtls_rec.interface_felony_dtls_id);
869: fnd_message.set_token('ERROR_CD',l_error_code);
870:
871: l_debug_str := fnd_message.get || ' ' || SQLERRM;
872:

Line 869: fnd_message.set_token('ERROR_CD',l_error_code);

865: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception';
866:
867: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
868: fnd_message.set_token('INTERFACE_ID',felony_dtls_rec.interface_felony_dtls_id);
869: fnd_message.set_token('ERROR_CD',l_error_code);
870:
871: l_debug_str := fnd_message.get || ' ' || SQLERRM;
872:
873: fnd_log.string_with_context( fnd_log.level_exception,

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

867: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
868: fnd_message.set_token('INTERFACE_ID',felony_dtls_rec.interface_felony_dtls_id);
869: fnd_message.set_token('ERROR_CD',l_error_code);
870:
871: l_debug_str := fnd_message.get || ' ' || SQLERRM;
872:
873: fnd_log.string_with_context( fnd_log.level_exception,
874: l_label,
875: l_debug_str, NULL,

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

906: WHERE interface_felony_dtls_id = felony_dtls_rec.interface_felony_dtls_id;
907: EXCEPTION
908: WHEN OTHERS THEN
909:
910: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
911:
912: IF l_message_name = 'IGS_PE_INT_DT_LT_BRDT' THEN
913: l_status :='3';
914: l_error_code := 'E579';

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

927: END IF;
928:
929: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception1';
930:
931: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
932: fnd_message.set_token('INTERFACE_ID',felony_dtls_rec.interface_felony_dtls_id);
933: fnd_message.set_token('ERROR_CD',l_error_code);
934:
935: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 932: fnd_message.set_token('INTERFACE_ID',felony_dtls_rec.interface_felony_dtls_id);

928:
929: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception1';
930:
931: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
932: fnd_message.set_token('INTERFACE_ID',felony_dtls_rec.interface_felony_dtls_id);
933: fnd_message.set_token('ERROR_CD',l_error_code);
934:
935: l_debug_str := fnd_message.get || ' ' || SQLERRM;
936:

Line 933: fnd_message.set_token('ERROR_CD',l_error_code);

929: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception1';
930:
931: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
932: fnd_message.set_token('INTERFACE_ID',felony_dtls_rec.interface_felony_dtls_id);
933: fnd_message.set_token('ERROR_CD',l_error_code);
934:
935: l_debug_str := fnd_message.get || ' ' || SQLERRM;
936:
937: fnd_log.string_with_context( fnd_log.level_exception,

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

931: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
932: fnd_message.set_token('INTERFACE_ID',felony_dtls_rec.interface_felony_dtls_id);
933: fnd_message.set_token('ERROR_CD',l_error_code);
934:
935: l_debug_str := fnd_message.get || ' ' || SQLERRM;
936:
937: fnd_log.string_with_context( fnd_log.level_exception,
938: l_label,
939: l_debug_str, NULL,

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

1114:
1115: EXCEPTION
1116: WHEN OTHERS THEN
1117:
1118: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED,l_app,l_message_name);
1119:
1120: IF l_message_name = 'IGS_AD_STRT_DT_LESS_BIRTH_DT' THEN
1121: p_status :='3';
1122: p_error_code := 'E222';

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

1133: END IF;
1134:
1135: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception_crt_pe_hearing_dtls';
1136:
1137: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1138: fnd_message.set_token('INTERFACE_ID',p_hearing_dtls_rec.interface_hearing_dtls_id);
1139: fnd_message.set_token('ERROR_CD',p_error_code);
1140:
1141: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1138: fnd_message.set_token('INTERFACE_ID',p_hearing_dtls_rec.interface_hearing_dtls_id);

1134:
1135: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception_crt_pe_hearing_dtls';
1136:
1137: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1138: fnd_message.set_token('INTERFACE_ID',p_hearing_dtls_rec.interface_hearing_dtls_id);
1139: fnd_message.set_token('ERROR_CD',p_error_code);
1140:
1141: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1142:

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

1135: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception_crt_pe_hearing_dtls';
1136:
1137: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1138: fnd_message.set_token('INTERFACE_ID',p_hearing_dtls_rec.interface_hearing_dtls_id);
1139: fnd_message.set_token('ERROR_CD',p_error_code);
1140:
1141: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1142:
1143: fnd_log.string_with_context( fnd_log.level_exception,

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

1137: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1138: fnd_message.set_token('INTERFACE_ID',p_hearing_dtls_rec.interface_hearing_dtls_id);
1139: fnd_message.set_token('ERROR_CD',p_error_code);
1140:
1141: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1142:
1143: fnd_log.string_with_context( fnd_log.level_exception,
1144: l_label,
1145: l_debug_str, NULL,

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

1328: WHERE interface_hearing_dtls_id = hearing_dtls_rec.interface_hearing_dtls_id;
1329: EXCEPTION
1330: WHEN OTHERS THEN
1331:
1332: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED,l_app,l_message_name);
1333:
1334: IF l_message_name = 'IGS_AD_STRT_DT_LESS_BIRTH_DT' THEN
1335: l_status := '3' ;
1336: l_error_code := 'E222';

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

1347: END IF;
1348:
1349: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception1';
1350:
1351: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1352: fnd_message.set_token('INTERFACE_ID',hearing_dtls_rec.interface_hearing_dtls_id);
1353: fnd_message.set_token('ERROR_CD',l_error_code);
1354:
1355: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1352: fnd_message.set_token('INTERFACE_ID',hearing_dtls_rec.interface_hearing_dtls_id);

1348:
1349: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception1';
1350:
1351: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1352: fnd_message.set_token('INTERFACE_ID',hearing_dtls_rec.interface_hearing_dtls_id);
1353: fnd_message.set_token('ERROR_CD',l_error_code);
1354:
1355: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1356:

Line 1353: fnd_message.set_token('ERROR_CD',l_error_code);

1349: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception1';
1350:
1351: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1352: fnd_message.set_token('INTERFACE_ID',hearing_dtls_rec.interface_hearing_dtls_id);
1353: fnd_message.set_token('ERROR_CD',l_error_code);
1354:
1355: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1356:
1357: fnd_log.string_with_context( fnd_log.level_exception,

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

1351: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1352: fnd_message.set_token('INTERFACE_ID',hearing_dtls_rec.interface_hearing_dtls_id);
1353: fnd_message.set_token('ERROR_CD',l_error_code);
1354:
1355: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1356:
1357: fnd_log.string_with_context( fnd_log.level_exception,
1358: l_label,
1359: l_debug_str, NULL,

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

1393: WHERE interface_hearing_dtls_id = hearing_dtls_rec.interface_hearing_dtls_id;
1394: EXCEPTION
1395: WHEN OTHERS THEN
1396:
1397: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED,l_app,l_message_name);
1398:
1399: IF l_message_name = 'IGS_AD_STRT_DT_LESS_BIRTH_DT' THEN
1400: l_status := '3' ;
1401: l_error_code := 'E222';

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

1413: END IF;
1414:
1415: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception2';
1416:
1417: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1418: fnd_message.set_token('INTERFACE_ID',hearing_dtls_rec.interface_hearing_dtls_id);
1419: fnd_message.set_token('ERROR_CD',l_error_code);
1420:
1421: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1418: fnd_message.set_token('INTERFACE_ID',hearing_dtls_rec.interface_hearing_dtls_id);

1414:
1415: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception2';
1416:
1417: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1418: fnd_message.set_token('INTERFACE_ID',hearing_dtls_rec.interface_hearing_dtls_id);
1419: fnd_message.set_token('ERROR_CD',l_error_code);
1420:
1421: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1422:

Line 1419: fnd_message.set_token('ERROR_CD',l_error_code);

1415: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception2';
1416:
1417: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1418: fnd_message.set_token('INTERFACE_ID',hearing_dtls_rec.interface_hearing_dtls_id);
1419: fnd_message.set_token('ERROR_CD',l_error_code);
1420:
1421: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1422:
1423: fnd_log.string_with_context( fnd_log.level_exception,

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

1417: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1418: fnd_message.set_token('INTERFACE_ID',hearing_dtls_rec.interface_hearing_dtls_id);
1419: fnd_message.set_token('ERROR_CD',l_error_code);
1420:
1421: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1422:
1423: fnd_log.string_with_context( fnd_log.level_exception,
1424: l_label,
1425: l_debug_str, NULL,

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

1568: END IF;
1569:
1570: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.exception_crt_pe_race';
1571:
1572: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1573: fnd_message.set_token('INTERFACE_ID',p_race_rec.interface_race_id);
1574: fnd_message.set_token('ERROR_CD','E322');
1575:
1576: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1573: fnd_message.set_token('INTERFACE_ID',p_race_rec.interface_race_id);

1569:
1570: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.exception_crt_pe_race';
1571:
1572: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1573: fnd_message.set_token('INTERFACE_ID',p_race_rec.interface_race_id);
1574: fnd_message.set_token('ERROR_CD','E322');
1575:
1576: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1577:

Line 1574: fnd_message.set_token('ERROR_CD','E322');

1570: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.exception_crt_pe_race';
1571:
1572: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1573: fnd_message.set_token('INTERFACE_ID',p_race_rec.interface_race_id);
1574: fnd_message.set_token('ERROR_CD','E322');
1575:
1576: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1577:
1578: fnd_log.string_with_context( fnd_log.level_exception,

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

1572: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1573: fnd_message.set_token('INTERFACE_ID',p_race_rec.interface_race_id);
1574: fnd_message.set_token('ERROR_CD','E322');
1575:
1576: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1577:
1578: fnd_log.string_with_context( fnd_log.level_exception,
1579: l_label,
1580: l_debug_str, NULL,

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

1623: END IF;
1624:
1625: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.exception_validate_race_record';
1626:
1627: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1628: fnd_message.set_token('INTERFACE_ID',p_race_rec.interface_race_id);
1629: fnd_message.set_token('ERROR_CD',l_error_code);
1630:
1631: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1628: fnd_message.set_token('INTERFACE_ID',p_race_rec.interface_race_id);

1624:
1625: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.exception_validate_race_record';
1626:
1627: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1628: fnd_message.set_token('INTERFACE_ID',p_race_rec.interface_race_id);
1629: fnd_message.set_token('ERROR_CD',l_error_code);
1630:
1631: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1632:

Line 1629: fnd_message.set_token('ERROR_CD',l_error_code);

1625: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.exception_validate_race_record';
1626:
1627: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1628: fnd_message.set_token('INTERFACE_ID',p_race_rec.interface_race_id);
1629: fnd_message.set_token('ERROR_CD',l_error_code);
1630:
1631: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1632:
1633: fnd_log.string_with_context( fnd_log.level_exception,

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

1627: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1628: fnd_message.set_token('INTERFACE_ID',p_race_rec.interface_race_id);
1629: fnd_message.set_token('ERROR_CD',l_error_code);
1630:
1631: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1632:
1633: fnd_log.string_with_context( fnd_log.level_exception,
1634: l_label,
1635: l_debug_str, NULL,

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

1835: EXCEPTION
1836: WHEN OTHERS THEN
1837: ROLLBACK TO before_insert;
1838: -- Catch the exceptions from TBH if any.
1839: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
1840:
1841: IF (l_message_name = 'IGS_PE_FROM_DT_GRT_TO_DATE')
1842: THEN
1843: l_error_code := 'E406';

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

1863: END IF;
1864:
1865: l_label := 'igs.plsql.igs_ad_imp_025.crt_pe_priv_dtls.exception';
1866:
1867: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1868: fnd_message.set_token('INTERFACE_ID',p_priv_rec.interface_privacy_id);
1869: fnd_message.set_token('ERROR_CD',l_error_code);
1870:
1871: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1868: fnd_message.set_token('INTERFACE_ID',p_priv_rec.interface_privacy_id);

1864:
1865: l_label := 'igs.plsql.igs_ad_imp_025.crt_pe_priv_dtls.exception';
1866:
1867: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1868: fnd_message.set_token('INTERFACE_ID',p_priv_rec.interface_privacy_id);
1869: fnd_message.set_token('ERROR_CD',l_error_code);
1870:
1871: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1872:

Line 1869: fnd_message.set_token('ERROR_CD',l_error_code);

1865: l_label := 'igs.plsql.igs_ad_imp_025.crt_pe_priv_dtls.exception';
1866:
1867: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1868: fnd_message.set_token('INTERFACE_ID',p_priv_rec.interface_privacy_id);
1869: fnd_message.set_token('ERROR_CD',l_error_code);
1870:
1871: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1872:
1873: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

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

1867: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1868: fnd_message.set_token('INTERFACE_ID',p_priv_rec.interface_privacy_id);
1869: fnd_message.set_token('ERROR_CD',l_error_code);
1870:
1871: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1872:
1873: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1874: END IF;
1875:

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

1921: WHEN OTHERS THEN
1922: ROLLBACK TO before_update;
1923:
1924: -- Catch the exceptions from TBH if any.
1925: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
1926:
1927: IF (l_message_name = 'IGS_PE_FROM_DT_GRT_TO_DATE')
1928: THEN
1929: l_error_code := 'E406';

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

1949: END IF;
1950:
1951: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.exception1';
1952:
1953: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1954: fnd_message.set_token('INTERFACE_ID',p_int_rec.interface_privacy_id);
1955: fnd_message.set_token('ERROR_CD',l_error_code);
1956:
1957: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 1954: fnd_message.set_token('INTERFACE_ID',p_int_rec.interface_privacy_id);

1950:
1951: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.exception1';
1952:
1953: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1954: fnd_message.set_token('INTERFACE_ID',p_int_rec.interface_privacy_id);
1955: fnd_message.set_token('ERROR_CD',l_error_code);
1956:
1957: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1958:

Line 1955: fnd_message.set_token('ERROR_CD',l_error_code);

1951: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.exception1';
1952:
1953: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1954: fnd_message.set_token('INTERFACE_ID',p_int_rec.interface_privacy_id);
1955: fnd_message.set_token('ERROR_CD',l_error_code);
1956:
1957: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1958:
1959: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

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

1953: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1954: fnd_message.set_token('INTERFACE_ID',p_int_rec.interface_privacy_id);
1955: fnd_message.set_token('ERROR_CD',l_error_code);
1956:
1957: l_debug_str := fnd_message.get || ' ' || SQLERRM;
1958:
1959: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1960: END IF;
1961:

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

2085: l_request_id := fnd_global.conc_request_id;
2086: END IF;
2087:
2088: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.exception_validate_record';
2089: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2090: fnd_message.set_token('INTERFACE_ID',p_priv_rec.interface_privacy_id);
2091: fnd_message.set_token('ERROR_CD',l_error_code);
2092: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2093: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

Line 2090: fnd_message.set_token('INTERFACE_ID',p_priv_rec.interface_privacy_id);

2086: END IF;
2087:
2088: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.exception_validate_record';
2089: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2090: fnd_message.set_token('INTERFACE_ID',p_priv_rec.interface_privacy_id);
2091: fnd_message.set_token('ERROR_CD',l_error_code);
2092: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2093: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2094:

Line 2091: fnd_message.set_token('ERROR_CD',l_error_code);

2087:
2088: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.exception_validate_record';
2089: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2090: fnd_message.set_token('INTERFACE_ID',p_priv_rec.interface_privacy_id);
2091: fnd_message.set_token('ERROR_CD',l_error_code);
2092: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2093: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2094:
2095: END IF;

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

2088: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.exception_validate_record';
2089: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2090: fnd_message.set_token('INTERFACE_ID',p_priv_rec.interface_privacy_id);
2091: fnd_message.set_token('ERROR_CD',l_error_code);
2092: l_debug_str := fnd_message.get || ' ' || SQLERRM;
2093: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2094:
2095: END IF;
2096: