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_AR_VALIDATE_DATA_PKG dependencies on JAI_AR_VALIDATE_DATA_PKG

Line 1: PACKAGE BODY jai_ar_validate_data_pkg

1: PACKAGE BODY jai_ar_validate_data_pkg
2: /* $Header: jai_ar_val_data.plb 120.2.12010000.2 2008/11/06 11:55:22 csahoo ship $ */
3: AS
4:
5: /*

Line 21: PROCEDURE populate_error_table (p_error_table OUT NOCOPY jai_ar_validate_data_pkg.t_error_table,

17: Issue: TAXES NOT FLOWING TO CREDIT MEMO WHEN INVOICNG RULE IS APPLIED FOR TRANSACTION
18: Fix: Modified the code in pre_validation. Added a cursor cur_chk_revrec_run_cm
19: --------------------------------------------------------------------------------------------------------------------------*/
20:
21: PROCEDURE populate_error_table (p_error_table OUT NOCOPY jai_ar_validate_data_pkg.t_error_table,
22: p_process_status OUT NOCOPY VARCHAR2,
23: p_process_message OUT NOCOPY VARCHAR2)
24: IS
25: BEGIN

Line 104: PROCEDURE display_error_summary(p_error_table IN jai_ar_validate_data_pkg.t_error_table,

100: p_process_message := SUBSTR(SQLERRM,1,300);
101: END populate_error_table;
102:
103:
104: PROCEDURE display_error_summary(p_error_table IN jai_ar_validate_data_pkg.t_error_table,
105: p_total_count IN NUMBER,
106: p_filename IN VARCHAR2,
107: p_process_status OUT NOCOPY VARCHAR2,
108: p_process_message OUT NOCOPY VARCHAR2)

Line 835: lt_error_table jai_ar_validate_data_pkg.t_error_table;

831: ln_precision NUMBER;
832: lv_sql_statement VARCHAR2(4000);
833: ln_exists NUMBER;
834:
835: lt_error_table jai_ar_validate_data_pkg.t_error_table;
836:
837: BEGIN
838: p_process_status := jai_constants.successful;
839: p_process_message := NULL;

Line 1125: OPEN jai_ar_validate_data_pkg.cur_curr_precision(rec_ra_customer_trx.set_of_books_id);

1121: ln_error_cnt := 1;
1122:
1123: ln_precision := null;
1124:
1125: OPEN jai_ar_validate_data_pkg.cur_curr_precision(rec_ra_customer_trx.set_of_books_id);
1126: FETCH jai_ar_validate_data_pkg.cur_curr_precision INTO ln_precision;
1127: CLOSE jai_ar_validate_data_pkg.cur_curr_precision;
1128:
1129: /*

Line 1126: FETCH jai_ar_validate_data_pkg.cur_curr_precision INTO ln_precision;

1122:
1123: ln_precision := null;
1124:
1125: OPEN jai_ar_validate_data_pkg.cur_curr_precision(rec_ra_customer_trx.set_of_books_id);
1126: FETCH jai_ar_validate_data_pkg.cur_curr_precision INTO ln_precision;
1127: CLOSE jai_ar_validate_data_pkg.cur_curr_precision;
1128:
1129: /*
1130: || set ra_cust_trx_line_gl_dist_all.amount = il.tax_amount for all account_class in TAX and 'FREIGHT'

Line 1127: CLOSE jai_ar_validate_data_pkg.cur_curr_precision;

1123: ln_precision := null;
1124:
1125: OPEN jai_ar_validate_data_pkg.cur_curr_precision(rec_ra_customer_trx.set_of_books_id);
1126: FETCH jai_ar_validate_data_pkg.cur_curr_precision INTO ln_precision;
1127: CLOSE jai_ar_validate_data_pkg.cur_curr_precision;
1128:
1129: /*
1130: || set ra_cust_trx_line_gl_dist_all.amount = il.tax_amount for all account_class in TAX and 'FREIGHT'
1131: */

Line 1664: OPEN jai_ar_validate_data_pkg.cur_curr_precision(rec_ra_customer_trx.set_of_books_id);

1660: END IF;
1661:
1662: ln_precision := null;
1663:
1664: OPEN jai_ar_validate_data_pkg.cur_curr_precision(rec_ra_customer_trx.set_of_books_id);
1665: FETCH jai_ar_validate_data_pkg.cur_curr_precision INTO ln_precision;
1666: CLOSE jai_ar_validate_data_pkg.cur_curr_precision;
1667:
1668: ln_err_num := 25;

Line 1665: FETCH jai_ar_validate_data_pkg.cur_curr_precision INTO ln_precision;

1661:
1662: ln_precision := null;
1663:
1664: OPEN jai_ar_validate_data_pkg.cur_curr_precision(rec_ra_customer_trx.set_of_books_id);
1665: FETCH jai_ar_validate_data_pkg.cur_curr_precision INTO ln_precision;
1666: CLOSE jai_ar_validate_data_pkg.cur_curr_precision;
1667:
1668: ln_err_num := 25;
1669: --To check, if AAAF = AA * exchange_rate(CM) for ar_receivable_applications_all

Line 1666: CLOSE jai_ar_validate_data_pkg.cur_curr_precision;

1662: ln_precision := null;
1663:
1664: OPEN jai_ar_validate_data_pkg.cur_curr_precision(rec_ra_customer_trx.set_of_books_id);
1665: FETCH jai_ar_validate_data_pkg.cur_curr_precision INTO ln_precision;
1666: CLOSE jai_ar_validate_data_pkg.cur_curr_precision;
1667:
1668: ln_err_num := 25;
1669: --To check, if AAAF = AA * exchange_rate(CM) for ar_receivable_applications_all
1670: IF lt_error_table(ln_err_num).enable = 'Y' THEN

Line 2017: OPEN jai_ar_validate_data_pkg.cur_curr_precision(rec_get_cust_trx.set_of_books_id);

2013: --=================================================================================================================--
2014: --Some more common validations--
2015: --=================================================================================================================--
2016:
2017: OPEN jai_ar_validate_data_pkg.cur_curr_precision(rec_get_cust_trx.set_of_books_id);
2018: FETCH jai_ar_validate_data_pkg.cur_curr_precision INTO ln_precision;
2019: CLOSE jai_ar_validate_data_pkg.cur_curr_precision;
2020:
2021: ln_local_cnt := 0;

Line 2018: FETCH jai_ar_validate_data_pkg.cur_curr_precision INTO ln_precision;

2014: --Some more common validations--
2015: --=================================================================================================================--
2016:
2017: OPEN jai_ar_validate_data_pkg.cur_curr_precision(rec_get_cust_trx.set_of_books_id);
2018: FETCH jai_ar_validate_data_pkg.cur_curr_precision INTO ln_precision;
2019: CLOSE jai_ar_validate_data_pkg.cur_curr_precision;
2020:
2021: ln_local_cnt := 0;
2022: ln_err_num := 8;

Line 2019: CLOSE jai_ar_validate_data_pkg.cur_curr_precision;

2015: --=================================================================================================================--
2016:
2017: OPEN jai_ar_validate_data_pkg.cur_curr_precision(rec_get_cust_trx.set_of_books_id);
2018: FETCH jai_ar_validate_data_pkg.cur_curr_precision INTO ln_precision;
2019: CLOSE jai_ar_validate_data_pkg.cur_curr_precision;
2020:
2021: ln_local_cnt := 0;
2022: ln_err_num := 8;
2023: --To check if AADR = ADR * exchange_rate in ar_payment_schedules_all

Line 2383: END jai_ar_validate_data_pkg;

2379: jai_cmn_utils_pkg.print_log(lv_log_filename, 'Encountered an Oracle error : '||lv_process_message);
2380:
2381: END post_validation;
2382:
2383: END jai_ar_validate_data_pkg;