APPS.MSC_WS_COLLECTIONS dependencies on FND_SUBMIT

Line 171: result := fnd_submit.set_request_set('MSC','MSCPDX');

167:
168:
169: -- initiating request set
170: error_tracking_num := 140;
171: result := fnd_submit.set_request_set('MSC','MSCPDX');
172: IF(result = false) THEN
173: RAISE submit_failed ;
174: END IF ;
175:

Line 183: result := fnd_submit.submit_program('MSC','MSCPDP','MSCPDP',InstanceId, passedCollectionGroup,

179: -- passedCollectionGroup := '-999';
180: --end if;
181: -- register Planning Data Pull
182: error_tracking_num := 150;
183: result := fnd_submit.submit_program('MSC','MSCPDP','MSCPDP',InstanceId, passedCollectionGroup,
184: TotalWorkerNum,Timeout,'US', -- language
185: MSC_WS_COMMON.Bool_to_Number( OdsPURGEoption),
186: GetCollectionMethodAsNumber(CollectionMethod ),
187: MSC_WS_COMMON.Bool_to_Number(AnalyzeTablesEnabled),

Line 238: result := fnd_submit.submit_program('MSC','MSCPDC','MSCPDC',InstanceId,Timeout,Odstotalworkernum,

234: END IF ;
235:
236: -- register Planning ODS Load
237: error_tracking_num := 160;
238: result := fnd_submit.submit_program('MSC','MSCPDC','MSCPDC',InstanceId,Timeout,Odstotalworkernum,
239: MSC_WS_COMMON.Bool_to_Number(RecalcResAvailability),
240: MSC_WS_COMMON.Bool_to_Number(SourcingHistoryEnabled),
241: MSC_WS_COMMON.Bool_to_Number(PurgeSourcingHistory));
242:

Line 249: req_id := fnd_submit.submit_set(NULL,FALSE);

245: END IF ;
246:
247: -- submitting the request set
248: error_tracking_num := 170;
249: req_id := fnd_submit.submit_set(NULL,FALSE);
250: IF(req_id = 0) THEN
251: RAISE submit_failed ;
252: END IF ;
253:

Line 676: result := fnd_submit.set_request_set('MSD','MSDDEMRSCH');

672:
673:
674: -- initiating request set
675: error_tracking_num := 160;
676: result := fnd_submit.set_request_set('MSD','MSDDEMRSCH');
677: IF(result = false) THEN
678: RAISE submit_failed ;
679: END IF ;
680:

Line 688: result := fnd_submit.submit_program('MSD','MSDDEMCHD','MSDDEMRSCHD',

684: -- passedCollectionGroup := '-999';
685: --end if;
686: -- Stage 1 Collect Shipment and booking History
687: error_tracking_num := 170;
688: result := fnd_submit.submit_program('MSD','MSDDEMCHD','MSDDEMRSCHD',
689: InstanceId,passedCollectionGroup, CollectionMethod,hiddenParam,
690: DateRangeType, HistoryCollectionWindow,
691: to_char(DateFrom, 'YYYY/MM/DD HH24:MI:SS'), to_char(DateTo, 'YYYY/MM/DD HH24:MI:SS'),
692: MSC_WS_COMMON.Bool_to_Number(BHBookedItemsBookedDate),

Line 713: result := fnd_submit.submit_program('MSD','MSDDEMPSP','MSDDEMRSPSP',

709: END IF ;
710:
711: -- Stage 2 Push Setup Params
712: error_tracking_num := 180;
713: result := fnd_submit.submit_program('MSD','MSDDEMPSP','MSDDEMRSPSP',
714: InstanceId,passedCollectionGroup);
715:
716: IF(result = false) THEN
717: RAISE submit_failed ;

Line 723: result := fnd_submit.submit_program('MSD','MSDDEMCLT','MSDDEMRSPST',

719:
720: -- Stage 3 Populate Staging Tables
721: -- Stage 3.1 Collect Level Type
722: error_tracking_num := 190;
723: result := fnd_submit.submit_program('MSD','MSDDEMCLT','MSDDEMRSPST',
724: InstanceId, 2);
725:
726: IF(result = false) THEN
727: RAISE submit_failed ;

Line 732: result := fnd_submit.submit_program('MSD','MSDDEMCLT','MSDDEMRSPST',

728: END IF ;
729:
730: -- Stage 3.2 Collect Level Type
731: error_tracking_num := 200;
732: result := fnd_submit.submit_program('MSD','MSDDEMCLT','MSDDEMRSPST',
733: InstanceId, 1);
734:
735: IF(result = false) THEN
736: RAISE submit_failed ;

Line 741: result := fnd_submit.submit_program('MSD','MSDDEMULC','MSDDEMRSPST',

737: END IF ;
738:
739: -- Stage 3.3 Update Level Codes
740: error_tracking_num := 210;
741: result := fnd_submit.submit_program('MSD','MSDDEMULC','MSDDEMRSPST',
742: InstanceId, 'SITE', Dem_ULC_GetDestTableName(), 'DM_SITE_CODE', 'EBS_SITE_SR_PK');
743:
744: IF(result = false) THEN
745: RAISE submit_failed ;

Line 750: result := fnd_submit.submit_program('MSD','MSDDEMCTD','MSDDEMRSPST',

746: END IF ;
747:
748: -- Stage 3.4 Collect Time
749: error_tracking_num := 220;
750: result := fnd_submit.submit_program('MSD','MSDDEMCTD','MSDDEMRSPST',
751: MSC_WS_COMMON.Bool_to_Number(LaunchDownload ));
752:
753: IF(result = false) THEN
754: RAISE submit_failed ;

Line 759: result := fnd_submit.submit_program('MSD','MSDDEMARD','MSDDEMRSLH',

755: END IF ;
756:
757: -- Stage 4 Launch EP Load
758: error_tracking_num := 230;
759: result := fnd_submit.submit_program('MSD','MSDDEMARD','MSDDEMRSLH',
760: MSC_WS_COMMON.Bool_to_Number(LaunchDownload ));
761:
762: IF(result = false) THEN
763: RAISE submit_failed ;

Line 768: req_id := fnd_submit.submit_set(NULL,FALSE);

764: END IF ;
765:
766: -- submitting the request set
767: error_tracking_num := 240;
768: req_id := fnd_submit.submit_set(NULL,FALSE);
769: IF(req_id = 0) THEN
770: RAISE submit_failed ;
771: END IF ;
772: