APPS.LNS_APPROVAL_ACTION_PUB dependencies on FND_PROFILE

Line 11: -- G_AF_DO_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

7: G_DEBUG_COUNT NUMBER := 0;
8: G_DEBUG BOOLEAN := FALSE;
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'LNS_APPROVAL_ACTION_PUB';
11: -- G_AF_DO_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
12: g_last_all_statements CLOB;
13:
14: --------------------------------------------------
15: -- declaration of private procedures and functions

Line 2077: l_is_ame_profile_set fnd_profile_option_values.profile_option_value%TYPE;

2073: +-----------------------------------------------------------------------*/
2074:
2075: l_api_name CONSTANT VARCHAR2(30) := 'IS_AME_ENABLED';
2076: l_result VARCHAR2(1);
2077: l_is_ame_profile_set fnd_profile_option_values.profile_option_value%TYPE;
2078: l_next_approver ame_util.approversTable2;
2079: l_approval_complete VARCHAR2(20);
2080: l_next_approver_name VARCHAR2(50);
2081: l_transaction_type VARCHAR2(30);

Line 2088: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');

2084:
2085:
2086: BEGIN
2087: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
2088: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2089: l_result := 'N';
2090:
2091:
2092:

Line 2098: l_is_ame_profile_set := fnd_profile.value('AME_INSTALLED_FLAG');

2094: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
2095: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);
2096: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOGGED_IN_USER_NAME: ' || P_LOGGED_IN_USER_NAME);
2097:
2098: l_is_ame_profile_set := fnd_profile.value('AME_INSTALLED_FLAG');
2099: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Is AME_INSTALLED_FLAG set : ' || l_is_ame_profile_set);
2100:
2101: --The below api wont work for us as it gets the next non-notified approver.
2102: /* ame_api2.getNextApprovers4(