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.MSC_LAUNCH_PLAN_PK dependencies on MSC_UTIL

Line 28: MSC_UTIL.msc_Debug('Launch Refresh MV MSCREFSN failed');

24:
25: COMMIT;
26:
27: IF lvs_request_id=0 THEN
28: MSC_UTIL.msc_Debug('Launch Refresh MV MSCREFSN failed');
29: RETURN FALSE;
30: ELSE
31: MSC_UTIL.msc_Debug('Launched Program MSCREFSN Request:'|| to_char(lvs_request_id));
32: END IF;

Line 31: MSC_UTIL.msc_Debug('Launched Program MSCREFSN Request:'|| to_char(lvs_request_id));

27: IF lvs_request_id=0 THEN
28: MSC_UTIL.msc_Debug('Launch Refresh MV MSCREFSN failed');
29: RETURN FALSE;
30: ELSE
31: MSC_UTIL.msc_Debug('Launched Program MSCREFSN Request:'|| to_char(lvs_request_id));
32: END IF;
33:
34: LOOP
35: /* come out of function only when the MSCPDCP is complete - reqd for Collections incompatibility */

Line 48: MSC_UTIL.msc_Debug('Failure in verifying request:'|| to_char(lvs_request_id));

44: l_dev_status,
45: l_message);
46:
47: IF (l_call_status=FALSE) THEN
48: MSC_UTIL.msc_Debug('Failure in verifying request:'|| to_char(lvs_request_id));
49: RETURN FALSE;
50: END IF;
51:
52: EXIT WHEN l_dev_phase = 'COMPLETE';

Line 60: MSC_UTIL.msc_Debug('Failure in verifying request:'|| to_char(lvs_request_id));

56: RETURN TRUE;
57:
58: EXCEPTION
59: WHEN OTHERS THEN
60: MSC_UTIL.msc_Debug('Failure in verifying request:'|| to_char(lvs_request_id));
61: RETURN FALSE;
62: END LAUNCH_REFRESH_MV;
63: -- Modification for bug 1863615 - removed the plan horizon date parameter
64: -- ************************* msc_launch_plan ******************************* --

Line 200: msc_util.msc_debug('Plan Id changed.');

196: v_new_plan_id := arg_plan_id;
197: CLOSE check_plan_id;
198: ELSE
199: CLOSE check_plan_id;
200: msc_util.msc_debug('Plan Id changed.');
201: OPEN get_plan_id(arg_designator);
202: FETCH get_plan_id INTO v_new_plan_id;
203: CLOSE get_plan_id;
204: msc_util.msc_debug('New Plan Id is '||v_new_plan_id);

Line 204: msc_util.msc_debug('New Plan Id is '||v_new_plan_id);

200: msc_util.msc_debug('Plan Id changed.');
201: OPEN get_plan_id(arg_designator);
202: FETCH get_plan_id INTO v_new_plan_id;
203: CLOSE get_plan_id;
204: msc_util.msc_debug('New Plan Id is '||v_new_plan_id);
205: END IF;
206:
207: --Additional code for release reschedules bug#2881012
208: update msc_plans

Line 331: -- MSC_UTIL.msc_Debug('phase '||L_phase||' '||L_message);

327: else -- v_rec_c1.plan_completion_date is null then
328: -- ------------------------------------
329: -- if plan run is not complete then...
330: -- ------------------------------------
331: -- MSC_UTIL.msc_Debug('phase '||L_phase||' '||L_message);
332: IF upper(l_dev_phase) <>'COMPLETE' THEN
333: IF v_rec_c1.summary_flag = 2 THEN
334: v_lookup_name:= 'MSC_POST_PROCESS_RUNNING';
335: RAISE v_ex_error_plan_launch;

Line 379: MSC_UTIL.msc_Debug('deleting temp_plan '||var_temp_plan_id);

375: -- Var_Temp_plan_id <>-1, Temp. plan exists.
376: -- Delete the temp. plan because, for any plan,
377: -- only one temp. plan can exist at any instance.
378: -- ----------------------------------------------
379: MSC_UTIL.msc_Debug('deleting temp_plan '||var_temp_plan_id);
380: msc_copy_plan_options.delete_temp_plan(errbuf, retcode, var_temp_desig_id, TRUE);
381: if retcode >0 then
382: raise v_ex_error_plan_launch;
383: end if;

Line 422: MSC_UTIL.msc_Debug('Copying plan options...' );

418: set purge_current_plan = decode(p_24x7atp,3,2,1)
419: where designator_id = var_desig_id;
420:
421: msc_copy_plan_options.init_plan_id('N',NULL,NULL);
422: MSC_UTIL.msc_Debug('Copying plan options...' );
423: msc_copy_plan_options.copy_plan_options
424: ( v_plan_id , -- > p_source_plan_id
425: nvl(substr(to_char(v_plan_id),-10),v_plan_id), -- > p_dest_plan_name
426: var_desc, -- > p_dest_plan_desc

Line 448: MSC_UTIL.msc_Debug('copying firm orders...' );

444: end if;
445: msc_copy_plan_options.init_plan_id('N',NULL,NULL);
446:
447: if var_overwrite_all<> 1 then
448: MSC_UTIL.msc_Debug('copying firm orders...' );
449: msc_copy_plan_options.copy_firm_orders(errbuf, retcode, v_plan_id, var_temp_plan_id);
450: if nvl(retcode,0) > 0 then
451: raise v_ex_error_plan_launch;
452: end if;

Line 461: MSC_UTIL.msc_Debug('About to Launch Plan');

457:
458: /*----------------------------------------+
459: | Update msc_plans with plan horizon date |
460: +----------------------------------------*/
461: MSC_UTIL.msc_Debug('******About to Launch Plan******');
462: -- Modification for bug 1863615
463: -- IF arg_plan_horizon IS NULL THEN
464: -- months := fnd_profile.value('MRP_CUTOFF_DATE_OFFSET');
465:

Line 663: MSC_UTIL.msc_Debug('Launching Snapshot for 32 bit');

659: l_platform_type := 0;
660: END IF;
661:
662: IF l_platform_type = 0 THEN
663: MSC_UTIL.msc_Debug('Launching Snapshot for 32 bit');
664: var_snapshot_req_id := NULL;
665: IF (arg_netchange_mode = SYS_NO) THEN
666: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
667: 'MSC', -- application

Line 698: MSC_UTIL.msc_Debug('Launching Snapshot for 64 bit Sun');

694: );
695: END IF;
696:
697: ELSIF l_platform_type = 1 THEN
698: MSC_UTIL.msc_Debug('Launching Snapshot for 64 bit Sun');
699: var_snapshot_req_id := NULL;
700: IF (arg_netchange_mode = SYS_NO) THEN
701: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
702: 'MSC', -- application

Line 732: MSC_UTIL.msc_Debug('Launching Snapshot for 64 bit HP');

728: 1 -- p_snap_static_entities
729: );
730: END IF;
731: ELSIF l_platform_type = 2 THEN
732: MSC_UTIL.msc_Debug('Launching Snapshot for 64 bit HP');
733: var_snapshot_req_id := NULL;
734: IF (arg_netchange_mode = SYS_NO) THEN
735: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
736: 'MSC', -- application

Line 766: MSC_UTIL.msc_Debug('Launching Snapshot for 64 bit AIX');

762: 1 -- p_snap_static_entities
763: );
764: END IF;
765: ELSIF l_platform_type = 3 THEN
766: MSC_UTIL.msc_Debug('Launching Snapshot for 64 bit AIX');
767: var_snapshot_req_id := NULL;
768: IF (arg_netchange_mode = SYS_NO) THEN
769: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
770: 'MSC', -- application

Line 801: MSC_UTIL.msc_Debug('Launching Snapshot for Linux 64bit');

797: );
798: END IF;
799:
800: ELSIF l_platform_type = 4 THEN
801: MSC_UTIL.msc_Debug('Launching Snapshot for Linux 64bit');
802: var_snapshot_req_id := NULL;
803: IF (arg_netchange_mode = SYS_NO) THEN
804: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
805: 'MSC', -- application

Line 835: MSC_UTIL.msc_Debug('Launching Snapshot for HP Itanium 64bit');

831: );
832: END IF;
833:
834: ELSIF l_platform_type = 5 THEN
835: MSC_UTIL.msc_Debug('Launching Snapshot for HP Itanium 64bit');
836: var_snapshot_req_id := NULL;
837: IF (arg_netchange_mode = SYS_NO) THEN
838: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
839: 'MSC', -- application

Line 881: MSC_UTIL.msc_Debug('Launched Snapshot:'||

877: WHERE plan_id = v_plan_id;
878:
879: COMMIT;
880:
881: MSC_UTIL.msc_Debug('Launched Snapshot:'||
882: to_char(var_snapshot_req_id));
883:
884: END IF; /* if arg_launch_snapshot = SYS_YES */
885:

Line 1037: MSC_UTIL.msc_Debug('Launched Planner:'||

1033: SET request_id = var_snapshot_req_id
1034: WHERE plan_id = v_plan_id;
1035:
1036: COMMIT;
1037: MSC_UTIL.msc_Debug('Launched Planner:'||
1038: to_char(var_planner_req_id));
1039: END IF;
1040:
1041: begin

Line 1058: MSC_UTIL.msc_Debug('phub archive_flag :'|| to_char(p_archive_flag));

1054: null;
1055: end;
1056:
1057: --pabram..phub
1058: MSC_UTIL.msc_Debug('phub archive_flag :'|| to_char(p_archive_flag));
1059: update msc_plans
1060: set archive_flag = p_archive_flag
1061: where plan_id = v_plan_id;
1062: commit;

Line 1064: MSC_UTIL.msc_Debug('Exiting with Success');

1060: set archive_flag = p_archive_flag
1061: where plan_id = v_plan_id;
1062: commit;
1063: --pabram..phub ends
1064: MSC_UTIL.msc_Debug('Exiting with Success');
1065: retcode := 0;
1066: errbuf := NULL;
1067: return;
1068: EXCEPTION

Line 1513: MSC_UTIL.msc_Debug('Updating preferences...');

1509: l_Counter NUMBER;
1510: l_max_tries CONSTANT Number := 100000;
1511: BEGIN
1512: savepoint BF_UPD_PREF;
1513: MSC_UTIL.msc_Debug('Updating preferences...');
1514: -- update w/b preferences
1515: l_Counter := 0;
1516: LOOP
1517: BEGIN

Line 1535: MSC_UTIL.msc_Debug('Unable to lock preference rows.');

1531: IF c_pref%ISOPEN THEN
1532: CLOSE c_pref;
1533: END IF;
1534: IF l_Counter > l_max_tries THEN
1535: MSC_UTIL.msc_Debug('Unable to lock preference rows.');
1536: --RAISE;
1537: rollback to BF_UPD_PREF;
1538: EXIT;
1539: END IF;

Line 1541: MSC_UTIL.msc_Debug('Unable to lock preference rows: ('||l_Counter||') Tries...');

1537: rollback to BF_UPD_PREF;
1538: EXIT;
1539: END IF;
1540: IF TRUNC(l_Counter/100)*100 = l_Counter THEN
1541: MSC_UTIL.msc_Debug('Unable to lock preference rows: ('||l_Counter||') Tries...');
1542: END IF;
1543: END;
1544: END LOOP;
1545:

Line 1547: MSC_UTIL.msc_Debug('Updating schedules...');

1543: END;
1544: END LOOP;
1545:
1546: savepoint BF_UPD_SCHD;
1547: MSC_UTIL.msc_Debug('Updating schedules...');
1548: -- update supply/demand schedules
1549: l_Counter := 0;
1550: l_rowlist.delete;
1551: LOOP

Line 1573: MSC_UTIL.msc_Debug('Unable to lock schedules rows.');

1569: IF c_pref%ISOPEN THEN
1570: CLOSE c_pref;
1571: END IF;
1572: IF l_Counter > l_max_tries THEN
1573: MSC_UTIL.msc_Debug('Unable to lock schedules rows.');
1574: --RAISE;
1575: rollback to BF_UPD_SCHD;
1576: EXIT;
1577: END IF;

Line 1579: MSC_UTIL.msc_Debug('Unable to lock schedules rows: ('||l_Counter||') Tries...');

1575: rollback to BF_UPD_SCHD;
1576: EXIT;
1577: END IF;
1578: IF TRUNC(l_Counter/100)*100 = l_Counter THEN
1579: MSC_UTIL.msc_Debug('Unable to lock schedules rows: ('||l_Counter||') Tries...');
1580: END IF;
1581: END;
1582: END LOOP;
1583:

Line 1586: MSC_UTIL.msc_Debug('Error updating preferences and schedules.');

1582: END LOOP;
1583:
1584: EXCEPTION
1585: WHEN OTHERS THEN
1586: MSC_UTIL.msc_Debug('Error updating preferences and schedules.');
1587: RAISE;
1588: END;
1589: -- Bug#7449943
1590: Update msc_plans_other

Line 1601: MSC_UTIL.msc_Debug('Purging Original plan...' );

1597: -- To delete the Original Plan,
1598: -- ---------------------------------
1599: -- Modified (forward port) for the bug # 3021850
1600: if nvl(v_org_desig_cur.purge_current_plan,1) = 1 THEN
1601: MSC_UTIL.msc_Debug('Purging Original plan...' );
1602: MSC_COPY_PLAN_OPTIONS.delete_temp_plan
1603: (errbuf, retcode, v_org_desig_cur.designator_id,FALSE);
1604:
1605: if nvl(retcode,0) >0 then

Line 1676: MSC_UTIL.msc_Debug('Error while updating msc_plans.planning_mode. Plan_id = '||to_char(arg_plan_id));

1672:
1673: COMMIT;
1674:
1675: EXCEPTION WHEN OTHERS THEN
1676: MSC_UTIL.msc_Debug('Error while updating msc_plans.planning_mode. Plan_id = '||to_char(arg_plan_id));
1677: MSC_UTIL.msc_Debug(SQLERRM);
1678: END;
1679:
1680: v_plan_id := arg_plan_id;

Line 1677: MSC_UTIL.msc_Debug(SQLERRM);

1673: COMMIT;
1674:
1675: EXCEPTION WHEN OTHERS THEN
1676: MSC_UTIL.msc_Debug('Error while updating msc_plans.planning_mode. Plan_id = '||to_char(arg_plan_id));
1677: MSC_UTIL.msc_Debug(SQLERRM);
1678: END;
1679:
1680: v_plan_id := arg_plan_id;
1681: open C1(v_plan_id);

Line 1771: MSC_UTIL.msc_Debug('Launched Snapshot:'||to_char(var_snapshot_req_id));

1767: , 1 -- Netchange_mode
1768: , 1 -- p_snap_static_entities
1769: );
1770: COMMIT;
1771: MSC_UTIL.msc_Debug('Launched Snapshot:'||to_char(var_snapshot_req_id));
1772: END IF; /* if arg_launch_snapshot = SYS_YES */
1773:
1774: IF (((arg_launch_scheduler = SYS_YES) AND (arg_launch_snapshot = SYS_NO)) or
1775: (arg_launch_scheduler = DS_OLS_ONLY)

Line 1804: MSC_UTIL.msc_Debug('Launched Program:'||l_executable_name);

1800: errbuf := 'Invalid Platform Type: '||to_char(l_platform_type);
1801: return;
1802: END CASE;
1803:
1804: MSC_UTIL.msc_Debug('Launched Program:'||l_executable_name);
1805:
1806: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST('MSO' -- application
1807: , l_executable_name
1808: , NULL -- description

Line 1827: MSC_UTIL.msc_Debug('Launched Program:'||l_executable_name);

1823: errbuf := 'Invalid Platform Type: '||to_char(l_platform_type);
1824: return;
1825: END CASE;
1826:
1827: MSC_UTIL.msc_Debug('Launched Program:'||l_executable_name);
1828:
1829: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST('MSO' -- application
1830: , l_executable_name
1831: , NULL -- description

Line 1883: MSC_UTIL.msc_Debug('Launched Planner:'||to_char(var_planner_req_id));

1879: END IF;
1880: COMMIT;
1881: END IF;
1882:
1883: MSC_UTIL.msc_Debug('Launched Planner:'||to_char(var_planner_req_id));
1884: END IF;
1885:
1886: MSC_UTIL.msc_Debug('Exiting with Success');
1887: retcode := 0;

Line 1886: MSC_UTIL.msc_Debug('Exiting with Success');

1882:
1883: MSC_UTIL.msc_Debug('Launched Planner:'||to_char(var_planner_req_id));
1884: END IF;
1885:
1886: MSC_UTIL.msc_Debug('Exiting with Success');
1887: retcode := 0;
1888: errbuf := NULL;
1889:
1890: EXCEPTION