APPS.PN_LEASE_PUB dependencies on FND_PROFILE

Line 11: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');--NVL(PN_MO_CACHE_UTILS.get_current_org_id,fnd_profile.VALUE ('org_id'));

7: g_resp_appl_id CONSTANT NUMBER := fnd_global.resp_appl_id;
8: g_resp_id CONSTANT NUMBER := fnd_global.resp_appl_id;
9: g_user_id CONSTANT NUMBER := fnd_global.user_id;
10: g_login_id CONSTANT NUMBER := fnd_global.login_id;
11: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');--NVL(PN_MO_CACHE_UTILS.get_current_org_id,fnd_profile.VALUE ('org_id'));
12:
13: -- Procedure to create a new lease
14: PROCEDURE create_lease (
15: p_api_version IN NUMBER

Line 413: l_debug_mode := NVL (fnd_profile.VALUE ('PN_DEBUG_MODE'), 'N');

409: l_debug_mode VARCHAR2 (1);
410: BEGIN
411: -- Standard start of API savepoint
412: --SAVEPOINT update_lease_pub;
413: l_debug_mode := NVL (fnd_profile.VALUE ('PN_DEBUG_MODE'), 'N');
414: ------dbms_output.put_line ( 'In Public:p_lease_rec.lease_id'|| p_lease_rec.lease_id); --Rupak
415:
416: --test_lease(1,'In Public');
417: --test_lease(1,'In Public-01:'||p_lease_rec.lease_id);

Line 580: l_debug_mode := NVL (fnd_profile.VALUE ('PN_DEBUG_MODE'), 'N');

576: l_msg_count NUMBER;
577: l_msg_data VARCHAR2 (2000);
578: l_debug_mode VARCHAR2 (1);
579: BEGIN
580: l_debug_mode := NVL (fnd_profile.VALUE ('PN_DEBUG_MODE'), 'N');
581: IF fnd_api.to_boolean (p_init_msg_list)
582: THEN
583: fnd_msg_pub.initialize;
584: END IF;

Line 687: l_debug_mode := NVL (fnd_profile.VALUE ('PN_DEBUG_MODE'), 'N');

683: l_msg_count NUMBER;
684: l_msg_data VARCHAR2 (2000);
685: l_debug_mode VARCHAR2 (1);
686: BEGIN
687: l_debug_mode := NVL (fnd_profile.VALUE ('PN_DEBUG_MODE'), 'N');
688: IF fnd_api.to_boolean (p_init_msg_list)
689: THEN
690: fnd_msg_pub.initialize;
691: END IF;