APPS.JAI_AR_CR_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 54: pv_return_code := jai_constants.successful;

50: lv_regime_code varchar2(50);
51: /*Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952 End*/
52:
53: BEGIN
54: pv_return_code := jai_constants.successful;
55:
56: BEGIN
57: OPEN c_current_sid;
58: FETCH c_current_sid INTO ln_session_id;

Line 81: pv_return_code := jai_constants.expected_error;

77: r_check_tmp_data.currency_code <> pr_new.currency_code OR
78: r_check_tmp_data.exchange_rate <> pr_new.exchange_rate
79: THEN
80: --raise_application_error(-20010,'Either of Receipt Amount or customer details or currency details are changed. Delete the record using Zoom function');
81: pv_return_code := jai_constants.expected_error;
82: pv_return_message := 'Either of Receipt Amount or customer details or currency details are changed. Delete the record using Tools Menu';
83: return;
84: END IF;
85:

Line 99: p_event => jai_constants.trx_type_adv_rcpts,--Changed by Qiong from ar_cash_tax_confirmed to trx_type_adv_rcpts for bug13569249

95: AND source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL';
96:
97: IF r_check_tmp_data.confirm_flag = 'Y' THEN
98: jai_ar_cr_pkg.process_cm_dm(
99: p_event => jai_constants.trx_type_adv_rcpts,--Changed by Qiong from ar_cash_tax_confirmed to trx_type_adv_rcpts for bug13569249
100: p_new => pr_new,
101: p_old => pr_old,
102: p_process_flag => lv_process_flag,
103: p_process_message => lv_process_message);

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

101: p_old => pr_old,
102: p_process_flag => lv_process_flag,
103: p_process_message => lv_process_message);
104:
105: IF NVL(lv_process_flag,'XX') <> jai_constants.successful THEN
106: --raise_application_error(-20011, lv_process_message);
107: pv_return_code := jai_constants.expected_error;
108: pv_return_message := lv_process_message;
109: return;

Line 107: pv_return_code := jai_constants.expected_error;

103: p_process_message => lv_process_message);
104:
105: IF NVL(lv_process_flag,'XX') <> jai_constants.successful THEN
106: --raise_application_error(-20011, lv_process_message);
107: pv_return_code := jai_constants.expected_error;
108: pv_return_message := lv_process_message;
109: return;
110: END IF;
111:

Line 118: pv_return_code := jai_constants.expected_error;

114:
115: ELSIF r_check_tmp_data.loc_cash_receipt_id IS NULL AND upper(nvl(lv_regime_code,'####')) = 'TCS' THEN
116: --Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952
117: --raise_application_error(-20010,'First process the taxes using Zoom function and then save the form');
118: pv_return_code := jai_constants.expected_error;
119: pv_return_message := 'First process the taxes using Tools Menu and then save the form';
120: return;
121: END IF;
122: EXCEPTION

Line 124: pv_return_code := jai_constants.unexpected_error;

120: return;
121: END IF;
122: EXCEPTION
123: WHEN OTHERS THEN
124: pv_return_code := jai_constants.unexpected_error;
125: pv_return_message := 'Encountered an error in jai_ar_cash_receipts_trg_pkg.ARI_T1 ' || substr(sqlerrm,1,1900);
126:
127: END ARI_T1;
128:

Line 168: p_event => jai_constants.trx_type_rct_rvs,

164: ELSE
165: IF pr_old.reversal_date IS NULL AND pr_new.reversal_date is NOT NULL THEN
166:
167: jai_ar_cr_pkg.process_cm_dm(
168: p_event => jai_constants.trx_type_rct_rvs,
169: p_new => pr_new,
170: p_old => pr_old,
171: p_process_flag => lv_process_flag,
172: p_process_message => lv_process_message);

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

170: p_old => pr_old,
171: p_process_flag => lv_process_flag,
172: p_process_message => lv_process_message);
173:
174: IF NVL(lv_process_flag,'XX') <> jai_constants.successful THEN
175: --raise_application_error(-20011, lv_process_message);
176: pv_return_code := jai_constants.expected_error;
177: pv_return_message := lv_process_message;
178: return;

Line 176: pv_return_code := jai_constants.expected_error;

172: p_process_message => lv_process_message);
173:
174: IF NVL(lv_process_flag,'XX') <> jai_constants.successful THEN
175: --raise_application_error(-20011, lv_process_message);
176: pv_return_code := jai_constants.expected_error;
177: pv_return_message := lv_process_message;
178: return;
179: END IF;
180: ELSE

Line 182: pv_return_code := jai_constants.expected_error;

178: return;
179: END IF;
180: ELSE
181: --raise_application_error(-20011, 'Either receipt amount or customer details are changed. You can''t change these details. Reverse the receipt');
182: pv_return_code := jai_constants.expected_error;
183: pv_return_message := 'Either receipt amount or customer details are changed. You can''t change these details. Reverse the receipt';
184: return;
185: END IF;
186: END IF;

Line 193: pv_return_code := jai_constants.unexpected_error;

189: NULL;
190: END IF;
191: EXCEPTION
192: WHEN OTHERS THEN
193: pv_return_code := jai_constants.unexpected_error;
194: pv_return_message := 'Encountered an error in jai_ar_cash_receipts_trg_pkg.ARU_T1 ' || substr(sqlerrm,1,1900);
195: END ARU_T1;
196:
197: PROCEDURE ARD_T1 (pr_old IN t_rec%type ,

Line 228: pv_return_code := jai_constants.expected_error;

224: DELETE jai_ar_cash_receipts_all
225: WHERE cash_receipt_id = pr_old.cash_receipt_id;
226: ELSE
227: --raise_application_error(-20011, 'You can''t delete this receipt. Reverse the receipt');
228: pv_return_code := jai_constants.expected_error;
229: pv_return_message := 'You can''t delete this receipt. Reverse the receipt';
230: return;
231: END IF;
232: EXCEPTION

Line 234: pv_return_code := jai_constants.unexpected_error;

230: return;
231: END IF;
232: EXCEPTION
233: WHEN OTHERS THEN
234: pv_return_code := jai_constants.unexpected_error;
235: pv_return_message := 'Encountered an error in jai_ar_cash_receipts_trg_pkg.ARD_T1 ' || substr(sqlerrm,1,1900);
236: END ARD_T1;
237:
238: END;