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.

[Home] [Help]

APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on FND_LOG

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

90: p_call_from IN varchar2 default 'VALIDATION' --Added by Chong for Bug#13802244 2012/09/17
91: )
92: is
93:
94: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
95: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
96: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
97: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
98: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

91: )
92: is
93:
94: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
95: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
96: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
97: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
98: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
99: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

92: is
93:
94: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
95: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
96: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
97: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
98: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
99: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
100: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

93:
94: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
95: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
96: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
97: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
98: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
99: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
100: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
101: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AP_DTC_TAX_DEFAULTATION';

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

94: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
95: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
96: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
97: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
98: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
99: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
100: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
101: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AP_DTC_TAX_DEFAULTATION';
102: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_DTC_TAX_DEFAULTATION';

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

95: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
96: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
97: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
98: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
99: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
100: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
101: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AP_DTC_TAX_DEFAULTATION';
102: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_DTC_TAX_DEFAULTATION';
103: G_VENDOR_SITE_DEF_SEC_CODE CONSTANT VARCHAR2(40) := 'Vendor Site Default Section Code';

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

96: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
97: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
98: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
99: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
100: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
101: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AP_DTC_TAX_DEFAULTATION';
102: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_DTC_TAX_DEFAULTATION';
103: G_VENDOR_SITE_DEF_SEC_CODE CONSTANT VARCHAR2(40) := 'Vendor Site Default Section Code';
104: G_NTL_ACC_SEC_MAP CONSTANT VARCHAR2(40) := 'Natural Account - Section Code Mapping';

Line 771: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');

767:
768: lv_confirm_flg VARCHAR2(1); -- 'Y':confirmed, 'N':unconfirmed added by zhiwei.xin for bug 13792748 on 08-Mar-2012
769:
770: begin
771: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
772: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_inv_id: '||p_inv_id);
773: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_redefault_tax_category: '||p_redefault_tax_category);
774: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_redefault_section_code: '||p_redefault_section_code);
775: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_call_from: '||p_call_from);

Line 772: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_inv_id: '||p_inv_id);

768: lv_confirm_flg VARCHAR2(1); -- 'Y':confirmed, 'N':unconfirmed added by zhiwei.xin for bug 13792748 on 08-Mar-2012
769:
770: begin
771: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
772: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_inv_id: '||p_inv_id);
773: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_redefault_tax_category: '||p_redefault_tax_category);
774: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_redefault_section_code: '||p_redefault_section_code);
775: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_call_from: '||p_call_from);
776:

Line 773: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_redefault_tax_category: '||p_redefault_tax_category);

769:
770: begin
771: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
772: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_inv_id: '||p_inv_id);
773: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_redefault_tax_category: '||p_redefault_tax_category);
774: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_redefault_section_code: '||p_redefault_section_code);
775: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_call_from: '||p_call_from);
776:
777: -- clear tables

Line 774: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_redefault_section_code: '||p_redefault_section_code);

770: begin
771: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
772: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_inv_id: '||p_inv_id);
773: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_redefault_tax_category: '||p_redefault_tax_category);
774: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_redefault_section_code: '||p_redefault_section_code);
775: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_call_from: '||p_call_from);
776:
777: -- clear tables
778: if p_redefault_section_code = 'Y' then

Line 775: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_call_from: '||p_call_from);

771: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
772: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_inv_id: '||p_inv_id);
773: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_redefault_tax_category: '||p_redefault_tax_category);
774: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_redefault_section_code: '||p_redefault_section_code);
775: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_call_from: '||p_call_from);
776:
777: -- clear tables
778: if p_redefault_section_code = 'Y' then
779: delete from JAI_AP_TDS_DEFAULT where INVOICE_ID = p_inv_id;

Line 792: FND_LOG.STRING(G_LEVEL_STATEMENT,

788: if lv_vendor_type is NULL then
789: p_process_flag := 'N';
790: p_process_message := 'TDS vendor type classification is not present for the vendor. ';
791: if G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL then
792: FND_LOG.STRING(G_LEVEL_STATEMENT,
793: G_MODULE_NAME || l_api_name ,
794: 'TDS vendor type classification is not present for the vendor ' || ln_vendor_id);
795: end if;
796: return;

Line 917: FND_LOG.STRING(G_LEVEL_STATEMENT,

913:
914: p_process_flag := 'E';
915: p_process_message := 'TDS Period is not defined.';
916: if G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL then
917: FND_LOG.STRING(G_LEVEL_STATEMENT,
918: G_MODULE_NAME || l_api_name,
919: 'TDS Period is not defined / Invoice Accounting Date can not span across Financial Years.');
920: end if;
921: return;

Line 942: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_cnt_matched_lines: ' || ln_cnt_matched_lines);

938: --When get count > 0, means AP invoice containing matched invoice lines
939: open c_check_is_matched;
940: fetch c_check_is_matched into ln_cnt_matched_lines;
941: close c_check_is_matched;
942: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_cnt_matched_lines: ' || ln_cnt_matched_lines);
943:
944: if ln_cnt_matched_lines > 0 then
945: --PO/receipt Match AP invoice
946: lv_tax_default_option := G_VENDOR_SITE_DEF_SEC_CODE;

Line 976: FND_LOG.STRING(G_LEVEL_STATEMENT,

972: if lv_tax_default_option is NULL then
973: p_process_flag := 'E';
974: p_process_message := 'TDS Defaultation Option is not defined in Regime Setup.';
975: if G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL then
976: FND_LOG.STRING(G_LEVEL_STATEMENT,
977: G_MODULE_NAME || l_api_name,
978: 'TDS Defaultation Option not defined in Regime Setup.');
979: end if;
980: return;

Line 984: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'lv_tax_default_option: '||lv_tax_default_option);

980: return;
981: end if;
982: Commented out by Chong for bug#15939571 20121210 End */
983:
984: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'lv_tax_default_option: '||lv_tax_default_option);
985:
986: if lv_tax_default_option = G_NTL_ACC_SEC_MAP then
987:
988: if p_redefault_section_code = 'Y' then

Line 1058: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Default section from vendor site: '||lv_default_section_code);

1054: fetch c_get_null_sec_code into lv_default_section_code;
1055: close c_get_null_sec_code;
1056: end if;
1057:
1058: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Default section from vendor site: '||lv_default_section_code);
1059: --If any line missed mapping to any section, default on vendor site default section.
1060: UPDATE JAI_AP_TDS_DEFAULT
1061: SET TDS_SECTION_CODE = lv_default_section_code
1062: WHERE INVOICE_ID = p_inv_id

Line 1122: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'NO PAN 1@Tax end date issue in tax category: '||ln_tax_ctg_id);

1118: fetch c_check_taxes_end_date into lv_end_date_check2;
1119: close c_check_taxes_end_date;
1120:
1121: if (NVL(lv_end_date_check, '0') = '1') or (NVL(lv_end_date_check2, '0') = '1')then
1122: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'NO PAN 1@Tax end date issue in tax category: '||ln_tax_ctg_id);
1123: return;
1124: end if;
1125: -----------------------------------------------------------------------------
1126: --Added by Chong for bug#16274617 End

Line 1131: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'NO PAN 1@ln_tax_ctg_id: '||ln_tax_ctg_id);

1127:
1128: UPDATE JAI_AP_TDS_DEFAULT
1129: SET TAX_CATEGORY_ID = ln_tax_ctg_id
1130: WHERE INVOICE_ID = p_inv_id;
1131: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'NO PAN 1@ln_tax_ctg_id: '||ln_tax_ctg_id);
1132: else
1133:
1134: -- added by zhiwei.xin for bug 13792748 on 08-Mar-2012 end.
1135:

Line 1179: FND_LOG.STRING(G_LEVEL_STATEMENT,

1175: if ln_thr_header_id is NULL then
1176: p_process_flag := 'N';
1177: p_process_message := 'Threshold Setup does not exist. Hence no Tax will be deducted/applicable';
1178: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1179: FND_LOG.STRING(G_LEVEL_STATEMENT,
1180: G_MODULE_NAME || l_api_name,
1181: 'Threshold Setup does not exist for Vendor Type ' ||
1182: lv_vendor_type ||
1183: ' and Section Code ' ||

Line 1217: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '1@ln_thr_slab_id_old: '||ln_thr_slab_id_old);

1213: fetch c_get_thr_slab_id into ln_thr_slab_id_old;
1214: close c_get_thr_slab_id;
1215:
1216: -- added by zhiwei.xin for bug 13745243 on 01-MAR-2012 end.
1217: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '1@ln_thr_slab_id_old: '||ln_thr_slab_id_old);
1218: Commented out by Chong for bug#15939571 20121213 End*/
1219:
1220: UPDATE JAI_AP_TDS_DEFAULT
1221: SET CUMULATIVE_AMT = CUMULATIVE_AMT + NVL(ln_effective_amount,0)

Line 1225: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name,

1221: SET CUMULATIVE_AMT = CUMULATIVE_AMT + NVL(ln_effective_amount,0)
1222: WHERE TDS_SECTION_CODE = disnt_sec_code_rec.TDS_SECTION_CODE
1223: AND INVOICE_ID = p_inv_id;
1224:
1225: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name,
1226: 'Processing Section: '||disnt_sec_code_rec.TDS_SECTION_CODE || ' Header ID:' || ln_thr_header_id || ' Multi Rate:' || lv_multi_rate_flg);
1227:
1228: if lv_multi_rate_flg = 'Y' then
1229: --Added by Chong for bug#15939571 20121213 Start

Line 1234: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name,

1230: ----------------------------------------------------------------------
1231: FOR get_grp_sec_act_rec IN c_get_grp_sec_act(disnt_sec_code_rec.TDS_SECTION_CODE)
1232: LOOP
1233:
1234: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name,
1235: 'Processing Natural Account: '||get_grp_sec_act_rec.natural_account_value || ' Ac Date:' || get_grp_sec_act_rec.accounting_date);
1236:
1237: open c_check_effective_date(cp_legal_entity_id => ln_legal_entity_id
1238: ,cp_tds_section_code => disnt_sec_code_rec.tds_section_code

Line 1257: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on 1@ln_thr_slab_id_old: '||ln_thr_slab_id_old);

1253: ,get_grp_sec_act_rec.natural_account_value
1254: ,get_grp_sec_act_rec.accounting_date);
1255: fetch c_get_thr_slab_id_mul into ln_thr_slab_id_old;
1256: close c_get_thr_slab_id_mul;
1257: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on 1@ln_thr_slab_id_old: '||ln_thr_slab_id_old);
1258: ----------------------------------------------------------------------
1259: --Added by Chong for bug#15939571 20121213 End
1260:
1261: -- added by zhiwei.xin for bug 13745243 on 01-MAR-2012 begin

Line 1275: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on 2@ln_thr_slab_id_new: '||ln_thr_slab_id_new);

1271: );
1272: --Added ln_legal_entity_id ,disnt_sec_code_rec.tds_section_code by Chong for Bug#13802244 2012/09/21
1273: fetch c_get_thr_slab_id_mul into ln_thr_slab_id_new;
1274: close c_get_thr_slab_id_mul;
1275: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on 2@ln_thr_slab_id_new: '||ln_thr_slab_id_new);
1276:
1277: if nvl(ln_thr_slab_id_new,0) = 0 then
1278: open c_get_thr_slab_id_mul(ln_thr_header_id
1279: , 'SINGLE'

Line 1294: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on 3@ln_thr_slab_id_new: '||ln_thr_slab_id_new);

1290: close c_get_thr_slab_id_mul;
1291: end if;
1292:
1293: -- added by zhiwei.xin for bug 13745243 on 01-MAR-2012 end.
1294: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on 3@ln_thr_slab_id_new: '||ln_thr_slab_id_new);
1295: for thrd_details_rec IN c_thrd_details(ln_thr_header_id
1296: ,ln_org_id
1297: ,ln_thr_slab_id_new --Added by Chong for bug#16274617
1298: )

Line 1308: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Mult on4@Tax end date issue in tax category: '||thrd_details_rec.TAX_CATEGORY_ID);

1304: fetch c_check_taxes_end_date into lv_end_date_check;
1305: close c_check_taxes_end_date;
1306:
1307: if (NVL(lv_end_date_check, '0') = '1') then
1308: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Mult on4@Tax end date issue in tax category: '||thrd_details_rec.TAX_CATEGORY_ID);
1309: return;
1310: end if;
1311:
1312: UPDATE JAI_AP_TDS_DEFAULT

Line 1367: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on 5@ln_tax_ctg_id: '||ln_tax_ctg_id);

1363: open c_tax_category_id(ln_thr_slab_id_new, ln_org_id);
1364: fetch c_tax_category_id into ln_tax_ctg_id;
1365: close c_tax_category_id;
1366:
1367: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on 5@ln_tax_ctg_id: '||ln_tax_ctg_id);
1368:
1369: UPDATE JAI_AP_TDS_DEFAULT
1370: SET TAX_CATEGORY_ID = ln_tax_ctg_id
1371: WHERE INVOICE_ID = p_inv_id

Line 1381: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on/eff off 1@ln_thr_slab_id_old: '||ln_thr_slab_id_old);

1377: else
1378: open c_get_thr_slab_id (ln_thr_header_id, 'CUMULATIVE', ln_effective_amount, ld_max_date, ld_min_date);
1379: fetch c_get_thr_slab_id into ln_thr_slab_id_old;
1380: close c_get_thr_slab_id;
1381: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on/eff off 1@ln_thr_slab_id_old: '||ln_thr_slab_id_old);
1382:
1383: open c_get_thr_slab_id (ln_thr_header_id, 'CUMULATIVE', ln_effective_amount + disnt_sec_code_rec.SEC_AMOUNT, ld_max_date, ld_min_date);
1384: fetch c_get_thr_slab_id into ln_thr_slab_id_new;
1385: close c_get_thr_slab_id;

Line 1393: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on/eff off 2@ln_thr_slab_id_new: '||ln_thr_slab_id_new);

1389: fetch c_get_thr_slab_id into ln_thr_slab_id_new;
1390: close c_get_thr_slab_id;
1391: end if;
1392:
1393: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on/eff off 2@ln_thr_slab_id_new: '||ln_thr_slab_id_new);
1394:
1395: for thrd_details_rec IN c_thrd_details(ln_thr_header_id
1396: ,ln_org_id
1397: ,ln_thr_slab_id_new --Added by Chong for bug#16274617

Line 1409: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on/eff off 3@Tax end date issue in tax category: '||thrd_details_rec.TAX_CATEGORY_ID);

1405: fetch c_check_taxes_end_date into lv_end_date_check;
1406: close c_check_taxes_end_date;
1407:
1408: if (NVL(lv_end_date_check, '0') = '1') then
1409: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on/eff off 3@Tax end date issue in tax category: '||thrd_details_rec.TAX_CATEGORY_ID);
1410: return;
1411: end if;
1412: UPDATE JAI_AP_TDS_DEFAULT
1413: SET TAX_CATEGORY_ID = thrd_details_rec.TAX_CATEGORY_ID

Line 1440: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on/eff off 4@ln_tax_ctg_id: '||ln_tax_ctg_id);

1436: open c_tax_category_id(ln_thr_slab_id_new, ln_org_id);
1437: fetch c_tax_category_id into ln_tax_ctg_id;
1438: close c_tax_category_id;
1439:
1440: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi on/eff off 4@ln_tax_ctg_id: '||ln_tax_ctg_id);
1441:
1442: UPDATE JAI_AP_TDS_DEFAULT
1443: SET TAX_CATEGORY_ID = ln_tax_ctg_id
1444: WHERE INVOICE_ID = p_inv_id

Line 1463: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi off 1@ln_thr_slab_id_old: '||ln_thr_slab_id_old);

1459: ----------------------------------------------------------------------
1460: open c_get_thr_slab_id (ln_thr_header_id, 'CUMULATIVE', ln_effective_amount, ld_max_date, ld_min_date);
1461: fetch c_get_thr_slab_id into ln_thr_slab_id_old;
1462: close c_get_thr_slab_id;
1463: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi off 1@ln_thr_slab_id_old: '||ln_thr_slab_id_old);
1464: ----------------------------------------------------------------------
1465: --Added by Chong for bug#15939571 20121213 End
1466: -- added by zhiwei.xin for bug 13745243 on 01-MAR-2012 begin
1467: open c_get_thr_slab_id (ln_thr_header_id, 'CUMULATIVE', ln_effective_amount + disnt_sec_code_rec.SEC_AMOUNT, ld_max_date, ld_min_date);

Line 1478: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi off @2ln_thr_slab_id_new: '||ln_thr_slab_id_new);

1474: fetch c_get_thr_slab_id into ln_thr_slab_id_new;
1475: close c_get_thr_slab_id;
1476: end if;
1477: -- added by zhiwei.xin for bug 13745243 on 01-MAR-2012 end.
1478: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'multi off @2ln_thr_slab_id_new: '||ln_thr_slab_id_new);
1479:
1480: for thrd_details_rec IN c_thrd_details(ln_thr_header_id
1481: ,ln_org_id
1482: ,ln_thr_slab_id_new --Added by Chong for bug#16274617

Line 1502: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Mult off3@Tax end date issue in tax category: '||thrd_details_rec.TAX_CATEGORY_ID);

1498: close c_check_taxes_end_date;
1499: if (NVL(lv_end_date_check, '0') = '1') or (NVL(lv_end_date_check2, '0') = '1') then
1500: -------------------------------------------------------------------
1501: --if (NVL(lv_end_date_check, '0') = '1') then --Commented by Chong for bug#16274617
1502: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Mult off3@Tax end date issue in tax category: '||thrd_details_rec.TAX_CATEGORY_ID);
1503: return;
1504: end if;
1505: UPDATE JAI_AP_TDS_DEFAULT
1506: SET TAX_CATEGORY_ID = thrd_details_rec.TAX_CATEGORY_ID

Line 1531: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Mult off4@ln_tax_ctg_id: '||ln_tax_ctg_id);

1527: open c_tax_category_id(ln_thr_slab_id_new, ln_org_id);
1528: fetch c_tax_category_id into ln_tax_ctg_id;
1529: close c_tax_category_id;
1530:
1531: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Mult off4@ln_tax_ctg_id: '||ln_tax_ctg_id);
1532:
1533: UPDATE JAI_AP_TDS_DEFAULT
1534: SET TAX_CATEGORY_ID = ln_tax_ctg_id
1535: WHERE INVOICE_ID = p_inv_id

Line 1675: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'NO PAN 2@Tax end date issue in tax category: '||ln_tax_ctg_id);

1671: fetch c_check_taxes_end_date into lv_end_date_check2;
1672: close c_check_taxes_end_date;
1673:
1674: if (NVL(lv_end_date_check, '0') = '1') or (NVL(lv_end_date_check2, '0') = '1')then
1675: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'NO PAN 2@Tax end date issue in tax category: '||ln_tax_ctg_id);
1676: return;
1677: end if;
1678: -----------------------------------------------------------------------------
1679: --Added by Chong for bug#16274617 End

Line 1685: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'NO PAN 2@ln_tax_ctg_id: '||ln_tax_ctg_id);

1681: UPDATE JAI_AP_TDS_DEFAULT
1682: SET TAX_CATEGORY_ID = ln_tax_ctg_id
1683: WHERE INVOICE_ID = p_inv_id;
1684:
1685: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'NO PAN 2@ln_tax_ctg_id: '||ln_tax_ctg_id);
1686: else
1687:
1688: -- added by zhiwei.xin for bug 13792748 on 08-Mar-2012 end.
1689:

Line 1733: FND_LOG.STRING(G_LEVEL_STATEMENT,

1729: if ln_thr_header_id is NULL then
1730: p_process_flag := 'N';
1731: p_process_message := 'Threshold Setup does not exist. Hence no Tax will be deducted/applicable';
1732: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1733: FND_LOG.STRING(G_LEVEL_STATEMENT,
1734: G_MODULE_NAME || l_api_name,
1735: 'Threshold Setup does not exist for Vendor Type ' ||
1736: lv_vendor_type ||
1737: ' and Section Code ' ||

Line 1808: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Vendor site default @Tax end date issue in tax category: '||thrd_details_rec.TAX_CATEGORY_ID);

1804: if (NVL(lv_end_date_check, '0') = '1') or (NVL(lv_end_date_check2, '0') = '1') then
1805: --------------------------------------------------------------------
1806: --Added by Chong for bug#16274617 end
1807: --if (NVL(lv_end_date_check, '0') = '1') then --Comment by Chong for bug#16274617
1808: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Vendor site default @Tax end date issue in tax category: '||thrd_details_rec.TAX_CATEGORY_ID);
1809: return;
1810: end if;
1811:
1812: UPDATE JAI_AP_TDS_DEFAULT

Line 2151: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');

2147: end if;
2148: end if; -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012
2149: end loop;
2150: end if; -- p_redefault_tax_category = 'Y'
2151: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
2152: exception
2153: when others then
2154: p_process_flag := 'E';
2155: P_process_message := 'Error from default_tds_from_setup :' || sqlerrm;

Line 2156: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.exception', P_process_message);

2152: exception
2153: when others then
2154: p_process_flag := 'E';
2155: P_process_message := 'Error from default_tds_from_setup :' || sqlerrm;
2156: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.exception', P_process_message);
2157: return;
2158:
2159: end default_tds_from_setup;
2160: