DBA Data[Home] [Help]

APPS.INV_PICK_WAVE_PICK_CONFIRM_PUB dependencies on FND_MSG_PUB

Line 96: FND_MSG_PUB.initialize;

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:
100: -- if( l_trolin_tbl.count = 0 OR (l_trolin_tbl.count = 0 AND

Line 110: FND_MSG_PUB.add;

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;
114:

Line 147: FND_MSG_PUB.ADD;

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
151: l_mold_tbl := INV_MO_LINE_DETAIL_UTIL.Query_Rows( p_line_id => l_trolin_tbl(i).line_id);

Line 179: FND_MSG_PUB.add;

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;
183: END IF;

Line 199: FND_MSG_PUB.add;

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;
203:

Line 228: fnd_msg_pub.add;

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;
232: rollback to TO_TRX_LINE_SAVE;

Line 239: fnd_msg_pub.add;

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;
243: IF (l_debug = 1) THEN

Line 290: FND_MSG_PUB.ADD;

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;
294: l_mold_tbl(j).transaction_status := 3;

Line 311: FND_MSG_PUB.add;

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;
315: END IF;

Line 329: FND_MSG_PUB.add;

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;
333:

Line 348: fnd_msg_pub.add;

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
352: IF (l_debug = 1) THEN

Line 356: fnd_msg_pub.add;

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;
360: l_trolin_tbl(1).transaction_header_id :=

Line 410: FND_MSG_PUB.add;

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
414: TraceLog('lot success= -2', 'Pick_Confirm');

Line 418: FND_MSG_PUB.add;

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
422: TraceLog('lot success= -3', 'Pick_Confirm');

Line 426: FND_MSG_PUB.add;

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
430: TraceLog('lot success= -4', 'Pick_Confirm');

Line 434: FND_MSG_PUB.Add;

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:
438: /* Bug 1620487 - Performance

Line 485: FND_MSG_PUB.ADD;

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
489: IF (l_debug = 1) THEN

Line 495: FND_MSG_PUB.ADD;

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
499: IF (l_debug = 1) THEN

Line 536: FND_MSG_PUB.ADD;

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
540: TraceLog('l_rc_field = ' || l_rc_field);

Line 542: FND_MSG_PUB.ADD;

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
546: TraceLog('l_rc_field = ' || l_rc_field);

Line 614: FND_MSG_PUB.ADD;

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;
618: end if;

Line 624: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data =>

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

Line 629: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data =>

625: x_msg_data);
626: ROLLBACK TO TO_TRX_LINE_SAVE; /* Bug 7014473 */
627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
629: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data =>
630: x_msg_data);
631: ROLLBACK TO TO_TRX_LINE_SAVE; /* Bug 7014473 */
632: WHEN OTHERS THEN
633: IF (l_debug = 1) THEN

Line 638: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

634: TraceLog('Exception when others', 'Pick_Confirm');
635: END IF;
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
637: -- Get message count and data
638: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
639: ROLLBACK TO TO_TRX_LINE_SAVE; /* Bug 7014473 */
640:
641: END Pick_Confirm;
642:

Line 722: fnd_msg_pub.add;

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
726: IF (l_debug = 1) THEN

Line 731: fnd_msg_pub.add;

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
735: IF (l_debug = 1) THEN

Line 740: fnd_msg_pub.add;

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
744: rtvl := fnd_transaction.get_values

Line 753: FND_MSG_PUB.Add_Exc_Msg(

749: END IF;
750:
751: IF (args1 IS NOT NULL) THEN
752: --inv_debug.message(args1);
753: FND_MSG_PUB.Add_Exc_Msg(
754: p_pkg_name => 'INV_Pick_Confirm_PUB',
755: p_procedure_name => 'INV_TM_LAUNCH',
756: p_error_text => args1);
757: END IF;

Line 760: FND_MSG_PUB.Add_Exc_Msg(

756: p_error_text => args1);
757: END IF;
758: IF (args2 IS NOT NULL) THEN
759: --inv_debug.message(args2);
760: FND_MSG_PUB.Add_Exc_Msg(
761: p_pkg_name => 'INV_Pick_Confirm_PUB',
762: p_procedure_name => 'INV_TM_LAUNCH',
763: p_error_text => args2);
764: END IF;

Line 766: FND_MSG_PUB.Add_Exc_Msg(

762: p_procedure_name => 'INV_TM_LAUNCH',
763: p_error_text => args2);
764: END IF;
765: IF (args3 IS NOT NULL) THEN
766: FND_MSG_PUB.Add_Exc_Msg(
767: p_pkg_name => 'INV_Pick_Confirm_PUB',
768: p_procedure_name => 'INV_TM_LAUNCH',
769: p_error_text => args3);
770: --inv_debug.message(args3);

Line 773: FND_MSG_PUB.Add_Exc_Msg(

769: p_error_text => args3);
770: --inv_debug.message(args3);
771: END IF;
772: IF (args4 IS NOT NULL) THEN
773: FND_MSG_PUB.Add_Exc_Msg(
774: p_pkg_name => 'INV_Pick_Confirm_PUB',
775: p_procedure_name => 'INV_TM_LAUNCH',
776: p_error_text => args4);
777: --inv_debug.message(args4);

Line 780: FND_MSG_PUB.Add_Exc_Msg(

776: p_error_text => args4);
777: --inv_debug.message(args4);
778: END IF;
779: IF (args5 IS NOT NULL) THEN
780: FND_MSG_PUB.Add_Exc_Msg(
781: p_pkg_name => 'INV_Pick_Confirm_PUB',
782: p_procedure_name => 'INV_TM_LAUNCH',
783: p_error_text => args5);
784: --inv_debug.message(args5);

Line 788: FND_MSG_PUB.Add_Exc_Msg(

784: --inv_debug.message(args5);
785: END IF;
786: IF (args6 IS NOT NULL) THEN
787: --inv_debug.message(args6);
788: FND_MSG_PUB.Add_Exc_Msg(
789: p_pkg_name => 'INV_Pick_Confirm_PUB',
790: p_procedure_name => 'INV_TM_LAUNCH',
791: p_error_text => args6);
792: END IF;

Line 794: FND_MSG_PUB.Add_Exc_Msg(

790: p_procedure_name => 'INV_TM_LAUNCH',
791: p_error_text => args6);
792: END IF;
793: IF (args7 IS NOT NULL) THEN
794: FND_MSG_PUB.Add_Exc_Msg(
795: p_pkg_name => 'INV_Pick_Confirm_PUB',
796: p_procedure_name => 'INV_TM_LAUNCH',
797: p_error_text => args7);
798: --inv_debug.message(args7);

Line 801: FND_MSG_PUB.Add_Exc_Msg(

797: p_error_text => args7);
798: --inv_debug.message(args7);
799: END IF;
800: IF (args8 IS NOT NULL) THEN
801: FND_MSG_PUB.Add_Exc_Msg(
802: p_pkg_name => 'INV_Pick_Confirm_PUB',
803: p_procedure_name => 'INV_TM_LAUNCH',
804: p_error_text => args8);
805: --inV_debug.message(args8);

Line 808: FND_MSG_PUB.Add_Exc_Msg(

804: p_error_text => args8);
805: --inV_debug.message(args8);
806: END IF;
807: IF (args9 IS NOT NULL) THEN
808: FND_MSG_PUB.Add_Exc_Msg(
809: p_pkg_name => 'INV_Pick_Confirm_PUB',
810: p_procedure_name => 'INV_TM_LAUNCH',
811: p_error_text => args9);
812: --inv_debug.message(args9);

Line 815: FND_MSG_PUB.Add_Exc_Msg(

811: p_error_text => args9);
812: --inv_debug.message(args9);
813: END IF;
814: IF (args10 IS NOT NULL) THEN
815: FND_MSG_PUB.Add_Exc_Msg(
816: p_pkg_name => 'INV_Pick_Confirm_PUB',
817: p_procedure_name => 'INV_TM_LAUNCH',
818: p_error_text => args10);
819: --inv_debug.message(args10);

Line 835: FND_MSG_PUB.Add_Exc_Msg(

831: IF (l_debug = 1) THEN
832: TraceLog('exception ...', 'INV_TM_LAUNCH');
833: END IF;
834: END IF;
835: FND_MSG_PUB.Add_Exc_Msg(
836: p_pkg_name => 'INV_Pick_Confirm_PUB',
837: p_procedure_name => 'INV_TM_LAUNCH');
838: return (false);
839: END INV_TM_LAUNCH;