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_DEMCL dependencies on MSC_UTIL

Line 36: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario'

32: SELECT SUBSTR(return_str,start_index+1,1800)
33: INTO err_message
34: FROM dual;
35:
36: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario'
37: || scenario_name
38: || ' execution failed.'
39: || err_message);
40: RETURN FALSE;

Line 55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario '

51: INTO err_message
52: FROM dual;
53:
54: IF session_num = '-1' THEN
55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario '
56: || scenario_name
57: || ' executed with errors. Session #: '
58: || session_num
59: || ' , Error Message: '

Line 64: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario '

60: || err_message);
61: RETURN FALSE;
62: END IF;
63: IF session_num <>'-1' AND LENGTH(err_message) > 0 THEN
64: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario '
65: || scenario_name
66: || ' executed with errors. Session #: '
67: || session_num
68: || ' , Error Message: '

Line 77: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario '

73: -- Changes for 11G
74: IF ( (session_num <> '-1') AND (LENGTH(err_message) IS NULL) ) THEN
75: err_msg1 := MSC_E1APS_UTIL.GetODIErrorMessage(session_num);
76: IF ( LENGTH(err_msg1) IS NOT NULL ) THEN
77: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario '
78: || scenario_name
79: || ' FAILED. Session # : ' || session_num);
80: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error : ' || err_msg1);
81: RETURN FALSE;

Line 80: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error : ' || err_msg1);

76: IF ( LENGTH(err_msg1) IS NOT NULL ) THEN
77: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario '
78: || scenario_name
79: || ' FAILED. Session # : ' || session_num);
80: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error : ' || err_msg1);
81: RETURN FALSE;
82: END IF;
83: END IF;
84:

Line 85: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario '

81: RETURN FALSE;
82: END IF;
83: END IF;
84:
85: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario '
86: || scenario_name
87: || ' execution is successful.');
88: RETURN TRUE;
89: END CALL_ODIEXE;

Line 124: IF RETCODE = MSC_UTIL.G_ERROR THEN

120:
121: /* Launching Price List and UOM Pre-Proces Custom Hook*/
122: MSC_E1APS_HOOK.COL_PRC_UOM_PRE_PROCESS(ERRBUF,RETCODE);
123:
124: IF RETCODE = MSC_UTIL.G_ERROR THEN
125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
126: RETCODE := MSC_UTIL.G_ERROR;
127: RETURN;
128: END IF;

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

121: /* Launching Price List and UOM Pre-Proces Custom Hook*/
122: MSC_E1APS_HOOK.COL_PRC_UOM_PRE_PROCESS(ERRBUF,RETCODE);
123:
124: IF RETCODE = MSC_UTIL.G_ERROR THEN
125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
126: RETCODE := MSC_UTIL.G_ERROR;
127: RETURN;
128: END IF;
129:

Line 126: RETCODE := MSC_UTIL.G_ERROR;

122: MSC_E1APS_HOOK.COL_PRC_UOM_PRE_PROCESS(ERRBUF,RETCODE);
123:
124: IF RETCODE = MSC_UTIL.G_ERROR THEN
125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
126: RETCODE := MSC_UTIL.G_ERROR;
127: RETURN;
128: END IF;
129:
130: /* Launching ODI Pre-Process Custom Hook Scenarios */

Line 153: RETCODE := MSC_UTIL.G_ERROR;

149: scenario_name := 'MAIL';
150: scenario_version := '001';
151: scenario_param := '';
152: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
153: RETCODE := MSC_UTIL.G_ERROR;
154: RETURN;
155: END IF;
156: END IF;
157:

Line 168: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_PRICE_LISTS');

164:
165: COMMIT;
166: EXCEPTION
167: WHEN OTHERS THEN
168: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_PRICE_LISTS');
169: RETCODE := MSC_UTIL.G_ERROR;
170: RETURN;
171: END;
172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_PRICE_LISTS');

Line 169: RETCODE := MSC_UTIL.G_ERROR;

165: COMMIT;
166: EXCEPTION
167: WHEN OTHERS THEN
168: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_PRICE_LISTS');
169: RETCODE := MSC_UTIL.G_ERROR;
170: RETURN;
171: END;
172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_PRICE_LISTS');
173:

Line 172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_PRICE_LISTS');

168: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_PRICE_LISTS');
169: RETCODE := MSC_UTIL.G_ERROR;
170: RETURN;
171: END;
172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_PRICE_LISTS');
173:
174: /* Step 1: Inserting rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIST */
175: BEGIN
176: INSERT

Line 196: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');

192:
193: COMMIT;
194: EXCEPTION
195: WHEN OTHERS THEN
196: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');
197: RETCODE := MSC_UTIL.G_ERROR;
198: RETURN;
199: END;
200: SELECT COUNT(*)

Line 197: RETCODE := MSC_UTIL.G_ERROR;

193: COMMIT;
194: EXCEPTION
195: WHEN OTHERS THEN
196: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');
197: RETCODE := MSC_UTIL.G_ERROR;
198: RETURN;
199: END;
200: SELECT COUNT(*)
201: INTO total_rows

Line 203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Inserted ' || total_rows || 'rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');

199: END;
200: SELECT COUNT(*)
201: INTO total_rows
202: FROM MSD_DEM_PRICE_LISTS;
203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Inserted ' || total_rows || 'rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');
204:
205:
206: p_start_date := fnd_profile.value('MSC_E1APS_DEM_START_DATE_IN_MONTHS');
207: p_end_date := fnd_profile.value('MSC_E1APS_DEM_END_DATE_IN_MONTHS');

Line 228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in submitting concurrent program for Demantra Price List Collection');

224: p_include_all,
225: p_include_prl_list,
226: p_exclude_prl_list);
227: IF v_request_id1 = 0 THEN
228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in submitting concurrent program for Demantra Price List Collection');
229: RETCODE := MSC_UTIL.G_ERROR;
230: RETURN;
231: ELSE
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Demantra Price List Launched. Request Id:'

Line 229: RETCODE := MSC_UTIL.G_ERROR;

225: p_include_prl_list,
226: p_exclude_prl_list);
227: IF v_request_id1 = 0 THEN
228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in submitting concurrent program for Demantra Price List Collection');
229: RETCODE := MSC_UTIL.G_ERROR;
230: RETURN;
231: ELSE
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Demantra Price List Launched. Request Id:'
233: || v_request_id1 );

Line 232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Demantra Price List Launched. Request Id:'

228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in submitting concurrent program for Demantra Price List Collection');
229: RETCODE := MSC_UTIL.G_ERROR;
230: RETURN;
231: ELSE
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Demantra Price List Launched. Request Id:'
233: || v_request_id1 );
234:
235:
236:

Line 256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in submitting concurrent program for Demantra UOM Collection');

252: p_include_all,
253: p_include_uom_list,
254: p_exclude_uom_list);
255: IF v_request_id2 = 0 THEN
256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in submitting concurrent program for Demantra UOM Collection');
257: RETCODE := MSC_UTIL.G_ERROR;
258: RETURN;
259: ELSE
260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Demantra UOM Collection Launched. Request Id:'

Line 257: RETCODE := MSC_UTIL.G_ERROR;

253: p_include_uom_list,
254: p_exclude_uom_list);
255: IF v_request_id2 = 0 THEN
256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in submitting concurrent program for Demantra UOM Collection');
257: RETCODE := MSC_UTIL.G_ERROR;
258: RETURN;
259: ELSE
260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Demantra UOM Collection Launched. Request Id:'
261: || v_request_id2 );

Line 260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Demantra UOM Collection Launched. Request Id:'

256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in submitting concurrent program for Demantra UOM Collection');
257: RETCODE := MSC_UTIL.G_ERROR;
258: RETURN;
259: ELSE
260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Demantra UOM Collection Launched. Request Id:'
261: || v_request_id2 );
262: END IF;
263: END IF;
264:

Line 289: RETCODE := MSC_UTIL.G_ERROR;

285: scenario_param := '';
286: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
287:
288: IF pre_process_odi = FALSE THEN
289: RETCODE := MSC_UTIL.G_ERROR;
290: RETURN;
291: END IF;
292: END IF;
293:

Line 297: IF RETCODE = MSC_UTIL.G_ERROR THEN

293:
294: /* Launching Price List and UOM Post-Proces Custom Hook*/
295: MSC_E1APS_HOOK.COL_PRC_UOM_POST_PROCESS(ERRBUF,RETCODE);
296:
297: IF RETCODE = MSC_UTIL.G_ERROR THEN
298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
299: RETCODE := MSC_UTIL.G_ERROR;
300: RETURN;
301: END IF;

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

294: /* Launching Price List and UOM Post-Proces Custom Hook*/
295: MSC_E1APS_HOOK.COL_PRC_UOM_POST_PROCESS(ERRBUF,RETCODE);
296:
297: IF RETCODE = MSC_UTIL.G_ERROR THEN
298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
299: RETCODE := MSC_UTIL.G_ERROR;
300: RETURN;
301: END IF;
302:

Line 299: RETCODE := MSC_UTIL.G_ERROR;

295: MSC_E1APS_HOOK.COL_PRC_UOM_POST_PROCESS(ERRBUF,RETCODE);
296:
297: IF RETCODE = MSC_UTIL.G_ERROR THEN
298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
299: RETCODE := MSC_UTIL.G_ERROR;
300: RETURN;
301: END IF;
302:
303: END DEM_PL_UOM;

Line 346: IF RETCODE = MSC_UTIL.G_ERROR THEN

342:
343: /* Launching Sales History Pre-Proces Custom Hook*/
344: MSC_E1APS_HOOK.COL_PRC_UOM_PRE_PROCESS(ERRBUF,RETCODE);
345:
346: IF RETCODE = MSC_UTIL.G_ERROR THEN
347: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
348: RETCODE := MSC_UTIL.G_ERROR;
349: RETURN;
350: END IF;

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

343: /* Launching Sales History Pre-Proces Custom Hook*/
344: MSC_E1APS_HOOK.COL_PRC_UOM_PRE_PROCESS(ERRBUF,RETCODE);
345:
346: IF RETCODE = MSC_UTIL.G_ERROR THEN
347: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
348: RETCODE := MSC_UTIL.G_ERROR;
349: RETURN;
350: END IF;
351:

Line 348: RETCODE := MSC_UTIL.G_ERROR;

344: MSC_E1APS_HOOK.COL_PRC_UOM_PRE_PROCESS(ERRBUF,RETCODE);
345:
346: IF RETCODE = MSC_UTIL.G_ERROR THEN
347: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
348: RETCODE := MSC_UTIL.G_ERROR;
349: RETURN;
350: END IF;
351:
352: /*Checking ODI Profile */

Line 374: RETCODE := MSC_UTIL.G_ERROR;

370: scenario_name := 'MAIL';
371: scenario_version := '001';
372: scenario_param := '';
373: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
374: RETCODE := MSC_UTIL.G_ERROR;
375: RETURN;
376: END IF;
377: END IF;
378: /* Truncating T_SRC_SALES_TMPL table */

Line 386: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Truncated from T_SRC_SALES_TMPL');

382: || '.T_SRC_SALES_TMPL';
383: EXECUTE immediate l_sql;
384: EXCEPTION
385: WHEN OTHERS THEN
386: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Truncated from T_SRC_SALES_TMPL');
387: RETCODE := MSC_UTIL.G_ERROR;
388: RETURN;
389: END;
390: /* Accessing instance_id from MSC_APPS_INSTANCES*/

Line 387: RETCODE := MSC_UTIL.G_ERROR;

383: EXECUTE immediate l_sql;
384: EXCEPTION
385: WHEN OTHERS THEN
386: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Truncated from T_SRC_SALES_TMPL');
387: RETCODE := MSC_UTIL.G_ERROR;
388: RETURN;
389: END;
390: /* Accessing instance_id from MSC_APPS_INSTANCES*/
391: SELECT ATTRIBUTE13,

Line 410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_CALENDARS');

406:
407: COMMIT;
408: EXCEPTION
409: WHEN OTHERS THEN
410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_CALENDARS');
411: RETCODE := MSC_UTIL.G_ERROR;
412: RETURN;
413: END;
414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_CALENDARS');

Line 411: RETCODE := MSC_UTIL.G_ERROR;

407: COMMIT;
408: EXCEPTION
409: WHEN OTHERS THEN
410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_CALENDARS');
411: RETCODE := MSC_UTIL.G_ERROR;
412: RETURN;
413: END;
414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_CALENDARS');
415: BEGIN

Line 414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_CALENDARS');

410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_CALENDARS');
411: RETCODE := MSC_UTIL.G_ERROR;
412: RETURN;
413: END;
414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_CALENDARS');
415: BEGIN
416: INSERT
417: INTO MSD_DEM_CALENDARS
418: (

Line 444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');

440:
441: COMMIT;
442: EXCEPTION
443: WHEN OTHERS THEN
444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
445: RETCODE := MSC_UTIL.G_ERROR;
446: RETURN;
447: END;
448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');

Line 445: RETCODE := MSC_UTIL.G_ERROR;

441: COMMIT;
442: EXCEPTION
443: WHEN OTHERS THEN
444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
445: RETCODE := MSC_UTIL.G_ERROR;
446: RETURN;
447: END;
448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
449: /*ODI Initialize*/

Line 448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');

444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
445: RETCODE := MSC_UTIL.G_ERROR;
446: RETURN;
447: END;
448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
449: /*ODI Initialize*/
450: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
451: IF odi_url IS NOT NULL THEN
452: BEGIN

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

458: WHEN OTHERS THEN
459: select instr(ReturnStr,'#') into StartIndex from dual;
460: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
461:
462: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
463: RETCODE := MSC_UTIL.G_ERROR;
464: RETURN;
465: END;
466: select instr(ReturnStr,'#') into StartIndex from dual;

Line 463: RETCODE := MSC_UTIL.G_ERROR;

459: select instr(ReturnStr,'#') into StartIndex from dual;
460: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
461:
462: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
463: RETCODE := MSC_UTIL.G_ERROR;
464: RETURN;
465: END;
466: select instr(ReturnStr,'#') into StartIndex from dual;
467: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;

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

466: select instr(ReturnStr,'#') into StartIndex from dual;
467: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
468:
469: IF(length(ErrMessage) > 0) THEN
470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
471: RETCODE := MSC_UTIL.G_ERROR;
472: RETURN;
473: END IF;
474: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');

Line 471: RETCODE := MSC_UTIL.G_ERROR;

467: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
468:
469: IF(length(ErrMessage) > 0) THEN
470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
471: RETCODE := MSC_UTIL.G_ERROR;
472: RETURN;
473: END IF;
474: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
475: END IF;

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

470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
471: RETCODE := MSC_UTIL.G_ERROR;
472: RETURN;
473: END IF;
474: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
475: END IF;
476: /*Calling 'MSC_E1APS_ODIScenarioExecute' Function by using the 'CALL_ODIEXE' function */
477: scenario_name := 'LOADE1SALESORDERHISTORYDATATODMPKG';
478: scenario_version := '001';

Line 496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copied Successfully .' );

492: scenario_name := 'MAIL';
493: scenario_version := '001';
494: scenario_param := '';
495: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copied Successfully .' );
497: fc_ret_value:=ret_value;
498:
499: ELSE
500: /* Executing Mail Scenario */

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

502: scenario_version := '001';
503: scenario_param := '';
504: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
505:
506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
507: RETCODE := MSC_UTIL.G_ERROR;
508: RETURN;
509: END IF;
510: ELSE

Line 507: RETCODE := MSC_UTIL.G_ERROR;

503: scenario_param := '';
504: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
505:
506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
507: RETCODE := MSC_UTIL.G_ERROR;
508: RETURN;
509: END IF;
510: ELSE
511:

Line 520: RETCODE := MSC_UTIL.G_ERROR;

516: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
517:
518: fc_ret_value:=ret_value;
519: IF ret_value =FALSE then
520: RETCODE := MSC_UTIL.G_ERROR;
521: RETURN;
522: END IF;
523: END IF;
524:

Line 534: RETCODE := MSC_UTIL.G_ERROR;

530: IF NVL(to_number(retcode),0) <>0 THEN
531: msd_dem_common_utilities.log_message('Error Loading msd_dem_ssl_rs.run_rs Concurrent Request'
532: || errbuf
533: || retcode);
534: RETCODE := MSC_UTIL.G_ERROR;
535: RETURN;
536: ELSE
537: msd_dem_common_utilities.log_message('Demantra Collections Launched successfully');
538: END IF;

Line 547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in submitting concurrent program for Demantra Calenders Collection');

543: NULL, -- start date
544: FALSE, -- sub request
545: 1 );
546: IF v_request_id = 0 THEN
547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in submitting concurrent program for Demantra Calenders Collection');
548: RETCODE := MSC_UTIL.G_ERROR;
549: RETURN;
550: ELSE
551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Demantra Calenders Collections Launched. Request Id:'

Line 548: RETCODE := MSC_UTIL.G_ERROR;

544: FALSE, -- sub request
545: 1 );
546: IF v_request_id = 0 THEN
547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in submitting concurrent program for Demantra Calenders Collection');
548: RETCODE := MSC_UTIL.G_ERROR;
549: RETURN;
550: ELSE
551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Demantra Calenders Collections Launched. Request Id:'
552: || v_request_id );

Line 551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Demantra Calenders Collections Launched. Request Id:'

547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in submitting concurrent program for Demantra Calenders Collection');
548: RETCODE := MSC_UTIL.G_ERROR;
549: RETURN;
550: ELSE
551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Demantra Calenders Collections Launched. Request Id:'
552: || v_request_id );
553: END IF;
554: END IF;
555:

Line 576: RETCODE := MSC_UTIL.G_ERROR;

572: scenario_name := 'MAIL';
573: scenario_version := '001';
574: scenario_param := '';
575: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
576: RETCODE := MSC_UTIL.G_ERROR;
577: RETURN;
578: ELSE
579: /* Executing Mail Scenario */
580: scenario_name := 'MAIL';

Line 590: IF RETCODE = MSC_UTIL.G_ERROR THEN

586:
587: /* Launching Sales History Post-Proces Custom Hook*/
588: MSC_E1APS_HOOK.COL_PRC_UOM_POST_PROCESS(ERRBUF,RETCODE);
589:
590: IF RETCODE = MSC_UTIL.G_ERROR THEN
591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
592: RETCODE := MSC_UTIL.G_ERROR;
593: RETURN;
594: ELSE

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

587: /* Launching Sales History Post-Proces Custom Hook*/
588: MSC_E1APS_HOOK.COL_PRC_UOM_POST_PROCESS(ERRBUF,RETCODE);
589:
590: IF RETCODE = MSC_UTIL.G_ERROR THEN
591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
592: RETCODE := MSC_UTIL.G_ERROR;
593: RETURN;
594: ELSE
595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Post Process Custom Hook Procedure Excecuted Successfully');

Line 592: RETCODE := MSC_UTIL.G_ERROR;

588: MSC_E1APS_HOOK.COL_PRC_UOM_POST_PROCESS(ERRBUF,RETCODE);
589:
590: IF RETCODE = MSC_UTIL.G_ERROR THEN
591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
592: RETCODE := MSC_UTIL.G_ERROR;
593: RETURN;
594: ELSE
595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Post Process Custom Hook Procedure Excecuted Successfully');
596: END IF;

Line 595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Post Process Custom Hook Procedure Excecuted Successfully');

591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
592: RETCODE := MSC_UTIL.G_ERROR;
593: RETURN;
594: ELSE
595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Post Process Custom Hook Procedure Excecuted Successfully');
596: END IF;
597:
598: END DEM_SH;
599: /*Procedure for PTP Collections*/

Line 638: IF RETCODE = MSC_UTIL.G_ERROR THEN

634:
635: /* Launching Collect PTP Pre-Proces Custom Hook*/
636: MSC_E1APS_HOOK.COL_PTP_DATA_PRE_PROCESS(ERRBUF,RETCODE);
637:
638: IF RETCODE = MSC_UTIL.G_ERROR THEN
639: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
640: RETCODE := MSC_UTIL.G_ERROR;
641: RETURN;
642: END IF;

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

635: /* Launching Collect PTP Pre-Proces Custom Hook*/
636: MSC_E1APS_HOOK.COL_PTP_DATA_PRE_PROCESS(ERRBUF,RETCODE);
637:
638: IF RETCODE = MSC_UTIL.G_ERROR THEN
639: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
640: RETCODE := MSC_UTIL.G_ERROR;
641: RETURN;
642: END IF;
643:

Line 640: RETCODE := MSC_UTIL.G_ERROR;

636: MSC_E1APS_HOOK.COL_PTP_DATA_PRE_PROCESS(ERRBUF,RETCODE);
637:
638: IF RETCODE = MSC_UTIL.G_ERROR THEN
639: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
640: RETCODE := MSC_UTIL.G_ERROR;
641: RETURN;
642: END IF;
643:
644: /* Checking ODI Profile*/

Line 666: RETCODE := MSC_UTIL.G_ERROR;

662: scenario_name := 'MAIL';
663: scenario_version := '001';
664: scenario_param := '';
665: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
666: RETCODE := MSC_UTIL.G_ERROR;
667: RETURN;
668: END IF;
669: END IF;
670:

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

682: WHEN OTHERS THEN
683: select instr(ReturnStr,'#') into StartIndex from dual;
684: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
685:
686: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
687: RETCODE := MSC_UTIL.G_ERROR;
688: RETURN;
689: END;
690: select instr(ReturnStr,'#') into StartIndex from dual;

Line 687: RETCODE := MSC_UTIL.G_ERROR;

683: select instr(ReturnStr,'#') into StartIndex from dual;
684: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
685:
686: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
687: RETCODE := MSC_UTIL.G_ERROR;
688: RETURN;
689: END;
690: select instr(ReturnStr,'#') into StartIndex from dual;
691: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;

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

690: select instr(ReturnStr,'#') into StartIndex from dual;
691: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
692:
693: IF(length(ErrMessage) > 0) THEN
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
695: RETCODE := MSC_UTIL.G_ERROR;
696: RETURN;
697: END IF;
698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');

Line 695: RETCODE := MSC_UTIL.G_ERROR;

691: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
692:
693: IF(length(ErrMessage) > 0) THEN
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
695: RETCODE := MSC_UTIL.G_ERROR;
696: RETURN;
697: END IF;
698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
699:

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

694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
695: RETCODE := MSC_UTIL.G_ERROR;
696: RETURN;
697: END IF;
698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
699:
700: END IF;
701: SELECT ATTRIBUTE14,
702: ATTRIBUTE13

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

731: scenario_version := '001';
732: scenario_param := '';
733: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
734:
735: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
736: RETCODE := MSC_UTIL.G_ERROR;
737: RETURN;
738: END IF;
739: ELSE

Line 736: RETCODE := MSC_UTIL.G_ERROR;

732: scenario_param := '';
733: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
734:
735: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
736: RETCODE := MSC_UTIL.G_ERROR;
737: RETURN;
738: END IF;
739: ELSE
740:

Line 749: RETCODE := MSC_UTIL.G_ERROR;

745: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
746:
747: fc_ret_value:=ret_value;
748: IF ret_value =FALSE then
749: RETCODE := MSC_UTIL.G_ERROR;
750: RETURN;
751: END IF;
752: END IF;
753:

Line 760: RETCODE := MSC_UTIL.G_ERROR;

756: l_wf_lookup_code := 'WF_AIA_E1_PTP_PROMOPRICE_DWNLD';
757: MSC_E1APS_UTIL.DEM_WORKFLOW(errbuf, RETCODE,l_wf_lookup_code , process_id, l_user_id);
758: IF retcode= -1 OR process_id= -1 THEN
759: msd_dem_common_utilities.log_message('LIST PRICE DEM WORKFLOW NOT LAUNCHED. Process ID: ' || process_id);
760: RETCODE := MSC_UTIL.G_ERROR;
761: RETURN;
762: ELSE
763: msd_dem_common_utilities.log_message('LIST PRICE DEM WORKFLOW LAUNCHED. Process ID: ' || process_id);
764: END IF;

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

789: scenario_version := '001';
790: scenario_param := '';
791: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
792:
793: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
794: RETCODE := MSC_UTIL.G_ERROR;
795: RETURN;
796: END IF;
797: ELSE

Line 794: RETCODE := MSC_UTIL.G_ERROR;

790: scenario_param := '';
791: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
792:
793: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
794: RETCODE := MSC_UTIL.G_ERROR;
795: RETURN;
796: END IF;
797: ELSE
798: /* Executing Mail Scenario*/

Line 806: RETCODE := MSC_UTIL.G_ERROR;

802: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
803:
804: fc_ret_value:=ret_value;
805: IF ret_value =FALSE then
806: RETCODE := MSC_UTIL.G_ERROR;
807: RETURN;
808: END IF;
809: END IF;
810:

Line 817: RETCODE := MSC_UTIL.G_ERROR;

813: l_wf_lookup_code := 'WF_AIA_E1_PTP_PROMOCOST_DWNLD';
814: MSC_E1APS_UTIL.DEM_WORKFLOW(errbuf, RETCODE,l_wf_lookup_code , process_id, l_user_id);
815: IF retcode= -1 OR process_id= -1 THEN
816: msd_dem_common_utilities.log_message('ITEM COST DEM WORKFLOW NOT LAUNCHED.' || process_id);
817: RETCODE := MSC_UTIL.G_ERROR;
818: RETURN;
819: ELSE
820: msd_dem_common_utilities.log_message('ITEM COST DEM WORKFLOW LAUNCHED. Process ID: ' || process_id);
821: END IF;

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

843: scenario_version := '001';
844: scenario_param := '';
845: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
846:
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
848: RETCODE := MSC_UTIL.G_ERROR;
849: RETURN;
850: END IF;
851: ELSE

Line 848: RETCODE := MSC_UTIL.G_ERROR;

844: scenario_param := '';
845: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
846:
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
848: RETCODE := MSC_UTIL.G_ERROR;
849: RETURN;
850: END IF;
851: ELSE
852: /* Executing Mail Scenario*/

Line 860: RETCODE := MSC_UTIL.G_ERROR;

856: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
857:
858: fc_ret_value:=ret_value;
859: IF ret_value =FALSE then
860: RETCODE := MSC_UTIL.G_ERROR;
861: RETURN;
862: END IF;
863: END IF;
864:

Line 871: RETCODE := MSC_UTIL.G_ERROR;

867: l_wf_lookup_code := 'WF_AIA_E1_PTP_PRICEHIST_DWNLD';
868: MSC_E1APS_UTIL.DEM_WORKFLOW(errbuf, RETCODE,l_wf_lookup_code , process_id, l_user_id);
869: IF retcode= -1 OR process_id= -1 THEN
870: msd_dem_common_utilities.log_message('PRICE HISTORY DEM WORKFLOW NOT LAUNCHED.Process ID: ' || process_id);
871: RETCODE := MSC_UTIL.G_ERROR;
872: RETURN;
873: ELSE
874: msd_dem_common_utilities.log_message('PRICE HISTORY DEM WORKFLOW LAUNCHED. Process ID: ' || process_id);
875: END IF;

Line 896: RETCODE := MSC_UTIL.G_ERROR;

892: scenario_name := 'MAIL';
893: scenario_version := '001';
894: scenario_param := '';
895: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
896: RETCODE := MSC_UTIL.G_ERROR;
897: RETURN;
898: ELSE
899: /* Executing Mail Scenario */
900: scenario_name := 'MAIL';

Line 908: IF RETCODE = MSC_UTIL.G_ERROR THEN

904: END IF;
905: /* Launching Collect PTP Post-Proces Custom Hook*/
906: MSC_E1APS_HOOK.COL_PTP_DATA_POST_PROCESS(ERRBUF,RETCODE);
907:
908: IF RETCODE = MSC_UTIL.G_ERROR THEN
909: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
910: RETCODE := MSC_UTIL.G_ERROR;
911: RETURN;
912: END IF;

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

905: /* Launching Collect PTP Post-Proces Custom Hook*/
906: MSC_E1APS_HOOK.COL_PTP_DATA_POST_PROCESS(ERRBUF,RETCODE);
907:
908: IF RETCODE = MSC_UTIL.G_ERROR THEN
909: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
910: RETCODE := MSC_UTIL.G_ERROR;
911: RETURN;
912: END IF;
913:

Line 910: RETCODE := MSC_UTIL.G_ERROR;

906: MSC_E1APS_HOOK.COL_PTP_DATA_POST_PROCESS(ERRBUF,RETCODE);
907:
908: IF RETCODE = MSC_UTIL.G_ERROR THEN
909: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
910: RETCODE := MSC_UTIL.G_ERROR;
911: RETURN;
912: END IF;
913:
914: END DEM_PTP;

Line 945: IF RETCODE = MSC_UTIL.G_ERROR THEN

941:
942: /* Launching Publish Planning Results Pre-Proces Custom Hook*/
943: MSC_E1APS_HOOK.PUB_PLAN_RES_PRE_PROCESS(ERRBUF,RETCODE);
944:
945: IF RETCODE = MSC_UTIL.G_ERROR THEN
946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
947: RETCODE := MSC_UTIL.G_ERROR;
948: RETURN;
949: END IF;

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

942: /* Launching Publish Planning Results Pre-Proces Custom Hook*/
943: MSC_E1APS_HOOK.PUB_PLAN_RES_PRE_PROCESS(ERRBUF,RETCODE);
944:
945: IF RETCODE = MSC_UTIL.G_ERROR THEN
946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
947: RETCODE := MSC_UTIL.G_ERROR;
948: RETURN;
949: END IF;
950:

Line 947: RETCODE := MSC_UTIL.G_ERROR;

943: MSC_E1APS_HOOK.PUB_PLAN_RES_PRE_PROCESS(ERRBUF,RETCODE);
944:
945: IF RETCODE = MSC_UTIL.G_ERROR THEN
946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
947: RETCODE := MSC_UTIL.G_ERROR;
948: RETURN;
949: END IF;
950:
951: /* Checking ODI Profile*/

Line 974: RETCODE := MSC_UTIL.G_ERROR;

970: scenario_name := 'MAIL';
971: scenario_version := '001';
972: scenario_param := '';
973: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
974: RETCODE := MSC_UTIL.G_ERROR;
975: RETURN;
976: END IF;
977: END IF;
978:

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

995: WHEN OTHERS THEN
996: select instr(ReturnStr,'#') into StartIndex from dual;
997: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
998:
999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1000: RETCODE := MSC_UTIL.G_ERROR;
1001: RETURN;
1002: END;
1003: select instr(ReturnStr,'#') into StartIndex from dual;

Line 1000: RETCODE := MSC_UTIL.G_ERROR;

996: select instr(ReturnStr,'#') into StartIndex from dual;
997: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
998:
999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1000: RETCODE := MSC_UTIL.G_ERROR;
1001: RETURN;
1002: END;
1003: select instr(ReturnStr,'#') into StartIndex from dual;
1004: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;

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

1003: select instr(ReturnStr,'#') into StartIndex from dual;
1004: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
1005:
1006: IF(length(ErrMessage) > 0) THEN
1007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1008: RETCODE := MSC_UTIL.G_ERROR;
1009: RETURN;
1010: END IF;
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');

Line 1008: RETCODE := MSC_UTIL.G_ERROR;

1004: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
1005:
1006: IF(length(ErrMessage) > 0) THEN
1007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1008: RETCODE := MSC_UTIL.G_ERROR;
1009: RETURN;
1010: END IF;
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
1012:

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

1007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1008: RETCODE := MSC_UTIL.G_ERROR;
1009: RETURN;
1010: END IF;
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
1012:
1013: END IF;
1014:
1015: /* Executing PurchasePlan ODI Scenarios */

Line 1016: IF p_purchase_plan = MSC_UTIL.SYS_YES THEN

1012:
1013: END IF;
1014:
1015: /* Executing PurchasePlan ODI Scenarios */
1016: IF p_purchase_plan = MSC_UTIL.SYS_YES THEN
1017: scenario_name:='LOADAPSPURCHASEPLANDATATOE1PKG';
1018: ret_value1 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1019: END IF;
1020:

Line 1021: IF p_deployment_plan = MSC_UTIL.SYS_YES THEN

1017: scenario_name:='LOADAPSPURCHASEPLANDATATOE1PKG';
1018: ret_value1 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1019: END IF;
1020:
1021: IF p_deployment_plan = MSC_UTIL.SYS_YES THEN
1022: scenario_name:='LOADAPSDEPLOYMENTPLANDATATOE1PKG';
1023: ret_value2 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1024: END IF;
1025: IF p_detailed_production_plan = MSC_UTIL.SYS_YES THEN

Line 1025: IF p_detailed_production_plan = MSC_UTIL.SYS_YES THEN

1021: IF p_deployment_plan = MSC_UTIL.SYS_YES THEN
1022: scenario_name:='LOADAPSDEPLOYMENTPLANDATATOE1PKG';
1023: ret_value2 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1024: END IF;
1025: IF p_detailed_production_plan = MSC_UTIL.SYS_YES THEN
1026: scenario_name:='LOADAPSDETAILEDPRODPLANDATATOE1PKG';
1027: ret_value3 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1028: END IF;
1029:

Line 1034: RETCODE := MSC_UTIL.G_ERROR;

1030: IF ret_value3 = false OR ret_value2 = false OR ret_value1 = false THEN
1031: scenario_name :='MAIL';
1032: scenario_param:='';
1033: ret_value4 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1034: RETCODE := MSC_UTIL.G_ERROR;
1035: RETURN;
1036: END IF;
1037:
1038: IF ret_value3 OR ret_value2 OR ret_value1 THEN

Line 1055: RETCODE := MSC_UTIL.G_ERROR;

1051: scenario_name := 'MAIL';
1052: scenario_version := '001';
1053: scenario_param := '';
1054: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
1055: RETCODE := MSC_UTIL.G_ERROR;
1056: RETURN;
1057: ELSE
1058: /* Executing Mail Scenario */
1059: scenario_name := 'MAIL';

Line 1068: RETCODE := MSC_UTIL.G_ERROR;

1064: ELSE
1065: scenario_name :='MAIL';
1066: scenario_param:='';
1067: ret_value4 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1068: RETCODE := MSC_UTIL.G_ERROR;
1069: RETURN;
1070: END IF;
1071:
1072: /* Launching Publish Planning Results Post-Proces Custom Hook*/

Line 1075: IF RETCODE = MSC_UTIL.G_ERROR THEN

1071:
1072: /* Launching Publish Planning Results Post-Proces Custom Hook*/
1073: MSC_E1APS_HOOK.PUB_PLAN_RES_POST_PROCESS(ERRBUF,RETCODE);
1074:
1075: IF RETCODE = MSC_UTIL.G_ERROR THEN
1076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1077: RETCODE := MSC_UTIL.G_ERROR;
1078: RETURN;
1079: END IF;

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

1072: /* Launching Publish Planning Results Post-Proces Custom Hook*/
1073: MSC_E1APS_HOOK.PUB_PLAN_RES_POST_PROCESS(ERRBUF,RETCODE);
1074:
1075: IF RETCODE = MSC_UTIL.G_ERROR THEN
1076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1077: RETCODE := MSC_UTIL.G_ERROR;
1078: RETURN;
1079: END IF;
1080:

Line 1077: RETCODE := MSC_UTIL.G_ERROR;

1073: MSC_E1APS_HOOK.PUB_PLAN_RES_POST_PROCESS(ERRBUF,RETCODE);
1074:
1075: IF RETCODE = MSC_UTIL.G_ERROR THEN
1076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1077: RETCODE := MSC_UTIL.G_ERROR;
1078: RETURN;
1079: END IF;
1080:
1081: END PUB_PPR;

Line 1116: IF RETCODE = MSC_UTIL.G_ERROR THEN

1112:
1113: /* Launching Publish Forecast Pre-Proces Custom Hook*/
1114: MSC_E1APS_HOOK.PUB_FCST_PRE_PROCESS(ERRBUF,RETCODE);
1115:
1116: IF RETCODE = MSC_UTIL.G_ERROR THEN
1117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1118: RETCODE := MSC_UTIL.G_ERROR;
1119: RETURN;
1120: END IF;

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

1113: /* Launching Publish Forecast Pre-Proces Custom Hook*/
1114: MSC_E1APS_HOOK.PUB_FCST_PRE_PROCESS(ERRBUF,RETCODE);
1115:
1116: IF RETCODE = MSC_UTIL.G_ERROR THEN
1117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1118: RETCODE := MSC_UTIL.G_ERROR;
1119: RETURN;
1120: END IF;
1121:

Line 1118: RETCODE := MSC_UTIL.G_ERROR;

1114: MSC_E1APS_HOOK.PUB_FCST_PRE_PROCESS(ERRBUF,RETCODE);
1115:
1116: IF RETCODE = MSC_UTIL.G_ERROR THEN
1117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1118: RETCODE := MSC_UTIL.G_ERROR;
1119: RETURN;
1120: END IF;
1121:
1122: /* Checking ODI Profile*/

Line 1145: RETCODE := MSC_UTIL.G_ERROR;

1141: scenario_name := 'MAIL';
1142: scenario_version := '001';
1143: scenario_param := '';
1144: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
1145: RETCODE := MSC_UTIL.G_ERROR;
1146: RETURN;
1147: END IF;
1148: END IF;
1149: g_demantra_schema:=MSD_DEM_DEMANTRA_UTILITIES.GET_DEMANTRA_SCHEMA;

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

1196: WHEN OTHERS THEN
1197: select instr(ReturnStr,'#') into StartIndex from dual;
1198: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
1199:
1200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1201: RETCODE := MSC_UTIL.G_ERROR;
1202: RETURN ;
1203: END;
1204:

Line 1201: RETCODE := MSC_UTIL.G_ERROR;

1197: select instr(ReturnStr,'#') into StartIndex from dual;
1198: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
1199:
1200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1201: RETCODE := MSC_UTIL.G_ERROR;
1202: RETURN ;
1203: END;
1204:
1205: IF(length(ErrMessage) > 0) THEN

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

1202: RETURN ;
1203: END;
1204:
1205: IF(length(ErrMessage) > 0) THEN
1206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1207: RETCODE := MSC_UTIL.G_ERROR;
1208: RETURN;
1209: END IF;
1210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');

Line 1207: RETCODE := MSC_UTIL.G_ERROR;

1203: END;
1204:
1205: IF(length(ErrMessage) > 0) THEN
1206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1207: RETCODE := MSC_UTIL.G_ERROR;
1208: RETURN;
1209: END IF;
1210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
1211:

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

1206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1207: RETCODE := MSC_UTIL.G_ERROR;
1208: RETURN;
1209: END IF;
1210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
1211:
1212: END IF;
1213:
1214: /* Launching Demantra Workflow using function PUBLISH_DEM_WORKFLOW*/

Line 1233: RETCODE := MSC_UTIL.G_ERROR;

1229: scenario_name := 'MAIL';
1230: scenario_version := '001';
1231: scenario_param := '';
1232: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
1233: RETCODE := MSC_UTIL.G_ERROR;
1234: RETURN;
1235: ELSE
1236: /* Executing Mail Scenario */
1237: scenario_name := 'MAIL';

Line 1246: RETCODE := MSC_UTIL.G_ERROR;

1242: ELSIF ret_value = MSC_E1APS_UTIL.DEM_FAILURE THEN
1243: scenario_name :='MAIL';
1244: scenario_param:='';
1245: ret_value1 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1246: RETCODE := MSC_UTIL.G_ERROR;
1247: RETURN;
1248:
1249: ELSIF ret_value = MSC_E1APS_UTIL.DEM_WARNING THEN
1250: scenario_name :='MAIL';

Line 1253: RETCODE := MSC_UTIL.G_WARNING;

1249: ELSIF ret_value = MSC_E1APS_UTIL.DEM_WARNING THEN
1250: scenario_name :='MAIL';
1251: scenario_param:='';
1252: ret_value1 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1253: RETCODE := MSC_UTIL.G_WARNING;
1254: RETURN;
1255: END IF;
1256:
1257: /* Launching Publish Forecast Post-Proces Custom Hook*/

Line 1260: IF RETCODE = MSC_UTIL.G_ERROR THEN

1256:
1257: /* Launching Publish Forecast Post-Proces Custom Hook*/
1258: MSC_E1APS_HOOK.PUB_FCST_POST_PROCESS(ERRBUF,RETCODE);
1259:
1260: IF RETCODE = MSC_UTIL.G_ERROR THEN
1261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1262: RETCODE := MSC_UTIL.G_ERROR;
1263: RETURN;
1264: END IF;

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

1257: /* Launching Publish Forecast Post-Proces Custom Hook*/
1258: MSC_E1APS_HOOK.PUB_FCST_POST_PROCESS(ERRBUF,RETCODE);
1259:
1260: IF RETCODE = MSC_UTIL.G_ERROR THEN
1261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1262: RETCODE := MSC_UTIL.G_ERROR;
1263: RETURN;
1264: END IF;
1265: END DEM_PUB_FSS;

Line 1262: RETCODE := MSC_UTIL.G_ERROR;

1258: MSC_E1APS_HOOK.PUB_FCST_POST_PROCESS(ERRBUF,RETCODE);
1259:
1260: IF RETCODE = MSC_UTIL.G_ERROR THEN
1261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1262: RETCODE := MSC_UTIL.G_ERROR;
1263: RETURN;
1264: END IF;
1265: END DEM_PUB_FSS;
1266:

Line 1295: IF RETCODE = MSC_UTIL.G_ERROR THEN

1291: BEGIN
1292: /* Launching Publish PTP Pre-Proces Custom Hook*/
1293: MSC_E1APS_HOOK.PUB_PTP_RES_PRE_PROCESS(ERRBUF,RETCODE);
1294:
1295: IF RETCODE = MSC_UTIL.G_ERROR THEN
1296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1297: RETCODE := MSC_UTIL.G_ERROR;
1298: RETURN;
1299: END IF;

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

1292: /* Launching Publish PTP Pre-Proces Custom Hook*/
1293: MSC_E1APS_HOOK.PUB_PTP_RES_PRE_PROCESS(ERRBUF,RETCODE);
1294:
1295: IF RETCODE = MSC_UTIL.G_ERROR THEN
1296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1297: RETCODE := MSC_UTIL.G_ERROR;
1298: RETURN;
1299: END IF;
1300:

Line 1297: RETCODE := MSC_UTIL.G_ERROR;

1293: MSC_E1APS_HOOK.PUB_PTP_RES_PRE_PROCESS(ERRBUF,RETCODE);
1294:
1295: IF RETCODE = MSC_UTIL.G_ERROR THEN
1296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1297: RETCODE := MSC_UTIL.G_ERROR;
1298: RETURN;
1299: END IF;
1300:
1301: /* Checking ODI Profile*/

Line 1324: RETCODE := MSC_UTIL.G_ERROR;

1320: IF pre_process_odi = FALSE THEN
1321: /* Executing Mail Scenario */
1322: scenario_version := '001';
1323: ret_value1 :=CALL_ODIEXE('MAIL',scenario_version,'', odi_url);
1324: RETCODE := MSC_UTIL.G_ERROR;
1325: RETURN ;
1326: END IF;
1327: END IF;
1328:

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

1347: WHEN OTHERS THEN
1348: select instr(ReturnStr,'#') into StartIndex from dual;
1349: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
1350:
1351: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1352: RETCODE := MSC_UTIL.G_ERROR;
1353: RETURN;
1354: END;
1355: IF(length(ErrMessage) > 0) THEN

Line 1352: RETCODE := MSC_UTIL.G_ERROR;

1348: select instr(ReturnStr,'#') into StartIndex from dual;
1349: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
1350:
1351: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1352: RETCODE := MSC_UTIL.G_ERROR;
1353: RETURN;
1354: END;
1355: IF(length(ErrMessage) > 0) THEN
1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);

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

1352: RETCODE := MSC_UTIL.G_ERROR;
1353: RETURN;
1354: END;
1355: IF(length(ErrMessage) > 0) THEN
1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1357: RETCODE := MSC_UTIL.G_ERROR;
1358: RETURN;
1359: END IF;
1360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');

Line 1357: RETCODE := MSC_UTIL.G_ERROR;

1353: RETURN;
1354: END;
1355: IF(length(ErrMessage) > 0) THEN
1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1357: RETCODE := MSC_UTIL.G_ERROR;
1358: RETURN;
1359: END IF;
1360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
1361:

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

1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1357: RETCODE := MSC_UTIL.G_ERROR;
1358: RETURN;
1359: END IF;
1360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
1361:
1362: END IF;
1363:
1364: /* Launching Demantra Workflow using function PUBLISH_DEM_WORKFLOW*/

Line 1373: RETCODE := MSC_UTIL.G_ERROR;

1369: scenario_name := 'MAIL';
1370: scenario_version := '001';
1371: scenario_param := '';
1372: ret_value1 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1373: RETCODE := MSC_UTIL.G_ERROR;
1374: RETURN;
1375: END IF;
1376:
1377: IF ret_value2 = MSC_E1APS_UTIL.DEM_WARNING THEN

Line 1382: RETCODE := MSC_UTIL.G_WARNING;

1378: scenario_name := 'MAIL';
1379: scenario_version := '001';
1380: scenario_param := '';
1381: ret_value1 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1382: RETCODE := MSC_UTIL.G_WARNING;
1383: RETURN;
1384: END IF;
1385:
1386:

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

1396: scenario_name := 'MAIL';
1397: scenario_version := '001';
1398: scenario_param := '';
1399: ret_value1 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
1401: RETCODE := MSC_UTIL.G_ERROR;
1402: RETURN;
1403: END IF;
1404: END IF; */

Line 1401: RETCODE := MSC_UTIL.G_ERROR;

1397: scenario_version := '001';
1398: scenario_param := '';
1399: ret_value1 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
1401: RETCODE := MSC_UTIL.G_ERROR;
1402: RETURN;
1403: END IF;
1404: END IF; */
1405: ret_value := FALSE;

Line 1430: RETCODE := MSC_UTIL.G_ERROR;

1426: scenario_name := 'MAIL';
1427: scenario_version := '001';
1428: scenario_param := '';
1429: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
1430: RETCODE := MSC_UTIL.G_ERROR;
1431: RETURN;
1432: ELSE
1433: /* Executing Mail Scenario */
1434: scenario_name := 'MAIL';

Line 1444: RETCODE := MSC_UTIL.G_ERROR;

1440: scenario_name := 'MAIL';
1441: scenario_param := '';
1442: scenario_version := '001';
1443: ret_value1 :=CALL_ODIEXE(scenario_name ,scenario_version,scenario_param ,odi_url);
1444: RETCODE := MSC_UTIL.G_ERROR;
1445: RETURN;
1446: END IF;
1447:
1448: /* Launching Publish PTP Post-Proces Custom Hook*/

Line 1451: IF RETCODE = MSC_UTIL.G_ERROR THEN

1447:
1448: /* Launching Publish PTP Post-Proces Custom Hook*/
1449: MSC_E1APS_HOOK.PUB_PTP_RES_PRE_PROCESS(ERRBUF,RETCODE);
1450:
1451: IF RETCODE = MSC_UTIL.G_ERROR THEN
1452: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1453: RETCODE := MSC_UTIL.G_ERROR;
1454: RETURN;
1455: END IF;

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

1448: /* Launching Publish PTP Post-Proces Custom Hook*/
1449: MSC_E1APS_HOOK.PUB_PTP_RES_PRE_PROCESS(ERRBUF,RETCODE);
1450:
1451: IF RETCODE = MSC_UTIL.G_ERROR THEN
1452: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1453: RETCODE := MSC_UTIL.G_ERROR;
1454: RETURN;
1455: END IF;
1456:

Line 1453: RETCODE := MSC_UTIL.G_ERROR;

1449: MSC_E1APS_HOOK.PUB_PTP_RES_PRE_PROCESS(ERRBUF,RETCODE);
1450:
1451: IF RETCODE = MSC_UTIL.G_ERROR THEN
1452: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1453: RETCODE := MSC_UTIL.G_ERROR;
1454: RETURN;
1455: END IF;
1456:
1457: END DEM_PUB_PTP;

Line 1485: IF RETCODE = MSC_UTIL.G_ERROR THEN

1481:
1482: /* Launching Publish DSM Pre-Proces Custom Hook*/
1483: MSC_E1APS_HOOK.PUB_DSM_RES_PRE_PROCESS(ERRBUF,RETCODE);
1484:
1485: IF RETCODE = MSC_UTIL.G_ERROR THEN
1486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1487: RETCODE := MSC_UTIL.G_ERROR;
1488: RETURN;
1489: END IF;

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

1482: /* Launching Publish DSM Pre-Proces Custom Hook*/
1483: MSC_E1APS_HOOK.PUB_DSM_RES_PRE_PROCESS(ERRBUF,RETCODE);
1484:
1485: IF RETCODE = MSC_UTIL.G_ERROR THEN
1486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1487: RETCODE := MSC_UTIL.G_ERROR;
1488: RETURN;
1489: END IF;
1490:

Line 1487: RETCODE := MSC_UTIL.G_ERROR;

1483: MSC_E1APS_HOOK.PUB_DSM_RES_PRE_PROCESS(ERRBUF,RETCODE);
1484:
1485: IF RETCODE = MSC_UTIL.G_ERROR THEN
1486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1487: RETCODE := MSC_UTIL.G_ERROR;
1488: RETURN;
1489: END IF;
1490:
1491: /* Checking ODI Profile*/

Line 1513: RETCODE := MSC_UTIL.G_ERROR;

1509: IF pre_process_odi = FALSE THEN
1510: /* Executing Mail Scenario */
1511: scenario_version := '001';
1512: ret_value1 :=CALL_ODIEXE('MAIL',scenario_version,'', odi_url);
1513: RETCODE := MSC_UTIL.G_ERROR;
1514: RETURN ;
1515: END IF;
1516: END IF;
1517:

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

1531: WHEN OTHERS THEN
1532: select instr(ReturnStr,'#') into StartIndex from dual;
1533: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
1534:
1535: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1536: RETCODE := MSC_UTIL.G_ERROR;
1537: RETURN;
1538: END;
1539: IF(length(ErrMessage) > 0) THEN

Line 1536: RETCODE := MSC_UTIL.G_ERROR;

1532: select instr(ReturnStr,'#') into StartIndex from dual;
1533: select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
1534:
1535: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1536: RETCODE := MSC_UTIL.G_ERROR;
1537: RETURN;
1538: END;
1539: IF(length(ErrMessage) > 0) THEN
1540: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);

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

1536: RETCODE := MSC_UTIL.G_ERROR;
1537: RETURN;
1538: END;
1539: IF(length(ErrMessage) > 0) THEN
1540: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1541: RETCODE := MSC_UTIL.G_ERROR;
1542: RETURN;
1543: END IF;
1544: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');

Line 1541: RETCODE := MSC_UTIL.G_ERROR;

1537: RETURN;
1538: END;
1539: IF(length(ErrMessage) > 0) THEN
1540: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1541: RETCODE := MSC_UTIL.G_ERROR;
1542: RETURN;
1543: END IF;
1544: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
1545:

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

1540: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Intialization failed. Error message' || ErrMessage);
1541: RETCODE := MSC_UTIL.G_ERROR;
1542: RETURN;
1543: END IF;
1544: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
1545:
1546: END IF;
1547:
1548: /* Bug#8224935 - APP ID */

Line 1550: IF p_pb_claims = MSC_UTIL.SYS_YES THEN

1546: END IF;
1547:
1548: /* Bug#8224935 - APP ID */
1549: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_PTP', 1, 'user_id'));
1550: IF p_pb_claims = MSC_UTIL.SYS_YES THEN
1551: l_wf_lookup_code := 'WF_AIA_DSM_E1_CLAIM_EXP';
1552: scenario_name := 'LOADDMCLAIMDATATOE1PKG';
1553: ret_value:=MSC_E1APS_UTIL.PUBLISH_DEM_WORKFLOW(ERRBUF ,RETCODE ,p_instance_id ,l_wf_lookup_code ,scenario_name,l_user_id);
1554:

Line 1556: RETCODE := MSC_UTIL.G_ERROR;

1552: scenario_name := 'LOADDMCLAIMDATATOE1PKG';
1553: ret_value:=MSC_E1APS_UTIL.PUBLISH_DEM_WORKFLOW(ERRBUF ,RETCODE ,p_instance_id ,l_wf_lookup_code ,scenario_name,l_user_id);
1554:
1555: IF ret_value = MSC_E1APS_UTIL.DEM_FAILURE THEN
1556: RETCODE := MSC_UTIL.G_ERROR;
1557: RETURN;
1558: END IF;
1559:
1560: IF ret_value = MSC_E1APS_UTIL.DEM_WARNING THEN

Line 1561: RETCODE := MSC_UTIL.G_WARNING;

1557: RETURN;
1558: END IF;
1559:
1560: IF ret_value = MSC_E1APS_UTIL.DEM_WARNING THEN
1561: RETCODE := MSC_UTIL.G_WARNING;
1562: RETURN;
1563: END IF;
1564: END IF;
1565:

Line 1566: IF p_pb_dedu_dispos = MSC_UTIL.SYS_YES THEN

1562: RETURN;
1563: END IF;
1564: END IF;
1565:
1566: IF p_pb_dedu_dispos = MSC_UTIL.SYS_YES THEN
1567: l_wf_lookup_code := 'WF_AIA_DSM_E1_DEDUCT_EXP';
1568: scenario_name := 'LOADDMDEDDISPOSITIONSDATATOE1PKG';
1569: ret_value:=MSC_E1APS_UTIL.PUBLISH_DEM_WORKFLOW(ERRBUF ,RETCODE ,p_instance_id ,l_wf_lookup_code ,scenario_name ,l_user_id);
1570:

Line 1576: RETCODE := MSC_UTIL.G_ERROR;

1572: scenario_name := 'MAIL';
1573: scenario_version := '001';
1574: scenario_param := '';
1575: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
1576: RETCODE := MSC_UTIL.G_ERROR;
1577: RETURN;
1578: END IF;
1579:
1580: IF ret_value = MSC_E1APS_UTIL.DEM_WARNING THEN

Line 1585: RETCODE := MSC_UTIL.G_WARNING;

1581: scenario_name := 'MAIL';
1582: scenario_version := '001';
1583: scenario_param := '';
1584: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
1585: RETCODE := MSC_UTIL.G_WARNING;
1586: RETURN;
1587: END IF;
1588: END IF;
1589:

Line 1607: RETCODE := MSC_UTIL.G_ERROR;

1603: scenario_name := 'MAIL';
1604: scenario_version := '001';
1605: scenario_param := '';
1606: ret_value1 :=CALL_ODIEXE(scenario_name, scenario_version, scenario_param, odi_url);
1607: RETCODE := MSC_UTIL.G_ERROR;
1608: RETURN;
1609: ELSE
1610: /* Executing Mail Scenario */
1611: scenario_name := 'MAIL';

Line 1620: RETCODE := MSC_UTIL.G_ERROR;

1616: ELSE
1617: scenario_name :='MAIL';
1618: scenario_param:='';
1619: ret_value1 :=CALL_ODIEXE(scenario_name ,scenario_version ,scenario_param ,odi_url);
1620: RETCODE := MSC_UTIL.G_ERROR;
1621: RETURN;
1622: END IF;
1623:
1624: /* Launching Publish DSM Post-Proces Custom Hook*/

Line 1627: IF RETCODE = MSC_UTIL.G_ERROR THEN

1623:
1624: /* Launching Publish DSM Post-Proces Custom Hook*/
1625: MSC_E1APS_HOOK.PUB_DSM_RES_PRE_PROCESS(ERRBUF,RETCODE);
1626:
1627: IF RETCODE = MSC_UTIL.G_ERROR THEN
1628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1629: RETCODE := MSC_UTIL.G_ERROR;
1630: RETURN;
1631: END IF;

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

1624: /* Launching Publish DSM Post-Proces Custom Hook*/
1625: MSC_E1APS_HOOK.PUB_DSM_RES_PRE_PROCESS(ERRBUF,RETCODE);
1626:
1627: IF RETCODE = MSC_UTIL.G_ERROR THEN
1628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1629: RETCODE := MSC_UTIL.G_ERROR;
1630: RETURN;
1631: END IF;
1632:

Line 1629: RETCODE := MSC_UTIL.G_ERROR;

1625: MSC_E1APS_HOOK.PUB_DSM_RES_PRE_PROCESS(ERRBUF,RETCODE);
1626:
1627: IF RETCODE = MSC_UTIL.G_ERROR THEN
1628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error Message:' || ERRBUF);
1629: RETCODE := MSC_UTIL.G_ERROR;
1630: RETURN;
1631: END IF;
1632:
1633: END DEM_PUB_DSM;