DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on FND_PROFILE

Line 3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');

1: PACKAGE BODY gme_common_pvt AS
2: /* $Header: GMEVCMNB.pls 120.36.12010000.2 2008/11/06 03:10:18 srpuri ship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_COMMON_PVT';
5:
6: /*************************************************************************************************/
7: /* Oracle Process Manufacturing Process Execution APIs */

Line 228: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID') );

224: IF (gme_common_pvt.g_setup_done) THEN
225: RETURN TRUE;
226: END IF;
227:
228: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID') );
229: gme_common_pvt.g_user_ident :=
230: TO_NUMBER (fnd_profile.VALUE ('USER_ID') );
231:
232: OPEN cur_get_user (gme_common_pvt.g_user_ident);

Line 230: TO_NUMBER (fnd_profile.VALUE ('USER_ID') );

226: END IF;
227:
228: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID') );
229: gme_common_pvt.g_user_ident :=
230: TO_NUMBER (fnd_profile.VALUE ('USER_ID') );
231:
232: OPEN cur_get_user (gme_common_pvt.g_user_ident);
233:
234: FETCH cur_get_user

Line 362: fnd_profile.VALUE ('BOM:HOUR_UOM_CODE');

358: l_cur_get_org_params.fpo_no_last_assigned;
359: gme_common_pvt.g_rule_based_resv_horizon :=
360: l_cur_get_org_params.rule_based_resv_horizon;
361: gme_common_pvt.g_hour_uom_code :=
362: fnd_profile.VALUE ('BOM:HOUR_UOM_CODE');
363:
364: IF g_debug <= gme_debug.g_log_procedure THEN
365: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
366: END IF;

Line 422: gme_common_pvt.g_user_ident := fnd_profile.VALUE ('USER_ID');

418: PROCEDURE set_who
419: IS
420: l_api_name CONSTANT VARCHAR2 (30) := 'set_who';
421: BEGIN
422: gme_common_pvt.g_user_ident := fnd_profile.VALUE ('USER_ID');
423: gme_common_pvt.g_login_id := fnd_profile.VALUE ('LOGIN_ID');
424: gme_common_pvt.set_timestamp;
425: EXCEPTION
426: WHEN OTHERS THEN

Line 423: gme_common_pvt.g_login_id := fnd_profile.VALUE ('LOGIN_ID');

419: IS
420: l_api_name CONSTANT VARCHAR2 (30) := 'set_who';
421: BEGIN
422: gme_common_pvt.g_user_ident := fnd_profile.VALUE ('USER_ID');
423: gme_common_pvt.g_login_id := fnd_profile.VALUE ('LOGIN_ID');
424: gme_common_pvt.set_timestamp;
425: EXCEPTION
426: WHEN OTHERS THEN
427: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);