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_DTC_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 217: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);

213: );
214:
215: if nvl(lv_process_flag, 'N') = 'E' then
216: raise_application_error(-20007,
217: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
218: end if;
219:
220: else
221: /* Bug 5640993 FP of 5553489. Added by JMEENA

Line 250: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);

246: );
247:
248: if nvl(lv_process_flag, 'N') = 'E' then
249: raise_application_error(-20008,
250: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
251: end if;
252: END IF ; --End of bug#5640993
253:
254: end if; --Transactions in new regime

Line 303: from ap_invoice_distributions_all

299:
300: cursor get_dist_no(cp_invoice_id number,cp_inv_lineno number)
301: is
302: select max(nvl(distribution_line_number,0))
303: from ap_invoice_distributions_all
304: where invoice_id = cp_invoice_id
305: and invoice_line_number=cp_inv_lineno;
306:
307: cursor get_tax_name(cp_tax_id in number)

Line 333: FROM ap_invoice_distributions_all

329:
330:
331: cursor c_get_accrual_acct(cp_invoice_id number,cp_inv_distid number) is
332: select dist_code_combination_id
333: FROM ap_invoice_distributions_all
334: where invoice_id =cp_invoice_id
335: and invoice_distribution_id=cp_inv_distid;
336:
337: ln_accrual_acct number;

Line 412: from ap_invoice_distributions_all

408: /*
409: Cursor get_mis_dists
410: is
411: select *
412: from ap_invoice_distributions_all
413: where invoice_id=cp_invoice_id
414: and line_type_lookup_code='MISCELLANEOUS'
415: and invoice_distribut
416: */

Line 495: INSERT INTO ap_invoice_distributions_all

491:
492: ln_distribution_lineno :=nvl(ln_distribution_lineno,0)+1;
493:
494: --insert the variance amount with line_type_lookup_code as MISCELLANEOUS
495: INSERT INTO ap_invoice_distributions_all
496: (
497: accounting_date,
498: accrual_posted_flag,
499: assets_addition_flag,

Line 619: INSERT INTO ap_invoice_distributions_all

615:
616: ln_distribution_lineno :=nvl(ln_distribution_lineno,0)+1;
617:
618: --insert the variance amount with line_type_lookup_code as MISCELLANEOUS
619: INSERT INTO ap_invoice_distributions_all
620: (
621: accounting_date,
622: accrual_posted_flag,
623: assets_addition_flag,

Line 850: INSERT INTO ap_invoice_distributions_all

846:
847: ln_distribution_lineno :=nvl(ln_distribution_lineno,0)+1;
848:
849: --insert the variance amount with line_type_lookup_code as MISCELLANEOUS
850: INSERT INTO ap_invoice_distributions_all
851: (
852: accounting_date,
853: accrual_posted_flag,
854: assets_addition_flag,

Line 974: INSERT INTO ap_invoice_distributions_all

970:
971: ln_distribution_lineno :=nvl(ln_distribution_lineno,0)+1;
972:
973: --insert the variance amount with line_type_lookup_code as MISCELLANEOUS
974: INSERT INTO ap_invoice_distributions_all
975: (
976: accounting_date,
977: accrual_posted_flag,
978: assets_addition_flag,

Line 1123: be populated in the attribute columns of ap_invoice_distributions_all table

1119:
1120: 2. 11/05/2005 rchandan for bug#4333488. Version 116.1
1121: The Invoice Distribution DFF is eliminated and a new global DFF is used to
1122: maintain the functionality. From now the TDS tax, WCT tax and ESSI will not
1123: be populated in the attribute columns of ap_invoice_distributions_all table
1124: instead these will be populated in the global attribute columns. So the code changes are
1125: made accordingly.
1126:
1127: 3. 24/05/2005 Ramananda for bug# 4388958 File Version: 116.1

Line 1145: ap_invoice_distributions_all

1141: prior to upgrade to TDS Threshold will be done only at the time of application and not during validation.
1142:
1143: 9. 18-Jul-2009 Bug 8641199
1144: Need to update match_status_flag in jai_ap_tds_inv_taxes with the match_status_flag of
1145: ap_invoice_distributions_all
1146:
1147: 8. 11-Jan-2010 Xiao Lv for bug#7347508, related 11i bug#6417285
1148: Added new conditions to check if either TDS, WCT or ESSI taxes are getting modified or inserted
1149: after the invoice has been validated. In such cases an error message is thrown stating that once an

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

1373: );*/
1374:
1375: if nvl(lv_process_flag, 'N') = 'E' then
1376: /* raise_application_error(-20004,
1377: '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 :=
1378: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_codepath ; return ;
1379: end if;
1380:
1381: /*Bug 8641199 - Start*/

Line 1378: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_codepath ; return ;

1374:
1375: if nvl(lv_process_flag, 'N') = 'E' then
1376: /* raise_application_error(-20004,
1377: '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 :=
1378: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_codepath ; return ;
1379: end if;
1380:
1381: /*Bug 8641199 - Start*/
1382: jai_ap_tds_generation_pkg.status_update_chk_validate

Line 1486: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;

1482: );
1483: if nvl(lv_process_flag, 'N') = 'E' then
1484: pv_return_code := jai_constants.expected_error ;
1485: pv_return_message :=
1486: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
1487: return ;
1488: end if;
1489:
1490: lv_codepath := null;

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

1503: );
1504:
1505: if nvl(lv_process_flag, 'N') = 'E' then
1506: /* raise_application_error(-20005,
1507: '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 :=
1508: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
1509: end if;
1510:
1511: --if lv_is_invoice_validated = 'Y' then --Comment by Zhiwei Hou for bug#13359892 DTC on 20120103

Line 1508: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;

1504:
1505: if nvl(lv_process_flag, 'N') = 'E' then
1506: /* raise_application_error(-20005,
1507: '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 :=
1508: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
1509: end if;
1510:
1511: --if lv_is_invoice_validated = 'Y' then --Comment by Zhiwei Hou for bug#13359892 DTC on 20120103
1512:

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

1534: );
1535:
1536: if nvl(lv_process_flag, 'N') = 'E' then
1537: /* raise_application_error(-20006,
1538: '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 :=
1539: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
1540: end if;
1541:
1542: --end if; --moved this from below for Bug#7433241--Comment by Zhiwei Hou for bug#13359892 DTC on 20120103

Line 1539: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;

1535:
1536: if nvl(lv_process_flag, 'N') = 'E' then
1537: /* raise_application_error(-20006,
1538: '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 :=
1539: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
1540: end if;
1541:
1542: --end if; --moved this from below for Bug#7433241--Comment by Zhiwei Hou for bug#13359892 DTC on 20120103
1543:

Line 1642: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);

1638: );
1639:
1640: if nvl(lv_process_flag, 'N') = 'E' then
1641: raise_application_error(-20005,
1642: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
1643: end if;
1644:
1645: IF lv_is_invoice_validated = 'N' THEN
1646: RETURN;

Line 1702: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);

1698: );
1699:
1700: if nvl(lv_process_flag, 'N') = 'E' then
1701: -- raise_application_error(-20007,
1702: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
1703: pv_return_code := jai_constants.expected_error ;
1704: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
1705: return ;
1706: end if;

Line 1704: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;

1700: if nvl(lv_process_flag, 'N') = 'E' then
1701: -- raise_application_error(-20007,
1702: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
1703: pv_return_code := jai_constants.expected_error ;
1704: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
1705: return ;
1706: end if;
1707:
1708: else

Line 1729: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);

1725: );
1726:
1727: if nvl(lv_process_flag, 'N') = 'E' then
1728: --raise_application_error(-20008,
1729: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
1730: pv_return_code := jai_constants.expected_error ;
1731: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
1732: return ;
1733: end if;

Line 1731: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;

1727: if nvl(lv_process_flag, 'N') = 'E' then
1728: --raise_application_error(-20008,
1729: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
1730: pv_return_code := jai_constants.expected_error ;
1731: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
1732: return ;
1733: end if;
1734:
1735:

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

1800: );
1801:
1802: if nvl(lv_process_flag, 'N') = 'E' then
1803: /* raise_application_error(-20009,
1804: '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 :=
1805: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
1806: end if;
1807:
1808: end if; /* Deleting */

Line 1805: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;

1801:
1802: if nvl(lv_process_flag, 'N') = 'E' then
1803: /* raise_application_error(-20009,
1804: '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 :=
1805: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
1806: end if;
1807:
1808: end if; /* Deleting */
1809:

Line 1813: --raise_application_error(-20010, 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || sqlerrm);

1809:
1810:
1811: exception
1812: when others then
1813: --raise_application_error(-20010, 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || sqlerrm);
1814: Pv_return_code := jai_constants.unexpected_error;
1815: Pv_return_message := 'Encountered an error in JAI_AP_IDA_TRIGGER_DTC_PKG.BRIUD_DTC_T1 ' ||
1816: 'Error on ap_invoice_distributions_all : ' || substr(sqlerrm,1,1900);
1817:

Line 1816: 'Error on ap_invoice_distributions_all : ' || substr(sqlerrm,1,1900);

1812: when others then
1813: --raise_application_error(-20010, 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || sqlerrm);
1814: Pv_return_code := jai_constants.unexpected_error;
1815: Pv_return_message := 'Encountered an error in JAI_AP_IDA_TRIGGER_DTC_PKG.BRIUD_DTC_T1 ' ||
1816: 'Error on ap_invoice_distributions_all : ' || substr(sqlerrm,1,1900);
1817:
1818: END BRIUD_DTC_T1 ;
1819:
1820: END JAI_AP_IDA_TRIGGER_DTC_PKG ;