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

APPS.OKC_CTI_PVT dependencies on OKC_API

Line 15: g_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_COVER_TIMES_V';
14: G_EXCEPTION_HALT_VALIDATION exception;
15: g_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16:
17: -- Start of comments
18: --
19: -- Procedure Name : validate_rul_id

Line 37: x_return_status := OKC_API.G_RET_STS_SUCCESS;

33: FROM OKC_RULES_B rulv
34: WHERE rulv.ID = p_ctiv_rec.RUL_ID;
35: BEGIN
36: -- initialize return status
37: x_return_status := OKC_API.G_RET_STS_SUCCESS;
38:
39: -- data required
40: IF (p_ctiv_rec.rul_id = OKC_API.G_MISS_NUM OR
41: p_ctiv_rec.rul_id IS NULL) THEN

Line 40: IF (p_ctiv_rec.rul_id = OKC_API.G_MISS_NUM OR

36: -- initialize return status
37: x_return_status := OKC_API.G_RET_STS_SUCCESS;
38:
39: -- data required
40: IF (p_ctiv_rec.rul_id = OKC_API.G_MISS_NUM OR
41: p_ctiv_rec.rul_id IS NULL) THEN
42:
43: OKC_API.set_message(
44: p_app_name => G_APP_NAME,

Line 43: OKC_API.set_message(

39: -- data required
40: IF (p_ctiv_rec.rul_id = OKC_API.G_MISS_NUM OR
41: p_ctiv_rec.rul_id IS NULL) THEN
42:
43: OKC_API.set_message(
44: p_app_name => G_APP_NAME,
45: p_msg_name => G_REQUIRED_VALUE,
46: p_token1 => G_COL_NAME_TOKEN,
47: p_token1_value => 'rul_id');

Line 50: x_return_status := OKC_API.G_RET_STS_ERROR;

46: p_token1 => G_COL_NAME_TOKEN,
47: p_token1_value => 'rul_id');
48:
49: -- notify caller of an error
50: x_return_status := OKC_API.G_RET_STS_ERROR;
51:
52: -- halt validation
53: RAISE G_EXCEPTION_HALT_VALIDATION;
54: END IF;

Line 63: OKC_API.set_message(

59: CLOSE l_rulv_csr;
60:
61: -- if l_dummy_var still set to default, data was not found
62: IF (l_dummy_var = '?') THEN
63: OKC_API.set_message(
64: p_app_name => G_APP_NAME,
65: p_msg_name => G_NO_PARENT_RECORD,
66: p_token1 => G_COL_NAME_TOKEN,
67: p_token1_value => 'rul_id',

Line 74: x_return_status := OKC_API.G_RET_STS_ERROR;

70: p_token3 => G_PARENT_TABLE_TOKEN,
71: p_token3_value => 'OKC_RULES_V');
72:
73: -- notify caller of an error
74: x_return_status := OKC_API.G_RET_STS_ERROR;
75: END IF;
76: EXCEPTION
77: WHEN G_EXCEPTION_HALT_VALIDATION THEN
78: -- no processing necessary; validation can continue with next column

Line 82: OKC_API.SET_MESSAGE(

78: -- no processing necessary; validation can continue with next column
79: NULL;
80: WHEN OTHERS THEN
81: -- store SQL error message on message stack
82: OKC_API.SET_MESSAGE(
83: p_app_name => g_app_name,
84: p_msg_name => g_unexpected_error,
85: p_token1 => g_sqlcode_token,
86: p_token1_value => sqlcode,

Line 90: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

86: p_token1_value => sqlcode,
87: p_token2 => g_sqlerrm_token,
88: p_token2_value => sqlerrm);
89: -- notify caller of an error as UNEXPETED error
90: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
91: -- verify that cursor was closed
92: IF l_rulv_csr%ISOPEN THEN
93: CLOSE l_rulv_csr;
94: END IF;

Line 117: x_return_status := OKC_API.G_RET_STS_SUCCESS;

113: FROM OKC_TIMEVALUES tvev
114: WHERE tvev.ID = p_ctiv_rec.TVE_ID;
115: BEGIN
116: -- initialize return status
117: x_return_status := OKC_API.G_RET_STS_SUCCESS;
118:
119: -- data required
120: IF (p_ctiv_rec.tve_id = OKC_API.G_MISS_NUM OR
121: p_ctiv_rec.tve_id IS NULL) THEN

Line 120: IF (p_ctiv_rec.tve_id = OKC_API.G_MISS_NUM OR

116: -- initialize return status
117: x_return_status := OKC_API.G_RET_STS_SUCCESS;
118:
119: -- data required
120: IF (p_ctiv_rec.tve_id = OKC_API.G_MISS_NUM OR
121: p_ctiv_rec.tve_id IS NULL) THEN
122:
123: OKC_API.set_message(
124: p_app_name => G_APP_NAME,

Line 123: OKC_API.set_message(

119: -- data required
120: IF (p_ctiv_rec.tve_id = OKC_API.G_MISS_NUM OR
121: p_ctiv_rec.tve_id IS NULL) THEN
122:
123: OKC_API.set_message(
124: p_app_name => G_APP_NAME,
125: p_msg_name => G_REQUIRED_VALUE,
126: p_token1 => G_COL_NAME_TOKEN,
127: p_token1_value => 'tve_id');

Line 130: x_return_status := OKC_API.G_RET_STS_ERROR;

126: p_token1 => G_COL_NAME_TOKEN,
127: p_token1_value => 'tve_id');
128:
129: -- notify caller of an error
130: x_return_status := OKC_API.G_RET_STS_ERROR;
131:
132: -- halt validation
133: RAISE G_EXCEPTION_HALT_VALIDATION;
134: END IF;

Line 143: OKC_API.set_message(

139: CLOSE l_tvev_csr;
140:
141: -- if l_dummy_var still set to default, data was not found
142: IF (l_dummy_var = '?') THEN
143: OKC_API.set_message(
144: p_app_name => G_APP_NAME,
145: p_msg_name => G_NO_PARENT_RECORD,
146: p_token1 => G_COL_NAME_TOKEN,
147: p_token1_value => 'tve_id',

Line 153: x_return_status := OKC_API.G_RET_STS_ERROR;

149: p_token2_value => G_VIEW,
150: p_token3 => G_PARENT_TABLE_TOKEN,
151: p_token3_value => 'OKC_TIMEVALUES_V');
152: -- notify caller of an error
153: x_return_status := OKC_API.G_RET_STS_ERROR;
154: END IF;
155: EXCEPTION
156: WHEN G_EXCEPTION_HALT_VALIDATION THEN
157: -- no processing necessary; validation can continue with next column

Line 161: OKC_API.SET_MESSAGE(

157: -- no processing necessary; validation can continue with next column
158: NULL;
159: WHEN OTHERS THEN
160: -- store SQL error message on message stack
161: OKC_API.SET_MESSAGE(
162: p_app_name => g_app_name,
163: p_msg_name => g_unexpected_error,
164: p_token1 => g_sqlcode_token,
165: p_token1_value => sqlcode,

Line 169: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

165: p_token1_value => sqlcode,
166: p_token2 => g_sqlerrm_token,
167: p_token2_value => sqlerrm);
168: -- notify caller of an error as UNEXPETED error
169: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
170: -- verify that cursor was closed
171: IF l_tvev_csr%ISOPEN THEN
172: CLOSE l_tvev_csr;
173: END IF;

Line 196: x_return_status := OKC_API.G_RET_STS_SUCCESS;

192: FROM OKC_K_HEADERS_B chrv
193: WHERE chrv.ID = p_ctiv_rec.DNZ_CHR_ID;
194: BEGIN
195: -- initialize return status
196: x_return_status := OKC_API.G_RET_STS_SUCCESS;
197:
198: -- data required
199: IF (p_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR
200: p_ctiv_rec.dnz_chr_id IS NULL) THEN

Line 199: IF (p_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR

195: -- initialize return status
196: x_return_status := OKC_API.G_RET_STS_SUCCESS;
197:
198: -- data required
199: IF (p_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR
200: p_ctiv_rec.dnz_chr_id IS NULL) THEN
201:
202: OKC_API.set_message(
203: p_app_name => G_APP_NAME,

Line 202: OKC_API.set_message(

198: -- data required
199: IF (p_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR
200: p_ctiv_rec.dnz_chr_id IS NULL) THEN
201:
202: OKC_API.set_message(
203: p_app_name => G_APP_NAME,
204: p_msg_name => G_REQUIRED_VALUE,
205: p_token1 => G_COL_NAME_TOKEN,
206: p_token1_value => 'dnz_chr_id');

Line 209: x_return_status := OKC_API.G_RET_STS_ERROR;

205: p_token1 => G_COL_NAME_TOKEN,
206: p_token1_value => 'dnz_chr_id');
207:
208: -- notify caller of an error
209: x_return_status := OKC_API.G_RET_STS_ERROR;
210:
211: -- halt validation
212: RAISE G_EXCEPTION_HALT_VALIDATION;
213: END IF;

Line 222: OKC_API.set_message(

218: CLOSE l_chrv_csr;
219:
220: -- if l_dummy_var still set to default, data was not found
221: IF (l_dummy_var = '?') THEN
222: OKC_API.set_message(
223: p_app_name => G_APP_NAME,
224: p_msg_name => G_NO_PARENT_RECORD,
225: p_token1 => G_COL_NAME_TOKEN,
226: p_token1_value => 'dnz_chr_id',

Line 233: x_return_status := OKC_API.G_RET_STS_ERROR;

229: p_token3 => G_PARENT_TABLE_TOKEN,
230: p_token3_value => 'OKC_K_HEADERS_V');
231:
232: -- notify caller of an error
233: x_return_status := OKC_API.G_RET_STS_ERROR;
234: END IF;
235: EXCEPTION
236: WHEN G_EXCEPTION_HALT_VALIDATION THEN
237: -- no processing necessary; validation can continue with next column

Line 241: OKC_API.SET_MESSAGE(

237: -- no processing necessary; validation can continue with next column
238: NULL;
239: WHEN OTHERS THEN
240: -- store SQL error message on message stack
241: OKC_API.SET_MESSAGE(
242: p_app_name => g_app_name,
243: p_msg_name => g_unexpected_error,
244: p_token1 => g_sqlcode_token,
245: p_token1_value => sqlcode,

Line 249: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

245: p_token1_value => sqlcode,
246: p_token2 => g_sqlerrm_token,
247: p_token2_value => sqlerrm);
248: -- notify caller of an error as UNEXPETED error
249: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
250: -- verify that cursor was closed
251: IF l_chrv_csr%ISOPEN THEN
252: CLOSE l_chrv_csr;
253: END IF;

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

264:
265: FUNCTION Validate_Attributes (
266: p_ctiv_rec IN ctiv_rec_type
267: ) RETURN VARCHAR2 IS
268: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
269: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
270: BEGIN
271: -- call each column-level validation
272:

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

265: FUNCTION Validate_Attributes (
266: p_ctiv_rec IN ctiv_rec_type
267: ) RETURN VARCHAR2 IS
268: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
269: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
270: BEGIN
271: -- call each column-level validation
272:
273: validate_rul_id(

Line 278: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

274: x_return_status => l_return_status,
275: p_ctiv_rec => p_ctiv_rec);
276:
277: -- store the highest degree of error
278: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
279: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
280: x_return_status := l_return_status;
281: END IF;
282: END IF;

Line 279: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

275: p_ctiv_rec => p_ctiv_rec);
276:
277: -- store the highest degree of error
278: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
279: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
280: x_return_status := l_return_status;
281: END IF;
282: END IF;
283: --

Line 289: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

285: x_return_status => l_return_status,
286: p_ctiv_rec => p_ctiv_rec);
287:
288: -- store the highest degree of error
289: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
290: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
291: x_return_status := l_return_status;
292: END IF;
293: END IF;

Line 290: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

286: p_ctiv_rec => p_ctiv_rec);
287:
288: -- store the highest degree of error
289: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
290: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
291: x_return_status := l_return_status;
292: END IF;
293: END IF;
294: --

Line 300: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

296: x_return_status => l_return_status,
297: p_ctiv_rec => p_ctiv_rec);
298:
299: -- store the highest degree of error
300: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
301: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
302: x_return_status := l_return_status;
303: END IF;
304: END IF;

Line 301: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

297: p_ctiv_rec => p_ctiv_rec);
298:
299: -- store the highest degree of error
300: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
301: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
302: x_return_status := l_return_status;
303: END IF;
304: END IF;
305: --

Line 312: OKC_API.SET_MESSAGE

308:
309: EXCEPTION
310: WHEN OTHERS THEN
311: -- store SQL error message on message stack for caller
312: OKC_API.SET_MESSAGE
313: (p_app_name => G_APP_NAME,
314: p_msg_name => G_UNEXPECTED_ERROR,
315: p_token1 => G_SQLCODE_TOKEN,
316: p_token1_value => SQLCODE,

Line 321: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

317: p_token2 => G_SQLERRM_TOKEN,
318: p_token2_value => SQLERRM);
319:
320: -- notify caller of an UNEXPECTED error
321: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
322:
323: -- return status to caller
324: RETURN x_return_status;
325:

Line 473: IF (l_ctiv_rec.rul_id = OKC_API.G_MISS_NUM) THEN

469: p_ctiv_rec IN ctiv_rec_type
470: ) RETURN ctiv_rec_type IS
471: l_ctiv_rec ctiv_rec_type := p_ctiv_rec;
472: BEGIN
473: IF (l_ctiv_rec.rul_id = OKC_API.G_MISS_NUM) THEN
474: l_ctiv_rec.rul_id := NULL;
475: END IF;
476: IF (l_ctiv_rec.tve_id = OKC_API.G_MISS_NUM) THEN
477: l_ctiv_rec.tve_id := NULL;

Line 476: IF (l_ctiv_rec.tve_id = OKC_API.G_MISS_NUM) THEN

472: BEGIN
473: IF (l_ctiv_rec.rul_id = OKC_API.G_MISS_NUM) THEN
474: l_ctiv_rec.rul_id := NULL;
475: END IF;
476: IF (l_ctiv_rec.tve_id = OKC_API.G_MISS_NUM) THEN
477: l_ctiv_rec.tve_id := NULL;
478: END IF;
479: IF (l_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) THEN
480: l_ctiv_rec.dnz_chr_id := NULL;

Line 479: IF (l_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) THEN

475: END IF;
476: IF (l_ctiv_rec.tve_id = OKC_API.G_MISS_NUM) THEN
477: l_ctiv_rec.tve_id := NULL;
478: END IF;
479: IF (l_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) THEN
480: l_ctiv_rec.dnz_chr_id := NULL;
481: END IF;
482: IF (l_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
483: l_ctiv_rec.object_version_number := NULL;

Line 482: IF (l_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

478: END IF;
479: IF (l_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) THEN
480: l_ctiv_rec.dnz_chr_id := NULL;
481: END IF;
482: IF (l_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
483: l_ctiv_rec.object_version_number := NULL;
484: END IF;
485: IF (l_ctiv_rec.created_by = OKC_API.G_MISS_NUM) THEN
486: l_ctiv_rec.created_by := NULL;

Line 485: IF (l_ctiv_rec.created_by = OKC_API.G_MISS_NUM) THEN

481: END IF;
482: IF (l_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
483: l_ctiv_rec.object_version_number := NULL;
484: END IF;
485: IF (l_ctiv_rec.created_by = OKC_API.G_MISS_NUM) THEN
486: l_ctiv_rec.created_by := NULL;
487: END IF;
488: IF (l_ctiv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
489: l_ctiv_rec.creation_date := NULL;

Line 488: IF (l_ctiv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

484: END IF;
485: IF (l_ctiv_rec.created_by = OKC_API.G_MISS_NUM) THEN
486: l_ctiv_rec.created_by := NULL;
487: END IF;
488: IF (l_ctiv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
489: l_ctiv_rec.creation_date := NULL;
490: END IF;
491: IF (l_ctiv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
492: l_ctiv_rec.last_updated_by := NULL;

Line 491: IF (l_ctiv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

487: END IF;
488: IF (l_ctiv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
489: l_ctiv_rec.creation_date := NULL;
490: END IF;
491: IF (l_ctiv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
492: l_ctiv_rec.last_updated_by := NULL;
493: END IF;
494: IF (l_ctiv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
495: l_ctiv_rec.last_update_date := NULL;

Line 494: IF (l_ctiv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

490: END IF;
491: IF (l_ctiv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
492: l_ctiv_rec.last_updated_by := NULL;
493: END IF;
494: IF (l_ctiv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
495: l_ctiv_rec.last_update_date := NULL;
496: END IF;
497: IF (l_ctiv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
498: l_ctiv_rec.last_update_login := NULL;

Line 497: IF (l_ctiv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

493: END IF;
494: IF (l_ctiv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
495: l_ctiv_rec.last_update_date := NULL;
496: END IF;
497: IF (l_ctiv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
498: l_ctiv_rec.last_update_login := NULL;
499: END IF;
500: RETURN(l_ctiv_rec);
501: END null_out_defaults;

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

508: /* commenting out nocopy generated code in favor of hand-coded procedure
509: FUNCTION Validate_Attributes (
510: p_ctiv_rec IN ctiv_rec_type
511: ) RETURN VARCHAR2 IS
512: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
513: BEGIN
514: IF p_ctiv_rec.rul_id = OKC_API.G_MISS_NUM OR
515: p_ctiv_rec.rul_id IS NULL
516: THEN

Line 514: IF p_ctiv_rec.rul_id = OKC_API.G_MISS_NUM OR

510: p_ctiv_rec IN ctiv_rec_type
511: ) RETURN VARCHAR2 IS
512: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
513: BEGIN
514: IF p_ctiv_rec.rul_id = OKC_API.G_MISS_NUM OR
515: p_ctiv_rec.rul_id IS NULL
516: THEN
517: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'rul_id');
518: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 517: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'rul_id');

513: BEGIN
514: IF p_ctiv_rec.rul_id = OKC_API.G_MISS_NUM OR
515: p_ctiv_rec.rul_id IS NULL
516: THEN
517: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'rul_id');
518: l_return_status := OKC_API.G_RET_STS_ERROR;
519: ELSIF p_ctiv_rec.tve_id = OKC_API.G_MISS_NUM OR
520: p_ctiv_rec.tve_id IS NULL
521: THEN

Line 518: l_return_status := OKC_API.G_RET_STS_ERROR;

514: IF p_ctiv_rec.rul_id = OKC_API.G_MISS_NUM OR
515: p_ctiv_rec.rul_id IS NULL
516: THEN
517: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'rul_id');
518: l_return_status := OKC_API.G_RET_STS_ERROR;
519: ELSIF p_ctiv_rec.tve_id = OKC_API.G_MISS_NUM OR
520: p_ctiv_rec.tve_id IS NULL
521: THEN
522: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'tve_id');

Line 519: ELSIF p_ctiv_rec.tve_id = OKC_API.G_MISS_NUM OR

515: p_ctiv_rec.rul_id IS NULL
516: THEN
517: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'rul_id');
518: l_return_status := OKC_API.G_RET_STS_ERROR;
519: ELSIF p_ctiv_rec.tve_id = OKC_API.G_MISS_NUM OR
520: p_ctiv_rec.tve_id IS NULL
521: THEN
522: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'tve_id');
523: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 522: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'tve_id');

518: l_return_status := OKC_API.G_RET_STS_ERROR;
519: ELSIF p_ctiv_rec.tve_id = OKC_API.G_MISS_NUM OR
520: p_ctiv_rec.tve_id IS NULL
521: THEN
522: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'tve_id');
523: l_return_status := OKC_API.G_RET_STS_ERROR;
524: ELSIF p_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR
525: p_ctiv_rec.dnz_chr_id IS NULL
526: THEN

Line 523: l_return_status := OKC_API.G_RET_STS_ERROR;

519: ELSIF p_ctiv_rec.tve_id = OKC_API.G_MISS_NUM OR
520: p_ctiv_rec.tve_id IS NULL
521: THEN
522: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'tve_id');
523: l_return_status := OKC_API.G_RET_STS_ERROR;
524: ELSIF p_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR
525: p_ctiv_rec.dnz_chr_id IS NULL
526: THEN
527: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dnz_chr_id');

Line 524: ELSIF p_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR

520: p_ctiv_rec.tve_id IS NULL
521: THEN
522: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'tve_id');
523: l_return_status := OKC_API.G_RET_STS_ERROR;
524: ELSIF p_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR
525: p_ctiv_rec.dnz_chr_id IS NULL
526: THEN
527: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dnz_chr_id');
528: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 527: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dnz_chr_id');

523: l_return_status := OKC_API.G_RET_STS_ERROR;
524: ELSIF p_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR
525: p_ctiv_rec.dnz_chr_id IS NULL
526: THEN
527: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dnz_chr_id');
528: l_return_status := OKC_API.G_RET_STS_ERROR;
529: ELSIF p_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM OR
530: p_ctiv_rec.object_version_number IS NULL
531: THEN

Line 528: l_return_status := OKC_API.G_RET_STS_ERROR;

524: ELSIF p_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR
525: p_ctiv_rec.dnz_chr_id IS NULL
526: THEN
527: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dnz_chr_id');
528: l_return_status := OKC_API.G_RET_STS_ERROR;
529: ELSIF p_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM OR
530: p_ctiv_rec.object_version_number IS NULL
531: THEN
532: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 529: ELSIF p_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM OR

525: p_ctiv_rec.dnz_chr_id IS NULL
526: THEN
527: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dnz_chr_id');
528: l_return_status := OKC_API.G_RET_STS_ERROR;
529: ELSIF p_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM OR
530: p_ctiv_rec.object_version_number IS NULL
531: THEN
532: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
533: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 532: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

528: l_return_status := OKC_API.G_RET_STS_ERROR;
529: ELSIF p_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM OR
530: p_ctiv_rec.object_version_number IS NULL
531: THEN
532: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
533: l_return_status := OKC_API.G_RET_STS_ERROR;
534: END IF;
535: RETURN(l_return_status);
536: END Validate_Attributes;

Line 533: l_return_status := OKC_API.G_RET_STS_ERROR;

529: ELSIF p_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM OR
530: p_ctiv_rec.object_version_number IS NULL
531: THEN
532: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
533: l_return_status := OKC_API.G_RET_STS_ERROR;
534: END IF;
535: RETURN(l_return_status);
536: END Validate_Attributes;
537: */

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

543: -------------------------------------------
544: FUNCTION Validate_Record (
545: p_ctiv_rec IN ctiv_rec_type
546: ) RETURN VARCHAR2 IS
547: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
548: BEGIN
549: RETURN (l_return_status);
550: END Validate_Record;
551:

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

598: p_ctiv_rec IN ctiv_rec_type) IS
599:
600: l_api_version CONSTANT NUMBER := 1;
601: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
602: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
603: l_ctiv_rec ctiv_rec_type := p_ctiv_rec;
604: l_cti_rec cti_rec_type;
605: BEGIN
606: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

602: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
603: l_ctiv_rec ctiv_rec_type := p_ctiv_rec;
604: l_cti_rec cti_rec_type;
605: BEGIN
606: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
607: G_PKG_NAME,
608: p_init_msg_list,
609: l_api_version,
610: p_api_version,

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

609: l_api_version,
610: p_api_version,
611: '_PVT',
612: x_return_status);
613: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
614: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
616: RAISE OKC_API.G_EXCEPTION_ERROR;
617: END IF;

Line 614: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

610: p_api_version,
611: '_PVT',
612: x_return_status);
613: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
614: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
616: RAISE OKC_API.G_EXCEPTION_ERROR;
617: END IF;
618: --- Validate all non-missing attributes (Item Level Validation)

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

611: '_PVT',
612: x_return_status);
613: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
614: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
616: RAISE OKC_API.G_EXCEPTION_ERROR;
617: END IF;
618: --- Validate all non-missing attributes (Item Level Validation)
619: l_return_status := Validate_Attributes(l_ctiv_rec);

Line 616: RAISE OKC_API.G_EXCEPTION_ERROR;

612: x_return_status);
613: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
614: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
616: RAISE OKC_API.G_EXCEPTION_ERROR;
617: END IF;
618: --- Validate all non-missing attributes (Item Level Validation)
619: l_return_status := Validate_Attributes(l_ctiv_rec);
620: --- If any errors happen abort API

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

617: END IF;
618: --- Validate all non-missing attributes (Item Level Validation)
619: l_return_status := Validate_Attributes(l_ctiv_rec);
620: --- If any errors happen abort API
621: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
622: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
623: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
624: RAISE OKC_API.G_EXCEPTION_ERROR;
625: END IF;

Line 622: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

618: --- Validate all non-missing attributes (Item Level Validation)
619: l_return_status := Validate_Attributes(l_ctiv_rec);
620: --- If any errors happen abort API
621: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
622: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
623: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
624: RAISE OKC_API.G_EXCEPTION_ERROR;
625: END IF;
626: l_return_status := Validate_Record(l_ctiv_rec);

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

619: l_return_status := Validate_Attributes(l_ctiv_rec);
620: --- If any errors happen abort API
621: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
622: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
623: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
624: RAISE OKC_API.G_EXCEPTION_ERROR;
625: END IF;
626: l_return_status := Validate_Record(l_ctiv_rec);
627: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 624: RAISE OKC_API.G_EXCEPTION_ERROR;

620: --- If any errors happen abort API
621: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
622: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
623: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
624: RAISE OKC_API.G_EXCEPTION_ERROR;
625: END IF;
626: l_return_status := Validate_Record(l_ctiv_rec);
627: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
628: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

623: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
624: RAISE OKC_API.G_EXCEPTION_ERROR;
625: END IF;
626: l_return_status := Validate_Record(l_ctiv_rec);
627: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
628: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
629: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
630: RAISE OKC_API.G_EXCEPTION_ERROR;
631: END IF;

Line 628: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

624: RAISE OKC_API.G_EXCEPTION_ERROR;
625: END IF;
626: l_return_status := Validate_Record(l_ctiv_rec);
627: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
628: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
629: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
630: RAISE OKC_API.G_EXCEPTION_ERROR;
631: END IF;
632: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

625: END IF;
626: l_return_status := Validate_Record(l_ctiv_rec);
627: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
628: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
629: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
630: RAISE OKC_API.G_EXCEPTION_ERROR;
631: END IF;
632: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
633: EXCEPTION

Line 630: RAISE OKC_API.G_EXCEPTION_ERROR;

626: l_return_status := Validate_Record(l_ctiv_rec);
627: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
628: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
629: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
630: RAISE OKC_API.G_EXCEPTION_ERROR;
631: END IF;
632: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
633: EXCEPTION
634: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

628: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
629: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
630: RAISE OKC_API.G_EXCEPTION_ERROR;
631: END IF;
632: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
633: EXCEPTION
634: WHEN OKC_API.G_EXCEPTION_ERROR THEN
635: x_return_status := OKC_API.HANDLE_EXCEPTIONS
636: (

Line 634: WHEN OKC_API.G_EXCEPTION_ERROR THEN

630: RAISE OKC_API.G_EXCEPTION_ERROR;
631: END IF;
632: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
633: EXCEPTION
634: WHEN OKC_API.G_EXCEPTION_ERROR THEN
635: x_return_status := OKC_API.HANDLE_EXCEPTIONS
636: (
637: l_api_name,
638: G_PKG_NAME,

Line 635: x_return_status := OKC_API.HANDLE_EXCEPTIONS

631: END IF;
632: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
633: EXCEPTION
634: WHEN OKC_API.G_EXCEPTION_ERROR THEN
635: x_return_status := OKC_API.HANDLE_EXCEPTIONS
636: (
637: l_api_name,
638: G_PKG_NAME,
639: 'OKC_API.G_RET_STS_ERROR',

Line 639: 'OKC_API.G_RET_STS_ERROR',

635: x_return_status := OKC_API.HANDLE_EXCEPTIONS
636: (
637: l_api_name,
638: G_PKG_NAME,
639: 'OKC_API.G_RET_STS_ERROR',
640: x_msg_count,
641: x_msg_data,
642: '_PVT'
643: );

Line 644: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

640: x_msg_count,
641: x_msg_data,
642: '_PVT'
643: );
644: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
645: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
646: (
647: l_api_name,
648: G_PKG_NAME,

Line 645: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

641: x_msg_data,
642: '_PVT'
643: );
644: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
645: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
646: (
647: l_api_name,
648: G_PKG_NAME,
649: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 649: 'OKC_API.G_RET_STS_UNEXP_ERROR',

645: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
646: (
647: l_api_name,
648: G_PKG_NAME,
649: 'OKC_API.G_RET_STS_UNEXP_ERROR',
650: x_msg_count,
651: x_msg_data,
652: '_PVT'
653: );

Line 655: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

651: x_msg_data,
652: '_PVT'
653: );
654: WHEN OTHERS THEN
655: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
656: (
657: l_api_name,
658: G_PKG_NAME,
659: 'OTHERS',

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

674: p_ctiv_tbl IN ctiv_tbl_type) IS
675:
676: l_api_version CONSTANT NUMBER := 1;
677: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
678: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
679: i NUMBER := 0;
680: BEGIN
681: OKC_API.init_msg_list(p_init_msg_list);
682: -- Make sure PL/SQL table has records in it before passing

Line 681: OKC_API.init_msg_list(p_init_msg_list);

677: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
678: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
679: i NUMBER := 0;
680: BEGIN
681: OKC_API.init_msg_list(p_init_msg_list);
682: -- Make sure PL/SQL table has records in it before passing
683: IF (p_ctiv_tbl.COUNT > 0) THEN
684: i := p_ctiv_tbl.FIRST;
685: LOOP

Line 688: p_init_msg_list => OKC_API.G_FALSE,

684: i := p_ctiv_tbl.FIRST;
685: LOOP
686: validate_row (
687: p_api_version => p_api_version,
688: p_init_msg_list => OKC_API.G_FALSE,
689: x_return_status => x_return_status,
690: x_msg_count => x_msg_count,
691: x_msg_data => x_msg_data,
692: p_ctiv_rec => p_ctiv_tbl(i));

Line 698: WHEN OKC_API.G_EXCEPTION_ERROR THEN

694: i := p_ctiv_tbl.NEXT(i);
695: END LOOP;
696: END IF;
697: EXCEPTION
698: WHEN OKC_API.G_EXCEPTION_ERROR THEN
699: x_return_status := OKC_API.HANDLE_EXCEPTIONS
700: (
701: l_api_name,
702: G_PKG_NAME,

Line 699: x_return_status := OKC_API.HANDLE_EXCEPTIONS

695: END LOOP;
696: END IF;
697: EXCEPTION
698: WHEN OKC_API.G_EXCEPTION_ERROR THEN
699: x_return_status := OKC_API.HANDLE_EXCEPTIONS
700: (
701: l_api_name,
702: G_PKG_NAME,
703: 'OKC_API.G_RET_STS_ERROR',

Line 703: 'OKC_API.G_RET_STS_ERROR',

699: x_return_status := OKC_API.HANDLE_EXCEPTIONS
700: (
701: l_api_name,
702: G_PKG_NAME,
703: 'OKC_API.G_RET_STS_ERROR',
704: x_msg_count,
705: x_msg_data,
706: '_PVT'
707: );

Line 708: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

704: x_msg_count,
705: x_msg_data,
706: '_PVT'
707: );
708: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
709: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
710: (
711: l_api_name,
712: G_PKG_NAME,

Line 709: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

705: x_msg_data,
706: '_PVT'
707: );
708: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
709: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
710: (
711: l_api_name,
712: G_PKG_NAME,
713: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 713: 'OKC_API.G_RET_STS_UNEXP_ERROR',

709: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
710: (
711: l_api_name,
712: G_PKG_NAME,
713: 'OKC_API.G_RET_STS_UNEXP_ERROR',
714: x_msg_count,
715: x_msg_data,
716: '_PVT'
717: );

Line 719: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

715: x_msg_data,
716: '_PVT'
717: );
718: WHEN OTHERS THEN
719: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
720: (
721: l_api_name,
722: G_PKG_NAME,
723: 'OTHERS',

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

742: x_cti_rec OUT NOCOPY cti_rec_type) IS
743:
744: l_api_version CONSTANT NUMBER := 1;
745: l_api_name CONSTANT VARCHAR2(30) := 'TIMES_insert_row';
746: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
747: l_cti_rec cti_rec_type := p_cti_rec;
748: l_def_cti_rec cti_rec_type;
749: ----------------------------------------
750: -- Set_Attributes for:OKC_COVER_TIMES --

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

752: FUNCTION Set_Attributes (
753: p_cti_rec IN cti_rec_type,
754: x_cti_rec OUT NOCOPY cti_rec_type
755: ) RETURN VARCHAR2 IS
756: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
757: BEGIN
758: x_cti_rec := p_cti_rec;
759: RETURN(l_return_status);
760: END Set_Attributes;

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

758: x_cti_rec := p_cti_rec;
759: RETURN(l_return_status);
760: END Set_Attributes;
761: BEGIN
762: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
763: p_init_msg_list,
764: '_PVT',
765: x_return_status);
766: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

762: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
763: p_init_msg_list,
764: '_PVT',
765: x_return_status);
766: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
767: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
768: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
769: RAISE OKC_API.G_EXCEPTION_ERROR;
770: END IF;

Line 767: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

763: p_init_msg_list,
764: '_PVT',
765: x_return_status);
766: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
767: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
768: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
769: RAISE OKC_API.G_EXCEPTION_ERROR;
770: END IF;
771: --- Setting item attributes

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

764: '_PVT',
765: x_return_status);
766: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
767: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
768: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
769: RAISE OKC_API.G_EXCEPTION_ERROR;
770: END IF;
771: --- Setting item attributes
772: l_return_status := Set_Attributes(

Line 769: RAISE OKC_API.G_EXCEPTION_ERROR;

765: x_return_status);
766: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
767: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
768: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
769: RAISE OKC_API.G_EXCEPTION_ERROR;
770: END IF;
771: --- Setting item attributes
772: l_return_status := Set_Attributes(
773: p_cti_rec, -- IN

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

772: l_return_status := Set_Attributes(
773: p_cti_rec, -- IN
774: l_cti_rec); -- OUT
775: --- If any errors happen abort API
776: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
777: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
778: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
779: RAISE OKC_API.G_EXCEPTION_ERROR;
780: END IF;

Line 777: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

773: p_cti_rec, -- IN
774: l_cti_rec); -- OUT
775: --- If any errors happen abort API
776: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
777: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
778: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
779: RAISE OKC_API.G_EXCEPTION_ERROR;
780: END IF;
781: INSERT INTO OKC_COVER_TIMES(

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

774: l_cti_rec); -- OUT
775: --- If any errors happen abort API
776: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
777: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
778: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
779: RAISE OKC_API.G_EXCEPTION_ERROR;
780: END IF;
781: INSERT INTO OKC_COVER_TIMES(
782: rul_id,

Line 779: RAISE OKC_API.G_EXCEPTION_ERROR;

775: --- If any errors happen abort API
776: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
777: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
778: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
779: RAISE OKC_API.G_EXCEPTION_ERROR;
780: END IF;
781: INSERT INTO OKC_COVER_TIMES(
782: rul_id,
783: tve_id,

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

799: l_cti_rec.last_update_date,
800: l_cti_rec.last_update_login);
801: -- Set OUT values
802: x_cti_rec := l_cti_rec;
803: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
804: EXCEPTION
805: WHEN OKC_API.G_EXCEPTION_ERROR THEN
806: x_return_status := OKC_API.HANDLE_EXCEPTIONS
807: (

Line 805: WHEN OKC_API.G_EXCEPTION_ERROR THEN

801: -- Set OUT values
802: x_cti_rec := l_cti_rec;
803: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
804: EXCEPTION
805: WHEN OKC_API.G_EXCEPTION_ERROR THEN
806: x_return_status := OKC_API.HANDLE_EXCEPTIONS
807: (
808: l_api_name,
809: G_PKG_NAME,

Line 806: x_return_status := OKC_API.HANDLE_EXCEPTIONS

802: x_cti_rec := l_cti_rec;
803: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
804: EXCEPTION
805: WHEN OKC_API.G_EXCEPTION_ERROR THEN
806: x_return_status := OKC_API.HANDLE_EXCEPTIONS
807: (
808: l_api_name,
809: G_PKG_NAME,
810: 'OKC_API.G_RET_STS_ERROR',

Line 810: 'OKC_API.G_RET_STS_ERROR',

806: x_return_status := OKC_API.HANDLE_EXCEPTIONS
807: (
808: l_api_name,
809: G_PKG_NAME,
810: 'OKC_API.G_RET_STS_ERROR',
811: x_msg_count,
812: x_msg_data,
813: '_PVT'
814: );

Line 815: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

811: x_msg_count,
812: x_msg_data,
813: '_PVT'
814: );
815: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
816: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
817: (
818: l_api_name,
819: G_PKG_NAME,

Line 816: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

812: x_msg_data,
813: '_PVT'
814: );
815: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
816: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
817: (
818: l_api_name,
819: G_PKG_NAME,
820: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 820: 'OKC_API.G_RET_STS_UNEXP_ERROR',

816: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
817: (
818: l_api_name,
819: G_PKG_NAME,
820: 'OKC_API.G_RET_STS_UNEXP_ERROR',
821: x_msg_count,
822: x_msg_data,
823: '_PVT'
824: );

Line 826: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

822: x_msg_data,
823: '_PVT'
824: );
825: WHEN OTHERS THEN
826: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
827: (
828: l_api_name,
829: G_PKG_NAME,
830: 'OTHERS',

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

846: x_ctiv_rec OUT NOCOPY ctiv_rec_type) IS
847:
848: l_api_version CONSTANT NUMBER := 1;
849: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
850: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
851: l_ctiv_rec ctiv_rec_type;
852: l_def_ctiv_rec ctiv_rec_type;
853: l_cti_rec cti_rec_type;
854: lx_cti_rec cti_rec_type;

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

873: FUNCTION Set_Attributes (
874: p_ctiv_rec IN ctiv_rec_type,
875: x_ctiv_rec OUT NOCOPY ctiv_rec_type
876: ) RETURN VARCHAR2 IS
877: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
878: BEGIN
879: x_ctiv_rec := p_ctiv_rec;
880: x_ctiv_rec.OBJECT_VERSION_NUMBER := 1;
881: RETURN(l_return_status);

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

880: x_ctiv_rec.OBJECT_VERSION_NUMBER := 1;
881: RETURN(l_return_status);
882: END Set_Attributes;
883: BEGIN
884: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
885: G_PKG_NAME,
886: p_init_msg_list,
887: l_api_version,
888: p_api_version,

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

887: l_api_version,
888: p_api_version,
889: '_PVT',
890: x_return_status);
891: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
894: RAISE OKC_API.G_EXCEPTION_ERROR;
895: END IF;

Line 892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

888: p_api_version,
889: '_PVT',
890: x_return_status);
891: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
894: RAISE OKC_API.G_EXCEPTION_ERROR;
895: END IF;
896: l_ctiv_rec := null_out_defaults(p_ctiv_rec);

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

889: '_PVT',
890: x_return_status);
891: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
894: RAISE OKC_API.G_EXCEPTION_ERROR;
895: END IF;
896: l_ctiv_rec := null_out_defaults(p_ctiv_rec);
897: --- Setting item attributes

Line 894: RAISE OKC_API.G_EXCEPTION_ERROR;

890: x_return_status);
891: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
894: RAISE OKC_API.G_EXCEPTION_ERROR;
895: END IF;
896: l_ctiv_rec := null_out_defaults(p_ctiv_rec);
897: --- Setting item attributes
898: l_return_status := Set_Attributes(

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

898: l_return_status := Set_Attributes(
899: l_ctiv_rec, -- IN
900: l_def_ctiv_rec); -- OUT
901: --- If any errors happen abort API
902: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
903: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
904: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
905: RAISE OKC_API.G_EXCEPTION_ERROR;
906: END IF;

Line 903: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

899: l_ctiv_rec, -- IN
900: l_def_ctiv_rec); -- OUT
901: --- If any errors happen abort API
902: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
903: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
904: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
905: RAISE OKC_API.G_EXCEPTION_ERROR;
906: END IF;
907: l_def_ctiv_rec := fill_who_columns(l_def_ctiv_rec);

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

900: l_def_ctiv_rec); -- OUT
901: --- If any errors happen abort API
902: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
903: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
904: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
905: RAISE OKC_API.G_EXCEPTION_ERROR;
906: END IF;
907: l_def_ctiv_rec := fill_who_columns(l_def_ctiv_rec);
908: --- Validate all non-missing attributes (Item Level Validation)

Line 905: RAISE OKC_API.G_EXCEPTION_ERROR;

901: --- If any errors happen abort API
902: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
903: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
904: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
905: RAISE OKC_API.G_EXCEPTION_ERROR;
906: END IF;
907: l_def_ctiv_rec := fill_who_columns(l_def_ctiv_rec);
908: --- Validate all non-missing attributes (Item Level Validation)
909: l_return_status := Validate_Attributes(l_def_ctiv_rec);

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

907: l_def_ctiv_rec := fill_who_columns(l_def_ctiv_rec);
908: --- Validate all non-missing attributes (Item Level Validation)
909: l_return_status := Validate_Attributes(l_def_ctiv_rec);
910: --- If any errors happen abort API
911: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
912: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
913: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
914: RAISE OKC_API.G_EXCEPTION_ERROR;
915: END IF;

Line 912: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

908: --- Validate all non-missing attributes (Item Level Validation)
909: l_return_status := Validate_Attributes(l_def_ctiv_rec);
910: --- If any errors happen abort API
911: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
912: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
913: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
914: RAISE OKC_API.G_EXCEPTION_ERROR;
915: END IF;
916: l_return_status := Validate_Record(l_def_ctiv_rec);

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

909: l_return_status := Validate_Attributes(l_def_ctiv_rec);
910: --- If any errors happen abort API
911: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
912: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
913: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
914: RAISE OKC_API.G_EXCEPTION_ERROR;
915: END IF;
916: l_return_status := Validate_Record(l_def_ctiv_rec);
917: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 914: RAISE OKC_API.G_EXCEPTION_ERROR;

910: --- If any errors happen abort API
911: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
912: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
913: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
914: RAISE OKC_API.G_EXCEPTION_ERROR;
915: END IF;
916: l_return_status := Validate_Record(l_def_ctiv_rec);
917: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
918: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

913: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
914: RAISE OKC_API.G_EXCEPTION_ERROR;
915: END IF;
916: l_return_status := Validate_Record(l_def_ctiv_rec);
917: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
918: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
920: RAISE OKC_API.G_EXCEPTION_ERROR;
921: END IF;

Line 918: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

914: RAISE OKC_API.G_EXCEPTION_ERROR;
915: END IF;
916: l_return_status := Validate_Record(l_def_ctiv_rec);
917: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
918: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
920: RAISE OKC_API.G_EXCEPTION_ERROR;
921: END IF;
922: --------------------------------------

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

915: END IF;
916: l_return_status := Validate_Record(l_def_ctiv_rec);
917: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
918: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
920: RAISE OKC_API.G_EXCEPTION_ERROR;
921: END IF;
922: --------------------------------------
923: -- Move VIEW record to "Child" records

Line 920: RAISE OKC_API.G_EXCEPTION_ERROR;

916: l_return_status := Validate_Record(l_def_ctiv_rec);
917: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
918: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
920: RAISE OKC_API.G_EXCEPTION_ERROR;
921: END IF;
922: --------------------------------------
923: -- Move VIEW record to "Child" records
924: --------------------------------------

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

933: x_msg_data,
934: l_cti_rec,
935: lx_cti_rec
936: );
937: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
938: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
939: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
940: RAISE OKC_API.G_EXCEPTION_ERROR;
941: END IF;

Line 938: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

934: l_cti_rec,
935: lx_cti_rec
936: );
937: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
938: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
939: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
940: RAISE OKC_API.G_EXCEPTION_ERROR;
941: END IF;
942: migrate(lx_cti_rec, l_def_ctiv_rec);

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

935: lx_cti_rec
936: );
937: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
938: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
939: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
940: RAISE OKC_API.G_EXCEPTION_ERROR;
941: END IF;
942: migrate(lx_cti_rec, l_def_ctiv_rec);
943: -- Set OUT values

Line 940: RAISE OKC_API.G_EXCEPTION_ERROR;

936: );
937: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
938: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
939: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
940: RAISE OKC_API.G_EXCEPTION_ERROR;
941: END IF;
942: migrate(lx_cti_rec, l_def_ctiv_rec);
943: -- Set OUT values
944: x_ctiv_rec := l_def_ctiv_rec;

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

941: END IF;
942: migrate(lx_cti_rec, l_def_ctiv_rec);
943: -- Set OUT values
944: x_ctiv_rec := l_def_ctiv_rec;
945: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
946: EXCEPTION
947: WHEN OKC_API.G_EXCEPTION_ERROR THEN
948: x_return_status := OKC_API.HANDLE_EXCEPTIONS
949: (

Line 947: WHEN OKC_API.G_EXCEPTION_ERROR THEN

943: -- Set OUT values
944: x_ctiv_rec := l_def_ctiv_rec;
945: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
946: EXCEPTION
947: WHEN OKC_API.G_EXCEPTION_ERROR THEN
948: x_return_status := OKC_API.HANDLE_EXCEPTIONS
949: (
950: l_api_name,
951: G_PKG_NAME,

Line 948: x_return_status := OKC_API.HANDLE_EXCEPTIONS

944: x_ctiv_rec := l_def_ctiv_rec;
945: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
946: EXCEPTION
947: WHEN OKC_API.G_EXCEPTION_ERROR THEN
948: x_return_status := OKC_API.HANDLE_EXCEPTIONS
949: (
950: l_api_name,
951: G_PKG_NAME,
952: 'OKC_API.G_RET_STS_ERROR',

Line 952: 'OKC_API.G_RET_STS_ERROR',

948: x_return_status := OKC_API.HANDLE_EXCEPTIONS
949: (
950: l_api_name,
951: G_PKG_NAME,
952: 'OKC_API.G_RET_STS_ERROR',
953: x_msg_count,
954: x_msg_data,
955: '_PVT'
956: );

Line 957: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 958: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

954: x_msg_data,
955: '_PVT'
956: );
957: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
958: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
959: (
960: l_api_name,
961: G_PKG_NAME,
962: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 962: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 968: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

964: x_msg_data,
965: '_PVT'
966: );
967: WHEN OTHERS THEN
968: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
969: (
970: l_api_name,
971: G_PKG_NAME,
972: 'OTHERS',

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

988: x_ctiv_tbl OUT NOCOPY ctiv_tbl_type) IS
989:
990: l_api_version CONSTANT NUMBER := 1;
991: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
992: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
993: i NUMBER := 0;
994: BEGIN
995: OKC_API.init_msg_list(p_init_msg_list);
996: -- Make sure PL/SQL table has records in it before passing

Line 995: OKC_API.init_msg_list(p_init_msg_list);

991: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
992: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
993: i NUMBER := 0;
994: BEGIN
995: OKC_API.init_msg_list(p_init_msg_list);
996: -- Make sure PL/SQL table has records in it before passing
997: IF (p_ctiv_tbl.COUNT > 0) THEN
998: i := p_ctiv_tbl.FIRST;
999: LOOP

Line 1002: p_init_msg_list => OKC_API.G_FALSE,

998: i := p_ctiv_tbl.FIRST;
999: LOOP
1000: insert_row (
1001: p_api_version => p_api_version,
1002: p_init_msg_list => OKC_API.G_FALSE,
1003: x_return_status => x_return_status,
1004: x_msg_count => x_msg_count,
1005: x_msg_data => x_msg_data,
1006: p_ctiv_rec => p_ctiv_tbl(i),

Line 1013: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1009: i := p_ctiv_tbl.NEXT(i);
1010: END LOOP;
1011: END IF;
1012: EXCEPTION
1013: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1014: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1015: (
1016: l_api_name,
1017: G_PKG_NAME,

Line 1014: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1010: END LOOP;
1011: END IF;
1012: EXCEPTION
1013: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1014: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1015: (
1016: l_api_name,
1017: G_PKG_NAME,
1018: 'OKC_API.G_RET_STS_ERROR',

Line 1018: 'OKC_API.G_RET_STS_ERROR',

1014: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1015: (
1016: l_api_name,
1017: G_PKG_NAME,
1018: 'OKC_API.G_RET_STS_ERROR',
1019: x_msg_count,
1020: x_msg_data,
1021: '_PVT'
1022: );

Line 1023: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1019: x_msg_count,
1020: x_msg_data,
1021: '_PVT'
1022: );
1023: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1024: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1025: (
1026: l_api_name,
1027: G_PKG_NAME,

Line 1024: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1020: x_msg_data,
1021: '_PVT'
1022: );
1023: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1024: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1025: (
1026: l_api_name,
1027: G_PKG_NAME,
1028: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1028: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1024: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1025: (
1026: l_api_name,
1027: G_PKG_NAME,
1028: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1029: x_msg_count,
1030: x_msg_data,
1031: '_PVT'
1032: );

Line 1034: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1030: x_msg_data,
1031: '_PVT'
1032: );
1033: WHEN OTHERS THEN
1034: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1035: (
1036: l_api_name,
1037: G_PKG_NAME,
1038: 'OTHERS',

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

1071: WHERE RUL_ID = p_cti_rec.rul_id
1072: AND TVE_ID = p_cti_rec.tve_id;
1073: l_api_version CONSTANT NUMBER := 1;
1074: l_api_name CONSTANT VARCHAR2(30) := 'TIMES_lock_row';
1075: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1076: l_object_version_number OKC_COVER_TIMES.OBJECT_VERSION_NUMBER%TYPE;
1077: lc_object_version_number OKC_COVER_TIMES.OBJECT_VERSION_NUMBER%TYPE;
1078: l_row_notfound BOOLEAN := FALSE;
1079: lc_row_notfound BOOLEAN := FALSE;

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

1077: lc_object_version_number OKC_COVER_TIMES.OBJECT_VERSION_NUMBER%TYPE;
1078: l_row_notfound BOOLEAN := FALSE;
1079: lc_row_notfound BOOLEAN := FALSE;
1080: BEGIN
1081: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1082: p_init_msg_list,
1083: '_PVT',
1084: x_return_status);
1085: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1081: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1082: p_init_msg_list,
1083: '_PVT',
1084: x_return_status);
1085: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1086: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1087: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1088: RAISE OKC_API.G_EXCEPTION_ERROR;
1089: END IF;

Line 1086: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1082: p_init_msg_list,
1083: '_PVT',
1084: x_return_status);
1085: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1086: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1087: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1088: RAISE OKC_API.G_EXCEPTION_ERROR;
1089: END IF;
1090: BEGIN

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

1083: '_PVT',
1084: x_return_status);
1085: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1086: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1087: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1088: RAISE OKC_API.G_EXCEPTION_ERROR;
1089: END IF;
1090: BEGIN
1091: OPEN lock_csr(p_cti_rec);

Line 1088: RAISE OKC_API.G_EXCEPTION_ERROR;

1084: x_return_status);
1085: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1086: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1087: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1088: RAISE OKC_API.G_EXCEPTION_ERROR;
1089: END IF;
1090: BEGIN
1091: OPEN lock_csr(p_cti_rec);
1092: FETCH lock_csr INTO l_object_version_number;

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

1096: WHEN E_Resource_Busy THEN
1097: IF (lock_csr%ISOPEN) THEN
1098: CLOSE lock_csr;
1099: END IF;
1100: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1101: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1102: END;
1103:
1104: IF ( l_row_notfound ) THEN

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

1107: lc_row_notfound := lchk_csr%NOTFOUND;
1108: CLOSE lchk_csr;
1109: END IF;
1110: IF (lc_row_notfound) THEN
1111: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1112: RAISE OKC_API.G_EXCEPTION_ERROR;
1113: ELSIF lc_object_version_number > p_cti_rec.object_version_number THEN
1114: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1115: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1112: RAISE OKC_API.G_EXCEPTION_ERROR;

1108: CLOSE lchk_csr;
1109: END IF;
1110: IF (lc_row_notfound) THEN
1111: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1112: RAISE OKC_API.G_EXCEPTION_ERROR;
1113: ELSIF lc_object_version_number > p_cti_rec.object_version_number THEN
1114: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1115: RAISE OKC_API.G_EXCEPTION_ERROR;
1116: ELSIF lc_object_version_number <> p_cti_rec.object_version_number THEN

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

1110: IF (lc_row_notfound) THEN
1111: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1112: RAISE OKC_API.G_EXCEPTION_ERROR;
1113: ELSIF lc_object_version_number > p_cti_rec.object_version_number THEN
1114: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1115: RAISE OKC_API.G_EXCEPTION_ERROR;
1116: ELSIF lc_object_version_number <> p_cti_rec.object_version_number THEN
1117: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1118: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1115: RAISE OKC_API.G_EXCEPTION_ERROR;

1111: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1112: RAISE OKC_API.G_EXCEPTION_ERROR;
1113: ELSIF lc_object_version_number > p_cti_rec.object_version_number THEN
1114: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1115: RAISE OKC_API.G_EXCEPTION_ERROR;
1116: ELSIF lc_object_version_number <> p_cti_rec.object_version_number THEN
1117: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1118: RAISE OKC_API.G_EXCEPTION_ERROR;
1119: ELSIF lc_object_version_number = -1 THEN

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

1113: ELSIF lc_object_version_number > p_cti_rec.object_version_number THEN
1114: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1115: RAISE OKC_API.G_EXCEPTION_ERROR;
1116: ELSIF lc_object_version_number <> p_cti_rec.object_version_number THEN
1117: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1118: RAISE OKC_API.G_EXCEPTION_ERROR;
1119: ELSIF lc_object_version_number = -1 THEN
1120: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1121: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1118: RAISE OKC_API.G_EXCEPTION_ERROR;

1114: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1115: RAISE OKC_API.G_EXCEPTION_ERROR;
1116: ELSIF lc_object_version_number <> p_cti_rec.object_version_number THEN
1117: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1118: RAISE OKC_API.G_EXCEPTION_ERROR;
1119: ELSIF lc_object_version_number = -1 THEN
1120: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1121: RAISE OKC_API.G_EXCEPTION_ERROR;
1122: END IF;

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

1116: ELSIF lc_object_version_number <> p_cti_rec.object_version_number THEN
1117: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1118: RAISE OKC_API.G_EXCEPTION_ERROR;
1119: ELSIF lc_object_version_number = -1 THEN
1120: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1121: RAISE OKC_API.G_EXCEPTION_ERROR;
1122: END IF;
1123: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1124: EXCEPTION

Line 1121: RAISE OKC_API.G_EXCEPTION_ERROR;

1117: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1118: RAISE OKC_API.G_EXCEPTION_ERROR;
1119: ELSIF lc_object_version_number = -1 THEN
1120: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1121: RAISE OKC_API.G_EXCEPTION_ERROR;
1122: END IF;
1123: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1124: EXCEPTION
1125: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1119: ELSIF lc_object_version_number = -1 THEN
1120: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1121: RAISE OKC_API.G_EXCEPTION_ERROR;
1122: END IF;
1123: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1124: EXCEPTION
1125: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1126: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1127: (

Line 1125: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1121: RAISE OKC_API.G_EXCEPTION_ERROR;
1122: END IF;
1123: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1124: EXCEPTION
1125: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1126: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1127: (
1128: l_api_name,
1129: G_PKG_NAME,

Line 1126: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1122: END IF;
1123: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1124: EXCEPTION
1125: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1126: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1127: (
1128: l_api_name,
1129: G_PKG_NAME,
1130: 'OKC_API.G_RET_STS_ERROR',

Line 1130: 'OKC_API.G_RET_STS_ERROR',

1126: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1127: (
1128: l_api_name,
1129: G_PKG_NAME,
1130: 'OKC_API.G_RET_STS_ERROR',
1131: x_msg_count,
1132: x_msg_data,
1133: '_PVT'
1134: );

Line 1135: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1131: x_msg_count,
1132: x_msg_data,
1133: '_PVT'
1134: );
1135: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1136: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1137: (
1138: l_api_name,
1139: G_PKG_NAME,

Line 1136: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1132: x_msg_data,
1133: '_PVT'
1134: );
1135: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1136: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1137: (
1138: l_api_name,
1139: G_PKG_NAME,
1140: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1140: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1136: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1137: (
1138: l_api_name,
1139: G_PKG_NAME,
1140: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1141: x_msg_count,
1142: x_msg_data,
1143: '_PVT'
1144: );

Line 1146: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1142: x_msg_data,
1143: '_PVT'
1144: );
1145: WHEN OTHERS THEN
1146: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1147: (
1148: l_api_name,
1149: G_PKG_NAME,
1150: 'OTHERS',

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

1165: p_ctiv_rec IN ctiv_rec_type) IS
1166:
1167: l_api_version CONSTANT NUMBER := 1;
1168: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1169: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1170: l_cti_rec cti_rec_type;
1171: BEGIN
1172: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1173: G_PKG_NAME,

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

1168: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1169: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1170: l_cti_rec cti_rec_type;
1171: BEGIN
1172: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1173: G_PKG_NAME,
1174: p_init_msg_list,
1175: l_api_version,
1176: p_api_version,

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

1175: l_api_version,
1176: p_api_version,
1177: '_PVT',
1178: x_return_status);
1179: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1180: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1181: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1182: RAISE OKC_API.G_EXCEPTION_ERROR;
1183: END IF;

Line 1180: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1176: p_api_version,
1177: '_PVT',
1178: x_return_status);
1179: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1180: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1181: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1182: RAISE OKC_API.G_EXCEPTION_ERROR;
1183: END IF;
1184: --------------------------------------

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

1177: '_PVT',
1178: x_return_status);
1179: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1180: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1181: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1182: RAISE OKC_API.G_EXCEPTION_ERROR;
1183: END IF;
1184: --------------------------------------
1185: -- Move VIEW record to "Child" records

Line 1182: RAISE OKC_API.G_EXCEPTION_ERROR;

1178: x_return_status);
1179: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1180: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1181: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1182: RAISE OKC_API.G_EXCEPTION_ERROR;
1183: END IF;
1184: --------------------------------------
1185: -- Move VIEW record to "Child" records
1186: --------------------------------------

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

1194: x_msg_count,
1195: x_msg_data,
1196: l_cti_rec
1197: );
1198: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1200: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1201: RAISE OKC_API.G_EXCEPTION_ERROR;
1202: END IF;

Line 1199: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1195: x_msg_data,
1196: l_cti_rec
1197: );
1198: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1200: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1201: RAISE OKC_API.G_EXCEPTION_ERROR;
1202: END IF;
1203: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1196: l_cti_rec
1197: );
1198: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1200: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1201: RAISE OKC_API.G_EXCEPTION_ERROR;
1202: END IF;
1203: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1204: EXCEPTION

Line 1201: RAISE OKC_API.G_EXCEPTION_ERROR;

1197: );
1198: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1200: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1201: RAISE OKC_API.G_EXCEPTION_ERROR;
1202: END IF;
1203: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1204: EXCEPTION
1205: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1199: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1200: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1201: RAISE OKC_API.G_EXCEPTION_ERROR;
1202: END IF;
1203: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1204: EXCEPTION
1205: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1206: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1207: (

Line 1205: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1201: RAISE OKC_API.G_EXCEPTION_ERROR;
1202: END IF;
1203: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1204: EXCEPTION
1205: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1206: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1207: (
1208: l_api_name,
1209: G_PKG_NAME,

Line 1206: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1202: END IF;
1203: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1204: EXCEPTION
1205: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1206: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1207: (
1208: l_api_name,
1209: G_PKG_NAME,
1210: 'OKC_API.G_RET_STS_ERROR',

Line 1210: 'OKC_API.G_RET_STS_ERROR',

1206: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1207: (
1208: l_api_name,
1209: G_PKG_NAME,
1210: 'OKC_API.G_RET_STS_ERROR',
1211: x_msg_count,
1212: x_msg_data,
1213: '_PVT'
1214: );

Line 1215: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1211: x_msg_count,
1212: x_msg_data,
1213: '_PVT'
1214: );
1215: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1216: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1217: (
1218: l_api_name,
1219: G_PKG_NAME,

Line 1216: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1212: x_msg_data,
1213: '_PVT'
1214: );
1215: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1216: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1217: (
1218: l_api_name,
1219: G_PKG_NAME,
1220: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1220: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1216: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1217: (
1218: l_api_name,
1219: G_PKG_NAME,
1220: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1221: x_msg_count,
1222: x_msg_data,
1223: '_PVT'
1224: );

Line 1226: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1222: x_msg_data,
1223: '_PVT'
1224: );
1225: WHEN OTHERS THEN
1226: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1227: (
1228: l_api_name,
1229: G_PKG_NAME,
1230: 'OTHERS',

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

1245: p_ctiv_tbl IN ctiv_tbl_type) IS
1246:
1247: l_api_version CONSTANT NUMBER := 1;
1248: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1249: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1250: i NUMBER := 0;
1251: BEGIN
1252: OKC_API.init_msg_list(p_init_msg_list);
1253: -- Make sure PL/SQL table has records in it before passing

Line 1252: OKC_API.init_msg_list(p_init_msg_list);

1248: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1249: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1250: i NUMBER := 0;
1251: BEGIN
1252: OKC_API.init_msg_list(p_init_msg_list);
1253: -- Make sure PL/SQL table has records in it before passing
1254: IF (p_ctiv_tbl.COUNT > 0) THEN
1255: i := p_ctiv_tbl.FIRST;
1256: LOOP

Line 1259: p_init_msg_list => OKC_API.G_FALSE,

1255: i := p_ctiv_tbl.FIRST;
1256: LOOP
1257: lock_row (
1258: p_api_version => p_api_version,
1259: p_init_msg_list => OKC_API.G_FALSE,
1260: x_return_status => x_return_status,
1261: x_msg_count => x_msg_count,
1262: x_msg_data => x_msg_data,
1263: p_ctiv_rec => p_ctiv_tbl(i));

Line 1269: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1265: i := p_ctiv_tbl.NEXT(i);
1266: END LOOP;
1267: END IF;
1268: EXCEPTION
1269: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1270: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1271: (
1272: l_api_name,
1273: G_PKG_NAME,

Line 1270: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1266: END LOOP;
1267: END IF;
1268: EXCEPTION
1269: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1270: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1271: (
1272: l_api_name,
1273: G_PKG_NAME,
1274: 'OKC_API.G_RET_STS_ERROR',

Line 1274: 'OKC_API.G_RET_STS_ERROR',

1270: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1271: (
1272: l_api_name,
1273: G_PKG_NAME,
1274: 'OKC_API.G_RET_STS_ERROR',
1275: x_msg_count,
1276: x_msg_data,
1277: '_PVT'
1278: );

Line 1279: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1275: x_msg_count,
1276: x_msg_data,
1277: '_PVT'
1278: );
1279: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1280: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1281: (
1282: l_api_name,
1283: G_PKG_NAME,

Line 1280: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1276: x_msg_data,
1277: '_PVT'
1278: );
1279: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1280: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1281: (
1282: l_api_name,
1283: G_PKG_NAME,
1284: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1284: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1280: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1281: (
1282: l_api_name,
1283: G_PKG_NAME,
1284: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1285: x_msg_count,
1286: x_msg_data,
1287: '_PVT'
1288: );

Line 1290: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1286: x_msg_data,
1287: '_PVT'
1288: );
1289: WHEN OTHERS THEN
1290: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1291: (
1292: l_api_name,
1293: G_PKG_NAME,
1294: 'OTHERS',

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

1313: x_cti_rec OUT NOCOPY cti_rec_type) IS
1314:
1315: l_api_version CONSTANT NUMBER := 1;
1316: l_api_name CONSTANT VARCHAR2(30) := 'TIMES_update_row';
1317: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1318: l_cti_rec cti_rec_type := p_cti_rec;
1319: l_def_cti_rec cti_rec_type;
1320: l_row_notfound BOOLEAN := TRUE;
1321: ----------------------------------

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

1326: x_cti_rec OUT NOCOPY cti_rec_type
1327: ) RETURN VARCHAR2 IS
1328: l_cti_rec cti_rec_type;
1329: l_row_notfound BOOLEAN := TRUE;
1330: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1331: BEGIN
1332: x_cti_rec := p_cti_rec;
1333: -- Get current database values
1334: l_cti_rec := get_rec(p_cti_rec, l_row_notfound);

Line 1336: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1332: x_cti_rec := p_cti_rec;
1333: -- Get current database values
1334: l_cti_rec := get_rec(p_cti_rec, l_row_notfound);
1335: IF (l_row_notfound) THEN
1336: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1337: END IF;
1338: IF (x_cti_rec.rul_id = OKC_API.G_MISS_NUM)
1339: THEN
1340: x_cti_rec.rul_id := l_cti_rec.rul_id;

Line 1338: IF (x_cti_rec.rul_id = OKC_API.G_MISS_NUM)

1334: l_cti_rec := get_rec(p_cti_rec, l_row_notfound);
1335: IF (l_row_notfound) THEN
1336: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1337: END IF;
1338: IF (x_cti_rec.rul_id = OKC_API.G_MISS_NUM)
1339: THEN
1340: x_cti_rec.rul_id := l_cti_rec.rul_id;
1341: END IF;
1342: IF (x_cti_rec.tve_id = OKC_API.G_MISS_NUM)

Line 1342: IF (x_cti_rec.tve_id = OKC_API.G_MISS_NUM)

1338: IF (x_cti_rec.rul_id = OKC_API.G_MISS_NUM)
1339: THEN
1340: x_cti_rec.rul_id := l_cti_rec.rul_id;
1341: END IF;
1342: IF (x_cti_rec.tve_id = OKC_API.G_MISS_NUM)
1343: THEN
1344: x_cti_rec.tve_id := l_cti_rec.tve_id;
1345: END IF;
1346: IF (x_cti_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

Line 1346: IF (x_cti_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

1342: IF (x_cti_rec.tve_id = OKC_API.G_MISS_NUM)
1343: THEN
1344: x_cti_rec.tve_id := l_cti_rec.tve_id;
1345: END IF;
1346: IF (x_cti_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1347: THEN
1348: x_cti_rec.dnz_chr_id := l_cti_rec.dnz_chr_id;
1349: END IF;
1350: IF (x_cti_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1350: IF (x_cti_rec.object_version_number = OKC_API.G_MISS_NUM)

1346: IF (x_cti_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1347: THEN
1348: x_cti_rec.dnz_chr_id := l_cti_rec.dnz_chr_id;
1349: END IF;
1350: IF (x_cti_rec.object_version_number = OKC_API.G_MISS_NUM)
1351: THEN
1352: x_cti_rec.object_version_number := l_cti_rec.object_version_number;
1353: END IF;
1354: IF (x_cti_rec.created_by = OKC_API.G_MISS_NUM)

Line 1354: IF (x_cti_rec.created_by = OKC_API.G_MISS_NUM)

1350: IF (x_cti_rec.object_version_number = OKC_API.G_MISS_NUM)
1351: THEN
1352: x_cti_rec.object_version_number := l_cti_rec.object_version_number;
1353: END IF;
1354: IF (x_cti_rec.created_by = OKC_API.G_MISS_NUM)
1355: THEN
1356: x_cti_rec.created_by := l_cti_rec.created_by;
1357: END IF;
1358: IF (x_cti_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1358: IF (x_cti_rec.creation_date = OKC_API.G_MISS_DATE)

1354: IF (x_cti_rec.created_by = OKC_API.G_MISS_NUM)
1355: THEN
1356: x_cti_rec.created_by := l_cti_rec.created_by;
1357: END IF;
1358: IF (x_cti_rec.creation_date = OKC_API.G_MISS_DATE)
1359: THEN
1360: x_cti_rec.creation_date := l_cti_rec.creation_date;
1361: END IF;
1362: IF (x_cti_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1362: IF (x_cti_rec.last_updated_by = OKC_API.G_MISS_NUM)

1358: IF (x_cti_rec.creation_date = OKC_API.G_MISS_DATE)
1359: THEN
1360: x_cti_rec.creation_date := l_cti_rec.creation_date;
1361: END IF;
1362: IF (x_cti_rec.last_updated_by = OKC_API.G_MISS_NUM)
1363: THEN
1364: x_cti_rec.last_updated_by := l_cti_rec.last_updated_by;
1365: END IF;
1366: IF (x_cti_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1366: IF (x_cti_rec.last_update_date = OKC_API.G_MISS_DATE)

1362: IF (x_cti_rec.last_updated_by = OKC_API.G_MISS_NUM)
1363: THEN
1364: x_cti_rec.last_updated_by := l_cti_rec.last_updated_by;
1365: END IF;
1366: IF (x_cti_rec.last_update_date = OKC_API.G_MISS_DATE)
1367: THEN
1368: x_cti_rec.last_update_date := l_cti_rec.last_update_date;
1369: END IF;
1370: IF (x_cti_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1370: IF (x_cti_rec.last_update_login = OKC_API.G_MISS_NUM)

1366: IF (x_cti_rec.last_update_date = OKC_API.G_MISS_DATE)
1367: THEN
1368: x_cti_rec.last_update_date := l_cti_rec.last_update_date;
1369: END IF;
1370: IF (x_cti_rec.last_update_login = OKC_API.G_MISS_NUM)
1371: THEN
1372: x_cti_rec.last_update_login := l_cti_rec.last_update_login;
1373: END IF;
1374: RETURN(l_return_status);

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

1379: FUNCTION Set_Attributes (
1380: p_cti_rec IN cti_rec_type,
1381: x_cti_rec OUT NOCOPY cti_rec_type
1382: ) RETURN VARCHAR2 IS
1383: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1384: BEGIN
1385: x_cti_rec := p_cti_rec;
1386: RETURN(l_return_status);
1387: END Set_Attributes;

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

1385: x_cti_rec := p_cti_rec;
1386: RETURN(l_return_status);
1387: END Set_Attributes;
1388: BEGIN
1389: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1390: p_init_msg_list,
1391: '_PVT',
1392: x_return_status);
1393: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1389: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1390: p_init_msg_list,
1391: '_PVT',
1392: x_return_status);
1393: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1394: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1395: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1396: RAISE OKC_API.G_EXCEPTION_ERROR;
1397: END IF;

Line 1394: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1390: p_init_msg_list,
1391: '_PVT',
1392: x_return_status);
1393: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1394: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1395: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1396: RAISE OKC_API.G_EXCEPTION_ERROR;
1397: END IF;
1398: --- Setting item attributes

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

1391: '_PVT',
1392: x_return_status);
1393: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1394: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1395: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1396: RAISE OKC_API.G_EXCEPTION_ERROR;
1397: END IF;
1398: --- Setting item attributes
1399: l_return_status := Set_Attributes(

Line 1396: RAISE OKC_API.G_EXCEPTION_ERROR;

1392: x_return_status);
1393: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1394: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1395: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1396: RAISE OKC_API.G_EXCEPTION_ERROR;
1397: END IF;
1398: --- Setting item attributes
1399: l_return_status := Set_Attributes(
1400: p_cti_rec, -- IN

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

1399: l_return_status := Set_Attributes(
1400: p_cti_rec, -- IN
1401: l_cti_rec); -- OUT
1402: --- If any errors happen abort API
1403: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1405: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1406: RAISE OKC_API.G_EXCEPTION_ERROR;
1407: END IF;

Line 1404: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1400: p_cti_rec, -- IN
1401: l_cti_rec); -- OUT
1402: --- If any errors happen abort API
1403: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1405: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1406: RAISE OKC_API.G_EXCEPTION_ERROR;
1407: END IF;
1408: l_return_status := populate_new_record(l_cti_rec, l_def_cti_rec);

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

1401: l_cti_rec); -- OUT
1402: --- If any errors happen abort API
1403: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1405: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1406: RAISE OKC_API.G_EXCEPTION_ERROR;
1407: END IF;
1408: l_return_status := populate_new_record(l_cti_rec, l_def_cti_rec);
1409: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1406: RAISE OKC_API.G_EXCEPTION_ERROR;

1402: --- If any errors happen abort API
1403: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1405: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1406: RAISE OKC_API.G_EXCEPTION_ERROR;
1407: END IF;
1408: l_return_status := populate_new_record(l_cti_rec, l_def_cti_rec);
1409: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1405: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1406: RAISE OKC_API.G_EXCEPTION_ERROR;
1407: END IF;
1408: l_return_status := populate_new_record(l_cti_rec, l_def_cti_rec);
1409: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1411: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1412: RAISE OKC_API.G_EXCEPTION_ERROR;
1413: END IF;

Line 1410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1406: RAISE OKC_API.G_EXCEPTION_ERROR;
1407: END IF;
1408: l_return_status := populate_new_record(l_cti_rec, l_def_cti_rec);
1409: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1411: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1412: RAISE OKC_API.G_EXCEPTION_ERROR;
1413: END IF;
1414: UPDATE OKC_COVER_TIMES

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

1407: END IF;
1408: l_return_status := populate_new_record(l_cti_rec, l_def_cti_rec);
1409: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1411: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1412: RAISE OKC_API.G_EXCEPTION_ERROR;
1413: END IF;
1414: UPDATE OKC_COVER_TIMES
1415: SET DNZ_CHR_ID = l_def_cti_rec.dnz_chr_id,

Line 1412: RAISE OKC_API.G_EXCEPTION_ERROR;

1408: l_return_status := populate_new_record(l_cti_rec, l_def_cti_rec);
1409: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1411: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1412: RAISE OKC_API.G_EXCEPTION_ERROR;
1413: END IF;
1414: UPDATE OKC_COVER_TIMES
1415: SET DNZ_CHR_ID = l_def_cti_rec.dnz_chr_id,
1416: OBJECT_VERSION_NUMBER = l_def_cti_rec.object_version_number,

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

1422: WHERE RUL_ID = l_def_cti_rec.rul_id
1423: AND TVE_ID = l_def_cti_rec.tve_id;
1424:
1425: x_cti_rec := l_def_cti_rec;
1426: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1427: EXCEPTION
1428: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1429: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1430: (

Line 1428: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1424:
1425: x_cti_rec := l_def_cti_rec;
1426: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1427: EXCEPTION
1428: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1429: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1430: (
1431: l_api_name,
1432: G_PKG_NAME,

Line 1429: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1425: x_cti_rec := l_def_cti_rec;
1426: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1427: EXCEPTION
1428: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1429: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1430: (
1431: l_api_name,
1432: G_PKG_NAME,
1433: 'OKC_API.G_RET_STS_ERROR',

Line 1433: 'OKC_API.G_RET_STS_ERROR',

1429: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1430: (
1431: l_api_name,
1432: G_PKG_NAME,
1433: 'OKC_API.G_RET_STS_ERROR',
1434: x_msg_count,
1435: x_msg_data,
1436: '_PVT'
1437: );

Line 1438: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1434: x_msg_count,
1435: x_msg_data,
1436: '_PVT'
1437: );
1438: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1439: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1440: (
1441: l_api_name,
1442: G_PKG_NAME,

Line 1439: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1435: x_msg_data,
1436: '_PVT'
1437: );
1438: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1439: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1440: (
1441: l_api_name,
1442: G_PKG_NAME,
1443: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1443: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1439: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1440: (
1441: l_api_name,
1442: G_PKG_NAME,
1443: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1444: x_msg_count,
1445: x_msg_data,
1446: '_PVT'
1447: );

Line 1449: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1445: x_msg_data,
1446: '_PVT'
1447: );
1448: WHEN OTHERS THEN
1449: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1450: (
1451: l_api_name,
1452: G_PKG_NAME,
1453: 'OTHERS',

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

1469: x_ctiv_rec OUT NOCOPY ctiv_rec_type) IS
1470:
1471: l_api_version CONSTANT NUMBER := 1;
1472: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1473: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1474: l_ctiv_rec ctiv_rec_type := p_ctiv_rec;
1475: l_def_ctiv_rec ctiv_rec_type;
1476: l_cti_rec cti_rec_type;
1477: lx_cti_rec cti_rec_type;

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

1496: x_ctiv_rec OUT NOCOPY ctiv_rec_type
1497: ) RETURN VARCHAR2 IS
1498: l_ctiv_rec ctiv_rec_type;
1499: l_row_notfound BOOLEAN := TRUE;
1500: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1501: BEGIN
1502: x_ctiv_rec := p_ctiv_rec;
1503: -- Get current database values
1504: l_ctiv_rec := get_rec(p_ctiv_rec, l_row_notfound);

Line 1506: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1502: x_ctiv_rec := p_ctiv_rec;
1503: -- Get current database values
1504: l_ctiv_rec := get_rec(p_ctiv_rec, l_row_notfound);
1505: IF (l_row_notfound) THEN
1506: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1507: END IF;
1508: IF (x_ctiv_rec.rul_id = OKC_API.G_MISS_NUM)
1509: THEN
1510: x_ctiv_rec.rul_id := l_ctiv_rec.rul_id;

Line 1508: IF (x_ctiv_rec.rul_id = OKC_API.G_MISS_NUM)

1504: l_ctiv_rec := get_rec(p_ctiv_rec, l_row_notfound);
1505: IF (l_row_notfound) THEN
1506: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1507: END IF;
1508: IF (x_ctiv_rec.rul_id = OKC_API.G_MISS_NUM)
1509: THEN
1510: x_ctiv_rec.rul_id := l_ctiv_rec.rul_id;
1511: END IF;
1512: IF (x_ctiv_rec.tve_id = OKC_API.G_MISS_NUM)

Line 1512: IF (x_ctiv_rec.tve_id = OKC_API.G_MISS_NUM)

1508: IF (x_ctiv_rec.rul_id = OKC_API.G_MISS_NUM)
1509: THEN
1510: x_ctiv_rec.rul_id := l_ctiv_rec.rul_id;
1511: END IF;
1512: IF (x_ctiv_rec.tve_id = OKC_API.G_MISS_NUM)
1513: THEN
1514: x_ctiv_rec.tve_id := l_ctiv_rec.tve_id;
1515: END IF;
1516: IF (x_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

Line 1516: IF (x_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

1512: IF (x_ctiv_rec.tve_id = OKC_API.G_MISS_NUM)
1513: THEN
1514: x_ctiv_rec.tve_id := l_ctiv_rec.tve_id;
1515: END IF;
1516: IF (x_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1517: THEN
1518: x_ctiv_rec.dnz_chr_id := l_ctiv_rec.dnz_chr_id;
1519: END IF;
1520: IF (x_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1520: IF (x_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM)

1516: IF (x_ctiv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1517: THEN
1518: x_ctiv_rec.dnz_chr_id := l_ctiv_rec.dnz_chr_id;
1519: END IF;
1520: IF (x_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM)
1521: THEN
1522: x_ctiv_rec.object_version_number := l_ctiv_rec.object_version_number;
1523: END IF;
1524: IF (x_ctiv_rec.created_by = OKC_API.G_MISS_NUM)

Line 1524: IF (x_ctiv_rec.created_by = OKC_API.G_MISS_NUM)

1520: IF (x_ctiv_rec.object_version_number = OKC_API.G_MISS_NUM)
1521: THEN
1522: x_ctiv_rec.object_version_number := l_ctiv_rec.object_version_number;
1523: END IF;
1524: IF (x_ctiv_rec.created_by = OKC_API.G_MISS_NUM)
1525: THEN
1526: x_ctiv_rec.created_by := l_ctiv_rec.created_by;
1527: END IF;
1528: IF (x_ctiv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1528: IF (x_ctiv_rec.creation_date = OKC_API.G_MISS_DATE)

1524: IF (x_ctiv_rec.created_by = OKC_API.G_MISS_NUM)
1525: THEN
1526: x_ctiv_rec.created_by := l_ctiv_rec.created_by;
1527: END IF;
1528: IF (x_ctiv_rec.creation_date = OKC_API.G_MISS_DATE)
1529: THEN
1530: x_ctiv_rec.creation_date := l_ctiv_rec.creation_date;
1531: END IF;
1532: IF (x_ctiv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1532: IF (x_ctiv_rec.last_updated_by = OKC_API.G_MISS_NUM)

1528: IF (x_ctiv_rec.creation_date = OKC_API.G_MISS_DATE)
1529: THEN
1530: x_ctiv_rec.creation_date := l_ctiv_rec.creation_date;
1531: END IF;
1532: IF (x_ctiv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1533: THEN
1534: x_ctiv_rec.last_updated_by := l_ctiv_rec.last_updated_by;
1535: END IF;
1536: IF (x_ctiv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1536: IF (x_ctiv_rec.last_update_date = OKC_API.G_MISS_DATE)

1532: IF (x_ctiv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1533: THEN
1534: x_ctiv_rec.last_updated_by := l_ctiv_rec.last_updated_by;
1535: END IF;
1536: IF (x_ctiv_rec.last_update_date = OKC_API.G_MISS_DATE)
1537: THEN
1538: x_ctiv_rec.last_update_date := l_ctiv_rec.last_update_date;
1539: END IF;
1540: IF (x_ctiv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1540: IF (x_ctiv_rec.last_update_login = OKC_API.G_MISS_NUM)

1536: IF (x_ctiv_rec.last_update_date = OKC_API.G_MISS_DATE)
1537: THEN
1538: x_ctiv_rec.last_update_date := l_ctiv_rec.last_update_date;
1539: END IF;
1540: IF (x_ctiv_rec.last_update_login = OKC_API.G_MISS_NUM)
1541: THEN
1542: x_ctiv_rec.last_update_login := l_ctiv_rec.last_update_login;
1543: END IF;
1544: RETURN(l_return_status);

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

1549: FUNCTION Set_Attributes (
1550: p_ctiv_rec IN ctiv_rec_type,
1551: x_ctiv_rec OUT NOCOPY ctiv_rec_type
1552: ) RETURN VARCHAR2 IS
1553: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1554: BEGIN
1555: x_ctiv_rec := p_ctiv_rec;
1556: x_ctiv_rec.OBJECT_VERSION_NUMBER := NVL(x_ctiv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1557: RETURN(l_return_status);

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

1556: x_ctiv_rec.OBJECT_VERSION_NUMBER := NVL(x_ctiv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1557: RETURN(l_return_status);
1558: END Set_Attributes;
1559: BEGIN
1560: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1561: G_PKG_NAME,
1562: p_init_msg_list,
1563: l_api_version,
1564: p_api_version,

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

1563: l_api_version,
1564: p_api_version,
1565: '_PVT',
1566: x_return_status);
1567: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1568: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1569: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1570: RAISE OKC_API.G_EXCEPTION_ERROR;
1571: END IF;

Line 1568: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1564: p_api_version,
1565: '_PVT',
1566: x_return_status);
1567: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1568: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1569: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1570: RAISE OKC_API.G_EXCEPTION_ERROR;
1571: END IF;
1572: --- Setting item attributes

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

1565: '_PVT',
1566: x_return_status);
1567: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1568: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1569: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1570: RAISE OKC_API.G_EXCEPTION_ERROR;
1571: END IF;
1572: --- Setting item attributes
1573: l_return_status := Set_Attributes(

Line 1570: RAISE OKC_API.G_EXCEPTION_ERROR;

1566: x_return_status);
1567: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1568: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1569: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1570: RAISE OKC_API.G_EXCEPTION_ERROR;
1571: END IF;
1572: --- Setting item attributes
1573: l_return_status := Set_Attributes(
1574: p_ctiv_rec, -- IN

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

1573: l_return_status := Set_Attributes(
1574: p_ctiv_rec, -- IN
1575: l_ctiv_rec); -- OUT
1576: --- If any errors happen abort API
1577: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1578: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1579: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1580: RAISE OKC_API.G_EXCEPTION_ERROR;
1581: END IF;

Line 1578: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1574: p_ctiv_rec, -- IN
1575: l_ctiv_rec); -- OUT
1576: --- If any errors happen abort API
1577: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1578: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1579: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1580: RAISE OKC_API.G_EXCEPTION_ERROR;
1581: END IF;
1582: l_return_status := populate_new_record(l_ctiv_rec, l_def_ctiv_rec);

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

1575: l_ctiv_rec); -- OUT
1576: --- If any errors happen abort API
1577: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1578: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1579: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1580: RAISE OKC_API.G_EXCEPTION_ERROR;
1581: END IF;
1582: l_return_status := populate_new_record(l_ctiv_rec, l_def_ctiv_rec);
1583: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1580: RAISE OKC_API.G_EXCEPTION_ERROR;

1576: --- If any errors happen abort API
1577: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1578: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1579: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1580: RAISE OKC_API.G_EXCEPTION_ERROR;
1581: END IF;
1582: l_return_status := populate_new_record(l_ctiv_rec, l_def_ctiv_rec);
1583: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1579: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1580: RAISE OKC_API.G_EXCEPTION_ERROR;
1581: END IF;
1582: l_return_status := populate_new_record(l_ctiv_rec, l_def_ctiv_rec);
1583: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1586: RAISE OKC_API.G_EXCEPTION_ERROR;
1587: END IF;

Line 1584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1580: RAISE OKC_API.G_EXCEPTION_ERROR;
1581: END IF;
1582: l_return_status := populate_new_record(l_ctiv_rec, l_def_ctiv_rec);
1583: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1586: RAISE OKC_API.G_EXCEPTION_ERROR;
1587: END IF;
1588: l_def_ctiv_rec := fill_who_columns(l_def_ctiv_rec);

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

1581: END IF;
1582: l_return_status := populate_new_record(l_ctiv_rec, l_def_ctiv_rec);
1583: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1586: RAISE OKC_API.G_EXCEPTION_ERROR;
1587: END IF;
1588: l_def_ctiv_rec := fill_who_columns(l_def_ctiv_rec);
1589: --- Validate all non-missing attributes (Item Level Validation)

Line 1586: RAISE OKC_API.G_EXCEPTION_ERROR;

1582: l_return_status := populate_new_record(l_ctiv_rec, l_def_ctiv_rec);
1583: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1586: RAISE OKC_API.G_EXCEPTION_ERROR;
1587: END IF;
1588: l_def_ctiv_rec := fill_who_columns(l_def_ctiv_rec);
1589: --- Validate all non-missing attributes (Item Level Validation)
1590: l_return_status := Validate_Attributes(l_def_ctiv_rec);

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

1588: l_def_ctiv_rec := fill_who_columns(l_def_ctiv_rec);
1589: --- Validate all non-missing attributes (Item Level Validation)
1590: l_return_status := Validate_Attributes(l_def_ctiv_rec);
1591: --- If any errors happen abort API
1592: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1594: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1595: RAISE OKC_API.G_EXCEPTION_ERROR;
1596: END IF;

Line 1593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1589: --- Validate all non-missing attributes (Item Level Validation)
1590: l_return_status := Validate_Attributes(l_def_ctiv_rec);
1591: --- If any errors happen abort API
1592: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1594: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1595: RAISE OKC_API.G_EXCEPTION_ERROR;
1596: END IF;
1597: l_return_status := Validate_Record(l_def_ctiv_rec);

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

1590: l_return_status := Validate_Attributes(l_def_ctiv_rec);
1591: --- If any errors happen abort API
1592: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1594: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1595: RAISE OKC_API.G_EXCEPTION_ERROR;
1596: END IF;
1597: l_return_status := Validate_Record(l_def_ctiv_rec);
1598: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1595: RAISE OKC_API.G_EXCEPTION_ERROR;

1591: --- If any errors happen abort API
1592: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1594: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1595: RAISE OKC_API.G_EXCEPTION_ERROR;
1596: END IF;
1597: l_return_status := Validate_Record(l_def_ctiv_rec);
1598: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1599: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1594: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1595: RAISE OKC_API.G_EXCEPTION_ERROR;
1596: END IF;
1597: l_return_status := Validate_Record(l_def_ctiv_rec);
1598: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1599: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1600: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1601: RAISE OKC_API.G_EXCEPTION_ERROR;
1602: END IF;

Line 1599: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1595: RAISE OKC_API.G_EXCEPTION_ERROR;
1596: END IF;
1597: l_return_status := Validate_Record(l_def_ctiv_rec);
1598: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1599: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1600: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1601: RAISE OKC_API.G_EXCEPTION_ERROR;
1602: END IF;
1603:

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

1596: END IF;
1597: l_return_status := Validate_Record(l_def_ctiv_rec);
1598: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1599: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1600: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1601: RAISE OKC_API.G_EXCEPTION_ERROR;
1602: END IF;
1603:
1604: --------------------------------------

Line 1601: RAISE OKC_API.G_EXCEPTION_ERROR;

1597: l_return_status := Validate_Record(l_def_ctiv_rec);
1598: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1599: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1600: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1601: RAISE OKC_API.G_EXCEPTION_ERROR;
1602: END IF;
1603:
1604: --------------------------------------
1605: -- Move VIEW record to "Child" records

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

1615: x_msg_data,
1616: l_cti_rec,
1617: lx_cti_rec
1618: );
1619: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1620: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1621: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1622: RAISE OKC_API.G_EXCEPTION_ERROR;
1623: END IF;

Line 1620: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1616: l_cti_rec,
1617: lx_cti_rec
1618: );
1619: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1620: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1621: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1622: RAISE OKC_API.G_EXCEPTION_ERROR;
1623: END IF;
1624: migrate(lx_cti_rec, l_def_ctiv_rec);

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

1617: lx_cti_rec
1618: );
1619: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1620: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1621: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1622: RAISE OKC_API.G_EXCEPTION_ERROR;
1623: END IF;
1624: migrate(lx_cti_rec, l_def_ctiv_rec);
1625: x_ctiv_rec := l_def_ctiv_rec;

Line 1622: RAISE OKC_API.G_EXCEPTION_ERROR;

1618: );
1619: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1620: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1621: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1622: RAISE OKC_API.G_EXCEPTION_ERROR;
1623: END IF;
1624: migrate(lx_cti_rec, l_def_ctiv_rec);
1625: x_ctiv_rec := l_def_ctiv_rec;
1626: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1622: RAISE OKC_API.G_EXCEPTION_ERROR;
1623: END IF;
1624: migrate(lx_cti_rec, l_def_ctiv_rec);
1625: x_ctiv_rec := l_def_ctiv_rec;
1626: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1627: EXCEPTION
1628: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1629: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1630: (

Line 1628: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1624: migrate(lx_cti_rec, l_def_ctiv_rec);
1625: x_ctiv_rec := l_def_ctiv_rec;
1626: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1627: EXCEPTION
1628: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1629: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1630: (
1631: l_api_name,
1632: G_PKG_NAME,

Line 1629: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1625: x_ctiv_rec := l_def_ctiv_rec;
1626: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1627: EXCEPTION
1628: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1629: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1630: (
1631: l_api_name,
1632: G_PKG_NAME,
1633: 'OKC_API.G_RET_STS_ERROR',

Line 1633: 'OKC_API.G_RET_STS_ERROR',

1629: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1630: (
1631: l_api_name,
1632: G_PKG_NAME,
1633: 'OKC_API.G_RET_STS_ERROR',
1634: x_msg_count,
1635: x_msg_data,
1636: '_PVT'
1637: );

Line 1638: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1634: x_msg_count,
1635: x_msg_data,
1636: '_PVT'
1637: );
1638: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1639: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1640: (
1641: l_api_name,
1642: G_PKG_NAME,

Line 1639: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1635: x_msg_data,
1636: '_PVT'
1637: );
1638: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1639: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1640: (
1641: l_api_name,
1642: G_PKG_NAME,
1643: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1643: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1639: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1640: (
1641: l_api_name,
1642: G_PKG_NAME,
1643: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1644: x_msg_count,
1645: x_msg_data,
1646: '_PVT'
1647: );

Line 1649: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1645: x_msg_data,
1646: '_PVT'
1647: );
1648: WHEN OTHERS THEN
1649: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1650: (
1651: l_api_name,
1652: G_PKG_NAME,
1653: 'OTHERS',

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

1669: x_ctiv_tbl OUT NOCOPY ctiv_tbl_type) IS
1670:
1671: l_api_version CONSTANT NUMBER := 1;
1672: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1673: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1674: i NUMBER := 0;
1675: BEGIN
1676: OKC_API.init_msg_list(p_init_msg_list);
1677: -- Make sure PL/SQL table has records in it before passing

Line 1676: OKC_API.init_msg_list(p_init_msg_list);

1672: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1673: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1674: i NUMBER := 0;
1675: BEGIN
1676: OKC_API.init_msg_list(p_init_msg_list);
1677: -- Make sure PL/SQL table has records in it before passing
1678: IF (p_ctiv_tbl.COUNT > 0) THEN
1679: i := p_ctiv_tbl.FIRST;
1680: LOOP

Line 1683: p_init_msg_list => OKC_API.G_FALSE,

1679: i := p_ctiv_tbl.FIRST;
1680: LOOP
1681: update_row (
1682: p_api_version => p_api_version,
1683: p_init_msg_list => OKC_API.G_FALSE,
1684: x_return_status => x_return_status,
1685: x_msg_count => x_msg_count,
1686: x_msg_data => x_msg_data,
1687: p_ctiv_rec => p_ctiv_tbl(i),

Line 1694: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1690: i := p_ctiv_tbl.NEXT(i);
1691: END LOOP;
1692: END IF;
1693: EXCEPTION
1694: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1695: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1696: (
1697: l_api_name,
1698: G_PKG_NAME,

Line 1695: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1691: END LOOP;
1692: END IF;
1693: EXCEPTION
1694: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1695: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1696: (
1697: l_api_name,
1698: G_PKG_NAME,
1699: 'OKC_API.G_RET_STS_ERROR',

Line 1699: 'OKC_API.G_RET_STS_ERROR',

1695: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1696: (
1697: l_api_name,
1698: G_PKG_NAME,
1699: 'OKC_API.G_RET_STS_ERROR',
1700: x_msg_count,
1701: x_msg_data,
1702: '_PVT'
1703: );

Line 1704: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1700: x_msg_count,
1701: x_msg_data,
1702: '_PVT'
1703: );
1704: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1705: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1706: (
1707: l_api_name,
1708: G_PKG_NAME,

Line 1705: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1701: x_msg_data,
1702: '_PVT'
1703: );
1704: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1705: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1706: (
1707: l_api_name,
1708: G_PKG_NAME,
1709: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1709: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1705: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1706: (
1707: l_api_name,
1708: G_PKG_NAME,
1709: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1710: x_msg_count,
1711: x_msg_data,
1712: '_PVT'
1713: );

Line 1715: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1711: x_msg_data,
1712: '_PVT'
1713: );
1714: WHEN OTHERS THEN
1715: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1716: (
1717: l_api_name,
1718: G_PKG_NAME,
1719: 'OTHERS',

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

1737: p_cti_rec IN cti_rec_type) IS
1738:
1739: l_api_version CONSTANT NUMBER := 1;
1740: l_api_name CONSTANT VARCHAR2(30) := 'TIMES_delete_row';
1741: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1742: l_cti_rec cti_rec_type:= p_cti_rec;
1743: l_row_notfound BOOLEAN := TRUE;
1744: BEGIN
1745: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

1741: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1742: l_cti_rec cti_rec_type:= p_cti_rec;
1743: l_row_notfound BOOLEAN := TRUE;
1744: BEGIN
1745: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1746: p_init_msg_list,
1747: '_PVT',
1748: x_return_status);
1749: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1745: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1746: p_init_msg_list,
1747: '_PVT',
1748: x_return_status);
1749: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1750: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1751: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1752: RAISE OKC_API.G_EXCEPTION_ERROR;
1753: END IF;

Line 1750: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1746: p_init_msg_list,
1747: '_PVT',
1748: x_return_status);
1749: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1750: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1751: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1752: RAISE OKC_API.G_EXCEPTION_ERROR;
1753: END IF;
1754:

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

1747: '_PVT',
1748: x_return_status);
1749: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1750: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1751: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1752: RAISE OKC_API.G_EXCEPTION_ERROR;
1753: END IF;
1754:
1755: -- Bug#3080839 fix to delete time values associated

Line 1752: RAISE OKC_API.G_EXCEPTION_ERROR;

1748: x_return_status);
1749: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1750: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1751: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1752: RAISE OKC_API.G_EXCEPTION_ERROR;
1753: END IF;
1754:
1755: -- Bug#3080839 fix to delete time values associated
1756: -- with coverage times at line level.

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

1762: x_msg_count => x_msg_count,
1763: x_msg_data => x_msg_data,
1764: p_tve_id => l_cti_rec.tve_id);
1765:
1766: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1767: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1768: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1769: RAISE OKC_API.G_EXCEPTION_ERROR;
1770: END IF;

Line 1767: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1763: x_msg_data => x_msg_data,
1764: p_tve_id => l_cti_rec.tve_id);
1765:
1766: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1767: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1768: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1769: RAISE OKC_API.G_EXCEPTION_ERROR;
1770: END IF;
1771: END IF;

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

1764: p_tve_id => l_cti_rec.tve_id);
1765:
1766: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1767: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1768: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1769: RAISE OKC_API.G_EXCEPTION_ERROR;
1770: END IF;
1771: END IF;
1772:

Line 1769: RAISE OKC_API.G_EXCEPTION_ERROR;

1765:
1766: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1767: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1768: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1769: RAISE OKC_API.G_EXCEPTION_ERROR;
1770: END IF;
1771: END IF;
1772:
1773:

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

1774: -- delete cover times
1775: DELETE FROM OKC_COVER_TIMES
1776: WHERE RUL_ID = l_cti_rec.rul_id AND TVE_ID = l_cti_rec.tve_id;
1777:
1778: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1779: EXCEPTION
1780: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1781: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1782: (

Line 1780: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1776: WHERE RUL_ID = l_cti_rec.rul_id AND TVE_ID = l_cti_rec.tve_id;
1777:
1778: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1779: EXCEPTION
1780: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1781: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1782: (
1783: l_api_name,
1784: G_PKG_NAME,

Line 1781: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1777:
1778: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1779: EXCEPTION
1780: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1781: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1782: (
1783: l_api_name,
1784: G_PKG_NAME,
1785: 'OKC_API.G_RET_STS_ERROR',

Line 1785: 'OKC_API.G_RET_STS_ERROR',

1781: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1782: (
1783: l_api_name,
1784: G_PKG_NAME,
1785: 'OKC_API.G_RET_STS_ERROR',
1786: x_msg_count,
1787: x_msg_data,
1788: '_PVT'
1789: );

Line 1790: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1786: x_msg_count,
1787: x_msg_data,
1788: '_PVT'
1789: );
1790: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1791: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1792: (
1793: l_api_name,
1794: G_PKG_NAME,

Line 1791: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1787: x_msg_data,
1788: '_PVT'
1789: );
1790: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1791: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1792: (
1793: l_api_name,
1794: G_PKG_NAME,
1795: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1795: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1791: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1792: (
1793: l_api_name,
1794: G_PKG_NAME,
1795: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1796: x_msg_count,
1797: x_msg_data,
1798: '_PVT'
1799: );

Line 1801: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1797: x_msg_data,
1798: '_PVT'
1799: );
1800: WHEN OTHERS THEN
1801: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1802: (
1803: l_api_name,
1804: G_PKG_NAME,
1805: 'OTHERS',

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

1820: p_ctiv_rec IN ctiv_rec_type) IS
1821:
1822: l_api_version CONSTANT NUMBER := 1;
1823: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
1824: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1825: l_ctiv_rec ctiv_rec_type := p_ctiv_rec;
1826: l_cti_rec cti_rec_type;
1827: BEGIN
1828: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

1824: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1825: l_ctiv_rec ctiv_rec_type := p_ctiv_rec;
1826: l_cti_rec cti_rec_type;
1827: BEGIN
1828: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1829: G_PKG_NAME,
1830: p_init_msg_list,
1831: l_api_version,
1832: p_api_version,

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

1831: l_api_version,
1832: p_api_version,
1833: '_PVT',
1834: x_return_status);
1835: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1837: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1838: RAISE OKC_API.G_EXCEPTION_ERROR;
1839: END IF;

Line 1836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1832: p_api_version,
1833: '_PVT',
1834: x_return_status);
1835: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1837: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1838: RAISE OKC_API.G_EXCEPTION_ERROR;
1839: END IF;
1840: --------------------------------------

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

1833: '_PVT',
1834: x_return_status);
1835: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1837: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1838: RAISE OKC_API.G_EXCEPTION_ERROR;
1839: END IF;
1840: --------------------------------------
1841: -- Move VIEW record to "Child" records

Line 1838: RAISE OKC_API.G_EXCEPTION_ERROR;

1834: x_return_status);
1835: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1837: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1838: RAISE OKC_API.G_EXCEPTION_ERROR;
1839: END IF;
1840: --------------------------------------
1841: -- Move VIEW record to "Child" records
1842: --------------------------------------

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

1850: x_msg_count,
1851: x_msg_data,
1852: l_cti_rec
1853: );
1854: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1856: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1857: RAISE OKC_API.G_EXCEPTION_ERROR;
1858: END IF;

Line 1855: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1851: x_msg_data,
1852: l_cti_rec
1853: );
1854: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1856: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1857: RAISE OKC_API.G_EXCEPTION_ERROR;
1858: END IF;
1859: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1852: l_cti_rec
1853: );
1854: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1856: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1857: RAISE OKC_API.G_EXCEPTION_ERROR;
1858: END IF;
1859: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1860: EXCEPTION

Line 1857: RAISE OKC_API.G_EXCEPTION_ERROR;

1853: );
1854: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1856: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1857: RAISE OKC_API.G_EXCEPTION_ERROR;
1858: END IF;
1859: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1860: EXCEPTION
1861: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1855: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1856: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1857: RAISE OKC_API.G_EXCEPTION_ERROR;
1858: END IF;
1859: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1860: EXCEPTION
1861: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1862: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1863: (

Line 1861: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1857: RAISE OKC_API.G_EXCEPTION_ERROR;
1858: END IF;
1859: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1860: EXCEPTION
1861: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1862: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1863: (
1864: l_api_name,
1865: G_PKG_NAME,

Line 1862: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1858: END IF;
1859: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1860: EXCEPTION
1861: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1862: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1863: (
1864: l_api_name,
1865: G_PKG_NAME,
1866: 'OKC_API.G_RET_STS_ERROR',

Line 1866: 'OKC_API.G_RET_STS_ERROR',

1862: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1863: (
1864: l_api_name,
1865: G_PKG_NAME,
1866: 'OKC_API.G_RET_STS_ERROR',
1867: x_msg_count,
1868: x_msg_data,
1869: '_PVT'
1870: );

Line 1871: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1867: x_msg_count,
1868: x_msg_data,
1869: '_PVT'
1870: );
1871: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1872: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1873: (
1874: l_api_name,
1875: G_PKG_NAME,

Line 1872: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1868: x_msg_data,
1869: '_PVT'
1870: );
1871: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1872: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1873: (
1874: l_api_name,
1875: G_PKG_NAME,
1876: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1876: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1872: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1873: (
1874: l_api_name,
1875: G_PKG_NAME,
1876: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1877: x_msg_count,
1878: x_msg_data,
1879: '_PVT'
1880: );

Line 1882: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

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

1901: p_ctiv_tbl IN ctiv_tbl_type) IS
1902:
1903: l_api_version CONSTANT NUMBER := 1;
1904: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
1905: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1906: i NUMBER := 0;
1907: BEGIN
1908: OKC_API.init_msg_list(p_init_msg_list);
1909: -- Make sure PL/SQL table has records in it before passing

Line 1908: OKC_API.init_msg_list(p_init_msg_list);

1904: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
1905: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1906: i NUMBER := 0;
1907: BEGIN
1908: OKC_API.init_msg_list(p_init_msg_list);
1909: -- Make sure PL/SQL table has records in it before passing
1910: IF (p_ctiv_tbl.COUNT > 0) THEN
1911: i := p_ctiv_tbl.FIRST;
1912: LOOP

Line 1915: p_init_msg_list => OKC_API.G_FALSE,

1911: i := p_ctiv_tbl.FIRST;
1912: LOOP
1913: delete_row (
1914: p_api_version => p_api_version,
1915: p_init_msg_list => OKC_API.G_FALSE,
1916: x_return_status => x_return_status,
1917: x_msg_count => x_msg_count,
1918: x_msg_data => x_msg_data,
1919: p_ctiv_rec => p_ctiv_tbl(i));

Line 1925: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1921: i := p_ctiv_tbl.NEXT(i);
1922: END LOOP;
1923: END IF;
1924: EXCEPTION
1925: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1926: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1927: (
1928: l_api_name,
1929: G_PKG_NAME,

Line 1926: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1922: END LOOP;
1923: END IF;
1924: EXCEPTION
1925: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1926: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1927: (
1928: l_api_name,
1929: G_PKG_NAME,
1930: 'OKC_API.G_RET_STS_ERROR',

Line 1930: 'OKC_API.G_RET_STS_ERROR',

1926: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1927: (
1928: l_api_name,
1929: G_PKG_NAME,
1930: 'OKC_API.G_RET_STS_ERROR',
1931: x_msg_count,
1932: x_msg_data,
1933: '_PVT'
1934: );

Line 1935: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1931: x_msg_count,
1932: x_msg_data,
1933: '_PVT'
1934: );
1935: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1936: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1937: (
1938: l_api_name,
1939: G_PKG_NAME,

Line 1936: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1932: x_msg_data,
1933: '_PVT'
1934: );
1935: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1936: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1937: (
1938: l_api_name,
1939: G_PKG_NAME,
1940: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1940: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1936: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1937: (
1938: l_api_name,
1939: G_PKG_NAME,
1940: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1941: x_msg_count,
1942: x_msg_data,
1943: '_PVT'
1944: );

Line 1946: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1942: x_msg_data,
1943: '_PVT'
1944: );
1945: WHEN OTHERS THEN
1946: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1947: (
1948: l_api_name,
1949: G_PKG_NAME,
1950: 'OTHERS',

Line 1977: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1973: i number;
1974: j number;
1975: BEGIN
1976: --Initialize return status
1977: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1978:
1979: i := p_ctiv_tbl.FIRST; j:=0;
1980: while i is not null
1981: LOOP

Line 2026: OKC_API.SET_MESSAGE(

2022:
2023: EXCEPTION
2024: WHEN OTHERS THEN
2025: -- store SQL error message on message stack
2026: OKC_API.SET_MESSAGE(
2027: p_app_name => G_APP_NAME,
2028: p_msg_name => G_UNEXPECTED_ERROR,
2029: p_token1 => G_SQLCODE_TOKEN,
2030: p_token1_value => SQLCODE,

Line 2034: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2030: p_token1_value => SQLCODE,
2031: p_token2 => G_SQLERRM_TOKEN,
2032: p_token2_value => SQLERRM);
2033: -- notify caller of an error as UNEXPECTED error
2034: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2035:
2036: -- RAISE;
2037: END INSERT_ROW_UPG;
2038:

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

2044: p_chr_id IN NUMBER,
2045: p_major_version IN NUMBER
2046: ) RETURN VARCHAR2 IS
2047:
2048: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2049:
2050: BEGIN
2051: INSERT INTO okc_cover_times_h
2052: (

Line 2083: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

2079: EXCEPTION
2080: -- other appropriate handlers
2081: WHEN OTHERS THEN
2082: -- store SQL error message on message stack
2083: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2084: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2085: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2086: p_token1_value => sqlcode,
2087: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 2091: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2087: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2088: p_token2_value => sqlerrm);
2089:
2090: -- notify UNEXPECTED error
2091: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2092: return l_return_status;
2093: END create_version;
2094:
2095: --This Function is called from Versioning API OKC_VERSION_PVT

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

2100: p_chr_id IN NUMBER,
2101: p_major_version IN NUMBER
2102: ) RETURN VARCHAR2 IS
2103:
2104: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2105:
2106: BEGIN
2107: INSERT INTO okc_cover_times
2108: (

Line 2138: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

2134: EXCEPTION
2135: -- other appropriate handlers
2136: WHEN OTHERS THEN
2137: -- store SQL error message on message stack
2138: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2139: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2140: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2141: p_token1_value => sqlcode,
2142: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 2146: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2142: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2143: p_token2_value => sqlerrm);
2144:
2145: -- notify UNEXPECTED error
2146: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2147: return l_return_status;
2148: END restore_version;
2149: --
2150: END OKC_CTI_PVT;