DBA Data[Home] [Help]

APPS.WIP_INFINITE_SCHEDULER_PVT dependencies on FND_API

Line 111: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

107:
108: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
109: p_params => l_params,
110: x_returnStatus => x_returnStatus);
111: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
112: raise fnd_api.g_exc_unexpected_error;
113: end if;
114: end if;
115: x_returnStatus := fnd_api.g_ret_sts_success;

Line 112: raise fnd_api.g_exc_unexpected_error;

108: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
109: p_params => l_params,
110: x_returnStatus => x_returnStatus);
111: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
112: raise fnd_api.g_exc_unexpected_error;
113: end if;
114: end if;
115: x_returnStatus := fnd_api.g_ret_sts_success;
116:

Line 115: x_returnStatus := fnd_api.g_ret_sts_success;

111: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
112: raise fnd_api.g_exc_unexpected_error;
113: end if;
114: end if;
115: x_returnStatus := fnd_api.g_ret_sts_success;
116:
117: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_true))) then
118: fnd_msg_pub.initialize;
119: end if;

Line 117: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_true))) then

113: end if;
114: end if;
115: x_returnStatus := fnd_api.g_ret_sts_success;
116:
117: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_true))) then
118: fnd_msg_pub.initialize;
119: end if;
120:
121: if (l_logLevel <= wip_constants.full_logging) then

Line 159: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

155: x_resTbls => l_resTbls,
156: x_assignedUnits => l_assignedUnits,
157: x_returnStatus => x_returnStatus);
158:
159: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
160: raise fnd_api.g_exc_unexpected_error;
161: end if;
162: /*
163: if(p_repSchedID is not null) then

Line 160: raise fnd_api.g_exc_unexpected_error;

156: x_assignedUnits => l_assignedUnits,
157: x_returnStatus => x_returnStatus);
158:
159: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
160: raise fnd_api.g_exc_unexpected_error;
161: end if;
162: /*
163: if(p_repSchedID is not null) then
164: select line_id

Line 180: p_endDebug => fnd_api.g_false,

176: p_startDate => p_startDate,
177: p_endDate => p_endDate,
178: p_opSeqNum => p_opSeqNum,
179: p_resSeqNum => p_resSeqNum,
180: p_endDebug => fnd_api.g_false,
181: x_resTbls => l_resTbls,
182: x_returnStatus => x_returnStatus);
183: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
184: raise fnd_api.g_exc_unexpected_error;

Line 183: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

179: p_resSeqNum => p_resSeqNum,
180: p_endDebug => fnd_api.g_false,
181: x_resTbls => l_resTbls,
182: x_returnStatus => x_returnStatus);
183: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
184: raise fnd_api.g_exc_unexpected_error;
185: end if;
186:
187: if (l_logLevel <= wip_constants.full_logging) then

Line 184: raise fnd_api.g_exc_unexpected_error;

180: p_endDebug => fnd_api.g_false,
181: x_resTbls => l_resTbls,
182: x_returnStatus => x_returnStatus);
183: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
184: raise fnd_api.g_exc_unexpected_error;
185: end if;
186:
187: if (l_logLevel <= wip_constants.full_logging) then
188: wip_logger.log('writing job/schedule...', l_retStatus);

Line 204: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

200: p_assignedUnits => l_assignedUnits,
201: x_resTbls => l_resTbls,
202: x_returnStatus => x_returnStatus);
203:
204: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
205: raise fnd_api.g_exc_unexpected_error;
206: end if;
207:
208: if (l_logLevel <= wip_constants.trace_logging) then

Line 205: raise fnd_api.g_exc_unexpected_error;

201: x_resTbls => l_resTbls,
202: x_returnStatus => x_returnStatus);
203:
204: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
205: raise fnd_api.g_exc_unexpected_error;
206: end if;
207:
208: if (l_logLevel <= wip_constants.trace_logging) then
209: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',

Line 213: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

209: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
210: p_procReturnStatus => x_returnStatus,
211: p_msg => 'success',
212: x_returnStatus => l_retStatus);
213: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then
214: wip_logger.cleanup(l_retStatus);
215: end if;
216: end if;
217: exception

Line 218: when fnd_api.g_exc_unexpected_error then

214: wip_logger.cleanup(l_retStatus);
215: end if;
216: end if;
217: exception
218: when fnd_api.g_exc_unexpected_error then
219: rollback to wipiscdb0;
220: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
221: wip_utilities.get_message_stack(p_msg => x_errorMsg,
222: p_delete_stack => fnd_api.g_false);

Line 220: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

216: end if;
217: exception
218: when fnd_api.g_exc_unexpected_error then
219: rollback to wipiscdb0;
220: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
221: wip_utilities.get_message_stack(p_msg => x_errorMsg,
222: p_delete_stack => fnd_api.g_false);
223: if (l_logLevel <= wip_constants.trace_logging) then
224: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',

Line 222: p_delete_stack => fnd_api.g_false);

218: when fnd_api.g_exc_unexpected_error then
219: rollback to wipiscdb0;
220: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
221: wip_utilities.get_message_stack(p_msg => x_errorMsg,
222: p_delete_stack => fnd_api.g_false);
223: if (l_logLevel <= wip_constants.trace_logging) then
224: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
225: p_procReturnStatus => x_returnStatus,
226: p_msg => 'error: ' || x_errorMsg,

Line 228: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

224: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
225: p_procReturnStatus => x_returnStatus,
226: p_msg => 'error: ' || x_errorMsg,
227: x_returnStatus => l_retStatus);
228: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then
229: wip_logger.cleanup(l_retStatus);
230: end if;
231: end if;
232:

Line 235: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

231: end if;
232:
233: when others then
234: rollback to wipiscdb0;
235: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',
237: p_procedure_name => 'schedule',
238: p_error_text => SQLERRM);
239: wip_utilities.get_message_stack(p_msg => x_errorMsg,

Line 240: p_delete_stack => fnd_api.g_false);

236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',
237: p_procedure_name => 'schedule',
238: p_error_text => SQLERRM);
239: wip_utilities.get_message_stack(p_msg => x_errorMsg,
240: p_delete_stack => fnd_api.g_false);
241: if (l_logLevel <= wip_constants.trace_logging) then
242: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
243: p_procReturnStatus => x_returnStatus,
244: p_msg => 'unexp error: ' || x_errorMsg,

Line 246: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

242: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
243: p_procReturnStatus => x_returnStatus,
244: p_msg => 'unexp error: ' || x_errorMsg,
245: x_returnStatus => l_retStatus);
246: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then
247: wip_logger.cleanup(l_retStatus);
248: end if;
249: end if;
250: end schedule;

Line 560: x_returnStatus := fnd_api.g_ret_sts_success;

556: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',
557: p_params => l_params,
558: x_returnStatus => l_retStatus);
559: end if;
560: x_returnStatus := fnd_api.g_ret_sts_success;
561:
562: l_hrUOM := fnd_profile.value('BOM:HOUR_UOM_CODE');
563: select conversion_rate, uom_class
564: into l_hrVal, l_uomClass

Line 702: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

698: x_returnStatus => l_retStatus);
699: end if;
700: exception
701: when others then
702: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
703: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',
704: p_procedure_name => 'readJobSchedule',
705: p_error_text => SQLERRM);
706: if (l_logLevel <= wip_constants.trace_logging) then

Line 779: x_returnStatus := fnd_api.g_ret_sts_success;

775: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',
776: p_params => l_params,
777: x_returnStatus => l_retStatus);
778: end if;
779: x_returnStatus := fnd_api.g_ret_sts_success;
780:
781: --update resources
782: forall i in 1..x_resTbls.resID.count
783: update wip_operation_resources

Line 1159: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1155: end if;
1156: exception
1157: when others then
1158: rollback to wipiscdb100;
1159: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1160: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',
1161: p_procedure_name => 'writeJobSchedule',
1162: p_error_text => SQLERRM);
1163: if (l_logLevel <= wip_constants.trace_logging) then