APPS.MSD_DEM_COLLECT_PRICE_LISTS dependencies on MSD_DEM_COLLECT_PRICE_LISTS

Line 1: PACKAGE BODY MSD_DEM_COLLECT_PRICE_LISTS AS

1: PACKAGE BODY MSD_DEM_COLLECT_PRICE_LISTS AS
2: /* $Header: msddemprlclb.pls 120.14.12020000.2 2012/09/14 16:24:28 nallkuma ship $ */
3:
4: v_list varchar2(5000);
5:

Line 868: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

864:
865: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
866: IF (x_schema IS NULL)
867: THEN
868: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
869: || ' Unable to get Demantra schema name ');
870: retcode := -1;
871: RETURN;
872: END IF;

Line 883: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

879: EXECUTE IMMEDIATE x_stmt INTO x_price_list_col;
880:
881: IF (x_price_list_col IS NULL)
882: THEN
883: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
884: || ' Price List Column name is null ');
885: retcode := -1;
886: RETURN;
887: END IF;

Line 898: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

894: 1,
895: 1);
896: IF (x_retcode = -1)
897: THEN
898: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
899: || ' Failed to truncate BIIO_CTO_OPTION_PRICE');
900: retcode := -1;
901: errbuf := x_errbuf;
902: RETURN;

Line 914: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

910: 1,
911: 1);
912: IF (x_retcode = -1)
913: THEN
914: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
915: || ' Failed to truncate BIIO_CTO_OPTION_PRICE_ERR');
916: retcode := -1;
917: errbuf := x_errbuf;
918: RETURN;

Line 942: msd_dem_common_utilities.log_debug ('msd_dem_collect_price_lists.collect_price_lists - INFO - '

938:
939: msd_dem_common_utilities.log_debug('End - CTO Price');
940:
941: ELSE
942: msd_dem_common_utilities.log_debug ('msd_dem_collect_price_lists.collect_price_lists - INFO - '
943: || 'Include Dependent Demand is set to No. Hence no action taken for CTO Price');
944: END IF;
945:
946: /* Populate Scenario Price Staging Table if present */

Line 953: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR(2) - '

949: x_price_list_col := NULL;
950: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
951: IF (x_schema IS NULL)
952: THEN
953: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR(2) - '
954: || ' Unable to get Demantra schema name ');
955: retcode := -1;
956: RETURN;
957: END IF;

Line 978: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

974: EXECUTE IMMEDIATE x_stmt INTO x_price_list_col;
975:
976: IF (x_price_list_col IS NULL)
977: THEN
978: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
979: || ' Price List Column name is null ');
980: retcode := -1;
981: RETURN;
982: END IF;

Line 993: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

989: 1,
990: 1);
991: IF (x_retcode = -1)
992: THEN
993: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
994: || ' Failed to truncate BIIO_SCENARIO_PRICE');
995: retcode := -1;
996: errbuf := x_errbuf;
997: RETURN;

Line 1009: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

1005: 1,
1006: 1);
1007: IF (x_retcode = -1)
1008: THEN
1009: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
1010: || ' Failed to truncate BIIO_SCENARIO_PRICE_ERR');
1011: retcode := -1;
1012: errbuf := x_errbuf;
1013: RETURN;

Line 1037: msd_dem_common_utilities.log_debug ('msd_dem_collect_price_lists.collect_price_lists - INFO - '

1033:
1034: msd_dem_common_utilities.log_debug('End - Scenario Price');
1035:
1036: ELSE
1037: msd_dem_common_utilities.log_debug ('msd_dem_collect_price_lists.collect_price_lists - INFO - '
1038: || 'Staging tables for Scenario Price not found. Hence no action taken for Scenario Price');
1039:
1040: END IF;
1041:

Line 1210: END MSD_DEM_COLLECT_PRICE_LISTS;

1206: retcode := -1;
1207:
1208: end;
1209:
1210: END MSD_DEM_COLLECT_PRICE_LISTS;
1211: