eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_WS_COLLECTIONS dependencies on MSC_WS_COMMON

Line 101: MSC_WS_COMMON.VALIDATE_USER_RESP(L_VAL_RESULT, UserId, ResponsibilityID);

97: /* Language and Trading Partners are hidden*/
98: /* validate InstanceId, CollectionGroup, WorkOrderNum, Timeout, Odstotalworkernum, all others are yes/no flags*/
99:
100: error_tracking_num := 100;
101: MSC_WS_COMMON.VALIDATE_USER_RESP(L_VAL_RESULT, UserId, ResponsibilityID);
102: IF (L_VAL_RESULT <> 'OK') THEN
103: PROCESSID := -1;
104: STATUS := L_VAL_RESULT;
105: RETURN;

Line 185: MSC_WS_COMMON.Bool_to_Number( OdsPURGEoption),

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),
188: GetLookupCodeForAppSuppList(ApprovedSupplierList),
189: MSC_WS_COMMON.Bool_to_Number(AtpRulesEnabled),

Line 187: MSC_WS_COMMON.Bool_to_Number(AnalyzeTablesEnabled),

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),
188: GetLookupCodeForAppSuppList(ApprovedSupplierList),
189: MSC_WS_COMMON.Bool_to_Number(AtpRulesEnabled),
190: MSC_WS_COMMON.Bool_to_Number(BomEnabled),
191: MSC_WS_COMMON.Bool_to_Number(BorEnabled) ,

Line 189: MSC_WS_COMMON.Bool_to_Number(AtpRulesEnabled),

185: MSC_WS_COMMON.Bool_to_Number( OdsPURGEoption),
186: GetCollectionMethodAsNumber(CollectionMethod ),
187: MSC_WS_COMMON.Bool_to_Number(AnalyzeTablesEnabled),
188: GetLookupCodeForAppSuppList(ApprovedSupplierList),
189: MSC_WS_COMMON.Bool_to_Number(AtpRulesEnabled),
190: MSC_WS_COMMON.Bool_to_Number(BomEnabled),
191: MSC_WS_COMMON.Bool_to_Number(BorEnabled) ,
192: MSC_WS_COMMON.Bool_to_Number(CalendarEnabled),
193: MSC_WS_COMMON.Bool_to_Number(DemandClassEnabled),

Line 190: MSC_WS_COMMON.Bool_to_Number(BomEnabled),

186: GetCollectionMethodAsNumber(CollectionMethod ),
187: MSC_WS_COMMON.Bool_to_Number(AnalyzeTablesEnabled),
188: GetLookupCodeForAppSuppList(ApprovedSupplierList),
189: MSC_WS_COMMON.Bool_to_Number(AtpRulesEnabled),
190: MSC_WS_COMMON.Bool_to_Number(BomEnabled),
191: MSC_WS_COMMON.Bool_to_Number(BorEnabled) ,
192: MSC_WS_COMMON.Bool_to_Number(CalendarEnabled),
193: MSC_WS_COMMON.Bool_to_Number(DemandClassEnabled),
194: MSC_WS_COMMON.Bool_to_Number(ItemSubstEnabled) ,

Line 191: MSC_WS_COMMON.Bool_to_Number(BorEnabled) ,

187: MSC_WS_COMMON.Bool_to_Number(AnalyzeTablesEnabled),
188: GetLookupCodeForAppSuppList(ApprovedSupplierList),
189: MSC_WS_COMMON.Bool_to_Number(AtpRulesEnabled),
190: MSC_WS_COMMON.Bool_to_Number(BomEnabled),
191: MSC_WS_COMMON.Bool_to_Number(BorEnabled) ,
192: MSC_WS_COMMON.Bool_to_Number(CalendarEnabled),
193: MSC_WS_COMMON.Bool_to_Number(DemandClassEnabled),
194: MSC_WS_COMMON.Bool_to_Number(ItemSubstEnabled) ,
195: MSC_WS_COMMON.Bool_to_Number(ForecastEnabled),

Line 192: MSC_WS_COMMON.Bool_to_Number(CalendarEnabled),

188: GetLookupCodeForAppSuppList(ApprovedSupplierList),
189: MSC_WS_COMMON.Bool_to_Number(AtpRulesEnabled),
190: MSC_WS_COMMON.Bool_to_Number(BomEnabled),
191: MSC_WS_COMMON.Bool_to_Number(BorEnabled) ,
192: MSC_WS_COMMON.Bool_to_Number(CalendarEnabled),
193: MSC_WS_COMMON.Bool_to_Number(DemandClassEnabled),
194: MSC_WS_COMMON.Bool_to_Number(ItemSubstEnabled) ,
195: MSC_WS_COMMON.Bool_to_Number(ForecastEnabled),
196: MSC_WS_COMMON.Bool_to_Number(ItemEnabled),

Line 193: MSC_WS_COMMON.Bool_to_Number(DemandClassEnabled),

189: MSC_WS_COMMON.Bool_to_Number(AtpRulesEnabled),
190: MSC_WS_COMMON.Bool_to_Number(BomEnabled),
191: MSC_WS_COMMON.Bool_to_Number(BorEnabled) ,
192: MSC_WS_COMMON.Bool_to_Number(CalendarEnabled),
193: MSC_WS_COMMON.Bool_to_Number(DemandClassEnabled),
194: MSC_WS_COMMON.Bool_to_Number(ItemSubstEnabled) ,
195: MSC_WS_COMMON.Bool_to_Number(ForecastEnabled),
196: MSC_WS_COMMON.Bool_to_Number(ItemEnabled),
197: MSC_WS_COMMON.Bool_to_Number(KpiBisEnabled),

Line 194: MSC_WS_COMMON.Bool_to_Number(ItemSubstEnabled) ,

190: MSC_WS_COMMON.Bool_to_Number(BomEnabled),
191: MSC_WS_COMMON.Bool_to_Number(BorEnabled) ,
192: MSC_WS_COMMON.Bool_to_Number(CalendarEnabled),
193: MSC_WS_COMMON.Bool_to_Number(DemandClassEnabled),
194: MSC_WS_COMMON.Bool_to_Number(ItemSubstEnabled) ,
195: MSC_WS_COMMON.Bool_to_Number(ForecastEnabled),
196: MSC_WS_COMMON.Bool_to_Number(ItemEnabled),
197: MSC_WS_COMMON.Bool_to_Number(KpiBisEnabled),
198: MSC_WS_COMMON.Bool_to_Number(MdsEnabled),

Line 195: MSC_WS_COMMON.Bool_to_Number(ForecastEnabled),

191: MSC_WS_COMMON.Bool_to_Number(BorEnabled) ,
192: MSC_WS_COMMON.Bool_to_Number(CalendarEnabled),
193: MSC_WS_COMMON.Bool_to_Number(DemandClassEnabled),
194: MSC_WS_COMMON.Bool_to_Number(ItemSubstEnabled) ,
195: MSC_WS_COMMON.Bool_to_Number(ForecastEnabled),
196: MSC_WS_COMMON.Bool_to_Number(ItemEnabled),
197: MSC_WS_COMMON.Bool_to_Number(KpiBisEnabled),
198: MSC_WS_COMMON.Bool_to_Number(MdsEnabled),
199: MSC_WS_COMMON.Bool_to_Number(MpsEnabled),

Line 196: MSC_WS_COMMON.Bool_to_Number(ItemEnabled),

192: MSC_WS_COMMON.Bool_to_Number(CalendarEnabled),
193: MSC_WS_COMMON.Bool_to_Number(DemandClassEnabled),
194: MSC_WS_COMMON.Bool_to_Number(ItemSubstEnabled) ,
195: MSC_WS_COMMON.Bool_to_Number(ForecastEnabled),
196: MSC_WS_COMMON.Bool_to_Number(ItemEnabled),
197: MSC_WS_COMMON.Bool_to_Number(KpiBisEnabled),
198: MSC_WS_COMMON.Bool_to_Number(MdsEnabled),
199: MSC_WS_COMMON.Bool_to_Number(MpsEnabled),
200: MSC_WS_COMMON.Bool_to_Number(OnHandEnabled),

Line 197: MSC_WS_COMMON.Bool_to_Number(KpiBisEnabled),

193: MSC_WS_COMMON.Bool_to_Number(DemandClassEnabled),
194: MSC_WS_COMMON.Bool_to_Number(ItemSubstEnabled) ,
195: MSC_WS_COMMON.Bool_to_Number(ForecastEnabled),
196: MSC_WS_COMMON.Bool_to_Number(ItemEnabled),
197: MSC_WS_COMMON.Bool_to_Number(KpiBisEnabled),
198: MSC_WS_COMMON.Bool_to_Number(MdsEnabled),
199: MSC_WS_COMMON.Bool_to_Number(MpsEnabled),
200: MSC_WS_COMMON.Bool_to_Number(OnHandEnabled),
201: MSC_WS_COMMON.Bool_to_Number(ParameterEnabled),

Line 198: MSC_WS_COMMON.Bool_to_Number(MdsEnabled),

194: MSC_WS_COMMON.Bool_to_Number(ItemSubstEnabled) ,
195: MSC_WS_COMMON.Bool_to_Number(ForecastEnabled),
196: MSC_WS_COMMON.Bool_to_Number(ItemEnabled),
197: MSC_WS_COMMON.Bool_to_Number(KpiBisEnabled),
198: MSC_WS_COMMON.Bool_to_Number(MdsEnabled),
199: MSC_WS_COMMON.Bool_to_Number(MpsEnabled),
200: MSC_WS_COMMON.Bool_to_Number(OnHandEnabled),
201: MSC_WS_COMMON.Bool_to_Number(ParameterEnabled),
202: MSC_WS_COMMON.Bool_to_Number(PlannerEnabled),

Line 199: MSC_WS_COMMON.Bool_to_Number(MpsEnabled),

195: MSC_WS_COMMON.Bool_to_Number(ForecastEnabled),
196: MSC_WS_COMMON.Bool_to_Number(ItemEnabled),
197: MSC_WS_COMMON.Bool_to_Number(KpiBisEnabled),
198: MSC_WS_COMMON.Bool_to_Number(MdsEnabled),
199: MSC_WS_COMMON.Bool_to_Number(MpsEnabled),
200: MSC_WS_COMMON.Bool_to_Number(OnHandEnabled),
201: MSC_WS_COMMON.Bool_to_Number(ParameterEnabled),
202: MSC_WS_COMMON.Bool_to_Number(PlannerEnabled),
203: MSC_WS_COMMON.Bool_to_Number(PoReceiptsEnabled),

Line 200: MSC_WS_COMMON.Bool_to_Number(OnHandEnabled),

196: MSC_WS_COMMON.Bool_to_Number(ItemEnabled),
197: MSC_WS_COMMON.Bool_to_Number(KpiBisEnabled),
198: MSC_WS_COMMON.Bool_to_Number(MdsEnabled),
199: MSC_WS_COMMON.Bool_to_Number(MpsEnabled),
200: MSC_WS_COMMON.Bool_to_Number(OnHandEnabled),
201: MSC_WS_COMMON.Bool_to_Number(ParameterEnabled),
202: MSC_WS_COMMON.Bool_to_Number(PlannerEnabled),
203: MSC_WS_COMMON.Bool_to_Number(PoReceiptsEnabled),
204: MSC_WS_COMMON.Bool_to_Number(ProjectEnabled),

Line 201: MSC_WS_COMMON.Bool_to_Number(ParameterEnabled),

197: MSC_WS_COMMON.Bool_to_Number(KpiBisEnabled),
198: MSC_WS_COMMON.Bool_to_Number(MdsEnabled),
199: MSC_WS_COMMON.Bool_to_Number(MpsEnabled),
200: MSC_WS_COMMON.Bool_to_Number(OnHandEnabled),
201: MSC_WS_COMMON.Bool_to_Number(ParameterEnabled),
202: MSC_WS_COMMON.Bool_to_Number(PlannerEnabled),
203: MSC_WS_COMMON.Bool_to_Number(PoReceiptsEnabled),
204: MSC_WS_COMMON.Bool_to_Number(ProjectEnabled),
205: MSC_WS_COMMON.Bool_to_Number(PurReqPoEnabled),

Line 202: MSC_WS_COMMON.Bool_to_Number(PlannerEnabled),

198: MSC_WS_COMMON.Bool_to_Number(MdsEnabled),
199: MSC_WS_COMMON.Bool_to_Number(MpsEnabled),
200: MSC_WS_COMMON.Bool_to_Number(OnHandEnabled),
201: MSC_WS_COMMON.Bool_to_Number(ParameterEnabled),
202: MSC_WS_COMMON.Bool_to_Number(PlannerEnabled),
203: MSC_WS_COMMON.Bool_to_Number(PoReceiptsEnabled),
204: MSC_WS_COMMON.Bool_to_Number(ProjectEnabled),
205: MSC_WS_COMMON.Bool_to_Number(PurReqPoEnabled),
206: MSC_WS_COMMON.Bool_to_Number(ReservesHardEnabled),

Line 203: MSC_WS_COMMON.Bool_to_Number(PoReceiptsEnabled),

199: MSC_WS_COMMON.Bool_to_Number(MpsEnabled),
200: MSC_WS_COMMON.Bool_to_Number(OnHandEnabled),
201: MSC_WS_COMMON.Bool_to_Number(ParameterEnabled),
202: MSC_WS_COMMON.Bool_to_Number(PlannerEnabled),
203: MSC_WS_COMMON.Bool_to_Number(PoReceiptsEnabled),
204: MSC_WS_COMMON.Bool_to_Number(ProjectEnabled),
205: MSC_WS_COMMON.Bool_to_Number(PurReqPoEnabled),
206: MSC_WS_COMMON.Bool_to_Number(ReservesHardEnabled),
207: GetResAvail(ResourceAvailability) ,

Line 204: MSC_WS_COMMON.Bool_to_Number(ProjectEnabled),

200: MSC_WS_COMMON.Bool_to_Number(OnHandEnabled),
201: MSC_WS_COMMON.Bool_to_Number(ParameterEnabled),
202: MSC_WS_COMMON.Bool_to_Number(PlannerEnabled),
203: MSC_WS_COMMON.Bool_to_Number(PoReceiptsEnabled),
204: MSC_WS_COMMON.Bool_to_Number(ProjectEnabled),
205: MSC_WS_COMMON.Bool_to_Number(PurReqPoEnabled),
206: MSC_WS_COMMON.Bool_to_Number(ReservesHardEnabled),
207: GetResAvail(ResourceAvailability) ,
208: MSC_WS_COMMON.Bool_to_Number(SafestockEnabled),

Line 205: MSC_WS_COMMON.Bool_to_Number(PurReqPoEnabled),

201: MSC_WS_COMMON.Bool_to_Number(ParameterEnabled),
202: MSC_WS_COMMON.Bool_to_Number(PlannerEnabled),
203: MSC_WS_COMMON.Bool_to_Number(PoReceiptsEnabled),
204: MSC_WS_COMMON.Bool_to_Number(ProjectEnabled),
205: MSC_WS_COMMON.Bool_to_Number(PurReqPoEnabled),
206: MSC_WS_COMMON.Bool_to_Number(ReservesHardEnabled),
207: GetResAvail(ResourceAvailability) ,
208: MSC_WS_COMMON.Bool_to_Number(SafestockEnabled),
209: MSC_WS_COMMON.Bool_to_Number(SalesorderRtype),

Line 206: MSC_WS_COMMON.Bool_to_Number(ReservesHardEnabled),

202: MSC_WS_COMMON.Bool_to_Number(PlannerEnabled),
203: MSC_WS_COMMON.Bool_to_Number(PoReceiptsEnabled),
204: MSC_WS_COMMON.Bool_to_Number(ProjectEnabled),
205: MSC_WS_COMMON.Bool_to_Number(PurReqPoEnabled),
206: MSC_WS_COMMON.Bool_to_Number(ReservesHardEnabled),
207: GetResAvail(ResourceAvailability) ,
208: MSC_WS_COMMON.Bool_to_Number(SafestockEnabled),
209: MSC_WS_COMMON.Bool_to_Number(SalesorderRtype),
210: MSC_WS_COMMON.Bool_to_Number(SourcingHistoryEnabled),

Line 208: MSC_WS_COMMON.Bool_to_Number(SafestockEnabled),

204: MSC_WS_COMMON.Bool_to_Number(ProjectEnabled),
205: MSC_WS_COMMON.Bool_to_Number(PurReqPoEnabled),
206: MSC_WS_COMMON.Bool_to_Number(ReservesHardEnabled),
207: GetResAvail(ResourceAvailability) ,
208: MSC_WS_COMMON.Bool_to_Number(SafestockEnabled),
209: MSC_WS_COMMON.Bool_to_Number(SalesorderRtype),
210: MSC_WS_COMMON.Bool_to_Number(SourcingHistoryEnabled),
211: MSC_WS_COMMON.Bool_to_Number(SourcingEnabled),
212: MSC_WS_COMMON.Bool_to_Number(SubInvEnabled),

Line 209: MSC_WS_COMMON.Bool_to_Number(SalesorderRtype),

205: MSC_WS_COMMON.Bool_to_Number(PurReqPoEnabled),
206: MSC_WS_COMMON.Bool_to_Number(ReservesHardEnabled),
207: GetResAvail(ResourceAvailability) ,
208: MSC_WS_COMMON.Bool_to_Number(SafestockEnabled),
209: MSC_WS_COMMON.Bool_to_Number(SalesorderRtype),
210: MSC_WS_COMMON.Bool_to_Number(SourcingHistoryEnabled),
211: MSC_WS_COMMON.Bool_to_Number(SourcingEnabled),
212: MSC_WS_COMMON.Bool_to_Number(SubInvEnabled),
213:

Line 210: MSC_WS_COMMON.Bool_to_Number(SourcingHistoryEnabled),

206: MSC_WS_COMMON.Bool_to_Number(ReservesHardEnabled),
207: GetResAvail(ResourceAvailability) ,
208: MSC_WS_COMMON.Bool_to_Number(SafestockEnabled),
209: MSC_WS_COMMON.Bool_to_Number(SalesorderRtype),
210: MSC_WS_COMMON.Bool_to_Number(SourcingHistoryEnabled),
211: MSC_WS_COMMON.Bool_to_Number(SourcingEnabled),
212: MSC_WS_COMMON.Bool_to_Number(SubInvEnabled),
213:
214: MSC_WS_COMMON.Bool_to_Number(SupplierResponseEnabled),

Line 211: MSC_WS_COMMON.Bool_to_Number(SourcingEnabled),

207: GetResAvail(ResourceAvailability) ,
208: MSC_WS_COMMON.Bool_to_Number(SafestockEnabled),
209: MSC_WS_COMMON.Bool_to_Number(SalesorderRtype),
210: MSC_WS_COMMON.Bool_to_Number(SourcingHistoryEnabled),
211: MSC_WS_COMMON.Bool_to_Number(SourcingEnabled),
212: MSC_WS_COMMON.Bool_to_Number(SubInvEnabled),
213:
214: MSC_WS_COMMON.Bool_to_Number(SupplierResponseEnabled),
215: MSC_WS_COMMON.Bool_to_Number(TpCustomerEnabled),

Line 212: MSC_WS_COMMON.Bool_to_Number(SubInvEnabled),

208: MSC_WS_COMMON.Bool_to_Number(SafestockEnabled),
209: MSC_WS_COMMON.Bool_to_Number(SalesorderRtype),
210: MSC_WS_COMMON.Bool_to_Number(SourcingHistoryEnabled),
211: MSC_WS_COMMON.Bool_to_Number(SourcingEnabled),
212: MSC_WS_COMMON.Bool_to_Number(SubInvEnabled),
213:
214: MSC_WS_COMMON.Bool_to_Number(SupplierResponseEnabled),
215: MSC_WS_COMMON.Bool_to_Number(TpCustomerEnabled),
216: MSC_WS_COMMON.Bool_to_Number('N'),

Line 214: MSC_WS_COMMON.Bool_to_Number(SupplierResponseEnabled),

210: MSC_WS_COMMON.Bool_to_Number(SourcingHistoryEnabled),
211: MSC_WS_COMMON.Bool_to_Number(SourcingEnabled),
212: MSC_WS_COMMON.Bool_to_Number(SubInvEnabled),
213:
214: MSC_WS_COMMON.Bool_to_Number(SupplierResponseEnabled),
215: MSC_WS_COMMON.Bool_to_Number(TpCustomerEnabled),
216: MSC_WS_COMMON.Bool_to_Number('N'),
217: MSC_WS_COMMON.Bool_to_Number(TripEnabled),
218: MSC_WS_COMMON.Bool_to_Number(UnitNoEnabled),

Line 215: MSC_WS_COMMON.Bool_to_Number(TpCustomerEnabled),

211: MSC_WS_COMMON.Bool_to_Number(SourcingEnabled),
212: MSC_WS_COMMON.Bool_to_Number(SubInvEnabled),
213:
214: MSC_WS_COMMON.Bool_to_Number(SupplierResponseEnabled),
215: MSC_WS_COMMON.Bool_to_Number(TpCustomerEnabled),
216: MSC_WS_COMMON.Bool_to_Number('N'),
217: MSC_WS_COMMON.Bool_to_Number(TripEnabled),
218: MSC_WS_COMMON.Bool_to_Number(UnitNoEnabled),
219: MSC_WS_COMMON.Bool_to_Number(UomEnabled),

Line 216: MSC_WS_COMMON.Bool_to_Number('N'),

212: MSC_WS_COMMON.Bool_to_Number(SubInvEnabled),
213:
214: MSC_WS_COMMON.Bool_to_Number(SupplierResponseEnabled),
215: MSC_WS_COMMON.Bool_to_Number(TpCustomerEnabled),
216: MSC_WS_COMMON.Bool_to_Number('N'),
217: MSC_WS_COMMON.Bool_to_Number(TripEnabled),
218: MSC_WS_COMMON.Bool_to_Number(UnitNoEnabled),
219: MSC_WS_COMMON.Bool_to_Number(UomEnabled),
220: GetUserCompAssoc(UserCompanyAssoc),

Line 217: MSC_WS_COMMON.Bool_to_Number(TripEnabled),

213:
214: MSC_WS_COMMON.Bool_to_Number(SupplierResponseEnabled),
215: MSC_WS_COMMON.Bool_to_Number(TpCustomerEnabled),
216: MSC_WS_COMMON.Bool_to_Number('N'),
217: MSC_WS_COMMON.Bool_to_Number(TripEnabled),
218: MSC_WS_COMMON.Bool_to_Number(UnitNoEnabled),
219: MSC_WS_COMMON.Bool_to_Number(UomEnabled),
220: GetUserCompAssoc(UserCompanyAssoc),
221: MSC_WS_COMMON.Bool_to_Number(UserSupplyDemand),

Line 218: MSC_WS_COMMON.Bool_to_Number(UnitNoEnabled),

214: MSC_WS_COMMON.Bool_to_Number(SupplierResponseEnabled),
215: MSC_WS_COMMON.Bool_to_Number(TpCustomerEnabled),
216: MSC_WS_COMMON.Bool_to_Number('N'),
217: MSC_WS_COMMON.Bool_to_Number(TripEnabled),
218: MSC_WS_COMMON.Bool_to_Number(UnitNoEnabled),
219: MSC_WS_COMMON.Bool_to_Number(UomEnabled),
220: GetUserCompAssoc(UserCompanyAssoc),
221: MSC_WS_COMMON.Bool_to_Number(UserSupplyDemand),
222: MSC_WS_COMMON.Bool_to_Number(WipEnabled),

Line 219: MSC_WS_COMMON.Bool_to_Number(UomEnabled),

215: MSC_WS_COMMON.Bool_to_Number(TpCustomerEnabled),
216: MSC_WS_COMMON.Bool_to_Number('N'),
217: MSC_WS_COMMON.Bool_to_Number(TripEnabled),
218: MSC_WS_COMMON.Bool_to_Number(UnitNoEnabled),
219: MSC_WS_COMMON.Bool_to_Number(UomEnabled),
220: GetUserCompAssoc(UserCompanyAssoc),
221: MSC_WS_COMMON.Bool_to_Number(UserSupplyDemand),
222: MSC_WS_COMMON.Bool_to_Number(WipEnabled),
223: MSC_WS_COMMON.Bool_to_Number(SalesChannelEnabled),

Line 221: MSC_WS_COMMON.Bool_to_Number(UserSupplyDemand),

217: MSC_WS_COMMON.Bool_to_Number(TripEnabled),
218: MSC_WS_COMMON.Bool_to_Number(UnitNoEnabled),
219: MSC_WS_COMMON.Bool_to_Number(UomEnabled),
220: GetUserCompAssoc(UserCompanyAssoc),
221: MSC_WS_COMMON.Bool_to_Number(UserSupplyDemand),
222: MSC_WS_COMMON.Bool_to_Number(WipEnabled),
223: MSC_WS_COMMON.Bool_to_Number(SalesChannelEnabled),
224: MSC_WS_COMMON.Bool_to_Number(FiscalCalendarEnabled),
225: MSC_WS_COMMON.Bool_to_Number(InternalRepairEnabled),

Line 222: MSC_WS_COMMON.Bool_to_Number(WipEnabled),

218: MSC_WS_COMMON.Bool_to_Number(UnitNoEnabled),
219: MSC_WS_COMMON.Bool_to_Number(UomEnabled),
220: GetUserCompAssoc(UserCompanyAssoc),
221: MSC_WS_COMMON.Bool_to_Number(UserSupplyDemand),
222: MSC_WS_COMMON.Bool_to_Number(WipEnabled),
223: MSC_WS_COMMON.Bool_to_Number(SalesChannelEnabled),
224: MSC_WS_COMMON.Bool_to_Number(FiscalCalendarEnabled),
225: MSC_WS_COMMON.Bool_to_Number(InternalRepairEnabled),
226: MSC_WS_COMMON.Bool_to_Number(ExternalRepairEnabled ),

Line 223: MSC_WS_COMMON.Bool_to_Number(SalesChannelEnabled),

219: MSC_WS_COMMON.Bool_to_Number(UomEnabled),
220: GetUserCompAssoc(UserCompanyAssoc),
221: MSC_WS_COMMON.Bool_to_Number(UserSupplyDemand),
222: MSC_WS_COMMON.Bool_to_Number(WipEnabled),
223: MSC_WS_COMMON.Bool_to_Number(SalesChannelEnabled),
224: MSC_WS_COMMON.Bool_to_Number(FiscalCalendarEnabled),
225: MSC_WS_COMMON.Bool_to_Number(InternalRepairEnabled),
226: MSC_WS_COMMON.Bool_to_Number(ExternalRepairEnabled ),
227: MSC_WS_COMMON.Bool_to_Number(PaybackDemandSupplyEnabled ),

Line 224: MSC_WS_COMMON.Bool_to_Number(FiscalCalendarEnabled),

220: GetUserCompAssoc(UserCompanyAssoc),
221: MSC_WS_COMMON.Bool_to_Number(UserSupplyDemand),
222: MSC_WS_COMMON.Bool_to_Number(WipEnabled),
223: MSC_WS_COMMON.Bool_to_Number(SalesChannelEnabled),
224: MSC_WS_COMMON.Bool_to_Number(FiscalCalendarEnabled),
225: MSC_WS_COMMON.Bool_to_Number(InternalRepairEnabled),
226: MSC_WS_COMMON.Bool_to_Number(ExternalRepairEnabled ),
227: MSC_WS_COMMON.Bool_to_Number(PaybackDemandSupplyEnabled ),
228: MSC_WS_COMMON.Bool_to_Number(CurrencyConversionEnabled ),

Line 225: MSC_WS_COMMON.Bool_to_Number(InternalRepairEnabled),

221: MSC_WS_COMMON.Bool_to_Number(UserSupplyDemand),
222: MSC_WS_COMMON.Bool_to_Number(WipEnabled),
223: MSC_WS_COMMON.Bool_to_Number(SalesChannelEnabled),
224: MSC_WS_COMMON.Bool_to_Number(FiscalCalendarEnabled),
225: MSC_WS_COMMON.Bool_to_Number(InternalRepairEnabled),
226: MSC_WS_COMMON.Bool_to_Number(ExternalRepairEnabled ),
227: MSC_WS_COMMON.Bool_to_Number(PaybackDemandSupplyEnabled ),
228: MSC_WS_COMMON.Bool_to_Number(CurrencyConversionEnabled ),
229: MSC_WS_COMMON.Bool_to_Number(DeliveryDetailsEnabled )

Line 226: MSC_WS_COMMON.Bool_to_Number(ExternalRepairEnabled ),

222: MSC_WS_COMMON.Bool_to_Number(WipEnabled),
223: MSC_WS_COMMON.Bool_to_Number(SalesChannelEnabled),
224: MSC_WS_COMMON.Bool_to_Number(FiscalCalendarEnabled),
225: MSC_WS_COMMON.Bool_to_Number(InternalRepairEnabled),
226: MSC_WS_COMMON.Bool_to_Number(ExternalRepairEnabled ),
227: MSC_WS_COMMON.Bool_to_Number(PaybackDemandSupplyEnabled ),
228: MSC_WS_COMMON.Bool_to_Number(CurrencyConversionEnabled ),
229: MSC_WS_COMMON.Bool_to_Number(DeliveryDetailsEnabled )
230: );

Line 227: MSC_WS_COMMON.Bool_to_Number(PaybackDemandSupplyEnabled ),

223: MSC_WS_COMMON.Bool_to_Number(SalesChannelEnabled),
224: MSC_WS_COMMON.Bool_to_Number(FiscalCalendarEnabled),
225: MSC_WS_COMMON.Bool_to_Number(InternalRepairEnabled),
226: MSC_WS_COMMON.Bool_to_Number(ExternalRepairEnabled ),
227: MSC_WS_COMMON.Bool_to_Number(PaybackDemandSupplyEnabled ),
228: MSC_WS_COMMON.Bool_to_Number(CurrencyConversionEnabled ),
229: MSC_WS_COMMON.Bool_to_Number(DeliveryDetailsEnabled )
230: );
231:

Line 228: MSC_WS_COMMON.Bool_to_Number(CurrencyConversionEnabled ),

224: MSC_WS_COMMON.Bool_to_Number(FiscalCalendarEnabled),
225: MSC_WS_COMMON.Bool_to_Number(InternalRepairEnabled),
226: MSC_WS_COMMON.Bool_to_Number(ExternalRepairEnabled ),
227: MSC_WS_COMMON.Bool_to_Number(PaybackDemandSupplyEnabled ),
228: MSC_WS_COMMON.Bool_to_Number(CurrencyConversionEnabled ),
229: MSC_WS_COMMON.Bool_to_Number(DeliveryDetailsEnabled )
230: );
231:
232: IF(result = false) THEN

Line 229: MSC_WS_COMMON.Bool_to_Number(DeliveryDetailsEnabled )

225: MSC_WS_COMMON.Bool_to_Number(InternalRepairEnabled),
226: MSC_WS_COMMON.Bool_to_Number(ExternalRepairEnabled ),
227: MSC_WS_COMMON.Bool_to_Number(PaybackDemandSupplyEnabled ),
228: MSC_WS_COMMON.Bool_to_Number(CurrencyConversionEnabled ),
229: MSC_WS_COMMON.Bool_to_Number(DeliveryDetailsEnabled )
230: );
231:
232: IF(result = false) THEN
233: RAISE submit_failed ;

Line 239: MSC_WS_COMMON.Bool_to_Number(RecalcResAvailability),

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:
243: IF(result = false) THEN

Line 240: MSC_WS_COMMON.Bool_to_Number(SourcingHistoryEnabled),

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:
243: IF(result = false) THEN
244: RAISE submit_failed ;

Line 241: MSC_WS_COMMON.Bool_to_Number(PurgeSourcingHistory));

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:
243: IF(result = false) THEN
244: RAISE submit_failed ;
245: END IF ;

Line 337: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

333: error_tracking_num number;
334: l_SecutirtGroupId NUMBER;
335: BEGIN
336: error_tracking_num :=2010;
337: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
338: IF (l_String <> 'OK') THEN
339: Status := l_String;
340: RETURN;
341: END IF;

Line 343: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid,'MSC_FNDRSRUN_COLL', l_SecutirtGroupId);

339: Status := l_String;
340: RETURN;
341: END IF;
342: error_tracking_num :=2020;
343: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid,'MSC_FNDRSRUN_COLL', l_SecutirtGroupId);
344: IF (l_String <> 'OK') THEN
345: Status := l_String;
346: RETURN;
347: END IF;

Line 445: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);

441: submit_failed EXCEPTION;
442: error_tracking_num NUMBER;
443: BEGIN
444: error_tracking_num :=100;
445: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);
446: IF (L_VAL_RESULT <> 'OK') THEN
447: PROCESSID := -1;
448: STATUS := L_VAL_RESULT;
449: RETURN;

Line 478: MSC_WS_COMMON.Bool_to_Number(RecalcResAvailability),

474: -- register Planning ODS Load
475: error_tracking_num :=150;
476: req_id := fnd_request.submit_request('MSC','MSCPDC','Planning ODS Load',NULL, false,
477: InstanceId, Timeout, TotalWorkerNum,
478: MSC_WS_COMMON.Bool_to_Number(RecalcResAvailability),
479: MSC_WS_COMMON.Bool_to_Number(RecalcSourcingHistory),
480: MSC_WS_COMMON.Bool_to_Number(PurgeSourcingHistory));
481:
482: IF(req_id = 0) THEN

Line 479: MSC_WS_COMMON.Bool_to_Number(RecalcSourcingHistory),

475: error_tracking_num :=150;
476: req_id := fnd_request.submit_request('MSC','MSCPDC','Planning ODS Load',NULL, false,
477: InstanceId, Timeout, TotalWorkerNum,
478: MSC_WS_COMMON.Bool_to_Number(RecalcResAvailability),
479: MSC_WS_COMMON.Bool_to_Number(RecalcSourcingHistory),
480: MSC_WS_COMMON.Bool_to_Number(PurgeSourcingHistory));
481:
482: IF(req_id = 0) THEN
483: raise submit_failed ;

Line 480: MSC_WS_COMMON.Bool_to_Number(PurgeSourcingHistory));

476: req_id := fnd_request.submit_request('MSC','MSCPDC','Planning ODS Load',NULL, false,
477: InstanceId, Timeout, TotalWorkerNum,
478: MSC_WS_COMMON.Bool_to_Number(RecalcResAvailability),
479: MSC_WS_COMMON.Bool_to_Number(RecalcSourcingHistory),
480: MSC_WS_COMMON.Bool_to_Number(PurgeSourcingHistory));
481:
482: IF(req_id = 0) THEN
483: raise submit_failed ;
484: END IF ;

Line 523: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

519: error_tracking_num number;
520: l_SecutirtGroupId NUMBER;
521: BEGIN
522: error_tracking_num :=2010;
523: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
524: IF (l_String <> 'OK') THEN
525: Status := l_String;
526: RETURN;
527: END IF;

Line 529: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid,'MSC_FNDRSRUN_COLL', l_SecutirtGroupId);

525: Status := l_String;
526: RETURN;
527: END IF;
528: error_tracking_num :=2020;
529: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid,'MSC_FNDRSRUN_COLL', l_SecutirtGroupId);
530: IF (l_String <> 'OK') THEN
531: Status := l_String;
532: RETURN;
533: END IF;

Line 605: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);

601: /* VALIDATE: InstanceId, CollectionGroup , CollectionMethod,DateRangeType*/
602: /* for CollectAllOrderTypes = no , EITHER IncludeOrderTypes non empty, or ExcludeOrderTypes not empty, but not both*/
603:
604: error_tracking_num := 100;
605: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);
606: IF (L_VAL_RESULT <> 'OK') THEN
607: PROCESSID := -1;
608: STATUS := L_VAL_RESULT;
609: RETURN;

Line 692: MSC_WS_COMMON.Bool_to_Number(BHBookedItemsBookedDate),

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),
693: MSC_WS_COMMON.Bool_to_Number(BHBookedItemsRequestedDate),
694: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsBookedDate),
695: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsRequestedDate),
696: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsShippedDate),

Line 693: MSC_WS_COMMON.Bool_to_Number(BHBookedItemsRequestedDate),

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),
693: MSC_WS_COMMON.Bool_to_Number(BHBookedItemsRequestedDate),
694: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsBookedDate),
695: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsRequestedDate),
696: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsShippedDate),
697: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsRequestedDate),

Line 694: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsBookedDate),

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),
693: MSC_WS_COMMON.Bool_to_Number(BHBookedItemsRequestedDate),
694: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsBookedDate),
695: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsRequestedDate),
696: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsShippedDate),
697: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsRequestedDate),
698: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsShippedDate),

Line 695: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsRequestedDate),

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),
693: MSC_WS_COMMON.Bool_to_Number(BHBookedItemsRequestedDate),
694: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsBookedDate),
695: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsRequestedDate),
696: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsShippedDate),
697: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsRequestedDate),
698: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsShippedDate),
699: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsRequestedDate),

Line 696: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsShippedDate),

692: MSC_WS_COMMON.Bool_to_Number(BHBookedItemsBookedDate),
693: MSC_WS_COMMON.Bool_to_Number(BHBookedItemsRequestedDate),
694: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsBookedDate),
695: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsRequestedDate),
696: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsShippedDate),
697: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsRequestedDate),
698: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsShippedDate),
699: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsRequestedDate),
700: MSC_WS_COMMON.Bool_to_Number(CollectISO),

Line 697: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsRequestedDate),

693: MSC_WS_COMMON.Bool_to_Number(BHBookedItemsRequestedDate),
694: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsBookedDate),
695: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsRequestedDate),
696: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsShippedDate),
697: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsRequestedDate),
698: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsShippedDate),
699: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsRequestedDate),
700: MSC_WS_COMMON.Bool_to_Number(CollectISO),
701: MSC_WS_COMMON.Bool_to_Number(CollectAllOrderTypes ),

Line 698: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsShippedDate),

694: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsBookedDate),
695: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsRequestedDate),
696: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsShippedDate),
697: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsRequestedDate),
698: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsShippedDate),
699: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsRequestedDate),
700: MSC_WS_COMMON.Bool_to_Number(CollectISO),
701: MSC_WS_COMMON.Bool_to_Number(CollectAllOrderTypes ),
702: IncludeOrderTypes,

Line 699: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsRequestedDate),

695: MSC_WS_COMMON.Bool_to_Number(BHRequestedItemsRequestedDate),
696: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsShippedDate),
697: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsRequestedDate),
698: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsShippedDate),
699: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsRequestedDate),
700: MSC_WS_COMMON.Bool_to_Number(CollectISO),
701: MSC_WS_COMMON.Bool_to_Number(CollectAllOrderTypes ),
702: IncludeOrderTypes,
703: ExcludeOrderTypes,

Line 700: MSC_WS_COMMON.Bool_to_Number(CollectISO),

696: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsShippedDate),
697: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsRequestedDate),
698: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsShippedDate),
699: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsRequestedDate),
700: MSC_WS_COMMON.Bool_to_Number(CollectISO),
701: MSC_WS_COMMON.Bool_to_Number(CollectAllOrderTypes ),
702: IncludeOrderTypes,
703: ExcludeOrderTypes,
704: MSC_WS_COMMON.Bool_to_Number(LaunchDownload )

Line 701: MSC_WS_COMMON.Bool_to_Number(CollectAllOrderTypes ),

697: MSC_WS_COMMON.Bool_to_Number(SHShippedItemsRequestedDate),
698: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsShippedDate),
699: MSC_WS_COMMON.Bool_to_Number(SHRequestedItemsRequestedDate),
700: MSC_WS_COMMON.Bool_to_Number(CollectISO),
701: MSC_WS_COMMON.Bool_to_Number(CollectAllOrderTypes ),
702: IncludeOrderTypes,
703: ExcludeOrderTypes,
704: MSC_WS_COMMON.Bool_to_Number(LaunchDownload )
705: );

Line 704: MSC_WS_COMMON.Bool_to_Number(LaunchDownload )

700: MSC_WS_COMMON.Bool_to_Number(CollectISO),
701: MSC_WS_COMMON.Bool_to_Number(CollectAllOrderTypes ),
702: IncludeOrderTypes,
703: ExcludeOrderTypes,
704: MSC_WS_COMMON.Bool_to_Number(LaunchDownload )
705: );
706:
707: IF(result = false) THEN
708: RAISE submit_failed ;

Line 751: MSC_WS_COMMON.Bool_to_Number(LaunchDownload ));

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 ;
755: END IF ;

Line 760: MSC_WS_COMMON.Bool_to_Number(LaunchDownload ));

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 ;
764: END IF ;

Line 825: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

821: error_tracking_num number;
822: l_SecutirtGroupId NUMBER;
823: BEGIN
824: error_tracking_num :=2010;
825: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
826: IF (l_String <> 'OK') THEN
827: Status := l_String;
828: RETURN;
829: END IF;

Line 831: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid,'MSD_DEM_FNDRSRUN_CHD', l_SecutirtGroupId);

827: Status := l_String;
828: RETURN;
829: END IF;
830: error_tracking_num :=2020;
831: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid,'MSD_DEM_FNDRSRUN_CHD', l_SecutirtGroupId);
832: IF (l_String <> 'OK') THEN
833: Status := l_String;
834: RETURN;
835: END IF;

Line 902: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);

898: BEGIN
899: /* validate: Instanceid, CollectionGroup, CollectionMenthod, DateRangeType*/
900:
901: error_tracking_number := 100;
902: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);
903: IF (L_VAL_RESULT <> 'OK') THEN
904: PROCESSID := -1;
905: STATUS := L_VAL_RESULT;
906: RETURN;

Line 1016: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

1012: error_tracking_num number;
1013: l_SecutirtGroupId NUMBER;
1014: BEGIN
1015: error_tracking_num :=2010;
1016: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
1017: IF (l_String <> 'OK') THEN
1018: Status := l_String;
1019: RETURN;
1020: END IF;

Line 1022: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid,respid,'MSD_DEM_FNDRSRUN_SCI', l_SecutirtGroupId);

1018: Status := l_String;
1019: RETURN;
1020: END IF;
1021: error_tracking_num :=2020;
1022: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid,respid,'MSD_DEM_FNDRSRUN_SCI', l_SecutirtGroupId);
1023: IF (l_String <> 'OK') THEN
1024: Status := l_String;
1025: RETURN;
1026: END IF;

Line 1080: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);

1076: error_tracking_number NUMBER;
1077: BEGIN
1078:
1079: error_tracking_number:= 100;
1080: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);
1081: IF (L_VAL_RESULT <> 'OK') THEN
1082: PROCESSID := -1;
1083: STATUS := L_VAL_RESULT;
1084: RETURN;

Line 1117: MSC_WS_COMMON.Bool_to_Number(CollectAllCurrencies),

1113: error_tracking_number:= 130;
1114: req_id := fnd_request.submit_request('MSD','MSDDEMCCONV','Collect Currency',NULL, false,
1115: InstanceId,
1116: to_char(DateFrom, 'YYYY/MM/DD HH24:MI:SS'), to_char(DateTo, 'YYYY/MM/DD HH24:MI:SS'),
1117: MSC_WS_COMMON.Bool_to_Number(CollectAllCurrencies),
1118: IncludeCurrencyList,
1119: ExcludeCurrencyList
1120: );
1121:

Line 1165: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

1161: error_tracking_num number;
1162: l_SecutirtGroupId NUMBER;
1163: BEGIN
1164: error_tracking_num :=2010;
1165: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
1166: IF (l_String <> 'OK') THEN
1167: Status := l_String;
1168: RETURN;
1169: END IF;

Line 1171: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSD_DEM_FNDRSRUN_CURCONV',l_SecutirtGroupId);

1167: Status := l_String;
1168: RETURN;
1169: END IF;
1170: error_tracking_num :=2020;
1171: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSD_DEM_FNDRSRUN_CURCONV',l_SecutirtGroupId);
1172: IF (l_String <> 'OK') THEN
1173: Status := l_String;
1174: RETURN;
1175: END IF;

Line 1221: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);

1217: error_tracking_number NUMBER;
1218: BEGIN
1219:
1220: error_tracking_number := 100;
1221: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);
1222: IF (L_VAL_RESULT <> 'OK') THEN
1223: PROCESSID := -1;
1224: STATUS := L_VAL_RESULT;
1225: RETURN;

Line 1249: MSC_WS_COMMON.Bool_to_Number(IncludeAll),

1245: -- register Collect UOM Conversions
1246: error_tracking_number := 130;
1247: req_id := fnd_request.submit_request('MSD','MSDDEMUOM','UOM Conversions',NULL, false,
1248: InstanceId,
1249: MSC_WS_COMMON.Bool_to_Number(IncludeAll),
1250: IncludeUomList,
1251: ExcludeUomList
1252: );
1253:

Line 1294: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

1290: error_tracking_num number;
1291: l_SecutirtGroupId NUMBER;
1292: BEGIN
1293: error_tracking_num :=2010;
1294: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
1295: IF (l_String <> 'OK') THEN
1296: status := l_String;
1297: RETURN;
1298: END IF;

Line 1300: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid,'MSD_DEM_FNDRSRUN_UOM', l_SecutirtGroupId);

1296: status := l_String;
1297: RETURN;
1298: END IF;
1299: error_tracking_num :=2020;
1300: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid,'MSD_DEM_FNDRSRUN_UOM', l_SecutirtGroupId);
1301: IF (l_String <> 'OK') THEN
1302: status := l_String;
1303: RETURN;
1304: END IF;

Line 1353: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);

1349: error_tracking_number NUMBER;
1350: BEGIN
1351:
1352: error_tracking_number := 100;
1353: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);
1354: IF (L_VAL_RESULT <> 'OK') THEN
1355: PROCESSID := -1;
1356: STATUS := L_VAL_RESULT;
1357: RETURN;

Line 1401: MSC_WS_COMMON.Bool_to_Number(IncludeAllLists),

1397: req_id := fnd_request.submit_request('MSD','MSDDEMPRL','Collect Price Lists',NULL, false,
1398: InstanceId,
1399: to_char(DateFrom, 'YYYY/MM/DD HH24:MI:SS'),
1400: to_char(DateTo, 'YYYY/MM/DD HH24:MI:SS'),
1401: MSC_WS_COMMON.Bool_to_Number(IncludeAllLists),
1402: IncludePriceList,
1403: ExcludePriceList
1404: );
1405:

Line 1449: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

1445: error_tracking_num number;
1446: l_SecutirtGroupId NUMBER;
1447: BEGIN
1448: error_tracking_num :=2010;
1449: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
1450: IF (l_String <> 'OK') THEN
1451: Status := l_String;
1452: RETURN;
1453: END IF;

Line 1455: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid,'MSD_DEM_FNDRSRUN_PRL', l_SecutirtGroupId);

1451: Status := l_String;
1452: RETURN;
1453: END IF;
1454: error_tracking_num :=2020;
1455: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid,'MSD_DEM_FNDRSRUN_PRL', l_SecutirtGroupId);
1456: IF (l_String <> 'OK') THEN
1457: Status := l_String;
1458: RETURN;
1459: END IF;

Line 1511: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);

1507: passedCollectionGroup varchar2(100);
1508:
1509: BEGIN
1510: error_tracking_number:=100;
1511: MSC_WS_COMMON.VALIDATE_USER_RESP (L_VAL_RESULT, UserId, ResponsibilityID);
1512: IF (L_VAL_RESULT <> 'OK') THEN
1513: PROCESSID := -1;
1514: STATUS := L_VAL_RESULT;
1515: RETURN;

Line 1615: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

1611: error_tracking_num number;
1612: l_SecutirtGroupId NUMBER;
1613: BEGIN
1614: error_tracking_num :=2010;
1615: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
1616: IF (l_String <> 'OK') THEN
1617: Status := l_String;
1618: RETURN;
1619: END IF;

Line 1621: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid,'MSD_DEM_CRH', l_SecutirtGroupId);

1617: Status := l_String;
1618: RETURN;
1619: END IF;
1620: error_tracking_num :=2020;
1621: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid,'MSD_DEM_CRH', l_SecutirtGroupId);
1622: IF (l_String <> 'OK') THEN
1623: Status := l_String;
1624: RETURN;
1625: END IF;