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 408: FND_MSG_PUB.add;

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

Line 416: FND_MSG_PUB.add;

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

Line 424: FND_MSG_PUB.add;

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

Line 432: FND_MSG_PUB.Add;

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

Line 483: FND_MSG_PUB.ADD;

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

Line 493: FND_MSG_PUB.ADD;

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

Line 534: FND_MSG_PUB.ADD;

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

Line 540: FND_MSG_PUB.ADD;

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

Line 612: FND_MSG_PUB.ADD;

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;
614: if( p_commit = FND_API.G_TRUE ) then
615: commit;
616: end if;

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

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 */
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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:
639: END Pick_Confirm;
640:

Line 720: fnd_msg_pub.add;

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

Line 729: fnd_msg_pub.add;

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

Line 738: fnd_msg_pub.add;

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

Line 751: FND_MSG_PUB.Add_Exc_Msg(

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

Line 758: FND_MSG_PUB.Add_Exc_Msg(

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

Line 764: FND_MSG_PUB.Add_Exc_Msg(

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

Line 771: FND_MSG_PUB.Add_Exc_Msg(

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

Line 778: FND_MSG_PUB.Add_Exc_Msg(

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

Line 786: FND_MSG_PUB.Add_Exc_Msg(

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

Line 792: FND_MSG_PUB.Add_Exc_Msg(

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

Line 799: FND_MSG_PUB.Add_Exc_Msg(

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

Line 806: FND_MSG_PUB.Add_Exc_Msg(

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

Line 813: FND_MSG_PUB.Add_Exc_Msg(

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

Line 833: FND_MSG_PUB.Add_Exc_Msg(

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