DBA Data[Home] [Help]

APPS.IBU_MES_BIN dependencies on FND_MSG_PUB

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

149:
150: EXCEPTION
151: WHEN OTHERS THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
153: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
154: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
155: END IF;
156: FND_MSG_PUB.Count_And_Get
157: (

Line 154: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);

150: EXCEPTION
151: WHEN OTHERS THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
153: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
154: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
155: END IF;
156: FND_MSG_PUB.Count_And_Get
157: (
158: p_count => x_msg_count ,

Line 156: FND_MSG_PUB.Count_And_Get

152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
153: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
154: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
155: END IF;
156: FND_MSG_PUB.Count_And_Get
157: (
158: p_count => x_msg_count ,
159: p_data => x_msg_data
160: );

Line 224: FND_MSG_PUB.initialize;

220: begin
221:
222: -- Initialize message list if p_init_msg_list is set to TRUE.
223: IF FND_API.to_Boolean( p_init_msg_list ) THEN
224: FND_MSG_PUB.initialize;
225: END IF;
226: -- Initialize API return status to success
227: x_return_status := FND_API.G_RET_STS_SUCCESS;
228:

Line 249: FND_MSG_PUB.Add;

245: /* dbms_output.put_line ('bin_name=' || l_bin_name); */
246:
247: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
248: FND_MESSAGE.SET_NAME('IBU','IBU_HOM_BINNAME_ERROR');
249: FND_MSG_PUB.Add;
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252:
253: IBU_Home_Page_PVT.get_bin_info(p_api_version_number => l_api_version,

Line 263: FND_MSG_PUB.Add;

259: x_bin_info => l_bin_info);
260:
261: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
262: FND_MESSAGE.SET_NAME('IBU','IBU_HOM_BININFO_ERROR');
263: FND_MSG_PUB.Add;
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:
267: category_id := l_bin_info.MES_cat_ID;

Line 273: FND_MSG_PUB.Add;

269: THEN
270: /* dbms_output.put_line('No Categories found='); */
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: FND_MESSAGE.SET_NAME('IBU', 'IBU_HOM_NO_CAT_FOR_CNEWS');
273: FND_MSG_PUB.Add;
274: RAISE FND_API.G_EXC_ERROR;
275: END IF;
276:
277: IBU_Home_Page_PVT.get_filter_list(p_api_version => l_api_version,

Line 320: fnd_msg_pub.Add;

316: if (x_return_status = 'F')
317: THEN
318: /* dbms_output.put_line('No Items Found='); */
319: fnd_message.set_name('IBU', 'IBU_HOM_ITEMS_ERROR');
320: fnd_msg_pub.Add;
321: RAISE FND_API.G_EXC_ERROR;
322: END IF;
323:
324: ---------------------------------------------------------------------------

Line 443: FND_MSG_PUB.Count_And_Get

439: x_clob := res_clob;
440: dbms_lob.freetemporary(res_clob);
441: EXCEPTION
442: WHEN FND_API.G_EXC_ERROR THEN
443: FND_MSG_PUB.Count_And_Get
444: (p_count => x_msg_count ,
445: p_data => x_msg_data
446: );
447:

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

447:
448: WHEN OTHERS THEN
449: -- ROLLBACK TO Get_Filter;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
452: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
453: END IF;
454: FND_MSG_PUB.Count_And_Get
455: (p_count => x_msg_count ,

Line 452: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);

448: WHEN OTHERS THEN
449: -- ROLLBACK TO Get_Filter;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
452: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
453: END IF;
454: FND_MSG_PUB.Count_And_Get
455: (p_count => x_msg_count ,
456: p_data => x_msg_data

Line 454: FND_MSG_PUB.Count_And_Get

450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
452: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
453: END IF;
454: FND_MSG_PUB.Count_And_Get
455: (p_count => x_msg_count ,
456: p_data => x_msg_data
457: );
458:

Line 531: FND_MSG_PUB.initialize;

527: no_items_exist VARCHAR2(100) := FND_API.G_TRUE;
528: begin
529: -- Initialize message list if p_init_msg_list is set to TRUE.
530: IF FND_API.to_Boolean( p_init_msg_list ) THEN
531: FND_MSG_PUB.initialize;
532: END IF;
533: -- Initialize API return status to success
534: x_return_status := FND_API.G_RET_STS_SUCCESS;
535:

Line 542: FND_MSG_PUB.Add;

538: -- do validation
539: IF p_bin_id is NULL THEN
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: FND_MESSAGE.SET_NAME('IBU','IBU_HOM_BIN_ID_MISSING');
542: FND_MSG_PUB.Add;
543: RAISE FND_API.G_EXC_ERROR;
544: END IF;
545:
546: -- Get the bin name, the mandatory flag

Line 558: FND_MSG_PUB.Add;

554: x_bin_name => l_bin_name);
555:
556: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
557: FND_MESSAGE.SET_NAME('IBU','IBU_HOM_BINNAME_ERROR');
558: FND_MSG_PUB.Add;
559: RAISE FND_API.G_EXC_ERROR;
560: END IF;
561:
562: IBU_Home_Page_PVT.get_bin_info(p_api_version_number => l_api_version,

Line 572: FND_MSG_PUB.Add;

568: x_bin_info => l_bin_info);
569:
570: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
571: FND_MESSAGE.SET_NAME('IBU','IBU_HOM_BININFO_ERROR');
572: FND_MSG_PUB.Add;
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
575:
576: category_id := l_bin_info.MES_cat_ID;

Line 582: FND_MSG_PUB.Add;

578: THEN
579: /* dbms_output.put_line('No Categories found=');*/
580: x_return_status := FND_API.G_RET_STS_ERROR;
581: FND_MESSAGE.SET_NAME('IBU', 'IBU_HOM_NO_CAT_FOR_CNEWS');
582: FND_MSG_PUB.Add;
583: RAISE FND_API.G_EXC_ERROR;
584: END IF;
585:
586: IBU_Home_Page_PVT.get_filter_list(p_api_version => l_api_version,

Line 655: fnd_msg_pub.Add;

651: if (x_return_status = 'F')
652: THEN
653: /* dbms_output.put_line('No Items Found='); */
654: fnd_message.set_name('IBU', 'IBU_HOM_ITEMS_ERROR');
655: fnd_msg_pub.Add;
656: RAISE FND_API.G_EXC_ERROR;
657: END IF;
658:
659: ---------------------------------------------------------------------------

Line 1043: FND_MSG_PUB.Count_And_Get

1039: IF FND_API.To_Boolean( p_commit ) THEN
1040: COMMIT WORK;
1041: END IF;
1042: -- Standard call to get message count and if count is 1, get message info.
1043: FND_MSG_PUB.Count_And_Get
1044: (p_count => x_msg_count ,
1045: p_data => x_msg_data
1046: );
1047: EXCEPTION

Line 1049: FND_MSG_PUB.Count_And_Get

1045: p_data => x_msg_data
1046: );
1047: EXCEPTION
1048: WHEN FND_API.G_EXC_ERROR THEN
1049: FND_MSG_PUB.Count_And_Get
1050: (p_count => x_msg_count ,
1051: p_data => x_msg_data
1052: );
1053: WHEN OTHERS THEN

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

1052: );
1053: WHEN OTHERS THEN
1054: -- ROLLBACK TO Get_Filter;
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1057: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1058: END IF;
1059: FND_MSG_PUB.Count_And_Get
1060: (p_count => x_msg_count ,

Line 1057: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);

1053: WHEN OTHERS THEN
1054: -- ROLLBACK TO Get_Filter;
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1057: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1058: END IF;
1059: FND_MSG_PUB.Count_And_Get
1060: (p_count => x_msg_count ,
1061: p_data => x_msg_data

Line 1059: FND_MSG_PUB.Count_And_Get

1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1057: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1058: END IF;
1059: FND_MSG_PUB.Count_And_Get
1060: (p_count => x_msg_count ,
1061: p_data => x_msg_data
1062: );
1063: raise;