DBA Data[Home] [Help]

APPS.IGS_HE_SUSA_LGCY_PUB dependencies on FND_API

Line 678: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version,

674: -- Create a savepoint
675: SAVEPOINT create_hesa_susa_pub;
676:
677: -- Check for the Compatible API call
678: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version,
679: p_api_version,
680: l_api_name,
681: g_pkg_name) THEN
682:

Line 683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

679: p_api_version,
680: l_api_name,
681: g_pkg_name) THEN
682:
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: END IF;
685:
686: -- If the calling program has passed the parameter for initializing the message list
687: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

Line 687: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: END IF;
685:
686: -- If the calling program has passed the parameter for initializing the message list
687: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
688: FND_MSG_PUB.INITIALIZE;
689: END IF;
690:
691: -- Set the return status to success

Line 692: x_return_status := FND_API.G_RET_STS_SUCCESS;

688: FND_MSG_PUB.INITIALIZE;
689: END IF;
690:
691: -- Set the return status to success
692: x_return_status := FND_API.G_RET_STS_SUCCESS;
693:
694:
695: -- Check whether the country profile value is GB
696: IF NVL(FND_PROFILE.VALUE('OSS_COUNTRY_CODE'),'NONE') <> 'GB' THEN

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

695: -- Check whether the country profile value is GB
696: IF NVL(FND_PROFILE.VALUE('OSS_COUNTRY_CODE'),'NONE') <> 'GB' THEN
697: FND_MESSAGE.SET_NAME ('IGS','IGS_UC_HE_NOT_ENABLED');
698: FND_MSG_PUB.ADD;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: l_insert_flag := FALSE;
701: END IF;
702:
703:

Line 707: x_return_status := FND_API.G_RET_STS_ERROR;

703:
704: -- // Validate input paramaters ---------
705: IF l_insert_flag THEN
706: IF NOT validate_parameters(p_hesa_susa_rec) THEN
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: l_insert_flag := FALSE;
709: END IF;
710: END IF;
711:

Line 723: x_return_status := FND_API.G_RET_STS_ERROR;

719: IF l_person_id IS NULL THEN
720: -- ADD excep to stack
721: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_PERSON_NUMBER');
722: FND_MSG_PUB.ADD;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: l_insert_flag := FALSE;
725: END IF;
726: END IF;
727:

Line 740: x_return_status := FND_API.G_RET_STS_ERROR;

736: IF l_us_version_number IS NULL OR l_sequence_number IS NULL THEN
737: -- ADD excep to stack
738: FND_MESSAGE.SET_NAME('IGS','IGS_HE_SUSA_REC_NEX');
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_sequence_number => l_sequence_number,
750: p_hesa_susa_rec => p_hesa_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 766: x_return_status := FND_API.G_RET_STS_ERROR;

762: -- Business validation
763: IF l_insert_flag THEN
764: IF NOT validate_hesa_susa (p_us_version_number => l_us_version_number,
765: p_hesa_susa_rec => p_hesa_susa_rec) THEN
766: x_return_status := FND_API.G_RET_STS_ERROR;
767: l_insert_flag := FALSE;
768: END IF;
769: END IF;
770:

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

922:
923:
924: -- If the calling program has passed the parameter for committing the data and there
925: -- have been no errors in calling the balances process, then commit the work
926: IF ( (FND_API.TO_BOOLEAN(p_commit)) AND (l_insert_flag) ) THEN
927: COMMIT WORK;
928: END IF;
929:
930:

Line 936: WHEN FND_API.G_EXC_ERROR THEN

932: p_data => x_msg_data);
933:
934:
935: EXCEPTION
936: WHEN FND_API.G_EXC_ERROR THEN
937: ROLLBACK TO create_hesa_susa_pub;
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
940: p_data => x_msg_data);

Line 938: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

939: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
940: p_data => x_msg_data);
941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
942: ROLLBACK TO create_hesa_susa_pub;
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
944: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
945: p_data => x_msg_data);
946: WHEN OTHERS THEN
947: ROLLBACK TO create_hesa_susa_pub;

Line 948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

944: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
945: p_data => x_msg_data);
946: WHEN OTHERS THEN
947: ROLLBACK TO create_hesa_susa_pub;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
950: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
951: l_api_name);
952: END IF;