APPS.JAI_PA_PDIA_AFTER_T1 dependencies on JAI_CONSTANTS

Line 265: if pv_event = jai_constants.DEFAULT_TAXES then

261: debug (ln_reg_id, 'OPEN/FETCH curosr c_chk_req_exists');
262:
263: lv_ret_val := false;
264:
265: if pv_event = jai_constants.DEFAULT_TAXES then
266:
267: open c_chk_default_req_exists;
268: fetch c_chk_default_req_exists into ln_req_exists;
269: lv_ret_val := c_chk_default_req_exists%found ;

Line 272: elsif pv_event = jai_constants.RECALCULATE_TAXES

268: fetch c_chk_default_req_exists into ln_req_exists;
269: lv_ret_val := c_chk_default_req_exists%found ;
270: close c_chk_default_req_exists;
271:
272: elsif pv_event = jai_constants.RECALCULATE_TAXES
273: then
274:
275: open c_chk_recalc_req_exists;
276: fetch c_chk_recalc_req_exists into ln_req_exists;

Line 316: if pv_event = jai_constants.default_taxes then

312: if (request_exists_for_event (pv_event)) = false then
313: --
314: -- Request does not exists
315: --
316: if pv_event = jai_constants.default_taxes then
317:
318: ln_parent_request_id := ln_conc_request_id;
319:
320: elsif pv_event = jai_constants.recalculate_taxes then

Line 320: elsif pv_event = jai_constants.recalculate_taxes then

316: if pv_event = jai_constants.default_taxes then
317:
318: ln_parent_request_id := ln_conc_request_id;
319:
320: elsif pv_event = jai_constants.recalculate_taxes then
321:
322: ln_project_id := r_new.project_id;
323: ln_draft_invoice_num := r_new.draft_invoice_num;
324:

Line 374: if pv_event = jai_constants.DEFAULT_TAXES then

370: );
371: debug (ln_reg_id, 'ln_request_id='||ln_request_id);
372: if ln_request_id > 0 then
373:
374: if pv_event = jai_constants.DEFAULT_TAXES then
375: --
376: -- Event is default taxes hence the trigger is invoked by a project's draft invoice generation concurrent
377: -- By inserting a row in to global temporary table (which preserve row ever after COMMIT) to later check
378: -- if the request is already submitted in the current session (concurrent session)

Line 391: elsif pv_event = jai_constants.RECALCULATE_TAXES then

387: pv_event
388: , ln_request_id
389: , ln_parent_request_id
390: );
391: elsif pv_event = jai_constants.RECALCULATE_TAXES then
392: --
393: -- Recalulate event is triggered from the front-end UI and here using a global temporary table
394: -- (which *DO NOT* preseve rows on COMMIT) so after each commit a new request will be submited
395: --

Line 479: ( pv_event => jai_constants.default_taxes

475:
476: if inserting then
477:
478: submit_request
479: ( pv_event => jai_constants.default_taxes
480: );
481:
482: end if ;
483:

Line 502: ( pv_event => jai_constants.recalculate_taxes

498: ||',r_new.inv_currency_code='||r_new.inv_currency_code
499: ||',r_old.inv_currency_code='||r_old.inv_currency_code
500: );
501: submit_request
502: ( pv_event => jai_constants.recalculate_taxes
503: );
504:
505: end if;
506:

Line 534: if lv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

530: ||', lv_process_message:'||lv_process_message
531: );
532: end if;
533:
534: if lv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then
535: goto end_of_trigger;
536: end if;
537:
538: /* TESTING purpose

Line 558: if lv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

554: pv_process_flag => lv_process_flag,
555: pv_process_message => lv_process_message
556: ) ;
557:
558: if lv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then
559: goto end_of_trigger;
560: end if;
561:
562: end if;

Line 569: if lv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

565: -- End of Trigger logic
566: --
567: <>
568: jai_cmn_debug_contexts_pkg.deregister (ln_reg_id);
569: if lv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then
570: fnd_message.set_name( 'JA', 'JAI_GENERIC_MSG');
571: fnd_message.set_token('MSG_TEXT', lv_process_message);
572: app_exception.raise_exception;
573: end if;