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.MSD_DEM_SOP dependencies on MSD_DEM_SOP

Line 1: PACKAGE BODY MSD_DEM_SOP AS

1: PACKAGE BODY MSD_DEM_SOP AS
2: /* $Header: msddemsopb.pls 120.17.12010000.3 2008/08/28 12:02:14 syenamar ship $ */
3:
4:
5: /*** CUSTOM DATA TYPES ***/

Line 137: log_debug ('Entering: msd_dem_sop.truncate_staging_tables - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

133: IS
134: x_table_name VARCHAR2(60) := NULL;
135: BEGIN
136:
137: log_debug ('Entering: msd_dem_sop.truncate_staging_tables - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
138:
139:
140: x_table_name := g_schema || '.BIIO_RESOURCE_CAPACITY';
141: log_message ('Truncating table ' || x_table_name || ' ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 228: log_debug ('Exiting: msd_dem_sop.truncate_staging_tables - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

224: x_table_name := g_schema || '.T_SRC_LOC_TMPL_ERR';
225: log_message ('Truncating table ' || x_table_name || ' ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
226: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || x_table_name;
227:
228: log_debug ('Exiting: msd_dem_sop.truncate_staging_tables - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
229:
230: EXCEPTION
231: WHEN OTHERS THEN
232: retcode := -1;

Line 234: log_message ('Exception(1): msd_dem_sop.truncate_staging_tables - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

230: EXCEPTION
231: WHEN OTHERS THEN
232: retcode := -1;
233: errbuf := substr(SQLERRM,1,150);
234: log_message ('Exception(1): msd_dem_sop.truncate_staging_tables - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
235: RETURN;
236: END TRUNCATE_STAGING_TABLES;
237:
238:

Line 285: log_debug ('Entering: msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

281:
282: /*** LOCAL VARIABLES - END ***/
283:
284: BEGIN
285: log_debug ('Entering: msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
286:
287: /* Validate INPUT Parameters */
288: IF (p_series_id IS NULL OR p_plan_id IS NULL)
289: THEN

Line 290: log_message ('Error(1): msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') ||

286:
287: /* Validate INPUT Parameters */
288: IF (p_series_id IS NULL OR p_plan_id IS NULL)
289: THEN
290: log_message ('Error(1): msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') ||
291: ' - One or Both the parameters passed to the procedure is/are NULL.');
292: RETURN;
293: END IF;
294:

Line 308: log_message ('Error(2): msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') ||

304: IF ( x_series_name IS NULL
305: OR x_series_type IS NULL
306: OR x_identifier IS NULL)
307: THEN
308: log_message ('Error(2): msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') ||
309: ' - Unable to get series info for id - ' || to_char(p_series_id));
310: RETURN;
311: END IF;
312:

Line 351: log_message ('Error(3): msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') ||

347: x_view_name);
348:
349: IF (x_retcode = -1)
350: THEN
351: log_message ('Error(3): msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') ||
352: ' - Unable to get query for identifier - ' || x_identifier);
353: RETURN;
354: END IF;
355:

Line 367: log_message ('Exception(1): msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

363: EXCEPTION
364: WHEN OTHERS THEN
365: retcode := -1;
366: errbuf := substr(SQLERRM,1,150);
367: log_message ('Exception(1): msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
368: RETURN;
369: END;
370:
371:

Line 374: log_debug ('Exiting: msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

370:
371:
372: log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
373:
374: log_debug ('Exiting: msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
375: EXCEPTION
376: WHEN OTHERS THEN
377: retcode := -1;
378: errbuf := substr(SQLERRM,1,150);

Line 379: log_message ('Exception(2): msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

375: EXCEPTION
376: WHEN OTHERS THEN
377: retcode := -1;
378: errbuf := substr(SQLERRM,1,150);
379: log_message ('Exception(2): msd_dem_sop.load_series_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
380: RETURN;
381: END LOAD_SERIES_DATA;
382:
383:

Line 424: log_debug ('Entering: msd_dem_sop.pre_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

420:
421: /*** LOCAL VARIABLES - END ***/
422:
423: BEGIN
424: log_debug ('Entering: msd_dem_sop.pre_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
425:
426: /***** 1. DECIDE UPON HOW TO HANDLE CONCURRENCY *****/
427: /***** Handled in WAIT_UNTIL_DOWNLOAD_COMPLETE *****/
428:

Line 446: log_message ('Error(2): msd_dem_sop.pre_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

442: IF (x_retcode = -1)
443: THEN
444: retcode := -1;
445: errbuf := x_errbuf;
446: log_message ('Error(2): msd_dem_sop.pre_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
447: RETURN;
448: END IF;
449:
450: log_debug ('End Of Loop for series id - ' || to_number(rec.series_id) || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 508: log_debug ('Exiting: msd_dem_sop.pre_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

504: end if;
505:
506:
507:
508: log_debug ('Exiting: msd_dem_sop.pre_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
509: EXCEPTION
510: WHEN OTHERS THEN
511: retcode := -1;
512: errbuf := substr(SQLERRM,1,150);

Line 513: log_message ('Exception: msd_dem_sop.pre_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

509: EXCEPTION
510: WHEN OTHERS THEN
511: retcode := -1;
512: errbuf := substr(SQLERRM,1,150);
513: log_message ('Exception: msd_dem_sop.pre_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
514: RETURN;
515: END PRE_DOWNLOAD_HOOK;
516:
517:

Line 550: log_debug ('Entering: msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

546:
547: /*** LOCAL VARIABLES - END ***/
548:
549: BEGIN
550: log_debug ('Entering: msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
551:
552: /* Get the lowest time bucket */
553: x_dm_time_bucket := msd_dem_common_utilities.dm_time_level;
554: IF (x_dm_time_bucket IS NULL)

Line 558: log_message('Error(1): msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

554: IF (x_dm_time_bucket IS NULL)
555: THEN
556: retcode := -1;
557: errbuf := 'Unable to get lowest time bucket';
558: log_message('Error(1): msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
559: RETURN;
560: ELSIF (upper(x_dm_time_bucket) = 'DAY')
561: THEN
562: x_dm_time_level := 1;

Line 582: log_message ('Error(2): msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

578: IF (x_retcode = -1)
579: THEN
580: retcode := -1;
581: errbuf := x_errbuf;
582: log_message ('Error(2): msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
583: RETURN;
584: END IF;
585:
586: COMMIT;

Line 614: log_message ('Exception(1): msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

610: EXCEPTION
611: WHEN OTHERS THEN
612: retcode := -1;
613: errbuf := substr(SQLERRM,1,150);
614: log_message ('Exception(1): msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
615: RETURN;
616: END;
617:
618: COMMIT;

Line 651: log_message ('Exception(2): msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

647: EXCEPTION
648: WHEN OTHERS THEN
649: retcode := -1;
650: errbuf := substr(SQLERRM,1,150);
651: log_message ('Exception(2): msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
652: RETURN;
653: END;
654:
655: COMMIT;

Line 659: log_debug ('Exiting: msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

655: COMMIT;
656:
657: log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
658:
659: log_debug ('Exiting: msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
660: EXCEPTION
661: WHEN OTHERS THEN
662: retcode := -1;
663: errbuf := substr(SQLERRM,1,150);

Line 664: log_message ('Exception(3): msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

660: EXCEPTION
661: WHEN OTHERS THEN
662: retcode := -1;
663: errbuf := substr(SQLERRM,1,150);
664: log_message ('Exception(3): msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
665: RETURN;
666: END LOAD_ASCP_DATA;
667:
668:

Line 696: log_debug ('Entering: msd_dem_sop.push_time_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

692: /*** LOCAL VARIABLES - END ***/
693:
694: BEGIN
695:
696: log_debug ('Entering: msd_dem_sop.push_time_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
697:
698: IF (C_MSD_DEM_PUSH_TIME = 'N')
699: THEN
700: log_debug ('Table msd_dem_dates has already been populated for this session.');

Line 763: log_debug ('Exiting: msd_dem_sop.push_time_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

759: COMMIT;
760:
761: C_MSD_DEM_PUSH_TIME := 'N';
762:
763: log_debug ('Exiting: msd_dem_sop.push_time_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
764:
765: EXCEPTION
766: WHEN OTHERS THEN
767: retcode := -1;

Line 769: log_message ('Exception: msd_dem_sop.push_time_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

765: EXCEPTION
766: WHEN OTHERS THEN
767: retcode := -1;
768: errbuf := substr(SQLERRM,1,150);
769: log_message ('Exception: msd_dem_sop.push_time_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
770: RETURN;
771: END PUSH_TIME_DATA;
772:
773:

Line 833: log_message ('Error(1): msd_dem_sop.load_plan_data - Unable to find schema name');

829:
830: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
831: IF (g_schema IS NULL)
832: THEN
833: log_message ('Error(1): msd_dem_sop.load_plan_data - Unable to find schema name');
834: END IF;
835:
836: l_sql := 'select scenario_status_id from '|| g_schema||'.supply_plan where plan_id = '||p_plan_id;
837:

Line 1358: log_message ('Error: msd_dem_sop.set_plan_attributes - Unable to find schema name');

1354:
1355: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
1356: IF (g_schema IS NULL)
1357: THEN
1358: log_message ('Error: msd_dem_sop.set_plan_attributes - Unable to find schema name');
1359: END IF;
1360:
1361: load_plan_gl(p_plan_id, 0);
1362:

Line 1405: log_message ('Error(1): msd_dem_sop.load_plan_data - Unable to find schema name');

1401:
1402: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
1403: IF (g_schema IS NULL)
1404: THEN
1405: log_message ('Error(1): msd_dem_sop.load_plan_data - Unable to find schema name');
1406: RETURN;
1407: END IF;
1408:
1409: /* Alter session to demantra schema */

Line 1412: log_debug ('Entering: msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1408:
1409: /* Alter session to demantra schema */
1410: x_small_sql := 'alter session set current_schema = ' || g_schema;
1411:
1412: log_debug ('Entering: msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1413:
1414: /* Get plan id of the supply plan */
1415: x_plan_id := get_plan_id (p_member_id);
1416: IF (x_plan_id IS NULL)

Line 1418: log_message ('Error(2): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') ||

1414: /* Get plan id of the supply plan */
1415: x_plan_id := get_plan_id (p_member_id);
1416: IF (x_plan_id IS NULL)
1417: THEN
1418: log_message ('Error(2): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') ||
1419: ' - Unable to get plan id for the given plan scenario member id : ' || to_char(p_member_id));
1420: EXECUTE IMMEDIATE x_small_sql;
1421: RETURN;
1422: END IF;

Line 1428: log_message ('Error(3): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') ||

1424: /* Get plan type of the supply plan */
1425: x_plan_type := get_plan_type (p_member_id);
1426: IF (x_plan_type IS NULL)
1427: THEN
1428: log_message ('Error(3): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') ||
1429: ' - Unable to get plan type for the given plan scenario member id : ' || to_char(p_member_id));
1430: EXECUTE IMMEDIATE x_small_sql;
1431: RETURN;
1432: END IF;

Line 1440: log_message ('Error(4): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') ||

1436: x_errbuf,
1437: x_retcode);
1438: IF (x_retcode = -1)
1439: THEN
1440: log_message ('Error(4): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') ||
1441: ' - ' || x_errbuf );
1442: EXECUTE IMMEDIATE x_small_sql;
1443: RETURN;
1444: END IF;

Line 1454: log_message ('Error(4): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || x_errbuf);

1450: x_retcode,
1451: x_plan_id);
1452: IF (x_retcode = -1)
1453: THEN
1454: log_message ('Error(4): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || x_errbuf);
1455: EXECUTE IMMEDIATE x_small_sql;
1456: RETURN;
1457: END IF;
1458:

Line 1469: log_message ('Error(5): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || x_errbuf);

1465: x_errbuf,
1466: x_retcode);
1467: IF (x_retcode = -1)
1468: THEN
1469: log_message ('Error(5): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || x_errbuf);
1470: EXECUTE IMMEDIATE x_small_sql;
1471: RETURN;
1472: END IF;
1473:

Line 1480: log_message ('Error(6): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || x_errbuf);

1476: x_retcode,
1477: x_plan_id);
1478: IF (x_retcode = -1)
1479: THEN
1480: log_message ('Error(6): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || x_errbuf);
1481: EXECUTE IMMEDIATE x_small_sql;
1482: RETURN;
1483: END IF;
1484:

Line 1491: log_message ('Error(7): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || 'Error in call to SNOP_DATA_LOAD.SNO_LOAD_DATA');

1487: x_sno_sql := 'BEGIN ' || g_schema || '.SNOP_DATA_LOAD.SNO_LOAD_DATA(''' || x_plan_id || '''); END;';
1488: EXECUTE IMMEDIATE x_sno_sql;
1489: EXCEPTION
1490: WHEN OTHERS THEN
1491: log_message ('Error(7): msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || 'Error in call to SNOP_DATA_LOAD.SNO_LOAD_DATA');
1492: EXECUTE IMMEDIATE x_small_sql;
1493: RETURN;
1494: END;
1495: END IF;

Line 1508: log_debug ('Exiting: msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1504: /* Load Item Location */
1505: load_item_locs (x_plan_id);
1506:
1507:
1508: log_debug ('Exiting: msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1509:
1510:
1511: /* Alter session to demantra schema */
1512: x_small_sql := 'alter session set current_schema = ' || g_schema;

Line 1517: log_message ('Exception: msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1513: EXECUTE IMMEDIATE x_small_sql;
1514:
1515: EXCEPTION
1516: WHEN OTHERS THEN
1517: log_message ('Exception: msd_dem_sop.load_plan_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1518: log_message (substr(SQLERRM,1,150));
1519:
1520: /* Alter session to demantra schema */
1521: x_small_sql := 'alter session set current_schema = ' || g_schema;

Line 1539: log_debug ('Entering: msd_dem_sop.load_plan_members - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1535: IS
1536: x_small_sql varchar2(1000);
1537: BEGIN
1538:
1539: log_debug ('Entering: msd_dem_sop.load_plan_members - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1540:
1541: /* Alter session to APPS */
1542: x_small_sql := 'alter session set current_schema = APPS';
1543: EXECUTE IMMEDIATE x_small_sql;

Line 1548: log_message ('Error(1): msd_dem_sop.load_plan_data - Unable to find schema name');

1544:
1545: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
1546: IF (g_schema IS NULL)
1547: THEN
1548: log_message ('Error(1): msd_dem_sop.load_plan_data - Unable to find schema name');
1549: END IF;
1550:
1551: load_plan_gl(NULL, 0);
1552:

Line 1557: log_debug ('Exiting: msd_dem_sop.load_plan_members - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1553: /* Alter session to demantra schema */
1554: x_small_sql := 'alter session set current_schema = ' || g_schema;
1555: EXECUTE IMMEDIATE x_small_sql;
1556:
1557: log_debug ('Exiting: msd_dem_sop.load_plan_members - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1558: EXCEPTION
1559: WHEN OTHERS THEN
1560: log_message ('Exception: msd_dem_sop.load_plan_members - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1561: log_message (substr(SQLERRM,1,150));

Line 1560: log_message ('Exception: msd_dem_sop.load_plan_members - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1556:
1557: log_debug ('Exiting: msd_dem_sop.load_plan_members - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1558: EXCEPTION
1559: WHEN OTHERS THEN
1560: log_message ('Exception: msd_dem_sop.load_plan_members - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1561: log_message (substr(SQLERRM,1,150));
1562:
1563: /* Alter session to demantra schema */
1564: x_small_sql := 'alter session set current_schema = ' || g_schema;

Line 1580: --log_debug ('Entering: msd_dem_sop.post_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1576: PROCEDURE POST_DOWNLOAD_HOOK (
1577: p_member_id IN NUMBER )
1578: IS
1579: BEGIN
1580: --log_debug ('Entering: msd_dem_sop.post_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1581: NULL;
1582: --log_debug ('Exiting: msd_dem_sop.post_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1583: EXCEPTION
1584: WHEN OTHERS THEN

Line 1582: --log_debug ('Exiting: msd_dem_sop.post_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1578: IS
1579: BEGIN
1580: --log_debug ('Entering: msd_dem_sop.post_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1581: NULL;
1582: --log_debug ('Exiting: msd_dem_sop.post_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1583: EXCEPTION
1584: WHEN OTHERS THEN
1585: --log_message ('Exception: msd_dem_sop.post_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1586: --log_message (substr(SQLERRM,1,150));

Line 1585: --log_message ('Exception: msd_dem_sop.post_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1581: NULL;
1582: --log_debug ('Exiting: msd_dem_sop.post_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1583: EXCEPTION
1584: WHEN OTHERS THEN
1585: --log_message ('Exception: msd_dem_sop.post_download_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1586: --log_message (substr(SQLERRM,1,150));
1587: RETURN;
1588:
1589: END POST_DOWNLOAD_HOOK;

Line 1620: log_message ('Error(1): msd_dem_sop.load_item_cost - Unable to find schema name');

1616:
1617: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
1618: IF (g_schema IS NULL)
1619: THEN
1620: log_message ('Error(1): msd_dem_sop.load_item_cost - Unable to find schema name');
1621: END IF;
1622:
1623:
1624: log_debug ('Entering: msd_dem_sop.load_item_cost - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 1624: log_debug ('Entering: msd_dem_sop.load_item_cost - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1620: log_message ('Error(1): msd_dem_sop.load_item_cost - Unable to find schema name');
1621: END IF;
1622:
1623:
1624: log_debug ('Entering: msd_dem_sop.load_item_cost - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1625:
1626: /* Delete all data (if any) from the staging table */
1627: x_small_sql := 'TRUNCATE TABLE ' || g_schema || '.BIIO_ITEM_COST';
1628: EXECUTE IMMEDIATE x_small_sql;

Line 1639: log_message ('Error(2): msd_dem_sop.load_item_cost - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || x_errbuf);

1635: x_errbuf,
1636: x_retcode);
1637: IF (x_retcode = -1)
1638: THEN
1639: log_message ('Error(2): msd_dem_sop.load_item_cost - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || x_errbuf);
1640: RAISE NO_DATA_FOUND;
1641: END IF;
1642:
1643: /* Load data for series Item Cost */

Line 1647: C_MSD_DEM_SOP_ITEM_COST,

1643: /* Load data for series Item Cost */
1644: load_series_data (
1645: x_errbuf,
1646: x_retcode,
1647: C_MSD_DEM_SOP_ITEM_COST,
1648: -1,
1649: 1);
1650: IF (x_retcode = -1)
1651: THEN

Line 1652: log_message ('Error(3): msd_dem_sop.load_item_cost - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || x_errbuf);

1648: -1,
1649: 1);
1650: IF (x_retcode = -1)
1651: THEN
1652: log_message ('Error(3): msd_dem_sop.load_item_cost - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || x_errbuf);
1653: RAISE NO_DATA_FOUND;
1654: END IF;
1655:
1656: COMMIT;

Line 1658: log_debug ('Exiting: msd_dem_sop.load_item_cost - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1654: END IF;
1655:
1656: COMMIT;
1657:
1658: log_debug ('Exiting: msd_dem_sop.load_item_cost - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1659:
1660:
1661: /* Alter session to demantra schema */
1662: x_small_sql := 'alter session set current_schema = ' || g_schema;

Line 1667: log_message ('Exception: msd_dem_sop.load_item_cost - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1663: EXECUTE IMMEDIATE x_small_sql;
1664:
1665: EXCEPTION
1666: WHEN OTHERS THEN
1667: log_message ('Exception: msd_dem_sop.load_item_cost - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1668: log_message (substr(SQLERRM,1,150));
1669:
1670: COMMIT;
1671:

Line 1742: msd_dem_common_utilities.log_message ('Entering: msd_dem_sop.collect_sci_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1738: lv_request_id1 NUMBER := to_number(NULL);
1739: lv_request_id2 NUMBER := to_number(NULL);
1740:
1741: BEGIN
1742: msd_dem_common_utilities.log_message ('Entering: msd_dem_sop.collect_sci_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1743:
1744:
1745: /* Launching two Conc. Programs (for each Import Integration
1746: Interfact definde for SCI Data) to have the collection

Line 1812: msd_dem_common_utilities.log_message ('Exiting: msd_dem_sop.collect_sci_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1808: END IF;
1809:
1810: COMMIT;
1811:
1812: msd_dem_common_utilities.log_message ('Exiting: msd_dem_sop.collect_sci_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: retcode := -1 ;
1816: errbuf := substr(SQLERRM,1,150);

Line 1817: msd_dem_common_utilities.log_message ('Exception: msd_dem_sop.collect_sci_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: retcode := -1 ;
1816: errbuf := substr(SQLERRM,1,150);
1817: msd_dem_common_utilities.log_message ('Exception: msd_dem_sop.collect_sci_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1818: msd_dem_common_utilities.log_message (errbuf);
1819: RETURN;
1820:
1821: END COLLECT_SCI_DATA;

Line 1861: msd_dem_common_utilities.log_message ('Entering: msd_dem_sop.launch_sci_data_loads - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1857:
1858:
1859: BEGIN
1860:
1861: msd_dem_common_utilities.log_message ('Entering: msd_dem_sop.launch_sci_data_loads - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1862:
1863: retcode := 0;
1864:
1865: /* SCI BACKLOG */

Line 2098: msd_dem_common_utilities.log_message ('Exiting: msd_dem_sop.launch_sci_data_loads - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

2094: errbuf := l_errbuff1 || l_errbuff2 ;
2095: END IF;
2096: END IF; -- IF ( p_entity = G_SCI_BACKLOG )
2097:
2098: msd_dem_common_utilities.log_message ('Exiting: msd_dem_sop.launch_sci_data_loads - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2099:
2100: EXCEPTION
2101: WHEN OTHERS THEN
2102: retcode := -1 ;

Line 2104: msd_dem_common_utilities.log_message ('Exception: msd_dem_sop.launch_sci_data_loads- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

2100: EXCEPTION
2101: WHEN OTHERS THEN
2102: retcode := -1 ;
2103: errbuf := substr(SQLERRM,1,150);
2104: msd_dem_common_utilities.log_message ('Exception: msd_dem_sop.launch_sci_data_loads- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2105: msd_dem_common_utilities.log_message (errbuf);
2106: RETURN;
2107:
2108: END LAUNCH_SCI_DATA_LOADS;

Line 2112: END MSD_DEM_SOP;

2108: END LAUNCH_SCI_DATA_LOADS;
2109:
2110:
2111:
2112: END MSD_DEM_SOP;