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_IDA_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 62: AND jrr.registration_type = jai_constants.regn_type_tax_types

58: AND jcdt.modvat_flag = 'Y' --Xiao for POT bug#12598010.
59: AND jcdt.tax_id = jcta.tax_id
60: AND jcta.tax_type = jrr.attribute_code
61: AND jrr.regime_id = jrd.regime_id
62: AND jrr.registration_type = jai_constants.regn_type_tax_types
63: AND jrd.regime_code = jai_constants.service_regime;
64:
65: CURSOR get_matched_tax_cur IS
66: SELECT jcta.tax_type

Line 63: AND jrd.regime_code = jai_constants.service_regime;

59: AND jcdt.tax_id = jcta.tax_id
60: AND jcta.tax_type = jrr.attribute_code
61: AND jrr.regime_id = jrd.regime_id
62: AND jrr.registration_type = jai_constants.regn_type_tax_types
63: AND jrd.regime_code = jai_constants.service_regime;
64:
65: CURSOR get_matched_tax_cur IS
66: SELECT jcta.tax_type
67: FROM jai_ap_match_inv_taxes jamt

Line 78: AND jrr.registration_type = jai_constants.regn_type_tax_types

74: and jamt.invoice_distribution_id=nvl(pr_new.parent_reversal_id,pr_new.invoice_distribution_id) /* Added for bug 16393213 */
75: AND jamt.recoverable_flag = 'Y'
76: AND jcta.tax_type = jrr.attribute_code
77: AND jrr.regime_id = jrd.regime_id
78: AND jrr.registration_type = jai_constants.regn_type_tax_types
79: AND jrd.regime_code = jai_constants.service_regime;
80:
81: /* Modified the cursor get_match_item_cur for bug 14507573 */
82: CURSOR get_match_item_cur IS

Line 79: AND jrd.regime_code = jai_constants.service_regime;

75: AND jamt.recoverable_flag = 'Y'
76: AND jcta.tax_type = jrr.attribute_code
77: AND jrr.regime_id = jrd.regime_id
78: AND jrr.registration_type = jai_constants.regn_type_tax_types
79: AND jrd.regime_code = jai_constants.service_regime;
80:
81: /* Modified the cursor get_match_item_cur for bug 14507573 */
82: CURSOR get_match_item_cur IS
83:

Line 113: WHERE regime_code = jai_constants.service_regime;

109:
110: CURSOR get_regime_id_cur IS
111: SELECT regime_id
112: FROM jai_rgm_definitions
113: WHERE regime_code = jai_constants.service_regime;
114:
115: CURSOR get_org_cur IS
116: SELECT organization_id,location_id
117: FROM jai_ap_invoice_lines

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

197: lv_same_period_flag VARCHAR2(1);
198:
199: lv_process_message VARCHAR2(200);
200: ln_regime_id NUMBER;
201: lv_regime_code VARCHAR2(30) := jai_constants.service_regime;
202: lv_tax_type VARCHAR2(30);
203: ln_organization_id NUMBER;
204: ln_location_id NUMBER;
205: ln_charge_account_id NUMBER;

Line 274: pv_return_code := jai_constants.successful ;

270: END check_same_period_func;
271: -- added by zhiwei.xin for bug 13540555 on 6-FEB-2012 end.
272:
273: BEGIN
274: pv_return_code := jai_constants.successful ;
275:
276: /*------------------------------------------------------------------------------------------
277: FILENAME: jai_ap_ida_t.plb
278:

Line 655: ln_entered_amt := round(ln_dist_line_amount, jai_constants.service_rgm_rnd_factor);

651:
652: /*Bug 12805386 - Moved the code to derive Organization ID and Location ID outside the loop*/
653: IF pr_new.accounting_date >= ld_accrual_date THEN
654:
655: ln_entered_amt := round(ln_dist_line_amount, jai_constants.service_rgm_rnd_factor);
656: ln_accounted_amt := ln_entered_amt * nvl(ln_curr_conv_rate, 1);
657:
658: IF lv_tax_type IS NOT NULL THEN --Service Tax.
659:

Line 694: lv_account_name := jai_constants.liability_interim;

690:
691: IF lv_invoice_type IN ('CREDIT', 'DEBIT') THEN
692: --DR: Service Tax interim liability Account
693: IF lv_event = 'ACCOUNTING' THEN
694: lv_account_name := jai_constants.liability_interim;
695: ELSE --'CANCELLATION'
696: lv_account_name := jai_constants.liability;
697: END IF;
698: ln_entered_amt := abs(ln_entered_amt);

Line 696: lv_account_name := jai_constants.liability;

692: --DR: Service Tax interim liability Account
693: IF lv_event = 'ACCOUNTING' THEN
694: lv_account_name := jai_constants.liability_interim;
695: ELSE --'CANCELLATION'
696: lv_account_name := jai_constants.liability;
697: END IF;
698: ln_entered_amt := abs(ln_entered_amt);
699: ln_accounted_amt := abs(ln_accounted_amt);
700: ELSE

Line 712: lv_account_name := jai_constants.recovery;

708: --> cancelled line with +ve figure accounting:
709: Dr Recovery/Liability based on period check
710: */
711: IF lv_event = 'ACCOUNTING' and sign(ln_dist_line_amount)=1 THEN /* Avanija 16314805 */
712: lv_account_name := jai_constants.recovery;
713: ELSIF ((lv_event= 'ACCOUNTING' and sign(ln_dist_line_amount)=-1 ) or (lv_event= 'CANCELLATION' and sign(ln_dist_line_amount)=-1))THEN--'CANCELLATION'
714: lv_account_name := jai_constants.recovery_interim;
715: ELSIF (lv_event='CANCELLATION' and sign(ln_dist_line_amount)=1 )
716: then

Line 714: lv_account_name := jai_constants.recovery_interim;

710: */
711: IF lv_event = 'ACCOUNTING' and sign(ln_dist_line_amount)=1 THEN /* Avanija 16314805 */
712: lv_account_name := jai_constants.recovery;
713: ELSIF ((lv_event= 'ACCOUNTING' and sign(ln_dist_line_amount)=-1 ) or (lv_event= 'CANCELLATION' and sign(ln_dist_line_amount)=-1))THEN--'CANCELLATION'
714: lv_account_name := jai_constants.recovery_interim;
715: ELSIF (lv_event='CANCELLATION' and sign(ln_dist_line_amount)=1 )
716: then
717: lv_same_period_flag := check_same_period_func; --added for bug#13934819
718: IF nvl(lv_same_period_flag, 'N') = 'N' THEN

Line 719: lv_account_name := jai_constants.liability;

715: ELSIF (lv_event='CANCELLATION' and sign(ln_dist_line_amount)=1 )
716: then
717: lv_same_period_flag := check_same_period_func; --added for bug#13934819
718: IF nvl(lv_same_period_flag, 'N') = 'N' THEN
719: lv_account_name := jai_constants.liability;
720: ELSE
721: lv_account_name := jai_constants.recovery;
722: END IF;
723: else

Line 721: lv_account_name := jai_constants.recovery;

717: lv_same_period_flag := check_same_period_func; --added for bug#13934819
718: IF nvl(lv_same_period_flag, 'N') = 'N' THEN
719: lv_account_name := jai_constants.liability;
720: ELSE
721: lv_account_name := jai_constants.recovery;
722: END IF;
723: else
724: lv_account_name := jai_constants.recovery_interim;
725: END IF;

Line 724: lv_account_name := jai_constants.recovery_interim;

720: ELSE
721: lv_account_name := jai_constants.recovery;
722: END IF;
723: else
724: lv_account_name := jai_constants.recovery_interim;
725: END IF;
726:
727: /*Added by Qinglei on 16-Feb-2012 for bug#13725705 begin*/
728: ln_entered_amt := abs(ln_entered_amt);

Line 734: , p_organization_type => jai_constants.service_tax_orgn_type

730: /*Added by Qinglei on 16-Feb-2012 for bug#13725705 end*/
731: END IF;
732: ln_charge_account_id := jai_cmn_rgm_recording_pkg.get_account(
733: p_regime_id => ln_regime_id
734: , p_organization_type => jai_constants.service_tax_orgn_type
735: , p_organization_id => ln_organization_id
736: , p_location_id => ln_location_id
737: , p_tax_type => lv_tax_type
738: , p_account_name => lv_account_name);

Line 750: p_organization_type => jai_constants.service_tax_orgn_type,

746:
747: jai_cmn_rgm_recording_pkg.post_accounting(
748: p_regime_code => lv_regime_code,
749: p_tax_type => lv_tax_type,
750: p_organization_type => jai_constants.service_tax_orgn_type,
751: p_organization_id => ln_organization_id,
752: p_source => jai_constants.source_ap,
753: p_source_trx_type => lv_source_trx_type,
754: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',

Line 752: p_source => jai_constants.source_ap,

748: p_regime_code => lv_regime_code,
749: p_tax_type => lv_tax_type,
750: p_organization_type => jai_constants.service_tax_orgn_type,
751: p_organization_id => ln_organization_id,
752: p_source => jai_constants.source_ap,
753: p_source_trx_type => lv_source_trx_type,
754: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',
755: p_source_document_id => ln_invoice_dist_id,
756: p_code_combination_id => ln_charge_account_id,

Line 777: lv_account_name := jai_constants.liability;

773:
774: IF lv_invoice_type IN ('CREDIT', 'DEBIT') THEN
775: --CR: Service Tax liability Account
776: IF lv_event = 'ACCOUNTING' THEN
777: lv_account_name := jai_constants.liability;
778: ELSE --'CANCELLATION'
779: lv_account_name := jai_constants.liability_interim;
780: END IF;
781: ELSE

Line 779: lv_account_name := jai_constants.liability_interim;

775: --CR: Service Tax liability Account
776: IF lv_event = 'ACCOUNTING' THEN
777: lv_account_name := jai_constants.liability;
778: ELSE --'CANCELLATION'
779: lv_account_name := jai_constants.liability_interim;
780: END IF;
781: ELSE
782: --CR: Service Tax Recovery Interim Account
783:

Line 795: lv_account_name := jai_constants.recovery_interim;

791: --> cancelled line with +ve figure accounting(added) :
792: Cr Interim recovery
793: */
794: IF lv_event = 'ACCOUNTING' and sign(ln_dist_line_amount)=1 or (lv_event = 'CANCELLATION' and sign(ln_dist_line_amount)=1)THEN /* Avanija 16314805 */
795: lv_account_name := jai_constants.recovery_interim;
796: ELSIF (lv_event= 'ACCOUNTING' and sign(ln_dist_line_amount)=-1 ) then
797: lv_account_name := jai_constants.recovery;
798: elsif (lv_event = 'CANCELLATION' and sign(ln_dist_line_amount)=-1) then --'CANCELLATION'
799: IF lv_invoice_type = 'STANDARD' THEN

Line 797: lv_account_name := jai_constants.recovery;

793: */
794: IF lv_event = 'ACCOUNTING' and sign(ln_dist_line_amount)=1 or (lv_event = 'CANCELLATION' and sign(ln_dist_line_amount)=1)THEN /* Avanija 16314805 */
795: lv_account_name := jai_constants.recovery_interim;
796: ELSIF (lv_event= 'ACCOUNTING' and sign(ln_dist_line_amount)=-1 ) then
797: lv_account_name := jai_constants.recovery;
798: elsif (lv_event = 'CANCELLATION' and sign(ln_dist_line_amount)=-1) then --'CANCELLATION'
799: IF lv_invoice_type = 'STANDARD' THEN
800: /*commented for bug#13934819
801: OPEN check_same_period_cur;

Line 807: lv_account_name := jai_constants.liability;

803: CLOSE check_same_period_cur;
804: */
805: lv_same_period_flag := check_same_period_func; --added for bug#13934819
806: IF nvl(lv_same_period_flag, 'N') = 'N' THEN
807: lv_account_name := jai_constants.liability;
808: ELSE
809: lv_account_name := jai_constants.recovery;
810: END IF;
811: ELSE

Line 809: lv_account_name := jai_constants.recovery;

805: lv_same_period_flag := check_same_period_func; --added for bug#13934819
806: IF nvl(lv_same_period_flag, 'N') = 'N' THEN
807: lv_account_name := jai_constants.liability;
808: ELSE
809: lv_account_name := jai_constants.recovery;
810: END IF;
811: ELSE
812: lv_account_name := jai_constants.recovery;
813: END IF;

Line 812: lv_account_name := jai_constants.recovery;

808: ELSE
809: lv_account_name := jai_constants.recovery;
810: END IF;
811: ELSE
812: lv_account_name := jai_constants.recovery;
813: END IF;
814: END IF;
815: END IF;
816:

Line 819: , p_organization_type => jai_constants.service_tax_orgn_type

815: END IF;
816:
817: ln_charge_account_id := jai_cmn_rgm_recording_pkg.get_account(
818: p_regime_id => ln_regime_id
819: , p_organization_type => jai_constants.service_tax_orgn_type
820: , p_organization_id => ln_organization_id
821: , p_location_id => ln_location_id
822: , p_tax_type => lv_tax_type
823: , p_account_name => lv_account_name);

Line 834: p_organization_type => jai_constants.service_tax_orgn_type,

830:
831: jai_cmn_rgm_recording_pkg.post_accounting(
832: p_regime_code => lv_regime_code,
833: p_tax_type => lv_tax_type,
834: p_organization_type => jai_constants.service_tax_orgn_type,
835: p_organization_id => ln_organization_id,
836: p_source => jai_constants.source_ap,
837: p_source_trx_type => lv_source_trx_type,
838: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',

Line 836: p_source => jai_constants.source_ap,

832: p_regime_code => lv_regime_code,
833: p_tax_type => lv_tax_type,
834: p_organization_type => jai_constants.service_tax_orgn_type,
835: p_organization_id => ln_organization_id,
836: p_source => jai_constants.source_ap,
837: p_source_trx_type => lv_source_trx_type,
838: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',
839: p_source_document_id => ln_invoice_dist_id,
840: p_code_combination_id => ln_charge_account_id,

Line 1965: pv_return_code := jai_constants.successful ;

1961:
1962:
1963:
1964: BEGIN
1965: pv_return_code := jai_constants.successful ;
1966: /*------------------------------------------------------------------------------------------
1967: FILENAME: ja_in_ap_aida_before_trg.sql
1968:
1969: CHANGE HISTORY:

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

2077: S.No Bug Date Author and Details
2078: 1 6493858 4-DEC-2007 Added by Nitin Prashar, for cancelation of Base Invoice*/
2079:
2080:
2081: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
2082: ln_org_id := pr_new.org_id;
2083: ln_set_of_books_id := pr_new.set_of_books_id;
2084: elsif pv_action = jai_constants.deleting then
2085: ln_org_id := pr_old.org_id;

Line 2084: elsif pv_action = jai_constants.deleting then

2080:
2081: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
2082: ln_org_id := pr_new.org_id;
2083: ln_set_of_books_id := pr_new.set_of_books_id;
2084: elsif pv_action = jai_constants.deleting then
2085: ln_org_id := pr_old.org_id;
2086: ln_set_of_books_id := pr_old.set_of_books_id;
2087: end if;
2088:

Line 2102: if pv_action = jai_constants.inserting

2098: */
2099:
2100: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud',' pv_action '||pv_action||' nvl(pr_old.match_status_flag,Q) '||nvl(pr_old.match_status_flag,'Q')||' nvl(pr_new.match_status_flag,Q) '||nvl(pr_new.match_status_flag,'Q'));
2101: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','pr_new.line_type_lookup_code '||pr_new.line_type_lookup_code);
2102: if pv_action = jai_constants.inserting
2103: AND ( nvl(pr_old.match_status_flag,'Q')<> nvl(pr_new.match_status_flag,'Q') and nvl(pr_new.match_status_flag,'Q') IN ('N'))
2104: AND ( pr_new.line_type_lookup_code ='IPV' or pr_new.line_type_lookup_code ='ERV' )
2105: then
2106: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','before call to process_ipv');

Line 2144: if pv_action = jai_constants.updating

2140:
2141: /*Bug 5989740 bduvarag end*/
2142:
2143: --Added by Xiao Lv for bug#7347508 on 11-Jan-2010, begin
2144: if pv_action = jai_constants.updating
2145: then
2146: IF nvl(pr_new.global_attribute_category, 'JA.IN.APXINWKB.DISTRIBUTIONS' ) = 'JA.IN.APXINWKB.DISTRIBUTIONS'
2147: AND ( nvl(pr_old.global_attribute1, 0) <> nvl(pr_new.global_attribute1, 0)
2148: OR nvl(pr_old.global_attribute2, 0) <> nvl(pr_new.global_attribute2, 0)

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

2156: end if;
2157: --Added by Xiao Lv for bug#7347508 on 11-Jan-2010, end
2158:
2159:
2160: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
2161:
2162: if nvl(pr_new.global_attribute_category, 'JA.IN.APXINWKB.DISTRIBUTIONS' ) = 'JA.IN.APXINWKB.DISTRIBUTIONS' and -- rchandan for bug#4333488
2163: pr_new.line_type_lookup_code <> 'PREPAY' and
2164: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */

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

2197: );
2198:
2199: if nvl(lv_process_flag, 'N') = 'E' then
2200: /* raise_application_error(-20004,
2201: '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 :=
2202: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_codepath ; return ;
2203: end if;
2204:
2205: /*Bug 8641199 - Start*/

Line 2242: if pv_action = jai_constants.updating then

2238: is set to A or T process_tds_at_inv_validate shall be called. If process_tds_at_inv_validate is called after insertion
2239: of data in JAI_AP_TDS_PREPAYMENTS it results in incorrect TDS deduction. Hence moved the code to insert JAI_AP_TDS_PREPAYMENTS
2240: after validation of Invoice.*/
2241: --To handle the condition, if there are PP applications/Unapplications, before the SI is validated
2242: if pv_action = jai_constants.updating then
2243: IF pr_new.line_type_lookup_code = 'PREPAY' and
2244: nvl(pr_old.match_status_flag, 'Q') <> nvl(pr_new.match_status_flag, 'Q') and pr_new.match_status_flag = 'A' /* Added for Bug #16028459 */
2245: THEN
2246: lv_prepay_flag := NULL;

Line 2276: if pv_action = jai_constants.updating then

2272: END IF;
2273: end if;
2274: /*Bug 12630283 - End*/
2275: /* Intercepting Validate event */
2276: if pv_action = jai_constants.updating then
2277:
2278: if nvl(pr_old.match_status_flag, 'Q') <> nvl(pr_new.match_status_flag, 'Q') and
2279: pr_new.match_status_flag = 'A' and
2280: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */

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

2307: );
2308:
2309: if nvl(lv_process_flag, 'N') = 'E' then
2310: /* raise_application_error(-20005,
2311: '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 :=
2312: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
2313: end if;
2314:
2315: if lv_is_invoice_validated = 'Y' then

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

2333: );
2334:
2335: if nvl(lv_process_flag, 'N') = 'E' then
2336: /* raise_application_error(-20006,
2337: '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 :=
2338: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
2339: end if;
2340:
2341: end if; --moved this from below for Bug#7433241

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

2355: end if; /* updating */
2356: /* Intercepting Validate event */
2357:
2358:
2359: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
2360:
2361: /*START, by amandali for Bug#10430662*/
2362: if (pr_new.global_attribute1 is not null or pr_new.global_attribute2 is not null or pr_new.global_attribute3 is not null) and (pr_new.global_attribute_category is null) then
2363: pr_new.global_attribute_category := 'JA.IN.APXINWKB.DISTRIBUTIONS';

Line 2404: if pv_action = jai_constants.inserting then

2400: end if;
2401: end if;
2402: /*END, by amandali for Bug#10430662*/
2403: /* Prepayment functionality */
2404: if pv_action = jai_constants.inserting then
2405: if pr_new.line_type_lookup_code = 'PREPAY' and
2406: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */
2407: c_rec_ap_invoices_all.cancelled_date is null
2408: then

Line 2502: pv_return_code := jai_constants.expected_error ;

2498:
2499: if nvl(lv_process_flag, 'N') = 'E' then
2500: -- raise_application_error(-20007,
2501: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
2502: pv_return_code := jai_constants.expected_error ;
2503: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
2504: return ;
2505: end if;
2506:

Line 2529: pv_return_code := jai_constants.expected_error ;

2525:
2526: if nvl(lv_process_flag, 'N') = 'E' then
2527: --raise_application_error(-20008,
2528: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
2529: pv_return_code := jai_constants.expected_error ;
2530: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
2531: return ;
2532: end if;
2533:

Line 2590: if pv_action = jai_constants.deleting then

2586: /*End for bug 8330522*/
2587:
2588: end if; /* inserting */
2589:
2590: if pv_action = jai_constants.deleting then
2591:
2592: jai_ap_tds_tax_defaultation.process_delete
2593: (
2594: p_invoice_id => pr_old.invoice_id,

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

2599: );
2600:
2601: if nvl(lv_process_flag, 'N') = 'E' then
2602: /* raise_application_error(-20009,
2603: '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 :=
2604: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
2605: end if;
2606:
2607: end if; /* Deleting */

Line 2613: Pv_return_code := jai_constants.unexpected_error;

2609:
2610: exception
2611: when others then
2612: --raise_application_error(-20010, 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || sqlerrm);
2613: Pv_return_code := jai_constants.unexpected_error;
2614: Pv_return_message := 'Encountered an error in JAI_AP_IDA_TRIGGER_PKG.BRIUD_T1 ' ||
2615: 'Error on ap_invoice_distributions_all : ' || substr(sqlerrm,1,1900);
2616:
2617: END BRIUD_T1 ;