DBA Data[Home] [Help]

APPS.IGS_AD_IMP_013 dependencies on FND_MESSAGE

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

254: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
255:
256: EXCEPTION
257: WHEN OTHERS THEN
258: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
259:
260: IF l_message_name IN ('IGS_AD_PROSPCT_XST_NO_EVAL','IGS_AD_EVAL_XST_NO_PROSPCT') THEN
261: l_error_code := 'E294';
262: ELSE

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

266:
267:
268: l_label := 'igs.plsql.igs_ad_imp_013.prc_pe_type.exception';
269:
270: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
271: fnd_message.set_token('INTERFACE_ID',p_person_type_rec.interface_person_type_id);
272: fnd_message.set_token('ERROR_CD',l_error_code);
273:
274: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 271: fnd_message.set_token('INTERFACE_ID',p_person_type_rec.interface_person_type_id);

267:
268: l_label := 'igs.plsql.igs_ad_imp_013.prc_pe_type.exception';
269:
270: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
271: fnd_message.set_token('INTERFACE_ID',p_person_type_rec.interface_person_type_id);
272: fnd_message.set_token('ERROR_CD',l_error_code);
273:
274: l_debug_str := fnd_message.get || ' ' || SQLERRM;
275:

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

268: l_label := 'igs.plsql.igs_ad_imp_013.prc_pe_type.exception';
269:
270: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
271: fnd_message.set_token('INTERFACE_ID',p_person_type_rec.interface_person_type_id);
272: fnd_message.set_token('ERROR_CD',l_error_code);
273:
274: l_debug_str := fnd_message.get || ' ' || SQLERRM;
275:
276: fnd_log.string_with_context( fnd_log.level_exception,

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

270: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
271: fnd_message.set_token('INTERFACE_ID',p_person_type_rec.interface_person_type_id);
272: fnd_message.set_token('ERROR_CD',l_error_code);
273:
274: l_debug_str := fnd_message.get || ' ' || SQLERRM;
275:
276: fnd_log.string_with_context( fnd_log.level_exception,
277: l_label,
278: l_debug_str, NULL,

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

434: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
435:
436: EXCEPTION
437: WHEN OTHERS THEN
438: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
439:
440: IF l_message_name IN ('IGS_AD_PROSPCT_XST_NO_EVAL','IGS_AD_EVAL_XST_NO_PROSPCT') THEN
441: l_error_code := 'E294';
442:

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

447:
448:
449: l_label := 'igs.plsql.igs_ad_imp_013.update_person_type.exception1';
450:
451: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
452: fnd_message.set_token('INTERFACE_ID',p_person_type_rec.interface_person_type_id);
453: fnd_message.set_token('ERROR_CD',l_error_code);
454:
455: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 452: fnd_message.set_token('INTERFACE_ID',p_person_type_rec.interface_person_type_id);

448:
449: l_label := 'igs.plsql.igs_ad_imp_013.update_person_type.exception1';
450:
451: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
452: fnd_message.set_token('INTERFACE_ID',p_person_type_rec.interface_person_type_id);
453: fnd_message.set_token('ERROR_CD',l_error_code);
454:
455: l_debug_str := fnd_message.get || ' ' || SQLERRM;
456:

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

449: l_label := 'igs.plsql.igs_ad_imp_013.update_person_type.exception1';
450:
451: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
452: fnd_message.set_token('INTERFACE_ID',p_person_type_rec.interface_person_type_id);
453: fnd_message.set_token('ERROR_CD',l_error_code);
454:
455: l_debug_str := fnd_message.get || ' ' || SQLERRM;
456:
457: fnd_log.string_with_context( fnd_log.level_exception,

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

451: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
452: fnd_message.set_token('INTERFACE_ID',p_person_type_rec.interface_person_type_id);
453: fnd_message.set_token('ERROR_CD',l_error_code);
454:
455: l_debug_str := fnd_message.get || ' ' || SQLERRM;
456:
457: fnd_log.string_with_context( fnd_log.level_exception,
458: l_label,
459: l_debug_str, NULL,

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

1362: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1363:
1364: l_label := 'igs.plsql.igs_ad_imp_028.crc_pe_acad_hist.exception '||l_msg_data;
1365:
1366: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1367: fnd_message.set_token('INTERFACE_ID',person_history_rec.interface_acadhis_id);
1368: fnd_message.set_token('ERROR_CD','E322');
1369:
1370: l_debug_str := fnd_message.get;

Line 1367: fnd_message.set_token('INTERFACE_ID',person_history_rec.interface_acadhis_id);

1363:
1364: l_label := 'igs.plsql.igs_ad_imp_028.crc_pe_acad_hist.exception '||l_msg_data;
1365:
1366: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1367: fnd_message.set_token('INTERFACE_ID',person_history_rec.interface_acadhis_id);
1368: fnd_message.set_token('ERROR_CD','E322');
1369:
1370: l_debug_str := fnd_message.get;
1371:

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

1364: l_label := 'igs.plsql.igs_ad_imp_028.crc_pe_acad_hist.exception '||l_msg_data;
1365:
1366: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1367: fnd_message.set_token('INTERFACE_ID',person_history_rec.interface_acadhis_id);
1368: fnd_message.set_token('ERROR_CD','E322');
1369:
1370: l_debug_str := fnd_message.get;
1371:
1372: fnd_log.string_with_context( fnd_log.level_exception,

Line 1370: l_debug_str := fnd_message.get;

1366: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1367: fnd_message.set_token('INTERFACE_ID',person_history_rec.interface_acadhis_id);
1368: fnd_message.set_token('ERROR_CD','E322');
1369:
1370: l_debug_str := fnd_message.get;
1371:
1372: fnd_log.string_with_context( fnd_log.level_exception,
1373: l_label,
1374: l_debug_str, NULL,

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

1533: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1534:
1535: l_label := 'igs.plsql.igs_ad_imp_028.crc_pe_acad_hist.exception '||l_msg_data;
1536:
1537: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1538: fnd_message.set_token('INTERFACE_ID',person_history_rec.interface_acadhis_id);
1539: fnd_message.set_token('ERROR_CD','E322');
1540:
1541: l_debug_str := fnd_message.get;

Line 1538: fnd_message.set_token('INTERFACE_ID',person_history_rec.interface_acadhis_id);

1534:
1535: l_label := 'igs.plsql.igs_ad_imp_028.crc_pe_acad_hist.exception '||l_msg_data;
1536:
1537: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1538: fnd_message.set_token('INTERFACE_ID',person_history_rec.interface_acadhis_id);
1539: fnd_message.set_token('ERROR_CD','E322');
1540:
1541: l_debug_str := fnd_message.get;
1542:

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

1535: l_label := 'igs.plsql.igs_ad_imp_028.crc_pe_acad_hist.exception '||l_msg_data;
1536:
1537: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1538: fnd_message.set_token('INTERFACE_ID',person_history_rec.interface_acadhis_id);
1539: fnd_message.set_token('ERROR_CD','E322');
1540:
1541: l_debug_str := fnd_message.get;
1542:
1543: fnd_log.string_with_context( fnd_log.level_exception,

Line 1541: l_debug_str := fnd_message.get;

1537: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1538: fnd_message.set_token('INTERFACE_ID',person_history_rec.interface_acadhis_id);
1539: fnd_message.set_token('ERROR_CD','E322');
1540:
1541: l_debug_str := fnd_message.get;
1542:
1543: fnd_log.string_with_context( fnd_log.level_exception,
1544: l_label,
1545: l_debug_str, NULL,

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

2302: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2303:
2304: l_label := 'igs.plsql.igs_ad_imp_028.update_pe_cred.exception '|| l_msg_data;
2305:
2306: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2307: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);
2308: fnd_message.set_token('ERROR_CD','E014');
2309:
2310: l_debug_str := fnd_message.get;

Line 2307: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);

2303:
2304: l_label := 'igs.plsql.igs_ad_imp_028.update_pe_cred.exception '|| l_msg_data;
2305:
2306: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2307: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);
2308: fnd_message.set_token('ERROR_CD','E014');
2309:
2310: l_debug_str := fnd_message.get;
2311:

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

2304: l_label := 'igs.plsql.igs_ad_imp_028.update_pe_cred.exception '|| l_msg_data;
2305:
2306: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2307: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);
2308: fnd_message.set_token('ERROR_CD','E014');
2309:
2310: l_debug_str := fnd_message.get;
2311:
2312: fnd_log.string_with_context( fnd_log.level_exception,

Line 2310: l_debug_str := fnd_message.get;

2306: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2307: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);
2308: fnd_message.set_token('ERROR_CD','E014');
2309:
2310: l_debug_str := fnd_message.get;
2311:
2312: fnd_log.string_with_context( fnd_log.level_exception,
2313: l_label,
2314: l_debug_str, NULL,

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

2404: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2405:
2406: l_label := 'igs.plsql.igs_ad_imp_028.insert_pe_cred.exception'||l_msg_data;
2407:
2408: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2409: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);
2410: fnd_message.set_token('ERROR_CD',l_error_code);
2411:
2412: l_debug_str := fnd_message.get;

Line 2409: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);

2405:
2406: l_label := 'igs.plsql.igs_ad_imp_028.insert_pe_cred.exception'||l_msg_data;
2407:
2408: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2409: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);
2410: fnd_message.set_token('ERROR_CD',l_error_code);
2411:
2412: l_debug_str := fnd_message.get;
2413:

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

2406: l_label := 'igs.plsql.igs_ad_imp_028.insert_pe_cred.exception'||l_msg_data;
2407:
2408: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2409: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);
2410: fnd_message.set_token('ERROR_CD',l_error_code);
2411:
2412: l_debug_str := fnd_message.get;
2413:
2414: fnd_log.string_with_context( fnd_log.level_exception,

Line 2412: l_debug_str := fnd_message.get;

2408: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2409: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);
2410: fnd_message.set_token('ERROR_CD',l_error_code);
2411:
2412: l_debug_str := fnd_message.get;
2413:
2414: fnd_log.string_with_context( fnd_log.level_exception,
2415: l_label,
2416: l_debug_str, NULL,

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

2439: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2440:
2441: l_label := 'igs.plsql.igs_ad_imp_028.update_pe_cred.exception '||'E322';
2442:
2443: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2444: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);
2445: fnd_message.set_token('ERROR_CD','E322');
2446:
2447: l_debug_str := fnd_message.get;

Line 2444: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);

2440:
2441: l_label := 'igs.plsql.igs_ad_imp_028.update_pe_cred.exception '||'E322';
2442:
2443: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2444: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);
2445: fnd_message.set_token('ERROR_CD','E322');
2446:
2447: l_debug_str := fnd_message.get;
2448:

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

2441: l_label := 'igs.plsql.igs_ad_imp_028.update_pe_cred.exception '||'E322';
2442:
2443: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2444: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);
2445: fnd_message.set_token('ERROR_CD','E322');
2446:
2447: l_debug_str := fnd_message.get;
2448:
2449: fnd_log.string_with_context( fnd_log.level_exception,

Line 2447: l_debug_str := fnd_message.get;

2443: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2444: fnd_message.set_token('INTERFACE_ID',cp_pe_cr_rec.interface_cred_id);
2445: fnd_message.set_token('ERROR_CD','E322');
2446:
2447: l_debug_str := fnd_message.get;
2448:
2449: fnd_log.string_with_context( fnd_log.level_exception,
2450: l_label,
2451: l_debug_str, NULL,