DBA Data[Home] [Help]

APPS.INV_MO_ADMIN_PUB dependencies on FND_MSG_PUB

Line 52: FND_MSG_PUB.initialize;

48: END IF;
49:
50: -- Initailize message list
51: If FND_API.To_Boolean( p_init_msg_list ) Then
52: FND_MSG_PUB.initialize;
53: End If;
54:
55: -- API Body
56: INV_Move_Order_Pub.Get_Move_Order(

Line 84: FND_MSG_PUB.ADD;

80: END IF;
81:
82: IF ( l_trohdr_rec.header_status = 5 ) THEN
83: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
84: FND_MSG_PUB.ADD;
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87:
88: for I in 1..l_trolin_tbl.count loop

Line 121: FND_MSG_PUB.Count_And_Get(

117: COMMIT WORK;
118: end if;
119:
120: -- Call to get msg count
121: FND_MSG_PUB.Count_And_Get(
122: p_count => x_msg_count,
123: p_data => x_msg_data ) ;
124:
125: EXCEPTION

Line 128: FND_MSG_PUB.Count_And_Get(

124:
125: EXCEPTION
126: WHEN FND_API.G_EXC_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: FND_MSG_PUB.Count_And_Get(
129: p_count => x_msg_count,
130: p_data => x_msg_data) ;
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 133: FND_MSG_PUB.Count_And_Get(

129: p_count => x_msg_count,
130: p_data => x_msg_data) ;
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: FND_MSG_PUB.Count_And_Get(
134: p_count => x_msg_count,
135: p_data => x_msg_data) ;
136: WHEN OTHERS THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 138: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

134: p_count => x_msg_count,
135: p_data => x_msg_data) ;
136: WHEN OTHERS THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
139: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel_Order');
140: END IF;
141: FND_MSG_PUB.Count_And_Get(
142: p_count => x_msg_count,

Line 139: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel_Order');

135: p_data => x_msg_data) ;
136: WHEN OTHERS THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
139: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel_Order');
140: END IF;
141: FND_MSG_PUB.Count_And_Get(
142: p_count => x_msg_count,
143: p_data => x_msg_data) ;

Line 141: FND_MSG_PUB.Count_And_Get(

137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
139: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel_Order');
140: END IF;
141: FND_MSG_PUB.Count_And_Get(
142: p_count => x_msg_count,
143: p_data => x_msg_data) ;
144: END CANCEL_ORDER;
145:

Line 186: FND_MSG_PUB.initialize;

182: END IF;
183:
184: -- Initailize message list
185: If FND_API.To_Boolean( p_init_msg_list ) Then
186: FND_MSG_PUB.initialize;
187: End If;
188:
189: -- API Body
190: BEGIN

Line 199: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close Order');

195: EXCEPTION
196: WHEN No_Data_Found THEN
197: RAISE FND_API.G_EXC_ERROR;
198: WHEN OTHERS THEN
199: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close Order');
200: RAISE FND_API.G_EXC_ERROR;
201: END;
202:
203: IF ( l_hdr_status = 5 ) THEN

Line 225: FND_MSG_PUB.ADD;

221: END IF;
222:
223: IF ( l_hdr_status = 1 OR l_line_status = 1 ) THEN
224: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
225: FND_MSG_PUB.ADD;
226: RAISE FND_API.G_EXC_ERROR;
227: END IF;
228:
229: l_trolin_tbl := Inv_Trolin_Util.Get_Lines( l_header_id );

Line 266: FND_MSG_PUB.Count_And_Get(

262: COMMIT WORK;
263: end if;
264:
265: -- Call to get msg count and data
266: FND_MSG_PUB.Count_And_Get(
267: p_count => x_msg_count,
268: p_data => x_msg_data ) ;
269:
270: EXCEPTION

Line 273: FND_MSG_PUB.Count_And_Get(

269:
270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: FND_MSG_PUB.Count_And_Get(
274: p_count => x_msg_count,
275: p_data => x_msg_data) ;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 278: FND_MSG_PUB.Count_And_Get(

274: p_count => x_msg_count,
275: p_data => x_msg_data) ;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: FND_MSG_PUB.Count_And_Get(
279: p_count => x_msg_count,
280: p_data => x_msg_data) ;
281: WHEN OTHERS THEN
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 283: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

279: p_count => x_msg_count,
280: p_data => x_msg_data) ;
281: WHEN OTHERS THEN
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
284: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close_Order');
285: END IF;
286: FND_MSG_PUB.Count_And_Get(
287: p_count => x_msg_count,

Line 284: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close_Order');

280: p_data => x_msg_data) ;
281: WHEN OTHERS THEN
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
284: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close_Order');
285: END IF;
286: FND_MSG_PUB.Count_And_Get(
287: p_count => x_msg_count,
288: p_data => x_msg_data) ;

Line 286: FND_MSG_PUB.Count_And_Get(

282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
284: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close_Order');
285: END IF;
286: FND_MSG_PUB.Count_And_Get(
287: p_count => x_msg_count,
288: p_data => x_msg_data) ;
289: END CLOSE_ORDER;
290:

Line 329: FND_MSG_PUB.initialize;

325: END IF;
326:
327: -- Initailize message list
328: If FND_API.To_Boolean( p_init_msg_list ) Then
329: FND_MSG_PUB.initialize;
330: End If;
331:
332: -- API Body
333: Begin

Line 343: FND_MSG_PUB.Add_Exc_Msg

339: Exception
340: When No_Data_Found Then
341: RAISE FND_API.G_EXC_ERROR;
342: When OTHERS then
343: FND_MSG_PUB.Add_Exc_Msg
344: ( G_PKG_NAME
345: , 'purge Order'
346: );
347:

Line 353: FND_MSG_PUB.ADD;

349: End;
350:
351: IF ( l_hdr_status <> 5 ) THEN
352: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
353: FND_MSG_PUB.ADD;
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:
357: Delete MTL_TXN_REQUEST_LINES

Line 374: FND_MSG_PUB.Count_And_Get(

370: COMMIT WORK;
371: end if;
372:
373: -- Call to get msg count and data
374: FND_MSG_PUB.Count_And_Get(
375: p_count => x_msg_count,
376: p_data => x_msg_data ) ;
377:
378: Exception

Line 381: FND_MSG_PUB.Count_And_Get(

377:
378: Exception
379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MSG_PUB.Count_And_Get(
382: p_count => x_msg_count,
383: p_data => x_msg_data ) ;
384:
385:

Line 389: FND_MSG_PUB.Count_And_Get(

385:
386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
387:
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389: FND_MSG_PUB.Count_And_Get(
390: p_count => x_msg_count,
391: p_data => x_msg_data ) ;
392:
393:

Line 395: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

391: p_data => x_msg_data ) ;
392:
393:
394: WHEN OTHERS THEN
395: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
396: THEN
397: FND_MSG_PUB.Add_Exc_Msg
398: ( G_PKG_NAME
399: , 'Purge_Order'

Line 397: FND_MSG_PUB.Add_Exc_Msg

393:
394: WHEN OTHERS THEN
395: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
396: THEN
397: FND_MSG_PUB.Add_Exc_Msg
398: ( G_PKG_NAME
399: , 'Purge_Order'
400: );
401: END IF;

Line 402: FND_MSG_PUB.Count_And_Get(

398: ( G_PKG_NAME
399: , 'Purge_Order'
400: );
401: END IF;
402: FND_MSG_PUB.Count_And_Get(
403: p_count => x_msg_count,
404: p_data => x_msg_data ) ;
405:
406: END PURGE_ORDER;

Line 458: FND_MSG_PUB.initialize;

454: END IF;
455:
456: -- Initailize message list
457: If FND_API.To_Boolean( p_init_msg_list ) Then
458: FND_MSG_PUB.initialize;
459: End If;
460:
461: -- API Body
462: Begin

Line 475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

471: EXCEPTION
472: WHEN No_Data_Found THEN
473: RAISE FND_API.G_EXC_ERROR;
474: WHEN app_exceptions.record_lock_exception THEN
475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
476: fnd_message.set_name('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
477: fnd_msg_pub.ADD;
478: END IF;
479: RAISE FND_API.G_EXC_ERROR;

Line 477: fnd_msg_pub.ADD;

473: RAISE FND_API.G_EXC_ERROR;
474: WHEN app_exceptions.record_lock_exception THEN
475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
476: fnd_message.set_name('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
477: fnd_msg_pub.ADD;
478: END IF;
479: RAISE FND_API.G_EXC_ERROR;
480: WHEN OTHERS THEN
481: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel Line');

Line 481: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel Line');

477: fnd_msg_pub.ADD;
478: END IF;
479: RAISE FND_API.G_EXC_ERROR;
480: WHEN OTHERS THEN
481: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel Line');
482: RAISE FND_API.G_EXC_ERROR;
483: END;
484:
485:

Line 493: FND_MSG_PUB.ADD;

489: END IF;
490:
491: IF ( l_Line_status = 5 ) THEN
492: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
493: FND_MSG_PUB.ADD;
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496:
497: IF ( l_mo_type <> 3 ) then /* 3 - pickwave type MO */

Line 540: FND_MSG_PUB.Add_Exc_Msg

536: l_new_trolin_tbl(1).line_status := 6;
537: l_new_trolin_tbl(1).status_date := sysdate; --bug 5053725
538: l_delete_mmtt := 'YES';
539: When OTHERS then
540: FND_MSG_PUB.Add_Exc_Msg
541: ( G_PKG_NAME
542: , 'Cancel Line'
543: );
544:

Line 585: FND_MSG_PUB.Count_And_Get(

581: COMMIT WORK;
582: end if;
583:
584: -- Call to get msg count and data
585: FND_MSG_PUB.Count_And_Get(
586: p_count => x_msg_count,
587: p_data => x_msg_data ) ;
588:
589: EXCEPTION

Line 592: FND_MSG_PUB.Count_And_Get(

588:
589: EXCEPTION
590: WHEN FND_API.G_EXC_ERROR THEN
591: x_return_status := FND_API.G_RET_STS_ERROR;
592: FND_MSG_PUB.Count_And_Get(
593: p_count => x_msg_count,
594: p_data => x_msg_data) ;
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 597: FND_MSG_PUB.Count_And_Get(

593: p_count => x_msg_count,
594: p_data => x_msg_data) ;
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597: FND_MSG_PUB.Count_And_Get(
598: p_count => x_msg_count,
599: p_data => x_msg_data) ;
600: WHEN OTHERS THEN
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 602: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

598: p_count => x_msg_count,
599: p_data => x_msg_data) ;
600: WHEN OTHERS THEN
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
603: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel line');
604: END IF;
605: FND_MSG_PUB.Count_And_Get(
606: p_count => x_msg_count,

Line 603: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel line');

599: p_data => x_msg_data) ;
600: WHEN OTHERS THEN
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
603: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel line');
604: END IF;
605: FND_MSG_PUB.Count_And_Get(
606: p_count => x_msg_count,
607: p_data => x_msg_data ) ;

Line 605: FND_MSG_PUB.Count_And_Get(

601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
603: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel line');
604: END IF;
605: FND_MSG_PUB.Count_And_Get(
606: p_count => x_msg_count,
607: p_data => x_msg_data ) ;
608: END CANCEL_LINE;
609:

Line 655: FND_MSG_PUB.initialize;

651: END IF;
652:
653: -- Initailize message list
654: If FND_API.To_Boolean( p_init_msg_list ) Then
655: FND_MSG_PUB.initialize;
656: End If;
657:
658: -- API Body
659: BEGIN

Line 672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

668: EXCEPTION
669: WHEN No_Data_Found THEN
670: RAISE FND_API.G_EXC_ERROR;
671: WHEN app_exceptions.record_lock_exception THEN
672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
673: fnd_message.set_name('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
674: fnd_msg_pub.ADD;
675: END IF;
676: RAISE FND_API.G_EXC_ERROR;

Line 674: fnd_msg_pub.ADD;

670: RAISE FND_API.G_EXC_ERROR;
671: WHEN app_exceptions.record_lock_exception THEN
672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
673: fnd_message.set_name('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
674: fnd_msg_pub.ADD;
675: END IF;
676: RAISE FND_API.G_EXC_ERROR;
677: WHEN OTHERS THEN
678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close Line');

Line 678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close Line');

674: fnd_msg_pub.ADD;
675: END IF;
676: RAISE FND_API.G_EXC_ERROR;
677: WHEN OTHERS THEN
678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close Line');
679: RAISE FND_API.G_EXC_ERROR;
680: END;
681:
682: IF ( l_Line_status = 5 ) THEN

Line 696: FND_MSG_PUB.ADD;

692: END IF; */
693:
694: IF ( l_Line_status not in (3,4,6,7,9) ) THEN
695: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
696: FND_MSG_PUB.ADD;
697: RAISE FND_API.G_EXC_ERROR;
698: END IF;
699:
700: /*Added bug3524130*/

Line 788: FND_MSG_PUB.Count_And_Get(

784: COMMIT WORK;
785: end if;
786:
787: -- Call to get msg coount and data
788: FND_MSG_PUB.Count_And_Get(
789: p_count => x_msg_count,
790: p_data => x_msg_data ) ;
791:
792: Exception

Line 795: FND_MSG_PUB.Count_And_Get(

791:
792: Exception
793: WHEN FND_API.G_EXC_ERROR THEN
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: FND_MSG_PUB.Count_And_Get(
796: p_count => x_msg_count,
797: p_data => x_msg_data ) ;
798:
799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 801: FND_MSG_PUB.Count_And_Get(

797: p_data => x_msg_data ) ;
798:
799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: FND_MSG_PUB.Count_And_Get(
802: p_count => x_msg_count,
803: p_data => x_msg_data ) ;
804: WHEN OTHERS THEN
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 806: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

802: p_count => x_msg_count,
803: p_data => x_msg_data ) ;
804: WHEN OTHERS THEN
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
806: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
807: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close line');
808: END IF;
809: FND_MSG_PUB.Count_And_Get(
810: p_count => x_msg_count,

Line 807: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close line');

803: p_data => x_msg_data ) ;
804: WHEN OTHERS THEN
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
806: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
807: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close line');
808: END IF;
809: FND_MSG_PUB.Count_And_Get(
810: p_count => x_msg_count,
811: p_data => x_msg_data ) ;

Line 809: FND_MSG_PUB.Count_And_Get(

805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
806: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
807: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close line');
808: END IF;
809: FND_MSG_PUB.Count_And_Get(
810: p_count => x_msg_count,
811: p_data => x_msg_data ) ;
812: END CLOSE_LINE;
813: