APPS.IGS_FI_WAV_UTILS_001 dependencies on IGS_FI_CONTROL_ALL

Line 1865: -- Cursor to fetch the value of waiver_notify_finaid_flag from igs_fi_control_all

1861: Change History :
1862: WHO WHEN WHAT
1863: ***************************************************************** */
1864:
1865: -- Cursor to fetch the value of waiver_notify_finaid_flag from igs_fi_control_all
1866: CURSOR cur_notify_flag IS
1867: SELECT waiver_notify_finaid_flag
1868: FROM igs_fi_control_all;
1869:

Line 1868: FROM igs_fi_control_all;

1864:
1865: -- Cursor to fetch the value of waiver_notify_finaid_flag from igs_fi_control_all
1866: CURSOR cur_notify_flag IS
1867: SELECT waiver_notify_finaid_flag
1868: FROM igs_fi_control_all;
1869:
1870: -- Local variables
1871: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
1872: l_v_return_status VARCHAR2(1);

Line 1873: l_v_notify_fa_flag igs_fi_control_all.waiver_notify_finaid_flag%TYPE;

1869:
1870: -- Local variables
1871: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
1872: l_v_return_status VARCHAR2(1);
1873: l_v_notify_fa_flag igs_fi_control_all.waiver_notify_finaid_flag%TYPE;
1874:
1875: BEGIN
1876:
1877: l_v_return_status := 'S';

Line 1928: -- Fetch the value of 'Generate Notification to Financial Aid' (WAIVER_NOTIFY_FINAID_FLAG in IGS_FI_CONTROL_ALL)

1924: x_return_status := 'E';
1925: RETURN;
1926: END IF;
1927:
1928: -- Fetch the value of 'Generate Notification to Financial Aid' (WAIVER_NOTIFY_FINAID_FLAG in IGS_FI_CONTROL_ALL)
1929: -- If this value is 'Y', then invoke procedure to raise a Workflow event
1930: OPEN cur_notify_flag;
1931: FETCH cur_notify_flag INTO l_v_notify_fa_flag;
1932: IF (cur_notify_flag%NOTFOUND) THEN

Line 1933: -- If no data was found in IGS_FI_CONTROL_ALL, rollback and return E

1929: -- If this value is 'Y', then invoke procedure to raise a Workflow event
1930: OPEN cur_notify_flag;
1931: FETCH cur_notify_flag INTO l_v_notify_fa_flag;
1932: IF (cur_notify_flag%NOTFOUND) THEN
1933: -- If no data was found in IGS_FI_CONTROL_ALL, rollback and return E
1934: log_to_fnd(p_v_module => 'create_ss_waiver_transactions',
1935: p_v_string => ' Error: Error in fetching WAIVER_NOTIFY_FINAID_FLAG from IGS_FI_CONTROL_ALL, returning E after rollback');
1936: CLOSE cur_notify_flag;
1937: ROLLBACK;

Line 1935: p_v_string => ' Error: Error in fetching WAIVER_NOTIFY_FINAID_FLAG from IGS_FI_CONTROL_ALL, returning E after rollback');

1931: FETCH cur_notify_flag INTO l_v_notify_fa_flag;
1932: IF (cur_notify_flag%NOTFOUND) THEN
1933: -- If no data was found in IGS_FI_CONTROL_ALL, rollback and return E
1934: log_to_fnd(p_v_module => 'create_ss_waiver_transactions',
1935: p_v_string => ' Error: Error in fetching WAIVER_NOTIFY_FINAID_FLAG from IGS_FI_CONTROL_ALL, returning E after rollback');
1936: CLOSE cur_notify_flag;
1937: ROLLBACK;
1938: x_return_status := 'E';
1939: RETURN;

Line 1944: p_v_string => ' Fetched WAIVER_NOTIFY_FINAID_FLAG from IGS_FI_CONTROL_ALL, Value is: '||l_v_notify_fa_flag);

1940: END IF;
1941: CLOSE cur_notify_flag;
1942:
1943: log_to_fnd(p_v_module => 'create_ss_waiver_transactions',
1944: p_v_string => ' Fetched WAIVER_NOTIFY_FINAID_FLAG from IGS_FI_CONTROL_ALL, Value is: '||l_v_notify_fa_flag);
1945:
1946: -- If 'Generate Notification to Financial Aid' is Yes, raise Workflow Event.
1947: IF NVL(l_v_notify_fa_flag,'N') = 'Y' THEN
1948: log_to_fnd(p_v_module => 'create_ss_waiver_transactions',