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

Line 9: g_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

5: /*+++++++++++++Start of hand code +++++++++++++++++*/
6: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
7: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
8: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
9: g_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
10: G_EXCEPTION_HALT_VALIDATION exception;
11: /*+++++++++++++End of hand code +++++++++++++++++++*/
12: ---------------------------------------------------------------------------
13: -- FUNCTION get_seq_id

Line 254: IF (l_cimv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

250: okc_debug.Set_Indentation('OKC_CIM_PVT');
251: okc_debug.log('900: Entered null_out_defaults', 2);
252: END IF;
253:
254: IF (l_cimv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
255: l_cimv_rec.object_version_number := NULL;
256: END IF;
257: IF (l_cimv_rec.cle_id = OKC_API.G_MISS_NUM) THEN
258: l_cimv_rec.cle_id := NULL;

Line 257: IF (l_cimv_rec.cle_id = OKC_API.G_MISS_NUM) THEN

253:
254: IF (l_cimv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
255: l_cimv_rec.object_version_number := NULL;
256: END IF;
257: IF (l_cimv_rec.cle_id = OKC_API.G_MISS_NUM) THEN
258: l_cimv_rec.cle_id := NULL;
259: END IF;
260: IF (l_cimv_rec.chr_id = OKC_API.G_MISS_NUM) THEN
261: l_cimv_rec.chr_id := NULL;

Line 260: IF (l_cimv_rec.chr_id = OKC_API.G_MISS_NUM) THEN

256: END IF;
257: IF (l_cimv_rec.cle_id = OKC_API.G_MISS_NUM) THEN
258: l_cimv_rec.cle_id := NULL;
259: END IF;
260: IF (l_cimv_rec.chr_id = OKC_API.G_MISS_NUM) THEN
261: l_cimv_rec.chr_id := NULL;
262: END IF;
263: IF (l_cimv_rec.cle_id_for = OKC_API.G_MISS_NUM) THEN
264: l_cimv_rec.cle_id_for := NULL;

Line 263: IF (l_cimv_rec.cle_id_for = OKC_API.G_MISS_NUM) THEN

259: END IF;
260: IF (l_cimv_rec.chr_id = OKC_API.G_MISS_NUM) THEN
261: l_cimv_rec.chr_id := NULL;
262: END IF;
263: IF (l_cimv_rec.cle_id_for = OKC_API.G_MISS_NUM) THEN
264: l_cimv_rec.cle_id_for := NULL;
265: END IF;
266: IF (l_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) THEN
267: l_cimv_rec.dnz_chr_id := NULL;

Line 266: IF (l_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) THEN

262: END IF;
263: IF (l_cimv_rec.cle_id_for = OKC_API.G_MISS_NUM) THEN
264: l_cimv_rec.cle_id_for := NULL;
265: END IF;
266: IF (l_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) THEN
267: l_cimv_rec.dnz_chr_id := NULL;
268: END IF;
269: IF (l_cimv_rec.object1_id1 = OKC_API.G_MISS_CHAR) THEN
270: l_cimv_rec.object1_id1 := NULL;

Line 269: IF (l_cimv_rec.object1_id1 = OKC_API.G_MISS_CHAR) THEN

265: END IF;
266: IF (l_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) THEN
267: l_cimv_rec.dnz_chr_id := NULL;
268: END IF;
269: IF (l_cimv_rec.object1_id1 = OKC_API.G_MISS_CHAR) THEN
270: l_cimv_rec.object1_id1 := NULL;
271: END IF;
272: IF (l_cimv_rec.object1_id2 = OKC_API.G_MISS_CHAR) THEN
273: l_cimv_rec.object1_id2 := NULL;

Line 272: IF (l_cimv_rec.object1_id2 = OKC_API.G_MISS_CHAR) THEN

268: END IF;
269: IF (l_cimv_rec.object1_id1 = OKC_API.G_MISS_CHAR) THEN
270: l_cimv_rec.object1_id1 := NULL;
271: END IF;
272: IF (l_cimv_rec.object1_id2 = OKC_API.G_MISS_CHAR) THEN
273: l_cimv_rec.object1_id2 := NULL;
274: END IF;
275: IF (l_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR) THEN
276: l_cimv_rec.jtot_object1_code := NULL;

Line 275: IF (l_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR) THEN

271: END IF;
272: IF (l_cimv_rec.object1_id2 = OKC_API.G_MISS_CHAR) THEN
273: l_cimv_rec.object1_id2 := NULL;
274: END IF;
275: IF (l_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR) THEN
276: l_cimv_rec.jtot_object1_code := NULL;
277: END IF;
278: IF (l_cimv_rec.uom_code = OKC_API.G_MISS_CHAR) THEN
279: l_cimv_rec.uom_code := NULL;

Line 278: IF (l_cimv_rec.uom_code = OKC_API.G_MISS_CHAR) THEN

274: END IF;
275: IF (l_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR) THEN
276: l_cimv_rec.jtot_object1_code := NULL;
277: END IF;
278: IF (l_cimv_rec.uom_code = OKC_API.G_MISS_CHAR) THEN
279: l_cimv_rec.uom_code := NULL;
280: END IF;
281: IF (l_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR) THEN
282: l_cimv_rec.exception_yn := NULL;

Line 281: IF (l_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR) THEN

277: END IF;
278: IF (l_cimv_rec.uom_code = OKC_API.G_MISS_CHAR) THEN
279: l_cimv_rec.uom_code := NULL;
280: END IF;
281: IF (l_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR) THEN
282: l_cimv_rec.exception_yn := NULL;
283: END IF;
284: IF (l_cimv_rec.number_of_items = OKC_API.G_MISS_NUM) THEN
285: l_cimv_rec.number_of_items := NULL;

Line 284: IF (l_cimv_rec.number_of_items = OKC_API.G_MISS_NUM) THEN

280: END IF;
281: IF (l_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR) THEN
282: l_cimv_rec.exception_yn := NULL;
283: END IF;
284: IF (l_cimv_rec.number_of_items = OKC_API.G_MISS_NUM) THEN
285: l_cimv_rec.number_of_items := NULL;
286: END IF;
287: IF (l_cimv_rec.upg_orig_system_ref = OKC_API.G_MISS_CHAR) THEN
288: l_cimv_rec.upg_orig_system_ref := NULL;

Line 287: IF (l_cimv_rec.upg_orig_system_ref = OKC_API.G_MISS_CHAR) THEN

283: END IF;
284: IF (l_cimv_rec.number_of_items = OKC_API.G_MISS_NUM) THEN
285: l_cimv_rec.number_of_items := NULL;
286: END IF;
287: IF (l_cimv_rec.upg_orig_system_ref = OKC_API.G_MISS_CHAR) THEN
288: l_cimv_rec.upg_orig_system_ref := NULL;
289: END IF;
290: IF (l_cimv_rec.upg_orig_system_ref_id = OKC_API.G_MISS_NUM) THEN
291: l_cimv_rec.upg_orig_system_ref_id := NULL;

Line 290: IF (l_cimv_rec.upg_orig_system_ref_id = OKC_API.G_MISS_NUM) THEN

286: END IF;
287: IF (l_cimv_rec.upg_orig_system_ref = OKC_API.G_MISS_CHAR) THEN
288: l_cimv_rec.upg_orig_system_ref := NULL;
289: END IF;
290: IF (l_cimv_rec.upg_orig_system_ref_id = OKC_API.G_MISS_NUM) THEN
291: l_cimv_rec.upg_orig_system_ref_id := NULL;
292: END IF;
293: IF (l_cimv_rec.priced_item_yn = OKC_API.G_MISS_CHAR) THEN
294: l_cimv_rec.priced_item_yn := NULL;

Line 293: IF (l_cimv_rec.priced_item_yn = OKC_API.G_MISS_CHAR) THEN

289: END IF;
290: IF (l_cimv_rec.upg_orig_system_ref_id = OKC_API.G_MISS_NUM) THEN
291: l_cimv_rec.upg_orig_system_ref_id := NULL;
292: END IF;
293: IF (l_cimv_rec.priced_item_yn = OKC_API.G_MISS_CHAR) THEN
294: l_cimv_rec.priced_item_yn := NULL;
295: END IF;
296: IF (l_cimv_rec.created_by = OKC_API.G_MISS_NUM) THEN
297: l_cimv_rec.created_by := NULL;

Line 296: IF (l_cimv_rec.created_by = OKC_API.G_MISS_NUM) THEN

292: END IF;
293: IF (l_cimv_rec.priced_item_yn = OKC_API.G_MISS_CHAR) THEN
294: l_cimv_rec.priced_item_yn := NULL;
295: END IF;
296: IF (l_cimv_rec.created_by = OKC_API.G_MISS_NUM) THEN
297: l_cimv_rec.created_by := NULL;
298: END IF;
299: IF (l_cimv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
300: l_cimv_rec.creation_date := NULL;

Line 299: IF (l_cimv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

295: END IF;
296: IF (l_cimv_rec.created_by = OKC_API.G_MISS_NUM) THEN
297: l_cimv_rec.created_by := NULL;
298: END IF;
299: IF (l_cimv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
300: l_cimv_rec.creation_date := NULL;
301: END IF;
302: IF (l_cimv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
303: l_cimv_rec.last_updated_by := NULL;

Line 302: IF (l_cimv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

298: END IF;
299: IF (l_cimv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
300: l_cimv_rec.creation_date := NULL;
301: END IF;
302: IF (l_cimv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
303: l_cimv_rec.last_updated_by := NULL;
304: END IF;
305: IF (l_cimv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
306: l_cimv_rec.last_update_date := NULL;

Line 305: IF (l_cimv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

301: END IF;
302: IF (l_cimv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
303: l_cimv_rec.last_updated_by := NULL;
304: END IF;
305: IF (l_cimv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
306: l_cimv_rec.last_update_date := NULL;
307: END IF;
308: IF (l_cimv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
309: l_cimv_rec.last_update_login := NULL;

Line 308: IF (l_cimv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

304: END IF;
305: IF (l_cimv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
306: l_cimv_rec.last_update_date := NULL;
307: END IF;
308: IF (l_cimv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
309: l_cimv_rec.last_update_login := NULL;
310: END IF;
311: IF (l_cimv_rec.request_id = OKC_API.G_MISS_NUM) THEN
312: l_cimv_rec.request_id := NULL;

Line 311: IF (l_cimv_rec.request_id = OKC_API.G_MISS_NUM) THEN

307: END IF;
308: IF (l_cimv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
309: l_cimv_rec.last_update_login := NULL;
310: END IF;
311: IF (l_cimv_rec.request_id = OKC_API.G_MISS_NUM) THEN
312: l_cimv_rec.request_id := NULL;
313: END IF;
314: IF (l_cimv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
315: l_cimv_rec.program_application_id := NULL;

Line 314: IF (l_cimv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN

310: END IF;
311: IF (l_cimv_rec.request_id = OKC_API.G_MISS_NUM) THEN
312: l_cimv_rec.request_id := NULL;
313: END IF;
314: IF (l_cimv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
315: l_cimv_rec.program_application_id := NULL;
316: END IF;
317: IF (l_cimv_rec.program_id = OKC_API.G_MISS_NUM) THEN
318: l_cimv_rec.program_id := NULL;

Line 317: IF (l_cimv_rec.program_id = OKC_API.G_MISS_NUM) THEN

313: END IF;
314: IF (l_cimv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
315: l_cimv_rec.program_application_id := NULL;
316: END IF;
317: IF (l_cimv_rec.program_id = OKC_API.G_MISS_NUM) THEN
318: l_cimv_rec.program_id := NULL;
319: END IF;
320: IF (l_cimv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
321: l_cimv_rec.program_update_date := NULL;

Line 320: IF (l_cimv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN

316: END IF;
317: IF (l_cimv_rec.program_id = OKC_API.G_MISS_NUM) THEN
318: l_cimv_rec.program_id := NULL;
319: END IF;
320: IF (l_cimv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
321: l_cimv_rec.program_update_date := NULL;
322: END IF;
323:
324: IF (l_debug = 'Y') THEN

Line 359: x_return_status := OKC_API.G_RET_STS_SUCCESS;

355: okc_debug.Set_Indentation('OKC_CIM_PVT');
356: okc_debug.log('1000: Entered validate_cle_id', 2);
357: END IF;
358:
359: x_return_status := OKC_API.G_RET_STS_SUCCESS;
360: if (p_cimv_rec.cle_id = OKC_API.G_MISS_NUM) then
361: return;
362: end if;
363: if (p_cimv_rec.cle_id is NULL) then

Line 360: if (p_cimv_rec.cle_id = OKC_API.G_MISS_NUM) then

356: okc_debug.log('1000: Entered validate_cle_id', 2);
357: END IF;
358:
359: x_return_status := OKC_API.G_RET_STS_SUCCESS;
360: if (p_cimv_rec.cle_id = OKC_API.G_MISS_NUM) then
361: return;
362: end if;
363: if (p_cimv_rec.cle_id is NULL) then
364: OKC_API.set_message(p_app_name => g_app_name,

Line 364: OKC_API.set_message(p_app_name => g_app_name,

360: if (p_cimv_rec.cle_id = OKC_API.G_MISS_NUM) then
361: return;
362: end if;
363: if (p_cimv_rec.cle_id is NULL) then
364: OKC_API.set_message(p_app_name => g_app_name,
365: p_msg_name => G_REQUIRED_VALUE,
366: p_token1 => G_COL_NAME_TOKEN,
367: p_token1_value => 'CLE_ID');
368: raise G_EXCEPTION_HALT_VALIDATION;

Line 374: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CLE_ID');

370: open l_cle_csr;
371: fetch l_cle_csr into l_dummy_var;
372: close l_cle_csr;
373: if (l_dummy_var = '?') then
374: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CLE_ID');
375: raise G_EXCEPTION_HALT_VALIDATION;
376: end if;
377:
378: IF (l_debug = 'Y') THEN

Line 391: x_return_status := OKC_API.G_RET_STS_ERROR;

387: okc_debug.log('1200: Exiting validate_cle_id:G_EXCEPTION_HALT_VALIDATION Exception', 2);
388: okc_debug.Reset_Indentation;
389: END IF;
390:
391: x_return_status := OKC_API.G_RET_STS_ERROR;
392: when OTHERS then
393:
394: IF (l_debug = 'Y') THEN
395: okc_debug.log('1300: Exiting validate_cle_id:OTHERS Exception', 2);

Line 402: OKC_API.set_message(p_app_name => g_app_name,

398:
399: if l_cle_csr%ISOPEN then
400: close l_cle_csr;
401: end if;
402: OKC_API.set_message(p_app_name => g_app_name,
403: p_msg_name => g_unexpected_error,
404: p_token1 => g_sqlcode_token,
405: p_token1_value => sqlcode,
406: p_token2 => g_sqlerrm_token,

Line 408: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

404: p_token1 => g_sqlcode_token,
405: p_token1_value => sqlcode,
406: p_token2 => g_sqlerrm_token,
407: p_token2_value => sqlerrm);
408: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
409:
410: end validate_cle_id;
411:
412: -- Start of comments

Line 435: x_return_status := OKC_API.G_RET_STS_SUCCESS;

431: okc_debug.Set_Indentation('OKC_CIM_PVT');
432: okc_debug.log('1400: Entered validate_cle_id_for', 2);
433: END IF;
434:
435: x_return_status := OKC_API.G_RET_STS_SUCCESS;
436: if (p_cimv_rec.cle_id_for = OKC_API.G_MISS_NUM or p_cimv_rec.cle_id_for is NULL) then
437: return;
438: end if;
439: open l_cle_csr;

Line 436: if (p_cimv_rec.cle_id_for = OKC_API.G_MISS_NUM or p_cimv_rec.cle_id_for is NULL) then

432: okc_debug.log('1400: Entered validate_cle_id_for', 2);
433: END IF;
434:
435: x_return_status := OKC_API.G_RET_STS_SUCCESS;
436: if (p_cimv_rec.cle_id_for = OKC_API.G_MISS_NUM or p_cimv_rec.cle_id_for is NULL) then
437: return;
438: end if;
439: open l_cle_csr;
440: fetch l_cle_csr into l_dummy_var;

Line 443: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CLE_ID_FOR');

439: open l_cle_csr;
440: fetch l_cle_csr into l_dummy_var;
441: close l_cle_csr;
442: if (l_dummy_var = '?') then
443: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CLE_ID_FOR');
444: x_return_status := OKC_API.G_RET_STS_ERROR;
445: end if;
446:
447: IF (l_debug = 'Y') THEN

Line 444: x_return_status := OKC_API.G_RET_STS_ERROR;

440: fetch l_cle_csr into l_dummy_var;
441: close l_cle_csr;
442: if (l_dummy_var = '?') then
443: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CLE_ID_FOR');
444: x_return_status := OKC_API.G_RET_STS_ERROR;
445: end if;
446:
447: IF (l_debug = 'Y') THEN
448: okc_debug.log('1500: Leaving validate_cle_id_for', 2);

Line 463: OKC_API.set_message(p_app_name => g_app_name,

459:
460: if l_cle_csr%ISOPEN then
461: close l_cle_csr;
462: end if;
463: OKC_API.set_message(p_app_name => g_app_name,
464: p_msg_name => g_unexpected_error,
465: p_token1 => g_sqlcode_token,
466: p_token1_value => sqlcode,
467: p_token2 => g_sqlerrm_token,

Line 469: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

465: p_token1 => g_sqlcode_token,
466: p_token1_value => sqlcode,
467: p_token2 => g_sqlerrm_token,
468: p_token2_value => sqlerrm);
469: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
470:
471: end validate_cle_id_for;
472:
473: -- Start of comments

Line 496: x_return_status := OKC_API.G_RET_STS_SUCCESS;

492: okc_debug.Set_Indentation('OKC_CIM_PVT');
493: okc_debug.log('1700: Entered validate_chr_id', 2);
494: END IF;
495:
496: x_return_status := OKC_API.G_RET_STS_SUCCESS;
497: if (p_cimv_rec.chr_id = OKC_API.G_MISS_NUM or p_cimv_rec.chr_id is NULL) then
498: x_return_status := OKC_API.G_RET_STS_SUCCESS;
499: return;
500: end if;

Line 497: if (p_cimv_rec.chr_id = OKC_API.G_MISS_NUM or p_cimv_rec.chr_id is NULL) then

493: okc_debug.log('1700: Entered validate_chr_id', 2);
494: END IF;
495:
496: x_return_status := OKC_API.G_RET_STS_SUCCESS;
497: if (p_cimv_rec.chr_id = OKC_API.G_MISS_NUM or p_cimv_rec.chr_id is NULL) then
498: x_return_status := OKC_API.G_RET_STS_SUCCESS;
499: return;
500: end if;
501: open l_chr_csr;

Line 498: x_return_status := OKC_API.G_RET_STS_SUCCESS;

494: END IF;
495:
496: x_return_status := OKC_API.G_RET_STS_SUCCESS;
497: if (p_cimv_rec.chr_id = OKC_API.G_MISS_NUM or p_cimv_rec.chr_id is NULL) then
498: x_return_status := OKC_API.G_RET_STS_SUCCESS;
499: return;
500: end if;
501: open l_chr_csr;
502: fetch l_chr_csr into l_dummy_var;

Line 505: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CHR_ID');

501: open l_chr_csr;
502: fetch l_chr_csr into l_dummy_var;
503: close l_chr_csr;
504: if (l_dummy_var = '?') then
505: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CHR_ID');
506: x_return_status := OKC_API.G_RET_STS_ERROR;
507: end if;
508:
509: IF (l_debug = 'Y') THEN

Line 506: x_return_status := OKC_API.G_RET_STS_ERROR;

502: fetch l_chr_csr into l_dummy_var;
503: close l_chr_csr;
504: if (l_dummy_var = '?') then
505: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CHR_ID');
506: x_return_status := OKC_API.G_RET_STS_ERROR;
507: end if;
508:
509: IF (l_debug = 'Y') THEN
510: okc_debug.log('1800: Leaving validate_chr_id', 2);

Line 525: OKC_API.set_message(p_app_name => g_app_name,

521:
522: if l_chr_csr%ISOPEN then
523: close l_chr_csr;
524: end if;
525: OKC_API.set_message(p_app_name => g_app_name,
526: p_msg_name => g_unexpected_error,
527: p_token1 => g_sqlcode_token,
528: p_token1_value => sqlcode,
529: p_token2 => g_sqlerrm_token,

Line 531: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

527: p_token1 => g_sqlcode_token,
528: p_token1_value => sqlcode,
529: p_token2 => g_sqlerrm_token,
530: p_token2_value => sqlerrm);
531: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
532:
533: end validate_chr_id;
534:
535: -- Start of comments

Line 552: if (p_cimv_rec.exception_yn in ('Y','N',OKC_API.G_MISS_CHAR)) then

548: okc_debug.Set_Indentation('OKC_CIM_PVT');
549: okc_debug.log('2000: Entered validate_exception_yn', 2);
550: END IF;
551:
552: if (p_cimv_rec.exception_yn in ('Y','N',OKC_API.G_MISS_CHAR)) then
553: x_return_status := OKC_API.G_RET_STS_SUCCESS;
554: else
555: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'EXCEPTION_YN');
556: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 553: x_return_status := OKC_API.G_RET_STS_SUCCESS;

549: okc_debug.log('2000: Entered validate_exception_yn', 2);
550: END IF;
551:
552: if (p_cimv_rec.exception_yn in ('Y','N',OKC_API.G_MISS_CHAR)) then
553: x_return_status := OKC_API.G_RET_STS_SUCCESS;
554: else
555: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'EXCEPTION_YN');
556: x_return_status := OKC_API.G_RET_STS_ERROR;
557: end if;

Line 555: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'EXCEPTION_YN');

551:
552: if (p_cimv_rec.exception_yn in ('Y','N',OKC_API.G_MISS_CHAR)) then
553: x_return_status := OKC_API.G_RET_STS_SUCCESS;
554: else
555: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'EXCEPTION_YN');
556: x_return_status := OKC_API.G_RET_STS_ERROR;
557: end if;
558:
559: IF (l_debug = 'Y') THEN

Line 556: x_return_status := OKC_API.G_RET_STS_ERROR;

552: if (p_cimv_rec.exception_yn in ('Y','N',OKC_API.G_MISS_CHAR)) then
553: x_return_status := OKC_API.G_RET_STS_SUCCESS;
554: else
555: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'EXCEPTION_YN');
556: x_return_status := OKC_API.G_RET_STS_ERROR;
557: end if;
558:
559: IF (l_debug = 'Y') THEN
560: okc_debug.log('2050: Leaving validate_exception_yn ', 2);

Line 583: if (p_cimv_rec.priced_item_yn is NULL or p_cimv_rec.priced_item_yn in ('Y','N',OKC_API.G_MISS_CHAR)) then

579: okc_debug.Set_Indentation('OKC_CIM_PVT');
580: okc_debug.log('2100: Entered validate_priced_item_yn', 2);
581: END IF;
582:
583: if (p_cimv_rec.priced_item_yn is NULL or p_cimv_rec.priced_item_yn in ('Y','N',OKC_API.G_MISS_CHAR)) then
584: x_return_status := OKC_API.G_RET_STS_SUCCESS;
585: else
586: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PRICED_ITEM_YN');
587: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 584: x_return_status := OKC_API.G_RET_STS_SUCCESS;

580: okc_debug.log('2100: Entered validate_priced_item_yn', 2);
581: END IF;
582:
583: if (p_cimv_rec.priced_item_yn is NULL or p_cimv_rec.priced_item_yn in ('Y','N',OKC_API.G_MISS_CHAR)) then
584: x_return_status := OKC_API.G_RET_STS_SUCCESS;
585: else
586: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PRICED_ITEM_YN');
587: x_return_status := OKC_API.G_RET_STS_ERROR;
588: end if;

Line 586: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PRICED_ITEM_YN');

582:
583: if (p_cimv_rec.priced_item_yn is NULL or p_cimv_rec.priced_item_yn in ('Y','N',OKC_API.G_MISS_CHAR)) then
584: x_return_status := OKC_API.G_RET_STS_SUCCESS;
585: else
586: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PRICED_ITEM_YN');
587: x_return_status := OKC_API.G_RET_STS_ERROR;
588: end if;
589:
590: IF (l_debug = 'Y') THEN

Line 587: x_return_status := OKC_API.G_RET_STS_ERROR;

583: if (p_cimv_rec.priced_item_yn is NULL or p_cimv_rec.priced_item_yn in ('Y','N',OKC_API.G_MISS_CHAR)) then
584: x_return_status := OKC_API.G_RET_STS_SUCCESS;
585: else
586: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PRICED_ITEM_YN');
587: x_return_status := OKC_API.G_RET_STS_ERROR;
588: end if;
589:
590: IF (l_debug = 'Y') THEN
591: okc_debug.log('2150: Leaving validate_priced_item_yn ', 2);

Line 620: x_return_status := OKC_API.G_RET_STS_SUCCESS;

616: okc_debug.Set_Indentation('OKC_CIM_PVT');
617: okc_debug.log('2200: Entered validate_UOM_CODE', 2);
618: END IF;
619:
620: x_return_status := OKC_API.G_RET_STS_SUCCESS;
621: if (p_cimv_rec.UOM_CODE = OKC_API.G_MISS_CHAR
622: or p_cimv_rec.UOM_CODE is NULL) then
623: return;
624: end if;

Line 621: if (p_cimv_rec.UOM_CODE = OKC_API.G_MISS_CHAR

617: okc_debug.log('2200: Entered validate_UOM_CODE', 2);
618: END IF;
619:
620: x_return_status := OKC_API.G_RET_STS_SUCCESS;
621: if (p_cimv_rec.UOM_CODE = OKC_API.G_MISS_CHAR
622: or p_cimv_rec.UOM_CODE is NULL) then
623: return;
624: end if;
625: open l_okx_csr;

Line 629: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'UOM_CODE');

625: open l_okx_csr;
626: fetch l_okx_csr into l_dummy_var;
627: close l_okx_csr;
628: if (l_dummy_var = '?') then
629: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'UOM_CODE');
630: x_return_status := OKC_API.G_RET_STS_ERROR;
631: end if;
632:
633: IF (l_debug = 'Y') THEN

Line 630: x_return_status := OKC_API.G_RET_STS_ERROR;

626: fetch l_okx_csr into l_dummy_var;
627: close l_okx_csr;
628: if (l_dummy_var = '?') then
629: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'UOM_CODE');
630: x_return_status := OKC_API.G_RET_STS_ERROR;
631: end if;
632:
633: IF (l_debug = 'Y') THEN
634: okc_debug.log('2450: Leaving validate_UOM_CODE', 2);

Line 649: OKC_API.set_message(p_app_name => g_app_name,

645:
646: if l_okx_csr%ISOPEN then
647: close l_okx_csr;
648: end if;
649: OKC_API.set_message(p_app_name => g_app_name,
650: p_msg_name => g_unexpected_error,
651: p_token1 => g_sqlcode_token,
652: p_token1_value => sqlcode,
653: p_token2 => g_sqlerrm_token,

Line 655: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

651: p_token1 => g_sqlcode_token,
652: p_token1_value => sqlcode,
653: p_token2 => g_sqlerrm_token,
654: p_token2_value => sqlerrm);
655: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
656:
657: end validate_UOM_CODE;
658:
659: -- Start of comments

Line 695: x_return_status := OKC_API.G_RET_STS_SUCCESS;

691: okc_debug.Set_Indentation('OKC_CIM_PVT');
692: okc_debug.log('2500: Entered validate_JTOT_OBJECT1_CODE', 2);
693: END IF;
694:
695: x_return_status := OKC_API.G_RET_STS_SUCCESS;
696: if (p_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR or p_cimv_rec.jtot_object1_code is NULL) then
697: return;
698: end if;
699: --

Line 696: if (p_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR or p_cimv_rec.jtot_object1_code is NULL) then

692: okc_debug.log('2500: Entered validate_JTOT_OBJECT1_CODE', 2);
693: END IF;
694:
695: x_return_status := OKC_API.G_RET_STS_SUCCESS;
696: if (p_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR or p_cimv_rec.jtot_object1_code is NULL) then
697: return;
698: end if;
699: --
700:

Line 705: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'JTOT_OBJECT1_CODE');

701: open l_object1_csr;
702: fetch l_object1_csr into l_dummy_var;
703: close l_object1_csr;
704: if (l_dummy_var = '?') then
705: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'JTOT_OBJECT1_CODE');
706: x_return_status := OKC_API.G_RET_STS_ERROR;
707: end if;
708: IF (l_debug = 'Y') THEN
709: okc_debug.log('2600: Leaving validate_JTOT_OBJECT1_CODE', 2);

Line 706: x_return_status := OKC_API.G_RET_STS_ERROR;

702: fetch l_object1_csr into l_dummy_var;
703: close l_object1_csr;
704: if (l_dummy_var = '?') then
705: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'JTOT_OBJECT1_CODE');
706: x_return_status := OKC_API.G_RET_STS_ERROR;
707: end if;
708: IF (l_debug = 'Y') THEN
709: okc_debug.log('2600: Leaving validate_JTOT_OBJECT1_CODE', 2);
710: okc_debug.Reset_Indentation;

Line 724: OKC_API.set_message(p_app_name => g_app_name,

720:
721: if l_object1_csr%ISOPEN then
722: close l_object1_csr;
723: end if;
724: OKC_API.set_message(p_app_name => g_app_name,
725: p_msg_name => g_unexpected_error,
726: p_token1 => g_sqlcode_token,
727: p_token1_value => sqlcode,
728: p_token2 => g_sqlerrm_token,

Line 730: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

726: p_token1 => g_sqlcode_token,
727: p_token1_value => sqlcode,
728: p_token2 => g_sqlerrm_token,
729: p_token2_value => sqlerrm);
730: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
731:
732: end validate_JTOT_OBJECT1_CODE;
733:
734: -- Start of comments

Line 773: x_return_status := OKC_API.G_RET_STS_SUCCESS;

769: okc_debug.Set_Indentation('OKC_CIM_PVT');
770: okc_debug.log('2800: Entered validate_object1_id1', 2);
771: END IF;
772:
773: x_return_status := OKC_API.G_RET_STS_SUCCESS;
774: if (p_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR or p_cimv_rec.jtot_object1_code is NULL) then
775: return;
776: end if;
777: if (p_cimv_rec.object1_id1 = OKC_API.G_MISS_CHAR or p_cimv_rec.object1_id1 is NULL) then

Line 774: if (p_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR or p_cimv_rec.jtot_object1_code is NULL) then

770: okc_debug.log('2800: Entered validate_object1_id1', 2);
771: END IF;
772:
773: x_return_status := OKC_API.G_RET_STS_SUCCESS;
774: if (p_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR or p_cimv_rec.jtot_object1_code is NULL) then
775: return;
776: end if;
777: if (p_cimv_rec.object1_id1 = OKC_API.G_MISS_CHAR or p_cimv_rec.object1_id1 is NULL) then
778: return;

Line 777: if (p_cimv_rec.object1_id1 = OKC_API.G_MISS_CHAR or p_cimv_rec.object1_id1 is NULL) then

773: x_return_status := OKC_API.G_RET_STS_SUCCESS;
774: if (p_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR or p_cimv_rec.jtot_object1_code is NULL) then
775: return;
776: end if;
777: if (p_cimv_rec.object1_id1 = OKC_API.G_MISS_CHAR or p_cimv_rec.object1_id1 is NULL) then
778: return;
779: end if;
780: open l_object1_csr;
781: fetch l_object1_csr into l_from_table, l_where_clause;

Line 805: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'JTOT_OBJECT1_CODE');

801: okc_debug.log('3000: Exiting validate_object1_id1:e_source_not_exists Exception', 2);
802: okc_debug.Reset_Indentation;
803: END IF;
804:
805: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'JTOT_OBJECT1_CODE');
806: x_return_status := OKC_API.G_RET_STS_ERROR;
807: when e_column_not_exists then
808:
809: IF (l_debug = 'Y') THEN

Line 806: x_return_status := OKC_API.G_RET_STS_ERROR;

802: okc_debug.Reset_Indentation;
803: END IF;
804:
805: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'JTOT_OBJECT1_CODE');
806: x_return_status := OKC_API.G_RET_STS_ERROR;
807: when e_column_not_exists then
808:
809: IF (l_debug = 'Y') THEN
810: okc_debug.log('3100: Exiting validate_object1_id1:e_column_not_exists Exception', 2);

Line 814: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_from_table||'.ID1');

810: okc_debug.log('3100: Exiting validate_object1_id1:e_column_not_exists Exception', 2);
811: okc_debug.Reset_Indentation;
812: END IF;
813:
814: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_from_table||'.ID1');
815: x_return_status := OKC_API.G_RET_STS_ERROR;
816: when e_no_data_found then
817:
818: IF (l_debug = 'Y') THEN

Line 815: x_return_status := OKC_API.G_RET_STS_ERROR;

811: okc_debug.Reset_Indentation;
812: END IF;
813:
814: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_from_table||'.ID1');
815: x_return_status := OKC_API.G_RET_STS_ERROR;
816: when e_no_data_found then
817:
818: IF (l_debug = 'Y') THEN
819: okc_debug.log('3200: Exiting validate_object1_id1:e_no_data_found Exception', 2);

Line 823: OKC_API.set_message(G_APP_NAME,'OKC_INVALID_ITEM');

819: okc_debug.log('3200: Exiting validate_object1_id1:e_no_data_found Exception', 2);
820: okc_debug.Reset_Indentation;
821: END IF;
822:
823: OKC_API.set_message(G_APP_NAME,'OKC_INVALID_ITEM');
824: x_return_status := OKC_API.G_RET_STS_ERROR;
825: when e_too_many_rows then
826:
827: IF (l_debug = 'Y') THEN

Line 824: x_return_status := OKC_API.G_RET_STS_ERROR;

820: okc_debug.Reset_Indentation;
821: END IF;
822:
823: OKC_API.set_message(G_APP_NAME,'OKC_INVALID_ITEM');
824: x_return_status := OKC_API.G_RET_STS_ERROR;
825: when e_too_many_rows then
826:
827: IF (l_debug = 'Y') THEN
828: okc_debug.log('3300: Exiting validate_object1_id1:e_too_many_rows Exception', 2);

Line 832: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_from_table||'.ID1');

828: okc_debug.log('3300: Exiting validate_object1_id1:e_too_many_rows Exception', 2);
829: okc_debug.Reset_Indentation;
830: END IF;
831:
832: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_from_table||'.ID1');
833: x_return_status := OKC_API.G_RET_STS_ERROR;
834: when OTHERS then
835:
836: IF (l_debug = 'Y') THEN

Line 833: x_return_status := OKC_API.G_RET_STS_ERROR;

829: okc_debug.Reset_Indentation;
830: END IF;
831:
832: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_from_table||'.ID1');
833: x_return_status := OKC_API.G_RET_STS_ERROR;
834: when OTHERS then
835:
836: IF (l_debug = 'Y') THEN
837: okc_debug.log('3400: Exiting validate_object1_id1:OTHERS Exception', 2);

Line 844: OKC_API.set_message(p_app_name => g_app_name,

840:
841: if l_object1_csr%ISOPEN then
842: close l_object1_csr;
843: end if;
844: OKC_API.set_message(p_app_name => g_app_name,
845: p_msg_name => g_unexpected_error,
846: p_token1 => g_sqlcode_token,
847: p_token1_value => sqlcode,
848: p_token2 => g_sqlerrm_token,

Line 850: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

846: p_token1 => g_sqlcode_token,
847: p_token1_value => sqlcode,
848: p_token2 => g_sqlerrm_token,
849: p_token2_value => sqlerrm);
850: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
851:
852: end validate_object1_id1;
853:
854: -- Start of comments

Line 877: x_return_status := OKC_API.G_RET_STS_SUCCESS;

873: okc_debug.Set_Indentation('OKC_CIM_PVT');
874: okc_debug.log('3500: Entered validate_dnz_chr_id', 2);
875: END IF;
876:
877: x_return_status := OKC_API.G_RET_STS_SUCCESS;
878: if (p_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) then
879: return;
880: end if;
881: if (p_cimv_rec.dnz_chr_id is NULL) then

Line 878: if (p_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) then

874: okc_debug.log('3500: Entered validate_dnz_chr_id', 2);
875: END IF;
876:
877: x_return_status := OKC_API.G_RET_STS_SUCCESS;
878: if (p_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) then
879: return;
880: end if;
881: if (p_cimv_rec.dnz_chr_id is NULL) then
882: OKC_API.set_message(p_app_name => g_app_name,

Line 882: OKC_API.set_message(p_app_name => g_app_name,

878: if (p_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM) then
879: return;
880: end if;
881: if (p_cimv_rec.dnz_chr_id is NULL) then
882: OKC_API.set_message(p_app_name => g_app_name,
883: p_msg_name => G_REQUIRED_VALUE,
884: p_token1 => G_COL_NAME_TOKEN,
885: p_token1_value => 'DNZ_CHR_ID');
886: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 886: x_return_status := OKC_API.G_RET_STS_ERROR;

882: OKC_API.set_message(p_app_name => g_app_name,
883: p_msg_name => G_REQUIRED_VALUE,
884: p_token1 => G_COL_NAME_TOKEN,
885: p_token1_value => 'DNZ_CHR_ID');
886: x_return_status := OKC_API.G_RET_STS_ERROR;
887: return;
888: end if;
889: open Kt_Hr_Mj_Vr;
890: fetch Kt_Hr_Mj_Vr into l_dummy;

Line 893: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DNZ_CHR_ID');

889: open Kt_Hr_Mj_Vr;
890: fetch Kt_Hr_Mj_Vr into l_dummy;
891: close Kt_Hr_Mj_Vr;
892: if (l_dummy='?') then
893: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DNZ_CHR_ID');
894: x_return_status := OKC_API.G_RET_STS_ERROR;
895: return;
896: end if;
897:

Line 894: x_return_status := OKC_API.G_RET_STS_ERROR;

890: fetch Kt_Hr_Mj_Vr into l_dummy;
891: close Kt_Hr_Mj_Vr;
892: if (l_dummy='?') then
893: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DNZ_CHR_ID');
894: x_return_status := OKC_API.G_RET_STS_ERROR;
895: return;
896: end if;
897:
898: IF (l_debug = 'Y') THEN

Line 911: OKC_API.set_message(p_app_name => g_app_name,

907: okc_debug.log('3700: Exiting validate_dnz_chr_id:OTHERS Exception', 2);
908: okc_debug.Reset_Indentation;
909: END IF;
910:
911: OKC_API.set_message(p_app_name => g_app_name,
912: p_msg_name => g_unexpected_error,
913: p_token1 => g_sqlcode_token,
914: p_token1_value => sqlcode,
915: p_token2 => g_sqlerrm_token,

Line 917: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

913: p_token1 => g_sqlcode_token,
914: p_token1_value => sqlcode,
915: p_token2 => g_sqlerrm_token,
916: p_token2_value => sqlerrm);
917: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
918:
919: end validate_dnz_chr_id;
920:
921: /*+++++++++++++End of hand code +++++++++++++++++++*/

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

924: -------------------------------------------
925: FUNCTION Validate_Attributes (
926: p_cimv_rec IN cimv_rec_type
927: ) RETURN VARCHAR2 IS
928: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
929: /*-------------Commented in favor of hand code------
930: BEGIN
931:
932: IF (l_debug = 'Y') THEN

Line 937: IF p_cimv_rec.id = OKC_API.G_MISS_NUM OR

933: okc_debug.Set_Indentation('OKC_CIM_PVT');
934: okc_debug.log('3800: Entered Validate_Attributes', 2);
935: END IF;
936:
937: IF p_cimv_rec.id = OKC_API.G_MISS_NUM OR
938: p_cimv_rec.id IS NULL
939: THEN
940: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
941: l_return_status := OKC_API.G_RET_STS_ERROR;

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

936:
937: IF p_cimv_rec.id = OKC_API.G_MISS_NUM OR
938: p_cimv_rec.id IS NULL
939: THEN
940: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
941: l_return_status := OKC_API.G_RET_STS_ERROR;
942: ELSIF p_cimv_rec.object_version_number = OKC_API.G_MISS_NUM OR
943: p_cimv_rec.object_version_number IS NULL
944: THEN

Line 941: l_return_status := OKC_API.G_RET_STS_ERROR;

937: IF p_cimv_rec.id = OKC_API.G_MISS_NUM OR
938: p_cimv_rec.id IS NULL
939: THEN
940: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
941: l_return_status := OKC_API.G_RET_STS_ERROR;
942: ELSIF p_cimv_rec.object_version_number = OKC_API.G_MISS_NUM OR
943: p_cimv_rec.object_version_number IS NULL
944: THEN
945: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 942: ELSIF p_cimv_rec.object_version_number = OKC_API.G_MISS_NUM OR

938: p_cimv_rec.id IS NULL
939: THEN
940: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
941: l_return_status := OKC_API.G_RET_STS_ERROR;
942: ELSIF p_cimv_rec.object_version_number = OKC_API.G_MISS_NUM OR
943: p_cimv_rec.object_version_number IS NULL
944: THEN
945: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
946: l_return_status := OKC_API.G_RET_STS_ERROR;

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

941: l_return_status := OKC_API.G_RET_STS_ERROR;
942: ELSIF p_cimv_rec.object_version_number = OKC_API.G_MISS_NUM OR
943: p_cimv_rec.object_version_number IS NULL
944: THEN
945: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
946: l_return_status := OKC_API.G_RET_STS_ERROR;
947: ELSIF p_cimv_rec.cle_id = OKC_API.G_MISS_NUM OR
948: p_cimv_rec.cle_id IS NULL
949: THEN

Line 946: l_return_status := OKC_API.G_RET_STS_ERROR;

942: ELSIF p_cimv_rec.object_version_number = OKC_API.G_MISS_NUM OR
943: p_cimv_rec.object_version_number IS NULL
944: THEN
945: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
946: l_return_status := OKC_API.G_RET_STS_ERROR;
947: ELSIF p_cimv_rec.cle_id = OKC_API.G_MISS_NUM OR
948: p_cimv_rec.cle_id IS NULL
949: THEN
950: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cle_id');

Line 947: ELSIF p_cimv_rec.cle_id = OKC_API.G_MISS_NUM OR

943: p_cimv_rec.object_version_number IS NULL
944: THEN
945: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
946: l_return_status := OKC_API.G_RET_STS_ERROR;
947: ELSIF p_cimv_rec.cle_id = OKC_API.G_MISS_NUM OR
948: p_cimv_rec.cle_id IS NULL
949: THEN
950: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cle_id');
951: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 950: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cle_id');

946: l_return_status := OKC_API.G_RET_STS_ERROR;
947: ELSIF p_cimv_rec.cle_id = OKC_API.G_MISS_NUM OR
948: p_cimv_rec.cle_id IS NULL
949: THEN
950: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cle_id');
951: l_return_status := OKC_API.G_RET_STS_ERROR;
952: ELSIF p_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR
953: p_cimv_rec.dnz_chr_id IS NULL
954: THEN

Line 951: l_return_status := OKC_API.G_RET_STS_ERROR;

947: ELSIF p_cimv_rec.cle_id = OKC_API.G_MISS_NUM OR
948: p_cimv_rec.cle_id IS NULL
949: THEN
950: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cle_id');
951: l_return_status := OKC_API.G_RET_STS_ERROR;
952: ELSIF p_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR
953: p_cimv_rec.dnz_chr_id IS NULL
954: THEN
955: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dnz_chr_id');

Line 952: ELSIF p_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR

948: p_cimv_rec.cle_id IS NULL
949: THEN
950: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cle_id');
951: l_return_status := OKC_API.G_RET_STS_ERROR;
952: ELSIF p_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR
953: p_cimv_rec.dnz_chr_id IS NULL
954: THEN
955: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dnz_chr_id');
956: l_return_status := OKC_API.G_RET_STS_ERROR;

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

951: l_return_status := OKC_API.G_RET_STS_ERROR;
952: ELSIF p_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR
953: p_cimv_rec.dnz_chr_id IS NULL
954: THEN
955: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dnz_chr_id');
956: l_return_status := OKC_API.G_RET_STS_ERROR;
957: ELSIF p_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR OR
958: p_cimv_rec.exception_yn IS NULL
959: THEN

Line 956: l_return_status := OKC_API.G_RET_STS_ERROR;

952: ELSIF p_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM OR
953: p_cimv_rec.dnz_chr_id IS NULL
954: THEN
955: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dnz_chr_id');
956: l_return_status := OKC_API.G_RET_STS_ERROR;
957: ELSIF p_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR OR
958: p_cimv_rec.exception_yn IS NULL
959: THEN
960: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'exception_yn');

Line 957: ELSIF p_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR OR

953: p_cimv_rec.dnz_chr_id IS NULL
954: THEN
955: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dnz_chr_id');
956: l_return_status := OKC_API.G_RET_STS_ERROR;
957: ELSIF p_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR OR
958: p_cimv_rec.exception_yn IS NULL
959: THEN
960: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'exception_yn');
961: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 960: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'exception_yn');

956: l_return_status := OKC_API.G_RET_STS_ERROR;
957: ELSIF p_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR OR
958: p_cimv_rec.exception_yn IS NULL
959: THEN
960: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'exception_yn');
961: l_return_status := OKC_API.G_RET_STS_ERROR;
962: END IF;
963:
964: IF (l_debug = 'Y') THEN

Line 961: l_return_status := OKC_API.G_RET_STS_ERROR;

957: ELSIF p_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR OR
958: p_cimv_rec.exception_yn IS NULL
959: THEN
960: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'exception_yn');
961: l_return_status := OKC_API.G_RET_STS_ERROR;
962: END IF;
963:
964: IF (l_debug = 'Y') THEN
965: okc_debug.log('3850: Leaving Validate_Attributes ', 2);

Line 974: x_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

970:
971: END Validate_Attributes;
972: ---------------End of the commented code-----------*/
973: /*+++++++++++++Start of hand code +++++++++++++++++*/
974: x_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
975: BEGIN
976: -- call each column-level validation
977: --
978: validate_cle_id(x_return_status => l_return_status,

Line 980: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

976: -- call each column-level validation
977: --
978: validate_cle_id(x_return_status => l_return_status,
979: p_cimv_rec => p_cimv_rec);
980: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
981: return OKC_API.G_RET_STS_UNEXP_ERROR;
982: end if;
983: if (l_return_status = OKC_API.G_RET_STS_ERROR
984: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

Line 981: return OKC_API.G_RET_STS_UNEXP_ERROR;

977: --
978: validate_cle_id(x_return_status => l_return_status,
979: p_cimv_rec => p_cimv_rec);
980: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
981: return OKC_API.G_RET_STS_UNEXP_ERROR;
982: end if;
983: if (l_return_status = OKC_API.G_RET_STS_ERROR
984: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
985: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 983: if (l_return_status = OKC_API.G_RET_STS_ERROR

979: p_cimv_rec => p_cimv_rec);
980: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
981: return OKC_API.G_RET_STS_UNEXP_ERROR;
982: end if;
983: if (l_return_status = OKC_API.G_RET_STS_ERROR
984: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
985: x_return_status := OKC_API.G_RET_STS_ERROR;
986: end if;
987: --

Line 984: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

980: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
981: return OKC_API.G_RET_STS_UNEXP_ERROR;
982: end if;
983: if (l_return_status = OKC_API.G_RET_STS_ERROR
984: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
985: x_return_status := OKC_API.G_RET_STS_ERROR;
986: end if;
987: --
988: validate_cle_id_for(x_return_status => l_return_status,

Line 985: x_return_status := OKC_API.G_RET_STS_ERROR;

981: return OKC_API.G_RET_STS_UNEXP_ERROR;
982: end if;
983: if (l_return_status = OKC_API.G_RET_STS_ERROR
984: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
985: x_return_status := OKC_API.G_RET_STS_ERROR;
986: end if;
987: --
988: validate_cle_id_for(x_return_status => l_return_status,
989: p_cimv_rec => p_cimv_rec);

Line 990: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

986: end if;
987: --
988: validate_cle_id_for(x_return_status => l_return_status,
989: p_cimv_rec => p_cimv_rec);
990: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
991: return OKC_API.G_RET_STS_UNEXP_ERROR;
992: end if;
993: if (l_return_status = OKC_API.G_RET_STS_ERROR
994: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

Line 991: return OKC_API.G_RET_STS_UNEXP_ERROR;

987: --
988: validate_cle_id_for(x_return_status => l_return_status,
989: p_cimv_rec => p_cimv_rec);
990: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
991: return OKC_API.G_RET_STS_UNEXP_ERROR;
992: end if;
993: if (l_return_status = OKC_API.G_RET_STS_ERROR
994: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
995: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 993: if (l_return_status = OKC_API.G_RET_STS_ERROR

989: p_cimv_rec => p_cimv_rec);
990: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
991: return OKC_API.G_RET_STS_UNEXP_ERROR;
992: end if;
993: if (l_return_status = OKC_API.G_RET_STS_ERROR
994: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
995: x_return_status := OKC_API.G_RET_STS_ERROR;
996: end if;
997: --

Line 994: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

990: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
991: return OKC_API.G_RET_STS_UNEXP_ERROR;
992: end if;
993: if (l_return_status = OKC_API.G_RET_STS_ERROR
994: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
995: x_return_status := OKC_API.G_RET_STS_ERROR;
996: end if;
997: --
998: validate_chr_id(x_return_status => l_return_status,

Line 995: x_return_status := OKC_API.G_RET_STS_ERROR;

991: return OKC_API.G_RET_STS_UNEXP_ERROR;
992: end if;
993: if (l_return_status = OKC_API.G_RET_STS_ERROR
994: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
995: x_return_status := OKC_API.G_RET_STS_ERROR;
996: end if;
997: --
998: validate_chr_id(x_return_status => l_return_status,
999: p_cimv_rec => p_cimv_rec);

Line 1000: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

996: end if;
997: --
998: validate_chr_id(x_return_status => l_return_status,
999: p_cimv_rec => p_cimv_rec);
1000: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1001: return OKC_API.G_RET_STS_UNEXP_ERROR;
1002: end if;
1003: if (l_return_status = OKC_API.G_RET_STS_ERROR
1004: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

Line 1001: return OKC_API.G_RET_STS_UNEXP_ERROR;

997: --
998: validate_chr_id(x_return_status => l_return_status,
999: p_cimv_rec => p_cimv_rec);
1000: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1001: return OKC_API.G_RET_STS_UNEXP_ERROR;
1002: end if;
1003: if (l_return_status = OKC_API.G_RET_STS_ERROR
1004: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1005: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1003: if (l_return_status = OKC_API.G_RET_STS_ERROR

999: p_cimv_rec => p_cimv_rec);
1000: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1001: return OKC_API.G_RET_STS_UNEXP_ERROR;
1002: end if;
1003: if (l_return_status = OKC_API.G_RET_STS_ERROR
1004: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1005: x_return_status := OKC_API.G_RET_STS_ERROR;
1006: end if;
1007: --

Line 1004: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

1000: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1001: return OKC_API.G_RET_STS_UNEXP_ERROR;
1002: end if;
1003: if (l_return_status = OKC_API.G_RET_STS_ERROR
1004: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1005: x_return_status := OKC_API.G_RET_STS_ERROR;
1006: end if;
1007: --
1008: validate_exception_yn(x_return_status => l_return_status,

Line 1005: x_return_status := OKC_API.G_RET_STS_ERROR;

1001: return OKC_API.G_RET_STS_UNEXP_ERROR;
1002: end if;
1003: if (l_return_status = OKC_API.G_RET_STS_ERROR
1004: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1005: x_return_status := OKC_API.G_RET_STS_ERROR;
1006: end if;
1007: --
1008: validate_exception_yn(x_return_status => l_return_status,
1009: p_cimv_rec => p_cimv_rec);

Line 1010: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1006: end if;
1007: --
1008: validate_exception_yn(x_return_status => l_return_status,
1009: p_cimv_rec => p_cimv_rec);
1010: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1011: return OKC_API.G_RET_STS_UNEXP_ERROR;
1012: end if;
1013: if (l_return_status = OKC_API.G_RET_STS_ERROR
1014: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

Line 1011: return OKC_API.G_RET_STS_UNEXP_ERROR;

1007: --
1008: validate_exception_yn(x_return_status => l_return_status,
1009: p_cimv_rec => p_cimv_rec);
1010: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1011: return OKC_API.G_RET_STS_UNEXP_ERROR;
1012: end if;
1013: if (l_return_status = OKC_API.G_RET_STS_ERROR
1014: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1015: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1013: if (l_return_status = OKC_API.G_RET_STS_ERROR

1009: p_cimv_rec => p_cimv_rec);
1010: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1011: return OKC_API.G_RET_STS_UNEXP_ERROR;
1012: end if;
1013: if (l_return_status = OKC_API.G_RET_STS_ERROR
1014: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1015: x_return_status := OKC_API.G_RET_STS_ERROR;
1016: end if;
1017: --

Line 1014: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

1010: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1011: return OKC_API.G_RET_STS_UNEXP_ERROR;
1012: end if;
1013: if (l_return_status = OKC_API.G_RET_STS_ERROR
1014: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1015: x_return_status := OKC_API.G_RET_STS_ERROR;
1016: end if;
1017: --
1018: validate_priced_item_yn(x_return_status => l_return_status,

Line 1015: x_return_status := OKC_API.G_RET_STS_ERROR;

1011: return OKC_API.G_RET_STS_UNEXP_ERROR;
1012: end if;
1013: if (l_return_status = OKC_API.G_RET_STS_ERROR
1014: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1015: x_return_status := OKC_API.G_RET_STS_ERROR;
1016: end if;
1017: --
1018: validate_priced_item_yn(x_return_status => l_return_status,
1019: p_cimv_rec => p_cimv_rec);

Line 1020: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1016: end if;
1017: --
1018: validate_priced_item_yn(x_return_status => l_return_status,
1019: p_cimv_rec => p_cimv_rec);
1020: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1021: return OKC_API.G_RET_STS_UNEXP_ERROR;
1022: end if;
1023: if (l_return_status = OKC_API.G_RET_STS_ERROR
1024: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

Line 1021: return OKC_API.G_RET_STS_UNEXP_ERROR;

1017: --
1018: validate_priced_item_yn(x_return_status => l_return_status,
1019: p_cimv_rec => p_cimv_rec);
1020: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1021: return OKC_API.G_RET_STS_UNEXP_ERROR;
1022: end if;
1023: if (l_return_status = OKC_API.G_RET_STS_ERROR
1024: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1025: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1023: if (l_return_status = OKC_API.G_RET_STS_ERROR

1019: p_cimv_rec => p_cimv_rec);
1020: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1021: return OKC_API.G_RET_STS_UNEXP_ERROR;
1022: end if;
1023: if (l_return_status = OKC_API.G_RET_STS_ERROR
1024: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1025: x_return_status := OKC_API.G_RET_STS_ERROR;
1026: end if;
1027: --

Line 1024: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

1020: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1021: return OKC_API.G_RET_STS_UNEXP_ERROR;
1022: end if;
1023: if (l_return_status = OKC_API.G_RET_STS_ERROR
1024: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1025: x_return_status := OKC_API.G_RET_STS_ERROR;
1026: end if;
1027: --
1028: validate_UOM_CODE(x_return_status => l_return_status,

Line 1025: x_return_status := OKC_API.G_RET_STS_ERROR;

1021: return OKC_API.G_RET_STS_UNEXP_ERROR;
1022: end if;
1023: if (l_return_status = OKC_API.G_RET_STS_ERROR
1024: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1025: x_return_status := OKC_API.G_RET_STS_ERROR;
1026: end if;
1027: --
1028: validate_UOM_CODE(x_return_status => l_return_status,
1029: p_cimv_rec => p_cimv_rec);

Line 1030: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1026: end if;
1027: --
1028: validate_UOM_CODE(x_return_status => l_return_status,
1029: p_cimv_rec => p_cimv_rec);
1030: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1031: return OKC_API.G_RET_STS_UNEXP_ERROR;
1032: end if;
1033: if (l_return_status = OKC_API.G_RET_STS_ERROR
1034: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

Line 1031: return OKC_API.G_RET_STS_UNEXP_ERROR;

1027: --
1028: validate_UOM_CODE(x_return_status => l_return_status,
1029: p_cimv_rec => p_cimv_rec);
1030: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1031: return OKC_API.G_RET_STS_UNEXP_ERROR;
1032: end if;
1033: if (l_return_status = OKC_API.G_RET_STS_ERROR
1034: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1035: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1033: if (l_return_status = OKC_API.G_RET_STS_ERROR

1029: p_cimv_rec => p_cimv_rec);
1030: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1031: return OKC_API.G_RET_STS_UNEXP_ERROR;
1032: end if;
1033: if (l_return_status = OKC_API.G_RET_STS_ERROR
1034: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1035: x_return_status := OKC_API.G_RET_STS_ERROR;
1036: end if;
1037: --

Line 1034: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

1030: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1031: return OKC_API.G_RET_STS_UNEXP_ERROR;
1032: end if;
1033: if (l_return_status = OKC_API.G_RET_STS_ERROR
1034: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1035: x_return_status := OKC_API.G_RET_STS_ERROR;
1036: end if;
1037: --
1038: validate_dnz_chr_id(x_return_status => l_return_status,

Line 1035: x_return_status := OKC_API.G_RET_STS_ERROR;

1031: return OKC_API.G_RET_STS_UNEXP_ERROR;
1032: end if;
1033: if (l_return_status = OKC_API.G_RET_STS_ERROR
1034: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1035: x_return_status := OKC_API.G_RET_STS_ERROR;
1036: end if;
1037: --
1038: validate_dnz_chr_id(x_return_status => l_return_status,
1039: p_cimv_rec => p_cimv_rec);

Line 1040: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1036: end if;
1037: --
1038: validate_dnz_chr_id(x_return_status => l_return_status,
1039: p_cimv_rec => p_cimv_rec);
1040: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1041: return OKC_API.G_RET_STS_UNEXP_ERROR;
1042: end if;
1043: if (l_return_status = OKC_API.G_RET_STS_ERROR
1044: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

Line 1041: return OKC_API.G_RET_STS_UNEXP_ERROR;

1037: --
1038: validate_dnz_chr_id(x_return_status => l_return_status,
1039: p_cimv_rec => p_cimv_rec);
1040: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1041: return OKC_API.G_RET_STS_UNEXP_ERROR;
1042: end if;
1043: if (l_return_status = OKC_API.G_RET_STS_ERROR
1044: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1045: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1043: if (l_return_status = OKC_API.G_RET_STS_ERROR

1039: p_cimv_rec => p_cimv_rec);
1040: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1041: return OKC_API.G_RET_STS_UNEXP_ERROR;
1042: end if;
1043: if (l_return_status = OKC_API.G_RET_STS_ERROR
1044: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1045: x_return_status := OKC_API.G_RET_STS_ERROR;
1046: end if;
1047: --

Line 1044: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

1040: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1041: return OKC_API.G_RET_STS_UNEXP_ERROR;
1042: end if;
1043: if (l_return_status = OKC_API.G_RET_STS_ERROR
1044: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1045: x_return_status := OKC_API.G_RET_STS_ERROR;
1046: end if;
1047: --
1048: IF (l_debug = 'Y') THEN

Line 1045: x_return_status := OKC_API.G_RET_STS_ERROR;

1041: return OKC_API.G_RET_STS_UNEXP_ERROR;
1042: end if;
1043: if (l_return_status = OKC_API.G_RET_STS_ERROR
1044: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1045: x_return_status := OKC_API.G_RET_STS_ERROR;
1046: end if;
1047: --
1048: IF (l_debug = 'Y') THEN
1049: okc_debug.log('3860: Leaving Validate_Attributes ', 2);

Line 1057: OKC_API.set_message(p_app_name => g_app_name,

1053: return x_return_status;
1054: exception
1055: when OTHERS then
1056: -- store SQL error message on message stack for caller
1057: OKC_API.set_message(p_app_name => g_app_name,
1058: p_msg_name => g_unexpected_error,
1059: p_token1 => g_sqlcode_token,
1060: p_token1_value => sqlcode,
1061: p_token2 => g_sqlerrm_token,

Line 1063: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1059: p_token1 => g_sqlcode_token,
1060: p_token1_value => sqlcode,
1061: p_token2 => g_sqlerrm_token,
1062: p_token2_value => sqlerrm);
1063: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1064: return x_return_status;
1065: END Validate_Attributes;
1066: /*+++++++++++++End of hand code +++++++++++++++++++*/
1067:

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

1073: ---------------------------------------
1074: FUNCTION Validate_Record (
1075: p_cimv_rec IN cimv_rec_type
1076: ) RETURN VARCHAR2 IS
1077: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1078: /*+++++++++++++Start of hand code +++++++++++++++++*/
1079: l_dummy_var VARCHAR2(1) := '?';
1080: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1081: -- indirection

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

1076: ) RETURN VARCHAR2 IS
1077: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1078: /*+++++++++++++Start of hand code +++++++++++++++++*/
1079: l_dummy_var VARCHAR2(1) := '?';
1080: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1081: -- indirection
1082: l_access_level VARCHAR2(1);
1083: l_lse_id NUMBER;
1084:

Line 1103: if ((p_cimv_rec.chr_id IS NOT NULL and p_cimv_rec.chr_id <> OKC_API.G_MISS_NUM) and

1099: okc_debug.Set_Indentation('OKC_CIM_PVT');
1100: okc_debug.log('3900: Entered Validate_Record', 2);
1101: END IF;
1102:
1103: if ((p_cimv_rec.chr_id IS NOT NULL and p_cimv_rec.chr_id <> OKC_API.G_MISS_NUM) and
1104: (p_cimv_rec.cle_id_for IS NOT NULL and p_cimv_rec.cle_id_for <> OKC_API.G_MISS_NUM)) then
1105: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CHR_ID, CLE_ID_FOR');
1106: l_return_status := OKC_API.G_RET_STS_ERROR;
1107: end if;

Line 1104: (p_cimv_rec.cle_id_for IS NOT NULL and p_cimv_rec.cle_id_for <> OKC_API.G_MISS_NUM)) then

1100: okc_debug.log('3900: Entered Validate_Record', 2);
1101: END IF;
1102:
1103: if ((p_cimv_rec.chr_id IS NOT NULL and p_cimv_rec.chr_id <> OKC_API.G_MISS_NUM) and
1104: (p_cimv_rec.cle_id_for IS NOT NULL and p_cimv_rec.cle_id_for <> OKC_API.G_MISS_NUM)) then
1105: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CHR_ID, CLE_ID_FOR');
1106: l_return_status := OKC_API.G_RET_STS_ERROR;
1107: end if;
1108: if (l_return_status = OKC_API.G_RET_STS_ERROR

Line 1105: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CHR_ID, CLE_ID_FOR');

1101: END IF;
1102:
1103: if ((p_cimv_rec.chr_id IS NOT NULL and p_cimv_rec.chr_id <> OKC_API.G_MISS_NUM) and
1104: (p_cimv_rec.cle_id_for IS NOT NULL and p_cimv_rec.cle_id_for <> OKC_API.G_MISS_NUM)) then
1105: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CHR_ID, CLE_ID_FOR');
1106: l_return_status := OKC_API.G_RET_STS_ERROR;
1107: end if;
1108: if (l_return_status = OKC_API.G_RET_STS_ERROR
1109: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

Line 1106: l_return_status := OKC_API.G_RET_STS_ERROR;

1102:
1103: if ((p_cimv_rec.chr_id IS NOT NULL and p_cimv_rec.chr_id <> OKC_API.G_MISS_NUM) and
1104: (p_cimv_rec.cle_id_for IS NOT NULL and p_cimv_rec.cle_id_for <> OKC_API.G_MISS_NUM)) then
1105: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CHR_ID, CLE_ID_FOR');
1106: l_return_status := OKC_API.G_RET_STS_ERROR;
1107: end if;
1108: if (l_return_status = OKC_API.G_RET_STS_ERROR
1109: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1110: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1108: if (l_return_status = OKC_API.G_RET_STS_ERROR

1104: (p_cimv_rec.cle_id_for IS NOT NULL and p_cimv_rec.cle_id_for <> OKC_API.G_MISS_NUM)) then
1105: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CHR_ID, CLE_ID_FOR');
1106: l_return_status := OKC_API.G_RET_STS_ERROR;
1107: end if;
1108: if (l_return_status = OKC_API.G_RET_STS_ERROR
1109: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1110: x_return_status := OKC_API.G_RET_STS_ERROR;
1111: end if;
1112:

Line 1109: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

1105: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CHR_ID, CLE_ID_FOR');
1106: l_return_status := OKC_API.G_RET_STS_ERROR;
1107: end if;
1108: if (l_return_status = OKC_API.G_RET_STS_ERROR
1109: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1110: x_return_status := OKC_API.G_RET_STS_ERROR;
1111: end if;
1112:
1113: -- indirection

Line 1110: x_return_status := OKC_API.G_RET_STS_ERROR;

1106: l_return_status := OKC_API.G_RET_STS_ERROR;
1107: end if;
1108: if (l_return_status = OKC_API.G_RET_STS_ERROR
1109: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1110: x_return_status := OKC_API.G_RET_STS_ERROR;
1111: end if;
1112:
1113: -- indirection
1114: Open c_lse_id;

Line 1126: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1122: --
1123:
1124: validate_JTOT_OBJECT1_CODE(x_return_status => l_return_status,
1125: p_cimv_rec => p_cimv_rec);
1126: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1127: IF (l_debug = 'Y') THEN
1128: okc_debug.log('3910: Exiting Validate_jtot_object1_code in validate_record:unexp err', 2);
1129: okc_debug.Reset_Indentation;
1130: END IF;

Line 1131: return OKC_API.G_RET_STS_UNEXP_ERROR;

1127: IF (l_debug = 'Y') THEN
1128: okc_debug.log('3910: Exiting Validate_jtot_object1_code in validate_record:unexp err', 2);
1129: okc_debug.Reset_Indentation;
1130: END IF;
1131: return OKC_API.G_RET_STS_UNEXP_ERROR;
1132: end if;
1133: if (l_return_status = OKC_API.G_RET_STS_ERROR
1134: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1135: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1133: if (l_return_status = OKC_API.G_RET_STS_ERROR

1129: okc_debug.Reset_Indentation;
1130: END IF;
1131: return OKC_API.G_RET_STS_UNEXP_ERROR;
1132: end if;
1133: if (l_return_status = OKC_API.G_RET_STS_ERROR
1134: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1135: x_return_status := OKC_API.G_RET_STS_ERROR;
1136: end if;
1137: validate_object1_id1(x_return_status => l_return_status,

Line 1134: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

1130: END IF;
1131: return OKC_API.G_RET_STS_UNEXP_ERROR;
1132: end if;
1133: if (l_return_status = OKC_API.G_RET_STS_ERROR
1134: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1135: x_return_status := OKC_API.G_RET_STS_ERROR;
1136: end if;
1137: validate_object1_id1(x_return_status => l_return_status,
1138: p_cimv_rec => p_cimv_rec);

Line 1135: x_return_status := OKC_API.G_RET_STS_ERROR;

1131: return OKC_API.G_RET_STS_UNEXP_ERROR;
1132: end if;
1133: if (l_return_status = OKC_API.G_RET_STS_ERROR
1134: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1135: x_return_status := OKC_API.G_RET_STS_ERROR;
1136: end if;
1137: validate_object1_id1(x_return_status => l_return_status,
1138: p_cimv_rec => p_cimv_rec);
1139: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

Line 1139: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1135: x_return_status := OKC_API.G_RET_STS_ERROR;
1136: end if;
1137: validate_object1_id1(x_return_status => l_return_status,
1138: p_cimv_rec => p_cimv_rec);
1139: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1140: IF (l_debug = 'Y') THEN
1141: okc_debug.log('3920: Exiting Validate_object1_id1 in validate_record:unexp err', 2);
1142: okc_debug.Reset_Indentation;
1143: END IF;

Line 1144: return OKC_API.G_RET_STS_UNEXP_ERROR;

1140: IF (l_debug = 'Y') THEN
1141: okc_debug.log('3920: Exiting Validate_object1_id1 in validate_record:unexp err', 2);
1142: okc_debug.Reset_Indentation;
1143: END IF;
1144: return OKC_API.G_RET_STS_UNEXP_ERROR;
1145: end if;
1146: if (l_return_status = OKC_API.G_RET_STS_ERROR
1147: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1148: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1146: if (l_return_status = OKC_API.G_RET_STS_ERROR

1142: okc_debug.Reset_Indentation;
1143: END IF;
1144: return OKC_API.G_RET_STS_UNEXP_ERROR;
1145: end if;
1146: if (l_return_status = OKC_API.G_RET_STS_ERROR
1147: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1148: x_return_status := OKC_API.G_RET_STS_ERROR;
1149: end if;
1150: End If; -- if user defined

Line 1147: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then

1143: END IF;
1144: return OKC_API.G_RET_STS_UNEXP_ERROR;
1145: end if;
1146: if (l_return_status = OKC_API.G_RET_STS_ERROR
1147: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1148: x_return_status := OKC_API.G_RET_STS_ERROR;
1149: end if;
1150: End If; -- if user defined
1151:

Line 1148: x_return_status := OKC_API.G_RET_STS_ERROR;

1144: return OKC_API.G_RET_STS_UNEXP_ERROR;
1145: end if;
1146: if (l_return_status = OKC_API.G_RET_STS_ERROR
1147: and x_return_status = OKC_API.G_RET_STS_SUCCESS) then
1148: x_return_status := OKC_API.G_RET_STS_ERROR;
1149: end if;
1150: End If; -- if user defined
1151:
1152: IF (l_debug = 'Y') THEN

Line 1168: OKC_API.set_message(p_app_name => g_app_name,

1164: okc_debug.Reset_Indentation;
1165: END IF;
1166:
1167: -- store SQL error message on message stack for caller
1168: OKC_API.set_message(p_app_name => g_app_name,
1169: p_msg_name => g_unexpected_error,
1170: p_token1 => g_sqlcode_token,
1171: p_token1_value => sqlcode,
1172: p_token2 => g_sqlerrm_token,

Line 1174: RETURN(OKC_API.G_RET_STS_UNEXP_ERROR);

1170: p_token1 => g_sqlcode_token,
1171: p_token1_value => sqlcode,
1172: p_token2 => g_sqlerrm_token,
1173: p_token2_value => sqlerrm);
1174: RETURN(OKC_API.G_RET_STS_UNEXP_ERROR);
1175:
1176: END Validate_Record;
1177: /*+++++++++++++End of hand code +++++++++++++++++++*/
1178:

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

1260: p_cimv_rec IN cimv_rec_type) IS
1261:
1262: l_api_version CONSTANT NUMBER := 1;
1263: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1264: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1265: l_cimv_rec cimv_rec_type := p_cimv_rec;
1266: l_cim_rec cim_rec_type;
1267: BEGIN
1268:

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

1270: okc_debug.Set_Indentation('OKC_CIM_PVT');
1271: okc_debug.log('4400: Entered validate_row', 2);
1272: END IF;
1273:
1274: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1275: G_PKG_NAME,
1276: p_init_msg_list,
1277: l_api_version,
1278: p_api_version,

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

1277: l_api_version,
1278: p_api_version,
1279: '_PVT',
1280: x_return_status);
1281: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1284: RAISE OKC_API.G_EXCEPTION_ERROR;
1285: END IF;

Line 1282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1278: p_api_version,
1279: '_PVT',
1280: x_return_status);
1281: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1284: RAISE OKC_API.G_EXCEPTION_ERROR;
1285: END IF;
1286: --- Validate all non-missing attributes (Item Level Validation)

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

1279: '_PVT',
1280: x_return_status);
1281: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1284: RAISE OKC_API.G_EXCEPTION_ERROR;
1285: END IF;
1286: --- Validate all non-missing attributes (Item Level Validation)
1287: l_return_status := Validate_Attributes(l_cimv_rec);

Line 1284: RAISE OKC_API.G_EXCEPTION_ERROR;

1280: x_return_status);
1281: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1284: RAISE OKC_API.G_EXCEPTION_ERROR;
1285: END IF;
1286: --- Validate all non-missing attributes (Item Level Validation)
1287: l_return_status := Validate_Attributes(l_cimv_rec);
1288: --- If any errors happen abort API

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

1285: END IF;
1286: --- Validate all non-missing attributes (Item Level Validation)
1287: l_return_status := Validate_Attributes(l_cimv_rec);
1288: --- If any errors happen abort API
1289: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1291: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_ERROR;
1293: END IF;

Line 1290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1286: --- Validate all non-missing attributes (Item Level Validation)
1287: l_return_status := Validate_Attributes(l_cimv_rec);
1288: --- If any errors happen abort API
1289: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1291: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_ERROR;
1293: END IF;
1294: l_return_status := Validate_Record(l_cimv_rec);

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

1287: l_return_status := Validate_Attributes(l_cimv_rec);
1288: --- If any errors happen abort API
1289: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1291: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_ERROR;
1293: END IF;
1294: l_return_status := Validate_Record(l_cimv_rec);
1295: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1292: RAISE OKC_API.G_EXCEPTION_ERROR;

1288: --- If any errors happen abort API
1289: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1291: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_ERROR;
1293: END IF;
1294: l_return_status := Validate_Record(l_cimv_rec);
1295: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1296: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1291: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_ERROR;
1293: END IF;
1294: l_return_status := Validate_Record(l_cimv_rec);
1295: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1296: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1297: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1298: RAISE OKC_API.G_EXCEPTION_ERROR;
1299: END IF;

Line 1296: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1292: RAISE OKC_API.G_EXCEPTION_ERROR;
1293: END IF;
1294: l_return_status := Validate_Record(l_cimv_rec);
1295: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1296: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1297: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1298: RAISE OKC_API.G_EXCEPTION_ERROR;
1299: END IF;
1300: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1293: END IF;
1294: l_return_status := Validate_Record(l_cimv_rec);
1295: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1296: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1297: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1298: RAISE OKC_API.G_EXCEPTION_ERROR;
1299: END IF;
1300: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1301:

Line 1298: RAISE OKC_API.G_EXCEPTION_ERROR;

1294: l_return_status := Validate_Record(l_cimv_rec);
1295: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1296: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1297: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1298: RAISE OKC_API.G_EXCEPTION_ERROR;
1299: END IF;
1300: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1301:
1302: IF (l_debug = 'Y') THEN

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

1296: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1297: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1298: RAISE OKC_API.G_EXCEPTION_ERROR;
1299: END IF;
1300: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1301:
1302: IF (l_debug = 'Y') THEN
1303: okc_debug.log('4700: Leaving validate_row', 2);
1304: okc_debug.Reset_Indentation;

Line 1308: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1304: okc_debug.Reset_Indentation;
1305: END IF;
1306:
1307: EXCEPTION
1308: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1309:
1310: IF (l_debug = 'Y') THEN
1311: okc_debug.log('4600: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1312: okc_debug.Reset_Indentation;

Line 1311: okc_debug.log('4600: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

1307: EXCEPTION
1308: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1309:
1310: IF (l_debug = 'Y') THEN
1311: okc_debug.log('4600: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1312: okc_debug.Reset_Indentation;
1313: END IF;
1314:
1315: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1315: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1311: okc_debug.log('4600: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1312: okc_debug.Reset_Indentation;
1313: END IF;
1314:
1315: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1316: (
1317: l_api_name,
1318: G_PKG_NAME,
1319: 'OKC_API.G_RET_STS_ERROR',

Line 1319: 'OKC_API.G_RET_STS_ERROR',

1315: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1316: (
1317: l_api_name,
1318: G_PKG_NAME,
1319: 'OKC_API.G_RET_STS_ERROR',
1320: x_msg_count,
1321: x_msg_data,
1322: '_PVT'
1323: );

Line 1324: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1320: x_msg_count,
1321: x_msg_data,
1322: '_PVT'
1323: );
1324: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1325:
1326: IF (l_debug = 'Y') THEN
1327: okc_debug.log('4700: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1328: okc_debug.Reset_Indentation;

Line 1327: okc_debug.log('4700: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1323: );
1324: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1325:
1326: IF (l_debug = 'Y') THEN
1327: okc_debug.log('4700: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1328: okc_debug.Reset_Indentation;
1329: END IF;
1330:
1331: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1331: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1327: okc_debug.log('4700: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1328: okc_debug.Reset_Indentation;
1329: END IF;
1330:
1331: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1332: (
1333: l_api_name,
1334: G_PKG_NAME,
1335: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1335: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1347: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1343: okc_debug.log('4800: Exiting validate_row:OTHERS Exception', 2);
1344: okc_debug.Reset_Indentation;
1345: END IF;
1346:
1347: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1348: (
1349: l_api_name,
1350: G_PKG_NAME,
1351: 'OTHERS',

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

1367: p_cimv_tbl IN cimv_tbl_type) IS
1368:
1369: l_api_version CONSTANT NUMBER := 1;
1370: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1371: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1372: i NUMBER := 0;
1373: BEGIN
1374:
1375: IF (l_debug = 'Y') THEN

Line 1380: OKC_API.init_msg_list(p_init_msg_list);

1376: okc_debug.Set_Indentation('OKC_CIM_PVT');
1377: okc_debug.log('4900: Entered validate_row', 2);
1378: END IF;
1379:
1380: OKC_API.init_msg_list(p_init_msg_list);
1381: -- Make sure PL/SQL table has records in it before passing
1382: IF (p_cimv_tbl.COUNT > 0) THEN
1383: i := p_cimv_tbl.FIRST;
1384: LOOP

Line 1387: p_init_msg_list => OKC_API.G_FALSE,

1383: i := p_cimv_tbl.FIRST;
1384: LOOP
1385: validate_row (
1386: p_api_version => p_api_version,
1387: p_init_msg_list => OKC_API.G_FALSE,
1388: x_return_status => x_return_status,
1389: x_msg_count => x_msg_count,
1390: x_msg_data => x_msg_data,
1391: p_cimv_rec => p_cimv_tbl(i));

Line 1403: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1399: okc_debug.Reset_Indentation;
1400: END IF;
1401:
1402: EXCEPTION
1403: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1404:
1405: IF (l_debug = 'Y') THEN
1406: okc_debug.log('5100: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1407: okc_debug.Reset_Indentation;

Line 1406: okc_debug.log('5100: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

1402: EXCEPTION
1403: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1404:
1405: IF (l_debug = 'Y') THEN
1406: okc_debug.log('5100: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1407: okc_debug.Reset_Indentation;
1408: END IF;
1409:
1410: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1410: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1406: okc_debug.log('5100: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1407: okc_debug.Reset_Indentation;
1408: END IF;
1409:
1410: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1411: (
1412: l_api_name,
1413: G_PKG_NAME,
1414: 'OKC_API.G_RET_STS_ERROR',

Line 1414: 'OKC_API.G_RET_STS_ERROR',

1410: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1411: (
1412: l_api_name,
1413: G_PKG_NAME,
1414: 'OKC_API.G_RET_STS_ERROR',
1415: x_msg_count,
1416: x_msg_data,
1417: '_PVT'
1418: );

Line 1419: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1415: x_msg_count,
1416: x_msg_data,
1417: '_PVT'
1418: );
1419: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1420:
1421: IF (l_debug = 'Y') THEN
1422: okc_debug.log('5200: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1423: okc_debug.Reset_Indentation;

Line 1422: okc_debug.log('5200: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1418: );
1419: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1420:
1421: IF (l_debug = 'Y') THEN
1422: okc_debug.log('5200: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1423: okc_debug.Reset_Indentation;
1424: END IF;
1425:
1426: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1426: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1422: okc_debug.log('5200: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1423: okc_debug.Reset_Indentation;
1424: END IF;
1425:
1426: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1427: (
1428: l_api_name,
1429: G_PKG_NAME,
1430: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1430: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1426: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1427: (
1428: l_api_name,
1429: G_PKG_NAME,
1430: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1431: x_msg_count,
1432: x_msg_data,
1433: '_PVT'
1434: );

Line 1442: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1438: okc_debug.log('5300: Exiting validate_row:OTHERS Exception', 2);
1439: okc_debug.Reset_Indentation;
1440: END IF;
1441:
1442: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1443: (
1444: l_api_name,
1445: G_PKG_NAME,
1446: 'OTHERS',

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

1466: x_cim_rec OUT NOCOPY cim_rec_type) IS
1467:
1468: l_api_version CONSTANT NUMBER := 1;
1469: l_api_name CONSTANT VARCHAR2(30) := 'ITEMS_insert_row';
1470: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1471: l_cim_rec cim_rec_type := p_cim_rec;
1472: l_def_cim_rec cim_rec_type;
1473: ------------------------------------
1474: -- Set_Attributes for:OKC_K_ITEMS --

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

1476: FUNCTION Set_Attributes (
1477: p_cim_rec IN cim_rec_type,
1478: x_cim_rec OUT NOCOPY cim_rec_type
1479: ) RETURN VARCHAR2 IS
1480: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1481: BEGIN
1482:
1483: x_cim_rec := p_cim_rec;
1484:

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

1491: okc_debug.Set_Indentation('OKC_CIM_PVT');
1492: okc_debug.log('5500: Entered insert_row', 2);
1493: END IF;
1494:
1495: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1496: p_init_msg_list,
1497: '_PVT',
1498: x_return_status);
1499: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1495: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1496: p_init_msg_list,
1497: '_PVT',
1498: x_return_status);
1499: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1500: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1501: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1502: RAISE OKC_API.G_EXCEPTION_ERROR;
1503: END IF;

Line 1500: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1496: p_init_msg_list,
1497: '_PVT',
1498: x_return_status);
1499: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1500: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1501: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1502: RAISE OKC_API.G_EXCEPTION_ERROR;
1503: END IF;
1504: --- Setting item attributes

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

1497: '_PVT',
1498: x_return_status);
1499: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1500: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1501: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1502: RAISE OKC_API.G_EXCEPTION_ERROR;
1503: END IF;
1504: --- Setting item attributes
1505: l_return_status := Set_Attributes(

Line 1502: RAISE OKC_API.G_EXCEPTION_ERROR;

1498: x_return_status);
1499: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1500: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1501: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1502: RAISE OKC_API.G_EXCEPTION_ERROR;
1503: END IF;
1504: --- Setting item attributes
1505: l_return_status := Set_Attributes(
1506: p_cim_rec, -- IN

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

1505: l_return_status := Set_Attributes(
1506: p_cim_rec, -- IN
1507: l_cim_rec); -- OUT
1508: --- If any errors happen abort API
1509: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1511: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1512: RAISE OKC_API.G_EXCEPTION_ERROR;
1513: END IF;

Line 1510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1506: p_cim_rec, -- IN
1507: l_cim_rec); -- OUT
1508: --- If any errors happen abort API
1509: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1511: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1512: RAISE OKC_API.G_EXCEPTION_ERROR;
1513: END IF;
1514: INSERT INTO OKC_K_ITEMS(

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

1507: l_cim_rec); -- OUT
1508: --- If any errors happen abort API
1509: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1511: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1512: RAISE OKC_API.G_EXCEPTION_ERROR;
1513: END IF;
1514: INSERT INTO OKC_K_ITEMS(
1515: id,

Line 1512: RAISE OKC_API.G_EXCEPTION_ERROR;

1508: --- If any errors happen abort API
1509: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1511: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1512: RAISE OKC_API.G_EXCEPTION_ERROR;
1513: END IF;
1514: INSERT INTO OKC_K_ITEMS(
1515: id,
1516: cle_id,

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

1563: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1564: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE) );
1565: -- Set OUT values
1566: x_cim_rec := l_cim_rec;
1567: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1568:
1569: IF (l_debug = 'Y') THEN
1570: okc_debug.log('5600: Leaving insert_row', 2);
1571: okc_debug.Reset_Indentation;

Line 1575: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1571: okc_debug.Reset_Indentation;
1572: END IF;
1573:
1574: EXCEPTION
1575: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1576:
1577: IF (l_debug = 'Y') THEN
1578: okc_debug.log('5700: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1579: okc_debug.Reset_Indentation;

Line 1578: okc_debug.log('5700: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

1574: EXCEPTION
1575: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1576:
1577: IF (l_debug = 'Y') THEN
1578: okc_debug.log('5700: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1579: okc_debug.Reset_Indentation;
1580: END IF;
1581:
1582: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1582: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1578: okc_debug.log('5700: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1579: okc_debug.Reset_Indentation;
1580: END IF;
1581:
1582: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1583: (
1584: l_api_name,
1585: G_PKG_NAME,
1586: 'OKC_API.G_RET_STS_ERROR',

Line 1586: 'OKC_API.G_RET_STS_ERROR',

1582: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1583: (
1584: l_api_name,
1585: G_PKG_NAME,
1586: 'OKC_API.G_RET_STS_ERROR',
1587: x_msg_count,
1588: x_msg_data,
1589: '_PVT'
1590: );

Line 1591: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1587: x_msg_count,
1588: x_msg_data,
1589: '_PVT'
1590: );
1591: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1592:
1593: IF (l_debug = 'Y') THEN
1594: okc_debug.log('5800: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1595: okc_debug.Reset_Indentation;

Line 1594: okc_debug.log('5800: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1590: );
1591: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1592:
1593: IF (l_debug = 'Y') THEN
1594: okc_debug.log('5800: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1595: okc_debug.Reset_Indentation;
1596: END IF;
1597:
1598: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1598: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1594: okc_debug.log('5800: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1595: okc_debug.Reset_Indentation;
1596: END IF;
1597:
1598: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1599: (
1600: l_api_name,
1601: G_PKG_NAME,
1602: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1602: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1598: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1599: (
1600: l_api_name,
1601: G_PKG_NAME,
1602: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1603: x_msg_count,
1604: x_msg_data,
1605: '_PVT'
1606: );

Line 1614: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1610: okc_debug.log('5900: Exiting insert_row:OTHERS Exception', 2);
1611: okc_debug.Reset_Indentation;
1612: END IF;
1613:
1614: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1615: (
1616: l_api_name,
1617: G_PKG_NAME,
1618: 'OTHERS',

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

1635: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
1636:
1637: l_api_version CONSTANT NUMBER := 1;
1638: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1639: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1640: l_cimv_rec cimv_rec_type;
1641: l_def_cimv_rec cimv_rec_type;
1642: l_cim_rec cim_rec_type;
1643: lx_cim_rec cim_rec_type;

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

1665: FUNCTION Set_Attributes (
1666: p_cimv_rec IN cimv_rec_type,
1667: x_cimv_rec OUT NOCOPY cimv_rec_type
1668: ) RETURN VARCHAR2 IS
1669: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1670: BEGIN
1671:
1672: x_cimv_rec := p_cimv_rec;
1673: x_cimv_rec.OBJECT_VERSION_NUMBER := 1;

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

1680: okc_debug.Set_Indentation('OKC_CIM_PVT');
1681: okc_debug.log('6200: Entered insert_row', 2);
1682: END IF;
1683:
1684: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1685: G_PKG_NAME,
1686: p_init_msg_list,
1687: l_api_version,
1688: p_api_version,

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

1687: l_api_version,
1688: p_api_version,
1689: '_PVT',
1690: x_return_status);
1691: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1694: RAISE OKC_API.G_EXCEPTION_ERROR;
1695: END IF;

Line 1692: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1688: p_api_version,
1689: '_PVT',
1690: x_return_status);
1691: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1694: RAISE OKC_API.G_EXCEPTION_ERROR;
1695: END IF;
1696: l_cimv_rec := null_out_defaults(p_cimv_rec);

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

1689: '_PVT',
1690: x_return_status);
1691: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1694: RAISE OKC_API.G_EXCEPTION_ERROR;
1695: END IF;
1696: l_cimv_rec := null_out_defaults(p_cimv_rec);
1697: -- Set primary key value

Line 1694: RAISE OKC_API.G_EXCEPTION_ERROR;

1690: x_return_status);
1691: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1694: RAISE OKC_API.G_EXCEPTION_ERROR;
1695: END IF;
1696: l_cimv_rec := null_out_defaults(p_cimv_rec);
1697: -- Set primary key value
1698: l_cimv_rec.ID := get_seq_id;

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

1700: l_return_status := Set_Attributes(
1701: l_cimv_rec, -- IN
1702: l_def_cimv_rec); -- OUT
1703: --- If any errors happen abort API
1704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1707: RAISE OKC_API.G_EXCEPTION_ERROR;
1708: END IF;

Line 1705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1701: l_cimv_rec, -- IN
1702: l_def_cimv_rec); -- OUT
1703: --- If any errors happen abort API
1704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1707: RAISE OKC_API.G_EXCEPTION_ERROR;
1708: END IF;
1709: l_def_cimv_rec := fill_who_columns(l_def_cimv_rec);

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

1702: l_def_cimv_rec); -- OUT
1703: --- If any errors happen abort API
1704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1707: RAISE OKC_API.G_EXCEPTION_ERROR;
1708: END IF;
1709: l_def_cimv_rec := fill_who_columns(l_def_cimv_rec);
1710: --- Validate all non-missing attributes (Item Level Validation)

Line 1707: RAISE OKC_API.G_EXCEPTION_ERROR;

1703: --- If any errors happen abort API
1704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1707: RAISE OKC_API.G_EXCEPTION_ERROR;
1708: END IF;
1709: l_def_cimv_rec := fill_who_columns(l_def_cimv_rec);
1710: --- Validate all non-missing attributes (Item Level Validation)
1711: l_return_status := Validate_Attributes(l_def_cimv_rec);

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

1709: l_def_cimv_rec := fill_who_columns(l_def_cimv_rec);
1710: --- Validate all non-missing attributes (Item Level Validation)
1711: l_return_status := Validate_Attributes(l_def_cimv_rec);
1712: --- If any errors happen abort API
1713: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1714: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1715: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1716: RAISE OKC_API.G_EXCEPTION_ERROR;
1717: END IF;

Line 1714: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1710: --- Validate all non-missing attributes (Item Level Validation)
1711: l_return_status := Validate_Attributes(l_def_cimv_rec);
1712: --- If any errors happen abort API
1713: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1714: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1715: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1716: RAISE OKC_API.G_EXCEPTION_ERROR;
1717: END IF;
1718: l_return_status := Validate_Record(l_def_cimv_rec);

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

1711: l_return_status := Validate_Attributes(l_def_cimv_rec);
1712: --- If any errors happen abort API
1713: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1714: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1715: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1716: RAISE OKC_API.G_EXCEPTION_ERROR;
1717: END IF;
1718: l_return_status := Validate_Record(l_def_cimv_rec);
1719: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1716: RAISE OKC_API.G_EXCEPTION_ERROR;

1712: --- If any errors happen abort API
1713: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1714: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1715: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1716: RAISE OKC_API.G_EXCEPTION_ERROR;
1717: END IF;
1718: l_return_status := Validate_Record(l_def_cimv_rec);
1719: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1720: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1715: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1716: RAISE OKC_API.G_EXCEPTION_ERROR;
1717: END IF;
1718: l_return_status := Validate_Record(l_def_cimv_rec);
1719: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1720: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1721: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1722: RAISE OKC_API.G_EXCEPTION_ERROR;
1723: END IF;

Line 1720: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1716: RAISE OKC_API.G_EXCEPTION_ERROR;
1717: END IF;
1718: l_return_status := Validate_Record(l_def_cimv_rec);
1719: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1720: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1721: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1722: RAISE OKC_API.G_EXCEPTION_ERROR;
1723: END IF;
1724: --------------------------------------

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

1717: END IF;
1718: l_return_status := Validate_Record(l_def_cimv_rec);
1719: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1720: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1721: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1722: RAISE OKC_API.G_EXCEPTION_ERROR;
1723: END IF;
1724: --------------------------------------
1725: -- Move VIEW record to "Child" records

Line 1722: RAISE OKC_API.G_EXCEPTION_ERROR;

1718: l_return_status := Validate_Record(l_def_cimv_rec);
1719: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1720: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1721: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1722: RAISE OKC_API.G_EXCEPTION_ERROR;
1723: END IF;
1724: --------------------------------------
1725: -- Move VIEW record to "Child" records
1726: --------------------------------------

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

1735: x_msg_data,
1736: l_cim_rec,
1737: lx_cim_rec
1738: );
1739: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1740: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1741: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1742: RAISE OKC_API.G_EXCEPTION_ERROR;
1743: END IF;

Line 1740: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1736: l_cim_rec,
1737: lx_cim_rec
1738: );
1739: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1740: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1741: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1742: RAISE OKC_API.G_EXCEPTION_ERROR;
1743: END IF;
1744: migrate(lx_cim_rec, l_def_cimv_rec);

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

1737: lx_cim_rec
1738: );
1739: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1740: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1741: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1742: RAISE OKC_API.G_EXCEPTION_ERROR;
1743: END IF;
1744: migrate(lx_cim_rec, l_def_cimv_rec);
1745: -- Set OUT values

Line 1742: RAISE OKC_API.G_EXCEPTION_ERROR;

1738: );
1739: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1740: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1741: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1742: RAISE OKC_API.G_EXCEPTION_ERROR;
1743: END IF;
1744: migrate(lx_cim_rec, l_def_cimv_rec);
1745: -- Set OUT values
1746: x_cimv_rec := l_def_cimv_rec;

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

1743: END IF;
1744: migrate(lx_cim_rec, l_def_cimv_rec);
1745: -- Set OUT values
1746: x_cimv_rec := l_def_cimv_rec;
1747: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1748:
1749: IF (l_debug = 'Y') THEN
1750: okc_debug.log('6500: Leaving insert_row', 2);
1751: okc_debug.Reset_Indentation;

Line 1755: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1751: okc_debug.Reset_Indentation;
1752: END IF;
1753:
1754: EXCEPTION
1755: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1756:
1757: IF (l_debug = 'Y') THEN
1758: okc_debug.log('6400: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1759: okc_debug.Reset_Indentation;

Line 1758: okc_debug.log('6400: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

1754: EXCEPTION
1755: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1756:
1757: IF (l_debug = 'Y') THEN
1758: okc_debug.log('6400: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1759: okc_debug.Reset_Indentation;
1760: END IF;
1761:
1762: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1762: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1758: okc_debug.log('6400: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1759: okc_debug.Reset_Indentation;
1760: END IF;
1761:
1762: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1763: (
1764: l_api_name,
1765: G_PKG_NAME,
1766: 'OKC_API.G_RET_STS_ERROR',

Line 1766: 'OKC_API.G_RET_STS_ERROR',

1762: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1763: (
1764: l_api_name,
1765: G_PKG_NAME,
1766: 'OKC_API.G_RET_STS_ERROR',
1767: x_msg_count,
1768: x_msg_data,
1769: '_PVT'
1770: );

Line 1771: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1767: x_msg_count,
1768: x_msg_data,
1769: '_PVT'
1770: );
1771: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1772:
1773: IF (l_debug = 'Y') THEN
1774: okc_debug.log('6500: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1775: okc_debug.Reset_Indentation;

Line 1774: okc_debug.log('6500: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1770: );
1771: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1772:
1773: IF (l_debug = 'Y') THEN
1774: okc_debug.log('6500: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1775: okc_debug.Reset_Indentation;
1776: END IF;
1777:
1778: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1778: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1774: okc_debug.log('6500: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1775: okc_debug.Reset_Indentation;
1776: END IF;
1777:
1778: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1779: (
1780: l_api_name,
1781: G_PKG_NAME,
1782: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1782: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1794: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1790: okc_debug.log('6600: Exiting insert_row:OTHERS Exception', 2);
1791: okc_debug.Reset_Indentation;
1792: END IF;
1793:
1794: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1795: (
1796: l_api_name,
1797: G_PKG_NAME,
1798: 'OTHERS',

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

1815: x_cimv_tbl OUT NOCOPY cimv_tbl_type) IS
1816:
1817: l_api_version CONSTANT NUMBER := 1;
1818: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1819: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1820: i NUMBER := 0;
1821: BEGIN
1822:
1823: IF (l_debug = 'Y') THEN

Line 1828: OKC_API.init_msg_list(p_init_msg_list);

1824: okc_debug.Set_Indentation('OKC_CIM_PVT');
1825: okc_debug.log('6700: Entered insert_row', 2);
1826: END IF;
1827:
1828: OKC_API.init_msg_list(p_init_msg_list);
1829: -- Make sure PL/SQL table has records in it before passing
1830: IF (p_cimv_tbl.COUNT > 0) THEN
1831: i := p_cimv_tbl.FIRST;
1832: LOOP

Line 1835: p_init_msg_list => OKC_API.G_FALSE,

1831: i := p_cimv_tbl.FIRST;
1832: LOOP
1833: insert_row (
1834: p_api_version => p_api_version,
1835: p_init_msg_list => OKC_API.G_FALSE,
1836: x_return_status => x_return_status,
1837: x_msg_count => x_msg_count,
1838: x_msg_data => x_msg_data,
1839: p_cimv_rec => p_cimv_tbl(i),

Line 1852: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1848: okc_debug.Reset_Indentation;
1849: END IF;
1850:
1851: EXCEPTION
1852: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1853:
1854: IF (l_debug = 'Y') THEN
1855: okc_debug.log('6900: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1856: okc_debug.Reset_Indentation;

Line 1855: okc_debug.log('6900: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

1851: EXCEPTION
1852: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1853:
1854: IF (l_debug = 'Y') THEN
1855: okc_debug.log('6900: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1856: okc_debug.Reset_Indentation;
1857: END IF;
1858:
1859: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1859: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1855: okc_debug.log('6900: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1856: okc_debug.Reset_Indentation;
1857: END IF;
1858:
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:
1870: IF (l_debug = 'Y') THEN
1871: okc_debug.log('7000: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1872: okc_debug.Reset_Indentation;

Line 1871: okc_debug.log('7000: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1867: );
1868: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1869:
1870: IF (l_debug = 'Y') THEN
1871: okc_debug.log('7000: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1872: okc_debug.Reset_Indentation;
1873: END IF;
1874:
1875: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1875: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1871: okc_debug.log('7000: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1872: okc_debug.Reset_Indentation;
1873: END IF;
1874:
1875: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1876: (
1877: l_api_name,
1878: G_PKG_NAME,
1879: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1879: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1891: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1887: okc_debug.log('7100: Exiting insert_row:OTHERS Exception', 2);
1888: okc_debug.Reset_Indentation;
1889: END IF;
1890:
1891: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1892: (
1893: l_api_name,
1894: G_PKG_NAME,
1895: 'OTHERS',

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

1927: FROM OKC_K_ITEMS
1928: WHERE ID = p_cim_rec.id;
1929: l_api_version CONSTANT NUMBER := 1;
1930: l_api_name CONSTANT VARCHAR2(30) := 'ITEMS_lock_row';
1931: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1932: l_object_version_number OKC_K_ITEMS.OBJECT_VERSION_NUMBER%TYPE;
1933: lc_object_version_number OKC_K_ITEMS.OBJECT_VERSION_NUMBER%TYPE;
1934: l_row_notfound BOOLEAN := FALSE;
1935: lc_row_notfound BOOLEAN := FALSE;

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

1939: okc_debug.Set_Indentation('OKC_CIM_PVT');
1940: okc_debug.log('7200: Entered lock_row', 2);
1941: END IF;
1942:
1943: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1944: p_init_msg_list,
1945: '_PVT',
1946: x_return_status);
1947: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1943: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1944: p_init_msg_list,
1945: '_PVT',
1946: x_return_status);
1947: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1948: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1949: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1950: RAISE OKC_API.G_EXCEPTION_ERROR;
1951: END IF;

Line 1948: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1944: p_init_msg_list,
1945: '_PVT',
1946: x_return_status);
1947: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1948: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1949: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1950: RAISE OKC_API.G_EXCEPTION_ERROR;
1951: END IF;
1952: BEGIN

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

1945: '_PVT',
1946: x_return_status);
1947: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1948: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1949: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1950: RAISE OKC_API.G_EXCEPTION_ERROR;
1951: END IF;
1952: BEGIN
1953:

Line 1950: RAISE OKC_API.G_EXCEPTION_ERROR;

1946: x_return_status);
1947: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1948: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1949: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1950: RAISE OKC_API.G_EXCEPTION_ERROR;
1951: END IF;
1952: BEGIN
1953:
1954: IF (l_debug = 'Y') THEN

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

1976:
1977: IF (lock_csr%ISOPEN) THEN
1978: CLOSE lock_csr;
1979: END IF;
1980: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1981: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1982: END;
1983:
1984: IF ( l_row_notfound ) THEN

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

1987: lc_row_notfound := lchk_csr%NOTFOUND;
1988: CLOSE lchk_csr;
1989: END IF;
1990: IF (lc_row_notfound) THEN
1991: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1992: RAISE OKC_API.G_EXCEPTION_ERROR;
1993: ELSIF lc_object_version_number > p_cim_rec.object_version_number THEN
1994: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1995: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1992: RAISE OKC_API.G_EXCEPTION_ERROR;

1988: CLOSE lchk_csr;
1989: END IF;
1990: IF (lc_row_notfound) THEN
1991: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1992: RAISE OKC_API.G_EXCEPTION_ERROR;
1993: ELSIF lc_object_version_number > p_cim_rec.object_version_number THEN
1994: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1995: RAISE OKC_API.G_EXCEPTION_ERROR;
1996: ELSIF lc_object_version_number <> p_cim_rec.object_version_number THEN

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

1990: IF (lc_row_notfound) THEN
1991: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1992: RAISE OKC_API.G_EXCEPTION_ERROR;
1993: ELSIF lc_object_version_number > p_cim_rec.object_version_number THEN
1994: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1995: RAISE OKC_API.G_EXCEPTION_ERROR;
1996: ELSIF lc_object_version_number <> p_cim_rec.object_version_number THEN
1997: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1998: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1995: RAISE OKC_API.G_EXCEPTION_ERROR;

1991: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1992: RAISE OKC_API.G_EXCEPTION_ERROR;
1993: ELSIF lc_object_version_number > p_cim_rec.object_version_number THEN
1994: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1995: RAISE OKC_API.G_EXCEPTION_ERROR;
1996: ELSIF lc_object_version_number <> p_cim_rec.object_version_number THEN
1997: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1998: RAISE OKC_API.G_EXCEPTION_ERROR;
1999: ELSIF lc_object_version_number = -1 THEN

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

1993: ELSIF lc_object_version_number > p_cim_rec.object_version_number THEN
1994: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1995: RAISE OKC_API.G_EXCEPTION_ERROR;
1996: ELSIF lc_object_version_number <> p_cim_rec.object_version_number THEN
1997: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1998: RAISE OKC_API.G_EXCEPTION_ERROR;
1999: ELSIF lc_object_version_number = -1 THEN
2000: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2001: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1998: RAISE OKC_API.G_EXCEPTION_ERROR;

1994: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1995: RAISE OKC_API.G_EXCEPTION_ERROR;
1996: ELSIF lc_object_version_number <> p_cim_rec.object_version_number THEN
1997: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1998: RAISE OKC_API.G_EXCEPTION_ERROR;
1999: ELSIF lc_object_version_number = -1 THEN
2000: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2001: RAISE OKC_API.G_EXCEPTION_ERROR;
2002: END IF;

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

1996: ELSIF lc_object_version_number <> p_cim_rec.object_version_number THEN
1997: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1998: RAISE OKC_API.G_EXCEPTION_ERROR;
1999: ELSIF lc_object_version_number = -1 THEN
2000: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2001: RAISE OKC_API.G_EXCEPTION_ERROR;
2002: END IF;
2003: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2004:

Line 2001: RAISE OKC_API.G_EXCEPTION_ERROR;

1997: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1998: RAISE OKC_API.G_EXCEPTION_ERROR;
1999: ELSIF lc_object_version_number = -1 THEN
2000: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2001: RAISE OKC_API.G_EXCEPTION_ERROR;
2002: END IF;
2003: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2004:
2005: IF (l_debug = 'Y') THEN

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

1999: ELSIF lc_object_version_number = -1 THEN
2000: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2001: RAISE OKC_API.G_EXCEPTION_ERROR;
2002: END IF;
2003: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2004:
2005: IF (l_debug = 'Y') THEN
2006: okc_debug.log('7800: Exiting lock_row', 2);
2007: okc_debug.Reset_Indentation;

Line 2011: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2007: okc_debug.Reset_Indentation;
2008: END IF;
2009:
2010: EXCEPTION
2011: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2012:
2013: IF (l_debug = 'Y') THEN
2014: okc_debug.log('7700: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2015: okc_debug.Reset_Indentation;

Line 2014: okc_debug.log('7700: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2010: EXCEPTION
2011: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2012:
2013: IF (l_debug = 'Y') THEN
2014: okc_debug.log('7700: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2015: okc_debug.Reset_Indentation;
2016: END IF;
2017:
2018: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2018: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2014: okc_debug.log('7700: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2015: okc_debug.Reset_Indentation;
2016: END IF;
2017:
2018: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2019: (
2020: l_api_name,
2021: G_PKG_NAME,
2022: 'OKC_API.G_RET_STS_ERROR',

Line 2022: 'OKC_API.G_RET_STS_ERROR',

2018: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2019: (
2020: l_api_name,
2021: G_PKG_NAME,
2022: 'OKC_API.G_RET_STS_ERROR',
2023: x_msg_count,
2024: x_msg_data,
2025: '_PVT'
2026: );

Line 2027: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2023: x_msg_count,
2024: x_msg_data,
2025: '_PVT'
2026: );
2027: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2028:
2029: IF (l_debug = 'Y') THEN
2030: okc_debug.log('7800: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2031: okc_debug.Reset_Indentation;

Line 2030: okc_debug.log('7800: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2026: );
2027: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2028:
2029: IF (l_debug = 'Y') THEN
2030: okc_debug.log('7800: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2031: okc_debug.Reset_Indentation;
2032: END IF;
2033:
2034: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2034: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2030: okc_debug.log('7800: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2031: okc_debug.Reset_Indentation;
2032: END IF;
2033:
2034: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2035: (
2036: l_api_name,
2037: G_PKG_NAME,
2038: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2038: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2034: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2035: (
2036: l_api_name,
2037: G_PKG_NAME,
2038: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2039: x_msg_count,
2040: x_msg_data,
2041: '_PVT'
2042: );

Line 2050: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2046: okc_debug.log('7900: Exiting lock_row:OTHERS Exception', 2);
2047: okc_debug.Reset_Indentation;
2048: END IF;
2049:
2050: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2051: (
2052: l_api_name,
2053: G_PKG_NAME,
2054: 'OTHERS',

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

2070: p_cimv_rec IN cimv_rec_type) IS
2071:
2072: l_api_version CONSTANT NUMBER := 1;
2073: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2074: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2075: l_cim_rec cim_rec_type;
2076: BEGIN
2077:
2078: IF (l_debug = 'Y') THEN

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

2079: okc_debug.Set_Indentation('OKC_CIM_PVT');
2080: okc_debug.log('8000: Entered lock_row', 2);
2081: END IF;
2082:
2083: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2084: G_PKG_NAME,
2085: p_init_msg_list,
2086: l_api_version,
2087: p_api_version,

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

2086: l_api_version,
2087: p_api_version,
2088: '_PVT',
2089: x_return_status);
2090: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2091: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2092: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2093: RAISE OKC_API.G_EXCEPTION_ERROR;
2094: END IF;

Line 2091: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2087: p_api_version,
2088: '_PVT',
2089: x_return_status);
2090: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2091: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2092: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2093: RAISE OKC_API.G_EXCEPTION_ERROR;
2094: END IF;
2095: --------------------------------------

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

2088: '_PVT',
2089: x_return_status);
2090: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2091: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2092: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2093: RAISE OKC_API.G_EXCEPTION_ERROR;
2094: END IF;
2095: --------------------------------------
2096: -- Move VIEW record to "Child" records

Line 2093: RAISE OKC_API.G_EXCEPTION_ERROR;

2089: x_return_status);
2090: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2091: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2092: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2093: RAISE OKC_API.G_EXCEPTION_ERROR;
2094: END IF;
2095: --------------------------------------
2096: -- Move VIEW record to "Child" records
2097: --------------------------------------

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

2105: x_msg_count,
2106: x_msg_data,
2107: l_cim_rec
2108: );
2109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2112: RAISE OKC_API.G_EXCEPTION_ERROR;
2113: END IF;

Line 2110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2106: x_msg_data,
2107: l_cim_rec
2108: );
2109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2112: RAISE OKC_API.G_EXCEPTION_ERROR;
2113: END IF;
2114: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2107: l_cim_rec
2108: );
2109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2112: RAISE OKC_API.G_EXCEPTION_ERROR;
2113: END IF;
2114: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2115:

Line 2112: RAISE OKC_API.G_EXCEPTION_ERROR;

2108: );
2109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2112: RAISE OKC_API.G_EXCEPTION_ERROR;
2113: END IF;
2114: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2115:
2116: IF (l_debug = 'Y') THEN

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

2110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2112: RAISE OKC_API.G_EXCEPTION_ERROR;
2113: END IF;
2114: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2115:
2116: IF (l_debug = 'Y') THEN
2117: okc_debug.log('8100: Leaving lock_row', 2);
2118: okc_debug.Reset_Indentation;

Line 2122: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2118: okc_debug.Reset_Indentation;
2119: END IF;
2120:
2121: EXCEPTION
2122: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2123:
2124: IF (l_debug = 'Y') THEN
2125: okc_debug.log('8200: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2126: okc_debug.Reset_Indentation;

Line 2125: okc_debug.log('8200: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2121: EXCEPTION
2122: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2123:
2124: IF (l_debug = 'Y') THEN
2125: okc_debug.log('8200: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2126: okc_debug.Reset_Indentation;
2127: END IF;
2128:
2129: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2129: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2125: okc_debug.log('8200: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2126: okc_debug.Reset_Indentation;
2127: END IF;
2128:
2129: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2130: (
2131: l_api_name,
2132: G_PKG_NAME,
2133: 'OKC_API.G_RET_STS_ERROR',

Line 2133: 'OKC_API.G_RET_STS_ERROR',

2129: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2130: (
2131: l_api_name,
2132: G_PKG_NAME,
2133: 'OKC_API.G_RET_STS_ERROR',
2134: x_msg_count,
2135: x_msg_data,
2136: '_PVT'
2137: );

Line 2138: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2134: x_msg_count,
2135: x_msg_data,
2136: '_PVT'
2137: );
2138: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2139:
2140: IF (l_debug = 'Y') THEN
2141: okc_debug.log('8300: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2142: okc_debug.Reset_Indentation;

Line 2141: okc_debug.log('8300: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2137: );
2138: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2139:
2140: IF (l_debug = 'Y') THEN
2141: okc_debug.log('8300: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2142: okc_debug.Reset_Indentation;
2143: END IF;
2144:
2145: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2145: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2141: okc_debug.log('8300: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2142: okc_debug.Reset_Indentation;
2143: END IF;
2144:
2145: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2146: (
2147: l_api_name,
2148: G_PKG_NAME,
2149: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2149: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2145: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2146: (
2147: l_api_name,
2148: G_PKG_NAME,
2149: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2150: x_msg_count,
2151: x_msg_data,
2152: '_PVT'
2153: );

Line 2161: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2157: okc_debug.log('8400: Exiting lock_row:OTHERS Exception', 2);
2158: okc_debug.Reset_Indentation;
2159: END IF;
2160:
2161: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2162: (
2163: l_api_name,
2164: G_PKG_NAME,
2165: 'OTHERS',

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

2181: p_cimv_tbl IN cimv_tbl_type) IS
2182:
2183: l_api_version CONSTANT NUMBER := 1;
2184: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2185: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2186: i NUMBER := 0;
2187: BEGIN
2188:
2189: IF (l_debug = 'Y') THEN

Line 2194: OKC_API.init_msg_list(p_init_msg_list);

2190: okc_debug.Set_Indentation('OKC_CIM_PVT');
2191: okc_debug.log('8500: Entered lock_row', 2);
2192: END IF;
2193:
2194: OKC_API.init_msg_list(p_init_msg_list);
2195: -- Make sure PL/SQL table has records in it before passing
2196: IF (p_cimv_tbl.COUNT > 0) THEN
2197: i := p_cimv_tbl.FIRST;
2198: LOOP

Line 2201: p_init_msg_list => OKC_API.G_FALSE,

2197: i := p_cimv_tbl.FIRST;
2198: LOOP
2199: lock_row (
2200: p_api_version => p_api_version,
2201: p_init_msg_list => OKC_API.G_FALSE,
2202: x_return_status => x_return_status,
2203: x_msg_count => x_msg_count,
2204: x_msg_data => x_msg_data,
2205: p_cimv_rec => p_cimv_tbl(i));

Line 2217: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2213: okc_debug.Reset_Indentation;
2214: END IF;
2215:
2216: EXCEPTION
2217: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2218:
2219: IF (l_debug = 'Y') THEN
2220: okc_debug.log('8700: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2221: okc_debug.Reset_Indentation;

Line 2220: okc_debug.log('8700: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2216: EXCEPTION
2217: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2218:
2219: IF (l_debug = 'Y') THEN
2220: okc_debug.log('8700: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2221: okc_debug.Reset_Indentation;
2222: END IF;
2223:
2224: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2224: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2220: okc_debug.log('8700: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2221: okc_debug.Reset_Indentation;
2222: END IF;
2223:
2224: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2225: (
2226: l_api_name,
2227: G_PKG_NAME,
2228: 'OKC_API.G_RET_STS_ERROR',

Line 2228: 'OKC_API.G_RET_STS_ERROR',

2224: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2225: (
2226: l_api_name,
2227: G_PKG_NAME,
2228: 'OKC_API.G_RET_STS_ERROR',
2229: x_msg_count,
2230: x_msg_data,
2231: '_PVT'
2232: );

Line 2233: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2229: x_msg_count,
2230: x_msg_data,
2231: '_PVT'
2232: );
2233: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2234:
2235: IF (l_debug = 'Y') THEN
2236: okc_debug.log('8800: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2237: okc_debug.Reset_Indentation;

Line 2236: okc_debug.log('8800: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2232: );
2233: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2234:
2235: IF (l_debug = 'Y') THEN
2236: okc_debug.log('8800: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2237: okc_debug.Reset_Indentation;
2238: END IF;
2239:
2240: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2240: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2236: okc_debug.log('8800: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2237: okc_debug.Reset_Indentation;
2238: END IF;
2239:
2240: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2241: (
2242: l_api_name,
2243: G_PKG_NAME,
2244: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2244: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2240: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2241: (
2242: l_api_name,
2243: G_PKG_NAME,
2244: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2245: x_msg_count,
2246: x_msg_data,
2247: '_PVT'
2248: );

Line 2256: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2252: okc_debug.log('8900: Exiting lock_row:OTHERS Exception', 2);
2253: okc_debug.Reset_Indentation;
2254: END IF;
2255:
2256: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2257: (
2258: l_api_name,
2259: G_PKG_NAME,
2260: 'OTHERS',

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

2280: x_cim_rec OUT NOCOPY cim_rec_type) IS
2281:
2282: l_api_version CONSTANT NUMBER := 1;
2283: l_api_name CONSTANT VARCHAR2(30) := 'ITEMS_update_row';
2284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2285: l_cim_rec cim_rec_type := p_cim_rec;
2286: l_def_cim_rec cim_rec_type;
2287: l_row_notfound BOOLEAN := TRUE;
2288: ----------------------------------

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

2293: x_cim_rec OUT NOCOPY cim_rec_type
2294: ) RETURN VARCHAR2 IS
2295: l_cim_rec cim_rec_type;
2296: l_row_notfound BOOLEAN := TRUE;
2297: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2298: BEGIN
2299:
2300: IF (l_debug = 'Y') THEN
2301: okc_debug.Set_Indentation('OKC_CIM_PVT');

Line 2309: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2305: x_cim_rec := p_cim_rec;
2306: -- Get current database values
2307: l_cim_rec := get_rec(p_cim_rec, l_row_notfound);
2308: IF (l_row_notfound) THEN
2309: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2310: END IF;
2311: IF (x_cim_rec.id = OKC_API.G_MISS_NUM)
2312: THEN
2313: x_cim_rec.id := l_cim_rec.id;

Line 2311: IF (x_cim_rec.id = OKC_API.G_MISS_NUM)

2307: l_cim_rec := get_rec(p_cim_rec, l_row_notfound);
2308: IF (l_row_notfound) THEN
2309: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2310: END IF;
2311: IF (x_cim_rec.id = OKC_API.G_MISS_NUM)
2312: THEN
2313: x_cim_rec.id := l_cim_rec.id;
2314: END IF;
2315: IF (x_cim_rec.cle_id = OKC_API.G_MISS_NUM)

Line 2315: IF (x_cim_rec.cle_id = OKC_API.G_MISS_NUM)

2311: IF (x_cim_rec.id = OKC_API.G_MISS_NUM)
2312: THEN
2313: x_cim_rec.id := l_cim_rec.id;
2314: END IF;
2315: IF (x_cim_rec.cle_id = OKC_API.G_MISS_NUM)
2316: THEN
2317: x_cim_rec.cle_id := l_cim_rec.cle_id;
2318: END IF;
2319: IF (x_cim_rec.chr_id = OKC_API.G_MISS_NUM)

Line 2319: IF (x_cim_rec.chr_id = OKC_API.G_MISS_NUM)

2315: IF (x_cim_rec.cle_id = OKC_API.G_MISS_NUM)
2316: THEN
2317: x_cim_rec.cle_id := l_cim_rec.cle_id;
2318: END IF;
2319: IF (x_cim_rec.chr_id = OKC_API.G_MISS_NUM)
2320: THEN
2321: x_cim_rec.chr_id := l_cim_rec.chr_id;
2322: END IF;
2323: IF (x_cim_rec.cle_id_for = OKC_API.G_MISS_NUM)

Line 2323: IF (x_cim_rec.cle_id_for = OKC_API.G_MISS_NUM)

2319: IF (x_cim_rec.chr_id = OKC_API.G_MISS_NUM)
2320: THEN
2321: x_cim_rec.chr_id := l_cim_rec.chr_id;
2322: END IF;
2323: IF (x_cim_rec.cle_id_for = OKC_API.G_MISS_NUM)
2324: THEN
2325: x_cim_rec.cle_id_for := l_cim_rec.cle_id_for;
2326: END IF;
2327: IF (x_cim_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

Line 2327: IF (x_cim_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

2323: IF (x_cim_rec.cle_id_for = OKC_API.G_MISS_NUM)
2324: THEN
2325: x_cim_rec.cle_id_for := l_cim_rec.cle_id_for;
2326: END IF;
2327: IF (x_cim_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
2328: THEN
2329: x_cim_rec.dnz_chr_id := l_cim_rec.dnz_chr_id;
2330: END IF;
2331: IF (x_cim_rec.object1_id1 = OKC_API.G_MISS_CHAR)

Line 2331: IF (x_cim_rec.object1_id1 = OKC_API.G_MISS_CHAR)

2327: IF (x_cim_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
2328: THEN
2329: x_cim_rec.dnz_chr_id := l_cim_rec.dnz_chr_id;
2330: END IF;
2331: IF (x_cim_rec.object1_id1 = OKC_API.G_MISS_CHAR)
2332: THEN
2333: x_cim_rec.object1_id1 := l_cim_rec.object1_id1;
2334: END IF;
2335: IF (x_cim_rec.object1_id2 = OKC_API.G_MISS_CHAR)

Line 2335: IF (x_cim_rec.object1_id2 = OKC_API.G_MISS_CHAR)

2331: IF (x_cim_rec.object1_id1 = OKC_API.G_MISS_CHAR)
2332: THEN
2333: x_cim_rec.object1_id1 := l_cim_rec.object1_id1;
2334: END IF;
2335: IF (x_cim_rec.object1_id2 = OKC_API.G_MISS_CHAR)
2336: THEN
2337: x_cim_rec.object1_id2 := l_cim_rec.object1_id2;
2338: END IF;
2339: IF (x_cim_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)

Line 2339: IF (x_cim_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)

2335: IF (x_cim_rec.object1_id2 = OKC_API.G_MISS_CHAR)
2336: THEN
2337: x_cim_rec.object1_id2 := l_cim_rec.object1_id2;
2338: END IF;
2339: IF (x_cim_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)
2340: THEN
2341: x_cim_rec.jtot_object1_code := l_cim_rec.jtot_object1_code;
2342: END IF;
2343: IF (x_cim_rec.uom_code = OKC_API.G_MISS_CHAR)

Line 2343: IF (x_cim_rec.uom_code = OKC_API.G_MISS_CHAR)

2339: IF (x_cim_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)
2340: THEN
2341: x_cim_rec.jtot_object1_code := l_cim_rec.jtot_object1_code;
2342: END IF;
2343: IF (x_cim_rec.uom_code = OKC_API.G_MISS_CHAR)
2344: THEN
2345: x_cim_rec.uom_code := l_cim_rec.uom_code;
2346: END IF;
2347: IF (x_cim_rec.exception_yn = OKC_API.G_MISS_CHAR)

Line 2347: IF (x_cim_rec.exception_yn = OKC_API.G_MISS_CHAR)

2343: IF (x_cim_rec.uom_code = OKC_API.G_MISS_CHAR)
2344: THEN
2345: x_cim_rec.uom_code := l_cim_rec.uom_code;
2346: END IF;
2347: IF (x_cim_rec.exception_yn = OKC_API.G_MISS_CHAR)
2348: THEN
2349: x_cim_rec.exception_yn := l_cim_rec.exception_yn;
2350: END IF;
2351: IF (x_cim_rec.number_of_items = OKC_API.G_MISS_NUM)

Line 2351: IF (x_cim_rec.number_of_items = OKC_API.G_MISS_NUM)

2347: IF (x_cim_rec.exception_yn = OKC_API.G_MISS_CHAR)
2348: THEN
2349: x_cim_rec.exception_yn := l_cim_rec.exception_yn;
2350: END IF;
2351: IF (x_cim_rec.number_of_items = OKC_API.G_MISS_NUM)
2352: THEN
2353: x_cim_rec.number_of_items := l_cim_rec.number_of_items;
2354: END IF;
2355: IF (x_cim_rec.upg_orig_system_ref = OKC_API.G_MISS_CHAR)

Line 2355: IF (x_cim_rec.upg_orig_system_ref = OKC_API.G_MISS_CHAR)

2351: IF (x_cim_rec.number_of_items = OKC_API.G_MISS_NUM)
2352: THEN
2353: x_cim_rec.number_of_items := l_cim_rec.number_of_items;
2354: END IF;
2355: IF (x_cim_rec.upg_orig_system_ref = OKC_API.G_MISS_CHAR)
2356: THEN
2357: x_cim_rec.upg_orig_system_ref := l_cim_rec.upg_orig_system_ref;
2358: END IF;
2359: IF (x_cim_rec.upg_orig_system_ref_id = OKC_API.G_MISS_NUM)

Line 2359: IF (x_cim_rec.upg_orig_system_ref_id = OKC_API.G_MISS_NUM)

2355: IF (x_cim_rec.upg_orig_system_ref = OKC_API.G_MISS_CHAR)
2356: THEN
2357: x_cim_rec.upg_orig_system_ref := l_cim_rec.upg_orig_system_ref;
2358: END IF;
2359: IF (x_cim_rec.upg_orig_system_ref_id = OKC_API.G_MISS_NUM)
2360: THEN
2361: x_cim_rec.upg_orig_system_ref_id := l_cim_rec.upg_orig_system_ref_id;
2362: END IF;
2363: IF (x_cim_rec.priced_item_yn = OKC_API.G_MISS_CHAR)

Line 2363: IF (x_cim_rec.priced_item_yn = OKC_API.G_MISS_CHAR)

2359: IF (x_cim_rec.upg_orig_system_ref_id = OKC_API.G_MISS_NUM)
2360: THEN
2361: x_cim_rec.upg_orig_system_ref_id := l_cim_rec.upg_orig_system_ref_id;
2362: END IF;
2363: IF (x_cim_rec.priced_item_yn = OKC_API.G_MISS_CHAR)
2364: THEN
2365: x_cim_rec.priced_item_yn := l_cim_rec.priced_item_yn;
2366: END IF;
2367: IF (x_cim_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 2367: IF (x_cim_rec.object_version_number = OKC_API.G_MISS_NUM)

2363: IF (x_cim_rec.priced_item_yn = OKC_API.G_MISS_CHAR)
2364: THEN
2365: x_cim_rec.priced_item_yn := l_cim_rec.priced_item_yn;
2366: END IF;
2367: IF (x_cim_rec.object_version_number = OKC_API.G_MISS_NUM)
2368: THEN
2369: x_cim_rec.object_version_number := l_cim_rec.object_version_number;
2370: END IF;
2371: IF (x_cim_rec.created_by = OKC_API.G_MISS_NUM)

Line 2371: IF (x_cim_rec.created_by = OKC_API.G_MISS_NUM)

2367: IF (x_cim_rec.object_version_number = OKC_API.G_MISS_NUM)
2368: THEN
2369: x_cim_rec.object_version_number := l_cim_rec.object_version_number;
2370: END IF;
2371: IF (x_cim_rec.created_by = OKC_API.G_MISS_NUM)
2372: THEN
2373: x_cim_rec.created_by := l_cim_rec.created_by;
2374: END IF;
2375: IF (x_cim_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2375: IF (x_cim_rec.creation_date = OKC_API.G_MISS_DATE)

2371: IF (x_cim_rec.created_by = OKC_API.G_MISS_NUM)
2372: THEN
2373: x_cim_rec.created_by := l_cim_rec.created_by;
2374: END IF;
2375: IF (x_cim_rec.creation_date = OKC_API.G_MISS_DATE)
2376: THEN
2377: x_cim_rec.creation_date := l_cim_rec.creation_date;
2378: END IF;
2379: IF (x_cim_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2379: IF (x_cim_rec.last_updated_by = OKC_API.G_MISS_NUM)

2375: IF (x_cim_rec.creation_date = OKC_API.G_MISS_DATE)
2376: THEN
2377: x_cim_rec.creation_date := l_cim_rec.creation_date;
2378: END IF;
2379: IF (x_cim_rec.last_updated_by = OKC_API.G_MISS_NUM)
2380: THEN
2381: x_cim_rec.last_updated_by := l_cim_rec.last_updated_by;
2382: END IF;
2383: IF (x_cim_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2383: IF (x_cim_rec.last_update_date = OKC_API.G_MISS_DATE)

2379: IF (x_cim_rec.last_updated_by = OKC_API.G_MISS_NUM)
2380: THEN
2381: x_cim_rec.last_updated_by := l_cim_rec.last_updated_by;
2382: END IF;
2383: IF (x_cim_rec.last_update_date = OKC_API.G_MISS_DATE)
2384: THEN
2385: x_cim_rec.last_update_date := l_cim_rec.last_update_date;
2386: END IF;
2387: IF (x_cim_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2387: IF (x_cim_rec.last_update_login = OKC_API.G_MISS_NUM)

2383: IF (x_cim_rec.last_update_date = OKC_API.G_MISS_DATE)
2384: THEN
2385: x_cim_rec.last_update_date := l_cim_rec.last_update_date;
2386: END IF;
2387: IF (x_cim_rec.last_update_login = OKC_API.G_MISS_NUM)
2388: THEN
2389: x_cim_rec.last_update_login := l_cim_rec.last_update_login;
2390: END IF;
2391: IF (x_cim_rec.request_id = OKC_API.G_MISS_NUM)

Line 2391: IF (x_cim_rec.request_id = OKC_API.G_MISS_NUM)

2387: IF (x_cim_rec.last_update_login = OKC_API.G_MISS_NUM)
2388: THEN
2389: x_cim_rec.last_update_login := l_cim_rec.last_update_login;
2390: END IF;
2391: IF (x_cim_rec.request_id = OKC_API.G_MISS_NUM)
2392: THEN
2393: x_cim_rec.request_id := l_cim_rec.request_id;
2394: END IF;
2395: IF (x_cim_rec.program_application_id = OKC_API.G_MISS_NUM)

Line 2395: IF (x_cim_rec.program_application_id = OKC_API.G_MISS_NUM)

2391: IF (x_cim_rec.request_id = OKC_API.G_MISS_NUM)
2392: THEN
2393: x_cim_rec.request_id := l_cim_rec.request_id;
2394: END IF;
2395: IF (x_cim_rec.program_application_id = OKC_API.G_MISS_NUM)
2396: THEN
2397: x_cim_rec.program_application_id := l_cim_rec.program_application_id ;
2398: END IF;
2399: IF (x_cim_rec.program_id = OKC_API.G_MISS_NUM)

Line 2399: IF (x_cim_rec.program_id = OKC_API.G_MISS_NUM)

2395: IF (x_cim_rec.program_application_id = OKC_API.G_MISS_NUM)
2396: THEN
2397: x_cim_rec.program_application_id := l_cim_rec.program_application_id ;
2398: END IF;
2399: IF (x_cim_rec.program_id = OKC_API.G_MISS_NUM)
2400: THEN
2401: x_cim_rec.program_id := l_cim_rec.program_id ;
2402: END IF;
2403: IF (x_cim_rec.program_update_date = OKC_API.G_MISS_DATE)

Line 2403: IF (x_cim_rec.program_update_date = OKC_API.G_MISS_DATE)

2399: IF (x_cim_rec.program_id = OKC_API.G_MISS_NUM)
2400: THEN
2401: x_cim_rec.program_id := l_cim_rec.program_id ;
2402: END IF;
2403: IF (x_cim_rec.program_update_date = OKC_API.G_MISS_DATE)
2404: THEN
2405: x_cim_rec.program_update_date := l_cim_rec.program_update_date ;
2406: END IF;
2407:

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

2419: FUNCTION Set_Attributes (
2420: p_cim_rec IN cim_rec_type,
2421: x_cim_rec OUT NOCOPY cim_rec_type
2422: ) RETURN VARCHAR2 IS
2423: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2424: BEGIN
2425:
2426: x_cim_rec := p_cim_rec;
2427: RETURN(l_return_status);

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

2433: okc_debug.Set_Indentation('OKC_CIM_PVT');
2434: okc_debug.log('9200: Entered update_row', 2);
2435: END IF;
2436:
2437: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2438: p_init_msg_list,
2439: '_PVT',
2440: x_return_status);
2441: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2437: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2438: p_init_msg_list,
2439: '_PVT',
2440: x_return_status);
2441: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2442: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2443: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2444: RAISE OKC_API.G_EXCEPTION_ERROR;
2445: END IF;

Line 2442: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2438: p_init_msg_list,
2439: '_PVT',
2440: x_return_status);
2441: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2442: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2443: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2444: RAISE OKC_API.G_EXCEPTION_ERROR;
2445: END IF;
2446: --- Setting item attributes

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

2439: '_PVT',
2440: x_return_status);
2441: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2442: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2443: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2444: RAISE OKC_API.G_EXCEPTION_ERROR;
2445: END IF;
2446: --- Setting item attributes
2447: l_return_status := Set_Attributes(

Line 2444: RAISE OKC_API.G_EXCEPTION_ERROR;

2440: x_return_status);
2441: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2442: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2443: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2444: RAISE OKC_API.G_EXCEPTION_ERROR;
2445: END IF;
2446: --- Setting item attributes
2447: l_return_status := Set_Attributes(
2448: p_cim_rec, -- IN

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

2447: l_return_status := Set_Attributes(
2448: p_cim_rec, -- IN
2449: l_cim_rec); -- OUT
2450: --- If any errors happen abort API
2451: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2452: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2453: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_ERROR;
2455: END IF;

Line 2452: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2448: p_cim_rec, -- IN
2449: l_cim_rec); -- OUT
2450: --- If any errors happen abort API
2451: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2452: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2453: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_ERROR;
2455: END IF;
2456: l_return_status := populate_new_record(l_cim_rec, l_def_cim_rec);

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

2449: l_cim_rec); -- OUT
2450: --- If any errors happen abort API
2451: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2452: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2453: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_ERROR;
2455: END IF;
2456: l_return_status := populate_new_record(l_cim_rec, l_def_cim_rec);
2457: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2454: RAISE OKC_API.G_EXCEPTION_ERROR;

2450: --- If any errors happen abort API
2451: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2452: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2453: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_ERROR;
2455: END IF;
2456: l_return_status := populate_new_record(l_cim_rec, l_def_cim_rec);
2457: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2458: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2453: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_ERROR;
2455: END IF;
2456: l_return_status := populate_new_record(l_cim_rec, l_def_cim_rec);
2457: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2458: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2459: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2460: RAISE OKC_API.G_EXCEPTION_ERROR;
2461: END IF;

Line 2458: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2454: RAISE OKC_API.G_EXCEPTION_ERROR;
2455: END IF;
2456: l_return_status := populate_new_record(l_cim_rec, l_def_cim_rec);
2457: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2458: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2459: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2460: RAISE OKC_API.G_EXCEPTION_ERROR;
2461: END IF;
2462: UPDATE OKC_K_ITEMS

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

2455: END IF;
2456: l_return_status := populate_new_record(l_cim_rec, l_def_cim_rec);
2457: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2458: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2459: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2460: RAISE OKC_API.G_EXCEPTION_ERROR;
2461: END IF;
2462: UPDATE OKC_K_ITEMS
2463: SET CLE_ID = l_def_cim_rec.cle_id,

Line 2460: RAISE OKC_API.G_EXCEPTION_ERROR;

2456: l_return_status := populate_new_record(l_cim_rec, l_def_cim_rec);
2457: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2458: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2459: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2460: RAISE OKC_API.G_EXCEPTION_ERROR;
2461: END IF;
2462: UPDATE OKC_K_ITEMS
2463: SET CLE_ID = l_def_cim_rec.cle_id,
2464: CHR_ID = l_def_cim_rec.chr_id,

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

2485: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_cim_rec.program_application_id)
2486: WHERE ID = l_def_cim_rec.id;
2487:
2488: x_cim_rec := l_def_cim_rec;
2489: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2490:
2491: IF (l_debug = 'Y') THEN
2492: okc_debug.log('9300: Leaving update_row', 2);
2493: okc_debug.Reset_Indentation;

Line 2497: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2493: okc_debug.Reset_Indentation;
2494: END IF;
2495:
2496: EXCEPTION
2497: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2498:
2499: IF (l_debug = 'Y') THEN
2500: okc_debug.log('9400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2501: okc_debug.Reset_Indentation;

Line 2500: okc_debug.log('9400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2496: EXCEPTION
2497: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2498:
2499: IF (l_debug = 'Y') THEN
2500: okc_debug.log('9400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2501: okc_debug.Reset_Indentation;
2502: END IF;
2503:
2504: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2504: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2500: okc_debug.log('9400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2501: okc_debug.Reset_Indentation;
2502: END IF;
2503:
2504: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2505: (
2506: l_api_name,
2507: G_PKG_NAME,
2508: 'OKC_API.G_RET_STS_ERROR',

Line 2508: 'OKC_API.G_RET_STS_ERROR',

2504: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2505: (
2506: l_api_name,
2507: G_PKG_NAME,
2508: 'OKC_API.G_RET_STS_ERROR',
2509: x_msg_count,
2510: x_msg_data,
2511: '_PVT'
2512: );

Line 2513: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2509: x_msg_count,
2510: x_msg_data,
2511: '_PVT'
2512: );
2513: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2514:
2515: IF (l_debug = 'Y') THEN
2516: okc_debug.log('9500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2517: okc_debug.Reset_Indentation;

Line 2516: okc_debug.log('9500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2512: );
2513: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2514:
2515: IF (l_debug = 'Y') THEN
2516: okc_debug.log('9500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2517: okc_debug.Reset_Indentation;
2518: END IF;
2519:
2520: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2520: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2516: okc_debug.log('9500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2517: okc_debug.Reset_Indentation;
2518: END IF;
2519:
2520: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2521: (
2522: l_api_name,
2523: G_PKG_NAME,
2524: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2524: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2520: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2521: (
2522: l_api_name,
2523: G_PKG_NAME,
2524: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2525: x_msg_count,
2526: x_msg_data,
2527: '_PVT'
2528: );

Line 2536: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2532: okc_debug.log('9600: Exiting update_row:OTHERS Exception', 2);
2533: okc_debug.Reset_Indentation;
2534: END IF;
2535:
2536: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2537: (
2538: l_api_name,
2539: G_PKG_NAME,
2540: 'OTHERS',

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

2557: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
2558:
2559: l_api_version CONSTANT NUMBER := 1;
2560: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2561: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2562: l_cimv_rec cimv_rec_type := p_cimv_rec;
2563: l_def_cimv_rec cimv_rec_type;
2564: l_cim_rec cim_rec_type;
2565: lx_cim_rec cim_rec_type;

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

2587: x_cimv_rec OUT NOCOPY cimv_rec_type
2588: ) RETURN VARCHAR2 IS
2589: l_cimv_rec cimv_rec_type;
2590: l_row_notfound BOOLEAN := TRUE;
2591: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2592: BEGIN
2593:
2594: IF (l_debug = 'Y') THEN
2595: okc_debug.Set_Indentation('OKC_CIM_PVT');

Line 2603: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2599: x_cimv_rec := p_cimv_rec;
2600: -- Get current database values
2601: l_cimv_rec := get_rec(p_cimv_rec, l_row_notfound);
2602: IF (l_row_notfound) THEN
2603: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2604: END IF;
2605: IF (x_cimv_rec.id = OKC_API.G_MISS_NUM)
2606: THEN
2607: x_cimv_rec.id := l_cimv_rec.id;

Line 2605: IF (x_cimv_rec.id = OKC_API.G_MISS_NUM)

2601: l_cimv_rec := get_rec(p_cimv_rec, l_row_notfound);
2602: IF (l_row_notfound) THEN
2603: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2604: END IF;
2605: IF (x_cimv_rec.id = OKC_API.G_MISS_NUM)
2606: THEN
2607: x_cimv_rec.id := l_cimv_rec.id;
2608: END IF;
2609: IF (x_cimv_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 2609: IF (x_cimv_rec.object_version_number = OKC_API.G_MISS_NUM)

2605: IF (x_cimv_rec.id = OKC_API.G_MISS_NUM)
2606: THEN
2607: x_cimv_rec.id := l_cimv_rec.id;
2608: END IF;
2609: IF (x_cimv_rec.object_version_number = OKC_API.G_MISS_NUM)
2610: THEN
2611: x_cimv_rec.object_version_number := l_cimv_rec.object_version_number;
2612: END IF;
2613: IF (x_cimv_rec.cle_id = OKC_API.G_MISS_NUM)

Line 2613: IF (x_cimv_rec.cle_id = OKC_API.G_MISS_NUM)

2609: IF (x_cimv_rec.object_version_number = OKC_API.G_MISS_NUM)
2610: THEN
2611: x_cimv_rec.object_version_number := l_cimv_rec.object_version_number;
2612: END IF;
2613: IF (x_cimv_rec.cle_id = OKC_API.G_MISS_NUM)
2614: THEN
2615: x_cimv_rec.cle_id := l_cimv_rec.cle_id;
2616: END IF;
2617: IF (x_cimv_rec.chr_id = OKC_API.G_MISS_NUM)

Line 2617: IF (x_cimv_rec.chr_id = OKC_API.G_MISS_NUM)

2613: IF (x_cimv_rec.cle_id = OKC_API.G_MISS_NUM)
2614: THEN
2615: x_cimv_rec.cle_id := l_cimv_rec.cle_id;
2616: END IF;
2617: IF (x_cimv_rec.chr_id = OKC_API.G_MISS_NUM)
2618: THEN
2619: x_cimv_rec.chr_id := l_cimv_rec.chr_id;
2620: END IF;
2621: IF (x_cimv_rec.cle_id_for = OKC_API.G_MISS_NUM)

Line 2621: IF (x_cimv_rec.cle_id_for = OKC_API.G_MISS_NUM)

2617: IF (x_cimv_rec.chr_id = OKC_API.G_MISS_NUM)
2618: THEN
2619: x_cimv_rec.chr_id := l_cimv_rec.chr_id;
2620: END IF;
2621: IF (x_cimv_rec.cle_id_for = OKC_API.G_MISS_NUM)
2622: THEN
2623: x_cimv_rec.cle_id_for := l_cimv_rec.cle_id_for;
2624: END IF;
2625: IF (x_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

Line 2625: IF (x_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

2621: IF (x_cimv_rec.cle_id_for = OKC_API.G_MISS_NUM)
2622: THEN
2623: x_cimv_rec.cle_id_for := l_cimv_rec.cle_id_for;
2624: END IF;
2625: IF (x_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
2626: THEN
2627: x_cimv_rec.dnz_chr_id := l_cimv_rec.dnz_chr_id;
2628: END IF;
2629: IF (x_cimv_rec.object1_id1 = OKC_API.G_MISS_CHAR)

Line 2629: IF (x_cimv_rec.object1_id1 = OKC_API.G_MISS_CHAR)

2625: IF (x_cimv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
2626: THEN
2627: x_cimv_rec.dnz_chr_id := l_cimv_rec.dnz_chr_id;
2628: END IF;
2629: IF (x_cimv_rec.object1_id1 = OKC_API.G_MISS_CHAR)
2630: THEN
2631: x_cimv_rec.object1_id1 := l_cimv_rec.object1_id1;
2632: END IF;
2633: IF (x_cimv_rec.object1_id2 = OKC_API.G_MISS_CHAR)

Line 2633: IF (x_cimv_rec.object1_id2 = OKC_API.G_MISS_CHAR)

2629: IF (x_cimv_rec.object1_id1 = OKC_API.G_MISS_CHAR)
2630: THEN
2631: x_cimv_rec.object1_id1 := l_cimv_rec.object1_id1;
2632: END IF;
2633: IF (x_cimv_rec.object1_id2 = OKC_API.G_MISS_CHAR)
2634: THEN
2635: x_cimv_rec.object1_id2 := l_cimv_rec.object1_id2;
2636: END IF;
2637: IF (x_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)

Line 2637: IF (x_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)

2633: IF (x_cimv_rec.object1_id2 = OKC_API.G_MISS_CHAR)
2634: THEN
2635: x_cimv_rec.object1_id2 := l_cimv_rec.object1_id2;
2636: END IF;
2637: IF (x_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)
2638: THEN
2639: x_cimv_rec.jtot_object1_code := l_cimv_rec.jtot_object1_code;
2640: END IF;
2641: IF (x_cimv_rec.uom_code = OKC_API.G_MISS_CHAR)

Line 2641: IF (x_cimv_rec.uom_code = OKC_API.G_MISS_CHAR)

2637: IF (x_cimv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)
2638: THEN
2639: x_cimv_rec.jtot_object1_code := l_cimv_rec.jtot_object1_code;
2640: END IF;
2641: IF (x_cimv_rec.uom_code = OKC_API.G_MISS_CHAR)
2642: THEN
2643: x_cimv_rec.uom_code := l_cimv_rec.uom_code;
2644: END IF;
2645: IF (x_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR)

Line 2645: IF (x_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR)

2641: IF (x_cimv_rec.uom_code = OKC_API.G_MISS_CHAR)
2642: THEN
2643: x_cimv_rec.uom_code := l_cimv_rec.uom_code;
2644: END IF;
2645: IF (x_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR)
2646: THEN
2647: x_cimv_rec.exception_yn := l_cimv_rec.exception_yn;
2648: END IF;
2649: IF (x_cimv_rec.number_of_items = OKC_API.G_MISS_NUM)

Line 2649: IF (x_cimv_rec.number_of_items = OKC_API.G_MISS_NUM)

2645: IF (x_cimv_rec.exception_yn = OKC_API.G_MISS_CHAR)
2646: THEN
2647: x_cimv_rec.exception_yn := l_cimv_rec.exception_yn;
2648: END IF;
2649: IF (x_cimv_rec.number_of_items = OKC_API.G_MISS_NUM)
2650: THEN
2651: x_cimv_rec.number_of_items := l_cimv_rec.number_of_items;
2652: END IF;
2653: IF (x_cimv_rec.upg_orig_system_ref = OKC_API.G_MISS_CHAR)

Line 2653: IF (x_cimv_rec.upg_orig_system_ref = OKC_API.G_MISS_CHAR)

2649: IF (x_cimv_rec.number_of_items = OKC_API.G_MISS_NUM)
2650: THEN
2651: x_cimv_rec.number_of_items := l_cimv_rec.number_of_items;
2652: END IF;
2653: IF (x_cimv_rec.upg_orig_system_ref = OKC_API.G_MISS_CHAR)
2654: THEN
2655: x_cimv_rec.upg_orig_system_ref := l_cimv_rec.upg_orig_system_ref;
2656: END IF;
2657: IF (x_cimv_rec.upg_orig_system_ref_id = OKC_API.G_MISS_NUM)

Line 2657: IF (x_cimv_rec.upg_orig_system_ref_id = OKC_API.G_MISS_NUM)

2653: IF (x_cimv_rec.upg_orig_system_ref = OKC_API.G_MISS_CHAR)
2654: THEN
2655: x_cimv_rec.upg_orig_system_ref := l_cimv_rec.upg_orig_system_ref;
2656: END IF;
2657: IF (x_cimv_rec.upg_orig_system_ref_id = OKC_API.G_MISS_NUM)
2658: THEN
2659: x_cimv_rec.upg_orig_system_ref_id := l_cimv_rec.upg_orig_system_ref_id;
2660: END IF;
2661: IF (x_cimv_rec.priced_item_yn = OKC_API.G_MISS_CHAR)

Line 2661: IF (x_cimv_rec.priced_item_yn = OKC_API.G_MISS_CHAR)

2657: IF (x_cimv_rec.upg_orig_system_ref_id = OKC_API.G_MISS_NUM)
2658: THEN
2659: x_cimv_rec.upg_orig_system_ref_id := l_cimv_rec.upg_orig_system_ref_id;
2660: END IF;
2661: IF (x_cimv_rec.priced_item_yn = OKC_API.G_MISS_CHAR)
2662: THEN
2663: x_cimv_rec.priced_item_yn := l_cimv_rec.priced_item_yn;
2664: END IF;
2665: IF (x_cimv_rec.created_by = OKC_API.G_MISS_NUM)

Line 2665: IF (x_cimv_rec.created_by = OKC_API.G_MISS_NUM)

2661: IF (x_cimv_rec.priced_item_yn = OKC_API.G_MISS_CHAR)
2662: THEN
2663: x_cimv_rec.priced_item_yn := l_cimv_rec.priced_item_yn;
2664: END IF;
2665: IF (x_cimv_rec.created_by = OKC_API.G_MISS_NUM)
2666: THEN
2667: x_cimv_rec.created_by := l_cimv_rec.created_by;
2668: END IF;
2669: IF (x_cimv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2669: IF (x_cimv_rec.creation_date = OKC_API.G_MISS_DATE)

2665: IF (x_cimv_rec.created_by = OKC_API.G_MISS_NUM)
2666: THEN
2667: x_cimv_rec.created_by := l_cimv_rec.created_by;
2668: END IF;
2669: IF (x_cimv_rec.creation_date = OKC_API.G_MISS_DATE)
2670: THEN
2671: x_cimv_rec.creation_date := l_cimv_rec.creation_date;
2672: END IF;
2673: IF (x_cimv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2673: IF (x_cimv_rec.last_updated_by = OKC_API.G_MISS_NUM)

2669: IF (x_cimv_rec.creation_date = OKC_API.G_MISS_DATE)
2670: THEN
2671: x_cimv_rec.creation_date := l_cimv_rec.creation_date;
2672: END IF;
2673: IF (x_cimv_rec.last_updated_by = OKC_API.G_MISS_NUM)
2674: THEN
2675: x_cimv_rec.last_updated_by := l_cimv_rec.last_updated_by;
2676: END IF;
2677: IF (x_cimv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2677: IF (x_cimv_rec.last_update_date = OKC_API.G_MISS_DATE)

2673: IF (x_cimv_rec.last_updated_by = OKC_API.G_MISS_NUM)
2674: THEN
2675: x_cimv_rec.last_updated_by := l_cimv_rec.last_updated_by;
2676: END IF;
2677: IF (x_cimv_rec.last_update_date = OKC_API.G_MISS_DATE)
2678: THEN
2679: x_cimv_rec.last_update_date := l_cimv_rec.last_update_date;
2680: END IF;
2681: IF (x_cimv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2681: IF (x_cimv_rec.last_update_login = OKC_API.G_MISS_NUM)

2677: IF (x_cimv_rec.last_update_date = OKC_API.G_MISS_DATE)
2678: THEN
2679: x_cimv_rec.last_update_date := l_cimv_rec.last_update_date;
2680: END IF;
2681: IF (x_cimv_rec.last_update_login = OKC_API.G_MISS_NUM)
2682: THEN
2683: x_cimv_rec.last_update_login := l_cimv_rec.last_update_login;
2684: END IF;
2685: ---

Line 2686: IF (x_cimv_rec.request_id = OKC_API.G_MISS_NUM)

2682: THEN
2683: x_cimv_rec.last_update_login := l_cimv_rec.last_update_login;
2684: END IF;
2685: ---
2686: IF (x_cimv_rec.request_id = OKC_API.G_MISS_NUM)
2687: THEN
2688: x_cimv_rec.request_id := l_cimv_rec.request_id;
2689: END IF;
2690: IF (x_cimv_rec.program_application_id = OKC_API.G_MISS_NUM)

Line 2690: IF (x_cimv_rec.program_application_id = OKC_API.G_MISS_NUM)

2686: IF (x_cimv_rec.request_id = OKC_API.G_MISS_NUM)
2687: THEN
2688: x_cimv_rec.request_id := l_cimv_rec.request_id;
2689: END IF;
2690: IF (x_cimv_rec.program_application_id = OKC_API.G_MISS_NUM)
2691: THEN
2692: x_cimv_rec.program_application_id := l_cimv_rec.program_application_id;
2693: END IF;
2694: IF (x_cimv_rec.program_id = OKC_API.G_MISS_NUM)

Line 2694: IF (x_cimv_rec.program_id = OKC_API.G_MISS_NUM)

2690: IF (x_cimv_rec.program_application_id = OKC_API.G_MISS_NUM)
2691: THEN
2692: x_cimv_rec.program_application_id := l_cimv_rec.program_application_id;
2693: END IF;
2694: IF (x_cimv_rec.program_id = OKC_API.G_MISS_NUM)
2695: THEN
2696: x_cimv_rec.program_id := l_cimv_rec.program_id;
2697: END IF;
2698:

Line 2699: IF (x_cimv_rec.program_update_date = OKC_API.G_MISS_DATE)

2695: THEN
2696: x_cimv_rec.program_id := l_cimv_rec.program_id;
2697: END IF;
2698:
2699: IF (x_cimv_rec.program_update_date = OKC_API.G_MISS_DATE)
2700: THEN
2701: x_cimv_rec.program_update_date := l_cimv_rec.program_update_date;
2702: END IF;
2703:

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

2716: FUNCTION Set_Attributes (
2717: p_cimv_rec IN cimv_rec_type,
2718: x_cimv_rec OUT NOCOPY cimv_rec_type
2719: ) RETURN VARCHAR2 IS
2720: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2721: BEGIN
2722:
2723: x_cimv_rec := p_cimv_rec;
2724: x_cimv_rec.OBJECT_VERSION_NUMBER := NVL(x_cimv_rec.OBJECT_VERSION_NUMBER, 0) + 1;

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

2731: okc_debug.Set_Indentation('OKC_CIM_PVT');
2732: okc_debug.log('10000: Entered update_row', 2);
2733: END IF;
2734:
2735: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2736: G_PKG_NAME,
2737: p_init_msg_list,
2738: l_api_version,
2739: p_api_version,

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

2738: l_api_version,
2739: p_api_version,
2740: '_PVT',
2741: x_return_status);
2742: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2743: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2744: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2745: RAISE OKC_API.G_EXCEPTION_ERROR;
2746: END IF;

Line 2743: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2739: p_api_version,
2740: '_PVT',
2741: x_return_status);
2742: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2743: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2744: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2745: RAISE OKC_API.G_EXCEPTION_ERROR;
2746: END IF;
2747: --- Setting item attributes

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

2740: '_PVT',
2741: x_return_status);
2742: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2743: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2744: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2745: RAISE OKC_API.G_EXCEPTION_ERROR;
2746: END IF;
2747: --- Setting item attributes
2748: l_return_status := Set_Attributes(

Line 2745: RAISE OKC_API.G_EXCEPTION_ERROR;

2741: x_return_status);
2742: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2743: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2744: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2745: RAISE OKC_API.G_EXCEPTION_ERROR;
2746: END IF;
2747: --- Setting item attributes
2748: l_return_status := Set_Attributes(
2749: p_cimv_rec, -- IN

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

2748: l_return_status := Set_Attributes(
2749: p_cimv_rec, -- IN
2750: l_cimv_rec); -- OUT
2751: --- If any errors happen abort API
2752: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2753: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2754: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2755: RAISE OKC_API.G_EXCEPTION_ERROR;
2756: END IF;

Line 2753: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2749: p_cimv_rec, -- IN
2750: l_cimv_rec); -- OUT
2751: --- If any errors happen abort API
2752: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2753: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2754: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2755: RAISE OKC_API.G_EXCEPTION_ERROR;
2756: END IF;
2757: l_return_status := populate_new_record(l_cimv_rec, l_def_cimv_rec);

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

2750: l_cimv_rec); -- OUT
2751: --- If any errors happen abort API
2752: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2753: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2754: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2755: RAISE OKC_API.G_EXCEPTION_ERROR;
2756: END IF;
2757: l_return_status := populate_new_record(l_cimv_rec, l_def_cimv_rec);
2758: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2755: RAISE OKC_API.G_EXCEPTION_ERROR;

2751: --- If any errors happen abort API
2752: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2753: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2754: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2755: RAISE OKC_API.G_EXCEPTION_ERROR;
2756: END IF;
2757: l_return_status := populate_new_record(l_cimv_rec, l_def_cimv_rec);
2758: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2754: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2755: RAISE OKC_API.G_EXCEPTION_ERROR;
2756: END IF;
2757: l_return_status := populate_new_record(l_cimv_rec, l_def_cimv_rec);
2758: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2760: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2761: RAISE OKC_API.G_EXCEPTION_ERROR;
2762: END IF;

Line 2759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2755: RAISE OKC_API.G_EXCEPTION_ERROR;
2756: END IF;
2757: l_return_status := populate_new_record(l_cimv_rec, l_def_cimv_rec);
2758: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2760: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2761: RAISE OKC_API.G_EXCEPTION_ERROR;
2762: END IF;
2763: l_def_cimv_rec := fill_who_columns(l_def_cimv_rec);

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

2756: END IF;
2757: l_return_status := populate_new_record(l_cimv_rec, l_def_cimv_rec);
2758: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2760: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2761: RAISE OKC_API.G_EXCEPTION_ERROR;
2762: END IF;
2763: l_def_cimv_rec := fill_who_columns(l_def_cimv_rec);
2764: --- Validate all non-missing attributes (Item Level Validation)

Line 2761: RAISE OKC_API.G_EXCEPTION_ERROR;

2757: l_return_status := populate_new_record(l_cimv_rec, l_def_cimv_rec);
2758: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2760: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2761: RAISE OKC_API.G_EXCEPTION_ERROR;
2762: END IF;
2763: l_def_cimv_rec := fill_who_columns(l_def_cimv_rec);
2764: --- Validate all non-missing attributes (Item Level Validation)
2765: l_return_status := Validate_Attributes(l_def_cimv_rec);

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

2763: l_def_cimv_rec := fill_who_columns(l_def_cimv_rec);
2764: --- Validate all non-missing attributes (Item Level Validation)
2765: l_return_status := Validate_Attributes(l_def_cimv_rec);
2766: --- If any errors happen abort API
2767: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2769: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2770: RAISE OKC_API.G_EXCEPTION_ERROR;
2771: END IF;

Line 2768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2764: --- Validate all non-missing attributes (Item Level Validation)
2765: l_return_status := Validate_Attributes(l_def_cimv_rec);
2766: --- If any errors happen abort API
2767: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2769: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2770: RAISE OKC_API.G_EXCEPTION_ERROR;
2771: END IF;
2772: l_return_status := Validate_Record(l_def_cimv_rec);

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

2765: l_return_status := Validate_Attributes(l_def_cimv_rec);
2766: --- If any errors happen abort API
2767: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2769: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2770: RAISE OKC_API.G_EXCEPTION_ERROR;
2771: END IF;
2772: l_return_status := Validate_Record(l_def_cimv_rec);
2773: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2770: RAISE OKC_API.G_EXCEPTION_ERROR;

2766: --- If any errors happen abort API
2767: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2769: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2770: RAISE OKC_API.G_EXCEPTION_ERROR;
2771: END IF;
2772: l_return_status := Validate_Record(l_def_cimv_rec);
2773: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2774: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2769: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2770: RAISE OKC_API.G_EXCEPTION_ERROR;
2771: END IF;
2772: l_return_status := Validate_Record(l_def_cimv_rec);
2773: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2774: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2775: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2776: RAISE OKC_API.G_EXCEPTION_ERROR;
2777: END IF;

Line 2774: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2770: RAISE OKC_API.G_EXCEPTION_ERROR;
2771: END IF;
2772: l_return_status := Validate_Record(l_def_cimv_rec);
2773: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2774: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2775: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2776: RAISE OKC_API.G_EXCEPTION_ERROR;
2777: END IF;
2778:

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

2771: END IF;
2772: l_return_status := Validate_Record(l_def_cimv_rec);
2773: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2774: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2775: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2776: RAISE OKC_API.G_EXCEPTION_ERROR;
2777: END IF;
2778:
2779: --------------------------------------

Line 2776: RAISE OKC_API.G_EXCEPTION_ERROR;

2772: l_return_status := Validate_Record(l_def_cimv_rec);
2773: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2774: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2775: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2776: RAISE OKC_API.G_EXCEPTION_ERROR;
2777: END IF;
2778:
2779: --------------------------------------
2780: -- Move VIEW record to "Child" records

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

2790: x_msg_data,
2791: l_cim_rec,
2792: lx_cim_rec
2793: );
2794: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2795: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2797: RAISE OKC_API.G_EXCEPTION_ERROR;
2798: END IF;

Line 2795: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2791: l_cim_rec,
2792: lx_cim_rec
2793: );
2794: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2795: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2797: RAISE OKC_API.G_EXCEPTION_ERROR;
2798: END IF;
2799: migrate(lx_cim_rec, l_def_cimv_rec);

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

2792: lx_cim_rec
2793: );
2794: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2795: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2797: RAISE OKC_API.G_EXCEPTION_ERROR;
2798: END IF;
2799: migrate(lx_cim_rec, l_def_cimv_rec);
2800: x_cimv_rec := l_def_cimv_rec;

Line 2797: RAISE OKC_API.G_EXCEPTION_ERROR;

2793: );
2794: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2795: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2797: RAISE OKC_API.G_EXCEPTION_ERROR;
2798: END IF;
2799: migrate(lx_cim_rec, l_def_cimv_rec);
2800: x_cimv_rec := l_def_cimv_rec;
2801: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2797: RAISE OKC_API.G_EXCEPTION_ERROR;
2798: END IF;
2799: migrate(lx_cim_rec, l_def_cimv_rec);
2800: x_cimv_rec := l_def_cimv_rec;
2801: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2802:
2803: IF (l_debug = 'Y') THEN
2804: okc_debug.log('10100: Leaving update_row', 2);
2805: okc_debug.Reset_Indentation;

Line 2809: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2805: okc_debug.Reset_Indentation;
2806: END IF;
2807:
2808: EXCEPTION
2809: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2810:
2811: IF (l_debug = 'Y') THEN
2812: okc_debug.log('10200: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2813: okc_debug.Reset_Indentation;

Line 2812: okc_debug.log('10200: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2808: EXCEPTION
2809: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2810:
2811: IF (l_debug = 'Y') THEN
2812: okc_debug.log('10200: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2813: okc_debug.Reset_Indentation;
2814: END IF;
2815:
2816: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2816: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2812: okc_debug.log('10200: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2813: okc_debug.Reset_Indentation;
2814: END IF;
2815:
2816: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2817: (
2818: l_api_name,
2819: G_PKG_NAME,
2820: 'OKC_API.G_RET_STS_ERROR',

Line 2820: 'OKC_API.G_RET_STS_ERROR',

2816: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2817: (
2818: l_api_name,
2819: G_PKG_NAME,
2820: 'OKC_API.G_RET_STS_ERROR',
2821: x_msg_count,
2822: x_msg_data,
2823: '_PVT'
2824: );

Line 2825: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2821: x_msg_count,
2822: x_msg_data,
2823: '_PVT'
2824: );
2825: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2826:
2827: IF (l_debug = 'Y') THEN
2828: okc_debug.log('10300: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2829: okc_debug.Reset_Indentation;

Line 2828: okc_debug.log('10300: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2824: );
2825: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2826:
2827: IF (l_debug = 'Y') THEN
2828: okc_debug.log('10300: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2829: okc_debug.Reset_Indentation;
2830: END IF;
2831:
2832: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2832: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2828: okc_debug.log('10300: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2829: okc_debug.Reset_Indentation;
2830: END IF;
2831:
2832: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2833: (
2834: l_api_name,
2835: G_PKG_NAME,
2836: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2836: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2832: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2833: (
2834: l_api_name,
2835: G_PKG_NAME,
2836: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2837: x_msg_count,
2838: x_msg_data,
2839: '_PVT'
2840: );

Line 2848: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2844: okc_debug.log('10400: Exiting update_row:OTHERS Exception', 2);
2845: okc_debug.Reset_Indentation;
2846: END IF;
2847:
2848: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2849: (
2850: l_api_name,
2851: G_PKG_NAME,
2852: 'OTHERS',

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

2869: x_cimv_tbl OUT NOCOPY cimv_tbl_type) IS
2870:
2871: l_api_version CONSTANT NUMBER := 1;
2872: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2873: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2874: i NUMBER := 0;
2875: BEGIN
2876:
2877: IF (l_debug = 'Y') THEN

Line 2882: OKC_API.init_msg_list(p_init_msg_list);

2878: okc_debug.Set_Indentation('OKC_CIM_PVT');
2879: okc_debug.log('10500: Entered update_row', 2);
2880: END IF;
2881:
2882: OKC_API.init_msg_list(p_init_msg_list);
2883: -- Make sure PL/SQL table has records in it before passing
2884: IF (p_cimv_tbl.COUNT > 0) THEN
2885: i := p_cimv_tbl.FIRST;
2886: LOOP

Line 2889: p_init_msg_list => OKC_API.G_FALSE,

2885: i := p_cimv_tbl.FIRST;
2886: LOOP
2887: update_row (
2888: p_api_version => p_api_version,
2889: p_init_msg_list => OKC_API.G_FALSE,
2890: x_return_status => x_return_status,
2891: x_msg_count => x_msg_count,
2892: x_msg_data => x_msg_data,
2893: p_cimv_rec => p_cimv_tbl(i),

Line 2906: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2902: okc_debug.Reset_Indentation;
2903: END IF;
2904:
2905: EXCEPTION
2906: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2907:
2908: IF (l_debug = 'Y') THEN
2909: okc_debug.log('10700: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2910: okc_debug.Reset_Indentation;

Line 2909: okc_debug.log('10700: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2905: EXCEPTION
2906: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2907:
2908: IF (l_debug = 'Y') THEN
2909: okc_debug.log('10700: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2910: okc_debug.Reset_Indentation;
2911: END IF;
2912:
2913: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2913: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2909: okc_debug.log('10700: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2910: okc_debug.Reset_Indentation;
2911: END IF;
2912:
2913: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2914: (
2915: l_api_name,
2916: G_PKG_NAME,
2917: 'OKC_API.G_RET_STS_ERROR',

Line 2917: 'OKC_API.G_RET_STS_ERROR',

2913: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2914: (
2915: l_api_name,
2916: G_PKG_NAME,
2917: 'OKC_API.G_RET_STS_ERROR',
2918: x_msg_count,
2919: x_msg_data,
2920: '_PVT'
2921: );

Line 2922: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2918: x_msg_count,
2919: x_msg_data,
2920: '_PVT'
2921: );
2922: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2923:
2924: IF (l_debug = 'Y') THEN
2925: okc_debug.log('10800: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2926: okc_debug.Reset_Indentation;

Line 2925: okc_debug.log('10800: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2921: );
2922: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2923:
2924: IF (l_debug = 'Y') THEN
2925: okc_debug.log('10800: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2926: okc_debug.Reset_Indentation;
2927: END IF;
2928:
2929: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2929: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2925: okc_debug.log('10800: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2926: okc_debug.Reset_Indentation;
2927: END IF;
2928:
2929: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2930: (
2931: l_api_name,
2932: G_PKG_NAME,
2933: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2933: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2929: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2930: (
2931: l_api_name,
2932: G_PKG_NAME,
2933: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2934: x_msg_count,
2935: x_msg_data,
2936: '_PVT'
2937: );

Line 2945: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2941: okc_debug.log('10900: Exiting update_row:OTHERS Exception', 2);
2942: okc_debug.Reset_Indentation;
2943: END IF;
2944:
2945: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2946: (
2947: l_api_name,
2948: G_PKG_NAME,
2949: 'OTHERS',

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

2968: p_cim_rec IN cim_rec_type) IS
2969:
2970: l_api_version CONSTANT NUMBER := 1;
2971: l_api_name CONSTANT VARCHAR2(30) := 'ITEMS_delete_row';
2972: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2973: l_cim_rec cim_rec_type:= p_cim_rec;
2974: l_row_notfound BOOLEAN := TRUE;
2975: BEGIN
2976:

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

2978: okc_debug.Set_Indentation('OKC_CIM_PVT');
2979: okc_debug.log('11000: Entered delete_row', 2);
2980: END IF;
2981:
2982: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2983: p_init_msg_list,
2984: '_PVT',
2985: x_return_status);
2986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2982: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2983: p_init_msg_list,
2984: '_PVT',
2985: x_return_status);
2986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2989: RAISE OKC_API.G_EXCEPTION_ERROR;
2990: END IF;

Line 2987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2983: p_init_msg_list,
2984: '_PVT',
2985: x_return_status);
2986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2989: RAISE OKC_API.G_EXCEPTION_ERROR;
2990: END IF;
2991: DELETE FROM OKC_K_ITEMS

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

2984: '_PVT',
2985: x_return_status);
2986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2989: RAISE OKC_API.G_EXCEPTION_ERROR;
2990: END IF;
2991: DELETE FROM OKC_K_ITEMS
2992: WHERE ID = l_cim_rec.id;

Line 2989: RAISE OKC_API.G_EXCEPTION_ERROR;

2985: x_return_status);
2986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2989: RAISE OKC_API.G_EXCEPTION_ERROR;
2990: END IF;
2991: DELETE FROM OKC_K_ITEMS
2992: WHERE ID = l_cim_rec.id;
2993:

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

2990: END IF;
2991: DELETE FROM OKC_K_ITEMS
2992: WHERE ID = l_cim_rec.id;
2993:
2994: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2995:
2996: IF (l_debug = 'Y') THEN
2997: okc_debug.log('11100: Leaving delete_row', 2);
2998: okc_debug.Reset_Indentation;

Line 3002: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2998: okc_debug.Reset_Indentation;
2999: END IF;
3000:
3001: EXCEPTION
3002: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3003:
3004: IF (l_debug = 'Y') THEN
3005: okc_debug.log('11200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3006: okc_debug.Reset_Indentation;

Line 3005: okc_debug.log('11200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

3001: EXCEPTION
3002: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3003:
3004: IF (l_debug = 'Y') THEN
3005: okc_debug.log('11200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3006: okc_debug.Reset_Indentation;
3007: END IF;
3008:
3009: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3009: x_return_status := OKC_API.HANDLE_EXCEPTIONS

3005: okc_debug.log('11200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3006: okc_debug.Reset_Indentation;
3007: END IF;
3008:
3009: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3010: (
3011: l_api_name,
3012: G_PKG_NAME,
3013: 'OKC_API.G_RET_STS_ERROR',

Line 3013: 'OKC_API.G_RET_STS_ERROR',

3009: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3010: (
3011: l_api_name,
3012: G_PKG_NAME,
3013: 'OKC_API.G_RET_STS_ERROR',
3014: x_msg_count,
3015: x_msg_data,
3016: '_PVT'
3017: );

Line 3018: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3014: x_msg_count,
3015: x_msg_data,
3016: '_PVT'
3017: );
3018: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3019:
3020: IF (l_debug = 'Y') THEN
3021: okc_debug.log('11300: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3022: okc_debug.Reset_Indentation;

Line 3021: okc_debug.log('11300: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

3017: );
3018: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3019:
3020: IF (l_debug = 'Y') THEN
3021: okc_debug.log('11300: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3022: okc_debug.Reset_Indentation;
3023: END IF;
3024:
3025: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3025: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3021: okc_debug.log('11300: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3022: okc_debug.Reset_Indentation;
3023: END IF;
3024:
3025: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3026: (
3027: l_api_name,
3028: G_PKG_NAME,
3029: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3029: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3025: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3026: (
3027: l_api_name,
3028: G_PKG_NAME,
3029: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3030: x_msg_count,
3031: x_msg_data,
3032: '_PVT'
3033: );

Line 3041: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3037: okc_debug.log('11400: Exiting delete_row:OTHERS Exception', 2);
3038: okc_debug.Reset_Indentation;
3039: END IF;
3040:
3041: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3042: (
3043: l_api_name,
3044: G_PKG_NAME,
3045: 'OTHERS',

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

3061: p_cimv_rec IN cimv_rec_type) IS
3062:
3063: l_api_version CONSTANT NUMBER := 1;
3064: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3065: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3066: l_cimv_rec cimv_rec_type := p_cimv_rec;
3067: l_cim_rec cim_rec_type;
3068: BEGIN
3069:

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

3071: okc_debug.Set_Indentation('OKC_CIM_PVT');
3072: okc_debug.log('11500: Entered delete_row', 2);
3073: END IF;
3074:
3075: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3076: G_PKG_NAME,
3077: p_init_msg_list,
3078: l_api_version,
3079: p_api_version,

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

3078: l_api_version,
3079: p_api_version,
3080: '_PVT',
3081: x_return_status);
3082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3085: RAISE OKC_API.G_EXCEPTION_ERROR;
3086: END IF;

Line 3083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3079: p_api_version,
3080: '_PVT',
3081: x_return_status);
3082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3085: RAISE OKC_API.G_EXCEPTION_ERROR;
3086: END IF;
3087: --------------------------------------

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

3080: '_PVT',
3081: x_return_status);
3082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3085: RAISE OKC_API.G_EXCEPTION_ERROR;
3086: END IF;
3087: --------------------------------------
3088: -- Move VIEW record to "Child" records

Line 3085: RAISE OKC_API.G_EXCEPTION_ERROR;

3081: x_return_status);
3082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3085: RAISE OKC_API.G_EXCEPTION_ERROR;
3086: END IF;
3087: --------------------------------------
3088: -- Move VIEW record to "Child" records
3089: --------------------------------------

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

3097: x_msg_count,
3098: x_msg_data,
3099: l_cim_rec
3100: );
3101: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3103: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3104: RAISE OKC_API.G_EXCEPTION_ERROR;
3105: END IF;

Line 3102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3098: x_msg_data,
3099: l_cim_rec
3100: );
3101: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3103: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3104: RAISE OKC_API.G_EXCEPTION_ERROR;
3105: END IF;
3106: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

3099: l_cim_rec
3100: );
3101: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3103: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3104: RAISE OKC_API.G_EXCEPTION_ERROR;
3105: END IF;
3106: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3107:

Line 3104: RAISE OKC_API.G_EXCEPTION_ERROR;

3100: );
3101: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3103: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3104: RAISE OKC_API.G_EXCEPTION_ERROR;
3105: END IF;
3106: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3107:
3108: IF (l_debug = 'Y') THEN

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

3102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3103: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3104: RAISE OKC_API.G_EXCEPTION_ERROR;
3105: END IF;
3106: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3107:
3108: IF (l_debug = 'Y') THEN
3109: okc_debug.log('11600: Leaving delete_row', 2);
3110: okc_debug.Reset_Indentation;

Line 3114: WHEN OKC_API.G_EXCEPTION_ERROR THEN

3110: okc_debug.Reset_Indentation;
3111: END IF;
3112:
3113: EXCEPTION
3114: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3115:
3116: IF (l_debug = 'Y') THEN
3117: okc_debug.log('11700: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3118: okc_debug.Reset_Indentation;

Line 3117: okc_debug.log('11700: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

3113: EXCEPTION
3114: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3115:
3116: IF (l_debug = 'Y') THEN
3117: okc_debug.log('11700: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3118: okc_debug.Reset_Indentation;
3119: END IF;
3120:
3121: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3121: x_return_status := OKC_API.HANDLE_EXCEPTIONS

3117: okc_debug.log('11700: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3118: okc_debug.Reset_Indentation;
3119: END IF;
3120:
3121: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3122: (
3123: l_api_name,
3124: G_PKG_NAME,
3125: 'OKC_API.G_RET_STS_ERROR',

Line 3125: 'OKC_API.G_RET_STS_ERROR',

3121: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3122: (
3123: l_api_name,
3124: G_PKG_NAME,
3125: 'OKC_API.G_RET_STS_ERROR',
3126: x_msg_count,
3127: x_msg_data,
3128: '_PVT'
3129: );

Line 3130: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3126: x_msg_count,
3127: x_msg_data,
3128: '_PVT'
3129: );
3130: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3131:
3132: IF (l_debug = 'Y') THEN
3133: okc_debug.log('11800: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3134: okc_debug.Reset_Indentation;

Line 3133: okc_debug.log('11800: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

3129: );
3130: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3131:
3132: IF (l_debug = 'Y') THEN
3133: okc_debug.log('11800: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3134: okc_debug.Reset_Indentation;
3135: END IF;
3136:
3137: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3137: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3133: okc_debug.log('11800: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3134: okc_debug.Reset_Indentation;
3135: END IF;
3136:
3137: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3138: (
3139: l_api_name,
3140: G_PKG_NAME,
3141: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3141: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3137: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3138: (
3139: l_api_name,
3140: G_PKG_NAME,
3141: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3142: x_msg_count,
3143: x_msg_data,
3144: '_PVT'
3145: );

Line 3153: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3149: okc_debug.log('11900: Exiting delete_row:OTHERS Exception', 2);
3150: okc_debug.Reset_Indentation;
3151: END IF;
3152:
3153: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3154: (
3155: l_api_name,
3156: G_PKG_NAME,
3157: 'OTHERS',

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

3173: p_cimv_tbl IN cimv_tbl_type) IS
3174:
3175: l_api_version CONSTANT NUMBER := 1;
3176: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3177: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3178: i NUMBER := 0;
3179: BEGIN
3180:
3181: IF (l_debug = 'Y') THEN

Line 3186: OKC_API.init_msg_list(p_init_msg_list);

3182: okc_debug.Set_Indentation('OKC_CIM_PVT');
3183: okc_debug.log('12000: Entered delete_row', 2);
3184: END IF;
3185:
3186: OKC_API.init_msg_list(p_init_msg_list);
3187: -- Make sure PL/SQL table has records in it before passing
3188: IF (p_cimv_tbl.COUNT > 0) THEN
3189: i := p_cimv_tbl.FIRST;
3190: LOOP

Line 3193: p_init_msg_list => OKC_API.G_FALSE,

3189: i := p_cimv_tbl.FIRST;
3190: LOOP
3191: delete_row (
3192: p_api_version => p_api_version,
3193: p_init_msg_list => OKC_API.G_FALSE,
3194: x_return_status => x_return_status,
3195: x_msg_count => x_msg_count,
3196: x_msg_data => x_msg_data,
3197: p_cimv_rec => p_cimv_tbl(i));

Line 3209: WHEN OKC_API.G_EXCEPTION_ERROR THEN

3205: okc_debug.Reset_Indentation;
3206: END IF;
3207:
3208: EXCEPTION
3209: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3210:
3211: IF (l_debug = 'Y') THEN
3212: okc_debug.log('12200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3213: okc_debug.Reset_Indentation;

Line 3212: okc_debug.log('12200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

3208: EXCEPTION
3209: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3210:
3211: IF (l_debug = 'Y') THEN
3212: okc_debug.log('12200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3213: okc_debug.Reset_Indentation;
3214: END IF;
3215:
3216: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3216: x_return_status := OKC_API.HANDLE_EXCEPTIONS

3212: okc_debug.log('12200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3213: okc_debug.Reset_Indentation;
3214: END IF;
3215:
3216: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3217: (
3218: l_api_name,
3219: G_PKG_NAME,
3220: 'OKC_API.G_RET_STS_ERROR',

Line 3220: 'OKC_API.G_RET_STS_ERROR',

3216: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3217: (
3218: l_api_name,
3219: G_PKG_NAME,
3220: 'OKC_API.G_RET_STS_ERROR',
3221: x_msg_count,
3222: x_msg_data,
3223: '_PVT'
3224: );

Line 3225: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3221: x_msg_count,
3222: x_msg_data,
3223: '_PVT'
3224: );
3225: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3226:
3227: IF (l_debug = 'Y') THEN
3228: okc_debug.log('12300: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3229: okc_debug.Reset_Indentation;

Line 3228: okc_debug.log('12300: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

3224: );
3225: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3226:
3227: IF (l_debug = 'Y') THEN
3228: okc_debug.log('12300: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3229: okc_debug.Reset_Indentation;
3230: END IF;
3231:
3232: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3232: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3228: okc_debug.log('12300: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3229: okc_debug.Reset_Indentation;
3230: END IF;
3231:
3232: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3233: (
3234: l_api_name,
3235: G_PKG_NAME,
3236: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3236: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3232: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3233: (
3234: l_api_name,
3235: G_PKG_NAME,
3236: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3237: x_msg_count,
3238: x_msg_data,
3239: '_PVT'
3240: );

Line 3248: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3244: okc_debug.log('12400: Exiting delete_row:OTHERS Exception', 2);
3245: okc_debug.Reset_Indentation;
3246: END IF;
3247:
3248: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3249: (
3250: l_api_name,
3251: G_PKG_NAME,
3252: 'OTHERS',

Line 3296: x_return_status := OKC_API.G_RET_STS_SUCCESS;

3292: j NUMBEr := 0;
3293:
3294: BEGIN
3295: -- Initializing return status
3296: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3297:
3298: IF (l_debug = 'Y') THEN
3299: okc_debug.Set_Indentation('OKC_CIM_PVT');
3300: okc_debug.log('12500: Entered INSERT_ROW_UPG', 2);

Line 3417: OKC_API.SET_MESSAGE(

3413: EXCEPTION
3414: WHEN OTHERS THEN
3415:
3416: -- store SQL error message on message stack
3417: OKC_API.SET_MESSAGE(
3418: p_app_name => G_APP_NAME,
3419: p_msg_name => G_UNEXPECTED_ERROR,
3420: p_token1 => G_SQLCODE_TOKEN,
3421: p_token1_value => SQLCODE,

Line 3425: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

3421: p_token1_value => SQLCODE,
3422: p_token2 => G_SQLERRM_TOKEN,
3423: p_token2_value => SQLERRM);
3424: -- notify caller of an error as UNEXPETED error
3425: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3426: IF (l_debug = 'Y') THEN
3427: okc_debug.log('12700: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
3428: okc_debug.Reset_Indentation;
3429: END IF;

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

3440: p_chr_id IN NUMBER,
3441: p_major_version IN NUMBER
3442: ) RETURN VARCHAR2 IS
3443:
3444: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3445:
3446: BEGIN
3447:
3448: IF (l_debug = 'Y') THEN

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

3520: okc_debug.Reset_Indentation;
3521: END IF;
3522:
3523: -- store SQL error message on message stack
3524: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3525: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3526: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3527: p_token1_value => sqlcode,
3528: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 3532: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

3528: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3529: p_token2_value => sqlerrm);
3530:
3531: -- notify UNEXPECTED error
3532: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3533: return l_return_status;
3534:
3535: END create_version;
3536:

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

3542: p_chr_id IN NUMBER,
3543: p_major_version IN NUMBER
3544: ) RETURN VARCHAR2 IS
3545:
3546: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3547:
3548: BEGIN
3549:
3550: IF (l_debug = 'Y') THEN

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

3620: okc_debug.Reset_Indentation;
3621: END IF;
3622:
3623: -- store SQL error message on message stack
3624: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3625: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3626: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3627: p_token1_value => sqlcode,
3628: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 3632: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

3628: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3629: p_token2_value => sqlerrm);
3630:
3631: -- notify UNEXPECTED error
3632: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3633: return l_return_status;
3634:
3635: END restore_version;
3636: