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 MSC_UTIL

Line 36: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario' || scrName|| ' execution failed.' || ErrMessage);

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

Line 44: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario ' || scrName|| ' executed with errors. Session #: ' || SessionNum || ' , Error Message: ' || ErrMessage);

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;
47:
48: if (SessionNum <> '-1' and length(ErrMessage) > 0) then

Line 49: 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;
47:
48: if (SessionNum <> '-1' and length(ErrMessage) > 0) then
49: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario ' || scrName|| ' executed with errors. Session #: ' || SessionNum || ' , Error Message: ' || ErrMessage);
50: RETURN FALSE;
51: end if;
52:
53: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario ' || scrName || ' execution is successful.');

Line 53: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario ' || scrName || ' execution is successful.');

49: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario ' || scrName|| ' executed with errors. Session #: ' || SessionNum || ' , Error Message: ' || ErrMessage);
50: RETURN FALSE;
51: end if;
52:
53: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario ' || scrName || ' execution is successful.');
54: RETURN TRUE;
55: END IF;
56:
57: RETURN TRUE;

Line 85: IF RETCODE = MSC_UTIL.G_ERROR THEN

81: BEGIN
82:
83: /* Launching Collect DSM Pre-Proces Custom Hook*/
84: MSC_E1APS_HOOK.COL_DSM_DATA_PRE_PROCESS(ERRBUF,RETCODE);
85: IF RETCODE = MSC_UTIL.G_ERROR THEN
86: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
87: RETCODE := MSC_UTIL.G_ERROR;
88: RETURN;
89: END IF;

Line 86: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);

82:
83: /* Launching Collect DSM Pre-Proces Custom Hook*/
84: MSC_E1APS_HOOK.COL_DSM_DATA_PRE_PROCESS(ERRBUF,RETCODE);
85: IF RETCODE = MSC_UTIL.G_ERROR THEN
86: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
87: RETCODE := MSC_UTIL.G_ERROR;
88: RETURN;
89: END IF;
90:

Line 87: RETCODE := MSC_UTIL.G_ERROR;

83: /* Launching Collect DSM Pre-Proces Custom Hook*/
84: MSC_E1APS_HOOK.COL_DSM_DATA_PRE_PROCESS(ERRBUF,RETCODE);
85: IF RETCODE = MSC_UTIL.G_ERROR THEN
86: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
87: RETCODE := MSC_UTIL.G_ERROR;
88: RETURN;
89: END IF;
90:
91: /* Checking ODI Profile*/

Line 114: RETCODE := MSC_UTIL.G_ERROR;

110: scenario_name := 'MAIL';
111: scenario_version := '001';
112: scenario_param := '';
113: ret_value1 :=MSC_E1APS_DEMCL.CALL_ODIEXE(scenario_name, scenario_version, scenario_param, WSURL);
114: RETCODE := MSC_UTIL.G_ERROR;
115: RETURN;
116: END IF;
117: END IF;
118:

Line 130: MSC_UTIL.MSC_DEBUG('INITIALIZING ODI ....');

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;
132:
133: EXCEPTION
134: WHEN OTHERS THEN

Line 137: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);

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

Line 138: RETCODE := MSC_UTIL.G_ERROR;

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;
141: select instr(ReturnStr,'#') into StartIndex from dual;
142: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;

Line 145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);

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;
147: return;
148: end if;
149:

Line 146: RETCODE := MSC_UTIL.G_ERROR;

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;
147: return;
148: end if;
149:
150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');

Line 150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');

146: RETCODE := MSC_UTIL.G_ERROR;
147: return;
148: end if;
149:
150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
151:
152:
153: END IF;
154:

Line 155: IF parLoadPayCnf = MSC_UTIL.SYS_YES THEN

151:
152:
153: END IF;
154:
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');

Line 167: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );

163: if fc_ret_value = FALSE then
164: /* Launch Mail */
165: mailstat := MSC_E1APS_ODIExecute('MAIL',WSURL);
166:
167: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
168: RETCODE := MSC_UTIL.G_ERROR;
169: RETURN;
170: end if;
171: else

Line 168: RETCODE := MSC_UTIL.G_ERROR;

164: /* Launch Mail */
165: mailstat := MSC_E1APS_ODIExecute('MAIL',WSURL);
166:
167: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
168: RETCODE := MSC_UTIL.G_ERROR;
169: RETURN;
170: end if;
171: else
172: /* Launch Mail */

Line 177: RETCODE := MSC_UTIL.G_ERROR;

173: mailstat := MSC_E1APS_ODIExecute('MAIL',WSURL);
174: fc_ret_value:=ODILaunchFlag;
175:
176: IF ODILaunchFlag = FALSE THEN
177: RETCODE := MSC_UTIL.G_ERROR;
178: RETURN;
179: END IF;
180:
181: end if;

Line 193: RETCODE := MSC_UTIL.G_ERROR;

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;
194: RETURN;
195: else
196: msd_dem_common_utilities.log_message('DEM WORKFLOW LAUNCHED. Process ID: ' || process_id );
197: end if;

Line 202: IF parLoadDed = MSC_UTIL.SYS_YES THEN

198: END IF;
199:
200: END IF;
201:
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');

Line 214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );

210: if fc_ret_value = FALSE then
211: /* Launch Mail */
212: mailstat := MSC_E1APS_ODIExecute('MAIL',WSURL);
213:
214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
215: RETCODE := MSC_UTIL.G_ERROR;
216: RETURN;
217: end if;
218: else

Line 215: RETCODE := MSC_UTIL.G_ERROR;

211: /* Launch Mail */
212: mailstat := MSC_E1APS_ODIExecute('MAIL',WSURL);
213:
214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
215: RETCODE := MSC_UTIL.G_ERROR;
216: RETURN;
217: end if;
218: else
219: /* Launch Mail */

Line 224: RETCODE := MSC_UTIL.G_ERROR;

220: mailstat := MSC_E1APS_ODIExecute('MAIL',WSURL);
221: fc_ret_value:=ODILaunchFlag;
222:
223: IF ODILaunchFlag = FALSE THEN
224: RETCODE := MSC_UTIL.G_ERROR;
225: -- RETURN;
226: END IF;
227:
228: end if;

Line 242: RETCODE := MSC_UTIL.G_ERROR;

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;
243: RETURN;
244: else
245: msd_dem_common_utilities.log_message('DEM WORKFLOW LAUNCHED. Process ID: ' || process_id );
246: end if;

Line 272: RETCODE := MSC_UTIL.G_ERROR;

268: scenario_name := 'MAIL';
269: scenario_version := '001';
270: scenario_param := '';
271: ret_value1 :=MSC_E1APS_DEMCL.CALL_ODIEXE(scenario_name, scenario_version, scenario_param, WSURL);
272: RETCODE := MSC_UTIL.G_ERROR;
273: RETURN;
274: ELSE
275: /* Executing Mail Scenario */
276: scenario_name := 'MAIL';

Line 284: IF RETCODE = MSC_UTIL.G_ERROR THEN

280: END IF;
281:
282: /* Launching Collect DSM Post-Proces Custom Hook*/
283: MSC_E1APS_HOOK.COL_DSM_DATA_PRE_PROCESS(ERRBUF,RETCODE);
284: IF RETCODE = MSC_UTIL.G_ERROR THEN
285: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
286: RETCODE := MSC_UTIL.G_ERROR;
287: RETURN;
288: END IF;

Line 285: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);

281:
282: /* Launching Collect DSM Post-Proces Custom Hook*/
283: MSC_E1APS_HOOK.COL_DSM_DATA_PRE_PROCESS(ERRBUF,RETCODE);
284: IF RETCODE = MSC_UTIL.G_ERROR THEN
285: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
286: RETCODE := MSC_UTIL.G_ERROR;
287: RETURN;
288: END IF;
289:

Line 286: RETCODE := MSC_UTIL.G_ERROR;

282: /* Launching Collect DSM Post-Proces Custom Hook*/
283: MSC_E1APS_HOOK.COL_DSM_DATA_PRE_PROCESS(ERRBUF,RETCODE);
284: IF RETCODE = MSC_UTIL.G_ERROR THEN
285: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
286: RETCODE := MSC_UTIL.G_ERROR;
287: RETURN;
288: END IF;
289:
290: END; -- Procedure MSC_DSM_COLLECTIONS