DBA Data[Home] [Help]

APPS.OZF_CLAIM_PUB dependencies on FND_MSG_PUB

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

20: -- ===============================================================
21: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Claim_PUB';
22: G_FILE_NAME CONSTANT VARCHAR2(14) := 'ozfpclab.pls';
23:
24: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
25:
26: ---------------------------------------------------------------------
27: -- PROCEDURE
28: -- create_claim

Line 78: FND_MSG_PUB.initialize;

74: END IF;
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76: IF FND_API.to_Boolean( p_init_msg_list )
77: THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80: -- Debug Message
81: IF g_debug THEN
82: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' pub start');

Line 307: FND_MSG_PUB.Count_And_Get (

303: COMMIT WORK;
304: END IF;
305: --OZF_UTILITY_PVT.DEBUG_MESSAGE('CLAIM_ID=>'||l_claim_line_rec.claim_id);
306: -- Standard call to get message count and if count is 1, get message info.
307: FND_MSG_PUB.Count_And_Get (
308: p_encoded => FND_API.G_FALSE,
309: p_count => x_msg_count,
310: p_data => x_msg_data
311: );

Line 317: FND_MSG_PUB.Count_And_Get (

313: WHEN OZF_Utility_PVT.resource_locked THEN
314: ROLLBACK TO CREATE_Claim_PUB;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
317: FND_MSG_PUB.Count_And_Get (
318: p_encoded => FND_API.G_FALSE,
319: p_count => x_msg_count,
320: p_data => x_msg_data
321: );

Line 326: FND_MSG_PUB.Count_And_Get (

322: WHEN FND_API.G_EXC_ERROR THEN
323: ROLLBACK TO CREATE_Claim_PUB;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: -- Standard call to get message count and if count=1, get the message
326: FND_MSG_PUB.Count_And_Get (
327: p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data
330: );

Line 335: FND_MSG_PUB.Count_And_Get (

331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: ROLLBACK TO CREATE_Claim_PUB;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: -- Standard call to get message count and if count=1, get the message
335: FND_MSG_PUB.Count_And_Get (
336: p_encoded => FND_API.G_FALSE,
337: p_count => x_msg_count,
338: p_data => x_msg_data
339: );

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

339: );
340: WHEN OTHERS THEN
341: ROLLBACK TO CREATE_Claim_PUB;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
344: THEN
345: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
346: END IF;
347: -- Standard call to get message count and if count=1, get the message

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

341: ROLLBACK TO CREATE_Claim_PUB;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
344: THEN
345: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
346: END IF;
347: -- Standard call to get message count and if count=1, get the message
348: FND_MSG_PUB.Count_And_Get (
349: p_encoded => FND_API.G_FALSE,

Line 348: FND_MSG_PUB.Count_And_Get (

344: THEN
345: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
346: END IF;
347: -- Standard call to get message count and if count=1, get the message
348: FND_MSG_PUB.Count_And_Get (
349: p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data
352: );

Line 403: FND_MSG_PUB.initialize;

399: END IF;
400: -- Initialize message list if p_init_msg_list is set to TRUE.
401: IF FND_API.to_Boolean( p_init_msg_list )
402: THEN
403: FND_MSG_PUB.initialize;
404: END IF;
405: -- Debug Message
406: IF g_debug THEN
407: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' pub start');

Line 535: FND_MSG_PUB.Count_And_Get

531: IF g_debug THEN
532: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
533: END IF;
534: -- Standard call to get message count and if count is 1, get message info.
535: FND_MSG_PUB.Count_And_Get
536: (p_count => x_msg_count,
537: p_data => x_msg_data
538: );
539: EXCEPTION

Line 544: FND_MSG_PUB.Count_And_Get (

540: WHEN OZF_Utility_PVT.resource_locked THEN
541: ROLLBACK TO Create_Claim_Line_Tbl;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
544: FND_MSG_PUB.Count_And_Get (
545: p_encoded => FND_API.G_FALSE,
546: p_count => x_msg_count,
547: p_data => x_msg_data
548: );

Line 553: FND_MSG_PUB.Count_And_Get (

549: WHEN FND_API.G_EXC_ERROR THEN
550: ROLLBACK TO Create_Claim_Line_Tbl;
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: -- Standard call to get message count and if count=1, get the message
553: FND_MSG_PUB.Count_And_Get (
554: p_encoded => FND_API.G_FALSE,
555: p_count => x_msg_count,
556: p_data => x_msg_data
557: );

Line 562: FND_MSG_PUB.Count_And_Get (

558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
559: ROLLBACK TO Create_Claim_Line_Tbl;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: -- Standard call to get message count and if count=1, get the message
562: FND_MSG_PUB.Count_And_Get (
563: p_encoded => FND_API.G_FALSE,
564: p_count => x_msg_count,
565: p_data => x_msg_data
566: );

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

566: );
567: WHEN OTHERS THEN
568: ROLLBACK TO Create_Claim_Line_Tbl;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
573: END IF;
574: -- Standard call to get message count and if count=1, get the message

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

568: ROLLBACK TO Create_Claim_Line_Tbl;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
573: END IF;
574: -- Standard call to get message count and if count=1, get the message
575: FND_MSG_PUB.Count_And_Get (
576: p_encoded => FND_API.G_FALSE,

Line 575: FND_MSG_PUB.Count_And_Get (

571: THEN
572: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
573: END IF;
574: -- Standard call to get message count and if count=1, get the message
575: FND_MSG_PUB.Count_And_Get (
576: p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => x_msg_data
579: );

Line 644: FND_MSG_PUB.initialize;

640: END IF;
641: -- Initialize message list if p_init_msg_list is set to TRUE.
642: IF FND_API.to_Boolean( p_init_msg_list )
643: THEN
644: FND_MSG_PUB.initialize;
645: END IF;
646:
647: -- Debug Message
648: IF g_debug THEN

Line 876: FND_MSG_PUB.Count_And_Get

872: IF g_debug THEN
873: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
874: END IF;
875: -- Standard call to get message count and if count is 1, get message info.
876: FND_MSG_PUB.Count_And_Get
877: (p_count => x_msg_count,
878: p_data => x_msg_data
879: );
880: EXCEPTION

Line 885: FND_MSG_PUB.Count_And_Get (

881: WHEN OZF_Utility_PVT.resource_locked THEN
882: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
883: x_return_status := FND_API.g_ret_sts_error;
884: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
885: FND_MSG_PUB.Count_And_Get (
886: p_encoded => FND_API.G_FALSE,
887: p_count => x_msg_count,
888: p_data => x_msg_data
889: );

Line 894: FND_MSG_PUB.Count_And_Get (

890: WHEN FND_API.G_EXC_ERROR THEN
891: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893: -- Standard call to get message count and if count=1, get the message
894: FND_MSG_PUB.Count_And_Get (
895: p_encoded => FND_API.G_FALSE,
896: p_count => x_msg_count,
897: p_data => x_msg_data
898: );

Line 903: FND_MSG_PUB.Count_And_Get (

899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: -- Standard call to get message count and if count=1, get the message
903: FND_MSG_PUB.Count_And_Get (
904: p_encoded => FND_API.G_FALSE,
905: p_count => x_msg_count,
906: p_data => x_msg_data
907: );

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

907: );
908: WHEN OTHERS THEN
909: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
912: THEN
913: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
914: END IF;
915: -- Standard call to get message count and if count=1, get the message

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

909: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
912: THEN
913: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
914: END IF;
915: -- Standard call to get message count and if count=1, get the message
916: FND_MSG_PUB.Count_And_Get (
917: p_encoded => FND_API.G_FALSE,

Line 916: FND_MSG_PUB.Count_And_Get (

912: THEN
913: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
914: END IF;
915: -- Standard call to get message count and if count=1, get the message
916: FND_MSG_PUB.Count_And_Get (
917: p_encoded => FND_API.G_FALSE,
918: p_count => x_msg_count,
919: p_data => x_msg_data
920: );

Line 971: FND_MSG_PUB.initialize;

967: END IF;
968: -- Initialize message list if p_init_msg_list is set to TRUE.
969: IF FND_API.to_Boolean( p_init_msg_list )
970: THEN
971: FND_MSG_PUB.initialize;
972: END IF;
973: -- Debug Message
974: IF g_debug THEN
975: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

Line 1523: FND_MSG_PUB.Count_And_Get

1519: IF g_debug THEN
1520: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
1521: END IF;
1522: -- Standard call to get message count and if count is 1, get message info.
1523: FND_MSG_PUB.Count_And_Get
1524: (p_count => x_msg_count,
1525: p_data => x_msg_data
1526: );
1527: EXCEPTION

Line 1531: FND_MSG_PUB.Count_And_Get (

1527: EXCEPTION
1528: WHEN OZF_Utility_PVT.resource_locked THEN
1529: ROLLBACK TO Update_Claim_Line_Tbl;
1530: x_return_status := FND_API.g_ret_sts_error;
1531: FND_MSG_PUB.Count_And_Get (
1532: p_encoded => FND_API.G_FALSE,
1533: p_count => x_msg_count,
1534: p_data => x_msg_data
1535: );

Line 1541: FND_MSG_PUB.Count_And_Get (

1537: WHEN FND_API.G_EXC_ERROR THEN
1538: ROLLBACK TO Update_Claim_Line_Tbl;
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: -- Standard call to get message count and if count=1, get the message
1541: FND_MSG_PUB.Count_And_Get (
1542: p_encoded => FND_API.G_FALSE,
1543: p_count => x_msg_count,
1544: p_data => x_msg_data
1545: );

Line 1550: FND_MSG_PUB.Count_And_Get (

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

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

1554: );
1555: WHEN OTHERS THEN
1556: ROLLBACK TO Update_Claim_Line_Tbl;
1557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1558: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1559: THEN
1560: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1561: END IF;
1562: -- Standard call to get message count and if count=1, get the message

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

1556: ROLLBACK TO Update_Claim_Line_Tbl;
1557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1558: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1559: THEN
1560: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1561: END IF;
1562: -- Standard call to get message count and if count=1, get the message
1563: FND_MSG_PUB.Count_And_Get (
1564: p_encoded => FND_API.G_FALSE,

Line 1563: FND_MSG_PUB.Count_And_Get (

1559: THEN
1560: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1561: END IF;
1562: -- Standard call to get message count and if count=1, get the message
1563: FND_MSG_PUB.Count_And_Get (
1564: p_encoded => FND_API.G_FALSE,
1565: p_count => x_msg_count,
1566: p_data => x_msg_data
1567: );

Line 1616: FND_MSG_PUB.initialize;

1612: END IF;
1613: -- Initialize message list if p_init_msg_list is set to TRUE.
1614: IF FND_API.to_Boolean( p_init_msg_list )
1615: THEN
1616: FND_MSG_PUB.initialize;
1617: END IF;
1618: -- Debug Message
1619: IF g_debug THEN
1620: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

Line 1653: FND_MSG_PUB.Count_And_Get

1649: IF g_debug THEN
1650: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
1651: END IF;
1652: -- Standard call to get message count and if count is 1, get message info.
1653: FND_MSG_PUB.Count_And_Get
1654: (p_count => x_msg_count,
1655: p_data => x_msg_data
1656: );
1657: EXCEPTION

Line 1661: FND_MSG_PUB.Count_And_Get (

1657: EXCEPTION
1658: WHEN OZF_Utility_PVT.resource_locked THEN
1659: ROLLBACK TO DELETE_Claim_PUB;
1660: x_return_status := FND_API.g_ret_sts_error;
1661: FND_MSG_PUB.Count_And_Get (
1662: p_encoded => FND_API.G_FALSE,
1663: p_count => x_msg_count,
1664: p_data => x_msg_data
1665: );

Line 1671: FND_MSG_PUB.Count_And_Get (

1667: WHEN FND_API.G_EXC_ERROR THEN
1668: ROLLBACK TO DELETE_Claim_PUB;
1669: x_return_status := FND_API.G_RET_STS_ERROR;
1670: -- Standard call to get message count and if count=1, get the message
1671: FND_MSG_PUB.Count_And_Get (
1672: p_encoded => FND_API.G_FALSE,
1673: p_count => x_msg_count,
1674: p_data => x_msg_data
1675: );

Line 1680: FND_MSG_PUB.Count_And_Get (

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

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

1684: );
1685: WHEN OTHERS THEN
1686: ROLLBACK TO DELETE_Claim_PUB;
1687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1688: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1689: THEN
1690: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1691: END IF;
1692: -- Standard call to get message count and if count=1, get the message

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

1686: ROLLBACK TO DELETE_Claim_PUB;
1687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1688: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1689: THEN
1690: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1691: END IF;
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,

Line 1693: FND_MSG_PUB.Count_And_Get (

1689: THEN
1690: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1691: END IF;
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 1747: FND_MSG_PUB.initialize;

1743: END IF;
1744: -- Initialize message list if p_init_msg_list is set to TRUE.
1745: IF FND_API.to_Boolean( p_init_msg_list )
1746: THEN
1747: FND_MSG_PUB.initialize;
1748: END IF;
1749: -- Debug Message
1750: IF g_debug THEN
1751: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

Line 1800: FND_MSG_PUB.Count_And_Get

1796: IF g_debug THEN
1797: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
1798: END IF;
1799: -- Standard call to get message count and if count is 1, get message info.
1800: FND_MSG_PUB.Count_And_Get
1801: (p_count => x_msg_count,
1802: p_data => x_msg_data
1803: );
1804: EXCEPTION

Line 1809: FND_MSG_PUB.Count_And_Get (

1805: WHEN OZF_Utility_PVT.resource_locked THEN
1806: ROLLBACK TO DELETE_Claim_Line_PUB;
1807: x_return_status := FND_API.G_RET_STS_ERROR;
1808: -- Standard call to get message count and if count=1, get the message
1809: FND_MSG_PUB.Count_And_Get (
1810: p_encoded => FND_API.G_FALSE,
1811: p_count => x_msg_count,
1812: p_data => x_msg_data
1813: );

Line 1819: FND_MSG_PUB.Count_And_Get (

1815: WHEN FND_API.G_EXC_ERROR THEN
1816: ROLLBACK TO DELETE_Claim_Line_PUB;
1817: x_return_status := FND_API.G_RET_STS_ERROR;
1818: -- Standard call to get message count and if count=1, get the message
1819: FND_MSG_PUB.Count_And_Get (
1820: p_encoded => FND_API.G_FALSE,
1821: p_count => x_msg_count,
1822: p_data => x_msg_data
1823: );

Line 1828: FND_MSG_PUB.Count_And_Get (

1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1825: ROLLBACK TO DELETE_Claim_Line_PUB;
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1827: -- Standard call to get message count and if count=1, get the message
1828: FND_MSG_PUB.Count_And_Get (
1829: p_encoded => FND_API.G_FALSE,
1830: p_count => x_msg_count,
1831: p_data => x_msg_data
1832: );

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

1832: );
1833: WHEN OTHERS THEN
1834: ROLLBACK TO DELETE_Claim_PUB;
1835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1836: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1837: THEN
1838: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1839: END IF;
1840: -- Standard call to get message count and if count=1, get the message

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

1834: ROLLBACK TO DELETE_Claim_PUB;
1835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1836: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1837: THEN
1838: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1839: END IF;
1840: -- Standard call to get message count and if count=1, get the message
1841: FND_MSG_PUB.Count_And_Get (
1842: p_encoded => FND_API.G_FALSE,

Line 1841: FND_MSG_PUB.Count_And_Get (

1837: THEN
1838: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1839: END IF;
1840: -- Standard call to get message count and if count=1, get the message
1841: FND_MSG_PUB.Count_And_Get (
1842: p_encoded => FND_API.G_FALSE,
1843: p_count => x_msg_count,
1844: p_data => x_msg_data
1845: );

Line 1906: FND_MSG_PUB.initialize;

1902: END IF;
1903:
1904: -- Initialize message list if p_init_msg_list is set to TRUE.
1905: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1906: FND_MSG_PUB.initialize;
1907: END IF;
1908:
1909: -- Initialize API return status to SUCCESS
1910: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1972: FND_MSG_PUB.Count_And_Get(

1968: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1969: END IF;
1970:
1971: -- Standard call to get message count and if count is 1, get message info.
1972: FND_MSG_PUB.Count_And_Get(
1973: p_count => x_msg_count,
1974: p_data => x_msg_data
1975: );
1976:

Line 1981: FND_MSG_PUB.Count_And_Get (

1977: EXCEPTION
1978: WHEN FND_API.G_EXC_ERROR THEN
1979: ROLLBACK TO Asso_Accruals_To_Claim;
1980: x_return_status := FND_API.G_RET_STS_ERROR;
1981: FND_MSG_PUB.Count_And_Get (
1982: p_encoded => FND_API.G_FALSE,
1983: p_count => x_msg_count,
1984: p_data => x_msg_data
1985: );

Line 1990: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1986:
1987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1988: ROLLBACK TO Asso_Accruals_To_Claim;
1989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1990: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1991: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
1992: FND_MSG_PUB.add;
1993: END IF;
1994: FND_MSG_PUB.Count_And_Get (

Line 1992: FND_MSG_PUB.add;

1988: ROLLBACK TO Asso_Accruals_To_Claim;
1989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1990: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1991: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
1992: FND_MSG_PUB.add;
1993: END IF;
1994: FND_MSG_PUB.Count_And_Get (
1995: p_encoded => FND_API.G_FALSE,
1996: p_count => x_msg_count,

Line 1994: FND_MSG_PUB.Count_And_Get (

1990: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1991: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
1992: FND_MSG_PUB.add;
1993: END IF;
1994: FND_MSG_PUB.Count_And_Get (
1995: p_encoded => FND_API.G_FALSE,
1996: p_count => x_msg_count,
1997: p_data => x_msg_data
1998: );

Line 2003: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1999:
2000: WHEN OTHERS THEN
2001: ROLLBACK TO Asso_Accruals_To_Claim;
2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2003: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2004: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2005: FND_MSG_PUB.add;
2006: END IF;
2007: FND_MSG_PUB.Count_And_Get (

Line 2005: FND_MSG_PUB.add;

2001: ROLLBACK TO Asso_Accruals_To_Claim;
2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2003: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2004: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2005: FND_MSG_PUB.add;
2006: END IF;
2007: FND_MSG_PUB.Count_And_Get (
2008: p_encoded => FND_API.G_FALSE,
2009: p_count => x_msg_count,

Line 2007: FND_MSG_PUB.Count_And_Get (

2003: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2004: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2005: FND_MSG_PUB.add;
2006: END IF;
2007: FND_MSG_PUB.Count_And_Get (
2008: p_encoded => FND_API.G_FALSE,
2009: p_count => x_msg_count,
2010: p_data => x_msg_data
2011: );

Line 2066: FND_MSG_PUB.initialize;

2062: END IF;
2063:
2064: -- Initialize message list if p_init_msg_list is set to TRUE.
2065: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2066: FND_MSG_PUB.initialize;
2067: END IF;
2068:
2069: -- Initialize API return status to SUCCESS
2070: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2103: FND_MSG_PUB.Count_And_Get(

2099: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2100: END IF;
2101:
2102: -- Standard call to get message count and if count is 1, get message info.
2103: FND_MSG_PUB.Count_And_Get(
2104: p_count => x_msg_count,
2105: p_data => x_msg_data
2106: );
2107:

Line 2112: FND_MSG_PUB.Count_And_Get (

2108: EXCEPTION
2109: WHEN FND_API.G_EXC_ERROR THEN
2110: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2111: x_return_status := FND_API.G_RET_STS_ERROR;
2112: FND_MSG_PUB.Count_And_Get (
2113: p_encoded => FND_API.G_FALSE,
2114: p_count => x_msg_count,
2115: p_data => x_msg_data
2116: );

Line 2121: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2117:
2118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2119: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2121: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2122: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2123: FND_MSG_PUB.add;
2124: END IF;
2125: FND_MSG_PUB.Count_And_Get (

Line 2123: FND_MSG_PUB.add;

2119: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2121: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2122: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2123: FND_MSG_PUB.add;
2124: END IF;
2125: FND_MSG_PUB.Count_And_Get (
2126: p_encoded => FND_API.G_FALSE,
2127: p_count => x_msg_count,

Line 2125: FND_MSG_PUB.Count_And_Get (

2121: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2122: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2123: FND_MSG_PUB.add;
2124: END IF;
2125: FND_MSG_PUB.Count_And_Get (
2126: p_encoded => FND_API.G_FALSE,
2127: p_count => x_msg_count,
2128: p_data => x_msg_data
2129: );

Line 2134: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2130:
2131: WHEN OTHERS THEN
2132: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2134: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2135: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2136: FND_MSG_PUB.add;
2137: END IF;
2138: FND_MSG_PUB.Count_And_Get (

Line 2136: FND_MSG_PUB.add;

2132: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2134: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2135: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2136: FND_MSG_PUB.add;
2137: END IF;
2138: FND_MSG_PUB.Count_And_Get (
2139: p_encoded => FND_API.G_FALSE,
2140: p_count => x_msg_count,

Line 2138: FND_MSG_PUB.Count_And_Get (

2134: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2135: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2136: FND_MSG_PUB.add;
2137: END IF;
2138: FND_MSG_PUB.Count_And_Get (
2139: p_encoded => FND_API.G_FALSE,
2140: p_count => x_msg_count,
2141: p_data => x_msg_data
2142: );

Line 2204: FND_MSG_PUB.initialize;

2200: END IF;
2201:
2202: -- Initialize message list if p_init_msg_list is set to TRUE.
2203: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2204: FND_MSG_PUB.initialize;
2205: END IF;
2206:
2207: -- Initialize API return status to SUCCESS
2208: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2334: FND_MSG_PUB.Count_And_Get(

2330: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2331: END IF;
2332:
2333: -- Standard call to get message count and if count is 1, get message info.
2334: FND_MSG_PUB.Count_And_Get(
2335: p_count => x_msg_count,
2336: p_data => x_msg_data
2337: );
2338:

Line 2343: FND_MSG_PUB.Count_And_Get (

2339: EXCEPTION
2340: WHEN FND_API.G_EXC_ERROR THEN
2341: ROLLBACK TO Create_Claim_For_Accruals;
2342: x_return_status := FND_API.G_RET_STS_ERROR;
2343: FND_MSG_PUB.Count_And_Get (
2344: p_encoded => FND_API.G_FALSE,
2345: p_count => x_msg_count,
2346: p_data => x_msg_data
2347: );

Line 2352: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2348:
2349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2350: ROLLBACK TO Create_Claim_For_Accruals;
2351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2352: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2353: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2354: FND_MSG_PUB.add;
2355: END IF;
2356: FND_MSG_PUB.Count_And_Get (

Line 2354: FND_MSG_PUB.add;

2350: ROLLBACK TO Create_Claim_For_Accruals;
2351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2352: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2353: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2354: FND_MSG_PUB.add;
2355: END IF;
2356: FND_MSG_PUB.Count_And_Get (
2357: p_encoded => FND_API.G_FALSE,
2358: p_count => x_msg_count,

Line 2356: FND_MSG_PUB.Count_And_Get (

2352: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2353: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2354: FND_MSG_PUB.add;
2355: END IF;
2356: FND_MSG_PUB.Count_And_Get (
2357: p_encoded => FND_API.G_FALSE,
2358: p_count => x_msg_count,
2359: p_data => x_msg_data
2360: );

Line 2365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2361:
2362: WHEN OTHERS THEN
2363: ROLLBACK TO Create_Claim_For_Accruals;
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2366: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2367: FND_MSG_PUB.add;
2368: END IF;
2369: FND_MSG_PUB.Count_And_Get (

Line 2367: FND_MSG_PUB.add;

2363: ROLLBACK TO Create_Claim_For_Accruals;
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2366: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2367: FND_MSG_PUB.add;
2368: END IF;
2369: FND_MSG_PUB.Count_And_Get (
2370: p_encoded => FND_API.G_FALSE,
2371: p_count => x_msg_count,

Line 2369: FND_MSG_PUB.Count_And_Get (

2365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2366: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2367: FND_MSG_PUB.add;
2368: END IF;
2369: FND_MSG_PUB.Count_And_Get (
2370: p_encoded => FND_API.G_FALSE,
2371: p_count => x_msg_count,
2372: p_data => x_msg_data
2373: );

Line 2435: FND_MSG_PUB.initialize;

2431: END IF;
2432:
2433: -- Initialize message list if p_init_msg_list is set to TRUE.
2434: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2435: FND_MSG_PUB.initialize;
2436: END IF;
2437:
2438: -- Initialize API return status to SUCCESS
2439: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2565: FND_MSG_PUB.Count_And_Get(

2561: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2562: END IF;
2563:
2564: -- Standard call to get message count and if count is 1, get message info.
2565: FND_MSG_PUB.Count_And_Get(
2566: p_count => x_msg_count,
2567: p_data => x_msg_data
2568: );
2569:

Line 2574: FND_MSG_PUB.Count_And_Get (

2570: EXCEPTION
2571: WHEN FND_API.G_EXC_ERROR THEN
2572: ROLLBACK TO Pay_Claim_For_Accruals;
2573: x_return_status := FND_API.G_RET_STS_ERROR;
2574: FND_MSG_PUB.Count_And_Get (
2575: p_encoded => FND_API.G_FALSE,
2576: p_count => x_msg_count,
2577: p_data => x_msg_data
2578: );

Line 2583: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2579:
2580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2581: ROLLBACK TO Pay_Claim_For_Accruals;
2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2583: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2584: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2585: FND_MSG_PUB.add;
2586: END IF;
2587: FND_MSG_PUB.Count_And_Get (

Line 2585: FND_MSG_PUB.add;

2581: ROLLBACK TO Pay_Claim_For_Accruals;
2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2583: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2584: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2585: FND_MSG_PUB.add;
2586: END IF;
2587: FND_MSG_PUB.Count_And_Get (
2588: p_encoded => FND_API.G_FALSE,
2589: p_count => x_msg_count,

Line 2587: FND_MSG_PUB.Count_And_Get (

2583: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2584: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2585: FND_MSG_PUB.add;
2586: END IF;
2587: FND_MSG_PUB.Count_And_Get (
2588: p_encoded => FND_API.G_FALSE,
2589: p_count => x_msg_count,
2590: p_data => x_msg_data
2591: );

Line 2596: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2592:
2593: WHEN OTHERS THEN
2594: ROLLBACK TO Pay_Claim_For_Accruals;
2595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2596: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2597: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2598: FND_MSG_PUB.add;
2599: END IF;
2600: FND_MSG_PUB.Count_And_Get (

Line 2598: FND_MSG_PUB.add;

2594: ROLLBACK TO Pay_Claim_For_Accruals;
2595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2596: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2597: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2598: FND_MSG_PUB.add;
2599: END IF;
2600: FND_MSG_PUB.Count_And_Get (
2601: p_encoded => FND_API.G_FALSE,
2602: p_count => x_msg_count,

Line 2600: FND_MSG_PUB.Count_And_Get (

2596: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2597: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2598: FND_MSG_PUB.add;
2599: END IF;
2600: FND_MSG_PUB.Count_And_Get (
2601: p_encoded => FND_API.G_FALSE,
2602: p_count => x_msg_count,
2603: p_data => x_msg_data
2604: );