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_CMN_RGM_RECORDING_PKG dependencies on JAI_CMN_UTILS_PKG

Line 933: jai_cmn_utils_pkg.print_log('6395039.log', 'Start of post_accounting');

929: -- end, ssumaith for Bug 6664855
930:
931: BEGIN
932: --Bug 5051541 bduvarag
933: jai_cmn_utils_pkg.print_log('6395039.log', 'Start of post_accounting');
934:
935: -- added, ssumaith for Bug 6664855
936: lv_reference1 := null ;
937:

Line 985: jai_cmn_utils_pkg.print_log('6395039.log', lv_reference10);

981: lv_source_name := jai_constants.service_tax_source; -- added by csahoo for bug#6155839
982: ELSIF p_regime_code = jai_constants.vat_regime THEN
983: lv_reference10 := 'VAT Accounting for '||p_source||'. Transaction Type:'||nvl(p_source_trx_type,'~~');
984: lv_source_name := jai_constants.vat_source; -- modified by csahoo for bug#6155839
985: jai_cmn_utils_pkg.print_log('6395039.log', lv_reference10);
986: END IF;
987:
988: ld_accounting_date := nvl( trunc(p_accounting_date), trunc(sysdate) );
989:

Line 1015: jai_cmn_utils_pkg.print_log('6395039.log', 'before call to get_period_name');

1011: FND_FILE.put_line( FND_FILE.log, 'Accounting not done as Both Credit and Debit are Zero ');
1012: RETURN ;
1013:
1014: END IF;
1015: jai_cmn_utils_pkg.print_log('6395039.log', 'before call to get_period_name');
1016: get_period_name(
1017: p_organization_type => p_organization_type,
1018: p_organization_id => p_organization_id,
1019: p_accounting_date => ld_accounting_date,

Line 1023: jai_cmn_utils_pkg.print_log('6395039.log', 'after call to get_period_name');

1019: p_accounting_date => ld_accounting_date,
1020: p_period_name => lv_period_name,
1021: p_sob_id => ln_sob_id
1022: );
1023: jai_cmn_utils_pkg.print_log('6395039.log', 'after call to get_period_name');
1024:
1025: /* following added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1026: lv_gl_je_category := jai_constants.je_category_rg_entry;
1027: lv_status := 'NEW';--rchandan for bug#4428980

Line 1028: jai_cmn_utils_pkg.print_log('6395039.log', 'before insert inot gl_interface');

1024:
1025: /* following added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1026: lv_gl_je_category := jai_constants.je_category_rg_entry;
1027: lv_status := 'NEW';--rchandan for bug#4428980
1028: jai_cmn_utils_pkg.print_log('6395039.log', 'before insert inot gl_interface');
1029: INSERT INTO gl_interface (
1030: status, set_of_books_id, user_je_source_name, user_je_category_name,
1031: accounting_date, currency_code, date_created, created_by,
1032: actual_flag, entered_cr, entered_dr, accounted_cr, accounted_dr, transaction_date,

Line 1046: jai_cmn_utils_pkg.print_log('6395039.log', 'after insert inot gl_interface');

1042: -- commented lv_organization_code and passed refererence1 ssumaith bug#6664855
1043: --Bug 5051541 kunkumar
1044: p_source_table_name, p_source_document_id, p_repository_name, p_organization_id
1045: );
1046: jai_cmn_utils_pkg.print_log('6395039.log', 'after insert inot gl_interface');
1047: IF p_reference_id IS NOT NULL OR p_reference_name IS NOT NULL THEN
1048: lv_reference_name := p_reference_name;
1049: ln_reference_id := p_reference_id;
1050: ELSE

Line 1054: jai_cmn_utils_pkg.print_log('6395039.log', 'before insert inot JAI_CMN_JOURNAL_ENTRIES');

1050: ELSE
1051: lv_reference_name := p_repository_name;
1052: ln_reference_id := p_repository_id;
1053: END IF;
1054: jai_cmn_utils_pkg.print_log('6395039.log', 'before insert inot JAI_CMN_JOURNAL_ENTRIES');
1055: INSERT INTO JAI_CMN_JOURNAL_ENTRIES(JOURNAL_ENTRY_ID,
1056: regime_code, organization_id, set_of_books_id, tax_type, period_name,
1057: code_combination_id, accounted_dr, accounted_cr, transaction_date,
1058: source, source_table_name, source_trx_id, reference_name, reference_id, repository_id,/* added by ssawant for bug 5879769 */

Line 1067: jai_cmn_utils_pkg.print_log('6395039.log', 'after insert inot JAI_CMN_JOURNAL_ENTRIES');

1063: p_source, p_source_table_name, p_source_document_id, p_reference_name, p_reference_id,p_repository_id,/* added by ssawant for bug 5879769 */
1064: p_currency_code, p_curr_conv_rate, sysdate, FND_GLOBAL.user_id, sysdate, fnd_global.user_id, fnd_global.login_id
1065: );
1066:
1067: jai_cmn_utils_pkg.print_log('6395039.log', 'after insert inot JAI_CMN_JOURNAL_ENTRIES');
1068: /* Added by Ramananda for bug#4407165 */
1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: FND_MESSAGE.SET_NAME('JA','JAI_EXCEPTION_OCCURED');

Line 1073: jai_cmn_utils_pkg.print_log('6395039.log', 'exception occured'||sqlerrm);

1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: FND_MESSAGE.SET_NAME('JA','JAI_EXCEPTION_OCCURED');
1072: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG', lv_object_name ||'. Err:'||sqlerrm );
1073: jai_cmn_utils_pkg.print_log('6395039.log', 'exception occured'||sqlerrm);
1074: app_exception.raise_exception;
1075:
1076: END post_accounting;
1077:

Line 1500: jai_cmn_utils_pkg.print_log('6395039.log', 'IN get_period_name : ln_sob_id '||ln_sob_id||' r_period_dtl.period_name '||r_period_dtl.period_name);

1496:
1497: OPEN c_period_dtl(ln_sob_id, p_accounting_date);
1498: FETCH c_period_dtl INTO r_period_dtl;
1499: CLOSE c_period_dtl;
1500: jai_cmn_utils_pkg.print_log('6395039.log', 'IN get_period_name : ln_sob_id '||ln_sob_id||' r_period_dtl.period_name '||r_period_dtl.period_name);
1501:
1502: IF r_period_dtl.closing_status IN ('O','F') THEN
1503: p_sob_id := ln_sob_id;
1504: p_period_name := r_period_dtl.period_name;

Line 1519: jai_cmn_utils_pkg.print_log('6395039.log', 'IN get_period_name : in IF Block');

1515: IF period.closing_status IN('O','F') THEN
1516: p_sob_id := ln_sob_id;
1517: p_period_name := period.period_name;
1518: ld_accounting_date := period.start_date;
1519: jai_cmn_utils_pkg.print_log('6395039.log', 'IN get_period_name : in IF Block');
1520: exit;
1521: END IF;
1522: END LOOP;
1523:

Line 1803: jai_cmn_utils_pkg.print_log('6395039.log','START '||lv_statement_id);

1799:
1800: BEGIN
1801:
1802: lv_statement_id := '1';
1803: jai_cmn_utils_pkg.print_log('6395039.log','START '||lv_statement_id);
1804:
1805: IF pn_repository_id IS NULL THEN
1806:
1807: lv_statement_id := '2';

Line 1811: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id||' lv_regime_code '||lv_regime_code);

1807: lv_statement_id := '2';
1808: OPEN c_regime_code(pn_regime_id);
1809: FETCH c_regime_code INTO lv_regime_code;
1810: CLOSE c_regime_code;
1811: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id||' lv_regime_code '||lv_regime_code);
1812:
1813: lv_tax_type := pv_tax_type;
1814: lv_source := pv_source;
1815: lv_source_trx_type := pv_source_trx_type;

Line 1827: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

1823: lv_statement_id := '3';
1824: OPEN c_repository_dtl(pn_repository_id);
1825: FETCH c_repository_dtl INTO r_repo_dtl;
1826: CLOSE c_repository_dtl;
1827: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
1828:
1829: lv_regime_code := r_repo_dtl.regime_code;
1830: lv_tax_type := r_repo_dtl.tax_type;
1831: lv_source := r_repo_dtl.source;

Line 1840: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

1836: ln_repository_id := pn_repository_id;
1837: END IF;
1838:
1839: lv_statement_id := '4';
1840: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
1841: IF pd_transaction_date IS NULL THEN
1842: ld_transaction_date := trunc(sysdate);
1843: ELSE
1844: ld_transaction_date := pd_transaction_date;

Line 1848: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

1844: ld_transaction_date := pd_transaction_date;
1845: END IF;
1846:
1847: lv_statement_id := '5';
1848: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
1849: IF pd_accounting_date IS NULL THEN
1850: ld_accounting_date := ld_transaction_date;
1851: ELSE
1852: ld_accounting_date := pd_accounting_date;

Line 1856: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

1852: ld_accounting_date := pd_accounting_date;
1853: END IF;
1854:
1855: lv_statement_id := '6';
1856: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
1857: IF pn_credit_ccid IS NOT NULL AND pn_credit_amount <> 0 THEN
1858:
1859: lv_statement_id := '7';
1860: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

Line 1860: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

1856: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
1857: IF pn_credit_ccid IS NOT NULL AND pn_credit_amount <> 0 THEN
1858:
1859: lv_statement_id := '7';
1860: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
1861: ln_credit := pn_credit_amount;
1862: ln_debit := null;
1863: ln_accounted_credit := pn_credit_amount;
1864: ln_accounted_debit := null;

Line 1867: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

1863: ln_accounted_credit := pn_credit_amount;
1864: ln_accounted_debit := null;
1865:
1866: lv_statement_id := '8';
1867: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
1868: post_accounting(
1869: p_regime_code => lv_regime_code,
1870: p_tax_type => lv_tax_type,
1871: p_organization_type => pv_organization_type,

Line 1898: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

1894:
1895: END IF;
1896:
1897: lv_statement_id := '9';
1898: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
1899: IF pn_debit_ccid IS NOT NULL AND pn_debit_amount <> 0 THEN
1900:
1901: lv_statement_id := '10';
1902: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

Line 1902: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

1898: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
1899: IF pn_debit_ccid IS NOT NULL AND pn_debit_amount <> 0 THEN
1900:
1901: lv_statement_id := '10';
1902: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
1903: ln_debit := pn_debit_amount;
1904: ln_credit := null;
1905: ln_accounted_debit := pn_debit_amount;
1906: ln_accounted_credit := null;

Line 1909: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

1905: ln_accounted_debit := pn_debit_amount;
1906: ln_accounted_credit := null;
1907:
1908: lv_statement_id := '11';
1909: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
1910: post_accounting(
1911: p_regime_code => lv_regime_code,
1912: p_tax_type => lv_tax_type,
1913: p_organization_type => pv_organization_type,

Line 1941: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

1937: END IF;
1938:
1939: pv_process_flag := jai_constants.successful;
1940: lv_statement_id := '15';
1941: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
1942:
1943: EXCEPTION
1944: WHEN OTHERS THEN
1945: pv_process_flag := jai_constants.unexpected_error;

Line 1948: jai_cmn_utils_pkg.print_log('6395039.log', 'Error in doVatAccounting. Stmt:'||lv_statement_id);

1944: WHEN OTHERS THEN
1945: pv_process_flag := jai_constants.unexpected_error;
1946: pv_process_message := 'doVatAccounting Error(Stmt:'||lv_statement_id||') Occured:'||SQLERRM;
1947: --lv_codepath := jai_general_pkg.plot_codepath(-999, lv_codepath);
1948: jai_cmn_utils_pkg.print_log('6395039.log', 'Error in doVatAccounting. Stmt:'||lv_statement_id);
1949: Fnd_file.put_line( fnd_file.log, 'Error in doVatAccounting. Stmt:'||lv_statement_id);
1950:
1951: END do_vat_accounting;
1952: