APPS.OKC_ACY_PVT dependencies on OKC_API

Line 34: x_return_status := OKC_API.G_RET_STS_SUCCESS;

30: from OKC_K_LINES_B
31: where ID = p_acyv_rec.cle_id;
32: Begin
33: -- initialize return status
34: x_return_status := OKC_API.G_RET_STS_SUCCESS;
35:
36: -- check that data exists
37: If (p_acyv_rec.cle_id = OKC_API.G_MISS_NUM or
38: p_acyv_rec.cle_id IS NULL)

Line 37: If (p_acyv_rec.cle_id = OKC_API.G_MISS_NUM or

33: -- initialize return status
34: x_return_status := OKC_API.G_RET_STS_SUCCESS;
35:
36: -- check that data exists
37: If (p_acyv_rec.cle_id = OKC_API.G_MISS_NUM or
38: p_acyv_rec.cle_id IS NULL)
39: Then
40: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
41: p_msg_name => g_required_value,

Line 40: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

36: -- check that data exists
37: If (p_acyv_rec.cle_id = OKC_API.G_MISS_NUM or
38: p_acyv_rec.cle_id IS NULL)
39: Then
40: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
41: p_msg_name => g_required_value,
42: p_token1 => g_col_name_token,
43: p_token1_value => 'cle_id');
44: -- set error flag

Line 45: x_return_status := OKC_API.G_RET_STS_ERROR;

41: p_msg_name => g_required_value,
42: p_token1 => g_col_name_token,
43: p_token1_value => 'cle_id');
44: -- set error flag
45: x_return_status := OKC_API.G_RET_STS_ERROR;
46:
47: -- halt validation
48: raise G_EXCEPTION_HALT_VALIDATION;
49: End If;

Line 58: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

54: Close l_clev_csr;
55:
56: -- if l_dummy_var still set to default, data was not found
57: If (l_dummy_var = '?') Then
58: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
59: p_msg_name => G_NO_PARENT_RECORD,
60: p_token1 => G_COL_NAME_TOKEN,
61: p_token1_value => 'cle_id',
62: p_token2 => G_CHILD_TABLE_TOKEN,

Line 67: x_return_status := OKC_API.G_RET_STS_ERROR;

63: p_token2_value => G_VIEW,
64: p_token3 => G_PARENT_TABLE_TOKEN,
65: p_token3_value => 'OKC_K_LINES_V');
66: -- notify caller of an error
67: x_return_status := OKC_API.G_RET_STS_ERROR;
68: End If;
69: exception
70: when G_EXCEPTION_HALT_VALIDATION then
71: -- no processing necessary; validation can continue with next column

Line 76: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

72: null;
73:
74: when OTHERS then
75: -- store SQL error message on message stack
76: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
77: p_msg_name => g_unexpected_error,
78: p_token1 => g_sqlcode_token,
79: p_token1_value => sqlcode,
80: p_token2 => g_sqlerrm_token,

Line 83: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

79: p_token1_value => sqlcode,
80: p_token2 => g_sqlerrm_token,
81: p_token2_value => sqlerrm);
82: -- set error flag as UNEXPETED error
83: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
84:
85: -- verify that cursor was closed
86: if l_clev_csr%ISOPEN then
87: close l_clev_csr;

Line 111: x_return_status := OKC_API.G_RET_STS_SUCCESS;

107: where ID = p_acyv_rec.cle_id_ascendant;
108:
109: Begin
110: -- initialize return status
111: x_return_status := OKC_API.G_RET_STS_SUCCESS;
112:
113: -- check that data exists
114: If (p_acyv_rec.cle_id_ascendant = OKC_API.G_MISS_NUM or
115: p_acyv_rec.cle_id_ascendant IS NULL)

Line 114: If (p_acyv_rec.cle_id_ascendant = OKC_API.G_MISS_NUM or

110: -- initialize return status
111: x_return_status := OKC_API.G_RET_STS_SUCCESS;
112:
113: -- check that data exists
114: If (p_acyv_rec.cle_id_ascendant = OKC_API.G_MISS_NUM or
115: p_acyv_rec.cle_id_ascendant IS NULL)
116: Then
117: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
118: p_msg_name => g_required_value,

Line 117: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

113: -- check that data exists
114: If (p_acyv_rec.cle_id_ascendant = OKC_API.G_MISS_NUM or
115: p_acyv_rec.cle_id_ascendant IS NULL)
116: Then
117: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
118: p_msg_name => g_required_value,
119: p_token1 => g_col_name_token,
120: p_token1_value => 'cle_id_ascendant');
121: -- set error flag

Line 122: x_return_status := OKC_API.G_RET_STS_ERROR;

118: p_msg_name => g_required_value,
119: p_token1 => g_col_name_token,
120: p_token1_value => 'cle_id_ascendant');
121: -- set error flag
122: x_return_status := OKC_API.G_RET_STS_ERROR;
123:
124: -- halt validation
125: raise G_EXCEPTION_HALT_VALIDATION;
126: End If;

Line 135: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

131: Close l_clev_csr;
132:
133: -- if l_dummy_var still set to default, data was not found
134: If (l_dummy_var = '?') Then
135: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
136: p_msg_name => g_no_parent_record,
137: p_token1 => g_col_name_token,
138: p_token1_value => 'cle_id_ascendant',
139: p_token2 => g_child_table_token,

Line 144: x_return_status := OKC_API.G_RET_STS_ERROR;

140: p_token2_value => G_VIEW,
141: p_token3 => g_parent_table_token,
142: p_token3_value => 'OKC_K_LINES_V');
143: -- notify caller of an error
144: x_return_status := OKC_API.G_RET_STS_ERROR;
145: End If;
146:
147: exception
148: when G_EXCEPTION_HALT_VALIDATION then

Line 154: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

150: null;
151:
152: when OTHERS then
153: -- store SQL error message on message stack
154: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
155: p_msg_name => g_unexpected_error,
156: p_token1 => g_sqlcode_token,
157: p_token1_value => sqlcode,
158: p_token2 => g_sqlerrm_token,

Line 161: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

157: p_token1_value => sqlcode,
158: p_token2 => g_sqlerrm_token,
159: p_token2_value => sqlerrm);
160: -- set error flag as UNEXPETED error
161: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
162:
163: -- verify that cursor was closed
164: if l_clev_csr%ISOPEN then
165: close l_clev_csr;

Line 183: x_return_status := OKC_API.G_RET_STS_SUCCESS;

179: p_acyv_rec IN acyv_rec_type) is
180:
181: Begin
182: -- initialize return status
183: x_return_status := OKC_API.G_RET_STS_SUCCESS;
184:
185: -- check that data exists
186: If (p_acyv_rec.level_sequence = OKC_API.G_MISS_NUM or
187: p_acyv_rec.level_sequence IS NULL)

Line 186: If (p_acyv_rec.level_sequence = OKC_API.G_MISS_NUM or

182: -- initialize return status
183: x_return_status := OKC_API.G_RET_STS_SUCCESS;
184:
185: -- check that data exists
186: If (p_acyv_rec.level_sequence = OKC_API.G_MISS_NUM or
187: p_acyv_rec.level_sequence IS NULL)
188: Then
189: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
190: p_msg_name => g_required_value,

Line 189: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

185: -- check that data exists
186: If (p_acyv_rec.level_sequence = OKC_API.G_MISS_NUM or
187: p_acyv_rec.level_sequence IS NULL)
188: Then
189: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
190: p_msg_name => g_required_value,
191: p_token1 => g_col_name_token,
192: p_token1_value => 'level_sequence');
193: -- set error flag

Line 194: x_return_status := OKC_API.G_RET_STS_ERROR;

190: p_msg_name => g_required_value,
191: p_token1 => g_col_name_token,
192: p_token1_value => 'level_sequence');
193: -- set error flag
194: x_return_status := OKC_API.G_RET_STS_ERROR;
195:
196: -- halt validation
197: raise G_EXCEPTION_HALT_VALIDATION;
198: End If;

Line 207: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

203: null;
204:
205: when OTHERS then
206: -- store SQL error message on message stack
207: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
208: p_msg_name => g_unexpected_error,
209: p_token1 => g_sqlcode_token,
210: p_token1_value => sqlcode,
211: p_token2 => g_sqlerrm_token,

Line 214: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

210: p_token1_value => sqlcode,
211: p_token2 => g_sqlerrm_token,
212: p_token2_value => sqlerrm);
213: -- set error flag as UNEXPETED error
214: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
215: End validate_level_sequence;
216:
217: /*********************** END HAND-CODED ********************************/
218: ---------------------------------------------------------------------------

Line 361: IF (l_acyv_rec.cle_id = OKC_API.G_MISS_NUM) THEN

357: p_acyv_rec IN acyv_rec_type
358: ) RETURN acyv_rec_type IS
359: l_acyv_rec acyv_rec_type := p_acyv_rec;
360: BEGIN
361: IF (l_acyv_rec.cle_id = OKC_API.G_MISS_NUM) THEN
362: l_acyv_rec.cle_id := NULL;
363: END IF;
364: IF (l_acyv_rec.cle_id_ascendant = OKC_API.G_MISS_NUM) THEN
365: l_acyv_rec.cle_id_ascendant := NULL;

Line 364: IF (l_acyv_rec.cle_id_ascendant = OKC_API.G_MISS_NUM) THEN

360: BEGIN
361: IF (l_acyv_rec.cle_id = OKC_API.G_MISS_NUM) THEN
362: l_acyv_rec.cle_id := NULL;
363: END IF;
364: IF (l_acyv_rec.cle_id_ascendant = OKC_API.G_MISS_NUM) THEN
365: l_acyv_rec.cle_id_ascendant := NULL;
366: END IF;
367: IF (l_acyv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
368: l_acyv_rec.object_version_number := NULL;

Line 367: IF (l_acyv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

363: END IF;
364: IF (l_acyv_rec.cle_id_ascendant = OKC_API.G_MISS_NUM) THEN
365: l_acyv_rec.cle_id_ascendant := NULL;
366: END IF;
367: IF (l_acyv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
368: l_acyv_rec.object_version_number := NULL;
369: END IF;
370: IF (l_acyv_rec.level_sequence = OKC_API.G_MISS_NUM) THEN
371: l_acyv_rec.level_sequence := NULL;

Line 370: IF (l_acyv_rec.level_sequence = OKC_API.G_MISS_NUM) THEN

366: END IF;
367: IF (l_acyv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
368: l_acyv_rec.object_version_number := NULL;
369: END IF;
370: IF (l_acyv_rec.level_sequence = OKC_API.G_MISS_NUM) THEN
371: l_acyv_rec.level_sequence := NULL;
372: END IF;
373: IF (l_acyv_rec.created_by = OKC_API.G_MISS_NUM) THEN
374: l_acyv_rec.created_by := NULL;

Line 373: IF (l_acyv_rec.created_by = OKC_API.G_MISS_NUM) THEN

369: END IF;
370: IF (l_acyv_rec.level_sequence = OKC_API.G_MISS_NUM) THEN
371: l_acyv_rec.level_sequence := NULL;
372: END IF;
373: IF (l_acyv_rec.created_by = OKC_API.G_MISS_NUM) THEN
374: l_acyv_rec.created_by := NULL;
375: END IF;
376: IF (l_acyv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
377: l_acyv_rec.creation_date := NULL;

Line 376: IF (l_acyv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

372: END IF;
373: IF (l_acyv_rec.created_by = OKC_API.G_MISS_NUM) THEN
374: l_acyv_rec.created_by := NULL;
375: END IF;
376: IF (l_acyv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
377: l_acyv_rec.creation_date := NULL;
378: END IF;
379: IF (l_acyv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
380: l_acyv_rec.last_updated_by := NULL;

Line 379: IF (l_acyv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

375: END IF;
376: IF (l_acyv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
377: l_acyv_rec.creation_date := NULL;
378: END IF;
379: IF (l_acyv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
380: l_acyv_rec.last_updated_by := NULL;
381: END IF;
382: IF (l_acyv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
383: l_acyv_rec.last_update_date := NULL;

Line 382: IF (l_acyv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

378: END IF;
379: IF (l_acyv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
380: l_acyv_rec.last_updated_by := NULL;
381: END IF;
382: IF (l_acyv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
383: l_acyv_rec.last_update_date := NULL;
384: END IF;
385: IF (l_acyv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
386: l_acyv_rec.last_update_login := NULL;

Line 385: IF (l_acyv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

381: END IF;
382: IF (l_acyv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
383: l_acyv_rec.last_update_date := NULL;
384: END IF;
385: IF (l_acyv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
386: l_acyv_rec.last_update_login := NULL;
387: END IF;
388: RETURN(l_acyv_rec);
389: END null_out_defaults;

Line 399: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

395: ---------------------------------------------
396: FUNCTION Validate_Attributes (
397: p_acyv_rec IN acyv_rec_type
398: ) RETURN VARCHAR2 IS
399: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
400: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
401: BEGIN
402: /************************ HAND-CODED *********************************/
403: validate_cle_id

Line 400: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

396: FUNCTION Validate_Attributes (
397: p_acyv_rec IN acyv_rec_type
398: ) RETURN VARCHAR2 IS
399: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
400: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
401: BEGIN
402: /************************ HAND-CODED *********************************/
403: validate_cle_id
404: (x_return_status => l_return_status,

Line 408: If l_return_status <> OKC_API.G_RET_STS_SUCCESS Then

404: (x_return_status => l_return_status,
405: p_acyv_rec => p_acyv_rec);
406:
407: -- store the highest degree of error
408: If l_return_status <> OKC_API.G_RET_STS_SUCCESS Then
409: If x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
410: x_return_status := l_return_status;
411: End If;
412: End If;

Line 409: If x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

405: p_acyv_rec => p_acyv_rec);
406:
407: -- store the highest degree of error
408: If l_return_status <> OKC_API.G_RET_STS_SUCCESS Then
409: If x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
410: x_return_status := l_return_status;
411: End If;
412: End If;
413:

Line 419: If l_return_status <> OKC_API.G_RET_STS_SUCCESS Then

415: (x_return_status => l_return_status,
416: p_acyv_rec => p_acyv_rec);
417:
418: -- store the highest degree of error
419: If l_return_status <> OKC_API.G_RET_STS_SUCCESS Then
420: If x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
421: x_return_status := l_return_status;
422: End If;
423: End If;

Line 420: If x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

416: p_acyv_rec => p_acyv_rec);
417:
418: -- store the highest degree of error
419: If l_return_status <> OKC_API.G_RET_STS_SUCCESS Then
420: If x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
421: x_return_status := l_return_status;
422: End If;
423: End If;
424:

Line 430: If l_return_status <> OKC_API.G_RET_STS_SUCCESS Then

426: (x_return_status => l_return_status,
427: p_acyv_rec => p_acyv_rec);
428:
429: -- store the highest degree of error
430: If l_return_status <> OKC_API.G_RET_STS_SUCCESS Then
431: If x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
432: x_return_status := l_return_status;
433: End If;
434: End If;

Line 431: If x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

427: p_acyv_rec => p_acyv_rec);
428:
429: -- store the highest degree of error
430: If l_return_status <> OKC_API.G_RET_STS_SUCCESS Then
431: If x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
432: x_return_status := l_return_status;
433: End If;
434: End If;
435:

Line 440: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

436: RETURN(x_return_status);
437: exception
438: when OTHERS then
439: -- store SQL error message on message stack
440: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
441: p_msg_name => g_unexpected_error,
442: p_token1 => g_sqlcode_token,
443: p_token1_value => sqlcode,
444: p_token2 => g_sqlerrm_token,

Line 448: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

444: p_token2 => g_sqlerrm_token,
445: p_token2_value => sqlerrm);
446:
447: -- notify caller of an UNEXPETED error
448: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
449:
450: -- return status to caller
451: RETURN(x_return_status);
452: /*********************** END HAND-CODED ********************************/

Line 464: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

460: -----------------------------------------
461: FUNCTION Validate_Record (
462: p_acyv_rec IN acyv_rec_type
463: ) RETURN VARCHAR2 IS
464: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
465: BEGIN
466: RETURN (l_return_status);
467: END Validate_Record;
468:

Line 519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

515: p_acyv_rec IN acyv_rec_type) IS
516:
517: l_api_version CONSTANT NUMBER := 1;
518: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
520: l_acyv_rec acyv_rec_type := p_acyv_rec;
521: l_acy_rec acy_rec_type;
522: BEGIN
523: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 523: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
520: l_acyv_rec acyv_rec_type := p_acyv_rec;
521: l_acy_rec acy_rec_type;
522: BEGIN
523: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
524: G_PKG_NAME,
525: p_init_msg_list,
526: l_api_version,
527: p_api_version,

Line 530: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

526: l_api_version,
527: p_api_version,
528: '_PVT',
529: x_return_status);
530: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
531: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
532: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
533: RAISE OKC_API.G_EXCEPTION_ERROR;
534: END IF;

Line 531: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

527: p_api_version,
528: '_PVT',
529: x_return_status);
530: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
531: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
532: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
533: RAISE OKC_API.G_EXCEPTION_ERROR;
534: END IF;
535: --- Validate all non-missing attributes (Item Level Validation)

Line 532: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

528: '_PVT',
529: x_return_status);
530: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
531: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
532: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
533: RAISE OKC_API.G_EXCEPTION_ERROR;
534: END IF;
535: --- Validate all non-missing attributes (Item Level Validation)
536: l_return_status := Validate_Attributes(l_acyv_rec);

Line 533: RAISE OKC_API.G_EXCEPTION_ERROR;

529: x_return_status);
530: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
531: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
532: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
533: RAISE OKC_API.G_EXCEPTION_ERROR;
534: END IF;
535: --- Validate all non-missing attributes (Item Level Validation)
536: l_return_status := Validate_Attributes(l_acyv_rec);
537: --- If any errors happen abort API

Line 538: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

534: END IF;
535: --- Validate all non-missing attributes (Item Level Validation)
536: l_return_status := Validate_Attributes(l_acyv_rec);
537: --- If any errors happen abort API
538: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
539: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
541: RAISE OKC_API.G_EXCEPTION_ERROR;
542: END IF;

Line 539: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

535: --- Validate all non-missing attributes (Item Level Validation)
536: l_return_status := Validate_Attributes(l_acyv_rec);
537: --- If any errors happen abort API
538: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
539: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
541: RAISE OKC_API.G_EXCEPTION_ERROR;
542: END IF;
543: l_return_status := Validate_Record(l_acyv_rec);

Line 540: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

536: l_return_status := Validate_Attributes(l_acyv_rec);
537: --- If any errors happen abort API
538: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
539: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
541: RAISE OKC_API.G_EXCEPTION_ERROR;
542: END IF;
543: l_return_status := Validate_Record(l_acyv_rec);
544: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 541: RAISE OKC_API.G_EXCEPTION_ERROR;

537: --- If any errors happen abort API
538: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
539: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
541: RAISE OKC_API.G_EXCEPTION_ERROR;
542: END IF;
543: l_return_status := Validate_Record(l_acyv_rec);
544: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 544: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

540: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
541: RAISE OKC_API.G_EXCEPTION_ERROR;
542: END IF;
543: l_return_status := Validate_Record(l_acyv_rec);
544: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
546: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
547: RAISE OKC_API.G_EXCEPTION_ERROR;
548: END IF;

Line 545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

541: RAISE OKC_API.G_EXCEPTION_ERROR;
542: END IF;
543: l_return_status := Validate_Record(l_acyv_rec);
544: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
546: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
547: RAISE OKC_API.G_EXCEPTION_ERROR;
548: END IF;
549: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 546: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

542: END IF;
543: l_return_status := Validate_Record(l_acyv_rec);
544: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
546: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
547: RAISE OKC_API.G_EXCEPTION_ERROR;
548: END IF;
549: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
550: EXCEPTION

Line 547: RAISE OKC_API.G_EXCEPTION_ERROR;

543: l_return_status := Validate_Record(l_acyv_rec);
544: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
546: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
547: RAISE OKC_API.G_EXCEPTION_ERROR;
548: END IF;
549: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
550: EXCEPTION
551: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 549: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
546: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
547: RAISE OKC_API.G_EXCEPTION_ERROR;
548: END IF;
549: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
550: EXCEPTION
551: WHEN OKC_API.G_EXCEPTION_ERROR THEN
552: x_return_status := OKC_API.HANDLE_EXCEPTIONS
553: (

Line 551: WHEN OKC_API.G_EXCEPTION_ERROR THEN

547: RAISE OKC_API.G_EXCEPTION_ERROR;
548: END IF;
549: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
550: EXCEPTION
551: WHEN OKC_API.G_EXCEPTION_ERROR THEN
552: x_return_status := OKC_API.HANDLE_EXCEPTIONS
553: (
554: l_api_name,
555: G_PKG_NAME,

Line 552: x_return_status := OKC_API.HANDLE_EXCEPTIONS

548: END IF;
549: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
550: EXCEPTION
551: WHEN OKC_API.G_EXCEPTION_ERROR THEN
552: x_return_status := OKC_API.HANDLE_EXCEPTIONS
553: (
554: l_api_name,
555: G_PKG_NAME,
556: 'OKC_API.G_RET_STS_ERROR',

Line 556: 'OKC_API.G_RET_STS_ERROR',

552: x_return_status := OKC_API.HANDLE_EXCEPTIONS
553: (
554: l_api_name,
555: G_PKG_NAME,
556: 'OKC_API.G_RET_STS_ERROR',
557: x_msg_count,
558: x_msg_data,
559: '_PVT'
560: );

Line 561: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

557: x_msg_count,
558: x_msg_data,
559: '_PVT'
560: );
561: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
562: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
563: (
564: l_api_name,
565: G_PKG_NAME,

Line 562: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

558: x_msg_data,
559: '_PVT'
560: );
561: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
562: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
563: (
564: l_api_name,
565: G_PKG_NAME,
566: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 566: 'OKC_API.G_RET_STS_UNEXP_ERROR',

562: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
563: (
564: l_api_name,
565: G_PKG_NAME,
566: 'OKC_API.G_RET_STS_UNEXP_ERROR',
567: x_msg_count,
568: x_msg_data,
569: '_PVT'
570: );

Line 572: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

568: x_msg_data,
569: '_PVT'
570: );
571: WHEN OTHERS THEN
572: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
573: (
574: l_api_name,
575: G_PKG_NAME,
576: 'OTHERS',

Line 595: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

591: p_acyv_tbl IN acyv_tbl_type) IS
592:
593: l_api_version CONSTANT NUMBER := 1;
594: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
595: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
596: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
597: i NUMBER := 0;
598: BEGIN
599: OKC_API.init_msg_list(p_init_msg_list);

Line 596: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

592:
593: l_api_version CONSTANT NUMBER := 1;
594: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
595: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
596: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
597: i NUMBER := 0;
598: BEGIN
599: OKC_API.init_msg_list(p_init_msg_list);
600: -- Make sure PL/SQL table has records in it before passing

Line 599: OKC_API.init_msg_list(p_init_msg_list);

595: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
596: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
597: i NUMBER := 0;
598: BEGIN
599: OKC_API.init_msg_list(p_init_msg_list);
600: -- Make sure PL/SQL table has records in it before passing
601: IF (p_acyv_tbl.COUNT > 0) THEN
602: i := p_acyv_tbl.FIRST;
603: LOOP

Line 606: p_init_msg_list => OKC_API.G_FALSE,

602: i := p_acyv_tbl.FIRST;
603: LOOP
604: validate_row (
605: p_api_version => p_api_version,
606: p_init_msg_list => OKC_API.G_FALSE,
607: x_return_status => x_return_status,
608: x_msg_count => x_msg_count,
609: x_msg_data => x_msg_data,
610: p_acyv_rec => p_acyv_tbl(i));

Line 613: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

609: x_msg_data => x_msg_data,
610: p_acyv_rec => p_acyv_tbl(i));
611:
612: -- store the highest degree of error
613: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
614: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
615: l_overall_status := x_return_status;
616: End If;
617: End If;

Line 614: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

610: p_acyv_rec => p_acyv_tbl(i));
611:
612: -- store the highest degree of error
613: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
614: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
615: l_overall_status := x_return_status;
616: End If;
617: End If;
618:

Line 626: WHEN OKC_API.G_EXCEPTION_ERROR THEN

622: -- return overall status
623: x_return_status := l_overall_status;
624: END IF;
625: EXCEPTION
626: WHEN OKC_API.G_EXCEPTION_ERROR THEN
627: x_return_status := OKC_API.HANDLE_EXCEPTIONS
628: (
629: l_api_name,
630: G_PKG_NAME,

Line 627: x_return_status := OKC_API.HANDLE_EXCEPTIONS

623: x_return_status := l_overall_status;
624: END IF;
625: EXCEPTION
626: WHEN OKC_API.G_EXCEPTION_ERROR THEN
627: x_return_status := OKC_API.HANDLE_EXCEPTIONS
628: (
629: l_api_name,
630: G_PKG_NAME,
631: 'OKC_API.G_RET_STS_ERROR',

Line 631: 'OKC_API.G_RET_STS_ERROR',

627: x_return_status := OKC_API.HANDLE_EXCEPTIONS
628: (
629: l_api_name,
630: G_PKG_NAME,
631: 'OKC_API.G_RET_STS_ERROR',
632: x_msg_count,
633: x_msg_data,
634: '_PVT'
635: );

Line 636: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

632: x_msg_count,
633: x_msg_data,
634: '_PVT'
635: );
636: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
637: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
638: (
639: l_api_name,
640: G_PKG_NAME,

Line 637: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

633: x_msg_data,
634: '_PVT'
635: );
636: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
637: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
638: (
639: l_api_name,
640: G_PKG_NAME,
641: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 641: 'OKC_API.G_RET_STS_UNEXP_ERROR',

637: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
638: (
639: l_api_name,
640: G_PKG_NAME,
641: 'OKC_API.G_RET_STS_UNEXP_ERROR',
642: x_msg_count,
643: x_msg_data,
644: '_PVT'
645: );

Line 647: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

643: x_msg_data,
644: '_PVT'
645: );
646: WHEN OTHERS THEN
647: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
648: (
649: l_api_name,
650: G_PKG_NAME,
651: 'OTHERS',

Line 674: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

670: x_acy_rec OUT NOCOPY acy_rec_type) IS
671:
672: l_api_version CONSTANT NUMBER := 1;
673: l_api_name CONSTANT VARCHAR2(30) := 'ANCESTRYS_insert_row';
674: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
675: l_acy_rec acy_rec_type := p_acy_rec;
676: l_def_acy_rec acy_rec_type;
677: --------------------------------------
678: -- Set_Attributes for:OKC_ANCESTRYS --

Line 684: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

680: FUNCTION Set_Attributes (
681: p_acy_rec IN acy_rec_type,
682: x_acy_rec OUT NOCOPY acy_rec_type
683: ) RETURN VARCHAR2 IS
684: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
685: BEGIN
686: x_acy_rec := p_acy_rec;
687: RETURN(l_return_status);
688: END Set_Attributes;

Line 690: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

686: x_acy_rec := p_acy_rec;
687: RETURN(l_return_status);
688: END Set_Attributes;
689: BEGIN
690: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
691: p_init_msg_list,
692: '_PVT',
693: x_return_status);
694: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 694: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

690: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
691: p_init_msg_list,
692: '_PVT',
693: x_return_status);
694: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
695: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
696: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
697: RAISE OKC_API.G_EXCEPTION_ERROR;
698: END IF;

Line 695: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

691: p_init_msg_list,
692: '_PVT',
693: x_return_status);
694: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
695: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
696: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
697: RAISE OKC_API.G_EXCEPTION_ERROR;
698: END IF;
699: --- Setting item attributes

Line 696: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

692: '_PVT',
693: x_return_status);
694: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
695: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
696: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
697: RAISE OKC_API.G_EXCEPTION_ERROR;
698: END IF;
699: --- Setting item attributes
700: l_return_status := Set_Attributes(

Line 697: RAISE OKC_API.G_EXCEPTION_ERROR;

693: x_return_status);
694: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
695: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
696: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
697: RAISE OKC_API.G_EXCEPTION_ERROR;
698: END IF;
699: --- Setting item attributes
700: l_return_status := Set_Attributes(
701: p_acy_rec, -- IN

Line 704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

700: l_return_status := Set_Attributes(
701: p_acy_rec, -- IN
702: l_acy_rec); -- OUT
703: --- If any errors happen abort API
704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
707: RAISE OKC_API.G_EXCEPTION_ERROR;
708: END IF;

Line 705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

701: p_acy_rec, -- IN
702: l_acy_rec); -- OUT
703: --- If any errors happen abort API
704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
707: RAISE OKC_API.G_EXCEPTION_ERROR;
708: END IF;
709: INSERT INTO OKC_ANCESTRYS(

Line 706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

702: l_acy_rec); -- OUT
703: --- If any errors happen abort API
704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
707: RAISE OKC_API.G_EXCEPTION_ERROR;
708: END IF;
709: INSERT INTO OKC_ANCESTRYS(
710: cle_id,

Line 707: RAISE OKC_API.G_EXCEPTION_ERROR;

703: --- If any errors happen abort API
704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
707: RAISE OKC_API.G_EXCEPTION_ERROR;
708: END IF;
709: INSERT INTO OKC_ANCESTRYS(
710: cle_id,
711: cle_id_ascendant,

Line 731: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

727: l_acy_rec.last_update_date,
728: l_acy_rec.last_update_login);
729: -- Set OUT values
730: x_acy_rec := l_acy_rec;
731: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
732: EXCEPTION
733: WHEN OKC_API.G_EXCEPTION_ERROR THEN
734: x_return_status := OKC_API.HANDLE_EXCEPTIONS
735: (

Line 733: WHEN OKC_API.G_EXCEPTION_ERROR THEN

729: -- Set OUT values
730: x_acy_rec := l_acy_rec;
731: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
732: EXCEPTION
733: WHEN OKC_API.G_EXCEPTION_ERROR THEN
734: x_return_status := OKC_API.HANDLE_EXCEPTIONS
735: (
736: l_api_name,
737: G_PKG_NAME,

Line 734: x_return_status := OKC_API.HANDLE_EXCEPTIONS

730: x_acy_rec := l_acy_rec;
731: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
732: EXCEPTION
733: WHEN OKC_API.G_EXCEPTION_ERROR THEN
734: x_return_status := OKC_API.HANDLE_EXCEPTIONS
735: (
736: l_api_name,
737: G_PKG_NAME,
738: 'OKC_API.G_RET_STS_ERROR',

Line 738: 'OKC_API.G_RET_STS_ERROR',

734: x_return_status := OKC_API.HANDLE_EXCEPTIONS
735: (
736: l_api_name,
737: G_PKG_NAME,
738: 'OKC_API.G_RET_STS_ERROR',
739: x_msg_count,
740: x_msg_data,
741: '_PVT'
742: );

Line 743: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

739: x_msg_count,
740: x_msg_data,
741: '_PVT'
742: );
743: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
744: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
745: (
746: l_api_name,
747: G_PKG_NAME,

Line 744: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

740: x_msg_data,
741: '_PVT'
742: );
743: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
744: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
745: (
746: l_api_name,
747: G_PKG_NAME,
748: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 748: 'OKC_API.G_RET_STS_UNEXP_ERROR',

744: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
745: (
746: l_api_name,
747: G_PKG_NAME,
748: 'OKC_API.G_RET_STS_UNEXP_ERROR',
749: x_msg_count,
750: x_msg_data,
751: '_PVT'
752: );

Line 754: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

750: x_msg_data,
751: '_PVT'
752: );
753: WHEN OTHERS THEN
754: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
755: (
756: l_api_name,
757: G_PKG_NAME,
758: 'OTHERS',

Line 778: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

774: x_acyv_rec OUT NOCOPY acyv_rec_type) IS
775:
776: l_api_version CONSTANT NUMBER := 1;
777: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
778: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
779: l_acyv_rec acyv_rec_type;
780: l_def_acyv_rec acyv_rec_type;
781: l_acy_rec acy_rec_type;
782: lx_acy_rec acy_rec_type;

Line 805: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

801: FUNCTION Set_Attributes (
802: p_acyv_rec IN acyv_rec_type,
803: x_acyv_rec OUT NOCOPY acyv_rec_type
804: ) RETURN VARCHAR2 IS
805: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
806: BEGIN
807: x_acyv_rec := p_acyv_rec;
808: x_acyv_rec.OBJECT_VERSION_NUMBER := 1;
809: RETURN(l_return_status);

Line 812: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

808: x_acyv_rec.OBJECT_VERSION_NUMBER := 1;
809: RETURN(l_return_status);
810: END Set_Attributes;
811: BEGIN
812: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
813: G_PKG_NAME,
814: p_init_msg_list,
815: l_api_version,
816: p_api_version,

Line 819: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

815: l_api_version,
816: p_api_version,
817: '_PVT',
818: x_return_status);
819: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
820: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
821: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
822: RAISE OKC_API.G_EXCEPTION_ERROR;
823: END IF;

Line 820: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

816: p_api_version,
817: '_PVT',
818: x_return_status);
819: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
820: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
821: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
822: RAISE OKC_API.G_EXCEPTION_ERROR;
823: END IF;
824: l_acyv_rec := null_out_defaults(p_acyv_rec);

Line 821: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

817: '_PVT',
818: x_return_status);
819: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
820: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
821: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
822: RAISE OKC_API.G_EXCEPTION_ERROR;
823: END IF;
824: l_acyv_rec := null_out_defaults(p_acyv_rec);
825: --- Setting item attributes

Line 822: RAISE OKC_API.G_EXCEPTION_ERROR;

818: x_return_status);
819: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
820: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
821: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
822: RAISE OKC_API.G_EXCEPTION_ERROR;
823: END IF;
824: l_acyv_rec := null_out_defaults(p_acyv_rec);
825: --- Setting item attributes
826: l_return_status := Set_Attributes(

Line 830: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

826: l_return_status := Set_Attributes(
827: l_acyv_rec, -- IN
828: l_def_acyv_rec); -- OUT
829: --- If any errors happen abort API
830: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
831: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
832: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
833: RAISE OKC_API.G_EXCEPTION_ERROR;
834: END IF;

Line 831: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

827: l_acyv_rec, -- IN
828: l_def_acyv_rec); -- OUT
829: --- If any errors happen abort API
830: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
831: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
832: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
833: RAISE OKC_API.G_EXCEPTION_ERROR;
834: END IF;
835: l_def_acyv_rec := fill_who_columns(l_def_acyv_rec);

Line 832: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

828: l_def_acyv_rec); -- OUT
829: --- If any errors happen abort API
830: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
831: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
832: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
833: RAISE OKC_API.G_EXCEPTION_ERROR;
834: END IF;
835: l_def_acyv_rec := fill_who_columns(l_def_acyv_rec);
836: --- Validate all non-missing attributes (Item Level Validation)

Line 833: RAISE OKC_API.G_EXCEPTION_ERROR;

829: --- If any errors happen abort API
830: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
831: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
832: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
833: RAISE OKC_API.G_EXCEPTION_ERROR;
834: END IF;
835: l_def_acyv_rec := fill_who_columns(l_def_acyv_rec);
836: --- Validate all non-missing attributes (Item Level Validation)
837: l_return_status := Validate_Attributes(l_def_acyv_rec);

Line 839: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

835: l_def_acyv_rec := fill_who_columns(l_def_acyv_rec);
836: --- Validate all non-missing attributes (Item Level Validation)
837: l_return_status := Validate_Attributes(l_def_acyv_rec);
838: --- If any errors happen abort API
839: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
840: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
841: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
842: RAISE OKC_API.G_EXCEPTION_ERROR;
843: END IF;

Line 840: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

836: --- Validate all non-missing attributes (Item Level Validation)
837: l_return_status := Validate_Attributes(l_def_acyv_rec);
838: --- If any errors happen abort API
839: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
840: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
841: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
842: RAISE OKC_API.G_EXCEPTION_ERROR;
843: END IF;
844: l_return_status := Validate_Record(l_def_acyv_rec);

Line 841: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

837: l_return_status := Validate_Attributes(l_def_acyv_rec);
838: --- If any errors happen abort API
839: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
840: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
841: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
842: RAISE OKC_API.G_EXCEPTION_ERROR;
843: END IF;
844: l_return_status := Validate_Record(l_def_acyv_rec);
845: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 842: RAISE OKC_API.G_EXCEPTION_ERROR;

838: --- If any errors happen abort API
839: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
840: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
841: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
842: RAISE OKC_API.G_EXCEPTION_ERROR;
843: END IF;
844: l_return_status := Validate_Record(l_def_acyv_rec);
845: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 845: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

841: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
842: RAISE OKC_API.G_EXCEPTION_ERROR;
843: END IF;
844: l_return_status := Validate_Record(l_def_acyv_rec);
845: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
847: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
848: RAISE OKC_API.G_EXCEPTION_ERROR;
849: END IF;

Line 846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

842: RAISE OKC_API.G_EXCEPTION_ERROR;
843: END IF;
844: l_return_status := Validate_Record(l_def_acyv_rec);
845: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
847: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
848: RAISE OKC_API.G_EXCEPTION_ERROR;
849: END IF;
850: --------------------------------------

Line 847: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

843: END IF;
844: l_return_status := Validate_Record(l_def_acyv_rec);
845: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
847: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
848: RAISE OKC_API.G_EXCEPTION_ERROR;
849: END IF;
850: --------------------------------------
851: -- Move VIEW record to "Child" records

Line 848: RAISE OKC_API.G_EXCEPTION_ERROR;

844: l_return_status := Validate_Record(l_def_acyv_rec);
845: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
847: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
848: RAISE OKC_API.G_EXCEPTION_ERROR;
849: END IF;
850: --------------------------------------
851: -- Move VIEW record to "Child" records
852: --------------------------------------

Line 865: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

861: x_msg_data,
862: l_acy_rec,
863: lx_acy_rec
864: );
865: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
866: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
867: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
868: RAISE OKC_API.G_EXCEPTION_ERROR;
869: END IF;

Line 866: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

862: l_acy_rec,
863: lx_acy_rec
864: );
865: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
866: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
867: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
868: RAISE OKC_API.G_EXCEPTION_ERROR;
869: END IF;
870: migrate(lx_acy_rec, l_def_acyv_rec);

Line 867: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

863: lx_acy_rec
864: );
865: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
866: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
867: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
868: RAISE OKC_API.G_EXCEPTION_ERROR;
869: END IF;
870: migrate(lx_acy_rec, l_def_acyv_rec);
871: -- Set OUT values

Line 868: RAISE OKC_API.G_EXCEPTION_ERROR;

864: );
865: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
866: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
867: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
868: RAISE OKC_API.G_EXCEPTION_ERROR;
869: END IF;
870: migrate(lx_acy_rec, l_def_acyv_rec);
871: -- Set OUT values
872: x_acyv_rec := l_def_acyv_rec;

Line 873: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

869: END IF;
870: migrate(lx_acy_rec, l_def_acyv_rec);
871: -- Set OUT values
872: x_acyv_rec := l_def_acyv_rec;
873: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
874: EXCEPTION
875: WHEN OKC_API.G_EXCEPTION_ERROR THEN
876: x_return_status := OKC_API.HANDLE_EXCEPTIONS
877: (

Line 875: WHEN OKC_API.G_EXCEPTION_ERROR THEN

871: -- Set OUT values
872: x_acyv_rec := l_def_acyv_rec;
873: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
874: EXCEPTION
875: WHEN OKC_API.G_EXCEPTION_ERROR THEN
876: x_return_status := OKC_API.HANDLE_EXCEPTIONS
877: (
878: l_api_name,
879: G_PKG_NAME,

Line 876: x_return_status := OKC_API.HANDLE_EXCEPTIONS

872: x_acyv_rec := l_def_acyv_rec;
873: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
874: EXCEPTION
875: WHEN OKC_API.G_EXCEPTION_ERROR THEN
876: x_return_status := OKC_API.HANDLE_EXCEPTIONS
877: (
878: l_api_name,
879: G_PKG_NAME,
880: 'OKC_API.G_RET_STS_ERROR',

Line 880: 'OKC_API.G_RET_STS_ERROR',

876: x_return_status := OKC_API.HANDLE_EXCEPTIONS
877: (
878: l_api_name,
879: G_PKG_NAME,
880: 'OKC_API.G_RET_STS_ERROR',
881: x_msg_count,
882: x_msg_data,
883: '_PVT'
884: );

Line 885: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

881: x_msg_count,
882: x_msg_data,
883: '_PVT'
884: );
885: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
886: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
887: (
888: l_api_name,
889: G_PKG_NAME,

Line 886: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

882: x_msg_data,
883: '_PVT'
884: );
885: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
886: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
887: (
888: l_api_name,
889: G_PKG_NAME,
890: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 890: 'OKC_API.G_RET_STS_UNEXP_ERROR',

886: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
887: (
888: l_api_name,
889: G_PKG_NAME,
890: 'OKC_API.G_RET_STS_UNEXP_ERROR',
891: x_msg_count,
892: x_msg_data,
893: '_PVT'
894: );

Line 896: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

892: x_msg_data,
893: '_PVT'
894: );
895: WHEN OTHERS THEN
896: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
897: (
898: l_api_name,
899: G_PKG_NAME,
900: 'OTHERS',

Line 920: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

916: x_acyv_tbl OUT NOCOPY acyv_tbl_type) IS
917:
918: l_api_version CONSTANT NUMBER := 1;
919: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
920: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
921: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
922: i NUMBER := 0;
923: BEGIN
924: OKC_API.init_msg_list(p_init_msg_list);

Line 921: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

917:
918: l_api_version CONSTANT NUMBER := 1;
919: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
920: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
921: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
922: i NUMBER := 0;
923: BEGIN
924: OKC_API.init_msg_list(p_init_msg_list);
925: -- Make sure PL/SQL table has records in it before passing

Line 924: OKC_API.init_msg_list(p_init_msg_list);

920: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
921: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
922: i NUMBER := 0;
923: BEGIN
924: OKC_API.init_msg_list(p_init_msg_list);
925: -- Make sure PL/SQL table has records in it before passing
926: IF (p_acyv_tbl.COUNT > 0) THEN
927: i := p_acyv_tbl.FIRST;
928: LOOP

Line 931: p_init_msg_list => OKC_API.G_FALSE,

927: i := p_acyv_tbl.FIRST;
928: LOOP
929: insert_row (
930: p_api_version => p_api_version,
931: p_init_msg_list => OKC_API.G_FALSE,
932: x_return_status => x_return_status,
933: x_msg_count => x_msg_count,
934: x_msg_data => x_msg_data,
935: p_acyv_rec => p_acyv_tbl(i),

Line 939: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

935: p_acyv_rec => p_acyv_tbl(i),
936: x_acyv_rec => x_acyv_tbl(i));
937:
938: -- store the highest degree of error
939: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
940: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
941: l_overall_status := x_return_status;
942: End If;
943: End If;

Line 940: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

936: x_acyv_rec => x_acyv_tbl(i));
937:
938: -- store the highest degree of error
939: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
940: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
941: l_overall_status := x_return_status;
942: End If;
943: End If;
944:

Line 952: WHEN OKC_API.G_EXCEPTION_ERROR THEN

948: -- return overall status
949: x_return_status := l_overall_status;
950: END IF;
951: EXCEPTION
952: WHEN OKC_API.G_EXCEPTION_ERROR THEN
953: x_return_status := OKC_API.HANDLE_EXCEPTIONS
954: (
955: l_api_name,
956: G_PKG_NAME,

Line 953: x_return_status := OKC_API.HANDLE_EXCEPTIONS

949: x_return_status := l_overall_status;
950: END IF;
951: EXCEPTION
952: WHEN OKC_API.G_EXCEPTION_ERROR THEN
953: x_return_status := OKC_API.HANDLE_EXCEPTIONS
954: (
955: l_api_name,
956: G_PKG_NAME,
957: 'OKC_API.G_RET_STS_ERROR',

Line 957: 'OKC_API.G_RET_STS_ERROR',

953: x_return_status := OKC_API.HANDLE_EXCEPTIONS
954: (
955: l_api_name,
956: G_PKG_NAME,
957: 'OKC_API.G_RET_STS_ERROR',
958: x_msg_count,
959: x_msg_data,
960: '_PVT'
961: );

Line 962: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

958: x_msg_count,
959: x_msg_data,
960: '_PVT'
961: );
962: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
963: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
964: (
965: l_api_name,
966: G_PKG_NAME,

Line 963: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

959: x_msg_data,
960: '_PVT'
961: );
962: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
963: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
964: (
965: l_api_name,
966: G_PKG_NAME,
967: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 967: 'OKC_API.G_RET_STS_UNEXP_ERROR',

963: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
964: (
965: l_api_name,
966: G_PKG_NAME,
967: 'OKC_API.G_RET_STS_UNEXP_ERROR',
968: x_msg_count,
969: x_msg_data,
970: '_PVT'
971: );

Line 973: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

969: x_msg_data,
970: '_PVT'
971: );
972: WHEN OTHERS THEN
973: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
974: (
975: l_api_name,
976: G_PKG_NAME,
977: 'OTHERS',

Line 1014: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1010: WHERE CLE_ID = p_acy_rec.cle_id
1011: AND CLE_ID_ASCENDANT = p_acy_rec.cle_id_ascendant;
1012: l_api_version CONSTANT NUMBER := 1;
1013: l_api_name CONSTANT VARCHAR2(30) := 'ANCESTRYS_lock_row';
1014: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1015: l_object_version_number OKC_ANCESTRYS.OBJECT_VERSION_NUMBER%TYPE;
1016: lc_object_version_number OKC_ANCESTRYS.OBJECT_VERSION_NUMBER%TYPE;
1017: l_row_notfound BOOLEAN := FALSE;
1018: lc_row_notfound BOOLEAN := FALSE;

Line 1020: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1016: lc_object_version_number OKC_ANCESTRYS.OBJECT_VERSION_NUMBER%TYPE;
1017: l_row_notfound BOOLEAN := FALSE;
1018: lc_row_notfound BOOLEAN := FALSE;
1019: BEGIN
1020: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1021: p_init_msg_list,
1022: '_PVT',
1023: x_return_status);
1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1020: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1021: p_init_msg_list,
1022: '_PVT',
1023: x_return_status);
1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_ERROR;
1028: END IF;

Line 1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1021: p_init_msg_list,
1022: '_PVT',
1023: x_return_status);
1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_ERROR;
1028: END IF;
1029: BEGIN

Line 1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1022: '_PVT',
1023: x_return_status);
1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_ERROR;
1028: END IF;
1029: BEGIN
1030: OPEN lock_csr(p_acy_rec);

Line 1027: RAISE OKC_API.G_EXCEPTION_ERROR;

1023: x_return_status);
1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_ERROR;
1028: END IF;
1029: BEGIN
1030: OPEN lock_csr(p_acy_rec);
1031: FETCH lock_csr INTO l_object_version_number;

Line 1039: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1035: WHEN E_Resource_Busy THEN
1036: IF (lock_csr%ISOPEN) THEN
1037: CLOSE lock_csr;
1038: END IF;
1039: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1040: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1041: END;
1042:
1043: IF ( l_row_notfound ) THEN

Line 1050: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1046: lc_row_notfound := lchk_csr%NOTFOUND;
1047: CLOSE lchk_csr;
1048: END IF;
1049: IF (lc_row_notfound) THEN
1050: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1051: RAISE OKC_API.G_EXCEPTION_ERROR;
1052: ELSIF lc_object_version_number > p_acy_rec.object_version_number THEN
1053: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1054: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1051: RAISE OKC_API.G_EXCEPTION_ERROR;

1047: CLOSE lchk_csr;
1048: END IF;
1049: IF (lc_row_notfound) THEN
1050: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1051: RAISE OKC_API.G_EXCEPTION_ERROR;
1052: ELSIF lc_object_version_number > p_acy_rec.object_version_number THEN
1053: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1054: RAISE OKC_API.G_EXCEPTION_ERROR;
1055: ELSIF lc_object_version_number <> p_acy_rec.object_version_number THEN

Line 1053: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1049: IF (lc_row_notfound) THEN
1050: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1051: RAISE OKC_API.G_EXCEPTION_ERROR;
1052: ELSIF lc_object_version_number > p_acy_rec.object_version_number THEN
1053: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1054: RAISE OKC_API.G_EXCEPTION_ERROR;
1055: ELSIF lc_object_version_number <> p_acy_rec.object_version_number THEN
1056: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1057: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1054: RAISE OKC_API.G_EXCEPTION_ERROR;

1050: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1051: RAISE OKC_API.G_EXCEPTION_ERROR;
1052: ELSIF lc_object_version_number > p_acy_rec.object_version_number THEN
1053: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1054: RAISE OKC_API.G_EXCEPTION_ERROR;
1055: ELSIF lc_object_version_number <> p_acy_rec.object_version_number THEN
1056: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1057: RAISE OKC_API.G_EXCEPTION_ERROR;
1058: ELSIF lc_object_version_number = -1 THEN

Line 1056: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1052: ELSIF lc_object_version_number > p_acy_rec.object_version_number THEN
1053: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1054: RAISE OKC_API.G_EXCEPTION_ERROR;
1055: ELSIF lc_object_version_number <> p_acy_rec.object_version_number THEN
1056: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1057: RAISE OKC_API.G_EXCEPTION_ERROR;
1058: ELSIF lc_object_version_number = -1 THEN
1059: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1060: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1057: RAISE OKC_API.G_EXCEPTION_ERROR;

1053: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1054: RAISE OKC_API.G_EXCEPTION_ERROR;
1055: ELSIF lc_object_version_number <> p_acy_rec.object_version_number THEN
1056: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1057: RAISE OKC_API.G_EXCEPTION_ERROR;
1058: ELSIF lc_object_version_number = -1 THEN
1059: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1060: RAISE OKC_API.G_EXCEPTION_ERROR;
1061: END IF;

Line 1059: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1055: ELSIF lc_object_version_number <> p_acy_rec.object_version_number THEN
1056: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1057: RAISE OKC_API.G_EXCEPTION_ERROR;
1058: ELSIF lc_object_version_number = -1 THEN
1059: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1060: RAISE OKC_API.G_EXCEPTION_ERROR;
1061: END IF;
1062: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1063: EXCEPTION

Line 1060: RAISE OKC_API.G_EXCEPTION_ERROR;

1056: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1057: RAISE OKC_API.G_EXCEPTION_ERROR;
1058: ELSIF lc_object_version_number = -1 THEN
1059: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1060: RAISE OKC_API.G_EXCEPTION_ERROR;
1061: END IF;
1062: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1063: EXCEPTION
1064: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1062: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1058: ELSIF lc_object_version_number = -1 THEN
1059: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1060: RAISE OKC_API.G_EXCEPTION_ERROR;
1061: END IF;
1062: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1063: EXCEPTION
1064: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1065: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1066: (

Line 1064: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1060: RAISE OKC_API.G_EXCEPTION_ERROR;
1061: END IF;
1062: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1063: EXCEPTION
1064: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1065: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1066: (
1067: l_api_name,
1068: G_PKG_NAME,

Line 1065: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1061: END IF;
1062: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1063: EXCEPTION
1064: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1065: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1066: (
1067: l_api_name,
1068: G_PKG_NAME,
1069: 'OKC_API.G_RET_STS_ERROR',

Line 1069: 'OKC_API.G_RET_STS_ERROR',

1065: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1066: (
1067: l_api_name,
1068: G_PKG_NAME,
1069: 'OKC_API.G_RET_STS_ERROR',
1070: x_msg_count,
1071: x_msg_data,
1072: '_PVT'
1073: );

Line 1074: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1070: x_msg_count,
1071: x_msg_data,
1072: '_PVT'
1073: );
1074: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1075: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1076: (
1077: l_api_name,
1078: G_PKG_NAME,

Line 1075: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1071: x_msg_data,
1072: '_PVT'
1073: );
1074: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1075: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1076: (
1077: l_api_name,
1078: G_PKG_NAME,
1079: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1079: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1075: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1076: (
1077: l_api_name,
1078: G_PKG_NAME,
1079: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1080: x_msg_count,
1081: x_msg_data,
1082: '_PVT'
1083: );

Line 1085: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1081: x_msg_data,
1082: '_PVT'
1083: );
1084: WHEN OTHERS THEN
1085: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1086: (
1087: l_api_name,
1088: G_PKG_NAME,
1089: 'OTHERS',

Line 1108: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1104: p_acyv_rec IN acyv_rec_type) IS
1105:
1106: l_api_version CONSTANT NUMBER := 1;
1107: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1108: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1109: l_acy_rec acy_rec_type;
1110: BEGIN
1111: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1112: G_PKG_NAME,

Line 1111: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1107: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1108: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1109: l_acy_rec acy_rec_type;
1110: BEGIN
1111: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1112: G_PKG_NAME,
1113: p_init_msg_list,
1114: l_api_version,
1115: p_api_version,

Line 1118: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1114: l_api_version,
1115: p_api_version,
1116: '_PVT',
1117: x_return_status);
1118: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1119: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1120: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_ERROR;
1122: END IF;

Line 1119: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1115: p_api_version,
1116: '_PVT',
1117: x_return_status);
1118: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1119: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1120: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_ERROR;
1122: END IF;
1123: --------------------------------------

Line 1120: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1116: '_PVT',
1117: x_return_status);
1118: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1119: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1120: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_ERROR;
1122: END IF;
1123: --------------------------------------
1124: -- Move VIEW record to "Child" records

Line 1121: RAISE OKC_API.G_EXCEPTION_ERROR;

1117: x_return_status);
1118: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1119: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1120: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_ERROR;
1122: END IF;
1123: --------------------------------------
1124: -- Move VIEW record to "Child" records
1125: --------------------------------------

Line 1137: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1133: x_msg_count,
1134: x_msg_data,
1135: l_acy_rec
1136: );
1137: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1138: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1139: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1140: RAISE OKC_API.G_EXCEPTION_ERROR;
1141: END IF;

Line 1138: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1134: x_msg_data,
1135: l_acy_rec
1136: );
1137: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1138: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1139: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1140: RAISE OKC_API.G_EXCEPTION_ERROR;
1141: END IF;
1142: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1139: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1135: l_acy_rec
1136: );
1137: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1138: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1139: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1140: RAISE OKC_API.G_EXCEPTION_ERROR;
1141: END IF;
1142: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1143: EXCEPTION

Line 1140: RAISE OKC_API.G_EXCEPTION_ERROR;

1136: );
1137: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1138: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1139: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1140: RAISE OKC_API.G_EXCEPTION_ERROR;
1141: END IF;
1142: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1143: EXCEPTION
1144: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1142: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1138: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1139: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1140: RAISE OKC_API.G_EXCEPTION_ERROR;
1141: END IF;
1142: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1143: EXCEPTION
1144: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1145: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1146: (

Line 1144: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1140: RAISE OKC_API.G_EXCEPTION_ERROR;
1141: END IF;
1142: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1143: EXCEPTION
1144: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1145: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1146: (
1147: l_api_name,
1148: G_PKG_NAME,

Line 1145: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1141: END IF;
1142: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1143: EXCEPTION
1144: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1145: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1146: (
1147: l_api_name,
1148: G_PKG_NAME,
1149: 'OKC_API.G_RET_STS_ERROR',

Line 1149: 'OKC_API.G_RET_STS_ERROR',

1145: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1146: (
1147: l_api_name,
1148: G_PKG_NAME,
1149: 'OKC_API.G_RET_STS_ERROR',
1150: x_msg_count,
1151: x_msg_data,
1152: '_PVT'
1153: );

Line 1154: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1150: x_msg_count,
1151: x_msg_data,
1152: '_PVT'
1153: );
1154: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1155: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1156: (
1157: l_api_name,
1158: G_PKG_NAME,

Line 1155: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 1159: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1155: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1156: (
1157: l_api_name,
1158: G_PKG_NAME,
1159: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1160: x_msg_count,
1161: x_msg_data,
1162: '_PVT'
1163: );

Line 1165: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1161: x_msg_data,
1162: '_PVT'
1163: );
1164: WHEN OTHERS THEN
1165: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1166: (
1167: l_api_name,
1168: G_PKG_NAME,
1169: 'OTHERS',

Line 1188: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1184: p_acyv_tbl IN acyv_tbl_type) IS
1185:
1186: l_api_version CONSTANT NUMBER := 1;
1187: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1188: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1189: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1190: i NUMBER := 0;
1191: BEGIN
1192: OKC_API.init_msg_list(p_init_msg_list);

Line 1189: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1185:
1186: l_api_version CONSTANT NUMBER := 1;
1187: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1188: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1189: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1190: i NUMBER := 0;
1191: BEGIN
1192: OKC_API.init_msg_list(p_init_msg_list);
1193: -- Make sure PL/SQL table has records in it before passing

Line 1192: OKC_API.init_msg_list(p_init_msg_list);

1188: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1189: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1190: i NUMBER := 0;
1191: BEGIN
1192: OKC_API.init_msg_list(p_init_msg_list);
1193: -- Make sure PL/SQL table has records in it before passing
1194: IF (p_acyv_tbl.COUNT > 0) THEN
1195: i := p_acyv_tbl.FIRST;
1196: LOOP

Line 1199: p_init_msg_list => OKC_API.G_FALSE,

1195: i := p_acyv_tbl.FIRST;
1196: LOOP
1197: lock_row (
1198: p_api_version => p_api_version,
1199: p_init_msg_list => OKC_API.G_FALSE,
1200: x_return_status => x_return_status,
1201: x_msg_count => x_msg_count,
1202: x_msg_data => x_msg_data,
1203: p_acyv_rec => p_acyv_tbl(i));

Line 1206: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

1202: x_msg_data => x_msg_data,
1203: p_acyv_rec => p_acyv_tbl(i));
1204:
1205: -- store the highest degree of error
1206: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
1207: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
1208: l_overall_status := x_return_status;
1209: End If;
1210: End If;

Line 1207: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

1203: p_acyv_rec => p_acyv_tbl(i));
1204:
1205: -- store the highest degree of error
1206: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
1207: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
1208: l_overall_status := x_return_status;
1209: End If;
1210: End If;
1211:

Line 1219: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1215: -- return overall status
1216: x_return_status := l_overall_status;
1217: END IF;
1218: EXCEPTION
1219: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1220: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1221: (
1222: l_api_name,
1223: G_PKG_NAME,

Line 1220: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1216: x_return_status := l_overall_status;
1217: END IF;
1218: EXCEPTION
1219: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1220: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1221: (
1222: l_api_name,
1223: G_PKG_NAME,
1224: 'OKC_API.G_RET_STS_ERROR',

Line 1224: 'OKC_API.G_RET_STS_ERROR',

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

Line 1229: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1230: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 1234: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1240: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 1267: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1263: x_acy_rec OUT NOCOPY acy_rec_type) IS
1264:
1265: l_api_version CONSTANT NUMBER := 1;
1266: l_api_name CONSTANT VARCHAR2(30) := 'ANCESTRYS_update_row';
1267: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1268: l_acy_rec acy_rec_type := p_acy_rec;
1269: l_def_acy_rec acy_rec_type;
1270: l_row_notfound BOOLEAN := TRUE;
1271: ----------------------------------

Line 1280: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1276: x_acy_rec OUT NOCOPY acy_rec_type
1277: ) RETURN VARCHAR2 IS
1278: l_acy_rec acy_rec_type;
1279: l_row_notfound BOOLEAN := TRUE;
1280: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1281: BEGIN
1282: x_acy_rec := p_acy_rec;
1283: -- Get current database values
1284: l_acy_rec := get_rec(p_acy_rec, l_row_notfound);

Line 1286: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1282: x_acy_rec := p_acy_rec;
1283: -- Get current database values
1284: l_acy_rec := get_rec(p_acy_rec, l_row_notfound);
1285: IF (l_row_notfound) THEN
1286: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1287: END IF;
1288: IF (x_acy_rec.cle_id = OKC_API.G_MISS_NUM)
1289: THEN
1290: x_acy_rec.cle_id := l_acy_rec.cle_id;

Line 1288: IF (x_acy_rec.cle_id = OKC_API.G_MISS_NUM)

1284: l_acy_rec := get_rec(p_acy_rec, l_row_notfound);
1285: IF (l_row_notfound) THEN
1286: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1287: END IF;
1288: IF (x_acy_rec.cle_id = OKC_API.G_MISS_NUM)
1289: THEN
1290: x_acy_rec.cle_id := l_acy_rec.cle_id;
1291: END IF;
1292: IF (x_acy_rec.cle_id_ascendant = OKC_API.G_MISS_NUM)

Line 1292: IF (x_acy_rec.cle_id_ascendant = OKC_API.G_MISS_NUM)

1288: IF (x_acy_rec.cle_id = OKC_API.G_MISS_NUM)
1289: THEN
1290: x_acy_rec.cle_id := l_acy_rec.cle_id;
1291: END IF;
1292: IF (x_acy_rec.cle_id_ascendant = OKC_API.G_MISS_NUM)
1293: THEN
1294: x_acy_rec.cle_id_ascendant := l_acy_rec.cle_id_ascendant;
1295: END IF;
1296: IF (x_acy_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1296: IF (x_acy_rec.object_version_number = OKC_API.G_MISS_NUM)

1292: IF (x_acy_rec.cle_id_ascendant = OKC_API.G_MISS_NUM)
1293: THEN
1294: x_acy_rec.cle_id_ascendant := l_acy_rec.cle_id_ascendant;
1295: END IF;
1296: IF (x_acy_rec.object_version_number = OKC_API.G_MISS_NUM)
1297: THEN
1298: x_acy_rec.object_version_number := l_acy_rec.object_version_number;
1299: END IF;
1300: IF (x_acy_rec.level_sequence = OKC_API.G_MISS_NUM)

Line 1300: IF (x_acy_rec.level_sequence = OKC_API.G_MISS_NUM)

1296: IF (x_acy_rec.object_version_number = OKC_API.G_MISS_NUM)
1297: THEN
1298: x_acy_rec.object_version_number := l_acy_rec.object_version_number;
1299: END IF;
1300: IF (x_acy_rec.level_sequence = OKC_API.G_MISS_NUM)
1301: THEN
1302: x_acy_rec.level_sequence := l_acy_rec.level_sequence;
1303: END IF;
1304: IF (x_acy_rec.created_by = OKC_API.G_MISS_NUM)

Line 1304: IF (x_acy_rec.created_by = OKC_API.G_MISS_NUM)

1300: IF (x_acy_rec.level_sequence = OKC_API.G_MISS_NUM)
1301: THEN
1302: x_acy_rec.level_sequence := l_acy_rec.level_sequence;
1303: END IF;
1304: IF (x_acy_rec.created_by = OKC_API.G_MISS_NUM)
1305: THEN
1306: x_acy_rec.created_by := l_acy_rec.created_by;
1307: END IF;
1308: IF (x_acy_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1308: IF (x_acy_rec.creation_date = OKC_API.G_MISS_DATE)

1304: IF (x_acy_rec.created_by = OKC_API.G_MISS_NUM)
1305: THEN
1306: x_acy_rec.created_by := l_acy_rec.created_by;
1307: END IF;
1308: IF (x_acy_rec.creation_date = OKC_API.G_MISS_DATE)
1309: THEN
1310: x_acy_rec.creation_date := l_acy_rec.creation_date;
1311: END IF;
1312: IF (x_acy_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1312: IF (x_acy_rec.last_updated_by = OKC_API.G_MISS_NUM)

1308: IF (x_acy_rec.creation_date = OKC_API.G_MISS_DATE)
1309: THEN
1310: x_acy_rec.creation_date := l_acy_rec.creation_date;
1311: END IF;
1312: IF (x_acy_rec.last_updated_by = OKC_API.G_MISS_NUM)
1313: THEN
1314: x_acy_rec.last_updated_by := l_acy_rec.last_updated_by;
1315: END IF;
1316: IF (x_acy_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1316: IF (x_acy_rec.last_update_date = OKC_API.G_MISS_DATE)

1312: IF (x_acy_rec.last_updated_by = OKC_API.G_MISS_NUM)
1313: THEN
1314: x_acy_rec.last_updated_by := l_acy_rec.last_updated_by;
1315: END IF;
1316: IF (x_acy_rec.last_update_date = OKC_API.G_MISS_DATE)
1317: THEN
1318: x_acy_rec.last_update_date := l_acy_rec.last_update_date;
1319: END IF;
1320: IF (x_acy_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1320: IF (x_acy_rec.last_update_login = OKC_API.G_MISS_NUM)

1316: IF (x_acy_rec.last_update_date = OKC_API.G_MISS_DATE)
1317: THEN
1318: x_acy_rec.last_update_date := l_acy_rec.last_update_date;
1319: END IF;
1320: IF (x_acy_rec.last_update_login = OKC_API.G_MISS_NUM)
1321: THEN
1322: x_acy_rec.last_update_login := l_acy_rec.last_update_login;
1323: END IF;
1324: RETURN(l_return_status);

Line 1333: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1329: FUNCTION Set_Attributes (
1330: p_acy_rec IN acy_rec_type,
1331: x_acy_rec OUT NOCOPY acy_rec_type
1332: ) RETURN VARCHAR2 IS
1333: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1334: BEGIN
1335: x_acy_rec := p_acy_rec;
1336: RETURN(l_return_status);
1337: END Set_Attributes;

Line 1339: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1335: x_acy_rec := p_acy_rec;
1336: RETURN(l_return_status);
1337: END Set_Attributes;
1338: BEGIN
1339: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1340: p_init_msg_list,
1341: '_PVT',
1342: x_return_status);
1343: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1343: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1339: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1340: p_init_msg_list,
1341: '_PVT',
1342: x_return_status);
1343: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1345: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1346: RAISE OKC_API.G_EXCEPTION_ERROR;
1347: END IF;

Line 1344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1340: p_init_msg_list,
1341: '_PVT',
1342: x_return_status);
1343: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1345: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1346: RAISE OKC_API.G_EXCEPTION_ERROR;
1347: END IF;
1348: --- Setting item attributes

Line 1345: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1341: '_PVT',
1342: x_return_status);
1343: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1345: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1346: RAISE OKC_API.G_EXCEPTION_ERROR;
1347: END IF;
1348: --- Setting item attributes
1349: l_return_status := Set_Attributes(

Line 1346: RAISE OKC_API.G_EXCEPTION_ERROR;

1342: x_return_status);
1343: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1345: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1346: RAISE OKC_API.G_EXCEPTION_ERROR;
1347: END IF;
1348: --- Setting item attributes
1349: l_return_status := Set_Attributes(
1350: p_acy_rec, -- IN

Line 1353: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1349: l_return_status := Set_Attributes(
1350: p_acy_rec, -- IN
1351: l_acy_rec); -- OUT
1352: --- If any errors happen abort API
1353: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1355: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1356: RAISE OKC_API.G_EXCEPTION_ERROR;
1357: END IF;

Line 1354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1350: p_acy_rec, -- IN
1351: l_acy_rec); -- OUT
1352: --- If any errors happen abort API
1353: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1355: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1356: RAISE OKC_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: l_return_status := populate_new_record(l_acy_rec, l_def_acy_rec);

Line 1355: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1351: l_acy_rec); -- OUT
1352: --- If any errors happen abort API
1353: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1355: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1356: RAISE OKC_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: l_return_status := populate_new_record(l_acy_rec, l_def_acy_rec);
1359: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1356: RAISE OKC_API.G_EXCEPTION_ERROR;

1352: --- If any errors happen abort API
1353: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1355: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1356: RAISE OKC_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: l_return_status := populate_new_record(l_acy_rec, l_def_acy_rec);
1359: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1359: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1355: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1356: RAISE OKC_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: l_return_status := populate_new_record(l_acy_rec, l_def_acy_rec);
1359: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1361: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1362: RAISE OKC_API.G_EXCEPTION_ERROR;
1363: END IF;

Line 1360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1356: RAISE OKC_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: l_return_status := populate_new_record(l_acy_rec, l_def_acy_rec);
1359: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1361: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1362: RAISE OKC_API.G_EXCEPTION_ERROR;
1363: END IF;
1364: UPDATE OKC_ANCESTRYS

Line 1361: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1357: END IF;
1358: l_return_status := populate_new_record(l_acy_rec, l_def_acy_rec);
1359: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1361: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1362: RAISE OKC_API.G_EXCEPTION_ERROR;
1363: END IF;
1364: UPDATE OKC_ANCESTRYS
1365: SET OBJECT_VERSION_NUMBER = l_def_acy_rec.object_version_number,

Line 1362: RAISE OKC_API.G_EXCEPTION_ERROR;

1358: l_return_status := populate_new_record(l_acy_rec, l_def_acy_rec);
1359: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1361: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1362: RAISE OKC_API.G_EXCEPTION_ERROR;
1363: END IF;
1364: UPDATE OKC_ANCESTRYS
1365: SET OBJECT_VERSION_NUMBER = l_def_acy_rec.object_version_number,
1366: LEVEL_SEQUENCE = l_def_acy_rec.level_sequence,

Line 1376: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1372: WHERE CLE_ID = l_def_acy_rec.cle_id
1373: AND CLE_ID_ASCENDANT = l_def_acy_rec.cle_id_ascendant;
1374:
1375: x_acy_rec := l_def_acy_rec;
1376: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1377: EXCEPTION
1378: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1379: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1380: (

Line 1378: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1374:
1375: x_acy_rec := l_def_acy_rec;
1376: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1377: EXCEPTION
1378: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1379: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1380: (
1381: l_api_name,
1382: G_PKG_NAME,

Line 1379: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1375: x_acy_rec := l_def_acy_rec;
1376: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1377: EXCEPTION
1378: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1379: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1380: (
1381: l_api_name,
1382: G_PKG_NAME,
1383: 'OKC_API.G_RET_STS_ERROR',

Line 1383: 'OKC_API.G_RET_STS_ERROR',

1379: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1380: (
1381: l_api_name,
1382: G_PKG_NAME,
1383: 'OKC_API.G_RET_STS_ERROR',
1384: x_msg_count,
1385: x_msg_data,
1386: '_PVT'
1387: );

Line 1388: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1384: x_msg_count,
1385: x_msg_data,
1386: '_PVT'
1387: );
1388: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1389: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1390: (
1391: l_api_name,
1392: G_PKG_NAME,

Line 1389: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1385: x_msg_data,
1386: '_PVT'
1387: );
1388: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1389: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1390: (
1391: l_api_name,
1392: G_PKG_NAME,
1393: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1393: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1389: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1390: (
1391: l_api_name,
1392: G_PKG_NAME,
1393: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1394: x_msg_count,
1395: x_msg_data,
1396: '_PVT'
1397: );

Line 1399: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1395: x_msg_data,
1396: '_PVT'
1397: );
1398: WHEN OTHERS THEN
1399: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1400: (
1401: l_api_name,
1402: G_PKG_NAME,
1403: 'OTHERS',

Line 1423: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1419: x_acyv_rec OUT NOCOPY acyv_rec_type) IS
1420:
1421: l_api_version CONSTANT NUMBER := 1;
1422: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1423: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1424: l_acyv_rec acyv_rec_type := p_acyv_rec;
1425: l_def_acyv_rec acyv_rec_type;
1426: l_acy_rec acy_rec_type;
1427: lx_acy_rec acy_rec_type;

Line 1450: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1446: x_acyv_rec OUT NOCOPY acyv_rec_type
1447: ) RETURN VARCHAR2 IS
1448: l_acyv_rec acyv_rec_type;
1449: l_row_notfound BOOLEAN := TRUE;
1450: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1451: BEGIN
1452: x_acyv_rec := p_acyv_rec;
1453: -- Get current database values
1454: l_acyv_rec := get_rec(p_acyv_rec, l_row_notfound);

Line 1456: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1452: x_acyv_rec := p_acyv_rec;
1453: -- Get current database values
1454: l_acyv_rec := get_rec(p_acyv_rec, l_row_notfound);
1455: IF (l_row_notfound) THEN
1456: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1457: END IF;
1458: IF (x_acyv_rec.cle_id = OKC_API.G_MISS_NUM)
1459: THEN
1460: x_acyv_rec.cle_id := l_acyv_rec.cle_id;

Line 1458: IF (x_acyv_rec.cle_id = OKC_API.G_MISS_NUM)

1454: l_acyv_rec := get_rec(p_acyv_rec, l_row_notfound);
1455: IF (l_row_notfound) THEN
1456: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1457: END IF;
1458: IF (x_acyv_rec.cle_id = OKC_API.G_MISS_NUM)
1459: THEN
1460: x_acyv_rec.cle_id := l_acyv_rec.cle_id;
1461: END IF;
1462: IF (x_acyv_rec.cle_id_ascendant = OKC_API.G_MISS_NUM)

Line 1462: IF (x_acyv_rec.cle_id_ascendant = OKC_API.G_MISS_NUM)

1458: IF (x_acyv_rec.cle_id = OKC_API.G_MISS_NUM)
1459: THEN
1460: x_acyv_rec.cle_id := l_acyv_rec.cle_id;
1461: END IF;
1462: IF (x_acyv_rec.cle_id_ascendant = OKC_API.G_MISS_NUM)
1463: THEN
1464: x_acyv_rec.cle_id_ascendant := l_acyv_rec.cle_id_ascendant;
1465: END IF;
1466: IF (x_acyv_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1466: IF (x_acyv_rec.object_version_number = OKC_API.G_MISS_NUM)

1462: IF (x_acyv_rec.cle_id_ascendant = OKC_API.G_MISS_NUM)
1463: THEN
1464: x_acyv_rec.cle_id_ascendant := l_acyv_rec.cle_id_ascendant;
1465: END IF;
1466: IF (x_acyv_rec.object_version_number = OKC_API.G_MISS_NUM)
1467: THEN
1468: x_acyv_rec.object_version_number := l_acyv_rec.object_version_number;
1469: END IF;
1470: IF (x_acyv_rec.level_sequence = OKC_API.G_MISS_NUM)

Line 1470: IF (x_acyv_rec.level_sequence = OKC_API.G_MISS_NUM)

1466: IF (x_acyv_rec.object_version_number = OKC_API.G_MISS_NUM)
1467: THEN
1468: x_acyv_rec.object_version_number := l_acyv_rec.object_version_number;
1469: END IF;
1470: IF (x_acyv_rec.level_sequence = OKC_API.G_MISS_NUM)
1471: THEN
1472: x_acyv_rec.level_sequence := l_acyv_rec.level_sequence;
1473: END IF;
1474: IF (x_acyv_rec.created_by = OKC_API.G_MISS_NUM)

Line 1474: IF (x_acyv_rec.created_by = OKC_API.G_MISS_NUM)

1470: IF (x_acyv_rec.level_sequence = OKC_API.G_MISS_NUM)
1471: THEN
1472: x_acyv_rec.level_sequence := l_acyv_rec.level_sequence;
1473: END IF;
1474: IF (x_acyv_rec.created_by = OKC_API.G_MISS_NUM)
1475: THEN
1476: x_acyv_rec.created_by := l_acyv_rec.created_by;
1477: END IF;
1478: IF (x_acyv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1478: IF (x_acyv_rec.creation_date = OKC_API.G_MISS_DATE)

1474: IF (x_acyv_rec.created_by = OKC_API.G_MISS_NUM)
1475: THEN
1476: x_acyv_rec.created_by := l_acyv_rec.created_by;
1477: END IF;
1478: IF (x_acyv_rec.creation_date = OKC_API.G_MISS_DATE)
1479: THEN
1480: x_acyv_rec.creation_date := l_acyv_rec.creation_date;
1481: END IF;
1482: IF (x_acyv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1482: IF (x_acyv_rec.last_updated_by = OKC_API.G_MISS_NUM)

1478: IF (x_acyv_rec.creation_date = OKC_API.G_MISS_DATE)
1479: THEN
1480: x_acyv_rec.creation_date := l_acyv_rec.creation_date;
1481: END IF;
1482: IF (x_acyv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1483: THEN
1484: x_acyv_rec.last_updated_by := l_acyv_rec.last_updated_by;
1485: END IF;
1486: IF (x_acyv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1486: IF (x_acyv_rec.last_update_date = OKC_API.G_MISS_DATE)

1482: IF (x_acyv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1483: THEN
1484: x_acyv_rec.last_updated_by := l_acyv_rec.last_updated_by;
1485: END IF;
1486: IF (x_acyv_rec.last_update_date = OKC_API.G_MISS_DATE)
1487: THEN
1488: x_acyv_rec.last_update_date := l_acyv_rec.last_update_date;
1489: END IF;
1490: IF (x_acyv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1490: IF (x_acyv_rec.last_update_login = OKC_API.G_MISS_NUM)

1486: IF (x_acyv_rec.last_update_date = OKC_API.G_MISS_DATE)
1487: THEN
1488: x_acyv_rec.last_update_date := l_acyv_rec.last_update_date;
1489: END IF;
1490: IF (x_acyv_rec.last_update_login = OKC_API.G_MISS_NUM)
1491: THEN
1492: x_acyv_rec.last_update_login := l_acyv_rec.last_update_login;
1493: END IF;
1494: RETURN(l_return_status);

Line 1503: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1499: FUNCTION Set_Attributes (
1500: p_acyv_rec IN acyv_rec_type,
1501: x_acyv_rec OUT NOCOPY acyv_rec_type
1502: ) RETURN VARCHAR2 IS
1503: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1504: BEGIN
1505: x_acyv_rec := p_acyv_rec;
1506: x_acyv_rec.OBJECT_VERSION_NUMBER := NVL(x_acyv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1507: RETURN(l_return_status);

Line 1510: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1506: x_acyv_rec.OBJECT_VERSION_NUMBER := NVL(x_acyv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1507: RETURN(l_return_status);
1508: END Set_Attributes;
1509: BEGIN
1510: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1511: G_PKG_NAME,
1512: p_init_msg_list,
1513: l_api_version,
1514: p_api_version,

Line 1517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1513: l_api_version,
1514: p_api_version,
1515: '_PVT',
1516: x_return_status);
1517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1520: RAISE OKC_API.G_EXCEPTION_ERROR;
1521: END IF;

Line 1518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1514: p_api_version,
1515: '_PVT',
1516: x_return_status);
1517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1520: RAISE OKC_API.G_EXCEPTION_ERROR;
1521: END IF;
1522: --- Setting item attributes

Line 1519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1515: '_PVT',
1516: x_return_status);
1517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1520: RAISE OKC_API.G_EXCEPTION_ERROR;
1521: END IF;
1522: --- Setting item attributes
1523: l_return_status := Set_Attributes(

Line 1520: RAISE OKC_API.G_EXCEPTION_ERROR;

1516: x_return_status);
1517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1520: RAISE OKC_API.G_EXCEPTION_ERROR;
1521: END IF;
1522: --- Setting item attributes
1523: l_return_status := Set_Attributes(
1524: p_acyv_rec, -- IN

Line 1527: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1523: l_return_status := Set_Attributes(
1524: p_acyv_rec, -- IN
1525: l_acyv_rec); -- OUT
1526: --- If any errors happen abort API
1527: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1530: RAISE OKC_API.G_EXCEPTION_ERROR;
1531: END IF;

Line 1528: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1524: p_acyv_rec, -- IN
1525: l_acyv_rec); -- OUT
1526: --- If any errors happen abort API
1527: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1530: RAISE OKC_API.G_EXCEPTION_ERROR;
1531: END IF;
1532: l_return_status := populate_new_record(l_acyv_rec, l_def_acyv_rec);

Line 1529: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1525: l_acyv_rec); -- OUT
1526: --- If any errors happen abort API
1527: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1530: RAISE OKC_API.G_EXCEPTION_ERROR;
1531: END IF;
1532: l_return_status := populate_new_record(l_acyv_rec, l_def_acyv_rec);
1533: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1530: RAISE OKC_API.G_EXCEPTION_ERROR;

1526: --- If any errors happen abort API
1527: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1530: RAISE OKC_API.G_EXCEPTION_ERROR;
1531: END IF;
1532: l_return_status := populate_new_record(l_acyv_rec, l_def_acyv_rec);
1533: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1534: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1533: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1529: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1530: RAISE OKC_API.G_EXCEPTION_ERROR;
1531: END IF;
1532: l_return_status := populate_new_record(l_acyv_rec, l_def_acyv_rec);
1533: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1534: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1535: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1536: RAISE OKC_API.G_EXCEPTION_ERROR;
1537: END IF;

Line 1534: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1530: RAISE OKC_API.G_EXCEPTION_ERROR;
1531: END IF;
1532: l_return_status := populate_new_record(l_acyv_rec, l_def_acyv_rec);
1533: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1534: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1535: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1536: RAISE OKC_API.G_EXCEPTION_ERROR;
1537: END IF;
1538: l_def_acyv_rec := fill_who_columns(l_def_acyv_rec);

Line 1535: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1531: END IF;
1532: l_return_status := populate_new_record(l_acyv_rec, l_def_acyv_rec);
1533: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1534: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1535: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1536: RAISE OKC_API.G_EXCEPTION_ERROR;
1537: END IF;
1538: l_def_acyv_rec := fill_who_columns(l_def_acyv_rec);
1539: --- Validate all non-missing attributes (Item Level Validation)

Line 1536: RAISE OKC_API.G_EXCEPTION_ERROR;

1532: l_return_status := populate_new_record(l_acyv_rec, l_def_acyv_rec);
1533: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1534: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1535: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1536: RAISE OKC_API.G_EXCEPTION_ERROR;
1537: END IF;
1538: l_def_acyv_rec := fill_who_columns(l_def_acyv_rec);
1539: --- Validate all non-missing attributes (Item Level Validation)
1540: l_return_status := Validate_Attributes(l_def_acyv_rec);

Line 1542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1538: l_def_acyv_rec := fill_who_columns(l_def_acyv_rec);
1539: --- Validate all non-missing attributes (Item Level Validation)
1540: l_return_status := Validate_Attributes(l_def_acyv_rec);
1541: --- If any errors happen abort API
1542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1543: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1545: RAISE OKC_API.G_EXCEPTION_ERROR;
1546: END IF;

Line 1543: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1539: --- Validate all non-missing attributes (Item Level Validation)
1540: l_return_status := Validate_Attributes(l_def_acyv_rec);
1541: --- If any errors happen abort API
1542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1543: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1545: RAISE OKC_API.G_EXCEPTION_ERROR;
1546: END IF;
1547: l_return_status := Validate_Record(l_def_acyv_rec);

Line 1544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1540: l_return_status := Validate_Attributes(l_def_acyv_rec);
1541: --- If any errors happen abort API
1542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1543: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1545: RAISE OKC_API.G_EXCEPTION_ERROR;
1546: END IF;
1547: l_return_status := Validate_Record(l_def_acyv_rec);
1548: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1545: RAISE OKC_API.G_EXCEPTION_ERROR;

1541: --- If any errors happen abort API
1542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1543: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1545: RAISE OKC_API.G_EXCEPTION_ERROR;
1546: END IF;
1547: l_return_status := Validate_Record(l_def_acyv_rec);
1548: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1548: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1545: RAISE OKC_API.G_EXCEPTION_ERROR;
1546: END IF;
1547: l_return_status := Validate_Record(l_def_acyv_rec);
1548: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1551: RAISE OKC_API.G_EXCEPTION_ERROR;
1552: END IF;

Line 1549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1545: RAISE OKC_API.G_EXCEPTION_ERROR;
1546: END IF;
1547: l_return_status := Validate_Record(l_def_acyv_rec);
1548: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1551: RAISE OKC_API.G_EXCEPTION_ERROR;
1552: END IF;
1553:

Line 1550: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1546: END IF;
1547: l_return_status := Validate_Record(l_def_acyv_rec);
1548: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1551: RAISE OKC_API.G_EXCEPTION_ERROR;
1552: END IF;
1553:
1554: --------------------------------------

Line 1551: RAISE OKC_API.G_EXCEPTION_ERROR;

1547: l_return_status := Validate_Record(l_def_acyv_rec);
1548: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1551: RAISE OKC_API.G_EXCEPTION_ERROR;
1552: END IF;
1553:
1554: --------------------------------------
1555: -- Move VIEW record to "Child" records

Line 1569: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1565: x_msg_data,
1566: l_acy_rec,
1567: lx_acy_rec
1568: );
1569: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1571: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1572: RAISE OKC_API.G_EXCEPTION_ERROR;
1573: END IF;

Line 1570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1566: l_acy_rec,
1567: lx_acy_rec
1568: );
1569: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1571: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1572: RAISE OKC_API.G_EXCEPTION_ERROR;
1573: END IF;
1574: migrate(lx_acy_rec, l_def_acyv_rec);

Line 1571: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1567: lx_acy_rec
1568: );
1569: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1571: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1572: RAISE OKC_API.G_EXCEPTION_ERROR;
1573: END IF;
1574: migrate(lx_acy_rec, l_def_acyv_rec);
1575: x_acyv_rec := l_def_acyv_rec;

Line 1572: RAISE OKC_API.G_EXCEPTION_ERROR;

1568: );
1569: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1571: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1572: RAISE OKC_API.G_EXCEPTION_ERROR;
1573: END IF;
1574: migrate(lx_acy_rec, l_def_acyv_rec);
1575: x_acyv_rec := l_def_acyv_rec;
1576: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1576: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1572: RAISE OKC_API.G_EXCEPTION_ERROR;
1573: END IF;
1574: migrate(lx_acy_rec, l_def_acyv_rec);
1575: x_acyv_rec := l_def_acyv_rec;
1576: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1577: EXCEPTION
1578: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1579: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1580: (

Line 1578: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1574: migrate(lx_acy_rec, l_def_acyv_rec);
1575: x_acyv_rec := l_def_acyv_rec;
1576: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1577: EXCEPTION
1578: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1579: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1580: (
1581: l_api_name,
1582: G_PKG_NAME,

Line 1579: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1575: x_acyv_rec := l_def_acyv_rec;
1576: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1577: EXCEPTION
1578: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1579: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1580: (
1581: l_api_name,
1582: G_PKG_NAME,
1583: 'OKC_API.G_RET_STS_ERROR',

Line 1583: 'OKC_API.G_RET_STS_ERROR',

1579: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1580: (
1581: l_api_name,
1582: G_PKG_NAME,
1583: 'OKC_API.G_RET_STS_ERROR',
1584: x_msg_count,
1585: x_msg_data,
1586: '_PVT'
1587: );

Line 1588: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1584: x_msg_count,
1585: x_msg_data,
1586: '_PVT'
1587: );
1588: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1589: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1590: (
1591: l_api_name,
1592: G_PKG_NAME,

Line 1589: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1585: x_msg_data,
1586: '_PVT'
1587: );
1588: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1589: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1590: (
1591: l_api_name,
1592: G_PKG_NAME,
1593: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1593: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1589: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1590: (
1591: l_api_name,
1592: G_PKG_NAME,
1593: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1594: x_msg_count,
1595: x_msg_data,
1596: '_PVT'
1597: );

Line 1599: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1595: x_msg_data,
1596: '_PVT'
1597: );
1598: WHEN OTHERS THEN
1599: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1600: (
1601: l_api_name,
1602: G_PKG_NAME,
1603: 'OTHERS',

Line 1623: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1619: x_acyv_tbl OUT NOCOPY acyv_tbl_type) IS
1620:
1621: l_api_version CONSTANT NUMBER := 1;
1622: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1623: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1624: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1625: i NUMBER := 0;
1626: BEGIN
1627: OKC_API.init_msg_list(p_init_msg_list);

Line 1624: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1620:
1621: l_api_version CONSTANT NUMBER := 1;
1622: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1623: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1624: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1625: i NUMBER := 0;
1626: BEGIN
1627: OKC_API.init_msg_list(p_init_msg_list);
1628: -- Make sure PL/SQL table has records in it before passing

Line 1627: OKC_API.init_msg_list(p_init_msg_list);

1623: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1624: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1625: i NUMBER := 0;
1626: BEGIN
1627: OKC_API.init_msg_list(p_init_msg_list);
1628: -- Make sure PL/SQL table has records in it before passing
1629: IF (p_acyv_tbl.COUNT > 0) THEN
1630: i := p_acyv_tbl.FIRST;
1631: LOOP

Line 1634: p_init_msg_list => OKC_API.G_FALSE,

1630: i := p_acyv_tbl.FIRST;
1631: LOOP
1632: update_row (
1633: p_api_version => p_api_version,
1634: p_init_msg_list => OKC_API.G_FALSE,
1635: x_return_status => x_return_status,
1636: x_msg_count => x_msg_count,
1637: x_msg_data => x_msg_data,
1638: p_acyv_rec => p_acyv_tbl(i),

Line 1642: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

1638: p_acyv_rec => p_acyv_tbl(i),
1639: x_acyv_rec => x_acyv_tbl(i));
1640:
1641: -- store the highest degree of error
1642: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
1643: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
1644: l_overall_status := x_return_status;
1645: End If;
1646: End If;

Line 1643: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

1639: x_acyv_rec => x_acyv_tbl(i));
1640:
1641: -- store the highest degree of error
1642: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
1643: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
1644: l_overall_status := x_return_status;
1645: End If;
1646: End If;
1647:

Line 1655: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1651: -- return overall status
1652: x_return_status := l_overall_status;
1653: END IF;
1654: EXCEPTION
1655: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1656: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1657: (
1658: l_api_name,
1659: G_PKG_NAME,

Line 1656: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1652: x_return_status := l_overall_status;
1653: END IF;
1654: EXCEPTION
1655: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1656: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1657: (
1658: l_api_name,
1659: G_PKG_NAME,
1660: 'OKC_API.G_RET_STS_ERROR',

Line 1660: 'OKC_API.G_RET_STS_ERROR',

1656: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1657: (
1658: l_api_name,
1659: G_PKG_NAME,
1660: 'OKC_API.G_RET_STS_ERROR',
1661: x_msg_count,
1662: x_msg_data,
1663: '_PVT'
1664: );

Line 1665: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1661: x_msg_count,
1662: x_msg_data,
1663: '_PVT'
1664: );
1665: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1666: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1667: (
1668: l_api_name,
1669: G_PKG_NAME,

Line 1666: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1662: x_msg_data,
1663: '_PVT'
1664: );
1665: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1666: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1667: (
1668: l_api_name,
1669: G_PKG_NAME,
1670: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1670: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1666: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1667: (
1668: l_api_name,
1669: G_PKG_NAME,
1670: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1671: x_msg_count,
1672: x_msg_data,
1673: '_PVT'
1674: );

Line 1676: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1672: x_msg_data,
1673: '_PVT'
1674: );
1675: WHEN OTHERS THEN
1676: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1677: (
1678: l_api_name,
1679: G_PKG_NAME,
1680: 'OTHERS',

Line 1702: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1698: p_acy_rec IN acy_rec_type) IS
1699:
1700: l_api_version CONSTANT NUMBER := 1;
1701: l_api_name CONSTANT VARCHAR2(30) := 'ANCESTRYS_delete_row';
1702: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1703: l_acy_rec acy_rec_type:= p_acy_rec;
1704: l_row_notfound BOOLEAN := TRUE;
1705: BEGIN
1706: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1706: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1702: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1703: l_acy_rec acy_rec_type:= p_acy_rec;
1704: l_row_notfound BOOLEAN := TRUE;
1705: BEGIN
1706: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1707: p_init_msg_list,
1708: '_PVT',
1709: x_return_status);
1710: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1710: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1706: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1707: p_init_msg_list,
1708: '_PVT',
1709: x_return_status);
1710: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1712: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1713: RAISE OKC_API.G_EXCEPTION_ERROR;
1714: END IF;

Line 1711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1707: p_init_msg_list,
1708: '_PVT',
1709: x_return_status);
1710: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1712: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1713: RAISE OKC_API.G_EXCEPTION_ERROR;
1714: END IF;
1715: DELETE FROM OKC_ANCESTRYS

Line 1712: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1708: '_PVT',
1709: x_return_status);
1710: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1712: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1713: RAISE OKC_API.G_EXCEPTION_ERROR;
1714: END IF;
1715: DELETE FROM OKC_ANCESTRYS
1716: WHERE CLE_ID = l_acy_rec.cle_id AND

Line 1713: RAISE OKC_API.G_EXCEPTION_ERROR;

1709: x_return_status);
1710: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1712: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1713: RAISE OKC_API.G_EXCEPTION_ERROR;
1714: END IF;
1715: DELETE FROM OKC_ANCESTRYS
1716: WHERE CLE_ID = l_acy_rec.cle_id AND
1717: CLE_ID_ASCENDANT = l_acy_rec.cle_id_ascendant;

Line 1719: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1715: DELETE FROM OKC_ANCESTRYS
1716: WHERE CLE_ID = l_acy_rec.cle_id AND
1717: CLE_ID_ASCENDANT = l_acy_rec.cle_id_ascendant;
1718:
1719: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1720: EXCEPTION
1721: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1722: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1723: (

Line 1721: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1717: CLE_ID_ASCENDANT = l_acy_rec.cle_id_ascendant;
1718:
1719: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1720: EXCEPTION
1721: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1722: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1723: (
1724: l_api_name,
1725: G_PKG_NAME,

Line 1722: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1718:
1719: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1720: EXCEPTION
1721: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1722: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1723: (
1724: l_api_name,
1725: G_PKG_NAME,
1726: 'OKC_API.G_RET_STS_ERROR',

Line 1726: 'OKC_API.G_RET_STS_ERROR',

1722: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1723: (
1724: l_api_name,
1725: G_PKG_NAME,
1726: 'OKC_API.G_RET_STS_ERROR',
1727: x_msg_count,
1728: x_msg_data,
1729: '_PVT'
1730: );

Line 1731: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1727: x_msg_count,
1728: x_msg_data,
1729: '_PVT'
1730: );
1731: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1732: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1733: (
1734: l_api_name,
1735: G_PKG_NAME,

Line 1732: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1728: x_msg_data,
1729: '_PVT'
1730: );
1731: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1732: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1733: (
1734: l_api_name,
1735: G_PKG_NAME,
1736: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1736: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1732: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1733: (
1734: l_api_name,
1735: G_PKG_NAME,
1736: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1737: x_msg_count,
1738: x_msg_data,
1739: '_PVT'
1740: );

Line 1742: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1738: x_msg_data,
1739: '_PVT'
1740: );
1741: WHEN OTHERS THEN
1742: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1743: (
1744: l_api_name,
1745: G_PKG_NAME,
1746: 'OTHERS',

Line 1765: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1761: p_acyv_rec IN acyv_rec_type) IS
1762:
1763: l_api_version CONSTANT NUMBER := 1;
1764: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
1765: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1766: l_acyv_rec acyv_rec_type := p_acyv_rec;
1767: l_acy_rec acy_rec_type;
1768: BEGIN
1769: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1769: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1765: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1766: l_acyv_rec acyv_rec_type := p_acyv_rec;
1767: l_acy_rec acy_rec_type;
1768: BEGIN
1769: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1770: G_PKG_NAME,
1771: p_init_msg_list,
1772: l_api_version,
1773: p_api_version,

Line 1776: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1772: l_api_version,
1773: p_api_version,
1774: '_PVT',
1775: x_return_status);
1776: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1777: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1778: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1779: RAISE OKC_API.G_EXCEPTION_ERROR;
1780: END IF;

Line 1777: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1773: p_api_version,
1774: '_PVT',
1775: x_return_status);
1776: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1777: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1778: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1779: RAISE OKC_API.G_EXCEPTION_ERROR;
1780: END IF;
1781: --------------------------------------

Line 1778: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1774: '_PVT',
1775: x_return_status);
1776: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1777: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1778: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1779: RAISE OKC_API.G_EXCEPTION_ERROR;
1780: END IF;
1781: --------------------------------------
1782: -- Move VIEW record to "Child" records

Line 1779: RAISE OKC_API.G_EXCEPTION_ERROR;

1775: x_return_status);
1776: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1777: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1778: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1779: RAISE OKC_API.G_EXCEPTION_ERROR;
1780: END IF;
1781: --------------------------------------
1782: -- Move VIEW record to "Child" records
1783: --------------------------------------

Line 1795: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1791: x_msg_count,
1792: x_msg_data,
1793: l_acy_rec
1794: );
1795: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1796: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1797: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1798: RAISE OKC_API.G_EXCEPTION_ERROR;
1799: END IF;

Line 1796: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1792: x_msg_data,
1793: l_acy_rec
1794: );
1795: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1796: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1797: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1798: RAISE OKC_API.G_EXCEPTION_ERROR;
1799: END IF;
1800: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1797: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1793: l_acy_rec
1794: );
1795: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1796: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1797: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1798: RAISE OKC_API.G_EXCEPTION_ERROR;
1799: END IF;
1800: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1801: EXCEPTION

Line 1798: RAISE OKC_API.G_EXCEPTION_ERROR;

1794: );
1795: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1796: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1797: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1798: RAISE OKC_API.G_EXCEPTION_ERROR;
1799: END IF;
1800: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1801: EXCEPTION
1802: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1800: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1796: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1797: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1798: RAISE OKC_API.G_EXCEPTION_ERROR;
1799: END IF;
1800: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1801: EXCEPTION
1802: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1803: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1804: (

Line 1802: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1798: RAISE OKC_API.G_EXCEPTION_ERROR;
1799: END IF;
1800: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1801: EXCEPTION
1802: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1803: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1804: (
1805: l_api_name,
1806: G_PKG_NAME,

Line 1803: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1799: END IF;
1800: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1801: EXCEPTION
1802: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1803: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1804: (
1805: l_api_name,
1806: G_PKG_NAME,
1807: 'OKC_API.G_RET_STS_ERROR',

Line 1807: 'OKC_API.G_RET_STS_ERROR',

1803: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1804: (
1805: l_api_name,
1806: G_PKG_NAME,
1807: 'OKC_API.G_RET_STS_ERROR',
1808: x_msg_count,
1809: x_msg_data,
1810: '_PVT'
1811: );

Line 1812: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1808: x_msg_count,
1809: x_msg_data,
1810: '_PVT'
1811: );
1812: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1813: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1814: (
1815: l_api_name,
1816: G_PKG_NAME,

Line 1813: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1809: x_msg_data,
1810: '_PVT'
1811: );
1812: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1813: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1814: (
1815: l_api_name,
1816: G_PKG_NAME,
1817: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1817: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1813: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1814: (
1815: l_api_name,
1816: G_PKG_NAME,
1817: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1818: x_msg_count,
1819: x_msg_data,
1820: '_PVT'
1821: );

Line 1823: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1819: x_msg_data,
1820: '_PVT'
1821: );
1822: WHEN OTHERS THEN
1823: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1824: (
1825: l_api_name,
1826: G_PKG_NAME,
1827: 'OTHERS',

Line 1846: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1842: p_acyv_tbl IN acyv_tbl_type) IS
1843:
1844: l_api_version CONSTANT NUMBER := 1;
1845: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
1846: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1847: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1848: i NUMBER := 0;
1849: BEGIN
1850: OKC_API.init_msg_list(p_init_msg_list);

Line 1847: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1843:
1844: l_api_version CONSTANT NUMBER := 1;
1845: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
1846: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1847: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1848: i NUMBER := 0;
1849: BEGIN
1850: OKC_API.init_msg_list(p_init_msg_list);
1851: -- Make sure PL/SQL table has records in it before passing

Line 1850: OKC_API.init_msg_list(p_init_msg_list);

1846: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1847: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1848: i NUMBER := 0;
1849: BEGIN
1850: OKC_API.init_msg_list(p_init_msg_list);
1851: -- Make sure PL/SQL table has records in it before passing
1852: IF (p_acyv_tbl.COUNT > 0) THEN
1853: i := p_acyv_tbl.FIRST;
1854: LOOP

Line 1857: p_init_msg_list => OKC_API.G_FALSE,

1853: i := p_acyv_tbl.FIRST;
1854: LOOP
1855: delete_row (
1856: p_api_version => p_api_version,
1857: p_init_msg_list => OKC_API.G_FALSE,
1858: x_return_status => x_return_status,
1859: x_msg_count => x_msg_count,
1860: x_msg_data => x_msg_data,
1861: p_acyv_rec => p_acyv_tbl(i));

Line 1864: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

1860: x_msg_data => x_msg_data,
1861: p_acyv_rec => p_acyv_tbl(i));
1862:
1863: -- store the highest degree of error
1864: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
1865: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
1866: l_overall_status := x_return_status;
1867: End If;
1868: End If;

Line 1865: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

1861: p_acyv_rec => p_acyv_tbl(i));
1862:
1863: -- store the highest degree of error
1864: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
1865: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
1866: l_overall_status := x_return_status;
1867: End If;
1868: End If;
1869:

Line 1877: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1873: -- return overall status
1874: x_return_status := l_overall_status;
1875: END IF;
1876: EXCEPTION
1877: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1878: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1879: (
1880: l_api_name,
1881: G_PKG_NAME,

Line 1878: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1874: x_return_status := l_overall_status;
1875: END IF;
1876: EXCEPTION
1877: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1878: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1879: (
1880: l_api_name,
1881: G_PKG_NAME,
1882: 'OKC_API.G_RET_STS_ERROR',

Line 1882: 'OKC_API.G_RET_STS_ERROR',

1878: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1879: (
1880: l_api_name,
1881: G_PKG_NAME,
1882: 'OKC_API.G_RET_STS_ERROR',
1883: x_msg_count,
1884: x_msg_data,
1885: '_PVT'
1886: );

Line 1887: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1883: x_msg_count,
1884: x_msg_data,
1885: '_PVT'
1886: );
1887: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1888: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1889: (
1890: l_api_name,
1891: G_PKG_NAME,

Line 1888: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1884: x_msg_data,
1885: '_PVT'
1886: );
1887: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1888: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1889: (
1890: l_api_name,
1891: G_PKG_NAME,
1892: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1892: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1888: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1889: (
1890: l_api_name,
1891: G_PKG_NAME,
1892: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1893: x_msg_count,
1894: x_msg_data,
1895: '_PVT'
1896: );

Line 1898: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1894: x_msg_data,
1895: '_PVT'
1896: );
1897: WHEN OTHERS THEN
1898: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1899: (
1900: l_api_name,
1901: G_PKG_NAME,
1902: 'OTHERS',