[Home] [Help]
725: TYPE t_distinct_batch IS TABLE OF igs_fi_lockbox_ints.batch_name%TYPE
726: INDEX BY BINARY_INTEGER;
727:
728: l_t_distinct_batch t_distinct_batch;
729: l_n_receipt_amount igs_fi_credits.amount%TYPE;
730: l_b_distinct_batch_found BOOLEAN := FALSE;
731: l_n_batch_count NUMBER(38);
732: l_n_batch_amount igs_fi_credits.amount%TYPE;
733: l_b_rec_batch BOOLEAN;
728: l_t_distinct_batch t_distinct_batch;
729: l_n_receipt_amount igs_fi_credits.amount%TYPE;
730: l_b_distinct_batch_found BOOLEAN := FALSE;
731: l_n_batch_count NUMBER(38);
732: l_n_batch_amount igs_fi_credits.amount%TYPE;
733: l_b_rec_batch BOOLEAN;
734: l_b_batch_unq BOOLEAN;
735: l_b_chg_amt_match BOOLEAN;
736: l_n_amt_appl igs_fi_lockbox_ints.applied_amt1%TYPE;
2008: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
2009: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
2010: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;
2011: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;
2012: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
2013: l_n_inv_amount_due igs_fi_inv_int.invoice_amount_due%TYPE;
2014: l_v_err_msg VARCHAR2(2000);
2015: l_b_status BOOLEAN := FALSE;
2016: BEGIN
2253: pathipat 21-Aug-2003 Enh 3076768 - Auto Release of Holds
2254: Added code to get message even if
2255: credits_api returns with status = 'S'
2256: ***************************************************************** */
2257: l_attribute_rec igs_fi_credits_api_pub.attribute_rec_type;
2258: l_credit_rec igs_fi_credit_pvt.credit_rec_type;
2259: l_v_status VARCHAR2(1);
2260: l_n_msg_count NUMBER(10);
2261: l_v_msg_data VARCHAR2(2000);
2258: l_credit_rec igs_fi_credit_pvt.credit_rec_type;
2259: l_v_status VARCHAR2(1);
2260: l_n_msg_count NUMBER(10);
2261: l_v_msg_data VARCHAR2(2000);
2262: l_n_credit_id igs_fi_credits.credit_id%TYPE;
2263: l_n_cr_activity_id igs_fi_cr_activities.credit_activity_id%TYPE;
2264: l_v_msg_txt VARCHAR2(2000);
2265: l_v_credit_number igs_fi_credits_all.credit_number%TYPE;
2266:
2261: l_v_msg_data VARCHAR2(2000);
2262: l_n_credit_id igs_fi_credits.credit_id%TYPE;
2263: l_n_cr_activity_id igs_fi_cr_activities.credit_activity_id%TYPE;
2264: l_v_msg_txt VARCHAR2(2000);
2265: l_v_credit_number igs_fi_credits_all.credit_number%TYPE;
2266:
2267:
2268:
2269: BEGIN
2427: l_n_invoice_id igs_fi_inv_int.invoice_id%TYPE;
2428: l_v_message_text VARCHAR2(2000);
2429: l_b_ro_rec_match BOOLEAN;
2430: l_n_rec_err_id igs_fi_lb_rect_errs.lockbox_receipt_error_id%TYPE;
2431: l_n_credit_id igs_fi_credits.credit_id%TYPE;
2432: l_v_status VARCHAR2(1);
2433: l_n_act_amnt_applied igs_fi_applications.amount_applied%TYPE;
2434: l_n_app_id igs_fi_applications.application_id%TYPE;
2435: l_n_rec_amnt_prc igs_fi_credits.amount%TYPE;
2431: l_n_credit_id igs_fi_credits.credit_id%TYPE;
2432: l_v_status VARCHAR2(1);
2433: l_n_act_amnt_applied igs_fi_applications.amount_applied%TYPE;
2434: l_n_app_id igs_fi_applications.application_id%TYPE;
2435: l_n_rec_amnt_prc igs_fi_credits.amount%TYPE;
2436: l_n_rec_cntr NUMBER(38);
2437: l_n_receipt_number NUMBER(38);
2438: l_n_cntr NUMBER(38);
2439: l_n_cntr1 NUMBER(38);
2438: l_n_cntr NUMBER(38);
2439: l_n_cntr1 NUMBER(38);
2440: l_b_rec_succ BOOLEAN;
2441:
2442: l_n_amount_api igs_fi_credits_all.amount%TYPE;
2443: l_n_cr_type_id_api igs_fi_cr_types_all.credit_type_id%TYPE;
2444: l_n_dflt_cr_type_id igs_fi_cr_types_all.credit_type_id%TYPE;
2445: l_v_act_plan_name igs_fi_pp_std_attrs.payment_plan_name%TYPE;
2446: l_n_act_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;
2911: p_v_attribute17 => l_t_rc_tab(l_n_cntr).attribute17,
2912: p_v_attribute18 => l_t_rc_tab(l_n_cntr).attribute18,
2913: p_v_attribute19 => l_t_rc_tab(l_n_cntr).attribute19,
2914: p_v_attribute20 => l_t_rc_tab(l_n_cntr).attribute20,
2915: p_v_desc_flex_name => 'IGS_FI_CREDITS_ALL_FLEX') THEN
2916: l_b_val_err := TRUE;
2917: log_type2_err(l_t_rc_tab(l_n_cntr).lockbox_name,
2918: l_t_rc_tab(l_n_cntr).batch_name,
2919: l_t_rc_tab(l_n_cntr).item_number);