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_CSP_PVT dependencies on OKL_API

Line 31: x_return_status := OKL_API.G_RET_STS_SUCCESS;

27: FROM OKL_K_HEADERS khrv
28: WHERE khrv.id = p_khr_id);
29: BEGIN
30: -- initialize return status
31: x_return_status := OKL_API.G_RET_STS_SUCCESS;
32: -- data is required
33: IF (p_cspv_rec.khr_id = OKL_API.G_MISS_NUM) OR
34: (p_cspv_rec.khr_id IS NULL) THEN
35: -- halt validation as it is a required field

Line 33: IF (p_cspv_rec.khr_id = OKL_API.G_MISS_NUM) OR

29: BEGIN
30: -- initialize return status
31: x_return_status := OKL_API.G_RET_STS_SUCCESS;
32: -- data is required
33: IF (p_cspv_rec.khr_id = OKL_API.G_MISS_NUM) OR
34: (p_cspv_rec.khr_id IS NULL) THEN
35: -- halt validation as it is a required field
36: RAISE G_EXCEPTION_STOP_VALIDATION;
37: END IF;

Line 54: OKL_API.set_message(p_app_name => G_APP_NAME,

50: END IF;
51: EXCEPTION
52: WHEN G_EXCEPTION_STOP_VALIDATION then
53: -- We are here since the field is Required Value
54: OKL_API.set_message(p_app_name => G_APP_NAME,
55: p_msg_name => G_REQUIRED_VALUE,
56: p_token1 => G_COL_NAME_TOKEN,
57: p_token1_value => 'khr_id');
58: -- If the cursor is open then it has to be closed

Line 63: x_return_status := OKL_API.G_RET_STS_ERROR;

59: IF c_khr_id_validate%ISOPEN THEN
60: CLOSE c_khr_id_validate;
61: END IF;
62: -- notify caller of an error
63: x_return_status := OKL_API.G_RET_STS_ERROR;
64: WHEN G_EXCEPTION_HALT_VALIDATION then
65: -- We are here b'cause we have no parent record
66: -- store SQL error message on message stack
67: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 67: OKL_API.set_message(p_app_name => G_APP_NAME,

63: x_return_status := OKL_API.G_RET_STS_ERROR;
64: WHEN G_EXCEPTION_HALT_VALIDATION then
65: -- We are here b'cause we have no parent record
66: -- store SQL error message on message stack
67: OKL_API.set_message(p_app_name => G_APP_NAME,
68: p_msg_name => G_NO_MATCHING_RECORD,
69: p_token1 => G_COL_NAME_TOKEN,
70: p_token1_value => 'khr_id');
71: -- If the cursor is open then it has to be closed

Line 76: x_return_status := OKL_API.G_RET_STS_ERROR;

72: IF c_khr_id_validate%ISOPEN THEN
73: CLOSE c_khr_id_validate;
74: END IF;
75: -- notify caller of an error
76: x_return_status := OKL_API.G_RET_STS_ERROR;
77: WHEN OTHERS THEN
78: -- store SQL error message on message stack
79: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
80: p_msg_name => G_UNEXPECTED_ERROR,

Line 79: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

75: -- notify caller of an error
76: x_return_status := OKL_API.G_RET_STS_ERROR;
77: WHEN OTHERS THEN
78: -- store SQL error message on message stack
79: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
80: p_msg_name => G_UNEXPECTED_ERROR,
81: p_token1 => G_SQLCODE_TOKEN,
82: p_token1_value => SQLCODE,
83: p_token2 => G_SQLERRM_TOKEN,

Line 90: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

86: IF c_khr_id_validate%ISOPEN THEN
87: CLOSE c_khr_id_validate;
88: END IF;
89: -- notify caller of an error as UNEXPETED error
90: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
91: END validate_khr_id;
92: ----------------------------------------------------------------------------
93: -- Start of Commnets
94: -- Badrinath Kuchibholta

Line 114: x_return_status := OKL_API.G_RET_STS_SUCCESS;

110: FROM OKL_PDT_OPT_VALS
111: WHERE id = p_pov_id);
112: BEGIN
113: -- initialize return status
114: x_return_status := OKL_API.G_RET_STS_SUCCESS;
115: -- data is required
116: IF (p_cspv_rec.pov_id = OKL_API.G_MISS_NUM) OR
117: (p_cspv_rec.pov_id IS NULL) THEN
118: -- halt validation as it is a required field

Line 116: IF (p_cspv_rec.pov_id = OKL_API.G_MISS_NUM) OR

112: BEGIN
113: -- initialize return status
114: x_return_status := OKL_API.G_RET_STS_SUCCESS;
115: -- data is required
116: IF (p_cspv_rec.pov_id = OKL_API.G_MISS_NUM) OR
117: (p_cspv_rec.pov_id IS NULL) THEN
118: -- halt validation as it is a required field
119: RAISE G_EXCEPTION_STOP_VALIDATION;
120: END IF;

Line 136: OKL_API.set_message(p_app_name => G_APP_NAME,

132: END IF;
133: EXCEPTION
134: WHEN G_EXCEPTION_STOP_VALIDATION then
135: -- We are here since the field is Required Value
136: OKL_API.set_message(p_app_name => G_APP_NAME,
137: p_msg_name => G_REQUIRED_VALUE,
138: p_token1 => G_COL_NAME_TOKEN,
139: p_token1_value => 'pov_id');
140: -- If the cursor is open then it has to be closed

Line 145: x_return_status := OKL_API.G_RET_STS_ERROR;

141: IF c_pov_id_validate%ISOPEN THEN
142: CLOSE c_pov_id_validate;
143: END IF;
144: -- notify caller of an error
145: x_return_status := OKL_API.G_RET_STS_ERROR;
146: WHEN G_EXCEPTION_HALT_VALIDATION then
147: -- We are here b'cause we have no parent record
148: -- store SQL error message on message stack
149: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 149: OKL_API.set_message(p_app_name => G_APP_NAME,

145: x_return_status := OKL_API.G_RET_STS_ERROR;
146: WHEN G_EXCEPTION_HALT_VALIDATION then
147: -- We are here b'cause we have no parent record
148: -- store SQL error message on message stack
149: OKL_API.set_message(p_app_name => G_APP_NAME,
150: p_msg_name => G_NO_MATCHING_RECORD,
151: p_token1 => G_COL_NAME_TOKEN,
152: p_token1_value => 'pov_id');
153: IF c_pov_id_validate%ISOPEN THEN

Line 157: x_return_status := OKL_API.G_RET_STS_ERROR;

153: IF c_pov_id_validate%ISOPEN THEN
154: CLOSE c_pov_id_validate;
155: END IF;
156: -- notify caller of an error
157: x_return_status := OKL_API.G_RET_STS_ERROR;
158: WHEN OTHERS THEN
159: -- store SQL error message on message stack
160: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
161: p_msg_name => G_UNEXPECTED_ERROR,

Line 160: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

156: -- notify caller of an error
157: x_return_status := OKL_API.G_RET_STS_ERROR;
158: WHEN OTHERS THEN
159: -- store SQL error message on message stack
160: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
161: p_msg_name => G_UNEXPECTED_ERROR,
162: p_token1 => G_SQLCODE_TOKEN,
163: p_token1_value => SQLCODE,
164: p_token2 => G_SQLERRM_TOKEN,

Line 171: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

167: IF c_pov_id_validate%ISOPEN THEN
168: CLOSE c_pov_id_validate;
169: END IF;
170: -- notify caller of an error as UNEXPETED error
171: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
172: END validate_pov_id;
173: ---------------------------------------------------------------------------
174: -- FUNCTION get_seq_id
175: ---------------------------------------------------------------------------

Line 374: IF (l_cspv_rec.object_version_number = OKL_API.G_MISS_NUM) THEN

370: p_cspv_rec IN cspv_rec_type
371: ) RETURN cspv_rec_type IS
372: l_cspv_rec cspv_rec_type := p_cspv_rec;
373: BEGIN
374: IF (l_cspv_rec.object_version_number = OKL_API.G_MISS_NUM) THEN
375: l_cspv_rec.object_version_number := NULL;
376: END IF;
377: IF (l_cspv_rec.pov_id = OKL_API.G_MISS_NUM) THEN
378: l_cspv_rec.pov_id := NULL;

Line 377: IF (l_cspv_rec.pov_id = OKL_API.G_MISS_NUM) THEN

373: BEGIN
374: IF (l_cspv_rec.object_version_number = OKL_API.G_MISS_NUM) THEN
375: l_cspv_rec.object_version_number := NULL;
376: END IF;
377: IF (l_cspv_rec.pov_id = OKL_API.G_MISS_NUM) THEN
378: l_cspv_rec.pov_id := NULL;
379: END IF;
380: IF (l_cspv_rec.khr_id = OKL_API.G_MISS_NUM) THEN
381: l_cspv_rec.khr_id := NULL;

Line 380: IF (l_cspv_rec.khr_id = OKL_API.G_MISS_NUM) THEN

376: END IF;
377: IF (l_cspv_rec.pov_id = OKL_API.G_MISS_NUM) THEN
378: l_cspv_rec.pov_id := NULL;
379: END IF;
380: IF (l_cspv_rec.khr_id = OKL_API.G_MISS_NUM) THEN
381: l_cspv_rec.khr_id := NULL;
382: END IF;
383: IF (l_cspv_rec.attribute_category = OKL_API.G_MISS_NUM) THEN
384: l_cspv_rec.attribute_category := NULL;

Line 383: IF (l_cspv_rec.attribute_category = OKL_API.G_MISS_NUM) THEN

379: END IF;
380: IF (l_cspv_rec.khr_id = OKL_API.G_MISS_NUM) THEN
381: l_cspv_rec.khr_id := NULL;
382: END IF;
383: IF (l_cspv_rec.attribute_category = OKL_API.G_MISS_NUM) THEN
384: l_cspv_rec.attribute_category := NULL;
385: END IF;
386: IF (l_cspv_rec.attribute1 = OKL_API.G_MISS_NUM) THEN
387: l_cspv_rec.attribute1 := NULL;

Line 386: IF (l_cspv_rec.attribute1 = OKL_API.G_MISS_NUM) THEN

382: END IF;
383: IF (l_cspv_rec.attribute_category = OKL_API.G_MISS_NUM) THEN
384: l_cspv_rec.attribute_category := NULL;
385: END IF;
386: IF (l_cspv_rec.attribute1 = OKL_API.G_MISS_NUM) THEN
387: l_cspv_rec.attribute1 := NULL;
388: END IF;
389: IF (l_cspv_rec.attribute2 = OKL_API.G_MISS_NUM) THEN
390: l_cspv_rec.attribute2 := NULL;

Line 389: IF (l_cspv_rec.attribute2 = OKL_API.G_MISS_NUM) THEN

385: END IF;
386: IF (l_cspv_rec.attribute1 = OKL_API.G_MISS_NUM) THEN
387: l_cspv_rec.attribute1 := NULL;
388: END IF;
389: IF (l_cspv_rec.attribute2 = OKL_API.G_MISS_NUM) THEN
390: l_cspv_rec.attribute2 := NULL;
391: END IF;
392: IF (l_cspv_rec.attribute3 = OKL_API.G_MISS_NUM) THEN
393: l_cspv_rec.attribute3 := NULL;

Line 392: IF (l_cspv_rec.attribute3 = OKL_API.G_MISS_NUM) THEN

388: END IF;
389: IF (l_cspv_rec.attribute2 = OKL_API.G_MISS_NUM) THEN
390: l_cspv_rec.attribute2 := NULL;
391: END IF;
392: IF (l_cspv_rec.attribute3 = OKL_API.G_MISS_NUM) THEN
393: l_cspv_rec.attribute3 := NULL;
394: END IF;
395: IF (l_cspv_rec.attribute4 = OKL_API.G_MISS_NUM) THEN
396: l_cspv_rec.attribute4 := NULL;

Line 395: IF (l_cspv_rec.attribute4 = OKL_API.G_MISS_NUM) THEN

391: END IF;
392: IF (l_cspv_rec.attribute3 = OKL_API.G_MISS_NUM) THEN
393: l_cspv_rec.attribute3 := NULL;
394: END IF;
395: IF (l_cspv_rec.attribute4 = OKL_API.G_MISS_NUM) THEN
396: l_cspv_rec.attribute4 := NULL;
397: END IF;
398: IF (l_cspv_rec.attribute5 = OKL_API.G_MISS_NUM) THEN
399: l_cspv_rec.attribute5 := NULL;

Line 398: IF (l_cspv_rec.attribute5 = OKL_API.G_MISS_NUM) THEN

394: END IF;
395: IF (l_cspv_rec.attribute4 = OKL_API.G_MISS_NUM) THEN
396: l_cspv_rec.attribute4 := NULL;
397: END IF;
398: IF (l_cspv_rec.attribute5 = OKL_API.G_MISS_NUM) THEN
399: l_cspv_rec.attribute5 := NULL;
400: END IF;
401: IF (l_cspv_rec.attribute6 = OKL_API.G_MISS_NUM) THEN
402: l_cspv_rec.attribute6 := NULL;

Line 401: IF (l_cspv_rec.attribute6 = OKL_API.G_MISS_NUM) THEN

397: END IF;
398: IF (l_cspv_rec.attribute5 = OKL_API.G_MISS_NUM) THEN
399: l_cspv_rec.attribute5 := NULL;
400: END IF;
401: IF (l_cspv_rec.attribute6 = OKL_API.G_MISS_NUM) THEN
402: l_cspv_rec.attribute6 := NULL;
403: END IF;
404: IF (l_cspv_rec.attribute7 = OKL_API.G_MISS_NUM) THEN
405: l_cspv_rec.attribute7 := NULL;

Line 404: IF (l_cspv_rec.attribute7 = OKL_API.G_MISS_NUM) THEN

400: END IF;
401: IF (l_cspv_rec.attribute6 = OKL_API.G_MISS_NUM) THEN
402: l_cspv_rec.attribute6 := NULL;
403: END IF;
404: IF (l_cspv_rec.attribute7 = OKL_API.G_MISS_NUM) THEN
405: l_cspv_rec.attribute7 := NULL;
406: END IF;
407: IF (l_cspv_rec.attribute8 = OKL_API.G_MISS_NUM) THEN
408: l_cspv_rec.attribute8 := NULL;

Line 407: IF (l_cspv_rec.attribute8 = OKL_API.G_MISS_NUM) THEN

403: END IF;
404: IF (l_cspv_rec.attribute7 = OKL_API.G_MISS_NUM) THEN
405: l_cspv_rec.attribute7 := NULL;
406: END IF;
407: IF (l_cspv_rec.attribute8 = OKL_API.G_MISS_NUM) THEN
408: l_cspv_rec.attribute8 := NULL;
409: END IF;
410: IF (l_cspv_rec.attribute9 = OKL_API.G_MISS_NUM) THEN
411: l_cspv_rec.attribute9 := NULL;

Line 410: IF (l_cspv_rec.attribute9 = OKL_API.G_MISS_NUM) THEN

406: END IF;
407: IF (l_cspv_rec.attribute8 = OKL_API.G_MISS_NUM) THEN
408: l_cspv_rec.attribute8 := NULL;
409: END IF;
410: IF (l_cspv_rec.attribute9 = OKL_API.G_MISS_NUM) THEN
411: l_cspv_rec.attribute9 := NULL;
412: END IF;
413: IF (l_cspv_rec.attribute10 = OKL_API.G_MISS_NUM) THEN
414: l_cspv_rec.attribute10 := NULL;

Line 413: IF (l_cspv_rec.attribute10 = OKL_API.G_MISS_NUM) THEN

409: END IF;
410: IF (l_cspv_rec.attribute9 = OKL_API.G_MISS_NUM) THEN
411: l_cspv_rec.attribute9 := NULL;
412: END IF;
413: IF (l_cspv_rec.attribute10 = OKL_API.G_MISS_NUM) THEN
414: l_cspv_rec.attribute10 := NULL;
415: END IF;
416: IF (l_cspv_rec.attribute11 = OKL_API.G_MISS_NUM) THEN
417: l_cspv_rec.attribute11 := NULL;

Line 416: IF (l_cspv_rec.attribute11 = OKL_API.G_MISS_NUM) THEN

412: END IF;
413: IF (l_cspv_rec.attribute10 = OKL_API.G_MISS_NUM) THEN
414: l_cspv_rec.attribute10 := NULL;
415: END IF;
416: IF (l_cspv_rec.attribute11 = OKL_API.G_MISS_NUM) THEN
417: l_cspv_rec.attribute11 := NULL;
418: END IF;
419: IF (l_cspv_rec.attribute12 = OKL_API.G_MISS_NUM) THEN
420: l_cspv_rec.attribute12 := NULL;

Line 419: IF (l_cspv_rec.attribute12 = OKL_API.G_MISS_NUM) THEN

415: END IF;
416: IF (l_cspv_rec.attribute11 = OKL_API.G_MISS_NUM) THEN
417: l_cspv_rec.attribute11 := NULL;
418: END IF;
419: IF (l_cspv_rec.attribute12 = OKL_API.G_MISS_NUM) THEN
420: l_cspv_rec.attribute12 := NULL;
421: END IF;
422: IF (l_cspv_rec.attribute13 = OKL_API.G_MISS_NUM) THEN
423: l_cspv_rec.attribute13 := NULL;

Line 422: IF (l_cspv_rec.attribute13 = OKL_API.G_MISS_NUM) THEN

418: END IF;
419: IF (l_cspv_rec.attribute12 = OKL_API.G_MISS_NUM) THEN
420: l_cspv_rec.attribute12 := NULL;
421: END IF;
422: IF (l_cspv_rec.attribute13 = OKL_API.G_MISS_NUM) THEN
423: l_cspv_rec.attribute13 := NULL;
424: END IF;
425: IF (l_cspv_rec.attribute14 = OKL_API.G_MISS_NUM) THEN
426: l_cspv_rec.attribute14 := NULL;

Line 425: IF (l_cspv_rec.attribute14 = OKL_API.G_MISS_NUM) THEN

421: END IF;
422: IF (l_cspv_rec.attribute13 = OKL_API.G_MISS_NUM) THEN
423: l_cspv_rec.attribute13 := NULL;
424: END IF;
425: IF (l_cspv_rec.attribute14 = OKL_API.G_MISS_NUM) THEN
426: l_cspv_rec.attribute14 := NULL;
427: END IF;
428: IF (l_cspv_rec.attribute15 = OKL_API.G_MISS_NUM) THEN
429: l_cspv_rec.attribute15 := NULL;

Line 428: IF (l_cspv_rec.attribute15 = OKL_API.G_MISS_NUM) THEN

424: END IF;
425: IF (l_cspv_rec.attribute14 = OKL_API.G_MISS_NUM) THEN
426: l_cspv_rec.attribute14 := NULL;
427: END IF;
428: IF (l_cspv_rec.attribute15 = OKL_API.G_MISS_NUM) THEN
429: l_cspv_rec.attribute15 := NULL;
430: END IF;
431: IF (l_cspv_rec.created_by = OKL_API.G_MISS_NUM) THEN
432: l_cspv_rec.created_by := NULL;

Line 431: IF (l_cspv_rec.created_by = OKL_API.G_MISS_NUM) THEN

427: END IF;
428: IF (l_cspv_rec.attribute15 = OKL_API.G_MISS_NUM) THEN
429: l_cspv_rec.attribute15 := NULL;
430: END IF;
431: IF (l_cspv_rec.created_by = OKL_API.G_MISS_NUM) THEN
432: l_cspv_rec.created_by := NULL;
433: END IF;
434: IF (l_cspv_rec.creation_date = OKL_API.G_MISS_DATE) THEN
435: l_cspv_rec.creation_date := NULL;

Line 434: IF (l_cspv_rec.creation_date = OKL_API.G_MISS_DATE) THEN

430: END IF;
431: IF (l_cspv_rec.created_by = OKL_API.G_MISS_NUM) THEN
432: l_cspv_rec.created_by := NULL;
433: END IF;
434: IF (l_cspv_rec.creation_date = OKL_API.G_MISS_DATE) THEN
435: l_cspv_rec.creation_date := NULL;
436: END IF;
437: IF (l_cspv_rec.last_updated_by = OKL_API.G_MISS_NUM) THEN
438: l_cspv_rec.last_updated_by := NULL;

Line 437: IF (l_cspv_rec.last_updated_by = OKL_API.G_MISS_NUM) THEN

433: END IF;
434: IF (l_cspv_rec.creation_date = OKL_API.G_MISS_DATE) THEN
435: l_cspv_rec.creation_date := NULL;
436: END IF;
437: IF (l_cspv_rec.last_updated_by = OKL_API.G_MISS_NUM) THEN
438: l_cspv_rec.last_updated_by := NULL;
439: END IF;
440: IF (l_cspv_rec.last_update_date = OKL_API.G_MISS_DATE) THEN
441: l_cspv_rec.last_update_date := NULL;

Line 440: IF (l_cspv_rec.last_update_date = OKL_API.G_MISS_DATE) THEN

436: END IF;
437: IF (l_cspv_rec.last_updated_by = OKL_API.G_MISS_NUM) THEN
438: l_cspv_rec.last_updated_by := NULL;
439: END IF;
440: IF (l_cspv_rec.last_update_date = OKL_API.G_MISS_DATE) THEN
441: l_cspv_rec.last_update_date := NULL;
442: END IF;
443: IF (l_cspv_rec.last_update_login = OKL_API.G_MISS_NUM) THEN
444: l_cspv_rec.last_update_login := NULL;

Line 443: IF (l_cspv_rec.last_update_login = OKL_API.G_MISS_NUM) THEN

439: END IF;
440: IF (l_cspv_rec.last_update_date = OKL_API.G_MISS_DATE) THEN
441: l_cspv_rec.last_update_date := NULL;
442: END IF;
443: IF (l_cspv_rec.last_update_login = OKL_API.G_MISS_NUM) THEN
444: l_cspv_rec.last_update_login := NULL;
445: END IF;
446: RETURN(l_cspv_rec);
447: END null_out_defaults;

Line 457: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

453: -----------------------------------------------
454: FUNCTION Validate_Attributes (
455: p_cspv_rec IN cspv_rec_type
456: ) RETURN VARCHAR2 IS
457: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
458: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
459: BEGIN
460: IF p_cspv_rec.id = OKL_API.G_MISS_NUM OR
461: p_cspv_rec.id IS NULL THEN

Line 458: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

454: FUNCTION Validate_Attributes (
455: p_cspv_rec IN cspv_rec_type
456: ) RETURN VARCHAR2 IS
457: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
458: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
459: BEGIN
460: IF p_cspv_rec.id = OKL_API.G_MISS_NUM OR
461: p_cspv_rec.id IS NULL THEN
462: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

Line 460: IF p_cspv_rec.id = OKL_API.G_MISS_NUM OR

456: ) RETURN VARCHAR2 IS
457: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
458: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
459: BEGIN
460: IF p_cspv_rec.id = OKL_API.G_MISS_NUM OR
461: p_cspv_rec.id IS NULL THEN
462: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
463: l_return_status := OKL_API.G_RET_STS_ERROR;
464: ELSIF p_cspv_rec.object_version_number = OKL_API.G_MISS_NUM OR

Line 462: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

458: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
459: BEGIN
460: IF p_cspv_rec.id = OKL_API.G_MISS_NUM OR
461: p_cspv_rec.id IS NULL THEN
462: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
463: l_return_status := OKL_API.G_RET_STS_ERROR;
464: ELSIF p_cspv_rec.object_version_number = OKL_API.G_MISS_NUM OR
465: p_cspv_rec.object_version_number IS NULL THEN
466: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 463: l_return_status := OKL_API.G_RET_STS_ERROR;

459: BEGIN
460: IF p_cspv_rec.id = OKL_API.G_MISS_NUM OR
461: p_cspv_rec.id IS NULL THEN
462: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
463: l_return_status := OKL_API.G_RET_STS_ERROR;
464: ELSIF p_cspv_rec.object_version_number = OKL_API.G_MISS_NUM OR
465: p_cspv_rec.object_version_number IS NULL THEN
466: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
467: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 464: ELSIF p_cspv_rec.object_version_number = OKL_API.G_MISS_NUM OR

460: IF p_cspv_rec.id = OKL_API.G_MISS_NUM OR
461: p_cspv_rec.id IS NULL THEN
462: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
463: l_return_status := OKL_API.G_RET_STS_ERROR;
464: ELSIF p_cspv_rec.object_version_number = OKL_API.G_MISS_NUM OR
465: p_cspv_rec.object_version_number IS NULL THEN
466: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
467: l_return_status := OKL_API.G_RET_STS_ERROR;
468: END IF;

Line 466: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

462: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
463: l_return_status := OKL_API.G_RET_STS_ERROR;
464: ELSIF p_cspv_rec.object_version_number = OKL_API.G_MISS_NUM OR
465: p_cspv_rec.object_version_number IS NULL THEN
466: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
467: l_return_status := OKL_API.G_RET_STS_ERROR;
468: END IF;
469: validate_khr_id(x_return_status => l_return_status,
470: p_cspv_rec => p_cspv_rec);

Line 467: l_return_status := OKL_API.G_RET_STS_ERROR;

463: l_return_status := OKL_API.G_RET_STS_ERROR;
464: ELSIF p_cspv_rec.object_version_number = OKL_API.G_MISS_NUM OR
465: p_cspv_rec.object_version_number IS NULL THEN
466: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
467: l_return_status := OKL_API.G_RET_STS_ERROR;
468: END IF;
469: validate_khr_id(x_return_status => l_return_status,
470: p_cspv_rec => p_cspv_rec);
471: -- Store the Highest Degree of Error

Line 472: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

468: END IF;
469: validate_khr_id(x_return_status => l_return_status,
470: p_cspv_rec => p_cspv_rec);
471: -- Store the Highest Degree of Error
472: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
473: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
474: x_return_status := l_return_status;
475: END IF;
476: END IF;

Line 473: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

469: validate_khr_id(x_return_status => l_return_status,
470: p_cspv_rec => p_cspv_rec);
471: -- Store the Highest Degree of Error
472: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
473: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
474: x_return_status := l_return_status;
475: END IF;
476: END IF;
477: l_return_status := x_return_status;

Line 481: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

477: l_return_status := x_return_status;
478: validate_pov_id(x_return_status => l_return_status,
479: p_cspv_rec => p_cspv_rec);
480: -- Store the Highest Degree of Error
481: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
482: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
483: x_return_status := l_return_status;
484: END IF;
485: END IF;

Line 482: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

478: validate_pov_id(x_return_status => l_return_status,
479: p_cspv_rec => p_cspv_rec);
480: -- Store the Highest Degree of Error
481: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
482: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
483: x_return_status := l_return_status;
484: END IF;
485: END IF;
486: l_return_status := x_return_status;

Line 498: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

494: -------------------------------------------
495: FUNCTION Validate_Record (
496: p_cspv_rec IN cspv_rec_type
497: ) RETURN VARCHAR2 IS
498: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
499: BEGIN
500: RETURN (l_return_status);
501: END Validate_Record;
502:

Line 577: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

573: -- validate_row for:OKL_SLCTD_OPTNS_V --
574: ----------------------------------------
575: PROCEDURE validate_row(
576: p_api_version IN NUMBER,
577: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
578: x_return_status OUT NOCOPY VARCHAR2,
579: x_msg_count OUT NOCOPY NUMBER,
580: x_msg_data OUT NOCOPY VARCHAR2,
581: p_cspv_rec IN cspv_rec_type) IS

Line 585: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

581: p_cspv_rec IN cspv_rec_type) IS
582:
583: l_api_version CONSTANT NUMBER := 1;
584: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
585: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
586: l_cspv_rec cspv_rec_type := p_cspv_rec;
587: l_csp_rec csp_rec_type;
588: BEGIN
589: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 589: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

585: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
586: l_cspv_rec cspv_rec_type := p_cspv_rec;
587: l_csp_rec csp_rec_type;
588: BEGIN
589: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
590: G_PKG_NAME,
591: p_init_msg_list,
592: l_api_version,
593: p_api_version,

Line 596: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

592: l_api_version,
593: p_api_version,
594: '_PVT',
595: x_return_status);
596: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
597: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
598: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
599: RAISE OKL_API.G_EXCEPTION_ERROR;
600: END IF;

Line 597: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

593: p_api_version,
594: '_PVT',
595: x_return_status);
596: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
597: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
598: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
599: RAISE OKL_API.G_EXCEPTION_ERROR;
600: END IF;
601: --- Validate all non-missing attributes (Item Level Validation)

Line 598: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

594: '_PVT',
595: x_return_status);
596: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
597: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
598: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
599: RAISE OKL_API.G_EXCEPTION_ERROR;
600: END IF;
601: --- Validate all non-missing attributes (Item Level Validation)
602: l_return_status := Validate_Attributes(l_cspv_rec);

Line 599: RAISE OKL_API.G_EXCEPTION_ERROR;

595: x_return_status);
596: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
597: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
598: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
599: RAISE OKL_API.G_EXCEPTION_ERROR;
600: END IF;
601: --- Validate all non-missing attributes (Item Level Validation)
602: l_return_status := Validate_Attributes(l_cspv_rec);
603: --- If any errors happen abort API

Line 604: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

600: END IF;
601: --- Validate all non-missing attributes (Item Level Validation)
602: l_return_status := Validate_Attributes(l_cspv_rec);
603: --- If any errors happen abort API
604: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;

Line 605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

601: --- Validate all non-missing attributes (Item Level Validation)
602: l_return_status := Validate_Attributes(l_cspv_rec);
603: --- If any errors happen abort API
604: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;
609: l_return_status := Validate_Record(l_cspv_rec);

Line 606: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

602: l_return_status := Validate_Attributes(l_cspv_rec);
603: --- If any errors happen abort API
604: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;
609: l_return_status := Validate_Record(l_cspv_rec);
610: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 607: RAISE OKL_API.G_EXCEPTION_ERROR;

603: --- If any errors happen abort API
604: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;
609: l_return_status := Validate_Record(l_cspv_rec);
610: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 610: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

606: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;
609: l_return_status := Validate_Record(l_cspv_rec);
610: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;

Line 611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;
609: l_return_status := Validate_Record(l_cspv_rec);
610: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 612: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

608: END IF;
609: l_return_status := Validate_Record(l_cspv_rec);
610: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
616: EXCEPTION

Line 613: RAISE OKL_API.G_EXCEPTION_ERROR;

609: l_return_status := Validate_Record(l_cspv_rec);
610: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
616: EXCEPTION
617: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 615: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
616: EXCEPTION
617: WHEN OKL_API.G_EXCEPTION_ERROR THEN
618: x_return_status := OKL_API.HANDLE_EXCEPTIONS
619: (

Line 617: WHEN OKL_API.G_EXCEPTION_ERROR THEN

613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
616: EXCEPTION
617: WHEN OKL_API.G_EXCEPTION_ERROR THEN
618: x_return_status := OKL_API.HANDLE_EXCEPTIONS
619: (
620: l_api_name,
621: G_PKG_NAME,

Line 618: x_return_status := OKL_API.HANDLE_EXCEPTIONS

614: END IF;
615: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
616: EXCEPTION
617: WHEN OKL_API.G_EXCEPTION_ERROR THEN
618: x_return_status := OKL_API.HANDLE_EXCEPTIONS
619: (
620: l_api_name,
621: G_PKG_NAME,
622: 'OKL_API.G_RET_STS_ERROR',

Line 622: 'OKL_API.G_RET_STS_ERROR',

618: x_return_status := OKL_API.HANDLE_EXCEPTIONS
619: (
620: l_api_name,
621: G_PKG_NAME,
622: 'OKL_API.G_RET_STS_ERROR',
623: x_msg_count,
624: x_msg_data,
625: '_PVT'
626: );

Line 627: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

623: x_msg_count,
624: x_msg_data,
625: '_PVT'
626: );
627: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
628: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
629: (
630: l_api_name,
631: G_PKG_NAME,

Line 628: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

624: x_msg_data,
625: '_PVT'
626: );
627: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
628: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
629: (
630: l_api_name,
631: G_PKG_NAME,
632: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 632: 'OKL_API.G_RET_STS_UNEXP_ERROR',

628: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
629: (
630: l_api_name,
631: G_PKG_NAME,
632: 'OKL_API.G_RET_STS_UNEXP_ERROR',
633: x_msg_count,
634: x_msg_data,
635: '_PVT'
636: );

Line 638: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

634: x_msg_data,
635: '_PVT'
636: );
637: WHEN OTHERS THEN
638: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
639: (
640: l_api_name,
641: G_PKG_NAME,
642: 'OTHERS',

Line 653: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

649: -- PL/SQL TBL validate_row for:CSPV_TBL --
650: ------------------------------------------
651: PROCEDURE validate_row(
652: p_api_version IN NUMBER,
653: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
654: x_return_status OUT NOCOPY VARCHAR2,
655: x_msg_count OUT NOCOPY NUMBER,
656: x_msg_data OUT NOCOPY VARCHAR2,
657: p_cspv_tbl IN cspv_tbl_type) IS

Line 661: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

657: p_cspv_tbl IN cspv_tbl_type) IS
658:
659: l_api_version CONSTANT NUMBER := 1;
660: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
661: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
662: i NUMBER := 0;
663: BEGIN
664: OKL_API.init_msg_list(p_init_msg_list);
665: -- Make sure PL/SQL table has records in it before passing

Line 664: OKL_API.init_msg_list(p_init_msg_list);

660: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
661: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
662: i NUMBER := 0;
663: BEGIN
664: OKL_API.init_msg_list(p_init_msg_list);
665: -- Make sure PL/SQL table has records in it before passing
666: IF (p_cspv_tbl.COUNT > 0) THEN
667: i := p_cspv_tbl.FIRST;
668: LOOP

Line 671: p_init_msg_list => OKL_API.G_FALSE,

667: i := p_cspv_tbl.FIRST;
668: LOOP
669: validate_row (
670: p_api_version => p_api_version,
671: p_init_msg_list => OKL_API.G_FALSE,
672: x_return_status => x_return_status,
673: x_msg_count => x_msg_count,
674: x_msg_data => x_msg_data,
675: p_cspv_rec => p_cspv_tbl(i));

Line 681: WHEN OKL_API.G_EXCEPTION_ERROR THEN

677: i := p_cspv_tbl.NEXT(i);
678: END LOOP;
679: END IF;
680: EXCEPTION
681: WHEN OKL_API.G_EXCEPTION_ERROR THEN
682: x_return_status := OKL_API.HANDLE_EXCEPTIONS
683: (
684: l_api_name,
685: G_PKG_NAME,

Line 682: x_return_status := OKL_API.HANDLE_EXCEPTIONS

678: END LOOP;
679: END IF;
680: EXCEPTION
681: WHEN OKL_API.G_EXCEPTION_ERROR THEN
682: x_return_status := OKL_API.HANDLE_EXCEPTIONS
683: (
684: l_api_name,
685: G_PKG_NAME,
686: 'OKL_API.G_RET_STS_ERROR',

Line 686: 'OKL_API.G_RET_STS_ERROR',

682: x_return_status := OKL_API.HANDLE_EXCEPTIONS
683: (
684: l_api_name,
685: G_PKG_NAME,
686: 'OKL_API.G_RET_STS_ERROR',
687: x_msg_count,
688: x_msg_data,
689: '_PVT'
690: );

Line 691: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

687: x_msg_count,
688: x_msg_data,
689: '_PVT'
690: );
691: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
692: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
693: (
694: l_api_name,
695: G_PKG_NAME,

Line 692: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

688: x_msg_data,
689: '_PVT'
690: );
691: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
692: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
693: (
694: l_api_name,
695: G_PKG_NAME,
696: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 696: 'OKL_API.G_RET_STS_UNEXP_ERROR',

692: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
693: (
694: l_api_name,
695: G_PKG_NAME,
696: 'OKL_API.G_RET_STS_UNEXP_ERROR',
697: x_msg_count,
698: x_msg_data,
699: '_PVT'
700: );

Line 702: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

698: x_msg_data,
699: '_PVT'
700: );
701: WHEN OTHERS THEN
702: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
703: (
704: l_api_name,
705: G_PKG_NAME,
706: 'OTHERS',

Line 720: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

716: ------------------------------------
717: -- insert_row for:OKL_SLCTD_OPTNS --
718: ------------------------------------
719: PROCEDURE insert_row(
720: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
721: x_return_status OUT NOCOPY VARCHAR2,
722: x_msg_count OUT NOCOPY NUMBER,
723: x_msg_data OUT NOCOPY VARCHAR2,
724: p_csp_rec IN csp_rec_type,

Line 729: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

725: x_csp_rec OUT NOCOPY csp_rec_type) IS
726:
727: l_api_version CONSTANT NUMBER := 1;
728: l_api_name CONSTANT VARCHAR2(30) := 'OPTNS_insert_row';
729: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
730: l_csp_rec csp_rec_type := p_csp_rec;
731: l_def_csp_rec csp_rec_type;
732: ----------------------------------------
733: -- Set_Attributes for:OKL_SLCTD_OPTNS --

Line 739: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

735: FUNCTION Set_Attributes (
736: p_csp_rec IN csp_rec_type,
737: x_csp_rec OUT NOCOPY csp_rec_type
738: ) RETURN VARCHAR2 IS
739: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
740: BEGIN
741: x_csp_rec := p_csp_rec;
742: RETURN(l_return_status);
743: END Set_Attributes;

Line 745: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

741: x_csp_rec := p_csp_rec;
742: RETURN(l_return_status);
743: END Set_Attributes;
744: BEGIN
745: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
746: p_init_msg_list,
747: '_PVT',
748: x_return_status);
749: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 749: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

745: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
746: p_init_msg_list,
747: '_PVT',
748: x_return_status);
749: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
751: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
752: RAISE OKL_API.G_EXCEPTION_ERROR;
753: END IF;

Line 750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

746: p_init_msg_list,
747: '_PVT',
748: x_return_status);
749: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
751: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
752: RAISE OKL_API.G_EXCEPTION_ERROR;
753: END IF;
754: --- Setting item attributes

Line 751: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

747: '_PVT',
748: x_return_status);
749: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
751: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
752: RAISE OKL_API.G_EXCEPTION_ERROR;
753: END IF;
754: --- Setting item attributes
755: l_return_status := Set_Attributes(

Line 752: RAISE OKL_API.G_EXCEPTION_ERROR;

748: x_return_status);
749: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
751: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
752: RAISE OKL_API.G_EXCEPTION_ERROR;
753: END IF;
754: --- Setting item attributes
755: l_return_status := Set_Attributes(
756: p_csp_rec, -- IN

Line 759: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

755: l_return_status := Set_Attributes(
756: p_csp_rec, -- IN
757: l_csp_rec); -- OUT
758: --- If any errors happen abort API
759: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
761: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
762: RAISE OKL_API.G_EXCEPTION_ERROR;
763: END IF;

Line 760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

756: p_csp_rec, -- IN
757: l_csp_rec); -- OUT
758: --- If any errors happen abort API
759: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
761: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
762: RAISE OKL_API.G_EXCEPTION_ERROR;
763: END IF;
764: INSERT INTO OKL_SLCTD_OPTNS(

Line 761: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

757: l_csp_rec); -- OUT
758: --- If any errors happen abort API
759: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
761: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
762: RAISE OKL_API.G_EXCEPTION_ERROR;
763: END IF;
764: INSERT INTO OKL_SLCTD_OPTNS(
765: id,

Line 762: RAISE OKL_API.G_EXCEPTION_ERROR;

758: --- If any errors happen abort API
759: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
761: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
762: RAISE OKL_API.G_EXCEPTION_ERROR;
763: END IF;
764: INSERT INTO OKL_SLCTD_OPTNS(
765: id,
766: pov_id,

Line 818: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

814: l_csp_rec.last_update_date,
815: l_csp_rec.last_update_login);
816: -- Set OUT values
817: x_csp_rec := l_csp_rec;
818: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
819: EXCEPTION
820: WHEN OKL_API.G_EXCEPTION_ERROR THEN
821: x_return_status := OKL_API.HANDLE_EXCEPTIONS
822: (

Line 820: WHEN OKL_API.G_EXCEPTION_ERROR THEN

816: -- Set OUT values
817: x_csp_rec := l_csp_rec;
818: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
819: EXCEPTION
820: WHEN OKL_API.G_EXCEPTION_ERROR THEN
821: x_return_status := OKL_API.HANDLE_EXCEPTIONS
822: (
823: l_api_name,
824: G_PKG_NAME,

Line 821: x_return_status := OKL_API.HANDLE_EXCEPTIONS

817: x_csp_rec := l_csp_rec;
818: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
819: EXCEPTION
820: WHEN OKL_API.G_EXCEPTION_ERROR THEN
821: x_return_status := OKL_API.HANDLE_EXCEPTIONS
822: (
823: l_api_name,
824: G_PKG_NAME,
825: 'OKL_API.G_RET_STS_ERROR',

Line 825: 'OKL_API.G_RET_STS_ERROR',

821: x_return_status := OKL_API.HANDLE_EXCEPTIONS
822: (
823: l_api_name,
824: G_PKG_NAME,
825: 'OKL_API.G_RET_STS_ERROR',
826: x_msg_count,
827: x_msg_data,
828: '_PVT'
829: );

Line 830: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

826: x_msg_count,
827: x_msg_data,
828: '_PVT'
829: );
830: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
831: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
832: (
833: l_api_name,
834: G_PKG_NAME,

Line 831: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

827: x_msg_data,
828: '_PVT'
829: );
830: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
831: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
832: (
833: l_api_name,
834: G_PKG_NAME,
835: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 835: 'OKL_API.G_RET_STS_UNEXP_ERROR',

831: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
832: (
833: l_api_name,
834: G_PKG_NAME,
835: 'OKL_API.G_RET_STS_UNEXP_ERROR',
836: x_msg_count,
837: x_msg_data,
838: '_PVT'
839: );

Line 841: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

837: x_msg_data,
838: '_PVT'
839: );
840: WHEN OTHERS THEN
841: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
842: (
843: l_api_name,
844: G_PKG_NAME,
845: 'OTHERS',

Line 856: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

852: -- insert_row for:OKL_SLCTD_OPTNS_V --
853: --------------------------------------
854: PROCEDURE insert_row(
855: p_api_version IN NUMBER,
856: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
857: x_return_status OUT NOCOPY VARCHAR2,
858: x_msg_count OUT NOCOPY NUMBER,
859: x_msg_data OUT NOCOPY VARCHAR2,
860: p_cspv_rec IN cspv_rec_type,

Line 865: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

861: x_cspv_rec OUT NOCOPY cspv_rec_type) IS
862:
863: l_api_version CONSTANT NUMBER := 1;
864: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
865: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
866: l_cspv_rec cspv_rec_type;
867: l_def_cspv_rec cspv_rec_type;
868: l_csp_rec csp_rec_type;
869: lx_csp_rec csp_rec_type;

Line 892: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

888: FUNCTION Set_Attributes (
889: p_cspv_rec IN cspv_rec_type,
890: x_cspv_rec OUT NOCOPY cspv_rec_type
891: ) RETURN VARCHAR2 IS
892: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
893: BEGIN
894: x_cspv_rec := p_cspv_rec;
895: x_cspv_rec.OBJECT_VERSION_NUMBER := 1;
896: RETURN(l_return_status);

Line 899: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

895: x_cspv_rec.OBJECT_VERSION_NUMBER := 1;
896: RETURN(l_return_status);
897: END Set_Attributes;
898: BEGIN
899: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
900: G_PKG_NAME,
901: p_init_msg_list,
902: l_api_version,
903: p_api_version,

Line 906: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

902: l_api_version,
903: p_api_version,
904: '_PVT',
905: x_return_status);
906: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
907: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
908: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
909: RAISE OKL_API.G_EXCEPTION_ERROR;
910: END IF;

Line 907: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

903: p_api_version,
904: '_PVT',
905: x_return_status);
906: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
907: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
908: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
909: RAISE OKL_API.G_EXCEPTION_ERROR;
910: END IF;
911: l_cspv_rec := null_out_defaults(p_cspv_rec);

Line 908: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

904: '_PVT',
905: x_return_status);
906: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
907: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
908: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
909: RAISE OKL_API.G_EXCEPTION_ERROR;
910: END IF;
911: l_cspv_rec := null_out_defaults(p_cspv_rec);
912: -- Set primary key value

Line 909: RAISE OKL_API.G_EXCEPTION_ERROR;

905: x_return_status);
906: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
907: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
908: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
909: RAISE OKL_API.G_EXCEPTION_ERROR;
910: END IF;
911: l_cspv_rec := null_out_defaults(p_cspv_rec);
912: -- Set primary key value
913: l_cspv_rec.ID := get_seq_id;

Line 919: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

915: l_return_status := Set_Attributes(
916: l_cspv_rec, -- IN
917: l_def_cspv_rec); -- OUT
918: --- If any errors happen abort API
919: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
920: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
921: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
922: RAISE OKL_API.G_EXCEPTION_ERROR;
923: END IF;

Line 920: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

916: l_cspv_rec, -- IN
917: l_def_cspv_rec); -- OUT
918: --- If any errors happen abort API
919: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
920: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
921: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
922: RAISE OKL_API.G_EXCEPTION_ERROR;
923: END IF;
924: l_def_cspv_rec := fill_who_columns(l_def_cspv_rec);

Line 921: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

917: l_def_cspv_rec); -- OUT
918: --- If any errors happen abort API
919: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
920: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
921: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
922: RAISE OKL_API.G_EXCEPTION_ERROR;
923: END IF;
924: l_def_cspv_rec := fill_who_columns(l_def_cspv_rec);
925: --- Validate all non-missing attributes (Item Level Validation)

Line 922: RAISE OKL_API.G_EXCEPTION_ERROR;

918: --- If any errors happen abort API
919: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
920: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
921: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
922: RAISE OKL_API.G_EXCEPTION_ERROR;
923: END IF;
924: l_def_cspv_rec := fill_who_columns(l_def_cspv_rec);
925: --- Validate all non-missing attributes (Item Level Validation)
926: l_return_status := Validate_Attributes(l_def_cspv_rec);

Line 928: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

924: l_def_cspv_rec := fill_who_columns(l_def_cspv_rec);
925: --- Validate all non-missing attributes (Item Level Validation)
926: l_return_status := Validate_Attributes(l_def_cspv_rec);
927: --- If any errors happen abort API
928: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
929: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
930: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
931: RAISE OKL_API.G_EXCEPTION_ERROR;
932: END IF;

Line 929: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

925: --- Validate all non-missing attributes (Item Level Validation)
926: l_return_status := Validate_Attributes(l_def_cspv_rec);
927: --- If any errors happen abort API
928: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
929: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
930: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
931: RAISE OKL_API.G_EXCEPTION_ERROR;
932: END IF;
933: l_return_status := Validate_Record(l_def_cspv_rec);

Line 930: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

926: l_return_status := Validate_Attributes(l_def_cspv_rec);
927: --- If any errors happen abort API
928: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
929: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
930: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
931: RAISE OKL_API.G_EXCEPTION_ERROR;
932: END IF;
933: l_return_status := Validate_Record(l_def_cspv_rec);
934: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 931: RAISE OKL_API.G_EXCEPTION_ERROR;

927: --- If any errors happen abort API
928: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
929: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
930: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
931: RAISE OKL_API.G_EXCEPTION_ERROR;
932: END IF;
933: l_return_status := Validate_Record(l_def_cspv_rec);
934: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 934: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

930: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
931: RAISE OKL_API.G_EXCEPTION_ERROR;
932: END IF;
933: l_return_status := Validate_Record(l_def_cspv_rec);
934: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
937: RAISE OKL_API.G_EXCEPTION_ERROR;
938: END IF;

Line 935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

931: RAISE OKL_API.G_EXCEPTION_ERROR;
932: END IF;
933: l_return_status := Validate_Record(l_def_cspv_rec);
934: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
937: RAISE OKL_API.G_EXCEPTION_ERROR;
938: END IF;
939: --------------------------------------

Line 936: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

932: END IF;
933: l_return_status := Validate_Record(l_def_cspv_rec);
934: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
937: RAISE OKL_API.G_EXCEPTION_ERROR;
938: END IF;
939: --------------------------------------
940: -- Move VIEW record to "Child" records

Line 937: RAISE OKL_API.G_EXCEPTION_ERROR;

933: l_return_status := Validate_Record(l_def_cspv_rec);
934: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
937: RAISE OKL_API.G_EXCEPTION_ERROR;
938: END IF;
939: --------------------------------------
940: -- Move VIEW record to "Child" records
941: --------------------------------------

Line 954: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

950: x_msg_data,
951: l_csp_rec,
952: lx_csp_rec
953: );
954: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
955: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
956: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
957: RAISE OKL_API.G_EXCEPTION_ERROR;
958: END IF;

Line 955: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

951: l_csp_rec,
952: lx_csp_rec
953: );
954: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
955: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
956: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
957: RAISE OKL_API.G_EXCEPTION_ERROR;
958: END IF;
959: migrate(lx_csp_rec, l_def_cspv_rec);

Line 956: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

952: lx_csp_rec
953: );
954: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
955: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
956: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
957: RAISE OKL_API.G_EXCEPTION_ERROR;
958: END IF;
959: migrate(lx_csp_rec, l_def_cspv_rec);
960: -- Set OUT values

Line 957: RAISE OKL_API.G_EXCEPTION_ERROR;

953: );
954: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
955: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
956: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
957: RAISE OKL_API.G_EXCEPTION_ERROR;
958: END IF;
959: migrate(lx_csp_rec, l_def_cspv_rec);
960: -- Set OUT values
961: x_cspv_rec := l_def_cspv_rec;

Line 962: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

958: END IF;
959: migrate(lx_csp_rec, l_def_cspv_rec);
960: -- Set OUT values
961: x_cspv_rec := l_def_cspv_rec;
962: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
963: EXCEPTION
964: WHEN OKL_API.G_EXCEPTION_ERROR THEN
965: x_return_status := OKL_API.HANDLE_EXCEPTIONS
966: (

Line 964: WHEN OKL_API.G_EXCEPTION_ERROR THEN

960: -- Set OUT values
961: x_cspv_rec := l_def_cspv_rec;
962: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
963: EXCEPTION
964: WHEN OKL_API.G_EXCEPTION_ERROR THEN
965: x_return_status := OKL_API.HANDLE_EXCEPTIONS
966: (
967: l_api_name,
968: G_PKG_NAME,

Line 965: x_return_status := OKL_API.HANDLE_EXCEPTIONS

961: x_cspv_rec := l_def_cspv_rec;
962: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
963: EXCEPTION
964: WHEN OKL_API.G_EXCEPTION_ERROR THEN
965: x_return_status := OKL_API.HANDLE_EXCEPTIONS
966: (
967: l_api_name,
968: G_PKG_NAME,
969: 'OKL_API.G_RET_STS_ERROR',

Line 969: 'OKL_API.G_RET_STS_ERROR',

965: x_return_status := OKL_API.HANDLE_EXCEPTIONS
966: (
967: l_api_name,
968: G_PKG_NAME,
969: 'OKL_API.G_RET_STS_ERROR',
970: x_msg_count,
971: x_msg_data,
972: '_PVT'
973: );

Line 974: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

970: x_msg_count,
971: x_msg_data,
972: '_PVT'
973: );
974: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
975: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
976: (
977: l_api_name,
978: G_PKG_NAME,

Line 975: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

971: x_msg_data,
972: '_PVT'
973: );
974: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
975: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
976: (
977: l_api_name,
978: G_PKG_NAME,
979: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 979: 'OKL_API.G_RET_STS_UNEXP_ERROR',

975: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
976: (
977: l_api_name,
978: G_PKG_NAME,
979: 'OKL_API.G_RET_STS_UNEXP_ERROR',
980: x_msg_count,
981: x_msg_data,
982: '_PVT'
983: );

Line 985: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

981: x_msg_data,
982: '_PVT'
983: );
984: WHEN OTHERS THEN
985: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
986: (
987: l_api_name,
988: G_PKG_NAME,
989: 'OTHERS',

Line 1000: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

996: -- PL/SQL TBL insert_row for:CSPV_TBL --
997: ----------------------------------------
998: PROCEDURE insert_row(
999: p_api_version IN NUMBER,
1000: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1001: x_return_status OUT NOCOPY VARCHAR2,
1002: x_msg_count OUT NOCOPY NUMBER,
1003: x_msg_data OUT NOCOPY VARCHAR2,
1004: p_cspv_tbl IN cspv_tbl_type,

Line 1009: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1005: x_cspv_tbl OUT NOCOPY cspv_tbl_type) IS
1006:
1007: l_api_version CONSTANT NUMBER := 1;
1008: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1009: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1010: i NUMBER := 0;
1011: BEGIN
1012: OKL_API.init_msg_list(p_init_msg_list);
1013: -- Make sure PL/SQL table has records in it before passing

Line 1012: OKL_API.init_msg_list(p_init_msg_list);

1008: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1009: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1010: i NUMBER := 0;
1011: BEGIN
1012: OKL_API.init_msg_list(p_init_msg_list);
1013: -- Make sure PL/SQL table has records in it before passing
1014: IF (p_cspv_tbl.COUNT > 0) THEN
1015: i := p_cspv_tbl.FIRST;
1016: LOOP

Line 1019: p_init_msg_list => OKL_API.G_FALSE,

1015: i := p_cspv_tbl.FIRST;
1016: LOOP
1017: insert_row (
1018: p_api_version => p_api_version,
1019: p_init_msg_list => OKL_API.G_FALSE,
1020: x_return_status => x_return_status,
1021: x_msg_count => x_msg_count,
1022: x_msg_data => x_msg_data,
1023: p_cspv_rec => p_cspv_tbl(i),

Line 1030: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1026: i := p_cspv_tbl.NEXT(i);
1027: END LOOP;
1028: END IF;
1029: EXCEPTION
1030: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1031: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1032: (
1033: l_api_name,
1034: G_PKG_NAME,

Line 1031: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1027: END LOOP;
1028: END IF;
1029: EXCEPTION
1030: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1031: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1032: (
1033: l_api_name,
1034: G_PKG_NAME,
1035: 'OKL_API.G_RET_STS_ERROR',

Line 1035: 'OKL_API.G_RET_STS_ERROR',

1031: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1032: (
1033: l_api_name,
1034: G_PKG_NAME,
1035: 'OKL_API.G_RET_STS_ERROR',
1036: x_msg_count,
1037: x_msg_data,
1038: '_PVT'
1039: );

Line 1040: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1036: x_msg_count,
1037: x_msg_data,
1038: '_PVT'
1039: );
1040: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1041: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1042: (
1043: l_api_name,
1044: G_PKG_NAME,

Line 1041: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1037: x_msg_data,
1038: '_PVT'
1039: );
1040: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1041: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1042: (
1043: l_api_name,
1044: G_PKG_NAME,
1045: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1045: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1041: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1042: (
1043: l_api_name,
1044: G_PKG_NAME,
1045: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1046: x_msg_count,
1047: x_msg_data,
1048: '_PVT'
1049: );

Line 1051: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1047: x_msg_data,
1048: '_PVT'
1049: );
1050: WHEN OTHERS THEN
1051: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1052: (
1053: l_api_name,
1054: G_PKG_NAME,
1055: 'OTHERS',

Line 1069: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1065: ----------------------------------
1066: -- lock_row for:OKL_SLCTD_OPTNS --
1067: ----------------------------------
1068: PROCEDURE lock_row(
1069: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1070: x_return_status OUT NOCOPY VARCHAR2,
1071: x_msg_count OUT NOCOPY NUMBER,
1072: x_msg_data OUT NOCOPY VARCHAR2,
1073: p_csp_rec IN csp_rec_type) IS

Line 1090: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1086: FROM OKL_SLCTD_OPTNS
1087: WHERE ID = p_csp_rec.id;
1088: l_api_version CONSTANT NUMBER := 1;
1089: l_api_name CONSTANT VARCHAR2(30) := 'OPTNS_lock_row';
1090: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1091: l_object_version_number OKL_SLCTD_OPTNS.OBJECT_VERSION_NUMBER%TYPE;
1092: lc_object_version_number OKL_SLCTD_OPTNS.OBJECT_VERSION_NUMBER%TYPE;
1093: l_row_notfound BOOLEAN := FALSE;
1094: lc_row_notfound BOOLEAN := FALSE;

Line 1096: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1092: lc_object_version_number OKL_SLCTD_OPTNS.OBJECT_VERSION_NUMBER%TYPE;
1093: l_row_notfound BOOLEAN := FALSE;
1094: lc_row_notfound BOOLEAN := FALSE;
1095: BEGIN
1096: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1097: p_init_msg_list,
1098: '_PVT',
1099: x_return_status);
1100: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1100: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1096: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1097: p_init_msg_list,
1098: '_PVT',
1099: x_return_status);
1100: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1102: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1103: RAISE OKL_API.G_EXCEPTION_ERROR;
1104: END IF;

Line 1101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1097: p_init_msg_list,
1098: '_PVT',
1099: x_return_status);
1100: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1102: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1103: RAISE OKL_API.G_EXCEPTION_ERROR;
1104: END IF;
1105: BEGIN

Line 1102: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1098: '_PVT',
1099: x_return_status);
1100: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1102: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1103: RAISE OKL_API.G_EXCEPTION_ERROR;
1104: END IF;
1105: BEGIN
1106: OPEN lock_csr(p_csp_rec);

Line 1103: RAISE OKL_API.G_EXCEPTION_ERROR;

1099: x_return_status);
1100: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1102: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1103: RAISE OKL_API.G_EXCEPTION_ERROR;
1104: END IF;
1105: BEGIN
1106: OPEN lock_csr(p_csp_rec);
1107: FETCH lock_csr INTO l_object_version_number;

Line 1115: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1111: WHEN E_Resource_Busy THEN
1112: IF (lock_csr%ISOPEN) THEN
1113: CLOSE lock_csr;
1114: END IF;
1115: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1116: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1117: END;
1118:
1119: IF ( l_row_notfound ) THEN

Line 1126: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1122: lc_row_notfound := lchk_csr%NOTFOUND;
1123: CLOSE lchk_csr;
1124: END IF;
1125: IF (lc_row_notfound) THEN
1126: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1127: RAISE OKL_API.G_EXCEPTION_ERROR;
1128: ELSIF lc_object_version_number > p_csp_rec.object_version_number THEN
1129: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1130: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1127: RAISE OKL_API.G_EXCEPTION_ERROR;

1123: CLOSE lchk_csr;
1124: END IF;
1125: IF (lc_row_notfound) THEN
1126: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1127: RAISE OKL_API.G_EXCEPTION_ERROR;
1128: ELSIF lc_object_version_number > p_csp_rec.object_version_number THEN
1129: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1130: RAISE OKL_API.G_EXCEPTION_ERROR;
1131: ELSIF lc_object_version_number <> p_csp_rec.object_version_number THEN

Line 1129: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1125: IF (lc_row_notfound) THEN
1126: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1127: RAISE OKL_API.G_EXCEPTION_ERROR;
1128: ELSIF lc_object_version_number > p_csp_rec.object_version_number THEN
1129: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1130: RAISE OKL_API.G_EXCEPTION_ERROR;
1131: ELSIF lc_object_version_number <> p_csp_rec.object_version_number THEN
1132: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1133: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1130: RAISE OKL_API.G_EXCEPTION_ERROR;

1126: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1127: RAISE OKL_API.G_EXCEPTION_ERROR;
1128: ELSIF lc_object_version_number > p_csp_rec.object_version_number THEN
1129: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1130: RAISE OKL_API.G_EXCEPTION_ERROR;
1131: ELSIF lc_object_version_number <> p_csp_rec.object_version_number THEN
1132: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: ELSIF lc_object_version_number = -1 THEN

Line 1132: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1128: ELSIF lc_object_version_number > p_csp_rec.object_version_number THEN
1129: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1130: RAISE OKL_API.G_EXCEPTION_ERROR;
1131: ELSIF lc_object_version_number <> p_csp_rec.object_version_number THEN
1132: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: ELSIF lc_object_version_number = -1 THEN
1135: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1136: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1133: RAISE OKL_API.G_EXCEPTION_ERROR;

1129: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1130: RAISE OKL_API.G_EXCEPTION_ERROR;
1131: ELSIF lc_object_version_number <> p_csp_rec.object_version_number THEN
1132: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: ELSIF lc_object_version_number = -1 THEN
1135: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1136: RAISE OKL_API.G_EXCEPTION_ERROR;
1137: END IF;

Line 1135: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1131: ELSIF lc_object_version_number <> p_csp_rec.object_version_number THEN
1132: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: ELSIF lc_object_version_number = -1 THEN
1135: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1136: RAISE OKL_API.G_EXCEPTION_ERROR;
1137: END IF;
1138: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1139: EXCEPTION

Line 1136: RAISE OKL_API.G_EXCEPTION_ERROR;

1132: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: ELSIF lc_object_version_number = -1 THEN
1135: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1136: RAISE OKL_API.G_EXCEPTION_ERROR;
1137: END IF;
1138: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1139: EXCEPTION
1140: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1138: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1134: ELSIF lc_object_version_number = -1 THEN
1135: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1136: RAISE OKL_API.G_EXCEPTION_ERROR;
1137: END IF;
1138: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1139: EXCEPTION
1140: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1141: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1142: (

Line 1140: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1136: RAISE OKL_API.G_EXCEPTION_ERROR;
1137: END IF;
1138: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1139: EXCEPTION
1140: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1141: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1142: (
1143: l_api_name,
1144: G_PKG_NAME,

Line 1141: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1137: END IF;
1138: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1139: EXCEPTION
1140: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1141: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1142: (
1143: l_api_name,
1144: G_PKG_NAME,
1145: 'OKL_API.G_RET_STS_ERROR',

Line 1145: 'OKL_API.G_RET_STS_ERROR',

1141: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1142: (
1143: l_api_name,
1144: G_PKG_NAME,
1145: 'OKL_API.G_RET_STS_ERROR',
1146: x_msg_count,
1147: x_msg_data,
1148: '_PVT'
1149: );

Line 1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1146: x_msg_count,
1147: x_msg_data,
1148: '_PVT'
1149: );
1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1151: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1152: (
1153: l_api_name,
1154: G_PKG_NAME,

Line 1151: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1147: x_msg_data,
1148: '_PVT'
1149: );
1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1151: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1152: (
1153: l_api_name,
1154: G_PKG_NAME,
1155: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1155: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1151: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1152: (
1153: l_api_name,
1154: G_PKG_NAME,
1155: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1156: x_msg_count,
1157: x_msg_data,
1158: '_PVT'
1159: );

Line 1161: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1157: x_msg_data,
1158: '_PVT'
1159: );
1160: WHEN OTHERS THEN
1161: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1162: (
1163: l_api_name,
1164: G_PKG_NAME,
1165: 'OTHERS',

Line 1176: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1172: -- lock_row for:OKL_SLCTD_OPTNS_V --
1173: ------------------------------------
1174: PROCEDURE lock_row(
1175: p_api_version IN NUMBER,
1176: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1177: x_return_status OUT NOCOPY VARCHAR2,
1178: x_msg_count OUT NOCOPY NUMBER,
1179: x_msg_data OUT NOCOPY VARCHAR2,
1180: p_cspv_rec IN cspv_rec_type) IS

Line 1184: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1180: p_cspv_rec IN cspv_rec_type) IS
1181:
1182: l_api_version CONSTANT NUMBER := 1;
1183: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1184: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1185: l_csp_rec csp_rec_type;
1186: BEGIN
1187: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1188: G_PKG_NAME,

Line 1187: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1183: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1184: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1185: l_csp_rec csp_rec_type;
1186: BEGIN
1187: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1188: G_PKG_NAME,
1189: p_init_msg_list,
1190: l_api_version,
1191: p_api_version,

Line 1194: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1190: l_api_version,
1191: p_api_version,
1192: '_PVT',
1193: x_return_status);
1194: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1196: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1197: RAISE OKL_API.G_EXCEPTION_ERROR;
1198: END IF;

Line 1195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1191: p_api_version,
1192: '_PVT',
1193: x_return_status);
1194: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1196: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1197: RAISE OKL_API.G_EXCEPTION_ERROR;
1198: END IF;
1199: --------------------------------------

Line 1196: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1192: '_PVT',
1193: x_return_status);
1194: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1196: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1197: RAISE OKL_API.G_EXCEPTION_ERROR;
1198: END IF;
1199: --------------------------------------
1200: -- Move VIEW record to "Child" records

Line 1197: RAISE OKL_API.G_EXCEPTION_ERROR;

1193: x_return_status);
1194: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1196: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1197: RAISE OKL_API.G_EXCEPTION_ERROR;
1198: END IF;
1199: --------------------------------------
1200: -- Move VIEW record to "Child" records
1201: --------------------------------------

Line 1213: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1209: x_msg_count,
1210: x_msg_data,
1211: l_csp_rec
1212: );
1213: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1215: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1216: RAISE OKL_API.G_EXCEPTION_ERROR;
1217: END IF;

Line 1214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1210: x_msg_data,
1211: l_csp_rec
1212: );
1213: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1215: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1216: RAISE OKL_API.G_EXCEPTION_ERROR;
1217: END IF;
1218: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1215: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1211: l_csp_rec
1212: );
1213: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1215: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1216: RAISE OKL_API.G_EXCEPTION_ERROR;
1217: END IF;
1218: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1219: EXCEPTION

Line 1216: RAISE OKL_API.G_EXCEPTION_ERROR;

1212: );
1213: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1215: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1216: RAISE OKL_API.G_EXCEPTION_ERROR;
1217: END IF;
1218: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1219: EXCEPTION
1220: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1218: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1215: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1216: RAISE OKL_API.G_EXCEPTION_ERROR;
1217: END IF;
1218: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1219: EXCEPTION
1220: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1221: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1222: (

Line 1220: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1216: RAISE OKL_API.G_EXCEPTION_ERROR;
1217: END IF;
1218: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1219: EXCEPTION
1220: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1221: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1222: (
1223: l_api_name,
1224: G_PKG_NAME,

Line 1221: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1217: END IF;
1218: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1219: EXCEPTION
1220: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1221: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1222: (
1223: l_api_name,
1224: G_PKG_NAME,
1225: 'OKL_API.G_RET_STS_ERROR',

Line 1225: 'OKL_API.G_RET_STS_ERROR',

1221: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1222: (
1223: l_api_name,
1224: G_PKG_NAME,
1225: 'OKL_API.G_RET_STS_ERROR',
1226: x_msg_count,
1227: x_msg_data,
1228: '_PVT'
1229: );

Line 1230: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1226: x_msg_count,
1227: x_msg_data,
1228: '_PVT'
1229: );
1230: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1231: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1232: (
1233: l_api_name,
1234: G_PKG_NAME,

Line 1231: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1227: x_msg_data,
1228: '_PVT'
1229: );
1230: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1231: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1232: (
1233: l_api_name,
1234: G_PKG_NAME,
1235: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1235: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1231: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1232: (
1233: l_api_name,
1234: G_PKG_NAME,
1235: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1236: x_msg_count,
1237: x_msg_data,
1238: '_PVT'
1239: );

Line 1241: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1237: x_msg_data,
1238: '_PVT'
1239: );
1240: WHEN OTHERS THEN
1241: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1242: (
1243: l_api_name,
1244: G_PKG_NAME,
1245: 'OTHERS',

Line 1256: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1252: -- PL/SQL TBL lock_row for:CSPV_TBL --
1253: --------------------------------------
1254: PROCEDURE lock_row(
1255: p_api_version IN NUMBER,
1256: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1257: x_return_status OUT NOCOPY VARCHAR2,
1258: x_msg_count OUT NOCOPY NUMBER,
1259: x_msg_data OUT NOCOPY VARCHAR2,
1260: p_cspv_tbl IN cspv_tbl_type) IS

Line 1264: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1260: p_cspv_tbl IN cspv_tbl_type) IS
1261:
1262: l_api_version CONSTANT NUMBER := 1;
1263: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1264: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1265: i NUMBER := 0;
1266: BEGIN
1267: OKL_API.init_msg_list(p_init_msg_list);
1268: -- Make sure PL/SQL table has records in it before passing

Line 1267: OKL_API.init_msg_list(p_init_msg_list);

1263: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1264: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1265: i NUMBER := 0;
1266: BEGIN
1267: OKL_API.init_msg_list(p_init_msg_list);
1268: -- Make sure PL/SQL table has records in it before passing
1269: IF (p_cspv_tbl.COUNT > 0) THEN
1270: i := p_cspv_tbl.FIRST;
1271: LOOP

Line 1274: p_init_msg_list => OKL_API.G_FALSE,

1270: i := p_cspv_tbl.FIRST;
1271: LOOP
1272: lock_row (
1273: p_api_version => p_api_version,
1274: p_init_msg_list => OKL_API.G_FALSE,
1275: x_return_status => x_return_status,
1276: x_msg_count => x_msg_count,
1277: x_msg_data => x_msg_data,
1278: p_cspv_rec => p_cspv_tbl(i));

Line 1284: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1280: i := p_cspv_tbl.NEXT(i);
1281: END LOOP;
1282: END IF;
1283: EXCEPTION
1284: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1285: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1286: (
1287: l_api_name,
1288: G_PKG_NAME,

Line 1285: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1281: END LOOP;
1282: END IF;
1283: EXCEPTION
1284: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1285: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1286: (
1287: l_api_name,
1288: G_PKG_NAME,
1289: 'OKL_API.G_RET_STS_ERROR',

Line 1289: 'OKL_API.G_RET_STS_ERROR',

1285: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1286: (
1287: l_api_name,
1288: G_PKG_NAME,
1289: 'OKL_API.G_RET_STS_ERROR',
1290: x_msg_count,
1291: x_msg_data,
1292: '_PVT'
1293: );

Line 1294: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1290: x_msg_count,
1291: x_msg_data,
1292: '_PVT'
1293: );
1294: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1295: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1296: (
1297: l_api_name,
1298: G_PKG_NAME,

Line 1295: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1291: x_msg_data,
1292: '_PVT'
1293: );
1294: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1295: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1296: (
1297: l_api_name,
1298: G_PKG_NAME,
1299: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1299: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1295: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1296: (
1297: l_api_name,
1298: G_PKG_NAME,
1299: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1300: x_msg_count,
1301: x_msg_data,
1302: '_PVT'
1303: );

Line 1305: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1301: x_msg_data,
1302: '_PVT'
1303: );
1304: WHEN OTHERS THEN
1305: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1306: (
1307: l_api_name,
1308: G_PKG_NAME,
1309: 'OTHERS',

Line 1323: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1319: ------------------------------------
1320: -- update_row for:OKL_SLCTD_OPTNS --
1321: ------------------------------------
1322: PROCEDURE update_row(
1323: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1324: x_return_status OUT NOCOPY VARCHAR2,
1325: x_msg_count OUT NOCOPY NUMBER,
1326: x_msg_data OUT NOCOPY VARCHAR2,
1327: p_csp_rec IN csp_rec_type,

Line 1332: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1328: x_csp_rec OUT NOCOPY csp_rec_type) IS
1329:
1330: l_api_version CONSTANT NUMBER := 1;
1331: l_api_name CONSTANT VARCHAR2(30) := 'OPTNS_update_row';
1332: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1333: l_csp_rec csp_rec_type := p_csp_rec;
1334: l_def_csp_rec csp_rec_type;
1335: l_row_notfound BOOLEAN := TRUE;
1336: ----------------------------------

Line 1345: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1341: x_csp_rec OUT NOCOPY csp_rec_type
1342: ) RETURN VARCHAR2 IS
1343: l_csp_rec csp_rec_type;
1344: l_row_notfound BOOLEAN := TRUE;
1345: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1346: BEGIN
1347: x_csp_rec := p_csp_rec;
1348: -- Get current database values
1349: l_csp_rec := get_rec(p_csp_rec, l_row_notfound);

Line 1351: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1347: x_csp_rec := p_csp_rec;
1348: -- Get current database values
1349: l_csp_rec := get_rec(p_csp_rec, l_row_notfound);
1350: IF (l_row_notfound) THEN
1351: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1352: END IF;
1353: IF (x_csp_rec.id = OKL_API.G_MISS_NUM)
1354: THEN
1355: x_csp_rec.id := l_csp_rec.id;

Line 1353: IF (x_csp_rec.id = OKL_API.G_MISS_NUM)

1349: l_csp_rec := get_rec(p_csp_rec, l_row_notfound);
1350: IF (l_row_notfound) THEN
1351: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1352: END IF;
1353: IF (x_csp_rec.id = OKL_API.G_MISS_NUM)
1354: THEN
1355: x_csp_rec.id := l_csp_rec.id;
1356: END IF;
1357: IF (x_csp_rec.pov_id = OKL_API.G_MISS_NUM)

Line 1357: IF (x_csp_rec.pov_id = OKL_API.G_MISS_NUM)

1353: IF (x_csp_rec.id = OKL_API.G_MISS_NUM)
1354: THEN
1355: x_csp_rec.id := l_csp_rec.id;
1356: END IF;
1357: IF (x_csp_rec.pov_id = OKL_API.G_MISS_NUM)
1358: THEN
1359: x_csp_rec.pov_id := l_csp_rec.pov_id;
1360: END IF;
1361: IF (x_csp_rec.khr_id = OKL_API.G_MISS_NUM)

Line 1361: IF (x_csp_rec.khr_id = OKL_API.G_MISS_NUM)

1357: IF (x_csp_rec.pov_id = OKL_API.G_MISS_NUM)
1358: THEN
1359: x_csp_rec.pov_id := l_csp_rec.pov_id;
1360: END IF;
1361: IF (x_csp_rec.khr_id = OKL_API.G_MISS_NUM)
1362: THEN
1363: x_csp_rec.khr_id := l_csp_rec.khr_id;
1364: END IF;
1365: IF (x_csp_rec.object_version_number = OKL_API.G_MISS_NUM)

Line 1365: IF (x_csp_rec.object_version_number = OKL_API.G_MISS_NUM)

1361: IF (x_csp_rec.khr_id = OKL_API.G_MISS_NUM)
1362: THEN
1363: x_csp_rec.khr_id := l_csp_rec.khr_id;
1364: END IF;
1365: IF (x_csp_rec.object_version_number = OKL_API.G_MISS_NUM)
1366: THEN
1367: x_csp_rec.object_version_number := l_csp_rec.object_version_number;
1368: END IF;
1369: IF (x_csp_rec.attribute_category = OKL_API.G_MISS_NUM)

Line 1369: IF (x_csp_rec.attribute_category = OKL_API.G_MISS_NUM)

1365: IF (x_csp_rec.object_version_number = OKL_API.G_MISS_NUM)
1366: THEN
1367: x_csp_rec.object_version_number := l_csp_rec.object_version_number;
1368: END IF;
1369: IF (x_csp_rec.attribute_category = OKL_API.G_MISS_NUM)
1370: THEN
1371: x_csp_rec.attribute_category := l_csp_rec.attribute_category;
1372: END IF;
1373: IF (x_csp_rec.attribute1 = OKL_API.G_MISS_NUM)

Line 1373: IF (x_csp_rec.attribute1 = OKL_API.G_MISS_NUM)

1369: IF (x_csp_rec.attribute_category = OKL_API.G_MISS_NUM)
1370: THEN
1371: x_csp_rec.attribute_category := l_csp_rec.attribute_category;
1372: END IF;
1373: IF (x_csp_rec.attribute1 = OKL_API.G_MISS_NUM)
1374: THEN
1375: x_csp_rec.attribute1 := l_csp_rec.attribute1;
1376: END IF;
1377: IF (x_csp_rec.attribute2 = OKL_API.G_MISS_NUM)

Line 1377: IF (x_csp_rec.attribute2 = OKL_API.G_MISS_NUM)

1373: IF (x_csp_rec.attribute1 = OKL_API.G_MISS_NUM)
1374: THEN
1375: x_csp_rec.attribute1 := l_csp_rec.attribute1;
1376: END IF;
1377: IF (x_csp_rec.attribute2 = OKL_API.G_MISS_NUM)
1378: THEN
1379: x_csp_rec.attribute2 := l_csp_rec.attribute2;
1380: END IF;
1381: IF (x_csp_rec.attribute3 = OKL_API.G_MISS_NUM)

Line 1381: IF (x_csp_rec.attribute3 = OKL_API.G_MISS_NUM)

1377: IF (x_csp_rec.attribute2 = OKL_API.G_MISS_NUM)
1378: THEN
1379: x_csp_rec.attribute2 := l_csp_rec.attribute2;
1380: END IF;
1381: IF (x_csp_rec.attribute3 = OKL_API.G_MISS_NUM)
1382: THEN
1383: x_csp_rec.attribute3 := l_csp_rec.attribute3;
1384: END IF;
1385: IF (x_csp_rec.attribute4 = OKL_API.G_MISS_NUM)

Line 1385: IF (x_csp_rec.attribute4 = OKL_API.G_MISS_NUM)

1381: IF (x_csp_rec.attribute3 = OKL_API.G_MISS_NUM)
1382: THEN
1383: x_csp_rec.attribute3 := l_csp_rec.attribute3;
1384: END IF;
1385: IF (x_csp_rec.attribute4 = OKL_API.G_MISS_NUM)
1386: THEN
1387: x_csp_rec.attribute4 := l_csp_rec.attribute4;
1388: END IF;
1389: IF (x_csp_rec.attribute5 = OKL_API.G_MISS_NUM)

Line 1389: IF (x_csp_rec.attribute5 = OKL_API.G_MISS_NUM)

1385: IF (x_csp_rec.attribute4 = OKL_API.G_MISS_NUM)
1386: THEN
1387: x_csp_rec.attribute4 := l_csp_rec.attribute4;
1388: END IF;
1389: IF (x_csp_rec.attribute5 = OKL_API.G_MISS_NUM)
1390: THEN
1391: x_csp_rec.attribute5 := l_csp_rec.attribute5;
1392: END IF;
1393: IF (x_csp_rec.attribute6 = OKL_API.G_MISS_NUM)

Line 1393: IF (x_csp_rec.attribute6 = OKL_API.G_MISS_NUM)

1389: IF (x_csp_rec.attribute5 = OKL_API.G_MISS_NUM)
1390: THEN
1391: x_csp_rec.attribute5 := l_csp_rec.attribute5;
1392: END IF;
1393: IF (x_csp_rec.attribute6 = OKL_API.G_MISS_NUM)
1394: THEN
1395: x_csp_rec.attribute6 := l_csp_rec.attribute6;
1396: END IF;
1397: IF (x_csp_rec.attribute7 = OKL_API.G_MISS_NUM)

Line 1397: IF (x_csp_rec.attribute7 = OKL_API.G_MISS_NUM)

1393: IF (x_csp_rec.attribute6 = OKL_API.G_MISS_NUM)
1394: THEN
1395: x_csp_rec.attribute6 := l_csp_rec.attribute6;
1396: END IF;
1397: IF (x_csp_rec.attribute7 = OKL_API.G_MISS_NUM)
1398: THEN
1399: x_csp_rec.attribute7 := l_csp_rec.attribute7;
1400: END IF;
1401: IF (x_csp_rec.attribute8 = OKL_API.G_MISS_NUM)

Line 1401: IF (x_csp_rec.attribute8 = OKL_API.G_MISS_NUM)

1397: IF (x_csp_rec.attribute7 = OKL_API.G_MISS_NUM)
1398: THEN
1399: x_csp_rec.attribute7 := l_csp_rec.attribute7;
1400: END IF;
1401: IF (x_csp_rec.attribute8 = OKL_API.G_MISS_NUM)
1402: THEN
1403: x_csp_rec.attribute8 := l_csp_rec.attribute8;
1404: END IF;
1405: IF (x_csp_rec.attribute9 = OKL_API.G_MISS_NUM)

Line 1405: IF (x_csp_rec.attribute9 = OKL_API.G_MISS_NUM)

1401: IF (x_csp_rec.attribute8 = OKL_API.G_MISS_NUM)
1402: THEN
1403: x_csp_rec.attribute8 := l_csp_rec.attribute8;
1404: END IF;
1405: IF (x_csp_rec.attribute9 = OKL_API.G_MISS_NUM)
1406: THEN
1407: x_csp_rec.attribute9 := l_csp_rec.attribute9;
1408: END IF;
1409: IF (x_csp_rec.attribute10 = OKL_API.G_MISS_NUM)

Line 1409: IF (x_csp_rec.attribute10 = OKL_API.G_MISS_NUM)

1405: IF (x_csp_rec.attribute9 = OKL_API.G_MISS_NUM)
1406: THEN
1407: x_csp_rec.attribute9 := l_csp_rec.attribute9;
1408: END IF;
1409: IF (x_csp_rec.attribute10 = OKL_API.G_MISS_NUM)
1410: THEN
1411: x_csp_rec.attribute10 := l_csp_rec.attribute10;
1412: END IF;
1413: IF (x_csp_rec.attribute11 = OKL_API.G_MISS_NUM)

Line 1413: IF (x_csp_rec.attribute11 = OKL_API.G_MISS_NUM)

1409: IF (x_csp_rec.attribute10 = OKL_API.G_MISS_NUM)
1410: THEN
1411: x_csp_rec.attribute10 := l_csp_rec.attribute10;
1412: END IF;
1413: IF (x_csp_rec.attribute11 = OKL_API.G_MISS_NUM)
1414: THEN
1415: x_csp_rec.attribute11 := l_csp_rec.attribute11;
1416: END IF;
1417: IF (x_csp_rec.attribute12 = OKL_API.G_MISS_NUM)

Line 1417: IF (x_csp_rec.attribute12 = OKL_API.G_MISS_NUM)

1413: IF (x_csp_rec.attribute11 = OKL_API.G_MISS_NUM)
1414: THEN
1415: x_csp_rec.attribute11 := l_csp_rec.attribute11;
1416: END IF;
1417: IF (x_csp_rec.attribute12 = OKL_API.G_MISS_NUM)
1418: THEN
1419: x_csp_rec.attribute12 := l_csp_rec.attribute12;
1420: END IF;
1421: IF (x_csp_rec.attribute13 = OKL_API.G_MISS_NUM)

Line 1421: IF (x_csp_rec.attribute13 = OKL_API.G_MISS_NUM)

1417: IF (x_csp_rec.attribute12 = OKL_API.G_MISS_NUM)
1418: THEN
1419: x_csp_rec.attribute12 := l_csp_rec.attribute12;
1420: END IF;
1421: IF (x_csp_rec.attribute13 = OKL_API.G_MISS_NUM)
1422: THEN
1423: x_csp_rec.attribute13 := l_csp_rec.attribute13;
1424: END IF;
1425: IF (x_csp_rec.attribute14 = OKL_API.G_MISS_NUM)

Line 1425: IF (x_csp_rec.attribute14 = OKL_API.G_MISS_NUM)

1421: IF (x_csp_rec.attribute13 = OKL_API.G_MISS_NUM)
1422: THEN
1423: x_csp_rec.attribute13 := l_csp_rec.attribute13;
1424: END IF;
1425: IF (x_csp_rec.attribute14 = OKL_API.G_MISS_NUM)
1426: THEN
1427: x_csp_rec.attribute14 := l_csp_rec.attribute14;
1428: END IF;
1429: IF (x_csp_rec.attribute15 = OKL_API.G_MISS_NUM)

Line 1429: IF (x_csp_rec.attribute15 = OKL_API.G_MISS_NUM)

1425: IF (x_csp_rec.attribute14 = OKL_API.G_MISS_NUM)
1426: THEN
1427: x_csp_rec.attribute14 := l_csp_rec.attribute14;
1428: END IF;
1429: IF (x_csp_rec.attribute15 = OKL_API.G_MISS_NUM)
1430: THEN
1431: x_csp_rec.attribute15 := l_csp_rec.attribute15;
1432: END IF;
1433: IF (x_csp_rec.created_by = OKL_API.G_MISS_NUM)

Line 1433: IF (x_csp_rec.created_by = OKL_API.G_MISS_NUM)

1429: IF (x_csp_rec.attribute15 = OKL_API.G_MISS_NUM)
1430: THEN
1431: x_csp_rec.attribute15 := l_csp_rec.attribute15;
1432: END IF;
1433: IF (x_csp_rec.created_by = OKL_API.G_MISS_NUM)
1434: THEN
1435: x_csp_rec.created_by := l_csp_rec.created_by;
1436: END IF;
1437: IF (x_csp_rec.creation_date = OKL_API.G_MISS_DATE)

Line 1437: IF (x_csp_rec.creation_date = OKL_API.G_MISS_DATE)

1433: IF (x_csp_rec.created_by = OKL_API.G_MISS_NUM)
1434: THEN
1435: x_csp_rec.created_by := l_csp_rec.created_by;
1436: END IF;
1437: IF (x_csp_rec.creation_date = OKL_API.G_MISS_DATE)
1438: THEN
1439: x_csp_rec.creation_date := l_csp_rec.creation_date;
1440: END IF;
1441: IF (x_csp_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 1441: IF (x_csp_rec.last_updated_by = OKL_API.G_MISS_NUM)

1437: IF (x_csp_rec.creation_date = OKL_API.G_MISS_DATE)
1438: THEN
1439: x_csp_rec.creation_date := l_csp_rec.creation_date;
1440: END IF;
1441: IF (x_csp_rec.last_updated_by = OKL_API.G_MISS_NUM)
1442: THEN
1443: x_csp_rec.last_updated_by := l_csp_rec.last_updated_by;
1444: END IF;
1445: IF (x_csp_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 1445: IF (x_csp_rec.last_update_date = OKL_API.G_MISS_DATE)

1441: IF (x_csp_rec.last_updated_by = OKL_API.G_MISS_NUM)
1442: THEN
1443: x_csp_rec.last_updated_by := l_csp_rec.last_updated_by;
1444: END IF;
1445: IF (x_csp_rec.last_update_date = OKL_API.G_MISS_DATE)
1446: THEN
1447: x_csp_rec.last_update_date := l_csp_rec.last_update_date;
1448: END IF;
1449: IF (x_csp_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 1449: IF (x_csp_rec.last_update_login = OKL_API.G_MISS_NUM)

1445: IF (x_csp_rec.last_update_date = OKL_API.G_MISS_DATE)
1446: THEN
1447: x_csp_rec.last_update_date := l_csp_rec.last_update_date;
1448: END IF;
1449: IF (x_csp_rec.last_update_login = OKL_API.G_MISS_NUM)
1450: THEN
1451: x_csp_rec.last_update_login := l_csp_rec.last_update_login;
1452: END IF;
1453: RETURN(l_return_status);

Line 1462: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1458: FUNCTION Set_Attributes (
1459: p_csp_rec IN csp_rec_type,
1460: x_csp_rec OUT NOCOPY csp_rec_type
1461: ) RETURN VARCHAR2 IS
1462: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1463: BEGIN
1464: x_csp_rec := p_csp_rec;
1465: RETURN(l_return_status);
1466: END Set_Attributes;

Line 1468: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1464: x_csp_rec := p_csp_rec;
1465: RETURN(l_return_status);
1466: END Set_Attributes;
1467: BEGIN
1468: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1469: p_init_msg_list,
1470: '_PVT',
1471: x_return_status);
1472: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1472: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1468: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1469: p_init_msg_list,
1470: '_PVT',
1471: x_return_status);
1472: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1475: RAISE OKL_API.G_EXCEPTION_ERROR;
1476: END IF;

Line 1473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1469: p_init_msg_list,
1470: '_PVT',
1471: x_return_status);
1472: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1475: RAISE OKL_API.G_EXCEPTION_ERROR;
1476: END IF;
1477: --- Setting item attributes

Line 1474: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1470: '_PVT',
1471: x_return_status);
1472: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1475: RAISE OKL_API.G_EXCEPTION_ERROR;
1476: END IF;
1477: --- Setting item attributes
1478: l_return_status := Set_Attributes(

Line 1475: RAISE OKL_API.G_EXCEPTION_ERROR;

1471: x_return_status);
1472: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1475: RAISE OKL_API.G_EXCEPTION_ERROR;
1476: END IF;
1477: --- Setting item attributes
1478: l_return_status := Set_Attributes(
1479: p_csp_rec, -- IN

Line 1482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1478: l_return_status := Set_Attributes(
1479: p_csp_rec, -- IN
1480: l_csp_rec); -- OUT
1481: --- If any errors happen abort API
1482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1485: RAISE OKL_API.G_EXCEPTION_ERROR;
1486: END IF;

Line 1483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1479: p_csp_rec, -- IN
1480: l_csp_rec); -- OUT
1481: --- If any errors happen abort API
1482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1485: RAISE OKL_API.G_EXCEPTION_ERROR;
1486: END IF;
1487: l_return_status := populate_new_record(l_csp_rec, l_def_csp_rec);

Line 1484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1480: l_csp_rec); -- OUT
1481: --- If any errors happen abort API
1482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1485: RAISE OKL_API.G_EXCEPTION_ERROR;
1486: END IF;
1487: l_return_status := populate_new_record(l_csp_rec, l_def_csp_rec);
1488: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1485: RAISE OKL_API.G_EXCEPTION_ERROR;

1481: --- If any errors happen abort API
1482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1485: RAISE OKL_API.G_EXCEPTION_ERROR;
1486: END IF;
1487: l_return_status := populate_new_record(l_csp_rec, l_def_csp_rec);
1488: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1489: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1488: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1485: RAISE OKL_API.G_EXCEPTION_ERROR;
1486: END IF;
1487: l_return_status := populate_new_record(l_csp_rec, l_def_csp_rec);
1488: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1489: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1490: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1491: RAISE OKL_API.G_EXCEPTION_ERROR;
1492: END IF;

Line 1489: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1485: RAISE OKL_API.G_EXCEPTION_ERROR;
1486: END IF;
1487: l_return_status := populate_new_record(l_csp_rec, l_def_csp_rec);
1488: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1489: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1490: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1491: RAISE OKL_API.G_EXCEPTION_ERROR;
1492: END IF;
1493: UPDATE OKL_SLCTD_OPTNS

Line 1490: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1486: END IF;
1487: l_return_status := populate_new_record(l_csp_rec, l_def_csp_rec);
1488: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1489: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1490: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1491: RAISE OKL_API.G_EXCEPTION_ERROR;
1492: END IF;
1493: UPDATE OKL_SLCTD_OPTNS
1494: SET POV_ID = l_def_csp_rec.pov_id,

Line 1491: RAISE OKL_API.G_EXCEPTION_ERROR;

1487: l_return_status := populate_new_record(l_csp_rec, l_def_csp_rec);
1488: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1489: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1490: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1491: RAISE OKL_API.G_EXCEPTION_ERROR;
1492: END IF;
1493: UPDATE OKL_SLCTD_OPTNS
1494: SET POV_ID = l_def_csp_rec.pov_id,
1495: KHR_ID = l_def_csp_rec.khr_id,

Line 1521: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1517: LAST_UPDATE_LOGIN = l_def_csp_rec.last_update_login
1518: WHERE ID = l_def_csp_rec.id;
1519:
1520: x_csp_rec := l_def_csp_rec;
1521: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1522: EXCEPTION
1523: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1524: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1525: (

Line 1523: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1519:
1520: x_csp_rec := l_def_csp_rec;
1521: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1522: EXCEPTION
1523: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1524: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1525: (
1526: l_api_name,
1527: G_PKG_NAME,

Line 1524: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1520: x_csp_rec := l_def_csp_rec;
1521: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1522: EXCEPTION
1523: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1524: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1525: (
1526: l_api_name,
1527: G_PKG_NAME,
1528: 'OKL_API.G_RET_STS_ERROR',

Line 1528: 'OKL_API.G_RET_STS_ERROR',

1524: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1525: (
1526: l_api_name,
1527: G_PKG_NAME,
1528: 'OKL_API.G_RET_STS_ERROR',
1529: x_msg_count,
1530: x_msg_data,
1531: '_PVT'
1532: );

Line 1533: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1529: x_msg_count,
1530: x_msg_data,
1531: '_PVT'
1532: );
1533: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1534: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1535: (
1536: l_api_name,
1537: G_PKG_NAME,

Line 1534: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1530: x_msg_data,
1531: '_PVT'
1532: );
1533: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1534: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1535: (
1536: l_api_name,
1537: G_PKG_NAME,
1538: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1538: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1534: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1535: (
1536: l_api_name,
1537: G_PKG_NAME,
1538: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1539: x_msg_count,
1540: x_msg_data,
1541: '_PVT'
1542: );

Line 1544: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1540: x_msg_data,
1541: '_PVT'
1542: );
1543: WHEN OTHERS THEN
1544: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1545: (
1546: l_api_name,
1547: G_PKG_NAME,
1548: 'OTHERS',

Line 1559: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1555: -- update_row for:OKL_SLCTD_OPTNS_V --
1556: --------------------------------------
1557: PROCEDURE update_row(
1558: p_api_version IN NUMBER,
1559: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1560: x_return_status OUT NOCOPY VARCHAR2,
1561: x_msg_count OUT NOCOPY NUMBER,
1562: x_msg_data OUT NOCOPY VARCHAR2,
1563: p_cspv_rec IN cspv_rec_type,

Line 1568: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1564: x_cspv_rec OUT NOCOPY cspv_rec_type) IS
1565:
1566: l_api_version CONSTANT NUMBER := 1;
1567: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1568: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1569: l_cspv_rec cspv_rec_type := p_cspv_rec;
1570: l_def_cspv_rec cspv_rec_type;
1571: l_csp_rec csp_rec_type;
1572: lx_csp_rec csp_rec_type;

Line 1595: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1591: x_cspv_rec OUT NOCOPY cspv_rec_type
1592: ) RETURN VARCHAR2 IS
1593: l_cspv_rec cspv_rec_type;
1594: l_row_notfound BOOLEAN := TRUE;
1595: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1596: BEGIN
1597: x_cspv_rec := p_cspv_rec;
1598: -- Get current database values
1599: l_cspv_rec := get_rec(p_cspv_rec, l_row_notfound);

Line 1601: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1597: x_cspv_rec := p_cspv_rec;
1598: -- Get current database values
1599: l_cspv_rec := get_rec(p_cspv_rec, l_row_notfound);
1600: IF (l_row_notfound) THEN
1601: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1602: END IF;
1603: IF (x_cspv_rec.id = OKL_API.G_MISS_NUM)
1604: THEN
1605: x_cspv_rec.id := l_cspv_rec.id;

Line 1603: IF (x_cspv_rec.id = OKL_API.G_MISS_NUM)

1599: l_cspv_rec := get_rec(p_cspv_rec, l_row_notfound);
1600: IF (l_row_notfound) THEN
1601: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1602: END IF;
1603: IF (x_cspv_rec.id = OKL_API.G_MISS_NUM)
1604: THEN
1605: x_cspv_rec.id := l_cspv_rec.id;
1606: END IF;
1607: IF (x_cspv_rec.object_version_number = OKL_API.G_MISS_NUM)

Line 1607: IF (x_cspv_rec.object_version_number = OKL_API.G_MISS_NUM)

1603: IF (x_cspv_rec.id = OKL_API.G_MISS_NUM)
1604: THEN
1605: x_cspv_rec.id := l_cspv_rec.id;
1606: END IF;
1607: IF (x_cspv_rec.object_version_number = OKL_API.G_MISS_NUM)
1608: THEN
1609: x_cspv_rec.object_version_number := l_cspv_rec.object_version_number;
1610: END IF;
1611: IF (x_cspv_rec.pov_id = OKL_API.G_MISS_NUM)

Line 1611: IF (x_cspv_rec.pov_id = OKL_API.G_MISS_NUM)

1607: IF (x_cspv_rec.object_version_number = OKL_API.G_MISS_NUM)
1608: THEN
1609: x_cspv_rec.object_version_number := l_cspv_rec.object_version_number;
1610: END IF;
1611: IF (x_cspv_rec.pov_id = OKL_API.G_MISS_NUM)
1612: THEN
1613: x_cspv_rec.pov_id := l_cspv_rec.pov_id;
1614: END IF;
1615: IF (x_cspv_rec.khr_id = OKL_API.G_MISS_NUM)

Line 1615: IF (x_cspv_rec.khr_id = OKL_API.G_MISS_NUM)

1611: IF (x_cspv_rec.pov_id = OKL_API.G_MISS_NUM)
1612: THEN
1613: x_cspv_rec.pov_id := l_cspv_rec.pov_id;
1614: END IF;
1615: IF (x_cspv_rec.khr_id = OKL_API.G_MISS_NUM)
1616: THEN
1617: x_cspv_rec.khr_id := l_cspv_rec.khr_id;
1618: END IF;
1619: IF (x_cspv_rec.attribute_category = OKL_API.G_MISS_NUM)

Line 1619: IF (x_cspv_rec.attribute_category = OKL_API.G_MISS_NUM)

1615: IF (x_cspv_rec.khr_id = OKL_API.G_MISS_NUM)
1616: THEN
1617: x_cspv_rec.khr_id := l_cspv_rec.khr_id;
1618: END IF;
1619: IF (x_cspv_rec.attribute_category = OKL_API.G_MISS_NUM)
1620: THEN
1621: x_cspv_rec.attribute_category := l_cspv_rec.attribute_category;
1622: END IF;
1623: IF (x_cspv_rec.attribute1 = OKL_API.G_MISS_NUM)

Line 1623: IF (x_cspv_rec.attribute1 = OKL_API.G_MISS_NUM)

1619: IF (x_cspv_rec.attribute_category = OKL_API.G_MISS_NUM)
1620: THEN
1621: x_cspv_rec.attribute_category := l_cspv_rec.attribute_category;
1622: END IF;
1623: IF (x_cspv_rec.attribute1 = OKL_API.G_MISS_NUM)
1624: THEN
1625: x_cspv_rec.attribute1 := l_cspv_rec.attribute1;
1626: END IF;
1627: IF (x_cspv_rec.attribute2 = OKL_API.G_MISS_NUM)

Line 1627: IF (x_cspv_rec.attribute2 = OKL_API.G_MISS_NUM)

1623: IF (x_cspv_rec.attribute1 = OKL_API.G_MISS_NUM)
1624: THEN
1625: x_cspv_rec.attribute1 := l_cspv_rec.attribute1;
1626: END IF;
1627: IF (x_cspv_rec.attribute2 = OKL_API.G_MISS_NUM)
1628: THEN
1629: x_cspv_rec.attribute2 := l_cspv_rec.attribute2;
1630: END IF;
1631: IF (x_cspv_rec.attribute3 = OKL_API.G_MISS_NUM)

Line 1631: IF (x_cspv_rec.attribute3 = OKL_API.G_MISS_NUM)

1627: IF (x_cspv_rec.attribute2 = OKL_API.G_MISS_NUM)
1628: THEN
1629: x_cspv_rec.attribute2 := l_cspv_rec.attribute2;
1630: END IF;
1631: IF (x_cspv_rec.attribute3 = OKL_API.G_MISS_NUM)
1632: THEN
1633: x_cspv_rec.attribute3 := l_cspv_rec.attribute3;
1634: END IF;
1635: IF (x_cspv_rec.attribute4 = OKL_API.G_MISS_NUM)

Line 1635: IF (x_cspv_rec.attribute4 = OKL_API.G_MISS_NUM)

1631: IF (x_cspv_rec.attribute3 = OKL_API.G_MISS_NUM)
1632: THEN
1633: x_cspv_rec.attribute3 := l_cspv_rec.attribute3;
1634: END IF;
1635: IF (x_cspv_rec.attribute4 = OKL_API.G_MISS_NUM)
1636: THEN
1637: x_cspv_rec.attribute4 := l_cspv_rec.attribute4;
1638: END IF;
1639: IF (x_cspv_rec.attribute5 = OKL_API.G_MISS_NUM)

Line 1639: IF (x_cspv_rec.attribute5 = OKL_API.G_MISS_NUM)

1635: IF (x_cspv_rec.attribute4 = OKL_API.G_MISS_NUM)
1636: THEN
1637: x_cspv_rec.attribute4 := l_cspv_rec.attribute4;
1638: END IF;
1639: IF (x_cspv_rec.attribute5 = OKL_API.G_MISS_NUM)
1640: THEN
1641: x_cspv_rec.attribute5 := l_cspv_rec.attribute5;
1642: END IF;
1643: IF (x_cspv_rec.attribute6 = OKL_API.G_MISS_NUM)

Line 1643: IF (x_cspv_rec.attribute6 = OKL_API.G_MISS_NUM)

1639: IF (x_cspv_rec.attribute5 = OKL_API.G_MISS_NUM)
1640: THEN
1641: x_cspv_rec.attribute5 := l_cspv_rec.attribute5;
1642: END IF;
1643: IF (x_cspv_rec.attribute6 = OKL_API.G_MISS_NUM)
1644: THEN
1645: x_cspv_rec.attribute6 := l_cspv_rec.attribute6;
1646: END IF;
1647: IF (x_cspv_rec.attribute7 = OKL_API.G_MISS_NUM)

Line 1647: IF (x_cspv_rec.attribute7 = OKL_API.G_MISS_NUM)

1643: IF (x_cspv_rec.attribute6 = OKL_API.G_MISS_NUM)
1644: THEN
1645: x_cspv_rec.attribute6 := l_cspv_rec.attribute6;
1646: END IF;
1647: IF (x_cspv_rec.attribute7 = OKL_API.G_MISS_NUM)
1648: THEN
1649: x_cspv_rec.attribute7 := l_cspv_rec.attribute7;
1650: END IF;
1651: IF (x_cspv_rec.attribute8 = OKL_API.G_MISS_NUM)

Line 1651: IF (x_cspv_rec.attribute8 = OKL_API.G_MISS_NUM)

1647: IF (x_cspv_rec.attribute7 = OKL_API.G_MISS_NUM)
1648: THEN
1649: x_cspv_rec.attribute7 := l_cspv_rec.attribute7;
1650: END IF;
1651: IF (x_cspv_rec.attribute8 = OKL_API.G_MISS_NUM)
1652: THEN
1653: x_cspv_rec.attribute8 := l_cspv_rec.attribute8;
1654: END IF;
1655: IF (x_cspv_rec.attribute9 = OKL_API.G_MISS_NUM)

Line 1655: IF (x_cspv_rec.attribute9 = OKL_API.G_MISS_NUM)

1651: IF (x_cspv_rec.attribute8 = OKL_API.G_MISS_NUM)
1652: THEN
1653: x_cspv_rec.attribute8 := l_cspv_rec.attribute8;
1654: END IF;
1655: IF (x_cspv_rec.attribute9 = OKL_API.G_MISS_NUM)
1656: THEN
1657: x_cspv_rec.attribute9 := l_cspv_rec.attribute9;
1658: END IF;
1659: IF (x_cspv_rec.attribute10 = OKL_API.G_MISS_NUM)

Line 1659: IF (x_cspv_rec.attribute10 = OKL_API.G_MISS_NUM)

1655: IF (x_cspv_rec.attribute9 = OKL_API.G_MISS_NUM)
1656: THEN
1657: x_cspv_rec.attribute9 := l_cspv_rec.attribute9;
1658: END IF;
1659: IF (x_cspv_rec.attribute10 = OKL_API.G_MISS_NUM)
1660: THEN
1661: x_cspv_rec.attribute10 := l_cspv_rec.attribute10;
1662: END IF;
1663: IF (x_cspv_rec.attribute11 = OKL_API.G_MISS_NUM)

Line 1663: IF (x_cspv_rec.attribute11 = OKL_API.G_MISS_NUM)

1659: IF (x_cspv_rec.attribute10 = OKL_API.G_MISS_NUM)
1660: THEN
1661: x_cspv_rec.attribute10 := l_cspv_rec.attribute10;
1662: END IF;
1663: IF (x_cspv_rec.attribute11 = OKL_API.G_MISS_NUM)
1664: THEN
1665: x_cspv_rec.attribute11 := l_cspv_rec.attribute11;
1666: END IF;
1667: IF (x_cspv_rec.attribute12 = OKL_API.G_MISS_NUM)

Line 1667: IF (x_cspv_rec.attribute12 = OKL_API.G_MISS_NUM)

1663: IF (x_cspv_rec.attribute11 = OKL_API.G_MISS_NUM)
1664: THEN
1665: x_cspv_rec.attribute11 := l_cspv_rec.attribute11;
1666: END IF;
1667: IF (x_cspv_rec.attribute12 = OKL_API.G_MISS_NUM)
1668: THEN
1669: x_cspv_rec.attribute12 := l_cspv_rec.attribute12;
1670: END IF;
1671: IF (x_cspv_rec.attribute13 = OKL_API.G_MISS_NUM)

Line 1671: IF (x_cspv_rec.attribute13 = OKL_API.G_MISS_NUM)

1667: IF (x_cspv_rec.attribute12 = OKL_API.G_MISS_NUM)
1668: THEN
1669: x_cspv_rec.attribute12 := l_cspv_rec.attribute12;
1670: END IF;
1671: IF (x_cspv_rec.attribute13 = OKL_API.G_MISS_NUM)
1672: THEN
1673: x_cspv_rec.attribute13 := l_cspv_rec.attribute13;
1674: END IF;
1675: IF (x_cspv_rec.attribute14 = OKL_API.G_MISS_NUM)

Line 1675: IF (x_cspv_rec.attribute14 = OKL_API.G_MISS_NUM)

1671: IF (x_cspv_rec.attribute13 = OKL_API.G_MISS_NUM)
1672: THEN
1673: x_cspv_rec.attribute13 := l_cspv_rec.attribute13;
1674: END IF;
1675: IF (x_cspv_rec.attribute14 = OKL_API.G_MISS_NUM)
1676: THEN
1677: x_cspv_rec.attribute14 := l_cspv_rec.attribute14;
1678: END IF;
1679: IF (x_cspv_rec.attribute15 = OKL_API.G_MISS_NUM)

Line 1679: IF (x_cspv_rec.attribute15 = OKL_API.G_MISS_NUM)

1675: IF (x_cspv_rec.attribute14 = OKL_API.G_MISS_NUM)
1676: THEN
1677: x_cspv_rec.attribute14 := l_cspv_rec.attribute14;
1678: END IF;
1679: IF (x_cspv_rec.attribute15 = OKL_API.G_MISS_NUM)
1680: THEN
1681: x_cspv_rec.attribute15 := l_cspv_rec.attribute15;
1682: END IF;
1683: IF (x_cspv_rec.created_by = OKL_API.G_MISS_NUM)

Line 1683: IF (x_cspv_rec.created_by = OKL_API.G_MISS_NUM)

1679: IF (x_cspv_rec.attribute15 = OKL_API.G_MISS_NUM)
1680: THEN
1681: x_cspv_rec.attribute15 := l_cspv_rec.attribute15;
1682: END IF;
1683: IF (x_cspv_rec.created_by = OKL_API.G_MISS_NUM)
1684: THEN
1685: x_cspv_rec.created_by := l_cspv_rec.created_by;
1686: END IF;
1687: IF (x_cspv_rec.creation_date = OKL_API.G_MISS_DATE)

Line 1687: IF (x_cspv_rec.creation_date = OKL_API.G_MISS_DATE)

1683: IF (x_cspv_rec.created_by = OKL_API.G_MISS_NUM)
1684: THEN
1685: x_cspv_rec.created_by := l_cspv_rec.created_by;
1686: END IF;
1687: IF (x_cspv_rec.creation_date = OKL_API.G_MISS_DATE)
1688: THEN
1689: x_cspv_rec.creation_date := l_cspv_rec.creation_date;
1690: END IF;
1691: IF (x_cspv_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 1691: IF (x_cspv_rec.last_updated_by = OKL_API.G_MISS_NUM)

1687: IF (x_cspv_rec.creation_date = OKL_API.G_MISS_DATE)
1688: THEN
1689: x_cspv_rec.creation_date := l_cspv_rec.creation_date;
1690: END IF;
1691: IF (x_cspv_rec.last_updated_by = OKL_API.G_MISS_NUM)
1692: THEN
1693: x_cspv_rec.last_updated_by := l_cspv_rec.last_updated_by;
1694: END IF;
1695: IF (x_cspv_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 1695: IF (x_cspv_rec.last_update_date = OKL_API.G_MISS_DATE)

1691: IF (x_cspv_rec.last_updated_by = OKL_API.G_MISS_NUM)
1692: THEN
1693: x_cspv_rec.last_updated_by := l_cspv_rec.last_updated_by;
1694: END IF;
1695: IF (x_cspv_rec.last_update_date = OKL_API.G_MISS_DATE)
1696: THEN
1697: x_cspv_rec.last_update_date := l_cspv_rec.last_update_date;
1698: END IF;
1699: IF (x_cspv_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 1699: IF (x_cspv_rec.last_update_login = OKL_API.G_MISS_NUM)

1695: IF (x_cspv_rec.last_update_date = OKL_API.G_MISS_DATE)
1696: THEN
1697: x_cspv_rec.last_update_date := l_cspv_rec.last_update_date;
1698: END IF;
1699: IF (x_cspv_rec.last_update_login = OKL_API.G_MISS_NUM)
1700: THEN
1701: x_cspv_rec.last_update_login := l_cspv_rec.last_update_login;
1702: END IF;
1703: RETURN(l_return_status);

Line 1712: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1708: FUNCTION Set_Attributes (
1709: p_cspv_rec IN cspv_rec_type,
1710: x_cspv_rec OUT NOCOPY cspv_rec_type
1711: ) RETURN VARCHAR2 IS
1712: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1713: BEGIN
1714: x_cspv_rec := p_cspv_rec;
1715: x_cspv_rec.OBJECT_VERSION_NUMBER := NVL(x_cspv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1716: RETURN(l_return_status);

Line 1719: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1715: x_cspv_rec.OBJECT_VERSION_NUMBER := NVL(x_cspv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1716: RETURN(l_return_status);
1717: END Set_Attributes;
1718: BEGIN
1719: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1720: G_PKG_NAME,
1721: p_init_msg_list,
1722: l_api_version,
1723: p_api_version,

Line 1726: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1722: l_api_version,
1723: p_api_version,
1724: '_PVT',
1725: x_return_status);
1726: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1729: RAISE OKL_API.G_EXCEPTION_ERROR;
1730: END IF;

Line 1727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1723: p_api_version,
1724: '_PVT',
1725: x_return_status);
1726: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1729: RAISE OKL_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: --- Setting item attributes

Line 1728: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1724: '_PVT',
1725: x_return_status);
1726: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1729: RAISE OKL_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: --- Setting item attributes
1732: l_return_status := Set_Attributes(

Line 1729: RAISE OKL_API.G_EXCEPTION_ERROR;

1725: x_return_status);
1726: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1729: RAISE OKL_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: --- Setting item attributes
1732: l_return_status := Set_Attributes(
1733: p_cspv_rec, -- IN

Line 1736: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1732: l_return_status := Set_Attributes(
1733: p_cspv_rec, -- IN
1734: l_cspv_rec); -- OUT
1735: --- If any errors happen abort API
1736: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1738: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1739: RAISE OKL_API.G_EXCEPTION_ERROR;
1740: END IF;

Line 1737: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1733: p_cspv_rec, -- IN
1734: l_cspv_rec); -- OUT
1735: --- If any errors happen abort API
1736: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1738: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1739: RAISE OKL_API.G_EXCEPTION_ERROR;
1740: END IF;
1741: l_return_status := populate_new_record(l_cspv_rec, l_def_cspv_rec);

Line 1738: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1734: l_cspv_rec); -- OUT
1735: --- If any errors happen abort API
1736: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1738: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1739: RAISE OKL_API.G_EXCEPTION_ERROR;
1740: END IF;
1741: l_return_status := populate_new_record(l_cspv_rec, l_def_cspv_rec);
1742: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1739: RAISE OKL_API.G_EXCEPTION_ERROR;

1735: --- If any errors happen abort API
1736: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1738: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1739: RAISE OKL_API.G_EXCEPTION_ERROR;
1740: END IF;
1741: l_return_status := populate_new_record(l_cspv_rec, l_def_cspv_rec);
1742: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1742: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1738: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1739: RAISE OKL_API.G_EXCEPTION_ERROR;
1740: END IF;
1741: l_return_status := populate_new_record(l_cspv_rec, l_def_cspv_rec);
1742: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1744: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1745: RAISE OKL_API.G_EXCEPTION_ERROR;
1746: END IF;

Line 1743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1739: RAISE OKL_API.G_EXCEPTION_ERROR;
1740: END IF;
1741: l_return_status := populate_new_record(l_cspv_rec, l_def_cspv_rec);
1742: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1744: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1745: RAISE OKL_API.G_EXCEPTION_ERROR;
1746: END IF;
1747: l_def_cspv_rec := fill_who_columns(l_def_cspv_rec);

Line 1744: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1740: END IF;
1741: l_return_status := populate_new_record(l_cspv_rec, l_def_cspv_rec);
1742: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1744: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1745: RAISE OKL_API.G_EXCEPTION_ERROR;
1746: END IF;
1747: l_def_cspv_rec := fill_who_columns(l_def_cspv_rec);
1748: --- Validate all non-missing attributes (Item Level Validation)

Line 1745: RAISE OKL_API.G_EXCEPTION_ERROR;

1741: l_return_status := populate_new_record(l_cspv_rec, l_def_cspv_rec);
1742: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1744: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1745: RAISE OKL_API.G_EXCEPTION_ERROR;
1746: END IF;
1747: l_def_cspv_rec := fill_who_columns(l_def_cspv_rec);
1748: --- Validate all non-missing attributes (Item Level Validation)
1749: l_return_status := Validate_Attributes(l_def_cspv_rec);

Line 1751: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1747: l_def_cspv_rec := fill_who_columns(l_def_cspv_rec);
1748: --- Validate all non-missing attributes (Item Level Validation)
1749: l_return_status := Validate_Attributes(l_def_cspv_rec);
1750: --- If any errors happen abort API
1751: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1752: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1753: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1754: RAISE OKL_API.G_EXCEPTION_ERROR;
1755: END IF;

Line 1752: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1748: --- Validate all non-missing attributes (Item Level Validation)
1749: l_return_status := Validate_Attributes(l_def_cspv_rec);
1750: --- If any errors happen abort API
1751: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1752: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1753: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1754: RAISE OKL_API.G_EXCEPTION_ERROR;
1755: END IF;
1756: l_return_status := Validate_Record(l_def_cspv_rec);

Line 1753: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1749: l_return_status := Validate_Attributes(l_def_cspv_rec);
1750: --- If any errors happen abort API
1751: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1752: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1753: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1754: RAISE OKL_API.G_EXCEPTION_ERROR;
1755: END IF;
1756: l_return_status := Validate_Record(l_def_cspv_rec);
1757: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1754: RAISE OKL_API.G_EXCEPTION_ERROR;

1750: --- If any errors happen abort API
1751: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1752: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1753: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1754: RAISE OKL_API.G_EXCEPTION_ERROR;
1755: END IF;
1756: l_return_status := Validate_Record(l_def_cspv_rec);
1757: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1758: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1757: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1753: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1754: RAISE OKL_API.G_EXCEPTION_ERROR;
1755: END IF;
1756: l_return_status := Validate_Record(l_def_cspv_rec);
1757: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1758: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1759: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1760: RAISE OKL_API.G_EXCEPTION_ERROR;
1761: END IF;

Line 1758: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1754: RAISE OKL_API.G_EXCEPTION_ERROR;
1755: END IF;
1756: l_return_status := Validate_Record(l_def_cspv_rec);
1757: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1758: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1759: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1760: RAISE OKL_API.G_EXCEPTION_ERROR;
1761: END IF;
1762: --------------------------------------

Line 1759: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1755: END IF;
1756: l_return_status := Validate_Record(l_def_cspv_rec);
1757: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1758: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1759: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1760: RAISE OKL_API.G_EXCEPTION_ERROR;
1761: END IF;
1762: --------------------------------------
1763: -- Move VIEW record to "Child" records

Line 1760: RAISE OKL_API.G_EXCEPTION_ERROR;

1756: l_return_status := Validate_Record(l_def_cspv_rec);
1757: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1758: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1759: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1760: RAISE OKL_API.G_EXCEPTION_ERROR;
1761: END IF;
1762: --------------------------------------
1763: -- Move VIEW record to "Child" records
1764: --------------------------------------

Line 1777: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1773: x_msg_data,
1774: l_csp_rec,
1775: lx_csp_rec
1776: );
1777: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1778: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1780: RAISE OKL_API.G_EXCEPTION_ERROR;
1781: END IF;

Line 1778: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1774: l_csp_rec,
1775: lx_csp_rec
1776: );
1777: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1778: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1780: RAISE OKL_API.G_EXCEPTION_ERROR;
1781: END IF;
1782: migrate(lx_csp_rec, l_def_cspv_rec);

Line 1779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1775: lx_csp_rec
1776: );
1777: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1778: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1780: RAISE OKL_API.G_EXCEPTION_ERROR;
1781: END IF;
1782: migrate(lx_csp_rec, l_def_cspv_rec);
1783: x_cspv_rec := l_def_cspv_rec;

Line 1780: RAISE OKL_API.G_EXCEPTION_ERROR;

1776: );
1777: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1778: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1780: RAISE OKL_API.G_EXCEPTION_ERROR;
1781: END IF;
1782: migrate(lx_csp_rec, l_def_cspv_rec);
1783: x_cspv_rec := l_def_cspv_rec;
1784: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1784: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1780: RAISE OKL_API.G_EXCEPTION_ERROR;
1781: END IF;
1782: migrate(lx_csp_rec, l_def_cspv_rec);
1783: x_cspv_rec := l_def_cspv_rec;
1784: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1785: EXCEPTION
1786: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1787: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1788: (

Line 1786: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1782: migrate(lx_csp_rec, l_def_cspv_rec);
1783: x_cspv_rec := l_def_cspv_rec;
1784: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1785: EXCEPTION
1786: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1787: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1788: (
1789: l_api_name,
1790: G_PKG_NAME,

Line 1787: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1783: x_cspv_rec := l_def_cspv_rec;
1784: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1785: EXCEPTION
1786: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1787: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1788: (
1789: l_api_name,
1790: G_PKG_NAME,
1791: 'OKL_API.G_RET_STS_ERROR',

Line 1791: 'OKL_API.G_RET_STS_ERROR',

1787: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1788: (
1789: l_api_name,
1790: G_PKG_NAME,
1791: 'OKL_API.G_RET_STS_ERROR',
1792: x_msg_count,
1793: x_msg_data,
1794: '_PVT'
1795: );

Line 1796: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1792: x_msg_count,
1793: x_msg_data,
1794: '_PVT'
1795: );
1796: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1797: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1798: (
1799: l_api_name,
1800: G_PKG_NAME,

Line 1797: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1793: x_msg_data,
1794: '_PVT'
1795: );
1796: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1797: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1798: (
1799: l_api_name,
1800: G_PKG_NAME,
1801: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1801: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1797: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1798: (
1799: l_api_name,
1800: G_PKG_NAME,
1801: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1802: x_msg_count,
1803: x_msg_data,
1804: '_PVT'
1805: );

Line 1807: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1803: x_msg_data,
1804: '_PVT'
1805: );
1806: WHEN OTHERS THEN
1807: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1808: (
1809: l_api_name,
1810: G_PKG_NAME,
1811: 'OTHERS',

Line 1822: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1818: -- PL/SQL TBL update_row for:CSPV_TBL --
1819: ----------------------------------------
1820: PROCEDURE update_row(
1821: p_api_version IN NUMBER,
1822: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1823: x_return_status OUT NOCOPY VARCHAR2,
1824: x_msg_count OUT NOCOPY NUMBER,
1825: x_msg_data OUT NOCOPY VARCHAR2,
1826: p_cspv_tbl IN cspv_tbl_type,

Line 1831: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1827: x_cspv_tbl OUT NOCOPY cspv_tbl_type) IS
1828:
1829: l_api_version CONSTANT NUMBER := 1;
1830: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1831: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1832: i NUMBER := 0;
1833: BEGIN
1834: OKL_API.init_msg_list(p_init_msg_list);
1835: -- Make sure PL/SQL table has records in it before passing

Line 1834: OKL_API.init_msg_list(p_init_msg_list);

1830: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1831: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1832: i NUMBER := 0;
1833: BEGIN
1834: OKL_API.init_msg_list(p_init_msg_list);
1835: -- Make sure PL/SQL table has records in it before passing
1836: IF (p_cspv_tbl.COUNT > 0) THEN
1837: i := p_cspv_tbl.FIRST;
1838: LOOP

Line 1841: p_init_msg_list => OKL_API.G_FALSE,

1837: i := p_cspv_tbl.FIRST;
1838: LOOP
1839: update_row (
1840: p_api_version => p_api_version,
1841: p_init_msg_list => OKL_API.G_FALSE,
1842: x_return_status => x_return_status,
1843: x_msg_count => x_msg_count,
1844: x_msg_data => x_msg_data,
1845: p_cspv_rec => p_cspv_tbl(i),

Line 1852: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1848: i := p_cspv_tbl.NEXT(i);
1849: END LOOP;
1850: END IF;
1851: EXCEPTION
1852: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1853: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1854: (
1855: l_api_name,
1856: G_PKG_NAME,

Line 1853: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1849: END LOOP;
1850: END IF;
1851: EXCEPTION
1852: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1853: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1854: (
1855: l_api_name,
1856: G_PKG_NAME,
1857: 'OKL_API.G_RET_STS_ERROR',

Line 1857: 'OKL_API.G_RET_STS_ERROR',

1853: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1854: (
1855: l_api_name,
1856: G_PKG_NAME,
1857: 'OKL_API.G_RET_STS_ERROR',
1858: x_msg_count,
1859: x_msg_data,
1860: '_PVT'
1861: );

Line 1862: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1858: x_msg_count,
1859: x_msg_data,
1860: '_PVT'
1861: );
1862: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1863: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1864: (
1865: l_api_name,
1866: G_PKG_NAME,

Line 1863: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1859: x_msg_data,
1860: '_PVT'
1861: );
1862: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1863: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1864: (
1865: l_api_name,
1866: G_PKG_NAME,
1867: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1867: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1863: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1864: (
1865: l_api_name,
1866: G_PKG_NAME,
1867: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1868: x_msg_count,
1869: x_msg_data,
1870: '_PVT'
1871: );

Line 1873: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1869: x_msg_data,
1870: '_PVT'
1871: );
1872: WHEN OTHERS THEN
1873: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1874: (
1875: l_api_name,
1876: G_PKG_NAME,
1877: 'OTHERS',

Line 1891: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1887: ------------------------------------
1888: -- delete_row for:OKL_SLCTD_OPTNS --
1889: ------------------------------------
1890: PROCEDURE delete_row(
1891: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1892: x_return_status OUT NOCOPY VARCHAR2,
1893: x_msg_count OUT NOCOPY NUMBER,
1894: x_msg_data OUT NOCOPY VARCHAR2,
1895: p_csp_rec IN csp_rec_type) IS

Line 1899: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1895: p_csp_rec IN csp_rec_type) IS
1896:
1897: l_api_version CONSTANT NUMBER := 1;
1898: l_api_name CONSTANT VARCHAR2(30) := 'OPTNS_delete_row';
1899: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1900: l_csp_rec csp_rec_type:= p_csp_rec;
1901: l_row_notfound BOOLEAN := TRUE;
1902: BEGIN
1903: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1903: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1899: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1900: l_csp_rec csp_rec_type:= p_csp_rec;
1901: l_row_notfound BOOLEAN := TRUE;
1902: BEGIN
1903: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1904: p_init_msg_list,
1905: '_PVT',
1906: x_return_status);
1907: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1907: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1903: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1904: p_init_msg_list,
1905: '_PVT',
1906: x_return_status);
1907: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1908: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1909: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1910: RAISE OKL_API.G_EXCEPTION_ERROR;
1911: END IF;

Line 1908: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1904: p_init_msg_list,
1905: '_PVT',
1906: x_return_status);
1907: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1908: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1909: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1910: RAISE OKL_API.G_EXCEPTION_ERROR;
1911: END IF;
1912: DELETE FROM OKL_SLCTD_OPTNS

Line 1909: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1905: '_PVT',
1906: x_return_status);
1907: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1908: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1909: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1910: RAISE OKL_API.G_EXCEPTION_ERROR;
1911: END IF;
1912: DELETE FROM OKL_SLCTD_OPTNS
1913: WHERE ID = l_csp_rec.id;

Line 1910: RAISE OKL_API.G_EXCEPTION_ERROR;

1906: x_return_status);
1907: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1908: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1909: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1910: RAISE OKL_API.G_EXCEPTION_ERROR;
1911: END IF;
1912: DELETE FROM OKL_SLCTD_OPTNS
1913: WHERE ID = l_csp_rec.id;
1914:

Line 1915: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1911: END IF;
1912: DELETE FROM OKL_SLCTD_OPTNS
1913: WHERE ID = l_csp_rec.id;
1914:
1915: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1916: EXCEPTION
1917: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1918: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1919: (

Line 1917: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1913: WHERE ID = l_csp_rec.id;
1914:
1915: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1916: EXCEPTION
1917: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1918: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1919: (
1920: l_api_name,
1921: G_PKG_NAME,

Line 1918: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1914:
1915: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1916: EXCEPTION
1917: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1918: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1919: (
1920: l_api_name,
1921: G_PKG_NAME,
1922: 'OKL_API.G_RET_STS_ERROR',

Line 1922: 'OKL_API.G_RET_STS_ERROR',

1918: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1919: (
1920: l_api_name,
1921: G_PKG_NAME,
1922: 'OKL_API.G_RET_STS_ERROR',
1923: x_msg_count,
1924: x_msg_data,
1925: '_PVT'
1926: );

Line 1927: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1923: x_msg_count,
1924: x_msg_data,
1925: '_PVT'
1926: );
1927: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1928: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1929: (
1930: l_api_name,
1931: G_PKG_NAME,

Line 1928: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1924: x_msg_data,
1925: '_PVT'
1926: );
1927: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1928: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1929: (
1930: l_api_name,
1931: G_PKG_NAME,
1932: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1932: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1928: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1929: (
1930: l_api_name,
1931: G_PKG_NAME,
1932: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1933: x_msg_count,
1934: x_msg_data,
1935: '_PVT'
1936: );

Line 1938: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1934: x_msg_data,
1935: '_PVT'
1936: );
1937: WHEN OTHERS THEN
1938: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1939: (
1940: l_api_name,
1941: G_PKG_NAME,
1942: 'OTHERS',

Line 1953: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1949: -- delete_row for:OKL_SLCTD_OPTNS_V --
1950: --------------------------------------
1951: PROCEDURE delete_row(
1952: p_api_version IN NUMBER,
1953: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1954: x_return_status OUT NOCOPY VARCHAR2,
1955: x_msg_count OUT NOCOPY NUMBER,
1956: x_msg_data OUT NOCOPY VARCHAR2,
1957: p_cspv_rec IN cspv_rec_type) IS

Line 1961: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1957: p_cspv_rec IN cspv_rec_type) IS
1958:
1959: l_api_version CONSTANT NUMBER := 1;
1960: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
1961: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1962: l_cspv_rec cspv_rec_type := p_cspv_rec;
1963: l_csp_rec csp_rec_type;
1964: BEGIN
1965: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1965: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1961: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1962: l_cspv_rec cspv_rec_type := p_cspv_rec;
1963: l_csp_rec csp_rec_type;
1964: BEGIN
1965: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1966: G_PKG_NAME,
1967: p_init_msg_list,
1968: l_api_version,
1969: p_api_version,

Line 1972: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1968: l_api_version,
1969: p_api_version,
1970: '_PVT',
1971: x_return_status);
1972: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1973: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1974: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1975: RAISE OKL_API.G_EXCEPTION_ERROR;
1976: END IF;

Line 1973: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1969: p_api_version,
1970: '_PVT',
1971: x_return_status);
1972: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1973: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1974: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1975: RAISE OKL_API.G_EXCEPTION_ERROR;
1976: END IF;
1977: --------------------------------------

Line 1974: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1970: '_PVT',
1971: x_return_status);
1972: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1973: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1974: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1975: RAISE OKL_API.G_EXCEPTION_ERROR;
1976: END IF;
1977: --------------------------------------
1978: -- Move VIEW record to "Child" records

Line 1975: RAISE OKL_API.G_EXCEPTION_ERROR;

1971: x_return_status);
1972: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1973: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1974: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1975: RAISE OKL_API.G_EXCEPTION_ERROR;
1976: END IF;
1977: --------------------------------------
1978: -- Move VIEW record to "Child" records
1979: --------------------------------------

Line 1991: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1987: x_msg_count,
1988: x_msg_data,
1989: l_csp_rec
1990: );
1991: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1992: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1993: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1994: RAISE OKL_API.G_EXCEPTION_ERROR;
1995: END IF;

Line 1992: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1988: x_msg_data,
1989: l_csp_rec
1990: );
1991: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1992: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1993: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1994: RAISE OKL_API.G_EXCEPTION_ERROR;
1995: END IF;
1996: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1993: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1989: l_csp_rec
1990: );
1991: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1992: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1993: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1994: RAISE OKL_API.G_EXCEPTION_ERROR;
1995: END IF;
1996: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1997: EXCEPTION

Line 1994: RAISE OKL_API.G_EXCEPTION_ERROR;

1990: );
1991: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1992: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1993: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1994: RAISE OKL_API.G_EXCEPTION_ERROR;
1995: END IF;
1996: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1997: EXCEPTION
1998: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1996: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1992: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1993: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1994: RAISE OKL_API.G_EXCEPTION_ERROR;
1995: END IF;
1996: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1997: EXCEPTION
1998: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1999: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2000: (

Line 1998: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1994: RAISE OKL_API.G_EXCEPTION_ERROR;
1995: END IF;
1996: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1997: EXCEPTION
1998: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1999: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2000: (
2001: l_api_name,
2002: G_PKG_NAME,

Line 1999: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1995: END IF;
1996: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1997: EXCEPTION
1998: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1999: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2000: (
2001: l_api_name,
2002: G_PKG_NAME,
2003: 'OKL_API.G_RET_STS_ERROR',

Line 2003: 'OKL_API.G_RET_STS_ERROR',

1999: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2000: (
2001: l_api_name,
2002: G_PKG_NAME,
2003: 'OKL_API.G_RET_STS_ERROR',
2004: x_msg_count,
2005: x_msg_data,
2006: '_PVT'
2007: );

Line 2008: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2004: x_msg_count,
2005: x_msg_data,
2006: '_PVT'
2007: );
2008: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2009: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2010: (
2011: l_api_name,
2012: G_PKG_NAME,

Line 2009: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2005: x_msg_data,
2006: '_PVT'
2007: );
2008: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2009: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2010: (
2011: l_api_name,
2012: G_PKG_NAME,
2013: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2013: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2009: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2010: (
2011: l_api_name,
2012: G_PKG_NAME,
2013: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2014: x_msg_count,
2015: x_msg_data,
2016: '_PVT'
2017: );

Line 2019: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2015: x_msg_data,
2016: '_PVT'
2017: );
2018: WHEN OTHERS THEN
2019: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2020: (
2021: l_api_name,
2022: G_PKG_NAME,
2023: 'OTHERS',

Line 2034: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2030: -- PL/SQL TBL delete_row for:CSPV_TBL --
2031: ----------------------------------------
2032: PROCEDURE delete_row(
2033: p_api_version IN NUMBER,
2034: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2035: x_return_status OUT NOCOPY VARCHAR2,
2036: x_msg_count OUT NOCOPY NUMBER,
2037: x_msg_data OUT NOCOPY VARCHAR2,
2038: p_cspv_tbl IN cspv_tbl_type) IS

Line 2042: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2038: p_cspv_tbl IN cspv_tbl_type) IS
2039:
2040: l_api_version CONSTANT NUMBER := 1;
2041: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2042: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2043: i NUMBER := 0;
2044: BEGIN
2045: OKL_API.init_msg_list(p_init_msg_list);
2046: -- Make sure PL/SQL table has records in it before passing

Line 2045: OKL_API.init_msg_list(p_init_msg_list);

2041: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2042: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2043: i NUMBER := 0;
2044: BEGIN
2045: OKL_API.init_msg_list(p_init_msg_list);
2046: -- Make sure PL/SQL table has records in it before passing
2047: IF (p_cspv_tbl.COUNT > 0) THEN
2048: i := p_cspv_tbl.FIRST;
2049: LOOP

Line 2052: p_init_msg_list => OKL_API.G_FALSE,

2048: i := p_cspv_tbl.FIRST;
2049: LOOP
2050: delete_row (
2051: p_api_version => p_api_version,
2052: p_init_msg_list => OKL_API.G_FALSE,
2053: x_return_status => x_return_status,
2054: x_msg_count => x_msg_count,
2055: x_msg_data => x_msg_data,
2056: p_cspv_rec => p_cspv_tbl(i));

Line 2062: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2058: i := p_cspv_tbl.NEXT(i);
2059: END LOOP;
2060: END IF;
2061: EXCEPTION
2062: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2063: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2064: (
2065: l_api_name,
2066: G_PKG_NAME,

Line 2063: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2059: END LOOP;
2060: END IF;
2061: EXCEPTION
2062: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2063: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2064: (
2065: l_api_name,
2066: G_PKG_NAME,
2067: 'OKL_API.G_RET_STS_ERROR',

Line 2067: 'OKL_API.G_RET_STS_ERROR',

2063: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2064: (
2065: l_api_name,
2066: G_PKG_NAME,
2067: 'OKL_API.G_RET_STS_ERROR',
2068: x_msg_count,
2069: x_msg_data,
2070: '_PVT'
2071: );

Line 2072: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2068: x_msg_count,
2069: x_msg_data,
2070: '_PVT'
2071: );
2072: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2073: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2074: (
2075: l_api_name,
2076: G_PKG_NAME,

Line 2073: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2069: x_msg_data,
2070: '_PVT'
2071: );
2072: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2073: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2074: (
2075: l_api_name,
2076: G_PKG_NAME,
2077: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2077: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2073: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2074: (
2075: l_api_name,
2076: G_PKG_NAME,
2077: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2078: x_msg_count,
2079: x_msg_data,
2080: '_PVT'
2081: );

Line 2083: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2079: x_msg_data,
2080: '_PVT'
2081: );
2082: WHEN OTHERS THEN
2083: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2084: (
2085: l_api_name,
2086: G_PKG_NAME,
2087: 'OTHERS',