APPS.JTF_RS_RESOURCE_PUB dependencies on FND_API

Line 457: x_return_status := fnd_api.g_ret_sts_success;

453:
454:
455: SAVEPOINT create_resource_pub;
456:
457: x_return_status := fnd_api.g_ret_sts_success;
458:
459: -- DBMS_OUTPUT.put_line(' Started Create Resource Pub ');
460:
461:

Line 463: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

459: -- DBMS_OUTPUT.put_line(' Started Create Resource Pub ');
460:
461:
462:
463: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
464:
465: RAISE fnd_api.g_exc_unexpected_error;
466:
467: END IF;

Line 465: RAISE fnd_api.g_exc_unexpected_error;

461:
462:
463: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
464:
465: RAISE fnd_api.g_exc_unexpected_error;
466:
467: END IF;
468:
469:

Line 470: IF fnd_api.to_boolean(p_init_msg_list) THEN

466:
467: END IF;
468:
469:
470: IF fnd_api.to_boolean(p_init_msg_list) THEN
471:
472: fnd_msg_pub.initialize;
473:
474: END IF;

Line 486: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

482: x_return_status => x_return_status
483: );
484:
485:
486: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
487: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
488: RAISE FND_API.G_EXC_ERROR;
489: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 487: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

483: );
484:
485:
486: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
487: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
488: RAISE FND_API.G_EXC_ERROR;
489: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;

Line 488: RAISE FND_API.G_EXC_ERROR;

484:
485:
486: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
487: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
488: RAISE FND_API.G_EXC_ERROR;
489: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;
492: END IF;

Line 489: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

485:
486: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
487: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
488: RAISE FND_API.G_EXC_ERROR;
489: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;
492: END IF;
493:

Line 490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

486: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
487: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
488: RAISE FND_API.G_EXC_ERROR;
489: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;
492: END IF;
493:
494: /* Validate Source ID */

Line 503: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

499: p_address_id => l_address_id,
500: x_return_status => x_return_status
501: );
502:
503: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
504: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
505: RAISE FND_API.G_EXC_ERROR;
506: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 504: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

500: x_return_status => x_return_status
501: );
502:
503: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
504: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
505: RAISE FND_API.G_EXC_ERROR;
506: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;

Line 505: RAISE FND_API.G_EXC_ERROR;

501: );
502:
503: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
504: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
505: RAISE FND_API.G_EXC_ERROR;
506: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509: END IF;

Line 506: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

502:
503: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
504: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
505: RAISE FND_API.G_EXC_ERROR;
506: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509: END IF;
510:

Line 507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

503: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
504: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
505: RAISE FND_API.G_EXC_ERROR;
506: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509: END IF;
510:
511: /* Validations for category as OTHER and TBH */

Line 526: RAISE fnd_api.g_exc_error;

522: -- dbms_output.put_line('For OTHER category, source_id, address_id, contact_id and managing_emp_id should be all null');
523:
524: fnd_message.set_name('JTF', 'JTF_RS_OTHER_IDS_NOT_NULL');
525: fnd_msg_pub.add;
526: RAISE fnd_api.g_exc_error;
527:
528: END IF;
529:
530: END IF;

Line 542: RAISE fnd_api.g_exc_error;

538: IF (l_source_id IS NULL) THEN
539: -- dbms_output.put_line('For PARTNER category, source_id should not be null');
540: fnd_message.set_name('JTF', 'JTF_RS_PARTNER_IDS_NULL');
541: fnd_msg_pub.add;
542: RAISE fnd_api.g_exc_error;
543: ELSE
544: IF G_RS_ID_PUB_FLAG = 'Y' THEN --This flag is checked for migration purpose.
545: OPEN c_validate_partner(l_source_id);
546: FETCH c_validate_partner INTO l_check_flag;

Line 551: RAISE fnd_api.g_exc_error;

547: IF c_validate_partner%NOTFOUND THEN
548: -- dbms_output.put_line('Partner does not exist for the passed source_id');
549: fnd_message.set_name('JTF', 'JTF_RS_INVALID_PARTNER_IDS');
550: fnd_msg_pub.add;
551: RAISE fnd_api.g_exc_error;
552: END IF;
553: CLOSE c_validate_partner;
554: ELSIF G_RS_ID_PUB_FLAG = 'N' THEN
555: OPEN c_validate_partner_migr(l_source_id);

Line 562: RAISE fnd_api.g_exc_error;

558: IF c_validate_partner_migr%NOTFOUND THEN
559: -- dbms_output.put_line('Partner does not exist for the passed source_id');
560: fnd_message.set_name('JTF', 'JTF_RS_INVALID_PARTNER_IDS');
561: fnd_msg_pub.add;
562: RAISE fnd_api.g_exc_error;
563: END IF;
564: CLOSE c_validate_partner_migr;
565: END IF;
566: END IF;

Line 578: RAISE fnd_api.g_exc_error;

574: -- dbms_output.put_line('Invalid Partner Address Id');
575: fnd_message.set_name('JTF', 'JTF_RS_ERR_PARTNER_ADDRESS_ID');
576: fnd_message.set_token('P_ADDRESS_ID', l_address_id);
577: fnd_msg_pub.add;
578: RAISE fnd_api.g_exc_error;
579: END IF;
580: CLOSE c_validate_partner_address;
581: END IF;
582:

Line 594: RAISE fnd_api.g_exc_error;

590: -- dbms_output.put_line('Invalid Partner Contact Id');
591: fnd_message.set_name('JTF', 'JTF_RS_ERR_PARTNER_CONTACT_ID');
592: fnd_message.set_token('P_CONTACT_ID', l_contact_id);
593: fnd_msg_pub.add;
594: RAISE fnd_api.g_exc_error;
595: END IF;
596: CLOSE c_validate_partner_contact;
597: END IF;
598:

Line 611: RAISE fnd_api.g_exc_error;

607: IF l_source_id IS NULL THEN
608: -- dbms_output.put_line('Source Id should not be Null');
609: fnd_message.set_name('JTF', 'JTF_RS_SOURCE_ID_NULL');
610: fnd_msg_pub.add;
611: RAISE fnd_api.g_exc_error;
612: END IF;
613:
614: jtf_resource_utl.check_object_existence_migr(
615:

Line 624: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

620: X_FOUND => l_found,
621: X_RETURN_STATUS => x_return_status
622: );
623:
624: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
625: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
626: RAISE FND_API.G_EXC_ERROR;
627: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 625: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

621: X_RETURN_STATUS => x_return_status
622: );
623:
624: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
625: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
626: RAISE FND_API.G_EXC_ERROR;
627: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;

Line 626: RAISE FND_API.G_EXC_ERROR;

622: );
623:
624: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
625: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
626: RAISE FND_API.G_EXC_ERROR;
627: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;
630: END IF;

Line 627: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

623:
624: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
625: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
626: RAISE FND_API.G_EXC_ERROR;
627: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;
630: END IF;
631:

Line 628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

624: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
625: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
626: RAISE FND_API.G_EXC_ERROR;
627: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;
630: END IF;
631:
632: IF l_found = FALSE THEN

Line 636: RAISE fnd_api.g_exc_error;

632: IF l_found = FALSE THEN
633: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SOURCE_ID');
634: fnd_message.set_token('P_SOURCE_ID', l_source_id);
635: fnd_msg_pub.add;
636: RAISE fnd_api.g_exc_error;
637: END IF;
638:
639: END IF;
640:

Line 650: RAISE fnd_api.g_exc_error;

646: -- First check is null check for source id
647: IF l_source_id IS NULL THEN
648: fnd_message.set_name('JTF', 'JTF_RS_SOURCE_ID_NULL');
649: fnd_msg_pub.add;
650: RAISE fnd_api.g_exc_error;
651: END IF;
652:
653: open c_emp_exist(l_source_id);
654: fetch c_emp_exist into r_emp_exist;

Line 662: RAISE fnd_api.g_exc_error;

658: then
659: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SOURCE_ID');
660: fnd_message.set_token('P_SOURCE_ID', l_source_id);
661: fnd_msg_pub.add;
662: RAISE fnd_api.g_exc_error;
663: end if;
664:
665: END IF; -- end of check l_category = 'EMPLOYEE'
666:

Line 688: RAISE fnd_api.g_exc_error;

684: fnd_message.set_name('JTF', 'JTF_RS_INVALID_PARTY_ADDRESS');
685: fnd_message.set_token('P_ADDRESS_ID', l_address_id);
686: fnd_msg_pub.add;
687:
688: RAISE fnd_api.g_exc_error;
689:
690: END IF;
691:
692: /* Close the cursor */

Line 717: RAISE fnd_api.g_exc_error;

713: fnd_message.set_name('JTF', 'JTF_RS_ERR_PARTY_CONTACT_ID');
714: fnd_message.set_token('P_CONTACT_ID', l_contact_id);
715: fnd_msg_pub.add;
716:
717: RAISE fnd_api.g_exc_error;
718:
719: END IF;
720:
721:

Line 747: RAISE fnd_api.g_exc_error;

743:
744: fnd_message.set_name('JTF', 'JTF_RS_SC_IDS_NOT_NULL');
745: fnd_msg_pub.add;
746:
747: RAISE fnd_api.g_exc_error;
748:
749: END IF;
750:
751: END IF;

Line 769: RAISE fnd_api.g_exc_error;

765:
766: fnd_message.set_name('JTF', 'JTF_RS_EMP_IDS_NOT_NULL');
767: fnd_msg_pub.add;
768:
769: RAISE fnd_api.g_exc_error;
770:
771: END IF;
772:
773: END IF;

Line 788: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

784: );
785: -- added for NOCOPY
786: l_managing_emp_id := l_managing_emp_id_out;
787:
788: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
789: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 789: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

785: -- added for NOCOPY
786: l_managing_emp_id := l_managing_emp_id_out;
787:
788: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
789: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;

Line 790: RAISE FND_API.G_EXC_ERROR;

786: l_managing_emp_id := l_managing_emp_id_out;
787:
788: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
789: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:

Line 791: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

787:
788: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
789: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:
795: END IF;

Line 792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

788: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
789: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:
795: END IF;
796:

Line 807: RAISE fnd_api.g_exc_error;

803:
804: fnd_message.set_name('JTF', 'JTF_RS_START_DATE_NULL');
805: fnd_msg_pub.add;
806:
807: RAISE fnd_api.g_exc_error;
808:
809: END IF;
810:
811:

Line 822: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

818: p_time_zone_id => l_time_zone,
819: x_return_status => x_return_status
820: );
821:
822: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
823: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
824: RAISE FND_API.G_EXC_ERROR;
825: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 823: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

819: x_return_status => x_return_status
820: );
821:
822: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
823: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
824: RAISE FND_API.G_EXC_ERROR;
825: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;

Line 824: RAISE FND_API.G_EXC_ERROR;

820: );
821:
822: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
823: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
824: RAISE FND_API.G_EXC_ERROR;
825: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;
828: END IF;

Line 825: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

821:
822: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
823: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
824: RAISE FND_API.G_EXC_ERROR;
825: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;
828: END IF;
829:

Line 826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

822: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
823: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
824: RAISE FND_API.G_EXC_ERROR;
825: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;
828: END IF;
829:
830: END IF;

Line 843: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

839: p_nls_language => l_primary_language,
840: x_return_status => x_return_status
841: );
842:
843: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
844: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
845: RAISE FND_API.G_EXC_ERROR;
846: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 844: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

840: x_return_status => x_return_status
841: );
842:
843: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
844: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
845: RAISE FND_API.G_EXC_ERROR;
846: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
848: END IF;

Line 845: RAISE FND_API.G_EXC_ERROR;

841: );
842:
843: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
844: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
845: RAISE FND_API.G_EXC_ERROR;
846: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
848: END IF;
849: END IF;

Line 846: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

842:
843: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
844: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
845: RAISE FND_API.G_EXC_ERROR;
846: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
848: END IF;
849: END IF;
850:

Line 847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

843: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
844: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
845: RAISE FND_API.G_EXC_ERROR;
846: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
848: END IF;
849: END IF;
850:
851: END IF;

Line 864: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

860: p_nls_language => l_secondary_language,
861: x_return_status => x_return_status
862: );
863:
864: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
865: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
866: RAISE FND_API.G_EXC_ERROR;
867: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 865: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

861: x_return_status => x_return_status
862: );
863:
864: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
865: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
866: RAISE FND_API.G_EXC_ERROR;
867: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
869: END IF;

Line 866: RAISE FND_API.G_EXC_ERROR;

862: );
863:
864: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
865: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
866: RAISE FND_API.G_EXC_ERROR;
867: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
869: END IF;
870: END IF;

Line 867: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

863:
864: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
865: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
866: RAISE FND_API.G_EXC_ERROR;
867: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
869: END IF;
870: END IF;
871:

Line 868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

864: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
865: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
866: RAISE FND_API.G_EXC_ERROR;
867: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
869: END IF;
870: END IF;
871:
872: END IF;

Line 885: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

881: p_support_site_id => l_support_site_id,
882: x_return_status => x_return_status
883: );
884:
885: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
886: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
887: RAISE FND_API.G_EXC_ERROR;
888: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 886: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

882: x_return_status => x_return_status
883: );
884:
885: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
886: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
887: RAISE FND_API.G_EXC_ERROR;
888: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890: END IF;

Line 887: RAISE FND_API.G_EXC_ERROR;

883: );
884:
885: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
886: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
887: RAISE FND_API.G_EXC_ERROR;
888: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890: END IF;
891: END IF;

Line 888: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

884:
885: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
886: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
887: RAISE FND_API.G_EXC_ERROR;
888: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890: END IF;
891: END IF;
892:

Line 889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

885: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
886: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
887: RAISE FND_API.G_EXC_ERROR;
888: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890: END IF;
891: END IF;
892:
893: END IF;

Line 909: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

905:
906: -- added for NOCOPY
907: l_server_group_id := l_server_group_id_out;
908:
909: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
910: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
911: RAISE FND_API.G_EXC_ERROR;
912: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 910: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

906: -- added for NOCOPY
907: l_server_group_id := l_server_group_id_out;
908:
909: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
910: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
911: RAISE FND_API.G_EXC_ERROR;
912: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
914: END IF;

Line 911: RAISE FND_API.G_EXC_ERROR;

907: l_server_group_id := l_server_group_id_out;
908:
909: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
910: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
911: RAISE FND_API.G_EXC_ERROR;
912: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
914: END IF;
915: END IF;

Line 912: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

908:
909: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
910: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
911: RAISE FND_API.G_EXC_ERROR;
912: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
914: END IF;
915: END IF;
916:

Line 913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

909: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
910: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
911: RAISE FND_API.G_EXC_ERROR;
912: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
914: END IF;
915: END IF;
916:
917:

Line 934: RAISE fnd_api.g_exc_error;

930:
931: fnd_message.set_name('JTF', 'JTF_RS_ERR_ASSIGN_TO_GRP_ID');
932: fnd_message.set_token('P_ASSIGNED_TO_GROUP_ID', l_assigned_to_group_id);
933: fnd_msg_pub.add;
934: RAISE fnd_api.g_exc_error;
935:
936: END IF;
937:
938:

Line 956: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

952: p_currency_code => l_comp_currency_code,
953: x_return_status => x_return_status
954: );
955:
956: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
957: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
958: RAISE FND_API.G_EXC_ERROR;
959: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 957: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

953: x_return_status => x_return_status
954: );
955:
956: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
957: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
958: RAISE FND_API.G_EXC_ERROR;
959: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: END IF;

Line 958: RAISE FND_API.G_EXC_ERROR;

954: );
955:
956: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
957: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
958: RAISE FND_API.G_EXC_ERROR;
959: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: END IF;
962: END IF;

Line 959: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

955:
956: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
957: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
958: RAISE FND_API.G_EXC_ERROR;
959: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: END IF;
962: END IF;
963:

Line 960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

956: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
957: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
958: RAISE FND_API.G_EXC_ERROR;
959: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: END IF;
962: END IF;
963:
964: END IF;

Line 976: RAISE fnd_api.g_exc_error;

972:
973: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
974: fnd_msg_pub.add;
975:
976: RAISE fnd_api.g_exc_error;
977:
978: END IF;
979:
980:

Line 989: RAISE fnd_api.g_exc_error;

985: -- dbms_output.put_line('Hold Payment should either be ''Y'' or ''N'' ');
986:
987: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
988: fnd_msg_pub.add;
989: RAISE fnd_api.g_exc_error;
990:
991: END IF;
992:
993:

Line 1004: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1000: p_hold_reason_code => l_hold_reason_code,
1001: x_return_status => x_return_status
1002: );
1003:
1004: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1005: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1006: RAISE FND_API.G_EXC_ERROR;
1007: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1005: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1001: x_return_status => x_return_status
1002: );
1003:
1004: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1005: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1006: RAISE FND_API.G_EXC_ERROR;
1007: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1009: END IF;

Line 1006: RAISE FND_API.G_EXC_ERROR;

1002: );
1003:
1004: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1005: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1006: RAISE FND_API.G_EXC_ERROR;
1007: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1009: END IF;
1010: END IF;

Line 1007: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1003:
1004: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1005: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1006: RAISE FND_API.G_EXC_ERROR;
1007: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1009: END IF;
1010: END IF;
1011:

Line 1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1004: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1005: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1006: RAISE FND_API.G_EXC_ERROR;
1007: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1009: END IF;
1010: END IF;
1011:
1012: END IF;

Line 1025: RAISE fnd_api.g_exc_error;

1021:
1022: fnd_message.set_name('JTF', 'JTF_RS_USERID_ERROR');
1023: fnd_msg_pub.add;
1024:
1025: RAISE fnd_api.g_exc_error;
1026:
1027: END IF;
1028:
1029: ELSE

Line 1042: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1038: p_source_id => l_source_id,
1039: x_return_status => x_return_status
1040: );
1041:
1042: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1043:
1044: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1045: RAISE FND_API.G_EXC_ERROR;
1046: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1044: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1040: );
1041:
1042: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1043:
1044: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1045: RAISE FND_API.G_EXC_ERROR;
1046: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1048: END IF;

Line 1045: RAISE FND_API.G_EXC_ERROR;

1041:
1042: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1043:
1044: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1045: RAISE FND_API.G_EXC_ERROR;
1046: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1048: END IF;
1049:

Line 1046: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1042: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1043:
1044: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1045: RAISE FND_API.G_EXC_ERROR;
1046: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1048: END IF;
1049:
1050: else

Line 1047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1043:
1044: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1045: RAISE FND_API.G_EXC_ERROR;
1046: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1048: END IF;
1049:
1050: else
1051:

Line 1065: RAISE fnd_api.g_exc_error;

1061: fnd_message.set_name('JTF', 'JTF_RS_ERR_DUPLICATE_USER_ID');
1062: fnd_message.set_token('P_USER_ID', l_user_id);
1063: fnd_msg_pub.add;
1064:
1065: RAISE fnd_api.g_exc_error;
1066:
1067: END IF;
1068:
1069:

Line 1097: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1093:
1094: -- added for NOCOPY
1095: l_comp_service_team_id := l_comp_service_team_id_out;
1096:
1097: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1098:
1099: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1100: RAISE FND_API.G_EXC_ERROR;
1101: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1099: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1095: l_comp_service_team_id := l_comp_service_team_id_out;
1096:
1097: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1098:
1099: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1100: RAISE FND_API.G_EXC_ERROR;
1101: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: END IF;

Line 1100: RAISE FND_API.G_EXC_ERROR;

1096:
1097: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1098:
1099: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1100: RAISE FND_API.G_EXC_ERROR;
1101: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: END IF;
1104:

Line 1101: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1097: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1098:
1099: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1100: RAISE FND_API.G_EXC_ERROR;
1101: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: END IF;
1104:
1105: END IF;

Line 1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1098:
1099: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1100: RAISE FND_API.G_EXC_ERROR;
1101: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: END IF;
1104:
1105: END IF;
1106:

Line 1122: P_INIT_MSG_LIST => fnd_api.g_false,

1118: -- dbms_output.put_line ('Before call to the private procedure create_resource');
1119:
1120: jtf_rs_resource_pvt.create_resource (
1121: P_API_VERSION => 1,
1122: P_INIT_MSG_LIST => fnd_api.g_false,
1123: P_COMMIT => fnd_api.g_false,
1124: P_CATEGORY => l_category,
1125: P_SOURCE_ID => l_source_id,
1126: P_ADDRESS_ID => l_address_id,

Line 1123: P_COMMIT => fnd_api.g_false,

1119:
1120: jtf_rs_resource_pvt.create_resource (
1121: P_API_VERSION => 1,
1122: P_INIT_MSG_LIST => fnd_api.g_false,
1123: P_COMMIT => fnd_api.g_false,
1124: P_CATEGORY => l_category,
1125: P_SOURCE_ID => l_source_id,
1126: P_ADDRESS_ID => l_address_id,
1127: P_CONTACT_ID => l_contact_id,

Line 1158: P_INIT_MSG_LIST => fnd_api.g_false,

1154: );
1155:
1156: /* jtf_rs_resource_pvt.create_resource (
1157: P_API_VERSION => 1,
1158: P_INIT_MSG_LIST => fnd_api.g_false,
1159: P_COMMIT => fnd_api.g_false,
1160: P_CATEGORY => l_category,
1161: P_SOURCE_ID => l_source_id,
1162: P_ADDRESS_ID => l_address_id,

Line 1159: P_COMMIT => fnd_api.g_false,

1155:
1156: /* jtf_rs_resource_pvt.create_resource (
1157: P_API_VERSION => 1,
1158: P_INIT_MSG_LIST => fnd_api.g_false,
1159: P_COMMIT => fnd_api.g_false,
1160: P_CATEGORY => l_category,
1161: P_SOURCE_ID => l_source_id,
1162: P_ADDRESS_ID => l_address_id,
1163: P_CONTACT_ID => l_contact_id,

Line 1212: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1208: );
1209:
1210: */
1211:
1212: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1213: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1214: RAISE FND_API.G_EXC_ERROR;
1215: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1213: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1209:
1210: */
1211:
1212: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1213: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1214: RAISE FND_API.G_EXC_ERROR;
1215: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: END IF;

Line 1214: RAISE FND_API.G_EXC_ERROR;

1210: */
1211:
1212: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1213: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1214: RAISE FND_API.G_EXC_ERROR;
1215: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: END IF;
1218: END IF;

Line 1215: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1211:
1212: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1213: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1214: RAISE FND_API.G_EXC_ERROR;
1215: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: END IF;
1218: END IF;
1219:

Line 1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1212: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1213: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1214: RAISE FND_API.G_EXC_ERROR;
1215: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: END IF;
1218: END IF;
1219:
1220: ELSE

Line 1228: P_INIT_MSG_LIST => fnd_api.g_false,

1224: /* Call the private procedure for Migration. */
1225:
1226: jtf_rs_resource_pvt.create_resource_migrate (
1227: P_API_VERSION => 1,
1228: P_INIT_MSG_LIST => fnd_api.g_false,
1229: P_COMMIT => fnd_api.g_false,
1230: P_CATEGORY => l_category,
1231: P_SOURCE_ID => l_source_id,
1232: P_ADDRESS_ID => l_address_id,

Line 1229: P_COMMIT => fnd_api.g_false,

1225:
1226: jtf_rs_resource_pvt.create_resource_migrate (
1227: P_API_VERSION => 1,
1228: P_INIT_MSG_LIST => fnd_api.g_false,
1229: P_COMMIT => fnd_api.g_false,
1230: P_CATEGORY => l_category,
1231: P_SOURCE_ID => l_source_id,
1232: P_ADDRESS_ID => l_address_id,
1233: P_CONTACT_ID => l_contact_id,

Line 1278: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1274: X_MSG_DATA => x_msg_data,
1275: X_RESOURCE_ID => x_resource_id,
1276: X_RESOURCE_NUMBER => x_resource_number
1277: );
1278: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1279: -- dbms_output.put_line('Failed status from call to private procedure');
1280: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1281: RAISE FND_API.G_EXC_ERROR;
1282: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1280: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1276: X_RESOURCE_NUMBER => x_resource_number
1277: );
1278: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1279: -- dbms_output.put_line('Failed status from call to private procedure');
1280: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1281: RAISE FND_API.G_EXC_ERROR;
1282: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: END IF;

Line 1281: RAISE FND_API.G_EXC_ERROR;

1277: );
1278: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1279: -- dbms_output.put_line('Failed status from call to private procedure');
1280: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1281: RAISE FND_API.G_EXC_ERROR;
1282: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: END IF;
1285: END IF;

Line 1282: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1278: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1279: -- dbms_output.put_line('Failed status from call to private procedure');
1280: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1281: RAISE FND_API.G_EXC_ERROR;
1282: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: END IF;
1285: END IF;
1286:

Line 1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1279: -- dbms_output.put_line('Failed status from call to private procedure');
1280: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1281: RAISE FND_API.G_EXC_ERROR;
1282: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: END IF;
1285: END IF;
1286:
1287: END IF;

Line 1289: IF fnd_api.to_boolean(p_commit) THEN

1285: END IF;
1286:
1287: END IF;
1288:
1289: IF fnd_api.to_boolean(p_commit) THEN
1290:
1291: COMMIT WORK;
1292:
1293: END IF;

Line 1301: WHEN fnd_api.g_exc_error THEN

1297:
1298: EXCEPTION
1299:
1300:
1301: WHEN fnd_api.g_exc_error THEN
1302: ROLLBACK TO create_resource_pub;
1303: x_return_status := fnd_api.g_ret_sts_error;
1304: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1305: p_data => x_msg_data);

Line 1303: x_return_status := fnd_api.g_ret_sts_error;

1299:
1300:
1301: WHEN fnd_api.g_exc_error THEN
1302: ROLLBACK TO create_resource_pub;
1303: x_return_status := fnd_api.g_ret_sts_error;
1304: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1305: p_data => x_msg_data);
1306: WHEN fnd_api.g_exc_unexpected_error THEN
1307: ROLLBACK TO create_resource_pub;

Line 1306: WHEN fnd_api.g_exc_unexpected_error THEN

1302: ROLLBACK TO create_resource_pub;
1303: x_return_status := fnd_api.g_ret_sts_error;
1304: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1305: p_data => x_msg_data);
1306: WHEN fnd_api.g_exc_unexpected_error THEN
1307: ROLLBACK TO create_resource_pub;
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1310: p_data => x_msg_data);

Line 1308: x_return_status := fnd_api.g_ret_sts_unexp_error;

1304: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1305: p_data => x_msg_data);
1306: WHEN fnd_api.g_exc_unexpected_error THEN
1307: ROLLBACK TO create_resource_pub;
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1310: p_data => x_msg_data);
1311: WHEN OTHERS THEN
1312: ROLLBACK TO create_resource_pub;

Line 1318: x_return_status := fnd_api.g_ret_sts_unexp_error;

1314: fnd_message.set_token('P_SQLCODE',SQLCODE);
1315: fnd_message.set_token('P_SQLERRM',SQLERRM);
1316: fnd_message.set_token('P_API_NAME', l_api_name);
1317: FND_MSG_PUB.add;
1318: x_return_status := fnd_api.g_ret_sts_unexp_error;
1319: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1320: p_data => x_msg_data);
1321:
1322: END create_resource;

Line 1557: x_return_status := fnd_api.g_ret_sts_success;

1553:
1554:
1555: SAVEPOINT update_resource_pub;
1556:
1557: x_return_status := fnd_api.g_ret_sts_success;
1558:
1559: -- dbms_output.put_line(' Started Update Resource Pub ');
1560:
1561:

Line 1562: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1558:
1559: -- dbms_output.put_line(' Started Update Resource Pub ');
1560:
1561:
1562: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1563:
1564: RAISE fnd_api.g_exc_unexpected_error;
1565:
1566: END IF;

Line 1564: RAISE fnd_api.g_exc_unexpected_error;

1560:
1561:
1562: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1563:
1564: RAISE fnd_api.g_exc_unexpected_error;
1565:
1566: END IF;
1567:
1568:

Line 1569: IF fnd_api.to_boolean(p_init_msg_list) THEN

1565:
1566: END IF;
1567:
1568:
1569: IF fnd_api.to_boolean(p_init_msg_list) THEN
1570:
1571: fnd_msg_pub.initialize;
1572:
1573: END IF;

Line 1585: RAISE fnd_api.g_exc_error;

1581:
1582: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
1583: fnd_msg_pub.add;
1584:
1585: RAISE fnd_api.g_exc_error;
1586:
1587: END IF;
1588:
1589:

Line 1604: RAISE fnd_api.g_exc_error;

1600: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
1601: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);
1602: fnd_msg_pub.add;
1603:
1604: RAISE fnd_api.g_exc_error;
1605:
1606: END IF;
1607:
1608: CLOSE c_resource_id;

Line 1624: RAISE fnd_api.g_exc_error;

1620: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE_NUMBER');
1621: fnd_message.set_token('P_RESOURCE_NUMBER', l_resource_number);
1622: fnd_msg_pub.add;
1623:
1624: RAISE fnd_api.g_exc_error;
1625:
1626: END IF;
1627:
1628: CLOSE c_resource_number;

Line 1638: P_INIT_MSG_LIST => fnd_api.g_false,

1634: /* Call the private procedure with the validated parameters. */
1635:
1636: jtf_rs_resource_pvt.update_resource
1637: (P_API_VERSION => 1,
1638: P_INIT_MSG_LIST => fnd_api.g_false,
1639: P_COMMIT => fnd_api.g_false,
1640: P_RESOURCE_ID => l_resource_id,
1641: P_MANAGING_EMP_ID => l_managing_emp_id,
1642: P_START_DATE_ACTIVE => l_start_date_active,

Line 1639: P_COMMIT => fnd_api.g_false,

1635:
1636: jtf_rs_resource_pvt.update_resource
1637: (P_API_VERSION => 1,
1638: P_INIT_MSG_LIST => fnd_api.g_false,
1639: P_COMMIT => fnd_api.g_false,
1640: P_RESOURCE_ID => l_resource_id,
1641: P_MANAGING_EMP_ID => l_managing_emp_id,
1642: P_START_DATE_ACTIVE => l_start_date_active,
1643: P_END_DATE_ACTIVE => l_end_date_active,

Line 1667: P_SOURCE_NAME => fnd_api.g_miss_char

1663: X_MSG_COUNT => x_msg_count,
1664: X_MSG_DATA => x_msg_data,
1665: --added this so that the overloaded procedure for update resource is called
1666: -- otherwise all source coulmns were being set to null
1667: P_SOURCE_NAME => fnd_api.g_miss_char
1668: );
1669:
1670:
1671: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 1671: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1667: P_SOURCE_NAME => fnd_api.g_miss_char
1668: );
1669:
1670:
1671: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1672:
1673: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1674: RAISE FND_API.G_EXC_ERROR;
1675: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1673: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1669:
1670:
1671: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1672:
1673: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1674: RAISE FND_API.G_EXC_ERROR;
1675: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1677: END IF;

Line 1674: RAISE FND_API.G_EXC_ERROR;

1670:
1671: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1672:
1673: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1674: RAISE FND_API.G_EXC_ERROR;
1675: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1677: END IF;
1678:

Line 1675: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1671: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1672:
1673: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1674: RAISE FND_API.G_EXC_ERROR;
1675: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1677: END IF;
1678:
1679: END IF;

Line 1676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1672:
1673: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1674: RAISE FND_API.G_EXC_ERROR;
1675: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1677: END IF;
1678:
1679: END IF;
1680:

Line 1685: IF fnd_api.to_boolean(p_commit) THEN

1681: /* Return the new value of the object version number */
1682:
1683: p_object_version_num := l_object_version_num;
1684:
1685: IF fnd_api.to_boolean(p_commit) THEN
1686:
1687: COMMIT WORK;
1688:
1689: END IF;

Line 1696: WHEN fnd_api.g_exc_error THEN

1692:
1693:
1694:
1695: EXCEPTION
1696: WHEN fnd_api.g_exc_error THEN
1697: ROLLBACK TO update_resource_pub;
1698: x_return_status := fnd_api.g_ret_sts_error;
1699: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1700: p_data => x_msg_data);

Line 1698: x_return_status := fnd_api.g_ret_sts_error;

1694:
1695: EXCEPTION
1696: WHEN fnd_api.g_exc_error THEN
1697: ROLLBACK TO update_resource_pub;
1698: x_return_status := fnd_api.g_ret_sts_error;
1699: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1700: p_data => x_msg_data);
1701: WHEN fnd_api.g_exc_unexpected_error THEN
1702: ROLLBACK TO update_resource_pub;

Line 1701: WHEN fnd_api.g_exc_unexpected_error THEN

1697: ROLLBACK TO update_resource_pub;
1698: x_return_status := fnd_api.g_ret_sts_error;
1699: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1700: p_data => x_msg_data);
1701: WHEN fnd_api.g_exc_unexpected_error THEN
1702: ROLLBACK TO update_resource_pub;
1703: x_return_status := fnd_api.g_ret_sts_unexp_error;
1704: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1705: p_data => x_msg_data);

Line 1703: x_return_status := fnd_api.g_ret_sts_unexp_error;

1699: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1700: p_data => x_msg_data);
1701: WHEN fnd_api.g_exc_unexpected_error THEN
1702: ROLLBACK TO update_resource_pub;
1703: x_return_status := fnd_api.g_ret_sts_unexp_error;
1704: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1705: p_data => x_msg_data);
1706: WHEN OTHERS THEN
1707: ROLLBACK TO update_resource_pub;

Line 1713: x_return_status := fnd_api.g_ret_sts_unexp_error;

1709: fnd_message.set_token('P_SQLCODE',SQLCODE);
1710: fnd_message.set_token('P_SQLERRM',SQLERRM);
1711: fnd_message.set_token('P_API_NAME', l_api_name);
1712: FND_MSG_PUB.add;
1713: x_return_status := fnd_api.g_ret_sts_unexp_error;
1714: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1715: p_data => x_msg_data);
1716:
1717: END update_resource;

Line 1880: x_return_status := fnd_api.g_ret_sts_success;

1876:
1877:
1878: SAVEPOINT update_resource_pub;
1879:
1880: x_return_status := fnd_api.g_ret_sts_success;
1881:
1882: -- dbms_output.put_line(' Started Update Resource Pub ');
1883:
1884:

Line 1885: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1881:
1882: -- dbms_output.put_line(' Started Update Resource Pub ');
1883:
1884:
1885: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1886:
1887: RAISE fnd_api.g_exc_unexpected_error;
1888:
1889: END IF;

Line 1887: RAISE fnd_api.g_exc_unexpected_error;

1883:
1884:
1885: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1886:
1887: RAISE fnd_api.g_exc_unexpected_error;
1888:
1889: END IF;
1890:
1891:

Line 1892: IF fnd_api.to_boolean(p_init_msg_list) THEN

1888:
1889: END IF;
1890:
1891:
1892: IF fnd_api.to_boolean(p_init_msg_list) THEN
1893:
1894: fnd_msg_pub.initialize;
1895:
1896: END IF;

Line 1908: RAISE fnd_api.g_exc_error;

1904:
1905: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
1906: fnd_msg_pub.add;
1907:
1908: RAISE fnd_api.g_exc_error;
1909:
1910: END IF;
1911:
1912:

Line 1927: RAISE fnd_api.g_exc_error;

1923: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
1924: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);
1925: fnd_msg_pub.add;
1926:
1927: RAISE fnd_api.g_exc_error;
1928:
1929: END IF;
1930:
1931: CLOSE c_resource_id;

Line 1947: RAISE fnd_api.g_exc_error;

1943: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE_NUMBER');
1944: fnd_message.set_token('P_RESOURCE_NUMBER', l_resource_number);
1945: fnd_msg_pub.add;
1946:
1947: RAISE fnd_api.g_exc_error;
1948:
1949:
1950: END IF;
1951:

Line 1962: P_INIT_MSG_LIST => fnd_api.g_false,

1958: /* Call the private procedure with the validated parameters. */
1959:
1960: jtf_rs_resource_pvt.update_resource
1961: (P_API_VERSION => 1,
1962: P_INIT_MSG_LIST => fnd_api.g_false,
1963: P_COMMIT => fnd_api.g_false,
1964: P_RESOURCE_ID => l_resource_id,
1965: P_MANAGING_EMP_ID => l_managing_emp_id,
1966: P_START_DATE_ACTIVE => l_start_date_active,

Line 1963: P_COMMIT => fnd_api.g_false,

1959:
1960: jtf_rs_resource_pvt.update_resource
1961: (P_API_VERSION => 1,
1962: P_INIT_MSG_LIST => fnd_api.g_false,
1963: P_COMMIT => fnd_api.g_false,
1964: P_RESOURCE_ID => l_resource_id,
1965: P_MANAGING_EMP_ID => l_managing_emp_id,
1966: P_START_DATE_ACTIVE => l_start_date_active,
1967: P_END_DATE_ACTIVE => l_end_date_active,

Line 2042: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2038: P_SOURCE_PAGER => P_SOURCE_PAGER
2039: );
2040:
2041:
2042: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2043:
2044: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2045: RAISE FND_API.G_EXC_ERROR;
2046: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2044: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

2040:
2041:
2042: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2043:
2044: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2045: RAISE FND_API.G_EXC_ERROR;
2046: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2048: END IF;

Line 2045: RAISE FND_API.G_EXC_ERROR;

2041:
2042: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2043:
2044: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2045: RAISE FND_API.G_EXC_ERROR;
2046: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2048: END IF;
2049:

Line 2046: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

2042: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2043:
2044: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2045: RAISE FND_API.G_EXC_ERROR;
2046: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2048: END IF;
2049:
2050: END IF;

Line 2047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2043:
2044: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2045: RAISE FND_API.G_EXC_ERROR;
2046: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2048: END IF;
2049:
2050: END IF;
2051:

Line 2054: IF fnd_api.to_boolean(p_commit) THEN

2050: END IF;
2051:
2052:
2053:
2054: IF fnd_api.to_boolean(p_commit) THEN
2055:
2056: COMMIT WORK;
2057:
2058: END IF;

Line 2066: WHEN fnd_api.g_exc_error THEN

2062:
2063:
2064: EXCEPTION
2065:
2066: WHEN fnd_api.g_exc_error THEN
2067: ROLLBACK TO update_resource_pub;
2068: x_return_status := fnd_api.g_ret_sts_error;
2069: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2070: p_data => x_msg_data);

Line 2068: x_return_status := fnd_api.g_ret_sts_error;

2064: EXCEPTION
2065:
2066: WHEN fnd_api.g_exc_error THEN
2067: ROLLBACK TO update_resource_pub;
2068: x_return_status := fnd_api.g_ret_sts_error;
2069: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2070: p_data => x_msg_data);
2071: WHEN fnd_api.g_exc_unexpected_error THEN
2072: ROLLBACK TO update_resource_pub;

Line 2071: WHEN fnd_api.g_exc_unexpected_error THEN

2067: ROLLBACK TO update_resource_pub;
2068: x_return_status := fnd_api.g_ret_sts_error;
2069: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2070: p_data => x_msg_data);
2071: WHEN fnd_api.g_exc_unexpected_error THEN
2072: ROLLBACK TO update_resource_pub;
2073: x_return_status := fnd_api.g_ret_sts_unexp_error;
2074: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2075: p_data => x_msg_data);

Line 2073: x_return_status := fnd_api.g_ret_sts_unexp_error;

2069: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2070: p_data => x_msg_data);
2071: WHEN fnd_api.g_exc_unexpected_error THEN
2072: ROLLBACK TO update_resource_pub;
2073: x_return_status := fnd_api.g_ret_sts_unexp_error;
2074: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2075: p_data => x_msg_data);
2076: WHEN OTHERS THEN
2077: ROLLBACK TO update_resource_pub;

Line 2083: x_return_status := fnd_api.g_ret_sts_unexp_error;

2079: fnd_message.set_token('P_SQLCODE',SQLCODE);
2080: fnd_message.set_token('P_SQLERRM',SQLERRM);
2081: fnd_message.set_token('P_API_NAME', l_api_name);
2082: FND_MSG_PUB.add;
2083: x_return_status := fnd_api.g_ret_sts_unexp_error;
2084: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2085: p_data => x_msg_data);
2086:
2087:

Line 2125: x_return_status := fnd_api.g_ret_sts_success;

2121:
2122: l_resource_id := p_resource_id;
2123:
2124: SAVEPOINT delete_resource_pub;
2125: x_return_status := fnd_api.g_ret_sts_success;
2126: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2127: RAISE fnd_api.g_exc_unexpected_error;
2128: END IF;
2129:

Line 2126: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

2122: l_resource_id := p_resource_id;
2123:
2124: SAVEPOINT delete_resource_pub;
2125: x_return_status := fnd_api.g_ret_sts_success;
2126: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2127: RAISE fnd_api.g_exc_unexpected_error;
2128: END IF;
2129:
2130: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2127: RAISE fnd_api.g_exc_unexpected_error;

2123:
2124: SAVEPOINT delete_resource_pub;
2125: x_return_status := fnd_api.g_ret_sts_success;
2126: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2127: RAISE fnd_api.g_exc_unexpected_error;
2128: END IF;
2129:
2130: IF fnd_api.to_boolean(p_init_msg_list) THEN
2131: fnd_msg_pub.initialize;

Line 2130: IF fnd_api.to_boolean(p_init_msg_list) THEN

2126: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2127: RAISE fnd_api.g_exc_unexpected_error;
2128: END IF;
2129:
2130: IF fnd_api.to_boolean(p_init_msg_list) THEN
2131: fnd_msg_pub.initialize;
2132: END IF;
2133:
2134:

Line 2139: RAISE fnd_api.g_exc_error;

2135: /* Validate the Resource. */
2136: IF l_resource_id IS NULL THEN
2137: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
2138: fnd_msg_pub.add;
2139: RAISE fnd_api.g_exc_error;
2140:
2141: END IF;
2142:
2143:

Line 2151: RAISE fnd_api.g_exc_error;

2147: IF res_cur%NOTFOUND THEN
2148: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
2149: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);
2150: fnd_msg_pub.add;
2151: RAISE fnd_api.g_exc_error;
2152:
2153: END IF;
2154: IF res_rec.category <> 'TBH'
2155: THEN

Line 2158: RAISE fnd_api.g_exc_error;

2154: IF res_rec.category <> 'TBH'
2155: THEN
2156: fnd_message.set_name('JTF', 'JTF_RS_NOT_TBH');
2157: fnd_msg_pub.add;
2158: RAISE fnd_api.g_exc_error;
2159: END IF;
2160: CLOSE res_cur;
2161:
2162: END IF;

Line 2170: P_INIT_MSG_LIST => fnd_api.g_false,

2166: /* Call the private procedure with the validated parameters. */
2167: --call private api for delete
2168: JTF_RS_RESOURCE_PVT.DELETE_RESOURCE(
2169: P_API_VERSION => 1.0,
2170: P_INIT_MSG_LIST => fnd_api.g_false,
2171: P_COMMIT => fnd_api.g_false,
2172: P_RESOURCE_ID => l_resource_id,
2173: X_RETURN_STATUS => x_return_status,
2174: X_MSG_COUNT => x_msg_count,

Line 2171: P_COMMIT => fnd_api.g_false,

2167: --call private api for delete
2168: JTF_RS_RESOURCE_PVT.DELETE_RESOURCE(
2169: P_API_VERSION => 1.0,
2170: P_INIT_MSG_LIST => fnd_api.g_false,
2171: P_COMMIT => fnd_api.g_false,
2172: P_RESOURCE_ID => l_resource_id,
2173: X_RETURN_STATUS => x_return_status,
2174: X_MSG_COUNT => x_msg_count,
2175: X_MSG_DATA => x_msg_data );

Line 2178: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2174: X_MSG_COUNT => x_msg_count,
2175: X_MSG_DATA => x_msg_data );
2176:
2177:
2178: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2179: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2180: RAISE FND_API.G_EXC_ERROR;
2181: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2179: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

2175: X_MSG_DATA => x_msg_data );
2176:
2177:
2178: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2179: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2180: RAISE FND_API.G_EXC_ERROR;
2181: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2183: END IF;

Line 2180: RAISE FND_API.G_EXC_ERROR;

2176:
2177:
2178: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2179: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2180: RAISE FND_API.G_EXC_ERROR;
2181: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2183: END IF;
2184: END IF;

Line 2181: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

2177:
2178: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2179: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2180: RAISE FND_API.G_EXC_ERROR;
2181: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2183: END IF;
2184: END IF;
2185:

Line 2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2178: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2179: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2180: RAISE FND_API.G_EXC_ERROR;
2181: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2183: END IF;
2184: END IF;
2185:
2186: IF fnd_api.to_boolean(p_commit) THEN

Line 2186: IF fnd_api.to_boolean(p_commit) THEN

2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2183: END IF;
2184: END IF;
2185:
2186: IF fnd_api.to_boolean(p_commit) THEN
2187: COMMIT WORK;
2188: END IF;
2189: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2190:

Line 2192: WHEN fnd_api.g_exc_error THEN

2188: END IF;
2189: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2190:
2191: EXCEPTION
2192: WHEN fnd_api.g_exc_error THEN
2193: ROLLBACK TO delete_resource_pub;
2194: x_return_status := fnd_api.g_ret_sts_error;
2195: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2196: p_data => x_msg_data);

Line 2194: x_return_status := fnd_api.g_ret_sts_error;

2190:
2191: EXCEPTION
2192: WHEN fnd_api.g_exc_error THEN
2193: ROLLBACK TO delete_resource_pub;
2194: x_return_status := fnd_api.g_ret_sts_error;
2195: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2196: p_data => x_msg_data);
2197: WHEN fnd_api.g_exc_unexpected_error THEN
2198: ROLLBACK TO delete_resource_pub;

Line 2197: WHEN fnd_api.g_exc_unexpected_error THEN

2193: ROLLBACK TO delete_resource_pub;
2194: x_return_status := fnd_api.g_ret_sts_error;
2195: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2196: p_data => x_msg_data);
2197: WHEN fnd_api.g_exc_unexpected_error THEN
2198: ROLLBACK TO delete_resource_pub;
2199: x_return_status := fnd_api.g_ret_sts_unexp_error;
2200: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2201: p_data => x_msg_data);

Line 2199: x_return_status := fnd_api.g_ret_sts_unexp_error;

2195: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2196: p_data => x_msg_data);
2197: WHEN fnd_api.g_exc_unexpected_error THEN
2198: ROLLBACK TO delete_resource_pub;
2199: x_return_status := fnd_api.g_ret_sts_unexp_error;
2200: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2201: p_data => x_msg_data);
2202: WHEN OTHERS THEN
2203: ROLLBACK TO delete_resource_pub;

Line 2209: x_return_status := fnd_api.g_ret_sts_unexp_error;

2205: fnd_message.set_token('P_SQLCODE',SQLCODE);
2206: fnd_message.set_token('P_SQLERRM',SQLERRM);
2207: fnd_message.set_token('P_API_NAME', l_api_name);
2208: FND_MSG_PUB.add;
2209: x_return_status := fnd_api.g_ret_sts_unexp_error;
2210: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2211: p_data => x_msg_data);
2212:
2213: END delete_resource;

Line 2602: x_return_status := fnd_api.g_ret_sts_success;

2598:
2599: --Standard Start of API SAVEPOINT
2600: SAVEPOINT CREATE_RESOURCE_SP;
2601:
2602: x_return_status := fnd_api.g_ret_sts_success;
2603:
2604: --Standard Call to check API compatibility
2605: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2606: THEN

Line 2605: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

2601:
2602: x_return_status := fnd_api.g_ret_sts_success;
2603:
2604: --Standard Call to check API compatibility
2605: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2606: THEN
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608: END IF;
2609:

Line 2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2603:
2604: --Standard Call to check API compatibility
2605: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2606: THEN
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608: END IF;
2609:
2610: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2611: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 2611: IF FND_API.To_boolean(P_INIT_MSG_LIST)

2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608: END IF;
2609:
2610: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2611: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2612: THEN
2613: FND_MSG_PUB.Initialize;
2614: END IF;
2615:

Line 2624: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2620: x_return_status => x_return_status
2621: );
2622:
2623:
2624: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2625:
2626: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2627: RAISE FND_API.G_EXC_ERROR;
2628: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2626: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

2622:
2623:
2624: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2625:
2626: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2627: RAISE FND_API.G_EXC_ERROR;
2628: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2630: END IF;

Line 2627: RAISE FND_API.G_EXC_ERROR;

2623:
2624: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2625:
2626: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2627: RAISE FND_API.G_EXC_ERROR;
2628: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2630: END IF;
2631:

Line 2628: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

2624: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2625:
2626: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2627: RAISE FND_API.G_EXC_ERROR;
2628: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2630: END IF;
2631:
2632: END IF;

Line 2629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2625:
2626: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2627: RAISE FND_API.G_EXC_ERROR;
2628: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2630: END IF;
2631:
2632: END IF;
2633:

Line 2644: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2640: p_address_id => l_address_id,
2641: x_return_status => x_return_status
2642: );
2643:
2644: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2645: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2646: RAISE FND_API.G_EXC_ERROR;
2647: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2645: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

2641: x_return_status => x_return_status
2642: );
2643:
2644: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2645: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2646: RAISE FND_API.G_EXC_ERROR;
2647: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2649: END IF;

Line 2646: RAISE FND_API.G_EXC_ERROR;

2642: );
2643:
2644: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2645: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2646: RAISE FND_API.G_EXC_ERROR;
2647: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2649: END IF;
2650:

Line 2647: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

2643:
2644: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2645: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2646: RAISE FND_API.G_EXC_ERROR;
2647: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2649: END IF;
2650:
2651: END IF;

Line 2648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2644: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2645: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2646: RAISE FND_API.G_EXC_ERROR;
2647: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2649: END IF;
2650:
2651: END IF;
2652:

Line 2670: RAISE fnd_api.g_exc_error;

2666:
2667: fnd_message.set_name('JTF', 'JTF_RS_OTHER_IDS_NOT_NULL');
2668: fnd_msg_pub.add;
2669:
2670: RAISE fnd_api.g_exc_error;
2671:
2672: END IF;
2673:
2674: END IF;

Line 2686: RAISE fnd_api.g_exc_error;

2682: IF (l_source_id IS NULL) THEN
2683: -- dbms_output.put_line('For PARTNER category, source_id should not be null');
2684: fnd_message.set_name('JTF', 'JTF_RS_PARTNER_IDS_NULL');
2685: fnd_msg_pub.add;
2686: RAISE fnd_api.g_exc_error;
2687:
2688: ELSE
2689: OPEN c_validate_partner(l_source_id);
2690: FETCH c_validate_partner INTO l_check_flag;

Line 2695: RAISE fnd_api.g_exc_error;

2691: IF c_validate_partner%NOTFOUND THEN
2692: -- dbms_output.put_line('Partner does not exist for the passed source_id');
2693: fnd_message.set_name('JTF', 'JTF_RS_INVALID_PARTNER_IDS');
2694: fnd_msg_pub.add;
2695: RAISE fnd_api.g_exc_error;
2696:
2697: END IF;
2698: CLOSE c_validate_partner;
2699: END IF;

Line 2711: RAISE fnd_api.g_exc_error;

2707: -- dbms_output.put_line('Invalid Partner Address Id');
2708: fnd_message.set_name('JTF', 'JTF_RS_ERR_PARTNER_ADDRESS_ID');
2709: fnd_message.set_token('P_ADDRESS_ID', l_address_id);
2710: fnd_msg_pub.add;
2711: RAISE fnd_api.g_exc_error;
2712:
2713: END IF;
2714: CLOSE c_validate_partner_address;
2715: END IF;

Line 2728: RAISE fnd_api.g_exc_error;

2724: -- dbms_output.put_line('Invalid Partner Contact Id');
2725: fnd_message.set_name('JTF', 'JTF_RS_ERR_PARTNER_CONTACT_ID');
2726: fnd_message.set_token('P_CONTACT_ID', l_contact_id);
2727: fnd_msg_pub.add;
2728: RAISE fnd_api.g_exc_error;
2729:
2730: END IF;
2731: CLOSE c_validate_partner_contact;
2732: END IF;

Line 2747: RAISE fnd_api.g_exc_error;

2743: IF l_source_id IS NULL THEN
2744: -- dbms_output.put_line('Source Id should not be Null');
2745: fnd_message.set_name('JTF', 'JTF_RS_SOURCE_ID_NULL');
2746: fnd_msg_pub.add;
2747: RAISE fnd_api.g_exc_error;
2748:
2749: END IF;
2750:
2751: jtf_resource_utl.check_object_existence_migr(

Line 2761: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2757: X_FOUND => l_found,
2758: X_RETURN_STATUS => x_return_status
2759: );
2760:
2761: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2762:
2763: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2764: RAISE FND_API.G_EXC_ERROR;
2765: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2763: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

2759: );
2760:
2761: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2762:
2763: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2764: RAISE FND_API.G_EXC_ERROR;
2765: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2767: END IF;

Line 2764: RAISE FND_API.G_EXC_ERROR;

2760:
2761: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2762:
2763: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2764: RAISE FND_API.G_EXC_ERROR;
2765: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2767: END IF;
2768:

Line 2765: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

2761: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2762:
2763: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2764: RAISE FND_API.G_EXC_ERROR;
2765: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2767: END IF;
2768:
2769: END IF;

Line 2766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2762:
2763: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2764: RAISE FND_API.G_EXC_ERROR;
2765: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2767: END IF;
2768:
2769: END IF;
2770:

Line 2780: RAISE fnd_api.g_exc_error;

2776: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SOURCE_ID');
2777: fnd_message.set_token('P_SOURCE_ID', l_source_id);
2778: fnd_msg_pub.add;
2779:
2780: RAISE fnd_api.g_exc_error;
2781:
2782:
2783: END IF;
2784:

Line 2797: RAISE fnd_api.g_exc_error;

2793: -- First check is null check for source id
2794: IF l_source_id IS NULL THEN
2795: fnd_message.set_name('JTF', 'JTF_RS_SOURCE_ID_NULL');
2796: fnd_msg_pub.add;
2797: RAISE fnd_api.g_exc_error;
2798: END IF;
2799:
2800: open c_emp_exist(l_source_id);
2801: fetch c_emp_exist into r_emp_exist;

Line 2809: RAISE fnd_api.g_exc_error;

2805: then
2806: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SOURCE_ID');
2807: fnd_message.set_token('P_SOURCE_ID', l_source_id);
2808: fnd_msg_pub.add;
2809: RAISE fnd_api.g_exc_error;
2810: end if;
2811:
2812: END IF; -- end of check l_category = 'EMPLOYEE'
2813:

Line 2835: RAISE fnd_api.g_exc_error;

2831: fnd_message.set_name('JTF', 'JTF_RS_INVALID_PARTY_ADDRESS');
2832: fnd_message.set_token('P_ADDRESS_ID', l_address_id);
2833: fnd_msg_pub.add;
2834:
2835: RAISE fnd_api.g_exc_error;
2836:
2837:
2838: END IF;
2839:

Line 2865: RAISE fnd_api.g_exc_error;

2861: fnd_message.set_name('JTF', 'JTF_RS_ERR_PARTY_CONTACT_ID');
2862: fnd_message.set_token('P_CONTACT_ID', l_contact_id);
2863: fnd_msg_pub.add;
2864:
2865: RAISE fnd_api.g_exc_error;
2866:
2867: END IF;
2868:
2869:

Line 2895: RAISE fnd_api.g_exc_error;

2891:
2892: fnd_message.set_name('JTF', 'JTF_RS_SC_IDS_NOT_NULL');
2893: fnd_msg_pub.add;
2894:
2895: RAISE fnd_api.g_exc_error;
2896:
2897: END IF;
2898:
2899: END IF;

Line 2917: RAISE fnd_api.g_exc_error;

2913:
2914: fnd_message.set_name('JTF', 'JTF_RS_EMP_IDS_NOT_NULL');
2915: fnd_msg_pub.add;
2916:
2917: RAISE fnd_api.g_exc_error;
2918:
2919:
2920: END IF;
2921:

Line 2938: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2934:
2935: -- added for NOCOPY
2936: l_managing_emp_id := l_managing_emp_id_out;
2937:
2938: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2939:
2940: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2941: RAISE FND_API.G_EXC_ERROR;
2942: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2940: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

2936: l_managing_emp_id := l_managing_emp_id_out;
2937:
2938: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2939:
2940: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2941: RAISE FND_API.G_EXC_ERROR;
2942: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: END IF;

Line 2941: RAISE FND_API.G_EXC_ERROR;

2937:
2938: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2939:
2940: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2941: RAISE FND_API.G_EXC_ERROR;
2942: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: END IF;
2945:

Line 2942: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

2938: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2939:
2940: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2941: RAISE FND_API.G_EXC_ERROR;
2942: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: END IF;
2945:
2946: END IF;

Line 2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2939:
2940: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2941: RAISE FND_API.G_EXC_ERROR;
2942: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: END IF;
2945:
2946: END IF;
2947:

Line 2959: RAISE fnd_api.g_exc_error;

2955:
2956: fnd_message.set_name('JTF', 'JTF_RS_START_DATE_NULL');
2957: fnd_msg_pub.add;
2958:
2959: RAISE fnd_api.g_exc_error;
2960:
2961:
2962: END IF;
2963:

Line 2975: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2971: p_time_zone_id => l_time_zone,
2972: x_return_status => x_return_status
2973: );
2974:
2975: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2976:
2977: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2978: RAISE FND_API.G_EXC_ERROR;
2979: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2977: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

2973: );
2974:
2975: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2976:
2977: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2978: RAISE FND_API.G_EXC_ERROR;
2979: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2981: END IF;

Line 2978: RAISE FND_API.G_EXC_ERROR;

2974:
2975: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2976:
2977: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2978: RAISE FND_API.G_EXC_ERROR;
2979: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2981: END IF;
2982:

Line 2979: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

2975: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2976:
2977: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2978: RAISE FND_API.G_EXC_ERROR;
2979: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2981: END IF;
2982:
2983: END IF;

Line 2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2976:
2977: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2978: RAISE FND_API.G_EXC_ERROR;
2979: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2981: END IF;
2982:
2983: END IF;
2984:

Line 2998: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2994: p_nls_language => l_primary_language,
2995: x_return_status => x_return_status
2996: );
2997:
2998: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2999:
3000: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3001: RAISE FND_API.G_EXC_ERROR;
3002: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3000: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

2996: );
2997:
2998: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2999:
3000: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3001: RAISE FND_API.G_EXC_ERROR;
3002: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: END IF;

Line 3001: RAISE FND_API.G_EXC_ERROR;

2997:
2998: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2999:
3000: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3001: RAISE FND_API.G_EXC_ERROR;
3002: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: END IF;
3005:

Line 3002: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

2998: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2999:
3000: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3001: RAISE FND_API.G_EXC_ERROR;
3002: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: END IF;
3005:
3006: END IF;

Line 3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2999:
3000: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3001: RAISE FND_API.G_EXC_ERROR;
3002: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: END IF;
3005:
3006: END IF;
3007:

Line 3021: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3017: p_nls_language => l_secondary_language,
3018: x_return_status => x_return_status
3019: );
3020:
3021: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3022:
3023: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3024: RAISE FND_API.G_EXC_ERROR;
3025: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3023: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

3019: );
3020:
3021: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3022:
3023: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3024: RAISE FND_API.G_EXC_ERROR;
3025: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3027: END IF;

Line 3024: RAISE FND_API.G_EXC_ERROR;

3020:
3021: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3022:
3023: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3024: RAISE FND_API.G_EXC_ERROR;
3025: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3027: END IF;
3028:

Line 3025: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

3021: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3022:
3023: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3024: RAISE FND_API.G_EXC_ERROR;
3025: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3027: END IF;
3028:
3029: END IF;

Line 3026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3022:
3023: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3024: RAISE FND_API.G_EXC_ERROR;
3025: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3027: END IF;
3028:
3029: END IF;
3030:

Line 3044: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3040: p_support_site_id => l_support_site_id,
3041: x_return_status => x_return_status
3042: );
3043:
3044: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3045:
3046: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3047: RAISE FND_API.G_EXC_ERROR;
3048: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3046: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

3042: );
3043:
3044: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3045:
3046: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3047: RAISE FND_API.G_EXC_ERROR;
3048: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3050: END IF;

Line 3047: RAISE FND_API.G_EXC_ERROR;

3043:
3044: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3045:
3046: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3047: RAISE FND_API.G_EXC_ERROR;
3048: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3050: END IF;
3051:

Line 3048: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

3044: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3045:
3046: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3047: RAISE FND_API.G_EXC_ERROR;
3048: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3050: END IF;
3051:
3052: END IF;

Line 3049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3045:
3046: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3047: RAISE FND_API.G_EXC_ERROR;
3048: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3050: END IF;
3051:
3052: END IF;
3053:

Line 3069: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3065: );
3066: -- added for NOCOPY
3067: l_server_group_id := l_server_group_id_out;
3068:
3069: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3070:
3071: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3072: RAISE FND_API.G_EXC_ERROR;
3073: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3071: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

3067: l_server_group_id := l_server_group_id_out;
3068:
3069: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3070:
3071: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3072: RAISE FND_API.G_EXC_ERROR;
3073: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3075: END IF;

Line 3072: RAISE FND_API.G_EXC_ERROR;

3068:
3069: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3070:
3071: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3072: RAISE FND_API.G_EXC_ERROR;
3073: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3075: END IF;
3076:

Line 3073: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

3069: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3070:
3071: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3072: RAISE FND_API.G_EXC_ERROR;
3073: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3075: END IF;
3076:
3077: END IF;

Line 3074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3070:
3071: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3072: RAISE FND_API.G_EXC_ERROR;
3073: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3075: END IF;
3076:
3077: END IF;
3078:

Line 3098: RAISE fnd_api.g_exc_error;

3094: fnd_message.set_name('JTF', 'JTF_RS_ERR_ASSIGN_TO_GRP_ID');
3095: fnd_message.set_token('P_ASSIGNED_TO_GROUP_ID', l_assigned_to_group_id);
3096: fnd_msg_pub.add;
3097:
3098: RAISE fnd_api.g_exc_error;
3099:
3100:
3101: END IF;
3102:

Line 3121: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3117: p_currency_code => l_comp_currency_code,
3118: x_return_status => x_return_status
3119: );
3120:
3121: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3122:
3123: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3124: RAISE FND_API.G_EXC_ERROR;
3125: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3123: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

3119: );
3120:
3121: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3122:
3123: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3124: RAISE FND_API.G_EXC_ERROR;
3125: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3127: END IF;

Line 3124: RAISE FND_API.G_EXC_ERROR;

3120:
3121: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3122:
3123: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3124: RAISE FND_API.G_EXC_ERROR;
3125: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3127: END IF;
3128:

Line 3125: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

3121: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3122:
3123: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3124: RAISE FND_API.G_EXC_ERROR;
3125: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3127: END IF;
3128:
3129: END IF;

Line 3126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3122:
3123: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3124: RAISE FND_API.G_EXC_ERROR;
3125: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3127: END IF;
3128:
3129: END IF;
3130:

Line 3143: RAISE fnd_api.g_exc_error;

3139:
3140: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
3141: fnd_msg_pub.add;
3142:
3143: RAISE fnd_api.g_exc_error;
3144:
3145:
3146: END IF;
3147:

Line 3158: RAISE fnd_api.g_exc_error;

3154:
3155: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
3156: fnd_msg_pub.add;
3157:
3158: RAISE fnd_api.g_exc_error;
3159:
3160:
3161: END IF;
3162:

Line 3174: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3170: p_hold_reason_code => l_hold_reason_code,
3171: x_return_status => x_return_status
3172: );
3173:
3174: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3175:
3176: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3177: RAISE FND_API.G_EXC_ERROR;
3178: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3176: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

3172: );
3173:
3174: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3175:
3176: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3177: RAISE FND_API.G_EXC_ERROR;
3178: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3180: END IF;

Line 3177: RAISE FND_API.G_EXC_ERROR;

3173:
3174: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3175:
3176: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3177: RAISE FND_API.G_EXC_ERROR;
3178: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3180: END IF;
3181:

Line 3178: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

3174: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3175:
3176: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3177: RAISE FND_API.G_EXC_ERROR;
3178: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3180: END IF;
3181:
3182: END IF;

Line 3179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3175:
3176: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3177: RAISE FND_API.G_EXC_ERROR;
3178: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3180: END IF;
3181:
3182: END IF;
3183:

Line 3197: RAISE fnd_api.g_exc_error;

3193:
3194: fnd_message.set_name('JTF', 'JTF_RS_USERID_ERROR');
3195: fnd_msg_pub.add;
3196:
3197: RAISE fnd_api.g_exc_error;
3198:
3199:
3200: END IF;
3201:

Line 3215: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3211: p_source_id => l_source_id,
3212: x_return_status => x_return_status
3213: );
3214:
3215: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3216:
3217: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3218: RAISE FND_API.G_EXC_ERROR;
3219: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3217: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

3213: );
3214:
3215: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3216:
3217: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3218: RAISE FND_API.G_EXC_ERROR;
3219: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3221: END IF;

Line 3218: RAISE FND_API.G_EXC_ERROR;

3214:
3215: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3216:
3217: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3218: RAISE FND_API.G_EXC_ERROR;
3219: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3221: END IF;
3222: else

Line 3219: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

3215: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3216:
3217: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3218: RAISE FND_API.G_EXC_ERROR;
3219: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3221: END IF;
3222: else
3223:

Line 3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3216:
3217: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3218: RAISE FND_API.G_EXC_ERROR;
3219: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3221: END IF;
3222: else
3223:
3224: OPEN c_validate_user_id(l_user_id);

Line 3237: RAISE fnd_api.g_exc_error;

3233: fnd_message.set_name('JTF', 'JTF_RS_ERR_DUPLICATE_USER_ID');
3234: fnd_message.set_token('P_USER_ID', l_user_id);
3235: fnd_msg_pub.add;
3236:
3237: RAISE fnd_api.g_exc_error;
3238:
3239:
3240: END IF;
3241:

Line 3269: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3265: );
3266: -- added for NOCOPY
3267: l_comp_service_team_id := l_comp_service_team_id_out;
3268:
3269: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3270:
3271: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3272: RAISE FND_API.G_EXC_ERROR;
3273: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3271: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

3267: l_comp_service_team_id := l_comp_service_team_id_out;
3268:
3269: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3270:
3271: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3272: RAISE FND_API.G_EXC_ERROR;
3273: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3275: END IF;

Line 3272: RAISE FND_API.G_EXC_ERROR;

3268:
3269: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3270:
3271: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3272: RAISE FND_API.G_EXC_ERROR;
3273: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3275: END IF;
3276:

Line 3273: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

3269: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3270:
3271: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3272: RAISE FND_API.G_EXC_ERROR;
3273: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3275: END IF;
3276:
3277: END IF;

Line 3274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3270:
3271: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3272: RAISE FND_API.G_EXC_ERROR;
3273: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3275: END IF;
3276:
3277: END IF;
3278:

Line 3290: P_INIT_MSG_LIST => fnd_api.g_false,

3286:
3287: /* Call the private procedure with the validated parameters. */
3288: jtf_rs_resource_pvt.create_resource (
3289: P_API_VERSION => 1,
3290: P_INIT_MSG_LIST => fnd_api.g_false,
3291: P_COMMIT => fnd_api.g_false,
3292: P_CATEGORY => l_category,
3293: P_SOURCE_ID => l_source_id,
3294: P_ADDRESS_ID => l_address_id,

Line 3291: P_COMMIT => fnd_api.g_false,

3287: /* Call the private procedure with the validated parameters. */
3288: jtf_rs_resource_pvt.create_resource (
3289: P_API_VERSION => 1,
3290: P_INIT_MSG_LIST => fnd_api.g_false,
3291: P_COMMIT => fnd_api.g_false,
3292: P_CATEGORY => l_category,
3293: P_SOURCE_ID => l_source_id,
3294: P_ADDRESS_ID => l_address_id,
3295: P_CONTACT_ID => l_contact_id,

Line 3376: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3372: );
3373:
3374:
3375:
3376: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3377: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3378: RAISE FND_API.G_EXC_ERROR;
3379: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3377: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

3373:
3374:
3375:
3376: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3377: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3378: RAISE FND_API.G_EXC_ERROR;
3379: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3381: END IF;

Line 3378: RAISE FND_API.G_EXC_ERROR;

3374:
3375:
3376: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3377: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3378: RAISE FND_API.G_EXC_ERROR;
3379: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3381: END IF;
3382: END IF;

Line 3379: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

3375:
3376: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3377: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3378: RAISE FND_API.G_EXC_ERROR;
3379: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3381: END IF;
3382: END IF;
3383:

Line 3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3376: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3377: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3378: RAISE FND_API.G_EXC_ERROR;
3379: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3381: END IF;
3382: END IF;
3383:
3384: ELSE

Line 3392: P_INIT_MSG_LIST => fnd_api.g_false,

3388: /* Call the private procedure for Migration. */
3389:
3390: jtf_rs_resource_pvt.create_resource_migrate (
3391: P_API_VERSION => 1,
3392: P_INIT_MSG_LIST => fnd_api.g_false,
3393: P_COMMIT => fnd_api.g_false,
3394: P_CATEGORY => l_category,
3395: P_SOURCE_ID => l_source_id,
3396: P_ADDRESS_ID => l_address_id,

Line 3393: P_COMMIT => fnd_api.g_false,

3389:
3390: jtf_rs_resource_pvt.create_resource_migrate (
3391: P_API_VERSION => 1,
3392: P_INIT_MSG_LIST => fnd_api.g_false,
3393: P_COMMIT => fnd_api.g_false,
3394: P_CATEGORY => l_category,
3395: P_SOURCE_ID => l_source_id,
3396: P_ADDRESS_ID => l_address_id,
3397: P_CONTACT_ID => l_contact_id,

Line 3442: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3438: X_MSG_DATA => x_msg_data,
3439: X_RESOURCE_ID => x_resource_id,
3440: X_RESOURCE_NUMBER => x_resource_number
3441: );
3442: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3443: -- dbms_output.put_line('Failed status from call to private procedure');
3444: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3445: RAISE FND_API.G_EXC_ERROR;
3446: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3444: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

3440: X_RESOURCE_NUMBER => x_resource_number
3441: );
3442: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3443: -- dbms_output.put_line('Failed status from call to private procedure');
3444: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3445: RAISE FND_API.G_EXC_ERROR;
3446: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3448: END IF;

Line 3445: RAISE FND_API.G_EXC_ERROR;

3441: );
3442: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3443: -- dbms_output.put_line('Failed status from call to private procedure');
3444: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3445: RAISE FND_API.G_EXC_ERROR;
3446: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3448: END IF;
3449: END IF;

Line 3446: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

3442: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3443: -- dbms_output.put_line('Failed status from call to private procedure');
3444: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3445: RAISE FND_API.G_EXC_ERROR;
3446: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3448: END IF;
3449: END IF;
3450:

Line 3447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3443: -- dbms_output.put_line('Failed status from call to private procedure');
3444: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3445: RAISE FND_API.G_EXC_ERROR;
3446: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3448: END IF;
3449: END IF;
3450:
3451: END IF;

Line 3453: IF (x_return_status <> fnd_api.g_ret_sts_success)

3449: END IF;
3450:
3451: END IF;
3452:
3453: IF (x_return_status <> fnd_api.g_ret_sts_success)
3454: THEN
3455: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3456: RAISE FND_API.G_EXC_ERROR;
3457: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3455: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

3451: END IF;
3452:
3453: IF (x_return_status <> fnd_api.g_ret_sts_success)
3454: THEN
3455: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3456: RAISE FND_API.G_EXC_ERROR;
3457: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3459: END IF;

Line 3456: RAISE FND_API.G_EXC_ERROR;

3452:
3453: IF (x_return_status <> fnd_api.g_ret_sts_success)
3454: THEN
3455: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3456: RAISE FND_API.G_EXC_ERROR;
3457: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3459: END IF;
3460: END IF;

Line 3457: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

3453: IF (x_return_status <> fnd_api.g_ret_sts_success)
3454: THEN
3455: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3456: RAISE FND_API.G_EXC_ERROR;
3457: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3459: END IF;
3460: END IF;
3461:

Line 3458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3454: THEN
3455: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3456: RAISE FND_API.G_EXC_ERROR;
3457: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3459: END IF;
3460: END IF;
3461:
3462: IF fnd_api.to_boolean (p_commit)

Line 3462: IF fnd_api.to_boolean (p_commit)

3458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3459: END IF;
3460: END IF;
3461:
3462: IF fnd_api.to_boolean (p_commit)
3463: THEN
3464: COMMIT WORK;
3465: END IF;
3466:

Line 3471: WHEN fnd_api.g_exc_error THEN

3467:
3468: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3469:
3470: EXCEPTION
3471: WHEN fnd_api.g_exc_error THEN
3472: ROLLBACK TO create_resource_sp;
3473: x_return_status := fnd_api.g_ret_sts_error;
3474: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3475: p_data => x_msg_data);

Line 3473: x_return_status := fnd_api.g_ret_sts_error;

3469:
3470: EXCEPTION
3471: WHEN fnd_api.g_exc_error THEN
3472: ROLLBACK TO create_resource_sp;
3473: x_return_status := fnd_api.g_ret_sts_error;
3474: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3475: p_data => x_msg_data);
3476: WHEN fnd_api.g_exc_unexpected_error THEN
3477: ROLLBACK TO create_resource_sp;

Line 3476: WHEN fnd_api.g_exc_unexpected_error THEN

3472: ROLLBACK TO create_resource_sp;
3473: x_return_status := fnd_api.g_ret_sts_error;
3474: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3475: p_data => x_msg_data);
3476: WHEN fnd_api.g_exc_unexpected_error THEN
3477: ROLLBACK TO create_resource_sp;
3478: x_return_status := fnd_api.g_ret_sts_unexp_error;
3479: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3480: p_data => x_msg_data);

Line 3478: x_return_status := fnd_api.g_ret_sts_unexp_error;

3474: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3475: p_data => x_msg_data);
3476: WHEN fnd_api.g_exc_unexpected_error THEN
3477: ROLLBACK TO create_resource_sp;
3478: x_return_status := fnd_api.g_ret_sts_unexp_error;
3479: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3480: p_data => x_msg_data);
3481: WHEN OTHERS THEN
3482: ROLLBACK TO create_resource_sp;

Line 3488: x_return_status := fnd_api.g_ret_sts_unexp_error;

3484: fnd_message.set_token('P_SQLCODE',SQLCODE);
3485: fnd_message.set_token('P_SQLERRM',SQLERRM);
3486: fnd_message.set_token('P_API_NAME', l_api_name);
3487: FND_MSG_PUB.add;
3488: x_return_status := fnd_api.g_ret_sts_unexp_error;
3489: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3490: p_data => x_msg_data);
3491:
3492: END;