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_DEMANTRA_UTILITIES dependencies on MSD_DEM_DEMANTRA_UTILITIES

Line 1: PACKAGE BODY MSD_DEM_DEMANTRA_UTILITIES AS

1: PACKAGE BODY MSD_DEM_DEMANTRA_UTILITIES AS
2: /* $Header: msddemdub.pls 120.5.12020000.3 2012/11/22 10:57:28 nallkuma ship $ */
3:
4:
5:

Line 66: log_debug ('msd_dem_demantra_utilities.set_demantra_schema : the demantra schema is ' || g_demantra_schema_name);

62:
63: EXECUTE IMMEDIATE 'SELECT count(1) FROM ' || g_demantra_schema_name || '.MDP_MATRIX WHERE rownum <2'
64: INTO x_count;
65:
66: log_debug ('msd_dem_demantra_utilities.set_demantra_schema : the demantra schema is ' || g_demantra_schema_name);
67:
68: log_debug ('Exiting msd_dem_demantra_utilities.set_demantra_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
69: RETURN 0;
70:

Line 68: log_debug ('Exiting msd_dem_demantra_utilities.set_demantra_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

64: INTO x_count;
65:
66: log_debug ('msd_dem_demantra_utilities.set_demantra_schema : the demantra schema is ' || g_demantra_schema_name);
67:
68: log_debug ('Exiting msd_dem_demantra_utilities.set_demantra_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
69: RETURN 0;
70:
71: EXCEPTION
72: WHEN OTHERS THEN

Line 169: log_debug ('Entering msd_dem_demantra_utilities.get_sequence_nextval ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

165: RETURN -3;
166: END IF;
167: END IF;
168:
169: log_debug ('Entering msd_dem_demantra_utilities.get_sequence_nextval ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
170:
171: IF (g_is_demantra_schema = FALSE)
172: THEN
173: log_debug ('Alter the schema for the session to ' || g_demantra_schema_name );

Line 187: log_message ('Error(1) in function msd_dem_demantra_utilities.get_sequence_nextval ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

183: EXECUTE IMMEDIATE x_sql USING p_table_name, p_column_name, p_seq_name, OUT x_sequence_nextval;
184:
185: IF (x_sequence_nextval = -1)
186: THEN
187: log_message ('Error(1) in function msd_dem_demantra_utilities.get_sequence_nextval ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
188: log_message ('Table ' || p_table_name || 'does not exist.');
189: RETURN -1;
190: ELSIF (x_sequence_nextval = -1)
191: THEN

Line 192: log_message ('Error(2) in function msd_dem_demantra_utilities.get_sequence_nextval ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

188: log_message ('Table ' || p_table_name || 'does not exist.');
189: RETURN -1;
190: ELSIF (x_sequence_nextval = -1)
191: THEN
192: log_message ('Error(2) in function msd_dem_demantra_utilities.get_sequence_nextval ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
193: log_message ('Column ' || p_column_name || 'does not exist in the table ' || p_table_name || '.');
194: RETURN -2;
195: END IF;
196:

Line 208: log_debug ('Exiting msd_dem_demantra_utilities.get_sequence_nextval ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

204: log_debug (x_sql);
205: EXECUTE IMMEDIATE x_sql;
206: END IF;
207:
208: log_debug ('Exiting msd_dem_demantra_utilities.get_sequence_nextval ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
209: RETURN x_sequence_nextval;
210:
211: EXCEPTION
212: WHEN OTHERS THEN

Line 222: log_message ('Exception in function msd_dem_demantra_utilities.get_sequence_nextval ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

218: log_debug (x_sql);
219: EXECUTE IMMEDIATE x_sql;
220: END IF;
221:
222: log_message ('Exception in function msd_dem_demantra_utilities.get_sequence_nextval ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
223: log_message (substr(SQLERRM,1,150));
224: RETURN -4;
225:
226: END GET_SEQUENCE_NEXTVAL;

Line 281: log_debug ('Entering msd_dem_demantra_utilities.create_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

277: END IF;
278: END IF;
279:
280:
281: log_debug ('Entering msd_dem_demantra_utilities.create_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
282:
283: log_debug ('Verify that mandatory parameters should be not null');
284: IF ( p_computed_name IS NULL
285: OR p_exp_template IS NULL

Line 298: log_message ('Error(1) in function msd_dem_demantra_utilities.create_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

294: OR p_expression_type IS NULL
295: OR p_int_aggr_func IS NULL
296: OR p_data_type IS NULL)
297: THEN
298: log_message ('Error(1) in function msd_dem_demantra_utilities.create_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
299: log_message ('Some of the mandatory parameters are null');
300: RETURN -4;
301: END IF;
302:

Line 311: log_message ('Error(2) in function msd_dem_demantra_utilities.create_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

307: 'FORECAST_TYPE_ID',
308: 'COMPUTED_FIELDS_SEQ');
309: IF (x_forecast_type_id < 0)
310: THEN
311: log_message ('Error(2) in function msd_dem_demantra_utilities.create_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
312: log_message ('Unable to get next sequence value for forecast type id');
313: RETURN -5;
314: END IF;
315: log_debug ('Next sequence value for forecast_type_id : ' || to_char(x_forecast_type_id));

Line 341: log_message ('Error(3) in function msd_dem_demantra_utilities.create_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

337: USING g_demantra_schema_name, p_dbname;
338:
339: IF (x_return_value = 1)
340: THEN
341: log_message ('Error(3) in function msd_dem_demantra_utilities.create_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
342: log_message ('Column ' || p_dbname || ' already exists in the SALES_DATA table');
343: RETURN -6;
344: END IF;
345:

Line 390: log_debug ('Exiting msd_dem_demantra_utilities.create_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

386: p_aggr_by, p_preservation_type, p_move_preservation_type, p_data_type;
387: COMMIT;
388: log_debug ('Insert statement executed successfully');
389:
390: log_debug ('Exiting msd_dem_demantra_utilities.create_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
391: RETURN x_forecast_type_id;
392:
393: EXCEPTION
394: WHEN OTHERS THEN

Line 395: log_message ('Exception in function msd_dem_demantra_utilities.create_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

391: RETURN x_forecast_type_id;
392:
393: EXCEPTION
394: WHEN OTHERS THEN
395: log_message ('Exception in function msd_dem_demantra_utilities.create_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
396: log_message (substr(SQLERRM,1,150));
397: RETURN -1;
398:
399: END CREATE_SERIES;

Line 432: log_debug ('Entering msd_dem_demantra_utilities.delete_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

428: END IF;
429: END IF;
430:
431:
432: log_debug ('Entering msd_dem_demantra_utilities.delete_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
433:
434: log_debug ('Get series info for ' || p_computed_name);
435: x_sql := 'SELECT forecast_type_id, dbname '
436: || ' FROM ' || g_demantra_schema_name || '.COMPUTED_FIELDS '

Line 502: log_debug ('Exiting msd_dem_demantra_utilities.delete_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

498: log_debug ('Column ' || x_dbname || 'dropped successfully');
499:
500: END IF;
501:
502: log_debug ('Exiting msd_dem_demantra_utilities.delete_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
503: RETURN x_series_id;
504:
505: EXCEPTION
506: WHEN NO_DATA_FOUND THEN

Line 507: log_message ('Exception(1) in function msd_dem_demantra_utilities.delete_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

503: RETURN x_series_id;
504:
505: EXCEPTION
506: WHEN NO_DATA_FOUND THEN
507: log_message ('Exception(1) in function msd_dem_demantra_utilities.delete_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
508: log_message (substr(SQLERRM,1,150));
509: log_message ('Series : ' || p_computed_name || ' is not present. ');
510: RETURN -2;
511: WHEN OTHERS THEN

Line 512: log_message ('Exception(2) in function msd_dem_demantra_utilities.delete_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

508: log_message (substr(SQLERRM,1,150));
509: log_message ('Series : ' || p_computed_name || ' is not present. ');
510: RETURN -2;
511: WHEN OTHERS THEN
512: log_message ('Exception(2) in function msd_dem_demantra_utilities.delete_series ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
513: log_message (substr(SQLERRM,1,150));
514: RETURN -1;
515:
516: END DELETE_SERIES;

Line 551: log_debug ('Entering msd_dem_demantra_utilities.add_series_to_component ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

547: END IF;
548: END IF;
549:
550:
551: log_debug ('Entering msd_dem_demantra_utilities.add_series_to_component ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
552:
553: log_debug ('Check if series with id : ' || to_char(p_series_id) || ' is present or not.');
554: x_sql := ' SELECT computed_title FROM ' || g_demantra_schema_name || '.COMPUTED_FIELDS WHERE forecast_type_id = :1 ';
555: log_debug (x_sql);

Line 593: log_debug ('Exiting msd_dem_demantra_utilities.add_series_to_component ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

589:
590: COMMIT;
591: log_debug ('Series successfully added to the component and its owner.');
592:
593: log_debug ('Exiting msd_dem_demantra_utilities.add_series_to_component ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
594: RETURN 0;
595:
596:
597: EXCEPTION

Line 599: log_message ('Exception in function msd_dem_demantra_utilities.add_series_to_component ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

595:
596:
597: EXCEPTION
598: WHEN OTHERS THEN
599: log_message ('Exception in function msd_dem_demantra_utilities.add_series_to_component ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
600: log_message (substr(SQLERRM,1,150));
601: RETURN -1;
602:
603: END ADD_SERIES_TO_COMPONENT;

Line 639: log_debug ('Entering msd_dem_demantra_utilities.create_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

635: RETURN -3;
636: END IF;
637: END IF;
638:
639: log_debug ('Entering msd_dem_demantra_utilities.create_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
640:
641: log_debug ('Check if an integration interface with the same name already exists');
642: x_sql := 'SELECT count(1) FROM ' || g_demantra_schema_name || '.TRANSFER_LIST WHERE name = :1 ';
643: log_debug (x_sql);

Line 650: log_message ('Error(1) in function msd_dem_demantra_utilities.create_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

646: USING p_name;
647:
648: IF (x_return_value = 1)
649: THEN
650: log_message ('Error(1) in function msd_dem_demantra_utilities.create_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
651: log_message ('Integration interface : ' || p_name || ' already exists.');
652: RETURN -4;
653: END IF;
654:

Line 663: log_message ('Error(2) in function msd_dem_demantra_utilities.create_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

659: 'ID',
660: 'TRANSFER_ID_SEQ');
661: IF (x_integration_interface_id < 0)
662: THEN
663: log_message ('Error(2) in function msd_dem_demantra_utilities.create_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
664: log_message ('Unable to get next sequence value for integration interface id');
665: RETURN -5;
666: END IF;
667: log_debug ('Next sequence value for id : ' || to_char(x_integration_interface_id));

Line 681: log_debug ('Exiting msd_dem_demantra_utilities.create_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

677:
678: COMMIT;
679: log_debug ('Integration Interface created successfully');
680:
681: log_debug ('Exiting msd_dem_demantra_utilities.create_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
682: RETURN x_integration_interface_id;
683:
684: EXCEPTION
685: WHEN OTHERS THEN

Line 686: log_message ('Exception in function msd_dem_demantra_utilities.create_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

682: RETURN x_integration_interface_id;
683:
684: EXCEPTION
685: WHEN OTHERS THEN
686: log_message ('Exception in function msd_dem_demantra_utilities.create_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
687: log_message (substr(SQLERRM,1,150));
688: RETURN -1;
689:
690: END CREATE_INTEGRATION_INTERFACE;

Line 719: log_debug ('Entering msd_dem_demantra_utilities.delete_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

715: RETURN -3;
716: END IF;
717: END IF;
718:
719: log_debug ('Entering msd_dem_demantra_utilities.delete_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
720:
721: log_debug ('Deleting the integration interface '|| p_name || ' all the profiles under it.');
722: x_sql := 'DELETE FROM ' || g_demantra_schema_name || '.TRANSFER_LIST WHERE name = :1 ';
723: log_debug (x_sql);

Line 729: log_debug ('Exiting msd_dem_demantra_utilities.delete_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

725:
726: COMMIT;
727: log_debug ('Integration Interface deleted successfully');
728:
729: log_debug ('Exiting msd_dem_demantra_utilities.delete_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
730: RETURN 0;
731:
732: EXCEPTION
733: WHEN OTHERS THEN

Line 734: log_message ('Exception in function msd_dem_demantra_utilities.delete_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

730: RETURN 0;
731:
732: EXCEPTION
733: WHEN OTHERS THEN
734: log_message ('Exception in function msd_dem_demantra_utilities.delete_integration_interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
735: log_message (substr(SQLERRM,1,150));
736: RETURN -1;
737:
738: END DELETE_INTEGRATION_INTERFACE;

Line 787: log_debug ('Entering msd_dem_demantra_utilities.create_data_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

783: RETURN -3;
784: END IF;
785: END IF;
786:
787: log_debug ('Entering msd_dem_demantra_utilities.create_data_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
788:
789: log_debug ('Check if a data profile with the same name already exists or not');
790: x_sql := 'SELECT count(1) FROM ' || g_demantra_schema_name || '.TRANSFER_QUERY WHERE query_name = :1 ';
791: log_debug (x_sql);

Line 798: log_message ('Error(1) in function msd_dem_demantra_utilities.create_data_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

794: USING p_query_name;
795:
796: IF (x_return_value = 1)
797: THEN
798: log_message ('Error(1) in function msd_dem_demantra_utilities.create_data_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
799: log_message ('Data Profile : ' || p_query_name || ' already exists.');
800: RETURN -4;
801: END IF;
802:

Line 811: log_message ('Error(2) in function msd_dem_demantra_utilities.create_data_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

807: 'ID',
808: 'TRANSFER_QUERY_SEQ');
809: IF (x_data_profile_id < 0)
810: THEN
811: log_message ('Error(2) in function msd_dem_demantra_utilities.create_data_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
812: log_message ('Unable to get next sequence value for data profile id');
813: RETURN -5;
814: END IF;
815: log_debug ('Next sequence value for id : ' || to_char(x_data_profile_id));

Line 856: log_debug ('Exiting msd_dem_demantra_utilities.create_data_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

852:
853: COMMIT;
854: log_debug ('Data Profile created successfully.');
855:
856: log_debug ('Exiting msd_dem_demantra_utilities.create_data_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
857: RETURN x_data_profile_id;
858:
859: EXCEPTION
860: WHEN OTHERS THEN

Line 861: log_message ('Exception in function msd_dem_demantra_utilities.create_data_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

857: RETURN x_data_profile_id;
858:
859: EXCEPTION
860: WHEN OTHERS THEN
861: log_message ('Exception in function msd_dem_demantra_utilities.create_data_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
862: log_message (substr(SQLERRM,1,150));
863: RETURN -1;
864:
865: END CREATE_DATA_PROFILE;

Line 895: log_debug ('Entering msd_dem_demantra_utilities.add_series_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

891: RETURN -3;
892: END IF;
893: END IF;
894:
895: log_debug ('Entering msd_dem_demantra_utilities.add_series_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
896:
897: log_debug ('Adding series : ' || to_char(p_series_id) || ' to the profile : ' || to_char(p_data_profile_id));
898: x_sql := 'INSERT INTO ' || g_demantra_schema_name || '.TRANSFER_QUERY_SERIES ( ID, SERIES_ID, LOAD_OPTION, PURGE_OPTION ) '
899: || ' VALUES ( :1, :2, 0, 0 ) ';

Line 906: log_debug ('Exiting msd_dem_demantra_utilities.add_series_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

902:
903: COMMIT;
904: log_debug ('Series added successfully to the data profile');
905:
906: log_debug ('Exiting msd_dem_demantra_utilities.add_series_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
907: RETURN 0;
908:
909: EXCEPTION
910: WHEN OTHERS THEN

Line 911: log_message ('Exception in function msd_dem_demantra_utilities.add_series_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

907: RETURN 0;
908:
909: EXCEPTION
910: WHEN OTHERS THEN
911: log_message ('Exception in function msd_dem_demantra_utilities.add_series_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
912: log_message (substr(SQLERRM,1,150));
913: RETURN -1;
914:
915: END ADD_SERIES_TO_PROFILE;

Line 944: log_debug ('Entering msd_dem_demantra_utilities.add_level_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

940: RETURN -3;
941: END IF;
942: END IF;
943:
944: log_debug ('Entering msd_dem_demantra_utilities.add_level_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
945:
946: log_debug ('Adding level : ' || to_char(p_level_id) || ' to the profile : ' || to_char(p_data_profile_id));
947: x_sql := 'INSERT INTO ' || g_demantra_schema_name || '.TRANSFER_QUERY_LEVELS ( ID, LEVEL_ID, LORDER ) '
948: || ' VALUES ( :1, :2, :3 ) ';

Line 955: log_debug ('Exiting msd_dem_demantra_utilities.add_level_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

951:
952: COMMIT;
953: log_debug ('Level added successfully to the data profile');
954:
955: log_debug ('Exiting msd_dem_demantra_utilities.add_level_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
956: RETURN 0;
957:
958: EXCEPTION
959: WHEN OTHERS THEN

Line 960: log_message ('Exception in function msd_dem_demantra_utilities.add_level_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

956: RETURN 0;
957:
958: EXCEPTION
959: WHEN OTHERS THEN
960: log_message ('Exception in function msd_dem_demantra_utilities.add_level_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
961: log_message (substr(SQLERRM,1,150));
962: RETURN -1;
963:
964: END ADD_LEVEL_TO_PROFILE;

Line 1003: log_debug ('Entering msd_dem_demantra_utilities.create_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

999: RETURN -3;
1000: END IF;
1001: END IF;
1002:
1003: log_debug ('Entering msd_dem_demantra_utilities.create_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1004:
1005: log_debug ('First check if the workflow schema : ' || p_schema_name || ' already exists or not. ');
1006: x_sql := 'SELECT count(1) FROM ' || g_demantra_schema_name || '.WF_SCHEMAS WHERE schema_name = :1 ';
1007: log_debug (x_sql);

Line 1014: log_message ('Error(1) in function msd_dem_demantra_utilities.create_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1010: USING p_schema_name;
1011:
1012: IF (x_return_value <> 0)
1013: THEN
1014: log_message ('Error(1) in function msd_dem_demantra_utilities.create_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1015: log_message ('Workflow Schema : ' || p_schema_name || ' already exists.');
1016: RETURN -4;
1017: END IF;
1018:

Line 1027: log_message ('Error(2) in function msd_dem_demantra_utilities.create_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1023: 'SCHEMA_ID',
1024: 'WF_SCHEMA_ID_SEQ');
1025: IF (x_schema_id < 0)
1026: THEN
1027: log_message ('Error(2) in function msd_dem_demantra_utilities.create_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1028: log_message ('Unable to get next sequence value for schema id');
1029: RETURN -5;
1030: END IF;
1031: log_debug ('Next sequence value for id : ' || to_char(x_schema_id));

Line 1049: log_debug ('Exiting msd_dem_demantra_utilities.create_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1045:
1046: COMMIT;
1047: log_debug ('Workflow Schema created successfully');
1048:
1049: log_debug ('Exiting msd_dem_demantra_utilities.create_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1050: RETURN x_schema_id;
1051:
1052: EXCEPTION
1053: WHEN OTHERS THEN

Line 1054: log_message ('Exception in function msd_dem_demantra_utilities.create_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1050: RETURN x_schema_id;
1051:
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: log_message ('Exception in function msd_dem_demantra_utilities.create_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1055: log_message (substr(SQLERRM,1,150));
1056: RETURN -1;
1057:
1058: END CREATE_WORKFLOW_SCHEMA;

Line 1086: log_debug ('Entering msd_dem_demantra_utilities.delete_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1082: RETURN -3;
1083: END IF;
1084: END IF;
1085:
1086: log_debug ('Entering msd_dem_demantra_utilities.delete_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1087:
1088: log_debug ('Deleting workflow schema : ' || p_schema_name);
1089: x_sql := 'DELETE FROM ' || g_demantra_schema_name || '.WF_SCHEMAS WHERE schema_name = :1 ';
1090: log_debug (x_sql);

Line 1096: log_debug ('Exiting msd_dem_demantra_utilities.delete_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1092:
1093: COMMIT;
1094: log_debug ('Workflow Schema deleted successfully.');
1095:
1096: log_debug ('Exiting msd_dem_demantra_utilities.delete_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1097: RETURN 0;
1098:
1099: EXCEPTION
1100: WHEN OTHERS THEN

Line 1101: log_message ('Exception in function msd_dem_demantra_utilities.delete_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1097: RETURN 0;
1098:
1099: EXCEPTION
1100: WHEN OTHERS THEN
1101: log_message ('Exception in function msd_dem_demantra_utilities.delete_workflow_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1102: log_message (substr(SQLERRM,1,150));
1103: RETURN -1;
1104:
1105: END DELETE_WORKFLOW_SCHEMA;

Line 1128: log_debug ('Exiting msd_dem_demantra_utilities.get_demantra_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1124: RETURN null;
1125: END IF;
1126: END IF;
1127:
1128: log_debug ('Exiting msd_dem_demantra_utilities.get_demantra_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1129: RETURN g_demantra_schema_name;
1130:
1131: EXCEPTION
1132: WHEN OTHERS THEN

Line 1133: log_message ('Exception in function msd_dem_demantra_utilities.get_demantra_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1129: RETURN g_demantra_schema_name;
1130:
1131: EXCEPTION
1132: WHEN OTHERS THEN
1133: log_message ('Exception in function msd_dem_demantra_utilities.get_demantra_schema ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1134: log_message (substr(SQLERRM,1,150));
1135: RETURN null;
1136:
1137: END GET_DEMANTRA_SCHEMA;

Line 1165: log_debug ('Entering msd_dem_demantra_utilities.create_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1161: RETURN -3;
1162: END IF;
1163: END IF;
1164:
1165: log_debug ('Entering msd_dem_demantra_utilities.create_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1166:
1167: log_debug ('Demantra object : ' || p_object_name);
1168: log_debug ('Object Type : ' || p_object_type);
1169:

Line 1176: log_debug ('Exiting msd_dem_demantra_utilities.create_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1172: EXECUTE IMMEDIATE p_create_sql;
1173:
1174: log_debug ('DB Object created successfully.');
1175:
1176: log_debug ('Exiting msd_dem_demantra_utilities.create_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1177: RETURN 0;
1178:
1179: EXCEPTION
1180: WHEN OTHERS THEN

Line 1181: log_message ('Exception in function msd_dem_demantra_utilities.create_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1177: RETURN 0;
1178:
1179: EXCEPTION
1180: WHEN OTHERS THEN
1181: log_message ('Exception in function msd_dem_demantra_utilities.create_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1182: log_message (substr(SQLERRM,1,150));
1183: RETURN -1;
1184:
1185: END CREATE_DEMANTRA_DB_OBJECT;

Line 1216: log_debug ('Entering msd_dem_demantra_utilities.drop_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1212: RETURN -3;
1213: END IF;
1214: END IF;
1215:
1216: log_debug ('Entering msd_dem_demantra_utilities.drop_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1217:
1218: log_debug ('Demantra object : ' || p_object_name);
1219: log_debug ('Object Type : ' || p_object_type);
1220:

Line 1235: log_debug ('Exiting msd_dem_demantra_utilities.drop_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1231: EXECUTE IMMEDIATE x_sql;
1232:
1233: log_debug ('Demantra Object dropped successfully');
1234:
1235: log_debug ('Exiting msd_dem_demantra_utilities.drop_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1236: RETURN 0;
1237:
1238: EXCEPTION
1239:

Line 1241: log_message ('Exception(1) in function msd_dem_demantra_utilities.drop_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1237:
1238: EXCEPTION
1239:
1240: WHEN NO_DATA_FOUND THEN
1241: log_message ('Exception(1) in function msd_dem_demantra_utilities.drop_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1242: log_message (substr(SQLERRM,1,150));
1243: log_message ('Object to be dropped not found. Ignore this error.');
1244: RETURN 0;
1245:

Line 1247: log_message ('Exception(2) in function msd_dem_demantra_utilities.drop_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1243: log_message ('Object to be dropped not found. Ignore this error.');
1244: RETURN 0;
1245:
1246: WHEN OTHERS THEN
1247: log_message ('Exception(2) in function msd_dem_demantra_utilities.drop_demantra_db_object ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1248: log_message (substr(SQLERRM,1,150));
1249: RETURN -1;
1250:
1251: END DROP_DEMANTRA_DB_OBJECT;

Line 1280: log_debug ('Entering msd_dem_demantra_utilities.create_synonym_in_ebs ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1276: RETURN -3;
1277: END IF;
1278: END IF;
1279:
1280: log_debug ('Entering msd_dem_demantra_utilities.create_synonym_in_ebs ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1281:
1282: log_debug ('Object Name : ' || p_object_name);
1283:
1284: /* First check if Demantra and APS are on the same DB instance */

Line 1287: log_message ('Note in function msd_dem_demantra_utilities.create_synonym_in_ebs ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1283:
1284: /* First check if Demantra and APS are on the same DB instance */
1285: IF (g_is_demantra_schema)
1286: THEN
1287: log_message ('Note in function msd_dem_demantra_utilities.create_synonym_in_ebs ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1288: log_message ('Synonym ' || p_object_name || 'not created. Create the synonym manually.');
1289: RETURN 0;
1290: END IF;
1291:

Line 1298: log_debug ('Exiting msd_dem_demantra_utilities.create_synonym_in_ebs ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1294: EXECUTE IMMEDIATE p_create_replace_sql;
1295:
1296: log_debug ('Synonym created successfully.');
1297:
1298: log_debug ('Exiting msd_dem_demantra_utilities.create_synonym_in_ebs ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1299: RETURN 0;
1300:
1301: EXCEPTION
1302: WHEN OTHERS THEN

Line 1303: log_message ('Exception in function msd_dem_demantra_utilities.create_synonym_in_ebs ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1299: RETURN 0;
1300:
1301: EXCEPTION
1302: WHEN OTHERS THEN
1303: log_message ('Exception in function msd_dem_demantra_utilities.create_synonym_in_ebs ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1304: log_message (substr(SQLERRM,1,150));
1305: RETURN -1;
1306:
1307: END CREATE_SYNONYM_IN_EBS;

Line 1338: log_debug ('Entering msd_dem_demantra_utilities.add_intersect_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1334: RETURN -3;
1335: END IF;
1336: END IF;
1337:
1338: log_debug ('Entering msd_dem_demantra_utilities.add_intersect_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1339:
1340: log_debug ('Adding base_level_id : ' || to_char(p_base_level_id) || ' to the profile : ' || to_char(p_data_profile_id));
1341: x_sql := 'INSERT INTO ' || g_demantra_schema_name || '.TRANSFER_QUERY_INTERSECTIONS ( ID, BASE_LEVEL_ID, TYPE ) '
1342: || ' VALUES ( :1, :2, 1 ) ';

Line 1349: log_debug ('Exiting msd_dem_demantra_utilities.add_intersect_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1345:
1346: COMMIT;
1347: log_debug ('Base level id added successfully to the data profile');
1348:
1349: log_debug ('Exiting msd_dem_demantra_utilities.add_intersect_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1350: RETURN 0;
1351:
1352: EXCEPTION
1353: WHEN OTHERS THEN

Line 1354: log_message ('Exception in function msd_dem_demantra_utilities.add_intersect_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1350: RETURN 0;
1351:
1352: EXCEPTION
1353: WHEN OTHERS THEN
1354: log_message ('Exception in function msd_dem_demantra_utilities.add_intersect_to_profile ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1355: log_message (substr(SQLERRM,1,150));
1356: RETURN -1;
1357:
1358: END ADD_INTERSECT_TO_PROFILE;

Line 1903: END MSD_DEM_DEMANTRA_UTILITIES;

1899:
1900:
1901:
1902:
1903: END MSD_DEM_DEMANTRA_UTILITIES;