DBA Data[Home] [Help]

APPS.INV_PICK_WAVE_PICK_CONFIRM_PUB dependencies on FND_MESSAGE

Line 109: FND_MESSAGE.SET_NAME('INV', 'INV_NO_LINES_TO_PICK_CONFIRM');

105: -- Only if both are zero should it error out
106:
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;

Line 146: FND_MESSAGE.SET_NAME('INV', 'INV_PICK_QTY_ERROR');

142: TraceLog(to_char(i) || ' ' || l_trolin_rec.line_id || ' l_qty_detailed = ' || l_qty_detailed, 'Pick_Confirm');
143: TraceLog(to_char(i) || ' ' || l_trolin_rec.line_id || ' l_qty_delivered = ' || l_qty_delivered, 'Pick_Confirm');
144: END IF;
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

Line 178: FND_MESSAGE.SET_NAME('INV', 'INV_INT_TDATEEX');

174: IF p_transaction_date IS NOT NULL THEN
175: TraceLog('p_transaction_date: '||p_transaction_date, 'Pick_confirm');
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;

Line 198: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');

194:
195:
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;

Line 227: fnd_message.set_name('INV', 'INV_COULD_NOT_UPATE_RECORD');

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');
231: END IF;

Line 238: fnd_message.set_name('INV', 'INV_COULD_NOT_UPATE_RECORD');

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');
239: fnd_msg_pub.add;
240: rollback to TO_TRX_LINE_SAVE;
241: raise FND_API.G_EXC_UNEXPECTED_ERROR;
242: end if;

Line 289: FND_MESSAGE.SET_NAME('INV', 'INV_PICK_QTY_ERROR');

285:
286: l_qty_detailed := l_trolin_tbl(1).quantity_detailed;
287: l_qtY_delivered := l_trolin_tbl(1).quantity_delivered;
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;

Line 310: FND_MESSAGE.SET_NAME('INV', 'INV_INT_TDATEEX');

306: IF p_transaction_date IS NOT NULL THEN
307: TraceLog('p_transaction_date: '||p_transaction_date, 'Pick_confirm');
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;

Line 328: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');

324: open_past_period => l_open_past_period);
325:
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;

Line 347: fnd_message.set_name('INV', 'INV_COULD_NOT_UPATE_RECORD');

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');
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

Line 355: fnd_message.set_name('INV', 'INV_COULD_NOT_UPATE_RECORD');

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');
356: fnd_msg_pub.add;
357: rollback to TO_TRX_LINE_SAVE;
358: raise FND_API.G_EXC_UNEXPECTED_ERROR;
359: end if;

Line 409: FND_Message.Set_Name('INV','INV_ORPHAN_CLEANUP_ERROR');

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

Line 417: FND_Message.Set_Name('INV', 'INV_LOTNULL_ERROR');

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

Line 425: FND_Message.Set_Name('INV', 'INV_LOTCOPY_ERROR');

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

Line 433: FND_Message.Set_Name('INV', 'INV_DYNAMIC_SERIAL_ERROR');

429: IF (l_debug = 1) THEN
430: TraceLog('lot success= -4', 'Pick_Confirm');
431: END IF;
432: rollback to TO_TRX_LINE_SAVE;
433: FND_Message.Set_Name('INV', 'INV_DYNAMIC_SERIAL_ERROR');
434: FND_MSG_PUB.Add;
435: raise FND_API.G_EXC_ERROR;
436: END IF;
437:

Line 484: FND_MESSAGE.SET_NAME('INV', 'INV_TM_TIME_OUT');

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

Line 494: FND_MESSAGE.SET_NAME('INV', 'INV_TM_MGR_NOT_AVAIL');

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

Line 535: FND_MESSAGE.SET_NAME('INV', 'INV_TM_TIME_OUT');

531: TraceLog('Error from INV_TM launch', 'Pick_Confirm');
532: --rollback to TO_TRX_LINE_SAVE;
533: /*if( l_rc_field = 1) then
534: TraceLog('l_rc_field = ' || l_rc_field);
535: FND_MESSAGE.SET_NAME('INV', 'INV_TM_TIME_OUT');
536: FND_MSG_PUB.ADD;
537: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: raise FND_API.G_EXC_UNEXPECTED_ERROR;
539: elsif l_rc_field = 2 then

Line 541: FND_MESSAGE.SET_NAME('INV', 'INV_TM_MGR_NOT_AVAIL');

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

Line 613: FND_MESSAGE.SET_NAME('INV', 'INV_ORPHAN_CLEANUP_ERROR');

609: WHEN OTHERS then
610: -- TraceLog('error in cleanup orphan lot serial');
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: rollback to TO_TRX_LINE_SAVE;
613: FND_MESSAGE.SET_NAME('INV', 'INV_ORPHAN_CLEANUP_ERROR');
614: FND_MSG_PUB.ADD;
615: END;
616: if( p_commit = FND_API.G_TRUE ) then
617: commit;

Line 721: fnd_message.set_name('INV', 'INV_TM_TIME_OUT');

717: IF (l_debug = 1) THEN
718: TraceLog('INV_TM_TIMEOUT', 'INV_TM_LAUNCH');
719: END IF;
720: END IF;
721: fnd_message.set_name('INV', 'INV_TM_TIME_OUT');
722: fnd_msg_pub.add;
723: RETURN (FALSE);
724: ELSIF rtvl = 2 THEN
725: IF (l_debug = 1) THEN

Line 730: fnd_message.set_name('INV', 'INV_TM_MGR_NOT_AVAIL');

726: IF (l_debug = 1) THEN
727: TraceLog('INV_TM_MGR_NOT_AVAIL', 'INV_TM_LAUNCH');
728: END IF;
729: END IF;
730: fnd_message.set_name('INV', 'INV_TM_MGR_NOT_AVAIL');
731: fnd_msg_pub.add;
732: RETURN (FALSE);
733: ELSIF rtvl = 3 THEN
734: IF (l_debug = 1) THEN

Line 739: fnd_message.set_name('FND','CONC-DG-Inactive No Manager');

735: IF (l_debug = 1) THEN
736: TraceLog('CONC-DG-Inactive No Manager', 'INV_TM_LAUNCH');
737: END IF;
738: END IF;
739: fnd_message.set_name('FND','CONC-DG-Inactive No Manager');
740: fnd_msg_pub.add;
741: RETURN(FALSE);
742: ELSIF rtvl = 0 THEN
743: -- get info back from server and handle problems