eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ETV_PVT dependencies on OKL_API

Line 26: x_return_status := okl_api.g_ret_sts_success; -- END_OF_TERM_VALUE_ID is a required field

22: PROCEDURE validate_end_of_term_value_id(x_return_status OUT NOCOPY VARCHAR2
23: ,p_etv_rec IN okl_etv_rec) IS
24:
25: BEGIN -- initialize the return status
26: x_return_status := okl_api.g_ret_sts_success; -- END_OF_TERM_VALUE_ID is a required field
27:
28: IF (p_etv_rec.end_of_term_value_id IS NULL OR p_etv_rec.end_of_term_value_id = okl_api.g_miss_num) THEN
29: okl_api.set_message(p_app_name => g_app_name
30: ,p_msg_name => g_required_value

Line 28: IF (p_etv_rec.end_of_term_value_id IS NULL OR p_etv_rec.end_of_term_value_id = okl_api.g_miss_num) THEN

24:
25: BEGIN -- initialize the return status
26: x_return_status := okl_api.g_ret_sts_success; -- END_OF_TERM_VALUE_ID is a required field
27:
28: IF (p_etv_rec.end_of_term_value_id IS NULL OR p_etv_rec.end_of_term_value_id = okl_api.g_miss_num) THEN
29: okl_api.set_message(p_app_name => g_app_name
30: ,p_msg_name => g_required_value
31: ,p_token1 => g_col_name_token
32: ,p_token1_value => 'END_OF_TERM_VALUE_ID'); -- notify caller of an error

Line 29: okl_api.set_message(p_app_name => g_app_name

25: BEGIN -- initialize the return status
26: x_return_status := okl_api.g_ret_sts_success; -- END_OF_TERM_VALUE_ID is a required field
27:
28: IF (p_etv_rec.end_of_term_value_id IS NULL OR p_etv_rec.end_of_term_value_id = okl_api.g_miss_num) THEN
29: okl_api.set_message(p_app_name => g_app_name
30: ,p_msg_name => g_required_value
31: ,p_token1 => g_col_name_token
32: ,p_token1_value => 'END_OF_TERM_VALUE_ID'); -- notify caller of an error
33: x_return_status := okl_api.g_ret_sts_error; -- halt further validation of this column

Line 33: x_return_status := okl_api.g_ret_sts_error; -- halt further validation of this column

29: okl_api.set_message(p_app_name => g_app_name
30: ,p_msg_name => g_required_value
31: ,p_token1 => g_col_name_token
32: ,p_token1_value => 'END_OF_TERM_VALUE_ID'); -- notify caller of an error
33: x_return_status := okl_api.g_ret_sts_error; -- halt further validation of this column
34: RAISE g_exception_halt_validation;
35: END IF;
36:
37: EXCEPTION

Line 41: okl_api.set_message(p_app_name => g_app_name

37: EXCEPTION
38: WHEN g_exception_halt_validation THEN -- no proccessing required. Validation can continue with the next column
39: NULL;
40: WHEN OTHERS THEN -- store SQL error message on message stack for caller
41: okl_api.set_message(p_app_name => g_app_name
42: ,p_msg_name => g_unexpected_error
43: ,p_token1 => g_sqlcode_token
44: ,p_token1_value => sqlcode
45: ,p_token2 => g_sqlerrm_token

Line 47: x_return_status := okl_api.g_ret_sts_unexp_error;

43: ,p_token1 => g_sqlcode_token
44: ,p_token1_value => sqlcode
45: ,p_token2 => g_sqlerrm_token
46: ,p_token2_value => sqlerrm); -- notify caller of an UNEXPECTED error
47: x_return_status := okl_api.g_ret_sts_unexp_error;
48: END validate_end_of_term_value_id;
49:
50: PROCEDURE validate_eot_term(x_return_status OUT NOCOPY VARCHAR2
51: ,p_etv_rec IN okl_etv_rec) IS

Line 54: x_return_status := okl_api.g_ret_sts_success; -- term is a required field

50: PROCEDURE validate_eot_term(x_return_status OUT NOCOPY VARCHAR2
51: ,p_etv_rec IN okl_etv_rec) IS
52:
53: BEGIN -- initialize the return status
54: x_return_status := okl_api.g_ret_sts_success; -- term is a required field
55:
56: IF (p_etv_rec.eot_term IS NULL OR p_etv_rec.eot_term = okl_api.g_miss_num) THEN
57: okl_api.set_message(p_app_name => g_app_name
58: ,p_msg_name => g_required_value

Line 56: IF (p_etv_rec.eot_term IS NULL OR p_etv_rec.eot_term = okl_api.g_miss_num) THEN

52:
53: BEGIN -- initialize the return status
54: x_return_status := okl_api.g_ret_sts_success; -- term is a required field
55:
56: IF (p_etv_rec.eot_term IS NULL OR p_etv_rec.eot_term = okl_api.g_miss_num) THEN
57: okl_api.set_message(p_app_name => g_app_name
58: ,p_msg_name => g_required_value
59: ,p_token1 => g_col_name_token
60: ,p_token1_value => 'eot_term'); -- notify caller of an error

Line 57: okl_api.set_message(p_app_name => g_app_name

53: BEGIN -- initialize the return status
54: x_return_status := okl_api.g_ret_sts_success; -- term is a required field
55:
56: IF (p_etv_rec.eot_term IS NULL OR p_etv_rec.eot_term = okl_api.g_miss_num) THEN
57: okl_api.set_message(p_app_name => g_app_name
58: ,p_msg_name => g_required_value
59: ,p_token1 => g_col_name_token
60: ,p_token1_value => 'eot_term'); -- notify caller of an error
61: x_return_status := okl_api.g_ret_sts_error; -- halt further validation of this column

Line 61: x_return_status := okl_api.g_ret_sts_error; -- halt further validation of this column

57: okl_api.set_message(p_app_name => g_app_name
58: ,p_msg_name => g_required_value
59: ,p_token1 => g_col_name_token
60: ,p_token1_value => 'eot_term'); -- notify caller of an error
61: x_return_status := okl_api.g_ret_sts_error; -- halt further validation of this column
62: RAISE g_exception_halt_validation;
63: END IF;
64:
65: EXCEPTION

Line 69: okl_api.set_message(p_app_name => g_app_name

65: EXCEPTION
66: WHEN g_exception_halt_validation THEN -- no proccessing required. Validation can continue with the next column
67: NULL;
68: WHEN OTHERS THEN -- store SQL error message on message stack for caller
69: okl_api.set_message(p_app_name => g_app_name
70: ,p_msg_name => g_unexpected_error
71: ,p_token1 => g_sqlcode_token
72: ,p_token1_value => sqlcode
73: ,p_token2 => g_sqlerrm_token

Line 75: x_return_status := okl_api.g_ret_sts_unexp_error;

71: ,p_token1 => g_sqlcode_token
72: ,p_token1_value => sqlcode
73: ,p_token2 => g_sqlerrm_token
74: ,p_token2_value => sqlerrm); -- notify caller of an UNEXPECTED error
75: x_return_status := okl_api.g_ret_sts_unexp_error;
76: END validate_eot_term;
77:
78: PROCEDURE validate_eot_value(x_return_status OUT NOCOPY VARCHAR2
79: ,p_etv_rec IN okl_etv_rec) IS

Line 82: x_return_status := okl_api.g_ret_sts_success; -- value is a required field

78: PROCEDURE validate_eot_value(x_return_status OUT NOCOPY VARCHAR2
79: ,p_etv_rec IN okl_etv_rec) IS
80:
81: BEGIN -- initialize the return status
82: x_return_status := okl_api.g_ret_sts_success; -- value is a required field
83:
84: IF (p_etv_rec.eot_value IS NULL OR p_etv_rec.eot_value = okl_api.g_miss_num) THEN
85: okl_api.set_message(p_app_name => g_app_name
86: ,p_msg_name => g_required_value

Line 84: IF (p_etv_rec.eot_value IS NULL OR p_etv_rec.eot_value = okl_api.g_miss_num) THEN

80:
81: BEGIN -- initialize the return status
82: x_return_status := okl_api.g_ret_sts_success; -- value is a required field
83:
84: IF (p_etv_rec.eot_value IS NULL OR p_etv_rec.eot_value = okl_api.g_miss_num) THEN
85: okl_api.set_message(p_app_name => g_app_name
86: ,p_msg_name => g_required_value
87: ,p_token1 => g_col_name_token
88: ,p_token1_value => 'eot_value'); -- notify caller of an error

Line 85: okl_api.set_message(p_app_name => g_app_name

81: BEGIN -- initialize the return status
82: x_return_status := okl_api.g_ret_sts_success; -- value is a required field
83:
84: IF (p_etv_rec.eot_value IS NULL OR p_etv_rec.eot_value = okl_api.g_miss_num) THEN
85: okl_api.set_message(p_app_name => g_app_name
86: ,p_msg_name => g_required_value
87: ,p_token1 => g_col_name_token
88: ,p_token1_value => 'eot_value'); -- notify caller of an error
89: x_return_status := okl_api.g_ret_sts_error; -- halt further validation of this column

Line 89: x_return_status := okl_api.g_ret_sts_error; -- halt further validation of this column

85: okl_api.set_message(p_app_name => g_app_name
86: ,p_msg_name => g_required_value
87: ,p_token1 => g_col_name_token
88: ,p_token1_value => 'eot_value'); -- notify caller of an error
89: x_return_status := okl_api.g_ret_sts_error; -- halt further validation of this column
90: RAISE g_exception_halt_validation;
91: END IF;
92:
93: EXCEPTION

Line 97: okl_api.set_message(p_app_name => g_app_name

93: EXCEPTION
94: WHEN g_exception_halt_validation THEN -- no proccessing required. Validation can continue with the next column
95: NULL;
96: WHEN OTHERS THEN -- store SQL error message on message stack for caller
97: okl_api.set_message(p_app_name => g_app_name
98: ,p_msg_name => g_unexpected_error
99: ,p_token1 => g_sqlcode_token
100: ,p_token1_value => sqlcode
101: ,p_token2 => g_sqlerrm_token

Line 103: x_return_status := okl_api.g_ret_sts_unexp_error;

99: ,p_token1 => g_sqlcode_token
100: ,p_token1_value => sqlcode
101: ,p_token2 => g_sqlerrm_token
102: ,p_token2_value => sqlerrm); -- notify caller of an UNEXPECTED error
103: x_return_status := okl_api.g_ret_sts_unexp_error;
104: END validate_eot_value;
105:
106: PROCEDURE validate_end_of_term_ver_id(x_return_status OUT NOCOPY VARCHAR2
107: ,p_etv_rec IN okl_etv_rec) IS

Line 116: x_return_status := okl_api.g_ret_sts_success;

112: WHERE end_of_term_ver_id = p_etv_rec.end_of_term_ver_id;
113: l_dummy_var VARCHAR2(1) := '?';
114:
115: BEGIN -- Initialize the return status to success
116: x_return_status := okl_api.g_ret_sts_success;
117:
118: IF (p_etv_rec.end_of_term_ver_id IS NULL AND p_etv_rec.end_of_term_ver_id = okl_api.g_miss_num) THEN
119: okl_api.set_message(p_app_name => g_app_name
120: ,p_msg_name => g_required_value

Line 118: IF (p_etv_rec.end_of_term_ver_id IS NULL AND p_etv_rec.end_of_term_ver_id = okl_api.g_miss_num) THEN

114:
115: BEGIN -- Initialize the return status to success
116: x_return_status := okl_api.g_ret_sts_success;
117:
118: IF (p_etv_rec.end_of_term_ver_id IS NULL AND p_etv_rec.end_of_term_ver_id = okl_api.g_miss_num) THEN
119: okl_api.set_message(p_app_name => g_app_name
120: ,p_msg_name => g_required_value
121: ,p_token1 => g_col_name_token
122: ,p_token1_value => 'END_OF_TERM_VER_ID'); -- notify caller of an error

Line 119: okl_api.set_message(p_app_name => g_app_name

115: BEGIN -- Initialize the return status to success
116: x_return_status := okl_api.g_ret_sts_success;
117:
118: IF (p_etv_rec.end_of_term_ver_id IS NULL AND p_etv_rec.end_of_term_ver_id = okl_api.g_miss_num) THEN
119: okl_api.set_message(p_app_name => g_app_name
120: ,p_msg_name => g_required_value
121: ,p_token1 => g_col_name_token
122: ,p_token1_value => 'END_OF_TERM_VER_ID'); -- notify caller of an error
123: x_return_status := okc_api.g_ret_sts_error;

Line 131: okl_api.set_message(p_app_name => g_app_name

127: FETCH po_ver_exists_csr INTO l_dummy_var ;
128: CLOSE po_ver_exists_csr; -- if l_dummy_var is still set to default, data was not found
129:
130: IF (l_dummy_var = '?') THEN
131: okl_api.set_message(p_app_name => g_app_name
132: ,p_msg_name => g_invalid_value
133: ,p_token1 => g_col_name_token
134: ,p_token1_value => 'END_OF_TERM_VER_ID'); -- notify caller of an error
135: x_return_status := okc_api.g_ret_sts_error;

Line 247: IF (l_etv_rec.end_of_term_value_id = okl_api.g_miss_num) THEN

243: l_etv_rec okl_etv_rec := p_etv_rec;
244:
245: BEGIN
246:
247: IF (l_etv_rec.end_of_term_value_id = okl_api.g_miss_num) THEN
248: l_etv_rec.end_of_term_value_id := NULL;
249: END IF;
250:
251: IF (l_etv_rec.object_version_number = okl_api.g_miss_num) THEN

Line 251: IF (l_etv_rec.object_version_number = okl_api.g_miss_num) THEN

247: IF (l_etv_rec.end_of_term_value_id = okl_api.g_miss_num) THEN
248: l_etv_rec.end_of_term_value_id := NULL;
249: END IF;
250:
251: IF (l_etv_rec.object_version_number = okl_api.g_miss_num) THEN
252: l_etv_rec.object_version_number := NULL;
253: END IF;
254:
255: IF (l_etv_rec.eot_term = okl_api.g_miss_num) THEN

Line 255: IF (l_etv_rec.eot_term = okl_api.g_miss_num) THEN

251: IF (l_etv_rec.object_version_number = okl_api.g_miss_num) THEN
252: l_etv_rec.object_version_number := NULL;
253: END IF;
254:
255: IF (l_etv_rec.eot_term = okl_api.g_miss_num) THEN
256: l_etv_rec.eot_term := NULL;
257: END IF;
258:
259: IF (l_etv_rec.eot_value = okl_api.g_miss_num) THEN

Line 259: IF (l_etv_rec.eot_value = okl_api.g_miss_num) THEN

255: IF (l_etv_rec.eot_term = okl_api.g_miss_num) THEN
256: l_etv_rec.eot_term := NULL;
257: END IF;
258:
259: IF (l_etv_rec.eot_value = okl_api.g_miss_num) THEN
260: l_etv_rec.eot_value := NULL;
261: END IF;
262:
263: IF (l_etv_rec.end_of_term_ver_id = okl_api.g_miss_num) THEN

Line 263: IF (l_etv_rec.end_of_term_ver_id = okl_api.g_miss_num) THEN

259: IF (l_etv_rec.eot_value = okl_api.g_miss_num) THEN
260: l_etv_rec.eot_value := NULL;
261: END IF;
262:
263: IF (l_etv_rec.end_of_term_ver_id = okl_api.g_miss_num) THEN
264: l_etv_rec.end_of_term_ver_id := NULL;
265: END IF;
266:
267: IF (l_etv_rec.attribute_category = okl_api.g_miss_char) THEN

Line 267: IF (l_etv_rec.attribute_category = okl_api.g_miss_char) THEN

263: IF (l_etv_rec.end_of_term_ver_id = okl_api.g_miss_num) THEN
264: l_etv_rec.end_of_term_ver_id := NULL;
265: END IF;
266:
267: IF (l_etv_rec.attribute_category = okl_api.g_miss_char) THEN
268: l_etv_rec.attribute_category := NULL;
269: END IF;
270:
271: IF (l_etv_rec.attribute1 = okl_api.g_miss_char) THEN

Line 271: IF (l_etv_rec.attribute1 = okl_api.g_miss_char) THEN

267: IF (l_etv_rec.attribute_category = okl_api.g_miss_char) THEN
268: l_etv_rec.attribute_category := NULL;
269: END IF;
270:
271: IF (l_etv_rec.attribute1 = okl_api.g_miss_char) THEN
272: l_etv_rec.attribute1 := NULL;
273: END IF;
274:
275: IF (l_etv_rec.attribute2 = okl_api.g_miss_char) THEN

Line 275: IF (l_etv_rec.attribute2 = okl_api.g_miss_char) THEN

271: IF (l_etv_rec.attribute1 = okl_api.g_miss_char) THEN
272: l_etv_rec.attribute1 := NULL;
273: END IF;
274:
275: IF (l_etv_rec.attribute2 = okl_api.g_miss_char) THEN
276: l_etv_rec.attribute2 := NULL;
277: END IF;
278:
279: IF (l_etv_rec.attribute3 = okl_api.g_miss_char) THEN

Line 279: IF (l_etv_rec.attribute3 = okl_api.g_miss_char) THEN

275: IF (l_etv_rec.attribute2 = okl_api.g_miss_char) THEN
276: l_etv_rec.attribute2 := NULL;
277: END IF;
278:
279: IF (l_etv_rec.attribute3 = okl_api.g_miss_char) THEN
280: l_etv_rec.attribute3 := NULL;
281: END IF;
282:
283: IF (l_etv_rec.attribute4 = okl_api.g_miss_char) THEN

Line 283: IF (l_etv_rec.attribute4 = okl_api.g_miss_char) THEN

279: IF (l_etv_rec.attribute3 = okl_api.g_miss_char) THEN
280: l_etv_rec.attribute3 := NULL;
281: END IF;
282:
283: IF (l_etv_rec.attribute4 = okl_api.g_miss_char) THEN
284: l_etv_rec.attribute4 := NULL;
285: END IF;
286:
287: IF (l_etv_rec.attribute5 = okl_api.g_miss_char) THEN

Line 287: IF (l_etv_rec.attribute5 = okl_api.g_miss_char) THEN

283: IF (l_etv_rec.attribute4 = okl_api.g_miss_char) THEN
284: l_etv_rec.attribute4 := NULL;
285: END IF;
286:
287: IF (l_etv_rec.attribute5 = okl_api.g_miss_char) THEN
288: l_etv_rec.attribute5 := NULL;
289: END IF;
290:
291: IF (l_etv_rec.attribute6 = okl_api.g_miss_char) THEN

Line 291: IF (l_etv_rec.attribute6 = okl_api.g_miss_char) THEN

287: IF (l_etv_rec.attribute5 = okl_api.g_miss_char) THEN
288: l_etv_rec.attribute5 := NULL;
289: END IF;
290:
291: IF (l_etv_rec.attribute6 = okl_api.g_miss_char) THEN
292: l_etv_rec.attribute6 := NULL;
293: END IF;
294:
295: IF (l_etv_rec.attribute7 = okl_api.g_miss_char) THEN

Line 295: IF (l_etv_rec.attribute7 = okl_api.g_miss_char) THEN

291: IF (l_etv_rec.attribute6 = okl_api.g_miss_char) THEN
292: l_etv_rec.attribute6 := NULL;
293: END IF;
294:
295: IF (l_etv_rec.attribute7 = okl_api.g_miss_char) THEN
296: l_etv_rec.attribute7 := NULL;
297: END IF;
298:
299: IF (l_etv_rec.attribute8 = okl_api.g_miss_char) THEN

Line 299: IF (l_etv_rec.attribute8 = okl_api.g_miss_char) THEN

295: IF (l_etv_rec.attribute7 = okl_api.g_miss_char) THEN
296: l_etv_rec.attribute7 := NULL;
297: END IF;
298:
299: IF (l_etv_rec.attribute8 = okl_api.g_miss_char) THEN
300: l_etv_rec.attribute8 := NULL;
301: END IF;
302:
303: IF (l_etv_rec.attribute9 = okl_api.g_miss_char) THEN

Line 303: IF (l_etv_rec.attribute9 = okl_api.g_miss_char) THEN

299: IF (l_etv_rec.attribute8 = okl_api.g_miss_char) THEN
300: l_etv_rec.attribute8 := NULL;
301: END IF;
302:
303: IF (l_etv_rec.attribute9 = okl_api.g_miss_char) THEN
304: l_etv_rec.attribute9 := NULL;
305: END IF;
306:
307: IF (l_etv_rec.attribute10 = okl_api.g_miss_char) THEN

Line 307: IF (l_etv_rec.attribute10 = okl_api.g_miss_char) THEN

303: IF (l_etv_rec.attribute9 = okl_api.g_miss_char) THEN
304: l_etv_rec.attribute9 := NULL;
305: END IF;
306:
307: IF (l_etv_rec.attribute10 = okl_api.g_miss_char) THEN
308: l_etv_rec.attribute10 := NULL;
309: END IF;
310:
311: IF (l_etv_rec.attribute11 = okl_api.g_miss_char) THEN

Line 311: IF (l_etv_rec.attribute11 = okl_api.g_miss_char) THEN

307: IF (l_etv_rec.attribute10 = okl_api.g_miss_char) THEN
308: l_etv_rec.attribute10 := NULL;
309: END IF;
310:
311: IF (l_etv_rec.attribute11 = okl_api.g_miss_char) THEN
312: l_etv_rec.attribute11 := NULL;
313: END IF;
314:
315: IF (l_etv_rec.attribute12 = okl_api.g_miss_char) THEN

Line 315: IF (l_etv_rec.attribute12 = okl_api.g_miss_char) THEN

311: IF (l_etv_rec.attribute11 = okl_api.g_miss_char) THEN
312: l_etv_rec.attribute11 := NULL;
313: END IF;
314:
315: IF (l_etv_rec.attribute12 = okl_api.g_miss_char) THEN
316: l_etv_rec.attribute12 := NULL;
317: END IF;
318:
319: IF (l_etv_rec.attribute13 = okl_api.g_miss_char) THEN

Line 319: IF (l_etv_rec.attribute13 = okl_api.g_miss_char) THEN

315: IF (l_etv_rec.attribute12 = okl_api.g_miss_char) THEN
316: l_etv_rec.attribute12 := NULL;
317: END IF;
318:
319: IF (l_etv_rec.attribute13 = okl_api.g_miss_char) THEN
320: l_etv_rec.attribute13 := NULL;
321: END IF;
322:
323: IF (l_etv_rec.attribute14 = okl_api.g_miss_char) THEN

Line 323: IF (l_etv_rec.attribute14 = okl_api.g_miss_char) THEN

319: IF (l_etv_rec.attribute13 = okl_api.g_miss_char) THEN
320: l_etv_rec.attribute13 := NULL;
321: END IF;
322:
323: IF (l_etv_rec.attribute14 = okl_api.g_miss_char) THEN
324: l_etv_rec.attribute14 := NULL;
325: END IF;
326:
327: IF (l_etv_rec.attribute15 = okl_api.g_miss_char) THEN

Line 327: IF (l_etv_rec.attribute15 = okl_api.g_miss_char) THEN

323: IF (l_etv_rec.attribute14 = okl_api.g_miss_char) THEN
324: l_etv_rec.attribute14 := NULL;
325: END IF;
326:
327: IF (l_etv_rec.attribute15 = okl_api.g_miss_char) THEN
328: l_etv_rec.attribute15 := NULL;
329: END IF;
330:
331: IF (l_etv_rec.created_by = okl_api.g_miss_num) THEN

Line 331: IF (l_etv_rec.created_by = okl_api.g_miss_num) THEN

327: IF (l_etv_rec.attribute15 = okl_api.g_miss_char) THEN
328: l_etv_rec.attribute15 := NULL;
329: END IF;
330:
331: IF (l_etv_rec.created_by = okl_api.g_miss_num) THEN
332: l_etv_rec.created_by := NULL;
333: END IF;
334:
335: IF (l_etv_rec.creation_date = okl_api.g_miss_date) THEN

Line 335: IF (l_etv_rec.creation_date = okl_api.g_miss_date) THEN

331: IF (l_etv_rec.created_by = okl_api.g_miss_num) THEN
332: l_etv_rec.created_by := NULL;
333: END IF;
334:
335: IF (l_etv_rec.creation_date = okl_api.g_miss_date) THEN
336: l_etv_rec.creation_date := NULL;
337: END IF;
338:
339: IF (l_etv_rec.last_updated_by = okl_api.g_miss_num) THEN

Line 339: IF (l_etv_rec.last_updated_by = okl_api.g_miss_num) THEN

335: IF (l_etv_rec.creation_date = okl_api.g_miss_date) THEN
336: l_etv_rec.creation_date := NULL;
337: END IF;
338:
339: IF (l_etv_rec.last_updated_by = okl_api.g_miss_num) THEN
340: l_etv_rec.last_updated_by := NULL;
341: END IF;
342:
343: IF (l_etv_rec.last_update_date = okl_api.g_miss_date) THEN

Line 343: IF (l_etv_rec.last_update_date = okl_api.g_miss_date) THEN

339: IF (l_etv_rec.last_updated_by = okl_api.g_miss_num) THEN
340: l_etv_rec.last_updated_by := NULL;
341: END IF;
342:
343: IF (l_etv_rec.last_update_date = okl_api.g_miss_date) THEN
344: l_etv_rec.last_update_date := NULL;
345: END IF;
346:
347: IF (l_etv_rec.last_update_login = okl_api.g_miss_num) THEN

Line 347: IF (l_etv_rec.last_update_login = okl_api.g_miss_num) THEN

343: IF (l_etv_rec.last_update_date = okl_api.g_miss_date) THEN
344: l_etv_rec.last_update_date := NULL;
345: END IF;
346:
347: IF (l_etv_rec.last_update_login = okl_api.g_miss_num) THEN
348: l_etv_rec.last_update_login := NULL;
349: END IF;
350: RETURN(l_etv_rec);
351: END null_out_defaults;

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

357: END get_seq_id;
358:
359: FUNCTION validate_attributes(p_etv_rec IN okl_etv_rec) RETURN VARCHAR2 IS
360: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
361: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
362:
363: BEGIN -- validate the id
364: validate_end_of_term_value_id(x_return_status => l_return_status
365: ,p_etv_rec => p_etv_rec); -- store the highest degree of error

Line 367: IF (l_return_status <> okl_api.g_ret_sts_success) THEN

363: BEGIN -- validate the id
364: validate_end_of_term_value_id(x_return_status => l_return_status
365: ,p_etv_rec => p_etv_rec); -- store the highest degree of error
366:
367: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
368: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
369: x_return_status := l_return_status;
370: END IF;
371: END IF; -- validate the term

Line 368: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN

364: validate_end_of_term_value_id(x_return_status => l_return_status
365: ,p_etv_rec => p_etv_rec); -- store the highest degree of error
366:
367: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
368: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
369: x_return_status := l_return_status;
370: END IF;
371: END IF; -- validate the term
372: validate_eot_term(x_return_status => l_return_status

Line 375: IF (l_return_status <> okl_api.g_ret_sts_success) THEN

371: END IF; -- validate the term
372: validate_eot_term(x_return_status => l_return_status
373: ,p_etv_rec => p_etv_rec); -- store the highest degree of error
374:
375: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
376: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
377: x_return_status := l_return_status;
378: END IF;
379: END IF; -- validate the value

Line 376: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN

372: validate_eot_term(x_return_status => l_return_status
373: ,p_etv_rec => p_etv_rec); -- store the highest degree of error
374:
375: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
376: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
377: x_return_status := l_return_status;
378: END IF;
379: END IF; -- validate the value
380: validate_eot_term(x_return_status => l_return_status

Line 383: IF (l_return_status <> okl_api.g_ret_sts_success) THEN

379: END IF; -- validate the value
380: validate_eot_term(x_return_status => l_return_status
381: ,p_etv_rec => p_etv_rec); -- store the highest degree of error
382:
383: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
384: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
385: x_return_status := l_return_status;
386: END IF;
387: END IF; -- validate the version id

Line 384: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN

380: validate_eot_term(x_return_status => l_return_status
381: ,p_etv_rec => p_etv_rec); -- store the highest degree of error
382:
383: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
384: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
385: x_return_status := l_return_status;
386: END IF;
387: END IF; -- validate the version id
388: validate_end_of_term_ver_id(x_return_status => l_return_status

Line 391: IF (l_return_status <> okl_api.g_ret_sts_success) THEN

387: END IF; -- validate the version id
388: validate_end_of_term_ver_id(x_return_status => l_return_status
389: ,p_etv_rec => p_etv_rec); -- store the highest degree of error
390:
391: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
392: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
393: x_return_status := l_return_status;
394: END IF;
395: END IF;

Line 392: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN

388: validate_end_of_term_ver_id(x_return_status => l_return_status
389: ,p_etv_rec => p_etv_rec); -- store the highest degree of error
390:
391: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
392: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
393: x_return_status := l_return_status;
394: END IF;
395: END IF;
396: RETURN(x_return_status);

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

397: END validate_attributes;
398:
399: FUNCTION validate_record(p_etv_rec IN okl_etv_rec) RETURN VARCHAR2 IS
400: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
401: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
402:
403: BEGIN
404: RETURN(x_return_status);
405: END validate_record; -- lock row

Line 408: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

404: RETURN(x_return_status);
405: END validate_record; -- lock row
406:
407: PROCEDURE lock_row(p_api_version IN NUMBER
408: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
409: ,x_return_status OUT NOCOPY VARCHAR2
410: ,x_msg_count OUT NOCOPY NUMBER
411: ,x_msg_data OUT NOCOPY VARCHAR2
412: ,p_def_etv_rec IN okl_etv_rec) IS

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

425: CURSOR lchk_csr(p_def_etv_rec IN okl_etv_rec) IS
426: SELECT object_version_number
427: FROM okl_fe_eo_term_values
428: WHERE end_of_term_value_id = p_def_etv_rec.end_of_term_value_id;
429: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
430: l_object_version_number okl_fe_item_residual_all.object_version_number%TYPE;
431: lc_object_version_number okl_fe_item_residual_all.object_version_number%TYPE;
432: l_row_notfound BOOLEAN := false;
433: lc_row_notfound BOOLEAN := false;

Line 448: okl_api.set_message(g_fnd_app

444:
445: IF (lock_csr%ISOPEN) THEN
446: CLOSE lock_csr;
447: END IF;
448: okl_api.set_message(g_fnd_app
449: ,g_form_unable_to_reserve_rec);
450: RAISE app_exceptions.record_lock_exception;
451: END;
452:

Line 461: okl_api.set_message(g_fnd_app

457: CLOSE lchk_csr;
458: END IF;
459:
460: IF (lc_row_notfound) THEN
461: okl_api.set_message(g_fnd_app
462: ,g_form_record_deleted);
463: RAISE okl_api.g_exception_error;
464: ELSIF lc_object_version_number > p_def_etv_rec.object_version_number THEN
465: okl_api.set_message(g_fnd_app

Line 463: RAISE okl_api.g_exception_error;

459:
460: IF (lc_row_notfound) THEN
461: okl_api.set_message(g_fnd_app
462: ,g_form_record_deleted);
463: RAISE okl_api.g_exception_error;
464: ELSIF lc_object_version_number > p_def_etv_rec.object_version_number THEN
465: okl_api.set_message(g_fnd_app
466: ,g_form_record_changed);
467: RAISE okl_api.g_exception_error;

Line 465: okl_api.set_message(g_fnd_app

461: okl_api.set_message(g_fnd_app
462: ,g_form_record_deleted);
463: RAISE okl_api.g_exception_error;
464: ELSIF lc_object_version_number > p_def_etv_rec.object_version_number THEN
465: okl_api.set_message(g_fnd_app
466: ,g_form_record_changed);
467: RAISE okl_api.g_exception_error;
468: ELSIF lc_object_version_number <> p_def_etv_rec.object_version_number THEN
469: okl_api.set_message(g_fnd_app

Line 467: RAISE okl_api.g_exception_error;

463: RAISE okl_api.g_exception_error;
464: ELSIF lc_object_version_number > p_def_etv_rec.object_version_number THEN
465: okl_api.set_message(g_fnd_app
466: ,g_form_record_changed);
467: RAISE okl_api.g_exception_error;
468: ELSIF lc_object_version_number <> p_def_etv_rec.object_version_number THEN
469: okl_api.set_message(g_fnd_app
470: ,g_form_record_changed);
471: RAISE okl_api.g_exception_error;

Line 469: okl_api.set_message(g_fnd_app

465: okl_api.set_message(g_fnd_app
466: ,g_form_record_changed);
467: RAISE okl_api.g_exception_error;
468: ELSIF lc_object_version_number <> p_def_etv_rec.object_version_number THEN
469: okl_api.set_message(g_fnd_app
470: ,g_form_record_changed);
471: RAISE okl_api.g_exception_error;
472: ELSIF lc_object_version_number = - 1 THEN
473: okl_api.set_message(g_app_name

Line 471: RAISE okl_api.g_exception_error;

467: RAISE okl_api.g_exception_error;
468: ELSIF lc_object_version_number <> p_def_etv_rec.object_version_number THEN
469: okl_api.set_message(g_fnd_app
470: ,g_form_record_changed);
471: RAISE okl_api.g_exception_error;
472: ELSIF lc_object_version_number = - 1 THEN
473: okl_api.set_message(g_app_name
474: ,g_record_logically_deleted);
475: RAISE okl_api.g_exception_error;

Line 473: okl_api.set_message(g_app_name

469: okl_api.set_message(g_fnd_app
470: ,g_form_record_changed);
471: RAISE okl_api.g_exception_error;
472: ELSIF lc_object_version_number = - 1 THEN
473: okl_api.set_message(g_app_name
474: ,g_record_logically_deleted);
475: RAISE okl_api.g_exception_error;
476: END IF;
477: x_return_status := l_return_status;

Line 475: RAISE okl_api.g_exception_error;

471: RAISE okl_api.g_exception_error;
472: ELSIF lc_object_version_number = - 1 THEN
473: okl_api.set_message(g_app_name
474: ,g_record_logically_deleted);
475: RAISE okl_api.g_exception_error;
476: END IF;
477: x_return_status := l_return_status;
478: EXCEPTION
479: WHEN okl_api.g_exception_error THEN

Line 479: WHEN okl_api.g_exception_error THEN

475: RAISE okl_api.g_exception_error;
476: END IF;
477: x_return_status := l_return_status;
478: EXCEPTION
479: WHEN okl_api.g_exception_error THEN
480: x_return_status := g_ret_sts_error;
481: WHEN okl_api.g_exception_unexpected_error THEN
482: x_return_status := g_ret_sts_unexp_error;
483: WHEN OTHERS THEN

Line 481: WHEN okl_api.g_exception_unexpected_error THEN

477: x_return_status := l_return_status;
478: EXCEPTION
479: WHEN okl_api.g_exception_error THEN
480: x_return_status := g_ret_sts_error;
481: WHEN okl_api.g_exception_unexpected_error THEN
482: x_return_status := g_ret_sts_unexp_error;
483: WHEN OTHERS THEN
484: okl_api.set_message(p_app_name => g_app_name
485: ,p_msg_name => g_db_error

Line 484: okl_api.set_message(p_app_name => g_app_name

480: x_return_status := g_ret_sts_error;
481: WHEN okl_api.g_exception_unexpected_error THEN
482: x_return_status := g_ret_sts_unexp_error;
483: WHEN OTHERS THEN
484: okl_api.set_message(p_app_name => g_app_name
485: ,p_msg_name => g_db_error
486: ,p_token1 => g_prog_name_token
487: ,p_token1_value => l_api_name
488: ,p_token2 => g_sqlcode_token

Line 500: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

496: -- lock_row (TBL)
497: -----------------
498:
499: PROCEDURE lock_row(p_api_version IN NUMBER
500: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
501: ,x_return_status OUT NOCOPY VARCHAR2
502: ,x_msg_count OUT NOCOPY NUMBER
503: ,x_msg_data OUT NOCOPY VARCHAR2
504: ,okl_etv_tbl IN okl_etv_tbl) IS

Line 523: RAISE okl_api.g_exception_unexpected_error;

519: ,x_msg_count => x_msg_count
520: ,x_msg_data => x_msg_data
521: ,p_def_etv_rec => okl_etv_tbl(i));
522: IF l_return_status = g_ret_sts_unexp_error THEN
523: RAISE okl_api.g_exception_unexpected_error;
524: ELSIF l_return_status = g_ret_sts_error THEN
525: RAISE okl_api.g_exception_error;
526: END IF;
527: EXIT WHEN(i = okl_etv_tbl.LAST);

Line 525: RAISE okl_api.g_exception_error;

521: ,p_def_etv_rec => okl_etv_tbl(i));
522: IF l_return_status = g_ret_sts_unexp_error THEN
523: RAISE okl_api.g_exception_unexpected_error;
524: ELSIF l_return_status = g_ret_sts_error THEN
525: RAISE okl_api.g_exception_error;
526: END IF;
527: EXIT WHEN(i = okl_etv_tbl.LAST);
528: i := okl_etv_tbl.next(i);
529: END IF;

Line 535: WHEN okl_api.g_exception_error THEN

531:
532: END IF;
533: x_return_status := l_return_status;
534: EXCEPTION
535: WHEN okl_api.g_exception_error THEN
536: x_return_status := g_ret_sts_error;
537: WHEN okl_api.g_exception_unexpected_error THEN
538: x_return_status := g_ret_sts_unexp_error;
539: WHEN OTHERS THEN

Line 537: WHEN okl_api.g_exception_unexpected_error THEN

533: x_return_status := l_return_status;
534: EXCEPTION
535: WHEN okl_api.g_exception_error THEN
536: x_return_status := g_ret_sts_error;
537: WHEN okl_api.g_exception_unexpected_error THEN
538: x_return_status := g_ret_sts_unexp_error;
539: WHEN OTHERS THEN
540: okl_api.set_message(p_app_name => g_app_name
541: ,p_msg_name => g_db_error

Line 540: okl_api.set_message(p_app_name => g_app_name

536: x_return_status := g_ret_sts_error;
537: WHEN okl_api.g_exception_unexpected_error THEN
538: x_return_status := g_ret_sts_unexp_error;
539: WHEN OTHERS THEN
540: okl_api.set_message(p_app_name => g_app_name
541: ,p_msg_name => g_db_error
542: ,p_token1 => g_prog_name_token
543: ,p_token1_value => l_api_name
544: ,p_token2 => g_sqlcode_token

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

560: ,p_etv_rec IN okl_etv_rec
561: ,x_etv_rec OUT NOCOPY okl_etv_rec) IS
562: l_api_version CONSTANT NUMBER := 1;
563: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
564: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
565: l_etv_rec okl_etv_rec;
566: l_def_pvl_rec okl_etv_rec;
567:
568: FUNCTION fill_who_columns(p_etv_rec IN okl_etv_rec) RETURN okl_etv_rec IS

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

595: ,p_api_version
596: ,'_PVT'
597: ,x_return_status);
598:
599: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
600: RAISE okc_api.g_exception_unexpected_error;
601: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
602: RAISE okc_api.g_exception_error;
603: END IF;

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

597: ,x_return_status);
598:
599: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
600: RAISE okc_api.g_exception_unexpected_error;
601: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
602: RAISE okc_api.g_exception_error;
603: END IF;
604: l_etv_rec := null_out_defaults(p_etv_rec); -- Set Primary key value
605: l_etv_rec.end_of_term_value_id := get_seq_id; --Setting Item Attributes

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

605: l_etv_rec.end_of_term_value_id := get_seq_id; --Setting Item Attributes
606: l_return_status := set_attributes(l_etv_rec
607: ,l_def_pvl_rec);
608:
609: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
610: RAISE okc_api.g_exception_unexpected_error;
611: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
612: RAISE okc_api.g_exception_error;
613: END IF;

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

607: ,l_def_pvl_rec);
608:
609: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
610: RAISE okc_api.g_exception_unexpected_error;
611: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
612: RAISE okc_api.g_exception_error;
613: END IF;
614: l_def_pvl_rec := fill_who_columns(l_def_pvl_rec);
615: l_return_status := validate_attributes(l_def_pvl_rec);

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

613: END IF;
614: l_def_pvl_rec := fill_who_columns(l_def_pvl_rec);
615: l_return_status := validate_attributes(l_def_pvl_rec);
616:
617: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
618: RAISE okc_api.g_exception_unexpected_error;
619: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
620: RAISE okc_api.g_exception_error;
621: END IF;

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

615: l_return_status := validate_attributes(l_def_pvl_rec);
616:
617: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
618: RAISE okc_api.g_exception_unexpected_error;
619: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
620: RAISE okc_api.g_exception_error;
621: END IF;
622: l_return_status := validate_record(l_def_pvl_rec);
623:

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

620: RAISE okc_api.g_exception_error;
621: END IF;
622: l_return_status := validate_record(l_def_pvl_rec);
623:
624: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
625: RAISE okc_api.g_exception_unexpected_error;
626: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
627: RAISE okc_api.g_exception_error;
628: END IF;

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

622: l_return_status := validate_record(l_def_pvl_rec);
623:
624: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
625: RAISE okc_api.g_exception_unexpected_error;
626: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
627: RAISE okc_api.g_exception_error;
628: END IF;
629:
630: INSERT INTO okl_fe_eo_term_values

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

680: ,l_def_pvl_rec.last_updated_by
681: ,l_def_pvl_rec.last_update_date
682: ,l_def_pvl_rec.last_update_login);
683:
684: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
685: RAISE okc_api.g_exception_unexpected_error;
686: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
687: RAISE okc_api.g_exception_error;
688: END IF; --Set OUT Values

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

682: ,l_def_pvl_rec.last_update_login);
683:
684: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
685: RAISE okc_api.g_exception_unexpected_error;
686: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
687: RAISE okc_api.g_exception_error;
688: END IF; --Set OUT Values
689: x_etv_rec := l_def_pvl_rec;
690: okc_api.end_activity(x_msg_count

Line 696: x_return_status := okl_api.handle_exceptions(l_api_name

692: EXCEPTION
693: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
694: NULL;
695: WHEN okc_api.g_exception_error THEN
696: x_return_status := okl_api.handle_exceptions(l_api_name
697: ,g_pkg_name
698: ,'OKL_API.G_RET_STS_ERROR'
699: ,x_msg_count
700: ,x_msg_data

Line 698: ,'OKL_API.G_RET_STS_ERROR'

694: NULL;
695: WHEN okc_api.g_exception_error THEN
696: x_return_status := okl_api.handle_exceptions(l_api_name
697: ,g_pkg_name
698: ,'OKL_API.G_RET_STS_ERROR'
699: ,x_msg_count
700: ,x_msg_data
701: ,'_PVT');
702: WHEN okc_api.g_exception_unexpected_error THEN

Line 703: x_return_status := okl_api.handle_exceptions(l_api_name

699: ,x_msg_count
700: ,x_msg_data
701: ,'_PVT');
702: WHEN okc_api.g_exception_unexpected_error THEN
703: x_return_status := okl_api.handle_exceptions(l_api_name
704: ,g_pkg_name
705: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
706: ,x_msg_count
707: ,x_msg_data

Line 705: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

701: ,'_PVT');
702: WHEN okc_api.g_exception_unexpected_error THEN
703: x_return_status := okl_api.handle_exceptions(l_api_name
704: ,g_pkg_name
705: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
706: ,x_msg_count
707: ,x_msg_data
708: ,'_PVT');
709: WHEN OTHERS THEN

Line 710: x_return_status := okl_api.handle_exceptions(l_api_name

706: ,x_msg_count
707: ,x_msg_data
708: ,'_PVT');
709: WHEN OTHERS THEN
710: x_return_status := okl_api.handle_exceptions(l_api_name
711: ,g_pkg_name
712: ,'OTHERS'
713: ,x_msg_count
714: ,x_msg_data

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

727: ,p_etv_tbl IN okl_etv_tbl
728: ,x_etv_tbl OUT NOCOPY okl_etv_tbl) IS
729: l_api_version CONSTANT NUMBER := 1;
730: l_api_name CONSTANT VARCHAR2(30) := 'insert_row_tbl';
731: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
732: i NUMBER := 0;
733: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
734:
735: BEGIN

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

729: l_api_version CONSTANT NUMBER := 1;
730: l_api_name CONSTANT VARCHAR2(30) := 'insert_row_tbl';
731: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
732: i NUMBER := 0;
733: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
734:
735: BEGIN
736: okc_api.init_msg_list(p_init_msg_list); -- Make sure PL/SQL table has records in it before passing
737:

Line 764: x_return_status := okl_api.handle_exceptions(l_api_name

760: EXCEPTION
761: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
762: NULL;
763: WHEN okc_api.g_exception_error THEN
764: x_return_status := okl_api.handle_exceptions(l_api_name
765: ,g_pkg_name
766: ,'OKL_API.G_RET_STS_ERROR'
767: ,x_msg_count
768: ,x_msg_data

Line 766: ,'OKL_API.G_RET_STS_ERROR'

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

Line 771: x_return_status := okl_api.handle_exceptions(l_api_name

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

Line 773: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

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

Line 778: x_return_status := okl_api.handle_exceptions(l_api_name

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

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

795: ,p_etv_rec IN okl_etv_rec
796: ,x_etv_rec OUT NOCOPY okl_etv_rec) IS
797: l_api_version CONSTANT NUMBER := 1;
798: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
799: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
800: l_etv_rec okl_etv_rec := p_etv_rec;
801: l_def_etv_rec okl_etv_rec;
802: lx_etv_rec okl_etv_rec;
803:

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

814: FUNCTION populate_new_record(p_etv_rec IN okl_etv_rec
815: ,x_etv_rec OUT NOCOPY okl_etv_rec) RETURN VARCHAR2 IS
816: l_etv_rec okl_etv_rec;
817: l_row_notfound BOOLEAN := true;
818: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
819:
820: BEGIN
821: x_etv_rec := p_etv_rec; --Get current database values
822: l_etv_rec := get_rec(p_etv_rec

Line 826: l_return_status := okl_api.g_ret_sts_unexp_error;

822: l_etv_rec := get_rec(p_etv_rec
823: ,l_row_notfound);
824:
825: IF (l_row_notfound) THEN
826: l_return_status := okl_api.g_ret_sts_unexp_error;
827: END IF;
828:
829: IF (x_etv_rec.end_of_term_value_id IS NULL) THEN
830: x_etv_rec.end_of_term_value_id := l_etv_rec.end_of_term_value_id;

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

949: ,p_api_version
950: ,'_PVT'
951: ,x_return_status);
952:
953: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
954: RAISE okc_api.g_exception_unexpected_error;
955: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
956: RAISE okc_api.g_exception_error;
957: END IF; --Setting Item Attributes

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

951: ,x_return_status);
952:
953: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
954: RAISE okc_api.g_exception_unexpected_error;
955: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
956: RAISE okc_api.g_exception_error;
957: END IF; --Setting Item Attributes
958: l_return_status := set_attributes(l_etv_rec
959: ,lx_etv_rec);

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

957: END IF; --Setting Item Attributes
958: l_return_status := set_attributes(l_etv_rec
959: ,lx_etv_rec);
960:
961: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
962: RAISE okc_api.g_exception_unexpected_error;
963: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
964: RAISE okc_api.g_exception_error;
965: END IF;

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

959: ,lx_etv_rec);
960:
961: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
962: RAISE okc_api.g_exception_unexpected_error;
963: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
964: RAISE okc_api.g_exception_error;
965: END IF;
966: l_return_status := populate_new_record(lx_etv_rec
967: ,l_def_etv_rec);

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

965: END IF;
966: l_return_status := populate_new_record(lx_etv_rec
967: ,l_def_etv_rec);
968:
969: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
970: RAISE okc_api.g_exception_unexpected_error;
971: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
972: RAISE okc_api.g_exception_error;
973: END IF;

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

967: ,l_def_etv_rec);
968:
969: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
970: RAISE okc_api.g_exception_unexpected_error;
971: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
972: RAISE okc_api.g_exception_error;
973: END IF;
974: l_def_etv_rec := null_out_defaults(l_def_etv_rec);
975:

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

972: RAISE okc_api.g_exception_error;
973: END IF;
974: l_def_etv_rec := null_out_defaults(l_def_etv_rec);
975:
976: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
977: RAISE okl_api.g_exception_unexpected_error;
978: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
979: RAISE okl_api.g_exception_error;
980: END IF;

Line 977: RAISE okl_api.g_exception_unexpected_error;

973: END IF;
974: l_def_etv_rec := null_out_defaults(l_def_etv_rec);
975:
976: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
977: RAISE okl_api.g_exception_unexpected_error;
978: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
979: RAISE okl_api.g_exception_error;
980: END IF;
981: l_def_etv_rec := fill_who_columns(l_def_etv_rec);

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

974: l_def_etv_rec := null_out_defaults(l_def_etv_rec);
975:
976: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
977: RAISE okl_api.g_exception_unexpected_error;
978: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
979: RAISE okl_api.g_exception_error;
980: END IF;
981: l_def_etv_rec := fill_who_columns(l_def_etv_rec);
982: l_return_status := validate_attributes(l_def_etv_rec);

Line 979: RAISE okl_api.g_exception_error;

975:
976: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
977: RAISE okl_api.g_exception_unexpected_error;
978: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
979: RAISE okl_api.g_exception_error;
980: END IF;
981: l_def_etv_rec := fill_who_columns(l_def_etv_rec);
982: l_return_status := validate_attributes(l_def_etv_rec);
983:

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

980: END IF;
981: l_def_etv_rec := fill_who_columns(l_def_etv_rec);
982: l_return_status := validate_attributes(l_def_etv_rec);
983:
984: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
985: RAISE okc_api.g_exception_unexpected_error;
986: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
987: RAISE okc_api.g_exception_error;
988: END IF;

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

982: l_return_status := validate_attributes(l_def_etv_rec);
983:
984: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
985: RAISE okc_api.g_exception_unexpected_error;
986: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
987: RAISE okc_api.g_exception_error;
988: END IF;
989: l_return_status := validate_record(l_def_etv_rec);
990:

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

987: RAISE okc_api.g_exception_error;
988: END IF;
989: l_return_status := validate_record(l_def_etv_rec);
990:
991: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
992: RAISE okc_api.g_exception_unexpected_error;
993: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
994: RAISE okc_api.g_exception_error;
995: END IF; -- Lock the row before updating

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

989: l_return_status := validate_record(l_def_etv_rec);
990:
991: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
992: RAISE okc_api.g_exception_unexpected_error;
993: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
994: RAISE okc_api.g_exception_error;
995: END IF; -- Lock the row before updating
996: lock_row(p_api_version => g_api_version
997: ,p_init_msg_list => g_false

Line 1004: RAISE okl_api.g_exception_unexpected_error;

1000: ,x_msg_data => x_msg_data
1001: ,p_def_etv_rec => l_def_etv_rec);
1002:
1003: IF (l_return_status = g_ret_sts_unexp_error) THEN
1004: RAISE okl_api.g_exception_unexpected_error;
1005: ELSIF (l_return_status = g_ret_sts_error) THEN
1006: RAISE okl_api.g_exception_error;
1007: END IF;
1008:

Line 1006: RAISE okl_api.g_exception_error;

1002:
1003: IF (l_return_status = g_ret_sts_unexp_error) THEN
1004: RAISE okl_api.g_exception_unexpected_error;
1005: ELSIF (l_return_status = g_ret_sts_error) THEN
1006: RAISE okl_api.g_exception_error;
1007: END IF;
1008:
1009: UPDATE okl_fe_eo_term_values
1010: SET end_of_term_value_id = l_def_etv_rec.end_of_term_value_id

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

1034: ,last_update_date = l_def_etv_rec.last_update_date
1035: ,last_update_login = l_def_etv_rec.last_update_login
1036: WHERE end_of_term_value_id = l_def_etv_rec.end_of_term_value_id;
1037:
1038: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1039: RAISE okc_api.g_exception_unexpected_error;
1040: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1041: RAISE okc_api.g_exception_error;
1042: END IF; --Set OUT Values

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

1036: WHERE end_of_term_value_id = l_def_etv_rec.end_of_term_value_id;
1037:
1038: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1039: RAISE okc_api.g_exception_unexpected_error;
1040: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1041: RAISE okc_api.g_exception_error;
1042: END IF; --Set OUT Values
1043: x_etv_rec := l_def_etv_rec;
1044: okc_api.end_activity(x_msg_count

Line 1050: x_return_status := okl_api.handle_exceptions(l_api_name

1046: EXCEPTION
1047: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
1048: NULL;
1049: WHEN okc_api.g_exception_error THEN
1050: x_return_status := okl_api.handle_exceptions(l_api_name
1051: ,g_pkg_name
1052: ,'OKL_API.G_RET_STS_ERROR'
1053: ,x_msg_count
1054: ,x_msg_data

Line 1052: ,'OKL_API.G_RET_STS_ERROR'

1048: NULL;
1049: WHEN okc_api.g_exception_error THEN
1050: x_return_status := okl_api.handle_exceptions(l_api_name
1051: ,g_pkg_name
1052: ,'OKL_API.G_RET_STS_ERROR'
1053: ,x_msg_count
1054: ,x_msg_data
1055: ,'_PVT');
1056: WHEN okc_api.g_exception_unexpected_error THEN

Line 1057: x_return_status := okl_api.handle_exceptions(l_api_name

1053: ,x_msg_count
1054: ,x_msg_data
1055: ,'_PVT');
1056: WHEN okc_api.g_exception_unexpected_error THEN
1057: x_return_status := okl_api.handle_exceptions(l_api_name
1058: ,g_pkg_name
1059: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1060: ,x_msg_count
1061: ,x_msg_data

Line 1059: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1055: ,'_PVT');
1056: WHEN okc_api.g_exception_unexpected_error THEN
1057: x_return_status := okl_api.handle_exceptions(l_api_name
1058: ,g_pkg_name
1059: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1060: ,x_msg_count
1061: ,x_msg_data
1062: ,'_PVT');
1063: WHEN OTHERS THEN

Line 1064: x_return_status := okl_api.handle_exceptions(l_api_name

1060: ,x_msg_count
1061: ,x_msg_data
1062: ,'_PVT');
1063: WHEN OTHERS THEN
1064: x_return_status := okl_api.handle_exceptions(l_api_name
1065: ,g_pkg_name
1066: ,'OTHERS'
1067: ,x_msg_count
1068: ,x_msg_data

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

1081: ,p_etv_tbl IN okl_etv_tbl
1082: ,x_etv_tbl OUT NOCOPY okl_etv_tbl) IS
1083: l_api_version CONSTANT NUMBER := 1;
1084: l_api_name CONSTANT VARCHAR2(30) := 'update_row_tbl';
1085: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1086: i NUMBER := 0;
1087: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1088:
1089: BEGIN

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

1083: l_api_version CONSTANT NUMBER := 1;
1084: l_api_name CONSTANT VARCHAR2(30) := 'update_row_tbl';
1085: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1086: i NUMBER := 0;
1087: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1088:
1089: BEGIN
1090: okc_api.init_msg_list(p_init_msg_list); -- Make sure PL/SQL table has records in it before passing
1091:

Line 1118: x_return_status := okl_api.handle_exceptions(l_api_name

1114: EXCEPTION
1115: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
1116: NULL;
1117: WHEN okc_api.g_exception_error THEN
1118: x_return_status := okl_api.handle_exceptions(l_api_name
1119: ,g_pkg_name
1120: ,'OKL_API.G_RET_STS_ERROR'
1121: ,x_msg_count
1122: ,x_msg_data

Line 1120: ,'OKL_API.G_RET_STS_ERROR'

1116: NULL;
1117: WHEN okc_api.g_exception_error THEN
1118: x_return_status := okl_api.handle_exceptions(l_api_name
1119: ,g_pkg_name
1120: ,'OKL_API.G_RET_STS_ERROR'
1121: ,x_msg_count
1122: ,x_msg_data
1123: ,'_PVT');
1124: WHEN okc_api.g_exception_unexpected_error THEN

Line 1125: x_return_status := okl_api.handle_exceptions(l_api_name

1121: ,x_msg_count
1122: ,x_msg_data
1123: ,'_PVT');
1124: WHEN okc_api.g_exception_unexpected_error THEN
1125: x_return_status := okl_api.handle_exceptions(l_api_name
1126: ,g_pkg_name
1127: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1128: ,x_msg_count
1129: ,x_msg_data

Line 1127: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1123: ,'_PVT');
1124: WHEN okc_api.g_exception_unexpected_error THEN
1125: x_return_status := okl_api.handle_exceptions(l_api_name
1126: ,g_pkg_name
1127: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1128: ,x_msg_count
1129: ,x_msg_data
1130: ,'_PVT');
1131: WHEN OTHERS THEN

Line 1132: x_return_status := okl_api.handle_exceptions(l_api_name

1128: ,x_msg_count
1129: ,x_msg_data
1130: ,'_PVT');
1131: WHEN OTHERS THEN
1132: x_return_status := okl_api.handle_exceptions(l_api_name
1133: ,g_pkg_name
1134: ,'OTHERS'
1135: ,x_msg_count
1136: ,x_msg_data

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

1148: ,x_msg_data OUT NOCOPY VARCHAR2
1149: ,p_etv_rec IN okl_etv_rec) IS
1150: l_api_version CONSTANT NUMBER := 1;
1151: l_api_name CONSTANT VARCHAR2(30) := 'v_delete_row';
1152: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1153: l_etv_rec okl_etv_rec := p_etv_rec;
1154:
1155: BEGIN
1156: l_return_status := okc_api.start_activity(l_api_name

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

1160: ,p_api_version
1161: ,'_PVT'
1162: ,x_return_status);
1163:
1164: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1165: RAISE okc_api.g_exception_unexpected_error;
1166: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1167: RAISE okc_api.g_exception_error;
1168: END IF;

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

1162: ,x_return_status);
1163:
1164: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1165: RAISE okc_api.g_exception_unexpected_error;
1166: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1167: RAISE okc_api.g_exception_error;
1168: END IF;
1169:
1170: DELETE FROM okl_fe_eo_term_values

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

1169:
1170: DELETE FROM okl_fe_eo_term_values
1171: WHERE end_of_term_value_id = l_etv_rec.end_of_term_value_id;
1172:
1173: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1174: RAISE okc_api.g_exception_unexpected_error;
1175: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1176: RAISE okc_api.g_exception_error;
1177: END IF;

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

1171: WHERE end_of_term_value_id = l_etv_rec.end_of_term_value_id;
1172:
1173: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1174: RAISE okc_api.g_exception_unexpected_error;
1175: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1176: RAISE okc_api.g_exception_error;
1177: END IF;
1178: okc_api.end_activity(x_msg_count
1179: ,x_msg_data);

Line 1184: x_return_status := okl_api.handle_exceptions(l_api_name

1180: EXCEPTION
1181: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
1182: NULL;
1183: WHEN okc_api.g_exception_error THEN
1184: x_return_status := okl_api.handle_exceptions(l_api_name
1185: ,g_pkg_name
1186: ,'OKL_API.G_RET_STS_ERROR'
1187: ,x_msg_count
1188: ,x_msg_data

Line 1186: ,'OKL_API.G_RET_STS_ERROR'

1182: NULL;
1183: WHEN okc_api.g_exception_error THEN
1184: x_return_status := okl_api.handle_exceptions(l_api_name
1185: ,g_pkg_name
1186: ,'OKL_API.G_RET_STS_ERROR'
1187: ,x_msg_count
1188: ,x_msg_data
1189: ,'_PVT');
1190: WHEN okc_api.g_exception_unexpected_error THEN

Line 1191: x_return_status := okl_api.handle_exceptions(l_api_name

1187: ,x_msg_count
1188: ,x_msg_data
1189: ,'_PVT');
1190: WHEN okc_api.g_exception_unexpected_error THEN
1191: x_return_status := okl_api.handle_exceptions(l_api_name
1192: ,g_pkg_name
1193: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1194: ,x_msg_count
1195: ,x_msg_data

Line 1193: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1189: ,'_PVT');
1190: WHEN okc_api.g_exception_unexpected_error THEN
1191: x_return_status := okl_api.handle_exceptions(l_api_name
1192: ,g_pkg_name
1193: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1194: ,x_msg_count
1195: ,x_msg_data
1196: ,'_PVT');
1197: WHEN OTHERS THEN

Line 1198: x_return_status := okl_api.handle_exceptions(l_api_name

1194: ,x_msg_count
1195: ,x_msg_data
1196: ,'_PVT');
1197: WHEN OTHERS THEN
1198: x_return_status := okl_api.handle_exceptions(l_api_name
1199: ,g_pkg_name
1200: ,'OTHERS'
1201: ,x_msg_count
1202: ,x_msg_data

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

1214: ,x_msg_data OUT NOCOPY VARCHAR2
1215: ,p_etv_tbl IN okl_etv_tbl) IS
1216: l_api_version CONSTANT NUMBER := 1;
1217: l_api_name CONSTANT VARCHAR2(30) := 'v_delete_row';
1218: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1219: i NUMBER := 0;
1220: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1221:
1222: BEGIN

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

1216: l_api_version CONSTANT NUMBER := 1;
1217: l_api_name CONSTANT VARCHAR2(30) := 'v_delete_row';
1218: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1219: i NUMBER := 0;
1220: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1221:
1222: BEGIN
1223: okc_api.init_msg_list(p_init_msg_list); -- Make sure PL/SQL table has records in it before passing
1224:

Line 1250: x_return_status := okl_api.handle_exceptions(l_api_name

1246: EXCEPTION
1247: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
1248: NULL;
1249: WHEN okc_api.g_exception_error THEN
1250: x_return_status := okl_api.handle_exceptions(l_api_name
1251: ,g_pkg_name
1252: ,'OKL_API.G_RET_STS_ERROR'
1253: ,x_msg_count
1254: ,x_msg_data

Line 1252: ,'OKL_API.G_RET_STS_ERROR'

1248: NULL;
1249: WHEN okc_api.g_exception_error THEN
1250: x_return_status := okl_api.handle_exceptions(l_api_name
1251: ,g_pkg_name
1252: ,'OKL_API.G_RET_STS_ERROR'
1253: ,x_msg_count
1254: ,x_msg_data
1255: ,'_PVT');
1256: WHEN okc_api.g_exception_unexpected_error THEN

Line 1257: x_return_status := okl_api.handle_exceptions(l_api_name

1253: ,x_msg_count
1254: ,x_msg_data
1255: ,'_PVT');
1256: WHEN okc_api.g_exception_unexpected_error THEN
1257: x_return_status := okl_api.handle_exceptions(l_api_name
1258: ,g_pkg_name
1259: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1260: ,x_msg_count
1261: ,x_msg_data

Line 1259: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1255: ,'_PVT');
1256: WHEN okc_api.g_exception_unexpected_error THEN
1257: x_return_status := okl_api.handle_exceptions(l_api_name
1258: ,g_pkg_name
1259: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1260: ,x_msg_count
1261: ,x_msg_data
1262: ,'_PVT');
1263: WHEN OTHERS THEN

Line 1264: x_return_status := okl_api.handle_exceptions(l_api_name

1260: ,x_msg_count
1261: ,x_msg_data
1262: ,'_PVT');
1263: WHEN OTHERS THEN
1264: x_return_status := okl_api.handle_exceptions(l_api_name
1265: ,g_pkg_name
1266: ,'OTHERS'
1267: ,x_msg_count
1268: ,x_msg_data