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.2.12010000.2 2008/05/07 11:01:53 sjagathe 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 167: log_debug ('Entering msd_dem_demantra_utilities.get_sequence_nextval ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1316: END MSD_DEM_DEMANTRA_UTILITIES;

1312:
1313:
1314:
1315:
1316: END MSD_DEM_DEMANTRA_UTILITIES;