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_SUPP_TRADE_PROFILE_PVT dependencies on FND_MSG_PUB

Line 28: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

24: -- ===============================================================
25: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_SUPP_TRADE_PROFILE_PVT';
26: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvstpb.pls';
27:
28: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
29:
30: CURSOR g_functional_currency_code_csr IS
31: SELECT gs.currency_code
32: FROM gl_sets_of_books gs,

Line 818: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

814:
815: EXCEPTION
816: WHEN OTHERS THEN
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
819: THEN
820: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
821: END IF;
822: END populate_supp_defaults;

Line 820: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

816: WHEN OTHERS THEN
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
819: THEN
820: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
821: END IF;
822: END populate_supp_defaults;
823: --------------------------------------------------------------------------------
824: PROCEDURE Create_Supp_Trade_Profile(

Line 893: FND_MSG_PUB.initialize;

889:
890: -- Initialize message list if p_init_msg_list is set to TRUE.
891: IF FND_API.to_Boolean( p_init_msg_list )
892: THEN
893: FND_MSG_PUB.initialize;
894: END IF;
895: -- Initialize API return status to SUCCESS
896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897: -- Local variable initialization

Line 919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

915: -- Validate Environment
916: -- =========================================================================
917: IF FND_GLOBAL.User_Id IS NULL
918: THEN
919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
920: FND_MESSAGE.set_name('OZF', 'OZF_USER_PROFILE_MISSING');
921: FND_MSG_PUB.add;
922: END IF;
923: RAISE FND_API.G_EXC_ERROR;

Line 921: FND_MSG_PUB.add;

917: IF FND_GLOBAL.User_Id IS NULL
918: THEN
919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
920: FND_MESSAGE.set_name('OZF', 'OZF_USER_PROFILE_MISSING');
921: FND_MSG_PUB.add;
922: END IF;
923: RAISE FND_API.G_EXC_ERROR;
924: END IF;
925:

Line 1083: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1079: x_supp_trade_profile_id := l_supp_trade_profile_id ;
1080:
1081: EXCEPTION
1082: WHEN OTHERS THEN
1083: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1084: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
1085: FND_MSG_PUB.add;
1086: END IF;
1087:

Line 1085: FND_MSG_PUB.add;

1081: EXCEPTION
1082: WHEN OTHERS THEN
1083: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1084: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
1085: FND_MSG_PUB.add;
1086: END IF;
1087:
1088: RAISE FND_API.G_EXC_ERROR;
1089: END;

Line 1106: FND_MSG_PUB.Count_And_Get

1102: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1103: END IF;
1104:
1105: -- Standard call to get message count and if count is 1, get message info.
1106: FND_MSG_PUB.Count_And_Get
1107: (p_count => x_msg_count,
1108: p_data => x_msg_data
1109: );
1110:

Line 1114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1110:
1111: EXCEPTION
1112: WHEN OZF_Utility_PVT.resource_locked THEN
1113: x_return_status := FND_API.g_ret_sts_error;
1114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1115: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
1116: FND_MSG_PUB.add;
1117: END IF;
1118: WHEN FND_API.G_EXC_ERROR THEN

Line 1116: FND_MSG_PUB.add;

1112: WHEN OZF_Utility_PVT.resource_locked THEN
1113: x_return_status := FND_API.g_ret_sts_error;
1114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1115: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
1116: FND_MSG_PUB.add;
1117: END IF;
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1120: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1122: FND_MSG_PUB.Count_And_Get (

1118: WHEN FND_API.G_EXC_ERROR THEN
1119: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1120: x_return_status := FND_API.G_RET_STS_ERROR;
1121: -- Standard call to get message count and if count=1, get the message
1122: FND_MSG_PUB.Count_And_Get (
1123: p_encoded => FND_API.G_FALSE,
1124: p_count => x_msg_count,
1125: p_data => x_msg_data
1126: );

Line 1131: FND_MSG_PUB.Count_And_Get (

1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: -- Standard call to get message count and if count=1, get the message
1131: FND_MSG_PUB.Count_And_Get (
1132: p_encoded => FND_API.G_FALSE,
1133: p_count => x_msg_count,
1134: p_data => x_msg_data
1135: );

Line 1139: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1135: );
1136: WHEN OTHERS THEN
1137: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1139: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1140: THEN
1141: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1142: END IF;
1143: -- Standard call to get message count and if count=1, get the message

Line 1141: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1137: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1139: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1140: THEN
1141: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1142: END IF;
1143: -- Standard call to get message count and if count=1, get the message
1144: FND_MSG_PUB.Count_And_Get (
1145: p_encoded => FND_API.G_FALSE,

Line 1144: FND_MSG_PUB.Count_And_Get (

1140: THEN
1141: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1142: END IF;
1143: -- Standard call to get message count and if count=1, get the message
1144: FND_MSG_PUB.Count_And_Get (
1145: p_encoded => FND_API.G_FALSE,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data
1148: );

Line 1215: FND_MSG_PUB.initialize;

1211: END IF;
1212: -- Initialize message list if p_init_msg_list is set to TRUE.
1213: IF FND_API.to_Boolean( p_init_msg_list )
1214: THEN
1215: FND_MSG_PUB.initialize;
1216: END IF;
1217: -- Debug Message
1218: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1219: -- Initialize API return status to SUCCESS

Line 1230: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1226: END IF;
1227: OPEN c_supp_trade;
1228: FETCH c_supp_trade INTO l_ref_supp_trade_profile_rec;
1229: IF ( c_supp_trade%NOTFOUND) THEN
1230: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1231: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1232: FND_MSG_PUB.add;
1233: END IF;
1234: RAISE FND_API.G_EXC_ERROR;

Line 1232: FND_MSG_PUB.add;

1228: FETCH c_supp_trade INTO l_ref_supp_trade_profile_rec;
1229: IF ( c_supp_trade%NOTFOUND) THEN
1230: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1231: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1232: FND_MSG_PUB.add;
1233: END IF;
1234: RAISE FND_API.G_EXC_ERROR;
1235: END IF;
1236: CLOSE c_supp_trade;

Line 1244: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1240: END IF;
1241:
1242: IF (l_tar_supp_trade_profile_rec.object_version_number is NULL or
1243: l_tar_supp_trade_profile_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1244: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1245: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
1246: FND_MSG_PUB.add;
1247: END IF;
1248: raise FND_API.G_EXC_ERROR;

Line 1246: FND_MSG_PUB.add;

1242: IF (l_tar_supp_trade_profile_rec.object_version_number is NULL or
1243: l_tar_supp_trade_profile_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1244: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1245: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
1246: FND_MSG_PUB.add;
1247: END IF;
1248: raise FND_API.G_EXC_ERROR;
1249: End if;
1250:

Line 1468: FND_MSG_PUB.Count_And_Get

1464: IF g_debug THEN
1465: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1466: END IF;
1467: -- Standard call to get message count and if count is 1, get message info.
1468: FND_MSG_PUB.Count_And_Get
1469: (p_count => x_msg_count,
1470: p_data => x_msg_data
1471: );
1472: EXCEPTION

Line 1475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1471: );
1472: EXCEPTION
1473: WHEN OZF_Utility_PVT.resource_locked THEN
1474: x_return_status := FND_API.g_ret_sts_error;
1475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1476: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1477: FND_MSG_PUB.add;
1478: END IF;
1479: WHEN FND_API.G_EXC_ERROR THEN

Line 1477: FND_MSG_PUB.add;

1473: WHEN OZF_Utility_PVT.resource_locked THEN
1474: x_return_status := FND_API.g_ret_sts_error;
1475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1476: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1477: FND_MSG_PUB.add;
1478: END IF;
1479: WHEN FND_API.G_EXC_ERROR THEN
1480: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1481: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1483: FND_MSG_PUB.Count_And_Get (

1479: WHEN FND_API.G_EXC_ERROR THEN
1480: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1481: x_return_status := FND_API.G_RET_STS_ERROR;
1482: -- Standard call to get message count and if count=1, get the message
1483: FND_MSG_PUB.Count_And_Get (
1484: p_encoded => FND_API.G_FALSE,
1485: p_count => x_msg_count,
1486: p_data => x_msg_data
1487: );

Line 1492: FND_MSG_PUB.Count_And_Get (

1488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1489: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1491: -- Standard call to get message count and if count=1, get the message
1492: FND_MSG_PUB.Count_And_Get (
1493: p_encoded => FND_API.G_FALSE,
1494: p_count => x_msg_count,
1495: p_data => x_msg_data
1496: );

Line 1500: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1496: );
1497: WHEN OTHERS THEN
1498: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1501: THEN
1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1503: END IF;
1504: -- Standard call to get message count and if count=1, get the message

Line 1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1498: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1501: THEN
1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1503: END IF;
1504: -- Standard call to get message count and if count=1, get the message
1505: FND_MSG_PUB.Count_And_Get (
1506: p_encoded => FND_API.G_FALSE,

Line 1505: FND_MSG_PUB.Count_And_Get (

1501: THEN
1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1503: END IF;
1504: -- Standard call to get message count and if count=1, get the message
1505: FND_MSG_PUB.Count_And_Get (
1506: p_encoded => FND_API.G_FALSE,
1507: p_count => x_msg_count,
1508: p_data => x_msg_data
1509: );

Line 1543: FND_MSG_PUB.initialize;

1539: END IF;
1540: -- Initialize message list if p_init_msg_list is set to TRUE.
1541: IF FND_API.to_Boolean( p_init_msg_list )
1542: THEN
1543: FND_MSG_PUB.initialize;
1544: END IF;
1545: -- Debug Message
1546: IF g_debug THEN
1547: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 1571: FND_MSG_PUB.Count_And_Get

1567: IF g_debug THEN
1568: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1569: END IF;
1570: -- Standard call to get message count and if count is 1, get message info.
1571: FND_MSG_PUB.Count_And_Get
1572: (p_count => x_msg_count,
1573: p_data => x_msg_data
1574: );
1575:

Line 1579: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1575:
1576: EXCEPTION
1577: WHEN OZF_Utility_PVT.resource_locked THEN
1578: x_return_status := FND_API.g_ret_sts_error;
1579: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1580: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
1581: FND_MSG_PUB.add;
1582: END IF;
1583: WHEN FND_API.G_EXC_ERROR THEN

Line 1581: FND_MSG_PUB.add;

1577: WHEN OZF_Utility_PVT.resource_locked THEN
1578: x_return_status := FND_API.g_ret_sts_error;
1579: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1580: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
1581: FND_MSG_PUB.add;
1582: END IF;
1583: WHEN FND_API.G_EXC_ERROR THEN
1584: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1585: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1587: FND_MSG_PUB.Count_And_Get (

1583: WHEN FND_API.G_EXC_ERROR THEN
1584: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1585: x_return_status := FND_API.G_RET_STS_ERROR;
1586: -- Standard call to get message count and if count=1, get the message
1587: FND_MSG_PUB.Count_And_Get (
1588: p_encoded => FND_API.G_FALSE,
1589: p_count => x_msg_count,
1590: p_data => x_msg_data
1591: );

Line 1597: FND_MSG_PUB.Count_And_Get (

1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1596: -- Standard call to get message count and if count=1, get the message
1597: FND_MSG_PUB.Count_And_Get (
1598: p_encoded => FND_API.G_FALSE,
1599: p_count => x_msg_count,
1600: p_data => x_msg_data
1601: );

Line 1605: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1601: );
1602: WHEN OTHERS THEN
1603: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1605: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1606: THEN
1607: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1608: END IF;
1609: -- Standard call to get message count and if count=1, get the message

Line 1607: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1603: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1605: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1606: THEN
1607: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1608: END IF;
1609: -- Standard call to get message count and if count=1, get the message
1610: FND_MSG_PUB.Count_And_Get (
1611: p_encoded => FND_API.G_FALSE,

Line 1610: FND_MSG_PUB.Count_And_Get (

1606: THEN
1607: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1608: END IF;
1609: -- Standard call to get message count and if count=1, get the message
1610: FND_MSG_PUB.Count_And_Get (
1611: p_encoded => FND_API.G_FALSE,
1612: p_count => x_msg_count,
1613: p_data => x_msg_data
1614: );

Line 1647: FND_MSG_PUB.initialize;

1643:
1644: -- Initialize message list if p_init_msg_list is set to TRUE.
1645: IF FND_API.to_Boolean( p_init_msg_list )
1646: THEN
1647: FND_MSG_PUB.initialize;
1648: END IF;
1649:
1650: -- Standard call to check for call compatibility.
1651: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1668: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1664: OPEN c_Supp_Trade_Profile;
1665: FETCH c_Supp_Trade_Profile INTO l_SUPP_TRADE_PROFILE_ID;
1666: IF (c_Supp_Trade_Profile%NOTFOUND) THEN
1667: CLOSE c_Supp_Trade_Profile;
1668: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1669: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1670: FND_MSG_PUB.add;
1671: END IF;
1672: RAISE FND_API.g_exc_error;

Line 1670: FND_MSG_PUB.add;

1666: IF (c_Supp_Trade_Profile%NOTFOUND) THEN
1667: CLOSE c_Supp_Trade_Profile;
1668: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1669: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1670: FND_MSG_PUB.add;
1671: END IF;
1672: RAISE FND_API.g_exc_error;
1673: END IF;
1674: CLOSE c_Supp_Trade_Profile;

Line 1676: FND_MSG_PUB.count_and_get(

1672: RAISE FND_API.g_exc_error;
1673: END IF;
1674: CLOSE c_Supp_Trade_Profile;
1675: -------------------- finish --------------------------
1676: FND_MSG_PUB.count_and_get(
1677: p_encoded => FND_API.g_false,
1678: p_count => x_msg_count,
1679: p_data => x_msg_data);
1680: IF g_debug THEN

Line 1686: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

Line 1688: FND_MSG_PUB.add;

1684: WHEN OZF_Utility_PVT.resource_locked THEN
1685: x_return_status := FND_API.g_ret_sts_error;
1686: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1687: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES LOCKED');
1688: FND_MSG_PUB.add;
1689: END IF;
1690: WHEN FND_API.G_EXC_ERROR THEN
1691: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1692: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1694: FND_MSG_PUB.Count_And_Get (

1690: WHEN FND_API.G_EXC_ERROR THEN
1691: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1692: x_return_status := FND_API.G_RET_STS_ERROR;
1693: -- Standard call to get message count and if count=1, get the message
1694: FND_MSG_PUB.Count_And_Get (
1695: p_encoded => FND_API.G_FALSE,
1696: p_count => x_msg_count,
1697: p_data => x_msg_data
1698: );

Line 1703: FND_MSG_PUB.Count_And_Get (

1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1700: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1702: -- Standard call to get message count and if count=1, get the message
1703: FND_MSG_PUB.Count_And_Get (
1704: p_encoded => FND_API.G_FALSE,
1705: p_count => x_msg_count,
1706: p_data => x_msg_data
1707: );

Line 1711: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1707: );
1708: WHEN OTHERS THEN
1709: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1711: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1712: THEN
1713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1714: END IF;
1715: -- Standard call to get message count and if count=1, get the message

Line 1713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1709: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1711: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1712: THEN
1713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1714: END IF;
1715: -- Standard call to get message count and if count=1, get the message
1716: FND_MSG_PUB.Count_And_Get (
1717: p_encoded => FND_API.G_FALSE,

Line 1716: FND_MSG_PUB.Count_And_Get (

1712: THEN
1713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1714: END IF;
1715: -- Standard call to get message count and if count=1, get the message
1716: FND_MSG_PUB.Count_And_Get (
1717: p_encoded => FND_API.G_FALSE,
1718: p_count => x_msg_count,
1719: p_data => x_msg_data
1720: );

Line 1774: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1770: END IF; -- end of p_validation_mode = create
1771: END IF;
1772: --Seed the message OZF_SUPP_TRADE_DUPLICATE
1773: IF l_valid_flag = FND_API.g_false THEN
1774: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1775: FND_MESSAGE.set_name('OZF', 'OZF_SUPP_TRADE_PROFILE_DUPLIC');
1776: FND_MSG_PUB.add;
1777: END IF;
1778: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1776: FND_MSG_PUB.add;

1772: --Seed the message OZF_SUPP_TRADE_DUPLICATE
1773: IF l_valid_flag = FND_API.g_false THEN
1774: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1775: FND_MESSAGE.set_name('OZF', 'OZF_SUPP_TRADE_PROFILE_DUPLIC');
1776: FND_MSG_PUB.add;
1777: END IF;
1778: x_return_status := FND_API.G_RET_STS_ERROR;
1779: END IF;
1780: END check_supp_trd_prfl_uk_items;

Line 1804: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1800:
1801: IF p_supp_trade_profile_rec.supplier_id = FND_API.g_miss_num OR
1802: p_supp_trade_profile_rec.supplier_id IS NULL
1803: THEN
1804: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1805: FND_MESSAGE.set_name('OZF', 'OZF_SUPPLIER_MISSING');
1806: FND_MSG_PUB.add;
1807: END IF;
1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1806: FND_MSG_PUB.add;

1802: p_supp_trade_profile_rec.supplier_id IS NULL
1803: THEN
1804: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1805: FND_MESSAGE.set_name('OZF', 'OZF_SUPPLIER_MISSING');
1806: FND_MSG_PUB.add;
1807: END IF;
1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1809: END IF;
1810: IF p_supp_trade_profile_rec.supplier_site_id = FND_API.g_miss_num OR

Line 1813: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1809: END IF;
1810: IF p_supp_trade_profile_rec.supplier_site_id = FND_API.g_miss_num OR
1811: p_supp_trade_profile_rec.supplier_site_id IS NULL
1812: THEN
1813: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1814: FND_MESSAGE.set_name('OZF', 'OZF_SUPPLIER_SITE_MISSING');
1815: FND_MSG_PUB.add;
1816: END IF;
1817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1815: FND_MSG_PUB.add;

1811: p_supp_trade_profile_rec.supplier_site_id IS NULL
1812: THEN
1813: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1814: FND_MESSAGE.set_name('OZF', 'OZF_SUPPLIER_SITE_MISSING');
1815: FND_MSG_PUB.add;
1816: END IF;
1817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1818: END IF;
1819:

Line 1823: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1819:
1820: IF p_supp_trade_profile_rec.party_id = FND_API.g_miss_num OR
1821: p_supp_trade_profile_rec.party_id IS NULL
1822: THEN
1823: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1824: FND_MESSAGE.set_name('OZF', 'OZF_CUSTOMER_MISSING');
1825: FND_MSG_PUB.add;
1826: END IF;
1827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1825: FND_MSG_PUB.add;

1821: p_supp_trade_profile_rec.party_id IS NULL
1822: THEN
1823: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1824: FND_MESSAGE.set_name('OZF', 'OZF_CUSTOMER_MISSING');
1825: FND_MSG_PUB.add;
1826: END IF;
1827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1828: END IF;
1829: IF p_supp_trade_profile_rec.cust_account_id = FND_API.g_miss_num OR

Line 1832: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1828: END IF;
1829: IF p_supp_trade_profile_rec.cust_account_id = FND_API.g_miss_num OR
1830: p_supp_trade_profile_rec.cust_account_id IS NULL
1831: THEN
1832: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1833: FND_MESSAGE.set_name('OZF', 'OZF_CUSTOMER_ACCOUNT_MISSING');
1834: FND_MSG_PUB.add;
1835: END IF;
1836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1834: FND_MSG_PUB.add;

1830: p_supp_trade_profile_rec.cust_account_id IS NULL
1831: THEN
1832: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1833: FND_MESSAGE.set_name('OZF', 'OZF_CUSTOMER_ACCOUNT_MISSING');
1834: FND_MSG_PUB.add;
1835: END IF;
1836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1837: END IF;
1838:

Line 1940: FND_MSG_PUB.initialize;

1936: END IF;
1937: -- Initialize message list if p_init_msg_list is set to TRUE.
1938: IF FND_API.to_Boolean( p_init_msg_list )
1939: THEN
1940: FND_MSG_PUB.initialize;
1941: END IF;
1942: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1943: Check_supp_trd_prfl_Items(
1944: p_supp_trade_profile_rec => p_supp_trade_profile_rec,

Line 1973: FND_MSG_PUB.Count_And_Get

1969:
1970: -- Initialize API return status to SUCCESS
1971: x_return_status := FND_API.G_RET_STS_SUCCESS;
1972: -- Standard call to get message count and if count is 1, get message info.
1973: FND_MSG_PUB.Count_And_Get
1974: (p_count => x_msg_count,
1975: p_data => x_msg_data
1976: );
1977: EXCEPTION

Line 1980: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1976: );
1977: EXCEPTION
1978: WHEN OZF_Utility_PVT.resource_locked THEN
1979: x_return_status := FND_API.g_ret_sts_error;
1980: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1981: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
1982: FND_MSG_PUB.add;
1983: END IF;
1984: WHEN FND_API.G_EXC_ERROR THEN

Line 1982: FND_MSG_PUB.add;

1978: WHEN OZF_Utility_PVT.resource_locked THEN
1979: x_return_status := FND_API.g_ret_sts_error;
1980: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1981: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
1982: FND_MSG_PUB.add;
1983: END IF;
1984: WHEN FND_API.G_EXC_ERROR THEN
1985: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
1986: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1988: FND_MSG_PUB.Count_And_Get (

1984: WHEN FND_API.G_EXC_ERROR THEN
1985: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
1986: x_return_status := FND_API.G_RET_STS_ERROR;
1987: -- Standard call to get message count and if count=1, get the message
1988: FND_MSG_PUB.Count_And_Get (
1989: p_encoded => FND_API.G_FALSE,
1990: p_count => x_msg_count,
1991: p_data => x_msg_data
1992: );

Line 1997: FND_MSG_PUB.Count_And_Get (

1993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1994: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
1995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1996: -- Standard call to get message count and if count=1, get the message
1997: FND_MSG_PUB.Count_And_Get (
1998: p_encoded => FND_API.G_FALSE,
1999: p_count => x_msg_count,
2000: p_data => x_msg_data
2001: );

Line 2005: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2001: );
2002: WHEN OTHERS THEN
2003: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
2004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2005: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2006: THEN
2007: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2008: END IF;
2009: -- Standard call to get message count and if count=1, get the message

Line 2007: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2003: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
2004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2005: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2006: THEN
2007: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2008: END IF;
2009: -- Standard call to get message count and if count=1, get the message
2010: FND_MSG_PUB.Count_And_Get (
2011: p_encoded => FND_API.G_FALSE,

Line 2010: FND_MSG_PUB.Count_And_Get (

2006: THEN
2007: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2008: END IF;
2009: -- Standard call to get message count and if count=1, get the message
2010: FND_MSG_PUB.Count_And_Get (
2011: p_encoded => FND_API.G_FALSE,
2012: p_count => x_msg_count,
2013: p_data => x_msg_data
2014: );

Line 2030: FND_MSG_PUB.initialize;

2026: BEGIN
2027: -- Initialize message list if p_init_msg_list is set to TRUE.
2028: IF FND_API.to_Boolean( p_init_msg_list )
2029: THEN
2030: FND_MSG_PUB.initialize;
2031: END IF;
2032:
2033: -- Initialize API return status to SUCCESS
2034: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2041: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2037: IF p_supp_trade_profile_rec.default_days_covered is not null and
2038: ( p_supp_trade_profile_rec.default_days_covered > 9999 or
2039: p_supp_trade_profile_rec.default_days_covered < 0)
2040: THEN
2041: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2042: FND_MESSAGE.set_name('OZF', 'OZF_DEFAULT_DAYS_INVALID_VAL');
2043: FND_MSG_PUB.add;
2044: END IF;
2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2043: FND_MSG_PUB.add;

2039: p_supp_trade_profile_rec.default_days_covered < 0)
2040: THEN
2041: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2042: FND_MESSAGE.set_name('OZF', 'OZF_DEFAULT_DAYS_INVALID_VAL');
2043: FND_MSG_PUB.add;
2044: END IF;
2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2046: END IF ;
2047: -- Hint: qty_increase_tolerance shd lie in 1-100

Line 2053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2049: (p_supp_trade_profile_rec.qty_increase_tolerance > 100 or
2050: p_supp_trade_profile_rec.qty_increase_tolerance < 0)
2051: THEN
2052: x_return_status := FND_API.G_RET_STS_ERROR;
2053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2054: FND_MESSAGE.set_name('OZF', 'OZF_QTY_INC_TOLERANCE_INVALID');
2055: FND_MSG_PUB.add;
2056: END IF;
2057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2055: FND_MSG_PUB.add;

2051: THEN
2052: x_return_status := FND_API.G_RET_STS_ERROR;
2053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2054: FND_MESSAGE.set_name('OZF', 'OZF_QTY_INC_TOLERANCE_INVALID');
2055: FND_MSG_PUB.add;
2056: END IF;
2057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2058: END IF ;
2059: IF p_supp_trade_profile_rec.grace_days is not null and

Line 2064: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2060: ( p_supp_trade_profile_rec.grace_days > 9999 or
2061: p_supp_trade_profile_rec.grace_days < 0)
2062: THEN
2063: x_return_status := FND_API.G_RET_STS_ERROR;
2064: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2065: FND_MESSAGE.set_name('OZF', 'OZF_GRACE_DAYS_INVALID_VAL');
2066: FND_MSG_PUB.add;
2067: END IF;
2068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2066: FND_MSG_PUB.add;

2062: THEN
2063: x_return_status := FND_API.G_RET_STS_ERROR;
2064: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2065: FND_MESSAGE.set_name('OZF', 'OZF_GRACE_DAYS_INVALID_VAL');
2066: FND_MSG_PUB.add;
2067: END IF;
2068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2069: END IF ;
2070: IF p_supp_trade_profile_rec.authorization_period is not null and

Line 2075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2071: (p_supp_trade_profile_rec.authorization_period > 9999 or
2072: p_supp_trade_profile_rec.authorization_period < 0)
2073: THEN
2074: x_return_status := FND_API.G_RET_STS_ERROR;
2075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2076: FND_MESSAGE.set_name('OZF', 'OZF_AUTH_PERIOD_INVALID_VAL');
2077: FND_MSG_PUB.add;
2078: END IF;
2079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2077: FND_MSG_PUB.add;

2073: THEN
2074: x_return_status := FND_API.G_RET_STS_ERROR;
2075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2076: FND_MESSAGE.set_name('OZF', 'OZF_AUTH_PERIOD_INVALID_VAL');
2077: FND_MSG_PUB.add;
2078: END IF;
2079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2080: END IF ;
2081: --gdeepika 2/21/2008 claim frequency cannot be negetive--

Line 2086: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2082: IF p_supp_trade_profile_rec.claim_frequency is not null and
2083: p_supp_trade_profile_rec.claim_frequency < 0
2084: THEN
2085: x_return_status := FND_API.G_RET_STS_ERROR;
2086: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2087: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_FREQ_NEG');
2088: FND_MSG_PUB.add;
2089: END IF;
2090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2088: FND_MSG_PUB.add;

2084: THEN
2085: x_return_status := FND_API.G_RET_STS_ERROR;
2086: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2087: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_FREQ_NEG');
2088: FND_MSG_PUB.add;
2089: END IF;
2090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2091: END IF ;
2092: --2/22/2008 gdeepika- claim amount thresholds cannot be negative -6839040

Line 2097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2093: IF(p_supp_trade_profile_rec.min_claim_amt IS NOT null)
2094: THEN
2095: IF (p_supp_trade_profile_rec.min_claim_amt < 0)
2096: THEN
2097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2098: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AMT_INVALID');
2099: FND_MSG_PUB.add;
2100: END IF;
2101: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2099: FND_MSG_PUB.add;

2095: IF (p_supp_trade_profile_rec.min_claim_amt < 0)
2096: THEN
2097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2098: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AMT_INVALID');
2099: FND_MSG_PUB.add;
2100: END IF;
2101: x_return_status := FND_API.G_RET_STS_ERROR;
2102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2103: END IF ;

Line 2110: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2106: IF( p_supp_trade_profile_rec.min_claim_amt_line_lvl IS NOT null )
2107: THEN
2108: IF (p_supp_trade_profile_rec.min_claim_amt_line_lvl < 0)
2109: THEN
2110: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2111: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NEG');
2112: FND_MSG_PUB.add;
2113: END IF;
2114: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2112: FND_MSG_PUB.add;

2108: IF (p_supp_trade_profile_rec.min_claim_amt_line_lvl < 0)
2109: THEN
2110: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2111: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NEG');
2112: FND_MSG_PUB.add;
2113: END IF;
2114: x_return_status := FND_API.G_RET_STS_ERROR;
2115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2116: END IF ;

Line 2127: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2123: THEN
2124:
2125: IF (p_supp_trade_profile_rec.min_claim_amt < p_supp_trade_profile_rec.min_claim_amt_line_lvl)
2126: THEN
2127: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2128: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AMT_ERROR');
2129: FND_MSG_PUB.add;
2130: END IF;
2131: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2129: FND_MSG_PUB.add;

2125: IF (p_supp_trade_profile_rec.min_claim_amt < p_supp_trade_profile_rec.min_claim_amt_line_lvl)
2126: THEN
2127: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2128: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AMT_ERROR');
2129: FND_MSG_PUB.add;
2130: END IF;
2131: x_return_status := FND_API.G_RET_STS_ERROR;
2132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2133: END IF ;

Line 2141: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2137: p_supp_trade_profile_rec.days_before_claiming_debit > 9999 or
2138: p_supp_trade_profile_rec.days_before_claiming_debit < 0
2139: THEN
2140: x_return_status := FND_API.G_RET_STS_ERROR;
2141: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2142: FND_MESSAGE.set_name('OZF', 'OZF_DAYS_BEF_CLAIMING_DEBIT');
2143: FND_MSG_PUB.add;
2144: END IF;
2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2143: FND_MSG_PUB.add;

2139: THEN
2140: x_return_status := FND_API.G_RET_STS_ERROR;
2141: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2142: FND_MESSAGE.set_name('OZF', 'OZF_DAYS_BEF_CLAIMING_DEBIT');
2143: FND_MSG_PUB.add;
2144: END IF;
2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2146: END IF ;
2147: -- Debug Message

Line 2152: FND_MSG_PUB.Count_And_Get

2148: IF g_debug THEN
2149: OZF_UTILITY_PVT.debug_message('Private API: Validate the trade profile record');
2150: END IF;
2151: -- Standard call to get message count and if count is 1, get message info.
2152: FND_MSG_PUB.Count_And_Get
2153: (p_count => x_msg_count,
2154: p_data => x_msg_data
2155: );
2156: END Validate_supp_trd_prfl_rec;