DBA Data[Home] [Help]

APPS.OZF_CLAIM_PUB dependencies on OZF_UTILITY_PVT

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

103: FND_MSG_PUB.initialize;
104: END IF;
105: -- Debug Message
106: IF g_debug THEN
107: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' pub start');
108: END IF;
109: -- Initialize API return status to SUCCESS
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: --

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

274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
275: END IF;
276: l_pvt_claim_rec := l_x_pvt_claim_rec;
277:
278: -- OZF_UTILITY_PVT.debug_message('Call Private APICreate Claim Procdure 1');
279: OZF_claim_PVT.Create_Claim(
280: p_api_version => p_api_version_number,
281: p_init_msg_list => FND_API.G_FALSE,
282: p_commit => FND_API.G_FALSE,

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

334: ,x_msg_count => x_msg_count
335: ,p_claim_line_tbl => l_claim_line_tbl
336: ,x_error_index => l_error_index);
337: IF g_debug THEN
338: ozf_utility_pvt.debug_message('return status for create_claim_line_tbl =>'||x_return_status);
339: END IF;
340: IF x_return_status = FND_API.G_RET_STS_ERROR then
341: RAISE FND_API.G_EXC_ERROR;
342: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345: -- Debug Message
346: IF g_debug THEN
347: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
348: END IF;
349: IF FND_API.to_Boolean( p_commit )
350: THEN
351: COMMIT WORK;

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

349: IF FND_API.to_Boolean( p_commit )
350: THEN
351: COMMIT WORK;
352: END IF;
353: --OZF_UTILITY_PVT.DEBUG_MESSAGE('CLAIM_ID=>'||l_claim_line_rec.claim_id);
354: -- Standard call to get message count and if count is 1, get message info.
355: FND_MSG_PUB.Count_And_Get (
356: p_encoded => FND_API.G_FALSE,
357: p_count => x_msg_count,

Line 361: WHEN OZF_Utility_PVT.resource_locked THEN

357: p_count => x_msg_count,
358: p_data => x_msg_data
359: );
360: EXCEPTION
361: WHEN OZF_Utility_PVT.resource_locked THEN
362: ROLLBACK TO CREATE_Claim_PUB;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
365: FND_MSG_PUB.Count_And_Get (

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

360: EXCEPTION
361: WHEN OZF_Utility_PVT.resource_locked THEN
362: ROLLBACK TO CREATE_Claim_PUB;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
365: FND_MSG_PUB.Count_And_Get (
366: p_encoded => FND_API.G_FALSE,
367: p_count => x_msg_count,
368: p_data => x_msg_data

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

451: FND_MSG_PUB.initialize;
452: END IF;
453: -- Debug Message
454: IF g_debug THEN
455: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' pub start');
456: END IF;
457: -- Initialize API return status to SUCCESS
458: x_return_status := FND_API.G_RET_STS_SUCCESS;
459: IF p_claim_line_tbl.count > 0 THEN

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

562: ,x_msg_count => x_msg_count
563: ,p_claim_line_tbl => l_pvt_claim_line_tbl
564: ,x_error_index => l_error_index);
565: IF g_debug THEN
566: ozf_utility_pvt.debug_message('return status for create_claim_line_tbl =>'||x_return_status);
567: END IF;
568: IF x_return_status = FND_API.G_RET_STS_ERROR then
569: RAISE FND_API.G_EXC_ERROR;
570: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

576: COMMIT WORK;
577: END IF;
578: -- Debug Message
579: IF g_debug THEN
580: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
581: END IF;
582: -- Standard call to get message count and if count is 1, get message info.
583: FND_MSG_PUB.Count_And_Get
584: (p_count => x_msg_count,

Line 588: WHEN OZF_Utility_PVT.resource_locked THEN

584: (p_count => x_msg_count,
585: p_data => x_msg_data
586: );
587: EXCEPTION
588: WHEN OZF_Utility_PVT.resource_locked THEN
589: ROLLBACK TO Create_Claim_Line_Tbl;
590: x_return_status := FND_API.G_RET_STS_ERROR;
591: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
592: FND_MSG_PUB.Count_And_Get (

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

587: EXCEPTION
588: WHEN OZF_Utility_PVT.resource_locked THEN
589: ROLLBACK TO Create_Claim_Line_Tbl;
590: x_return_status := FND_API.G_RET_STS_ERROR;
591: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
592: FND_MSG_PUB.Count_And_Get (
593: p_encoded => FND_API.G_FALSE,
594: p_count => x_msg_count,
595: p_data => x_msg_data

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

707: END IF;
708:
709: -- Debug Message
710: IF g_debug THEN
711: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
712: END IF;
713:
714: -- Initialize API return status to SUCCESS
715: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

869: p_event => 'UPDATE',
870: p_mode => OZF_claim_Utility_pvt.G_AUTO_MODE,
871: x_object_version_number => x_object_version_number );
872: IF g_debug THEN
873: OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION NUMBER =>'||NVL(x_object_version_number,-99));
874: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR UPDATE CLAIM =>'||X_RETURN_STATUS);
875: END IF;
876: -- Check return status from the above procedure call
877: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

870: p_mode => OZF_claim_Utility_pvt.G_AUTO_MODE,
871: x_object_version_number => x_object_version_number );
872: IF g_debug THEN
873: OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION NUMBER =>'||NVL(x_object_version_number,-99));
874: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR UPDATE CLAIM =>'||X_RETURN_STATUS);
875: END IF;
876: -- Check return status from the above procedure call
877: IF x_return_status = FND_API.G_RET_STS_ERROR then
878: RAISE FND_API.G_EXC_ERROR;

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

916: FETCH Claim_Source_csr INTO l_source_object_class;
917: ClOSE Claim_Source_csr;
918:
919: IF g_debug THEN
920: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_source_object_class =>'||l_source_object_class);
921: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_claim_rec.claim_id =>'||l_claim_rec.claim_id);
922: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_claim_line_tbl.count =>'||l_claim_line_tbl.count);
923: END IF;
924: --Added for bug 6965694

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

917: ClOSE Claim_Source_csr;
918:
919: IF g_debug THEN
920: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_source_object_class =>'||l_source_object_class);
921: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_claim_rec.claim_id =>'||l_claim_rec.claim_id);
922: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_claim_line_tbl.count =>'||l_claim_line_tbl.count);
923: END IF;
924: --Added for bug 6965694
925: -- Added for bug 7443072

Line 922: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_claim_line_tbl.count =>'||l_claim_line_tbl.count);

918:
919: IF g_debug THEN
920: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_source_object_class =>'||l_source_object_class);
921: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_claim_rec.claim_id =>'||l_claim_rec.claim_id);
922: OZF_UTILITY_PVT.DEBUG_MESSAGE('In Public API l_claim_line_tbl.count =>'||l_claim_line_tbl.count);
923: END IF;
924: --Added for bug 6965694
925: -- Added for bug 7443072
926:

Line 930: OZF_UTILITY_PVT.DEBUG_MESSAGE('Before Calling Update_Claim_Line_Tbl ');

926:
927: IF (l_source_object_class NOT IN ('PPVENDOR','PPINCVENDOR')
928: OR ( l_source_object_class IN ('PPVENDOR','PPINCVENDOR') AND l_claim_line_tbl.count >1))
929: THEN
930: OZF_UTILITY_PVT.DEBUG_MESSAGE('Before Calling Update_Claim_Line_Tbl ');
931: Update_Claim_Line_Tbl(
932: p_api_version => p_api_version_number
933: ,p_init_msg_list => FND_API.G_FALSE
934: ,p_commit => FND_API.G_FALSE

Line 943: OZF_UTILITY_PVT.DEBUG_MESSAGE('After Call Update_Claim_Line_Tbl ');

939: ,p_claim_line_tbl => l_claim_line_tbl
940: ,p_change_object_version => FND_API.g_false -- Added For Fix
941: ,x_error_index => x_error_index);
942:
943: OZF_UTILITY_PVT.DEBUG_MESSAGE('After Call Update_Claim_Line_Tbl ');
944: END IF;
945: --OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION =>'||NVL(x_object_version,-99));
946: IF g_debug THEN
947: OZF_UTILITY_PVT.DEBUG_MESSAGE('Return Status for Update claim line =>'||x_return_status);

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

941: ,x_error_index => x_error_index);
942:
943: OZF_UTILITY_PVT.DEBUG_MESSAGE('After Call Update_Claim_Line_Tbl ');
944: END IF;
945: --OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION =>'||NVL(x_object_version,-99));
946: IF g_debug THEN
947: OZF_UTILITY_PVT.DEBUG_MESSAGE('Return Status for Update claim line =>'||x_return_status);
948: END IF;
949: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

943: OZF_UTILITY_PVT.DEBUG_MESSAGE('After Call Update_Claim_Line_Tbl ');
944: END IF;
945: --OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION =>'||NVL(x_object_version,-99));
946: IF g_debug THEN
947: OZF_UTILITY_PVT.DEBUG_MESSAGE('Return Status for Update claim line =>'||x_return_status);
948: END IF;
949: IF x_return_status = FND_API.G_RET_STS_ERROR then
950: RAISE FND_API.G_EXC_ERROR;
951: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

958: COMMIT WORK;
959: END IF;
960: -- Debug Message
961: IF g_debug THEN
962: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
963: END IF;
964: -- Standard call to get message count and if count is 1, get message info.
965: FND_MSG_PUB.Count_And_Get
966: (p_count => x_msg_count,

Line 970: WHEN OZF_Utility_PVT.resource_locked THEN

966: (p_count => x_msg_count,
967: p_data => x_msg_data
968: );
969: EXCEPTION
970: WHEN OZF_Utility_PVT.resource_locked THEN
971: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
972: x_return_status := FND_API.g_ret_sts_error;
973: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
974: FND_MSG_PUB.Count_And_Get (

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

969: EXCEPTION
970: WHEN OZF_Utility_PVT.resource_locked THEN
971: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
972: x_return_status := FND_API.g_ret_sts_error;
973: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
974: FND_MSG_PUB.Count_And_Get (
975: p_encoded => FND_API.G_FALSE,
976: p_count => x_msg_count,
977: p_data => x_msg_data

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

1168: FND_MSG_PUB.initialize;
1169: END IF;
1170: -- Debug Message
1171: IF g_debug THEN
1172: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
1173: END IF;
1174:
1175: -- Initialize API return status to SUCCESS
1176: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1464: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(

1460: END IF;
1461:
1462:
1463: IF l_claim_line_tbl(i).item_type IS NOT NULL THEN
1464: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(
1465: p_lookup_table_name =>'OZF_LOOKUPS'
1466: ,p_lookup_type =>'OZF_CLAIM_LINE_ITEM_TYPE'
1467: ,p_lookup_code => l_claim_line_tbl(i).item_type);
1468:

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

1715: ,p_claim_line_tbl => l_pvt_claim_line_tbl
1716: ,p_change_object_version => FND_API.g_false
1717: ,x_error_index => l_error_index );
1718: IF g_debug THEN
1719: OZF_UTILITY_PVT.DEBUG_MESSAGE('sTATUS FOR Update claim line =>'||x_return_status);
1720: END IF;
1721: IF x_return_status = FND_API.G_RET_STS_ERROR then
1722: RAISE FND_API.G_EXC_ERROR;
1723: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

1729: COMMIT WORK;
1730: END IF;
1731: -- Debug Message
1732: IF g_debug THEN
1733: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
1734: END IF;
1735: -- Standard call to get message count and if count is 1, get message info.
1736: FND_MSG_PUB.Count_And_Get
1737: (p_count => x_msg_count,

Line 1741: WHEN OZF_Utility_PVT.resource_locked THEN

1737: (p_count => x_msg_count,
1738: p_data => x_msg_data
1739: );
1740: EXCEPTION
1741: WHEN OZF_Utility_PVT.resource_locked THEN
1742: ROLLBACK TO Update_Claim_Line_Tbl;
1743: x_return_status := FND_API.g_ret_sts_error;
1744: FND_MSG_PUB.Count_And_Get (
1745: p_encoded => FND_API.G_FALSE,

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

1745: p_encoded => FND_API.G_FALSE,
1746: p_count => x_msg_count,
1747: p_data => x_msg_data
1748: );
1749: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1750: WHEN FND_API.G_EXC_ERROR THEN
1751: ROLLBACK TO Update_Claim_Line_Tbl;
1752: x_return_status := FND_API.G_RET_STS_ERROR;
1753: -- Standard call to get message count and if count=1, get the message

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

1829: FND_MSG_PUB.initialize;
1830: END IF;
1831: -- Debug Message
1832: IF g_debug THEN
1833: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
1834: END IF;
1835: -- Initialize API return status to SUCCESS
1836: x_return_status := FND_API.G_RET_STS_SUCCESS;
1837: --

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

1848: x_msg_data => x_msg_data
1849: );
1850: --
1851: IF g_debug THEN
1852: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR DELETE_CLAIM =>'||X_RETURN_STATUS);
1853: END IF;
1854: -- Check return status from the above procedure call
1855: --
1856: -- Standard check for p_commit

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

1859: COMMIT WORK;
1860: END IF;
1861: -- Debug Message
1862: IF g_debug THEN
1863: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
1864: END IF;
1865: -- Standard call to get message count and if count is 1, get message info.
1866: FND_MSG_PUB.Count_And_Get
1867: (p_count => x_msg_count,

Line 1871: WHEN OZF_Utility_PVT.resource_locked THEN

1867: (p_count => x_msg_count,
1868: p_data => x_msg_data
1869: );
1870: EXCEPTION
1871: WHEN OZF_Utility_PVT.resource_locked THEN
1872: ROLLBACK TO DELETE_Claim_PUB;
1873: x_return_status := FND_API.g_ret_sts_error;
1874: FND_MSG_PUB.Count_And_Get (
1875: p_encoded => FND_API.G_FALSE,

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

1875: p_encoded => FND_API.G_FALSE,
1876: p_count => x_msg_count,
1877: p_data => x_msg_data
1878: );
1879: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1880: WHEN FND_API.G_EXC_ERROR THEN
1881: ROLLBACK TO DELETE_Claim_PUB;
1882: x_return_status := FND_API.G_RET_STS_ERROR;
1883: -- Standard call to get message count and if count=1, get the message

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

1960: FND_MSG_PUB.initialize;
1961: END IF;
1962: -- Debug Message
1963: IF g_debug THEN
1964: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
1965: END IF;
1966: -- Initialize API return status to SUCCESS
1967: x_return_status := FND_API.G_RET_STS_SUCCESS;
1968: --

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

1988: ,p_claim_line_tbl => l_pvt_claim_line_tbl
1989: ,p_change_object_version => FND_API.g_false
1990: ,x_error_index => l_error_index);
1991: IF g_debug THEN
1992: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR DELETE_CLAIM_Line_Tbl =>'||X_RETURN_STATUS);
1993: END IF;
1994: -- Check return status from the above procedure call
1995: IF x_return_status = FND_API.G_RET_STS_ERROR then
1996: RAISE FND_API.G_EXC_ERROR;

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

2006: COMMIT WORK;
2007: END IF;
2008: -- Debug Message
2009: IF g_debug THEN
2010: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
2011: END IF;
2012: -- Standard call to get message count and if count is 1, get message info.
2013: FND_MSG_PUB.Count_And_Get
2014: (p_count => x_msg_count,

Line 2018: WHEN OZF_Utility_PVT.resource_locked THEN

2014: (p_count => x_msg_count,
2015: p_data => x_msg_data
2016: );
2017: EXCEPTION
2018: WHEN OZF_Utility_PVT.resource_locked THEN
2019: ROLLBACK TO DELETE_Claim_Line_PUB;
2020: x_return_status := FND_API.G_RET_STS_ERROR;
2021: -- Standard call to get message count and if count=1, get the message
2022: FND_MSG_PUB.Count_And_Get (

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

2023: p_encoded => FND_API.G_FALSE,
2024: p_count => x_msg_count,
2025: p_data => x_msg_data
2026: );
2027: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
2028: WHEN FND_API.G_EXC_ERROR THEN
2029: ROLLBACK TO DELETE_Claim_Line_PUB;
2030: x_return_status := FND_API.G_RET_STS_ERROR;
2031: -- Standard call to get message count and if count=1, get the message

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

2102: -- Standard Start of API savepoint
2103: SAVEPOINT Asso_Accruals_To_Claim;
2104:
2105: IF G_DEBUG THEN
2106: OZF_Utility_PVT.debug_message(l_full_name||': start');
2107: END IF;
2108:
2109: -- Standard call to check for call compatibility.
2110: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

2181: COMMIT WORK;
2182: END IF;
2183:
2184: IF G_DEBUG THEN
2185: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2186: END IF;
2187:
2188: -- Standard call to get message count and if count is 1, get message info.
2189: FND_MSG_PUB.Count_And_Get(

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

2266: -- Standard Start of API savepoint
2267: SAVEPOINT Asso_Accruals_To_Claim_Line;
2268:
2269: IF G_DEBUG THEN
2270: OZF_Utility_PVT.debug_message(l_full_name||': start');
2271: END IF;
2272:
2273: -- Standard call to check for call compatibility.
2274: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

2313: COMMIT WORK;
2314: END IF;
2315:
2316: IF G_DEBUG THEN
2317: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2318: END IF;
2319:
2320: -- Standard call to get message count and if count is 1, get message info.
2321: FND_MSG_PUB.Count_And_Get(

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

2405: -- Standard Start of API savepoint
2406: SAVEPOINT Create_Claim_For_Accruals;
2407:
2408: IF G_DEBUG THEN
2409: OZF_Utility_PVT.debug_message(l_full_name||': start');
2410: END IF;
2411:
2412: -- Standard call to check for call compatibility.
2413: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 2529: OZF_Utility_PVT.debug_message(l_claim_rec.claim_number||': In Public l_claim_rec.claim_number');

2525: ------------------------------------------
2526: -- 2. Call OZF_CLAIM_ACCRUAL_PVT
2527: ------------------------------------------
2528: IF G_DEBUG THEN
2529: OZF_Utility_PVT.debug_message(l_claim_rec.claim_number||': In Public l_claim_rec.claim_number');
2530: END IF;
2531:
2532: OZF_Claim_Accrual_PVT.Create_Claim_For_Accruals(
2533: p_api_version => l_api_version

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

2555: COMMIT WORK;
2556: END IF;
2557:
2558: IF G_DEBUG THEN
2559: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2560: END IF;
2561:
2562: -- Standard call to get message count and if count is 1, get message info.
2563: FND_MSG_PUB.Count_And_Get(

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

2647: -- Standard Start of API savepoint
2648: SAVEPOINT Pay_Claim_For_Accruals;
2649:
2650: IF G_DEBUG THEN
2651: OZF_Utility_PVT.debug_message(l_full_name||': start');
2652: END IF;
2653:
2654: -- Standard call to check for call compatibility.
2655: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

2792: COMMIT WORK;
2793: END IF;
2794:
2795: IF G_DEBUG THEN
2796: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2797: END IF;
2798:
2799: -- Standard call to get message count and if count is 1, get message info.
2800: FND_MSG_PUB.Count_And_Get(

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

2928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2929: END IF;
2930:
2931: IF G_DEBUG THEN
2932: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' start');
2933: END IF;
2934:
2935: -- Initialize message list if p_init_msg_list is set to TRUE.
2936:

Line 3052: OZF_UTILITY_PVT.debug_message('Claim line ID :'|| px_child_claim_tbl(i).claim_line_id_tbl(j).claim_line_id);

3048: FETCH claim_lines_cur INTO l_claim_line_id,l_amount;
3049: CLOSE claim_lines_cur;
3050:
3051: IF G_DEBUG THEN
3052: OZF_UTILITY_PVT.debug_message('Claim line ID :'|| px_child_claim_tbl(i).claim_line_id_tbl(j).claim_line_id);
3053: OZF_UTILITY_PVT.debug_message('l_claim_line_id :'||l_claim_line_id);
3054: OZF_UTILITY_PVT.debug_message('l_amount :'|| l_amount);
3055: END IF;
3056:

Line 3053: OZF_UTILITY_PVT.debug_message('l_claim_line_id :'||l_claim_line_id);

3049: CLOSE claim_lines_cur;
3050:
3051: IF G_DEBUG THEN
3052: OZF_UTILITY_PVT.debug_message('Claim line ID :'|| px_child_claim_tbl(i).claim_line_id_tbl(j).claim_line_id);
3053: OZF_UTILITY_PVT.debug_message('l_claim_line_id :'||l_claim_line_id);
3054: OZF_UTILITY_PVT.debug_message('l_amount :'|| l_amount);
3055: END IF;
3056:
3057: IF l_claim_line_id IS NULL THEN

Line 3054: OZF_UTILITY_PVT.debug_message('l_amount :'|| l_amount);

3050:
3051: IF G_DEBUG THEN
3052: OZF_UTILITY_PVT.debug_message('Claim line ID :'|| px_child_claim_tbl(i).claim_line_id_tbl(j).claim_line_id);
3053: OZF_UTILITY_PVT.debug_message('l_claim_line_id :'||l_claim_line_id);
3054: OZF_UTILITY_PVT.debug_message('l_amount :'|| l_amount);
3055: END IF;
3056:
3057: IF l_claim_line_id IS NULL THEN
3058: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

Line 3127: OZF_UTILITY_PVT.debug_message('Public API: '|| l_api_name||' End');

3123:
3124: --========================================================================
3125: --// Commit the process
3126: IF G_DEBUG THEN
3127: OZF_UTILITY_PVT.debug_message('Public API: '|| l_api_name||' End');
3128: END IF;
3129:
3130: IF FND_API.to_Boolean( p_commit ) THEN
3131: COMMIT WORK;

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

3300: END IF;
3301:
3302: -- Debug Message
3303: IF G_DEBUG THEN
3304: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' start');
3305: END IF;
3306:
3307: -- Initialize API return status to SUCCESS
3308: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3313: OZF_UTILITY_PVT.debug_message('--------- Create_Event ----------');

3309:
3310: --//API Body
3311: --========================================================================
3312: IF G_DEBUG THEN
3313: OZF_UTILITY_PVT.debug_message('--------- Create_Event ----------');
3314: OZF_UTILITY_PVT.debug_message('event_type_code : '||p_event_type_code);
3315: OZF_UTILITY_PVT.debug_message('Claim ID : '||p_claim_id);
3316: OZF_UTILITY_PVT.debug_message('Reversal Flag : '||p_reversal_flag);
3317: END IF;

Line 3314: OZF_UTILITY_PVT.debug_message('event_type_code : '||p_event_type_code);

3310: --//API Body
3311: --========================================================================
3312: IF G_DEBUG THEN
3313: OZF_UTILITY_PVT.debug_message('--------- Create_Event ----------');
3314: OZF_UTILITY_PVT.debug_message('event_type_code : '||p_event_type_code);
3315: OZF_UTILITY_PVT.debug_message('Claim ID : '||p_claim_id);
3316: OZF_UTILITY_PVT.debug_message('Reversal Flag : '||p_reversal_flag);
3317: END IF;
3318:

Line 3315: OZF_UTILITY_PVT.debug_message('Claim ID : '||p_claim_id);

3311: --========================================================================
3312: IF G_DEBUG THEN
3313: OZF_UTILITY_PVT.debug_message('--------- Create_Event ----------');
3314: OZF_UTILITY_PVT.debug_message('event_type_code : '||p_event_type_code);
3315: OZF_UTILITY_PVT.debug_message('Claim ID : '||p_claim_id);
3316: OZF_UTILITY_PVT.debug_message('Reversal Flag : '||p_reversal_flag);
3317: END IF;
3318:
3319: --//Validations

Line 3316: OZF_UTILITY_PVT.debug_message('Reversal Flag : '||p_reversal_flag);

3312: IF G_DEBUG THEN
3313: OZF_UTILITY_PVT.debug_message('--------- Create_Event ----------');
3314: OZF_UTILITY_PVT.debug_message('event_type_code : '||p_event_type_code);
3315: OZF_UTILITY_PVT.debug_message('Claim ID : '||p_claim_id);
3316: OZF_UTILITY_PVT.debug_message('Reversal Flag : '||p_reversal_flag);
3317: END IF;
3318:
3319: --//Validations
3320: --//Validate event_type_code passed

Line 3326: OZF_UTILITY_PVT.debug_message('l_claim_id : '||l_claim_id);

3322: FETCH csr_claim_info INTO l_claim_id,l_status_code,l_settlement_method;
3323: CLOSE csr_claim_info;
3324:
3325: IF G_DEBUG THEN
3326: OZF_UTILITY_PVT.debug_message('l_claim_id : '||l_claim_id);
3327: OZF_UTILITY_PVT.debug_message('l_status_code : '||l_status_code);
3328: OZF_UTILITY_PVT.debug_message('l_settlement_method : '||l_settlement_method);
3329: END IF;
3330:

Line 3327: OZF_UTILITY_PVT.debug_message('l_status_code : '||l_status_code);

3323: CLOSE csr_claim_info;
3324:
3325: IF G_DEBUG THEN
3326: OZF_UTILITY_PVT.debug_message('l_claim_id : '||l_claim_id);
3327: OZF_UTILITY_PVT.debug_message('l_status_code : '||l_status_code);
3328: OZF_UTILITY_PVT.debug_message('l_settlement_method : '||l_settlement_method);
3329: END IF;
3330:
3331: IF l_claim_id IS NULL THEN

Line 3328: OZF_UTILITY_PVT.debug_message('l_settlement_method : '||l_settlement_method);

3324:
3325: IF G_DEBUG THEN
3326: OZF_UTILITY_PVT.debug_message('l_claim_id : '||l_claim_id);
3327: OZF_UTILITY_PVT.debug_message('l_status_code : '||l_status_code);
3328: OZF_UTILITY_PVT.debug_message('l_settlement_method : '||l_settlement_method);
3329: END IF;
3330:
3331: IF l_claim_id IS NULL THEN
3332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 3375: OZF_UTILITY_PVT.debug_message('l_settle_method_match FALSE');

3371: END IF;
3372: x_return_status := fnd_api.g_ret_sts_error;
3373: RETURN;
3374: IF G_DEBUG THEN
3375: OZF_UTILITY_PVT.debug_message('l_settle_method_match FALSE');
3376: END IF;
3377: END IF;
3378:
3379: l_settle_method_match := TRUE;

Line 3428: OZF_UTILITY_PVT.debug_message('Post to GL is enabled');

3424: CLOSE claim_gl_posting_csr;
3425:
3426: IF l_post_to_gl = 'T' THEN
3427: IF G_DEBUG THEN
3428: OZF_UTILITY_PVT.debug_message('Post to GL is enabled');
3429: END IF;
3430: ELSE
3431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3432: FND_MESSAGE.set_name('OZF', 'OZF_BAD_POST_TO_GL');

Line 3530: OZF_UTILITY_PVT.debug_message('l_claim_event_tbl.COUNT :'|| l_claim_event_tbl.COUNT);

3526: CLOSE csr_claim_dup_chk;
3527:
3528: IF l_claim_event_tbl.COUNT <> 0 THEN
3529: IF G_DEBUG THEN
3530: OZF_UTILITY_PVT.debug_message('l_claim_event_tbl.COUNT :'|| l_claim_event_tbl.COUNT);
3531: END IF;
3532:
3533: IF l_claim_event_tbl.COUNT = 1 AND NVL(p_reversal_flag,'N') <> 'Y' THEN
3534:

Line 3602: OZF_UTILITY_PVT.debug_message('Public API: '|| l_api_name||' End');

3598: --========================================================================
3599: --// Commit the process
3600: IF G_DEBUG THEN
3601:
3602: OZF_UTILITY_PVT.debug_message('Public API: '|| l_api_name||' End');
3603: END IF;
3604: IF FND_API.to_Boolean( p_commit )
3605: THEN
3606: COMMIT WORK;