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_E1_APS_PDP dependencies on DUAL

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

29:
30:
31: EXCEPTION
32: WHEN OTHERS THEN
33: select instr(ReturnStr,'#') into StartIndex from dual;
34: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
35: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario' || scrName|| ' execution failed.' || ErrMessage);
36: return FALSE;
37: end;

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

30:
31: EXCEPTION
32: WHEN OTHERS THEN
33: select instr(ReturnStr,'#') into StartIndex from dual;
34: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
35: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario' || scrName|| ' execution failed.' || ErrMessage);
36: return FALSE;
37: end;
38:

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

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

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

36: return FALSE;
37: end;
38:
39: select instr(ReturnStr,'#') into StartIndex from dual;
40: select substr(ReturnStr,0,StartIndex-1) into SessionNum from dual;
41: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
42:
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,StartIndex+1,1800) into ErrMessage from dual;

37: end;
38:
39: select instr(ReturnStr,'#') into StartIndex from dual;
40: select substr(ReturnStr,0,StartIndex-1) into SessionNum from dual;
41: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
42:
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 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 81: select instr(ReturnStr,'#') into StartIndex from dual;

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;
82: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
83: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario' || arrScr(i)|| ' execution failed.' || ErrMessage);
84: return FALSE;
85: end;

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

78:
79: EXCEPTION
80: WHEN OTHERS THEN
81: select instr(ReturnStr,'#') into StartIndex from dual;
82: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
83: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario' || arrScr(i)|| ' execution failed.' || ErrMessage);
84: return FALSE;
85: end;
86:

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

83: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario' || arrScr(i)|| ' execution failed.' || ErrMessage);
84: return FALSE;
85: end;
86:
87: select instr(ReturnStr,'#') into StartIndex from dual;
88: select substr(ReturnStr,0,StartIndex-1) into SessionNum from dual;
89: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
90: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, ' ODI Scenario '||' RESULT');
91:

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

84: return FALSE;
85: end;
86:
87: select instr(ReturnStr,'#') into StartIndex from dual;
88: select substr(ReturnStr,0,StartIndex-1) into SessionNum from dual;
89: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
90: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, ' ODI Scenario '||' RESULT');
91:
92:

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

85: end;
86:
87: select instr(ReturnStr,'#') into StartIndex from dual;
88: select substr(ReturnStr,0,StartIndex-1) into SessionNum from dual;
89: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
90: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, ' ODI Scenario '||' RESULT');
91:
92:
93: if (SessionNum = '-1') then

Line 105: sql_cnd := 'select INSTR('''||ws_prf||''','''||srch_str||''') from dual';

101: end if;
102:
103: -- Changes for bug # 12897298
104: ws_prf := fnd_profile.value('MSC_E1APS_ODIURL');
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);

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

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;
593: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error Message' || ErrMessage );
595: RETCODE := MSC_UTIL.G_ERROR;
596: RETURN;

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

589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: select instr(ReturnStr,'#') into StartIndex from dual;
593: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error Message' || ErrMessage );
595: RETCODE := MSC_UTIL.G_ERROR;
596: RETURN;
597: END;

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

595: RETCODE := MSC_UTIL.G_ERROR;
596: RETURN;
597: END;
598:
599: select instr(ReturnStr,'#') into StartIndex from dual;
600: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
601:
602: IF (length(ErrMessage) > 0) THEN
603: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Failed to Initialize. Error Message' || ErrMessage );

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

596: RETURN;
597: END;
598:
599: select instr(ReturnStr,'#') into StartIndex from dual;
600: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
601:
602: IF (length(ErrMessage) > 0) THEN
603: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Failed to Initialize. Error Message' || ErrMessage );
604: RETCODE := MSC_UTIL.G_ERROR;