APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on JTF_PLSQL_API

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

1188:
1189:
1190: PROCEDURE check_offers_uk_items(
1191: p_offers_rec IN offers_rec_type,
1192: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1193: x_return_status OUT NOCOPY VARCHAR2)
1194: IS
1195: l_valid_flag VARCHAR2(1);
1196:

Line 1199: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1195: l_valid_flag VARCHAR2(1);
1196:
1197: BEGIN
1198: x_return_status := FND_API.g_ret_sts_success;
1199: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1200:
1201: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1202: 'OZF_OFFERS',
1203: 'OFFER_ID = '|| p_offers_rec.OFFER_ID

Line 1214: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1210: x_return_status := FND_API.g_ret_sts_error;
1211: RETURN;
1212: END IF;
1213:
1214: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1215:
1216: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1217: 'OZF_OFFERS',
1218: 'qp_list_header_id = '|| p_offers_rec.qp_list_header_id

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

1230: END check_offers_uk_items;
1231:
1232: PROCEDURE check_offers_req_items(
1233: p_offers_rec IN offers_rec_type,
1234: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1235: x_return_status OUT NOCOPY VARCHAR2
1236: )
1237: IS
1238:

Line 1249: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1245:
1246: BEGIN
1247: x_return_status := FND_API.g_ret_sts_success;
1248:
1249: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1250:
1251:
1252: IF p_offers_rec.offer_id = FND_API.g_miss_num OR p_offers_rec.offer_id IS NULL THEN
1253: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_ID');

Line 1816: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1812: p_offers_rec => p_offers_rec,
1813: x_complete_rec => l_offers_rec
1814: );
1815:
1816: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1817: Check_offers_Items(
1818: p_offers_rec => l_offers_rec,
1819: p_validation_mode => JTF_PLSQL_API.g_update,
1820: x_return_status => x_return_status

Line 1819: p_validation_mode => JTF_PLSQL_API.g_update,

1815:
1816: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1817: Check_offers_Items(
1818: p_offers_rec => l_offers_rec,
1819: p_validation_mode => JTF_PLSQL_API.g_update,
1820: x_return_status => x_return_status
1821: );
1822:
1823: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1830: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1827: END IF;
1828: END IF;
1829:
1830: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1831: Validate_offers_Rec(
1832: p_api_version_number => 1.0,
1833: p_init_msg_list => FND_API.G_FALSE,
1834: x_return_status => x_return_status,