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_PICK_WAVE_PICK_CONFIRM_PUB dependencies on FND_API

Line 18: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

14:
15: PROCEDURE Pick_Confirm
16: (
17: p_api_version_number IN NUMBER
18: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
19: , p_commit IN VARCHAR2 := FND_API.G_FALSE
20: , x_return_status OUT NOCOPY VARCHAR2
21: , x_msg_count OUT NOCOPY NUMBER
22: , x_msg_data OUT NOCOPY VARCHAR2

Line 19: , p_commit IN VARCHAR2 := FND_API.G_FALSE

15: PROCEDURE Pick_Confirm
16: (
17: p_api_version_number IN NUMBER
18: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
19: , p_commit IN VARCHAR2 := FND_API.G_FALSE
20: , x_return_status OUT NOCOPY VARCHAR2
21: , x_msg_count OUT NOCOPY NUMBER
22: , x_msg_data OUT NOCOPY VARCHAR2
23: , p_move_order_type IN NUMBER

Line 82: IF NOT FND_API.Compatible_API_Call

78: -- Standard call to check for call compatibility
79: IF (l_debug = 1) THEN
80: TraceLog('Inside pick_wave_pick_confirm', 'Pick_confirm');
81: END IF;
82: IF NOT FND_API.Compatible_API_Call
83: ( l_api_version_number
84: , p_api_version_number
85: , l_api_name
86: , G_PKG_NAME

Line 89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

85: , l_api_name
86: , G_PKG_NAME
87: )
88: THEN
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END IF;
91:
92: l_return_status := FND_API.G_RET_STS_SUCCESS;
93:

Line 92: l_return_status := FND_API.G_RET_STS_SUCCESS;

88: THEN
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END IF;
91:
92: l_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: -- bug 2307057 Initialize message list if p_init_msg_list is set to TRUE.
95: IF FND_API.to_Boolean( p_init_msg_list ) THEN
96: FND_MSG_PUB.initialize;

Line 95: IF FND_API.to_Boolean( p_init_msg_list ) THEN

91:
92: l_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: -- bug 2307057 Initialize message list if p_init_msg_list is set to TRUE.
95: IF FND_API.to_Boolean( p_init_msg_list ) THEN
96: FND_MSG_PUB.initialize;
97: END IF;
98:
99:

Line 111: l_return_status := FND_API.G_RET_STS_ERROR;

107: if( l_trolin_tbl.count = 0 AND l_mold_tbl.count = 0) then
108:
109: FND_MESSAGE.SET_NAME('INV', 'INV_NO_LINES_TO_PICK_CONFIRM');
110: FND_MSG_PUB.add;
111: l_return_status := FND_API.G_RET_STS_ERROR;
112: raise FND_API.G_EXC_ERROR;
113: end if;
114:
115: select mtl_material_transactions_s.nextval

Line 112: raise FND_API.G_EXC_ERROR;

108:
109: FND_MESSAGE.SET_NAME('INV', 'INV_NO_LINES_TO_PICK_CONFIRM');
110: FND_MSG_PUB.add;
111: l_return_status := FND_API.G_RET_STS_ERROR;
112: raise FND_API.G_EXC_ERROR;
113: end if;
114:
115: select mtl_material_transactions_s.nextval
116: into l_transaction_header_id

Line 133: IF (l_trolin_tbl(i).return_status <> FND_API.G_RET_STS_UNEXP_ERROR and

129: IF (l_debug = 1) THEN
130: TraceLog('mo line_id is = ' || l_trolin_tbl(i).line_id, 'Pick_Confirm');
131: END IF;
132: -- only process the valid move order, fix bug 1540709.
133: IF (l_trolin_tbl(i).return_status <> FND_API.G_RET_STS_UNEXP_ERROR and
134: l_trolin_tbl(i).return_status <> FND_API.G_RET_STS_ERROR) THEN
135:
136: --if( l_trolin_tbl(i) is not null ) then
137: l_trolin_rec := INV_Trolin_Util.Query_Row(l_trolin_tbl(i).line_id);

Line 134: l_trolin_tbl(i).return_status <> FND_API.G_RET_STS_ERROR) THEN

130: TraceLog('mo line_id is = ' || l_trolin_tbl(i).line_id, 'Pick_Confirm');
131: END IF;
132: -- only process the valid move order, fix bug 1540709.
133: IF (l_trolin_tbl(i).return_status <> FND_API.G_RET_STS_UNEXP_ERROR and
134: l_trolin_tbl(i).return_status <> FND_API.G_RET_STS_ERROR) THEN
135:
136: --if( l_trolin_tbl(i) is not null ) then
137: l_trolin_rec := INV_Trolin_Util.Query_Row(l_trolin_tbl(i).line_id);
138: l_trolin_tbl(i) := l_trolin_rec;

Line 149: --raise FND_API.G_EXC_ERROR;

145: if( L_qty_detailed = l_qty_delivered OR l_qty_detailed = 0 ) then
146: FND_MESSAGE.SET_NAME('INV', 'INV_PICK_QTY_ERROR');
147: FND_MSG_PUB.ADD;
148: --rollback to TO_TRX_LINE_SAVE;
149: --raise FND_API.G_EXC_ERROR;
150: else
151: l_mold_tbl := INV_MO_LINE_DETAIL_UTIL.Query_Rows( p_line_id => l_trolin_tbl(i).line_id);
152: IF (l_debug = 1) THEN
153: TraceLog('mold records = ' || l_mold_tbl.count, 'Pick_Confirm');

Line 180: raise FND_API.G_EXC_ERROR;

176: IF p_transaction_date > sysdate THEN
177: TraceLog('Error: Transaction date cannot be a future date', 'Pick_confirm');
178: FND_MESSAGE.SET_NAME('INV', 'INV_INT_TDATEEX');
179: FND_MSG_PUB.add;
180: raise FND_API.G_EXC_ERROR;
181: END IF;
182: l_mold_tbl(j).transaction_date := p_transaction_date;
183: END IF;
184:

Line 200: l_return_status := FND_API.G_RET_STS_ERROR;

196: TraceLog('l_period_id: '||l_period_id, 'Pick_confirm');
197: IF (l_period_id = -1 or l_period_id = 0) THEN
198: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
199: FND_MSG_PUB.add;
200: l_return_status := FND_API.G_RET_STS_ERROR;
201: raise FND_API.G_EXC_ERROR;
202: END IF;
203:
204: END IF;

Line 201: raise FND_API.G_EXC_ERROR;

197: IF (l_period_id = -1 or l_period_id = 0) THEN
198: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
199: FND_MSG_PUB.add;
200: l_return_status := FND_API.G_RET_STS_ERROR;
201: raise FND_API.G_EXC_ERROR;
202: END IF;
203:
204: END IF;
205: l_mold_tbl(j).acct_period_id := l_period_id;

Line 226: if( l_return_status = FND_API.G_RET_STS_ERROR ) then

222: inv_mo_line_detail_util.update_row(l_return_status, l_mold_tbl(j));
223: IF (l_debug = 1) THEN
224: TraceLog('after update transaction_status = 3', 'Pick_Confirm');
225: END IF;
226: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
227: fnd_message.set_name('INV', 'INV_COULD_NOT_UPATE_RECORD');
228: fnd_msg_pub.add;
229: IF (l_debug = 1) THEN
230: TraceLog('error in update mold', 'Pick_Confirm');

Line 233: raise FND_API.G_EXC_ERROR;

229: IF (l_debug = 1) THEN
230: TraceLog('error in update mold', 'Pick_Confirm');
231: END IF;
232: rollback to TO_TRX_LINE_SAVE;
233: raise FND_API.G_EXC_ERROR;
234: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
235: IF (l_debug = 1) THEN
236: TraceLog('error in update mold', 'Pick_Confirm');
237: END IF;

Line 234: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

230: TraceLog('error in update mold', 'Pick_Confirm');
231: END IF;
232: rollback to TO_TRX_LINE_SAVE;
233: raise FND_API.G_EXC_ERROR;
234: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
235: IF (l_debug = 1) THEN
236: TraceLog('error in update mold', 'Pick_Confirm');
237: END IF;
238: fnd_message.set_name('INV', 'INV_COULD_NOT_UPATE_RECORD');

Line 241: raise FND_API.G_EXC_UNEXPECTED_ERROR;

237: END IF;
238: fnd_message.set_name('INV', 'INV_COULD_NOT_UPATE_RECORD');
239: fnd_msg_pub.add;
240: rollback to TO_TRX_LINE_SAVE;
241: raise FND_API.G_EXC_UNEXPECTED_ERROR;
242: end if;
243: IF (l_debug = 1) THEN
244: TraceLog('end of loop of mold, still inside loop', 'Pick Confirm');
245: END IF;

Line 292: raise FND_API.G_EXC_ERROR;

288: if( l_qty_detailed = l_qty_delivered OR l_qty_detailed = 0 ) then
289: FND_MESSAGE.SET_NAME('INV', 'INV_PICK_QTY_ERROR');
290: FND_MSG_PUB.ADD;
291: rollback to TO_TRX_LINE_SAVE;
292: raise FND_API.G_EXC_ERROR;
293: end if;
294: l_mold_tbl(j).transaction_status := 3;
295: l_mold_tbl(j).transaction_mode := p_transaction_mode;
296: l_mold_tbl(j).transaction_header_id := l_transaction_header_id;

Line 312: raise FND_API.G_EXC_ERROR;

308: IF p_transaction_date > sysdate THEN
309: TraceLog('Error: Transaction date cannot be a future date', 'Pick_confirm');
310: FND_MESSAGE.SET_NAME('INV', 'INV_INT_TDATEEX');
311: FND_MSG_PUB.add;
312: raise FND_API.G_EXC_ERROR;
313: END IF;
314: l_mold_tbl(j).transaction_date := p_transaction_date;
315: END IF;
316:

Line 330: l_return_status := FND_API.G_RET_STS_ERROR;

326: TraceLog('l_period_id: '||l_period_id, 'Pick_confirm');
327: IF (l_period_id = -1 or l_period_id = 0) THEN
328: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
329: FND_MSG_PUB.add;
330: l_return_status := FND_API.G_RET_STS_ERROR;
331: raise FND_API.G_EXC_ERROR;
332: END IF;
333:
334: END IF;

Line 331: raise FND_API.G_EXC_ERROR;

327: IF (l_period_id = -1 or l_period_id = 0) THEN
328: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
329: FND_MSG_PUB.add;
330: l_return_status := FND_API.G_RET_STS_ERROR;
331: raise FND_API.G_EXC_ERROR;
332: END IF;
333:
334: END IF;
335:

Line 343: if( l_return_status = FND_API.G_RET_STS_ERROR ) then

339: inv_mo_line_detail_util.update_row(l_return_status, l_mold_tbl(j));
340: IF (l_debug = 1) THEN
341: TraceLog('after update transaction_status = 3', 'Pick_Confirm');
342: END IF;
343: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
344: IF (l_debug = 1) THEN
345: TraceLog('error in update mold', 'Pick_Confirm');
346: END IF;
347: fnd_message.set_name('INV', 'INV_COULD_NOT_UPATE_RECORD');

Line 350: raise FND_API.G_EXC_ERROR;

346: END IF;
347: fnd_message.set_name('INV', 'INV_COULD_NOT_UPATE_RECORD');
348: fnd_msg_pub.add;
349: rollback to TO_TRX_LINE_SAVE;
350: raise FND_API.G_EXC_ERROR;
351: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
352: IF (l_debug = 1) THEN
353: TraceLog('error in update mold', 'Pick_Confirm');
354: END IF;

Line 351: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

347: fnd_message.set_name('INV', 'INV_COULD_NOT_UPATE_RECORD');
348: fnd_msg_pub.add;
349: rollback to TO_TRX_LINE_SAVE;
350: raise FND_API.G_EXC_ERROR;
351: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
352: IF (l_debug = 1) THEN
353: TraceLog('error in update mold', 'Pick_Confirm');
354: END IF;
355: fnd_message.set_name('INV', 'INV_COULD_NOT_UPATE_RECORD');

Line 358: raise FND_API.G_EXC_UNEXPECTED_ERROR;

354: END IF;
355: fnd_message.set_name('INV', 'INV_COULD_NOT_UPATE_RECORD');
356: fnd_msg_pub.add;
357: rollback to TO_TRX_LINE_SAVE;
358: raise FND_API.G_EXC_UNEXPECTED_ERROR;
359: end if;
360: l_trolin_tbl(1).transaction_header_id :=
361: l_transaction_header_id;
362:

Line 409: raise FND_API.G_EXC_ERROR;

405: END IF;
406: rollback to TO_TRX_LINE_SAVE;
407: FND_Message.Set_Name('INV','INV_ORPHAN_CLEANUP_ERROR');
408: FND_MSG_PUB.add;
409: raise FND_API.G_EXC_ERROR;
410: ELSIF ( lot_success = '-2' ) THEN
411: IF (l_debug = 1) THEN
412: TraceLog('lot success= -2', 'Pick_Confirm');
413: END IF;

Line 417: raise FND_API.G_EXC_ERROR;

413: END IF;
414: rollback to TO_TRX_LINE_SAVE;
415: FND_Message.Set_Name('INV', 'INV_LOTNULL_ERROR');
416: FND_MSG_PUB.add;
417: raise FND_API.G_EXC_ERROR;
418: ELSIF ( lot_success = '-3' ) THEN
419: IF (l_debug = 1) THEN
420: TraceLog('lot success= -3', 'Pick_Confirm');
421: END IF;

Line 425: raise FND_API.G_EXC_ERROR;

421: END IF;
422: rollback to TO_TRX_LINE_SAVE;
423: FND_Message.Set_Name('INV', 'INV_LOTCOPY_ERROR');
424: FND_MSG_PUB.add;
425: raise FND_API.G_EXC_ERROR;
426: ELSIF ( lot_success = '-4' ) THEN
427: IF (l_debug = 1) THEN
428: TraceLog('lot success= -4', 'Pick_Confirm');
429: END IF;

Line 433: raise FND_API.G_EXC_ERROR;

429: END IF;
430: rollback to TO_TRX_LINE_SAVE;
431: FND_Message.Set_Name('INV', 'INV_DYNAMIC_SERIAL_ERROR');
432: FND_MSG_PUB.Add;
433: raise FND_API.G_EXC_ERROR;
434: END IF;
435:
436: /* Bug 1620487 - Performance
437: We no longer need to call do_check, since we lock the quantity

Line 442: p_init_msg_lst => FND_API.G_FALSE,

438: Tree during pick release. This was causing a huge performance hit.
439: INV_Quantity_Tree_Pub.Do_Check
440: (
441: p_api_version_number => 1.0,
442: p_init_msg_lst => FND_API.G_FALSE,
443: x_return_status => l_return_status,
444: x_msg_count => l_msg_count,
445: x_msg_data => l_msg_data,
446: x_no_violation => l_no_violation

Line 452: if( l_return_status = FND_API.G_RET_STS_ERROR ) then

448:
449: IF (l_debug = 1) THEN
450: TraceLog('after quantity_tree.do_check', 'Pick_Confirm');
451: END IF;
452: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
453: rollback to TO_TRX_LINE_SAVE;
454: raise FND_API.G_EXC_ERROR;
455: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
456: rollback to TO_TRX_LINE_SAVE;

Line 454: raise FND_API.G_EXC_ERROR;

450: TraceLog('after quantity_tree.do_check', 'Pick_Confirm');
451: END IF;
452: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
453: rollback to TO_TRX_LINE_SAVE;
454: raise FND_API.G_EXC_ERROR;
455: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
456: rollback to TO_TRX_LINE_SAVE;
457: raise FND_API.G_EXC_UNEXPECTED_ERROR;
458: end if;

Line 455: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

451: END IF;
452: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
453: rollback to TO_TRX_LINE_SAVE;
454: raise FND_API.G_EXC_ERROR;
455: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
456: rollback to TO_TRX_LINE_SAVE;
457: raise FND_API.G_EXC_UNEXPECTED_ERROR;
458: end if;
459: */

Line 457: raise FND_API.G_EXC_UNEXPECTED_ERROR;

453: rollback to TO_TRX_LINE_SAVE;
454: raise FND_API.G_EXC_ERROR;
455: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
456: rollback to TO_TRX_LINE_SAVE;
457: raise FND_API.G_EXC_UNEXPECTED_ERROR;
458: end if;
459: */
460: IF (P_MOVE_ORDER_TYPE <> 5 OR P_MOVE_ORDER_TYPE is null) then
461: -- Calling new Java transaction manager instread of pro C version

Line 484: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

480: END IF;
481: END IF;
482: FND_MESSAGE.SET_NAME('INV', 'INV_TM_TIME_OUT');
483: FND_MSG_PUB.ADD;
484: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: raise FND_API.G_EXC_UNEXPECTED_ERROR;
486: elsif l_rc_field = 2 then
487: IF (l_debug = 1) THEN
488: IF (l_debug = 1) THEN

Line 485: raise FND_API.G_EXC_UNEXPECTED_ERROR;

481: END IF;
482: FND_MESSAGE.SET_NAME('INV', 'INV_TM_TIME_OUT');
483: FND_MSG_PUB.ADD;
484: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: raise FND_API.G_EXC_UNEXPECTED_ERROR;
486: elsif l_rc_field = 2 then
487: IF (l_debug = 1) THEN
488: IF (l_debug = 1) THEN
489: TraceLog('l_rc_field = ' || l_rc_field);

Line 494: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

490: END IF;
491: END IF;
492: FND_MESSAGE.SET_NAME('INV', 'INV_TM_MGR_NOT_AVAIL');
493: FND_MSG_PUB.ADD;
494: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
496: elsif l_rc_field <> 0 then
497: IF (l_debug = 1) THEN
498: IF (l_debug = 1) THEN

Line 495: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

491: END IF;
492: FND_MESSAGE.SET_NAME('INV', 'INV_TM_MGR_NOT_AVAIL');
493: FND_MSG_PUB.ADD;
494: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
496: elsif l_rc_field <> 0 then
497: IF (l_debug = 1) THEN
498: IF (l_debug = 1) THEN
499: TraceLog('l_rc_field = ' || l_rc_field);

Line 502: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

498: IF (l_debug = 1) THEN
499: TraceLog('l_rc_field = ' || l_rc_field);
500: END IF;
501: END IF;
502: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
503: end if; */
504: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
505: else
506: IF (l_debug = 1) THEN

Line 504: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

500: END IF;
501: END IF;
502: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
503: end if; */
504: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
505: else
506: IF (l_debug = 1) THEN
507: IF (l_debug = 1) THEN
508: TraceLog('Success from inv_trx_mgr.process_trx_batch', 'Pick_Confirm');

Line 511: x_return_status := FND_API.G_RET_STS_SUCCESS;

507: IF (l_debug = 1) THEN
508: TraceLog('Success from inv_trx_mgr.process_trx_batch', 'Pick_Confirm');
509: END IF;
510: END IF;
511: x_return_status := FND_API.G_RET_STS_SUCCESS;
512: end if;
513: ELSE
514: l_program := 'INXTPU';
515: l_func := l_program;

Line 535: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

531: /*if( l_rc_field = 1) then
532: TraceLog('l_rc_field = ' || l_rc_field);
533: FND_MESSAGE.SET_NAME('INV', 'INV_TM_TIME_OUT');
534: FND_MSG_PUB.ADD;
535: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: raise FND_API.G_EXC_UNEXPECTED_ERROR;
537: elsif l_rc_field = 2 then
538: TraceLog('l_rc_field = ' || l_rc_field);
539: FND_MESSAGE.SET_NAME('INV', 'INV_TM_MGR_NOT_AVAIL');

Line 536: raise FND_API.G_EXC_UNEXPECTED_ERROR;

532: TraceLog('l_rc_field = ' || l_rc_field);
533: FND_MESSAGE.SET_NAME('INV', 'INV_TM_TIME_OUT');
534: FND_MSG_PUB.ADD;
535: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: raise FND_API.G_EXC_UNEXPECTED_ERROR;
537: elsif l_rc_field = 2 then
538: TraceLog('l_rc_field = ' || l_rc_field);
539: FND_MESSAGE.SET_NAME('INV', 'INV_TM_MGR_NOT_AVAIL');
540: FND_MSG_PUB.ADD;

Line 541: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

537: elsif l_rc_field = 2 then
538: TraceLog('l_rc_field = ' || l_rc_field);
539: FND_MESSAGE.SET_NAME('INV', 'INV_TM_MGR_NOT_AVAIL');
540: FND_MSG_PUB.ADD;
541: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
542: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
543: elsif l_rc_field <> 0 then
544: TraceLog('l_rc_field = ' || l_rc_field);
545: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

Line 542: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

538: TraceLog('l_rc_field = ' || l_rc_field);
539: FND_MESSAGE.SET_NAME('INV', 'INV_TM_MGR_NOT_AVAIL');
540: FND_MSG_PUB.ADD;
541: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
542: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
543: elsif l_rc_field <> 0 then
544: TraceLog('l_rc_field = ' || l_rc_field);
545: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
546: end if;*/

Line 545: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

541: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
542: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
543: elsif l_rc_field <> 0 then
544: TraceLog('l_rc_field = ' || l_rc_field);
545: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
546: end if;*/
547: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
548: else
549: TraceLog('Success from Old INVTM', 'Pick_Confirm');

Line 547: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

543: elsif l_rc_field <> 0 then
544: TraceLog('l_rc_field = ' || l_rc_field);
545: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
546: end if;*/
547: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
548: else
549: TraceLog('Success from Old INVTM', 'Pick_Confirm');
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551: end if;

Line 550: x_return_status := FND_API.G_RET_STS_SUCCESS;

546: end if;*/
547: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
548: else
549: TraceLog('Success from Old INVTM', 'Pick_Confirm');
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551: end if;
552: END IF; --Call Old tm for WIP Picking records
553:
554: -- Insert_Row.Clear_Orphan_Lots_Serials(l_transaction_header_id,-999);

Line 609: x_return_status := FND_API.G_RET_STS_ERROR;

605:
606: EXCEPTION
607: WHEN OTHERS then
608: -- TraceLog('error in cleanup orphan lot serial');
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: rollback to TO_TRX_LINE_SAVE;
611: FND_MESSAGE.SET_NAME('INV', 'INV_ORPHAN_CLEANUP_ERROR');
612: FND_MSG_PUB.ADD;
613: END;

Line 614: if( p_commit = FND_API.G_TRUE ) then

610: rollback to TO_TRX_LINE_SAVE;
611: FND_MESSAGE.SET_NAME('INV', 'INV_ORPHAN_CLEANUP_ERROR');
612: FND_MSG_PUB.ADD;
613: END;
614: if( p_commit = FND_API.G_TRUE ) then
615: commit;
616: end if;
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618: EXCEPTION

Line 617: x_return_status := FND_API.G_RET_STS_SUCCESS;

613: END;
614: if( p_commit = FND_API.G_TRUE ) then
615: commit;
616: end if;
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618: EXCEPTION
619: WHEN FND_API.G_EXC_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: -- Get message count and data

Line 619: WHEN FND_API.G_EXC_ERROR THEN

615: commit;
616: end if;
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618: EXCEPTION
619: WHEN FND_API.G_EXC_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: -- Get message count and data
622: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data =>
623: x_msg_data);

Line 620: x_return_status := FND_API.G_RET_STS_ERROR;

616: end if;
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618: EXCEPTION
619: WHEN FND_API.G_EXC_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: -- Get message count and data
622: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data =>
623: x_msg_data);
624: ROLLBACK TO TO_TRX_LINE_SAVE; /* Bug 7014473 */

Line 625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

621: -- Get message count and data
622: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data =>
623: x_msg_data);
624: ROLLBACK TO TO_TRX_LINE_SAVE; /* Bug 7014473 */
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
627: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data =>
628: x_msg_data);
629: ROLLBACK TO TO_TRX_LINE_SAVE; /* Bug 7014473 */

Line 626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

622: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data =>
623: x_msg_data);
624: ROLLBACK TO TO_TRX_LINE_SAVE; /* Bug 7014473 */
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
627: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data =>
628: x_msg_data);
629: ROLLBACK TO TO_TRX_LINE_SAVE; /* Bug 7014473 */
630: WHEN OTHERS THEN

Line 634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

630: WHEN OTHERS THEN
631: IF (l_debug = 1) THEN
632: TraceLog('Exception when others', 'Pick_Confirm');
633: END IF;
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: -- Get message count and data
636: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
637: ROLLBACK TO TO_TRX_LINE_SAVE; /* Bug 7014473 */
638: