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 205: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

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

Line 362: WHEN OZF_Utility_PVT.resource_locked THEN

358: p_data => x_msg_data
359: );
360: EXCEPTION
361:
362: WHEN OZF_Utility_PVT.resource_locked THEN
363: x_return_status := FND_API.g_ret_sts_error;
364: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
365:
366: WHEN FND_API.G_EXC_ERROR THEN

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

360: EXCEPTION
361:
362: WHEN OZF_Utility_PVT.resource_locked THEN
363: x_return_status := FND_API.g_ret_sts_error;
364: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
365:
366: WHEN FND_API.G_EXC_ERROR THEN
367: ROLLBACK TO CREATE_Offers_PVT;
368: x_return_status := FND_API.G_RET_STS_ERROR;

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

757: OPEN c_get_Offers( l_tar_offers_rec.qp_list_header_id);
758: FETCH c_get_Offers INTO l_object_version_number;
759:
760: If ( c_get_Offers%NOTFOUND) THEN
761: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
762: p_token_name => 'INFO',
763: p_token_value => 'Offers') ;
764: RAISE FND_API.G_EXC_ERROR;
765: END IF;

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

768: -- Check Whether record has been changed by someone else
769: If l_tar_offers_rec.object_version_number IS NOT NULL
770: AND l_tar_offers_rec.object_version_number <> FND_API.G_MISS_NUM
771: AND l_tar_offers_rec.object_version_number <> l_object_version_number Then
772: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
773: p_token_name => 'INFO',
774: p_token_value => 'Offers') ;
775: raise FND_API.G_EXC_ERROR;
776: End if;

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

805:
806: IF l_offers_rec.owner_id <> l_old_owner_id THEN
807: l_is_owner := AMS_access_PVT.check_owner(p_object_id => l_offers_rec.qp_list_header_id
808: ,p_object_type => 'OFFR'
809: ,p_user_or_role_id => ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id)
810: ,p_user_or_role_type => 'USER');
811: -- check if login user is super user
812: l_is_admin := AMS_Access_PVT.Check_Admin_Access(ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id));
813:

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

808: ,p_object_type => 'OFFR'
809: ,p_user_or_role_id => ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id)
810: ,p_user_or_role_type => 'USER');
811: -- check if login user is super user
812: l_is_admin := AMS_Access_PVT.Check_Admin_Access(ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id));
813:
814: IF l_is_owner = 'Y' OR l_is_admin THEN -- curent user is owner/admin, changing owner is allowed
815: AMS_access_PVT.update_object_owner(
816: p_api_version => l_api_version_number,

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

830: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
831: RAISE FND_API.g_exc_unexpected_error;
832: END IF;
833: ELSE -- not owner nor super user
834: OZF_Utility_PVT.error_message('OZF_OFFR_UPDT_OWNER_PERM');
835: RAISE FND_API.g_exc_error;
836: END IF;
837: END IF;
838: -- end of offer security change

Line 932: WHEN OZF_Utility_PVT.resource_locked THEN

928: p_encoded => FND_API.G_FALSE
929: );
930: EXCEPTION
931:
932: WHEN OZF_Utility_PVT.resource_locked THEN
933: x_return_status := FND_API.g_ret_sts_error;
934: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
935:
936: WHEN FND_API.G_EXC_ERROR THEN

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

930: EXCEPTION
931:
932: WHEN OZF_Utility_PVT.resource_locked THEN
933: x_return_status := FND_API.g_ret_sts_error;
934: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
935:
936: WHEN FND_API.G_EXC_ERROR THEN
937: ROLLBACK TO UPDATE_Offers_PVT;
938: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1036: WHEN OZF_Utility_PVT.resource_locked THEN

1032: p_data => x_msg_data
1033: );
1034: EXCEPTION
1035:
1036: WHEN OZF_Utility_PVT.resource_locked THEN
1037: x_return_status := FND_API.g_ret_sts_error;
1038: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1039:
1040: WHEN FND_API.G_EXC_ERROR THEN

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

1034: EXCEPTION
1035:
1036: WHEN OZF_Utility_PVT.resource_locked THEN
1037: x_return_status := FND_API.g_ret_sts_error;
1038: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1039:
1040: WHEN FND_API.G_EXC_ERROR THEN
1041: ROLLBACK TO DELETE_Offers_PVT;
1042: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1150: WHEN OZF_Utility_PVT.resource_locked THEN

1146: p_data => x_msg_data);
1147:
1148: EXCEPTION
1149:
1150: WHEN OZF_Utility_PVT.resource_locked THEN
1151: x_return_status := FND_API.g_ret_sts_error;
1152: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1153:
1154: WHEN FND_API.G_EXC_ERROR THEN

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

1148: EXCEPTION
1149:
1150: WHEN OZF_Utility_PVT.resource_locked THEN
1151: x_return_status := FND_API.g_ret_sts_error;
1152: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1153:
1154: WHEN FND_API.G_EXC_ERROR THEN
1155: ROLLBACK TO LOCK_Offers_PVT;
1156: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1201: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

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
1204: );
1205:

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

1205:
1206: END IF;
1207:
1208: IF l_valid_flag = FND_API.g_false THEN
1209: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ID_DUPLICATE');
1210: x_return_status := FND_API.g_ret_sts_error;
1211: RETURN;
1212: END IF;
1213:

Line 1216: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

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
1219: );
1220:

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

1220:
1221: END IF;
1222:
1223: IF l_valid_flag = FND_API.g_false THEN
1224: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_QP_ID_DUPLICATE');
1225: x_return_status := FND_API.g_ret_sts_error;
1226: RETURN;
1227: END IF;
1228:

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

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');
1254: x_return_status := FND_API.g_ret_sts_error;
1255: RETURN;
1256: END IF;
1257:

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

1256: END IF;
1257:
1258:
1259: IF p_offers_rec.qp_list_header_id = FND_API.g_miss_num OR p_offers_rec.qp_list_header_id IS NULL THEN
1260: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_LIST_HEADER_ID');
1261: x_return_status := FND_API.g_ret_sts_error;
1262: RETURN;
1263: END IF;
1264:

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

1263: END IF;
1264:
1265:
1266: IF p_offers_rec.offer_type = FND_API.g_miss_char OR p_offers_rec.offer_type IS NULL THEN
1267: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_TYPE');
1268: x_return_status := FND_API.g_ret_sts_error;
1269: RETURN;
1270: END IF;
1271:

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

1270: END IF;
1271:
1272:
1273: IF p_offers_rec.offer_code = FND_API.g_miss_char OR p_offers_rec.offer_code IS NULL THEN
1274: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_CODE');
1275: x_return_status := FND_API.g_ret_sts_error;
1276: RETURN;
1277: END IF;
1278:

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

1276: RETURN;
1277: END IF;
1278:
1279: IF p_offers_rec.user_status_id = FND_API.g_miss_num OR p_offers_rec.user_status_id IS NULL THEN
1280: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_USER_STATUS_ID');
1281: x_return_status := FND_API.g_ret_sts_error;
1282: RETURN;
1283: END IF;
1284:

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

1283: END IF;
1284:
1285: IF p_offers_rec.offer_type = 'SCAN_DATA' THEN
1286: IF p_offers_rec.activity_media_id = FND_API.g_miss_num OR p_offers_rec.activity_media_id IS NULL THEN
1287: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_ACTIVITY');
1288: x_return_status := FND_API.g_ret_sts_error;
1289: RETURN;
1290: END IF;
1291: END IF;

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

1291: END IF;
1292:
1293: IF p_offers_rec.autopay_flag = 'Y' THEN
1294: IF p_offers_rec.autopay_days IS NULL THEN
1295: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_AUTOPAY_DAYS');
1296: x_return_status := FND_API.g_ret_sts_error;
1297: RETURN;
1298: END IF;
1299:

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

1297: RETURN;
1298: END IF;
1299:
1300: IF p_offers_rec.autopay_method IS NULL THEN
1301: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_AUTOPAY_METHOD');
1302: x_return_status := FND_API.g_ret_sts_error;
1303: RETURN;
1304: END IF;
1305:

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

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

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

1312: OPEN c_offer_end_date;
1313: FETCH c_offer_end_date INTO l_offer_end_date;
1314: CLOSE c_offer_end_date;
1315: IF l_offer_end_date IS NULL THEN
1316: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_END_DATE');
1317: x_return_status := FND_API.g_ret_sts_error;
1318: RETURN;
1319: END IF;
1320: END IF;

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

1320: END IF;
1321:
1322: IF p_offers_rec.offer_type = 'NET_ACCRUAL' THEN
1323: IF p_offers_rec.tier_level = FND_API.g_miss_char OR p_offers_rec.tier_level IS NULL THEN
1324: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_INVALID_TIER_LVL');
1325: x_return_status := FND_API.g_ret_sts_error;
1326: RETURN;
1327: END IF;
1328:

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

1327: END IF;
1328:
1329: IF p_offers_rec.custom_setup_id <> 105 THEN -- customer not required for PV offer
1330: IF p_offers_rec.qualifier_id IS NULL OR p_offers_rec.qualifier_id = FND_API.g_miss_num THEN
1331: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_CUSTOMER');
1332: x_return_status := FND_API.g_ret_sts_error;
1333: RETURN;
1334: END IF;
1335: END IF;

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

1337: ELSE
1338:
1339:
1340: IF p_offers_rec.offer_id IS NULL THEN
1341: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_ID');
1342: x_return_status := FND_API.g_ret_sts_error;
1343: RETURN;
1344: END IF;
1345:

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

1344: END IF;
1345:
1346:
1347: IF p_offers_rec.qp_list_header_id IS NULL THEN
1348: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_LIST_HEADER_ID');
1349: x_return_status := FND_API.g_ret_sts_error;
1350: RETURN;
1351: END IF;
1352:

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

1351: END IF;
1352:
1353:
1354: IF p_offers_rec.offer_type IS NULL THEN
1355: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_TYPE');
1356: x_return_status := FND_API.g_ret_sts_error;
1357: RETURN;
1358: END IF;
1359:

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

1358: END IF;
1359:
1360:
1361: IF p_offers_rec.offer_code IS NULL THEN
1362: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_CODE');
1363: x_return_status := FND_API.g_ret_sts_error;
1364: RETURN;
1365: END IF;
1366:

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

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

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

1371: END IF;
1372:
1373: IF p_offers_rec.offer_type = 'SCAN_DATA' THEN
1374: IF p_offers_rec.activity_media_id IS NULL OR p_offers_rec.activity_media_id = FND_API.g_miss_num THEN
1375: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_ACTIVITY');
1376: x_return_status := FND_API.g_ret_sts_error;
1377: RETURN;
1378: END IF;
1379: END IF;

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

1379: END IF;
1380:
1381: IF p_offers_rec.offer_type = 'NET_ACCRUAL' THEN
1382: IF p_offers_rec.tier_level = FND_API.g_miss_char OR p_offers_rec.tier_level IS NULL THEN
1383: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_INVALID_TIER_LVL');
1384: x_return_status := FND_API.g_ret_sts_error;
1385: RETURN;
1386: END IF;
1387:

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

1386: END IF;
1387:
1388: IF p_offers_rec.custom_setup_id <> 105 THEN -- customer not required for PV offer
1389: IF p_offers_rec.qualifier_id IS NULL OR p_offers_rec.qualifier_id = FND_API.g_miss_num THEN
1390: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_NO_CUSTOMER');
1391: x_return_status := FND_API.g_ret_sts_error;
1392: RETURN;
1393: END IF;
1394: END IF;

Line 1420: IF OZF_Utility_PVT.check_fk_exists(

1416: x_return_status := FND_API.g_ret_sts_success;
1417:
1418: --- checking the owner_id
1419: IF p_offers_rec.owner_id <> FND_API.g_miss_num THEN
1420: IF OZF_Utility_PVT.check_fk_exists(
1421: 'jtf_rs_resource_extns',
1422: 'resource_id',
1423: p_offers_rec.owner_id ) = FND_API.g_false
1424: THEN

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

1421: 'jtf_rs_resource_extns',
1422: 'resource_id',
1423: p_offers_rec.owner_id ) = FND_API.g_false
1424: THEN
1425: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_USER_ID');
1426: x_return_status := FND_API.g_ret_sts_error;
1427: RETURN;
1428: END IF;
1429: END IF;

Line 1433: IF OZF_Utility_PVT.check_fk_exists(

1429: END IF;
1430:
1431: --- checking the qp_list_header_id
1432: IF p_offers_rec.qp_list_header_id <> FND_API.G_MISS_NUM THEN
1433: IF OZF_Utility_PVT.check_fk_exists(
1434: 'qp_list_headers_b'
1435: ,'list_header_id '
1436: ,p_offers_rec.qp_list_header_id) = FND_API.g_false
1437: THEN

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

1434: 'qp_list_headers_b'
1435: ,'list_header_id '
1436: ,p_offers_rec.qp_list_header_id) = FND_API.g_false
1437: THEN
1438: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_QP_LIST_HEADER_ID');
1439: x_return_status := FND_API.g_ret_sts_error;
1440: RETURN;
1441: END IF;
1442: END IF;

Line 1448: IF OZF_Utility_PVT.check_fk_exists(

1444: -- checking the custom_setup_id
1445: IF p_offers_rec.custom_setup_id <> FND_API.g_miss_num
1446: AND p_offers_rec.custom_setup_id IS NOT NULL
1447: THEN
1448: IF OZF_Utility_PVT.check_fk_exists(
1449: 'ams_custom_setups_vl'
1450: ,'custom_setup_id '
1451: ,p_offers_rec.custom_setup_id) = FND_API.g_false
1452: THEN

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

1449: 'ams_custom_setups_vl'
1450: ,'custom_setup_id '
1451: ,p_offers_rec.custom_setup_id) = FND_API.g_false
1452: THEN
1453: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_CUSTOM_SETUP_ID');
1454: x_return_status := FND_API.g_ret_sts_error;
1455: RETURN;
1456: END IF;
1457: END IF;

Line 1463: IF OZF_Utility_PVT.check_fk_exists(

1459: -- checking the user_status_id
1460: IF p_offers_rec.user_status_id <> FND_API.G_MISS_NUM
1461: AND p_offers_rec.user_status_id IS NOT NULL
1462: THEN
1463: IF OZF_Utility_PVT.check_fk_exists(
1464: 'ams_user_statuses_vl'
1465: ,'user_status_id '
1466: ,p_offers_rec.user_status_id) = FND_API.g_false
1467: THEN

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

1464: 'ams_user_statuses_vl'
1465: ,'user_status_id '
1466: ,p_offers_rec.user_status_id) = FND_API.g_false
1467: THEN
1468: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_USER_STATUS_ID');
1469: x_return_status := FND_API.g_ret_sts_error;
1470: RETURN;
1471: END IF;
1472: END IF;

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

1481: CLOSE c_media_id;
1482:
1483: IF l_dummy IS NULL
1484: THEN
1485: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_MEDIA_ID');
1486: x_return_status := FND_API.g_ret_sts_error;
1487: RETURN;
1488: END IF;
1489: END IF;

Line 1493: IF ozf_utility_pvt.check_fk_exists('ozf_na_rule_headers_b'

1489: END IF;
1490:
1491: IF p_offers_rec.offer_type = 'NET_ACCRUAL' THEN
1492: 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
1493: IF ozf_utility_pvt.check_fk_exists('ozf_na_rule_headers_b'
1494: ,'NA_RULE_HEADER_ID'
1495: ,p_offers_rec.na_rule_header_id) = FND_API.G_FALSE
1496: THEN
1497: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_NA_RULE_HEADER_ID');

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

1493: IF ozf_utility_pvt.check_fk_exists('ozf_na_rule_headers_b'
1494: ,'NA_RULE_HEADER_ID'
1495: ,p_offers_rec.na_rule_header_id) = FND_API.G_FALSE
1496: THEN
1497: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_NA_RULE_HEADER_ID');
1498: x_return_status := FND_API.g_ret_sts_error;
1499: RETURN;
1500: END IF;
1501: END IF;

Line 1517: IF OZF_Utility_PVT.check_lookup_exists(

1513: -- modifier_level_code
1514: IF p_offers_rec.modifier_level_code <> FND_API.g_miss_char
1515: AND p_offers_rec.modifier_level_code IS NOT NULL
1516: THEN
1517: IF OZF_Utility_PVT.check_lookup_exists(
1518: p_lookup_table_name => 'qp_lookups'
1519: ,p_lookup_type => 'MODIFIER_LEVEL_CODE'
1520: ,p_lookup_code => p_offers_rec.modifier_level_code
1521: ) = FND_API.g_false

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

1519: ,p_lookup_type => 'MODIFIER_LEVEL_CODE'
1520: ,p_lookup_code => p_offers_rec.modifier_level_code
1521: ) = FND_API.g_false
1522: THEN
1523: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;
1524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1525: THEN
1526: FND_MESSAGE.set_name('OZF', 'OZF_OFR_BAD_MODIFIER_LEVEL_COD');
1527: FND_MSG_PUB.add;

Line 1539: IF OZF_Utility_PVT.check_lookup_exists(

1535: --- reminder : This lookup has to be created . -musman 04/20
1536: IF p_offers_rec.order_value_discount_type <> FND_API.g_miss_char
1537: AND p_offers_rec.order_value_discount_type IS NOT NULL
1538: THEN
1539: IF OZF_Utility_PVT.check_lookup_exists(
1540: p_lookup_type => 'OZF_OFFER_OV_DISCOUNT_TYPE',
1541: p_lookup_code => p_offers_rec.order_value_discount_type
1542: ) = FND_API.g_false
1543: THEN

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

1540: p_lookup_type => 'OZF_OFFER_OV_DISCOUNT_TYPE',
1541: p_lookup_code => p_offers_rec.order_value_discount_type
1542: ) = FND_API.g_false
1543: THEN
1544: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_DISCOUNT_TYPE') ;
1545: x_return_status := FND_API.g_ret_sts_error;
1546: RETURN;
1547: END IF;
1548: END IF;

Line 1553: IF OZF_Utility_PVT.check_lookup_exists(

1549:
1550: IF p_offers_rec.lumpsum_payment_type <> FND_API.g_miss_char
1551: AND p_offers_rec.lumpsum_payment_type IS NOT NULL
1552: THEN
1553: IF OZF_Utility_PVT.check_lookup_exists(
1554: p_lookup_type => 'OZF_OFFER_LUMPSUM_PAYMENT',
1555: p_lookup_code => p_offers_rec.lumpsum_payment_type
1556: ) = FND_API.g_false
1557: THEN

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

1554: p_lookup_type => 'OZF_OFFER_LUMPSUM_PAYMENT',
1555: p_lookup_code => p_offers_rec.lumpsum_payment_type
1556: ) = FND_API.g_false
1557: THEN
1558: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_DISCOUNT_TYPE') ;
1559: x_return_status := FND_API.g_ret_sts_error;
1560: RETURN;
1561: END IF;
1562: END IF;

Line 1568: IF OZF_Utility_PVT.check_lookup_exists(

1564: -- status code
1565: IF p_offers_rec.status_code <> FND_API.g_miss_char
1566: AND p_offers_rec.status_code IS NOT NULL
1567: THEN
1568: IF OZF_Utility_PVT.check_lookup_exists(
1569: p_lookup_type => 'OZF_OFFER_STATUS',
1570: p_lookup_code => p_offers_rec.status_code
1571: ) = FND_API.g_false
1572: THEN

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

1569: p_lookup_type => 'OZF_OFFER_STATUS',
1570: p_lookup_code => p_offers_rec.status_code
1571: ) = FND_API.g_false
1572: THEN
1573: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_STATUS_CODE') ;
1574: x_return_status := FND_API.g_ret_sts_error;
1575: RETURN;
1576: END IF;
1577: END IF;

Line 1583: IF OZF_Utility_PVT.check_lookup_exists(

1579: -- offer_type
1580: IF p_offers_rec.offer_type <> FND_API.g_miss_char
1581: AND p_offers_rec.offer_type IS NOT NULL
1582: THEN
1583: IF OZF_Utility_PVT.check_lookup_exists(
1584: p_lookup_type => 'OZF_OFFER_TYPE',
1585: p_lookup_code => p_offers_rec.offer_type
1586: ) = FND_API.g_false
1587: THEN

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

1584: p_lookup_type => 'OZF_OFFER_TYPE',
1585: p_lookup_code => p_offers_rec.offer_type
1586: ) = FND_API.g_false
1587: THEN
1588: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_OFFER_TYPE') ;
1589: x_return_status := FND_API.g_ret_sts_error;
1590: RETURN;
1591: END IF;
1592: END IF;

Line 1596: IF OZF_Utility_PVT.check_lookup_exists(

1592: END IF;
1593:
1594: -- break_type
1595: IF p_offers_rec.offer_type = 'OID' THEN
1596: IF OZF_Utility_PVT.check_lookup_exists(
1597: p_lookup_type => 'OZF_OFFER_BREAK_TYPE',
1598: p_lookup_code => p_offers_rec.break_type
1599: ) = FND_API.g_false
1600: THEN

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

1597: p_lookup_type => 'OZF_OFFER_BREAK_TYPE',
1598: p_lookup_code => p_offers_rec.break_type
1599: ) = FND_API.g_false
1600: THEN
1601: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_BREAK_TYPE') ;
1602: x_return_status := FND_API.g_ret_sts_error;
1603: RETURN;
1604: END IF;
1605: END IF;

Line 1610: IF OZF_Utility_PVT.check_lookup_exists(

1606: /*
1607: IF p_offers_rec.autopay_method <> FND_API.g_miss_char
1608: AND p_offers_rec.autopay_method IS NOT NULL
1609: THEN
1610: IF OZF_Utility_PVT.check_lookup_exists(
1611: p_lookup_table_name => 'OZF_lookups'
1612: ,p_lookup_type => 'OZF_OFFER_AUTOPAY_METHOD'
1613: ,p_lookup_code => p_offers_rec.autopay_method
1614: ) = FND_API.g_false

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

1612: ,p_lookup_type => 'OZF_OFFER_AUTOPAY_METHOD'
1613: ,p_lookup_code => p_offers_rec.autopay_method
1614: ) = FND_API.g_false
1615: THEN
1616: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;
1617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1618: THEN
1619: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_PAYMENT_METHOD');
1620: FND_MSG_PUB.add;

Line 1630: IF OZF_Utility_PVT.check_lookup_exists(

1626:
1627: IF p_offers_rec.autopay_party_attr <> FND_API.g_miss_char
1628: AND p_offers_rec.autopay_party_attr IS NOT NULL
1629: THEN
1630: IF OZF_Utility_PVT.check_lookup_exists(
1631: p_lookup_table_name => 'ozf_lookups'
1632: ,p_lookup_type => 'OZF_AUTOPAY_CUST_TYPES'
1633: ,p_lookup_code => p_offers_rec.autopay_party_attr
1634: ) = FND_API.g_false

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

1632: ,p_lookup_type => 'OZF_AUTOPAY_CUST_TYPES'
1633: ,p_lookup_code => p_offers_rec.autopay_party_attr
1634: ) = FND_API.g_false
1635: THEN
1636: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;
1637: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1638: THEN
1639: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_AUTOPAY_CUSTTYPE');
1640: FND_MSG_PUB.add;

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

1658: ----------------------- active_flag ------------------------
1659: IF p_offers_rec.reusable <> FND_API.g_miss_char
1660: AND p_offers_rec.reusable IS NOT NULL
1661: THEN
1662: IF OZF_Utility_PVT.is_Y_or_N(p_offers_rec.reusable) = FND_API.g_false
1663: THEN
1664: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_REUSABLE_FLAG');
1665: x_return_status := FND_API.g_ret_sts_error;
1666: RETURN;

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

1660: AND p_offers_rec.reusable IS NOT NULL
1661: THEN
1662: IF OZF_Utility_PVT.is_Y_or_N(p_offers_rec.reusable) = FND_API.g_false
1663: THEN
1664: OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_REUSABLE_FLAG');
1665: x_return_status := FND_API.g_ret_sts_error;
1666: RETURN;
1667: END IF;
1668: END IF;

Line 1857: WHEN OZF_Utility_PVT.resource_locked THEN

1853: );
1854:
1855: EXCEPTION
1856:
1857: WHEN OZF_Utility_PVT.resource_locked THEN
1858: x_return_status := FND_API.g_ret_sts_error;
1859: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1860:
1861: WHEN FND_API.G_EXC_ERROR THEN

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

1855: EXCEPTION
1856:
1857: WHEN OZF_Utility_PVT.resource_locked THEN
1858: x_return_status := FND_API.g_ret_sts_error;
1859: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1860:
1861: WHEN FND_API.G_EXC_ERROR THEN
1862: ROLLBACK TO VALIDATE_Offers_;
1863: x_return_status := FND_API.G_RET_STS_ERROR;

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

1952: CLOSE c_status_code;
1953:
1954: IF l_status_code IS NULL THEN
1955: x_return_status := FND_API.g_ret_sts_error;
1956: OZF_Utility_PVT.error_message('OZF_OFFR_BAD_USER_STATUS_ID');
1957: END IF;
1958:
1959: x_status_code := l_status_code;
1960:

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

1985: CLOSE c_status_id;
1986:
1987: IF l_status_id IS NULL THEN
1988: x_return_status := FND_API.g_ret_sts_error;
1989: OZF_Utility_PVT.error_message('OZF_OFFR_BAD_USER_STATUS_ID');
1990: END IF;
1991:
1992: x_status_id := l_status_id;
1993: