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.BIS_VG_REPOSITORY_MEDIATOR dependencies on FND_API

Line 53: --- x_return_status := FND_API.G_RET_STS_SUCCESS;

49: --
50: BEGIN
51:
52: BIS_DEBUG_PUB.Add('> init_string_generator');
53: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
54: l_statement := l_statement || '''' || p_View_Name || '''';
55: g_cursor := DBMS_SQL.OPEN_CURSOR;
56: DBMS_SQL.PARSE(g_cursor, l_statement, DBMS_SQL.NATIVE);
57: DBMS_SQL.DEFINE_COLUMN_LONG(g_cursor, 1);

Line 65: when FND_API.G_EXC_ERROR then

61: BIS_DEBUG_PUB.Add('< init_string_generator');
62:
63:
64: EXCEPTION
65: when FND_API.G_EXC_ERROR then
66: --- x_return_status := FND_API.G_RET_STS_ERROR ;
67: RAISE FND_API.G_EXC_ERROR;
68: when FND_API.G_EXC_UNEXPECTED_ERROR then
69: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 66: --- x_return_status := FND_API.G_RET_STS_ERROR ;

62:
63:
64: EXCEPTION
65: when FND_API.G_EXC_ERROR then
66: --- x_return_status := FND_API.G_RET_STS_ERROR ;
67: RAISE FND_API.G_EXC_ERROR;
68: when FND_API.G_EXC_UNEXPECTED_ERROR then
69: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 67: RAISE FND_API.G_EXC_ERROR;

63:
64: EXCEPTION
65: when FND_API.G_EXC_ERROR then
66: --- x_return_status := FND_API.G_RET_STS_ERROR ;
67: RAISE FND_API.G_EXC_ERROR;
68: when FND_API.G_EXC_UNEXPECTED_ERROR then
69: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: when others then

Line 68: when FND_API.G_EXC_UNEXPECTED_ERROR then

64: EXCEPTION
65: when FND_API.G_EXC_ERROR then
66: --- x_return_status := FND_API.G_RET_STS_ERROR ;
67: RAISE FND_API.G_EXC_ERROR;
68: when FND_API.G_EXC_UNEXPECTED_ERROR then
69: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: when others then
72: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 69: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

65: when FND_API.G_EXC_ERROR then
66: --- x_return_status := FND_API.G_RET_STS_ERROR ;
67: RAISE FND_API.G_EXC_ERROR;
68: when FND_API.G_EXC_UNEXPECTED_ERROR then
69: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: when others then
72: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: BIS_VG_UTIL.Add_Error_Message

Line 70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

66: --- x_return_status := FND_API.G_RET_STS_ERROR ;
67: RAISE FND_API.G_EXC_ERROR;
68: when FND_API.G_EXC_UNEXPECTED_ERROR then
69: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: when others then
72: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: BIS_VG_UTIL.Add_Error_Message
74: ( p_error_msg_id => SQLCODE

Line 72: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

68: when FND_API.G_EXC_UNEXPECTED_ERROR then
69: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: when others then
72: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: BIS_VG_UTIL.Add_Error_Message
74: ( p_error_msg_id => SQLCODE
75: , p_error_description => SQLERRM
76: , p_error_proc_name => G_PKG_NAME||'.string_generator_init'

Line 80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

76: , p_error_proc_name => G_PKG_NAME||'.string_generator_init'
77: , p_error_table => x_error_tbl
78: , x_error_table => x_error_tbl
79: );
80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
81:
82: END string_generator_init;
83:
84: -- ============================================================================

Line 108: --- x_return_status := FND_API.G_RET_STS_SUCCESS;

104: l_dummy VARCHAR2(1000);
105: l_chunk_size_ret INTEGER;
106: BEGIN
107: BIS_DEBUG_PUB.Add('> String_Generator_Get_String');
108: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
109: DBMS_SQL.COLUMN_VALUE_LONG( g_cursor
110: , 1
111: , p_chunk_size
112: , g_current_posn

Line 139: when FND_API.G_EXC_ERROR then

135: BIS_DEBUG_PUB.Add('< String_Generator_Get_String');
136:
137:
138: EXCEPTION
139: when FND_API.G_EXC_ERROR then
140: --- x_return_status := FND_API.G_RET_STS_ERROR ;
141: RAISE FND_API.G_EXC_ERROR;
142: when FND_API.G_EXC_UNEXPECTED_ERROR then
143: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 140: --- x_return_status := FND_API.G_RET_STS_ERROR ;

136:
137:
138: EXCEPTION
139: when FND_API.G_EXC_ERROR then
140: --- x_return_status := FND_API.G_RET_STS_ERROR ;
141: RAISE FND_API.G_EXC_ERROR;
142: when FND_API.G_EXC_UNEXPECTED_ERROR then
143: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 141: RAISE FND_API.G_EXC_ERROR;

137:
138: EXCEPTION
139: when FND_API.G_EXC_ERROR then
140: --- x_return_status := FND_API.G_RET_STS_ERROR ;
141: RAISE FND_API.G_EXC_ERROR;
142: when FND_API.G_EXC_UNEXPECTED_ERROR then
143: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: when others then

Line 142: when FND_API.G_EXC_UNEXPECTED_ERROR then

138: EXCEPTION
139: when FND_API.G_EXC_ERROR then
140: --- x_return_status := FND_API.G_RET_STS_ERROR ;
141: RAISE FND_API.G_EXC_ERROR;
142: when FND_API.G_EXC_UNEXPECTED_ERROR then
143: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: when others then
146: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 143: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

139: when FND_API.G_EXC_ERROR then
140: --- x_return_status := FND_API.G_RET_STS_ERROR ;
141: RAISE FND_API.G_EXC_ERROR;
142: when FND_API.G_EXC_UNEXPECTED_ERROR then
143: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: when others then
146: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
147: BIS_VG_UTIL.Add_Error_Message

Line 144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

140: --- x_return_status := FND_API.G_RET_STS_ERROR ;
141: RAISE FND_API.G_EXC_ERROR;
142: when FND_API.G_EXC_UNEXPECTED_ERROR then
143: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: when others then
146: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
147: BIS_VG_UTIL.Add_Error_Message
148: ( p_error_msg_id => SQLCODE

Line 146: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

142: when FND_API.G_EXC_UNEXPECTED_ERROR then
143: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: when others then
146: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
147: BIS_VG_UTIL.Add_Error_Message
148: ( p_error_msg_id => SQLCODE
149: , p_error_description => SQLERRM
150: , p_error_proc_name => G_PKG_NAME||'.String_Generator_Get_String'

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150: , p_error_proc_name => G_PKG_NAME||'.String_Generator_Get_String'
151: , p_error_table => x_error_tbl
152: , x_error_table => x_error_tbl
153: );
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155:
156: END String_Generator_Get_String;
157:
158:

Line 183: --- x_return_status := FND_API.G_RET_STS_SUCCESS;

179:
180: BEGIN
181:
182: BIS_DEBUG_PUB.Add('> create_View_Select_Text_Table');
183: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
184:
185: l_eod := FALSE;
186:
187: string_generator_init ( p_view_name

Line 210: when FND_API.G_EXC_ERROR then

206: BIS_DEBUG_PUB.Add('< create_View_Select_Text_Table');
207:
208:
209: EXCEPTION
210: when FND_API.G_EXC_ERROR then
211: DBMS_SQL.CLOSE_CURSOR(g_cursor);
212:
213: RAISE FND_API.G_EXC_ERROR;
214: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 213: RAISE FND_API.G_EXC_ERROR;

209: EXCEPTION
210: when FND_API.G_EXC_ERROR then
211: DBMS_SQL.CLOSE_CURSOR(g_cursor);
212:
213: RAISE FND_API.G_EXC_ERROR;
214: when FND_API.G_EXC_UNEXPECTED_ERROR then
215: DBMS_SQL.CLOSE_CURSOR(g_cursor);
216:
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 214: when FND_API.G_EXC_UNEXPECTED_ERROR then

210: when FND_API.G_EXC_ERROR then
211: DBMS_SQL.CLOSE_CURSOR(g_cursor);
212:
213: RAISE FND_API.G_EXC_ERROR;
214: when FND_API.G_EXC_UNEXPECTED_ERROR then
215: DBMS_SQL.CLOSE_CURSOR(g_cursor);
216:
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: when others then

Line 217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

213: RAISE FND_API.G_EXC_ERROR;
214: when FND_API.G_EXC_UNEXPECTED_ERROR then
215: DBMS_SQL.CLOSE_CURSOR(g_cursor);
216:
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: when others then
219: DBMS_SQL.CLOSE_CURSOR(g_cursor);
220:
221: BIS_VG_UTIL.Add_Error_Message

Line 228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

224: , p_error_proc_name => G_PKG_NAME||'.create_View_Select_Text_Table'
225: , p_error_table => x_error_tbl
226: , x_error_table => x_error_tbl
227: );
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229:
230: END create_View_Select_Text_Table;
231: ---
232: --- ============================================================================

Line 269: --- x_return_status := FND_API.G_RET_STS_SUCCESS;

265: order by COLUMN_ID;
266: --
267: BEGIN
268: BIS_DEBUG_PUB.Add('> create_View_Text_Tables');
269: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
270: --
271: l_Done := FALSE;
272: l_count := 1;
273: --

Line 294: when FND_API.G_EXC_ERROR then

290: --
291: BIS_DEBUG_PUB.Add('< create_View_Text_Tables');
292:
293: EXCEPTION
294: when FND_API.G_EXC_ERROR then
295:
296: CLOSE c_all_columns;
297: RAISE FND_API.G_EXC_ERROR;
298: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 297: RAISE FND_API.G_EXC_ERROR;

293: EXCEPTION
294: when FND_API.G_EXC_ERROR then
295:
296: CLOSE c_all_columns;
297: RAISE FND_API.G_EXC_ERROR;
298: when FND_API.G_EXC_UNEXPECTED_ERROR then
299:
300: CLOSE c_all_columns;
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 298: when FND_API.G_EXC_UNEXPECTED_ERROR then

294: when FND_API.G_EXC_ERROR then
295:
296: CLOSE c_all_columns;
297: RAISE FND_API.G_EXC_ERROR;
298: when FND_API.G_EXC_UNEXPECTED_ERROR then
299:
300: CLOSE c_all_columns;
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: when others then

Line 301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

297: RAISE FND_API.G_EXC_ERROR;
298: when FND_API.G_EXC_UNEXPECTED_ERROR then
299:
300: CLOSE c_all_columns;
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: when others then
303:
304: CLOSE c_all_columns;
305: BIS_VG_UTIL.Add_Error_Message

Line 312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

308: , p_error_proc_name => G_PKG_NAME||'.create_View_Text_Tables'
309: , p_error_table => x_error_tbl
310: , x_error_table => x_error_tbl
311: );
312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
313:
314: END create_View_Text_Tables;
315:
316:

Line 345: x_return_status := FND_API.G_RET_STS_SUCCESS;

341: WHERE application_short_name = Lower(p_short_name);
342:
343: BEGIN
344: BIS_DEBUG_PUB.Add('> get_app_info');
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346: l_view_rec := p_view_rec;
347: l_pos := Instr(l_view_rec.view_name, 'BV_');
348: IF (l_pos = 0) THEN
349: l_pos := Instr(l_view_rec.view_name, 'FV_');

Line 373: when FND_API.G_EXC_ERROR then

369: RETURN l_view_rec;
370: CLOSE app_cursor;
371:
372: EXCEPTION
373: when FND_API.G_EXC_ERROR then
374: x_return_status := FND_API.G_RET_STS_ERROR ;
375: CLOSE app_cursor;
376: RAISE FND_API.G_EXC_ERROR;
377: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 374: x_return_status := FND_API.G_RET_STS_ERROR ;

370: CLOSE app_cursor;
371:
372: EXCEPTION
373: when FND_API.G_EXC_ERROR then
374: x_return_status := FND_API.G_RET_STS_ERROR ;
375: CLOSE app_cursor;
376: RAISE FND_API.G_EXC_ERROR;
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 376: RAISE FND_API.G_EXC_ERROR;

372: EXCEPTION
373: when FND_API.G_EXC_ERROR then
374: x_return_status := FND_API.G_RET_STS_ERROR ;
375: CLOSE app_cursor;
376: RAISE FND_API.G_EXC_ERROR;
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
379: CLOSE app_cursor;
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 377: when FND_API.G_EXC_UNEXPECTED_ERROR then

373: when FND_API.G_EXC_ERROR then
374: x_return_status := FND_API.G_RET_STS_ERROR ;
375: CLOSE app_cursor;
376: RAISE FND_API.G_EXC_ERROR;
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
379: CLOSE app_cursor;
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: when others then

Line 378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

374: x_return_status := FND_API.G_RET_STS_ERROR ;
375: CLOSE app_cursor;
376: RAISE FND_API.G_EXC_ERROR;
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
379: CLOSE app_cursor;
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: when others then
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

376: RAISE FND_API.G_EXC_ERROR;
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
379: CLOSE app_cursor;
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: when others then
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: CLOSE app_cursor;
384: BIS_VG_UTIL.Add_Error_Message

Line 382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
379: CLOSE app_cursor;
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: when others then
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: CLOSE app_cursor;
384: BIS_VG_UTIL.Add_Error_Message
385: ( p_error_msg_id => SQLCODE
386: , p_error_description => SQLERRM

Line 391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

387: , p_error_proc_name => G_PKG_NAME||'.get_app_info'
388: , p_error_table => x_error_tbl
389: , x_error_table => x_error_tbl
390: );
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392:
393: END get_app_info;
394:
395: /* ============================================================================

Line 453: when FND_API.G_EXC_ERROR then

449: RETURN l_found;
450:
451:
452: EXCEPTION
453: when FND_API.G_EXC_ERROR then
454: x_return_status := FND_API.G_RET_STS_ERROR ;
455: dbms_sql.close_cursor(g_cursor);
456: RAISE FND_API.G_EXC_ERROR;
457: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 454: x_return_status := FND_API.G_RET_STS_ERROR ;

450:
451:
452: EXCEPTION
453: when FND_API.G_EXC_ERROR then
454: x_return_status := FND_API.G_RET_STS_ERROR ;
455: dbms_sql.close_cursor(g_cursor);
456: RAISE FND_API.G_EXC_ERROR;
457: when FND_API.G_EXC_UNEXPECTED_ERROR then
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 456: RAISE FND_API.G_EXC_ERROR;

452: EXCEPTION
453: when FND_API.G_EXC_ERROR then
454: x_return_status := FND_API.G_RET_STS_ERROR ;
455: dbms_sql.close_cursor(g_cursor);
456: RAISE FND_API.G_EXC_ERROR;
457: when FND_API.G_EXC_UNEXPECTED_ERROR then
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: dbms_sql.close_cursor(g_cursor);
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 457: when FND_API.G_EXC_UNEXPECTED_ERROR then

453: when FND_API.G_EXC_ERROR then
454: x_return_status := FND_API.G_RET_STS_ERROR ;
455: dbms_sql.close_cursor(g_cursor);
456: RAISE FND_API.G_EXC_ERROR;
457: when FND_API.G_EXC_UNEXPECTED_ERROR then
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: dbms_sql.close_cursor(g_cursor);
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: when others then

Line 458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

454: x_return_status := FND_API.G_RET_STS_ERROR ;
455: dbms_sql.close_cursor(g_cursor);
456: RAISE FND_API.G_EXC_ERROR;
457: when FND_API.G_EXC_UNEXPECTED_ERROR then
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: dbms_sql.close_cursor(g_cursor);
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: when others then
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

456: RAISE FND_API.G_EXC_ERROR;
457: when FND_API.G_EXC_UNEXPECTED_ERROR then
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: dbms_sql.close_cursor(g_cursor);
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: when others then
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
463: dbms_sql.close_cursor(g_cursor);
464: BIS_VG_UTIL.Add_Error_Message

Line 462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: dbms_sql.close_cursor(g_cursor);
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: when others then
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
463: dbms_sql.close_cursor(g_cursor);
464: BIS_VG_UTIL.Add_Error_Message
465: ( p_error_msg_id => SQLCODE
466: , p_error_description => SQLERRM

Line 471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

467: , p_error_proc_name => G_PKG_NAME||'.valid_view'
468: , p_error_table => x_error_tbl
469: , x_error_table => x_error_tbl
470: );
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472:
473: END valid_view;
474:
475: /* ============================================================================

Line 542: when FND_API.G_EXC_ERROR then

538: END LOOP;
539: BIS_DEBUG_PUB.Add('< retrieve_business_views_field');
540:
541: EXCEPTION
542: when FND_API.G_EXC_ERROR then
543: x_return_status := FND_API.G_RET_STS_ERROR ;
544: CLOSE c_field_views;
545: RAISE FND_API.G_EXC_ERROR;
546: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 543: x_return_status := FND_API.G_RET_STS_ERROR ;

539: BIS_DEBUG_PUB.Add('< retrieve_business_views_field');
540:
541: EXCEPTION
542: when FND_API.G_EXC_ERROR then
543: x_return_status := FND_API.G_RET_STS_ERROR ;
544: CLOSE c_field_views;
545: RAISE FND_API.G_EXC_ERROR;
546: when FND_API.G_EXC_UNEXPECTED_ERROR then
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 545: RAISE FND_API.G_EXC_ERROR;

541: EXCEPTION
542: when FND_API.G_EXC_ERROR then
543: x_return_status := FND_API.G_RET_STS_ERROR ;
544: CLOSE c_field_views;
545: RAISE FND_API.G_EXC_ERROR;
546: when FND_API.G_EXC_UNEXPECTED_ERROR then
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548: CLOSE c_field_views;
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 546: when FND_API.G_EXC_UNEXPECTED_ERROR then

542: when FND_API.G_EXC_ERROR then
543: x_return_status := FND_API.G_RET_STS_ERROR ;
544: CLOSE c_field_views;
545: RAISE FND_API.G_EXC_ERROR;
546: when FND_API.G_EXC_UNEXPECTED_ERROR then
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548: CLOSE c_field_views;
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: when others then

Line 547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

543: x_return_status := FND_API.G_RET_STS_ERROR ;
544: CLOSE c_field_views;
545: RAISE FND_API.G_EXC_ERROR;
546: when FND_API.G_EXC_UNEXPECTED_ERROR then
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548: CLOSE c_field_views;
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: when others then
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

545: RAISE FND_API.G_EXC_ERROR;
546: when FND_API.G_EXC_UNEXPECTED_ERROR then
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548: CLOSE c_field_views;
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: when others then
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
552: CLOSE c_field_views;
553: BIS_VG_UTIL.Add_Error_Message

Line 551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548: CLOSE c_field_views;
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: when others then
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
552: CLOSE c_field_views;
553: BIS_VG_UTIL.Add_Error_Message
554: ( p_error_msg_id => SQLCODE
555: , p_error_description => SQLERRM

Line 560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

556: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_field'
557: , p_error_table => x_error_tbl
558: , x_error_table => x_error_tbl
559: );
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561:
562: END retrieve_business_views_field;
563:
564: /* ============================================================================

Line 605: when FND_API.G_EXC_ERROR then

601: );
602: BIS_DEBUG_PUB.Add('< retrieve_business_views_kfx');
603:
604: EXCEPTION
605: when FND_API.G_EXC_ERROR then
606: x_return_status := FND_API.G_RET_STS_ERROR ;
607: RAISE FND_API.G_EXC_ERROR;
608: when FND_API.G_EXC_UNEXPECTED_ERROR then
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 606: x_return_status := FND_API.G_RET_STS_ERROR ;

602: BIS_DEBUG_PUB.Add('< retrieve_business_views_kfx');
603:
604: EXCEPTION
605: when FND_API.G_EXC_ERROR then
606: x_return_status := FND_API.G_RET_STS_ERROR ;
607: RAISE FND_API.G_EXC_ERROR;
608: when FND_API.G_EXC_UNEXPECTED_ERROR then
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 607: RAISE FND_API.G_EXC_ERROR;

603:
604: EXCEPTION
605: when FND_API.G_EXC_ERROR then
606: x_return_status := FND_API.G_RET_STS_ERROR ;
607: RAISE FND_API.G_EXC_ERROR;
608: when FND_API.G_EXC_UNEXPECTED_ERROR then
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: when others then

Line 608: when FND_API.G_EXC_UNEXPECTED_ERROR then

604: EXCEPTION
605: when FND_API.G_EXC_ERROR then
606: x_return_status := FND_API.G_RET_STS_ERROR ;
607: RAISE FND_API.G_EXC_ERROR;
608: when FND_API.G_EXC_UNEXPECTED_ERROR then
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: when others then
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

605: when FND_API.G_EXC_ERROR then
606: x_return_status := FND_API.G_RET_STS_ERROR ;
607: RAISE FND_API.G_EXC_ERROR;
608: when FND_API.G_EXC_UNEXPECTED_ERROR then
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: when others then
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
613: BIS_VG_UTIL.Add_Error_Message

Line 610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

606: x_return_status := FND_API.G_RET_STS_ERROR ;
607: RAISE FND_API.G_EXC_ERROR;
608: when FND_API.G_EXC_UNEXPECTED_ERROR then
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: when others then
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
613: BIS_VG_UTIL.Add_Error_Message
614: ( p_error_msg_id => SQLCODE

Line 612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

608: when FND_API.G_EXC_UNEXPECTED_ERROR then
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: when others then
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
613: BIS_VG_UTIL.Add_Error_Message
614: ( p_error_msg_id => SQLCODE
615: , p_error_description => SQLERRM
616: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_kfx'

Line 620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

616: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_kfx'
617: , p_error_table => x_error_tbl
618: , x_error_table => x_error_tbl
619: );
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621:
622: END retrieve_business_views_kfx;
623:
624: /* ============================================================================

Line 665: when FND_API.G_EXC_ERROR then

661: );
662: BIS_DEBUG_PUB.Add('< retrieve_business_views_dfx');
663:
664: EXCEPTION
665: when FND_API.G_EXC_ERROR then
666: x_return_status := FND_API.G_RET_STS_ERROR ;
667: RAISE FND_API.G_EXC_ERROR;
668: when FND_API.G_EXC_UNEXPECTED_ERROR then
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 666: x_return_status := FND_API.G_RET_STS_ERROR ;

662: BIS_DEBUG_PUB.Add('< retrieve_business_views_dfx');
663:
664: EXCEPTION
665: when FND_API.G_EXC_ERROR then
666: x_return_status := FND_API.G_RET_STS_ERROR ;
667: RAISE FND_API.G_EXC_ERROR;
668: when FND_API.G_EXC_UNEXPECTED_ERROR then
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 667: RAISE FND_API.G_EXC_ERROR;

663:
664: EXCEPTION
665: when FND_API.G_EXC_ERROR then
666: x_return_status := FND_API.G_RET_STS_ERROR ;
667: RAISE FND_API.G_EXC_ERROR;
668: when FND_API.G_EXC_UNEXPECTED_ERROR then
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
671: when others then

Line 668: when FND_API.G_EXC_UNEXPECTED_ERROR then

664: EXCEPTION
665: when FND_API.G_EXC_ERROR then
666: x_return_status := FND_API.G_RET_STS_ERROR ;
667: RAISE FND_API.G_EXC_ERROR;
668: when FND_API.G_EXC_UNEXPECTED_ERROR then
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
671: when others then
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

665: when FND_API.G_EXC_ERROR then
666: x_return_status := FND_API.G_RET_STS_ERROR ;
667: RAISE FND_API.G_EXC_ERROR;
668: when FND_API.G_EXC_UNEXPECTED_ERROR then
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
671: when others then
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
673: BIS_VG_UTIL.Add_Error_Message

Line 670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

666: x_return_status := FND_API.G_RET_STS_ERROR ;
667: RAISE FND_API.G_EXC_ERROR;
668: when FND_API.G_EXC_UNEXPECTED_ERROR then
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
671: when others then
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
673: BIS_VG_UTIL.Add_Error_Message
674: ( p_error_msg_id => SQLCODE

Line 672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

668: when FND_API.G_EXC_UNEXPECTED_ERROR then
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
671: when others then
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
673: BIS_VG_UTIL.Add_Error_Message
674: ( p_error_msg_id => SQLCODE
675: , p_error_description => SQLERRM
676: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_dfx'

Line 680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

676: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_dfx'
677: , p_error_table => x_error_tbl
678: , x_error_table => x_error_tbl
679: );
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681:
682: END retrieve_business_views_dfx;
683:
684: /* ============================================================================

Line 726: when FND_API.G_EXC_ERROR then

722: );
723: BIS_DEBUG_PUB.Add('< retrieve_business_views_lat');
724:
725: EXCEPTION
726: when FND_API.G_EXC_ERROR then
727: x_return_status := FND_API.G_RET_STS_ERROR ;
728: RAISE FND_API.G_EXC_ERROR;
729: when FND_API.G_EXC_UNEXPECTED_ERROR then
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 727: x_return_status := FND_API.G_RET_STS_ERROR ;

723: BIS_DEBUG_PUB.Add('< retrieve_business_views_lat');
724:
725: EXCEPTION
726: when FND_API.G_EXC_ERROR then
727: x_return_status := FND_API.G_RET_STS_ERROR ;
728: RAISE FND_API.G_EXC_ERROR;
729: when FND_API.G_EXC_UNEXPECTED_ERROR then
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 728: RAISE FND_API.G_EXC_ERROR;

724:
725: EXCEPTION
726: when FND_API.G_EXC_ERROR then
727: x_return_status := FND_API.G_RET_STS_ERROR ;
728: RAISE FND_API.G_EXC_ERROR;
729: when FND_API.G_EXC_UNEXPECTED_ERROR then
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: when others then

Line 729: when FND_API.G_EXC_UNEXPECTED_ERROR then

725: EXCEPTION
726: when FND_API.G_EXC_ERROR then
727: x_return_status := FND_API.G_RET_STS_ERROR ;
728: RAISE FND_API.G_EXC_ERROR;
729: when FND_API.G_EXC_UNEXPECTED_ERROR then
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: when others then
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

726: when FND_API.G_EXC_ERROR then
727: x_return_status := FND_API.G_RET_STS_ERROR ;
728: RAISE FND_API.G_EXC_ERROR;
729: when FND_API.G_EXC_UNEXPECTED_ERROR then
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: when others then
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
734: BIS_VG_UTIL.Add_Error_Message

Line 731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

727: x_return_status := FND_API.G_RET_STS_ERROR ;
728: RAISE FND_API.G_EXC_ERROR;
729: when FND_API.G_EXC_UNEXPECTED_ERROR then
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: when others then
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
734: BIS_VG_UTIL.Add_Error_Message
735: ( p_error_msg_id => SQLCODE

Line 733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

729: when FND_API.G_EXC_UNEXPECTED_ERROR then
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: when others then
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
734: BIS_VG_UTIL.Add_Error_Message
735: ( p_error_msg_id => SQLCODE
736: , p_error_description => SQLERRM
737: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_lat'

Line 741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

737: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_lat'
738: , p_error_table => x_error_tbl
739: , x_error_table => x_error_tbl
740: );
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742:
743: END retrieve_business_views_lat;
744:
745: /* ============================================================================

Line 786: when FND_API.G_EXC_ERROR then

782: END LOOP;
783: BIS_DEBUG_PUB.Add('< retrieve_Business_Views_view_name');
784:
785: EXCEPTION
786: when FND_API.G_EXC_ERROR then
787: x_return_status := FND_API.G_RET_STS_ERROR ;
788: CLOSE c_all_views;
789: RAISE FND_API.G_EXC_ERROR;
790: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 787: x_return_status := FND_API.G_RET_STS_ERROR ;

783: BIS_DEBUG_PUB.Add('< retrieve_Business_Views_view_name');
784:
785: EXCEPTION
786: when FND_API.G_EXC_ERROR then
787: x_return_status := FND_API.G_RET_STS_ERROR ;
788: CLOSE c_all_views;
789: RAISE FND_API.G_EXC_ERROR;
790: when FND_API.G_EXC_UNEXPECTED_ERROR then
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 789: RAISE FND_API.G_EXC_ERROR;

785: EXCEPTION
786: when FND_API.G_EXC_ERROR then
787: x_return_status := FND_API.G_RET_STS_ERROR ;
788: CLOSE c_all_views;
789: RAISE FND_API.G_EXC_ERROR;
790: when FND_API.G_EXC_UNEXPECTED_ERROR then
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792: CLOSE c_all_views;
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 790: when FND_API.G_EXC_UNEXPECTED_ERROR then

786: when FND_API.G_EXC_ERROR then
787: x_return_status := FND_API.G_RET_STS_ERROR ;
788: CLOSE c_all_views;
789: RAISE FND_API.G_EXC_ERROR;
790: when FND_API.G_EXC_UNEXPECTED_ERROR then
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792: CLOSE c_all_views;
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: when others then

Line 791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

787: x_return_status := FND_API.G_RET_STS_ERROR ;
788: CLOSE c_all_views;
789: RAISE FND_API.G_EXC_ERROR;
790: when FND_API.G_EXC_UNEXPECTED_ERROR then
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792: CLOSE c_all_views;
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: when others then
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

789: RAISE FND_API.G_EXC_ERROR;
790: when FND_API.G_EXC_UNEXPECTED_ERROR then
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792: CLOSE c_all_views;
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: when others then
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
796: CLOSE c_all_views;
797: BIS_VG_UTIL.Add_Error_Message

Line 795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792: CLOSE c_all_views;
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: when others then
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
796: CLOSE c_all_views;
797: BIS_VG_UTIL.Add_Error_Message
798: ( p_error_msg_id => SQLCODE
799: , p_error_description => SQLERRM

Line 804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

800: , p_error_proc_name => G_PKG_NAME||'.retrieve_Business_View_name'
801: , p_error_table => x_error_tbl
802: , x_error_table => x_error_tbl
803: );
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805:
806: END retrieve_Business_View_name;
807:
808: /* ============================================================================

Line 935: when FND_API.G_EXC_ERROR then

931: BIS_DEBUG_PUB.Add('< retrieve_Business_Views_app');
932:
933:
934: EXCEPTION
935: when FND_API.G_EXC_ERROR then
936: x_return_status := FND_API.G_RET_STS_ERROR ;
937: CLOSE c_all_views;
938: RAISE FND_API.G_EXC_ERROR;
939: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 936: x_return_status := FND_API.G_RET_STS_ERROR ;

932:
933:
934: EXCEPTION
935: when FND_API.G_EXC_ERROR then
936: x_return_status := FND_API.G_RET_STS_ERROR ;
937: CLOSE c_all_views;
938: RAISE FND_API.G_EXC_ERROR;
939: when FND_API.G_EXC_UNEXPECTED_ERROR then
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 938: RAISE FND_API.G_EXC_ERROR;

934: EXCEPTION
935: when FND_API.G_EXC_ERROR then
936: x_return_status := FND_API.G_RET_STS_ERROR ;
937: CLOSE c_all_views;
938: RAISE FND_API.G_EXC_ERROR;
939: when FND_API.G_EXC_UNEXPECTED_ERROR then
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
941: CLOSE c_all_views;
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 939: when FND_API.G_EXC_UNEXPECTED_ERROR then

935: when FND_API.G_EXC_ERROR then
936: x_return_status := FND_API.G_RET_STS_ERROR ;
937: CLOSE c_all_views;
938: RAISE FND_API.G_EXC_ERROR;
939: when FND_API.G_EXC_UNEXPECTED_ERROR then
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
941: CLOSE c_all_views;
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: when others then

Line 940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

936: x_return_status := FND_API.G_RET_STS_ERROR ;
937: CLOSE c_all_views;
938: RAISE FND_API.G_EXC_ERROR;
939: when FND_API.G_EXC_UNEXPECTED_ERROR then
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
941: CLOSE c_all_views;
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: when others then
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

938: RAISE FND_API.G_EXC_ERROR;
939: when FND_API.G_EXC_UNEXPECTED_ERROR then
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
941: CLOSE c_all_views;
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: when others then
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
945: CLOSE c_all_views;
946: BIS_VG_UTIL.Add_Error_Message

Line 944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
941: CLOSE c_all_views;
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: when others then
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
945: CLOSE c_all_views;
946: BIS_VG_UTIL.Add_Error_Message
947: ( p_error_msg_id => SQLCODE
948: , p_error_description => SQLERRM

Line 953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

949: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_app'
950: , p_error_table => x_error_tbl
951: , x_error_table => x_error_tbl
952: );
953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
954:
955: END retrieve_business_views_app;
956:
957: /* ============================================================================

Line 1002: when FND_API.G_EXC_ERROR then

998: END LOOP;
999:
1000:
1001: EXCEPTION
1002: when FND_API.G_EXC_ERROR then
1003: x_return_status := FND_API.G_RET_STS_ERROR ;
1004: CLOSE c_all_views;
1005: RAISE FND_API.G_EXC_ERROR;
1006: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1003: x_return_status := FND_API.G_RET_STS_ERROR ;

999:
1000:
1001: EXCEPTION
1002: when FND_API.G_EXC_ERROR then
1003: x_return_status := FND_API.G_RET_STS_ERROR ;
1004: CLOSE c_all_views;
1005: RAISE FND_API.G_EXC_ERROR;
1006: when FND_API.G_EXC_UNEXPECTED_ERROR then
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1005: RAISE FND_API.G_EXC_ERROR;

1001: EXCEPTION
1002: when FND_API.G_EXC_ERROR then
1003: x_return_status := FND_API.G_RET_STS_ERROR ;
1004: CLOSE c_all_views;
1005: RAISE FND_API.G_EXC_ERROR;
1006: when FND_API.G_EXC_UNEXPECTED_ERROR then
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1008: CLOSE c_all_views;
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1006: when FND_API.G_EXC_UNEXPECTED_ERROR then

1002: when FND_API.G_EXC_ERROR then
1003: x_return_status := FND_API.G_RET_STS_ERROR ;
1004: CLOSE c_all_views;
1005: RAISE FND_API.G_EXC_ERROR;
1006: when FND_API.G_EXC_UNEXPECTED_ERROR then
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1008: CLOSE c_all_views;
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: when others then

Line 1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1003: x_return_status := FND_API.G_RET_STS_ERROR ;
1004: CLOSE c_all_views;
1005: RAISE FND_API.G_EXC_ERROR;
1006: when FND_API.G_EXC_UNEXPECTED_ERROR then
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1008: CLOSE c_all_views;
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: when others then
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1005: RAISE FND_API.G_EXC_ERROR;
1006: when FND_API.G_EXC_UNEXPECTED_ERROR then
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1008: CLOSE c_all_views;
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: when others then
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1012: CLOSE c_all_views;
1013: BIS_VG_UTIL.Add_Error_Message

Line 1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1008: CLOSE c_all_views;
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: when others then
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1012: CLOSE c_all_views;
1013: BIS_VG_UTIL.Add_Error_Message
1014: ( p_error_msg_id => SQLCODE
1015: , p_error_description => SQLERRM

Line 1020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1016: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_all'
1017: , p_error_table => x_error_tbl
1018: , x_error_table => x_error_tbl
1019: );
1020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1021:
1022: END retrieve_business_views_all;
1023:
1024: /* ============================================================================

Line 1062: x_return_status := FND_API.G_RET_STS_SUCCESS;

1058: --
1059: BEGIN
1060:
1061: BIS_DEBUG_PUB.Add('> retrieve_Business_Views');
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063:
1064: IF (p_all_flag = fnd_api.g_true) THEN
1065:
1066: retrieve_business_views_all ( x_view_table

Line 1064: IF (p_all_flag = fnd_api.g_true) THEN

1060:
1061: BIS_DEBUG_PUB.Add('> retrieve_Business_Views');
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063:
1064: IF (p_all_flag = fnd_api.g_true) THEN
1065:
1066: retrieve_business_views_all ( x_view_table
1067: , x_return_status
1068: , x_error_Tbl

Line 1124: when FND_API.G_EXC_ERROR then

1120:
1121: BIS_DEBUG_PUB.Add('< retrieve_Business_Views');
1122:
1123: EXCEPTION
1124: when FND_API.G_EXC_ERROR then
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126: RAISE FND_API.G_EXC_ERROR;
1127: when FND_API.G_EXC_UNEXPECTED_ERROR then
1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1125: x_return_status := FND_API.G_RET_STS_ERROR ;

1121: BIS_DEBUG_PUB.Add('< retrieve_Business_Views');
1122:
1123: EXCEPTION
1124: when FND_API.G_EXC_ERROR then
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126: RAISE FND_API.G_EXC_ERROR;
1127: when FND_API.G_EXC_UNEXPECTED_ERROR then
1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1126: RAISE FND_API.G_EXC_ERROR;

1122:
1123: EXCEPTION
1124: when FND_API.G_EXC_ERROR then
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126: RAISE FND_API.G_EXC_ERROR;
1127: when FND_API.G_EXC_UNEXPECTED_ERROR then
1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: when others then

Line 1127: when FND_API.G_EXC_UNEXPECTED_ERROR then

1123: EXCEPTION
1124: when FND_API.G_EXC_ERROR then
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126: RAISE FND_API.G_EXC_ERROR;
1127: when FND_API.G_EXC_UNEXPECTED_ERROR then
1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: when others then
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1124: when FND_API.G_EXC_ERROR then
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126: RAISE FND_API.G_EXC_ERROR;
1127: when FND_API.G_EXC_UNEXPECTED_ERROR then
1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: when others then
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1132: BIS_VG_UTIL.Add_Error_Message

Line 1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126: RAISE FND_API.G_EXC_ERROR;
1127: when FND_API.G_EXC_UNEXPECTED_ERROR then
1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: when others then
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1132: BIS_VG_UTIL.Add_Error_Message
1133: ( p_error_msg_id => SQLCODE

Line 1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1127: when FND_API.G_EXC_UNEXPECTED_ERROR then
1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: when others then
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1132: BIS_VG_UTIL.Add_Error_Message
1133: ( p_error_msg_id => SQLCODE
1134: , p_error_description => SQLERRM
1135: , p_error_proc_name => G_PKG_NAME||'.retrieve_Business_Views'

Line 1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1135: , p_error_proc_name => G_PKG_NAME||'.retrieve_Business_Views'
1136: , p_error_table => x_error_tbl
1137: , x_error_table => x_error_tbl
1138: );
1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1140:
1141: END retrieve_Business_Views;
1142: --
1143: END BIS_VG_REPOSITORY_MEDIATOR;