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_COMMON_UTILITIES dependencies on MSD_DEM_COMMON_UTILITIES

Line 1: PACKAGE BODY MSD_DEM_COMMON_UTILITIES AS

1: PACKAGE BODY MSD_DEM_COMMON_UTILITIES AS
2: /* $Header: msddemcub.pls 120.60.12020000.6 2013/01/22 10:17:01 kkhatri ship $ */
3:
4:
5: LG_VAR_SITE_CODE_FORMAT NUMBER := NULL;

Line 524: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_COMMON_UTILITIES TO ' || x_dem_schema;

520: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_SOP TO ' || x_dem_schema;
521: EXECUTE IMMEDIATE x_grant_sql;
522: log_message ('Execute privilege granted on package MSD_DEM_SOP to ' || x_dem_schema || ' schema.');
523:
524: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_COMMON_UTILITIES TO ' || x_dem_schema;
525: EXECUTE IMMEDIATE x_grant_sql;
526: log_message ('Execute privilege granted on package MSD_DEM_COMMON_UTILITIES to ' || x_dem_schema || ' schema.');
527:
528: x_grant_sql := 'GRANT EXECUTE ON MSC_PHUB_PKG TO ' || x_dem_schema;

Line 526: log_message ('Execute privilege granted on package MSD_DEM_COMMON_UTILITIES to ' || x_dem_schema || ' schema.');

522: log_message ('Execute privilege granted on package MSD_DEM_SOP to ' || x_dem_schema || ' schema.');
523:
524: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_COMMON_UTILITIES TO ' || x_dem_schema;
525: EXECUTE IMMEDIATE x_grant_sql;
526: log_message ('Execute privilege granted on package MSD_DEM_COMMON_UTILITIES to ' || x_dem_schema || ' schema.');
527:
528: x_grant_sql := 'GRANT EXECUTE ON MSC_PHUB_PKG TO ' || x_dem_schema;
529: EXECUTE IMMEDIATE x_grant_sql;
530: log_message ('Execute privilege granted on package MSC_PHUB_PKG to ' || x_dem_schema || ' schema.');

Line 620: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');

616: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_BASE_MODEL := get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 1);
617: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION_CLASS := get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 2);
618: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION := get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 3);
619:
620: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
621: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');
622:
623: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
624: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));

Line 621: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');

617: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION_CLASS := get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 2);
618: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION := get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 3);
619:
620: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
621: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');
622:
623: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
624: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));
625: -- bug#14694463 kkhatri

Line 623: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));

619:
620: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
621: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');
622:
623: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
624: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));
625: -- bug#14694463 kkhatri
626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);

Line 624: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));

620: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
621: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');
622:
623: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
624: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));
625: -- bug#14694463 kkhatri
626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
628: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);

Line 626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);

622:
623: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
624: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));
625: -- bug#14694463 kkhatri
626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
628: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
629: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
630: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);

Line 627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);

623: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
624: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));
625: -- bug#14694463 kkhatri
626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
628: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
629: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
630: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
631:

Line 628: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);

624: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));
625: -- bug#14694463 kkhatri
626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
628: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
629: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
630: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
631:
632: END IF;

Line 629: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);

625: -- bug#14694463 kkhatri
626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
628: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
629: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
630: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
631:
632: END IF;
633:

Line 630: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);

626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
628: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
629: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
630: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
631:
632: END IF;
633:
634: /* Set the profile MSD_DEM_VERSION */ -- nallkuma

Line 910: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

906: COMMIT;
907:
908: EXCEPTION
909: WHEN OTHERS THEN
910: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
911: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
912: retcode := -1;
913: END;
914:

Line 911: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

907:
908: EXCEPTION
909: WHEN OTHERS THEN
910: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
911: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
912: retcode := -1;
913: END;
914:
915: /* Deletes the msd_dem_entities_inuse table if the new demantra schema is intstalled

Line 927: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

923: delete msd_dem_entities_inuse;
924: commit;
925: EXCEPTION
926: when others then
927: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
928: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
929: retcode := -1;
930: END;
931:

Line 928: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

924: commit;
925: EXCEPTION
926: when others then
927: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
928: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
929: retcode := -1;
930: END;
931:
932:

Line 1010: msd_dem_common_utilities.get_dblink (

1006:
1007: BEGIN
1008:
1009: /* Get the db link to the source instance */
1010: msd_dem_common_utilities.get_dblink (
1011: x_errbuf,
1012: x_retcode,
1013: p_sr_instance_id,
1014: x_dblink);

Line 1082: L_DM := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');

1078: FETCH C1 INTO L_DM;
1079: CLOSE C1;
1080: */
1081:
1082: L_DM := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');
1083:
1084: L_STMT := 'SELECT TIME_BUCKET FROM '||
1085: L_DM||
1086: ' WHERE IS_ACTIVE=1 ';

Line 1552: if (upper(msd_dem_common_utilities.dm_time_level) <> 'DAY') then

1548: open c2 (p_plan_id);
1549: fetch c2 into l_ret;
1550: close c2;
1551:
1552: if (upper(msd_dem_common_utilities.dm_time_level) <> 'DAY') then
1553: open c3(l_ret);
1554: fetch c3 into l_ret;
1555: close c3;
1556: end if;

Line 1577: || msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS')

1573: BEGIN
1574:
1575: EXECUTE IMMEDIATE 'SELECT datet FROM ( '
1576: || ' SELECT datet FROM '
1577: || msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS')
1578: || ' WHERE datet > sysdate '
1579: || ' ORDER BY datet ) '
1580: || ' WHERE rownum < 2 '
1581: INTO x_dummy_date;

Line 1735: IF (upper(msd_dem_common_utilities.dm_time_level) = 'DAY')

1731: IS
1732: x_max_date DATE := NULL;
1733: BEGIN
1734:
1735: IF (upper(msd_dem_common_utilities.dm_time_level) = 'DAY')
1736: THEN
1737: RETURN 1;
1738: END IF;
1739:

Line 2614: x_dm_time_level := lower(msd_dem_common_utilities.dm_time_level);

2610:
2611: END IF;
2612:
2613: /* check the time bucket used in demantra */
2614: x_dm_time_level := lower(msd_dem_common_utilities.dm_time_level);
2615: IF x_dm_time_level = 'day'
2616: THEN
2617: x_bom_date := x_max_sales_date_d + x_num_periods;
2618: ELSIF x_dm_time_level = 'week'

Line 2987: msd_dem_common_utilities.log_debug ('Entering: msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

2983:
2984:
2985: BEGIN
2986:
2987: msd_dem_common_utilities.log_debug ('Entering: msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2988:
2989: /* Log the input parameters to the log file */
2990: msd_dem_common_utilities.log_message('----------------------------------Input Parameters - Begin------------------------------------------');
2991:

Line 2990: msd_dem_common_utilities.log_message('----------------------------------Input Parameters - Begin------------------------------------------');

2986:
2987: msd_dem_common_utilities.log_debug ('Entering: msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2988:
2989: /* Log the input parameters to the log file */
2990: msd_dem_common_utilities.log_message('----------------------------------Input Parameters - Begin------------------------------------------');
2991:
2992: msd_dem_common_utilities.log_message(' ' || rpad('Workflow Lookup Code', 30) || ' - ' || to_char(nvl(p_workflow_lookup_code,'No Value')));
2993:
2994: msd_dem_common_utilities.log_message('-----------------------------------Input Parameters - End-------------------------------------------');

Line 2992: msd_dem_common_utilities.log_message(' ' || rpad('Workflow Lookup Code', 30) || ' - ' || to_char(nvl(p_workflow_lookup_code,'No Value')));

2988:
2989: /* Log the input parameters to the log file */
2990: msd_dem_common_utilities.log_message('----------------------------------Input Parameters - Begin------------------------------------------');
2991:
2992: msd_dem_common_utilities.log_message(' ' || rpad('Workflow Lookup Code', 30) || ' - ' || to_char(nvl(p_workflow_lookup_code,'No Value')));
2993:
2994: msd_dem_common_utilities.log_message('-----------------------------------Input Parameters - End-------------------------------------------');
2995: msd_dem_common_utilities.log_message ('');
2996: msd_dem_common_utilities.log_message ('');

Line 2994: msd_dem_common_utilities.log_message('-----------------------------------Input Parameters - End-------------------------------------------');

2990: msd_dem_common_utilities.log_message('----------------------------------Input Parameters - Begin------------------------------------------');
2991:
2992: msd_dem_common_utilities.log_message(' ' || rpad('Workflow Lookup Code', 30) || ' - ' || to_char(nvl(p_workflow_lookup_code,'No Value')));
2993:
2994: msd_dem_common_utilities.log_message('-----------------------------------Input Parameters - End-------------------------------------------');
2995: msd_dem_common_utilities.log_message ('');
2996: msd_dem_common_utilities.log_message ('');
2997:
2998: /* Log the optional input parameters to the output file */

Line 2995: msd_dem_common_utilities.log_message ('');

2991:
2992: msd_dem_common_utilities.log_message(' ' || rpad('Workflow Lookup Code', 30) || ' - ' || to_char(nvl(p_workflow_lookup_code,'No Value')));
2993:
2994: msd_dem_common_utilities.log_message('-----------------------------------Input Parameters - End-------------------------------------------');
2995: msd_dem_common_utilities.log_message ('');
2996: msd_dem_common_utilities.log_message ('');
2997:
2998: /* Log the optional input parameters to the output file */
2999: msd_dem_common_utilities.log_debug('----------------------------------Input Parameters (optional) - Begin------------------------------------------');

Line 2996: msd_dem_common_utilities.log_message ('');

2992: msd_dem_common_utilities.log_message(' ' || rpad('Workflow Lookup Code', 30) || ' - ' || to_char(nvl(p_workflow_lookup_code,'No Value')));
2993:
2994: msd_dem_common_utilities.log_message('-----------------------------------Input Parameters - End-------------------------------------------');
2995: msd_dem_common_utilities.log_message ('');
2996: msd_dem_common_utilities.log_message ('');
2997:
2998: /* Log the optional input parameters to the output file */
2999: msd_dem_common_utilities.log_debug('----------------------------------Input Parameters (optional) - Begin------------------------------------------');
3000:

Line 2999: msd_dem_common_utilities.log_debug('----------------------------------Input Parameters (optional) - Begin------------------------------------------');

2995: msd_dem_common_utilities.log_message ('');
2996: msd_dem_common_utilities.log_message ('');
2997:
2998: /* Log the optional input parameters to the output file */
2999: msd_dem_common_utilities.log_debug('----------------------------------Input Parameters (optional) - Begin------------------------------------------');
3000:
3001: msd_dem_common_utilities.log_debug(' ' || rpad('Synchronous', 30) || ' - ' || to_char(p_synchronous));
3002: msd_dem_common_utilities.log_debug(' ' || rpad('Check Interval(sec)', 30) || ' - ' || to_char(p_check_interval));
3003: msd_dem_common_utilities.log_debug(' ' || rpad('Time Out(min)', 30) || ' - ' || p_time_out);

Line 3001: msd_dem_common_utilities.log_debug(' ' || rpad('Synchronous', 30) || ' - ' || to_char(p_synchronous));

2997:
2998: /* Log the optional input parameters to the output file */
2999: msd_dem_common_utilities.log_debug('----------------------------------Input Parameters (optional) - Begin------------------------------------------');
3000:
3001: msd_dem_common_utilities.log_debug(' ' || rpad('Synchronous', 30) || ' - ' || to_char(p_synchronous));
3002: msd_dem_common_utilities.log_debug(' ' || rpad('Check Interval(sec)', 30) || ' - ' || to_char(p_check_interval));
3003: msd_dem_common_utilities.log_debug(' ' || rpad('Time Out(min)', 30) || ' - ' || p_time_out);
3004:
3005: msd_dem_common_utilities.log_debug('-----------------------------------Input Parameters (optional) - End-------------------------------------------');

Line 3002: msd_dem_common_utilities.log_debug(' ' || rpad('Check Interval(sec)', 30) || ' - ' || to_char(p_check_interval));

2998: /* Log the optional input parameters to the output file */
2999: msd_dem_common_utilities.log_debug('----------------------------------Input Parameters (optional) - Begin------------------------------------------');
3000:
3001: msd_dem_common_utilities.log_debug(' ' || rpad('Synchronous', 30) || ' - ' || to_char(p_synchronous));
3002: msd_dem_common_utilities.log_debug(' ' || rpad('Check Interval(sec)', 30) || ' - ' || to_char(p_check_interval));
3003: msd_dem_common_utilities.log_debug(' ' || rpad('Time Out(min)', 30) || ' - ' || p_time_out);
3004:
3005: msd_dem_common_utilities.log_debug('-----------------------------------Input Parameters (optional) - End-------------------------------------------');
3006: msd_dem_common_utilities.log_debug ('');

Line 3003: msd_dem_common_utilities.log_debug(' ' || rpad('Time Out(min)', 30) || ' - ' || p_time_out);

2999: msd_dem_common_utilities.log_debug('----------------------------------Input Parameters (optional) - Begin------------------------------------------');
3000:
3001: msd_dem_common_utilities.log_debug(' ' || rpad('Synchronous', 30) || ' - ' || to_char(p_synchronous));
3002: msd_dem_common_utilities.log_debug(' ' || rpad('Check Interval(sec)', 30) || ' - ' || to_char(p_check_interval));
3003: msd_dem_common_utilities.log_debug(' ' || rpad('Time Out(min)', 30) || ' - ' || p_time_out);
3004:
3005: msd_dem_common_utilities.log_debug('-----------------------------------Input Parameters (optional) - End-------------------------------------------');
3006: msd_dem_common_utilities.log_debug ('');
3007: msd_dem_common_utilities.log_debug ('');

Line 3005: msd_dem_common_utilities.log_debug('-----------------------------------Input Parameters (optional) - End-------------------------------------------');

3001: msd_dem_common_utilities.log_debug(' ' || rpad('Synchronous', 30) || ' - ' || to_char(p_synchronous));
3002: msd_dem_common_utilities.log_debug(' ' || rpad('Check Interval(sec)', 30) || ' - ' || to_char(p_check_interval));
3003: msd_dem_common_utilities.log_debug(' ' || rpad('Time Out(min)', 30) || ' - ' || p_time_out);
3004:
3005: msd_dem_common_utilities.log_debug('-----------------------------------Input Parameters (optional) - End-------------------------------------------');
3006: msd_dem_common_utilities.log_debug ('');
3007: msd_dem_common_utilities.log_debug ('');
3008:
3009: /* START - Parameters Validation */

Line 3006: msd_dem_common_utilities.log_debug ('');

3002: msd_dem_common_utilities.log_debug(' ' || rpad('Check Interval(sec)', 30) || ' - ' || to_char(p_check_interval));
3003: msd_dem_common_utilities.log_debug(' ' || rpad('Time Out(min)', 30) || ' - ' || p_time_out);
3004:
3005: msd_dem_common_utilities.log_debug('-----------------------------------Input Parameters (optional) - End-------------------------------------------');
3006: msd_dem_common_utilities.log_debug ('');
3007: msd_dem_common_utilities.log_debug ('');
3008:
3009: /* START - Parameters Validation */
3010: IF ( p_workflow_lookup_code IS NULL )

Line 3007: msd_dem_common_utilities.log_debug ('');

3003: msd_dem_common_utilities.log_debug(' ' || rpad('Time Out(min)', 30) || ' - ' || p_time_out);
3004:
3005: msd_dem_common_utilities.log_debug('-----------------------------------Input Parameters (optional) - End-------------------------------------------');
3006: msd_dem_common_utilities.log_debug ('');
3007: msd_dem_common_utilities.log_debug ('');
3008:
3009: /* START - Parameters Validation */
3010: IF ( p_workflow_lookup_code IS NULL )
3011: THEN

Line 3014: msd_dem_common_utilities.log_message ('Error(1): msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3010: IF ( p_workflow_lookup_code IS NULL )
3011: THEN
3012: retcode := -1;
3013: errbuf := '''Workflow Lookup Code'' cannot be NULL.';
3014: msd_dem_common_utilities.log_message ('Error(1): msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3015: msd_dem_common_utilities.log_message (errbuf);
3016: RETURN;
3017: END IF;
3018: /* END - Parameters Validation */

Line 3015: msd_dem_common_utilities.log_message (errbuf);

3011: THEN
3012: retcode := -1;
3013: errbuf := '''Workflow Lookup Code'' cannot be NULL.';
3014: msd_dem_common_utilities.log_message ('Error(1): msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3015: msd_dem_common_utilities.log_message (errbuf);
3016: RETURN;
3017: END IF;
3018: /* END - Parameters Validation */
3019:

Line 3025: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID',

3021:
3022: IF fnd_profile.value('MSD_DEM_SCHEMA') IS NOT NULL
3023: THEN
3024:
3025: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID',
3026: 'COMP_DM',
3027: 1,
3028: 'user_id'));
3029: IF l_user_id is not null

Line 3036: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID',

3032: EXECUTE IMMEDIATE l_sql INTO l_user_name, l_password;
3033:
3034: ELSE
3035:
3036: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID',
3037: 'COMP_SOP',
3038: 1,
3039: 'user_id'));
3040:

Line 3046: msd_dem_common_utilities.log_message('Component is not found.');

3042: THEN
3043: l_sql := 'select user_name, password from '||dem_schema||'.user_id where user_id = '||l_user_id;
3044: EXECUTE IMMEDIATE l_sql INTO l_user_name, l_password;
3045: ELSE
3046: msd_dem_common_utilities.log_message('Component is not found.');
3047: END IF;
3048: END IF;
3049:
3050:

Line 3054: l_schema_name := trim(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', p_workflow_lookup_code, 1, 'schema_name'));

3050:
3051: IF l_user_name IS NOT NULL
3052: THEN
3053: l_url := fnd_profile.value('MSD_DEM_HOST_URL');
3054: l_schema_name := trim(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', p_workflow_lookup_code, 1, 'schema_name'));
3055: l_sql := null;
3056: l_sql := 'SELECT utl_http.request('''||l_url||'/WorkflowServer?action=run_proc&user='||l_user_name||'&password='||l_password||'&schema='|| replace(l_schema_name, ' ', '%20') ||'&sync=no'') FROM dual';
3057:
3058: msd_dem_common_utilities.log_message('Launching Demantra workflow - ' || l_schema_name);

Line 3058: msd_dem_common_utilities.log_message('Launching Demantra workflow - ' || l_schema_name);

3054: l_schema_name := trim(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', p_workflow_lookup_code, 1, 'schema_name'));
3055: l_sql := null;
3056: l_sql := 'SELECT utl_http.request('''||l_url||'/WorkflowServer?action=run_proc&user='||l_user_name||'&password='||l_password||'&schema='|| replace(l_schema_name, ' ', '%20') ||'&sync=no'') FROM dual';
3057:
3058: msd_dem_common_utilities.log_message('Launching Demantra workflow - ' || l_schema_name);
3059: msd_dem_common_utilities.log_debug ( ' ');
3060: msd_dem_common_utilities.log_debug('Workflow Calling sql - ');
3061: msd_dem_common_utilities.log_debug(l_sql);
3062: EXECUTE IMMEDIATE l_sql INTO ret_process_id;

Line 3059: msd_dem_common_utilities.log_debug ( ' ');

3055: l_sql := null;
3056: l_sql := 'SELECT utl_http.request('''||l_url||'/WorkflowServer?action=run_proc&user='||l_user_name||'&password='||l_password||'&schema='|| replace(l_schema_name, ' ', '%20') ||'&sync=no'') FROM dual';
3057:
3058: msd_dem_common_utilities.log_message('Launching Demantra workflow - ' || l_schema_name);
3059: msd_dem_common_utilities.log_debug ( ' ');
3060: msd_dem_common_utilities.log_debug('Workflow Calling sql - ');
3061: msd_dem_common_utilities.log_debug(l_sql);
3062: EXECUTE IMMEDIATE l_sql INTO ret_process_id;
3063:

Line 3060: msd_dem_common_utilities.log_debug('Workflow Calling sql - ');

3056: l_sql := 'SELECT utl_http.request('''||l_url||'/WorkflowServer?action=run_proc&user='||l_user_name||'&password='||l_password||'&schema='|| replace(l_schema_name, ' ', '%20') ||'&sync=no'') FROM dual';
3057:
3058: msd_dem_common_utilities.log_message('Launching Demantra workflow - ' || l_schema_name);
3059: msd_dem_common_utilities.log_debug ( ' ');
3060: msd_dem_common_utilities.log_debug('Workflow Calling sql - ');
3061: msd_dem_common_utilities.log_debug(l_sql);
3062: EXECUTE IMMEDIATE l_sql INTO ret_process_id;
3063:
3064: IF (to_number(ret_process_id) < 0)

Line 3061: msd_dem_common_utilities.log_debug(l_sql);

3057:
3058: msd_dem_common_utilities.log_message('Launching Demantra workflow - ' || l_schema_name);
3059: msd_dem_common_utilities.log_debug ( ' ');
3060: msd_dem_common_utilities.log_debug('Workflow Calling sql - ');
3061: msd_dem_common_utilities.log_debug(l_sql);
3062: EXECUTE IMMEDIATE l_sql INTO ret_process_id;
3063:
3064: IF (to_number(ret_process_id) < 0)
3065: THEN

Line 3069: msd_dem_common_utilities.log_message ('ERROR(2): msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3065: THEN
3066:
3067: retcode := -1;
3068: errbuf := ret_process_id;
3069: msd_dem_common_utilities.log_message ('ERROR(2): msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3070: msd_dem_common_utilities.log_message ('Failed to launch download workflow');
3071: msd_dem_common_utilities.log_message (errbuf);
3072: RETURN;
3073:

Line 3070: msd_dem_common_utilities.log_message ('Failed to launch download workflow');

3066:
3067: retcode := -1;
3068: errbuf := ret_process_id;
3069: msd_dem_common_utilities.log_message ('ERROR(2): msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3070: msd_dem_common_utilities.log_message ('Failed to launch download workflow');
3071: msd_dem_common_utilities.log_message (errbuf);
3072: RETURN;
3073:
3074: ELSE

Line 3071: msd_dem_common_utilities.log_message (errbuf);

3067: retcode := -1;
3068: errbuf := ret_process_id;
3069: msd_dem_common_utilities.log_message ('ERROR(2): msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3070: msd_dem_common_utilities.log_message ('Failed to launch download workflow');
3071: msd_dem_common_utilities.log_message (errbuf);
3072: RETURN;
3073:
3074: ELSE
3075:

Line 3076: msd_dem_common_utilities.log_message('Launched workflow successfully.');

3072: RETURN;
3073:
3074: ELSE
3075:
3076: msd_dem_common_utilities.log_message('Launched workflow successfully.');
3077: msd_dem_common_utilities.log_message('Workflow Process Id - ' || to_number(ret_process_id));
3078: msd_dem_common_utilities.log_message('Please check the workflow process status from workflow manager.');
3079:
3080: END IF;

Line 3077: msd_dem_common_utilities.log_message('Workflow Process Id - ' || to_number(ret_process_id));

3073:
3074: ELSE
3075:
3076: msd_dem_common_utilities.log_message('Launched workflow successfully.');
3077: msd_dem_common_utilities.log_message('Workflow Process Id - ' || to_number(ret_process_id));
3078: msd_dem_common_utilities.log_message('Please check the workflow process status from workflow manager.');
3079:
3080: END IF;
3081:

Line 3078: msd_dem_common_utilities.log_message('Please check the workflow process status from workflow manager.');

3074: ELSE
3075:
3076: msd_dem_common_utilities.log_message('Launched workflow successfully.');
3077: msd_dem_common_utilities.log_message('Workflow Process Id - ' || to_number(ret_process_id));
3078: msd_dem_common_utilities.log_message('Please check the workflow process status from workflow manager.');
3079:
3080: END IF;
3081:
3082: /* START - Checking the status of the workflow */

Line 3100: msd_dem_common_utilities.log_message( workflow_name || ' Workflow completed successfully.');

3096:
3097: IF (workflow_status = 1) THEN
3098: DBMS_LOCK.SLEEP( p_check_interval );
3099: ELSIF (workflow_status = 0) then
3100: msd_dem_common_utilities.log_message( workflow_name || ' Workflow completed successfully.');
3101: retcode := 0;
3102: EXIT;
3103: ELSIF (workflow_status = -1) then
3104: msd_dem_common_utilities.log_message( workflow_name || ' Workflow Failed.');

Line 3104: msd_dem_common_utilities.log_message( workflow_name || ' Workflow Failed.');

3100: msd_dem_common_utilities.log_message( workflow_name || ' Workflow completed successfully.');
3101: retcode := 0;
3102: EXIT;
3103: ELSIF (workflow_status = -1) then
3104: msd_dem_common_utilities.log_message( workflow_name || ' Workflow Failed.');
3105: retcode := -1;
3106: EXIT;
3107: ELSE
3108: msd_dem_common_utilities.log_message( workflow_name || ' Workflow Status not defined. ');

Line 3108: msd_dem_common_utilities.log_message( workflow_name || ' Workflow Status not defined. ');

3104: msd_dem_common_utilities.log_message( workflow_name || ' Workflow Failed.');
3105: retcode := -1;
3106: EXIT;
3107: ELSE
3108: msd_dem_common_utilities.log_message( workflow_name || ' Workflow Status not defined. ');
3109: retcode := 1;
3110: EXIT;
3111: END IF;
3112:

Line 3116: msd_dem_common_utilities.log_message( workflow_name || ' Workflow timed out. Check status of the workflow');

3112:
3113: x_check_cnt := x_check_cnt + p_check_interval ;
3114:
3115: If (x_check_cnt >= x_time_out_cnt) then
3116: msd_dem_common_utilities.log_message( workflow_name || ' Workflow timed out. Check status of the workflow');
3117: retcode := 1;
3118: End if;
3119:
3120: END LOOP;

Line 3126: msd_dem_common_utilities.log_message('Error in launching demantra workflow.');

3122: END IF;
3123: /* END - Checking the status of the workflow */
3124:
3125: ELSE
3126: msd_dem_common_utilities.log_message('Error in launching demantra workflow.');
3127: retcode := -1;
3128: Return;
3129: END IF;
3130:

Line 3132: msd_dem_common_utilities.log_message('Demantra Schema not set');

3128: Return;
3129: END IF;
3130:
3131: ELSE
3132: msd_dem_common_utilities.log_message('Demantra Schema not set');
3133: END IF;
3134:
3135: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3136:

Line 3135: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3131: ELSE
3132: msd_dem_common_utilities.log_message('Demantra Schema not set');
3133: END IF;
3134:
3135: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3136:
3137: EXCEPTION
3138: WHEN OTHERS THEN
3139: errbuf := substr(SQLERRM,1,150);

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

3138: WHEN OTHERS THEN
3139: errbuf := substr(SQLERRM,1,150);
3140: retcode := -1 ;
3141:
3142: msd_dem_common_utilities.log_message ('Exception: msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3143: msd_dem_common_utilities.log_message (errbuf);
3144: RETURN;
3145:
3146: END Launch_Dem_Workflow;

Line 3143: msd_dem_common_utilities.log_message (errbuf);

3139: errbuf := substr(SQLERRM,1,150);
3140: retcode := -1 ;
3141:
3142: msd_dem_common_utilities.log_message ('Exception: msd_dem_common_utilities.Launch_Dem_Workflow - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3143: msd_dem_common_utilities.log_message (errbuf);
3144: RETURN;
3145:
3146: END Launch_Dem_Workflow;
3147:

Line 3198: msd_dem_common_utilities.log_debug ('Entering: msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3194:
3195:
3196: BEGIN
3197:
3198: msd_dem_common_utilities.log_debug ('Entering: msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3199: msd_dem_common_utilities.log_debug (' ');
3200:
3201: /* VALIDATION OF INPUT PARAMETERS - BEGIN */
3202:

Line 3199: msd_dem_common_utilities.log_debug (' ');

3195:
3196: BEGIN
3197:
3198: msd_dem_common_utilities.log_debug ('Entering: msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3199: msd_dem_common_utilities.log_debug (' ');
3200:
3201: /* VALIDATION OF INPUT PARAMETERS - BEGIN */
3202:
3203: msd_dem_common_utilities.log_debug ('Begin validation of inputs parameters - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 3203: msd_dem_common_utilities.log_debug ('Begin validation of inputs parameters - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3199: msd_dem_common_utilities.log_debug (' ');
3200:
3201: /* VALIDATION OF INPUT PARAMETERS - BEGIN */
3202:
3203: msd_dem_common_utilities.log_debug ('Begin validation of inputs parameters - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3204:
3205: /* Show Warning if collection method is 'Refresh/Complete' and a date range filter is specified */
3206: IF ( p_collection_method = 1
3207: AND ( p_from_date IS NOT NULL

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

3210: OR p_future_window is not null))
3211: THEN
3212: x_retcode := 1;
3213: x_errbuf := 'Date Range filters are ignored in ''Refresh/Complete'' collections';
3214: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3215: msd_dem_common_utilities.log_message (x_errbuf);
3216: END IF;
3217:
3218:

Line 3215: msd_dem_common_utilities.log_message (x_errbuf);

3211: THEN
3212: x_retcode := 1;
3213: x_errbuf := 'Date Range filters are ignored in ''Refresh/Complete'' collections';
3214: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3215: msd_dem_common_utilities.log_message (x_errbuf);
3216: END IF;
3217:
3218:
3219: /* Show Warning if collection method is 'Net Change', date_range_type is 'Rolling' and from_date and to_date are specified */

Line 3227: msd_dem_common_utilities.log_message ('Warning(2): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3223: OR p_to_date IS NOT NULL))
3224: THEN
3225: x_retcode := 1;
3226: x_errbuf := 'The ''Date From'' and ''Date To'' fields are ignored if ''Rolling'' date_range_type is selected.';
3227: msd_dem_common_utilities.log_message ('Warning(2): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3228: msd_dem_common_utilities.log_message (x_errbuf);
3229: END IF;
3230:
3231:

Line 3228: msd_dem_common_utilities.log_message (x_errbuf);

3224: THEN
3225: x_retcode := 1;
3226: x_errbuf := 'The ''Date From'' and ''Date To'' fields are ignored if ''Rolling'' date_range_type is selected.';
3227: msd_dem_common_utilities.log_message ('Warning(2): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3228: msd_dem_common_utilities.log_message (x_errbuf);
3229: END IF;
3230:
3231:
3232: /* Show Warning if collection method is 'Net Change', date_range_type is 'Absolute' and history collection window is specified */

Line 3239: msd_dem_common_utilities.log_message ('Warning(3): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3235: AND (p_collection_window IS NOT NULL or p_future_window is not null))
3236: THEN
3237: x_retcode := 1;
3238: x_errbuf := 'The ''History Collection Window'' field is ignored if ''Absolute'' date range type is selected.';
3239: msd_dem_common_utilities.log_message ('Warning(3): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3240: msd_dem_common_utilities.log_message (x_errbuf);
3241: END IF;
3242:
3243:

Line 3240: msd_dem_common_utilities.log_message (x_errbuf);

3236: THEN
3237: x_retcode := 1;
3238: x_errbuf := 'The ''History Collection Window'' field is ignored if ''Absolute'' date range type is selected.';
3239: msd_dem_common_utilities.log_message ('Warning(3): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3240: msd_dem_common_utilities.log_message (x_errbuf);
3241: END IF;
3242:
3243:
3244: /* Error if collection method is 'Net Change', date_range_type is 'Rolling' and collection window is not specified */

Line 3251: msd_dem_common_utilities.log_message ('Error(1): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3247: AND p_collection_window IS NULL and p_future_window is null)
3248: THEN
3249: retcode := -1;
3250: errbuf := 'The ''History Collection Window'' field cannot be NULL, if ''Rolling'' date range type is selected.';
3251: msd_dem_common_utilities.log_message ('Error(1): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3252: msd_dem_common_utilities.log_message (errbuf);
3253: RETURN;
3254: END IF;
3255:

Line 3252: msd_dem_common_utilities.log_message (errbuf);

3248: THEN
3249: retcode := -1;
3250: errbuf := 'The ''History Collection Window'' field cannot be NULL, if ''Rolling'' date range type is selected.';
3251: msd_dem_common_utilities.log_message ('Error(1): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3252: msd_dem_common_utilities.log_message (errbuf);
3253: RETURN;
3254: END IF;
3255:
3256: /* Error if collection method is 'Net Change', date_range_type is 'Absolute' and from_date and to_date are not specified */

Line 3264: msd_dem_common_utilities.log_message ('Error(2): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3260: OR p_to_date IS NULL))
3261: THEN
3262: retcode := -1;
3263: errbuf := 'The ''Date From'' and ''Date To'' fields cannot be NULL, if ''Absolute'' date range type is selected.';
3264: msd_dem_common_utilities.log_message ('Error(2): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3265: msd_dem_common_utilities.log_message (errbuf);
3266: RETURN;
3267: END IF;
3268:

Line 3265: msd_dem_common_utilities.log_message (errbuf);

3261: THEN
3262: retcode := -1;
3263: errbuf := 'The ''Date From'' and ''Date To'' fields cannot be NULL, if ''Absolute'' date range type is selected.';
3264: msd_dem_common_utilities.log_message ('Error(2): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3265: msd_dem_common_utilities.log_message (errbuf);
3266: RETURN;
3267: END IF;
3268:
3269: /* VALIDATION OF INPUT PARAMETERS - END */

Line 3274: msd_dem_common_utilities.log_debug ('Begin get dates - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3270:
3271:
3272: /* Get the start date and end dates for collection */
3273:
3274: msd_dem_common_utilities.log_debug ('Begin get dates - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3275:
3276: IF (p_collection_method = 1) /* Refresh/Complete */
3277: THEN
3278: x_from_date := to_date('01/01/1000', 'DD/MM/YYYY');

Line 3304: msd_dem_common_utilities.log_message ('Error(3): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3300: IF (x_from_date > x_to_date)
3301: THEN
3302: retcode := -1;
3303: errbuf := 'From Date should not be greater than To Date.';
3304: msd_dem_common_utilities.log_message ('Error(3): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3305: msd_dem_common_utilities.log_message (errbuf);
3306: RETURN;
3307: END IF;
3308:

Line 3305: msd_dem_common_utilities.log_message (errbuf);

3301: THEN
3302: retcode := -1;
3303: errbuf := 'From Date should not be greater than To Date.';
3304: msd_dem_common_utilities.log_message ('Error(3): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3305: msd_dem_common_utilities.log_message (errbuf);
3306: RETURN;
3307: END IF;
3308:
3309: ELSE /* Rolling */

Line 3315: msd_dem_common_utilities.log_message ('Error(4): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3311: IF (p_collection_window <= 0 or p_future_window <= 0)
3312: THEN
3313: retcode := -1;
3314: errbuf := 'Collection Window must be a positive number.';
3315: msd_dem_common_utilities.log_message ('Error(4): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3316: msd_dem_common_utilities.log_message (errbuf);
3317: RETURN;
3318: ELSE
3319: x_from_date := trunc(sysdate, 'DD') - nvl(p_collection_window,0) + 1;

Line 3316: msd_dem_common_utilities.log_message (errbuf);

3312: THEN
3313: retcode := -1;
3314: errbuf := 'Collection Window must be a positive number.';
3315: msd_dem_common_utilities.log_message ('Error(4): msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3316: msd_dem_common_utilities.log_message (errbuf);
3317: RETURN;
3318: ELSE
3319: x_from_date := trunc(sysdate, 'DD') - nvl(p_collection_window,0) + 1;
3320: x_to_date := trunc(sysdate, 'DD') + nvl(p_future_window,0);

Line 3328: msd_dem_common_utilities.log_debug ('End get dates - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3324:
3325: o_from_date := x_from_date;
3326: o_to_date := x_to_date;
3327:
3328: msd_dem_common_utilities.log_debug ('End get dates - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3329:
3330: msd_dem_common_utilities.log_debug (' ');
3331:
3332: msd_dem_common_utilities.log_message ('Date From (DD/MM/RRRR) - ' || to_char(o_from_date, 'DD/MM/RRRR'));

Line 3330: msd_dem_common_utilities.log_debug (' ');

3326: o_to_date := x_to_date;
3327:
3328: msd_dem_common_utilities.log_debug ('End get dates - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3329:
3330: msd_dem_common_utilities.log_debug (' ');
3331:
3332: msd_dem_common_utilities.log_message ('Date From (DD/MM/RRRR) - ' || to_char(o_from_date, 'DD/MM/RRRR'));
3333: msd_dem_common_utilities.log_message ('Date To (DD/MM/RRRR) - ' || to_char(o_to_date, 'DD/MM/RRRR'));
3334:

Line 3332: msd_dem_common_utilities.log_message ('Date From (DD/MM/RRRR) - ' || to_char(o_from_date, 'DD/MM/RRRR'));

3328: msd_dem_common_utilities.log_debug ('End get dates - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3329:
3330: msd_dem_common_utilities.log_debug (' ');
3331:
3332: msd_dem_common_utilities.log_message ('Date From (DD/MM/RRRR) - ' || to_char(o_from_date, 'DD/MM/RRRR'));
3333: msd_dem_common_utilities.log_message ('Date To (DD/MM/RRRR) - ' || to_char(o_to_date, 'DD/MM/RRRR'));
3334:
3335: msd_dem_common_utilities.log_message (' ');
3336:

Line 3333: msd_dem_common_utilities.log_message ('Date To (DD/MM/RRRR) - ' || to_char(o_to_date, 'DD/MM/RRRR'));

3329:
3330: msd_dem_common_utilities.log_debug (' ');
3331:
3332: msd_dem_common_utilities.log_message ('Date From (DD/MM/RRRR) - ' || to_char(o_from_date, 'DD/MM/RRRR'));
3333: msd_dem_common_utilities.log_message ('Date To (DD/MM/RRRR) - ' || to_char(o_to_date, 'DD/MM/RRRR'));
3334:
3335: msd_dem_common_utilities.log_message (' ');
3336:
3337: msd_dem_common_utilities.log_debug ('Existing: msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 3335: msd_dem_common_utilities.log_message (' ');

3331:
3332: msd_dem_common_utilities.log_message ('Date From (DD/MM/RRRR) - ' || to_char(o_from_date, 'DD/MM/RRRR'));
3333: msd_dem_common_utilities.log_message ('Date To (DD/MM/RRRR) - ' || to_char(o_to_date, 'DD/MM/RRRR'));
3334:
3335: msd_dem_common_utilities.log_message (' ');
3336:
3337: msd_dem_common_utilities.log_debug ('Existing: msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3338:
3339: EXCEPTION

Line 3337: msd_dem_common_utilities.log_debug ('Existing: msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3333: msd_dem_common_utilities.log_message ('Date To (DD/MM/RRRR) - ' || to_char(o_to_date, 'DD/MM/RRRR'));
3334:
3335: msd_dem_common_utilities.log_message (' ');
3336:
3337: msd_dem_common_utilities.log_debug ('Existing: msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3338:
3339: EXCEPTION
3340: WHEN OTHERS THEN
3341: errbuf := substr(SQLERRM,1,150);

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

3339: EXCEPTION
3340: WHEN OTHERS THEN
3341: errbuf := substr(SQLERRM,1,150);
3342: retcode := -1 ;
3343: msd_dem_common_utilities.log_message ('Exception: msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3344: msd_dem_common_utilities.log_message (errbuf);
3345:
3346: END UI_params_validation;
3347:

Line 3344: msd_dem_common_utilities.log_message (errbuf);

3340: WHEN OTHERS THEN
3341: errbuf := substr(SQLERRM,1,150);
3342: retcode := -1 ;
3343: msd_dem_common_utilities.log_message ('Exception: msd_dem_common_utilities.UI_params_validation - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3344: msd_dem_common_utilities.log_message (errbuf);
3345:
3346: END UI_params_validation;
3347:
3348:

Line 3391: raise_application_error (-20001, 'Error: msd_dem_common_utilities.update_dem_params - Unable to find schema name.');

3387: BEGIN
3388:
3389: /*-- START : basic check conditions --*/
3390: IF (x_dem_schema IS NULL) THEN
3391: raise_application_error (-20001, 'Error: msd_dem_common_utilities.update_dem_params - Unable to find schema name.');
3392: END IF;
3393:
3394:
3395: IF (p_start_param IS NOT NULL AND p_start_bucket IS NULL) THEN

Line 3396: raise_application_error (-20002, 'Error: msd_dem_common_utilities.update_dem_params - Missing value for BucketStart adjustment.');

3392: END IF;
3393:
3394:
3395: IF (p_start_param IS NOT NULL AND p_start_bucket IS NULL) THEN
3396: raise_application_error (-20002, 'Error: msd_dem_common_utilities.update_dem_params - Missing value for BucketStart adjustment.');
3397:
3398: ELSIF (p_start_param IS NOT NULL AND p_start_bucket IS NOT NULL) THEN
3399: BEGIN
3400: x_sql := 'SELECT 1 FROM ' || x_dem_schema || '.sys_params WHERE LOWER(pname)=''' || LOWER(p_start_param) || '''' ;

Line 3404: raise_application_error (-20003, 'Error: msd_dem_common_utilities.update_dem_params - ' || p_start_param ||' Parameter doesnot exist.');

3400: x_sql := 'SELECT 1 FROM ' || x_dem_schema || '.sys_params WHERE LOWER(pname)=''' || LOWER(p_start_param) || '''' ;
3401: EXECUTE IMMEDIATE x_sql INTO x_is_exists ;
3402: EXCEPTION
3403: WHEN OTHERS THEN
3404: raise_application_error (-20003, 'Error: msd_dem_common_utilities.update_dem_params - ' || p_start_param ||' Parameter doesnot exist.');
3405: END;
3406:
3407: IF (p_pivot_param IS NULL) THEN
3408: raise_application_error (-20004, 'Error: msd_dem_common_utilities.update_dem_params - Missing BASE parameter name.');

Line 3408: raise_application_error (-20004, 'Error: msd_dem_common_utilities.update_dem_params - Missing BASE parameter name.');

3404: raise_application_error (-20003, 'Error: msd_dem_common_utilities.update_dem_params - ' || p_start_param ||' Parameter doesnot exist.');
3405: END;
3406:
3407: IF (p_pivot_param IS NULL) THEN
3408: raise_application_error (-20004, 'Error: msd_dem_common_utilities.update_dem_params - Missing BASE parameter name.');
3409: ELSE
3410: BEGIN
3411:
3412: x_sql := 'SELECT 1 FROM ' || x_dem_schema || '.sys_params WHERE LOWER(pname)=''' || LOWER(p_pivot_param) || '''' ;

Line 3416: raise_application_error (-20005, 'Error: msd_dem_common_utilities.update_dem_params - ' || p_pivot_param ||' Parameter doesnot exist.');

3412: x_sql := 'SELECT 1 FROM ' || x_dem_schema || '.sys_params WHERE LOWER(pname)=''' || LOWER(p_pivot_param) || '''' ;
3413: EXECUTE IMMEDIATE x_sql INTO x_is_exists ;
3414: EXCEPTION
3415: WHEN OTHERS THEN
3416: raise_application_error (-20005, 'Error: msd_dem_common_utilities.update_dem_params - ' || p_pivot_param ||' Parameter doesnot exist.');
3417: END;
3418: END IF;
3419:
3420: END IF;

Line 3423: raise_application_error (-20006, 'Error: msd_dem_common_utilities.update_dem_params - Missing start parameter name.');

3419:
3420: END IF;
3421:
3422: IF (p_start_param IS NULL AND p_start_bucket IS NOT NULL) THEN
3423: raise_application_error (-20006, 'Error: msd_dem_common_utilities.update_dem_params - Missing start parameter name.');
3424:
3425: END IF;
3426:
3427:

Line 3429: raise_application_error (-20007, 'Error: msd_dem_common_utilities.update_dem_params - Missing value for BucketEnd adjustment.');

3425: END IF;
3426:
3427:
3428: IF (p_end_param IS NOT NULL AND p_end_bucket IS NULL) THEN
3429: raise_application_error (-20007, 'Error: msd_dem_common_utilities.update_dem_params - Missing value for BucketEnd adjustment.');
3430: ELSIF (p_end_param IS NOT NULL AND p_end_bucket IS NOT NULL) THEN
3431: BEGIN
3432: --x_is_exists := NULL;
3433: x_sql := 'SELECT 1 FROM ' || x_dem_schema || '.sys_params WHERE LOWER(pname)=''' || LOWER(p_end_param) || '''' ;

Line 3437: RAISE_APPLICATION_ERROR (-20008, 'Error: msd_dem_common_utilities.update_dem_params - ' || p_end_param ||' Parameter doesnot exist.');

3433: x_sql := 'SELECT 1 FROM ' || x_dem_schema || '.sys_params WHERE LOWER(pname)=''' || LOWER(p_end_param) || '''' ;
3434: EXECUTE IMMEDIATE x_sql INTO x_is_exists ;
3435: EXCEPTION
3436: WHEN OTHERS THEN
3437: RAISE_APPLICATION_ERROR (-20008, 'Error: msd_dem_common_utilities.update_dem_params - ' || p_end_param ||' Parameter doesnot exist.');
3438: END;
3439:
3440: IF (p_pivot_param IS NULL) THEN
3441: raise_application_error (-20009, 'Error: msd_dem_common_utilities.update_dem_params - Missing BASE parameter name.');

Line 3441: raise_application_error (-20009, 'Error: msd_dem_common_utilities.update_dem_params - Missing BASE parameter name.');

3437: RAISE_APPLICATION_ERROR (-20008, 'Error: msd_dem_common_utilities.update_dem_params - ' || p_end_param ||' Parameter doesnot exist.');
3438: END;
3439:
3440: IF (p_pivot_param IS NULL) THEN
3441: raise_application_error (-20009, 'Error: msd_dem_common_utilities.update_dem_params - Missing BASE parameter name.');
3442: ELSE
3443: BEGIN
3444: x_sql := 'SELECT 1 FROM ' || x_dem_schema || '.sys_params WHERE LOWER(pname)=''' || LOWER(p_pivot_param) || '''' ;
3445: EXECUTE IMMEDIATE x_sql INTO x_is_exists ;

Line 3448: raise_application_error (-200010, 'Error: msd_dem_common_utilities.update_dem_params - ' || p_pivot_param ||' Parameter doesnot exist.');

3444: x_sql := 'SELECT 1 FROM ' || x_dem_schema || '.sys_params WHERE LOWER(pname)=''' || LOWER(p_pivot_param) || '''' ;
3445: EXECUTE IMMEDIATE x_sql INTO x_is_exists ;
3446: EXCEPTION
3447: WHEN OTHERS THEN
3448: raise_application_error (-200010, 'Error: msd_dem_common_utilities.update_dem_params - ' || p_pivot_param ||' Parameter doesnot exist.');
3449: END;
3450: END IF;
3451:
3452: END IF;

Line 3455: raise_application_error (-20011, 'Error: msd_dem_common_utilities.update_dem_params - Missing END parameter name.');

3451:
3452: END IF;
3453:
3454: IF (p_end_param IS NULL AND p_end_bucket IS NOT NULL) THEN
3455: raise_application_error (-20011, 'Error: msd_dem_common_utilities.update_dem_params - Missing END parameter name.');
3456:
3457: END IF;
3458:
3459:

Line 3462: raise_application_error (-20012, 'Error: msd_dem_common_utilities.update_dem_params - Missing parameter value.');

3458:
3459:
3460:
3461: IF (p_param_name IS NOT NULL AND p_param_value IS NULL) THEN
3462: raise_application_error (-20012, 'Error: msd_dem_common_utilities.update_dem_params - Missing parameter value.');
3463: ELSIF (p_param_name IS NOT NULL AND p_param_value IS NOT NULL) THEN
3464: begin
3465: x_is_exists := NULL;
3466: x_sql := 'SELECT 1 FROM ' || x_dem_schema || '.sys_params WHERE LOWER(pname)=''' || LOWER(p_param_name) || '''' ;

Line 3470: RAISE_APPLICATION_ERROR (-20013, 'Error: msd_dem_common_utilities.update_dem_params - ' || p_param_name ||' Parameter doesnot exist.');

3466: x_sql := 'SELECT 1 FROM ' || x_dem_schema || '.sys_params WHERE LOWER(pname)=''' || LOWER(p_param_name) || '''' ;
3467: EXECUTE IMMEDIATE x_sql INTO x_is_exists ;
3468: EXCEPTION
3469: WHEN OTHERS THEN
3470: RAISE_APPLICATION_ERROR (-20013, 'Error: msd_dem_common_utilities.update_dem_params - ' || p_param_name ||' Parameter doesnot exist.');
3471: END;
3472: END IF;
3473:
3474: IF (p_param_name IS NULL AND p_param_value IS NOT NULL) THEN

Line 3475: raise_application_error (-20014, 'Error: msd_dem_common_utilities.update_dem_params - Missing parameter name.');

3471: END;
3472: END IF;
3473:
3474: IF (p_param_name IS NULL AND p_param_value IS NOT NULL) THEN
3475: raise_application_error (-20014, 'Error: msd_dem_common_utilities.update_dem_params - Missing parameter name.');
3476: END IF;
3477:
3478: /*-- END : basic check conditions --*/
3479:

Line 3527: RAISE_APPLICATION_ERROR (-20015, 'Error: msd_dem_common_utilities.update_dem_params - '|| substr(sqlerrm,1,150));

3523: END IF ;
3524:
3525: EXCEPTION
3526: WHEN OTHERS THEN
3527: RAISE_APPLICATION_ERROR (-20015, 'Error: msd_dem_common_utilities.update_dem_params - '|| substr(sqlerrm,1,150));
3528:
3529: END update_dem_params;
3530:
3531: /*

Line 3561: msd_dem_common_utilities.log_debug ('Entering: MSD_DEM_COMMON_UTILITIES.SET_SERIES_OPTIONS - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3557: x_retcode1 varchar2(100) := null;
3558:
3559:
3560: BEGIN
3561: msd_dem_common_utilities.log_debug ('Entering: MSD_DEM_COMMON_UTILITIES.SET_SERIES_OPTIONS - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3562:
3563: x_profile_id := to_number(msd_dem_common_utilities.get_app_id_text (
3564: 'MSD_DEM_DEMANTRA_OBJECT_ID',
3565: p_dataprofile,

Line 3563: x_profile_id := to_number(msd_dem_common_utilities.get_app_id_text (

3559:
3560: BEGIN
3561: msd_dem_common_utilities.log_debug ('Entering: MSD_DEM_COMMON_UTILITIES.SET_SERIES_OPTIONS - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3562:
3563: x_profile_id := to_number(msd_dem_common_utilities.get_app_id_text (
3564: 'MSD_DEM_DEMANTRA_OBJECT_ID',
3565: p_dataprofile,
3566: 1,
3567: 'id'));

Line 3571: msd_dem_common_utilities.log_debug(x_sql);

3567: 'id'));
3568:
3569: /*
3570: x_sql := 'select query_name from '|| p_schema || '.transfer_query where id = ' || x_profile_id;
3571: msd_dem_common_utilities.log_debug(x_sql);
3572: execute immediate x_sql into x_query_name ;
3573: msd_dem_common_utilities.log_debug('Refreshing profile - ' || x_query_name);
3574: msd_dem_common_utilities.REFRESH_PURGE_SERIES(x_errbuf1, x_retcode1, x_profile_id, p_schema);
3575:

Line 3573: msd_dem_common_utilities.log_debug('Refreshing profile - ' || x_query_name);

3569: /*
3570: x_sql := 'select query_name from '|| p_schema || '.transfer_query where id = ' || x_profile_id;
3571: msd_dem_common_utilities.log_debug(x_sql);
3572: execute immediate x_sql into x_query_name ;
3573: msd_dem_common_utilities.log_debug('Refreshing profile - ' || x_query_name);
3574: msd_dem_common_utilities.REFRESH_PURGE_SERIES(x_errbuf1, x_retcode1, x_profile_id, p_schema);
3575:
3576: IF (x_retcode1 = -1) THEN
3577: retcode := 1;

Line 3574: msd_dem_common_utilities.REFRESH_PURGE_SERIES(x_errbuf1, x_retcode1, x_profile_id, p_schema);

3570: x_sql := 'select query_name from '|| p_schema || '.transfer_query where id = ' || x_profile_id;
3571: msd_dem_common_utilities.log_debug(x_sql);
3572: execute immediate x_sql into x_query_name ;
3573: msd_dem_common_utilities.log_debug('Refreshing profile - ' || x_query_name);
3574: msd_dem_common_utilities.REFRESH_PURGE_SERIES(x_errbuf1, x_retcode1, x_profile_id, p_schema);
3575:
3576: IF (x_retcode1 = -1) THEN
3577: retcode := 1;
3578: errbuf := 'Error refreshing profile - ' || x_query_name ||'. ';

Line 3579: msd_dem_common_utilities.log_debug('Error Refreshing profile -' || x_query_name || ' : ' || x_errbuf1);

3575:
3576: IF (x_retcode1 = -1) THEN
3577: retcode := 1;
3578: errbuf := 'Error refreshing profile - ' || x_query_name ||'. ';
3579: msd_dem_common_utilities.log_debug('Error Refreshing profile -' || x_query_name || ' : ' || x_errbuf1);
3580: END IF;
3581: */
3582:
3583: --set series's Load option & Purge option

Line 3584: msd_dem_common_utilities.log_debug('Set purge for install base');

3580: END IF;
3581: */
3582:
3583: --set series's Load option & Purge option
3584: msd_dem_common_utilities.log_debug('Set purge for install base');
3585: x_srs_id := to_number(msd_dem_common_utilities.get_app_id_text (
3586: 'MSD_DEM_DEMANTRA_OBJECT_ID',
3587: p_series,
3588: 1,

Line 3585: x_srs_id := to_number(msd_dem_common_utilities.get_app_id_text (

3581: */
3582:
3583: --set series's Load option & Purge option
3584: msd_dem_common_utilities.log_debug('Set purge for install base');
3585: x_srs_id := to_number(msd_dem_common_utilities.get_app_id_text (
3586: 'MSD_DEM_DEMANTRA_OBJECT_ID',
3587: p_series,
3588: 1,
3589: 'forecast_type_id'));

Line 3591: msd_dem_common_utilities.log_debug(x_sql);

3587: p_series,
3588: 1,
3589: 'forecast_type_id'));
3590: x_sql := 'begin ' || p_schema|| '.API_MODIFY_INTEG_SERIES_ATTR('||x_profile_id||', '|| x_srs_id||', '|| p_load ||', '|| p_purge || '); end;';
3591: msd_dem_common_utilities.log_debug(x_sql);
3592: execute immediate x_sql;
3593:
3594: commit;
3595:

Line 3599: msd_dem_common_utilities.log_debug(x_sql);

3595:
3596: IF (p_notify = 1 ) THEN
3597: --notify app server
3598: x_sql := 'begin ' || p_schema|| '.API_NOTIFY_APS_INTEGRATION('||x_profile_id ||'); end;';
3599: msd_dem_common_utilities.log_debug(x_sql);
3600: execute immediate x_sql;
3601: END IF;
3602:
3603: msd_dem_common_utilities.log_debug ('Exiting: MSD_DEM_COMMON_UTILITIES.SET_SERIES_OPTIONS - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 3603: msd_dem_common_utilities.log_debug ('Exiting: MSD_DEM_COMMON_UTILITIES.SET_SERIES_OPTIONS - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3599: msd_dem_common_utilities.log_debug(x_sql);
3600: execute immediate x_sql;
3601: END IF;
3602:
3603: msd_dem_common_utilities.log_debug ('Exiting: MSD_DEM_COMMON_UTILITIES.SET_SERIES_OPTIONS - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3604:
3605: EXCEPTION
3606: WHEN OTHERS THEN
3607: retcode := -1;

Line 3609: msd_dem_common_utilities.log_message ('EXCEPTION : MSD_DEM_COMMON_UTILITIES.SET_SERIES_OPTIONS - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3605: EXCEPTION
3606: WHEN OTHERS THEN
3607: retcode := -1;
3608: errbuf := substr(SQLERRM,1,150);
3609: msd_dem_common_utilities.log_message ('EXCEPTION : MSD_DEM_COMMON_UTILITIES.SET_SERIES_OPTIONS - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3610: msd_dem_common_utilities.log_message (errbuf);
3611: RETURN;
3612:
3613: END SET_SERIES_OPTIONS;

Line 3610: msd_dem_common_utilities.log_message (errbuf);

3606: WHEN OTHERS THEN
3607: retcode := -1;
3608: errbuf := substr(SQLERRM,1,150);
3609: msd_dem_common_utilities.log_message ('EXCEPTION : MSD_DEM_COMMON_UTILITIES.SET_SERIES_OPTIONS - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3610: msd_dem_common_utilities.log_message (errbuf);
3611: RETURN;
3612:
3613: END SET_SERIES_OPTIONS;
3614: --BUG#13604468 --kkhatri

Line 3705: msd_dem_common_utilities.log_message( dem_schema_name || ' Workflow completed successfully.');

3701:
3702: IF (dem_status = 1) then
3703: DBMS_LOCK.SLEEP( p_check_finish );
3704: ElsIf (dem_status = 0) then
3705: msd_dem_common_utilities.log_message( dem_schema_name || ' Workflow completed successfully.');
3706: retcode := 0;
3707: exit;
3708: ElsIf (dem_status = -1) then
3709: msd_dem_common_utilities.log_message( dem_schema_name || ' Workflow Failed.');

Line 3709: msd_dem_common_utilities.log_message( dem_schema_name || ' Workflow Failed.');

3705: msd_dem_common_utilities.log_message( dem_schema_name || ' Workflow completed successfully.');
3706: retcode := 0;
3707: exit;
3708: ElsIf (dem_status = -1) then
3709: msd_dem_common_utilities.log_message( dem_schema_name || ' Workflow Failed.');
3710: retcode := -1;
3711: exit;
3712: Else
3713: msd_dem_common_utilities.log_message( dem_schema_name || ' Workflow Status not defined. ');

Line 3713: msd_dem_common_utilities.log_message( dem_schema_name || ' Workflow Status not defined. ');

3709: msd_dem_common_utilities.log_message( dem_schema_name || ' Workflow Failed.');
3710: retcode := -1;
3711: exit;
3712: Else
3713: msd_dem_common_utilities.log_message( dem_schema_name || ' Workflow Status not defined. ');
3714: retcode := 1;
3715: exit;
3716: End if;
3717:

Line 3721: msd_dem_common_utilities.log_message( dem_schema_name || ' Workflow timed out. Check status of the workflow');

3717:
3718: p_check_cnt := p_check_cnt + p_check_finish ;
3719:
3720: If (p_check_cnt >= p_time_out_cnt) then
3721: msd_dem_common_utilities.log_message( dem_schema_name || ' Workflow timed out. Check status of the workflow');
3722: retcode := 1;
3723: End if;
3724:
3725:

Line 3732: END MSD_DEM_COMMON_UTILITIES;

3728: RETURN retcode;
3729:
3730: END CHECK_WF_STATUS;
3731:
3732: END MSD_DEM_COMMON_UTILITIES;