eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBU_ALERT_BIN dependencies on FND_API

Line 14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

10: -----------------------------------------------------------
11: -- Define procedure for rendering name.
12: -- ---------------------------------------------------------
13: procedure get_bin_name (p_api_version_number IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR := FND_API.G_FALSE,
16: p_bin_id IN NUMBER,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,

Line 15: p_commit IN VARCHAR := FND_API.G_FALSE,

11: -- Define procedure for rendering name.
12: -- ---------------------------------------------------------
13: procedure get_bin_name (p_api_version_number IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR := FND_API.G_FALSE,
16: p_bin_id IN NUMBER,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,

Line 24: x_return_status := FND_API.G_RET_STS_SUCCESS;

20: x_bin_name out NOCOPY VARCHAR2)
21: as
22: l_api_name CONSTANT VARCHAR2(30) := 'Get_Bin_Name';
23: begin
24: x_return_status := FND_API.G_RET_STS_SUCCESS;
25: x_bin_name := ibu_home_page_pvt.get_ak_bin_prompt ('IBU_HOM_CAT_ALERT');
26:
27: EXCEPTION
28: WHEN OTHERS THEN

Line 29: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

25: x_bin_name := ibu_home_page_pvt.get_ak_bin_prompt ('IBU_HOM_CAT_ALERT');
26:
27: EXCEPTION
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);

Line 47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

43: -----------------------------------------------------------
44: -- Define procedure for email text.
45: -- ---------------------------------------------------------
46: procedure get_email_text(p_api_version_number IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR := FND_API.G_FALSE,
49: p_user_id IN NUMBER,
50: p_lang_code IN VARCHAR2,
51: p_bin_id IN NUMBER,

Line 48: p_commit IN VARCHAR := FND_API.G_FALSE,

44: -- Define procedure for email text.
45: -- ---------------------------------------------------------
46: procedure get_email_text(p_api_version_number IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR := FND_API.G_FALSE,
49: p_user_id IN NUMBER,
50: p_lang_code IN VARCHAR2,
51: p_bin_id IN NUMBER,
52: x_return_status OUT NOCOPY VARCHAR2,

Line 82: IF FND_API.to_Boolean( p_init_msg_list ) THEN

78: l_supplier_id fnd_user.supplier_id%TYPE;
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;

Line 86: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
88: -- API Body
89:
90: -- do validation

Line 92: x_return_status := FND_API.G_RET_STS_ERROR;

88: -- API Body
89:
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;

Line 95: RAISE FND_API.G_EXC_ERROR;

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;
99: request_obj.start_record_position := 1;

Line 109: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

105: x_return_status => x_return_status,
106: x_msg_count => x_msg_count,
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;

Line 112: RAISE FND_API.G_EXC_ERROR;

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');
116: IF l_more is NULL OR l_more ='' THEN

Line 191: if NOT (x_return_status = FND_API.G_RET_STS_SUCCESS)

187: x_items_array => items_array);
188:
189: /*dbms_output.put_line('return_status is ' || return_status); */
190:
191: if NOT (x_return_status = FND_API.G_RET_STS_SUCCESS)
192: THEN
193: tmp_str := fnd_message.get_string('IBU', 'IBU_HOM_ITEMS_ERROR');
194: dbms_lob.writeappend(res_clob, length(tmp_str), tmp_str);
195: dbms_lob.writeappend(res_clob, length(newln), newln);

Line 226: IF FND_API.To_Boolean( p_commit ) THEN

222:
223: -- End of API Body
224:
225: -- Standard check of p_commit.
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

Line 235: WHEN FND_API.G_EXC_ERROR THEN

231: (p_count => x_msg_count ,
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: );

Line 242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

238: p_data => x_msg_data
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

Line 256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

252: -----------------------------------------------------------
253: -- Define procedure for rendering html.
254: -- ---------------------------------------------------------
255: procedure get_html (p_api_version_number IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_commit IN VARCHAR := FND_API.G_FALSE,
258: p_bin_id IN NUMBER,
259: p_cookie_url IN VARCHAR2,
260: x_return_status OUT NOCOPY VARCHAR2,

Line 257: p_commit IN VARCHAR := FND_API.G_FALSE,

253: -- Define procedure for rendering html.
254: -- ---------------------------------------------------------
255: procedure get_html (p_api_version_number IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_commit IN VARCHAR := FND_API.G_FALSE,
258: p_bin_id IN NUMBER,
259: p_cookie_url IN VARCHAR2,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,

Line 317: IF FND_API.to_Boolean( p_init_msg_list ) THEN

313:
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;

Line 321: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
323: -- API Body
324:
325: -- do validation

Line 327: x_return_status := FND_API.G_RET_STS_ERROR;

323: -- API Body
324:
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;

Line 330: RAISE FND_API.G_EXC_ERROR;

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
334:

Line 342: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

338: x_return_status => x_return_status,
339: x_msg_count => x_msg_count,
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;

Line 345: RAISE FND_API.G_EXC_ERROR;

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');
349: IF l_more is NULL OR l_more ='' THEN

Line 361: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

357: x_msg_data => x_msg_data,
358: p_bin_id => p_bin_id,
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;

Line 364: RAISE FND_API.G_EXC_ERROR;

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
368: batch_size := l_bin_info.row_number ;

Line 380: IF (NOT (x_return_status = FND_API.G_RET_STS_SUCCESS))

376: p_bin_id => p_bin_id,
377: x_filter_list => l_filter_list,
378: x_filter_string => l_filter_string);
379:
380: IF (NOT (x_return_status = FND_API.G_RET_STS_SUCCESS))
381: OR l_filter_string is null THEN
382: -- no filter criteria exist, so use hard coded default
383: x_return_status := FND_API.G_RET_STS_SUCCESS;
384: l_filter_string := 'end=5';

Line 383: x_return_status := FND_API.G_RET_STS_SUCCESS;

379:
380: IF (NOT (x_return_status = FND_API.G_RET_STS_SUCCESS))
381: OR l_filter_string is null THEN
382: -- no filter criteria exist, so use hard coded default
383: x_return_status := FND_API.G_RET_STS_SUCCESS;
384: l_filter_string := 'end=5';
385: ELSE
386: FOR l_curr_row IN 1..l_filter_list.count()
387: LOOP

Line 399: if l_bin_info.mandatory_flag = FND_API.G_FALSE then

395: END LOOP;
396: END IF;
397:
398: l_edit_url := IBU_Home_Page_PVT.get_edit_bin_url(p_bin_id, 'ibuhalrt.jsp', l_filter_string, p_cookie_url);
399: if l_bin_info.mandatory_flag = FND_API.G_FALSE then
400: l_close_url := IBU_Home_Page_PVT.get_close_bin_url(p_bin_id, p_cookie_url);
401: else
402: l_close_url := null;
403: end if;

Line 449: if l_bin_info.mandatory_flag = FND_API.G_FALSE then

445: dbms_lob.writeappend(res_clob,length(newln), newln);
446: tmp_str := '';
447: dbms_lob.writeappend(res_clob,length(tmp_str), tmp_str);
448:
449: if l_bin_info.mandatory_flag = FND_API.G_FALSE then
450: tmp_str := '';
451: dbms_lob.writeappend(res_clob,length(tmp_str), tmp_str);
452: end if;
453:

Line 553: if NOT (x_return_status = FND_API.G_RET_STS_SUCCESS)

549: x_return_obj => return_obj,
550: x_items_array => items_array);
551:
552: --dbms_output.put_line ('got items for user' || resource_id);
553: if NOT (x_return_status = FND_API.G_RET_STS_SUCCESS)
554: THEN
555: x_return_status := FND_API.G_RET_STS_SUCCESS;
556: tmp_str := ''
557: || FND_MESSAGE.GET_STRING('IBU', 'IBU_HOM_ITEMS_ERROR')

Line 555: x_return_status := FND_API.G_RET_STS_SUCCESS;

551:
552: --dbms_output.put_line ('got items for user' || resource_id);
553: if NOT (x_return_status = FND_API.G_RET_STS_SUCCESS)
554: THEN
555: x_return_status := FND_API.G_RET_STS_SUCCESS;
556: tmp_str := ''
557: || FND_MESSAGE.GET_STRING('IBU', 'IBU_HOM_ITEMS_ERROR')
558: || '';
559: dbms_lob.writeappend(res_clob,length(tmp_str),tmp_str);

Line 588: if NOT (x_return_status = FND_API.G_RET_STS_SUCCESS)

584: x_persp_array => item_persp_array,
585: x_author_array => item_author_array,
586: x_keyword_array => item_keyword_array);
587:
588: if NOT (x_return_status = FND_API.G_RET_STS_SUCCESS)
589: THEN
590: x_return_status := FND_API.G_RET_STS_SUCCESS;
591: --dbms_output.put_line('Error while getting Item for this user');
592: tmp_str := ''

Line 590: x_return_status := FND_API.G_RET_STS_SUCCESS;

586: x_keyword_array => item_keyword_array);
587:
588: if NOT (x_return_status = FND_API.G_RET_STS_SUCCESS)
589: THEN
590: x_return_status := FND_API.G_RET_STS_SUCCESS;
591: --dbms_output.put_line('Error while getting Item for this user');
592: tmp_str := ''
593: || FND_MESSAGE.GET_STRING('IBU', 'IBU_HOM_ITEMS_ERROR')
594: || '';

Line 649: END IF; -- if NOT (x_return_status = FND_API.G_RET_STS_SUCCESS)

645: dbms_lob.writeappend(res_clob,5,'');
646: dbms_lob.writeappend(res_clob, length(newln), newln);
647: end if;
648:
649: END IF; -- if NOT (x_return_status = FND_API.G_RET_STS_SUCCESS)
650:
651: END IF ; -- IF (resource_id IS NULL)
652:
653: if l_more_msg_data = TRUE then

Line 659: FND_API.G_FALSE

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 || '';
662: dbms_lob.writeappend(res_clob, length(tmp_str), tmp_str);
663: dbms_lob.writeappend(res_clob, length(newln), newln);

Line 694: IF FND_API.To_Boolean( p_commit ) THEN

690:
691: -- End of API Body
692:
693: -- Standard check of p_commit.
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

Line 703: WHEN FND_API.G_EXC_ERROR THEN

699: (p_count => x_msg_count ,
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: );

Line 710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

706: p_data => x_msg_data
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