APPS.MSC_E1APS_DSMCOLL dependencies on MSC_E1APS_UTIL

Line 31: select MSC_E1APS_UTIL.MSC_E1APS_ODIScenarioExecute(scrName,'001','',WSURL) into ReturnStr from dual;

27:
28: IF WSURL IS NOT NULL THEN
29: begin
30: /* Execute ODI scenarios */
31: select MSC_E1APS_UTIL.MSC_E1APS_ODIScenarioExecute(scrName,'001','',WSURL) into ReturnStr from dual;
32: EXCEPTION
33: WHEN OTHERS THEN
34: select instr(ReturnStr,'#') into StartIndex from dual;
35: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;

Line 105: || MSC_E1APS_UTIL.COL_DSM_DATA;

101: scenario_param := 'E1TOAPSPROJECT.PVV_PRE_PROCESS_VAR=';
102: scenario_param := scenario_param
103: ||l_instance_code
104: || ':'
105: || MSC_E1APS_UTIL.COL_DSM_DATA;
106: pre_process_odi :=MSC_E1APS_DEMCL.CALL_ODIEXE(scenario_name, scenario_version, scenario_param, WSURL);
107:
108: IF pre_process_odi = FALSE THEN
109: /* Executing Mail Scenario */

Line 131: select MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(WSURL,2) into ReturnStr from dual;

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;
132:
133: EXCEPTION
134: WHEN OTHERS THEN
135: select instr(ReturnStr,'#') into StartIndex from dual;

Line 189: MSC_E1APS_UTIL.DEM_WORKFLOW(errbuf, retcode, l_wf_lookup_code,process_id,l_user_id);

185: l_wf_lookup_code := 'WF_AIA_E1_PTP_APCONFIRM_IMPORT';
186: retcode := 0;
187:
188: /* Lauch Demantra Work Flow */
189: MSC_E1APS_UTIL.DEM_WORKFLOW(errbuf, retcode, l_wf_lookup_code,process_id,l_user_id);
190:
191: if retcode = -1 or process_id= -1 then
192: msd_dem_common_utilities.log_message('DEM WORKFLOW NOT LAUNCHED');
193: RETCODE := MSC_UTIL.G_ERROR;

Line 238: MSC_E1APS_UTIL.DEM_WORKFLOW(errbuf, retcode, l_wf_lookup_code,process_id,l_user_id);

234: l_wf_lookup_code := 'WF_AIA_E1_DSM_NEWDEDUCT_DWNLD';
235: retcode := 0;
236:
237: /* Lauch Demantra Work Flow */
238: MSC_E1APS_UTIL.DEM_WORKFLOW(errbuf, retcode, l_wf_lookup_code,process_id,l_user_id);
239:
240: if retcode= -1 then
241: msd_dem_common_utilities.log_message('DEM WORKFLOW NOT LAUNCHED');
242: RETCODE := MSC_UTIL.G_ERROR;

Line 262: || MSC_E1APS_UTIL.COL_DSM_DATA;

258: scenario_param := 'E1TOAPSPROJECT.PVV_POST_PROCESS_VAR=';
259: scenario_param := scenario_param
260: ||l_instance_code
261: || ':'
262: || MSC_E1APS_UTIL.COL_DSM_DATA;
263:
264: post_process_odi :=MSC_E1APS_DEMCL.CALL_ODIEXE(scenario_name, scenario_version, scenario_param, WSURL);
265:
266: IF post_process_odi = FALSE THEN