APPS.IGS_FI_WAV_UTILS_001 dependencies on IGS_FI_WAV_UTILS_001

Line 1: PACKAGE BODY igs_fi_wav_utils_001 AS

1: PACKAGE BODY igs_fi_wav_utils_001 AS
2: /* $Header: IGSFI95B.pls 120.2 2005/11/07 16:08:58 appldev noship $ */
3:
4: /******************************************************************
5: Created By : Anji Yedubati

Line 338: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.get_eligible_waiver_amt.exception','sqlerrm ' || SQLERRM);

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:

Line 757: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.apply_waivers.exception','sqlerrm ' || SQLERRM);

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:

Line 1060: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.process_wavadj_charges.exception','sqlerrm ' || SQLERRM);

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:

Line 1195: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.process_stdnt_charges.exception','sqlerrm ' || SQLERRM);

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';

Line 1370: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.adjust_stdnt_charges.exception','sqlerrm ' || SQLERRM);

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';

Line 1482: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.create_wavadj_charge.exception','sqlerrm ' || SQLERRM);

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';

Line 1809: fnd_log.string(fnd_log.level_exception,'igs.plsql.igs_fi_wav_utils_001.process_due_wavadj_charges.exception','sqlerrm ' || SQLERRM);

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';

Line 1833: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_fi_wav_utils_001.'||p_v_module, p_v_string);

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:

Line 1903: p_v_string => ' Invoking igs_fi_wav_utils_001.apply_waivers for given Person, Waiver and Fee Period');

1899: RETURN;
1900: END IF;
1901:
1902: log_to_fnd(p_v_module => 'create_ss_waiver_transactions',
1903: p_v_string => ' Invoking igs_fi_wav_utils_001.apply_waivers for given Person, Waiver and Fee Period');
1904:
1905: -- Invoke procedure to Apply the Waivers.
1906: igs_fi_wav_utils_001.apply_waivers(p_n_person_id => p_n_person_id,
1907: p_v_fee_cal_type => p_v_fee_cal_type,

Line 1906: igs_fi_wav_utils_001.apply_waivers(p_n_person_id => p_n_person_id,

1902: log_to_fnd(p_v_module => 'create_ss_waiver_transactions',
1903: p_v_string => ' Invoking igs_fi_wav_utils_001.apply_waivers for given Person, Waiver and Fee Period');
1904:
1905: -- Invoke procedure to Apply the Waivers.
1906: igs_fi_wav_utils_001.apply_waivers(p_n_person_id => p_n_person_id,
1907: p_v_fee_cal_type => p_v_fee_cal_type,
1908: p_n_fee_ci_seq_number => p_n_fee_ci_seq_number,
1909: p_v_waiver_name => p_v_waiver_name,
1910: p_v_target_fee_type => p_v_target_fee_type,

Line 1922: p_v_string => ' Error: Error from igs_fi_wav_utils_001.apply_waivers, returning E after rollback');

1918: x_return_status => l_v_return_status);
1919: -- If the above call returns E, then rollback and return from the procedure
1920: IF (l_v_return_status = 'E') THEN
1921: log_to_fnd(p_v_module => 'create_ss_waiver_transactions',
1922: p_v_string => ' Error: Error from igs_fi_wav_utils_001.apply_waivers, returning E after rollback');
1923: ROLLBACK;
1924: x_return_status := 'E';
1925: RETURN;
1926: END IF;

Line 1969: END igs_fi_wav_utils_001;

1965: x_return_status := 'E';
1966:
1967: END create_ss_waiver_transactions;
1968:
1969: END igs_fi_wav_utils_001;