eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_IA_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 16: pv_return_code := jai_constants.successful ;

12: REM +======================================================================+
13: */
14: PROCEDURE ARUID_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
15: BEGIN
16: pv_return_code := jai_constants.successful ;
17: /*------------------------------------------------------------------------------------------
18: FILENAME: ja_in_ap_aia_after_trg.sql
19:
20: CHANGE HISTORY:

Line 78: if pv_action = jai_constants.updating then

74: /* India Localization funtionality is not required */
75: -- return;
76: --end if;
77:
78: if pv_action = jai_constants.updating then
79:
80: -- Bug 7114863. Added by Lakshmi Gopalsami
81: -- Removed the reference to jai_ap_tolerance_pkg.check_tolerance_hold
82:

Line 113: Pv_return_code := jai_constants.unexpected_error;

109: exception
110: when others then
111: --raise_application_error(-20000, 'Error - trigger ja_in_ap_aia_after_trg on ap_invoices_all : ' || sqlerrm);
112: /* Added an exception block by Ramananda for bug#4570303 */
113: Pv_return_code := jai_constants.unexpected_error;
114: Pv_return_message := 'Encountered an error in JAI_AP_IA_TRIGGER_PKG.ARI_T7 ' ||
115: 'Error on ap_invoices_all : ' || substr(sqlerrm,1,1800);
116:
117: END ARUID_T1 ;

Line 139: lv_regime_code VARCHAR2(30) := jai_constants.service_regime;

135: ln_set_of_books_id ap_invoices_all.set_of_books_id%type;
136:
137:
138: ln_regime_id NUMBER;
139: lv_regime_code VARCHAR2(30) := jai_constants.service_regime;
140:
141: ln_organization_id NUMBER;
142: ln_location_id NUMBER;
143: ln_charge_account_id NUMBER;

Line 164: pv_return_code := jai_constants.successful ;

160:
161: /*changes for bug 5662741 removed for bug 6493858/6411412*/
162:
163: BEGIN
164: pv_return_code := jai_constants.successful ;
165: /*------------------------------------------------------------------------------------------
166: FILENAME: jai_ap_ia_t.sql
167:
168: CHANGE HISTORY:

Line 219: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then

215:
216:
217:
218: ------------------------------------------------------------------------------------------ */
219: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
220: ln_org_id := pr_new.org_id;
221: ln_set_of_books_id := pr_new.set_of_books_id;
222: elsif pv_action = jai_constants.deleting then
223: ln_org_id := pr_old.org_id;

Line 222: elsif pv_action = jai_constants.deleting then

218: ------------------------------------------------------------------------------------------ */
219: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
220: ln_org_id := pr_new.org_id;
221: ln_set_of_books_id := pr_new.set_of_books_id;
222: elsif pv_action = jai_constants.deleting then
223: ln_org_id := pr_old.org_id;
224: ln_set_of_books_id := pr_old.set_of_books_id;
225: end if;
226:

Line 242: if pv_action = jai_constants.updating then

238:
239: /*
240: || Cancellation Functionality
241: */
242: if pv_action = jai_constants.updating then
243:
244: if pr_old.cancelled_date is null and pr_new.cancelled_date is not null then
245:
246: if pr_new.source <> 'INDIA TDS' then /* 'TDS' then --Ramanand for bug#4388958 */

Line 292: end if; /* if pv_action = jai_constants.updating than */

288: /* Updated By Wenqiong Zhou for Bug #1168411 BOE enhancement End*/
289:
290: end if; /* if pr_old.cancelled_date is null and pr_new.cancelled_date is not null then */
291:
292: end if; /* if pv_action = jai_constants.updating than */
293:
294: /* Update invoice Ids in TDS tables for TDS invoices */
295: if pv_action = jai_constants.inserting and pr_new.source = 'INDIA TDS' then /* 'TDS' then --Ramanand for bug#4388958 */
296:

Line 295: if pv_action = jai_constants.inserting and pr_new.source = 'INDIA TDS' then /* 'TDS' then --Ramanand for bug#4388958 */

291:
292: end if; /* if pv_action = jai_constants.updating than */
293:
294: /* Update invoice Ids in TDS tables for TDS invoices */
295: if pv_action = jai_constants.inserting and pr_new.source = 'INDIA TDS' then /* 'TDS' then --Ramanand for bug#4388958 */
296:
297: jai_ap_tds_generation_pkg.populate_tds_invoice_id
298: (
299: p_invoice_id => pr_new.invoice_id,

Line 309: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=

305: );
306:
307: if nvl(lv_process_flag, 'N') = 'E' then
308: /* raise_application_error(-20001,
309: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
310: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message ; return ;
311: end if;
312:
313: end if; /* Update invoice Ids in TDS tables for TDS invoices */

Line 316: if pv_action = jai_constants.inserting and pr_new.source = 'INDIA TAX INVOICE' then /* 'RECEIPT' then --Ramanand for bug#4388958 */

312:
313: end if; /* Update invoice Ids in TDS tables for TDS invoices */
314:
315: /* Update invoice Ids in Third Party tables for Third Party invoices */
316: if pv_action = jai_constants.inserting and pr_new.source = 'INDIA TAX INVOICE' then /* 'RECEIPT' then --Ramanand for bug#4388958 */
317:
318: jai_rcv_third_party_pkg.populate_tp_invoice_id
319: (
320: p_invoice_id => pr_new.invoice_id,

Line 327: if nvl(lv_process_flag, 'N') = jai_constants.unexpected_error then

323: p_vendor_site_id => pr_new.vendor_site_id,
324: p_process_flag => lv_process_flag,
325: p_process_message => lv_process_message
326: );
327: if nvl(lv_process_flag, 'N') = jai_constants.unexpected_error then
328: /* raise_application_error(-20002,
329: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
330: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message ; return ;
331: end if;

Line 329: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=

325: p_process_message => lv_process_message
326: );
327: if nvl(lv_process_flag, 'N') = jai_constants.unexpected_error then
328: /* raise_application_error(-20002,
329: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
330: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message ; return ;
331: end if;
332: end if;
333:

Line 339: if pv_action = jai_constants.deleting then

335: || Update invoice Ids in Third Party tables for Third Party invoices
336: */
337:
338: /* Deleting */
339: if pv_action = jai_constants.deleting then
340:
341: jai_ap_tds_tax_defaultation.process_delete
342: (
343: p_invoice_id => pr_old.invoice_id,

Line 350: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=

346: );
347:
348: if nvl(lv_process_flag, 'N') = 'E' then
349: /* raise_application_error(-20002,
350: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
351: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
352: end if;
353:
354: end if; /* Deleting */

Line 361: Pv_return_code := jai_constants.unexpected_error;

357: exception
358: when others then
359: --raise_application_error(-20003, 'Error - trigger ja_in_ap_aia_before_trg on ap_invoices_all : ' || sqlerrm);
360: /* Added an exception block by Ramananda for bug#4570303 */
361: Pv_return_code := jai_constants.unexpected_error;
362: Pv_return_message := 'Encountered an error in JAI_AP_IA_TRIGGER_PKG.ARI_T7 ' ||
363: 'Error on ap_invoices_all : ' || substr(sqlerrm,1,1800);
364:
365: END BRIUD_T1 ;