APPS.OKL_CMG_PVT dependencies on OKL_API

Line 225: IF (l_cmgv_rec.object_version_number = OKL_API.G_MISS_NUM) THEN

221: p_cmgv_rec IN cmgv_rec_type
222: ) RETURN cmgv_rec_type IS
223: l_cmgv_rec cmgv_rec_type := p_cmgv_rec;
224: BEGIN
225: IF (l_cmgv_rec.object_version_number = OKL_API.G_MISS_NUM) THEN
226: l_cmgv_rec.object_version_number := NULL;
227: END IF;
228: IF (l_cmgv_rec.ims_id = OKL_API.G_MISS_NUM) THEN
229: l_cmgv_rec.ims_id := NULL;

Line 228: IF (l_cmgv_rec.ims_id = OKL_API.G_MISS_NUM) THEN

224: BEGIN
225: IF (l_cmgv_rec.object_version_number = OKL_API.G_MISS_NUM) THEN
226: l_cmgv_rec.object_version_number := NULL;
227: END IF;
228: IF (l_cmgv_rec.ims_id = OKL_API.G_MISS_NUM) THEN
229: l_cmgv_rec.ims_id := NULL;
230: END IF;
231: IF (l_cmgv_rec.ivm_id = OKL_API.G_MISS_NUM) THEN
232: l_cmgv_rec.ivm_id := NULL;

Line 231: IF (l_cmgv_rec.ivm_id = OKL_API.G_MISS_NUM) THEN

227: END IF;
228: IF (l_cmgv_rec.ims_id = OKL_API.G_MISS_NUM) THEN
229: l_cmgv_rec.ims_id := NULL;
230: END IF;
231: IF (l_cmgv_rec.ivm_id = OKL_API.G_MISS_NUM) THEN
232: l_cmgv_rec.ivm_id := NULL;
233: END IF;
234: IF (l_cmgv_rec.sequence_number = OKL_API.G_MISS_NUM) THEN
235: l_cmgv_rec.sequence_number := NULL;

Line 234: IF (l_cmgv_rec.sequence_number = OKL_API.G_MISS_NUM) THEN

230: END IF;
231: IF (l_cmgv_rec.ivm_id = OKL_API.G_MISS_NUM) THEN
232: l_cmgv_rec.ivm_id := NULL;
233: END IF;
234: IF (l_cmgv_rec.sequence_number = OKL_API.G_MISS_NUM) THEN
235: l_cmgv_rec.sequence_number := NULL;
236: END IF;
237: IF (l_cmgv_rec.attribute_category = OKL_API.G_MISS_CHAR) THEN
238: l_cmgv_rec.attribute_category := NULL;

Line 237: IF (l_cmgv_rec.attribute_category = OKL_API.G_MISS_CHAR) THEN

233: END IF;
234: IF (l_cmgv_rec.sequence_number = OKL_API.G_MISS_NUM) THEN
235: l_cmgv_rec.sequence_number := NULL;
236: END IF;
237: IF (l_cmgv_rec.attribute_category = OKL_API.G_MISS_CHAR) THEN
238: l_cmgv_rec.attribute_category := NULL;
239: END IF;
240: IF (l_cmgv_rec.attribute1 = OKL_API.G_MISS_CHAR) THEN
241: l_cmgv_rec.attribute1 := NULL;

Line 240: IF (l_cmgv_rec.attribute1 = OKL_API.G_MISS_CHAR) THEN

236: END IF;
237: IF (l_cmgv_rec.attribute_category = OKL_API.G_MISS_CHAR) THEN
238: l_cmgv_rec.attribute_category := NULL;
239: END IF;
240: IF (l_cmgv_rec.attribute1 = OKL_API.G_MISS_CHAR) THEN
241: l_cmgv_rec.attribute1 := NULL;
242: END IF;
243: IF (l_cmgv_rec.attribute2 = OKL_API.G_MISS_CHAR) THEN
244: l_cmgv_rec.attribute2 := NULL;

Line 243: IF (l_cmgv_rec.attribute2 = OKL_API.G_MISS_CHAR) THEN

239: END IF;
240: IF (l_cmgv_rec.attribute1 = OKL_API.G_MISS_CHAR) THEN
241: l_cmgv_rec.attribute1 := NULL;
242: END IF;
243: IF (l_cmgv_rec.attribute2 = OKL_API.G_MISS_CHAR) THEN
244: l_cmgv_rec.attribute2 := NULL;
245: END IF;
246: IF (l_cmgv_rec.attribute3 = OKL_API.G_MISS_CHAR) THEN
247: l_cmgv_rec.attribute3 := NULL;

Line 246: IF (l_cmgv_rec.attribute3 = OKL_API.G_MISS_CHAR) THEN

242: END IF;
243: IF (l_cmgv_rec.attribute2 = OKL_API.G_MISS_CHAR) THEN
244: l_cmgv_rec.attribute2 := NULL;
245: END IF;
246: IF (l_cmgv_rec.attribute3 = OKL_API.G_MISS_CHAR) THEN
247: l_cmgv_rec.attribute3 := NULL;
248: END IF;
249: IF (l_cmgv_rec.attribute4 = OKL_API.G_MISS_CHAR) THEN
250: l_cmgv_rec.attribute4 := NULL;

Line 249: IF (l_cmgv_rec.attribute4 = OKL_API.G_MISS_CHAR) THEN

245: END IF;
246: IF (l_cmgv_rec.attribute3 = OKL_API.G_MISS_CHAR) THEN
247: l_cmgv_rec.attribute3 := NULL;
248: END IF;
249: IF (l_cmgv_rec.attribute4 = OKL_API.G_MISS_CHAR) THEN
250: l_cmgv_rec.attribute4 := NULL;
251: END IF;
252: IF (l_cmgv_rec.attribute5 = OKL_API.G_MISS_CHAR) THEN
253: l_cmgv_rec.attribute5 := NULL;

Line 252: IF (l_cmgv_rec.attribute5 = OKL_API.G_MISS_CHAR) THEN

248: END IF;
249: IF (l_cmgv_rec.attribute4 = OKL_API.G_MISS_CHAR) THEN
250: l_cmgv_rec.attribute4 := NULL;
251: END IF;
252: IF (l_cmgv_rec.attribute5 = OKL_API.G_MISS_CHAR) THEN
253: l_cmgv_rec.attribute5 := NULL;
254: END IF;
255: IF (l_cmgv_rec.attribute6 = OKL_API.G_MISS_CHAR) THEN
256: l_cmgv_rec.attribute6 := NULL;

Line 255: IF (l_cmgv_rec.attribute6 = OKL_API.G_MISS_CHAR) THEN

251: END IF;
252: IF (l_cmgv_rec.attribute5 = OKL_API.G_MISS_CHAR) THEN
253: l_cmgv_rec.attribute5 := NULL;
254: END IF;
255: IF (l_cmgv_rec.attribute6 = OKL_API.G_MISS_CHAR) THEN
256: l_cmgv_rec.attribute6 := NULL;
257: END IF;
258: IF (l_cmgv_rec.attribute7 = OKL_API.G_MISS_CHAR) THEN
259: l_cmgv_rec.attribute7 := NULL;

Line 258: IF (l_cmgv_rec.attribute7 = OKL_API.G_MISS_CHAR) THEN

254: END IF;
255: IF (l_cmgv_rec.attribute6 = OKL_API.G_MISS_CHAR) THEN
256: l_cmgv_rec.attribute6 := NULL;
257: END IF;
258: IF (l_cmgv_rec.attribute7 = OKL_API.G_MISS_CHAR) THEN
259: l_cmgv_rec.attribute7 := NULL;
260: END IF;
261: IF (l_cmgv_rec.attribute8 = OKL_API.G_MISS_CHAR) THEN
262: l_cmgv_rec.attribute8 := NULL;

Line 261: IF (l_cmgv_rec.attribute8 = OKL_API.G_MISS_CHAR) THEN

257: END IF;
258: IF (l_cmgv_rec.attribute7 = OKL_API.G_MISS_CHAR) THEN
259: l_cmgv_rec.attribute7 := NULL;
260: END IF;
261: IF (l_cmgv_rec.attribute8 = OKL_API.G_MISS_CHAR) THEN
262: l_cmgv_rec.attribute8 := NULL;
263: END IF;
264: IF (l_cmgv_rec.attribute9 = OKL_API.G_MISS_CHAR) THEN
265: l_cmgv_rec.attribute9 := NULL;

Line 264: IF (l_cmgv_rec.attribute9 = OKL_API.G_MISS_CHAR) THEN

260: END IF;
261: IF (l_cmgv_rec.attribute8 = OKL_API.G_MISS_CHAR) THEN
262: l_cmgv_rec.attribute8 := NULL;
263: END IF;
264: IF (l_cmgv_rec.attribute9 = OKL_API.G_MISS_CHAR) THEN
265: l_cmgv_rec.attribute9 := NULL;
266: END IF;
267: IF (l_cmgv_rec.attribute10 = OKL_API.G_MISS_CHAR) THEN
268: l_cmgv_rec.attribute10 := NULL;

Line 267: IF (l_cmgv_rec.attribute10 = OKL_API.G_MISS_CHAR) THEN

263: END IF;
264: IF (l_cmgv_rec.attribute9 = OKL_API.G_MISS_CHAR) THEN
265: l_cmgv_rec.attribute9 := NULL;
266: END IF;
267: IF (l_cmgv_rec.attribute10 = OKL_API.G_MISS_CHAR) THEN
268: l_cmgv_rec.attribute10 := NULL;
269: END IF;
270: IF (l_cmgv_rec.attribute11 = OKL_API.G_MISS_CHAR) THEN
271: l_cmgv_rec.attribute11 := NULL;

Line 270: IF (l_cmgv_rec.attribute11 = OKL_API.G_MISS_CHAR) THEN

266: END IF;
267: IF (l_cmgv_rec.attribute10 = OKL_API.G_MISS_CHAR) THEN
268: l_cmgv_rec.attribute10 := NULL;
269: END IF;
270: IF (l_cmgv_rec.attribute11 = OKL_API.G_MISS_CHAR) THEN
271: l_cmgv_rec.attribute11 := NULL;
272: END IF;
273: IF (l_cmgv_rec.attribute12 = OKL_API.G_MISS_CHAR) THEN
274: l_cmgv_rec.attribute12 := NULL;

Line 273: IF (l_cmgv_rec.attribute12 = OKL_API.G_MISS_CHAR) THEN

269: END IF;
270: IF (l_cmgv_rec.attribute11 = OKL_API.G_MISS_CHAR) THEN
271: l_cmgv_rec.attribute11 := NULL;
272: END IF;
273: IF (l_cmgv_rec.attribute12 = OKL_API.G_MISS_CHAR) THEN
274: l_cmgv_rec.attribute12 := NULL;
275: END IF;
276: IF (l_cmgv_rec.attribute13 = OKL_API.G_MISS_CHAR) THEN
277: l_cmgv_rec.attribute13 := NULL;

Line 276: IF (l_cmgv_rec.attribute13 = OKL_API.G_MISS_CHAR) THEN

272: END IF;
273: IF (l_cmgv_rec.attribute12 = OKL_API.G_MISS_CHAR) THEN
274: l_cmgv_rec.attribute12 := NULL;
275: END IF;
276: IF (l_cmgv_rec.attribute13 = OKL_API.G_MISS_CHAR) THEN
277: l_cmgv_rec.attribute13 := NULL;
278: END IF;
279: IF (l_cmgv_rec.attribute14 = OKL_API.G_MISS_CHAR) THEN
280: l_cmgv_rec.attribute14 := NULL;

Line 279: IF (l_cmgv_rec.attribute14 = OKL_API.G_MISS_CHAR) THEN

275: END IF;
276: IF (l_cmgv_rec.attribute13 = OKL_API.G_MISS_CHAR) THEN
277: l_cmgv_rec.attribute13 := NULL;
278: END IF;
279: IF (l_cmgv_rec.attribute14 = OKL_API.G_MISS_CHAR) THEN
280: l_cmgv_rec.attribute14 := NULL;
281: END IF;
282: IF (l_cmgv_rec.attribute15 = OKL_API.G_MISS_CHAR) THEN
283: l_cmgv_rec.attribute15 := NULL;

Line 282: IF (l_cmgv_rec.attribute15 = OKL_API.G_MISS_CHAR) THEN

278: END IF;
279: IF (l_cmgv_rec.attribute14 = OKL_API.G_MISS_CHAR) THEN
280: l_cmgv_rec.attribute14 := NULL;
281: END IF;
282: IF (l_cmgv_rec.attribute15 = OKL_API.G_MISS_CHAR) THEN
283: l_cmgv_rec.attribute15 := NULL;
284: END IF;
285: IF (l_cmgv_rec.created_by = OKL_API.G_MISS_NUM) THEN
286: l_cmgv_rec.created_by := NULL;

Line 285: IF (l_cmgv_rec.created_by = OKL_API.G_MISS_NUM) THEN

281: END IF;
282: IF (l_cmgv_rec.attribute15 = OKL_API.G_MISS_CHAR) THEN
283: l_cmgv_rec.attribute15 := NULL;
284: END IF;
285: IF (l_cmgv_rec.created_by = OKL_API.G_MISS_NUM) THEN
286: l_cmgv_rec.created_by := NULL;
287: END IF;
288: IF (l_cmgv_rec.creation_date = OKL_API.G_MISS_DATE) THEN
289: l_cmgv_rec.creation_date := NULL;

Line 288: IF (l_cmgv_rec.creation_date = OKL_API.G_MISS_DATE) THEN

284: END IF;
285: IF (l_cmgv_rec.created_by = OKL_API.G_MISS_NUM) THEN
286: l_cmgv_rec.created_by := NULL;
287: END IF;
288: IF (l_cmgv_rec.creation_date = OKL_API.G_MISS_DATE) THEN
289: l_cmgv_rec.creation_date := NULL;
290: END IF;
291: IF (l_cmgv_rec.last_updated_by = OKL_API.G_MISS_NUM) THEN
292: l_cmgv_rec.last_updated_by := NULL;

Line 291: IF (l_cmgv_rec.last_updated_by = OKL_API.G_MISS_NUM) THEN

287: END IF;
288: IF (l_cmgv_rec.creation_date = OKL_API.G_MISS_DATE) THEN
289: l_cmgv_rec.creation_date := NULL;
290: END IF;
291: IF (l_cmgv_rec.last_updated_by = OKL_API.G_MISS_NUM) THEN
292: l_cmgv_rec.last_updated_by := NULL;
293: END IF;
294: IF (l_cmgv_rec.last_update_date = OKL_API.G_MISS_DATE) THEN
295: l_cmgv_rec.last_update_date := NULL;

Line 294: IF (l_cmgv_rec.last_update_date = OKL_API.G_MISS_DATE) THEN

290: END IF;
291: IF (l_cmgv_rec.last_updated_by = OKL_API.G_MISS_NUM) THEN
292: l_cmgv_rec.last_updated_by := NULL;
293: END IF;
294: IF (l_cmgv_rec.last_update_date = OKL_API.G_MISS_DATE) THEN
295: l_cmgv_rec.last_update_date := NULL;
296: END IF;
297: IF (l_cmgv_rec.last_update_login = OKL_API.G_MISS_NUM) THEN
298: l_cmgv_rec.last_update_login := NULL;

Line 297: IF (l_cmgv_rec.last_update_login = OKL_API.G_MISS_NUM) THEN

293: END IF;
294: IF (l_cmgv_rec.last_update_date = OKL_API.G_MISS_DATE) THEN
295: l_cmgv_rec.last_update_date := NULL;
296: END IF;
297: IF (l_cmgv_rec.last_update_login = OKL_API.G_MISS_NUM) THEN
298: l_cmgv_rec.last_update_login := NULL;
299: END IF;
300: RETURN(l_cmgv_rec);
301: END null_out_defaults;

Line 316: x_return_status := OKL_API.G_RET_STS_SUCCESS;

312:
313: BEGIN
314:
315: -- initialize return status
316: x_return_status := OKL_API.G_RET_STS_SUCCESS;
317:
318: -- data is required
319: IF p_cmgv_rec.id = OKL_API.G_MISS_NUM
320: OR p_cmgv_rec.id IS NULL

Line 319: IF p_cmgv_rec.id = OKL_API.G_MISS_NUM

315: -- initialize return status
316: x_return_status := OKL_API.G_RET_STS_SUCCESS;
317:
318: -- data is required
319: IF p_cmgv_rec.id = OKL_API.G_MISS_NUM
320: OR p_cmgv_rec.id IS NULL
321: THEN
322:
323: -- display error message

Line 324: OKL_API.set_message(

320: OR p_cmgv_rec.id IS NULL
321: THEN
322:
323: -- display error message
324: OKL_API.set_message(
325: p_app_name => G_APP_NAME,
326: p_msg_name => G_REQUIRED_VALUE,
327: p_token1 => G_COL_NAME_TOKEN,
328: p_token1_value => 'id');

Line 331: x_return_status := OKL_API.G_RET_STS_ERROR;

327: p_token1 => G_COL_NAME_TOKEN,
328: p_token1_value => 'id');
329:
330: -- notify caller of en error
331: x_return_status := OKL_API.G_RET_STS_ERROR;
332: -- halt furhter validation of the column
333: raise G_EXCEPTION_HALT_VALIDATION;
334:
335: END IF;

Line 345: OKL_API.set_message(

341: null;
342:
343: when OTHERS then
344: -- display error message
345: OKL_API.set_message(
346: p_app_name => G_APP_NAME,
347: p_msg_name => G_UNEXPECTED_ERROR,
348: p_token1 => G_SQLCODE_TOKEN,
349: p_token1_value => SQLCODE,

Line 353: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

349: p_token1_value => SQLCODE,
350: p_token2 => G_SQLERRM_TOKEN,
351: p_token2_value => SQLERRM);
352: -- notify caller of an unexpected error
353: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
354:
355: END Validate_Id;
356:
357: ---------------------------------------------------------------------------

Line 370: x_return_status := OKL_API.G_RET_STS_SUCCESS;

366:
367: BEGIN
368:
369: -- initialize return status
370: x_return_status := OKL_API.G_RET_STS_SUCCESS;
371:
372: -- data is required
373: IF p_cmgv_rec.object_version_number = OKL_API.G_MISS_NUM
374: OR p_cmgv_rec.object_version_number IS NULL

Line 373: IF p_cmgv_rec.object_version_number = OKL_API.G_MISS_NUM

369: -- initialize return status
370: x_return_status := OKL_API.G_RET_STS_SUCCESS;
371:
372: -- data is required
373: IF p_cmgv_rec.object_version_number = OKL_API.G_MISS_NUM
374: OR p_cmgv_rec.object_version_number IS NULL
375: THEN
376:
377: -- display error message

Line 378: OKL_API.set_message(

374: OR p_cmgv_rec.object_version_number IS NULL
375: THEN
376:
377: -- display error message
378: OKL_API.set_message(
379: p_app_name => G_APP_NAME,
380: p_msg_name => G_REQUIRED_VALUE,
381: p_token1 => G_COL_NAME_TOKEN,
382: p_token1_value => 'object_version_number');

Line 385: x_return_status := OKL_API.G_RET_STS_ERROR;

381: p_token1 => G_COL_NAME_TOKEN,
382: p_token1_value => 'object_version_number');
383:
384: -- notify caller of en error
385: x_return_status := OKL_API.G_RET_STS_ERROR;
386: -- halt furhter validation of the column
387: raise G_EXCEPTION_HALT_VALIDATION;
388:
389: END IF;

Line 399: OKL_API.set_message(

395: null;
396:
397: when OTHERS then
398: -- display error message
399: OKL_API.set_message(
400: p_app_name => G_APP_NAME,
401: p_msg_name => G_UNEXPECTED_ERROR,
402: p_token1 => G_SQLCODE_TOKEN,
403: p_token1_value => SQLCODE,

Line 407: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

403: p_token1_value => SQLCODE,
404: p_token2 => G_SQLERRM_TOKEN,
405: p_token2_value => SQLERRM);
406: -- notify caller of an unexpected error
407: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
408:
409: END Validate_Object_Version_Number;
410:
411: ---------------------------------------------------------------------------

Line 431: x_return_status := OKL_API.G_RET_STS_SUCCESS;

427:
428: BEGIN
429:
430: -- initialize return status
431: x_return_status := OKL_API.G_RET_STS_SUCCESS;
432:
433: -- data is required
434: IF p_cmgv_rec.ims_id = OKL_API.G_MISS_NUM
435: OR p_cmgv_rec.ims_id IS NULL

Line 434: IF p_cmgv_rec.ims_id = OKL_API.G_MISS_NUM

430: -- initialize return status
431: x_return_status := OKL_API.G_RET_STS_SUCCESS;
432:
433: -- data is required
434: IF p_cmgv_rec.ims_id = OKL_API.G_MISS_NUM
435: OR p_cmgv_rec.ims_id IS NULL
436: THEN
437:
438: -- display error message

Line 439: OKL_API.set_message(

435: OR p_cmgv_rec.ims_id IS NULL
436: THEN
437:
438: -- display error message
439: OKL_API.set_message(
440: p_app_name => G_APP_NAME,
441: p_msg_name => G_REQUIRED_VALUE,
442: p_token1 => G_COL_NAME_TOKEN,
443: p_token1_value => 'ims_id');

Line 446: x_return_status := OKL_API.G_RET_STS_ERROR;

442: p_token1 => G_COL_NAME_TOKEN,
443: p_token1_value => 'ims_id');
444:
445: -- notify caller of en error
446: x_return_status := OKL_API.G_RET_STS_ERROR;
447: -- halt furhter validation of the column
448: raise G_EXCEPTION_HALT_VALIDATION;
449:
450: END IF;

Line 461: OKL_API.set_message(

457: -- if dummy value is still set to default, data was not found
458: IF (l_dummy_var = '?') THEN
459:
460: -- display error message
461: OKL_API.set_message(
462: p_app_name => G_APP_NAME,
463: p_msg_name => G_NO_PARENT_RECORD,
464: p_token1 => G_COL_NAME_TOKEN,
465: p_token1_value => 'ims_id',

Line 472: x_return_status := OKL_API.G_RET_STS_ERROR;

468: p_token3 => G_PARENT_TABLE_TOKEN,
469: p_token3_value => 'OKL_INVOICE_MSSGS_V');
470:
471: -- notify caller of en error
472: x_return_status := OKL_API.G_RET_STS_ERROR;
473:
474: END IF;
475:
476: EXCEPTION

Line 484: OKL_API.set_message(

480: null;
481:
482: when OTHERS then
483: -- display error message
484: OKL_API.set_message(
485: p_app_name => G_APP_NAME,
486: p_msg_name => G_UNEXPECTED_ERROR,
487: p_token1 => G_SQLCODE_TOKEN,
488: p_token1_value => SQLCODE,

Line 492: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

488: p_token1_value => SQLCODE,
489: p_token2 => G_SQLERRM_TOKEN,
490: p_token2_value => SQLERRM);
491: -- notify caller of an unexpected error
492: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
493: -- verify the cursor is closed
494: IF l_imsv_csr%ISOPEN THEN
495: CLOSE l_imsv_csr;
496: END IF;

Line 520: x_return_status := OKL_API.G_RET_STS_SUCCESS;

516:
517: BEGIN
518:
519: -- initialize return status
520: x_return_status := OKL_API.G_RET_STS_SUCCESS;
521:
522: -- data is required
523: IF p_cmgv_rec.ivm_id = OKL_API.G_MISS_NUM
524: OR p_cmgv_rec.ivm_id IS NULL

Line 523: IF p_cmgv_rec.ivm_id = OKL_API.G_MISS_NUM

519: -- initialize return status
520: x_return_status := OKL_API.G_RET_STS_SUCCESS;
521:
522: -- data is required
523: IF p_cmgv_rec.ivm_id = OKL_API.G_MISS_NUM
524: OR p_cmgv_rec.ivm_id IS NULL
525: THEN
526:
527: -- display error message

Line 528: OKL_API.set_message(

524: OR p_cmgv_rec.ivm_id IS NULL
525: THEN
526:
527: -- display error message
528: OKL_API.set_message(
529: p_app_name => G_APP_NAME,
530: p_msg_name => G_REQUIRED_VALUE,
531: p_token1 => G_COL_NAME_TOKEN,
532: p_token1_value => 'ivm_id');

Line 535: x_return_status := OKL_API.G_RET_STS_ERROR;

531: p_token1 => G_COL_NAME_TOKEN,
532: p_token1_value => 'ivm_id');
533:
534: -- notify caller of en error
535: x_return_status := OKL_API.G_RET_STS_ERROR;
536: -- halt furhter validation of the column
537: raise G_EXCEPTION_HALT_VALIDATION;
538:
539: END IF;

Line 550: OKL_API.set_message(

546: -- if dummy value is still set to default, data was not found
547: IF (l_dummy_var = '?') THEN
548:
549: -- display error message
550: OKL_API.set_message(
551: p_app_name => G_APP_NAME,
552: p_msg_name => G_NO_PARENT_RECORD,
553: p_token1 => G_COL_NAME_TOKEN,
554: p_token1_value => 'ivm_id',

Line 561: x_return_status := OKL_API.G_RET_STS_ERROR;

557: p_token3 => G_PARENT_TABLE_TOKEN,
558: p_token3_value => 'OKL_INVC_MSS_PRCDRS_V');
559:
560: -- notify caller of en error
561: x_return_status := OKL_API.G_RET_STS_ERROR;
562:
563: END IF;
564:
565: EXCEPTION

Line 573: OKL_API.set_message(

569: null;
570:
571: when OTHERS then
572: -- display error message
573: OKL_API.set_message(
574: p_app_name => G_APP_NAME,
575: p_msg_name => G_UNEXPECTED_ERROR,
576: p_token1 => G_SQLCODE_TOKEN,
577: p_token1_value => SQLCODE,

Line 581: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

577: p_token1_value => SQLCODE,
578: p_token2 => G_SQLERRM_TOKEN,
579: p_token2_value => SQLERRM);
580: -- notify caller of an unexpected error
581: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
582: -- verify the cursor is closed
583: IF l_ivmv_csr%ISOPEN THEN
584: CLOSE l_ivmv_csr;
585: END IF;

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

601: WHERE ims_id = p_cmgv_rec.ims_id
602: AND ivm_id = p_cmgv_rec.ivm_id
603: AND id <> nvl (p_cmgv_rec.id, -99999);
604:
605: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
606: l_dummy VARCHAR2(1);
607: l_found BOOLEAN;
608:
609: BEGIN

Line 620: OKL_API.set_message(

616:
617: IF (l_found) THEN
618:
619: -- display error message
620: OKL_API.set_message(
621: p_app_name => G_APP_NAME,
622: p_msg_name => G_NOT_SAME,
623: p_token1 => 'IMS_ID',
624: p_token1_value => p_cmgv_rec.ims_id,

Line 629: l_return_status := OKL_API.G_RET_STS_ERROR;

625: p_token2 => 'IVM_ID',
626: p_token2_value => p_cmgv_rec.ivm_id);
627:
628: -- notify caller of an error
629: l_return_status := OKL_API.G_RET_STS_ERROR;
630:
631: END IF;
632:
633: -- return status to the caller

Line 640: OKL_API.set_message(

636: EXCEPTION
637:
638: when OTHERS then
639: -- display error message
640: OKL_API.set_message(
641: p_app_name => G_APP_NAME,
642: p_msg_name => G_UNEXPECTED_ERROR,
643: p_token1 => G_SQLCODE_TOKEN,
644: p_token1_value => SQLCODE,

Line 648: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

644: p_token1_value => SQLCODE,
645: p_token2 => G_SQLERRM_TOKEN,
646: p_token2_value => SQLERRM);
647: -- notify caller of an unexpected error
648: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
649: -- verify the cursor is closed
650: IF l_cmgv_csr%ISOPEN THEN
651: CLOSE l_cmgv_csr;
652: END IF;

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

666: FUNCTION Validate_Attributes (
667: p_cmgv_rec IN cmgv_rec_type
668: ) RETURN VARCHAR2 IS
669:
670: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
671: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
672:
673: BEGIN
674:

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

667: p_cmgv_rec IN cmgv_rec_type
668: ) RETURN VARCHAR2 IS
669:
670: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
671: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
672:
673: BEGIN
674:
675: -- call each column-level validation

Line 681: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

677: validate_id (
678: x_return_status => l_return_status,
679: p_cmgv_rec => p_cmgv_rec);
680:
681: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
682: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
683: x_return_status := l_return_status;
684: END IF;
685: END IF;

Line 682: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

678: x_return_status => l_return_status,
679: p_cmgv_rec => p_cmgv_rec);
680:
681: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
682: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
683: x_return_status := l_return_status;
684: END IF;
685: END IF;
686:

Line 691: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

687: validate_object_version_number (
688: x_return_status => l_return_status,
689: p_cmgv_rec => p_cmgv_rec);
690:
691: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
692: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
693: x_return_status := l_return_status;
694: END IF;
695: END IF;

Line 692: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

688: x_return_status => l_return_status,
689: p_cmgv_rec => p_cmgv_rec);
690:
691: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
692: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
693: x_return_status := l_return_status;
694: END IF;
695: END IF;
696:

Line 701: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

697: validate_ims_id (
698: x_return_status => l_return_status,
699: p_cmgv_rec => p_cmgv_rec);
700:
701: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
702: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
703: x_return_status := l_return_status;
704: END IF;
705: END IF;

Line 702: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

698: x_return_status => l_return_status,
699: p_cmgv_rec => p_cmgv_rec);
700:
701: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
702: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
703: x_return_status := l_return_status;
704: END IF;
705: END IF;
706:

Line 711: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

707: validate_ivm_id (
708: x_return_status => l_return_status,
709: p_cmgv_rec => p_cmgv_rec);
710:
711: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
712: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
713: x_return_status := l_return_status;
714: END IF;
715: END IF;

Line 712: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

708: x_return_status => l_return_status,
709: p_cmgv_rec => p_cmgv_rec);
710:
711: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
712: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
713: x_return_status := l_return_status;
714: END IF;
715: END IF;
716:

Line 723: OKL_API.set_message(

719: EXCEPTION
720:
721: when OTHERS then
722: -- display error message
723: OKL_API.set_message(
724: p_app_name => G_APP_NAME,
725: p_msg_name => G_UNEXPECTED_ERROR,
726: p_token1 => G_SQLCODE_TOKEN,
727: p_token1_value => SQLCODE,

Line 731: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

727: p_token1_value => SQLCODE,
728: p_token2 => G_SQLERRM_TOKEN,
729: p_token2_value => SQLERRM);
730: -- notify caller of an unexpected error
731: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
732: -- return status to the caller
733: RETURN x_return_status;
734:
735: END Validate_Attributes;

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

744: -----------------------------------------------
745: FUNCTION Validate_Record (
746: p_cmgv_rec IN cmgv_rec_type
747: ) RETURN VARCHAR2 IS
748: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
749: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
750: BEGIN
751:
752: -- call each record-level validation

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

745: FUNCTION Validate_Record (
746: p_cmgv_rec IN cmgv_rec_type
747: ) RETURN VARCHAR2 IS
748: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
749: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
750: BEGIN
751:
752: -- call each record-level validation
753: l_return_status := is_unique (p_cmgv_rec);

Line 755: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

751:
752: -- call each record-level validation
753: l_return_status := is_unique (p_cmgv_rec);
754:
755: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
756: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
757: x_return_status := l_return_status;
758: END IF;
759: END IF;

Line 756: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

752: -- call each record-level validation
753: l_return_status := is_unique (p_cmgv_rec);
754:
755: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
756: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
757: x_return_status := l_return_status;
758: END IF;
759: END IF;
760:

Line 767: OKL_API.set_message(

763: EXCEPTION
764:
765: when OTHERS then
766: -- display error message
767: OKL_API.set_message(
768: p_app_name => G_APP_NAME,
769: p_msg_name => G_UNEXPECTED_ERROR,
770: p_token1 => G_SQLCODE_TOKEN,
771: p_token1_value => SQLCODE,

Line 775: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

771: p_token1_value => SQLCODE,
772: p_token2 => G_SQLERRM_TOKEN,
773: p_token2_value => SQLERRM);
774: -- notify caller of an unexpected error
775: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
776: -- return status to the caller
777: RETURN x_return_status;
778:
779: END Validate_Record;

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

862: ) IS
863:
864: l_api_version CONSTANT NUMBER := 1;
865: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
866: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
867: l_cmgv_rec cmgv_rec_type := p_cmgv_rec;
868: l_cmg_rec cmg_rec_type;
869: BEGIN
870: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

866: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
867: l_cmgv_rec cmgv_rec_type := p_cmgv_rec;
868: l_cmg_rec cmg_rec_type;
869: BEGIN
870: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
871: G_PKG_NAME,
872: p_init_msg_list,
873: l_api_version,
874: p_api_version,

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

873: l_api_version,
874: p_api_version,
875: '_PVT',
876: x_return_status);
877: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
880: RAISE OKL_API.G_EXCEPTION_ERROR;
881: END IF;

Line 878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

874: p_api_version,
875: '_PVT',
876: x_return_status);
877: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
880: RAISE OKL_API.G_EXCEPTION_ERROR;
881: END IF;
882: --- Validate all non-missing attributes (Item Level Validation)

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

875: '_PVT',
876: x_return_status);
877: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
880: RAISE OKL_API.G_EXCEPTION_ERROR;
881: END IF;
882: --- Validate all non-missing attributes (Item Level Validation)
883: l_return_status := Validate_Attributes(l_cmgv_rec);

Line 880: RAISE OKL_API.G_EXCEPTION_ERROR;

876: x_return_status);
877: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
880: RAISE OKL_API.G_EXCEPTION_ERROR;
881: END IF;
882: --- Validate all non-missing attributes (Item Level Validation)
883: l_return_status := Validate_Attributes(l_cmgv_rec);
884: --- If any errors happen abort API

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

881: END IF;
882: --- Validate all non-missing attributes (Item Level Validation)
883: l_return_status := Validate_Attributes(l_cmgv_rec);
884: --- If any errors happen abort API
885: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
888: RAISE OKL_API.G_EXCEPTION_ERROR;
889: END IF;

Line 886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

882: --- Validate all non-missing attributes (Item Level Validation)
883: l_return_status := Validate_Attributes(l_cmgv_rec);
884: --- If any errors happen abort API
885: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
888: RAISE OKL_API.G_EXCEPTION_ERROR;
889: END IF;
890: l_return_status := Validate_Record(l_cmgv_rec);

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

883: l_return_status := Validate_Attributes(l_cmgv_rec);
884: --- If any errors happen abort API
885: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
888: RAISE OKL_API.G_EXCEPTION_ERROR;
889: END IF;
890: l_return_status := Validate_Record(l_cmgv_rec);
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 888: RAISE OKL_API.G_EXCEPTION_ERROR;

884: --- If any errors happen abort API
885: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
888: RAISE OKL_API.G_EXCEPTION_ERROR;
889: END IF;
890: l_return_status := Validate_Record(l_cmgv_rec);
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

887: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
888: RAISE OKL_API.G_EXCEPTION_ERROR;
889: END IF;
890: l_return_status := Validate_Record(l_cmgv_rec);
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;

Line 892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

888: RAISE OKL_API.G_EXCEPTION_ERROR;
889: END IF;
890: l_return_status := Validate_Record(l_cmgv_rec);
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;
896: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

889: END IF;
890: l_return_status := Validate_Record(l_cmgv_rec);
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;
896: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
897: EXCEPTION

Line 894: RAISE OKL_API.G_EXCEPTION_ERROR;

890: l_return_status := Validate_Record(l_cmgv_rec);
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;
896: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
897: EXCEPTION
898: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;
896: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
897: EXCEPTION
898: WHEN OKL_API.G_EXCEPTION_ERROR THEN
899: x_return_status := OKL_API.HANDLE_EXCEPTIONS
900: (

Line 898: WHEN OKL_API.G_EXCEPTION_ERROR THEN

894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;
896: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
897: EXCEPTION
898: WHEN OKL_API.G_EXCEPTION_ERROR THEN
899: x_return_status := OKL_API.HANDLE_EXCEPTIONS
900: (
901: l_api_name,
902: G_PKG_NAME,

Line 899: x_return_status := OKL_API.HANDLE_EXCEPTIONS

895: END IF;
896: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
897: EXCEPTION
898: WHEN OKL_API.G_EXCEPTION_ERROR THEN
899: x_return_status := OKL_API.HANDLE_EXCEPTIONS
900: (
901: l_api_name,
902: G_PKG_NAME,
903: 'OKL_API.G_RET_STS_ERROR',

Line 903: 'OKL_API.G_RET_STS_ERROR',

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

Line 908: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

904: x_msg_count,
905: x_msg_data,
906: '_PVT'
907: );
908: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
909: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
910: (
911: l_api_name,
912: G_PKG_NAME,

Line 909: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

905: x_msg_data,
906: '_PVT'
907: );
908: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
909: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
910: (
911: l_api_name,
912: G_PKG_NAME,
913: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 913: 'OKL_API.G_RET_STS_UNEXP_ERROR',

909: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
910: (
911: l_api_name,
912: G_PKG_NAME,
913: 'OKL_API.G_RET_STS_UNEXP_ERROR',
914: x_msg_count,
915: x_msg_data,
916: '_PVT'
917: );

Line 919: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

915: x_msg_data,
916: '_PVT'
917: );
918: WHEN OTHERS THEN
919: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
920: (
921: l_api_name,
922: G_PKG_NAME,
923: 'OTHERS',

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

939: ) IS
940:
941: l_api_version CONSTANT NUMBER := 1;
942: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
943: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
944: i NUMBER := 0;
945: -- Begin Post-Generation Change
946: -- overall error status
947: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 947: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

943: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
944: i NUMBER := 0;
945: -- Begin Post-Generation Change
946: -- overall error status
947: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
948: -- End Post-Generation Change
949:
950: BEGIN
951: OKL_API.init_msg_list(p_init_msg_list);

Line 951: OKL_API.init_msg_list(p_init_msg_list);

947: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
948: -- End Post-Generation Change
949:
950: BEGIN
951: OKL_API.init_msg_list(p_init_msg_list);
952: -- Make sure PL/SQL table has records in it before passing
953: IF (p_cmgv_tbl.COUNT > 0) THEN
954: i := p_cmgv_tbl.FIRST;
955: LOOP

Line 958: p_init_msg_list => OKL_API.G_FALSE,

954: i := p_cmgv_tbl.FIRST;
955: LOOP
956: validate_row (
957: p_api_version => p_api_version,
958: p_init_msg_list => OKL_API.G_FALSE,
959: x_return_status => x_return_status,
960: x_msg_count => x_msg_count,
961: x_msg_data => x_msg_data,
962: p_cmgv_rec => p_cmgv_tbl(i));

Line 965: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

961: x_msg_data => x_msg_data,
962: p_cmgv_rec => p_cmgv_tbl(i));
963: -- Begin Post-Generation Change
964: -- store the highest degree of error
965: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
966: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
967: l_overall_status := x_return_status;
968: END IF;
969: END IF;

Line 966: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

962: p_cmgv_rec => p_cmgv_tbl(i));
963: -- Begin Post-Generation Change
964: -- store the highest degree of error
965: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
966: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
967: l_overall_status := x_return_status;
968: END IF;
969: END IF;
970: -- End Post-Generation Change

Line 980: WHEN OKL_API.G_EXCEPTION_ERROR THEN

976: x_return_status := l_overall_status;
977: -- End Post-Generation Change
978: END IF;
979: EXCEPTION
980: WHEN OKL_API.G_EXCEPTION_ERROR THEN
981: x_return_status := OKL_API.HANDLE_EXCEPTIONS
982: (
983: l_api_name,
984: G_PKG_NAME,

Line 981: x_return_status := OKL_API.HANDLE_EXCEPTIONS

977: -- End Post-Generation Change
978: END IF;
979: EXCEPTION
980: WHEN OKL_API.G_EXCEPTION_ERROR THEN
981: x_return_status := OKL_API.HANDLE_EXCEPTIONS
982: (
983: l_api_name,
984: G_PKG_NAME,
985: 'OKL_API.G_RET_STS_ERROR',

Line 985: 'OKL_API.G_RET_STS_ERROR',

981: x_return_status := OKL_API.HANDLE_EXCEPTIONS
982: (
983: l_api_name,
984: G_PKG_NAME,
985: 'OKL_API.G_RET_STS_ERROR',
986: x_msg_count,
987: x_msg_data,
988: '_PVT'
989: );

Line 990: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

986: x_msg_count,
987: x_msg_data,
988: '_PVT'
989: );
990: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
991: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
992: (
993: l_api_name,
994: G_PKG_NAME,

Line 991: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

987: x_msg_data,
988: '_PVT'
989: );
990: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
991: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
992: (
993: l_api_name,
994: G_PKG_NAME,
995: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 995: 'OKL_API.G_RET_STS_UNEXP_ERROR',

991: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
992: (
993: l_api_name,
994: G_PKG_NAME,
995: 'OKL_API.G_RET_STS_UNEXP_ERROR',
996: x_msg_count,
997: x_msg_data,
998: '_PVT'
999: );

Line 1001: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

997: x_msg_data,
998: '_PVT'
999: );
1000: WHEN OTHERS THEN
1001: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1002: (
1003: l_api_name,
1004: G_PKG_NAME,
1005: 'OTHERS',

Line 1019: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1015: ----------------------------------------
1016: -- insert_row for:OKL_CONDITION_MSSGS --
1017: ----------------------------------------
1018: PROCEDURE insert_row(
1019: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1020: x_return_status OUT NOCOPY VARCHAR2,
1021: x_msg_count OUT NOCOPY NUMBER,
1022: x_msg_data OUT NOCOPY VARCHAR2,
1023: p_cmg_rec IN cmg_rec_type,

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

1024: x_cmg_rec OUT NOCOPY cmg_rec_type) IS
1025:
1026: l_api_version CONSTANT NUMBER := 1;
1027: l_api_name CONSTANT VARCHAR2(30) := 'MSSGS_insert_row';
1028: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1029: l_cmg_rec cmg_rec_type := p_cmg_rec;
1030: l_def_cmg_rec cmg_rec_type;
1031: --------------------------------------------
1032: -- Set_Attributes for:OKL_CONDITION_MSSGS --

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

1034: FUNCTION Set_Attributes (
1035: p_cmg_rec IN cmg_rec_type,
1036: x_cmg_rec OUT NOCOPY cmg_rec_type
1037: ) RETURN VARCHAR2 IS
1038: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1039: BEGIN
1040: x_cmg_rec := p_cmg_rec;
1041: RETURN(l_return_status);
1042: END Set_Attributes;

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

1040: x_cmg_rec := p_cmg_rec;
1041: RETURN(l_return_status);
1042: END Set_Attributes;
1043: BEGIN
1044: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1045: p_init_msg_list,
1046: '_PVT',
1047: x_return_status);
1048: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1044: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1045: p_init_msg_list,
1046: '_PVT',
1047: x_return_status);
1048: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1050: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_ERROR;
1052: END IF;

Line 1049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1045: p_init_msg_list,
1046: '_PVT',
1047: x_return_status);
1048: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1050: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_ERROR;
1052: END IF;
1053: --- Setting item attributes

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

1046: '_PVT',
1047: x_return_status);
1048: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1050: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_ERROR;
1052: END IF;
1053: --- Setting item attributes
1054: l_return_status := Set_Attributes(

Line 1051: RAISE OKL_API.G_EXCEPTION_ERROR;

1047: x_return_status);
1048: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1050: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_ERROR;
1052: END IF;
1053: --- Setting item attributes
1054: l_return_status := Set_Attributes(
1055: p_cmg_rec, -- IN

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

1054: l_return_status := Set_Attributes(
1055: p_cmg_rec, -- IN
1056: l_cmg_rec); -- OUT
1057: --- If any errors happen abort API
1058: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1060: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1061: RAISE OKL_API.G_EXCEPTION_ERROR;
1062: END IF;

Line 1059: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1055: p_cmg_rec, -- IN
1056: l_cmg_rec); -- OUT
1057: --- If any errors happen abort API
1058: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1060: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1061: RAISE OKL_API.G_EXCEPTION_ERROR;
1062: END IF;
1063: INSERT INTO OKL_CONDITION_MSSGS(

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

1056: l_cmg_rec); -- OUT
1057: --- If any errors happen abort API
1058: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1060: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1061: RAISE OKL_API.G_EXCEPTION_ERROR;
1062: END IF;
1063: INSERT INTO OKL_CONDITION_MSSGS(
1064: id,

Line 1061: RAISE OKL_API.G_EXCEPTION_ERROR;

1057: --- If any errors happen abort API
1058: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1060: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1061: RAISE OKL_API.G_EXCEPTION_ERROR;
1062: END IF;
1063: INSERT INTO OKL_CONDITION_MSSGS(
1064: id,
1065: ims_id,

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

1115: l_cmg_rec.last_update_date,
1116: l_cmg_rec.last_update_login);
1117: -- Set OUT values
1118: x_cmg_rec := l_cmg_rec;
1119: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1120: EXCEPTION
1121: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1122: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1123: (

Line 1121: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1117: -- Set OUT values
1118: x_cmg_rec := l_cmg_rec;
1119: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1120: EXCEPTION
1121: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1122: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1123: (
1124: l_api_name,
1125: G_PKG_NAME,

Line 1122: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1118: x_cmg_rec := l_cmg_rec;
1119: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1120: EXCEPTION
1121: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1122: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1123: (
1124: l_api_name,
1125: G_PKG_NAME,
1126: 'OKL_API.G_RET_STS_ERROR',

Line 1126: 'OKL_API.G_RET_STS_ERROR',

1122: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1123: (
1124: l_api_name,
1125: G_PKG_NAME,
1126: 'OKL_API.G_RET_STS_ERROR',
1127: x_msg_count,
1128: x_msg_data,
1129: '_PVT'
1130: );

Line 1131: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1127: x_msg_count,
1128: x_msg_data,
1129: '_PVT'
1130: );
1131: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1132: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1133: (
1134: l_api_name,
1135: G_PKG_NAME,

Line 1132: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1128: x_msg_data,
1129: '_PVT'
1130: );
1131: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1132: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1133: (
1134: l_api_name,
1135: G_PKG_NAME,
1136: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1136: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1142: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1138: x_msg_data,
1139: '_PVT'
1140: );
1141: WHEN OTHERS THEN
1142: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1143: (
1144: l_api_name,
1145: G_PKG_NAME,
1146: 'OTHERS',

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

1163: ) IS
1164:
1165: l_api_version CONSTANT NUMBER := 1;
1166: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1167: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1168: l_cmgv_rec cmgv_rec_type;
1169: l_def_cmgv_rec cmgv_rec_type;
1170: l_cmg_rec cmg_rec_type;
1171: lx_cmg_rec cmg_rec_type;

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

1190: FUNCTION Set_Attributes (
1191: p_cmgv_rec IN cmgv_rec_type,
1192: x_cmgv_rec OUT NOCOPY cmgv_rec_type
1193: ) RETURN VARCHAR2 IS
1194: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1195: BEGIN
1196: x_cmgv_rec := p_cmgv_rec;
1197: x_cmgv_rec.OBJECT_VERSION_NUMBER := 1;
1198: RETURN(l_return_status);

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

1197: x_cmgv_rec.OBJECT_VERSION_NUMBER := 1;
1198: RETURN(l_return_status);
1199: END Set_Attributes;
1200: BEGIN
1201: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1202: G_PKG_NAME,
1203: p_init_msg_list,
1204: l_api_version,
1205: p_api_version,

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

1204: l_api_version,
1205: p_api_version,
1206: '_PVT',
1207: x_return_status);
1208: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1209: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1210: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_ERROR;
1212: END IF;

Line 1209: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1205: p_api_version,
1206: '_PVT',
1207: x_return_status);
1208: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1209: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1210: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_ERROR;
1212: END IF;
1213: l_cmgv_rec := null_out_defaults(p_cmgv_rec);

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

1206: '_PVT',
1207: x_return_status);
1208: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1209: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1210: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_ERROR;
1212: END IF;
1213: l_cmgv_rec := null_out_defaults(p_cmgv_rec);
1214: -- Set primary key value

Line 1211: RAISE OKL_API.G_EXCEPTION_ERROR;

1207: x_return_status);
1208: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1209: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1210: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_ERROR;
1212: END IF;
1213: l_cmgv_rec := null_out_defaults(p_cmgv_rec);
1214: -- Set primary key value
1215: l_cmgv_rec.ID := get_seq_id;

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

1217: l_return_status := Set_Attributes(
1218: l_cmgv_rec, -- IN
1219: l_def_cmgv_rec); -- OUT
1220: --- If any errors happen abort API
1221: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_ERROR;
1225: END IF;

Line 1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1218: l_cmgv_rec, -- IN
1219: l_def_cmgv_rec); -- OUT
1220: --- If any errors happen abort API
1221: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_ERROR;
1225: END IF;
1226: l_def_cmgv_rec := fill_who_columns(l_def_cmgv_rec);

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

1219: l_def_cmgv_rec); -- OUT
1220: --- If any errors happen abort API
1221: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_ERROR;
1225: END IF;
1226: l_def_cmgv_rec := fill_who_columns(l_def_cmgv_rec);
1227: --- Validate all non-missing attributes (Item Level Validation)

Line 1224: RAISE OKL_API.G_EXCEPTION_ERROR;

1220: --- If any errors happen abort API
1221: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_ERROR;
1225: END IF;
1226: l_def_cmgv_rec := fill_who_columns(l_def_cmgv_rec);
1227: --- Validate all non-missing attributes (Item Level Validation)
1228: l_return_status := Validate_Attributes(l_def_cmgv_rec);

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

1226: l_def_cmgv_rec := fill_who_columns(l_def_cmgv_rec);
1227: --- Validate all non-missing attributes (Item Level Validation)
1228: l_return_status := Validate_Attributes(l_def_cmgv_rec);
1229: --- If any errors happen abort API
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: --- Validate all non-missing attributes (Item Level Validation)
1228: l_return_status := Validate_Attributes(l_def_cmgv_rec);
1229: --- If any errors happen abort API
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: l_return_status := Validate_Record(l_def_cmgv_rec);

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

1228: l_return_status := Validate_Attributes(l_def_cmgv_rec);
1229: --- If any errors happen abort API
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: l_return_status := Validate_Record(l_def_cmgv_rec);
1236: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1233: RAISE OKL_API.G_EXCEPTION_ERROR;

1229: --- If any errors happen abort API
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: l_return_status := Validate_Record(l_def_cmgv_rec);
1236: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1232: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1233: RAISE OKL_API.G_EXCEPTION_ERROR;
1234: END IF;
1235: l_return_status := Validate_Record(l_def_cmgv_rec);
1236: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1238: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_ERROR;
1240: END IF;

Line 1237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1233: RAISE OKL_API.G_EXCEPTION_ERROR;
1234: END IF;
1235: l_return_status := Validate_Record(l_def_cmgv_rec);
1236: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1238: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_ERROR;
1240: END IF;
1241: --------------------------------------

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

1234: END IF;
1235: l_return_status := Validate_Record(l_def_cmgv_rec);
1236: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1238: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_ERROR;
1240: END IF;
1241: --------------------------------------
1242: -- Move VIEW record to "Child" records

Line 1239: RAISE OKL_API.G_EXCEPTION_ERROR;

1235: l_return_status := Validate_Record(l_def_cmgv_rec);
1236: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1238: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_ERROR;
1240: END IF;
1241: --------------------------------------
1242: -- Move VIEW record to "Child" records
1243: --------------------------------------

Line 1256: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1252: x_msg_data,
1253: l_cmg_rec,
1254: lx_cmg_rec
1255: );
1256: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1257: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1258: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1259: RAISE OKL_API.G_EXCEPTION_ERROR;
1260: END IF;

Line 1257: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1253: l_cmg_rec,
1254: lx_cmg_rec
1255: );
1256: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1257: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1258: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1259: RAISE OKL_API.G_EXCEPTION_ERROR;
1260: END IF;
1261: migrate(lx_cmg_rec, l_def_cmgv_rec);

Line 1258: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1254: lx_cmg_rec
1255: );
1256: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1257: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1258: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1259: RAISE OKL_API.G_EXCEPTION_ERROR;
1260: END IF;
1261: migrate(lx_cmg_rec, l_def_cmgv_rec);
1262: -- Set OUT values

Line 1259: RAISE OKL_API.G_EXCEPTION_ERROR;

1255: );
1256: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1257: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1258: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1259: RAISE OKL_API.G_EXCEPTION_ERROR;
1260: END IF;
1261: migrate(lx_cmg_rec, l_def_cmgv_rec);
1262: -- Set OUT values
1263: x_cmgv_rec := l_def_cmgv_rec;

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

1260: END IF;
1261: migrate(lx_cmg_rec, l_def_cmgv_rec);
1262: -- Set OUT values
1263: x_cmgv_rec := l_def_cmgv_rec;
1264: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1265: EXCEPTION
1266: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1267: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1268: (

Line 1266: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1262: -- Set OUT values
1263: x_cmgv_rec := l_def_cmgv_rec;
1264: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1265: EXCEPTION
1266: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1267: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1268: (
1269: l_api_name,
1270: G_PKG_NAME,

Line 1267: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1271: 'OKL_API.G_RET_STS_ERROR',

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

Line 1276: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1277: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

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

Line 1281: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1287: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

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

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

1308: ) IS
1309:
1310: l_api_version CONSTANT NUMBER := 1;
1311: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1312: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1313: i NUMBER := 0;
1314: -- Begin Post-Generation Change
1315: -- overall error status
1316: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1316: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1312: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1313: i NUMBER := 0;
1314: -- Begin Post-Generation Change
1315: -- overall error status
1316: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1317: -- End Post-Generation Change
1318:
1319: BEGIN
1320: OKL_API.init_msg_list(p_init_msg_list);

Line 1320: OKL_API.init_msg_list(p_init_msg_list);

1316: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1317: -- End Post-Generation Change
1318:
1319: BEGIN
1320: OKL_API.init_msg_list(p_init_msg_list);
1321: -- Make sure PL/SQL table has records in it before passing
1322: IF (p_cmgv_tbl.COUNT > 0) THEN
1323: i := p_cmgv_tbl.FIRST;
1324: LOOP

Line 1327: p_init_msg_list => OKL_API.G_FALSE,

1323: i := p_cmgv_tbl.FIRST;
1324: LOOP
1325: insert_row (
1326: p_api_version => p_api_version,
1327: p_init_msg_list => OKL_API.G_FALSE,
1328: x_return_status => x_return_status,
1329: x_msg_count => x_msg_count,
1330: x_msg_data => x_msg_data,
1331: p_cmgv_rec => p_cmgv_tbl(i),

Line 1335: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1331: p_cmgv_rec => p_cmgv_tbl(i),
1332: x_cmgv_rec => x_cmgv_tbl(i));
1333: -- Begin Post-Generation Change
1334: -- store the highest degree of error
1335: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1336: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1337: l_overall_status := x_return_status;
1338: END IF;
1339: END IF;

Line 1336: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1332: x_cmgv_rec => x_cmgv_tbl(i));
1333: -- Begin Post-Generation Change
1334: -- store the highest degree of error
1335: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1336: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1337: l_overall_status := x_return_status;
1338: END IF;
1339: END IF;
1340: -- End Post-Generation Change

Line 1350: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1346: x_return_status := l_overall_status;
1347: -- End Post-Generation Change
1348: END IF;
1349: EXCEPTION
1350: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1351: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1352: (
1353: l_api_name,
1354: G_PKG_NAME,

Line 1351: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1347: -- End Post-Generation Change
1348: END IF;
1349: EXCEPTION
1350: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1351: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1352: (
1353: l_api_name,
1354: G_PKG_NAME,
1355: 'OKL_API.G_RET_STS_ERROR',

Line 1355: 'OKL_API.G_RET_STS_ERROR',

1351: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1352: (
1353: l_api_name,
1354: G_PKG_NAME,
1355: 'OKL_API.G_RET_STS_ERROR',
1356: x_msg_count,
1357: x_msg_data,
1358: '_PVT'
1359: );

Line 1360: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1356: x_msg_count,
1357: x_msg_data,
1358: '_PVT'
1359: );
1360: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1361: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1362: (
1363: l_api_name,
1364: G_PKG_NAME,

Line 1361: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1357: x_msg_data,
1358: '_PVT'
1359: );
1360: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1361: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1362: (
1363: l_api_name,
1364: G_PKG_NAME,
1365: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1365: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1361: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1362: (
1363: l_api_name,
1364: G_PKG_NAME,
1365: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1366: x_msg_count,
1367: x_msg_data,
1368: '_PVT'
1369: );

Line 1371: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1367: x_msg_data,
1368: '_PVT'
1369: );
1370: WHEN OTHERS THEN
1371: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1372: (
1373: l_api_name,
1374: G_PKG_NAME,
1375: 'OTHERS',

Line 1389: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1385: --------------------------------------
1386: -- lock_row for:OKL_CONDITION_MSSGS --
1387: --------------------------------------
1388: PROCEDURE lock_row(
1389: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1390: x_return_status OUT NOCOPY VARCHAR2,
1391: x_msg_count OUT NOCOPY NUMBER,
1392: x_msg_data OUT NOCOPY VARCHAR2,
1393: p_cmg_rec IN cmg_rec_type) IS

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

1406: FROM OKL_CONDITION_MSSGS
1407: WHERE ID = p_cmg_rec.id;
1408: l_api_version CONSTANT NUMBER := 1;
1409: l_api_name CONSTANT VARCHAR2(30) := 'MSSGS_lock_row';
1410: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1411: l_object_version_number OKL_CONDITION_MSSGS.OBJECT_VERSION_NUMBER%TYPE;
1412: lc_object_version_number OKL_CONDITION_MSSGS.OBJECT_VERSION_NUMBER%TYPE;
1413: l_row_notfound BOOLEAN := FALSE;
1414: lc_row_notfound BOOLEAN := FALSE;

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

1412: lc_object_version_number OKL_CONDITION_MSSGS.OBJECT_VERSION_NUMBER%TYPE;
1413: l_row_notfound BOOLEAN := FALSE;
1414: lc_row_notfound BOOLEAN := FALSE;
1415: BEGIN
1416: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1417: p_init_msg_list,
1418: '_PVT',
1419: x_return_status);
1420: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1416: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1417: p_init_msg_list,
1418: '_PVT',
1419: x_return_status);
1420: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1422: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1423: RAISE OKL_API.G_EXCEPTION_ERROR;
1424: END IF;

Line 1421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1417: p_init_msg_list,
1418: '_PVT',
1419: x_return_status);
1420: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1422: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1423: RAISE OKL_API.G_EXCEPTION_ERROR;
1424: END IF;
1425: BEGIN

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

1418: '_PVT',
1419: x_return_status);
1420: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1422: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1423: RAISE OKL_API.G_EXCEPTION_ERROR;
1424: END IF;
1425: BEGIN
1426: OPEN lock_csr(p_cmg_rec);

Line 1423: RAISE OKL_API.G_EXCEPTION_ERROR;

1419: x_return_status);
1420: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1422: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1423: RAISE OKL_API.G_EXCEPTION_ERROR;
1424: END IF;
1425: BEGIN
1426: OPEN lock_csr(p_cmg_rec);
1427: FETCH lock_csr INTO l_object_version_number;

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

1431: WHEN E_Resource_Busy THEN
1432: IF (lock_csr%ISOPEN) THEN
1433: CLOSE lock_csr;
1434: END IF;
1435: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1436: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1437: END;
1438:
1439: IF ( l_row_notfound ) THEN

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

1442: lc_row_notfound := lchk_csr%NOTFOUND;
1443: CLOSE lchk_csr;
1444: END IF;
1445: IF (lc_row_notfound) THEN
1446: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1447: RAISE OKL_API.G_EXCEPTION_ERROR;
1448: ELSIF lc_object_version_number > p_cmg_rec.object_version_number THEN
1449: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1450: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1447: RAISE OKL_API.G_EXCEPTION_ERROR;

1443: CLOSE lchk_csr;
1444: END IF;
1445: IF (lc_row_notfound) THEN
1446: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1447: RAISE OKL_API.G_EXCEPTION_ERROR;
1448: ELSIF lc_object_version_number > p_cmg_rec.object_version_number THEN
1449: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1450: RAISE OKL_API.G_EXCEPTION_ERROR;
1451: ELSIF lc_object_version_number <> p_cmg_rec.object_version_number THEN

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

1445: IF (lc_row_notfound) THEN
1446: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1447: RAISE OKL_API.G_EXCEPTION_ERROR;
1448: ELSIF lc_object_version_number > p_cmg_rec.object_version_number THEN
1449: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1450: RAISE OKL_API.G_EXCEPTION_ERROR;
1451: ELSIF lc_object_version_number <> p_cmg_rec.object_version_number THEN
1452: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1453: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1450: RAISE OKL_API.G_EXCEPTION_ERROR;

1446: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1447: RAISE OKL_API.G_EXCEPTION_ERROR;
1448: ELSIF lc_object_version_number > p_cmg_rec.object_version_number THEN
1449: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1450: RAISE OKL_API.G_EXCEPTION_ERROR;
1451: ELSIF lc_object_version_number <> p_cmg_rec.object_version_number THEN
1452: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454: ELSIF lc_object_version_number = -1 THEN

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

1448: ELSIF lc_object_version_number > p_cmg_rec.object_version_number THEN
1449: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1450: RAISE OKL_API.G_EXCEPTION_ERROR;
1451: ELSIF lc_object_version_number <> p_cmg_rec.object_version_number THEN
1452: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454: ELSIF lc_object_version_number = -1 THEN
1455: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1456: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1453: RAISE OKL_API.G_EXCEPTION_ERROR;

1449: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1450: RAISE OKL_API.G_EXCEPTION_ERROR;
1451: ELSIF lc_object_version_number <> p_cmg_rec.object_version_number THEN
1452: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454: ELSIF lc_object_version_number = -1 THEN
1455: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1456: RAISE OKL_API.G_EXCEPTION_ERROR;
1457: END IF;

Line 1455: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1451: ELSIF lc_object_version_number <> p_cmg_rec.object_version_number THEN
1452: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454: ELSIF lc_object_version_number = -1 THEN
1455: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1456: RAISE OKL_API.G_EXCEPTION_ERROR;
1457: END IF;
1458: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1459: EXCEPTION

Line 1456: RAISE OKL_API.G_EXCEPTION_ERROR;

1452: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454: ELSIF lc_object_version_number = -1 THEN
1455: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1456: RAISE OKL_API.G_EXCEPTION_ERROR;
1457: END IF;
1458: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1459: EXCEPTION
1460: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

1454: ELSIF lc_object_version_number = -1 THEN
1455: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1456: RAISE OKL_API.G_EXCEPTION_ERROR;
1457: END IF;
1458: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1459: EXCEPTION
1460: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1461: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1462: (

Line 1460: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1456: RAISE OKL_API.G_EXCEPTION_ERROR;
1457: END IF;
1458: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1459: EXCEPTION
1460: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1461: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1462: (
1463: l_api_name,
1464: G_PKG_NAME,

Line 1461: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1457: END IF;
1458: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1459: EXCEPTION
1460: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1461: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1462: (
1463: l_api_name,
1464: G_PKG_NAME,
1465: 'OKL_API.G_RET_STS_ERROR',

Line 1465: 'OKL_API.G_RET_STS_ERROR',

1461: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1462: (
1463: l_api_name,
1464: G_PKG_NAME,
1465: 'OKL_API.G_RET_STS_ERROR',
1466: x_msg_count,
1467: x_msg_data,
1468: '_PVT'
1469: );

Line 1470: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1471: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1467: x_msg_data,
1468: '_PVT'
1469: );
1470: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1471: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1472: (
1473: l_api_name,
1474: G_PKG_NAME,
1475: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1475: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1481: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

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

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

1501: ) IS
1502:
1503: l_api_version CONSTANT NUMBER := 1;
1504: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1505: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1506: l_cmg_rec cmg_rec_type;
1507: BEGIN
1508: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1509: G_PKG_NAME,

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

1504: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1505: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1506: l_cmg_rec cmg_rec_type;
1507: BEGIN
1508: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1509: G_PKG_NAME,
1510: p_init_msg_list,
1511: l_api_version,
1512: p_api_version,

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

1511: l_api_version,
1512: p_api_version,
1513: '_PVT',
1514: x_return_status);
1515: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1516: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1517: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1518: RAISE OKL_API.G_EXCEPTION_ERROR;
1519: END IF;

Line 1516: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1512: p_api_version,
1513: '_PVT',
1514: x_return_status);
1515: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1516: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1517: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1518: RAISE OKL_API.G_EXCEPTION_ERROR;
1519: END IF;
1520: --------------------------------------

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

1513: '_PVT',
1514: x_return_status);
1515: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1516: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1517: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1518: RAISE OKL_API.G_EXCEPTION_ERROR;
1519: END IF;
1520: --------------------------------------
1521: -- Move VIEW record to "Child" records

Line 1518: RAISE OKL_API.G_EXCEPTION_ERROR;

1514: x_return_status);
1515: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1516: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1517: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1518: RAISE OKL_API.G_EXCEPTION_ERROR;
1519: END IF;
1520: --------------------------------------
1521: -- Move VIEW record to "Child" records
1522: --------------------------------------

Line 1534: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1530: x_msg_count,
1531: x_msg_data,
1532: l_cmg_rec
1533: );
1534: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1537: RAISE OKL_API.G_EXCEPTION_ERROR;
1538: END IF;

Line 1535: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1531: x_msg_data,
1532: l_cmg_rec
1533: );
1534: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1537: RAISE OKL_API.G_EXCEPTION_ERROR;
1538: END IF;
1539: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1536: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1532: l_cmg_rec
1533: );
1534: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1537: RAISE OKL_API.G_EXCEPTION_ERROR;
1538: END IF;
1539: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1540: EXCEPTION

Line 1537: RAISE OKL_API.G_EXCEPTION_ERROR;

1533: );
1534: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1537: RAISE OKL_API.G_EXCEPTION_ERROR;
1538: END IF;
1539: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1540: EXCEPTION
1541: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

1535: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1537: RAISE OKL_API.G_EXCEPTION_ERROR;
1538: END IF;
1539: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1540: EXCEPTION
1541: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1542: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1543: (

Line 1541: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1537: RAISE OKL_API.G_EXCEPTION_ERROR;
1538: END IF;
1539: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1540: EXCEPTION
1541: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1542: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1543: (
1544: l_api_name,
1545: G_PKG_NAME,

Line 1542: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1538: END IF;
1539: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1540: EXCEPTION
1541: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1542: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1543: (
1544: l_api_name,
1545: G_PKG_NAME,
1546: 'OKL_API.G_RET_STS_ERROR',

Line 1546: 'OKL_API.G_RET_STS_ERROR',

1542: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1543: (
1544: l_api_name,
1545: G_PKG_NAME,
1546: 'OKL_API.G_RET_STS_ERROR',
1547: x_msg_count,
1548: x_msg_data,
1549: '_PVT'
1550: );

Line 1551: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1547: x_msg_count,
1548: x_msg_data,
1549: '_PVT'
1550: );
1551: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1552: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1553: (
1554: l_api_name,
1555: G_PKG_NAME,

Line 1552: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1548: x_msg_data,
1549: '_PVT'
1550: );
1551: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1552: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1553: (
1554: l_api_name,
1555: G_PKG_NAME,
1556: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1556: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1552: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1553: (
1554: l_api_name,
1555: G_PKG_NAME,
1556: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1557: x_msg_count,
1558: x_msg_data,
1559: '_PVT'
1560: );

Line 1562: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1558: x_msg_data,
1559: '_PVT'
1560: );
1561: WHEN OTHERS THEN
1562: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1563: (
1564: l_api_name,
1565: G_PKG_NAME,
1566: 'OTHERS',

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

1582: ) IS
1583:
1584: l_api_version CONSTANT NUMBER := 1;
1585: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1586: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1587: i NUMBER := 0;
1588: -- Begin Post-Generation Change
1589: -- overall error status
1590: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1590: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1586: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1587: i NUMBER := 0;
1588: -- Begin Post-Generation Change
1589: -- overall error status
1590: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1591: -- End Post-Generation Change
1592:
1593: BEGIN
1594: OKL_API.init_msg_list(p_init_msg_list);

Line 1594: OKL_API.init_msg_list(p_init_msg_list);

1590: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1591: -- End Post-Generation Change
1592:
1593: BEGIN
1594: OKL_API.init_msg_list(p_init_msg_list);
1595: -- Make sure PL/SQL table has records in it before passing
1596: IF (p_cmgv_tbl.COUNT > 0) THEN
1597: i := p_cmgv_tbl.FIRST;
1598: LOOP

Line 1601: p_init_msg_list => OKL_API.G_FALSE,

1597: i := p_cmgv_tbl.FIRST;
1598: LOOP
1599: lock_row (
1600: p_api_version => p_api_version,
1601: p_init_msg_list => OKL_API.G_FALSE,
1602: x_return_status => x_return_status,
1603: x_msg_count => x_msg_count,
1604: x_msg_data => x_msg_data,
1605: p_cmgv_rec => p_cmgv_tbl(i));

Line 1608: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1604: x_msg_data => x_msg_data,
1605: p_cmgv_rec => p_cmgv_tbl(i));
1606: -- Begin Post-Generation Change
1607: -- store the highest degree of error
1608: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1609: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1610: l_overall_status := x_return_status;
1611: END IF;
1612: END IF;

Line 1609: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1605: p_cmgv_rec => p_cmgv_tbl(i));
1606: -- Begin Post-Generation Change
1607: -- store the highest degree of error
1608: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1609: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1610: l_overall_status := x_return_status;
1611: END IF;
1612: END IF;
1613: -- End Post-Generation Change

Line 1623: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1619: x_return_status := l_overall_status;
1620: -- End Post-Generation Change
1621: END IF;
1622: EXCEPTION
1623: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1624: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1625: (
1626: l_api_name,
1627: G_PKG_NAME,

Line 1624: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1620: -- End Post-Generation Change
1621: END IF;
1622: EXCEPTION
1623: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1624: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1625: (
1626: l_api_name,
1627: G_PKG_NAME,
1628: 'OKL_API.G_RET_STS_ERROR',

Line 1628: 'OKL_API.G_RET_STS_ERROR',

1624: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1625: (
1626: l_api_name,
1627: G_PKG_NAME,
1628: 'OKL_API.G_RET_STS_ERROR',
1629: x_msg_count,
1630: x_msg_data,
1631: '_PVT'
1632: );

Line 1633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1629: x_msg_count,
1630: x_msg_data,
1631: '_PVT'
1632: );
1633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1634: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1635: (
1636: l_api_name,
1637: G_PKG_NAME,

Line 1634: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1630: x_msg_data,
1631: '_PVT'
1632: );
1633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1634: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1635: (
1636: l_api_name,
1637: G_PKG_NAME,
1638: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1638: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1634: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1635: (
1636: l_api_name,
1637: G_PKG_NAME,
1638: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1639: x_msg_count,
1640: x_msg_data,
1641: '_PVT'
1642: );

Line 1644: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1640: x_msg_data,
1641: '_PVT'
1642: );
1643: WHEN OTHERS THEN
1644: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1645: (
1646: l_api_name,
1647: G_PKG_NAME,
1648: 'OTHERS',

Line 1662: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1658: ----------------------------------------
1659: -- update_row for:OKL_CONDITION_MSSGS --
1660: ----------------------------------------
1661: PROCEDURE update_row(
1662: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1663: x_return_status OUT NOCOPY VARCHAR2,
1664: x_msg_count OUT NOCOPY NUMBER,
1665: x_msg_data OUT NOCOPY VARCHAR2,
1666: p_cmg_rec IN cmg_rec_type,

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

1667: x_cmg_rec OUT NOCOPY cmg_rec_type) IS
1668:
1669: l_api_version CONSTANT NUMBER := 1;
1670: l_api_name CONSTANT VARCHAR2(30) := 'MSSGS_update_row';
1671: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1672: l_cmg_rec cmg_rec_type := p_cmg_rec;
1673: l_def_cmg_rec cmg_rec_type;
1674: l_row_notfound BOOLEAN := TRUE;
1675: ----------------------------------

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

1680: x_cmg_rec OUT NOCOPY cmg_rec_type
1681: ) RETURN VARCHAR2 IS
1682: l_cmg_rec cmg_rec_type;
1683: l_row_notfound BOOLEAN := TRUE;
1684: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1685: BEGIN
1686: x_cmg_rec := p_cmg_rec;
1687: -- Get current database values
1688: l_cmg_rec := get_rec(p_cmg_rec, l_row_notfound);

Line 1690: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1686: x_cmg_rec := p_cmg_rec;
1687: -- Get current database values
1688: l_cmg_rec := get_rec(p_cmg_rec, l_row_notfound);
1689: IF (l_row_notfound) THEN
1690: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1691: END IF;
1692: IF (x_cmg_rec.id = OKL_API.G_MISS_NUM)
1693: THEN
1694: x_cmg_rec.id := l_cmg_rec.id;

Line 1692: IF (x_cmg_rec.id = OKL_API.G_MISS_NUM)

1688: l_cmg_rec := get_rec(p_cmg_rec, l_row_notfound);
1689: IF (l_row_notfound) THEN
1690: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1691: END IF;
1692: IF (x_cmg_rec.id = OKL_API.G_MISS_NUM)
1693: THEN
1694: x_cmg_rec.id := l_cmg_rec.id;
1695: END IF;
1696: IF (x_cmg_rec.ims_id = OKL_API.G_MISS_NUM)

Line 1696: IF (x_cmg_rec.ims_id = OKL_API.G_MISS_NUM)

1692: IF (x_cmg_rec.id = OKL_API.G_MISS_NUM)
1693: THEN
1694: x_cmg_rec.id := l_cmg_rec.id;
1695: END IF;
1696: IF (x_cmg_rec.ims_id = OKL_API.G_MISS_NUM)
1697: THEN
1698: x_cmg_rec.ims_id := l_cmg_rec.ims_id;
1699: END IF;
1700: IF (x_cmg_rec.ivm_id = OKL_API.G_MISS_NUM)

Line 1700: IF (x_cmg_rec.ivm_id = OKL_API.G_MISS_NUM)

1696: IF (x_cmg_rec.ims_id = OKL_API.G_MISS_NUM)
1697: THEN
1698: x_cmg_rec.ims_id := l_cmg_rec.ims_id;
1699: END IF;
1700: IF (x_cmg_rec.ivm_id = OKL_API.G_MISS_NUM)
1701: THEN
1702: x_cmg_rec.ivm_id := l_cmg_rec.ivm_id;
1703: END IF;
1704: IF (x_cmg_rec.object_version_number = OKL_API.G_MISS_NUM)

Line 1704: IF (x_cmg_rec.object_version_number = OKL_API.G_MISS_NUM)

1700: IF (x_cmg_rec.ivm_id = OKL_API.G_MISS_NUM)
1701: THEN
1702: x_cmg_rec.ivm_id := l_cmg_rec.ivm_id;
1703: END IF;
1704: IF (x_cmg_rec.object_version_number = OKL_API.G_MISS_NUM)
1705: THEN
1706: x_cmg_rec.object_version_number := l_cmg_rec.object_version_number;
1707: END IF;
1708: IF (x_cmg_rec.sequence_number = OKL_API.G_MISS_NUM)

Line 1708: IF (x_cmg_rec.sequence_number = OKL_API.G_MISS_NUM)

1704: IF (x_cmg_rec.object_version_number = OKL_API.G_MISS_NUM)
1705: THEN
1706: x_cmg_rec.object_version_number := l_cmg_rec.object_version_number;
1707: END IF;
1708: IF (x_cmg_rec.sequence_number = OKL_API.G_MISS_NUM)
1709: THEN
1710: x_cmg_rec.sequence_number := l_cmg_rec.sequence_number;
1711: END IF;
1712: IF (x_cmg_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 1712: IF (x_cmg_rec.attribute_category = OKL_API.G_MISS_CHAR)

1708: IF (x_cmg_rec.sequence_number = OKL_API.G_MISS_NUM)
1709: THEN
1710: x_cmg_rec.sequence_number := l_cmg_rec.sequence_number;
1711: END IF;
1712: IF (x_cmg_rec.attribute_category = OKL_API.G_MISS_CHAR)
1713: THEN
1714: x_cmg_rec.attribute_category := l_cmg_rec.attribute_category;
1715: END IF;
1716: IF (x_cmg_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 1716: IF (x_cmg_rec.attribute1 = OKL_API.G_MISS_CHAR)

1712: IF (x_cmg_rec.attribute_category = OKL_API.G_MISS_CHAR)
1713: THEN
1714: x_cmg_rec.attribute_category := l_cmg_rec.attribute_category;
1715: END IF;
1716: IF (x_cmg_rec.attribute1 = OKL_API.G_MISS_CHAR)
1717: THEN
1718: x_cmg_rec.attribute1 := l_cmg_rec.attribute1;
1719: END IF;
1720: IF (x_cmg_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 1720: IF (x_cmg_rec.attribute2 = OKL_API.G_MISS_CHAR)

1716: IF (x_cmg_rec.attribute1 = OKL_API.G_MISS_CHAR)
1717: THEN
1718: x_cmg_rec.attribute1 := l_cmg_rec.attribute1;
1719: END IF;
1720: IF (x_cmg_rec.attribute2 = OKL_API.G_MISS_CHAR)
1721: THEN
1722: x_cmg_rec.attribute2 := l_cmg_rec.attribute2;
1723: END IF;
1724: IF (x_cmg_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 1724: IF (x_cmg_rec.attribute3 = OKL_API.G_MISS_CHAR)

1720: IF (x_cmg_rec.attribute2 = OKL_API.G_MISS_CHAR)
1721: THEN
1722: x_cmg_rec.attribute2 := l_cmg_rec.attribute2;
1723: END IF;
1724: IF (x_cmg_rec.attribute3 = OKL_API.G_MISS_CHAR)
1725: THEN
1726: x_cmg_rec.attribute3 := l_cmg_rec.attribute3;
1727: END IF;
1728: IF (x_cmg_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 1728: IF (x_cmg_rec.attribute4 = OKL_API.G_MISS_CHAR)

1724: IF (x_cmg_rec.attribute3 = OKL_API.G_MISS_CHAR)
1725: THEN
1726: x_cmg_rec.attribute3 := l_cmg_rec.attribute3;
1727: END IF;
1728: IF (x_cmg_rec.attribute4 = OKL_API.G_MISS_CHAR)
1729: THEN
1730: x_cmg_rec.attribute4 := l_cmg_rec.attribute4;
1731: END IF;
1732: IF (x_cmg_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 1732: IF (x_cmg_rec.attribute5 = OKL_API.G_MISS_CHAR)

1728: IF (x_cmg_rec.attribute4 = OKL_API.G_MISS_CHAR)
1729: THEN
1730: x_cmg_rec.attribute4 := l_cmg_rec.attribute4;
1731: END IF;
1732: IF (x_cmg_rec.attribute5 = OKL_API.G_MISS_CHAR)
1733: THEN
1734: x_cmg_rec.attribute5 := l_cmg_rec.attribute5;
1735: END IF;
1736: IF (x_cmg_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 1736: IF (x_cmg_rec.attribute6 = OKL_API.G_MISS_CHAR)

1732: IF (x_cmg_rec.attribute5 = OKL_API.G_MISS_CHAR)
1733: THEN
1734: x_cmg_rec.attribute5 := l_cmg_rec.attribute5;
1735: END IF;
1736: IF (x_cmg_rec.attribute6 = OKL_API.G_MISS_CHAR)
1737: THEN
1738: x_cmg_rec.attribute6 := l_cmg_rec.attribute6;
1739: END IF;
1740: IF (x_cmg_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 1740: IF (x_cmg_rec.attribute7 = OKL_API.G_MISS_CHAR)

1736: IF (x_cmg_rec.attribute6 = OKL_API.G_MISS_CHAR)
1737: THEN
1738: x_cmg_rec.attribute6 := l_cmg_rec.attribute6;
1739: END IF;
1740: IF (x_cmg_rec.attribute7 = OKL_API.G_MISS_CHAR)
1741: THEN
1742: x_cmg_rec.attribute7 := l_cmg_rec.attribute7;
1743: END IF;
1744: IF (x_cmg_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 1744: IF (x_cmg_rec.attribute8 = OKL_API.G_MISS_CHAR)

1740: IF (x_cmg_rec.attribute7 = OKL_API.G_MISS_CHAR)
1741: THEN
1742: x_cmg_rec.attribute7 := l_cmg_rec.attribute7;
1743: END IF;
1744: IF (x_cmg_rec.attribute8 = OKL_API.G_MISS_CHAR)
1745: THEN
1746: x_cmg_rec.attribute8 := l_cmg_rec.attribute8;
1747: END IF;
1748: IF (x_cmg_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 1748: IF (x_cmg_rec.attribute9 = OKL_API.G_MISS_CHAR)

1744: IF (x_cmg_rec.attribute8 = OKL_API.G_MISS_CHAR)
1745: THEN
1746: x_cmg_rec.attribute8 := l_cmg_rec.attribute8;
1747: END IF;
1748: IF (x_cmg_rec.attribute9 = OKL_API.G_MISS_CHAR)
1749: THEN
1750: x_cmg_rec.attribute9 := l_cmg_rec.attribute9;
1751: END IF;
1752: IF (x_cmg_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 1752: IF (x_cmg_rec.attribute10 = OKL_API.G_MISS_CHAR)

1748: IF (x_cmg_rec.attribute9 = OKL_API.G_MISS_CHAR)
1749: THEN
1750: x_cmg_rec.attribute9 := l_cmg_rec.attribute9;
1751: END IF;
1752: IF (x_cmg_rec.attribute10 = OKL_API.G_MISS_CHAR)
1753: THEN
1754: x_cmg_rec.attribute10 := l_cmg_rec.attribute10;
1755: END IF;
1756: IF (x_cmg_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 1756: IF (x_cmg_rec.attribute11 = OKL_API.G_MISS_CHAR)

1752: IF (x_cmg_rec.attribute10 = OKL_API.G_MISS_CHAR)
1753: THEN
1754: x_cmg_rec.attribute10 := l_cmg_rec.attribute10;
1755: END IF;
1756: IF (x_cmg_rec.attribute11 = OKL_API.G_MISS_CHAR)
1757: THEN
1758: x_cmg_rec.attribute11 := l_cmg_rec.attribute11;
1759: END IF;
1760: IF (x_cmg_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 1760: IF (x_cmg_rec.attribute12 = OKL_API.G_MISS_CHAR)

1756: IF (x_cmg_rec.attribute11 = OKL_API.G_MISS_CHAR)
1757: THEN
1758: x_cmg_rec.attribute11 := l_cmg_rec.attribute11;
1759: END IF;
1760: IF (x_cmg_rec.attribute12 = OKL_API.G_MISS_CHAR)
1761: THEN
1762: x_cmg_rec.attribute12 := l_cmg_rec.attribute12;
1763: END IF;
1764: IF (x_cmg_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 1764: IF (x_cmg_rec.attribute13 = OKL_API.G_MISS_CHAR)

1760: IF (x_cmg_rec.attribute12 = OKL_API.G_MISS_CHAR)
1761: THEN
1762: x_cmg_rec.attribute12 := l_cmg_rec.attribute12;
1763: END IF;
1764: IF (x_cmg_rec.attribute13 = OKL_API.G_MISS_CHAR)
1765: THEN
1766: x_cmg_rec.attribute13 := l_cmg_rec.attribute13;
1767: END IF;
1768: IF (x_cmg_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 1768: IF (x_cmg_rec.attribute14 = OKL_API.G_MISS_CHAR)

1764: IF (x_cmg_rec.attribute13 = OKL_API.G_MISS_CHAR)
1765: THEN
1766: x_cmg_rec.attribute13 := l_cmg_rec.attribute13;
1767: END IF;
1768: IF (x_cmg_rec.attribute14 = OKL_API.G_MISS_CHAR)
1769: THEN
1770: x_cmg_rec.attribute14 := l_cmg_rec.attribute14;
1771: END IF;
1772: IF (x_cmg_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 1772: IF (x_cmg_rec.attribute15 = OKL_API.G_MISS_CHAR)

1768: IF (x_cmg_rec.attribute14 = OKL_API.G_MISS_CHAR)
1769: THEN
1770: x_cmg_rec.attribute14 := l_cmg_rec.attribute14;
1771: END IF;
1772: IF (x_cmg_rec.attribute15 = OKL_API.G_MISS_CHAR)
1773: THEN
1774: x_cmg_rec.attribute15 := l_cmg_rec.attribute15;
1775: END IF;
1776: IF (x_cmg_rec.created_by = OKL_API.G_MISS_NUM)

Line 1776: IF (x_cmg_rec.created_by = OKL_API.G_MISS_NUM)

1772: IF (x_cmg_rec.attribute15 = OKL_API.G_MISS_CHAR)
1773: THEN
1774: x_cmg_rec.attribute15 := l_cmg_rec.attribute15;
1775: END IF;
1776: IF (x_cmg_rec.created_by = OKL_API.G_MISS_NUM)
1777: THEN
1778: x_cmg_rec.created_by := l_cmg_rec.created_by;
1779: END IF;
1780: IF (x_cmg_rec.creation_date = OKL_API.G_MISS_DATE)

Line 1780: IF (x_cmg_rec.creation_date = OKL_API.G_MISS_DATE)

1776: IF (x_cmg_rec.created_by = OKL_API.G_MISS_NUM)
1777: THEN
1778: x_cmg_rec.created_by := l_cmg_rec.created_by;
1779: END IF;
1780: IF (x_cmg_rec.creation_date = OKL_API.G_MISS_DATE)
1781: THEN
1782: x_cmg_rec.creation_date := l_cmg_rec.creation_date;
1783: END IF;
1784: IF (x_cmg_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 1784: IF (x_cmg_rec.last_updated_by = OKL_API.G_MISS_NUM)

1780: IF (x_cmg_rec.creation_date = OKL_API.G_MISS_DATE)
1781: THEN
1782: x_cmg_rec.creation_date := l_cmg_rec.creation_date;
1783: END IF;
1784: IF (x_cmg_rec.last_updated_by = OKL_API.G_MISS_NUM)
1785: THEN
1786: x_cmg_rec.last_updated_by := l_cmg_rec.last_updated_by;
1787: END IF;
1788: IF (x_cmg_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 1788: IF (x_cmg_rec.last_update_date = OKL_API.G_MISS_DATE)

1784: IF (x_cmg_rec.last_updated_by = OKL_API.G_MISS_NUM)
1785: THEN
1786: x_cmg_rec.last_updated_by := l_cmg_rec.last_updated_by;
1787: END IF;
1788: IF (x_cmg_rec.last_update_date = OKL_API.G_MISS_DATE)
1789: THEN
1790: x_cmg_rec.last_update_date := l_cmg_rec.last_update_date;
1791: END IF;
1792: IF (x_cmg_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 1792: IF (x_cmg_rec.last_update_login = OKL_API.G_MISS_NUM)

1788: IF (x_cmg_rec.last_update_date = OKL_API.G_MISS_DATE)
1789: THEN
1790: x_cmg_rec.last_update_date := l_cmg_rec.last_update_date;
1791: END IF;
1792: IF (x_cmg_rec.last_update_login = OKL_API.G_MISS_NUM)
1793: THEN
1794: x_cmg_rec.last_update_login := l_cmg_rec.last_update_login;
1795: END IF;
1796: RETURN(l_return_status);

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

1801: FUNCTION Set_Attributes (
1802: p_cmg_rec IN cmg_rec_type,
1803: x_cmg_rec OUT NOCOPY cmg_rec_type
1804: ) RETURN VARCHAR2 IS
1805: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1806: BEGIN
1807: x_cmg_rec := p_cmg_rec;
1808: RETURN(l_return_status);
1809: END Set_Attributes;

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

1807: x_cmg_rec := p_cmg_rec;
1808: RETURN(l_return_status);
1809: END Set_Attributes;
1810: BEGIN
1811: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1812: p_init_msg_list,
1813: '_PVT',
1814: x_return_status);
1815: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

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

Line 1816: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1818: RAISE OKL_API.G_EXCEPTION_ERROR;

1814: x_return_status);
1815: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1816: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1817: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1818: RAISE OKL_API.G_EXCEPTION_ERROR;
1819: END IF;
1820: --- Setting item attributes
1821: l_return_status := Set_Attributes(
1822: p_cmg_rec, -- IN

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

1821: l_return_status := Set_Attributes(
1822: p_cmg_rec, -- IN
1823: l_cmg_rec); -- OUT
1824: --- If any errors happen abort API
1825: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1828: RAISE OKL_API.G_EXCEPTION_ERROR;
1829: END IF;

Line 1826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1822: p_cmg_rec, -- IN
1823: l_cmg_rec); -- OUT
1824: --- If any errors happen abort API
1825: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1828: RAISE OKL_API.G_EXCEPTION_ERROR;
1829: END IF;
1830: l_return_status := populate_new_record(l_cmg_rec, l_def_cmg_rec);

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

1823: l_cmg_rec); -- OUT
1824: --- If any errors happen abort API
1825: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1828: RAISE OKL_API.G_EXCEPTION_ERROR;
1829: END IF;
1830: l_return_status := populate_new_record(l_cmg_rec, l_def_cmg_rec);
1831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1828: RAISE OKL_API.G_EXCEPTION_ERROR;

1824: --- If any errors happen abort API
1825: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1828: RAISE OKL_API.G_EXCEPTION_ERROR;
1829: END IF;
1830: l_return_status := populate_new_record(l_cmg_rec, l_def_cmg_rec);
1831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1832: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1828: RAISE OKL_API.G_EXCEPTION_ERROR;
1829: END IF;
1830: l_return_status := populate_new_record(l_cmg_rec, l_def_cmg_rec);
1831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1832: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1834: RAISE OKL_API.G_EXCEPTION_ERROR;
1835: END IF;

Line 1832: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1828: RAISE OKL_API.G_EXCEPTION_ERROR;
1829: END IF;
1830: l_return_status := populate_new_record(l_cmg_rec, l_def_cmg_rec);
1831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1832: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1834: RAISE OKL_API.G_EXCEPTION_ERROR;
1835: END IF;
1836: UPDATE OKL_CONDITION_MSSGS

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

1829: END IF;
1830: l_return_status := populate_new_record(l_cmg_rec, l_def_cmg_rec);
1831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1832: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1834: RAISE OKL_API.G_EXCEPTION_ERROR;
1835: END IF;
1836: UPDATE OKL_CONDITION_MSSGS
1837: SET IMS_ID = l_def_cmg_rec.ims_id,

Line 1834: RAISE OKL_API.G_EXCEPTION_ERROR;

1830: l_return_status := populate_new_record(l_cmg_rec, l_def_cmg_rec);
1831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1832: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1834: RAISE OKL_API.G_EXCEPTION_ERROR;
1835: END IF;
1836: UPDATE OKL_CONDITION_MSSGS
1837: SET IMS_ID = l_def_cmg_rec.ims_id,
1838: IVM_ID = l_def_cmg_rec.ivm_id,

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

1861: LAST_UPDATE_LOGIN = l_def_cmg_rec.last_update_login
1862: WHERE ID = l_def_cmg_rec.id;
1863:
1864: x_cmg_rec := l_def_cmg_rec;
1865: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1866: EXCEPTION
1867: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1868: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1869: (

Line 1867: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1863:
1864: x_cmg_rec := l_def_cmg_rec;
1865: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1866: EXCEPTION
1867: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1868: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1869: (
1870: l_api_name,
1871: G_PKG_NAME,

Line 1868: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1864: x_cmg_rec := l_def_cmg_rec;
1865: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1866: EXCEPTION
1867: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1868: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1869: (
1870: l_api_name,
1871: G_PKG_NAME,
1872: 'OKL_API.G_RET_STS_ERROR',

Line 1872: 'OKL_API.G_RET_STS_ERROR',

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

Line 1877: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1873: x_msg_count,
1874: x_msg_data,
1875: '_PVT'
1876: );
1877: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1878: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1879: (
1880: l_api_name,
1881: G_PKG_NAME,

Line 1878: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1874: x_msg_data,
1875: '_PVT'
1876: );
1877: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1878: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1879: (
1880: l_api_name,
1881: G_PKG_NAME,
1882: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1882: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1878: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1879: (
1880: l_api_name,
1881: G_PKG_NAME,
1882: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1883: x_msg_count,
1884: x_msg_data,
1885: '_PVT'
1886: );

Line 1888: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1884: x_msg_data,
1885: '_PVT'
1886: );
1887: WHEN OTHERS THEN
1888: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1889: (
1890: l_api_name,
1891: G_PKG_NAME,
1892: 'OTHERS',

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

1909: ) IS
1910:
1911: l_api_version CONSTANT NUMBER := 1;
1912: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1913: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1914: l_cmgv_rec cmgv_rec_type := p_cmgv_rec;
1915: l_def_cmgv_rec cmgv_rec_type;
1916: l_cmg_rec cmg_rec_type;
1917: lx_cmg_rec cmg_rec_type;

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

1936: x_cmgv_rec OUT NOCOPY cmgv_rec_type
1937: ) RETURN VARCHAR2 IS
1938: l_cmgv_rec cmgv_rec_type;
1939: l_row_notfound BOOLEAN := TRUE;
1940: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1941: BEGIN
1942: x_cmgv_rec := p_cmgv_rec;
1943: -- Get current database values
1944: l_cmgv_rec := get_rec(p_cmgv_rec, l_row_notfound);

Line 1946: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1942: x_cmgv_rec := p_cmgv_rec;
1943: -- Get current database values
1944: l_cmgv_rec := get_rec(p_cmgv_rec, l_row_notfound);
1945: IF (l_row_notfound) THEN
1946: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1947: END IF;
1948: IF (x_cmgv_rec.id = OKL_API.G_MISS_NUM)
1949: THEN
1950: x_cmgv_rec.id := l_cmgv_rec.id;

Line 1948: IF (x_cmgv_rec.id = OKL_API.G_MISS_NUM)

1944: l_cmgv_rec := get_rec(p_cmgv_rec, l_row_notfound);
1945: IF (l_row_notfound) THEN
1946: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1947: END IF;
1948: IF (x_cmgv_rec.id = OKL_API.G_MISS_NUM)
1949: THEN
1950: x_cmgv_rec.id := l_cmgv_rec.id;
1951: END IF;
1952: IF (x_cmgv_rec.object_version_number = OKL_API.G_MISS_NUM)

Line 1952: IF (x_cmgv_rec.object_version_number = OKL_API.G_MISS_NUM)

1948: IF (x_cmgv_rec.id = OKL_API.G_MISS_NUM)
1949: THEN
1950: x_cmgv_rec.id := l_cmgv_rec.id;
1951: END IF;
1952: IF (x_cmgv_rec.object_version_number = OKL_API.G_MISS_NUM)
1953: THEN
1954: x_cmgv_rec.object_version_number := l_cmgv_rec.object_version_number;
1955: END IF;
1956: IF (x_cmgv_rec.ims_id = OKL_API.G_MISS_NUM)

Line 1956: IF (x_cmgv_rec.ims_id = OKL_API.G_MISS_NUM)

1952: IF (x_cmgv_rec.object_version_number = OKL_API.G_MISS_NUM)
1953: THEN
1954: x_cmgv_rec.object_version_number := l_cmgv_rec.object_version_number;
1955: END IF;
1956: IF (x_cmgv_rec.ims_id = OKL_API.G_MISS_NUM)
1957: THEN
1958: x_cmgv_rec.ims_id := l_cmgv_rec.ims_id;
1959: END IF;
1960: IF (x_cmgv_rec.ivm_id = OKL_API.G_MISS_NUM)

Line 1960: IF (x_cmgv_rec.ivm_id = OKL_API.G_MISS_NUM)

1956: IF (x_cmgv_rec.ims_id = OKL_API.G_MISS_NUM)
1957: THEN
1958: x_cmgv_rec.ims_id := l_cmgv_rec.ims_id;
1959: END IF;
1960: IF (x_cmgv_rec.ivm_id = OKL_API.G_MISS_NUM)
1961: THEN
1962: x_cmgv_rec.ivm_id := l_cmgv_rec.ivm_id;
1963: END IF;
1964: IF (x_cmgv_rec.sequence_number = OKL_API.G_MISS_NUM)

Line 1964: IF (x_cmgv_rec.sequence_number = OKL_API.G_MISS_NUM)

1960: IF (x_cmgv_rec.ivm_id = OKL_API.G_MISS_NUM)
1961: THEN
1962: x_cmgv_rec.ivm_id := l_cmgv_rec.ivm_id;
1963: END IF;
1964: IF (x_cmgv_rec.sequence_number = OKL_API.G_MISS_NUM)
1965: THEN
1966: x_cmgv_rec.sequence_number := l_cmgv_rec.sequence_number;
1967: END IF;
1968: IF (x_cmgv_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 1968: IF (x_cmgv_rec.attribute_category = OKL_API.G_MISS_CHAR)

1964: IF (x_cmgv_rec.sequence_number = OKL_API.G_MISS_NUM)
1965: THEN
1966: x_cmgv_rec.sequence_number := l_cmgv_rec.sequence_number;
1967: END IF;
1968: IF (x_cmgv_rec.attribute_category = OKL_API.G_MISS_CHAR)
1969: THEN
1970: x_cmgv_rec.attribute_category := l_cmgv_rec.attribute_category;
1971: END IF;
1972: IF (x_cmgv_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 1972: IF (x_cmgv_rec.attribute1 = OKL_API.G_MISS_CHAR)

1968: IF (x_cmgv_rec.attribute_category = OKL_API.G_MISS_CHAR)
1969: THEN
1970: x_cmgv_rec.attribute_category := l_cmgv_rec.attribute_category;
1971: END IF;
1972: IF (x_cmgv_rec.attribute1 = OKL_API.G_MISS_CHAR)
1973: THEN
1974: x_cmgv_rec.attribute1 := l_cmgv_rec.attribute1;
1975: END IF;
1976: IF (x_cmgv_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 1976: IF (x_cmgv_rec.attribute2 = OKL_API.G_MISS_CHAR)

1972: IF (x_cmgv_rec.attribute1 = OKL_API.G_MISS_CHAR)
1973: THEN
1974: x_cmgv_rec.attribute1 := l_cmgv_rec.attribute1;
1975: END IF;
1976: IF (x_cmgv_rec.attribute2 = OKL_API.G_MISS_CHAR)
1977: THEN
1978: x_cmgv_rec.attribute2 := l_cmgv_rec.attribute2;
1979: END IF;
1980: IF (x_cmgv_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 1980: IF (x_cmgv_rec.attribute3 = OKL_API.G_MISS_CHAR)

1976: IF (x_cmgv_rec.attribute2 = OKL_API.G_MISS_CHAR)
1977: THEN
1978: x_cmgv_rec.attribute2 := l_cmgv_rec.attribute2;
1979: END IF;
1980: IF (x_cmgv_rec.attribute3 = OKL_API.G_MISS_CHAR)
1981: THEN
1982: x_cmgv_rec.attribute3 := l_cmgv_rec.attribute3;
1983: END IF;
1984: IF (x_cmgv_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 1984: IF (x_cmgv_rec.attribute4 = OKL_API.G_MISS_CHAR)

1980: IF (x_cmgv_rec.attribute3 = OKL_API.G_MISS_CHAR)
1981: THEN
1982: x_cmgv_rec.attribute3 := l_cmgv_rec.attribute3;
1983: END IF;
1984: IF (x_cmgv_rec.attribute4 = OKL_API.G_MISS_CHAR)
1985: THEN
1986: x_cmgv_rec.attribute4 := l_cmgv_rec.attribute4;
1987: END IF;
1988: IF (x_cmgv_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 1988: IF (x_cmgv_rec.attribute5 = OKL_API.G_MISS_CHAR)

1984: IF (x_cmgv_rec.attribute4 = OKL_API.G_MISS_CHAR)
1985: THEN
1986: x_cmgv_rec.attribute4 := l_cmgv_rec.attribute4;
1987: END IF;
1988: IF (x_cmgv_rec.attribute5 = OKL_API.G_MISS_CHAR)
1989: THEN
1990: x_cmgv_rec.attribute5 := l_cmgv_rec.attribute5;
1991: END IF;
1992: IF (x_cmgv_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 1992: IF (x_cmgv_rec.attribute6 = OKL_API.G_MISS_CHAR)

1988: IF (x_cmgv_rec.attribute5 = OKL_API.G_MISS_CHAR)
1989: THEN
1990: x_cmgv_rec.attribute5 := l_cmgv_rec.attribute5;
1991: END IF;
1992: IF (x_cmgv_rec.attribute6 = OKL_API.G_MISS_CHAR)
1993: THEN
1994: x_cmgv_rec.attribute6 := l_cmgv_rec.attribute6;
1995: END IF;
1996: IF (x_cmgv_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 1996: IF (x_cmgv_rec.attribute7 = OKL_API.G_MISS_CHAR)

1992: IF (x_cmgv_rec.attribute6 = OKL_API.G_MISS_CHAR)
1993: THEN
1994: x_cmgv_rec.attribute6 := l_cmgv_rec.attribute6;
1995: END IF;
1996: IF (x_cmgv_rec.attribute7 = OKL_API.G_MISS_CHAR)
1997: THEN
1998: x_cmgv_rec.attribute7 := l_cmgv_rec.attribute7;
1999: END IF;
2000: IF (x_cmgv_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 2000: IF (x_cmgv_rec.attribute8 = OKL_API.G_MISS_CHAR)

1996: IF (x_cmgv_rec.attribute7 = OKL_API.G_MISS_CHAR)
1997: THEN
1998: x_cmgv_rec.attribute7 := l_cmgv_rec.attribute7;
1999: END IF;
2000: IF (x_cmgv_rec.attribute8 = OKL_API.G_MISS_CHAR)
2001: THEN
2002: x_cmgv_rec.attribute8 := l_cmgv_rec.attribute8;
2003: END IF;
2004: IF (x_cmgv_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 2004: IF (x_cmgv_rec.attribute9 = OKL_API.G_MISS_CHAR)

2000: IF (x_cmgv_rec.attribute8 = OKL_API.G_MISS_CHAR)
2001: THEN
2002: x_cmgv_rec.attribute8 := l_cmgv_rec.attribute8;
2003: END IF;
2004: IF (x_cmgv_rec.attribute9 = OKL_API.G_MISS_CHAR)
2005: THEN
2006: x_cmgv_rec.attribute9 := l_cmgv_rec.attribute9;
2007: END IF;
2008: IF (x_cmgv_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 2008: IF (x_cmgv_rec.attribute10 = OKL_API.G_MISS_CHAR)

2004: IF (x_cmgv_rec.attribute9 = OKL_API.G_MISS_CHAR)
2005: THEN
2006: x_cmgv_rec.attribute9 := l_cmgv_rec.attribute9;
2007: END IF;
2008: IF (x_cmgv_rec.attribute10 = OKL_API.G_MISS_CHAR)
2009: THEN
2010: x_cmgv_rec.attribute10 := l_cmgv_rec.attribute10;
2011: END IF;
2012: IF (x_cmgv_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 2012: IF (x_cmgv_rec.attribute11 = OKL_API.G_MISS_CHAR)

2008: IF (x_cmgv_rec.attribute10 = OKL_API.G_MISS_CHAR)
2009: THEN
2010: x_cmgv_rec.attribute10 := l_cmgv_rec.attribute10;
2011: END IF;
2012: IF (x_cmgv_rec.attribute11 = OKL_API.G_MISS_CHAR)
2013: THEN
2014: x_cmgv_rec.attribute11 := l_cmgv_rec.attribute11;
2015: END IF;
2016: IF (x_cmgv_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 2016: IF (x_cmgv_rec.attribute12 = OKL_API.G_MISS_CHAR)

2012: IF (x_cmgv_rec.attribute11 = OKL_API.G_MISS_CHAR)
2013: THEN
2014: x_cmgv_rec.attribute11 := l_cmgv_rec.attribute11;
2015: END IF;
2016: IF (x_cmgv_rec.attribute12 = OKL_API.G_MISS_CHAR)
2017: THEN
2018: x_cmgv_rec.attribute12 := l_cmgv_rec.attribute12;
2019: END IF;
2020: IF (x_cmgv_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 2020: IF (x_cmgv_rec.attribute13 = OKL_API.G_MISS_CHAR)

2016: IF (x_cmgv_rec.attribute12 = OKL_API.G_MISS_CHAR)
2017: THEN
2018: x_cmgv_rec.attribute12 := l_cmgv_rec.attribute12;
2019: END IF;
2020: IF (x_cmgv_rec.attribute13 = OKL_API.G_MISS_CHAR)
2021: THEN
2022: x_cmgv_rec.attribute13 := l_cmgv_rec.attribute13;
2023: END IF;
2024: IF (x_cmgv_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 2024: IF (x_cmgv_rec.attribute14 = OKL_API.G_MISS_CHAR)

2020: IF (x_cmgv_rec.attribute13 = OKL_API.G_MISS_CHAR)
2021: THEN
2022: x_cmgv_rec.attribute13 := l_cmgv_rec.attribute13;
2023: END IF;
2024: IF (x_cmgv_rec.attribute14 = OKL_API.G_MISS_CHAR)
2025: THEN
2026: x_cmgv_rec.attribute14 := l_cmgv_rec.attribute14;
2027: END IF;
2028: IF (x_cmgv_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 2028: IF (x_cmgv_rec.attribute15 = OKL_API.G_MISS_CHAR)

2024: IF (x_cmgv_rec.attribute14 = OKL_API.G_MISS_CHAR)
2025: THEN
2026: x_cmgv_rec.attribute14 := l_cmgv_rec.attribute14;
2027: END IF;
2028: IF (x_cmgv_rec.attribute15 = OKL_API.G_MISS_CHAR)
2029: THEN
2030: x_cmgv_rec.attribute15 := l_cmgv_rec.attribute15;
2031: END IF;
2032: IF (x_cmgv_rec.created_by = OKL_API.G_MISS_NUM)

Line 2032: IF (x_cmgv_rec.created_by = OKL_API.G_MISS_NUM)

2028: IF (x_cmgv_rec.attribute15 = OKL_API.G_MISS_CHAR)
2029: THEN
2030: x_cmgv_rec.attribute15 := l_cmgv_rec.attribute15;
2031: END IF;
2032: IF (x_cmgv_rec.created_by = OKL_API.G_MISS_NUM)
2033: THEN
2034: x_cmgv_rec.created_by := l_cmgv_rec.created_by;
2035: END IF;
2036: IF (x_cmgv_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2036: IF (x_cmgv_rec.creation_date = OKL_API.G_MISS_DATE)

2032: IF (x_cmgv_rec.created_by = OKL_API.G_MISS_NUM)
2033: THEN
2034: x_cmgv_rec.created_by := l_cmgv_rec.created_by;
2035: END IF;
2036: IF (x_cmgv_rec.creation_date = OKL_API.G_MISS_DATE)
2037: THEN
2038: x_cmgv_rec.creation_date := l_cmgv_rec.creation_date;
2039: END IF;
2040: IF (x_cmgv_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2040: IF (x_cmgv_rec.last_updated_by = OKL_API.G_MISS_NUM)

2036: IF (x_cmgv_rec.creation_date = OKL_API.G_MISS_DATE)
2037: THEN
2038: x_cmgv_rec.creation_date := l_cmgv_rec.creation_date;
2039: END IF;
2040: IF (x_cmgv_rec.last_updated_by = OKL_API.G_MISS_NUM)
2041: THEN
2042: x_cmgv_rec.last_updated_by := l_cmgv_rec.last_updated_by;
2043: END IF;
2044: IF (x_cmgv_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2044: IF (x_cmgv_rec.last_update_date = OKL_API.G_MISS_DATE)

2040: IF (x_cmgv_rec.last_updated_by = OKL_API.G_MISS_NUM)
2041: THEN
2042: x_cmgv_rec.last_updated_by := l_cmgv_rec.last_updated_by;
2043: END IF;
2044: IF (x_cmgv_rec.last_update_date = OKL_API.G_MISS_DATE)
2045: THEN
2046: x_cmgv_rec.last_update_date := l_cmgv_rec.last_update_date;
2047: END IF;
2048: IF (x_cmgv_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2048: IF (x_cmgv_rec.last_update_login = OKL_API.G_MISS_NUM)

2044: IF (x_cmgv_rec.last_update_date = OKL_API.G_MISS_DATE)
2045: THEN
2046: x_cmgv_rec.last_update_date := l_cmgv_rec.last_update_date;
2047: END IF;
2048: IF (x_cmgv_rec.last_update_login = OKL_API.G_MISS_NUM)
2049: THEN
2050: x_cmgv_rec.last_update_login := l_cmgv_rec.last_update_login;
2051: END IF;
2052: RETURN(l_return_status);

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

2057: FUNCTION Set_Attributes (
2058: p_cmgv_rec IN cmgv_rec_type,
2059: x_cmgv_rec OUT NOCOPY cmgv_rec_type
2060: ) RETURN VARCHAR2 IS
2061: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2062: BEGIN
2063: x_cmgv_rec := p_cmgv_rec;
2064: x_cmgv_rec.OBJECT_VERSION_NUMBER := NVL(x_cmgv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2065: RETURN(l_return_status);

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

2064: x_cmgv_rec.OBJECT_VERSION_NUMBER := NVL(x_cmgv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2065: RETURN(l_return_status);
2066: END Set_Attributes;
2067: BEGIN
2068: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2069: G_PKG_NAME,
2070: p_init_msg_list,
2071: l_api_version,
2072: p_api_version,

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

2071: l_api_version,
2072: p_api_version,
2073: '_PVT',
2074: x_return_status);
2075: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2076: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2077: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2078: RAISE OKL_API.G_EXCEPTION_ERROR;
2079: END IF;

Line 2076: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2072: p_api_version,
2073: '_PVT',
2074: x_return_status);
2075: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2076: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2077: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2078: RAISE OKL_API.G_EXCEPTION_ERROR;
2079: END IF;
2080: --- Setting item attributes

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

2073: '_PVT',
2074: x_return_status);
2075: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2076: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2077: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2078: RAISE OKL_API.G_EXCEPTION_ERROR;
2079: END IF;
2080: --- Setting item attributes
2081: l_return_status := Set_Attributes(

Line 2078: RAISE OKL_API.G_EXCEPTION_ERROR;

2074: x_return_status);
2075: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2076: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2077: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2078: RAISE OKL_API.G_EXCEPTION_ERROR;
2079: END IF;
2080: --- Setting item attributes
2081: l_return_status := Set_Attributes(
2082: p_cmgv_rec, -- IN

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

2081: l_return_status := Set_Attributes(
2082: p_cmgv_rec, -- IN
2083: l_cmgv_rec); -- OUT
2084: --- If any errors happen abort API
2085: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2086: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2087: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2088: RAISE OKL_API.G_EXCEPTION_ERROR;
2089: END IF;

Line 2086: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2082: p_cmgv_rec, -- IN
2083: l_cmgv_rec); -- OUT
2084: --- If any errors happen abort API
2085: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2086: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2087: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2088: RAISE OKL_API.G_EXCEPTION_ERROR;
2089: END IF;
2090: l_return_status := populate_new_record(l_cmgv_rec, l_def_cmgv_rec);

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

2083: l_cmgv_rec); -- OUT
2084: --- If any errors happen abort API
2085: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2086: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2087: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2088: RAISE OKL_API.G_EXCEPTION_ERROR;
2089: END IF;
2090: l_return_status := populate_new_record(l_cmgv_rec, l_def_cmgv_rec);
2091: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2088: RAISE OKL_API.G_EXCEPTION_ERROR;

2084: --- If any errors happen abort API
2085: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2086: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2087: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2088: RAISE OKL_API.G_EXCEPTION_ERROR;
2089: END IF;
2090: l_return_status := populate_new_record(l_cmgv_rec, l_def_cmgv_rec);
2091: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2092: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2087: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2088: RAISE OKL_API.G_EXCEPTION_ERROR;
2089: END IF;
2090: l_return_status := populate_new_record(l_cmgv_rec, l_def_cmgv_rec);
2091: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2092: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2093: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2094: RAISE OKL_API.G_EXCEPTION_ERROR;
2095: END IF;

Line 2092: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2088: RAISE OKL_API.G_EXCEPTION_ERROR;
2089: END IF;
2090: l_return_status := populate_new_record(l_cmgv_rec, l_def_cmgv_rec);
2091: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2092: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2093: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2094: RAISE OKL_API.G_EXCEPTION_ERROR;
2095: END IF;
2096: l_def_cmgv_rec := fill_who_columns(l_def_cmgv_rec);

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

2089: END IF;
2090: l_return_status := populate_new_record(l_cmgv_rec, l_def_cmgv_rec);
2091: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2092: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2093: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2094: RAISE OKL_API.G_EXCEPTION_ERROR;
2095: END IF;
2096: l_def_cmgv_rec := fill_who_columns(l_def_cmgv_rec);
2097: --- Validate all non-missing attributes (Item Level Validation)

Line 2094: RAISE OKL_API.G_EXCEPTION_ERROR;

2090: l_return_status := populate_new_record(l_cmgv_rec, l_def_cmgv_rec);
2091: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2092: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2093: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2094: RAISE OKL_API.G_EXCEPTION_ERROR;
2095: END IF;
2096: l_def_cmgv_rec := fill_who_columns(l_def_cmgv_rec);
2097: --- Validate all non-missing attributes (Item Level Validation)
2098: l_return_status := Validate_Attributes(l_def_cmgv_rec);

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

2096: l_def_cmgv_rec := fill_who_columns(l_def_cmgv_rec);
2097: --- Validate all non-missing attributes (Item Level Validation)
2098: l_return_status := Validate_Attributes(l_def_cmgv_rec);
2099: --- If any errors happen abort API
2100: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2102: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2103: RAISE OKL_API.G_EXCEPTION_ERROR;
2104: END IF;

Line 2101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2097: --- Validate all non-missing attributes (Item Level Validation)
2098: l_return_status := Validate_Attributes(l_def_cmgv_rec);
2099: --- If any errors happen abort API
2100: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2102: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2103: RAISE OKL_API.G_EXCEPTION_ERROR;
2104: END IF;
2105: l_return_status := Validate_Record(l_def_cmgv_rec);

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

2098: l_return_status := Validate_Attributes(l_def_cmgv_rec);
2099: --- If any errors happen abort API
2100: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2102: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2103: RAISE OKL_API.G_EXCEPTION_ERROR;
2104: END IF;
2105: l_return_status := Validate_Record(l_def_cmgv_rec);
2106: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2103: RAISE OKL_API.G_EXCEPTION_ERROR;

2099: --- If any errors happen abort API
2100: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2102: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2103: RAISE OKL_API.G_EXCEPTION_ERROR;
2104: END IF;
2105: l_return_status := Validate_Record(l_def_cmgv_rec);
2106: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2102: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2103: RAISE OKL_API.G_EXCEPTION_ERROR;
2104: END IF;
2105: l_return_status := Validate_Record(l_def_cmgv_rec);
2106: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2109: RAISE OKL_API.G_EXCEPTION_ERROR;
2110: END IF;

Line 2107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2103: RAISE OKL_API.G_EXCEPTION_ERROR;
2104: END IF;
2105: l_return_status := Validate_Record(l_def_cmgv_rec);
2106: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2109: RAISE OKL_API.G_EXCEPTION_ERROR;
2110: END IF;
2111:

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

2104: END IF;
2105: l_return_status := Validate_Record(l_def_cmgv_rec);
2106: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2109: RAISE OKL_API.G_EXCEPTION_ERROR;
2110: END IF;
2111:
2112: --------------------------------------

Line 2109: RAISE OKL_API.G_EXCEPTION_ERROR;

2105: l_return_status := Validate_Record(l_def_cmgv_rec);
2106: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2109: RAISE OKL_API.G_EXCEPTION_ERROR;
2110: END IF;
2111:
2112: --------------------------------------
2113: -- Move VIEW record to "Child" records

Line 2127: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2123: x_msg_data,
2124: l_cmg_rec,
2125: lx_cmg_rec
2126: );
2127: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2129: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2130: RAISE OKL_API.G_EXCEPTION_ERROR;
2131: END IF;

Line 2128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2124: l_cmg_rec,
2125: lx_cmg_rec
2126: );
2127: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2129: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2130: RAISE OKL_API.G_EXCEPTION_ERROR;
2131: END IF;
2132: migrate(lx_cmg_rec, l_def_cmgv_rec);

Line 2129: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2125: lx_cmg_rec
2126: );
2127: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2129: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2130: RAISE OKL_API.G_EXCEPTION_ERROR;
2131: END IF;
2132: migrate(lx_cmg_rec, l_def_cmgv_rec);
2133: x_cmgv_rec := l_def_cmgv_rec;

Line 2130: RAISE OKL_API.G_EXCEPTION_ERROR;

2126: );
2127: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2129: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2130: RAISE OKL_API.G_EXCEPTION_ERROR;
2131: END IF;
2132: migrate(lx_cmg_rec, l_def_cmgv_rec);
2133: x_cmgv_rec := l_def_cmgv_rec;
2134: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2130: RAISE OKL_API.G_EXCEPTION_ERROR;
2131: END IF;
2132: migrate(lx_cmg_rec, l_def_cmgv_rec);
2133: x_cmgv_rec := l_def_cmgv_rec;
2134: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2135: EXCEPTION
2136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2138: (

Line 2136: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2132: migrate(lx_cmg_rec, l_def_cmgv_rec);
2133: x_cmgv_rec := l_def_cmgv_rec;
2134: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2135: EXCEPTION
2136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2138: (
2139: l_api_name,
2140: G_PKG_NAME,

Line 2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2133: x_cmgv_rec := l_def_cmgv_rec;
2134: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2135: EXCEPTION
2136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2138: (
2139: l_api_name,
2140: G_PKG_NAME,
2141: 'OKL_API.G_RET_STS_ERROR',

Line 2141: 'OKL_API.G_RET_STS_ERROR',

2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2138: (
2139: l_api_name,
2140: G_PKG_NAME,
2141: 'OKL_API.G_RET_STS_ERROR',
2142: x_msg_count,
2143: x_msg_data,
2144: '_PVT'
2145: );

Line 2146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2142: x_msg_count,
2143: x_msg_data,
2144: '_PVT'
2145: );
2146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2147: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2148: (
2149: l_api_name,
2150: G_PKG_NAME,

Line 2147: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2143: x_msg_data,
2144: '_PVT'
2145: );
2146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2147: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2148: (
2149: l_api_name,
2150: G_PKG_NAME,
2151: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2151: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2147: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2148: (
2149: l_api_name,
2150: G_PKG_NAME,
2151: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2152: x_msg_count,
2153: x_msg_data,
2154: '_PVT'
2155: );

Line 2157: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2153: x_msg_data,
2154: '_PVT'
2155: );
2156: WHEN OTHERS THEN
2157: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2158: (
2159: l_api_name,
2160: G_PKG_NAME,
2161: 'OTHERS',

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

2178: ) IS
2179:
2180: l_api_version CONSTANT NUMBER := 1;
2181: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2182: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2183: i NUMBER := 0;
2184: -- Begin Post-Generation Change
2185: -- overall error status
2186: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2186: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2182: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2183: i NUMBER := 0;
2184: -- Begin Post-Generation Change
2185: -- overall error status
2186: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2187: -- End Post-Generation Change
2188:
2189: BEGIN
2190: OKL_API.init_msg_list(p_init_msg_list);

Line 2190: OKL_API.init_msg_list(p_init_msg_list);

2186: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2187: -- End Post-Generation Change
2188:
2189: BEGIN
2190: OKL_API.init_msg_list(p_init_msg_list);
2191: -- Make sure PL/SQL table has records in it before passing
2192: IF (p_cmgv_tbl.COUNT > 0) THEN
2193: i := p_cmgv_tbl.FIRST;
2194: LOOP

Line 2197: p_init_msg_list => OKL_API.G_FALSE,

2193: i := p_cmgv_tbl.FIRST;
2194: LOOP
2195: update_row (
2196: p_api_version => p_api_version,
2197: p_init_msg_list => OKL_API.G_FALSE,
2198: x_return_status => x_return_status,
2199: x_msg_count => x_msg_count,
2200: x_msg_data => x_msg_data,
2201: p_cmgv_rec => p_cmgv_tbl(i),

Line 2205: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2201: p_cmgv_rec => p_cmgv_tbl(i),
2202: x_cmgv_rec => x_cmgv_tbl(i));
2203: -- Begin Post-Generation Change
2204: -- store the highest degree of error
2205: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2206: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2207: l_overall_status := x_return_status;
2208: END IF;
2209: END IF;

Line 2206: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2202: x_cmgv_rec => x_cmgv_tbl(i));
2203: -- Begin Post-Generation Change
2204: -- store the highest degree of error
2205: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2206: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2207: l_overall_status := x_return_status;
2208: END IF;
2209: END IF;
2210: -- End Post-Generation Change

Line 2220: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2216: x_return_status := l_overall_status;
2217: -- End Post-Generation Change
2218: END IF;
2219: EXCEPTION
2220: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2221: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2222: (
2223: l_api_name,
2224: G_PKG_NAME,

Line 2221: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2217: -- End Post-Generation Change
2218: END IF;
2219: EXCEPTION
2220: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2221: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2222: (
2223: l_api_name,
2224: G_PKG_NAME,
2225: 'OKL_API.G_RET_STS_ERROR',

Line 2225: 'OKL_API.G_RET_STS_ERROR',

2221: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2222: (
2223: l_api_name,
2224: G_PKG_NAME,
2225: 'OKL_API.G_RET_STS_ERROR',
2226: x_msg_count,
2227: x_msg_data,
2228: '_PVT'
2229: );

Line 2230: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2226: x_msg_count,
2227: x_msg_data,
2228: '_PVT'
2229: );
2230: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2231: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2232: (
2233: l_api_name,
2234: G_PKG_NAME,

Line 2231: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2227: x_msg_data,
2228: '_PVT'
2229: );
2230: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2231: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2232: (
2233: l_api_name,
2234: G_PKG_NAME,
2235: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2235: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2231: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2232: (
2233: l_api_name,
2234: G_PKG_NAME,
2235: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2236: x_msg_count,
2237: x_msg_data,
2238: '_PVT'
2239: );

Line 2241: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2237: x_msg_data,
2238: '_PVT'
2239: );
2240: WHEN OTHERS THEN
2241: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2242: (
2243: l_api_name,
2244: G_PKG_NAME,
2245: 'OTHERS',

Line 2259: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2255: ----------------------------------------
2256: -- delete_row for:OKL_CONDITION_MSSGS --
2257: ----------------------------------------
2258: PROCEDURE delete_row(
2259: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2260: x_return_status OUT NOCOPY VARCHAR2,
2261: x_msg_count OUT NOCOPY NUMBER,
2262: x_msg_data OUT NOCOPY VARCHAR2,
2263: p_cmg_rec IN cmg_rec_type) IS

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

2263: p_cmg_rec IN cmg_rec_type) IS
2264:
2265: l_api_version CONSTANT NUMBER := 1;
2266: l_api_name CONSTANT VARCHAR2(30) := 'MSSGS_delete_row';
2267: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2268: l_cmg_rec cmg_rec_type:= p_cmg_rec;
2269: l_row_notfound BOOLEAN := TRUE;
2270: BEGIN
2271: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

2267: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2268: l_cmg_rec cmg_rec_type:= p_cmg_rec;
2269: l_row_notfound BOOLEAN := TRUE;
2270: BEGIN
2271: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2272: p_init_msg_list,
2273: '_PVT',
2274: x_return_status);
2275: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

2271: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2272: p_init_msg_list,
2273: '_PVT',
2274: x_return_status);
2275: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2277: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2278: RAISE OKL_API.G_EXCEPTION_ERROR;
2279: END IF;

Line 2276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2272: p_init_msg_list,
2273: '_PVT',
2274: x_return_status);
2275: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2277: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2278: RAISE OKL_API.G_EXCEPTION_ERROR;
2279: END IF;
2280: DELETE FROM OKL_CONDITION_MSSGS

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

2273: '_PVT',
2274: x_return_status);
2275: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2277: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2278: RAISE OKL_API.G_EXCEPTION_ERROR;
2279: END IF;
2280: DELETE FROM OKL_CONDITION_MSSGS
2281: WHERE ID = l_cmg_rec.id;

Line 2278: RAISE OKL_API.G_EXCEPTION_ERROR;

2274: x_return_status);
2275: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2277: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2278: RAISE OKL_API.G_EXCEPTION_ERROR;
2279: END IF;
2280: DELETE FROM OKL_CONDITION_MSSGS
2281: WHERE ID = l_cmg_rec.id;
2282:

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

2279: END IF;
2280: DELETE FROM OKL_CONDITION_MSSGS
2281: WHERE ID = l_cmg_rec.id;
2282:
2283: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2284: EXCEPTION
2285: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2286: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2287: (

Line 2285: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2281: WHERE ID = l_cmg_rec.id;
2282:
2283: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2284: EXCEPTION
2285: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2286: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2287: (
2288: l_api_name,
2289: G_PKG_NAME,

Line 2286: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2282:
2283: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2284: EXCEPTION
2285: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2286: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2287: (
2288: l_api_name,
2289: G_PKG_NAME,
2290: 'OKL_API.G_RET_STS_ERROR',

Line 2290: 'OKL_API.G_RET_STS_ERROR',

2286: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2287: (
2288: l_api_name,
2289: G_PKG_NAME,
2290: 'OKL_API.G_RET_STS_ERROR',
2291: x_msg_count,
2292: x_msg_data,
2293: '_PVT'
2294: );

Line 2295: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2291: x_msg_count,
2292: x_msg_data,
2293: '_PVT'
2294: );
2295: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2296: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2297: (
2298: l_api_name,
2299: G_PKG_NAME,

Line 2296: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2292: x_msg_data,
2293: '_PVT'
2294: );
2295: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2296: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2297: (
2298: l_api_name,
2299: G_PKG_NAME,
2300: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2300: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2296: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2297: (
2298: l_api_name,
2299: G_PKG_NAME,
2300: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2301: x_msg_count,
2302: x_msg_data,
2303: '_PVT'
2304: );

Line 2306: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2302: x_msg_data,
2303: '_PVT'
2304: );
2305: WHEN OTHERS THEN
2306: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2307: (
2308: l_api_name,
2309: G_PKG_NAME,
2310: 'OTHERS',

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

2326: ) IS
2327:
2328: l_api_version CONSTANT NUMBER := 1;
2329: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2330: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2331: l_cmgv_rec cmgv_rec_type := p_cmgv_rec;
2332: l_cmg_rec cmg_rec_type;
2333: BEGIN
2334: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

2330: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2331: l_cmgv_rec cmgv_rec_type := p_cmgv_rec;
2332: l_cmg_rec cmg_rec_type;
2333: BEGIN
2334: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2335: G_PKG_NAME,
2336: p_init_msg_list,
2337: l_api_version,
2338: p_api_version,

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

2337: l_api_version,
2338: p_api_version,
2339: '_PVT',
2340: x_return_status);
2341: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2343: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2344: RAISE OKL_API.G_EXCEPTION_ERROR;
2345: END IF;

Line 2342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2338: p_api_version,
2339: '_PVT',
2340: x_return_status);
2341: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2343: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2344: RAISE OKL_API.G_EXCEPTION_ERROR;
2345: END IF;
2346: --------------------------------------

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

2339: '_PVT',
2340: x_return_status);
2341: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2343: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2344: RAISE OKL_API.G_EXCEPTION_ERROR;
2345: END IF;
2346: --------------------------------------
2347: -- Move VIEW record to "Child" records

Line 2344: RAISE OKL_API.G_EXCEPTION_ERROR;

2340: x_return_status);
2341: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2343: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2344: RAISE OKL_API.G_EXCEPTION_ERROR;
2345: END IF;
2346: --------------------------------------
2347: -- Move VIEW record to "Child" records
2348: --------------------------------------

Line 2360: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2356: x_msg_count,
2357: x_msg_data,
2358: l_cmg_rec
2359: );
2360: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2361: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2363: RAISE OKL_API.G_EXCEPTION_ERROR;
2364: END IF;

Line 2361: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2357: x_msg_data,
2358: l_cmg_rec
2359: );
2360: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2361: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2363: RAISE OKL_API.G_EXCEPTION_ERROR;
2364: END IF;
2365: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2358: l_cmg_rec
2359: );
2360: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2361: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2363: RAISE OKL_API.G_EXCEPTION_ERROR;
2364: END IF;
2365: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2366: EXCEPTION

Line 2363: RAISE OKL_API.G_EXCEPTION_ERROR;

2359: );
2360: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2361: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2363: RAISE OKL_API.G_EXCEPTION_ERROR;
2364: END IF;
2365: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2366: EXCEPTION
2367: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

2361: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2363: RAISE OKL_API.G_EXCEPTION_ERROR;
2364: END IF;
2365: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2366: EXCEPTION
2367: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2368: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2369: (

Line 2367: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2363: RAISE OKL_API.G_EXCEPTION_ERROR;
2364: END IF;
2365: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2366: EXCEPTION
2367: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2368: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2369: (
2370: l_api_name,
2371: G_PKG_NAME,

Line 2368: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2364: END IF;
2365: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2366: EXCEPTION
2367: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2368: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2369: (
2370: l_api_name,
2371: G_PKG_NAME,
2372: 'OKL_API.G_RET_STS_ERROR',

Line 2372: 'OKL_API.G_RET_STS_ERROR',

2368: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2369: (
2370: l_api_name,
2371: G_PKG_NAME,
2372: 'OKL_API.G_RET_STS_ERROR',
2373: x_msg_count,
2374: x_msg_data,
2375: '_PVT'
2376: );

Line 2377: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2373: x_msg_count,
2374: x_msg_data,
2375: '_PVT'
2376: );
2377: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2378: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2379: (
2380: l_api_name,
2381: G_PKG_NAME,

Line 2378: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2374: x_msg_data,
2375: '_PVT'
2376: );
2377: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2378: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2379: (
2380: l_api_name,
2381: G_PKG_NAME,
2382: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2382: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2378: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2379: (
2380: l_api_name,
2381: G_PKG_NAME,
2382: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2383: x_msg_count,
2384: x_msg_data,
2385: '_PVT'
2386: );

Line 2388: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2384: x_msg_data,
2385: '_PVT'
2386: );
2387: WHEN OTHERS THEN
2388: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2389: (
2390: l_api_name,
2391: G_PKG_NAME,
2392: 'OTHERS',

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

2408: ) IS
2409:
2410: l_api_version CONSTANT NUMBER := 1;
2411: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2412: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2413: i NUMBER := 0;
2414: -- Begin Post-Generation Change
2415: -- overall error status
2416: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2416: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2412: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2413: i NUMBER := 0;
2414: -- Begin Post-Generation Change
2415: -- overall error status
2416: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2417: -- End Post-Generation Change
2418:
2419: BEGIN
2420: OKL_API.init_msg_list(p_init_msg_list);

Line 2420: OKL_API.init_msg_list(p_init_msg_list);

2416: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2417: -- End Post-Generation Change
2418:
2419: BEGIN
2420: OKL_API.init_msg_list(p_init_msg_list);
2421: -- Make sure PL/SQL table has records in it before passing
2422: IF (p_cmgv_tbl.COUNT > 0) THEN
2423: i := p_cmgv_tbl.FIRST;
2424: LOOP

Line 2427: p_init_msg_list => OKL_API.G_FALSE,

2423: i := p_cmgv_tbl.FIRST;
2424: LOOP
2425: delete_row (
2426: p_api_version => p_api_version,
2427: p_init_msg_list => OKL_API.G_FALSE,
2428: x_return_status => x_return_status,
2429: x_msg_count => x_msg_count,
2430: x_msg_data => x_msg_data,
2431: p_cmgv_rec => p_cmgv_tbl(i));

Line 2435: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2431: p_cmgv_rec => p_cmgv_tbl(i));
2432: EXIT WHEN (i = p_cmgv_tbl.LAST);
2433: -- Begin Post-Generation Change
2434: -- store the highest degree of error
2435: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2436: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2437: l_overall_status := x_return_status;
2438: END IF;
2439: END IF;

Line 2436: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2432: EXIT WHEN (i = p_cmgv_tbl.LAST);
2433: -- Begin Post-Generation Change
2434: -- store the highest degree of error
2435: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2436: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2437: l_overall_status := x_return_status;
2438: END IF;
2439: END IF;
2440: -- End Post-Generation Change

Line 2449: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2445: x_return_status := l_overall_status;
2446: -- End Post-Generation Change
2447: END IF;
2448: EXCEPTION
2449: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2450: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2451: (
2452: l_api_name,
2453: G_PKG_NAME,

Line 2450: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2446: -- End Post-Generation Change
2447: END IF;
2448: EXCEPTION
2449: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2450: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2451: (
2452: l_api_name,
2453: G_PKG_NAME,
2454: 'OKL_API.G_RET_STS_ERROR',

Line 2454: 'OKL_API.G_RET_STS_ERROR',

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

Line 2459: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2455: x_msg_count,
2456: x_msg_data,
2457: '_PVT'
2458: );
2459: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2460: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2461: (
2462: l_api_name,
2463: G_PKG_NAME,

Line 2460: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2456: x_msg_data,
2457: '_PVT'
2458: );
2459: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2460: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2461: (
2462: l_api_name,
2463: G_PKG_NAME,
2464: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2464: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2460: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2461: (
2462: l_api_name,
2463: G_PKG_NAME,
2464: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2465: x_msg_count,
2466: x_msg_data,
2467: '_PVT'
2468: );

Line 2470: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

2466: x_msg_data,
2467: '_PVT'
2468: );
2469: WHEN OTHERS THEN
2470: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2471: (
2472: l_api_name,
2473: G_PKG_NAME,
2474: 'OTHERS',