DBA Data[Home] [Help]

APPS.IGS_EN_SUSA_LGCY_PUB dependencies on FND_API

Line 644: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version,

640: -- Create a savepoint
641: SAVEPOINT create_susa_pub;
642:
643: -- Check for the Compatible API call
644: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version,
645: p_api_version,
646: l_api_name,
647: g_pkg_name) THEN
648:

Line 649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

645: p_api_version,
646: l_api_name,
647: g_pkg_name) THEN
648:
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
651:
652: -- If the calling program has passed the parameter for initializing the message list
653: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

Line 653: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
651:
652: -- If the calling program has passed the parameter for initializing the message list
653: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
654: FND_MSG_PUB.INITIALIZE;
655: END IF;
656:
657: -- Set the return status to success

Line 658: x_return_status := FND_API.G_RET_STS_SUCCESS;

654: FND_MSG_PUB.INITIALIZE;
655: END IF;
656:
657: -- Set the return status to success
658: x_return_status := FND_API.G_RET_STS_SUCCESS;
659:
660:
661:
662: -- Validate input paramaters ---------

Line 665: x_return_status := FND_API.G_RET_STS_ERROR;

661:
662: -- Validate input paramaters ---------
663:
664: IF NOT validate_parameters(p_susa_rec => p_susa_rec) THEN
665: x_return_status := FND_API.G_RET_STS_ERROR;
666: l_insert_flag := FALSE;
667: END IF;
668:
669:

Line 680: x_return_status := FND_API.G_RET_STS_ERROR;

676: IF l_person_id IS NULL THEN
677: -- Add excep to stack
678: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_PERSON_NUMBER');
679: FND_MSG_PUB.ADD;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: l_insert_flag := FALSE;
682: END IF;
683: END IF;
684:

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

695: IF l_us_version_number IS NULL OR l_parent_seq_number IS NULL THEN
696: -- Add excep to stack
697: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_PAR_UNIT_SET_CD');
698: FND_MSG_PUB.ADD;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: l_insert_flag := FALSE;
701: END IF;
702: END IF;
703: END IF;

Line 720: x_return_status := FND_API.G_RET_STS_ERROR;

716: IF l_cal_return_status = 'INVALID' THEN
717: -- Add excep to stack
718: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_ACAD_TERM_CAL');
719: FND_MSG_PUB.ADD;
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: l_insert_flag := FALSE;
722: ELSIF l_cal_return_status = 'MULTIPLE' THEN
723: -- Add excep to stack
724: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MORE_CAL_FOUND');

Line 726: x_return_status := FND_API.G_RET_STS_ERROR;

722: ELSIF l_cal_return_status = 'MULTIPLE' THEN
723: -- Add excep to stack
724: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MORE_CAL_FOUND');
725: FND_MSG_PUB.ADD;
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: l_insert_flag := FALSE;
728: END IF;
729: END IF;
730:

Line 740: x_return_status := FND_API.G_RET_STS_ERROR;

736: IF l_auth_person_id IS NULL THEN
737: -- Add excep to stack
738: FND_MESSAGE.SET_NAME('IGS','IGS_EN_AUTH_PERS_NOTEXIST');
739: FND_MSG_PUB.ADD;
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: l_insert_flag := FALSE;
742: END IF;
743: END IF;
744:

Line 753: x_return_status := FND_API.G_RET_STS_ERROR;

749: p_parent_seq_number => l_parent_seq_number,
750: p_susa_rec => p_susa_rec);
751:
752: IF l_ret_val = 'E' THEN
753: x_return_status := FND_API.G_RET_STS_ERROR;
754: l_insert_flag := FALSE;
755: ELSIF l_ret_val = 'W' THEN
756: x_return_status := 'W';
757: l_insert_flag := FALSE;

Line 771: x_return_status := FND_API.G_RET_STS_ERROR;

767: p_sequence_number => 0,
768: p_parent_seq_number => l_parent_seq_number,
769: p_auth_person_id => l_auth_person_id,
770: p_susa_rec => p_susa_rec) THEN
771: x_return_status := FND_API.G_RET_STS_ERROR;
772: l_insert_flag := FALSE;
773: END IF;
774: END IF;
775:

Line 930: IF ( (FND_API.TO_BOOLEAN(p_commit)) AND (l_insert_flag) ) THEN

926:
927:
928: -- If the calling program has passed the parameter for committing the data and there
929: -- have been no validation failures, then commit the work
930: IF ( (FND_API.TO_BOOLEAN(p_commit)) AND (l_insert_flag) ) THEN
931: COMMIT WORK;
932: END IF;
933:
934:

Line 940: WHEN FND_API.G_EXC_ERROR THEN

936: p_data => x_msg_data);
937:
938:
939: EXCEPTION
940: WHEN FND_API.G_EXC_ERROR THEN
941: ROLLBACK TO create_susa_pub;
942: x_return_status := FND_API.G_RET_STS_ERROR;
943: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
944: p_data => x_msg_data);

Line 942: x_return_status := FND_API.G_RET_STS_ERROR;

938:
939: EXCEPTION
940: WHEN FND_API.G_EXC_ERROR THEN
941: ROLLBACK TO create_susa_pub;
942: x_return_status := FND_API.G_RET_STS_ERROR;
943: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
944: p_data => x_msg_data);
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: ROLLBACK TO create_susa_pub;

Line 945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

941: ROLLBACK TO create_susa_pub;
942: x_return_status := FND_API.G_RET_STS_ERROR;
943: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
944: p_data => x_msg_data);
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: ROLLBACK TO create_susa_pub;
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
949: p_data => x_msg_data);

Line 947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

943: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
944: p_data => x_msg_data);
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: ROLLBACK TO create_susa_pub;
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
949: p_data => x_msg_data);
950: WHEN OTHERS THEN
951: ROLLBACK TO create_susa_pub;

Line 952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

948: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
949: p_data => x_msg_data);
950: WHEN OTHERS THEN
951: ROLLBACK TO create_susa_pub;
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
954: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
955: l_api_name);
956: END IF;