239: p_procReturnStatus => x_returnStatus,
240: p_msg => 'records locked',
241: x_returnStatus => l_retStatus);
242: end if;
243: fnd_message.set_name('WIP', 'WIP_LOCKED_ROW_ALREADY_LOCKED');
244: x_errorMsg := fnd_message.get;
245: when fnd_api.g_exc_unexpected_error then
246: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
247: if (l_logLevel <= wip_constants.trace_logging) then
240: p_msg => 'records locked',
241: x_returnStatus => l_retStatus);
242: end if;
243: fnd_message.set_name('WIP', 'WIP_LOCKED_ROW_ALREADY_LOCKED');
244: x_errorMsg := fnd_message.get;
245: when fnd_api.g_exc_unexpected_error then
246: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
247: if (l_logLevel <= wip_constants.trace_logging) then
248: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
304: and process_phase = wip_constants.ml_validation
305: and load_type in (wip_constants.create_job, wip_constants.create_ns_job);
306:
307: if ( l_totalNum <> 1 ) then
308: fnd_message.set_name('WIP', 'WIP_WJSI_ONE_ROW');
309: x_errorMsg := fnd_message.get;
310: raise fnd_api.g_exc_unexpected_error;
311: end if;
312:
305: and load_type in (wip_constants.create_job, wip_constants.create_ns_job);
306:
307: if ( l_totalNum <> 1 ) then
308: fnd_message.set_name('WIP', 'WIP_WJSI_ONE_ROW');
309: x_errorMsg := fnd_message.get;
310: raise fnd_api.g_exc_unexpected_error;
311: end if;
312:
313: select count(*)
315: from wip_job_schedule_interface wjsi
316: where wjsi.group_id = l_groupID;
317:
318: if ( l_totalNum <> 1 ) then
319: fnd_message.set_name('WIP', 'WIP_WJSI_ONE_ROW');
320: x_errorMsg := fnd_message.get;
321: raise fnd_api.g_exc_unexpected_error;
322: end if;
323:
316: where wjsi.group_id = l_groupID;
317:
318: if ( l_totalNum <> 1 ) then
319: fnd_message.set_name('WIP', 'WIP_WJSI_ONE_ROW');
320: x_errorMsg := fnd_message.get;
321: raise fnd_api.g_exc_unexpected_error;
322: end if;
323:
324: -- lock all the records
346: where interface_id = p_interfaceID
347: and process_status in (wip_constants.running, wip_constants.warning);
348:
349: if ( l_totalNum <> 1 ) then
350: fnd_message.set_name('WIP', 'WIP_WJSI_VAL_FAILED');
351: x_errorMsg := fnd_message.get;
352: raise fnd_api.g_exc_unexpected_error;
353: end if;
354:
347: and process_status in (wip_constants.running, wip_constants.warning);
348:
349: if ( l_totalNum <> 1 ) then
350: fnd_message.set_name('WIP', 'WIP_WJSI_VAL_FAILED');
351: x_errorMsg := fnd_message.get;
352: raise fnd_api.g_exc_unexpected_error;
353: end if;
354:
355: wip_massload_pvt.processWJSI(l_rowid, x_returnStatus, x_errorMsg);
410: end if;
411: exception
412: when wip_constants.records_locked then
413: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
414: fnd_message.set_name('WIP', 'WIP_LOCKED_ROW_ALREADY_LOCKED');
415: x_errorMsg := fnd_message.get;
416: wip_validateMLHeader_pvt.setInterfaceError(l_rowid,
417: p_interfaceID,
418: x_errorMsg,
411: exception
412: when wip_constants.records_locked then
413: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
414: fnd_message.set_name('WIP', 'WIP_LOCKED_ROW_ALREADY_LOCKED');
415: x_errorMsg := fnd_message.get;
416: wip_validateMLHeader_pvt.setInterfaceError(l_rowid,
417: p_interfaceID,
418: x_errorMsg,
419: g_wipMLError);
556: end if;
557: exception
558: when others then
559: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
560: fnd_message.set_name('WIP', l_msg);
561: if ( l_msg = 'WIP_ML_SER_DEF_FAILURE' ) then
562: fnd_message.set_token('MESSAGE', x_errorMsg);
563: end if;
564: x_errorMsg := fnd_message.get;
558: when others then
559: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
560: fnd_message.set_name('WIP', l_msg);
561: if ( l_msg = 'WIP_ML_SER_DEF_FAILURE' ) then
562: fnd_message.set_token('MESSAGE', x_errorMsg);
563: end if;
564: x_errorMsg := fnd_message.get;
565: end processSerStartOp;
566:
560: fnd_message.set_name('WIP', l_msg);
561: if ( l_msg = 'WIP_ML_SER_DEF_FAILURE' ) then
562: fnd_message.set_token('MESSAGE', x_errorMsg);
563: end if;
564: x_errorMsg := fnd_message.get;
565: end processSerStartOp;
566:
567: end wip_massload_pub;