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 AP_INVOICE_DISTRIBUTIONS_ALL

Line 180: AND source_table_name='AP_INVOICE_DISTRIBUTIONS_ALL'

176: is
177: SELECT 'Y' FROM jai_cmn_journal_entries
178: WHERE regime_code='SERVICE'
179: AND source='AP'
180: AND source_table_name='AP_INVOICE_DISTRIBUTIONS_ALL'
181: AND SOURCE_TRX_ID=CP_INVOICE_DISTIRBUTION_ID;
182:
183: lv_accting_exists VARCHAR2(1);
184: --end additions for bug#16241506

Line 255: FROM ap_invoice_distributions_all

251: PRAGMA AUTONOMOUS_TRANSACTION;
252:
253: CURSOR check_same_period_cur IS
254: SELECT 'Y'
255: FROM ap_invoice_distributions_all
256: WHERE invoice_id = pr_new.invoice_id
257: AND invoice_distribution_id = pr_new.parent_reversal_id
258: AND period_name = pr_new.period_name;
259:

Line 743: RAISE_APPLICATION_ERROR(-20007, 'Error - trigger ja_in_ap_aida_after_trg on ap_invoice_distributions_all: '

739:
740: IF ln_charge_account_id IS NULL THEN
741:
742: lv_process_message := 'Recovery/Liability Accounts are not defined at the regime registration. Review Invoice ID: ' || pr_new.invoice_id;
743: RAISE_APPLICATION_ERROR(-20007, 'Error - trigger ja_in_ap_aida_after_trg on ap_invoice_distributions_all: '
744: ||lv_process_message);
745: END IF;
746:
747: jai_cmn_rgm_recording_pkg.post_accounting(

Line 754: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',

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,
757: p_entered_cr => NULL,
758: p_entered_dr => ln_entered_amt,

Line 766: p_reference_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',

762: p_transaction_date => ld_transaction_date,
763: p_calling_object => lv_called_from,
764: p_repository_name => 'invoice_distribution_id',
765: p_repository_id => NULL,
766: p_reference_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',
767: p_reference_id => ln_invoice_dist_id,
768: p_currency_code => lv_currency_code,
769: p_curr_conv_date => ld_curr_conv_date,
770: p_curr_conv_type => lv_curr_conv_type,

Line 827: RAISE_APPLICATION_ERROR(-20007, 'Error - trigger ja_in_ap_aida_after_trg on ap_invoice_distributions_all: '

823: , p_account_name => lv_account_name);
824: IF ln_charge_account_id IS NULL THEN
825:
826: lv_process_message := 'Recovery/Liability Accounts are not defined at the regime registration. Review Invoice ID: ' || pr_new.invoice_id;
827: RAISE_APPLICATION_ERROR(-20007, 'Error - trigger ja_in_ap_aida_after_trg on ap_invoice_distributions_all: '
828: ||lv_process_message);
829: END IF;
830:
831: jai_cmn_rgm_recording_pkg.post_accounting(

Line 838: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',

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,
841: p_entered_cr => ln_entered_amt,
842: p_entered_dr => NULL,

Line 850: p_reference_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',

846: p_transaction_date => ld_transaction_date,
847: p_calling_object => lv_called_from,
848: p_repository_name => 'invoice_distribution_id',
849: p_repository_id => NULL,
850: p_reference_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',
851: p_reference_id => ln_invoice_dist_id,
852: p_currency_code => lv_currency_code,
853: p_curr_conv_date => ld_curr_conv_date,
854: p_curr_conv_type => lv_curr_conv_type,

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

1085: );
1086:
1087: if nvl(lv_process_flag, 'N') = 'E' then
1088: raise_application_error(-20007,
1089: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
1090: end if;
1091:
1092: else
1093: /* Bug 5640993 FP of 5553489. Added by JMEENA

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

1113: );
1114:
1115: if nvl(lv_process_flag, 'N') = 'E' then
1116: raise_application_error(-20008,
1117: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
1118: end if;
1119: END IF ; --End of bug#5640993
1120:
1121: end if; --Transactions in new regime

Line 1170: from ap_invoice_distributions_all

1166:
1167: cursor get_dist_no(cp_invoice_id number,cp_inv_lineno number)
1168: is
1169: select max(nvl(distribution_line_number,0))
1170: from ap_invoice_distributions_all
1171: where invoice_id = cp_invoice_id
1172: and invoice_line_number=cp_inv_lineno;
1173:
1174: cursor get_tax_name(cp_tax_id in number)

Line 1199: FROM ap_invoice_distributions_all

1195: WHERE transaction_id=cp_rcv_transaction_id;
1196:
1197: cursor c_get_accrual_acct(cp_invoice_id number,cp_inv_distid number) is
1198: select dist_code_combination_id
1199: FROM ap_invoice_distributions_all
1200: where invoice_id =cp_invoice_id
1201: and invoice_distribution_id=cp_inv_distid;
1202:
1203: ln_accrual_acct number;

Line 1275: from ap_invoice_distributions_all

1271: /*
1272: Cursor get_mis_dists
1273: is
1274: select *
1275: from ap_invoice_distributions_all
1276: where invoice_id=cp_invoice_id
1277: and line_type_lookup_code='MISCELLANEOUS'
1278: and invoice_distribut
1279: */

Line 1358: INSERT INTO ap_invoice_distributions_all

1354:
1355: ln_distribution_lineno :=nvl(ln_distribution_lineno,0)+1;
1356:
1357: --insert the variance amount with line_type_lookup_code as MISCELLANEOUS
1358: INSERT INTO ap_invoice_distributions_all
1359: (
1360: accounting_date,
1361: accrual_posted_flag,
1362: assets_addition_flag,

Line 1482: INSERT INTO ap_invoice_distributions_all

1478:
1479: ln_distribution_lineno :=nvl(ln_distribution_lineno,0)+1;
1480:
1481: --insert the variance amount with line_type_lookup_code as MISCELLANEOUS
1482: INSERT INTO ap_invoice_distributions_all
1483: (
1484: accounting_date,
1485: accrual_posted_flag,
1486: assets_addition_flag,

Line 1713: INSERT INTO ap_invoice_distributions_all

1709:
1710: ln_distribution_lineno :=nvl(ln_distribution_lineno,0)+1;
1711:
1712: --insert the variance amount with line_type_lookup_code as MISCELLANEOUS
1713: INSERT INTO ap_invoice_distributions_all
1714: (
1715: accounting_date,
1716: accrual_posted_flag,
1717: assets_addition_flag,

Line 1837: INSERT INTO ap_invoice_distributions_all

1833:
1834: ln_distribution_lineno :=nvl(ln_distribution_lineno,0)+1;
1835:
1836: --insert the variance amount with line_type_lookup_code as MISCELLANEOUS
1837: INSERT INTO ap_invoice_distributions_all
1838: (
1839: accounting_date,
1840: accrual_posted_flag,
1841: assets_addition_flag,

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

1976:
1977: 2. 11/05/2005 rchandan for bug#4333488. Version 116.1
1978: The Invoice Distribution DFF is eliminated and a new global DFF is used to
1979: maintain the functionality. From now the TDS tax, WCT tax and ESSI will not
1980: be populated in the attribute columns of ap_invoice_distributions_all table
1981: instead these will be populated in the global attribute columns. So the code changes are
1982: made accordingly.
1983:
1984: 3. 24/05/2005 Ramananda for bug# 4388958 File Version: 116.1

Line 2002: ap_invoice_distributions_all

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

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 2202: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_codepath ; return ;

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*/
2206: jai_ap_tds_generation_pkg.status_update_chk_validate

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 2312: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;

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
2316:

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 2338: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;

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
2342:

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

2437: );
2438:
2439: if nvl(lv_process_flag, 'N') = 'E' then
2440: raise_application_error(-20005,
2441: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
2442: end if;
2443:
2444: IF lv_is_invoice_validated = 'N' THEN
2445: RETURN;

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

2497: );
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;

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

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:
2507: else

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

2524: );
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;

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

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:
2534:

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 2604: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;

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 */
2608:

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

2608:
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:

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

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 ;
2618:
2619: END JAI_AP_IDA_TRIGGER_PKG ;