65: APP_EXCEPTION.RAISE_EXCEPTION;
66: END;
67: END;
68:
69: function isCreditCardEnabled(p_employeeId in AP_WEB_DB_CCARD_PKG.cards_employeeID) return boolean
70: IS
71: l_has VARCHAR2(1);
72: l_cCardEnabled VARCHAR2(1);
73: l_FNDUserID AP_WEB_DB_HR_INT_PKG.fndUser_userID;
91: ELSE
92: FND_PROFILE.GET('SSE_ENABLE_CREDIT_CARD', l_cCardEnabled);
93: END IF;
94:
95: return (AP_WEB_DB_CCARD_PKG.UserHasCreditCard(p_employeeId, l_has) AND
96: l_has = 'Y' AND l_cCardEnabled = 'Y');
97: EXCEPTION
98: WHEN OTHERS THEN
99: BEGIN