APPS.MSC_E1APS_DSMCOLL dependencies on FND_PROFILE

Line 92: WSURL := fnd_profile.value('MSC_E1APS_ODIURL');

88: RETURN;
89: END IF;
90:
91: /* Checking ODI Profile*/
92: WSURL := fnd_profile.value('MSC_E1APS_ODIURL');
93: IF WSURL IS NOT NULL THEN
94: /* Launching Pre-Process Custom Hook ODI Scenario */
95: select instance_code into l_instance_code
96: from msc_apps_instances

Line 127: WSURL:= fnd_profile.value('MSC_E1APS_ODIURL');

123: 'COMP_PTP',
124: 1,
125: 'user_id'));
126: /*Initialize ODI*/
127: WSURL:= fnd_profile.value('MSC_E1APS_ODIURL');
128: IF WSURL IS NOT NULL THEN
129: BEGIN
130: MSC_UTIL.MSC_DEBUG('INITIALIZING ODI ....');
131: select MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(WSURL,2) into ReturnStr from dual;

Line 159: fc_url := fnd_profile.value('MSC_E1APS_FCURL');

155: IF parLoadPayCnf = MSC_UTIL.SYS_YES THEN
156:
157: ODILaunchFlag := MSC_E1APS_ODIExecute('LOADE1APCONFIRMDATATODMPKG',WSURL);
158:
159: fc_url := fnd_profile.value('MSC_E1APS_FCURL');
160: fc_ret_value:=TRUE;
161: if fc_url is not null and ODILaunchFlag then
162: fc_ret_value := MSC_E1APS_ODIExecute('IMPORTFILESTODEMANTRASERVER',fc_url);
163: if fc_ret_value = FALSE then

Line 206: fc_url := fnd_profile.value('MSC_E1APS_FCURL');

202: IF parLoadDed = MSC_UTIL.SYS_YES THEN
203:
204: ODILaunchFlag := MSC_E1APS_ODIExecute('LOADE1DEDUCTIONSDATATODMPKG',WSURL);
205:
206: fc_url := fnd_profile.value('MSC_E1APS_FCURL');
207: fc_ret_value:=TRUE;
208: if fc_url is not null and ODILaunchFlag then
209: fc_ret_value := MSC_E1APS_ODIExecute('IMPORTFILESTODEMANTRASERVER',fc_url);
210: if fc_ret_value = FALSE then