DBA Data[Home] [Help]

APPS.OZF_CLAIM_PUB dependencies on OZF_UTILITY_PVT

Line 82: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' pub start');

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');
83: END IF;
84: -- Initialize API return status to SUCCESS
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: --

Line 253: -- OZF_UTILITY_PVT.debug_message('Call Private APICreate Claim Procdure 1');

249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251: l_pvt_claim_rec := l_x_pvt_claim_rec;
252:
253: -- OZF_UTILITY_PVT.debug_message('Call Private APICreate Claim Procdure 1');
254: OZF_claim_PVT.Create_Claim(
255: p_api_version => p_api_version_number,
256: p_init_msg_list => FND_API.G_FALSE,
257: p_commit => FND_API.G_FALSE,

Line 290: ozf_utility_pvt.debug_message('return status for create_claim_line_tbl =>'||x_return_status);

286: ,x_msg_count => x_msg_count
287: ,p_claim_line_tbl => l_claim_line_tbl
288: ,x_error_index => l_error_index);
289: IF g_debug THEN
290: ozf_utility_pvt.debug_message('return status for create_claim_line_tbl =>'||x_return_status);
291: END IF;
292: IF x_return_status = FND_API.G_RET_STS_ERROR then
293: RAISE FND_API.G_EXC_ERROR;
294: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

Line 299: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: END IF;
297: -- Debug Message
298: IF g_debug THEN
299: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
300: END IF;
301: IF FND_API.to_Boolean( p_commit )
302: THEN
303: COMMIT WORK;

Line 305: --OZF_UTILITY_PVT.DEBUG_MESSAGE('CLAIM_ID=>'||l_claim_line_rec.claim_id);

301: IF FND_API.to_Boolean( p_commit )
302: THEN
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,

Line 313: WHEN OZF_Utility_PVT.resource_locked THEN

309: p_count => x_msg_count,
310: p_data => x_msg_data
311: );
312: EXCEPTION
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 (

Line 316: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

312: EXCEPTION
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

Line 407: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' pub start');

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');
408: END IF;
409: -- Initialize API return status to SUCCESS
410: x_return_status := FND_API.G_RET_STS_SUCCESS;
411: IF p_claim_line_tbl.count > 0 THEN

Line 518: ozf_utility_pvt.debug_message('return status for create_claim_line_tbl =>'||x_return_status);

514: ,x_msg_count => x_msg_count
515: ,p_claim_line_tbl => l_pvt_claim_line_tbl
516: ,x_error_index => l_error_index);
517: IF g_debug THEN
518: ozf_utility_pvt.debug_message('return status for create_claim_line_tbl =>'||x_return_status);
519: END IF;
520: IF x_return_status = FND_API.G_RET_STS_ERROR then
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

Line 532: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

528: COMMIT WORK;
529: END IF;
530: -- Debug Message
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,

Line 540: WHEN OZF_Utility_PVT.resource_locked THEN

536: (p_count => x_msg_count,
537: p_data => x_msg_data
538: );
539: EXCEPTION
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 (

Line 543: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

539: EXCEPTION
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

Line 649: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

645: END IF;
646:
647: -- Debug Message
648: IF g_debug THEN
649: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
650: END IF;
651:
652: -- Initialize API return status to SUCCESS
653: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 811: OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION NUMBER =>'||NVL(x_object_version_number,-99));

807: p_event => 'UPDATE',
808: p_mode => OZF_claim_Utility_pvt.G_AUTO_MODE,
809: x_object_version_number => x_object_version_number );
810: IF g_debug THEN
811: OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION NUMBER =>'||NVL(x_object_version_number,-99));
812: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR UPDATE CLAIM =>'||X_RETURN_STATUS);
813: END IF;
814: -- Check return status from the above procedure call
815: IF x_return_status = FND_API.G_RET_STS_ERROR then

Line 812: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR UPDATE CLAIM =>'||X_RETURN_STATUS);

808: p_mode => OZF_claim_Utility_pvt.G_AUTO_MODE,
809: x_object_version_number => x_object_version_number );
810: IF g_debug THEN
811: OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION NUMBER =>'||NVL(x_object_version_number,-99));
812: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR UPDATE CLAIM =>'||X_RETURN_STATUS);
813: END IF;
814: -- Check return status from the above procedure call
815: IF x_return_status = FND_API.G_RET_STS_ERROR then
816: RAISE FND_API.G_EXC_ERROR;

Line 835: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_source_object_class =>'||l_source_object_class);

831: FETCH Claim_Source_csr INTO l_source_object_class;
832: ClOSE Claim_Source_csr;
833:
834: IF g_debug THEN
835: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_source_object_class =>'||l_source_object_class);
836: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_claim_rec.claim_id =>'||l_claim_rec.claim_id);
837: END IF;
838: --Added for bug 6965694
839: -- Added for bug 7443072

Line 836: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_claim_rec.claim_id =>'||l_claim_rec.claim_id);

832: ClOSE Claim_Source_csr;
833:
834: IF g_debug THEN
835: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_source_object_class =>'||l_source_object_class);
836: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_claim_rec.claim_id =>'||l_claim_rec.claim_id);
837: END IF;
838: --Added for bug 6965694
839: -- Added for bug 7443072
840:

Line 856: --OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION =>'||NVL(x_object_version,-99));

852: ,p_claim_line_tbl => l_claim_line_tbl
853: ,p_change_object_version => FND_API.g_false
854: ,x_error_index => x_error_index);
855: END IF;
856: --OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION =>'||NVL(x_object_version,-99));
857: IF g_debug THEN
858: OZF_UTILITY_PVT.DEBUG_MESSAGE('Return Status for Update claim line =>'||x_return_status);
859: END IF;
860: IF x_return_status = FND_API.G_RET_STS_ERROR then

Line 858: OZF_UTILITY_PVT.DEBUG_MESSAGE('Return Status for Update claim line =>'||x_return_status);

854: ,x_error_index => x_error_index);
855: END IF;
856: --OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION =>'||NVL(x_object_version,-99));
857: IF g_debug THEN
858: OZF_UTILITY_PVT.DEBUG_MESSAGE('Return Status for Update claim line =>'||x_return_status);
859: END IF;
860: IF x_return_status = FND_API.G_RET_STS_ERROR then
861: RAISE FND_API.G_EXC_ERROR;
862: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

Line 873: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

869: COMMIT WORK;
870: END IF;
871: -- Debug Message
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,

Line 881: WHEN OZF_Utility_PVT.resource_locked THEN

877: (p_count => x_msg_count,
878: p_data => x_msg_data
879: );
880: EXCEPTION
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 (

Line 884: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

880: EXCEPTION
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

Line 975: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

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');
976: END IF;
977:
978: -- Initialize API return status to SUCCESS
979: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1506: OZF_UTILITY_PVT.DEBUG_MESSAGE('sTATUS FOR Update claim line =>'||x_return_status);

1502: ,p_claim_line_tbl => l_pvt_claim_line_tbl
1503: ,p_change_object_version => FND_API.g_false
1504: ,x_error_index => l_error_index );
1505: IF g_debug THEN
1506: OZF_UTILITY_PVT.DEBUG_MESSAGE('sTATUS FOR Update claim line =>'||x_return_status);
1507: END IF;
1508: IF x_return_status = FND_API.G_RET_STS_ERROR then
1509: RAISE FND_API.G_EXC_ERROR;
1510: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

Line 1520: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

1516: COMMIT WORK;
1517: END IF;
1518: -- Debug Message
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,

Line 1528: WHEN OZF_Utility_PVT.resource_locked THEN

1524: (p_count => x_msg_count,
1525: p_data => x_msg_data
1526: );
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,

Line 1536: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1532: p_encoded => FND_API.G_FALSE,
1533: p_count => x_msg_count,
1534: p_data => x_msg_data
1535: );
1536: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
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

Line 1620: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

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');
1621: END IF;
1622: -- Initialize API return status to SUCCESS
1623: x_return_status := FND_API.G_RET_STS_SUCCESS;
1624: --

Line 1639: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR DELETE_CLAIM =>'||X_RETURN_STATUS);

1635: x_msg_data => x_msg_data
1636: );
1637: --
1638: IF g_debug THEN
1639: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR DELETE_CLAIM =>'||X_RETURN_STATUS);
1640: END IF;
1641: -- Check return status from the above procedure call
1642: --
1643: -- Standard check for p_commit

Line 1650: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

1646: COMMIT WORK;
1647: END IF;
1648: -- Debug Message
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,

Line 1658: WHEN OZF_Utility_PVT.resource_locked THEN

1654: (p_count => x_msg_count,
1655: p_data => x_msg_data
1656: );
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,

Line 1666: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1662: p_encoded => FND_API.G_FALSE,
1663: p_count => x_msg_count,
1664: p_data => x_msg_data
1665: );
1666: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
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

Line 1751: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

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');
1752: END IF;
1753: -- Initialize API return status to SUCCESS
1754: x_return_status := FND_API.G_RET_STS_SUCCESS;
1755: --

Line 1779: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR DELETE_CLAIM_Line_Tbl =>'||X_RETURN_STATUS);

1775: ,p_claim_line_tbl => l_pvt_claim_line_tbl
1776: ,p_change_object_version => FND_API.g_false
1777: ,x_error_index => l_error_index);
1778: IF g_debug THEN
1779: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR DELETE_CLAIM_Line_Tbl =>'||X_RETURN_STATUS);
1780: END IF;
1781: -- Check return status from the above procedure call
1782: IF x_return_status = FND_API.G_RET_STS_ERROR then
1783: RAISE FND_API.G_EXC_ERROR;

Line 1797: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

1793: COMMIT WORK;
1794: END IF;
1795: -- Debug Message
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,

Line 1805: WHEN OZF_Utility_PVT.resource_locked THEN

1801: (p_count => x_msg_count,
1802: p_data => x_msg_data
1803: );
1804: EXCEPTION
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 (

Line 1814: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1810: p_encoded => FND_API.G_FALSE,
1811: p_count => x_msg_count,
1812: p_data => x_msg_data
1813: );
1814: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
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

Line 1893: OZF_Utility_PVT.debug_message(l_full_name||': start');

1889: -- Standard Start of API savepoint
1890: SAVEPOINT Asso_Accruals_To_Claim;
1891:
1892: IF G_DEBUG THEN
1893: OZF_Utility_PVT.debug_message(l_full_name||': start');
1894: END IF;
1895:
1896: -- Standard call to check for call compatibility.
1897: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 1968: OZF_Utility_PVT.debug_message(l_full_name ||': end');

1964: COMMIT WORK;
1965: END IF;
1966:
1967: IF G_DEBUG THEN
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(

Line 2053: OZF_Utility_PVT.debug_message(l_full_name||': start');

2049: -- Standard Start of API savepoint
2050: SAVEPOINT Asso_Accruals_To_Claim_Line;
2051:
2052: IF G_DEBUG THEN
2053: OZF_Utility_PVT.debug_message(l_full_name||': start');
2054: END IF;
2055:
2056: -- Standard call to check for call compatibility.
2057: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 2099: OZF_Utility_PVT.debug_message(l_full_name ||': end');

2095: COMMIT WORK;
2096: END IF;
2097:
2098: IF G_DEBUG THEN
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(

Line 2191: OZF_Utility_PVT.debug_message(l_full_name||': start');

2187: -- Standard Start of API savepoint
2188: SAVEPOINT Create_Claim_For_Accruals;
2189:
2190: IF G_DEBUG THEN
2191: OZF_Utility_PVT.debug_message(l_full_name||': start');
2192: END IF;
2193:
2194: -- Standard call to check for call compatibility.
2195: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 2330: OZF_Utility_PVT.debug_message(l_full_name ||': end');

2326: COMMIT WORK;
2327: END IF;
2328:
2329: IF G_DEBUG THEN
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(

Line 2422: OZF_Utility_PVT.debug_message(l_full_name||': start');

2418: -- Standard Start of API savepoint
2419: SAVEPOINT Pay_Claim_For_Accruals;
2420:
2421: IF G_DEBUG THEN
2422: OZF_Utility_PVT.debug_message(l_full_name||': start');
2423: END IF;
2424:
2425: -- Standard call to check for call compatibility.
2426: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 2561: OZF_Utility_PVT.debug_message(l_full_name ||': end');

2557: COMMIT WORK;
2558: END IF;
2559:
2560: IF G_DEBUG THEN
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(