APPS.MSC_E1_APS_PDP dependencies on MSC_E1APS_UTIL

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

24: -- NO local variables
25: BEGIN
26: IF WSURL IS NOT NULL THEN
27: begin
28: select MSC_E1APS_UTIL.MSC_E1APS_ODIScenarioExecute(scrName,'001','',WSURL) into ReturnStr from dual;
29:
30:
31: EXCEPTION
32: WHEN OTHERS THEN

Line 77: select MSC_E1APS_UTIL.MSC_E1APS_ODIScenarioExecute(arrScr(i),'001','',WSURL) into ReturnStr from dual;

73: begin
74: FOR i IN arrScr.FIRST .. arrScr.LAST LOOP
75: IF WSURL IS NOT NULL THEN
76: begin
77: select MSC_E1APS_UTIL.MSC_E1APS_ODIScenarioExecute(arrScr(i),'001','',WSURL) into ReturnStr from dual;
78:
79: EXCEPTION
80: WHEN OTHERS THEN
81: select instr(ReturnStr,'#') into StartIndex from dual;

Line 109: err_msg1 := MSC_E1APS_UTIL.GetODIErrorMessage(SessionNum);

105: sql_cnd := 'select INSTR('''||ws_prf||''','''||srch_str||''') from dual';
106: EXECUTE immediate sql_cnd into chk_cnd;
107: IF (chk_cnd > 0) THEN -- Execute only if its 11G
108: if (SessionNum <> '-1' and length(ErrMessage) IS NULL) then
109: err_msg1 := MSC_E1APS_UTIL.GetODIErrorMessage(SessionNum);
110: if (length(err_msg1) IS NOT NULL) then
111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario : ' || arrScr(i)|| ' FAILED. Session #: ' || SessionNum);
112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message: ' || err_msg1);
113: RETURN FALSE;

Line 119: OdiStatus:= MSC_E1APS_UTIL.OdiSessionStatus(arrScr(i));

115: end if;
116: END IF; -- for Bug # 12897298
117:
118: if (SessionNum is NULL ) then
119: OdiStatus:= MSC_E1APS_UTIL.OdiSessionStatus(arrScr(i));
120: IF OdiStatus = FALSE THEN
121: RETURN OdiStatus;
122: END IF;
123:

Line 315: || MSC_E1APS_UTIL.COL_PLAN_DATA;

311: scenario_name := 'PREPROCESSHOOKPKG';
312: scenario_version := '001';
313: scenario_param := 'E1TOAPSPROJECT.PVV_PRE_PROCESS_VAR=';
314: scenario_param := scenario_param ||l_instance_code || ':'
315: || MSC_E1APS_UTIL.COL_PLAN_DATA;
316: pre_process_odi :=MSC_E1APS_DEMCL.CALL_ODIEXE(scenario_name, scenario_version, scenario_param, WSURL);
317:
318: IF pre_process_odi = FALSE THEN
319: mailstat := MSC_E1_Mail_ODIExecute('MAIL',WSURL);

Line 588: select MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(WSURL,parBaseDate) into ReturnStr from dual;

584: WSURL := fnd_profile.value('MSC_E1APS_ODIURL');
585:
586: IF WSURL IS NOT NULL THEN
587: BEGIN
588: select MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(WSURL,parBaseDate) into ReturnStr from dual;
589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: select instr(ReturnStr,'#') into StartIndex from dual;

Line 875: || MSC_E1APS_UTIL.COL_PLAN_DATA;

871: scenario_param := 'E1TOAPSPROJECT.PVV_POST_PROCESS_VAR=';
872: scenario_param := scenario_param
873: ||l_instance_code
874: || ':'
875: || MSC_E1APS_UTIL.COL_PLAN_DATA;
876: post_process_odi :=MSC_E1APS_DEMCL.CALL_ODIEXE(scenario_name, scenario_version, scenario_param, WSURL);
877:
878: IF post_process_odi = FALSE THEN
879: mailstat := MSC_E1_Mail_ODIExecute('MAIL',WSURL);