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.INV_PULLSEQUENCE_PKG dependencies on FND_API

Line 196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

192: , 'Query_Row'
193: );
194: END IF;
195:
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197:
198: END Query_Row;
199:
200: FUNCTION Convert_Miss_To_Null

Line 207: IF l_pull_sequence_rec.pull_sequence_id = FND_API.G_MISS_NUM THEN

203: IS
204: l_pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type := p_pull_sequence_rec;
205: BEGIN
206:
207: IF l_pull_sequence_rec.pull_sequence_id = FND_API.G_MISS_NUM THEN
208: l_pull_sequence_rec.pull_sequence_id := NULL;
209: END IF;
210:
211: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

Line 211: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

207: IF l_pull_sequence_rec.pull_sequence_id = FND_API.G_MISS_NUM THEN
208: l_pull_sequence_rec.pull_sequence_id := NULL;
209: END IF;
210:
211: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
212: l_pull_sequence_rec.inventory_item_id := NULL;
213: END IF;
214:
215: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 215: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN

211: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
212: l_pull_sequence_rec.inventory_item_id := NULL;
213: END IF;
214:
215: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN
216: l_pull_sequence_rec.organization_id := NULL;
217: END IF;
218:
219: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN

Line 219: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN

215: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN
216: l_pull_sequence_rec.organization_id := NULL;
217: END IF;
218:
219: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN
220: l_pull_sequence_rec.subinventory_name := NULL;
221: END IF;
222:
223: IF l_pull_sequence_rec.kanban_plan_id = FND_API.G_MISS_NUM THEN

Line 223: IF l_pull_sequence_rec.kanban_plan_id = FND_API.G_MISS_NUM THEN

219: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN
220: l_pull_sequence_rec.subinventory_name := NULL;
221: END IF;
222:
223: IF l_pull_sequence_rec.kanban_plan_id = FND_API.G_MISS_NUM THEN
224: l_pull_sequence_rec.kanban_plan_id := NULL;
225: END IF;
226:
227: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN

Line 227: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN

223: IF l_pull_sequence_rec.kanban_plan_id = FND_API.G_MISS_NUM THEN
224: l_pull_sequence_rec.kanban_plan_id := NULL;
225: END IF;
226:
227: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN
228: l_pull_sequence_rec.source_type := NULL;
229: END IF;
230:
231: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 231: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN

227: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN
228: l_pull_sequence_rec.source_type := NULL;
229: END IF;
230:
231: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN
232: l_pull_sequence_rec.last_update_date := NULL;
233: END IF;
234:
235: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 235: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN

231: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN
232: l_pull_sequence_rec.last_update_date := NULL;
233: END IF;
234:
235: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN
236: l_pull_sequence_rec.last_updated_by := NULL;
237: END IF;
238:
239: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 239: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN

235: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN
236: l_pull_sequence_rec.last_updated_by := NULL;
237: END IF;
238:
239: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN
240: l_pull_sequence_rec.creation_date := NULL;
241: END IF;
242:
243: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN

Line 243: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN

239: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN
240: l_pull_sequence_rec.creation_date := NULL;
241: END IF;
242:
243: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN
244: l_pull_sequence_rec.created_by := NULL;
245: END IF;
246:
247: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 247: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN

243: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN
244: l_pull_sequence_rec.created_by := NULL;
245: END IF;
246:
247: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
248: l_pull_sequence_rec.last_update_login := NULL;
249: END IF;
250:
251: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN

Line 251: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN

247: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
248: l_pull_sequence_rec.last_update_login := NULL;
249: END IF;
250:
251: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN
252: l_pull_sequence_rec.locator_id := NULL;
253: END IF;
254:
255: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN

Line 255: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN

251: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN
252: l_pull_sequence_rec.locator_id := NULL;
253: END IF;
254:
255: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN
256: l_pull_sequence_rec.supplier_id := NULL;
257: END IF;
258:
259: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN

Line 259: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN

255: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN
256: l_pull_sequence_rec.supplier_id := NULL;
257: END IF;
258:
259: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN
260: l_pull_sequence_rec.source_organization_id := NULL;
261: END IF;
262:
263: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN

Line 263: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN

259: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN
260: l_pull_sequence_rec.source_organization_id := NULL;
261: END IF;
262:
263: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN
264: l_pull_sequence_rec.source_subinventory := NULL;
265: END IF;
266:
267: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN

Line 267: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN

263: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN
264: l_pull_sequence_rec.source_subinventory := NULL;
265: END IF;
266:
267: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN
268: l_pull_sequence_rec.source_locator_id := NULL;
269: END IF;
270:
271: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN

Line 271: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN

267: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN
268: l_pull_sequence_rec.source_locator_id := NULL;
269: END IF;
270:
271: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN
272: l_pull_sequence_rec.wip_line_id := NULL;
273: END IF;
274:
275: IF l_pull_sequence_rec.release_kanban_flag = FND_API.G_MISS_NUM THEN

Line 275: IF l_pull_sequence_rec.release_kanban_flag = FND_API.G_MISS_NUM THEN

271: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN
272: l_pull_sequence_rec.wip_line_id := NULL;
273: END IF;
274:
275: IF l_pull_sequence_rec.release_kanban_flag = FND_API.G_MISS_NUM THEN
276: l_pull_sequence_rec.release_kanban_flag := NULL;
277: END IF;
278:
279: IF l_pull_sequence_rec.calculate_kanban_flag = FND_API.G_MISS_NUM THEN

Line 279: IF l_pull_sequence_rec.calculate_kanban_flag = FND_API.G_MISS_NUM THEN

275: IF l_pull_sequence_rec.release_kanban_flag = FND_API.G_MISS_NUM THEN
276: l_pull_sequence_rec.release_kanban_flag := NULL;
277: END IF;
278:
279: IF l_pull_sequence_rec.calculate_kanban_flag = FND_API.G_MISS_NUM THEN
280: l_pull_sequence_rec.calculate_kanban_flag := NULL;
281: END IF;
282:
283: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN

Line 283: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN

279: IF l_pull_sequence_rec.calculate_kanban_flag = FND_API.G_MISS_NUM THEN
280: l_pull_sequence_rec.calculate_kanban_flag := NULL;
281: END IF;
282:
283: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN
284: l_pull_sequence_rec.kanban_size := NULL;
285: END IF;
286:
287: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN

Line 287: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN

283: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN
284: l_pull_sequence_rec.kanban_size := NULL;
285: END IF;
286:
287: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN
288: l_pull_sequence_rec.replenishment_lead_time := NULL;
289: END IF;
290:
291: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN

Line 291: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN

287: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN
288: l_pull_sequence_rec.replenishment_lead_time := NULL;
289: END IF;
290:
291: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN
292: l_pull_sequence_rec.fixed_lot_multiplier := NULL;
293: END IF;
294:
295: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN

Line 295: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN

291: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN
292: l_pull_sequence_rec.fixed_lot_multiplier := NULL;
293: END IF;
294:
295: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN
296: l_pull_sequence_rec.safety_stock_days := NULL;
297: END IF;
298:
299: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN

Line 299: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN

295: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN
296: l_pull_sequence_rec.safety_stock_days := NULL;
297: END IF;
298:
299: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN
300: l_pull_sequence_rec.number_of_cards := NULL;
301: END IF;
302:
303: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN

Line 303: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN

299: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN
300: l_pull_sequence_rec.number_of_cards := NULL;
301: END IF;
302:
303: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN
304: l_pull_sequence_rec.minimum_order_quantity := NULL;
305: END IF;
306:
307: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN

Line 307: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN

303: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN
304: l_pull_sequence_rec.minimum_order_quantity := NULL;
305: END IF;
306:
307: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN
308: l_pull_sequence_rec.aggregation_type := NULL;
309: END IF;
310:
311: IF l_pull_sequence_rec.allocation_percent = FND_API.G_MISS_NUM THEN

Line 311: IF l_pull_sequence_rec.allocation_percent = FND_API.G_MISS_NUM THEN

307: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN
308: l_pull_sequence_rec.aggregation_type := NULL;
309: END IF;
310:
311: IF l_pull_sequence_rec.allocation_percent = FND_API.G_MISS_NUM THEN
312: l_pull_sequence_rec.allocation_percent := NULL;
313: END IF;
314:
315: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 315: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN

311: IF l_pull_sequence_rec.allocation_percent = FND_API.G_MISS_NUM THEN
312: l_pull_sequence_rec.allocation_percent := NULL;
313: END IF;
314:
315: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
316: l_pull_sequence_rec.last_update_login := NULL;
317: END IF;
318:
319: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN

Line 319: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN

315: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
316: l_pull_sequence_rec.last_update_login := NULL;
317: END IF;
318:
319: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN
320: l_pull_sequence_rec.updated_flag := NULL;
321: END IF;
322:
323: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 323: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN

319: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN
320: l_pull_sequence_rec.updated_flag := NULL;
321: END IF;
322:
323: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN
324: l_pull_sequence_rec.attribute_category := NULL;
325: END IF;
326:
327: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 327: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN

323: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN
324: l_pull_sequence_rec.attribute_category := NULL;
325: END IF;
326:
327: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN
328: l_pull_sequence_rec.attribute1 := NULL;
329: END IF;
330:
331: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 331: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN

327: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN
328: l_pull_sequence_rec.attribute1 := NULL;
329: END IF;
330:
331: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN
332: l_pull_sequence_rec.attribute2 := NULL;
333: END IF;
334:
335: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 335: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN

331: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN
332: l_pull_sequence_rec.attribute2 := NULL;
333: END IF;
334:
335: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN
336: l_pull_sequence_rec.attribute3 := NULL;
337: END IF;
338:
339: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 339: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN

335: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN
336: l_pull_sequence_rec.attribute3 := NULL;
337: END IF;
338:
339: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN
340: l_pull_sequence_rec.attribute4 := NULL;
341: END IF;
342:
343: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 343: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN

339: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN
340: l_pull_sequence_rec.attribute4 := NULL;
341: END IF;
342:
343: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN
344: l_pull_sequence_rec.attribute5 := NULL;
345: END IF;
346:
347: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 347: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN

343: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN
344: l_pull_sequence_rec.attribute5 := NULL;
345: END IF;
346:
347: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN
348: l_pull_sequence_rec.attribute6 := NULL;
349: END IF;
350:
351: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 351: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN

347: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN
348: l_pull_sequence_rec.attribute6 := NULL;
349: END IF;
350:
351: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN
352: l_pull_sequence_rec.attribute7 := NULL;
353: END IF;
354:
355: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 355: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN

351: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN
352: l_pull_sequence_rec.attribute7 := NULL;
353: END IF;
354:
355: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN
356: l_pull_sequence_rec.attribute8 := NULL;
357: END IF;
358:
359: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 359: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN

355: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN
356: l_pull_sequence_rec.attribute8 := NULL;
357: END IF;
358:
359: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN
360: l_pull_sequence_rec.attribute9 := NULL;
361: END IF;
362:
363: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 363: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN

359: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN
360: l_pull_sequence_rec.attribute9 := NULL;
361: END IF;
362:
363: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN
364: l_pull_sequence_rec.attribute10 := NULL;
365: END IF;
366:
367: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 367: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN

363: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN
364: l_pull_sequence_rec.attribute10 := NULL;
365: END IF;
366:
367: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN
368: l_pull_sequence_rec.attribute11 := NULL;
369: END IF;
370:
371: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 371: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN

367: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN
368: l_pull_sequence_rec.attribute11 := NULL;
369: END IF;
370:
371: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN
372: l_pull_sequence_rec.attribute12 := NULL;
373: END IF;
374:
375: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 375: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN

371: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN
372: l_pull_sequence_rec.attribute12 := NULL;
373: END IF;
374:
375: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN
376: l_pull_sequence_rec.attribute13 := NULL;
377: END IF;
378:
379: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 379: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN

375: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN
376: l_pull_sequence_rec.attribute13 := NULL;
377: END IF;
378:
379: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN
380: l_pull_sequence_rec.attribute14 := NULL;
381: END IF;
382:
383: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 383: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN

379: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN
380: l_pull_sequence_rec.attribute14 := NULL;
381: END IF;
382:
383: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN
384: l_pull_sequence_rec.attribute15 := NULL;
385: END IF;
386:
387: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN

Line 387: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN

383: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN
384: l_pull_sequence_rec.attribute15 := NULL;
385: END IF;
386:
387: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN
388: l_pull_sequence_rec.request_id := NULL;
389: END IF;
390:
391: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 391: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN

387: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN
388: l_pull_sequence_rec.request_id := NULL;
389: END IF;
390:
391: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN
392: l_pull_sequence_rec.program_application_id := NULL;
393: END IF;
394:
395: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN

Line 395: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN

391: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN
392: l_pull_sequence_rec.program_application_id := NULL;
393: END IF;
394:
395: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN
396: l_pull_sequence_rec.program_id := NULL;
397: END IF;
398:
399: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 399: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN

395: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN
396: l_pull_sequence_rec.program_id := NULL;
397: END IF;
398:
399: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN
400: l_pull_sequence_rec.program_update_date := NULL;
401: END IF;
402:
403: IF l_pull_sequence_rec.point_of_use_x= FND_API.G_MISS_NUM THEN

Line 403: IF l_pull_sequence_rec.point_of_use_x= FND_API.G_MISS_NUM THEN

399: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN
400: l_pull_sequence_rec.program_update_date := NULL;
401: END IF;
402:
403: IF l_pull_sequence_rec.point_of_use_x= FND_API.G_MISS_NUM THEN
404: l_pull_sequence_rec.point_of_use_x := NULL;
405: END IF;
406:
407: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN

Line 407: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN

403: IF l_pull_sequence_rec.point_of_use_x= FND_API.G_MISS_NUM THEN
404: l_pull_sequence_rec.point_of_use_x := NULL;
405: END IF;
406:
407: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN
408: l_pull_sequence_rec.point_of_use_y := NULL;
409: END IF;
410:
411: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN

Line 411: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN

407: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN
408: l_pull_sequence_rec.point_of_use_y := NULL;
409: END IF;
410:
411: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN
412: l_pull_sequence_rec.point_of_supply_x := NULL;
413: END IF;
414:
415: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN

Line 415: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN

411: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN
412: l_pull_sequence_rec.point_of_supply_x := NULL;
413: END IF;
414:
415: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN
416: l_pull_sequence_rec.point_of_supply_y := NULL;
417: END IF;
418:
419: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN

Line 419: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN

415: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN
416: l_pull_sequence_rec.point_of_supply_y := NULL;
417: END IF;
418:
419: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN
420: l_pull_sequence_rec.planning_update_status := NULL;
421: END IF;
422:
423: IF l_pull_sequence_rec.auto_request = FND_API.G_MISS_CHAR THEN

Line 423: IF l_pull_sequence_rec.auto_request = FND_API.G_MISS_CHAR THEN

419: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN
420: l_pull_sequence_rec.planning_update_status := NULL;
421: END IF;
422:
423: IF l_pull_sequence_rec.auto_request = FND_API.G_MISS_CHAR THEN
424: l_pull_sequence_rec.auto_request := NULL;
425: END IF;
426:
427: /*Added the following IF statement for 3905884.*/

Line 428: IF l_pull_sequence_rec.auto_allocate_flag = FND_API.G_MISS_NUM THEN

424: l_pull_sequence_rec.auto_request := NULL;
425: END IF;
426:
427: /*Added the following IF statement for 3905884.*/
428: IF l_pull_sequence_rec.auto_allocate_flag = FND_API.G_MISS_NUM THEN
429: l_pull_sequence_rec.auto_allocate_flag := NULL;
430: END IF;
431:
432: RETURN l_pull_sequence_rec;

Line 444: IF l_pull_sequence_rec.pull_sequence_id = FND_API.G_MISS_NUM THEN

440: IS
441: l_pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type := p_pull_sequence_rec;
442: BEGIN
443:
444: IF l_pull_sequence_rec.pull_sequence_id = FND_API.G_MISS_NUM THEN
445: l_pull_sequence_rec.pull_sequence_id := p_old_pull_sequence_rec.pull_sequence_id;
446: END IF;
447:
448: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

Line 448: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

444: IF l_pull_sequence_rec.pull_sequence_id = FND_API.G_MISS_NUM THEN
445: l_pull_sequence_rec.pull_sequence_id := p_old_pull_sequence_rec.pull_sequence_id;
446: END IF;
447:
448: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
449: l_pull_sequence_rec.inventory_item_id := p_old_pull_sequence_rec.inventory_item_id;
450: END IF;
451:
452: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 452: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN

448: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
449: l_pull_sequence_rec.inventory_item_id := p_old_pull_sequence_rec.inventory_item_id;
450: END IF;
451:
452: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN
453: l_pull_sequence_rec.organization_id := p_old_pull_sequence_rec.organization_id;
454: END IF;
455:
456: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN

Line 456: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN

452: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN
453: l_pull_sequence_rec.organization_id := p_old_pull_sequence_rec.organization_id;
454: END IF;
455:
456: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN
457: l_pull_sequence_rec.subinventory_name := p_old_pull_sequence_rec.subinventory_name;
458: END IF;
459:
460: IF l_pull_sequence_rec.Kanban_plan_id = FND_API.G_MISS_NUM THEN

Line 460: IF l_pull_sequence_rec.Kanban_plan_id = FND_API.G_MISS_NUM THEN

456: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN
457: l_pull_sequence_rec.subinventory_name := p_old_pull_sequence_rec.subinventory_name;
458: END IF;
459:
460: IF l_pull_sequence_rec.Kanban_plan_id = FND_API.G_MISS_NUM THEN
461: l_pull_sequence_rec.Kanban_plan_id := p_old_pull_sequence_rec.Kanban_plan_id;
462: END IF;
463:
464: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN

Line 464: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN

460: IF l_pull_sequence_rec.Kanban_plan_id = FND_API.G_MISS_NUM THEN
461: l_pull_sequence_rec.Kanban_plan_id := p_old_pull_sequence_rec.Kanban_plan_id;
462: END IF;
463:
464: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN
465: l_pull_sequence_rec.source_type := p_old_pull_sequence_rec.source_type;
466: END IF;
467:
468: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 468: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN

464: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN
465: l_pull_sequence_rec.source_type := p_old_pull_sequence_rec.source_type;
466: END IF;
467:
468: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN
469: l_pull_sequence_rec.last_update_date := p_old_pull_sequence_rec.last_update_date;
470: END IF;
471:
472: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 472: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN

468: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN
469: l_pull_sequence_rec.last_update_date := p_old_pull_sequence_rec.last_update_date;
470: END IF;
471:
472: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN
473: l_pull_sequence_rec.last_updated_by := p_old_pull_sequence_rec.last_updated_by;
474: END IF;
475:
476: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 476: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN

472: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN
473: l_pull_sequence_rec.last_updated_by := p_old_pull_sequence_rec.last_updated_by;
474: END IF;
475:
476: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN
477: l_pull_sequence_rec.creation_date := p_old_pull_sequence_rec.creation_date;
478: END IF;
479:
480: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN

Line 480: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN

476: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN
477: l_pull_sequence_rec.creation_date := p_old_pull_sequence_rec.creation_date;
478: END IF;
479:
480: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN
481: l_pull_sequence_rec.created_by := p_old_pull_sequence_rec.created_by;
482: END IF;
483:
484: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN

Line 484: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN

480: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN
481: l_pull_sequence_rec.created_by := p_old_pull_sequence_rec.created_by;
482: END IF;
483:
484: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN
485: l_pull_sequence_rec.locator_id := p_old_pull_sequence_rec.locator_id;
486: END IF;
487:
488: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN

Line 488: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN

484: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN
485: l_pull_sequence_rec.locator_id := p_old_pull_sequence_rec.locator_id;
486: END IF;
487:
488: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN
489: l_pull_sequence_rec.supplier_id := p_old_pull_sequence_rec.supplier_id;
490: END IF;
491:
492: IF l_pull_sequence_rec.supplier_site_id = FND_API.G_MISS_NUM THEN

Line 492: IF l_pull_sequence_rec.supplier_site_id = FND_API.G_MISS_NUM THEN

488: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN
489: l_pull_sequence_rec.supplier_id := p_old_pull_sequence_rec.supplier_id;
490: END IF;
491:
492: IF l_pull_sequence_rec.supplier_site_id = FND_API.G_MISS_NUM THEN
493: l_pull_sequence_rec.supplier_site_id := p_old_pull_sequence_rec.supplier_site_id;
494: END IF;
495:
496: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN

Line 496: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN

492: IF l_pull_sequence_rec.supplier_site_id = FND_API.G_MISS_NUM THEN
493: l_pull_sequence_rec.supplier_site_id := p_old_pull_sequence_rec.supplier_site_id;
494: END IF;
495:
496: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN
497: l_pull_sequence_rec.source_organization_id := p_old_pull_sequence_rec.source_organization_id;
498: END IF;
499:
500: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN

Line 500: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN

496: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN
497: l_pull_sequence_rec.source_organization_id := p_old_pull_sequence_rec.source_organization_id;
498: END IF;
499:
500: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN
501: l_pull_sequence_rec.source_subinventory := p_old_pull_sequence_rec.source_subinventory;
502: END IF;
503:
504: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN

Line 504: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN

500: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN
501: l_pull_sequence_rec.source_subinventory := p_old_pull_sequence_rec.source_subinventory;
502: END IF;
503:
504: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN
505: l_pull_sequence_rec.source_locator_id := p_old_pull_sequence_rec.source_locator_id;
506: END IF;
507:
508: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN

Line 508: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN

504: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN
505: l_pull_sequence_rec.source_locator_id := p_old_pull_sequence_rec.source_locator_id;
506: END IF;
507:
508: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN
509: l_pull_sequence_rec.wip_line_id := p_old_pull_sequence_rec.wip_line_id;
510: END IF;
511:
512: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN

Line 512: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN

508: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN
509: l_pull_sequence_rec.wip_line_id := p_old_pull_sequence_rec.wip_line_id;
510: END IF;
511:
512: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN
513: l_pull_sequence_rec.replenishment_lead_time := p_old_pull_sequence_rec.replenishment_lead_time;
514: END IF;
515:
516: IF l_pull_sequence_rec.Release_Kanban_Flag = FND_API.G_MISS_NUM THEN

Line 516: IF l_pull_sequence_rec.Release_Kanban_Flag = FND_API.G_MISS_NUM THEN

512: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN
513: l_pull_sequence_rec.replenishment_lead_time := p_old_pull_sequence_rec.replenishment_lead_time;
514: END IF;
515:
516: IF l_pull_sequence_rec.Release_Kanban_Flag = FND_API.G_MISS_NUM THEN
517: l_pull_sequence_rec.Release_Kanban_Flag := p_old_pull_sequence_rec.Release_Kanban_Flag;
518:
519: END IF;
520: IF l_pull_sequence_rec.Calculate_Kanban_Flag = FND_API.G_MISS_NUM THEN

Line 520: IF l_pull_sequence_rec.Calculate_Kanban_Flag = FND_API.G_MISS_NUM THEN

516: IF l_pull_sequence_rec.Release_Kanban_Flag = FND_API.G_MISS_NUM THEN
517: l_pull_sequence_rec.Release_Kanban_Flag := p_old_pull_sequence_rec.Release_Kanban_Flag;
518:
519: END IF;
520: IF l_pull_sequence_rec.Calculate_Kanban_Flag = FND_API.G_MISS_NUM THEN
521: l_pull_sequence_rec.Calculate_Kanban_Flag := p_old_pull_sequence_rec.Calculate_Kanban_Flag;
522: END IF;
523:
524: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN

Line 524: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN

520: IF l_pull_sequence_rec.Calculate_Kanban_Flag = FND_API.G_MISS_NUM THEN
521: l_pull_sequence_rec.Calculate_Kanban_Flag := p_old_pull_sequence_rec.Calculate_Kanban_Flag;
522: END IF;
523:
524: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN
525: l_pull_sequence_rec.kanban_size := p_old_pull_sequence_rec.kanban_size;
526: END IF;
527:
528: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN

Line 528: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN

524: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN
525: l_pull_sequence_rec.kanban_size := p_old_pull_sequence_rec.kanban_size;
526: END IF;
527:
528: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN
529: l_pull_sequence_rec.fixed_lot_multiplier := p_old_pull_sequence_rec.fixed_lot_multiplier;
530: END IF;
531:
532: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN

Line 532: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN

528: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN
529: l_pull_sequence_rec.fixed_lot_multiplier := p_old_pull_sequence_rec.fixed_lot_multiplier;
530: END IF;
531:
532: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN
533: l_pull_sequence_rec.safety_stock_days := p_old_pull_sequence_rec.safety_stock_days;
534: END IF;
535:
536: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN

Line 536: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN

532: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN
533: l_pull_sequence_rec.safety_stock_days := p_old_pull_sequence_rec.safety_stock_days;
534: END IF;
535:
536: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN
537: l_pull_sequence_rec.number_of_cards := p_old_pull_sequence_rec.number_of_cards;
538: END IF;
539:
540: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN

Line 540: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN

536: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN
537: l_pull_sequence_rec.number_of_cards := p_old_pull_sequence_rec.number_of_cards;
538: END IF;
539:
540: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN
541: l_pull_sequence_rec.minimum_order_quantity := p_old_pull_sequence_rec.minimum_order_quantity;
542: END IF;
543:
544: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN

Line 544: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN

540: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN
541: l_pull_sequence_rec.minimum_order_quantity := p_old_pull_sequence_rec.minimum_order_quantity;
542: END IF;
543:
544: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN
545: l_pull_sequence_rec.aggregation_type := p_old_pull_sequence_rec.aggregation_type;
546: END IF;
547:
548: IF l_pull_sequence_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN

Line 548: IF l_pull_sequence_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN

544: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN
545: l_pull_sequence_rec.aggregation_type := p_old_pull_sequence_rec.aggregation_type;
546: END IF;
547:
548: IF l_pull_sequence_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN
549: l_pull_sequence_rec.Allocation_Percent := p_old_pull_sequence_rec.Allocation_Percent;
550: END IF;
551:
552: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 552: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN

548: IF l_pull_sequence_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN
549: l_pull_sequence_rec.Allocation_Percent := p_old_pull_sequence_rec.Allocation_Percent;
550: END IF;
551:
552: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
553: l_pull_sequence_rec.last_update_login := p_old_pull_sequence_rec.last_update_login;
554: END IF;
555:
556: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN

Line 556: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN

552: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
553: l_pull_sequence_rec.last_update_login := p_old_pull_sequence_rec.last_update_login;
554: END IF;
555:
556: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN
557: l_pull_sequence_rec.updated_flag := p_old_pull_sequence_rec.updated_flag;
558: END IF;
559:
560: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 560: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN

556: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN
557: l_pull_sequence_rec.updated_flag := p_old_pull_sequence_rec.updated_flag;
558: END IF;
559:
560: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN
561: l_pull_sequence_rec.attribute_category := p_old_pull_sequence_rec.attribute_category;
562: END IF;
563:
564: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 564: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN

560: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN
561: l_pull_sequence_rec.attribute_category := p_old_pull_sequence_rec.attribute_category;
562: END IF;
563:
564: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN
565: l_pull_sequence_rec.attribute1 := p_old_pull_sequence_rec.attribute1;
566: END IF;
567:
568: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 568: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN

564: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN
565: l_pull_sequence_rec.attribute1 := p_old_pull_sequence_rec.attribute1;
566: END IF;
567:
568: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN
569: l_pull_sequence_rec.attribute2 := p_old_pull_sequence_rec.attribute2;
570: END IF;
571:
572: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 572: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN

568: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN
569: l_pull_sequence_rec.attribute2 := p_old_pull_sequence_rec.attribute2;
570: END IF;
571:
572: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN
573: l_pull_sequence_rec.attribute3 := p_old_pull_sequence_rec.attribute3;
574: END IF;
575:
576: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 576: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN

572: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN
573: l_pull_sequence_rec.attribute3 := p_old_pull_sequence_rec.attribute3;
574: END IF;
575:
576: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN
577: l_pull_sequence_rec.attribute4 := p_old_pull_sequence_rec.attribute4;
578: END IF;
579:
580: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 580: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN

576: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN
577: l_pull_sequence_rec.attribute4 := p_old_pull_sequence_rec.attribute4;
578: END IF;
579:
580: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN
581: l_pull_sequence_rec.attribute5 := p_old_pull_sequence_rec.attribute5;
582: END IF;
583:
584: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 584: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN

580: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN
581: l_pull_sequence_rec.attribute5 := p_old_pull_sequence_rec.attribute5;
582: END IF;
583:
584: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN
585: l_pull_sequence_rec.attribute6 := p_old_pull_sequence_rec.attribute6;
586: END IF;
587:
588: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 588: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN

584: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN
585: l_pull_sequence_rec.attribute6 := p_old_pull_sequence_rec.attribute6;
586: END IF;
587:
588: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN
589: l_pull_sequence_rec.attribute7 := p_old_pull_sequence_rec.attribute7;
590: END IF;
591:
592: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 592: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN

588: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN
589: l_pull_sequence_rec.attribute7 := p_old_pull_sequence_rec.attribute7;
590: END IF;
591:
592: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN
593: l_pull_sequence_rec.attribute8 := p_old_pull_sequence_rec.attribute8;
594: END IF;
595:
596: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 596: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN

592: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN
593: l_pull_sequence_rec.attribute8 := p_old_pull_sequence_rec.attribute8;
594: END IF;
595:
596: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN
597: l_pull_sequence_rec.attribute9 := p_old_pull_sequence_rec.attribute9;
598: END IF;
599:
600: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 600: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN

596: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN
597: l_pull_sequence_rec.attribute9 := p_old_pull_sequence_rec.attribute9;
598: END IF;
599:
600: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN
601: l_pull_sequence_rec.attribute10 := p_old_pull_sequence_rec.attribute10;
602: END IF;
603:
604: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 604: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN

600: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN
601: l_pull_sequence_rec.attribute10 := p_old_pull_sequence_rec.attribute10;
602: END IF;
603:
604: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN
605: l_pull_sequence_rec.attribute11 := p_old_pull_sequence_rec.attribute11;
606: END IF;
607:
608: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 608: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN

604: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN
605: l_pull_sequence_rec.attribute11 := p_old_pull_sequence_rec.attribute11;
606: END IF;
607:
608: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN
609: l_pull_sequence_rec.attribute12 := p_old_pull_sequence_rec.attribute12;
610: END IF;
611:
612: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 612: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN

608: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN
609: l_pull_sequence_rec.attribute12 := p_old_pull_sequence_rec.attribute12;
610: END IF;
611:
612: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN
613: l_pull_sequence_rec.attribute13 := p_old_pull_sequence_rec.attribute13;
614: END IF;
615:
616: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 616: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN

612: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN
613: l_pull_sequence_rec.attribute13 := p_old_pull_sequence_rec.attribute13;
614: END IF;
615:
616: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN
617: l_pull_sequence_rec.attribute14 := p_old_pull_sequence_rec.attribute14;
618: END IF;
619:
620: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 620: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN

616: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN
617: l_pull_sequence_rec.attribute14 := p_old_pull_sequence_rec.attribute14;
618: END IF;
619:
620: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN
621: l_pull_sequence_rec.attribute15 := p_old_pull_sequence_rec.attribute15;
622: END IF;
623:
624: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN

Line 624: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN

620: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN
621: l_pull_sequence_rec.attribute15 := p_old_pull_sequence_rec.attribute15;
622: END IF;
623:
624: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN
625: l_pull_sequence_rec.request_id := p_old_pull_sequence_rec.request_id;
626: END IF;
627:
628: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 628: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN

624: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN
625: l_pull_sequence_rec.request_id := p_old_pull_sequence_rec.request_id;
626: END IF;
627:
628: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN
629: l_pull_sequence_rec.program_application_id := p_old_pull_sequence_rec.program_application_id;
630: END IF;
631:
632: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN

Line 632: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN

628: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN
629: l_pull_sequence_rec.program_application_id := p_old_pull_sequence_rec.program_application_id;
630: END IF;
631:
632: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN
633: l_pull_sequence_rec.program_id := p_old_pull_sequence_rec.program_id;
634: END IF;
635:
636: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 636: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN

632: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN
633: l_pull_sequence_rec.program_id := p_old_pull_sequence_rec.program_id;
634: END IF;
635:
636: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN
637: l_pull_sequence_rec.program_update_date := p_old_pull_sequence_rec.program_update_date;
638: END IF;
639:
640: IF l_pull_sequence_rec.point_of_use_x = FND_API.G_MISS_NUM THEN

Line 640: IF l_pull_sequence_rec.point_of_use_x = FND_API.G_MISS_NUM THEN

636: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN
637: l_pull_sequence_rec.program_update_date := p_old_pull_sequence_rec.program_update_date;
638: END IF;
639:
640: IF l_pull_sequence_rec.point_of_use_x = FND_API.G_MISS_NUM THEN
641: l_pull_sequence_rec.point_of_use_x := p_old_pull_sequence_rec.point_of_use_x;
642: END IF;
643:
644: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN

Line 644: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN

640: IF l_pull_sequence_rec.point_of_use_x = FND_API.G_MISS_NUM THEN
641: l_pull_sequence_rec.point_of_use_x := p_old_pull_sequence_rec.point_of_use_x;
642: END IF;
643:
644: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN
645: l_pull_sequence_rec.point_of_use_y := p_old_pull_sequence_rec.point_of_use_y;
646: END IF;
647:
648: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN

Line 648: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN

644: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN
645: l_pull_sequence_rec.point_of_use_y := p_old_pull_sequence_rec.point_of_use_y;
646: END IF;
647:
648: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN
649: l_pull_sequence_rec.point_of_supply_x := p_old_pull_sequence_rec.point_of_supply_x;
650: END IF;
651:
652: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN

Line 652: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN

648: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN
649: l_pull_sequence_rec.point_of_supply_x := p_old_pull_sequence_rec.point_of_supply_x;
650: END IF;
651:
652: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN
653: l_pull_sequence_rec.point_of_supply_y := p_old_pull_sequence_rec.point_of_supply_y;
654: END IF;
655:
656: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN

Line 656: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN

652: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN
653: l_pull_sequence_rec.point_of_supply_y := p_old_pull_sequence_rec.point_of_supply_y;
654: END IF;
655:
656: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN
657: l_pull_sequence_rec.planning_update_status := p_old_pull_sequence_rec.planning_update_status;
658: END IF;
659:
660: IF l_pull_sequence_rec.auto_request = FND_API.G_MISS_CHAR THEN

Line 660: IF l_pull_sequence_rec.auto_request = FND_API.G_MISS_CHAR THEN

656: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN
657: l_pull_sequence_rec.planning_update_status := p_old_pull_sequence_rec.planning_update_status;
658: END IF;
659:
660: IF l_pull_sequence_rec.auto_request = FND_API.G_MISS_CHAR THEN
661: l_pull_sequence_rec.auto_request := p_old_pull_sequence_rec.auto_request;
662: END IF;
663:
664: /*Added the following IF statement for 3905884.*/

Line 665: IF l_pull_sequence_rec.auto_allocate_flag = FND_API.G_MISS_NUM THEN

661: l_pull_sequence_rec.auto_request := p_old_pull_sequence_rec.auto_request;
662: END IF;
663:
664: /*Added the following IF statement for 3905884.*/
665: IF l_pull_sequence_rec.auto_allocate_flag = FND_API.G_MISS_NUM THEN
666: l_pull_sequence_rec.auto_allocate_flag := p_old_pull_sequence_rec.auto_allocate_flag;
667: END IF;
668:
669: RETURN l_pull_sequence_rec;

Line 732: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;

728: p_auto_request VARCHAR2 DEFAULT NULL,
729: p_Auto_Allocate_Flag NUMBER ) --Bug3905884
730: is
731: l_pull_sequence_Id MTL_Kanban_Pull_Sequences.Pull_Sequence_Id%Type;
732: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
733: BEGIN
734: FND_MSG_PUB.Initialize;
735: If nvl(p_Pull_sequence_Id,0) <= 0
736: Then

Line 866: WHEN FND_API.G_EXC_ERROR THEN

862: p_pull_sequence_id := l_Pull_Sequence_id;
863:
864: x_return_status := l_return_status;
865: EXCEPTION
866: WHEN FND_API.G_EXC_ERROR THEN
867:
868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 868: x_return_status := FND_API.G_RET_STS_ERROR;

864: x_return_status := l_return_status;
865: EXCEPTION
866: WHEN FND_API.G_EXC_ERROR THEN
867:
868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871:
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

866: WHEN FND_API.G_EXC_ERROR THEN
867:
868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871:
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873:
874: WHEN OTHERS THEN

Line 872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871:
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873:
874: WHEN OTHERS THEN
875: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
876: THEN

Line 883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

879: , 'Insert_Row'
880: );
881: END IF;
882:
883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
884:
885: End Insert_Row;
886:
887: Procedure Insert_Row(p_pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type)

Line 953: if l_return_status = FND_API.G_RET_STS_ERROR

949: p_point_of_supply_y =>l_Pull_sequence_Rec.point_of_supply_y,
950: p_planning_update_status=>l_Pull_sequence_Rec.planning_update_status,
951: p_auto_request =>l_Pull_sequence_Rec.auto_request,
952: p_Auto_Allocate_Flag =>l_Pull_sequence_Rec.Auto_Allocate_Flag); --Added for 3905884.
953: if l_return_status = FND_API.G_RET_STS_ERROR
954: Then
955: Raise FND_API.G_EXC_ERROR;
956: End if;
957:

Line 955: Raise FND_API.G_EXC_ERROR;

951: p_auto_request =>l_Pull_sequence_Rec.auto_request,
952: p_Auto_Allocate_Flag =>l_Pull_sequence_Rec.Auto_Allocate_Flag); --Added for 3905884.
953: if l_return_status = FND_API.G_RET_STS_ERROR
954: Then
955: Raise FND_API.G_EXC_ERROR;
956: End if;
957:
958: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
959: Then

Line 958: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

954: Then
955: Raise FND_API.G_EXC_ERROR;
956: End if;
957:
958: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
959: Then
960: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
961: End If;
962:

Line 960: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

956: End if;
957:
958: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
959: Then
960: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
961: End If;
962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN

Line 964: WHEN FND_API.G_EXC_ERROR THEN

960: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
961: End If;
962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN
965:
966: Raise FND_API.G_EXC_ERROR;
967:
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 966: Raise FND_API.G_EXC_ERROR;

962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN
965:
966: Raise FND_API.G_EXC_ERROR;
967:
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
969:
970: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

964: WHEN FND_API.G_EXC_ERROR THEN
965:
966: Raise FND_API.G_EXC_ERROR;
967:
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
969:
970: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
971:
972: WHEN OTHERS THEN

Line 970: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

966: Raise FND_API.G_EXC_ERROR;
967:
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
969:
970: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
971:
972: WHEN OTHERS THEN
973:
974: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 982: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

978: , 'Insert_Row'
979: );
980: END IF;
981:
982: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
983:
984: End Insert_Row;
985:
986: PROCEDURE Lock_Row (p_Pull_Sequence_Id NUMBER,

Line 1239: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

1235: p_auto_request VARCHAR2 DEFAULT NULL,
1236: p_Auto_Allocate_Flag NUMBER ) --Added for 3905884
1237: IS
1238:
1239: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1240:
1241: BEGIN
1242: FND_MSG_PUB.Initialize;
1243: UPDATE MTL_KANBAN_PULL_SEQUENCES

Line 1305: WHEN FND_API.G_EXC_ERROR THEN

1301: x_return_status := l_return_status;
1302:
1303: EXCEPTION
1304:
1305: WHEN FND_API.G_EXC_ERROR THEN
1306:
1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308:
1309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1307: x_return_status := FND_API.G_RET_STS_ERROR;

1303: EXCEPTION
1304:
1305: WHEN FND_API.G_EXC_ERROR THEN
1306:
1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308:
1309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1310:
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1305: WHEN FND_API.G_EXC_ERROR THEN
1306:
1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308:
1309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1310:
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1312:
1313: WHEN OTHERS THEN

Line 1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308:
1309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1310:
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1312:
1313: WHEN OTHERS THEN
1314:
1315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1319: , 'Update_Row'
1320: );
1321: END IF;
1322:
1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1324:
1325: END Update_Row;
1326:
1327: PROCEDURE Update_Row(

Line 1390: if l_return_status = FND_API.G_RET_STS_ERROR

1386: p_planning_update_status =>p_Pull_sequence_Rec.planning_update_status,
1387: p_auto_request =>p_Pull_sequence_Rec.auto_request,
1388: p_Auto_Allocate_Flag =>p_Pull_sequence_Rec.Auto_Allocate_Flag ); --Added for 3905884.
1389:
1390: if l_return_status = FND_API.G_RET_STS_ERROR
1391: Then
1392: Raise FND_API.G_EXC_ERROR;
1393: End if;
1394:

Line 1392: Raise FND_API.G_EXC_ERROR;

1388: p_Auto_Allocate_Flag =>p_Pull_sequence_Rec.Auto_Allocate_Flag ); --Added for 3905884.
1389:
1390: if l_return_status = FND_API.G_RET_STS_ERROR
1391: Then
1392: Raise FND_API.G_EXC_ERROR;
1393: End if;
1394:
1395: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1396: Then

Line 1395: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1391: Then
1392: Raise FND_API.G_EXC_ERROR;
1393: End if;
1394:
1395: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1396: Then
1397: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1398: End If;
1399:

Line 1397: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1393: End if;
1394:
1395: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1396: Then
1397: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1398: End If;
1399:
1400: EXCEPTION
1401:

Line 1402: WHEN FND_API.G_EXC_ERROR THEN

1398: End If;
1399:
1400: EXCEPTION
1401:
1402: WHEN FND_API.G_EXC_ERROR THEN
1403:
1404: Raise FND_API.G_EXC_ERROR;
1405:
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1404: Raise FND_API.G_EXC_ERROR;

1400: EXCEPTION
1401:
1402: WHEN FND_API.G_EXC_ERROR THEN
1403:
1404: Raise FND_API.G_EXC_ERROR;
1405:
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407:
1408: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1402: WHEN FND_API.G_EXC_ERROR THEN
1403:
1404: Raise FND_API.G_EXC_ERROR;
1405:
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407:
1408: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1409:
1410: WHEN OTHERS THEN

Line 1408: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1404: Raise FND_API.G_EXC_ERROR;
1405:
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407:
1408: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1409:
1410: WHEN OTHERS THEN
1411:
1412: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1419: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1415: ( G_PKG_NAME
1416: , 'Update_Row'
1417: );
1418: END IF;
1419: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1420:
1421: END Update_Row;
1422:
1423: PROCEDURE Delete_Row(x_return_status OUT NOCOPY VARCHAR2,

Line 1426: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR;

1422:
1423: PROCEDURE Delete_Row(x_return_status OUT NOCOPY VARCHAR2,
1424: p_Pull_Sequence_Id Number)
1425: IS
1426: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR;
1427:
1428: BEGIN
1429: FND_MSG_PUB.Initialize;
1430: if INV_Kanban_PVT.Ok_To_Delete_Pull_Sequence(p_pull_sequence_Id)

Line 1437: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1433: DELETE FROM MTL_KANBAN_PULL_SEQUENCES
1434: WHERE pull_sequence_id = p_pull_sequence_id;
1435:
1436: if (SQL%NOTFOUND) then
1437: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1438: else
1439: l_return_status := FND_API.G_RET_STS_SUCCESS;
1440: end if;
1441: else

Line 1439: l_return_status := FND_API.G_RET_STS_SUCCESS;

1435:
1436: if (SQL%NOTFOUND) then
1437: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1438: else
1439: l_return_status := FND_API.G_RET_STS_SUCCESS;
1440: end if;
1441: else
1442: Raise FND_API.G_EXC_ERROR;
1443: end if;

Line 1442: Raise FND_API.G_EXC_ERROR;

1438: else
1439: l_return_status := FND_API.G_RET_STS_SUCCESS;
1440: end if;
1441: else
1442: Raise FND_API.G_EXC_ERROR;
1443: end if;
1444:
1445: x_return_status := l_return_status;
1446:

Line 1448: WHEN FND_API.G_EXC_ERROR THEN

1444:
1445: x_return_status := l_return_status;
1446:
1447: EXCEPTION
1448: WHEN FND_API.G_EXC_ERROR THEN
1449:
1450: x_return_status := FND_API.G_RET_STS_ERROR;
1451:
1452: WHEN OTHERS THEN

Line 1450: x_return_status := FND_API.G_RET_STS_ERROR;

1446:
1447: EXCEPTION
1448: WHEN FND_API.G_EXC_ERROR THEN
1449:
1450: x_return_status := FND_API.G_RET_STS_ERROR;
1451:
1452: WHEN OTHERS THEN
1453:
1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1450: x_return_status := FND_API.G_RET_STS_ERROR;
1451:
1452: WHEN OTHERS THEN
1453:
1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1455: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1456: THEN
1457: FND_MSG_PUB.Add_Exc_Msg
1458: ( G_PKG_NAME