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_ETH_PVT dependencies on OKC_API

Line 120: okc_api.set_message(p_app_name => g_app_name

116: WHEN OTHERS THEN
117:
118: -- store SQL error message on message stack for caller
119:
120: okc_api.set_message(p_app_name => g_app_name
121: ,p_msg_name => g_unexpected_error
122: ,p_token1 => g_sqlcode_token
123: ,p_token1_value => sqlcode
124: ,p_token2 => g_sqlerrm_token

Line 129: x_return_status := okc_api.g_ret_sts_unexp_error;

125: ,p_token2_value => sqlerrm);
126:
127: -- notify caller of an UNEXPECTED error
128:
129: x_return_status := okc_api.g_ret_sts_unexp_error;
130: END validate_end_of_term_id;
131:
132: PROCEDURE validate_object_version_number(x_return_status OUT NOCOPY VARCHAR2
133: ,p_ethv_rec IN okl_ethv_rec) IS

Line 168: okc_api.set_message(p_app_name => g_app_name

164: WHEN OTHERS THEN
165:
166: -- store SQL error message on message stack for caller
167:
168: okc_api.set_message(p_app_name => g_app_name
169: ,p_msg_name => g_unexpected_error
170: ,p_token1 => g_sqlcode_token
171: ,p_token1_value => sqlcode
172: ,p_token2 => g_sqlerrm_token

Line 177: x_return_status := okc_api.g_ret_sts_unexp_error;

173: ,p_token2_value => sqlerrm);
174:
175: -- notify caller of an UNEXPECTED error
176:
177: x_return_status := okc_api.g_ret_sts_unexp_error;
178: END validate_object_version_number;
179:
180: PROCEDURE validate_org_id(x_return_status OUT NOCOPY VARCHAR2
181: ,p_ethv_rec IN okl_ethv_rec) IS

Line 187: x_return_status := okc_api.g_ret_sts_success;

183: BEGIN
184:
185: -- initialize return status
186:
187: x_return_status := okc_api.g_ret_sts_success;
188:
189: -- check org id validity using the generic function okl_util.check_org_id()
190:
191: x_return_status := okl_util.check_org_id(p_ethv_rec.org_id);

Line 193: IF (x_return_status = okc_api.g_ret_sts_error) THEN

189: -- check org id validity using the generic function okl_util.check_org_id()
190:
191: x_return_status := okl_util.check_org_id(p_ethv_rec.org_id);
192:
193: IF (x_return_status = okc_api.g_ret_sts_error) THEN
194: okc_api.set_message(p_app_name => g_app_name
195: ,p_msg_name => g_invalid_value
196: ,p_token1 => g_col_name_token
197: ,p_token1_value => 'org_id');

Line 194: okc_api.set_message(p_app_name => g_app_name

190:
191: x_return_status := okl_util.check_org_id(p_ethv_rec.org_id);
192:
193: IF (x_return_status = okc_api.g_ret_sts_error) THEN
194: okc_api.set_message(p_app_name => g_app_name
195: ,p_msg_name => g_invalid_value
196: ,p_token1 => g_col_name_token
197: ,p_token1_value => 'org_id');
198:

Line 202: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN

198:
199: -- notify caller of an error
200:
201: RAISE g_exception_halt_validation;
202: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
203:
204: -- notify caller of an error
205:
206: RAISE g_exception_halt_validation;

Line 228: x_return_status := okc_api.g_ret_sts_unexp_error;

224: ,p_token2_value => sqlerrm);
225:
226: -- notify caller of an UNEXPECTED error
227:
228: x_return_status := okc_api.g_ret_sts_unexp_error;
229: END validate_org_id;
230:
231: PROCEDURE validate_currency_code(x_return_status OUT NOCOPY VARCHAR2
232: ,p_ethv_rec IN okl_ethv_rec) IS

Line 238: x_return_status := okc_api.g_ret_sts_success;

234: BEGIN
235:
236: -- initialize return status
237:
238: x_return_status := okc_api.g_ret_sts_success;
239:
240: -- data is required
241:
242: IF (p_ethv_rec.currency_code IS NOT NULL) AND (p_ethv_rec.currency_code <> okc_api.g_miss_char) THEN

Line 242: IF (p_ethv_rec.currency_code IS NOT NULL) AND (p_ethv_rec.currency_code <> okc_api.g_miss_char) THEN

238: x_return_status := okc_api.g_ret_sts_success;
239:
240: -- data is required
241:
242: IF (p_ethv_rec.currency_code IS NOT NULL) AND (p_ethv_rec.currency_code <> okc_api.g_miss_char) THEN
243:
244: x_return_status := okl_accounting_util.validate_currency_code(p_ethv_rec.currency_code);
245:
246: IF (x_return_status <> okl_api.g_true) THEN

Line 247: okc_api.set_message(p_app_name => g_app_name

243:
244: x_return_status := okl_accounting_util.validate_currency_code(p_ethv_rec.currency_code);
245:
246: IF (x_return_status <> okl_api.g_true) THEN
247: okc_api.set_message(p_app_name => g_app_name
248: ,p_msg_name => g_invalid_value
249: ,p_token1 => g_col_name_token
250: ,p_token1_value => 'currency_code');
251:

Line 260: x_return_status := okc_api.g_ret_sts_error;

256: END IF;
257:
258: EXCEPTION
259: WHEN g_exception_halt_validation THEN
260: x_return_status := okc_api.g_ret_sts_error;
261: WHEN OTHERS THEN
262:
263: -- store SQL error message on message stack for caller
264:

Line 265: okc_api.set_message(p_app_name => g_app_name

261: WHEN OTHERS THEN
262:
263: -- store SQL error message on message stack for caller
264:
265: okc_api.set_message(p_app_name => g_app_name
266: ,p_msg_name => g_unexpected_error
267: ,p_token1 => g_sqlcode_token
268: ,p_token1_value => sqlcode
269: ,p_token2 => g_sqlerrm_token

Line 274: x_return_status := okc_api.g_ret_sts_unexp_error;

270: ,p_token2_value => sqlerrm);
271:
272: -- notify caller of an UNEXPECTED error
273:
274: x_return_status := okc_api.g_ret_sts_unexp_error;
275: END validate_currency_code;
276:
277: PROCEDURE validate_eot_type_code(x_return_status OUT NOCOPY VARCHAR2
278: ,p_ethv_rec IN okl_ethv_rec) IS

Line 284: x_return_status := okc_api.g_ret_sts_success;

280: BEGIN
281:
282: -- initialize return status
283:
284: x_return_status := okc_api.g_ret_sts_success;
285:
286: -- data is required
287:
288: IF (p_ethv_rec.eot_type_code IS NULL) OR (p_ethv_rec.eot_type_code = okc_api.g_miss_char) THEN

Line 288: IF (p_ethv_rec.eot_type_code IS NULL) OR (p_ethv_rec.eot_type_code = okc_api.g_miss_char) THEN

284: x_return_status := okc_api.g_ret_sts_success;
285:
286: -- data is required
287:
288: IF (p_ethv_rec.eot_type_code IS NULL) OR (p_ethv_rec.eot_type_code = okc_api.g_miss_char) THEN
289: okc_api.set_message(p_app_name => g_app_name
290: ,p_msg_name => g_required_value
291: ,p_token1 => g_col_name_token
292: ,p_token1_value => 'EOT_TYPE_CODE');

Line 289: okc_api.set_message(p_app_name => g_app_name

285:
286: -- data is required
287:
288: IF (p_ethv_rec.eot_type_code IS NULL) OR (p_ethv_rec.eot_type_code = okc_api.g_miss_char) THEN
289: okc_api.set_message(p_app_name => g_app_name
290: ,p_msg_name => g_required_value
291: ,p_token1 => g_col_name_token
292: ,p_token1_value => 'EOT_TYPE_CODE');
293:

Line 296: x_return_status := okc_api.g_ret_sts_error;

292: ,p_token1_value => 'EOT_TYPE_CODE');
293:
294: -- notify caller of an error
295:
296: x_return_status := okc_api.g_ret_sts_error;
297:
298: -- halt further validation of this column
299:
300: RAISE g_exception_halt_validation;

Line 308: IF (x_return_status = okc_api.g_ret_sts_error) THEN

304:
305: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_RESIDUAL_TYPES'
306: ,p_lookup_code => p_ethv_rec.eot_type_code);
307:
308: IF (x_return_status = okc_api.g_ret_sts_error) THEN
309: okc_api.set_message(p_app_name => g_app_name
310: ,p_msg_name => g_invalid_value
311: ,p_token1 => g_col_name_token
312: ,p_token1_value => 'EOT_TYPE_CODE'); -- notify caller of an error

Line 309: okc_api.set_message(p_app_name => g_app_name

305: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_RESIDUAL_TYPES'
306: ,p_lookup_code => p_ethv_rec.eot_type_code);
307:
308: IF (x_return_status = okc_api.g_ret_sts_error) THEN
309: okc_api.set_message(p_app_name => g_app_name
310: ,p_msg_name => g_invalid_value
311: ,p_token1 => g_col_name_token
312: ,p_token1_value => 'EOT_TYPE_CODE'); -- notify caller of an error
313: RAISE g_exception_halt_validation;

Line 314: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN

310: ,p_msg_name => g_invalid_value
311: ,p_token1 => g_col_name_token
312: ,p_token1_value => 'EOT_TYPE_CODE'); -- notify caller of an error
313: RAISE g_exception_halt_validation;
314: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
315:
316: -- notify caller of an error
317:
318: x_return_status := okc_api.g_ret_sts_unexp_error;

Line 318: x_return_status := okc_api.g_ret_sts_unexp_error;

314: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
315:
316: -- notify caller of an error
317:
318: x_return_status := okc_api.g_ret_sts_unexp_error;
319: RAISE g_exception_halt_validation;
320: END IF;
321:
322: EXCEPTION

Line 333: okc_api.set_message(p_app_name => g_app_name

329: WHEN OTHERS THEN
330:
331: -- store SQL error message on message stack for caller
332:
333: okc_api.set_message(p_app_name => g_app_name
334: ,p_msg_name => g_unexpected_error
335: ,p_token1 => g_sqlcode_token
336: ,p_token1_value => sqlcode
337: ,p_token2 => g_sqlerrm_token

Line 358: x_return_status := okc_api.g_ret_sts_success;

354: BEGIN
355:
356: -- initialize return status
357:
358: x_return_status := okc_api.g_ret_sts_success;
359:
360: -- data is required
361:
362: IF (p_ethv_rec.product_id IS NULL) OR (p_ethv_rec.product_id = okc_api.g_miss_num) THEN

Line 362: IF (p_ethv_rec.product_id IS NULL) OR (p_ethv_rec.product_id = okc_api.g_miss_num) THEN

358: x_return_status := okc_api.g_ret_sts_success;
359:
360: -- data is required
361:
362: IF (p_ethv_rec.product_id IS NULL) OR (p_ethv_rec.product_id = okc_api.g_miss_num) THEN
363: okc_api.set_message(p_app_name => g_app_name
364: ,p_msg_name => g_required_value
365: ,p_token1 => g_col_name_token
366: ,p_token1_value => 'product_id');

Line 363: okc_api.set_message(p_app_name => g_app_name

359:
360: -- data is required
361:
362: IF (p_ethv_rec.product_id IS NULL) OR (p_ethv_rec.product_id = okc_api.g_miss_num) THEN
363: okc_api.set_message(p_app_name => g_app_name
364: ,p_msg_name => g_required_value
365: ,p_token1 => g_col_name_token
366: ,p_token1_value => 'product_id');
367:

Line 386: okc_api.set_message(p_app_name => g_app_name

382:
383: -- if l_dummy_var is still set to default, data was not found
384:
385: IF (l_dummy_var = '?') THEN
386: okc_api.set_message(p_app_name => g_app_name
387: ,p_msg_name => g_invalid_value
388: ,p_token1 => g_col_name_token
389: ,p_token1_value => 'product_id');
390:

Line 393: x_return_status := okc_api.g_ret_sts_error;

389: ,p_token1_value => 'product_id');
390:
391: -- notify caller of an error
392:
393: x_return_status := okc_api.g_ret_sts_error;
394: END IF;
395:
396: EXCEPTION
397: WHEN g_exception_halt_validation THEN

Line 407: okc_api.set_message(p_app_name => g_app_name

403: WHEN OTHERS THEN
404:
405: -- store SQL error message on message stack for caller
406:
407: okc_api.set_message(p_app_name => g_app_name
408: ,p_msg_name => g_unexpected_error
409: ,p_token1 => g_sqlcode_token
410: ,p_token1_value => sqlcode
411: ,p_token2 => g_sqlerrm_token

Line 416: x_return_status := okc_api.g_ret_sts_unexp_error;

412: ,p_token2_value => sqlerrm);
413:
414: -- notify caller of an UNEXPECTED error
415:
416: x_return_status := okc_api.g_ret_sts_unexp_error;
417:
418: -- verify that cursor was closed
419:
420: IF product_id_exists_csr%ISOPEN THEN

Line 433: x_return_status := okc_api.g_ret_sts_success;

429: BEGIN
430:
431: -- initialize return status
432:
433: x_return_status := okc_api.g_ret_sts_success;
434:
435: -- data is required
436:
437: IF (p_ethv_rec.category_type_code IS NULL) OR (p_ethv_rec.category_type_code = okc_api.g_miss_char) THEN

Line 437: IF (p_ethv_rec.category_type_code IS NULL) OR (p_ethv_rec.category_type_code = okc_api.g_miss_char) THEN

433: x_return_status := okc_api.g_ret_sts_success;
434:
435: -- data is required
436:
437: IF (p_ethv_rec.category_type_code IS NULL) OR (p_ethv_rec.category_type_code = okc_api.g_miss_char) THEN
438: okc_api.set_message(p_app_name => g_app_name
439: ,p_msg_name => g_required_value
440: ,p_token1 => g_col_name_token
441: ,p_token1_value => 'CATEGORY_TYPE_CODE');

Line 438: okc_api.set_message(p_app_name => g_app_name

434:
435: -- data is required
436:
437: IF (p_ethv_rec.category_type_code IS NULL) OR (p_ethv_rec.category_type_code = okc_api.g_miss_char) THEN
438: okc_api.set_message(p_app_name => g_app_name
439: ,p_msg_name => g_required_value
440: ,p_token1 => g_col_name_token
441: ,p_token1_value => 'CATEGORY_TYPE_CODE');
442:

Line 457: IF (x_return_status = okc_api.g_ret_sts_error) THEN

453:
454: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_SOURCE_TYPES'
455: ,p_lookup_code => p_ethv_rec.category_type_code);
456:
457: IF (x_return_status = okc_api.g_ret_sts_error) THEN
458: okc_api.set_message(p_app_name => g_app_name
459: ,p_msg_name => g_invalid_value
460: ,p_token1 => g_col_name_token
461: ,p_token1_value => 'CATEGORY_TYPE_CODE'); -- notify caller of an error

Line 458: okc_api.set_message(p_app_name => g_app_name

454: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_SOURCE_TYPES'
455: ,p_lookup_code => p_ethv_rec.category_type_code);
456:
457: IF (x_return_status = okc_api.g_ret_sts_error) THEN
458: okc_api.set_message(p_app_name => g_app_name
459: ,p_msg_name => g_invalid_value
460: ,p_token1 => g_col_name_token
461: ,p_token1_value => 'CATEGORY_TYPE_CODE'); -- notify caller of an error
462: RAISE g_exception_halt_validation;

Line 463: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN

459: ,p_msg_name => g_invalid_value
460: ,p_token1 => g_col_name_token
461: ,p_token1_value => 'CATEGORY_TYPE_CODE'); -- notify caller of an error
462: RAISE g_exception_halt_validation;
463: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
464:
465: -- notify caller of an error
466:
467: x_return_status := okc_api.g_ret_sts_unexp_error;

Line 467: x_return_status := okc_api.g_ret_sts_unexp_error;

463: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
464:
465: -- notify caller of an error
466:
467: x_return_status := okc_api.g_ret_sts_unexp_error;
468: RAISE g_exception_halt_validation;
469: END IF;
470:
471: EXCEPTION

Line 482: okc_api.set_message(p_app_name => g_app_name

478: WHEN OTHERS THEN
479:
480: -- store SQL error message on message stack for caller
481:
482: okc_api.set_message(p_app_name => g_app_name
483: ,p_msg_name => g_unexpected_error
484: ,p_token1 => g_sqlcode_token
485: ,p_token1_value => sqlcode
486: ,p_token2 => g_sqlerrm_token

Line 491: x_return_status := okc_api.g_ret_sts_unexp_error;

487: ,p_token2_value => sqlerrm);
488:
489: -- notify caller of an UNEXPECTED error
490:
491: x_return_status := okc_api.g_ret_sts_unexp_error;
492: END validate_category_type_code;
493:
494: PROCEDURE validate_orig_end_of_term_id(x_return_status OUT NOCOPY VARCHAR2
495: ,p_ethv_rec IN okl_ethv_rec) IS

Line 524: x_return_status := okc_api.g_ret_sts_error;

520: ,p_token1_value => 'ORIG_END_OF_TERM_ID');
521:
522: -- notify caller of an error
523:
524: x_return_status := okc_api.g_ret_sts_error;
525: RAISE g_exception_halt_validation;
526: END IF;
527: END IF;
528:

Line 540: okc_api.set_message(p_app_name => g_app_name

536: WHEN OTHERS THEN
537:
538: -- store SQL error message on message stack for caller
539:
540: okc_api.set_message(p_app_name => g_app_name
541: ,p_msg_name => g_unexpected_error
542: ,p_token1 => g_sqlcode_token
543: ,p_token1_value => sqlcode
544: ,p_token2 => g_sqlerrm_token

Line 549: x_return_status := okc_api.g_ret_sts_unexp_error;

545: ,p_token2_value => sqlerrm);
546:
547: -- notify caller of an UNEXPECTED error
548:
549: x_return_status := okc_api.g_ret_sts_unexp_error;
550:
551: -- verify that cursor was closed
552:
553: IF pos_exists_csr%ISOPEN THEN

Line 591: okc_api.set_message(p_app_name => g_app_name

587: WHEN OTHERS THEN
588:
589: -- store SQL error message on message stack for caller
590:
591: okc_api.set_message(p_app_name => g_app_name
592: ,p_msg_name => g_unexpected_error
593: ,p_token1 => g_sqlcode_token
594: ,p_token1_value => sqlcode
595: ,p_token2 => g_sqlerrm_token

Line 600: x_return_status := okc_api.g_ret_sts_unexp_error;

596: ,p_token2_value => sqlerrm);
597:
598: -- notify caller of an UNEXPECTED error
599:
600: x_return_status := okc_api.g_ret_sts_unexp_error;
601: END validate_effective_from_date;
602:
603: PROCEDURE validate_sts_code(x_return_status OUT NOCOPY VARCHAR2
604: ,p_ethv_rec IN okl_ethv_rec) IS

Line 631: IF (x_return_status = okc_api.g_ret_sts_error) THEN

627:
628: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_PRC_STATUS'
629: ,p_lookup_code => p_ethv_rec.sts_code);
630:
631: IF (x_return_status = okc_api.g_ret_sts_error) THEN
632: okc_api.set_message(p_app_name => g_app_name
633: ,p_msg_name => g_invalid_value
634: ,p_token1 => g_col_name_token
635: ,p_token1_value => 'sts_code'); -- notify caller of an error

Line 632: okc_api.set_message(p_app_name => g_app_name

628: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_PRC_STATUS'
629: ,p_lookup_code => p_ethv_rec.sts_code);
630:
631: IF (x_return_status = okc_api.g_ret_sts_error) THEN
632: okc_api.set_message(p_app_name => g_app_name
633: ,p_msg_name => g_invalid_value
634: ,p_token1 => g_col_name_token
635: ,p_token1_value => 'sts_code'); -- notify caller of an error
636: RAISE g_exception_halt_validation;

Line 637: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN

633: ,p_msg_name => g_invalid_value
634: ,p_token1 => g_col_name_token
635: ,p_token1_value => 'sts_code'); -- notify caller of an error
636: RAISE g_exception_halt_validation;
637: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
638:
639: -- notify caller of an error
640:
641: x_return_status := okc_api.g_ret_sts_unexp_error;

Line 641: x_return_status := okc_api.g_ret_sts_unexp_error;

637: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
638:
639: -- notify caller of an error
640:
641: x_return_status := okc_api.g_ret_sts_unexp_error;
642: RAISE g_exception_halt_validation;
643: END IF;
644:
645: EXCEPTION

Line 656: okc_api.set_message(p_app_name => g_app_name

652: WHEN OTHERS THEN
653:
654: -- store SQL error message on message stack for caller
655:
656: okc_api.set_message(p_app_name => g_app_name
657: ,p_msg_name => g_unexpected_error
658: ,p_token1 => g_sqlcode_token
659: ,p_token1_value => sqlcode
660: ,p_token2 => g_sqlerrm_token

Line 665: x_return_status := okc_api.g_ret_sts_unexp_error;

661: ,p_token2_value => sqlerrm);
662:
663: -- notify caller of an UNEXPECTED error
664:
665: x_return_status := okc_api.g_ret_sts_unexp_error;
666: END validate_sts_code;
667:
668: --------------------------------------------------------------------------------
669: -- Procedure get_rec for OKL_FE_EO_TERMS_ALL_B

Line 1180: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

1176: RETURN(okc_p_util.raw_to_number(sys_guid()));
1177: END get_seq_id;
1178:
1179: FUNCTION validate_attributes(p_ethv_rec IN okl_ethv_rec) RETURN VARCHAR2 IS
1180: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
1181: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1182:
1183: BEGIN
1184:

Line 1192: IF (l_return_status <> okc_api.g_ret_sts_success) THEN

1188: ,p_ethv_rec => p_ethv_rec);
1189:
1190: -- store the highest degree of error
1191:
1192: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1193: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1194: x_return_status := l_return_status;
1195: END IF;
1196: END IF;

Line 1193: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN

1189:
1190: -- store the highest degree of error
1191:
1192: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1193: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1194: x_return_status := l_return_status;
1195: END IF;
1196: END IF;
1197: validate_object_version_number(x_return_status => l_return_status

Line 1202: IF (l_return_status <> okc_api.g_ret_sts_success) THEN

1198: ,p_ethv_rec => p_ethv_rec);
1199:
1200: -- store the highest degree of error
1201:
1202: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1203: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1204: x_return_status := l_return_status;
1205: END IF;
1206: END IF;

Line 1203: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN

1199:
1200: -- store the highest degree of error
1201:
1202: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1203: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1204: x_return_status := l_return_status;
1205: END IF;
1206: END IF;
1207: validate_org_id(x_return_status => l_return_status

Line 1212: IF (l_return_status <> okc_api.g_ret_sts_success) THEN

1208: ,p_ethv_rec => p_ethv_rec);
1209:
1210: -- store the highest degree of error
1211:
1212: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1213: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1214: x_return_status := l_return_status;
1215: END IF;
1216: END IF;

Line 1213: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN

1209:
1210: -- store the highest degree of error
1211:
1212: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1213: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1214: x_return_status := l_return_status;
1215: END IF;
1216: END IF;
1217: validate_currency_code(x_return_status => l_return_status

Line 1222: IF (l_return_status <> okc_api.g_ret_sts_success) THEN

1218: ,p_ethv_rec => p_ethv_rec);
1219:
1220: -- store the highest degree of error
1221:
1222: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1223: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1224: x_return_status := l_return_status;
1225: END IF;
1226: END IF;

Line 1223: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN

1219:
1220: -- store the highest degree of error
1221:
1222: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1223: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1224: x_return_status := l_return_status;
1225: END IF;
1226: END IF;
1227: validate_eot_type_code(x_return_status => l_return_status

Line 1232: IF (l_return_status <> okc_api.g_ret_sts_success) THEN

1228: ,p_ethv_rec => p_ethv_rec);
1229:
1230: -- store the highest degree of error
1231:
1232: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1233: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1234: x_return_status := l_return_status;
1235: END IF;
1236: END IF;

Line 1233: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN

1229:
1230: -- store the highest degree of error
1231:
1232: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1233: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1234: x_return_status := l_return_status;
1235: END IF;
1236: END IF;
1237: validate_product_id(x_return_status => l_return_status

Line 1242: IF (l_return_status <> okc_api.g_ret_sts_success) THEN

1238: ,p_ethv_rec => p_ethv_rec);
1239:
1240: -- store the highest degree of error
1241:
1242: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1243: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1244: x_return_status := l_return_status;
1245: END IF;
1246: END IF;

Line 1243: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN

1239:
1240: -- store the highest degree of error
1241:
1242: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1243: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1244: x_return_status := l_return_status;
1245: END IF;
1246: END IF;
1247: validate_category_type_code(x_return_status => l_return_status

Line 1252: IF (l_return_status <> okc_api.g_ret_sts_success) THEN

1248: ,p_ethv_rec => p_ethv_rec);
1249:
1250: -- store the highest degree of error
1251:
1252: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1253: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1254: x_return_status := l_return_status;
1255: END IF;
1256: END IF;

Line 1253: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN

1249:
1250: -- store the highest degree of error
1251:
1252: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1253: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1254: x_return_status := l_return_status;
1255: END IF;
1256: END IF;
1257: validate_orig_end_of_term_id(x_return_status => l_return_status

Line 1262: IF (l_return_status <> okc_api.g_ret_sts_success) THEN

1258: ,p_ethv_rec => p_ethv_rec);
1259:
1260: -- store the highest degree of error
1261:
1262: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1263: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1264: x_return_status := l_return_status;
1265: END IF;
1266: END IF;

Line 1263: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN

1259:
1260: -- store the highest degree of error
1261:
1262: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1263: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1264: x_return_status := l_return_status;
1265: END IF;
1266: END IF;
1267: validate_sts_code(x_return_status => l_return_status

Line 1272: IF (l_return_status <> okc_api.g_ret_sts_success) THEN

1268: ,p_ethv_rec => p_ethv_rec);
1269:
1270: -- store the highest degree of error
1271:
1272: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1273: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1274: x_return_status := l_return_status;
1275: END IF;
1276: END IF;

Line 1273: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN

1269:
1270: -- store the highest degree of error
1271:
1272: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1273: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1274: x_return_status := l_return_status;
1275: END IF;
1276: END IF;
1277: validate_effective_from_date(x_return_status => l_return_status

Line 1282: IF (l_return_status <> okc_api.g_ret_sts_success) THEN

1278: ,p_ethv_rec => p_ethv_rec);
1279:
1280: -- store the highest degree of error
1281:
1282: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1283: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1284: x_return_status := l_return_status;
1285: END IF;
1286: END IF;

Line 1283: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN

1279:
1280: -- store the highest degree of error
1281:
1282: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1283: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1284: x_return_status := l_return_status;
1285: END IF;
1286: END IF;
1287: RETURN(x_return_status);

Line 1291: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

1287: RETURN(x_return_status);
1288: END validate_attributes;
1289:
1290: FUNCTION validate_record(p_ethv_rec IN okl_ethv_rec) RETURN VARCHAR2 IS
1291: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
1292: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1293:
1294: BEGIN
1295: IF (p_ethv_rec.effective_to_date IS NOT NULL) THEN

Line 1707: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1703: -- Procedure insert_row_b
1704: --------------------------------------------------------------------------------
1705:
1706: PROCEDURE insert_row(p_api_version IN NUMBER
1707: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1708: ,x_return_status OUT NOCOPY VARCHAR2
1709: ,x_msg_count OUT NOCOPY NUMBER
1710: ,x_msg_data OUT NOCOPY VARCHAR2
1711: ,p_ethb_rec IN okl_ethb_rec

Line 1720: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

1716: l_ethb_rec okl_ethb_rec := p_ethb_rec;
1717:
1718: FUNCTION set_attributes(p_ethb_rec IN okl_ethb_rec
1719: ,x_ethb_rec OUT NOCOPY okl_ethb_rec) RETURN VARCHAR2 IS
1720: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
1721:
1722: BEGIN
1723: x_ethb_rec := p_ethb_rec;
1724: RETURN(l_return_status);

Line 1728: l_return_status := okc_api.start_activity(l_api_name

1724: RETURN(l_return_status);
1725: END set_attributes;
1726:
1727: BEGIN
1728: l_return_status := okc_api.start_activity(l_api_name
1729: ,g_pkg_name
1730: ,p_init_msg_list
1731: ,l_api_version
1732: ,p_api_version

Line 1737: RAISE okc_api.g_exception_unexpected_error;

1733: ,'_PVT'
1734: ,x_return_status);
1735:
1736: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1737: RAISE okc_api.g_exception_unexpected_error;
1738: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1739: RAISE okc_api.g_exception_error;
1740: END IF;
1741:

Line 1739: RAISE okc_api.g_exception_error;

1735:
1736: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1737: RAISE okc_api.g_exception_unexpected_error;
1738: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1739: RAISE okc_api.g_exception_error;
1740: END IF;
1741:
1742: --Setting Item Attributes
1743:

Line 1748: RAISE okc_api.g_exception_unexpected_error;

1744: l_return_status := set_attributes(p_ethb_rec
1745: ,l_ethb_rec);
1746:
1747: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1748: RAISE okc_api.g_exception_unexpected_error;
1749: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1750: RAISE okc_api.g_exception_error;
1751: END IF;
1752:

Line 1750: RAISE okc_api.g_exception_error;

1746:
1747: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1748: RAISE okc_api.g_exception_unexpected_error;
1749: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1750: RAISE okc_api.g_exception_error;
1751: END IF;
1752:
1753: INSERT INTO okl_fe_eo_terms_all_b
1754: (end_of_term_id

Line 1824: okc_api.end_activity(x_msg_count

1820:
1821: --Set OUT Values
1822:
1823: x_ethb_rec := l_ethb_rec;
1824: okc_api.end_activity(x_msg_count
1825: ,x_msg_data);
1826: EXCEPTION
1827: WHEN g_exception_halt_validation THEN
1828:

Line 1832: WHEN okc_api.g_exception_error THEN

1828:
1829: -- No action necessary. Validation can continue to next attribute/column
1830:
1831: NULL;
1832: WHEN okc_api.g_exception_error THEN
1833: x_return_status := okl_api.handle_exceptions(l_api_name
1834: ,g_pkg_name
1835: ,'OKL_API.G_RET_STS_ERROR'
1836: ,x_msg_count

Line 1839: WHEN okc_api.g_exception_unexpected_error THEN

1835: ,'OKL_API.G_RET_STS_ERROR'
1836: ,x_msg_count
1837: ,x_msg_data
1838: ,'_PVT');
1839: WHEN okc_api.g_exception_unexpected_error THEN
1840: x_return_status := okl_api.handle_exceptions(l_api_name
1841: ,g_pkg_name
1842: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1843: ,x_msg_count

Line 1860: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1856: -- Procedure insert_row_tl
1857: --------------------------------------------------------------------------------
1858:
1859: PROCEDURE insert_row(p_api_version IN NUMBER
1860: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1861: ,x_return_status OUT NOCOPY VARCHAR2
1862: ,x_msg_count OUT NOCOPY NUMBER
1863: ,x_msg_data OUT NOCOPY VARCHAR2
1864: ,p_ethtl_rec IN okl_ethtl_rec

Line 1878: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

1874: WHERE installed_flag IN('I', 'B');
1875:
1876: FUNCTION set_attributes(p_ethtl_rec IN okl_ethtl_rec
1877: ,x_ethtl_rec OUT NOCOPY okl_ethtl_rec) RETURN VARCHAR2 IS
1878: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
1879:
1880: BEGIN
1881: x_ethtl_rec := p_ethtl_rec;
1882: x_ethtl_rec.sfwt_flag := 'N';

Line 1889: l_return_status := okc_api.start_activity(l_api_name

1885: RETURN(l_return_status);
1886: END set_attributes;
1887:
1888: BEGIN
1889: l_return_status := okc_api.start_activity(l_api_name
1890: ,g_pkg_name
1891: ,p_init_msg_list
1892: ,l_api_version
1893: ,p_api_version

Line 1898: RAISE okc_api.g_exception_unexpected_error;

1894: ,'_PVT'
1895: ,x_return_status);
1896:
1897: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1898: RAISE okc_api.g_exception_unexpected_error;
1899: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1900: RAISE okc_api.g_exception_error;
1901: END IF;
1902:

Line 1900: RAISE okc_api.g_exception_error;

1896:
1897: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1898: RAISE okc_api.g_exception_unexpected_error;
1899: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1900: RAISE okc_api.g_exception_error;
1901: END IF;
1902:
1903: --Setting Item Attributes
1904:

Line 1909: RAISE okc_api.g_exception_unexpected_error;

1905: l_return_status := set_attributes(p_ethtl_rec
1906: ,l_ethtl_rec);
1907:
1908: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1909: RAISE okc_api.g_exception_unexpected_error;
1910: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1911: RAISE okc_api.g_exception_error;
1912: END IF;
1913:

Line 1911: RAISE okc_api.g_exception_error;

1907:
1908: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1909: RAISE okc_api.g_exception_unexpected_error;
1910: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1911: RAISE okc_api.g_exception_error;
1912: END IF;
1913:
1914: FOR l_lang_rec IN get_languages LOOP
1915: l_ethtl_rec.language := l_lang_rec.language_code;

Line 1944: okc_api.end_activity(x_msg_count

1940:
1941: --Set OUT Values
1942:
1943: x_ethtl_rec := l_ethtl_rec;
1944: okc_api.end_activity(x_msg_count
1945: ,x_msg_data);
1946: EXCEPTION
1947: WHEN g_exception_halt_validation THEN
1948:

Line 1952: WHEN okc_api.g_exception_error THEN

1948:
1949: -- No action necessary. Validation can continue to next attribute/column
1950:
1951: NULL;
1952: WHEN okc_api.g_exception_error THEN
1953: x_return_status := okl_api.handle_exceptions(l_api_name
1954: ,g_pkg_name
1955: ,'OKL_API.G_RET_STS_ERROR'
1956: ,x_msg_count

Line 1959: WHEN okc_api.g_exception_unexpected_error THEN

1955: ,'OKL_API.G_RET_STS_ERROR'
1956: ,x_msg_count
1957: ,x_msg_data
1958: ,'_PVT');
1959: WHEN okc_api.g_exception_unexpected_error THEN
1960: x_return_status := okl_api.handle_exceptions(l_api_name
1961: ,g_pkg_name
1962: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1963: ,x_msg_count

Line 1980: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1976: -- Procedure insert_row_v
1977: --------------------------------------------------------------------------------
1978:
1979: PROCEDURE insert_row(p_api_version IN NUMBER
1980: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1981: ,x_return_status OUT NOCOPY VARCHAR2
1982: ,x_msg_count OUT NOCOPY NUMBER
1983: ,x_msg_data OUT NOCOPY VARCHAR2
1984: ,p_ethv_rec IN okl_ethv_rec

Line 2010: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

2006: END fill_who_columns;
2007:
2008: FUNCTION set_attributes(p_ethv_rec IN okl_ethv_rec
2009: ,x_ethv_rec OUT NOCOPY okl_ethv_rec) RETURN VARCHAR2 IS
2010: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
2011:
2012: BEGIN
2013: x_ethv_rec := p_ethv_rec;
2014: x_ethv_rec.object_version_number := 1;

Line 2020: l_return_status := okc_api.start_activity(l_api_name

2016: RETURN(l_return_status);
2017: END set_attributes;
2018:
2019: BEGIN
2020: l_return_status := okc_api.start_activity(l_api_name
2021: ,g_pkg_name
2022: ,p_init_msg_list
2023: ,l_api_version
2024: ,p_api_version

Line 2029: RAISE okc_api.g_exception_unexpected_error;

2025: ,'_PVT'
2026: ,x_return_status);
2027:
2028: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2029: RAISE okc_api.g_exception_unexpected_error;
2030: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2031: RAISE okc_api.g_exception_error;
2032: END IF;
2033: l_ethv_rec := null_out_defaults(p_ethv_rec);

Line 2031: RAISE okc_api.g_exception_error;

2027:
2028: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2029: RAISE okc_api.g_exception_unexpected_error;
2030: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2031: RAISE okc_api.g_exception_error;
2032: END IF;
2033: l_ethv_rec := null_out_defaults(p_ethv_rec);
2034:
2035: -- Set Primary key value

Line 2045: RAISE okc_api.g_exception_unexpected_error;

2041: l_return_status := set_attributes(l_ethv_rec
2042: ,l_def_ethv_rec);
2043:
2044: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2045: RAISE okc_api.g_exception_unexpected_error;
2046: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2047: RAISE okc_api.g_exception_error;
2048: END IF;
2049: l_def_ethv_rec := fill_who_columns(l_def_ethv_rec);

Line 2047: RAISE okc_api.g_exception_error;

2043:
2044: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2045: RAISE okc_api.g_exception_unexpected_error;
2046: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2047: RAISE okc_api.g_exception_error;
2048: END IF;
2049: l_def_ethv_rec := fill_who_columns(l_def_ethv_rec);
2050: l_return_status := validate_attributes(l_def_ethv_rec);
2051:

Line 2053: RAISE okc_api.g_exception_unexpected_error;

2049: l_def_ethv_rec := fill_who_columns(l_def_ethv_rec);
2050: l_return_status := validate_attributes(l_def_ethv_rec);
2051:
2052: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2053: RAISE okc_api.g_exception_unexpected_error;
2054: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2055: RAISE okc_api.g_exception_error;
2056: END IF;
2057: l_return_status := validate_record(l_def_ethv_rec);

Line 2055: RAISE okc_api.g_exception_error;

2051:
2052: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2053: RAISE okc_api.g_exception_unexpected_error;
2054: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2055: RAISE okc_api.g_exception_error;
2056: END IF;
2057: l_return_status := validate_record(l_def_ethv_rec);
2058:
2059: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 2060: RAISE okc_api.g_exception_unexpected_error;

2056: END IF;
2057: l_return_status := validate_record(l_def_ethv_rec);
2058:
2059: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2060: RAISE okc_api.g_exception_unexpected_error;
2061: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2062: RAISE okc_api.g_exception_error;
2063: END IF;
2064: migrate(l_def_ethv_rec

Line 2062: RAISE okc_api.g_exception_error;

2058:
2059: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2060: RAISE okc_api.g_exception_unexpected_error;
2061: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2062: RAISE okc_api.g_exception_error;
2063: END IF;
2064: migrate(l_def_ethv_rec
2065: ,l_ethb_rec);
2066: migrate(l_def_ethv_rec

Line 2077: RAISE okc_api.g_exception_unexpected_error;

2073: ,l_ethb_rec
2074: ,lx_ethb_rec);
2075:
2076: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2077: RAISE okc_api.g_exception_unexpected_error;
2078: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2079: RAISE okc_api.g_exception_error;
2080: END IF;
2081: migrate(lx_ethb_rec

Line 2079: RAISE okc_api.g_exception_error;

2075:
2076: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2077: RAISE okc_api.g_exception_unexpected_error;
2078: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2079: RAISE okc_api.g_exception_error;
2080: END IF;
2081: migrate(lx_ethb_rec
2082: ,l_def_ethv_rec);
2083: insert_row(p_api_version

Line 2092: RAISE okc_api.g_exception_unexpected_error;

2088: ,l_ethtl_rec
2089: ,lx_ethtl_rec);
2090:
2091: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2092: RAISE okc_api.g_exception_unexpected_error;
2093: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2094: RAISE okc_api.g_exception_error;
2095: END IF;
2096: migrate(lx_ethtl_rec

Line 2094: RAISE okc_api.g_exception_error;

2090:
2091: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2092: RAISE okc_api.g_exception_unexpected_error;
2093: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2094: RAISE okc_api.g_exception_error;
2095: END IF;
2096: migrate(lx_ethtl_rec
2097: ,l_def_ethv_rec);
2098:

Line 2102: okc_api.end_activity(x_msg_count

2098:
2099: --Set OUT Values
2100:
2101: x_ethv_rec := l_def_ethv_rec;
2102: okc_api.end_activity(x_msg_count
2103: ,x_msg_data);
2104: EXCEPTION
2105: WHEN g_exception_halt_validation THEN
2106:

Line 2110: WHEN okc_api.g_exception_error THEN

2106:
2107: -- No action necessary. Validation can continue to next attribute/column
2108:
2109: NULL;
2110: WHEN okc_api.g_exception_error THEN
2111: x_return_status := okl_api.handle_exceptions(l_api_name
2112: ,g_pkg_name
2113: ,'OKL_API.G_RET_STS_ERROR'
2114: ,x_msg_count

Line 2117: WHEN okc_api.g_exception_unexpected_error THEN

2113: ,'OKL_API.G_RET_STS_ERROR'
2114: ,x_msg_count
2115: ,x_msg_data
2116: ,'_PVT');
2117: WHEN okc_api.g_exception_unexpected_error THEN
2118: x_return_status := okl_api.handle_exceptions(l_api_name
2119: ,g_pkg_name
2120: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2121: ,x_msg_count

Line 2138: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2134: -- Procedure insert_row_tbl
2135: --------------------------------------------------------------------------------
2136:
2137: PROCEDURE insert_row(p_api_version IN NUMBER
2138: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2139: ,x_return_status OUT NOCOPY VARCHAR2
2140: ,x_msg_count OUT NOCOPY NUMBER
2141: ,x_msg_data OUT NOCOPY VARCHAR2
2142: ,p_ethv_tbl IN okl_ethv_tbl

Line 2151: okc_api.init_msg_list(p_init_msg_list);

2147: i NUMBER := 0;
2148: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2149:
2150: BEGIN
2151: okc_api.init_msg_list(p_init_msg_list);
2152:
2153: -- Make sure PL/SQL table has records in it before passing
2154:
2155: IF (p_ethv_tbl.COUNT > 0) THEN

Line 2160: ,p_init_msg_list => okc_api.g_false

2156: i := p_ethv_tbl.FIRST;
2157:
2158: LOOP
2159: insert_row(p_api_version => p_api_version
2160: ,p_init_msg_list => okc_api.g_false
2161: ,x_return_status => x_return_status
2162: ,x_msg_count => x_msg_count
2163: ,x_msg_data => x_msg_data
2164: ,p_ethv_rec => p_ethv_tbl(i)

Line 2166: IF x_return_status <> okc_api.g_ret_sts_success THEN

2162: ,x_msg_count => x_msg_count
2163: ,x_msg_data => x_msg_data
2164: ,p_ethv_rec => p_ethv_tbl(i)
2165: ,x_ethv_rec => x_ethv_tbl(i));
2166: IF x_return_status <> okc_api.g_ret_sts_success THEN
2167: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
2168: l_overall_status := x_return_status;
2169: END IF;
2170: END IF;

Line 2167: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

2163: ,x_msg_data => x_msg_data
2164: ,p_ethv_rec => p_ethv_tbl(i)
2165: ,x_ethv_rec => x_ethv_tbl(i));
2166: IF x_return_status <> okc_api.g_ret_sts_success THEN
2167: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
2168: l_overall_status := x_return_status;
2169: END IF;
2170: END IF;
2171: EXIT WHEN(i = p_ethv_tbl.LAST);

Line 2183: WHEN okc_api.g_exception_error THEN

2179:
2180: -- No action necessary. Validation can continue to next attribute/column
2181:
2182: NULL;
2183: WHEN okc_api.g_exception_error THEN
2184: x_return_status := okl_api.handle_exceptions(l_api_name
2185: ,g_pkg_name
2186: ,'OKL_API.G_RET_STS_ERROR'
2187: ,x_msg_count

Line 2190: WHEN okc_api.g_exception_unexpected_error THEN

2186: ,'OKL_API.G_RET_STS_ERROR'
2187: ,x_msg_count
2188: ,x_msg_data
2189: ,'_PVT');
2190: WHEN okc_api.g_exception_unexpected_error THEN
2191: x_return_status := okl_api.handle_exceptions(l_api_name
2192: ,g_pkg_name
2193: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2194: ,x_msg_count

Line 2211: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2207: -- Procedure update_row_b
2208: --------------------------------------------------------------------------------
2209:
2210: PROCEDURE update_row(p_api_version IN NUMBER
2211: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2212: ,x_return_status OUT NOCOPY VARCHAR2
2213: ,x_msg_count OUT NOCOPY NUMBER
2214: ,x_msg_data OUT NOCOPY VARCHAR2
2215: ,p_ethb_rec IN okl_ethb_rec

Line 2226: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

2222: l_row_notfound BOOLEAN := true;
2223:
2224: FUNCTION set_attributes(p_ethb_rec IN okl_ethb_rec
2225: ,x_ethb_rec OUT NOCOPY okl_ethb_rec) RETURN VARCHAR2 IS
2226: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
2227:
2228: BEGIN
2229: x_ethb_rec := p_ethb_rec;
2230: RETURN(l_return_status);

Line 2234: l_return_status := okc_api.start_activity(l_api_name

2230: RETURN(l_return_status);
2231: END set_attributes;
2232:
2233: BEGIN
2234: l_return_status := okc_api.start_activity(l_api_name
2235: ,g_pkg_name
2236: ,p_init_msg_list
2237: ,l_api_version
2238: ,p_api_version

Line 2243: RAISE okc_api.g_exception_unexpected_error;

2239: ,'_PVT'
2240: ,x_return_status);
2241:
2242: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2243: RAISE okc_api.g_exception_unexpected_error;
2244: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2245: RAISE okc_api.g_exception_error;
2246: END IF;
2247:

Line 2245: RAISE okc_api.g_exception_error;

2241:
2242: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2243: RAISE okc_api.g_exception_unexpected_error;
2244: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2245: RAISE okc_api.g_exception_error;
2246: END IF;
2247:
2248: --Setting Item Attributes
2249:

Line 2254: RAISE okc_api.g_exception_unexpected_error;

2250: l_return_status := set_attributes(p_ethb_rec
2251: ,l_def_ethb_rec);
2252:
2253: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2254: RAISE okc_api.g_exception_unexpected_error;
2255: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2256: RAISE okc_api.g_exception_error;
2257: END IF;
2258:

Line 2256: RAISE okc_api.g_exception_error;

2252:
2253: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2254: RAISE okc_api.g_exception_unexpected_error;
2255: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2256: RAISE okc_api.g_exception_error;
2257: END IF;
2258:
2259: UPDATE okl_fe_eo_terms_all_b
2260: SET end_of_term_id = l_def_ethb_rec.end_of_term_id

Line 2298: okc_api.end_activity(x_msg_count

2294:
2295: --Set OUT Values
2296:
2297: x_ethb_rec := l_ethb_rec;
2298: okc_api.end_activity(x_msg_count
2299: ,x_msg_data);
2300: EXCEPTION
2301: WHEN g_exception_halt_validation THEN
2302:

Line 2306: WHEN okc_api.g_exception_error THEN

2302:
2303: -- No action necessary. Validation can continue to next attribute/column
2304:
2305: NULL;
2306: WHEN okc_api.g_exception_error THEN
2307: x_return_status := okl_api.handle_exceptions(l_api_name
2308: ,g_pkg_name
2309: ,'OKL_API.G_RET_STS_ERROR'
2310: ,x_msg_count

Line 2313: WHEN okc_api.g_exception_unexpected_error THEN

2309: ,'OKL_API.G_RET_STS_ERROR'
2310: ,x_msg_count
2311: ,x_msg_data
2312: ,'_PVT');
2313: WHEN okc_api.g_exception_unexpected_error THEN
2314: x_return_status := okl_api.handle_exceptions(l_api_name
2315: ,g_pkg_name
2316: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2317: ,x_msg_count

Line 2334: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2330: -- Procedure update_row_tl
2331: --------------------------------------------------------------------------------
2332:
2333: PROCEDURE update_row(p_api_version IN NUMBER
2334: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2335: ,x_return_status OUT NOCOPY VARCHAR2
2336: ,x_msg_count OUT NOCOPY NUMBER
2337: ,x_msg_data OUT NOCOPY VARCHAR2
2338: ,p_ethtl_rec IN okl_ethtl_rec

Line 2349: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

2345: l_row_notfound BOOLEAN := true;
2346:
2347: FUNCTION set_attributes(p_ethtl_rec IN okl_ethtl_rec
2348: ,x_ethtl_rec OUT NOCOPY okl_ethtl_rec) RETURN VARCHAR2 IS
2349: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
2350:
2351: BEGIN
2352: x_ethtl_rec := p_ethtl_rec;
2353: x_ethtl_rec.language := USERENV('LANG');

Line 2359: l_return_status := okc_api.start_activity(l_api_name

2355: RETURN(l_return_status);
2356: END set_attributes;
2357:
2358: BEGIN
2359: l_return_status := okc_api.start_activity(l_api_name
2360: ,g_pkg_name
2361: ,p_init_msg_list
2362: ,l_api_version
2363: ,p_api_version

Line 2368: RAISE okc_api.g_exception_unexpected_error;

2364: ,'_PVT'
2365: ,x_return_status);
2366:
2367: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2368: RAISE okc_api.g_exception_unexpected_error;
2369: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2370: RAISE okc_api.g_exception_error;
2371: END IF;
2372:

Line 2370: RAISE okc_api.g_exception_error;

2366:
2367: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2368: RAISE okc_api.g_exception_unexpected_error;
2369: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2370: RAISE okc_api.g_exception_error;
2371: END IF;
2372:
2373: --Setting Item Attributes
2374:

Line 2379: RAISE okc_api.g_exception_unexpected_error;

2375: l_return_status := set_attributes(p_ethtl_rec
2376: ,l_def_ethtl_rec);
2377:
2378: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2379: RAISE okc_api.g_exception_unexpected_error;
2380: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2381: RAISE okc_api.g_exception_error;
2382: END IF;
2383:

Line 2381: RAISE okc_api.g_exception_error;

2377:
2378: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2379: RAISE okc_api.g_exception_unexpected_error;
2380: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2381: RAISE okc_api.g_exception_error;
2382: END IF;
2383:
2384: UPDATE okl_fe_eo_terms_all_tl
2385: SET end_of_term_id = l_def_ethtl_rec.end_of_term_id

Line 2406: okc_api.end_activity(x_msg_count

2402:
2403: --Set OUT Values
2404:
2405: x_ethtl_rec := l_ethtl_rec;
2406: okc_api.end_activity(x_msg_count
2407: ,x_msg_data);
2408: EXCEPTION
2409: WHEN g_exception_halt_validation THEN
2410:

Line 2414: WHEN okc_api.g_exception_error THEN

2410:
2411: -- No action necessary. Validation can continue to next attribute/column
2412:
2413: NULL;
2414: WHEN okc_api.g_exception_error THEN
2415: x_return_status := okl_api.handle_exceptions(l_api_name
2416: ,g_pkg_name
2417: ,'OKL_API.G_RET_STS_ERROR'
2418: ,x_msg_count

Line 2421: WHEN okc_api.g_exception_unexpected_error THEN

2417: ,'OKL_API.G_RET_STS_ERROR'
2418: ,x_msg_count
2419: ,x_msg_data
2420: ,'_PVT');
2421: WHEN okc_api.g_exception_unexpected_error THEN
2422: x_return_status := okl_api.handle_exceptions(l_api_name
2423: ,g_pkg_name
2424: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2425: ,x_msg_count

Line 2442: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2438: -- Procedure insert_row_v
2439: --------------------------------------------------------------------------------
2440:
2441: PROCEDURE update_row(p_api_version IN NUMBER
2442: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2443: ,x_return_status OUT NOCOPY VARCHAR2
2444: ,x_msg_count OUT NOCOPY NUMBER
2445: ,x_msg_data OUT NOCOPY VARCHAR2
2446: ,p_ethv_rec IN okl_ethv_rec

Line 2627: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

2623: END populate_new_record;
2624:
2625: FUNCTION set_attributes(p_ethv_rec IN okl_ethv_rec
2626: ,x_ethv_rec OUT NOCOPY okl_ethv_rec) RETURN VARCHAR2 IS
2627: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
2628:
2629: BEGIN
2630: x_ethv_rec := p_ethv_rec;
2631: RETURN(l_return_status);

Line 2635: l_return_status := okc_api.start_activity(l_api_name

2631: RETURN(l_return_status);
2632: END set_attributes;
2633:
2634: BEGIN
2635: l_return_status := okc_api.start_activity(l_api_name
2636: ,g_pkg_name
2637: ,p_init_msg_list
2638: ,l_api_version
2639: ,p_api_version

Line 2644: RAISE okc_api.g_exception_unexpected_error;

2640: ,'_PVT'
2641: ,x_return_status);
2642:
2643: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2644: RAISE okc_api.g_exception_unexpected_error;
2645: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2646: RAISE okc_api.g_exception_error;
2647: END IF;
2648:

Line 2646: RAISE okc_api.g_exception_error;

2642:
2643: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2644: RAISE okc_api.g_exception_unexpected_error;
2645: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2646: RAISE okc_api.g_exception_error;
2647: END IF;
2648:
2649: --Setting Item Attributes
2650:

Line 2655: RAISE okc_api.g_exception_unexpected_error;

2651: l_return_status := set_attributes(l_ethv_rec
2652: ,lx_ethv_rec);
2653:
2654: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2655: RAISE okc_api.g_exception_unexpected_error;
2656: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2657: RAISE okc_api.g_exception_error;
2658: END IF;
2659: l_return_status := populate_new_record(lx_ethv_rec

Line 2657: RAISE okc_api.g_exception_error;

2653:
2654: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2655: RAISE okc_api.g_exception_unexpected_error;
2656: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2657: RAISE okc_api.g_exception_error;
2658: END IF;
2659: l_return_status := populate_new_record(lx_ethv_rec
2660: ,l_def_ethv_rec);
2661:

Line 2663: RAISE okc_api.g_exception_unexpected_error;

2659: l_return_status := populate_new_record(lx_ethv_rec
2660: ,l_def_ethv_rec);
2661:
2662: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2663: RAISE okc_api.g_exception_unexpected_error;
2664: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2665: RAISE okc_api.g_exception_error;
2666: END IF;
2667: l_def_ethv_rec := null_out_defaults(l_def_ethv_rec);

Line 2665: RAISE okc_api.g_exception_error;

2661:
2662: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2663: RAISE okc_api.g_exception_unexpected_error;
2664: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2665: RAISE okc_api.g_exception_error;
2666: END IF;
2667: l_def_ethv_rec := null_out_defaults(l_def_ethv_rec);
2668: l_def_ethv_rec := fill_who_columns(l_def_ethv_rec);
2669: l_return_status := validate_attributes(l_def_ethv_rec);

Line 2672: RAISE okc_api.g_exception_unexpected_error;

2668: l_def_ethv_rec := fill_who_columns(l_def_ethv_rec);
2669: l_return_status := validate_attributes(l_def_ethv_rec);
2670:
2671: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2672: RAISE okc_api.g_exception_unexpected_error;
2673: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2674: RAISE okc_api.g_exception_error;
2675: END IF;
2676: l_return_status := validate_record(l_def_ethv_rec);

Line 2674: RAISE okc_api.g_exception_error;

2670:
2671: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2672: RAISE okc_api.g_exception_unexpected_error;
2673: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2674: RAISE okc_api.g_exception_error;
2675: END IF;
2676: l_return_status := validate_record(l_def_ethv_rec);
2677:
2678: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 2679: RAISE okc_api.g_exception_unexpected_error;

2675: END IF;
2676: l_return_status := validate_record(l_def_ethv_rec);
2677:
2678: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2679: RAISE okc_api.g_exception_unexpected_error;
2680: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2681: RAISE okc_api.g_exception_error;
2682: END IF;
2683:

Line 2681: RAISE okc_api.g_exception_error;

2677:
2678: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2679: RAISE okc_api.g_exception_unexpected_error;
2680: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2681: RAISE okc_api.g_exception_error;
2682: END IF;
2683:
2684: --lock the row
2685:

Line 2711: RAISE okc_api.g_exception_unexpected_error;

2707: ,l_ethb_rec
2708: ,lx_ethb_rec);
2709:
2710: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2711: RAISE okc_api.g_exception_unexpected_error;
2712: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2713: RAISE okc_api.g_exception_error;
2714: END IF;
2715: migrate(lx_ethb_rec

Line 2713: RAISE okc_api.g_exception_error;

2709:
2710: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2711: RAISE okc_api.g_exception_unexpected_error;
2712: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2713: RAISE okc_api.g_exception_error;
2714: END IF;
2715: migrate(lx_ethb_rec
2716: ,l_def_ethv_rec);
2717: update_row(p_api_version

Line 2726: RAISE okc_api.g_exception_unexpected_error;

2722: ,l_ethtl_rec
2723: ,lx_ethtl_rec);
2724:
2725: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2726: RAISE okc_api.g_exception_unexpected_error;
2727: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2728: RAISE okc_api.g_exception_error;
2729: END IF;
2730: migrate(lx_ethtl_rec

Line 2728: RAISE okc_api.g_exception_error;

2724:
2725: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2726: RAISE okc_api.g_exception_unexpected_error;
2727: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2728: RAISE okc_api.g_exception_error;
2729: END IF;
2730: migrate(lx_ethtl_rec
2731: ,l_def_ethv_rec);
2732:

Line 2736: okc_api.end_activity(x_msg_count

2732:
2733: --Set OUT Values
2734:
2735: x_ethv_rec := l_def_ethv_rec;
2736: okc_api.end_activity(x_msg_count
2737: ,x_msg_data);
2738: EXCEPTION
2739: WHEN g_exception_halt_validation THEN
2740:

Line 2744: WHEN okc_api.g_exception_error THEN

2740:
2741: -- No action necessary. Validation can continue to next attribute/column
2742:
2743: NULL;
2744: WHEN okc_api.g_exception_error THEN
2745: x_return_status := okl_api.handle_exceptions(l_api_name
2746: ,g_pkg_name
2747: ,'OKL_API.G_RET_STS_ERROR'
2748: ,x_msg_count

Line 2751: WHEN okc_api.g_exception_unexpected_error THEN

2747: ,'OKL_API.G_RET_STS_ERROR'
2748: ,x_msg_count
2749: ,x_msg_data
2750: ,'_PVT');
2751: WHEN okc_api.g_exception_unexpected_error THEN
2752: x_return_status := okl_api.handle_exceptions(l_api_name
2753: ,g_pkg_name
2754: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2755: ,x_msg_count

Line 2772: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2768: -- Procedure insert_row_tbl
2769: --------------------------------------------------------------------------------
2770:
2771: PROCEDURE update_row(p_api_version IN NUMBER
2772: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2773: ,x_return_status OUT NOCOPY VARCHAR2
2774: ,x_msg_count OUT NOCOPY NUMBER
2775: ,x_msg_data OUT NOCOPY VARCHAR2
2776: ,p_ethv_tbl IN okl_ethv_tbl

Line 2785: okc_api.init_msg_list(p_init_msg_list);

2781: i NUMBER := 0;
2782: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2783:
2784: BEGIN
2785: okc_api.init_msg_list(p_init_msg_list);
2786:
2787: -- Make sure PL/SQL table has records in it before passing
2788:
2789: IF (p_ethv_tbl.COUNT > 0) THEN

Line 2794: ,p_init_msg_list => okc_api.g_false

2790: i := p_ethv_tbl.FIRST;
2791:
2792: LOOP
2793: update_row(p_api_version => p_api_version
2794: ,p_init_msg_list => okc_api.g_false
2795: ,x_return_status => x_return_status
2796: ,x_msg_count => x_msg_count
2797: ,x_msg_data => x_msg_data
2798: ,p_ethv_rec => p_ethv_tbl(i)

Line 2800: IF x_return_status <> okc_api.g_ret_sts_success THEN

2796: ,x_msg_count => x_msg_count
2797: ,x_msg_data => x_msg_data
2798: ,p_ethv_rec => p_ethv_tbl(i)
2799: ,x_ethv_rec => x_ethv_tbl(i));
2800: IF x_return_status <> okc_api.g_ret_sts_success THEN
2801: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
2802: l_overall_status := x_return_status;
2803: END IF;
2804: END IF;

Line 2801: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

2797: ,x_msg_data => x_msg_data
2798: ,p_ethv_rec => p_ethv_tbl(i)
2799: ,x_ethv_rec => x_ethv_tbl(i));
2800: IF x_return_status <> okc_api.g_ret_sts_success THEN
2801: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
2802: l_overall_status := x_return_status;
2803: END IF;
2804: END IF;
2805: EXIT WHEN(i = p_ethv_tbl.LAST);

Line 2817: WHEN okc_api.g_exception_error THEN

2813:
2814: -- No action necessary. Validation can continue to next attribute/column
2815:
2816: NULL;
2817: WHEN okc_api.g_exception_error THEN
2818: x_return_status := okl_api.handle_exceptions(l_api_name
2819: ,g_pkg_name
2820: ,'OKL_API.G_RET_STS_ERROR'
2821: ,x_msg_count

Line 2824: WHEN okc_api.g_exception_unexpected_error THEN

2820: ,'OKL_API.G_RET_STS_ERROR'
2821: ,x_msg_count
2822: ,x_msg_data
2823: ,'_PVT');
2824: WHEN okc_api.g_exception_unexpected_error THEN
2825: x_return_status := okl_api.handle_exceptions(l_api_name
2826: ,g_pkg_name
2827: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2828: ,x_msg_count

Line 2845: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2841: -- Procedure delete_row_b
2842: --------------------------------------------------------------------------------
2843:
2844: PROCEDURE delete_row(p_api_version IN NUMBER
2845: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2846: ,x_return_status OUT NOCOPY VARCHAR2
2847: ,x_msg_count OUT NOCOPY NUMBER
2848: ,x_msg_data OUT NOCOPY VARCHAR2
2849: ,p_ethb_rec IN okl_ethb_rec) IS

Line 2857: l_return_status := okc_api.start_activity(l_api_name

2853: l_ethb_rec okl_ethb_rec := p_ethb_rec;
2854: l_row_notfound BOOLEAN := true;
2855:
2856: BEGIN
2857: l_return_status := okc_api.start_activity(l_api_name
2858: ,g_pkg_name
2859: ,p_init_msg_list
2860: ,l_api_version
2861: ,p_api_version

Line 2866: RAISE okc_api.g_exception_unexpected_error;

2862: ,'_PVT'
2863: ,x_return_status);
2864:
2865: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2866: RAISE okc_api.g_exception_unexpected_error;
2867: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2868: RAISE okc_api.g_exception_error;
2869: END IF;
2870:

Line 2868: RAISE okc_api.g_exception_error;

2864:
2865: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2866: RAISE okc_api.g_exception_unexpected_error;
2867: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2868: RAISE okc_api.g_exception_error;
2869: END IF;
2870:
2871: DELETE FROM okl_fe_eo_terms_all_b
2872: WHERE end_of_term_id = l_ethb_rec.end_of_term_id;

Line 2880: WHEN okc_api.g_exception_error THEN

2876:
2877: -- No action necessary. Validation can continue to next attribute/column
2878:
2879: NULL;
2880: WHEN okc_api.g_exception_error THEN
2881: x_return_status := okl_api.handle_exceptions(l_api_name
2882: ,g_pkg_name
2883: ,'OKL_API.G_RET_STS_ERROR'
2884: ,x_msg_count

Line 2887: WHEN okc_api.g_exception_unexpected_error THEN

2883: ,'OKL_API.G_RET_STS_ERROR'
2884: ,x_msg_count
2885: ,x_msg_data
2886: ,'_PVT');
2887: WHEN okc_api.g_exception_unexpected_error THEN
2888: x_return_status := okl_api.handle_exceptions(l_api_name
2889: ,g_pkg_name
2890: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2891: ,x_msg_count

Line 2908: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2904: -- Procedure delete_row_tl
2905: --------------------------------------------------------------------------------
2906:
2907: PROCEDURE delete_row(p_api_version IN NUMBER
2908: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2909: ,x_return_status OUT NOCOPY VARCHAR2
2910: ,x_msg_count OUT NOCOPY NUMBER
2911: ,x_msg_data OUT NOCOPY VARCHAR2
2912: ,p_ethtl_rec IN okl_ethtl_rec) IS

Line 2921: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

2917: l_row_notfound BOOLEAN := true;
2918:
2919: FUNCTION set_attributes(p_ethtl_rec IN okl_ethtl_rec
2920: ,x_ethtl_rec OUT NOCOPY okl_ethtl_rec) RETURN VARCHAR2 IS
2921: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
2922:
2923: BEGIN
2924: x_ethtl_rec := p_ethtl_rec;
2925: x_ethtl_rec.language := USERENV('LANG');

Line 2931: l_return_status := okc_api.start_activity(l_api_name

2927: RETURN(l_return_status);
2928: END set_attributes;
2929:
2930: BEGIN
2931: l_return_status := okc_api.start_activity(l_api_name
2932: ,g_pkg_name
2933: ,p_init_msg_list
2934: ,l_api_version
2935: ,p_api_version

Line 2940: RAISE okc_api.g_exception_unexpected_error;

2936: ,'_PVT'
2937: ,x_return_status);
2938:
2939: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2940: RAISE okc_api.g_exception_unexpected_error;
2941: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2942: RAISE okc_api.g_exception_error;
2943: END IF;
2944:

Line 2942: RAISE okc_api.g_exception_error;

2938:
2939: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2940: RAISE okc_api.g_exception_unexpected_error;
2941: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2942: RAISE okc_api.g_exception_error;
2943: END IF;
2944:
2945: --Setting Item Attributes
2946:

Line 2951: RAISE okc_api.g_exception_unexpected_error;

2947: l_return_status := set_attributes(p_ethtl_rec
2948: ,l_ethtl_rec);
2949:
2950: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2951: RAISE okc_api.g_exception_unexpected_error;
2952: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2953: RAISE okc_api.g_exception_error;
2954: END IF;
2955:

Line 2953: RAISE okc_api.g_exception_error;

2949:
2950: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2951: RAISE okc_api.g_exception_unexpected_error;
2952: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2953: RAISE okc_api.g_exception_error;
2954: END IF;
2955:
2956: DELETE FROM okl_fe_eo_terms_all_tl
2957: WHERE end_of_term_id = l_ethtl_rec.end_of_term_id;

Line 2965: WHEN okc_api.g_exception_error THEN

2961:
2962: -- No action necessary. Validation can continue to next attribute/column
2963:
2964: NULL;
2965: WHEN okc_api.g_exception_error THEN
2966: x_return_status := okl_api.handle_exceptions(l_api_name
2967: ,g_pkg_name
2968: ,'OKL_API.G_RET_STS_ERROR'
2969: ,x_msg_count

Line 2972: WHEN okc_api.g_exception_unexpected_error THEN

2968: ,'OKL_API.G_RET_STS_ERROR'
2969: ,x_msg_count
2970: ,x_msg_data
2971: ,'_PVT');
2972: WHEN okc_api.g_exception_unexpected_error THEN
2973: x_return_status := okl_api.handle_exceptions(l_api_name
2974: ,g_pkg_name
2975: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2976: ,x_msg_count

Line 2993: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2989: -- Procedure delete_row_v
2990: --------------------------------------------------------------------------------
2991:
2992: PROCEDURE delete_row(p_api_version IN NUMBER
2993: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2994: ,x_return_status OUT NOCOPY VARCHAR2
2995: ,x_msg_count OUT NOCOPY NUMBER
2996: ,x_msg_data OUT NOCOPY VARCHAR2
2997: ,p_ethv_rec IN okl_ethv_rec) IS

Line 3006: l_return_status := okc_api.start_activity(l_api_name

3002: l_ethb_rec okl_ethb_rec;
3003: l_ethtl_rec okl_ethtl_rec;
3004:
3005: BEGIN
3006: l_return_status := okc_api.start_activity(l_api_name
3007: ,g_pkg_name
3008: ,p_init_msg_list
3009: ,l_api_version
3010: ,p_api_version

Line 3015: RAISE okc_api.g_exception_unexpected_error;

3011: ,'_PVT'
3012: ,x_return_status);
3013:
3014: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
3015: RAISE okc_api.g_exception_unexpected_error;
3016: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3017: RAISE okc_api.g_exception_error;
3018: END IF;
3019: migrate(l_ethv_rec

Line 3017: RAISE okc_api.g_exception_error;

3013:
3014: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
3015: RAISE okc_api.g_exception_unexpected_error;
3016: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3017: RAISE okc_api.g_exception_error;
3018: END IF;
3019: migrate(l_ethv_rec
3020: ,l_ethb_rec);
3021: migrate(l_ethv_rec

Line 3031: RAISE okc_api.g_exception_unexpected_error;

3027: ,x_msg_data
3028: ,l_ethb_rec);
3029:
3030: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
3031: RAISE okc_api.g_exception_unexpected_error;
3032: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3033: RAISE okc_api.g_exception_error;
3034: END IF;
3035: delete_row(p_api_version

Line 3033: RAISE okc_api.g_exception_error;

3029:
3030: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
3031: RAISE okc_api.g_exception_unexpected_error;
3032: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3033: RAISE okc_api.g_exception_error;
3034: END IF;
3035: delete_row(p_api_version
3036: ,p_init_msg_list
3037: ,x_return_status

Line 3043: RAISE okc_api.g_exception_unexpected_error;

3039: ,x_msg_data
3040: ,l_ethtl_rec);
3041:
3042: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
3043: RAISE okc_api.g_exception_unexpected_error;
3044: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3045: RAISE okc_api.g_exception_error;
3046: END IF;
3047: okc_api.end_activity(x_msg_count

Line 3045: RAISE okc_api.g_exception_error;

3041:
3042: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
3043: RAISE okc_api.g_exception_unexpected_error;
3044: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3045: RAISE okc_api.g_exception_error;
3046: END IF;
3047: okc_api.end_activity(x_msg_count
3048: ,x_msg_data);
3049: EXCEPTION

Line 3047: okc_api.end_activity(x_msg_count

3043: RAISE okc_api.g_exception_unexpected_error;
3044: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3045: RAISE okc_api.g_exception_error;
3046: END IF;
3047: okc_api.end_activity(x_msg_count
3048: ,x_msg_data);
3049: EXCEPTION
3050: WHEN g_exception_halt_validation THEN
3051:

Line 3055: WHEN okc_api.g_exception_error THEN

3051:
3052: -- No action necessary. Validation can continue to next attribute/column
3053:
3054: NULL;
3055: WHEN okc_api.g_exception_error THEN
3056: x_return_status := okl_api.handle_exceptions(l_api_name
3057: ,g_pkg_name
3058: ,'OKL_API.G_RET_STS_ERROR'
3059: ,x_msg_count

Line 3062: WHEN okc_api.g_exception_unexpected_error THEN

3058: ,'OKL_API.G_RET_STS_ERROR'
3059: ,x_msg_count
3060: ,x_msg_data
3061: ,'_PVT');
3062: WHEN okc_api.g_exception_unexpected_error THEN
3063: x_return_status := okl_api.handle_exceptions(l_api_name
3064: ,g_pkg_name
3065: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
3066: ,x_msg_count

Line 3083: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

3079: -- Procedure delete_row_tbl
3080: --------------------------------------------------------------------------------
3081:
3082: PROCEDURE delete_row(p_api_version IN NUMBER
3083: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
3084: ,x_return_status OUT NOCOPY VARCHAR2
3085: ,x_msg_count OUT NOCOPY NUMBER
3086: ,x_msg_data OUT NOCOPY VARCHAR2
3087: ,p_ethv_tbl IN okl_ethv_tbl) IS

Line 3095: okc_api.init_msg_list(p_init_msg_list);

3091: i NUMBER := 0;
3092: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
3093:
3094: BEGIN
3095: okc_api.init_msg_list(p_init_msg_list);
3096:
3097: -- Make sure PL/SQL table has records in it before passing
3098:
3099: IF (p_ethv_tbl.COUNT > 0) THEN

Line 3104: ,p_init_msg_list => okc_api.g_false

3100: i := p_ethv_tbl.FIRST;
3101:
3102: LOOP
3103: delete_row(p_api_version => p_api_version
3104: ,p_init_msg_list => okc_api.g_false
3105: ,x_return_status => x_return_status
3106: ,x_msg_count => x_msg_count
3107: ,x_msg_data => x_msg_data
3108: ,p_ethv_rec => p_ethv_tbl(i));

Line 3109: IF x_return_status <> okc_api.g_ret_sts_success THEN

3105: ,x_return_status => x_return_status
3106: ,x_msg_count => x_msg_count
3107: ,x_msg_data => x_msg_data
3108: ,p_ethv_rec => p_ethv_tbl(i));
3109: IF x_return_status <> okc_api.g_ret_sts_success THEN
3110: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
3111: l_overall_status := x_return_status;
3112: END IF;
3113: END IF;

Line 3110: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

3106: ,x_msg_count => x_msg_count
3107: ,x_msg_data => x_msg_data
3108: ,p_ethv_rec => p_ethv_tbl(i));
3109: IF x_return_status <> okc_api.g_ret_sts_success THEN
3110: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
3111: l_overall_status := x_return_status;
3112: END IF;
3113: END IF;
3114: EXIT WHEN(i = p_ethv_tbl.LAST);

Line 3126: WHEN okc_api.g_exception_error THEN

3122:
3123: -- No action necessary. Validation can continue to next attribute/column
3124:
3125: NULL;
3126: WHEN okc_api.g_exception_error THEN
3127: x_return_status := okl_api.handle_exceptions(l_api_name
3128: ,g_pkg_name
3129: ,'OKL_API.G_RET_STS_ERROR'
3130: ,x_msg_count

Line 3133: WHEN okc_api.g_exception_unexpected_error THEN

3129: ,'OKL_API.G_RET_STS_ERROR'
3130: ,x_msg_count
3131: ,x_msg_data
3132: ,'_PVT');
3133: WHEN okc_api.g_exception_unexpected_error THEN
3134: x_return_status := okl_api.handle_exceptions(l_api_name
3135: ,g_pkg_name
3136: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
3137: ,x_msg_count