APPS.JAI_AR_CR_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 34: pv_return_code := jai_constants.successful;

30: lv_process_flag VARCHAR2(2);
31: lv_process_message VARCHAR2(1000);
32:
33: BEGIN
34: pv_return_code := jai_constants.successful;
35:
36: BEGIN
37: OPEN c_current_sid;
38: FETCH c_current_sid INTO ln_session_id;

Line 57: pv_return_code := jai_constants.expected_error;

53: r_check_tmp_data.currency_code <> pr_new.currency_code OR
54: r_check_tmp_data.exchange_rate <> pr_new.exchange_rate
55: THEN
56: --raise_application_error(-20010,'Either of Receipt Amount or customer details or currency details are changed. Delete the record using Zoom function');
57: pv_return_code := jai_constants.expected_error;
58: pv_return_message := 'Either of Receipt Amount or customer details or currency details are changed. Delete the record using Tools Menu';
59: return;
60: END IF;
61:

Line 76: p_event => jai_constants.ar_cash_tax_confirmed,

72:
73: IF r_check_tmp_data.confirm_flag = 'Y' THEN
74:
75: jai_ar_cr_pkg.process_cm_dm(
76: p_event => jai_constants.ar_cash_tax_confirmed,
77: p_new => pr_new,
78: p_old => pr_old,
79: p_process_flag => lv_process_flag,
80: p_process_message => lv_process_message);

Line 82: IF NVL(lv_process_flag,'XX') <> jai_constants.successful THEN

78: p_old => pr_old,
79: p_process_flag => lv_process_flag,
80: p_process_message => lv_process_message);
81:
82: IF NVL(lv_process_flag,'XX') <> jai_constants.successful THEN
83: --raise_application_error(-20011, lv_process_message);
84: pv_return_code := jai_constants.expected_error;
85: pv_return_message := lv_process_message;
86: return;

Line 84: pv_return_code := jai_constants.expected_error;

80: p_process_message => lv_process_message);
81:
82: IF NVL(lv_process_flag,'XX') <> jai_constants.successful THEN
83: --raise_application_error(-20011, lv_process_message);
84: pv_return_code := jai_constants.expected_error;
85: pv_return_message := lv_process_message;
86: return;
87: END IF;
88:

Line 94: pv_return_code := jai_constants.expected_error;

90: END IF;
91:
92: ELSE
93: --raise_application_error(-20010,'First process the taxes using Zoom function and then save the form');
94: pv_return_code := jai_constants.expected_error;
95: pv_return_message := 'First process the taxes using Tools Menu and then save the form';
96: return;
97: END IF;
98: EXCEPTION

Line 100: pv_return_code := jai_constants.unexpected_error;

96: return;
97: END IF;
98: EXCEPTION
99: WHEN OTHERS THEN
100: pv_return_code := jai_constants.unexpected_error;
101: pv_return_message := 'Encountered an error in jai_ar_cash_receipts_trg_pkg.ARI_T1 ' || substr(sqlerrm,1,1900);
102:
103: END ARI_T1;
104:

Line 143: p_event => jai_constants.trx_type_rct_rvs,

139: WHERE cash_receipt_id = pr_old.cash_receipt_id;
140: ELSE
141: IF pr_old.reversal_date IS NULL AND pr_new.reversal_date is NOT NULL THEN
142: jai_ar_cr_pkg.process_cm_dm(
143: p_event => jai_constants.trx_type_rct_rvs,
144: p_new => pr_new,
145: p_old => pr_old,
146: p_process_flag => lv_process_flag,
147: p_process_message => lv_process_message);

Line 149: IF NVL(lv_process_flag,'XX') <> jai_constants.successful THEN

145: p_old => pr_old,
146: p_process_flag => lv_process_flag,
147: p_process_message => lv_process_message);
148:
149: IF NVL(lv_process_flag,'XX') <> jai_constants.successful THEN
150: --raise_application_error(-20011, lv_process_message);
151: pv_return_code := jai_constants.expected_error;
152: pv_return_message := lv_process_message;
153: return;

Line 151: pv_return_code := jai_constants.expected_error;

147: p_process_message => lv_process_message);
148:
149: IF NVL(lv_process_flag,'XX') <> jai_constants.successful THEN
150: --raise_application_error(-20011, lv_process_message);
151: pv_return_code := jai_constants.expected_error;
152: pv_return_message := lv_process_message;
153: return;
154: END IF;
155: ELSE

Line 157: pv_return_code := jai_constants.expected_error;

153: return;
154: END IF;
155: ELSE
156: --raise_application_error(-20011, 'Either receipt amount or customer details are changed. You can''t change these details. Reverse the receipt');
157: pv_return_code := jai_constants.expected_error;
158: pv_return_message := 'Either receipt amount or customer details are changed. You can''t change these details. Reverse the receipt';
159: return;
160: END IF;
161: END IF;

Line 168: pv_return_code := jai_constants.unexpected_error;

164: NULL;
165: END IF;
166: EXCEPTION
167: WHEN OTHERS THEN
168: pv_return_code := jai_constants.unexpected_error;
169: pv_return_message := 'Encountered an error in jai_ar_cash_receipts_trg_pkg.ARU_T1 ' || substr(sqlerrm,1,1900);
170: END ARU_T1;
171:
172: PROCEDURE ARD_T1 (pr_old IN t_rec%type ,

Line 203: pv_return_code := jai_constants.expected_error;

199: DELETE jai_ar_cash_receipts_all
200: WHERE cash_receipt_id = pr_old.cash_receipt_id;
201: ELSE
202: --raise_application_error(-20011, 'You can''t delete this receipt. Reverse the receipt');
203: pv_return_code := jai_constants.expected_error;
204: pv_return_message := 'You can''t delete this receipt. Reverse the receipt';
205: return;
206: END IF;
207: EXCEPTION

Line 209: pv_return_code := jai_constants.unexpected_error;

205: return;
206: END IF;
207: EXCEPTION
208: WHEN OTHERS THEN
209: pv_return_code := jai_constants.unexpected_error;
210: pv_return_message := 'Encountered an error in jai_ar_cash_receipts_trg_pkg.ARD_T1 ' || substr(sqlerrm,1,1900);
211: END ARD_T1;
212:
213: END;