DBA Data[Home] [Help]

APPS.JAI_PO_HOOK_PKG dependencies on FND_LOG

Line 2505: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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)

Line 2506: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

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

Line 2511: FND_LOG.STRING( ln_proc_level

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

Line 2755: FND_LOG.STRING( ln_proc_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

Line 2764: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_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);

Line 2766: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

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);

Line 2769: END 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);
2771: END Get_InAndEx_Tax_Total;
2772:
2773: --==========================================================================

Line 2947: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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)

Line 2948: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

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

Line 2953: FND_LOG.STRING( ln_proc_level

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

Line 3198: FND_LOG.STRING( ln_proc_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

Line 3207: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_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);

Line 3209: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

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);

Line 3212: END 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);
3214: END Get_Isp_InAndEx_Tax_Total;
3215:
3216: END JAI_PO_HOOK_PKG;