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

APPS.OKL_TRNS_ACC_DSTRS_PUB dependencies on FND_API

Line 204: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

200: l_tabv_rec tabv_rec_type;
201: l_data VARCHAR2(100);
202: l_api_name CONSTANT VARCHAR2(30) := 'insert_trns_acc_dstrs';
203: l_count NUMBER ;
204: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
205: l_acct_der VARCHAR(4);
206: l_row_notfound BOOLEAN := FALSE;
207: item_not_found_error EXCEPTION;
208: CURSOR acc_temp_name_csr(template_id NUMBER) IS

Line 213: x_return_status := FND_API.G_RET_STS_SUCCESS;

209: SELECT NAME
210: FROM okl_ae_templates
211: WHERE id = template_id;
212: BEGIN
213: x_return_status := FND_API.G_RET_STS_SUCCESS;
214: SAVEPOINT insert_trns_acc_dstrs;
215: l_tabv_rec := p_tabv_rec;
216: -- Added as part of SLA Uptake Bug#5707866 by zrehman on 7-Feb-2006 start
217: IF(p_tabv_rec.template_id IS NOT NULL AND p_tabv_rec.template_id <> Okc_Api.G_MISS_NUM) THEN

Line 251: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

247: ,p_tabv_rec => l_tabv_rec
248: ,x_tabv_rec => x_tabv_rec
249: );
250:
251: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;

Line 252: RAISE FND_API.G_EXC_ERROR;

248: ,x_tabv_rec => x_tabv_rec
249: );
250:
251: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:

Line 253: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

249: );
250:
251: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:
257: /* re-assign local record structure using output record from pvt api */

Line 254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

250:
251: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:
257: /* re-assign local record structure using output record from pvt api */
258: l_tabv_rec := x_tabv_rec;

Line 264: WHEN FND_API.G_EXC_ERROR THEN

260:
261:
262:
263: EXCEPTION
264: WHEN FND_API.G_EXC_ERROR THEN
265: ROLLBACK TO insert_trns_acc_dstrs;
266: x_return_status := FND_API.G_RET_STS_ERROR;
267:
268: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 266: x_return_status := FND_API.G_RET_STS_ERROR;

262:
263: EXCEPTION
264: WHEN FND_API.G_EXC_ERROR THEN
265: ROLLBACK TO insert_trns_acc_dstrs;
266: x_return_status := FND_API.G_RET_STS_ERROR;
267:
268: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
269: ,p_count => x_msg_count
270: ,p_data => x_msg_data);

Line 272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

268: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
269: ,p_count => x_msg_count
270: ,p_data => x_msg_data);
271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: ROLLBACK TO insert_trns_acc_dstrs;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
276: ,p_count => x_msg_count

Line 274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

270: ,p_data => x_msg_data);
271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: ROLLBACK TO insert_trns_acc_dstrs;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
276: ,p_count => x_msg_count
277: ,p_data => x_msg_data);
278:

Line 286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

282: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
283: ,p_count => x_msg_count
284: ,p_data => x_msg_data);
285: -- notify caller of an UNEXPECTED error
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: END insert_trns_acc_dstrs;
288:
289:
290: PROCEDURE insert_trns_acc_dstrs(

Line 303: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

299: l_tabv_tbl tabv_tbl_type;
300: l_data VARCHAR2(100);
301: l_count NUMBER ;
302: l_api_name CONSTANT VARCHAR2(30) := 'insert_trns_acc_dstrs';
303: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
304: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
305: i NUMBER;
306:
307: BEGIN

Line 304: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

300: l_data VARCHAR2(100);
301: l_count NUMBER ;
302: l_api_name CONSTANT VARCHAR2(30) := 'insert_trns_acc_dstrs';
303: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
304: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
305: i NUMBER;
306:
307: BEGIN
308: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 308: x_return_status := FND_API.G_RET_STS_SUCCESS;

304: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
305: i NUMBER;
306:
307: BEGIN
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309: SAVEPOINT insert_trns_acc_dstrs;
310: l_tabv_tbl := p_tabv_tbl;
311:
312:

Line 329: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

325: ,x_tabv_rec => x_tabv_tbl(i)
326: );
327:
328: -- store the highest degree of error
329: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
330: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
331: l_overall_status := x_return_status;
332: END IF;
333: END IF;

Line 330: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

326: );
327:
328: -- store the highest degree of error
329: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
330: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
331: l_overall_status := x_return_status;
332: END IF;
333: END IF;
334: EXIT WHEN (i = p_tabv_tbl.LAST);

Line 346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

342: END IF;
343:
344: l_return_status := x_return_status;
345:
346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;

Line 347: RAISE FND_API.G_EXC_ERROR;

343:
344: l_return_status := x_return_status;
345:
346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351:

Line 348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

344: l_return_status := x_return_status;
345:
346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351:
352: /* re-assign local table structure using output table from pvt api */

Line 349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

345:
346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351:
352: /* re-assign local table structure using output table from pvt api */
353: l_tabv_tbl := x_tabv_tbl;

Line 358: WHEN FND_API.G_EXC_ERROR THEN

354:
355:
356:
357: EXCEPTION
358: WHEN FND_API.G_EXC_ERROR THEN
359: ROLLBACK TO insert_trns_acc_dstrs;
360: x_return_status := FND_API.G_RET_STS_ERROR;
361:
362: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 360: x_return_status := FND_API.G_RET_STS_ERROR;

356:
357: EXCEPTION
358: WHEN FND_API.G_EXC_ERROR THEN
359: ROLLBACK TO insert_trns_acc_dstrs;
360: x_return_status := FND_API.G_RET_STS_ERROR;
361:
362: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
363: ,p_count => x_msg_count
364: ,p_data => x_msg_data);

Line 366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

362: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
363: ,p_count => x_msg_count
364: ,p_data => x_msg_data);
365:
366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
367: ROLLBACK TO insert_trns_acc_dstrs;
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
370: ,p_count => x_msg_count

Line 368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

364: ,p_data => x_msg_data);
365:
366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
367: ROLLBACK TO insert_trns_acc_dstrs;
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
370: ,p_count => x_msg_count
371: ,p_data => x_msg_data);
372:

Line 380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

376: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
377: ,p_count => x_msg_count
378: ,p_data => x_msg_data);
379: -- notify caller of an UNEXPECTED error
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: END insert_trns_acc_dstrs;
382:
383: PROCEDURE lock_trns_acc_dstrs(
384: p_api_version IN NUMBER

Line 393: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

389: ,p_tabv_rec IN tabv_rec_type
390: ) IS
391:
392: l_tabv_rec tabv_rec_type;
393: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
394:
395: BEGIN
396: x_return_status := FND_API.G_RET_STS_SUCCESS;
397: SAVEPOINT lock_trns_acc_dstrs;

Line 396: x_return_status := FND_API.G_RET_STS_SUCCESS;

392: l_tabv_rec tabv_rec_type;
393: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
394:
395: BEGIN
396: x_return_status := FND_API.G_RET_STS_SUCCESS;
397: SAVEPOINT lock_trns_acc_dstrs;
398: l_tabv_rec := p_tabv_rec;
399:
400: okl_tab_pvt.lock_row(

Line 409: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

405: ,x_msg_data => x_msg_data
406: ,p_tabv_rec => l_tabv_rec
407: );
408:
409: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
410: RAISE FND_API.G_EXC_ERROR;
411: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF;

Line 410: RAISE FND_API.G_EXC_ERROR;

406: ,p_tabv_rec => l_tabv_rec
407: );
408:
409: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
410: RAISE FND_API.G_EXC_ERROR;
411: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF;
414:

Line 411: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

407: );
408:
409: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
410: RAISE FND_API.G_EXC_ERROR;
411: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF;
414:
415: EXCEPTION

Line 412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

408:
409: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
410: RAISE FND_API.G_EXC_ERROR;
411: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF;
414:
415: EXCEPTION
416: WHEN FND_API.G_EXC_ERROR THEN

Line 416: WHEN FND_API.G_EXC_ERROR THEN

412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF;
414:
415: EXCEPTION
416: WHEN FND_API.G_EXC_ERROR THEN
417: ROLLBACK TO lock_trns_acc_dstrs;
418: x_return_status := FND_API.G_RET_STS_ERROR;
419:
420: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 418: x_return_status := FND_API.G_RET_STS_ERROR;

414:
415: EXCEPTION
416: WHEN FND_API.G_EXC_ERROR THEN
417: ROLLBACK TO lock_trns_acc_dstrs;
418: x_return_status := FND_API.G_RET_STS_ERROR;
419:
420: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
421: ,p_count => x_msg_count
422: ,p_data => x_msg_data);

Line 424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

420: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
421: ,p_count => x_msg_count
422: ,p_data => x_msg_data);
423:
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425: ROLLBACK TO lock_trns_acc_dstrs;
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
428: ,p_count => x_msg_count

Line 426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

422: ,p_data => x_msg_data);
423:
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425: ROLLBACK TO lock_trns_acc_dstrs;
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
428: ,p_count => x_msg_count
429: ,p_data => x_msg_data);
430:

Line 438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

434: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
435: ,p_count => x_msg_count
436: ,p_data => x_msg_data);
437: -- notify caller of an UNEXPECTED error
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: END lock_trns_acc_dstrs;
440:
441: PROCEDURE lock_trns_acc_dstrs(
442: p_api_version IN NUMBER

Line 450: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

446: ,x_msg_data OUT NOCOPY VARCHAR2
447: ,p_tabv_tbl IN tabv_tbl_type
448: ) IS
449:
450: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
451: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
452: i NUMBER;
453:
454: BEGIN

Line 451: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

447: ,p_tabv_tbl IN tabv_tbl_type
448: ) IS
449:
450: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
451: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
452: i NUMBER;
453:
454: BEGIN
455: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 455: x_return_status := FND_API.G_RET_STS_SUCCESS;

451: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
452: i NUMBER;
453:
454: BEGIN
455: x_return_status := FND_API.G_RET_STS_SUCCESS;
456: SAVEPOINT lock_trns_acc_dstrs;
457:
458: IF (p_tabv_tbl.COUNT > 0) THEN
459: i := p_tabv_tbl.FIRST;

Line 472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

468: ,p_tabv_rec => p_tabv_tbl(i)
469: );
470:
471: -- store the highest degree of error
472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
473: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
474: l_overall_status := x_return_status;
475: END IF;
476: END IF;

Line 473: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

469: );
470:
471: -- store the highest degree of error
472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
473: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
474: l_overall_status := x_return_status;
475: END IF;
476: END IF;
477: EXIT WHEN (i = p_tabv_tbl.LAST);

Line 489: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

485: END IF;
486:
487: l_return_status := x_return_status;
488:
489: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
490: RAISE FND_API.G_EXC_ERROR;
491: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;

Line 490: RAISE FND_API.G_EXC_ERROR;

486:
487: l_return_status := x_return_status;
488:
489: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
490: RAISE FND_API.G_EXC_ERROR;
491: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:

Line 491: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

487: l_return_status := x_return_status;
488:
489: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
490: RAISE FND_API.G_EXC_ERROR;
491: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:
495: EXCEPTION

Line 492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

488:
489: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
490: RAISE FND_API.G_EXC_ERROR;
491: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:
495: EXCEPTION
496: WHEN FND_API.G_EXC_ERROR THEN

Line 496: WHEN FND_API.G_EXC_ERROR THEN

492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:
495: EXCEPTION
496: WHEN FND_API.G_EXC_ERROR THEN
497: ROLLBACK TO lock_trns_acc_dstrs;
498: x_return_status := FND_API.G_RET_STS_ERROR;
499:
500: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 498: x_return_status := FND_API.G_RET_STS_ERROR;

494:
495: EXCEPTION
496: WHEN FND_API.G_EXC_ERROR THEN
497: ROLLBACK TO lock_trns_acc_dstrs;
498: x_return_status := FND_API.G_RET_STS_ERROR;
499:
500: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
501: ,p_count => x_msg_count
502: ,p_data => x_msg_data);

Line 504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

500: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
501: ,p_count => x_msg_count
502: ,p_data => x_msg_data);
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
505: ROLLBACK TO lock_trns_acc_dstrs;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
508: ,p_count => x_msg_count

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

502: ,p_data => x_msg_data);
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
505: ROLLBACK TO lock_trns_acc_dstrs;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
508: ,p_count => x_msg_count
509: ,p_data => x_msg_data);
510:

Line 518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

514: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
515: ,p_count => x_msg_count
516: ,p_data => x_msg_data);
517: -- notify caller of an UNEXPECTED error
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: END lock_trns_acc_dstrs;
520:
521: PROCEDURE update_trns_acc_dstrs(
522: p_api_version IN NUMBER

Line 534: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

530: l_tabv_rec tabv_rec_type;
531: l_data VARCHAR2(100);
532: l_count NUMBER ;
533: l_api_name CONSTANT VARCHAR2(30) := 'update_trns_acc_dstrs';
534: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
535: BEGIN
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537: SAVEPOINT update_trns_acc_dstrs;
538: l_tabv_rec := p_tabv_rec;

Line 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532: l_count NUMBER ;
533: l_api_name CONSTANT VARCHAR2(30) := 'update_trns_acc_dstrs';
534: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
535: BEGIN
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537: SAVEPOINT update_trns_acc_dstrs;
538: l_tabv_rec := p_tabv_rec;
539:
540:

Line 552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

548: ,p_tabv_rec => l_tabv_rec
549: ,x_tabv_rec => x_tabv_rec
550: );
551:
552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
553: RAISE FND_API.G_EXC_ERROR;
554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: END IF;

Line 553: RAISE FND_API.G_EXC_ERROR;

549: ,x_tabv_rec => x_tabv_rec
550: );
551:
552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
553: RAISE FND_API.G_EXC_ERROR;
554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: END IF;
557:

Line 554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

550: );
551:
552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
553: RAISE FND_API.G_EXC_ERROR;
554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: END IF;
557:
558: /* re-assign local record structure using output record from pvt api */

Line 555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

551:
552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
553: RAISE FND_API.G_EXC_ERROR;
554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: END IF;
557:
558: /* re-assign local record structure using output record from pvt api */
559: l_tabv_rec := x_tabv_rec;

Line 564: WHEN FND_API.G_EXC_ERROR THEN

560:
561:
562:
563: EXCEPTION
564: WHEN FND_API.G_EXC_ERROR THEN
565: ROLLBACK TO update_trns_acc_dstrs;
566: x_return_status := FND_API.G_RET_STS_ERROR;
567:
568: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 566: x_return_status := FND_API.G_RET_STS_ERROR;

562:
563: EXCEPTION
564: WHEN FND_API.G_EXC_ERROR THEN
565: ROLLBACK TO update_trns_acc_dstrs;
566: x_return_status := FND_API.G_RET_STS_ERROR;
567:
568: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
569: ,p_count => x_msg_count
570: ,p_data => x_msg_data);

Line 572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

568: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
569: ,p_count => x_msg_count
570: ,p_data => x_msg_data);
571:
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
573: ROLLBACK TO update_trns_acc_dstrs;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
576: ,p_count => x_msg_count

Line 574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

570: ,p_data => x_msg_data);
571:
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
573: ROLLBACK TO update_trns_acc_dstrs;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
576: ,p_count => x_msg_count
577: ,p_data => x_msg_data);
578:

Line 586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

582: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
583: ,p_count => x_msg_count
584: ,p_data => x_msg_data);
585: -- notify caller of an UNEXPECTED error
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
587: END update_trns_acc_dstrs;
588:
589:
590: PROCEDURE update_trns_acc_dstrs(

Line 603: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

599: l_tabv_tbl tabv_tbl_type;
600: l_data VARCHAR2(100);
601: l_count NUMBER;
602: l_api_name CONSTANT VARCHAR2(30) := 'update_trns_acc_dstrs';
603: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
604: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
605: i NUMBER;
606:
607: BEGIN

Line 604: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

600: l_data VARCHAR2(100);
601: l_count NUMBER;
602: l_api_name CONSTANT VARCHAR2(30) := 'update_trns_acc_dstrs';
603: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
604: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
605: i NUMBER;
606:
607: BEGIN
608: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 608: x_return_status := FND_API.G_RET_STS_SUCCESS;

604: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
605: i NUMBER;
606:
607: BEGIN
608: x_return_status := FND_API.G_RET_STS_SUCCESS;
609: SAVEPOINT update_trns_acc_dstrs;
610: l_tabv_tbl := p_tabv_tbl;
611:
612:

Line 629: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

625: ,x_tabv_rec => x_tabv_tbl(i)
626: );
627:
628: -- store the highest degree of error
629: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
630: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
631: l_overall_status := x_return_status;
632: END IF;
633: END IF;

Line 630: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

626: );
627:
628: -- store the highest degree of error
629: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
630: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
631: l_overall_status := x_return_status;
632: END IF;
633: END IF;
634: EXIT WHEN (i = p_tabv_tbl.LAST);

Line 646: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

642: END IF;
643:
644: l_return_status := x_return_status;
645:
646: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
647: RAISE FND_API.G_EXC_ERROR;
648: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;

Line 647: RAISE FND_API.G_EXC_ERROR;

643:
644: l_return_status := x_return_status;
645:
646: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
647: RAISE FND_API.G_EXC_ERROR;
648: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
651:

Line 648: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

644: l_return_status := x_return_status;
645:
646: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
647: RAISE FND_API.G_EXC_ERROR;
648: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
651:
652: /* re-assign local table structure using output table from pvt api */

Line 649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

645:
646: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
647: RAISE FND_API.G_EXC_ERROR;
648: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
651:
652: /* re-assign local table structure using output table from pvt api */
653: l_tabv_tbl := x_tabv_tbl;

Line 658: WHEN FND_API.G_EXC_ERROR THEN

654:
655:
656:
657: EXCEPTION
658: WHEN FND_API.G_EXC_ERROR THEN
659: ROLLBACK TO update_trns_acc_dstrs;
660: x_return_status := FND_API.G_RET_STS_ERROR;
661:
662: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 660: x_return_status := FND_API.G_RET_STS_ERROR;

656:
657: EXCEPTION
658: WHEN FND_API.G_EXC_ERROR THEN
659: ROLLBACK TO update_trns_acc_dstrs;
660: x_return_status := FND_API.G_RET_STS_ERROR;
661:
662: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
663: ,p_count => x_msg_count
664: ,p_data => x_msg_data);

Line 666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

662: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
663: ,p_count => x_msg_count
664: ,p_data => x_msg_data);
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: ROLLBACK TO update_trns_acc_dstrs;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
670: ,p_count => x_msg_count

Line 668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

664: ,p_data => x_msg_data);
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: ROLLBACK TO update_trns_acc_dstrs;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
670: ,p_count => x_msg_count
671: ,p_data => x_msg_data);
672:

Line 680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

676: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
677: ,p_count => x_msg_count
678: ,p_data => x_msg_data);
679: -- notify caller of an UNEXPECTED error
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: END update_trns_acc_dstrs;
682:
683: PROCEDURE delete_trns_acc_dstrs(
684: p_api_version IN NUMBER

Line 695: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

691: l_tabv_rec tabv_rec_type;
692: l_data VARCHAR2(100);
693: l_count NUMBER ;
694: l_api_name CONSTANT VARCHAR2(30) := 'delete_trns_acc_dstrs';
695: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
696:
697:
698: -- Added by Santonyr to fix the bug 3089327 on 07th Aug, 2003
699:

Line 714: x_return_status := FND_API.G_RET_STS_SUCCESS;

710: FROM OKL_TRX_CONTRACTS
711: WHERE ID = v_tcn_id;
712: --
713: BEGIN
714: x_return_status := FND_API.G_RET_STS_SUCCESS;
715: SAVEPOINT delete_trns_acc_dstrs;
716: l_tabv_rec := p_tabv_rec;
717:
718:

Line 749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

745: ,x_msg_data => x_msg_data
746: ,p_tabv_rec => l_tabv_rec
747: );
748:
749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
750: RAISE FND_API.G_EXC_ERROR;
751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END IF;

Line 750: RAISE FND_API.G_EXC_ERROR;

746: ,p_tabv_rec => l_tabv_rec
747: );
748:
749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
750: RAISE FND_API.G_EXC_ERROR;
751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END IF;
754:

Line 751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

747: );
748:
749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
750: RAISE FND_API.G_EXC_ERROR;
751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END IF;
754:
755:

Line 752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

748:
749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
750: RAISE FND_API.G_EXC_ERROR;
751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END IF;
754:
755:
756:

Line 758: WHEN FND_API.G_EXC_ERROR THEN

754:
755:
756:
757: EXCEPTION
758: WHEN FND_API.G_EXC_ERROR THEN
759: ROLLBACK TO delete_trns_acc_dstrs;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761:
762: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 760: x_return_status := FND_API.G_RET_STS_ERROR;

756:
757: EXCEPTION
758: WHEN FND_API.G_EXC_ERROR THEN
759: ROLLBACK TO delete_trns_acc_dstrs;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761:
762: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
763: ,p_count => x_msg_count
764: ,p_data => x_msg_data);

Line 766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

762: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
763: ,p_count => x_msg_count
764: ,p_data => x_msg_data);
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: ROLLBACK TO delete_trns_acc_dstrs;
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
770: ,p_count => x_msg_count

Line 768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

764: ,p_data => x_msg_data);
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: ROLLBACK TO delete_trns_acc_dstrs;
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
770: ,p_count => x_msg_count
771: ,p_data => x_msg_data);
772:

Line 780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
777: ,p_count => x_msg_count
778: ,p_data => x_msg_data);
779: -- notify caller of an UNEXPECTED error
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: END delete_trns_acc_dstrs;
782:
783:
784: PROCEDURE delete_trns_acc_dstrs(

Line 796: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

792: l_tabv_tbl tabv_tbl_type;
793: l_data VARCHAR2(100);
794: l_count NUMBER ;
795: l_api_name CONSTANT VARCHAR2(30) := 'delete_trns_acc_dstrs';
796: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
797: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
798: i NUMBER;
799:
800: BEGIN

Line 797: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

793: l_data VARCHAR2(100);
794: l_count NUMBER ;
795: l_api_name CONSTANT VARCHAR2(30) := 'delete_trns_acc_dstrs';
796: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
797: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
798: i NUMBER;
799:
800: BEGIN
801: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 801: x_return_status := FND_API.G_RET_STS_SUCCESS;

797: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
798: i NUMBER;
799:
800: BEGIN
801: x_return_status := FND_API.G_RET_STS_SUCCESS;
802: SAVEPOINT delete_trns_acc_dstrs;
803: l_tabv_tbl := p_tabv_tbl;
804:
805:

Line 821: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

817: ,p_tabv_rec => p_tabv_tbl(i)
818: );
819:
820: -- store the highest degree of error
821: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
822: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
823: l_overall_status := x_return_status;
824: END IF;
825: END IF;

Line 822: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

818: );
819:
820: -- store the highest degree of error
821: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
822: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
823: l_overall_status := x_return_status;
824: END IF;
825: END IF;
826: EXIT WHEN (i = p_tabv_tbl.LAST);

Line 838: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

834: END IF;
835:
836: l_return_status := x_return_status;
837:
838: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
839: RAISE FND_API.G_EXC_ERROR;
840: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;

Line 839: RAISE FND_API.G_EXC_ERROR;

835:
836: l_return_status := x_return_status;
837:
838: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
839: RAISE FND_API.G_EXC_ERROR;
840: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843:

Line 840: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

836: l_return_status := x_return_status;
837:
838: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
839: RAISE FND_API.G_EXC_ERROR;
840: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843:
844:

Line 841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

837:
838: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
839: RAISE FND_API.G_EXC_ERROR;
840: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843:
844:
845:

Line 847: WHEN FND_API.G_EXC_ERROR THEN

843:
844:
845:
846: EXCEPTION
847: WHEN FND_API.G_EXC_ERROR THEN
848: ROLLBACK TO delete_trns_acc_dstrs;
849: x_return_status := FND_API.G_RET_STS_ERROR;
850:
851: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 849: x_return_status := FND_API.G_RET_STS_ERROR;

845:
846: EXCEPTION
847: WHEN FND_API.G_EXC_ERROR THEN
848: ROLLBACK TO delete_trns_acc_dstrs;
849: x_return_status := FND_API.G_RET_STS_ERROR;
850:
851: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
852: ,p_count => x_msg_count
853: ,p_data => x_msg_data);

Line 855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

851: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
852: ,p_count => x_msg_count
853: ,p_data => x_msg_data);
854:
855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
856: ROLLBACK TO delete_trns_acc_dstrs;
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
859: ,p_count => x_msg_count

Line 857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

853: ,p_data => x_msg_data);
854:
855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
856: ROLLBACK TO delete_trns_acc_dstrs;
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
859: ,p_count => x_msg_count
860: ,p_data => x_msg_data);
861:

Line 869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

865: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
866: ,p_count => x_msg_count
867: ,p_data => x_msg_data);
868: -- notify caller of an UNEXPECTED error
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: END delete_trns_acc_dstrs;
871:
872: PROCEDURE validate_trns_acc_dstrs(
873: p_api_version IN NUMBER

Line 884: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

880: l_tabv_rec tabv_rec_type;
881: l_data VARCHAR2(100);
882: l_count NUMBER;
883: l_api_name CONSTANT VARCHAR2(30) := 'validate_trns_acc_dstrs';
884: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
885: BEGIN
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887: SAVEPOINT validate_trns_acc_dstrs;
888: l_tabv_rec := p_tabv_rec;

Line 886: x_return_status := FND_API.G_RET_STS_SUCCESS;

882: l_count NUMBER;
883: l_api_name CONSTANT VARCHAR2(30) := 'validate_trns_acc_dstrs';
884: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
885: BEGIN
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887: SAVEPOINT validate_trns_acc_dstrs;
888: l_tabv_rec := p_tabv_rec;
889:
890:

Line 901: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

897: ,x_msg_data => x_msg_data
898: ,p_tabv_rec => l_tabv_rec
899: );
900:
901: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
902: RAISE FND_API.G_EXC_ERROR;
903: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
905: END IF;

Line 902: RAISE FND_API.G_EXC_ERROR;

898: ,p_tabv_rec => l_tabv_rec
899: );
900:
901: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
902: RAISE FND_API.G_EXC_ERROR;
903: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
905: END IF;
906:

Line 903: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

899: );
900:
901: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
902: RAISE FND_API.G_EXC_ERROR;
903: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
905: END IF;
906:
907:

Line 904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

900:
901: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
902: RAISE FND_API.G_EXC_ERROR;
903: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
905: END IF;
906:
907:
908:

Line 910: WHEN FND_API.G_EXC_ERROR THEN

906:
907:
908:
909: EXCEPTION
910: WHEN FND_API.G_EXC_ERROR THEN
911: ROLLBACK TO validate_trns_acc_dstrs;
912: x_return_status := FND_API.G_RET_STS_ERROR;
913:
914: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 912: x_return_status := FND_API.G_RET_STS_ERROR;

908:
909: EXCEPTION
910: WHEN FND_API.G_EXC_ERROR THEN
911: ROLLBACK TO validate_trns_acc_dstrs;
912: x_return_status := FND_API.G_RET_STS_ERROR;
913:
914: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
915: ,p_count => x_msg_count
916: ,p_data => x_msg_data);

Line 918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

914: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
915: ,p_count => x_msg_count
916: ,p_data => x_msg_data);
917:
918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
919: ROLLBACK TO validate_trns_acc_dstrs;
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
922: ,p_count => x_msg_count

Line 920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

916: ,p_data => x_msg_data);
917:
918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
919: ROLLBACK TO validate_trns_acc_dstrs;
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
922: ,p_count => x_msg_count
923: ,p_data => x_msg_data);
924:

Line 932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

928: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
929: ,p_count => x_msg_count
930: ,p_data => x_msg_data);
931: -- notify caller of an UNEXPECTED error
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933: END validate_trns_acc_dstrs;
934:
935:
936: PROCEDURE validate_trns_acc_dstrs(

Line 948: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

944: l_tabv_tbl tabv_tbl_type;
945: l_data VARCHAR2(100);
946: l_count NUMBER;
947: l_api_name CONSTANT VARCHAR2(30) := 'validate_trns_acc_dstrs';
948: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
949: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
950: i NUMBER;
951:
952: BEGIN

Line 949: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

945: l_data VARCHAR2(100);
946: l_count NUMBER;
947: l_api_name CONSTANT VARCHAR2(30) := 'validate_trns_acc_dstrs';
948: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
949: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
950: i NUMBER;
951:
952: BEGIN
953: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 953: x_return_status := FND_API.G_RET_STS_SUCCESS;

949: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
950: i NUMBER;
951:
952: BEGIN
953: x_return_status := FND_API.G_RET_STS_SUCCESS;
954: SAVEPOINT validate_trns_acc_dstrs;
955: l_tabv_tbl := p_tabv_tbl;
956:
957:

Line 973: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

969: ,p_tabv_rec => p_tabv_tbl(i)
970: );
971:
972: -- store the highest degree of error
973: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
974: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
975: l_overall_status := x_return_status;
976: END IF;
977: END IF;

Line 974: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

970: );
971:
972: -- store the highest degree of error
973: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
974: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
975: l_overall_status := x_return_status;
976: END IF;
977: END IF;
978: EXIT WHEN (i = p_tabv_tbl.LAST);

Line 990: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

986: END IF;
987:
988: l_return_status := x_return_status;
989:
990: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
991: RAISE FND_API.G_EXC_ERROR;
992: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: END IF;

Line 991: RAISE FND_API.G_EXC_ERROR;

987:
988: l_return_status := x_return_status;
989:
990: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
991: RAISE FND_API.G_EXC_ERROR;
992: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: END IF;
995:

Line 992: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

988: l_return_status := x_return_status;
989:
990: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
991: RAISE FND_API.G_EXC_ERROR;
992: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: END IF;
995:
996:

Line 993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

989:
990: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
991: RAISE FND_API.G_EXC_ERROR;
992: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: END IF;
995:
996:
997:

Line 1000: WHEN FND_API.G_EXC_ERROR THEN

996:
997:
998:
999: EXCEPTION
1000: WHEN FND_API.G_EXC_ERROR THEN
1001: ROLLBACK TO validate_trns_acc_dstrs;
1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003:
1004: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1002: x_return_status := FND_API.G_RET_STS_ERROR;

998:
999: EXCEPTION
1000: WHEN FND_API.G_EXC_ERROR THEN
1001: ROLLBACK TO validate_trns_acc_dstrs;
1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003:
1004: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1005: ,p_count => x_msg_count
1006: ,p_data => x_msg_data);

Line 1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1004: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1005: ,p_count => x_msg_count
1006: ,p_data => x_msg_data);
1007:
1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1009: ROLLBACK TO validate_trns_acc_dstrs;
1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1011: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1012: ,p_count => x_msg_count

Line 1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1006: ,p_data => x_msg_data);
1007:
1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1009: ROLLBACK TO validate_trns_acc_dstrs;
1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1011: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1012: ,p_count => x_msg_count
1013: ,p_data => x_msg_data);
1014:

Line 1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1018: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1019: ,p_count => x_msg_count
1020: ,p_data => x_msg_data);
1021: -- notify caller of an UNEXPECTED error
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1023: END validate_trns_acc_dstrs;
1024:
1025:
1026: END OKL_TRNS_ACC_DSTRS_PUB;