eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on OZF_UTILITY_PVT

Line 207: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

203: -- =========================================================================
204:
205: IF FND_GLOBAL.User_Id IS NULL
206: THEN
207: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
208: RAISE FND_API.G_EXC_ERROR;
209: END IF;
210:
211: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 366: WHEN OZF_Utility_PVT.resource_locked THEN

362: p_data => x_msg_data
363: );
364: EXCEPTION
365:
366: WHEN OZF_Utility_PVT.resource_locked THEN
367: x_return_status := FND_API.g_ret_sts_error;
368: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
369:
370: WHEN FND_API.G_EXC_ERROR THEN

Line 368: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

364: EXCEPTION
365:
366: WHEN OZF_Utility_PVT.resource_locked THEN
367: x_return_status := FND_API.g_ret_sts_error;
368: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
369:
370: WHEN FND_API.G_EXC_ERROR THEN
371: ROLLBACK TO CREATE_Offers_PVT;
372: x_return_status := FND_API.G_RET_STS_ERROR;

Line 770: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

766: OPEN c_get_Offers( l_tar_offers_rec.qp_list_header_id);
767: FETCH c_get_Offers INTO l_object_version_number;
768:
769: If ( c_get_Offers%NOTFOUND) THEN
770: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
771: p_token_name => 'INFO',
772: p_token_value => 'Offers') ;
773: RAISE FND_API.G_EXC_ERROR;
774: END IF;

Line 781: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

777: -- Check Whether record has been changed by someone else
778: If l_tar_offers_rec.object_version_number IS NOT NULL
779: AND l_tar_offers_rec.object_version_number <> FND_API.G_MISS_NUM
780: AND l_tar_offers_rec.object_version_number <> l_object_version_number Then
781: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
782: p_token_name => 'INFO',
783: p_token_value => 'Offers') ;
784: raise FND_API.G_EXC_ERROR;
785: End if;

Line 818: ,p_user_or_role_id => ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id)

814:
815: IF l_offers_rec.owner_id <> l_old_owner_id THEN
816: l_is_owner := AMS_access_PVT.check_owner(p_object_id => l_offers_rec.qp_list_header_id
817: ,p_object_type => 'OFFR'
818: ,p_user_or_role_id => ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id)
819: ,p_user_or_role_type => 'USER');
820: -- check if login user is super user
821: l_is_admin := AMS_Access_PVT.Check_Admin_Access(ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id));
822:

Line 821: l_is_admin := AMS_Access_PVT.Check_Admin_Access(ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id));

817: ,p_object_type => 'OFFR'
818: ,p_user_or_role_id => ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id)
819: ,p_user_or_role_type => 'USER');
820: -- check if login user is super user
821: l_is_admin := AMS_Access_PVT.Check_Admin_Access(ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id));
822:
823: IF l_is_owner = 'Y' OR l_is_admin THEN -- curent user is owner/admin, changing owner is allowed
824: AMS_access_PVT.update_object_owner(
825: p_api_version => l_api_version_number,

Line 843: OZF_Utility_PVT.error_message('OZF_OFFR_UPDT_OWNER_PERM');

839: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
840: RAISE FND_API.g_exc_unexpected_error;
841: END IF;
842: ELSE -- not owner nor super user
843: OZF_Utility_PVT.error_message('OZF_OFFR_UPDT_OWNER_PERM');
844: RAISE FND_API.g_exc_error;
845: END IF;
846: END IF;
847: -- end of offer security change

Line 944: WHEN OZF_Utility_PVT.resource_locked THEN

940: p_encoded => FND_API.G_FALSE
941: );
942: EXCEPTION
943:
944: WHEN OZF_Utility_PVT.resource_locked THEN
945: x_return_status := FND_API.g_ret_sts_error;
946: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
947:
948: WHEN FND_API.G_EXC_ERROR THEN

Line 946: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

942: EXCEPTION
943:
944: WHEN OZF_Utility_PVT.resource_locked THEN
945: x_return_status := FND_API.g_ret_sts_error;
946: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
947:
948: WHEN FND_API.G_EXC_ERROR THEN
949: ROLLBACK TO UPDATE_Offers_PVT;
950: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1048: WHEN OZF_Utility_PVT.resource_locked THEN

1044: p_data => x_msg_data
1045: );
1046: EXCEPTION
1047:
1048: WHEN OZF_Utility_PVT.resource_locked THEN
1049: x_return_status := FND_API.g_ret_sts_error;
1050: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1051:
1052: WHEN FND_API.G_EXC_ERROR THEN

Line 1050: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1046: EXCEPTION
1047:
1048: WHEN OZF_Utility_PVT.resource_locked THEN
1049: x_return_status := FND_API.g_ret_sts_error;
1050: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1051:
1052: WHEN FND_API.G_EXC_ERROR THEN
1053: ROLLBACK TO DELETE_Offers_PVT;
1054: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1162: WHEN OZF_Utility_PVT.resource_locked THEN

1158: p_data => x_msg_data);
1159:
1160: EXCEPTION
1161:
1162: WHEN OZF_Utility_PVT.resource_locked THEN
1163: x_return_status := FND_API.g_ret_sts_error;
1164: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1165:
1166: WHEN FND_API.G_EXC_ERROR THEN

Line 1164: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1160: EXCEPTION
1161:
1162: WHEN OZF_Utility_PVT.resource_locked THEN
1163: x_return_status := FND_API.g_ret_sts_error;
1164: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1165:
1166: WHEN FND_API.G_EXC_ERROR THEN
1167: ROLLBACK TO LOCK_Offers_PVT;
1168: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1213: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

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
1216: );
1217:

Line 1221: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ID_DUPLICATE');

1217:
1218: END IF;
1219:
1220: IF l_valid_flag = FND_API.g_false THEN
1221: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ID_DUPLICATE');
1222: x_return_status := FND_API.g_ret_sts_error;
1223: RETURN;
1224: END IF;
1225:

Line 1228: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

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
1231: );
1232:

Line 1236: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_QP_ID_DUPLICATE');

1232:
1233: END IF;
1234:
1235: IF l_valid_flag = FND_API.g_false THEN
1236: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_QP_ID_DUPLICATE');
1237: x_return_status := FND_API.g_ret_sts_error;
1238: RETURN;
1239: END IF;
1240:

Line 1265: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_ID');

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');
1266: x_return_status := FND_API.g_ret_sts_error;
1267: RETURN;
1268: END IF;
1269:

Line 1272: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_LIST_HEADER_ID');

1268: END IF;
1269:
1270:
1271: IF p_offers_rec.qp_list_header_id = FND_API.g_miss_num OR p_offers_rec.qp_list_header_id IS NULL THEN
1272: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_LIST_HEADER_ID');
1273: x_return_status := FND_API.g_ret_sts_error;
1274: RETURN;
1275: END IF;
1276:

Line 1279: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_TYPE');

1275: END IF;
1276:
1277:
1278: IF p_offers_rec.offer_type = FND_API.g_miss_char OR p_offers_rec.offer_type IS NULL THEN
1279: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_TYPE');
1280: x_return_status := FND_API.g_ret_sts_error;
1281: RETURN;
1282: END IF;
1283:

Line 1286: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_CODE');

1282: END IF;
1283:
1284:
1285: IF p_offers_rec.offer_code = FND_API.g_miss_char OR p_offers_rec.offer_code IS NULL THEN
1286: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_CODE');
1287: x_return_status := FND_API.g_ret_sts_error;
1288: RETURN;
1289: END IF;
1290:

Line 1292: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_USER_STATUS_ID');

1288: RETURN;
1289: END IF;
1290:
1291: IF p_offers_rec.user_status_id = FND_API.g_miss_num OR p_offers_rec.user_status_id IS NULL THEN
1292: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_USER_STATUS_ID');
1293: x_return_status := FND_API.g_ret_sts_error;
1294: RETURN;
1295: END IF;
1296:

Line 1299: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_ACTIVITY');

1295: END IF;
1296:
1297: IF p_offers_rec.offer_type = 'SCAN_DATA' THEN
1298: IF p_offers_rec.activity_media_id = FND_API.g_miss_num OR p_offers_rec.activity_media_id IS NULL THEN
1299: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_ACTIVITY');
1300: x_return_status := FND_API.g_ret_sts_error;
1301: RETURN;
1302: END IF;
1303: END IF;

Line 1307: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_AUTOPAY_DAYS');

1303: END IF;
1304:
1305: IF p_offers_rec.autopay_flag = 'Y' THEN
1306: IF p_offers_rec.autopay_days IS NULL THEN
1307: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_AUTOPAY_DAYS');
1308: x_return_status := FND_API.g_ret_sts_error;
1309: RETURN;
1310: END IF;
1311:

Line 1313: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_AUTOPAY_METHOD');

1309: RETURN;
1310: END IF;
1311:
1312: IF p_offers_rec.autopay_method IS NULL THEN
1313: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_AUTOPAY_METHOD');
1314: x_return_status := FND_API.g_ret_sts_error;
1315: RETURN;
1316: END IF;
1317:

Line 1319: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_AUTOPAY_PARTY_ID');

1315: RETURN;
1316: END IF;
1317:
1318: IF p_offers_rec.autopay_party_id IS NULL THEN
1319: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_AUTOPAY_PARTY_ID');
1320: x_return_status := FND_API.g_ret_sts_error;
1321: RETURN;
1322: END IF;
1323:

Line 1328: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_END_DATE');

1324: OPEN c_offer_end_date;
1325: FETCH c_offer_end_date INTO l_offer_end_date;
1326: CLOSE c_offer_end_date;
1327: IF l_offer_end_date IS NULL THEN
1328: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_END_DATE');
1329: x_return_status := FND_API.g_ret_sts_error;
1330: RETURN;
1331: END IF;
1332: END IF;

Line 1336: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_INVALID_TIER_LVL');

1332: END IF;
1333:
1334: IF p_offers_rec.offer_type = 'NET_ACCRUAL' THEN
1335: IF p_offers_rec.tier_level = FND_API.g_miss_char OR p_offers_rec.tier_level IS NULL THEN
1336: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_INVALID_TIER_LVL');
1337: x_return_status := FND_API.g_ret_sts_error;
1338: RETURN;
1339: END IF;
1340:

Line 1343: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_CUSTOMER');

1339: END IF;
1340:
1341: IF p_offers_rec.custom_setup_id <> 105 THEN -- customer not required for PV offer
1342: IF p_offers_rec.qualifier_id IS NULL OR p_offers_rec.qualifier_id = FND_API.g_miss_num THEN
1343: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_CUSTOMER');
1344: x_return_status := FND_API.g_ret_sts_error;
1345: RETURN;
1346: END IF;
1347: END IF;

Line 1353: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_ID');

1349: ELSE
1350:
1351:
1352: IF p_offers_rec.offer_id IS NULL THEN
1353: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_ID');
1354: x_return_status := FND_API.g_ret_sts_error;
1355: RETURN;
1356: END IF;
1357:

Line 1360: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_LIST_HEADER_ID');

1356: END IF;
1357:
1358:
1359: IF p_offers_rec.qp_list_header_id IS NULL THEN
1360: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_LIST_HEADER_ID');
1361: x_return_status := FND_API.g_ret_sts_error;
1362: RETURN;
1363: END IF;
1364:

Line 1367: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_TYPE');

1363: END IF;
1364:
1365:
1366: IF p_offers_rec.offer_type IS NULL THEN
1367: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_TYPE');
1368: x_return_status := FND_API.g_ret_sts_error;
1369: RETURN;
1370: END IF;
1371:

Line 1374: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_CODE');

1370: END IF;
1371:
1372:
1373: IF p_offers_rec.offer_code IS NULL THEN
1374: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_CODE');
1375: x_return_status := FND_API.g_ret_sts_error;
1376: RETURN;
1377: END IF;
1378:

Line 1380: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_USER_STATUS_ID');

1376: RETURN;
1377: END IF;
1378:
1379: IF p_offers_rec.user_status_id IS NULL THEN
1380: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_USER_STATUS_ID');
1381: x_return_status := FND_API.g_ret_sts_error;
1382: RETURN;
1383: END IF;
1384:

Line 1387: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_ACTIVITY');

1383: END IF;
1384:
1385: IF p_offers_rec.offer_type = 'SCAN_DATA' THEN
1386: IF p_offers_rec.activity_media_id IS NULL OR p_offers_rec.activity_media_id = FND_API.g_miss_num THEN
1387: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_ACTIVITY');
1388: x_return_status := FND_API.g_ret_sts_error;
1389: RETURN;
1390: END IF;
1391: END IF;

Line 1395: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_INVALID_TIER_LVL');

1391: END IF;
1392:
1393: IF p_offers_rec.offer_type = 'NET_ACCRUAL' THEN
1394: IF p_offers_rec.tier_level = FND_API.g_miss_char OR p_offers_rec.tier_level IS NULL THEN
1395: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_INVALID_TIER_LVL');
1396: x_return_status := FND_API.g_ret_sts_error;
1397: RETURN;
1398: END IF;
1399:

Line 1402: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_CUSTOMER');

1398: END IF;
1399:
1400: IF p_offers_rec.custom_setup_id <> 105 THEN -- customer not required for PV offer
1401: IF p_offers_rec.qualifier_id IS NULL OR p_offers_rec.qualifier_id = FND_API.g_miss_num THEN
1402: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_CUSTOMER');
1403: x_return_status := FND_API.g_ret_sts_error;
1404: RETURN;
1405: END IF;
1406: END IF;

Line 1432: IF OZF_Utility_PVT.check_fk_exists(

1428: x_return_status := FND_API.g_ret_sts_success;
1429:
1430: --- checking the owner_id
1431: IF p_offers_rec.owner_id <> FND_API.g_miss_num THEN
1432: IF OZF_Utility_PVT.check_fk_exists(
1433: 'jtf_rs_resource_extns',
1434: 'resource_id',
1435: p_offers_rec.owner_id ) = FND_API.g_false
1436: THEN

Line 1437: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_USER_ID');

1433: 'jtf_rs_resource_extns',
1434: 'resource_id',
1435: p_offers_rec.owner_id ) = FND_API.g_false
1436: THEN
1437: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_USER_ID');
1438: x_return_status := FND_API.g_ret_sts_error;
1439: RETURN;
1440: END IF;
1441: END IF;

Line 1445: IF OZF_Utility_PVT.check_fk_exists(

1441: END IF;
1442:
1443: --- checking the qp_list_header_id
1444: IF p_offers_rec.qp_list_header_id <> FND_API.G_MISS_NUM THEN
1445: IF OZF_Utility_PVT.check_fk_exists(
1446: 'qp_list_headers_b'
1447: ,'list_header_id '
1448: ,p_offers_rec.qp_list_header_id) = FND_API.g_false
1449: THEN

Line 1450: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_QP_LIST_HEADER_ID');

1446: 'qp_list_headers_b'
1447: ,'list_header_id '
1448: ,p_offers_rec.qp_list_header_id) = FND_API.g_false
1449: THEN
1450: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_QP_LIST_HEADER_ID');
1451: x_return_status := FND_API.g_ret_sts_error;
1452: RETURN;
1453: END IF;
1454: END IF;

Line 1460: IF OZF_Utility_PVT.check_fk_exists(

1456: -- checking the custom_setup_id
1457: IF p_offers_rec.custom_setup_id <> FND_API.g_miss_num
1458: AND p_offers_rec.custom_setup_id IS NOT NULL
1459: THEN
1460: IF OZF_Utility_PVT.check_fk_exists(
1461: 'ams_custom_setups_vl'
1462: ,'custom_setup_id '
1463: ,p_offers_rec.custom_setup_id) = FND_API.g_false
1464: THEN

Line 1465: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_CUSTOM_SETUP_ID');

1461: 'ams_custom_setups_vl'
1462: ,'custom_setup_id '
1463: ,p_offers_rec.custom_setup_id) = FND_API.g_false
1464: THEN
1465: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_CUSTOM_SETUP_ID');
1466: x_return_status := FND_API.g_ret_sts_error;
1467: RETURN;
1468: END IF;
1469: END IF;

Line 1475: IF OZF_Utility_PVT.check_fk_exists(

1471: -- checking the user_status_id
1472: IF p_offers_rec.user_status_id <> FND_API.G_MISS_NUM
1473: AND p_offers_rec.user_status_id IS NOT NULL
1474: THEN
1475: IF OZF_Utility_PVT.check_fk_exists(
1476: 'ams_user_statuses_vl'
1477: ,'user_status_id '
1478: ,p_offers_rec.user_status_id) = FND_API.g_false
1479: THEN

Line 1480: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_USER_STATUS_ID');

1476: 'ams_user_statuses_vl'
1477: ,'user_status_id '
1478: ,p_offers_rec.user_status_id) = FND_API.g_false
1479: THEN
1480: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_USER_STATUS_ID');
1481: x_return_status := FND_API.g_ret_sts_error;
1482: RETURN;
1483: END IF;
1484: END IF;

Line 1497: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_MEDIA_ID');

1493: CLOSE c_media_id;
1494:
1495: IF l_dummy IS NULL
1496: THEN
1497: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_MEDIA_ID');
1498: x_return_status := FND_API.g_ret_sts_error;
1499: RETURN;
1500: END IF;
1501: END IF;

Line 1505: IF ozf_utility_pvt.check_fk_exists('ozf_na_rule_headers_b'

1501: END IF;
1502:
1503: IF p_offers_rec.offer_type = 'NET_ACCRUAL' THEN
1504: IF p_offers_rec.na_rule_header_id IS NOT NULL AND p_offers_rec.na_rule_header_id <> FND_API.G_MISS_NUM THEN
1505: IF ozf_utility_pvt.check_fk_exists('ozf_na_rule_headers_b'
1506: ,'NA_RULE_HEADER_ID'
1507: ,p_offers_rec.na_rule_header_id) = FND_API.G_FALSE
1508: THEN
1509: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_NA_RULE_HEADER_ID');

Line 1509: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_NA_RULE_HEADER_ID');

1505: IF ozf_utility_pvt.check_fk_exists('ozf_na_rule_headers_b'
1506: ,'NA_RULE_HEADER_ID'
1507: ,p_offers_rec.na_rule_header_id) = FND_API.G_FALSE
1508: THEN
1509: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_NA_RULE_HEADER_ID');
1510: x_return_status := FND_API.g_ret_sts_error;
1511: RETURN;
1512: END IF;
1513: END IF;

Line 1529: IF OZF_Utility_PVT.check_lookup_exists(

1525: -- modifier_level_code
1526: IF p_offers_rec.modifier_level_code <> FND_API.g_miss_char
1527: AND p_offers_rec.modifier_level_code IS NOT NULL
1528: THEN
1529: IF OZF_Utility_PVT.check_lookup_exists(
1530: p_lookup_table_name => 'qp_lookups'
1531: ,p_lookup_type => 'MODIFIER_LEVEL_CODE'
1532: ,p_lookup_code => p_offers_rec.modifier_level_code
1533: ) = FND_API.g_false

Line 1535: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;

1531: ,p_lookup_type => 'MODIFIER_LEVEL_CODE'
1532: ,p_lookup_code => p_offers_rec.modifier_level_code
1533: ) = FND_API.g_false
1534: THEN
1535: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;
1536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1537: THEN
1538: FND_MESSAGE.set_name('OZF', 'OZF_OFR_BAD_MODIFIER_LEVEL_COD');
1539: FND_MSG_PUB.add;

Line 1551: IF OZF_Utility_PVT.check_lookup_exists(

1547: --- reminder : This lookup has to be created . -musman 04/20
1548: IF p_offers_rec.order_value_discount_type <> FND_API.g_miss_char
1549: AND p_offers_rec.order_value_discount_type IS NOT NULL
1550: THEN
1551: IF OZF_Utility_PVT.check_lookup_exists(
1552: p_lookup_type => 'OZF_OFFER_OV_DISCOUNT_TYPE',
1553: p_lookup_code => p_offers_rec.order_value_discount_type
1554: ) = FND_API.g_false
1555: THEN

Line 1556: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_DISCOUNT_TYPE') ;

1552: p_lookup_type => 'OZF_OFFER_OV_DISCOUNT_TYPE',
1553: p_lookup_code => p_offers_rec.order_value_discount_type
1554: ) = FND_API.g_false
1555: THEN
1556: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_DISCOUNT_TYPE') ;
1557: x_return_status := FND_API.g_ret_sts_error;
1558: RETURN;
1559: END IF;
1560: END IF;

Line 1565: IF OZF_Utility_PVT.check_lookup_exists(

1561:
1562: IF p_offers_rec.lumpsum_payment_type <> FND_API.g_miss_char
1563: AND p_offers_rec.lumpsum_payment_type IS NOT NULL
1564: THEN
1565: IF OZF_Utility_PVT.check_lookup_exists(
1566: p_lookup_type => 'OZF_OFFER_LUMPSUM_PAYMENT',
1567: p_lookup_code => p_offers_rec.lumpsum_payment_type
1568: ) = FND_API.g_false
1569: THEN

Line 1570: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_DISCOUNT_TYPE') ;

1566: p_lookup_type => 'OZF_OFFER_LUMPSUM_PAYMENT',
1567: p_lookup_code => p_offers_rec.lumpsum_payment_type
1568: ) = FND_API.g_false
1569: THEN
1570: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_DISCOUNT_TYPE') ;
1571: x_return_status := FND_API.g_ret_sts_error;
1572: RETURN;
1573: END IF;
1574: END IF;

Line 1580: IF OZF_Utility_PVT.check_lookup_exists(

1576: -- status code
1577: IF p_offers_rec.status_code <> FND_API.g_miss_char
1578: AND p_offers_rec.status_code IS NOT NULL
1579: THEN
1580: IF OZF_Utility_PVT.check_lookup_exists(
1581: p_lookup_type => 'OZF_OFFER_STATUS',
1582: p_lookup_code => p_offers_rec.status_code
1583: ) = FND_API.g_false
1584: THEN

Line 1585: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_STATUS_CODE') ;

1581: p_lookup_type => 'OZF_OFFER_STATUS',
1582: p_lookup_code => p_offers_rec.status_code
1583: ) = FND_API.g_false
1584: THEN
1585: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_STATUS_CODE') ;
1586: x_return_status := FND_API.g_ret_sts_error;
1587: RETURN;
1588: END IF;
1589: END IF;

Line 1595: IF OZF_Utility_PVT.check_lookup_exists(

1591: -- offer_type
1592: IF p_offers_rec.offer_type <> FND_API.g_miss_char
1593: AND p_offers_rec.offer_type IS NOT NULL
1594: THEN
1595: IF OZF_Utility_PVT.check_lookup_exists(
1596: p_lookup_type => 'OZF_OFFER_TYPE',
1597: p_lookup_code => p_offers_rec.offer_type
1598: ) = FND_API.g_false
1599: THEN

Line 1600: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_OFFER_TYPE') ;

1596: p_lookup_type => 'OZF_OFFER_TYPE',
1597: p_lookup_code => p_offers_rec.offer_type
1598: ) = FND_API.g_false
1599: THEN
1600: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_OFFER_TYPE') ;
1601: x_return_status := FND_API.g_ret_sts_error;
1602: RETURN;
1603: END IF;
1604: END IF;

Line 1608: IF OZF_Utility_PVT.check_lookup_exists(

1604: END IF;
1605:
1606: -- break_type
1607: IF p_offers_rec.offer_type = 'OID' THEN
1608: IF OZF_Utility_PVT.check_lookup_exists(
1609: p_lookup_type => 'OZF_OFFER_BREAK_TYPE',
1610: p_lookup_code => p_offers_rec.break_type
1611: ) = FND_API.g_false
1612: THEN

Line 1613: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_BREAK_TYPE') ;

1609: p_lookup_type => 'OZF_OFFER_BREAK_TYPE',
1610: p_lookup_code => p_offers_rec.break_type
1611: ) = FND_API.g_false
1612: THEN
1613: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_BREAK_TYPE') ;
1614: x_return_status := FND_API.g_ret_sts_error;
1615: RETURN;
1616: END IF;
1617: END IF;

Line 1622: IF OZF_Utility_PVT.check_lookup_exists(

1618: /*
1619: IF p_offers_rec.autopay_method <> FND_API.g_miss_char
1620: AND p_offers_rec.autopay_method IS NOT NULL
1621: THEN
1622: IF OZF_Utility_PVT.check_lookup_exists(
1623: p_lookup_table_name => 'OZF_lookups'
1624: ,p_lookup_type => 'OZF_OFFER_AUTOPAY_METHOD'
1625: ,p_lookup_code => p_offers_rec.autopay_method
1626: ) = FND_API.g_false

Line 1628: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;

1624: ,p_lookup_type => 'OZF_OFFER_AUTOPAY_METHOD'
1625: ,p_lookup_code => p_offers_rec.autopay_method
1626: ) = FND_API.g_false
1627: THEN
1628: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;
1629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1630: THEN
1631: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_PAYMENT_METHOD');
1632: FND_MSG_PUB.add;

Line 1642: IF OZF_Utility_PVT.check_lookup_exists(

1638:
1639: IF p_offers_rec.autopay_party_attr <> FND_API.g_miss_char
1640: AND p_offers_rec.autopay_party_attr IS NOT NULL
1641: THEN
1642: IF OZF_Utility_PVT.check_lookup_exists(
1643: p_lookup_table_name => 'ozf_lookups'
1644: ,p_lookup_type => 'OZF_AUTOPAY_CUST_TYPES'
1645: ,p_lookup_code => p_offers_rec.autopay_party_attr
1646: ) = FND_API.g_false

Line 1648: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;

1644: ,p_lookup_type => 'OZF_AUTOPAY_CUST_TYPES'
1645: ,p_lookup_code => p_offers_rec.autopay_party_attr
1646: ) = FND_API.g_false
1647: THEN
1648: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;
1649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1650: THEN
1651: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_AUTOPAY_CUSTTYPE');
1652: FND_MSG_PUB.add;

Line 1674: IF OZF_Utility_PVT.is_Y_or_N(p_offers_rec.reusable) = FND_API.g_false

1670: ----------------------- active_flag ------------------------
1671: IF p_offers_rec.reusable <> FND_API.g_miss_char
1672: AND p_offers_rec.reusable IS NOT NULL
1673: THEN
1674: IF OZF_Utility_PVT.is_Y_or_N(p_offers_rec.reusable) = FND_API.g_false
1675: THEN
1676: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_REUSABLE_FLAG');
1677: x_return_status := FND_API.g_ret_sts_error;
1678: RETURN;

Line 1676: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_REUSABLE_FLAG');

1672: AND p_offers_rec.reusable IS NOT NULL
1673: THEN
1674: IF OZF_Utility_PVT.is_Y_or_N(p_offers_rec.reusable) = FND_API.g_false
1675: THEN
1676: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_REUSABLE_FLAG');
1677: x_return_status := FND_API.g_ret_sts_error;
1678: RETURN;
1679: END IF;
1680: END IF;

Line 1869: WHEN OZF_Utility_PVT.resource_locked THEN

1865: );
1866:
1867: EXCEPTION
1868:
1869: WHEN OZF_Utility_PVT.resource_locked THEN
1870: x_return_status := FND_API.g_ret_sts_error;
1871: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1872:
1873: WHEN FND_API.G_EXC_ERROR THEN

Line 1871: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1867: EXCEPTION
1868:
1869: WHEN OZF_Utility_PVT.resource_locked THEN
1870: x_return_status := FND_API.g_ret_sts_error;
1871: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1872:
1873: WHEN FND_API.G_EXC_ERROR THEN
1874: ROLLBACK TO VALIDATE_Offers_;
1875: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1968: OZF_Utility_PVT.error_message('OZF_OFFR_BAD_USER_STATUS_ID');

1964: CLOSE c_status_code;
1965:
1966: IF l_status_code IS NULL THEN
1967: x_return_status := FND_API.g_ret_sts_error;
1968: OZF_Utility_PVT.error_message('OZF_OFFR_BAD_USER_STATUS_ID');
1969: END IF;
1970:
1971: x_status_code := l_status_code;
1972:

Line 2001: OZF_Utility_PVT.error_message('OZF_OFFR_BAD_USER_STATUS_ID');

1997: CLOSE c_status_id;
1998:
1999: IF l_status_id IS NULL THEN
2000: x_return_status := FND_API.g_ret_sts_error;
2001: OZF_Utility_PVT.error_message('OZF_OFFR_BAD_USER_STATUS_ID');
2002: END IF;
2003:
2004: x_status_id := l_status_id;
2005: