APPS.BIS_VG_UTIL dependencies on FND_API

Line 47: x_return_status := FND_API.G_RET_STS_SUCCESS;

43: RETURN BOOLEAN IS
44: --
45: BEGIN
46: BIS_DEBUG_PUB.Add('> is_char_delimiter');
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48:
49: IF( p_character = ' '
50: -- OR p_character = ' '
51: OR p_character = ','

Line 65: when FND_API.G_EXC_ERROR then

61: RETURN FALSE;
62: END IF;
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: END IF;
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||'.is_char_delimiter'

Line 80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

76: , p_error_proc_name => G_PKG_NAME||'.is_char_delimiter'
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 is_char_delimiter;
83: --
84: --

Line 104: x_return_status := FND_API.G_RET_STS_SUCCESS;

100: l_old_chunk_size NUMBER;
101: --
102: BEGIN
103: bis_debug_pub.Add('> create_Text_Table');
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: l_string_len := LENGTH(p_String);
107: IF(l_string_len <= l_chunk_size) THEN
108: -- string can be stored in one row of table

Line 166: when FND_API.G_EXC_ERROR then

162: bis_debug_pub.Add('< create_Text_Table');
163:
164:
165: EXCEPTION
166: when FND_API.G_EXC_ERROR then
167: x_return_status := FND_API.G_RET_STS_ERROR ;
168: RAISE FND_API.G_EXC_ERROR;
169: when FND_API.G_EXC_UNEXPECTED_ERROR then
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 167: x_return_status := FND_API.G_RET_STS_ERROR ;

163:
164:
165: EXCEPTION
166: when FND_API.G_EXC_ERROR then
167: x_return_status := FND_API.G_RET_STS_ERROR ;
168: RAISE FND_API.G_EXC_ERROR;
169: when FND_API.G_EXC_UNEXPECTED_ERROR then
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 168: RAISE FND_API.G_EXC_ERROR;

164:
165: EXCEPTION
166: when FND_API.G_EXC_ERROR then
167: x_return_status := FND_API.G_RET_STS_ERROR ;
168: RAISE FND_API.G_EXC_ERROR;
169: when FND_API.G_EXC_UNEXPECTED_ERROR then
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: when others then

Line 169: when FND_API.G_EXC_UNEXPECTED_ERROR then

165: EXCEPTION
166: when FND_API.G_EXC_ERROR then
167: x_return_status := FND_API.G_RET_STS_ERROR ;
168: RAISE FND_API.G_EXC_ERROR;
169: when FND_API.G_EXC_UNEXPECTED_ERROR then
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: when others then
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

166: when FND_API.G_EXC_ERROR then
167: x_return_status := FND_API.G_RET_STS_ERROR ;
168: RAISE FND_API.G_EXC_ERROR;
169: when FND_API.G_EXC_UNEXPECTED_ERROR then
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: when others then
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: BIS_VG_UTIL.Add_Error_Message

Line 171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

167: x_return_status := FND_API.G_RET_STS_ERROR ;
168: RAISE FND_API.G_EXC_ERROR;
169: when FND_API.G_EXC_UNEXPECTED_ERROR then
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: when others then
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: BIS_VG_UTIL.Add_Error_Message
175: ( p_error_msg_id => SQLCODE

Line 173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

169: when FND_API.G_EXC_UNEXPECTED_ERROR then
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: when others then
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: BIS_VG_UTIL.Add_Error_Message
175: ( p_error_msg_id => SQLCODE
176: , p_error_description => SQLERRM
177: , p_error_proc_name => G_PKG_NAME||'.create_Text_Table'

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

177: , p_error_proc_name => G_PKG_NAME||'.create_Text_Table'
178: , p_error_table => x_error_tbl
179: , x_error_table => x_error_tbl
180: );
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182:
183: END create_Text_Table;
184: --
185: FUNCTION get_valid_col_name

Line 199: x_return_status := FND_API.G_RET_STS_SUCCESS;

195: l_dummy INTEGER;
196: --
197: BEGIN
198: bis_debug_pub.Add('> get_string_len30');
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: l_String := REPLACE(p_Col_Name, ' ', '_');
202: l_String := REPLACE(l_String, '^', '_');
203: l_String := REPLACE(l_String, '-', '_');

Line 219: when FND_API.G_EXC_ERROR then

215: bis_debug_pub.Add('< get_string_len30');
216:
217:
218: EXCEPTION
219: when FND_API.G_EXC_ERROR then
220: x_return_status := FND_API.G_RET_STS_ERROR ;
221: RAISE FND_API.G_EXC_ERROR;
222: when FND_API.G_EXC_UNEXPECTED_ERROR then
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 220: x_return_status := FND_API.G_RET_STS_ERROR ;

216:
217:
218: EXCEPTION
219: when FND_API.G_EXC_ERROR then
220: x_return_status := FND_API.G_RET_STS_ERROR ;
221: RAISE FND_API.G_EXC_ERROR;
222: when FND_API.G_EXC_UNEXPECTED_ERROR then
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 221: RAISE FND_API.G_EXC_ERROR;

217:
218: EXCEPTION
219: when FND_API.G_EXC_ERROR then
220: x_return_status := FND_API.G_RET_STS_ERROR ;
221: RAISE FND_API.G_EXC_ERROR;
222: when FND_API.G_EXC_UNEXPECTED_ERROR then
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: when others then

Line 222: when FND_API.G_EXC_UNEXPECTED_ERROR then

218: EXCEPTION
219: when FND_API.G_EXC_ERROR then
220: x_return_status := FND_API.G_RET_STS_ERROR ;
221: RAISE FND_API.G_EXC_ERROR;
222: when FND_API.G_EXC_UNEXPECTED_ERROR then
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: when others then
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

219: when FND_API.G_EXC_ERROR then
220: x_return_status := FND_API.G_RET_STS_ERROR ;
221: RAISE FND_API.G_EXC_ERROR;
222: when FND_API.G_EXC_UNEXPECTED_ERROR then
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: when others then
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: BIS_VG_UTIL.Add_Error_Message

Line 224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

220: x_return_status := FND_API.G_RET_STS_ERROR ;
221: RAISE FND_API.G_EXC_ERROR;
222: when FND_API.G_EXC_UNEXPECTED_ERROR then
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: when others then
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: BIS_VG_UTIL.Add_Error_Message
228: ( p_error_msg_id => SQLCODE

Line 226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

222: when FND_API.G_EXC_UNEXPECTED_ERROR then
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: when others then
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: BIS_VG_UTIL.Add_Error_Message
228: ( p_error_msg_id => SQLCODE
229: , p_error_description => SQLERRM
230: , p_error_proc_name => G_PKG_NAME||'.get_valid_col_name'

Line 234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

230: , p_error_proc_name => G_PKG_NAME||'.get_valid_col_name'
231: , p_error_table => x_error_tbl
232: , x_error_table => x_error_tbl
233: );
234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
235:
236: END get_valid_col_name;
237: --
238: --

Line 253: x_return_status := FND_API.G_RET_STS_SUCCESS;

249: l_Suffix_Len NUMBER := 0;
250: --
251: BEGIN
252: BIS_DEBUG_PUB.Add('> get_string_len30');
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: IF(p_Suffix IS NOT NULL) THEN
256: l_Suffix_Len := LENGTH(p_Suffix);
257: END IF;

Line 264: when FND_API.G_EXC_ERROR then

260: BIS_DEBUG_PUB.Add('< get_string_len30');
261:
262:
263: EXCEPTION
264: when FND_API.G_EXC_ERROR then
265: x_return_status := FND_API.G_RET_STS_ERROR ;
266: RAISE FND_API.G_EXC_ERROR;
267: when FND_API.G_EXC_UNEXPECTED_ERROR then
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 265: x_return_status := FND_API.G_RET_STS_ERROR ;

261:
262:
263: EXCEPTION
264: when FND_API.G_EXC_ERROR then
265: x_return_status := FND_API.G_RET_STS_ERROR ;
266: RAISE FND_API.G_EXC_ERROR;
267: when FND_API.G_EXC_UNEXPECTED_ERROR then
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 266: RAISE FND_API.G_EXC_ERROR;

262:
263: EXCEPTION
264: when FND_API.G_EXC_ERROR then
265: x_return_status := FND_API.G_RET_STS_ERROR ;
266: RAISE FND_API.G_EXC_ERROR;
267: when FND_API.G_EXC_UNEXPECTED_ERROR then
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: when others then

Line 267: when FND_API.G_EXC_UNEXPECTED_ERROR then

263: EXCEPTION
264: when FND_API.G_EXC_ERROR then
265: x_return_status := FND_API.G_RET_STS_ERROR ;
266: RAISE FND_API.G_EXC_ERROR;
267: when FND_API.G_EXC_UNEXPECTED_ERROR then
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: when others then
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

264: when FND_API.G_EXC_ERROR then
265: x_return_status := FND_API.G_RET_STS_ERROR ;
266: RAISE FND_API.G_EXC_ERROR;
267: when FND_API.G_EXC_UNEXPECTED_ERROR then
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: when others then
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
272: BIS_VG_UTIL.Add_Error_Message

Line 269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

265: x_return_status := FND_API.G_RET_STS_ERROR ;
266: RAISE FND_API.G_EXC_ERROR;
267: when FND_API.G_EXC_UNEXPECTED_ERROR then
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: when others then
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
272: BIS_VG_UTIL.Add_Error_Message
273: ( p_error_msg_id => SQLCODE

Line 271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

267: when FND_API.G_EXC_UNEXPECTED_ERROR then
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: when others then
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
272: BIS_VG_UTIL.Add_Error_Message
273: ( p_error_msg_id => SQLCODE
274: , p_error_description => SQLERRM
275: , p_error_proc_name => G_PKG_NAME||'.get_string_len30'

Line 279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

275: , p_error_proc_name => G_PKG_NAME||'.get_string_len30'
276: , p_error_table => x_error_tbl
277: , x_error_table => x_error_tbl
278: );
279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
280:
281: END get_string_len30;
282: --
283: --

Line 299: x_return_status := FND_API.G_RET_STS_SUCCESS;

295: end_pointer bis_vg_types.view_character_pointer_type;
296: BEGIN
297:
298: BIS_DEBUG_PUB.Add('> get_string');
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300:
301: print_view_pointer ( p_start_pointer
302: , x_return_status
303: , x_error_Tbl

Line 354: when FND_API.G_EXC_ERROR then

350: BIS_DEBUG_PUB.Add('< get_string');
351: RETURN l_ret;
352:
353: EXCEPTION
354: when FND_API.G_EXC_ERROR then
355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: RAISE FND_API.G_EXC_ERROR;
357: when FND_API.G_EXC_UNEXPECTED_ERROR then
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 355: x_return_status := FND_API.G_RET_STS_ERROR ;

351: RETURN l_ret;
352:
353: EXCEPTION
354: when FND_API.G_EXC_ERROR then
355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: RAISE FND_API.G_EXC_ERROR;
357: when FND_API.G_EXC_UNEXPECTED_ERROR then
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 356: RAISE FND_API.G_EXC_ERROR;

352:
353: EXCEPTION
354: when FND_API.G_EXC_ERROR then
355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: RAISE FND_API.G_EXC_ERROR;
357: when FND_API.G_EXC_UNEXPECTED_ERROR then
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: when others then

Line 357: when FND_API.G_EXC_UNEXPECTED_ERROR then

353: EXCEPTION
354: when FND_API.G_EXC_ERROR then
355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: RAISE FND_API.G_EXC_ERROR;
357: when FND_API.G_EXC_UNEXPECTED_ERROR then
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: when others then
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

354: when FND_API.G_EXC_ERROR then
355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: RAISE FND_API.G_EXC_ERROR;
357: when FND_API.G_EXC_UNEXPECTED_ERROR then
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: when others then
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362: BIS_VG_UTIL.Add_Error_Message

Line 359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: RAISE FND_API.G_EXC_ERROR;
357: when FND_API.G_EXC_UNEXPECTED_ERROR then
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: when others then
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362: BIS_VG_UTIL.Add_Error_Message
363: ( p_error_msg_id => SQLCODE

Line 361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

357: when FND_API.G_EXC_UNEXPECTED_ERROR then
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: when others then
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362: BIS_VG_UTIL.Add_Error_Message
363: ( p_error_msg_id => SQLCODE
364: , p_error_description => SQLERRM
365: , p_error_proc_name => G_PKG_NAME||'.get_string'

Line 369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

365: , p_error_proc_name => G_PKG_NAME||'.get_string'
366: , p_error_table => x_error_tbl
367: , x_error_table => x_error_tbl
368: );
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
370:
371: END get_string;
372:
373: FUNCTION get_char

Line 385: when FND_API.G_EXC_ERROR then

381: BEGIN
382: RETURN Substr(p_view_table(p_pointer.row_num), p_pointer.col_num, 1);
383:
384: EXCEPTION
385: when FND_API.G_EXC_ERROR then
386: x_return_status := FND_API.G_RET_STS_ERROR ;
387: RAISE FND_API.G_EXC_ERROR;
388: when FND_API.G_EXC_UNEXPECTED_ERROR then
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 386: x_return_status := FND_API.G_RET_STS_ERROR ;

382: RETURN Substr(p_view_table(p_pointer.row_num), p_pointer.col_num, 1);
383:
384: EXCEPTION
385: when FND_API.G_EXC_ERROR then
386: x_return_status := FND_API.G_RET_STS_ERROR ;
387: RAISE FND_API.G_EXC_ERROR;
388: when FND_API.G_EXC_UNEXPECTED_ERROR then
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 387: RAISE FND_API.G_EXC_ERROR;

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

Line 388: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

388: when FND_API.G_EXC_UNEXPECTED_ERROR then
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
391: when others then
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: BIS_VG_UTIL.Add_Error_Message
394: ( p_error_msg_id => SQLCODE
395: , p_error_description => SQLERRM
396: , p_error_proc_name => G_PKG_NAME||'.get_char'

Line 400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

396: , p_error_proc_name => G_PKG_NAME||'.get_char'
397: , p_error_table => x_error_tbl
398: , x_error_table => x_error_tbl
399: );
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401:
402: END get_char;
403:
404: FUNCTION increment_pointer

Line 416: x_return_status := FND_API.G_RET_STS_SUCCESS;

412: l_str VARCHAR2(2000);
413: l_pointer bis_vg_types.view_character_pointer_type;
414: begin
415: BIS_DEBUG_PUB.Add('> increment_pointer');
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417: l_str := p_view_table(p_pointer.row_num);
418: IF (p_pointer.col_num = Length(l_str)) THEN
419: -- if at end of table return null
420: IF(p_pointer.row_num < p_view_table.COUNT) then

Line 433: when FND_API.G_EXC_ERROR then

429: RETURN l_pointer;
430:
431:
432: EXCEPTION
433: when FND_API.G_EXC_ERROR then
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: RAISE FND_API.G_EXC_ERROR;
436: when FND_API.G_EXC_UNEXPECTED_ERROR then
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 434: x_return_status := FND_API.G_RET_STS_ERROR ;

430:
431:
432: EXCEPTION
433: when FND_API.G_EXC_ERROR then
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: RAISE FND_API.G_EXC_ERROR;
436: when FND_API.G_EXC_UNEXPECTED_ERROR then
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 435: RAISE FND_API.G_EXC_ERROR;

431:
432: EXCEPTION
433: when FND_API.G_EXC_ERROR then
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: RAISE FND_API.G_EXC_ERROR;
436: when FND_API.G_EXC_UNEXPECTED_ERROR then
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
439: when others then

Line 436: when FND_API.G_EXC_UNEXPECTED_ERROR then

432: EXCEPTION
433: when FND_API.G_EXC_ERROR then
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: RAISE FND_API.G_EXC_ERROR;
436: when FND_API.G_EXC_UNEXPECTED_ERROR then
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
439: when others then
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

433: when FND_API.G_EXC_ERROR then
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: RAISE FND_API.G_EXC_ERROR;
436: when FND_API.G_EXC_UNEXPECTED_ERROR then
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
439: when others then
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
441: BIS_VG_UTIL.Add_Error_Message

Line 438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: RAISE FND_API.G_EXC_ERROR;
436: when FND_API.G_EXC_UNEXPECTED_ERROR then
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
439: when others then
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
441: BIS_VG_UTIL.Add_Error_Message
442: ( p_error_msg_id => SQLCODE

Line 440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

436: when FND_API.G_EXC_UNEXPECTED_ERROR then
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
439: when others then
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
441: BIS_VG_UTIL.Add_Error_Message
442: ( p_error_msg_id => SQLCODE
443: , p_error_description => SQLERRM
444: , p_error_proc_name => G_PKG_NAME||'.increment_pointer'

Line 448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

444: , p_error_proc_name => G_PKG_NAME||'.increment_pointer'
445: , p_error_table => x_error_tbl
446: , x_error_table => x_error_tbl
447: );
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449:
450: END increment_pointer;
451:
452: -- concatenates p_View_Table_A with p_View_Table_B

Line 465: x_return_status := FND_API.G_RET_STS_SUCCESS;

461: --
462: l_count INTEGER;
463: BEGIN
464: BIS_DEBUG_PUB.Add('> concatenate_Tables');
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466: x_View_Table := p_View_Table_A;
467: l_count := x_View_Table.COUNT + 1;
468: for p_ind in 1 .. p_View_Table_B.COUNT loop
469: x_View_Table(l_count) := p_View_Table_B(p_ind);

Line 476: when FND_API.G_EXC_ERROR then

472: BIS_DEBUG_PUB.Add('< concatenate_Tables');
473:
474:
475: EXCEPTION
476: when FND_API.G_EXC_ERROR then
477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: RAISE FND_API.G_EXC_ERROR;
479: when FND_API.G_EXC_UNEXPECTED_ERROR then
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 477: x_return_status := FND_API.G_RET_STS_ERROR ;

473:
474:
475: EXCEPTION
476: when FND_API.G_EXC_ERROR then
477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: RAISE FND_API.G_EXC_ERROR;
479: when FND_API.G_EXC_UNEXPECTED_ERROR then
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 478: RAISE FND_API.G_EXC_ERROR;

474:
475: EXCEPTION
476: when FND_API.G_EXC_ERROR then
477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: RAISE FND_API.G_EXC_ERROR;
479: when FND_API.G_EXC_UNEXPECTED_ERROR then
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
482: when others then

Line 479: when FND_API.G_EXC_UNEXPECTED_ERROR then

475: EXCEPTION
476: when FND_API.G_EXC_ERROR then
477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: RAISE FND_API.G_EXC_ERROR;
479: when FND_API.G_EXC_UNEXPECTED_ERROR then
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
482: when others then
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

476: when FND_API.G_EXC_ERROR then
477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: RAISE FND_API.G_EXC_ERROR;
479: when FND_API.G_EXC_UNEXPECTED_ERROR then
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
482: when others then
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
484: BIS_VG_UTIL.Add_Error_Message

Line 481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: RAISE FND_API.G_EXC_ERROR;
479: when FND_API.G_EXC_UNEXPECTED_ERROR then
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
482: when others then
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
484: BIS_VG_UTIL.Add_Error_Message
485: ( p_error_msg_id => SQLCODE

Line 483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

479: when FND_API.G_EXC_UNEXPECTED_ERROR then
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
482: when others then
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
484: BIS_VG_UTIL.Add_Error_Message
485: ( p_error_msg_id => SQLCODE
486: , p_error_description => SQLERRM
487: , p_error_proc_name => G_PKG_NAME||'.concatenate_Tables'

Line 491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

487: , p_error_proc_name => G_PKG_NAME||'.concatenate_Tables'
488: , p_error_table => x_error_tbl
489: , x_error_table => x_error_tbl
490: );
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492:
493: END concatenate_Tables;
494: --
495: --

Line 508: x_return_status := FND_API.G_RET_STS_SUCCESS;

504: --
505: l_count INTEGER;
506: BEGIN
507: BIS_DEBUG_PUB.Add('> concatenate_Tables Flex_Column_Comment');
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: x_View_Table := p_View_Table_A;
510: l_count := x_View_Table.COUNT + 1;
511: for p_ind in 1 .. p_View_Table_B.COUNT loop
512: x_View_Table(l_count) := p_View_Table_B(p_ind);

Line 519: when FND_API.G_EXC_ERROR then

515: BIS_DEBUG_PUB.Add('< concatenate_Tables Flex_Column_Comment');
516:
517:
518: EXCEPTION
519: when FND_API.G_EXC_ERROR then
520: x_return_status := FND_API.G_RET_STS_ERROR ;
521: RAISE FND_API.G_EXC_ERROR;
522: when FND_API.G_EXC_UNEXPECTED_ERROR then
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 520: x_return_status := FND_API.G_RET_STS_ERROR ;

516:
517:
518: EXCEPTION
519: when FND_API.G_EXC_ERROR then
520: x_return_status := FND_API.G_RET_STS_ERROR ;
521: RAISE FND_API.G_EXC_ERROR;
522: when FND_API.G_EXC_UNEXPECTED_ERROR then
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 521: RAISE FND_API.G_EXC_ERROR;

517:
518: EXCEPTION
519: when FND_API.G_EXC_ERROR then
520: x_return_status := FND_API.G_RET_STS_ERROR ;
521: RAISE FND_API.G_EXC_ERROR;
522: when FND_API.G_EXC_UNEXPECTED_ERROR then
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: when others then

Line 522: when FND_API.G_EXC_UNEXPECTED_ERROR then

518: EXCEPTION
519: when FND_API.G_EXC_ERROR then
520: x_return_status := FND_API.G_RET_STS_ERROR ;
521: RAISE FND_API.G_EXC_ERROR;
522: when FND_API.G_EXC_UNEXPECTED_ERROR then
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: when others then
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

519: when FND_API.G_EXC_ERROR then
520: x_return_status := FND_API.G_RET_STS_ERROR ;
521: RAISE FND_API.G_EXC_ERROR;
522: when FND_API.G_EXC_UNEXPECTED_ERROR then
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: when others then
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
527: BIS_VG_UTIL.Add_Error_Message

Line 524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

520: x_return_status := FND_API.G_RET_STS_ERROR ;
521: RAISE FND_API.G_EXC_ERROR;
522: when FND_API.G_EXC_UNEXPECTED_ERROR then
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: when others then
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
527: BIS_VG_UTIL.Add_Error_Message
528: ( p_error_msg_id => SQLCODE

Line 526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

522: when FND_API.G_EXC_UNEXPECTED_ERROR then
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: when others then
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
527: BIS_VG_UTIL.Add_Error_Message
528: ( p_error_msg_id => SQLCODE
529: , p_error_description => SQLERRM
530: , p_error_proc_name => G_PKG_NAME||'.concatenate_Tables'

Line 534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

530: , p_error_proc_name => G_PKG_NAME||'.concatenate_Tables'
531: , p_error_table => x_error_tbl
532: , x_error_table => x_error_tbl
533: );
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535:
536: END concatenate_Tables;
537: --
538: --

Line 549: x_return_status := FND_API.G_RET_STS_SUCCESS;

545: RETURN BOOLEAN IS
546: --
547: BEGIN
548: BIS_DEBUG_PUB.Add('> equal_pointers');
549: x_return_status := FND_API.G_RET_STS_SUCCESS;
550: -- both are null; return true
551: IF (null_pointer(p_start_pointer, x_return_status, x_error_Tbl) = TRUE)
552: AND (null_pointer(p_end_pointer, x_return_status, x_error_Tbl) = TRUE) THEN
553: RETURN TRUE;

Line 571: when FND_API.G_EXC_ERROR then

567: BIS_DEBUG_PUB.Add('< equal_pointers');
568:
569:
570: EXCEPTION
571: when FND_API.G_EXC_ERROR then
572: x_return_status := FND_API.G_RET_STS_ERROR ;
573: RAISE FND_API.G_EXC_ERROR;
574: when FND_API.G_EXC_UNEXPECTED_ERROR then
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 572: x_return_status := FND_API.G_RET_STS_ERROR ;

568:
569:
570: EXCEPTION
571: when FND_API.G_EXC_ERROR then
572: x_return_status := FND_API.G_RET_STS_ERROR ;
573: RAISE FND_API.G_EXC_ERROR;
574: when FND_API.G_EXC_UNEXPECTED_ERROR then
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 573: RAISE FND_API.G_EXC_ERROR;

569:
570: EXCEPTION
571: when FND_API.G_EXC_ERROR then
572: x_return_status := FND_API.G_RET_STS_ERROR ;
573: RAISE FND_API.G_EXC_ERROR;
574: when FND_API.G_EXC_UNEXPECTED_ERROR then
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: when others then

Line 574: when FND_API.G_EXC_UNEXPECTED_ERROR then

570: EXCEPTION
571: when FND_API.G_EXC_ERROR then
572: x_return_status := FND_API.G_RET_STS_ERROR ;
573: RAISE FND_API.G_EXC_ERROR;
574: when FND_API.G_EXC_UNEXPECTED_ERROR then
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: when others then
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

571: when FND_API.G_EXC_ERROR then
572: x_return_status := FND_API.G_RET_STS_ERROR ;
573: RAISE FND_API.G_EXC_ERROR;
574: when FND_API.G_EXC_UNEXPECTED_ERROR then
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: when others then
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
579: BIS_VG_UTIL.Add_Error_Message

Line 576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

572: x_return_status := FND_API.G_RET_STS_ERROR ;
573: RAISE FND_API.G_EXC_ERROR;
574: when FND_API.G_EXC_UNEXPECTED_ERROR then
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: when others then
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
579: BIS_VG_UTIL.Add_Error_Message
580: ( p_error_msg_id => SQLCODE

Line 578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

574: when FND_API.G_EXC_UNEXPECTED_ERROR then
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: when others then
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
579: BIS_VG_UTIL.Add_Error_Message
580: ( p_error_msg_id => SQLCODE
581: , p_error_description => SQLERRM
582: , p_error_proc_name => G_PKG_NAME||'.equal_pointers'

Line 586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

582: , p_error_proc_name => G_PKG_NAME||'.equal_pointers'
583: , p_error_table => x_error_tbl
584: , x_error_table => x_error_tbl
585: );
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587:
588: END equal_pointers;
589: --
590: --

Line 606: x_return_status := FND_API.G_RET_STS_SUCCESS;

602: l_end NUMBER;
603: j NUMBER;
604: BEGIN
605: BIS_DEBUG_PUB.Add('> copy part of table');
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607:
608: print_view_pointer ( p_start_pointer
609: , x_return_status
610: , x_error_Tbl

Line 687: when FND_API.G_EXC_ERROR then

683: BIS_DEBUG_PUB.Add('< copy part of table');
684:
685:
686: EXCEPTION
687: when FND_API.G_EXC_ERROR then
688: x_return_status := FND_API.G_RET_STS_ERROR ;
689: RAISE FND_API.G_EXC_ERROR;
690: when FND_API.G_EXC_UNEXPECTED_ERROR then
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 688: x_return_status := FND_API.G_RET_STS_ERROR ;

684:
685:
686: EXCEPTION
687: when FND_API.G_EXC_ERROR then
688: x_return_status := FND_API.G_RET_STS_ERROR ;
689: RAISE FND_API.G_EXC_ERROR;
690: when FND_API.G_EXC_UNEXPECTED_ERROR then
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 689: RAISE FND_API.G_EXC_ERROR;

685:
686: EXCEPTION
687: when FND_API.G_EXC_ERROR then
688: x_return_status := FND_API.G_RET_STS_ERROR ;
689: RAISE FND_API.G_EXC_ERROR;
690: when FND_API.G_EXC_UNEXPECTED_ERROR then
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: when others then

Line 690: when FND_API.G_EXC_UNEXPECTED_ERROR then

686: EXCEPTION
687: when FND_API.G_EXC_ERROR then
688: x_return_status := FND_API.G_RET_STS_ERROR ;
689: RAISE FND_API.G_EXC_ERROR;
690: when FND_API.G_EXC_UNEXPECTED_ERROR then
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: when others then
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

687: when FND_API.G_EXC_ERROR then
688: x_return_status := FND_API.G_RET_STS_ERROR ;
689: RAISE FND_API.G_EXC_ERROR;
690: when FND_API.G_EXC_UNEXPECTED_ERROR then
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: when others then
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
695: BIS_VG_UTIL.Add_Error_Message

Line 692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

688: x_return_status := FND_API.G_RET_STS_ERROR ;
689: RAISE FND_API.G_EXC_ERROR;
690: when FND_API.G_EXC_UNEXPECTED_ERROR then
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: when others then
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
695: BIS_VG_UTIL.Add_Error_Message
696: ( p_error_msg_id => SQLCODE

Line 694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

690: when FND_API.G_EXC_UNEXPECTED_ERROR then
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: when others then
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
695: BIS_VG_UTIL.Add_Error_Message
696: ( p_error_msg_id => SQLCODE
697: , p_error_description => SQLERRM
698: , p_error_proc_name => G_PKG_NAME||'.copy_part_of_table'

Line 702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

698: , p_error_proc_name => G_PKG_NAME||'.copy_part_of_table'
699: , p_error_table => x_error_tbl
700: , x_error_table => x_error_tbl
701: );
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703:
704: END copy_part_of_table;
705:
706: /* ============================================================================

Line 727: x_return_status := FND_API.G_RET_STS_SUCCESS;

723: i NUMBER;
724: --
725: BEGIN
726: BIS_DEBUG_PUB.Add('> print_View_Text');
727: x_return_status := FND_API.G_RET_STS_SUCCESS;
728: bis_debug_pub.ADD('# of rows in table = '||p_view_text_table.COUNT);
729: for i in 1 .. p_View_Text_Table.COUNT loop
730: BIS_DEBUG_PUB.Add(p_View_Text_Table(i));
731: end loop;

Line 736: when FND_API.G_EXC_ERROR then

732: BIS_DEBUG_PUB.Add('< print_View_Text');
733:
734:
735: EXCEPTION
736: when FND_API.G_EXC_ERROR then
737: x_return_status := FND_API.G_RET_STS_ERROR ;
738: RAISE FND_API.G_EXC_ERROR;
739: when FND_API.G_EXC_UNEXPECTED_ERROR then
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 737: x_return_status := FND_API.G_RET_STS_ERROR ;

733:
734:
735: EXCEPTION
736: when FND_API.G_EXC_ERROR then
737: x_return_status := FND_API.G_RET_STS_ERROR ;
738: RAISE FND_API.G_EXC_ERROR;
739: when FND_API.G_EXC_UNEXPECTED_ERROR then
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 738: RAISE FND_API.G_EXC_ERROR;

734:
735: EXCEPTION
736: when FND_API.G_EXC_ERROR then
737: x_return_status := FND_API.G_RET_STS_ERROR ;
738: RAISE FND_API.G_EXC_ERROR;
739: when FND_API.G_EXC_UNEXPECTED_ERROR then
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: when others then

Line 739: when FND_API.G_EXC_UNEXPECTED_ERROR then

735: EXCEPTION
736: when FND_API.G_EXC_ERROR then
737: x_return_status := FND_API.G_RET_STS_ERROR ;
738: RAISE FND_API.G_EXC_ERROR;
739: when FND_API.G_EXC_UNEXPECTED_ERROR then
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: when others then
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

736: when FND_API.G_EXC_ERROR then
737: x_return_status := FND_API.G_RET_STS_ERROR ;
738: RAISE FND_API.G_EXC_ERROR;
739: when FND_API.G_EXC_UNEXPECTED_ERROR then
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: when others then
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
744: BIS_VG_UTIL.Add_Error_Message

Line 741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

737: x_return_status := FND_API.G_RET_STS_ERROR ;
738: RAISE FND_API.G_EXC_ERROR;
739: when FND_API.G_EXC_UNEXPECTED_ERROR then
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: when others then
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
744: BIS_VG_UTIL.Add_Error_Message
745: ( p_error_msg_id => SQLCODE

Line 743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

739: when FND_API.G_EXC_UNEXPECTED_ERROR then
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: when others then
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
744: BIS_VG_UTIL.Add_Error_Message
745: ( p_error_msg_id => SQLCODE
746: , p_error_description => SQLERRM
747: , p_error_proc_name => G_PKG_NAME||'.print_View_Text'

Line 751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

747: , p_error_proc_name => G_PKG_NAME||'.print_View_Text'
748: , p_error_table => x_error_tbl
749: , x_error_table => x_error_tbl
750: );
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752:
753: END print_View_Text; --}
754: --
755: /* ============================================================================

Line 773: x_return_status := FND_API.G_RET_STS_SUCCESS;

769: )
770: IS
771: BEGIN
772: BIS_DEBUG_PUB.Add('> print_View_pointer');
773: x_return_status := FND_API.G_RET_STS_SUCCESS;
774: BIS_DEBUG_PUB.Add('pointer row num = '||p_pointer.row_num ||
775: ' pointer col num = '||p_pointer.col_num);
776: BIS_DEBUG_PUB.Add('< print_View_pointer');
777:

Line 780: when FND_API.G_EXC_ERROR then

776: BIS_DEBUG_PUB.Add('< print_View_pointer');
777:
778:
779: EXCEPTION
780: when FND_API.G_EXC_ERROR then
781: x_return_status := FND_API.G_RET_STS_ERROR ;
782: RAISE FND_API.G_EXC_ERROR;
783: when FND_API.G_EXC_UNEXPECTED_ERROR then
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 781: x_return_status := FND_API.G_RET_STS_ERROR ;

777:
778:
779: EXCEPTION
780: when FND_API.G_EXC_ERROR then
781: x_return_status := FND_API.G_RET_STS_ERROR ;
782: RAISE FND_API.G_EXC_ERROR;
783: when FND_API.G_EXC_UNEXPECTED_ERROR then
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 782: RAISE FND_API.G_EXC_ERROR;

778:
779: EXCEPTION
780: when FND_API.G_EXC_ERROR then
781: x_return_status := FND_API.G_RET_STS_ERROR ;
782: RAISE FND_API.G_EXC_ERROR;
783: when FND_API.G_EXC_UNEXPECTED_ERROR then
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: when others then

Line 783: when FND_API.G_EXC_UNEXPECTED_ERROR then

779: EXCEPTION
780: when FND_API.G_EXC_ERROR then
781: x_return_status := FND_API.G_RET_STS_ERROR ;
782: RAISE FND_API.G_EXC_ERROR;
783: when FND_API.G_EXC_UNEXPECTED_ERROR then
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: when others then
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

780: when FND_API.G_EXC_ERROR then
781: x_return_status := FND_API.G_RET_STS_ERROR ;
782: RAISE FND_API.G_EXC_ERROR;
783: when FND_API.G_EXC_UNEXPECTED_ERROR then
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: when others then
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
788: BIS_VG_UTIL.Add_Error_Message

Line 785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

781: x_return_status := FND_API.G_RET_STS_ERROR ;
782: RAISE FND_API.G_EXC_ERROR;
783: when FND_API.G_EXC_UNEXPECTED_ERROR then
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: when others then
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
788: BIS_VG_UTIL.Add_Error_Message
789: ( p_error_msg_id => SQLCODE

Line 787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

783: when FND_API.G_EXC_UNEXPECTED_ERROR then
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: when others then
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
788: BIS_VG_UTIL.Add_Error_Message
789: ( p_error_msg_id => SQLCODE
790: , p_error_description => SQLERRM
791: , p_error_proc_name => G_PKG_NAME||'.print_View_pointer'

Line 795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

791: , p_error_proc_name => G_PKG_NAME||'.print_View_pointer'
792: , p_error_table => x_error_tbl
793: , x_error_table => x_error_tbl
794: );
795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
796:
797: END print_View_pointer; --}
798: --
799:

Line 823: x_return_status := FND_API.G_RET_STS_SUCCESS;

819: IS
820: l_pointer bis_vg_types.view_character_pointer_type;
821: BEGIN
822: BIS_DEBUG_PUB.Add('> position_before_characters');
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824: l_pointer.row_num := p_view_text_table.COUNT;
825: l_pointer.col_num := Length(p_view_text_table(l_pointer.row_num));
826: BIS_DEBUG_PUB.Add('< position_before_characters');
827: RETURN (position_before_characters(p_view_text_table

Line 836: when FND_API.G_EXC_ERROR then

832: )
833: );
834:
835: EXCEPTION
836: when FND_API.G_EXC_ERROR then
837: x_return_status := FND_API.G_RET_STS_ERROR ;
838: RAISE FND_API.G_EXC_ERROR;
839: when FND_API.G_EXC_UNEXPECTED_ERROR then
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 837: x_return_status := FND_API.G_RET_STS_ERROR ;

833: );
834:
835: EXCEPTION
836: when FND_API.G_EXC_ERROR then
837: x_return_status := FND_API.G_RET_STS_ERROR ;
838: RAISE FND_API.G_EXC_ERROR;
839: when FND_API.G_EXC_UNEXPECTED_ERROR then
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 838: RAISE FND_API.G_EXC_ERROR;

834:
835: EXCEPTION
836: when FND_API.G_EXC_ERROR then
837: x_return_status := FND_API.G_RET_STS_ERROR ;
838: RAISE FND_API.G_EXC_ERROR;
839: when FND_API.G_EXC_UNEXPECTED_ERROR then
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: when others then

Line 839: when FND_API.G_EXC_UNEXPECTED_ERROR then

835: EXCEPTION
836: when FND_API.G_EXC_ERROR then
837: x_return_status := FND_API.G_RET_STS_ERROR ;
838: RAISE FND_API.G_EXC_ERROR;
839: when FND_API.G_EXC_UNEXPECTED_ERROR then
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: when others then
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

836: when FND_API.G_EXC_ERROR then
837: x_return_status := FND_API.G_RET_STS_ERROR ;
838: RAISE FND_API.G_EXC_ERROR;
839: when FND_API.G_EXC_UNEXPECTED_ERROR then
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: when others then
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
844: BIS_VG_UTIL.Add_Error_Message

Line 841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

837: x_return_status := FND_API.G_RET_STS_ERROR ;
838: RAISE FND_API.G_EXC_ERROR;
839: when FND_API.G_EXC_UNEXPECTED_ERROR then
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: when others then
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
844: BIS_VG_UTIL.Add_Error_Message
845: ( p_error_msg_id => SQLCODE

Line 843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

839: when FND_API.G_EXC_UNEXPECTED_ERROR then
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: when others then
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
844: BIS_VG_UTIL.Add_Error_Message
845: ( p_error_msg_id => SQLCODE
846: , p_error_description => SQLERRM
847: , p_error_proc_name => G_PKG_NAME||'.position_before_characters'

Line 851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

847: , p_error_proc_name => G_PKG_NAME||'.position_before_characters'
848: , p_error_table => x_error_tbl
849: , x_error_table => x_error_tbl
850: );
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852:
853: END position_before_characters;
854:
855: /* ============================================================================

Line 882: x_return_status := FND_API.G_RET_STS_SUCCESS;

878: l_char VARCHAR2(1);
879: l_pos NUMBER;
880: BEGIN
881: BIS_DEBUG_PUB.Add('> position_before_characters');
882: x_return_status := FND_API.G_RET_STS_SUCCESS;
883:
884: IF (p_pointer.row_num IS NULL) THEN
885: return p_pointer;
886: END IF;

Line 932: when FND_API.G_EXC_ERROR then

928: BIS_DEBUG_PUB.Add('< position_before_characters');
929: RETURN l_pointer;
930:
931: EXCEPTION
932: when FND_API.G_EXC_ERROR then
933: x_return_status := FND_API.G_RET_STS_ERROR ;
934: RAISE FND_API.G_EXC_ERROR;
935: when FND_API.G_EXC_UNEXPECTED_ERROR then
936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 933: x_return_status := FND_API.G_RET_STS_ERROR ;

929: RETURN l_pointer;
930:
931: EXCEPTION
932: when FND_API.G_EXC_ERROR then
933: x_return_status := FND_API.G_RET_STS_ERROR ;
934: RAISE FND_API.G_EXC_ERROR;
935: when FND_API.G_EXC_UNEXPECTED_ERROR then
936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 934: RAISE FND_API.G_EXC_ERROR;

930:
931: EXCEPTION
932: when FND_API.G_EXC_ERROR then
933: x_return_status := FND_API.G_RET_STS_ERROR ;
934: RAISE FND_API.G_EXC_ERROR;
935: when FND_API.G_EXC_UNEXPECTED_ERROR then
936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
938: when others then

Line 935: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

932: when FND_API.G_EXC_ERROR then
933: x_return_status := FND_API.G_RET_STS_ERROR ;
934: RAISE FND_API.G_EXC_ERROR;
935: when FND_API.G_EXC_UNEXPECTED_ERROR then
936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
938: when others then
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: BIS_VG_UTIL.Add_Error_Message

Line 937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

933: x_return_status := FND_API.G_RET_STS_ERROR ;
934: RAISE FND_API.G_EXC_ERROR;
935: when FND_API.G_EXC_UNEXPECTED_ERROR then
936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
938: when others then
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: BIS_VG_UTIL.Add_Error_Message
941: ( p_error_msg_id => SQLCODE

Line 939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

935: when FND_API.G_EXC_UNEXPECTED_ERROR then
936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
938: when others then
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: BIS_VG_UTIL.Add_Error_Message
941: ( p_error_msg_id => SQLCODE
942: , p_error_description => SQLERRM
943: , p_error_proc_name => G_PKG_NAME||'.position_before_characters'

Line 947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

943: , p_error_proc_name => G_PKG_NAME||'.position_before_characters'
944: , p_error_table => x_error_tbl
945: , x_error_table => x_error_tbl
946: );
947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
948:
949:
950: END position_before_characters;
951:

Line 965: x_return_status := FND_API.G_RET_STS_SUCCESS;

961: l_str VARCHAR2(2000);
962: l_pointer bis_vg_types.view_character_pointer_type;
963: BEGIN
964: BIS_DEBUG_PUB.Add('> decrement_pointer');
965: x_return_status := FND_API.G_RET_STS_SUCCESS;
966:
967: IF (p_pointer.row_num IS NULL) THEN
968: return p_pointer;
969: END IF;

Line 988: when FND_API.G_EXC_ERROR then

984: BIS_DEBUG_PUB.Add('< decrement_pointer');
985: RETURN l_pointer;
986:
987: EXCEPTION
988: when FND_API.G_EXC_ERROR then
989: x_return_status := FND_API.G_RET_STS_ERROR ;
990: RAISE FND_API.G_EXC_ERROR;
991: when FND_API.G_EXC_UNEXPECTED_ERROR then
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 989: x_return_status := FND_API.G_RET_STS_ERROR ;

985: RETURN l_pointer;
986:
987: EXCEPTION
988: when FND_API.G_EXC_ERROR then
989: x_return_status := FND_API.G_RET_STS_ERROR ;
990: RAISE FND_API.G_EXC_ERROR;
991: when FND_API.G_EXC_UNEXPECTED_ERROR then
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 990: RAISE FND_API.G_EXC_ERROR;

986:
987: EXCEPTION
988: when FND_API.G_EXC_ERROR then
989: x_return_status := FND_API.G_RET_STS_ERROR ;
990: RAISE FND_API.G_EXC_ERROR;
991: when FND_API.G_EXC_UNEXPECTED_ERROR then
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: when others then

Line 991: when FND_API.G_EXC_UNEXPECTED_ERROR then

987: EXCEPTION
988: when FND_API.G_EXC_ERROR then
989: x_return_status := FND_API.G_RET_STS_ERROR ;
990: RAISE FND_API.G_EXC_ERROR;
991: when FND_API.G_EXC_UNEXPECTED_ERROR then
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: when others then
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

988: when FND_API.G_EXC_ERROR then
989: x_return_status := FND_API.G_RET_STS_ERROR ;
990: RAISE FND_API.G_EXC_ERROR;
991: when FND_API.G_EXC_UNEXPECTED_ERROR then
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: when others then
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
996: BIS_VG_UTIL.Add_Error_Message

Line 993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

989: x_return_status := FND_API.G_RET_STS_ERROR ;
990: RAISE FND_API.G_EXC_ERROR;
991: when FND_API.G_EXC_UNEXPECTED_ERROR then
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: when others then
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
996: BIS_VG_UTIL.Add_Error_Message
997: ( p_error_msg_id => SQLCODE

Line 995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

991: when FND_API.G_EXC_UNEXPECTED_ERROR then
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: when others then
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
996: BIS_VG_UTIL.Add_Error_Message
997: ( p_error_msg_id => SQLCODE
998: , p_error_description => SQLERRM
999: , p_error_proc_name => G_PKG_NAME||'.decrement_pointer'

Line 1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

999: , p_error_proc_name => G_PKG_NAME||'.decrement_pointer'
1000: , p_error_table => x_error_tbl
1001: , x_error_table => x_error_tbl
1002: );
1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1004:
1005: END decrement_pointer;
1006:
1007: -- return TRUE if pointer is a null

Line 1025: when FND_API.G_EXC_ERROR then

1021:
1022: RETURN FALSE;
1023:
1024: EXCEPTION
1025: when FND_API.G_EXC_ERROR then
1026: x_return_status := FND_API.G_RET_STS_ERROR ;
1027: RAISE FND_API.G_EXC_ERROR;
1028: when FND_API.G_EXC_UNEXPECTED_ERROR then
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1026: x_return_status := FND_API.G_RET_STS_ERROR ;

1022: RETURN FALSE;
1023:
1024: EXCEPTION
1025: when FND_API.G_EXC_ERROR then
1026: x_return_status := FND_API.G_RET_STS_ERROR ;
1027: RAISE FND_API.G_EXC_ERROR;
1028: when FND_API.G_EXC_UNEXPECTED_ERROR then
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1027: RAISE FND_API.G_EXC_ERROR;

1023:
1024: EXCEPTION
1025: when FND_API.G_EXC_ERROR then
1026: x_return_status := FND_API.G_RET_STS_ERROR ;
1027: RAISE FND_API.G_EXC_ERROR;
1028: when FND_API.G_EXC_UNEXPECTED_ERROR then
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: when others then

Line 1028: when FND_API.G_EXC_UNEXPECTED_ERROR then

1024: EXCEPTION
1025: when FND_API.G_EXC_ERROR then
1026: x_return_status := FND_API.G_RET_STS_ERROR ;
1027: RAISE FND_API.G_EXC_ERROR;
1028: when FND_API.G_EXC_UNEXPECTED_ERROR then
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: when others then
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1025: when FND_API.G_EXC_ERROR then
1026: x_return_status := FND_API.G_RET_STS_ERROR ;
1027: RAISE FND_API.G_EXC_ERROR;
1028: when FND_API.G_EXC_UNEXPECTED_ERROR then
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: when others then
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1033: BIS_VG_UTIL.Add_Error_Message

Line 1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1026: x_return_status := FND_API.G_RET_STS_ERROR ;
1027: RAISE FND_API.G_EXC_ERROR;
1028: when FND_API.G_EXC_UNEXPECTED_ERROR then
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: when others then
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1033: BIS_VG_UTIL.Add_Error_Message
1034: ( p_error_msg_id => SQLCODE

Line 1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1028: when FND_API.G_EXC_UNEXPECTED_ERROR then
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: when others then
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1033: BIS_VG_UTIL.Add_Error_Message
1034: ( p_error_msg_id => SQLCODE
1035: , p_error_description => SQLERRM
1036: , p_error_proc_name => G_PKG_NAME||'.null_pointer'

Line 1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1036: , p_error_proc_name => G_PKG_NAME||'.null_pointer'
1037: , p_error_table => x_error_tbl
1038: , x_error_table => x_error_tbl
1039: );
1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1041:
1042: END null_pointer;
1043:
1044: -- returns the row pointed to by the pointer

Line 1066: when FND_API.G_EXC_ERROR then

1062:
1063: RETURN p_view_table(p_pointer.row_num);
1064:
1065: EXCEPTION
1066: when FND_API.G_EXC_ERROR then
1067: x_return_status := FND_API.G_RET_STS_ERROR ;
1068: RAISE FND_API.G_EXC_ERROR;
1069: when FND_API.G_EXC_UNEXPECTED_ERROR then
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1067: x_return_status := FND_API.G_RET_STS_ERROR ;

1063: RETURN p_view_table(p_pointer.row_num);
1064:
1065: EXCEPTION
1066: when FND_API.G_EXC_ERROR then
1067: x_return_status := FND_API.G_RET_STS_ERROR ;
1068: RAISE FND_API.G_EXC_ERROR;
1069: when FND_API.G_EXC_UNEXPECTED_ERROR then
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1068: RAISE FND_API.G_EXC_ERROR;

1064:
1065: EXCEPTION
1066: when FND_API.G_EXC_ERROR then
1067: x_return_status := FND_API.G_RET_STS_ERROR ;
1068: RAISE FND_API.G_EXC_ERROR;
1069: when FND_API.G_EXC_UNEXPECTED_ERROR then
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: when others then

Line 1069: when FND_API.G_EXC_UNEXPECTED_ERROR then

1065: EXCEPTION
1066: when FND_API.G_EXC_ERROR then
1067: x_return_status := FND_API.G_RET_STS_ERROR ;
1068: RAISE FND_API.G_EXC_ERROR;
1069: when FND_API.G_EXC_UNEXPECTED_ERROR then
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: when others then
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1066: when FND_API.G_EXC_ERROR then
1067: x_return_status := FND_API.G_RET_STS_ERROR ;
1068: RAISE FND_API.G_EXC_ERROR;
1069: when FND_API.G_EXC_UNEXPECTED_ERROR then
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: when others then
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1074: BIS_VG_UTIL.Add_Error_Message

Line 1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1067: x_return_status := FND_API.G_RET_STS_ERROR ;
1068: RAISE FND_API.G_EXC_ERROR;
1069: when FND_API.G_EXC_UNEXPECTED_ERROR then
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: when others then
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1074: BIS_VG_UTIL.Add_Error_Message
1075: ( p_error_msg_id => SQLCODE

Line 1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1069: when FND_API.G_EXC_UNEXPECTED_ERROR then
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: when others then
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1074: BIS_VG_UTIL.Add_Error_Message
1075: ( p_error_msg_id => SQLCODE
1076: , p_error_description => SQLERRM
1077: , p_error_proc_name => G_PKG_NAME||'.get_row'

Line 1081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1077: , p_error_proc_name => G_PKG_NAME||'.get_row'
1078: , p_error_table => x_error_tbl
1079: , x_error_table => x_error_tbl
1080: );
1081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1082:
1083: END get_row;
1084:
1085: -- increments the pointer to next row

Line 1097: x_return_status := FND_API.G_RET_STS_SUCCESS;

1093: IS
1094: l_pointer bis_vg_types.view_character_pointer_type;
1095: BEGIN
1096: BIS_DEBUG_PUB.Add('> increment_pointer_by_row ');
1097: x_return_status := FND_API.G_RET_STS_SUCCESS;
1098: IF ( null_pointer ( p_pointer
1099: , x_return_status
1100: , x_error_Tbl
1101: ) = TRUE

Line 1114: when FND_API.G_EXC_ERROR then

1110: BIS_DEBUG_PUB.Add('< increment_pointer_by_row ');
1111: RETURN l_pointer;
1112:
1113: EXCEPTION
1114: when FND_API.G_EXC_ERROR then
1115: x_return_status := FND_API.G_RET_STS_ERROR ;
1116: RAISE FND_API.G_EXC_ERROR;
1117: when FND_API.G_EXC_UNEXPECTED_ERROR then
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1115: x_return_status := FND_API.G_RET_STS_ERROR ;

1111: RETURN l_pointer;
1112:
1113: EXCEPTION
1114: when FND_API.G_EXC_ERROR then
1115: x_return_status := FND_API.G_RET_STS_ERROR ;
1116: RAISE FND_API.G_EXC_ERROR;
1117: when FND_API.G_EXC_UNEXPECTED_ERROR then
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1116: RAISE FND_API.G_EXC_ERROR;

1112:
1113: EXCEPTION
1114: when FND_API.G_EXC_ERROR then
1115: x_return_status := FND_API.G_RET_STS_ERROR ;
1116: RAISE FND_API.G_EXC_ERROR;
1117: when FND_API.G_EXC_UNEXPECTED_ERROR then
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: when others then

Line 1117: when FND_API.G_EXC_UNEXPECTED_ERROR then

1113: EXCEPTION
1114: when FND_API.G_EXC_ERROR then
1115: x_return_status := FND_API.G_RET_STS_ERROR ;
1116: RAISE FND_API.G_EXC_ERROR;
1117: when FND_API.G_EXC_UNEXPECTED_ERROR then
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: when others then
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1114: when FND_API.G_EXC_ERROR then
1115: x_return_status := FND_API.G_RET_STS_ERROR ;
1116: RAISE FND_API.G_EXC_ERROR;
1117: when FND_API.G_EXC_UNEXPECTED_ERROR then
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: when others then
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1122: BIS_VG_UTIL.Add_Error_Message

Line 1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1115: x_return_status := FND_API.G_RET_STS_ERROR ;
1116: RAISE FND_API.G_EXC_ERROR;
1117: when FND_API.G_EXC_UNEXPECTED_ERROR then
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: when others then
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1122: BIS_VG_UTIL.Add_Error_Message
1123: ( p_error_msg_id => SQLCODE

Line 1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1117: when FND_API.G_EXC_UNEXPECTED_ERROR then
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: when others then
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1122: BIS_VG_UTIL.Add_Error_Message
1123: ( p_error_msg_id => SQLCODE
1124: , p_error_description => SQLERRM
1125: , p_error_proc_name => G_PKG_NAME||'.increment_pointer_by_row'

Line 1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1125: , p_error_proc_name => G_PKG_NAME||'.increment_pointer_by_row'
1126: , p_error_table => x_error_tbl
1127: , x_error_table => x_error_tbl
1128: );
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130:
1131: END increment_pointer_by_row;
1132:
1133: -- this function returns the generated view name for the original view name

Line 1148: x_return_status := FND_API.G_RET_STS_SUCCESS;

1144: --
1145: BEGIN
1146:
1147: bis_debug_pub.Add('> get_generated_view_name');
1148: x_return_status := FND_API.G_RET_STS_SUCCESS;
1149: l_pos := INSTR(p_View_Name, 'V_');
1150: l_View_Name := SUBSTR(p_View_Name, 1, l_pos - 1)
1151: || 'G'
1152: || SUBSTR( p_View_Name

Line 1160: when FND_API.G_EXC_ERROR then

1156: bis_debug_pub.Add('< get_generated_view_name');
1157: RETURN l_view_name;
1158:
1159: EXCEPTION
1160: when FND_API.G_EXC_ERROR then
1161: x_return_status := FND_API.G_RET_STS_ERROR ;
1162: RAISE FND_API.G_EXC_ERROR;
1163: when FND_API.G_EXC_UNEXPECTED_ERROR then
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1161: x_return_status := FND_API.G_RET_STS_ERROR ;

1157: RETURN l_view_name;
1158:
1159: EXCEPTION
1160: when FND_API.G_EXC_ERROR then
1161: x_return_status := FND_API.G_RET_STS_ERROR ;
1162: RAISE FND_API.G_EXC_ERROR;
1163: when FND_API.G_EXC_UNEXPECTED_ERROR then
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1162: RAISE FND_API.G_EXC_ERROR;

1158:
1159: EXCEPTION
1160: when FND_API.G_EXC_ERROR then
1161: x_return_status := FND_API.G_RET_STS_ERROR ;
1162: RAISE FND_API.G_EXC_ERROR;
1163: when FND_API.G_EXC_UNEXPECTED_ERROR then
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: when others then

Line 1163: when FND_API.G_EXC_UNEXPECTED_ERROR then

1159: EXCEPTION
1160: when FND_API.G_EXC_ERROR then
1161: x_return_status := FND_API.G_RET_STS_ERROR ;
1162: RAISE FND_API.G_EXC_ERROR;
1163: when FND_API.G_EXC_UNEXPECTED_ERROR then
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: when others then
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1160: when FND_API.G_EXC_ERROR then
1161: x_return_status := FND_API.G_RET_STS_ERROR ;
1162: RAISE FND_API.G_EXC_ERROR;
1163: when FND_API.G_EXC_UNEXPECTED_ERROR then
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: when others then
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1168: BIS_VG_UTIL.Add_Error_Message

Line 1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1161: x_return_status := FND_API.G_RET_STS_ERROR ;
1162: RAISE FND_API.G_EXC_ERROR;
1163: when FND_API.G_EXC_UNEXPECTED_ERROR then
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: when others then
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1168: BIS_VG_UTIL.Add_Error_Message
1169: ( p_error_msg_id => SQLCODE

Line 1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1163: when FND_API.G_EXC_UNEXPECTED_ERROR then
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: when others then
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1168: BIS_VG_UTIL.Add_Error_Message
1169: ( p_error_msg_id => SQLCODE
1170: , p_error_description => SQLERRM
1171: , p_error_proc_name => G_PKG_NAME||'.get_generated_view_name'

Line 1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1171: , p_error_proc_name => G_PKG_NAME||'.get_generated_view_name'
1172: , p_error_table => x_error_tbl
1173: , x_error_table => x_error_tbl
1174: );
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176:
1177: END get_generated_view_name;
1178:
1179: -- these procedure check and puts the error message on the message stack

Line 1194: when FND_API.G_EXC_ERROR then

1190: fnd_msg_pub.ADD;
1191: END IF;
1192:
1193: EXCEPTION
1194: when FND_API.G_EXC_ERROR then
1195: x_return_status := FND_API.G_RET_STS_ERROR ;
1196: RAISE FND_API.G_EXC_ERROR;
1197: when FND_API.G_EXC_UNEXPECTED_ERROR then
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1195: x_return_status := FND_API.G_RET_STS_ERROR ;

1191: END IF;
1192:
1193: EXCEPTION
1194: when FND_API.G_EXC_ERROR then
1195: x_return_status := FND_API.G_RET_STS_ERROR ;
1196: RAISE FND_API.G_EXC_ERROR;
1197: when FND_API.G_EXC_UNEXPECTED_ERROR then
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1196: RAISE FND_API.G_EXC_ERROR;

1192:
1193: EXCEPTION
1194: when FND_API.G_EXC_ERROR then
1195: x_return_status := FND_API.G_RET_STS_ERROR ;
1196: RAISE FND_API.G_EXC_ERROR;
1197: when FND_API.G_EXC_UNEXPECTED_ERROR then
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1200: when others then

Line 1197: when FND_API.G_EXC_UNEXPECTED_ERROR then

1193: EXCEPTION
1194: when FND_API.G_EXC_ERROR then
1195: x_return_status := FND_API.G_RET_STS_ERROR ;
1196: RAISE FND_API.G_EXC_ERROR;
1197: when FND_API.G_EXC_UNEXPECTED_ERROR then
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1200: when others then
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1194: when FND_API.G_EXC_ERROR then
1195: x_return_status := FND_API.G_RET_STS_ERROR ;
1196: RAISE FND_API.G_EXC_ERROR;
1197: when FND_API.G_EXC_UNEXPECTED_ERROR then
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1200: when others then
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1202: BIS_VG_UTIL.Add_Error_Message

Line 1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1195: x_return_status := FND_API.G_RET_STS_ERROR ;
1196: RAISE FND_API.G_EXC_ERROR;
1197: when FND_API.G_EXC_UNEXPECTED_ERROR then
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1200: when others then
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1202: BIS_VG_UTIL.Add_Error_Message
1203: ( p_error_msg_id => SQLCODE

Line 1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1197: when FND_API.G_EXC_UNEXPECTED_ERROR then
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1200: when others then
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1202: BIS_VG_UTIL.Add_Error_Message
1203: ( p_error_msg_id => SQLCODE
1204: , p_error_description => SQLERRM
1205: , p_error_proc_name => G_PKG_NAME||'.add_message'

Line 1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1205: , p_error_proc_name => G_PKG_NAME||'.add_message'
1206: , p_error_table => x_error_tbl
1207: , x_error_table => x_error_tbl
1208: );
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210:
1211: END add_message;
1212:
1213: PROCEDURE add_message

Line 1231: when FND_API.G_EXC_ERROR then

1227: fnd_msg_pub.ADD;
1228: END IF;
1229:
1230: EXCEPTION
1231: when FND_API.G_EXC_ERROR then
1232: x_return_status := FND_API.G_RET_STS_ERROR ;
1233: RAISE FND_API.G_EXC_ERROR;
1234: when FND_API.G_EXC_UNEXPECTED_ERROR then
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1232: x_return_status := FND_API.G_RET_STS_ERROR ;

1228: END IF;
1229:
1230: EXCEPTION
1231: when FND_API.G_EXC_ERROR then
1232: x_return_status := FND_API.G_RET_STS_ERROR ;
1233: RAISE FND_API.G_EXC_ERROR;
1234: when FND_API.G_EXC_UNEXPECTED_ERROR then
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1233: RAISE FND_API.G_EXC_ERROR;

1229:
1230: EXCEPTION
1231: when FND_API.G_EXC_ERROR then
1232: x_return_status := FND_API.G_RET_STS_ERROR ;
1233: RAISE FND_API.G_EXC_ERROR;
1234: when FND_API.G_EXC_UNEXPECTED_ERROR then
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1237: when others then

Line 1234: when FND_API.G_EXC_UNEXPECTED_ERROR then

1230: EXCEPTION
1231: when FND_API.G_EXC_ERROR then
1232: x_return_status := FND_API.G_RET_STS_ERROR ;
1233: RAISE FND_API.G_EXC_ERROR;
1234: when FND_API.G_EXC_UNEXPECTED_ERROR then
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1237: when others then
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1231: when FND_API.G_EXC_ERROR then
1232: x_return_status := FND_API.G_RET_STS_ERROR ;
1233: RAISE FND_API.G_EXC_ERROR;
1234: when FND_API.G_EXC_UNEXPECTED_ERROR then
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1237: when others then
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1239: BIS_VG_UTIL.Add_Error_Message

Line 1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1232: x_return_status := FND_API.G_RET_STS_ERROR ;
1233: RAISE FND_API.G_EXC_ERROR;
1234: when FND_API.G_EXC_UNEXPECTED_ERROR then
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1237: when others then
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1239: BIS_VG_UTIL.Add_Error_Message
1240: ( p_error_msg_id => SQLCODE

Line 1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1234: when FND_API.G_EXC_UNEXPECTED_ERROR then
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1237: when others then
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1239: BIS_VG_UTIL.Add_Error_Message
1240: ( p_error_msg_id => SQLCODE
1241: , p_error_description => SQLERRM
1242: , p_error_proc_name => G_PKG_NAME||'.add_message'

Line 1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1242: , p_error_proc_name => G_PKG_NAME||'.add_message'
1243: , p_error_table => x_error_tbl
1244: , x_error_table => x_error_tbl
1245: );
1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1247:
1248: END add_message;
1249:
1250: PROCEDURE add_message

Line 1270: when FND_API.G_EXC_ERROR then

1266: fnd_msg_pub.ADD;
1267: END IF;
1268:
1269: EXCEPTION
1270: when FND_API.G_EXC_ERROR then
1271: x_return_status := FND_API.G_RET_STS_ERROR ;
1272: RAISE FND_API.G_EXC_ERROR;
1273: when FND_API.G_EXC_UNEXPECTED_ERROR then
1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1271: x_return_status := FND_API.G_RET_STS_ERROR ;

1267: END IF;
1268:
1269: EXCEPTION
1270: when FND_API.G_EXC_ERROR then
1271: x_return_status := FND_API.G_RET_STS_ERROR ;
1272: RAISE FND_API.G_EXC_ERROR;
1273: when FND_API.G_EXC_UNEXPECTED_ERROR then
1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1272: RAISE FND_API.G_EXC_ERROR;

1268:
1269: EXCEPTION
1270: when FND_API.G_EXC_ERROR then
1271: x_return_status := FND_API.G_RET_STS_ERROR ;
1272: RAISE FND_API.G_EXC_ERROR;
1273: when FND_API.G_EXC_UNEXPECTED_ERROR then
1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1276: when others then

Line 1273: when FND_API.G_EXC_UNEXPECTED_ERROR then

1269: EXCEPTION
1270: when FND_API.G_EXC_ERROR then
1271: x_return_status := FND_API.G_RET_STS_ERROR ;
1272: RAISE FND_API.G_EXC_ERROR;
1273: when FND_API.G_EXC_UNEXPECTED_ERROR then
1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1276: when others then
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1270: when FND_API.G_EXC_ERROR then
1271: x_return_status := FND_API.G_RET_STS_ERROR ;
1272: RAISE FND_API.G_EXC_ERROR;
1273: when FND_API.G_EXC_UNEXPECTED_ERROR then
1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1276: when others then
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1278: BIS_VG_UTIL.Add_Error_Message

Line 1275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1271: x_return_status := FND_API.G_RET_STS_ERROR ;
1272: RAISE FND_API.G_EXC_ERROR;
1273: when FND_API.G_EXC_UNEXPECTED_ERROR then
1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1276: when others then
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1278: BIS_VG_UTIL.Add_Error_Message
1279: ( p_error_msg_id => SQLCODE

Line 1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1273: when FND_API.G_EXC_UNEXPECTED_ERROR then
1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1276: when others then
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1278: BIS_VG_UTIL.Add_Error_Message
1279: ( p_error_msg_id => SQLCODE
1280: , p_error_description => SQLERRM
1281: , p_error_proc_name => G_PKG_NAME||'.add_message'

Line 1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1281: , p_error_proc_name => G_PKG_NAME||'.add_message'
1282: , p_error_table => x_error_tbl
1283: , x_error_table => x_error_tbl
1284: );
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286:
1287: END add_message;
1288:
1289: PROCEDURE add_message

Line 1312: when FND_API.G_EXC_ERROR then

1308: fnd_msg_pub.ADD;
1309: END IF;
1310:
1311: EXCEPTION
1312: when FND_API.G_EXC_ERROR then
1313: x_return_status := FND_API.G_RET_STS_ERROR ;
1314: RAISE FND_API.G_EXC_ERROR;
1315: when FND_API.G_EXC_UNEXPECTED_ERROR then
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1313: x_return_status := FND_API.G_RET_STS_ERROR ;

1309: END IF;
1310:
1311: EXCEPTION
1312: when FND_API.G_EXC_ERROR then
1313: x_return_status := FND_API.G_RET_STS_ERROR ;
1314: RAISE FND_API.G_EXC_ERROR;
1315: when FND_API.G_EXC_UNEXPECTED_ERROR then
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1314: RAISE FND_API.G_EXC_ERROR;

1310:
1311: EXCEPTION
1312: when FND_API.G_EXC_ERROR then
1313: x_return_status := FND_API.G_RET_STS_ERROR ;
1314: RAISE FND_API.G_EXC_ERROR;
1315: when FND_API.G_EXC_UNEXPECTED_ERROR then
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: when others then

Line 1315: when FND_API.G_EXC_UNEXPECTED_ERROR then

1311: EXCEPTION
1312: when FND_API.G_EXC_ERROR then
1313: x_return_status := FND_API.G_RET_STS_ERROR ;
1314: RAISE FND_API.G_EXC_ERROR;
1315: when FND_API.G_EXC_UNEXPECTED_ERROR then
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: when others then
1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1312: when FND_API.G_EXC_ERROR then
1313: x_return_status := FND_API.G_RET_STS_ERROR ;
1314: RAISE FND_API.G_EXC_ERROR;
1315: when FND_API.G_EXC_UNEXPECTED_ERROR then
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: when others then
1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1320: BIS_VG_UTIL.Add_Error_Message

Line 1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1313: x_return_status := FND_API.G_RET_STS_ERROR ;
1314: RAISE FND_API.G_EXC_ERROR;
1315: when FND_API.G_EXC_UNEXPECTED_ERROR then
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: when others then
1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1320: BIS_VG_UTIL.Add_Error_Message
1321: ( p_error_msg_id => SQLCODE

Line 1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1315: when FND_API.G_EXC_UNEXPECTED_ERROR then
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: when others then
1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1320: BIS_VG_UTIL.Add_Error_Message
1321: ( p_error_msg_id => SQLCODE
1322: , p_error_description => SQLERRM
1323: , p_error_proc_name => G_PKG_NAME||'.add_message'

Line 1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1323: , p_error_proc_name => G_PKG_NAME||'.add_message'
1324: , p_error_table => x_error_tbl
1325: , x_error_table => x_error_tbl
1326: );
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328:
1329: END add_message;
1330: --
1331: -- these procedure check and puts the error message on the message stack