[Home] [Help]
181: -- release planned order, work order,purchasing requision,schedule
182: -- MSC_Rel_Plan_PUB.msc_release_plan_sc needs to be updated to report
183: -- cp request id and progress
184:
185: -- insert into msc_rp_release_status table for pcnt
186: insert into msc_rp_release_status (
187: release_session_id,
188: completion_pcnt,
189: status,
182: -- MSC_Rel_Plan_PUB.msc_release_plan_sc needs to be updated to report
183: -- cp request id and progress
184:
185: -- insert into msc_rp_release_status table for pcnt
186: insert into msc_rp_release_status (
187: release_session_id,
188: completion_pcnt,
189: status,
190: last_update_date,
299: --- insert result into table so that ws can report progress
300: ------------------------------------------------------------
301: -- print_debug('Updating status after releasing planned orders, etc ...' );
302:
303: update msc_rp_release_status set completion_pcnt=40
304: where release_session_id=psid;
305:
306:
307: if v_other_count > 0 then
401:
402:
403:
404: -- print_debug('Updating release status after releasing purchasing orders ...');
405: update msc_rp_release_status set completion_pcnt=60
406: where release_session_id=psid;
407:
408: if v_res_po_count > 0 then
409: FOR i in 1..v_res_po_count LOOP
454: END LOOP;
455: end if;
456:
457:
458: update msc_rp_release_status set completion_pcnt=100,status=2
459: where release_session_id=psid;
460:
461: commit;
462:
462:
463: -- print_debug('All done ...');
464: EXCEPTION
465: WHEN OTHERS THEN
466: update msc_rp_release_status set completion_pcnt=100,status=4
467: where release_session_id=psid;
468: commit;
469:
470: fnd_message.set_name('MSC', 'MSC_REL_SETUP_ERR');