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

Line 169: AND to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID',

165: tq.id = x_data_profile_id
166: AND tql.id = tq.id
167: AND gt.group_table_id = tql.level_id
168: AND flv.lookup_type = 'MSD_DEM_LEVELS'
169: AND to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID',
170: flv.meaning,
171: 1,
172: 'group_table_id')) = gt.group_table_id;
173:

Line 297: msd_dem_common_utilities.log_message ('Error: can not assign plan name to forecast' );

293:
294: ELSE
295: retcode := -1;
296: errbuf:='INVALID_DATA_PROFILE';
297: msd_dem_common_utilities.log_message ('Error: can not assign plan name to forecast' );
298: msd_dem_common_utilities.log_message(errbuf);
299: msd_dem_common_utilities.log_message ('Exiting: MSD_WS_DEM_RENAME_FORECAST.ASSIGN_PLAN_NAME_TO_FORECAST- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
300:
301: RETURN;

Line 298: msd_dem_common_utilities.log_message(errbuf);

294: ELSE
295: retcode := -1;
296: errbuf:='INVALID_DATA_PROFILE';
297: msd_dem_common_utilities.log_message ('Error: can not assign plan name to forecast' );
298: msd_dem_common_utilities.log_message(errbuf);
299: msd_dem_common_utilities.log_message ('Exiting: MSD_WS_DEM_RENAME_FORECAST.ASSIGN_PLAN_NAME_TO_FORECAST- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
300:
301: RETURN;
302: END IF;

Line 299: msd_dem_common_utilities.log_message ('Exiting: MSD_WS_DEM_RENAME_FORECAST.ASSIGN_PLAN_NAME_TO_FORECAST- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

295: retcode := -1;
296: errbuf:='INVALID_DATA_PROFILE';
297: msd_dem_common_utilities.log_message ('Error: can not assign plan name to forecast' );
298: msd_dem_common_utilities.log_message(errbuf);
299: msd_dem_common_utilities.log_message ('Exiting: MSD_WS_DEM_RENAME_FORECAST.ASSIGN_PLAN_NAME_TO_FORECAST- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
300:
301: RETURN;
302: END IF;
303:

Line 320: msd_dem_common_utilities.log_message ('Warning: IN assign plan name to forecast' );

316: IF (x_retcode = '1')
317: THEN
318: retcode := x_retcode;
319: errbuf:= x_errbuf;
320: msd_dem_common_utilities.log_message ('Warning: IN assign plan name to forecast' );
321: msd_dem_common_utilities.log_debug ('Warning: IN assign plan name to forecast' );
322: msd_dem_common_utilities.log_debug (errbuf);
323:
324: ELSIF(x_retcode = '-1')

Line 321: msd_dem_common_utilities.log_debug ('Warning: IN assign plan name to forecast' );

317: THEN
318: retcode := x_retcode;
319: errbuf:= x_errbuf;
320: msd_dem_common_utilities.log_message ('Warning: IN assign plan name to forecast' );
321: msd_dem_common_utilities.log_debug ('Warning: IN assign plan name to forecast' );
322: msd_dem_common_utilities.log_debug (errbuf);
323:
324: ELSIF(x_retcode = '-1')
325: THEN

Line 322: msd_dem_common_utilities.log_debug (errbuf);

318: retcode := x_retcode;
319: errbuf:= x_errbuf;
320: msd_dem_common_utilities.log_message ('Warning: IN assign plan name to forecast' );
321: msd_dem_common_utilities.log_debug ('Warning: IN assign plan name to forecast' );
322: msd_dem_common_utilities.log_debug (errbuf);
323:
324: ELSIF(x_retcode = '-1')
325: THEN
326: retcode := x_retcode;

Line 328: msd_dem_common_utilities.log_message ('Error: In assign plan name to forecast' );

324: ELSIF(x_retcode = '-1')
325: THEN
326: retcode := x_retcode;
327: errbuf:= x_errbuf;
328: msd_dem_common_utilities.log_message ('Error: In assign plan name to forecast' );
329: msd_dem_common_utilities.log_message(errbuf);
330: msd_dem_common_utilities.log_message ('Exiting: MSD_WS_DEM_RENAME_FORECAST.ASSIGN_PLAN_NAME_TO_FORECAST- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
331: RETURN;
332: END IF;

Line 329: msd_dem_common_utilities.log_message(errbuf);

325: THEN
326: retcode := x_retcode;
327: errbuf:= x_errbuf;
328: msd_dem_common_utilities.log_message ('Error: In assign plan name to forecast' );
329: msd_dem_common_utilities.log_message(errbuf);
330: msd_dem_common_utilities.log_message ('Exiting: MSD_WS_DEM_RENAME_FORECAST.ASSIGN_PLAN_NAME_TO_FORECAST- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
331: RETURN;
332: END IF;
333:

Line 330: msd_dem_common_utilities.log_message ('Exiting: MSD_WS_DEM_RENAME_FORECAST.ASSIGN_PLAN_NAME_TO_FORECAST- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

326: retcode := x_retcode;
327: errbuf:= x_errbuf;
328: msd_dem_common_utilities.log_message ('Error: In assign plan name to forecast' );
329: msd_dem_common_utilities.log_message(errbuf);
330: msd_dem_common_utilities.log_message ('Exiting: MSD_WS_DEM_RENAME_FORECAST.ASSIGN_PLAN_NAME_TO_FORECAST- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
331: RETURN;
332: END IF;
333:
334: EXCEPTION

Line 338: msd_dem_common_utilities.log_message ('Error: can not assign plan name to forecast' );

334: EXCEPTION
335: WHEN OTHERS THEN
336: retcode:= -1;
337: errbuf := substr(SQLERRM,1,150);
338: msd_dem_common_utilities.log_message ('Error: can not assign plan name to forecast' );
339: msd_dem_common_utilities.log_message ('Exception: MSD_WS_DEM_RENAME_FORECAST.ASSIGN_PLAN_NAME_TO_FORECAST - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') );
340: msd_dem_common_utilities.log_message (errbuf);
341: RETURN;
342:

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

335: WHEN OTHERS THEN
336: retcode:= -1;
337: errbuf := substr(SQLERRM,1,150);
338: msd_dem_common_utilities.log_message ('Error: can not assign plan name to forecast' );
339: msd_dem_common_utilities.log_message ('Exception: MSD_WS_DEM_RENAME_FORECAST.ASSIGN_PLAN_NAME_TO_FORECAST - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') );
340: msd_dem_common_utilities.log_message (errbuf);
341: RETURN;
342:
343:

Line 340: msd_dem_common_utilities.log_message (errbuf);

336: retcode:= -1;
337: errbuf := substr(SQLERRM,1,150);
338: msd_dem_common_utilities.log_message ('Error: can not assign plan name to forecast' );
339: msd_dem_common_utilities.log_message ('Exception: MSD_WS_DEM_RENAME_FORECAST.ASSIGN_PLAN_NAME_TO_FORECAST - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') );
340: msd_dem_common_utilities.log_message (errbuf);
341: RETURN;
342:
343:
344: END ASSIGN_PLAN_NAME_INT;

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

684:
685:
686: BEGIN
687:
688: msd_dem_common_utilities.log_debug ('Entering: msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
689: msd_dem_common_utilities.log_debug (' ');
690:
691: msd_dem_common_utilities.log_message (' ' || rpad('Plan Scenario Id', 30) || ' - ' || to_char(p_plan_scn_id));
692: msd_dem_common_utilities.log_message (' ' || rpad('Delete Associations', 30) || ' - ' || to_char(p_delete_assoc));

Line 689: msd_dem_common_utilities.log_debug (' ');

685:
686: BEGIN
687:
688: msd_dem_common_utilities.log_debug ('Entering: msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
689: msd_dem_common_utilities.log_debug (' ');
690:
691: msd_dem_common_utilities.log_message (' ' || rpad('Plan Scenario Id', 30) || ' - ' || to_char(p_plan_scn_id));
692: msd_dem_common_utilities.log_message (' ' || rpad('Delete Associations', 30) || ' - ' || to_char(p_delete_assoc));
693: msd_dem_common_utilities.log_message (' ');

Line 691: msd_dem_common_utilities.log_message (' ' || rpad('Plan Scenario Id', 30) || ' - ' || to_char(p_plan_scn_id));

687:
688: msd_dem_common_utilities.log_debug ('Entering: msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
689: msd_dem_common_utilities.log_debug (' ');
690:
691: msd_dem_common_utilities.log_message (' ' || rpad('Plan Scenario Id', 30) || ' - ' || to_char(p_plan_scn_id));
692: msd_dem_common_utilities.log_message (' ' || rpad('Delete Associations', 30) || ' - ' || to_char(p_delete_assoc));
693: msd_dem_common_utilities.log_message (' ');
694:
695: /* Get the scenario_id of given Plan scenario id */

Line 692: msd_dem_common_utilities.log_message (' ' || rpad('Delete Associations', 30) || ' - ' || to_char(p_delete_assoc));

688: msd_dem_common_utilities.log_debug ('Entering: msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
689: msd_dem_common_utilities.log_debug (' ');
690:
691: msd_dem_common_utilities.log_message (' ' || rpad('Plan Scenario Id', 30) || ' - ' || to_char(p_plan_scn_id));
692: msd_dem_common_utilities.log_message (' ' || rpad('Delete Associations', 30) || ' - ' || to_char(p_delete_assoc));
693: msd_dem_common_utilities.log_message (' ');
694:
695: /* Get the scenario_id of given Plan scenario id */
696: x_sql_stmt := 'SELECT nvl(sum(scenario_id), 0) '

Line 693: msd_dem_common_utilities.log_message (' ');

689: msd_dem_common_utilities.log_debug (' ');
690:
691: msd_dem_common_utilities.log_message (' ' || rpad('Plan Scenario Id', 30) || ' - ' || to_char(p_plan_scn_id));
692: msd_dem_common_utilities.log_message (' ' || rpad('Delete Associations', 30) || ' - ' || to_char(p_delete_assoc));
693: msd_dem_common_utilities.log_message (' ');
694:
695: /* Get the scenario_id of given Plan scenario id */
696: x_sql_stmt := 'SELECT nvl(sum(scenario_id), 0) '
697: || ' FROM msd_dp_scenarios mds '

Line 704: msd_dem_common_utilities.log_debug (x_sql_stmt);

700: || ' AND mds.scenario_id = ' || p_plan_scn_id ;
701:
702: EXECUTE IMMEDIATE x_sql_stmt INTO x_scenario_id ;
703:
704: msd_dem_common_utilities.log_debug (x_sql_stmt);
705: msd_dem_common_utilities.log_debug (' ');
706:
707: /* Check if the scenario_id is attached to any ascp plan */
708: x_sql_stmt := 'SELECT nvl(sum(1),0) FROM msc_plan_schedules WHERE input_schedule_id = ' || x_scenario_id ;

Line 705: msd_dem_common_utilities.log_debug (' ');

701:
702: EXECUTE IMMEDIATE x_sql_stmt INTO x_scenario_id ;
703:
704: msd_dem_common_utilities.log_debug (x_sql_stmt);
705: msd_dem_common_utilities.log_debug (' ');
706:
707: /* Check if the scenario_id is attached to any ascp plan */
708: x_sql_stmt := 'SELECT nvl(sum(1),0) FROM msc_plan_schedules WHERE input_schedule_id = ' || x_scenario_id ;
709:

Line 712: msd_dem_common_utilities.log_debug (x_sql_stmt);

708: x_sql_stmt := 'SELECT nvl(sum(1),0) FROM msc_plan_schedules WHERE input_schedule_id = ' || x_scenario_id ;
709:
710: EXECUTE IMMEDIATE x_sql_stmt INTO x_attached_flag ;
711:
712: msd_dem_common_utilities.log_debug (x_sql_stmt);
713: msd_dem_common_utilities.log_debug (' ');
714:
715: msd_dem_common_utilities.log_debug ('***Variables***');
716: msd_dem_common_utilities.log_debug ('x_scenario_id - ' || x_scenario_id);

Line 713: msd_dem_common_utilities.log_debug (' ');

709:
710: EXECUTE IMMEDIATE x_sql_stmt INTO x_attached_flag ;
711:
712: msd_dem_common_utilities.log_debug (x_sql_stmt);
713: msd_dem_common_utilities.log_debug (' ');
714:
715: msd_dem_common_utilities.log_debug ('***Variables***');
716: msd_dem_common_utilities.log_debug ('x_scenario_id - ' || x_scenario_id);
717: msd_dem_common_utilities.log_debug ('x_attached_flag - ' || x_attached_flag);

Line 715: msd_dem_common_utilities.log_debug ('Variables');

711:
712: msd_dem_common_utilities.log_debug (x_sql_stmt);
713: msd_dem_common_utilities.log_debug (' ');
714:
715: msd_dem_common_utilities.log_debug ('***Variables***');
716: msd_dem_common_utilities.log_debug ('x_scenario_id - ' || x_scenario_id);
717: msd_dem_common_utilities.log_debug ('x_attached_flag - ' || x_attached_flag);
718: msd_dem_common_utilities.log_debug ('p_delete_assoc - ' || p_delete_assoc);
719: msd_dem_common_utilities.log_debug (' ');

Line 716: msd_dem_common_utilities.log_debug ('x_scenario_id - ' || x_scenario_id);

712: msd_dem_common_utilities.log_debug (x_sql_stmt);
713: msd_dem_common_utilities.log_debug (' ');
714:
715: msd_dem_common_utilities.log_debug ('***Variables***');
716: msd_dem_common_utilities.log_debug ('x_scenario_id - ' || x_scenario_id);
717: msd_dem_common_utilities.log_debug ('x_attached_flag - ' || x_attached_flag);
718: msd_dem_common_utilities.log_debug ('p_delete_assoc - ' || p_delete_assoc);
719: msd_dem_common_utilities.log_debug (' ');
720:

Line 717: msd_dem_common_utilities.log_debug ('x_attached_flag - ' || x_attached_flag);

713: msd_dem_common_utilities.log_debug (' ');
714:
715: msd_dem_common_utilities.log_debug ('***Variables***');
716: msd_dem_common_utilities.log_debug ('x_scenario_id - ' || x_scenario_id);
717: msd_dem_common_utilities.log_debug ('x_attached_flag - ' || x_attached_flag);
718: msd_dem_common_utilities.log_debug ('p_delete_assoc - ' || p_delete_assoc);
719: msd_dem_common_utilities.log_debug (' ');
720:
721: IF (x_attached_flag <> 0 AND p_delete_assoc = C_NO) THEN -- scenario_id is attached, delete_assoc is NO

Line 718: msd_dem_common_utilities.log_debug ('p_delete_assoc - ' || p_delete_assoc);

714:
715: msd_dem_common_utilities.log_debug ('***Variables***');
716: msd_dem_common_utilities.log_debug ('x_scenario_id - ' || x_scenario_id);
717: msd_dem_common_utilities.log_debug ('x_attached_flag - ' || x_attached_flag);
718: msd_dem_common_utilities.log_debug ('p_delete_assoc - ' || p_delete_assoc);
719: msd_dem_common_utilities.log_debug (' ');
720:
721: IF (x_attached_flag <> 0 AND p_delete_assoc = C_NO) THEN -- scenario_id is attached, delete_assoc is NO
722:

Line 719: msd_dem_common_utilities.log_debug (' ');

715: msd_dem_common_utilities.log_debug ('***Variables***');
716: msd_dem_common_utilities.log_debug ('x_scenario_id - ' || x_scenario_id);
717: msd_dem_common_utilities.log_debug ('x_attached_flag - ' || x_attached_flag);
718: msd_dem_common_utilities.log_debug ('p_delete_assoc - ' || p_delete_assoc);
719: msd_dem_common_utilities.log_debug (' ');
720:
721: IF (x_attached_flag <> 0 AND p_delete_assoc = C_NO) THEN -- scenario_id is attached, delete_assoc is NO
722:
723: retcode := -1;

Line 725: msd_dem_common_utilities.log_message ('ERROR(1): msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

721: IF (x_attached_flag <> 0 AND p_delete_assoc = C_NO) THEN -- scenario_id is attached, delete_assoc is NO
722:
723: retcode := -1;
724: errbuf := 'There are associations for this plan, hence the plan cannot be deleted.';
725: msd_dem_common_utilities.log_message ('ERROR(1): msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
726: msd_dem_common_utilities.log_message ('There are associations for this plan, hence the plan cannot be deleted.');
727: msd_dem_common_utilities.log_message ('If you still want to delete, rerun program with parameter "Delete Associations to Supply Plans" set to yes');
728: msd_dem_common_utilities.log_message (' ');
729:

Line 726: msd_dem_common_utilities.log_message ('There are associations for this plan, hence the plan cannot be deleted.');

722:
723: retcode := -1;
724: errbuf := 'There are associations for this plan, hence the plan cannot be deleted.';
725: msd_dem_common_utilities.log_message ('ERROR(1): msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
726: msd_dem_common_utilities.log_message ('There are associations for this plan, hence the plan cannot be deleted.');
727: msd_dem_common_utilities.log_message ('If you still want to delete, rerun program with parameter "Delete Associations to Supply Plans" set to yes');
728: msd_dem_common_utilities.log_message (' ');
729:
730: RETURN;

Line 727: msd_dem_common_utilities.log_message ('If you still want to delete, rerun program with parameter "Delete Associations to Supply Plans" set to yes');

723: retcode := -1;
724: errbuf := 'There are associations for this plan, hence the plan cannot be deleted.';
725: msd_dem_common_utilities.log_message ('ERROR(1): msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
726: msd_dem_common_utilities.log_message ('There are associations for this plan, hence the plan cannot be deleted.');
727: msd_dem_common_utilities.log_message ('If you still want to delete, rerun program with parameter "Delete Associations to Supply Plans" set to yes');
728: msd_dem_common_utilities.log_message (' ');
729:
730: RETURN;
731:

Line 728: msd_dem_common_utilities.log_message (' ');

724: errbuf := 'There are associations for this plan, hence the plan cannot be deleted.';
725: msd_dem_common_utilities.log_message ('ERROR(1): msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
726: msd_dem_common_utilities.log_message ('There are associations for this plan, hence the plan cannot be deleted.');
727: msd_dem_common_utilities.log_message ('If you still want to delete, rerun program with parameter "Delete Associations to Supply Plans" set to yes');
728: msd_dem_common_utilities.log_message (' ');
729:
730: RETURN;
731:
732: ELSIF (x_attached_flag = 0 OR (x_attached_flag <> 0 AND p_delete_assoc = C_YES) ) THEN -- scenario_id is NOT attached OR scenario_id is attached, delete_assoc is YES

Line 740: msd_dem_common_utilities.log_debug (x_del_stmt);

736: EXECUTE IMMEDIATE x_del_stmt;
737: x_count := SQL%ROWCOUNT;
738: COMMIT;
739:
740: msd_dem_common_utilities.log_debug (x_del_stmt);
741: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
742: msd_dem_common_utilities.log_debug (' ');
743:
744: /* msd_dp_scenario_output_levels */

Line 741: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );

737: x_count := SQL%ROWCOUNT;
738: COMMIT;
739:
740: msd_dem_common_utilities.log_debug (x_del_stmt);
741: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
742: msd_dem_common_utilities.log_debug (' ');
743:
744: /* msd_dp_scenario_output_levels */
745: x_del_stmt := 'DELETE FROM msd_dp_scenario_output_levels WHERE scenario_id = ' || x_scenario_id ;

Line 742: msd_dem_common_utilities.log_debug (' ');

738: COMMIT;
739:
740: msd_dem_common_utilities.log_debug (x_del_stmt);
741: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
742: msd_dem_common_utilities.log_debug (' ');
743:
744: /* msd_dp_scenario_output_levels */
745: x_del_stmt := 'DELETE FROM msd_dp_scenario_output_levels WHERE scenario_id = ' || x_scenario_id ;
746: EXECUTE IMMEDIATE x_del_stmt;

Line 750: msd_dem_common_utilities.log_debug (x_del_stmt);

746: EXECUTE IMMEDIATE x_del_stmt;
747: x_count := SQL%ROWCOUNT;
748: COMMIT;
749:
750: msd_dem_common_utilities.log_debug (x_del_stmt);
751: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
752: msd_dem_common_utilities.log_debug (' ');
753:
754: /* msd_dp_scn_entries_denorm */

Line 751: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );

747: x_count := SQL%ROWCOUNT;
748: COMMIT;
749:
750: msd_dem_common_utilities.log_debug (x_del_stmt);
751: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
752: msd_dem_common_utilities.log_debug (' ');
753:
754: /* msd_dp_scn_entries_denorm */
755: x_del_stmt := 'DELETE FROM msd_dp_scn_entries_denorm WHERE scenario_id = ' || x_scenario_id ;

Line 752: msd_dem_common_utilities.log_debug (' ');

748: COMMIT;
749:
750: msd_dem_common_utilities.log_debug (x_del_stmt);
751: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
752: msd_dem_common_utilities.log_debug (' ');
753:
754: /* msd_dp_scn_entries_denorm */
755: x_del_stmt := 'DELETE FROM msd_dp_scn_entries_denorm WHERE scenario_id = ' || x_scenario_id ;
756: EXECUTE IMMEDIATE x_del_stmt;

Line 760: msd_dem_common_utilities.log_debug (x_del_stmt);

756: EXECUTE IMMEDIATE x_del_stmt;
757: x_count := SQL%ROWCOUNT;
758: COMMIT;
759:
760: msd_dem_common_utilities.log_debug (x_del_stmt);
761: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
762: msd_dem_common_utilities.log_debug (' ');
763:
764:

Line 761: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );

757: x_count := SQL%ROWCOUNT;
758: COMMIT;
759:
760: msd_dem_common_utilities.log_debug (x_del_stmt);
761: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
762: msd_dem_common_utilities.log_debug (' ');
763:
764:
765: IF (x_attached_flag <> 0 AND p_delete_assoc = C_YES) THEN

Line 762: msd_dem_common_utilities.log_debug (' ');

758: COMMIT;
759:
760: msd_dem_common_utilities.log_debug (x_del_stmt);
761: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
762: msd_dem_common_utilities.log_debug (' ');
763:
764:
765: IF (x_attached_flag <> 0 AND p_delete_assoc = C_YES) THEN
766: /* msc_plan_schedules */

Line 772: msd_dem_common_utilities.log_debug (x_del_stmt);

768: EXECUTE IMMEDIATE x_del_stmt;
769: x_count := SQL%ROWCOUNT;
770: COMMIT;
771:
772: msd_dem_common_utilities.log_debug (x_del_stmt);
773: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
774: msd_dem_common_utilities.log_debug (' ');
775: END IF;
776:

Line 773: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );

769: x_count := SQL%ROWCOUNT;
770: COMMIT;
771:
772: msd_dem_common_utilities.log_debug (x_del_stmt);
773: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
774: msd_dem_common_utilities.log_debug (' ');
775: END IF;
776:
777: END IF;

Line 774: msd_dem_common_utilities.log_debug (' ');

770: COMMIT;
771:
772: msd_dem_common_utilities.log_debug (x_del_stmt);
773: msd_dem_common_utilities.log_debug ('Rows Deleted - ' || x_count );
774: msd_dem_common_utilities.log_debug (' ');
775: END IF;
776:
777: END IF;
778:

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

775: END IF;
776:
777: END IF;
778:
779: msd_dem_common_utilities.log_debug ('Exiting: msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
780: msd_dem_common_utilities.log_debug (' ');
781:
782:
783: EXCEPTION

Line 780: msd_dem_common_utilities.log_debug (' ');

776:
777: END IF;
778:
779: msd_dem_common_utilities.log_debug ('Exiting: msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
780: msd_dem_common_utilities.log_debug (' ');
781:
782:
783: EXCEPTION
784: WHEN others THEN

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

783: EXCEPTION
784: WHEN others THEN
785: errbuf := substr(SQLERRM,1,150);
786: retcode := -1 ;
787: msd_dem_common_utilities.log_message ('Exception: msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
788: msd_dem_common_utilities.log_message (errbuf);
789: msd_dem_common_utilities.log_message (' ');
790: ROLLBACK;
791:

Line 788: msd_dem_common_utilities.log_message (errbuf);

784: WHEN others THEN
785: errbuf := substr(SQLERRM,1,150);
786: retcode := -1 ;
787: msd_dem_common_utilities.log_message ('Exception: msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
788: msd_dem_common_utilities.log_message (errbuf);
789: msd_dem_common_utilities.log_message (' ');
790: ROLLBACK;
791:
792: END DELETE_PLAN;

Line 789: msd_dem_common_utilities.log_message (' ');

785: errbuf := substr(SQLERRM,1,150);
786: retcode := -1 ;
787: msd_dem_common_utilities.log_message ('Exception: msd_ws_dem_rename_forecast.delete_plan - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
788: msd_dem_common_utilities.log_message (errbuf);
789: msd_dem_common_utilities.log_message (' ');
790: ROLLBACK;
791:
792: END DELETE_PLAN;
793: