DBA Data[Home] [Help]

APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on FND_MSG_PUB

Line 134: FND_MSG_PUB.initialize;

130:
131: -- Initialize message list if p_init_msg_list is set to TRUE.
132: IF FND_API.to_Boolean( p_init_msg_list )
133: THEN
134: FND_MSG_PUB.initialize;
135: END IF;
136:
137: -- Initialize API return status to SUCCESS
138: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 360: FND_MSG_PUB.Count_And_Get

356: COMMIT WORK;
357: END IF;
358:
359: -- Standard call to get message count and if count is 1, get message info.
360: FND_MSG_PUB.Count_And_Get
361: (p_count => x_msg_count,
362: p_data => x_msg_data
363: );
364: EXCEPTION

Line 374: FND_MSG_PUB.Count_And_Get (

370: WHEN FND_API.G_EXC_ERROR THEN
371: ROLLBACK TO CREATE_Offers_PVT;
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: -- Standard call to get message count and if count=1, get the message
374: FND_MSG_PUB.Count_And_Get (
375: p_encoded => FND_API.G_FALSE,
376: p_count => x_msg_count,
377: p_data => x_msg_data
378: );

Line 384: FND_MSG_PUB.Count_And_Get (

380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: ROLLBACK TO CREATE_Offers_PVT;
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: -- Standard call to get message count and if count=1, get the message
384: FND_MSG_PUB.Count_And_Get (
385: p_encoded => FND_API.G_FALSE,
386: p_count => x_msg_count,
387: p_data => x_msg_data
388: );

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

389:
390: WHEN OTHERS THEN
391: ROLLBACK TO CREATE_Offers_PVT;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
394: THEN
395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
396: END IF;
397: -- Standard call to get message count and if count=1, get the message

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

391: ROLLBACK TO CREATE_Offers_PVT;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
394: THEN
395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
396: END IF;
397: -- Standard call to get message count and if count=1, get the message
398: FND_MSG_PUB.Count_And_Get (
399: p_encoded => FND_API.G_FALSE,

Line 398: FND_MSG_PUB.Count_And_Get (

394: THEN
395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
396: END IF;
397: -- Standard call to get message count and if count=1, get the message
398: FND_MSG_PUB.Count_And_Get (
399: p_encoded => FND_API.G_FALSE,
400: p_count => x_msg_count,
401: p_data => x_msg_data
402: );

Line 760: FND_MSG_PUB.initialize;

756:
757: -- Initialize message list if p_init_msg_list is set to TRUE.
758: IF FND_API.to_Boolean( p_init_msg_list )
759: THEN
760: FND_MSG_PUB.initialize;
761: END IF;
762:
763: -- Initialize API return status to SUCCESS
764: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 937: FND_MSG_PUB.Count_And_Get

933: COMMIT WORK;
934: END IF;
935:
936: -- Standard call to get message count and if count is 1, get message info.
937: FND_MSG_PUB.Count_And_Get
938: (p_count => x_msg_count,
939: p_data => x_msg_data,
940: p_encoded => FND_API.G_FALSE
941: );

Line 952: FND_MSG_PUB.Count_And_Get (

948: WHEN FND_API.G_EXC_ERROR THEN
949: ROLLBACK TO UPDATE_Offers_PVT;
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: -- Standard call to get message count and if count=1, get the message
952: FND_MSG_PUB.Count_And_Get (
953: p_encoded => FND_API.G_FALSE,
954: p_count => x_msg_count,
955: p_data => x_msg_data
956: );

Line 962: FND_MSG_PUB.Count_And_Get (

958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
959: ROLLBACK TO UPDATE_Offers_PVT;
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
961: -- Standard call to get message count and if count=1, get the message
962: FND_MSG_PUB.Count_And_Get (
963: p_encoded => FND_API.G_FALSE,
964: p_count => x_msg_count,
965: p_data => x_msg_data
966: );

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

967: /*
968: WHEN OTHERS THEN
969: ROLLBACK TO UPDATE_Offers_PVT;
970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
971: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
972: THEN
973: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
974: END IF;
975: -- Standard call to get message count and if count=1, get the message

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

969: ROLLBACK TO UPDATE_Offers_PVT;
970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
971: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
972: THEN
973: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
974: END IF;
975: -- Standard call to get message count and if count=1, get the message
976: FND_MSG_PUB.Count_And_Get (
977: p_encoded => FND_API.G_FALSE,

Line 976: FND_MSG_PUB.Count_And_Get (

972: THEN
973: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
974: END IF;
975: -- Standard call to get message count and if count=1, get the message
976: FND_MSG_PUB.Count_And_Get (
977: p_encoded => FND_API.G_FALSE,
978: p_count => x_msg_count,
979: p_data => x_msg_data
980: );

Line 1018: FND_MSG_PUB.initialize;

1014:
1015: -- Initialize message list if p_init_msg_list is set to TRUE.
1016: IF FND_API.to_Boolean( p_init_msg_list )
1017: THEN
1018: FND_MSG_PUB.initialize;
1019: END IF;
1020:
1021: -- Initialize API return status to SUCCESS
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1042: FND_MSG_PUB.Count_And_Get

1038: COMMIT WORK;
1039: END IF;
1040:
1041: -- Standard call to get message count and if count is 1, get message info.
1042: FND_MSG_PUB.Count_And_Get
1043: (p_count => x_msg_count,
1044: p_data => x_msg_data
1045: );
1046: EXCEPTION

Line 1056: FND_MSG_PUB.Count_And_Get (

1052: WHEN FND_API.G_EXC_ERROR THEN
1053: ROLLBACK TO DELETE_Offers_PVT;
1054: x_return_status := FND_API.G_RET_STS_ERROR;
1055: -- Standard call to get message count and if count=1, get the message
1056: FND_MSG_PUB.Count_And_Get (
1057: p_encoded => FND_API.G_FALSE,
1058: p_count => x_msg_count,
1059: p_data => x_msg_data
1060: );

Line 1066: FND_MSG_PUB.Count_And_Get (

1062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1063: ROLLBACK TO DELETE_Offers_PVT;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: -- Standard call to get message count and if count=1, get the message
1066: FND_MSG_PUB.Count_And_Get (
1067: p_encoded => FND_API.G_FALSE,
1068: p_count => x_msg_count,
1069: p_data => x_msg_data
1070: );

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

1071:
1072: WHEN OTHERS THEN
1073: ROLLBACK TO DELETE_Offers_PVT;
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1075: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1076: THEN
1077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1078: END IF;
1079: -- Standard call to get message count and if count=1, get the message

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

1073: ROLLBACK TO DELETE_Offers_PVT;
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1075: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1076: THEN
1077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1078: END IF;
1079: -- Standard call to get message count and if count=1, get the message
1080: FND_MSG_PUB.Count_And_Get (
1081: p_encoded => FND_API.G_FALSE,

Line 1080: FND_MSG_PUB.Count_And_Get (

1076: THEN
1077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1078: END IF;
1079: -- Standard call to get message count and if count=1, get the message
1080: FND_MSG_PUB.Count_And_Get (
1081: p_encoded => FND_API.G_FALSE,
1082: p_count => x_msg_count,
1083: p_data => x_msg_data
1084: );

Line 1120: FND_MSG_PUB.initialize;

1116:
1117: -- Initialize message list if p_init_msg_list is set to TRUE.
1118: IF FND_API.to_Boolean( p_init_msg_list )
1119: THEN
1120: FND_MSG_PUB.initialize;
1121: END IF;
1122:
1123: -- Standard call to check for call compatibility.
1124: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1141: FETCH c_Offers INTO l_OFFER_ID;
1142:
1143: IF (c_Offers%NOTFOUND) THEN
1144: CLOSE c_Offers;
1145: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1146: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1147: FND_MSG_PUB.add;
1148: END IF;
1149: RAISE FND_API.g_exc_error;

Line 1147: FND_MSG_PUB.add;

1143: IF (c_Offers%NOTFOUND) THEN
1144: CLOSE c_Offers;
1145: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1146: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1147: FND_MSG_PUB.add;
1148: END IF;
1149: RAISE FND_API.g_exc_error;
1150: END IF;
1151:

Line 1155: FND_MSG_PUB.count_and_get(

1151:
1152: CLOSE c_Offers;
1153:
1154: -------------------- finish --------------------------
1155: FND_MSG_PUB.count_and_get(
1156: p_encoded => FND_API.g_false,
1157: p_count => x_msg_count,
1158: p_data => x_msg_data);
1159:

Line 1170: FND_MSG_PUB.Count_And_Get (

1166: WHEN FND_API.G_EXC_ERROR THEN
1167: ROLLBACK TO LOCK_Offers_PVT;
1168: x_return_status := FND_API.G_RET_STS_ERROR;
1169: -- Standard call to get message count and if count=1, get the message
1170: FND_MSG_PUB.Count_And_Get (
1171: p_encoded => FND_API.G_FALSE,
1172: p_count => x_msg_count,
1173: p_data => x_msg_data
1174: );

Line 1180: FND_MSG_PUB.Count_And_Get (

1176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1177: ROLLBACK TO LOCK_Offers_PVT;
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179: -- Standard call to get message count and if count=1, get the message
1180: FND_MSG_PUB.Count_And_Get (
1181: p_encoded => FND_API.G_FALSE,
1182: p_count => x_msg_count,
1183: p_data => x_msg_data
1184: );

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

1185:
1186: WHEN OTHERS THEN
1187: ROLLBACK TO LOCK_Offers_PVT;
1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1189: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1190: THEN
1191: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1192: END IF;
1193: -- Standard call to get message count and if count=1, get the message

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

1187: ROLLBACK TO LOCK_Offers_PVT;
1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1189: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1190: THEN
1191: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1192: END IF;
1193: -- Standard call to get message count and if count=1, get the message
1194: FND_MSG_PUB.Count_And_Get (
1195: p_encoded => FND_API.G_FALSE,

Line 1194: FND_MSG_PUB.Count_And_Get (

1190: THEN
1191: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1192: END IF;
1193: -- Standard call to get message count and if count=1, get the message
1194: FND_MSG_PUB.Count_And_Get (
1195: p_encoded => FND_API.G_FALSE,
1196: p_count => x_msg_count,
1197: p_data => x_msg_data
1198: );

Line 1536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1532: ,p_lookup_code => p_offers_rec.modifier_level_code
1533: ) = FND_API.g_false
1534: THEN
1535: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;
1536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1537: THEN
1538: FND_MESSAGE.set_name('OZF', 'OZF_OFR_BAD_MODIFIER_LEVEL_COD');
1539: FND_MSG_PUB.add;
1540: END IF;

Line 1539: FND_MSG_PUB.add;

1535: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;
1536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1537: THEN
1538: FND_MESSAGE.set_name('OZF', 'OZF_OFR_BAD_MODIFIER_LEVEL_COD');
1539: FND_MSG_PUB.add;
1540: END IF;
1541: x_return_status := FND_API.g_ret_sts_error;
1542: RETURN;
1543: END IF;

Line 1629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1625: ,p_lookup_code => p_offers_rec.autopay_method
1626: ) = FND_API.g_false
1627: THEN
1628: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;
1629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1630: THEN
1631: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_PAYMENT_METHOD');
1632: FND_MSG_PUB.add;
1633: END IF;

Line 1632: FND_MSG_PUB.add;

1628: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;
1629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1630: THEN
1631: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_PAYMENT_METHOD');
1632: FND_MSG_PUB.add;
1633: END IF;
1634: x_return_status := FND_API.g_ret_sts_error;
1635: RETURN;
1636: END IF;

Line 1649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1645: ,p_lookup_code => p_offers_rec.autopay_party_attr
1646: ) = FND_API.g_false
1647: THEN
1648: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;
1649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1650: THEN
1651: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_AUTOPAY_CUSTTYPE');
1652: FND_MSG_PUB.add;
1653: END IF;

Line 1652: FND_MSG_PUB.add;

1648: --OZF_Utility_PVT.Error_Message('OZF_OFR_BAD_MODIFIER_LEVEL_CODE') ;
1649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1650: THEN
1651: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_AUTOPAY_CUSTTYPE');
1652: FND_MSG_PUB.add;
1653: END IF;
1654: x_return_status := FND_API.g_ret_sts_error;
1655: RETURN;
1656: END IF;

Line 1708: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1704: THEN
1705: l_start_date := p_offers_rec.perf_date_from;
1706: l_end_date := p_offers_rec.perf_date_to;
1707: IF l_start_date > l_end_date THEN
1708: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1709: THEN
1710: FND_MESSAGE.set_name('OZF', 'OZF_OFR_SHIP_START_AFTER_END');
1711: FND_MSG_PUB.add;
1712: END IF;

Line 1711: FND_MSG_PUB.add;

1707: IF l_start_date > l_end_date THEN
1708: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1709: THEN
1710: FND_MESSAGE.set_name('OZF', 'OZF_OFR_SHIP_START_AFTER_END');
1711: FND_MSG_PUB.add;
1712: END IF;
1713: x_return_status := FND_API.g_ret_sts_error;
1714: END IF;
1715: END IF;

Line 1818: FND_MSG_PUB.initialize;

1814:
1815: -- Initialize message list if p_init_msg_list is set to TRUE.
1816: IF FND_API.to_Boolean( p_init_msg_list )
1817: THEN
1818: FND_MSG_PUB.initialize;
1819: END IF;
1820:
1821: x_return_status := FND_API.g_ret_sts_success;
1822:

Line 1862: FND_MSG_PUB.Count_And_Get

1858: -- Initialize API return status to SUCCESS
1859: x_return_status := FND_API.G_RET_STS_SUCCESS;
1860:
1861: -- Standard call to get message count and if count is 1, get message info.
1862: FND_MSG_PUB.Count_And_Get
1863: (p_count => x_msg_count,
1864: p_data => x_msg_data
1865: );
1866:

Line 1877: FND_MSG_PUB.Count_And_Get (

1873: WHEN FND_API.G_EXC_ERROR THEN
1874: ROLLBACK TO VALIDATE_Offers_;
1875: x_return_status := FND_API.G_RET_STS_ERROR;
1876: -- Standard call to get message count and if count=1, get the message
1877: FND_MSG_PUB.Count_And_Get (
1878: p_encoded => FND_API.G_FALSE,
1879: p_count => x_msg_count,
1880: p_data => x_msg_data
1881: );

Line 1887: FND_MSG_PUB.Count_And_Get (

1883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1884: ROLLBACK TO VALIDATE_Offers_;
1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1886: -- Standard call to get message count and if count=1, get the message
1887: FND_MSG_PUB.Count_And_Get (
1888: p_encoded => FND_API.G_FALSE,
1889: p_count => x_msg_count,
1890: p_data => x_msg_data
1891: );

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

1892:
1893: WHEN OTHERS THEN
1894: ROLLBACK TO VALIDATE_Offers_;
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1897: THEN
1898: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1899: END IF;
1900: -- Standard call to get message count and if count=1, get the message

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

1894: ROLLBACK TO VALIDATE_Offers_;
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1897: THEN
1898: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1899: END IF;
1900: -- Standard call to get message count and if count=1, get the message
1901: FND_MSG_PUB.Count_And_Get (
1902: p_encoded => FND_API.G_FALSE,

Line 1901: FND_MSG_PUB.Count_And_Get (

1897: THEN
1898: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1899: END IF;
1900: -- Standard call to get message count and if count=1, get the message
1901: FND_MSG_PUB.Count_And_Get (
1902: p_encoded => FND_API.G_FALSE,
1903: p_count => x_msg_count,
1904: p_data => x_msg_data
1905: );

Line 1924: FND_MSG_PUB.initialize;

1920: BEGIN
1921: -- Initialize message list if p_init_msg_list is set to TRUE.
1922: IF FND_API.to_Boolean( p_init_msg_list )
1923: THEN
1924: FND_MSG_PUB.initialize;
1925: END IF;
1926:
1927: -- Initialize API return status to SUCCESS
1928: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1936: FND_MSG_PUB.Count_And_Get

1932: -- THEN
1933: -- x_return_status := FND_API.G_RET_STS_ERROR;
1934:
1935: -- Standard call to get message count and if count is 1, get message info.
1936: FND_MSG_PUB.Count_And_Get
1937: (p_count => x_msg_count,
1938: p_data => x_msg_data
1939: );
1940: END Validate_offers_Rec;