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

APPS.OKL_MST_PVT dependencies on OKL_API

Line 25: x_return_status := OKL_API.G_RET_STS_SUCCESS;

21: FROM okl_mass_rbk_criteria
22: WHERE request_name = p_request_name;
23:
24: BEGIN
25: x_return_status := OKL_API.G_RET_STS_SUCCESS;
26:
27: OPEN crit_csr(p_request_name);
28: FETCH crit_csr INTO l_present;
29: IF crit_csr%NOTFOUND THEN

Line 30: OKL_API.set_message(p_app_name => G_APP_NAME,

26:
27: OPEN crit_csr(p_request_name);
28: FETCH crit_csr INTO l_present;
29: IF crit_csr%NOTFOUND THEN
30: OKL_API.set_message(p_app_name => G_APP_NAME,
31: p_msg_name => G_NO_MATCHING_RECORD,
32: p_token1 => G_COL_NAME_TOKEN,
33: p_token1_value => 'request_name');
34:

Line 49: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

45:
46: IF crit_csr%ISOPEN THEN
47: CLOSE crit_csr;
48: END IF;
49: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
50:
51: WHEN OTHERS THEN
52: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
53: ,p_msg_name => G_UNEXPECTED_ERROR

Line 52: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

48: END IF;
49: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
50:
51: WHEN OTHERS THEN
52: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
53: ,p_msg_name => G_UNEXPECTED_ERROR
54: ,p_token1 => G_SQLCODE_TOKEN
55: ,p_token1_value => SQLCODE
56: ,p_token2 => G_SQLERRM_TOKEN

Line 58: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

54: ,p_token1 => G_SQLCODE_TOKEN
55: ,p_token1_value => SQLCODE
56: ,p_token2 => G_SQLERRM_TOKEN
57: ,p_token2_value => SQLERRM);
58: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
59:
60: END validate_request_name;
61:
62: ---------------------------------------------------------------------------

Line 189: x_return_status := OKL_API.G_RET_STS_SUCCESS;

185: ) RETURN mstv_rec_type IS
186: l_mstv_rec mstv_rec_type;
187: l_row_notfound BOOLEAN := TRUE;
188: BEGIN
189: x_return_status := OKL_API.G_RET_STS_SUCCESS;
190: l_mstv_rec := get_rec(p_mstv_rec, l_row_notfound);
191: IF (l_row_notfound) THEN
192: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
193: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 192: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

188: BEGIN
189: x_return_status := OKL_API.G_RET_STS_SUCCESS;
190: l_mstv_rec := get_rec(p_mstv_rec, l_row_notfound);
191: IF (l_row_notfound) THEN
192: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
193: x_return_status := OKL_API.G_RET_STS_ERROR;
194: END IF;
195: RETURN(l_mstv_rec);
196: END get_rec;

Line 193: x_return_status := OKL_API.G_RET_STS_ERROR;

189: x_return_status := OKL_API.G_RET_STS_SUCCESS;
190: l_mstv_rec := get_rec(p_mstv_rec, l_row_notfound);
191: IF (l_row_notfound) THEN
192: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
193: x_return_status := OKL_API.G_RET_STS_ERROR;
194: END IF;
195: RETURN(l_mstv_rec);
196: END get_rec;
197: -----------------------------------------------------------

Line 302: x_return_status := OKL_API.G_RET_STS_SUCCESS;

298: ) RETURN mst_rec_type IS
299: l_mst_rec mst_rec_type;
300: l_row_notfound BOOLEAN := TRUE;
301: BEGIN
302: x_return_status := OKL_API.G_RET_STS_SUCCESS;
303: l_mst_rec := get_rec(p_mst_rec, l_row_notfound);
304: IF (l_row_notfound) THEN
305: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
306: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 305: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

301: BEGIN
302: x_return_status := OKL_API.G_RET_STS_SUCCESS;
303: l_mst_rec := get_rec(p_mst_rec, l_row_notfound);
304: IF (l_row_notfound) THEN
305: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
306: x_return_status := OKL_API.G_RET_STS_ERROR;
307: END IF;
308: RETURN(l_mst_rec);
309: END get_rec;

Line 306: x_return_status := OKL_API.G_RET_STS_ERROR;

302: x_return_status := OKL_API.G_RET_STS_SUCCESS;
303: l_mst_rec := get_rec(p_mst_rec, l_row_notfound);
304: IF (l_row_notfound) THEN
305: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
306: x_return_status := OKL_API.G_RET_STS_ERROR;
307: END IF;
308: RETURN(l_mst_rec);
309: END get_rec;
310: -----------------------------------------------------------

Line 328: IF (l_mstv_rec.id = OKL_API.G_MISS_NUM ) THEN

324: p_mstv_rec IN mstv_rec_type
325: ) RETURN mstv_rec_type IS
326: l_mstv_rec mstv_rec_type := p_mstv_rec;
327: BEGIN
328: IF (l_mstv_rec.id = OKL_API.G_MISS_NUM ) THEN
329: l_mstv_rec.id := NULL;
330: END IF;
331: IF (l_mstv_rec.request_name = OKL_API.G_MISS_CHAR ) THEN
332: l_mstv_rec.request_name := NULL;

Line 331: IF (l_mstv_rec.request_name = OKL_API.G_MISS_CHAR ) THEN

327: BEGIN
328: IF (l_mstv_rec.id = OKL_API.G_MISS_NUM ) THEN
329: l_mstv_rec.id := NULL;
330: END IF;
331: IF (l_mstv_rec.request_name = OKL_API.G_MISS_CHAR ) THEN
332: l_mstv_rec.request_name := NULL;
333: END IF;
334: IF (l_mstv_rec.khr_id = OKL_API.G_MISS_NUM ) THEN
335: l_mstv_rec.khr_id := NULL;

Line 334: IF (l_mstv_rec.khr_id = OKL_API.G_MISS_NUM ) THEN

330: END IF;
331: IF (l_mstv_rec.request_name = OKL_API.G_MISS_CHAR ) THEN
332: l_mstv_rec.request_name := NULL;
333: END IF;
334: IF (l_mstv_rec.khr_id = OKL_API.G_MISS_NUM ) THEN
335: l_mstv_rec.khr_id := NULL;
336: END IF;
337: IF (l_mstv_rec.contract_number = OKL_API.G_MISS_CHAR ) THEN
338: l_mstv_rec.contract_number := NULL;

Line 337: IF (l_mstv_rec.contract_number = OKL_API.G_MISS_CHAR ) THEN

333: END IF;
334: IF (l_mstv_rec.khr_id = OKL_API.G_MISS_NUM ) THEN
335: l_mstv_rec.khr_id := NULL;
336: END IF;
337: IF (l_mstv_rec.contract_number = OKL_API.G_MISS_CHAR ) THEN
338: l_mstv_rec.contract_number := NULL;
339: END IF;
340: IF (l_mstv_rec.contract_description = OKL_API.G_MISS_CHAR ) THEN
341: l_mstv_rec.contract_description := NULL;

Line 340: IF (l_mstv_rec.contract_description = OKL_API.G_MISS_CHAR ) THEN

336: END IF;
337: IF (l_mstv_rec.contract_number = OKL_API.G_MISS_CHAR ) THEN
338: l_mstv_rec.contract_number := NULL;
339: END IF;
340: IF (l_mstv_rec.contract_description = OKL_API.G_MISS_CHAR ) THEN
341: l_mstv_rec.contract_description := NULL;
342: END IF;
343: IF (l_mstv_rec.kle_id = OKL_API.G_MISS_NUM ) THEN
344: l_mstv_rec.kle_id := NULL;

Line 343: IF (l_mstv_rec.kle_id = OKL_API.G_MISS_NUM ) THEN

339: END IF;
340: IF (l_mstv_rec.contract_description = OKL_API.G_MISS_CHAR ) THEN
341: l_mstv_rec.contract_description := NULL;
342: END IF;
343: IF (l_mstv_rec.kle_id = OKL_API.G_MISS_NUM ) THEN
344: l_mstv_rec.kle_id := NULL;
345: END IF;
346: IF (l_mstv_rec.transaction_id = OKL_API.G_MISS_NUM ) THEN
347: l_mstv_rec.transaction_id := NULL;

Line 346: IF (l_mstv_rec.transaction_id = OKL_API.G_MISS_NUM ) THEN

342: END IF;
343: IF (l_mstv_rec.kle_id = OKL_API.G_MISS_NUM ) THEN
344: l_mstv_rec.kle_id := NULL;
345: END IF;
346: IF (l_mstv_rec.transaction_id = OKL_API.G_MISS_NUM ) THEN
347: l_mstv_rec.transaction_id := NULL;
348: END IF;
349: IF (l_mstv_rec.selected_flag = OKL_API.G_MISS_CHAR ) THEN
350: l_mstv_rec.selected_flag := NULL;

Line 349: IF (l_mstv_rec.selected_flag = OKL_API.G_MISS_CHAR ) THEN

345: END IF;
346: IF (l_mstv_rec.transaction_id = OKL_API.G_MISS_NUM ) THEN
347: l_mstv_rec.transaction_id := NULL;
348: END IF;
349: IF (l_mstv_rec.selected_flag = OKL_API.G_MISS_CHAR ) THEN
350: l_mstv_rec.selected_flag := NULL;
351: END IF;
352: IF (l_mstv_rec.status = OKL_API.G_MISS_CHAR ) THEN
353: l_mstv_rec.status := NULL;

Line 352: IF (l_mstv_rec.status = OKL_API.G_MISS_CHAR ) THEN

348: END IF;
349: IF (l_mstv_rec.selected_flag = OKL_API.G_MISS_CHAR ) THEN
350: l_mstv_rec.selected_flag := NULL;
351: END IF;
352: IF (l_mstv_rec.status = OKL_API.G_MISS_CHAR ) THEN
353: l_mstv_rec.status := NULL;
354: END IF;
355: IF (l_mstv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
356: l_mstv_rec.attribute_category := NULL;

Line 355: IF (l_mstv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN

351: END IF;
352: IF (l_mstv_rec.status = OKL_API.G_MISS_CHAR ) THEN
353: l_mstv_rec.status := NULL;
354: END IF;
355: IF (l_mstv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
356: l_mstv_rec.attribute_category := NULL;
357: END IF;
358: IF (l_mstv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
359: l_mstv_rec.attribute1 := NULL;

Line 358: IF (l_mstv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN

354: END IF;
355: IF (l_mstv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
356: l_mstv_rec.attribute_category := NULL;
357: END IF;
358: IF (l_mstv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
359: l_mstv_rec.attribute1 := NULL;
360: END IF;
361: IF (l_mstv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
362: l_mstv_rec.attribute2 := NULL;

Line 361: IF (l_mstv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN

357: END IF;
358: IF (l_mstv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
359: l_mstv_rec.attribute1 := NULL;
360: END IF;
361: IF (l_mstv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
362: l_mstv_rec.attribute2 := NULL;
363: END IF;
364: IF (l_mstv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
365: l_mstv_rec.attribute3 := NULL;

Line 364: IF (l_mstv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN

360: END IF;
361: IF (l_mstv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
362: l_mstv_rec.attribute2 := NULL;
363: END IF;
364: IF (l_mstv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
365: l_mstv_rec.attribute3 := NULL;
366: END IF;
367: IF (l_mstv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
368: l_mstv_rec.attribute4 := NULL;

Line 367: IF (l_mstv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN

363: END IF;
364: IF (l_mstv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
365: l_mstv_rec.attribute3 := NULL;
366: END IF;
367: IF (l_mstv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
368: l_mstv_rec.attribute4 := NULL;
369: END IF;
370: IF (l_mstv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
371: l_mstv_rec.attribute5 := NULL;

Line 370: IF (l_mstv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN

366: END IF;
367: IF (l_mstv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
368: l_mstv_rec.attribute4 := NULL;
369: END IF;
370: IF (l_mstv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
371: l_mstv_rec.attribute5 := NULL;
372: END IF;
373: IF (l_mstv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
374: l_mstv_rec.attribute6 := NULL;

Line 373: IF (l_mstv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN

369: END IF;
370: IF (l_mstv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
371: l_mstv_rec.attribute5 := NULL;
372: END IF;
373: IF (l_mstv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
374: l_mstv_rec.attribute6 := NULL;
375: END IF;
376: IF (l_mstv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
377: l_mstv_rec.attribute7 := NULL;

Line 376: IF (l_mstv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN

372: END IF;
373: IF (l_mstv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
374: l_mstv_rec.attribute6 := NULL;
375: END IF;
376: IF (l_mstv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
377: l_mstv_rec.attribute7 := NULL;
378: END IF;
379: IF (l_mstv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
380: l_mstv_rec.attribute8 := NULL;

Line 379: IF (l_mstv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN

375: END IF;
376: IF (l_mstv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
377: l_mstv_rec.attribute7 := NULL;
378: END IF;
379: IF (l_mstv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
380: l_mstv_rec.attribute8 := NULL;
381: END IF;
382: IF (l_mstv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
383: l_mstv_rec.attribute9 := NULL;

Line 382: IF (l_mstv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN

378: END IF;
379: IF (l_mstv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
380: l_mstv_rec.attribute8 := NULL;
381: END IF;
382: IF (l_mstv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
383: l_mstv_rec.attribute9 := NULL;
384: END IF;
385: IF (l_mstv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
386: l_mstv_rec.attribute10 := NULL;

Line 385: IF (l_mstv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN

381: END IF;
382: IF (l_mstv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
383: l_mstv_rec.attribute9 := NULL;
384: END IF;
385: IF (l_mstv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
386: l_mstv_rec.attribute10 := NULL;
387: END IF;
388: IF (l_mstv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
389: l_mstv_rec.attribute11 := NULL;

Line 388: IF (l_mstv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN

384: END IF;
385: IF (l_mstv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
386: l_mstv_rec.attribute10 := NULL;
387: END IF;
388: IF (l_mstv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
389: l_mstv_rec.attribute11 := NULL;
390: END IF;
391: IF (l_mstv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
392: l_mstv_rec.attribute12 := NULL;

Line 391: IF (l_mstv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN

387: END IF;
388: IF (l_mstv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
389: l_mstv_rec.attribute11 := NULL;
390: END IF;
391: IF (l_mstv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
392: l_mstv_rec.attribute12 := NULL;
393: END IF;
394: IF (l_mstv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
395: l_mstv_rec.attribute13 := NULL;

Line 394: IF (l_mstv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN

390: END IF;
391: IF (l_mstv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
392: l_mstv_rec.attribute12 := NULL;
393: END IF;
394: IF (l_mstv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
395: l_mstv_rec.attribute13 := NULL;
396: END IF;
397: IF (l_mstv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
398: l_mstv_rec.attribute14 := NULL;

Line 397: IF (l_mstv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN

393: END IF;
394: IF (l_mstv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
395: l_mstv_rec.attribute13 := NULL;
396: END IF;
397: IF (l_mstv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
398: l_mstv_rec.attribute14 := NULL;
399: END IF;
400: IF (l_mstv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
401: l_mstv_rec.attribute15 := NULL;

Line 400: IF (l_mstv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN

396: END IF;
397: IF (l_mstv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
398: l_mstv_rec.attribute14 := NULL;
399: END IF;
400: IF (l_mstv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
401: l_mstv_rec.attribute15 := NULL;
402: END IF;
403: IF (l_mstv_rec.created_by = OKL_API.G_MISS_NUM ) THEN
404: l_mstv_rec.created_by := NULL;

Line 403: IF (l_mstv_rec.created_by = OKL_API.G_MISS_NUM ) THEN

399: END IF;
400: IF (l_mstv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
401: l_mstv_rec.attribute15 := NULL;
402: END IF;
403: IF (l_mstv_rec.created_by = OKL_API.G_MISS_NUM ) THEN
404: l_mstv_rec.created_by := NULL;
405: END IF;
406: IF (l_mstv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
407: l_mstv_rec.creation_date := NULL;

Line 406: IF (l_mstv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN

402: END IF;
403: IF (l_mstv_rec.created_by = OKL_API.G_MISS_NUM ) THEN
404: l_mstv_rec.created_by := NULL;
405: END IF;
406: IF (l_mstv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
407: l_mstv_rec.creation_date := NULL;
408: END IF;
409: IF (l_mstv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
410: l_mstv_rec.last_updated_by := NULL;

Line 409: IF (l_mstv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN

405: END IF;
406: IF (l_mstv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
407: l_mstv_rec.creation_date := NULL;
408: END IF;
409: IF (l_mstv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
410: l_mstv_rec.last_updated_by := NULL;
411: END IF;
412: IF (l_mstv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
413: l_mstv_rec.last_update_date := NULL;

Line 412: IF (l_mstv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN

408: END IF;
409: IF (l_mstv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
410: l_mstv_rec.last_updated_by := NULL;
411: END IF;
412: IF (l_mstv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
413: l_mstv_rec.last_update_date := NULL;
414: END IF;
415: IF (l_mstv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
416: l_mstv_rec.last_update_login := NULL;

Line 415: IF (l_mstv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN

411: END IF;
412: IF (l_mstv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
413: l_mstv_rec.last_update_date := NULL;
414: END IF;
415: IF (l_mstv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
416: l_mstv_rec.last_update_login := NULL;
417: END IF;
418: IF (l_mstv_rec.transaction_date = OKL_API.G_MISS_DATE ) THEN
419: l_mstv_rec.transaction_date := NULL;

Line 418: IF (l_mstv_rec.transaction_date = OKL_API.G_MISS_DATE ) THEN

414: END IF;
415: IF (l_mstv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
416: l_mstv_rec.last_update_login := NULL;
417: END IF;
418: IF (l_mstv_rec.transaction_date = OKL_API.G_MISS_DATE ) THEN
419: l_mstv_rec.transaction_date := NULL;
420: END IF;
421: RETURN(l_mstv_rec);
422: END null_out_defaults;

Line 431: x_return_status := OKL_API.G_RET_STS_SUCCESS;

427: PROCEDURE validate_id(
428: x_return_status OUT NOCOPY VARCHAR2,
429: p_id IN NUMBER) IS
430: BEGIN
431: x_return_status := OKL_API.G_RET_STS_SUCCESS;
432: IF (p_id = OKL_API.G_MISS_NUM OR
433: p_id IS NULL)
434: THEN
435: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');

Line 432: IF (p_id = OKL_API.G_MISS_NUM OR

428: x_return_status OUT NOCOPY VARCHAR2,
429: p_id IN NUMBER) IS
430: BEGIN
431: x_return_status := OKL_API.G_RET_STS_SUCCESS;
432: IF (p_id = OKL_API.G_MISS_NUM OR
433: p_id IS NULL)
434: THEN
435: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
436: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 435: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');

431: x_return_status := OKL_API.G_RET_STS_SUCCESS;
432: IF (p_id = OKL_API.G_MISS_NUM OR
433: p_id IS NULL)
434: THEN
435: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
436: x_return_status := OKL_API.G_RET_STS_ERROR;
437: RAISE G_EXCEPTION_HALT_VALIDATION;
438: END IF;
439: EXCEPTION

Line 436: x_return_status := OKL_API.G_RET_STS_ERROR;

432: IF (p_id = OKL_API.G_MISS_NUM OR
433: p_id IS NULL)
434: THEN
435: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
436: x_return_status := OKL_API.G_RET_STS_ERROR;
437: RAISE G_EXCEPTION_HALT_VALIDATION;
438: END IF;
439: EXCEPTION
440: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 443: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

439: EXCEPTION
440: WHEN G_EXCEPTION_HALT_VALIDATION THEN
441: null;
442: WHEN OTHERS THEN
443: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
444: ,p_msg_name => G_UNEXPECTED_ERROR
445: ,p_token1 => G_SQLCODE_TOKEN
446: ,p_token1_value => SQLCODE
447: ,p_token2 => G_SQLERRM_TOKEN

Line 449: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

445: ,p_token1 => G_SQLCODE_TOKEN
446: ,p_token1_value => SQLCODE
447: ,p_token2 => G_SQLERRM_TOKEN
448: ,p_token2_value => SQLERRM);
449: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
450: END validate_id;
451: ---------------------------------------------------------------------------
452: -- FUNCTION Validate_Attributes
453: ---------------------------------------------------------------------------

Line 460: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

456: ---------------------------------------------------------
457: FUNCTION Validate_Attributes (
458: p_mstv_rec IN mstv_rec_type
459: ) RETURN VARCHAR2 IS
460: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
461: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
462: BEGIN
463: -----------------------------
464: -- Column Level Validation --

Line 461: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

457: FUNCTION Validate_Attributes (
458: p_mstv_rec IN mstv_rec_type
459: ) RETURN VARCHAR2 IS
460: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
461: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
462: BEGIN
463: -----------------------------
464: -- Column Level Validation --
465: -----------------------------

Line 470: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

466: -- ***
467: -- id
468: -- ***
469: validate_id(x_return_status, p_mstv_rec.id);
470: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
471: l_return_status := x_return_status;
472: RAISE G_EXCEPTION_HALT_VALIDATION;
473: END IF;
474:

Line 482: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

478: /* Commented to incorporate AM Mass re-book requirement
479: * dedey, Bug# , 06/27/2002
480:
481: validate_request_name(x_return_status, p_mstv_rec.request_name);
482: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
483: l_return_status := x_return_status;
484: RAISE G_EXCEPTION_HALT_VALIDATION;
485: END IF;
486: */

Line 497: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

493: EXCEPTION
494: WHEN G_EXCEPTION_HALT_VALIDATION THEN
495: RETURN(l_return_status);
496: WHEN OTHERS THEN
497: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
498: ,p_msg_name => G_UNEXPECTED_ERROR
499: ,p_token1 => G_SQLCODE_TOKEN
500: ,p_token1_value => SQLCODE
501: ,p_token2 => G_SQLERRM_TOKEN

Line 503: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

499: ,p_token1 => G_SQLCODE_TOKEN
500: ,p_token1_value => SQLCODE
501: ,p_token2 => G_SQLERRM_TOKEN
502: ,p_token2_value => SQLERRM);
503: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
504: RETURN(l_return_status);
505: END Validate_Attributes;
506: ---------------------------------------------------------------------------
507: -- PROCEDURE Validate_Record

Line 516: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

512: FUNCTION Validate_Record (
513: p_mstv_rec IN mstv_rec_type,
514: p_db_mstv_rec IN mstv_rec_type
515: ) RETURN VARCHAR2 IS
516: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
517: BEGIN
518: RETURN (l_return_status);
519: END Validate_Record;
520: FUNCTION Validate_Record (

Line 523: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

519: END Validate_Record;
520: FUNCTION Validate_Record (
521: p_mstv_rec IN mstv_rec_type
522: ) RETURN VARCHAR2 IS
523: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
524: l_db_mstv_rec mstv_rec_type := get_rec(p_mstv_rec);
525: BEGIN
526: l_return_status := Validate_Record(p_mstv_rec => p_mstv_rec,
527: p_db_mstv_rec => l_db_mstv_rec);

Line 624: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

620: p_mstv_rec IN mstv_rec_type) IS
621:
622: l_api_version CONSTANT NUMBER := 1;
623: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
624: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
625: l_mstv_rec mstv_rec_type := p_mstv_rec;
626: l_mst_rec mst_rec_type;
627: l_mst_rec mst_rec_type;
628: BEGIN

Line 629: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

625: l_mstv_rec mstv_rec_type := p_mstv_rec;
626: l_mst_rec mst_rec_type;
627: l_mst_rec mst_rec_type;
628: BEGIN
629: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
630: G_PKG_NAME,
631: p_init_msg_list,
632: l_api_version,
633: p_api_version,

Line 636: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

632: l_api_version,
633: p_api_version,
634: '_PVT',
635: x_return_status);
636: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
639: RAISE OKL_API.G_EXCEPTION_ERROR;
640: END IF;

Line 637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

633: p_api_version,
634: '_PVT',
635: x_return_status);
636: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
639: RAISE OKL_API.G_EXCEPTION_ERROR;
640: END IF;
641: --- Validate all non-missing attributes (Item Level Validation)

Line 638: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

634: '_PVT',
635: x_return_status);
636: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
639: RAISE OKL_API.G_EXCEPTION_ERROR;
640: END IF;
641: --- Validate all non-missing attributes (Item Level Validation)
642: l_return_status := Validate_Attributes(l_mstv_rec);

Line 639: RAISE OKL_API.G_EXCEPTION_ERROR;

635: x_return_status);
636: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
639: RAISE OKL_API.G_EXCEPTION_ERROR;
640: END IF;
641: --- Validate all non-missing attributes (Item Level Validation)
642: l_return_status := Validate_Attributes(l_mstv_rec);
643: --- If any errors happen abort API

Line 644: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

640: END IF;
641: --- Validate all non-missing attributes (Item Level Validation)
642: l_return_status := Validate_Attributes(l_mstv_rec);
643: --- If any errors happen abort API
644: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
646: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
647: RAISE OKL_API.G_EXCEPTION_ERROR;
648: END IF;

Line 645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

641: --- Validate all non-missing attributes (Item Level Validation)
642: l_return_status := Validate_Attributes(l_mstv_rec);
643: --- If any errors happen abort API
644: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
646: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
647: RAISE OKL_API.G_EXCEPTION_ERROR;
648: END IF;
649: l_return_status := Validate_Record(l_mstv_rec);

Line 646: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

642: l_return_status := Validate_Attributes(l_mstv_rec);
643: --- If any errors happen abort API
644: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
646: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
647: RAISE OKL_API.G_EXCEPTION_ERROR;
648: END IF;
649: l_return_status := Validate_Record(l_mstv_rec);
650: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 647: RAISE OKL_API.G_EXCEPTION_ERROR;

643: --- If any errors happen abort API
644: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
646: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
647: RAISE OKL_API.G_EXCEPTION_ERROR;
648: END IF;
649: l_return_status := Validate_Record(l_mstv_rec);
650: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 650: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

646: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
647: RAISE OKL_API.G_EXCEPTION_ERROR;
648: END IF;
649: l_return_status := Validate_Record(l_mstv_rec);
650: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
652: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
653: RAISE OKL_API.G_EXCEPTION_ERROR;
654: END IF;

Line 651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

647: RAISE OKL_API.G_EXCEPTION_ERROR;
648: END IF;
649: l_return_status := Validate_Record(l_mstv_rec);
650: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
652: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
653: RAISE OKL_API.G_EXCEPTION_ERROR;
654: END IF;
655: x_return_status := l_return_status;

Line 652: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

648: END IF;
649: l_return_status := Validate_Record(l_mstv_rec);
650: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
652: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
653: RAISE OKL_API.G_EXCEPTION_ERROR;
654: END IF;
655: x_return_status := l_return_status;
656: EXCEPTION

Line 653: RAISE OKL_API.G_EXCEPTION_ERROR;

649: l_return_status := Validate_Record(l_mstv_rec);
650: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
652: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
653: RAISE OKL_API.G_EXCEPTION_ERROR;
654: END IF;
655: x_return_status := l_return_status;
656: EXCEPTION
657: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 657: WHEN OKL_API.G_EXCEPTION_ERROR THEN

653: RAISE OKL_API.G_EXCEPTION_ERROR;
654: END IF;
655: x_return_status := l_return_status;
656: EXCEPTION
657: WHEN OKL_API.G_EXCEPTION_ERROR THEN
658: x_return_status := OKL_API.HANDLE_EXCEPTIONS
659: (
660: l_api_name,
661: G_PKG_NAME,

Line 658: x_return_status := OKL_API.HANDLE_EXCEPTIONS

654: END IF;
655: x_return_status := l_return_status;
656: EXCEPTION
657: WHEN OKL_API.G_EXCEPTION_ERROR THEN
658: x_return_status := OKL_API.HANDLE_EXCEPTIONS
659: (
660: l_api_name,
661: G_PKG_NAME,
662: 'OKL_API.G_RET_STS_ERROR',

Line 662: 'OKL_API.G_RET_STS_ERROR',

658: x_return_status := OKL_API.HANDLE_EXCEPTIONS
659: (
660: l_api_name,
661: G_PKG_NAME,
662: 'OKL_API.G_RET_STS_ERROR',
663: x_msg_count,
664: x_msg_data,
665: '_PVT'
666: );

Line 667: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

663: x_msg_count,
664: x_msg_data,
665: '_PVT'
666: );
667: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
668: x_return_status := OKL_API.HANDLE_EXCEPTIONS
669: (
670: l_api_name,
671: G_PKG_NAME,

Line 668: x_return_status := OKL_API.HANDLE_EXCEPTIONS

664: x_msg_data,
665: '_PVT'
666: );
667: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
668: x_return_status := OKL_API.HANDLE_EXCEPTIONS
669: (
670: l_api_name,
671: G_PKG_NAME,
672: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 672: 'OKL_API.G_RET_STS_UNEXP_ERROR',

668: x_return_status := OKL_API.HANDLE_EXCEPTIONS
669: (
670: l_api_name,
671: G_PKG_NAME,
672: 'OKL_API.G_RET_STS_UNEXP_ERROR',
673: x_msg_count,
674: x_msg_data,
675: '_PVT'
676: );

Line 678: x_return_status := OKL_API.HANDLE_EXCEPTIONS

674: x_msg_data,
675: '_PVT'
676: );
677: WHEN OTHERS THEN
678: x_return_status := OKL_API.HANDLE_EXCEPTIONS
679: (
680: l_api_name,
681: G_PKG_NAME,
682: 'OTHERS',

Line 702: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

698:
699: l_api_version CONSTANT NUMBER := 1;
700: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
701: i NUMBER := 0;
702: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
703: BEGIN
704: OKL_API.init_msg_list(p_init_msg_list);
705: -- Make sure PL/SQL table has records in it before passing
706: IF (p_mstv_tbl.COUNT > 0) THEN

Line 704: OKL_API.init_msg_list(p_init_msg_list);

700: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
701: i NUMBER := 0;
702: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
703: BEGIN
704: OKL_API.init_msg_list(p_init_msg_list);
705: -- Make sure PL/SQL table has records in it before passing
706: IF (p_mstv_tbl.COUNT > 0) THEN
707: i := p_mstv_tbl.FIRST;
708: LOOP

Line 711: p_init_msg_list => OKL_API.G_FALSE,

707: i := p_mstv_tbl.FIRST;
708: LOOP
709: validate_row (
710: p_api_version => p_api_version,
711: p_init_msg_list => OKL_API.G_FALSE,
712: x_return_status => x_return_status,
713: x_msg_count => x_msg_count,
714: x_msg_data => x_msg_data,
715: p_mstv_rec => p_mstv_tbl(i));

Line 717: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

713: x_msg_count => x_msg_count,
714: x_msg_data => x_msg_data,
715: p_mstv_rec => p_mstv_tbl(i));
716:
717: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
718: l_final_status := x_return_status;
719: END IF;
720:
721: EXIT WHEN (i = p_mstv_tbl.LAST);

Line 727: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

723: END LOOP;
724: END IF;
725:
726: x_return_status := l_final_status;
727: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
728:
729: EXCEPTION
730: WHEN OKL_API.G_EXCEPTION_ERROR THEN
731: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 730: WHEN OKL_API.G_EXCEPTION_ERROR THEN

726: x_return_status := l_final_status;
727: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
728:
729: EXCEPTION
730: WHEN OKL_API.G_EXCEPTION_ERROR THEN
731: x_return_status := OKL_API.HANDLE_EXCEPTIONS
732: (
733: l_api_name,
734: G_PKG_NAME,

Line 731: x_return_status := OKL_API.HANDLE_EXCEPTIONS

727: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
728:
729: EXCEPTION
730: WHEN OKL_API.G_EXCEPTION_ERROR THEN
731: x_return_status := OKL_API.HANDLE_EXCEPTIONS
732: (
733: l_api_name,
734: G_PKG_NAME,
735: 'OKL_API.G_RET_STS_ERROR',

Line 735: 'OKL_API.G_RET_STS_ERROR',

731: x_return_status := OKL_API.HANDLE_EXCEPTIONS
732: (
733: l_api_name,
734: G_PKG_NAME,
735: 'OKL_API.G_RET_STS_ERROR',
736: x_msg_count,
737: x_msg_data,
738: '_PVT'
739: );

Line 740: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

736: x_msg_count,
737: x_msg_data,
738: '_PVT'
739: );
740: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
741: x_return_status := OKL_API.HANDLE_EXCEPTIONS
742: (
743: l_api_name,
744: G_PKG_NAME,

Line 741: x_return_status := OKL_API.HANDLE_EXCEPTIONS

737: x_msg_data,
738: '_PVT'
739: );
740: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
741: x_return_status := OKL_API.HANDLE_EXCEPTIONS
742: (
743: l_api_name,
744: G_PKG_NAME,
745: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 745: 'OKL_API.G_RET_STS_UNEXP_ERROR',

741: x_return_status := OKL_API.HANDLE_EXCEPTIONS
742: (
743: l_api_name,
744: G_PKG_NAME,
745: 'OKL_API.G_RET_STS_UNEXP_ERROR',
746: x_msg_count,
747: x_msg_data,
748: '_PVT'
749: );

Line 751: x_return_status := OKL_API.HANDLE_EXCEPTIONS

747: x_msg_data,
748: '_PVT'
749: );
750: WHEN OTHERS THEN
751: x_return_status := OKL_API.HANDLE_EXCEPTIONS
752: (
753: l_api_name,
754: G_PKG_NAME,
755: 'OTHERS',

Line 769: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

765: ----------------------------------------------
766: -- insert_row for:OKL_RBK_SELECTED_CONTRACT --
767: ----------------------------------------------
768: PROCEDURE insert_row(
769: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
770: x_return_status OUT NOCOPY VARCHAR2,
771: x_msg_count OUT NOCOPY NUMBER,
772: x_msg_data OUT NOCOPY VARCHAR2,
773: p_mst_rec IN mst_rec_type,

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

774: x_mst_rec OUT NOCOPY mst_rec_type) IS
775:
776: l_api_version CONSTANT NUMBER := 1;
777: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
778: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
779: l_mst_rec mst_rec_type := p_mst_rec;
780: l_def_mst_rec mst_rec_type;
781: --------------------------------------------------
782: -- Set_Attributes for:OKL_RBK_SELECTED_CONTRACT --

Line 788: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

784: FUNCTION Set_Attributes (
785: p_mst_rec IN mst_rec_type,
786: x_mst_rec OUT NOCOPY mst_rec_type
787: ) RETURN VARCHAR2 IS
788: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
789: BEGIN
790: x_mst_rec := p_mst_rec;
791: RETURN(l_return_status);
792: END Set_Attributes;

Line 794: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

790: x_mst_rec := p_mst_rec;
791: RETURN(l_return_status);
792: END Set_Attributes;
793: BEGIN
794: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
795: p_init_msg_list,
796: '_PVT',
797: x_return_status);
798: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 798: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

794: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
795: p_init_msg_list,
796: '_PVT',
797: x_return_status);
798: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
799: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
800: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_ERROR;
802: END IF;

Line 799: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

795: p_init_msg_list,
796: '_PVT',
797: x_return_status);
798: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
799: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
800: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_ERROR;
802: END IF;
803: --- Setting item atributes

Line 800: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

796: '_PVT',
797: x_return_status);
798: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
799: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
800: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_ERROR;
802: END IF;
803: --- Setting item atributes
804: l_return_status := Set_Attributes(

Line 801: RAISE OKL_API.G_EXCEPTION_ERROR;

797: x_return_status);
798: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
799: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
800: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_ERROR;
802: END IF;
803: --- Setting item atributes
804: l_return_status := Set_Attributes(
805: p_mst_rec, -- IN

Line 808: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

804: l_return_status := Set_Attributes(
805: p_mst_rec, -- IN
806: l_mst_rec); -- OUT
807: --- If any errors happen abort API
808: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
810: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
811: RAISE OKL_API.G_EXCEPTION_ERROR;
812: END IF;

Line 809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

805: p_mst_rec, -- IN
806: l_mst_rec); -- OUT
807: --- If any errors happen abort API
808: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
810: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
811: RAISE OKL_API.G_EXCEPTION_ERROR;
812: END IF;
813: INSERT INTO OKL_RBK_SELECTED_CONTRACT(

Line 810: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

806: l_mst_rec); -- OUT
807: --- If any errors happen abort API
808: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
810: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
811: RAISE OKL_API.G_EXCEPTION_ERROR;
812: END IF;
813: INSERT INTO OKL_RBK_SELECTED_CONTRACT(
814: id,

Line 811: RAISE OKL_API.G_EXCEPTION_ERROR;

807: --- If any errors happen abort API
808: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
810: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
811: RAISE OKL_API.G_EXCEPTION_ERROR;
812: END IF;
813: INSERT INTO OKL_RBK_SELECTED_CONTRACT(
814: id,
815: request_name,

Line 880: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

876: l_mst_rec.transaction_date);
877: -- Set OUT values
878: x_mst_rec := l_mst_rec;
879: x_return_status := l_return_status;
880: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
881: EXCEPTION
882: WHEN OKL_API.G_EXCEPTION_ERROR THEN
883: x_return_status := OKL_API.HANDLE_EXCEPTIONS
884: (

Line 882: WHEN OKL_API.G_EXCEPTION_ERROR THEN

878: x_mst_rec := l_mst_rec;
879: x_return_status := l_return_status;
880: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
881: EXCEPTION
882: WHEN OKL_API.G_EXCEPTION_ERROR THEN
883: x_return_status := OKL_API.HANDLE_EXCEPTIONS
884: (
885: l_api_name,
886: G_PKG_NAME,

Line 883: x_return_status := OKL_API.HANDLE_EXCEPTIONS

879: x_return_status := l_return_status;
880: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
881: EXCEPTION
882: WHEN OKL_API.G_EXCEPTION_ERROR THEN
883: x_return_status := OKL_API.HANDLE_EXCEPTIONS
884: (
885: l_api_name,
886: G_PKG_NAME,
887: 'OKL_API.G_RET_STS_ERROR',

Line 887: 'OKL_API.G_RET_STS_ERROR',

883: x_return_status := OKL_API.HANDLE_EXCEPTIONS
884: (
885: l_api_name,
886: G_PKG_NAME,
887: 'OKL_API.G_RET_STS_ERROR',
888: x_msg_count,
889: x_msg_data,
890: '_PVT'
891: );

Line 892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

888: x_msg_count,
889: x_msg_data,
890: '_PVT'
891: );
892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
893: x_return_status := OKL_API.HANDLE_EXCEPTIONS
894: (
895: l_api_name,
896: G_PKG_NAME,

Line 893: x_return_status := OKL_API.HANDLE_EXCEPTIONS

889: x_msg_data,
890: '_PVT'
891: );
892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
893: x_return_status := OKL_API.HANDLE_EXCEPTIONS
894: (
895: l_api_name,
896: G_PKG_NAME,
897: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 897: 'OKL_API.G_RET_STS_UNEXP_ERROR',

893: x_return_status := OKL_API.HANDLE_EXCEPTIONS
894: (
895: l_api_name,
896: G_PKG_NAME,
897: 'OKL_API.G_RET_STS_UNEXP_ERROR',
898: x_msg_count,
899: x_msg_data,
900: '_PVT'
901: );

Line 903: x_return_status := OKL_API.HANDLE_EXCEPTIONS

899: x_msg_data,
900: '_PVT'
901: );
902: WHEN OTHERS THEN
903: x_return_status := OKL_API.HANDLE_EXCEPTIONS
904: (
905: l_api_name,
906: G_PKG_NAME,
907: 'OTHERS',

Line 927: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

923: x_mstv_rec OUT NOCOPY mstv_rec_type) IS
924:
925: l_api_version CONSTANT NUMBER := 1;
926: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
927: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
928: l_mstv_rec mstv_rec_type := p_mstv_rec;
929: l_def_mstv_rec mstv_rec_type;
930: l_mst_rec mst_rec_type;
931: lx_mst_rec mst_rec_type;

Line 954: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

950: FUNCTION Set_Attributes (
951: p_mstv_rec IN mstv_rec_type,
952: x_mstv_rec OUT NOCOPY mstv_rec_type
953: ) RETURN VARCHAR2 IS
954: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
955: BEGIN
956: x_mstv_rec := p_mstv_rec;
957: RETURN(l_return_status);
958: END Set_Attributes;

Line 960: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

956: x_mstv_rec := p_mstv_rec;
957: RETURN(l_return_status);
958: END Set_Attributes;
959: BEGIN
960: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
961: G_PKG_NAME,
962: p_init_msg_list,
963: l_api_version,
964: p_api_version,

Line 967: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

963: l_api_version,
964: p_api_version,
965: '_PVT',
966: x_return_status);
967: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
969: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
970: RAISE OKL_API.G_EXCEPTION_ERROR;
971: END IF;

Line 968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

964: p_api_version,
965: '_PVT',
966: x_return_status);
967: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
969: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
970: RAISE OKL_API.G_EXCEPTION_ERROR;
971: END IF;
972: l_mstv_rec := null_out_defaults(p_mstv_rec);

Line 969: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

965: '_PVT',
966: x_return_status);
967: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
969: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
970: RAISE OKL_API.G_EXCEPTION_ERROR;
971: END IF;
972: l_mstv_rec := null_out_defaults(p_mstv_rec);
973: -- Set primary key value

Line 970: RAISE OKL_API.G_EXCEPTION_ERROR;

966: x_return_status);
967: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
969: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
970: RAISE OKL_API.G_EXCEPTION_ERROR;
971: END IF;
972: l_mstv_rec := null_out_defaults(p_mstv_rec);
973: -- Set primary key value
974: l_mstv_rec.ID := get_seq_id;

Line 980: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

976: l_return_Status := Set_Attributes(
977: l_mstv_rec, -- IN
978: l_def_mstv_rec); -- OUT
979: --- If any errors happen abort API
980: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
982: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
983: RAISE OKL_API.G_EXCEPTION_ERROR;
984: END IF;

Line 981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

977: l_mstv_rec, -- IN
978: l_def_mstv_rec); -- OUT
979: --- If any errors happen abort API
980: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
982: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
983: RAISE OKL_API.G_EXCEPTION_ERROR;
984: END IF;
985: l_def_mstv_rec := fill_who_columns(l_def_mstv_rec);

Line 982: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

978: l_def_mstv_rec); -- OUT
979: --- If any errors happen abort API
980: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
982: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
983: RAISE OKL_API.G_EXCEPTION_ERROR;
984: END IF;
985: l_def_mstv_rec := fill_who_columns(l_def_mstv_rec);
986: --- Validate all non-missing attributes (Item Level Validation)

Line 983: RAISE OKL_API.G_EXCEPTION_ERROR;

979: --- If any errors happen abort API
980: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
982: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
983: RAISE OKL_API.G_EXCEPTION_ERROR;
984: END IF;
985: l_def_mstv_rec := fill_who_columns(l_def_mstv_rec);
986: --- Validate all non-missing attributes (Item Level Validation)
987: l_return_status := Validate_Attributes(l_def_mstv_rec);

Line 989: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

985: l_def_mstv_rec := fill_who_columns(l_def_mstv_rec);
986: --- Validate all non-missing attributes (Item Level Validation)
987: l_return_status := Validate_Attributes(l_def_mstv_rec);
988: --- If any errors happen abort API
989: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
991: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
992: RAISE OKL_API.G_EXCEPTION_ERROR;
993: END IF;

Line 990: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

986: --- Validate all non-missing attributes (Item Level Validation)
987: l_return_status := Validate_Attributes(l_def_mstv_rec);
988: --- If any errors happen abort API
989: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
991: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
992: RAISE OKL_API.G_EXCEPTION_ERROR;
993: END IF;
994: l_return_status := Validate_Record(l_def_mstv_rec);

Line 991: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

987: l_return_status := Validate_Attributes(l_def_mstv_rec);
988: --- If any errors happen abort API
989: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
991: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
992: RAISE OKL_API.G_EXCEPTION_ERROR;
993: END IF;
994: l_return_status := Validate_Record(l_def_mstv_rec);
995: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 992: RAISE OKL_API.G_EXCEPTION_ERROR;

988: --- If any errors happen abort API
989: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
991: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
992: RAISE OKL_API.G_EXCEPTION_ERROR;
993: END IF;
994: l_return_status := Validate_Record(l_def_mstv_rec);
995: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 995: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

991: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
992: RAISE OKL_API.G_EXCEPTION_ERROR;
993: END IF;
994: l_return_status := Validate_Record(l_def_mstv_rec);
995: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
998: RAISE OKL_API.G_EXCEPTION_ERROR;
999: END IF;

Line 996: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

992: RAISE OKL_API.G_EXCEPTION_ERROR;
993: END IF;
994: l_return_status := Validate_Record(l_def_mstv_rec);
995: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
998: RAISE OKL_API.G_EXCEPTION_ERROR;
999: END IF;
1000: -----------------------------------------

Line 997: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

993: END IF;
994: l_return_status := Validate_Record(l_def_mstv_rec);
995: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
998: RAISE OKL_API.G_EXCEPTION_ERROR;
999: END IF;
1000: -----------------------------------------
1001: -- Move VIEW record to "Child" records --

Line 998: RAISE OKL_API.G_EXCEPTION_ERROR;

994: l_return_status := Validate_Record(l_def_mstv_rec);
995: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
998: RAISE OKL_API.G_EXCEPTION_ERROR;
999: END IF;
1000: -----------------------------------------
1001: -- Move VIEW record to "Child" records --
1002: -----------------------------------------

Line 1015: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1011: x_msg_data,
1012: l_mst_rec,
1013: lx_mst_rec
1014: );
1015: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1016: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1017: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1018: RAISE OKL_API.G_EXCEPTION_ERROR;
1019: END IF;

Line 1016: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1012: l_mst_rec,
1013: lx_mst_rec
1014: );
1015: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1016: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1017: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1018: RAISE OKL_API.G_EXCEPTION_ERROR;
1019: END IF;
1020: migrate(lx_mst_rec, l_def_mstv_rec);

Line 1017: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1013: lx_mst_rec
1014: );
1015: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1016: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1017: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1018: RAISE OKL_API.G_EXCEPTION_ERROR;
1019: END IF;
1020: migrate(lx_mst_rec, l_def_mstv_rec);
1021: -- Set OUT values

Line 1018: RAISE OKL_API.G_EXCEPTION_ERROR;

1014: );
1015: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1016: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1017: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1018: RAISE OKL_API.G_EXCEPTION_ERROR;
1019: END IF;
1020: migrate(lx_mst_rec, l_def_mstv_rec);
1021: -- Set OUT values
1022: x_mstv_rec := l_def_mstv_rec;

Line 1024: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1020: migrate(lx_mst_rec, l_def_mstv_rec);
1021: -- Set OUT values
1022: x_mstv_rec := l_def_mstv_rec;
1023: x_return_status := l_return_status;
1024: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1025: EXCEPTION
1026: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1028: (

Line 1026: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1022: x_mstv_rec := l_def_mstv_rec;
1023: x_return_status := l_return_status;
1024: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1025: EXCEPTION
1026: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1028: (
1029: l_api_name,
1030: G_PKG_NAME,

Line 1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1023: x_return_status := l_return_status;
1024: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1025: EXCEPTION
1026: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1028: (
1029: l_api_name,
1030: G_PKG_NAME,
1031: 'OKL_API.G_RET_STS_ERROR',

Line 1031: 'OKL_API.G_RET_STS_ERROR',

1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1028: (
1029: l_api_name,
1030: G_PKG_NAME,
1031: 'OKL_API.G_RET_STS_ERROR',
1032: x_msg_count,
1033: x_msg_data,
1034: '_PVT'
1035: );

Line 1036: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1032: x_msg_count,
1033: x_msg_data,
1034: '_PVT'
1035: );
1036: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1037: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1038: (
1039: l_api_name,
1040: G_PKG_NAME,

Line 1037: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1033: x_msg_data,
1034: '_PVT'
1035: );
1036: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1037: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1038: (
1039: l_api_name,
1040: G_PKG_NAME,
1041: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1041: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1037: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1038: (
1039: l_api_name,
1040: G_PKG_NAME,
1041: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1042: x_msg_count,
1043: x_msg_data,
1044: '_PVT'
1045: );

Line 1047: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1043: x_msg_data,
1044: '_PVT'
1045: );
1046: WHEN OTHERS THEN
1047: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1048: (
1049: l_api_name,
1050: G_PKG_NAME,
1051: 'OTHERS',

Line 1072: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1068:
1069: l_api_version CONSTANT NUMBER := 1;
1070: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1071: i NUMBER := 0;
1072: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1073: BEGIN
1074: OKL_API.init_msg_list(p_init_msg_list);
1075: -- Make sure PL/SQL table has records in it before passing
1076: IF (p_mstv_tbl.COUNT > 0) THEN

Line 1074: OKL_API.init_msg_list(p_init_msg_list);

1070: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1071: i NUMBER := 0;
1072: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1073: BEGIN
1074: OKL_API.init_msg_list(p_init_msg_list);
1075: -- Make sure PL/SQL table has records in it before passing
1076: IF (p_mstv_tbl.COUNT > 0) THEN
1077: i := p_mstv_tbl.FIRST;
1078: LOOP

Line 1081: p_init_msg_list => OKL_API.G_FALSE,

1077: i := p_mstv_tbl.FIRST;
1078: LOOP
1079: insert_row (
1080: p_api_version => p_api_version,
1081: p_init_msg_list => OKL_API.G_FALSE,
1082: x_return_status => x_return_status,
1083: x_msg_count => x_msg_count,
1084: x_msg_data => x_msg_data,
1085: p_mstv_rec => p_mstv_tbl(i),

Line 1088: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

1084: x_msg_data => x_msg_data,
1085: p_mstv_rec => p_mstv_tbl(i),
1086: x_mstv_rec => x_mstv_tbl(i));
1087:
1088: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1089: l_final_status := x_return_status;
1090: END IF;
1091:
1092: EXIT WHEN (i = p_mstv_tbl.LAST);

Line 1098: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1094: END LOOP;
1095: END IF;
1096:
1097: x_return_status := l_final_status;
1098: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1099:
1100: EXCEPTION
1101: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1102: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 1101: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1097: x_return_status := l_final_status;
1098: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1099:
1100: EXCEPTION
1101: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1102: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1103: (
1104: l_api_name,
1105: G_PKG_NAME,

Line 1102: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1098: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1099:
1100: EXCEPTION
1101: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1102: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1103: (
1104: l_api_name,
1105: G_PKG_NAME,
1106: 'OKL_API.G_RET_STS_ERROR',

Line 1106: 'OKL_API.G_RET_STS_ERROR',

1102: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1103: (
1104: l_api_name,
1105: G_PKG_NAME,
1106: 'OKL_API.G_RET_STS_ERROR',
1107: x_msg_count,
1108: x_msg_data,
1109: '_PVT'
1110: );

Line 1111: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1107: x_msg_count,
1108: x_msg_data,
1109: '_PVT'
1110: );
1111: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1112: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1113: (
1114: l_api_name,
1115: G_PKG_NAME,

Line 1112: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1108: x_msg_data,
1109: '_PVT'
1110: );
1111: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1112: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1113: (
1114: l_api_name,
1115: G_PKG_NAME,
1116: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1116: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1112: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1113: (
1114: l_api_name,
1115: G_PKG_NAME,
1116: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1117: x_msg_count,
1118: x_msg_data,
1119: '_PVT'
1120: );

Line 1122: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1118: x_msg_data,
1119: '_PVT'
1120: );
1121: WHEN OTHERS THEN
1122: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1123: (
1124: l_api_name,
1125: G_PKG_NAME,
1126: 'OTHERS',

Line 1140: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1136: --------------------------------------------
1137: -- lock_row for:OKL_RBK_SELECTED_CONTRACT --
1138: --------------------------------------------
1139: PROCEDURE lock_row(
1140: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1141: x_return_status OUT NOCOPY VARCHAR2,
1142: x_msg_count OUT NOCOPY NUMBER,
1143: x_msg_data OUT NOCOPY VARCHAR2,
1144: p_mst_rec IN mst_rec_type) IS

Line 1156: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1152: FOR UPDATE NOWAIT;
1153:
1154: l_api_version CONSTANT NUMBER := 1;
1155: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1156: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1157: l_lock_var lock_csr%ROWTYPE;
1158: l_row_notfound BOOLEAN := FALSE;
1159: lc_row_notfound BOOLEAN := FALSE;
1160: BEGIN

Line 1161: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1157: l_lock_var lock_csr%ROWTYPE;
1158: l_row_notfound BOOLEAN := FALSE;
1159: lc_row_notfound BOOLEAN := FALSE;
1160: BEGIN
1161: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1162: p_init_msg_list,
1163: '_PVT',
1164: x_return_status);
1165: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1165: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1161: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1162: p_init_msg_list,
1163: '_PVT',
1164: x_return_status);
1165: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1167: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1168: RAISE OKL_API.G_EXCEPTION_ERROR;
1169: END IF;

Line 1166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1162: p_init_msg_list,
1163: '_PVT',
1164: x_return_status);
1165: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1167: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1168: RAISE OKL_API.G_EXCEPTION_ERROR;
1169: END IF;
1170: BEGIN

Line 1167: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1163: '_PVT',
1164: x_return_status);
1165: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1167: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1168: RAISE OKL_API.G_EXCEPTION_ERROR;
1169: END IF;
1170: BEGIN
1171: OPEN lock_csr(p_mst_rec);

Line 1168: RAISE OKL_API.G_EXCEPTION_ERROR;

1164: x_return_status);
1165: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1167: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1168: RAISE OKL_API.G_EXCEPTION_ERROR;
1169: END IF;
1170: BEGIN
1171: OPEN lock_csr(p_mst_rec);
1172: FETCH lock_csr INTO l_lock_var;

Line 1180: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1176: WHEN E_Resource_Busy THEN
1177: IF (lock_csr%ISOPEN) THEN
1178: CLOSE lock_csr;
1179: END IF;
1180: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1181: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1182: END;
1183:
1184: IF ( l_row_notfound ) THEN

Line 1185: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1181: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1182: END;
1183:
1184: IF ( l_row_notfound ) THEN
1185: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1186: RAISE OKL_API.G_EXCEPTION_ERROR;
1187: ELSE
1188: IF (l_lock_var.id <> p_mst_rec.id) THEN
1189: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1186: RAISE OKL_API.G_EXCEPTION_ERROR;

1182: END;
1183:
1184: IF ( l_row_notfound ) THEN
1185: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1186: RAISE OKL_API.G_EXCEPTION_ERROR;
1187: ELSE
1188: IF (l_lock_var.id <> p_mst_rec.id) THEN
1189: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1190: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1189: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1185: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1186: RAISE OKL_API.G_EXCEPTION_ERROR;
1187: ELSE
1188: IF (l_lock_var.id <> p_mst_rec.id) THEN
1189: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1190: RAISE OKL_API.G_EXCEPTION_ERROR;
1191: END IF;
1192: IF (l_lock_var.request_name <> p_mst_rec.request_name) THEN
1193: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1190: RAISE OKL_API.G_EXCEPTION_ERROR;

1186: RAISE OKL_API.G_EXCEPTION_ERROR;
1187: ELSE
1188: IF (l_lock_var.id <> p_mst_rec.id) THEN
1189: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1190: RAISE OKL_API.G_EXCEPTION_ERROR;
1191: END IF;
1192: IF (l_lock_var.request_name <> p_mst_rec.request_name) THEN
1193: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1194: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1193: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1189: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1190: RAISE OKL_API.G_EXCEPTION_ERROR;
1191: END IF;
1192: IF (l_lock_var.request_name <> p_mst_rec.request_name) THEN
1193: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1194: RAISE OKL_API.G_EXCEPTION_ERROR;
1195: END IF;
1196: IF (l_lock_var.khr_id <> p_mst_rec.khr_id) THEN
1197: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1194: RAISE OKL_API.G_EXCEPTION_ERROR;

1190: RAISE OKL_API.G_EXCEPTION_ERROR;
1191: END IF;
1192: IF (l_lock_var.request_name <> p_mst_rec.request_name) THEN
1193: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1194: RAISE OKL_API.G_EXCEPTION_ERROR;
1195: END IF;
1196: IF (l_lock_var.khr_id <> p_mst_rec.khr_id) THEN
1197: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1198: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1197: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1193: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1194: RAISE OKL_API.G_EXCEPTION_ERROR;
1195: END IF;
1196: IF (l_lock_var.khr_id <> p_mst_rec.khr_id) THEN
1197: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1198: RAISE OKL_API.G_EXCEPTION_ERROR;
1199: END IF;
1200: IF (l_lock_var.contract_number <> p_mst_rec.contract_number) THEN
1201: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1198: RAISE OKL_API.G_EXCEPTION_ERROR;

1194: RAISE OKL_API.G_EXCEPTION_ERROR;
1195: END IF;
1196: IF (l_lock_var.khr_id <> p_mst_rec.khr_id) THEN
1197: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1198: RAISE OKL_API.G_EXCEPTION_ERROR;
1199: END IF;
1200: IF (l_lock_var.contract_number <> p_mst_rec.contract_number) THEN
1201: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1202: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1201: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1197: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1198: RAISE OKL_API.G_EXCEPTION_ERROR;
1199: END IF;
1200: IF (l_lock_var.contract_number <> p_mst_rec.contract_number) THEN
1201: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1202: RAISE OKL_API.G_EXCEPTION_ERROR;
1203: END IF;
1204: IF (l_lock_var.contract_description <> p_mst_rec.contract_description) THEN
1205: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1202: RAISE OKL_API.G_EXCEPTION_ERROR;

1198: RAISE OKL_API.G_EXCEPTION_ERROR;
1199: END IF;
1200: IF (l_lock_var.contract_number <> p_mst_rec.contract_number) THEN
1201: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1202: RAISE OKL_API.G_EXCEPTION_ERROR;
1203: END IF;
1204: IF (l_lock_var.contract_description <> p_mst_rec.contract_description) THEN
1205: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1206: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1205: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1201: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1202: RAISE OKL_API.G_EXCEPTION_ERROR;
1203: END IF;
1204: IF (l_lock_var.contract_description <> p_mst_rec.contract_description) THEN
1205: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1206: RAISE OKL_API.G_EXCEPTION_ERROR;
1207: END IF;
1208: IF (l_lock_var.kle_id <> p_mst_rec.kle_id) THEN
1209: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1206: RAISE OKL_API.G_EXCEPTION_ERROR;

1202: RAISE OKL_API.G_EXCEPTION_ERROR;
1203: END IF;
1204: IF (l_lock_var.contract_description <> p_mst_rec.contract_description) THEN
1205: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1206: RAISE OKL_API.G_EXCEPTION_ERROR;
1207: END IF;
1208: IF (l_lock_var.kle_id <> p_mst_rec.kle_id) THEN
1209: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1210: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1209: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1205: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1206: RAISE OKL_API.G_EXCEPTION_ERROR;
1207: END IF;
1208: IF (l_lock_var.kle_id <> p_mst_rec.kle_id) THEN
1209: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1210: RAISE OKL_API.G_EXCEPTION_ERROR;
1211: END IF;
1212: IF (l_lock_var.transaction_id <> p_mst_rec.transaction_id) THEN
1213: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1210: RAISE OKL_API.G_EXCEPTION_ERROR;

1206: RAISE OKL_API.G_EXCEPTION_ERROR;
1207: END IF;
1208: IF (l_lock_var.kle_id <> p_mst_rec.kle_id) THEN
1209: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1210: RAISE OKL_API.G_EXCEPTION_ERROR;
1211: END IF;
1212: IF (l_lock_var.transaction_id <> p_mst_rec.transaction_id) THEN
1213: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1214: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1213: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1209: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1210: RAISE OKL_API.G_EXCEPTION_ERROR;
1211: END IF;
1212: IF (l_lock_var.transaction_id <> p_mst_rec.transaction_id) THEN
1213: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1214: RAISE OKL_API.G_EXCEPTION_ERROR;
1215: END IF;
1216: IF (l_lock_var.selected_flag <> p_mst_rec.selected_flag) THEN
1217: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1214: RAISE OKL_API.G_EXCEPTION_ERROR;

1210: RAISE OKL_API.G_EXCEPTION_ERROR;
1211: END IF;
1212: IF (l_lock_var.transaction_id <> p_mst_rec.transaction_id) THEN
1213: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1214: RAISE OKL_API.G_EXCEPTION_ERROR;
1215: END IF;
1216: IF (l_lock_var.selected_flag <> p_mst_rec.selected_flag) THEN
1217: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1218: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1217: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1213: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1214: RAISE OKL_API.G_EXCEPTION_ERROR;
1215: END IF;
1216: IF (l_lock_var.selected_flag <> p_mst_rec.selected_flag) THEN
1217: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1218: RAISE OKL_API.G_EXCEPTION_ERROR;
1219: END IF;
1220: IF (l_lock_var.status <> p_mst_rec.status) THEN
1221: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1218: RAISE OKL_API.G_EXCEPTION_ERROR;

1214: RAISE OKL_API.G_EXCEPTION_ERROR;
1215: END IF;
1216: IF (l_lock_var.selected_flag <> p_mst_rec.selected_flag) THEN
1217: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1218: RAISE OKL_API.G_EXCEPTION_ERROR;
1219: END IF;
1220: IF (l_lock_var.status <> p_mst_rec.status) THEN
1221: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1222: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1221: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1217: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1218: RAISE OKL_API.G_EXCEPTION_ERROR;
1219: END IF;
1220: IF (l_lock_var.status <> p_mst_rec.status) THEN
1221: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1222: RAISE OKL_API.G_EXCEPTION_ERROR;
1223: END IF;
1224: IF (l_lock_var.attribute_category <> p_mst_rec.attribute_category) THEN
1225: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1222: RAISE OKL_API.G_EXCEPTION_ERROR;

1218: RAISE OKL_API.G_EXCEPTION_ERROR;
1219: END IF;
1220: IF (l_lock_var.status <> p_mst_rec.status) THEN
1221: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1222: RAISE OKL_API.G_EXCEPTION_ERROR;
1223: END IF;
1224: IF (l_lock_var.attribute_category <> p_mst_rec.attribute_category) THEN
1225: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1226: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1225: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1221: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1222: RAISE OKL_API.G_EXCEPTION_ERROR;
1223: END IF;
1224: IF (l_lock_var.attribute_category <> p_mst_rec.attribute_category) THEN
1225: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1226: RAISE OKL_API.G_EXCEPTION_ERROR;
1227: END IF;
1228: IF (l_lock_var.attribute1 <> p_mst_rec.attribute1) THEN
1229: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1226: RAISE OKL_API.G_EXCEPTION_ERROR;

1222: RAISE OKL_API.G_EXCEPTION_ERROR;
1223: END IF;
1224: IF (l_lock_var.attribute_category <> p_mst_rec.attribute_category) THEN
1225: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1226: RAISE OKL_API.G_EXCEPTION_ERROR;
1227: END IF;
1228: IF (l_lock_var.attribute1 <> p_mst_rec.attribute1) THEN
1229: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1230: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1229: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1225: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1226: RAISE OKL_API.G_EXCEPTION_ERROR;
1227: END IF;
1228: IF (l_lock_var.attribute1 <> p_mst_rec.attribute1) THEN
1229: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1230: RAISE OKL_API.G_EXCEPTION_ERROR;
1231: END IF;
1232: IF (l_lock_var.attribute2 <> p_mst_rec.attribute2) THEN
1233: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1230: RAISE OKL_API.G_EXCEPTION_ERROR;

1226: RAISE OKL_API.G_EXCEPTION_ERROR;
1227: END IF;
1228: IF (l_lock_var.attribute1 <> p_mst_rec.attribute1) THEN
1229: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1230: RAISE OKL_API.G_EXCEPTION_ERROR;
1231: END IF;
1232: IF (l_lock_var.attribute2 <> p_mst_rec.attribute2) THEN
1233: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1234: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1233: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1229: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1230: RAISE OKL_API.G_EXCEPTION_ERROR;
1231: END IF;
1232: IF (l_lock_var.attribute2 <> p_mst_rec.attribute2) THEN
1233: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1234: RAISE OKL_API.G_EXCEPTION_ERROR;
1235: END IF;
1236: IF (l_lock_var.attribute3 <> p_mst_rec.attribute3) THEN
1237: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1234: RAISE OKL_API.G_EXCEPTION_ERROR;

1230: RAISE OKL_API.G_EXCEPTION_ERROR;
1231: END IF;
1232: IF (l_lock_var.attribute2 <> p_mst_rec.attribute2) THEN
1233: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1234: RAISE OKL_API.G_EXCEPTION_ERROR;
1235: END IF;
1236: IF (l_lock_var.attribute3 <> p_mst_rec.attribute3) THEN
1237: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1238: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1237: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1233: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1234: RAISE OKL_API.G_EXCEPTION_ERROR;
1235: END IF;
1236: IF (l_lock_var.attribute3 <> p_mst_rec.attribute3) THEN
1237: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1238: RAISE OKL_API.G_EXCEPTION_ERROR;
1239: END IF;
1240: IF (l_lock_var.attribute4 <> p_mst_rec.attribute4) THEN
1241: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1238: RAISE OKL_API.G_EXCEPTION_ERROR;

1234: RAISE OKL_API.G_EXCEPTION_ERROR;
1235: END IF;
1236: IF (l_lock_var.attribute3 <> p_mst_rec.attribute3) THEN
1237: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1238: RAISE OKL_API.G_EXCEPTION_ERROR;
1239: END IF;
1240: IF (l_lock_var.attribute4 <> p_mst_rec.attribute4) THEN
1241: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1242: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1241: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1237: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1238: RAISE OKL_API.G_EXCEPTION_ERROR;
1239: END IF;
1240: IF (l_lock_var.attribute4 <> p_mst_rec.attribute4) THEN
1241: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1242: RAISE OKL_API.G_EXCEPTION_ERROR;
1243: END IF;
1244: IF (l_lock_var.attribute5 <> p_mst_rec.attribute5) THEN
1245: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1242: RAISE OKL_API.G_EXCEPTION_ERROR;

1238: RAISE OKL_API.G_EXCEPTION_ERROR;
1239: END IF;
1240: IF (l_lock_var.attribute4 <> p_mst_rec.attribute4) THEN
1241: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1242: RAISE OKL_API.G_EXCEPTION_ERROR;
1243: END IF;
1244: IF (l_lock_var.attribute5 <> p_mst_rec.attribute5) THEN
1245: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1246: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1245: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1241: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1242: RAISE OKL_API.G_EXCEPTION_ERROR;
1243: END IF;
1244: IF (l_lock_var.attribute5 <> p_mst_rec.attribute5) THEN
1245: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;
1248: IF (l_lock_var.attribute6 <> p_mst_rec.attribute6) THEN
1249: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1246: RAISE OKL_API.G_EXCEPTION_ERROR;

1242: RAISE OKL_API.G_EXCEPTION_ERROR;
1243: END IF;
1244: IF (l_lock_var.attribute5 <> p_mst_rec.attribute5) THEN
1245: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;
1248: IF (l_lock_var.attribute6 <> p_mst_rec.attribute6) THEN
1249: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1250: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1249: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1245: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;
1248: IF (l_lock_var.attribute6 <> p_mst_rec.attribute6) THEN
1249: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1250: RAISE OKL_API.G_EXCEPTION_ERROR;
1251: END IF;
1252: IF (l_lock_var.attribute7 <> p_mst_rec.attribute7) THEN
1253: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1250: RAISE OKL_API.G_EXCEPTION_ERROR;

1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;
1248: IF (l_lock_var.attribute6 <> p_mst_rec.attribute6) THEN
1249: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1250: RAISE OKL_API.G_EXCEPTION_ERROR;
1251: END IF;
1252: IF (l_lock_var.attribute7 <> p_mst_rec.attribute7) THEN
1253: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1254: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1253: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1249: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1250: RAISE OKL_API.G_EXCEPTION_ERROR;
1251: END IF;
1252: IF (l_lock_var.attribute7 <> p_mst_rec.attribute7) THEN
1253: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: END IF;
1256: IF (l_lock_var.attribute8 <> p_mst_rec.attribute8) THEN
1257: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1254: RAISE OKL_API.G_EXCEPTION_ERROR;

1250: RAISE OKL_API.G_EXCEPTION_ERROR;
1251: END IF;
1252: IF (l_lock_var.attribute7 <> p_mst_rec.attribute7) THEN
1253: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: END IF;
1256: IF (l_lock_var.attribute8 <> p_mst_rec.attribute8) THEN
1257: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1258: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1257: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1253: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: END IF;
1256: IF (l_lock_var.attribute8 <> p_mst_rec.attribute8) THEN
1257: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1258: RAISE OKL_API.G_EXCEPTION_ERROR;
1259: END IF;
1260: IF (l_lock_var.attribute9 <> p_mst_rec.attribute9) THEN
1261: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1258: RAISE OKL_API.G_EXCEPTION_ERROR;

1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: END IF;
1256: IF (l_lock_var.attribute8 <> p_mst_rec.attribute8) THEN
1257: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1258: RAISE OKL_API.G_EXCEPTION_ERROR;
1259: END IF;
1260: IF (l_lock_var.attribute9 <> p_mst_rec.attribute9) THEN
1261: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1262: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1261: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1257: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1258: RAISE OKL_API.G_EXCEPTION_ERROR;
1259: END IF;
1260: IF (l_lock_var.attribute9 <> p_mst_rec.attribute9) THEN
1261: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1262: RAISE OKL_API.G_EXCEPTION_ERROR;
1263: END IF;
1264: IF (l_lock_var.attribute10 <> p_mst_rec.attribute10) THEN
1265: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1262: RAISE OKL_API.G_EXCEPTION_ERROR;

1258: RAISE OKL_API.G_EXCEPTION_ERROR;
1259: END IF;
1260: IF (l_lock_var.attribute9 <> p_mst_rec.attribute9) THEN
1261: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1262: RAISE OKL_API.G_EXCEPTION_ERROR;
1263: END IF;
1264: IF (l_lock_var.attribute10 <> p_mst_rec.attribute10) THEN
1265: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1266: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1265: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1261: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1262: RAISE OKL_API.G_EXCEPTION_ERROR;
1263: END IF;
1264: IF (l_lock_var.attribute10 <> p_mst_rec.attribute10) THEN
1265: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1266: RAISE OKL_API.G_EXCEPTION_ERROR;
1267: END IF;
1268: IF (l_lock_var.attribute11 <> p_mst_rec.attribute11) THEN
1269: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1266: RAISE OKL_API.G_EXCEPTION_ERROR;

1262: RAISE OKL_API.G_EXCEPTION_ERROR;
1263: END IF;
1264: IF (l_lock_var.attribute10 <> p_mst_rec.attribute10) THEN
1265: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1266: RAISE OKL_API.G_EXCEPTION_ERROR;
1267: END IF;
1268: IF (l_lock_var.attribute11 <> p_mst_rec.attribute11) THEN
1269: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1270: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1269: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1265: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1266: RAISE OKL_API.G_EXCEPTION_ERROR;
1267: END IF;
1268: IF (l_lock_var.attribute11 <> p_mst_rec.attribute11) THEN
1269: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1270: RAISE OKL_API.G_EXCEPTION_ERROR;
1271: END IF;
1272: IF (l_lock_var.attribute12 <> p_mst_rec.attribute12) THEN
1273: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1270: RAISE OKL_API.G_EXCEPTION_ERROR;

1266: RAISE OKL_API.G_EXCEPTION_ERROR;
1267: END IF;
1268: IF (l_lock_var.attribute11 <> p_mst_rec.attribute11) THEN
1269: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1270: RAISE OKL_API.G_EXCEPTION_ERROR;
1271: END IF;
1272: IF (l_lock_var.attribute12 <> p_mst_rec.attribute12) THEN
1273: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1274: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1273: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1269: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1270: RAISE OKL_API.G_EXCEPTION_ERROR;
1271: END IF;
1272: IF (l_lock_var.attribute12 <> p_mst_rec.attribute12) THEN
1273: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1274: RAISE OKL_API.G_EXCEPTION_ERROR;
1275: END IF;
1276: IF (l_lock_var.attribute13 <> p_mst_rec.attribute13) THEN
1277: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1274: RAISE OKL_API.G_EXCEPTION_ERROR;

1270: RAISE OKL_API.G_EXCEPTION_ERROR;
1271: END IF;
1272: IF (l_lock_var.attribute12 <> p_mst_rec.attribute12) THEN
1273: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1274: RAISE OKL_API.G_EXCEPTION_ERROR;
1275: END IF;
1276: IF (l_lock_var.attribute13 <> p_mst_rec.attribute13) THEN
1277: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1278: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1277: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1273: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1274: RAISE OKL_API.G_EXCEPTION_ERROR;
1275: END IF;
1276: IF (l_lock_var.attribute13 <> p_mst_rec.attribute13) THEN
1277: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1278: RAISE OKL_API.G_EXCEPTION_ERROR;
1279: END IF;
1280: IF (l_lock_var.attribute14 <> p_mst_rec.attribute14) THEN
1281: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1278: RAISE OKL_API.G_EXCEPTION_ERROR;

1274: RAISE OKL_API.G_EXCEPTION_ERROR;
1275: END IF;
1276: IF (l_lock_var.attribute13 <> p_mst_rec.attribute13) THEN
1277: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1278: RAISE OKL_API.G_EXCEPTION_ERROR;
1279: END IF;
1280: IF (l_lock_var.attribute14 <> p_mst_rec.attribute14) THEN
1281: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1282: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1281: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1277: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1278: RAISE OKL_API.G_EXCEPTION_ERROR;
1279: END IF;
1280: IF (l_lock_var.attribute14 <> p_mst_rec.attribute14) THEN
1281: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1282: RAISE OKL_API.G_EXCEPTION_ERROR;
1283: END IF;
1284: IF (l_lock_var.attribute15 <> p_mst_rec.attribute15) THEN
1285: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1282: RAISE OKL_API.G_EXCEPTION_ERROR;

1278: RAISE OKL_API.G_EXCEPTION_ERROR;
1279: END IF;
1280: IF (l_lock_var.attribute14 <> p_mst_rec.attribute14) THEN
1281: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1282: RAISE OKL_API.G_EXCEPTION_ERROR;
1283: END IF;
1284: IF (l_lock_var.attribute15 <> p_mst_rec.attribute15) THEN
1285: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1286: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1285: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1281: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1282: RAISE OKL_API.G_EXCEPTION_ERROR;
1283: END IF;
1284: IF (l_lock_var.attribute15 <> p_mst_rec.attribute15) THEN
1285: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1286: RAISE OKL_API.G_EXCEPTION_ERROR;
1287: END IF;
1288: IF (l_lock_var.created_by <> p_mst_rec.created_by) THEN
1289: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1286: RAISE OKL_API.G_EXCEPTION_ERROR;

1282: RAISE OKL_API.G_EXCEPTION_ERROR;
1283: END IF;
1284: IF (l_lock_var.attribute15 <> p_mst_rec.attribute15) THEN
1285: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1286: RAISE OKL_API.G_EXCEPTION_ERROR;
1287: END IF;
1288: IF (l_lock_var.created_by <> p_mst_rec.created_by) THEN
1289: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1290: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1289: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1285: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1286: RAISE OKL_API.G_EXCEPTION_ERROR;
1287: END IF;
1288: IF (l_lock_var.created_by <> p_mst_rec.created_by) THEN
1289: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1290: RAISE OKL_API.G_EXCEPTION_ERROR;
1291: END IF;
1292: IF (l_lock_var.creation_date <> p_mst_rec.creation_date) THEN
1293: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1290: RAISE OKL_API.G_EXCEPTION_ERROR;

1286: RAISE OKL_API.G_EXCEPTION_ERROR;
1287: END IF;
1288: IF (l_lock_var.created_by <> p_mst_rec.created_by) THEN
1289: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1290: RAISE OKL_API.G_EXCEPTION_ERROR;
1291: END IF;
1292: IF (l_lock_var.creation_date <> p_mst_rec.creation_date) THEN
1293: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1294: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1293: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1289: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1290: RAISE OKL_API.G_EXCEPTION_ERROR;
1291: END IF;
1292: IF (l_lock_var.creation_date <> p_mst_rec.creation_date) THEN
1293: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1294: RAISE OKL_API.G_EXCEPTION_ERROR;
1295: END IF;
1296: IF (l_lock_var.last_updated_by <> p_mst_rec.last_updated_by) THEN
1297: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1294: RAISE OKL_API.G_EXCEPTION_ERROR;

1290: RAISE OKL_API.G_EXCEPTION_ERROR;
1291: END IF;
1292: IF (l_lock_var.creation_date <> p_mst_rec.creation_date) THEN
1293: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1294: RAISE OKL_API.G_EXCEPTION_ERROR;
1295: END IF;
1296: IF (l_lock_var.last_updated_by <> p_mst_rec.last_updated_by) THEN
1297: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1298: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1297: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1293: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1294: RAISE OKL_API.G_EXCEPTION_ERROR;
1295: END IF;
1296: IF (l_lock_var.last_updated_by <> p_mst_rec.last_updated_by) THEN
1297: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1298: RAISE OKL_API.G_EXCEPTION_ERROR;
1299: END IF;
1300: IF (l_lock_var.last_update_date <> p_mst_rec.last_update_date) THEN
1301: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1298: RAISE OKL_API.G_EXCEPTION_ERROR;

1294: RAISE OKL_API.G_EXCEPTION_ERROR;
1295: END IF;
1296: IF (l_lock_var.last_updated_by <> p_mst_rec.last_updated_by) THEN
1297: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1298: RAISE OKL_API.G_EXCEPTION_ERROR;
1299: END IF;
1300: IF (l_lock_var.last_update_date <> p_mst_rec.last_update_date) THEN
1301: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1302: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1301: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1297: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1298: RAISE OKL_API.G_EXCEPTION_ERROR;
1299: END IF;
1300: IF (l_lock_var.last_update_date <> p_mst_rec.last_update_date) THEN
1301: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1302: RAISE OKL_API.G_EXCEPTION_ERROR;
1303: END IF;
1304: IF (l_lock_var.last_update_login <> p_mst_rec.last_update_login) THEN
1305: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1302: RAISE OKL_API.G_EXCEPTION_ERROR;

1298: RAISE OKL_API.G_EXCEPTION_ERROR;
1299: END IF;
1300: IF (l_lock_var.last_update_date <> p_mst_rec.last_update_date) THEN
1301: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1302: RAISE OKL_API.G_EXCEPTION_ERROR;
1303: END IF;
1304: IF (l_lock_var.last_update_login <> p_mst_rec.last_update_login) THEN
1305: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1306: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1305: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1301: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1302: RAISE OKL_API.G_EXCEPTION_ERROR;
1303: END IF;
1304: IF (l_lock_var.last_update_login <> p_mst_rec.last_update_login) THEN
1305: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1306: RAISE OKL_API.G_EXCEPTION_ERROR;
1307: END IF;
1308: IF (l_lock_var.transaction_date <> p_mst_rec.transaction_date) THEN
1309: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line 1306: RAISE OKL_API.G_EXCEPTION_ERROR;

1302: RAISE OKL_API.G_EXCEPTION_ERROR;
1303: END IF;
1304: IF (l_lock_var.last_update_login <> p_mst_rec.last_update_login) THEN
1305: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1306: RAISE OKL_API.G_EXCEPTION_ERROR;
1307: END IF;
1308: IF (l_lock_var.transaction_date <> p_mst_rec.transaction_date) THEN
1309: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1310: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1309: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1305: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1306: RAISE OKL_API.G_EXCEPTION_ERROR;
1307: END IF;
1308: IF (l_lock_var.transaction_date <> p_mst_rec.transaction_date) THEN
1309: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1310: RAISE OKL_API.G_EXCEPTION_ERROR;
1311: END IF;
1312: END IF;
1313: x_return_status := l_return_status;

Line 1310: RAISE OKL_API.G_EXCEPTION_ERROR;

1306: RAISE OKL_API.G_EXCEPTION_ERROR;
1307: END IF;
1308: IF (l_lock_var.transaction_date <> p_mst_rec.transaction_date) THEN
1309: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1310: RAISE OKL_API.G_EXCEPTION_ERROR;
1311: END IF;
1312: END IF;
1313: x_return_status := l_return_status;
1314: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1314: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1310: RAISE OKL_API.G_EXCEPTION_ERROR;
1311: END IF;
1312: END IF;
1313: x_return_status := l_return_status;
1314: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1315: EXCEPTION
1316: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1317: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1318: (

Line 1316: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1312: END IF;
1313: x_return_status := l_return_status;
1314: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1315: EXCEPTION
1316: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1317: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1318: (
1319: l_api_name,
1320: G_PKG_NAME,

Line 1317: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1313: x_return_status := l_return_status;
1314: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1315: EXCEPTION
1316: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1317: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1318: (
1319: l_api_name,
1320: G_PKG_NAME,
1321: 'OKL_API.G_RET_STS_ERROR',

Line 1321: 'OKL_API.G_RET_STS_ERROR',

1317: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1318: (
1319: l_api_name,
1320: G_PKG_NAME,
1321: 'OKL_API.G_RET_STS_ERROR',
1322: x_msg_count,
1323: x_msg_data,
1324: '_PVT'
1325: );

Line 1326: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1322: x_msg_count,
1323: x_msg_data,
1324: '_PVT'
1325: );
1326: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1327: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1328: (
1329: l_api_name,
1330: G_PKG_NAME,

Line 1327: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1323: x_msg_data,
1324: '_PVT'
1325: );
1326: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1327: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1328: (
1329: l_api_name,
1330: G_PKG_NAME,
1331: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1331: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1327: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1328: (
1329: l_api_name,
1330: G_PKG_NAME,
1331: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1332: x_msg_count,
1333: x_msg_data,
1334: '_PVT'
1335: );

Line 1337: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1333: x_msg_data,
1334: '_PVT'
1335: );
1336: WHEN OTHERS THEN
1337: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1338: (
1339: l_api_name,
1340: G_PKG_NAME,
1341: 'OTHERS',

Line 1360: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1356: p_mstv_rec IN mstv_rec_type) IS
1357:
1358: l_api_version CONSTANT NUMBER := 1;
1359: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1360: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1361: l_mst_rec mst_rec_type;
1362: BEGIN
1363: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1364: G_PKG_NAME,

Line 1363: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1359: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1360: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1361: l_mst_rec mst_rec_type;
1362: BEGIN
1363: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1364: G_PKG_NAME,
1365: p_init_msg_list,
1366: l_api_version,
1367: p_api_version,

Line 1370: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1366: l_api_version,
1367: p_api_version,
1368: '_PVT',
1369: x_return_status);
1370: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1371: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1372: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1373: RAISE OKL_API.G_EXCEPTION_ERROR;
1374: END IF;

Line 1371: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1367: p_api_version,
1368: '_PVT',
1369: x_return_status);
1370: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1371: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1372: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1373: RAISE OKL_API.G_EXCEPTION_ERROR;
1374: END IF;
1375: -----------------------------------------

Line 1372: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1368: '_PVT',
1369: x_return_status);
1370: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1371: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1372: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1373: RAISE OKL_API.G_EXCEPTION_ERROR;
1374: END IF;
1375: -----------------------------------------
1376: -- Move VIEW record to "Child" records --

Line 1373: RAISE OKL_API.G_EXCEPTION_ERROR;

1369: x_return_status);
1370: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1371: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1372: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1373: RAISE OKL_API.G_EXCEPTION_ERROR;
1374: END IF;
1375: -----------------------------------------
1376: -- Move VIEW record to "Child" records --
1377: -----------------------------------------

Line 1389: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1385: x_msg_count,
1386: x_msg_data,
1387: l_mst_rec
1388: );
1389: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1392: RAISE OKL_API.G_EXCEPTION_ERROR;
1393: END IF;

Line 1390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1386: x_msg_data,
1387: l_mst_rec
1388: );
1389: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1392: RAISE OKL_API.G_EXCEPTION_ERROR;
1393: END IF;
1394: x_return_status := l_return_status;

Line 1391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1387: l_mst_rec
1388: );
1389: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1392: RAISE OKL_API.G_EXCEPTION_ERROR;
1393: END IF;
1394: x_return_status := l_return_status;
1395: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1392: RAISE OKL_API.G_EXCEPTION_ERROR;

1388: );
1389: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1392: RAISE OKL_API.G_EXCEPTION_ERROR;
1393: END IF;
1394: x_return_status := l_return_status;
1395: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1396: EXCEPTION

Line 1395: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1392: RAISE OKL_API.G_EXCEPTION_ERROR;
1393: END IF;
1394: x_return_status := l_return_status;
1395: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1396: EXCEPTION
1397: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1398: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1399: (

Line 1397: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1393: END IF;
1394: x_return_status := l_return_status;
1395: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1396: EXCEPTION
1397: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1398: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1399: (
1400: l_api_name,
1401: G_PKG_NAME,

Line 1398: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1394: x_return_status := l_return_status;
1395: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1396: EXCEPTION
1397: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1398: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1399: (
1400: l_api_name,
1401: G_PKG_NAME,
1402: 'OKL_API.G_RET_STS_ERROR',

Line 1402: 'OKL_API.G_RET_STS_ERROR',

1398: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1399: (
1400: l_api_name,
1401: G_PKG_NAME,
1402: 'OKL_API.G_RET_STS_ERROR',
1403: x_msg_count,
1404: x_msg_data,
1405: '_PVT'
1406: );

Line 1407: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1403: x_msg_count,
1404: x_msg_data,
1405: '_PVT'
1406: );
1407: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1408: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1409: (
1410: l_api_name,
1411: G_PKG_NAME,

Line 1408: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1404: x_msg_data,
1405: '_PVT'
1406: );
1407: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1408: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1409: (
1410: l_api_name,
1411: G_PKG_NAME,
1412: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1412: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1408: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1409: (
1410: l_api_name,
1411: G_PKG_NAME,
1412: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1413: x_msg_count,
1414: x_msg_data,
1415: '_PVT'
1416: );

Line 1418: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1414: x_msg_data,
1415: '_PVT'
1416: );
1417: WHEN OTHERS THEN
1418: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1419: (
1420: l_api_name,
1421: G_PKG_NAME,
1422: 'OTHERS',

Line 1442: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1438:
1439: l_api_version CONSTANT NUMBER := 1;
1440: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1441: i NUMBER := 0;
1442: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1443: BEGIN
1444: OKL_API.init_msg_list(p_init_msg_list);
1445: -- Make sure PL/SQL table has recrods in it before passing
1446: IF (p_mstv_tbl.COUNT > 0) THEN

Line 1444: OKL_API.init_msg_list(p_init_msg_list);

1440: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1441: i NUMBER := 0;
1442: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1443: BEGIN
1444: OKL_API.init_msg_list(p_init_msg_list);
1445: -- Make sure PL/SQL table has recrods in it before passing
1446: IF (p_mstv_tbl.COUNT > 0) THEN
1447: i := p_mstv_tbl.FIRST;
1448: LOOP

Line 1451: p_init_msg_list => OKL_API.G_FALSE,

1447: i := p_mstv_tbl.FIRST;
1448: LOOP
1449: lock_row(
1450: p_api_version => p_api_version,
1451: p_init_msg_list => OKL_API.G_FALSE,
1452: x_return_status => x_return_status,
1453: x_msg_count => x_msg_count,
1454: x_msg_data => x_msg_data,
1455: p_mstv_rec => p_mstv_tbl(i));

Line 1457: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

1453: x_msg_count => x_msg_count,
1454: x_msg_data => x_msg_data,
1455: p_mstv_rec => p_mstv_tbl(i));
1456:
1457: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1458: l_final_status := x_return_status;
1459: END IF;
1460: EXIT WHEN (i = p_mstv_tbl.LAST);
1461: i := p_mstv_tbl.NEXT(i);

Line 1466: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1462: END LOOP;
1463: END IF;
1464:
1465: x_return_status := l_final_status;
1466: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1467:
1468: EXCEPTION
1469: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1470: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 1469: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1465: x_return_status := l_final_status;
1466: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1467:
1468: EXCEPTION
1469: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1470: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1471: (
1472: l_api_name,
1473: G_PKG_NAME,

Line 1470: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1466: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1467:
1468: EXCEPTION
1469: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1470: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1471: (
1472: l_api_name,
1473: G_PKG_NAME,
1474: 'OKL_API.G_RET_STS_ERROR',

Line 1474: 'OKL_API.G_RET_STS_ERROR',

1470: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1471: (
1472: l_api_name,
1473: G_PKG_NAME,
1474: 'OKL_API.G_RET_STS_ERROR',
1475: x_msg_count,
1476: x_msg_data,
1477: '_PVT'
1478: );

Line 1479: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1475: x_msg_count,
1476: x_msg_data,
1477: '_PVT'
1478: );
1479: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1480: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1481: (
1482: l_api_name,
1483: G_PKG_NAME,

Line 1480: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1476: x_msg_data,
1477: '_PVT'
1478: );
1479: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1480: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1481: (
1482: l_api_name,
1483: G_PKG_NAME,
1484: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1484: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1480: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1481: (
1482: l_api_name,
1483: G_PKG_NAME,
1484: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1485: x_msg_count,
1486: x_msg_data,
1487: '_PVT'
1488: );

Line 1490: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1486: x_msg_data,
1487: '_PVT'
1488: );
1489: WHEN OTHERS THEN
1490: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1491: (
1492: l_api_name,
1493: G_PKG_NAME,
1494: 'OTHERS',

Line 1508: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1504: ----------------------------------------------
1505: -- update_row for:OKL_RBK_SELECTED_CONTRACT --
1506: ----------------------------------------------
1507: PROCEDURE update_row(
1508: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1509: x_return_status OUT NOCOPY VARCHAR2,
1510: x_msg_count OUT NOCOPY NUMBER,
1511: x_msg_data OUT NOCOPY VARCHAR2,
1512: p_mst_rec IN mst_rec_type,

Line 1517: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1513: x_mst_rec OUT NOCOPY mst_rec_type) IS
1514:
1515: l_api_version CONSTANT NUMBER := 1;
1516: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1517: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1518: l_mst_rec mst_rec_type := p_mst_rec;
1519: l_def_mst_rec mst_rec_type;
1520: l_row_notfound BOOLEAN := TRUE;
1521: ----------------------------------

Line 1530: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1526: x_mst_rec OUT NOCOPY mst_rec_type
1527: ) RETURN VARCHAR2 IS
1528: l_mst_rec mst_rec_type;
1529: l_row_notfound BOOLEAN := TRUE;
1530: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1531: BEGIN
1532: x_mst_rec := p_mst_rec;
1533: -- Get current database values
1534: l_mst_rec := get_rec(p_mst_rec, l_return_status);

Line 1535: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

1531: BEGIN
1532: x_mst_rec := p_mst_rec;
1533: -- Get current database values
1534: l_mst_rec := get_rec(p_mst_rec, l_return_status);
1535: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1536: IF (x_mst_rec.id = OKL_API.G_MISS_NUM)
1537: THEN
1538: x_mst_rec.id := l_mst_rec.id;
1539: END IF;

Line 1536: IF (x_mst_rec.id = OKL_API.G_MISS_NUM)

1532: x_mst_rec := p_mst_rec;
1533: -- Get current database values
1534: l_mst_rec := get_rec(p_mst_rec, l_return_status);
1535: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1536: IF (x_mst_rec.id = OKL_API.G_MISS_NUM)
1537: THEN
1538: x_mst_rec.id := l_mst_rec.id;
1539: END IF;
1540: IF (x_mst_rec.request_name = OKL_API.G_MISS_CHAR)

Line 1540: IF (x_mst_rec.request_name = OKL_API.G_MISS_CHAR)

1536: IF (x_mst_rec.id = OKL_API.G_MISS_NUM)
1537: THEN
1538: x_mst_rec.id := l_mst_rec.id;
1539: END IF;
1540: IF (x_mst_rec.request_name = OKL_API.G_MISS_CHAR)
1541: THEN
1542: x_mst_rec.request_name := l_mst_rec.request_name;
1543: END IF;
1544: IF (x_mst_rec.khr_id = OKL_API.G_MISS_NUM)

Line 1544: IF (x_mst_rec.khr_id = OKL_API.G_MISS_NUM)

1540: IF (x_mst_rec.request_name = OKL_API.G_MISS_CHAR)
1541: THEN
1542: x_mst_rec.request_name := l_mst_rec.request_name;
1543: END IF;
1544: IF (x_mst_rec.khr_id = OKL_API.G_MISS_NUM)
1545: THEN
1546: x_mst_rec.khr_id := l_mst_rec.khr_id;
1547: END IF;
1548: IF (x_mst_rec.contract_number = OKL_API.G_MISS_CHAR)

Line 1548: IF (x_mst_rec.contract_number = OKL_API.G_MISS_CHAR)

1544: IF (x_mst_rec.khr_id = OKL_API.G_MISS_NUM)
1545: THEN
1546: x_mst_rec.khr_id := l_mst_rec.khr_id;
1547: END IF;
1548: IF (x_mst_rec.contract_number = OKL_API.G_MISS_CHAR)
1549: THEN
1550: x_mst_rec.contract_number := l_mst_rec.contract_number;
1551: END IF;
1552: IF (x_mst_rec.contract_description = OKL_API.G_MISS_CHAR)

Line 1552: IF (x_mst_rec.contract_description = OKL_API.G_MISS_CHAR)

1548: IF (x_mst_rec.contract_number = OKL_API.G_MISS_CHAR)
1549: THEN
1550: x_mst_rec.contract_number := l_mst_rec.contract_number;
1551: END IF;
1552: IF (x_mst_rec.contract_description = OKL_API.G_MISS_CHAR)
1553: THEN
1554: x_mst_rec.contract_description := l_mst_rec.contract_description;
1555: END IF;
1556: IF (x_mst_rec.kle_id = OKL_API.G_MISS_NUM)

Line 1556: IF (x_mst_rec.kle_id = OKL_API.G_MISS_NUM)

1552: IF (x_mst_rec.contract_description = OKL_API.G_MISS_CHAR)
1553: THEN
1554: x_mst_rec.contract_description := l_mst_rec.contract_description;
1555: END IF;
1556: IF (x_mst_rec.kle_id = OKL_API.G_MISS_NUM)
1557: THEN
1558: x_mst_rec.kle_id := l_mst_rec.kle_id;
1559: END IF;
1560: IF (x_mst_rec.transaction_id = OKL_API.G_MISS_NUM)

Line 1560: IF (x_mst_rec.transaction_id = OKL_API.G_MISS_NUM)

1556: IF (x_mst_rec.kle_id = OKL_API.G_MISS_NUM)
1557: THEN
1558: x_mst_rec.kle_id := l_mst_rec.kle_id;
1559: END IF;
1560: IF (x_mst_rec.transaction_id = OKL_API.G_MISS_NUM)
1561: THEN
1562: x_mst_rec.transaction_id := l_mst_rec.transaction_id;
1563: END IF;
1564: IF (x_mst_rec.selected_flag = OKL_API.G_MISS_CHAR)

Line 1564: IF (x_mst_rec.selected_flag = OKL_API.G_MISS_CHAR)

1560: IF (x_mst_rec.transaction_id = OKL_API.G_MISS_NUM)
1561: THEN
1562: x_mst_rec.transaction_id := l_mst_rec.transaction_id;
1563: END IF;
1564: IF (x_mst_rec.selected_flag = OKL_API.G_MISS_CHAR)
1565: THEN
1566: x_mst_rec.selected_flag := l_mst_rec.selected_flag;
1567: END IF;
1568: IF (x_mst_rec.status = OKL_API.G_MISS_CHAR)

Line 1568: IF (x_mst_rec.status = OKL_API.G_MISS_CHAR)

1564: IF (x_mst_rec.selected_flag = OKL_API.G_MISS_CHAR)
1565: THEN
1566: x_mst_rec.selected_flag := l_mst_rec.selected_flag;
1567: END IF;
1568: IF (x_mst_rec.status = OKL_API.G_MISS_CHAR)
1569: THEN
1570: x_mst_rec.status := l_mst_rec.status;
1571: END IF;
1572: IF (x_mst_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 1572: IF (x_mst_rec.attribute_category = OKL_API.G_MISS_CHAR)

1568: IF (x_mst_rec.status = OKL_API.G_MISS_CHAR)
1569: THEN
1570: x_mst_rec.status := l_mst_rec.status;
1571: END IF;
1572: IF (x_mst_rec.attribute_category = OKL_API.G_MISS_CHAR)
1573: THEN
1574: x_mst_rec.attribute_category := l_mst_rec.attribute_category;
1575: END IF;
1576: IF (x_mst_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 1576: IF (x_mst_rec.attribute1 = OKL_API.G_MISS_CHAR)

1572: IF (x_mst_rec.attribute_category = OKL_API.G_MISS_CHAR)
1573: THEN
1574: x_mst_rec.attribute_category := l_mst_rec.attribute_category;
1575: END IF;
1576: IF (x_mst_rec.attribute1 = OKL_API.G_MISS_CHAR)
1577: THEN
1578: x_mst_rec.attribute1 := l_mst_rec.attribute1;
1579: END IF;
1580: IF (x_mst_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 1580: IF (x_mst_rec.attribute2 = OKL_API.G_MISS_CHAR)

1576: IF (x_mst_rec.attribute1 = OKL_API.G_MISS_CHAR)
1577: THEN
1578: x_mst_rec.attribute1 := l_mst_rec.attribute1;
1579: END IF;
1580: IF (x_mst_rec.attribute2 = OKL_API.G_MISS_CHAR)
1581: THEN
1582: x_mst_rec.attribute2 := l_mst_rec.attribute2;
1583: END IF;
1584: IF (x_mst_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 1584: IF (x_mst_rec.attribute3 = OKL_API.G_MISS_CHAR)

1580: IF (x_mst_rec.attribute2 = OKL_API.G_MISS_CHAR)
1581: THEN
1582: x_mst_rec.attribute2 := l_mst_rec.attribute2;
1583: END IF;
1584: IF (x_mst_rec.attribute3 = OKL_API.G_MISS_CHAR)
1585: THEN
1586: x_mst_rec.attribute3 := l_mst_rec.attribute3;
1587: END IF;
1588: IF (x_mst_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 1588: IF (x_mst_rec.attribute4 = OKL_API.G_MISS_CHAR)

1584: IF (x_mst_rec.attribute3 = OKL_API.G_MISS_CHAR)
1585: THEN
1586: x_mst_rec.attribute3 := l_mst_rec.attribute3;
1587: END IF;
1588: IF (x_mst_rec.attribute4 = OKL_API.G_MISS_CHAR)
1589: THEN
1590: x_mst_rec.attribute4 := l_mst_rec.attribute4;
1591: END IF;
1592: IF (x_mst_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 1592: IF (x_mst_rec.attribute5 = OKL_API.G_MISS_CHAR)

1588: IF (x_mst_rec.attribute4 = OKL_API.G_MISS_CHAR)
1589: THEN
1590: x_mst_rec.attribute4 := l_mst_rec.attribute4;
1591: END IF;
1592: IF (x_mst_rec.attribute5 = OKL_API.G_MISS_CHAR)
1593: THEN
1594: x_mst_rec.attribute5 := l_mst_rec.attribute5;
1595: END IF;
1596: IF (x_mst_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 1596: IF (x_mst_rec.attribute6 = OKL_API.G_MISS_CHAR)

1592: IF (x_mst_rec.attribute5 = OKL_API.G_MISS_CHAR)
1593: THEN
1594: x_mst_rec.attribute5 := l_mst_rec.attribute5;
1595: END IF;
1596: IF (x_mst_rec.attribute6 = OKL_API.G_MISS_CHAR)
1597: THEN
1598: x_mst_rec.attribute6 := l_mst_rec.attribute6;
1599: END IF;
1600: IF (x_mst_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 1600: IF (x_mst_rec.attribute7 = OKL_API.G_MISS_CHAR)

1596: IF (x_mst_rec.attribute6 = OKL_API.G_MISS_CHAR)
1597: THEN
1598: x_mst_rec.attribute6 := l_mst_rec.attribute6;
1599: END IF;
1600: IF (x_mst_rec.attribute7 = OKL_API.G_MISS_CHAR)
1601: THEN
1602: x_mst_rec.attribute7 := l_mst_rec.attribute7;
1603: END IF;
1604: IF (x_mst_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 1604: IF (x_mst_rec.attribute8 = OKL_API.G_MISS_CHAR)

1600: IF (x_mst_rec.attribute7 = OKL_API.G_MISS_CHAR)
1601: THEN
1602: x_mst_rec.attribute7 := l_mst_rec.attribute7;
1603: END IF;
1604: IF (x_mst_rec.attribute8 = OKL_API.G_MISS_CHAR)
1605: THEN
1606: x_mst_rec.attribute8 := l_mst_rec.attribute8;
1607: END IF;
1608: IF (x_mst_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 1608: IF (x_mst_rec.attribute9 = OKL_API.G_MISS_CHAR)

1604: IF (x_mst_rec.attribute8 = OKL_API.G_MISS_CHAR)
1605: THEN
1606: x_mst_rec.attribute8 := l_mst_rec.attribute8;
1607: END IF;
1608: IF (x_mst_rec.attribute9 = OKL_API.G_MISS_CHAR)
1609: THEN
1610: x_mst_rec.attribute9 := l_mst_rec.attribute9;
1611: END IF;
1612: IF (x_mst_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 1612: IF (x_mst_rec.attribute10 = OKL_API.G_MISS_CHAR)

1608: IF (x_mst_rec.attribute9 = OKL_API.G_MISS_CHAR)
1609: THEN
1610: x_mst_rec.attribute9 := l_mst_rec.attribute9;
1611: END IF;
1612: IF (x_mst_rec.attribute10 = OKL_API.G_MISS_CHAR)
1613: THEN
1614: x_mst_rec.attribute10 := l_mst_rec.attribute10;
1615: END IF;
1616: IF (x_mst_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 1616: IF (x_mst_rec.attribute11 = OKL_API.G_MISS_CHAR)

1612: IF (x_mst_rec.attribute10 = OKL_API.G_MISS_CHAR)
1613: THEN
1614: x_mst_rec.attribute10 := l_mst_rec.attribute10;
1615: END IF;
1616: IF (x_mst_rec.attribute11 = OKL_API.G_MISS_CHAR)
1617: THEN
1618: x_mst_rec.attribute11 := l_mst_rec.attribute11;
1619: END IF;
1620: IF (x_mst_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 1620: IF (x_mst_rec.attribute12 = OKL_API.G_MISS_CHAR)

1616: IF (x_mst_rec.attribute11 = OKL_API.G_MISS_CHAR)
1617: THEN
1618: x_mst_rec.attribute11 := l_mst_rec.attribute11;
1619: END IF;
1620: IF (x_mst_rec.attribute12 = OKL_API.G_MISS_CHAR)
1621: THEN
1622: x_mst_rec.attribute12 := l_mst_rec.attribute12;
1623: END IF;
1624: IF (x_mst_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 1624: IF (x_mst_rec.attribute13 = OKL_API.G_MISS_CHAR)

1620: IF (x_mst_rec.attribute12 = OKL_API.G_MISS_CHAR)
1621: THEN
1622: x_mst_rec.attribute12 := l_mst_rec.attribute12;
1623: END IF;
1624: IF (x_mst_rec.attribute13 = OKL_API.G_MISS_CHAR)
1625: THEN
1626: x_mst_rec.attribute13 := l_mst_rec.attribute13;
1627: END IF;
1628: IF (x_mst_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 1628: IF (x_mst_rec.attribute14 = OKL_API.G_MISS_CHAR)

1624: IF (x_mst_rec.attribute13 = OKL_API.G_MISS_CHAR)
1625: THEN
1626: x_mst_rec.attribute13 := l_mst_rec.attribute13;
1627: END IF;
1628: IF (x_mst_rec.attribute14 = OKL_API.G_MISS_CHAR)
1629: THEN
1630: x_mst_rec.attribute14 := l_mst_rec.attribute14;
1631: END IF;
1632: IF (x_mst_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 1632: IF (x_mst_rec.attribute15 = OKL_API.G_MISS_CHAR)

1628: IF (x_mst_rec.attribute14 = OKL_API.G_MISS_CHAR)
1629: THEN
1630: x_mst_rec.attribute14 := l_mst_rec.attribute14;
1631: END IF;
1632: IF (x_mst_rec.attribute15 = OKL_API.G_MISS_CHAR)
1633: THEN
1634: x_mst_rec.attribute15 := l_mst_rec.attribute15;
1635: END IF;
1636: IF (x_mst_rec.created_by = OKL_API.G_MISS_NUM)

Line 1636: IF (x_mst_rec.created_by = OKL_API.G_MISS_NUM)

1632: IF (x_mst_rec.attribute15 = OKL_API.G_MISS_CHAR)
1633: THEN
1634: x_mst_rec.attribute15 := l_mst_rec.attribute15;
1635: END IF;
1636: IF (x_mst_rec.created_by = OKL_API.G_MISS_NUM)
1637: THEN
1638: x_mst_rec.created_by := l_mst_rec.created_by;
1639: END IF;
1640: IF (x_mst_rec.creation_date = OKL_API.G_MISS_DATE)

Line 1640: IF (x_mst_rec.creation_date = OKL_API.G_MISS_DATE)

1636: IF (x_mst_rec.created_by = OKL_API.G_MISS_NUM)
1637: THEN
1638: x_mst_rec.created_by := l_mst_rec.created_by;
1639: END IF;
1640: IF (x_mst_rec.creation_date = OKL_API.G_MISS_DATE)
1641: THEN
1642: x_mst_rec.creation_date := l_mst_rec.creation_date;
1643: END IF;
1644: IF (x_mst_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 1644: IF (x_mst_rec.last_updated_by = OKL_API.G_MISS_NUM)

1640: IF (x_mst_rec.creation_date = OKL_API.G_MISS_DATE)
1641: THEN
1642: x_mst_rec.creation_date := l_mst_rec.creation_date;
1643: END IF;
1644: IF (x_mst_rec.last_updated_by = OKL_API.G_MISS_NUM)
1645: THEN
1646: x_mst_rec.last_updated_by := l_mst_rec.last_updated_by;
1647: END IF;
1648: IF (x_mst_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 1648: IF (x_mst_rec.last_update_date = OKL_API.G_MISS_DATE)

1644: IF (x_mst_rec.last_updated_by = OKL_API.G_MISS_NUM)
1645: THEN
1646: x_mst_rec.last_updated_by := l_mst_rec.last_updated_by;
1647: END IF;
1648: IF (x_mst_rec.last_update_date = OKL_API.G_MISS_DATE)
1649: THEN
1650: x_mst_rec.last_update_date := l_mst_rec.last_update_date;
1651: END IF;
1652: IF (x_mst_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 1652: IF (x_mst_rec.last_update_login = OKL_API.G_MISS_NUM)

1648: IF (x_mst_rec.last_update_date = OKL_API.G_MISS_DATE)
1649: THEN
1650: x_mst_rec.last_update_date := l_mst_rec.last_update_date;
1651: END IF;
1652: IF (x_mst_rec.last_update_login = OKL_API.G_MISS_NUM)
1653: THEN
1654: x_mst_rec.last_update_login := l_mst_rec.last_update_login;
1655: END IF;
1656: IF (x_mst_rec.transaction_date = OKL_API.G_MISS_DATE)

Line 1656: IF (x_mst_rec.transaction_date = OKL_API.G_MISS_DATE)

1652: IF (x_mst_rec.last_update_login = OKL_API.G_MISS_NUM)
1653: THEN
1654: x_mst_rec.last_update_login := l_mst_rec.last_update_login;
1655: END IF;
1656: IF (x_mst_rec.transaction_date = OKL_API.G_MISS_DATE)
1657: THEN
1658: x_mst_rec.transaction_date := l_mst_rec.transaction_date;
1659: END IF;
1660: END IF;

Line 1670: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1666: FUNCTION Set_Attributes (
1667: p_mst_rec IN mst_rec_type,
1668: x_mst_rec OUT NOCOPY mst_rec_type
1669: ) RETURN VARCHAR2 IS
1670: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1671: BEGIN
1672: x_mst_rec := p_mst_rec;
1673: RETURN(l_return_status);
1674: END Set_Attributes;

Line 1676: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1672: x_mst_rec := p_mst_rec;
1673: RETURN(l_return_status);
1674: END Set_Attributes;
1675: BEGIN
1676: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1677: p_init_msg_list,
1678: '_PVT',
1679: x_return_status);
1680: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1680: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1676: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1677: p_init_msg_list,
1678: '_PVT',
1679: x_return_status);
1680: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1681: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1682: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1683: RAISE OKL_API.G_EXCEPTION_ERROR;
1684: END IF;

Line 1681: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1677: p_init_msg_list,
1678: '_PVT',
1679: x_return_status);
1680: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1681: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1682: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1683: RAISE OKL_API.G_EXCEPTION_ERROR;
1684: END IF;
1685: --- Setting item attributes

Line 1682: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1678: '_PVT',
1679: x_return_status);
1680: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1681: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1682: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1683: RAISE OKL_API.G_EXCEPTION_ERROR;
1684: END IF;
1685: --- Setting item attributes
1686: l_return_status := Set_Attributes(

Line 1683: RAISE OKL_API.G_EXCEPTION_ERROR;

1679: x_return_status);
1680: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1681: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1682: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1683: RAISE OKL_API.G_EXCEPTION_ERROR;
1684: END IF;
1685: --- Setting item attributes
1686: l_return_status := Set_Attributes(
1687: p_mst_rec, -- IN

Line 1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1686: l_return_status := Set_Attributes(
1687: p_mst_rec, -- IN
1688: l_mst_rec); -- OUT
1689: --- If any errors happen abort API
1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;

Line 1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1687: p_mst_rec, -- IN
1688: l_mst_rec); -- OUT
1689: --- If any errors happen abort API
1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;
1695: l_return_status := populate_new_record(l_mst_rec, l_def_mst_rec);

Line 1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1688: l_mst_rec); -- OUT
1689: --- If any errors happen abort API
1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;
1695: l_return_status := populate_new_record(l_mst_rec, l_def_mst_rec);
1696: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1693: RAISE OKL_API.G_EXCEPTION_ERROR;

1689: --- If any errors happen abort API
1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;
1695: l_return_status := populate_new_record(l_mst_rec, l_def_mst_rec);
1696: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1697: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1696: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;
1695: l_return_status := populate_new_record(l_mst_rec, l_def_mst_rec);
1696: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1697: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1698: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1699: RAISE OKL_API.G_EXCEPTION_ERROR;
1700: END IF;

Line 1697: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;
1695: l_return_status := populate_new_record(l_mst_rec, l_def_mst_rec);
1696: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1697: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1698: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1699: RAISE OKL_API.G_EXCEPTION_ERROR;
1700: END IF;
1701: UPDATE OKL_RBK_SELECTED_CONTRACT

Line 1698: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1694: END IF;
1695: l_return_status := populate_new_record(l_mst_rec, l_def_mst_rec);
1696: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1697: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1698: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1699: RAISE OKL_API.G_EXCEPTION_ERROR;
1700: END IF;
1701: UPDATE OKL_RBK_SELECTED_CONTRACT
1702: SET request_name = l_def_mst_rec.request_name,

Line 1699: RAISE OKL_API.G_EXCEPTION_ERROR;

1695: l_return_status := populate_new_record(l_mst_rec, l_def_mst_rec);
1696: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1697: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1698: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1699: RAISE OKL_API.G_EXCEPTION_ERROR;
1700: END IF;
1701: UPDATE OKL_RBK_SELECTED_CONTRACT
1702: SET request_name = l_def_mst_rec.request_name,
1703: KHR_ID = l_def_mst_rec.khr_id,

Line 1736: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1732: WHERE ID = l_def_mst_rec.id;
1733:
1734: x_mst_rec := l_mst_rec;
1735: x_return_status := l_return_status;
1736: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1737: EXCEPTION
1738: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1739: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1740: (

Line 1738: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1734: x_mst_rec := l_mst_rec;
1735: x_return_status := l_return_status;
1736: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1737: EXCEPTION
1738: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1739: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1740: (
1741: l_api_name,
1742: G_PKG_NAME,

Line 1739: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1735: x_return_status := l_return_status;
1736: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1737: EXCEPTION
1738: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1739: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1740: (
1741: l_api_name,
1742: G_PKG_NAME,
1743: 'OKL_API.G_RET_STS_ERROR',

Line 1743: 'OKL_API.G_RET_STS_ERROR',

1739: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1740: (
1741: l_api_name,
1742: G_PKG_NAME,
1743: 'OKL_API.G_RET_STS_ERROR',
1744: x_msg_count,
1745: x_msg_data,
1746: '_PVT'
1747: );

Line 1748: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1744: x_msg_count,
1745: x_msg_data,
1746: '_PVT'
1747: );
1748: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1749: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1750: (
1751: l_api_name,
1752: G_PKG_NAME,

Line 1749: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1745: x_msg_data,
1746: '_PVT'
1747: );
1748: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1749: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1750: (
1751: l_api_name,
1752: G_PKG_NAME,
1753: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1753: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1749: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1750: (
1751: l_api_name,
1752: G_PKG_NAME,
1753: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1754: x_msg_count,
1755: x_msg_data,
1756: '_PVT'
1757: );

Line 1759: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1755: x_msg_data,
1756: '_PVT'
1757: );
1758: WHEN OTHERS THEN
1759: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1760: (
1761: l_api_name,
1762: G_PKG_NAME,
1763: 'OTHERS',

Line 1783: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1779: x_mstv_rec OUT NOCOPY mstv_rec_type) IS
1780:
1781: l_api_version CONSTANT NUMBER := 1;
1782: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1783: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1784: l_mstv_rec mstv_rec_type := p_mstv_rec;
1785: l_def_mstv_rec mstv_rec_type;
1786: l_db_mstv_rec mstv_rec_type;
1787: l_mst_rec mst_rec_type;

Line 1810: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1806: p_mstv_rec IN mstv_rec_type,
1807: x_mstv_rec OUT NOCOPY mstv_rec_type
1808: ) RETURN VARCHAR2 IS
1809: l_row_notfound BOOLEAN := TRUE;
1810: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1811: BEGIN
1812: x_mstv_rec := p_mstv_rec;
1813: -- Get current database values
1814: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it

Line 1817: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

1813: -- Get current database values
1814: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1815: -- so it may be verified through LOCK_ROW.
1816: l_db_mstv_rec := get_rec(p_mstv_rec, l_return_status);
1817: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1818: IF (x_mstv_rec.id = OKL_API.G_MISS_NUM)
1819: THEN
1820: x_mstv_rec.id := l_db_mstv_rec.id;
1821: END IF;

Line 1818: IF (x_mstv_rec.id = OKL_API.G_MISS_NUM)

1814: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1815: -- so it may be verified through LOCK_ROW.
1816: l_db_mstv_rec := get_rec(p_mstv_rec, l_return_status);
1817: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1818: IF (x_mstv_rec.id = OKL_API.G_MISS_NUM)
1819: THEN
1820: x_mstv_rec.id := l_db_mstv_rec.id;
1821: END IF;
1822: IF (x_mstv_rec.request_name = OKL_API.G_MISS_CHAR)

Line 1822: IF (x_mstv_rec.request_name = OKL_API.G_MISS_CHAR)

1818: IF (x_mstv_rec.id = OKL_API.G_MISS_NUM)
1819: THEN
1820: x_mstv_rec.id := l_db_mstv_rec.id;
1821: END IF;
1822: IF (x_mstv_rec.request_name = OKL_API.G_MISS_CHAR)
1823: THEN
1824: x_mstv_rec.request_name := l_db_mstv_rec.request_name;
1825: END IF;
1826: IF (x_mstv_rec.khr_id = OKL_API.G_MISS_NUM)

Line 1826: IF (x_mstv_rec.khr_id = OKL_API.G_MISS_NUM)

1822: IF (x_mstv_rec.request_name = OKL_API.G_MISS_CHAR)
1823: THEN
1824: x_mstv_rec.request_name := l_db_mstv_rec.request_name;
1825: END IF;
1826: IF (x_mstv_rec.khr_id = OKL_API.G_MISS_NUM)
1827: THEN
1828: x_mstv_rec.khr_id := l_db_mstv_rec.khr_id;
1829: END IF;
1830: IF (x_mstv_rec.contract_number = OKL_API.G_MISS_CHAR)

Line 1830: IF (x_mstv_rec.contract_number = OKL_API.G_MISS_CHAR)

1826: IF (x_mstv_rec.khr_id = OKL_API.G_MISS_NUM)
1827: THEN
1828: x_mstv_rec.khr_id := l_db_mstv_rec.khr_id;
1829: END IF;
1830: IF (x_mstv_rec.contract_number = OKL_API.G_MISS_CHAR)
1831: THEN
1832: x_mstv_rec.contract_number := l_db_mstv_rec.contract_number;
1833: END IF;
1834: IF (x_mstv_rec.contract_description = OKL_API.G_MISS_CHAR)

Line 1834: IF (x_mstv_rec.contract_description = OKL_API.G_MISS_CHAR)

1830: IF (x_mstv_rec.contract_number = OKL_API.G_MISS_CHAR)
1831: THEN
1832: x_mstv_rec.contract_number := l_db_mstv_rec.contract_number;
1833: END IF;
1834: IF (x_mstv_rec.contract_description = OKL_API.G_MISS_CHAR)
1835: THEN
1836: x_mstv_rec.contract_description := l_db_mstv_rec.contract_description;
1837: END IF;
1838: IF (x_mstv_rec.kle_id = OKL_API.G_MISS_NUM)

Line 1838: IF (x_mstv_rec.kle_id = OKL_API.G_MISS_NUM)

1834: IF (x_mstv_rec.contract_description = OKL_API.G_MISS_CHAR)
1835: THEN
1836: x_mstv_rec.contract_description := l_db_mstv_rec.contract_description;
1837: END IF;
1838: IF (x_mstv_rec.kle_id = OKL_API.G_MISS_NUM)
1839: THEN
1840: x_mstv_rec.kle_id := l_db_mstv_rec.kle_id;
1841: END IF;
1842: IF (x_mstv_rec.transaction_id = OKL_API.G_MISS_NUM)

Line 1842: IF (x_mstv_rec.transaction_id = OKL_API.G_MISS_NUM)

1838: IF (x_mstv_rec.kle_id = OKL_API.G_MISS_NUM)
1839: THEN
1840: x_mstv_rec.kle_id := l_db_mstv_rec.kle_id;
1841: END IF;
1842: IF (x_mstv_rec.transaction_id = OKL_API.G_MISS_NUM)
1843: THEN
1844: x_mstv_rec.transaction_id := l_db_mstv_rec.transaction_id;
1845: END IF;
1846: IF (x_mstv_rec.selected_flag = OKL_API.G_MISS_CHAR)

Line 1846: IF (x_mstv_rec.selected_flag = OKL_API.G_MISS_CHAR)

1842: IF (x_mstv_rec.transaction_id = OKL_API.G_MISS_NUM)
1843: THEN
1844: x_mstv_rec.transaction_id := l_db_mstv_rec.transaction_id;
1845: END IF;
1846: IF (x_mstv_rec.selected_flag = OKL_API.G_MISS_CHAR)
1847: THEN
1848: x_mstv_rec.selected_flag := l_db_mstv_rec.selected_flag;
1849: END IF;
1850: IF (x_mstv_rec.status = OKL_API.G_MISS_CHAR)

Line 1850: IF (x_mstv_rec.status = OKL_API.G_MISS_CHAR)

1846: IF (x_mstv_rec.selected_flag = OKL_API.G_MISS_CHAR)
1847: THEN
1848: x_mstv_rec.selected_flag := l_db_mstv_rec.selected_flag;
1849: END IF;
1850: IF (x_mstv_rec.status = OKL_API.G_MISS_CHAR)
1851: THEN
1852: x_mstv_rec.status := l_db_mstv_rec.status;
1853: END IF;
1854: IF (x_mstv_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 1854: IF (x_mstv_rec.attribute_category = OKL_API.G_MISS_CHAR)

1850: IF (x_mstv_rec.status = OKL_API.G_MISS_CHAR)
1851: THEN
1852: x_mstv_rec.status := l_db_mstv_rec.status;
1853: END IF;
1854: IF (x_mstv_rec.attribute_category = OKL_API.G_MISS_CHAR)
1855: THEN
1856: x_mstv_rec.attribute_category := l_db_mstv_rec.attribute_category;
1857: END IF;
1858: IF (x_mstv_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 1858: IF (x_mstv_rec.attribute1 = OKL_API.G_MISS_CHAR)

1854: IF (x_mstv_rec.attribute_category = OKL_API.G_MISS_CHAR)
1855: THEN
1856: x_mstv_rec.attribute_category := l_db_mstv_rec.attribute_category;
1857: END IF;
1858: IF (x_mstv_rec.attribute1 = OKL_API.G_MISS_CHAR)
1859: THEN
1860: x_mstv_rec.attribute1 := l_db_mstv_rec.attribute1;
1861: END IF;
1862: IF (x_mstv_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 1862: IF (x_mstv_rec.attribute2 = OKL_API.G_MISS_CHAR)

1858: IF (x_mstv_rec.attribute1 = OKL_API.G_MISS_CHAR)
1859: THEN
1860: x_mstv_rec.attribute1 := l_db_mstv_rec.attribute1;
1861: END IF;
1862: IF (x_mstv_rec.attribute2 = OKL_API.G_MISS_CHAR)
1863: THEN
1864: x_mstv_rec.attribute2 := l_db_mstv_rec.attribute2;
1865: END IF;
1866: IF (x_mstv_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 1866: IF (x_mstv_rec.attribute3 = OKL_API.G_MISS_CHAR)

1862: IF (x_mstv_rec.attribute2 = OKL_API.G_MISS_CHAR)
1863: THEN
1864: x_mstv_rec.attribute2 := l_db_mstv_rec.attribute2;
1865: END IF;
1866: IF (x_mstv_rec.attribute3 = OKL_API.G_MISS_CHAR)
1867: THEN
1868: x_mstv_rec.attribute3 := l_db_mstv_rec.attribute3;
1869: END IF;
1870: IF (x_mstv_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 1870: IF (x_mstv_rec.attribute4 = OKL_API.G_MISS_CHAR)

1866: IF (x_mstv_rec.attribute3 = OKL_API.G_MISS_CHAR)
1867: THEN
1868: x_mstv_rec.attribute3 := l_db_mstv_rec.attribute3;
1869: END IF;
1870: IF (x_mstv_rec.attribute4 = OKL_API.G_MISS_CHAR)
1871: THEN
1872: x_mstv_rec.attribute4 := l_db_mstv_rec.attribute4;
1873: END IF;
1874: IF (x_mstv_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 1874: IF (x_mstv_rec.attribute5 = OKL_API.G_MISS_CHAR)

1870: IF (x_mstv_rec.attribute4 = OKL_API.G_MISS_CHAR)
1871: THEN
1872: x_mstv_rec.attribute4 := l_db_mstv_rec.attribute4;
1873: END IF;
1874: IF (x_mstv_rec.attribute5 = OKL_API.G_MISS_CHAR)
1875: THEN
1876: x_mstv_rec.attribute5 := l_db_mstv_rec.attribute5;
1877: END IF;
1878: IF (x_mstv_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 1878: IF (x_mstv_rec.attribute6 = OKL_API.G_MISS_CHAR)

1874: IF (x_mstv_rec.attribute5 = OKL_API.G_MISS_CHAR)
1875: THEN
1876: x_mstv_rec.attribute5 := l_db_mstv_rec.attribute5;
1877: END IF;
1878: IF (x_mstv_rec.attribute6 = OKL_API.G_MISS_CHAR)
1879: THEN
1880: x_mstv_rec.attribute6 := l_db_mstv_rec.attribute6;
1881: END IF;
1882: IF (x_mstv_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 1882: IF (x_mstv_rec.attribute7 = OKL_API.G_MISS_CHAR)

1878: IF (x_mstv_rec.attribute6 = OKL_API.G_MISS_CHAR)
1879: THEN
1880: x_mstv_rec.attribute6 := l_db_mstv_rec.attribute6;
1881: END IF;
1882: IF (x_mstv_rec.attribute7 = OKL_API.G_MISS_CHAR)
1883: THEN
1884: x_mstv_rec.attribute7 := l_db_mstv_rec.attribute7;
1885: END IF;
1886: IF (x_mstv_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 1886: IF (x_mstv_rec.attribute8 = OKL_API.G_MISS_CHAR)

1882: IF (x_mstv_rec.attribute7 = OKL_API.G_MISS_CHAR)
1883: THEN
1884: x_mstv_rec.attribute7 := l_db_mstv_rec.attribute7;
1885: END IF;
1886: IF (x_mstv_rec.attribute8 = OKL_API.G_MISS_CHAR)
1887: THEN
1888: x_mstv_rec.attribute8 := l_db_mstv_rec.attribute8;
1889: END IF;
1890: IF (x_mstv_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 1890: IF (x_mstv_rec.attribute9 = OKL_API.G_MISS_CHAR)

1886: IF (x_mstv_rec.attribute8 = OKL_API.G_MISS_CHAR)
1887: THEN
1888: x_mstv_rec.attribute8 := l_db_mstv_rec.attribute8;
1889: END IF;
1890: IF (x_mstv_rec.attribute9 = OKL_API.G_MISS_CHAR)
1891: THEN
1892: x_mstv_rec.attribute9 := l_db_mstv_rec.attribute9;
1893: END IF;
1894: IF (x_mstv_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 1894: IF (x_mstv_rec.attribute10 = OKL_API.G_MISS_CHAR)

1890: IF (x_mstv_rec.attribute9 = OKL_API.G_MISS_CHAR)
1891: THEN
1892: x_mstv_rec.attribute9 := l_db_mstv_rec.attribute9;
1893: END IF;
1894: IF (x_mstv_rec.attribute10 = OKL_API.G_MISS_CHAR)
1895: THEN
1896: x_mstv_rec.attribute10 := l_db_mstv_rec.attribute10;
1897: END IF;
1898: IF (x_mstv_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 1898: IF (x_mstv_rec.attribute11 = OKL_API.G_MISS_CHAR)

1894: IF (x_mstv_rec.attribute10 = OKL_API.G_MISS_CHAR)
1895: THEN
1896: x_mstv_rec.attribute10 := l_db_mstv_rec.attribute10;
1897: END IF;
1898: IF (x_mstv_rec.attribute11 = OKL_API.G_MISS_CHAR)
1899: THEN
1900: x_mstv_rec.attribute11 := l_db_mstv_rec.attribute11;
1901: END IF;
1902: IF (x_mstv_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 1902: IF (x_mstv_rec.attribute12 = OKL_API.G_MISS_CHAR)

1898: IF (x_mstv_rec.attribute11 = OKL_API.G_MISS_CHAR)
1899: THEN
1900: x_mstv_rec.attribute11 := l_db_mstv_rec.attribute11;
1901: END IF;
1902: IF (x_mstv_rec.attribute12 = OKL_API.G_MISS_CHAR)
1903: THEN
1904: x_mstv_rec.attribute12 := l_db_mstv_rec.attribute12;
1905: END IF;
1906: IF (x_mstv_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 1906: IF (x_mstv_rec.attribute13 = OKL_API.G_MISS_CHAR)

1902: IF (x_mstv_rec.attribute12 = OKL_API.G_MISS_CHAR)
1903: THEN
1904: x_mstv_rec.attribute12 := l_db_mstv_rec.attribute12;
1905: END IF;
1906: IF (x_mstv_rec.attribute13 = OKL_API.G_MISS_CHAR)
1907: THEN
1908: x_mstv_rec.attribute13 := l_db_mstv_rec.attribute13;
1909: END IF;
1910: IF (x_mstv_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 1910: IF (x_mstv_rec.attribute14 = OKL_API.G_MISS_CHAR)

1906: IF (x_mstv_rec.attribute13 = OKL_API.G_MISS_CHAR)
1907: THEN
1908: x_mstv_rec.attribute13 := l_db_mstv_rec.attribute13;
1909: END IF;
1910: IF (x_mstv_rec.attribute14 = OKL_API.G_MISS_CHAR)
1911: THEN
1912: x_mstv_rec.attribute14 := l_db_mstv_rec.attribute14;
1913: END IF;
1914: IF (x_mstv_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 1914: IF (x_mstv_rec.attribute15 = OKL_API.G_MISS_CHAR)

1910: IF (x_mstv_rec.attribute14 = OKL_API.G_MISS_CHAR)
1911: THEN
1912: x_mstv_rec.attribute14 := l_db_mstv_rec.attribute14;
1913: END IF;
1914: IF (x_mstv_rec.attribute15 = OKL_API.G_MISS_CHAR)
1915: THEN
1916: x_mstv_rec.attribute15 := l_db_mstv_rec.attribute15;
1917: END IF;
1918: IF (x_mstv_rec.created_by = OKL_API.G_MISS_NUM)

Line 1918: IF (x_mstv_rec.created_by = OKL_API.G_MISS_NUM)

1914: IF (x_mstv_rec.attribute15 = OKL_API.G_MISS_CHAR)
1915: THEN
1916: x_mstv_rec.attribute15 := l_db_mstv_rec.attribute15;
1917: END IF;
1918: IF (x_mstv_rec.created_by = OKL_API.G_MISS_NUM)
1919: THEN
1920: x_mstv_rec.created_by := l_db_mstv_rec.created_by;
1921: END IF;
1922: IF (x_mstv_rec.creation_date = OKL_API.G_MISS_DATE)

Line 1922: IF (x_mstv_rec.creation_date = OKL_API.G_MISS_DATE)

1918: IF (x_mstv_rec.created_by = OKL_API.G_MISS_NUM)
1919: THEN
1920: x_mstv_rec.created_by := l_db_mstv_rec.created_by;
1921: END IF;
1922: IF (x_mstv_rec.creation_date = OKL_API.G_MISS_DATE)
1923: THEN
1924: x_mstv_rec.creation_date := l_db_mstv_rec.creation_date;
1925: END IF;
1926: IF (x_mstv_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 1926: IF (x_mstv_rec.last_updated_by = OKL_API.G_MISS_NUM)

1922: IF (x_mstv_rec.creation_date = OKL_API.G_MISS_DATE)
1923: THEN
1924: x_mstv_rec.creation_date := l_db_mstv_rec.creation_date;
1925: END IF;
1926: IF (x_mstv_rec.last_updated_by = OKL_API.G_MISS_NUM)
1927: THEN
1928: x_mstv_rec.last_updated_by := l_db_mstv_rec.last_updated_by;
1929: END IF;
1930: IF (x_mstv_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 1930: IF (x_mstv_rec.last_update_date = OKL_API.G_MISS_DATE)

1926: IF (x_mstv_rec.last_updated_by = OKL_API.G_MISS_NUM)
1927: THEN
1928: x_mstv_rec.last_updated_by := l_db_mstv_rec.last_updated_by;
1929: END IF;
1930: IF (x_mstv_rec.last_update_date = OKL_API.G_MISS_DATE)
1931: THEN
1932: x_mstv_rec.last_update_date := l_db_mstv_rec.last_update_date;
1933: END IF;
1934: IF (x_mstv_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 1934: IF (x_mstv_rec.last_update_login = OKL_API.G_MISS_NUM)

1930: IF (x_mstv_rec.last_update_date = OKL_API.G_MISS_DATE)
1931: THEN
1932: x_mstv_rec.last_update_date := l_db_mstv_rec.last_update_date;
1933: END IF;
1934: IF (x_mstv_rec.last_update_login = OKL_API.G_MISS_NUM)
1935: THEN
1936: x_mstv_rec.last_update_login := l_db_mstv_rec.last_update_login;
1937: END IF;
1938: IF (x_mstv_rec.transaction_date = OKL_API.G_MISS_DATE)

Line 1938: IF (x_mstv_rec.transaction_date = OKL_API.G_MISS_DATE)

1934: IF (x_mstv_rec.last_update_login = OKL_API.G_MISS_NUM)
1935: THEN
1936: x_mstv_rec.last_update_login := l_db_mstv_rec.last_update_login;
1937: END IF;
1938: IF (x_mstv_rec.transaction_date = OKL_API.G_MISS_DATE)
1939: THEN
1940: x_mstv_rec.transaction_date := l_db_mstv_rec.transaction_date;
1941: END IF;
1942: END IF;

Line 1952: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1948: FUNCTION Set_Attributes (
1949: p_mstv_rec IN mstv_rec_type,
1950: x_mstv_rec OUT NOCOPY mstv_rec_type
1951: ) RETURN VARCHAR2 IS
1952: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1953: BEGIN
1954: x_mstv_rec := p_mstv_rec;
1955: RETURN(l_return_status);
1956: END Set_Attributes;

Line 1958: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1954: x_mstv_rec := p_mstv_rec;
1955: RETURN(l_return_status);
1956: END Set_Attributes;
1957: BEGIN
1958: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1959: G_PKG_NAME,
1960: p_init_msg_list,
1961: l_api_version,
1962: p_api_version,

Line 1965: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1961: l_api_version,
1962: p_api_version,
1963: '_PVT',
1964: x_return_status);
1965: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1966: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1967: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1968: RAISE OKL_API.G_EXCEPTION_ERROR;
1969: END IF;

Line 1966: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1962: p_api_version,
1963: '_PVT',
1964: x_return_status);
1965: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1966: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1967: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1968: RAISE OKL_API.G_EXCEPTION_ERROR;
1969: END IF;
1970: --- Setting item attributes

Line 1967: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1963: '_PVT',
1964: x_return_status);
1965: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1966: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1967: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1968: RAISE OKL_API.G_EXCEPTION_ERROR;
1969: END IF;
1970: --- Setting item attributes
1971: l_return_status := Set_Attributes(

Line 1968: RAISE OKL_API.G_EXCEPTION_ERROR;

1964: x_return_status);
1965: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1966: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1967: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1968: RAISE OKL_API.G_EXCEPTION_ERROR;
1969: END IF;
1970: --- Setting item attributes
1971: l_return_status := Set_Attributes(
1972: p_mstv_rec, -- IN

Line 1975: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1971: l_return_status := Set_Attributes(
1972: p_mstv_rec, -- IN
1973: x_mstv_rec); -- OUT
1974: --- If any errors happen abort API
1975: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1976: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1977: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1978: RAISE OKL_API.G_EXCEPTION_ERROR;
1979: END IF;

Line 1976: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1972: p_mstv_rec, -- IN
1973: x_mstv_rec); -- OUT
1974: --- If any errors happen abort API
1975: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1976: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1977: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1978: RAISE OKL_API.G_EXCEPTION_ERROR;
1979: END IF;
1980: l_return_status := populate_new_record(l_mstv_rec, l_def_mstv_rec);

Line 1977: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1973: x_mstv_rec); -- OUT
1974: --- If any errors happen abort API
1975: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1976: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1977: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1978: RAISE OKL_API.G_EXCEPTION_ERROR;
1979: END IF;
1980: l_return_status := populate_new_record(l_mstv_rec, l_def_mstv_rec);
1981: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1978: RAISE OKL_API.G_EXCEPTION_ERROR;

1974: --- If any errors happen abort API
1975: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1976: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1977: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1978: RAISE OKL_API.G_EXCEPTION_ERROR;
1979: END IF;
1980: l_return_status := populate_new_record(l_mstv_rec, l_def_mstv_rec);
1981: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1981: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1977: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1978: RAISE OKL_API.G_EXCEPTION_ERROR;
1979: END IF;
1980: l_return_status := populate_new_record(l_mstv_rec, l_def_mstv_rec);
1981: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1983: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1984: RAISE OKL_API.G_EXCEPTION_ERROR;
1985: END IF;

Line 1982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1978: RAISE OKL_API.G_EXCEPTION_ERROR;
1979: END IF;
1980: l_return_status := populate_new_record(l_mstv_rec, l_def_mstv_rec);
1981: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1983: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1984: RAISE OKL_API.G_EXCEPTION_ERROR;
1985: END IF;
1986: l_def_mstv_rec := fill_who_columns(l_def_mstv_rec);

Line 1983: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1979: END IF;
1980: l_return_status := populate_new_record(l_mstv_rec, l_def_mstv_rec);
1981: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1983: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1984: RAISE OKL_API.G_EXCEPTION_ERROR;
1985: END IF;
1986: l_def_mstv_rec := fill_who_columns(l_def_mstv_rec);
1987: --- Validate all non-missing attributes (Item Level Validation)

Line 1984: RAISE OKL_API.G_EXCEPTION_ERROR;

1980: l_return_status := populate_new_record(l_mstv_rec, l_def_mstv_rec);
1981: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1983: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1984: RAISE OKL_API.G_EXCEPTION_ERROR;
1985: END IF;
1986: l_def_mstv_rec := fill_who_columns(l_def_mstv_rec);
1987: --- Validate all non-missing attributes (Item Level Validation)
1988: l_return_status := Validate_Attributes(l_def_mstv_rec);

Line 1990: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1986: l_def_mstv_rec := fill_who_columns(l_def_mstv_rec);
1987: --- Validate all non-missing attributes (Item Level Validation)
1988: l_return_status := Validate_Attributes(l_def_mstv_rec);
1989: --- If any errors happen abort API
1990: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1992: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1993: RAISE OKL_API.G_EXCEPTION_ERROR;
1994: END IF;

Line 1991: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1987: --- Validate all non-missing attributes (Item Level Validation)
1988: l_return_status := Validate_Attributes(l_def_mstv_rec);
1989: --- If any errors happen abort API
1990: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1992: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1993: RAISE OKL_API.G_EXCEPTION_ERROR;
1994: END IF;
1995: l_return_status := Validate_Record(l_def_mstv_rec, l_db_mstv_rec);

Line 1992: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1988: l_return_status := Validate_Attributes(l_def_mstv_rec);
1989: --- If any errors happen abort API
1990: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1992: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1993: RAISE OKL_API.G_EXCEPTION_ERROR;
1994: END IF;
1995: l_return_status := Validate_Record(l_def_mstv_rec, l_db_mstv_rec);
1996: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1993: RAISE OKL_API.G_EXCEPTION_ERROR;

1989: --- If any errors happen abort API
1990: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1992: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1993: RAISE OKL_API.G_EXCEPTION_ERROR;
1994: END IF;
1995: l_return_status := Validate_Record(l_def_mstv_rec, l_db_mstv_rec);
1996: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1996: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1992: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1993: RAISE OKL_API.G_EXCEPTION_ERROR;
1994: END IF;
1995: l_return_status := Validate_Record(l_def_mstv_rec, l_db_mstv_rec);
1996: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1998: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1999: RAISE OKL_API.G_EXCEPTION_ERROR;
2000: END IF;

Line 1997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1993: RAISE OKL_API.G_EXCEPTION_ERROR;
1994: END IF;
1995: l_return_status := Validate_Record(l_def_mstv_rec, l_db_mstv_rec);
1996: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1998: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1999: RAISE OKL_API.G_EXCEPTION_ERROR;
2000: END IF;
2001:

Line 1998: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1994: END IF;
1995: l_return_status := Validate_Record(l_def_mstv_rec, l_db_mstv_rec);
1996: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1998: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1999: RAISE OKL_API.G_EXCEPTION_ERROR;
2000: END IF;
2001:
2002: -----------------------------------------

Line 1999: RAISE OKL_API.G_EXCEPTION_ERROR;

1995: l_return_status := Validate_Record(l_def_mstv_rec, l_db_mstv_rec);
1996: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1998: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1999: RAISE OKL_API.G_EXCEPTION_ERROR;
2000: END IF;
2001:
2002: -----------------------------------------
2003: -- Move VIEW record to "Child" records --

Line 2017: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2013: x_msg_data,
2014: l_mst_rec,
2015: lx_mst_rec
2016: );
2017: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2018: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2019: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2020: RAISE OKL_API.G_EXCEPTION_ERROR;
2021: END IF;

Line 2018: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2014: l_mst_rec,
2015: lx_mst_rec
2016: );
2017: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2018: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2019: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2020: RAISE OKL_API.G_EXCEPTION_ERROR;
2021: END IF;
2022: migrate(lx_mst_rec, l_def_mstv_rec);

Line 2019: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2015: lx_mst_rec
2016: );
2017: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2018: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2019: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2020: RAISE OKL_API.G_EXCEPTION_ERROR;
2021: END IF;
2022: migrate(lx_mst_rec, l_def_mstv_rec);
2023: x_mstv_rec := l_def_mstv_rec;

Line 2020: RAISE OKL_API.G_EXCEPTION_ERROR;

2016: );
2017: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2018: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2019: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2020: RAISE OKL_API.G_EXCEPTION_ERROR;
2021: END IF;
2022: migrate(lx_mst_rec, l_def_mstv_rec);
2023: x_mstv_rec := l_def_mstv_rec;
2024: x_return_status := l_return_status;

Line 2025: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2021: END IF;
2022: migrate(lx_mst_rec, l_def_mstv_rec);
2023: x_mstv_rec := l_def_mstv_rec;
2024: x_return_status := l_return_status;
2025: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2026: EXCEPTION
2027: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2028: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2029: (

Line 2027: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2023: x_mstv_rec := l_def_mstv_rec;
2024: x_return_status := l_return_status;
2025: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2026: EXCEPTION
2027: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2028: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2029: (
2030: l_api_name,
2031: G_PKG_NAME,

Line 2028: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2024: x_return_status := l_return_status;
2025: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2026: EXCEPTION
2027: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2028: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2029: (
2030: l_api_name,
2031: G_PKG_NAME,
2032: 'OKL_API.G_RET_STS_ERROR',

Line 2032: 'OKL_API.G_RET_STS_ERROR',

2028: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2029: (
2030: l_api_name,
2031: G_PKG_NAME,
2032: 'OKL_API.G_RET_STS_ERROR',
2033: x_msg_count,
2034: x_msg_data,
2035: '_PVT'
2036: );

Line 2037: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2033: x_msg_count,
2034: x_msg_data,
2035: '_PVT'
2036: );
2037: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2038: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2039: (
2040: l_api_name,
2041: G_PKG_NAME,

Line 2038: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2042: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2038: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2039: (
2040: l_api_name,
2041: G_PKG_NAME,
2042: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2043: x_msg_count,
2044: x_msg_data,
2045: '_PVT'
2046: );

Line 2048: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2044: x_msg_data,
2045: '_PVT'
2046: );
2047: WHEN OTHERS THEN
2048: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2049: (
2050: l_api_name,
2051: G_PKG_NAME,
2052: 'OTHERS',

Line 2073: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2069:
2070: l_api_version CONSTANT NUMBER := 1;
2071: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2072: i NUMBER := 0;
2073: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2074: BEGIN
2075: OKL_API.init_msg_list(p_init_msg_list);
2076: -- Make sure PL/SQL table has records in it before passing
2077: IF (p_mstv_tbl.COUNT > 0) THEN

Line 2075: OKL_API.init_msg_list(p_init_msg_list);

2071: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2072: i NUMBER := 0;
2073: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2074: BEGIN
2075: OKL_API.init_msg_list(p_init_msg_list);
2076: -- Make sure PL/SQL table has records in it before passing
2077: IF (p_mstv_tbl.COUNT > 0) THEN
2078: i := p_mstv_tbl.FIRST;
2079: LOOP

Line 2082: p_init_msg_list => OKL_API.G_FALSE,

2078: i := p_mstv_tbl.FIRST;
2079: LOOP
2080: update_row (
2081: p_api_version => p_api_version,
2082: p_init_msg_list => OKL_API.G_FALSE,
2083: x_return_status => x_return_status,
2084: x_msg_count => x_msg_count,
2085: x_msg_data => x_msg_data,
2086: p_mstv_rec => p_mstv_tbl(i),

Line 2089: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2085: x_msg_data => x_msg_data,
2086: p_mstv_rec => p_mstv_tbl(i),
2087: x_mstv_rec => x_mstv_tbl(i));
2088:
2089: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2090: l_final_status := x_return_status;
2091: END IF;
2092:
2093: EXIT WHEN (i = p_mstv_tbl.LAST);

Line 2099: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2095: END LOOP;
2096: END IF;
2097:
2098: x_return_status := l_final_status;
2099: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2100:
2101: EXCEPTION
2102: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2103: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 2102: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2098: x_return_status := l_final_status;
2099: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2100:
2101: EXCEPTION
2102: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2103: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2104: (
2105: l_api_name,
2106: G_PKG_NAME,

Line 2103: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2099: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2100:
2101: EXCEPTION
2102: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2103: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2104: (
2105: l_api_name,
2106: G_PKG_NAME,
2107: 'OKL_API.G_RET_STS_ERROR',

Line 2107: 'OKL_API.G_RET_STS_ERROR',

2103: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2104: (
2105: l_api_name,
2106: G_PKG_NAME,
2107: 'OKL_API.G_RET_STS_ERROR',
2108: x_msg_count,
2109: x_msg_data,
2110: '_PVT'
2111: );

Line 2112: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2108: x_msg_count,
2109: x_msg_data,
2110: '_PVT'
2111: );
2112: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2113: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2114: (
2115: l_api_name,
2116: G_PKG_NAME,

Line 2113: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2109: x_msg_data,
2110: '_PVT'
2111: );
2112: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2113: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2114: (
2115: l_api_name,
2116: G_PKG_NAME,
2117: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2117: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2123: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2119: x_msg_data,
2120: '_PVT'
2121: );
2122: WHEN OTHERS THEN
2123: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2124: (
2125: l_api_name,
2126: G_PKG_NAME,
2127: 'OTHERS',

Line 2141: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2137: ----------------------------------------------
2138: -- delete_row for:OKL_RBK_SELECTED_CONTRACT --
2139: ----------------------------------------------
2140: PROCEDURE delete_row(
2141: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2142: x_return_status OUT NOCOPY VARCHAR2,
2143: x_msg_count OUT NOCOPY NUMBER,
2144: x_msg_data OUT NOCOPY VARCHAR2,
2145: p_mst_rec IN mst_rec_type) IS

Line 2149: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2145: p_mst_rec IN mst_rec_type) IS
2146:
2147: l_api_version CONSTANT NUMBER := 1;
2148: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2149: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2150: l_mst_rec mst_rec_type := p_mst_rec;
2151: l_row_notfound BOOLEAN := TRUE;
2152: BEGIN
2153: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2153: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

2149: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2150: l_mst_rec mst_rec_type := p_mst_rec;
2151: l_row_notfound BOOLEAN := TRUE;
2152: BEGIN
2153: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2154: p_init_msg_list,
2155: '_PVT',
2156: x_return_status);
2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2153: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2154: p_init_msg_list,
2155: '_PVT',
2156: x_return_status);
2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;

Line 2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2154: p_init_msg_list,
2155: '_PVT',
2156: x_return_status);
2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;
2162:

Line 2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2155: '_PVT',
2156: x_return_status);
2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;
2162:
2163: DELETE FROM OKL_RBK_SELECTED_CONTRACT

Line 2160: RAISE OKL_API.G_EXCEPTION_ERROR;

2156: x_return_status);
2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;
2162:
2163: DELETE FROM OKL_RBK_SELECTED_CONTRACT
2164: WHERE ID = p_mst_rec.id;

Line 2167: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2163: DELETE FROM OKL_RBK_SELECTED_CONTRACT
2164: WHERE ID = p_mst_rec.id;
2165:
2166: x_return_status := l_return_status;
2167: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2168: EXCEPTION
2169: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2170: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2171: (

Line 2169: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2165:
2166: x_return_status := l_return_status;
2167: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2168: EXCEPTION
2169: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2170: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2171: (
2172: l_api_name,
2173: G_PKG_NAME,

Line 2170: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2166: x_return_status := l_return_status;
2167: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2168: EXCEPTION
2169: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2170: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2171: (
2172: l_api_name,
2173: G_PKG_NAME,
2174: 'OKL_API.G_RET_STS_ERROR',

Line 2174: 'OKL_API.G_RET_STS_ERROR',

2170: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2171: (
2172: l_api_name,
2173: G_PKG_NAME,
2174: 'OKL_API.G_RET_STS_ERROR',
2175: x_msg_count,
2176: x_msg_data,
2177: '_PVT'
2178: );

Line 2179: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2175: x_msg_count,
2176: x_msg_data,
2177: '_PVT'
2178: );
2179: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2180: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2181: (
2182: l_api_name,
2183: G_PKG_NAME,

Line 2180: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2176: x_msg_data,
2177: '_PVT'
2178: );
2179: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2180: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2181: (
2182: l_api_name,
2183: G_PKG_NAME,
2184: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2184: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2180: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2181: (
2182: l_api_name,
2183: G_PKG_NAME,
2184: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2185: x_msg_count,
2186: x_msg_data,
2187: '_PVT'
2188: );

Line 2190: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2186: x_msg_data,
2187: '_PVT'
2188: );
2189: WHEN OTHERS THEN
2190: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2191: (
2192: l_api_name,
2193: G_PKG_NAME,
2194: 'OTHERS',

Line 2214: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2210: p_mstv_rec IN mstv_rec_type) IS
2211:
2212: l_api_version CONSTANT NUMBER := 1;
2213: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2214: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2215: l_mstv_rec mstv_rec_type := p_mstv_rec;
2216: l_mst_rec mst_rec_type;
2217: BEGIN
2218: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2218: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

2214: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2215: l_mstv_rec mstv_rec_type := p_mstv_rec;
2216: l_mst_rec mst_rec_type;
2217: BEGIN
2218: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2219: G_PKG_NAME,
2220: p_init_msg_list,
2221: l_api_version,
2222: p_api_version,

Line 2225: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2221: l_api_version,
2222: p_api_version,
2223: '_PVT',
2224: x_return_status);
2225: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2227: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2228: RAISE OKL_API.G_EXCEPTION_ERROR;
2229: END IF;

Line 2226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2222: p_api_version,
2223: '_PVT',
2224: x_return_status);
2225: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2227: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2228: RAISE OKL_API.G_EXCEPTION_ERROR;
2229: END IF;
2230: -----------------------------------------

Line 2227: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2223: '_PVT',
2224: x_return_status);
2225: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2227: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2228: RAISE OKL_API.G_EXCEPTION_ERROR;
2229: END IF;
2230: -----------------------------------------
2231: -- Move VIEW record to "Child" records --

Line 2228: RAISE OKL_API.G_EXCEPTION_ERROR;

2224: x_return_status);
2225: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2227: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2228: RAISE OKL_API.G_EXCEPTION_ERROR;
2229: END IF;
2230: -----------------------------------------
2231: -- Move VIEW record to "Child" records --
2232: -----------------------------------------

Line 2244: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2240: x_msg_count,
2241: x_msg_data,
2242: l_mst_rec
2243: );
2244: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_ERROR;
2248: END IF;

Line 2245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2241: x_msg_data,
2242: l_mst_rec
2243: );
2244: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_ERROR;
2248: END IF;
2249: x_return_status := l_return_status;

Line 2246: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2242: l_mst_rec
2243: );
2244: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_ERROR;
2248: END IF;
2249: x_return_status := l_return_status;
2250: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2247: RAISE OKL_API.G_EXCEPTION_ERROR;

2243: );
2244: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_ERROR;
2248: END IF;
2249: x_return_status := l_return_status;
2250: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2251: EXCEPTION

Line 2250: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2246: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_ERROR;
2248: END IF;
2249: x_return_status := l_return_status;
2250: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2251: EXCEPTION
2252: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2253: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2254: (

Line 2252: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2248: END IF;
2249: x_return_status := l_return_status;
2250: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2251: EXCEPTION
2252: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2253: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2254: (
2255: l_api_name,
2256: G_PKG_NAME,

Line 2253: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2249: x_return_status := l_return_status;
2250: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2251: EXCEPTION
2252: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2253: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2254: (
2255: l_api_name,
2256: G_PKG_NAME,
2257: 'OKL_API.G_RET_STS_ERROR',

Line 2257: 'OKL_API.G_RET_STS_ERROR',

2253: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2254: (
2255: l_api_name,
2256: G_PKG_NAME,
2257: 'OKL_API.G_RET_STS_ERROR',
2258: x_msg_count,
2259: x_msg_data,
2260: '_PVT'
2261: );

Line 2262: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2258: x_msg_count,
2259: x_msg_data,
2260: '_PVT'
2261: );
2262: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2263: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2264: (
2265: l_api_name,
2266: G_PKG_NAME,

Line 2263: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2267: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2263: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2264: (
2265: l_api_name,
2266: G_PKG_NAME,
2267: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2268: x_msg_count,
2269: x_msg_data,
2270: '_PVT'
2271: );

Line 2273: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2269: x_msg_data,
2270: '_PVT'
2271: );
2272: WHEN OTHERS THEN
2273: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2274: (
2275: l_api_name,
2276: G_PKG_NAME,
2277: 'OTHERS',

Line 2298: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2294:
2295: l_api_version CONSTANT NUMBER := 1;
2296: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2297: i NUMBER := 0;
2298: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2299: BEGIN
2300: OKL_API.init_msg_list(p_init_msg_list);
2301: -- Make sure PL/SQL table has records in it before passing
2302: IF (p_mstv_tbl.COUNT > 0) THEN

Line 2300: OKL_API.init_msg_list(p_init_msg_list);

2296: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2297: i NUMBER := 0;
2298: l_final_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2299: BEGIN
2300: OKL_API.init_msg_list(p_init_msg_list);
2301: -- Make sure PL/SQL table has records in it before passing
2302: IF (p_mstv_tbl.COUNT > 0) THEN
2303: i := p_mstv_tbl.FIRST;
2304: LOOP

Line 2307: p_init_msg_list => OKL_API.G_FALSE,

2303: i := p_mstv_tbl.FIRST;
2304: LOOP
2305: delete_row (
2306: p_api_version => p_api_version,
2307: p_init_msg_list => OKL_API.G_FALSE,
2308: x_return_status => x_return_status,
2309: x_msg_count => x_msg_count,
2310: x_msg_data => x_msg_data,
2311: p_mstv_rec => p_mstv_tbl(i));

Line 2313: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2309: x_msg_count => x_msg_count,
2310: x_msg_data => x_msg_data,
2311: p_mstv_rec => p_mstv_tbl(i));
2312:
2313: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2314: l_final_status := x_return_status;
2315: END IF;
2316:
2317: EXIT WHEN (i = p_mstv_tbl.LAST);

Line 2323: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2319: END LOOP;
2320: END IF;
2321:
2322: x_return_status := l_final_status;
2323: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2324:
2325: EXCEPTION
2326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2327: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 2326: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2322: x_return_status := l_final_status;
2323: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2324:
2325: EXCEPTION
2326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2327: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2328: (
2329: l_api_name,
2330: G_PKG_NAME,

Line 2327: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2323: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2324:
2325: EXCEPTION
2326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2327: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2328: (
2329: l_api_name,
2330: G_PKG_NAME,
2331: 'OKL_API.G_RET_STS_ERROR',

Line 2331: 'OKL_API.G_RET_STS_ERROR',

2327: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2328: (
2329: l_api_name,
2330: G_PKG_NAME,
2331: 'OKL_API.G_RET_STS_ERROR',
2332: x_msg_count,
2333: x_msg_data,
2334: '_PVT'
2335: );

Line 2336: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2332: x_msg_count,
2333: x_msg_data,
2334: '_PVT'
2335: );
2336: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2337: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2338: (
2339: l_api_name,
2340: G_PKG_NAME,

Line 2337: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2333: x_msg_data,
2334: '_PVT'
2335: );
2336: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2337: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2338: (
2339: l_api_name,
2340: G_PKG_NAME,
2341: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2341: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2337: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2338: (
2339: l_api_name,
2340: G_PKG_NAME,
2341: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2342: x_msg_count,
2343: x_msg_data,
2344: '_PVT'
2345: );

Line 2347: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2343: x_msg_data,
2344: '_PVT'
2345: );
2346: WHEN OTHERS THEN
2347: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2348: (
2349: l_api_name,
2350: G_PKG_NAME,
2351: 'OTHERS',