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.61.12020000.4 2012/11/28 15:35:54 adeshmuk 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 318: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID') );

314: RETURN TRUE;
315: END IF;
316: END IF;
317:
318: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID') );
319: gme_common_pvt.g_user_ident :=
320: TO_NUMBER (fnd_profile.VALUE ('USER_ID') );
321:
322: OPEN cur_get_user (gme_common_pvt.g_user_ident);

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

316: END IF;
317:
318: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID') );
319: gme_common_pvt.g_user_ident :=
320: TO_NUMBER (fnd_profile.VALUE ('USER_ID') );
321:
322: OPEN cur_get_user (gme_common_pvt.g_user_ident);
323:
324: FETCH cur_get_user

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

448: l_cur_get_org_params.fpo_no_last_assigned;
449: gme_common_pvt.g_rule_based_resv_horizon :=
450: l_cur_get_org_params.rule_based_resv_horizon;
451: gme_common_pvt.g_hour_uom_code :=
452: fnd_profile.VALUE ('BOM:HOUR_UOM_CODE');
453:
454: IF g_debug <= gme_debug.g_log_procedure THEN
455: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
456: END IF;

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

508: PROCEDURE set_who
509: IS
510: l_api_name CONSTANT VARCHAR2 (30) := 'set_who';
511: BEGIN
512: gme_common_pvt.g_user_ident := fnd_profile.VALUE ('USER_ID');
513: gme_common_pvt.g_login_id := fnd_profile.VALUE ('LOGIN_ID');
514: gme_common_pvt.set_timestamp;
515: EXCEPTION
516: WHEN OTHERS THEN

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

509: IS
510: l_api_name CONSTANT VARCHAR2 (30) := 'set_who';
511: BEGIN
512: gme_common_pvt.g_user_ident := fnd_profile.VALUE ('USER_ID');
513: gme_common_pvt.g_login_id := fnd_profile.VALUE ('LOGIN_ID');
514: gme_common_pvt.set_timestamp;
515: EXCEPTION
516: WHEN OTHERS THEN
517: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);