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 23: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

19: -- ===============================================================
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_SUPP_TRADE_PROFILE_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvstpb.pls';
22:
23: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
24:
25: CURSOR g_functional_currency_code_csr IS
26: SELECT gs.currency_code
27: FROM gl_sets_of_books gs,

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

707:
708: EXCEPTION
709: WHEN OTHERS THEN
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
712: THEN
713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
714: END IF;
715: END populate_supp_defaults;

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

709: WHEN OTHERS THEN
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
712: THEN
713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
714: END IF;
715: END populate_supp_defaults;
716: --------------------------------------------------------------------------------
717: PROCEDURE Create_Supp_Trade_Profile(

Line 786: FND_MSG_PUB.initialize;

782:
783: -- Initialize message list if p_init_msg_list is set to TRUE.
784: IF FND_API.to_Boolean( p_init_msg_list )
785: THEN
786: FND_MSG_PUB.initialize;
787: END IF;
788: -- Initialize API return status to SUCCESS
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790: -- Local variable initialization

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

808: -- Validate Environment
809: -- =========================================================================
810: IF FND_GLOBAL.User_Id IS NULL
811: THEN
812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
813: FND_MESSAGE.set_name('OZF', 'OZF_USER_PROFILE_MISSING');
814: FND_MSG_PUB.add;
815: END IF;
816: RAISE FND_API.G_EXC_ERROR;

Line 814: FND_MSG_PUB.add;

810: IF FND_GLOBAL.User_Id IS NULL
811: THEN
812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
813: FND_MESSAGE.set_name('OZF', 'OZF_USER_PROFILE_MISSING');
814: FND_MSG_PUB.add;
815: END IF;
816: RAISE FND_API.G_EXC_ERROR;
817: END IF;
818:

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

960: );
961:
962: EXCEPTION
963: WHEN OTHERS THEN
964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
965: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
966: FND_MSG_PUB.add;
967: END IF;
968:

Line 966: FND_MSG_PUB.add;

962: EXCEPTION
963: WHEN OTHERS THEN
964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
965: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
966: FND_MSG_PUB.add;
967: END IF;
968:
969: RAISE FND_API.G_EXC_ERROR;
970: END;

Line 987: FND_MSG_PUB.Count_And_Get

983: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
984: END IF;
985:
986: -- Standard call to get message count and if count is 1, get message info.
987: FND_MSG_PUB.Count_And_Get
988: (p_count => x_msg_count,
989: p_data => x_msg_data
990: );
991:

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

991:
992: EXCEPTION
993: WHEN OZF_Utility_PVT.resource_locked THEN
994: x_return_status := FND_API.g_ret_sts_error;
995: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
996: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
997: FND_MSG_PUB.add;
998: END IF;
999: WHEN FND_API.G_EXC_ERROR THEN

Line 997: FND_MSG_PUB.add;

993: WHEN OZF_Utility_PVT.resource_locked THEN
994: x_return_status := FND_API.g_ret_sts_error;
995: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
996: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
997: FND_MSG_PUB.add;
998: END IF;
999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1001: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1003: FND_MSG_PUB.Count_And_Get (

999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: -- Standard call to get message count and if count=1, get the message
1003: FND_MSG_PUB.Count_And_Get (
1004: p_encoded => FND_API.G_FALSE,
1005: p_count => x_msg_count,
1006: p_data => x_msg_data
1007: );

Line 1012: FND_MSG_PUB.Count_And_Get (

1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1009: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1011: -- Standard call to get message count and if count=1, get the message
1012: FND_MSG_PUB.Count_And_Get (
1013: p_encoded => FND_API.G_FALSE,
1014: p_count => x_msg_count,
1015: p_data => x_msg_data
1016: );

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

1016: );
1017: WHEN OTHERS THEN
1018: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message

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

1018: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,

Line 1025: FND_MSG_PUB.Count_And_Get (

1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data
1029: );

Line 1096: FND_MSG_PUB.initialize;

1092: END IF;
1093: -- Initialize message list if p_init_msg_list is set to TRUE.
1094: IF FND_API.to_Boolean( p_init_msg_list )
1095: THEN
1096: FND_MSG_PUB.initialize;
1097: END IF;
1098: -- Debug Message
1099: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1100: -- Initialize API return status to SUCCESS

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

1107: END IF;
1108: OPEN c_supp_trade;
1109: FETCH c_supp_trade INTO l_ref_supp_trade_profile_rec;
1110: IF ( c_supp_trade%NOTFOUND) THEN
1111: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1112: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1113: FND_MSG_PUB.add;
1114: END IF;
1115: RAISE FND_API.G_EXC_ERROR;

Line 1113: FND_MSG_PUB.add;

1109: FETCH c_supp_trade INTO l_ref_supp_trade_profile_rec;
1110: IF ( c_supp_trade%NOTFOUND) THEN
1111: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1112: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1113: FND_MSG_PUB.add;
1114: END IF;
1115: RAISE FND_API.G_EXC_ERROR;
1116: END IF;
1117: CLOSE c_supp_trade;

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

1121: END IF;
1122:
1123: IF (l_tar_supp_trade_profile_rec.object_version_number is NULL or
1124: l_tar_supp_trade_profile_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1126: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
1127: FND_MSG_PUB.add;
1128: END IF;
1129: raise FND_API.G_EXC_ERROR;

Line 1127: FND_MSG_PUB.add;

1123: IF (l_tar_supp_trade_profile_rec.object_version_number is NULL or
1124: l_tar_supp_trade_profile_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1126: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
1127: FND_MSG_PUB.add;
1128: END IF;
1129: raise FND_API.G_EXC_ERROR;
1130: End if;
1131:

Line 1337: FND_MSG_PUB.Count_And_Get

1333: IF g_debug THEN
1334: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1335: END IF;
1336: -- Standard call to get message count and if count is 1, get message info.
1337: FND_MSG_PUB.Count_And_Get
1338: (p_count => x_msg_count,
1339: p_data => x_msg_data
1340: );
1341: EXCEPTION

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

1340: );
1341: EXCEPTION
1342: WHEN OZF_Utility_PVT.resource_locked THEN
1343: x_return_status := FND_API.g_ret_sts_error;
1344: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1345: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1346: FND_MSG_PUB.add;
1347: END IF;
1348: WHEN FND_API.G_EXC_ERROR THEN

Line 1346: FND_MSG_PUB.add;

1342: WHEN OZF_Utility_PVT.resource_locked THEN
1343: x_return_status := FND_API.g_ret_sts_error;
1344: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1345: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1346: FND_MSG_PUB.add;
1347: END IF;
1348: WHEN FND_API.G_EXC_ERROR THEN
1349: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1350: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1352: FND_MSG_PUB.Count_And_Get (

1348: WHEN FND_API.G_EXC_ERROR THEN
1349: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: -- Standard call to get message count and if count=1, get the message
1352: FND_MSG_PUB.Count_And_Get (
1353: p_encoded => FND_API.G_FALSE,
1354: p_count => x_msg_count,
1355: p_data => x_msg_data
1356: );

Line 1361: FND_MSG_PUB.Count_And_Get (

1357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1358: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1360: -- Standard call to get message count and if count=1, get the message
1361: FND_MSG_PUB.Count_And_Get (
1362: p_encoded => FND_API.G_FALSE,
1363: p_count => x_msg_count,
1364: p_data => x_msg_data
1365: );

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

1365: );
1366: WHEN OTHERS THEN
1367: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1370: THEN
1371: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1372: END IF;
1373: -- Standard call to get message count and if count=1, get the message

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

1367: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1370: THEN
1371: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1372: END IF;
1373: -- Standard call to get message count and if count=1, get the message
1374: FND_MSG_PUB.Count_And_Get (
1375: p_encoded => FND_API.G_FALSE,

Line 1374: FND_MSG_PUB.Count_And_Get (

1370: THEN
1371: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1372: END IF;
1373: -- Standard call to get message count and if count=1, get the message
1374: FND_MSG_PUB.Count_And_Get (
1375: p_encoded => FND_API.G_FALSE,
1376: p_count => x_msg_count,
1377: p_data => x_msg_data
1378: );

Line 1412: FND_MSG_PUB.initialize;

1408: END IF;
1409: -- Initialize message list if p_init_msg_list is set to TRUE.
1410: IF FND_API.to_Boolean( p_init_msg_list )
1411: THEN
1412: FND_MSG_PUB.initialize;
1413: END IF;
1414: -- Debug Message
1415: IF g_debug THEN
1416: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 1440: FND_MSG_PUB.Count_And_Get

1436: IF g_debug THEN
1437: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1438: END IF;
1439: -- Standard call to get message count and if count is 1, get message info.
1440: FND_MSG_PUB.Count_And_Get
1441: (p_count => x_msg_count,
1442: p_data => x_msg_data
1443: );
1444:

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

1444:
1445: EXCEPTION
1446: WHEN OZF_Utility_PVT.resource_locked THEN
1447: x_return_status := FND_API.g_ret_sts_error;
1448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1449: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
1450: FND_MSG_PUB.add;
1451: END IF;
1452: WHEN FND_API.G_EXC_ERROR THEN

Line 1450: FND_MSG_PUB.add;

1446: WHEN OZF_Utility_PVT.resource_locked THEN
1447: x_return_status := FND_API.g_ret_sts_error;
1448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1449: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
1450: FND_MSG_PUB.add;
1451: END IF;
1452: WHEN FND_API.G_EXC_ERROR THEN
1453: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1454: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1456: FND_MSG_PUB.Count_And_Get (

1452: WHEN FND_API.G_EXC_ERROR THEN
1453: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1454: x_return_status := FND_API.G_RET_STS_ERROR;
1455: -- Standard call to get message count and if count=1, get the message
1456: FND_MSG_PUB.Count_And_Get (
1457: p_encoded => FND_API.G_FALSE,
1458: p_count => x_msg_count,
1459: p_data => x_msg_data
1460: );

Line 1466: FND_MSG_PUB.Count_And_Get (

1462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1463: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: -- Standard call to get message count and if count=1, get the message
1466: FND_MSG_PUB.Count_And_Get (
1467: p_encoded => FND_API.G_FALSE,
1468: p_count => x_msg_count,
1469: p_data => x_msg_data
1470: );

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

1470: );
1471: WHEN OTHERS THEN
1472: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1475: THEN
1476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1477: END IF;
1478: -- Standard call to get message count and if count=1, get the message

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

1472: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1475: THEN
1476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1477: END IF;
1478: -- Standard call to get message count and if count=1, get the message
1479: FND_MSG_PUB.Count_And_Get (
1480: p_encoded => FND_API.G_FALSE,

Line 1479: FND_MSG_PUB.Count_And_Get (

1475: THEN
1476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1477: END IF;
1478: -- Standard call to get message count and if count=1, get the message
1479: FND_MSG_PUB.Count_And_Get (
1480: p_encoded => FND_API.G_FALSE,
1481: p_count => x_msg_count,
1482: p_data => x_msg_data
1483: );

Line 1516: FND_MSG_PUB.initialize;

1512:
1513: -- Initialize message list if p_init_msg_list is set to TRUE.
1514: IF FND_API.to_Boolean( p_init_msg_list )
1515: THEN
1516: FND_MSG_PUB.initialize;
1517: END IF;
1518:
1519: -- Standard call to check for call compatibility.
1520: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1533: OPEN c_Supp_Trade_Profile;
1534: FETCH c_Supp_Trade_Profile INTO l_SUPP_TRADE_PROFILE_ID;
1535: IF (c_Supp_Trade_Profile%NOTFOUND) THEN
1536: CLOSE c_Supp_Trade_Profile;
1537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1538: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1539: FND_MSG_PUB.add;
1540: END IF;
1541: RAISE FND_API.g_exc_error;

Line 1539: FND_MSG_PUB.add;

1535: IF (c_Supp_Trade_Profile%NOTFOUND) THEN
1536: CLOSE c_Supp_Trade_Profile;
1537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1538: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1539: FND_MSG_PUB.add;
1540: END IF;
1541: RAISE FND_API.g_exc_error;
1542: END IF;
1543: CLOSE c_Supp_Trade_Profile;

Line 1545: FND_MSG_PUB.count_and_get(

1541: RAISE FND_API.g_exc_error;
1542: END IF;
1543: CLOSE c_Supp_Trade_Profile;
1544: -------------------- finish --------------------------
1545: FND_MSG_PUB.count_and_get(
1546: p_encoded => FND_API.g_false,
1547: p_count => x_msg_count,
1548: p_data => x_msg_data);
1549: IF g_debug THEN

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

1551: END IF;
1552: EXCEPTION
1553: WHEN OZF_Utility_PVT.resource_locked THEN
1554: x_return_status := FND_API.g_ret_sts_error;
1555: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1556: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES LOCKED');
1557: FND_MSG_PUB.add;
1558: END IF;
1559: WHEN FND_API.G_EXC_ERROR THEN

Line 1557: FND_MSG_PUB.add;

1553: WHEN OZF_Utility_PVT.resource_locked THEN
1554: x_return_status := FND_API.g_ret_sts_error;
1555: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1556: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES LOCKED');
1557: FND_MSG_PUB.add;
1558: END IF;
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1561: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1563: FND_MSG_PUB.Count_And_Get (

1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: -- Standard call to get message count and if count=1, get the message
1563: FND_MSG_PUB.Count_And_Get (
1564: p_encoded => FND_API.G_FALSE,
1565: p_count => x_msg_count,
1566: p_data => x_msg_data
1567: );

Line 1572: FND_MSG_PUB.Count_And_Get (

1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1569: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1571: -- Standard call to get message count and if count=1, get the message
1572: FND_MSG_PUB.Count_And_Get (
1573: p_encoded => FND_API.G_FALSE,
1574: p_count => x_msg_count,
1575: p_data => x_msg_data
1576: );

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

1576: );
1577: WHEN OTHERS THEN
1578: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1580: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1583: END IF;
1584: -- Standard call to get message count and if count=1, get the message

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

1578: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1580: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1583: END IF;
1584: -- Standard call to get message count and if count=1, get the message
1585: FND_MSG_PUB.Count_And_Get (
1586: p_encoded => FND_API.G_FALSE,

Line 1585: FND_MSG_PUB.Count_And_Get (

1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1583: END IF;
1584: -- Standard call to get message count and if count=1, get the message
1585: FND_MSG_PUB.Count_And_Get (
1586: p_encoded => FND_API.G_FALSE,
1587: p_count => x_msg_count,
1588: p_data => x_msg_data
1589: );

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

1639: END IF; -- end of p_validation_mode = create
1640: END IF;
1641: --Seed the message OZF_SUPP_TRADE_DUPLICATE
1642: IF l_valid_flag = FND_API.g_false THEN
1643: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1644: FND_MESSAGE.set_name('OZF', 'OZF_SUPP_TRADE_PROFILE_DUPLIC');
1645: FND_MSG_PUB.add;
1646: END IF;
1647: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1645: FND_MSG_PUB.add;

1641: --Seed the message OZF_SUPP_TRADE_DUPLICATE
1642: IF l_valid_flag = FND_API.g_false THEN
1643: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1644: FND_MESSAGE.set_name('OZF', 'OZF_SUPP_TRADE_PROFILE_DUPLIC');
1645: FND_MSG_PUB.add;
1646: END IF;
1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: END IF;
1649: END check_supp_trd_prfl_uk_items;

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

1669:
1670: IF p_supp_trade_profile_rec.supplier_id = FND_API.g_miss_num OR
1671: p_supp_trade_profile_rec.supplier_id IS NULL
1672: THEN
1673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1674: FND_MESSAGE.set_name('OZF', 'OZF_SUPPLIER_MISSING');
1675: FND_MSG_PUB.add;
1676: END IF;
1677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1675: FND_MSG_PUB.add;

1671: p_supp_trade_profile_rec.supplier_id IS NULL
1672: THEN
1673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1674: FND_MESSAGE.set_name('OZF', 'OZF_SUPPLIER_MISSING');
1675: FND_MSG_PUB.add;
1676: END IF;
1677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1678: END IF;
1679: IF p_supp_trade_profile_rec.supplier_site_id = FND_API.g_miss_num OR

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

1678: END IF;
1679: IF p_supp_trade_profile_rec.supplier_site_id = FND_API.g_miss_num OR
1680: p_supp_trade_profile_rec.supplier_site_id IS NULL
1681: THEN
1682: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1683: FND_MESSAGE.set_name('OZF', 'OZF_SUPPLIER_SITE_MISSING');
1684: FND_MSG_PUB.add;
1685: END IF;
1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1684: FND_MSG_PUB.add;

1680: p_supp_trade_profile_rec.supplier_site_id IS NULL
1681: THEN
1682: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1683: FND_MESSAGE.set_name('OZF', 'OZF_SUPPLIER_SITE_MISSING');
1684: FND_MSG_PUB.add;
1685: END IF;
1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1687: END IF;
1688:

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

1688:
1689: IF p_supp_trade_profile_rec.party_id = FND_API.g_miss_num OR
1690: p_supp_trade_profile_rec.party_id IS NULL
1691: THEN
1692: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1693: FND_MESSAGE.set_name('OZF', 'OZF_CUSTOMER_MISSING');
1694: FND_MSG_PUB.add;
1695: END IF;
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1694: FND_MSG_PUB.add;

1690: p_supp_trade_profile_rec.party_id IS NULL
1691: THEN
1692: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1693: FND_MESSAGE.set_name('OZF', 'OZF_CUSTOMER_MISSING');
1694: FND_MSG_PUB.add;
1695: END IF;
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: END IF;
1698: IF p_supp_trade_profile_rec.cust_account_id = FND_API.g_miss_num OR

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

1697: END IF;
1698: IF p_supp_trade_profile_rec.cust_account_id = FND_API.g_miss_num OR
1699: p_supp_trade_profile_rec.cust_account_id IS NULL
1700: THEN
1701: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1702: FND_MESSAGE.set_name('OZF', 'OZF_CUSTOMER_ACCOUNT_MISSING');
1703: FND_MSG_PUB.add;
1704: END IF;
1705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1703: FND_MSG_PUB.add;

1699: p_supp_trade_profile_rec.cust_account_id IS NULL
1700: THEN
1701: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1702: FND_MESSAGE.set_name('OZF', 'OZF_CUSTOMER_ACCOUNT_MISSING');
1703: FND_MSG_PUB.add;
1704: END IF;
1705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1706: END IF;
1707:

Line 1809: FND_MSG_PUB.initialize;

1805: END IF;
1806: -- Initialize message list if p_init_msg_list is set to TRUE.
1807: IF FND_API.to_Boolean( p_init_msg_list )
1808: THEN
1809: FND_MSG_PUB.initialize;
1810: END IF;
1811: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1812: Check_supp_trd_prfl_Items(
1813: p_supp_trade_profile_rec => p_supp_trade_profile_rec,

Line 1842: FND_MSG_PUB.Count_And_Get

1838:
1839: -- Initialize API return status to SUCCESS
1840: x_return_status := FND_API.G_RET_STS_SUCCESS;
1841: -- Standard call to get message count and if count is 1, get message info.
1842: FND_MSG_PUB.Count_And_Get
1843: (p_count => x_msg_count,
1844: p_data => x_msg_data
1845: );
1846: EXCEPTION

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

1845: );
1846: EXCEPTION
1847: WHEN OZF_Utility_PVT.resource_locked THEN
1848: x_return_status := FND_API.g_ret_sts_error;
1849: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1850: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
1851: FND_MSG_PUB.add;
1852: END IF;
1853: WHEN FND_API.G_EXC_ERROR THEN

Line 1851: FND_MSG_PUB.add;

1847: WHEN OZF_Utility_PVT.resource_locked THEN
1848: x_return_status := FND_API.g_ret_sts_error;
1849: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1850: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
1851: FND_MSG_PUB.add;
1852: END IF;
1853: WHEN FND_API.G_EXC_ERROR THEN
1854: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
1855: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1857: FND_MSG_PUB.Count_And_Get (

1853: WHEN FND_API.G_EXC_ERROR THEN
1854: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
1855: x_return_status := FND_API.G_RET_STS_ERROR;
1856: -- Standard call to get message count and if count=1, get the message
1857: FND_MSG_PUB.Count_And_Get (
1858: p_encoded => FND_API.G_FALSE,
1859: p_count => x_msg_count,
1860: p_data => x_msg_data
1861: );

Line 1866: FND_MSG_PUB.Count_And_Get (

1862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1863: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1865: -- Standard call to get message count and if count=1, get the message
1866: FND_MSG_PUB.Count_And_Get (
1867: p_encoded => FND_API.G_FALSE,
1868: p_count => x_msg_count,
1869: p_data => x_msg_data
1870: );

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

1870: );
1871: WHEN OTHERS THEN
1872: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1874: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1877: END IF;
1878: -- Standard call to get message count and if count=1, get the message

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

1872: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1874: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1877: END IF;
1878: -- Standard call to get message count and if count=1, get the message
1879: FND_MSG_PUB.Count_And_Get (
1880: p_encoded => FND_API.G_FALSE,

Line 1879: FND_MSG_PUB.Count_And_Get (

1875: THEN
1876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1877: END IF;
1878: -- Standard call to get message count and if count=1, get the message
1879: FND_MSG_PUB.Count_And_Get (
1880: p_encoded => FND_API.G_FALSE,
1881: p_count => x_msg_count,
1882: p_data => x_msg_data
1883: );

Line 1899: FND_MSG_PUB.initialize;

1895: BEGIN
1896: -- Initialize message list if p_init_msg_list is set to TRUE.
1897: IF FND_API.to_Boolean( p_init_msg_list )
1898: THEN
1899: FND_MSG_PUB.initialize;
1900: END IF;
1901:
1902: -- Initialize API return status to SUCCESS
1903: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1906: IF p_supp_trade_profile_rec.default_days_covered is not null and
1907: ( p_supp_trade_profile_rec.default_days_covered > 9999 or
1908: p_supp_trade_profile_rec.default_days_covered < 0)
1909: THEN
1910: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1911: FND_MESSAGE.set_name('OZF', 'OZF_DEFAULT_DAYS_INVALID_VAL');
1912: FND_MSG_PUB.add;
1913: END IF;
1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1912: FND_MSG_PUB.add;

1908: p_supp_trade_profile_rec.default_days_covered < 0)
1909: THEN
1910: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1911: FND_MESSAGE.set_name('OZF', 'OZF_DEFAULT_DAYS_INVALID_VAL');
1912: FND_MSG_PUB.add;
1913: END IF;
1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1915: END IF ;
1916: -- Hint: qty_increase_tolerance shd lie in 1-100

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

1918: (p_supp_trade_profile_rec.qty_increase_tolerance > 100 or
1919: p_supp_trade_profile_rec.qty_increase_tolerance < 0)
1920: THEN
1921: x_return_status := FND_API.G_RET_STS_ERROR;
1922: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1923: FND_MESSAGE.set_name('OZF', 'OZF_QTY_INC_TOLERANCE_INVALID');
1924: FND_MSG_PUB.add;
1925: END IF;
1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1924: FND_MSG_PUB.add;

1920: THEN
1921: x_return_status := FND_API.G_RET_STS_ERROR;
1922: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1923: FND_MESSAGE.set_name('OZF', 'OZF_QTY_INC_TOLERANCE_INVALID');
1924: FND_MSG_PUB.add;
1925: END IF;
1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1927: END IF ;
1928: IF p_supp_trade_profile_rec.grace_days is not null and

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

1929: ( p_supp_trade_profile_rec.grace_days > 9999 or
1930: p_supp_trade_profile_rec.grace_days < 0)
1931: THEN
1932: x_return_status := FND_API.G_RET_STS_ERROR;
1933: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1934: FND_MESSAGE.set_name('OZF', 'OZF_GRACE_DAYS_INVALID_VAL');
1935: FND_MSG_PUB.add;
1936: END IF;
1937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1935: FND_MSG_PUB.add;

1931: THEN
1932: x_return_status := FND_API.G_RET_STS_ERROR;
1933: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1934: FND_MESSAGE.set_name('OZF', 'OZF_GRACE_DAYS_INVALID_VAL');
1935: FND_MSG_PUB.add;
1936: END IF;
1937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1938: END IF ;
1939: IF p_supp_trade_profile_rec.authorization_period is not null and

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

1940: (p_supp_trade_profile_rec.authorization_period > 9999 or
1941: p_supp_trade_profile_rec.authorization_period < 0)
1942: THEN
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1945: FND_MESSAGE.set_name('OZF', 'OZF_AUTH_PERIOD_INVALID_VAL');
1946: FND_MSG_PUB.add;
1947: END IF;
1948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1946: FND_MSG_PUB.add;

1942: THEN
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1945: FND_MESSAGE.set_name('OZF', 'OZF_AUTH_PERIOD_INVALID_VAL');
1946: FND_MSG_PUB.add;
1947: END IF;
1948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1949: END IF ;
1950: --gdeepika 2/21/2008 claim frequency cannot be negetive--

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

1951: IF p_supp_trade_profile_rec.claim_frequency is not null and
1952: p_supp_trade_profile_rec.claim_frequency < 0
1953: THEN
1954: x_return_status := FND_API.G_RET_STS_ERROR;
1955: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1956: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_FREQ_NEG');
1957: FND_MSG_PUB.add;
1958: END IF;
1959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1957: FND_MSG_PUB.add;

1953: THEN
1954: x_return_status := FND_API.G_RET_STS_ERROR;
1955: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1956: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_FREQ_NEG');
1957: FND_MSG_PUB.add;
1958: END IF;
1959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1960: END IF ;
1961: --2/22/2008 gdeepika- claim amount thresholds cannot be negative -6839040

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

1962: IF(p_supp_trade_profile_rec.min_claim_amt IS NOT null)
1963: THEN
1964: IF (p_supp_trade_profile_rec.min_claim_amt < 0)
1965: THEN
1966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1967: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AMT_INVALID');
1968: FND_MSG_PUB.add;
1969: END IF;
1970: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1968: FND_MSG_PUB.add;

1964: IF (p_supp_trade_profile_rec.min_claim_amt < 0)
1965: THEN
1966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1967: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AMT_INVALID');
1968: FND_MSG_PUB.add;
1969: END IF;
1970: x_return_status := FND_API.G_RET_STS_ERROR;
1971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1972: END IF ;

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

1975: IF( p_supp_trade_profile_rec.min_claim_amt_line_lvl IS NOT null )
1976: THEN
1977: IF (p_supp_trade_profile_rec.min_claim_amt_line_lvl < 0)
1978: THEN
1979: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1980: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NEG');
1981: FND_MSG_PUB.add;
1982: END IF;
1983: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1981: FND_MSG_PUB.add;

1977: IF (p_supp_trade_profile_rec.min_claim_amt_line_lvl < 0)
1978: THEN
1979: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1980: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NEG');
1981: FND_MSG_PUB.add;
1982: END IF;
1983: x_return_status := FND_API.G_RET_STS_ERROR;
1984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1985: END IF ;

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

1992: THEN
1993:
1994: IF (p_supp_trade_profile_rec.min_claim_amt < p_supp_trade_profile_rec.min_claim_amt_line_lvl)
1995: THEN
1996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1997: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AMT_ERROR');
1998: FND_MSG_PUB.add;
1999: END IF;
2000: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1998: FND_MSG_PUB.add;

1994: IF (p_supp_trade_profile_rec.min_claim_amt < p_supp_trade_profile_rec.min_claim_amt_line_lvl)
1995: THEN
1996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1997: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AMT_ERROR');
1998: FND_MSG_PUB.add;
1999: END IF;
2000: x_return_status := FND_API.G_RET_STS_ERROR;
2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2002: END IF ;

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

2006: p_supp_trade_profile_rec.days_before_claiming_debit > 9999 or
2007: p_supp_trade_profile_rec.days_before_claiming_debit < 0
2008: THEN
2009: x_return_status := FND_API.G_RET_STS_ERROR;
2010: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2011: FND_MESSAGE.set_name('OZF', 'OZF_DAYS_BEF_CLAIMING_DEBIT');
2012: FND_MSG_PUB.add;
2013: END IF;
2014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2012: FND_MSG_PUB.add;

2008: THEN
2009: x_return_status := FND_API.G_RET_STS_ERROR;
2010: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2011: FND_MESSAGE.set_name('OZF', 'OZF_DAYS_BEF_CLAIMING_DEBIT');
2012: FND_MSG_PUB.add;
2013: END IF;
2014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2015: END IF ;
2016: -- Debug Message

Line 2021: FND_MSG_PUB.Count_And_Get

2017: IF g_debug THEN
2018: OZF_UTILITY_PVT.debug_message('Private API: Validate the trade profile record');
2019: END IF;
2020: -- Standard call to get message count and if count is 1, get message info.
2021: FND_MSG_PUB.Count_And_Get
2022: (p_count => x_msg_count,
2023: p_data => x_msg_data
2024: );
2025: END Validate_supp_trd_prfl_rec;