[Home] [Help]
88: FETCH c_custom_setup INTO l_custom_setup_id;
89: CLOSE c_custom_setup;
90: */
91: -- validate
92: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
93: validate_act_offer
94: (
95: p_api_version => l_api_version,
96: p_init_msg_list => p_init_msg_list,
394:
395: x_return_status := FND_API.g_ret_sts_success;
396:
397: -- validate
398: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
399: check_items
400: (
401: p_validation_mode => JTF_PLSQL_API.g_update,
402: x_return_status => l_return_status,
397: -- validate
398: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
399: check_items
400: (
401: p_validation_mode => JTF_PLSQL_API.g_update,
402: x_return_status => l_return_status,
403: p_act_offer_rec => l_act_offer_rec
404: );
405:
415: p_act_offer_rec,
416: l_act_offer_rec
417: );
418:
419: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
420: check_record
421: (
422: p_act_offer_rec => p_act_offer_rec,
423: p_complete_rec => l_act_offer_rec,
843:
844: x_return_status := FND_API.g_ret_sts_success;
845:
846: ---------------------- validate ------------------------
847: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
848: check_items
849: (
850: p_validation_mode => JTF_PLSQL_API.g_create,
851: x_return_status => l_return_status,
846: ---------------------- validate ------------------------
847: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
848: check_items
849: (
850: p_validation_mode => JTF_PLSQL_API.g_create,
851: x_return_status => l_return_status,
852: p_act_offer_rec => p_act_offer_rec
853: );
854:
859: END IF;
860: END IF;
861:
862: -- record level
863: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
864: check_record
865: (
866: p_act_offer_rec => p_act_offer_rec,
867: p_complete_rec => p_act_offer_rec,
939: -- Date : 14Jan2000
940:
941: -- check activity_offer_id
942: IF p_act_offer_rec.activity_offer_id IS NULL
943: AND p_validation_mode = JTF_PLSQL_API.g_update
944: THEN
945: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
946: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_ACT_OFFER_ID');
947: FND_MSG_PUB.add;
952: END IF;
953:
954: -- check object_version_number
955: IF p_act_offer_rec.object_version_number IS NULL
956: AND p_validation_mode = JTF_PLSQL_API.g_update
957: THEN
958: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
959: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
960: FND_MSG_PUB.add;
1007: -- 11/22/1999 julou created
1008: -------------------------------------------------------------------------------
1009: PROCEDURE Check_Uk_Items
1010: (
1011: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1012: p_act_offer_rec IN act_offer_rec_type,
1013: x_return_status OUT NOCOPY VARCHAR2
1014: )
1015: IS
1021: x_return_status := FND_API.g_ret_sts_success;
1022: -- rssharma fixed bug # 2747282
1023: -- don't allow adding duplicate offers to same campaign
1024: -- check PK, if activity_offer_id is passed in, must check if it is duplicate
1025: IF p_validation_mode = JTF_PLSQL_API.g_create
1026: -- AND p_act_offer_rec.activity_offer_id IS NOT NULL
1027: THEN
1028: l_uk_flag := OZF_Utility_PVT.check_uniqueness
1029: (
1031: ' qp_list_header_id = ' || p_act_offer_rec.qp_list_header_id ||
1032: ' AND act_offer_used_by_id = ' || p_act_offer_rec.act_offer_used_by_id ||
1033: ' AND arc_act_offer_used_by = ' ||p_act_offer_rec.arc_act_offer_used_by
1034: );
1035: ELSIF p_validation_mode = JTF_PLSQL_API.g_update
1036: AND p_act_offer_rec.activity_offer_id IS NOT NULL
1037: THEN
1038: l_uk_flag := OZF_Utility_PVT.check_uniqueness
1039: (
1058: -- commented by julou 05/03/2001. offer_code is gone.
1059: /*
1060: -- check offer_code
1061: IF p_act_offer_rec.offer_code IS NOT NULL THEN
1062: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1063: l_uk_flag := OZF_Utility_PVT.check_uniqueness
1064: (
1065: 'AMS_SOURCE_CODES',
1066: 'source_code = ''' || p_act_offer_rec.offer_code || ''''