DBA Data[Home] [Help]

APPS.OZF_TRADE_PROFILE_PVT dependencies on FND_MESSAGE

Line 50: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_PROFILE_MISSING');

46: FETCH c_trade INTO l_trade_profile_rec;
47: IF c_trade%NOTFOUND THEN
48: CLOSE c_trade;
49: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
50: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_PROFILE_MISSING');
51: FND_MSG_PUB.add;
52: END IF;
53: RAISE FND_API.g_exc_error;
54: END IF;

Line 511: FND_MESSAGE.set_name('OZF', 'OZF_USER_PROFILE_MISSING');

507: -- =========================================================================
508: IF FND_GLOBAL.User_Id IS NULL
509: THEN
510: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
511: FND_MESSAGE.set_name('OZF', 'OZF_USER_PROFILE_MISSING');
512: FND_MSG_PUB.add;
513: END IF;
514: RAISE FND_API.G_EXC_ERROR;
515: END IF;

Line 531: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_CUST_MISSING');

527: IF l_trade_profile_rec.cust_account_id = FND_API.g_miss_num OR
528: l_trade_profile_rec.cust_account_id IS NULL
529: THEN
530: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
531: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_CUST_MISSING');
532: FND_MSG_PUB.add;
533: END IF;
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: ELSE

Line 650: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');

646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
650: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
651: FND_MSG_PUB.add;
652: END IF;
653:
654: RAISE FND_API.G_EXC_ERROR;

Line 681: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');

677: EXCEPTION
678: WHEN OZF_Utility_PVT.resource_locked THEN
679: x_return_status := FND_API.g_ret_sts_error;
680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
681: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
682: FND_MSG_PUB.add;
683: END IF;
684: WHEN FND_API.G_EXC_ERROR THEN
685: ROLLBACK TO CREATE_Trade_Profile_PVT;

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

799: OPEN c_trade;
800: FETCH c_trade INTO l_ref_trade_profile_rec;
801: IF ( c_trade%NOTFOUND) THEN
802: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
803: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
804: FND_MSG_PUB.add;
805: END IF;
806: RAISE FND_API.G_EXC_ERROR;
807: END IF;

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

813:
814: IF (l_tar_trade_profile_rec.object_version_number is NULL or
815: l_tar_trade_profile_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
816: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
817: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
818: FND_MSG_PUB.add;
819: END IF;
820: raise FND_API.G_EXC_ERROR;
821: End if;

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

988: EXCEPTION
989: WHEN OZF_Utility_PVT.resource_locked THEN
990: x_return_status := FND_API.g_ret_sts_error;
991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
992: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
993: FND_MSG_PUB.add;
994: END IF;
995: WHEN FND_API.G_EXC_ERROR THEN
996: ROLLBACK TO UPDATE_Trade_Profile_PVT;

Line 1095: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');

1091: EXCEPTION
1092: WHEN OZF_Utility_PVT.resource_locked THEN
1093: x_return_status := FND_API.g_ret_sts_error;
1094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1095: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
1096: FND_MSG_PUB.add;
1097: END IF;
1098: WHEN FND_API.G_EXC_ERROR THEN
1099: ROLLBACK TO DELETE_Trade_Profile_PVT;

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

1180: FETCH c_Trade_Profile INTO l_TRADE_PROFILE_ID;
1181: IF (c_Trade_Profile%NOTFOUND) THEN
1182: CLOSE c_Trade_Profile;
1183: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1184: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1185: FND_MSG_PUB.add;
1186: END IF;
1187: RAISE FND_API.g_exc_error;
1188: END IF;

Line 1202: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES LOCKED');

1198: EXCEPTION
1199: WHEN OZF_Utility_PVT.resource_locked THEN
1200: x_return_status := FND_API.g_ret_sts_error;
1201: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1202: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES LOCKED');
1203: FND_MSG_PUB.add;
1204: END IF;
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: ROLLBACK TO LOCK_Trade_Profile_PVT;

Line 1323: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_CUST_DUPLICATE');

1319: END IF;
1320:
1321: IF l_valid_flag = FND_API.g_false THEN
1322: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1323: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_CUST_DUPLICATE');
1324: FND_MSG_PUB.add;
1325: END IF;
1326: x_return_status := FND_API.G_RET_STS_ERROR;
1327: END IF;

Line 1359: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_PARTY_MISSING');

1355: IF p_trade_profile_rec.site_use_id = FND_API.g_miss_num OR --For R12.1 Enhancements
1356: p_trade_profile_rec.site_use_id IS NULL
1357: THEN
1358: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1359: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_PARTY_MISSING');
1360: FND_MSG_PUB.add;
1361: END IF;
1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1363: END IF;

Line 1371: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_VENDOR_MISSING');

1367: IF p_trade_profile_rec.payment_method IN ('CHECK','EFT','WIRE','AP_DEBIT','AP_DEFAULT') THEN
1368: IF p_trade_profile_rec.vendor_id = FND_API.g_miss_num OR
1369: p_trade_profile_rec.vendor_id IS NULL THEN
1370: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1371: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_VENDOR_MISSING');
1372: FND_MSG_PUB.add;
1373: END IF;
1374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1375: END IF;

Line 1380: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_VENSITE_MISSING');

1376: IF p_trade_profile_rec.vendor_site_id = FND_API.g_miss_num OR
1377: p_trade_profile_rec.vendor_site_id IS NULL
1378: THEN
1379: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1380: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_VENSITE_MISSING');
1381: FND_MSG_PUB.add;
1382: END IF;
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: END IF;

Line 1390: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_AUTO_MISSING ');

1386: IF p_trade_profile_rec.autopay_flag = FND_API.g_miss_char OR
1387: p_trade_profile_rec.autopay_flag IS NULL
1388: THEN
1389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1390: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_AUTO_MISSING ');
1391: FND_MSG_PUB.add;
1392: END IF;
1393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1394: END IF;

Line 1401: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_INTERNET_MISSING');

1397: IF p_trade_profile_rec.autopay_flag = FND_API.g_miss_char OR
1398: p_trade_profile_rec.internet_deal_view_flag IS NULL
1399: THEN
1400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1401: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_INTERNET_MISSING');
1402: FND_MSG_PUB.add;
1403: END IF;
1404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1405: END IF;

Line 1410: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_PRINT_MISSING');

1406: IF p_trade_profile_rec.autopay_flag = FND_API.g_miss_char OR
1407: p_trade_profile_rec.print_flag IS NULL
1408: THEN
1409: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1410: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_PRINT_MISSING');
1411: FND_MSG_PUB.add;
1412: END IF;
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;

Line 1423: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_SITE_MISSING');

1419: IF p_trade_profile_rec.site_use_id IS NULL OR
1420: p_trade_profile_rec.site_use_id = FND_API.G_MISS_NUM
1421: THEN
1422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1423: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_SITE_MISSING');
1424: FND_MSG_PUB.add;
1425: END IF;
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1427: END IF;

Line 1438: FND_MESSAGE.set_name('OZF', 'ERROR1');

1434: IF p_trade_profile_rec.claim_currency IS NULL AND
1435: p_trade_profile_rec.claim_threshold IS NULL
1436: THEN
1437: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1438: FND_MESSAGE.set_name('OZF', 'ERROR1');
1439: FND_MSG_PUB.add;
1440: END IF;
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: END IF;

Line 1448: FND_MESSAGE.set_name('OZF', 'ERROR1');

1444: IF p_trade_profile_rec.autopay_periodicity IS NULL OR
1445: p_trade_profile_rec.autopay_periodicity_type IS NULL
1446: THEN
1447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1448: FND_MESSAGE.set_name('OZF', 'ERROR1');
1449: FND_MSG_PUB.add;
1450: END IF;
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: END IF;

Line 1462: FND_MESSAGE.set_name('OZF', 'ERROR3');

1458: IF p_trade_profile_rec.autopay_periodicity IS NULL AND
1459: p_trade_profile_rec.autopay_periodicity_type IS NULL
1460: THEN
1461: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1462: FND_MESSAGE.set_name('OZF', 'ERROR3');
1463: FND_MSG_PUB.add;
1464: END IF;
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: END IF;

Line 1472: FND_MESSAGE.set_name('OZF', 'ERROR4');

1468: IF p_trade_profile_rec.claim_currency IS NULL OR
1469: p_trade_profile_rec.claim_threshold IS NULL
1470: THEN
1471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1472: FND_MESSAGE.set_name('OZF', 'ERROR4');
1473: FND_MSG_PUB.add;
1474: END IF;
1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1476: END IF;

Line 1520: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_TYPE_REQ');

1516: AND p_trade_profile_rec.header_tolerance_operand is not null)
1517: THEN
1518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1519: THEN
1520: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_TYPE_REQ');
1521: FND_MSG_PUB.add;
1522: END IF;
1523: x_return_status := FND_API.g_ret_sts_error;
1524: RETURN;

Line 1530: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_VAL_REQ');

1526: AND p_trade_profile_rec.header_tolerance_operand is null)
1527: THEN
1528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1529: THEN
1530: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_VAL_REQ');
1531: FND_MSG_PUB.add;
1532: END IF;
1533: x_return_status := FND_API.g_ret_sts_error;
1534: RETURN;

Line 1544: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_TYPE_REQ');

1540: AND p_trade_profile_rec.line_tolerance_operand is not null )
1541: THEN
1542: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1543: THEN
1544: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_TYPE_REQ');
1545: FND_MSG_PUB.add;
1546: END IF;
1547: x_return_status := FND_API.g_ret_sts_error;
1548: RETURN;

Line 1554: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_VAL_REQ');

1550: AND p_trade_profile_rec.line_tolerance_operand is null)
1551: THEN
1552: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1553: THEN
1554: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_VAL_REQ');
1555: FND_MSG_PUB.add;
1556: END IF;
1557: x_return_status := FND_API.g_ret_sts_error;
1558: RETURN;

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

1682: EXCEPTION
1683: WHEN OZF_Utility_PVT.resource_locked THEN
1684: x_return_status := FND_API.g_ret_sts_error;
1685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1686: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
1687: FND_MSG_PUB.add;
1688: END IF;
1689: WHEN FND_API.G_EXC_ERROR THEN
1690: ROLLBACK TO VALIDATE_Trade_Profile_PVT;