DBA Data[Home] [Help]

APPS.JAI_PO_HOOK_PKG dependencies on FND_LOG

Line 2303: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2299: lv_cancel_flag VARCHAR2(1);
2300: lv_func_currency VARCHAR2(15);
2301: ln_org_id NUMBER;
2302: lv_procedure_name VARCHAR2(40):='Get_InAndEx_Tax_Total';
2303: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2304: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2305: BEGIN
2306: --logging for debug
2307: IF (ln_proc_level >= ln_dbg_level)

Line 2304: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

2300: lv_func_currency VARCHAR2(15);
2301: ln_org_id NUMBER;
2302: lv_procedure_name VARCHAR2(40):='Get_InAndEx_Tax_Total';
2303: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2304: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2305: BEGIN
2306: --logging for debug
2307: IF (ln_proc_level >= ln_dbg_level)
2308: THEN

Line 2309: FND_LOG.STRING( ln_proc_level

2305: BEGIN
2306: --logging for debug
2307: IF (ln_proc_level >= ln_dbg_level)
2308: THEN
2309: FND_LOG.STRING( ln_proc_level
2310: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2311: , 'Enter function'
2312: );
2313: END IF; --l_proc_level>=l_dbg_level

Line 2553: FND_LOG.STRING( ln_proc_level

2549:
2550: --logging for debug
2551: IF (ln_proc_level >= ln_dbg_level)
2552: THEN
2553: FND_LOG.STRING( ln_proc_level
2554: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2555: , 'Exit function'
2556: );
2557: END IF; --l_proc_level>=l_dbg_level

Line 2562: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2558:
2559: RETURN ln_tax_amt;
2560: EXCEPTION
2561: WHEN OTHERS THEN
2562: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2563: THEN
2564: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2565: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2566: , Sqlcode||Sqlerrm);

Line 2564: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

2560: EXCEPTION
2561: WHEN OTHERS THEN
2562: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2563: THEN
2564: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2565: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2566: , Sqlcode||Sqlerrm);
2567: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2568: RETURN (-1);

Line 2567: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2563: THEN
2564: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2565: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2566: , Sqlcode||Sqlerrm);
2567: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2568: RETURN (-1);
2569: END Get_InAndEx_Tax_Total;
2570:
2571: --==========================================================================

Line 2745: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2741: lv_cancel_flag VARCHAR2(1);
2742: lv_func_currency VARCHAR2(15);
2743: ln_org_id NUMBER;
2744: lv_procedure_name VARCHAR2(40):='Get_InAndEx_Tax_Total';
2745: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2746: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2747: BEGIN
2748: --logging for debug
2749: IF (ln_proc_level >= ln_dbg_level)

Line 2746: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

2742: lv_func_currency VARCHAR2(15);
2743: ln_org_id NUMBER;
2744: lv_procedure_name VARCHAR2(40):='Get_InAndEx_Tax_Total';
2745: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2746: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2747: BEGIN
2748: --logging for debug
2749: IF (ln_proc_level >= ln_dbg_level)
2750: THEN

Line 2751: FND_LOG.STRING( ln_proc_level

2747: BEGIN
2748: --logging for debug
2749: IF (ln_proc_level >= ln_dbg_level)
2750: THEN
2751: FND_LOG.STRING( ln_proc_level
2752: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2753: , 'Enter function'
2754: );
2755: END IF; --l_proc_level>=l_dbg_level

Line 2996: FND_LOG.STRING( ln_proc_level

2992:
2993: --logging for debug
2994: IF (ln_proc_level >= ln_dbg_level)
2995: THEN
2996: FND_LOG.STRING( ln_proc_level
2997: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2998: , 'Exit function'
2999: );
3000: END IF; --l_proc_level>=l_dbg_level

Line 3005: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3001:
3002: RETURN ln_tax_amt;
3003: EXCEPTION
3004: WHEN OTHERS THEN
3005: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3006: THEN
3007: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3008: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3009: , Sqlcode||Sqlerrm);

Line 3007: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

3003: EXCEPTION
3004: WHEN OTHERS THEN
3005: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3006: THEN
3007: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3008: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3009: , Sqlcode||Sqlerrm);
3010: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3011: RETURN (-1);

Line 3010: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3006: THEN
3007: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3008: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3009: , Sqlcode||Sqlerrm);
3010: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3011: RETURN (-1);
3012: END Get_Isp_InAndEx_Tax_Total;
3013:
3014: END JAI_PO_HOOK_PKG;