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 1319: jai_cmn_utils_pkg.print_log('6395039.log', 'Start of post_accounting');

1315: -- end, ssumaith for Bug 6664855
1316:
1317: BEGIN
1318: --Bug 5051541 bduvarag
1319: jai_cmn_utils_pkg.print_log('6395039.log', 'Start of post_accounting');
1320: -- added, ssumaith for Bug 6664855
1321: lv_reference1 := null ;
1322:
1323: OPEN c_get_source(p_repository_id) ;

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

1414: ELSIF p_regime_code = jai_constants.vat_regime THEN
1415: lv_reference10 := 'VAT Accounting for '||p_source||'. Transaction Type:'||nvl(p_source_trx_type,'~~')
1416: || '. ' ||lv_invoice_num_str; --Add by Xiao for bug#12598609
1417: lv_source_name := jai_constants.vat_source; -- modified by csahoo for bug#6155839
1418: jai_cmn_utils_pkg.print_log('6395039.log', lv_reference10);
1419:
1420: /*Added code for TCS for bug 12641455 by mmurtuza*/
1421: ELSIF p_regime_code = jai_constants.tcs_regime THEN
1422: /*For bug 12641455. Changed Service Tax to TCS in lv_reference10*/

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

1451: FND_FILE.put_line( FND_FILE.log, 'Accounting not done as Both Credit and Debit are Zero ');
1452: RETURN ;
1453:
1454: END IF;
1455: jai_cmn_utils_pkg.print_log('6395039.log', 'before call to get_period_name');
1456:
1457: get_period_name(
1458: p_organization_type => p_organization_type,
1459: p_organization_id => p_organization_id,

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

1461: p_period_name => lv_period_name,
1462: p_sob_id => ln_sob_id
1463: );
1464:
1465: jai_cmn_utils_pkg.print_log('6395039.log', 'after call to get_period_name');
1466:
1467: /* following added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1468: lv_gl_je_category := jai_constants.je_category_rg_entry;
1469: lv_status := 'NEW';--rchandan for bug#4428980

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

1466:
1467: /* following added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1468: lv_gl_je_category := jai_constants.je_category_rg_entry;
1469: lv_status := 'NEW';--rchandan for bug#4428980
1470: jai_cmn_utils_pkg.print_log('6395039.log', 'before insert inot gl_interface');
1471:
1472: INSERT INTO gl_interface (
1473: status, set_of_books_id, user_je_source_name, user_je_category_name,
1474: accounting_date, currency_code, date_created, created_by,

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

1486: --Bug 5051541 kunkumar
1487: p_source_table_name, p_source_document_id, p_repository_name, p_organization_id
1488: );
1489:
1490: jai_cmn_utils_pkg.print_log('6395039.log', 'after insert inot gl_interface');
1491: IF p_reference_id IS NOT NULL OR p_reference_name IS NOT NULL THEN
1492: lv_reference_name := p_reference_name;
1493: ln_reference_id := p_reference_id;
1494: ELSE

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

1494: ELSE
1495: lv_reference_name := p_repository_name;
1496: ln_reference_id := p_repository_id;
1497: END IF;
1498: jai_cmn_utils_pkg.print_log('6395039.log', 'before insert inot JAI_CMN_JOURNAL_ENTRIES');
1499:
1500: INSERT INTO JAI_CMN_JOURNAL_ENTRIES(JOURNAL_ENTRY_ID,
1501: regime_code, organization_id, set_of_books_id, tax_type, period_name,
1502: code_combination_id, accounted_dr, accounted_cr, transaction_date,

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

1507: p_code_combination_id, ln_accounted_dr, ln_accounted_cr, p_transaction_date,
1508: p_source, p_source_table_name, p_source_document_id, p_source_trx_type /* p_reference_name- Bug 13430127 */, p_reference_id,p_repository_id,/* added by ssawant for bug 5879769 */
1509: p_currency_code, p_curr_conv_rate, sysdate, FND_GLOBAL.user_id, sysdate, fnd_global.user_id, fnd_global.login_id
1510: );
1511: jai_cmn_utils_pkg.print_log('6395039.log', 'after insert inot JAI_CMN_JOURNAL_ENTRIES');
1512: /* Added by Ramananda for bug#4407165 */
1513:
1514: EXCEPTION
1515: WHEN OTHERS THEN

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

1514: EXCEPTION
1515: WHEN OTHERS THEN
1516: FND_MESSAGE.SET_NAME('JA','JAI_EXCEPTION_OCCURED');
1517: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG', lv_object_name ||'. Err:'||sqlerrm );
1518: jai_cmn_utils_pkg.print_log('6395039.log', 'exception occured'||sqlerrm);
1519: app_exception.raise_exception;
1520:
1521: END post_accounting;
1522:

Line 1952: 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);

1948:
1949: OPEN c_period_dtl(ln_sob_id, p_accounting_date);
1950: FETCH c_period_dtl INTO r_period_dtl;
1951: CLOSE c_period_dtl;
1952: 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);
1953:
1954: IF r_period_dtl.closing_status IN ('O','F') THEN
1955: p_sob_id := ln_sob_id;
1956: p_period_name := r_period_dtl.period_name;

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

1967: IF period.closing_status IN('O','F') THEN
1968: p_sob_id := ln_sob_id;
1969: p_period_name := period.period_name;
1970: ld_accounting_date := period.start_date;
1971: jai_cmn_utils_pkg.print_log('6395039.log', 'IN get_period_name : in IF Block');
1972: exit;
1973: END IF;
1974: END LOOP;
1975:

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

2256:
2257: BEGIN
2258:
2259: lv_statement_id := '1';
2260: jai_cmn_utils_pkg.print_log('6395039.log','START '||lv_statement_id);
2261:
2262: IF pn_repository_id IS NULL THEN
2263:
2264: lv_statement_id := '2';

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

2264: lv_statement_id := '2';
2265: OPEN c_regime_code(pn_regime_id);
2266: FETCH c_regime_code INTO lv_regime_code;
2267: CLOSE c_regime_code;
2268: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id||' lv_regime_code '||lv_regime_code);
2269:
2270: lv_tax_type := pv_tax_type;
2271: lv_source := pv_source;
2272: lv_source_trx_type := pv_source_trx_type;

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

2280: lv_statement_id := '3';
2281: OPEN c_repository_dtl(pn_repository_id);
2282: FETCH c_repository_dtl INTO r_repo_dtl;
2283: CLOSE c_repository_dtl;
2284: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
2285:
2286: lv_regime_code := r_repo_dtl.regime_code;
2287: lv_tax_type := r_repo_dtl.tax_type;
2288: lv_source := r_repo_dtl.source;

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

2293: ln_repository_id := pn_repository_id;
2294: END IF;
2295:
2296: lv_statement_id := '4';
2297: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
2298: IF pd_transaction_date IS NULL THEN
2299: ld_transaction_date := trunc(sysdate);
2300: ELSE
2301: ld_transaction_date := pd_transaction_date;

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

2301: ld_transaction_date := pd_transaction_date;
2302: END IF;
2303:
2304: lv_statement_id := '5';
2305: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
2306: IF pd_accounting_date IS NULL THEN
2307: ld_accounting_date := ld_transaction_date;
2308: ELSE
2309: ld_accounting_date := pd_accounting_date;

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

2309: ld_accounting_date := pd_accounting_date;
2310: END IF;
2311:
2312: lv_statement_id := '6';
2313: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
2314: IF pn_credit_ccid IS NOT NULL AND pn_credit_amount <> 0 THEN
2315:
2316: lv_statement_id := '7';
2317: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

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

2313: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
2314: IF pn_credit_ccid IS NOT NULL AND pn_credit_amount <> 0 THEN
2315:
2316: lv_statement_id := '7';
2317: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
2318: ln_credit := pn_credit_amount;
2319: ln_debit := null;
2320: ln_accounted_credit := pn_credit_amount;
2321: ln_accounted_debit := null;

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

2320: ln_accounted_credit := pn_credit_amount;
2321: ln_accounted_debit := null;
2322:
2323: lv_statement_id := '8';
2324: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
2325: post_accounting(
2326: p_regime_code => lv_regime_code,
2327: p_tax_type => lv_tax_type,
2328: p_organization_type => pv_organization_type,

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

2351:
2352: END IF;
2353:
2354: lv_statement_id := '9';
2355: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
2356: IF pn_debit_ccid IS NOT NULL AND pn_debit_amount <> 0 THEN
2357:
2358: lv_statement_id := '10';
2359: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);

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

2355: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
2356: IF pn_debit_ccid IS NOT NULL AND pn_debit_amount <> 0 THEN
2357:
2358: lv_statement_id := '10';
2359: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
2360: ln_debit := pn_debit_amount;
2361: ln_credit := null;
2362: ln_accounted_debit := pn_debit_amount;
2363: ln_accounted_credit := null;

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

2362: ln_accounted_debit := pn_debit_amount;
2363: ln_accounted_credit := null;
2364:
2365: lv_statement_id := '11';
2366: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
2367: post_accounting(
2368: p_regime_code => lv_regime_code,
2369: p_tax_type => lv_tax_type,
2370: p_organization_type => pv_organization_type,

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

2394: END IF;
2395:
2396: pv_process_flag := jai_constants.successful;
2397: lv_statement_id := '15';
2398: jai_cmn_utils_pkg.print_log('6395039.log',lv_statement_id);
2399:
2400: EXCEPTION
2401: WHEN OTHERS THEN
2402: pv_process_flag := jai_constants.unexpected_error;

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

2401: WHEN OTHERS THEN
2402: pv_process_flag := jai_constants.unexpected_error;
2403: pv_process_message := 'doVatAccounting Error(Stmt:'||lv_statement_id||') Occured:'||SQLERRM;
2404: --lv_codepath := jai_general_pkg.plot_codepath(-999, lv_codepath);
2405: jai_cmn_utils_pkg.print_log('6395039.log', 'Error in doVatAccounting. Stmt:'||lv_statement_id);
2406: Fnd_file.put_line( fnd_file.log, 'Error in doVatAccounting. Stmt:'||lv_statement_id);
2407:
2408: END do_vat_accounting;
2409: