eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AME_SETUP_PVT dependencies on FND_PROFILE

Line 4: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: PACKAGE BODY PO_AME_SETUP_PVT AS
2: /* $Header: POXAMESB.pls 120.8.12020000.3 2013/02/10 23:53:43 vegajula ship $*/
3:
4: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: --------------------------------------------------------------------------------
7: --Start of Comments
8: --Name: get_function_currency

Line 70: l_rate_type fnd_profile_option_values.profile_option_value%TYPE;

66: -------------------------------------------------------------------------------
67: FUNCTION get_rate_type(reqHeaderId IN NUMBER)
68: RETURN VARCHAR2 IS
69: l_user_id fnd_user.user_id%TYPE;
70: l_rate_type fnd_profile_option_values.profile_option_value%TYPE;
71:
72: BEGIN
73: BEGIN
74: SELECT fu.user_id

Line 81: fnd_profile.get('POR_DEFAULT_RATE_TYPE', l_rate_type);

77: WHERE prh.requisition_header_id = reqHeaderId and
78: prh.preparer_id = fu.employee_id;
79: EXCEPTION
80: when others then
81: fnd_profile.get('POR_DEFAULT_RATE_TYPE', l_rate_type);
82: RETURN l_rate_type;
83: END;
84: l_rate_type := fnd_profile.value_specific('POR_DEFAULT_RATE_TYPE', l_user_id);
85: RETURN l_rate_type;

Line 84: l_rate_type := fnd_profile.value_specific('POR_DEFAULT_RATE_TYPE', l_user_id);

80: when others then
81: fnd_profile.get('POR_DEFAULT_RATE_TYPE', l_rate_type);
82: RETURN l_rate_type;
83: END;
84: l_rate_type := fnd_profile.value_specific('POR_DEFAULT_RATE_TYPE', l_user_id);
85: RETURN l_rate_type;
86: EXCEPTION
87: when others then
88: raise;

Line 410: l_option_value fnd_profile_option_values.profile_option_value%TYPE;

406: -------------------------------------------------------------------------------
407: FUNCTION is_system_approver_mandatory(reqHeaderId IN NUMBER)
408: RETURN VARCHAR2 IS
409: l_user_id fnd_user.user_id%TYPE;
410: l_option_value fnd_profile_option_values.profile_option_value%TYPE;
411: BEGIN
412:
413: l_option_value:= fnd_profile.VALUE_SPECIFIC('POR_SYS_GENERATED_APPROVERS_SUPPRESS');
414:

Line 413: l_option_value:= fnd_profile.VALUE_SPECIFIC('POR_SYS_GENERATED_APPROVERS_SUPPRESS');

409: l_user_id fnd_user.user_id%TYPE;
410: l_option_value fnd_profile_option_values.profile_option_value%TYPE;
411: BEGIN
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=' ||

Line 434: fnd_profile.get('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_option_value);

430: WHERE prh.requisition_header_id = reqHeaderId and
431: prh.preparer_id = fu.employee_id;
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 );

Line 445: l_option_value := fnd_profile.value_specific('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_user_id);

441:
442: RETURN l_option_value;
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 );

Line 569: l_option_value fnd_profile_option_values.profile_option_value%TYPE;

565: -------------------------------------------------------------------------------
566: FUNCTION is_system_app_mandatory_po(ameApprovalId IN NUMBER)
567: RETURN VARCHAR2 IS
568: l_user_id fnd_user.user_id%TYPE;
569: l_option_value fnd_profile_option_values.profile_option_value%TYPE;
570:
571: BEGIN
572:
573: -- AME Project

Line 574: l_option_value:= fnd_profile.VALUE_SPECIFIC('PO_SYS_GENERATED_APPROVERS_SUPPRESS');

570:
571: BEGIN
572:
573: -- AME Project
574: l_option_value:= fnd_profile.VALUE_SPECIFIC('PO_SYS_GENERATED_APPROVERS_SUPPRESS');
575:
576: if l_option_value = 'Y' then
577: RETURN 'N';
578: end if;

Line 588: fnd_profile.get('PO_SYS_GENERATED_APPROVERS_MANDATORY', l_option_value);

584: WHERE phm.ame_approval_id = ameApprovalId and
585: phm.agent_id = fu.employee_id;
586: EXCEPTION
587: when others then
588: fnd_profile.get('PO_SYS_GENERATED_APPROVERS_MANDATORY', l_option_value);
589: RETURN l_option_value;
590:
591: END;
592: l_option_value := fnd_profile.value_specific('PO_SYS_GENERATED_APPROVERS_MANDATORY', l_user_id);

Line 592: l_option_value := fnd_profile.value_specific('PO_SYS_GENERATED_APPROVERS_MANDATORY', l_user_id);

588: fnd_profile.get('PO_SYS_GENERATED_APPROVERS_MANDATORY', l_option_value);
589: RETURN l_option_value;
590:
591: END;
592: l_option_value := fnd_profile.value_specific('PO_SYS_GENERATED_APPROVERS_MANDATORY', l_user_id);
593:
594: RETURN l_option_value;
595:
596: EXCEPTION

Line 665: l_rate_type fnd_profile_option_values.profile_option_value%TYPE;

661: -------------------------------------------------------------------------------
662: FUNCTION get_rate_type_po(ameApprovalId IN NUMBER)
663: RETURN VARCHAR2 IS
664: l_user_id fnd_user.user_id%TYPE;
665: l_rate_type fnd_profile_option_values.profile_option_value%TYPE;
666:
667: BEGIN
668: BEGIN
669: SELECT fu.user_id

Line 676: fnd_profile.get('POR_DEFAULT_RATE_TYPE', l_rate_type);

672: WHERE phm.ame_approval_id = ameApprovalId and
673: phm.agent_id = fu.employee_id;
674: EXCEPTION
675: when others then
676: fnd_profile.get('POR_DEFAULT_RATE_TYPE', l_rate_type);
677: RETURN l_rate_type;
678: END;
679: l_rate_type := fnd_profile.value_specific('POR_DEFAULT_RATE_TYPE', l_user_id);
680: RETURN l_rate_type;

Line 679: l_rate_type := fnd_profile.value_specific('POR_DEFAULT_RATE_TYPE', l_user_id);

675: when others then
676: fnd_profile.get('POR_DEFAULT_RATE_TYPE', l_rate_type);
677: RETURN l_rate_type;
678: END;
679: l_rate_type := fnd_profile.value_specific('POR_DEFAULT_RATE_TYPE', l_user_id);
680: RETURN l_rate_type;
681: EXCEPTION
682: when others then
683: raise;