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

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

69: --x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type ) IS l_str
70: --bis_vg_types.view_text_table_rec_type; l_char VARCHAR(1); l_length NUMBER;
71: --BEGIN
72: -- bis_debug_pub.Add('> remove_blank_lines');
73: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
74: --
75: -- FOR i IN 1 .. p_view_text_table.COUNT LOOP
76: -- l_str := p_view_text_table(i);
77: -- l_length := Length(l_str);

Line 93: -- when FND_API.G_EXC_ERROR then

89: -- bis_debug_pub.Add('< remove_blank_lines');
90: --
91: --
92: --EXCEPTION
93: -- when FND_API.G_EXC_ERROR then
94: -- x_return_status := FND_API.G_RET_STS_ERROR ;
95: -- RAISE FND_API.G_EXC_ERROR;
96: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
97: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

90: --
91: --
92: --EXCEPTION
93: -- when FND_API.G_EXC_ERROR then
94: -- x_return_status := FND_API.G_RET_STS_ERROR ;
95: -- RAISE FND_API.G_EXC_ERROR;
96: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
97: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
98: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 95: -- RAISE FND_API.G_EXC_ERROR;

91: --
92: --EXCEPTION
93: -- when FND_API.G_EXC_ERROR then
94: -- x_return_status := FND_API.G_RET_STS_ERROR ;
95: -- RAISE FND_API.G_EXC_ERROR;
96: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
97: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
98: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: -- when others then

Line 96: -- when FND_API.G_EXC_UNEXPECTED_ERROR then

92: --EXCEPTION
93: -- when FND_API.G_EXC_ERROR then
94: -- x_return_status := FND_API.G_RET_STS_ERROR ;
95: -- RAISE FND_API.G_EXC_ERROR;
96: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
97: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
98: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: -- when others then
100: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

93: -- when FND_API.G_EXC_ERROR then
94: -- x_return_status := FND_API.G_RET_STS_ERROR ;
95: -- RAISE FND_API.G_EXC_ERROR;
96: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
97: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
98: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: -- when others then
100: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: -- BIS_VG_UTIL.Add_Error_Message

Line 98: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

94: -- x_return_status := FND_API.G_RET_STS_ERROR ;
95: -- RAISE FND_API.G_EXC_ERROR;
96: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
97: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
98: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: -- when others then
100: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: -- BIS_VG_UTIL.Add_Error_Message
102: -- ( p_error_msg_id => SQLCODE

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

96: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
97: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
98: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: -- when others then
100: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: -- BIS_VG_UTIL.Add_Error_Message
102: -- ( p_error_msg_id => SQLCODE
103: -- , p_error_description => SQLERRM
104: -- , p_error_proc_name => G_PKG_NAME||'.remove_blank_lines'

Line 112: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

108: -- bis_vg_log.update_failure_log( x_error_tbl
109: -- , x_return_status
110: -- , x_error_Tbl
111: -- );
112: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: --
114: --END remove_blank_lines;
115: --
116: -- ============================================================================

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

135: -- p_dummy INTEGER;
136: ----
137: -- BEGIN
138: -- bis_debug_pub.Add('> create_DSQL_view');
139: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
140: -- FOR i IN 1 .. p_View_Text_Table.COUNT LOOP
141: -- p_SQL_text := p_SQL_text || p_View_Text_Table(i);
142: -- END LOOP;
143: -- p_CursorID := DBMS_SQL.OPEN_CURSOR;

Line 150: -- when FND_API.G_EXC_ERROR then

146: -- bis_debug_pub.Add('< create_DSQL_view');
147: --
148: --
149: -- EXCEPTION
150: -- when FND_API.G_EXC_ERROR then
151: -- x_return_status := FND_API.G_RET_STS_ERROR ;
152: -- RAISE FND_API.G_EXC_ERROR;
153: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
154: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

147: --
148: --
149: -- EXCEPTION
150: -- when FND_API.G_EXC_ERROR then
151: -- x_return_status := FND_API.G_RET_STS_ERROR ;
152: -- RAISE FND_API.G_EXC_ERROR;
153: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
154: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
155: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 152: -- RAISE FND_API.G_EXC_ERROR;

148: --
149: -- EXCEPTION
150: -- when FND_API.G_EXC_ERROR then
151: -- x_return_status := FND_API.G_RET_STS_ERROR ;
152: -- RAISE FND_API.G_EXC_ERROR;
153: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
154: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
155: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: -- when others then

Line 153: -- when FND_API.G_EXC_UNEXPECTED_ERROR then

149: -- EXCEPTION
150: -- when FND_API.G_EXC_ERROR then
151: -- x_return_status := FND_API.G_RET_STS_ERROR ;
152: -- RAISE FND_API.G_EXC_ERROR;
153: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
154: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
155: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: -- when others then
157: --

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

150: -- when FND_API.G_EXC_ERROR then
151: -- x_return_status := FND_API.G_RET_STS_ERROR ;
152: -- RAISE FND_API.G_EXC_ERROR;
153: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
154: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
155: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: -- when others then
157: --
158: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 155: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

151: -- x_return_status := FND_API.G_RET_STS_ERROR ;
152: -- RAISE FND_API.G_EXC_ERROR;
153: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
154: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
155: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: -- when others then
157: --
158: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159: -- BIS_VG_UTIL.Add_Error_Message

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

154: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
155: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: -- when others then
157: --
158: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159: -- BIS_VG_UTIL.Add_Error_Message
160: -- ( p_error_msg_id => SQLCODE
161: -- , p_error_description => SQLERRM
162: -- , p_error_proc_name => G_PKG_NAME||'.create_DSQL_view'

Line 170: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

166: -- bis_vg_log.update_failure_log( x_error_tbl
167: -- , x_return_status
168: -- , x_error_Tbl
169: -- );
170: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
171: --
172: -- END create_DSQL_view;
173: -- ============================================================================
174: --PROCEDURE : execute_DDL_Statement

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

198: --l_retvar BOOLEAN;
199: ----
200: --BEGIN
201: -- bis_debug_pub.Add('> execute_DDL_Statement');
202: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
203: -- l_retvar := FND_INSTALLATION.GET_APP_INFO
204: -- ( 'FND'
205: -- , dummy1
206: -- , dummy2

Line 240: -- when FND_API.G_EXC_ERROR then

236: ----
237: --
238: --
239: --EXCEPTION
240: -- when FND_API.G_EXC_ERROR then
241: -- x_return_status := FND_API.G_RET_STS_ERROR ;
242: -- RAISE FND_API.G_EXC_ERROR;
243: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
244: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

237: --
238: --
239: --EXCEPTION
240: -- when FND_API.G_EXC_ERROR then
241: -- x_return_status := FND_API.G_RET_STS_ERROR ;
242: -- RAISE FND_API.G_EXC_ERROR;
243: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
244: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 242: -- RAISE FND_API.G_EXC_ERROR;

238: --
239: --EXCEPTION
240: -- when FND_API.G_EXC_ERROR then
241: -- x_return_status := FND_API.G_RET_STS_ERROR ;
242: -- RAISE FND_API.G_EXC_ERROR;
243: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
244: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: -- when others then

Line 243: -- when FND_API.G_EXC_UNEXPECTED_ERROR then

239: --EXCEPTION
240: -- when FND_API.G_EXC_ERROR then
241: -- x_return_status := FND_API.G_RET_STS_ERROR ;
242: -- RAISE FND_API.G_EXC_ERROR;
243: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
244: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: -- when others then
247: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

240: -- when FND_API.G_EXC_ERROR then
241: -- x_return_status := FND_API.G_RET_STS_ERROR ;
242: -- RAISE FND_API.G_EXC_ERROR;
243: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
244: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: -- when others then
247: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: -- BIS_VG_UTIL.Add_Error_Message

Line 245: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

241: -- x_return_status := FND_API.G_RET_STS_ERROR ;
242: -- RAISE FND_API.G_EXC_ERROR;
243: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
244: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: -- when others then
247: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: -- BIS_VG_UTIL.Add_Error_Message
249: -- ( p_error_msg_id => SQLCODE

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

243: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
244: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: -- when others then
247: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: -- BIS_VG_UTIL.Add_Error_Message
249: -- ( p_error_msg_id => SQLCODE
250: -- , p_error_description => SQLERRM
251: -- , p_error_proc_name => G_PKG_NAME||'.execute_DDL_Statement'

Line 259: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

255: -- bis_vg_log.update_failure_log( x_error_tbl
256: -- , x_return_status
257: -- , x_error_Tbl
258: -- );
259: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260: --
261: --END execute_DDL_Statement;
262: --
263: --

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

282: --l_count INTEGER;
283: --
284: --BEGIN
285: -- bis_debug_pub.Add('> build_DDL_Statement');
286: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
287: -- FOR l_count IN 1 .. p_View_Text_Table.COUNT LOOP
288: -- AD_DDL.build_statement(' '||p_View_Text_Table(l_count)||' ', l_count);
289: -- END LOOP;
290: -- bis_debug_pub.Add('< build_DDL_Statement');

Line 294: -- when FND_API.G_EXC_ERROR then

290: -- bis_debug_pub.Add('< build_DDL_Statement');
291: --
292: --
293: --EXCEPTION
294: -- when FND_API.G_EXC_ERROR then
295: -- x_return_status := FND_API.G_RET_STS_ERROR ;
296: -- RAISE FND_API.G_EXC_ERROR;
297: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
298: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

291: --
292: --
293: --EXCEPTION
294: -- when FND_API.G_EXC_ERROR then
295: -- x_return_status := FND_API.G_RET_STS_ERROR ;
296: -- RAISE FND_API.G_EXC_ERROR;
297: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
298: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 296: -- RAISE FND_API.G_EXC_ERROR;

292: --
293: --EXCEPTION
294: -- when FND_API.G_EXC_ERROR then
295: -- x_return_status := FND_API.G_RET_STS_ERROR ;
296: -- RAISE FND_API.G_EXC_ERROR;
297: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
298: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: -- when others then

Line 297: -- when FND_API.G_EXC_UNEXPECTED_ERROR then

293: --EXCEPTION
294: -- when FND_API.G_EXC_ERROR then
295: -- x_return_status := FND_API.G_RET_STS_ERROR ;
296: -- RAISE FND_API.G_EXC_ERROR;
297: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
298: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: -- when others then
301: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

294: -- when FND_API.G_EXC_ERROR then
295: -- x_return_status := FND_API.G_RET_STS_ERROR ;
296: -- RAISE FND_API.G_EXC_ERROR;
297: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
298: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: -- when others then
301: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302: -- BIS_VG_UTIL.Add_Error_Message

Line 299: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

295: -- x_return_status := FND_API.G_RET_STS_ERROR ;
296: -- RAISE FND_API.G_EXC_ERROR;
297: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
298: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: -- when others then
301: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302: -- BIS_VG_UTIL.Add_Error_Message
303: -- ( p_error_msg_id => SQLCODE

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

297: -- when FND_API.G_EXC_UNEXPECTED_ERROR then
298: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: -- when others then
301: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302: -- BIS_VG_UTIL.Add_Error_Message
303: -- ( p_error_msg_id => SQLCODE
304: -- , p_error_description => SQLERRM
305: -- , p_error_proc_name => G_PKG_NAME||'.build_DDL_Statement'

Line 313: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

309: -- bis_vg_log.update_failure_log( x_error_tbl
310: -- , x_return_status
311: -- , x_error_Tbl
312: -- );
313: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: --
315: --END build_DDL_Statement;
316:
317: --=====================

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

346: l_total NUMBER;
347: l_dummy VARCHAR2(100);
348: BEGIN
349: bis_debug_pub.Add('> do_long_ddl');
350: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352:
353: FOR l_count IN 1 .. p_View_Create_Text_Table.COUNT
354: LOOP

Line 386: when FND_API.G_EXC_ERROR then

382: );
383: bis_debug_pub.Add('< do_long_ddl');
384:
385: EXCEPTION
386: when FND_API.G_EXC_ERROR then
387: --- x_return_status := FND_API.G_RET_STS_ERROR ;
388: RAISE FND_API.G_EXC_ERROR;
389: when FND_API.G_EXC_UNEXPECTED_ERROR then
390: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

383: bis_debug_pub.Add('< do_long_ddl');
384:
385: EXCEPTION
386: when FND_API.G_EXC_ERROR then
387: --- x_return_status := FND_API.G_RET_STS_ERROR ;
388: RAISE FND_API.G_EXC_ERROR;
389: when FND_API.G_EXC_UNEXPECTED_ERROR then
390: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 388: RAISE FND_API.G_EXC_ERROR;

384:
385: EXCEPTION
386: when FND_API.G_EXC_ERROR then
387: --- x_return_status := FND_API.G_RET_STS_ERROR ;
388: RAISE FND_API.G_EXC_ERROR;
389: when FND_API.G_EXC_UNEXPECTED_ERROR then
390: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: when others then

Line 389: when FND_API.G_EXC_UNEXPECTED_ERROR then

385: EXCEPTION
386: when FND_API.G_EXC_ERROR then
387: --- x_return_status := FND_API.G_RET_STS_ERROR ;
388: RAISE FND_API.G_EXC_ERROR;
389: when FND_API.G_EXC_UNEXPECTED_ERROR then
390: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: when others then
393: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

386: when FND_API.G_EXC_ERROR then
387: --- x_return_status := FND_API.G_RET_STS_ERROR ;
388: RAISE FND_API.G_EXC_ERROR;
389: when FND_API.G_EXC_UNEXPECTED_ERROR then
390: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: when others then
393: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
394: BIS_VG_UTIL.Add_Error_Message

Line 391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

387: --- x_return_status := FND_API.G_RET_STS_ERROR ;
388: RAISE FND_API.G_EXC_ERROR;
389: when FND_API.G_EXC_UNEXPECTED_ERROR then
390: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: when others then
393: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
394: BIS_VG_UTIL.Add_Error_Message
395: ( p_error_msg_id => SQLCODE

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

389: when FND_API.G_EXC_UNEXPECTED_ERROR then
390: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: when others then
393: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
394: BIS_VG_UTIL.Add_Error_Message
395: ( p_error_msg_id => SQLCODE
396: , p_error_description => SQLERRM||'[ '||ad_ddl.error_buf||' ]'
397: , p_error_proc_name => G_PKG_NAME||'.do_long_ddl'

Line 405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

401: bis_vg_log.update_failure_log( x_error_tbl
402: , x_return_status
403: , x_error_Tbl
404: );
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406:
407: END do_long_ddl;
408: --
409: -- ============================================================================

Line 440: x_return_status := FND_API.G_RET_STS_SUCCESS;

436: l_count NUMBER;
437: l_length NUMBER := 0;
438: BEGIN
439: bis_debug_pub.Add('> do_short_ddl');
440: x_return_status := FND_API.G_RET_STS_SUCCESS;
441:
442:
443: BEGIN
444: FOR l_count IN 1 .. p_View_Create_Text_Table.COUNT

Line 499: when FND_API.G_EXC_ERROR then

495: raise;
496: when numeric_or_value_error then
497: bis_debug_pub.Add('Numeric_or_value error unexpected in do_short_ddl');
498: RAISE;
499: when FND_API.G_EXC_ERROR then
500: x_return_status := FND_API.G_RET_STS_ERROR ;
501: RAISE FND_API.G_EXC_ERROR;
502: when FND_API.G_EXC_UNEXPECTED_ERROR then
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 500: x_return_status := FND_API.G_RET_STS_ERROR ;

496: when numeric_or_value_error then
497: bis_debug_pub.Add('Numeric_or_value error unexpected in do_short_ddl');
498: RAISE;
499: when FND_API.G_EXC_ERROR then
500: x_return_status := FND_API.G_RET_STS_ERROR ;
501: RAISE FND_API.G_EXC_ERROR;
502: when FND_API.G_EXC_UNEXPECTED_ERROR then
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 501: RAISE FND_API.G_EXC_ERROR;

497: bis_debug_pub.Add('Numeric_or_value error unexpected in do_short_ddl');
498: RAISE;
499: when FND_API.G_EXC_ERROR then
500: x_return_status := FND_API.G_RET_STS_ERROR ;
501: RAISE FND_API.G_EXC_ERROR;
502: when FND_API.G_EXC_UNEXPECTED_ERROR then
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: when others then

Line 502: when FND_API.G_EXC_UNEXPECTED_ERROR then

498: RAISE;
499: when FND_API.G_EXC_ERROR then
500: x_return_status := FND_API.G_RET_STS_ERROR ;
501: RAISE FND_API.G_EXC_ERROR;
502: when FND_API.G_EXC_UNEXPECTED_ERROR then
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: when others then
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

499: when FND_API.G_EXC_ERROR then
500: x_return_status := FND_API.G_RET_STS_ERROR ;
501: RAISE FND_API.G_EXC_ERROR;
502: when FND_API.G_EXC_UNEXPECTED_ERROR then
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: when others then
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
507: BIS_VG_UTIL.Add_Error_Message

Line 504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

500: x_return_status := FND_API.G_RET_STS_ERROR ;
501: RAISE FND_API.G_EXC_ERROR;
502: when FND_API.G_EXC_UNEXPECTED_ERROR then
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: when others then
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
507: BIS_VG_UTIL.Add_Error_Message
508: ( p_error_msg_id => SQLCODE

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

502: when FND_API.G_EXC_UNEXPECTED_ERROR then
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: when others then
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
507: BIS_VG_UTIL.Add_Error_Message
508: ( p_error_msg_id => SQLCODE
509: , p_error_description => SQLERRM||'[ '||ad_ddl.error_buf||' ]'
510: , p_error_proc_name => G_PKG_NAME||'.do_short_ddl'

Line 518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

514: bis_vg_log.update_failure_log( x_error_tbl
515: , x_return_status
516: , x_error_Tbl
517: );
518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519:
520: END do_short_ddl;
521:
522:

Line 552: x_return_status := FND_API.G_RET_STS_SUCCESS;

548: l_pos NUMBER;
549: --
550: BEGIN
551: bis_debug_pub.Add('> make_column_len30');
552: x_return_status := FND_API.G_RET_STS_SUCCESS;
553: x_View_Column_Table := p_View_Column_Table;
554: x_View_Column_Comment_Table := p_View_Column_Comment_Table;
555: FOR i IN 1 .. p_View_Column_Table.COUNT LOOP
556: l_column_name := p_View_Column_Table(i);

Line 598: when FND_API.G_EXC_ERROR then

594: END LOOP;
595: bis_debug_pub.Add('< make_column_len30');
596:
597: EXCEPTION
598: when FND_API.G_EXC_ERROR then
599: x_return_status := FND_API.G_RET_STS_ERROR ;
600: RAISE FND_API.G_EXC_ERROR;
601: when FND_API.G_EXC_UNEXPECTED_ERROR then
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 599: x_return_status := FND_API.G_RET_STS_ERROR ;

595: bis_debug_pub.Add('< make_column_len30');
596:
597: EXCEPTION
598: when FND_API.G_EXC_ERROR then
599: x_return_status := FND_API.G_RET_STS_ERROR ;
600: RAISE FND_API.G_EXC_ERROR;
601: when FND_API.G_EXC_UNEXPECTED_ERROR then
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 600: RAISE FND_API.G_EXC_ERROR;

596:
597: EXCEPTION
598: when FND_API.G_EXC_ERROR then
599: x_return_status := FND_API.G_RET_STS_ERROR ;
600: RAISE FND_API.G_EXC_ERROR;
601: when FND_API.G_EXC_UNEXPECTED_ERROR then
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: when others then

Line 601: when FND_API.G_EXC_UNEXPECTED_ERROR then

597: EXCEPTION
598: when FND_API.G_EXC_ERROR then
599: x_return_status := FND_API.G_RET_STS_ERROR ;
600: RAISE FND_API.G_EXC_ERROR;
601: when FND_API.G_EXC_UNEXPECTED_ERROR then
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: when others then
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

598: when FND_API.G_EXC_ERROR then
599: x_return_status := FND_API.G_RET_STS_ERROR ;
600: RAISE FND_API.G_EXC_ERROR;
601: when FND_API.G_EXC_UNEXPECTED_ERROR then
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: when others then
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
606: BIS_VG_UTIL.Add_Error_Message

Line 603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

599: x_return_status := FND_API.G_RET_STS_ERROR ;
600: RAISE FND_API.G_EXC_ERROR;
601: when FND_API.G_EXC_UNEXPECTED_ERROR then
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: when others then
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
606: BIS_VG_UTIL.Add_Error_Message
607: ( p_error_msg_id => SQLCODE

Line 605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

601: when FND_API.G_EXC_UNEXPECTED_ERROR then
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: when others then
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
606: BIS_VG_UTIL.Add_Error_Message
607: ( p_error_msg_id => SQLCODE
608: , p_error_description => SQLERRM
609: , p_error_proc_name => G_PKG_NAME||'.make_column_len30'

Line 617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

613: bis_vg_log.update_failure_log( x_error_tbl
614: , x_return_status
615: , x_error_Tbl
616: );
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618:
619:
620: END make_column_len30;
621: --

Line 643: x_return_status := FND_API.G_RET_STS_SUCCESS;

639: RETURN NUMBER IS
640: --
641: BEGIN
642: bis_debug_pub.Add('> find_column');
643: x_return_status := FND_API.G_RET_STS_SUCCESS;
644: FOR i IN 1 .. p_View_Text_Count_Table.COUNT LOOP
645: IF( REPLACE(p_column_name, '^', '_') =
646: REPLACE(p_View_Text_Count_Table(i).Column_name, '^', '_') ) THEN
647: RETURN i;

Line 656: when FND_API.G_EXC_ERROR then

652:
653:
654:
655: EXCEPTION
656: when FND_API.G_EXC_ERROR then
657: x_return_status := FND_API.G_RET_STS_ERROR ;
658: RAISE FND_API.G_EXC_ERROR;
659: when FND_API.G_EXC_UNEXPECTED_ERROR then
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 657: x_return_status := FND_API.G_RET_STS_ERROR ;

653:
654:
655: EXCEPTION
656: when FND_API.G_EXC_ERROR then
657: x_return_status := FND_API.G_RET_STS_ERROR ;
658: RAISE FND_API.G_EXC_ERROR;
659: when FND_API.G_EXC_UNEXPECTED_ERROR then
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 658: RAISE FND_API.G_EXC_ERROR;

654:
655: EXCEPTION
656: when FND_API.G_EXC_ERROR then
657: x_return_status := FND_API.G_RET_STS_ERROR ;
658: RAISE FND_API.G_EXC_ERROR;
659: when FND_API.G_EXC_UNEXPECTED_ERROR then
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
662: when others then

Line 659: when FND_API.G_EXC_UNEXPECTED_ERROR then

655: EXCEPTION
656: when FND_API.G_EXC_ERROR then
657: x_return_status := FND_API.G_RET_STS_ERROR ;
658: RAISE FND_API.G_EXC_ERROR;
659: when FND_API.G_EXC_UNEXPECTED_ERROR then
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
662: when others then
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

656: when FND_API.G_EXC_ERROR then
657: x_return_status := FND_API.G_RET_STS_ERROR ;
658: RAISE FND_API.G_EXC_ERROR;
659: when FND_API.G_EXC_UNEXPECTED_ERROR then
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
662: when others then
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
664: BIS_VG_UTIL.Add_Error_Message

Line 661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

657: x_return_status := FND_API.G_RET_STS_ERROR ;
658: RAISE FND_API.G_EXC_ERROR;
659: when FND_API.G_EXC_UNEXPECTED_ERROR then
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
662: when others then
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
664: BIS_VG_UTIL.Add_Error_Message
665: ( p_error_msg_id => SQLCODE

Line 663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

659: when FND_API.G_EXC_UNEXPECTED_ERROR then
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
662: when others then
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
664: BIS_VG_UTIL.Add_Error_Message
665: ( p_error_msg_id => SQLCODE
666: , p_error_description => SQLERRM
667: , p_error_proc_name => G_PKG_NAME||'.find_column'

Line 675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

671: bis_vg_log.update_failure_log( x_error_tbl
672: , x_return_status
673: , x_error_Tbl
674: );
675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
676:
677: END find_column;
678: --
679: -- ============================================================================

Line 703: x_return_status := FND_API.G_RET_STS_SUCCESS;

699: l_pos NUMBER;
700: --
701: BEGIN
702: bis_debug_pub.Add('> insert_hat_in_column');
703: x_return_status := FND_API.G_RET_STS_SUCCESS;
704: x_column_name := p_column_name;
705: l_pos := INSTRB(p_table_column_name, '^');
706: IF(l_pos > 0) THEN
707: x_column_name := SUBSTRB(p_column_name, 1, l_pos - 1) ||

Line 715: when FND_API.G_EXC_ERROR then

711: bis_debug_pub.Add('< insert_hat_in_column');
712:
713:
714: EXCEPTION
715: when FND_API.G_EXC_ERROR then
716: x_return_status := FND_API.G_RET_STS_ERROR ;
717: RAISE FND_API.G_EXC_ERROR;
718: when FND_API.G_EXC_UNEXPECTED_ERROR then
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 716: x_return_status := FND_API.G_RET_STS_ERROR ;

712:
713:
714: EXCEPTION
715: when FND_API.G_EXC_ERROR then
716: x_return_status := FND_API.G_RET_STS_ERROR ;
717: RAISE FND_API.G_EXC_ERROR;
718: when FND_API.G_EXC_UNEXPECTED_ERROR then
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 717: RAISE FND_API.G_EXC_ERROR;

713:
714: EXCEPTION
715: when FND_API.G_EXC_ERROR then
716: x_return_status := FND_API.G_RET_STS_ERROR ;
717: RAISE FND_API.G_EXC_ERROR;
718: when FND_API.G_EXC_UNEXPECTED_ERROR then
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: when others then

Line 718: when FND_API.G_EXC_UNEXPECTED_ERROR then

714: EXCEPTION
715: when FND_API.G_EXC_ERROR then
716: x_return_status := FND_API.G_RET_STS_ERROR ;
717: RAISE FND_API.G_EXC_ERROR;
718: when FND_API.G_EXC_UNEXPECTED_ERROR then
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: when others then
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

715: when FND_API.G_EXC_ERROR then
716: x_return_status := FND_API.G_RET_STS_ERROR ;
717: RAISE FND_API.G_EXC_ERROR;
718: when FND_API.G_EXC_UNEXPECTED_ERROR then
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: when others then
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
723: BIS_VG_UTIL.Add_Error_Message

Line 720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

716: x_return_status := FND_API.G_RET_STS_ERROR ;
717: RAISE FND_API.G_EXC_ERROR;
718: when FND_API.G_EXC_UNEXPECTED_ERROR then
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: when others then
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
723: BIS_VG_UTIL.Add_Error_Message
724: ( p_error_msg_id => SQLCODE

Line 722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

718: when FND_API.G_EXC_UNEXPECTED_ERROR then
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: when others then
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
723: BIS_VG_UTIL.Add_Error_Message
724: ( p_error_msg_id => SQLCODE
725: , p_error_description => SQLERRM
726: , p_error_proc_name => G_PKG_NAME||'.insert_hat_in_column'

Line 734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

730: bis_vg_log.update_failure_log( x_error_tbl
731: , x_return_status
732: , x_error_Tbl
733: );
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735:
736: END insert_hat_in_column;
737: --
738: -- ============================================================================

Line 772: x_return_status := FND_API.G_RET_STS_SUCCESS;

768: l_pos NUMBER;
769: --
770: BEGIN
771: bis_debug_pub.Add('> make_unique_columns');
772: x_return_status := FND_API.G_RET_STS_SUCCESS;
773: x_View_Column_Table := p_View_Column_Table;
774: x_View_Column_Comment_Table := p_View_Column_Comment_Table;
775: FOR i IN 1 .. x_View_Column_Table.COUNT LOOP
776: x_View_Column_Table(i) := UPPER(x_View_Column_Table(i));

Line 819: when FND_API.G_EXC_ERROR then

815: bis_debug_pub.Add('< make_unique_columns');
816:
817:
818: EXCEPTION
819: when FND_API.G_EXC_ERROR then
820: x_return_status := FND_API.G_RET_STS_ERROR ;
821: RAISE FND_API.G_EXC_ERROR;
822: when FND_API.G_EXC_UNEXPECTED_ERROR then
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 820: x_return_status := FND_API.G_RET_STS_ERROR ;

816:
817:
818: EXCEPTION
819: when FND_API.G_EXC_ERROR then
820: x_return_status := FND_API.G_RET_STS_ERROR ;
821: RAISE FND_API.G_EXC_ERROR;
822: when FND_API.G_EXC_UNEXPECTED_ERROR then
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 821: RAISE FND_API.G_EXC_ERROR;

817:
818: EXCEPTION
819: when FND_API.G_EXC_ERROR then
820: x_return_status := FND_API.G_RET_STS_ERROR ;
821: RAISE FND_API.G_EXC_ERROR;
822: when FND_API.G_EXC_UNEXPECTED_ERROR then
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
825: when others then

Line 822: when FND_API.G_EXC_UNEXPECTED_ERROR then

818: EXCEPTION
819: when FND_API.G_EXC_ERROR then
820: x_return_status := FND_API.G_RET_STS_ERROR ;
821: RAISE FND_API.G_EXC_ERROR;
822: when FND_API.G_EXC_UNEXPECTED_ERROR then
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
825: when others then
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

819: when FND_API.G_EXC_ERROR then
820: x_return_status := FND_API.G_RET_STS_ERROR ;
821: RAISE FND_API.G_EXC_ERROR;
822: when FND_API.G_EXC_UNEXPECTED_ERROR then
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
825: when others then
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
827: BIS_VG_UTIL.Add_Error_Message

Line 824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

820: x_return_status := FND_API.G_RET_STS_ERROR ;
821: RAISE FND_API.G_EXC_ERROR;
822: when FND_API.G_EXC_UNEXPECTED_ERROR then
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
825: when others then
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
827: BIS_VG_UTIL.Add_Error_Message
828: ( p_error_msg_id => SQLCODE

Line 826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

822: when FND_API.G_EXC_UNEXPECTED_ERROR then
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
825: when others then
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
827: BIS_VG_UTIL.Add_Error_Message
828: ( p_error_msg_id => SQLCODE
829: , p_error_description => SQLERRM
830: , p_error_proc_name => G_PKG_NAME||'.make_unique_columns'

Line 838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

834: bis_vg_log.update_failure_log( x_error_tbl
835: , x_return_status
836: , x_error_Tbl
837: );
838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
839:
840: END make_unique_columns;
841: --
842: -- ============================================================================

Line 866: x_return_status := FND_API.G_RET_STS_SUCCESS;

862: l_counter NUMBER;
863: l_occurence_counter NUMBER;
864: BEGIN
865: bis_debug_pub.Add('> format_columns');
866: x_return_status := FND_API.G_RET_STS_SUCCESS;
867: FOR i IN 1 .. p_View_Column_Table.COUNT LOOP
868: x_View_Column_Table(i) := REPLACE(p_View_Column_Table(i), '&', '_');
869: x_View_Column_Table(i) := REPLACE(x_View_Column_Table(i), '"','_');
870: x_View_Column_Table(i) := REPLACE(x_View_Column_Table(i), '^', '_');

Line 947: when FND_API.G_EXC_ERROR then

943: bis_debug_pub.Add('< format_columns');
944:
945:
946: EXCEPTION
947: when FND_API.G_EXC_ERROR then
948: x_return_status := FND_API.G_RET_STS_ERROR ;
949: RAISE FND_API.G_EXC_ERROR;
950: when FND_API.G_EXC_UNEXPECTED_ERROR then
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 948: x_return_status := FND_API.G_RET_STS_ERROR ;

944:
945:
946: EXCEPTION
947: when FND_API.G_EXC_ERROR then
948: x_return_status := FND_API.G_RET_STS_ERROR ;
949: RAISE FND_API.G_EXC_ERROR;
950: when FND_API.G_EXC_UNEXPECTED_ERROR then
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 949: RAISE FND_API.G_EXC_ERROR;

945:
946: EXCEPTION
947: when FND_API.G_EXC_ERROR then
948: x_return_status := FND_API.G_RET_STS_ERROR ;
949: RAISE FND_API.G_EXC_ERROR;
950: when FND_API.G_EXC_UNEXPECTED_ERROR then
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: when others then

Line 950: when FND_API.G_EXC_UNEXPECTED_ERROR then

946: EXCEPTION
947: when FND_API.G_EXC_ERROR then
948: x_return_status := FND_API.G_RET_STS_ERROR ;
949: RAISE FND_API.G_EXC_ERROR;
950: when FND_API.G_EXC_UNEXPECTED_ERROR then
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: when others then
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

947: when FND_API.G_EXC_ERROR then
948: x_return_status := FND_API.G_RET_STS_ERROR ;
949: RAISE FND_API.G_EXC_ERROR;
950: when FND_API.G_EXC_UNEXPECTED_ERROR then
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: when others then
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
955: BIS_VG_UTIL.Add_Error_Message

Line 952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

948: x_return_status := FND_API.G_RET_STS_ERROR ;
949: RAISE FND_API.G_EXC_ERROR;
950: when FND_API.G_EXC_UNEXPECTED_ERROR then
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: when others then
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
955: BIS_VG_UTIL.Add_Error_Message
956: ( p_error_msg_id => SQLCODE

Line 954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

950: when FND_API.G_EXC_UNEXPECTED_ERROR then
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: when others then
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
955: BIS_VG_UTIL.Add_Error_Message
956: ( p_error_msg_id => SQLCODE
957: , p_error_description => SQLERRM
958: , p_error_proc_name => G_PKG_NAME||'.format_columns'

Line 966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

962: bis_vg_log.update_failure_log( x_error_tbl
963: , x_return_status
964: , x_error_Tbl
965: );
966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
967:
968: END format_columns;
969: --
970: -- ============================================================================

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

1009: l_View_Column_Comment_Table4 bis_vg_types.Flex_Column_Comment_Table_Type;
1010: --
1011: BEGIN
1012: bis_debug_pub.Add('> format_Table');
1013: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
1014: l_pos := INSTRB(p_View_Name, 'V_');
1015: x_View_Name := bis_vg_util.get_generated_view_name
1016: ( p_View_name
1017: , l_dummy

Line 1096: when FND_API.G_EXC_ERROR then

1092: bis_debug_pub.Add('< format_Table');
1093:
1094:
1095: EXCEPTION
1096: when FND_API.G_EXC_ERROR then
1097: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1098: RAISE;
1099: when FND_API.G_EXC_UNEXPECTED_ERROR then
1100: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1093:
1094:
1095: EXCEPTION
1096: when FND_API.G_EXC_ERROR then
1097: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1098: RAISE;
1099: when FND_API.G_EXC_UNEXPECTED_ERROR then
1100: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1101: RAISE;

Line 1099: when FND_API.G_EXC_UNEXPECTED_ERROR then

1095: EXCEPTION
1096: when FND_API.G_EXC_ERROR then
1097: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1098: RAISE;
1099: when FND_API.G_EXC_UNEXPECTED_ERROR then
1100: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1101: RAISE;
1102: when others then
1103: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1096: when FND_API.G_EXC_ERROR then
1097: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1098: RAISE;
1099: when FND_API.G_EXC_UNEXPECTED_ERROR then
1100: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1101: RAISE;
1102: when others then
1103: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1104: BIS_VG_UTIL.Add_Error_Message

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

1099: when FND_API.G_EXC_UNEXPECTED_ERROR then
1100: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1101: RAISE;
1102: when others then
1103: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1104: BIS_VG_UTIL.Add_Error_Message
1105: ( p_error_msg_id => SQLCODE
1106: , p_error_description => SQLERRM
1107: , p_error_proc_name => G_PKG_NAME||'.format_Table'

Line 1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1111: bis_vg_log.update_failure_log( x_error_tbl
1112: , l_dummy
1113: , x_error_Tbl
1114: );
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116:
1117: END format_Table;
1118:
1119: --=====================

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

1152: --
1153: BEGIN
1154:
1155: bis_debug_pub.Add('> write_View');
1156: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
1157: format_Table( p_View_name
1158: , p_View_Create_Text_Table
1159: , p_View_Column_Comment_Table
1160: , l_View_name

Line 1174: THEN RAISE FND_API.G_EXC_ERROR ;

1170: , dummy_char
1171: , dummy_char
1172: , l_applsys_schema
1173: )
1174: THEN RAISE FND_API.G_EXC_ERROR ;
1175: END IF;
1176:
1177:
1178: declare

Line 1214: when FND_API.G_EXC_ERROR then

1210:
1211: bis_debug_pub.Add('< write_View');
1212:
1213: EXCEPTION
1214: when FND_API.G_EXC_ERROR then
1215: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1216: RAISE;
1217: when FND_API.G_EXC_UNEXPECTED_ERROR then
1218: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1211: bis_debug_pub.Add('< write_View');
1212:
1213: EXCEPTION
1214: when FND_API.G_EXC_ERROR then
1215: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1216: RAISE;
1217: when FND_API.G_EXC_UNEXPECTED_ERROR then
1218: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1219: RAISE;

Line 1217: when FND_API.G_EXC_UNEXPECTED_ERROR then

1213: EXCEPTION
1214: when FND_API.G_EXC_ERROR then
1215: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1216: RAISE;
1217: when FND_API.G_EXC_UNEXPECTED_ERROR then
1218: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1219: RAISE;
1220: when others then
1221: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1214: when FND_API.G_EXC_ERROR then
1215: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1216: RAISE;
1217: when FND_API.G_EXC_UNEXPECTED_ERROR then
1218: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1219: RAISE;
1220: when others then
1221: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1222: BIS_VG_UTIL.Add_Error_Message

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

1217: when FND_API.G_EXC_UNEXPECTED_ERROR then
1218: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1219: RAISE;
1220: when others then
1221: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1222: BIS_VG_UTIL.Add_Error_Message
1223: ( p_error_msg_id => SQLCODE
1224: , p_error_description => SQLERRM
1225: , p_error_proc_name => G_PKG_NAME||'.write_View'

Line 1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1229: bis_vg_log.update_failure_log( x_error_tbl
1230: , dummy_char
1231: , x_error_Tbl
1232: );
1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1234:
1235: END write_View;
1236: --
1237: END BIS_VG_COMPILE;