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_SPM_PVT dependencies on OKL_API

Line 174: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

170: ----------------------------------------------
171: FUNCTION validate_record (
172: p_spmv_rec IN spmv_rec_type
173: ) RETURN VARCHAR2 IS
174: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
175: BEGIN
176: RETURN (l_return_status);
177: END validate_record;
178:

Line 199: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

195:
196:
197: BEGIN
198: -- initialize return status
199: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
200:
201: IF p_spmv_rec.id = Okl_Api.G_MISS_NUM OR
202: p_spmv_rec.id IS NULL
203: THEN

Line 201: IF p_spmv_rec.id = Okl_Api.G_MISS_NUM OR

197: BEGIN
198: -- initialize return status
199: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
200:
201: IF p_spmv_rec.id = Okl_Api.G_MISS_NUM OR
202: p_spmv_rec.id IS NULL
203: THEN
204: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
205: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 204: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

200:
201: IF p_spmv_rec.id = Okl_Api.G_MISS_NUM OR
202: p_spmv_rec.id IS NULL
203: THEN
204: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
205: x_return_status := Okl_Api.G_RET_STS_ERROR;
206: RAISE G_EXCEPTION_HALT_VALIDATION;
207: END IF;
208:

Line 205: x_return_status := Okl_Api.G_RET_STS_ERROR;

201: IF p_spmv_rec.id = Okl_Api.G_MISS_NUM OR
202: p_spmv_rec.id IS NULL
203: THEN
204: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
205: x_return_status := Okl_Api.G_RET_STS_ERROR;
206: RAISE G_EXCEPTION_HALT_VALIDATION;
207: END IF;
208:
209: EXCEPTION

Line 217: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME

213: NULL;
214:
215: WHEN OTHERS THEN
216: -- store SQL error message on message stack for caller
217: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME
218: ,p_msg_name => G_UNEXPECTED_ERROR
219: ,p_token1 => G_SQLCODE_TOKEN
220: ,p_token1_value => SQLCODE
221: ,p_token2 => G_SQLERRM_TOKEN

Line 225: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

221: ,p_token2 => G_SQLERRM_TOKEN
222: ,p_token2_value => SQLERRM);
223:
224: -- notify caller of an UNEXPECTED error
225: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
226:
227: END Validate_Id;
228:
229: ---------------------------------------------------------------------------

Line 249: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

245:
246: BEGIN
247:
248: -- initialize return status
249: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
250:
251: IF p_spmv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
252: p_spmv_rec.object_version_number IS NULL
253: THEN

Line 251: IF p_spmv_rec.object_version_number = Okl_Api.G_MISS_NUM OR

247:
248: -- initialize return status
249: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
250:
251: IF p_spmv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
252: p_spmv_rec.object_version_number IS NULL
253: THEN
254: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
255: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 254: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

250:
251: IF p_spmv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
252: p_spmv_rec.object_version_number IS NULL
253: THEN
254: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
255: x_return_status := Okl_Api.G_RET_STS_ERROR;
256: RAISE G_EXCEPTION_HALT_VALIDATION;
257: END IF;
258:

Line 255: x_return_status := Okl_Api.G_RET_STS_ERROR;

251: IF p_spmv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
252: p_spmv_rec.object_version_number IS NULL
253: THEN
254: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
255: x_return_status := Okl_Api.G_RET_STS_ERROR;
256: RAISE G_EXCEPTION_HALT_VALIDATION;
257: END IF;
258:
259: EXCEPTION

Line 267: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME

263: NULL;
264:
265: WHEN OTHERS THEN
266: -- store SQL error message on message stack for caller
267: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME
268: ,p_msg_name => G_UNEXPECTED_ERROR
269: ,p_token1 => G_SQLCODE_TOKEN
270: ,p_token1_value => SQLCODE
271: ,p_token2 => G_SQLERRM_TOKEN

Line 275: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

271: ,p_token2 => G_SQLERRM_TOKEN
272: ,p_token2_value => SQLERRM);
273:
274: -- notify caller of an UNEXPECTED error
275: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
276:
277: END Validate_Object_Version_Number;
278:
279: ---------------------------------------------------------------------------

Line 299: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

295:
296: BEGIN
297:
298: -- initialize return status
299: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
300:
301: IF p_spmv_rec.khr_id = Okl_Api.G_MISS_NUM OR
302: p_spmv_rec.khr_id IS NULL
303: THEN

Line 301: IF p_spmv_rec.khr_id = Okl_Api.G_MISS_NUM OR

297:
298: -- initialize return status
299: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
300:
301: IF p_spmv_rec.khr_id = Okl_Api.G_MISS_NUM OR
302: p_spmv_rec.khr_id IS NULL
303: THEN
304: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'khr_id');
305: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 304: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'khr_id');

300:
301: IF p_spmv_rec.khr_id = Okl_Api.G_MISS_NUM OR
302: p_spmv_rec.khr_id IS NULL
303: THEN
304: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'khr_id');
305: x_return_status := Okl_Api.G_RET_STS_ERROR;
306: RAISE G_EXCEPTION_HALT_VALIDATION;
307: END IF;
308:

Line 305: x_return_status := Okl_Api.G_RET_STS_ERROR;

301: IF p_spmv_rec.khr_id = Okl_Api.G_MISS_NUM OR
302: p_spmv_rec.khr_id IS NULL
303: THEN
304: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'khr_id');
305: x_return_status := Okl_Api.G_RET_STS_ERROR;
306: RAISE G_EXCEPTION_HALT_VALIDATION;
307: END IF;
308:
309: EXCEPTION

Line 317: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME

313: NULL;
314:
315: WHEN OTHERS THEN
316: -- store SQL error message on message stack for caller
317: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME
318: ,p_msg_name => G_UNEXPECTED_ERROR
319: ,p_token1 => G_SQLCODE_TOKEN
320: ,p_token1_value => SQLCODE
321: ,p_token2 => G_SQLERRM_TOKEN

Line 325: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

321: ,p_token2 => G_SQLERRM_TOKEN
322: ,p_token2_value => SQLERRM);
323:
324: -- notify caller of an UNEXPECTED error
325: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
326:
327: END validate_khr_id;
328:
329: ---------------------------------------------------------------------------

Line 346: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

342: FUNCTION Validate_Attributes (
343: p_spmv_rec IN spmv_rec_type
344: ) RETURN VARCHAR2 IS
345:
346: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
347: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
348: BEGIN
349: -- call each column-level validation
350: -- Validate_Id

Line 347: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

343: p_spmv_rec IN spmv_rec_type
344: ) RETURN VARCHAR2 IS
345:
346: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
347: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
348: BEGIN
349: -- call each column-level validation
350: -- Validate_Id
351: Validate_Id(p_spmv_rec, x_return_status);

Line 352: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

348: BEGIN
349: -- call each column-level validation
350: -- Validate_Id
351: Validate_Id(p_spmv_rec, x_return_status);
352: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
353: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
354: -- need to exit
355: l_return_status := x_return_status;
356: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 353: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

349: -- call each column-level validation
350: -- Validate_Id
351: Validate_Id(p_spmv_rec, x_return_status);
352: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
353: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
354: -- need to exit
355: l_return_status := x_return_status;
356: RAISE G_EXCEPTION_HALT_VALIDATION;
357: ELSE

Line 365: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

361: END IF;
362:
363: -- Validate_Object_Version_Number
364: validate_object_version_number(p_spmv_rec, x_return_status);
365: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
366: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
367: -- need to exit
368: l_return_status := x_return_status;
369: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 366: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

362:
363: -- Validate_Object_Version_Number
364: validate_object_version_number(p_spmv_rec, x_return_status);
365: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
366: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
367: -- need to exit
368: l_return_status := x_return_status;
369: RAISE G_EXCEPTION_HALT_VALIDATION;
370: ELSE

Line 378: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

374: END IF;
375:
376: -- Validate_khr_id
377: validate_khr_id(p_spmv_rec, x_return_status);
378: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
379: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
380: -- need to exit
381: l_return_status := x_return_status;
382: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 379: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

375:
376: -- Validate_khr_id
377: validate_khr_id(p_spmv_rec, x_return_status);
378: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
379: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
380: -- need to exit
381: l_return_status := x_return_status;
382: RAISE G_EXCEPTION_HALT_VALIDATION;
383: ELSE

Line 409: IF (l_spmv_rec.id = Okl_Api.G_MISS_NUM) THEN

405: p_spmv_rec IN spmv_rec_type
406: ) RETURN spmv_rec_type IS
407: l_spmv_rec spmv_rec_type := p_spmv_rec;
408: BEGIN
409: IF (l_spmv_rec.id = Okl_Api.G_MISS_NUM) THEN
410: l_spmv_rec.id := NULL;
411: END IF;
412: IF (l_spmv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN
413: l_spmv_rec.object_version_number := NULL;

Line 412: IF (l_spmv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN

408: BEGIN
409: IF (l_spmv_rec.id = Okl_Api.G_MISS_NUM) THEN
410: l_spmv_rec.id := NULL;
411: END IF;
412: IF (l_spmv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN
413: l_spmv_rec.object_version_number := NULL;
414: END IF;
415: IF (l_spmv_rec.khr_id = Okl_Api.G_MISS_NUM) THEN
416: l_spmv_rec.khr_id := NULL;

Line 415: IF (l_spmv_rec.khr_id = Okl_Api.G_MISS_NUM) THEN

411: END IF;
412: IF (l_spmv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN
413: l_spmv_rec.object_version_number := NULL;
414: END IF;
415: IF (l_spmv_rec.khr_id = Okl_Api.G_MISS_NUM) THEN
416: l_spmv_rec.khr_id := NULL;
417: END IF;
418: IF (l_spmv_rec.sif_id = Okl_Api.G_MISS_NUM) THEN
419: l_spmv_rec.sif_id := NULL;

Line 418: IF (l_spmv_rec.sif_id = Okl_Api.G_MISS_NUM) THEN

414: END IF;
415: IF (l_spmv_rec.khr_id = Okl_Api.G_MISS_NUM) THEN
416: l_spmv_rec.khr_id := NULL;
417: END IF;
418: IF (l_spmv_rec.sif_id = Okl_Api.G_MISS_NUM) THEN
419: l_spmv_rec.sif_id := NULL;
420: END IF;
421: IF (l_spmv_rec.name = Okl_Api.G_MISS_CHAR) THEN
422: l_spmv_rec.name := NULL;

Line 421: IF (l_spmv_rec.name = Okl_Api.G_MISS_CHAR) THEN

417: END IF;
418: IF (l_spmv_rec.sif_id = Okl_Api.G_MISS_NUM) THEN
419: l_spmv_rec.sif_id := NULL;
420: END IF;
421: IF (l_spmv_rec.name = Okl_Api.G_MISS_CHAR) THEN
422: l_spmv_rec.name := NULL;
423: END IF;
424: IF (l_spmv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
425: l_spmv_rec.display_yn := NULL;

Line 424: IF (l_spmv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN

420: END IF;
421: IF (l_spmv_rec.name = Okl_Api.G_MISS_CHAR) THEN
422: l_spmv_rec.name := NULL;
423: END IF;
424: IF (l_spmv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
425: l_spmv_rec.display_yn := NULL;
426: END IF;
427: IF (l_spmv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
428: l_spmv_rec.update_yn := NULL;

Line 427: IF (l_spmv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN

423: END IF;
424: IF (l_spmv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
425: l_spmv_rec.display_yn := NULL;
426: END IF;
427: IF (l_spmv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
428: l_spmv_rec.update_yn := NULL;
429: END IF;
430: IF (l_spmv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
431: l_spmv_rec.default_value := NULL;

Line 430: IF (l_spmv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN

426: END IF;
427: IF (l_spmv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
428: l_spmv_rec.update_yn := NULL;
429: END IF;
430: IF (l_spmv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
431: l_spmv_rec.default_value := NULL;
432: END IF;
433: IF (l_spmv_rec.parameter_value = Okl_Api.G_MISS_CHAR) THEN
434: l_spmv_rec.parameter_value := NULL;

Line 433: IF (l_spmv_rec.parameter_value = Okl_Api.G_MISS_CHAR) THEN

429: END IF;
430: IF (l_spmv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
431: l_spmv_rec.default_value := NULL;
432: END IF;
433: IF (l_spmv_rec.parameter_value = Okl_Api.G_MISS_CHAR) THEN
434: l_spmv_rec.parameter_value := NULL;
435: END IF;
436: IF (l_spmv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
437: l_spmv_rec.prc_eng_ident := NULL;

Line 436: IF (l_spmv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN

432: END IF;
433: IF (l_spmv_rec.parameter_value = Okl_Api.G_MISS_CHAR) THEN
434: l_spmv_rec.parameter_value := NULL;
435: END IF;
436: IF (l_spmv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
437: l_spmv_rec.prc_eng_ident := NULL;
438: END IF;
439: IF (l_spmv_rec.description = Okl_Api.G_MISS_CHAR) THEN
440: l_spmv_rec.description := NULL;

Line 439: IF (l_spmv_rec.description = Okl_Api.G_MISS_CHAR) THEN

435: END IF;
436: IF (l_spmv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
437: l_spmv_rec.prc_eng_ident := NULL;
438: END IF;
439: IF (l_spmv_rec.description = Okl_Api.G_MISS_CHAR) THEN
440: l_spmv_rec.description := NULL;
441: END IF;
442: IF (l_spmv_rec.created_by = Okl_Api.G_MISS_NUM) THEN
443: l_spmv_rec.created_by := NULL;

Line 442: IF (l_spmv_rec.created_by = Okl_Api.G_MISS_NUM) THEN

438: END IF;
439: IF (l_spmv_rec.description = Okl_Api.G_MISS_CHAR) THEN
440: l_spmv_rec.description := NULL;
441: END IF;
442: IF (l_spmv_rec.created_by = Okl_Api.G_MISS_NUM) THEN
443: l_spmv_rec.created_by := NULL;
444: END IF;
445: IF (l_spmv_rec.creation_date = Okl_Api.G_MISS_DATE) THEN
446: l_spmv_rec.creation_date := NULL;

Line 445: IF (l_spmv_rec.creation_date = Okl_Api.G_MISS_DATE) THEN

441: END IF;
442: IF (l_spmv_rec.created_by = Okl_Api.G_MISS_NUM) THEN
443: l_spmv_rec.created_by := NULL;
444: END IF;
445: IF (l_spmv_rec.creation_date = Okl_Api.G_MISS_DATE) THEN
446: l_spmv_rec.creation_date := NULL;
447: END IF;
448: IF (l_spmv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
449: l_spmv_rec.last_updated_by := NULL;

Line 448: IF (l_spmv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN

444: END IF;
445: IF (l_spmv_rec.creation_date = Okl_Api.G_MISS_DATE) THEN
446: l_spmv_rec.creation_date := NULL;
447: END IF;
448: IF (l_spmv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
449: l_spmv_rec.last_updated_by := NULL;
450: END IF;
451: IF (l_spmv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
452: l_spmv_rec.last_update_date := NULL;

Line 451: IF (l_spmv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN

447: END IF;
448: IF (l_spmv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
449: l_spmv_rec.last_updated_by := NULL;
450: END IF;
451: IF (l_spmv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
452: l_spmv_rec.last_update_date := NULL;
453: END IF;
454: IF (l_spmv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
455: l_spmv_rec.last_update_login := NULL;

Line 454: IF (l_spmv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN

450: END IF;
451: IF (l_spmv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
452: l_spmv_rec.last_update_date := NULL;
453: END IF;
454: IF (l_spmv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
455: l_spmv_rec.last_update_login := NULL;
456: END IF;
457:
458: RETURN(l_spmv_rec);

Line 528: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

524: -- Version : 1.0
525: -- End of comments
526: ---------------------------------------------------------------------------
527: PROCEDURE insert_row(
528: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
529: x_return_status OUT NOCOPY VARCHAR2,
530: x_msg_count OUT NOCOPY NUMBER,
531: x_msg_data OUT NOCOPY VARCHAR2,
532: p_spm_rec IN spm_rec_type) AS

Line 537: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

533:
534: -- Local Variables within the function
535: l_api_version CONSTANT NUMBER := 1;
536: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
537: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
538: l_spm_rec spm_rec_type := p_spm_rec;
539: l_def_spm_rec spm_rec_type;
540:
541: ---------------------------------------------

Line 548: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

544: FUNCTION Set_Attributes (
545: p_spm_rec IN spm_rec_type,
546: x_spm_rec OUT NOCOPY spm_rec_type
547: ) RETURN VARCHAR2 IS
548: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
549: BEGIN
550: x_spm_rec := p_spm_rec;
551: RETURN(l_return_status);
552: END Set_Attributes;

Line 555: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

551: RETURN(l_return_status);
552: END Set_Attributes;
553:
554: BEGIN
555: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
556: p_init_msg_list,
557: '_PVT',
558: x_return_status);
559: --- If any errors happen abort API

Line 560: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

556: p_init_msg_list,
557: '_PVT',
558: x_return_status);
559: --- If any errors happen abort API
560: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
561: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
562:
563: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
564: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 561: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

557: '_PVT',
558: x_return_status);
559: --- If any errors happen abort API
560: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
561: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
562:
563: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
564: RAISE Okl_Api.G_EXCEPTION_ERROR;
565: END IF;

Line 563: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

559: --- If any errors happen abort API
560: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
561: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
562:
563: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
564: RAISE Okl_Api.G_EXCEPTION_ERROR;
565: END IF;
566:
567: --- Setting item attributes

Line 564: RAISE Okl_Api.G_EXCEPTION_ERROR;

560: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
561: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
562:
563: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
564: RAISE Okl_Api.G_EXCEPTION_ERROR;
565: END IF;
566:
567: --- Setting item attributes
568: l_return_status := Set_Attributes(

Line 573: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

569: p_spm_rec, -- IN
570: l_spm_rec -- OUT
571: );
572: --- If any errors happen abort API
573: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
574: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
576: RAISE Okl_Api.G_EXCEPTION_ERROR;
577: END IF;

Line 574: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

570: l_spm_rec -- OUT
571: );
572: --- If any errors happen abort API
573: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
574: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
576: RAISE Okl_Api.G_EXCEPTION_ERROR;
577: END IF;
578:

Line 575: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

571: );
572: --- If any errors happen abort API
573: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
574: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
576: RAISE Okl_Api.G_EXCEPTION_ERROR;
577: END IF;
578:
579: INSERT INTO OKL_SIF_PRICING_PARAMS(

Line 576: RAISE Okl_Api.G_EXCEPTION_ERROR;

572: --- If any errors happen abort API
573: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
574: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
576: RAISE Okl_Api.G_EXCEPTION_ERROR;
577: END IF;
578:
579: INSERT INTO OKL_SIF_PRICING_PARAMS(
580: ID

Line 618: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

614: );
615:
616: -- Set OUT values
617: --x_spm_rec := l_spm_rec;
618: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
619:
620: EXCEPTION
621: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
622: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 621: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

617: --x_spm_rec := l_spm_rec;
618: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
619:
620: EXCEPTION
621: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
622: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
623: (
624: l_api_name,
625: G_PKG_NAME,

Line 622: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

618: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
619:
620: EXCEPTION
621: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
622: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
623: (
624: l_api_name,
625: G_PKG_NAME,
626: 'Okl_Api.G_RET_STS_ERROR',

Line 626: 'Okl_Api.G_RET_STS_ERROR',

622: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
623: (
624: l_api_name,
625: G_PKG_NAME,
626: 'Okl_Api.G_RET_STS_ERROR',
627: x_msg_count,
628: x_msg_data,
629: '_PVT'
630: );

Line 631: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

627: x_msg_count,
628: x_msg_data,
629: '_PVT'
630: );
631: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
632: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
633: (
634: l_api_name,
635: G_PKG_NAME,

Line 632: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

628: x_msg_data,
629: '_PVT'
630: );
631: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
632: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
633: (
634: l_api_name,
635: G_PKG_NAME,
636: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 636: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

632: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
633: (
634: l_api_name,
635: G_PKG_NAME,
636: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
637: x_msg_count,
638: x_msg_data,
639: '_PVT'
640: );

Line 642: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

638: x_msg_data,
639: '_PVT'
640: );
641: WHEN OTHERS THEN
642: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
643: (
644: l_api_name,
645: G_PKG_NAME,
646: 'OTHERS',

Line 658: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

654: -- PL/SQL TBL insert_row for: SPMV_REC --
655: ----------------------------------------
656: PROCEDURE insert_row(
657: p_api_version IN NUMBER,
658: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
659: x_return_status OUT NOCOPY VARCHAR2,
660: x_msg_count OUT NOCOPY NUMBER,
661: x_msg_data OUT NOCOPY VARCHAR2,
662: p_spmv_rec IN spmv_rec_type) AS

Line 668: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

664:
665: -- Local Variables within the function
666: l_api_version CONSTANT NUMBER := 1;
667: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
668: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
669: l_spmv_rec spmv_rec_type;
670: l_def_spmv_rec spmv_rec_type;
671: l_spm_rec spm_rec_type;
672: lx_spm_rec spm_rec_type;

Line 696: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

692: FUNCTION Set_Attributes (
693: p_spmv_rec IN spmv_rec_type,
694: x_spmv_rec OUT NOCOPY spmv_rec_type
695: ) RETURN VARCHAR2 IS
696: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
697: BEGIN
698: x_spmv_rec := p_spmv_rec;
699: x_spmv_rec.OBJECT_VERSION_NUMBER := 1;
700:

Line 706: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

702: END Set_Attributes;
703:
704: BEGIN
705:
706: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
707: G_PKG_NAME,
708: p_init_msg_list,
709: l_api_version,
710: p_api_version,

Line 713: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

709: l_api_version,
710: p_api_version,
711: '_PVT',
712: x_return_status);
713: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
714: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
715: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
716: RAISE Okl_Api.G_EXCEPTION_ERROR;
717: END IF;

Line 714: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

710: p_api_version,
711: '_PVT',
712: x_return_status);
713: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
714: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
715: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
716: RAISE Okl_Api.G_EXCEPTION_ERROR;
717: END IF;
718:

Line 715: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

711: '_PVT',
712: x_return_status);
713: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
714: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
715: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
716: RAISE Okl_Api.G_EXCEPTION_ERROR;
717: END IF;
718:
719: l_spmv_rec := null_out_defaults(p_spmv_rec);

Line 716: RAISE Okl_Api.G_EXCEPTION_ERROR;

712: x_return_status);
713: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
714: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
715: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
716: RAISE Okl_Api.G_EXCEPTION_ERROR;
717: END IF;
718:
719: l_spmv_rec := null_out_defaults(p_spmv_rec);
720:

Line 731: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

727: l_def_spmv_rec); -- OUT
728:
729:
730: --- If any errors happen abort API
731: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
732: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
734: RAISE Okl_Api.G_EXCEPTION_ERROR;
735: END IF;

Line 732: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

728:
729:
730: --- If any errors happen abort API
731: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
732: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
734: RAISE Okl_Api.G_EXCEPTION_ERROR;
735: END IF;
736:

Line 733: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

729:
730: --- If any errors happen abort API
731: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
732: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
734: RAISE Okl_Api.G_EXCEPTION_ERROR;
735: END IF;
736:
737: -- fill who columns for the l_def_spmv_rec

Line 734: RAISE Okl_Api.G_EXCEPTION_ERROR;

730: --- If any errors happen abort API
731: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
732: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
734: RAISE Okl_Api.G_EXCEPTION_ERROR;
735: END IF;
736:
737: -- fill who columns for the l_def_spmv_rec
738: l_def_spmv_rec := fill_who_columns(l_def_spmv_rec);

Line 743: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

739:
740: --- Validate all non-missing attributes (Item Level Validation)
741: l_return_status := Validate_Attributes(l_def_spmv_rec);
742: --- If any errors happen abort API
743: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
744: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
745: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
746: RAISE Okl_Api.G_EXCEPTION_ERROR;
747: END IF;

Line 744: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

740: --- Validate all non-missing attributes (Item Level Validation)
741: l_return_status := Validate_Attributes(l_def_spmv_rec);
742: --- If any errors happen abort API
743: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
744: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
745: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
746: RAISE Okl_Api.G_EXCEPTION_ERROR;
747: END IF;
748:

Line 745: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

741: l_return_status := Validate_Attributes(l_def_spmv_rec);
742: --- If any errors happen abort API
743: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
744: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
745: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
746: RAISE Okl_Api.G_EXCEPTION_ERROR;
747: END IF;
748:
749: -- Perfrom all row level validations

Line 746: RAISE Okl_Api.G_EXCEPTION_ERROR;

742: --- If any errors happen abort API
743: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
744: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
745: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
746: RAISE Okl_Api.G_EXCEPTION_ERROR;
747: END IF;
748:
749: -- Perfrom all row level validations
750: l_return_status := validate_record(l_def_spmv_rec);

Line 751: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

747: END IF;
748:
749: -- Perfrom all row level validations
750: l_return_status := validate_record(l_def_spmv_rec);
751: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
752: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
753: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
754: RAISE Okl_Api.G_EXCEPTION_ERROR;
755: END IF;

Line 752: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

748:
749: -- Perfrom all row level validations
750: l_return_status := validate_record(l_def_spmv_rec);
751: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
752: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
753: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
754: RAISE Okl_Api.G_EXCEPTION_ERROR;
755: END IF;
756:

Line 753: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

749: -- Perfrom all row level validations
750: l_return_status := validate_record(l_def_spmv_rec);
751: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
752: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
753: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
754: RAISE Okl_Api.G_EXCEPTION_ERROR;
755: END IF;
756:
757: --------------------------------------

Line 754: RAISE Okl_Api.G_EXCEPTION_ERROR;

750: l_return_status := validate_record(l_def_spmv_rec);
751: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
752: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
753: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
754: RAISE Okl_Api.G_EXCEPTION_ERROR;
755: END IF;
756:
757: --------------------------------------
758: -- Move VIEW record to "Child" records

Line 773: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

769: ,x_msg_count => x_msg_count
770: ,x_msg_data => x_msg_data
771: ,p_spm_rec => l_spm_rec
772: );
773: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
776: RAISE Okl_Api.G_EXCEPTION_ERROR;
777: END IF;

Line 774: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

770: ,x_msg_data => x_msg_data
771: ,p_spm_rec => l_spm_rec
772: );
773: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
776: RAISE Okl_Api.G_EXCEPTION_ERROR;
777: END IF;
778:

Line 775: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

771: ,p_spm_rec => l_spm_rec
772: );
773: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
776: RAISE Okl_Api.G_EXCEPTION_ERROR;
777: END IF;
778:
779: migrate(lx_spm_rec, l_def_spmv_rec);

Line 776: RAISE Okl_Api.G_EXCEPTION_ERROR;

772: );
773: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
776: RAISE Okl_Api.G_EXCEPTION_ERROR;
777: END IF;
778:
779: migrate(lx_spm_rec, l_def_spmv_rec);
780:

Line 783: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

779: migrate(lx_spm_rec, l_def_spmv_rec);
780:
781: -- Set OUT values
782: --x_spmv_rec := l_def_spmv_rec;
783: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
784:
785: EXCEPTION
786: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
787: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 786: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

782: --x_spmv_rec := l_def_spmv_rec;
783: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
784:
785: EXCEPTION
786: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
787: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
788: (
789: l_api_name,
790: G_PKG_NAME,

Line 787: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

783: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
784:
785: EXCEPTION
786: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
787: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
788: (
789: l_api_name,
790: G_PKG_NAME,
791: 'Okl_Api.G_RET_STS_ERROR',

Line 791: 'Okl_Api.G_RET_STS_ERROR',

787: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
788: (
789: l_api_name,
790: G_PKG_NAME,
791: 'Okl_Api.G_RET_STS_ERROR',
792: x_msg_count,
793: x_msg_data,
794: '_PVT'
795: );

Line 796: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

792: x_msg_count,
793: x_msg_data,
794: '_PVT'
795: );
796: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
797: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
798: (
799: l_api_name,
800: G_PKG_NAME,

Line 797: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

793: x_msg_data,
794: '_PVT'
795: );
796: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
797: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
798: (
799: l_api_name,
800: G_PKG_NAME,
801: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 801: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

797: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
798: (
799: l_api_name,
800: G_PKG_NAME,
801: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
802: x_msg_count,
803: x_msg_data,
804: '_PVT'
805: );

Line 807: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

803: x_msg_data,
804: '_PVT'
805: );
806: WHEN OTHERS THEN
807: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
808: (
809: l_api_name,
810: G_PKG_NAME,
811: 'OTHERS',

Line 823: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

819: -- PL/SQL TBL insert_row for: SPMV_TBL --
820: ----------------------------------------
821: PROCEDURE insert_row(
822: p_api_version IN NUMBER,
823: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
824: x_return_status OUT NOCOPY VARCHAR2,
825: x_msg_count OUT NOCOPY NUMBER,
826: x_msg_data OUT NOCOPY VARCHAR2,
827: p_spmv_tbl IN spmv_tbl_type) IS

Line 831: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

827: p_spmv_tbl IN spmv_tbl_type) IS
828:
829: l_api_version CONSTANT NUMBER := 1;
830: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
831: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
832: i NUMBER := 0;
833: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
834: BEGIN
835: Okl_Api.init_msg_list(p_init_msg_list);

Line 833: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

829: l_api_version CONSTANT NUMBER := 1;
830: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
831: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
832: i NUMBER := 0;
833: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
834: BEGIN
835: Okl_Api.init_msg_list(p_init_msg_list);
836:
837: -- Making sure PL/SQL table has records in it before passing

Line 835: Okl_Api.init_msg_list(p_init_msg_list);

831: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
832: i NUMBER := 0;
833: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
834: BEGIN
835: Okl_Api.init_msg_list(p_init_msg_list);
836:
837: -- Making sure PL/SQL table has records in it before passing
838: IF (p_spmv_tbl.COUNT > 0) THEN
839: i := p_spmv_tbl.FIRST;

Line 844: p_init_msg_list => Okl_Api.G_FALSE,

840: LOOP
841:
842: insert_row (
843: p_api_version => l_api_version,
844: p_init_msg_list => Okl_Api.G_FALSE,
845: x_return_status => x_return_status,
846: x_msg_count => x_msg_count,
847: x_msg_data => x_msg_data,
848: p_spmv_rec => p_spmv_tbl(i));

Line 851: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

847: x_msg_data => x_msg_data,
848: p_spmv_rec => p_spmv_tbl(i));
849:
850: -- store the highest degree of error
851: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
852: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
853: l_overall_status := x_return_status;
854: END IF;
855: END IF;

Line 852: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

848: p_spmv_rec => p_spmv_tbl(i));
849:
850: -- store the highest degree of error
851: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
852: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
853: l_overall_status := x_return_status;
854: END IF;
855: END IF;
856: EXIT WHEN (i = p_spmv_tbl.LAST);

Line 865: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

861: x_return_status := l_overall_status;
862: END IF;
863: EXCEPTION
864:
865: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
866: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
867: (
868: l_api_name,
869: G_PKG_NAME,

Line 866: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

862: END IF;
863: EXCEPTION
864:
865: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
866: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
867: (
868: l_api_name,
869: G_PKG_NAME,
870: 'Okl_Api.G_RET_STS_ERROR',

Line 870: 'Okl_Api.G_RET_STS_ERROR',

866: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
867: (
868: l_api_name,
869: G_PKG_NAME,
870: 'Okl_Api.G_RET_STS_ERROR',
871: x_msg_count,
872: x_msg_data,
873: '_PVT'
874: );

Line 875: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

871: x_msg_count,
872: x_msg_data,
873: '_PVT'
874: );
875: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
876: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
877: (
878: l_api_name,
879: G_PKG_NAME,

Line 876: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

872: x_msg_data,
873: '_PVT'
874: );
875: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
876: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
877: (
878: l_api_name,
879: G_PKG_NAME,
880: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 880: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

876: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
877: (
878: l_api_name,
879: G_PKG_NAME,
880: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
881: x_msg_count,
882: x_msg_data,
883: '_PVT'
884: );

Line 886: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

882: x_msg_data,
883: '_PVT'
884: );
885: WHEN OTHERS THEN
886: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
887: (
888: l_api_name,
889: G_PKG_NAME,
890: 'OTHERS',

Line 911: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

907: -- Version : 1.0
908: -- End of comments
909: --------------------------------------------------------------------------
910: PROCEDURE update_row(
911: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
912: x_return_status OUT NOCOPY VARCHAR2,
913: x_msg_count OUT NOCOPY NUMBER,
914: x_msg_data OUT NOCOPY VARCHAR2,
915: p_spm_rec IN spm_rec_type) IS

Line 919: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

915: p_spm_rec IN spm_rec_type) IS
916:
917: l_api_version CONSTANT NUMBER := 1;
918: l_api_name CONSTANT VARCHAR2(30) := 'OPTS_update_row';
919: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
920: l_spm_rec spm_rec_type := p_spm_rec;
921: l_def_spm_rec spm_rec_type;
922: l_row_notfound BOOLEAN := TRUE;
923: ----------------------------------

Line 932: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

928: x_spm_rec OUT NOCOPY spm_rec_type
929: ) RETURN VARCHAR2 IS
930: l_spm_rec spm_rec_type;
931: l_row_notfound BOOLEAN := TRUE;
932: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
933: BEGIN
934: x_spm_rec := p_spm_rec;
935:
936: -- Get current database values

Line 940: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

936: -- Get current database values
937: l_spm_rec := get_rec( p_spm_rec, l_row_notfound);
938:
939: IF (l_row_notfound) THEN
940: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
941: END IF;
942: IF (x_spm_rec.id = Okl_Api.G_MISS_NUM)
943: THEN
944: x_spm_rec.id := l_spm_rec.id;

Line 942: IF (x_spm_rec.id = Okl_Api.G_MISS_NUM)

938:
939: IF (l_row_notfound) THEN
940: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
941: END IF;
942: IF (x_spm_rec.id = Okl_Api.G_MISS_NUM)
943: THEN
944: x_spm_rec.id := l_spm_rec.id;
945: END IF;
946: IF (x_spm_rec.object_version_number = Okl_Api.G_MISS_NUM)

Line 946: IF (x_spm_rec.object_version_number = Okl_Api.G_MISS_NUM)

942: IF (x_spm_rec.id = Okl_Api.G_MISS_NUM)
943: THEN
944: x_spm_rec.id := l_spm_rec.id;
945: END IF;
946: IF (x_spm_rec.object_version_number = Okl_Api.G_MISS_NUM)
947: THEN
948: x_spm_rec.object_version_number := l_spm_rec.object_version_number;
949: END IF;
950: IF (x_spm_rec.khr_id = Okl_Api.G_MISS_NUM)

Line 950: IF (x_spm_rec.khr_id = Okl_Api.G_MISS_NUM)

946: IF (x_spm_rec.object_version_number = Okl_Api.G_MISS_NUM)
947: THEN
948: x_spm_rec.object_version_number := l_spm_rec.object_version_number;
949: END IF;
950: IF (x_spm_rec.khr_id = Okl_Api.G_MISS_NUM)
951: THEN
952: x_spm_rec.khr_id := l_spm_rec.khr_id;
953: END IF;
954: IF (x_spm_rec.sif_id = Okl_Api.G_MISS_NUM)

Line 954: IF (x_spm_rec.sif_id = Okl_Api.G_MISS_NUM)

950: IF (x_spm_rec.khr_id = Okl_Api.G_MISS_NUM)
951: THEN
952: x_spm_rec.khr_id := l_spm_rec.khr_id;
953: END IF;
954: IF (x_spm_rec.sif_id = Okl_Api.G_MISS_NUM)
955: THEN
956: x_spm_rec.sif_id := l_spm_rec.sif_id;
957: END IF;
958: IF (x_spm_rec.name = Okl_Api.G_MISS_CHAR) THEN

Line 958: IF (x_spm_rec.name = Okl_Api.G_MISS_CHAR) THEN

954: IF (x_spm_rec.sif_id = Okl_Api.G_MISS_NUM)
955: THEN
956: x_spm_rec.sif_id := l_spm_rec.sif_id;
957: END IF;
958: IF (x_spm_rec.name = Okl_Api.G_MISS_CHAR) THEN
959: x_spm_rec.name := l_spm_rec.name;
960: END IF;
961: IF (x_spm_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
962: x_spm_rec.display_yn := l_spm_rec.display_yn;

Line 961: IF (x_spm_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN

957: END IF;
958: IF (x_spm_rec.name = Okl_Api.G_MISS_CHAR) THEN
959: x_spm_rec.name := l_spm_rec.name;
960: END IF;
961: IF (x_spm_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
962: x_spm_rec.display_yn := l_spm_rec.display_yn;
963: END IF;
964: IF (x_spm_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
965: x_spm_rec.update_yn := l_spm_rec.update_yn;

Line 964: IF (x_spm_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN

960: END IF;
961: IF (x_spm_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
962: x_spm_rec.display_yn := l_spm_rec.display_yn;
963: END IF;
964: IF (x_spm_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
965: x_spm_rec.update_yn := l_spm_rec.update_yn;
966: END IF;
967: IF (x_spm_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
968:

Line 967: IF (x_spm_rec.default_value = Okl_Api.G_MISS_CHAR) THEN

963: END IF;
964: IF (x_spm_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
965: x_spm_rec.update_yn := l_spm_rec.update_yn;
966: END IF;
967: IF (x_spm_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
968:
969: x_spm_rec.default_value := l_spm_rec.default_value;
970: END IF;
971: IF (x_spm_rec.parameter_value = Okl_Api.G_MISS_CHAR) THEN

Line 971: IF (x_spm_rec.parameter_value = Okl_Api.G_MISS_CHAR) THEN

967: IF (x_spm_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
968:
969: x_spm_rec.default_value := l_spm_rec.default_value;
970: END IF;
971: IF (x_spm_rec.parameter_value = Okl_Api.G_MISS_CHAR) THEN
972: x_spm_rec.parameter_value := l_spm_rec.parameter_value;
973: END IF;
974: IF (x_spm_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
975: x_spm_rec.prc_eng_ident := l_spm_rec.prc_eng_ident;

Line 974: IF (x_spm_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN

970: END IF;
971: IF (x_spm_rec.parameter_value = Okl_Api.G_MISS_CHAR) THEN
972: x_spm_rec.parameter_value := l_spm_rec.parameter_value;
973: END IF;
974: IF (x_spm_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
975: x_spm_rec.prc_eng_ident := l_spm_rec.prc_eng_ident;
976: END IF;
977: IF (x_spm_rec.description = Okl_Api.G_MISS_CHAR) THEN
978: x_spm_rec.description := l_spm_rec.description;

Line 977: IF (x_spm_rec.description = Okl_Api.G_MISS_CHAR) THEN

973: END IF;
974: IF (x_spm_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
975: x_spm_rec.prc_eng_ident := l_spm_rec.prc_eng_ident;
976: END IF;
977: IF (x_spm_rec.description = Okl_Api.G_MISS_CHAR) THEN
978: x_spm_rec.description := l_spm_rec.description;
979: END IF;
980: IF (x_spm_rec.created_by = Okl_Api.G_MISS_NUM)
981: THEN

Line 980: IF (x_spm_rec.created_by = Okl_Api.G_MISS_NUM)

976: END IF;
977: IF (x_spm_rec.description = Okl_Api.G_MISS_CHAR) THEN
978: x_spm_rec.description := l_spm_rec.description;
979: END IF;
980: IF (x_spm_rec.created_by = Okl_Api.G_MISS_NUM)
981: THEN
982: x_spm_rec.created_by := l_spm_rec.created_by;
983: END IF;
984: IF (x_spm_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 984: IF (x_spm_rec.creation_date = Okl_Api.G_MISS_DATE)

980: IF (x_spm_rec.created_by = Okl_Api.G_MISS_NUM)
981: THEN
982: x_spm_rec.created_by := l_spm_rec.created_by;
983: END IF;
984: IF (x_spm_rec.creation_date = Okl_Api.G_MISS_DATE)
985: THEN
986: x_spm_rec.creation_date := l_spm_rec.creation_date;
987: END IF;
988: IF (x_spm_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 988: IF (x_spm_rec.last_updated_by = Okl_Api.G_MISS_NUM)

984: IF (x_spm_rec.creation_date = Okl_Api.G_MISS_DATE)
985: THEN
986: x_spm_rec.creation_date := l_spm_rec.creation_date;
987: END IF;
988: IF (x_spm_rec.last_updated_by = Okl_Api.G_MISS_NUM)
989: THEN
990: x_spm_rec.last_updated_by := l_spm_rec.last_updated_by;
991: END IF;
992: IF (x_spm_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 992: IF (x_spm_rec.last_update_date = Okl_Api.G_MISS_DATE)

988: IF (x_spm_rec.last_updated_by = Okl_Api.G_MISS_NUM)
989: THEN
990: x_spm_rec.last_updated_by := l_spm_rec.last_updated_by;
991: END IF;
992: IF (x_spm_rec.last_update_date = Okl_Api.G_MISS_DATE)
993: THEN
994: x_spm_rec.last_update_date := l_spm_rec.last_update_date;
995: END IF;
996: IF (x_spm_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 996: IF (x_spm_rec.last_update_login = Okl_Api.G_MISS_NUM)

992: IF (x_spm_rec.last_update_date = Okl_Api.G_MISS_DATE)
993: THEN
994: x_spm_rec.last_update_date := l_spm_rec.last_update_date;
995: END IF;
996: IF (x_spm_rec.last_update_login = Okl_Api.G_MISS_NUM)
997: THEN
998: x_spm_rec.last_update_login := l_spm_rec.last_update_login;
999: END IF;
1000: RETURN(l_return_status);

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

1006: FUNCTION Set_Attributes (
1007: p_spm_rec IN spm_rec_type,
1008: x_spm_rec OUT NOCOPY spm_rec_type
1009: ) RETURN VARCHAR2 IS
1010: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1011: BEGIN
1012: x_spm_rec := p_spm_rec;
1013: RETURN(l_return_status);
1014: END Set_Attributes;

Line 1017: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

1013: RETURN(l_return_status);
1014: END Set_Attributes;
1015:
1016: BEGIN
1017: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1018: p_init_msg_list,
1019: '_PVT',
1020: x_return_status);
1021: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1021: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1017: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1018: p_init_msg_list,
1019: '_PVT',
1020: x_return_status);
1021: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1024: RAISE Okl_Api.G_EXCEPTION_ERROR;
1025: END IF;

Line 1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1018: p_init_msg_list,
1019: '_PVT',
1020: x_return_status);
1021: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1024: RAISE Okl_Api.G_EXCEPTION_ERROR;
1025: END IF;
1026:

Line 1023: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1019: '_PVT',
1020: x_return_status);
1021: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1024: RAISE Okl_Api.G_EXCEPTION_ERROR;
1025: END IF;
1026:
1027: --- Setting item attributes

Line 1024: RAISE Okl_Api.G_EXCEPTION_ERROR;

1020: x_return_status);
1021: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1024: RAISE Okl_Api.G_EXCEPTION_ERROR;
1025: END IF;
1026:
1027: --- Setting item attributes
1028: l_return_status := Set_Attributes(

Line 1033: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1029: p_spm_rec, -- IN
1030: l_spm_rec); -- OUT
1031:
1032: --- If any errors happen abort API
1033: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1036: RAISE Okl_Api.G_EXCEPTION_ERROR;
1037: END IF;

Line 1034: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1030: l_spm_rec); -- OUT
1031:
1032: --- If any errors happen abort API
1033: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1036: RAISE Okl_Api.G_EXCEPTION_ERROR;
1037: END IF;
1038:

Line 1035: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1031:
1032: --- If any errors happen abort API
1033: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1036: RAISE Okl_Api.G_EXCEPTION_ERROR;
1037: END IF;
1038:
1039: l_return_status := populate_new_record(l_spm_rec, l_def_spm_rec);

Line 1036: RAISE Okl_Api.G_EXCEPTION_ERROR;

1032: --- If any errors happen abort API
1033: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1036: RAISE Okl_Api.G_EXCEPTION_ERROR;
1037: END IF;
1038:
1039: l_return_status := populate_new_record(l_spm_rec, l_def_spm_rec);
1040: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1040: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1036: RAISE Okl_Api.G_EXCEPTION_ERROR;
1037: END IF;
1038:
1039: l_return_status := populate_new_record(l_spm_rec, l_def_spm_rec);
1040: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1041: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1042: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1043: RAISE Okl_Api.G_EXCEPTION_ERROR;
1044: END IF;

Line 1041: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1037: END IF;
1038:
1039: l_return_status := populate_new_record(l_spm_rec, l_def_spm_rec);
1040: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1041: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1042: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1043: RAISE Okl_Api.G_EXCEPTION_ERROR;
1044: END IF;
1045:

Line 1042: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1038:
1039: l_return_status := populate_new_record(l_spm_rec, l_def_spm_rec);
1040: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1041: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1042: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1043: RAISE Okl_Api.G_EXCEPTION_ERROR;
1044: END IF;
1045:
1046: UPDATE OKL_SIF_PRICING_PARAMS

Line 1043: RAISE Okl_Api.G_EXCEPTION_ERROR;

1039: l_return_status := populate_new_record(l_spm_rec, l_def_spm_rec);
1040: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1041: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1042: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1043: RAISE Okl_Api.G_EXCEPTION_ERROR;
1044: END IF;
1045:
1046: UPDATE OKL_SIF_PRICING_PARAMS
1047: SET ID = l_def_spm_rec.id

Line 1065: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1061: ,LAST_UPDATE_DATE = l_def_spm_rec.last_update_date
1062: ,LAST_UPDATE_LOGIN = l_def_spm_rec.last_update_login
1063: WHERE ID = l_def_spm_rec.id;
1064:
1065: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1066: EXCEPTION
1067: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1068: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1069:

Line 1067: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1063: WHERE ID = l_def_spm_rec.id;
1064:
1065: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1066: EXCEPTION
1067: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1068: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1069:
1070: (
1071: l_api_name,

Line 1068: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1064:
1065: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1066: EXCEPTION
1067: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1068: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1069:
1070: (
1071: l_api_name,
1072: G_PKG_NAME,

Line 1073: 'Okl_Api.G_RET_STS_ERROR',

1069:
1070: (
1071: l_api_name,
1072: G_PKG_NAME,
1073: 'Okl_Api.G_RET_STS_ERROR',
1074: x_msg_count,
1075: x_msg_data,
1076: '_PVT'
1077: );

Line 1078: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1074: x_msg_count,
1075: x_msg_data,
1076: '_PVT'
1077: );
1078: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1079: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1080: (
1081: l_api_name,
1082: G_PKG_NAME,

Line 1079: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1075: x_msg_data,
1076: '_PVT'
1077: );
1078: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1079: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1080: (
1081: l_api_name,
1082: G_PKG_NAME,
1083: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1083: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1079: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1080: (
1081: l_api_name,
1082: G_PKG_NAME,
1083: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1084: x_msg_count,
1085: x_msg_data,
1086: '_PVT'
1087: );

Line 1089: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1085: x_msg_data,
1086: '_PVT'
1087: );
1088: WHEN OTHERS THEN
1089: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1090: (
1091: l_api_name,
1092: G_PKG_NAME,
1093: 'OTHERS',

Line 1105: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1101: -- PL/SQL TBL update_row for: OKL_SIF_PRICING_PARAMS --
1102: -------------------------------------------------------
1103: PROCEDURE update_row(
1104: p_api_version IN NUMBER,
1105: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1106: x_return_status OUT NOCOPY VARCHAR2,
1107: x_msg_count OUT NOCOPY NUMBER,
1108: x_msg_data OUT NOCOPY VARCHAR2,
1109: p_spmv_rec IN spmv_rec_type) IS

Line 1113: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1109: p_spmv_rec IN spmv_rec_type) IS
1110:
1111: l_api_version CONSTANT NUMBER := 1;
1112: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1113: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1114: l_spmv_rec spmv_rec_type := p_spmv_rec;
1115: l_def_spmv_rec spmv_rec_type;
1116: l_spm_rec spm_rec_type;
1117: lx_spm_rec spm_rec_type;

Line 1140: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1136: x_spmv_rec OUT NOCOPY spmv_rec_type
1137: ) RETURN VARCHAR2 IS
1138: l_spmv_rec spmv_rec_type;
1139: l_row_notfound BOOLEAN := TRUE;
1140: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1141: BEGIN
1142: x_spmv_rec := p_spmv_rec;
1143:
1144: -- Get current database values

Line 1148: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1144: -- Get current database values
1145: l_spmv_rec := get_rec(p_spmv_rec, l_row_notfound);
1146:
1147: IF (l_row_notfound) THEN
1148: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1149: END IF;
1150: IF (x_spmv_rec.id = Okl_Api.G_MISS_NUM)
1151: THEN
1152: x_spmv_rec.id := l_spm_rec.id;

Line 1150: IF (x_spmv_rec.id = Okl_Api.G_MISS_NUM)

1146:
1147: IF (l_row_notfound) THEN
1148: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1149: END IF;
1150: IF (x_spmv_rec.id = Okl_Api.G_MISS_NUM)
1151: THEN
1152: x_spmv_rec.id := l_spm_rec.id;
1153: END IF;
1154: IF (x_spmv_rec.object_version_number = Okl_Api.G_MISS_NUM)

Line 1154: IF (x_spmv_rec.object_version_number = Okl_Api.G_MISS_NUM)

1150: IF (x_spmv_rec.id = Okl_Api.G_MISS_NUM)
1151: THEN
1152: x_spmv_rec.id := l_spm_rec.id;
1153: END IF;
1154: IF (x_spmv_rec.object_version_number = Okl_Api.G_MISS_NUM)
1155: THEN
1156: x_spmv_rec.object_version_number := l_spmv_rec.object_version_number;
1157: END IF;
1158: IF (x_spmv_rec.khr_id = Okl_Api.G_MISS_NUM)

Line 1158: IF (x_spmv_rec.khr_id = Okl_Api.G_MISS_NUM)

1154: IF (x_spmv_rec.object_version_number = Okl_Api.G_MISS_NUM)
1155: THEN
1156: x_spmv_rec.object_version_number := l_spmv_rec.object_version_number;
1157: END IF;
1158: IF (x_spmv_rec.khr_id = Okl_Api.G_MISS_NUM)
1159: THEN
1160: x_spmv_rec.khr_id := l_spmv_rec.khr_id;
1161: END IF;
1162: IF (x_spmv_rec.sif_id = Okl_Api.G_MISS_NUM)

Line 1162: IF (x_spmv_rec.sif_id = Okl_Api.G_MISS_NUM)

1158: IF (x_spmv_rec.khr_id = Okl_Api.G_MISS_NUM)
1159: THEN
1160: x_spmv_rec.khr_id := l_spmv_rec.khr_id;
1161: END IF;
1162: IF (x_spmv_rec.sif_id = Okl_Api.G_MISS_NUM)
1163: THEN
1164: x_spmv_rec.sif_id := l_spm_rec.sif_id;
1165: END IF;
1166: IF (x_spmv_rec.name = Okl_Api.G_MISS_CHAR) THEN

Line 1166: IF (x_spmv_rec.name = Okl_Api.G_MISS_CHAR) THEN

1162: IF (x_spmv_rec.sif_id = Okl_Api.G_MISS_NUM)
1163: THEN
1164: x_spmv_rec.sif_id := l_spm_rec.sif_id;
1165: END IF;
1166: IF (x_spmv_rec.name = Okl_Api.G_MISS_CHAR) THEN
1167: x_spmv_rec.name := l_spmv_rec.name;
1168: END IF;
1169: IF (x_spmv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
1170: x_spmv_rec.display_yn := l_spmv_rec.display_yn;

Line 1169: IF (x_spmv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN

1165: END IF;
1166: IF (x_spmv_rec.name = Okl_Api.G_MISS_CHAR) THEN
1167: x_spmv_rec.name := l_spmv_rec.name;
1168: END IF;
1169: IF (x_spmv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
1170: x_spmv_rec.display_yn := l_spmv_rec.display_yn;
1171: END IF;
1172: IF (x_spmv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
1173:

Line 1172: IF (x_spmv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN

1168: END IF;
1169: IF (x_spmv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
1170: x_spmv_rec.display_yn := l_spmv_rec.display_yn;
1171: END IF;
1172: IF (x_spmv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
1173:
1174: x_spmv_rec.update_yn := l_spmv_rec.update_yn;
1175: END IF;
1176: IF (x_spmv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN

Line 1176: IF (x_spmv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN

1172: IF (x_spmv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
1173:
1174: x_spmv_rec.update_yn := l_spmv_rec.update_yn;
1175: END IF;
1176: IF (x_spmv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
1177: x_spmv_rec.default_value := l_spmv_rec.default_value;
1178: END IF;
1179: IF (x_spmv_rec.parameter_value = Okl_Api.G_MISS_CHAR) THEN
1180: x_spmv_rec.parameter_value := l_spmv_rec.parameter_value;

Line 1179: IF (x_spmv_rec.parameter_value = Okl_Api.G_MISS_CHAR) THEN

1175: END IF;
1176: IF (x_spmv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
1177: x_spmv_rec.default_value := l_spmv_rec.default_value;
1178: END IF;
1179: IF (x_spmv_rec.parameter_value = Okl_Api.G_MISS_CHAR) THEN
1180: x_spmv_rec.parameter_value := l_spmv_rec.parameter_value;
1181: END IF;
1182: IF (x_spmv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
1183: x_spmv_rec.prc_eng_ident := l_spmv_rec.prc_eng_ident;

Line 1182: IF (x_spmv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN

1178: END IF;
1179: IF (x_spmv_rec.parameter_value = Okl_Api.G_MISS_CHAR) THEN
1180: x_spmv_rec.parameter_value := l_spmv_rec.parameter_value;
1181: END IF;
1182: IF (x_spmv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
1183: x_spmv_rec.prc_eng_ident := l_spmv_rec.prc_eng_ident;
1184: END IF;
1185: IF (x_spmv_rec.description = Okl_Api.G_MISS_CHAR) THEN
1186: x_spmv_rec.description := l_spmv_rec.description;

Line 1185: IF (x_spmv_rec.description = Okl_Api.G_MISS_CHAR) THEN

1181: END IF;
1182: IF (x_spmv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
1183: x_spmv_rec.prc_eng_ident := l_spmv_rec.prc_eng_ident;
1184: END IF;
1185: IF (x_spmv_rec.description = Okl_Api.G_MISS_CHAR) THEN
1186: x_spmv_rec.description := l_spmv_rec.description;
1187: END IF;
1188: IF (x_spmv_rec.created_by = Okl_Api.G_MISS_NUM)
1189: THEN

Line 1188: IF (x_spmv_rec.created_by = Okl_Api.G_MISS_NUM)

1184: END IF;
1185: IF (x_spmv_rec.description = Okl_Api.G_MISS_CHAR) THEN
1186: x_spmv_rec.description := l_spmv_rec.description;
1187: END IF;
1188: IF (x_spmv_rec.created_by = Okl_Api.G_MISS_NUM)
1189: THEN
1190: x_spmv_rec.created_by := l_spmv_rec.created_by;
1191: END IF;
1192: IF (x_spmv_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 1192: IF (x_spmv_rec.creation_date = Okl_Api.G_MISS_DATE)

1188: IF (x_spmv_rec.created_by = Okl_Api.G_MISS_NUM)
1189: THEN
1190: x_spmv_rec.created_by := l_spmv_rec.created_by;
1191: END IF;
1192: IF (x_spmv_rec.creation_date = Okl_Api.G_MISS_DATE)
1193: THEN
1194: x_spmv_rec.creation_date := l_spmv_rec.creation_date;
1195: END IF;
1196: IF (x_spmv_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 1196: IF (x_spmv_rec.last_updated_by = Okl_Api.G_MISS_NUM)

1192: IF (x_spmv_rec.creation_date = Okl_Api.G_MISS_DATE)
1193: THEN
1194: x_spmv_rec.creation_date := l_spmv_rec.creation_date;
1195: END IF;
1196: IF (x_spmv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
1197: THEN
1198: x_spmv_rec.last_updated_by := l_spmv_rec.last_updated_by;
1199: END IF;
1200: IF (x_spmv_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 1200: IF (x_spmv_rec.last_update_date = Okl_Api.G_MISS_DATE)

1196: IF (x_spmv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
1197: THEN
1198: x_spmv_rec.last_updated_by := l_spmv_rec.last_updated_by;
1199: END IF;
1200: IF (x_spmv_rec.last_update_date = Okl_Api.G_MISS_DATE)
1201: THEN
1202: x_spmv_rec.last_update_date := l_spmv_rec.last_update_date;
1203: END IF;
1204: IF (x_spmv_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 1204: IF (x_spmv_rec.last_update_login = Okl_Api.G_MISS_NUM)

1200: IF (x_spmv_rec.last_update_date = Okl_Api.G_MISS_DATE)
1201: THEN
1202: x_spmv_rec.last_update_date := l_spmv_rec.last_update_date;
1203: END IF;
1204: IF (x_spmv_rec.last_update_login = Okl_Api.G_MISS_NUM)
1205: THEN
1206: x_spmv_rec.last_update_login := l_spmv_rec.last_update_login;
1207: END IF;
1208: RETURN(l_return_status);

Line 1217: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1213: FUNCTION Set_Attributes (
1214: p_spmv_rec IN spmv_rec_type,
1215: x_spmv_rec OUT NOCOPY spmv_rec_type
1216: ) RETURN VARCHAR2 IS
1217: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1218: BEGIN
1219: x_spmv_rec := p_spmv_rec;
1220: RETURN(l_return_status);
1221: END Set_Attributes;

Line 1223: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

1219: x_spmv_rec := p_spmv_rec;
1220: RETURN(l_return_status);
1221: END Set_Attributes;
1222: BEGIN
1223: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1224: G_PKG_NAME,
1225: p_init_msg_list,
1226: l_api_version,
1227: p_api_version,

Line 1230: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1226: l_api_version,
1227: p_api_version,
1228: '_PVT',
1229: x_return_status);
1230: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1233: RAISE Okl_Api.G_EXCEPTION_ERROR;
1234: END IF;

Line 1231: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1227: p_api_version,
1228: '_PVT',
1229: x_return_status);
1230: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1233: RAISE Okl_Api.G_EXCEPTION_ERROR;
1234: END IF;
1235: --- Setting item attributes

Line 1232: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1228: '_PVT',
1229: x_return_status);
1230: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1233: RAISE Okl_Api.G_EXCEPTION_ERROR;
1234: END IF;
1235: --- Setting item attributes
1236: l_return_status := Set_Attributes(

Line 1233: RAISE Okl_Api.G_EXCEPTION_ERROR;

1229: x_return_status);
1230: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1233: RAISE Okl_Api.G_EXCEPTION_ERROR;
1234: END IF;
1235: --- Setting item attributes
1236: l_return_status := Set_Attributes(
1237: p_spmv_rec, -- IN

Line 1240: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1236: l_return_status := Set_Attributes(
1237: p_spmv_rec, -- IN
1238: l_spmv_rec); -- OUT
1239: --- If any errors happen abort API
1240: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1242: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1243: RAISE Okl_Api.G_EXCEPTION_ERROR;
1244: END IF;

Line 1241: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1237: p_spmv_rec, -- IN
1238: l_spmv_rec); -- OUT
1239: --- If any errors happen abort API
1240: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1242: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1243: RAISE Okl_Api.G_EXCEPTION_ERROR;
1244: END IF;
1245:

Line 1242: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1238: l_spmv_rec); -- OUT
1239: --- If any errors happen abort API
1240: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1242: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1243: RAISE Okl_Api.G_EXCEPTION_ERROR;
1244: END IF;
1245:
1246: l_return_status := populate_new_record(l_spmv_rec, l_def_spmv_rec);

Line 1243: RAISE Okl_Api.G_EXCEPTION_ERROR;

1239: --- If any errors happen abort API
1240: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1242: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1243: RAISE Okl_Api.G_EXCEPTION_ERROR;
1244: END IF;
1245:
1246: l_return_status := populate_new_record(l_spmv_rec, l_def_spmv_rec);
1247: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1247: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1243: RAISE Okl_Api.G_EXCEPTION_ERROR;
1244: END IF;
1245:
1246: l_return_status := populate_new_record(l_spmv_rec, l_def_spmv_rec);
1247: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1248: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1250: RAISE Okl_Api.G_EXCEPTION_ERROR;
1251: END IF;

Line 1248: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1244: END IF;
1245:
1246: l_return_status := populate_new_record(l_spmv_rec, l_def_spmv_rec);
1247: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1248: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1250: RAISE Okl_Api.G_EXCEPTION_ERROR;
1251: END IF;
1252: l_def_spmv_rec := fill_who_columns(l_def_spmv_rec);

Line 1249: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1245:
1246: l_return_status := populate_new_record(l_spmv_rec, l_def_spmv_rec);
1247: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1248: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1250: RAISE Okl_Api.G_EXCEPTION_ERROR;
1251: END IF;
1252: l_def_spmv_rec := fill_who_columns(l_def_spmv_rec);
1253:

Line 1250: RAISE Okl_Api.G_EXCEPTION_ERROR;

1246: l_return_status := populate_new_record(l_spmv_rec, l_def_spmv_rec);
1247: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1248: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1250: RAISE Okl_Api.G_EXCEPTION_ERROR;
1251: END IF;
1252: l_def_spmv_rec := fill_who_columns(l_def_spmv_rec);
1253:
1254: --- Validate all non-missing attributes (Item Level Validation)

Line 1258: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1254: --- Validate all non-missing attributes (Item Level Validation)
1255: l_return_status := Validate_Attributes(l_def_spmv_rec);
1256:
1257: --- If any errors happen abort API
1258: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1259: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1260: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1261: RAISE Okl_Api.G_EXCEPTION_ERROR;
1262: END IF;

Line 1259: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1255: l_return_status := Validate_Attributes(l_def_spmv_rec);
1256:
1257: --- If any errors happen abort API
1258: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1259: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1260: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1261: RAISE Okl_Api.G_EXCEPTION_ERROR;
1262: END IF;
1263:

Line 1260: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1256:
1257: --- If any errors happen abort API
1258: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1259: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1260: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1261: RAISE Okl_Api.G_EXCEPTION_ERROR;
1262: END IF;
1263:
1264: l_return_status := Validate_Record(l_def_spmv_rec);

Line 1261: RAISE Okl_Api.G_EXCEPTION_ERROR;

1257: --- If any errors happen abort API
1258: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1259: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1260: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1261: RAISE Okl_Api.G_EXCEPTION_ERROR;
1262: END IF;
1263:
1264: l_return_status := Validate_Record(l_def_spmv_rec);
1265: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1265: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1261: RAISE Okl_Api.G_EXCEPTION_ERROR;
1262: END IF;
1263:
1264: l_return_status := Validate_Record(l_def_spmv_rec);
1265: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1268: RAISE Okl_Api.G_EXCEPTION_ERROR;
1269: END IF;

Line 1266: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1262: END IF;
1263:
1264: l_return_status := Validate_Record(l_def_spmv_rec);
1265: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1268: RAISE Okl_Api.G_EXCEPTION_ERROR;
1269: END IF;
1270:

Line 1267: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1263:
1264: l_return_status := Validate_Record(l_def_spmv_rec);
1265: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1268: RAISE Okl_Api.G_EXCEPTION_ERROR;
1269: END IF;
1270:
1271: --------------------------------------

Line 1268: RAISE Okl_Api.G_EXCEPTION_ERROR;

1264: l_return_status := Validate_Record(l_def_spmv_rec);
1265: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1268: RAISE Okl_Api.G_EXCEPTION_ERROR;
1269: END IF;
1270:
1271: --------------------------------------
1272: -- Move VIEW record to "Child" records

Line 1286: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1282: x_msg_count => x_msg_count,
1283: x_msg_data => x_msg_data,
1284: p_spm_rec => l_spm_rec
1285: );
1286: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1287: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1288: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1289: RAISE Okl_Api.G_EXCEPTION_ERROR;
1290: END IF;

Line 1287: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1283: x_msg_data => x_msg_data,
1284: p_spm_rec => l_spm_rec
1285: );
1286: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1287: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1288: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1289: RAISE Okl_Api.G_EXCEPTION_ERROR;
1290: END IF;
1291:

Line 1288: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1284: p_spm_rec => l_spm_rec
1285: );
1286: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1287: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1288: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1289: RAISE Okl_Api.G_EXCEPTION_ERROR;
1290: END IF;
1291:
1292: migrate(lx_spm_rec, l_def_spmv_rec);

Line 1289: RAISE Okl_Api.G_EXCEPTION_ERROR;

1285: );
1286: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1287: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1288: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1289: RAISE Okl_Api.G_EXCEPTION_ERROR;
1290: END IF;
1291:
1292: migrate(lx_spm_rec, l_def_spmv_rec);
1293:

Line 1294: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1290: END IF;
1291:
1292: migrate(lx_spm_rec, l_def_spmv_rec);
1293:
1294: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1295: EXCEPTION
1296: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1297: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1298: (

Line 1296: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1292: migrate(lx_spm_rec, l_def_spmv_rec);
1293:
1294: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1295: EXCEPTION
1296: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1297: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1298: (
1299: l_api_name,
1300: G_PKG_NAME,

Line 1297: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1293:
1294: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1295: EXCEPTION
1296: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1297: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1298: (
1299: l_api_name,
1300: G_PKG_NAME,
1301: 'Okl_Api.G_RET_STS_ERROR',

Line 1301: 'Okl_Api.G_RET_STS_ERROR',

1297: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1298: (
1299: l_api_name,
1300: G_PKG_NAME,
1301: 'Okl_Api.G_RET_STS_ERROR',
1302: x_msg_count,
1303: x_msg_data,
1304: '_PVT'
1305: );

Line 1306: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1302: x_msg_count,
1303: x_msg_data,
1304: '_PVT'
1305: );
1306: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1307: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1308: (
1309: l_api_name,
1310: G_PKG_NAME,

Line 1307: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1303: x_msg_data,
1304: '_PVT'
1305: );
1306: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1307: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1308: (
1309: l_api_name,
1310: G_PKG_NAME,
1311: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1311: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1307: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1308: (
1309: l_api_name,
1310: G_PKG_NAME,
1311: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1312: x_msg_count,
1313: x_msg_data,
1314: '_PVT'
1315: );

Line 1317: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1313: x_msg_data,
1314: '_PVT'
1315: );
1316: WHEN OTHERS THEN
1317: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1318: (
1319: l_api_name,
1320: G_PKG_NAME,
1321: 'OTHERS',

Line 1333: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1329: -- PL/SQL TBL update_row for:OKL_SIF_PRICING_PARAMS_V --
1330: -------------------------------------------------------
1331: PROCEDURE update_row(
1332: p_api_version IN NUMBER,
1333: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1334: x_return_status OUT NOCOPY VARCHAR2,
1335: x_msg_count OUT NOCOPY NUMBER,
1336: x_msg_data OUT NOCOPY VARCHAR2,
1337: p_spmv_tbl IN spmv_tbl_type) IS

Line 1341: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1337: p_spmv_tbl IN spmv_tbl_type) IS
1338:
1339: l_api_version CONSTANT NUMBER := 1;
1340: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1341: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1342: i NUMBER := 0;
1343:
1344: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1345: BEGIN

Line 1344: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1340: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1341: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1342: i NUMBER := 0;
1343:
1344: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1345: BEGIN
1346: Okl_Api.init_msg_list(p_init_msg_list);
1347: -- Make sure PL/SQL table has records in it before passing
1348: IF (p_spmv_tbl.COUNT > 0) THEN

Line 1346: Okl_Api.init_msg_list(p_init_msg_list);

1342: i NUMBER := 0;
1343:
1344: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1345: BEGIN
1346: Okl_Api.init_msg_list(p_init_msg_list);
1347: -- Make sure PL/SQL table has records in it before passing
1348: IF (p_spmv_tbl.COUNT > 0) THEN
1349: i := p_spmv_tbl.FIRST;
1350: LOOP

Line 1353: p_init_msg_list => Okl_Api.G_FALSE,

1349: i := p_spmv_tbl.FIRST;
1350: LOOP
1351: update_row (
1352: p_api_version => l_api_version,
1353: p_init_msg_list => Okl_Api.G_FALSE,
1354: x_return_status => x_return_status,
1355: x_msg_count => x_msg_count,
1356: x_msg_data => x_msg_data,
1357: p_spmv_rec => p_spmv_tbl(i));

Line 1359: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1355: x_msg_count => x_msg_count,
1356: x_msg_data => x_msg_data,
1357: p_spmv_rec => p_spmv_tbl(i));
1358:
1359: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1360: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1361: l_overall_status := x_return_status;
1362: END IF;
1363: END IF;

Line 1360: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1356: x_msg_data => x_msg_data,
1357: p_spmv_rec => p_spmv_tbl(i));
1358:
1359: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1360: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1361: l_overall_status := x_return_status;
1362: END IF;
1363: END IF;
1364:

Line 1374: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1370:
1371: END IF;
1372: EXCEPTION
1373:
1374: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1375: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1376: (
1377: l_api_name,
1378: G_PKG_NAME,

Line 1375: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1371: END IF;
1372: EXCEPTION
1373:
1374: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1375: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1376: (
1377: l_api_name,
1378: G_PKG_NAME,
1379: 'Okl_Api.G_RET_STS_ERROR',

Line 1379: 'Okl_Api.G_RET_STS_ERROR',

1375: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1376: (
1377: l_api_name,
1378: G_PKG_NAME,
1379: 'Okl_Api.G_RET_STS_ERROR',
1380: x_msg_count,
1381: x_msg_data,
1382: '_PVT'
1383: );

Line 1384: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1380: x_msg_count,
1381: x_msg_data,
1382: '_PVT'
1383: );
1384: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1385: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1386: (
1387: l_api_name,
1388: G_PKG_NAME,

Line 1385: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1381: x_msg_data,
1382: '_PVT'
1383: );
1384: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1385: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1386: (
1387: l_api_name,
1388: G_PKG_NAME,
1389: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1389: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1385: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1386: (
1387: l_api_name,
1388: G_PKG_NAME,
1389: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1390: x_msg_count,
1391: x_msg_data,
1392: '_PVT'
1393: );

Line 1395: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1391: x_msg_data,
1392: '_PVT'
1393: );
1394: WHEN OTHERS THEN
1395: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1396: (
1397: l_api_name,
1398: G_PKG_NAME,
1399: 'OTHERS',