DBA Data[Home] [Help]

APPS.OKL_CNTR_GRP_BILLING_PVT dependencies on FND_API

Line 166: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN

162: END IF;
163:
164: END IF;
165:
166: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
167: RAISE l_clc_ext;
168: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
169: RAISE l_clc_ext;
170: END IF;

Line 168: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

164: END IF;
165:
166: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
167: RAISE l_clc_ext;
168: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
169: RAISE l_clc_ext;
170: END IF;
171: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
172:

Line 408: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

404:
405: --dbms_output.put_line('return status from tai is ' || l_return_status);
406: --dbms_output.put_line('l_msg_data from tai is ' || l_msg_data);
407:
408: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
409: RAISE Fnd_Api.G_EXC_ERROR;
410: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
411: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
412: END IF;

Line 409: RAISE Fnd_Api.G_EXC_ERROR;

405: --dbms_output.put_line('return status from tai is ' || l_return_status);
406: --dbms_output.put_line('l_msg_data from tai is ' || l_msg_data);
407:
408: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
409: RAISE Fnd_Api.G_EXC_ERROR;
410: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
411: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413:

Line 410: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

406: --dbms_output.put_line('l_msg_data from tai is ' || l_msg_data);
407:
408: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
409: RAISE Fnd_Api.G_EXC_ERROR;
410: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
411: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413:
414: --Line Level

Line 411: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

407:
408: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
409: RAISE Fnd_Api.G_EXC_ERROR;
410: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
411: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413:
414: --Line Level
415: OPEN l_lines_cur(l_asset_name, l_khr_id );-- for performance issue #5484903

Line 439: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

435: ,lx_tilv_rec);
436:
437: --dbms_output.put_line('Successfully inserted into Lines :'||l_return_status);
438:
439: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
440: RAISE Fnd_Api.G_EXC_ERROR;
441: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
442: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
443: END IF;

Line 440: RAISE Fnd_Api.G_EXC_ERROR;

436:
437: --dbms_output.put_line('Successfully inserted into Lines :'||l_return_status);
438:
439: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
440: RAISE Fnd_Api.G_EXC_ERROR;
441: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
442: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:

Line 441: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

437: --dbms_output.put_line('Successfully inserted into Lines :'||l_return_status);
438:
439: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
440: RAISE Fnd_Api.G_EXC_ERROR;
441: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
442: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:
445: -- Get sty_id for the contract

Line 442: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

438:
439: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
440: RAISE Fnd_Api.G_EXC_ERROR;
441: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
442: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:
445: -- Get sty_id for the contract
446: Okl_Streams_Util.get_primary_stream_type(

Line 488: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

484: ,l_tldv_rec
485: ,lx_tldv_rec);
486:
487:
488: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
489: RAISE Fnd_Api.G_EXC_ERROR;
490: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
491: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
492: END IF;

Line 489: RAISE Fnd_Api.G_EXC_ERROR;

485: ,lx_tldv_rec);
486:
487:
488: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
489: RAISE Fnd_Api.G_EXC_ERROR;
490: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
491: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:

Line 490: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

486:
487:
488: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
489: RAISE Fnd_Api.G_EXC_ERROR;
490: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
491: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:
494: p_bpd_acc_rec.id := lx_tldv_rec.id;

Line 491: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

487:
488: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
489: RAISE Fnd_Api.G_EXC_ERROR;
490: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
491: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:
494: p_bpd_acc_rec.id := lx_tldv_rec.id;
495: p_bpd_acc_rec.source_table := 'OKL_TXD_AR_LN_DTLS_B';

Line 566: ,FND_API.G_VALID_LEVEL_FULL -- addressing bug 3468630

562: 1.0
563: ,''
564: ,''
565: -- ,NULL
566: ,FND_API.G_VALID_LEVEL_FULL -- addressing bug 3468630
567: ,l_ctr_grp_log_rec
568: ,l_ctr_rdg_tbl
569: ,l_prop_rdg_tbl
570: ,l_return_status

Line 576: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

572: ,l_msg_data);
573:
574:
575: -- dbms_output.put_line('msg_date from install base :'||l_msg_data);
576: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
577: RAISE Fnd_Api.G_EXC_ERROR;
578: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
579: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
580: END IF;

Line 577: RAISE Fnd_Api.G_EXC_ERROR;

573:
574:
575: -- dbms_output.put_line('msg_date from install base :'||l_msg_data);
576: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
577: RAISE Fnd_Api.G_EXC_ERROR;
578: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
579: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
580: END IF;
581:

Line 578: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

574:
575: -- dbms_output.put_line('msg_date from install base :'||l_msg_data);
576: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
577: RAISE Fnd_Api.G_EXC_ERROR;
578: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
579: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
580: END IF;
581:
582:

Line 579: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

575: -- dbms_output.put_line('msg_date from install base :'||l_msg_data);
576: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
577: RAISE Fnd_Api.G_EXC_ERROR;
578: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
579: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
580: END IF;
581:
582:
583: x_return_status := l_return_status;

Line 592: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN

588: i := l_cntr_bill_tbl.NEXT(i);
589: END LOOP;
590:
591: END IF;
592: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
593: RAISE l_ins_ext;
594: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
595: RAISE l_ins_ext;
596: END IF;

Line 594: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

590:
591: END IF;
592: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
593: RAISE l_ins_ext;
594: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
595: RAISE l_ins_ext;
596: END IF;
597: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
598: