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.OKL_ECC_PVT dependencies on OKL_API

Line 8: g_ret_sts_success CONSTANT varchar2(1) := okl_api.g_ret_sts_success;

4: --------------------------------------------------------------------------------
5: --PACKAGE CONSTANTS
6: --------------------------------------------------------------------------------
7:
8: g_ret_sts_success CONSTANT varchar2(1) := okl_api.g_ret_sts_success;
9: g_ret_sts_unexp_error CONSTANT varchar2(1) := okl_api.g_ret_sts_unexp_error;
10: g_ret_sts_error CONSTANT varchar2(1) := okl_api.g_ret_sts_error;
11: g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
12: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';

Line 9: g_ret_sts_unexp_error CONSTANT varchar2(1) := okl_api.g_ret_sts_unexp_error;

5: --PACKAGE CONSTANTS
6: --------------------------------------------------------------------------------
7:
8: g_ret_sts_success CONSTANT varchar2(1) := okl_api.g_ret_sts_success;
9: g_ret_sts_unexp_error CONSTANT varchar2(1) := okl_api.g_ret_sts_unexp_error;
10: g_ret_sts_error CONSTANT varchar2(1) := okl_api.g_ret_sts_error;
11: g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
12: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
13: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;

Line 10: g_ret_sts_error CONSTANT varchar2(1) := okl_api.g_ret_sts_error;

6: --------------------------------------------------------------------------------
7:
8: g_ret_sts_success CONSTANT varchar2(1) := okl_api.g_ret_sts_success;
9: g_ret_sts_unexp_error CONSTANT varchar2(1) := okl_api.g_ret_sts_unexp_error;
10: g_ret_sts_error CONSTANT varchar2(1) := okl_api.g_ret_sts_error;
11: g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
12: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
13: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;
14: g_miss_num CONSTANT number := okl_api.g_miss_num;

Line 13: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;

9: g_ret_sts_unexp_error CONSTANT varchar2(1) := okl_api.g_ret_sts_unexp_error;
10: g_ret_sts_error CONSTANT varchar2(1) := okl_api.g_ret_sts_error;
11: g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
12: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
13: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;
14: g_miss_num CONSTANT number := okl_api.g_miss_num;
15: g_miss_date CONSTANT date := okl_api.g_miss_date;
16: g_no_parent_record CONSTANT varchar2(200) := 'OKC_NO_PARENT_RECORD';
17: g_unexpected_error CONSTANT varchar2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';

Line 14: g_miss_num CONSTANT number := okl_api.g_miss_num;

10: g_ret_sts_error CONSTANT varchar2(1) := okl_api.g_ret_sts_error;
11: g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
12: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
13: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;
14: g_miss_num CONSTANT number := okl_api.g_miss_num;
15: g_miss_date CONSTANT date := okl_api.g_miss_date;
16: g_no_parent_record CONSTANT varchar2(200) := 'OKC_NO_PARENT_RECORD';
17: g_unexpected_error CONSTANT varchar2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
18: g_sqlerrm_token CONSTANT varchar2(200) := 'SQLerrm';

Line 15: g_miss_date CONSTANT date := okl_api.g_miss_date;

11: g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
12: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
13: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;
14: g_miss_num CONSTANT number := okl_api.g_miss_num;
15: g_miss_date CONSTANT date := okl_api.g_miss_date;
16: g_no_parent_record CONSTANT varchar2(200) := 'OKC_NO_PARENT_RECORD';
17: g_unexpected_error CONSTANT varchar2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
18: g_sqlerrm_token CONSTANT varchar2(200) := 'SQLerrm';
19: g_sqlcode_token CONSTANT varchar2(200) := 'SQLcode';

Line 198: okl_api.set_message(p_app_name => g_app_name

194:
195: --crit_cat_def_id is required
196:
197: IF ((p_crit_cat_def_id IS NULL) OR (p_crit_cat_def_id = g_miss_num)) THEN
198: okl_api.set_message(p_app_name => g_app_name
199: ,p_msg_name => g_required_value
200: ,p_token1 => g_col_name_token
201: ,p_token1_value => 'crit_cat_def_id');
202: RAISE okl_api.g_exception_error;

Line 202: RAISE okl_api.g_exception_error;

198: okl_api.set_message(p_app_name => g_app_name
199: ,p_msg_name => g_required_value
200: ,p_token1 => g_col_name_token
201: ,p_token1_value => 'crit_cat_def_id');
202: RAISE okl_api.g_exception_error;
203: END IF;
204: RETURN g_ret_sts_success;
205: EXCEPTION
206: WHEN okl_api.g_exception_error THEN

Line 206: WHEN okl_api.g_exception_error THEN

202: RAISE okl_api.g_exception_error;
203: END IF;
204: RETURN g_ret_sts_success;
205: EXCEPTION
206: WHEN okl_api.g_exception_error THEN
207: RETURN g_ret_sts_error;
208: WHEN okl_api.g_exception_unexpected_error THEN
209: RETURN g_ret_sts_unexp_error;
210: WHEN OTHERS THEN

Line 208: WHEN okl_api.g_exception_unexpected_error THEN

204: RETURN g_ret_sts_success;
205: EXCEPTION
206: WHEN okl_api.g_exception_error THEN
207: RETURN g_ret_sts_error;
208: WHEN okl_api.g_exception_unexpected_error THEN
209: RETURN g_ret_sts_unexp_error;
210: WHEN OTHERS THEN
211: okl_api.set_message(p_app_name => g_app_name
212: ,p_msg_name => g_db_error

Line 211: okl_api.set_message(p_app_name => g_app_name

207: RETURN g_ret_sts_error;
208: WHEN okl_api.g_exception_unexpected_error THEN
209: RETURN g_ret_sts_unexp_error;
210: WHEN OTHERS THEN
211: okl_api.set_message(p_app_name => g_app_name
212: ,p_msg_name => g_db_error
213: ,p_token1 => g_prog_name_token
214: ,p_token1_value => l_api_name
215: ,p_token2 => 'SQLCODE'

Line 234: okl_api.set_message(p_app_name => g_app_name

230:
231: --object_version_number is required
232:
233: IF (p_object_version_number IS NULL) OR (p_object_version_number = g_miss_num) THEN
234: okl_api.set_message(p_app_name => g_app_name
235: ,p_msg_name => g_required_value
236: ,p_token1 => g_col_name_token
237: ,p_token1_value => 'object_version_number');
238: RAISE okl_api.g_exception_error;

Line 238: RAISE okl_api.g_exception_error;

234: okl_api.set_message(p_app_name => g_app_name
235: ,p_msg_name => g_required_value
236: ,p_token1 => g_col_name_token
237: ,p_token1_value => 'object_version_number');
238: RAISE okl_api.g_exception_error;
239: END IF;
240: RETURN g_ret_sts_success;
241: EXCEPTION
242: WHEN okl_api.g_exception_error THEN

Line 242: WHEN okl_api.g_exception_error THEN

238: RAISE okl_api.g_exception_error;
239: END IF;
240: RETURN g_ret_sts_success;
241: EXCEPTION
242: WHEN okl_api.g_exception_error THEN
243: RETURN g_ret_sts_error;
244: WHEN okl_api.g_exception_unexpected_error THEN
245: RETURN g_ret_sts_unexp_error;
246: WHEN OTHERS THEN

Line 244: WHEN okl_api.g_exception_unexpected_error THEN

240: RETURN g_ret_sts_success;
241: EXCEPTION
242: WHEN okl_api.g_exception_error THEN
243: RETURN g_ret_sts_error;
244: WHEN okl_api.g_exception_unexpected_error THEN
245: RETURN g_ret_sts_unexp_error;
246: WHEN OTHERS THEN
247: okl_api.set_message(p_app_name => g_app_name
248: ,p_msg_name => g_db_error

Line 247: okl_api.set_message(p_app_name => g_app_name

243: RETURN g_ret_sts_error;
244: WHEN okl_api.g_exception_unexpected_error THEN
245: RETURN g_ret_sts_unexp_error;
246: WHEN OTHERS THEN
247: okl_api.set_message(p_app_name => g_app_name
248: ,p_msg_name => g_db_error
249: ,p_token1 => g_prog_name_token
250: ,p_token1_value => l_api_name
251: ,p_token2 => 'SQLCODE'

Line 270: okl_api.set_message(p_app_name => g_app_name

266:
267: --name is required
268:
269: IF ((p_name IS NULL) OR (p_name = g_miss_char)) THEN
270: okl_api.set_message(p_app_name => g_app_name
271: ,p_msg_name => g_required_value
272: ,p_token1 => g_col_name_token
273: ,p_token1_value => 'Name');
274: RAISE okl_api.g_exception_error;

Line 274: RAISE okl_api.g_exception_error;

270: okl_api.set_message(p_app_name => g_app_name
271: ,p_msg_name => g_required_value
272: ,p_token1 => g_col_name_token
273: ,p_token1_value => 'Name');
274: RAISE okl_api.g_exception_error;
275: END IF;
276: RETURN g_ret_sts_success;
277: EXCEPTION
278: WHEN okl_api.g_exception_error THEN

Line 278: WHEN okl_api.g_exception_error THEN

274: RAISE okl_api.g_exception_error;
275: END IF;
276: RETURN g_ret_sts_success;
277: EXCEPTION
278: WHEN okl_api.g_exception_error THEN
279: RETURN g_ret_sts_error;
280: WHEN okl_api.g_exception_unexpected_error THEN
281: RETURN g_ret_sts_unexp_error;
282: WHEN OTHERS THEN

Line 280: WHEN okl_api.g_exception_unexpected_error THEN

276: RETURN g_ret_sts_success;
277: EXCEPTION
278: WHEN okl_api.g_exception_error THEN
279: RETURN g_ret_sts_error;
280: WHEN okl_api.g_exception_unexpected_error THEN
281: RETURN g_ret_sts_unexp_error;
282: WHEN OTHERS THEN
283: okl_api.set_message(p_app_name => g_app_name
284: ,p_msg_name => g_db_error

Line 283: okl_api.set_message(p_app_name => g_app_name

279: RETURN g_ret_sts_error;
280: WHEN okl_api.g_exception_unexpected_error THEN
281: RETURN g_ret_sts_unexp_error;
282: WHEN OTHERS THEN
283: okl_api.set_message(p_app_name => g_app_name
284: ,p_msg_name => g_db_error
285: ,p_token1 => g_prog_name_token
286: ,p_token1_value => l_api_name
287: ,p_token2 => 'SQLCODE'

Line 300: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

296: -------------------------------------
297:
298: FUNCTION validate_value_type_code(p_value_type_code IN varchar2) RETURN varchar2 IS
299: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_value_type_code';
300: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
301:
302: BEGIN
303:
304: --value_type_code is required

Line 307: okl_api.set_message(p_app_name => g_app_name

303:
304: --value_type_code is required
305:
306: IF ((p_value_type_code IS NULL) OR (p_value_type_code = g_miss_char)) THEN
307: okl_api.set_message(p_app_name => g_app_name
308: ,p_msg_name => g_required_value
309: ,p_token1 => g_col_name_token
310: ,p_token1_value => 'VALUE_TYPE_CODE');
311: RAISE okl_api.g_exception_error;

Line 311: RAISE okl_api.g_exception_error;

307: okl_api.set_message(p_app_name => g_app_name
308: ,p_msg_name => g_required_value
309: ,p_token1 => g_col_name_token
310: ,p_token1_value => 'VALUE_TYPE_CODE');
311: RAISE okl_api.g_exception_error;
312: END IF;
313:
314: --value_type_code should belong to lookup type OKL_ECC_VALUE_TYPE
315:

Line 319: IF (l_return_status = okl_api.g_ret_sts_error) THEN

315:
316: l_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_ECC_VALUE_TYPE'
317: ,p_lookup_code => p_value_type_code);
318:
319: IF (l_return_status = okl_api.g_ret_sts_error) THEN
320: okl_api.set_message(p_app_name => g_app_name
321: ,p_msg_name => g_invalid_value
322: ,p_token1 => g_col_name_token
323: ,p_token1_value => 'VALUE_TYPE_CODE');

Line 320: okl_api.set_message(p_app_name => g_app_name

316: l_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_ECC_VALUE_TYPE'
317: ,p_lookup_code => p_value_type_code);
318:
319: IF (l_return_status = okl_api.g_ret_sts_error) THEN
320: okl_api.set_message(p_app_name => g_app_name
321: ,p_msg_name => g_invalid_value
322: ,p_token1 => g_col_name_token
323: ,p_token1_value => 'VALUE_TYPE_CODE');
324: RAISE okl_api.g_exception_error;

Line 324: RAISE okl_api.g_exception_error;

320: okl_api.set_message(p_app_name => g_app_name
321: ,p_msg_name => g_invalid_value
322: ,p_token1 => g_col_name_token
323: ,p_token1_value => 'VALUE_TYPE_CODE');
324: RAISE okl_api.g_exception_error;
325: END IF;
326: RETURN g_ret_sts_success;
327: EXCEPTION
328: WHEN okl_api.g_exception_error THEN

Line 328: WHEN okl_api.g_exception_error THEN

324: RAISE okl_api.g_exception_error;
325: END IF;
326: RETURN g_ret_sts_success;
327: EXCEPTION
328: WHEN okl_api.g_exception_error THEN
329: RETURN g_ret_sts_error;
330: WHEN okl_api.g_exception_unexpected_error THEN
331: RETURN g_ret_sts_unexp_error;
332: WHEN OTHERS THEN

Line 330: WHEN okl_api.g_exception_unexpected_error THEN

326: RETURN g_ret_sts_success;
327: EXCEPTION
328: WHEN okl_api.g_exception_error THEN
329: RETURN g_ret_sts_error;
330: WHEN okl_api.g_exception_unexpected_error THEN
331: RETURN g_ret_sts_unexp_error;
332: WHEN OTHERS THEN
333: okl_api.set_message(p_app_name => g_app_name
334: ,p_msg_name => g_db_error

Line 333: okl_api.set_message(p_app_name => g_app_name

329: RETURN g_ret_sts_error;
330: WHEN okl_api.g_exception_unexpected_error THEN
331: RETURN g_ret_sts_unexp_error;
332: WHEN OTHERS THEN
333: okl_api.set_message(p_app_name => g_app_name
334: ,p_msg_name => g_db_error
335: ,p_token1 => g_prog_name_token
336: ,p_token1_value => l_api_name
337: ,p_token2 => 'SQLCODE'

Line 356: okl_api.set_message(p_app_name => g_app_name

352:
353: --ecc_ac_flag is required
354:
355: IF ((p_ecc_ac_flag IS NULL) OR (p_ecc_ac_flag = g_miss_char)) THEN
356: okl_api.set_message(p_app_name => g_app_name
357: ,p_msg_name => g_required_value
358: ,p_token1 => g_col_name_token
359: ,p_token1_value => 'ECC_AC_FLAG');
360: RAISE okl_api.g_exception_error;

Line 360: RAISE okl_api.g_exception_error;

356: okl_api.set_message(p_app_name => g_app_name
357: ,p_msg_name => g_required_value
358: ,p_token1 => g_col_name_token
359: ,p_token1_value => 'ECC_AC_FLAG');
360: RAISE okl_api.g_exception_error;
361: END IF;
362:
363: -- ecc_ac_flag should either be ECC or AC
364:

Line 366: okl_api.set_message(p_app_name => g_app_name

362:
363: -- ecc_ac_flag should either be ECC or AC
364:
365: IF ( NOT ((p_ecc_ac_flag = 'ECC') OR (p_ecc_ac_flag = 'AC'))) THEN
366: okl_api.set_message(p_app_name => g_app_name
367: ,p_msg_name => g_invalid_value
368: ,p_token1 => g_col_name_token
369: ,p_token1_value => 'ECC_AC_FLAG');
370: RAISE okl_api.g_exception_error;

Line 370: RAISE okl_api.g_exception_error;

366: okl_api.set_message(p_app_name => g_app_name
367: ,p_msg_name => g_invalid_value
368: ,p_token1 => g_col_name_token
369: ,p_token1_value => 'ECC_AC_FLAG');
370: RAISE okl_api.g_exception_error;
371: END IF;
372: RETURN g_ret_sts_success;
373: EXCEPTION
374: WHEN okl_api.g_exception_error THEN

Line 374: WHEN okl_api.g_exception_error THEN

370: RAISE okl_api.g_exception_error;
371: END IF;
372: RETURN g_ret_sts_success;
373: EXCEPTION
374: WHEN okl_api.g_exception_error THEN
375: RETURN g_ret_sts_error;
376: WHEN okl_api.g_exception_unexpected_error THEN
377: RETURN g_ret_sts_unexp_error;
378: WHEN OTHERS THEN

Line 376: WHEN okl_api.g_exception_unexpected_error THEN

372: RETURN g_ret_sts_success;
373: EXCEPTION
374: WHEN okl_api.g_exception_error THEN
375: RETURN g_ret_sts_error;
376: WHEN okl_api.g_exception_unexpected_error THEN
377: RETURN g_ret_sts_unexp_error;
378: WHEN OTHERS THEN
379: okl_api.set_message(p_app_name => g_app_name
380: ,p_msg_name => g_db_error

Line 379: okl_api.set_message(p_app_name => g_app_name

375: RETURN g_ret_sts_error;
376: WHEN okl_api.g_exception_unexpected_error THEN
377: RETURN g_ret_sts_unexp_error;
378: WHEN OTHERS THEN
379: okl_api.set_message(p_app_name => g_app_name
380: ,p_msg_name => g_db_error
381: ,p_token1 => g_prog_name_token
382: ,p_token1_value => l_api_name
383: ,p_token2 => 'SQLCODE'

Line 396: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

392: ------------------------------------
393:
394: FUNCTION validate_data_type_code(p_data_type_code IN varchar2) RETURN varchar2 IS
395: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_data_type_code';
396: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
397:
398: BEGIN
399:
400: --data_type_code is required

Line 403: okl_api.set_message(p_app_name => g_app_name

399:
400: --data_type_code is required
401:
402: IF ((p_data_type_code IS NULL) OR (p_data_type_code = g_miss_char)) THEN
403: okl_api.set_message(p_app_name => g_app_name
404: ,p_msg_name => g_required_value
405: ,p_token1 => g_col_name_token
406: ,p_token1_value => 'DATA_TYPE_CODE');
407: RAISE okl_api.g_exception_error;

Line 407: RAISE okl_api.g_exception_error;

403: okl_api.set_message(p_app_name => g_app_name
404: ,p_msg_name => g_required_value
405: ,p_token1 => g_col_name_token
406: ,p_token1_value => 'DATA_TYPE_CODE');
407: RAISE okl_api.g_exception_error;
408: END IF;
409:
410: --data_type_code should belong to lookup type OKL_ECC_DATA_TYPE
411:

Line 415: IF (l_return_status = okl_api.g_ret_sts_error) THEN

411:
412: l_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_ECC_DATA_TYPE'
413: ,p_lookup_code => p_data_type_code);
414:
415: IF (l_return_status = okl_api.g_ret_sts_error) THEN
416: okl_api.set_message(p_app_name => g_app_name
417: ,p_msg_name => g_invalid_value
418: ,p_token1 => g_col_name_token
419: ,p_token1_value => 'DATA_TYPE_CODE');

Line 416: okl_api.set_message(p_app_name => g_app_name

412: l_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_ECC_DATA_TYPE'
413: ,p_lookup_code => p_data_type_code);
414:
415: IF (l_return_status = okl_api.g_ret_sts_error) THEN
416: okl_api.set_message(p_app_name => g_app_name
417: ,p_msg_name => g_invalid_value
418: ,p_token1 => g_col_name_token
419: ,p_token1_value => 'DATA_TYPE_CODE');
420: RAISE okl_api.g_exception_error;

Line 420: RAISE okl_api.g_exception_error;

416: okl_api.set_message(p_app_name => g_app_name
417: ,p_msg_name => g_invalid_value
418: ,p_token1 => g_col_name_token
419: ,p_token1_value => 'DATA_TYPE_CODE');
420: RAISE okl_api.g_exception_error;
421: END IF;
422: RETURN g_ret_sts_success;
423: EXCEPTION
424: WHEN okl_api.g_exception_error THEN

Line 424: WHEN okl_api.g_exception_error THEN

420: RAISE okl_api.g_exception_error;
421: END IF;
422: RETURN g_ret_sts_success;
423: EXCEPTION
424: WHEN okl_api.g_exception_error THEN
425: RETURN g_ret_sts_error;
426: WHEN okl_api.g_exception_unexpected_error THEN
427: RETURN g_ret_sts_unexp_error;
428: WHEN OTHERS THEN

Line 426: WHEN okl_api.g_exception_unexpected_error THEN

422: RETURN g_ret_sts_success;
423: EXCEPTION
424: WHEN okl_api.g_exception_error THEN
425: RETURN g_ret_sts_error;
426: WHEN okl_api.g_exception_unexpected_error THEN
427: RETURN g_ret_sts_unexp_error;
428: WHEN OTHERS THEN
429: okl_api.set_message(p_app_name => g_app_name
430: ,p_msg_name => g_db_error

Line 429: okl_api.set_message(p_app_name => g_app_name

425: RETURN g_ret_sts_error;
426: WHEN okl_api.g_exception_unexpected_error THEN
427: RETURN g_ret_sts_unexp_error;
428: WHEN OTHERS THEN
429: okl_api.set_message(p_app_name => g_app_name
430: ,p_msg_name => g_db_error
431: ,p_token1 => g_prog_name_token
432: ,p_token1_value => l_api_name
433: ,p_token2 => 'SQLCODE'

Line 446: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

442: ---------------------------------
443:
444: FUNCTION validate_seeded_yn(p_seeded_yn IN varchar2) RETURN varchar2 IS
445: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_seeded_yn';
446: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
447:
448: BEGIN
449:
450: --seeded_yn is required

Line 453: okl_api.set_message(p_app_name => g_app_name

449:
450: --seeded_yn is required
451:
452: IF ((p_seeded_yn IS NULL) OR (p_seeded_yn = g_miss_char)) THEN
453: okl_api.set_message(p_app_name => g_app_name
454: ,p_msg_name => g_required_value
455: ,p_token1 => g_col_name_token
456: ,p_token1_value => 'seeded_yn');
457: RAISE okl_api.g_exception_error;

Line 457: RAISE okl_api.g_exception_error;

453: okl_api.set_message(p_app_name => g_app_name
454: ,p_msg_name => g_required_value
455: ,p_token1 => g_col_name_token
456: ,p_token1_value => 'seeded_yn');
457: RAISE okl_api.g_exception_error;
458: END IF;
459:
460: --seeded_yn should belong to lookup type OKL_YES_NO
461:

Line 465: IF (l_return_status = okl_api.g_ret_sts_error) THEN

461:
462: l_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_YES_NO'
463: ,p_lookup_code => p_seeded_yn);
464:
465: IF (l_return_status = okl_api.g_ret_sts_error) THEN
466: okl_api.set_message(p_app_name => g_app_name
467: ,p_msg_name => g_invalid_value
468: ,p_token1 => g_col_name_token
469: ,p_token1_value => 'seeded_yn');

Line 466: okl_api.set_message(p_app_name => g_app_name

462: l_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_YES_NO'
463: ,p_lookup_code => p_seeded_yn);
464:
465: IF (l_return_status = okl_api.g_ret_sts_error) THEN
466: okl_api.set_message(p_app_name => g_app_name
467: ,p_msg_name => g_invalid_value
468: ,p_token1 => g_col_name_token
469: ,p_token1_value => 'seeded_yn');
470: RAISE okl_api.g_exception_error;

Line 470: RAISE okl_api.g_exception_error;

466: okl_api.set_message(p_app_name => g_app_name
467: ,p_msg_name => g_invalid_value
468: ,p_token1 => g_col_name_token
469: ,p_token1_value => 'seeded_yn');
470: RAISE okl_api.g_exception_error;
471: END IF;
472: RETURN g_ret_sts_success;
473: EXCEPTION
474: WHEN okl_api.g_exception_error THEN

Line 474: WHEN okl_api.g_exception_error THEN

470: RAISE okl_api.g_exception_error;
471: END IF;
472: RETURN g_ret_sts_success;
473: EXCEPTION
474: WHEN okl_api.g_exception_error THEN
475: RETURN g_ret_sts_error;
476: WHEN okl_api.g_exception_unexpected_error THEN
477: RETURN g_ret_sts_unexp_error;
478: WHEN OTHERS THEN

Line 476: WHEN okl_api.g_exception_unexpected_error THEN

472: RETURN g_ret_sts_success;
473: EXCEPTION
474: WHEN okl_api.g_exception_error THEN
475: RETURN g_ret_sts_error;
476: WHEN okl_api.g_exception_unexpected_error THEN
477: RETURN g_ret_sts_unexp_error;
478: WHEN OTHERS THEN
479: okl_api.set_message(p_app_name => g_app_name
480: ,p_msg_name => g_db_error

Line 479: okl_api.set_message(p_app_name => g_app_name

475: RETURN g_ret_sts_error;
476: WHEN okl_api.g_exception_unexpected_error THEN
477: RETURN g_ret_sts_unexp_error;
478: WHEN OTHERS THEN
479: okl_api.set_message(p_app_name => g_app_name
480: ,p_msg_name => g_db_error
481: ,p_token1 => g_prog_name_token
482: ,p_token1_value => l_api_name
483: ,p_token2 => 'SQLCODE'

Line 496: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

492: ---------------------------------
493:
494: FUNCTION validate_enabled_yn(p_enabled_yn IN varchar2) RETURN varchar2 IS
495: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_enabled_yn';
496: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
497:
498: BEGIN
499:
500: --enabled_yn is required

Line 503: okl_api.set_message(p_app_name => g_app_name

499:
500: --enabled_yn is required
501:
502: IF ((p_enabled_yn IS NULL) OR (p_enabled_yn = g_miss_char)) THEN
503: okl_api.set_message(p_app_name => g_app_name
504: ,p_msg_name => g_required_value
505: ,p_token1 => g_col_name_token
506: ,p_token1_value => 'enabled_yn');
507: RAISE okl_api.g_exception_error;

Line 507: RAISE okl_api.g_exception_error;

503: okl_api.set_message(p_app_name => g_app_name
504: ,p_msg_name => g_required_value
505: ,p_token1 => g_col_name_token
506: ,p_token1_value => 'enabled_yn');
507: RAISE okl_api.g_exception_error;
508: END IF;
509:
510: --enabled_yn should belong to lookup type OKL_YES_NO
511:

Line 515: IF (l_return_status = okl_api.g_ret_sts_error) THEN

511:
512: l_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_YES_NO'
513: ,p_lookup_code => p_enabled_yn);
514:
515: IF (l_return_status = okl_api.g_ret_sts_error) THEN
516: okl_api.set_message(p_app_name => g_app_name
517: ,p_msg_name => g_invalid_value
518: ,p_token1 => g_col_name_token
519: ,p_token1_value => 'enabled_yn');

Line 516: okl_api.set_message(p_app_name => g_app_name

512: l_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_YES_NO'
513: ,p_lookup_code => p_enabled_yn);
514:
515: IF (l_return_status = okl_api.g_ret_sts_error) THEN
516: okl_api.set_message(p_app_name => g_app_name
517: ,p_msg_name => g_invalid_value
518: ,p_token1 => g_col_name_token
519: ,p_token1_value => 'enabled_yn');
520: RAISE okl_api.g_exception_error;

Line 520: RAISE okl_api.g_exception_error;

516: okl_api.set_message(p_app_name => g_app_name
517: ,p_msg_name => g_invalid_value
518: ,p_token1 => g_col_name_token
519: ,p_token1_value => 'enabled_yn');
520: RAISE okl_api.g_exception_error;
521: END IF;
522: RETURN g_ret_sts_success;
523: EXCEPTION
524: WHEN okl_api.g_exception_error THEN

Line 524: WHEN okl_api.g_exception_error THEN

520: RAISE okl_api.g_exception_error;
521: END IF;
522: RETURN g_ret_sts_success;
523: EXCEPTION
524: WHEN okl_api.g_exception_error THEN
525: RETURN g_ret_sts_error;
526: WHEN okl_api.g_exception_unexpected_error THEN
527: RETURN g_ret_sts_unexp_error;
528: WHEN OTHERS THEN

Line 526: WHEN okl_api.g_exception_unexpected_error THEN

522: RETURN g_ret_sts_success;
523: EXCEPTION
524: WHEN okl_api.g_exception_error THEN
525: RETURN g_ret_sts_error;
526: WHEN okl_api.g_exception_unexpected_error THEN
527: RETURN g_ret_sts_unexp_error;
528: WHEN OTHERS THEN
529: okl_api.set_message(p_app_name => g_app_name
530: ,p_msg_name => g_db_error

Line 529: okl_api.set_message(p_app_name => g_app_name

525: RETURN g_ret_sts_error;
526: WHEN okl_api.g_exception_unexpected_error THEN
527: RETURN g_ret_sts_unexp_error;
528: WHEN OTHERS THEN
529: okl_api.set_message(p_app_name => g_app_name
530: ,p_msg_name => g_db_error
531: ,p_token1 => g_prog_name_token
532: ,p_token1_value => l_api_name
533: ,p_token2 => 'SQLCODE'

Line 546: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

542: ---------------------------------
543:
544: FUNCTION validate_source_yn(p_source_yn IN varchar2) RETURN varchar2 IS
545: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_source_yn';
546: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
547:
548: BEGIN
549:
550: --source_yn is required

Line 553: okl_api.set_message(p_app_name => g_app_name

549:
550: --source_yn is required
551:
552: IF ((p_source_yn IS NULL) OR (p_source_yn = g_miss_char)) THEN
553: okl_api.set_message(p_app_name => g_app_name
554: ,p_msg_name => g_required_value
555: ,p_token1 => g_col_name_token
556: ,p_token1_value => 'source_yn');
557: RAISE okl_api.g_exception_error;

Line 557: RAISE okl_api.g_exception_error;

553: okl_api.set_message(p_app_name => g_app_name
554: ,p_msg_name => g_required_value
555: ,p_token1 => g_col_name_token
556: ,p_token1_value => 'source_yn');
557: RAISE okl_api.g_exception_error;
558: END IF;
559:
560: --source_yn should belong to lookup type OKL_YES_NO
561:

Line 565: IF (l_return_status = okl_api.g_ret_sts_error) THEN

561:
562: l_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_YES_NO'
563: ,p_lookup_code => p_source_yn);
564:
565: IF (l_return_status = okl_api.g_ret_sts_error) THEN
566: okl_api.set_message(p_app_name => g_app_name
567: ,p_msg_name => g_invalid_value
568: ,p_token1 => g_col_name_token
569: ,p_token1_value => 'source_yn');

Line 566: okl_api.set_message(p_app_name => g_app_name

562: l_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_YES_NO'
563: ,p_lookup_code => p_source_yn);
564:
565: IF (l_return_status = okl_api.g_ret_sts_error) THEN
566: okl_api.set_message(p_app_name => g_app_name
567: ,p_msg_name => g_invalid_value
568: ,p_token1 => g_col_name_token
569: ,p_token1_value => 'source_yn');
570: RAISE okl_api.g_exception_error;

Line 570: RAISE okl_api.g_exception_error;

566: okl_api.set_message(p_app_name => g_app_name
567: ,p_msg_name => g_invalid_value
568: ,p_token1 => g_col_name_token
569: ,p_token1_value => 'source_yn');
570: RAISE okl_api.g_exception_error;
571: END IF;
572: RETURN g_ret_sts_success;
573: EXCEPTION
574: WHEN okl_api.g_exception_error THEN

Line 574: WHEN okl_api.g_exception_error THEN

570: RAISE okl_api.g_exception_error;
571: END IF;
572: RETURN g_ret_sts_success;
573: EXCEPTION
574: WHEN okl_api.g_exception_error THEN
575: RETURN g_ret_sts_error;
576: WHEN okl_api.g_exception_unexpected_error THEN
577: RETURN g_ret_sts_unexp_error;
578: WHEN OTHERS THEN

Line 576: WHEN okl_api.g_exception_unexpected_error THEN

572: RETURN g_ret_sts_success;
573: EXCEPTION
574: WHEN okl_api.g_exception_error THEN
575: RETURN g_ret_sts_error;
576: WHEN okl_api.g_exception_unexpected_error THEN
577: RETURN g_ret_sts_unexp_error;
578: WHEN OTHERS THEN
579: okl_api.set_message(p_app_name => g_app_name
580: ,p_msg_name => g_db_error

Line 579: okl_api.set_message(p_app_name => g_app_name

575: RETURN g_ret_sts_error;
576: WHEN okl_api.g_exception_unexpected_error THEN
577: RETURN g_ret_sts_unexp_error;
578: WHEN OTHERS THEN
579: okl_api.set_message(p_app_name => g_app_name
580: ,p_msg_name => g_db_error
581: ,p_token1 => g_prog_name_token
582: ,p_token1_value => l_api_name
583: ,p_token2 => 'SQLCODE'

Line 619: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

615: FROM okl_fe_crit_cat_def_b
616: WHERE crit_cat_def_id = p_eccb_rec.crit_cat_def_id;
617: l_api_version CONSTANT number := 1;
618: l_api_name CONSTANT varchar2(30) := 'B_lock_row';
619: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
620: l_object_version_number okl_fe_crit_cat_def_b.object_version_number%TYPE;
621: lc_object_version_number okl_fe_crit_cat_def_b.object_version_number%TYPE;
622: l_row_notfound boolean := false;
623: lc_row_notfound boolean := false;

Line 626: l_return_status := okl_api.start_activity(l_api_name

622: l_row_notfound boolean := false;
623: lc_row_notfound boolean := false;
624:
625: BEGIN
626: l_return_status := okl_api.start_activity(l_api_name
627: ,p_init_msg_list
628: ,'_PVT'
629: ,x_return_status);
630:

Line 631: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

627: ,p_init_msg_list
628: ,'_PVT'
629: ,x_return_status);
630:
631: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
632: RAISE okl_api.g_exception_unexpected_error;
633: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
634: RAISE okl_api.g_exception_error;
635: END IF;

Line 632: RAISE okl_api.g_exception_unexpected_error;

628: ,'_PVT'
629: ,x_return_status);
630:
631: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
632: RAISE okl_api.g_exception_unexpected_error;
633: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
634: RAISE okl_api.g_exception_error;
635: END IF;
636:

Line 633: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

629: ,x_return_status);
630:
631: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
632: RAISE okl_api.g_exception_unexpected_error;
633: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
634: RAISE okl_api.g_exception_error;
635: END IF;
636:
637: BEGIN

Line 634: RAISE okl_api.g_exception_error;

630:
631: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
632: RAISE okl_api.g_exception_unexpected_error;
633: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
634: RAISE okl_api.g_exception_error;
635: END IF;
636:
637: BEGIN
638: OPEN lock_csr(p_eccb_rec);

Line 648: okl_api.set_message(g_fnd_app, g_form_unable_to_reserve_rec);

644:
645: IF (lock_csr%ISOPEN) THEN
646: CLOSE lock_csr;
647: END IF;
648: okl_api.set_message(g_fnd_app, g_form_unable_to_reserve_rec);
649: RAISE app_exceptions.record_lock_exception;
650: END;
651:
652: IF (l_row_notfound) THEN

Line 660: okl_api.set_message(g_fnd_app, g_form_record_deleted);

656: CLOSE lchk_csr;
657: END IF;
658:
659: IF (lc_row_notfound) THEN
660: okl_api.set_message(g_fnd_app, g_form_record_deleted);
661: RAISE okl_api.g_exception_error;
662: ELSIF lc_object_version_number > p_eccb_rec.object_version_number THEN
663: okl_api.set_message(g_fnd_app, g_form_record_changed);
664: RAISE okl_api.g_exception_error;

Line 661: RAISE okl_api.g_exception_error;

657: END IF;
658:
659: IF (lc_row_notfound) THEN
660: okl_api.set_message(g_fnd_app, g_form_record_deleted);
661: RAISE okl_api.g_exception_error;
662: ELSIF lc_object_version_number > p_eccb_rec.object_version_number THEN
663: okl_api.set_message(g_fnd_app, g_form_record_changed);
664: RAISE okl_api.g_exception_error;
665: ELSIF lc_object_version_number <> p_eccb_rec.object_version_number THEN

Line 663: okl_api.set_message(g_fnd_app, g_form_record_changed);

659: IF (lc_row_notfound) THEN
660: okl_api.set_message(g_fnd_app, g_form_record_deleted);
661: RAISE okl_api.g_exception_error;
662: ELSIF lc_object_version_number > p_eccb_rec.object_version_number THEN
663: okl_api.set_message(g_fnd_app, g_form_record_changed);
664: RAISE okl_api.g_exception_error;
665: ELSIF lc_object_version_number <> p_eccb_rec.object_version_number THEN
666: okl_api.set_message(g_fnd_app, g_form_record_changed);
667: RAISE okl_api.g_exception_error;

Line 664: RAISE okl_api.g_exception_error;

660: okl_api.set_message(g_fnd_app, g_form_record_deleted);
661: RAISE okl_api.g_exception_error;
662: ELSIF lc_object_version_number > p_eccb_rec.object_version_number THEN
663: okl_api.set_message(g_fnd_app, g_form_record_changed);
664: RAISE okl_api.g_exception_error;
665: ELSIF lc_object_version_number <> p_eccb_rec.object_version_number THEN
666: okl_api.set_message(g_fnd_app, g_form_record_changed);
667: RAISE okl_api.g_exception_error;
668: ELSIF lc_object_version_number = - 1 THEN

Line 666: okl_api.set_message(g_fnd_app, g_form_record_changed);

662: ELSIF lc_object_version_number > p_eccb_rec.object_version_number THEN
663: okl_api.set_message(g_fnd_app, g_form_record_changed);
664: RAISE okl_api.g_exception_error;
665: ELSIF lc_object_version_number <> p_eccb_rec.object_version_number THEN
666: okl_api.set_message(g_fnd_app, g_form_record_changed);
667: RAISE okl_api.g_exception_error;
668: ELSIF lc_object_version_number = - 1 THEN
669: okl_api.set_message(g_app_name, g_record_logically_deleted);
670: RAISE okl_api.g_exception_error;

Line 667: RAISE okl_api.g_exception_error;

663: okl_api.set_message(g_fnd_app, g_form_record_changed);
664: RAISE okl_api.g_exception_error;
665: ELSIF lc_object_version_number <> p_eccb_rec.object_version_number THEN
666: okl_api.set_message(g_fnd_app, g_form_record_changed);
667: RAISE okl_api.g_exception_error;
668: ELSIF lc_object_version_number = - 1 THEN
669: okl_api.set_message(g_app_name, g_record_logically_deleted);
670: RAISE okl_api.g_exception_error;
671: END IF;

Line 669: okl_api.set_message(g_app_name, g_record_logically_deleted);

665: ELSIF lc_object_version_number <> p_eccb_rec.object_version_number THEN
666: okl_api.set_message(g_fnd_app, g_form_record_changed);
667: RAISE okl_api.g_exception_error;
668: ELSIF lc_object_version_number = - 1 THEN
669: okl_api.set_message(g_app_name, g_record_logically_deleted);
670: RAISE okl_api.g_exception_error;
671: END IF;
672: okl_api.end_activity(x_msg_count, x_msg_data);
673: EXCEPTION

Line 670: RAISE okl_api.g_exception_error;

666: okl_api.set_message(g_fnd_app, g_form_record_changed);
667: RAISE okl_api.g_exception_error;
668: ELSIF lc_object_version_number = - 1 THEN
669: okl_api.set_message(g_app_name, g_record_logically_deleted);
670: RAISE okl_api.g_exception_error;
671: END IF;
672: okl_api.end_activity(x_msg_count, x_msg_data);
673: EXCEPTION
674: WHEN g_exception_halt_validation THEN

Line 672: okl_api.end_activity(x_msg_count, x_msg_data);

668: ELSIF lc_object_version_number = - 1 THEN
669: okl_api.set_message(g_app_name, g_record_logically_deleted);
670: RAISE okl_api.g_exception_error;
671: END IF;
672: okl_api.end_activity(x_msg_count, x_msg_data);
673: EXCEPTION
674: WHEN g_exception_halt_validation THEN
675: x_return_status := okl_api.handle_exceptions(l_api_name
676: ,g_pkg_name

Line 675: x_return_status := okl_api.handle_exceptions(l_api_name

671: END IF;
672: okl_api.end_activity(x_msg_count, x_msg_data);
673: EXCEPTION
674: WHEN g_exception_halt_validation THEN
675: x_return_status := okl_api.handle_exceptions(l_api_name
676: ,g_pkg_name
677: ,'OKL_API.G_RET_STS_ERROR'
678: ,x_msg_count
679: ,x_msg_data

Line 677: ,'OKL_API.G_RET_STS_ERROR'

673: EXCEPTION
674: WHEN g_exception_halt_validation THEN
675: x_return_status := okl_api.handle_exceptions(l_api_name
676: ,g_pkg_name
677: ,'OKL_API.G_RET_STS_ERROR'
678: ,x_msg_count
679: ,x_msg_data
680: ,'_PVT');
681: WHEN okl_api.g_exception_error THEN

Line 681: WHEN okl_api.g_exception_error THEN

677: ,'OKL_API.G_RET_STS_ERROR'
678: ,x_msg_count
679: ,x_msg_data
680: ,'_PVT');
681: WHEN okl_api.g_exception_error THEN
682: x_return_status := okl_api.handle_exceptions(l_api_name
683: ,g_pkg_name
684: ,'OKL_API.G_RET_STS_ERROR'
685: ,x_msg_count

Line 682: x_return_status := okl_api.handle_exceptions(l_api_name

678: ,x_msg_count
679: ,x_msg_data
680: ,'_PVT');
681: WHEN okl_api.g_exception_error THEN
682: x_return_status := okl_api.handle_exceptions(l_api_name
683: ,g_pkg_name
684: ,'OKL_API.G_RET_STS_ERROR'
685: ,x_msg_count
686: ,x_msg_data

Line 684: ,'OKL_API.G_RET_STS_ERROR'

680: ,'_PVT');
681: WHEN okl_api.g_exception_error THEN
682: x_return_status := okl_api.handle_exceptions(l_api_name
683: ,g_pkg_name
684: ,'OKL_API.G_RET_STS_ERROR'
685: ,x_msg_count
686: ,x_msg_data
687: ,'_PVT');
688: WHEN okl_api.g_exception_unexpected_error THEN

Line 688: WHEN okl_api.g_exception_unexpected_error THEN

684: ,'OKL_API.G_RET_STS_ERROR'
685: ,x_msg_count
686: ,x_msg_data
687: ,'_PVT');
688: WHEN okl_api.g_exception_unexpected_error THEN
689: x_return_status := okl_api.handle_exceptions(l_api_name
690: ,g_pkg_name
691: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
692: ,x_msg_count

Line 689: x_return_status := okl_api.handle_exceptions(l_api_name

685: ,x_msg_count
686: ,x_msg_data
687: ,'_PVT');
688: WHEN okl_api.g_exception_unexpected_error THEN
689: x_return_status := okl_api.handle_exceptions(l_api_name
690: ,g_pkg_name
691: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
692: ,x_msg_count
693: ,x_msg_data

Line 691: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

687: ,'_PVT');
688: WHEN okl_api.g_exception_unexpected_error THEN
689: x_return_status := okl_api.handle_exceptions(l_api_name
690: ,g_pkg_name
691: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
692: ,x_msg_count
693: ,x_msg_data
694: ,'_PVT');
695: WHEN OTHERS THEN

Line 696: x_return_status := okl_api.handle_exceptions(l_api_name

692: ,x_msg_count
693: ,x_msg_data
694: ,'_PVT');
695: WHEN OTHERS THEN
696: x_return_status := okl_api.handle_exceptions(l_api_name
697: ,g_pkg_name
698: ,'OTHERS'
699: ,x_msg_count
700: ,x_msg_data

Line 724: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

720: WHERE crit_cat_def_id = p_ecctl_rec.crit_cat_def_id
721: FOR UPDATE NOWAIT;
722: l_api_version CONSTANT number := 1;
723: l_api_name CONSTANT varchar2(30) := 'TL_lock_row';
724: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
725: l_lock_var lock_csr%ROWTYPE;
726: l_row_notfound boolean := false;
727: lc_row_notfound boolean := false;
728:

Line 730: l_return_status := okl_api.start_activity(l_api_name

726: l_row_notfound boolean := false;
727: lc_row_notfound boolean := false;
728:
729: BEGIN
730: l_return_status := okl_api.start_activity(l_api_name
731: ,p_init_msg_list
732: ,'_PVT'
733: ,x_return_status);
734:

Line 735: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

731: ,p_init_msg_list
732: ,'_PVT'
733: ,x_return_status);
734:
735: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
736: RAISE okl_api.g_exception_unexpected_error;
737: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
738: RAISE okl_api.g_exception_error;
739: END IF;

Line 736: RAISE okl_api.g_exception_unexpected_error;

732: ,'_PVT'
733: ,x_return_status);
734:
735: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
736: RAISE okl_api.g_exception_unexpected_error;
737: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
738: RAISE okl_api.g_exception_error;
739: END IF;
740:

Line 737: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

733: ,x_return_status);
734:
735: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
736: RAISE okl_api.g_exception_unexpected_error;
737: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
738: RAISE okl_api.g_exception_error;
739: END IF;
740:
741: BEGIN

Line 738: RAISE okl_api.g_exception_error;

734:
735: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
736: RAISE okl_api.g_exception_unexpected_error;
737: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
738: RAISE okl_api.g_exception_error;
739: END IF;
740:
741: BEGIN
742: OPEN lock_csr(p_ecctl_rec);

Line 752: okl_api.set_message(g_fnd_app, g_form_unable_to_reserve_rec);

748:
749: IF (lock_csr%ISOPEN) THEN
750: CLOSE lock_csr;
751: END IF;
752: okl_api.set_message(g_fnd_app, g_form_unable_to_reserve_rec);
753: RAISE app_exceptions.record_lock_exception;
754: END;
755:
756: IF (l_row_notfound) THEN

Line 757: okl_api.set_message(g_fnd_app, g_form_record_deleted);

753: RAISE app_exceptions.record_lock_exception;
754: END;
755:
756: IF (l_row_notfound) THEN
757: okl_api.set_message(g_fnd_app, g_form_record_deleted);
758: RAISE okl_api.g_exception_error;
759: END IF;
760: okl_api.end_activity(x_msg_count, x_msg_data);
761: EXCEPTION

Line 758: RAISE okl_api.g_exception_error;

754: END;
755:
756: IF (l_row_notfound) THEN
757: okl_api.set_message(g_fnd_app, g_form_record_deleted);
758: RAISE okl_api.g_exception_error;
759: END IF;
760: okl_api.end_activity(x_msg_count, x_msg_data);
761: EXCEPTION
762: WHEN g_exception_halt_validation THEN

Line 760: okl_api.end_activity(x_msg_count, x_msg_data);

756: IF (l_row_notfound) THEN
757: okl_api.set_message(g_fnd_app, g_form_record_deleted);
758: RAISE okl_api.g_exception_error;
759: END IF;
760: okl_api.end_activity(x_msg_count, x_msg_data);
761: EXCEPTION
762: WHEN g_exception_halt_validation THEN
763: x_return_status := okl_api.handle_exceptions(l_api_name
764: ,g_pkg_name

Line 763: x_return_status := okl_api.handle_exceptions(l_api_name

759: END IF;
760: okl_api.end_activity(x_msg_count, x_msg_data);
761: EXCEPTION
762: WHEN g_exception_halt_validation THEN
763: x_return_status := okl_api.handle_exceptions(l_api_name
764: ,g_pkg_name
765: ,'OKL_API.G_RET_STS_ERROR'
766: ,x_msg_count
767: ,x_msg_data

Line 765: ,'OKL_API.G_RET_STS_ERROR'

761: EXCEPTION
762: WHEN g_exception_halt_validation THEN
763: x_return_status := okl_api.handle_exceptions(l_api_name
764: ,g_pkg_name
765: ,'OKL_API.G_RET_STS_ERROR'
766: ,x_msg_count
767: ,x_msg_data
768: ,'_PVT');
769: WHEN okl_api.g_exception_error THEN

Line 769: WHEN okl_api.g_exception_error THEN

765: ,'OKL_API.G_RET_STS_ERROR'
766: ,x_msg_count
767: ,x_msg_data
768: ,'_PVT');
769: WHEN okl_api.g_exception_error THEN
770: x_return_status := okl_api.handle_exceptions(l_api_name
771: ,g_pkg_name
772: ,'OKL_API.G_RET_STS_ERROR'
773: ,x_msg_count

Line 770: x_return_status := okl_api.handle_exceptions(l_api_name

766: ,x_msg_count
767: ,x_msg_data
768: ,'_PVT');
769: WHEN okl_api.g_exception_error THEN
770: x_return_status := okl_api.handle_exceptions(l_api_name
771: ,g_pkg_name
772: ,'OKL_API.G_RET_STS_ERROR'
773: ,x_msg_count
774: ,x_msg_data

Line 772: ,'OKL_API.G_RET_STS_ERROR'

768: ,'_PVT');
769: WHEN okl_api.g_exception_error THEN
770: x_return_status := okl_api.handle_exceptions(l_api_name
771: ,g_pkg_name
772: ,'OKL_API.G_RET_STS_ERROR'
773: ,x_msg_count
774: ,x_msg_data
775: ,'_PVT');
776: WHEN okl_api.g_exception_unexpected_error THEN

Line 776: WHEN okl_api.g_exception_unexpected_error THEN

772: ,'OKL_API.G_RET_STS_ERROR'
773: ,x_msg_count
774: ,x_msg_data
775: ,'_PVT');
776: WHEN okl_api.g_exception_unexpected_error THEN
777: x_return_status := okl_api.handle_exceptions(l_api_name
778: ,g_pkg_name
779: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
780: ,x_msg_count

Line 777: x_return_status := okl_api.handle_exceptions(l_api_name

773: ,x_msg_count
774: ,x_msg_data
775: ,'_PVT');
776: WHEN okl_api.g_exception_unexpected_error THEN
777: x_return_status := okl_api.handle_exceptions(l_api_name
778: ,g_pkg_name
779: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
780: ,x_msg_count
781: ,x_msg_data

Line 779: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

775: ,'_PVT');
776: WHEN okl_api.g_exception_unexpected_error THEN
777: x_return_status := okl_api.handle_exceptions(l_api_name
778: ,g_pkg_name
779: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
780: ,x_msg_count
781: ,x_msg_data
782: ,'_PVT');
783: WHEN OTHERS THEN

Line 784: x_return_status := okl_api.handle_exceptions(l_api_name

780: ,x_msg_count
781: ,x_msg_data
782: ,'_PVT');
783: WHEN OTHERS THEN
784: x_return_status := okl_api.handle_exceptions(l_api_name
785: ,g_pkg_name
786: ,'OTHERS'
787: ,x_msg_count
788: ,x_msg_data

Line 804: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

800: ,x_msg_data OUT NOCOPY varchar2
801: ,p_eccv_rec IN okl_eccv_rec) IS
802: l_api_version CONSTANT number := 1;
803: l_api_name CONSTANT varchar2(30) := 'V_lock_row';
804: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
805: l_eccb_rec okl_eccb_rec;
806: l_ecctl_rec okl_ecctl_rec;
807:
808: BEGIN

Line 809: l_return_status := okl_api.start_activity(l_api_name

805: l_eccb_rec okl_eccb_rec;
806: l_ecctl_rec okl_ecctl_rec;
807:
808: BEGIN
809: l_return_status := okl_api.start_activity(l_api_name
810: ,g_pkg_name
811: ,p_init_msg_list
812: ,l_api_version
813: ,p_api_version

Line 817: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

813: ,p_api_version
814: ,'_PVT'
815: ,x_return_status);
816:
817: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
818: RAISE okl_api.g_exception_unexpected_error;
819: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
820: RAISE okl_api.g_exception_error;
821: END IF;

Line 818: RAISE okl_api.g_exception_unexpected_error;

814: ,'_PVT'
815: ,x_return_status);
816:
817: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
818: RAISE okl_api.g_exception_unexpected_error;
819: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
820: RAISE okl_api.g_exception_error;
821: END IF;
822:

Line 819: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

815: ,x_return_status);
816:
817: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
818: RAISE okl_api.g_exception_unexpected_error;
819: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
820: RAISE okl_api.g_exception_error;
821: END IF;
822:
823: --------------------------------------

Line 820: RAISE okl_api.g_exception_error;

816:
817: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
818: RAISE okl_api.g_exception_unexpected_error;
819: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
820: RAISE okl_api.g_exception_error;
821: END IF;
822:
823: --------------------------------------
824: -- Move VIEW record to "Child" records

Line 840: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

836: ,x_msg_count
837: ,x_msg_data
838: ,l_eccb_rec);
839:
840: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
841: RAISE okl_api.g_exception_unexpected_error;
842: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
843: RAISE okl_api.g_exception_error;
844: END IF;

Line 841: RAISE okl_api.g_exception_unexpected_error;

837: ,x_msg_data
838: ,l_eccb_rec);
839:
840: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
841: RAISE okl_api.g_exception_unexpected_error;
842: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
843: RAISE okl_api.g_exception_error;
844: END IF;
845: lock_row(p_init_msg_list

Line 842: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

838: ,l_eccb_rec);
839:
840: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
841: RAISE okl_api.g_exception_unexpected_error;
842: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
843: RAISE okl_api.g_exception_error;
844: END IF;
845: lock_row(p_init_msg_list
846: ,x_return_status

Line 843: RAISE okl_api.g_exception_error;

839:
840: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
841: RAISE okl_api.g_exception_unexpected_error;
842: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
843: RAISE okl_api.g_exception_error;
844: END IF;
845: lock_row(p_init_msg_list
846: ,x_return_status
847: ,x_msg_count

Line 851: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

847: ,x_msg_count
848: ,x_msg_data
849: ,l_ecctl_rec);
850:
851: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
852: RAISE okl_api.g_exception_unexpected_error;
853: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
854: RAISE okl_api.g_exception_error;
855: END IF;

Line 852: RAISE okl_api.g_exception_unexpected_error;

848: ,x_msg_data
849: ,l_ecctl_rec);
850:
851: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
852: RAISE okl_api.g_exception_unexpected_error;
853: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
854: RAISE okl_api.g_exception_error;
855: END IF;
856: okl_api.end_activity(x_msg_count, x_msg_data);

Line 853: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

849: ,l_ecctl_rec);
850:
851: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
852: RAISE okl_api.g_exception_unexpected_error;
853: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
854: RAISE okl_api.g_exception_error;
855: END IF;
856: okl_api.end_activity(x_msg_count, x_msg_data);
857: EXCEPTION

Line 854: RAISE okl_api.g_exception_error;

850:
851: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
852: RAISE okl_api.g_exception_unexpected_error;
853: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
854: RAISE okl_api.g_exception_error;
855: END IF;
856: okl_api.end_activity(x_msg_count, x_msg_data);
857: EXCEPTION
858: WHEN g_exception_halt_validation THEN

Line 856: okl_api.end_activity(x_msg_count, x_msg_data);

852: RAISE okl_api.g_exception_unexpected_error;
853: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
854: RAISE okl_api.g_exception_error;
855: END IF;
856: okl_api.end_activity(x_msg_count, x_msg_data);
857: EXCEPTION
858: WHEN g_exception_halt_validation THEN
859: x_return_status := okl_api.handle_exceptions(l_api_name
860: ,g_pkg_name

Line 859: x_return_status := okl_api.handle_exceptions(l_api_name

855: END IF;
856: okl_api.end_activity(x_msg_count, x_msg_data);
857: EXCEPTION
858: WHEN g_exception_halt_validation THEN
859: x_return_status := okl_api.handle_exceptions(l_api_name
860: ,g_pkg_name
861: ,'OKL_API.G_RET_STS_ERROR'
862: ,x_msg_count
863: ,x_msg_data

Line 861: ,'OKL_API.G_RET_STS_ERROR'

857: EXCEPTION
858: WHEN g_exception_halt_validation THEN
859: x_return_status := okl_api.handle_exceptions(l_api_name
860: ,g_pkg_name
861: ,'OKL_API.G_RET_STS_ERROR'
862: ,x_msg_count
863: ,x_msg_data
864: ,'_PVT');
865: WHEN okl_api.g_exception_error THEN

Line 865: WHEN okl_api.g_exception_error THEN

861: ,'OKL_API.G_RET_STS_ERROR'
862: ,x_msg_count
863: ,x_msg_data
864: ,'_PVT');
865: WHEN okl_api.g_exception_error THEN
866: x_return_status := okl_api.handle_exceptions(l_api_name
867: ,g_pkg_name
868: ,'OKL_API.G_RET_STS_ERROR'
869: ,x_msg_count

Line 866: x_return_status := okl_api.handle_exceptions(l_api_name

862: ,x_msg_count
863: ,x_msg_data
864: ,'_PVT');
865: WHEN okl_api.g_exception_error THEN
866: x_return_status := okl_api.handle_exceptions(l_api_name
867: ,g_pkg_name
868: ,'OKL_API.G_RET_STS_ERROR'
869: ,x_msg_count
870: ,x_msg_data

Line 868: ,'OKL_API.G_RET_STS_ERROR'

864: ,'_PVT');
865: WHEN okl_api.g_exception_error THEN
866: x_return_status := okl_api.handle_exceptions(l_api_name
867: ,g_pkg_name
868: ,'OKL_API.G_RET_STS_ERROR'
869: ,x_msg_count
870: ,x_msg_data
871: ,'_PVT');
872: WHEN okl_api.g_exception_unexpected_error THEN

Line 872: WHEN okl_api.g_exception_unexpected_error THEN

868: ,'OKL_API.G_RET_STS_ERROR'
869: ,x_msg_count
870: ,x_msg_data
871: ,'_PVT');
872: WHEN okl_api.g_exception_unexpected_error THEN
873: x_return_status := okl_api.handle_exceptions(l_api_name
874: ,g_pkg_name
875: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
876: ,x_msg_count

Line 873: x_return_status := okl_api.handle_exceptions(l_api_name

869: ,x_msg_count
870: ,x_msg_data
871: ,'_PVT');
872: WHEN okl_api.g_exception_unexpected_error THEN
873: x_return_status := okl_api.handle_exceptions(l_api_name
874: ,g_pkg_name
875: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
876: ,x_msg_count
877: ,x_msg_data

Line 875: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

871: ,'_PVT');
872: WHEN okl_api.g_exception_unexpected_error THEN
873: x_return_status := okl_api.handle_exceptions(l_api_name
874: ,g_pkg_name
875: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
876: ,x_msg_count
877: ,x_msg_data
878: ,'_PVT');
879: WHEN OTHERS THEN

Line 880: x_return_status := okl_api.handle_exceptions(l_api_name

876: ,x_msg_count
877: ,x_msg_data
878: ,'_PVT');
879: WHEN OTHERS THEN
880: x_return_status := okl_api.handle_exceptions(l_api_name
881: ,g_pkg_name
882: ,'OTHERS'
883: ,x_msg_count
884: ,x_msg_data

Line 900: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

896: ,x_msg_data OUT NOCOPY varchar2
897: ,p_eccv_tbl IN okl_eccv_tbl) IS
898: l_api_version CONSTANT number := 1;
899: l_api_name CONSTANT varchar2(30) := 'V_tbl_lock_row';
900: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
901:
902: -- Begin Post-Generation Change
903: -- overall error status
904:

Line 905: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;

901:
902: -- Begin Post-Generation Change
903: -- overall error status
904:
905: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;
906:
907: -- End Post-Generation Change
908:
909: i number := 0;

Line 912: okl_api.init_msg_list(p_init_msg_list);

908:
909: i number := 0;
910:
911: BEGIN
912: okl_api.init_msg_list(p_init_msg_list);
913:
914: -- Make sure PL/SQL table has records in it before passing
915:
916: IF (p_eccv_tbl.COUNT > 0) THEN

Line 921: ,p_init_msg_list => okl_api.g_false

917: i := p_eccv_tbl.FIRST;
918:
919: LOOP
920: lock_row(p_api_version => p_api_version
921: ,p_init_msg_list => okl_api.g_false
922: ,x_return_status => x_return_status
923: ,x_msg_count => x_msg_count
924: ,x_msg_data => x_msg_data
925: ,p_eccv_rec => p_eccv_tbl(i));

Line 930: IF x_return_status <> okl_api.g_ret_sts_success THEN

926:
927: -- Begin Post-Generation Change
928: -- store the highest degree of error
929:
930: IF x_return_status <> okl_api.g_ret_sts_success THEN
931: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
932: l_overall_status := x_return_status;
933: END IF;
934: END IF;

Line 931: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN

927: -- Begin Post-Generation Change
928: -- store the highest degree of error
929:
930: IF x_return_status <> okl_api.g_ret_sts_success THEN
931: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
932: l_overall_status := x_return_status;
933: END IF;
934: END IF;
935:

Line 953: x_return_status := okl_api.handle_exceptions(l_api_name

949: END IF;
950:
951: EXCEPTION
952: WHEN g_exception_halt_validation THEN
953: x_return_status := okl_api.handle_exceptions(l_api_name
954: ,g_pkg_name
955: ,'OKL_API.G_RET_STS_ERROR'
956: ,x_msg_count
957: ,x_msg_data

Line 955: ,'OKL_API.G_RET_STS_ERROR'

951: EXCEPTION
952: WHEN g_exception_halt_validation THEN
953: x_return_status := okl_api.handle_exceptions(l_api_name
954: ,g_pkg_name
955: ,'OKL_API.G_RET_STS_ERROR'
956: ,x_msg_count
957: ,x_msg_data
958: ,'_PVT');
959: WHEN okl_api.g_exception_error THEN

Line 959: WHEN okl_api.g_exception_error THEN

955: ,'OKL_API.G_RET_STS_ERROR'
956: ,x_msg_count
957: ,x_msg_data
958: ,'_PVT');
959: WHEN okl_api.g_exception_error THEN
960: x_return_status := okl_api.handle_exceptions(l_api_name
961: ,g_pkg_name
962: ,'OKL_API.G_RET_STS_ERROR'
963: ,x_msg_count

Line 960: x_return_status := okl_api.handle_exceptions(l_api_name

956: ,x_msg_count
957: ,x_msg_data
958: ,'_PVT');
959: WHEN okl_api.g_exception_error THEN
960: x_return_status := okl_api.handle_exceptions(l_api_name
961: ,g_pkg_name
962: ,'OKL_API.G_RET_STS_ERROR'
963: ,x_msg_count
964: ,x_msg_data

Line 962: ,'OKL_API.G_RET_STS_ERROR'

958: ,'_PVT');
959: WHEN okl_api.g_exception_error THEN
960: x_return_status := okl_api.handle_exceptions(l_api_name
961: ,g_pkg_name
962: ,'OKL_API.G_RET_STS_ERROR'
963: ,x_msg_count
964: ,x_msg_data
965: ,'_PVT');
966: WHEN okl_api.g_exception_unexpected_error THEN

Line 966: WHEN okl_api.g_exception_unexpected_error THEN

962: ,'OKL_API.G_RET_STS_ERROR'
963: ,x_msg_count
964: ,x_msg_data
965: ,'_PVT');
966: WHEN okl_api.g_exception_unexpected_error THEN
967: x_return_status := okl_api.handle_exceptions(l_api_name
968: ,g_pkg_name
969: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
970: ,x_msg_count

Line 967: x_return_status := okl_api.handle_exceptions(l_api_name

963: ,x_msg_count
964: ,x_msg_data
965: ,'_PVT');
966: WHEN okl_api.g_exception_unexpected_error THEN
967: x_return_status := okl_api.handle_exceptions(l_api_name
968: ,g_pkg_name
969: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
970: ,x_msg_count
971: ,x_msg_data

Line 969: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

965: ,'_PVT');
966: WHEN okl_api.g_exception_unexpected_error THEN
967: x_return_status := okl_api.handle_exceptions(l_api_name
968: ,g_pkg_name
969: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
970: ,x_msg_count
971: ,x_msg_data
972: ,'_PVT');
973: WHEN OTHERS THEN

Line 974: x_return_status := okl_api.handle_exceptions(l_api_name

970: ,x_msg_count
971: ,x_msg_data
972: ,'_PVT');
973: WHEN OTHERS THEN
974: x_return_status := okl_api.handle_exceptions(l_api_name
975: ,g_pkg_name
976: ,'OTHERS'
977: ,x_msg_count
978: ,x_msg_data

Line 1174: IF (l_eccv_rec.crit_cat_def_id = okl_api.g_miss_num) THEN

1170: l_eccv_rec okl_eccv_rec := p_eccv_rec;
1171:
1172: BEGIN
1173:
1174: IF (l_eccv_rec.crit_cat_def_id = okl_api.g_miss_num) THEN
1175: l_eccv_rec.crit_cat_def_id := NULL;
1176: END IF;
1177:
1178: IF (l_eccv_rec.object_version_number = okl_api.g_miss_num) THEN

Line 1178: IF (l_eccv_rec.object_version_number = okl_api.g_miss_num) THEN

1174: IF (l_eccv_rec.crit_cat_def_id = okl_api.g_miss_num) THEN
1175: l_eccv_rec.crit_cat_def_id := NULL;
1176: END IF;
1177:
1178: IF (l_eccv_rec.object_version_number = okl_api.g_miss_num) THEN
1179: l_eccv_rec.object_version_number := NULL;
1180: END IF;
1181:
1182: IF (l_eccv_rec.ecc_ac_flag = okl_api.g_miss_char) THEN

Line 1182: IF (l_eccv_rec.ecc_ac_flag = okl_api.g_miss_char) THEN

1178: IF (l_eccv_rec.object_version_number = okl_api.g_miss_num) THEN
1179: l_eccv_rec.object_version_number := NULL;
1180: END IF;
1181:
1182: IF (l_eccv_rec.ecc_ac_flag = okl_api.g_miss_char) THEN
1183: l_eccv_rec.ecc_ac_flag := NULL;
1184: END IF;
1185:
1186: IF (l_eccv_rec.orig_crit_cat_def_id = okl_api.g_miss_num) THEN

Line 1186: IF (l_eccv_rec.orig_crit_cat_def_id = okl_api.g_miss_num) THEN

1182: IF (l_eccv_rec.ecc_ac_flag = okl_api.g_miss_char) THEN
1183: l_eccv_rec.ecc_ac_flag := NULL;
1184: END IF;
1185:
1186: IF (l_eccv_rec.orig_crit_cat_def_id = okl_api.g_miss_num) THEN
1187: l_eccv_rec.orig_crit_cat_def_id := NULL;
1188: END IF;
1189:
1190: IF (l_eccv_rec.crit_cat_name = okl_api.g_miss_char) THEN

Line 1190: IF (l_eccv_rec.crit_cat_name = okl_api.g_miss_char) THEN

1186: IF (l_eccv_rec.orig_crit_cat_def_id = okl_api.g_miss_num) THEN
1187: l_eccv_rec.orig_crit_cat_def_id := NULL;
1188: END IF;
1189:
1190: IF (l_eccv_rec.crit_cat_name = okl_api.g_miss_char) THEN
1191: l_eccv_rec.crit_cat_name := NULL;
1192: END IF;
1193:
1194: IF (l_eccv_rec.crit_cat_desc = okl_api.g_miss_char) THEN

Line 1194: IF (l_eccv_rec.crit_cat_desc = okl_api.g_miss_char) THEN

1190: IF (l_eccv_rec.crit_cat_name = okl_api.g_miss_char) THEN
1191: l_eccv_rec.crit_cat_name := NULL;
1192: END IF;
1193:
1194: IF (l_eccv_rec.crit_cat_desc = okl_api.g_miss_char) THEN
1195: l_eccv_rec.crit_cat_desc := NULL;
1196: END IF;
1197:
1198: IF (l_eccv_rec.sfwt_flag = okl_api.g_miss_char) THEN

Line 1198: IF (l_eccv_rec.sfwt_flag = okl_api.g_miss_char) THEN

1194: IF (l_eccv_rec.crit_cat_desc = okl_api.g_miss_char) THEN
1195: l_eccv_rec.crit_cat_desc := NULL;
1196: END IF;
1197:
1198: IF (l_eccv_rec.sfwt_flag = okl_api.g_miss_char) THEN
1199: l_eccv_rec.sfwt_flag := NULL;
1200: END IF;
1201:
1202: IF (l_eccv_rec.value_type_code = okl_api.g_miss_char) THEN

Line 1202: IF (l_eccv_rec.value_type_code = okl_api.g_miss_char) THEN

1198: IF (l_eccv_rec.sfwt_flag = okl_api.g_miss_char) THEN
1199: l_eccv_rec.sfwt_flag := NULL;
1200: END IF;
1201:
1202: IF (l_eccv_rec.value_type_code = okl_api.g_miss_char) THEN
1203: l_eccv_rec.value_type_code := NULL;
1204: END IF;
1205:
1206: IF (l_eccv_rec.data_type_code = okl_api.g_miss_char) THEN

Line 1206: IF (l_eccv_rec.data_type_code = okl_api.g_miss_char) THEN

1202: IF (l_eccv_rec.value_type_code = okl_api.g_miss_char) THEN
1203: l_eccv_rec.value_type_code := NULL;
1204: END IF;
1205:
1206: IF (l_eccv_rec.data_type_code = okl_api.g_miss_char) THEN
1207: l_eccv_rec.data_type_code := NULL;
1208: END IF;
1209:
1210: IF (l_eccv_rec.enabled_yn = okl_api.g_miss_char) THEN

Line 1210: IF (l_eccv_rec.enabled_yn = okl_api.g_miss_char) THEN

1206: IF (l_eccv_rec.data_type_code = okl_api.g_miss_char) THEN
1207: l_eccv_rec.data_type_code := NULL;
1208: END IF;
1209:
1210: IF (l_eccv_rec.enabled_yn = okl_api.g_miss_char) THEN
1211: l_eccv_rec.enabled_yn := NULL;
1212: END IF;
1213:
1214: IF (l_eccv_rec.seeded_yn = okl_api.g_miss_char) THEN

Line 1214: IF (l_eccv_rec.seeded_yn = okl_api.g_miss_char) THEN

1210: IF (l_eccv_rec.enabled_yn = okl_api.g_miss_char) THEN
1211: l_eccv_rec.enabled_yn := NULL;
1212: END IF;
1213:
1214: IF (l_eccv_rec.seeded_yn = okl_api.g_miss_char) THEN
1215: l_eccv_rec.seeded_yn := NULL;
1216: END IF;
1217:
1218: IF (l_eccv_rec.function_id = okl_api.g_miss_num) THEN

Line 1218: IF (l_eccv_rec.function_id = okl_api.g_miss_num) THEN

1214: IF (l_eccv_rec.seeded_yn = okl_api.g_miss_char) THEN
1215: l_eccv_rec.seeded_yn := NULL;
1216: END IF;
1217:
1218: IF (l_eccv_rec.function_id = okl_api.g_miss_num) THEN
1219: l_eccv_rec.function_id := NULL;
1220: END IF;
1221:
1222: IF (l_eccv_rec.source_yn = okl_api.g_miss_char) THEN

Line 1222: IF (l_eccv_rec.source_yn = okl_api.g_miss_char) THEN

1218: IF (l_eccv_rec.function_id = okl_api.g_miss_num) THEN
1219: l_eccv_rec.function_id := NULL;
1220: END IF;
1221:
1222: IF (l_eccv_rec.source_yn = okl_api.g_miss_char) THEN
1223: l_eccv_rec.source_yn := NULL;
1224: END IF;
1225:
1226: IF (l_eccv_rec.sql_statement = okl_api.g_miss_char) THEN

Line 1226: IF (l_eccv_rec.sql_statement = okl_api.g_miss_char) THEN

1222: IF (l_eccv_rec.source_yn = okl_api.g_miss_char) THEN
1223: l_eccv_rec.source_yn := NULL;
1224: END IF;
1225:
1226: IF (l_eccv_rec.sql_statement = okl_api.g_miss_char) THEN
1227: l_eccv_rec.sql_statement := NULL;
1228: END IF;
1229:
1230: IF (l_eccv_rec.created_by = okl_api.g_miss_num) THEN

Line 1230: IF (l_eccv_rec.created_by = okl_api.g_miss_num) THEN

1226: IF (l_eccv_rec.sql_statement = okl_api.g_miss_char) THEN
1227: l_eccv_rec.sql_statement := NULL;
1228: END IF;
1229:
1230: IF (l_eccv_rec.created_by = okl_api.g_miss_num) THEN
1231: l_eccv_rec.created_by := NULL;
1232: END IF;
1233:
1234: IF (l_eccv_rec.creation_date = okl_api.g_miss_date) THEN

Line 1234: IF (l_eccv_rec.creation_date = okl_api.g_miss_date) THEN

1230: IF (l_eccv_rec.created_by = okl_api.g_miss_num) THEN
1231: l_eccv_rec.created_by := NULL;
1232: END IF;
1233:
1234: IF (l_eccv_rec.creation_date = okl_api.g_miss_date) THEN
1235: l_eccv_rec.creation_date := NULL;
1236: END IF;
1237:
1238: IF (l_eccv_rec.last_updated_by = okl_api.g_miss_num) THEN

Line 1238: IF (l_eccv_rec.last_updated_by = okl_api.g_miss_num) THEN

1234: IF (l_eccv_rec.creation_date = okl_api.g_miss_date) THEN
1235: l_eccv_rec.creation_date := NULL;
1236: END IF;
1237:
1238: IF (l_eccv_rec.last_updated_by = okl_api.g_miss_num) THEN
1239: l_eccv_rec.last_updated_by := NULL;
1240: END IF;
1241:
1242: IF (l_eccv_rec.last_update_date = okl_api.g_miss_date) THEN

Line 1242: IF (l_eccv_rec.last_update_date = okl_api.g_miss_date) THEN

1238: IF (l_eccv_rec.last_updated_by = okl_api.g_miss_num) THEN
1239: l_eccv_rec.last_updated_by := NULL;
1240: END IF;
1241:
1242: IF (l_eccv_rec.last_update_date = okl_api.g_miss_date) THEN
1243: l_eccv_rec.last_update_date := NULL;
1244: END IF;
1245:
1246: IF (l_eccv_rec.last_update_login = okl_api.g_miss_num) THEN

Line 1246: IF (l_eccv_rec.last_update_login = okl_api.g_miss_num) THEN

1242: IF (l_eccv_rec.last_update_date = okl_api.g_miss_date) THEN
1243: l_eccv_rec.last_update_date := NULL;
1244: END IF;
1245:
1246: IF (l_eccv_rec.last_update_login = okl_api.g_miss_num) THEN
1247: l_eccv_rec.last_update_login := NULL;
1248: END IF;
1249: RETURN(l_eccv_rec);
1250: END null_out_defaults;

Line 1263: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

1259: -----validate_attributes
1260: -------------------------------------------------------------------------------
1261:
1262: FUNCTION validate_attributes(p_eccv_rec IN okl_eccv_rec) RETURN varchar2 IS
1263: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1264: x_return_status varchar2(1) := okl_api.g_ret_sts_success;
1265: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_attributes';
1266:
1267: BEGIN

Line 1264: x_return_status varchar2(1) := okl_api.g_ret_sts_success;

1260: -------------------------------------------------------------------------------
1261:
1262: FUNCTION validate_attributes(p_eccv_rec IN okl_eccv_rec) RETURN varchar2 IS
1263: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1264: x_return_status varchar2(1) := okl_api.g_ret_sts_success;
1265: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_attributes';
1266:
1267: BEGIN
1268:

Line 1276: RAISE okl_api.g_exception_unexpected_error;

1272:
1273: l_return_status := validate_crit_cat_def_id(p_eccv_rec.crit_cat_def_id);
1274:
1275: IF (l_return_status = g_ret_sts_unexp_error) THEN
1276: RAISE okl_api.g_exception_unexpected_error;
1277: ELSIF (l_return_status = g_ret_sts_error) THEN
1278: RAISE okl_api.g_exception_error;
1279: END IF;
1280:

Line 1278: RAISE okl_api.g_exception_error;

1274:
1275: IF (l_return_status = g_ret_sts_unexp_error) THEN
1276: RAISE okl_api.g_exception_unexpected_error;
1277: ELSIF (l_return_status = g_ret_sts_error) THEN
1278: RAISE okl_api.g_exception_error;
1279: END IF;
1280:
1281: -- ***
1282: -- object_version_number

Line 1288: RAISE okl_api.g_exception_unexpected_error;

1284:
1285: l_return_status := validate_object_version_number(p_eccv_rec.object_version_number);
1286:
1287: IF (l_return_status = g_ret_sts_unexp_error) THEN
1288: RAISE okl_api.g_exception_unexpected_error;
1289: ELSIF (l_return_status = g_ret_sts_error) THEN
1290: RAISE okl_api.g_exception_error;
1291: END IF;
1292:

Line 1290: RAISE okl_api.g_exception_error;

1286:
1287: IF (l_return_status = g_ret_sts_unexp_error) THEN
1288: RAISE okl_api.g_exception_unexpected_error;
1289: ELSIF (l_return_status = g_ret_sts_error) THEN
1290: RAISE okl_api.g_exception_error;
1291: END IF;
1292:
1293: -- ***
1294: -- name

Line 1300: RAISE okl_api.g_exception_unexpected_error;

1296:
1297: l_return_status := validate_name(p_eccv_rec.crit_cat_name);
1298:
1299: IF (l_return_status = g_ret_sts_unexp_error) THEN
1300: RAISE okl_api.g_exception_unexpected_error;
1301: ELSIF (l_return_status = g_ret_sts_error) THEN
1302: RAISE okl_api.g_exception_error;
1303: END IF;
1304:

Line 1302: RAISE okl_api.g_exception_error;

1298:
1299: IF (l_return_status = g_ret_sts_unexp_error) THEN
1300: RAISE okl_api.g_exception_unexpected_error;
1301: ELSIF (l_return_status = g_ret_sts_error) THEN
1302: RAISE okl_api.g_exception_error;
1303: END IF;
1304:
1305: -- ***
1306: -- ECC_AC_FLAG

Line 1312: RAISE okl_api.g_exception_unexpected_error;

1308:
1309: l_return_status := validate_ecc_ac_flag(p_eccv_rec.ecc_ac_flag);
1310:
1311: IF (l_return_status = g_ret_sts_unexp_error) THEN
1312: RAISE okl_api.g_exception_unexpected_error;
1313: ELSIF (l_return_status = g_ret_sts_error) THEN
1314: RAISE okl_api.g_exception_error;
1315: END IF;
1316:

Line 1314: RAISE okl_api.g_exception_error;

1310:
1311: IF (l_return_status = g_ret_sts_unexp_error) THEN
1312: RAISE okl_api.g_exception_unexpected_error;
1313: ELSIF (l_return_status = g_ret_sts_error) THEN
1314: RAISE okl_api.g_exception_error;
1315: END IF;
1316:
1317: -- ***
1318: -- VALUE_TYPE_CODE

Line 1324: RAISE okl_api.g_exception_unexpected_error;

1320:
1321: l_return_status := validate_value_type_code(p_eccv_rec.value_type_code);
1322:
1323: IF (l_return_status = g_ret_sts_unexp_error) THEN
1324: RAISE okl_api.g_exception_unexpected_error;
1325: ELSIF (l_return_status = g_ret_sts_error) THEN
1326: RAISE okl_api.g_exception_error;
1327: END IF;
1328:

Line 1326: RAISE okl_api.g_exception_error;

1322:
1323: IF (l_return_status = g_ret_sts_unexp_error) THEN
1324: RAISE okl_api.g_exception_unexpected_error;
1325: ELSIF (l_return_status = g_ret_sts_error) THEN
1326: RAISE okl_api.g_exception_error;
1327: END IF;
1328:
1329: -- ***
1330: -- DATA_TYPE_CODE

Line 1336: RAISE okl_api.g_exception_unexpected_error;

1332:
1333: l_return_status := validate_data_type_code(p_eccv_rec.data_type_code);
1334:
1335: IF (l_return_status = g_ret_sts_unexp_error) THEN
1336: RAISE okl_api.g_exception_unexpected_error;
1337: ELSIF (l_return_status = g_ret_sts_error) THEN
1338: RAISE okl_api.g_exception_error;
1339: END IF;
1340:

Line 1338: RAISE okl_api.g_exception_error;

1334:
1335: IF (l_return_status = g_ret_sts_unexp_error) THEN
1336: RAISE okl_api.g_exception_unexpected_error;
1337: ELSIF (l_return_status = g_ret_sts_error) THEN
1338: RAISE okl_api.g_exception_error;
1339: END IF;
1340:
1341: -- ***
1342: -- seeded_yn

Line 1348: RAISE okl_api.g_exception_unexpected_error;

1344:
1345: l_return_status := validate_seeded_yn(p_eccv_rec.seeded_yn);
1346:
1347: IF (l_return_status = g_ret_sts_unexp_error) THEN
1348: RAISE okl_api.g_exception_unexpected_error;
1349: ELSIF (l_return_status = g_ret_sts_error) THEN
1350: RAISE okl_api.g_exception_error;
1351: END IF;
1352:

Line 1350: RAISE okl_api.g_exception_error;

1346:
1347: IF (l_return_status = g_ret_sts_unexp_error) THEN
1348: RAISE okl_api.g_exception_unexpected_error;
1349: ELSIF (l_return_status = g_ret_sts_error) THEN
1350: RAISE okl_api.g_exception_error;
1351: END IF;
1352:
1353: -- ***
1354: -- enabled_yn

Line 1360: RAISE okl_api.g_exception_unexpected_error;

1356:
1357: l_return_status := validate_enabled_yn(p_eccv_rec.enabled_yn);
1358:
1359: IF (l_return_status = g_ret_sts_unexp_error) THEN
1360: RAISE okl_api.g_exception_unexpected_error;
1361: ELSIF (l_return_status = g_ret_sts_error) THEN
1362: RAISE okl_api.g_exception_error;
1363: END IF;
1364:

Line 1362: RAISE okl_api.g_exception_error;

1358:
1359: IF (l_return_status = g_ret_sts_unexp_error) THEN
1360: RAISE okl_api.g_exception_unexpected_error;
1361: ELSIF (l_return_status = g_ret_sts_error) THEN
1362: RAISE okl_api.g_exception_error;
1363: END IF;
1364:
1365: -- ***
1366: -- source_yn

Line 1372: RAISE okl_api.g_exception_unexpected_error;

1368:
1369: l_return_status := validate_source_yn(p_eccv_rec.source_yn);
1370:
1371: IF (l_return_status = g_ret_sts_unexp_error) THEN
1372: RAISE okl_api.g_exception_unexpected_error;
1373: ELSIF (l_return_status = g_ret_sts_error) THEN
1374: RAISE okl_api.g_exception_error;
1375: END IF;
1376: RETURN(x_return_status);

Line 1374: RAISE okl_api.g_exception_error;

1370:
1371: IF (l_return_status = g_ret_sts_unexp_error) THEN
1372: RAISE okl_api.g_exception_unexpected_error;
1373: ELSIF (l_return_status = g_ret_sts_error) THEN
1374: RAISE okl_api.g_exception_error;
1375: END IF;
1376: RETURN(x_return_status);
1377: EXCEPTION
1378: WHEN okl_api.g_exception_error THEN

Line 1378: WHEN okl_api.g_exception_error THEN

1374: RAISE okl_api.g_exception_error;
1375: END IF;
1376: RETURN(x_return_status);
1377: EXCEPTION
1378: WHEN okl_api.g_exception_error THEN
1379: RETURN g_ret_sts_error;
1380: WHEN okl_api.g_exception_unexpected_error THEN
1381: RETURN g_ret_sts_unexp_error;
1382: WHEN OTHERS THEN

Line 1380: WHEN okl_api.g_exception_unexpected_error THEN

1376: RETURN(x_return_status);
1377: EXCEPTION
1378: WHEN okl_api.g_exception_error THEN
1379: RETURN g_ret_sts_error;
1380: WHEN okl_api.g_exception_unexpected_error THEN
1381: RETURN g_ret_sts_unexp_error;
1382: WHEN OTHERS THEN
1383: okl_api.set_message(p_app_name => g_app_name
1384: ,p_msg_name => g_db_error

Line 1383: okl_api.set_message(p_app_name => g_app_name

1379: RETURN g_ret_sts_error;
1380: WHEN okl_api.g_exception_unexpected_error THEN
1381: RETURN g_ret_sts_unexp_error;
1382: WHEN OTHERS THEN
1383: okl_api.set_message(p_app_name => g_app_name
1384: ,p_msg_name => g_db_error
1385: ,p_token1 => g_prog_name_token
1386: ,p_token1_value => l_api_name
1387: ,p_token2 => 'SQLCODE'

Line 1395: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

1391: RETURN g_ret_sts_unexp_error;
1392: END validate_attributes;
1393:
1394: FUNCTION validate_record(p_eccv_rec IN okl_eccv_rec) RETURN varchar2 IS
1395: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1396: x_return_status varchar2(1) := okl_api.g_ret_sts_success;
1397: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_attributes';
1398:
1399: BEGIN

Line 1396: x_return_status varchar2(1) := okl_api.g_ret_sts_success;

1392: END validate_attributes;
1393:
1394: FUNCTION validate_record(p_eccv_rec IN okl_eccv_rec) RETURN varchar2 IS
1395: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1396: x_return_status varchar2(1) := okl_api.g_ret_sts_success;
1397: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_attributes';
1398:
1399: BEGIN
1400: RETURN(x_return_status);

Line 1402: WHEN okl_api.g_exception_error THEN

1398:
1399: BEGIN
1400: RETURN(x_return_status);
1401: EXCEPTION
1402: WHEN okl_api.g_exception_error THEN
1403: RETURN g_ret_sts_error;
1404: WHEN okl_api.g_exception_unexpected_error THEN
1405: RETURN g_ret_sts_unexp_error;
1406: WHEN OTHERS THEN

Line 1404: WHEN okl_api.g_exception_unexpected_error THEN

1400: RETURN(x_return_status);
1401: EXCEPTION
1402: WHEN okl_api.g_exception_error THEN
1403: RETURN g_ret_sts_error;
1404: WHEN okl_api.g_exception_unexpected_error THEN
1405: RETURN g_ret_sts_unexp_error;
1406: WHEN OTHERS THEN
1407: okl_api.set_message(p_app_name => g_app_name
1408: ,p_msg_name => g_db_error

Line 1407: okl_api.set_message(p_app_name => g_app_name

1403: RETURN g_ret_sts_error;
1404: WHEN okl_api.g_exception_unexpected_error THEN
1405: RETURN g_ret_sts_unexp_error;
1406: WHEN OTHERS THEN
1407: okl_api.set_message(p_app_name => g_app_name
1408: ,p_msg_name => g_db_error
1409: ,p_token1 => g_prog_name_token
1410: ,p_token1_value => l_api_name
1411: ,p_token2 => g_sqlcode_token

Line 1423: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

1419: -- Procedure insert_row_b
1420: --------------------------------------------------------------------------------
1421:
1422: PROCEDURE insert_row(p_api_version IN number
1423: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
1424: ,x_return_status OUT NOCOPY varchar2
1425: ,x_msg_count OUT NOCOPY number
1426: ,x_msg_data OUT NOCOPY varchar2
1427: ,p_eccb_rec IN okl_eccb_rec

Line 1431: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

1427: ,p_eccb_rec IN okl_eccb_rec
1428: ,x_eccb_rec OUT NOCOPY okl_eccb_rec) IS
1429: l_api_version CONSTANT number := 1;
1430: l_api_name CONSTANT varchar2(30) := 'insert_row_b';
1431: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1432: l_eccb_rec okl_eccb_rec := p_eccb_rec;
1433: temp number;
1434:
1435: FUNCTION set_attributes(p_eccb_rec IN okl_eccb_rec

Line 1437: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

1433: temp number;
1434:
1435: FUNCTION set_attributes(p_eccb_rec IN okl_eccb_rec
1436: ,x_eccb_rec OUT NOCOPY okl_eccb_rec) RETURN varchar2 IS
1437: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1438:
1439: BEGIN
1440: x_eccb_rec := p_eccb_rec;
1441: RETURN(l_return_status);

Line 1445: l_return_status := okl_api.start_activity(l_api_name

1441: RETURN(l_return_status);
1442: END set_attributes;
1443:
1444: BEGIN
1445: l_return_status := okl_api.start_activity(l_api_name
1446: ,g_pkg_name
1447: ,p_init_msg_list
1448: ,l_api_version
1449: ,p_api_version

Line 1453: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1449: ,p_api_version
1450: ,'_PVT'
1451: ,x_return_status);
1452:
1453: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1454: RAISE okl_api.g_exception_unexpected_error;
1455: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1456: RAISE okl_api.g_exception_error;
1457: END IF;

Line 1454: RAISE okl_api.g_exception_unexpected_error;

1450: ,'_PVT'
1451: ,x_return_status);
1452:
1453: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1454: RAISE okl_api.g_exception_unexpected_error;
1455: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1456: RAISE okl_api.g_exception_error;
1457: END IF;
1458:

Line 1455: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1451: ,x_return_status);
1452:
1453: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1454: RAISE okl_api.g_exception_unexpected_error;
1455: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1456: RAISE okl_api.g_exception_error;
1457: END IF;
1458:
1459: --Setting Item Attributes

Line 1456: RAISE okl_api.g_exception_error;

1452:
1453: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1454: RAISE okl_api.g_exception_unexpected_error;
1455: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1456: RAISE okl_api.g_exception_error;
1457: END IF;
1458:
1459: --Setting Item Attributes
1460:

Line 1463: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1459: --Setting Item Attributes
1460:
1461: l_return_status := set_attributes(p_eccb_rec, l_eccb_rec);
1462:
1463: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1464: RAISE okl_api.g_exception_unexpected_error;
1465: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1466: RAISE okl_api.g_exception_error;
1467: END IF;

Line 1464: RAISE okl_api.g_exception_unexpected_error;

1460:
1461: l_return_status := set_attributes(p_eccb_rec, l_eccb_rec);
1462:
1463: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1464: RAISE okl_api.g_exception_unexpected_error;
1465: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1466: RAISE okl_api.g_exception_error;
1467: END IF;
1468:

Line 1465: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1461: l_return_status := set_attributes(p_eccb_rec, l_eccb_rec);
1462:
1463: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1464: RAISE okl_api.g_exception_unexpected_error;
1465: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1466: RAISE okl_api.g_exception_error;
1467: END IF;
1468:
1469: INSERT INTO okl_fe_crit_cat_def_b

Line 1466: RAISE okl_api.g_exception_error;

1462:
1463: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1464: RAISE okl_api.g_exception_unexpected_error;
1465: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1466: RAISE okl_api.g_exception_error;
1467: END IF;
1468:
1469: INSERT INTO okl_fe_crit_cat_def_b
1470: (crit_cat_def_id

Line 1509: okl_api.end_activity(x_msg_count, x_msg_data);

1505: --Set OUT Values
1506:
1507: x_eccb_rec := l_eccb_rec;
1508: x_return_status := l_return_status;
1509: okl_api.end_activity(x_msg_count, x_msg_data);
1510: EXCEPTION
1511: WHEN g_exception_halt_validation THEN
1512:
1513: -- No action necessary. Validation can continue to next attribute/column

Line 1516: WHEN okl_api.g_exception_error THEN

1512:
1513: -- No action necessary. Validation can continue to next attribute/column
1514:
1515: NULL;
1516: WHEN okl_api.g_exception_error THEN
1517: x_return_status := okl_api.handle_exceptions(l_api_name
1518: ,g_pkg_name
1519: ,'OKL_API.G_RET_STS_ERROR'
1520: ,x_msg_count

Line 1517: x_return_status := okl_api.handle_exceptions(l_api_name

1513: -- No action necessary. Validation can continue to next attribute/column
1514:
1515: NULL;
1516: WHEN okl_api.g_exception_error THEN
1517: x_return_status := okl_api.handle_exceptions(l_api_name
1518: ,g_pkg_name
1519: ,'OKL_API.G_RET_STS_ERROR'
1520: ,x_msg_count
1521: ,x_msg_data

Line 1519: ,'OKL_API.G_RET_STS_ERROR'

1515: NULL;
1516: WHEN okl_api.g_exception_error THEN
1517: x_return_status := okl_api.handle_exceptions(l_api_name
1518: ,g_pkg_name
1519: ,'OKL_API.G_RET_STS_ERROR'
1520: ,x_msg_count
1521: ,x_msg_data
1522: ,'_PVT');
1523: WHEN okl_api.g_exception_unexpected_error THEN

Line 1523: WHEN okl_api.g_exception_unexpected_error THEN

1519: ,'OKL_API.G_RET_STS_ERROR'
1520: ,x_msg_count
1521: ,x_msg_data
1522: ,'_PVT');
1523: WHEN okl_api.g_exception_unexpected_error THEN
1524: x_return_status := okl_api.handle_exceptions(l_api_name
1525: ,g_pkg_name
1526: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1527: ,x_msg_count

Line 1524: x_return_status := okl_api.handle_exceptions(l_api_name

1520: ,x_msg_count
1521: ,x_msg_data
1522: ,'_PVT');
1523: WHEN okl_api.g_exception_unexpected_error THEN
1524: x_return_status := okl_api.handle_exceptions(l_api_name
1525: ,g_pkg_name
1526: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1527: ,x_msg_count
1528: ,x_msg_data

Line 1526: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1522: ,'_PVT');
1523: WHEN okl_api.g_exception_unexpected_error THEN
1524: x_return_status := okl_api.handle_exceptions(l_api_name
1525: ,g_pkg_name
1526: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1527: ,x_msg_count
1528: ,x_msg_data
1529: ,'_PVT');
1530: WHEN OTHERS THEN

Line 1531: x_return_status := okl_api.handle_exceptions(l_api_name

1527: ,x_msg_count
1528: ,x_msg_data
1529: ,'_PVT');
1530: WHEN OTHERS THEN
1531: x_return_status := okl_api.handle_exceptions(l_api_name
1532: ,g_pkg_name
1533: ,'OTHERS'
1534: ,x_msg_count
1535: ,x_msg_data

Line 1544: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

1540: -- Procedure insert_row_tl
1541: --------------------------------------------------------------------------------
1542:
1543: PROCEDURE insert_row(p_api_version IN number
1544: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
1545: ,x_return_status OUT NOCOPY varchar2
1546: ,x_msg_count OUT NOCOPY number
1547: ,x_msg_data OUT NOCOPY varchar2
1548: ,p_ecctl_rec IN okl_ecctl_rec

Line 1552: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

1548: ,p_ecctl_rec IN okl_ecctl_rec
1549: ,x_ecctl_rec OUT NOCOPY okl_ecctl_rec) IS
1550: l_api_version CONSTANT number := 1;
1551: l_api_name CONSTANT varchar2(30) := 'insert_row_tl';
1552: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1553: l_ecctl_rec okl_ecctl_rec := p_ecctl_rec;
1554:
1555: CURSOR get_languages IS
1556: SELECT *

Line 1562: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

1558: WHERE installed_flag IN('I', 'B');
1559:
1560: FUNCTION set_attributes(p_ecctl_rec IN okl_ecctl_rec
1561: ,x_ecctl_rec OUT NOCOPY okl_ecctl_rec) RETURN varchar2 IS
1562: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1563:
1564: BEGIN
1565: x_ecctl_rec := p_ecctl_rec;
1566: x_ecctl_rec.language := userenv('LANG');

Line 1572: l_return_status := okl_api.start_activity(l_api_name

1568: RETURN(l_return_status);
1569: END set_attributes;
1570:
1571: BEGIN
1572: l_return_status := okl_api.start_activity(l_api_name
1573: ,g_pkg_name
1574: ,p_init_msg_list
1575: ,l_api_version
1576: ,p_api_version

Line 1580: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1576: ,p_api_version
1577: ,'_PVT'
1578: ,x_return_status);
1579:
1580: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1581: RAISE okl_api.g_exception_unexpected_error;
1582: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1583: RAISE okl_api.g_exception_error;
1584: END IF;

Line 1581: RAISE okl_api.g_exception_unexpected_error;

1577: ,'_PVT'
1578: ,x_return_status);
1579:
1580: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1581: RAISE okl_api.g_exception_unexpected_error;
1582: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1583: RAISE okl_api.g_exception_error;
1584: END IF;
1585:

Line 1582: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1578: ,x_return_status);
1579:
1580: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1581: RAISE okl_api.g_exception_unexpected_error;
1582: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1583: RAISE okl_api.g_exception_error;
1584: END IF;
1585:
1586: --Setting Item Attributes

Line 1583: RAISE okl_api.g_exception_error;

1579:
1580: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1581: RAISE okl_api.g_exception_unexpected_error;
1582: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1583: RAISE okl_api.g_exception_error;
1584: END IF;
1585:
1586: --Setting Item Attributes
1587:

Line 1590: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1586: --Setting Item Attributes
1587:
1588: l_return_status := set_attributes(p_ecctl_rec, l_ecctl_rec);
1589:
1590: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1591: RAISE okl_api.g_exception_unexpected_error;
1592: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1593: RAISE okl_api.g_exception_error;
1594: END IF;

Line 1591: RAISE okl_api.g_exception_unexpected_error;

1587:
1588: l_return_status := set_attributes(p_ecctl_rec, l_ecctl_rec);
1589:
1590: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1591: RAISE okl_api.g_exception_unexpected_error;
1592: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1593: RAISE okl_api.g_exception_error;
1594: END IF;
1595:

Line 1592: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1588: l_return_status := set_attributes(p_ecctl_rec, l_ecctl_rec);
1589:
1590: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1591: RAISE okl_api.g_exception_unexpected_error;
1592: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1593: RAISE okl_api.g_exception_error;
1594: END IF;
1595:
1596: FOR l_lang_rec IN get_languages LOOP

Line 1593: RAISE okl_api.g_exception_error;

1589:
1590: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1591: RAISE okl_api.g_exception_unexpected_error;
1592: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1593: RAISE okl_api.g_exception_error;
1594: END IF;
1595:
1596: FOR l_lang_rec IN get_languages LOOP
1597: l_ecctl_rec.language := l_lang_rec.language_code;

Line 1633: okl_api.end_activity(x_msg_count, x_msg_data);

1629: --Set OUT Values
1630:
1631: x_ecctl_rec := l_ecctl_rec;
1632: x_return_status := l_return_status;
1633: okl_api.end_activity(x_msg_count, x_msg_data);
1634: EXCEPTION
1635: WHEN g_exception_halt_validation THEN
1636:
1637: -- No action necessary. Validation can continue to next attribute/column

Line 1640: WHEN okl_api.g_exception_error THEN

1636:
1637: -- No action necessary. Validation can continue to next attribute/column
1638:
1639: NULL;
1640: WHEN okl_api.g_exception_error THEN
1641: x_return_status := okl_api.handle_exceptions(l_api_name
1642: ,g_pkg_name
1643: ,'OKL_API.G_RET_STS_ERROR'
1644: ,x_msg_count

Line 1641: x_return_status := okl_api.handle_exceptions(l_api_name

1637: -- No action necessary. Validation can continue to next attribute/column
1638:
1639: NULL;
1640: WHEN okl_api.g_exception_error THEN
1641: x_return_status := okl_api.handle_exceptions(l_api_name
1642: ,g_pkg_name
1643: ,'OKL_API.G_RET_STS_ERROR'
1644: ,x_msg_count
1645: ,x_msg_data

Line 1643: ,'OKL_API.G_RET_STS_ERROR'

1639: NULL;
1640: WHEN okl_api.g_exception_error THEN
1641: x_return_status := okl_api.handle_exceptions(l_api_name
1642: ,g_pkg_name
1643: ,'OKL_API.G_RET_STS_ERROR'
1644: ,x_msg_count
1645: ,x_msg_data
1646: ,'_PVT');
1647: WHEN okl_api.g_exception_unexpected_error THEN

Line 1647: WHEN okl_api.g_exception_unexpected_error THEN

1643: ,'OKL_API.G_RET_STS_ERROR'
1644: ,x_msg_count
1645: ,x_msg_data
1646: ,'_PVT');
1647: WHEN okl_api.g_exception_unexpected_error THEN
1648: x_return_status := okl_api.handle_exceptions(l_api_name
1649: ,g_pkg_name
1650: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1651: ,x_msg_count

Line 1648: x_return_status := okl_api.handle_exceptions(l_api_name

1644: ,x_msg_count
1645: ,x_msg_data
1646: ,'_PVT');
1647: WHEN okl_api.g_exception_unexpected_error THEN
1648: x_return_status := okl_api.handle_exceptions(l_api_name
1649: ,g_pkg_name
1650: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1651: ,x_msg_count
1652: ,x_msg_data

Line 1650: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1646: ,'_PVT');
1647: WHEN okl_api.g_exception_unexpected_error THEN
1648: x_return_status := okl_api.handle_exceptions(l_api_name
1649: ,g_pkg_name
1650: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1651: ,x_msg_count
1652: ,x_msg_data
1653: ,'_PVT');
1654: WHEN OTHERS THEN

Line 1655: x_return_status := okl_api.handle_exceptions(l_api_name

1651: ,x_msg_count
1652: ,x_msg_data
1653: ,'_PVT');
1654: WHEN OTHERS THEN
1655: x_return_status := okl_api.handle_exceptions(l_api_name
1656: ,g_pkg_name
1657: ,'OTHERS'
1658: ,x_msg_count
1659: ,x_msg_data

Line 1668: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

1664: -- Procedure insert_row_v
1665: --------------------------------------------------------------------------------
1666:
1667: PROCEDURE insert_row(p_api_version IN number
1668: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
1669: ,x_return_status OUT NOCOPY varchar2
1670: ,x_msg_count OUT NOCOPY number
1671: ,x_msg_data OUT NOCOPY varchar2
1672: ,p_eccv_rec IN okl_eccv_rec

Line 1676: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

1672: ,p_eccv_rec IN okl_eccv_rec
1673: ,x_eccv_rec OUT NOCOPY okl_eccv_rec) IS
1674: l_api_version CONSTANT number := 1;
1675: l_api_name CONSTANT varchar2(30) := 'v_insert_row';
1676: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1677: l_eccv_rec okl_eccv_rec;
1678: l_def_eccv_rec okl_eccv_rec;
1679: l_eccb_rec okl_eccb_rec;
1680: lx_eccb_rec okl_eccb_rec;

Line 1698: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

1694: END fill_who_columns;
1695:
1696: FUNCTION set_attributes(p_eccv_rec IN okl_eccv_rec
1697: ,x_eccv_rec OUT NOCOPY okl_eccv_rec) RETURN varchar2 IS
1698: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1699:
1700: BEGIN
1701: x_eccv_rec := p_eccv_rec;
1702: x_eccv_rec.crit_cat_name := upper(p_eccv_rec.crit_cat_name);

Line 1709: l_return_status := okl_api.start_activity(l_api_name

1705: RETURN(l_return_status);
1706: END set_attributes;
1707:
1708: BEGIN
1709: l_return_status := okl_api.start_activity(l_api_name
1710: ,g_pkg_name
1711: ,p_init_msg_list
1712: ,l_api_version
1713: ,p_api_version

Line 1717: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1713: ,p_api_version
1714: ,'_PVT'
1715: ,x_return_status);
1716:
1717: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1718: RAISE okl_api.g_exception_unexpected_error;
1719: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1720: RAISE okl_api.g_exception_error;
1721: END IF;

Line 1718: RAISE okl_api.g_exception_unexpected_error;

1714: ,'_PVT'
1715: ,x_return_status);
1716:
1717: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1718: RAISE okl_api.g_exception_unexpected_error;
1719: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1720: RAISE okl_api.g_exception_error;
1721: END IF;
1722:

Line 1719: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1715: ,x_return_status);
1716:
1717: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1718: RAISE okl_api.g_exception_unexpected_error;
1719: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1720: RAISE okl_api.g_exception_error;
1721: END IF;
1722:
1723: --null out defaults

Line 1720: RAISE okl_api.g_exception_error;

1716:
1717: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1718: RAISE okl_api.g_exception_unexpected_error;
1719: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1720: RAISE okl_api.g_exception_error;
1721: END IF;
1722:
1723: --null out defaults
1724:

Line 1732: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1728:
1729: l_eccv_rec.crit_cat_def_id := get_seq_id; --Setting Item Attributes
1730: l_return_status := set_attributes(l_eccv_rec, l_def_eccv_rec);
1731:
1732: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1733: RAISE okl_api.g_exception_unexpected_error;
1734: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1735: RAISE okl_api.g_exception_error;
1736: END IF;

Line 1733: RAISE okl_api.g_exception_unexpected_error;

1729: l_eccv_rec.crit_cat_def_id := get_seq_id; --Setting Item Attributes
1730: l_return_status := set_attributes(l_eccv_rec, l_def_eccv_rec);
1731:
1732: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1733: RAISE okl_api.g_exception_unexpected_error;
1734: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1735: RAISE okl_api.g_exception_error;
1736: END IF;
1737:

Line 1734: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1730: l_return_status := set_attributes(l_eccv_rec, l_def_eccv_rec);
1731:
1732: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1733: RAISE okl_api.g_exception_unexpected_error;
1734: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1735: RAISE okl_api.g_exception_error;
1736: END IF;
1737:
1738: -- fill who columns

Line 1735: RAISE okl_api.g_exception_error;

1731:
1732: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1733: RAISE okl_api.g_exception_unexpected_error;
1734: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1735: RAISE okl_api.g_exception_error;
1736: END IF;
1737:
1738: -- fill who columns
1739:

Line 1746: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1742: --validate attributes
1743:
1744: l_return_status := validate_attributes(l_def_eccv_rec);
1745:
1746: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1747: RAISE okl_api.g_exception_unexpected_error;
1748: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1749: RAISE okl_api.g_exception_error;
1750: END IF;

Line 1747: RAISE okl_api.g_exception_unexpected_error;

1743:
1744: l_return_status := validate_attributes(l_def_eccv_rec);
1745:
1746: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1747: RAISE okl_api.g_exception_unexpected_error;
1748: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1749: RAISE okl_api.g_exception_error;
1750: END IF;
1751:

Line 1748: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1744: l_return_status := validate_attributes(l_def_eccv_rec);
1745:
1746: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1747: RAISE okl_api.g_exception_unexpected_error;
1748: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1749: RAISE okl_api.g_exception_error;
1750: END IF;
1751:
1752: --validate record

Line 1749: RAISE okl_api.g_exception_error;

1745:
1746: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1747: RAISE okl_api.g_exception_unexpected_error;
1748: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1749: RAISE okl_api.g_exception_error;
1750: END IF;
1751:
1752: --validate record
1753:

Line 1756: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1752: --validate record
1753:
1754: l_return_status := validate_record(l_def_eccv_rec);
1755:
1756: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1757: RAISE okl_api.g_exception_unexpected_error;
1758: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1759: RAISE okl_api.g_exception_error;
1760: END IF;

Line 1757: RAISE okl_api.g_exception_unexpected_error;

1753:
1754: l_return_status := validate_record(l_def_eccv_rec);
1755:
1756: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1757: RAISE okl_api.g_exception_unexpected_error;
1758: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1759: RAISE okl_api.g_exception_error;
1760: END IF;
1761:

Line 1758: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1754: l_return_status := validate_record(l_def_eccv_rec);
1755:
1756: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1757: RAISE okl_api.g_exception_unexpected_error;
1758: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1759: RAISE okl_api.g_exception_error;
1760: END IF;
1761:
1762: --migrate v to b

Line 1759: RAISE okl_api.g_exception_error;

1755:
1756: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1757: RAISE okl_api.g_exception_unexpected_error;
1758: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1759: RAISE okl_api.g_exception_error;
1760: END IF;
1761:
1762: --migrate v to b
1763:

Line 1780: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1776: ,x_msg_data
1777: ,l_eccb_rec
1778: ,lx_eccb_rec);
1779:
1780: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1781: RAISE okl_api.g_exception_unexpected_error;
1782: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1783: RAISE okl_api.g_exception_error;
1784: END IF;

Line 1781: RAISE okl_api.g_exception_unexpected_error;

1777: ,l_eccb_rec
1778: ,lx_eccb_rec);
1779:
1780: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1781: RAISE okl_api.g_exception_unexpected_error;
1782: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1783: RAISE okl_api.g_exception_error;
1784: END IF;
1785:

Line 1782: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1778: ,lx_eccb_rec);
1779:
1780: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1781: RAISE okl_api.g_exception_unexpected_error;
1782: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1783: RAISE okl_api.g_exception_error;
1784: END IF;
1785:
1786: --migrate back b to v

Line 1783: RAISE okl_api.g_exception_error;

1779:
1780: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1781: RAISE okl_api.g_exception_unexpected_error;
1782: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1783: RAISE okl_api.g_exception_error;
1784: END IF;
1785:
1786: --migrate back b to v
1787:

Line 1800: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1796: ,x_msg_data
1797: ,l_ecctl_rec
1798: ,lx_ecctl_rec);
1799:
1800: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1801: RAISE okl_api.g_exception_unexpected_error;
1802: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1803: RAISE okl_api.g_exception_error;
1804: END IF;

Line 1801: RAISE okl_api.g_exception_unexpected_error;

1797: ,l_ecctl_rec
1798: ,lx_ecctl_rec);
1799:
1800: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1801: RAISE okl_api.g_exception_unexpected_error;
1802: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1803: RAISE okl_api.g_exception_error;
1804: END IF;
1805:

Line 1802: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1798: ,lx_ecctl_rec);
1799:
1800: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1801: RAISE okl_api.g_exception_unexpected_error;
1802: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1803: RAISE okl_api.g_exception_error;
1804: END IF;
1805:
1806: --migrate back tl to v

Line 1803: RAISE okl_api.g_exception_error;

1799:
1800: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1801: RAISE okl_api.g_exception_unexpected_error;
1802: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1803: RAISE okl_api.g_exception_error;
1804: END IF;
1805:
1806: --migrate back tl to v
1807:

Line 1814: okl_api.end_activity(x_msg_count, x_msg_data);

1810: --Set OUT Values
1811:
1812: x_eccv_rec := l_def_eccv_rec;
1813: x_return_status := l_return_status;
1814: okl_api.end_activity(x_msg_count, x_msg_data);
1815: EXCEPTION
1816: WHEN g_exception_halt_validation THEN
1817:
1818: -- No action necessary. Validation can continue to next attribute/column

Line 1821: WHEN okl_api.g_exception_error THEN

1817:
1818: -- No action necessary. Validation can continue to next attribute/column
1819:
1820: NULL;
1821: WHEN okl_api.g_exception_error THEN
1822: x_return_status := okl_api.handle_exceptions(l_api_name
1823: ,g_pkg_name
1824: ,'OKL_API.G_RET_STS_ERROR'
1825: ,x_msg_count

Line 1822: x_return_status := okl_api.handle_exceptions(l_api_name

1818: -- No action necessary. Validation can continue to next attribute/column
1819:
1820: NULL;
1821: WHEN okl_api.g_exception_error THEN
1822: x_return_status := okl_api.handle_exceptions(l_api_name
1823: ,g_pkg_name
1824: ,'OKL_API.G_RET_STS_ERROR'
1825: ,x_msg_count
1826: ,x_msg_data

Line 1824: ,'OKL_API.G_RET_STS_ERROR'

1820: NULL;
1821: WHEN okl_api.g_exception_error THEN
1822: x_return_status := okl_api.handle_exceptions(l_api_name
1823: ,g_pkg_name
1824: ,'OKL_API.G_RET_STS_ERROR'
1825: ,x_msg_count
1826: ,x_msg_data
1827: ,'_PVT');
1828: WHEN okl_api.g_exception_unexpected_error THEN

Line 1828: WHEN okl_api.g_exception_unexpected_error THEN

1824: ,'OKL_API.G_RET_STS_ERROR'
1825: ,x_msg_count
1826: ,x_msg_data
1827: ,'_PVT');
1828: WHEN okl_api.g_exception_unexpected_error THEN
1829: x_return_status := okl_api.handle_exceptions(l_api_name
1830: ,g_pkg_name
1831: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1832: ,x_msg_count

Line 1829: x_return_status := okl_api.handle_exceptions(l_api_name

1825: ,x_msg_count
1826: ,x_msg_data
1827: ,'_PVT');
1828: WHEN okl_api.g_exception_unexpected_error THEN
1829: x_return_status := okl_api.handle_exceptions(l_api_name
1830: ,g_pkg_name
1831: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1832: ,x_msg_count
1833: ,x_msg_data

Line 1831: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1827: ,'_PVT');
1828: WHEN okl_api.g_exception_unexpected_error THEN
1829: x_return_status := okl_api.handle_exceptions(l_api_name
1830: ,g_pkg_name
1831: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1832: ,x_msg_count
1833: ,x_msg_data
1834: ,'_PVT');
1835: WHEN OTHERS THEN

Line 1836: x_return_status := okl_api.handle_exceptions(l_api_name

1832: ,x_msg_count
1833: ,x_msg_data
1834: ,'_PVT');
1835: WHEN OTHERS THEN
1836: x_return_status := okl_api.handle_exceptions(l_api_name
1837: ,g_pkg_name
1838: ,'OTHERS'
1839: ,x_msg_count
1840: ,x_msg_data

Line 1849: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

1845: -- Procedure insert_row_tbl
1846: --------------------------------------------------------------------------------
1847:
1848: PROCEDURE insert_row(p_api_version IN number
1849: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
1850: ,x_return_status OUT NOCOPY varchar2
1851: ,x_msg_count OUT NOCOPY number
1852: ,x_msg_data OUT NOCOPY varchar2
1853: ,p_eccv_tbl IN okl_eccv_tbl

Line 1857: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

1853: ,p_eccv_tbl IN okl_eccv_tbl
1854: ,x_eccv_tbl OUT NOCOPY okl_eccv_tbl) IS
1855: l_api_version CONSTANT number := 1;
1856: l_api_name CONSTANT varchar2(30) := 'tbl_insert_row';
1857: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1858: i number := 0;
1859: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;
1860:
1861: BEGIN

Line 1859: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;

1855: l_api_version CONSTANT number := 1;
1856: l_api_name CONSTANT varchar2(30) := 'tbl_insert_row';
1857: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1858: i number := 0;
1859: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;
1860:
1861: BEGIN
1862: okl_api.init_msg_list(p_init_msg_list);
1863:

Line 1862: okl_api.init_msg_list(p_init_msg_list);

1858: i number := 0;
1859: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;
1860:
1861: BEGIN
1862: okl_api.init_msg_list(p_init_msg_list);
1863:
1864: -- Make sure PL/SQL table has records in it before passing
1865:
1866: IF (p_eccv_tbl.COUNT > 0) THEN

Line 1871: ,p_init_msg_list => okl_api.g_false

1867: i := p_eccv_tbl.FIRST;
1868:
1869: LOOP
1870: insert_row(p_api_version => p_api_version
1871: ,p_init_msg_list => okl_api.g_false
1872: ,x_return_status => x_return_status
1873: ,x_msg_count => x_msg_count
1874: ,x_msg_data => x_msg_data
1875: ,p_eccv_rec => p_eccv_tbl(i)

Line 1877: IF x_return_status <> okl_api.g_ret_sts_success THEN

1873: ,x_msg_count => x_msg_count
1874: ,x_msg_data => x_msg_data
1875: ,p_eccv_rec => p_eccv_tbl(i)
1876: ,x_eccv_rec => x_eccv_tbl(i));
1877: IF x_return_status <> okl_api.g_ret_sts_success THEN
1878: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
1879: l_overall_status := x_return_status;
1880: END IF;
1881: END IF;

Line 1878: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN

1874: ,x_msg_data => x_msg_data
1875: ,p_eccv_rec => p_eccv_tbl(i)
1876: ,x_eccv_rec => x_eccv_tbl(i));
1877: IF x_return_status <> okl_api.g_ret_sts_success THEN
1878: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
1879: l_overall_status := x_return_status;
1880: END IF;
1881: END IF;
1882: EXIT WHEN(i = p_eccv_tbl.LAST);

Line 1894: WHEN okl_api.g_exception_error THEN

1890:
1891: -- No action necessary. Validation can continue to next attribute/column
1892:
1893: NULL;
1894: WHEN okl_api.g_exception_error THEN
1895: x_return_status := okl_api.handle_exceptions(l_api_name
1896: ,g_pkg_name
1897: ,'OKL_API.G_RET_STS_ERROR'
1898: ,x_msg_count

Line 1895: x_return_status := okl_api.handle_exceptions(l_api_name

1891: -- No action necessary. Validation can continue to next attribute/column
1892:
1893: NULL;
1894: WHEN okl_api.g_exception_error THEN
1895: x_return_status := okl_api.handle_exceptions(l_api_name
1896: ,g_pkg_name
1897: ,'OKL_API.G_RET_STS_ERROR'
1898: ,x_msg_count
1899: ,x_msg_data

Line 1897: ,'OKL_API.G_RET_STS_ERROR'

1893: NULL;
1894: WHEN okl_api.g_exception_error THEN
1895: x_return_status := okl_api.handle_exceptions(l_api_name
1896: ,g_pkg_name
1897: ,'OKL_API.G_RET_STS_ERROR'
1898: ,x_msg_count
1899: ,x_msg_data
1900: ,'_PVT');
1901: WHEN okl_api.g_exception_unexpected_error THEN

Line 1901: WHEN okl_api.g_exception_unexpected_error THEN

1897: ,'OKL_API.G_RET_STS_ERROR'
1898: ,x_msg_count
1899: ,x_msg_data
1900: ,'_PVT');
1901: WHEN okl_api.g_exception_unexpected_error THEN
1902: x_return_status := okl_api.handle_exceptions(l_api_name
1903: ,g_pkg_name
1904: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1905: ,x_msg_count

Line 1902: x_return_status := okl_api.handle_exceptions(l_api_name

1898: ,x_msg_count
1899: ,x_msg_data
1900: ,'_PVT');
1901: WHEN okl_api.g_exception_unexpected_error THEN
1902: x_return_status := okl_api.handle_exceptions(l_api_name
1903: ,g_pkg_name
1904: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1905: ,x_msg_count
1906: ,x_msg_data

Line 1904: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1900: ,'_PVT');
1901: WHEN okl_api.g_exception_unexpected_error THEN
1902: x_return_status := okl_api.handle_exceptions(l_api_name
1903: ,g_pkg_name
1904: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1905: ,x_msg_count
1906: ,x_msg_data
1907: ,'_PVT');
1908: WHEN OTHERS THEN

Line 1909: x_return_status := okl_api.handle_exceptions(l_api_name

1905: ,x_msg_count
1906: ,x_msg_data
1907: ,'_PVT');
1908: WHEN OTHERS THEN
1909: x_return_status := okl_api.handle_exceptions(l_api_name
1910: ,g_pkg_name
1911: ,'OTHERS'
1912: ,x_msg_count
1913: ,x_msg_data

Line 1922: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

1918: -- Procedure update_row_b
1919: --------------------------------------------------------------------------------
1920:
1921: PROCEDURE update_row(p_api_version IN number
1922: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
1923: ,x_return_status OUT NOCOPY varchar2
1924: ,x_msg_count OUT NOCOPY number
1925: ,x_msg_data OUT NOCOPY varchar2
1926: ,p_eccb_rec IN okl_eccb_rec

Line 1930: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

1926: ,p_eccb_rec IN okl_eccb_rec
1927: ,x_eccb_rec OUT NOCOPY okl_eccb_rec) IS
1928: l_api_version CONSTANT number := 1;
1929: l_api_name CONSTANT varchar2(30) := 'update_row_b';
1930: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1931: l_eccb_rec okl_eccb_rec := p_eccb_rec;
1932: l_def_eccb_rec okl_eccb_rec;
1933: l_row_notfound boolean := true;
1934:

Line 1937: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

1933: l_row_notfound boolean := true;
1934:
1935: FUNCTION set_attributes(p_eccb_rec IN okl_eccb_rec
1936: ,x_eccb_rec OUT NOCOPY okl_eccb_rec) RETURN varchar2 IS
1937: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1938:
1939: BEGIN
1940: x_eccb_rec := p_eccb_rec;
1941: RETURN(l_return_status);

Line 1945: l_return_status := okl_api.start_activity(l_api_name

1941: RETURN(l_return_status);
1942: END set_attributes;
1943:
1944: BEGIN
1945: l_return_status := okl_api.start_activity(l_api_name
1946: ,g_pkg_name
1947: ,p_init_msg_list
1948: ,l_api_version
1949: ,p_api_version

Line 1953: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1949: ,p_api_version
1950: ,'_PVT'
1951: ,x_return_status);
1952:
1953: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1954: RAISE okl_api.g_exception_unexpected_error;
1955: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1956: RAISE okl_api.g_exception_error;
1957: END IF;

Line 1954: RAISE okl_api.g_exception_unexpected_error;

1950: ,'_PVT'
1951: ,x_return_status);
1952:
1953: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1954: RAISE okl_api.g_exception_unexpected_error;
1955: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1956: RAISE okl_api.g_exception_error;
1957: END IF;
1958:

Line 1955: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1951: ,x_return_status);
1952:
1953: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1954: RAISE okl_api.g_exception_unexpected_error;
1955: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1956: RAISE okl_api.g_exception_error;
1957: END IF;
1958:
1959: --Setting Item Attributes

Line 1956: RAISE okl_api.g_exception_error;

1952:
1953: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1954: RAISE okl_api.g_exception_unexpected_error;
1955: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1956: RAISE okl_api.g_exception_error;
1957: END IF;
1958:
1959: --Setting Item Attributes
1960:

Line 1963: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1959: --Setting Item Attributes
1960:
1961: l_return_status := set_attributes(p_eccb_rec, l_eccb_rec);
1962:
1963: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1964: RAISE okl_api.g_exception_unexpected_error;
1965: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1966: RAISE okl_api.g_exception_error;
1967: END IF;

Line 1964: RAISE okl_api.g_exception_unexpected_error;

1960:
1961: l_return_status := set_attributes(p_eccb_rec, l_eccb_rec);
1962:
1963: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1964: RAISE okl_api.g_exception_unexpected_error;
1965: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1966: RAISE okl_api.g_exception_error;
1967: END IF;
1968:

Line 1965: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1961: l_return_status := set_attributes(p_eccb_rec, l_eccb_rec);
1962:
1963: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1964: RAISE okl_api.g_exception_unexpected_error;
1965: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1966: RAISE okl_api.g_exception_error;
1967: END IF;
1968:
1969: UPDATE okl_fe_crit_cat_def_b

Line 1966: RAISE okl_api.g_exception_error;

1962:
1963: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1964: RAISE okl_api.g_exception_unexpected_error;
1965: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1966: RAISE okl_api.g_exception_error;
1967: END IF;
1968:
1969: UPDATE okl_fe_crit_cat_def_b
1970: SET crit_cat_def_id = l_eccb_rec.crit_cat_def_id

Line 1992: okl_api.end_activity(x_msg_count, x_msg_data);

1988:
1989: --Set OUT Values
1990:
1991: x_eccb_rec := l_eccb_rec;
1992: okl_api.end_activity(x_msg_count, x_msg_data);
1993: x_return_status := l_return_status;
1994: EXCEPTION
1995: WHEN g_exception_halt_validation THEN
1996:

Line 2000: WHEN okl_api.g_exception_error THEN

1996:
1997: -- No action necessary. Validation can continue to next attribute/column
1998:
1999: NULL;
2000: WHEN okl_api.g_exception_error THEN
2001: x_return_status := okl_api.handle_exceptions(l_api_name
2002: ,g_pkg_name
2003: ,'OKL_API.G_RET_STS_ERROR'
2004: ,x_msg_count

Line 2001: x_return_status := okl_api.handle_exceptions(l_api_name

1997: -- No action necessary. Validation can continue to next attribute/column
1998:
1999: NULL;
2000: WHEN okl_api.g_exception_error THEN
2001: x_return_status := okl_api.handle_exceptions(l_api_name
2002: ,g_pkg_name
2003: ,'OKL_API.G_RET_STS_ERROR'
2004: ,x_msg_count
2005: ,x_msg_data

Line 2003: ,'OKL_API.G_RET_STS_ERROR'

1999: NULL;
2000: WHEN okl_api.g_exception_error THEN
2001: x_return_status := okl_api.handle_exceptions(l_api_name
2002: ,g_pkg_name
2003: ,'OKL_API.G_RET_STS_ERROR'
2004: ,x_msg_count
2005: ,x_msg_data
2006: ,'_PVT');
2007: WHEN okl_api.g_exception_unexpected_error THEN

Line 2007: WHEN okl_api.g_exception_unexpected_error THEN

2003: ,'OKL_API.G_RET_STS_ERROR'
2004: ,x_msg_count
2005: ,x_msg_data
2006: ,'_PVT');
2007: WHEN okl_api.g_exception_unexpected_error THEN
2008: x_return_status := okl_api.handle_exceptions(l_api_name
2009: ,g_pkg_name
2010: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2011: ,x_msg_count

Line 2008: x_return_status := okl_api.handle_exceptions(l_api_name

2004: ,x_msg_count
2005: ,x_msg_data
2006: ,'_PVT');
2007: WHEN okl_api.g_exception_unexpected_error THEN
2008: x_return_status := okl_api.handle_exceptions(l_api_name
2009: ,g_pkg_name
2010: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2011: ,x_msg_count
2012: ,x_msg_data

Line 2010: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2006: ,'_PVT');
2007: WHEN okl_api.g_exception_unexpected_error THEN
2008: x_return_status := okl_api.handle_exceptions(l_api_name
2009: ,g_pkg_name
2010: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2011: ,x_msg_count
2012: ,x_msg_data
2013: ,'_PVT');
2014: WHEN OTHERS THEN

Line 2015: x_return_status := okl_api.handle_exceptions(l_api_name

2011: ,x_msg_count
2012: ,x_msg_data
2013: ,'_PVT');
2014: WHEN OTHERS THEN
2015: x_return_status := okl_api.handle_exceptions(l_api_name
2016: ,g_pkg_name
2017: ,'OTHERS'
2018: ,x_msg_count
2019: ,x_msg_data

Line 2028: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

2024: -- Procedure update_row_tl
2025: --------------------------------------------------------------------------------
2026:
2027: PROCEDURE update_row(p_api_version IN number
2028: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
2029: ,x_return_status OUT NOCOPY varchar2
2030: ,x_msg_count OUT NOCOPY number
2031: ,x_msg_data OUT NOCOPY varchar2
2032: ,p_ecctl_rec IN okl_ecctl_rec

Line 2036: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

2032: ,p_ecctl_rec IN okl_ecctl_rec
2033: ,x_ecctl_rec OUT NOCOPY okl_ecctl_rec) IS
2034: l_api_version CONSTANT number := 1;
2035: l_api_name CONSTANT varchar2(30) := 'update_row_tl';
2036: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2037: l_ecctl_rec okl_ecctl_rec := p_ecctl_rec;
2038: l_def_ecctl_rec okl_ecctl_rec;
2039: l_row_notfound boolean := true;
2040:

Line 2043: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

2039: l_row_notfound boolean := true;
2040:
2041: FUNCTION set_attributes(p_ecctl_rec IN okl_ecctl_rec
2042: ,x_ecctl_rec OUT NOCOPY okl_ecctl_rec) RETURN varchar2 IS
2043: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2044:
2045: BEGIN
2046: x_ecctl_rec := p_ecctl_rec;
2047: x_ecctl_rec.language := userenv('LANG');

Line 2053: l_return_status := okl_api.start_activity(l_api_name

2049: RETURN(l_return_status);
2050: END set_attributes;
2051:
2052: BEGIN
2053: l_return_status := okl_api.start_activity(l_api_name
2054: ,g_pkg_name
2055: ,p_init_msg_list
2056: ,l_api_version
2057: ,p_api_version

Line 2061: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2057: ,p_api_version
2058: ,'_PVT'
2059: ,x_return_status);
2060:
2061: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2062: RAISE okl_api.g_exception_unexpected_error;
2063: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2064: RAISE okl_api.g_exception_error;
2065: END IF;

Line 2062: RAISE okl_api.g_exception_unexpected_error;

2058: ,'_PVT'
2059: ,x_return_status);
2060:
2061: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2062: RAISE okl_api.g_exception_unexpected_error;
2063: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2064: RAISE okl_api.g_exception_error;
2065: END IF;
2066:

Line 2063: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2059: ,x_return_status);
2060:
2061: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2062: RAISE okl_api.g_exception_unexpected_error;
2063: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2064: RAISE okl_api.g_exception_error;
2065: END IF;
2066:
2067: --Setting Item Attributes

Line 2064: RAISE okl_api.g_exception_error;

2060:
2061: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2062: RAISE okl_api.g_exception_unexpected_error;
2063: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2064: RAISE okl_api.g_exception_error;
2065: END IF;
2066:
2067: --Setting Item Attributes
2068:

Line 2071: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2067: --Setting Item Attributes
2068:
2069: l_return_status := set_attributes(p_ecctl_rec, l_ecctl_rec);
2070:
2071: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2072: RAISE okl_api.g_exception_unexpected_error;
2073: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2074: RAISE okl_api.g_exception_error;
2075: END IF;

Line 2072: RAISE okl_api.g_exception_unexpected_error;

2068:
2069: l_return_status := set_attributes(p_ecctl_rec, l_ecctl_rec);
2070:
2071: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2072: RAISE okl_api.g_exception_unexpected_error;
2073: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2074: RAISE okl_api.g_exception_error;
2075: END IF;
2076:

Line 2073: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2069: l_return_status := set_attributes(p_ecctl_rec, l_ecctl_rec);
2070:
2071: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2072: RAISE okl_api.g_exception_unexpected_error;
2073: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2074: RAISE okl_api.g_exception_error;
2075: END IF;
2076:
2077: UPDATE okl_fe_crit_cat_def_tl

Line 2074: RAISE okl_api.g_exception_error;

2070:
2071: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2072: RAISE okl_api.g_exception_unexpected_error;
2073: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2074: RAISE okl_api.g_exception_error;
2075: END IF;
2076:
2077: UPDATE okl_fe_crit_cat_def_tl
2078: SET crit_cat_def_id = l_ecctl_rec.crit_cat_def_id

Line 2097: okl_api.end_activity(x_msg_count, x_msg_data);

2093: --Set OUT Values
2094:
2095: x_ecctl_rec := l_ecctl_rec;
2096: x_return_status := l_return_status;
2097: okl_api.end_activity(x_msg_count, x_msg_data);
2098: EXCEPTION
2099: WHEN g_exception_halt_validation THEN
2100:
2101: -- No action necessary. Validation can continue to next attribute/column

Line 2104: WHEN okl_api.g_exception_error THEN

2100:
2101: -- No action necessary. Validation can continue to next attribute/column
2102:
2103: NULL;
2104: WHEN okl_api.g_exception_error THEN
2105: x_return_status := okl_api.handle_exceptions(l_api_name
2106: ,g_pkg_name
2107: ,'OKL_API.G_RET_STS_ERROR'
2108: ,x_msg_count

Line 2105: x_return_status := okl_api.handle_exceptions(l_api_name

2101: -- No action necessary. Validation can continue to next attribute/column
2102:
2103: NULL;
2104: WHEN okl_api.g_exception_error THEN
2105: x_return_status := okl_api.handle_exceptions(l_api_name
2106: ,g_pkg_name
2107: ,'OKL_API.G_RET_STS_ERROR'
2108: ,x_msg_count
2109: ,x_msg_data

Line 2107: ,'OKL_API.G_RET_STS_ERROR'

2103: NULL;
2104: WHEN okl_api.g_exception_error THEN
2105: x_return_status := okl_api.handle_exceptions(l_api_name
2106: ,g_pkg_name
2107: ,'OKL_API.G_RET_STS_ERROR'
2108: ,x_msg_count
2109: ,x_msg_data
2110: ,'_PVT');
2111: WHEN okl_api.g_exception_unexpected_error THEN

Line 2111: WHEN okl_api.g_exception_unexpected_error THEN

2107: ,'OKL_API.G_RET_STS_ERROR'
2108: ,x_msg_count
2109: ,x_msg_data
2110: ,'_PVT');
2111: WHEN okl_api.g_exception_unexpected_error THEN
2112: x_return_status := okl_api.handle_exceptions(l_api_name
2113: ,g_pkg_name
2114: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2115: ,x_msg_count

Line 2112: x_return_status := okl_api.handle_exceptions(l_api_name

2108: ,x_msg_count
2109: ,x_msg_data
2110: ,'_PVT');
2111: WHEN okl_api.g_exception_unexpected_error THEN
2112: x_return_status := okl_api.handle_exceptions(l_api_name
2113: ,g_pkg_name
2114: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2115: ,x_msg_count
2116: ,x_msg_data

Line 2114: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2110: ,'_PVT');
2111: WHEN okl_api.g_exception_unexpected_error THEN
2112: x_return_status := okl_api.handle_exceptions(l_api_name
2113: ,g_pkg_name
2114: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2115: ,x_msg_count
2116: ,x_msg_data
2117: ,'_PVT');
2118: WHEN OTHERS THEN

Line 2119: x_return_status := okl_api.handle_exceptions(l_api_name

2115: ,x_msg_count
2116: ,x_msg_data
2117: ,'_PVT');
2118: WHEN OTHERS THEN
2119: x_return_status := okl_api.handle_exceptions(l_api_name
2120: ,g_pkg_name
2121: ,'OTHERS'
2122: ,x_msg_count
2123: ,x_msg_data

Line 2132: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

2128: -- Procedure update_row_v
2129: --------------------------------------------------------------------------------
2130:
2131: PROCEDURE update_row(p_api_version IN number
2132: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
2133: ,x_return_status OUT NOCOPY varchar2
2134: ,x_msg_count OUT NOCOPY number
2135: ,x_msg_data OUT NOCOPY varchar2
2136: ,p_eccv_rec IN okl_eccv_rec

Line 2140: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

2136: ,p_eccv_rec IN okl_eccv_rec
2137: ,x_eccv_rec OUT NOCOPY okl_eccv_rec) IS
2138: l_api_version CONSTANT number := 1;
2139: l_api_name CONSTANT varchar2(30) := 'v_update_row';
2140: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2141: l_eccv_rec okl_eccv_rec := p_eccv_rec;
2142: l_def_eccv_rec okl_eccv_rec;
2143: lx_def_eccv_rec okl_eccv_rec;
2144: l_eccb_rec okl_eccb_rec;

Line 2163: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

2159: FUNCTION populate_new_record(p_eccv_rec IN okl_eccv_rec
2160: ,x_eccv_rec OUT NOCOPY okl_eccv_rec) RETURN varchar2 IS
2161: l_eccv_rec okl_eccv_rec;
2162: l_row_notfound boolean := true;
2163: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2164:
2165: BEGIN
2166: x_eccv_rec := p_eccv_rec;
2167:

Line 2173: l_return_status := okl_api.g_ret_sts_unexp_error;

2169:
2170: l_eccv_rec := get_rec(p_eccv_rec, l_row_notfound);
2171:
2172: IF (l_row_notfound) THEN
2173: l_return_status := okl_api.g_ret_sts_unexp_error;
2174: END IF;
2175:
2176: --dont default object_version_number, last_updated_by, last_updat_date and last_update_login
2177:

Line 2242: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

2238: END populate_new_record;
2239:
2240: FUNCTION set_attributes(p_eccv_rec IN okl_eccv_rec
2241: ,x_eccv_rec OUT NOCOPY okl_eccv_rec) RETURN varchar2 IS
2242: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2243:
2244: BEGIN
2245: x_eccv_rec := p_eccv_rec;
2246: RETURN(l_return_status);

Line 2250: l_return_status := okl_api.start_activity(l_api_name

2246: RETURN(l_return_status);
2247: END set_attributes;
2248:
2249: BEGIN
2250: l_return_status := okl_api.start_activity(l_api_name
2251: ,g_pkg_name
2252: ,p_init_msg_list
2253: ,l_api_version
2254: ,p_api_version

Line 2258: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2254: ,p_api_version
2255: ,'_PVT'
2256: ,x_return_status);
2257:
2258: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2259: RAISE okl_api.g_exception_unexpected_error;
2260: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2261: RAISE okl_api.g_exception_error;
2262: END IF;

Line 2259: RAISE okl_api.g_exception_unexpected_error;

2255: ,'_PVT'
2256: ,x_return_status);
2257:
2258: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2259: RAISE okl_api.g_exception_unexpected_error;
2260: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2261: RAISE okl_api.g_exception_error;
2262: END IF;
2263:

Line 2260: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2256: ,x_return_status);
2257:
2258: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2259: RAISE okl_api.g_exception_unexpected_error;
2260: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2261: RAISE okl_api.g_exception_error;
2262: END IF;
2263:
2264: --Setting Item Attributes

Line 2261: RAISE okl_api.g_exception_error;

2257:
2258: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2259: RAISE okl_api.g_exception_unexpected_error;
2260: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2261: RAISE okl_api.g_exception_error;
2262: END IF;
2263:
2264: --Setting Item Attributes
2265:

Line 2268: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2264: --Setting Item Attributes
2265:
2266: l_return_status := set_attributes(l_eccv_rec, lx_def_eccv_rec);
2267:
2268: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2269: RAISE okl_api.g_exception_unexpected_error;
2270: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2271: RAISE okl_api.g_exception_error;
2272: END IF;

Line 2269: RAISE okl_api.g_exception_unexpected_error;

2265:
2266: l_return_status := set_attributes(l_eccv_rec, lx_def_eccv_rec);
2267:
2268: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2269: RAISE okl_api.g_exception_unexpected_error;
2270: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2271: RAISE okl_api.g_exception_error;
2272: END IF;
2273:

Line 2270: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2266: l_return_status := set_attributes(l_eccv_rec, lx_def_eccv_rec);
2267:
2268: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2269: RAISE okl_api.g_exception_unexpected_error;
2270: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2271: RAISE okl_api.g_exception_error;
2272: END IF;
2273:
2274: --default the unmodified values from the database

Line 2271: RAISE okl_api.g_exception_error;

2267:
2268: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2269: RAISE okl_api.g_exception_unexpected_error;
2270: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2271: RAISE okl_api.g_exception_error;
2272: END IF;
2273:
2274: --default the unmodified values from the database
2275:

Line 2278: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2274: --default the unmodified values from the database
2275:
2276: l_return_status := populate_new_record(lx_def_eccv_rec, l_def_eccv_rec);
2277:
2278: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2279: RAISE okl_api.g_exception_unexpected_error;
2280: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2281: RAISE okl_api.g_exception_error;
2282: END IF;

Line 2279: RAISE okl_api.g_exception_unexpected_error;

2275:
2276: l_return_status := populate_new_record(lx_def_eccv_rec, l_def_eccv_rec);
2277:
2278: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2279: RAISE okl_api.g_exception_unexpected_error;
2280: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2281: RAISE okl_api.g_exception_error;
2282: END IF;
2283:

Line 2280: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2276: l_return_status := populate_new_record(lx_def_eccv_rec, l_def_eccv_rec);
2277:
2278: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2279: RAISE okl_api.g_exception_unexpected_error;
2280: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2281: RAISE okl_api.g_exception_error;
2282: END IF;
2283:
2284: --null out the G Miss values

Line 2281: RAISE okl_api.g_exception_error;

2277:
2278: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2279: RAISE okl_api.g_exception_unexpected_error;
2280: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2281: RAISE okl_api.g_exception_error;
2282: END IF;
2283:
2284: --null out the G Miss values
2285:

Line 2296: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2292: --validate attributes
2293:
2294: l_return_status := validate_attributes(l_def_eccv_rec);
2295:
2296: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2297: RAISE okl_api.g_exception_unexpected_error;
2298: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2299: RAISE okl_api.g_exception_error;
2300: END IF;

Line 2297: RAISE okl_api.g_exception_unexpected_error;

2293:
2294: l_return_status := validate_attributes(l_def_eccv_rec);
2295:
2296: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2297: RAISE okl_api.g_exception_unexpected_error;
2298: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2299: RAISE okl_api.g_exception_error;
2300: END IF;
2301:

Line 2298: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2294: l_return_status := validate_attributes(l_def_eccv_rec);
2295:
2296: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2297: RAISE okl_api.g_exception_unexpected_error;
2298: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2299: RAISE okl_api.g_exception_error;
2300: END IF;
2301:
2302: --validate record

Line 2299: RAISE okl_api.g_exception_error;

2295:
2296: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2297: RAISE okl_api.g_exception_unexpected_error;
2298: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2299: RAISE okl_api.g_exception_error;
2300: END IF;
2301:
2302: --validate record
2303:

Line 2306: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2302: --validate record
2303:
2304: l_return_status := validate_record(l_def_eccv_rec);
2305:
2306: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2307: RAISE okl_api.g_exception_unexpected_error;
2308: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2309: RAISE okl_api.g_exception_error;
2310: END IF;

Line 2307: RAISE okl_api.g_exception_unexpected_error;

2303:
2304: l_return_status := validate_record(l_def_eccv_rec);
2305:
2306: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2307: RAISE okl_api.g_exception_unexpected_error;
2308: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2309: RAISE okl_api.g_exception_error;
2310: END IF;
2311:

Line 2308: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2304: l_return_status := validate_record(l_def_eccv_rec);
2305:
2306: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2307: RAISE okl_api.g_exception_unexpected_error;
2308: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2309: RAISE okl_api.g_exception_error;
2310: END IF;
2311:
2312: --lock the row

Line 2309: RAISE okl_api.g_exception_error;

2305:
2306: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2307: RAISE okl_api.g_exception_unexpected_error;
2308: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2309: RAISE okl_api.g_exception_error;
2310: END IF;
2311:
2312: --lock the row
2313:

Line 2315: ,p_init_msg_list => okl_api.g_false

2311:
2312: --lock the row
2313:
2314: lock_row(p_api_version => l_api_version
2315: ,p_init_msg_list => okl_api.g_false
2316: ,x_return_status => l_return_status
2317: ,x_msg_count => x_msg_count
2318: ,x_msg_data => x_msg_data
2319: ,p_eccv_rec => l_def_eccv_rec);

Line 2321: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2317: ,x_msg_count => x_msg_count
2318: ,x_msg_data => x_msg_data
2319: ,p_eccv_rec => l_def_eccv_rec);
2320:
2321: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2322: RAISE okl_api.g_exception_unexpected_error;
2323: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2324: RAISE okl_api.g_exception_error;
2325: END IF;

Line 2322: RAISE okl_api.g_exception_unexpected_error;

2318: ,x_msg_data => x_msg_data
2319: ,p_eccv_rec => l_def_eccv_rec);
2320:
2321: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2322: RAISE okl_api.g_exception_unexpected_error;
2323: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2324: RAISE okl_api.g_exception_error;
2325: END IF;
2326:

Line 2323: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2319: ,p_eccv_rec => l_def_eccv_rec);
2320:
2321: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2322: RAISE okl_api.g_exception_unexpected_error;
2323: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2324: RAISE okl_api.g_exception_error;
2325: END IF;
2326:
2327: --migrate v to b

Line 2324: RAISE okl_api.g_exception_error;

2320:
2321: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2322: RAISE okl_api.g_exception_unexpected_error;
2323: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2324: RAISE okl_api.g_exception_error;
2325: END IF;
2326:
2327: --migrate v to b
2328:

Line 2345: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2341: ,x_msg_data
2342: ,l_eccb_rec
2343: ,lx_eccb_rec);
2344:
2345: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2346: RAISE okl_api.g_exception_unexpected_error;
2347: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2348: RAISE okl_api.g_exception_error;
2349: END IF; --migrate back b to v

Line 2346: RAISE okl_api.g_exception_unexpected_error;

2342: ,l_eccb_rec
2343: ,lx_eccb_rec);
2344:
2345: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2346: RAISE okl_api.g_exception_unexpected_error;
2347: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2348: RAISE okl_api.g_exception_error;
2349: END IF; --migrate back b to v
2350: migrate(lx_eccb_rec, l_def_eccv_rec);

Line 2347: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2343: ,lx_eccb_rec);
2344:
2345: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2346: RAISE okl_api.g_exception_unexpected_error;
2347: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2348: RAISE okl_api.g_exception_error;
2349: END IF; --migrate back b to v
2350: migrate(lx_eccb_rec, l_def_eccv_rec);
2351:

Line 2348: RAISE okl_api.g_exception_error;

2344:
2345: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2346: RAISE okl_api.g_exception_unexpected_error;
2347: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2348: RAISE okl_api.g_exception_error;
2349: END IF; --migrate back b to v
2350: migrate(lx_eccb_rec, l_def_eccv_rec);
2351:
2352: --call tl update row

Line 2362: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2358: ,x_msg_data
2359: ,l_ecctl_rec
2360: ,lx_ecctl_rec);
2361:
2362: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2363: RAISE okl_api.g_exception_unexpected_error;
2364: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2365: RAISE okl_api.g_exception_error;
2366: END IF;

Line 2363: RAISE okl_api.g_exception_unexpected_error;

2359: ,l_ecctl_rec
2360: ,lx_ecctl_rec);
2361:
2362: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2363: RAISE okl_api.g_exception_unexpected_error;
2364: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2365: RAISE okl_api.g_exception_error;
2366: END IF;
2367: migrate(lx_ecctl_rec, l_def_eccv_rec);

Line 2364: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2360: ,lx_ecctl_rec);
2361:
2362: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2363: RAISE okl_api.g_exception_unexpected_error;
2364: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2365: RAISE okl_api.g_exception_error;
2366: END IF;
2367: migrate(lx_ecctl_rec, l_def_eccv_rec);
2368:

Line 2365: RAISE okl_api.g_exception_error;

2361:
2362: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2363: RAISE okl_api.g_exception_unexpected_error;
2364: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2365: RAISE okl_api.g_exception_error;
2366: END IF;
2367: migrate(lx_ecctl_rec, l_def_eccv_rec);
2368:
2369: --Set OUT Values

Line 2372: okl_api.end_activity(x_msg_count, x_msg_data);

2368:
2369: --Set OUT Values
2370:
2371: x_eccv_rec := l_def_eccv_rec;
2372: okl_api.end_activity(x_msg_count, x_msg_data);
2373: x_return_status := l_return_status;
2374: EXCEPTION
2375: WHEN g_exception_halt_validation THEN
2376:

Line 2380: WHEN okl_api.g_exception_error THEN

2376:
2377: -- No action necessary. Validation can continue to next attribute/column
2378:
2379: NULL;
2380: WHEN okl_api.g_exception_error THEN
2381: x_return_status := okl_api.handle_exceptions(l_api_name
2382: ,g_pkg_name
2383: ,'OKL_API.G_RET_STS_ERROR'
2384: ,x_msg_count

Line 2381: x_return_status := okl_api.handle_exceptions(l_api_name

2377: -- No action necessary. Validation can continue to next attribute/column
2378:
2379: NULL;
2380: WHEN okl_api.g_exception_error THEN
2381: x_return_status := okl_api.handle_exceptions(l_api_name
2382: ,g_pkg_name
2383: ,'OKL_API.G_RET_STS_ERROR'
2384: ,x_msg_count
2385: ,x_msg_data

Line 2383: ,'OKL_API.G_RET_STS_ERROR'

2379: NULL;
2380: WHEN okl_api.g_exception_error THEN
2381: x_return_status := okl_api.handle_exceptions(l_api_name
2382: ,g_pkg_name
2383: ,'OKL_API.G_RET_STS_ERROR'
2384: ,x_msg_count
2385: ,x_msg_data
2386: ,'_PVT');
2387: WHEN okl_api.g_exception_unexpected_error THEN

Line 2387: WHEN okl_api.g_exception_unexpected_error THEN

2383: ,'OKL_API.G_RET_STS_ERROR'
2384: ,x_msg_count
2385: ,x_msg_data
2386: ,'_PVT');
2387: WHEN okl_api.g_exception_unexpected_error THEN
2388: x_return_status := okl_api.handle_exceptions(l_api_name
2389: ,g_pkg_name
2390: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2391: ,x_msg_count

Line 2388: x_return_status := okl_api.handle_exceptions(l_api_name

2384: ,x_msg_count
2385: ,x_msg_data
2386: ,'_PVT');
2387: WHEN okl_api.g_exception_unexpected_error THEN
2388: x_return_status := okl_api.handle_exceptions(l_api_name
2389: ,g_pkg_name
2390: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2391: ,x_msg_count
2392: ,x_msg_data

Line 2390: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2386: ,'_PVT');
2387: WHEN okl_api.g_exception_unexpected_error THEN
2388: x_return_status := okl_api.handle_exceptions(l_api_name
2389: ,g_pkg_name
2390: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2391: ,x_msg_count
2392: ,x_msg_data
2393: ,'_PVT');
2394: WHEN OTHERS THEN

Line 2395: x_return_status := okl_api.handle_exceptions(l_api_name

2391: ,x_msg_count
2392: ,x_msg_data
2393: ,'_PVT');
2394: WHEN OTHERS THEN
2395: x_return_status := okl_api.handle_exceptions(l_api_name
2396: ,g_pkg_name
2397: ,'OTHERS'
2398: ,x_msg_count
2399: ,x_msg_data

Line 2408: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

2404: -- Procedure update_row_tbl
2405: --------------------------------------------------------------------------------
2406:
2407: PROCEDURE update_row(p_api_version IN number
2408: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
2409: ,x_return_status OUT NOCOPY varchar2
2410: ,x_msg_count OUT NOCOPY number
2411: ,x_msg_data OUT NOCOPY varchar2
2412: ,p_eccv_tbl IN okl_eccv_tbl

Line 2416: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

2412: ,p_eccv_tbl IN okl_eccv_tbl
2413: ,x_eccv_tbl OUT NOCOPY okl_eccv_tbl) IS
2414: l_api_version CONSTANT number := 1;
2415: l_api_name CONSTANT varchar2(30) := 'tbl_update_row';
2416: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2417: i number := 0;
2418: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;
2419:
2420: BEGIN

Line 2418: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;

2414: l_api_version CONSTANT number := 1;
2415: l_api_name CONSTANT varchar2(30) := 'tbl_update_row';
2416: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2417: i number := 0;
2418: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;
2419:
2420: BEGIN
2421: okl_api.init_msg_list(p_init_msg_list);
2422:

Line 2421: okl_api.init_msg_list(p_init_msg_list);

2417: i number := 0;
2418: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;
2419:
2420: BEGIN
2421: okl_api.init_msg_list(p_init_msg_list);
2422:
2423: -- Make sure PL/SQL table has records in it before passing
2424:
2425: IF (p_eccv_tbl.COUNT > 0) THEN

Line 2430: ,p_init_msg_list => okl_api.g_false

2426: i := p_eccv_tbl.FIRST;
2427:
2428: LOOP
2429: update_row(p_api_version => p_api_version
2430: ,p_init_msg_list => okl_api.g_false
2431: ,x_return_status => x_return_status
2432: ,x_msg_count => x_msg_count
2433: ,x_msg_data => x_msg_data
2434: ,p_eccv_rec => p_eccv_tbl(i)

Line 2436: IF x_return_status <> okl_api.g_ret_sts_success THEN

2432: ,x_msg_count => x_msg_count
2433: ,x_msg_data => x_msg_data
2434: ,p_eccv_rec => p_eccv_tbl(i)
2435: ,x_eccv_rec => x_eccv_tbl(i));
2436: IF x_return_status <> okl_api.g_ret_sts_success THEN
2437: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
2438: l_overall_status := x_return_status;
2439: END IF;
2440: END IF;

Line 2437: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN

2433: ,x_msg_data => x_msg_data
2434: ,p_eccv_rec => p_eccv_tbl(i)
2435: ,x_eccv_rec => x_eccv_tbl(i));
2436: IF x_return_status <> okl_api.g_ret_sts_success THEN
2437: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
2438: l_overall_status := x_return_status;
2439: END IF;
2440: END IF;
2441: EXIT WHEN(i = p_eccv_tbl.LAST);

Line 2453: WHEN okl_api.g_exception_error THEN

2449:
2450: -- No action necessary. Validation can continue to next attribute/column
2451:
2452: NULL;
2453: WHEN okl_api.g_exception_error THEN
2454: x_return_status := okl_api.handle_exceptions(l_api_name
2455: ,g_pkg_name
2456: ,'OKL_API.G_RET_STS_ERROR'
2457: ,x_msg_count

Line 2454: x_return_status := okl_api.handle_exceptions(l_api_name

2450: -- No action necessary. Validation can continue to next attribute/column
2451:
2452: NULL;
2453: WHEN okl_api.g_exception_error THEN
2454: x_return_status := okl_api.handle_exceptions(l_api_name
2455: ,g_pkg_name
2456: ,'OKL_API.G_RET_STS_ERROR'
2457: ,x_msg_count
2458: ,x_msg_data

Line 2456: ,'OKL_API.G_RET_STS_ERROR'

2452: NULL;
2453: WHEN okl_api.g_exception_error THEN
2454: x_return_status := okl_api.handle_exceptions(l_api_name
2455: ,g_pkg_name
2456: ,'OKL_API.G_RET_STS_ERROR'
2457: ,x_msg_count
2458: ,x_msg_data
2459: ,'_PVT');
2460: WHEN okl_api.g_exception_unexpected_error THEN

Line 2460: WHEN okl_api.g_exception_unexpected_error THEN

2456: ,'OKL_API.G_RET_STS_ERROR'
2457: ,x_msg_count
2458: ,x_msg_data
2459: ,'_PVT');
2460: WHEN okl_api.g_exception_unexpected_error THEN
2461: x_return_status := okl_api.handle_exceptions(l_api_name
2462: ,g_pkg_name
2463: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2464: ,x_msg_count

Line 2461: x_return_status := okl_api.handle_exceptions(l_api_name

2457: ,x_msg_count
2458: ,x_msg_data
2459: ,'_PVT');
2460: WHEN okl_api.g_exception_unexpected_error THEN
2461: x_return_status := okl_api.handle_exceptions(l_api_name
2462: ,g_pkg_name
2463: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2464: ,x_msg_count
2465: ,x_msg_data

Line 2463: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2459: ,'_PVT');
2460: WHEN okl_api.g_exception_unexpected_error THEN
2461: x_return_status := okl_api.handle_exceptions(l_api_name
2462: ,g_pkg_name
2463: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2464: ,x_msg_count
2465: ,x_msg_data
2466: ,'_PVT');
2467: WHEN OTHERS THEN

Line 2468: x_return_status := okl_api.handle_exceptions(l_api_name

2464: ,x_msg_count
2465: ,x_msg_data
2466: ,'_PVT');
2467: WHEN OTHERS THEN
2468: x_return_status := okl_api.handle_exceptions(l_api_name
2469: ,g_pkg_name
2470: ,'OTHERS'
2471: ,x_msg_count
2472: ,x_msg_data

Line 2481: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

2477: -- Procedure delete_row_b
2478: --------------------------------------------------------------------------------
2479:
2480: PROCEDURE delete_row(p_api_version IN number
2481: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
2482: ,x_return_status OUT NOCOPY varchar2
2483: ,x_msg_count OUT NOCOPY number
2484: ,x_msg_data OUT NOCOPY varchar2
2485: ,p_eccb_rec IN okl_eccb_rec) IS

Line 2488: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

2484: ,x_msg_data OUT NOCOPY varchar2
2485: ,p_eccb_rec IN okl_eccb_rec) IS
2486: l_api_version CONSTANT number := 1;
2487: l_api_name CONSTANT varchar2(30) := 'delete_row_b';
2488: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2489: l_eccb_rec okl_eccb_rec := p_eccb_rec;
2490: l_row_notfound boolean := true;
2491:
2492: BEGIN

Line 2493: l_return_status := okl_api.start_activity(l_api_name

2489: l_eccb_rec okl_eccb_rec := p_eccb_rec;
2490: l_row_notfound boolean := true;
2491:
2492: BEGIN
2493: l_return_status := okl_api.start_activity(l_api_name
2494: ,g_pkg_name
2495: ,p_init_msg_list
2496: ,l_api_version
2497: ,p_api_version

Line 2501: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2497: ,p_api_version
2498: ,'_PVT'
2499: ,x_return_status);
2500:
2501: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2502: RAISE okl_api.g_exception_unexpected_error;
2503: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2504: RAISE okl_api.g_exception_error;
2505: END IF;

Line 2502: RAISE okl_api.g_exception_unexpected_error;

2498: ,'_PVT'
2499: ,x_return_status);
2500:
2501: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2502: RAISE okl_api.g_exception_unexpected_error;
2503: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2504: RAISE okl_api.g_exception_error;
2505: END IF;
2506:

Line 2503: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2499: ,x_return_status);
2500:
2501: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2502: RAISE okl_api.g_exception_unexpected_error;
2503: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2504: RAISE okl_api.g_exception_error;
2505: END IF;
2506:
2507: DELETE FROM okl_fe_crit_cat_def_b

Line 2504: RAISE okl_api.g_exception_error;

2500:
2501: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2502: RAISE okl_api.g_exception_unexpected_error;
2503: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2504: RAISE okl_api.g_exception_error;
2505: END IF;
2506:
2507: DELETE FROM okl_fe_crit_cat_def_b
2508: WHERE crit_cat_def_id = l_eccb_rec.crit_cat_def_id;

Line 2510: okl_api.end_activity(x_msg_count, x_msg_data);

2506:
2507: DELETE FROM okl_fe_crit_cat_def_b
2508: WHERE crit_cat_def_id = l_eccb_rec.crit_cat_def_id;
2509: x_return_status := l_return_status;
2510: okl_api.end_activity(x_msg_count, x_msg_data);
2511: EXCEPTION
2512: WHEN g_exception_halt_validation THEN
2513:
2514: -- No action necessary. Validation can continue to next attribute/column

Line 2517: WHEN okl_api.g_exception_error THEN

2513:
2514: -- No action necessary. Validation can continue to next attribute/column
2515:
2516: NULL;
2517: WHEN okl_api.g_exception_error THEN
2518: x_return_status := okl_api.handle_exceptions(l_api_name
2519: ,g_pkg_name
2520: ,'OKL_API.G_RET_STS_ERROR'
2521: ,x_msg_count

Line 2518: x_return_status := okl_api.handle_exceptions(l_api_name

2514: -- No action necessary. Validation can continue to next attribute/column
2515:
2516: NULL;
2517: WHEN okl_api.g_exception_error THEN
2518: x_return_status := okl_api.handle_exceptions(l_api_name
2519: ,g_pkg_name
2520: ,'OKL_API.G_RET_STS_ERROR'
2521: ,x_msg_count
2522: ,x_msg_data

Line 2520: ,'OKL_API.G_RET_STS_ERROR'

2516: NULL;
2517: WHEN okl_api.g_exception_error THEN
2518: x_return_status := okl_api.handle_exceptions(l_api_name
2519: ,g_pkg_name
2520: ,'OKL_API.G_RET_STS_ERROR'
2521: ,x_msg_count
2522: ,x_msg_data
2523: ,'_PVT');
2524: WHEN okl_api.g_exception_unexpected_error THEN

Line 2524: WHEN okl_api.g_exception_unexpected_error THEN

2520: ,'OKL_API.G_RET_STS_ERROR'
2521: ,x_msg_count
2522: ,x_msg_data
2523: ,'_PVT');
2524: WHEN okl_api.g_exception_unexpected_error THEN
2525: x_return_status := okl_api.handle_exceptions(l_api_name
2526: ,g_pkg_name
2527: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2528: ,x_msg_count

Line 2525: x_return_status := okl_api.handle_exceptions(l_api_name

2521: ,x_msg_count
2522: ,x_msg_data
2523: ,'_PVT');
2524: WHEN okl_api.g_exception_unexpected_error THEN
2525: x_return_status := okl_api.handle_exceptions(l_api_name
2526: ,g_pkg_name
2527: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2528: ,x_msg_count
2529: ,x_msg_data

Line 2527: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2523: ,'_PVT');
2524: WHEN okl_api.g_exception_unexpected_error THEN
2525: x_return_status := okl_api.handle_exceptions(l_api_name
2526: ,g_pkg_name
2527: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2528: ,x_msg_count
2529: ,x_msg_data
2530: ,'_PVT');
2531: WHEN OTHERS THEN

Line 2532: x_return_status := okl_api.handle_exceptions(l_api_name

2528: ,x_msg_count
2529: ,x_msg_data
2530: ,'_PVT');
2531: WHEN OTHERS THEN
2532: x_return_status := okl_api.handle_exceptions(l_api_name
2533: ,g_pkg_name
2534: ,'OTHERS'
2535: ,x_msg_count
2536: ,x_msg_data

Line 2545: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

2541: -- Procedure delete_row_tl
2542: --------------------------------------------------------------------------------
2543:
2544: PROCEDURE delete_row(p_api_version IN number
2545: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
2546: ,x_return_status OUT NOCOPY varchar2
2547: ,x_msg_count OUT NOCOPY number
2548: ,x_msg_data OUT NOCOPY varchar2
2549: ,p_ecctl_rec IN okl_ecctl_rec) IS

Line 2552: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

2548: ,x_msg_data OUT NOCOPY varchar2
2549: ,p_ecctl_rec IN okl_ecctl_rec) IS
2550: l_api_version CONSTANT number := 1;
2551: l_api_name CONSTANT varchar2(30) := 'delete_row_tl';
2552: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2553: l_ecctl_rec okl_ecctl_rec := p_ecctl_rec;
2554: l_row_notfound boolean := true;
2555:
2556: FUNCTION set_attributes(p_ecctl_rec IN okl_ecctl_rec

Line 2558: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

2554: l_row_notfound boolean := true;
2555:
2556: FUNCTION set_attributes(p_ecctl_rec IN okl_ecctl_rec
2557: ,x_ecctl_rec OUT NOCOPY okl_ecctl_rec) RETURN varchar2 IS
2558: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2559:
2560: BEGIN
2561: x_ecctl_rec := p_ecctl_rec;
2562: x_ecctl_rec.language := userenv('LANG');

Line 2568: l_return_status := okl_api.start_activity(l_api_name

2564: RETURN(l_return_status);
2565: END set_attributes;
2566:
2567: BEGIN
2568: l_return_status := okl_api.start_activity(l_api_name
2569: ,g_pkg_name
2570: ,p_init_msg_list
2571: ,l_api_version
2572: ,p_api_version

Line 2576: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2572: ,p_api_version
2573: ,'_PVT'
2574: ,x_return_status);
2575:
2576: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2577: RAISE okl_api.g_exception_unexpected_error;
2578: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2579: RAISE okl_api.g_exception_error;
2580: END IF;

Line 2577: RAISE okl_api.g_exception_unexpected_error;

2573: ,'_PVT'
2574: ,x_return_status);
2575:
2576: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2577: RAISE okl_api.g_exception_unexpected_error;
2578: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2579: RAISE okl_api.g_exception_error;
2580: END IF;
2581:

Line 2578: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2574: ,x_return_status);
2575:
2576: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2577: RAISE okl_api.g_exception_unexpected_error;
2578: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2579: RAISE okl_api.g_exception_error;
2580: END IF;
2581:
2582: --Setting Item Attributes

Line 2579: RAISE okl_api.g_exception_error;

2575:
2576: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2577: RAISE okl_api.g_exception_unexpected_error;
2578: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2579: RAISE okl_api.g_exception_error;
2580: END IF;
2581:
2582: --Setting Item Attributes
2583:

Line 2586: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2582: --Setting Item Attributes
2583:
2584: l_return_status := set_attributes(p_ecctl_rec, l_ecctl_rec);
2585:
2586: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2587: RAISE okl_api.g_exception_unexpected_error;
2588: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2589: RAISE okl_api.g_exception_error;
2590: END IF;

Line 2587: RAISE okl_api.g_exception_unexpected_error;

2583:
2584: l_return_status := set_attributes(p_ecctl_rec, l_ecctl_rec);
2585:
2586: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2587: RAISE okl_api.g_exception_unexpected_error;
2588: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2589: RAISE okl_api.g_exception_error;
2590: END IF;
2591:

Line 2588: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2584: l_return_status := set_attributes(p_ecctl_rec, l_ecctl_rec);
2585:
2586: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2587: RAISE okl_api.g_exception_unexpected_error;
2588: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2589: RAISE okl_api.g_exception_error;
2590: END IF;
2591:
2592: DELETE FROM okl_fe_crit_cat_def_tl

Line 2589: RAISE okl_api.g_exception_error;

2585:
2586: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2587: RAISE okl_api.g_exception_unexpected_error;
2588: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2589: RAISE okl_api.g_exception_error;
2590: END IF;
2591:
2592: DELETE FROM okl_fe_crit_cat_def_tl
2593: WHERE crit_cat_def_id = l_ecctl_rec.crit_cat_def_id;

Line 2595: okl_api.end_activity(x_msg_count, x_msg_data);

2591:
2592: DELETE FROM okl_fe_crit_cat_def_tl
2593: WHERE crit_cat_def_id = l_ecctl_rec.crit_cat_def_id;
2594: x_return_status := l_return_status;
2595: okl_api.end_activity(x_msg_count, x_msg_data);
2596: EXCEPTION
2597: WHEN g_exception_halt_validation THEN
2598:
2599: -- No action necessary. Validation can continue to next attribute/column

Line 2602: WHEN okl_api.g_exception_error THEN

2598:
2599: -- No action necessary. Validation can continue to next attribute/column
2600:
2601: NULL;
2602: WHEN okl_api.g_exception_error THEN
2603: x_return_status := okl_api.handle_exceptions(l_api_name
2604: ,g_pkg_name
2605: ,'OKL_API.G_RET_STS_ERROR'
2606: ,x_msg_count

Line 2603: x_return_status := okl_api.handle_exceptions(l_api_name

2599: -- No action necessary. Validation can continue to next attribute/column
2600:
2601: NULL;
2602: WHEN okl_api.g_exception_error THEN
2603: x_return_status := okl_api.handle_exceptions(l_api_name
2604: ,g_pkg_name
2605: ,'OKL_API.G_RET_STS_ERROR'
2606: ,x_msg_count
2607: ,x_msg_data

Line 2605: ,'OKL_API.G_RET_STS_ERROR'

2601: NULL;
2602: WHEN okl_api.g_exception_error THEN
2603: x_return_status := okl_api.handle_exceptions(l_api_name
2604: ,g_pkg_name
2605: ,'OKL_API.G_RET_STS_ERROR'
2606: ,x_msg_count
2607: ,x_msg_data
2608: ,'_PVT');
2609: WHEN okl_api.g_exception_unexpected_error THEN

Line 2609: WHEN okl_api.g_exception_unexpected_error THEN

2605: ,'OKL_API.G_RET_STS_ERROR'
2606: ,x_msg_count
2607: ,x_msg_data
2608: ,'_PVT');
2609: WHEN okl_api.g_exception_unexpected_error THEN
2610: x_return_status := okl_api.handle_exceptions(l_api_name
2611: ,g_pkg_name
2612: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2613: ,x_msg_count

Line 2610: x_return_status := okl_api.handle_exceptions(l_api_name

2606: ,x_msg_count
2607: ,x_msg_data
2608: ,'_PVT');
2609: WHEN okl_api.g_exception_unexpected_error THEN
2610: x_return_status := okl_api.handle_exceptions(l_api_name
2611: ,g_pkg_name
2612: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2613: ,x_msg_count
2614: ,x_msg_data

Line 2612: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2608: ,'_PVT');
2609: WHEN okl_api.g_exception_unexpected_error THEN
2610: x_return_status := okl_api.handle_exceptions(l_api_name
2611: ,g_pkg_name
2612: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2613: ,x_msg_count
2614: ,x_msg_data
2615: ,'_PVT');
2616: WHEN OTHERS THEN

Line 2617: x_return_status := okl_api.handle_exceptions(l_api_name

2613: ,x_msg_count
2614: ,x_msg_data
2615: ,'_PVT');
2616: WHEN OTHERS THEN
2617: x_return_status := okl_api.handle_exceptions(l_api_name
2618: ,g_pkg_name
2619: ,'OTHERS'
2620: ,x_msg_count
2621: ,x_msg_data

Line 2630: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

2626: -- Procedure delete_row_v
2627: --------------------------------------------------------------------------------
2628:
2629: PROCEDURE delete_row(p_api_version IN number
2630: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
2631: ,x_return_status OUT NOCOPY varchar2
2632: ,x_msg_count OUT NOCOPY number
2633: ,x_msg_data OUT NOCOPY varchar2
2634: ,p_eccv_rec IN okl_eccv_rec) IS

Line 2637: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

2633: ,x_msg_data OUT NOCOPY varchar2
2634: ,p_eccv_rec IN okl_eccv_rec) IS
2635: l_api_version CONSTANT number := 1;
2636: l_api_name CONSTANT varchar2(30) := 'v_delete_row';
2637: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2638: l_eccv_rec okl_eccv_rec := p_eccv_rec;
2639: l_eccb_rec okl_eccb_rec;
2640: l_ecctl_rec okl_ecctl_rec;
2641:

Line 2643: l_return_status := okl_api.start_activity(l_api_name

2639: l_eccb_rec okl_eccb_rec;
2640: l_ecctl_rec okl_ecctl_rec;
2641:
2642: BEGIN
2643: l_return_status := okl_api.start_activity(l_api_name
2644: ,g_pkg_name
2645: ,p_init_msg_list
2646: ,l_api_version
2647: ,p_api_version

Line 2651: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2647: ,p_api_version
2648: ,'_PVT'
2649: ,x_return_status);
2650:
2651: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2652: RAISE okl_api.g_exception_unexpected_error;
2653: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2654: RAISE okl_api.g_exception_error;
2655: END IF;

Line 2652: RAISE okl_api.g_exception_unexpected_error;

2648: ,'_PVT'
2649: ,x_return_status);
2650:
2651: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2652: RAISE okl_api.g_exception_unexpected_error;
2653: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2654: RAISE okl_api.g_exception_error;
2655: END IF;
2656: migrate(l_eccv_rec, l_eccb_rec);

Line 2653: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2649: ,x_return_status);
2650:
2651: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2652: RAISE okl_api.g_exception_unexpected_error;
2653: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2654: RAISE okl_api.g_exception_error;
2655: END IF;
2656: migrate(l_eccv_rec, l_eccb_rec);
2657: migrate(l_eccv_rec, l_ecctl_rec);

Line 2654: RAISE okl_api.g_exception_error;

2650:
2651: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2652: RAISE okl_api.g_exception_unexpected_error;
2653: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2654: RAISE okl_api.g_exception_error;
2655: END IF;
2656: migrate(l_eccv_rec, l_eccb_rec);
2657: migrate(l_eccv_rec, l_ecctl_rec);
2658: delete_row(p_api_version

Line 2665: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2661: ,x_msg_count
2662: ,x_msg_data
2663: ,l_eccb_rec);
2664:
2665: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2666: RAISE okl_api.g_exception_unexpected_error;
2667: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2668: RAISE okl_api.g_exception_error;
2669: END IF;

Line 2666: RAISE okl_api.g_exception_unexpected_error;

2662: ,x_msg_data
2663: ,l_eccb_rec);
2664:
2665: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2666: RAISE okl_api.g_exception_unexpected_error;
2667: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2668: RAISE okl_api.g_exception_error;
2669: END IF;
2670: delete_row(p_api_version

Line 2667: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2663: ,l_eccb_rec);
2664:
2665: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2666: RAISE okl_api.g_exception_unexpected_error;
2667: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2668: RAISE okl_api.g_exception_error;
2669: END IF;
2670: delete_row(p_api_version
2671: ,p_init_msg_list

Line 2668: RAISE okl_api.g_exception_error;

2664:
2665: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2666: RAISE okl_api.g_exception_unexpected_error;
2667: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2668: RAISE okl_api.g_exception_error;
2669: END IF;
2670: delete_row(p_api_version
2671: ,p_init_msg_list
2672: ,l_return_status

Line 2677: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2673: ,x_msg_count
2674: ,x_msg_data
2675: ,l_ecctl_rec);
2676:
2677: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2678: RAISE okl_api.g_exception_unexpected_error;
2679: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2680: RAISE okl_api.g_exception_error;
2681: END IF;

Line 2678: RAISE okl_api.g_exception_unexpected_error;

2674: ,x_msg_data
2675: ,l_ecctl_rec);
2676:
2677: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2678: RAISE okl_api.g_exception_unexpected_error;
2679: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2680: RAISE okl_api.g_exception_error;
2681: END IF;
2682: x_return_status := l_return_status;

Line 2679: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2675: ,l_ecctl_rec);
2676:
2677: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2678: RAISE okl_api.g_exception_unexpected_error;
2679: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2680: RAISE okl_api.g_exception_error;
2681: END IF;
2682: x_return_status := l_return_status;
2683: okl_api.end_activity(x_msg_count, x_msg_data);

Line 2680: RAISE okl_api.g_exception_error;

2676:
2677: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2678: RAISE okl_api.g_exception_unexpected_error;
2679: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2680: RAISE okl_api.g_exception_error;
2681: END IF;
2682: x_return_status := l_return_status;
2683: okl_api.end_activity(x_msg_count, x_msg_data);
2684: EXCEPTION

Line 2683: okl_api.end_activity(x_msg_count, x_msg_data);

2679: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2680: RAISE okl_api.g_exception_error;
2681: END IF;
2682: x_return_status := l_return_status;
2683: okl_api.end_activity(x_msg_count, x_msg_data);
2684: EXCEPTION
2685: WHEN g_exception_halt_validation THEN
2686:
2687: -- No action necessary. Validation can continue to next attribute/column

Line 2690: WHEN okl_api.g_exception_error THEN

2686:
2687: -- No action necessary. Validation can continue to next attribute/column
2688:
2689: NULL;
2690: WHEN okl_api.g_exception_error THEN
2691: x_return_status := okl_api.handle_exceptions(l_api_name
2692: ,g_pkg_name
2693: ,'OKL_API.G_RET_STS_ERROR'
2694: ,x_msg_count

Line 2691: x_return_status := okl_api.handle_exceptions(l_api_name

2687: -- No action necessary. Validation can continue to next attribute/column
2688:
2689: NULL;
2690: WHEN okl_api.g_exception_error THEN
2691: x_return_status := okl_api.handle_exceptions(l_api_name
2692: ,g_pkg_name
2693: ,'OKL_API.G_RET_STS_ERROR'
2694: ,x_msg_count
2695: ,x_msg_data

Line 2693: ,'OKL_API.G_RET_STS_ERROR'

2689: NULL;
2690: WHEN okl_api.g_exception_error THEN
2691: x_return_status := okl_api.handle_exceptions(l_api_name
2692: ,g_pkg_name
2693: ,'OKL_API.G_RET_STS_ERROR'
2694: ,x_msg_count
2695: ,x_msg_data
2696: ,'_PVT');
2697: WHEN okl_api.g_exception_unexpected_error THEN

Line 2697: WHEN okl_api.g_exception_unexpected_error THEN

2693: ,'OKL_API.G_RET_STS_ERROR'
2694: ,x_msg_count
2695: ,x_msg_data
2696: ,'_PVT');
2697: WHEN okl_api.g_exception_unexpected_error THEN
2698: x_return_status := okl_api.handle_exceptions(l_api_name
2699: ,g_pkg_name
2700: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2701: ,x_msg_count

Line 2698: x_return_status := okl_api.handle_exceptions(l_api_name

2694: ,x_msg_count
2695: ,x_msg_data
2696: ,'_PVT');
2697: WHEN okl_api.g_exception_unexpected_error THEN
2698: x_return_status := okl_api.handle_exceptions(l_api_name
2699: ,g_pkg_name
2700: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2701: ,x_msg_count
2702: ,x_msg_data

Line 2700: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2696: ,'_PVT');
2697: WHEN okl_api.g_exception_unexpected_error THEN
2698: x_return_status := okl_api.handle_exceptions(l_api_name
2699: ,g_pkg_name
2700: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2701: ,x_msg_count
2702: ,x_msg_data
2703: ,'_PVT');
2704: WHEN OTHERS THEN

Line 2705: x_return_status := okl_api.handle_exceptions(l_api_name

2701: ,x_msg_count
2702: ,x_msg_data
2703: ,'_PVT');
2704: WHEN OTHERS THEN
2705: x_return_status := okl_api.handle_exceptions(l_api_name
2706: ,g_pkg_name
2707: ,'OTHERS'
2708: ,x_msg_count
2709: ,x_msg_data

Line 2718: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

2714: -- Procedure delete_row_tbl
2715: --------------------------------------------------------------------------------
2716:
2717: PROCEDURE delete_row(p_api_version IN number
2718: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
2719: ,x_return_status OUT NOCOPY varchar2
2720: ,x_msg_count OUT NOCOPY number
2721: ,x_msg_data OUT NOCOPY varchar2
2722: ,p_eccv_tbl IN okl_eccv_tbl) IS

Line 2725: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

2721: ,x_msg_data OUT NOCOPY varchar2
2722: ,p_eccv_tbl IN okl_eccv_tbl) IS
2723: l_api_version CONSTANT number := 1;
2724: l_api_name CONSTANT varchar2(30) := 'tbl_delete_row';
2725: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2726: i number := 0;
2727: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;
2728:
2729: BEGIN

Line 2727: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;

2723: l_api_version CONSTANT number := 1;
2724: l_api_name CONSTANT varchar2(30) := 'tbl_delete_row';
2725: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2726: i number := 0;
2727: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;
2728:
2729: BEGIN
2730: okl_api.init_msg_list(p_init_msg_list);
2731:

Line 2730: okl_api.init_msg_list(p_init_msg_list);

2726: i number := 0;
2727: l_overall_status varchar2(1) := okl_api.g_ret_sts_success;
2728:
2729: BEGIN
2730: okl_api.init_msg_list(p_init_msg_list);
2731:
2732: -- Make sure PL/SQL table has records in it before passing
2733:
2734: IF (p_eccv_tbl.COUNT > 0) THEN

Line 2739: ,p_init_msg_list => okl_api.g_false

2735: i := p_eccv_tbl.FIRST;
2736:
2737: LOOP
2738: delete_row(p_api_version => p_api_version
2739: ,p_init_msg_list => okl_api.g_false
2740: ,x_return_status => x_return_status
2741: ,x_msg_count => x_msg_count
2742: ,x_msg_data => x_msg_data
2743: ,p_eccv_rec => p_eccv_tbl(i));

Line 2744: IF x_return_status <> okl_api.g_ret_sts_success THEN

2740: ,x_return_status => x_return_status
2741: ,x_msg_count => x_msg_count
2742: ,x_msg_data => x_msg_data
2743: ,p_eccv_rec => p_eccv_tbl(i));
2744: IF x_return_status <> okl_api.g_ret_sts_success THEN
2745: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
2746: l_overall_status := x_return_status;
2747: END IF;
2748: END IF;

Line 2745: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN

2741: ,x_msg_count => x_msg_count
2742: ,x_msg_data => x_msg_data
2743: ,p_eccv_rec => p_eccv_tbl(i));
2744: IF x_return_status <> okl_api.g_ret_sts_success THEN
2745: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
2746: l_overall_status := x_return_status;
2747: END IF;
2748: END IF;
2749: EXIT WHEN(i = p_eccv_tbl.LAST);

Line 2761: WHEN okl_api.g_exception_error THEN

2757:
2758: -- No action necessary. Validation can continue to next attribute/column
2759:
2760: NULL;
2761: WHEN okl_api.g_exception_error THEN
2762: x_return_status := okl_api.handle_exceptions(l_api_name
2763: ,g_pkg_name
2764: ,'OKL_API.G_RET_STS_ERROR'
2765: ,x_msg_count

Line 2762: x_return_status := okl_api.handle_exceptions(l_api_name

2758: -- No action necessary. Validation can continue to next attribute/column
2759:
2760: NULL;
2761: WHEN okl_api.g_exception_error THEN
2762: x_return_status := okl_api.handle_exceptions(l_api_name
2763: ,g_pkg_name
2764: ,'OKL_API.G_RET_STS_ERROR'
2765: ,x_msg_count
2766: ,x_msg_data

Line 2764: ,'OKL_API.G_RET_STS_ERROR'

2760: NULL;
2761: WHEN okl_api.g_exception_error THEN
2762: x_return_status := okl_api.handle_exceptions(l_api_name
2763: ,g_pkg_name
2764: ,'OKL_API.G_RET_STS_ERROR'
2765: ,x_msg_count
2766: ,x_msg_data
2767: ,'_PVT');
2768: WHEN okl_api.g_exception_unexpected_error THEN

Line 2768: WHEN okl_api.g_exception_unexpected_error THEN

2764: ,'OKL_API.G_RET_STS_ERROR'
2765: ,x_msg_count
2766: ,x_msg_data
2767: ,'_PVT');
2768: WHEN okl_api.g_exception_unexpected_error THEN
2769: x_return_status := okl_api.handle_exceptions(l_api_name
2770: ,g_pkg_name
2771: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2772: ,x_msg_count

Line 2769: x_return_status := okl_api.handle_exceptions(l_api_name

2765: ,x_msg_count
2766: ,x_msg_data
2767: ,'_PVT');
2768: WHEN okl_api.g_exception_unexpected_error THEN
2769: x_return_status := okl_api.handle_exceptions(l_api_name
2770: ,g_pkg_name
2771: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2772: ,x_msg_count
2773: ,x_msg_data

Line 2771: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2767: ,'_PVT');
2768: WHEN okl_api.g_exception_unexpected_error THEN
2769: x_return_status := okl_api.handle_exceptions(l_api_name
2770: ,g_pkg_name
2771: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2772: ,x_msg_count
2773: ,x_msg_data
2774: ,'_PVT');
2775: WHEN OTHERS THEN

Line 2776: x_return_status := okl_api.handle_exceptions(l_api_name

2772: ,x_msg_count
2773: ,x_msg_data
2774: ,'_PVT');
2775: WHEN OTHERS THEN
2776: x_return_status := okl_api.handle_exceptions(l_api_name
2777: ,g_pkg_name
2778: ,'OTHERS'
2779: ,x_msg_count
2780: ,x_msg_data

Line 3011: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

3007: p_owner IN VARCHAR2,
3008: p_last_update_date IN VARCHAR2) IS
3009: l_api_version CONSTANT number := 1;
3010: l_api_name CONSTANT varchar2(30) := 'LOAD_SEED_ROW';
3011: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
3012: l_msg_count number;
3013: l_msg_data varchar2(4000);
3014: l_init_msg_list VARCHAR2(1):= 'T';
3015: l_eccv_rec okl_eccv_rec;