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 103: Pv_return_code := jai_constants.unexpected_error;

99: exception
100: when others then
101: --raise_application_error(-20000, 'Error - trigger ja_in_ap_aia_after_trg on ap_invoices_all : ' || sqlerrm);
102: /* Added an exception block by Ramananda for bug#4570303 */
103: Pv_return_code := jai_constants.unexpected_error;
104: Pv_return_message := 'Encountered an error in JAI_AP_IA_TRIGGER_PKG.ARI_T7 ' ||
105: 'Error on ap_invoices_all : ' || substr(sqlerrm,1,1800);
106:
107: END ARUID_T1 ;

Line 162: pv_return_code := jai_constants.successful ;

158:
159: /*END, Bgowrava for Bug#5638773 */
160:
161: BEGIN
162: pv_return_code := jai_constants.successful ;
163: /*------------------------------------------------------------------------------------------
164: FILENAME: jai_ap_ia_t.sql
165:
166: CHANGE HISTORY:

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

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

Line 223: elsif pv_action = jai_constants.deleting then

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

Line 243: if pv_action = jai_constants.updating then

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

Line 257: pv_return_code := jai_constants.expected_error ;

253:
254: IF r_tds_invoice_id.invoice_id IS NOT NULL THEN
255: lv_invoice_payment_status := get_invoice_payment_status(r_tds_invoice_id.invoice_id);
256: IF NVL(lv_invoice_payment_status,'N') <> 'N' THEN
257: pv_return_code := jai_constants.expected_error ;
258: pv_return_message := 'Invoice to TDS Authority - '||r_tds_invoice_id.invoice_num||' is already paid. Current invoice can''t be cancelled';
259: END IF;
260: END IF;
261:

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

282: end if; /* pr_new.source <> 'TDS' then */
283:
284: end if; /* if pr_old.cancelled_date is null and pr_new.cancelled_date is not null then */
285:
286: end if; /* if pv_action = jai_constants.updating than */
287:
288: /* Update invoice Ids in TDS tables for TDS invoices */
289: if pv_action = jai_constants.inserting and pr_new.source = 'INDIA TDS' then /* 'TDS' then --Ramanand for bug#4388958 */
290:

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

285:
286: end if; /* if pv_action = jai_constants.updating than */
287:
288: /* Update invoice Ids in TDS tables for TDS invoices */
289: if pv_action = jai_constants.inserting and pr_new.source = 'INDIA TDS' then /* 'TDS' then --Ramanand for bug#4388958 */
290:
291: jai_ap_tds_generation_pkg.populate_tds_invoice_id
292: (
293: p_invoice_id => pr_new.invoice_id,

Line 303: '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 :=

299: );
300:
301: if nvl(lv_process_flag, 'N') = 'E' then
302: /* raise_application_error(-20001,
303: '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 :=
304: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message ; return ;
305: end if;
306:
307: end if; /* Update invoice Ids in TDS tables for TDS invoices */

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

306:
307: end if; /* Update invoice Ids in TDS tables for TDS invoices */
308:
309: /* Update invoice Ids in Third Party tables for Third Party invoices */
310: if pv_action = jai_constants.inserting and pr_new.source = 'INDIA TAX INVOICE' then /* 'RECEIPT' then --Ramanand for bug#4388958 */
311:
312: jai_rcv_third_party_pkg.populate_tp_invoice_id
313: (
314: p_invoice_id => pr_new.invoice_id,

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

317: p_vendor_site_id => pr_new.vendor_site_id,
318: p_process_flag => lv_process_flag,
319: p_process_message => lv_process_message
320: );
321: if nvl(lv_process_flag, 'N') = jai_constants.unexpected_error then
322: /* raise_application_error(-20002,
323: '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 :=
324: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message ; return ;
325: end if;

Line 323: '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 :=

319: p_process_message => lv_process_message
320: );
321: if nvl(lv_process_flag, 'N') = jai_constants.unexpected_error then
322: /* raise_application_error(-20002,
323: '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 :=
324: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message ; return ;
325: end if;
326: end if;
327:

Line 333: if pv_action = jai_constants.deleting then

329: || Update invoice Ids in Third Party tables for Third Party invoices
330: */
331:
332: /* Deleting */
333: if pv_action = jai_constants.deleting then
334:
335: jai_ap_tds_tax_defaultation.process_delete
336: (
337: p_invoice_id => pr_old.invoice_id,

Line 344: '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 :=

340: );
341:
342: if nvl(lv_process_flag, 'N') = 'E' then
343: /* raise_application_error(-20002,
344: '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 :=
345: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
346: end if;
347:
348: end if; /* Deleting */

Line 355: Pv_return_code := jai_constants.unexpected_error;

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