APPS.MSD_DEM_EVENT dependencies on FND_PROFILE

Line 18: IF (fnd_profile.value ('MSD_DEM_DEBUG_MODE') = 'Y' OR 1=1)

14:
15: PROCEDURE log_debug (p_msg VARCHAR2)
16: IS
17: BEGIN
18: IF (fnd_profile.value ('MSD_DEM_DEBUG_MODE') = 'Y' OR 1=1)
19: THEN
20: RETURN;
21: END IF;
22:

Line 92: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');

88: BEGIN
89:
90: --Bug#7140524
91: /* Check if Demantra is installed before proceeding further */
92: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
93:
94: log_debug ('Schema: ' || x_schema);
95:
96: IF (x_schema IS NULL)

Line 876: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');

872: log ('Not a SOP User');
873: RETURN SUCCESS;
874: END IF;
875:
876: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
877:
878: /* Get the Sales and Operations Planning Component */
879: x_component_name := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID',
880: 'COMP_SOP',

Line 1111: WHERE NLS_LANGUAGE = FND_PROFILE.VALUE_SPECIFIC('ICX_LANGUAGE', p_ebs_user_id);

1107: /* Get the EBS user language */
1108: /* SELECT LANGUAGE_CODE
1109: INTO x_language
1110: FROM FND_LANGUAGES_VL
1111: WHERE NLS_LANGUAGE = FND_PROFILE.VALUE_SPECIFIC('ICX_LANGUAGE', p_ebs_user_id);
1112:
1113: EXECUTE IMMEDIATE 'select lang_id from ' || p_schema || '.languages where lang_code = :1'
1114: INTO x_dem_language_id USING x_language;
1115: