eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_E1APS_DSMCOLL dependencies on DUAL

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 34: select instr(ReturnStr,'#') into StartIndex from dual;

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;
36: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario' || scrName|| ' execution failed.' || ErrMessage);
37: RETURN FALSE;
38: end;

Line 35: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;

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;
36: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario' || scrName|| ' execution failed.' || ErrMessage);
37: RETURN FALSE;
38: end;
39:

Line 40: select instr(ReturnStr,'#') into StartIndex from dual;

36: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario' || scrName|| ' execution failed.' || ErrMessage);
37: RETURN FALSE;
38: end;
39:
40: select instr(ReturnStr,'#') into StartIndex from dual;
41: select substr(ReturnStr,0,StartIndex-1) into SessionNum from dual;
42: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
43: if (SessionNum = '-1') then
44: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario ' || scrName|| ' executed with errors. Session #: ' || SessionNum || ' , Error Message: ' || ErrMessage);

Line 41: select substr(ReturnStr,0,StartIndex-1) into SessionNum from dual;

37: RETURN FALSE;
38: end;
39:
40: select instr(ReturnStr,'#') into StartIndex from dual;
41: select substr(ReturnStr,0,StartIndex-1) into SessionNum from dual;
42: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
43: if (SessionNum = '-1') then
44: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario ' || scrName|| ' executed with errors. Session #: ' || SessionNum || ' , Error Message: ' || ErrMessage);
45: RETURN FALSE;

Line 42: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;

38: end;
39:
40: select instr(ReturnStr,'#') into StartIndex from dual;
41: select substr(ReturnStr,0,StartIndex-1) into SessionNum from dual;
42: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
43: if (SessionNum = '-1') then
44: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario ' || scrName|| ' executed with errors. Session #: ' || SessionNum || ' , Error Message: ' || ErrMessage);
45: RETURN FALSE;
46: end if;

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 135: select instr(ReturnStr,'#') into StartIndex from dual;

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;
136: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
137: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
138: RETCODE := MSC_UTIL.G_ERROR;
139: RETURN;

Line 136: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;

132:
133: EXCEPTION
134: WHEN OTHERS THEN
135: select instr(ReturnStr,'#') into StartIndex from dual;
136: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
137: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
138: RETCODE := MSC_UTIL.G_ERROR;
139: RETURN;
140: END;

Line 141: select instr(ReturnStr,'#') into StartIndex from dual;

137: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
138: RETCODE := MSC_UTIL.G_ERROR;
139: RETURN;
140: END;
141: select instr(ReturnStr,'#') into StartIndex from dual;
142: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
143:
144: IF(length(ErrMessage) > 0) THEN
145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);

Line 142: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;

138: RETCODE := MSC_UTIL.G_ERROR;
139: RETURN;
140: END;
141: select instr(ReturnStr,'#') into StartIndex from dual;
142: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
143:
144: IF(length(ErrMessage) > 0) THEN
145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
146: RETCODE := MSC_UTIL.G_ERROR;