711:
712:
713: PROCEDURE check_ae_header_uk_items(
714: p_ae_header_rec IN ae_header_rec_type,
715: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
716: x_return_status OUT NOCOPY VARCHAR2)
717: IS
718: l_valid_flag VARCHAR2(1);
719:
718: l_valid_flag VARCHAR2(1);
719:
720: BEGIN
721: x_return_status := FND_API.g_ret_sts_success;
722: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
723: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
724: 'OZF_AE_HEADERS_ALL',
725: 'AE_HEADER_ID = ''' || p_ae_header_rec.AE_HEADER_ID ||''''
726: );
741: END check_ae_header_uk_items;
742:
743: PROCEDURE check_ae_header_req_items(
744: p_ae_header_rec IN ae_header_rec_type,
745: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
746: x_return_status OUT NOCOPY VARCHAR2
747: )
748: IS
749: BEGIN
748: IS
749: BEGIN
750: x_return_status := FND_API.g_ret_sts_success;
751:
752: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
753:
754:
755: IF p_ae_header_rec.ae_header_id = FND_API.g_miss_num OR p_ae_header_rec.ae_header_id IS NULL THEN
756: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_HEADER_ID' );
1411: IF FND_API.to_Boolean( p_init_msg_list )
1412: THEN
1413: FND_MSG_PUB.initialize;
1414: END IF;
1415: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1416: Check_ae_header_Items(
1417: p_ae_header_rec => p_ae_header_rec,
1418: p_validation_mode => JTF_PLSQL_API.g_update,
1419: x_return_status => x_return_status
1414: END IF;
1415: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1416: Check_ae_header_Items(
1417: p_ae_header_rec => p_ae_header_rec,
1418: p_validation_mode => JTF_PLSQL_API.g_update,
1419: x_return_status => x_return_status
1420: );
1421:
1422: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1430: p_ae_header_rec => p_ae_header_rec,
1431: x_complete_rec => l_ae_header_rec
1432: );
1433:
1434: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1435: Validate_ae_header_Rec(
1436: p_api_version_number => 1.0,
1437: p_init_msg_list => FND_API.G_FALSE,
1438: x_return_status => x_return_status,