APPS.MSD_DEM_PROCESS_SALES_DATA dependencies on MSD_DEM_PROCESS_SALES_DATA

Line 1: PACKAGE BODY MSD_DEM_PROCESS_SALES_DATA AS -- body

1: PACKAGE BODY MSD_DEM_PROCESS_SALES_DATA AS -- body
2: /* $Header: MSDDEMSDB.pls 120.13 2011/06/02 07:03:17 mpmurali ship $ */
3:
4: NULL_CHAR CONSTANT VARCHAR2(6) := '-23453';
5:

Line 139: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('

135: EXCEPTION
136: WHEN OTHERS THEN
137: LOG_MESSAGE ('An error occured while generating Source Keys for Entity - '||l_entity_name);
138:
139: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('
140: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
141: LOG_MESSAGE(lv_error_text);
142:
143: ERRBUF := lv_error_text;

Line 176: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('

172: EXCEPTION
173: WHEN OTHERS THEN
174: LOG_MESSAGE ('An error occured while generating Source Keys for Entity - '||l_entity_name);
175:
176: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('
177: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
178: LOG_MESSAGE(lv_error_text);
179:
180: ERRBUF := lv_error_text;

Line 258: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('

254: EXCEPTION
255: WHEN OTHERS THEN
256: LOG_MESSAGE ('An error occured while generating Source Keys for Entity - '||l_entity_name);
257:
258: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('
259: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
260: LOG_MESSAGE(lv_error_text);
261:
262: ERRBUF := lv_error_text;

Line 309: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('

305: EXCEPTION
306: WHEN OTHERS THEN
307: LOG_MESSAGE ('An error occured while generating Source Keys for Entity - '||l_entity_name);
308:
309: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('
310: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
311: LOG_MESSAGE(lv_error_text);
312:
313: ERRBUF := lv_error_text;

Line 361: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('

357: EXCEPTION
358: WHEN OTHERS THEN
359: LOG_MESSAGE ('An error occured while generating Source Keys for Entity - '||l_entity_name);
360:
361: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('
362: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
363: LOG_MESSAGE(lv_error_text);
364:
365: ERRBUF := lv_error_text;

Line 403: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('

399: EXCEPTION
400: WHEN OTHERS THEN
401: LOG_MESSAGE ('An error occured while generating Source Keys for Entity - '||l_entity_name);
402:
403: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('
404: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
405: LOG_MESSAGE(lv_error_text);
406:
407: ERRBUF := lv_error_text;

Line 425: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_process_sales_data.launch - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

421: p_instance_id);
422:
423: IF (retcode = 1)
424: THEN
425: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_process_sales_data.launch - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
426: msd_dem_common_utilities.log_message ('Error while inserting dummy rows into the sales staging table for new items. ');
427: END IF;
428:
429:

Line 443: msd_dem_common_utilities.log_message ('MSD_DEM_PROCESS_SALES_DATA.LAUNCH - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

439: IF (l_dest_table is NULL)
440: THEN
441: RETCODE := -1;
442: ERRBUF := 'Unable to find the sales staging tables.';
443: msd_dem_common_utilities.log_message ('MSD_DEM_PROCESS_SALES_DATA.LAUNCH - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
444: msd_dem_common_utilities.log_message (ERRBUF);
445: RETURN;
446: END IF;
447:

Line 467: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('

463: EXCEPTION
464: WHEN OTHERS THEN
465: LOG_MESSAGE ('Error generating Source Keys');
466:
467: lv_error_text := substr('MSD_DEM_PROCESS_SALES_DATA.LAUNCH '||'('
468: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
469: LOG_MESSAGE(lv_error_text);
470:
471: ERRBUF := lv_error_text;

Line 476: END MSD_DEM_PROCESS_SALES_DATA;

472: RETCODE := G_ERROR;
473:
474: END LAUNCH;
475:
476: END MSD_DEM_PROCESS_SALES_DATA;