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 OKL_API

Line 81: x_return_status := okl_api.g_ret_sts_success;

77: BEGIN
78:
79: -- initialize the return status
80:
81: x_return_status := okl_api.g_ret_sts_success;
82:
83: -- END_OF_TERM_ID is a required field
84:
85: IF (p_ethv_rec.end_of_term_id IS NULL OR p_ethv_rec.end_of_term_id = okl_api.g_miss_num) THEN

Line 85: IF (p_ethv_rec.end_of_term_id IS NULL OR p_ethv_rec.end_of_term_id = okl_api.g_miss_num) THEN

81: x_return_status := okl_api.g_ret_sts_success;
82:
83: -- END_OF_TERM_ID is a required field
84:
85: IF (p_ethv_rec.end_of_term_id IS NULL OR p_ethv_rec.end_of_term_id = okl_api.g_miss_num) THEN
86: okl_api.set_message(p_app_name => g_app_name
87: ,p_msg_name => g_required_value
88: ,p_token1 => g_col_name_token
89: ,p_token1_value => 'END_OF_TERM_ID');

Line 86: okl_api.set_message(p_app_name => g_app_name

82:
83: -- END_OF_TERM_ID is a required field
84:
85: IF (p_ethv_rec.end_of_term_id IS NULL OR p_ethv_rec.end_of_term_id = okl_api.g_miss_num) THEN
86: okl_api.set_message(p_app_name => g_app_name
87: ,p_msg_name => g_required_value
88: ,p_token1 => g_col_name_token
89: ,p_token1_value => 'END_OF_TERM_ID');
90:

Line 93: x_return_status := okl_api.g_ret_sts_error;

89: ,p_token1_value => 'END_OF_TERM_ID');
90:
91: -- notify caller of an error
92:
93: x_return_status := okl_api.g_ret_sts_error;
94:
95: -- halt further validation of this column
96:
97: RAISE g_exception_halt_validation;

Line 129: x_return_status := okl_api.g_ret_sts_success;

125: BEGIN
126:
127: -- initialize the return status
128:
129: x_return_status := okl_api.g_ret_sts_success;
130:
131: -- object_version_number is a required field
132:
133: IF (p_ethv_rec.object_version_number IS NULL OR p_ethv_rec.object_version_number = okl_api.g_miss_num) THEN

Line 133: IF (p_ethv_rec.object_version_number IS NULL OR p_ethv_rec.object_version_number = okl_api.g_miss_num) THEN

129: x_return_status := okl_api.g_ret_sts_success;
130:
131: -- object_version_number is a required field
132:
133: IF (p_ethv_rec.object_version_number IS NULL OR p_ethv_rec.object_version_number = okl_api.g_miss_num) THEN
134: okl_api.set_message(p_app_name => g_app_name
135: ,p_msg_name => g_required_value
136: ,p_token1 => g_col_name_token
137: ,p_token1_value => 'object_version_number');

Line 134: okl_api.set_message(p_app_name => g_app_name

130:
131: -- object_version_number is a required field
132:
133: IF (p_ethv_rec.object_version_number IS NULL OR p_ethv_rec.object_version_number = okl_api.g_miss_num) THEN
134: okl_api.set_message(p_app_name => g_app_name
135: ,p_msg_name => g_required_value
136: ,p_token1 => g_col_name_token
137: ,p_token1_value => 'object_version_number');
138:

Line 141: x_return_status := okl_api.g_ret_sts_error;

137: ,p_token1_value => 'object_version_number');
138:
139: -- notify caller of an error
140:
141: x_return_status := okl_api.g_ret_sts_error;
142:
143: -- halt further validation of this column
144:
145: RAISE g_exception_halt_validation;

Line 209: okl_api.set_message(p_app_name => g_app_name

205: WHEN OTHERS THEN
206:
207: -- store SQL error message on message stack for caller
208:
209: okl_api.set_message(p_app_name => g_app_name
210: ,p_msg_name => g_unexpected_error
211: ,p_token1 => g_sqlcode_token
212: ,p_token1_value => sqlcode
213: ,p_token2 => g_sqlerrm_token

Line 236: IF (x_return_status <> okl_api.g_true) THEN

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
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');

Line 332: x_return_status := okl_api.g_ret_sts_unexp_error;

328: ,p_token2_value => sqlerrm);
329:
330: -- notify caller of an UNEXPECTED error
331:
332: x_return_status := okl_api.g_ret_sts_unexp_error;
333: END validate_eot_type_code;
334:
335: PROCEDURE validate_product_id(x_return_status OUT NOCOPY VARCHAR2
336: ,p_ethv_rec IN okl_ethv_rec) IS

Line 360: x_return_status := okl_api.g_ret_sts_error;

356: ,p_token1_value => 'product_id');
357:
358: -- notify caller of an error
359:
360: x_return_status := okl_api.g_ret_sts_error;
361:
362: -- halt further validation of this column
363:
364: RAISE g_exception_halt_validation;

Line 435: x_return_status := okl_api.g_ret_sts_error;

431: ,p_token1_value => 'CATEGORY_TYPE_CODE');
432:
433: -- notify caller of an error
434:
435: x_return_status := okl_api.g_ret_sts_error;
436:
437: -- halt further validation of this column
438:
439: RAISE g_exception_halt_validation;

Line 497: x_return_status := okl_api.g_ret_sts_success;

493: BEGIN
494:
495: -- Initialize the return status to success
496:
497: x_return_status := okl_api.g_ret_sts_success;
498:
499: IF (p_ethv_rec.orig_end_of_term_id IS NOT NULL AND p_ethv_rec.orig_end_of_term_id <> okl_api.g_miss_num) THEN
500: OPEN pos_exists_csr;
501: FETCH pos_exists_csr INTO l_dummy_var ;

Line 499: IF (p_ethv_rec.orig_end_of_term_id IS NOT NULL AND p_ethv_rec.orig_end_of_term_id <> okl_api.g_miss_num) THEN

495: -- Initialize the return status to success
496:
497: x_return_status := okl_api.g_ret_sts_success;
498:
499: IF (p_ethv_rec.orig_end_of_term_id IS NOT NULL AND p_ethv_rec.orig_end_of_term_id <> okl_api.g_miss_num) THEN
500: OPEN pos_exists_csr;
501: FETCH pos_exists_csr INTO l_dummy_var ;
502: CLOSE pos_exists_csr;
503:

Line 507: okl_api.set_message(p_app_name => g_app_name

503:
504: -- if l_dummy_var is still set to default, data was not found
505:
506: IF (l_dummy_var = '?') THEN
507: okl_api.set_message(p_app_name => g_app_name
508: ,p_msg_name => g_invalid_value
509: ,p_token1 => g_col_name_token
510: ,p_token1_value => 'ORIG_END_OF_TERM_ID');
511:

Line 556: x_return_status := okl_api.g_ret_sts_success;

552: BEGIN
553:
554: -- Initialize the return status to success
555:
556: x_return_status := okl_api.g_ret_sts_success;
557:
558: IF (p_ethv_rec.effective_from_date IS NULL OR p_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN
559: okl_api.set_message(p_app_name => g_app_name
560: ,p_msg_name => g_required_value

Line 558: IF (p_ethv_rec.effective_from_date IS NULL OR p_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN

554: -- Initialize the return status to success
555:
556: x_return_status := okl_api.g_ret_sts_success;
557:
558: IF (p_ethv_rec.effective_from_date IS NULL OR p_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN
559: okl_api.set_message(p_app_name => g_app_name
560: ,p_msg_name => g_required_value
561: ,p_token1 => g_col_name_token
562: ,p_token1_value => 'EFFECTIVE_FROM_DATE');

Line 559: okl_api.set_message(p_app_name => g_app_name

555:
556: x_return_status := okl_api.g_ret_sts_success;
557:
558: IF (p_ethv_rec.effective_from_date IS NULL OR p_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN
559: okl_api.set_message(p_app_name => g_app_name
560: ,p_msg_name => g_required_value
561: ,p_token1 => g_col_name_token
562: ,p_token1_value => 'EFFECTIVE_FROM_DATE');
563:

Line 566: x_return_status := okl_api.g_ret_sts_error;

562: ,p_token1_value => 'EFFECTIVE_FROM_DATE');
563:
564: -- notify caller of an error
565:
566: x_return_status := okl_api.g_ret_sts_error;
567: RAISE g_exception_halt_validation;
568: END IF;
569:
570: EXCEPTION

Line 600: x_return_status := okl_api.g_ret_sts_success;

596: BEGIN
597:
598: -- Initialize the return status to success
599:
600: x_return_status := okl_api.g_ret_sts_success;
601:
602: -- Column is mandatory
603:
604: IF (p_ethv_rec.sts_code IS NULL OR p_ethv_rec.sts_code = okl_api.g_miss_char) THEN

Line 604: IF (p_ethv_rec.sts_code IS NULL OR p_ethv_rec.sts_code = okl_api.g_miss_char) THEN

600: x_return_status := okl_api.g_ret_sts_success;
601:
602: -- Column is mandatory
603:
604: IF (p_ethv_rec.sts_code IS NULL OR p_ethv_rec.sts_code = okl_api.g_miss_char) THEN
605: okl_api.set_message(p_app_name => g_app_name
606: ,p_msg_name => g_required_value
607: ,p_token1 => g_col_name_token
608: ,p_token1_value => 'sts_code');

Line 605: okl_api.set_message(p_app_name => g_app_name

601:
602: -- Column is mandatory
603:
604: IF (p_ethv_rec.sts_code IS NULL OR p_ethv_rec.sts_code = okl_api.g_miss_char) THEN
605: okl_api.set_message(p_app_name => g_app_name
606: ,p_msg_name => g_required_value
607: ,p_token1 => g_col_name_token
608: ,p_token1_value => 'sts_code');
609:

Line 612: x_return_status := okl_api.g_ret_sts_error;

608: ,p_token1_value => 'sts_code');
609:
610: -- notify caller of an error
611:
612: x_return_status := okl_api.g_ret_sts_error;
613: RAISE g_exception_halt_validation;
614: END IF;
615:
616: -- Lookup Code Validation

Line 1025: IF (l_ethv_rec.end_of_term_id = okl_api.g_miss_num) THEN

1021: l_ethv_rec okl_ethv_rec := p_ethv_rec;
1022:
1023: BEGIN
1024:
1025: IF (l_ethv_rec.end_of_term_id = okl_api.g_miss_num) THEN
1026: l_ethv_rec.end_of_term_id := NULL;
1027: END IF;
1028:
1029: IF (l_ethv_rec.object_version_number = okl_api.g_miss_num) THEN

Line 1029: IF (l_ethv_rec.object_version_number = okl_api.g_miss_num) THEN

1025: IF (l_ethv_rec.end_of_term_id = okl_api.g_miss_num) THEN
1026: l_ethv_rec.end_of_term_id := NULL;
1027: END IF;
1028:
1029: IF (l_ethv_rec.object_version_number = okl_api.g_miss_num) THEN
1030: l_ethv_rec.object_version_number := NULL;
1031: END IF;
1032:
1033: IF (l_ethv_rec.end_of_term_name = okl_api.g_miss_char) THEN

Line 1033: IF (l_ethv_rec.end_of_term_name = okl_api.g_miss_char) THEN

1029: IF (l_ethv_rec.object_version_number = okl_api.g_miss_num) THEN
1030: l_ethv_rec.object_version_number := NULL;
1031: END IF;
1032:
1033: IF (l_ethv_rec.end_of_term_name = okl_api.g_miss_char) THEN
1034: l_ethv_rec.end_of_term_name := NULL;
1035: END IF;
1036:
1037: IF (l_ethv_rec.end_of_term_desc = okl_api.g_miss_char) THEN

Line 1037: IF (l_ethv_rec.end_of_term_desc = okl_api.g_miss_char) THEN

1033: IF (l_ethv_rec.end_of_term_name = okl_api.g_miss_char) THEN
1034: l_ethv_rec.end_of_term_name := NULL;
1035: END IF;
1036:
1037: IF (l_ethv_rec.end_of_term_desc = okl_api.g_miss_char) THEN
1038: l_ethv_rec.end_of_term_desc := NULL;
1039: END IF;
1040:
1041: IF (l_ethv_rec.org_id = okl_api.g_miss_num) THEN

Line 1041: IF (l_ethv_rec.org_id = okl_api.g_miss_num) THEN

1037: IF (l_ethv_rec.end_of_term_desc = okl_api.g_miss_char) THEN
1038: l_ethv_rec.end_of_term_desc := NULL;
1039: END IF;
1040:
1041: IF (l_ethv_rec.org_id = okl_api.g_miss_num) THEN
1042: l_ethv_rec.org_id := NULL;
1043: END IF;
1044:
1045: IF (l_ethv_rec.currency_code = okl_api.g_miss_char) THEN

Line 1045: IF (l_ethv_rec.currency_code = okl_api.g_miss_char) THEN

1041: IF (l_ethv_rec.org_id = okl_api.g_miss_num) THEN
1042: l_ethv_rec.org_id := NULL;
1043: END IF;
1044:
1045: IF (l_ethv_rec.currency_code = okl_api.g_miss_char) THEN
1046: l_ethv_rec.currency_code := NULL;
1047: END IF;
1048:
1049: IF (l_ethv_rec.eot_type_code = okl_api.g_miss_char) THEN

Line 1049: IF (l_ethv_rec.eot_type_code = okl_api.g_miss_char) THEN

1045: IF (l_ethv_rec.currency_code = okl_api.g_miss_char) THEN
1046: l_ethv_rec.currency_code := NULL;
1047: END IF;
1048:
1049: IF (l_ethv_rec.eot_type_code = okl_api.g_miss_char) THEN
1050: l_ethv_rec.eot_type_code := NULL;
1051: END IF;
1052:
1053: IF (l_ethv_rec.product_id = okl_api.g_miss_num) THEN

Line 1053: IF (l_ethv_rec.product_id = okl_api.g_miss_num) THEN

1049: IF (l_ethv_rec.eot_type_code = okl_api.g_miss_char) THEN
1050: l_ethv_rec.eot_type_code := NULL;
1051: END IF;
1052:
1053: IF (l_ethv_rec.product_id = okl_api.g_miss_num) THEN
1054: l_ethv_rec.product_id := NULL;
1055: END IF;
1056:
1057: IF (l_ethv_rec.category_type_code = okl_api.g_miss_char) THEN

Line 1057: IF (l_ethv_rec.category_type_code = okl_api.g_miss_char) THEN

1053: IF (l_ethv_rec.product_id = okl_api.g_miss_num) THEN
1054: l_ethv_rec.product_id := NULL;
1055: END IF;
1056:
1057: IF (l_ethv_rec.category_type_code = okl_api.g_miss_char) THEN
1058: l_ethv_rec.category_type_code := NULL;
1059: END IF;
1060:
1061: IF (l_ethv_rec.orig_end_of_term_id = okl_api.g_miss_num) THEN

Line 1061: IF (l_ethv_rec.orig_end_of_term_id = okl_api.g_miss_num) THEN

1057: IF (l_ethv_rec.category_type_code = okl_api.g_miss_char) THEN
1058: l_ethv_rec.category_type_code := NULL;
1059: END IF;
1060:
1061: IF (l_ethv_rec.orig_end_of_term_id = okl_api.g_miss_num) THEN
1062: l_ethv_rec.orig_end_of_term_id := NULL;
1063: END IF;
1064:
1065: IF (l_ethv_rec.sts_code = okl_api.g_miss_char) THEN

Line 1065: IF (l_ethv_rec.sts_code = okl_api.g_miss_char) THEN

1061: IF (l_ethv_rec.orig_end_of_term_id = okl_api.g_miss_num) THEN
1062: l_ethv_rec.orig_end_of_term_id := NULL;
1063: END IF;
1064:
1065: IF (l_ethv_rec.sts_code = okl_api.g_miss_char) THEN
1066: l_ethv_rec.sts_code := NULL;
1067: END IF;
1068:
1069: IF (l_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN

Line 1069: IF (l_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN

1065: IF (l_ethv_rec.sts_code = okl_api.g_miss_char) THEN
1066: l_ethv_rec.sts_code := NULL;
1067: END IF;
1068:
1069: IF (l_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN
1070: l_ethv_rec.effective_from_date := NULL;
1071: END IF;
1072:
1073: IF (l_ethv_rec.effective_to_date = okl_api.g_miss_date) THEN

Line 1073: IF (l_ethv_rec.effective_to_date = okl_api.g_miss_date) THEN

1069: IF (l_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN
1070: l_ethv_rec.effective_from_date := NULL;
1071: END IF;
1072:
1073: IF (l_ethv_rec.effective_to_date = okl_api.g_miss_date) THEN
1074: l_ethv_rec.effective_to_date := NULL;
1075: END IF;
1076:
1077: IF (l_ethv_rec.attribute_category = okl_api.g_miss_char) THEN

Line 1077: IF (l_ethv_rec.attribute_category = okl_api.g_miss_char) THEN

1073: IF (l_ethv_rec.effective_to_date = okl_api.g_miss_date) THEN
1074: l_ethv_rec.effective_to_date := NULL;
1075: END IF;
1076:
1077: IF (l_ethv_rec.attribute_category = okl_api.g_miss_char) THEN
1078: l_ethv_rec.attribute_category := NULL;
1079: END IF;
1080:
1081: IF (l_ethv_rec.attribute1 = okl_api.g_miss_char) THEN

Line 1081: IF (l_ethv_rec.attribute1 = okl_api.g_miss_char) THEN

1077: IF (l_ethv_rec.attribute_category = okl_api.g_miss_char) THEN
1078: l_ethv_rec.attribute_category := NULL;
1079: END IF;
1080:
1081: IF (l_ethv_rec.attribute1 = okl_api.g_miss_char) THEN
1082: l_ethv_rec.attribute1 := NULL;
1083: END IF;
1084:
1085: IF (l_ethv_rec.attribute2 = okl_api.g_miss_char) THEN

Line 1085: IF (l_ethv_rec.attribute2 = okl_api.g_miss_char) THEN

1081: IF (l_ethv_rec.attribute1 = okl_api.g_miss_char) THEN
1082: l_ethv_rec.attribute1 := NULL;
1083: END IF;
1084:
1085: IF (l_ethv_rec.attribute2 = okl_api.g_miss_char) THEN
1086: l_ethv_rec.attribute2 := NULL;
1087: END IF;
1088:
1089: IF (l_ethv_rec.attribute3 = okl_api.g_miss_char) THEN

Line 1089: IF (l_ethv_rec.attribute3 = okl_api.g_miss_char) THEN

1085: IF (l_ethv_rec.attribute2 = okl_api.g_miss_char) THEN
1086: l_ethv_rec.attribute2 := NULL;
1087: END IF;
1088:
1089: IF (l_ethv_rec.attribute3 = okl_api.g_miss_char) THEN
1090: l_ethv_rec.attribute3 := NULL;
1091: END IF;
1092:
1093: IF (l_ethv_rec.attribute4 = okl_api.g_miss_char) THEN

Line 1093: IF (l_ethv_rec.attribute4 = okl_api.g_miss_char) THEN

1089: IF (l_ethv_rec.attribute3 = okl_api.g_miss_char) THEN
1090: l_ethv_rec.attribute3 := NULL;
1091: END IF;
1092:
1093: IF (l_ethv_rec.attribute4 = okl_api.g_miss_char) THEN
1094: l_ethv_rec.attribute4 := NULL;
1095: END IF;
1096:
1097: IF (l_ethv_rec.attribute5 = okl_api.g_miss_char) THEN

Line 1097: IF (l_ethv_rec.attribute5 = okl_api.g_miss_char) THEN

1093: IF (l_ethv_rec.attribute4 = okl_api.g_miss_char) THEN
1094: l_ethv_rec.attribute4 := NULL;
1095: END IF;
1096:
1097: IF (l_ethv_rec.attribute5 = okl_api.g_miss_char) THEN
1098: l_ethv_rec.attribute5 := NULL;
1099: END IF;
1100:
1101: IF (l_ethv_rec.attribute6 = okl_api.g_miss_char) THEN

Line 1101: IF (l_ethv_rec.attribute6 = okl_api.g_miss_char) THEN

1097: IF (l_ethv_rec.attribute5 = okl_api.g_miss_char) THEN
1098: l_ethv_rec.attribute5 := NULL;
1099: END IF;
1100:
1101: IF (l_ethv_rec.attribute6 = okl_api.g_miss_char) THEN
1102: l_ethv_rec.attribute6 := NULL;
1103: END IF;
1104:
1105: IF (l_ethv_rec.attribute7 = okl_api.g_miss_char) THEN

Line 1105: IF (l_ethv_rec.attribute7 = okl_api.g_miss_char) THEN

1101: IF (l_ethv_rec.attribute6 = okl_api.g_miss_char) THEN
1102: l_ethv_rec.attribute6 := NULL;
1103: END IF;
1104:
1105: IF (l_ethv_rec.attribute7 = okl_api.g_miss_char) THEN
1106: l_ethv_rec.attribute7 := NULL;
1107: END IF;
1108:
1109: IF (l_ethv_rec.attribute8 = okl_api.g_miss_char) THEN

Line 1109: IF (l_ethv_rec.attribute8 = okl_api.g_miss_char) THEN

1105: IF (l_ethv_rec.attribute7 = okl_api.g_miss_char) THEN
1106: l_ethv_rec.attribute7 := NULL;
1107: END IF;
1108:
1109: IF (l_ethv_rec.attribute8 = okl_api.g_miss_char) THEN
1110: l_ethv_rec.attribute8 := NULL;
1111: END IF;
1112:
1113: IF (l_ethv_rec.attribute9 = okl_api.g_miss_char) THEN

Line 1113: IF (l_ethv_rec.attribute9 = okl_api.g_miss_char) THEN

1109: IF (l_ethv_rec.attribute8 = okl_api.g_miss_char) THEN
1110: l_ethv_rec.attribute8 := NULL;
1111: END IF;
1112:
1113: IF (l_ethv_rec.attribute9 = okl_api.g_miss_char) THEN
1114: l_ethv_rec.attribute9 := NULL;
1115: END IF;
1116:
1117: IF (l_ethv_rec.attribute10 = okl_api.g_miss_char) THEN

Line 1117: IF (l_ethv_rec.attribute10 = okl_api.g_miss_char) THEN

1113: IF (l_ethv_rec.attribute9 = okl_api.g_miss_char) THEN
1114: l_ethv_rec.attribute9 := NULL;
1115: END IF;
1116:
1117: IF (l_ethv_rec.attribute10 = okl_api.g_miss_char) THEN
1118: l_ethv_rec.attribute10 := NULL;
1119: END IF;
1120:
1121: IF (l_ethv_rec.attribute11 = okl_api.g_miss_char) THEN

Line 1121: IF (l_ethv_rec.attribute11 = okl_api.g_miss_char) THEN

1117: IF (l_ethv_rec.attribute10 = okl_api.g_miss_char) THEN
1118: l_ethv_rec.attribute10 := NULL;
1119: END IF;
1120:
1121: IF (l_ethv_rec.attribute11 = okl_api.g_miss_char) THEN
1122: l_ethv_rec.attribute11 := NULL;
1123: END IF;
1124:
1125: IF (l_ethv_rec.attribute12 = okl_api.g_miss_char) THEN

Line 1125: IF (l_ethv_rec.attribute12 = okl_api.g_miss_char) THEN

1121: IF (l_ethv_rec.attribute11 = okl_api.g_miss_char) THEN
1122: l_ethv_rec.attribute11 := NULL;
1123: END IF;
1124:
1125: IF (l_ethv_rec.attribute12 = okl_api.g_miss_char) THEN
1126: l_ethv_rec.attribute12 := NULL;
1127: END IF;
1128:
1129: IF (l_ethv_rec.attribute13 = okl_api.g_miss_char) THEN

Line 1129: IF (l_ethv_rec.attribute13 = okl_api.g_miss_char) THEN

1125: IF (l_ethv_rec.attribute12 = okl_api.g_miss_char) THEN
1126: l_ethv_rec.attribute12 := NULL;
1127: END IF;
1128:
1129: IF (l_ethv_rec.attribute13 = okl_api.g_miss_char) THEN
1130: l_ethv_rec.attribute13 := NULL;
1131: END IF;
1132:
1133: IF (l_ethv_rec.attribute14 = okl_api.g_miss_char) THEN

Line 1133: IF (l_ethv_rec.attribute14 = okl_api.g_miss_char) THEN

1129: IF (l_ethv_rec.attribute13 = okl_api.g_miss_char) THEN
1130: l_ethv_rec.attribute13 := NULL;
1131: END IF;
1132:
1133: IF (l_ethv_rec.attribute14 = okl_api.g_miss_char) THEN
1134: l_ethv_rec.attribute14 := NULL;
1135: END IF;
1136:
1137: IF (l_ethv_rec.attribute15 = okl_api.g_miss_char) THEN

Line 1137: IF (l_ethv_rec.attribute15 = okl_api.g_miss_char) THEN

1133: IF (l_ethv_rec.attribute14 = okl_api.g_miss_char) THEN
1134: l_ethv_rec.attribute14 := NULL;
1135: END IF;
1136:
1137: IF (l_ethv_rec.attribute15 = okl_api.g_miss_char) THEN
1138: l_ethv_rec.attribute15 := NULL;
1139: END IF;
1140:
1141: IF (l_ethv_rec.created_by = okl_api.g_miss_num) THEN

Line 1141: IF (l_ethv_rec.created_by = okl_api.g_miss_num) THEN

1137: IF (l_ethv_rec.attribute15 = okl_api.g_miss_char) THEN
1138: l_ethv_rec.attribute15 := NULL;
1139: END IF;
1140:
1141: IF (l_ethv_rec.created_by = okl_api.g_miss_num) THEN
1142: l_ethv_rec.created_by := NULL;
1143: END IF;
1144:
1145: IF (l_ethv_rec.creation_date = okl_api.g_miss_date) THEN

Line 1145: IF (l_ethv_rec.creation_date = okl_api.g_miss_date) THEN

1141: IF (l_ethv_rec.created_by = okl_api.g_miss_num) THEN
1142: l_ethv_rec.created_by := NULL;
1143: END IF;
1144:
1145: IF (l_ethv_rec.creation_date = okl_api.g_miss_date) THEN
1146: l_ethv_rec.creation_date := NULL;
1147: END IF;
1148:
1149: IF (l_ethv_rec.last_updated_by = okl_api.g_miss_num) THEN

Line 1149: IF (l_ethv_rec.last_updated_by = okl_api.g_miss_num) THEN

1145: IF (l_ethv_rec.creation_date = okl_api.g_miss_date) THEN
1146: l_ethv_rec.creation_date := NULL;
1147: END IF;
1148:
1149: IF (l_ethv_rec.last_updated_by = okl_api.g_miss_num) THEN
1150: l_ethv_rec.last_updated_by := NULL;
1151: END IF;
1152:
1153: IF (l_ethv_rec.last_update_date = okl_api.g_miss_date) THEN

Line 1153: IF (l_ethv_rec.last_update_date = okl_api.g_miss_date) THEN

1149: IF (l_ethv_rec.last_updated_by = okl_api.g_miss_num) THEN
1150: l_ethv_rec.last_updated_by := NULL;
1151: END IF;
1152:
1153: IF (l_ethv_rec.last_update_date = okl_api.g_miss_date) THEN
1154: l_ethv_rec.last_update_date := NULL;
1155: END IF;
1156:
1157: IF (l_ethv_rec.last_update_login = okl_api.g_miss_num) THEN

Line 1157: IF (l_ethv_rec.last_update_login = okl_api.g_miss_num) THEN

1153: IF (l_ethv_rec.last_update_date = okl_api.g_miss_date) THEN
1154: l_ethv_rec.last_update_date := NULL;
1155: END IF;
1156:
1157: IF (l_ethv_rec.last_update_login = okl_api.g_miss_num) THEN
1158: l_ethv_rec.last_update_login := NULL;
1159: END IF;
1160: RETURN(l_ethv_rec);
1161: END null_out_defaults;

Line 1171: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

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:
1175: -- validate the id

Line 1282: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

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
1286: IF (p_ethv_rec.effective_from_date > p_ethv_rec.effective_to_date) THEN

Line 1287: okl_api.set_message(p_app_name => g_app_name

1283:
1284: BEGIN
1285: IF (p_ethv_rec.effective_to_date IS NOT NULL) THEN
1286: IF (p_ethv_rec.effective_from_date > p_ethv_rec.effective_to_date) THEN
1287: okl_api.set_message(p_app_name => g_app_name
1288: ,p_msg_name => 'OKL_INVALID_EFFECTIVE_TO');
1289: x_return_status := okl_api.g_ret_sts_error;
1290: END IF;
1291: END IF;

Line 1289: x_return_status := okl_api.g_ret_sts_error;

1285: IF (p_ethv_rec.effective_to_date IS NOT NULL) THEN
1286: IF (p_ethv_rec.effective_from_date > p_ethv_rec.effective_to_date) THEN
1287: okl_api.set_message(p_app_name => g_app_name
1288: ,p_msg_name => 'OKL_INVALID_EFFECTIVE_TO');
1289: x_return_status := okl_api.g_ret_sts_error;
1290: END IF;
1291: END IF;
1292: RETURN(x_return_status);
1293: END validate_record;

Line 1317: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1313: FROM okl_fe_eo_terms_all_b
1314: WHERE end_of_term_id = p_ethb_rec.end_of_term_id;
1315: l_api_version CONSTANT NUMBER := 1;
1316: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1317: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1318: l_object_version_number okl_fe_resi_cat_all_b.object_version_number%TYPE;
1319: lc_object_version_number okl_fe_resi_cat_all_b.object_version_number%TYPE;
1320: l_row_notfound BOOLEAN := false;
1321: lc_row_notfound BOOLEAN := false;

Line 1324: l_return_status := okl_api.start_activity(l_api_name

1320: l_row_notfound BOOLEAN := false;
1321: lc_row_notfound BOOLEAN := false;
1322:
1323: BEGIN
1324: l_return_status := okl_api.start_activity(l_api_name
1325: ,p_init_msg_list
1326: ,'_PVT'
1327: ,x_return_status);
1328:

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

1325: ,p_init_msg_list
1326: ,'_PVT'
1327: ,x_return_status);
1328:
1329: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1330: RAISE okl_api.g_exception_unexpected_error;
1331: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1332: RAISE okl_api.g_exception_error;
1333: END IF;

Line 1330: RAISE okl_api.g_exception_unexpected_error;

1326: ,'_PVT'
1327: ,x_return_status);
1328:
1329: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1330: RAISE okl_api.g_exception_unexpected_error;
1331: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1332: RAISE okl_api.g_exception_error;
1333: END IF;
1334:

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

1327: ,x_return_status);
1328:
1329: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1330: RAISE okl_api.g_exception_unexpected_error;
1331: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1332: RAISE okl_api.g_exception_error;
1333: END IF;
1334:
1335: BEGIN

Line 1332: RAISE okl_api.g_exception_error;

1328:
1329: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1330: RAISE okl_api.g_exception_unexpected_error;
1331: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1332: RAISE okl_api.g_exception_error;
1333: END IF;
1334:
1335: BEGIN
1336: OPEN lock_csr(p_ethb_rec);

Line 1346: okl_api.set_message(g_fnd_app

1342:
1343: IF (lock_csr%ISOPEN) THEN
1344: CLOSE lock_csr;
1345: END IF;
1346: okl_api.set_message(g_fnd_app
1347: ,g_form_unable_to_reserve_rec);
1348: RAISE app_exceptions.record_lock_exception;
1349: END;
1350:

Line 1359: okl_api.set_message(g_fnd_app

1355: CLOSE lchk_csr;
1356: END IF;
1357:
1358: IF (lc_row_notfound) THEN
1359: okl_api.set_message(g_fnd_app
1360: ,g_form_record_deleted);
1361: RAISE okl_api.g_exception_error;
1362: ELSIF lc_object_version_number > p_ethb_rec.object_version_number THEN
1363: okl_api.set_message(g_fnd_app

Line 1361: RAISE okl_api.g_exception_error;

1357:
1358: IF (lc_row_notfound) THEN
1359: okl_api.set_message(g_fnd_app
1360: ,g_form_record_deleted);
1361: RAISE okl_api.g_exception_error;
1362: ELSIF lc_object_version_number > p_ethb_rec.object_version_number THEN
1363: okl_api.set_message(g_fnd_app
1364: ,g_form_record_changed);
1365: RAISE okl_api.g_exception_error;

Line 1363: okl_api.set_message(g_fnd_app

1359: okl_api.set_message(g_fnd_app
1360: ,g_form_record_deleted);
1361: RAISE okl_api.g_exception_error;
1362: ELSIF lc_object_version_number > p_ethb_rec.object_version_number THEN
1363: okl_api.set_message(g_fnd_app
1364: ,g_form_record_changed);
1365: RAISE okl_api.g_exception_error;
1366: ELSIF lc_object_version_number <> p_ethb_rec.object_version_number THEN
1367: okl_api.set_message(g_fnd_app

Line 1365: RAISE okl_api.g_exception_error;

1361: RAISE okl_api.g_exception_error;
1362: ELSIF lc_object_version_number > p_ethb_rec.object_version_number THEN
1363: okl_api.set_message(g_fnd_app
1364: ,g_form_record_changed);
1365: RAISE okl_api.g_exception_error;
1366: ELSIF lc_object_version_number <> p_ethb_rec.object_version_number THEN
1367: okl_api.set_message(g_fnd_app
1368: ,g_form_record_changed);
1369: RAISE okl_api.g_exception_error;

Line 1367: okl_api.set_message(g_fnd_app

1363: okl_api.set_message(g_fnd_app
1364: ,g_form_record_changed);
1365: RAISE okl_api.g_exception_error;
1366: ELSIF lc_object_version_number <> p_ethb_rec.object_version_number THEN
1367: okl_api.set_message(g_fnd_app
1368: ,g_form_record_changed);
1369: RAISE okl_api.g_exception_error;
1370: ELSIF lc_object_version_number = - 1 THEN
1371: okl_api.set_message(g_app_name

Line 1369: RAISE okl_api.g_exception_error;

1365: RAISE okl_api.g_exception_error;
1366: ELSIF lc_object_version_number <> p_ethb_rec.object_version_number THEN
1367: okl_api.set_message(g_fnd_app
1368: ,g_form_record_changed);
1369: RAISE okl_api.g_exception_error;
1370: ELSIF lc_object_version_number = - 1 THEN
1371: okl_api.set_message(g_app_name
1372: ,g_record_logically_deleted);
1373: RAISE okl_api.g_exception_error;

Line 1371: okl_api.set_message(g_app_name

1367: okl_api.set_message(g_fnd_app
1368: ,g_form_record_changed);
1369: RAISE okl_api.g_exception_error;
1370: ELSIF lc_object_version_number = - 1 THEN
1371: okl_api.set_message(g_app_name
1372: ,g_record_logically_deleted);
1373: RAISE okl_api.g_exception_error;
1374: END IF;
1375: okl_api.end_activity(x_msg_count

Line 1373: RAISE okl_api.g_exception_error;

1369: RAISE okl_api.g_exception_error;
1370: ELSIF lc_object_version_number = - 1 THEN
1371: okl_api.set_message(g_app_name
1372: ,g_record_logically_deleted);
1373: RAISE okl_api.g_exception_error;
1374: END IF;
1375: okl_api.end_activity(x_msg_count
1376: ,x_msg_data);
1377: EXCEPTION

Line 1375: okl_api.end_activity(x_msg_count

1371: okl_api.set_message(g_app_name
1372: ,g_record_logically_deleted);
1373: RAISE okl_api.g_exception_error;
1374: END IF;
1375: okl_api.end_activity(x_msg_count
1376: ,x_msg_data);
1377: EXCEPTION
1378: WHEN g_exception_halt_validation THEN
1379: x_return_status := okl_api.handle_exceptions(l_api_name

Line 1379: x_return_status := okl_api.handle_exceptions(l_api_name

1375: okl_api.end_activity(x_msg_count
1376: ,x_msg_data);
1377: EXCEPTION
1378: WHEN g_exception_halt_validation THEN
1379: x_return_status := okl_api.handle_exceptions(l_api_name
1380: ,g_pkg_name
1381: ,'OKL_API.G_RET_STS_ERROR'
1382: ,x_msg_count
1383: ,x_msg_data

Line 1381: ,'OKL_API.G_RET_STS_ERROR'

1377: EXCEPTION
1378: WHEN g_exception_halt_validation THEN
1379: x_return_status := okl_api.handle_exceptions(l_api_name
1380: ,g_pkg_name
1381: ,'OKL_API.G_RET_STS_ERROR'
1382: ,x_msg_count
1383: ,x_msg_data
1384: ,'_PVT');
1385: WHEN okl_api.g_exception_error THEN

Line 1385: WHEN okl_api.g_exception_error THEN

1381: ,'OKL_API.G_RET_STS_ERROR'
1382: ,x_msg_count
1383: ,x_msg_data
1384: ,'_PVT');
1385: WHEN okl_api.g_exception_error THEN
1386: x_return_status := okl_api.handle_exceptions(l_api_name
1387: ,g_pkg_name
1388: ,'OKL_API.G_RET_STS_ERROR'
1389: ,x_msg_count

Line 1386: x_return_status := okl_api.handle_exceptions(l_api_name

1382: ,x_msg_count
1383: ,x_msg_data
1384: ,'_PVT');
1385: WHEN okl_api.g_exception_error THEN
1386: x_return_status := okl_api.handle_exceptions(l_api_name
1387: ,g_pkg_name
1388: ,'OKL_API.G_RET_STS_ERROR'
1389: ,x_msg_count
1390: ,x_msg_data

Line 1388: ,'OKL_API.G_RET_STS_ERROR'

1384: ,'_PVT');
1385: WHEN okl_api.g_exception_error THEN
1386: x_return_status := okl_api.handle_exceptions(l_api_name
1387: ,g_pkg_name
1388: ,'OKL_API.G_RET_STS_ERROR'
1389: ,x_msg_count
1390: ,x_msg_data
1391: ,'_PVT');
1392: WHEN okl_api.g_exception_unexpected_error THEN

Line 1392: WHEN okl_api.g_exception_unexpected_error THEN

1388: ,'OKL_API.G_RET_STS_ERROR'
1389: ,x_msg_count
1390: ,x_msg_data
1391: ,'_PVT');
1392: WHEN okl_api.g_exception_unexpected_error THEN
1393: x_return_status := okl_api.handle_exceptions(l_api_name
1394: ,g_pkg_name
1395: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1396: ,x_msg_count

Line 1393: x_return_status := okl_api.handle_exceptions(l_api_name

1389: ,x_msg_count
1390: ,x_msg_data
1391: ,'_PVT');
1392: WHEN okl_api.g_exception_unexpected_error THEN
1393: x_return_status := okl_api.handle_exceptions(l_api_name
1394: ,g_pkg_name
1395: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1396: ,x_msg_count
1397: ,x_msg_data

Line 1395: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1391: ,'_PVT');
1392: WHEN okl_api.g_exception_unexpected_error THEN
1393: x_return_status := okl_api.handle_exceptions(l_api_name
1394: ,g_pkg_name
1395: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1396: ,x_msg_count
1397: ,x_msg_data
1398: ,'_PVT');
1399: WHEN OTHERS THEN

Line 1400: x_return_status := okl_api.handle_exceptions(l_api_name

1396: ,x_msg_count
1397: ,x_msg_data
1398: ,'_PVT');
1399: WHEN OTHERS THEN
1400: x_return_status := okl_api.handle_exceptions(l_api_name
1401: ,g_pkg_name
1402: ,'OTHERS'
1403: ,x_msg_count
1404: ,x_msg_data

Line 1428: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1424: WHERE end_of_term_id = p_ethtl_rec.end_of_term_id
1425: FOR UPDATE NOWAIT;
1426: l_api_version CONSTANT NUMBER := 1;
1427: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';
1428: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1429: l_lock_var lock_csr%ROWTYPE;
1430: l_row_notfound BOOLEAN := false;
1431: lc_row_notfound BOOLEAN := false;
1432:

Line 1434: l_return_status := okl_api.start_activity(l_api_name

1430: l_row_notfound BOOLEAN := false;
1431: lc_row_notfound BOOLEAN := false;
1432:
1433: BEGIN
1434: l_return_status := okl_api.start_activity(l_api_name
1435: ,p_init_msg_list
1436: ,'_PVT'
1437: ,x_return_status);
1438:

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

1435: ,p_init_msg_list
1436: ,'_PVT'
1437: ,x_return_status);
1438:
1439: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1440: RAISE okl_api.g_exception_unexpected_error;
1441: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1442: RAISE okl_api.g_exception_error;
1443: END IF;

Line 1440: RAISE okl_api.g_exception_unexpected_error;

1436: ,'_PVT'
1437: ,x_return_status);
1438:
1439: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1440: RAISE okl_api.g_exception_unexpected_error;
1441: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1442: RAISE okl_api.g_exception_error;
1443: END IF;
1444:

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

1437: ,x_return_status);
1438:
1439: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1440: RAISE okl_api.g_exception_unexpected_error;
1441: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1442: RAISE okl_api.g_exception_error;
1443: END IF;
1444:
1445: BEGIN

Line 1442: RAISE okl_api.g_exception_error;

1438:
1439: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1440: RAISE okl_api.g_exception_unexpected_error;
1441: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1442: RAISE okl_api.g_exception_error;
1443: END IF;
1444:
1445: BEGIN
1446: OPEN lock_csr(p_ethtl_rec);

Line 1456: okl_api.set_message(g_fnd_app

1452:
1453: IF (lock_csr%ISOPEN) THEN
1454: CLOSE lock_csr;
1455: END IF;
1456: okl_api.set_message(g_fnd_app
1457: ,g_form_unable_to_reserve_rec);
1458: RAISE app_exceptions.record_lock_exception;
1459: END;
1460:

Line 1462: okl_api.set_message(g_fnd_app

1458: RAISE app_exceptions.record_lock_exception;
1459: END;
1460:
1461: IF (l_row_notfound) THEN
1462: okl_api.set_message(g_fnd_app
1463: ,g_form_record_deleted);
1464: RAISE okl_api.g_exception_error;
1465: END IF;
1466: okl_api.end_activity(x_msg_count

Line 1464: RAISE okl_api.g_exception_error;

1460:
1461: IF (l_row_notfound) THEN
1462: okl_api.set_message(g_fnd_app
1463: ,g_form_record_deleted);
1464: RAISE okl_api.g_exception_error;
1465: END IF;
1466: okl_api.end_activity(x_msg_count
1467: ,x_msg_data);
1468: EXCEPTION

Line 1466: okl_api.end_activity(x_msg_count

1462: okl_api.set_message(g_fnd_app
1463: ,g_form_record_deleted);
1464: RAISE okl_api.g_exception_error;
1465: END IF;
1466: okl_api.end_activity(x_msg_count
1467: ,x_msg_data);
1468: EXCEPTION
1469: WHEN g_exception_halt_validation THEN
1470: x_return_status := okl_api.handle_exceptions(l_api_name

Line 1470: x_return_status := okl_api.handle_exceptions(l_api_name

1466: okl_api.end_activity(x_msg_count
1467: ,x_msg_data);
1468: EXCEPTION
1469: WHEN g_exception_halt_validation THEN
1470: x_return_status := okl_api.handle_exceptions(l_api_name
1471: ,g_pkg_name
1472: ,'OKL_API.G_RET_STS_ERROR'
1473: ,x_msg_count
1474: ,x_msg_data

Line 1472: ,'OKL_API.G_RET_STS_ERROR'

1468: EXCEPTION
1469: WHEN g_exception_halt_validation THEN
1470: x_return_status := okl_api.handle_exceptions(l_api_name
1471: ,g_pkg_name
1472: ,'OKL_API.G_RET_STS_ERROR'
1473: ,x_msg_count
1474: ,x_msg_data
1475: ,'_PVT');
1476: WHEN okl_api.g_exception_error THEN

Line 1476: WHEN okl_api.g_exception_error THEN

1472: ,'OKL_API.G_RET_STS_ERROR'
1473: ,x_msg_count
1474: ,x_msg_data
1475: ,'_PVT');
1476: WHEN okl_api.g_exception_error THEN
1477: x_return_status := okl_api.handle_exceptions(l_api_name
1478: ,g_pkg_name
1479: ,'OKL_API.G_RET_STS_ERROR'
1480: ,x_msg_count

Line 1477: x_return_status := okl_api.handle_exceptions(l_api_name

1473: ,x_msg_count
1474: ,x_msg_data
1475: ,'_PVT');
1476: WHEN okl_api.g_exception_error THEN
1477: x_return_status := okl_api.handle_exceptions(l_api_name
1478: ,g_pkg_name
1479: ,'OKL_API.G_RET_STS_ERROR'
1480: ,x_msg_count
1481: ,x_msg_data

Line 1479: ,'OKL_API.G_RET_STS_ERROR'

1475: ,'_PVT');
1476: WHEN okl_api.g_exception_error THEN
1477: x_return_status := okl_api.handle_exceptions(l_api_name
1478: ,g_pkg_name
1479: ,'OKL_API.G_RET_STS_ERROR'
1480: ,x_msg_count
1481: ,x_msg_data
1482: ,'_PVT');
1483: WHEN okl_api.g_exception_unexpected_error THEN

Line 1483: WHEN okl_api.g_exception_unexpected_error THEN

1479: ,'OKL_API.G_RET_STS_ERROR'
1480: ,x_msg_count
1481: ,x_msg_data
1482: ,'_PVT');
1483: WHEN okl_api.g_exception_unexpected_error THEN
1484: x_return_status := okl_api.handle_exceptions(l_api_name
1485: ,g_pkg_name
1486: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1487: ,x_msg_count

Line 1484: x_return_status := okl_api.handle_exceptions(l_api_name

1480: ,x_msg_count
1481: ,x_msg_data
1482: ,'_PVT');
1483: WHEN okl_api.g_exception_unexpected_error THEN
1484: x_return_status := okl_api.handle_exceptions(l_api_name
1485: ,g_pkg_name
1486: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1487: ,x_msg_count
1488: ,x_msg_data

Line 1486: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1482: ,'_PVT');
1483: WHEN okl_api.g_exception_unexpected_error THEN
1484: x_return_status := okl_api.handle_exceptions(l_api_name
1485: ,g_pkg_name
1486: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1487: ,x_msg_count
1488: ,x_msg_data
1489: ,'_PVT');
1490: WHEN OTHERS THEN

Line 1491: x_return_status := okl_api.handle_exceptions(l_api_name

1487: ,x_msg_count
1488: ,x_msg_data
1489: ,'_PVT');
1490: WHEN OTHERS THEN
1491: x_return_status := okl_api.handle_exceptions(l_api_name
1492: ,g_pkg_name
1493: ,'OTHERS'
1494: ,x_msg_count
1495: ,x_msg_data

Line 1511: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1507: ,x_msg_data OUT NOCOPY VARCHAR2
1508: ,p_ethv_rec IN okl_ethv_rec) IS
1509: l_api_version CONSTANT NUMBER := 1;
1510: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1511: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1512: l_ethb_rec okl_ethb_rec;
1513: l_ethtl_rec okl_ethtl_rec;
1514:
1515: BEGIN

Line 1516: l_return_status := okl_api.start_activity(l_api_name

1512: l_ethb_rec okl_ethb_rec;
1513: l_ethtl_rec okl_ethtl_rec;
1514:
1515: BEGIN
1516: l_return_status := okl_api.start_activity(l_api_name
1517: ,g_pkg_name
1518: ,p_init_msg_list
1519: ,l_api_version
1520: ,p_api_version

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

1520: ,p_api_version
1521: ,'_PVT'
1522: ,x_return_status);
1523:
1524: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1525: RAISE okl_api.g_exception_unexpected_error;
1526: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1527: RAISE okl_api.g_exception_error;
1528: END IF;

Line 1525: RAISE okl_api.g_exception_unexpected_error;

1521: ,'_PVT'
1522: ,x_return_status);
1523:
1524: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1525: RAISE okl_api.g_exception_unexpected_error;
1526: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1527: RAISE okl_api.g_exception_error;
1528: END IF;
1529:

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

1522: ,x_return_status);
1523:
1524: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1525: RAISE okl_api.g_exception_unexpected_error;
1526: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1527: RAISE okl_api.g_exception_error;
1528: END IF;
1529:
1530: --------------------------------------

Line 1527: RAISE okl_api.g_exception_error;

1523:
1524: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1525: RAISE okl_api.g_exception_unexpected_error;
1526: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1527: RAISE okl_api.g_exception_error;
1528: END IF;
1529:
1530: --------------------------------------
1531: -- Move VIEW record to "Child" records

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

1545: ,x_msg_count
1546: ,x_msg_data
1547: ,l_ethb_rec);
1548:
1549: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1550: RAISE okl_api.g_exception_unexpected_error;
1551: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1552: RAISE okl_api.g_exception_error;
1553: END IF;

Line 1550: RAISE okl_api.g_exception_unexpected_error;

1546: ,x_msg_data
1547: ,l_ethb_rec);
1548:
1549: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1550: RAISE okl_api.g_exception_unexpected_error;
1551: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1552: RAISE okl_api.g_exception_error;
1553: END IF;
1554: lock_row(p_init_msg_list

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

1547: ,l_ethb_rec);
1548:
1549: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1550: RAISE okl_api.g_exception_unexpected_error;
1551: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1552: RAISE okl_api.g_exception_error;
1553: END IF;
1554: lock_row(p_init_msg_list
1555: ,x_return_status

Line 1552: RAISE okl_api.g_exception_error;

1548:
1549: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1550: RAISE okl_api.g_exception_unexpected_error;
1551: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1552: RAISE okl_api.g_exception_error;
1553: END IF;
1554: lock_row(p_init_msg_list
1555: ,x_return_status
1556: ,x_msg_count

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

1556: ,x_msg_count
1557: ,x_msg_data
1558: ,l_ethtl_rec);
1559:
1560: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1561: RAISE okl_api.g_exception_unexpected_error;
1562: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1563: RAISE okl_api.g_exception_error;
1564: END IF;

Line 1561: RAISE okl_api.g_exception_unexpected_error;

1557: ,x_msg_data
1558: ,l_ethtl_rec);
1559:
1560: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1561: RAISE okl_api.g_exception_unexpected_error;
1562: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1563: RAISE okl_api.g_exception_error;
1564: END IF;
1565: okl_api.end_activity(x_msg_count

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

1558: ,l_ethtl_rec);
1559:
1560: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1561: RAISE okl_api.g_exception_unexpected_error;
1562: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1563: RAISE okl_api.g_exception_error;
1564: END IF;
1565: okl_api.end_activity(x_msg_count
1566: ,x_msg_data);

Line 1563: RAISE okl_api.g_exception_error;

1559:
1560: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1561: RAISE okl_api.g_exception_unexpected_error;
1562: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1563: RAISE okl_api.g_exception_error;
1564: END IF;
1565: okl_api.end_activity(x_msg_count
1566: ,x_msg_data);
1567: EXCEPTION

Line 1565: okl_api.end_activity(x_msg_count

1561: RAISE okl_api.g_exception_unexpected_error;
1562: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1563: RAISE okl_api.g_exception_error;
1564: END IF;
1565: okl_api.end_activity(x_msg_count
1566: ,x_msg_data);
1567: EXCEPTION
1568: WHEN g_exception_halt_validation THEN
1569: x_return_status := okl_api.handle_exceptions(l_api_name

Line 1569: x_return_status := okl_api.handle_exceptions(l_api_name

1565: okl_api.end_activity(x_msg_count
1566: ,x_msg_data);
1567: EXCEPTION
1568: WHEN g_exception_halt_validation THEN
1569: x_return_status := okl_api.handle_exceptions(l_api_name
1570: ,g_pkg_name
1571: ,'OKL_API.G_RET_STS_ERROR'
1572: ,x_msg_count
1573: ,x_msg_data

Line 1571: ,'OKL_API.G_RET_STS_ERROR'

1567: EXCEPTION
1568: WHEN g_exception_halt_validation THEN
1569: x_return_status := okl_api.handle_exceptions(l_api_name
1570: ,g_pkg_name
1571: ,'OKL_API.G_RET_STS_ERROR'
1572: ,x_msg_count
1573: ,x_msg_data
1574: ,'_PVT');
1575: WHEN okl_api.g_exception_error THEN

Line 1575: WHEN okl_api.g_exception_error THEN

1571: ,'OKL_API.G_RET_STS_ERROR'
1572: ,x_msg_count
1573: ,x_msg_data
1574: ,'_PVT');
1575: WHEN okl_api.g_exception_error THEN
1576: x_return_status := okl_api.handle_exceptions(l_api_name
1577: ,g_pkg_name
1578: ,'OKL_API.G_RET_STS_ERROR'
1579: ,x_msg_count

Line 1576: x_return_status := okl_api.handle_exceptions(l_api_name

1572: ,x_msg_count
1573: ,x_msg_data
1574: ,'_PVT');
1575: WHEN okl_api.g_exception_error THEN
1576: x_return_status := okl_api.handle_exceptions(l_api_name
1577: ,g_pkg_name
1578: ,'OKL_API.G_RET_STS_ERROR'
1579: ,x_msg_count
1580: ,x_msg_data

Line 1578: ,'OKL_API.G_RET_STS_ERROR'

1574: ,'_PVT');
1575: WHEN okl_api.g_exception_error THEN
1576: x_return_status := okl_api.handle_exceptions(l_api_name
1577: ,g_pkg_name
1578: ,'OKL_API.G_RET_STS_ERROR'
1579: ,x_msg_count
1580: ,x_msg_data
1581: ,'_PVT');
1582: WHEN okl_api.g_exception_unexpected_error THEN

Line 1582: WHEN okl_api.g_exception_unexpected_error THEN

1578: ,'OKL_API.G_RET_STS_ERROR'
1579: ,x_msg_count
1580: ,x_msg_data
1581: ,'_PVT');
1582: WHEN okl_api.g_exception_unexpected_error THEN
1583: x_return_status := okl_api.handle_exceptions(l_api_name
1584: ,g_pkg_name
1585: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1586: ,x_msg_count

Line 1583: x_return_status := okl_api.handle_exceptions(l_api_name

1579: ,x_msg_count
1580: ,x_msg_data
1581: ,'_PVT');
1582: WHEN okl_api.g_exception_unexpected_error THEN
1583: x_return_status := okl_api.handle_exceptions(l_api_name
1584: ,g_pkg_name
1585: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1586: ,x_msg_count
1587: ,x_msg_data

Line 1585: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1581: ,'_PVT');
1582: WHEN okl_api.g_exception_unexpected_error THEN
1583: x_return_status := okl_api.handle_exceptions(l_api_name
1584: ,g_pkg_name
1585: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1586: ,x_msg_count
1587: ,x_msg_data
1588: ,'_PVT');
1589: WHEN OTHERS THEN

Line 1590: x_return_status := okl_api.handle_exceptions(l_api_name

1586: ,x_msg_count
1587: ,x_msg_data
1588: ,'_PVT');
1589: WHEN OTHERS THEN
1590: x_return_status := okl_api.handle_exceptions(l_api_name
1591: ,g_pkg_name
1592: ,'OTHERS'
1593: ,x_msg_count
1594: ,x_msg_data

Line 1610: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1606: ,x_msg_data OUT NOCOPY VARCHAR2
1607: ,p_ethv_tbl IN okl_ethv_tbl) IS
1608: l_api_version CONSTANT NUMBER := 1;
1609: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1610: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1611:
1612: -- Begin Post-Generation Change
1613: -- overall error status
1614:

Line 1615: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1611:
1612: -- Begin Post-Generation Change
1613: -- overall error status
1614:
1615: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1616:
1617: -- End Post-Generation Change
1618:
1619: i NUMBER := 0;

Line 1622: okl_api.init_msg_list(p_init_msg_list);

1618:
1619: i NUMBER := 0;
1620:
1621: BEGIN
1622: okl_api.init_msg_list(p_init_msg_list);
1623:
1624: -- Make sure PL/SQL table has records in it before passing
1625:
1626: IF (p_ethv_tbl.COUNT > 0) THEN

Line 1631: ,p_init_msg_list => okl_api.g_false

1627: i := p_ethv_tbl.FIRST;
1628:
1629: LOOP
1630: lock_row(p_api_version => p_api_version
1631: ,p_init_msg_list => okl_api.g_false
1632: ,x_return_status => x_return_status
1633: ,x_msg_count => x_msg_count
1634: ,x_msg_data => x_msg_data
1635: ,p_ethv_rec => p_ethv_tbl(i));

Line 1640: IF x_return_status <> okl_api.g_ret_sts_success THEN

1636:
1637: -- Begin Post-Generation Change
1638: -- store the highest degree of error
1639:
1640: IF x_return_status <> okl_api.g_ret_sts_success THEN
1641: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
1642: l_overall_status := x_return_status;
1643: END IF;
1644: END IF;

Line 1641: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN

1637: -- Begin Post-Generation Change
1638: -- store the highest degree of error
1639:
1640: IF x_return_status <> okl_api.g_ret_sts_success THEN
1641: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
1642: l_overall_status := x_return_status;
1643: END IF;
1644: END IF;
1645:

Line 1663: x_return_status := okl_api.handle_exceptions(l_api_name

1659: END IF;
1660:
1661: EXCEPTION
1662: WHEN g_exception_halt_validation THEN
1663: x_return_status := okl_api.handle_exceptions(l_api_name
1664: ,g_pkg_name
1665: ,'OKL_API.G_RET_STS_ERROR'
1666: ,x_msg_count
1667: ,x_msg_data

Line 1665: ,'OKL_API.G_RET_STS_ERROR'

1661: EXCEPTION
1662: WHEN g_exception_halt_validation THEN
1663: x_return_status := okl_api.handle_exceptions(l_api_name
1664: ,g_pkg_name
1665: ,'OKL_API.G_RET_STS_ERROR'
1666: ,x_msg_count
1667: ,x_msg_data
1668: ,'_PVT');
1669: WHEN okl_api.g_exception_error THEN

Line 1669: WHEN okl_api.g_exception_error THEN

1665: ,'OKL_API.G_RET_STS_ERROR'
1666: ,x_msg_count
1667: ,x_msg_data
1668: ,'_PVT');
1669: WHEN okl_api.g_exception_error THEN
1670: x_return_status := okl_api.handle_exceptions(l_api_name
1671: ,g_pkg_name
1672: ,'OKL_API.G_RET_STS_ERROR'
1673: ,x_msg_count

Line 1670: x_return_status := okl_api.handle_exceptions(l_api_name

1666: ,x_msg_count
1667: ,x_msg_data
1668: ,'_PVT');
1669: WHEN okl_api.g_exception_error THEN
1670: x_return_status := okl_api.handle_exceptions(l_api_name
1671: ,g_pkg_name
1672: ,'OKL_API.G_RET_STS_ERROR'
1673: ,x_msg_count
1674: ,x_msg_data

Line 1672: ,'OKL_API.G_RET_STS_ERROR'

1668: ,'_PVT');
1669: WHEN okl_api.g_exception_error THEN
1670: x_return_status := okl_api.handle_exceptions(l_api_name
1671: ,g_pkg_name
1672: ,'OKL_API.G_RET_STS_ERROR'
1673: ,x_msg_count
1674: ,x_msg_data
1675: ,'_PVT');
1676: WHEN okl_api.g_exception_unexpected_error THEN

Line 1676: WHEN okl_api.g_exception_unexpected_error THEN

1672: ,'OKL_API.G_RET_STS_ERROR'
1673: ,x_msg_count
1674: ,x_msg_data
1675: ,'_PVT');
1676: WHEN okl_api.g_exception_unexpected_error THEN
1677: x_return_status := okl_api.handle_exceptions(l_api_name
1678: ,g_pkg_name
1679: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1680: ,x_msg_count

Line 1677: x_return_status := okl_api.handle_exceptions(l_api_name

1673: ,x_msg_count
1674: ,x_msg_data
1675: ,'_PVT');
1676: WHEN okl_api.g_exception_unexpected_error THEN
1677: x_return_status := okl_api.handle_exceptions(l_api_name
1678: ,g_pkg_name
1679: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1680: ,x_msg_count
1681: ,x_msg_data

Line 1679: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1675: ,'_PVT');
1676: WHEN okl_api.g_exception_unexpected_error THEN
1677: x_return_status := okl_api.handle_exceptions(l_api_name
1678: ,g_pkg_name
1679: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1680: ,x_msg_count
1681: ,x_msg_data
1682: ,'_PVT');
1683: WHEN OTHERS THEN

Line 1684: x_return_status := okl_api.handle_exceptions(l_api_name

1680: ,x_msg_count
1681: ,x_msg_data
1682: ,'_PVT');
1683: WHEN OTHERS THEN
1684: x_return_status := okl_api.handle_exceptions(l_api_name
1685: ,g_pkg_name
1686: ,'OTHERS'
1687: ,x_msg_count
1688: ,x_msg_data

Line 1705: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1701: ,p_ethb_rec IN okl_ethb_rec
1702: ,x_ethb_rec OUT NOCOPY okl_ethb_rec) IS
1703: l_api_version CONSTANT NUMBER := 1;
1704: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1705: l_return_status VARCHAR2(1) := okl_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

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

1722: ,p_api_version
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;

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

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:
1732: --Setting Item Attributes

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

1733:
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;

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

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:
1743: INSERT INTO okl_fe_eo_terms_all_b

Line 1823: x_return_status := okl_api.handle_exceptions(l_api_name

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
1827: ,x_msg_data

Line 1825: ,'OKL_API.G_RET_STS_ERROR'

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
1827: ,x_msg_data
1828: ,'_PVT');
1829: WHEN okc_api.g_exception_unexpected_error THEN

Line 1830: x_return_status := okl_api.handle_exceptions(l_api_name

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
1834: ,x_msg_data

Line 1832: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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
1834: ,x_msg_data
1835: ,'_PVT');
1836: WHEN OTHERS THEN

Line 1837: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 1858: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1854: ,p_ethtl_rec IN okl_ethtl_rec
1855: ,x_ethtl_rec OUT NOCOPY okl_ethtl_rec) IS
1856: l_api_version CONSTANT NUMBER := 1;
1857: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1858: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1859: l_ethtl_rec okl_ethtl_rec := p_ethtl_rec;
1860:
1861: CURSOR get_languages IS
1862: SELECT *

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

1883: ,p_api_version
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;

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

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:
1893: --Setting Item Attributes

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

1894:
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;

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

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:
1904: FOR l_lang_rec IN get_languages LOOP

Line 1943: x_return_status := okl_api.handle_exceptions(l_api_name

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
1947: ,x_msg_data

Line 1945: ,'OKL_API.G_RET_STS_ERROR'

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
1947: ,x_msg_data
1948: ,'_PVT');
1949: WHEN okc_api.g_exception_unexpected_error THEN

Line 1950: x_return_status := okl_api.handle_exceptions(l_api_name

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
1954: ,x_msg_data

Line 1952: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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
1954: ,x_msg_data
1955: ,'_PVT');
1956: WHEN OTHERS THEN

Line 1957: x_return_status := okl_api.handle_exceptions(l_api_name

1953: ,x_msg_count
1954: ,x_msg_data
1955: ,'_PVT');
1956: WHEN OTHERS THEN
1957: x_return_status := okl_api.handle_exceptions(l_api_name
1958: ,g_pkg_name
1959: ,'OTHERS'
1960: ,x_msg_count
1961: ,x_msg_data

Line 1978: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1974: ,p_ethv_rec IN okl_ethv_rec
1975: ,x_ethv_rec OUT NOCOPY okl_ethv_rec) IS
1976: l_api_version CONSTANT NUMBER := 1;
1977: l_api_name CONSTANT VARCHAR2(30) := 'v_insert_row';
1978: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1979: l_ethv_rec okl_ethv_rec;
1980: l_def_ethv_rec okl_ethv_rec;
1981: l_ethb_rec okl_ethb_rec;
1982: lx_ethb_rec okl_ethb_rec;

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

2014: ,p_api_version
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;

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

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);
2024:

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

2030:
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;

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

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);
2040: l_return_status := validate_attributes(l_def_ethv_rec);

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

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:
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;

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

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);
2048:

Line 2049: IF (l_return_status = okl_api.g_ret_sts_unexp_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
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;

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

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
2055: ,l_ethb_rec);

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

2062: ,x_msg_data
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;

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

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
2072: ,l_def_ethv_rec);

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

2077: ,x_msg_data
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;

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

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
2087: ,l_def_ethv_rec);

Line 2101: x_return_status := okl_api.handle_exceptions(l_api_name

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
2105: ,x_msg_data

Line 2103: ,'OKL_API.G_RET_STS_ERROR'

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
2105: ,x_msg_data
2106: ,'_PVT');
2107: WHEN okc_api.g_exception_unexpected_error THEN

Line 2108: x_return_status := okl_api.handle_exceptions(l_api_name

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
2112: ,x_msg_data

Line 2110: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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
2112: ,x_msg_data
2113: ,'_PVT');
2114: WHEN OTHERS THEN

Line 2115: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2136: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2132: ,p_ethv_tbl IN okl_ethv_tbl
2133: ,x_ethv_tbl OUT NOCOPY okl_ethv_tbl) IS
2134: l_api_version CONSTANT NUMBER := 1;
2135: l_api_name CONSTANT VARCHAR2(30) := 'v_insert_row';
2136: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2137: i NUMBER := 0;
2138: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2139:
2140: BEGIN

Line 2138: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2134: l_api_version CONSTANT NUMBER := 1;
2135: l_api_name CONSTANT VARCHAR2(30) := 'v_insert_row';
2136: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
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:

Line 2174: x_return_status := okl_api.handle_exceptions(l_api_name

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
2178: ,x_msg_data

Line 2176: ,'OKL_API.G_RET_STS_ERROR'

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
2178: ,x_msg_data
2179: ,'_PVT');
2180: WHEN okc_api.g_exception_unexpected_error THEN

Line 2181: x_return_status := okl_api.handle_exceptions(l_api_name

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
2185: ,x_msg_data

Line 2183: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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
2185: ,x_msg_data
2186: ,'_PVT');
2187: WHEN OTHERS THEN

Line 2188: x_return_status := okl_api.handle_exceptions(l_api_name

2184: ,x_msg_count
2185: ,x_msg_data
2186: ,'_PVT');
2187: WHEN OTHERS THEN
2188: x_return_status := okl_api.handle_exceptions(l_api_name
2189: ,g_pkg_name
2190: ,'OTHERS'
2191: ,x_msg_count
2192: ,x_msg_data

Line 2209: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2205: ,p_ethb_rec IN okl_ethb_rec
2206: ,x_ethb_rec OUT NOCOPY okl_ethb_rec) IS
2207: l_api_version CONSTANT NUMBER := 1;
2208: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2209: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2210: l_ethb_rec okl_ethb_rec := p_ethb_rec;
2211: l_def_ethb_rec okl_ethb_rec;
2212: l_row_notfound BOOLEAN := true;
2213:

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

2228: ,p_api_version
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;

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

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:
2238: --Setting Item Attributes

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

2239:
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;

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

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:
2249: UPDATE okl_fe_eo_terms_all_b

Line 2297: x_return_status := okl_api.handle_exceptions(l_api_name

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
2301: ,x_msg_data

Line 2299: ,'OKL_API.G_RET_STS_ERROR'

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
2301: ,x_msg_data
2302: ,'_PVT');
2303: WHEN okc_api.g_exception_unexpected_error THEN

Line 2304: x_return_status := okl_api.handle_exceptions(l_api_name

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
2308: ,x_msg_data

Line 2306: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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
2308: ,x_msg_data
2309: ,'_PVT');
2310: WHEN OTHERS THEN

Line 2311: x_return_status := okl_api.handle_exceptions(l_api_name

2307: ,x_msg_count
2308: ,x_msg_data
2309: ,'_PVT');
2310: WHEN OTHERS THEN
2311: x_return_status := okl_api.handle_exceptions(l_api_name
2312: ,g_pkg_name
2313: ,'OTHERS'
2314: ,x_msg_count
2315: ,x_msg_data

Line 2332: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2328: ,p_ethtl_rec IN okl_ethtl_rec
2329: ,x_ethtl_rec OUT NOCOPY okl_ethtl_rec) IS
2330: l_api_version CONSTANT NUMBER := 1;
2331: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2332: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2333: l_ethtl_rec okl_ethtl_rec := p_ethtl_rec;
2334: l_def_ethtl_rec okl_ethtl_rec;
2335: l_row_notfound BOOLEAN := true;
2336:

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

2353: ,p_api_version
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;

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

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:
2363: --Setting Item Attributes

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

2364:
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;

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

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:
2374: UPDATE okl_fe_eo_terms_all_tl

Line 2405: x_return_status := okl_api.handle_exceptions(l_api_name

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
2409: ,x_msg_data

Line 2407: ,'OKL_API.G_RET_STS_ERROR'

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
2409: ,x_msg_data
2410: ,'_PVT');
2411: WHEN okc_api.g_exception_unexpected_error THEN

Line 2412: x_return_status := okl_api.handle_exceptions(l_api_name

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
2416: ,x_msg_data

Line 2414: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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
2416: ,x_msg_data
2417: ,'_PVT');
2418: WHEN OTHERS THEN

Line 2419: x_return_status := okl_api.handle_exceptions(l_api_name

2415: ,x_msg_count
2416: ,x_msg_data
2417: ,'_PVT');
2418: WHEN OTHERS THEN
2419: x_return_status := okl_api.handle_exceptions(l_api_name
2420: ,g_pkg_name
2421: ,'OTHERS'
2422: ,x_msg_count
2423: ,x_msg_data

Line 2440: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2436: ,p_ethv_rec IN okl_ethv_rec
2437: ,x_ethv_rec OUT NOCOPY okl_ethv_rec) IS
2438: l_api_version CONSTANT NUMBER := 1;
2439: l_api_name CONSTANT VARCHAR2(30) := 'v_insert_row';
2440: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2441: l_ethv_rec okl_ethv_rec := p_ethv_rec;
2442: l_def_ethv_rec okl_ethv_rec;
2443: lx_ethv_rec okl_ethv_rec;
2444: l_ethb_rec okl_ethb_rec;

Line 2463: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2459: FUNCTION populate_new_record(p_ethv_rec IN okl_ethv_rec
2460: ,x_ethv_rec OUT NOCOPY okl_ethv_rec) RETURN VARCHAR2 IS
2461: l_ethv_rec okl_ethv_rec;
2462: l_row_notfound BOOLEAN := true;
2463: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2464:
2465: BEGIN
2466: x_ethv_rec := p_ethv_rec;
2467:

Line 2474: l_return_status := okl_api.g_ret_sts_unexp_error;

2470: l_ethv_rec := get_rec(p_ethv_rec
2471: ,l_row_notfound);
2472:
2473: IF (l_row_notfound) THEN
2474: l_return_status := okl_api.g_ret_sts_unexp_error;
2475: END IF;
2476:
2477: IF (x_ethv_rec.end_of_term_id IS NULL) THEN
2478: x_ethv_rec.end_of_term_id := l_ethv_rec.end_of_term_id;

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

2629: ,p_api_version
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;

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

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:
2639: --Setting Item Attributes

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

2640:
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;

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

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
2650: ,l_def_ethv_rec);

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

2648: END IF;
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;

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

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);
2658: l_def_ethv_rec := fill_who_columns(l_def_ethv_rec);

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

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);
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;

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

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);
2667:

Line 2668: IF (l_return_status = okl_api.g_ret_sts_unexp_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
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;

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

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:
2674: --lock the row

Line 2677: ,p_init_msg_list => okl_api.g_false

2673:
2674: --lock the row
2675:
2676: lock_row(p_api_version => l_api_version
2677: ,p_init_msg_list => okl_api.g_false
2678: ,x_return_status => l_return_status
2679: ,x_msg_count => x_msg_count
2680: ,x_msg_data => x_msg_data
2681: ,p_ethv_rec => l_def_ethv_rec);

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

2679: ,x_msg_count => x_msg_count
2680: ,x_msg_data => x_msg_data
2681: ,p_ethv_rec => l_def_ethv_rec);
2682:
2683: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2684: RAISE okl_api.g_exception_unexpected_error;
2685: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2686: RAISE okl_api.g_exception_error;
2687: END IF;

Line 2684: RAISE okl_api.g_exception_unexpected_error;

2680: ,x_msg_data => x_msg_data
2681: ,p_ethv_rec => l_def_ethv_rec);
2682:
2683: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2684: RAISE okl_api.g_exception_unexpected_error;
2685: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2686: RAISE okl_api.g_exception_error;
2687: END IF;
2688: migrate(l_def_ethv_rec

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

2681: ,p_ethv_rec => l_def_ethv_rec);
2682:
2683: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2684: RAISE okl_api.g_exception_unexpected_error;
2685: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2686: RAISE okl_api.g_exception_error;
2687: END IF;
2688: migrate(l_def_ethv_rec
2689: ,l_ethb_rec);

Line 2686: RAISE okl_api.g_exception_error;

2682:
2683: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2684: RAISE okl_api.g_exception_unexpected_error;
2685: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2686: RAISE okl_api.g_exception_error;
2687: END IF;
2688: migrate(l_def_ethv_rec
2689: ,l_ethb_rec);
2690: migrate(l_def_ethv_rec

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

2696: ,x_msg_data
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;

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

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
2706: ,l_def_ethv_rec);

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

2711: ,x_msg_data
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;

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

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
2721: ,l_def_ethv_rec);

Line 2735: x_return_status := okl_api.handle_exceptions(l_api_name

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
2739: ,x_msg_data

Line 2737: ,'OKL_API.G_RET_STS_ERROR'

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
2739: ,x_msg_data
2740: ,'_PVT');
2741: WHEN okc_api.g_exception_unexpected_error THEN

Line 2742: x_return_status := okl_api.handle_exceptions(l_api_name

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
2746: ,x_msg_data

Line 2744: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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
2746: ,x_msg_data
2747: ,'_PVT');
2748: WHEN OTHERS THEN

Line 2749: x_return_status := okl_api.handle_exceptions(l_api_name

2745: ,x_msg_count
2746: ,x_msg_data
2747: ,'_PVT');
2748: WHEN OTHERS THEN
2749: x_return_status := okl_api.handle_exceptions(l_api_name
2750: ,g_pkg_name
2751: ,'OTHERS'
2752: ,x_msg_count
2753: ,x_msg_data

Line 2770: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2766: ,p_ethv_tbl IN okl_ethv_tbl
2767: ,x_ethv_tbl OUT NOCOPY okl_ethv_tbl) IS
2768: l_api_version CONSTANT NUMBER := 1;
2769: l_api_name CONSTANT VARCHAR2(30) := 'v_update_row';
2770: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2771: i NUMBER := 0;
2772: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2773:
2774: BEGIN

Line 2772: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2768: l_api_version CONSTANT NUMBER := 1;
2769: l_api_name CONSTANT VARCHAR2(30) := 'v_update_row';
2770: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
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:

Line 2808: x_return_status := okl_api.handle_exceptions(l_api_name

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
2812: ,x_msg_data

Line 2810: ,'OKL_API.G_RET_STS_ERROR'

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
2812: ,x_msg_data
2813: ,'_PVT');
2814: WHEN okc_api.g_exception_unexpected_error THEN

Line 2815: x_return_status := okl_api.handle_exceptions(l_api_name

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
2819: ,x_msg_data

Line 2817: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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
2819: ,x_msg_data
2820: ,'_PVT');
2821: WHEN OTHERS THEN

Line 2822: x_return_status := okl_api.handle_exceptions(l_api_name

2818: ,x_msg_count
2819: ,x_msg_data
2820: ,'_PVT');
2821: WHEN OTHERS THEN
2822: x_return_status := okl_api.handle_exceptions(l_api_name
2823: ,g_pkg_name
2824: ,'OTHERS'
2825: ,x_msg_count
2826: ,x_msg_data

Line 2842: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2838: ,x_msg_data OUT NOCOPY VARCHAR2
2839: ,p_ethb_rec IN okl_ethb_rec) IS
2840: l_api_version CONSTANT NUMBER := 1;
2841: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
2842: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2843: l_ethb_rec okl_ethb_rec := p_ethb_rec;
2844: l_row_notfound BOOLEAN := true;
2845:
2846: BEGIN

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

2851: ,p_api_version
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;

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

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:
2861: DELETE FROM okl_fe_eo_terms_all_b

Line 2871: x_return_status := okl_api.handle_exceptions(l_api_name

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
2875: ,x_msg_data

Line 2873: ,'OKL_API.G_RET_STS_ERROR'

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
2875: ,x_msg_data
2876: ,'_PVT');
2877: WHEN okc_api.g_exception_unexpected_error THEN

Line 2878: x_return_status := okl_api.handle_exceptions(l_api_name

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
2882: ,x_msg_data

Line 2880: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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
2882: ,x_msg_data
2883: ,'_PVT');
2884: WHEN OTHERS THEN

Line 2885: x_return_status := okl_api.handle_exceptions(l_api_name

2881: ,x_msg_count
2882: ,x_msg_data
2883: ,'_PVT');
2884: WHEN OTHERS THEN
2885: x_return_status := okl_api.handle_exceptions(l_api_name
2886: ,g_pkg_name
2887: ,'OTHERS'
2888: ,x_msg_count
2889: ,x_msg_data

Line 2905: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2901: ,x_msg_data OUT NOCOPY VARCHAR2
2902: ,p_ethtl_rec IN okl_ethtl_rec) IS
2903: l_api_version CONSTANT NUMBER := 1;
2904: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
2905: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2906: l_ethtl_rec okl_ethtl_rec := p_ethtl_rec;
2907: l_row_notfound BOOLEAN := true;
2908:
2909: FUNCTION set_attributes(p_ethtl_rec IN okl_ethtl_rec

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

2925: ,p_api_version
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;

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

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:
2935: --Setting Item Attributes

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

2936:
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;

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

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:
2946: DELETE FROM okl_fe_eo_terms_all_tl

Line 2956: x_return_status := okl_api.handle_exceptions(l_api_name

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
2960: ,x_msg_data

Line 2958: ,'OKL_API.G_RET_STS_ERROR'

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
2960: ,x_msg_data
2961: ,'_PVT');
2962: WHEN okc_api.g_exception_unexpected_error THEN

Line 2963: x_return_status := okl_api.handle_exceptions(l_api_name

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
2967: ,x_msg_data

Line 2965: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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
2967: ,x_msg_data
2968: ,'_PVT');
2969: WHEN OTHERS THEN

Line 2970: x_return_status := okl_api.handle_exceptions(l_api_name

2966: ,x_msg_count
2967: ,x_msg_data
2968: ,'_PVT');
2969: WHEN OTHERS THEN
2970: x_return_status := okl_api.handle_exceptions(l_api_name
2971: ,g_pkg_name
2972: ,'OTHERS'
2973: ,x_msg_count
2974: ,x_msg_data

Line 2990: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2986: ,x_msg_data OUT NOCOPY VARCHAR2
2987: ,p_ethv_rec IN okl_ethv_rec) IS
2988: l_api_version CONSTANT NUMBER := 1;
2989: l_api_name CONSTANT VARCHAR2(30) := 'v_delete_row';
2990: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2991: l_ethv_rec okl_ethv_rec := p_ethv_rec;
2992: l_ethb_rec okl_ethb_rec;
2993: l_ethtl_rec okl_ethtl_rec;
2994:

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

3000: ,p_api_version
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;

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

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
3010: ,l_ethb_rec);

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

3016: ,x_msg_count
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;

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

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
3026: ,p_init_msg_list

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

3028: ,x_msg_count
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;

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

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
3038: ,x_msg_data);

Line 3046: x_return_status := okl_api.handle_exceptions(l_api_name

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
3050: ,x_msg_data

Line 3048: ,'OKL_API.G_RET_STS_ERROR'

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
3050: ,x_msg_data
3051: ,'_PVT');
3052: WHEN okc_api.g_exception_unexpected_error THEN

Line 3053: x_return_status := okl_api.handle_exceptions(l_api_name

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
3057: ,x_msg_data

Line 3055: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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
3057: ,x_msg_data
3058: ,'_PVT');
3059: WHEN OTHERS THEN

Line 3060: x_return_status := okl_api.handle_exceptions(l_api_name

3056: ,x_msg_count
3057: ,x_msg_data
3058: ,'_PVT');
3059: WHEN OTHERS THEN
3060: x_return_status := okl_api.handle_exceptions(l_api_name
3061: ,g_pkg_name
3062: ,'OTHERS'
3063: ,x_msg_count
3064: ,x_msg_data

Line 3080: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

3076: ,x_msg_data OUT NOCOPY VARCHAR2
3077: ,p_ethv_tbl IN okl_ethv_tbl) IS
3078: l_api_version CONSTANT NUMBER := 1;
3079: l_api_name CONSTANT VARCHAR2(30) := 'v_delete_row';
3080: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
3081: i NUMBER := 0;
3082: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
3083:
3084: BEGIN

Line 3082: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;

3078: l_api_version CONSTANT NUMBER := 1;
3079: l_api_name CONSTANT VARCHAR2(30) := 'v_delete_row';
3080: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
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:

Line 3117: x_return_status := okl_api.handle_exceptions(l_api_name

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
3121: ,x_msg_data

Line 3119: ,'OKL_API.G_RET_STS_ERROR'

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
3121: ,x_msg_data
3122: ,'_PVT');
3123: WHEN okc_api.g_exception_unexpected_error THEN

Line 3124: x_return_status := okl_api.handle_exceptions(l_api_name

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
3128: ,x_msg_data

Line 3126: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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
3128: ,x_msg_data
3129: ,'_PVT');
3130: WHEN OTHERS THEN

Line 3131: x_return_status := okl_api.handle_exceptions(l_api_name

3127: ,x_msg_count
3128: ,x_msg_data
3129: ,'_PVT');
3130: WHEN OTHERS THEN
3131: x_return_status := okl_api.handle_exceptions(l_api_name
3132: ,g_pkg_name
3133: ,'OTHERS'
3134: ,x_msg_count
3135: ,x_msg_data