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_SETUPFMACONSTRAINTS_PVT dependencies on FND_API

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

459: l_fodv_tbl fodv_tbl_type;
460: l_data VARCHAR2(100);
461: l_count NUMBER ;
462: l_api_name CONSTANT VARCHAR2(30) := 'insert_fmaconstraints';
463: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
464: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
465: i NUMBER;
466:
467: BEGIN

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

460: l_data VARCHAR2(100);
461: l_count NUMBER ;
462: l_api_name CONSTANT VARCHAR2(30) := 'insert_fmaconstraints';
463: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
464: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
465: i NUMBER;
466:
467: BEGIN
468: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 468: x_return_status := FND_API.G_RET_STS_SUCCESS;

464: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
465: i NUMBER;
466:
467: BEGIN
468: x_return_status := FND_API.G_RET_STS_SUCCESS;
469: SAVEPOINT insert_fmaconstraints;
470: l_fodv_tbl := p_fodv_tbl;
471:
472:

Line 490: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

486: ,x_fodv_rec => x_fodv_tbl(i)
487: );
488:
489: -- store the highest degree of error
490: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
491: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
492: l_overall_status := x_return_status;
493: END IF;
494: END IF;

Line 491: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

487: );
488:
489: -- store the highest degree of error
490: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
491: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
492: l_overall_status := x_return_status;
493: END IF;
494: END IF;
495: EXIT WHEN (i = p_fodv_tbl.LAST);

Line 507: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

503: END IF;
504:
505: l_return_status := x_return_status;
506:
507: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
508: RAISE FND_API.G_EXC_ERROR;
509: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;

Line 508: RAISE FND_API.G_EXC_ERROR;

504:
505: l_return_status := x_return_status;
506:
507: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
508: RAISE FND_API.G_EXC_ERROR;
509: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512:

Line 509: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

505: l_return_status := x_return_status;
506:
507: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
508: RAISE FND_API.G_EXC_ERROR;
509: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512:
513: /* re-assign local table structure using output table from pvt api */

Line 510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

506:
507: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
508: RAISE FND_API.G_EXC_ERROR;
509: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512:
513: /* re-assign local table structure using output table from pvt api */
514: l_fodv_tbl := x_fodv_tbl;

Line 517: WHEN FND_API.G_EXC_ERROR THEN

513: /* re-assign local table structure using output table from pvt api */
514: l_fodv_tbl := x_fodv_tbl;
515:
516: EXCEPTION
517: WHEN FND_API.G_EXC_ERROR THEN
518: ROLLBACK TO insert_fmaconstraints;
519: x_return_status := FND_API.G_RET_STS_ERROR;
520:
521: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 519: x_return_status := FND_API.G_RET_STS_ERROR;

515:
516: EXCEPTION
517: WHEN FND_API.G_EXC_ERROR THEN
518: ROLLBACK TO insert_fmaconstraints;
519: x_return_status := FND_API.G_RET_STS_ERROR;
520:
521: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
522: ,p_count => x_msg_count
523: ,p_data => x_msg_data);

Line 525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

521: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
522: ,p_count => x_msg_count
523: ,p_data => x_msg_data);
524:
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526: ROLLBACK TO insert_fmaconstraints;
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
529: ,p_count => x_msg_count

Line 527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

523: ,p_data => x_msg_data);
524:
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526: ROLLBACK TO insert_fmaconstraints;
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
529: ,p_count => x_msg_count
530: ,p_data => x_msg_data);
531:

Line 539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
536: ,p_count => x_msg_count
537: ,p_data => x_msg_data);
538: -- notify caller of an UNEXPECTED error
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: END insert_fmaconstraints;
541: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FMLA_OPRNDS - TBL : end
542:
543: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_FMLA_OPRNDS - TBL : begin

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

554: l_fodv_tbl fodv_tbl_type;
555: l_data VARCHAR2(100);
556: l_count NUMBER ;
557: l_api_name CONSTANT VARCHAR2(30) := 'update_fmaconstraints';
558: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
559: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
560: i NUMBER;
561:
562: BEGIN

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

555: l_data VARCHAR2(100);
556: l_count NUMBER ;
557: l_api_name CONSTANT VARCHAR2(30) := 'update_fmaconstraints';
558: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
559: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
560: i NUMBER;
561:
562: BEGIN
563: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 563: x_return_status := FND_API.G_RET_STS_SUCCESS;

559: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
560: i NUMBER;
561:
562: BEGIN
563: x_return_status := FND_API.G_RET_STS_SUCCESS;
564: SAVEPOINT update_fmaconstraints;
565: l_fodv_tbl := p_fodv_tbl;
566:
567:

Line 589: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

585: ,x_fodv_rec => x_fodv_tbl(i)
586: );
587:
588: -- store the highest degree of error
589: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
590: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
591: l_overall_status := x_return_status;
592: END IF;
593: END IF;

Line 590: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

586: );
587:
588: -- store the highest degree of error
589: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
590: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
591: l_overall_status := x_return_status;
592: END IF;
593: END IF;
594: EXIT WHEN (i = p_fodv_tbl.LAST);

Line 606: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

602: END IF;
603:
604: l_return_status := x_return_status;
605:
606: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
607: RAISE FND_API.G_EXC_ERROR;
608: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
610: END IF;

Line 607: RAISE FND_API.G_EXC_ERROR;

603:
604: l_return_status := x_return_status;
605:
606: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
607: RAISE FND_API.G_EXC_ERROR;
608: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
610: END IF;
611:

Line 608: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

604: l_return_status := x_return_status;
605:
606: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
607: RAISE FND_API.G_EXC_ERROR;
608: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
610: END IF;
611:
612: /* re-assign local table structure using output table from pvt api */

Line 609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

605:
606: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
607: RAISE FND_API.G_EXC_ERROR;
608: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
610: END IF;
611:
612: /* re-assign local table structure using output table from pvt api */
613: l_fodv_tbl := x_fodv_tbl;

Line 618: WHEN FND_API.G_EXC_ERROR THEN

614:
615:
616:
617: EXCEPTION
618: WHEN FND_API.G_EXC_ERROR THEN
619: ROLLBACK TO update_fmaconstraints;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621:
622: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 620: x_return_status := FND_API.G_RET_STS_ERROR;

616:
617: EXCEPTION
618: WHEN FND_API.G_EXC_ERROR THEN
619: ROLLBACK TO update_fmaconstraints;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621:
622: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
623: ,p_count => x_msg_count
624: ,p_data => x_msg_data);

Line 626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

622: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
623: ,p_count => x_msg_count
624: ,p_data => x_msg_data);
625:
626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
627: ROLLBACK TO update_fmaconstraints;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
630: ,p_count => x_msg_count

Line 628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

624: ,p_data => x_msg_data);
625:
626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
627: ROLLBACK TO update_fmaconstraints;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
630: ,p_count => x_msg_count
631: ,p_data => x_msg_data);
632:

Line 640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

636: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
637: ,p_count => x_msg_count
638: ,p_data => x_msg_data);
639: -- notify caller of an UNEXPECTED error
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641: END update_fmaconstraints;
642: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_FMLA_OPRNDS - TBL : end
643:
644: