2501: lv_cancel_flag VARCHAR2(1);
2502: lv_func_currency VARCHAR2(15);
2503: ln_org_id NUMBER;
2504: lv_procedure_name VARCHAR2(40):='Get_InAndEx_Tax_Total';
2505: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2506: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2507: BEGIN
2508: --logging for debug
2509: IF (ln_proc_level >= ln_dbg_level)
2502: lv_func_currency VARCHAR2(15);
2503: ln_org_id NUMBER;
2504: lv_procedure_name VARCHAR2(40):='Get_InAndEx_Tax_Total';
2505: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2506: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2507: BEGIN
2508: --logging for debug
2509: IF (ln_proc_level >= ln_dbg_level)
2510: THEN
2507: BEGIN
2508: --logging for debug
2509: IF (ln_proc_level >= ln_dbg_level)
2510: THEN
2511: FND_LOG.STRING( ln_proc_level
2512: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2513: , 'Enter function'
2514: );
2515: END IF; --l_proc_level>=l_dbg_level
2751:
2752: --logging for debug
2753: IF (ln_proc_level >= ln_dbg_level)
2754: THEN
2755: FND_LOG.STRING( ln_proc_level
2756: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2757: , 'Exit function'
2758: );
2759: END IF; --l_proc_level>=l_dbg_level
2760:
2761: RETURN ln_tax_amt;
2762: EXCEPTION
2763: WHEN OTHERS THEN
2764: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2765: THEN
2766: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2767: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2768: , Sqlcode||Sqlerrm);
2762: EXCEPTION
2763: WHEN OTHERS THEN
2764: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2765: THEN
2766: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2767: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2768: , Sqlcode||Sqlerrm);
2769: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2770: RETURN (-1);
2765: THEN
2766: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2767: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2768: , Sqlcode||Sqlerrm);
2769: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2770: RETURN (-1);
2771: END Get_InAndEx_Tax_Total;
2772:
2773: --==========================================================================
2943: lv_cancel_flag VARCHAR2(1);
2944: lv_func_currency VARCHAR2(15);
2945: ln_org_id NUMBER;
2946: lv_procedure_name VARCHAR2(40):='Get_InAndEx_Tax_Total';
2947: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2948: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2949: BEGIN
2950: --logging for debug
2951: IF (ln_proc_level >= ln_dbg_level)
2944: lv_func_currency VARCHAR2(15);
2945: ln_org_id NUMBER;
2946: lv_procedure_name VARCHAR2(40):='Get_InAndEx_Tax_Total';
2947: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2948: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2949: BEGIN
2950: --logging for debug
2951: IF (ln_proc_level >= ln_dbg_level)
2952: THEN
2949: BEGIN
2950: --logging for debug
2951: IF (ln_proc_level >= ln_dbg_level)
2952: THEN
2953: FND_LOG.STRING( ln_proc_level
2954: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2955: , 'Enter function'
2956: );
2957: END IF; --l_proc_level>=l_dbg_level
3194:
3195: --logging for debug
3196: IF (ln_proc_level >= ln_dbg_level)
3197: THEN
3198: FND_LOG.STRING( ln_proc_level
3199: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
3200: , 'Exit function'
3201: );
3202: END IF; --l_proc_level>=l_dbg_level
3203:
3204: RETURN ln_tax_amt;
3205: EXCEPTION
3206: WHEN OTHERS THEN
3207: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3208: THEN
3209: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3210: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3211: , Sqlcode||Sqlerrm);
3205: EXCEPTION
3206: WHEN OTHERS THEN
3207: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3208: THEN
3209: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3210: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3211: , Sqlcode||Sqlerrm);
3212: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3213: RETURN (-1);
3208: THEN
3209: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3210: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3211: , Sqlcode||Sqlerrm);
3212: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3213: RETURN (-1);
3214: END Get_Isp_InAndEx_Tax_Total;
3215:
3216: END JAI_PO_HOOK_PKG;