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

Line 118: FND_MSG_PUB.initialize;

114:
115: -- Initialize message list if p_init_msg_list is set to TRUE.
116: IF FND_API.to_Boolean( p_init_msg_list )
117: THEN
118: FND_MSG_PUB.initialize;
119: END IF;
120:
121:
122:

Line 143: FND_MSG_PUB.count_and_get(

139: OZF_DISC_LINE_PKG.Lock_Row(l_offer_discount_line_id,p_object_version);
140:
141:
142: -------------------- finish --------------------------
143: FND_MSG_PUB.count_and_get(
144: p_encoded => FND_API.g_false,
145: p_count => x_msg_count,
146: p_data => x_msg_data);
147: OZF_Utility_PVT.debug_message(l_full_name ||': end');

Line 158: FND_MSG_PUB.Count_And_Get (

154: WHEN FND_API.G_EXC_ERROR THEN
155: ROLLBACK TO LOCK_Ozf_Disc_Line_PVT;
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: -- Standard call to get message count and if count=1, get the message
158: FND_MSG_PUB.Count_And_Get (
159: p_encoded => FND_API.G_FALSE,
160: p_count => x_msg_count,
161: p_data => x_msg_data
162: );

Line 168: FND_MSG_PUB.Count_And_Get (

164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: ROLLBACK TO LOCK_Ozf_Disc_Line_PVT;
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: -- Standard call to get message count and if count=1, get the message
168: FND_MSG_PUB.Count_And_Get (
169: p_encoded => FND_API.G_FALSE,
170: p_count => x_msg_count,
171: p_data => x_msg_data
172: );

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

173:
174: WHEN OTHERS THEN
175: ROLLBACK TO LOCK_Ozf_Disc_Line_PVT;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
178: THEN
179: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
180: END IF;
181: -- Standard call to get message count and if count=1, get the message

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

175: ROLLBACK TO LOCK_Ozf_Disc_Line_PVT;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
178: THEN
179: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
180: END IF;
181: -- Standard call to get message count and if count=1, get the message
182: FND_MSG_PUB.Count_And_Get (
183: p_encoded => FND_API.G_FALSE,

Line 182: FND_MSG_PUB.Count_And_Get (

178: THEN
179: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
180: END IF;
181: -- Standard call to get message count and if count=1, get the message
182: FND_MSG_PUB.Count_And_Get (
183: p_encoded => FND_API.G_FALSE,
184: p_count => x_msg_count,
185: p_data => x_msg_data
186: );

Line 739: FND_MSG_PUB.initialize;

735: BEGIN
736: -- Initialize message list if p_init_msg_list is set to TRUE.
737: IF FND_API.to_Boolean( p_init_msg_list )
738: THEN
739: FND_MSG_PUB.initialize;
740: END IF;
741:
742:
743:

Line 755: FND_MSG_PUB.Count_And_Get

751:
752: -- Debug Message
753: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
754: -- Standard call to get message count and if count is 1, get message info.
755: FND_MSG_PUB.Count_And_Get
756: (p_count => x_msg_count,
757: p_data => x_msg_data
758: );
759: END Validate_ozf_offer_line_Rec;

Line 795: FND_MSG_PUB.initialize;

791:
792: -- Initialize message list if p_init_msg_list is set to TRUE.
793: IF FND_API.to_Boolean( p_init_msg_list )
794: THEN
795: FND_MSG_PUB.initialize;
796: END IF;
797:
798: -- Debug Message
799: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 852: FND_MSG_PUB.Count_And_Get

848: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
849:
850:
851: -- Standard call to get message count and if count is 1, get message info.
852: FND_MSG_PUB.Count_And_Get
853: (p_count => x_msg_count,
854: p_data => x_msg_data
855: );
856: EXCEPTION

Line 866: FND_MSG_PUB.Count_And_Get (

862: WHEN FND_API.G_EXC_ERROR THEN
863: ROLLBACK TO VALIDATE_Ozf_Disc_Line_;
864: x_return_status := FND_API.G_RET_STS_ERROR;
865: -- Standard call to get message count and if count=1, get the message
866: FND_MSG_PUB.Count_And_Get (
867: p_encoded => FND_API.G_FALSE,
868: p_count => x_msg_count,
869: p_data => x_msg_data
870: );

Line 876: FND_MSG_PUB.Count_And_Get (

872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
873: ROLLBACK TO VALIDATE_Ozf_Disc_Line_;
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: -- Standard call to get message count and if count=1, get the message
876: FND_MSG_PUB.Count_And_Get (
877: p_encoded => FND_API.G_FALSE,
878: p_count => x_msg_count,
879: p_data => x_msg_data
880: );

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

881:
882: WHEN OTHERS THEN
883: ROLLBACK TO VALIDATE_Ozf_Disc_Line_;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
886: THEN
887: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
888: END IF;
889: -- Standard call to get message count and if count=1, get the message

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

883: ROLLBACK TO VALIDATE_Ozf_Disc_Line_;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
886: THEN
887: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
888: END IF;
889: -- Standard call to get message count and if count=1, get the message
890: FND_MSG_PUB.Count_And_Get (
891: p_encoded => FND_API.G_FALSE,

Line 890: FND_MSG_PUB.Count_And_Get (

886: THEN
887: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
888: END IF;
889: -- Standard call to get message count and if count=1, get the message
890: FND_MSG_PUB.Count_And_Get (
891: p_encoded => FND_API.G_FALSE,
892: p_count => x_msg_count,
893: p_data => x_msg_data
894: );

Line 987: FND_MSG_PUB.initialize;

983:
984: -- Initialize message list if p_init_msg_list is set to TRUE.
985: IF FND_API.to_Boolean( p_init_msg_list )
986: THEN
987: FND_MSG_PUB.initialize;
988: END IF;
989:
990:
991:

Line 1123: FND_MSG_PUB.Count_And_Get

1119: -- Debug Message
1120: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1121:
1122: -- Standard call to get message count and if count is 1, get message info.
1123: FND_MSG_PUB.Count_And_Get
1124: (p_count => x_msg_count,
1125: p_data => x_msg_data
1126: );
1127: EXCEPTION

Line 1137: FND_MSG_PUB.Count_And_Get (

1133: WHEN FND_API.G_EXC_ERROR THEN
1134: ROLLBACK TO CREATE_Ozf_Disc_Line_PVT;
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: -- Standard call to get message count and if count=1, get the message
1137: FND_MSG_PUB.Count_And_Get (
1138: p_encoded => FND_API.G_FALSE,
1139: p_count => x_msg_count,
1140: p_data => x_msg_data
1141: );

Line 1147: FND_MSG_PUB.Count_And_Get (

1143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1144: ROLLBACK TO CREATE_Ozf_Disc_Line_PVT;
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: -- Standard call to get message count and if count=1, get the message
1147: FND_MSG_PUB.Count_And_Get (
1148: p_encoded => FND_API.G_FALSE,
1149: p_count => x_msg_count,
1150: p_data => x_msg_data
1151: );

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

1152:
1153: WHEN OTHERS THEN
1154: ROLLBACK TO CREATE_Ozf_Disc_Line_PVT;
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1157: THEN
1158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1159: END IF;
1160: -- Standard call to get message count and if count=1, get the message

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

1154: ROLLBACK TO CREATE_Ozf_Disc_Line_PVT;
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1157: THEN
1158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1159: END IF;
1160: -- Standard call to get message count and if count=1, get the message
1161: FND_MSG_PUB.Count_And_Get (
1162: p_encoded => FND_API.G_FALSE,

Line 1161: FND_MSG_PUB.Count_And_Get (

1157: THEN
1158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1159: END IF;
1160: -- Standard call to get message count and if count=1, get the message
1161: FND_MSG_PUB.Count_And_Get (
1162: p_encoded => FND_API.G_FALSE,
1163: p_count => x_msg_count,
1164: p_data => x_msg_data
1165: );

Line 1251: FND_MSG_PUB.initialize;

1247:
1248: -- Initialize message list if p_init_msg_list is set to TRUE.
1249: IF FND_API.to_Boolean( p_init_msg_list )
1250: THEN
1251: FND_MSG_PUB.initialize;
1252: END IF;
1253:
1254:
1255:

Line 1381: FND_MSG_PUB.Count_And_Get

1377: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1378:
1379:
1380: -- Standard call to get message count and if count is 1, get message info.
1381: FND_MSG_PUB.Count_And_Get
1382: (p_count => x_msg_count,
1383: p_data => x_msg_data
1384: );
1385: EXCEPTION

Line 1395: FND_MSG_PUB.Count_And_Get (

1391: WHEN FND_API.G_EXC_ERROR THEN
1392: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;
1393: x_return_status := FND_API.G_RET_STS_ERROR;
1394: -- Standard call to get message count and if count=1, get the message
1395: FND_MSG_PUB.Count_And_Get (
1396: p_encoded => FND_API.G_FALSE,
1397: p_count => x_msg_count,
1398: p_data => x_msg_data
1399: );

Line 1405: FND_MSG_PUB.Count_And_Get (

1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1402: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: -- Standard call to get message count and if count=1, get the message
1405: FND_MSG_PUB.Count_And_Get (
1406: p_encoded => FND_API.G_FALSE,
1407: p_count => x_msg_count,
1408: p_data => x_msg_data
1409: );

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

1410:
1411: WHEN OTHERS THEN
1412: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1415: THEN
1416: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1417: END IF;
1418: -- Standard call to get message count and if count=1, get the message

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

1412: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1415: THEN
1416: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1417: END IF;
1418: -- Standard call to get message count and if count=1, get the message
1419: FND_MSG_PUB.Count_And_Get (
1420: p_encoded => FND_API.G_FALSE,

Line 1419: FND_MSG_PUB.Count_And_Get (

1415: THEN
1416: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1417: END IF;
1418: -- Standard call to get message count and if count=1, get the message
1419: FND_MSG_PUB.Count_And_Get (
1420: p_encoded => FND_API.G_FALSE,
1421: p_count => x_msg_count,
1422: p_data => x_msg_data
1423: );

Line 1495: FND_MSG_PUB.initialize;

1491:
1492: -- Initialize message list if p_init_msg_list is set to TRUE.
1493: IF FND_API.to_Boolean( p_init_msg_list )
1494: THEN
1495: FND_MSG_PUB.initialize;
1496: END IF;
1497:
1498:
1499:

Line 1534: FND_MSG_PUB.Count_And_Get

1530: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1531:
1532:
1533: -- Standard call to get message count and if count is 1, get message info.
1534: FND_MSG_PUB.Count_And_Get
1535: (p_count => x_msg_count,
1536: p_data => x_msg_data
1537: );
1538: EXCEPTION

Line 1548: FND_MSG_PUB.Count_And_Get (

1544: WHEN FND_API.G_EXC_ERROR THEN
1545: ROLLBACK TO DELETE_Ozf_Disc_Line_PVT;
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: -- Standard call to get message count and if count=1, get the message
1548: FND_MSG_PUB.Count_And_Get (
1549: p_encoded => FND_API.G_FALSE,
1550: p_count => x_msg_count,
1551: p_data => x_msg_data
1552: );

Line 1558: FND_MSG_PUB.Count_And_Get (

1554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1555: ROLLBACK TO DELETE_Ozf_Disc_Line_PVT;
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: -- Standard call to get message count and if count=1, get the message
1558: FND_MSG_PUB.Count_And_Get (
1559: p_encoded => FND_API.G_FALSE,
1560: p_count => x_msg_count,
1561: p_data => x_msg_data
1562: );

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

1563:
1564: WHEN OTHERS THEN
1565: ROLLBACK TO DELETE_Ozf_Disc_Line_PVT;
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1567: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1568: THEN
1569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1570: END IF;
1571: -- Standard call to get message count and if count=1, get the message

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

1565: ROLLBACK TO DELETE_Ozf_Disc_Line_PVT;
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1567: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1568: THEN
1569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1570: END IF;
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,

Line 1572: FND_MSG_PUB.Count_And_Get (

1568: THEN
1569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1570: END IF;
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 1643: FND_MSG_PUB.initialize;

1639:
1640: -- Initialize message list if p_init_msg_list is set to TRUE.
1641: IF FND_API.to_Boolean( p_init_msg_list )
1642: THEN
1643: FND_MSG_PUB.initialize;
1644: END IF;
1645:
1646:
1647:

Line 1668: FND_MSG_PUB.count_and_get(

1664: Ozf_Create_Ozf_Prod_Line_Pkg.Lock_Row(l_off_discount_product_id,p_object_version);
1665:
1666:
1667: -------------------- finish --------------------------
1668: FND_MSG_PUB.count_and_get(
1669: p_encoded => FND_API.g_false,
1670: p_count => x_msg_count,
1671: p_data => x_msg_data);
1672: OZF_Utility_PVT.debug_message(l_full_name ||': end');

Line 1683: FND_MSG_PUB.Count_And_Get (

1679: WHEN FND_API.G_EXC_ERROR THEN
1680: ROLLBACK TO Lock_Ozf_Prod_Line_PVT;
1681: x_return_status := FND_API.G_RET_STS_ERROR;
1682: -- Standard call to get message count and if count=1, get the message
1683: FND_MSG_PUB.Count_And_Get (
1684: p_encoded => FND_API.G_FALSE,
1685: p_count => x_msg_count,
1686: p_data => x_msg_data
1687: );

Line 1693: FND_MSG_PUB.Count_And_Get (

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

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

1698:
1699: WHEN OTHERS THEN
1700: ROLLBACK TO Lock_Ozf_Prod_Line_PVT;
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1702: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1703: THEN
1704: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1705: END IF;
1706: -- Standard call to get message count and if count=1, get the message

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

1700: ROLLBACK TO Lock_Ozf_Prod_Line_PVT;
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1702: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1703: THEN
1704: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1705: END IF;
1706: -- Standard call to get message count and if count=1, get the message
1707: FND_MSG_PUB.Count_And_Get (
1708: p_encoded => FND_API.G_FALSE,

Line 1707: FND_MSG_PUB.Count_And_Get (

1703: THEN
1704: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1705: END IF;
1706: -- Standard call to get message count and if count=1, get the message
1707: FND_MSG_PUB.Count_And_Get (
1708: p_encoded => FND_API.G_FALSE,
1709: p_count => x_msg_count,
1710: p_data => x_msg_data
1711: );

Line 2113: FND_MSG_PUB.initialize;

2109: BEGIN
2110: -- Initialize message list if p_init_msg_list is set to TRUE.
2111: IF FND_API.to_Boolean( p_init_msg_list )
2112: THEN
2113: FND_MSG_PUB.initialize;
2114: END IF;
2115:
2116:
2117:

Line 2129: FND_MSG_PUB.Count_And_Get

2125:
2126: -- Debug Message
2127: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2128: -- Standard call to get message count and if count is 1, get message info.
2129: FND_MSG_PUB.Count_And_Get
2130: (p_count => x_msg_count,
2131: p_data => x_msg_data
2132: );
2133: END Validate_ozf_prod_Rec;

Line 2167: FND_MSG_PUB.initialize;

2163:
2164: -- Initialize message list if p_init_msg_list is set to TRUE.
2165: IF FND_API.to_Boolean( p_init_msg_list )
2166: THEN
2167: FND_MSG_PUB.initialize;
2168: END IF;
2169:
2170: -- Debug Message
2171: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 2220: FND_MSG_PUB.Count_And_Get

2216: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2217:
2218:
2219: -- Standard call to get message count and if count is 1, get message info.
2220: FND_MSG_PUB.Count_And_Get
2221: (p_count => x_msg_count,
2222: p_data => x_msg_data
2223: );
2224: EXCEPTION

Line 2234: FND_MSG_PUB.Count_And_Get (

2230: WHEN FND_API.G_EXC_ERROR THEN
2231: ROLLBACK TO VALIDATE_Create_Ozf_Prod_Line_;
2232: x_return_status := FND_API.G_RET_STS_ERROR;
2233: -- Standard call to get message count and if count=1, get the message
2234: FND_MSG_PUB.Count_And_Get (
2235: p_encoded => FND_API.G_FALSE,
2236: p_count => x_msg_count,
2237: p_data => x_msg_data
2238: );

Line 2244: FND_MSG_PUB.Count_And_Get (

2240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2241: ROLLBACK TO VALIDATE_Create_Ozf_Prod_Line_;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: -- Standard call to get message count and if count=1, get the message
2244: FND_MSG_PUB.Count_And_Get (
2245: p_encoded => FND_API.G_FALSE,
2246: p_count => x_msg_count,
2247: p_data => x_msg_data
2248: );

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

2249:
2250: WHEN OTHERS THEN
2251: ROLLBACK TO VALIDATE_Create_Ozf_Prod_Line_;
2252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2253: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2254: THEN
2255: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2256: END IF;
2257: -- Standard call to get message count and if count=1, get the message

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

2251: ROLLBACK TO VALIDATE_Create_Ozf_Prod_Line_;
2252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2253: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2254: THEN
2255: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2256: END IF;
2257: -- Standard call to get message count and if count=1, get the message
2258: FND_MSG_PUB.Count_And_Get (
2259: p_encoded => FND_API.G_FALSE,

Line 2258: FND_MSG_PUB.Count_And_Get (

2254: THEN
2255: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2256: END IF;
2257: -- Standard call to get message count and if count=1, get the message
2258: FND_MSG_PUB.Count_And_Get (
2259: p_encoded => FND_API.G_FALSE,
2260: p_count => x_msg_count,
2261: p_data => x_msg_data
2262: );

Line 2349: FND_MSG_PUB.initialize;

2345:
2346: -- Initialize message list if p_init_msg_list is set to TRUE.
2347: IF FND_API.to_Boolean( p_init_msg_list )
2348: THEN
2349: FND_MSG_PUB.initialize;
2350: END IF;
2351:
2352:
2353:

Line 2463: FND_MSG_PUB.Count_And_Get

2459: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2460:
2461:
2462: -- Standard call to get message count and if count is 1, get message info.
2463: FND_MSG_PUB.Count_And_Get
2464: (p_count => x_msg_count,
2465: p_data => x_msg_data
2466: );
2467: EXCEPTION

Line 2477: FND_MSG_PUB.Count_And_Get (

2473: WHEN FND_API.G_EXC_ERROR THEN
2474: ROLLBACK TO Create_Ozf_Prod_Line_PVT;
2475: x_return_status := FND_API.G_RET_STS_ERROR;
2476: -- Standard call to get message count and if count=1, get the message
2477: FND_MSG_PUB.Count_And_Get (
2478: p_encoded => FND_API.G_FALSE,
2479: p_count => x_msg_count,
2480: p_data => x_msg_data
2481: );

Line 2487: FND_MSG_PUB.Count_And_Get (

2483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2484: ROLLBACK TO Create_Ozf_Prod_Line_PVT;
2485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2486: -- Standard call to get message count and if count=1, get the message
2487: FND_MSG_PUB.Count_And_Get (
2488: p_encoded => FND_API.G_FALSE,
2489: p_count => x_msg_count,
2490: p_data => x_msg_data
2491: );

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

2492:
2493: WHEN OTHERS THEN
2494: ROLLBACK TO Create_Ozf_Prod_Line_PVT;
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2496: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2497: THEN
2498: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2499: END IF;
2500: -- Standard call to get message count and if count=1, get the message

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

2494: ROLLBACK TO Create_Ozf_Prod_Line_PVT;
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2496: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2497: THEN
2498: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2499: END IF;
2500: -- Standard call to get message count and if count=1, get the message
2501: FND_MSG_PUB.Count_And_Get (
2502: p_encoded => FND_API.G_FALSE,

Line 2501: FND_MSG_PUB.Count_And_Get (

2497: THEN
2498: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2499: END IF;
2500: -- Standard call to get message count and if count=1, get the message
2501: FND_MSG_PUB.Count_And_Get (
2502: p_encoded => FND_API.G_FALSE,
2503: p_count => x_msg_count,
2504: p_data => x_msg_data
2505: );

Line 2591: FND_MSG_PUB.initialize;

2587:
2588: -- Initialize message list if p_init_msg_list is set to TRUE.
2589: IF FND_API.to_Boolean( p_init_msg_list )
2590: THEN
2591: FND_MSG_PUB.initialize;
2592: END IF;
2593:
2594:
2595:

Line 2661: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

2657: END IF;
2658:
2659:
2660: -- Debug Message
2661: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
2662:
2663: -- Invoke table handler(Ozf_Create_Ozf_Prod_Line_Pkg.Update_Row)
2664: Ozf_Create_Ozf_Prod_Line_Pkg.Update_Row(
2665: p_off_discount_product_id => p_ozf_prod_rec.off_discount_product_id,

Line 2696: FND_MSG_PUB.Count_And_Get

2692: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2693:
2694:
2695: -- Standard call to get message count and if count is 1, get message info.
2696: FND_MSG_PUB.Count_And_Get
2697: (p_count => x_msg_count,
2698: p_data => x_msg_data
2699: );
2700: EXCEPTION

Line 2710: FND_MSG_PUB.Count_And_Get (

2706: WHEN FND_API.G_EXC_ERROR THEN
2707: ROLLBACK TO Update_Ozf_Prod_Line_PVT;
2708: x_return_status := FND_API.G_RET_STS_ERROR;
2709: -- Standard call to get message count and if count=1, get the message
2710: FND_MSG_PUB.Count_And_Get (
2711: p_encoded => FND_API.G_FALSE,
2712: p_count => x_msg_count,
2713: p_data => x_msg_data
2714: );

Line 2720: FND_MSG_PUB.Count_And_Get (

2716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2717: ROLLBACK TO Update_Ozf_Prod_Line_PVT;
2718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2719: -- Standard call to get message count and if count=1, get the message
2720: FND_MSG_PUB.Count_And_Get (
2721: p_encoded => FND_API.G_FALSE,
2722: p_count => x_msg_count,
2723: p_data => x_msg_data
2724: );

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

2725:
2726: WHEN OTHERS THEN
2727: ROLLBACK TO Update_Ozf_Prod_Line_PVT;
2728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2729: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2730: THEN
2731: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2732: END IF;
2733: -- Standard call to get message count and if count=1, get the message

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

2727: ROLLBACK TO Update_Ozf_Prod_Line_PVT;
2728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2729: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2730: THEN
2731: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2732: END IF;
2733: -- Standard call to get message count and if count=1, get the message
2734: FND_MSG_PUB.Count_And_Get (
2735: p_encoded => FND_API.G_FALSE,

Line 2734: FND_MSG_PUB.Count_And_Get (

2730: THEN
2731: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2732: END IF;
2733: -- Standard call to get message count and if count=1, get the message
2734: FND_MSG_PUB.Count_And_Get (
2735: p_encoded => FND_API.G_FALSE,
2736: p_count => x_msg_count,
2737: p_data => x_msg_data
2738: );

Line 2779: FND_MSG_PUB.Count_And_Get (

2775: WHEN FND_API.G_EXC_ERROR THEN
2776: ROLLBACK TO Delete_Exclusions_sp;
2777: x_return_status := FND_API.G_RET_STS_ERROR;
2778: -- Standard call to get message count and if count=1, get the message
2779: FND_MSG_PUB.Count_And_Get (
2780: p_encoded => FND_API.G_FALSE,
2781: p_count => x_msg_count,
2782: p_data => x_msg_data
2783: );

Line 2789: FND_MSG_PUB.Count_And_Get (

2785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2786: ROLLBACK TO Delete_Exclusions_sp;
2787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2788: -- Standard call to get message count and if count=1, get the message
2789: FND_MSG_PUB.Count_And_Get (
2790: p_encoded => FND_API.G_FALSE,
2791: p_count => x_msg_count,
2792: p_data => x_msg_data
2793: );

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

2794:
2795: WHEN OTHERS THEN
2796: ROLLBACK TO Delete_Exclusions_sp;
2797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2798: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2799: THEN
2800: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2801: END IF;
2802: -- Standard call to get message count and if count=1, get the message

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

2796: ROLLBACK TO Delete_Exclusions_sp;
2797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2798: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2799: THEN
2800: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2801: END IF;
2802: -- Standard call to get message count and if count=1, get the message
2803: FND_MSG_PUB.Count_And_Get (
2804: p_encoded => FND_API.G_FALSE,

Line 2803: FND_MSG_PUB.Count_And_Get (

2799: THEN
2800: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2801: END IF;
2802: -- Standard call to get message count and if count=1, get the message
2803: FND_MSG_PUB.Count_And_Get (
2804: p_encoded => FND_API.G_FALSE,
2805: p_count => x_msg_count,
2806: p_data => x_msg_data
2807: );

Line 2884: FND_MSG_PUB.initialize;

2880:
2881: -- Initialize message list if p_init_msg_list is set to TRUE.
2882: IF FND_API.to_Boolean( p_init_msg_list )
2883: THEN
2884: FND_MSG_PUB.initialize;
2885: END IF;
2886:
2887:
2888:

Line 2943: FND_MSG_PUB.Count_And_Get

2939: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2940:
2941:
2942: -- Standard call to get message count and if count is 1, get message info.
2943: FND_MSG_PUB.Count_And_Get
2944: (p_count => x_msg_count,
2945: p_data => x_msg_data
2946: );
2947: EXCEPTION

Line 2957: FND_MSG_PUB.Count_And_Get (

2953: WHEN FND_API.G_EXC_ERROR THEN
2954: ROLLBACK TO Delete_Ozf_Prod_Line_PVT;
2955: x_return_status := FND_API.G_RET_STS_ERROR;
2956: -- Standard call to get message count and if count=1, get the message
2957: FND_MSG_PUB.Count_And_Get (
2958: p_encoded => FND_API.G_FALSE,
2959: p_count => x_msg_count,
2960: p_data => x_msg_data
2961: );

Line 2967: FND_MSG_PUB.Count_And_Get (

2963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2964: ROLLBACK TO Delete_Ozf_Prod_Line_PVT;
2965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2966: -- Standard call to get message count and if count=1, get the message
2967: FND_MSG_PUB.Count_And_Get (
2968: p_encoded => FND_API.G_FALSE,
2969: p_count => x_msg_count,
2970: p_data => x_msg_data
2971: );

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

2972:
2973: WHEN OTHERS THEN
2974: ROLLBACK TO Delete_Ozf_Prod_Line_PVT;
2975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2976: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2977: THEN
2978: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2979: END IF;
2980: -- Standard call to get message count and if count=1, get the message

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

2974: ROLLBACK TO Delete_Ozf_Prod_Line_PVT;
2975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2976: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2977: THEN
2978: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2979: END IF;
2980: -- Standard call to get message count and if count=1, get the message
2981: FND_MSG_PUB.Count_And_Get (
2982: p_encoded => FND_API.G_FALSE,

Line 2981: FND_MSG_PUB.Count_And_Get (

2977: THEN
2978: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2979: END IF;
2980: -- Standard call to get message count and if count=1, get the message
2981: FND_MSG_PUB.Count_And_Get (
2982: p_encoded => FND_API.G_FALSE,
2983: p_count => x_msg_count,
2984: p_data => x_msg_data
2985: );

Line 3053: FND_MSG_PUB.initialize;

3049:
3050: -- Initialize message list if p_init_msg_list is set to TRUE.
3051: IF FND_API.to_Boolean( p_init_msg_list )
3052: THEN
3053: FND_MSG_PUB.initialize;
3054: END IF;
3055:
3056:
3057:

Line 3078: FND_MSG_PUB.count_and_get(

3074: Ozf_Prod_Reln_Pkg.Lock_Row(l_discount_product_reln_id,p_object_version);
3075:
3076:
3077: -------------------- finish --------------------------
3078: FND_MSG_PUB.count_and_get(
3079: p_encoded => FND_API.g_false,
3080: p_count => x_msg_count,
3081: p_data => x_msg_data);
3082: OZF_Utility_PVT.debug_message(l_full_name ||': end');

Line 3093: FND_MSG_PUB.Count_And_Get (

3089: WHEN FND_API.G_EXC_ERROR THEN
3090: ROLLBACK TO LOCK_Prod_Reln_PVT;
3091: x_return_status := FND_API.G_RET_STS_ERROR;
3092: -- Standard call to get message count and if count=1, get the message
3093: FND_MSG_PUB.Count_And_Get (
3094: p_encoded => FND_API.G_FALSE,
3095: p_count => x_msg_count,
3096: p_data => x_msg_data
3097: );

Line 3103: FND_MSG_PUB.Count_And_Get (

3099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3100: ROLLBACK TO LOCK_Prod_Reln_PVT;
3101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3102: -- Standard call to get message count and if count=1, get the message
3103: FND_MSG_PUB.Count_And_Get (
3104: p_encoded => FND_API.G_FALSE,
3105: p_count => x_msg_count,
3106: p_data => x_msg_data
3107: );

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

3108:
3109: WHEN OTHERS THEN
3110: ROLLBACK TO LOCK_Prod_Reln_PVT;
3111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3112: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3113: THEN
3114: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3115: END IF;
3116: -- Standard call to get message count and if count=1, get the message

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

3110: ROLLBACK TO LOCK_Prod_Reln_PVT;
3111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3112: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3113: THEN
3114: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3115: END IF;
3116: -- Standard call to get message count and if count=1, get the message
3117: FND_MSG_PUB.Count_And_Get (
3118: p_encoded => FND_API.G_FALSE,

Line 3117: FND_MSG_PUB.Count_And_Get (

3113: THEN
3114: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3115: END IF;
3116: -- Standard call to get message count and if count=1, get the message
3117: FND_MSG_PUB.Count_And_Get (
3118: p_encoded => FND_API.G_FALSE,
3119: p_count => x_msg_count,
3120: p_data => x_msg_data
3121: );

Line 3404: FND_MSG_PUB.initialize;

3400: BEGIN
3401: -- Initialize message list if p_init_msg_list is set to TRUE.
3402: IF FND_API.to_Boolean( p_init_msg_list )
3403: THEN
3404: FND_MSG_PUB.initialize;
3405: END IF;
3406:
3407:
3408:

Line 3420: FND_MSG_PUB.Count_And_Get

3416:
3417: -- Debug Message
3418: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
3419: -- Standard call to get message count and if count is 1, get message info.
3420: FND_MSG_PUB.Count_And_Get
3421: (p_count => x_msg_count,
3422: p_data => x_msg_data
3423: );
3424: END Validate_prod_reln_Rec;

Line 3461: FND_MSG_PUB.initialize;

3457:
3458: -- Initialize message list if p_init_msg_list is set to TRUE.
3459: IF FND_API.to_Boolean( p_init_msg_list )
3460: THEN
3461: FND_MSG_PUB.initialize;
3462: END IF;
3463:
3464: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3465: Check_prod_reln_Items(

Line 3520: FND_MSG_PUB.Count_And_Get

3516: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3517:
3518:
3519: -- Standard call to get message count and if count is 1, get message info.
3520: FND_MSG_PUB.Count_And_Get
3521: (p_count => x_msg_count,
3522: p_data => x_msg_data
3523: );
3524: EXCEPTION

Line 3534: FND_MSG_PUB.Count_And_Get (

3530: WHEN FND_API.G_EXC_ERROR THEN
3531: ROLLBACK TO VALIDATE_Prod_Reln_;
3532: x_return_status := FND_API.G_RET_STS_ERROR;
3533: -- Standard call to get message count and if count=1, get the message
3534: FND_MSG_PUB.Count_And_Get (
3535: p_encoded => FND_API.G_FALSE,
3536: p_count => x_msg_count,
3537: p_data => x_msg_data
3538: );

Line 3544: FND_MSG_PUB.Count_And_Get (

3540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3541: ROLLBACK TO VALIDATE_Prod_Reln_;
3542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3543: -- Standard call to get message count and if count=1, get the message
3544: FND_MSG_PUB.Count_And_Get (
3545: p_encoded => FND_API.G_FALSE,
3546: p_count => x_msg_count,
3547: p_data => x_msg_data
3548: );

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

3549:
3550: WHEN OTHERS THEN
3551: ROLLBACK TO VALIDATE_Prod_Reln_;
3552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3553: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3554: THEN
3555: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3556: END IF;
3557: -- Standard call to get message count and if count=1, get the message

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

3551: ROLLBACK TO VALIDATE_Prod_Reln_;
3552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3553: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3554: THEN
3555: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3556: END IF;
3557: -- Standard call to get message count and if count=1, get the message
3558: FND_MSG_PUB.Count_And_Get (
3559: p_encoded => FND_API.G_FALSE,

Line 3558: FND_MSG_PUB.Count_And_Get (

3554: THEN
3555: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3556: END IF;
3557: -- Standard call to get message count and if count=1, get the message
3558: FND_MSG_PUB.Count_And_Get (
3559: p_encoded => FND_API.G_FALSE,
3560: p_count => x_msg_count,
3561: p_data => x_msg_data
3562: );

Line 3652: FND_MSG_PUB.initialize;

3648:
3649: -- Initialize message list if p_init_msg_list is set to TRUE.
3650: IF FND_API.to_Boolean( p_init_msg_list )
3651: THEN
3652: FND_MSG_PUB.initialize;
3653: END IF;
3654:
3655:
3656:

Line 3755: FND_MSG_PUB.Count_And_Get

3751: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3752:
3753:
3754: -- Standard call to get message count and if count is 1, get message info.
3755: FND_MSG_PUB.Count_And_Get
3756: (p_count => x_msg_count,
3757: p_data => x_msg_data
3758: );
3759: EXCEPTION

Line 3769: FND_MSG_PUB.Count_And_Get (

3765: WHEN FND_API.G_EXC_ERROR THEN
3766: ROLLBACK TO CREATE_Prod_Reln_PVT;
3767: x_return_status := FND_API.G_RET_STS_ERROR;
3768: -- Standard call to get message count and if count=1, get the message
3769: FND_MSG_PUB.Count_And_Get (
3770: p_encoded => FND_API.G_FALSE,
3771: p_count => x_msg_count,
3772: p_data => x_msg_data
3773: );

Line 3779: FND_MSG_PUB.Count_And_Get (

3775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3776: ROLLBACK TO CREATE_Prod_Reln_PVT;
3777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3778: -- Standard call to get message count and if count=1, get the message
3779: FND_MSG_PUB.Count_And_Get (
3780: p_encoded => FND_API.G_FALSE,
3781: p_count => x_msg_count,
3782: p_data => x_msg_data
3783: );

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

3784:
3785: WHEN OTHERS THEN
3786: ROLLBACK TO CREATE_Prod_Reln_PVT;
3787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3788: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3789: THEN
3790: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3791: END IF;
3792: -- Standard call to get message count and if count=1, get the message

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

3786: ROLLBACK TO CREATE_Prod_Reln_PVT;
3787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3788: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3789: THEN
3790: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3791: END IF;
3792: -- Standard call to get message count and if count=1, get the message
3793: FND_MSG_PUB.Count_And_Get (
3794: p_encoded => FND_API.G_FALSE,

Line 3793: FND_MSG_PUB.Count_And_Get (

3789: THEN
3790: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3791: END IF;
3792: -- Standard call to get message count and if count=1, get the message
3793: FND_MSG_PUB.Count_And_Get (
3794: p_encoded => FND_API.G_FALSE,
3795: p_count => x_msg_count,
3796: p_data => x_msg_data
3797: );

Line 3883: FND_MSG_PUB.initialize;

3879:
3880: -- Initialize message list if p_init_msg_list is set to TRUE.
3881: IF FND_API.to_Boolean( p_init_msg_list )
3882: THEN
3883: FND_MSG_PUB.initialize;
3884: END IF;
3885:
3886:
3887:

Line 3953: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

3949: END IF;
3950:
3951:
3952: -- Debug Message
3953: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
3954:
3955: -- Invoke table handler(Ozf_Prod_Reln_Pkg.Update_Row)
3956: Ozf_Prod_Reln_Pkg.Update_Row(
3957: p_discount_product_reln_id => p_prod_reln_rec.discount_product_reln_id,

Line 3981: FND_MSG_PUB.Count_And_Get

3977: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3978:
3979:
3980: -- Standard call to get message count and if count is 1, get message info.
3981: FND_MSG_PUB.Count_And_Get
3982: (p_count => x_msg_count,
3983: p_data => x_msg_data
3984: );
3985: EXCEPTION

Line 3995: FND_MSG_PUB.Count_And_Get (

3991: WHEN FND_API.G_EXC_ERROR THEN
3992: ROLLBACK TO UPDATE_Prod_Reln_PVT;
3993: x_return_status := FND_API.G_RET_STS_ERROR;
3994: -- Standard call to get message count and if count=1, get the message
3995: FND_MSG_PUB.Count_And_Get (
3996: p_encoded => FND_API.G_FALSE,
3997: p_count => x_msg_count,
3998: p_data => x_msg_data
3999: );

Line 4005: FND_MSG_PUB.Count_And_Get (

4001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4002: ROLLBACK TO UPDATE_Prod_Reln_PVT;
4003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4004: -- Standard call to get message count and if count=1, get the message
4005: FND_MSG_PUB.Count_And_Get (
4006: p_encoded => FND_API.G_FALSE,
4007: p_count => x_msg_count,
4008: p_data => x_msg_data
4009: );

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

4010:
4011: WHEN OTHERS THEN
4012: ROLLBACK TO UPDATE_Prod_Reln_PVT;
4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4014: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4015: THEN
4016: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4017: END IF;
4018: -- Standard call to get message count and if count=1, get the message

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

4012: ROLLBACK TO UPDATE_Prod_Reln_PVT;
4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4014: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4015: THEN
4016: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4017: END IF;
4018: -- Standard call to get message count and if count=1, get the message
4019: FND_MSG_PUB.Count_And_Get (
4020: p_encoded => FND_API.G_FALSE,

Line 4019: FND_MSG_PUB.Count_And_Get (

4015: THEN
4016: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4017: END IF;
4018: -- Standard call to get message count and if count=1, get the message
4019: FND_MSG_PUB.Count_And_Get (
4020: p_encoded => FND_API.G_FALSE,
4021: p_count => x_msg_count,
4022: p_data => x_msg_data
4023: );

Line 4095: FND_MSG_PUB.initialize;

4091:
4092: -- Initialize message list if p_init_msg_list is set to TRUE.
4093: IF FND_API.to_Boolean( p_init_msg_list )
4094: THEN
4095: FND_MSG_PUB.initialize;
4096: END IF;
4097:
4098:
4099:

Line 4134: FND_MSG_PUB.Count_And_Get

4130: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
4131:
4132:
4133: -- Standard call to get message count and if count is 1, get message info.
4134: FND_MSG_PUB.Count_And_Get
4135: (p_count => x_msg_count,
4136: p_data => x_msg_data
4137: );
4138: EXCEPTION

Line 4148: FND_MSG_PUB.Count_And_Get (

4144: WHEN FND_API.G_EXC_ERROR THEN
4145: ROLLBACK TO DELETE_Prod_Reln_PVT;
4146: x_return_status := FND_API.G_RET_STS_ERROR;
4147: -- Standard call to get message count and if count=1, get the message
4148: FND_MSG_PUB.Count_And_Get (
4149: p_encoded => FND_API.G_FALSE,
4150: p_count => x_msg_count,
4151: p_data => x_msg_data
4152: );

Line 4158: FND_MSG_PUB.Count_And_Get (

4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: ROLLBACK TO DELETE_Prod_Reln_PVT;
4156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4157: -- Standard call to get message count and if count=1, get the message
4158: FND_MSG_PUB.Count_And_Get (
4159: p_encoded => FND_API.G_FALSE,
4160: p_count => x_msg_count,
4161: p_data => x_msg_data
4162: );

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

4163:
4164: WHEN OTHERS THEN
4165: ROLLBACK TO DELETE_Prod_Reln_PVT;
4166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4167: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4168: THEN
4169: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4170: END IF;
4171: -- Standard call to get message count and if count=1, get the message

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

4165: ROLLBACK TO DELETE_Prod_Reln_PVT;
4166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4167: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4168: THEN
4169: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4170: END IF;
4171: -- Standard call to get message count and if count=1, get the message
4172: FND_MSG_PUB.Count_And_Get (
4173: p_encoded => FND_API.G_FALSE,

Line 4172: FND_MSG_PUB.Count_And_Get (

4168: THEN
4169: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4170: END IF;
4171: -- Standard call to get message count and if count=1, get the message
4172: FND_MSG_PUB.Count_And_Get (
4173: p_encoded => FND_API.G_FALSE,
4174: p_count => x_msg_count,
4175: p_data => x_msg_data
4176: );

Line 4291: FND_MSG_PUB.initialize;

4287:
4288: -- Initialize message list if p_init_msg_list is set to TRUE.
4289: IF FND_API.to_Boolean( p_init_msg_list )
4290: THEN
4291: FND_MSG_PUB.initialize;
4292: END IF;
4293:
4294:
4295: -- Debug Message

Line 4356: FND_MSG_PUB.Count_And_Get (

4352: WHEN FND_API.G_EXC_ERROR THEN
4353: ROLLBACK TO Create_Product_pvt;
4354: x_return_status := FND_API.G_RET_STS_ERROR;
4355: -- Standard call to get message count and if count=1, get the message
4356: FND_MSG_PUB.Count_And_Get (
4357: p_encoded => FND_API.G_FALSE,
4358: p_count => l_msg_count,
4359: p_data => l_msg_data
4360: );

Line 4366: FND_MSG_PUB.Count_And_Get (

4362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4363: ROLLBACK TO Create_Product_pvt;
4364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4365: -- Standard call to get message count and if count=1, get the message
4366: FND_MSG_PUB.Count_And_Get (
4367: p_encoded => FND_API.G_FALSE,
4368: p_count => l_msg_count,
4369: p_data => l_msg_data
4370: );

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

4371:
4372: WHEN OTHERS THEN
4373: ROLLBACK TO Create_Product_pvt;
4374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4375: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4376: THEN
4377: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4378: END IF;
4379: -- Standard call to get message count and if count=1, get the message

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

4373: ROLLBACK TO Create_Product_pvt;
4374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4375: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4376: THEN
4377: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4378: END IF;
4379: -- Standard call to get message count and if count=1, get the message
4380: FND_MSG_PUB.Count_And_Get (
4381: p_encoded => FND_API.G_FALSE,

Line 4380: FND_MSG_PUB.Count_And_Get (

4376: THEN
4377: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4378: END IF;
4379: -- Standard call to get message count and if count=1, get the message
4380: FND_MSG_PUB.Count_And_Get (
4381: p_encoded => FND_API.G_FALSE,
4382: p_count => l_msg_count,
4383: p_data => l_msg_data
4384: );

Line 4468: FND_MSG_PUB.initialize;

4464:
4465: -- Initialize message list if p_init_msg_list is set to TRUE.
4466: IF FND_API.to_Boolean( p_init_msg_list )
4467: THEN
4468: FND_MSG_PUB.initialize;
4469: END IF;
4470:
4471:
4472:

Line 4528: FND_MSG_PUB.Count_And_Get

4524: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
4525:
4526:
4527: -- Standard call to get message count and if count is 1, get message info.
4528: FND_MSG_PUB.Count_And_Get
4529: (p_count => x_msg_count,
4530: p_data => x_msg_data
4531: );
4532:

Line 4540: FND_MSG_PUB.Count_And_Get (

4536: WHEN FND_API.G_EXC_ERROR THEN
4537: ROLLBACK TO Create_offer_line_pvt;
4538: x_return_status := FND_API.G_RET_STS_ERROR;
4539: -- Standard call to get message count and if count=1, get the message
4540: FND_MSG_PUB.Count_And_Get (
4541: p_encoded => FND_API.G_FALSE,
4542: p_count => x_msg_count,
4543: p_data => x_msg_data
4544: );

Line 4550: FND_MSG_PUB.Count_And_Get (

4546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4547: ROLLBACK TO Create_offer_line_pvt;
4548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4549: -- Standard call to get message count and if count=1, get the message
4550: FND_MSG_PUB.Count_And_Get (
4551: p_encoded => FND_API.G_FALSE,
4552: p_count => x_msg_count,
4553: p_data => x_msg_data
4554: );

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

4555:
4556: WHEN OTHERS THEN
4557: ROLLBACK TO Create_offer_line_pvt;
4558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4559: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4560: THEN
4561: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4562: END IF;
4563: -- Standard call to get message count and if count=1, get the message

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

4557: ROLLBACK TO Create_offer_line_pvt;
4558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4559: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4560: THEN
4561: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4562: END IF;
4563: -- Standard call to get message count and if count=1, get the message
4564: FND_MSG_PUB.Count_And_Get (
4565: p_encoded => FND_API.G_FALSE,

Line 4564: FND_MSG_PUB.Count_And_Get (

4560: THEN
4561: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4562: END IF;
4563: -- Standard call to get message count and if count=1, get the message
4564: FND_MSG_PUB.Count_And_Get (
4565: p_encoded => FND_API.G_FALSE,
4566: p_count => x_msg_count,
4567: p_data => x_msg_data
4568: );

Line 4734: FND_MSG_PUB.initialize;

4730:
4731: -- Initialize message list if p_init_msg_list is set to TRUE.
4732: IF FND_API.to_Boolean( p_init_msg_list )
4733: THEN
4734: FND_MSG_PUB.initialize;
4735: END IF;
4736:
4737:
4738:

Line 4787: FND_MSG_PUB.Count_And_Get

4783: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
4784:
4785:
4786: -- Standard call to get message count and if count is 1, get message info.
4787: FND_MSG_PUB.Count_And_Get
4788: (p_count => x_msg_count,
4789: p_data => x_msg_data
4790: );
4791:

Line 4798: FND_MSG_PUB.Count_And_Get (

4794: WHEN FND_API.G_EXC_ERROR THEN
4795: ROLLBACK TO Create_discount_line_pvt;
4796: x_return_status := FND_API.G_RET_STS_ERROR;
4797: -- Standard call to get message count and if count=1, get the message
4798: FND_MSG_PUB.Count_And_Get (
4799: p_encoded => FND_API.G_FALSE,
4800: p_count => x_msg_count,
4801: p_data => x_msg_data
4802: );

Line 4808: FND_MSG_PUB.Count_And_Get (

4804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4805: ROLLBACK TO Create_discount_line_pvt;
4806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4807: -- Standard call to get message count and if count=1, get the message
4808: FND_MSG_PUB.Count_And_Get (
4809: p_encoded => FND_API.G_FALSE,
4810: p_count => x_msg_count,
4811: p_data => x_msg_data
4812: );

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

4813:
4814: WHEN OTHERS THEN
4815: ROLLBACK TO Create_discount_line_pvt;
4816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4817: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4818: THEN
4819: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4820: END IF;
4821: -- Standard call to get message count and if count=1, get the message

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

4815: ROLLBACK TO Create_discount_line_pvt;
4816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4817: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4818: THEN
4819: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4820: END IF;
4821: -- Standard call to get message count and if count=1, get the message
4822: FND_MSG_PUB.Count_And_Get (
4823: p_encoded => FND_API.G_FALSE,

Line 4822: FND_MSG_PUB.Count_And_Get (

4818: THEN
4819: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4820: END IF;
4821: -- Standard call to get message count and if count=1, get the message
4822: FND_MSG_PUB.Count_And_Get (
4823: p_encoded => FND_API.G_FALSE,
4824: p_count => x_msg_count,
4825: p_data => x_msg_data
4826: );

Line 4908: FND_MSG_PUB.initialize;

4904:
4905: -- Initialize message list if p_init_msg_list is set to TRUE.
4906: IF FND_API.to_Boolean( p_init_msg_list )
4907: THEN
4908: FND_MSG_PUB.initialize;
4909: END IF;
4910:
4911:
4912: -- Debug Message

Line 4964: FND_MSG_PUB.Count_And_Get

4960: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
4961:
4962:
4963: -- Standard call to get message count and if count is 1, get message info.
4964: FND_MSG_PUB.Count_And_Get
4965: (p_count => x_msg_count,
4966: p_data => x_msg_data
4967: );
4968:

Line 4974: FND_MSG_PUB.Count_And_Get (

4970: WHEN FND_API.G_EXC_ERROR THEN
4971: ROLLBACK TO Update_offer_line_pvt;
4972: x_return_status := FND_API.G_RET_STS_ERROR;
4973: -- Standard call to get message count and if count=1, get the message
4974: FND_MSG_PUB.Count_And_Get (
4975: p_encoded => FND_API.G_FALSE,
4976: p_count => x_msg_count,
4977: p_data => x_msg_data
4978: );

Line 4984: FND_MSG_PUB.Count_And_Get (

4980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4981: ROLLBACK TO Update_offer_line_pvt;
4982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4983: -- Standard call to get message count and if count=1, get the message
4984: FND_MSG_PUB.Count_And_Get (
4985: p_encoded => FND_API.G_FALSE,
4986: p_count => x_msg_count,
4987: p_data => x_msg_data
4988: );

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

4989:
4990: WHEN OTHERS THEN
4991: ROLLBACK TO Update_offer_line_pvt;
4992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4993: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4994: THEN
4995: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4996: END IF;
4997: -- Standard call to get message count and if count=1, get the message

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

4991: ROLLBACK TO Update_offer_line_pvt;
4992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4993: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4994: THEN
4995: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4996: END IF;
4997: -- Standard call to get message count and if count=1, get the message
4998: FND_MSG_PUB.Count_And_Get (
4999: p_encoded => FND_API.G_FALSE,

Line 4998: FND_MSG_PUB.Count_And_Get (

4994: THEN
4995: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4996: END IF;
4997: -- Standard call to get message count and if count=1, get the message
4998: FND_MSG_PUB.Count_And_Get (
4999: p_encoded => FND_API.G_FALSE,
5000: p_count => x_msg_count,
5001: p_data => x_msg_data
5002: );

Line 5054: FND_MSG_PUB.initialize;

5050:
5051: -- Initialize message list if p_init_msg_list is set to TRUE.
5052: IF FND_API.to_Boolean( p_init_msg_list )
5053: THEN
5054: FND_MSG_PUB.initialize;
5055: END IF;
5056:
5057:
5058:

Line 5123: FND_MSG_PUB.Count_And_Get

5119: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
5120:
5121:
5122: -- Standard call to get message count and if count is 1, get message info.
5123: FND_MSG_PUB.Count_And_Get
5124: (p_count => x_msg_count,
5125: p_data => x_msg_data
5126: );
5127:

Line 5135: FND_MSG_PUB.Count_And_Get (

5131: WHEN FND_API.G_EXC_ERROR THEN
5132: ROLLBACK TO Update_discount_line_pvt;
5133: x_return_status := FND_API.G_RET_STS_ERROR;
5134: -- Standard call to get message count and if count=1, get the message
5135: FND_MSG_PUB.Count_And_Get (
5136: p_encoded => FND_API.G_FALSE,
5137: p_count => x_msg_count,
5138: p_data => x_msg_data
5139: );

Line 5145: FND_MSG_PUB.Count_And_Get (

5141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5142: ROLLBACK TO Update_discount_line_pvt;
5143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5144: -- Standard call to get message count and if count=1, get the message
5145: FND_MSG_PUB.Count_And_Get (
5146: p_encoded => FND_API.G_FALSE,
5147: p_count => x_msg_count,
5148: p_data => x_msg_data
5149: );

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

5150:
5151: WHEN OTHERS THEN
5152: ROLLBACK TO Update_discount_line_pvt;
5153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5154: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5155: THEN
5156: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5157: END IF;
5158: -- Standard call to get message count and if count=1, get the message

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

5152: ROLLBACK TO Update_discount_line_pvt;
5153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5154: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5155: THEN
5156: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5157: END IF;
5158: -- Standard call to get message count and if count=1, get the message
5159: FND_MSG_PUB.Count_And_Get (
5160: p_encoded => FND_API.G_FALSE,

Line 5159: FND_MSG_PUB.Count_And_Get (

5155: THEN
5156: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5157: END IF;
5158: -- Standard call to get message count and if count=1, get the message
5159: FND_MSG_PUB.Count_And_Get (
5160: p_encoded => FND_API.G_FALSE,
5161: p_count => x_msg_count,
5162: p_data => x_msg_data
5163: );

Line 5282: FND_MSG_PUB.initialize;

5278:
5279: -- Initialize message list if p_init_msg_list is set to TRUE.
5280: IF FND_API.to_Boolean( p_init_msg_list )
5281: THEN
5282: FND_MSG_PUB.initialize;
5283: END IF;
5284:
5285:
5286: -- Debug Message

Line 5349: FND_MSG_PUB.Count_And_Get

5345: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
5346:
5347:
5348: -- Standard call to get message count and if count is 1, get message info.
5349: FND_MSG_PUB.Count_And_Get
5350: (p_count => l_msg_count,
5351: p_data => l_msg_data
5352: );
5353:

Line 5359: FND_MSG_PUB.Count_And_Get (

5355: WHEN FND_API.G_EXC_ERROR THEN
5356: ROLLBACK TO Update_product_Pvt;
5357: x_return_status := FND_API.G_RET_STS_ERROR;
5358: -- Standard call to get message count and if count=1, get the message
5359: FND_MSG_PUB.Count_And_Get (
5360: p_encoded => FND_API.G_FALSE,
5361: p_count => l_msg_count,
5362: p_data => l_msg_data
5363: );

Line 5369: FND_MSG_PUB.Count_And_Get (

5365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5366: ROLLBACK TO Update_product_Pvt;
5367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5368: -- Standard call to get message count and if count=1, get the message
5369: FND_MSG_PUB.Count_And_Get (
5370: p_encoded => FND_API.G_FALSE,
5371: p_count => l_msg_count,
5372: p_data => l_msg_data
5373: );

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

5374:
5375: WHEN OTHERS THEN
5376: ROLLBACK TO Update_product_Pvt;
5377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5378: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5379: THEN
5380: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5381: END IF;
5382: -- Standard call to get message count and if count=1, get the message

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

5376: ROLLBACK TO Update_product_Pvt;
5377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5378: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5379: THEN
5380: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5381: END IF;
5382: -- Standard call to get message count and if count=1, get the message
5383: FND_MSG_PUB.Count_And_Get (
5384: p_encoded => FND_API.G_FALSE,

Line 5383: FND_MSG_PUB.Count_And_Get (

5379: THEN
5380: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5381: END IF;
5382: -- Standard call to get message count and if count=1, get the message
5383: FND_MSG_PUB.Count_And_Get (
5384: p_encoded => FND_API.G_FALSE,
5385: p_count => l_msg_count,
5386: p_data => l_msg_data
5387: );

Line 5458: FND_MSG_PUB.initialize;

5454:
5455: -- Initialize message list if p_init_msg_list is set to TRUE.
5456: IF FND_API.to_Boolean( p_init_msg_list )
5457: THEN
5458: FND_MSG_PUB.initialize;
5459: END IF;
5460:
5461:
5462: -- Debug Message

Line 5485: FND_MSG_PUB.Count_And_Get

5481: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
5482:
5483:
5484: -- Standard call to get message count and if count is 1, get message info.
5485: FND_MSG_PUB.Count_And_Get
5486: (p_count => l_msg_count,
5487: p_data => l_msg_data
5488: );
5489:

Line 5495: FND_MSG_PUB.Count_And_Get (

5491: WHEN FND_API.G_EXC_ERROR THEN
5492: ROLLBACK TO Delete_Relation_Pvt;
5493: x_return_status := FND_API.G_RET_STS_ERROR;
5494: -- Standard call to get message count and if count=1, get the message
5495: FND_MSG_PUB.Count_And_Get (
5496: p_encoded => FND_API.G_FALSE,
5497: p_count => l_msg_count,
5498: p_data => l_msg_data
5499: );

Line 5505: FND_MSG_PUB.Count_And_Get (

5501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5502: ROLLBACK TO Delete_Relation_Pvt;
5503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5504: -- Standard call to get message count and if count=1, get the message
5505: FND_MSG_PUB.Count_And_Get (
5506: p_encoded => FND_API.G_FALSE,
5507: p_count => l_msg_count,
5508: p_data => l_msg_data
5509: );

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

5510:
5511: WHEN OTHERS THEN
5512: ROLLBACK TO Delete_Relation_Pvt;
5513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5514: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5515: THEN
5516: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5517: END IF;
5518: -- Standard call to get message count and if count=1, get the message

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

5512: ROLLBACK TO Delete_Relation_Pvt;
5513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5514: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5515: THEN
5516: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5517: END IF;
5518: -- Standard call to get message count and if count=1, get the message
5519: FND_MSG_PUB.Count_And_Get (
5520: p_encoded => FND_API.G_FALSE,

Line 5519: FND_MSG_PUB.Count_And_Get (

5515: THEN
5516: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5517: END IF;
5518: -- Standard call to get message count and if count=1, get the message
5519: FND_MSG_PUB.Count_And_Get (
5520: p_encoded => FND_API.G_FALSE,
5521: p_count => l_msg_count,
5522: p_data => l_msg_data
5523: );

Line 5597: FND_MSG_PUB.initialize;

5593:
5594: -- Initialize message list if p_init_msg_list is set to TRUE.
5595: IF FND_API.to_Boolean( p_init_msg_list )
5596: THEN
5597: FND_MSG_PUB.initialize;
5598: END IF;
5599:
5600:
5601: -- Debug Message

Line 5638: FND_MSG_PUB.Count_And_Get

5634: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
5635:
5636:
5637: -- Standard call to get message count and if count is 1, get message info.
5638: FND_MSG_PUB.Count_And_Get
5639: (p_count => l_msg_count,
5640: p_data => l_msg_data
5641: );
5642:

Line 5648: FND_MSG_PUB.Count_And_Get (

5644: WHEN FND_API.G_EXC_ERROR THEN
5645: ROLLBACK TO Delete_Product_Pvt;
5646: x_return_status := FND_API.G_RET_STS_ERROR;
5647: -- Standard call to get message count and if count=1, get the message
5648: FND_MSG_PUB.Count_And_Get (
5649: p_encoded => FND_API.G_FALSE,
5650: p_count => l_msg_count,
5651: p_data => l_msg_data
5652: );

Line 5658: FND_MSG_PUB.Count_And_Get (

5654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5655: ROLLBACK TO Delete_Product_Pvt;
5656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5657: -- Standard call to get message count and if count=1, get the message
5658: FND_MSG_PUB.Count_And_Get (
5659: p_encoded => FND_API.G_FALSE,
5660: p_count => l_msg_count,
5661: p_data => l_msg_data
5662: );

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

5663:
5664: WHEN OTHERS THEN
5665: ROLLBACK TO Delete_Product_Pvt;
5666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5667: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5668: THEN
5669: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5670: END IF;
5671: -- Standard call to get message count and if count=1, get the message

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

5665: ROLLBACK TO Delete_Product_Pvt;
5666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5667: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5668: THEN
5669: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5670: END IF;
5671: -- Standard call to get message count and if count=1, get the message
5672: FND_MSG_PUB.Count_And_Get (
5673: p_encoded => FND_API.G_FALSE,

Line 5672: FND_MSG_PUB.Count_And_Get (

5668: THEN
5669: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5670: END IF;
5671: -- Standard call to get message count and if count=1, get the message
5672: FND_MSG_PUB.Count_And_Get (
5673: p_encoded => FND_API.G_FALSE,
5674: p_count => l_msg_count,
5675: p_data => l_msg_data
5676: );

Line 5766: FND_MSG_PUB.initialize;

5762:
5763: -- Initialize message list if p_init_msg_list is set to TRUE.
5764: IF FND_API.to_Boolean( p_init_msg_list )
5765: THEN
5766: FND_MSG_PUB.initialize;
5767: END IF;
5768:
5769:
5770: -- Debug Message

Line 5848: FND_MSG_PUB.Count_And_Get

5844: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
5845:
5846:
5847: -- Standard call to get message count and if count is 1, get message info.
5848: FND_MSG_PUB.Count_And_Get
5849: (p_count => x_msg_count,
5850: p_data => x_msg_data
5851: );
5852:

Line 5858: FND_MSG_PUB.Count_And_Get (

5854: WHEN FND_API.G_EXC_ERROR THEN
5855: ROLLBACK TO Delete_offer_line_pvt;
5856: x_return_status := FND_API.G_RET_STS_ERROR;
5857: -- Standard call to get message count and if count=1, get the message
5858: FND_MSG_PUB.Count_And_Get (
5859: p_encoded => FND_API.G_FALSE,
5860: p_count => x_msg_count,
5861: p_data => x_msg_data
5862: );

Line 5868: FND_MSG_PUB.Count_And_Get (

5864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5865: ROLLBACK TO Delete_offer_line_pvt;
5866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5867: -- Standard call to get message count and if count=1, get the message
5868: FND_MSG_PUB.Count_And_Get (
5869: p_encoded => FND_API.G_FALSE,
5870: p_count => x_msg_count,
5871: p_data => x_msg_data
5872: );

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

5873:
5874: WHEN OTHERS THEN
5875: ROLLBACK TO Delete_offer_line_pvt;
5876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5877: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5878: THEN
5879: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5880: END IF;
5881: -- Standard call to get message count and if count=1, get the message

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

5875: ROLLBACK TO Delete_offer_line_pvt;
5876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5877: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5878: THEN
5879: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5880: END IF;
5881: -- Standard call to get message count and if count=1, get the message
5882: FND_MSG_PUB.Count_And_Get (
5883: p_encoded => FND_API.G_FALSE,

Line 5882: FND_MSG_PUB.Count_And_Get (

5878: THEN
5879: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5880: END IF;
5881: -- Standard call to get message count and if count=1, get the message
5882: FND_MSG_PUB.Count_And_Get (
5883: p_encoded => FND_API.G_FALSE,
5884: p_count => x_msg_count,
5885: p_data => x_msg_data
5886: );

Line 6005: FND_MSG_PUB.initialize;

6001:
6002: -- Initialize message list if p_init_msg_list is set to TRUE.
6003: IF FND_API.to_Boolean( p_init_msg_list )
6004: THEN
6005: FND_MSG_PUB.initialize;
6006: END IF;
6007:
6008:
6009: -- Debug Message

Line 6085: FND_MSG_PUB.Count_And_Get (

6081: WHEN FND_API.G_EXC_ERROR THEN
6082: ROLLBACK TO Create_Product_Exclusion_PVT;
6083: x_return_status := FND_API.G_RET_STS_ERROR;
6084: -- Standard call to get message count and if count=1, get the message
6085: FND_MSG_PUB.Count_And_Get (
6086: p_encoded => FND_API.G_FALSE,
6087: p_count => x_msg_count,
6088: p_data => x_msg_data
6089: );

Line 6095: FND_MSG_PUB.Count_And_Get (

6091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6092: ROLLBACK TO Create_Product_Exclusion_PVT;
6093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6094: -- Standard call to get message count and if count=1, get the message
6095: FND_MSG_PUB.Count_And_Get (
6096: p_encoded => FND_API.G_FALSE,
6097: p_count => x_msg_count,
6098: p_data => x_msg_data
6099: );

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

6100:
6101: WHEN OTHERS THEN
6102: ROLLBACK TO Create_Product_Exclusion_PVT;
6103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6104: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6105: THEN
6106: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6107: END IF;
6108: -- Standard call to get message count and if count=1, get the message

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

6102: ROLLBACK TO Create_Product_Exclusion_PVT;
6103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6104: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6105: THEN
6106: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6107: END IF;
6108: -- Standard call to get message count and if count=1, get the message
6109: FND_MSG_PUB.Count_And_Get (
6110: p_encoded => FND_API.G_FALSE,

Line 6109: FND_MSG_PUB.Count_And_Get (

6105: THEN
6106: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6107: END IF;
6108: -- Standard call to get message count and if count=1, get the message
6109: FND_MSG_PUB.Count_And_Get (
6110: p_encoded => FND_API.G_FALSE,
6111: p_count => x_msg_count,
6112: p_data => x_msg_data
6113: );

Line 6162: FND_MSG_PUB.initialize;

6158:
6159: -- Initialize message list if p_init_msg_list is set to TRUE.
6160: IF FND_API.to_Boolean( p_init_msg_list )
6161: THEN
6162: FND_MSG_PUB.initialize;
6163: END IF;
6164:
6165:
6166: -- Debug Message

Line 6226: FND_MSG_PUB.Count_And_Get (

6222: WHEN FND_API.G_EXC_ERROR THEN
6223: ROLLBACK TO Update_Product_Exclusion_PVT;
6224: x_return_status := FND_API.G_RET_STS_ERROR;
6225: -- Standard call to get message count and if count=1, get the message
6226: FND_MSG_PUB.Count_And_Get (
6227: p_encoded => FND_API.G_FALSE,
6228: p_count => x_msg_count,
6229: p_data => x_msg_data
6230: );

Line 6236: FND_MSG_PUB.Count_And_Get (

6232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6233: ROLLBACK TO Update_Product_Exclusion_PVT;
6234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6235: -- Standard call to get message count and if count=1, get the message
6236: FND_MSG_PUB.Count_And_Get (
6237: p_encoded => FND_API.G_FALSE,
6238: p_count => x_msg_count,
6239: p_data => x_msg_data
6240: );

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

6241:
6242: WHEN OTHERS THEN
6243: ROLLBACK TO Update_Product_Exclusion_PVT;
6244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6245: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6246: THEN
6247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6248: END IF;
6249: -- Standard call to get message count and if count=1, get the message

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

6243: ROLLBACK TO Update_Product_Exclusion_PVT;
6244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6245: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6246: THEN
6247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6248: END IF;
6249: -- Standard call to get message count and if count=1, get the message
6250: FND_MSG_PUB.Count_And_Get (
6251: p_encoded => FND_API.G_FALSE,

Line 6250: FND_MSG_PUB.Count_And_Get (

6246: THEN
6247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6248: END IF;
6249: -- Standard call to get message count and if count=1, get the message
6250: FND_MSG_PUB.Count_And_Get (
6251: p_encoded => FND_API.G_FALSE,
6252: p_count => x_msg_count,
6253: p_data => x_msg_data
6254: );

Line 6543: FND_MSG_PUB.initialize;

6539:
6540: -- Initialize message list if p_init_msg_list is set to TRUE.
6541: IF FND_API.to_Boolean( p_init_msg_list )
6542: THEN
6543: FND_MSG_PUB.initialize;
6544: END IF;
6545:
6546:
6547: -- Debug Message

Line 6608: FND_MSG_PUB.Count_And_Get (

6604: WHEN FND_API.G_EXC_ERROR THEN
6605: ROLLBACK TO Create_Disc_tiers_PVT;
6606: x_return_status := FND_API.G_RET_STS_ERROR;
6607: -- Standard call to get message count and if count=1, get the message
6608: FND_MSG_PUB.Count_And_Get (
6609: p_encoded => FND_API.G_FALSE,
6610: p_count => x_msg_count,
6611: p_data => x_msg_data
6612: );

Line 6618: FND_MSG_PUB.Count_And_Get (

6614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6615: ROLLBACK TO Create_Disc_tiers_PVT;
6616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6617: -- Standard call to get message count and if count=1, get the message
6618: FND_MSG_PUB.Count_And_Get (
6619: p_encoded => FND_API.G_FALSE,
6620: p_count => x_msg_count,
6621: p_data => x_msg_data
6622: );

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

6623:
6624: WHEN OTHERS THEN
6625: ROLLBACK TO Create_Disc_tiers_PVT;
6626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6627: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6628: THEN
6629: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6630: END IF;
6631: -- Standard call to get message count and if count=1, get the message

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

6625: ROLLBACK TO Create_Disc_tiers_PVT;
6626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6627: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6628: THEN
6629: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6630: END IF;
6631: -- Standard call to get message count and if count=1, get the message
6632: FND_MSG_PUB.Count_And_Get (
6633: p_encoded => FND_API.G_FALSE,

Line 6632: FND_MSG_PUB.Count_And_Get (

6628: THEN
6629: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6630: END IF;
6631: -- Standard call to get message count and if count=1, get the message
6632: FND_MSG_PUB.Count_And_Get (
6633: p_encoded => FND_API.G_FALSE,
6634: p_count => x_msg_count,
6635: p_data => x_msg_data
6636: );

Line 6684: FND_MSG_PUB.initialize;

6680:
6681: -- Initialize message list if p_init_msg_list is set to TRUE.
6682: IF FND_API.to_Boolean( p_init_msg_list )
6683: THEN
6684: FND_MSG_PUB.initialize;
6685: END IF;
6686:
6687:
6688: -- Debug Message

Line 6744: FND_MSG_PUB.Count_And_Get (

6740: WHEN FND_API.G_EXC_ERROR THEN
6741: ROLLBACK TO Create_Disc_tiers_PVT;
6742: x_return_status := FND_API.G_RET_STS_ERROR;
6743: -- Standard call to get message count and if count=1, get the message
6744: FND_MSG_PUB.Count_And_Get (
6745: p_encoded => FND_API.G_FALSE,
6746: p_count => x_msg_count,
6747: p_data => x_msg_data
6748: );

Line 6754: FND_MSG_PUB.Count_And_Get (

6750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6751: ROLLBACK TO Create_Disc_tiers_PVT;
6752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6753: -- Standard call to get message count and if count=1, get the message
6754: FND_MSG_PUB.Count_And_Get (
6755: p_encoded => FND_API.G_FALSE,
6756: p_count => x_msg_count,
6757: p_data => x_msg_data
6758: );

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

6759:
6760: WHEN OTHERS THEN
6761: ROLLBACK TO Create_Disc_tiers_PVT;
6762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6763: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6764: THEN
6765: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6766: END IF;
6767: -- Standard call to get message count and if count=1, get the message

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

6761: ROLLBACK TO Create_Disc_tiers_PVT;
6762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6763: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6764: THEN
6765: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6766: END IF;
6767: -- Standard call to get message count and if count=1, get the message
6768: FND_MSG_PUB.Count_And_Get (
6769: p_encoded => FND_API.G_FALSE,

Line 6768: FND_MSG_PUB.Count_And_Get (

6764: THEN
6765: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6766: END IF;
6767: -- Standard call to get message count and if count=1, get the message
6768: FND_MSG_PUB.Count_And_Get (
6769: p_encoded => FND_API.G_FALSE,
6770: p_count => x_msg_count,
6771: p_data => x_msg_data
6772: );

Line 6816: FND_MSG_PUB.initialize;

6812:
6813: -- Initialize message list if p_init_msg_list is set to TRUE.
6814: IF FND_API.to_Boolean( p_init_msg_list )
6815: THEN
6816: FND_MSG_PUB.initialize;
6817: END IF;
6818:
6819:
6820: -- Debug Message

Line 6843: FND_MSG_PUB.Count_And_Get (

6839: WHEN FND_API.G_EXC_ERROR THEN
6840: ROLLBACK TO Delete_Disc_tiers_PVT;
6841: x_return_status := FND_API.G_RET_STS_ERROR;
6842: -- Standard call to get message count and if count=1, get the message
6843: FND_MSG_PUB.Count_And_Get (
6844: p_encoded => FND_API.G_FALSE,
6845: p_count => x_msg_count,
6846: p_data => x_msg_data
6847: );

Line 6853: FND_MSG_PUB.Count_And_Get (

6849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6850: ROLLBACK TO Delete_Disc_tiers_PVT;
6851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6852: -- Standard call to get message count and if count=1, get the message
6853: FND_MSG_PUB.Count_And_Get (
6854: p_encoded => FND_API.G_FALSE,
6855: p_count => x_msg_count,
6856: p_data => x_msg_data
6857: );

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

6858:
6859: WHEN OTHERS THEN
6860: ROLLBACK TO Delete_Disc_tiers_PVT;
6861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6862: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6863: THEN
6864: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6865: END IF;
6866: -- Standard call to get message count and if count=1, get the message

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

6860: ROLLBACK TO Delete_Disc_tiers_PVT;
6861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6862: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6863: THEN
6864: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6865: END IF;
6866: -- Standard call to get message count and if count=1, get the message
6867: FND_MSG_PUB.Count_And_Get (
6868: p_encoded => FND_API.G_FALSE,

Line 6867: FND_MSG_PUB.Count_And_Get (

6863: THEN
6864: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6865: END IF;
6866: -- Standard call to get message count and if count=1, get the message
6867: FND_MSG_PUB.Count_And_Get (
6868: p_encoded => FND_API.G_FALSE,
6869: p_count => x_msg_count,
6870: p_data => x_msg_data
6871: );

Line 6953: FND_MSG_PUB.initialize;

6949:
6950: -- Initialize message list if p_init_msg_list is set to TRUE.
6951: IF FND_API.to_Boolean( p_init_msg_list )
6952: THEN
6953: FND_MSG_PUB.initialize;
6954: END IF;
6955:
6956:
6957: -- Debug Message

Line 7006: FND_MSG_PUB.Count_And_Get

7002: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
7003:
7004:
7005: -- Standard call to get message count and if count is 1, get message info.
7006: FND_MSG_PUB.Count_And_Get
7007: (p_count => x_msg_count,
7008: p_data => x_msg_data
7009: );
7010:

Line 7016: FND_MSG_PUB.Count_And_Get (

7012: WHEN FND_API.G_EXC_ERROR THEN
7013: ROLLBACK TO Delete_tier_line_pvt;
7014: x_return_status := FND_API.G_RET_STS_ERROR;
7015: -- Standard call to get message count and if count=1, get the message
7016: FND_MSG_PUB.Count_And_Get (
7017: p_encoded => FND_API.G_FALSE,
7018: p_count => x_msg_count,
7019: p_data => x_msg_data
7020: );

Line 7026: FND_MSG_PUB.Count_And_Get (

7022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7023: ROLLBACK TO Delete_tier_line_pvt;
7024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7025: -- Standard call to get message count and if count=1, get the message
7026: FND_MSG_PUB.Count_And_Get (
7027: p_encoded => FND_API.G_FALSE,
7028: p_count => x_msg_count,
7029: p_data => x_msg_data
7030: );

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

7031:
7032: WHEN OTHERS THEN
7033: ROLLBACK TO Delete_tier_line_pvt;
7034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7035: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7036: THEN
7037: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7038: END IF;
7039: -- Standard call to get message count and if count=1, get the message

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

7033: ROLLBACK TO Delete_tier_line_pvt;
7034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7035: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7036: THEN
7037: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7038: END IF;
7039: -- Standard call to get message count and if count=1, get the message
7040: FND_MSG_PUB.Count_And_Get (
7041: p_encoded => FND_API.G_FALSE,

Line 7040: FND_MSG_PUB.Count_And_Get (

7036: THEN
7037: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7038: END IF;
7039: -- Standard call to get message count and if count=1, get the message
7040: FND_MSG_PUB.Count_And_Get (
7041: p_encoded => FND_API.G_FALSE,
7042: p_count => x_msg_count,
7043: p_data => x_msg_data
7044: );