APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on JTF_PLSQL_API

Line 1204: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1200:
1201:
1202: PROCEDURE check_offers_uk_items(
1203: p_offers_rec IN offers_rec_type,
1204: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1205: x_return_status OUT NOCOPY VARCHAR2)
1206: IS
1207: l_valid_flag VARCHAR2(1);
1208:

Line 1211: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1207: l_valid_flag VARCHAR2(1);
1208:
1209: BEGIN
1210: x_return_status := FND_API.g_ret_sts_success;
1211: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1212:
1213: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1214: 'OZF_OFFERS',
1215: 'OFFER_ID = '|| p_offers_rec.OFFER_ID

Line 1226: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1222: x_return_status := FND_API.g_ret_sts_error;
1223: RETURN;
1224: END IF;
1225:
1226: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1227:
1228: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1229: 'OZF_OFFERS',
1230: 'qp_list_header_id = '|| p_offers_rec.qp_list_header_id

Line 1246: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1242: END check_offers_uk_items;
1243:
1244: PROCEDURE check_offers_req_items(
1245: p_offers_rec IN offers_rec_type,
1246: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1247: x_return_status OUT NOCOPY VARCHAR2
1248: )
1249: IS
1250:

Line 1261: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1257:
1258: BEGIN
1259: x_return_status := FND_API.g_ret_sts_success;
1260:
1261: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1262:
1263:
1264: IF p_offers_rec.offer_id = FND_API.g_miss_num OR p_offers_rec.offer_id IS NULL THEN
1265: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_ID');

Line 1828: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1824: p_offers_rec => p_offers_rec,
1825: x_complete_rec => l_offers_rec
1826: );
1827:
1828: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1829: Check_offers_Items(
1830: p_offers_rec => l_offers_rec,
1831: p_validation_mode => JTF_PLSQL_API.g_update,
1832: x_return_status => x_return_status

Line 1831: p_validation_mode => JTF_PLSQL_API.g_update,

1827:
1828: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1829: Check_offers_Items(
1830: p_offers_rec => l_offers_rec,
1831: p_validation_mode => JTF_PLSQL_API.g_update,
1832: x_return_status => x_return_status
1833: );
1834:
1835: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1842: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1839: END IF;
1840: END IF;
1841:
1842: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1843: Validate_offers_Rec(
1844: p_api_version_number => 1.0,
1845: p_init_msg_list => FND_API.G_FALSE,
1846: x_return_status => x_return_status,