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.IGF_SL_PREF_LENDER dependencies on FND_MESSAGE

Line 116: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');

112: FOR i IN 1..l_count LOOP
113: IF g_log_tab(i).person_number IS NOT NULL THEN
114: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
115: fnd_file.put_line(fnd_file.log,'');
116: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
117: fnd_message.set_token('PERSON_NUM',g_log_tab(i).person_number);
118: fnd_file.put_line(fnd_file.log,fnd_message.get);
119: fnd_file.put_line(fnd_file.log,'');
120: END IF;

Line 117: fnd_message.set_token('PERSON_NUM',g_log_tab(i).person_number);

113: IF g_log_tab(i).person_number IS NOT NULL THEN
114: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
115: fnd_file.put_line(fnd_file.log,'');
116: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
117: fnd_message.set_token('PERSON_NUM',g_log_tab(i).person_number);
118: fnd_file.put_line(fnd_file.log,fnd_message.get);
119: fnd_file.put_line(fnd_file.log,'');
120: END IF;
121: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);

Line 118: fnd_file.put_line(fnd_file.log,fnd_message.get);

114: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
115: fnd_file.put_line(fnd_file.log,'');
116: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
117: fnd_message.set_token('PERSON_NUM',g_log_tab(i).person_number);
118: fnd_file.put_line(fnd_file.log,fnd_message.get);
119: fnd_file.put_line(fnd_file.log,'');
120: END IF;
121: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
122: END LOOP;

Line 129: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

125: WHEN others THEN
126: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
127: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.print_log_process.exception',SQLERRM);
128: END IF;
129: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
130: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.PRINT_LOG_PROCESS');
131: app_exception.raise_exception;
132:
133: END print_log_process;

Line 130: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.PRINT_LOG_PROCESS');

126: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
127: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.print_log_process.exception',SQLERRM);
128: END IF;
129: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
130: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.PRINT_LOG_PROCESS');
131: app_exception.raise_exception;
132:
133: END print_log_process;
134:

Line 161: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

157: WHEN others THEN
158: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
159: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.add_log_table_process.exception',SQLERRM);
160: END IF;
161: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
162: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.ADD_LOG_TABLE_PROCESS');
163: app_exception.raise_exception;
164:
165: END add_log_table_process;

Line 162: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.ADD_LOG_TABLE_PROCESS');

158: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
159: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.add_log_table_process.exception',SQLERRM);
160: END IF;
161: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
162: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.ADD_LOG_TABLE_PROCESS');
163: app_exception.raise_exception;
164:
165: END add_log_table_process;
166:

Line 226: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

222: WHEN others THEN
223: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
224: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.check_for_todo.exception',SQLERRM);
225: END IF;
226: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
227: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.CHECK_FOR_TODO');
228: app_exception.raise_exception;
229: END check_for_todo;
230:

Line 227: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.CHECK_FOR_TODO');

223: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
224: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.check_for_todo.exception',SQLERRM);
225: END IF;
226: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
227: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.CHECK_FOR_TODO');
228: app_exception.raise_exception;
229: END check_for_todo;
230:
231: PROCEDURE main (

Line 338: fnd_message.set_name('IGF','IGF_SL_INVALID_START_DATE');

334: BEGIN
335: l_start_date := IGS_GE_DATE.IGSDATE(p_start_date);
336: EXCEPTION
337: WHEN OTHERS THEN
338: fnd_message.set_name('IGF','IGF_SL_INVALID_START_DATE');
339: add_log_table_process(NULL,l_error,fnd_message.get);
340: l_terminate_flag := TRUE;
341: END;
342: ELSE

Line 339: add_log_table_process(NULL,l_error,fnd_message.get);

335: l_start_date := IGS_GE_DATE.IGSDATE(p_start_date);
336: EXCEPTION
337: WHEN OTHERS THEN
338: fnd_message.set_name('IGF','IGF_SL_INVALID_START_DATE');
339: add_log_table_process(NULL,l_error,fnd_message.get);
340: l_terminate_flag := TRUE;
341: END;
342: ELSE
343: l_start_date := TRUNC(SYSDATE);

Line 353: fnd_message.set_name('IGF','IGF_SL_INVALID_REL_CODE');

349: FETCH c_get_relation_code INTO l_get_relation_code;
350: CLOSE c_get_relation_code;
351:
352: IF l_get_relation_code.relationship_cd IS NULL THEN
353: fnd_message.set_name('IGF','IGF_SL_INVALID_REL_CODE');
354: add_log_table_process(NULL,l_error,fnd_message.get);
355: l_terminate_flag := TRUE;
356: END IF;
357:

Line 354: add_log_table_process(NULL,l_error,fnd_message.get);

350: CLOSE c_get_relation_code;
351:
352: IF l_get_relation_code.relationship_cd IS NULL THEN
353: fnd_message.set_name('IGF','IGF_SL_INVALID_REL_CODE');
354: add_log_table_process(NULL,l_error,fnd_message.get);
355: l_terminate_flag := TRUE;
356: END IF;
357:
358: -- validation for the person id group

Line 365: fnd_message.set_name('IGS','IGS_FI_INVPERS_ID_GRP');

361: FETCH c_chk_perid_grp INTO l_chk_perid_grp;
362: CLOSE c_chk_perid_grp;
363:
364: IF l_chk_perid_grp.group_cd IS NULL THEN
365: fnd_message.set_name('IGS','IGS_FI_INVPERS_ID_GRP');
366: add_log_table_process(NULL,l_error,fnd_message.get);
367: l_terminate_flag := TRUE;
368: END IF;
369:

Line 366: add_log_table_process(NULL,l_error,fnd_message.get);

362: CLOSE c_chk_perid_grp;
363:
364: IF l_chk_perid_grp.group_cd IS NULL THEN
365: fnd_message.set_name('IGS','IGS_FI_INVPERS_ID_GRP');
366: add_log_table_process(NULL,l_error,fnd_message.get);
367: l_terminate_flag := TRUE;
368: END IF;
369:
370: -- if either of the above condition fails then log the message in log file and exit.

Line 428: fnd_message.set_name('IGF','IGF_SL_CL_LEND_ADD');

424: );
425: -- here exception will be raised if the lender setup is invalid after performing the above operation
426: -- the validation is done in the TBH of igf_sl_cl_pref_lenders
427: -- if no exception is raised then add the sucessful message to the log
428: fnd_message.set_name('IGF','IGF_SL_CL_LEND_ADD');
429: fnd_message.set_token('PERS_NUM',l_person_number);
430: fnd_message.set_token('REL_CODE',p_rel_code);
431: add_log_table_process(l_person_number,'',fnd_message.get);
432: check_for_todo(l_person_id);

Line 429: fnd_message.set_token('PERS_NUM',l_person_number);

425: -- here exception will be raised if the lender setup is invalid after performing the above operation
426: -- the validation is done in the TBH of igf_sl_cl_pref_lenders
427: -- if no exception is raised then add the sucessful message to the log
428: fnd_message.set_name('IGF','IGF_SL_CL_LEND_ADD');
429: fnd_message.set_token('PERS_NUM',l_person_number);
430: fnd_message.set_token('REL_CODE',p_rel_code);
431: add_log_table_process(l_person_number,'',fnd_message.get);
432: check_for_todo(l_person_id);
433: EXCEPTION WHEN OTHERS THEN

Line 430: fnd_message.set_token('REL_CODE',p_rel_code);

426: -- the validation is done in the TBH of igf_sl_cl_pref_lenders
427: -- if no exception is raised then add the sucessful message to the log
428: fnd_message.set_name('IGF','IGF_SL_CL_LEND_ADD');
429: fnd_message.set_token('PERS_NUM',l_person_number);
430: fnd_message.set_token('REL_CODE',p_rel_code);
431: add_log_table_process(l_person_number,'',fnd_message.get);
432: check_for_todo(l_person_id);
433: EXCEPTION WHEN OTHERS THEN
434: -- check which messgae is there in the stack and display the appropriate message

Line 431: add_log_table_process(l_person_number,'',fnd_message.get);

427: -- if no exception is raised then add the sucessful message to the log
428: fnd_message.set_name('IGF','IGF_SL_CL_LEND_ADD');
429: fnd_message.set_token('PERS_NUM',l_person_number);
430: fnd_message.set_token('REL_CODE',p_rel_code);
431: add_log_table_process(l_person_number,'',fnd_message.get);
432: check_for_todo(l_person_id);
433: EXCEPTION WHEN OTHERS THEN
434: -- check which messgae is there in the stack and display the appropriate message
435: fnd_message.parse_encoded(fnd_message.get_encoded,l_app,l_message);

Line 435: fnd_message.parse_encoded(fnd_message.get_encoded,l_app,l_message);

431: add_log_table_process(l_person_number,'',fnd_message.get);
432: check_for_todo(l_person_id);
433: EXCEPTION WHEN OTHERS THEN
434: -- check which messgae is there in the stack and display the appropriate message
435: fnd_message.parse_encoded(fnd_message.get_encoded,l_app,l_message);
436: IF l_message IS NOT NULL THEN
437: fnd_message.set_name(l_app,l_message);
438: add_log_table_process(l_person_number,l_error,fnd_message.get);
439: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

Line 437: fnd_message.set_name(l_app,l_message);

433: EXCEPTION WHEN OTHERS THEN
434: -- check which messgae is there in the stack and display the appropriate message
435: fnd_message.parse_encoded(fnd_message.get_encoded,l_app,l_message);
436: IF l_message IS NOT NULL THEN
437: fnd_message.set_name(l_app,l_message);
438: add_log_table_process(l_person_number,l_error,fnd_message.get);
439: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
440: add_log_table_process(NULL,l_error,fnd_message.get);
441: ROLLBACK TO sp1;

Line 438: add_log_table_process(l_person_number,l_error,fnd_message.get);

434: -- check which messgae is there in the stack and display the appropriate message
435: fnd_message.parse_encoded(fnd_message.get_encoded,l_app,l_message);
436: IF l_message IS NOT NULL THEN
437: fnd_message.set_name(l_app,l_message);
438: add_log_table_process(l_person_number,l_error,fnd_message.get);
439: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
440: add_log_table_process(NULL,l_error,fnd_message.get);
441: ROLLBACK TO sp1;
442: l_error_flag := TRUE;

Line 439: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

435: fnd_message.parse_encoded(fnd_message.get_encoded,l_app,l_message);
436: IF l_message IS NOT NULL THEN
437: fnd_message.set_name(l_app,l_message);
438: add_log_table_process(l_person_number,l_error,fnd_message.get);
439: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
440: add_log_table_process(NULL,l_error,fnd_message.get);
441: ROLLBACK TO sp1;
442: l_error_flag := TRUE;
443: END IF;

Line 440: add_log_table_process(NULL,l_error,fnd_message.get);

436: IF l_message IS NOT NULL THEN
437: fnd_message.set_name(l_app,l_message);
438: add_log_table_process(l_person_number,l_error,fnd_message.get);
439: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
440: add_log_table_process(NULL,l_error,fnd_message.get);
441: ROLLBACK TO sp1;
442: l_error_flag := TRUE;
443: END IF;
444: END;

Line 453: fnd_message.set_name('IGF','IGF_SL_CL_LEND_EXISTS');

449: END IF;
450: -- means already the active lender exists
451: IF l_chk_pref_lender.relationship_cd = p_rel_code THEN
452: -- means same active relationship already exists
453: fnd_message.set_name('IGF','IGF_SL_CL_LEND_EXISTS');
454: add_log_table_process(l_person_number,l_error,fnd_message.get);
455: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
456: add_log_table_process(NULL,l_error,fnd_message.get);
457: l_error_flag := TRUE;

Line 454: add_log_table_process(l_person_number,l_error,fnd_message.get);

450: -- means already the active lender exists
451: IF l_chk_pref_lender.relationship_cd = p_rel_code THEN
452: -- means same active relationship already exists
453: fnd_message.set_name('IGF','IGF_SL_CL_LEND_EXISTS');
454: add_log_table_process(l_person_number,l_error,fnd_message.get);
455: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
456: add_log_table_process(NULL,l_error,fnd_message.get);
457: l_error_flag := TRUE;
458: ELSE

Line 455: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

451: IF l_chk_pref_lender.relationship_cd = p_rel_code THEN
452: -- means same active relationship already exists
453: fnd_message.set_name('IGF','IGF_SL_CL_LEND_EXISTS');
454: add_log_table_process(l_person_number,l_error,fnd_message.get);
455: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
456: add_log_table_process(NULL,l_error,fnd_message.get);
457: l_error_flag := TRUE;
458: ELSE
459: IF p_update = 'N' THEN

Line 456: add_log_table_process(NULL,l_error,fnd_message.get);

452: -- means same active relationship already exists
453: fnd_message.set_name('IGF','IGF_SL_CL_LEND_EXISTS');
454: add_log_table_process(l_person_number,l_error,fnd_message.get);
455: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
456: add_log_table_process(NULL,l_error,fnd_message.get);
457: l_error_flag := TRUE;
458: ELSE
459: IF p_update = 'N' THEN
460: -- log a message that existing relationship cannot be updated

Line 461: fnd_message.set_name('IGF','IGF_SL_CL_LEND_NOT_ADD');

457: l_error_flag := TRUE;
458: ELSE
459: IF p_update = 'N' THEN
460: -- log a message that existing relationship cannot be updated
461: fnd_message.set_name('IGF','IGF_SL_CL_LEND_NOT_ADD');
462: add_log_table_process(l_person_number,l_error,fnd_message.get);
463: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
464: add_log_table_process(NULL,l_error,fnd_message.get);
465: l_error_flag := TRUE;

Line 462: add_log_table_process(l_person_number,l_error,fnd_message.get);

458: ELSE
459: IF p_update = 'N' THEN
460: -- log a message that existing relationship cannot be updated
461: fnd_message.set_name('IGF','IGF_SL_CL_LEND_NOT_ADD');
462: add_log_table_process(l_person_number,l_error,fnd_message.get);
463: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
464: add_log_table_process(NULL,l_error,fnd_message.get);
465: l_error_flag := TRUE;
466: ELSE

Line 463: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

459: IF p_update = 'N' THEN
460: -- log a message that existing relationship cannot be updated
461: fnd_message.set_name('IGF','IGF_SL_CL_LEND_NOT_ADD');
462: add_log_table_process(l_person_number,l_error,fnd_message.get);
463: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
464: add_log_table_process(NULL,l_error,fnd_message.get);
465: l_error_flag := TRUE;
466: ELSE
467: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 464: add_log_table_process(NULL,l_error,fnd_message.get);

460: -- log a message that existing relationship cannot be updated
461: fnd_message.set_name('IGF','IGF_SL_CL_LEND_NOT_ADD');
462: add_log_table_process(l_person_number,l_error,fnd_message.get);
463: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
464: add_log_table_process(NULL,l_error,fnd_message.get);
465: l_error_flag := TRUE;
466: ELSE
467: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
468: l_debug_str := l_debug_str || ' Previous record has to be updated';

Line 500: fnd_message.set_name('IGF','IGF_SL_CL_LEND_ADD');

496: );
497: -- here exception will be raised if the lender setup is invalid after performing the above operation
498: -- the validation is done in the TBH of igf_sl_cl_pref_lenders
499: -- if no exception is raised then add the sucessful message to the log
500: fnd_message.set_name('IGF','IGF_SL_CL_LEND_ADD');
501: fnd_message.set_token('PERS_NUM',l_person_number);
502: fnd_message.set_token('REL_CODE',p_rel_code);
503: add_log_table_process(l_person_number,'',fnd_message.get);
504:

Line 501: fnd_message.set_token('PERS_NUM',l_person_number);

497: -- here exception will be raised if the lender setup is invalid after performing the above operation
498: -- the validation is done in the TBH of igf_sl_cl_pref_lenders
499: -- if no exception is raised then add the sucessful message to the log
500: fnd_message.set_name('IGF','IGF_SL_CL_LEND_ADD');
501: fnd_message.set_token('PERS_NUM',l_person_number);
502: fnd_message.set_token('REL_CODE',p_rel_code);
503: add_log_table_process(l_person_number,'',fnd_message.get);
504:
505: check_for_todo(l_person_id);

Line 502: fnd_message.set_token('REL_CODE',p_rel_code);

498: -- the validation is done in the TBH of igf_sl_cl_pref_lenders
499: -- if no exception is raised then add the sucessful message to the log
500: fnd_message.set_name('IGF','IGF_SL_CL_LEND_ADD');
501: fnd_message.set_token('PERS_NUM',l_person_number);
502: fnd_message.set_token('REL_CODE',p_rel_code);
503: add_log_table_process(l_person_number,'',fnd_message.get);
504:
505: check_for_todo(l_person_id);
506: EXCEPTION WHEN OTHERS THEN

Line 503: add_log_table_process(l_person_number,'',fnd_message.get);

499: -- if no exception is raised then add the sucessful message to the log
500: fnd_message.set_name('IGF','IGF_SL_CL_LEND_ADD');
501: fnd_message.set_token('PERS_NUM',l_person_number);
502: fnd_message.set_token('REL_CODE',p_rel_code);
503: add_log_table_process(l_person_number,'',fnd_message.get);
504:
505: check_for_todo(l_person_id);
506: EXCEPTION WHEN OTHERS THEN
507: -- check which messgae is there in the stack and display the appropriate message

Line 508: fnd_message.parse_encoded(fnd_message.get_encoded,l_app,l_message);

504:
505: check_for_todo(l_person_id);
506: EXCEPTION WHEN OTHERS THEN
507: -- check which messgae is there in the stack and display the appropriate message
508: fnd_message.parse_encoded(fnd_message.get_encoded,l_app,l_message);
509: IF l_message IS NOT NULL THEN
510: fnd_message.set_name(l_app,l_message);
511: add_log_table_process(l_person_number,l_error,fnd_message.get);
512: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

Line 510: fnd_message.set_name(l_app,l_message);

506: EXCEPTION WHEN OTHERS THEN
507: -- check which messgae is there in the stack and display the appropriate message
508: fnd_message.parse_encoded(fnd_message.get_encoded,l_app,l_message);
509: IF l_message IS NOT NULL THEN
510: fnd_message.set_name(l_app,l_message);
511: add_log_table_process(l_person_number,l_error,fnd_message.get);
512: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
513: add_log_table_process(NULL,l_error,fnd_message.get);
514: ROLLBACK TO sp1;

Line 511: add_log_table_process(l_person_number,l_error,fnd_message.get);

507: -- check which messgae is there in the stack and display the appropriate message
508: fnd_message.parse_encoded(fnd_message.get_encoded,l_app,l_message);
509: IF l_message IS NOT NULL THEN
510: fnd_message.set_name(l_app,l_message);
511: add_log_table_process(l_person_number,l_error,fnd_message.get);
512: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
513: add_log_table_process(NULL,l_error,fnd_message.get);
514: ROLLBACK TO sp1;
515: l_error_flag := TRUE;

Line 512: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

508: fnd_message.parse_encoded(fnd_message.get_encoded,l_app,l_message);
509: IF l_message IS NOT NULL THEN
510: fnd_message.set_name(l_app,l_message);
511: add_log_table_process(l_person_number,l_error,fnd_message.get);
512: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
513: add_log_table_process(NULL,l_error,fnd_message.get);
514: ROLLBACK TO sp1;
515: l_error_flag := TRUE;
516: END IF;

Line 513: add_log_table_process(NULL,l_error,fnd_message.get);

509: IF l_message IS NOT NULL THEN
510: fnd_message.set_name(l_app,l_message);
511: add_log_table_process(l_person_number,l_error,fnd_message.get);
512: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
513: add_log_table_process(NULL,l_error,fnd_message.get);
514: ROLLBACK TO sp1;
515: l_error_flag := TRUE;
516: END IF;
517: END;

Line 539: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

535: EXCEPTION
536: WHEN OTHERS THEN
537: l_debug_str := NULL;
538: l_error_flag := FALSE;
539: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
540: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.MAIN');
541: add_log_table_process(l_person_number,l_error,fnd_message.get || ' ' || SQLERRM);
542: ROLLBACK TO sp1;
543: END;

Line 540: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.MAIN');

536: WHEN OTHERS THEN
537: l_debug_str := NULL;
538: l_error_flag := FALSE;
539: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
540: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.MAIN');
541: add_log_table_process(l_person_number,l_error,fnd_message.get || ' ' || SQLERRM);
542: ROLLBACK TO sp1;
543: END;
544: -- commit the sucessful record

Line 541: add_log_table_process(l_person_number,l_error,fnd_message.get || ' ' || SQLERRM);

537: l_debug_str := NULL;
538: l_error_flag := FALSE;
539: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
540: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.MAIN');
541: add_log_table_process(l_person_number,l_error,fnd_message.get || ' ' || SQLERRM);
542: ROLLBACK TO sp1;
543: END;
544: -- commit the sucessful record
545: COMMIT;

Line 551: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');

547: CLOSE c_get_persons;
548:
549: -- if no record is processed then display the following message
550: IF l_success_record_cnt = 0 AND l_error_record_cnt = 0 THEN
551: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
552: add_log_table_process(NULL,l_error,fnd_message.get);
553: END IF;
554:
555: -- CALL THE PRINT LOG PROCESS

Line 552: add_log_table_process(NULL,l_error,fnd_message.get);

548:
549: -- if no record is processed then display the following message
550: IF l_success_record_cnt = 0 AND l_error_record_cnt = 0 THEN
551: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
552: add_log_table_process(NULL,l_error,fnd_message.get);
553: END IF;
554:
555: -- CALL THE PRINT LOG PROCESS
556: print_log_process(l_start_date,l_chk_perid_grp.group_cd,p_rel_code,p_update);

Line 564: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

560: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
561: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.main.exception',SQLERRM);
562: END IF;
563: ROLLBACK;
564: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
565: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.MAIN');
566: retcode := 2;
567: errbuf := fnd_message.get;
568: igs_ge_msg_stack.conc_exception_hndl;

Line 565: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.MAIN');

561: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.main.exception',SQLERRM);
562: END IF;
563: ROLLBACK;
564: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
565: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.MAIN');
566: retcode := 2;
567: errbuf := fnd_message.get;
568: igs_ge_msg_stack.conc_exception_hndl;
569:

Line 567: errbuf := fnd_message.get;

563: ROLLBACK;
564: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
565: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.MAIN');
566: retcode := 2;
567: errbuf := fnd_message.get;
568: igs_ge_msg_stack.conc_exception_hndl;
569:
570: END main;
571: