APPS.OKL_ETH_PVT dependencies on OKL_API

Line 91: x_return_status := okl_api.g_ret_sts_success;

87: BEGIN
88:
89: -- initialize the return status
90:
91: x_return_status := okl_api.g_ret_sts_success;
92:
93: -- END_OF_TERM_ID is a required field
94:
95: 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 95: IF (p_ethv_rec.end_of_term_id IS NULL OR p_ethv_rec.end_of_term_id = okl_api.g_miss_num) THEN

91: x_return_status := okl_api.g_ret_sts_success;
92:
93: -- END_OF_TERM_ID is a required field
94:
95: IF (p_ethv_rec.end_of_term_id IS NULL OR p_ethv_rec.end_of_term_id = okl_api.g_miss_num) THEN
96: okl_api.set_message(p_app_name => g_app_name
97: ,p_msg_name => g_required_value
98: ,p_token1 => g_col_name_token
99: ,p_token1_value => 'END_OF_TERM_ID');

Line 96: okl_api.set_message(p_app_name => g_app_name

92:
93: -- END_OF_TERM_ID is a required field
94:
95: IF (p_ethv_rec.end_of_term_id IS NULL OR p_ethv_rec.end_of_term_id = okl_api.g_miss_num) THEN
96: okl_api.set_message(p_app_name => g_app_name
97: ,p_msg_name => g_required_value
98: ,p_token1 => g_col_name_token
99: ,p_token1_value => 'END_OF_TERM_ID');
100:

Line 103: x_return_status := okl_api.g_ret_sts_error;

99: ,p_token1_value => 'END_OF_TERM_ID');
100:
101: -- notify caller of an error
102:
103: x_return_status := okl_api.g_ret_sts_error;
104:
105: -- halt further validation of this column
106:
107: RAISE g_exception_halt_validation;

Line 139: x_return_status := okl_api.g_ret_sts_success;

135: BEGIN
136:
137: -- initialize the return status
138:
139: x_return_status := okl_api.g_ret_sts_success;
140:
141: -- object_version_number is a required field
142:
143: IF (p_ethv_rec.object_version_number IS NULL OR p_ethv_rec.object_version_number = okl_api.g_miss_num) THEN

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

139: x_return_status := okl_api.g_ret_sts_success;
140:
141: -- object_version_number is a required field
142:
143: IF (p_ethv_rec.object_version_number IS NULL OR p_ethv_rec.object_version_number = okl_api.g_miss_num) THEN
144: okl_api.set_message(p_app_name => g_app_name
145: ,p_msg_name => g_required_value
146: ,p_token1 => g_col_name_token
147: ,p_token1_value => 'object_version_number');

Line 144: okl_api.set_message(p_app_name => g_app_name

140:
141: -- object_version_number is a required field
142:
143: IF (p_ethv_rec.object_version_number IS NULL OR p_ethv_rec.object_version_number = okl_api.g_miss_num) THEN
144: okl_api.set_message(p_app_name => g_app_name
145: ,p_msg_name => g_required_value
146: ,p_token1 => g_col_name_token
147: ,p_token1_value => 'object_version_number');
148:

Line 151: x_return_status := okl_api.g_ret_sts_error;

147: ,p_token1_value => 'object_version_number');
148:
149: -- notify caller of an error
150:
151: x_return_status := okl_api.g_ret_sts_error;
152:
153: -- halt further validation of this column
154:
155: RAISE g_exception_halt_validation;

Line 219: okl_api.set_message(p_app_name => g_app_name

215: WHEN OTHERS THEN
216:
217: -- store SQL error message on message stack for caller
218:
219: okl_api.set_message(p_app_name => g_app_name
220: ,p_msg_name => g_unexpected_error
221: ,p_token1 => g_sqlcode_token
222: ,p_token1_value => sqlcode
223: ,p_token2 => g_sqlerrm_token

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

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

Line 342: x_return_status := okl_api.g_ret_sts_unexp_error;

338: ,p_token2_value => sqlerrm);
339:
340: -- notify caller of an UNEXPECTED error
341:
342: x_return_status := okl_api.g_ret_sts_unexp_error;
343: END validate_eot_type_code;
344:
345: PROCEDURE validate_product_id(x_return_status OUT NOCOPY VARCHAR2
346: ,p_ethv_rec IN okl_ethv_rec) IS

Line 370: x_return_status := okl_api.g_ret_sts_error;

366: ,p_token1_value => 'product_id');
367:
368: -- notify caller of an error
369:
370: x_return_status := okl_api.g_ret_sts_error;
371:
372: -- halt further validation of this column
373:
374: RAISE g_exception_halt_validation;

Line 445: x_return_status := okl_api.g_ret_sts_error;

441: ,p_token1_value => 'CATEGORY_TYPE_CODE');
442:
443: -- notify caller of an error
444:
445: x_return_status := okl_api.g_ret_sts_error;
446:
447: -- halt further validation of this column
448:
449: RAISE g_exception_halt_validation;

Line 507: x_return_status := okl_api.g_ret_sts_success;

503: BEGIN
504:
505: -- Initialize the return status to success
506:
507: x_return_status := okl_api.g_ret_sts_success;
508:
509: 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
510: OPEN pos_exists_csr;
511: FETCH pos_exists_csr INTO l_dummy_var ;

Line 509: 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

505: -- Initialize the return status to success
506:
507: x_return_status := okl_api.g_ret_sts_success;
508:
509: 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
510: OPEN pos_exists_csr;
511: FETCH pos_exists_csr INTO l_dummy_var ;
512: CLOSE pos_exists_csr;
513:

Line 517: okl_api.set_message(p_app_name => g_app_name

513:
514: -- if l_dummy_var is still set to default, data was not found
515:
516: IF (l_dummy_var = '?') THEN
517: okl_api.set_message(p_app_name => g_app_name
518: ,p_msg_name => g_invalid_value
519: ,p_token1 => g_col_name_token
520: ,p_token1_value => 'ORIG_END_OF_TERM_ID');
521:

Line 566: x_return_status := okl_api.g_ret_sts_success;

562: BEGIN
563:
564: -- Initialize the return status to success
565:
566: x_return_status := okl_api.g_ret_sts_success;
567:
568: IF (p_ethv_rec.effective_from_date IS NULL OR p_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN
569: okl_api.set_message(p_app_name => g_app_name
570: ,p_msg_name => g_required_value

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

564: -- Initialize the return status to success
565:
566: x_return_status := okl_api.g_ret_sts_success;
567:
568: IF (p_ethv_rec.effective_from_date IS NULL OR p_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN
569: okl_api.set_message(p_app_name => g_app_name
570: ,p_msg_name => g_required_value
571: ,p_token1 => g_col_name_token
572: ,p_token1_value => 'EFFECTIVE_FROM_DATE');

Line 569: okl_api.set_message(p_app_name => g_app_name

565:
566: x_return_status := okl_api.g_ret_sts_success;
567:
568: IF (p_ethv_rec.effective_from_date IS NULL OR p_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN
569: okl_api.set_message(p_app_name => g_app_name
570: ,p_msg_name => g_required_value
571: ,p_token1 => g_col_name_token
572: ,p_token1_value => 'EFFECTIVE_FROM_DATE');
573:

Line 576: x_return_status := okl_api.g_ret_sts_error;

572: ,p_token1_value => 'EFFECTIVE_FROM_DATE');
573:
574: -- notify caller of an error
575:
576: x_return_status := okl_api.g_ret_sts_error;
577: RAISE g_exception_halt_validation;
578: END IF;
579:
580: EXCEPTION

Line 610: x_return_status := okl_api.g_ret_sts_success;

606: BEGIN
607:
608: -- Initialize the return status to success
609:
610: x_return_status := okl_api.g_ret_sts_success;
611:
612: -- Column is mandatory
613:
614: IF (p_ethv_rec.sts_code IS NULL OR p_ethv_rec.sts_code = okl_api.g_miss_char) THEN

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

610: x_return_status := okl_api.g_ret_sts_success;
611:
612: -- Column is mandatory
613:
614: IF (p_ethv_rec.sts_code IS NULL OR p_ethv_rec.sts_code = okl_api.g_miss_char) THEN
615: okl_api.set_message(p_app_name => g_app_name
616: ,p_msg_name => g_required_value
617: ,p_token1 => g_col_name_token
618: ,p_token1_value => 'sts_code');

Line 615: okl_api.set_message(p_app_name => g_app_name

611:
612: -- Column is mandatory
613:
614: IF (p_ethv_rec.sts_code IS NULL OR p_ethv_rec.sts_code = okl_api.g_miss_char) THEN
615: okl_api.set_message(p_app_name => g_app_name
616: ,p_msg_name => g_required_value
617: ,p_token1 => g_col_name_token
618: ,p_token1_value => 'sts_code');
619:

Line 622: x_return_status := okl_api.g_ret_sts_error;

618: ,p_token1_value => 'sts_code');
619:
620: -- notify caller of an error
621:
622: x_return_status := okl_api.g_ret_sts_error;
623: RAISE g_exception_halt_validation;
624: END IF;
625:
626: -- Lookup Code Validation

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

1031: l_ethv_rec okl_ethv_rec := p_ethv_rec;
1032:
1033: BEGIN
1034:
1035: IF (l_ethv_rec.end_of_term_id = okl_api.g_miss_num) THEN
1036: l_ethv_rec.end_of_term_id := NULL;
1037: END IF;
1038:
1039: IF (l_ethv_rec.object_version_number = okl_api.g_miss_num) THEN

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

1035: IF (l_ethv_rec.end_of_term_id = okl_api.g_miss_num) THEN
1036: l_ethv_rec.end_of_term_id := NULL;
1037: END IF;
1038:
1039: IF (l_ethv_rec.object_version_number = okl_api.g_miss_num) THEN
1040: l_ethv_rec.object_version_number := NULL;
1041: END IF;
1042:
1043: IF (l_ethv_rec.end_of_term_name = okl_api.g_miss_char) THEN

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

1039: IF (l_ethv_rec.object_version_number = okl_api.g_miss_num) THEN
1040: l_ethv_rec.object_version_number := NULL;
1041: END IF;
1042:
1043: IF (l_ethv_rec.end_of_term_name = okl_api.g_miss_char) THEN
1044: l_ethv_rec.end_of_term_name := NULL;
1045: END IF;
1046:
1047: IF (l_ethv_rec.end_of_term_desc = okl_api.g_miss_char) THEN

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

1043: IF (l_ethv_rec.end_of_term_name = okl_api.g_miss_char) THEN
1044: l_ethv_rec.end_of_term_name := NULL;
1045: END IF;
1046:
1047: IF (l_ethv_rec.end_of_term_desc = okl_api.g_miss_char) THEN
1048: l_ethv_rec.end_of_term_desc := NULL;
1049: END IF;
1050:
1051: IF (l_ethv_rec.org_id = okl_api.g_miss_num) THEN

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

1047: IF (l_ethv_rec.end_of_term_desc = okl_api.g_miss_char) THEN
1048: l_ethv_rec.end_of_term_desc := NULL;
1049: END IF;
1050:
1051: IF (l_ethv_rec.org_id = okl_api.g_miss_num) THEN
1052: l_ethv_rec.org_id := NULL;
1053: END IF;
1054:
1055: IF (l_ethv_rec.currency_code = okl_api.g_miss_char) THEN

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

1051: IF (l_ethv_rec.org_id = okl_api.g_miss_num) THEN
1052: l_ethv_rec.org_id := NULL;
1053: END IF;
1054:
1055: IF (l_ethv_rec.currency_code = okl_api.g_miss_char) THEN
1056: l_ethv_rec.currency_code := NULL;
1057: END IF;
1058:
1059: IF (l_ethv_rec.eot_type_code = okl_api.g_miss_char) THEN

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

1055: IF (l_ethv_rec.currency_code = okl_api.g_miss_char) THEN
1056: l_ethv_rec.currency_code := NULL;
1057: END IF;
1058:
1059: IF (l_ethv_rec.eot_type_code = okl_api.g_miss_char) THEN
1060: l_ethv_rec.eot_type_code := NULL;
1061: END IF;
1062:
1063: IF (l_ethv_rec.product_id = okl_api.g_miss_num) THEN

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

1059: IF (l_ethv_rec.eot_type_code = okl_api.g_miss_char) THEN
1060: l_ethv_rec.eot_type_code := NULL;
1061: END IF;
1062:
1063: IF (l_ethv_rec.product_id = okl_api.g_miss_num) THEN
1064: l_ethv_rec.product_id := NULL;
1065: END IF;
1066:
1067: IF (l_ethv_rec.category_type_code = okl_api.g_miss_char) THEN

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

1063: IF (l_ethv_rec.product_id = okl_api.g_miss_num) THEN
1064: l_ethv_rec.product_id := NULL;
1065: END IF;
1066:
1067: IF (l_ethv_rec.category_type_code = okl_api.g_miss_char) THEN
1068: l_ethv_rec.category_type_code := NULL;
1069: END IF;
1070:
1071: IF (l_ethv_rec.orig_end_of_term_id = okl_api.g_miss_num) THEN

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

1067: IF (l_ethv_rec.category_type_code = okl_api.g_miss_char) THEN
1068: l_ethv_rec.category_type_code := NULL;
1069: END IF;
1070:
1071: IF (l_ethv_rec.orig_end_of_term_id = okl_api.g_miss_num) THEN
1072: l_ethv_rec.orig_end_of_term_id := NULL;
1073: END IF;
1074:
1075: IF (l_ethv_rec.sts_code = okl_api.g_miss_char) THEN

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

1071: IF (l_ethv_rec.orig_end_of_term_id = okl_api.g_miss_num) THEN
1072: l_ethv_rec.orig_end_of_term_id := NULL;
1073: END IF;
1074:
1075: IF (l_ethv_rec.sts_code = okl_api.g_miss_char) THEN
1076: l_ethv_rec.sts_code := NULL;
1077: END IF;
1078:
1079: IF (l_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN

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

1075: IF (l_ethv_rec.sts_code = okl_api.g_miss_char) THEN
1076: l_ethv_rec.sts_code := NULL;
1077: END IF;
1078:
1079: IF (l_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN
1080: l_ethv_rec.effective_from_date := NULL;
1081: END IF;
1082:
1083: IF (l_ethv_rec.effective_to_date = okl_api.g_miss_date) THEN

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

1079: IF (l_ethv_rec.effective_from_date = okl_api.g_miss_date) THEN
1080: l_ethv_rec.effective_from_date := NULL;
1081: END IF;
1082:
1083: IF (l_ethv_rec.effective_to_date = okl_api.g_miss_date) THEN
1084: l_ethv_rec.effective_to_date := NULL;
1085: END IF;
1086:
1087: IF (l_ethv_rec.attribute_category = okl_api.g_miss_char) THEN

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

1083: IF (l_ethv_rec.effective_to_date = okl_api.g_miss_date) THEN
1084: l_ethv_rec.effective_to_date := NULL;
1085: END IF;
1086:
1087: IF (l_ethv_rec.attribute_category = okl_api.g_miss_char) THEN
1088: l_ethv_rec.attribute_category := NULL;
1089: END IF;
1090:
1091: IF (l_ethv_rec.attribute1 = okl_api.g_miss_char) THEN

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

1087: IF (l_ethv_rec.attribute_category = okl_api.g_miss_char) THEN
1088: l_ethv_rec.attribute_category := NULL;
1089: END IF;
1090:
1091: IF (l_ethv_rec.attribute1 = okl_api.g_miss_char) THEN
1092: l_ethv_rec.attribute1 := NULL;
1093: END IF;
1094:
1095: IF (l_ethv_rec.attribute2 = okl_api.g_miss_char) THEN

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

1091: IF (l_ethv_rec.attribute1 = okl_api.g_miss_char) THEN
1092: l_ethv_rec.attribute1 := NULL;
1093: END IF;
1094:
1095: IF (l_ethv_rec.attribute2 = okl_api.g_miss_char) THEN
1096: l_ethv_rec.attribute2 := NULL;
1097: END IF;
1098:
1099: IF (l_ethv_rec.attribute3 = okl_api.g_miss_char) THEN

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

1095: IF (l_ethv_rec.attribute2 = okl_api.g_miss_char) THEN
1096: l_ethv_rec.attribute2 := NULL;
1097: END IF;
1098:
1099: IF (l_ethv_rec.attribute3 = okl_api.g_miss_char) THEN
1100: l_ethv_rec.attribute3 := NULL;
1101: END IF;
1102:
1103: IF (l_ethv_rec.attribute4 = okl_api.g_miss_char) THEN

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

1099: IF (l_ethv_rec.attribute3 = okl_api.g_miss_char) THEN
1100: l_ethv_rec.attribute3 := NULL;
1101: END IF;
1102:
1103: IF (l_ethv_rec.attribute4 = okl_api.g_miss_char) THEN
1104: l_ethv_rec.attribute4 := NULL;
1105: END IF;
1106:
1107: IF (l_ethv_rec.attribute5 = okl_api.g_miss_char) THEN

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

1103: IF (l_ethv_rec.attribute4 = okl_api.g_miss_char) THEN
1104: l_ethv_rec.attribute4 := NULL;
1105: END IF;
1106:
1107: IF (l_ethv_rec.attribute5 = okl_api.g_miss_char) THEN
1108: l_ethv_rec.attribute5 := NULL;
1109: END IF;
1110:
1111: IF (l_ethv_rec.attribute6 = okl_api.g_miss_char) THEN

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

1107: IF (l_ethv_rec.attribute5 = okl_api.g_miss_char) THEN
1108: l_ethv_rec.attribute5 := NULL;
1109: END IF;
1110:
1111: IF (l_ethv_rec.attribute6 = okl_api.g_miss_char) THEN
1112: l_ethv_rec.attribute6 := NULL;
1113: END IF;
1114:
1115: IF (l_ethv_rec.attribute7 = okl_api.g_miss_char) THEN

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

1111: IF (l_ethv_rec.attribute6 = okl_api.g_miss_char) THEN
1112: l_ethv_rec.attribute6 := NULL;
1113: END IF;
1114:
1115: IF (l_ethv_rec.attribute7 = okl_api.g_miss_char) THEN
1116: l_ethv_rec.attribute7 := NULL;
1117: END IF;
1118:
1119: IF (l_ethv_rec.attribute8 = okl_api.g_miss_char) THEN

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

1115: IF (l_ethv_rec.attribute7 = okl_api.g_miss_char) THEN
1116: l_ethv_rec.attribute7 := NULL;
1117: END IF;
1118:
1119: IF (l_ethv_rec.attribute8 = okl_api.g_miss_char) THEN
1120: l_ethv_rec.attribute8 := NULL;
1121: END IF;
1122:
1123: IF (l_ethv_rec.attribute9 = okl_api.g_miss_char) THEN

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

1119: IF (l_ethv_rec.attribute8 = okl_api.g_miss_char) THEN
1120: l_ethv_rec.attribute8 := NULL;
1121: END IF;
1122:
1123: IF (l_ethv_rec.attribute9 = okl_api.g_miss_char) THEN
1124: l_ethv_rec.attribute9 := NULL;
1125: END IF;
1126:
1127: IF (l_ethv_rec.attribute10 = okl_api.g_miss_char) THEN

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

1123: IF (l_ethv_rec.attribute9 = okl_api.g_miss_char) THEN
1124: l_ethv_rec.attribute9 := NULL;
1125: END IF;
1126:
1127: IF (l_ethv_rec.attribute10 = okl_api.g_miss_char) THEN
1128: l_ethv_rec.attribute10 := NULL;
1129: END IF;
1130:
1131: IF (l_ethv_rec.attribute11 = okl_api.g_miss_char) THEN

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

1127: IF (l_ethv_rec.attribute10 = okl_api.g_miss_char) THEN
1128: l_ethv_rec.attribute10 := NULL;
1129: END IF;
1130:
1131: IF (l_ethv_rec.attribute11 = okl_api.g_miss_char) THEN
1132: l_ethv_rec.attribute11 := NULL;
1133: END IF;
1134:
1135: IF (l_ethv_rec.attribute12 = okl_api.g_miss_char) THEN

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

1131: IF (l_ethv_rec.attribute11 = okl_api.g_miss_char) THEN
1132: l_ethv_rec.attribute11 := NULL;
1133: END IF;
1134:
1135: IF (l_ethv_rec.attribute12 = okl_api.g_miss_char) THEN
1136: l_ethv_rec.attribute12 := NULL;
1137: END IF;
1138:
1139: IF (l_ethv_rec.attribute13 = okl_api.g_miss_char) THEN

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

1135: IF (l_ethv_rec.attribute12 = okl_api.g_miss_char) THEN
1136: l_ethv_rec.attribute12 := NULL;
1137: END IF;
1138:
1139: IF (l_ethv_rec.attribute13 = okl_api.g_miss_char) THEN
1140: l_ethv_rec.attribute13 := NULL;
1141: END IF;
1142:
1143: IF (l_ethv_rec.attribute14 = okl_api.g_miss_char) THEN

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

1139: IF (l_ethv_rec.attribute13 = okl_api.g_miss_char) THEN
1140: l_ethv_rec.attribute13 := NULL;
1141: END IF;
1142:
1143: IF (l_ethv_rec.attribute14 = okl_api.g_miss_char) THEN
1144: l_ethv_rec.attribute14 := NULL;
1145: END IF;
1146:
1147: IF (l_ethv_rec.attribute15 = okl_api.g_miss_char) THEN

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

1143: IF (l_ethv_rec.attribute14 = okl_api.g_miss_char) THEN
1144: l_ethv_rec.attribute14 := NULL;
1145: END IF;
1146:
1147: IF (l_ethv_rec.attribute15 = okl_api.g_miss_char) THEN
1148: l_ethv_rec.attribute15 := NULL;
1149: END IF;
1150:
1151: IF (l_ethv_rec.created_by = okl_api.g_miss_num) THEN

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

1147: IF (l_ethv_rec.attribute15 = okl_api.g_miss_char) THEN
1148: l_ethv_rec.attribute15 := NULL;
1149: END IF;
1150:
1151: IF (l_ethv_rec.created_by = okl_api.g_miss_num) THEN
1152: l_ethv_rec.created_by := NULL;
1153: END IF;
1154:
1155: IF (l_ethv_rec.creation_date = okl_api.g_miss_date) THEN

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

1151: IF (l_ethv_rec.created_by = okl_api.g_miss_num) THEN
1152: l_ethv_rec.created_by := NULL;
1153: END IF;
1154:
1155: IF (l_ethv_rec.creation_date = okl_api.g_miss_date) THEN
1156: l_ethv_rec.creation_date := NULL;
1157: END IF;
1158:
1159: IF (l_ethv_rec.last_updated_by = okl_api.g_miss_num) THEN

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

1155: IF (l_ethv_rec.creation_date = okl_api.g_miss_date) THEN
1156: l_ethv_rec.creation_date := NULL;
1157: END IF;
1158:
1159: IF (l_ethv_rec.last_updated_by = okl_api.g_miss_num) THEN
1160: l_ethv_rec.last_updated_by := NULL;
1161: END IF;
1162:
1163: IF (l_ethv_rec.last_update_date = okl_api.g_miss_date) THEN

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

1159: IF (l_ethv_rec.last_updated_by = okl_api.g_miss_num) THEN
1160: l_ethv_rec.last_updated_by := NULL;
1161: END IF;
1162:
1163: IF (l_ethv_rec.last_update_date = okl_api.g_miss_date) THEN
1164: l_ethv_rec.last_update_date := NULL;
1165: END IF;
1166:
1167: IF (l_ethv_rec.last_update_login = okl_api.g_miss_num) THEN

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

1163: IF (l_ethv_rec.last_update_date = okl_api.g_miss_date) THEN
1164: l_ethv_rec.last_update_date := NULL;
1165: END IF;
1166:
1167: IF (l_ethv_rec.last_update_login = okl_api.g_miss_num) THEN
1168: l_ethv_rec.last_update_login := NULL;
1169: END IF;
1170: RETURN(l_ethv_rec);
1171: END null_out_defaults;

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

1177: END get_seq_id;
1178:
1179: FUNCTION validate_attributes(p_ethv_rec IN okl_ethv_rec) RETURN VARCHAR2 IS
1180: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
1181: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1182:
1183: BEGIN
1184:
1185: -- validate the id

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

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

Line 1297: okl_api.set_message(p_app_name => g_app_name

1293:
1294: BEGIN
1295: IF (p_ethv_rec.effective_to_date IS NOT NULL) THEN
1296: IF (p_ethv_rec.effective_from_date > p_ethv_rec.effective_to_date) THEN
1297: okl_api.set_message(p_app_name => g_app_name
1298: ,p_msg_name => 'OKL_INVALID_EFFECTIVE_TO');
1299: x_return_status := okl_api.g_ret_sts_error;
1300: END IF;
1301: END IF;

Line 1299: x_return_status := okl_api.g_ret_sts_error;

1295: IF (p_ethv_rec.effective_to_date IS NOT NULL) THEN
1296: IF (p_ethv_rec.effective_from_date > p_ethv_rec.effective_to_date) THEN
1297: okl_api.set_message(p_app_name => g_app_name
1298: ,p_msg_name => 'OKL_INVALID_EFFECTIVE_TO');
1299: x_return_status := okl_api.g_ret_sts_error;
1300: END IF;
1301: END IF;
1302: RETURN(x_return_status);
1303: END validate_record;

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

1323: FROM okl_fe_eo_terms_all_b
1324: WHERE end_of_term_id = p_ethb_rec.end_of_term_id;
1325: l_api_version CONSTANT NUMBER := 1;
1326: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1327: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1328: l_object_version_number okl_fe_resi_cat_all_b.object_version_number%TYPE;
1329: lc_object_version_number okl_fe_resi_cat_all_b.object_version_number%TYPE;
1330: l_row_notfound BOOLEAN := false;
1331: lc_row_notfound BOOLEAN := false;

Line 1334: l_return_status := okl_api.start_activity(l_api_name

1330: l_row_notfound BOOLEAN := false;
1331: lc_row_notfound BOOLEAN := false;
1332:
1333: BEGIN
1334: l_return_status := okl_api.start_activity(l_api_name
1335: ,p_init_msg_list
1336: ,'_PVT'
1337: ,x_return_status);
1338:

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

1335: ,p_init_msg_list
1336: ,'_PVT'
1337: ,x_return_status);
1338:
1339: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1340: RAISE okl_api.g_exception_unexpected_error;
1341: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1342: RAISE okl_api.g_exception_error;
1343: END IF;

Line 1340: RAISE okl_api.g_exception_unexpected_error;

1336: ,'_PVT'
1337: ,x_return_status);
1338:
1339: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1340: RAISE okl_api.g_exception_unexpected_error;
1341: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1342: RAISE okl_api.g_exception_error;
1343: END IF;
1344:

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

1337: ,x_return_status);
1338:
1339: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1340: RAISE okl_api.g_exception_unexpected_error;
1341: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1342: RAISE okl_api.g_exception_error;
1343: END IF;
1344:
1345: BEGIN

Line 1342: RAISE okl_api.g_exception_error;

1338:
1339: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1340: RAISE okl_api.g_exception_unexpected_error;
1341: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1342: RAISE okl_api.g_exception_error;
1343: END IF;
1344:
1345: BEGIN
1346: OPEN lock_csr(p_ethb_rec);

Line 1356: okl_api.set_message(g_fnd_app

1352:
1353: IF (lock_csr%ISOPEN) THEN
1354: CLOSE lock_csr;
1355: END IF;
1356: okl_api.set_message(g_fnd_app
1357: ,g_form_unable_to_reserve_rec);
1358: RAISE app_exceptions.record_lock_exception;
1359: END;
1360:

Line 1369: okl_api.set_message(g_fnd_app

1365: CLOSE lchk_csr;
1366: END IF;
1367:
1368: IF (lc_row_notfound) THEN
1369: okl_api.set_message(g_fnd_app
1370: ,g_form_record_deleted);
1371: RAISE okl_api.g_exception_error;
1372: ELSIF lc_object_version_number > p_ethb_rec.object_version_number THEN
1373: okl_api.set_message(g_fnd_app

Line 1371: RAISE okl_api.g_exception_error;

1367:
1368: IF (lc_row_notfound) THEN
1369: okl_api.set_message(g_fnd_app
1370: ,g_form_record_deleted);
1371: RAISE okl_api.g_exception_error;
1372: ELSIF lc_object_version_number > p_ethb_rec.object_version_number THEN
1373: okl_api.set_message(g_fnd_app
1374: ,g_form_record_changed);
1375: RAISE okl_api.g_exception_error;

Line 1373: okl_api.set_message(g_fnd_app

1369: okl_api.set_message(g_fnd_app
1370: ,g_form_record_deleted);
1371: RAISE okl_api.g_exception_error;
1372: ELSIF lc_object_version_number > p_ethb_rec.object_version_number THEN
1373: okl_api.set_message(g_fnd_app
1374: ,g_form_record_changed);
1375: RAISE okl_api.g_exception_error;
1376: ELSIF lc_object_version_number <> p_ethb_rec.object_version_number THEN
1377: okl_api.set_message(g_fnd_app

Line 1375: RAISE okl_api.g_exception_error;

1371: RAISE okl_api.g_exception_error;
1372: ELSIF lc_object_version_number > p_ethb_rec.object_version_number THEN
1373: okl_api.set_message(g_fnd_app
1374: ,g_form_record_changed);
1375: RAISE okl_api.g_exception_error;
1376: ELSIF lc_object_version_number <> p_ethb_rec.object_version_number THEN
1377: okl_api.set_message(g_fnd_app
1378: ,g_form_record_changed);
1379: RAISE okl_api.g_exception_error;

Line 1377: okl_api.set_message(g_fnd_app

1373: okl_api.set_message(g_fnd_app
1374: ,g_form_record_changed);
1375: RAISE okl_api.g_exception_error;
1376: ELSIF lc_object_version_number <> p_ethb_rec.object_version_number THEN
1377: okl_api.set_message(g_fnd_app
1378: ,g_form_record_changed);
1379: RAISE okl_api.g_exception_error;
1380: ELSIF lc_object_version_number = - 1 THEN
1381: okl_api.set_message(g_app_name

Line 1379: RAISE okl_api.g_exception_error;

1375: RAISE okl_api.g_exception_error;
1376: ELSIF lc_object_version_number <> p_ethb_rec.object_version_number THEN
1377: okl_api.set_message(g_fnd_app
1378: ,g_form_record_changed);
1379: RAISE okl_api.g_exception_error;
1380: ELSIF lc_object_version_number = - 1 THEN
1381: okl_api.set_message(g_app_name
1382: ,g_record_logically_deleted);
1383: RAISE okl_api.g_exception_error;

Line 1381: okl_api.set_message(g_app_name

1377: okl_api.set_message(g_fnd_app
1378: ,g_form_record_changed);
1379: RAISE okl_api.g_exception_error;
1380: ELSIF lc_object_version_number = - 1 THEN
1381: okl_api.set_message(g_app_name
1382: ,g_record_logically_deleted);
1383: RAISE okl_api.g_exception_error;
1384: END IF;
1385: okl_api.end_activity(x_msg_count

Line 1383: RAISE okl_api.g_exception_error;

1379: RAISE okl_api.g_exception_error;
1380: ELSIF lc_object_version_number = - 1 THEN
1381: okl_api.set_message(g_app_name
1382: ,g_record_logically_deleted);
1383: RAISE okl_api.g_exception_error;
1384: END IF;
1385: okl_api.end_activity(x_msg_count
1386: ,x_msg_data);
1387: EXCEPTION

Line 1385: okl_api.end_activity(x_msg_count

1381: okl_api.set_message(g_app_name
1382: ,g_record_logically_deleted);
1383: RAISE okl_api.g_exception_error;
1384: END IF;
1385: okl_api.end_activity(x_msg_count
1386: ,x_msg_data);
1387: EXCEPTION
1388: WHEN g_exception_halt_validation THEN
1389: x_return_status := okl_api.handle_exceptions(l_api_name

Line 1389: x_return_status := okl_api.handle_exceptions(l_api_name

1385: okl_api.end_activity(x_msg_count
1386: ,x_msg_data);
1387: EXCEPTION
1388: WHEN g_exception_halt_validation THEN
1389: x_return_status := okl_api.handle_exceptions(l_api_name
1390: ,g_pkg_name
1391: ,'OKL_API.G_RET_STS_ERROR'
1392: ,x_msg_count
1393: ,x_msg_data

Line 1391: ,'OKL_API.G_RET_STS_ERROR'

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

Line 1395: WHEN okl_api.g_exception_error THEN

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

Line 1396: x_return_status := okl_api.handle_exceptions(l_api_name

1392: ,x_msg_count
1393: ,x_msg_data
1394: ,'_PVT');
1395: WHEN okl_api.g_exception_error THEN
1396: x_return_status := okl_api.handle_exceptions(l_api_name
1397: ,g_pkg_name
1398: ,'OKL_API.G_RET_STS_ERROR'
1399: ,x_msg_count
1400: ,x_msg_data

Line 1398: ,'OKL_API.G_RET_STS_ERROR'

1394: ,'_PVT');
1395: WHEN okl_api.g_exception_error THEN
1396: x_return_status := okl_api.handle_exceptions(l_api_name
1397: ,g_pkg_name
1398: ,'OKL_API.G_RET_STS_ERROR'
1399: ,x_msg_count
1400: ,x_msg_data
1401: ,'_PVT');
1402: WHEN okl_api.g_exception_unexpected_error THEN

Line 1402: WHEN okl_api.g_exception_unexpected_error THEN

1398: ,'OKL_API.G_RET_STS_ERROR'
1399: ,x_msg_count
1400: ,x_msg_data
1401: ,'_PVT');
1402: WHEN okl_api.g_exception_unexpected_error THEN
1403: x_return_status := okl_api.handle_exceptions(l_api_name
1404: ,g_pkg_name
1405: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1406: ,x_msg_count

Line 1403: x_return_status := okl_api.handle_exceptions(l_api_name

1399: ,x_msg_count
1400: ,x_msg_data
1401: ,'_PVT');
1402: WHEN okl_api.g_exception_unexpected_error THEN
1403: x_return_status := okl_api.handle_exceptions(l_api_name
1404: ,g_pkg_name
1405: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1406: ,x_msg_count
1407: ,x_msg_data

Line 1405: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1401: ,'_PVT');
1402: WHEN okl_api.g_exception_unexpected_error THEN
1403: x_return_status := okl_api.handle_exceptions(l_api_name
1404: ,g_pkg_name
1405: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1406: ,x_msg_count
1407: ,x_msg_data
1408: ,'_PVT');
1409: WHEN OTHERS THEN

Line 1410: x_return_status := okl_api.handle_exceptions(l_api_name

1406: ,x_msg_count
1407: ,x_msg_data
1408: ,'_PVT');
1409: WHEN OTHERS THEN
1410: x_return_status := okl_api.handle_exceptions(l_api_name
1411: ,g_pkg_name
1412: ,'OTHERS'
1413: ,x_msg_count
1414: ,x_msg_data

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

1434: WHERE end_of_term_id = p_ethtl_rec.end_of_term_id
1435: FOR UPDATE NOWAIT;
1436: l_api_version CONSTANT NUMBER := 1;
1437: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';
1438: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1439: l_lock_var lock_csr%ROWTYPE;
1440: l_row_notfound BOOLEAN := false;
1441: lc_row_notfound BOOLEAN := false;
1442:

Line 1444: l_return_status := okl_api.start_activity(l_api_name

1440: l_row_notfound BOOLEAN := false;
1441: lc_row_notfound BOOLEAN := false;
1442:
1443: BEGIN
1444: l_return_status := okl_api.start_activity(l_api_name
1445: ,p_init_msg_list
1446: ,'_PVT'
1447: ,x_return_status);
1448:

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

1445: ,p_init_msg_list
1446: ,'_PVT'
1447: ,x_return_status);
1448:
1449: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1450: RAISE okl_api.g_exception_unexpected_error;
1451: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1452: RAISE okl_api.g_exception_error;
1453: END IF;

Line 1450: RAISE okl_api.g_exception_unexpected_error;

1446: ,'_PVT'
1447: ,x_return_status);
1448:
1449: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1450: RAISE okl_api.g_exception_unexpected_error;
1451: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1452: RAISE okl_api.g_exception_error;
1453: END IF;
1454:

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

1447: ,x_return_status);
1448:
1449: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1450: RAISE okl_api.g_exception_unexpected_error;
1451: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1452: RAISE okl_api.g_exception_error;
1453: END IF;
1454:
1455: BEGIN

Line 1452: RAISE okl_api.g_exception_error;

1448:
1449: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1450: RAISE okl_api.g_exception_unexpected_error;
1451: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1452: RAISE okl_api.g_exception_error;
1453: END IF;
1454:
1455: BEGIN
1456: OPEN lock_csr(p_ethtl_rec);

Line 1466: okl_api.set_message(g_fnd_app

1462:
1463: IF (lock_csr%ISOPEN) THEN
1464: CLOSE lock_csr;
1465: END IF;
1466: okl_api.set_message(g_fnd_app
1467: ,g_form_unable_to_reserve_rec);
1468: RAISE app_exceptions.record_lock_exception;
1469: END;
1470:

Line 1472: okl_api.set_message(g_fnd_app

1468: RAISE app_exceptions.record_lock_exception;
1469: END;
1470:
1471: IF (l_row_notfound) THEN
1472: okl_api.set_message(g_fnd_app
1473: ,g_form_record_deleted);
1474: RAISE okl_api.g_exception_error;
1475: END IF;
1476: okl_api.end_activity(x_msg_count

Line 1474: RAISE okl_api.g_exception_error;

1470:
1471: IF (l_row_notfound) THEN
1472: okl_api.set_message(g_fnd_app
1473: ,g_form_record_deleted);
1474: RAISE okl_api.g_exception_error;
1475: END IF;
1476: okl_api.end_activity(x_msg_count
1477: ,x_msg_data);
1478: EXCEPTION

Line 1476: okl_api.end_activity(x_msg_count

1472: okl_api.set_message(g_fnd_app
1473: ,g_form_record_deleted);
1474: RAISE okl_api.g_exception_error;
1475: END IF;
1476: okl_api.end_activity(x_msg_count
1477: ,x_msg_data);
1478: EXCEPTION
1479: WHEN g_exception_halt_validation THEN
1480: x_return_status := okl_api.handle_exceptions(l_api_name

Line 1480: x_return_status := okl_api.handle_exceptions(l_api_name

1476: okl_api.end_activity(x_msg_count
1477: ,x_msg_data);
1478: EXCEPTION
1479: WHEN g_exception_halt_validation THEN
1480: x_return_status := okl_api.handle_exceptions(l_api_name
1481: ,g_pkg_name
1482: ,'OKL_API.G_RET_STS_ERROR'
1483: ,x_msg_count
1484: ,x_msg_data

Line 1482: ,'OKL_API.G_RET_STS_ERROR'

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

Line 1486: WHEN okl_api.g_exception_error THEN

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

Line 1487: x_return_status := okl_api.handle_exceptions(l_api_name

1483: ,x_msg_count
1484: ,x_msg_data
1485: ,'_PVT');
1486: WHEN okl_api.g_exception_error THEN
1487: x_return_status := okl_api.handle_exceptions(l_api_name
1488: ,g_pkg_name
1489: ,'OKL_API.G_RET_STS_ERROR'
1490: ,x_msg_count
1491: ,x_msg_data

Line 1489: ,'OKL_API.G_RET_STS_ERROR'

1485: ,'_PVT');
1486: WHEN okl_api.g_exception_error THEN
1487: x_return_status := okl_api.handle_exceptions(l_api_name
1488: ,g_pkg_name
1489: ,'OKL_API.G_RET_STS_ERROR'
1490: ,x_msg_count
1491: ,x_msg_data
1492: ,'_PVT');
1493: WHEN okl_api.g_exception_unexpected_error THEN

Line 1493: WHEN okl_api.g_exception_unexpected_error THEN

1489: ,'OKL_API.G_RET_STS_ERROR'
1490: ,x_msg_count
1491: ,x_msg_data
1492: ,'_PVT');
1493: WHEN okl_api.g_exception_unexpected_error THEN
1494: x_return_status := okl_api.handle_exceptions(l_api_name
1495: ,g_pkg_name
1496: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1497: ,x_msg_count

Line 1494: x_return_status := okl_api.handle_exceptions(l_api_name

1490: ,x_msg_count
1491: ,x_msg_data
1492: ,'_PVT');
1493: WHEN okl_api.g_exception_unexpected_error THEN
1494: x_return_status := okl_api.handle_exceptions(l_api_name
1495: ,g_pkg_name
1496: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1497: ,x_msg_count
1498: ,x_msg_data

Line 1496: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1492: ,'_PVT');
1493: WHEN okl_api.g_exception_unexpected_error THEN
1494: x_return_status := okl_api.handle_exceptions(l_api_name
1495: ,g_pkg_name
1496: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1497: ,x_msg_count
1498: ,x_msg_data
1499: ,'_PVT');
1500: WHEN OTHERS THEN

Line 1501: x_return_status := okl_api.handle_exceptions(l_api_name

1497: ,x_msg_count
1498: ,x_msg_data
1499: ,'_PVT');
1500: WHEN OTHERS THEN
1501: x_return_status := okl_api.handle_exceptions(l_api_name
1502: ,g_pkg_name
1503: ,'OTHERS'
1504: ,x_msg_count
1505: ,x_msg_data

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

1517: ,x_msg_data OUT NOCOPY VARCHAR2
1518: ,p_ethv_rec IN okl_ethv_rec) IS
1519: l_api_version CONSTANT NUMBER := 1;
1520: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1521: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1522: l_ethb_rec okl_ethb_rec;
1523: l_ethtl_rec okl_ethtl_rec;
1524:
1525: BEGIN

Line 1526: l_return_status := okl_api.start_activity(l_api_name

1522: l_ethb_rec okl_ethb_rec;
1523: l_ethtl_rec okl_ethtl_rec;
1524:
1525: BEGIN
1526: l_return_status := okl_api.start_activity(l_api_name
1527: ,g_pkg_name
1528: ,p_init_msg_list
1529: ,l_api_version
1530: ,p_api_version

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

1530: ,p_api_version
1531: ,'_PVT'
1532: ,x_return_status);
1533:
1534: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1535: RAISE okl_api.g_exception_unexpected_error;
1536: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1537: RAISE okl_api.g_exception_error;
1538: END IF;

Line 1535: RAISE okl_api.g_exception_unexpected_error;

1531: ,'_PVT'
1532: ,x_return_status);
1533:
1534: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1535: RAISE okl_api.g_exception_unexpected_error;
1536: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1537: RAISE okl_api.g_exception_error;
1538: END IF;
1539:

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

1532: ,x_return_status);
1533:
1534: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1535: RAISE okl_api.g_exception_unexpected_error;
1536: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1537: RAISE okl_api.g_exception_error;
1538: END IF;
1539:
1540: --------------------------------------

Line 1537: RAISE okl_api.g_exception_error;

1533:
1534: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1535: RAISE okl_api.g_exception_unexpected_error;
1536: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1537: RAISE okl_api.g_exception_error;
1538: END IF;
1539:
1540: --------------------------------------
1541: -- Move VIEW record to "Child" records

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

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

Line 1560: RAISE okl_api.g_exception_unexpected_error;

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

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

1557: ,l_ethb_rec);
1558:
1559: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1560: RAISE okl_api.g_exception_unexpected_error;
1561: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1562: RAISE okl_api.g_exception_error;
1563: END IF;
1564: lock_row(p_init_msg_list
1565: ,x_return_status

Line 1562: RAISE okl_api.g_exception_error;

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

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

1566: ,x_msg_count
1567: ,x_msg_data
1568: ,l_ethtl_rec);
1569:
1570: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1571: RAISE okl_api.g_exception_unexpected_error;
1572: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1573: RAISE okl_api.g_exception_error;
1574: END IF;

Line 1571: RAISE okl_api.g_exception_unexpected_error;

1567: ,x_msg_data
1568: ,l_ethtl_rec);
1569:
1570: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1571: RAISE okl_api.g_exception_unexpected_error;
1572: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1573: RAISE okl_api.g_exception_error;
1574: END IF;
1575: okl_api.end_activity(x_msg_count

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

1568: ,l_ethtl_rec);
1569:
1570: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1571: RAISE okl_api.g_exception_unexpected_error;
1572: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1573: RAISE okl_api.g_exception_error;
1574: END IF;
1575: okl_api.end_activity(x_msg_count
1576: ,x_msg_data);

Line 1573: RAISE okl_api.g_exception_error;

1569:
1570: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1571: RAISE okl_api.g_exception_unexpected_error;
1572: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1573: RAISE okl_api.g_exception_error;
1574: END IF;
1575: okl_api.end_activity(x_msg_count
1576: ,x_msg_data);
1577: EXCEPTION

Line 1575: okl_api.end_activity(x_msg_count

1571: RAISE okl_api.g_exception_unexpected_error;
1572: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
1573: RAISE okl_api.g_exception_error;
1574: END IF;
1575: okl_api.end_activity(x_msg_count
1576: ,x_msg_data);
1577: EXCEPTION
1578: WHEN g_exception_halt_validation THEN
1579: x_return_status := okl_api.handle_exceptions(l_api_name

Line 1579: x_return_status := okl_api.handle_exceptions(l_api_name

1575: okl_api.end_activity(x_msg_count
1576: ,x_msg_data);
1577: EXCEPTION
1578: WHEN g_exception_halt_validation THEN
1579: x_return_status := okl_api.handle_exceptions(l_api_name
1580: ,g_pkg_name
1581: ,'OKL_API.G_RET_STS_ERROR'
1582: ,x_msg_count
1583: ,x_msg_data

Line 1581: ,'OKL_API.G_RET_STS_ERROR'

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

Line 1585: WHEN okl_api.g_exception_error THEN

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

Line 1586: x_return_status := okl_api.handle_exceptions(l_api_name

1582: ,x_msg_count
1583: ,x_msg_data
1584: ,'_PVT');
1585: WHEN okl_api.g_exception_error THEN
1586: x_return_status := okl_api.handle_exceptions(l_api_name
1587: ,g_pkg_name
1588: ,'OKL_API.G_RET_STS_ERROR'
1589: ,x_msg_count
1590: ,x_msg_data

Line 1588: ,'OKL_API.G_RET_STS_ERROR'

1584: ,'_PVT');
1585: WHEN okl_api.g_exception_error THEN
1586: x_return_status := okl_api.handle_exceptions(l_api_name
1587: ,g_pkg_name
1588: ,'OKL_API.G_RET_STS_ERROR'
1589: ,x_msg_count
1590: ,x_msg_data
1591: ,'_PVT');
1592: WHEN okl_api.g_exception_unexpected_error THEN

Line 1592: WHEN okl_api.g_exception_unexpected_error THEN

1588: ,'OKL_API.G_RET_STS_ERROR'
1589: ,x_msg_count
1590: ,x_msg_data
1591: ,'_PVT');
1592: WHEN okl_api.g_exception_unexpected_error THEN
1593: x_return_status := okl_api.handle_exceptions(l_api_name
1594: ,g_pkg_name
1595: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1596: ,x_msg_count

Line 1593: x_return_status := okl_api.handle_exceptions(l_api_name

1589: ,x_msg_count
1590: ,x_msg_data
1591: ,'_PVT');
1592: WHEN okl_api.g_exception_unexpected_error THEN
1593: x_return_status := okl_api.handle_exceptions(l_api_name
1594: ,g_pkg_name
1595: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1596: ,x_msg_count
1597: ,x_msg_data

Line 1595: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1591: ,'_PVT');
1592: WHEN okl_api.g_exception_unexpected_error THEN
1593: x_return_status := okl_api.handle_exceptions(l_api_name
1594: ,g_pkg_name
1595: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1596: ,x_msg_count
1597: ,x_msg_data
1598: ,'_PVT');
1599: WHEN OTHERS THEN

Line 1600: x_return_status := okl_api.handle_exceptions(l_api_name

1596: ,x_msg_count
1597: ,x_msg_data
1598: ,'_PVT');
1599: WHEN OTHERS THEN
1600: x_return_status := okl_api.handle_exceptions(l_api_name
1601: ,g_pkg_name
1602: ,'OTHERS'
1603: ,x_msg_count
1604: ,x_msg_data

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

1616: ,x_msg_data OUT NOCOPY VARCHAR2
1617: ,p_ethv_tbl IN okl_ethv_tbl) IS
1618: l_api_version CONSTANT NUMBER := 1;
1619: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1620: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1621:
1622: -- Begin Post-Generation Change
1623: -- overall error status
1624:

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

1621:
1622: -- Begin Post-Generation Change
1623: -- overall error status
1624:
1625: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1626:
1627: -- End Post-Generation Change
1628:
1629: i NUMBER := 0;

Line 1632: okl_api.init_msg_list(p_init_msg_list);

1628:
1629: i NUMBER := 0;
1630:
1631: BEGIN
1632: okl_api.init_msg_list(p_init_msg_list);
1633:
1634: -- Make sure PL/SQL table has records in it before passing
1635:
1636: IF (p_ethv_tbl.COUNT > 0) THEN

Line 1641: ,p_init_msg_list => okl_api.g_false

1637: i := p_ethv_tbl.FIRST;
1638:
1639: LOOP
1640: lock_row(p_api_version => p_api_version
1641: ,p_init_msg_list => okl_api.g_false
1642: ,x_return_status => x_return_status
1643: ,x_msg_count => x_msg_count
1644: ,x_msg_data => x_msg_data
1645: ,p_ethv_rec => p_ethv_tbl(i));

Line 1650: IF x_return_status <> okl_api.g_ret_sts_success THEN

1646:
1647: -- Begin Post-Generation Change
1648: -- store the highest degree of error
1649:
1650: IF x_return_status <> okl_api.g_ret_sts_success THEN
1651: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
1652: l_overall_status := x_return_status;
1653: END IF;
1654: END IF;

Line 1651: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN

1647: -- Begin Post-Generation Change
1648: -- store the highest degree of error
1649:
1650: IF x_return_status <> okl_api.g_ret_sts_success THEN
1651: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
1652: l_overall_status := x_return_status;
1653: END IF;
1654: END IF;
1655:

Line 1673: x_return_status := okl_api.handle_exceptions(l_api_name

1669: END IF;
1670:
1671: EXCEPTION
1672: WHEN g_exception_halt_validation THEN
1673: x_return_status := okl_api.handle_exceptions(l_api_name
1674: ,g_pkg_name
1675: ,'OKL_API.G_RET_STS_ERROR'
1676: ,x_msg_count
1677: ,x_msg_data

Line 1675: ,'OKL_API.G_RET_STS_ERROR'

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

Line 1679: WHEN okl_api.g_exception_error THEN

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

Line 1680: x_return_status := okl_api.handle_exceptions(l_api_name

1676: ,x_msg_count
1677: ,x_msg_data
1678: ,'_PVT');
1679: WHEN okl_api.g_exception_error THEN
1680: x_return_status := okl_api.handle_exceptions(l_api_name
1681: ,g_pkg_name
1682: ,'OKL_API.G_RET_STS_ERROR'
1683: ,x_msg_count
1684: ,x_msg_data

Line 1682: ,'OKL_API.G_RET_STS_ERROR'

1678: ,'_PVT');
1679: WHEN okl_api.g_exception_error THEN
1680: x_return_status := okl_api.handle_exceptions(l_api_name
1681: ,g_pkg_name
1682: ,'OKL_API.G_RET_STS_ERROR'
1683: ,x_msg_count
1684: ,x_msg_data
1685: ,'_PVT');
1686: WHEN okl_api.g_exception_unexpected_error THEN

Line 1686: WHEN okl_api.g_exception_unexpected_error THEN

1682: ,'OKL_API.G_RET_STS_ERROR'
1683: ,x_msg_count
1684: ,x_msg_data
1685: ,'_PVT');
1686: WHEN okl_api.g_exception_unexpected_error THEN
1687: x_return_status := okl_api.handle_exceptions(l_api_name
1688: ,g_pkg_name
1689: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1690: ,x_msg_count

Line 1687: x_return_status := okl_api.handle_exceptions(l_api_name

1683: ,x_msg_count
1684: ,x_msg_data
1685: ,'_PVT');
1686: WHEN okl_api.g_exception_unexpected_error THEN
1687: x_return_status := okl_api.handle_exceptions(l_api_name
1688: ,g_pkg_name
1689: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1690: ,x_msg_count
1691: ,x_msg_data

Line 1689: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1685: ,'_PVT');
1686: WHEN okl_api.g_exception_unexpected_error THEN
1687: x_return_status := okl_api.handle_exceptions(l_api_name
1688: ,g_pkg_name
1689: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1690: ,x_msg_count
1691: ,x_msg_data
1692: ,'_PVT');
1693: WHEN OTHERS THEN

Line 1694: x_return_status := okl_api.handle_exceptions(l_api_name

1690: ,x_msg_count
1691: ,x_msg_data
1692: ,'_PVT');
1693: WHEN OTHERS THEN
1694: x_return_status := okl_api.handle_exceptions(l_api_name
1695: ,g_pkg_name
1696: ,'OTHERS'
1697: ,x_msg_count
1698: ,x_msg_data

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

1711: ,p_ethb_rec IN okl_ethb_rec
1712: ,x_ethb_rec OUT NOCOPY okl_ethb_rec) IS
1713: l_api_version CONSTANT NUMBER := 1;
1714: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1715: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1716: l_ethb_rec okl_ethb_rec := p_ethb_rec;
1717:
1718: FUNCTION set_attributes(p_ethb_rec IN okl_ethb_rec
1719: ,x_ethb_rec OUT NOCOPY okl_ethb_rec) RETURN VARCHAR2 IS

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

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

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

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

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

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

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

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

Line 1833: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 1835: ,'OKL_API.G_RET_STS_ERROR'

1831: NULL;
1832: WHEN okc_api.g_exception_error THEN
1833: x_return_status := okl_api.handle_exceptions(l_api_name
1834: ,g_pkg_name
1835: ,'OKL_API.G_RET_STS_ERROR'
1836: ,x_msg_count
1837: ,x_msg_data
1838: ,'_PVT');
1839: WHEN okc_api.g_exception_unexpected_error THEN

Line 1840: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 1842: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1838: ,'_PVT');
1839: WHEN okc_api.g_exception_unexpected_error THEN
1840: x_return_status := okl_api.handle_exceptions(l_api_name
1841: ,g_pkg_name
1842: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1843: ,x_msg_count
1844: ,x_msg_data
1845: ,'_PVT');
1846: WHEN OTHERS THEN

Line 1847: x_return_status := okl_api.handle_exceptions(l_api_name

1843: ,x_msg_count
1844: ,x_msg_data
1845: ,'_PVT');
1846: WHEN OTHERS THEN
1847: x_return_status := okl_api.handle_exceptions(l_api_name
1848: ,g_pkg_name
1849: ,'OTHERS'
1850: ,x_msg_count
1851: ,x_msg_data

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

1864: ,p_ethtl_rec IN okl_ethtl_rec
1865: ,x_ethtl_rec OUT NOCOPY okl_ethtl_rec) IS
1866: l_api_version CONSTANT NUMBER := 1;
1867: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1868: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1869: l_ethtl_rec okl_ethtl_rec := p_ethtl_rec;
1870:
1871: CURSOR get_languages IS
1872: SELECT *

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

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

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

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

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

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

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

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

Line 1953: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 1955: ,'OKL_API.G_RET_STS_ERROR'

1951: NULL;
1952: WHEN okc_api.g_exception_error THEN
1953: x_return_status := okl_api.handle_exceptions(l_api_name
1954: ,g_pkg_name
1955: ,'OKL_API.G_RET_STS_ERROR'
1956: ,x_msg_count
1957: ,x_msg_data
1958: ,'_PVT');
1959: WHEN okc_api.g_exception_unexpected_error THEN

Line 1960: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 1962: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1958: ,'_PVT');
1959: WHEN okc_api.g_exception_unexpected_error THEN
1960: x_return_status := okl_api.handle_exceptions(l_api_name
1961: ,g_pkg_name
1962: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1963: ,x_msg_count
1964: ,x_msg_data
1965: ,'_PVT');
1966: WHEN OTHERS THEN

Line 1967: x_return_status := okl_api.handle_exceptions(l_api_name

1963: ,x_msg_count
1964: ,x_msg_data
1965: ,'_PVT');
1966: WHEN OTHERS THEN
1967: x_return_status := okl_api.handle_exceptions(l_api_name
1968: ,g_pkg_name
1969: ,'OTHERS'
1970: ,x_msg_count
1971: ,x_msg_data

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

1984: ,p_ethv_rec IN okl_ethv_rec
1985: ,x_ethv_rec OUT NOCOPY okl_ethv_rec) IS
1986: l_api_version CONSTANT NUMBER := 1;
1987: l_api_name CONSTANT VARCHAR2(30) := 'v_insert_row';
1988: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1989: l_ethv_rec okl_ethv_rec;
1990: l_def_ethv_rec okl_ethv_rec;
1991: l_ethb_rec okl_ethb_rec;
1992: lx_ethb_rec okl_ethb_rec;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2111: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2113: ,'OKL_API.G_RET_STS_ERROR'

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

Line 2118: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2120: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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

Line 2125: x_return_status := okl_api.handle_exceptions(l_api_name

2121: ,x_msg_count
2122: ,x_msg_data
2123: ,'_PVT');
2124: WHEN OTHERS THEN
2125: x_return_status := okl_api.handle_exceptions(l_api_name
2126: ,g_pkg_name
2127: ,'OTHERS'
2128: ,x_msg_count
2129: ,x_msg_data

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

2142: ,p_ethv_tbl IN okl_ethv_tbl
2143: ,x_ethv_tbl OUT NOCOPY okl_ethv_tbl) IS
2144: l_api_version CONSTANT NUMBER := 1;
2145: l_api_name CONSTANT VARCHAR2(30) := 'v_insert_row';
2146: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2147: i NUMBER := 0;
2148: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2149:
2150: BEGIN

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

2144: l_api_version CONSTANT NUMBER := 1;
2145: l_api_name CONSTANT VARCHAR2(30) := 'v_insert_row';
2146: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2147: i NUMBER := 0;
2148: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2149:
2150: BEGIN
2151: okc_api.init_msg_list(p_init_msg_list);
2152:

Line 2184: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2186: ,'OKL_API.G_RET_STS_ERROR'

2182: NULL;
2183: WHEN okc_api.g_exception_error THEN
2184: x_return_status := okl_api.handle_exceptions(l_api_name
2185: ,g_pkg_name
2186: ,'OKL_API.G_RET_STS_ERROR'
2187: ,x_msg_count
2188: ,x_msg_data
2189: ,'_PVT');
2190: WHEN okc_api.g_exception_unexpected_error THEN

Line 2191: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2193: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2189: ,'_PVT');
2190: WHEN okc_api.g_exception_unexpected_error THEN
2191: x_return_status := okl_api.handle_exceptions(l_api_name
2192: ,g_pkg_name
2193: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2194: ,x_msg_count
2195: ,x_msg_data
2196: ,'_PVT');
2197: WHEN OTHERS THEN

Line 2198: x_return_status := okl_api.handle_exceptions(l_api_name

2194: ,x_msg_count
2195: ,x_msg_data
2196: ,'_PVT');
2197: WHEN OTHERS THEN
2198: x_return_status := okl_api.handle_exceptions(l_api_name
2199: ,g_pkg_name
2200: ,'OTHERS'
2201: ,x_msg_count
2202: ,x_msg_data

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

2215: ,p_ethb_rec IN okl_ethb_rec
2216: ,x_ethb_rec OUT NOCOPY okl_ethb_rec) IS
2217: l_api_version CONSTANT NUMBER := 1;
2218: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2219: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2220: l_ethb_rec okl_ethb_rec := p_ethb_rec;
2221: l_def_ethb_rec okl_ethb_rec;
2222: l_row_notfound BOOLEAN := true;
2223:

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

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

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

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

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

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

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

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

Line 2307: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2309: ,'OKL_API.G_RET_STS_ERROR'

2305: NULL;
2306: WHEN okc_api.g_exception_error THEN
2307: x_return_status := okl_api.handle_exceptions(l_api_name
2308: ,g_pkg_name
2309: ,'OKL_API.G_RET_STS_ERROR'
2310: ,x_msg_count
2311: ,x_msg_data
2312: ,'_PVT');
2313: WHEN okc_api.g_exception_unexpected_error THEN

Line 2314: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2316: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2312: ,'_PVT');
2313: WHEN okc_api.g_exception_unexpected_error THEN
2314: x_return_status := okl_api.handle_exceptions(l_api_name
2315: ,g_pkg_name
2316: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2317: ,x_msg_count
2318: ,x_msg_data
2319: ,'_PVT');
2320: WHEN OTHERS THEN

Line 2321: x_return_status := okl_api.handle_exceptions(l_api_name

2317: ,x_msg_count
2318: ,x_msg_data
2319: ,'_PVT');
2320: WHEN OTHERS THEN
2321: x_return_status := okl_api.handle_exceptions(l_api_name
2322: ,g_pkg_name
2323: ,'OTHERS'
2324: ,x_msg_count
2325: ,x_msg_data

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

2338: ,p_ethtl_rec IN okl_ethtl_rec
2339: ,x_ethtl_rec OUT NOCOPY okl_ethtl_rec) IS
2340: l_api_version CONSTANT NUMBER := 1;
2341: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2342: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2343: l_ethtl_rec okl_ethtl_rec := p_ethtl_rec;
2344: l_def_ethtl_rec okl_ethtl_rec;
2345: l_row_notfound BOOLEAN := true;
2346:

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

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

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

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

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

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

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

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

Line 2415: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2417: ,'OKL_API.G_RET_STS_ERROR'

2413: NULL;
2414: WHEN okc_api.g_exception_error THEN
2415: x_return_status := okl_api.handle_exceptions(l_api_name
2416: ,g_pkg_name
2417: ,'OKL_API.G_RET_STS_ERROR'
2418: ,x_msg_count
2419: ,x_msg_data
2420: ,'_PVT');
2421: WHEN okc_api.g_exception_unexpected_error THEN

Line 2422: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2424: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2420: ,'_PVT');
2421: WHEN okc_api.g_exception_unexpected_error THEN
2422: x_return_status := okl_api.handle_exceptions(l_api_name
2423: ,g_pkg_name
2424: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2425: ,x_msg_count
2426: ,x_msg_data
2427: ,'_PVT');
2428: WHEN OTHERS THEN

Line 2429: x_return_status := okl_api.handle_exceptions(l_api_name

2425: ,x_msg_count
2426: ,x_msg_data
2427: ,'_PVT');
2428: WHEN OTHERS THEN
2429: x_return_status := okl_api.handle_exceptions(l_api_name
2430: ,g_pkg_name
2431: ,'OTHERS'
2432: ,x_msg_count
2433: ,x_msg_data

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

2446: ,p_ethv_rec IN okl_ethv_rec
2447: ,x_ethv_rec OUT NOCOPY okl_ethv_rec) IS
2448: l_api_version CONSTANT NUMBER := 1;
2449: l_api_name CONSTANT VARCHAR2(30) := 'v_insert_row';
2450: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2451: l_ethv_rec okl_ethv_rec := p_ethv_rec;
2452: l_def_ethv_rec okl_ethv_rec;
2453: lx_ethv_rec okl_ethv_rec;
2454: l_ethb_rec okl_ethb_rec;

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

2469: FUNCTION populate_new_record(p_ethv_rec IN okl_ethv_rec
2470: ,x_ethv_rec OUT NOCOPY okl_ethv_rec) RETURN VARCHAR2 IS
2471: l_ethv_rec okl_ethv_rec;
2472: l_row_notfound BOOLEAN := true;
2473: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2474:
2475: BEGIN
2476: x_ethv_rec := p_ethv_rec;
2477:

Line 2484: l_return_status := okl_api.g_ret_sts_unexp_error;

2480: l_ethv_rec := get_rec(p_ethv_rec
2481: ,l_row_notfound);
2482:
2483: IF (l_row_notfound) THEN
2484: l_return_status := okl_api.g_ret_sts_unexp_error;
2485: END IF;
2486:
2487: IF (x_ethv_rec.end_of_term_id IS NULL) THEN
2488: x_ethv_rec.end_of_term_id := l_ethv_rec.end_of_term_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2687: ,p_init_msg_list => okl_api.g_false

2683:
2684: --lock the row
2685:
2686: lock_row(p_api_version => l_api_version
2687: ,p_init_msg_list => okl_api.g_false
2688: ,x_return_status => l_return_status
2689: ,x_msg_count => x_msg_count
2690: ,x_msg_data => x_msg_data
2691: ,p_ethv_rec => l_def_ethv_rec);

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

2689: ,x_msg_count => x_msg_count
2690: ,x_msg_data => x_msg_data
2691: ,p_ethv_rec => l_def_ethv_rec);
2692:
2693: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2694: RAISE okl_api.g_exception_unexpected_error;
2695: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2696: RAISE okl_api.g_exception_error;
2697: END IF;

Line 2694: RAISE okl_api.g_exception_unexpected_error;

2690: ,x_msg_data => x_msg_data
2691: ,p_ethv_rec => l_def_ethv_rec);
2692:
2693: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2694: RAISE okl_api.g_exception_unexpected_error;
2695: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2696: RAISE okl_api.g_exception_error;
2697: END IF;
2698: migrate(l_def_ethv_rec

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

2691: ,p_ethv_rec => l_def_ethv_rec);
2692:
2693: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2694: RAISE okl_api.g_exception_unexpected_error;
2695: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2696: RAISE okl_api.g_exception_error;
2697: END IF;
2698: migrate(l_def_ethv_rec
2699: ,l_ethb_rec);

Line 2696: RAISE okl_api.g_exception_error;

2692:
2693: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2694: RAISE okl_api.g_exception_unexpected_error;
2695: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2696: RAISE okl_api.g_exception_error;
2697: END IF;
2698: migrate(l_def_ethv_rec
2699: ,l_ethb_rec);
2700: migrate(l_def_ethv_rec

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

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

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

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

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

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

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

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

Line 2745: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2747: ,'OKL_API.G_RET_STS_ERROR'

2743: NULL;
2744: WHEN okc_api.g_exception_error THEN
2745: x_return_status := okl_api.handle_exceptions(l_api_name
2746: ,g_pkg_name
2747: ,'OKL_API.G_RET_STS_ERROR'
2748: ,x_msg_count
2749: ,x_msg_data
2750: ,'_PVT');
2751: WHEN okc_api.g_exception_unexpected_error THEN

Line 2752: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2754: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2750: ,'_PVT');
2751: WHEN okc_api.g_exception_unexpected_error THEN
2752: x_return_status := okl_api.handle_exceptions(l_api_name
2753: ,g_pkg_name
2754: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2755: ,x_msg_count
2756: ,x_msg_data
2757: ,'_PVT');
2758: WHEN OTHERS THEN

Line 2759: x_return_status := okl_api.handle_exceptions(l_api_name

2755: ,x_msg_count
2756: ,x_msg_data
2757: ,'_PVT');
2758: WHEN OTHERS THEN
2759: x_return_status := okl_api.handle_exceptions(l_api_name
2760: ,g_pkg_name
2761: ,'OTHERS'
2762: ,x_msg_count
2763: ,x_msg_data

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

2776: ,p_ethv_tbl IN okl_ethv_tbl
2777: ,x_ethv_tbl OUT NOCOPY okl_ethv_tbl) IS
2778: l_api_version CONSTANT NUMBER := 1;
2779: l_api_name CONSTANT VARCHAR2(30) := 'v_update_row';
2780: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2781: i NUMBER := 0;
2782: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2783:
2784: BEGIN

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

2778: l_api_version CONSTANT NUMBER := 1;
2779: l_api_name CONSTANT VARCHAR2(30) := 'v_update_row';
2780: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2781: i NUMBER := 0;
2782: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2783:
2784: BEGIN
2785: okc_api.init_msg_list(p_init_msg_list);
2786:

Line 2818: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2820: ,'OKL_API.G_RET_STS_ERROR'

2816: NULL;
2817: WHEN okc_api.g_exception_error THEN
2818: x_return_status := okl_api.handle_exceptions(l_api_name
2819: ,g_pkg_name
2820: ,'OKL_API.G_RET_STS_ERROR'
2821: ,x_msg_count
2822: ,x_msg_data
2823: ,'_PVT');
2824: WHEN okc_api.g_exception_unexpected_error THEN

Line 2825: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2827: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2823: ,'_PVT');
2824: WHEN okc_api.g_exception_unexpected_error THEN
2825: x_return_status := okl_api.handle_exceptions(l_api_name
2826: ,g_pkg_name
2827: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2828: ,x_msg_count
2829: ,x_msg_data
2830: ,'_PVT');
2831: WHEN OTHERS THEN

Line 2832: x_return_status := okl_api.handle_exceptions(l_api_name

2828: ,x_msg_count
2829: ,x_msg_data
2830: ,'_PVT');
2831: WHEN OTHERS THEN
2832: x_return_status := okl_api.handle_exceptions(l_api_name
2833: ,g_pkg_name
2834: ,'OTHERS'
2835: ,x_msg_count
2836: ,x_msg_data

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

2848: ,x_msg_data OUT NOCOPY VARCHAR2
2849: ,p_ethb_rec IN okl_ethb_rec) IS
2850: l_api_version CONSTANT NUMBER := 1;
2851: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
2852: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2853: l_ethb_rec okl_ethb_rec := p_ethb_rec;
2854: l_row_notfound BOOLEAN := true;
2855:
2856: BEGIN

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

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

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

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

Line 2881: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2883: ,'OKL_API.G_RET_STS_ERROR'

2879: NULL;
2880: WHEN okc_api.g_exception_error THEN
2881: x_return_status := okl_api.handle_exceptions(l_api_name
2882: ,g_pkg_name
2883: ,'OKL_API.G_RET_STS_ERROR'
2884: ,x_msg_count
2885: ,x_msg_data
2886: ,'_PVT');
2887: WHEN okc_api.g_exception_unexpected_error THEN

Line 2888: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2890: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2886: ,'_PVT');
2887: WHEN okc_api.g_exception_unexpected_error THEN
2888: x_return_status := okl_api.handle_exceptions(l_api_name
2889: ,g_pkg_name
2890: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2891: ,x_msg_count
2892: ,x_msg_data
2893: ,'_PVT');
2894: WHEN OTHERS THEN

Line 2895: x_return_status := okl_api.handle_exceptions(l_api_name

2891: ,x_msg_count
2892: ,x_msg_data
2893: ,'_PVT');
2894: WHEN OTHERS THEN
2895: x_return_status := okl_api.handle_exceptions(l_api_name
2896: ,g_pkg_name
2897: ,'OTHERS'
2898: ,x_msg_count
2899: ,x_msg_data

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

2911: ,x_msg_data OUT NOCOPY VARCHAR2
2912: ,p_ethtl_rec IN okl_ethtl_rec) IS
2913: l_api_version CONSTANT NUMBER := 1;
2914: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
2915: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2916: l_ethtl_rec okl_ethtl_rec := p_ethtl_rec;
2917: l_row_notfound BOOLEAN := true;
2918:
2919: FUNCTION set_attributes(p_ethtl_rec IN okl_ethtl_rec

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

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

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

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

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

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

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

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

Line 2966: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2968: ,'OKL_API.G_RET_STS_ERROR'

2964: NULL;
2965: WHEN okc_api.g_exception_error THEN
2966: x_return_status := okl_api.handle_exceptions(l_api_name
2967: ,g_pkg_name
2968: ,'OKL_API.G_RET_STS_ERROR'
2969: ,x_msg_count
2970: ,x_msg_data
2971: ,'_PVT');
2972: WHEN okc_api.g_exception_unexpected_error THEN

Line 2973: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 2975: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2971: ,'_PVT');
2972: WHEN okc_api.g_exception_unexpected_error THEN
2973: x_return_status := okl_api.handle_exceptions(l_api_name
2974: ,g_pkg_name
2975: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2976: ,x_msg_count
2977: ,x_msg_data
2978: ,'_PVT');
2979: WHEN OTHERS THEN

Line 2980: x_return_status := okl_api.handle_exceptions(l_api_name

2976: ,x_msg_count
2977: ,x_msg_data
2978: ,'_PVT');
2979: WHEN OTHERS THEN
2980: x_return_status := okl_api.handle_exceptions(l_api_name
2981: ,g_pkg_name
2982: ,'OTHERS'
2983: ,x_msg_count
2984: ,x_msg_data

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

2996: ,x_msg_data OUT NOCOPY VARCHAR2
2997: ,p_ethv_rec IN okl_ethv_rec) IS
2998: l_api_version CONSTANT NUMBER := 1;
2999: l_api_name CONSTANT VARCHAR2(30) := 'v_delete_row';
3000: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
3001: l_ethv_rec okl_ethv_rec := p_ethv_rec;
3002: l_ethb_rec okl_ethb_rec;
3003: l_ethtl_rec okl_ethtl_rec;
3004:

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

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

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

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

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

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

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

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

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

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

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

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

Line 3056: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 3058: ,'OKL_API.G_RET_STS_ERROR'

3054: NULL;
3055: WHEN okc_api.g_exception_error THEN
3056: x_return_status := okl_api.handle_exceptions(l_api_name
3057: ,g_pkg_name
3058: ,'OKL_API.G_RET_STS_ERROR'
3059: ,x_msg_count
3060: ,x_msg_data
3061: ,'_PVT');
3062: WHEN okc_api.g_exception_unexpected_error THEN

Line 3063: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 3065: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

3061: ,'_PVT');
3062: WHEN okc_api.g_exception_unexpected_error THEN
3063: x_return_status := okl_api.handle_exceptions(l_api_name
3064: ,g_pkg_name
3065: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
3066: ,x_msg_count
3067: ,x_msg_data
3068: ,'_PVT');
3069: WHEN OTHERS THEN

Line 3070: x_return_status := okl_api.handle_exceptions(l_api_name

3066: ,x_msg_count
3067: ,x_msg_data
3068: ,'_PVT');
3069: WHEN OTHERS THEN
3070: x_return_status := okl_api.handle_exceptions(l_api_name
3071: ,g_pkg_name
3072: ,'OTHERS'
3073: ,x_msg_count
3074: ,x_msg_data

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

3086: ,x_msg_data OUT NOCOPY VARCHAR2
3087: ,p_ethv_tbl IN okl_ethv_tbl) IS
3088: l_api_version CONSTANT NUMBER := 1;
3089: l_api_name CONSTANT VARCHAR2(30) := 'v_delete_row';
3090: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
3091: i NUMBER := 0;
3092: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
3093:
3094: BEGIN

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

3088: l_api_version CONSTANT NUMBER := 1;
3089: l_api_name CONSTANT VARCHAR2(30) := 'v_delete_row';
3090: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
3091: i NUMBER := 0;
3092: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
3093:
3094: BEGIN
3095: okc_api.init_msg_list(p_init_msg_list);
3096:

Line 3127: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 3129: ,'OKL_API.G_RET_STS_ERROR'

3125: NULL;
3126: WHEN okc_api.g_exception_error THEN
3127: x_return_status := okl_api.handle_exceptions(l_api_name
3128: ,g_pkg_name
3129: ,'OKL_API.G_RET_STS_ERROR'
3130: ,x_msg_count
3131: ,x_msg_data
3132: ,'_PVT');
3133: WHEN okc_api.g_exception_unexpected_error THEN

Line 3134: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 3136: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

3132: ,'_PVT');
3133: WHEN okc_api.g_exception_unexpected_error THEN
3134: x_return_status := okl_api.handle_exceptions(l_api_name
3135: ,g_pkg_name
3136: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
3137: ,x_msg_count
3138: ,x_msg_data
3139: ,'_PVT');
3140: WHEN OTHERS THEN

Line 3141: x_return_status := okl_api.handle_exceptions(l_api_name

3137: ,x_msg_count
3138: ,x_msg_data
3139: ,'_PVT');
3140: WHEN OTHERS THEN
3141: x_return_status := okl_api.handle_exceptions(l_api_name
3142: ,g_pkg_name
3143: ,'OTHERS'
3144: ,x_msg_count
3145: ,x_msg_data