374:
375: exception
376: when others then
377: if g_fnd_debug = 'Y' then
378: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
379: FND_LOG.string(FND_LOG.level_unexpected, 'icx.plsql.PO_AME_SETUP_PVT' ||
380: l_api_name || '.others_exception', sqlerrm);
381: END IF;
382: end if;
375: exception
376: when others then
377: if g_fnd_debug = 'Y' then
378: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
379: FND_LOG.string(FND_LOG.level_unexpected, 'icx.plsql.PO_AME_SETUP_PVT' ||
380: l_api_name || '.others_exception', sqlerrm);
381: END IF;
382: end if;
383: raise;
412:
413: l_option_value:= fnd_profile.VALUE_SPECIFIC('POR_SYS_GENERATED_APPROVERS_SUPPRESS');
414:
415: if g_fnd_debug = 'Y' then
416: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
417: FND_LOG.string(FND_LOG.level_statement, 'icx.plsql.PO_AME_SETUP_PVT.is_system_approver_mandatory','suppress l_option_value=' ||
418: l_option_value );
419: END IF;
420: END IF;
413: l_option_value:= fnd_profile.VALUE_SPECIFIC('POR_SYS_GENERATED_APPROVERS_SUPPRESS');
414:
415: if g_fnd_debug = 'Y' then
416: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
417: FND_LOG.string(FND_LOG.level_statement, 'icx.plsql.PO_AME_SETUP_PVT.is_system_approver_mandatory','suppress l_option_value=' ||
418: l_option_value );
419: END IF;
420: END IF;
421:
432: EXCEPTION
433: when others then
434: fnd_profile.get('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_option_value);
435: if g_fnd_debug = 'Y' then
436: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
437: FND_LOG.string(FND_LOG.level_statement, 'icx.plsql.PO_AME_SETUP_PVT.is_system_approver_mandatory',' l_option_value=' ||
438: l_option_value );
439: END IF;
440: END IF;
433: when others then
434: fnd_profile.get('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_option_value);
435: if g_fnd_debug = 'Y' then
436: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
437: FND_LOG.string(FND_LOG.level_statement, 'icx.plsql.PO_AME_SETUP_PVT.is_system_approver_mandatory',' l_option_value=' ||
438: l_option_value );
439: END IF;
440: END IF;
441:
443:
444: END;
445: l_option_value := fnd_profile.value_specific('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_user_id);
446: if g_fnd_debug = 'Y' then
447: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
448: FND_LOG.string(FND_LOG.level_statement, '2 icx.plsql.PO_AME_SETUP_PVT.is_system_approver_mandatory',' l_option_value=' ||
449: l_option_value );
450: END IF;
451: END IF;
444: END;
445: l_option_value := fnd_profile.value_specific('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_user_id);
446: if g_fnd_debug = 'Y' then
447: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
448: FND_LOG.string(FND_LOG.level_statement, '2 icx.plsql.PO_AME_SETUP_PVT.is_system_approver_mandatory',' l_option_value=' ||
449: l_option_value );
450: END IF;
451: END IF;
452: RETURN l_option_value;