APPS.MST_LAUNCH_PLAN_PKG dependencies on MSC_UTIL

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

152: SET request_id = var_snapshot_req_id
153: WHERE plan_id = v_plan_id;
154:
155: COMMIT;
156: MSC_UTIL.msc_Debug('Launched Snapshot:'||
157: to_char(var_snapshot_req_id));
158:
159: retcode := 0;
160: errbuf := NULL;

Line 243: MSC_UTIL.MSC_LOG('Error Setting Up Source Objects');

239:
240: RETCODE := G_SUCCESS;
241: EXCEPTION
242: WHEN SOURCE_SETUP_ERROR THEN
243: MSC_UTIL.MSC_LOG('Error Setting Up Source Objects');
244: RETCODE:= G_ERROR;
245:
246: ERRBUF:= SQLERRM;
247:

Line 277: MSC_UTIL.MSC_LOG( SQLERRM);

273: EXCEPTION
274:
275: WHEN OTHERS THEN
276:
277: MSC_UTIL.MSC_LOG( SQLERRM);
278: return FALSE;
279: END FOUND_EXIST_OBJECTS;
280:
281:

Line 304: MSC_UTIL.MSC_LOG( 'Request : ' ||

300: NULL,
301: NULL,
302: FALSE); -- sub request
303: commit;
304: MSC_UTIL.MSC_LOG( 'Request : ' ||
305: lv_request_id_wsh||' : WSH SNAPSHOT TABLE Creation request submitted');
306:
307: wait_for_request(lv_request_id_wsh, 10, lv_out);
308:

Line 326: MSC_UTIL.MSC_LOG( 'Request : '||lv_request_id_objs||' :Creates Triggesr/Views Submitted');

322: NULL,
323: NULL,
324: FALSE); -- sub request
325: commit;
326: MSC_UTIL.MSC_LOG( 'Request : '||lv_request_id_objs||' :Creates Triggesr/Views Submitted');
327:
328: end if;
329:
330: IF lv_success THEN

Line 332: MSC_UTIL.MSC_LOG('Updating Profile Option MSC_SOURCE_SETUP to No ');

328: end if;
329:
330: IF lv_success THEN
331: begin
332: MSC_UTIL.MSC_LOG('Updating Profile Option MSC_SOURCE_SETUP to No ');
333:
334: UPDATE FND_PROFILE_OPTION_VALUES
335: SET PROFILE_OPTION_VALUE = '2'
336: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID

Line 339: MSC_UTIL.MSC_LOG('Profile Option MSC_SOURCE_SETUP has been updated No ');

335: SET PROFILE_OPTION_VALUE = '2'
336: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
337: FROM FND_PROFILE_OPTIONS
338: WHERE PROFILE_OPTION_NAME = 'MST_SOURCE_SETUP');
339: MSC_UTIL.MSC_LOG('Profile Option MSC_SOURCE_SETUP has been updated No ');
340:
341: COMMIT;
342: return TRUE;
343:

Line 346: MSC_UTIL.MSC_LOG ('Error Updating Profile MSC_SOURCE_SETUP: '||SQLERRM);

342: return TRUE;
343:
344: EXCEPTION
345: WHEN OTHERS THEN
346: MSC_UTIL.MSC_LOG ('Error Updating Profile MSC_SOURCE_SETUP: '||SQLERRM);
347: end;
348: ELSE
349: MSC_UTIL.MSC_LOG ('Source Setup Objects Creation Requests did not complete Successfully');
350: MSC_UTIL.MSC_LOG(lv_request_id_wsh);

Line 349: MSC_UTIL.MSC_LOG ('Source Setup Objects Creation Requests did not complete Successfully');

345: WHEN OTHERS THEN
346: MSC_UTIL.MSC_LOG ('Error Updating Profile MSC_SOURCE_SETUP: '||SQLERRM);
347: end;
348: ELSE
349: MSC_UTIL.MSC_LOG ('Source Setup Objects Creation Requests did not complete Successfully');
350: MSC_UTIL.MSC_LOG(lv_request_id_wsh);
351: MSC_UTIL.MSC_LOG(lv_request_id_objs);
352: return false;
353: END IF;

Line 350: MSC_UTIL.MSC_LOG(lv_request_id_wsh);

346: MSC_UTIL.MSC_LOG ('Error Updating Profile MSC_SOURCE_SETUP: '||SQLERRM);
347: end;
348: ELSE
349: MSC_UTIL.MSC_LOG ('Source Setup Objects Creation Requests did not complete Successfully');
350: MSC_UTIL.MSC_LOG(lv_request_id_wsh);
351: MSC_UTIL.MSC_LOG(lv_request_id_objs);
352: return false;
353: END IF;
354:

Line 351: MSC_UTIL.MSC_LOG(lv_request_id_objs);

347: end;
348: ELSE
349: MSC_UTIL.MSC_LOG ('Source Setup Objects Creation Requests did not complete Successfully');
350: MSC_UTIL.MSC_LOG(lv_request_id_wsh);
351: MSC_UTIL.MSC_LOG(lv_request_id_objs);
352: return false;
353: END IF;
354:
355: return true;

Line 361: MSC_UTIL.MSC_LOG( SQLERRM);

357: EXCEPTION
358:
359: WHEN OTHERS THEN
360:
361: MSC_UTIL.MSC_LOG( SQLERRM);
362: return FALSE;
363: END SETUP_SOURCE_OBJECTS;
364:
365: