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.

[Home] [Help]

APPS.BIS_VG_LOOKUP dependencies on FND_API

Line 55: x_return_status := FND_API.G_RET_STS_SUCCESS;

51: l_col VARCHAR2(1000);
52: l_num NUMBER;
53: BEGIN
54: BIS_DEBUG_PUB.Add('> put_column_name');
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56: --
57: -- skip the _LA part
58: l_str := bis_vg_parser.Skip_Tag( p_View_Column_Table
59: , p_column_pointer

Line 110: RAISE FND_API.G_EXC_ERROR;

106: bis_vg_log.update_failure_log( x_error_tbl
107: , x_return_status
108: , x_error_Tbl
109: );
110: RAISE FND_API.G_EXC_ERROR;
111:
112: END IF;
113: --
114: -- save to output file

Line 131: when FND_API.G_EXC_ERROR then

127: END IF;
128: BIS_DEBUG_PUB.Add('< put_column_name');
129: --
130: EXCEPTION
131: when FND_API.G_EXC_ERROR then
132: x_return_status := FND_API.G_RET_STS_ERROR ;
133: RAISE FND_API.G_EXC_ERROR;
134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 132: x_return_status := FND_API.G_RET_STS_ERROR ;

128: BIS_DEBUG_PUB.Add('< put_column_name');
129: --
130: EXCEPTION
131: when FND_API.G_EXC_ERROR then
132: x_return_status := FND_API.G_RET_STS_ERROR ;
133: RAISE FND_API.G_EXC_ERROR;
134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 133: RAISE FND_API.G_EXC_ERROR;

129: --
130: EXCEPTION
131: when FND_API.G_EXC_ERROR then
132: x_return_status := FND_API.G_RET_STS_ERROR ;
133: RAISE FND_API.G_EXC_ERROR;
134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: when others then

Line 134: when FND_API.G_EXC_UNEXPECTED_ERROR then

130: EXCEPTION
131: when FND_API.G_EXC_ERROR then
132: x_return_status := FND_API.G_RET_STS_ERROR ;
133: RAISE FND_API.G_EXC_ERROR;
134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: when others then
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

131: when FND_API.G_EXC_ERROR then
132: x_return_status := FND_API.G_RET_STS_ERROR ;
133: RAISE FND_API.G_EXC_ERROR;
134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: when others then
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: BIS_VG_UTIL.Add_Error_Message

Line 136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

132: x_return_status := FND_API.G_RET_STS_ERROR ;
133: RAISE FND_API.G_EXC_ERROR;
134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: when others then
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: BIS_VG_UTIL.Add_Error_Message
140: ( p_error_msg_id => SQLCODE

Line 138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: when others then
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: BIS_VG_UTIL.Add_Error_Message
140: ( p_error_msg_id => SQLCODE
141: , p_error_description => SQLERRM
142: , p_error_proc_name => G_PKG_NAME||'.put_column_name'

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

146: bis_vg_log.update_failure_log( x_error_tbl
147: , x_return_status
148: , x_error_Tbl
149: );
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151:
152: END put_column_name;
153: --
154: /* ============================================================================

Line 179: x_return_status := FND_API.G_RET_STS_SUCCESS;

175: IS
176: l_select VARCHAR2(1000);
177: BEGIN
178: BIS_DEBUG_PUB.Add('> get_select_statement');
179: x_return_status := FND_API.G_RET_STS_SUCCESS;
180: --
181: l_select := 'select lookup_code, '||p_lookup_column;
182: l_select := l_select || ' from '||p_lookup_table;
183: l_select := l_select || ' where lookup_type = '''||p_lookup_type||'''';

Line 192: when FND_API.G_EXC_ERROR then

188: RETURN l_select;
189: --
190:
191: EXCEPTION
192: when FND_API.G_EXC_ERROR then
193: x_return_status := FND_API.G_RET_STS_ERROR ;
194: RAISE FND_API.G_EXC_ERROR;
195: when FND_API.G_EXC_UNEXPECTED_ERROR then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 193: x_return_status := FND_API.G_RET_STS_ERROR ;

189: --
190:
191: EXCEPTION
192: when FND_API.G_EXC_ERROR then
193: x_return_status := FND_API.G_RET_STS_ERROR ;
194: RAISE FND_API.G_EXC_ERROR;
195: when FND_API.G_EXC_UNEXPECTED_ERROR then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 194: RAISE FND_API.G_EXC_ERROR;

190:
191: EXCEPTION
192: when FND_API.G_EXC_ERROR then
193: x_return_status := FND_API.G_RET_STS_ERROR ;
194: RAISE FND_API.G_EXC_ERROR;
195: when FND_API.G_EXC_UNEXPECTED_ERROR then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: when others then

Line 195: when FND_API.G_EXC_UNEXPECTED_ERROR then

191: EXCEPTION
192: when FND_API.G_EXC_ERROR then
193: x_return_status := FND_API.G_RET_STS_ERROR ;
194: RAISE FND_API.G_EXC_ERROR;
195: when FND_API.G_EXC_UNEXPECTED_ERROR then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: when others then
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

192: when FND_API.G_EXC_ERROR then
193: x_return_status := FND_API.G_RET_STS_ERROR ;
194: RAISE FND_API.G_EXC_ERROR;
195: when FND_API.G_EXC_UNEXPECTED_ERROR then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: when others then
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
200: BIS_VG_UTIL.Add_Error_Message

Line 197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

193: x_return_status := FND_API.G_RET_STS_ERROR ;
194: RAISE FND_API.G_EXC_ERROR;
195: when FND_API.G_EXC_UNEXPECTED_ERROR then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: when others then
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
200: BIS_VG_UTIL.Add_Error_Message
201: ( p_error_msg_id => SQLCODE

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

195: when FND_API.G_EXC_UNEXPECTED_ERROR then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: when others then
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
200: BIS_VG_UTIL.Add_Error_Message
201: ( p_error_msg_id => SQLCODE
202: , p_error_description => SQLERRM
203: , p_error_proc_name => G_PKG_NAME||'.get_select_statement'

Line 211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

207: bis_vg_log.update_failure_log( x_error_tbl
208: , x_return_status
209: , x_error_Tbl
210: );
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212:
213: END get_select_statement;
214: --
215: /* ============================================================================

Line 251: x_return_status := FND_API.G_RET_STS_SUCCESS;

247: l_lookup_type_valid BOOLEAN := FALSE;
248: l_num_rows NUMBER;
249: BEGIN
250: BIS_DEBUG_PUB.Add('> write_decode_statement');
251: x_return_status := FND_API.G_RET_STS_SUCCESS;
252: -- open the cursor
253: l_cursor_id := dbms_sql.open_cursor;
254: --
255: -- parse the statement

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

266: --
267: l_num_rows := dbms_sql.fetch_rows(l_cursor_id);
268: --
269: IF (l_num_rows = 0) THEN
270: -- x_return_status := FND_API.G_RET_STS_ERROR;
271: -- Lookup type undefined set flag to return a NULL for the column
272: l_DECODE_flag := TRUE;
273: END IF;
274: --

Line 343: when FND_API.G_EXC_ERROR then

339: BIS_DEBUG_PUB.Add('< write_decode_statement');
340: --
341: --
342: EXCEPTION
343: when FND_API.G_EXC_ERROR then
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345: dbms_sql.close_cursor(l_cursor_id);
346: RAISE FND_API.G_EXC_ERROR;
347: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 344: x_return_status := FND_API.G_RET_STS_ERROR ;

340: --
341: --
342: EXCEPTION
343: when FND_API.G_EXC_ERROR then
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345: dbms_sql.close_cursor(l_cursor_id);
346: RAISE FND_API.G_EXC_ERROR;
347: when FND_API.G_EXC_UNEXPECTED_ERROR then
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 346: RAISE FND_API.G_EXC_ERROR;

342: EXCEPTION
343: when FND_API.G_EXC_ERROR then
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345: dbms_sql.close_cursor(l_cursor_id);
346: RAISE FND_API.G_EXC_ERROR;
347: when FND_API.G_EXC_UNEXPECTED_ERROR then
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: dbms_sql.close_cursor(l_cursor_id);
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 347: when FND_API.G_EXC_UNEXPECTED_ERROR then

343: when FND_API.G_EXC_ERROR then
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345: dbms_sql.close_cursor(l_cursor_id);
346: RAISE FND_API.G_EXC_ERROR;
347: when FND_API.G_EXC_UNEXPECTED_ERROR then
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: dbms_sql.close_cursor(l_cursor_id);
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: when others then

Line 348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

344: x_return_status := FND_API.G_RET_STS_ERROR ;
345: dbms_sql.close_cursor(l_cursor_id);
346: RAISE FND_API.G_EXC_ERROR;
347: when FND_API.G_EXC_UNEXPECTED_ERROR then
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: dbms_sql.close_cursor(l_cursor_id);
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: when others then
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

346: RAISE FND_API.G_EXC_ERROR;
347: when FND_API.G_EXC_UNEXPECTED_ERROR then
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: dbms_sql.close_cursor(l_cursor_id);
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: when others then
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
353: dbms_sql.close_cursor(l_cursor_id);
354: BIS_VG_UTIL.Add_Error_Message

Line 352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: dbms_sql.close_cursor(l_cursor_id);
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: when others then
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
353: dbms_sql.close_cursor(l_cursor_id);
354: BIS_VG_UTIL.Add_Error_Message
355: ( p_error_msg_id => SQLCODE
356: , p_error_description => SQLERRM

Line 366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

362: , x_return_status
363: , x_error_Tbl
364: );
365:
366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367:
368: END write_decode_statement;
369: --
370: /* ============================================================================

Line 399: x_return_status := FND_API.G_RET_STS_SUCCESS;

395: IS
396: l_select VARCHAR2(1000);
397: BEGIN
398: BIS_DEBUG_PUB.Add('> put_decode_statement');
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);
401: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);
402: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);
403: BIS_DEBUG_PUB.Add('p_expr = ' || p_expr);

Line 422: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

418: , x_select_table
419: , x_return_status
420: , x_error_Tbl
421: );
422: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
423: THEN
424: BIS_VG_UTIL.Add_Error_message
425: ( p_error_msg_name => bis_vg_lookup.LAT_INVALID_LOOKUP_TYPE_MSG
426: , p_error_proc_name => G_PKG_NAME||'. write_decode_statement'

Line 440: RAISE FND_API.G_EXC_ERROR;

436: bis_vg_log.update_failure_log( x_error_tbl
437: , x_return_status
438: , x_error_Tbl
439: );
440: RAISE FND_API.G_EXC_ERROR;
441: END IF;
442:
443: --
444: BIS_DEBUG_PUB.Add('< put_decode_statement');

Line 448: when FND_API.G_EXC_ERROR then

444: BIS_DEBUG_PUB.Add('< put_decode_statement');
445: --
446:
447: EXCEPTION
448: when FND_API.G_EXC_ERROR then
449: x_return_status := FND_API.G_RET_STS_ERROR ;
450: RAISE FND_API.G_EXC_ERROR;
451: when FND_API.G_EXC_UNEXPECTED_ERROR then
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 449: x_return_status := FND_API.G_RET_STS_ERROR ;

445: --
446:
447: EXCEPTION
448: when FND_API.G_EXC_ERROR then
449: x_return_status := FND_API.G_RET_STS_ERROR ;
450: RAISE FND_API.G_EXC_ERROR;
451: when FND_API.G_EXC_UNEXPECTED_ERROR then
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 450: RAISE FND_API.G_EXC_ERROR;

446:
447: EXCEPTION
448: when FND_API.G_EXC_ERROR then
449: x_return_status := FND_API.G_RET_STS_ERROR ;
450: RAISE FND_API.G_EXC_ERROR;
451: when FND_API.G_EXC_UNEXPECTED_ERROR then
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: when others then

Line 451: when FND_API.G_EXC_UNEXPECTED_ERROR then

447: EXCEPTION
448: when FND_API.G_EXC_ERROR then
449: x_return_status := FND_API.G_RET_STS_ERROR ;
450: RAISE FND_API.G_EXC_ERROR;
451: when FND_API.G_EXC_UNEXPECTED_ERROR then
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: when others then
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

448: when FND_API.G_EXC_ERROR then
449: x_return_status := FND_API.G_RET_STS_ERROR ;
450: RAISE FND_API.G_EXC_ERROR;
451: when FND_API.G_EXC_UNEXPECTED_ERROR then
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: when others then
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: BIS_VG_UTIL.Add_Error_Message

Line 453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

449: x_return_status := FND_API.G_RET_STS_ERROR ;
450: RAISE FND_API.G_EXC_ERROR;
451: when FND_API.G_EXC_UNEXPECTED_ERROR then
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: when others then
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: BIS_VG_UTIL.Add_Error_Message
457: ( p_error_msg_id => SQLCODE

Line 455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

451: when FND_API.G_EXC_UNEXPECTED_ERROR then
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: when others then
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: BIS_VG_UTIL.Add_Error_Message
457: ( p_error_msg_id => SQLCODE
458: , p_error_description => SQLERRM
459: , p_error_proc_name => G_PKG_NAME||'.put_decode_statement'

Line 467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

463: bis_vg_log.update_failure_log( x_error_tbl
464: , x_return_status
465: , x_error_Tbl
466: );
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468:
469:
470: END put_decode_statement;
471: --

Line 508: x_return_status := FND_API.G_RET_STS_SUCCESS;

504: l_dummy INTEGER;
505: BEGIN
506: --
507: BIS_DEBUG_PUB.Add('> put_decode_statement_lang');
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: --
510: BIS_DEBUG_PUB.Add('> put_decode_statement');
511: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);
512: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);

Line 540: when FND_API.G_EXC_ERROR then

536: BIS_DEBUG_PUB.Add('< put_decode_statement_lang');
537: --
538:
539: EXCEPTION
540: when FND_API.G_EXC_ERROR then
541: x_return_status := FND_API.G_RET_STS_ERROR ;
542: RAISE FND_API.G_EXC_ERROR;
543: when FND_API.G_EXC_UNEXPECTED_ERROR then
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 541: x_return_status := FND_API.G_RET_STS_ERROR ;

537: --
538:
539: EXCEPTION
540: when FND_API.G_EXC_ERROR then
541: x_return_status := FND_API.G_RET_STS_ERROR ;
542: RAISE FND_API.G_EXC_ERROR;
543: when FND_API.G_EXC_UNEXPECTED_ERROR then
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 542: RAISE FND_API.G_EXC_ERROR;

538:
539: EXCEPTION
540: when FND_API.G_EXC_ERROR then
541: x_return_status := FND_API.G_RET_STS_ERROR ;
542: RAISE FND_API.G_EXC_ERROR;
543: when FND_API.G_EXC_UNEXPECTED_ERROR then
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: when others then

Line 543: when FND_API.G_EXC_UNEXPECTED_ERROR then

539: EXCEPTION
540: when FND_API.G_EXC_ERROR then
541: x_return_status := FND_API.G_RET_STS_ERROR ;
542: RAISE FND_API.G_EXC_ERROR;
543: when FND_API.G_EXC_UNEXPECTED_ERROR then
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: when others then
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

540: when FND_API.G_EXC_ERROR then
541: x_return_status := FND_API.G_RET_STS_ERROR ;
542: RAISE FND_API.G_EXC_ERROR;
543: when FND_API.G_EXC_UNEXPECTED_ERROR then
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: when others then
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548: BIS_VG_UTIL.Add_Error_Message

Line 545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

541: x_return_status := FND_API.G_RET_STS_ERROR ;
542: RAISE FND_API.G_EXC_ERROR;
543: when FND_API.G_EXC_UNEXPECTED_ERROR then
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: when others then
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548: BIS_VG_UTIL.Add_Error_Message
549: ( p_error_msg_id => SQLCODE

Line 547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

543: when FND_API.G_EXC_UNEXPECTED_ERROR then
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: when others then
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548: BIS_VG_UTIL.Add_Error_Message
549: ( p_error_msg_id => SQLCODE
550: , p_error_description => SQLERRM
551: , p_error_proc_name => G_PKG_NAME||'.put_decode_statement_lang'

Line 559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

555: bis_vg_log.update_failure_log( x_error_tbl
556: , x_return_status
557: , x_error_Tbl
558: );
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560:
561: END put_decode_statement_lang;
562: --
563: /* ============================================================================

Line 649: when FND_API.G_EXC_ERROR then

645:
646:
647:
648: EXCEPTION
649: when FND_API.G_EXC_ERROR then
650: x_return_status := FND_API.G_RET_STS_ERROR ;
651: dbms_sql.close_cursor(l_cursor_id);
652: RAISE FND_API.G_EXC_ERROR;
653: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 650: x_return_status := FND_API.G_RET_STS_ERROR ;

646:
647:
648: EXCEPTION
649: when FND_API.G_EXC_ERROR then
650: x_return_status := FND_API.G_RET_STS_ERROR ;
651: dbms_sql.close_cursor(l_cursor_id);
652: RAISE FND_API.G_EXC_ERROR;
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 652: RAISE FND_API.G_EXC_ERROR;

648: EXCEPTION
649: when FND_API.G_EXC_ERROR then
650: x_return_status := FND_API.G_RET_STS_ERROR ;
651: dbms_sql.close_cursor(l_cursor_id);
652: RAISE FND_API.G_EXC_ERROR;
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: dbms_sql.close_cursor(l_cursor_id);
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 653: when FND_API.G_EXC_UNEXPECTED_ERROR then

649: when FND_API.G_EXC_ERROR then
650: x_return_status := FND_API.G_RET_STS_ERROR ;
651: dbms_sql.close_cursor(l_cursor_id);
652: RAISE FND_API.G_EXC_ERROR;
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: dbms_sql.close_cursor(l_cursor_id);
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: when others then

Line 654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

650: x_return_status := FND_API.G_RET_STS_ERROR ;
651: dbms_sql.close_cursor(l_cursor_id);
652: RAISE FND_API.G_EXC_ERROR;
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: dbms_sql.close_cursor(l_cursor_id);
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: when others then
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

652: RAISE FND_API.G_EXC_ERROR;
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: dbms_sql.close_cursor(l_cursor_id);
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: when others then
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
659: dbms_sql.close_cursor(l_cursor_id);
660: BIS_VG_UTIL.Add_Error_Message

Line 658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: dbms_sql.close_cursor(l_cursor_id);
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: when others then
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
659: dbms_sql.close_cursor(l_cursor_id);
660: BIS_VG_UTIL.Add_Error_Message
661: ( p_error_msg_id => SQLCODE
662: , p_error_description => SQLERRM

Line 672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

668: , x_return_status
669: , x_error_Tbl
670: );
671:
672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
673:
674:
675: END put_decode_statement_languages;
676: --

Line 713: when FND_API.G_EXC_ERROR then

709: --
710:
711:
712: EXCEPTION
713: when FND_API.G_EXC_ERROR then
714: x_return_status := FND_API.G_RET_STS_ERROR ;
715: if (col_cursor%ISOPEN) THEN
716: CLOSE col_cursor;
717: end if;

Line 714: x_return_status := FND_API.G_RET_STS_ERROR ;

710:
711:
712: EXCEPTION
713: when FND_API.G_EXC_ERROR then
714: x_return_status := FND_API.G_RET_STS_ERROR ;
715: if (col_cursor%ISOPEN) THEN
716: CLOSE col_cursor;
717: end if;
718: RAISE FND_API.G_EXC_ERROR;

Line 718: RAISE FND_API.G_EXC_ERROR;

714: x_return_status := FND_API.G_RET_STS_ERROR ;
715: if (col_cursor%ISOPEN) THEN
716: CLOSE col_cursor;
717: end if;
718: RAISE FND_API.G_EXC_ERROR;
719: when FND_API.G_EXC_UNEXPECTED_ERROR then
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
721: if (col_cursor%ISOPEN) THEN
722: CLOSE col_cursor;

Line 719: when FND_API.G_EXC_UNEXPECTED_ERROR then

715: if (col_cursor%ISOPEN) THEN
716: CLOSE col_cursor;
717: end if;
718: RAISE FND_API.G_EXC_ERROR;
719: when FND_API.G_EXC_UNEXPECTED_ERROR then
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
721: if (col_cursor%ISOPEN) THEN
722: CLOSE col_cursor;
723: end if;

Line 720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

716: CLOSE col_cursor;
717: end if;
718: RAISE FND_API.G_EXC_ERROR;
719: when FND_API.G_EXC_UNEXPECTED_ERROR then
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
721: if (col_cursor%ISOPEN) THEN
722: CLOSE col_cursor;
723: end if;
724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
721: if (col_cursor%ISOPEN) THEN
722: CLOSE col_cursor;
723: end if;
724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
725: when others then
726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
727: if (col_cursor%ISOPEN) THEN
728: CLOSE col_cursor;

Line 726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

722: CLOSE col_cursor;
723: end if;
724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
725: when others then
726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
727: if (col_cursor%ISOPEN) THEN
728: CLOSE col_cursor;
729: end if;
730: BIS_VG_UTIL.Add_Error_Message

Line 742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

738: , x_return_status
739: , x_error_Tbl
740: );
741:
742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
743:
744: END check_language;
745: --
746: /* ============================================================================

Line 809: when FND_API.G_EXC_ERROR then

805: BIS_DEBUG_PUB.Add('< add_select_info');
806: --
807:
808: EXCEPTION
809: when FND_API.G_EXC_ERROR then
810: x_return_status := FND_API.G_RET_STS_ERROR ;
811: RAISE FND_API.G_EXC_ERROR;
812: when FND_API.G_EXC_UNEXPECTED_ERROR then
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 810: x_return_status := FND_API.G_RET_STS_ERROR ;

806: --
807:
808: EXCEPTION
809: when FND_API.G_EXC_ERROR then
810: x_return_status := FND_API.G_RET_STS_ERROR ;
811: RAISE FND_API.G_EXC_ERROR;
812: when FND_API.G_EXC_UNEXPECTED_ERROR then
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 811: RAISE FND_API.G_EXC_ERROR;

807:
808: EXCEPTION
809: when FND_API.G_EXC_ERROR then
810: x_return_status := FND_API.G_RET_STS_ERROR ;
811: RAISE FND_API.G_EXC_ERROR;
812: when FND_API.G_EXC_UNEXPECTED_ERROR then
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: when others then

Line 812: when FND_API.G_EXC_UNEXPECTED_ERROR then

808: EXCEPTION
809: when FND_API.G_EXC_ERROR then
810: x_return_status := FND_API.G_RET_STS_ERROR ;
811: RAISE FND_API.G_EXC_ERROR;
812: when FND_API.G_EXC_UNEXPECTED_ERROR then
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: when others then
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

809: when FND_API.G_EXC_ERROR then
810: x_return_status := FND_API.G_RET_STS_ERROR ;
811: RAISE FND_API.G_EXC_ERROR;
812: when FND_API.G_EXC_UNEXPECTED_ERROR then
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: when others then
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
817: BIS_VG_UTIL.Add_Error_Message

Line 814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

810: x_return_status := FND_API.G_RET_STS_ERROR ;
811: RAISE FND_API.G_EXC_ERROR;
812: when FND_API.G_EXC_UNEXPECTED_ERROR then
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: when others then
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
817: BIS_VG_UTIL.Add_Error_Message
818: ( p_error_msg_id => SQLCODE

Line 816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

812: when FND_API.G_EXC_UNEXPECTED_ERROR then
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: when others then
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
817: BIS_VG_UTIL.Add_Error_Message
818: ( p_error_msg_id => SQLCODE
819: , p_error_description => SQLERRM
820: , p_error_proc_name => G_PKG_NAME||'.add_select_info'

Line 828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

824: bis_vg_log.update_failure_log( x_error_tbl
825: , x_return_status
826: , x_error_Tbl
827: );
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829:
830: END add_select_info;
831: --
832: --============================================================================

Line 900: RAISE FND_API.G_EXC_ERROR;

896: bis_vg_log.update_failure_log( x_error_tbl
897: , x_return_status
898: , x_error_Tbl
899: );
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902:
903: l_tmp_pointer := bis_vg_util.increment_pointer
904: ( p_View_Select_Table

Line 941: RAISE FND_API.G_EXC_ERROR;

937: bis_vg_log.update_failure_log( x_error_tbl
938: , x_return_status
939: , x_error_Tbl
940: );
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;
943: --
944: -- replace two consecutive single quotes by one single quote
945: x_expr := REPLACE(x_expr, '''''', '''');

Line 981: RAISE FND_API.G_EXC_ERROR;

977: bis_vg_log.update_failure_log( x_error_tbl
978: , x_return_status
979: , x_error_Tbl
980: );
981: RAISE FND_API.G_EXC_ERROR;
982:
983: END IF;
984: --
985: -- get the lookup type

Line 1018: RAISE FND_API.G_EXC_ERROR;

1014: bis_vg_log.update_failure_log( x_error_tbl
1015: , x_return_status
1016: , x_error_Tbl
1017: );
1018: RAISE FND_API.G_EXC_ERROR;
1019:
1020: END IF;
1021: --
1022: -- get the lookup column

Line 1049: RAISE FND_API.G_EXC_ERROR;

1045: bis_vg_log.update_failure_log( x_error_tbl
1046: , x_return_status
1047: , x_error_Tbl
1048: );
1049: RAISE FND_API.G_EXC_ERROR;
1050: END IF;
1051:
1052: BIS_DEBUG_PUB.Add('Parse_LA_Select Tag = '|| l_str);
1053:

Line 1058: when FND_API.G_EXC_ERROR then

1054:
1055: BIS_DEBUG_PUB.Add('< parse_LA_select');
1056: --
1057: EXCEPTION
1058: when FND_API.G_EXC_ERROR then
1059: x_return_status := FND_API.G_RET_STS_ERROR ;
1060: RAISE FND_API.G_EXC_ERROR;
1061: when FND_API.G_EXC_UNEXPECTED_ERROR then
1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1059: x_return_status := FND_API.G_RET_STS_ERROR ;

1055: BIS_DEBUG_PUB.Add('< parse_LA_select');
1056: --
1057: EXCEPTION
1058: when FND_API.G_EXC_ERROR then
1059: x_return_status := FND_API.G_RET_STS_ERROR ;
1060: RAISE FND_API.G_EXC_ERROR;
1061: when FND_API.G_EXC_UNEXPECTED_ERROR then
1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1060: RAISE FND_API.G_EXC_ERROR;

1056: --
1057: EXCEPTION
1058: when FND_API.G_EXC_ERROR then
1059: x_return_status := FND_API.G_RET_STS_ERROR ;
1060: RAISE FND_API.G_EXC_ERROR;
1061: when FND_API.G_EXC_UNEXPECTED_ERROR then
1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: when others then

Line 1061: when FND_API.G_EXC_UNEXPECTED_ERROR then

1057: EXCEPTION
1058: when FND_API.G_EXC_ERROR then
1059: x_return_status := FND_API.G_RET_STS_ERROR ;
1060: RAISE FND_API.G_EXC_ERROR;
1061: when FND_API.G_EXC_UNEXPECTED_ERROR then
1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: when others then
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1058: when FND_API.G_EXC_ERROR then
1059: x_return_status := FND_API.G_RET_STS_ERROR ;
1060: RAISE FND_API.G_EXC_ERROR;
1061: when FND_API.G_EXC_UNEXPECTED_ERROR then
1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: when others then
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1066: BIS_VG_UTIL.Add_Error_Message

Line 1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1059: x_return_status := FND_API.G_RET_STS_ERROR ;
1060: RAISE FND_API.G_EXC_ERROR;
1061: when FND_API.G_EXC_UNEXPECTED_ERROR then
1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: when others then
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1066: BIS_VG_UTIL.Add_Error_Message
1067: ( p_error_msg_id => SQLCODE

Line 1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1061: when FND_API.G_EXC_UNEXPECTED_ERROR then
1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: when others then
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1066: BIS_VG_UTIL.Add_Error_Message
1067: ( p_error_msg_id => SQLCODE
1068: , p_error_description => SQLERRM
1069: , p_error_proc_name => G_PKG_NAME||'.parse_LA_select'

Line 1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1073: bis_vg_log.update_failure_log( x_error_tbl
1074: , x_return_status
1075: , x_error_Tbl
1076: );
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078:
1079:
1080: END parse_LA_select;
1081:

Line 1251: RAISE FND_API.G_EXC_ERROR;

1247: bis_vg_log.update_failure_log( x_error_tbl
1248: , x_return_status
1249: , x_error_Tbl
1250: );
1251: RAISE FND_API.G_EXC_ERROR;
1252: END IF;
1253: END IF;
1254: --
1255: BIS_DEBUG_PUB.Add('> put_decode_in_select');

Line 1258: when FND_API.G_EXC_ERROR then

1254: --
1255: BIS_DEBUG_PUB.Add('> put_decode_in_select');
1256: --
1257: EXCEPTION
1258: when FND_API.G_EXC_ERROR then
1259: x_return_status := FND_API.G_RET_STS_ERROR ;
1260: RAISE FND_API.G_EXC_ERROR;
1261: when FND_API.G_EXC_UNEXPECTED_ERROR then
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1259: x_return_status := FND_API.G_RET_STS_ERROR ;

1255: BIS_DEBUG_PUB.Add('> put_decode_in_select');
1256: --
1257: EXCEPTION
1258: when FND_API.G_EXC_ERROR then
1259: x_return_status := FND_API.G_RET_STS_ERROR ;
1260: RAISE FND_API.G_EXC_ERROR;
1261: when FND_API.G_EXC_UNEXPECTED_ERROR then
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1260: RAISE FND_API.G_EXC_ERROR;

1256: --
1257: EXCEPTION
1258: when FND_API.G_EXC_ERROR then
1259: x_return_status := FND_API.G_RET_STS_ERROR ;
1260: RAISE FND_API.G_EXC_ERROR;
1261: when FND_API.G_EXC_UNEXPECTED_ERROR then
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: when others then

Line 1261: when FND_API.G_EXC_UNEXPECTED_ERROR then

1257: EXCEPTION
1258: when FND_API.G_EXC_ERROR then
1259: x_return_status := FND_API.G_RET_STS_ERROR ;
1260: RAISE FND_API.G_EXC_ERROR;
1261: when FND_API.G_EXC_UNEXPECTED_ERROR then
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: when others then
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1258: when FND_API.G_EXC_ERROR then
1259: x_return_status := FND_API.G_RET_STS_ERROR ;
1260: RAISE FND_API.G_EXC_ERROR;
1261: when FND_API.G_EXC_UNEXPECTED_ERROR then
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: when others then
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1266: BIS_VG_UTIL.Add_Error_Message

Line 1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1259: x_return_status := FND_API.G_RET_STS_ERROR ;
1260: RAISE FND_API.G_EXC_ERROR;
1261: when FND_API.G_EXC_UNEXPECTED_ERROR then
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: when others then
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1266: BIS_VG_UTIL.Add_Error_Message
1267: ( p_error_msg_id => SQLCODE

Line 1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1261: when FND_API.G_EXC_UNEXPECTED_ERROR then
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: when others then
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1266: BIS_VG_UTIL.Add_Error_Message
1267: ( p_error_msg_id => SQLCODE
1268: , p_error_description => SQLERRM
1269: , p_error_proc_name => G_PKG_NAME||'.put_decode_in_select'

Line 1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1273: bis_vg_log.update_failure_log( x_error_tbl
1274: , x_return_status
1275: , x_error_Tbl
1276: );
1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1278:
1279: END put_decode_in_select;
1280: --
1281: /* ============================================================================

Line 1346: when FND_API.G_EXC_ERROR then

1342: --
1343:
1344:
1345: EXCEPTION
1346: when FND_API.G_EXC_ERROR then
1347: x_return_status := FND_API.G_RET_STS_ERROR ;
1348: RAISE FND_API.G_EXC_ERROR;
1349: when FND_API.G_EXC_UNEXPECTED_ERROR then
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1347: x_return_status := FND_API.G_RET_STS_ERROR ;

1343:
1344:
1345: EXCEPTION
1346: when FND_API.G_EXC_ERROR then
1347: x_return_status := FND_API.G_RET_STS_ERROR ;
1348: RAISE FND_API.G_EXC_ERROR;
1349: when FND_API.G_EXC_UNEXPECTED_ERROR then
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1348: RAISE FND_API.G_EXC_ERROR;

1344:
1345: EXCEPTION
1346: when FND_API.G_EXC_ERROR then
1347: x_return_status := FND_API.G_RET_STS_ERROR ;
1348: RAISE FND_API.G_EXC_ERROR;
1349: when FND_API.G_EXC_UNEXPECTED_ERROR then
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1352: when others then

Line 1349: when FND_API.G_EXC_UNEXPECTED_ERROR then

1345: EXCEPTION
1346: when FND_API.G_EXC_ERROR then
1347: x_return_status := FND_API.G_RET_STS_ERROR ;
1348: RAISE FND_API.G_EXC_ERROR;
1349: when FND_API.G_EXC_UNEXPECTED_ERROR then
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1352: when others then
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1346: when FND_API.G_EXC_ERROR then
1347: x_return_status := FND_API.G_RET_STS_ERROR ;
1348: RAISE FND_API.G_EXC_ERROR;
1349: when FND_API.G_EXC_UNEXPECTED_ERROR then
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1352: when others then
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1354: BIS_VG_UTIL.Add_Error_Message

Line 1351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1347: x_return_status := FND_API.G_RET_STS_ERROR ;
1348: RAISE FND_API.G_EXC_ERROR;
1349: when FND_API.G_EXC_UNEXPECTED_ERROR then
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1352: when others then
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1354: BIS_VG_UTIL.Add_Error_Message
1355: ( p_error_msg_id => SQLCODE

Line 1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1349: when FND_API.G_EXC_UNEXPECTED_ERROR then
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1352: when others then
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1354: BIS_VG_UTIL.Add_Error_Message
1355: ( p_error_msg_id => SQLCODE
1356: , p_error_description => SQLERRM
1357: , p_error_proc_name => G_PKG_NAME||'.add_Lookup_Info'

Line 1365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1361: bis_vg_log.update_failure_log( x_error_tbl
1362: , x_return_status
1363: , x_error_Tbl
1364: );
1365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1366:
1367: END add_Lookup_Info;
1368: --
1369: END bis_vg_lookup;