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 117: FND_MSG_PUB.initialize;

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

Line 142: FND_MSG_PUB.count_and_get(

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

Line 157: FND_MSG_PUB.Count_And_Get (

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

Line 167: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 181: FND_MSG_PUB.Count_And_Get (

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

Line 738: FND_MSG_PUB.initialize;

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

Line 754: FND_MSG_PUB.Count_And_Get

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

Line 794: FND_MSG_PUB.initialize;

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

Line 851: FND_MSG_PUB.Count_And_Get

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

Line 865: FND_MSG_PUB.Count_And_Get (

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

Line 875: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 889: FND_MSG_PUB.Count_And_Get (

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

Line 986: FND_MSG_PUB.initialize;

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

Line 1122: FND_MSG_PUB.Count_And_Get

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

Line 1136: FND_MSG_PUB.Count_And_Get (

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

Line 1146: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1160: FND_MSG_PUB.Count_And_Get (

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

Line 1250: FND_MSG_PUB.initialize;

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

Line 1380: FND_MSG_PUB.Count_And_Get

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

Line 1394: FND_MSG_PUB.Count_And_Get (

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

Line 1404: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1418: FND_MSG_PUB.Count_And_Get (

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

Line 1494: FND_MSG_PUB.initialize;

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

Line 1533: FND_MSG_PUB.Count_And_Get

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

Line 1547: FND_MSG_PUB.Count_And_Get (

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

Line 1557: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1571: FND_MSG_PUB.Count_And_Get (

1567: THEN
1568: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1569: END IF;
1570: -- Standard call to get message count and if count=1, get the message
1571: FND_MSG_PUB.Count_And_Get (
1572: p_encoded => FND_API.G_FALSE,
1573: p_count => x_msg_count,
1574: p_data => x_msg_data
1575: );

Line 1642: FND_MSG_PUB.initialize;

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

Line 1667: FND_MSG_PUB.count_and_get(

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

Line 1682: FND_MSG_PUB.Count_And_Get (

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

Line 1692: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1706: FND_MSG_PUB.Count_And_Get (

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

Line 2112: FND_MSG_PUB.initialize;

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

Line 2128: FND_MSG_PUB.Count_And_Get

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

Line 2166: FND_MSG_PUB.initialize;

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

Line 2219: FND_MSG_PUB.Count_And_Get

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

Line 2233: FND_MSG_PUB.Count_And_Get (

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

Line 2243: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 2257: FND_MSG_PUB.Count_And_Get (

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

Line 2348: FND_MSG_PUB.initialize;

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

Line 2462: FND_MSG_PUB.Count_And_Get

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

Line 2476: FND_MSG_PUB.Count_And_Get (

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

Line 2486: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 2500: FND_MSG_PUB.Count_And_Get (

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

Line 2590: FND_MSG_PUB.initialize;

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

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

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

Line 2695: FND_MSG_PUB.Count_And_Get

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

Line 2709: FND_MSG_PUB.Count_And_Get (

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

Line 2719: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 2733: FND_MSG_PUB.Count_And_Get (

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

Line 2778: FND_MSG_PUB.Count_And_Get (

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

Line 2788: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 2802: FND_MSG_PUB.Count_And_Get (

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

Line 2883: FND_MSG_PUB.initialize;

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

Line 2942: FND_MSG_PUB.Count_And_Get

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

Line 2956: FND_MSG_PUB.Count_And_Get (

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

Line 2966: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 2980: FND_MSG_PUB.Count_And_Get (

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

Line 3052: FND_MSG_PUB.initialize;

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

Line 3077: FND_MSG_PUB.count_and_get(

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

Line 3092: FND_MSG_PUB.Count_And_Get (

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

Line 3102: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 3116: FND_MSG_PUB.Count_And_Get (

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

Line 3403: FND_MSG_PUB.initialize;

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

Line 3419: FND_MSG_PUB.Count_And_Get

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

Line 3460: FND_MSG_PUB.initialize;

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

Line 3519: FND_MSG_PUB.Count_And_Get

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

Line 3533: FND_MSG_PUB.Count_And_Get (

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

Line 3543: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 3557: FND_MSG_PUB.Count_And_Get (

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

Line 3651: FND_MSG_PUB.initialize;

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

Line 3754: FND_MSG_PUB.Count_And_Get

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

Line 3768: FND_MSG_PUB.Count_And_Get (

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

Line 3778: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 3792: FND_MSG_PUB.Count_And_Get (

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

Line 3882: FND_MSG_PUB.initialize;

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

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

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

Line 3980: FND_MSG_PUB.Count_And_Get

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

Line 3994: FND_MSG_PUB.Count_And_Get (

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

Line 4004: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 4018: FND_MSG_PUB.Count_And_Get (

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

Line 4094: FND_MSG_PUB.initialize;

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

Line 4133: FND_MSG_PUB.Count_And_Get

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

Line 4147: FND_MSG_PUB.Count_And_Get (

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

Line 4157: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 4171: FND_MSG_PUB.Count_And_Get (

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

Line 4290: FND_MSG_PUB.initialize;

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

Line 4355: FND_MSG_PUB.Count_And_Get (

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

Line 4365: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 4379: FND_MSG_PUB.Count_And_Get (

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

Line 4467: FND_MSG_PUB.initialize;

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

Line 4527: FND_MSG_PUB.Count_And_Get

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

Line 4539: FND_MSG_PUB.Count_And_Get (

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

Line 4549: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 4563: FND_MSG_PUB.Count_And_Get (

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

Line 4715: FND_MSG_PUB.initialize;

4711:
4712: -- Initialize message list if p_init_msg_list is set to TRUE.
4713: IF FND_API.to_Boolean( p_init_msg_list )
4714: THEN
4715: FND_MSG_PUB.initialize;
4716: END IF;
4717:
4718:
4719:

Line 4768: FND_MSG_PUB.Count_And_Get

4764: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
4765:
4766:
4767: -- Standard call to get message count and if count is 1, get message info.
4768: FND_MSG_PUB.Count_And_Get
4769: (p_count => x_msg_count,
4770: p_data => x_msg_data
4771: );
4772:

Line 4779: FND_MSG_PUB.Count_And_Get (

4775: WHEN FND_API.G_EXC_ERROR THEN
4776: ROLLBACK TO Create_discount_line_pvt;
4777: x_return_status := FND_API.G_RET_STS_ERROR;
4778: -- Standard call to get message count and if count=1, get the message
4779: FND_MSG_PUB.Count_And_Get (
4780: p_encoded => FND_API.G_FALSE,
4781: p_count => x_msg_count,
4782: p_data => x_msg_data
4783: );

Line 4789: FND_MSG_PUB.Count_And_Get (

4785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4786: ROLLBACK TO Create_discount_line_pvt;
4787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4788: -- Standard call to get message count and if count=1, get the message
4789: FND_MSG_PUB.Count_And_Get (
4790: p_encoded => FND_API.G_FALSE,
4791: p_count => x_msg_count,
4792: p_data => x_msg_data
4793: );

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

4794:
4795: WHEN OTHERS THEN
4796: ROLLBACK TO Create_discount_line_pvt;
4797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4798: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4799: THEN
4800: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4801: END IF;
4802: -- Standard call to get message count and if count=1, get the message

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

4796: ROLLBACK TO Create_discount_line_pvt;
4797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4798: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4799: THEN
4800: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4801: END IF;
4802: -- Standard call to get message count and if count=1, get the message
4803: FND_MSG_PUB.Count_And_Get (
4804: p_encoded => FND_API.G_FALSE,

Line 4803: FND_MSG_PUB.Count_And_Get (

4799: THEN
4800: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4801: END IF;
4802: -- Standard call to get message count and if count=1, get the message
4803: FND_MSG_PUB.Count_And_Get (
4804: p_encoded => FND_API.G_FALSE,
4805: p_count => x_msg_count,
4806: p_data => x_msg_data
4807: );

Line 4889: FND_MSG_PUB.initialize;

4885:
4886: -- Initialize message list if p_init_msg_list is set to TRUE.
4887: IF FND_API.to_Boolean( p_init_msg_list )
4888: THEN
4889: FND_MSG_PUB.initialize;
4890: END IF;
4891:
4892:
4893: -- Debug Message

Line 4945: FND_MSG_PUB.Count_And_Get

4941: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
4942:
4943:
4944: -- Standard call to get message count and if count is 1, get message info.
4945: FND_MSG_PUB.Count_And_Get
4946: (p_count => x_msg_count,
4947: p_data => x_msg_data
4948: );
4949:

Line 4955: FND_MSG_PUB.Count_And_Get (

4951: WHEN FND_API.G_EXC_ERROR THEN
4952: ROLLBACK TO Update_offer_line_pvt;
4953: x_return_status := FND_API.G_RET_STS_ERROR;
4954: -- Standard call to get message count and if count=1, get the message
4955: FND_MSG_PUB.Count_And_Get (
4956: p_encoded => FND_API.G_FALSE,
4957: p_count => x_msg_count,
4958: p_data => x_msg_data
4959: );

Line 4965: FND_MSG_PUB.Count_And_Get (

4961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4962: ROLLBACK TO Update_offer_line_pvt;
4963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4964: -- Standard call to get message count and if count=1, get the message
4965: FND_MSG_PUB.Count_And_Get (
4966: p_encoded => FND_API.G_FALSE,
4967: p_count => x_msg_count,
4968: p_data => x_msg_data
4969: );

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

4970:
4971: WHEN OTHERS THEN
4972: ROLLBACK TO Update_offer_line_pvt;
4973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4974: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4975: THEN
4976: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4977: END IF;
4978: -- Standard call to get message count and if count=1, get the message

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

4972: ROLLBACK TO Update_offer_line_pvt;
4973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4974: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4975: THEN
4976: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4977: END IF;
4978: -- Standard call to get message count and if count=1, get the message
4979: FND_MSG_PUB.Count_And_Get (
4980: p_encoded => FND_API.G_FALSE,

Line 4979: FND_MSG_PUB.Count_And_Get (

4975: THEN
4976: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4977: END IF;
4978: -- Standard call to get message count and if count=1, get the message
4979: FND_MSG_PUB.Count_And_Get (
4980: p_encoded => FND_API.G_FALSE,
4981: p_count => x_msg_count,
4982: p_data => x_msg_data
4983: );

Line 5035: FND_MSG_PUB.initialize;

5031:
5032: -- Initialize message list if p_init_msg_list is set to TRUE.
5033: IF FND_API.to_Boolean( p_init_msg_list )
5034: THEN
5035: FND_MSG_PUB.initialize;
5036: END IF;
5037:
5038:
5039:

Line 5104: FND_MSG_PUB.Count_And_Get

5100: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
5101:
5102:
5103: -- Standard call to get message count and if count is 1, get message info.
5104: FND_MSG_PUB.Count_And_Get
5105: (p_count => x_msg_count,
5106: p_data => x_msg_data
5107: );
5108:

Line 5116: FND_MSG_PUB.Count_And_Get (

5112: WHEN FND_API.G_EXC_ERROR THEN
5113: ROLLBACK TO Update_discount_line_pvt;
5114: x_return_status := FND_API.G_RET_STS_ERROR;
5115: -- Standard call to get message count and if count=1, get the message
5116: FND_MSG_PUB.Count_And_Get (
5117: p_encoded => FND_API.G_FALSE,
5118: p_count => x_msg_count,
5119: p_data => x_msg_data
5120: );

Line 5126: FND_MSG_PUB.Count_And_Get (

5122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5123: ROLLBACK TO Update_discount_line_pvt;
5124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5125: -- Standard call to get message count and if count=1, get the message
5126: FND_MSG_PUB.Count_And_Get (
5127: p_encoded => FND_API.G_FALSE,
5128: p_count => x_msg_count,
5129: p_data => x_msg_data
5130: );

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

5131:
5132: WHEN OTHERS THEN
5133: ROLLBACK TO Update_discount_line_pvt;
5134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5135: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5136: THEN
5137: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5138: END IF;
5139: -- Standard call to get message count and if count=1, get the message

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

5133: ROLLBACK TO Update_discount_line_pvt;
5134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5135: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5136: THEN
5137: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5138: END IF;
5139: -- Standard call to get message count and if count=1, get the message
5140: FND_MSG_PUB.Count_And_Get (
5141: p_encoded => FND_API.G_FALSE,

Line 5140: FND_MSG_PUB.Count_And_Get (

5136: THEN
5137: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5138: END IF;
5139: -- Standard call to get message count and if count=1, get the message
5140: FND_MSG_PUB.Count_And_Get (
5141: p_encoded => FND_API.G_FALSE,
5142: p_count => x_msg_count,
5143: p_data => x_msg_data
5144: );

Line 5263: FND_MSG_PUB.initialize;

5259:
5260: -- Initialize message list if p_init_msg_list is set to TRUE.
5261: IF FND_API.to_Boolean( p_init_msg_list )
5262: THEN
5263: FND_MSG_PUB.initialize;
5264: END IF;
5265:
5266:
5267: -- Debug Message

Line 5330: FND_MSG_PUB.Count_And_Get

5326: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
5327:
5328:
5329: -- Standard call to get message count and if count is 1, get message info.
5330: FND_MSG_PUB.Count_And_Get
5331: (p_count => l_msg_count,
5332: p_data => l_msg_data
5333: );
5334:

Line 5340: FND_MSG_PUB.Count_And_Get (

5336: WHEN FND_API.G_EXC_ERROR THEN
5337: ROLLBACK TO Update_product_Pvt;
5338: x_return_status := FND_API.G_RET_STS_ERROR;
5339: -- Standard call to get message count and if count=1, get the message
5340: FND_MSG_PUB.Count_And_Get (
5341: p_encoded => FND_API.G_FALSE,
5342: p_count => l_msg_count,
5343: p_data => l_msg_data
5344: );

Line 5350: FND_MSG_PUB.Count_And_Get (

5346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5347: ROLLBACK TO Update_product_Pvt;
5348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5349: -- Standard call to get message count and if count=1, get the message
5350: FND_MSG_PUB.Count_And_Get (
5351: p_encoded => FND_API.G_FALSE,
5352: p_count => l_msg_count,
5353: p_data => l_msg_data
5354: );

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

5355:
5356: WHEN OTHERS THEN
5357: ROLLBACK TO Update_product_Pvt;
5358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5359: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5360: THEN
5361: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5362: END IF;
5363: -- Standard call to get message count and if count=1, get the message

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

5357: ROLLBACK TO Update_product_Pvt;
5358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5359: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5360: THEN
5361: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5362: END IF;
5363: -- Standard call to get message count and if count=1, get the message
5364: FND_MSG_PUB.Count_And_Get (
5365: p_encoded => FND_API.G_FALSE,

Line 5364: FND_MSG_PUB.Count_And_Get (

5360: THEN
5361: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5362: END IF;
5363: -- Standard call to get message count and if count=1, get the message
5364: FND_MSG_PUB.Count_And_Get (
5365: p_encoded => FND_API.G_FALSE,
5366: p_count => l_msg_count,
5367: p_data => l_msg_data
5368: );

Line 5439: FND_MSG_PUB.initialize;

5435:
5436: -- Initialize message list if p_init_msg_list is set to TRUE.
5437: IF FND_API.to_Boolean( p_init_msg_list )
5438: THEN
5439: FND_MSG_PUB.initialize;
5440: END IF;
5441:
5442:
5443: -- Debug Message

Line 5466: FND_MSG_PUB.Count_And_Get

5462: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
5463:
5464:
5465: -- Standard call to get message count and if count is 1, get message info.
5466: FND_MSG_PUB.Count_And_Get
5467: (p_count => l_msg_count,
5468: p_data => l_msg_data
5469: );
5470:

Line 5476: FND_MSG_PUB.Count_And_Get (

5472: WHEN FND_API.G_EXC_ERROR THEN
5473: ROLLBACK TO Delete_Relation_Pvt;
5474: x_return_status := FND_API.G_RET_STS_ERROR;
5475: -- Standard call to get message count and if count=1, get the message
5476: FND_MSG_PUB.Count_And_Get (
5477: p_encoded => FND_API.G_FALSE,
5478: p_count => l_msg_count,
5479: p_data => l_msg_data
5480: );

Line 5486: FND_MSG_PUB.Count_And_Get (

5482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5483: ROLLBACK TO Delete_Relation_Pvt;
5484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5485: -- Standard call to get message count and if count=1, get the message
5486: FND_MSG_PUB.Count_And_Get (
5487: p_encoded => FND_API.G_FALSE,
5488: p_count => l_msg_count,
5489: p_data => l_msg_data
5490: );

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

5491:
5492: WHEN OTHERS THEN
5493: ROLLBACK TO Delete_Relation_Pvt;
5494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5496: THEN
5497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5498: END IF;
5499: -- Standard call to get message count and if count=1, get the message

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

5493: ROLLBACK TO Delete_Relation_Pvt;
5494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5496: THEN
5497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5498: END IF;
5499: -- Standard call to get message count and if count=1, get the message
5500: FND_MSG_PUB.Count_And_Get (
5501: p_encoded => FND_API.G_FALSE,

Line 5500: FND_MSG_PUB.Count_And_Get (

5496: THEN
5497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5498: END IF;
5499: -- Standard call to get message count and if count=1, get the message
5500: FND_MSG_PUB.Count_And_Get (
5501: p_encoded => FND_API.G_FALSE,
5502: p_count => l_msg_count,
5503: p_data => l_msg_data
5504: );

Line 5578: FND_MSG_PUB.initialize;

5574:
5575: -- Initialize message list if p_init_msg_list is set to TRUE.
5576: IF FND_API.to_Boolean( p_init_msg_list )
5577: THEN
5578: FND_MSG_PUB.initialize;
5579: END IF;
5580:
5581:
5582: -- Debug Message

Line 5619: FND_MSG_PUB.Count_And_Get

5615: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
5616:
5617:
5618: -- Standard call to get message count and if count is 1, get message info.
5619: FND_MSG_PUB.Count_And_Get
5620: (p_count => l_msg_count,
5621: p_data => l_msg_data
5622: );
5623:

Line 5629: FND_MSG_PUB.Count_And_Get (

5625: WHEN FND_API.G_EXC_ERROR THEN
5626: ROLLBACK TO Delete_Product_Pvt;
5627: x_return_status := FND_API.G_RET_STS_ERROR;
5628: -- Standard call to get message count and if count=1, get the message
5629: FND_MSG_PUB.Count_And_Get (
5630: p_encoded => FND_API.G_FALSE,
5631: p_count => l_msg_count,
5632: p_data => l_msg_data
5633: );

Line 5639: FND_MSG_PUB.Count_And_Get (

5635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5636: ROLLBACK TO Delete_Product_Pvt;
5637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5638: -- Standard call to get message count and if count=1, get the message
5639: FND_MSG_PUB.Count_And_Get (
5640: p_encoded => FND_API.G_FALSE,
5641: p_count => l_msg_count,
5642: p_data => l_msg_data
5643: );

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

5644:
5645: WHEN OTHERS THEN
5646: ROLLBACK TO Delete_Product_Pvt;
5647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5648: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5649: THEN
5650: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5651: END IF;
5652: -- Standard call to get message count and if count=1, get the message

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

5646: ROLLBACK TO Delete_Product_Pvt;
5647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5648: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5649: THEN
5650: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5651: END IF;
5652: -- Standard call to get message count and if count=1, get the message
5653: FND_MSG_PUB.Count_And_Get (
5654: p_encoded => FND_API.G_FALSE,

Line 5653: FND_MSG_PUB.Count_And_Get (

5649: THEN
5650: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5651: END IF;
5652: -- Standard call to get message count and if count=1, get the message
5653: FND_MSG_PUB.Count_And_Get (
5654: p_encoded => FND_API.G_FALSE,
5655: p_count => l_msg_count,
5656: p_data => l_msg_data
5657: );

Line 5747: FND_MSG_PUB.initialize;

5743:
5744: -- Initialize message list if p_init_msg_list is set to TRUE.
5745: IF FND_API.to_Boolean( p_init_msg_list )
5746: THEN
5747: FND_MSG_PUB.initialize;
5748: END IF;
5749:
5750:
5751: -- Debug Message

Line 5829: FND_MSG_PUB.Count_And_Get

5825: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
5826:
5827:
5828: -- Standard call to get message count and if count is 1, get message info.
5829: FND_MSG_PUB.Count_And_Get
5830: (p_count => x_msg_count,
5831: p_data => x_msg_data
5832: );
5833:

Line 5839: FND_MSG_PUB.Count_And_Get (

5835: WHEN FND_API.G_EXC_ERROR THEN
5836: ROLLBACK TO Delete_offer_line_pvt;
5837: x_return_status := FND_API.G_RET_STS_ERROR;
5838: -- Standard call to get message count and if count=1, get the message
5839: FND_MSG_PUB.Count_And_Get (
5840: p_encoded => FND_API.G_FALSE,
5841: p_count => x_msg_count,
5842: p_data => x_msg_data
5843: );

Line 5849: FND_MSG_PUB.Count_And_Get (

5845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5846: ROLLBACK TO Delete_offer_line_pvt;
5847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5848: -- Standard call to get message count and if count=1, get the message
5849: FND_MSG_PUB.Count_And_Get (
5850: p_encoded => FND_API.G_FALSE,
5851: p_count => x_msg_count,
5852: p_data => x_msg_data
5853: );

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

5854:
5855: WHEN OTHERS THEN
5856: ROLLBACK TO Delete_offer_line_pvt;
5857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5858: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5859: THEN
5860: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5861: END IF;
5862: -- Standard call to get message count and if count=1, get the message

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

5856: ROLLBACK TO Delete_offer_line_pvt;
5857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5858: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5859: THEN
5860: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5861: END IF;
5862: -- Standard call to get message count and if count=1, get the message
5863: FND_MSG_PUB.Count_And_Get (
5864: p_encoded => FND_API.G_FALSE,

Line 5863: FND_MSG_PUB.Count_And_Get (

5859: THEN
5860: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5861: END IF;
5862: -- Standard call to get message count and if count=1, get the message
5863: FND_MSG_PUB.Count_And_Get (
5864: p_encoded => FND_API.G_FALSE,
5865: p_count => x_msg_count,
5866: p_data => x_msg_data
5867: );

Line 5986: FND_MSG_PUB.initialize;

5982:
5983: -- Initialize message list if p_init_msg_list is set to TRUE.
5984: IF FND_API.to_Boolean( p_init_msg_list )
5985: THEN
5986: FND_MSG_PUB.initialize;
5987: END IF;
5988:
5989:
5990: -- Debug Message

Line 6066: FND_MSG_PUB.Count_And_Get (

6062: WHEN FND_API.G_EXC_ERROR THEN
6063: ROLLBACK TO Create_Product_Exclusion_PVT;
6064: x_return_status := FND_API.G_RET_STS_ERROR;
6065: -- Standard call to get message count and if count=1, get the message
6066: FND_MSG_PUB.Count_And_Get (
6067: p_encoded => FND_API.G_FALSE,
6068: p_count => x_msg_count,
6069: p_data => x_msg_data
6070: );

Line 6076: FND_MSG_PUB.Count_And_Get (

6072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6073: ROLLBACK TO Create_Product_Exclusion_PVT;
6074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6075: -- Standard call to get message count and if count=1, get the message
6076: FND_MSG_PUB.Count_And_Get (
6077: p_encoded => FND_API.G_FALSE,
6078: p_count => x_msg_count,
6079: p_data => x_msg_data
6080: );

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

6081:
6082: WHEN OTHERS THEN
6083: ROLLBACK TO Create_Product_Exclusion_PVT;
6084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6085: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6086: THEN
6087: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6088: END IF;
6089: -- Standard call to get message count and if count=1, get the message

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

6083: ROLLBACK TO Create_Product_Exclusion_PVT;
6084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6085: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6086: THEN
6087: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6088: END IF;
6089: -- Standard call to get message count and if count=1, get the message
6090: FND_MSG_PUB.Count_And_Get (
6091: p_encoded => FND_API.G_FALSE,

Line 6090: FND_MSG_PUB.Count_And_Get (

6086: THEN
6087: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6088: END IF;
6089: -- Standard call to get message count and if count=1, get the message
6090: FND_MSG_PUB.Count_And_Get (
6091: p_encoded => FND_API.G_FALSE,
6092: p_count => x_msg_count,
6093: p_data => x_msg_data
6094: );

Line 6143: FND_MSG_PUB.initialize;

6139:
6140: -- Initialize message list if p_init_msg_list is set to TRUE.
6141: IF FND_API.to_Boolean( p_init_msg_list )
6142: THEN
6143: FND_MSG_PUB.initialize;
6144: END IF;
6145:
6146:
6147: -- Debug Message

Line 6207: FND_MSG_PUB.Count_And_Get (

6203: WHEN FND_API.G_EXC_ERROR THEN
6204: ROLLBACK TO Update_Product_Exclusion_PVT;
6205: x_return_status := FND_API.G_RET_STS_ERROR;
6206: -- Standard call to get message count and if count=1, get the message
6207: FND_MSG_PUB.Count_And_Get (
6208: p_encoded => FND_API.G_FALSE,
6209: p_count => x_msg_count,
6210: p_data => x_msg_data
6211: );

Line 6217: FND_MSG_PUB.Count_And_Get (

6213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6214: ROLLBACK TO Update_Product_Exclusion_PVT;
6215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6216: -- Standard call to get message count and if count=1, get the message
6217: FND_MSG_PUB.Count_And_Get (
6218: p_encoded => FND_API.G_FALSE,
6219: p_count => x_msg_count,
6220: p_data => x_msg_data
6221: );

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

6222:
6223: WHEN OTHERS THEN
6224: ROLLBACK TO Update_Product_Exclusion_PVT;
6225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6226: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6227: THEN
6228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6229: END IF;
6230: -- Standard call to get message count and if count=1, get the message

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

6224: ROLLBACK TO Update_Product_Exclusion_PVT;
6225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6226: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6227: THEN
6228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6229: END IF;
6230: -- Standard call to get message count and if count=1, get the message
6231: FND_MSG_PUB.Count_And_Get (
6232: p_encoded => FND_API.G_FALSE,

Line 6231: FND_MSG_PUB.Count_And_Get (

6227: THEN
6228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6229: END IF;
6230: -- Standard call to get message count and if count=1, get the message
6231: FND_MSG_PUB.Count_And_Get (
6232: p_encoded => FND_API.G_FALSE,
6233: p_count => x_msg_count,
6234: p_data => x_msg_data
6235: );

Line 6506: FND_MSG_PUB.initialize;

6502:
6503: -- Initialize message list if p_init_msg_list is set to TRUE.
6504: IF FND_API.to_Boolean( p_init_msg_list )
6505: THEN
6506: FND_MSG_PUB.initialize;
6507: END IF;
6508:
6509:
6510: -- Debug Message

Line 6571: FND_MSG_PUB.Count_And_Get (

6567: WHEN FND_API.G_EXC_ERROR THEN
6568: ROLLBACK TO Create_Disc_tiers_PVT;
6569: x_return_status := FND_API.G_RET_STS_ERROR;
6570: -- Standard call to get message count and if count=1, get the message
6571: FND_MSG_PUB.Count_And_Get (
6572: p_encoded => FND_API.G_FALSE,
6573: p_count => x_msg_count,
6574: p_data => x_msg_data
6575: );

Line 6581: FND_MSG_PUB.Count_And_Get (

6577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6578: ROLLBACK TO Create_Disc_tiers_PVT;
6579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6580: -- Standard call to get message count and if count=1, get the message
6581: FND_MSG_PUB.Count_And_Get (
6582: p_encoded => FND_API.G_FALSE,
6583: p_count => x_msg_count,
6584: p_data => x_msg_data
6585: );

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

6586:
6587: WHEN OTHERS THEN
6588: ROLLBACK TO Create_Disc_tiers_PVT;
6589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6590: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6591: THEN
6592: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6593: END IF;
6594: -- Standard call to get message count and if count=1, get the message

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

6588: ROLLBACK TO Create_Disc_tiers_PVT;
6589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6590: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6591: THEN
6592: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6593: END IF;
6594: -- Standard call to get message count and if count=1, get the message
6595: FND_MSG_PUB.Count_And_Get (
6596: p_encoded => FND_API.G_FALSE,

Line 6595: FND_MSG_PUB.Count_And_Get (

6591: THEN
6592: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6593: END IF;
6594: -- Standard call to get message count and if count=1, get the message
6595: FND_MSG_PUB.Count_And_Get (
6596: p_encoded => FND_API.G_FALSE,
6597: p_count => x_msg_count,
6598: p_data => x_msg_data
6599: );

Line 6647: FND_MSG_PUB.initialize;

6643:
6644: -- Initialize message list if p_init_msg_list is set to TRUE.
6645: IF FND_API.to_Boolean( p_init_msg_list )
6646: THEN
6647: FND_MSG_PUB.initialize;
6648: END IF;
6649:
6650:
6651: -- Debug Message

Line 6707: FND_MSG_PUB.Count_And_Get (

6703: WHEN FND_API.G_EXC_ERROR THEN
6704: ROLLBACK TO Create_Disc_tiers_PVT;
6705: x_return_status := FND_API.G_RET_STS_ERROR;
6706: -- Standard call to get message count and if count=1, get the message
6707: FND_MSG_PUB.Count_And_Get (
6708: p_encoded => FND_API.G_FALSE,
6709: p_count => x_msg_count,
6710: p_data => x_msg_data
6711: );

Line 6717: FND_MSG_PUB.Count_And_Get (

6713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6714: ROLLBACK TO Create_Disc_tiers_PVT;
6715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6716: -- Standard call to get message count and if count=1, get the message
6717: FND_MSG_PUB.Count_And_Get (
6718: p_encoded => FND_API.G_FALSE,
6719: p_count => x_msg_count,
6720: p_data => x_msg_data
6721: );

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

6722:
6723: WHEN OTHERS THEN
6724: ROLLBACK TO Create_Disc_tiers_PVT;
6725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6726: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6727: THEN
6728: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6729: END IF;
6730: -- Standard call to get message count and if count=1, get the message

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

6724: ROLLBACK TO Create_Disc_tiers_PVT;
6725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6726: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6727: THEN
6728: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6729: END IF;
6730: -- Standard call to get message count and if count=1, get the message
6731: FND_MSG_PUB.Count_And_Get (
6732: p_encoded => FND_API.G_FALSE,

Line 6731: FND_MSG_PUB.Count_And_Get (

6727: THEN
6728: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6729: END IF;
6730: -- Standard call to get message count and if count=1, get the message
6731: FND_MSG_PUB.Count_And_Get (
6732: p_encoded => FND_API.G_FALSE,
6733: p_count => x_msg_count,
6734: p_data => x_msg_data
6735: );

Line 6779: FND_MSG_PUB.initialize;

6775:
6776: -- Initialize message list if p_init_msg_list is set to TRUE.
6777: IF FND_API.to_Boolean( p_init_msg_list )
6778: THEN
6779: FND_MSG_PUB.initialize;
6780: END IF;
6781:
6782:
6783: -- Debug Message

Line 6806: FND_MSG_PUB.Count_And_Get (

6802: WHEN FND_API.G_EXC_ERROR THEN
6803: ROLLBACK TO Delete_Disc_tiers_PVT;
6804: x_return_status := FND_API.G_RET_STS_ERROR;
6805: -- Standard call to get message count and if count=1, get the message
6806: FND_MSG_PUB.Count_And_Get (
6807: p_encoded => FND_API.G_FALSE,
6808: p_count => x_msg_count,
6809: p_data => x_msg_data
6810: );

Line 6816: FND_MSG_PUB.Count_And_Get (

6812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6813: ROLLBACK TO Delete_Disc_tiers_PVT;
6814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6815: -- Standard call to get message count and if count=1, get the message
6816: FND_MSG_PUB.Count_And_Get (
6817: p_encoded => FND_API.G_FALSE,
6818: p_count => x_msg_count,
6819: p_data => x_msg_data
6820: );

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

6821:
6822: WHEN OTHERS THEN
6823: ROLLBACK TO Delete_Disc_tiers_PVT;
6824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6825: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6826: THEN
6827: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6828: END IF;
6829: -- Standard call to get message count and if count=1, get the message

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

6823: ROLLBACK TO Delete_Disc_tiers_PVT;
6824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6825: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6826: THEN
6827: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6828: END IF;
6829: -- Standard call to get message count and if count=1, get the message
6830: FND_MSG_PUB.Count_And_Get (
6831: p_encoded => FND_API.G_FALSE,

Line 6830: FND_MSG_PUB.Count_And_Get (

6826: THEN
6827: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6828: END IF;
6829: -- Standard call to get message count and if count=1, get the message
6830: FND_MSG_PUB.Count_And_Get (
6831: p_encoded => FND_API.G_FALSE,
6832: p_count => x_msg_count,
6833: p_data => x_msg_data
6834: );

Line 6916: FND_MSG_PUB.initialize;

6912:
6913: -- Initialize message list if p_init_msg_list is set to TRUE.
6914: IF FND_API.to_Boolean( p_init_msg_list )
6915: THEN
6916: FND_MSG_PUB.initialize;
6917: END IF;
6918:
6919:
6920: -- Debug Message

Line 6969: FND_MSG_PUB.Count_And_Get

6965: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
6966:
6967:
6968: -- Standard call to get message count and if count is 1, get message info.
6969: FND_MSG_PUB.Count_And_Get
6970: (p_count => x_msg_count,
6971: p_data => x_msg_data
6972: );
6973:

Line 6979: FND_MSG_PUB.Count_And_Get (

6975: WHEN FND_API.G_EXC_ERROR THEN
6976: ROLLBACK TO Delete_tier_line_pvt;
6977: x_return_status := FND_API.G_RET_STS_ERROR;
6978: -- Standard call to get message count and if count=1, get the message
6979: FND_MSG_PUB.Count_And_Get (
6980: p_encoded => FND_API.G_FALSE,
6981: p_count => x_msg_count,
6982: p_data => x_msg_data
6983: );

Line 6989: FND_MSG_PUB.Count_And_Get (

6985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6986: ROLLBACK TO Delete_tier_line_pvt;
6987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6988: -- Standard call to get message count and if count=1, get the message
6989: FND_MSG_PUB.Count_And_Get (
6990: p_encoded => FND_API.G_FALSE,
6991: p_count => x_msg_count,
6992: p_data => x_msg_data
6993: );

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

6994:
6995: WHEN OTHERS THEN
6996: ROLLBACK TO Delete_tier_line_pvt;
6997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6998: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6999: THEN
7000: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7001: END IF;
7002: -- Standard call to get message count and if count=1, get the message

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

6996: ROLLBACK TO Delete_tier_line_pvt;
6997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6998: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6999: THEN
7000: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7001: END IF;
7002: -- Standard call to get message count and if count=1, get the message
7003: FND_MSG_PUB.Count_And_Get (
7004: p_encoded => FND_API.G_FALSE,

Line 7003: FND_MSG_PUB.Count_And_Get (

6999: THEN
7000: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7001: END IF;
7002: -- Standard call to get message count and if count=1, get the message
7003: FND_MSG_PUB.Count_And_Get (
7004: p_encoded => FND_API.G_FALSE,
7005: p_count => x_msg_count,
7006: p_data => x_msg_data
7007: );