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_OM_WDD_PROCESSING_PKG dependencies on FND_LOG

Line 4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY JAI_OM_WDD_PROCESSING_PKG AS
2: /* $Header: jai_om_wdd_prc.plb 120.0.12020000.3 2013/03/19 00:31:44 vkaranam noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_OM_WDD_PROCESSING_PKG';
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

1: PACKAGE BODY JAI_OM_WDD_PROCESSING_PKG AS
2: /* $Header: jai_om_wdd_prc.plb 120.0.12020000.3 2013/03/19 00:31:44 vkaranam noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_OM_WDD_PROCESSING_PKG';
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

2: /* $Header: jai_om_wdd_prc.plb 120.0.12020000.3 2013/03/19 00:31:44 vkaranam noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_OM_WDD_PROCESSING_PKG';
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_OM_WDD_PROCESSING_PKG';
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(60) := 'JA.PLSQL.JAI_OM_WDD_PROCESSING_PKG.';

Line 8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(60) := 'JA.PLSQL.JAI_OM_WDD_PROCESSING_PKG.';
12:

Line 9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(60) := 'JA.PLSQL.JAI_OM_WDD_PROCESSING_PKG.';
12:
13: /*

Line 10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(60) := 'JA.PLSQL.JAI_OM_WDD_PROCESSING_PKG.';
12:
13: /*
14: REM +======================================================================+

Line 279: FND_LOG.STRING(G_LEVEL_STATEMENT,

275: pv_return_code := jai_constants.expected_error ;
276: pv_return_message := 'Matched Quantity -- ' || TO_CHAR(NVL(v_matched_qty,0)) ||
277: ' should be equal to Shipped Quantity -- ' || TO_CHAR(NVL(v_shipped_quantity,0));
278: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING(G_LEVEL_STATEMENT,
280: G_MODULE_NAME || v_api_name,
281: 'Returned with ' || pv_return_code || pv_return_message);
282: END IF;
283: return ;

Line 292: FND_LOG.STRING(G_LEVEL_STATEMENT,

288: if nvl(v_matched_qty,0) > 0 then
289: pv_return_code := jai_constants.expected_error ;
290: pv_return_message := 'Please Unmatch the Delivery prior to backordering ' ;
291: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
292: FND_LOG.STRING(G_LEVEL_STATEMENT,
293: G_MODULE_NAME || v_api_name,
294: 'Returned with ' || pv_return_code || pv_return_message);
295: END IF;
296: return ;

Line 335: FND_LOG.STRING(G_LEVEL_STATEMENT,

331: pv_return_code := jai_constants.expected_error ;
332: pv_return_message := 'LC Matched Quantity -- ' || TO_CHAR(NVL(v_lc_qty_matched,0)) ||
333: ' should be equal to Shipped Quantity -- ' || TO_CHAR(NVL(v_lc_shipped_qty,0)) || ' for LC enabled Orders';
334: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
335: FND_LOG.STRING(G_LEVEL_STATEMENT,
336: G_MODULE_NAME || v_api_name,
337: 'Returned with ' || pv_return_code || pv_return_message);
338: END IF;
339: return ;

Line 914: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

910: counter :=0;
911: v_conversion_rate := 0;
912: v_matched_qty := 0;
913:
914: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
915: FND_LOG.STRING(G_LEVEL_PROCEDURE,
916: G_MODULE_NAME || v_api_name || '.BEGIN',
917: G_PKG_NAME || ': ' || v_api_name || '()+');
918: END IF;

Line 915: FND_LOG.STRING(G_LEVEL_PROCEDURE,

911: v_conversion_rate := 0;
912: v_matched_qty := 0;
913:
914: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
915: FND_LOG.STRING(G_LEVEL_PROCEDURE,
916: G_MODULE_NAME || v_api_name || '.BEGIN',
917: G_PKG_NAME || ': ' || v_api_name || '()+');
918: END IF;
919:

Line 921: FND_LOG.STRING(G_LEVEL_STATEMENT,

917: G_PKG_NAME || ': ' || v_api_name || '()+');
918: END IF;
919:
920: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
921: FND_LOG.STRING(G_LEVEL_STATEMENT,
922: G_MODULE_NAME || v_api_name,
923: 'The TIME Stamp this ENTRY IS Created IS ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
924: END IF;
925:

Line 1013: FND_LOG.STRING(G_LEVEL_STATEMENT,

1009: pv_return_code := jai_constants.expected_error ;
1010: pv_return_message := 'Matched Quantity -- ' || TO_CHAR(NVL(v_matched_qty,0)) ||
1011: ' should be equal to Shipped Quantity -- ' || TO_CHAR(NVL(v_shipped_quantity,0)) ;
1012: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1013: FND_LOG.STRING(G_LEVEL_STATEMENT,
1014: G_MODULE_NAME || v_api_name,
1015: 'Returned with ' || pv_return_code || pv_return_message);
1016: END IF;
1017: return ;

Line 1077: FND_LOG.STRING(G_LEVEL_STATEMENT,

1073: FETCH rg23d_amount_cur INTO v_tax_amt,v_base_tax_amt,v_func_tax_amt;
1074: CLOSE rg23d_amount_cur;
1075:
1076: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1077: FND_LOG.STRING(G_LEVEL_STATEMENT,
1078: G_MODULE_NAME || v_api_name,
1079: 'Delivery detail id ' || v_delivery_Detail_id ||
1080: ' Currency Conversion rate --' || v_curr_conv_rate);
1081: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 1081: FND_LOG.STRING(G_LEVEL_STATEMENT,

1077: FND_LOG.STRING(G_LEVEL_STATEMENT,
1078: G_MODULE_NAME || v_api_name,
1079: 'Delivery detail id ' || v_delivery_Detail_id ||
1080: ' Currency Conversion rate --' || v_curr_conv_rate);
1081: FND_LOG.STRING(G_LEVEL_STATEMENT,
1082: G_MODULE_NAME || v_api_name,
1083: 'Tax type --'|| rec.tax_type ||
1084: ' tax id '||rec.tax_id ||
1085: ' tax_amount '|| v_tax_amt ||

Line 1098: FND_LOG.STRING(G_LEVEL_STATEMENT,

1094: v_tax_amt := (v_func_tax_amt * 1/ nvl(v_curr_conv_rate,1)) ;
1095: v_base_tax_amt := v_tax_amt;
1096:
1097: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1098: FND_LOG.STRING(G_LEVEL_STATEMENT,
1099: G_MODULE_NAME || v_api_name,
1100: 'After conversion excise transaction tax amount '||v_tax_amt);
1101: END IF;
1102: else

Line 1107: FND_LOG.STRING(G_LEVEL_STATEMENT,

1103: --for other type of taxes functional tax amounts will be changing
1104: v_func_tax_amt := (v_tax_amt * nvl(v_curr_conv_rate,1)) ;
1105:
1106: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1107: FND_LOG.STRING(G_LEVEL_STATEMENT,
1108: G_MODULE_NAME || v_api_name,
1109: 'After conversion other taxes functional tax amount '||v_func_tax_amt);
1110: END IF;
1111: end if;

Line 1175: FND_LOG.STRING(G_LEVEL_STATEMENT,

1171: v_oth_excise_duty_amount := NVL(v_oth_excise_duty_amount,0) + v_tax_amount ;
1172: END IF;
1173:
1174: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1175: FND_LOG.STRING(G_LEVEL_STATEMENT,
1176: G_MODULE_NAME || v_api_name,
1177: '1 v_basic_excise_duty_amount -> ' || v_basic_excise_duty_amount ||
1178: ', v_add_excise_duty_amount -> '|| v_add_excise_duty_amount ||
1179: ', v_oth_excise_duty_amount -> '|| v_oth_excise_duty_amount);

Line 1263: FND_LOG.STRING(G_LEVEL_STATEMENT,

1259: fetch c_chk_rgm_tax_exists into ln_tcs_exists;
1260: close c_chk_rgm_tax_exists ;
1261:
1262: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1263: FND_LOG.STRING(G_LEVEL_STATEMENT,
1264: G_MODULE_NAME || v_api_name,
1265: 'tcs regime code :' || jai_constants.tcs_regime ||
1266: ', delivery_detail_id :' || v_delivery_detail_id ||
1267: ', ln_tcs_exists :' || ln_tcs_exists);

Line 1293: FND_LOG.STRING(G_LEVEL_STATEMENT,

1289: );
1290:
1291: if lv_process_flag <> jai_constants.successful then
1292: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1293: FND_LOG.STRING(G_LEVEL_STATEMENT,
1294: G_MODULE_NAME || v_api_name,
1295: 'Error in jai_rgm_thhold_proc_pkg.get_threshold_slab_id. ' || lv_process_message);
1296: END IF;
1297: app_exception.raise_exception

Line 1307: FND_LOG.STRING(G_LEVEL_STATEMENT,

1303:
1304: if ln_threshold_slab_id is not null then
1305: /* Threshold level is up. Surcharge needs to be defaulted , so find out the tax category based on the threshold slab */
1306: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1307: FND_LOG.STRING(G_LEVEL_STATEMENT,
1308: G_MODULE_NAME || v_api_name,
1309: 'Before jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id.' ||
1310: 'ln_threshold_slab_id :' || ln_threshold_slab_id);
1311: END IF;

Line 1323: FND_LOG.STRING(G_LEVEL_STATEMENT,

1319: );
1320:
1321: if lv_process_flag <> jai_constants.successful then
1322: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1323: FND_LOG.STRING(G_LEVEL_STATEMENT,
1324: G_MODULE_NAME || v_api_name,
1325: 'Error in jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id. ' || lv_process_message);
1326: END IF;
1327: app_exception.raise_exception

Line 1358: FND_LOG.STRING(G_LEVEL_STATEMENT,

1354:
1355: ln_vat_assessable_value := nvl(ln_vat_assessable_value * v_shipped_quantity / v_quantity, 0);
1356:
1357: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1358: FND_LOG.STRING(G_LEVEL_STATEMENT,
1359: G_MODULE_NAME || v_api_name,
1360: 'Before jai_rgm_thhold_proc_pkg.default_thhold_taxes.' ||
1361: 'ln_threshold_tax_cat_id :' || ln_threshold_tax_cat_id ||
1362: 'ln_vat_assessable_value :' || ln_vat_assessable_value);

Line 1388: FND_LOG.STRING(G_LEVEL_STATEMENT,

1384: );
1385:
1386: if lv_process_flag <> jai_constants.successful then
1387: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1388: FND_LOG.STRING(G_LEVEL_STATEMENT,
1389: G_MODULE_NAME || v_api_name,
1390: 'Error in jai_rgm_thhold_proc_pkg.default_thhold_taxes. ' || lv_process_message);
1391: END IF;
1392: app_exception.raise_exception

Line 1687: FND_LOG.STRING(G_LEVEL_STATEMENT,

1683: /*
1684: ||Does interim TCS accounting for the TCS type of taxes
1685: */
1686: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1687: FND_LOG.STRING(G_LEVEL_STATEMENT,
1688: G_MODULE_NAME || v_api_name,
1689: 'Before in jai_ar_tcs_rep_pkg.wsh_interim_accounting.');
1690: END IF;
1691: jai_ar_tcs_rep_pkg.wsh_interim_accounting ( p_delivery_id => v_delivery_id ,

Line 1705: FND_LOG.STRING(G_LEVEL_STATEMENT,

1701: IF lv_process_flag = jai_constants.expected_error OR
1702: lv_process_flag = jai_constants.unexpected_error
1703: THEN
1704: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1705: FND_LOG.STRING(G_LEVEL_STATEMENT,
1706: G_MODULE_NAME || v_api_name,
1707: 'Error in jai_ar_tcs_rep_pkg.wsh_interim_accounting. ' || lv_process_message);
1708: END IF;
1709: /*

Line 1728: FND_LOG.STRING(G_LEVEL_STATEMENT,

1724: FETCH bonded_cur INTO v_bonded_flag;
1725: CLOSE bonded_cur;
1726:
1727: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1728: FND_LOG.STRING(G_LEVEL_STATEMENT,
1729: G_MODULE_NAME || v_api_name,
1730: '2 BEFORE the assignment OF v_order_type_id');
1731: END IF;
1732: v_order_type_id := v_source_header_type_id;

Line 1735: FND_LOG.STRING(G_LEVEL_STATEMENT,

1731: END IF;
1732: v_order_type_id := v_source_header_type_id;
1733:
1734: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1735: FND_LOG.STRING(G_LEVEL_STATEMENT,
1736: G_MODULE_NAME || v_api_name,
1737: '3 v_order_type_id IS '|| v_order_type_id);
1738: END IF;
1739:

Line 1749: FND_LOG.STRING(G_LEVEL_STATEMENT,

1745: v_register_code
1746: );
1747:
1748: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1749: FND_LOG.STRING(G_LEVEL_STATEMENT,
1750: G_MODULE_NAME || v_api_name,
1751: '4 AFTER the Register Code CURSOR');
1752: END IF;
1753:

Line 1759: FND_LOG.STRING(G_LEVEL_STATEMENT,

1755: FETCH fin_year_cur INTO v_fin_year;
1756: CLOSE fin_year_cur;
1757:
1758: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1759: FND_LOG.STRING(G_LEVEL_STATEMENT,
1760: G_MODULE_NAME || v_api_name,
1761: '5 AFTER the Financial Year CURSOR');
1762: END IF;
1763:

Line 1774: FND_LOG.STRING(G_LEVEL_STATEMENT,

1770: IF NVL(v_bonded_flag,'Y') = 'Y' AND
1771: ( NVL(v_tot_excise_amt,0) > 0 OR v_excise_exempt_type IS NOT NULL ) THEN
1772:
1773: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1774: FND_LOG.STRING(G_LEVEL_STATEMENT,
1775: G_MODULE_NAME || v_api_name,
1776: '6 BEFORE the Preference cursors');
1777: END IF;
1778:

Line 1784: FND_LOG.STRING(G_LEVEL_STATEMENT,

1780: FETCH pref_cur INTO v_pref_rg23a, v_pref_rg23c, v_pref_pla,v_export_oriented_unit;
1781: CLOSE pref_cur;
1782:
1783: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1784: FND_LOG.STRING(G_LEVEL_STATEMENT,
1785: G_MODULE_NAME || v_api_name,
1786: '7 BEFORE the RG Balance CURSOR');
1787: END IF;
1788:

Line 1799: FND_LOG.STRING(G_LEVEL_STATEMENT,

1795: v_other_pla_balance;
1796: CLOSE rg_bal_cur;
1797:
1798: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1799: FND_LOG.STRING(G_LEVEL_STATEMENT,
1800: G_MODULE_NAME || v_api_name,
1801: '8 BEFORE the SSI Unit Flag CURSOR');
1802: END IF;
1803:

Line 1809: FND_LOG.STRING(G_LEVEL_STATEMENT,

1805: FETCH ssi_unit_flag_cur INTO v_ssi_unit_flag;
1806: CLOSE ssi_unit_flag_cur;
1807:
1808: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1809: FND_LOG.STRING(G_LEVEL_STATEMENT,
1810: G_MODULE_NAME || v_api_name,
1811: '9 BEFORE the Register Code CURSOR');
1812: END IF;
1813:

Line 1830: FND_LOG.STRING(G_LEVEL_STATEMENT,

1826: IF NVL(v_excise_exempt_type, '@@@') NOT IN ('CT2', 'EXCISE_EXEMPT_CERT',
1827: 'CT2_OTH', 'EXCISE_EXEMPT_CERT_OTH','CT3' ) THEN
1828:
1829: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1830: FND_LOG.STRING(G_LEVEL_STATEMENT,
1831: G_MODULE_NAME || v_api_name,
1832: '10 BEFORE the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION');
1833: END IF;
1834:

Line 1870: FND_LOG.STRING(G_LEVEL_STATEMENT,

1866: lv_process_message
1867: );
1868:
1869: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1870: FND_LOG.STRING(G_LEVEL_STATEMENT,
1871: G_MODULE_NAME || v_api_name,
1872: '11 AFTER the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION v_reg_type -> ' || v_reg_type);
1873: END IF;
1874: ELSE

Line 1891: FND_LOG.STRING(G_LEVEL_STATEMENT,

1887: END IF;
1888: v_exempt_bal := (NVL(v_exempt_bal, 0) + v_shipped_quantity * v_assessable_value * NVL(v_modvat_tax_rate,0))/100;
1889:
1890: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1891: FND_LOG.STRING(G_LEVEL_STATEMENT,
1892: G_MODULE_NAME || v_api_name,
1893: '12 BEFORE the jai_om_wsh_pkg.get_excise_register_with_bal FUNCTION v_exempt_bal -> '|| v_exempt_bal);
1894: END IF;
1895:

Line 1931: FND_LOG.STRING(G_LEVEL_STATEMENT,

1927: lv_process_message
1928: );
1929:
1930: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1931: FND_LOG.STRING(G_LEVEL_STATEMENT,
1932: G_MODULE_NAME || v_api_name,
1933: '13 AFTER the jai_om_wsh_pkg.get_excise_register_with_bal FUNCTION v_reg_type -> '|| v_reg_type);
1934: END IF;
1935: v_basic_ed_amt := v_exempt_bal;

Line 1939: FND_LOG.STRING(G_LEVEL_STATEMENT,

1935: v_basic_ed_amt := v_exempt_bal;
1936: v_tot_basic_ed_amt := NVL(v_tot_basic_ed_amt,0) + v_exempt_bal;
1937:
1938: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1939: FND_LOG.STRING(G_LEVEL_STATEMENT,
1940: G_MODULE_NAME || v_api_name,
1941: '14 v_basic_ed_amt -> '|| v_basic_ed_amt||', v_tot_basic_ed_amt -> '|| v_tot_basic_ed_amt);
1942: END IF;
1943: END IF;

Line 1956: FND_LOG.STRING(G_LEVEL_STATEMENT,

1952: IF nvl(v_reg_exp_date,sysdate) < sysdate then
1953: pv_return_code := jai_constants.expected_error ;
1954: pv_return_message := 'Bonded Register Validity has Expired on ' || v_reg_exp_date ;
1955: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1956: FND_LOG.STRING(G_LEVEL_STATEMENT,
1957: G_MODULE_NAME || v_api_name,
1958: 'Returned with ' || pv_return_code || pv_return_message);
1959: END IF;
1960: return ;

Line 1971: FND_LOG.STRING(G_LEVEL_STATEMENT,

1967: TO_CHAR(v_register_balance) ||
1968: ' ,which IS less than Excisable Amount -> ' ||
1969: TO_CHAR(v_tot_excise_amt) ;
1970: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1971: FND_LOG.STRING(G_LEVEL_STATEMENT,
1972: G_MODULE_NAME || v_api_name,
1973: 'Returned with ' || pv_return_code || pv_return_message);
1974: END IF;
1975: return ;

Line 1987: FND_LOG.STRING(G_LEVEL_STATEMENT,

1983: When Others then
1984: pv_return_code := jai_constants.expected_error ;
1985: pv_return_message := substr(sqlerrm,1,200) ;
1986: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1987: FND_LOG.STRING(G_LEVEL_STATEMENT,
1988: G_MODULE_NAME || v_api_name,
1989: 'Exception with ' || pv_return_code || pv_return_message);
1990: END IF;
1991: return ;

Line 2610: FND_LOG.STRING(G_LEVEL_STATEMENT,

2606: WHEN OTHERS THEN
2607: pv_return_code := 'E';
2608: pv_return_message := 'An error occurred when passing RG23D accounting entries. Check the lines in GL Interface';
2609: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2610: FND_LOG.STRING(G_LEVEL_STATEMENT,
2611: G_MODULE_NAME || v_api_name,
2612: 'Exception with ' || pv_return_code || pv_return_message);
2613: END IF;
2614: END RG23D_REV_ACCOUNTING;

Line 2744: FND_LOG.STRING(G_LEVEL_STATEMENT,

2740: CLOSE Get_Status_Cur;
2741:
2742: IF NVL(v_status_code,'#') NOT IN ('CO', 'IT','CL') THEN
2743: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2744: FND_LOG.STRING(G_LEVEL_STATEMENT,
2745: G_MODULE_NAME || v_api_name,
2746: 'Status is not in CO, IT or CL.');
2747: END IF;
2748: RETURN 'N';

Line 2753: FND_LOG.STRING(G_LEVEL_STATEMENT,

2749: END IF;
2750:
2751: IF NVL(pr_new.shipped_quantity,0) = 0 THEN
2752: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2753: FND_LOG.STRING(G_LEVEL_STATEMENT,
2754: G_MODULE_NAME || v_api_name,
2755: 'Shipped Quantity is 0.');
2756: END IF;
2757: RETURN 'N';

Line 2766: FND_LOG.STRING(G_LEVEL_STATEMENT,

2762: FETCH Get_So_Lines_Count_Cur INTO v_so_lines_count;
2763: CLOSE Get_So_Lines_Count_Cur ;
2764: IF v_so_lines_count = 0 THEN
2765: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2766: FND_LOG.STRING(G_LEVEL_STATEMENT,
2767: G_MODULE_NAME || v_api_name,
2768: 'SO Line Count is 0.');
2769: END IF;
2770: RETURN 'N';

Line 2891: FND_LOG.STRING(G_LEVEL_STATEMENT,

2887: FETCH matched_receipt_cur1 INTO v_matched_qty;
2888: CLOSE matched_receipt_cur1;
2889: IF NVL(v_shipped_quantity,0) <> NVL(v_matched_qty,0) THEN
2890: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2891: FND_LOG.STRING(G_LEVEL_STATEMENT,
2892: G_MODULE_NAME || v_api_name,
2893: 'Matched Quantity -- ' || TO_CHAR(NVL(v_matched_qty,0)) ||
2894: ' should be equal to Shipped Quantity -- ' || TO_CHAR(NVL(v_shipped_quantity,0)));
2895: END IF;

Line 2979: FND_LOG.STRING(G_LEVEL_STATEMENT,

2975: );
2976: IF v_curr_conv_rate IS NULL
2977: THEN
2978: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2979: FND_LOG.STRING(G_LEVEL_STATEMENT,
2980: G_MODULE_NAME || v_api_name,
2981: 'Currency Conversion on shipment date not setup.');
2982: END IF;
2983: lv_process_message := 'Currency Conversion on shipment date not setup.';

Line 3071: FND_LOG.STRING(G_LEVEL_STATEMENT,

3067: fetch c_chk_rgm_tax_exists into ln_tcs_exists;
3068: close c_chk_rgm_tax_exists ;
3069:
3070: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3071: FND_LOG.STRING(G_LEVEL_STATEMENT,
3072: G_MODULE_NAME || v_api_name,
3073: 'tcs regime code :' || jai_constants.tcs_regime ||
3074: ', delivery_detail_id :' || v_delivery_detail_id ||
3075: ', ln_tcs_exists :' || ln_tcs_exists);

Line 3106: FND_LOG.STRING(G_LEVEL_STATEMENT,

3102: );
3103:
3104: if lv_process_flag <> jai_constants.successful then
3105: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3106: FND_LOG.STRING(G_LEVEL_STATEMENT,
3107: G_MODULE_NAME || v_api_name,
3108: 'Error in jai_rgm_thhold_proc_pkg.get_threshold_slab_id. ' || lv_process_message);
3109: END IF;
3110: app_exception.raise_exception

Line 3120: FND_LOG.STRING(G_LEVEL_STATEMENT,

3116:
3117: if ln_threshold_slab_id is not null then
3118: /* Threshold level is up. Surcharge needs to be defaulted , so find out the tax category based on the threshold slab */
3119: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3120: FND_LOG.STRING(G_LEVEL_STATEMENT,
3121: G_MODULE_NAME || v_api_name,
3122: 'Before jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id.' ||
3123: 'ln_threshold_slab_id :' || ln_threshold_slab_id);
3124: END IF;

Line 3136: FND_LOG.STRING(G_LEVEL_STATEMENT,

3132: );
3133:
3134: if lv_process_flag <> jai_constants.successful then
3135: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3136: FND_LOG.STRING(G_LEVEL_STATEMENT,
3137: G_MODULE_NAME || v_api_name,
3138: 'Error in jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id. ' || lv_process_message);
3139: END IF;
3140: app_exception.raise_exception

Line 3311: FND_LOG.STRING(G_LEVEL_STATEMENT,

3307: pv_return_message => lv_return_message);
3308:
3309: if lv_return_code <> jai_constants.successful then
3310: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3311: FND_LOG.STRING(G_LEVEL_STATEMENT,
3312: G_MODULE_NAME || v_api_name,
3313: 'validate_matched_qty returned with ' || lv_return_code || lv_return_message);
3314: END IF;
3315:

Line 3333: FND_LOG.STRING(G_LEVEL_STATEMENT,

3329: pv_return_message => lv_return_message);
3330:
3331: if lv_return_code <> jai_constants.successful then
3332: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3333: FND_LOG.STRING(G_LEVEL_STATEMENT,
3334: G_MODULE_NAME || v_api_name,
3335: 'validate_currency returned with ' || lv_return_code || lv_return_message);
3336: END IF;
3337:

Line 3355: FND_LOG.STRING(G_LEVEL_STATEMENT,

3351: pv_return_message => lv_return_message);
3352:
3353: if lv_return_code <> jai_constants.successful then
3354: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3355: FND_LOG.STRING(G_LEVEL_STATEMENT,
3356: G_MODULE_NAME || v_api_name,
3357: 'validate_tcs_taxes returned with ' || lv_return_code || lv_return_message);
3358: END IF;
3359:

Line 3379: FND_LOG.STRING(G_LEVEL_STATEMENT,

3375:
3376: /*if px_return_code <> jai_constants.successful then*/ -- commented out by zhiwei.xin for bug #16207271 on 5-FEB-2013
3377: if lv_return_code <> jai_constants.successful then -- added by zhiwei.xin for bug #16207271 on 5-FEB-2013
3378: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3379: FND_LOG.STRING(G_LEVEL_STATEMENT,
3380: G_MODULE_NAME || v_api_name,
3381: 'validate_wsh_interim_acct returned with ' || lv_return_code || lv_return_message);
3382:
3383: END IF;

Line 3403: FND_LOG.STRING(G_LEVEL_STATEMENT,

3399: When Others then
3400: lv_return_code := jai_constants.unexpected_error;
3401: lv_return_message := substr(sqlerrm,1,200) ;
3402: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3403: FND_LOG.STRING(G_LEVEL_STATEMENT,
3404: G_MODULE_NAME || v_api_name,
3405: 'Exception with ' || lv_return_code || lv_return_message);
3406: END IF;
3407:

Line 3464: FND_LOG.STRING(G_LEVEL_STATEMENT,

3460: l_eventname := p_event.getEventName;
3461: l_eventkey := p_event.getEventKey;
3462:
3463: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3464: FND_LOG.STRING(G_LEVEL_STATEMENT,
3465: G_MODULE_NAME || v_api_name,
3466: 'Event Name:' || l_eventname || ',Event Key :' || l_eventkey);
3467: END IF;
3468:

Line 3485: FND_LOG.STRING(G_LEVEL_STATEMENT,

3481: px_return_code => lv_return_code,
3482: px_exp_msg => lt_exp_msg);
3483:
3484: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3485: FND_LOG.STRING(G_LEVEL_STATEMENT,
3486: G_MODULE_NAME || v_api_name,
3487: 'Validation processing returned with ' || lv_return_code);
3488: END IF;
3489:

Line 3501: FND_LOG.STRING(G_LEVEL_STATEMENT,

3497: pv_return_code => lv_return_code,
3498: pv_return_message => lv_return_msg);
3499:
3500: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3501: FND_LOG.STRING(G_LEVEL_STATEMENT,
3502: G_MODULE_NAME || v_api_name,
3503: 'Interfaced processing returned with ' || lv_return_code || lv_return_msg);
3504: END IF;
3505:

Line 3516: FND_LOG.STRING(G_LEVEL_STATEMENT,

3512: pv_return_code => lv_return_code ,
3513: pv_return_message => lv_return_msg);
3514:
3515: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3516: FND_LOG.STRING(G_LEVEL_STATEMENT,
3517: G_MODULE_NAME || v_api_name,
3518: 'accounting entries for RG23D reversal returned with ' || lv_return_code || lv_return_msg);
3519: END IF;
3520:

Line 3608: FND_LOG.STRING(G_LEVEL_STATEMENT,

3604: l_eventname := p_event.getEventName;
3605: l_eventkey := p_event.getEventKey;
3606:
3607: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3608: FND_LOG.STRING(G_LEVEL_STATEMENT,
3609: G_MODULE_NAME || v_api_name,
3610: 'Event Name:' || l_eventname || ',Event Key :' || l_eventkey);
3611: END IF;
3612:

Line 3623: FND_LOG.STRING(G_LEVEL_STATEMENT,

3619: pv_return_code => lv_return_code,
3620: pv_return_message => lv_return_msg);
3621:
3622: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3623: FND_LOG.STRING(G_LEVEL_STATEMENT,
3624: G_MODULE_NAME || v_api_name,
3625: 'Released processing returned with ' || lv_return_code || lv_return_msg);
3626: END IF;
3627:

Line 3679: FND_LOG.STRING(G_LEVEL_STATEMENT,

3675: l_eventname := p_event.getEventName;
3676: l_eventkey := p_event.getEventKey;
3677:
3678: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3679: FND_LOG.STRING(G_LEVEL_STATEMENT,
3680: G_MODULE_NAME || v_api_name,
3681: 'Event Name:' || l_eventname || ',Event Key :' || l_eventkey);
3682: END IF;
3683:

Line 3692: FND_LOG.STRING(G_LEVEL_STATEMENT,

3688: CLEAR_EXP_MSG(p_delivery_id => to_number(l_eventKey),
3689: p_exp_entity => v_exp_entity);
3690:
3691: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3692: FND_LOG.STRING(G_LEVEL_STATEMENT,
3693: G_MODULE_NAME || v_api_name,
3694: 'Process Inventory. Delivery Id : ' || l_eventKey);
3695: END IF;
3696: -- process inventory for VAT/Excise Invoice Generation

Line 3707: FND_LOG.STRING(G_LEVEL_STATEMENT,

3703: end if;
3704:
3705:
3706: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3707: FND_LOG.STRING(G_LEVEL_STATEMENT,
3708: G_MODULE_NAME || v_api_name,
3709: 'Submit status check CP. Delivery_id : ' || l_eventKey);
3710: END IF;
3711:

Line 3737: FND_LOG.STRING(G_LEVEL_STATEMENT,

3733: POPULATE_EXP_MSG(p_delivery_id => to_number(l_eventkey),
3734: p_exp_msg => lt_exp_msg);
3735:
3736: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3737: FND_LOG.STRING(G_LEVEL_STATEMENT,
3738: G_MODULE_NAME || v_api_name,
3739: 'Submit status check CP. Delivery_id : ' || l_eventKey);
3740: END IF;
3741:

Line 3766: FND_LOG.STRING(G_LEVEL_STATEMENT,

3762: POPULATE_EXP_MSG(p_delivery_id => to_number(l_eventkey),
3763: p_exp_msg => lt_exp_msg);
3764:
3765: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3766: FND_LOG.STRING(G_LEVEL_STATEMENT,
3767: G_MODULE_NAME || v_api_name,
3768: 'Submit status check CP. Delivery_id : ' || l_eventKey);
3769: END IF;
3770:

Line 3850: FND_LOG.STRING(G_LEVEL_STATEMENT,

3846: BEGIN
3847: lv_delivery_id := p_delivery_id;
3848:
3849: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3850: FND_LOG.STRING(G_LEVEL_STATEMENT,
3851: G_MODULE_NAME || v_api_name,
3852: 'Process Inventory Started. p_delivery_id :' || lv_delivery_id);
3853: END IF;
3854:

Line 3879: FND_LOG.STRING(G_LEVEL_STATEMENT,

3875: fetch c_reg_num into lv_reg_num ;
3876: close c_reg_num;
3877:
3878: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3879: FND_LOG.STRING(G_LEVEL_STATEMENT,
3880: G_MODULE_NAME || v_api_name,
3881: 'Parameters for Excise Invoice Generation.' ||
3882: 'pn_delivery_id : ' || lv_delivery_id);
3883: END IF;

Line 3891: FND_LOG.STRING(G_LEVEL_STATEMENT,

3887: retcode => pv_return_code,
3888: pn_delivery_id => lv_delivery_id);
3889:
3890: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3891: FND_LOG.STRING(G_LEVEL_STATEMENT,
3892: G_MODULE_NAME || v_api_name,
3893: 'Excise Invoice Generation returned with ' || pv_return_code || pv_return_msg);
3894: END IF;
3895:

Line 3901: FND_LOG.STRING(G_LEVEL_STATEMENT,

3897: return;
3898: END IF;
3899:
3900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3901: FND_LOG.STRING(G_LEVEL_STATEMENT,
3902: G_MODULE_NAME || v_api_name,
3903: 'Parameters for VAT Invoice Generation / Accounting.' ||
3904: 'p_regime_id : ' || lv_regime_id ||
3905: ',p_registration_num : ' || lv_reg_num ||

Line 3941: FND_LOG.STRING(G_LEVEL_STATEMENT,

3937: p_debug => jai_constants.no,
3938: p_called_from => 'BE');
3939:
3940: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3941: FND_LOG.STRING(G_LEVEL_STATEMENT,
3942: G_MODULE_NAME || v_api_name,
3943: 'VAT Invoice Generation / Accounting returned with ' || pv_return_code || pv_return_msg);
3944: END IF;
3945:

Line 3992: FND_LOG.STRING(G_LEVEL_STATEMENT,

3988:
3989: if nvl(lv_err_exist, 'N') = 'Y' then
3990:
3991: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3992: FND_LOG.STRING(G_LEVEL_STATEMENT,
3993: G_MODULE_NAME || v_api_name,
3994: 'Delete table JAI_WSH_EXCEPTIONS_T. Delivery Id : ' || p_delivery_id || 'Exception Entity : ' || p_exp_entity);
3995: END IF;
3996:

Line 4032: FND_LOG.STRING(G_LEVEL_STATEMENT,

4028: FOR l_exp_msg_index IN 1 .. NVL(p_exp_msg.LAST,0)
4029: LOOP
4030:
4031: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4032: FND_LOG.STRING(G_LEVEL_STATEMENT,
4033: G_MODULE_NAME || v_api_name,
4034: 'Populate table JAI_WSH_EXCEPTIONS_T. Delivery Id : ' || p_delivery_id || 'Exception_Entity : ' || p_exp_msg(l_exp_msg_index).EXCEPTION_ENTITY);
4035: END IF;
4036: