APPS.MSD_SOP dependencies on MSD_COMMON_UTILITIES

Line 270: msd_common_utilities.dbms_aw_interp_silent(script);

266:
267: script := script || 'call odpwf.setMaster(''' || aw_name || ''');' ;
268: begin
269:
270: msd_common_utilities.dbms_aw_interp_silent(script);
271:
272: exception
273: when others then
274: errbuf:=substr(sqlerrm, 1, 255);

Line 378: msd_common_utilities.dp_log(planID, 'Launching supply plans','BEGIN');

374: Itemtype => ItemType,
375: Itemkey => ItemKey,
376: aname => 'ODPPLAN');
377:
378: msd_common_utilities.dp_log(planID, 'Launching supply plans','BEGIN');
379:
380: -- populate denorm tables
381: msd_common_utilities.dp_log(planID, 'Populating denormalized tables');
382: MSD_ASCP_FLOW.populate_denorm_tables(planID);

Line 381: msd_common_utilities.dp_log(planID, 'Populating denormalized tables');

377:
378: msd_common_utilities.dp_log(planID, 'Launching supply plans','BEGIN');
379:
380: -- populate denorm tables
381: msd_common_utilities.dp_log(planID, 'Populating denormalized tables');
382: MSD_ASCP_FLOW.populate_denorm_tables(planID);
383:
384: v_cur := 0;
385: FOR plan_rec in c_plans(planID) LOOP

Line 394: msd_common_utilities.dp_log(planID, plan_rec.supply_plan_name||' (request id '||v_request||')');

390: 3,1,2,sysdate);
391: commit;
392: requests(v_cur) := v_request;
393: plans(v_cur) := plan_rec.supply_plan_id;
394: msd_common_utilities.dp_log(planID, plan_rec.supply_plan_name||' (request id '||v_request||')');
395: END LOOP;
396:
397: --wait until all the requests are done
398: FOR i in 1..v_cur LOOP

Line 399: msd_common_utilities.dp_log(planID, 'Waiting for request id '||v_request);

395: END LOOP;
396:
397: --wait until all the requests are done
398: FOR i in 1..v_cur LOOP
399: msd_common_utilities.dp_log(planID, 'Waiting for request id '||v_request);
400:
401: -- wait for this plan run to complete
402: MSC_LAUNCH_PLAN_PK.MSC_CHECK_PLAN_COMPLETION(requests(i),plans(i),v_status);
403:

Line 404: msd_common_utilities.dp_log(planID, 'Request id '||v_request||' completed with status '||v_status);

400:
401: -- wait for this plan run to complete
402: MSC_LAUNCH_PLAN_PK.MSC_CHECK_PLAN_COMPLETION(requests(i),plans(i),v_status);
403:
404: msd_common_utilities.dp_log(planID, 'Request id '||v_request||' completed with status '||v_status);
405: end loop;
406:
407: msd_common_utilities.dp_log(planID, 'Done launching supply plans.','END');
408:

Line 407: msd_common_utilities.dp_log(planID, 'Done launching supply plans.','END');

403:
404: msd_common_utilities.dp_log(planID, 'Request id '||v_request||' completed with status '||v_status);
405: end loop;
406:
407: msd_common_utilities.dp_log(planID, 'Done launching supply plans.','END');
408:
409: resultout := 'COMPLETE:Y';
410:
411: return;