APPS.IGF_SL_CL_ORIG_ACK dependencies on APP_EXCEPTION

Line 536: WHEN app_exception.record_lock_exception THEN

532: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.debug',gv_debug_str);
534: END IF;
535: RAISE;
536: WHEN app_exception.record_lock_exception THEN
537: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.debug',gv_debug_str || ' Lock ');
539: END IF;
540: RAISE;

Line 550: app_exception.raise_exception;

546: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.exception',gv_debug_str||' '|| SQLERRM);
547: END IF;
548: gv_debug_str := '';
549: igs_ge_msg_stack.add;
550: app_exception.raise_exception;
551:
552: END cl_load_file;
553:
554:

Line 1141: WHEN app_exception.record_lock_exception THEN

1137: END LOOP;
1138: CLOSE cur_1records; -- Finish inserting all the @1 and @8 Records into Resp1 and Resp2 Tables correspondingly.
1139:
1140: EXCEPTION
1141: WHEN app_exception.record_lock_exception THEN
1142: RAISE;
1143: WHEN OTHERS THEN
1144: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1145: fnd_message.set_token('NAME','IGF_SL_CL_ACK.PROCESS_1_RECORDS');

Line 1151: app_exception.raise_exception;

1147: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.exception',gv_debug_str||' '||SQLERRM);
1148: END IF;
1149: gv_debug_str := '';
1150: igs_ge_msg_stack.add;
1151: app_exception.raise_exception;
1152: END process_1_records;
1153:
1154:
1155: /* Inserts Data into Resp1 ,Resp4 and Resp8 Tables*/

Line 1865: WHEN app_exception.record_lock_exception THEN

1861: END IF;
1862: END IF;
1863: END IF;
1864: EXCEPTION
1865: WHEN app_exception.record_lock_exception THEN
1866: RAISE;
1867: WHEN OTHERS THEN
1868: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1869: fnd_message.set_token('NAME','IGF_SL_CL_ACK.INSERT_INTO_RESP1');

Line 1875: app_exception.raise_exception;

1871: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp1.exception',gv_debug_str||' '|| SQLERRM);
1872: END IF;
1873: gv_debug_str := '';
1874: igs_ge_msg_stack.add;
1875: app_exception.raise_exception;
1876: END insert_into_resp1;
1877:
1878:
1879: -- MAIN PROCEDURE

Line 2216: WHEN app_exception.record_lock_exception THEN

2212: ROLLBACK;
2213: retcode := 2;
2214: errbuf := NULL;
2215:
2216: WHEN app_exception.record_lock_exception THEN
2217: ROLLBACK;
2218: retcode := 2;
2219: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
2220: igs_ge_msg_stack.conc_exception_hndl;

Line 3290: WHEN app_exception.record_lock_exception THEN

3286:
3287: WHEN SKIP_UPDATE_LOANS THEN
3288: NULL;
3289:
3290: WHEN app_exception.record_lock_exception THEN
3291: RAISE;
3292:
3293: WHEN OTHERS THEN
3294: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

Line 3301: app_exception.raise_exception;

3297: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.update_lor.exception',gv_debug_str||' '|| SQLERRM);
3298: END IF;
3299: gv_debug_str := '';
3300: igs_ge_msg_stack.add;
3301: app_exception.raise_exception;
3302:
3303: END update_lor;
3304:
3305: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE)

Line 3955: WHEN app_exception.record_lock_exception THEN

3951: update_resp8_rec_status(loaded_1rec.clrp1_id, NULL, 'N');
3952:
3953: EXCEPTION
3954:
3955: WHEN app_exception.record_lock_exception THEN
3956: RAISE;
3957:
3958: WHEN OTHERS THEN
3959: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

Line 3966: app_exception.raise_exception;

3962: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.exception',gv_debug_str||' '|| SQLERRM);
3963: END IF;
3964: gv_debug_str := '';
3965: igs_ge_msg_stack.add;
3966: app_exception.raise_exception;
3967:
3968: END compare_disbursements;
3969:
3970:

Line 4147: app_exception.raise_exception;

4143: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp_r4.exception',gv_debug_str||' '|| SQLERRM);
4144: END IF;
4145: gv_debug_str := '';
4146: igs_ge_msg_stack.add;
4147: app_exception.raise_exception;
4148:
4149: END insert_into_resp_r4;
4150:
4151:

Line 4341: app_exception.raise_exception;

4337: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.show_alt_details.exception',gv_debug_str||' '|| SQLERRM);
4338: END IF;
4339: gv_debug_str := '';
4340: igs_ge_msg_stack.add;
4341: app_exception.raise_exception;
4342:
4343: END show_alt_details;
4344:
4345: