DBA Data[Home] [Help]

APPS.IBU_ALERT_BIN dependencies on FND_MSG_PUB

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

28: WHEN OTHERS THEN
29: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
30: x_bin_name := 'Alerts';
31:
32: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
33: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
34: END IF;
35: FND_MSG_PUB.Count_And_Get
36: (

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

29: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
30: x_bin_name := 'Alerts';
31:
32: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
33: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
34: END IF;
35: FND_MSG_PUB.Count_And_Get
36: (
37: p_count => x_msg_count ,

Line 35: FND_MSG_PUB.Count_And_Get

31:
32: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
33: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
34: END IF;
35: FND_MSG_PUB.Count_And_Get
36: (
37: p_count => x_msg_count ,
38: p_data => x_msg_data
39: );

Line 83: FND_MSG_PUB.initialize;

79:
80: begin
81: -- Initialize message list if p_init_msg_list is set to TRUE.
82: IF FND_API.to_Boolean( p_init_msg_list ) THEN
83: FND_MSG_PUB.initialize;
84: END IF;
85: -- Initialize API return status to success
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:

Line 94: FND_MSG_PUB.Add;

90: -- do validation
91: IF p_bin_id is NULL OR p_user_id is null THEN
92: x_return_status := FND_API.G_RET_STS_ERROR;
93: FND_MESSAGE.SET_NAME('IBU','IBU_HOM_BIN_ID_MISSING');
94: FND_MSG_PUB.Add;
95: RAISE FND_API.G_EXC_ERROR;
96: END IF;
97:
98: request_obj.records_requested := batch_size;

Line 111: FND_MSG_PUB.Add;

107: x_msg_data => x_msg_data,
108: x_bin_name => l_bin_name);
109: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
110: FND_MESSAGE.SET_NAME('IBU','IBU_HOM_BINNAME_ERROR');
111: FND_MSG_PUB.Add;
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114:
115: l_more := ibu_home_page_pvt.get_ak_bin_prompt ('IBU_HOM_CAT_MORE');

Line 230: FND_MSG_PUB.Count_And_Get

226: IF FND_API.To_Boolean( p_commit ) THEN
227: COMMIT WORK;
228: END IF;
229: -- Standard call to get message count and if count is 1, get message info.
230: FND_MSG_PUB.Count_And_Get
231: (p_count => x_msg_count ,
232: p_data => x_msg_data
233: );
234: EXCEPTION

Line 236: FND_MSG_PUB.Count_And_Get

232: p_data => x_msg_data
233: );
234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR THEN
236: FND_MSG_PUB.Count_And_Get
237: (p_count => x_msg_count ,
238: p_data => x_msg_data
239: );
240: WHEN OTHERS THEN

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

239: );
240: WHEN OTHERS THEN
241: -- ROLLBACK TO Get_Filter;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
244: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
245: END IF;
246: FND_MSG_PUB.Count_And_Get
247: (p_count => x_msg_count ,

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

240: WHEN OTHERS THEN
241: -- ROLLBACK TO Get_Filter;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
244: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
245: END IF;
246: FND_MSG_PUB.Count_And_Get
247: (p_count => x_msg_count ,
248: p_data => x_msg_data

Line 246: FND_MSG_PUB.Count_And_Get

242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
244: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
245: END IF;
246: FND_MSG_PUB.Count_And_Get
247: (p_count => x_msg_count ,
248: p_data => x_msg_data
249: );
250: end get_email_text;

Line 318: FND_MSG_PUB.initialize;

314: begin
315:
316: -- Initialize message list if p_init_msg_list is set to TRUE.
317: IF FND_API.to_Boolean( p_init_msg_list ) THEN
318: FND_MSG_PUB.initialize;
319: END IF;
320: -- Initialize API return status to success
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322:

Line 329: FND_MSG_PUB.Add;

325: -- do validation
326: IF p_bin_id is NULL THEN
327: x_return_status := FND_API.G_RET_STS_ERROR;
328: FND_MESSAGE.SET_NAME('IBU','IBU_HOM_BIN_ID_MISSING');
329: FND_MSG_PUB.Add;
330: RAISE FND_API.G_EXC_ERROR;
331: END IF;
332:
333: -- Get the bin name, the mandatory flag

Line 344: FND_MSG_PUB.Add;

340: x_msg_data => x_msg_data,
341: x_bin_name => l_bin_name);
342: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
343: FND_MESSAGE.SET_NAME('IBU','IBU_HOM_BINNAME_ERROR');
344: FND_MSG_PUB.Add;
345: RAISE FND_API.G_EXC_ERROR;
346: END IF;
347:
348: l_more := ibu_home_page_pvt.get_ak_bin_prompt ('IBU_HOM_CAT_MORE');

Line 363: FND_MSG_PUB.Add;

359: x_bin_info => l_bin_info);
360:
361: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
362: FND_MESSAGE.SET_NAME('IBU','IBU_HOM_BININFO_ERROR');
363: FND_MSG_PUB.Add;
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:
367: if l_bin_info.row_number > -1 then

Line 657: l_msg_data := FND_MSG_PUB.GET(

653: if l_more_msg_data = TRUE then
654: -- need to add more error messages to clob
655: l_msg_index := 1;
656: WHILE x_msg_count > 0 LOOP
657: l_msg_data := FND_MSG_PUB.GET(
658: l_msg_index,
659: FND_API.G_FALSE
660: );
661: tmp_str := '' || l_msg_data || '';

Line 698: FND_MSG_PUB.Count_And_Get

694: IF FND_API.To_Boolean( p_commit ) THEN
695: COMMIT WORK;
696: END IF;
697: -- Standard call to get message count and if count is 1, get message info.
698: FND_MSG_PUB.Count_And_Get
699: (p_count => x_msg_count ,
700: p_data => x_msg_data
701: );
702: EXCEPTION

Line 704: FND_MSG_PUB.Count_And_Get

700: p_data => x_msg_data
701: );
702: EXCEPTION
703: WHEN FND_API.G_EXC_ERROR THEN
704: FND_MSG_PUB.Count_And_Get
705: (p_count => x_msg_count ,
706: p_data => x_msg_data
707: );
708: WHEN OTHERS THEN

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

707: );
708: WHEN OTHERS THEN
709: -- ROLLBACK TO Get_Filter;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
713: END IF;
714: FND_MSG_PUB.Count_And_Get
715: (p_count => x_msg_count ,

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

708: WHEN OTHERS THEN
709: -- ROLLBACK TO Get_Filter;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
713: END IF;
714: FND_MSG_PUB.Count_And_Get
715: (p_count => x_msg_count ,
716: p_data => x_msg_data

Line 714: FND_MSG_PUB.Count_And_Get

710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
713: END IF;
714: FND_MSG_PUB.Count_And_Get
715: (p_count => x_msg_count ,
716: p_data => x_msg_data
717: );
718: end get_html;