APPS.JAI_AP_HA_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 23: pv_return_code := jai_constants.successful ;

19: v_source ap_invoices_all.source%type;
20:
21:
22: BEGIN
23: pv_return_code := jai_constants.successful ;
24:
25: /*------------------------------------------------------------------------------------------
26: FILENAME: ja_in_ai_cm_po_hold_trg.sql
27:

Line 89: Pv_return_code := jai_constants.unexpected_error;

85: EXCEPTION
86: WHEN OTHERS THEN
87: -- raise_application_error(-20000, 'Error - trigger ja_in_ai_cm_po_hold_trg : ' || sqlerrm);
88: /* Added an exception block by Ramananda for bug#4570303 */
89: Pv_return_code := jai_constants.unexpected_error;
90: Pv_return_message := 'Encountered an error in JAI_AP_HA_TRIGGER_PKG.BRI_T1 ' || substr(sqlerrm,1,1900);
91:
92: END BRI_T1 ;
93:

Line 134: pv_return_code := jai_constants.successful ;

130: ln_req_id number;
131: ln_org_id ap_invoices_all.org_id%type;
132: lv_request_id number ; -- added, Harshita for Bug#5131075(5346558)
133: BEGIN
134: pv_return_code := jai_constants.successful ;
135: /*------------------------------------------------------------------------------------------
136: FILENAME: ja_in_ap_aha_after_trg.sql
137:
138: CHANGE HISTORY:

Line 172: /* if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then

168:
169:
170: ------------------------------------------------------------------------------------------ */
171:
172: /* if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
173: ln_org_id := pr_new.org_id;
174: elsif pv_action = jai_constants.deleting then
175: ln_org_id := pr_old.org_id;
176: end if;

Line 174: elsif pv_action = jai_constants.deleting then

170: ------------------------------------------------------------------------------------------ */
171:
172: /* if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
173: ln_org_id := pr_new.org_id;
174: elsif pv_action = jai_constants.deleting then
175: ln_org_id := pr_old.org_id;
176: end if;
177: */
178: --if

Line 190: IF pv_action = jai_constants.inserting OR pv_action = jai_constants.deleting THEN

186: -- return;
187: -- end if;
188:
189: --Added by Sanjikum for Bug#5131075(4644291)
190: IF pv_action = jai_constants.inserting OR pv_action = jai_constants.deleting THEN
191: RETURN;
192: END IF;
193:
194:

Line 202: if pv_action = jai_constants.updating and

198: open c_ap_invoices_all(pr_new.invoice_id);
199: fetch c_ap_invoices_all into c_rec_ap_invoices_all;
200: close c_ap_invoices_all;
201:
202: if pv_action = jai_constants.updating and
203: pr_new.release_reason is not null and
204: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /* 'TDS' and --Ramanand for bug#4388958 */
205: c_rec_ap_invoices_all.cancelled_date is null
206: then

Line 276: Pv_return_code := jai_constants.unexpected_error;

272: /* Added an exception block by Ramananda for bug#4570303 */
273: EXCEPTION
274: WHEN OTHERS THEN
275: --raise_application_error(-20000, 'Error - ja_in_ap_aha_after_trg on ap_holds_all : ' || sqlerrm);
276: Pv_return_code := jai_constants.unexpected_error;
277: Pv_return_message := 'Encountered an error in JAI_AP_HA_TRIGGER_PKG.ARI_T7 ' || substr(sqlerrm,1,1900);
278:
279: END BRIUD_T1 ;
280: