APPS.OKC_PAC_PVT dependencies on OKC_API

Line 215: IF (l_pacv_rec.pat_id = OKC_API.G_MISS_NUM) THEN

211: okc_debug.Set_Indentation('OKC_PAC_PVT');
212: okc_debug.log('900: Entered null_out_defaults', 2);
213: END IF;
214:
215: IF (l_pacv_rec.pat_id = OKC_API.G_MISS_NUM) THEN
216: l_pacv_rec.pat_id := NULL;
217: END IF;
218: IF (l_pacv_rec.pat_id_from = OKC_API.G_MISS_NUM) THEN
219: l_pacv_rec.pat_id_from := NULL;

Line 218: IF (l_pacv_rec.pat_id_from = OKC_API.G_MISS_NUM) THEN

214:
215: IF (l_pacv_rec.pat_id = OKC_API.G_MISS_NUM) THEN
216: l_pacv_rec.pat_id := NULL;
217: END IF;
218: IF (l_pacv_rec.pat_id_from = OKC_API.G_MISS_NUM) THEN
219: l_pacv_rec.pat_id_from := NULL;
220: END IF;
221: IF (l_pacv_rec.bsl_id = OKC_API.G_MISS_NUM) THEN
222: l_pacv_rec.bsl_id := NULL;

Line 221: IF (l_pacv_rec.bsl_id = OKC_API.G_MISS_NUM) THEN

217: END IF;
218: IF (l_pacv_rec.pat_id_from = OKC_API.G_MISS_NUM) THEN
219: l_pacv_rec.pat_id_from := NULL;
220: END IF;
221: IF (l_pacv_rec.bsl_id = OKC_API.G_MISS_NUM) THEN
222: l_pacv_rec.bsl_id := NULL;
223: END IF;
224: IF (l_pacv_rec.cle_id = OKC_API.G_MISS_NUM) THEN
225: l_pacv_rec.cle_id := NULL;

Line 224: IF (l_pacv_rec.cle_id = OKC_API.G_MISS_NUM) THEN

220: END IF;
221: IF (l_pacv_rec.bsl_id = OKC_API.G_MISS_NUM) THEN
222: l_pacv_rec.bsl_id := NULL;
223: END IF;
224: IF (l_pacv_rec.cle_id = OKC_API.G_MISS_NUM) THEN
225: l_pacv_rec.cle_id := NULL;
226: END IF;
227: IF (l_pacv_rec.bcl_id = OKC_API.G_MISS_NUM) THEN
228: l_pacv_rec.bcl_id := NULL;

Line 227: IF (l_pacv_rec.bcl_id = OKC_API.G_MISS_NUM) THEN

223: END IF;
224: IF (l_pacv_rec.cle_id = OKC_API.G_MISS_NUM) THEN
225: l_pacv_rec.cle_id := NULL;
226: END IF;
227: IF (l_pacv_rec.bcl_id = OKC_API.G_MISS_NUM) THEN
228: l_pacv_rec.bcl_id := NULL;
229: END IF;
230: IF (l_pacv_rec.created_by = OKC_API.G_MISS_NUM) THEN
231: l_pacv_rec.created_by := NULL;

Line 230: IF (l_pacv_rec.created_by = OKC_API.G_MISS_NUM) THEN

226: END IF;
227: IF (l_pacv_rec.bcl_id = OKC_API.G_MISS_NUM) THEN
228: l_pacv_rec.bcl_id := NULL;
229: END IF;
230: IF (l_pacv_rec.created_by = OKC_API.G_MISS_NUM) THEN
231: l_pacv_rec.created_by := NULL;
232: END IF;
233: IF (l_pacv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
234: l_pacv_rec.creation_date := NULL;

Line 233: IF (l_pacv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

229: END IF;
230: IF (l_pacv_rec.created_by = OKC_API.G_MISS_NUM) THEN
231: l_pacv_rec.created_by := NULL;
232: END IF;
233: IF (l_pacv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
234: l_pacv_rec.creation_date := NULL;
235: END IF;
236: IF (l_pacv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
237: l_pacv_rec.last_updated_by := NULL;

Line 236: IF (l_pacv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

232: END IF;
233: IF (l_pacv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
234: l_pacv_rec.creation_date := NULL;
235: END IF;
236: IF (l_pacv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
237: l_pacv_rec.last_updated_by := NULL;
238: END IF;
239: IF (l_pacv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
240: l_pacv_rec.last_update_date := NULL;

Line 239: IF (l_pacv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

235: END IF;
236: IF (l_pacv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
237: l_pacv_rec.last_updated_by := NULL;
238: END IF;
239: IF (l_pacv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
240: l_pacv_rec.last_update_date := NULL;
241: END IF;
242: IF (l_pacv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
243: l_pacv_rec.last_update_login := NULL;

Line 242: IF (l_pacv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

238: END IF;
239: IF (l_pacv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
240: l_pacv_rec.last_update_date := NULL;
241: END IF;
242: IF (l_pacv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
243: l_pacv_rec.last_update_login := NULL;
244: END IF;
245: IF (l_pacv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
246: l_pacv_rec.program_application_id := NULL;

Line 245: IF (l_pacv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN

241: END IF;
242: IF (l_pacv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
243: l_pacv_rec.last_update_login := NULL;
244: END IF;
245: IF (l_pacv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
246: l_pacv_rec.program_application_id := NULL;
247: END IF;
248: IF (l_pacv_rec.program_id = OKC_API.G_MISS_NUM) THEN
249: l_pacv_rec.program_id := NULL;

Line 248: IF (l_pacv_rec.program_id = OKC_API.G_MISS_NUM) THEN

244: END IF;
245: IF (l_pacv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
246: l_pacv_rec.program_application_id := NULL;
247: END IF;
248: IF (l_pacv_rec.program_id = OKC_API.G_MISS_NUM) THEN
249: l_pacv_rec.program_id := NULL;
250: END IF;
251: IF (l_pacv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
252: l_pacv_rec.program_update_date := NULL;

Line 251: IF (l_pacv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN

247: END IF;
248: IF (l_pacv_rec.program_id = OKC_API.G_MISS_NUM) THEN
249: l_pacv_rec.program_id := NULL;
250: END IF;
251: IF (l_pacv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
252: l_pacv_rec.program_update_date := NULL;
253: END IF;
254: IF (l_pacv_rec.request_id= OKC_API.G_MISS_NUM) THEN
255: l_pacv_rec.request_id := NULL;

Line 254: IF (l_pacv_rec.request_id= OKC_API.G_MISS_NUM) THEN

250: END IF;
251: IF (l_pacv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
252: l_pacv_rec.program_update_date := NULL;
253: END IF;
254: IF (l_pacv_rec.request_id= OKC_API.G_MISS_NUM) THEN
255: l_pacv_rec.request_id := NULL;
256: END IF;
257: IF (l_pacv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
258: l_pacv_rec.object_version_number := NULL;

Line 257: IF (l_pacv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

253: END IF;
254: IF (l_pacv_rec.request_id= OKC_API.G_MISS_NUM) THEN
255: l_pacv_rec.request_id := NULL;
256: END IF;
257: IF (l_pacv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
258: l_pacv_rec.object_version_number := NULL;
259: END IF;
260:
261: IF (l_debug = 'Y') THEN

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

276: ---------------------------------------------------------------------------
277: PROCEDURE validate_id(
278: p_pacv_rec IN pacv_rec_type,
279: x_return_status OUT NOCOPY VARCHAR2) IS
280: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
281: BEGIN
282:
283: IF (l_debug = 'Y') THEN
284: okc_debug.Set_Indentation('OKC_PAC_PVT');

Line 288: IF p_pacv_rec.id = OKC_API.G_MISS_NUM OR

284: okc_debug.Set_Indentation('OKC_PAC_PVT');
285: okc_debug.log('1000: Entered validate_id', 2);
286: END IF;
287:
288: IF p_pacv_rec.id = OKC_API.G_MISS_NUM OR
289: p_pacv_rec.id IS NULL
290: THEN
291: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
292: l_return_status := OKC_API.G_RET_STS_ERROR;

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

287:
288: IF p_pacv_rec.id = OKC_API.G_MISS_NUM OR
289: p_pacv_rec.id IS NULL
290: THEN
291: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
292: l_return_status := OKC_API.G_RET_STS_ERROR;
293: END IF;
294: x_return_status := l_return_status;
295:

Line 292: l_return_status := OKC_API.G_RET_STS_ERROR;

288: IF p_pacv_rec.id = OKC_API.G_MISS_NUM OR
289: p_pacv_rec.id IS NULL
290: THEN
291: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
292: l_return_status := OKC_API.G_RET_STS_ERROR;
293: END IF;
294: x_return_status := l_return_status;
295:
296: IF (l_debug = 'Y') THEN

Line 310: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

306: okc_debug.Reset_Indentation;
307: END IF;
308:
309: -- store SQL error message on message stack for caller
310: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
311: -- notify caller of an UNEXPECTED error
312: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
313:
314: END validate_id;

Line 312: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

308:
309: -- store SQL error message on message stack for caller
310: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
311: -- notify caller of an UNEXPECTED error
312: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
313:
314: END validate_id;
315:
316: ---------------------------------------------------------------------------

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

319:
320: PROCEDURE validate_pat_id_from(
321: p_pacv_rec IN pacv_rec_type,
322: x_return_status OUT NOCOPY VARCHAR2) IS
323: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
324: BEGIN
325:
326: IF (l_debug = 'Y') THEN
327: okc_debug.Set_Indentation('OKC_PAC_PVT');

Line 331: IF p_pacv_rec.pat_id_from = OKC_API.G_MISS_NUM OR

327: okc_debug.Set_Indentation('OKC_PAC_PVT');
328: okc_debug.log('1300: Entered validate_pat_id_from', 2);
329: END IF;
330:
331: IF p_pacv_rec.pat_id_from = OKC_API.G_MISS_NUM OR
332: p_pacv_rec.pat_id_from IS NULL
333: THEN
334: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pat_id_from');
335: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 334: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pat_id_from');

330:
331: IF p_pacv_rec.pat_id_from = OKC_API.G_MISS_NUM OR
332: p_pacv_rec.pat_id_from IS NULL
333: THEN
334: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pat_id_from');
335: l_return_status := OKC_API.G_RET_STS_ERROR;
336: END IF;
337: x_return_status := l_return_status;
338:

Line 335: l_return_status := OKC_API.G_RET_STS_ERROR;

331: IF p_pacv_rec.pat_id_from = OKC_API.G_MISS_NUM OR
332: p_pacv_rec.pat_id_from IS NULL
333: THEN
334: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pat_id_from');
335: l_return_status := OKC_API.G_RET_STS_ERROR;
336: END IF;
337: x_return_status := l_return_status;
338:
339: IF (l_debug = 'Y') THEN

Line 353: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

349: okc_debug.Reset_Indentation;
350: END IF;
351:
352: -- store SQL error message on message stack for caller
353: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
354: -- notify caller of an UNEXPECTED error
355: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
356:
357: END validate_pat_id_from;

Line 355: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

351:
352: -- store SQL error message on message stack for caller
353: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
354: -- notify caller of an UNEXPECTED error
355: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
356:
357: END validate_pat_id_from;
358:
359:

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

365: ----------------------------------------------------
366: FUNCTION Validate_Attributes (
367: p_pacv_rec IN pacv_rec_type
368: ) RETURN VARCHAR2 IS
369: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
370: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
371: BEGIN
372:
373: IF (l_debug = 'Y') THEN

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

366: FUNCTION Validate_Attributes (
367: p_pacv_rec IN pacv_rec_type
368: ) RETURN VARCHAR2 IS
369: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
370: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
371: BEGIN
372:
373: IF (l_debug = 'Y') THEN
374: okc_debug.Set_Indentation('OKC_PAC_PVT');

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

378: ---------------------------------------------------------------------------------------
379: --Attribute Level Validation Procedure Calls Starts(Modification on TAPI generated Code.)--
380: ---------------------------------------------------------------------------------------
381: OKC_UTIL.ADD_VIEW('OKC_PRICE_ADJ_ASSOCS_V', l_return_status);
382: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
383: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
384: x_return_status := l_return_status;
385: RAISE G_EXCEPTION_HALT_VALIDATION;
386: ELSE

Line 383: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

379: --Attribute Level Validation Procedure Calls Starts(Modification on TAPI generated Code.)--
380: ---------------------------------------------------------------------------------------
381: OKC_UTIL.ADD_VIEW('OKC_PRICE_ADJ_ASSOCS_V', l_return_status);
382: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
383: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
384: x_return_status := l_return_status;
385: RAISE G_EXCEPTION_HALT_VALIDATION;
386: ELSE
387: x_return_status := l_return_status; -- record that there was an error

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

388: END IF;
389: END IF;
390:
391: VALIDATE_id(p_pacv_rec, l_return_status);
392: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
393: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
394: x_return_status := l_return_status;
395: RAISE G_EXCEPTION_HALT_VALIDATION;
396: ELSE

Line 393: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

389: END IF;
390:
391: VALIDATE_id(p_pacv_rec, l_return_status);
392: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
393: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
394: x_return_status := l_return_status;
395: RAISE G_EXCEPTION_HALT_VALIDATION;
396: ELSE
397: x_return_status := l_return_status; -- record that there was an error

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

398: END IF;
399: END IF;
400:
401: VALIDATE_pat_id_from (p_pacv_rec, l_return_status);
402: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
403: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
404: x_return_status := l_return_status;
405: RAISE G_EXCEPTION_HALT_VALIDATION;
406: ELSE

Line 403: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

399: END IF;
400:
401: VALIDATE_pat_id_from (p_pacv_rec, l_return_status);
402: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
403: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
404: x_return_status := l_return_status;
405: RAISE G_EXCEPTION_HALT_VALIDATION;
406: ELSE
407: x_return_status := l_return_status; -- record that there was an error

Line 435: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

431: okc_debug.Reset_Indentation;
432: END IF;
433:
434: -- store SQL error message on message stack for caller
435: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
436: -- notify caller of an UNEXPECTED error
437: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
438: return(x_return_status);
439:

Line 437: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

433:
434: -- store SQL error message on message stack for caller
435: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
436: -- notify caller of an UNEXPECTED error
437: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
438: return(x_return_status);
439:
440: ---------------------------------------------------------------------------------------
441: --Attribute Level Validation Procedure Calls Ends(Modification on TAPI generated Code.)--

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

452: ------------------------------------------------
453: FUNCTION Validate_Record (
454: p_pacv_rec IN pacv_rec_type
455: ) RETURN VARCHAR2 IS
456: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
457: ------------------------------------
458: -- FUNCTION validate_foreign_keys --
459: ------------------------------------
460: FUNCTION validate_foreign_keys (

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

484: 'x'
485: FROM Oks_Bill_Sub_Lines_V
486: WHERE oks_bill_sub_lines_v.id = p_id;
487: l_oks_bslv_pk oks_bslv_pk_csr%ROWTYPE;
488: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
489: l_row_notfound BOOLEAN := TRUE;
490: BEGIN
491:
492: IF (p_pacv_rec.PAT_ID IS NOT NULL)

Line 499: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PAT_ID');

495: FETCH okc_patv_pk_csr INTO l_okc_patv_pk;
496: l_row_notfound := okc_patv_pk_csr%NOTFOUND;
497: CLOSE okc_patv_pk_csr;
498: IF (l_row_notfound) THEN
499: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PAT_ID');
500: RAISE item_not_found_error;
501: END IF;
502: END IF;
503: IF (p_pacv_rec.CLE_ID IS NOT NULL)

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

506: FETCH okc_clev_pk_csr INTO l_okc_clev_pk;
507: l_row_notfound := okc_clev_pk_csr%NOTFOUND;
508: CLOSE okc_clev_pk_csr;
509: IF (l_row_notfound) THEN
510: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CLE_ID');
511: RAISE item_not_found_error;
512: END IF;
513: END IF;
514: IF (p_pacv_rec.BCL_ID IS NOT NULL)

Line 521: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BCL_ID');

517: FETCH okc_bclv_pk_csr INTO l_okc_bclv_pk;
518: l_row_notfound := okc_bclv_pk_csr%NOTFOUND;
519: CLOSE okc_bclv_pk_csr;
520: IF (l_row_notfound) THEN
521: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BCL_ID');
522: RAISE item_not_found_error;
523: END IF;
524: END IF;
525: IF (p_pacv_rec.PAT_ID_FROM IS NOT NULL)

Line 532: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PAT_ID_FROM');

528: FETCH okc_patv_pk_csr INTO l_okc_patv_pk;
529: l_row_notfound := okc_patv_pk_csr%NOTFOUND;
530: CLOSE okc_patv_pk_csr;
531: IF (l_row_notfound) THEN
532: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PAT_ID_FROM');
533: RAISE item_not_found_error;
534: END IF;
535: END IF;
536: IF (p_pacv_rec.BSL_ID IS NOT NULL)

Line 543: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BSL_ID');

539: FETCH oks_bslv_pk_csr INTO l_oks_bslv_pk;
540: l_row_notfound := oks_bslv_pk_csr%NOTFOUND;
541: CLOSE oks_bslv_pk_csr;
542: IF (l_row_notfound) THEN
543: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BSL_ID');
544: RAISE item_not_found_error;
545: END IF;
546: END IF;
547:

Line 563: l_return_status := OKC_API.G_RET_STS_ERROR;

559: okc_debug.log('2200: Exiting validate_foreign_keys:item_not_found_error Exception', 2);
560: okc_debug.Reset_Indentation;
561: END IF;
562:
563: l_return_status := OKC_API.G_RET_STS_ERROR;
564: RETURN (l_return_status);
565:
566: END validate_foreign_keys;
567: BEGIN

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

649: p_pacv_rec IN pacv_rec_type) IS
650:
651: l_api_version CONSTANT NUMBER := 1;
652: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
653: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
654: l_pacv_rec pacv_rec_type := p_pacv_rec;
655: l_pac_rec pac_rec_type;
656: BEGIN
657:

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

659: okc_debug.Set_Indentation('OKC_PAC_PVT');
660: okc_debug.log('2600: Entered validate_row', 2);
661: END IF;
662:
663: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
664: G_PKG_NAME,
665: p_init_msg_list,
666: l_api_version,
667: p_api_version,

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

666: l_api_version,
667: p_api_version,
668: '_PVT',
669: x_return_status);
670: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
671: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
673: RAISE OKC_API.G_EXCEPTION_ERROR;
674: END IF;

Line 671: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

667: p_api_version,
668: '_PVT',
669: x_return_status);
670: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
671: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
673: RAISE OKC_API.G_EXCEPTION_ERROR;
674: END IF;
675: --- Validate all non-missing attributes (Item Level Validation)

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

668: '_PVT',
669: x_return_status);
670: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
671: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
673: RAISE OKC_API.G_EXCEPTION_ERROR;
674: END IF;
675: --- Validate all non-missing attributes (Item Level Validation)
676: l_return_status := Validate_Attributes(l_pacv_rec);

Line 673: RAISE OKC_API.G_EXCEPTION_ERROR;

669: x_return_status);
670: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
671: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
673: RAISE OKC_API.G_EXCEPTION_ERROR;
674: END IF;
675: --- Validate all non-missing attributes (Item Level Validation)
676: l_return_status := Validate_Attributes(l_pacv_rec);
677: --- If any errors happen abort API

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

674: END IF;
675: --- Validate all non-missing attributes (Item Level Validation)
676: l_return_status := Validate_Attributes(l_pacv_rec);
677: --- If any errors happen abort API
678: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
679: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
680: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
681: RAISE OKC_API.G_EXCEPTION_ERROR;
682: END IF;

Line 679: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

675: --- Validate all non-missing attributes (Item Level Validation)
676: l_return_status := Validate_Attributes(l_pacv_rec);
677: --- If any errors happen abort API
678: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
679: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
680: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
681: RAISE OKC_API.G_EXCEPTION_ERROR;
682: END IF;
683: l_return_status := Validate_Record(l_pacv_rec);

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

676: l_return_status := Validate_Attributes(l_pacv_rec);
677: --- If any errors happen abort API
678: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
679: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
680: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
681: RAISE OKC_API.G_EXCEPTION_ERROR;
682: END IF;
683: l_return_status := Validate_Record(l_pacv_rec);
684: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 681: RAISE OKC_API.G_EXCEPTION_ERROR;

677: --- If any errors happen abort API
678: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
679: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
680: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
681: RAISE OKC_API.G_EXCEPTION_ERROR;
682: END IF;
683: l_return_status := Validate_Record(l_pacv_rec);
684: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
685: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

680: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
681: RAISE OKC_API.G_EXCEPTION_ERROR;
682: END IF;
683: l_return_status := Validate_Record(l_pacv_rec);
684: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
685: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
686: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
687: RAISE OKC_API.G_EXCEPTION_ERROR;
688: END IF;

Line 685: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

681: RAISE OKC_API.G_EXCEPTION_ERROR;
682: END IF;
683: l_return_status := Validate_Record(l_pacv_rec);
684: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
685: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
686: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
687: RAISE OKC_API.G_EXCEPTION_ERROR;
688: END IF;
689: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

682: END IF;
683: l_return_status := Validate_Record(l_pacv_rec);
684: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
685: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
686: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
687: RAISE OKC_API.G_EXCEPTION_ERROR;
688: END IF;
689: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
690:

Line 687: RAISE OKC_API.G_EXCEPTION_ERROR;

683: l_return_status := Validate_Record(l_pacv_rec);
684: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
685: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
686: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
687: RAISE OKC_API.G_EXCEPTION_ERROR;
688: END IF;
689: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
690:
691: IF (l_debug = 'Y') THEN

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

685: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
686: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
687: RAISE OKC_API.G_EXCEPTION_ERROR;
688: END IF;
689: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
690:
691: IF (l_debug = 'Y') THEN
692: okc_debug.log('2700: Leaving validate_row', 2);
693: okc_debug.Reset_Indentation;

Line 697: WHEN OKC_API.G_EXCEPTION_ERROR THEN

693: okc_debug.Reset_Indentation;
694: END IF;
695:
696: EXCEPTION
697: WHEN OKC_API.G_EXCEPTION_ERROR THEN
698:
699: IF (l_debug = 'Y') THEN
700: okc_debug.log('2800: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
701: okc_debug.Reset_Indentation;

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

696: EXCEPTION
697: WHEN OKC_API.G_EXCEPTION_ERROR THEN
698:
699: IF (l_debug = 'Y') THEN
700: okc_debug.log('2800: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
701: okc_debug.Reset_Indentation;
702: END IF;
703:
704: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 704: x_return_status := OKC_API.HANDLE_EXCEPTIONS

700: okc_debug.log('2800: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
701: okc_debug.Reset_Indentation;
702: END IF;
703:
704: x_return_status := OKC_API.HANDLE_EXCEPTIONS
705: (
706: l_api_name,
707: G_PKG_NAME,
708: 'OKC_API.G_RET_STS_ERROR',

Line 708: 'OKC_API.G_RET_STS_ERROR',

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

Line 713: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

709: x_msg_count,
710: x_msg_data,
711: '_PVT'
712: );
713: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
714:
715: IF (l_debug = 'Y') THEN
716: okc_debug.log('2900: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
717: okc_debug.Reset_Indentation;

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

712: );
713: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
714:
715: IF (l_debug = 'Y') THEN
716: okc_debug.log('2900: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
717: okc_debug.Reset_Indentation;
718: END IF;
719:
720: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 720: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

716: okc_debug.log('2900: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
717: okc_debug.Reset_Indentation;
718: END IF;
719:
720: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
721: (
722: l_api_name,
723: G_PKG_NAME,
724: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 724: 'OKC_API.G_RET_STS_UNEXP_ERROR',

720: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
721: (
722: l_api_name,
723: G_PKG_NAME,
724: 'OKC_API.G_RET_STS_UNEXP_ERROR',
725: x_msg_count,
726: x_msg_data,
727: '_PVT'
728: );

Line 736: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

732: okc_debug.log('3000: Exiting validate_row:OTHERS Exception', 2);
733: okc_debug.Reset_Indentation;
734: END IF;
735:
736: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
737: (
738: l_api_name,
739: G_PKG_NAME,
740: 'OTHERS',

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

756: p_pacv_tbl IN pacv_tbl_type) IS
757:
758: l_api_version CONSTANT NUMBER := 1;
759: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
760: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
761: i NUMBER := 0;
762: BEGIN
763:
764: IF (l_debug = 'Y') THEN

Line 769: OKC_API.init_msg_list(p_init_msg_list);

765: okc_debug.Set_Indentation('OKC_PAC_PVT');
766: okc_debug.log('3100: Entered validate_row', 2);
767: END IF;
768:
769: OKC_API.init_msg_list(p_init_msg_list);
770: -- Make sure PL/SQL table has records in it before passing
771: IF (p_pacv_tbl.COUNT > 0) THEN
772: i := p_pacv_tbl.FIRST;
773: LOOP

Line 776: p_init_msg_list => OKC_API.G_FALSE,

772: i := p_pacv_tbl.FIRST;
773: LOOP
774: validate_row (
775: p_api_version => p_api_version,
776: p_init_msg_list => OKC_API.G_FALSE,
777: x_return_status => x_return_status,
778: x_msg_count => x_msg_count,
779: x_msg_data => x_msg_data,
780: p_pacv_rec => p_pacv_tbl(i));

Line 792: WHEN OKC_API.G_EXCEPTION_ERROR THEN

788: okc_debug.Reset_Indentation;
789: END IF;
790:
791: EXCEPTION
792: WHEN OKC_API.G_EXCEPTION_ERROR THEN
793:
794: IF (l_debug = 'Y') THEN
795: okc_debug.log('3300: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
796: okc_debug.Reset_Indentation;

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

791: EXCEPTION
792: WHEN OKC_API.G_EXCEPTION_ERROR THEN
793:
794: IF (l_debug = 'Y') THEN
795: okc_debug.log('3300: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
796: okc_debug.Reset_Indentation;
797: END IF;
798:
799: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 799: x_return_status := OKC_API.HANDLE_EXCEPTIONS

795: okc_debug.log('3300: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
796: okc_debug.Reset_Indentation;
797: END IF;
798:
799: x_return_status := OKC_API.HANDLE_EXCEPTIONS
800: (
801: l_api_name,
802: G_PKG_NAME,
803: 'OKC_API.G_RET_STS_ERROR',

Line 803: 'OKC_API.G_RET_STS_ERROR',

799: x_return_status := OKC_API.HANDLE_EXCEPTIONS
800: (
801: l_api_name,
802: G_PKG_NAME,
803: 'OKC_API.G_RET_STS_ERROR',
804: x_msg_count,
805: x_msg_data,
806: '_PVT'
807: );

Line 808: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

804: x_msg_count,
805: x_msg_data,
806: '_PVT'
807: );
808: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
809:
810: IF (l_debug = 'Y') THEN
811: okc_debug.log('3400: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
812: okc_debug.Reset_Indentation;

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

807: );
808: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
809:
810: IF (l_debug = 'Y') THEN
811: okc_debug.log('3400: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
812: okc_debug.Reset_Indentation;
813: END IF;
814:
815: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 815: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

811: okc_debug.log('3400: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
812: okc_debug.Reset_Indentation;
813: END IF;
814:
815: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
816: (
817: l_api_name,
818: G_PKG_NAME,
819: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 819: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 831: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

827: okc_debug.log('3500: Exiting validate_row:OTHERS Exception', 2);
828: okc_debug.Reset_Indentation;
829: END IF;
830:
831: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
832: (
833: l_api_name,
834: G_PKG_NAME,
835: 'OTHERS',

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

855: x_pac_rec OUT NOCOPY pac_rec_type) IS
856:
857: l_api_version CONSTANT NUMBER := 1;
858: l_api_name CONSTANT VARCHAR2(30) := 'ASSOCS_insert_row';
859: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
860: l_pac_rec pac_rec_type := p_pac_rec;
861: l_def_pac_rec pac_rec_type;
862: ---------------------------------------------
863: -- Set_Attributes for:OKC_PRICE_ADJ_ASSOCS --

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

865: FUNCTION Set_Attributes (
866: p_pac_rec IN pac_rec_type,
867: x_pac_rec OUT NOCOPY pac_rec_type
868: ) RETURN VARCHAR2 IS
869: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
870: BEGIN
871:
872: x_pac_rec := p_pac_rec;
873: RETURN(l_return_status);

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

879: okc_debug.Set_Indentation('OKC_PAC_PVT');
880: okc_debug.log('3700: Entered insert_row', 2);
881: END IF;
882:
883: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
884: p_init_msg_list,
885: '_PVT',
886: x_return_status);
887: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

883: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
884: p_init_msg_list,
885: '_PVT',
886: x_return_status);
887: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
888: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
889: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
890: RAISE OKC_API.G_EXCEPTION_ERROR;
891: END IF;

Line 888: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

884: p_init_msg_list,
885: '_PVT',
886: x_return_status);
887: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
888: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
889: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
890: RAISE OKC_API.G_EXCEPTION_ERROR;
891: END IF;
892: --- Setting item attributes

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

885: '_PVT',
886: x_return_status);
887: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
888: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
889: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
890: RAISE OKC_API.G_EXCEPTION_ERROR;
891: END IF;
892: --- Setting item attributes
893: l_return_status := Set_Attributes(

Line 890: RAISE OKC_API.G_EXCEPTION_ERROR;

886: x_return_status);
887: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
888: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
889: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
890: RAISE OKC_API.G_EXCEPTION_ERROR;
891: END IF;
892: --- Setting item attributes
893: l_return_status := Set_Attributes(
894: p_pac_rec, -- IN

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

893: l_return_status := Set_Attributes(
894: p_pac_rec, -- IN
895: l_pac_rec); -- OUT
896: --- If any errors happen abort API
897: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
900: RAISE OKC_API.G_EXCEPTION_ERROR;
901: END IF;

Line 898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

894: p_pac_rec, -- IN
895: l_pac_rec); -- OUT
896: --- If any errors happen abort API
897: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
900: RAISE OKC_API.G_EXCEPTION_ERROR;
901: END IF;
902: INSERT INTO OKC_PRICE_ADJ_ASSOCS(

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

895: l_pac_rec); -- OUT
896: --- If any errors happen abort API
897: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
900: RAISE OKC_API.G_EXCEPTION_ERROR;
901: END IF;
902: INSERT INTO OKC_PRICE_ADJ_ASSOCS(
903: id,

Line 900: RAISE OKC_API.G_EXCEPTION_ERROR;

896: --- If any errors happen abort API
897: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
900: RAISE OKC_API.G_EXCEPTION_ERROR;
901: END IF;
902: INSERT INTO OKC_PRICE_ADJ_ASSOCS(
903: id,
904: pat_id,

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

934: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
935: l_pac_rec.object_version_number);
936: -- Set OUT values
937: x_pac_rec := l_pac_rec;
938: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
939:
940: IF (l_debug = 'Y') THEN
941: okc_debug.log('3800: Leaving insert_row', 2);
942: okc_debug.Reset_Indentation;

Line 946: WHEN OKC_API.G_EXCEPTION_ERROR THEN

942: okc_debug.Reset_Indentation;
943: END IF;
944:
945: EXCEPTION
946: WHEN OKC_API.G_EXCEPTION_ERROR THEN
947:
948: IF (l_debug = 'Y') THEN
949: okc_debug.log('3900: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
950: okc_debug.Reset_Indentation;

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

945: EXCEPTION
946: WHEN OKC_API.G_EXCEPTION_ERROR THEN
947:
948: IF (l_debug = 'Y') THEN
949: okc_debug.log('3900: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
950: okc_debug.Reset_Indentation;
951: END IF;
952:
953: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 953: x_return_status := OKC_API.HANDLE_EXCEPTIONS

949: okc_debug.log('3900: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
950: okc_debug.Reset_Indentation;
951: END IF;
952:
953: x_return_status := OKC_API.HANDLE_EXCEPTIONS
954: (
955: l_api_name,
956: G_PKG_NAME,
957: 'OKC_API.G_RET_STS_ERROR',

Line 957: 'OKC_API.G_RET_STS_ERROR',

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

Line 962: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

958: x_msg_count,
959: x_msg_data,
960: '_PVT'
961: );
962: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
963:
964: IF (l_debug = 'Y') THEN
965: okc_debug.log('4000: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
966: okc_debug.Reset_Indentation;

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

961: );
962: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
963:
964: IF (l_debug = 'Y') THEN
965: okc_debug.log('4000: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
966: okc_debug.Reset_Indentation;
967: END IF;
968:
969: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 969: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

965: okc_debug.log('4000: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
966: okc_debug.Reset_Indentation;
967: END IF;
968:
969: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
970: (
971: l_api_name,
972: G_PKG_NAME,
973: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 973: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 985: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

981: okc_debug.log('4100: Exiting insert_row:OTHERS Exception', 2);
982: okc_debug.Reset_Indentation;
983: END IF;
984:
985: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
986: (
987: l_api_name,
988: G_PKG_NAME,
989: 'OTHERS',

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

1006: x_pacv_rec OUT NOCOPY pacv_rec_type) IS
1007:
1008: l_api_version CONSTANT NUMBER := 1;
1009: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1010: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1011: l_pacv_rec pacv_rec_type;
1012: l_def_pacv_rec pacv_rec_type;
1013: l_pac_rec pac_rec_type;
1014: lx_pac_rec pac_rec_type;

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

1035: FUNCTION Set_Attributes (
1036: p_pacv_rec IN pacv_rec_type,
1037: x_pacv_rec OUT NOCOPY pacv_rec_type
1038: ) RETURN VARCHAR2 IS
1039: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1040: BEGIN
1041:
1042: x_pacv_rec := p_pacv_rec;
1043: x_pacv_rec.OBJECT_VERSION_NUMBER := 1;

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

1050: okc_debug.Set_Indentation('OKC_PAC_PVT');
1051: okc_debug.log('4400: Entered insert_row', 2);
1052: END IF;
1053:
1054: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1055: G_PKG_NAME,
1056: p_init_msg_list,
1057: l_api_version,
1058: p_api_version,

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

1057: l_api_version,
1058: p_api_version,
1059: '_PVT',
1060: x_return_status);
1061: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1064: RAISE OKC_API.G_EXCEPTION_ERROR;
1065: END IF;

Line 1062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1058: p_api_version,
1059: '_PVT',
1060: x_return_status);
1061: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1064: RAISE OKC_API.G_EXCEPTION_ERROR;
1065: END IF;
1066: l_pacv_rec := null_out_defaults(p_pacv_rec);

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

1059: '_PVT',
1060: x_return_status);
1061: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1064: RAISE OKC_API.G_EXCEPTION_ERROR;
1065: END IF;
1066: l_pacv_rec := null_out_defaults(p_pacv_rec);
1067: -- Set primary key value

Line 1064: RAISE OKC_API.G_EXCEPTION_ERROR;

1060: x_return_status);
1061: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1064: RAISE OKC_API.G_EXCEPTION_ERROR;
1065: END IF;
1066: l_pacv_rec := null_out_defaults(p_pacv_rec);
1067: -- Set primary key value
1068: l_pacv_rec.ID := get_seq_id;

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

1070: l_return_status := Set_Attributes(
1071: l_pacv_rec, -- IN
1072: l_def_pacv_rec); -- OUT
1073: --- If any errors happen abort API
1074: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1075: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1076: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1077: RAISE OKC_API.G_EXCEPTION_ERROR;
1078: END IF;

Line 1075: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1071: l_pacv_rec, -- IN
1072: l_def_pacv_rec); -- OUT
1073: --- If any errors happen abort API
1074: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1075: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1076: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1077: RAISE OKC_API.G_EXCEPTION_ERROR;
1078: END IF;
1079: l_def_pacv_rec := fill_who_columns(l_def_pacv_rec);

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

1072: l_def_pacv_rec); -- OUT
1073: --- If any errors happen abort API
1074: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1075: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1076: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1077: RAISE OKC_API.G_EXCEPTION_ERROR;
1078: END IF;
1079: l_def_pacv_rec := fill_who_columns(l_def_pacv_rec);
1080: --- Validate all non-missing attributes (Item Level Validation)

Line 1077: RAISE OKC_API.G_EXCEPTION_ERROR;

1073: --- If any errors happen abort API
1074: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1075: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1076: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1077: RAISE OKC_API.G_EXCEPTION_ERROR;
1078: END IF;
1079: l_def_pacv_rec := fill_who_columns(l_def_pacv_rec);
1080: --- Validate all non-missing attributes (Item Level Validation)
1081: l_return_status := Validate_Attributes(l_def_pacv_rec);

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

1079: l_def_pacv_rec := fill_who_columns(l_def_pacv_rec);
1080: --- Validate all non-missing attributes (Item Level Validation)
1081: l_return_status := Validate_Attributes(l_def_pacv_rec);
1082: --- If any errors happen abort API
1083: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1085: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1086: RAISE OKC_API.G_EXCEPTION_ERROR;
1087: END IF;

Line 1084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1080: --- Validate all non-missing attributes (Item Level Validation)
1081: l_return_status := Validate_Attributes(l_def_pacv_rec);
1082: --- If any errors happen abort API
1083: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1085: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1086: RAISE OKC_API.G_EXCEPTION_ERROR;
1087: END IF;
1088: l_return_status := Validate_Record(l_def_pacv_rec);

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

1081: l_return_status := Validate_Attributes(l_def_pacv_rec);
1082: --- If any errors happen abort API
1083: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1085: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1086: RAISE OKC_API.G_EXCEPTION_ERROR;
1087: END IF;
1088: l_return_status := Validate_Record(l_def_pacv_rec);
1089: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1086: RAISE OKC_API.G_EXCEPTION_ERROR;

1082: --- If any errors happen abort API
1083: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1085: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1086: RAISE OKC_API.G_EXCEPTION_ERROR;
1087: END IF;
1088: l_return_status := Validate_Record(l_def_pacv_rec);
1089: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1085: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1086: RAISE OKC_API.G_EXCEPTION_ERROR;
1087: END IF;
1088: l_return_status := Validate_Record(l_def_pacv_rec);
1089: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;

Line 1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1086: RAISE OKC_API.G_EXCEPTION_ERROR;
1087: END IF;
1088: l_return_status := Validate_Record(l_def_pacv_rec);
1089: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;
1094: --------------------------------------

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

1087: END IF;
1088: l_return_status := Validate_Record(l_def_pacv_rec);
1089: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;
1094: --------------------------------------
1095: -- Move VIEW record to "Child" records

Line 1092: RAISE OKC_API.G_EXCEPTION_ERROR;

1088: l_return_status := Validate_Record(l_def_pacv_rec);
1089: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;
1094: --------------------------------------
1095: -- Move VIEW record to "Child" records
1096: --------------------------------------

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

1105: x_msg_data,
1106: l_pac_rec,
1107: lx_pac_rec
1108: );
1109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1112: RAISE OKC_API.G_EXCEPTION_ERROR;
1113: END IF;

Line 1110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1106: l_pac_rec,
1107: lx_pac_rec
1108: );
1109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1112: RAISE OKC_API.G_EXCEPTION_ERROR;
1113: END IF;
1114: migrate(lx_pac_rec, l_def_pacv_rec);

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

1107: lx_pac_rec
1108: );
1109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1112: RAISE OKC_API.G_EXCEPTION_ERROR;
1113: END IF;
1114: migrate(lx_pac_rec, l_def_pacv_rec);
1115: -- Set OUT values

Line 1112: RAISE OKC_API.G_EXCEPTION_ERROR;

1108: );
1109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1112: RAISE OKC_API.G_EXCEPTION_ERROR;
1113: END IF;
1114: migrate(lx_pac_rec, l_def_pacv_rec);
1115: -- Set OUT values
1116: x_pacv_rec := l_def_pacv_rec;

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

1113: END IF;
1114: migrate(lx_pac_rec, l_def_pacv_rec);
1115: -- Set OUT values
1116: x_pacv_rec := l_def_pacv_rec;
1117: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1118:
1119: IF (l_debug = 'Y') THEN
1120: okc_debug.log('4500: Leaving insert_row', 2);
1121: okc_debug.Reset_Indentation;

Line 1125: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1121: okc_debug.Reset_Indentation;
1122: END IF;
1123:
1124: EXCEPTION
1125: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1126:
1127: IF (l_debug = 'Y') THEN
1128: okc_debug.log('4600: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1129: okc_debug.Reset_Indentation;

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

1124: EXCEPTION
1125: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1126:
1127: IF (l_debug = 'Y') THEN
1128: okc_debug.log('4600: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1129: okc_debug.Reset_Indentation;
1130: END IF;
1131:
1132: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1132: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1128: okc_debug.log('4600: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1129: okc_debug.Reset_Indentation;
1130: END IF;
1131:
1132: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1133: (
1134: l_api_name,
1135: G_PKG_NAME,
1136: 'OKC_API.G_RET_STS_ERROR',

Line 1136: 'OKC_API.G_RET_STS_ERROR',

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

Line 1141: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1137: x_msg_count,
1138: x_msg_data,
1139: '_PVT'
1140: );
1141: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1142:
1143: IF (l_debug = 'Y') THEN
1144: okc_debug.log('4700: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1145: okc_debug.Reset_Indentation;

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

1140: );
1141: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1142:
1143: IF (l_debug = 'Y') THEN
1144: okc_debug.log('4700: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1145: okc_debug.Reset_Indentation;
1146: END IF;
1147:
1148: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1148: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1144: okc_debug.log('4700: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1145: okc_debug.Reset_Indentation;
1146: END IF;
1147:
1148: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1149: (
1150: l_api_name,
1151: G_PKG_NAME,
1152: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1152: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1148: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1149: (
1150: l_api_name,
1151: G_PKG_NAME,
1152: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1153: x_msg_count,
1154: x_msg_data,
1155: '_PVT'
1156: );

Line 1164: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1160: okc_debug.log('4800: Exiting insert_row:OTHERS Exception', 2);
1161: okc_debug.Reset_Indentation;
1162: END IF;
1163:
1164: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1165: (
1166: l_api_name,
1167: G_PKG_NAME,
1168: 'OTHERS',

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

1185: x_pacv_tbl OUT NOCOPY pacv_tbl_type) IS
1186:
1187: l_api_version CONSTANT NUMBER := 1;
1188: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1189: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1190: i NUMBER := 0;
1191: BEGIN
1192:
1193: IF (l_debug = 'Y') THEN

Line 1198: OKC_API.init_msg_list(p_init_msg_list);

1194: okc_debug.Set_Indentation('OKC_PAC_PVT');
1195: okc_debug.log('4900: Entered insert_row', 2);
1196: END IF;
1197:
1198: OKC_API.init_msg_list(p_init_msg_list);
1199: -- Make sure PL/SQL table has records in it before passing
1200: IF (p_pacv_tbl.COUNT > 0) THEN
1201: i := p_pacv_tbl.FIRST;
1202: LOOP

Line 1205: p_init_msg_list => OKC_API.G_FALSE,

1201: i := p_pacv_tbl.FIRST;
1202: LOOP
1203: insert_row (
1204: p_api_version => p_api_version,
1205: p_init_msg_list => OKC_API.G_FALSE,
1206: x_return_status => x_return_status,
1207: x_msg_count => x_msg_count,
1208: x_msg_data => x_msg_data,
1209: p_pacv_rec => p_pacv_tbl(i),

Line 1222: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1218: okc_debug.Reset_Indentation;
1219: END IF;
1220:
1221: EXCEPTION
1222: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1223:
1224: IF (l_debug = 'Y') THEN
1225: okc_debug.log('5100: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1226: okc_debug.Reset_Indentation;

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

1221: EXCEPTION
1222: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1223:
1224: IF (l_debug = 'Y') THEN
1225: okc_debug.log('5100: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1226: okc_debug.Reset_Indentation;
1227: END IF;
1228:
1229: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1229: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1225: okc_debug.log('5100: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1226: okc_debug.Reset_Indentation;
1227: END IF;
1228:
1229: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1230: (
1231: l_api_name,
1232: G_PKG_NAME,
1233: 'OKC_API.G_RET_STS_ERROR',

Line 1233: 'OKC_API.G_RET_STS_ERROR',

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

Line 1238: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1234: x_msg_count,
1235: x_msg_data,
1236: '_PVT'
1237: );
1238: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1239:
1240: IF (l_debug = 'Y') THEN
1241: okc_debug.log('5200: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1242: okc_debug.Reset_Indentation;

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

1237: );
1238: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1239:
1240: IF (l_debug = 'Y') THEN
1241: okc_debug.log('5200: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1242: okc_debug.Reset_Indentation;
1243: END IF;
1244:
1245: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1245: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1241: okc_debug.log('5200: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1242: okc_debug.Reset_Indentation;
1243: END IF;
1244:
1245: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1246: (
1247: l_api_name,
1248: G_PKG_NAME,
1249: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1249: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1245: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1246: (
1247: l_api_name,
1248: G_PKG_NAME,
1249: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1250: x_msg_count,
1251: x_msg_data,
1252: '_PVT'
1253: );

Line 1261: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1257: okc_debug.log('5300: Exiting insert_row:OTHERS Exception', 2);
1258: okc_debug.Reset_Indentation;
1259: END IF;
1260:
1261: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1262: (
1263: l_api_name,
1264: G_PKG_NAME,
1265: 'OTHERS',

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

1292: FOR UPDATE NOWAIT;
1293:
1294: l_api_version CONSTANT NUMBER := 1;
1295: l_api_name CONSTANT VARCHAR2(30) := 'ASSOCS_lock_row';
1296: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1297: l_lock_var lock_csr%ROWTYPE;
1298: l_row_notfound BOOLEAN := FALSE;
1299: lc_row_notfound BOOLEAN := FALSE;
1300: BEGIN

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

1303: okc_debug.Set_Indentation('OKC_PAC_PVT');
1304: okc_debug.log('5400: Entered lock_row', 2);
1305: END IF;
1306:
1307: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1308: p_init_msg_list,
1309: '_PVT',
1310: x_return_status);
1311: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1307: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1308: p_init_msg_list,
1309: '_PVT',
1310: x_return_status);
1311: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1312: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1313: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1314: RAISE OKC_API.G_EXCEPTION_ERROR;
1315: END IF;

Line 1312: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1308: p_init_msg_list,
1309: '_PVT',
1310: x_return_status);
1311: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1312: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1313: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1314: RAISE OKC_API.G_EXCEPTION_ERROR;
1315: END IF;
1316: BEGIN

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

1309: '_PVT',
1310: x_return_status);
1311: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1312: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1313: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1314: RAISE OKC_API.G_EXCEPTION_ERROR;
1315: END IF;
1316: BEGIN
1317:

Line 1314: RAISE OKC_API.G_EXCEPTION_ERROR;

1310: x_return_status);
1311: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1312: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1313: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1314: RAISE OKC_API.G_EXCEPTION_ERROR;
1315: END IF;
1316: BEGIN
1317:
1318: OPEN lock_csr(p_pac_rec);

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

1330:
1331: IF (lock_csr%ISOPEN) THEN
1332: CLOSE lock_csr;
1333: END IF;
1334: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1335: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1336: END;
1337:
1338: IF ( l_row_notfound ) THEN

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

1335: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1336: END;
1337:
1338: IF ( l_row_notfound ) THEN
1339: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1340: RAISE OKC_API.G_EXCEPTION_ERROR;
1341: ELSE
1342: IF (l_lock_var.ID <> p_pac_rec.id) THEN
1343: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1340: RAISE OKC_API.G_EXCEPTION_ERROR;

1336: END;
1337:
1338: IF ( l_row_notfound ) THEN
1339: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1340: RAISE OKC_API.G_EXCEPTION_ERROR;
1341: ELSE
1342: IF (l_lock_var.ID <> p_pac_rec.id) THEN
1343: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1344: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1339: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1340: RAISE OKC_API.G_EXCEPTION_ERROR;
1341: ELSE
1342: IF (l_lock_var.ID <> p_pac_rec.id) THEN
1343: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1344: RAISE OKC_API.G_EXCEPTION_ERROR;
1345: END IF;
1346: IF (l_lock_var.PAT_ID <> p_pac_rec.pat_id) THEN
1347: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1344: RAISE OKC_API.G_EXCEPTION_ERROR;

1340: RAISE OKC_API.G_EXCEPTION_ERROR;
1341: ELSE
1342: IF (l_lock_var.ID <> p_pac_rec.id) THEN
1343: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1344: RAISE OKC_API.G_EXCEPTION_ERROR;
1345: END IF;
1346: IF (l_lock_var.PAT_ID <> p_pac_rec.pat_id) THEN
1347: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1348: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1343: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1344: RAISE OKC_API.G_EXCEPTION_ERROR;
1345: END IF;
1346: IF (l_lock_var.PAT_ID <> p_pac_rec.pat_id) THEN
1347: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1348: RAISE OKC_API.G_EXCEPTION_ERROR;
1349: END IF;
1350: IF (l_lock_var.PAT_ID_FROM <> p_pac_rec.pat_id_from) THEN
1351: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1348: RAISE OKC_API.G_EXCEPTION_ERROR;

1344: RAISE OKC_API.G_EXCEPTION_ERROR;
1345: END IF;
1346: IF (l_lock_var.PAT_ID <> p_pac_rec.pat_id) THEN
1347: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1348: RAISE OKC_API.G_EXCEPTION_ERROR;
1349: END IF;
1350: IF (l_lock_var.PAT_ID_FROM <> p_pac_rec.pat_id_from) THEN
1351: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1352: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1347: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1348: RAISE OKC_API.G_EXCEPTION_ERROR;
1349: END IF;
1350: IF (l_lock_var.PAT_ID_FROM <> p_pac_rec.pat_id_from) THEN
1351: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1352: RAISE OKC_API.G_EXCEPTION_ERROR;
1353: END IF;
1354: IF (l_lock_var.BSL_ID <> p_pac_rec.bsl_id) THEN
1355: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1352: RAISE OKC_API.G_EXCEPTION_ERROR;

1348: RAISE OKC_API.G_EXCEPTION_ERROR;
1349: END IF;
1350: IF (l_lock_var.PAT_ID_FROM <> p_pac_rec.pat_id_from) THEN
1351: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1352: RAISE OKC_API.G_EXCEPTION_ERROR;
1353: END IF;
1354: IF (l_lock_var.BSL_ID <> p_pac_rec.bsl_id) THEN
1355: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1356: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1351: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1352: RAISE OKC_API.G_EXCEPTION_ERROR;
1353: END IF;
1354: IF (l_lock_var.BSL_ID <> p_pac_rec.bsl_id) THEN
1355: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1356: RAISE OKC_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: IF (l_lock_var.CLE_ID <> p_pac_rec.cle_id) THEN
1359: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1356: RAISE OKC_API.G_EXCEPTION_ERROR;

1352: RAISE OKC_API.G_EXCEPTION_ERROR;
1353: END IF;
1354: IF (l_lock_var.BSL_ID <> p_pac_rec.bsl_id) THEN
1355: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1356: RAISE OKC_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: IF (l_lock_var.CLE_ID <> p_pac_rec.cle_id) THEN
1359: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1360: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1355: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1356: RAISE OKC_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: IF (l_lock_var.CLE_ID <> p_pac_rec.cle_id) THEN
1359: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1360: RAISE OKC_API.G_EXCEPTION_ERROR;
1361: END IF;
1362: IF (l_lock_var.BCL_ID <> p_pac_rec.bcl_id) THEN
1363: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1360: RAISE OKC_API.G_EXCEPTION_ERROR;

1356: RAISE OKC_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: IF (l_lock_var.CLE_ID <> p_pac_rec.cle_id) THEN
1359: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1360: RAISE OKC_API.G_EXCEPTION_ERROR;
1361: END IF;
1362: IF (l_lock_var.BCL_ID <> p_pac_rec.bcl_id) THEN
1363: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1364: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1359: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1360: RAISE OKC_API.G_EXCEPTION_ERROR;
1361: END IF;
1362: IF (l_lock_var.BCL_ID <> p_pac_rec.bcl_id) THEN
1363: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1364: RAISE OKC_API.G_EXCEPTION_ERROR;
1365: END IF;
1366: IF (l_lock_var.CREATED_BY <> p_pac_rec.created_by) THEN
1367: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1364: RAISE OKC_API.G_EXCEPTION_ERROR;

1360: RAISE OKC_API.G_EXCEPTION_ERROR;
1361: END IF;
1362: IF (l_lock_var.BCL_ID <> p_pac_rec.bcl_id) THEN
1363: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1364: RAISE OKC_API.G_EXCEPTION_ERROR;
1365: END IF;
1366: IF (l_lock_var.CREATED_BY <> p_pac_rec.created_by) THEN
1367: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1368: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1363: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1364: RAISE OKC_API.G_EXCEPTION_ERROR;
1365: END IF;
1366: IF (l_lock_var.CREATED_BY <> p_pac_rec.created_by) THEN
1367: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1368: RAISE OKC_API.G_EXCEPTION_ERROR;
1369: END IF;
1370: IF (l_lock_var.CREATION_DATE <> p_pac_rec.creation_date) THEN
1371: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1368: RAISE OKC_API.G_EXCEPTION_ERROR;

1364: RAISE OKC_API.G_EXCEPTION_ERROR;
1365: END IF;
1366: IF (l_lock_var.CREATED_BY <> p_pac_rec.created_by) THEN
1367: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1368: RAISE OKC_API.G_EXCEPTION_ERROR;
1369: END IF;
1370: IF (l_lock_var.CREATION_DATE <> p_pac_rec.creation_date) THEN
1371: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1372: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1367: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1368: RAISE OKC_API.G_EXCEPTION_ERROR;
1369: END IF;
1370: IF (l_lock_var.CREATION_DATE <> p_pac_rec.creation_date) THEN
1371: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1372: RAISE OKC_API.G_EXCEPTION_ERROR;
1373: END IF;
1374: IF (l_lock_var.LAST_UPDATED_BY <> p_pac_rec.last_updated_by) THEN
1375: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1372: RAISE OKC_API.G_EXCEPTION_ERROR;

1368: RAISE OKC_API.G_EXCEPTION_ERROR;
1369: END IF;
1370: IF (l_lock_var.CREATION_DATE <> p_pac_rec.creation_date) THEN
1371: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1372: RAISE OKC_API.G_EXCEPTION_ERROR;
1373: END IF;
1374: IF (l_lock_var.LAST_UPDATED_BY <> p_pac_rec.last_updated_by) THEN
1375: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1376: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1371: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1372: RAISE OKC_API.G_EXCEPTION_ERROR;
1373: END IF;
1374: IF (l_lock_var.LAST_UPDATED_BY <> p_pac_rec.last_updated_by) THEN
1375: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1376: RAISE OKC_API.G_EXCEPTION_ERROR;
1377: END IF;
1378: IF (l_lock_var.LAST_UPDATE_DATE <> p_pac_rec.last_update_date) THEN
1379: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1376: RAISE OKC_API.G_EXCEPTION_ERROR;

1372: RAISE OKC_API.G_EXCEPTION_ERROR;
1373: END IF;
1374: IF (l_lock_var.LAST_UPDATED_BY <> p_pac_rec.last_updated_by) THEN
1375: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1376: RAISE OKC_API.G_EXCEPTION_ERROR;
1377: END IF;
1378: IF (l_lock_var.LAST_UPDATE_DATE <> p_pac_rec.last_update_date) THEN
1379: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1380: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1375: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1376: RAISE OKC_API.G_EXCEPTION_ERROR;
1377: END IF;
1378: IF (l_lock_var.LAST_UPDATE_DATE <> p_pac_rec.last_update_date) THEN
1379: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1380: RAISE OKC_API.G_EXCEPTION_ERROR;
1381: END IF;
1382: IF (l_lock_var.LAST_UPDATE_LOGIN <> p_pac_rec.last_update_login) THEN
1383: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1380: RAISE OKC_API.G_EXCEPTION_ERROR;

1376: RAISE OKC_API.G_EXCEPTION_ERROR;
1377: END IF;
1378: IF (l_lock_var.LAST_UPDATE_DATE <> p_pac_rec.last_update_date) THEN
1379: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1380: RAISE OKC_API.G_EXCEPTION_ERROR;
1381: END IF;
1382: IF (l_lock_var.LAST_UPDATE_LOGIN <> p_pac_rec.last_update_login) THEN
1383: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1384: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1379: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1380: RAISE OKC_API.G_EXCEPTION_ERROR;
1381: END IF;
1382: IF (l_lock_var.LAST_UPDATE_LOGIN <> p_pac_rec.last_update_login) THEN
1383: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1384: RAISE OKC_API.G_EXCEPTION_ERROR;
1385: END IF;
1386: IF (l_lock_var.PROGRAM_APPLICATION_ID <> p_pac_rec.program_application_id) THEN
1387: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1384: RAISE OKC_API.G_EXCEPTION_ERROR;

1380: RAISE OKC_API.G_EXCEPTION_ERROR;
1381: END IF;
1382: IF (l_lock_var.LAST_UPDATE_LOGIN <> p_pac_rec.last_update_login) THEN
1383: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1384: RAISE OKC_API.G_EXCEPTION_ERROR;
1385: END IF;
1386: IF (l_lock_var.PROGRAM_APPLICATION_ID <> p_pac_rec.program_application_id) THEN
1387: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1388: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1383: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1384: RAISE OKC_API.G_EXCEPTION_ERROR;
1385: END IF;
1386: IF (l_lock_var.PROGRAM_APPLICATION_ID <> p_pac_rec.program_application_id) THEN
1387: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1388: RAISE OKC_API.G_EXCEPTION_ERROR;
1389: END IF;
1390: IF (l_lock_var.PROGRAM_ID <> p_pac_rec.program_id) THEN
1391: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1388: RAISE OKC_API.G_EXCEPTION_ERROR;

1384: RAISE OKC_API.G_EXCEPTION_ERROR;
1385: END IF;
1386: IF (l_lock_var.PROGRAM_APPLICATION_ID <> p_pac_rec.program_application_id) THEN
1387: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1388: RAISE OKC_API.G_EXCEPTION_ERROR;
1389: END IF;
1390: IF (l_lock_var.PROGRAM_ID <> p_pac_rec.program_id) THEN
1391: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1392: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1387: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1388: RAISE OKC_API.G_EXCEPTION_ERROR;
1389: END IF;
1390: IF (l_lock_var.PROGRAM_ID <> p_pac_rec.program_id) THEN
1391: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1392: RAISE OKC_API.G_EXCEPTION_ERROR;
1393: END IF;
1394: IF (l_lock_var.PROGRAM_UPDATE_DATE <> p_pac_rec.program_update_date) THEN
1395: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1392: RAISE OKC_API.G_EXCEPTION_ERROR;

1388: RAISE OKC_API.G_EXCEPTION_ERROR;
1389: END IF;
1390: IF (l_lock_var.PROGRAM_ID <> p_pac_rec.program_id) THEN
1391: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1392: RAISE OKC_API.G_EXCEPTION_ERROR;
1393: END IF;
1394: IF (l_lock_var.PROGRAM_UPDATE_DATE <> p_pac_rec.program_update_date) THEN
1395: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1396: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1391: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1392: RAISE OKC_API.G_EXCEPTION_ERROR;
1393: END IF;
1394: IF (l_lock_var.PROGRAM_UPDATE_DATE <> p_pac_rec.program_update_date) THEN
1395: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1396: RAISE OKC_API.G_EXCEPTION_ERROR;
1397: END IF;
1398: IF (l_lock_var.REQUEST_ID <> p_pac_rec.request_id) THEN
1399: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1396: RAISE OKC_API.G_EXCEPTION_ERROR;

1392: RAISE OKC_API.G_EXCEPTION_ERROR;
1393: END IF;
1394: IF (l_lock_var.PROGRAM_UPDATE_DATE <> p_pac_rec.program_update_date) THEN
1395: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1396: RAISE OKC_API.G_EXCEPTION_ERROR;
1397: END IF;
1398: IF (l_lock_var.REQUEST_ID <> p_pac_rec.request_id) THEN
1399: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1400: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1395: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1396: RAISE OKC_API.G_EXCEPTION_ERROR;
1397: END IF;
1398: IF (l_lock_var.REQUEST_ID <> p_pac_rec.request_id) THEN
1399: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1400: RAISE OKC_API.G_EXCEPTION_ERROR;
1401: END IF;
1402: IF (l_lock_var.OBJECT_VERSION_NUMBER <> p_pac_rec.object_version_number) THEN
1403: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1400: RAISE OKC_API.G_EXCEPTION_ERROR;

1396: RAISE OKC_API.G_EXCEPTION_ERROR;
1397: END IF;
1398: IF (l_lock_var.REQUEST_ID <> p_pac_rec.request_id) THEN
1399: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1400: RAISE OKC_API.G_EXCEPTION_ERROR;
1401: END IF;
1402: IF (l_lock_var.OBJECT_VERSION_NUMBER <> p_pac_rec.object_version_number) THEN
1403: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1404: RAISE OKC_API.G_EXCEPTION_ERROR;

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

1399: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1400: RAISE OKC_API.G_EXCEPTION_ERROR;
1401: END IF;
1402: IF (l_lock_var.OBJECT_VERSION_NUMBER <> p_pac_rec.object_version_number) THEN
1403: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;
1406: END IF;
1407: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1404: RAISE OKC_API.G_EXCEPTION_ERROR;

1400: RAISE OKC_API.G_EXCEPTION_ERROR;
1401: END IF;
1402: IF (l_lock_var.OBJECT_VERSION_NUMBER <> p_pac_rec.object_version_number) THEN
1403: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;
1406: END IF;
1407: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1408:

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

1403: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;
1406: END IF;
1407: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1408:
1409: IF (l_debug = 'Y') THEN
1410: okc_debug.log('5800: Leaving lock_row', 2);
1411: okc_debug.Reset_Indentation;

Line 1415: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1411: okc_debug.Reset_Indentation;
1412: END IF;
1413:
1414: EXCEPTION
1415: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1416:
1417: IF (l_debug = 'Y') THEN
1418: okc_debug.log('5900: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1419: okc_debug.Reset_Indentation;

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

1414: EXCEPTION
1415: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1416:
1417: IF (l_debug = 'Y') THEN
1418: okc_debug.log('5900: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1419: okc_debug.Reset_Indentation;
1420: END IF;
1421:
1422: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1422: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1418: okc_debug.log('5900: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1419: okc_debug.Reset_Indentation;
1420: END IF;
1421:
1422: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1423: (
1424: l_api_name,
1425: G_PKG_NAME,
1426: 'OKC_API.G_RET_STS_ERROR',

Line 1426: 'OKC_API.G_RET_STS_ERROR',

1422: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1423: (
1424: l_api_name,
1425: G_PKG_NAME,
1426: 'OKC_API.G_RET_STS_ERROR',
1427: x_msg_count,
1428: x_msg_data,
1429: '_PVT'
1430: );

Line 1431: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1427: x_msg_count,
1428: x_msg_data,
1429: '_PVT'
1430: );
1431: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1432:
1433: IF (l_debug = 'Y') THEN
1434: okc_debug.log('6000: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1435: okc_debug.Reset_Indentation;

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

1430: );
1431: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1432:
1433: IF (l_debug = 'Y') THEN
1434: okc_debug.log('6000: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1435: okc_debug.Reset_Indentation;
1436: END IF;
1437:
1438: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1438: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1434: okc_debug.log('6000: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1435: okc_debug.Reset_Indentation;
1436: END IF;
1437:
1438: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1439: (
1440: l_api_name,
1441: G_PKG_NAME,
1442: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1442: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1454: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1450: okc_debug.log('6100: Exiting lock_row:OTHERS Exception', 2);
1451: okc_debug.Reset_Indentation;
1452: END IF;
1453:
1454: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1455: (
1456: l_api_name,
1457: G_PKG_NAME,
1458: 'OTHERS',

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

1474: p_pacv_rec IN pacv_rec_type) IS
1475:
1476: l_api_version CONSTANT NUMBER := 1;
1477: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1478: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1479: l_pac_rec pac_rec_type;
1480: BEGIN
1481:
1482: IF (l_debug = 'Y') THEN

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

1483: okc_debug.Set_Indentation('OKC_PAC_PVT');
1484: okc_debug.log('6200: Entered lock_row', 2);
1485: END IF;
1486:
1487: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1488: G_PKG_NAME,
1489: p_init_msg_list,
1490: l_api_version,
1491: p_api_version,

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

1490: l_api_version,
1491: p_api_version,
1492: '_PVT',
1493: x_return_status);
1494: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1495: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1496: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1497: RAISE OKC_API.G_EXCEPTION_ERROR;
1498: END IF;

Line 1495: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1491: p_api_version,
1492: '_PVT',
1493: x_return_status);
1494: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1495: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1496: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1497: RAISE OKC_API.G_EXCEPTION_ERROR;
1498: END IF;
1499: --------------------------------------

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

1492: '_PVT',
1493: x_return_status);
1494: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1495: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1496: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1497: RAISE OKC_API.G_EXCEPTION_ERROR;
1498: END IF;
1499: --------------------------------------
1500: -- Move VIEW record to "Child" records

Line 1497: RAISE OKC_API.G_EXCEPTION_ERROR;

1493: x_return_status);
1494: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1495: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1496: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1497: RAISE OKC_API.G_EXCEPTION_ERROR;
1498: END IF;
1499: --------------------------------------
1500: -- Move VIEW record to "Child" records
1501: --------------------------------------

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

1509: x_msg_count,
1510: x_msg_data,
1511: l_pac_rec
1512: );
1513: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1514: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1515: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1516: RAISE OKC_API.G_EXCEPTION_ERROR;
1517: END IF;

Line 1514: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1510: x_msg_data,
1511: l_pac_rec
1512: );
1513: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1514: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1515: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1516: RAISE OKC_API.G_EXCEPTION_ERROR;
1517: END IF;
1518: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1511: l_pac_rec
1512: );
1513: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1514: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1515: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1516: RAISE OKC_API.G_EXCEPTION_ERROR;
1517: END IF;
1518: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1519:

Line 1516: RAISE OKC_API.G_EXCEPTION_ERROR;

1512: );
1513: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1514: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1515: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1516: RAISE OKC_API.G_EXCEPTION_ERROR;
1517: END IF;
1518: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1519:
1520: IF (l_debug = 'Y') THEN

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

1514: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1515: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1516: RAISE OKC_API.G_EXCEPTION_ERROR;
1517: END IF;
1518: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1519:
1520: IF (l_debug = 'Y') THEN
1521: okc_debug.log('6300: Leaving lock_row', 2);
1522: okc_debug.Reset_Indentation;

Line 1526: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1522: okc_debug.Reset_Indentation;
1523: END IF;
1524:
1525: EXCEPTION
1526: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1527:
1528: IF (l_debug = 'Y') THEN
1529: okc_debug.log('6400: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1530: okc_debug.Reset_Indentation;

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

1525: EXCEPTION
1526: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1527:
1528: IF (l_debug = 'Y') THEN
1529: okc_debug.log('6400: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1530: okc_debug.Reset_Indentation;
1531: END IF;
1532:
1533: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1533: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1529: okc_debug.log('6400: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1530: okc_debug.Reset_Indentation;
1531: END IF;
1532:
1533: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1534: (
1535: l_api_name,
1536: G_PKG_NAME,
1537: 'OKC_API.G_RET_STS_ERROR',

Line 1537: 'OKC_API.G_RET_STS_ERROR',

1533: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1534: (
1535: l_api_name,
1536: G_PKG_NAME,
1537: 'OKC_API.G_RET_STS_ERROR',
1538: x_msg_count,
1539: x_msg_data,
1540: '_PVT'
1541: );

Line 1542: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1538: x_msg_count,
1539: x_msg_data,
1540: '_PVT'
1541: );
1542: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1543:
1544: IF (l_debug = 'Y') THEN
1545: okc_debug.log('6500: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1546: okc_debug.Reset_Indentation;

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

1541: );
1542: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1543:
1544: IF (l_debug = 'Y') THEN
1545: okc_debug.log('6500: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1546: okc_debug.Reset_Indentation;
1547: END IF;
1548:
1549: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1549: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1545: okc_debug.log('6500: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1546: okc_debug.Reset_Indentation;
1547: END IF;
1548:
1549: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1550: (
1551: l_api_name,
1552: G_PKG_NAME,
1553: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1553: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1549: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1550: (
1551: l_api_name,
1552: G_PKG_NAME,
1553: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1554: x_msg_count,
1555: x_msg_data,
1556: '_PVT'
1557: );

Line 1565: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1561: okc_debug.log('6600: Exiting lock_row:OTHERS Exception', 2);
1562: okc_debug.Reset_Indentation;
1563: END IF;
1564:
1565: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1566: (
1567: l_api_name,
1568: G_PKG_NAME,
1569: 'OTHERS',

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

1585: p_pacv_tbl IN pacv_tbl_type) IS
1586:
1587: l_api_version CONSTANT NUMBER := 1;
1588: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1589: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1590: i NUMBER := 0;
1591: BEGIN
1592:
1593: IF (l_debug = 'Y') THEN

Line 1598: OKC_API.init_msg_list(p_init_msg_list);

1594: okc_debug.Set_Indentation('OKC_PAC_PVT');
1595: okc_debug.log('6700: Entered lock_row', 2);
1596: END IF;
1597:
1598: OKC_API.init_msg_list(p_init_msg_list);
1599: -- Make sure PL/SQL table has records in it before passing
1600: IF (p_pacv_tbl.COUNT > 0) THEN
1601: i := p_pacv_tbl.FIRST;
1602: LOOP

Line 1605: p_init_msg_list => OKC_API.G_FALSE,

1601: i := p_pacv_tbl.FIRST;
1602: LOOP
1603: lock_row (
1604: p_api_version => p_api_version,
1605: p_init_msg_list => OKC_API.G_FALSE,
1606: x_return_status => x_return_status,
1607: x_msg_count => x_msg_count,
1608: x_msg_data => x_msg_data,
1609: p_pacv_rec => p_pacv_tbl(i));

Line 1621: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1617: okc_debug.Reset_Indentation;
1618: END IF;
1619:
1620: EXCEPTION
1621: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1622:
1623: IF (l_debug = 'Y') THEN
1624: okc_debug.log('6900: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1625: okc_debug.Reset_Indentation;

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

1620: EXCEPTION
1621: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1622:
1623: IF (l_debug = 'Y') THEN
1624: okc_debug.log('6900: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1625: okc_debug.Reset_Indentation;
1626: END IF;
1627:
1628: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1628: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1624: okc_debug.log('6900: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1625: okc_debug.Reset_Indentation;
1626: END IF;
1627:
1628: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1629: (
1630: l_api_name,
1631: G_PKG_NAME,
1632: 'OKC_API.G_RET_STS_ERROR',

Line 1632: 'OKC_API.G_RET_STS_ERROR',

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

Line 1637: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1633: x_msg_count,
1634: x_msg_data,
1635: '_PVT'
1636: );
1637: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1638:
1639: IF (l_debug = 'Y') THEN
1640: okc_debug.log('7000: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1641: okc_debug.Reset_Indentation;

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

1636: );
1637: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1638:
1639: IF (l_debug = 'Y') THEN
1640: okc_debug.log('7000: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1641: okc_debug.Reset_Indentation;
1642: END IF;
1643:
1644: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1644: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1640: okc_debug.log('7000: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1641: okc_debug.Reset_Indentation;
1642: END IF;
1643:
1644: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1645: (
1646: l_api_name,
1647: G_PKG_NAME,
1648: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1648: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1644: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1645: (
1646: l_api_name,
1647: G_PKG_NAME,
1648: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1649: x_msg_count,
1650: x_msg_data,
1651: '_PVT'
1652: );

Line 1660: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1656: okc_debug.log('7100: Exiting lock_row:OTHERS Exception', 2);
1657: okc_debug.Reset_Indentation;
1658: END IF;
1659:
1660: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1661: (
1662: l_api_name,
1663: G_PKG_NAME,
1664: 'OTHERS',

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

1684: x_pac_rec OUT NOCOPY pac_rec_type) IS
1685:
1686: l_api_version CONSTANT NUMBER := 1;
1687: l_api_name CONSTANT VARCHAR2(30) := 'ASSOCS_update_row';
1688: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1689: l_pac_rec pac_rec_type := p_pac_rec;
1690: l_def_pac_rec pac_rec_type;
1691: l_row_notfound BOOLEAN := TRUE;
1692: ----------------------------------

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

1697: x_pac_rec OUT NOCOPY pac_rec_type
1698: ) RETURN VARCHAR2 IS
1699: l_pac_rec pac_rec_type;
1700: l_row_notfound BOOLEAN := TRUE;
1701: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1702: BEGIN
1703:
1704: IF (l_debug = 'Y') THEN
1705: okc_debug.Set_Indentation('OKC_PAC_PVT');

Line 1713: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1709: x_pac_rec := p_pac_rec;
1710: -- Get current database values
1711: l_pac_rec := get_rec(p_pac_rec, l_row_notfound);
1712: IF (l_row_notfound) THEN
1713: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1714: END IF;
1715: IF (x_pac_rec.id = OKC_API.G_MISS_NUM)
1716: THEN
1717: x_pac_rec.id := l_pac_rec.id;

Line 1715: IF (x_pac_rec.id = OKC_API.G_MISS_NUM)

1711: l_pac_rec := get_rec(p_pac_rec, l_row_notfound);
1712: IF (l_row_notfound) THEN
1713: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1714: END IF;
1715: IF (x_pac_rec.id = OKC_API.G_MISS_NUM)
1716: THEN
1717: x_pac_rec.id := l_pac_rec.id;
1718: END IF;
1719: IF (x_pac_rec.pat_id = OKC_API.G_MISS_NUM)

Line 1719: IF (x_pac_rec.pat_id = OKC_API.G_MISS_NUM)

1715: IF (x_pac_rec.id = OKC_API.G_MISS_NUM)
1716: THEN
1717: x_pac_rec.id := l_pac_rec.id;
1718: END IF;
1719: IF (x_pac_rec.pat_id = OKC_API.G_MISS_NUM)
1720: THEN
1721: x_pac_rec.pat_id := l_pac_rec.pat_id;
1722: END IF;
1723: IF (x_pac_rec.pat_id_from = OKC_API.G_MISS_NUM)

Line 1723: IF (x_pac_rec.pat_id_from = OKC_API.G_MISS_NUM)

1719: IF (x_pac_rec.pat_id = OKC_API.G_MISS_NUM)
1720: THEN
1721: x_pac_rec.pat_id := l_pac_rec.pat_id;
1722: END IF;
1723: IF (x_pac_rec.pat_id_from = OKC_API.G_MISS_NUM)
1724: THEN
1725: x_pac_rec.pat_id_from := l_pac_rec.pat_id_from;
1726: END IF;
1727: IF (x_pac_rec.bsl_id = OKC_API.G_MISS_NUM)

Line 1727: IF (x_pac_rec.bsl_id = OKC_API.G_MISS_NUM)

1723: IF (x_pac_rec.pat_id_from = OKC_API.G_MISS_NUM)
1724: THEN
1725: x_pac_rec.pat_id_from := l_pac_rec.pat_id_from;
1726: END IF;
1727: IF (x_pac_rec.bsl_id = OKC_API.G_MISS_NUM)
1728: THEN
1729: x_pac_rec.bsl_id := l_pac_rec.bsl_id;
1730: END IF;
1731: IF (x_pac_rec.cle_id = OKC_API.G_MISS_NUM)

Line 1731: IF (x_pac_rec.cle_id = OKC_API.G_MISS_NUM)

1727: IF (x_pac_rec.bsl_id = OKC_API.G_MISS_NUM)
1728: THEN
1729: x_pac_rec.bsl_id := l_pac_rec.bsl_id;
1730: END IF;
1731: IF (x_pac_rec.cle_id = OKC_API.G_MISS_NUM)
1732: THEN
1733: x_pac_rec.cle_id := l_pac_rec.cle_id;
1734: END IF;
1735: IF (x_pac_rec.bcl_id = OKC_API.G_MISS_NUM)

Line 1735: IF (x_pac_rec.bcl_id = OKC_API.G_MISS_NUM)

1731: IF (x_pac_rec.cle_id = OKC_API.G_MISS_NUM)
1732: THEN
1733: x_pac_rec.cle_id := l_pac_rec.cle_id;
1734: END IF;
1735: IF (x_pac_rec.bcl_id = OKC_API.G_MISS_NUM)
1736: THEN
1737: x_pac_rec.bcl_id := l_pac_rec.bcl_id;
1738: END IF;
1739: IF (x_pac_rec.created_by = OKC_API.G_MISS_NUM)

Line 1739: IF (x_pac_rec.created_by = OKC_API.G_MISS_NUM)

1735: IF (x_pac_rec.bcl_id = OKC_API.G_MISS_NUM)
1736: THEN
1737: x_pac_rec.bcl_id := l_pac_rec.bcl_id;
1738: END IF;
1739: IF (x_pac_rec.created_by = OKC_API.G_MISS_NUM)
1740: THEN
1741: x_pac_rec.created_by := l_pac_rec.created_by;
1742: END IF;
1743: IF (x_pac_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1743: IF (x_pac_rec.creation_date = OKC_API.G_MISS_DATE)

1739: IF (x_pac_rec.created_by = OKC_API.G_MISS_NUM)
1740: THEN
1741: x_pac_rec.created_by := l_pac_rec.created_by;
1742: END IF;
1743: IF (x_pac_rec.creation_date = OKC_API.G_MISS_DATE)
1744: THEN
1745: x_pac_rec.creation_date := l_pac_rec.creation_date;
1746: END IF;
1747: IF (x_pac_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1747: IF (x_pac_rec.last_updated_by = OKC_API.G_MISS_NUM)

1743: IF (x_pac_rec.creation_date = OKC_API.G_MISS_DATE)
1744: THEN
1745: x_pac_rec.creation_date := l_pac_rec.creation_date;
1746: END IF;
1747: IF (x_pac_rec.last_updated_by = OKC_API.G_MISS_NUM)
1748: THEN
1749: x_pac_rec.last_updated_by := l_pac_rec.last_updated_by;
1750: END IF;
1751: IF (x_pac_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1751: IF (x_pac_rec.last_update_date = OKC_API.G_MISS_DATE)

1747: IF (x_pac_rec.last_updated_by = OKC_API.G_MISS_NUM)
1748: THEN
1749: x_pac_rec.last_updated_by := l_pac_rec.last_updated_by;
1750: END IF;
1751: IF (x_pac_rec.last_update_date = OKC_API.G_MISS_DATE)
1752: THEN
1753: x_pac_rec.last_update_date := l_pac_rec.last_update_date;
1754: END IF;
1755: IF (x_pac_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1755: IF (x_pac_rec.last_update_login = OKC_API.G_MISS_NUM)

1751: IF (x_pac_rec.last_update_date = OKC_API.G_MISS_DATE)
1752: THEN
1753: x_pac_rec.last_update_date := l_pac_rec.last_update_date;
1754: END IF;
1755: IF (x_pac_rec.last_update_login = OKC_API.G_MISS_NUM)
1756: THEN
1757: x_pac_rec.last_update_login := l_pac_rec.last_update_login;
1758: END IF;
1759: IF (x_pac_rec.program_application_id = OKC_API.G_MISS_NUM)

Line 1759: IF (x_pac_rec.program_application_id = OKC_API.G_MISS_NUM)

1755: IF (x_pac_rec.last_update_login = OKC_API.G_MISS_NUM)
1756: THEN
1757: x_pac_rec.last_update_login := l_pac_rec.last_update_login;
1758: END IF;
1759: IF (x_pac_rec.program_application_id = OKC_API.G_MISS_NUM)
1760: THEN
1761: x_pac_rec.program_application_id := l_pac_rec.program_application_id;
1762: END IF;
1763: IF (x_pac_rec.program_id = OKC_API.G_MISS_NUM)

Line 1763: IF (x_pac_rec.program_id = OKC_API.G_MISS_NUM)

1759: IF (x_pac_rec.program_application_id = OKC_API.G_MISS_NUM)
1760: THEN
1761: x_pac_rec.program_application_id := l_pac_rec.program_application_id;
1762: END IF;
1763: IF (x_pac_rec.program_id = OKC_API.G_MISS_NUM)
1764: THEN
1765: x_pac_rec.program_id := l_pac_rec.program_id;
1766: END IF;
1767: IF (x_pac_rec.program_update_date = OKC_API.G_MISS_DATE)

Line 1767: IF (x_pac_rec.program_update_date = OKC_API.G_MISS_DATE)

1763: IF (x_pac_rec.program_id = OKC_API.G_MISS_NUM)
1764: THEN
1765: x_pac_rec.program_id := l_pac_rec.program_id;
1766: END IF;
1767: IF (x_pac_rec.program_update_date = OKC_API.G_MISS_DATE)
1768: THEN
1769: x_pac_rec.program_update_date := l_pac_rec.program_update_date;
1770: END IF;
1771: IF (x_pac_rec.request_id = OKC_API.G_MISS_NUM)

Line 1771: IF (x_pac_rec.request_id = OKC_API.G_MISS_NUM)

1767: IF (x_pac_rec.program_update_date = OKC_API.G_MISS_DATE)
1768: THEN
1769: x_pac_rec.program_update_date := l_pac_rec.program_update_date;
1770: END IF;
1771: IF (x_pac_rec.request_id = OKC_API.G_MISS_NUM)
1772: THEN
1773: x_pac_rec.request_id := l_pac_rec.request_id;
1774: END IF;
1775: IF (x_pac_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1775: IF (x_pac_rec.object_version_number = OKC_API.G_MISS_NUM)

1771: IF (x_pac_rec.request_id = OKC_API.G_MISS_NUM)
1772: THEN
1773: x_pac_rec.request_id := l_pac_rec.request_id;
1774: END IF;
1775: IF (x_pac_rec.object_version_number = OKC_API.G_MISS_NUM)
1776: THEN
1777: x_pac_rec.object_version_number := l_pac_rec.object_version_number;
1778: END IF;
1779:

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

1791: FUNCTION Set_Attributes (
1792: p_pac_rec IN pac_rec_type,
1793: x_pac_rec OUT NOCOPY pac_rec_type
1794: ) RETURN VARCHAR2 IS
1795: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1796: BEGIN
1797:
1798: x_pac_rec := p_pac_rec;
1799: RETURN(l_return_status);

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

1805: okc_debug.Set_Indentation('OKC_PAC_PVT');
1806: okc_debug.log('7400: Entered update_row', 2);
1807: END IF;
1808:
1809: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1810: p_init_msg_list,
1811: '_PVT',
1812: x_return_status);
1813: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1809: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1810: p_init_msg_list,
1811: '_PVT',
1812: x_return_status);
1813: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1814: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1815: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1816: RAISE OKC_API.G_EXCEPTION_ERROR;
1817: END IF;

Line 1814: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1810: p_init_msg_list,
1811: '_PVT',
1812: x_return_status);
1813: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1814: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1815: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1816: RAISE OKC_API.G_EXCEPTION_ERROR;
1817: END IF;
1818: --- Setting item attributes

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

1811: '_PVT',
1812: x_return_status);
1813: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1814: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1815: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1816: RAISE OKC_API.G_EXCEPTION_ERROR;
1817: END IF;
1818: --- Setting item attributes
1819: l_return_status := Set_Attributes(

Line 1816: RAISE OKC_API.G_EXCEPTION_ERROR;

1812: x_return_status);
1813: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1814: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1815: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1816: RAISE OKC_API.G_EXCEPTION_ERROR;
1817: END IF;
1818: --- Setting item attributes
1819: l_return_status := Set_Attributes(
1820: p_pac_rec, -- IN

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

1819: l_return_status := Set_Attributes(
1820: p_pac_rec, -- IN
1821: l_pac_rec); -- OUT
1822: --- If any errors happen abort API
1823: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1824: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1825: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1826: RAISE OKC_API.G_EXCEPTION_ERROR;
1827: END IF;

Line 1824: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1820: p_pac_rec, -- IN
1821: l_pac_rec); -- OUT
1822: --- If any errors happen abort API
1823: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1824: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1825: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1826: RAISE OKC_API.G_EXCEPTION_ERROR;
1827: END IF;
1828: l_return_status := populate_new_record(l_pac_rec, l_def_pac_rec);

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

1821: l_pac_rec); -- OUT
1822: --- If any errors happen abort API
1823: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1824: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1825: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1826: RAISE OKC_API.G_EXCEPTION_ERROR;
1827: END IF;
1828: l_return_status := populate_new_record(l_pac_rec, l_def_pac_rec);
1829: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1826: RAISE OKC_API.G_EXCEPTION_ERROR;

1822: --- If any errors happen abort API
1823: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1824: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1825: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1826: RAISE OKC_API.G_EXCEPTION_ERROR;
1827: END IF;
1828: l_return_status := populate_new_record(l_pac_rec, l_def_pac_rec);
1829: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1825: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1826: RAISE OKC_API.G_EXCEPTION_ERROR;
1827: END IF;
1828: l_return_status := populate_new_record(l_pac_rec, l_def_pac_rec);
1829: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1831: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1832: RAISE OKC_API.G_EXCEPTION_ERROR;
1833: END IF;

Line 1830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1826: RAISE OKC_API.G_EXCEPTION_ERROR;
1827: END IF;
1828: l_return_status := populate_new_record(l_pac_rec, l_def_pac_rec);
1829: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1831: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1832: RAISE OKC_API.G_EXCEPTION_ERROR;
1833: END IF;
1834: UPDATE OKC_PRICE_ADJ_ASSOCS

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

1827: END IF;
1828: l_return_status := populate_new_record(l_pac_rec, l_def_pac_rec);
1829: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1831: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1832: RAISE OKC_API.G_EXCEPTION_ERROR;
1833: END IF;
1834: UPDATE OKC_PRICE_ADJ_ASSOCS
1835: SET PAT_ID = l_def_pac_rec.pat_id,

Line 1832: RAISE OKC_API.G_EXCEPTION_ERROR;

1828: l_return_status := populate_new_record(l_pac_rec, l_def_pac_rec);
1829: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1831: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1832: RAISE OKC_API.G_EXCEPTION_ERROR;
1833: END IF;
1834: UPDATE OKC_PRICE_ADJ_ASSOCS
1835: SET PAT_ID = l_def_pac_rec.pat_id,
1836: PAT_ID_FROM = l_def_pac_rec.pat_id_from,

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

1850: OBJECT_VERSION_NUMBER = l_def_pac_rec.object_version_number
1851: WHERE ID = l_def_pac_rec.id;
1852:
1853: x_pac_rec := l_def_pac_rec;
1854: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1855:
1856: IF (l_debug = 'Y') THEN
1857: okc_debug.log('7500: Leaving update_row', 2);
1858: okc_debug.Reset_Indentation;

Line 1862: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1858: okc_debug.Reset_Indentation;
1859: END IF;
1860:
1861: EXCEPTION
1862: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1863:
1864: IF (l_debug = 'Y') THEN
1865: okc_debug.log('7600: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1866: okc_debug.Reset_Indentation;

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

1861: EXCEPTION
1862: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1863:
1864: IF (l_debug = 'Y') THEN
1865: okc_debug.log('7600: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1866: okc_debug.Reset_Indentation;
1867: END IF;
1868:
1869: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1869: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1865: okc_debug.log('7600: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1866: okc_debug.Reset_Indentation;
1867: END IF;
1868:
1869: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1870: (
1871: l_api_name,
1872: G_PKG_NAME,
1873: 'OKC_API.G_RET_STS_ERROR',

Line 1873: 'OKC_API.G_RET_STS_ERROR',

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

Line 1878: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1874: x_msg_count,
1875: x_msg_data,
1876: '_PVT'
1877: );
1878: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1879:
1880: IF (l_debug = 'Y') THEN
1881: okc_debug.log('7700: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1882: okc_debug.Reset_Indentation;

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

1877: );
1878: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1879:
1880: IF (l_debug = 'Y') THEN
1881: okc_debug.log('7700: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1882: okc_debug.Reset_Indentation;
1883: END IF;
1884:
1885: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1885: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1881: okc_debug.log('7700: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1882: okc_debug.Reset_Indentation;
1883: END IF;
1884:
1885: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1886: (
1887: l_api_name,
1888: G_PKG_NAME,
1889: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1889: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1901: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1897: okc_debug.log('7800: Exiting update_row:OTHERS Exception', 2);
1898: okc_debug.Reset_Indentation;
1899: END IF;
1900:
1901: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1902: (
1903: l_api_name,
1904: G_PKG_NAME,
1905: 'OTHERS',

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

1922: x_pacv_rec OUT NOCOPY pacv_rec_type) IS
1923:
1924: l_api_version CONSTANT NUMBER := 1;
1925: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1926: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1927: l_pacv_rec pacv_rec_type := p_pacv_rec;
1928: l_def_pacv_rec pacv_rec_type;
1929: l_pac_rec pac_rec_type;
1930: lx_pac_rec pac_rec_type;

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

1952: x_pacv_rec OUT NOCOPY pacv_rec_type
1953: ) RETURN VARCHAR2 IS
1954: l_pacv_rec pacv_rec_type;
1955: l_row_notfound BOOLEAN := TRUE;
1956: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1957: BEGIN
1958:
1959: IF (l_debug = 'Y') THEN
1960: okc_debug.Set_Indentation('OKC_PAC_PVT');

Line 1968: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1964: x_pacv_rec := p_pacv_rec;
1965: -- Get current database values
1966: l_pacv_rec := get_rec(p_pacv_rec, l_row_notfound);
1967: IF (l_row_notfound) THEN
1968: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1969: END IF;
1970: IF (x_pacv_rec.id = OKC_API.G_MISS_NUM)
1971: THEN
1972: x_pacv_rec.id := l_pacv_rec.id;

Line 1970: IF (x_pacv_rec.id = OKC_API.G_MISS_NUM)

1966: l_pacv_rec := get_rec(p_pacv_rec, l_row_notfound);
1967: IF (l_row_notfound) THEN
1968: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1969: END IF;
1970: IF (x_pacv_rec.id = OKC_API.G_MISS_NUM)
1971: THEN
1972: x_pacv_rec.id := l_pacv_rec.id;
1973: END IF;
1974: IF (x_pacv_rec.pat_id = OKC_API.G_MISS_NUM)

Line 1974: IF (x_pacv_rec.pat_id = OKC_API.G_MISS_NUM)

1970: IF (x_pacv_rec.id = OKC_API.G_MISS_NUM)
1971: THEN
1972: x_pacv_rec.id := l_pacv_rec.id;
1973: END IF;
1974: IF (x_pacv_rec.pat_id = OKC_API.G_MISS_NUM)
1975: THEN
1976: x_pacv_rec.pat_id := l_pacv_rec.pat_id;
1977: END IF;
1978: IF (x_pacv_rec.pat_id_from = OKC_API.G_MISS_NUM)

Line 1978: IF (x_pacv_rec.pat_id_from = OKC_API.G_MISS_NUM)

1974: IF (x_pacv_rec.pat_id = OKC_API.G_MISS_NUM)
1975: THEN
1976: x_pacv_rec.pat_id := l_pacv_rec.pat_id;
1977: END IF;
1978: IF (x_pacv_rec.pat_id_from = OKC_API.G_MISS_NUM)
1979: THEN
1980: x_pacv_rec.pat_id_from := l_pacv_rec.pat_id_from;
1981: END IF;
1982: IF (x_pacv_rec.bsl_id = OKC_API.G_MISS_NUM)

Line 1982: IF (x_pacv_rec.bsl_id = OKC_API.G_MISS_NUM)

1978: IF (x_pacv_rec.pat_id_from = OKC_API.G_MISS_NUM)
1979: THEN
1980: x_pacv_rec.pat_id_from := l_pacv_rec.pat_id_from;
1981: END IF;
1982: IF (x_pacv_rec.bsl_id = OKC_API.G_MISS_NUM)
1983: THEN
1984: x_pacv_rec.bsl_id := l_pacv_rec.bsl_id;
1985: END IF;
1986: IF (x_pacv_rec.cle_id = OKC_API.G_MISS_NUM)

Line 1986: IF (x_pacv_rec.cle_id = OKC_API.G_MISS_NUM)

1982: IF (x_pacv_rec.bsl_id = OKC_API.G_MISS_NUM)
1983: THEN
1984: x_pacv_rec.bsl_id := l_pacv_rec.bsl_id;
1985: END IF;
1986: IF (x_pacv_rec.cle_id = OKC_API.G_MISS_NUM)
1987: THEN
1988: x_pacv_rec.cle_id := l_pacv_rec.cle_id;
1989: END IF;
1990: IF (x_pacv_rec.bcl_id = OKC_API.G_MISS_NUM)

Line 1990: IF (x_pacv_rec.bcl_id = OKC_API.G_MISS_NUM)

1986: IF (x_pacv_rec.cle_id = OKC_API.G_MISS_NUM)
1987: THEN
1988: x_pacv_rec.cle_id := l_pacv_rec.cle_id;
1989: END IF;
1990: IF (x_pacv_rec.bcl_id = OKC_API.G_MISS_NUM)
1991: THEN
1992: x_pacv_rec.bcl_id := l_pacv_rec.bcl_id;
1993: END IF;
1994: IF (x_pacv_rec.created_by = OKC_API.G_MISS_NUM)

Line 1994: IF (x_pacv_rec.created_by = OKC_API.G_MISS_NUM)

1990: IF (x_pacv_rec.bcl_id = OKC_API.G_MISS_NUM)
1991: THEN
1992: x_pacv_rec.bcl_id := l_pacv_rec.bcl_id;
1993: END IF;
1994: IF (x_pacv_rec.created_by = OKC_API.G_MISS_NUM)
1995: THEN
1996: x_pacv_rec.created_by := l_pacv_rec.created_by;
1997: END IF;
1998: IF (x_pacv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1998: IF (x_pacv_rec.creation_date = OKC_API.G_MISS_DATE)

1994: IF (x_pacv_rec.created_by = OKC_API.G_MISS_NUM)
1995: THEN
1996: x_pacv_rec.created_by := l_pacv_rec.created_by;
1997: END IF;
1998: IF (x_pacv_rec.creation_date = OKC_API.G_MISS_DATE)
1999: THEN
2000: x_pacv_rec.creation_date := l_pacv_rec.creation_date;
2001: END IF;
2002: IF (x_pacv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2002: IF (x_pacv_rec.last_updated_by = OKC_API.G_MISS_NUM)

1998: IF (x_pacv_rec.creation_date = OKC_API.G_MISS_DATE)
1999: THEN
2000: x_pacv_rec.creation_date := l_pacv_rec.creation_date;
2001: END IF;
2002: IF (x_pacv_rec.last_updated_by = OKC_API.G_MISS_NUM)
2003: THEN
2004: x_pacv_rec.last_updated_by := l_pacv_rec.last_updated_by;
2005: END IF;
2006: IF (x_pacv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2006: IF (x_pacv_rec.last_update_date = OKC_API.G_MISS_DATE)

2002: IF (x_pacv_rec.last_updated_by = OKC_API.G_MISS_NUM)
2003: THEN
2004: x_pacv_rec.last_updated_by := l_pacv_rec.last_updated_by;
2005: END IF;
2006: IF (x_pacv_rec.last_update_date = OKC_API.G_MISS_DATE)
2007: THEN
2008: x_pacv_rec.last_update_date := l_pacv_rec.last_update_date;
2009: END IF;
2010: IF (x_pacv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2010: IF (x_pacv_rec.last_update_login = OKC_API.G_MISS_NUM)

2006: IF (x_pacv_rec.last_update_date = OKC_API.G_MISS_DATE)
2007: THEN
2008: x_pacv_rec.last_update_date := l_pacv_rec.last_update_date;
2009: END IF;
2010: IF (x_pacv_rec.last_update_login = OKC_API.G_MISS_NUM)
2011: THEN
2012: x_pacv_rec.last_update_login := l_pacv_rec.last_update_login;
2013: END IF;
2014: IF (x_pacv_rec.program_application_id = OKC_API.G_MISS_NUM)

Line 2014: IF (x_pacv_rec.program_application_id = OKC_API.G_MISS_NUM)

2010: IF (x_pacv_rec.last_update_login = OKC_API.G_MISS_NUM)
2011: THEN
2012: x_pacv_rec.last_update_login := l_pacv_rec.last_update_login;
2013: END IF;
2014: IF (x_pacv_rec.program_application_id = OKC_API.G_MISS_NUM)
2015: THEN
2016: x_pacv_rec.program_application_id := l_pacv_rec.program_application_id;
2017: END IF;
2018: IF (x_pacv_rec.program_id = OKC_API.G_MISS_NUM)

Line 2018: IF (x_pacv_rec.program_id = OKC_API.G_MISS_NUM)

2014: IF (x_pacv_rec.program_application_id = OKC_API.G_MISS_NUM)
2015: THEN
2016: x_pacv_rec.program_application_id := l_pacv_rec.program_application_id;
2017: END IF;
2018: IF (x_pacv_rec.program_id = OKC_API.G_MISS_NUM)
2019: THEN
2020: x_pacv_rec.program_id := l_pacv_rec.program_id;
2021: END IF;
2022: IF (x_pacv_rec.program_update_date = OKC_API.G_MISS_DATE)

Line 2022: IF (x_pacv_rec.program_update_date = OKC_API.G_MISS_DATE)

2018: IF (x_pacv_rec.program_id = OKC_API.G_MISS_NUM)
2019: THEN
2020: x_pacv_rec.program_id := l_pacv_rec.program_id;
2021: END IF;
2022: IF (x_pacv_rec.program_update_date = OKC_API.G_MISS_DATE)
2023: THEN
2024: x_pacv_rec.program_update_date := l_pacv_rec.program_update_date;
2025: END IF;
2026: IF (x_pacv_rec.request_id = OKC_API.G_MISS_NUM)

Line 2026: IF (x_pacv_rec.request_id = OKC_API.G_MISS_NUM)

2022: IF (x_pacv_rec.program_update_date = OKC_API.G_MISS_DATE)
2023: THEN
2024: x_pacv_rec.program_update_date := l_pacv_rec.program_update_date;
2025: END IF;
2026: IF (x_pacv_rec.request_id = OKC_API.G_MISS_NUM)
2027: THEN
2028: x_pacv_rec.request_id := l_pacv_rec.request_id;
2029: END IF;
2030: IF (x_pacv_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 2030: IF (x_pacv_rec.object_version_number = OKC_API.G_MISS_NUM)

2026: IF (x_pacv_rec.request_id = OKC_API.G_MISS_NUM)
2027: THEN
2028: x_pacv_rec.request_id := l_pacv_rec.request_id;
2029: END IF;
2030: IF (x_pacv_rec.object_version_number = OKC_API.G_MISS_NUM)
2031: THEN
2032: x_pacv_rec.object_version_number := l_pacv_rec.object_version_number;
2033: END IF;
2034:

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

2046: FUNCTION Set_Attributes (
2047: p_pacv_rec IN pacv_rec_type,
2048: x_pacv_rec OUT NOCOPY pacv_rec_type
2049: ) RETURN VARCHAR2 IS
2050: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2051: BEGIN
2052:
2053: x_pacv_rec := p_pacv_rec;
2054: x_pacv_rec.OBJECT_VERSION_NUMBER := NVL(x_pacv_rec.OBJECT_VERSION_NUMBER,0) + 1;

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

2061: okc_debug.Set_Indentation('OKC_PAC_PVT');
2062: okc_debug.log('8200: Entered update_row', 2);
2063: END IF;
2064:
2065: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2066: G_PKG_NAME,
2067: p_init_msg_list,
2068: l_api_version,
2069: p_api_version,

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

2068: l_api_version,
2069: p_api_version,
2070: '_PVT',
2071: x_return_status);
2072: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2073: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2074: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2075: RAISE OKC_API.G_EXCEPTION_ERROR;
2076: END IF;

Line 2073: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2069: p_api_version,
2070: '_PVT',
2071: x_return_status);
2072: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2073: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2074: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2075: RAISE OKC_API.G_EXCEPTION_ERROR;
2076: END IF;
2077: --- Setting item attributes

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

2070: '_PVT',
2071: x_return_status);
2072: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2073: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2074: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2075: RAISE OKC_API.G_EXCEPTION_ERROR;
2076: END IF;
2077: --- Setting item attributes
2078: l_return_status := Set_Attributes(

Line 2075: RAISE OKC_API.G_EXCEPTION_ERROR;

2071: x_return_status);
2072: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2073: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2074: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2075: RAISE OKC_API.G_EXCEPTION_ERROR;
2076: END IF;
2077: --- Setting item attributes
2078: l_return_status := Set_Attributes(
2079: p_pacv_rec, -- IN

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

2078: l_return_status := Set_Attributes(
2079: p_pacv_rec, -- IN
2080: l_pacv_rec); -- OUT
2081: --- If any errors happen abort API
2082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_ERROR;
2086: END IF;

Line 2083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2079: p_pacv_rec, -- IN
2080: l_pacv_rec); -- OUT
2081: --- If any errors happen abort API
2082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_ERROR;
2086: END IF;
2087: l_return_status := populate_new_record(l_pacv_rec, l_def_pacv_rec);

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

2080: l_pacv_rec); -- OUT
2081: --- If any errors happen abort API
2082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_ERROR;
2086: END IF;
2087: l_return_status := populate_new_record(l_pacv_rec, l_def_pacv_rec);
2088: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2085: RAISE OKC_API.G_EXCEPTION_ERROR;

2081: --- If any errors happen abort API
2082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_ERROR;
2086: END IF;
2087: l_return_status := populate_new_record(l_pacv_rec, l_def_pacv_rec);
2088: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2089: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_ERROR;
2086: END IF;
2087: l_return_status := populate_new_record(l_pacv_rec, l_def_pacv_rec);
2088: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2089: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2090: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2091: RAISE OKC_API.G_EXCEPTION_ERROR;
2092: END IF;

Line 2089: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2085: RAISE OKC_API.G_EXCEPTION_ERROR;
2086: END IF;
2087: l_return_status := populate_new_record(l_pacv_rec, l_def_pacv_rec);
2088: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2089: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2090: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2091: RAISE OKC_API.G_EXCEPTION_ERROR;
2092: END IF;
2093: l_def_pacv_rec := fill_who_columns(l_def_pacv_rec);

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

2086: END IF;
2087: l_return_status := populate_new_record(l_pacv_rec, l_def_pacv_rec);
2088: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2089: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2090: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2091: RAISE OKC_API.G_EXCEPTION_ERROR;
2092: END IF;
2093: l_def_pacv_rec := fill_who_columns(l_def_pacv_rec);
2094: --- Validate all non-missing attributes (Item Level Validation)

Line 2091: RAISE OKC_API.G_EXCEPTION_ERROR;

2087: l_return_status := populate_new_record(l_pacv_rec, l_def_pacv_rec);
2088: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2089: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2090: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2091: RAISE OKC_API.G_EXCEPTION_ERROR;
2092: END IF;
2093: l_def_pacv_rec := fill_who_columns(l_def_pacv_rec);
2094: --- Validate all non-missing attributes (Item Level Validation)
2095: l_return_status := Validate_Attributes(l_def_pacv_rec);

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

2093: l_def_pacv_rec := fill_who_columns(l_def_pacv_rec);
2094: --- Validate all non-missing attributes (Item Level Validation)
2095: l_return_status := Validate_Attributes(l_def_pacv_rec);
2096: --- If any errors happen abort API
2097: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2098: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2099: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2100: RAISE OKC_API.G_EXCEPTION_ERROR;
2101: END IF;

Line 2098: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2094: --- Validate all non-missing attributes (Item Level Validation)
2095: l_return_status := Validate_Attributes(l_def_pacv_rec);
2096: --- If any errors happen abort API
2097: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2098: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2099: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2100: RAISE OKC_API.G_EXCEPTION_ERROR;
2101: END IF;
2102: l_return_status := Validate_Record(l_def_pacv_rec);

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

2095: l_return_status := Validate_Attributes(l_def_pacv_rec);
2096: --- If any errors happen abort API
2097: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2098: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2099: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2100: RAISE OKC_API.G_EXCEPTION_ERROR;
2101: END IF;
2102: l_return_status := Validate_Record(l_def_pacv_rec);
2103: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2100: RAISE OKC_API.G_EXCEPTION_ERROR;

2096: --- If any errors happen abort API
2097: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2098: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2099: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2100: RAISE OKC_API.G_EXCEPTION_ERROR;
2101: END IF;
2102: l_return_status := Validate_Record(l_def_pacv_rec);
2103: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2104: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2099: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2100: RAISE OKC_API.G_EXCEPTION_ERROR;
2101: END IF;
2102: l_return_status := Validate_Record(l_def_pacv_rec);
2103: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2104: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2105: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2106: RAISE OKC_API.G_EXCEPTION_ERROR;
2107: END IF;

Line 2104: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2100: RAISE OKC_API.G_EXCEPTION_ERROR;
2101: END IF;
2102: l_return_status := Validate_Record(l_def_pacv_rec);
2103: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2104: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2105: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2106: RAISE OKC_API.G_EXCEPTION_ERROR;
2107: END IF;
2108:

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

2101: END IF;
2102: l_return_status := Validate_Record(l_def_pacv_rec);
2103: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2104: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2105: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2106: RAISE OKC_API.G_EXCEPTION_ERROR;
2107: END IF;
2108:
2109: --------------------------------------

Line 2106: RAISE OKC_API.G_EXCEPTION_ERROR;

2102: l_return_status := Validate_Record(l_def_pacv_rec);
2103: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2104: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2105: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2106: RAISE OKC_API.G_EXCEPTION_ERROR;
2107: END IF;
2108:
2109: --------------------------------------
2110: -- Move VIEW record to "Child" records

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

2120: x_msg_data,
2121: l_pac_rec,
2122: lx_pac_rec
2123: );
2124: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2125: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2126: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2127: RAISE OKC_API.G_EXCEPTION_ERROR;
2128: END IF;

Line 2125: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2121: l_pac_rec,
2122: lx_pac_rec
2123: );
2124: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2125: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2126: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2127: RAISE OKC_API.G_EXCEPTION_ERROR;
2128: END IF;
2129: migrate(lx_pac_rec, l_def_pacv_rec);

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

2122: lx_pac_rec
2123: );
2124: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2125: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2126: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2127: RAISE OKC_API.G_EXCEPTION_ERROR;
2128: END IF;
2129: migrate(lx_pac_rec, l_def_pacv_rec);
2130: x_pacv_rec := l_def_pacv_rec;

Line 2127: RAISE OKC_API.G_EXCEPTION_ERROR;

2123: );
2124: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2125: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2126: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2127: RAISE OKC_API.G_EXCEPTION_ERROR;
2128: END IF;
2129: migrate(lx_pac_rec, l_def_pacv_rec);
2130: x_pacv_rec := l_def_pacv_rec;
2131: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2127: RAISE OKC_API.G_EXCEPTION_ERROR;
2128: END IF;
2129: migrate(lx_pac_rec, l_def_pacv_rec);
2130: x_pacv_rec := l_def_pacv_rec;
2131: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2132:
2133: IF (l_debug = 'Y') THEN
2134: okc_debug.log('8300: Leaving update_row', 2);
2135: okc_debug.Reset_Indentation;

Line 2139: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2135: okc_debug.Reset_Indentation;
2136: END IF;
2137:
2138: EXCEPTION
2139: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2140:
2141: IF (l_debug = 'Y') THEN
2142: okc_debug.log('8400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2143: okc_debug.Reset_Indentation;

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

2138: EXCEPTION
2139: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2140:
2141: IF (l_debug = 'Y') THEN
2142: okc_debug.log('8400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2143: okc_debug.Reset_Indentation;
2144: END IF;
2145:
2146: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2146: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2142: okc_debug.log('8400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2143: okc_debug.Reset_Indentation;
2144: END IF;
2145:
2146: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2147: (
2148: l_api_name,
2149: G_PKG_NAME,
2150: 'OKC_API.G_RET_STS_ERROR',

Line 2150: 'OKC_API.G_RET_STS_ERROR',

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

Line 2155: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2151: x_msg_count,
2152: x_msg_data,
2153: '_PVT'
2154: );
2155: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2156:
2157: IF (l_debug = 'Y') THEN
2158: okc_debug.log('8500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2159: okc_debug.Reset_Indentation;

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

2154: );
2155: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2156:
2157: IF (l_debug = 'Y') THEN
2158: okc_debug.log('8500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2159: okc_debug.Reset_Indentation;
2160: END IF;
2161:
2162: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2162: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2158: okc_debug.log('8500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2159: okc_debug.Reset_Indentation;
2160: END IF;
2161:
2162: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2163: (
2164: l_api_name,
2165: G_PKG_NAME,
2166: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2166: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2162: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2163: (
2164: l_api_name,
2165: G_PKG_NAME,
2166: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2167: x_msg_count,
2168: x_msg_data,
2169: '_PVT'
2170: );

Line 2178: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2174: okc_debug.log('8600: Exiting update_row:OTHERS Exception', 2);
2175: okc_debug.Reset_Indentation;
2176: END IF;
2177:
2178: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2179: (
2180: l_api_name,
2181: G_PKG_NAME,
2182: 'OTHERS',

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

2199: x_pacv_tbl OUT NOCOPY pacv_tbl_type) IS
2200:
2201: l_api_version CONSTANT NUMBER := 1;
2202: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2203: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2204: i NUMBER := 0;
2205: BEGIN
2206:
2207: IF (l_debug = 'Y') THEN

Line 2212: OKC_API.init_msg_list(p_init_msg_list);

2208: okc_debug.Set_Indentation('OKC_PAC_PVT');
2209: okc_debug.log('8700: Entered update_row', 2);
2210: END IF;
2211:
2212: OKC_API.init_msg_list(p_init_msg_list);
2213: -- Make sure PL/SQL table has records in it before passing
2214: IF (p_pacv_tbl.COUNT > 0) THEN
2215: i := p_pacv_tbl.FIRST;
2216: LOOP

Line 2219: p_init_msg_list => OKC_API.G_FALSE,

2215: i := p_pacv_tbl.FIRST;
2216: LOOP
2217: update_row (
2218: p_api_version => p_api_version,
2219: p_init_msg_list => OKC_API.G_FALSE,
2220: x_return_status => x_return_status,
2221: x_msg_count => x_msg_count,
2222: x_msg_data => x_msg_data,
2223: p_pacv_rec => p_pacv_tbl(i),

Line 2236: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2232: okc_debug.Reset_Indentation;
2233: END IF;
2234:
2235: EXCEPTION
2236: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2237:
2238: IF (l_debug = 'Y') THEN
2239: okc_debug.log('8900: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2240: okc_debug.Reset_Indentation;

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

2235: EXCEPTION
2236: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2237:
2238: IF (l_debug = 'Y') THEN
2239: okc_debug.log('8900: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2240: okc_debug.Reset_Indentation;
2241: END IF;
2242:
2243: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2243: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2239: okc_debug.log('8900: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2240: okc_debug.Reset_Indentation;
2241: END IF;
2242:
2243: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2244: (
2245: l_api_name,
2246: G_PKG_NAME,
2247: 'OKC_API.G_RET_STS_ERROR',

Line 2247: 'OKC_API.G_RET_STS_ERROR',

2243: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2244: (
2245: l_api_name,
2246: G_PKG_NAME,
2247: 'OKC_API.G_RET_STS_ERROR',
2248: x_msg_count,
2249: x_msg_data,
2250: '_PVT'
2251: );

Line 2252: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2248: x_msg_count,
2249: x_msg_data,
2250: '_PVT'
2251: );
2252: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2253:
2254: IF (l_debug = 'Y') THEN
2255: okc_debug.log('9000: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2256: okc_debug.Reset_Indentation;

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

2251: );
2252: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2253:
2254: IF (l_debug = 'Y') THEN
2255: okc_debug.log('9000: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2256: okc_debug.Reset_Indentation;
2257: END IF;
2258:
2259: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2259: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2255: okc_debug.log('9000: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2256: okc_debug.Reset_Indentation;
2257: END IF;
2258:
2259: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2260: (
2261: l_api_name,
2262: G_PKG_NAME,
2263: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2263: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2259: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2260: (
2261: l_api_name,
2262: G_PKG_NAME,
2263: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2264: x_msg_count,
2265: x_msg_data,
2266: '_PVT'
2267: );

Line 2275: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2271: okc_debug.log('9100: Exiting update_row:OTHERS Exception', 2);
2272: okc_debug.Reset_Indentation;
2273: END IF;
2274:
2275: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2276: (
2277: l_api_name,
2278: G_PKG_NAME,
2279: 'OTHERS',

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

2298: p_pac_rec IN pac_rec_type) IS
2299:
2300: l_api_version CONSTANT NUMBER := 1;
2301: l_api_name CONSTANT VARCHAR2(30) := 'ASSOCS_delete_row';
2302: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2303: l_pac_rec pac_rec_type:= p_pac_rec;
2304: l_row_notfound BOOLEAN := TRUE;
2305: BEGIN
2306:

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

2308: okc_debug.Set_Indentation('OKC_PAC_PVT');
2309: okc_debug.log('9200: Entered delete_row', 2);
2310: END IF;
2311:
2312: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2313: p_init_msg_list,
2314: '_PVT',
2315: x_return_status);
2316: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2312: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2313: p_init_msg_list,
2314: '_PVT',
2315: x_return_status);
2316: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2319: RAISE OKC_API.G_EXCEPTION_ERROR;
2320: END IF;

Line 2317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2313: p_init_msg_list,
2314: '_PVT',
2315: x_return_status);
2316: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2319: RAISE OKC_API.G_EXCEPTION_ERROR;
2320: END IF;
2321: DELETE FROM OKC_PRICE_ADJ_ASSOCS

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

2314: '_PVT',
2315: x_return_status);
2316: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2319: RAISE OKC_API.G_EXCEPTION_ERROR;
2320: END IF;
2321: DELETE FROM OKC_PRICE_ADJ_ASSOCS
2322: WHERE ID = l_pac_rec.id;

Line 2319: RAISE OKC_API.G_EXCEPTION_ERROR;

2315: x_return_status);
2316: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2319: RAISE OKC_API.G_EXCEPTION_ERROR;
2320: END IF;
2321: DELETE FROM OKC_PRICE_ADJ_ASSOCS
2322: WHERE ID = l_pac_rec.id;
2323:

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

2320: END IF;
2321: DELETE FROM OKC_PRICE_ADJ_ASSOCS
2322: WHERE ID = l_pac_rec.id;
2323:
2324: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2325:
2326: IF (l_debug = 'Y') THEN
2327: okc_debug.log('9300: Leaving delete_row', 2);
2328: okc_debug.Reset_Indentation;

Line 2332: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2328: okc_debug.Reset_Indentation;
2329: END IF;
2330:
2331: EXCEPTION
2332: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2333:
2334: IF (l_debug = 'Y') THEN
2335: okc_debug.log('9400: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2336: okc_debug.Reset_Indentation;

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

2331: EXCEPTION
2332: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2333:
2334: IF (l_debug = 'Y') THEN
2335: okc_debug.log('9400: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2336: okc_debug.Reset_Indentation;
2337: END IF;
2338:
2339: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2339: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2335: okc_debug.log('9400: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2336: okc_debug.Reset_Indentation;
2337: END IF;
2338:
2339: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2340: (
2341: l_api_name,
2342: G_PKG_NAME,
2343: 'OKC_API.G_RET_STS_ERROR',

Line 2343: 'OKC_API.G_RET_STS_ERROR',

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

Line 2348: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2344: x_msg_count,
2345: x_msg_data,
2346: '_PVT'
2347: );
2348: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2349:
2350: IF (l_debug = 'Y') THEN
2351: okc_debug.log('9500: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2352: okc_debug.Reset_Indentation;

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

2347: );
2348: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2349:
2350: IF (l_debug = 'Y') THEN
2351: okc_debug.log('9500: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2352: okc_debug.Reset_Indentation;
2353: END IF;
2354:
2355: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2355: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2351: okc_debug.log('9500: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2352: okc_debug.Reset_Indentation;
2353: END IF;
2354:
2355: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2356: (
2357: l_api_name,
2358: G_PKG_NAME,
2359: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2359: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2355: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2356: (
2357: l_api_name,
2358: G_PKG_NAME,
2359: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2360: x_msg_count,
2361: x_msg_data,
2362: '_PVT'
2363: );

Line 2371: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2367: okc_debug.log('9600: Exiting delete_row:OTHERS Exception', 2);
2368: okc_debug.Reset_Indentation;
2369: END IF;
2370:
2371: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2372: (
2373: l_api_name,
2374: G_PKG_NAME,
2375: 'OTHERS',

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

2391: p_pacv_rec IN pacv_rec_type) IS
2392:
2393: l_api_version CONSTANT NUMBER := 1;
2394: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2395: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2396: l_pacv_rec pacv_rec_type := p_pacv_rec;
2397: l_pac_rec pac_rec_type;
2398: BEGIN
2399:

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

2401: okc_debug.Set_Indentation('OKC_PAC_PVT');
2402: okc_debug.log('9700: Entered delete_row', 2);
2403: END IF;
2404:
2405: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2406: G_PKG_NAME,
2407: p_init_msg_list,
2408: l_api_version,
2409: p_api_version,

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

2408: l_api_version,
2409: p_api_version,
2410: '_PVT',
2411: x_return_status);
2412: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2413: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2414: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2415: RAISE OKC_API.G_EXCEPTION_ERROR;
2416: END IF;

Line 2413: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2409: p_api_version,
2410: '_PVT',
2411: x_return_status);
2412: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2413: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2414: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2415: RAISE OKC_API.G_EXCEPTION_ERROR;
2416: END IF;
2417: --------------------------------------

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

2410: '_PVT',
2411: x_return_status);
2412: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2413: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2414: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2415: RAISE OKC_API.G_EXCEPTION_ERROR;
2416: END IF;
2417: --------------------------------------
2418: -- Move VIEW record to "Child" records

Line 2415: RAISE OKC_API.G_EXCEPTION_ERROR;

2411: x_return_status);
2412: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2413: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2414: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2415: RAISE OKC_API.G_EXCEPTION_ERROR;
2416: END IF;
2417: --------------------------------------
2418: -- Move VIEW record to "Child" records
2419: --------------------------------------

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

2427: x_msg_count,
2428: x_msg_data,
2429: l_pac_rec
2430: );
2431: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2432: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2433: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2434: RAISE OKC_API.G_EXCEPTION_ERROR;
2435: END IF;

Line 2432: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2428: x_msg_data,
2429: l_pac_rec
2430: );
2431: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2432: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2433: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2434: RAISE OKC_API.G_EXCEPTION_ERROR;
2435: END IF;
2436: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2429: l_pac_rec
2430: );
2431: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2432: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2433: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2434: RAISE OKC_API.G_EXCEPTION_ERROR;
2435: END IF;
2436: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2437:

Line 2434: RAISE OKC_API.G_EXCEPTION_ERROR;

2430: );
2431: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2432: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2433: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2434: RAISE OKC_API.G_EXCEPTION_ERROR;
2435: END IF;
2436: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2437:
2438: IF (l_debug = 'Y') THEN

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

2432: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2433: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2434: RAISE OKC_API.G_EXCEPTION_ERROR;
2435: END IF;
2436: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2437:
2438: IF (l_debug = 'Y') THEN
2439: okc_debug.log('9800: Leaving delete_row', 2);
2440: okc_debug.Reset_Indentation;

Line 2444: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2440: okc_debug.Reset_Indentation;
2441: END IF;
2442:
2443: EXCEPTION
2444: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2445:
2446: IF (l_debug = 'Y') THEN
2447: okc_debug.log('9900: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2448: okc_debug.Reset_Indentation;

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

2443: EXCEPTION
2444: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2445:
2446: IF (l_debug = 'Y') THEN
2447: okc_debug.log('9900: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2448: okc_debug.Reset_Indentation;
2449: END IF;
2450:
2451: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2451: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2447: okc_debug.log('9900: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2448: okc_debug.Reset_Indentation;
2449: END IF;
2450:
2451: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2452: (
2453: l_api_name,
2454: G_PKG_NAME,
2455: 'OKC_API.G_RET_STS_ERROR',

Line 2455: 'OKC_API.G_RET_STS_ERROR',

2451: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2452: (
2453: l_api_name,
2454: G_PKG_NAME,
2455: 'OKC_API.G_RET_STS_ERROR',
2456: x_msg_count,
2457: x_msg_data,
2458: '_PVT'
2459: );

Line 2460: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2456: x_msg_count,
2457: x_msg_data,
2458: '_PVT'
2459: );
2460: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2461:
2462: IF (l_debug = 'Y') THEN
2463: okc_debug.log('10000: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2464: okc_debug.Reset_Indentation;

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

2459: );
2460: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2461:
2462: IF (l_debug = 'Y') THEN
2463: okc_debug.log('10000: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2464: okc_debug.Reset_Indentation;
2465: END IF;
2466:
2467: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2467: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2463: okc_debug.log('10000: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2464: okc_debug.Reset_Indentation;
2465: END IF;
2466:
2467: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2468: (
2469: l_api_name,
2470: G_PKG_NAME,
2471: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2471: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2483: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2479: okc_debug.log('10100: Exiting delete_row:OTHERS Exception', 2);
2480: okc_debug.Reset_Indentation;
2481: END IF;
2482:
2483: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2484: (
2485: l_api_name,
2486: G_PKG_NAME,
2487: 'OTHERS',

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

2503: p_pacv_tbl IN pacv_tbl_type) IS
2504:
2505: l_api_version CONSTANT NUMBER := 1;
2506: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2507: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2508: i NUMBER := 0;
2509: BEGIN
2510:
2511: IF (l_debug = 'Y') THEN

Line 2516: OKC_API.init_msg_list(p_init_msg_list);

2512: okc_debug.Set_Indentation('OKC_PAC_PVT');
2513: okc_debug.log('10200: Entered delete_row', 2);
2514: END IF;
2515:
2516: OKC_API.init_msg_list(p_init_msg_list);
2517: -- Make sure PL/SQL table has records in it before passing
2518: IF (p_pacv_tbl.COUNT > 0) THEN
2519: i := p_pacv_tbl.FIRST;
2520: LOOP

Line 2523: p_init_msg_list => OKC_API.G_FALSE,

2519: i := p_pacv_tbl.FIRST;
2520: LOOP
2521: delete_row (
2522: p_api_version => p_api_version,
2523: p_init_msg_list => OKC_API.G_FALSE,
2524: x_return_status => x_return_status,
2525: x_msg_count => x_msg_count,
2526: x_msg_data => x_msg_data,
2527: p_pacv_rec => p_pacv_tbl(i));

Line 2539: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2535: okc_debug.Reset_Indentation;
2536: END IF;
2537:
2538: EXCEPTION
2539: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2540:
2541: IF (l_debug = 'Y') THEN
2542: okc_debug.log('10400: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2543: okc_debug.Reset_Indentation;

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

2538: EXCEPTION
2539: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2540:
2541: IF (l_debug = 'Y') THEN
2542: okc_debug.log('10400: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2543: okc_debug.Reset_Indentation;
2544: END IF;
2545:
2546: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2546: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2542: okc_debug.log('10400: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2543: okc_debug.Reset_Indentation;
2544: END IF;
2545:
2546: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2547: (
2548: l_api_name,
2549: G_PKG_NAME,
2550: 'OKC_API.G_RET_STS_ERROR',

Line 2550: 'OKC_API.G_RET_STS_ERROR',

2546: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2547: (
2548: l_api_name,
2549: G_PKG_NAME,
2550: 'OKC_API.G_RET_STS_ERROR',
2551: x_msg_count,
2552: x_msg_data,
2553: '_PVT'
2554: );

Line 2555: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2551: x_msg_count,
2552: x_msg_data,
2553: '_PVT'
2554: );
2555: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2556:
2557: IF (l_debug = 'Y') THEN
2558: okc_debug.log('10500: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2559: okc_debug.Reset_Indentation;

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

2554: );
2555: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2556:
2557: IF (l_debug = 'Y') THEN
2558: okc_debug.log('10500: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2559: okc_debug.Reset_Indentation;
2560: END IF;
2561:
2562: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2562: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2558: okc_debug.log('10500: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2559: okc_debug.Reset_Indentation;
2560: END IF;
2561:
2562: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2563: (
2564: l_api_name,
2565: G_PKG_NAME,
2566: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2566: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2578: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2574: okc_debug.log('10600: Exiting delete_row:OTHERS Exception', 2);
2575: okc_debug.Reset_Indentation;
2576: END IF;
2577:
2578: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2579: (
2580: l_api_name,
2581: G_PKG_NAME,
2582: 'OTHERS',

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

2591: p_chr_id IN NUMBER,
2592: p_major_version IN NUMBER
2593: ) RETURN VARCHAR2 IS
2594:
2595: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2596:
2597: BEGIN
2598:
2599: IF (l_debug = 'Y') THEN

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

2662: okc_debug.Reset_Indentation;
2663: END IF;
2664:
2665: -- store SQL error message on message stack
2666: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2667: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2668: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2669: p_token1_value => sqlcode,
2670: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 2674: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2670: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2671: p_token2_value => sqlerrm);
2672:
2673: -- notify UNEXPECTED error
2674: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2675: return l_return_status;
2676:
2677: END create_version;
2678:

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

2681: p_chr_id IN NUMBER,
2682: p_major_version IN NUMBER
2683: ) RETURN VARCHAR2 IS
2684:
2685: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2686:
2687: BEGIN
2688:
2689: IF (l_debug = 'Y') THEN

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

2751: okc_debug.Reset_Indentation;
2752: END IF;
2753:
2754: -- store SQL error message on message stack
2755: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2756: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2757: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2758: p_token1_value => sqlcode,
2759: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 2763: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2759: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2760: p_token2_value => sqlerrm);
2761:
2762: -- notify UNEXPECTED error
2763: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2764: return l_return_status;
2765:
2766: END restore_version;
2767: