DBA Data[Home] [Help]

APPS.OZF_TRADE_PROFILE_PVT dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1364: IF p_trade_profile_rec.payment_method = 'CHECK' THEN
1365: IF p_trade_profile_rec.vendor_id = FND_API.g_miss_num OR
1366: p_trade_profile_rec.vendor_id IS NULL THEN
1367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1368: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_VENDOR_MISSING');
1369: FND_MSG_PUB.add;
1370: END IF;
1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1372: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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