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_OAT_PVT dependencies on OKC_API

Line 162: IF (l_oatv_rec.pdp_id = OKC_API.G_MISS_NUM) THEN

158: p_oatv_rec IN oatv_rec_type
159: ) RETURN oatv_rec_type IS
160: l_oatv_rec oatv_rec_type := p_oatv_rec;
161: BEGIN
162: IF (l_oatv_rec.pdp_id = OKC_API.G_MISS_NUM) THEN
163: l_oatv_rec.pdp_id := NULL;
164: END IF;
165: IF (l_oatv_rec.oce_id = OKC_API.G_MISS_NUM) THEN
166: l_oatv_rec.oce_id := NULL;

Line 165: IF (l_oatv_rec.oce_id = OKC_API.G_MISS_NUM) THEN

161: BEGIN
162: IF (l_oatv_rec.pdp_id = OKC_API.G_MISS_NUM) THEN
163: l_oatv_rec.pdp_id := NULL;
164: END IF;
165: IF (l_oatv_rec.oce_id = OKC_API.G_MISS_NUM) THEN
166: l_oatv_rec.oce_id := NULL;
167: END IF;
168: IF (l_oatv_rec.aae_id = OKC_API.G_MISS_NUM) THEN
169: l_oatv_rec.aae_id := NULL;

Line 168: IF (l_oatv_rec.aae_id = OKC_API.G_MISS_NUM) THEN

164: END IF;
165: IF (l_oatv_rec.oce_id = OKC_API.G_MISS_NUM) THEN
166: l_oatv_rec.oce_id := NULL;
167: END IF;
168: IF (l_oatv_rec.aae_id = OKC_API.G_MISS_NUM) THEN
169: l_oatv_rec.aae_id := NULL;
170: END IF;
171: IF (l_oatv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) THEN
172: l_oatv_rec.dnz_chr_id := NULL;

Line 171: IF (l_oatv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) THEN

167: END IF;
168: IF (l_oatv_rec.aae_id = OKC_API.G_MISS_NUM) THEN
169: l_oatv_rec.aae_id := NULL;
170: END IF;
171: IF (l_oatv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) THEN
172: l_oatv_rec.dnz_chr_id := NULL;
173: END IF;
174: IF (l_oatv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
175: l_oatv_rec.object_version_number := NULL;

Line 174: IF (l_oatv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

170: END IF;
171: IF (l_oatv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) THEN
172: l_oatv_rec.dnz_chr_id := NULL;
173: END IF;
174: IF (l_oatv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
175: l_oatv_rec.object_version_number := NULL;
176: END IF;
177: IF (l_oatv_rec.value = OKC_API.G_MISS_CHAR) THEN
178: l_oatv_rec.value := NULL;

Line 177: IF (l_oatv_rec.value = OKC_API.G_MISS_CHAR) THEN

173: END IF;
174: IF (l_oatv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
175: l_oatv_rec.object_version_number := NULL;
176: END IF;
177: IF (l_oatv_rec.value = OKC_API.G_MISS_CHAR) THEN
178: l_oatv_rec.value := NULL;
179: END IF;
180: IF (l_oatv_rec.application_id = OKC_API.G_MISS_NUM) THEN
181: l_oatv_rec.application_id := NULL;

Line 180: IF (l_oatv_rec.application_id = OKC_API.G_MISS_NUM) THEN

176: END IF;
177: IF (l_oatv_rec.value = OKC_API.G_MISS_CHAR) THEN
178: l_oatv_rec.value := NULL;
179: END IF;
180: IF (l_oatv_rec.application_id = OKC_API.G_MISS_NUM) THEN
181: l_oatv_rec.application_id := NULL;
182: END IF;
183: IF (l_oatv_rec.seeded_flag = OKC_API.G_MISS_CHAR) THEN
184: l_oatv_rec.seeded_flag := NULL;

Line 183: IF (l_oatv_rec.seeded_flag = OKC_API.G_MISS_CHAR) THEN

179: END IF;
180: IF (l_oatv_rec.application_id = OKC_API.G_MISS_NUM) THEN
181: l_oatv_rec.application_id := NULL;
182: END IF;
183: IF (l_oatv_rec.seeded_flag = OKC_API.G_MISS_CHAR) THEN
184: l_oatv_rec.seeded_flag := NULL;
185: END IF;
186: IF (l_oatv_rec.created_by = OKC_API.G_MISS_NUM) THEN
187: l_oatv_rec.created_by := NULL;

Line 186: IF (l_oatv_rec.created_by = OKC_API.G_MISS_NUM) THEN

182: END IF;
183: IF (l_oatv_rec.seeded_flag = OKC_API.G_MISS_CHAR) THEN
184: l_oatv_rec.seeded_flag := NULL;
185: END IF;
186: IF (l_oatv_rec.created_by = OKC_API.G_MISS_NUM) THEN
187: l_oatv_rec.created_by := NULL;
188: END IF;
189: IF (l_oatv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
190: l_oatv_rec.creation_date := NULL;

Line 189: IF (l_oatv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

185: END IF;
186: IF (l_oatv_rec.created_by = OKC_API.G_MISS_NUM) THEN
187: l_oatv_rec.created_by := NULL;
188: END IF;
189: IF (l_oatv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
190: l_oatv_rec.creation_date := NULL;
191: END IF;
192: IF (l_oatv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
193: l_oatv_rec.last_updated_by := NULL;

Line 192: IF (l_oatv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

188: END IF;
189: IF (l_oatv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
190: l_oatv_rec.creation_date := NULL;
191: END IF;
192: IF (l_oatv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
193: l_oatv_rec.last_updated_by := NULL;
194: END IF;
195: IF (l_oatv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
196: l_oatv_rec.last_update_date := NULL;

Line 195: IF (l_oatv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

191: END IF;
192: IF (l_oatv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
193: l_oatv_rec.last_updated_by := NULL;
194: END IF;
195: IF (l_oatv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
196: l_oatv_rec.last_update_date := NULL;
197: END IF;
198: IF (l_oatv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
199: l_oatv_rec.last_update_login := NULL;

Line 198: IF (l_oatv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

194: END IF;
195: IF (l_oatv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
196: l_oatv_rec.last_update_date := NULL;
197: END IF;
198: IF (l_oatv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
199: l_oatv_rec.last_update_login := NULL;
200: END IF;
201: RETURN(l_oatv_rec);
202: END null_out_defaults;

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

210: -----------------------------------------------------
211: FUNCTION Validate_Attributes (
212: p_oatv_rec IN oatv_rec_type
213: ) RETURN VARCHAR2 IS
214: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
215: BEGIN
216: IF p_oatv_rec.id = OKC_API.G_MISS_NUM OR
217: p_oatv_rec.id IS NULL
218: THEN

Line 216: IF p_oatv_rec.id = OKC_API.G_MISS_NUM OR

212: p_oatv_rec IN oatv_rec_type
213: ) RETURN VARCHAR2 IS
214: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
215: BEGIN
216: IF p_oatv_rec.id = OKC_API.G_MISS_NUM OR
217: p_oatv_rec.id IS NULL
218: THEN
219: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
220: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 219: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

215: BEGIN
216: IF p_oatv_rec.id = OKC_API.G_MISS_NUM OR
217: p_oatv_rec.id IS NULL
218: THEN
219: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
220: l_return_status := OKC_API.G_RET_STS_ERROR;
221: ELSIF p_oatv_rec.pdp_id = OKC_API.G_MISS_NUM OR
222: p_oatv_rec.pdp_id IS NULL
223: THEN

Line 220: l_return_status := OKC_API.G_RET_STS_ERROR;

216: IF p_oatv_rec.id = OKC_API.G_MISS_NUM OR
217: p_oatv_rec.id IS NULL
218: THEN
219: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
220: l_return_status := OKC_API.G_RET_STS_ERROR;
221: ELSIF p_oatv_rec.pdp_id = OKC_API.G_MISS_NUM OR
222: p_oatv_rec.pdp_id IS NULL
223: THEN
224: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pdp_id');

Line 221: ELSIF p_oatv_rec.pdp_id = OKC_API.G_MISS_NUM OR

217: p_oatv_rec.id IS NULL
218: THEN
219: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
220: l_return_status := OKC_API.G_RET_STS_ERROR;
221: ELSIF p_oatv_rec.pdp_id = OKC_API.G_MISS_NUM OR
222: p_oatv_rec.pdp_id IS NULL
223: THEN
224: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pdp_id');
225: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 224: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pdp_id');

220: l_return_status := OKC_API.G_RET_STS_ERROR;
221: ELSIF p_oatv_rec.pdp_id = OKC_API.G_MISS_NUM OR
222: p_oatv_rec.pdp_id IS NULL
223: THEN
224: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pdp_id');
225: l_return_status := OKC_API.G_RET_STS_ERROR;
226: ELSIF p_oatv_rec.oce_id = OKC_API.G_MISS_NUM OR
227: p_oatv_rec.oce_id IS NULL
228: THEN

Line 225: l_return_status := OKC_API.G_RET_STS_ERROR;

221: ELSIF p_oatv_rec.pdp_id = OKC_API.G_MISS_NUM OR
222: p_oatv_rec.pdp_id IS NULL
223: THEN
224: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pdp_id');
225: l_return_status := OKC_API.G_RET_STS_ERROR;
226: ELSIF p_oatv_rec.oce_id = OKC_API.G_MISS_NUM OR
227: p_oatv_rec.oce_id IS NULL
228: THEN
229: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'oce_id');

Line 226: ELSIF p_oatv_rec.oce_id = OKC_API.G_MISS_NUM OR

222: p_oatv_rec.pdp_id IS NULL
223: THEN
224: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pdp_id');
225: l_return_status := OKC_API.G_RET_STS_ERROR;
226: ELSIF p_oatv_rec.oce_id = OKC_API.G_MISS_NUM OR
227: p_oatv_rec.oce_id IS NULL
228: THEN
229: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'oce_id');
230: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 229: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'oce_id');

225: l_return_status := OKC_API.G_RET_STS_ERROR;
226: ELSIF p_oatv_rec.oce_id = OKC_API.G_MISS_NUM OR
227: p_oatv_rec.oce_id IS NULL
228: THEN
229: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'oce_id');
230: l_return_status := OKC_API.G_RET_STS_ERROR;
231: ELSIF p_oatv_rec.object_version_number = OKC_API.G_MISS_NUM OR
232: p_oatv_rec.object_version_number IS NULL
233: THEN

Line 230: l_return_status := OKC_API.G_RET_STS_ERROR;

226: ELSIF p_oatv_rec.oce_id = OKC_API.G_MISS_NUM OR
227: p_oatv_rec.oce_id IS NULL
228: THEN
229: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'oce_id');
230: l_return_status := OKC_API.G_RET_STS_ERROR;
231: ELSIF p_oatv_rec.object_version_number = OKC_API.G_MISS_NUM OR
232: p_oatv_rec.object_version_number IS NULL
233: THEN
234: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 231: ELSIF p_oatv_rec.object_version_number = OKC_API.G_MISS_NUM OR

227: p_oatv_rec.oce_id IS NULL
228: THEN
229: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'oce_id');
230: l_return_status := OKC_API.G_RET_STS_ERROR;
231: ELSIF p_oatv_rec.object_version_number = OKC_API.G_MISS_NUM OR
232: p_oatv_rec.object_version_number IS NULL
233: THEN
234: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
235: l_return_status := OKC_API.G_RET_STS_ERROR;

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

230: l_return_status := OKC_API.G_RET_STS_ERROR;
231: ELSIF p_oatv_rec.object_version_number = OKC_API.G_MISS_NUM OR
232: p_oatv_rec.object_version_number IS NULL
233: THEN
234: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
235: l_return_status := OKC_API.G_RET_STS_ERROR;
236: END IF;
237: RETURN(l_return_status);
238: END Validate_Attributes;

Line 235: l_return_status := OKC_API.G_RET_STS_ERROR;

231: ELSIF p_oatv_rec.object_version_number = OKC_API.G_MISS_NUM OR
232: p_oatv_rec.object_version_number IS NULL
233: THEN
234: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
235: l_return_status := OKC_API.G_RET_STS_ERROR;
236: END IF;
237: RETURN(l_return_status);
238: END Validate_Attributes;
239:

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

245: -------------------------------------------------
246: FUNCTION Validate_Record (
247: p_oatv_rec IN oatv_rec_type
248: ) RETURN VARCHAR2 IS
249: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
250: ------------------------------------
251: -- FUNCTION validate_foreign_keys --
252: ------------------------------------
253: FUNCTION validate_foreign_keys (

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

353: LAST_UPDATE_LOGIN
354: FROM Okc_Action_Attributes_V
355: WHERE okc_action_attributes_v.id = p_id;
356: l_okc_aaev_pk okc_aaev_pk_csr%ROWTYPE;
357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
358: l_row_notfound BOOLEAN := TRUE;
359: BEGIN
360: IF (p_oatv_rec.OCE_ID IS NOT NULL)
361: THEN

Line 367: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OCE_ID');

363: FETCH okc_ocev_pk_csr INTO l_okc_ocev_pk;
364: l_row_notfound := okc_ocev_pk_csr%NOTFOUND;
365: CLOSE okc_ocev_pk_csr;
366: IF (l_row_notfound) THEN
367: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OCE_ID');
368: RAISE item_not_found_error;
369: END IF;
370: END IF;
371: IF (p_oatv_rec.PDP_ID IS NOT NULL)

Line 378: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PDP_ID');

374: FETCH okc_pdpv_pk_csr INTO l_okc_pdpv_pk;
375: l_row_notfound := okc_pdpv_pk_csr%NOTFOUND;
376: CLOSE okc_pdpv_pk_csr;
377: IF (l_row_notfound) THEN
378: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PDP_ID');
379: RAISE item_not_found_error;
380: END IF;
381: END IF;
382: IF (p_oatv_rec.AAE_ID IS NOT NULL)

Line 389: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'AAE_ID');

385: FETCH okc_aaev_pk_csr INTO l_okc_aaev_pk;
386: l_row_notfound := okc_aaev_pk_csr%NOTFOUND;
387: CLOSE okc_aaev_pk_csr;
388: IF (l_row_notfound) THEN
389: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'AAE_ID');
390: RAISE item_not_found_error;
391: END IF;
392: END IF;
393: RETURN (l_return_status);

Line 396: l_return_status := OKC_API.G_RET_STS_ERROR;

392: END IF;
393: RETURN (l_return_status);
394: EXCEPTION
395: WHEN item_not_found_error THEN
396: l_return_status := OKC_API.G_RET_STS_ERROR;
397: RETURN (l_return_status);
398: END validate_foreign_keys;
399: BEGIN
400: l_return_status := validate_foreign_keys (p_oatv_rec);

Line 427: x_return_status := OKC_API.G_RET_STS_SUCCESS;

423: p_oatv_rec IN oatv_rec_type) IS
424:
425: BEGIN
426: -- initialize return status
427: x_return_status := OKC_API.G_RET_STS_SUCCESS;
428:
429: -- Check if object version number is null
430: IF p_oatv_rec.object_version_number = OKC_API.G_MISS_NUM OR
431: p_oatv_rec.object_version_number IS NULL THEN

Line 430: IF p_oatv_rec.object_version_number = OKC_API.G_MISS_NUM OR

426: -- initialize return status
427: x_return_status := OKC_API.G_RET_STS_SUCCESS;
428:
429: -- Check if object version number is null
430: IF p_oatv_rec.object_version_number = OKC_API.G_MISS_NUM OR
431: p_oatv_rec.object_version_number IS NULL THEN
432: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
433: p_msg_name => g_required_value,
434: p_token1 => g_col_name_token,

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

428:
429: -- Check if object version number is null
430: IF p_oatv_rec.object_version_number = OKC_API.G_MISS_NUM OR
431: p_oatv_rec.object_version_number IS NULL THEN
432: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
433: p_msg_name => g_required_value,
434: p_token1 => g_col_name_token,
435: p_token1_value => 'object_version_number');
436: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 436: x_return_status := OKC_API.G_RET_STS_ERROR;

432: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
433: p_msg_name => g_required_value,
434: p_token1 => g_col_name_token,
435: p_token1_value => 'object_version_number');
436: x_return_status := OKC_API.G_RET_STS_ERROR;
437: raise G_EXCEPTION_HALT_VALIDATION;
438: END IF;
439:
440: EXCEPTION

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

444: null;
445:
446: when OTHERS then
447: -- store SQL error message on message stack for caller
448: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
449: p_msg_name => g_unexpected_error,
450: p_token1 => g_sqlcode_token,
451: p_token1_value => sqlcode,
452: p_token2 => g_sqlerrm_token,

Line 455: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

451: p_token1_value => sqlcode,
452: p_token2 => g_sqlerrm_token,
453: p_token2_value => sqlerrm);
454: -- notify caller of an UNEXPECTED error
455: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
456:
457: END validate_object_version_number;
458:
459: -- Start of comments

Line 472: x_return_status := OKC_API.G_RET_STS_SUCCESS;

468: l_y VARCHAR2(1) := 'Y';
469: l_n VARCHAR2(1) := 'N';
470: BEGIN
471: -- initialize return status
472: x_return_status := OKC_API.G_RET_STS_SUCCESS;
473: -- Check if seeded_flag is Y or N
474: IF UPPER(p_oatv_rec.seeded_flag) NOT IN ('Y', 'N') THEN
475: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
476: p_msg_name => g_invalid_value,

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

471: -- initialize return status
472: x_return_status := OKC_API.G_RET_STS_SUCCESS;
473: -- Check if seeded_flag is Y or N
474: IF UPPER(p_oatv_rec.seeded_flag) NOT IN ('Y', 'N') THEN
475: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
476: p_msg_name => g_invalid_value,
477: p_token1 => g_col_name_token,
478: p_token1_value => 'seeded_flag');
479: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 479: x_return_status := OKC_API.G_RET_STS_ERROR;

475: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
476: p_msg_name => g_invalid_value,
477: p_token1 => g_col_name_token,
478: p_token1_value => 'seeded_flag');
479: x_return_status := OKC_API.G_RET_STS_ERROR;
480: raise G_EXCEPTION_HALT_VALIDATION;
481: END IF;
482:
483: --Check if the data is in upper case

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

481: END IF;
482:
483: --Check if the data is in upper case
484: IF p_oatv_rec.seeded_flag <> UPPER(p_oatv_rec.seeded_flag) THEN
485: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
486: p_msg_name => g_uppercase_required,
487: p_token1 => g_col_name_token,
488: p_token1_value => 'seeded_flag');
489: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 489: x_return_status := OKC_API.G_RET_STS_ERROR;

485: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
486: p_msg_name => g_uppercase_required,
487: p_token1 => g_col_name_token,
488: p_token1_value => 'seeded_flag');
489: x_return_status := OKC_API.G_RET_STS_ERROR;
490: raise G_EXCEPTION_HALT_VALIDATION;
491: END IF;
492: EXCEPTION
493: when G_EXCEPTION_HALT_VALIDATION then

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

496: null;
497:
498: when OTHERS then
499: -- store SQL error message on message stack for caller
500: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
501: p_msg_name => g_unexpected_error,
502: p_token1 => g_sqlcode_token,
503: p_token1_value => sqlcode,
504: p_token2 => g_sqlerrm_token,

Line 507: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

503: p_token1_value => sqlcode,
504: p_token2 => g_sqlerrm_token,
505: p_token2_value => sqlerrm);
506: -- notify caller of an UNEXPECTED error
507: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
508: END validate_seeded_flag;
509:
510: -- Start of comments
511: -- Procedure Name : validate_application_id

Line 526: x_return_status := OKC_API.G_RET_STS_SUCCESS;

522: where application_id = p_application_id;
523: l_dummy VARCHAR2(1) := '?';
524: BEGIN
525: -- initialize return status
526: x_return_status := OKC_API.G_RET_STS_SUCCESS;
527:
528: IF p_oatv_rec.application_id IS NOT NULL THEN
529: --Check if application id exists in the fnd_application or not
530: OPEN application_id_cur(p_oatv_rec.application_id);

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

530: OPEN application_id_cur(p_oatv_rec.application_id);
531: FETCH application_id_cur INTO l_dummy;
532: CLOSE application_id_cur ;
533: IF l_dummy = '?' THEN
534: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
535: p_msg_name => g_invalid_value,
536: p_token1 => g_col_name_token,
537: p_token1_value => 'application_id');
538: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 538: x_return_status := OKC_API.G_RET_STS_ERROR;

534: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
535: p_msg_name => g_invalid_value,
536: p_token1 => g_col_name_token,
537: p_token1_value => 'application_id');
538: x_return_status := OKC_API.G_RET_STS_ERROR;
539: raise G_EXCEPTION_HALT_VALIDATION;
540: END IF;
541: END IF;
542: EXCEPTION

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

546: null;
547:
548: when OTHERS then
549: -- store SQL error message on message stack for caller
550: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
551: p_msg_name => g_unexpected_error,
552: p_token1 => g_sqlcode_token,
553: p_token1_value => sqlcode,
554: p_token2 => g_sqlerrm_token,

Line 557: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

553: p_token1_value => sqlcode,
554: p_token2 => g_sqlerrm_token,
555: p_token2_value => sqlerrm);
556: -- notify caller of an UNEXPECTED error
557: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
558: END validate_application_id;
559:
560: -- Start of comments
561: -- Procedure Name : validate_pdp_id

Line 581: x_return_status := OKC_API.G_RET_STS_SUCCESS;

577:
578: l_dummy VARCHAR2(1) := '?';
579: BEGIN
580: -- initialize return status
581: x_return_status := OKC_API.G_RET_STS_SUCCESS;
582:
583: IF p_oatv_rec.pdp_id = OKC_API.G_MISS_NUM OR p_oatv_rec.pdp_id IS NULL THEN
584: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
585: p_msg_name => g_required_value,

Line 583: IF p_oatv_rec.pdp_id = OKC_API.G_MISS_NUM OR p_oatv_rec.pdp_id IS NULL THEN

579: BEGIN
580: -- initialize return status
581: x_return_status := OKC_API.G_RET_STS_SUCCESS;
582:
583: IF p_oatv_rec.pdp_id = OKC_API.G_MISS_NUM OR p_oatv_rec.pdp_id IS NULL THEN
584: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
585: p_msg_name => g_required_value,
586: p_token1 => g_col_name_token,
587: p_token1_value => 'pdp_id');

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

580: -- initialize return status
581: x_return_status := OKC_API.G_RET_STS_SUCCESS;
582:
583: IF p_oatv_rec.pdp_id = OKC_API.G_MISS_NUM OR p_oatv_rec.pdp_id IS NULL THEN
584: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
585: p_msg_name => g_required_value,
586: p_token1 => g_col_name_token,
587: p_token1_value => 'pdp_id');
588: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 588: x_return_status := OKC_API.G_RET_STS_ERROR;

584: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
585: p_msg_name => g_required_value,
586: p_token1 => g_col_name_token,
587: p_token1_value => 'pdp_id');
588: x_return_status := OKC_API.G_RET_STS_ERROR;
589: raise G_EXCEPTION_HALT_VALIDATION;
590: END IF;
591:
592: -- Enforce foreign key

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

595: CLOSE okc_pdpv_pk_csr;
596:
597: -- If l_dummy is still set to default, data was not found
598: IF (l_dummy = '?') THEN
599: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
600: p_msg_name => g_no_parent_record,
601: p_token1 => g_col_name_token,
602: p_token1_value => 'pdp_id',
603: p_token2 => g_child_table_token,

Line 607: x_return_status := OKC_API.G_RET_STS_ERROR;

603: p_token2 => g_child_table_token,
604: p_token2_value => 'OKC_PROCESS_DEF_PARAMETERS_V',
605: p_token3 => g_parent_table_token,
606: p_token3_value => 'OKC_OUTCOMES_V');
607: x_return_status := OKC_API.G_RET_STS_ERROR;
608: RAISE G_EXCEPTION_HALT_VALIDATION;
609: END IF;
610: EXCEPTION
611: when G_EXCEPTION_HALT_VALIDATION then

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

619: end if;
620:
621: when OTHERS then
622: -- store SQL error message on message stack for caller
623: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
624: p_msg_name => g_unexpected_error,
625: p_token1 => g_sqlcode_token,
626: p_token1_value => sqlcode,
627: p_token2 => g_sqlerrm_token,

Line 630: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

626: p_token1_value => sqlcode,
627: p_token2 => g_sqlerrm_token,
628: p_token2_value => sqlerrm);
629: -- notify caller of an UNEXPECTED error
630: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
631: END validate_pdp_id;
632:
633: -- Start of comments
634: -- Procedure Name : validate_oce_id

Line 653: x_return_status := OKC_API.G_RET_STS_SUCCESS;

649:
650: l_dummy VARCHAR2(1) := '?';
651: BEGIN
652: -- initialize return status
653: x_return_status := OKC_API.G_RET_STS_SUCCESS;
654:
655: -- Check if oce_id is null
656: IF p_oatv_rec.oce_id = OKC_API.G_MISS_NUM OR p_oatv_rec.oce_id IS NULL THEN
657: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 656: IF p_oatv_rec.oce_id = OKC_API.G_MISS_NUM OR p_oatv_rec.oce_id IS NULL THEN

652: -- initialize return status
653: x_return_status := OKC_API.G_RET_STS_SUCCESS;
654:
655: -- Check if oce_id is null
656: IF p_oatv_rec.oce_id = OKC_API.G_MISS_NUM OR p_oatv_rec.oce_id IS NULL THEN
657: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
658: p_msg_name => g_required_value,
659: p_token1 => g_col_name_token,
660: p_token1_value => 'oce_id');

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

653: x_return_status := OKC_API.G_RET_STS_SUCCESS;
654:
655: -- Check if oce_id is null
656: IF p_oatv_rec.oce_id = OKC_API.G_MISS_NUM OR p_oatv_rec.oce_id IS NULL THEN
657: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
658: p_msg_name => g_required_value,
659: p_token1 => g_col_name_token,
660: p_token1_value => 'oce_id');
661: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 661: x_return_status := OKC_API.G_RET_STS_ERROR;

657: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
658: p_msg_name => g_required_value,
659: p_token1 => g_col_name_token,
660: p_token1_value => 'oce_id');
661: x_return_status := OKC_API.G_RET_STS_ERROR;
662: raise G_EXCEPTION_HALT_VALIDATION;
663: END IF;
664:
665: -- Enforce foreign key

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

668: CLOSE okc_ocev_pk_csr;
669:
670: -- If l_dummy is still set to default, data was not found
671: IF (l_dummy = '?') THEN
672: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
673: p_msg_name => g_no_parent_record,
674: p_token1 => g_col_name_token,
675: p_token1_value => 'oce_id',
676: p_token2 => g_child_table_token,

Line 680: x_return_status := OKC_API.G_RET_STS_ERROR;

676: p_token2 => g_child_table_token,
677: p_token2_value => 'OKC_OUTCOME_ARGUMENTS_V',
678: p_token3 => g_parent_table_token,
679: p_token3_value => 'OKC_OUTCOMES_V');
680: x_return_status := OKC_API.G_RET_STS_ERROR;
681: RAISE G_EXCEPTION_HALT_VALIDATION;
682: END IF;
683: EXCEPTION
684: when G_EXCEPTION_HALT_VALIDATION then

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

692: end if;
693:
694: when OTHERS then
695: -- store SQL error message on message stack for caller
696: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
697: p_msg_name => g_unexpected_error,
698: p_token1 => g_sqlcode_token,
699: p_token1_value => sqlcode,
700: p_token2 => g_sqlerrm_token,

Line 703: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

699: p_token1_value => sqlcode,
700: p_token2 => g_sqlerrm_token,
701: p_token2_value => sqlerrm);
702: -- notify caller of an UNEXPECTED error
703: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
704: END validate_oce_id;
705:
706: -- Start of comments
707: -- Procedure Name : validate_aae_id

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

729: CLOSE okc_aaev_pk_csr;
730:
731: -- If l_dummy is still set to default, data was not found
732: IF (l_dummy = '?') THEN
733: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
734: p_msg_name => g_no_parent_record,
735: p_token1 => g_col_name_token,
736: p_token1_value => 'aae_id',
737: p_token2 => g_child_table_token,

Line 741: x_return_status := OKC_API.G_RET_STS_ERROR;

737: p_token2 => g_child_table_token,
738: p_token2_value => 'OKC_OUTCOME_ARGUMENTS_V',
739: p_token3 => g_parent_table_token,
740: p_token3_value => 'OKC_ACTION_ATTRIBUTES_V');
741: x_return_status := OKC_API.G_RET_STS_ERROR;
742: RAISE G_EXCEPTION_HALT_VALIDATION;
743: END IF;
744: END IF;
745: EXCEPTION

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

754: end if;
755:
756: when OTHERS then
757: -- store SQL error message on message stack for caller
758: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
759: p_msg_name => g_unexpected_error,
760: p_token1 => g_sqlcode_token,
761: p_token1_value => sqlcode,
762: p_token2 => g_sqlerrm_token,

Line 765: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

761: p_token1_value => sqlcode,
762: p_token2 => g_sqlerrm_token,
763: p_token2_value => sqlerrm);
764: -- notify caller of an UNEXPECTED error
765: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
766: END validate_aae_id;
767:
768: FUNCTION Validate_Attributes (
769: p_oatv_rec IN oatv_rec_type

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

768: FUNCTION Validate_Attributes (
769: p_oatv_rec IN oatv_rec_type
770: ) RETURN VARCHAR2 IS
771:
772: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
773: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
774:
775: BEGIN
776: validate_object_version_number(x_return_status => l_return_status

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

769: p_oatv_rec IN oatv_rec_type
770: ) RETURN VARCHAR2 IS
771:
772: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
773: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
774:
775: BEGIN
776: validate_object_version_number(x_return_status => l_return_status
777: ,p_oatv_rec => p_oatv_rec);

Line 779: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

775: BEGIN
776: validate_object_version_number(x_return_status => l_return_status
777: ,p_oatv_rec => p_oatv_rec);
778: -- store the highest degree of error
779: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
780: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
781: l_return_status := x_return_status;
782: RAISE G_EXCEPTION_HALT_VALIDATION;
783: ELSE

Line 780: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

776: validate_object_version_number(x_return_status => l_return_status
777: ,p_oatv_rec => p_oatv_rec);
778: -- store the highest degree of error
779: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
780: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
781: l_return_status := x_return_status;
782: RAISE G_EXCEPTION_HALT_VALIDATION;
783: ELSE
784: l_return_status := x_return_status; -- record that there was an error

Line 791: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

787:
788: validate_seeded_flag(x_return_status => l_return_status
789: ,p_oatv_rec => p_oatv_rec);
790: -- store the highest degree of error
791: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
792: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
793: l_return_status := x_return_status;
794: RAISE G_EXCEPTION_HALT_VALIDATION;
795: ELSE

Line 792: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

788: validate_seeded_flag(x_return_status => l_return_status
789: ,p_oatv_rec => p_oatv_rec);
790: -- store the highest degree of error
791: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
792: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
793: l_return_status := x_return_status;
794: RAISE G_EXCEPTION_HALT_VALIDATION;
795: ELSE
796: l_return_status := x_return_status; -- record that there was an error

Line 803: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

799:
800: validate_application_id(x_return_status => l_return_status
801: ,p_oatv_rec => p_oatv_rec);
802: -- store the highest degree of error
803: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
804: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
805: l_return_status := x_return_status;
806: RAISE G_EXCEPTION_HALT_VALIDATION;
807: ELSE

Line 804: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

800: validate_application_id(x_return_status => l_return_status
801: ,p_oatv_rec => p_oatv_rec);
802: -- store the highest degree of error
803: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
804: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
805: l_return_status := x_return_status;
806: RAISE G_EXCEPTION_HALT_VALIDATION;
807: ELSE
808: l_return_status := x_return_status; -- record that there was an error

Line 815: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

811:
812: validate_pdp_id(x_return_status => l_return_status
813: ,p_oatv_rec => p_oatv_rec);
814: -- store the highest degree of error
815: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
816: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
817: l_return_status := x_return_status;
818: RAISE G_EXCEPTION_HALT_VALIDATION;
819: ELSE

Line 816: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

812: validate_pdp_id(x_return_status => l_return_status
813: ,p_oatv_rec => p_oatv_rec);
814: -- store the highest degree of error
815: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
816: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
817: l_return_status := x_return_status;
818: RAISE G_EXCEPTION_HALT_VALIDATION;
819: ELSE
820: l_return_status := x_return_status; -- record that there was an error

Line 827: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

823:
824: validate_oce_id(x_return_status => l_return_status
825: ,p_oatv_rec => p_oatv_rec);
826: -- store the highest degree of error
827: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
828: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
829: l_return_status := x_return_status;
830: RAISE G_EXCEPTION_HALT_VALIDATION;
831: ELSE

Line 828: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

824: validate_oce_id(x_return_status => l_return_status
825: ,p_oatv_rec => p_oatv_rec);
826: -- store the highest degree of error
827: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
828: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
829: l_return_status := x_return_status;
830: RAISE G_EXCEPTION_HALT_VALIDATION;
831: ELSE
832: l_return_status := x_return_status; -- record that there was an error

Line 839: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

835:
836: validate_aae_id(x_return_status => l_return_status
837: ,p_oatv_rec => p_oatv_rec);
838: -- store the highest degree of error
839: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
840: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
841: l_return_status := x_return_status;
842: RAISE G_EXCEPTION_HALT_VALIDATION;
843: ELSE

Line 840: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

836: validate_aae_id(x_return_status => l_return_status
837: ,p_oatv_rec => p_oatv_rec);
838: -- store the highest degree of error
839: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
840: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
841: l_return_status := x_return_status;
842: RAISE G_EXCEPTION_HALT_VALIDATION;
843: ELSE
844: l_return_status := x_return_status; -- record that there was an error

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

852: RETURN(l_return_status);
853:
854: when OTHERS then
855: -- store SQL error message on message stack for caller
856: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
857: p_msg_name => g_unexpected_error,
858: p_token1 => g_sqlcode_token,
859: p_token1_value => sqlcode,
860: p_token2 => g_sqlerrm_token,

Line 863: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

859: p_token1_value => sqlcode,
860: p_token2 => g_sqlerrm_token,
861: p_token2_value => sqlerrm);
862: -- notify caller of an UNEXPECTED error
863: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
864: RETURN(l_return_status);
865: END Validate_Attributes;
866:
867: ---------------------------------------------------------------------------

Line 887: x_return_status := OKC_API.G_RET_STS_SUCCESS;

883: p_oatv_rec IN oatv_rec_type) IS
884:
885: BEGIN
886: -- initialize return status
887: x_return_status := OKC_API.G_RET_STS_SUCCESS;
888:
889: -- Check if aae_id or value has value
890: IF p_oatv_rec.aae_id is not null and p_oatv_rec.value is not null then
891: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

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

887: x_return_status := OKC_API.G_RET_STS_SUCCESS;
888:
889: -- Check if aae_id or value has value
890: IF p_oatv_rec.aae_id is not null and p_oatv_rec.value is not null then
891: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
892: p_msg_name => g_arc_violated,
893: p_token1 => g_col_name_token,
894: p_token1_value => 'aae_id',
895: p_token2 => g_col_name_token,

Line 897: x_return_status := OKC_API.G_RET_STS_ERROR;

893: p_token1 => g_col_name_token,
894: p_token1_value => 'aae_id',
895: p_token2 => g_col_name_token,
896: p_token2_value => 'value');
897: x_return_status := OKC_API.G_RET_STS_ERROR;
898: raise G_EXCEPTION_HALT_VALIDATION;
899: END IF;
900:
901: EXCEPTION

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

905: null;
906:
907: when OTHERS then
908: -- store SQL error message on message stack for caller
909: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
910: p_msg_name => g_unexpected_error,
911: p_token1 => g_sqlcode_token,
912: p_token1_value => sqlcode,
913: p_token2 => g_sqlerrm_token,

Line 916: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

912: p_token1_value => sqlcode,
913: p_token2 => g_sqlerrm_token,
914: p_token2_value => sqlerrm);
915: -- notify caller of an UNEXPECTED error
916: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
917: END validate_aaeid_value;
918:
919: -- Start of comments
920: -- Procedure Name : validate_aaeid_datatype

Line 946: x_return_status := OKC_API.G_RET_STS_SUCCESS;

942: v_pdp_data_type VARCHAR2(90);
943:
944: BEGIN
945: -- initialize return status
946: x_return_status := OKC_API.G_RET_STS_SUCCESS;
947:
948: -- Check if aae_id is of the right datatype
949: IF p_oatv_rec.aae_id is not null and p_oatv_rec.pdp_id is not null then
950: OPEN pdp_cur(p_oatv_rec.pdp_id);

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

955: FETCH aae_cur into v_aae_data_type;
956: CLOSE aae_cur;
957:
958: IF v_pdp_data_type <> v_aae_data_type THEN
959: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
960: p_msg_name => g_invalid_value,
961: p_token1 => g_col_name_token,
962: p_token1_value => 'aae_id',
963: p_token2 => g_col_name_token,

Line 965: x_return_status := OKC_API.G_RET_STS_ERROR;

961: p_token1 => g_col_name_token,
962: p_token1_value => 'aae_id',
963: p_token2 => g_col_name_token,
964: p_token2_value => 'pdp_id');
965: x_return_status := OKC_API.G_RET_STS_ERROR;
966: raise G_EXCEPTION_HALT_VALIDATION;
967: END IF;
968: END IF;
969:

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

974: null;
975:
976: when OTHERS then
977: -- store SQL error message on message stack for caller
978: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
979: p_msg_name => g_unexpected_error,
980: p_token1 => g_sqlcode_token,
981: p_token1_value => sqlcode,
982: p_token2 => g_sqlerrm_token,

Line 985: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

981: p_token1_value => sqlcode,
982: p_token2 => g_sqlerrm_token,
983: p_token2_value => sqlerrm);
984: -- notify caller of an UNEXPECTED error
985: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
986: END validate_aaeid_datatype;
987:
988: -- Start of comments
989: -- Procedure Name : validate if the value is of the proper datatype(C, N, D)

Line 1040: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1036: l_func_datatype BOOLEAN;
1037:
1038: BEGIN
1039: -- initialize return status
1040: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1041:
1042: -- Check if value is of the right datatype
1043: IF p_oatv_rec.value is not null and p_oatv_rec.pdp_id is not null then
1044: OPEN pdp_cur(p_oatv_rec.pdp_id);

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

1047:
1048: IF l_pdp_data_type = 'N' THEN
1049: l_func_datatype := val_num(p_oatv_rec.value);
1050: IF l_func_datatype = FALSE THEN
1051: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1052: p_msg_name => g_invalid_value,
1053: p_token1 => g_col_name_token,
1054: p_token1_value => 'value',
1055: p_token2 => g_col_name_token,

Line 1057: x_return_status := OKC_API.G_RET_STS_ERROR;

1053: p_token1 => g_col_name_token,
1054: p_token1_value => 'value',
1055: p_token2 => g_col_name_token,
1056: p_token2_value => 'pdp_id');
1057: x_return_status := OKC_API.G_RET_STS_ERROR;
1058: raise G_EXCEPTION_HALT_VALIDATION;
1059: END IF;
1060: END IF;
1061:

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

1061:
1062: IF l_pdp_data_type = 'C' THEN
1063: l_func_datatype := val_num(p_oatv_rec.value);
1064: IF l_func_datatype = TRUE THEN
1065: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1066: p_msg_name => g_invalid_value,
1067: p_token1 => g_col_name_token,
1068: p_token1_value => 'value',
1069: p_token2 => g_col_name_token,

Line 1071: x_return_status := OKC_API.G_RET_STS_ERROR;

1067: p_token1 => g_col_name_token,
1068: p_token1_value => 'value',
1069: p_token2 => g_col_name_token,
1070: p_token2_value => 'pdp_id');
1071: x_return_status := OKC_API.G_RET_STS_ERROR;
1072: raise G_EXCEPTION_HALT_VALIDATION;
1073: END IF;
1074: END IF;
1075:

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

1075:
1076: IF l_pdp_data_type = 'D' THEN
1077: l_func_datatype := val_date(p_oatv_rec.value);
1078: IF l_func_datatype = FALSE THEN
1079: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1080: p_msg_name => g_invalid_value,
1081: p_token1 => g_col_name_token,
1082: p_token1_value => 'value',
1083: p_token2 => g_col_name_token,

Line 1085: x_return_status := OKC_API.G_RET_STS_ERROR;

1081: p_token1 => g_col_name_token,
1082: p_token1_value => 'value',
1083: p_token2 => g_col_name_token,
1084: p_token2_value => 'pdp_id');
1085: x_return_status := OKC_API.G_RET_STS_ERROR;
1086: raise G_EXCEPTION_HALT_VALIDATION;
1087: END IF;
1088: END IF;
1089: END IF;

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

1095: null;
1096:
1097: when OTHERS then
1098: -- store SQL error message on message stack for caller
1099: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1100: p_msg_name => g_unexpected_error,
1101: p_token1 => g_sqlcode_token,
1102: p_token1_value => sqlcode,
1103: p_token2 => g_sqlerrm_token,

Line 1106: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1102: p_token1_value => sqlcode,
1103: p_token2 => g_sqlerrm_token,
1104: p_token2_value => sqlerrm);
1105: -- notify caller of an UNEXPECTED error
1106: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1107: END validate_value_datatype;
1108:
1109: FUNCTION Validate_Record (
1110: p_oatv_rec IN oatv_rec_type

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

1108:
1109: FUNCTION Validate_Record (
1110: p_oatv_rec IN oatv_rec_type
1111: ) RETURN VARCHAR2 IS
1112: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1113: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1114: BEGIN
1115: validate_aaeid_value(x_return_status => l_return_status
1116: ,p_oatv_rec => p_oatv_rec);

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

1109: FUNCTION Validate_Record (
1110: p_oatv_rec IN oatv_rec_type
1111: ) RETURN VARCHAR2 IS
1112: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1113: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1114: BEGIN
1115: validate_aaeid_value(x_return_status => l_return_status
1116: ,p_oatv_rec => p_oatv_rec);
1117: -- store the highest degree of error

Line 1118: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1114: BEGIN
1115: validate_aaeid_value(x_return_status => l_return_status
1116: ,p_oatv_rec => p_oatv_rec);
1117: -- store the highest degree of error
1118: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1119: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
1120: l_return_status := x_return_status;
1121: RAISE G_EXCEPTION_HALT_VALIDATION;
1122: ELSE

Line 1119: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

1115: validate_aaeid_value(x_return_status => l_return_status
1116: ,p_oatv_rec => p_oatv_rec);
1117: -- store the highest degree of error
1118: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1119: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
1120: l_return_status := x_return_status;
1121: RAISE G_EXCEPTION_HALT_VALIDATION;
1122: ELSE
1123: l_return_status := x_return_status; -- record that there was an error

Line 1130: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1126:
1127: validate_aaeid_datatype(x_return_status => l_return_status
1128: ,p_oatv_rec => p_oatv_rec);
1129: -- store the highest degree of error
1130: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1131: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
1132: l_return_status := x_return_status;
1133: RAISE G_EXCEPTION_HALT_VALIDATION;
1134: ELSE

Line 1131: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

1127: validate_aaeid_datatype(x_return_status => l_return_status
1128: ,p_oatv_rec => p_oatv_rec);
1129: -- store the highest degree of error
1130: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1131: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
1132: l_return_status := x_return_status;
1133: RAISE G_EXCEPTION_HALT_VALIDATION;
1134: ELSE
1135: l_return_status := x_return_status; -- record that there was an error

Line 1142: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1138:
1139: validate_value_datatype(x_return_status => l_return_status
1140: ,p_oatv_rec => p_oatv_rec);
1141: -- store the highest degree of error
1142: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1143: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
1144: l_return_status := x_return_status;
1145: RAISE G_EXCEPTION_HALT_VALIDATION;
1146: ELSE

Line 1143: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

1139: validate_value_datatype(x_return_status => l_return_status
1140: ,p_oatv_rec => p_oatv_rec);
1141: -- store the highest degree of error
1142: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1143: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
1144: l_return_status := x_return_status;
1145: RAISE G_EXCEPTION_HALT_VALIDATION;
1146: ELSE
1147: l_return_status := x_return_status; -- record that there was an error

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

1155: RETURN(l_return_status);
1156:
1157: when OTHERS then
1158: -- store SQL error message on message stack for caller
1159: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1160: p_msg_name => g_unexpected_error,
1161: p_token1 => g_sqlcode_token,
1162: p_token1_value => sqlcode,
1163: p_token2 => g_sqlerrm_token,

Line 1167: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1163: p_token2 => g_sqlerrm_token,
1164: p_token2_value => sqlerrm);
1165:
1166: -- notify caller of an UNEXPECTED error
1167: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1168: RETURN(l_return_status);
1169: END Validate_Record;
1170:
1171:

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

1230: p_oatv_rec IN oatv_rec_type) IS
1231:
1232: l_api_version CONSTANT NUMBER := 1;
1233: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1234: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1235: l_oatv_rec oatv_rec_type := p_oatv_rec;
1236: l_oat_rec oat_rec_type;
1237: BEGIN
1238: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

1234: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1235: l_oatv_rec oatv_rec_type := p_oatv_rec;
1236: l_oat_rec oat_rec_type;
1237: BEGIN
1238: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1239: G_PKG_NAME,
1240: p_init_msg_list,
1241: l_api_version,
1242: p_api_version,

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

1241: l_api_version,
1242: p_api_version,
1243: '_PVT',
1244: x_return_status);
1245: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1246: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1247: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1248: RAISE OKC_API.G_EXCEPTION_ERROR;
1249: END IF;

Line 1246: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1242: p_api_version,
1243: '_PVT',
1244: x_return_status);
1245: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1246: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1247: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1248: RAISE OKC_API.G_EXCEPTION_ERROR;
1249: END IF;
1250: --- Validate all non-missing attributes (Item Level Validation)

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

1243: '_PVT',
1244: x_return_status);
1245: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1246: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1247: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1248: RAISE OKC_API.G_EXCEPTION_ERROR;
1249: END IF;
1250: --- Validate all non-missing attributes (Item Level Validation)
1251: l_return_status := Validate_Attributes(l_oatv_rec);

Line 1248: RAISE OKC_API.G_EXCEPTION_ERROR;

1244: x_return_status);
1245: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1246: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1247: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1248: RAISE OKC_API.G_EXCEPTION_ERROR;
1249: END IF;
1250: --- Validate all non-missing attributes (Item Level Validation)
1251: l_return_status := Validate_Attributes(l_oatv_rec);
1252: --- If any errors happen abort API

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

1249: END IF;
1250: --- Validate all non-missing attributes (Item Level Validation)
1251: l_return_status := Validate_Attributes(l_oatv_rec);
1252: --- If any errors happen abort API
1253: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1254: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1255: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1256: RAISE OKC_API.G_EXCEPTION_ERROR;
1257: END IF;

Line 1254: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1250: --- Validate all non-missing attributes (Item Level Validation)
1251: l_return_status := Validate_Attributes(l_oatv_rec);
1252: --- If any errors happen abort API
1253: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1254: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1255: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1256: RAISE OKC_API.G_EXCEPTION_ERROR;
1257: END IF;
1258: l_return_status := Validate_Record(l_oatv_rec);

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

1251: l_return_status := Validate_Attributes(l_oatv_rec);
1252: --- If any errors happen abort API
1253: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1254: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1255: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1256: RAISE OKC_API.G_EXCEPTION_ERROR;
1257: END IF;
1258: l_return_status := Validate_Record(l_oatv_rec);
1259: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1256: RAISE OKC_API.G_EXCEPTION_ERROR;

1252: --- If any errors happen abort API
1253: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1254: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1255: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1256: RAISE OKC_API.G_EXCEPTION_ERROR;
1257: END IF;
1258: l_return_status := Validate_Record(l_oatv_rec);
1259: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1260: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1255: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1256: RAISE OKC_API.G_EXCEPTION_ERROR;
1257: END IF;
1258: l_return_status := Validate_Record(l_oatv_rec);
1259: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1260: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1261: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1262: RAISE OKC_API.G_EXCEPTION_ERROR;
1263: END IF;

Line 1260: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1256: RAISE OKC_API.G_EXCEPTION_ERROR;
1257: END IF;
1258: l_return_status := Validate_Record(l_oatv_rec);
1259: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1260: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1261: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1262: RAISE OKC_API.G_EXCEPTION_ERROR;
1263: END IF;
1264: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1257: END IF;
1258: l_return_status := Validate_Record(l_oatv_rec);
1259: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1260: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1261: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1262: RAISE OKC_API.G_EXCEPTION_ERROR;
1263: END IF;
1264: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1265: EXCEPTION

Line 1262: RAISE OKC_API.G_EXCEPTION_ERROR;

1258: l_return_status := Validate_Record(l_oatv_rec);
1259: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1260: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1261: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1262: RAISE OKC_API.G_EXCEPTION_ERROR;
1263: END IF;
1264: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1265: EXCEPTION
1266: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1260: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1261: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1262: RAISE OKC_API.G_EXCEPTION_ERROR;
1263: END IF;
1264: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1265: EXCEPTION
1266: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1267: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1268: (

Line 1266: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1262: RAISE OKC_API.G_EXCEPTION_ERROR;
1263: END IF;
1264: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1265: EXCEPTION
1266: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1267: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1268: (
1269: l_api_name,
1270: G_PKG_NAME,

Line 1267: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1263: END IF;
1264: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1265: EXCEPTION
1266: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1267: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1268: (
1269: l_api_name,
1270: G_PKG_NAME,
1271: 'OKC_API.G_RET_STS_ERROR',

Line 1271: 'OKC_API.G_RET_STS_ERROR',

1267: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1268: (
1269: l_api_name,
1270: G_PKG_NAME,
1271: 'OKC_API.G_RET_STS_ERROR',
1272: x_msg_count,
1273: x_msg_data,
1274: '_PVT'
1275: );

Line 1276: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1277: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 1281: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1287: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

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

1306: p_oatv_tbl IN oatv_tbl_type) IS
1307:
1308: l_api_version CONSTANT NUMBER := 1;
1309: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1310: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1311: i NUMBER := 0;
1312: BEGIN
1313: OKC_API.init_msg_list(p_init_msg_list);
1314: -- Make sure PL/SQL table has records in it before passing

Line 1313: OKC_API.init_msg_list(p_init_msg_list);

1309: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1310: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1311: i NUMBER := 0;
1312: BEGIN
1313: OKC_API.init_msg_list(p_init_msg_list);
1314: -- Make sure PL/SQL table has records in it before passing
1315: IF (p_oatv_tbl.COUNT > 0) THEN
1316: i := p_oatv_tbl.FIRST;
1317: LOOP

Line 1320: p_init_msg_list => OKC_API.G_FALSE,

1316: i := p_oatv_tbl.FIRST;
1317: LOOP
1318: validate_row (
1319: p_api_version => p_api_version,
1320: p_init_msg_list => OKC_API.G_FALSE,
1321: x_return_status => x_return_status,
1322: x_msg_count => x_msg_count,
1323: x_msg_data => x_msg_data,
1324: p_oatv_rec => p_oatv_tbl(i));

Line 1330: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1326: i := p_oatv_tbl.NEXT(i);
1327: END LOOP;
1328: END IF;
1329: EXCEPTION
1330: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1331: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1332: (
1333: l_api_name,
1334: G_PKG_NAME,

Line 1331: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1327: END LOOP;
1328: END IF;
1329: EXCEPTION
1330: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1331: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1332: (
1333: l_api_name,
1334: G_PKG_NAME,
1335: 'OKC_API.G_RET_STS_ERROR',

Line 1335: 'OKC_API.G_RET_STS_ERROR',

1331: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1332: (
1333: l_api_name,
1334: G_PKG_NAME,
1335: 'OKC_API.G_RET_STS_ERROR',
1336: x_msg_count,
1337: x_msg_data,
1338: '_PVT'
1339: );

Line 1340: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1336: x_msg_count,
1337: x_msg_data,
1338: '_PVT'
1339: );
1340: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1341: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1342: (
1343: l_api_name,
1344: G_PKG_NAME,

Line 1341: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1337: x_msg_data,
1338: '_PVT'
1339: );
1340: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1341: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1342: (
1343: l_api_name,
1344: G_PKG_NAME,
1345: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1345: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1341: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1342: (
1343: l_api_name,
1344: G_PKG_NAME,
1345: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1346: x_msg_count,
1347: x_msg_data,
1348: '_PVT'
1349: );

Line 1351: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1347: x_msg_data,
1348: '_PVT'
1349: );
1350: WHEN OTHERS THEN
1351: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1352: (
1353: l_api_name,
1354: G_PKG_NAME,
1355: 'OTHERS',

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

1374: x_oat_rec OUT NOCOPY oat_rec_type) IS
1375:
1376: l_api_version CONSTANT NUMBER := 1;
1377: l_api_name CONSTANT VARCHAR2(30) := 'ARGUMENTS_insert_row';
1378: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1379: l_oat_rec oat_rec_type := p_oat_rec;
1380: l_def_oat_rec oat_rec_type;
1381: ----------------------------------------------
1382: -- Set_Attributes for:OKC_OUTCOME_ARGUMENTS --

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

1384: FUNCTION Set_Attributes (
1385: p_oat_rec IN oat_rec_type,
1386: x_oat_rec OUT NOCOPY oat_rec_type
1387: ) RETURN VARCHAR2 IS
1388: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1389: BEGIN
1390: x_oat_rec := p_oat_rec;
1391: RETURN(l_return_status);
1392: END Set_Attributes;

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

1390: x_oat_rec := p_oat_rec;
1391: RETURN(l_return_status);
1392: END Set_Attributes;
1393: BEGIN
1394: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1395: p_init_msg_list,
1396: '_PVT',
1397: x_return_status);
1398: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1394: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1395: p_init_msg_list,
1396: '_PVT',
1397: x_return_status);
1398: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_ERROR;
1402: END IF;

Line 1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1395: p_init_msg_list,
1396: '_PVT',
1397: x_return_status);
1398: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_ERROR;
1402: END IF;
1403: --- Setting item attributes

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

1396: '_PVT',
1397: x_return_status);
1398: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_ERROR;
1402: END IF;
1403: --- Setting item attributes
1404: l_return_status := Set_Attributes(

Line 1401: RAISE OKC_API.G_EXCEPTION_ERROR;

1397: x_return_status);
1398: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_ERROR;
1402: END IF;
1403: --- Setting item attributes
1404: l_return_status := Set_Attributes(
1405: p_oat_rec, -- IN

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

1404: l_return_status := Set_Attributes(
1405: p_oat_rec, -- IN
1406: l_oat_rec); -- OUT
1407: --- If any errors happen abort API
1408: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: END IF;

Line 1409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1405: p_oat_rec, -- IN
1406: l_oat_rec); -- OUT
1407: --- If any errors happen abort API
1408: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: END IF;
1413: INSERT INTO OKC_OUTCOME_ARGUMENTS(

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

1406: l_oat_rec); -- OUT
1407: --- If any errors happen abort API
1408: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: END IF;
1413: INSERT INTO OKC_OUTCOME_ARGUMENTS(
1414: id,

Line 1411: RAISE OKC_API.G_EXCEPTION_ERROR;

1407: --- If any errors happen abort API
1408: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: END IF;
1413: INSERT INTO OKC_OUTCOME_ARGUMENTS(
1414: id,
1415: oce_id,

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

1441: l_oat_rec.application_id,
1442: l_oat_rec.seeded_flag);
1443: -- Set OUT values
1444: x_oat_rec := l_oat_rec;
1445: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1446: EXCEPTION
1447: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1448: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1449: (

Line 1447: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1443: -- Set OUT values
1444: x_oat_rec := l_oat_rec;
1445: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1446: EXCEPTION
1447: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1448: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1449: (
1450: l_api_name,
1451: G_PKG_NAME,

Line 1448: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1444: x_oat_rec := l_oat_rec;
1445: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1446: EXCEPTION
1447: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1448: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1449: (
1450: l_api_name,
1451: G_PKG_NAME,
1452: 'OKC_API.G_RET_STS_ERROR',

Line 1452: 'OKC_API.G_RET_STS_ERROR',

1448: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1449: (
1450: l_api_name,
1451: G_PKG_NAME,
1452: 'OKC_API.G_RET_STS_ERROR',
1453: x_msg_count,
1454: x_msg_data,
1455: '_PVT'
1456: );

Line 1457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1453: x_msg_count,
1454: x_msg_data,
1455: '_PVT'
1456: );
1457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1458: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1459: (
1460: l_api_name,
1461: G_PKG_NAME,

Line 1458: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1454: x_msg_data,
1455: '_PVT'
1456: );
1457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1458: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1459: (
1460: l_api_name,
1461: G_PKG_NAME,
1462: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1462: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1458: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1459: (
1460: l_api_name,
1461: G_PKG_NAME,
1462: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1463: x_msg_count,
1464: x_msg_data,
1465: '_PVT'
1466: );

Line 1468: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1464: x_msg_data,
1465: '_PVT'
1466: );
1467: WHEN OTHERS THEN
1468: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1469: (
1470: l_api_name,
1471: G_PKG_NAME,
1472: 'OTHERS',

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

1489:
1490: l_id NUMBER ;
1491: l_api_version CONSTANT NUMBER := 1;
1492: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1494: l_oatv_rec oatv_rec_type;
1495: l_def_oatv_rec oatv_rec_type;
1496: l_oat_rec oat_rec_type;
1497: lx_oat_rec oat_rec_type;

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

1516: FUNCTION Set_Attributes (
1517: p_oatv_rec IN oatv_rec_type,
1518: x_oatv_rec OUT NOCOPY oatv_rec_type
1519: ) RETURN VARCHAR2 IS
1520: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1521: BEGIN
1522: x_oatv_rec := p_oatv_rec;
1523: x_oatv_rec.OBJECT_VERSION_NUMBER := 1;
1524: RETURN(l_return_status);

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

1523: x_oatv_rec.OBJECT_VERSION_NUMBER := 1;
1524: RETURN(l_return_status);
1525: END Set_Attributes;
1526: BEGIN
1527: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1528: G_PKG_NAME,
1529: p_init_msg_list,
1530: l_api_version,
1531: p_api_version,

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

1530: l_api_version,
1531: p_api_version,
1532: '_PVT',
1533: x_return_status);
1534: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1537: RAISE OKC_API.G_EXCEPTION_ERROR;
1538: END IF;

Line 1535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1531: p_api_version,
1532: '_PVT',
1533: x_return_status);
1534: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1537: RAISE OKC_API.G_EXCEPTION_ERROR;
1538: END IF;
1539: l_oatv_rec := null_out_defaults(p_oatv_rec);

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

1532: '_PVT',
1533: x_return_status);
1534: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1537: RAISE OKC_API.G_EXCEPTION_ERROR;
1538: END IF;
1539: l_oatv_rec := null_out_defaults(p_oatv_rec);
1540: -- Set primary key value

Line 1537: RAISE OKC_API.G_EXCEPTION_ERROR;

1533: x_return_status);
1534: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1537: RAISE OKC_API.G_EXCEPTION_ERROR;
1538: END IF;
1539: l_oatv_rec := null_out_defaults(p_oatv_rec);
1540: -- Set primary key value
1541: -- If outcome argument is created by seed then use sequence generated id

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

1553: l_return_status := Set_Attributes(
1554: l_oatv_rec, -- IN
1555: l_def_oatv_rec); -- OUT
1556: --- If any errors happen abort API
1557: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1558: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1559: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1560: RAISE OKC_API.G_EXCEPTION_ERROR;
1561: END IF;

Line 1558: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1554: l_oatv_rec, -- IN
1555: l_def_oatv_rec); -- OUT
1556: --- If any errors happen abort API
1557: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1558: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1559: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1560: RAISE OKC_API.G_EXCEPTION_ERROR;
1561: END IF;
1562: l_def_oatv_rec := fill_who_columns(l_def_oatv_rec);

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

1555: l_def_oatv_rec); -- OUT
1556: --- If any errors happen abort API
1557: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1558: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1559: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1560: RAISE OKC_API.G_EXCEPTION_ERROR;
1561: END IF;
1562: l_def_oatv_rec := fill_who_columns(l_def_oatv_rec);
1563: --- Validate all non-missing attributes (Item Level Validation)

Line 1560: RAISE OKC_API.G_EXCEPTION_ERROR;

1556: --- If any errors happen abort API
1557: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1558: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1559: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1560: RAISE OKC_API.G_EXCEPTION_ERROR;
1561: END IF;
1562: l_def_oatv_rec := fill_who_columns(l_def_oatv_rec);
1563: --- Validate all non-missing attributes (Item Level Validation)
1564: l_return_status := Validate_Attributes(l_def_oatv_rec);

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

1562: l_def_oatv_rec := fill_who_columns(l_def_oatv_rec);
1563: --- Validate all non-missing attributes (Item Level Validation)
1564: l_return_status := Validate_Attributes(l_def_oatv_rec);
1565: --- If any errors happen abort API
1566: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1568: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1569: RAISE OKC_API.G_EXCEPTION_ERROR;
1570: END IF;

Line 1567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1563: --- Validate all non-missing attributes (Item Level Validation)
1564: l_return_status := Validate_Attributes(l_def_oatv_rec);
1565: --- If any errors happen abort API
1566: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1568: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1569: RAISE OKC_API.G_EXCEPTION_ERROR;
1570: END IF;
1571: l_return_status := Validate_Record(l_def_oatv_rec);

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

1564: l_return_status := Validate_Attributes(l_def_oatv_rec);
1565: --- If any errors happen abort API
1566: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1568: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1569: RAISE OKC_API.G_EXCEPTION_ERROR;
1570: END IF;
1571: l_return_status := Validate_Record(l_def_oatv_rec);
1572: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1569: RAISE OKC_API.G_EXCEPTION_ERROR;

1565: --- If any errors happen abort API
1566: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1568: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1569: RAISE OKC_API.G_EXCEPTION_ERROR;
1570: END IF;
1571: l_return_status := Validate_Record(l_def_oatv_rec);
1572: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1573: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1568: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1569: RAISE OKC_API.G_EXCEPTION_ERROR;
1570: END IF;
1571: l_return_status := Validate_Record(l_def_oatv_rec);
1572: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1573: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1574: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1575: RAISE OKC_API.G_EXCEPTION_ERROR;
1576: END IF;

Line 1573: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1569: RAISE OKC_API.G_EXCEPTION_ERROR;
1570: END IF;
1571: l_return_status := Validate_Record(l_def_oatv_rec);
1572: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1573: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1574: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1575: RAISE OKC_API.G_EXCEPTION_ERROR;
1576: END IF;
1577: --------------------------------------

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

1570: END IF;
1571: l_return_status := Validate_Record(l_def_oatv_rec);
1572: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1573: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1574: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1575: RAISE OKC_API.G_EXCEPTION_ERROR;
1576: END IF;
1577: --------------------------------------
1578: -- Move VIEW record to "Child" records

Line 1575: RAISE OKC_API.G_EXCEPTION_ERROR;

1571: l_return_status := Validate_Record(l_def_oatv_rec);
1572: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1573: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1574: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1575: RAISE OKC_API.G_EXCEPTION_ERROR;
1576: END IF;
1577: --------------------------------------
1578: -- Move VIEW record to "Child" records
1579: --------------------------------------

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

1588: x_msg_data,
1589: l_oat_rec,
1590: lx_oat_rec
1591: );
1592: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1594: ELSIF (x_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: l_oat_rec,
1590: lx_oat_rec
1591: );
1592: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1594: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1595: RAISE OKC_API.G_EXCEPTION_ERROR;
1596: END IF;
1597: migrate(lx_oat_rec, l_def_oatv_rec);

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

1590: lx_oat_rec
1591: );
1592: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1594: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1595: RAISE OKC_API.G_EXCEPTION_ERROR;
1596: END IF;
1597: migrate(lx_oat_rec, l_def_oatv_rec);
1598: -- Set OUT values

Line 1595: RAISE OKC_API.G_EXCEPTION_ERROR;

1591: );
1592: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1594: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1595: RAISE OKC_API.G_EXCEPTION_ERROR;
1596: END IF;
1597: migrate(lx_oat_rec, l_def_oatv_rec);
1598: -- Set OUT values
1599: x_oatv_rec := l_def_oatv_rec;

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

1596: END IF;
1597: migrate(lx_oat_rec, l_def_oatv_rec);
1598: -- Set OUT values
1599: x_oatv_rec := l_def_oatv_rec;
1600: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1601: EXCEPTION
1602: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1603: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1604: (

Line 1602: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1598: -- Set OUT values
1599: x_oatv_rec := l_def_oatv_rec;
1600: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1601: EXCEPTION
1602: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1603: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1604: (
1605: l_api_name,
1606: G_PKG_NAME,

Line 1603: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1599: x_oatv_rec := l_def_oatv_rec;
1600: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1601: EXCEPTION
1602: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1603: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1604: (
1605: l_api_name,
1606: G_PKG_NAME,
1607: 'OKC_API.G_RET_STS_ERROR',

Line 1607: 'OKC_API.G_RET_STS_ERROR',

1603: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1604: (
1605: l_api_name,
1606: G_PKG_NAME,
1607: 'OKC_API.G_RET_STS_ERROR',
1608: x_msg_count,
1609: x_msg_data,
1610: '_PVT'
1611: );

Line 1612: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1608: x_msg_count,
1609: x_msg_data,
1610: '_PVT'
1611: );
1612: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1613: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1614: (
1615: l_api_name,
1616: G_PKG_NAME,

Line 1613: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1609: x_msg_data,
1610: '_PVT'
1611: );
1612: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1613: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1614: (
1615: l_api_name,
1616: G_PKG_NAME,
1617: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1617: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1613: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1614: (
1615: l_api_name,
1616: G_PKG_NAME,
1617: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1618: x_msg_count,
1619: x_msg_data,
1620: '_PVT'
1621: );

Line 1623: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1619: x_msg_data,
1620: '_PVT'
1621: );
1622: WHEN OTHERS THEN
1623: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1624: (
1625: l_api_name,
1626: G_PKG_NAME,
1627: 'OTHERS',

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

1643: x_oatv_tbl OUT NOCOPY oatv_tbl_type) IS
1644:
1645: l_api_version CONSTANT NUMBER := 1;
1646: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1647: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1648: i NUMBER := 0;
1649: BEGIN
1650: OKC_API.init_msg_list(p_init_msg_list);
1651: -- Make sure PL/SQL table has records in it before passing

Line 1650: OKC_API.init_msg_list(p_init_msg_list);

1646: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1647: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1648: i NUMBER := 0;
1649: BEGIN
1650: OKC_API.init_msg_list(p_init_msg_list);
1651: -- Make sure PL/SQL table has records in it before passing
1652: IF (p_oatv_tbl.COUNT > 0) THEN
1653: i := p_oatv_tbl.FIRST;
1654: LOOP

Line 1657: p_init_msg_list => OKC_API.G_FALSE,

1653: i := p_oatv_tbl.FIRST;
1654: LOOP
1655: insert_row (
1656: p_api_version => p_api_version,
1657: p_init_msg_list => OKC_API.G_FALSE,
1658: x_return_status => x_return_status,
1659: x_msg_count => x_msg_count,
1660: x_msg_data => x_msg_data,
1661: p_oatv_rec => p_oatv_tbl(i),

Line 1668: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1664: i := p_oatv_tbl.NEXT(i);
1665: END LOOP;
1666: END IF;
1667: EXCEPTION
1668: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1669: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1670: (
1671: l_api_name,
1672: G_PKG_NAME,

Line 1669: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1665: END LOOP;
1666: END IF;
1667: EXCEPTION
1668: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1669: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1670: (
1671: l_api_name,
1672: G_PKG_NAME,
1673: 'OKC_API.G_RET_STS_ERROR',

Line 1673: 'OKC_API.G_RET_STS_ERROR',

1669: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1670: (
1671: l_api_name,
1672: G_PKG_NAME,
1673: 'OKC_API.G_RET_STS_ERROR',
1674: x_msg_count,
1675: x_msg_data,
1676: '_PVT'
1677: );

Line 1678: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1674: x_msg_count,
1675: x_msg_data,
1676: '_PVT'
1677: );
1678: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1679: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1680: (
1681: l_api_name,
1682: G_PKG_NAME,

Line 1679: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1675: x_msg_data,
1676: '_PVT'
1677: );
1678: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1679: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1680: (
1681: l_api_name,
1682: G_PKG_NAME,
1683: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1683: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1679: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1680: (
1681: l_api_name,
1682: G_PKG_NAME,
1683: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1684: x_msg_count,
1685: x_msg_data,
1686: '_PVT'
1687: );

Line 1689: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1685: x_msg_data,
1686: '_PVT'
1687: );
1688: WHEN OTHERS THEN
1689: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1690: (
1691: l_api_name,
1692: G_PKG_NAME,
1693: 'OTHERS',

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

1724: FROM OKC_OUTCOME_ARGUMENTS
1725: WHERE ID = p_oat_rec.id;
1726: l_api_version CONSTANT NUMBER := 1;
1727: l_api_name CONSTANT VARCHAR2(30) := 'ARGUMENTS_lock_row';
1728: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1729: l_object_version_number OKC_OUTCOME_ARGUMENTS.OBJECT_VERSION_NUMBER%TYPE;
1730: lc_object_version_number OKC_OUTCOME_ARGUMENTS.OBJECT_VERSION_NUMBER%TYPE;
1731: l_row_notfound BOOLEAN := FALSE;
1732: lc_row_notfound BOOLEAN := FALSE;

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

1730: lc_object_version_number OKC_OUTCOME_ARGUMENTS.OBJECT_VERSION_NUMBER%TYPE;
1731: l_row_notfound BOOLEAN := FALSE;
1732: lc_row_notfound BOOLEAN := FALSE;
1733: BEGIN
1734: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1735: p_init_msg_list,
1736: '_PVT',
1737: x_return_status);
1738: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1734: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1735: p_init_msg_list,
1736: '_PVT',
1737: x_return_status);
1738: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1739: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1740: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1741: RAISE OKC_API.G_EXCEPTION_ERROR;
1742: END IF;

Line 1739: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1735: p_init_msg_list,
1736: '_PVT',
1737: x_return_status);
1738: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1739: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1740: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1741: RAISE OKC_API.G_EXCEPTION_ERROR;
1742: END IF;
1743: BEGIN

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

1736: '_PVT',
1737: x_return_status);
1738: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1739: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1740: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1741: RAISE OKC_API.G_EXCEPTION_ERROR;
1742: END IF;
1743: BEGIN
1744: OPEN lock_csr(p_oat_rec);

Line 1741: RAISE OKC_API.G_EXCEPTION_ERROR;

1737: x_return_status);
1738: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1739: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1740: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1741: RAISE OKC_API.G_EXCEPTION_ERROR;
1742: END IF;
1743: BEGIN
1744: OPEN lock_csr(p_oat_rec);
1745: FETCH lock_csr INTO l_object_version_number;

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

1749: WHEN E_Resource_Busy THEN
1750: IF (lock_csr%ISOPEN) THEN
1751: CLOSE lock_csr;
1752: END IF;
1753: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1754: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1755: END;
1756:
1757: IF ( l_row_notfound ) THEN

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

1760: lc_row_notfound := lchk_csr%NOTFOUND;
1761: CLOSE lchk_csr;
1762: END IF;
1763: IF (lc_row_notfound) THEN
1764: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1765: RAISE OKC_API.G_EXCEPTION_ERROR;
1766: ELSIF lc_object_version_number > p_oat_rec.object_version_number THEN
1767: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1768: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1765: RAISE OKC_API.G_EXCEPTION_ERROR;

1761: CLOSE lchk_csr;
1762: END IF;
1763: IF (lc_row_notfound) THEN
1764: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1765: RAISE OKC_API.G_EXCEPTION_ERROR;
1766: ELSIF lc_object_version_number > p_oat_rec.object_version_number THEN
1767: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1768: RAISE OKC_API.G_EXCEPTION_ERROR;
1769: ELSIF lc_object_version_number <> p_oat_rec.object_version_number THEN

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

1763: IF (lc_row_notfound) THEN
1764: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1765: RAISE OKC_API.G_EXCEPTION_ERROR;
1766: ELSIF lc_object_version_number > p_oat_rec.object_version_number THEN
1767: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1768: RAISE OKC_API.G_EXCEPTION_ERROR;
1769: ELSIF lc_object_version_number <> p_oat_rec.object_version_number THEN
1770: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1771: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1768: RAISE OKC_API.G_EXCEPTION_ERROR;

1764: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1765: RAISE OKC_API.G_EXCEPTION_ERROR;
1766: ELSIF lc_object_version_number > p_oat_rec.object_version_number THEN
1767: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1768: RAISE OKC_API.G_EXCEPTION_ERROR;
1769: ELSIF lc_object_version_number <> p_oat_rec.object_version_number THEN
1770: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1771: RAISE OKC_API.G_EXCEPTION_ERROR;
1772: ELSIF lc_object_version_number = -1 THEN

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

1766: ELSIF lc_object_version_number > p_oat_rec.object_version_number THEN
1767: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1768: RAISE OKC_API.G_EXCEPTION_ERROR;
1769: ELSIF lc_object_version_number <> p_oat_rec.object_version_number THEN
1770: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1771: RAISE OKC_API.G_EXCEPTION_ERROR;
1772: ELSIF lc_object_version_number = -1 THEN
1773: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1774: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1771: RAISE OKC_API.G_EXCEPTION_ERROR;

1767: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1768: RAISE OKC_API.G_EXCEPTION_ERROR;
1769: ELSIF lc_object_version_number <> p_oat_rec.object_version_number THEN
1770: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1771: RAISE OKC_API.G_EXCEPTION_ERROR;
1772: ELSIF lc_object_version_number = -1 THEN
1773: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1774: RAISE OKC_API.G_EXCEPTION_ERROR;
1775: END IF;

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

1769: ELSIF lc_object_version_number <> p_oat_rec.object_version_number THEN
1770: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1771: RAISE OKC_API.G_EXCEPTION_ERROR;
1772: ELSIF lc_object_version_number = -1 THEN
1773: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1774: RAISE OKC_API.G_EXCEPTION_ERROR;
1775: END IF;
1776: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1777: EXCEPTION

Line 1774: RAISE OKC_API.G_EXCEPTION_ERROR;

1770: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1771: RAISE OKC_API.G_EXCEPTION_ERROR;
1772: ELSIF lc_object_version_number = -1 THEN
1773: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1774: RAISE OKC_API.G_EXCEPTION_ERROR;
1775: END IF;
1776: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1777: EXCEPTION
1778: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1772: ELSIF lc_object_version_number = -1 THEN
1773: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1774: RAISE OKC_API.G_EXCEPTION_ERROR;
1775: END IF;
1776: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1777: EXCEPTION
1778: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1779: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1780: (

Line 1778: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1774: RAISE OKC_API.G_EXCEPTION_ERROR;
1775: END IF;
1776: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1777: EXCEPTION
1778: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1779: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1780: (
1781: l_api_name,
1782: G_PKG_NAME,

Line 1779: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1783: 'OKC_API.G_RET_STS_ERROR',

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

Line 1788: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1789: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 1793: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1799: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

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

1818: p_oatv_rec IN oatv_rec_type) IS
1819:
1820: l_api_version CONSTANT NUMBER := 1;
1821: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1822: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1823: l_oat_rec oat_rec_type;
1824: BEGIN
1825: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1826: G_PKG_NAME,

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

1821: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1822: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1823: l_oat_rec oat_rec_type;
1824: BEGIN
1825: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1826: G_PKG_NAME,
1827: p_init_msg_list,
1828: l_api_version,
1829: p_api_version,

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

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

Line 1833: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1835: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

1847: x_msg_count,
1848: x_msg_data,
1849: l_oat_rec
1850: );
1851: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1853: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1854: RAISE OKC_API.G_EXCEPTION_ERROR;
1855: END IF;

Line 1852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1848: x_msg_data,
1849: l_oat_rec
1850: );
1851: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1853: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1854: RAISE OKC_API.G_EXCEPTION_ERROR;
1855: END IF;
1856: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

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

Line 1854: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

Line 1858: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

Line 1859: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1863: 'OKC_API.G_RET_STS_ERROR',

1859: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1860: (
1861: l_api_name,
1862: G_PKG_NAME,
1863: 'OKC_API.G_RET_STS_ERROR',
1864: x_msg_count,
1865: x_msg_data,
1866: '_PVT'
1867: );

Line 1868: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1869: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 1873: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1879: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

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

1898: p_oatv_tbl IN oatv_tbl_type) IS
1899:
1900: l_api_version CONSTANT NUMBER := 1;
1901: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1902: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1903: i NUMBER := 0;
1904: BEGIN
1905: OKC_API.init_msg_list(p_init_msg_list);
1906: -- Make sure PL/SQL table has records in it before passing

Line 1905: OKC_API.init_msg_list(p_init_msg_list);

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

Line 1912: p_init_msg_list => OKC_API.G_FALSE,

1908: i := p_oatv_tbl.FIRST;
1909: LOOP
1910: lock_row (
1911: p_api_version => p_api_version,
1912: p_init_msg_list => OKC_API.G_FALSE,
1913: x_return_status => x_return_status,
1914: x_msg_count => x_msg_count,
1915: x_msg_data => x_msg_data,
1916: p_oatv_rec => p_oatv_tbl(i));

Line 1922: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1918: i := p_oatv_tbl.NEXT(i);
1919: END LOOP;
1920: END IF;
1921: EXCEPTION
1922: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1923: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1924: (
1925: l_api_name,
1926: G_PKG_NAME,

Line 1923: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1927: 'OKC_API.G_RET_STS_ERROR',

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

Line 1932: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1933: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 1937: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1943: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

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

1966: x_oat_rec OUT NOCOPY oat_rec_type) IS
1967:
1968: l_api_version CONSTANT NUMBER := 1;
1969: l_api_name CONSTANT VARCHAR2(30) := 'ARGUMENTS_update_row';
1970: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1971: l_oat_rec oat_rec_type := p_oat_rec;
1972: l_def_oat_rec oat_rec_type;
1973: l_row_notfound BOOLEAN := TRUE;
1974: ----------------------------------

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

1979: x_oat_rec OUT NOCOPY oat_rec_type
1980: ) RETURN VARCHAR2 IS
1981: l_oat_rec oat_rec_type;
1982: l_row_notfound BOOLEAN := TRUE;
1983: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1984: BEGIN
1985: x_oat_rec := p_oat_rec;
1986: -- Get current database values
1987: l_oat_rec := get_rec(p_oat_rec, l_row_notfound);

Line 1989: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1985: x_oat_rec := p_oat_rec;
1986: -- Get current database values
1987: l_oat_rec := get_rec(p_oat_rec, l_row_notfound);
1988: IF (l_row_notfound) THEN
1989: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1990: END IF;
1991: IF (x_oat_rec.id = OKC_API.G_MISS_NUM)
1992: THEN
1993: x_oat_rec.id := l_oat_rec.id;

Line 1991: IF (x_oat_rec.id = OKC_API.G_MISS_NUM)

1987: l_oat_rec := get_rec(p_oat_rec, l_row_notfound);
1988: IF (l_row_notfound) THEN
1989: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1990: END IF;
1991: IF (x_oat_rec.id = OKC_API.G_MISS_NUM)
1992: THEN
1993: x_oat_rec.id := l_oat_rec.id;
1994: END IF;
1995: IF (x_oat_rec.oce_id = OKC_API.G_MISS_NUM)

Line 1995: IF (x_oat_rec.oce_id = OKC_API.G_MISS_NUM)

1991: IF (x_oat_rec.id = OKC_API.G_MISS_NUM)
1992: THEN
1993: x_oat_rec.id := l_oat_rec.id;
1994: END IF;
1995: IF (x_oat_rec.oce_id = OKC_API.G_MISS_NUM)
1996: THEN
1997: x_oat_rec.oce_id := l_oat_rec.oce_id;
1998: END IF;
1999: IF (x_oat_rec.pdp_id = OKC_API.G_MISS_NUM)

Line 1999: IF (x_oat_rec.pdp_id = OKC_API.G_MISS_NUM)

1995: IF (x_oat_rec.oce_id = OKC_API.G_MISS_NUM)
1996: THEN
1997: x_oat_rec.oce_id := l_oat_rec.oce_id;
1998: END IF;
1999: IF (x_oat_rec.pdp_id = OKC_API.G_MISS_NUM)
2000: THEN
2001: x_oat_rec.pdp_id := l_oat_rec.pdp_id;
2002: END IF;
2003: IF (x_oat_rec.aae_id = OKC_API.G_MISS_NUM)

Line 2003: IF (x_oat_rec.aae_id = OKC_API.G_MISS_NUM)

1999: IF (x_oat_rec.pdp_id = OKC_API.G_MISS_NUM)
2000: THEN
2001: x_oat_rec.pdp_id := l_oat_rec.pdp_id;
2002: END IF;
2003: IF (x_oat_rec.aae_id = OKC_API.G_MISS_NUM)
2004: THEN
2005: x_oat_rec.aae_id := l_oat_rec.aae_id;
2006: END IF;
2007: IF (x_oat_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

Line 2007: IF (x_oat_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

2003: IF (x_oat_rec.aae_id = OKC_API.G_MISS_NUM)
2004: THEN
2005: x_oat_rec.aae_id := l_oat_rec.aae_id;
2006: END IF;
2007: IF (x_oat_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
2008: THEN
2009: x_oat_rec.dnz_chr_id := l_oat_rec.dnz_chr_id;
2010: END IF;
2011: IF (x_oat_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 2011: IF (x_oat_rec.object_version_number = OKC_API.G_MISS_NUM)

2007: IF (x_oat_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
2008: THEN
2009: x_oat_rec.dnz_chr_id := l_oat_rec.dnz_chr_id;
2010: END IF;
2011: IF (x_oat_rec.object_version_number = OKC_API.G_MISS_NUM)
2012: THEN
2013: x_oat_rec.object_version_number := l_oat_rec.object_version_number;
2014: END IF;
2015: IF (x_oat_rec.created_by = OKC_API.G_MISS_NUM)

Line 2015: IF (x_oat_rec.created_by = OKC_API.G_MISS_NUM)

2011: IF (x_oat_rec.object_version_number = OKC_API.G_MISS_NUM)
2012: THEN
2013: x_oat_rec.object_version_number := l_oat_rec.object_version_number;
2014: END IF;
2015: IF (x_oat_rec.created_by = OKC_API.G_MISS_NUM)
2016: THEN
2017: x_oat_rec.created_by := l_oat_rec.created_by;
2018: END IF;
2019: IF (x_oat_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2019: IF (x_oat_rec.creation_date = OKC_API.G_MISS_DATE)

2015: IF (x_oat_rec.created_by = OKC_API.G_MISS_NUM)
2016: THEN
2017: x_oat_rec.created_by := l_oat_rec.created_by;
2018: END IF;
2019: IF (x_oat_rec.creation_date = OKC_API.G_MISS_DATE)
2020: THEN
2021: x_oat_rec.creation_date := l_oat_rec.creation_date;
2022: END IF;
2023: IF (x_oat_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2023: IF (x_oat_rec.last_updated_by = OKC_API.G_MISS_NUM)

2019: IF (x_oat_rec.creation_date = OKC_API.G_MISS_DATE)
2020: THEN
2021: x_oat_rec.creation_date := l_oat_rec.creation_date;
2022: END IF;
2023: IF (x_oat_rec.last_updated_by = OKC_API.G_MISS_NUM)
2024: THEN
2025: x_oat_rec.last_updated_by := l_oat_rec.last_updated_by;
2026: END IF;
2027: IF (x_oat_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2027: IF (x_oat_rec.last_update_date = OKC_API.G_MISS_DATE)

2023: IF (x_oat_rec.last_updated_by = OKC_API.G_MISS_NUM)
2024: THEN
2025: x_oat_rec.last_updated_by := l_oat_rec.last_updated_by;
2026: END IF;
2027: IF (x_oat_rec.last_update_date = OKC_API.G_MISS_DATE)
2028: THEN
2029: x_oat_rec.last_update_date := l_oat_rec.last_update_date;
2030: END IF;
2031: IF (x_oat_rec.value = OKC_API.G_MISS_CHAR)

Line 2031: IF (x_oat_rec.value = OKC_API.G_MISS_CHAR)

2027: IF (x_oat_rec.last_update_date = OKC_API.G_MISS_DATE)
2028: THEN
2029: x_oat_rec.last_update_date := l_oat_rec.last_update_date;
2030: END IF;
2031: IF (x_oat_rec.value = OKC_API.G_MISS_CHAR)
2032: THEN
2033: x_oat_rec.value := l_oat_rec.value;
2034: END IF;
2035: IF (x_oat_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2035: IF (x_oat_rec.last_update_login = OKC_API.G_MISS_NUM)

2031: IF (x_oat_rec.value = OKC_API.G_MISS_CHAR)
2032: THEN
2033: x_oat_rec.value := l_oat_rec.value;
2034: END IF;
2035: IF (x_oat_rec.last_update_login = OKC_API.G_MISS_NUM)
2036: THEN
2037: x_oat_rec.last_update_login := l_oat_rec.last_update_login;
2038: END IF;
2039: IF (x_oat_rec.application_id = OKC_API.G_MISS_NUM)

Line 2039: IF (x_oat_rec.application_id = OKC_API.G_MISS_NUM)

2035: IF (x_oat_rec.last_update_login = OKC_API.G_MISS_NUM)
2036: THEN
2037: x_oat_rec.last_update_login := l_oat_rec.last_update_login;
2038: END IF;
2039: IF (x_oat_rec.application_id = OKC_API.G_MISS_NUM)
2040: THEN
2041: x_oat_rec.application_id := l_oat_rec.application_id;
2042: END IF;
2043: IF (x_oat_rec.seeded_flag = OKC_API.G_MISS_CHAR)

Line 2043: IF (x_oat_rec.seeded_flag = OKC_API.G_MISS_CHAR)

2039: IF (x_oat_rec.application_id = OKC_API.G_MISS_NUM)
2040: THEN
2041: x_oat_rec.application_id := l_oat_rec.application_id;
2042: END IF;
2043: IF (x_oat_rec.seeded_flag = OKC_API.G_MISS_CHAR)
2044: THEN
2045: x_oat_rec.seeded_flag := l_oat_rec.seeded_flag;
2046: END IF;
2047: RETURN(l_return_status);

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

2052: FUNCTION Set_Attributes (
2053: p_oat_rec IN oat_rec_type,
2054: x_oat_rec OUT NOCOPY oat_rec_type
2055: ) RETURN VARCHAR2 IS
2056: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2057: BEGIN
2058: x_oat_rec := p_oat_rec;
2059: RETURN(l_return_status);
2060: END Set_Attributes;

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

2058: x_oat_rec := p_oat_rec;
2059: RETURN(l_return_status);
2060: END Set_Attributes;
2061: BEGIN
2062: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2063: p_init_msg_list,
2064: '_PVT',
2065: x_return_status);
2066: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2062: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2063: p_init_msg_list,
2064: '_PVT',
2065: x_return_status);
2066: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2067: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2068: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_ERROR;
2070: END IF;

Line 2067: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2063: p_init_msg_list,
2064: '_PVT',
2065: x_return_status);
2066: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2067: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2068: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_ERROR;
2070: END IF;
2071: --- Setting item attributes

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

2064: '_PVT',
2065: x_return_status);
2066: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2067: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2068: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_ERROR;
2070: END IF;
2071: --- Setting item attributes
2072: l_return_status := Set_Attributes(

Line 2069: RAISE OKC_API.G_EXCEPTION_ERROR;

2065: x_return_status);
2066: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2067: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2068: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_ERROR;
2070: END IF;
2071: --- Setting item attributes
2072: l_return_status := Set_Attributes(
2073: p_oat_rec, -- IN

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

2072: l_return_status := Set_Attributes(
2073: p_oat_rec, -- IN
2074: l_oat_rec); -- OUT
2075: --- If any errors happen abort API
2076: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2077: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2078: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2079: RAISE OKC_API.G_EXCEPTION_ERROR;
2080: END IF;

Line 2077: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2073: p_oat_rec, -- IN
2074: l_oat_rec); -- OUT
2075: --- If any errors happen abort API
2076: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2077: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2078: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2079: RAISE OKC_API.G_EXCEPTION_ERROR;
2080: END IF;
2081: l_return_status := populate_new_record(l_oat_rec, l_def_oat_rec);

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

2074: l_oat_rec); -- OUT
2075: --- If any errors happen abort API
2076: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2077: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2078: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2079: RAISE OKC_API.G_EXCEPTION_ERROR;
2080: END IF;
2081: l_return_status := populate_new_record(l_oat_rec, l_def_oat_rec);
2082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2079: RAISE OKC_API.G_EXCEPTION_ERROR;

2075: --- If any errors happen abort API
2076: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2077: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2078: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2079: RAISE OKC_API.G_EXCEPTION_ERROR;
2080: END IF;
2081: l_return_status := populate_new_record(l_oat_rec, l_def_oat_rec);
2082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2078: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2079: RAISE OKC_API.G_EXCEPTION_ERROR;
2080: END IF;
2081: l_return_status := populate_new_record(l_oat_rec, l_def_oat_rec);
2082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_ERROR;
2086: END IF;

Line 2083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2079: RAISE OKC_API.G_EXCEPTION_ERROR;
2080: END IF;
2081: l_return_status := populate_new_record(l_oat_rec, l_def_oat_rec);
2082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_ERROR;
2086: END IF;
2087: UPDATE OKC_OUTCOME_ARGUMENTS

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

2080: END IF;
2081: l_return_status := populate_new_record(l_oat_rec, l_def_oat_rec);
2082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_ERROR;
2086: END IF;
2087: UPDATE OKC_OUTCOME_ARGUMENTS
2088: SET OCE_ID = l_def_oat_rec.oce_id,

Line 2085: RAISE OKC_API.G_EXCEPTION_ERROR;

2081: l_return_status := populate_new_record(l_oat_rec, l_def_oat_rec);
2082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_ERROR;
2086: END IF;
2087: UPDATE OKC_OUTCOME_ARGUMENTS
2088: SET OCE_ID = l_def_oat_rec.oce_id,
2089: PDP_ID = l_def_oat_rec.pdp_id,

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

2100: SEEDED_FLAG = l_def_oat_rec.seeded_flag
2101: WHERE ID = l_def_oat_rec.id;
2102:
2103: x_oat_rec := l_def_oat_rec;
2104: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2105: EXCEPTION
2106: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2107: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2108: (

Line 2106: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2102:
2103: x_oat_rec := l_def_oat_rec;
2104: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2105: EXCEPTION
2106: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2107: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2108: (
2109: l_api_name,
2110: G_PKG_NAME,

Line 2107: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2103: x_oat_rec := l_def_oat_rec;
2104: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2105: EXCEPTION
2106: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2107: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2108: (
2109: l_api_name,
2110: G_PKG_NAME,
2111: 'OKC_API.G_RET_STS_ERROR',

Line 2111: 'OKC_API.G_RET_STS_ERROR',

2107: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2108: (
2109: l_api_name,
2110: G_PKG_NAME,
2111: 'OKC_API.G_RET_STS_ERROR',
2112: x_msg_count,
2113: x_msg_data,
2114: '_PVT'
2115: );

Line 2116: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2112: x_msg_count,
2113: x_msg_data,
2114: '_PVT'
2115: );
2116: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2117: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2118: (
2119: l_api_name,
2120: G_PKG_NAME,

Line 2117: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2113: x_msg_data,
2114: '_PVT'
2115: );
2116: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2117: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2118: (
2119: l_api_name,
2120: G_PKG_NAME,
2121: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2121: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2117: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2118: (
2119: l_api_name,
2120: G_PKG_NAME,
2121: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2122: x_msg_count,
2123: x_msg_data,
2124: '_PVT'
2125: );

Line 2127: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2123: x_msg_data,
2124: '_PVT'
2125: );
2126: WHEN OTHERS THEN
2127: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2128: (
2129: l_api_name,
2130: G_PKG_NAME,
2131: 'OTHERS',

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

2147: x_oatv_rec OUT NOCOPY oatv_rec_type) IS
2148:
2149: l_api_version CONSTANT NUMBER := 1;
2150: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2151: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2152: l_oatv_rec oatv_rec_type := p_oatv_rec;
2153: l_def_oatv_rec oatv_rec_type;
2154: l_oat_rec oat_rec_type;
2155: lx_oat_rec oat_rec_type;

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

2174: x_oatv_rec OUT NOCOPY oatv_rec_type
2175: ) RETURN VARCHAR2 IS
2176: l_oatv_rec oatv_rec_type;
2177: l_row_notfound BOOLEAN := TRUE;
2178: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2179: BEGIN
2180: x_oatv_rec := p_oatv_rec;
2181: -- Get current database values
2182: l_oatv_rec := get_rec(p_oatv_rec, l_row_notfound);

Line 2184: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2180: x_oatv_rec := p_oatv_rec;
2181: -- Get current database values
2182: l_oatv_rec := get_rec(p_oatv_rec, l_row_notfound);
2183: IF (l_row_notfound) THEN
2184: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2185: END IF;
2186: IF (x_oatv_rec.id = OKC_API.G_MISS_NUM)
2187: THEN
2188: x_oatv_rec.id := l_oatv_rec.id;

Line 2186: IF (x_oatv_rec.id = OKC_API.G_MISS_NUM)

2182: l_oatv_rec := get_rec(p_oatv_rec, l_row_notfound);
2183: IF (l_row_notfound) THEN
2184: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2185: END IF;
2186: IF (x_oatv_rec.id = OKC_API.G_MISS_NUM)
2187: THEN
2188: x_oatv_rec.id := l_oatv_rec.id;
2189: END IF;
2190: IF (x_oatv_rec.pdp_id = OKC_API.G_MISS_NUM)

Line 2190: IF (x_oatv_rec.pdp_id = OKC_API.G_MISS_NUM)

2186: IF (x_oatv_rec.id = OKC_API.G_MISS_NUM)
2187: THEN
2188: x_oatv_rec.id := l_oatv_rec.id;
2189: END IF;
2190: IF (x_oatv_rec.pdp_id = OKC_API.G_MISS_NUM)
2191: THEN
2192: x_oatv_rec.pdp_id := l_oatv_rec.pdp_id;
2193: END IF;
2194: IF (x_oatv_rec.oce_id = OKC_API.G_MISS_NUM)

Line 2194: IF (x_oatv_rec.oce_id = OKC_API.G_MISS_NUM)

2190: IF (x_oatv_rec.pdp_id = OKC_API.G_MISS_NUM)
2191: THEN
2192: x_oatv_rec.pdp_id := l_oatv_rec.pdp_id;
2193: END IF;
2194: IF (x_oatv_rec.oce_id = OKC_API.G_MISS_NUM)
2195: THEN
2196: x_oatv_rec.oce_id := l_oatv_rec.oce_id;
2197: END IF;
2198: IF (x_oatv_rec.aae_id = OKC_API.G_MISS_NUM)

Line 2198: IF (x_oatv_rec.aae_id = OKC_API.G_MISS_NUM)

2194: IF (x_oatv_rec.oce_id = OKC_API.G_MISS_NUM)
2195: THEN
2196: x_oatv_rec.oce_id := l_oatv_rec.oce_id;
2197: END IF;
2198: IF (x_oatv_rec.aae_id = OKC_API.G_MISS_NUM)
2199: THEN
2200: x_oatv_rec.aae_id := l_oatv_rec.aae_id;
2201: END IF;
2202: IF (x_oatv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

Line 2202: IF (x_oatv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

2198: IF (x_oatv_rec.aae_id = OKC_API.G_MISS_NUM)
2199: THEN
2200: x_oatv_rec.aae_id := l_oatv_rec.aae_id;
2201: END IF;
2202: IF (x_oatv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
2203: THEN
2204: x_oatv_rec.dnz_chr_id := l_oatv_rec.dnz_chr_id;
2205: END IF;
2206: IF (x_oatv_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 2206: IF (x_oatv_rec.object_version_number = OKC_API.G_MISS_NUM)

2202: IF (x_oatv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
2203: THEN
2204: x_oatv_rec.dnz_chr_id := l_oatv_rec.dnz_chr_id;
2205: END IF;
2206: IF (x_oatv_rec.object_version_number = OKC_API.G_MISS_NUM)
2207: THEN
2208: x_oatv_rec.object_version_number := l_oatv_rec.object_version_number;
2209: END IF;
2210: IF (x_oatv_rec.value = OKC_API.G_MISS_CHAR)

Line 2210: IF (x_oatv_rec.value = OKC_API.G_MISS_CHAR)

2206: IF (x_oatv_rec.object_version_number = OKC_API.G_MISS_NUM)
2207: THEN
2208: x_oatv_rec.object_version_number := l_oatv_rec.object_version_number;
2209: END IF;
2210: IF (x_oatv_rec.value = OKC_API.G_MISS_CHAR)
2211: THEN
2212: x_oatv_rec.value := l_oatv_rec.value;
2213: END IF;
2214: IF (x_oatv_rec.application_id = OKC_API.G_MISS_NUM)

Line 2214: IF (x_oatv_rec.application_id = OKC_API.G_MISS_NUM)

2210: IF (x_oatv_rec.value = OKC_API.G_MISS_CHAR)
2211: THEN
2212: x_oatv_rec.value := l_oatv_rec.value;
2213: END IF;
2214: IF (x_oatv_rec.application_id = OKC_API.G_MISS_NUM)
2215: THEN
2216: x_oatv_rec.application_id := l_oatv_rec.application_id;
2217: END IF;
2218: IF (x_oatv_rec.seeded_flag = OKC_API.G_MISS_CHAR)

Line 2218: IF (x_oatv_rec.seeded_flag = OKC_API.G_MISS_CHAR)

2214: IF (x_oatv_rec.application_id = OKC_API.G_MISS_NUM)
2215: THEN
2216: x_oatv_rec.application_id := l_oatv_rec.application_id;
2217: END IF;
2218: IF (x_oatv_rec.seeded_flag = OKC_API.G_MISS_CHAR)
2219: THEN
2220: x_oatv_rec.seeded_flag := l_oatv_rec.seeded_flag;
2221: END IF;
2222: IF (x_oatv_rec.created_by = OKC_API.G_MISS_NUM)

Line 2222: IF (x_oatv_rec.created_by = OKC_API.G_MISS_NUM)

2218: IF (x_oatv_rec.seeded_flag = OKC_API.G_MISS_CHAR)
2219: THEN
2220: x_oatv_rec.seeded_flag := l_oatv_rec.seeded_flag;
2221: END IF;
2222: IF (x_oatv_rec.created_by = OKC_API.G_MISS_NUM)
2223: THEN
2224: x_oatv_rec.created_by := l_oatv_rec.created_by;
2225: END IF;
2226: IF (x_oatv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2226: IF (x_oatv_rec.creation_date = OKC_API.G_MISS_DATE)

2222: IF (x_oatv_rec.created_by = OKC_API.G_MISS_NUM)
2223: THEN
2224: x_oatv_rec.created_by := l_oatv_rec.created_by;
2225: END IF;
2226: IF (x_oatv_rec.creation_date = OKC_API.G_MISS_DATE)
2227: THEN
2228: x_oatv_rec.creation_date := l_oatv_rec.creation_date;
2229: END IF;
2230: IF (x_oatv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2230: IF (x_oatv_rec.last_updated_by = OKC_API.G_MISS_NUM)

2226: IF (x_oatv_rec.creation_date = OKC_API.G_MISS_DATE)
2227: THEN
2228: x_oatv_rec.creation_date := l_oatv_rec.creation_date;
2229: END IF;
2230: IF (x_oatv_rec.last_updated_by = OKC_API.G_MISS_NUM)
2231: THEN
2232: x_oatv_rec.last_updated_by := l_oatv_rec.last_updated_by;
2233: END IF;
2234: IF (x_oatv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2234: IF (x_oatv_rec.last_update_date = OKC_API.G_MISS_DATE)

2230: IF (x_oatv_rec.last_updated_by = OKC_API.G_MISS_NUM)
2231: THEN
2232: x_oatv_rec.last_updated_by := l_oatv_rec.last_updated_by;
2233: END IF;
2234: IF (x_oatv_rec.last_update_date = OKC_API.G_MISS_DATE)
2235: THEN
2236: x_oatv_rec.last_update_date := l_oatv_rec.last_update_date;
2237: END IF;
2238: IF (x_oatv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2238: IF (x_oatv_rec.last_update_login = OKC_API.G_MISS_NUM)

2234: IF (x_oatv_rec.last_update_date = OKC_API.G_MISS_DATE)
2235: THEN
2236: x_oatv_rec.last_update_date := l_oatv_rec.last_update_date;
2237: END IF;
2238: IF (x_oatv_rec.last_update_login = OKC_API.G_MISS_NUM)
2239: THEN
2240: x_oatv_rec.last_update_login := l_oatv_rec.last_update_login;
2241: END IF;
2242: RETURN(l_return_status);

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

2247: FUNCTION Set_Attributes (
2248: p_oatv_rec IN oatv_rec_type,
2249: x_oatv_rec OUT NOCOPY oatv_rec_type
2250: ) RETURN VARCHAR2 IS
2251: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2252: BEGIN
2253: x_oatv_rec := p_oatv_rec;
2254: x_oatv_rec.OBJECT_VERSION_NUMBER := NVL(x_oatv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2255: RETURN(l_return_status);

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

2254: x_oatv_rec.OBJECT_VERSION_NUMBER := NVL(x_oatv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2255: RETURN(l_return_status);
2256: END Set_Attributes;
2257: BEGIN
2258: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2259: G_PKG_NAME,
2260: p_init_msg_list,
2261: l_api_version,
2262: p_api_version,

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

2261: l_api_version,
2262: p_api_version,
2263: '_PVT',
2264: x_return_status);
2265: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2267: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2268: RAISE OKC_API.G_EXCEPTION_ERROR;
2269: END IF;

Line 2266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2262: p_api_version,
2263: '_PVT',
2264: x_return_status);
2265: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2267: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2268: RAISE OKC_API.G_EXCEPTION_ERROR;
2269: END IF;
2270: -- Seed data should not be updated unless user is DATAMERGE

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

2263: '_PVT',
2264: x_return_status);
2265: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2267: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2268: RAISE OKC_API.G_EXCEPTION_ERROR;
2269: END IF;
2270: -- Seed data should not be updated unless user is DATAMERGE
2271: IF l_oatv_rec.last_updated_by <> 1 THEN

Line 2268: RAISE OKC_API.G_EXCEPTION_ERROR;

2264: x_return_status);
2265: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2267: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2268: RAISE OKC_API.G_EXCEPTION_ERROR;
2269: END IF;
2270: -- Seed data should not be updated unless user is DATAMERGE
2271: IF l_oatv_rec.last_updated_by <> 1 THEN
2272: IF l_oatv_rec.seeded_flag = 'Y' THEN

Line 2273: OKC_API.set_message(p_app_name => G_APP_NAME,

2269: END IF;
2270: -- Seed data should not be updated unless user is DATAMERGE
2271: IF l_oatv_rec.last_updated_by <> 1 THEN
2272: IF l_oatv_rec.seeded_flag = 'Y' THEN
2273: OKC_API.set_message(p_app_name => G_APP_NAME,
2274: p_msg_name => 'OKC_NOT_DELETE_SEEDED');
2275: RAISE OKC_API.G_EXCEPTION_ERROR;
2276: END IF;
2277: END IF;

Line 2275: RAISE OKC_API.G_EXCEPTION_ERROR;

2271: IF l_oatv_rec.last_updated_by <> 1 THEN
2272: IF l_oatv_rec.seeded_flag = 'Y' THEN
2273: OKC_API.set_message(p_app_name => G_APP_NAME,
2274: p_msg_name => 'OKC_NOT_DELETE_SEEDED');
2275: RAISE OKC_API.G_EXCEPTION_ERROR;
2276: END IF;
2277: END IF;
2278: --- Setting item attributes
2279: l_return_status := Set_Attributes(

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

2279: l_return_status := Set_Attributes(
2280: p_oatv_rec, -- IN
2281: l_oatv_rec); -- OUT
2282: --- If any errors happen abort API
2283: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2284: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2285: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2286: RAISE OKC_API.G_EXCEPTION_ERROR;
2287: END IF;

Line 2284: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2280: p_oatv_rec, -- IN
2281: l_oatv_rec); -- OUT
2282: --- If any errors happen abort API
2283: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2284: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2285: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2286: RAISE OKC_API.G_EXCEPTION_ERROR;
2287: END IF;
2288: l_return_status := populate_new_record(l_oatv_rec, l_def_oatv_rec);

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

2281: l_oatv_rec); -- OUT
2282: --- If any errors happen abort API
2283: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2284: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2285: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2286: RAISE OKC_API.G_EXCEPTION_ERROR;
2287: END IF;
2288: l_return_status := populate_new_record(l_oatv_rec, l_def_oatv_rec);
2289: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2286: RAISE OKC_API.G_EXCEPTION_ERROR;

2282: --- If any errors happen abort API
2283: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2284: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2285: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2286: RAISE OKC_API.G_EXCEPTION_ERROR;
2287: END IF;
2288: l_return_status := populate_new_record(l_oatv_rec, l_def_oatv_rec);
2289: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2285: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2286: RAISE OKC_API.G_EXCEPTION_ERROR;
2287: END IF;
2288: l_return_status := populate_new_record(l_oatv_rec, l_def_oatv_rec);
2289: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2291: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2292: RAISE OKC_API.G_EXCEPTION_ERROR;
2293: END IF;

Line 2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2286: RAISE OKC_API.G_EXCEPTION_ERROR;
2287: END IF;
2288: l_return_status := populate_new_record(l_oatv_rec, l_def_oatv_rec);
2289: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2291: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2292: RAISE OKC_API.G_EXCEPTION_ERROR;
2293: END IF;
2294: l_def_oatv_rec := fill_who_columns(l_def_oatv_rec);

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

2287: END IF;
2288: l_return_status := populate_new_record(l_oatv_rec, l_def_oatv_rec);
2289: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2291: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2292: RAISE OKC_API.G_EXCEPTION_ERROR;
2293: END IF;
2294: l_def_oatv_rec := fill_who_columns(l_def_oatv_rec);
2295: --- Validate all non-missing attributes (Item Level Validation)

Line 2292: RAISE OKC_API.G_EXCEPTION_ERROR;

2288: l_return_status := populate_new_record(l_oatv_rec, l_def_oatv_rec);
2289: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2291: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2292: RAISE OKC_API.G_EXCEPTION_ERROR;
2293: END IF;
2294: l_def_oatv_rec := fill_who_columns(l_def_oatv_rec);
2295: --- Validate all non-missing attributes (Item Level Validation)
2296: l_return_status := Validate_Attributes(l_def_oatv_rec);

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

2294: l_def_oatv_rec := fill_who_columns(l_def_oatv_rec);
2295: --- Validate all non-missing attributes (Item Level Validation)
2296: l_return_status := Validate_Attributes(l_def_oatv_rec);
2297: --- If any errors happen abort API
2298: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2299: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2300: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2301: RAISE OKC_API.G_EXCEPTION_ERROR;
2302: END IF;

Line 2299: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2295: --- Validate all non-missing attributes (Item Level Validation)
2296: l_return_status := Validate_Attributes(l_def_oatv_rec);
2297: --- If any errors happen abort API
2298: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2299: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2300: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2301: RAISE OKC_API.G_EXCEPTION_ERROR;
2302: END IF;
2303: l_return_status := Validate_Record(l_def_oatv_rec);

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

2296: l_return_status := Validate_Attributes(l_def_oatv_rec);
2297: --- If any errors happen abort API
2298: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2299: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2300: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2301: RAISE OKC_API.G_EXCEPTION_ERROR;
2302: END IF;
2303: l_return_status := Validate_Record(l_def_oatv_rec);
2304: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2301: RAISE OKC_API.G_EXCEPTION_ERROR;

2297: --- If any errors happen abort API
2298: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2299: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2300: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2301: RAISE OKC_API.G_EXCEPTION_ERROR;
2302: END IF;
2303: l_return_status := Validate_Record(l_def_oatv_rec);
2304: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2300: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2301: RAISE OKC_API.G_EXCEPTION_ERROR;
2302: END IF;
2303: l_return_status := Validate_Record(l_def_oatv_rec);
2304: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2306: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2307: RAISE OKC_API.G_EXCEPTION_ERROR;
2308: END IF;

Line 2305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2301: RAISE OKC_API.G_EXCEPTION_ERROR;
2302: END IF;
2303: l_return_status := Validate_Record(l_def_oatv_rec);
2304: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2306: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2307: RAISE OKC_API.G_EXCEPTION_ERROR;
2308: END IF;
2309:

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

2302: END IF;
2303: l_return_status := Validate_Record(l_def_oatv_rec);
2304: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2306: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2307: RAISE OKC_API.G_EXCEPTION_ERROR;
2308: END IF;
2309:
2310: --------------------------------------

Line 2307: RAISE OKC_API.G_EXCEPTION_ERROR;

2303: l_return_status := Validate_Record(l_def_oatv_rec);
2304: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2306: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2307: RAISE OKC_API.G_EXCEPTION_ERROR;
2308: END IF;
2309:
2310: --------------------------------------
2311: -- Move VIEW record to "Child" records

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

2321: x_msg_data,
2322: l_oat_rec,
2323: lx_oat_rec
2324: );
2325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2328: RAISE OKC_API.G_EXCEPTION_ERROR;
2329: END IF;

Line 2326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2322: l_oat_rec,
2323: lx_oat_rec
2324: );
2325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2328: RAISE OKC_API.G_EXCEPTION_ERROR;
2329: END IF;
2330: migrate(lx_oat_rec, l_def_oatv_rec);

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

2323: lx_oat_rec
2324: );
2325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2328: RAISE OKC_API.G_EXCEPTION_ERROR;
2329: END IF;
2330: migrate(lx_oat_rec, l_def_oatv_rec);
2331: x_oatv_rec := l_def_oatv_rec;

Line 2328: RAISE OKC_API.G_EXCEPTION_ERROR;

2324: );
2325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2328: RAISE OKC_API.G_EXCEPTION_ERROR;
2329: END IF;
2330: migrate(lx_oat_rec, l_def_oatv_rec);
2331: x_oatv_rec := l_def_oatv_rec;
2332: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2328: RAISE OKC_API.G_EXCEPTION_ERROR;
2329: END IF;
2330: migrate(lx_oat_rec, l_def_oatv_rec);
2331: x_oatv_rec := l_def_oatv_rec;
2332: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2333: EXCEPTION
2334: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2335: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2336: (

Line 2334: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2330: migrate(lx_oat_rec, l_def_oatv_rec);
2331: x_oatv_rec := l_def_oatv_rec;
2332: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2333: EXCEPTION
2334: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2335: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2336: (
2337: l_api_name,
2338: G_PKG_NAME,

Line 2335: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2331: x_oatv_rec := l_def_oatv_rec;
2332: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2333: EXCEPTION
2334: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2335: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2336: (
2337: l_api_name,
2338: G_PKG_NAME,
2339: 'OKC_API.G_RET_STS_ERROR',

Line 2339: 'OKC_API.G_RET_STS_ERROR',

2335: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2336: (
2337: l_api_name,
2338: G_PKG_NAME,
2339: 'OKC_API.G_RET_STS_ERROR',
2340: x_msg_count,
2341: x_msg_data,
2342: '_PVT'
2343: );

Line 2344: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2340: x_msg_count,
2341: x_msg_data,
2342: '_PVT'
2343: );
2344: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2345: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2346: (
2347: l_api_name,
2348: G_PKG_NAME,

Line 2345: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2341: x_msg_data,
2342: '_PVT'
2343: );
2344: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2345: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2346: (
2347: l_api_name,
2348: G_PKG_NAME,
2349: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2349: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2345: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2346: (
2347: l_api_name,
2348: G_PKG_NAME,
2349: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2350: x_msg_count,
2351: x_msg_data,
2352: '_PVT'
2353: );

Line 2355: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2351: x_msg_data,
2352: '_PVT'
2353: );
2354: WHEN OTHERS THEN
2355: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2356: (
2357: l_api_name,
2358: G_PKG_NAME,
2359: 'OTHERS',

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

2375: x_oatv_tbl OUT NOCOPY oatv_tbl_type) IS
2376:
2377: l_api_version CONSTANT NUMBER := 1;
2378: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2379: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2380: i NUMBER := 0;
2381: BEGIN
2382: OKC_API.init_msg_list(p_init_msg_list);
2383: -- Make sure PL/SQL table has records in it before passing

Line 2382: OKC_API.init_msg_list(p_init_msg_list);

2378: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2379: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2380: i NUMBER := 0;
2381: BEGIN
2382: OKC_API.init_msg_list(p_init_msg_list);
2383: -- Make sure PL/SQL table has records in it before passing
2384: IF (p_oatv_tbl.COUNT > 0) THEN
2385: i := p_oatv_tbl.FIRST;
2386: LOOP

Line 2389: p_init_msg_list => OKC_API.G_FALSE,

2385: i := p_oatv_tbl.FIRST;
2386: LOOP
2387: update_row (
2388: p_api_version => p_api_version,
2389: p_init_msg_list => OKC_API.G_FALSE,
2390: x_return_status => x_return_status,
2391: x_msg_count => x_msg_count,
2392: x_msg_data => x_msg_data,
2393: p_oatv_rec => p_oatv_tbl(i),

Line 2400: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2396: i := p_oatv_tbl.NEXT(i);
2397: END LOOP;
2398: END IF;
2399: EXCEPTION
2400: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2401: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2402: (
2403: l_api_name,
2404: G_PKG_NAME,

Line 2401: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2397: END LOOP;
2398: END IF;
2399: EXCEPTION
2400: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2401: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2402: (
2403: l_api_name,
2404: G_PKG_NAME,
2405: 'OKC_API.G_RET_STS_ERROR',

Line 2405: 'OKC_API.G_RET_STS_ERROR',

2401: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2402: (
2403: l_api_name,
2404: G_PKG_NAME,
2405: 'OKC_API.G_RET_STS_ERROR',
2406: x_msg_count,
2407: x_msg_data,
2408: '_PVT'
2409: );

Line 2410: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2406: x_msg_count,
2407: x_msg_data,
2408: '_PVT'
2409: );
2410: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2411: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2412: (
2413: l_api_name,
2414: G_PKG_NAME,

Line 2411: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2407: x_msg_data,
2408: '_PVT'
2409: );
2410: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2411: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2412: (
2413: l_api_name,
2414: G_PKG_NAME,
2415: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2415: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2411: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2412: (
2413: l_api_name,
2414: G_PKG_NAME,
2415: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2416: x_msg_count,
2417: x_msg_data,
2418: '_PVT'
2419: );

Line 2421: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2417: x_msg_data,
2418: '_PVT'
2419: );
2420: WHEN OTHERS THEN
2421: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2422: (
2423: l_api_name,
2424: G_PKG_NAME,
2425: 'OTHERS',

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

2443: p_oat_rec IN oat_rec_type) IS
2444:
2445: l_api_version CONSTANT NUMBER := 1;
2446: l_api_name CONSTANT VARCHAR2(30) := 'ARGUMENTS_delete_row';
2447: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2448: l_oat_rec oat_rec_type:= p_oat_rec;
2449: l_row_notfound BOOLEAN := TRUE;
2450: BEGIN
2451: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2447: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2448: l_oat_rec oat_rec_type:= p_oat_rec;
2449: l_row_notfound BOOLEAN := TRUE;
2450: BEGIN
2451: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2452: p_init_msg_list,
2453: '_PVT',
2454: x_return_status);
2455: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2451: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2452: p_init_msg_list,
2453: '_PVT',
2454: x_return_status);
2455: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2456: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2457: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2458: RAISE OKC_API.G_EXCEPTION_ERROR;
2459: END IF;

Line 2456: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2452: p_init_msg_list,
2453: '_PVT',
2454: x_return_status);
2455: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2456: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2457: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2458: RAISE OKC_API.G_EXCEPTION_ERROR;
2459: END IF;
2460: DELETE FROM OKC_OUTCOME_ARGUMENTS

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

2453: '_PVT',
2454: x_return_status);
2455: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2456: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2457: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2458: RAISE OKC_API.G_EXCEPTION_ERROR;
2459: END IF;
2460: DELETE FROM OKC_OUTCOME_ARGUMENTS
2461: WHERE ID = l_oat_rec.id;

Line 2458: RAISE OKC_API.G_EXCEPTION_ERROR;

2454: x_return_status);
2455: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2456: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2457: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2458: RAISE OKC_API.G_EXCEPTION_ERROR;
2459: END IF;
2460: DELETE FROM OKC_OUTCOME_ARGUMENTS
2461: WHERE ID = l_oat_rec.id;
2462:

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

2459: END IF;
2460: DELETE FROM OKC_OUTCOME_ARGUMENTS
2461: WHERE ID = l_oat_rec.id;
2462:
2463: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2464: EXCEPTION
2465: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2466: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2467: (

Line 2465: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2461: WHERE ID = l_oat_rec.id;
2462:
2463: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2464: EXCEPTION
2465: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2466: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2467: (
2468: l_api_name,
2469: G_PKG_NAME,

Line 2466: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2462:
2463: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2464: EXCEPTION
2465: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2466: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2467: (
2468: l_api_name,
2469: G_PKG_NAME,
2470: 'OKC_API.G_RET_STS_ERROR',

Line 2470: 'OKC_API.G_RET_STS_ERROR',

2466: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2467: (
2468: l_api_name,
2469: G_PKG_NAME,
2470: 'OKC_API.G_RET_STS_ERROR',
2471: x_msg_count,
2472: x_msg_data,
2473: '_PVT'
2474: );

Line 2475: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2471: x_msg_count,
2472: x_msg_data,
2473: '_PVT'
2474: );
2475: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2476: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2477: (
2478: l_api_name,
2479: G_PKG_NAME,

Line 2476: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2472: x_msg_data,
2473: '_PVT'
2474: );
2475: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2476: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2477: (
2478: l_api_name,
2479: G_PKG_NAME,
2480: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2480: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2476: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2477: (
2478: l_api_name,
2479: G_PKG_NAME,
2480: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2481: x_msg_count,
2482: x_msg_data,
2483: '_PVT'
2484: );

Line 2486: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2482: x_msg_data,
2483: '_PVT'
2484: );
2485: WHEN OTHERS THEN
2486: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2487: (
2488: l_api_name,
2489: G_PKG_NAME,
2490: 'OTHERS',

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

2505: p_oatv_rec IN oatv_rec_type) IS
2506:
2507: l_api_version CONSTANT NUMBER := 1;
2508: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2509: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2510: l_oatv_rec oatv_rec_type := p_oatv_rec;
2511: l_oat_rec oat_rec_type;
2512: BEGIN
2513: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2509: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2510: l_oatv_rec oatv_rec_type := p_oatv_rec;
2511: l_oat_rec oat_rec_type;
2512: BEGIN
2513: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2514: G_PKG_NAME,
2515: p_init_msg_list,
2516: l_api_version,
2517: p_api_version,

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

2516: l_api_version,
2517: p_api_version,
2518: '_PVT',
2519: x_return_status);
2520: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2522: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2523: RAISE OKC_API.G_EXCEPTION_ERROR;
2524: END IF;

Line 2521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2517: p_api_version,
2518: '_PVT',
2519: x_return_status);
2520: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2522: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2523: RAISE OKC_API.G_EXCEPTION_ERROR;
2524: END IF;
2525: -- Seed data should not be deleted unless user is DATAMERGE

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

2518: '_PVT',
2519: x_return_status);
2520: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2522: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2523: RAISE OKC_API.G_EXCEPTION_ERROR;
2524: END IF;
2525: -- Seed data should not be deleted unless user is DATAMERGE
2526: IF l_oatv_rec.last_updated_by <> 1 THEN

Line 2523: RAISE OKC_API.G_EXCEPTION_ERROR;

2519: x_return_status);
2520: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2522: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2523: RAISE OKC_API.G_EXCEPTION_ERROR;
2524: END IF;
2525: -- Seed data should not be deleted unless user is DATAMERGE
2526: IF l_oatv_rec.last_updated_by <> 1 THEN
2527: IF l_oatv_rec.seeded_flag = 'Y' THEN

Line 2528: OKC_API.set_message(p_app_name => G_APP_NAME,

2524: END IF;
2525: -- Seed data should not be deleted unless user is DATAMERGE
2526: IF l_oatv_rec.last_updated_by <> 1 THEN
2527: IF l_oatv_rec.seeded_flag = 'Y' THEN
2528: OKC_API.set_message(p_app_name => G_APP_NAME,
2529: p_msg_name => 'OKC_NOT_DELETE_SEEDED');
2530: RAISE OKC_API.G_EXCEPTION_ERROR;
2531: END IF;
2532: END IF;

Line 2530: RAISE OKC_API.G_EXCEPTION_ERROR;

2526: IF l_oatv_rec.last_updated_by <> 1 THEN
2527: IF l_oatv_rec.seeded_flag = 'Y' THEN
2528: OKC_API.set_message(p_app_name => G_APP_NAME,
2529: p_msg_name => 'OKC_NOT_DELETE_SEEDED');
2530: RAISE OKC_API.G_EXCEPTION_ERROR;
2531: END IF;
2532: END IF;
2533: --------------------------------------
2534: -- Move VIEW record to "Child" records

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

2543: x_msg_count,
2544: x_msg_data,
2545: l_oat_rec
2546: );
2547: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2548: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2549: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2550: RAISE OKC_API.G_EXCEPTION_ERROR;
2551: END IF;

Line 2548: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2544: x_msg_data,
2545: l_oat_rec
2546: );
2547: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2548: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2549: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2550: RAISE OKC_API.G_EXCEPTION_ERROR;
2551: END IF;
2552: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2545: l_oat_rec
2546: );
2547: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2548: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2549: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2550: RAISE OKC_API.G_EXCEPTION_ERROR;
2551: END IF;
2552: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2553: EXCEPTION

Line 2550: RAISE OKC_API.G_EXCEPTION_ERROR;

2546: );
2547: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2548: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2549: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2550: RAISE OKC_API.G_EXCEPTION_ERROR;
2551: END IF;
2552: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2553: EXCEPTION
2554: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2548: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2549: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2550: RAISE OKC_API.G_EXCEPTION_ERROR;
2551: END IF;
2552: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2553: EXCEPTION
2554: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2555: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2556: (

Line 2554: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2550: RAISE OKC_API.G_EXCEPTION_ERROR;
2551: END IF;
2552: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2553: EXCEPTION
2554: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2555: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2556: (
2557: l_api_name,
2558: G_PKG_NAME,

Line 2555: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2551: END IF;
2552: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2553: EXCEPTION
2554: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2555: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2556: (
2557: l_api_name,
2558: G_PKG_NAME,
2559: 'OKC_API.G_RET_STS_ERROR',

Line 2559: 'OKC_API.G_RET_STS_ERROR',

2555: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2556: (
2557: l_api_name,
2558: G_PKG_NAME,
2559: 'OKC_API.G_RET_STS_ERROR',
2560: x_msg_count,
2561: x_msg_data,
2562: '_PVT'
2563: );

Line 2564: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2560: x_msg_count,
2561: x_msg_data,
2562: '_PVT'
2563: );
2564: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2565: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2566: (
2567: l_api_name,
2568: G_PKG_NAME,

Line 2565: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2561: x_msg_data,
2562: '_PVT'
2563: );
2564: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2565: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2566: (
2567: l_api_name,
2568: G_PKG_NAME,
2569: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2569: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2565: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2566: (
2567: l_api_name,
2568: G_PKG_NAME,
2569: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2570: x_msg_count,
2571: x_msg_data,
2572: '_PVT'
2573: );

Line 2575: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2571: x_msg_data,
2572: '_PVT'
2573: );
2574: WHEN OTHERS THEN
2575: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2576: (
2577: l_api_name,
2578: G_PKG_NAME,
2579: 'OTHERS',

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

2594: p_oatv_tbl IN oatv_tbl_type) IS
2595:
2596: l_api_version CONSTANT NUMBER := 1;
2597: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2598: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2599: i NUMBER := 0;
2600: BEGIN
2601: OKC_API.init_msg_list(p_init_msg_list);
2602: -- Make sure PL/SQL table has records in it before passing

Line 2601: OKC_API.init_msg_list(p_init_msg_list);

2597: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2598: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2599: i NUMBER := 0;
2600: BEGIN
2601: OKC_API.init_msg_list(p_init_msg_list);
2602: -- Make sure PL/SQL table has records in it before passing
2603: IF (p_oatv_tbl.COUNT > 0) THEN
2604: i := p_oatv_tbl.FIRST;
2605: LOOP

Line 2608: p_init_msg_list => OKC_API.G_FALSE,

2604: i := p_oatv_tbl.FIRST;
2605: LOOP
2606: delete_row (
2607: p_api_version => p_api_version,
2608: p_init_msg_list => OKC_API.G_FALSE,
2609: x_return_status => x_return_status,
2610: x_msg_count => x_msg_count,
2611: x_msg_data => x_msg_data,
2612: p_oatv_rec => p_oatv_tbl(i));

Line 2618: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2614: i := p_oatv_tbl.NEXT(i);
2615: END LOOP;
2616: END IF;
2617: EXCEPTION
2618: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2619: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2620: (
2621: l_api_name,
2622: G_PKG_NAME,

Line 2619: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2615: END LOOP;
2616: END IF;
2617: EXCEPTION
2618: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2619: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2620: (
2621: l_api_name,
2622: G_PKG_NAME,
2623: 'OKC_API.G_RET_STS_ERROR',

Line 2623: 'OKC_API.G_RET_STS_ERROR',

2619: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2620: (
2621: l_api_name,
2622: G_PKG_NAME,
2623: 'OKC_API.G_RET_STS_ERROR',
2624: x_msg_count,
2625: x_msg_data,
2626: '_PVT'
2627: );

Line 2628: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2624: x_msg_count,
2625: x_msg_data,
2626: '_PVT'
2627: );
2628: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2629: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2630: (
2631: l_api_name,
2632: G_PKG_NAME,

Line 2629: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2625: x_msg_data,
2626: '_PVT'
2627: );
2628: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2629: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2630: (
2631: l_api_name,
2632: G_PKG_NAME,
2633: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2633: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2629: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2630: (
2631: l_api_name,
2632: G_PKG_NAME,
2633: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2634: x_msg_count,
2635: x_msg_data,
2636: '_PVT'
2637: );

Line 2639: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2635: x_msg_data,
2636: '_PVT'
2637: );
2638: WHEN OTHERS THEN
2639: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2640: (
2641: l_api_name,
2642: G_PKG_NAME,
2643: 'OTHERS',

Line 2676: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2672: i NUMBER := p_oatv_tbl.FIRST;
2673: BEGIN
2674:
2675: --Initialize return status
2676: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2677: while i is not null
2678: LOOP
2679: j := j + 1;
2680: in_id (j) := p_oatv_tbl(i).id;

Line 2735: OKC_API.SET_MESSAGE(

2731: );
2732: EXCEPTION
2733: WHEN OTHERS THEN
2734: -- store SQL error message on message stack
2735: OKC_API.SET_MESSAGE(
2736: p_app_name => G_APP_NAME,
2737: p_msg_name => G_UNEXPECTED_ERROR,
2738: p_token1 => G_SQLCODE_TOKEN,
2739: p_token1_value => SQLCODE,

Line 2743: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2739: p_token1_value => SQLCODE,
2740: p_token2 => G_SQLERRM_TOKEN,
2741: p_token2_value => SQLERRM);
2742: -- notify caller of an error as UNEXPECTED error
2743: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2744:
2745: -- RAISE;
2746: END INSERT_ROW_UPG;
2747:

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

2753: p_chr_id IN NUMBER,
2754: p_major_version IN NUMBER
2755: ) RETURN VARCHAR2 IS
2756:
2757: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2758:
2759: BEGIN
2760: INSERT INTO okc_outcome_arguments_h
2761: (

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

2798: EXCEPTION
2799: -- other appropriate handlers
2800: WHEN OTHERS THEN
2801: -- store SQL error message on message stack
2802: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2803: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2804: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2805: p_token1_value => sqlcode,
2806: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 2810: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2806: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2807: p_token2_value => sqlerrm);
2808:
2809: -- notify UNEXPECTED error
2810: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2811: return l_return_status;
2812: END create_version;
2813:
2814: --This Function is called from Versioning API OKC_VERSION_PVT

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

2819: p_chr_id IN NUMBER,
2820: p_major_version IN NUMBER
2821: ) RETURN VARCHAR2 IS
2822:
2823: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2824:
2825: BEGIN
2826: INSERT INTO okc_outcome_arguments
2827: (

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

2863: EXCEPTION
2864: -- other appropriate handlers
2865: WHEN OTHERS THEN
2866: -- store SQL error message on message stack
2867: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2868: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2869: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2870: p_token1_value => sqlcode,
2871: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 2875: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2871: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2872: p_token2_value => sqlerrm);
2873:
2874: -- notify UNEXPECTED error
2875: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2876: return l_return_status;
2877: END restore_version;
2878: --
2879: END OKC_OAT_PVT;