DBA Data[Home] [Help]

APPS.EGO_ITEM_STATUSES_PUB dependencies on FND_MSG_PUB

Line 79: FND_MSG_PUB.initialize;

75: END IF;
76: -- Initialize API message list if necessary.
77: -- Initialize message list if p_init_msg_list is set to TRUE.
78: IF FND_API.to_Boolean(p_init_msg_list) THEN
79: FND_MSG_PUB.initialize;
80: END IF;
81:
82: ------------------------------
83:

Line 202: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

198: -- Standard call to get message count and if count is 1,
199: -- get message info.
200: -- The client will directly display the x_msg_data (which is already
201: -- translated) if the x_msg_count = 1;
202: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get
203: -- Server-side procedure to access the messages, and consolidate them
204: -- and display (or) to display one message after another.
205:
206: FND_MSG_PUB.Count_And_Get

Line 206: FND_MSG_PUB.Count_And_Get

202: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get
203: -- Server-side procedure to access the messages, and consolidate them
204: -- and display (or) to display one message after another.
205:
206: FND_MSG_PUB.Count_And_Get
207: ( p_count => x_msg_count,
208: p_data => x_msg_data
209: );
210:

Line 217: FND_MSG_PUB.Count_And_Get

213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO Create_Item_Status_PUB;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: FND_MSG_PUB.Count_And_Get
218: ( p_count => x_msg_count,
219: p_data => x_msg_data
220: );
221:

Line 227: FND_MSG_PUB.Count_And_Get

223:
224: WHEN G_DUPLICATE_EXCEPTION THEN
225: ROLLBACK TO Create_Item_Status_PUB;
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: FND_MSG_PUB.Count_And_Get
228: ( p_count => x_msg_count,
229: p_data => x_msg_data
230: );
231:

Line 237: FND_MSG_PUB.Count_And_Get

233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO Create_Item_Status_PUB;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: FND_MSG_PUB.Count_And_Get
238: ( p_count => x_msg_count,
239: p_data => x_msg_data
240: );
241: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 245: IF FND_MSG_PUB.Check_Msg_Level

241: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
242: WHEN OTHERS THEN
243: ROLLBACK TO Create_Item_Status_PUB;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: IF FND_MSG_PUB.Check_Msg_Level
246: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
247: THEN
248: FND_MSG_PUB.Add_Exc_Msg
249: ( G_PKG_NAME,

Line 246: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

242: WHEN OTHERS THEN
243: ROLLBACK TO Create_Item_Status_PUB;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: IF FND_MSG_PUB.Check_Msg_Level
246: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
247: THEN
248: FND_MSG_PUB.Add_Exc_Msg
249: ( G_PKG_NAME,
250: l_api_name

Line 248: FND_MSG_PUB.Add_Exc_Msg

244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: IF FND_MSG_PUB.Check_Msg_Level
246: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
247: THEN
248: FND_MSG_PUB.Add_Exc_Msg
249: ( G_PKG_NAME,
250: l_api_name
251: );
252: END IF;

Line 253: FND_MSG_PUB.Count_And_Get

249: ( G_PKG_NAME,
250: l_api_name
251: );
252: END IF;
253: FND_MSG_PUB.Count_And_Get
254: ( p_count => x_msg_count,
255: p_data => x_msg_data
256: );
257: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 322: FND_MSG_PUB.initialize;

318: END IF;
319: -- Initialize API message list if necessary.
320: -- Initialize message list if p_init_msg_list is set to TRUE.
321: IF FND_API.to_Boolean(p_init_msg_list) THEN
322: FND_MSG_PUB.initialize;
323: END IF;
324:
325: ------------------------------
326: MTL_ITEM_STATUS_PKG.UPDATE_ROW(

Line 397: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

393: -- Standard call to get message count and if count is 1,
394: -- get message info.
395: -- The client will directly display the x_msg_data (which is already
396: -- translated) if the x_msg_count = 1;
397: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get
398: -- Server-side procedure to access the messages, and consolidate them
399: -- and display (or) to display one message after another.
400:
401: FND_MSG_PUB.Count_And_Get

Line 401: FND_MSG_PUB.Count_And_Get

397: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get
398: -- Server-side procedure to access the messages, and consolidate them
399: -- and display (or) to display one message after another.
400:
401: FND_MSG_PUB.Count_And_Get
402: ( p_count => x_msg_count,
403: p_data => x_msg_data
404: );
405:

Line 413: IF FND_MSG_PUB.Check_Msg_Level

409:
410: WHEN OTHERS THEN
411: ROLLBACK TO Update_Item_Status_PUB;
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
413: IF FND_MSG_PUB.Check_Msg_Level
414: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
415: THEN
416: FND_MSG_PUB.Add_Exc_Msg
417: ( G_PKG_NAME,

Line 414: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

410: WHEN OTHERS THEN
411: ROLLBACK TO Update_Item_Status_PUB;
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
413: IF FND_MSG_PUB.Check_Msg_Level
414: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
415: THEN
416: FND_MSG_PUB.Add_Exc_Msg
417: ( G_PKG_NAME,
418: l_api_name

Line 416: FND_MSG_PUB.Add_Exc_Msg

412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
413: IF FND_MSG_PUB.Check_Msg_Level
414: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
415: THEN
416: FND_MSG_PUB.Add_Exc_Msg
417: ( G_PKG_NAME,
418: l_api_name
419: );
420: END IF;

Line 421: FND_MSG_PUB.Count_And_Get

417: ( G_PKG_NAME,
418: l_api_name
419: );
420: END IF;
421: FND_MSG_PUB.Count_And_Get
422: ( p_count => x_msg_count,
423: p_data => x_msg_data
424: );
425: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 471: FND_MSG_PUB.initialize;

467: END IF;
468: -- Initialize API message list if necessary.
469: -- Initialize message list if p_init_msg_list is set to TRUE.
470: IF FND_API.to_Boolean(p_init_msg_list) THEN
471: FND_MSG_PUB.initialize;
472: END IF;
473:
474: ------------------------------
475:

Line 528: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

524: -- Standard call to get message count and if count is 1,
525: -- get message info.
526: -- The client will directly display the x_msg_data (which is already
527: -- translated) if the x_msg_count = 1;
528: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get
529: -- Server-side procedure to access the messages, and consolidate them
530: -- and display (or) to display one message after another.
531:
532: FND_MSG_PUB.Count_And_Get

Line 532: FND_MSG_PUB.Count_And_Get

528: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get
529: -- Server-side procedure to access the messages, and consolidate them
530: -- and display (or) to display one message after another.
531:
532: FND_MSG_PUB.Count_And_Get
533: ( p_count => x_msg_count,
534: p_data => x_msg_data
535: );
536:

Line 543: FND_MSG_PUB.Count_And_Get

539: EXCEPTION
540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO Create_Item_Stat_Attr_Vals_Pub;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: FND_MSG_PUB.Count_And_Get
544: ( p_count => x_msg_count,
545: p_data => x_msg_data
546: );
547:

Line 553: FND_MSG_PUB.Count_And_Get

549:
550: WHEN G_DUPLICATE_EXCEPTION THEN
551: ROLLBACK TO Create_Item_Stat_Attr_Vals_Pub;
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: FND_MSG_PUB.Count_And_Get
554: ( p_count => x_msg_count,
555: p_data => x_msg_data
556: );
557:

Line 563: FND_MSG_PUB.Count_And_Get

559:
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: ROLLBACK TO Create_Item_Stat_Attr_Vals_Pub;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count,
565: p_data => x_msg_data
566: );
567: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 571: IF FND_MSG_PUB.Check_Msg_Level

567: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
568: WHEN OTHERS THEN
569: ROLLBACK TO Create_Item_Stat_Attr_Vals_Pub;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg
575: ( G_PKG_NAME,

Line 572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

568: WHEN OTHERS THEN
569: ROLLBACK TO Create_Item_Stat_Attr_Vals_Pub;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg
575: ( G_PKG_NAME,
576: l_api_name

Line 574: FND_MSG_PUB.Add_Exc_Msg

570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg
575: ( G_PKG_NAME,
576: l_api_name
577: );
578: END IF;

Line 579: FND_MSG_PUB.Count_And_Get

575: ( G_PKG_NAME,
576: l_api_name
577: );
578: END IF;
579: FND_MSG_PUB.Count_And_Get
580: ( p_count => x_msg_count,
581: p_data => x_msg_data
582: );
583: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 629: FND_MSG_PUB.initialize;

625: END IF;
626: -- Initialize API message list if necessary.
627: -- Initialize message list if p_init_msg_list is set to TRUE.
628: IF FND_API.to_Boolean(p_init_msg_list) THEN
629: FND_MSG_PUB.initialize;
630: END IF;
631:
632: ------------------------------
633:

Line 659: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

655: -- Standard call to get message count and if count is 1,
656: -- get message info.
657: -- The client will directly display the x_msg_data (which is already
658: -- translated) if the x_msg_count = 1;
659: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get
660: -- Server-side procedure to access the messages, and consolidate them
661: -- and display (or) to display one message after another.
662:
663: FND_MSG_PUB.Count_And_Get

Line 663: FND_MSG_PUB.Count_And_Get

659: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get
660: -- Server-side procedure to access the messages, and consolidate them
661: -- and display (or) to display one message after another.
662:
663: FND_MSG_PUB.Count_And_Get
664: ( p_count => x_msg_count,
665: p_data => x_msg_data
666: );
667:

Line 675: IF FND_MSG_PUB.Check_Msg_Level

671:
672: WHEN OTHERS THEN
673: ROLLBACK TO Update_Item_Stat_Attr_Vals_Pub;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
675: IF FND_MSG_PUB.Check_Msg_Level
676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg
679: ( G_PKG_NAME,

Line 676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

672: WHEN OTHERS THEN
673: ROLLBACK TO Update_Item_Stat_Attr_Vals_Pub;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
675: IF FND_MSG_PUB.Check_Msg_Level
676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg
679: ( G_PKG_NAME,
680: l_api_name

Line 678: FND_MSG_PUB.Add_Exc_Msg

674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
675: IF FND_MSG_PUB.Check_Msg_Level
676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg
679: ( G_PKG_NAME,
680: l_api_name
681: );
682: END IF;

Line 683: FND_MSG_PUB.Count_And_Get

679: ( G_PKG_NAME,
680: l_api_name
681: );
682: END IF;
683: FND_MSG_PUB.Count_And_Get
684: ( p_count => x_msg_count,
685: p_data => x_msg_data
686: );
687: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;