APPS.JAI_AVLIST_VALIDATE_PKG dependencies on FND_LOG

Line 202: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

198: ln_category_count NUMBER; /* Added for bug 10103931 */
199: le_multi_row EXCEPTION;
200:
201: lv_procedure_name VARCHAR2(40) := 'Check_AvList_Validation';
202: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
203: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
204:
205: BEGIN
206: --logging for debug

Line 203: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

199: le_multi_row EXCEPTION;
200:
201: lv_procedure_name VARCHAR2(40) := 'Check_AvList_Validation';
202: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
203: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
204:
205: BEGIN
206: --logging for debug
207: IF (ln_proc_level >= ln_dbg_level)

Line 209: FND_LOG.STRING( ln_proc_level

205: BEGIN
206: --logging for debug
207: IF (ln_proc_level >= ln_dbg_level)
208: THEN
209: FND_LOG.STRING( ln_proc_level
210: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Begin'
211: , 'Enter Procedure'
212: );
213: END IF; --l_proc_level>=l_dbg_level

Line 348: FND_LOG.STRING( ln_proc_level

344:
345: --logging for debug
346: IF (ln_proc_level >= ln_dbg_level)
347: THEN
348: FND_LOG.STRING( ln_proc_level
349: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.End'
350: , 'Enter Procedure'
351: );
352: END IF; --l_proc_level>=l_dbg_level

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

352: END IF; --l_proc_level>=l_dbg_level
353:
354: EXCEPTION
355: WHEN le_multi_row THEN
356: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
357: THEN
358: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
359: , GV_MODULE_PREFIX ||'.' || lv_procedure_name
360: || '.Multi_Exception '

Line 358: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

354: EXCEPTION
355: WHEN le_multi_row THEN
356: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
357: THEN
358: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
359: , GV_MODULE_PREFIX ||'.' || lv_procedure_name
360: || '.Multi_Exception '
361: , SQLCODE||SQLERRM);
362: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

358: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
359: , GV_MODULE_PREFIX ||'.' || lv_procedure_name
360: || '.Multi_Exception '
361: , SQLCODE||SQLERRM);
362: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
363:
364: FND_MESSAGE.SET_NAME ('JA','JAI_AV_LIST_VALIDATION');
365: FND_MESSAGE.SET_TOKEN ('AV_LIST_NAME',lv_av_list_name);
366: app_exception.raise_exception;