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_ACT_OFFERS_PVT dependencies on FND_MESSAGE

Line 475: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

471: AND object_version_number = l_act_offer_rec.object_version_number;
472:
473: IF (SQL%NOTFOUND) THEN
474: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
475: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
476: FND_MSG_PUB.add;
477: END IF;
478: RAISE FND_API.g_exc_error;
479: END IF;

Line 601: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

597: AND object_version_number = p_object_version;
598:
599: IF (SQL%NOTFOUND) THEN
600: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
601: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
602: FND_MSG_PUB.add;
603: END IF;
604: RAISE FND_API.g_exc_error;
605: END IF;

Line 743: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

739: FETCH c_act_offer_b INTO l_act_offer_id;
740: IF (c_act_offer_b%NOTFOUND) THEN
741: CLOSE c_act_offer_b;
742: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
743: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
744: FND_MSG_PUB.add;
745: END IF;
746: RAISE FND_API.g_exc_error;
747: END IF;

Line 762: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');

758: EXCEPTION
759: WHEN OZF_Utility_PVT.resource_locked THEN
760: x_return_status := FND_API.g_ret_sts_error;
761: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
762: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
763: FND_MSG_PUB.add;
764: END IF;
765: FND_MSG_PUB.count_and_get
766: (

Line 946: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_ACT_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;
948: END IF;
949:
950: x_return_status := FND_API.g_ret_sts_error;

Line 959: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');

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;
961: END IF;
962:
963: x_return_status := FND_API.g_ret_sts_error;

Line 970: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY_ID');

966:
967: -- check act_offer_used_by_id
968: IF p_act_offer_rec.act_offer_used_by_id IS NULL THEN
969: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
970: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY_ID');
971: FND_MSG_PUB.add;
972: END IF;
973:
974: x_return_status := FND_API.g_ret_sts_error;

Line 981: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY');

977:
978: -- check arc_act_offer_used_by
979: IF p_act_offer_rec.arc_act_offer_used_by IS NULL THEN
980: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
981: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY');
982: FND_MSG_PUB.add;
983: END IF;
984:
985: x_return_status := FND_API.g_ret_sts_error;

Line 992: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_LIST_HEAD_ID');

988:
989: -- check qp_list_header_id
990: IF p_act_offer_rec.qp_list_header_id IS NULL THEN
991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
992: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_LIST_HEAD_ID');
993: FND_MSG_PUB.add;
994: END IF;
995:
996: x_return_status := FND_API.g_ret_sts_error;

Line 1051: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_DUP_OFFER_ID');

1047: END IF;
1048:
1049: IF l_uk_flag = FND_API.g_false THEN
1050: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1051: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_DUP_OFFER_ID');
1052: FND_MSG_PUB.add;
1053: END IF;
1054:
1055: x_return_status := FND_API.g_ret_sts_error;

Line 1080: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_DUP_OFFER_CODE');

1076: END IF;
1077:
1078: IF l_uk_flag = FND_API.g_false THEN
1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1080: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_DUP_OFFER_CODE');
1081: FND_MSG_PUB.add;
1082: END IF;
1083:
1084: x_return_status := FND_API.g_ret_sts_error;

Line 1141: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY_ID');

1137: END IF;
1138:
1139: IF l_fk_flag = FND_API.g_false THEN
1140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1141: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY_ID');
1142: FND_MSG_PUB.add;
1143: END IF;
1144:
1145: x_return_status := FND_API.g_ret_sts_error;

Line 1163: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_LIST_HEAD_ID');

1159: );
1160:
1161: IF l_fk_flag = FND_API.g_false THEN
1162: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1163: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_LIST_HEAD_ID');
1164: FND_MSG_PUB.add;
1165: END IF;
1166:
1167: x_return_status := FND_API.g_ret_sts_error;

Line 1200: -- FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY');

1196: -- IF p_act_offer_rec.arc_act_offer_used_by <> FND_API.g_miss_char
1197: -- AND p_act_offer_rec.arc_act_offer_used_by NOT IN ('ECAM', 'MCAM', 'RCAM', 'CAMP')
1198: -- THEN
1199: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1200: -- FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY');
1201: -- FND_MSG_PUB.add;
1202: -- END IF;
1203: --OZF_UTILITY_PVT.debug_message(g_pkg_name||': check used_by');
1204: --OZF_UTILITY_PVT.debug_message('used by: ' || p_act_offer_rec.arc_act_offer_used_by);

Line 1210: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY');

1206: AND (p_act_offer_rec.arc_act_offer_used_by <> 'CAMP'
1207: AND p_act_offer_rec.arc_act_offer_used_by <> 'CSCH')
1208: THEN
1209: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1210: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY');
1211: FND_MSG_PUB.add;
1212: END IF;
1213:
1214: x_return_status := FND_API.g_ret_sts_error;

Line 1230: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_BAD_OFFER_TYPE');

1226: ) = FND_API.g_false
1227: THEN
1228: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1229: THEN
1230: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_BAD_OFFER_TYPE');
1231: FND_MSG_PUB.add;
1232: END IF;
1233: x_return_status := FND_API.g_ret_sts_error;
1234: RETURN;

Line 1249: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_BAD_STATUS');

1245: ) = FND_API.g_false
1246: THEN
1247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1248: THEN
1249: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_BAD_STATUS');
1250: FND_MSG_PUB.add;
1251: END IF;
1252: x_return_status := FND_API.g_ret_sts_error;
1253: RETURN;

Line 1268: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_BAD_PAYMENT');

1264: ) = FND_API.g_false
1265: THEN
1266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1267: THEN
1268: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_BAD_PAYMENT');
1269: FND_MSG_PUB.add;
1270: END IF;
1271: x_return_status := FND_API.g_ret_sts_error;
1272: RETURN;

Line 1403: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_START_AFTER_END');

1399: -- check offer dates
1400: IF p_complete_rec.start_date > p_complete_rec.end_date THEN
1401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1402: THEN
1403: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_START_AFTER_END');
1404: FND_MSG_PUB.add;
1405: END IF;
1406: x_return_status := FND_API.g_ret_sts_error;
1407: END IF;

Line 1412: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_ORDER_DATES');

1408:
1409: IF p_complete_rec.order_date_from > p_complete_rec.order_date_to THEN
1410: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1411: THEN
1412: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_ORDER_DATES');
1413: FND_MSG_PUB.add;
1414: END IF;
1415: x_return_status := FND_API.g_ret_sts_error;
1416: END IF;

Line 1421: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_SHIP_DATES');

1417:
1418: IF p_complete_rec.ship_date_from > p_complete_rec.ship_date_to THEN
1419: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1420: THEN
1421: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_SHIP_DATES');
1422: FND_MSG_PUB.add;
1423: END IF;
1424: x_return_status := FND_API.g_ret_sts_error;
1425: END IF;

Line 1430: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_PERF_DATES');

1426:
1427: IF p_complete_rec.perf_date_from > p_complete_rec.perf_date_to THEN
1428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1429: THEN
1430: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_PERF_DATES');
1431: FND_MSG_PUB.add;
1432: END IF;
1433: x_return_status := FND_API.g_ret_sts_error;
1434: END IF;

Line 1444: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_CAMP_EXPIRED');

1440: CLOSE c_active;
1441:
1442: IF l_active = 0 THEN
1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1444: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_CAMP_EXPIRED');
1445: FND_MSG_PUB.add;
1446: END IF;
1447: x_return_status := FND_API.g_ret_sts_error;
1448: RETURN;

Line 1460: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_PRI_OFFER_EXISTS');

1456: FETCH c_primary_offer_count1 INTO l_primary_offer_count;
1457: IF l_primary_offer_count <> 0 THEN
1458: CLOSE c_primary_offer_count1;
1459: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1460: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_PRI_OFFER_EXISTS');
1461: FND_MSG_PUB.add;
1462: END IF;
1463:
1464: x_return_status := FND_API.g_ret_sts_error;

Line 1474: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_PRI_OFFER_EXISTS');

1470: FETCH c_primary_offer_count2 INTO l_primary_offer_count;
1471: IF l_primary_offer_count <> 0 THEN
1472: CLOSE c_primary_offer_count2;
1473: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1474: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_PRI_OFFER_EXISTS');
1475: FND_MSG_PUB.add;
1476: END IF;
1477:
1478: x_return_status := FND_API.g_ret_sts_error;

Line 1518: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

1514: FETCH c_act_offer INTO l_act_offer_rec;
1515: IF (c_act_offer%NOTFOUND) THEN
1516: CLOSE c_act_offer;
1517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1518: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1519: FND_MSG_PUB.add;
1520: END IF;
1521: RAISE FND_API.g_exc_error;
1522: END IF;