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_MES_BIN dependencies on FND_API

Line 56: l_init_msg_list := FND_API.G_TRUE;

52: ind NUMBER := 1;
53: begin
54:
55: l_api_version := 1.0;
56: l_init_msg_list := FND_API.G_TRUE;
57: l_application_id := app_Id;
58: l_perz_data_name := 'IBU_A_CATEGORY';
59: l_profile_name := 'IBU_A_PROFILE00';
60:

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

109: -----------------------------------------------------------
110: -- Define procedure for rendering name.
111: -- ---------------------------------------------------------
112: procedure get_bin_name (p_api_version_number IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR := FND_API.G_FALSE,
115: p_bin_id IN NUMBER,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,

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

110: -- Define procedure for rendering name.
111: -- ---------------------------------------------------------
112: procedure get_bin_name (p_api_version_number IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR := FND_API.G_FALSE,
115: p_bin_id IN NUMBER,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,

Line 125: x_return_status := FND_API.G_RET_STS_SUCCESS;

121: l_api_name CONSTANT VARCHAR2(30) := 'Get_Bin_Name';
122: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;
123: l_cat_id NUMBER := null;
124: begin
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126: x_bin_name := '';
127:
128: -- get the bin info
129: IBU_Home_Page_PVT.get_bin_info(p_api_version_number => p_api_version_number,

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

133: x_msg_data => x_msg_data,
134: p_bin_id => p_bin_id,
135: x_bin_info => l_bin_info);
136:
137: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
138: raise NO_DATA_FOUND;
139: END IF;
140:
141: l_cat_id := l_bin_info.MES_cat_ID;

Line 152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

148: end if;
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

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

165: -----------------------------------------------------------
166: -- Define procedure for email text.
167: -- ---------------------------------------------------------
168: procedure get_email_text(p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR := FND_API.G_FALSE,
171: p_user_id IN NUMBER,
172: p_lang_code IN VARCHAR2,
173: p_bin_id IN NUMBER,

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

166: -- Define procedure for email text.
167: -- ---------------------------------------------------------
168: procedure get_email_text(p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR := FND_API.G_FALSE,
171: p_user_id IN NUMBER,
172: p_lang_code IN VARCHAR2,
173: p_bin_id IN NUMBER,
174: x_return_status OUT NOCOPY VARCHAR2,

Line 223: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 227: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
229: -- API Body
230:
231: -- do validation

Line 233: x_return_status := FND_API.G_RET_STS_ERROR;

229: -- API Body
230:
231: -- do validation
232: IF p_bin_id is NULL OR p_user_id is null THEN
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: RETURN;
235: END IF;
236:
237: -- Get the bin name

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

243: x_msg_data => x_msg_data,
244: x_bin_name => l_bin_name);
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;

Line 250: RAISE FND_API.G_EXC_ERROR;

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,
254: p_init_msg_list => p_init_msg_list,

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

257: x_msg_data => x_msg_data,
258: p_bin_id => p_bin_id,
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;

Line 264: RAISE FND_API.G_EXC_ERROR;

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;
268: IF (category_id is NULL)

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: category_id := l_bin_info.MES_cat_ID;
268: IF (category_id is NULL)
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;

Line 274: RAISE FND_API.G_EXC_ERROR;

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,
278: x_return_status => x_return_status,

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

282: p_bin_id => p_bin_id,
283: x_filter_list => l_filter_list,
284: x_filter_string => l_filter_string);
285:
286: IF (NOT (x_return_status = FND_API.G_RET_STS_SUCCESS))
287: OR l_filter_string is null THEN
288: -- no filter criteria exist, so use hard coded default
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290: l_filter_string := 'end=3';

Line 289: x_return_status := FND_API.G_RET_STS_SUCCESS;

285:
286: IF (NOT (x_return_status = FND_API.G_RET_STS_SUCCESS))
287: OR l_filter_string is null THEN
288: -- no filter criteria exist, so use hard coded default
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290: l_filter_string := 'end=3';
291: ELSE
292: FOR l_curr_row IN 1..l_filter_list.count()
293: LOOP

Line 321: RAISE FND_API.G_EXC_ERROR;

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: ---------------------------------------------------------------------------
325: channel_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_CHANNEL');

Line 355: x_return_status := FND_API.G_RET_STS_SUCCESS;

351: x_content_chan_array => channels_array);
352:
353: if (x_return_status = 'F')
354: THEN
355: x_return_status := FND_API.G_RET_STS_SUCCESS;
356: dbms_lob.writeappend(res_clob,length(newln), newln);
357: tmp_str := FND_MESSAGE.GET_STRING('IBU', 'IBU_HOM_ITEMS_ERROR');
358: dbms_lob.writeappend(res_clob,length(tmp_str), tmp_str);
359: dbms_lob.writeappend(res_clob,length(newln), newln);

Line 393: x_return_status := FND_API.G_RET_STS_SUCCESS;

389: x_document_id_array => items_array);
390:
391: if (x_return_status = 'F')
392: THEN
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394: dbms_lob.writeappend(res_clob,length(newln), newln);
395: tmp_str := FND_MESSAGE.GET_STRING('IBU', 'IBU_HOM_ITEMS_ERROR');
396: dbms_lob.writeappend(res_clob,length(tmp_str), tmp_str);
397: dbms_lob.writeappend(res_clob,length(newln), newln);

Line 419: x_return_status := FND_API.G_RET_STS_SUCCESS;

415:
416: if (x_return_status = 'F')
417:
418: THEN
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420: dbms_lob.writeappend(res_clob,length(newln), newln);
421: tmp_str := FND_MESSAGE.GET_STRING('IBU', 'IBU_HOM_ITEMS_ERROR');
422: dbms_lob.writeappend(res_clob,length(tmp_str), tmp_str);
423: dbms_lob.writeappend(res_clob,length(newln), newln);

Line 442: WHEN FND_API.G_EXC_ERROR THEN

438: end loop;
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: );

Line 450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

446: );
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

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

461: -----------------------------------------------------------
462: -- Define procedure for rendering html.
463: -- ---------------------------------------------------------
464: procedure get_html (p_api_version_number IN NUMBER,
465: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
466: p_commit IN VARCHAR := FND_API.G_FALSE,
467: p_bin_id IN NUMBER,
468: p_cookie_url IN VARCHAR2,
469: x_return_status OUT NOCOPY VARCHAR2,

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

462: -- Define procedure for rendering html.
463: -- ---------------------------------------------------------
464: procedure get_html (p_api_version_number IN NUMBER,
465: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
466: p_commit IN VARCHAR := FND_API.G_FALSE,
467: p_bin_id IN NUMBER,
468: p_cookie_url IN VARCHAR2,
469: x_return_status OUT NOCOPY VARCHAR2,
470: x_msg_count OUT NOCOPY NUMBER,

Line 527: no_items_exist VARCHAR2(100) := FND_API.G_TRUE;

523: no_items_fnd VARCHAR2(1000);
524: DETAIL_URL VARCHAR2(5000) := 'ibukmipc.jsp';
525: url VARCHAR2(5000);
526:
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;

Line 530: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 534: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
536: -- API Body
537:
538: -- do validation

Line 540: x_return_status := FND_API.G_RET_STS_ERROR;

536: -- API Body
537:
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;

Line 543: RAISE FND_API.G_EXC_ERROR;

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

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

552: x_msg_count => x_msg_count,
553: x_msg_data => x_msg_data,
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;

Line 559: RAISE FND_API.G_EXC_ERROR;

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,
563: p_init_msg_list => p_init_msg_list,

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

566: x_msg_data => x_msg_data,
567: p_bin_id => p_bin_id,
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;

Line 573: RAISE FND_API.G_EXC_ERROR;

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;
577: IF (category_id is NULL)

Line 580: x_return_status := FND_API.G_RET_STS_ERROR;

576: category_id := l_bin_info.MES_cat_ID;
577: IF (category_id is NULL)
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;

Line 583: RAISE FND_API.G_EXC_ERROR;

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,
587: x_return_status => x_return_status,

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

591: p_bin_id => p_bin_id,
592: x_filter_list => l_filter_list,
593: x_filter_string => l_filter_string);
594:
595: IF (NOT (x_return_status = FND_API.G_RET_STS_SUCCESS))
596: OR l_filter_string is null THEN
597: -- no filter criteria exist, so use hard coded default
598: x_return_status := FND_API.G_RET_STS_SUCCESS;
599: l_filter_string := 'end=3';

Line 598: x_return_status := FND_API.G_RET_STS_SUCCESS;

594:
595: IF (NOT (x_return_status = FND_API.G_RET_STS_SUCCESS))
596: OR l_filter_string is null THEN
597: -- no filter criteria exist, so use hard coded default
598: x_return_status := FND_API.G_RET_STS_SUCCESS;
599: l_filter_string := 'end=3';
600: ELSE
601: FOR l_curr_row IN 1..l_filter_list.count()
602: LOOP

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

611: END IF;
612:
613: l_edit_url := IBU_Home_Page_PVT.get_edit_bin_url(p_bin_id, 'ibuhmesc.jsp', l_filter_string, p_cookie_url);
614:
615: if l_bin_info.mandatory_flag = FND_API.G_FALSE then
616: l_close_url := IBU_Home_Page_PVT.get_close_bin_url(p_bin_id, p_cookie_url);
617: else
618: l_close_url := null;
619: end if;

Line 656: RAISE FND_API.G_EXC_ERROR;

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: ---------------------------------------------------------------------------
660: channel_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_CHANNEL');

Line 686: x_return_status := FND_API.G_RET_STS_SUCCESS;

682:
683: if (x_return_status = 'F')
684: THEN
685: /* dbms_output.put_line(' Items Error='); */
686: x_return_status := FND_API.G_RET_STS_SUCCESS;
687: dbms_lob.writeappend(res_clob,6, ' ');
688: dbms_lob.writeappend(res_clob,length(newln), newln);
689: dbms_lob.writeappend(res_clob,length(newln), newln);
690: tmp_str := FND_MESSAGE.GET_STRING('IBU', 'IBU_HOM_ITEMS_ERROR');

Line 714: no_items_exist := FND_API.G_FALSE;

710: tmp_str := '';
711: dbms_lob.writeappend(res_clob,length(tmp_str),tmp_str);
712:
713: -- ujagarla - If there is no content, then we need to show a message
714: no_items_exist := FND_API.G_FALSE;
715:
716: -- Start converting channel name to URL format
717: urlformat_channel_name := '';
718: channel_name:= channels_array(k).NAME;

Line 753: x_return_status := FND_API.G_RET_STS_SUCCESS;

749:
750: if (x_return_status = 'F')
751: THEN
752: /* dbms_output.put_line('No Items for this chanel='); */
753: x_return_status := FND_API.G_RET_STS_SUCCESS;
754: dbms_lob.writeappend(res_clob,6, ' ');
755: dbms_lob.writeappend(res_clob,length(newln), newln);
756: tmp_str := FND_MESSAGE.GET_STRING('IBU', 'IBU_HOM_ITEMS_ERROR');
757: res_str := ' ';
877: dbms_lob.writeappend(res_clob,length(tmp_str),tmp_str);
878:
879: -- ujagarla - If there is no content, then we need to show a message
880: no_items_exist := FND_API.G_FALSE;
881:
882: -- Start converting channel name to URL format
883: urlformat_channel_name := '';
884: channel_name:= channels_array(k).NAME;

Line 919: x_return_status := FND_API.G_RET_STS_SUCCESS;

915:
916: if (x_return_status = 'F')
917: THEN
918: /* dbms_output.put_line('No Items for this chanel='); */
919: x_return_status := FND_API.G_RET_STS_SUCCESS;
920: dbms_lob.writeappend(res_clob,6, ' ');
921: dbms_lob.writeappend(res_clob,length(newln), newln);
922: tmp_str := FND_MESSAGE.GET_STRING('IBU', 'IBU_HOM_ITEMS_ERROR');
923: res_str := ' '
1003: || FND_MESSAGE.GET_STRING('IBU', 'IBU_HOM_NO_ITEMS_FOUND')
1004: || '';
1005: dbms_lob.writeappend(res_clob,length(tmp_str),tmp_str);

Line 1039: IF FND_API.To_Boolean( p_commit ) THEN

1035: dbms_lob.freetemporary(res_clob);
1036:
1037: -- End of API Body
1038: -- Standard check of p_commit.
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

Line 1048: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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