18: l_req_id number;
19:
20: begin
21:
22: l_success := fnd_submit.set_request_set('MSD','MSDDEMLFD');
23:
24: if not l_success then
25: raise l_submit_failed;
26: end if;
24: if not l_success then
25: raise l_submit_failed;
26: end if;
27:
28: l_success := fnd_submit.submit_program('MSD','MSDDEMLD','STAGE10', instance, 1440, file_seperator, control_path, data_path, 3, null,
29: null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
30: null, null, null, null, null, null, null, null, null, null, file_name, auto_run);
31: if not l_success then
32: raise l_submit_failed;
31: if not l_success then
32: raise l_submit_failed;
33: end if;
34:
35: l_success := fnd_submit.submit_program('MSD','MSDDEMSDP','STAGE20', instance);
36: if not l_success then
37: raise l_submit_failed;
38: end if;
39:
36: if not l_success then
37: raise l_submit_failed;
38: end if;
39:
40: l_success := fnd_submit.submit_program('MSD','MSDDEMCLT','STAGE30', instance, 1);
41: if not l_success then
42: raise l_submit_failed;
43: end if;
44:
41: if not l_success then
42: raise l_submit_failed;
43: end if;
44:
45: l_success := fnd_submit.submit_program('MSD','MSDDEMCLT','STAGE30', instance, 2);
46: if not l_success then
47: raise l_submit_failed;
48: end if;
49:
46: if not l_success then
47: raise l_submit_failed;
48: end if;
49:
50: l_success := fnd_submit.submit_program('MSD','MSDDEMARD','STAGE40', auto_run);
51: if not l_success then
52: raise l_submit_failed;
53: end if;
54:
51: if not l_success then
52: raise l_submit_failed;
53: end if;
54:
55: l_req_id := fnd_submit.submit_set(NULL,FALSE);
56:
57: commit;
58:
59: retcode := 0;