25: ***************************************************************** */
26:
27: g_v_ind_no CONSTANT VARCHAR2(5) := 'N';
28: g_v_line_sep CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
29: g_v_label_lb_name igs_lookup_values.meaning%TYPE;
30: g_v_noval CONSTANT VARCHAR2(10) := 'NOVALUE';
31: g_n_retcode NUMBER(1) := 0;
32: g_v_gl_date_source igs_fi_lockboxes.gl_date_source_code%TYPE;
33: g_v_user_supp_dt CONSTANT VARCHAR2(30) := 'USER_SUPPLIED_DATE';
53: g_v_batch_header CONSTANT VARCHAR2(30) := 'BATCH_HEADER';
54: g_v_tran_header CONSTANT VARCHAR2(30) := 'TRAN_HEADER';
55: g_v_lock_header CONSTANT VARCHAR2(30) := 'LOCK_HEADER';
56:
57: g_v_test_run_val igs_lookup_values.meaning%TYPE;
58: g_v_label_test_run igs_lookup_values.meaning%TYPE;
59: g_v_label_batch igs_lookup_values.meaning%TYPE;
60: g_v_label_item igs_lookup_values.meaning%TYPE;
61: g_v_label_status igs_lookup_values.meaning%TYPE;
54: g_v_tran_header CONSTANT VARCHAR2(30) := 'TRAN_HEADER';
55: g_v_lock_header CONSTANT VARCHAR2(30) := 'LOCK_HEADER';
56:
57: g_v_test_run_val igs_lookup_values.meaning%TYPE;
58: g_v_label_test_run igs_lookup_values.meaning%TYPE;
59: g_v_label_batch igs_lookup_values.meaning%TYPE;
60: g_v_label_item igs_lookup_values.meaning%TYPE;
61: g_v_label_status igs_lookup_values.meaning%TYPE;
62: g_v_label_success igs_lookup_values.meaning%TYPE;
55: g_v_lock_header CONSTANT VARCHAR2(30) := 'LOCK_HEADER';
56:
57: g_v_test_run_val igs_lookup_values.meaning%TYPE;
58: g_v_label_test_run igs_lookup_values.meaning%TYPE;
59: g_v_label_batch igs_lookup_values.meaning%TYPE;
60: g_v_label_item igs_lookup_values.meaning%TYPE;
61: g_v_label_status igs_lookup_values.meaning%TYPE;
62: g_v_label_success igs_lookup_values.meaning%TYPE;
63: g_v_label_err igs_lookup_values.meaning%TYPE;
56:
57: g_v_test_run_val igs_lookup_values.meaning%TYPE;
58: g_v_label_test_run igs_lookup_values.meaning%TYPE;
59: g_v_label_batch igs_lookup_values.meaning%TYPE;
60: g_v_label_item igs_lookup_values.meaning%TYPE;
61: g_v_label_status igs_lookup_values.meaning%TYPE;
62: g_v_label_success igs_lookup_values.meaning%TYPE;
63: g_v_label_err igs_lookup_values.meaning%TYPE;
64: g_v_label_party igs_lookup_values.meaning%TYPE;
57: g_v_test_run_val igs_lookup_values.meaning%TYPE;
58: g_v_label_test_run igs_lookup_values.meaning%TYPE;
59: g_v_label_batch igs_lookup_values.meaning%TYPE;
60: g_v_label_item igs_lookup_values.meaning%TYPE;
61: g_v_label_status igs_lookup_values.meaning%TYPE;
62: g_v_label_success igs_lookup_values.meaning%TYPE;
63: g_v_label_err igs_lookup_values.meaning%TYPE;
64: g_v_label_party igs_lookup_values.meaning%TYPE;
65: g_v_label_rec_amnt igs_lookup_values.meaning%TYPE;
58: g_v_label_test_run igs_lookup_values.meaning%TYPE;
59: g_v_label_batch igs_lookup_values.meaning%TYPE;
60: g_v_label_item igs_lookup_values.meaning%TYPE;
61: g_v_label_status igs_lookup_values.meaning%TYPE;
62: g_v_label_success igs_lookup_values.meaning%TYPE;
63: g_v_label_err igs_lookup_values.meaning%TYPE;
64: g_v_label_party igs_lookup_values.meaning%TYPE;
65: g_v_label_rec_amnt igs_lookup_values.meaning%TYPE;
66: g_v_label_bal_amnt igs_lookup_values.meaning%TYPE;
59: g_v_label_batch igs_lookup_values.meaning%TYPE;
60: g_v_label_item igs_lookup_values.meaning%TYPE;
61: g_v_label_status igs_lookup_values.meaning%TYPE;
62: g_v_label_success igs_lookup_values.meaning%TYPE;
63: g_v_label_err igs_lookup_values.meaning%TYPE;
64: g_v_label_party igs_lookup_values.meaning%TYPE;
65: g_v_label_rec_amnt igs_lookup_values.meaning%TYPE;
66: g_v_label_bal_amnt igs_lookup_values.meaning%TYPE;
67: g_v_label_cr_type igs_lookup_values.meaning%TYPE;
60: g_v_label_item igs_lookup_values.meaning%TYPE;
61: g_v_label_status igs_lookup_values.meaning%TYPE;
62: g_v_label_success igs_lookup_values.meaning%TYPE;
63: g_v_label_err igs_lookup_values.meaning%TYPE;
64: g_v_label_party igs_lookup_values.meaning%TYPE;
65: g_v_label_rec_amnt igs_lookup_values.meaning%TYPE;
66: g_v_label_bal_amnt igs_lookup_values.meaning%TYPE;
67: g_v_label_cr_type igs_lookup_values.meaning%TYPE;
68: g_v_label_dflt_cr_type igs_lookup_values.meaning%TYPE;
61: g_v_label_status igs_lookup_values.meaning%TYPE;
62: g_v_label_success igs_lookup_values.meaning%TYPE;
63: g_v_label_err igs_lookup_values.meaning%TYPE;
64: g_v_label_party igs_lookup_values.meaning%TYPE;
65: g_v_label_rec_amnt igs_lookup_values.meaning%TYPE;
66: g_v_label_bal_amnt igs_lookup_values.meaning%TYPE;
67: g_v_label_cr_type igs_lookup_values.meaning%TYPE;
68: g_v_label_dflt_cr_type igs_lookup_values.meaning%TYPE;
69: g_v_label_fee_prd igs_lookup_values.meaning%TYPE;
62: g_v_label_success igs_lookup_values.meaning%TYPE;
63: g_v_label_err igs_lookup_values.meaning%TYPE;
64: g_v_label_party igs_lookup_values.meaning%TYPE;
65: g_v_label_rec_amnt igs_lookup_values.meaning%TYPE;
66: g_v_label_bal_amnt igs_lookup_values.meaning%TYPE;
67: g_v_label_cr_type igs_lookup_values.meaning%TYPE;
68: g_v_label_dflt_cr_type igs_lookup_values.meaning%TYPE;
69: g_v_label_fee_prd igs_lookup_values.meaning%TYPE;
70: g_v_label_gl_date igs_lookup_values.meaning%TYPE;
63: g_v_label_err igs_lookup_values.meaning%TYPE;
64: g_v_label_party igs_lookup_values.meaning%TYPE;
65: g_v_label_rec_amnt igs_lookup_values.meaning%TYPE;
66: g_v_label_bal_amnt igs_lookup_values.meaning%TYPE;
67: g_v_label_cr_type igs_lookup_values.meaning%TYPE;
68: g_v_label_dflt_cr_type igs_lookup_values.meaning%TYPE;
69: g_v_label_fee_prd igs_lookup_values.meaning%TYPE;
70: g_v_label_gl_date igs_lookup_values.meaning%TYPE;
71: g_v_label_adm_appl_num igs_lookup_values.meaning%TYPE;
64: g_v_label_party igs_lookup_values.meaning%TYPE;
65: g_v_label_rec_amnt igs_lookup_values.meaning%TYPE;
66: g_v_label_bal_amnt igs_lookup_values.meaning%TYPE;
67: g_v_label_cr_type igs_lookup_values.meaning%TYPE;
68: g_v_label_dflt_cr_type igs_lookup_values.meaning%TYPE;
69: g_v_label_fee_prd igs_lookup_values.meaning%TYPE;
70: g_v_label_gl_date igs_lookup_values.meaning%TYPE;
71: g_v_label_adm_appl_num igs_lookup_values.meaning%TYPE;
72: g_v_label_charge_code igs_lookup_values.meaning%TYPE;
65: g_v_label_rec_amnt igs_lookup_values.meaning%TYPE;
66: g_v_label_bal_amnt igs_lookup_values.meaning%TYPE;
67: g_v_label_cr_type igs_lookup_values.meaning%TYPE;
68: g_v_label_dflt_cr_type igs_lookup_values.meaning%TYPE;
69: g_v_label_fee_prd igs_lookup_values.meaning%TYPE;
70: g_v_label_gl_date igs_lookup_values.meaning%TYPE;
71: g_v_label_adm_appl_num igs_lookup_values.meaning%TYPE;
72: g_v_label_charge_code igs_lookup_values.meaning%TYPE;
73: g_v_label_bank_app_amt igs_lookup_values.meaning%TYPE;
66: g_v_label_bal_amnt igs_lookup_values.meaning%TYPE;
67: g_v_label_cr_type igs_lookup_values.meaning%TYPE;
68: g_v_label_dflt_cr_type igs_lookup_values.meaning%TYPE;
69: g_v_label_fee_prd igs_lookup_values.meaning%TYPE;
70: g_v_label_gl_date igs_lookup_values.meaning%TYPE;
71: g_v_label_adm_appl_num igs_lookup_values.meaning%TYPE;
72: g_v_label_charge_code igs_lookup_values.meaning%TYPE;
73: g_v_label_bank_app_amt igs_lookup_values.meaning%TYPE;
74: g_v_label_act_app_amt igs_lookup_values.meaning%TYPE;
67: g_v_label_cr_type igs_lookup_values.meaning%TYPE;
68: g_v_label_dflt_cr_type igs_lookup_values.meaning%TYPE;
69: g_v_label_fee_prd igs_lookup_values.meaning%TYPE;
70: g_v_label_gl_date igs_lookup_values.meaning%TYPE;
71: g_v_label_adm_appl_num igs_lookup_values.meaning%TYPE;
72: g_v_label_charge_code igs_lookup_values.meaning%TYPE;
73: g_v_label_bank_app_amt igs_lookup_values.meaning%TYPE;
74: g_v_label_act_app_amt igs_lookup_values.meaning%TYPE;
75: g_v_label_num_rec igs_lookup_values.meaning%TYPE;
68: g_v_label_dflt_cr_type igs_lookup_values.meaning%TYPE;
69: g_v_label_fee_prd igs_lookup_values.meaning%TYPE;
70: g_v_label_gl_date igs_lookup_values.meaning%TYPE;
71: g_v_label_adm_appl_num igs_lookup_values.meaning%TYPE;
72: g_v_label_charge_code igs_lookup_values.meaning%TYPE;
73: g_v_label_bank_app_amt igs_lookup_values.meaning%TYPE;
74: g_v_label_act_app_amt igs_lookup_values.meaning%TYPE;
75: g_v_label_num_rec igs_lookup_values.meaning%TYPE;
76: g_v_label_cur_rec igs_lookup_values.meaning%TYPE;
69: g_v_label_fee_prd igs_lookup_values.meaning%TYPE;
70: g_v_label_gl_date igs_lookup_values.meaning%TYPE;
71: g_v_label_adm_appl_num igs_lookup_values.meaning%TYPE;
72: g_v_label_charge_code igs_lookup_values.meaning%TYPE;
73: g_v_label_bank_app_amt igs_lookup_values.meaning%TYPE;
74: g_v_label_act_app_amt igs_lookup_values.meaning%TYPE;
75: g_v_label_num_rec igs_lookup_values.meaning%TYPE;
76: g_v_label_cur_rec igs_lookup_values.meaning%TYPE;
77: g_v_label_type1 igs_lookup_values.meaning%TYPE;
70: g_v_label_gl_date igs_lookup_values.meaning%TYPE;
71: g_v_label_adm_appl_num igs_lookup_values.meaning%TYPE;
72: g_v_label_charge_code igs_lookup_values.meaning%TYPE;
73: g_v_label_bank_app_amt igs_lookup_values.meaning%TYPE;
74: g_v_label_act_app_amt igs_lookup_values.meaning%TYPE;
75: g_v_label_num_rec igs_lookup_values.meaning%TYPE;
76: g_v_label_cur_rec igs_lookup_values.meaning%TYPE;
77: g_v_label_type1 igs_lookup_values.meaning%TYPE;
78: g_v_cr_desc igs_lookup_values.meaning%TYPE;
71: g_v_label_adm_appl_num igs_lookup_values.meaning%TYPE;
72: g_v_label_charge_code igs_lookup_values.meaning%TYPE;
73: g_v_label_bank_app_amt igs_lookup_values.meaning%TYPE;
74: g_v_label_act_app_amt igs_lookup_values.meaning%TYPE;
75: g_v_label_num_rec igs_lookup_values.meaning%TYPE;
76: g_v_label_cur_rec igs_lookup_values.meaning%TYPE;
77: g_v_label_type1 igs_lookup_values.meaning%TYPE;
78: g_v_cr_desc igs_lookup_values.meaning%TYPE;
79: g_b_log_head BOOLEAN := FALSE;
72: g_v_label_charge_code igs_lookup_values.meaning%TYPE;
73: g_v_label_bank_app_amt igs_lookup_values.meaning%TYPE;
74: g_v_label_act_app_amt igs_lookup_values.meaning%TYPE;
75: g_v_label_num_rec igs_lookup_values.meaning%TYPE;
76: g_v_label_cur_rec igs_lookup_values.meaning%TYPE;
77: g_v_label_type1 igs_lookup_values.meaning%TYPE;
78: g_v_cr_desc igs_lookup_values.meaning%TYPE;
79: g_b_log_head BOOLEAN := FALSE;
80: g_v_label_type2 igs_lookup_values.meaning%TYPE;
73: g_v_label_bank_app_amt igs_lookup_values.meaning%TYPE;
74: g_v_label_act_app_amt igs_lookup_values.meaning%TYPE;
75: g_v_label_num_rec igs_lookup_values.meaning%TYPE;
76: g_v_label_cur_rec igs_lookup_values.meaning%TYPE;
77: g_v_label_type1 igs_lookup_values.meaning%TYPE;
78: g_v_cr_desc igs_lookup_values.meaning%TYPE;
79: g_b_log_head BOOLEAN := FALSE;
80: g_v_label_type2 igs_lookup_values.meaning%TYPE;
81:
74: g_v_label_act_app_amt igs_lookup_values.meaning%TYPE;
75: g_v_label_num_rec igs_lookup_values.meaning%TYPE;
76: g_v_label_cur_rec igs_lookup_values.meaning%TYPE;
77: g_v_label_type1 igs_lookup_values.meaning%TYPE;
78: g_v_cr_desc igs_lookup_values.meaning%TYPE;
79: g_b_log_head BOOLEAN := FALSE;
80: g_v_label_type2 igs_lookup_values.meaning%TYPE;
81:
82: g_v_holds_message fnd_new_messages.message_text%TYPE := NULL;
76: g_v_label_cur_rec igs_lookup_values.meaning%TYPE;
77: g_v_label_type1 igs_lookup_values.meaning%TYPE;
78: g_v_cr_desc igs_lookup_values.meaning%TYPE;
79: g_b_log_head BOOLEAN := FALSE;
80: g_v_label_type2 igs_lookup_values.meaning%TYPE;
81:
82: g_v_holds_message fnd_new_messages.message_text%TYPE := NULL;
83:
84: PROCEDURE log_line(p_v_label VARCHAR2,