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 JAI_CONSTANTS

Line 1099: pv_return_code := jai_constants.successful ;

1095: end process_ipv;
1096:
1097:
1098: BEGIN
1099: pv_return_code := jai_constants.successful ;
1100: /* ----------------------------------------------------------------------------
1101: FILENAME : jai_ap_ida_dtc_t.plb
1102:
1103: Created By : Cholei

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

1249: S.No Bug Date Author and Details
1250: 1 6493858 4-DEC-2007 Added by Nitin Prashar, for cancelation of Base Invoice*/
1251:
1252:
1253: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
1254: ln_org_id := pr_new.org_id;
1255: ln_set_of_books_id := pr_new.set_of_books_id;
1256: elsif pv_action = jai_constants.deleting then
1257: ln_org_id := pr_old.org_id;

Line 1256: elsif pv_action = jai_constants.deleting then

1252:
1253: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
1254: ln_org_id := pr_new.org_id;
1255: ln_set_of_books_id := pr_new.set_of_books_id;
1256: elsif pv_action = jai_constants.deleting then
1257: ln_org_id := pr_old.org_id;
1258: ln_set_of_books_id := pr_old.set_of_books_id;
1259: end if;
1260:

Line 1275: if pv_action = jai_constants.inserting

1271: */
1272:
1273: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_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'));
1274: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','pr_new.line_type_lookup_code '||pr_new.line_type_lookup_code);
1275: if pv_action = jai_constants.inserting
1276: 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'))
1277: AND ( pr_new.line_type_lookup_code ='IPV' or pr_new.line_type_lookup_code ='ERV' )
1278: then
1279: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','before call to process_ipv');

Line 1319: if pv_action = jai_constants.updating

1315:
1316: --Comment out by Chong.Lei for ZX integration test 20120411 start
1317: /*
1318: --Added by Xiao Lv for bug#7347508 on 11-Jan-2010, begin
1319: if pv_action = jai_constants.updating
1320: then
1321: IF nvl(pr_new.global_attribute_category, 'JA.IN.APXINWKB.DISTRIBUTIONS' ) = 'JA.IN.APXINWKB.DISTRIBUTIONS'
1322: AND ( nvl(pr_old.global_attribute1, 0) <> nvl(pr_new.global_attribute1, 0)
1323: OR nvl(pr_old.global_attribute2, 0) <> nvl(pr_new.global_attribute2, 0)

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

1332: --Added by Xiao Lv for bug#7347508 on 11-Jan-2010, end
1333: */
1334: --Comment out by Chong.Lei for ZX integration test 20120411 end
1335:
1336: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
1337:
1338: if nvl(pr_new.global_attribute_category, 'JA.IN.APXINWKB.DISTRIBUTIONS' ) = 'JA.IN.APXINWKB.DISTRIBUTIONS' and -- rchandan for bug#4333488
1339: pr_new.line_type_lookup_code <> 'PREPAY' and
1340: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */

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 1418: if pv_action = jai_constants.updating then

1414: is set to A or T process_tds_at_inv_validate shall be called. If process_tds_at_inv_validate is called after insertion
1415: of data in JAI_AP_TDS_PREPAYMENTS it results in incorrect TDS deduction. Hence moved the code to insert JAI_AP_TDS_PREPAYMENTS
1416: after validation of Invoice.*/
1417: --To handle the condition, if there are PP applications/Unapplications, before the SI is validated
1418: if pv_action = jai_constants.updating then
1419: IF pr_new.line_type_lookup_code = 'PREPAY' THEN
1420: lv_prepay_flag := NULL;
1421: --Apply Scenario
1422: IF NVL(pr_new.amount,0) < 0 THEN

Line 1450: if pv_action = jai_constants.updating then

1446: END IF;
1447: end if;
1448: /*Bug 12630283 - End*/
1449: /* Intercepting Validate event */
1450: if pv_action = jai_constants.updating then
1451:
1452: --Update by Chong.Lei for ZX integration test 20120411 start
1453: -- if nvl(pr_old.match_status_flag, 'Q') <> nvl(pr_new.match_status_flag, 'Q') and
1454: -- pr_new.match_status_flag = 'A' and

Line 1484: pv_return_code := jai_constants.expected_error ;

1480: p_process_message => lv_process_message,
1481: p_codepath => lv_codepath
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;

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 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 1560: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then

1556: end if; /* updating */
1557: /* Intercepting Validate event */
1558:
1559:
1560: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
1561:
1562: /*START, by amandali for Bug#10430662*/
1563: 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
1564: pr_new.global_attribute_category := 'JA.IN.APXINWKB.DISTRIBUTIONS';

Line 1605: if pv_action = jai_constants.inserting then

1601: end if;
1602: end if;
1603: /*END, by amandali for Bug#10430662*/
1604: /* Prepayment functionality */
1605: if pv_action = jai_constants.inserting then
1606: if pr_new.line_type_lookup_code = 'PREPAY' and
1607: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */
1608: c_rec_ap_invoices_all.cancelled_date is null
1609: then

Line 1703: pv_return_code := jai_constants.expected_error ;

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;
1707:

Line 1730: pv_return_code := jai_constants.expected_error ;

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;
1734:

Line 1791: if pv_action = jai_constants.deleting then

1787: /*End for bug 8330522*/
1788:
1789: end if; /* inserting */
1790:
1791: if pv_action = jai_constants.deleting then
1792:
1793: jai_ap_tds_tax_defaultation.process_delete
1794: (
1795: p_invoice_id => pr_old.invoice_id,

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

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:
1818: END BRIUD_DTC_T1 ;