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 110: okc_api.set_message(p_app_name => g_app_name

106: WHEN OTHERS THEN
107:
108: -- store SQL error message on message stack for caller
109:
110: okc_api.set_message(p_app_name => g_app_name
111: ,p_msg_name => g_unexpected_error
112: ,p_token1 => g_sqlcode_token
113: ,p_token1_value => sqlcode
114: ,p_token2 => g_sqlerrm_token

Line 119: x_return_status := okc_api.g_ret_sts_unexp_error;

115: ,p_token2_value => sqlerrm);
116:
117: -- notify caller of an UNEXPECTED error
118:
119: x_return_status := okc_api.g_ret_sts_unexp_error;
120: END validate_end_of_term_id;
121:
122: PROCEDURE validate_object_version_number(x_return_status OUT NOCOPY VARCHAR2
123: ,p_ethv_rec IN okl_ethv_rec) IS

Line 158: okc_api.set_message(p_app_name => g_app_name

154: WHEN OTHERS THEN
155:
156: -- store SQL error message on message stack for caller
157:
158: okc_api.set_message(p_app_name => g_app_name
159: ,p_msg_name => g_unexpected_error
160: ,p_token1 => g_sqlcode_token
161: ,p_token1_value => sqlcode
162: ,p_token2 => g_sqlerrm_token

Line 167: x_return_status := okc_api.g_ret_sts_unexp_error;

163: ,p_token2_value => sqlerrm);
164:
165: -- notify caller of an UNEXPECTED error
166:
167: x_return_status := okc_api.g_ret_sts_unexp_error;
168: END validate_object_version_number;
169:
170: PROCEDURE validate_org_id(x_return_status OUT NOCOPY VARCHAR2
171: ,p_ethv_rec IN okl_ethv_rec) IS

Line 177: x_return_status := okc_api.g_ret_sts_success;

173: BEGIN
174:
175: -- initialize return status
176:
177: x_return_status := okc_api.g_ret_sts_success;
178:
179: -- check org id validity using the generic function okl_util.check_org_id()
180:
181: x_return_status := okl_util.check_org_id(p_ethv_rec.org_id);

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

179: -- check org id validity using the generic function okl_util.check_org_id()
180:
181: x_return_status := okl_util.check_org_id(p_ethv_rec.org_id);
182:
183: IF (x_return_status = okc_api.g_ret_sts_error) THEN
184: okc_api.set_message(p_app_name => g_app_name
185: ,p_msg_name => g_invalid_value
186: ,p_token1 => g_col_name_token
187: ,p_token1_value => 'org_id');

Line 184: okc_api.set_message(p_app_name => g_app_name

180:
181: x_return_status := okl_util.check_org_id(p_ethv_rec.org_id);
182:
183: IF (x_return_status = okc_api.g_ret_sts_error) THEN
184: okc_api.set_message(p_app_name => g_app_name
185: ,p_msg_name => g_invalid_value
186: ,p_token1 => g_col_name_token
187: ,p_token1_value => 'org_id');
188:

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

188:
189: -- notify caller of an error
190:
191: RAISE g_exception_halt_validation;
192: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
193:
194: -- notify caller of an error
195:
196: RAISE g_exception_halt_validation;

Line 218: x_return_status := okc_api.g_ret_sts_unexp_error;

214: ,p_token2_value => sqlerrm);
215:
216: -- notify caller of an UNEXPECTED error
217:
218: x_return_status := okc_api.g_ret_sts_unexp_error;
219: END validate_org_id;
220:
221: PROCEDURE validate_currency_code(x_return_status OUT NOCOPY VARCHAR2
222: ,p_ethv_rec IN okl_ethv_rec) IS

Line 228: x_return_status := okc_api.g_ret_sts_success;

224: BEGIN
225:
226: -- initialize return status
227:
228: x_return_status := okc_api.g_ret_sts_success;
229:
230: -- data is required
231:
232: IF (p_ethv_rec.currency_code IS NOT NULL) AND (p_ethv_rec.currency_code <> okc_api.g_miss_char) THEN

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

228: x_return_status := okc_api.g_ret_sts_success;
229:
230: -- data is required
231:
232: IF (p_ethv_rec.currency_code IS NOT NULL) AND (p_ethv_rec.currency_code <> okc_api.g_miss_char) THEN
233:
234: x_return_status := okl_accounting_util.validate_currency_code(p_ethv_rec.currency_code);
235:
236: IF (x_return_status <> okl_api.g_true) THEN

Line 237: okc_api.set_message(p_app_name => g_app_name

233:
234: x_return_status := okl_accounting_util.validate_currency_code(p_ethv_rec.currency_code);
235:
236: IF (x_return_status <> okl_api.g_true) THEN
237: okc_api.set_message(p_app_name => g_app_name
238: ,p_msg_name => g_invalid_value
239: ,p_token1 => g_col_name_token
240: ,p_token1_value => 'currency_code');
241:

Line 250: x_return_status := okc_api.g_ret_sts_error;

246: END IF;
247:
248: EXCEPTION
249: WHEN g_exception_halt_validation THEN
250: x_return_status := okc_api.g_ret_sts_error;
251: WHEN OTHERS THEN
252:
253: -- store SQL error message on message stack for caller
254:

Line 255: okc_api.set_message(p_app_name => g_app_name

251: WHEN OTHERS THEN
252:
253: -- store SQL error message on message stack for caller
254:
255: okc_api.set_message(p_app_name => g_app_name
256: ,p_msg_name => g_unexpected_error
257: ,p_token1 => g_sqlcode_token
258: ,p_token1_value => sqlcode
259: ,p_token2 => g_sqlerrm_token

Line 264: x_return_status := okc_api.g_ret_sts_unexp_error;

260: ,p_token2_value => sqlerrm);
261:
262: -- notify caller of an UNEXPECTED error
263:
264: x_return_status := okc_api.g_ret_sts_unexp_error;
265: END validate_currency_code;
266:
267: PROCEDURE validate_eot_type_code(x_return_status OUT NOCOPY VARCHAR2
268: ,p_ethv_rec IN okl_ethv_rec) IS

Line 274: x_return_status := okc_api.g_ret_sts_success;

270: BEGIN
271:
272: -- initialize return status
273:
274: x_return_status := okc_api.g_ret_sts_success;
275:
276: -- data is required
277:
278: IF (p_ethv_rec.eot_type_code IS NULL) OR (p_ethv_rec.eot_type_code = okc_api.g_miss_char) THEN

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

274: x_return_status := okc_api.g_ret_sts_success;
275:
276: -- data is required
277:
278: IF (p_ethv_rec.eot_type_code IS NULL) OR (p_ethv_rec.eot_type_code = okc_api.g_miss_char) THEN
279: okc_api.set_message(p_app_name => g_app_name
280: ,p_msg_name => g_required_value
281: ,p_token1 => g_col_name_token
282: ,p_token1_value => 'EOT_TYPE_CODE');

Line 279: okc_api.set_message(p_app_name => g_app_name

275:
276: -- data is required
277:
278: IF (p_ethv_rec.eot_type_code IS NULL) OR (p_ethv_rec.eot_type_code = okc_api.g_miss_char) THEN
279: okc_api.set_message(p_app_name => g_app_name
280: ,p_msg_name => g_required_value
281: ,p_token1 => g_col_name_token
282: ,p_token1_value => 'EOT_TYPE_CODE');
283:

Line 286: x_return_status := okc_api.g_ret_sts_error;

282: ,p_token1_value => 'EOT_TYPE_CODE');
283:
284: -- notify caller of an error
285:
286: x_return_status := okc_api.g_ret_sts_error;
287:
288: -- halt further validation of this column
289:
290: RAISE g_exception_halt_validation;

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

294:
295: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_RESIDUAL_TYPES'
296: ,p_lookup_code => p_ethv_rec.eot_type_code);
297:
298: IF (x_return_status = okc_api.g_ret_sts_error) THEN
299: okc_api.set_message(p_app_name => g_app_name
300: ,p_msg_name => g_invalid_value
301: ,p_token1 => g_col_name_token
302: ,p_token1_value => 'EOT_TYPE_CODE'); -- notify caller of an error

Line 299: okc_api.set_message(p_app_name => g_app_name

295: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_RESIDUAL_TYPES'
296: ,p_lookup_code => p_ethv_rec.eot_type_code);
297:
298: IF (x_return_status = okc_api.g_ret_sts_error) THEN
299: okc_api.set_message(p_app_name => g_app_name
300: ,p_msg_name => g_invalid_value
301: ,p_token1 => g_col_name_token
302: ,p_token1_value => 'EOT_TYPE_CODE'); -- notify caller of an error
303: RAISE g_exception_halt_validation;

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

300: ,p_msg_name => g_invalid_value
301: ,p_token1 => g_col_name_token
302: ,p_token1_value => 'EOT_TYPE_CODE'); -- notify caller of an error
303: RAISE g_exception_halt_validation;
304: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
305:
306: -- notify caller of an error
307:
308: x_return_status := okc_api.g_ret_sts_unexp_error;

Line 308: x_return_status := okc_api.g_ret_sts_unexp_error;

304: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
305:
306: -- notify caller of an error
307:
308: x_return_status := okc_api.g_ret_sts_unexp_error;
309: RAISE g_exception_halt_validation;
310: END IF;
311:
312: EXCEPTION

Line 323: okc_api.set_message(p_app_name => g_app_name

319: WHEN OTHERS THEN
320:
321: -- store SQL error message on message stack for caller
322:
323: okc_api.set_message(p_app_name => g_app_name
324: ,p_msg_name => g_unexpected_error
325: ,p_token1 => g_sqlcode_token
326: ,p_token1_value => sqlcode
327: ,p_token2 => g_sqlerrm_token

Line 348: x_return_status := okc_api.g_ret_sts_success;

344: BEGIN
345:
346: -- initialize return status
347:
348: x_return_status := okc_api.g_ret_sts_success;
349:
350: -- data is required
351:
352: IF (p_ethv_rec.product_id IS NULL) OR (p_ethv_rec.product_id = okc_api.g_miss_num) THEN

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

348: x_return_status := okc_api.g_ret_sts_success;
349:
350: -- data is required
351:
352: IF (p_ethv_rec.product_id IS NULL) OR (p_ethv_rec.product_id = okc_api.g_miss_num) THEN
353: okc_api.set_message(p_app_name => g_app_name
354: ,p_msg_name => g_required_value
355: ,p_token1 => g_col_name_token
356: ,p_token1_value => 'product_id');

Line 353: okc_api.set_message(p_app_name => g_app_name

349:
350: -- data is required
351:
352: IF (p_ethv_rec.product_id IS NULL) OR (p_ethv_rec.product_id = okc_api.g_miss_num) THEN
353: okc_api.set_message(p_app_name => g_app_name
354: ,p_msg_name => g_required_value
355: ,p_token1 => g_col_name_token
356: ,p_token1_value => 'product_id');
357:

Line 376: okc_api.set_message(p_app_name => g_app_name

372:
373: -- if l_dummy_var is still set to default, data was not found
374:
375: IF (l_dummy_var = '?') THEN
376: okc_api.set_message(p_app_name => g_app_name
377: ,p_msg_name => g_invalid_value
378: ,p_token1 => g_col_name_token
379: ,p_token1_value => 'product_id');
380:

Line 383: x_return_status := okc_api.g_ret_sts_error;

379: ,p_token1_value => 'product_id');
380:
381: -- notify caller of an error
382:
383: x_return_status := okc_api.g_ret_sts_error;
384: END IF;
385:
386: EXCEPTION
387: WHEN g_exception_halt_validation THEN

Line 397: okc_api.set_message(p_app_name => g_app_name

393: WHEN OTHERS THEN
394:
395: -- store SQL error message on message stack for caller
396:
397: okc_api.set_message(p_app_name => g_app_name
398: ,p_msg_name => g_unexpected_error
399: ,p_token1 => g_sqlcode_token
400: ,p_token1_value => sqlcode
401: ,p_token2 => g_sqlerrm_token

Line 406: x_return_status := okc_api.g_ret_sts_unexp_error;

402: ,p_token2_value => sqlerrm);
403:
404: -- notify caller of an UNEXPECTED error
405:
406: x_return_status := okc_api.g_ret_sts_unexp_error;
407:
408: -- verify that cursor was closed
409:
410: IF product_id_exists_csr%ISOPEN THEN

Line 423: x_return_status := okc_api.g_ret_sts_success;

419: BEGIN
420:
421: -- initialize return status
422:
423: x_return_status := okc_api.g_ret_sts_success;
424:
425: -- data is required
426:
427: IF (p_ethv_rec.category_type_code IS NULL) OR (p_ethv_rec.category_type_code = okc_api.g_miss_char) THEN

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

423: x_return_status := okc_api.g_ret_sts_success;
424:
425: -- data is required
426:
427: IF (p_ethv_rec.category_type_code IS NULL) OR (p_ethv_rec.category_type_code = okc_api.g_miss_char) THEN
428: okc_api.set_message(p_app_name => g_app_name
429: ,p_msg_name => g_required_value
430: ,p_token1 => g_col_name_token
431: ,p_token1_value => 'CATEGORY_TYPE_CODE');

Line 428: okc_api.set_message(p_app_name => g_app_name

424:
425: -- data is required
426:
427: IF (p_ethv_rec.category_type_code IS NULL) OR (p_ethv_rec.category_type_code = okc_api.g_miss_char) THEN
428: okc_api.set_message(p_app_name => g_app_name
429: ,p_msg_name => g_required_value
430: ,p_token1 => g_col_name_token
431: ,p_token1_value => 'CATEGORY_TYPE_CODE');
432:

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

443:
444: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_SOURCE_TYPES'
445: ,p_lookup_code => p_ethv_rec.category_type_code);
446:
447: IF (x_return_status = okc_api.g_ret_sts_error) THEN
448: okc_api.set_message(p_app_name => g_app_name
449: ,p_msg_name => g_invalid_value
450: ,p_token1 => g_col_name_token
451: ,p_token1_value => 'CATEGORY_TYPE_CODE'); -- notify caller of an error

Line 448: okc_api.set_message(p_app_name => g_app_name

444: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_SOURCE_TYPES'
445: ,p_lookup_code => p_ethv_rec.category_type_code);
446:
447: IF (x_return_status = okc_api.g_ret_sts_error) THEN
448: okc_api.set_message(p_app_name => g_app_name
449: ,p_msg_name => g_invalid_value
450: ,p_token1 => g_col_name_token
451: ,p_token1_value => 'CATEGORY_TYPE_CODE'); -- notify caller of an error
452: RAISE g_exception_halt_validation;

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

449: ,p_msg_name => g_invalid_value
450: ,p_token1 => g_col_name_token
451: ,p_token1_value => 'CATEGORY_TYPE_CODE'); -- notify caller of an error
452: RAISE g_exception_halt_validation;
453: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
454:
455: -- notify caller of an error
456:
457: x_return_status := okc_api.g_ret_sts_unexp_error;

Line 457: x_return_status := okc_api.g_ret_sts_unexp_error;

453: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
454:
455: -- notify caller of an error
456:
457: x_return_status := okc_api.g_ret_sts_unexp_error;
458: RAISE g_exception_halt_validation;
459: END IF;
460:
461: EXCEPTION

Line 472: okc_api.set_message(p_app_name => g_app_name

468: WHEN OTHERS THEN
469:
470: -- store SQL error message on message stack for caller
471:
472: okc_api.set_message(p_app_name => g_app_name
473: ,p_msg_name => g_unexpected_error
474: ,p_token1 => g_sqlcode_token
475: ,p_token1_value => sqlcode
476: ,p_token2 => g_sqlerrm_token

Line 481: x_return_status := okc_api.g_ret_sts_unexp_error;

477: ,p_token2_value => sqlerrm);
478:
479: -- notify caller of an UNEXPECTED error
480:
481: x_return_status := okc_api.g_ret_sts_unexp_error;
482: END validate_category_type_code;
483:
484: PROCEDURE validate_orig_end_of_term_id(x_return_status OUT NOCOPY VARCHAR2
485: ,p_ethv_rec IN okl_ethv_rec) IS

Line 514: x_return_status := okc_api.g_ret_sts_error;

510: ,p_token1_value => 'ORIG_END_OF_TERM_ID');
511:
512: -- notify caller of an error
513:
514: x_return_status := okc_api.g_ret_sts_error;
515: RAISE g_exception_halt_validation;
516: END IF;
517: END IF;
518:

Line 530: okc_api.set_message(p_app_name => g_app_name

526: WHEN OTHERS THEN
527:
528: -- store SQL error message on message stack for caller
529:
530: okc_api.set_message(p_app_name => g_app_name
531: ,p_msg_name => g_unexpected_error
532: ,p_token1 => g_sqlcode_token
533: ,p_token1_value => sqlcode
534: ,p_token2 => g_sqlerrm_token

Line 539: x_return_status := okc_api.g_ret_sts_unexp_error;

535: ,p_token2_value => sqlerrm);
536:
537: -- notify caller of an UNEXPECTED error
538:
539: x_return_status := okc_api.g_ret_sts_unexp_error;
540:
541: -- verify that cursor was closed
542:
543: IF pos_exists_csr%ISOPEN THEN

Line 581: okc_api.set_message(p_app_name => g_app_name

577: WHEN OTHERS THEN
578:
579: -- store SQL error message on message stack for caller
580:
581: okc_api.set_message(p_app_name => g_app_name
582: ,p_msg_name => g_unexpected_error
583: ,p_token1 => g_sqlcode_token
584: ,p_token1_value => sqlcode
585: ,p_token2 => g_sqlerrm_token

Line 590: x_return_status := okc_api.g_ret_sts_unexp_error;

586: ,p_token2_value => sqlerrm);
587:
588: -- notify caller of an UNEXPECTED error
589:
590: x_return_status := okc_api.g_ret_sts_unexp_error;
591: END validate_effective_from_date;
592:
593: PROCEDURE validate_sts_code(x_return_status OUT NOCOPY VARCHAR2
594: ,p_ethv_rec IN okl_ethv_rec) IS

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

617:
618: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_PRC_STATUS'
619: ,p_lookup_code => p_ethv_rec.sts_code);
620:
621: IF (x_return_status = okc_api.g_ret_sts_error) THEN
622: okc_api.set_message(p_app_name => g_app_name
623: ,p_msg_name => g_invalid_value
624: ,p_token1 => g_col_name_token
625: ,p_token1_value => 'sts_code'); -- notify caller of an error

Line 622: okc_api.set_message(p_app_name => g_app_name

618: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_PRC_STATUS'
619: ,p_lookup_code => p_ethv_rec.sts_code);
620:
621: IF (x_return_status = okc_api.g_ret_sts_error) THEN
622: okc_api.set_message(p_app_name => g_app_name
623: ,p_msg_name => g_invalid_value
624: ,p_token1 => g_col_name_token
625: ,p_token1_value => 'sts_code'); -- notify caller of an error
626: RAISE g_exception_halt_validation;

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

623: ,p_msg_name => g_invalid_value
624: ,p_token1 => g_col_name_token
625: ,p_token1_value => 'sts_code'); -- notify caller of an error
626: RAISE g_exception_halt_validation;
627: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
628:
629: -- notify caller of an error
630:
631: x_return_status := okc_api.g_ret_sts_unexp_error;

Line 631: x_return_status := okc_api.g_ret_sts_unexp_error;

627: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
628:
629: -- notify caller of an error
630:
631: x_return_status := okc_api.g_ret_sts_unexp_error;
632: RAISE g_exception_halt_validation;
633: END IF;
634:
635: EXCEPTION

Line 646: okc_api.set_message(p_app_name => g_app_name

642: WHEN OTHERS THEN
643:
644: -- store SQL error message on message stack for caller
645:
646: okc_api.set_message(p_app_name => g_app_name
647: ,p_msg_name => g_unexpected_error
648: ,p_token1 => g_sqlcode_token
649: ,p_token1_value => sqlcode
650: ,p_token2 => g_sqlerrm_token

Line 655: x_return_status := okc_api.g_ret_sts_unexp_error;

651: ,p_token2_value => sqlerrm);
652:
653: -- notify caller of an UNEXPECTED error
654:
655: x_return_status := okc_api.g_ret_sts_unexp_error;
656: END validate_sts_code;
657:
658: --------------------------------------------------------------------------------
659: -- Procedure get_rec for OKL_FE_EO_TERMS_ALL_B

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

1166: RETURN(okc_p_util.raw_to_number(sys_guid()));
1167: END get_seq_id;
1168:
1169: FUNCTION validate_attributes(p_ethv_rec IN okl_ethv_rec) RETURN VARCHAR2 IS
1170: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
1171: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1172:
1173: BEGIN
1174:

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

1178: ,p_ethv_rec => p_ethv_rec);
1179:
1180: -- store the highest degree of error
1181:
1182: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1183: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1184: x_return_status := l_return_status;
1185: END IF;
1186: END IF;

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

1179:
1180: -- store the highest degree of error
1181:
1182: IF (l_return_status <> okc_api.g_ret_sts_success) THEN
1183: IF (x_return_status <> okc_api.g_ret_sts_unexp_error) THEN
1184: x_return_status := l_return_status;
1185: END IF;
1186: END IF;
1187: validate_object_version_number(x_return_status => l_return_status

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_org_id(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_currency_code(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_eot_type_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_product_id(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_category_type_code(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_orig_end_of_term_id(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_sts_code(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_effective_from_date(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: RETURN(x_return_status);

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

1277: RETURN(x_return_status);
1278: END validate_attributes;
1279:
1280: FUNCTION validate_record(p_ethv_rec IN okl_ethv_rec) RETURN VARCHAR2 IS
1281: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
1282: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1283:
1284: BEGIN
1285: IF (p_ethv_rec.effective_to_date IS NOT NULL) THEN

Line 1697: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1693: -- Procedure insert_row_b
1694: --------------------------------------------------------------------------------
1695:
1696: PROCEDURE insert_row(p_api_version IN NUMBER
1697: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1698: ,x_return_status OUT NOCOPY VARCHAR2
1699: ,x_msg_count OUT NOCOPY NUMBER
1700: ,x_msg_data OUT NOCOPY VARCHAR2
1701: ,p_ethb_rec IN okl_ethb_rec

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

1706: l_ethb_rec okl_ethb_rec := p_ethb_rec;
1707:
1708: FUNCTION set_attributes(p_ethb_rec IN okl_ethb_rec
1709: ,x_ethb_rec OUT NOCOPY okl_ethb_rec) RETURN VARCHAR2 IS
1710: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
1711:
1712: BEGIN
1713: x_ethb_rec := p_ethb_rec;
1714: RETURN(l_return_status);

Line 1718: l_return_status := okc_api.start_activity(l_api_name

1714: RETURN(l_return_status);
1715: END set_attributes;
1716:
1717: BEGIN
1718: l_return_status := okc_api.start_activity(l_api_name
1719: ,g_pkg_name
1720: ,p_init_msg_list
1721: ,l_api_version
1722: ,p_api_version

Line 1727: RAISE okc_api.g_exception_unexpected_error;

1723: ,'_PVT'
1724: ,x_return_status);
1725:
1726: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1727: RAISE okc_api.g_exception_unexpected_error;
1728: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1729: RAISE okc_api.g_exception_error;
1730: END IF;
1731:

Line 1729: RAISE okc_api.g_exception_error;

1725:
1726: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1727: RAISE okc_api.g_exception_unexpected_error;
1728: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1729: RAISE okc_api.g_exception_error;
1730: END IF;
1731:
1732: --Setting Item Attributes
1733:

Line 1738: RAISE okc_api.g_exception_unexpected_error;

1734: l_return_status := set_attributes(p_ethb_rec
1735: ,l_ethb_rec);
1736:
1737: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1738: RAISE okc_api.g_exception_unexpected_error;
1739: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1740: RAISE okc_api.g_exception_error;
1741: END IF;
1742:

Line 1740: RAISE okc_api.g_exception_error;

1736:
1737: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1738: RAISE okc_api.g_exception_unexpected_error;
1739: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1740: RAISE okc_api.g_exception_error;
1741: END IF;
1742:
1743: INSERT INTO okl_fe_eo_terms_all_b
1744: (end_of_term_id

Line 1814: okc_api.end_activity(x_msg_count

1810:
1811: --Set OUT Values
1812:
1813: x_ethb_rec := l_ethb_rec;
1814: okc_api.end_activity(x_msg_count
1815: ,x_msg_data);
1816: EXCEPTION
1817: WHEN g_exception_halt_validation THEN
1818:

Line 1822: WHEN okc_api.g_exception_error THEN

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

Line 1829: WHEN okc_api.g_exception_unexpected_error THEN

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

Line 1850: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1846: -- Procedure insert_row_tl
1847: --------------------------------------------------------------------------------
1848:
1849: PROCEDURE insert_row(p_api_version IN NUMBER
1850: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1851: ,x_return_status OUT NOCOPY VARCHAR2
1852: ,x_msg_count OUT NOCOPY NUMBER
1853: ,x_msg_data OUT NOCOPY VARCHAR2
1854: ,p_ethtl_rec IN okl_ethtl_rec

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

1864: WHERE installed_flag IN('I', 'B');
1865:
1866: FUNCTION set_attributes(p_ethtl_rec IN okl_ethtl_rec
1867: ,x_ethtl_rec OUT NOCOPY okl_ethtl_rec) RETURN VARCHAR2 IS
1868: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
1869:
1870: BEGIN
1871: x_ethtl_rec := p_ethtl_rec;
1872: x_ethtl_rec.sfwt_flag := 'N';

Line 1879: l_return_status := okc_api.start_activity(l_api_name

1875: RETURN(l_return_status);
1876: END set_attributes;
1877:
1878: BEGIN
1879: l_return_status := okc_api.start_activity(l_api_name
1880: ,g_pkg_name
1881: ,p_init_msg_list
1882: ,l_api_version
1883: ,p_api_version

Line 1888: RAISE okc_api.g_exception_unexpected_error;

1884: ,'_PVT'
1885: ,x_return_status);
1886:
1887: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1888: RAISE okc_api.g_exception_unexpected_error;
1889: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1890: RAISE okc_api.g_exception_error;
1891: END IF;
1892:

Line 1890: RAISE okc_api.g_exception_error;

1886:
1887: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1888: RAISE okc_api.g_exception_unexpected_error;
1889: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1890: RAISE okc_api.g_exception_error;
1891: END IF;
1892:
1893: --Setting Item Attributes
1894:

Line 1899: RAISE okc_api.g_exception_unexpected_error;

1895: l_return_status := set_attributes(p_ethtl_rec
1896: ,l_ethtl_rec);
1897:
1898: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1899: RAISE okc_api.g_exception_unexpected_error;
1900: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1901: RAISE okc_api.g_exception_error;
1902: END IF;
1903:

Line 1901: RAISE okc_api.g_exception_error;

1897:
1898: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1899: RAISE okc_api.g_exception_unexpected_error;
1900: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1901: RAISE okc_api.g_exception_error;
1902: END IF;
1903:
1904: FOR l_lang_rec IN get_languages LOOP
1905: l_ethtl_rec.language := l_lang_rec.language_code;

Line 1934: okc_api.end_activity(x_msg_count

1930:
1931: --Set OUT Values
1932:
1933: x_ethtl_rec := l_ethtl_rec;
1934: okc_api.end_activity(x_msg_count
1935: ,x_msg_data);
1936: EXCEPTION
1937: WHEN g_exception_halt_validation THEN
1938:

Line 1942: WHEN okc_api.g_exception_error THEN

1938:
1939: -- No action necessary. Validation can continue to next attribute/column
1940:
1941: NULL;
1942: WHEN okc_api.g_exception_error THEN
1943: x_return_status := okl_api.handle_exceptions(l_api_name
1944: ,g_pkg_name
1945: ,'OKL_API.G_RET_STS_ERROR'
1946: ,x_msg_count

Line 1949: WHEN okc_api.g_exception_unexpected_error THEN

1945: ,'OKL_API.G_RET_STS_ERROR'
1946: ,x_msg_count
1947: ,x_msg_data
1948: ,'_PVT');
1949: WHEN okc_api.g_exception_unexpected_error THEN
1950: x_return_status := okl_api.handle_exceptions(l_api_name
1951: ,g_pkg_name
1952: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1953: ,x_msg_count

Line 1970: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1966: -- Procedure insert_row_v
1967: --------------------------------------------------------------------------------
1968:
1969: PROCEDURE insert_row(p_api_version IN NUMBER
1970: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1971: ,x_return_status OUT NOCOPY VARCHAR2
1972: ,x_msg_count OUT NOCOPY NUMBER
1973: ,x_msg_data OUT NOCOPY VARCHAR2
1974: ,p_ethv_rec IN okl_ethv_rec

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

1996: END fill_who_columns;
1997:
1998: FUNCTION set_attributes(p_ethv_rec IN okl_ethv_rec
1999: ,x_ethv_rec OUT NOCOPY okl_ethv_rec) RETURN VARCHAR2 IS
2000: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
2001:
2002: BEGIN
2003: x_ethv_rec := p_ethv_rec;
2004: x_ethv_rec.object_version_number := 1;

Line 2010: l_return_status := okc_api.start_activity(l_api_name

2006: RETURN(l_return_status);
2007: END set_attributes;
2008:
2009: BEGIN
2010: l_return_status := okc_api.start_activity(l_api_name
2011: ,g_pkg_name
2012: ,p_init_msg_list
2013: ,l_api_version
2014: ,p_api_version

Line 2019: RAISE okc_api.g_exception_unexpected_error;

2015: ,'_PVT'
2016: ,x_return_status);
2017:
2018: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2019: RAISE okc_api.g_exception_unexpected_error;
2020: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2021: RAISE okc_api.g_exception_error;
2022: END IF;
2023: l_ethv_rec := null_out_defaults(p_ethv_rec);

Line 2021: RAISE okc_api.g_exception_error;

2017:
2018: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2019: RAISE okc_api.g_exception_unexpected_error;
2020: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2021: RAISE okc_api.g_exception_error;
2022: END IF;
2023: l_ethv_rec := null_out_defaults(p_ethv_rec);
2024:
2025: -- Set Primary key value

Line 2035: RAISE okc_api.g_exception_unexpected_error;

2031: l_return_status := set_attributes(l_ethv_rec
2032: ,l_def_ethv_rec);
2033:
2034: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2035: RAISE okc_api.g_exception_unexpected_error;
2036: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2037: RAISE okc_api.g_exception_error;
2038: END IF;
2039: l_def_ethv_rec := fill_who_columns(l_def_ethv_rec);

Line 2037: RAISE okc_api.g_exception_error;

2033:
2034: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2035: RAISE okc_api.g_exception_unexpected_error;
2036: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2037: RAISE okc_api.g_exception_error;
2038: END IF;
2039: l_def_ethv_rec := fill_who_columns(l_def_ethv_rec);
2040: l_return_status := validate_attributes(l_def_ethv_rec);
2041:

Line 2043: RAISE okc_api.g_exception_unexpected_error;

2039: l_def_ethv_rec := fill_who_columns(l_def_ethv_rec);
2040: l_return_status := validate_attributes(l_def_ethv_rec);
2041:
2042: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2043: RAISE okc_api.g_exception_unexpected_error;
2044: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2045: RAISE okc_api.g_exception_error;
2046: END IF;
2047: l_return_status := validate_record(l_def_ethv_rec);

Line 2045: RAISE okc_api.g_exception_error;

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

Line 2050: RAISE okc_api.g_exception_unexpected_error;

2046: END IF;
2047: l_return_status := validate_record(l_def_ethv_rec);
2048:
2049: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2050: RAISE okc_api.g_exception_unexpected_error;
2051: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2052: RAISE okc_api.g_exception_error;
2053: END IF;
2054: migrate(l_def_ethv_rec

Line 2052: RAISE okc_api.g_exception_error;

2048:
2049: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2050: RAISE okc_api.g_exception_unexpected_error;
2051: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2052: RAISE okc_api.g_exception_error;
2053: END IF;
2054: migrate(l_def_ethv_rec
2055: ,l_ethb_rec);
2056: migrate(l_def_ethv_rec

Line 2067: RAISE okc_api.g_exception_unexpected_error;

2063: ,l_ethb_rec
2064: ,lx_ethb_rec);
2065:
2066: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2067: RAISE okc_api.g_exception_unexpected_error;
2068: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2069: RAISE okc_api.g_exception_error;
2070: END IF;
2071: migrate(lx_ethb_rec

Line 2069: RAISE okc_api.g_exception_error;

2065:
2066: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2067: RAISE okc_api.g_exception_unexpected_error;
2068: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2069: RAISE okc_api.g_exception_error;
2070: END IF;
2071: migrate(lx_ethb_rec
2072: ,l_def_ethv_rec);
2073: insert_row(p_api_version

Line 2082: RAISE okc_api.g_exception_unexpected_error;

2078: ,l_ethtl_rec
2079: ,lx_ethtl_rec);
2080:
2081: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2082: RAISE okc_api.g_exception_unexpected_error;
2083: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2084: RAISE okc_api.g_exception_error;
2085: END IF;
2086: migrate(lx_ethtl_rec

Line 2084: RAISE okc_api.g_exception_error;

2080:
2081: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2082: RAISE okc_api.g_exception_unexpected_error;
2083: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2084: RAISE okc_api.g_exception_error;
2085: END IF;
2086: migrate(lx_ethtl_rec
2087: ,l_def_ethv_rec);
2088:

Line 2092: okc_api.end_activity(x_msg_count

2088:
2089: --Set OUT Values
2090:
2091: x_ethv_rec := l_def_ethv_rec;
2092: okc_api.end_activity(x_msg_count
2093: ,x_msg_data);
2094: EXCEPTION
2095: WHEN g_exception_halt_validation THEN
2096:

Line 2100: WHEN okc_api.g_exception_error THEN

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

Line 2107: WHEN okc_api.g_exception_unexpected_error THEN

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

Line 2128: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2124: -- Procedure insert_row_tbl
2125: --------------------------------------------------------------------------------
2126:
2127: PROCEDURE insert_row(p_api_version IN NUMBER
2128: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2129: ,x_return_status OUT NOCOPY VARCHAR2
2130: ,x_msg_count OUT NOCOPY NUMBER
2131: ,x_msg_data OUT NOCOPY VARCHAR2
2132: ,p_ethv_tbl IN okl_ethv_tbl

Line 2141: okc_api.init_msg_list(p_init_msg_list);

2137: i NUMBER := 0;
2138: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2139:
2140: BEGIN
2141: okc_api.init_msg_list(p_init_msg_list);
2142:
2143: -- Make sure PL/SQL table has records in it before passing
2144:
2145: IF (p_ethv_tbl.COUNT > 0) THEN

Line 2150: ,p_init_msg_list => okc_api.g_false

2146: i := p_ethv_tbl.FIRST;
2147:
2148: LOOP
2149: insert_row(p_api_version => p_api_version
2150: ,p_init_msg_list => okc_api.g_false
2151: ,x_return_status => x_return_status
2152: ,x_msg_count => x_msg_count
2153: ,x_msg_data => x_msg_data
2154: ,p_ethv_rec => p_ethv_tbl(i)

Line 2156: IF x_return_status <> okc_api.g_ret_sts_success THEN

2152: ,x_msg_count => x_msg_count
2153: ,x_msg_data => x_msg_data
2154: ,p_ethv_rec => p_ethv_tbl(i)
2155: ,x_ethv_rec => x_ethv_tbl(i));
2156: IF x_return_status <> okc_api.g_ret_sts_success THEN
2157: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
2158: l_overall_status := x_return_status;
2159: END IF;
2160: END IF;

Line 2157: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

2153: ,x_msg_data => x_msg_data
2154: ,p_ethv_rec => p_ethv_tbl(i)
2155: ,x_ethv_rec => x_ethv_tbl(i));
2156: IF x_return_status <> okc_api.g_ret_sts_success THEN
2157: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
2158: l_overall_status := x_return_status;
2159: END IF;
2160: END IF;
2161: EXIT WHEN(i = p_ethv_tbl.LAST);

Line 2173: WHEN okc_api.g_exception_error THEN

2169:
2170: -- No action necessary. Validation can continue to next attribute/column
2171:
2172: NULL;
2173: WHEN okc_api.g_exception_error THEN
2174: x_return_status := okl_api.handle_exceptions(l_api_name
2175: ,g_pkg_name
2176: ,'OKL_API.G_RET_STS_ERROR'
2177: ,x_msg_count

Line 2180: WHEN okc_api.g_exception_unexpected_error THEN

2176: ,'OKL_API.G_RET_STS_ERROR'
2177: ,x_msg_count
2178: ,x_msg_data
2179: ,'_PVT');
2180: WHEN okc_api.g_exception_unexpected_error THEN
2181: x_return_status := okl_api.handle_exceptions(l_api_name
2182: ,g_pkg_name
2183: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2184: ,x_msg_count

Line 2201: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2197: -- Procedure update_row_b
2198: --------------------------------------------------------------------------------
2199:
2200: PROCEDURE update_row(p_api_version IN NUMBER
2201: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2202: ,x_return_status OUT NOCOPY VARCHAR2
2203: ,x_msg_count OUT NOCOPY NUMBER
2204: ,x_msg_data OUT NOCOPY VARCHAR2
2205: ,p_ethb_rec IN okl_ethb_rec

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

2212: l_row_notfound BOOLEAN := true;
2213:
2214: FUNCTION set_attributes(p_ethb_rec IN okl_ethb_rec
2215: ,x_ethb_rec OUT NOCOPY okl_ethb_rec) RETURN VARCHAR2 IS
2216: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
2217:
2218: BEGIN
2219: x_ethb_rec := p_ethb_rec;
2220: RETURN(l_return_status);

Line 2224: l_return_status := okc_api.start_activity(l_api_name

2220: RETURN(l_return_status);
2221: END set_attributes;
2222:
2223: BEGIN
2224: l_return_status := okc_api.start_activity(l_api_name
2225: ,g_pkg_name
2226: ,p_init_msg_list
2227: ,l_api_version
2228: ,p_api_version

Line 2233: RAISE okc_api.g_exception_unexpected_error;

2229: ,'_PVT'
2230: ,x_return_status);
2231:
2232: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2233: RAISE okc_api.g_exception_unexpected_error;
2234: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2235: RAISE okc_api.g_exception_error;
2236: END IF;
2237:

Line 2235: RAISE okc_api.g_exception_error;

2231:
2232: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2233: RAISE okc_api.g_exception_unexpected_error;
2234: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2235: RAISE okc_api.g_exception_error;
2236: END IF;
2237:
2238: --Setting Item Attributes
2239:

Line 2244: RAISE okc_api.g_exception_unexpected_error;

2240: l_return_status := set_attributes(p_ethb_rec
2241: ,l_def_ethb_rec);
2242:
2243: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2244: RAISE okc_api.g_exception_unexpected_error;
2245: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2246: RAISE okc_api.g_exception_error;
2247: END IF;
2248:

Line 2246: RAISE okc_api.g_exception_error;

2242:
2243: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2244: RAISE okc_api.g_exception_unexpected_error;
2245: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2246: RAISE okc_api.g_exception_error;
2247: END IF;
2248:
2249: UPDATE okl_fe_eo_terms_all_b
2250: SET end_of_term_id = l_def_ethb_rec.end_of_term_id

Line 2288: okc_api.end_activity(x_msg_count

2284:
2285: --Set OUT Values
2286:
2287: x_ethb_rec := l_ethb_rec;
2288: okc_api.end_activity(x_msg_count
2289: ,x_msg_data);
2290: EXCEPTION
2291: WHEN g_exception_halt_validation THEN
2292:

Line 2296: WHEN okc_api.g_exception_error THEN

2292:
2293: -- No action necessary. Validation can continue to next attribute/column
2294:
2295: NULL;
2296: WHEN okc_api.g_exception_error THEN
2297: x_return_status := okl_api.handle_exceptions(l_api_name
2298: ,g_pkg_name
2299: ,'OKL_API.G_RET_STS_ERROR'
2300: ,x_msg_count

Line 2303: WHEN okc_api.g_exception_unexpected_error THEN

2299: ,'OKL_API.G_RET_STS_ERROR'
2300: ,x_msg_count
2301: ,x_msg_data
2302: ,'_PVT');
2303: WHEN okc_api.g_exception_unexpected_error THEN
2304: x_return_status := okl_api.handle_exceptions(l_api_name
2305: ,g_pkg_name
2306: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2307: ,x_msg_count

Line 2324: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2320: -- Procedure update_row_tl
2321: --------------------------------------------------------------------------------
2322:
2323: PROCEDURE update_row(p_api_version IN NUMBER
2324: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2325: ,x_return_status OUT NOCOPY VARCHAR2
2326: ,x_msg_count OUT NOCOPY NUMBER
2327: ,x_msg_data OUT NOCOPY VARCHAR2
2328: ,p_ethtl_rec IN okl_ethtl_rec

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

2335: l_row_notfound BOOLEAN := true;
2336:
2337: FUNCTION set_attributes(p_ethtl_rec IN okl_ethtl_rec
2338: ,x_ethtl_rec OUT NOCOPY okl_ethtl_rec) RETURN VARCHAR2 IS
2339: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
2340:
2341: BEGIN
2342: x_ethtl_rec := p_ethtl_rec;
2343: x_ethtl_rec.language := USERENV('LANG');

Line 2349: l_return_status := okc_api.start_activity(l_api_name

2345: RETURN(l_return_status);
2346: END set_attributes;
2347:
2348: BEGIN
2349: l_return_status := okc_api.start_activity(l_api_name
2350: ,g_pkg_name
2351: ,p_init_msg_list
2352: ,l_api_version
2353: ,p_api_version

Line 2358: RAISE okc_api.g_exception_unexpected_error;

2354: ,'_PVT'
2355: ,x_return_status);
2356:
2357: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2358: RAISE okc_api.g_exception_unexpected_error;
2359: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2360: RAISE okc_api.g_exception_error;
2361: END IF;
2362:

Line 2360: RAISE okc_api.g_exception_error;

2356:
2357: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2358: RAISE okc_api.g_exception_unexpected_error;
2359: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2360: RAISE okc_api.g_exception_error;
2361: END IF;
2362:
2363: --Setting Item Attributes
2364:

Line 2369: RAISE okc_api.g_exception_unexpected_error;

2365: l_return_status := set_attributes(p_ethtl_rec
2366: ,l_def_ethtl_rec);
2367:
2368: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2369: RAISE okc_api.g_exception_unexpected_error;
2370: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2371: RAISE okc_api.g_exception_error;
2372: END IF;
2373:

Line 2371: RAISE okc_api.g_exception_error;

2367:
2368: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2369: RAISE okc_api.g_exception_unexpected_error;
2370: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2371: RAISE okc_api.g_exception_error;
2372: END IF;
2373:
2374: UPDATE okl_fe_eo_terms_all_tl
2375: SET end_of_term_id = l_def_ethtl_rec.end_of_term_id

Line 2396: okc_api.end_activity(x_msg_count

2392:
2393: --Set OUT Values
2394:
2395: x_ethtl_rec := l_ethtl_rec;
2396: okc_api.end_activity(x_msg_count
2397: ,x_msg_data);
2398: EXCEPTION
2399: WHEN g_exception_halt_validation THEN
2400:

Line 2404: WHEN okc_api.g_exception_error THEN

2400:
2401: -- No action necessary. Validation can continue to next attribute/column
2402:
2403: NULL;
2404: WHEN okc_api.g_exception_error THEN
2405: x_return_status := okl_api.handle_exceptions(l_api_name
2406: ,g_pkg_name
2407: ,'OKL_API.G_RET_STS_ERROR'
2408: ,x_msg_count

Line 2411: WHEN okc_api.g_exception_unexpected_error THEN

2407: ,'OKL_API.G_RET_STS_ERROR'
2408: ,x_msg_count
2409: ,x_msg_data
2410: ,'_PVT');
2411: WHEN okc_api.g_exception_unexpected_error THEN
2412: x_return_status := okl_api.handle_exceptions(l_api_name
2413: ,g_pkg_name
2414: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2415: ,x_msg_count

Line 2432: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2428: -- Procedure insert_row_v
2429: --------------------------------------------------------------------------------
2430:
2431: PROCEDURE update_row(p_api_version IN NUMBER
2432: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2433: ,x_return_status OUT NOCOPY VARCHAR2
2434: ,x_msg_count OUT NOCOPY NUMBER
2435: ,x_msg_data OUT NOCOPY VARCHAR2
2436: ,p_ethv_rec IN okl_ethv_rec

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

2613: END populate_new_record;
2614:
2615: FUNCTION set_attributes(p_ethv_rec IN okl_ethv_rec
2616: ,x_ethv_rec OUT NOCOPY okl_ethv_rec) RETURN VARCHAR2 IS
2617: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
2618:
2619: BEGIN
2620: x_ethv_rec := p_ethv_rec;
2621: RETURN(l_return_status);

Line 2625: l_return_status := okc_api.start_activity(l_api_name

2621: RETURN(l_return_status);
2622: END set_attributes;
2623:
2624: BEGIN
2625: l_return_status := okc_api.start_activity(l_api_name
2626: ,g_pkg_name
2627: ,p_init_msg_list
2628: ,l_api_version
2629: ,p_api_version

Line 2634: RAISE okc_api.g_exception_unexpected_error;

2630: ,'_PVT'
2631: ,x_return_status);
2632:
2633: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2634: RAISE okc_api.g_exception_unexpected_error;
2635: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2636: RAISE okc_api.g_exception_error;
2637: END IF;
2638:

Line 2636: RAISE okc_api.g_exception_error;

2632:
2633: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2634: RAISE okc_api.g_exception_unexpected_error;
2635: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2636: RAISE okc_api.g_exception_error;
2637: END IF;
2638:
2639: --Setting Item Attributes
2640:

Line 2645: RAISE okc_api.g_exception_unexpected_error;

2641: l_return_status := set_attributes(l_ethv_rec
2642: ,lx_ethv_rec);
2643:
2644: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2645: RAISE okc_api.g_exception_unexpected_error;
2646: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2647: RAISE okc_api.g_exception_error;
2648: END IF;
2649: l_return_status := populate_new_record(lx_ethv_rec

Line 2647: RAISE okc_api.g_exception_error;

2643:
2644: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2645: RAISE okc_api.g_exception_unexpected_error;
2646: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2647: RAISE okc_api.g_exception_error;
2648: END IF;
2649: l_return_status := populate_new_record(lx_ethv_rec
2650: ,l_def_ethv_rec);
2651:

Line 2653: RAISE okc_api.g_exception_unexpected_error;

2649: l_return_status := populate_new_record(lx_ethv_rec
2650: ,l_def_ethv_rec);
2651:
2652: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2653: RAISE okc_api.g_exception_unexpected_error;
2654: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2655: RAISE okc_api.g_exception_error;
2656: END IF;
2657: l_def_ethv_rec := null_out_defaults(l_def_ethv_rec);

Line 2655: RAISE okc_api.g_exception_error;

2651:
2652: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2653: RAISE okc_api.g_exception_unexpected_error;
2654: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2655: RAISE okc_api.g_exception_error;
2656: END IF;
2657: l_def_ethv_rec := null_out_defaults(l_def_ethv_rec);
2658: l_def_ethv_rec := fill_who_columns(l_def_ethv_rec);
2659: l_return_status := validate_attributes(l_def_ethv_rec);

Line 2662: RAISE okc_api.g_exception_unexpected_error;

2658: l_def_ethv_rec := fill_who_columns(l_def_ethv_rec);
2659: l_return_status := validate_attributes(l_def_ethv_rec);
2660:
2661: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2662: RAISE okc_api.g_exception_unexpected_error;
2663: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2664: RAISE okc_api.g_exception_error;
2665: END IF;
2666: l_return_status := validate_record(l_def_ethv_rec);

Line 2664: RAISE okc_api.g_exception_error;

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

Line 2669: RAISE okc_api.g_exception_unexpected_error;

2665: END IF;
2666: l_return_status := validate_record(l_def_ethv_rec);
2667:
2668: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2669: RAISE okc_api.g_exception_unexpected_error;
2670: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2671: RAISE okc_api.g_exception_error;
2672: END IF;
2673:

Line 2671: RAISE okc_api.g_exception_error;

2667:
2668: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2669: RAISE okc_api.g_exception_unexpected_error;
2670: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2671: RAISE okc_api.g_exception_error;
2672: END IF;
2673:
2674: --lock the row
2675:

Line 2701: RAISE okc_api.g_exception_unexpected_error;

2697: ,l_ethb_rec
2698: ,lx_ethb_rec);
2699:
2700: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2701: RAISE okc_api.g_exception_unexpected_error;
2702: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2703: RAISE okc_api.g_exception_error;
2704: END IF;
2705: migrate(lx_ethb_rec

Line 2703: RAISE okc_api.g_exception_error;

2699:
2700: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2701: RAISE okc_api.g_exception_unexpected_error;
2702: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2703: RAISE okc_api.g_exception_error;
2704: END IF;
2705: migrate(lx_ethb_rec
2706: ,l_def_ethv_rec);
2707: update_row(p_api_version

Line 2716: RAISE okc_api.g_exception_unexpected_error;

2712: ,l_ethtl_rec
2713: ,lx_ethtl_rec);
2714:
2715: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2716: RAISE okc_api.g_exception_unexpected_error;
2717: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2718: RAISE okc_api.g_exception_error;
2719: END IF;
2720: migrate(lx_ethtl_rec

Line 2718: RAISE okc_api.g_exception_error;

2714:
2715: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
2716: RAISE okc_api.g_exception_unexpected_error;
2717: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
2718: RAISE okc_api.g_exception_error;
2719: END IF;
2720: migrate(lx_ethtl_rec
2721: ,l_def_ethv_rec);
2722:

Line 2726: okc_api.end_activity(x_msg_count

2722:
2723: --Set OUT Values
2724:
2725: x_ethv_rec := l_def_ethv_rec;
2726: okc_api.end_activity(x_msg_count
2727: ,x_msg_data);
2728: EXCEPTION
2729: WHEN g_exception_halt_validation THEN
2730:

Line 2734: WHEN okc_api.g_exception_error THEN

2730:
2731: -- No action necessary. Validation can continue to next attribute/column
2732:
2733: NULL;
2734: WHEN okc_api.g_exception_error THEN
2735: x_return_status := okl_api.handle_exceptions(l_api_name
2736: ,g_pkg_name
2737: ,'OKL_API.G_RET_STS_ERROR'
2738: ,x_msg_count

Line 2741: WHEN okc_api.g_exception_unexpected_error THEN

2737: ,'OKL_API.G_RET_STS_ERROR'
2738: ,x_msg_count
2739: ,x_msg_data
2740: ,'_PVT');
2741: WHEN okc_api.g_exception_unexpected_error THEN
2742: x_return_status := okl_api.handle_exceptions(l_api_name
2743: ,g_pkg_name
2744: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2745: ,x_msg_count

Line 2762: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2758: -- Procedure insert_row_tbl
2759: --------------------------------------------------------------------------------
2760:
2761: PROCEDURE update_row(p_api_version IN NUMBER
2762: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2763: ,x_return_status OUT NOCOPY VARCHAR2
2764: ,x_msg_count OUT NOCOPY NUMBER
2765: ,x_msg_data OUT NOCOPY VARCHAR2
2766: ,p_ethv_tbl IN okl_ethv_tbl

Line 2775: okc_api.init_msg_list(p_init_msg_list);

2771: i NUMBER := 0;
2772: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2773:
2774: BEGIN
2775: okc_api.init_msg_list(p_init_msg_list);
2776:
2777: -- Make sure PL/SQL table has records in it before passing
2778:
2779: IF (p_ethv_tbl.COUNT > 0) THEN

Line 2784: ,p_init_msg_list => okc_api.g_false

2780: i := p_ethv_tbl.FIRST;
2781:
2782: LOOP
2783: update_row(p_api_version => p_api_version
2784: ,p_init_msg_list => okc_api.g_false
2785: ,x_return_status => x_return_status
2786: ,x_msg_count => x_msg_count
2787: ,x_msg_data => x_msg_data
2788: ,p_ethv_rec => p_ethv_tbl(i)

Line 2790: IF x_return_status <> okc_api.g_ret_sts_success THEN

2786: ,x_msg_count => x_msg_count
2787: ,x_msg_data => x_msg_data
2788: ,p_ethv_rec => p_ethv_tbl(i)
2789: ,x_ethv_rec => x_ethv_tbl(i));
2790: IF x_return_status <> okc_api.g_ret_sts_success THEN
2791: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
2792: l_overall_status := x_return_status;
2793: END IF;
2794: END IF;

Line 2791: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

2787: ,x_msg_data => x_msg_data
2788: ,p_ethv_rec => p_ethv_tbl(i)
2789: ,x_ethv_rec => x_ethv_tbl(i));
2790: IF x_return_status <> okc_api.g_ret_sts_success THEN
2791: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
2792: l_overall_status := x_return_status;
2793: END IF;
2794: END IF;
2795: EXIT WHEN(i = p_ethv_tbl.LAST);

Line 2807: WHEN okc_api.g_exception_error THEN

2803:
2804: -- No action necessary. Validation can continue to next attribute/column
2805:
2806: NULL;
2807: WHEN okc_api.g_exception_error THEN
2808: x_return_status := okl_api.handle_exceptions(l_api_name
2809: ,g_pkg_name
2810: ,'OKL_API.G_RET_STS_ERROR'
2811: ,x_msg_count

Line 2814: WHEN okc_api.g_exception_unexpected_error THEN

2810: ,'OKL_API.G_RET_STS_ERROR'
2811: ,x_msg_count
2812: ,x_msg_data
2813: ,'_PVT');
2814: WHEN okc_api.g_exception_unexpected_error THEN
2815: x_return_status := okl_api.handle_exceptions(l_api_name
2816: ,g_pkg_name
2817: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2818: ,x_msg_count

Line 2835: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2831: -- Procedure delete_row_b
2832: --------------------------------------------------------------------------------
2833:
2834: PROCEDURE delete_row(p_api_version IN NUMBER
2835: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2836: ,x_return_status OUT NOCOPY VARCHAR2
2837: ,x_msg_count OUT NOCOPY NUMBER
2838: ,x_msg_data OUT NOCOPY VARCHAR2
2839: ,p_ethb_rec IN okl_ethb_rec) IS

Line 2847: l_return_status := okc_api.start_activity(l_api_name

2843: l_ethb_rec okl_ethb_rec := p_ethb_rec;
2844: l_row_notfound BOOLEAN := true;
2845:
2846: BEGIN
2847: l_return_status := okc_api.start_activity(l_api_name
2848: ,g_pkg_name
2849: ,p_init_msg_list
2850: ,l_api_version
2851: ,p_api_version

Line 2856: RAISE okc_api.g_exception_unexpected_error;

2852: ,'_PVT'
2853: ,x_return_status);
2854:
2855: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2856: RAISE okc_api.g_exception_unexpected_error;
2857: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2858: RAISE okc_api.g_exception_error;
2859: END IF;
2860:

Line 2858: RAISE okc_api.g_exception_error;

2854:
2855: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2856: RAISE okc_api.g_exception_unexpected_error;
2857: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2858: RAISE okc_api.g_exception_error;
2859: END IF;
2860:
2861: DELETE FROM okl_fe_eo_terms_all_b
2862: WHERE end_of_term_id = l_ethb_rec.end_of_term_id;

Line 2870: WHEN okc_api.g_exception_error THEN

2866:
2867: -- No action necessary. Validation can continue to next attribute/column
2868:
2869: NULL;
2870: WHEN okc_api.g_exception_error THEN
2871: x_return_status := okl_api.handle_exceptions(l_api_name
2872: ,g_pkg_name
2873: ,'OKL_API.G_RET_STS_ERROR'
2874: ,x_msg_count

Line 2877: WHEN okc_api.g_exception_unexpected_error THEN

2873: ,'OKL_API.G_RET_STS_ERROR'
2874: ,x_msg_count
2875: ,x_msg_data
2876: ,'_PVT');
2877: WHEN okc_api.g_exception_unexpected_error THEN
2878: x_return_status := okl_api.handle_exceptions(l_api_name
2879: ,g_pkg_name
2880: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2881: ,x_msg_count

Line 2898: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2894: -- Procedure delete_row_tl
2895: --------------------------------------------------------------------------------
2896:
2897: PROCEDURE delete_row(p_api_version IN NUMBER
2898: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2899: ,x_return_status OUT NOCOPY VARCHAR2
2900: ,x_msg_count OUT NOCOPY NUMBER
2901: ,x_msg_data OUT NOCOPY VARCHAR2
2902: ,p_ethtl_rec IN okl_ethtl_rec) IS

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

2907: l_row_notfound BOOLEAN := true;
2908:
2909: FUNCTION set_attributes(p_ethtl_rec IN okl_ethtl_rec
2910: ,x_ethtl_rec OUT NOCOPY okl_ethtl_rec) RETURN VARCHAR2 IS
2911: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
2912:
2913: BEGIN
2914: x_ethtl_rec := p_ethtl_rec;
2915: x_ethtl_rec.language := USERENV('LANG');

Line 2921: l_return_status := okc_api.start_activity(l_api_name

2917: RETURN(l_return_status);
2918: END set_attributes;
2919:
2920: BEGIN
2921: l_return_status := okc_api.start_activity(l_api_name
2922: ,g_pkg_name
2923: ,p_init_msg_list
2924: ,l_api_version
2925: ,p_api_version

Line 2930: RAISE okc_api.g_exception_unexpected_error;

2926: ,'_PVT'
2927: ,x_return_status);
2928:
2929: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2930: RAISE okc_api.g_exception_unexpected_error;
2931: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2932: RAISE okc_api.g_exception_error;
2933: END IF;
2934:

Line 2932: RAISE okc_api.g_exception_error;

2928:
2929: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2930: RAISE okc_api.g_exception_unexpected_error;
2931: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2932: RAISE okc_api.g_exception_error;
2933: END IF;
2934:
2935: --Setting Item Attributes
2936:

Line 2941: RAISE okc_api.g_exception_unexpected_error;

2937: l_return_status := set_attributes(p_ethtl_rec
2938: ,l_ethtl_rec);
2939:
2940: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2941: RAISE okc_api.g_exception_unexpected_error;
2942: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2943: RAISE okc_api.g_exception_error;
2944: END IF;
2945:

Line 2943: RAISE okc_api.g_exception_error;

2939:
2940: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2941: RAISE okc_api.g_exception_unexpected_error;
2942: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2943: RAISE okc_api.g_exception_error;
2944: END IF;
2945:
2946: DELETE FROM okl_fe_eo_terms_all_tl
2947: WHERE end_of_term_id = l_ethtl_rec.end_of_term_id;

Line 2955: WHEN okc_api.g_exception_error THEN

2951:
2952: -- No action necessary. Validation can continue to next attribute/column
2953:
2954: NULL;
2955: WHEN okc_api.g_exception_error THEN
2956: x_return_status := okl_api.handle_exceptions(l_api_name
2957: ,g_pkg_name
2958: ,'OKL_API.G_RET_STS_ERROR'
2959: ,x_msg_count

Line 2962: WHEN okc_api.g_exception_unexpected_error THEN

2958: ,'OKL_API.G_RET_STS_ERROR'
2959: ,x_msg_count
2960: ,x_msg_data
2961: ,'_PVT');
2962: WHEN okc_api.g_exception_unexpected_error THEN
2963: x_return_status := okl_api.handle_exceptions(l_api_name
2964: ,g_pkg_name
2965: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2966: ,x_msg_count

Line 2983: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

2979: -- Procedure delete_row_v
2980: --------------------------------------------------------------------------------
2981:
2982: PROCEDURE delete_row(p_api_version IN NUMBER
2983: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
2984: ,x_return_status OUT NOCOPY VARCHAR2
2985: ,x_msg_count OUT NOCOPY NUMBER
2986: ,x_msg_data OUT NOCOPY VARCHAR2
2987: ,p_ethv_rec IN okl_ethv_rec) IS

Line 2996: l_return_status := okc_api.start_activity(l_api_name

2992: l_ethb_rec okl_ethb_rec;
2993: l_ethtl_rec okl_ethtl_rec;
2994:
2995: BEGIN
2996: l_return_status := okc_api.start_activity(l_api_name
2997: ,g_pkg_name
2998: ,p_init_msg_list
2999: ,l_api_version
3000: ,p_api_version

Line 3005: RAISE okc_api.g_exception_unexpected_error;

3001: ,'_PVT'
3002: ,x_return_status);
3003:
3004: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
3005: RAISE okc_api.g_exception_unexpected_error;
3006: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3007: RAISE okc_api.g_exception_error;
3008: END IF;
3009: migrate(l_ethv_rec

Line 3007: RAISE okc_api.g_exception_error;

3003:
3004: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
3005: RAISE okc_api.g_exception_unexpected_error;
3006: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3007: RAISE okc_api.g_exception_error;
3008: END IF;
3009: migrate(l_ethv_rec
3010: ,l_ethb_rec);
3011: migrate(l_ethv_rec

Line 3021: RAISE okc_api.g_exception_unexpected_error;

3017: ,x_msg_data
3018: ,l_ethb_rec);
3019:
3020: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
3021: RAISE okc_api.g_exception_unexpected_error;
3022: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3023: RAISE okc_api.g_exception_error;
3024: END IF;
3025: delete_row(p_api_version

Line 3023: RAISE okc_api.g_exception_error;

3019:
3020: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
3021: RAISE okc_api.g_exception_unexpected_error;
3022: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3023: RAISE okc_api.g_exception_error;
3024: END IF;
3025: delete_row(p_api_version
3026: ,p_init_msg_list
3027: ,x_return_status

Line 3033: RAISE okc_api.g_exception_unexpected_error;

3029: ,x_msg_data
3030: ,l_ethtl_rec);
3031:
3032: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
3033: RAISE okc_api.g_exception_unexpected_error;
3034: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3035: RAISE okc_api.g_exception_error;
3036: END IF;
3037: okc_api.end_activity(x_msg_count

Line 3035: RAISE okc_api.g_exception_error;

3031:
3032: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
3033: RAISE okc_api.g_exception_unexpected_error;
3034: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3035: RAISE okc_api.g_exception_error;
3036: END IF;
3037: okc_api.end_activity(x_msg_count
3038: ,x_msg_data);
3039: EXCEPTION

Line 3037: okc_api.end_activity(x_msg_count

3033: RAISE okc_api.g_exception_unexpected_error;
3034: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3035: RAISE okc_api.g_exception_error;
3036: END IF;
3037: okc_api.end_activity(x_msg_count
3038: ,x_msg_data);
3039: EXCEPTION
3040: WHEN g_exception_halt_validation THEN
3041:

Line 3045: WHEN okc_api.g_exception_error THEN

3041:
3042: -- No action necessary. Validation can continue to next attribute/column
3043:
3044: NULL;
3045: WHEN okc_api.g_exception_error THEN
3046: x_return_status := okl_api.handle_exceptions(l_api_name
3047: ,g_pkg_name
3048: ,'OKL_API.G_RET_STS_ERROR'
3049: ,x_msg_count

Line 3052: WHEN okc_api.g_exception_unexpected_error THEN

3048: ,'OKL_API.G_RET_STS_ERROR'
3049: ,x_msg_count
3050: ,x_msg_data
3051: ,'_PVT');
3052: WHEN okc_api.g_exception_unexpected_error THEN
3053: x_return_status := okl_api.handle_exceptions(l_api_name
3054: ,g_pkg_name
3055: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
3056: ,x_msg_count

Line 3073: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

3069: -- Procedure delete_row_tbl
3070: --------------------------------------------------------------------------------
3071:
3072: PROCEDURE delete_row(p_api_version IN NUMBER
3073: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
3074: ,x_return_status OUT NOCOPY VARCHAR2
3075: ,x_msg_count OUT NOCOPY NUMBER
3076: ,x_msg_data OUT NOCOPY VARCHAR2
3077: ,p_ethv_tbl IN okl_ethv_tbl) IS

Line 3085: okc_api.init_msg_list(p_init_msg_list);

3081: i NUMBER := 0;
3082: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
3083:
3084: BEGIN
3085: okc_api.init_msg_list(p_init_msg_list);
3086:
3087: -- Make sure PL/SQL table has records in it before passing
3088:
3089: IF (p_ethv_tbl.COUNT > 0) THEN

Line 3094: ,p_init_msg_list => okc_api.g_false

3090: i := p_ethv_tbl.FIRST;
3091:
3092: LOOP
3093: delete_row(p_api_version => p_api_version
3094: ,p_init_msg_list => okc_api.g_false
3095: ,x_return_status => x_return_status
3096: ,x_msg_count => x_msg_count
3097: ,x_msg_data => x_msg_data
3098: ,p_ethv_rec => p_ethv_tbl(i));

Line 3099: IF x_return_status <> okc_api.g_ret_sts_success THEN

3095: ,x_return_status => x_return_status
3096: ,x_msg_count => x_msg_count
3097: ,x_msg_data => x_msg_data
3098: ,p_ethv_rec => p_ethv_tbl(i));
3099: IF x_return_status <> okc_api.g_ret_sts_success THEN
3100: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
3101: l_overall_status := x_return_status;
3102: END IF;
3103: END IF;

Line 3100: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

3096: ,x_msg_count => x_msg_count
3097: ,x_msg_data => x_msg_data
3098: ,p_ethv_rec => p_ethv_tbl(i));
3099: IF x_return_status <> okc_api.g_ret_sts_success THEN
3100: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
3101: l_overall_status := x_return_status;
3102: END IF;
3103: END IF;
3104: EXIT WHEN(i = p_ethv_tbl.LAST);

Line 3116: WHEN okc_api.g_exception_error THEN

3112:
3113: -- No action necessary. Validation can continue to next attribute/column
3114:
3115: NULL;
3116: WHEN okc_api.g_exception_error THEN
3117: x_return_status := okl_api.handle_exceptions(l_api_name
3118: ,g_pkg_name
3119: ,'OKL_API.G_RET_STS_ERROR'
3120: ,x_msg_count

Line 3123: WHEN okc_api.g_exception_unexpected_error THEN

3119: ,'OKL_API.G_RET_STS_ERROR'
3120: ,x_msg_count
3121: ,x_msg_data
3122: ,'_PVT');
3123: WHEN okc_api.g_exception_unexpected_error THEN
3124: x_return_status := okl_api.handle_exceptions(l_api_name
3125: ,g_pkg_name
3126: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
3127: ,x_msg_count