DBA Data[Home] [Help]

APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 42: pv_return_code := jai_constants.successful ;

38:
39: /* Emd for bug4406963 */
40:
41: BEGIN
42: pv_return_code := jai_constants.successful ;
43:
44: /*------------------------------------------------------------------------------------------
45: FILENAME: jai_ap_ida_t.plb
46:

Line 438: pv_return_code := jai_constants.successful ;

434: END process_prepayment;
435:
436:
437: BEGIN
438: pv_return_code := jai_constants.successful ;
439: /*------------------------------------------------------------------------------------------
440: FILENAME: ja_in_ap_aida_before_trg.sql
441:
442: CHANGE HISTORY:

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

519: S.No Bug Date Author and Details
520: 1 6493858 4-DEC-2007 Added by Nitin Prashar, for cancelation of Base Invoice*/
521:
522:
523: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
524: ln_org_id := pr_new.org_id;
525: ln_set_of_books_id := pr_new.set_of_books_id;
526: elsif pv_action = jai_constants.deleting then
527: ln_org_id := pr_old.org_id;

Line 526: elsif pv_action = jai_constants.deleting then

522:
523: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
524: ln_org_id := pr_new.org_id;
525: ln_set_of_books_id := pr_new.set_of_books_id;
526: elsif pv_action = jai_constants.deleting then
527: ln_org_id := pr_old.org_id;
528: ln_set_of_books_id := pr_old.set_of_books_id;
529: end if;
530:

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

564:
565:
566: /*Bug 5989740 bduvarag end*/
567:
568: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
569:
570: if nvl(pr_new.global_attribute_category, 'JA.IN.APXINWKB.DISTRIBUTIONS' ) = 'JA.IN.APXINWKB.DISTRIBUTIONS' and -- rchandan for bug#4333488
571: pr_new.line_type_lookup_code <> 'PREPAY' and
572: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */

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

605: );
606:
607: if nvl(lv_process_flag, 'N') = 'E' then
608: /* raise_application_error(-20004,
609: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_codepath); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
610: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_codepath ; return ;
611: end if;
612:
613:

Line 629: if pv_action = jai_constants.updating then

625:
626: /* TDS Tax Defaultation Functionality Bug # 4088186 */
627:
628: /* Intercepting Validate event */
629: if pv_action = jai_constants.updating then
630:
631: if nvl(pr_old.match_status_flag, 'Q') <> nvl(pr_new.match_status_flag, 'Q') and
632: pr_new.match_status_flag = 'A' and
633: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */

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

660: );
661:
662: if nvl(lv_process_flag, 'N') = 'E' then
663: /* raise_application_error(-20005,
664: '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 :=
665: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
666: end if;
667:
668: if lv_is_invoice_validated = 'Y' then

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

686: );
687:
688: if nvl(lv_process_flag, 'N') = 'E' then
689: /* raise_application_error(-20006,
690: '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 :=
691: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
692: end if;
693:
694: end if; --moved this from below for Bug#7433241

Line 739: if pv_action = jai_constants.inserting then

735: /* Intercepting Validate event */
736:
737:
738: /* Prepayment functionality */
739: if pv_action = jai_constants.inserting then
740:
741: if pr_new.line_type_lookup_code = 'PREPAY' and
742: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */
743: c_rec_ap_invoices_all.cancelled_date is null

Line 838: pv_return_code := jai_constants.expected_error ;

834:
835: if nvl(lv_process_flag, 'N') = 'E' then
836: -- raise_application_error(-20007,
837: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
838: pv_return_code := jai_constants.expected_error ;
839: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
840: return ;
841: end if;
842:

Line 865: pv_return_code := jai_constants.expected_error ;

861:
862: if nvl(lv_process_flag, 'N') = 'E' then
863: --raise_application_error(-20008,
864: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
865: pv_return_code := jai_constants.expected_error ;
866: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
867: return ;
868: end if;
869:

Line 896: if pv_action = jai_constants.deleting then

892: /*end changes for bug 6493858 -Code Ended */
893:
894: end if; /* inserting */
895:
896: if pv_action = jai_constants.deleting then
897:
898: jai_ap_tds_tax_defaultation.process_delete
899: (
900: p_invoice_id => pr_old.invoice_id,

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

905: );
906:
907: if nvl(lv_process_flag, 'N') = 'E' then
908: /* raise_application_error(-20009,
909: '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 :=
910: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
911: end if;
912:
913: end if; /* Deleting */

Line 919: Pv_return_code := jai_constants.unexpected_error;

915:
916: exception
917: when others then
918: --raise_application_error(-20010, 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || sqlerrm);
919: Pv_return_code := jai_constants.unexpected_error;
920: Pv_return_message := 'Encountered an error in JAI_AP_IDA_TRIGGER_PKG.BRIUD_T1 ' ||
921: 'Error on ap_invoice_distributions_all : ' || substr(sqlerrm,1,1900);
922:
923: END BRIUD_T1 ;