333: x_eligible_amount := NULL;
334: x_return_status := 'E';
335:
336: -- Log the SQLERRM message
337: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
338: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.get_eligible_waiver_amt.exception','sqlerrm ' || SQLERRM);
339: END IF;
340:
341: END get_eligible_waiver_amt;
334: x_return_status := 'E';
335:
336: -- Log the SQLERRM message
337: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
338: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.get_eligible_waiver_amt.exception','sqlerrm ' || SQLERRM);
339: END IF;
340:
341: END get_eligible_waiver_amt;
342:
752: ROLLBACK TO apply_waivers_sp;
753: x_return_status := 'E';
754:
755: -- Log the SQLERRM message
756: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
757: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.apply_waivers.exception','sqlerrm ' || SQLERRM);
758: END IF;
759:
760: END apply_waivers;
753: x_return_status := 'E';
754:
755: -- Log the SQLERRM message
756: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
757: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.apply_waivers.exception','sqlerrm ' || SQLERRM);
758: END IF;
759:
760: END apply_waivers;
761:
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057:
1058: -- Log the SQLERRM message and return to the apply_waivers Procedure
1059: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1060: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.process_wavadj_charges.exception','sqlerrm ' || SQLERRM);
1061: END IF;
1062:
1063: x_return_status := 'E';
1056: WHEN OTHERS THEN
1057:
1058: -- Log the SQLERRM message and return to the apply_waivers Procedure
1059: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1060: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.process_wavadj_charges.exception','sqlerrm ' || SQLERRM);
1061: END IF;
1062:
1063: x_return_status := 'E';
1064:
1190: EXCEPTION
1191: WHEN OTHERS THEN
1192:
1193: -- Log the SQLERRM message and return to the apply_waivers procedure
1194: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1195: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.process_stdnt_charges.exception','sqlerrm ' || SQLERRM);
1196: END IF;
1197:
1198: -- Return the Error Status
1191: WHEN OTHERS THEN
1192:
1193: -- Log the SQLERRM message and return to the apply_waivers procedure
1194: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1195: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.process_stdnt_charges.exception','sqlerrm ' || SQLERRM);
1196: END IF;
1197:
1198: -- Return the Error Status
1199: x_return_status := 'E';
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367:
1368: -- Log the SQLERRM message and return to the apply_waivers Procedure
1369: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1370: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.adjust_stdnt_charges.exception','sqlerrm ' || SQLERRM);
1371: END IF;
1372:
1373: -- Return the Error Status
1366: WHEN OTHERS THEN
1367:
1368: -- Log the SQLERRM message and return to the apply_waivers Procedure
1369: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1370: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.adjust_stdnt_charges.exception','sqlerrm ' || SQLERRM);
1371: END IF;
1372:
1373: -- Return the Error Status
1374: x_return_status := 'E';
1477:
1478: EXCEPTION
1479: WHEN OTHERS THEN
1480: -- Log the SQLERRM message and return the Error status
1481: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1482: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.create_wavadj_charge.exception','sqlerrm ' || SQLERRM);
1483: END IF;
1484:
1485: -- Return the Error Status
1478: EXCEPTION
1479: WHEN OTHERS THEN
1480: -- Log the SQLERRM message and return the Error status
1481: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1482: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.create_wavadj_charge.exception','sqlerrm ' || SQLERRM);
1483: END IF;
1484:
1485: -- Return the Error Status
1486: x_return_status := 'E';
1804: EXCEPTION
1805:
1806: WHEN OTHERS THEN
1807: -- Log the SQLERRM message
1808: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1809: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.process_due_wavadj_charges.exception','sqlerrm ' || SQLERRM);
1810: END IF;
1811:
1812: -- Return the Error Status
1805:
1806: WHEN OTHERS THEN
1807: -- Log the SQLERRM message
1808: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1809: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.process_due_wavadj_charges.exception','sqlerrm ' || SQLERRM);
1810: END IF;
1811:
1812: -- Return the Error Status
1813: x_return_status := 'E';
1828:
1829: BEGIN
1830:
1831: -- If current Logging Level is less than or equal to Statement Level, then log the message
1832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1833: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_fi_wav_utils_001.'||p_v_module, p_v_string);
1834: END IF;
1835:
1836: END log_to_fnd;
1829: BEGIN
1830:
1831: -- If current Logging Level is less than or equal to Statement Level, then log the message
1832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1833: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_fi_wav_utils_001.'||p_v_module, p_v_string);
1834: END IF;
1835:
1836: END log_to_fnd;
1837: