APPS.OZF_CLAIM_GRP dependencies on FND_MSG_PUB

Line 13: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

9:
10: G_PKG_NAME CONSTANT VARCHAR2(20) := 'OZF_CLAIM_GRP';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfgclab.pls';
12:
13: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
14: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
15:
16: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
17:

Line 14: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);

10: G_PKG_NAME CONSTANT VARCHAR2(20) := 'OZF_CLAIM_GRP';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfgclab.pls';
12:
13: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
14: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
15:
16: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
17:
18: G_DEDUCTION_CLASS CONSTANT VARCHAR2(20) := 'DEDUCTION';

Line 335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 343: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: -- Standard call to get message count and if count=1, get the message
343: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
344: ,p_count => x_msg_count
345: ,p_data => x_msg_data
346: );
347:

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

346: );
347:
348: WHEN OTHERS THEN
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
351: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
352: FND_MSG_PUB.add;
353: END IF;
354: -- Standard call to get message count and if count=1, get the message

Line 352: FND_MSG_PUB.add;

348: WHEN OTHERS THEN
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
351: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
352: FND_MSG_PUB.add;
353: END IF;
354: -- Standard call to get message count and if count=1, get the message
355: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
356: ,p_count => x_msg_count

Line 355: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

351: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
352: FND_MSG_PUB.add;
353: END IF;
354: -- Standard call to get message count and if count=1, get the message
355: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
356: ,p_count => x_msg_count
357: ,p_data => x_msg_data
358: );
359: END update_parent_amounts;

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

422:
423: EXCEPTION
424: WHEN OTHERS THEN
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
427: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
428: FND_MSG_PUB.add;
429: END IF;
430: -- Standard call to get message count and if count=1, get the message

Line 428: FND_MSG_PUB.add;

424: WHEN OTHERS THEN
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
427: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
428: FND_MSG_PUB.add;
429: END IF;
430: -- Standard call to get message count and if count=1, get the message
431: FND_MSG_PUB.Count_And_Get (
432: p_encoded => FND_API.G_FALSE,

Line 431: FND_MSG_PUB.Count_And_Get (

427: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
428: FND_MSG_PUB.add;
429: END IF;
430: -- Standard call to get message count and if count=1, get the message
431: FND_MSG_PUB.Count_And_Get (
432: p_encoded => FND_API.G_FALSE,
433: p_count => x_msg_count,
434: p_data => x_msg_data
435: );

Line 544: FND_MSG_PUB.initialize;

540: END IF;
541:
542: -- Initialize message list if p_init_msg_list is set to TRUE.
543: IF FND_API.to_Boolean( p_init_msg_list ) THEN
544: FND_MSG_PUB.initialize;
545: END IF;
546:
547: -- Initialize API return status to SUCCESS
548: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 656: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

652: IF l_deduction_rec.cust_account_id IS NULL OR
653: l_deduction_rec.receipt_id IS NULL OR
654: l_deduction_rec.currency_code IS NULL OR
655: l_deduction_rec.amount IS NULL THEN
656: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
657: FND_MESSAGE.Set_Name('OZF','OZF_REQUIRED_FIELDS_MISSING');
658: FND_MSG_PUB.Add;
659: END IF;
660: RAISE FND_API.g_exc_error;

Line 658: FND_MSG_PUB.Add;

654: l_deduction_rec.currency_code IS NULL OR
655: l_deduction_rec.amount IS NULL THEN
656: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
657: FND_MESSAGE.Set_Name('OZF','OZF_REQUIRED_FIELDS_MISSING');
658: FND_MSG_PUB.Add;
659: END IF;
660: RAISE FND_API.g_exc_error;
661: ELSIF l_deduction_rec.source_object_id IS NOT NULL AND
662: l_deduction_rec.source_object_type_id IS NULL THEN

Line 664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

660: RAISE FND_API.g_exc_error;
661: ELSIF l_deduction_rec.source_object_id IS NOT NULL AND
662: l_deduction_rec.source_object_type_id IS NULL THEN
663: -- source_object_type_id is required for transaction-related deduction.
664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
665: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_SRC_INFO_MISSING');
666: FND_MSG_PUB.add;
667: END IF;
668: RAISE FND_API.g_exc_error;

Line 666: FND_MSG_PUB.add;

662: l_deduction_rec.source_object_type_id IS NULL THEN
663: -- source_object_type_id is required for transaction-related deduction.
664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
665: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_SRC_INFO_MISSING');
666: FND_MSG_PUB.add;
667: END IF;
668: RAISE FND_API.g_exc_error;
669: END IF;
670:

Line 877: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

873: COMMIT WORK;
874: END IF;
875:
876: -- Debug Message
877: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
878: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
879: FND_MESSAGE.Set_Token('TEXT',l_full_name||'End');
880: FND_MSG_PUB.Add;
881: END IF;

Line 880: FND_MSG_PUB.Add;

876: -- Debug Message
877: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
878: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
879: FND_MESSAGE.Set_Token('TEXT',l_full_name||'End');
880: FND_MSG_PUB.Add;
881: END IF;
882:
883: -- Standard call to get message count and if count is 1, get message info.
884: FND_MSG_PUB.Count_And_Get(

Line 884: FND_MSG_PUB.Count_And_Get(

880: FND_MSG_PUB.Add;
881: END IF;
882:
883: -- Standard call to get message count and if count is 1, get message info.
884: FND_MSG_PUB.Count_And_Get(
885: p_count => x_msg_count,
886: p_data => x_msg_data
887: );
888:

Line 893: FND_MSG_PUB.Count_And_Get (

889: EXCEPTION
890: WHEN FND_API.G_EXC_ERROR THEN
891: ROLLBACK TO CREATE_CLAIM_GRP;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893: FND_MSG_PUB.Count_And_Get (
894: p_encoded => FND_API.G_FALSE,
895: p_count => x_msg_count,
896: p_data => x_msg_data
897: );

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

898:
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900: ROLLBACK TO CREATE_CLAIM_GRP;
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
903: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
904: FND_MSG_PUB.add;
905: END IF;
906: FND_MSG_PUB.Count_And_Get (

Line 904: FND_MSG_PUB.add;

900: ROLLBACK TO CREATE_CLAIM_GRP;
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
903: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
904: FND_MSG_PUB.add;
905: END IF;
906: FND_MSG_PUB.Count_And_Get (
907: p_encoded => FND_API.G_FALSE,
908: p_count => x_msg_count,

Line 906: FND_MSG_PUB.Count_And_Get (

902: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
903: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
904: FND_MSG_PUB.add;
905: END IF;
906: FND_MSG_PUB.Count_And_Get (
907: p_encoded => FND_API.G_FALSE,
908: p_count => x_msg_count,
909: p_data => x_msg_data
910: );

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

911:
912: WHEN OTHERS THEN
913: ROLLBACK TO CREATE_CLAIM_GRP;
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
916: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
917: FND_MSG_PUB.add;
918: END IF;
919: FND_MSG_PUB.Count_And_Get (

Line 917: FND_MSG_PUB.add;

913: ROLLBACK TO CREATE_CLAIM_GRP;
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
916: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
917: FND_MSG_PUB.add;
918: END IF;
919: FND_MSG_PUB.Count_And_Get (
920: p_encoded => FND_API.G_FALSE,
921: p_count => x_msg_count,

Line 919: FND_MSG_PUB.Count_And_Get (

915: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
916: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
917: FND_MSG_PUB.add;
918: END IF;
919: FND_MSG_PUB.Count_And_Get (
920: p_encoded => FND_API.G_FALSE,
921: p_count => x_msg_count,
922: p_data => x_msg_data
923: );

Line 1156: FND_MSG_PUB.add;

1152: WHEN OTHERS THEN
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1154: FND_MESSAGE.set_name('OZF', 'OZF_API_DEBUG_MESSAGE');
1155: FND_MESSAGE.set_token('TEXT', l_full_name||'An error happened in '||l_full_name);
1156: FND_MSG_PUB.add;
1157:
1158: END Check_Update_Allowed;
1159:
1160:

Line 1337: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1333: IF l_split_flag = 'NO' THEN
1334:
1335: IF l_status_code <> 'CLOSED' THEN
1336: IF l_status_code = 'PENDING_CLOSE' THEN
1337: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1338: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_STATUS_PENDING_CLOSE');
1339: FND_MSG_PUB.add;
1340: END IF;
1341: RAISE FND_API.G_EXC_ERROR;

Line 1339: FND_MSG_PUB.add;

1335: IF l_status_code <> 'CLOSED' THEN
1336: IF l_status_code = 'PENDING_CLOSE' THEN
1337: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1338: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_STATUS_PENDING_CLOSE');
1339: FND_MSG_PUB.add;
1340: END IF;
1341: RAISE FND_API.G_EXC_ERROR;
1342: END IF;
1343:

Line 1526: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1522: ELSIF l_split_flag = 'YES' THEN
1523:
1524: FOR ref_split_claim_csr in split_claim_csr(l_deduction_rec.claim_id) LOOP
1525: IF ref_split_claim_csr.status_code = 'PENDING_CLOSE' THEN
1526: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1527: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_STATUS_PENDING_CLOSE');
1528: FND_MSG_PUB.add;
1529: END IF;
1530: RAISE FND_API.G_EXC_ERROR;

Line 1528: FND_MSG_PUB.add;

1524: FOR ref_split_claim_csr in split_claim_csr(l_deduction_rec.claim_id) LOOP
1525: IF ref_split_claim_csr.status_code = 'PENDING_CLOSE' THEN
1526: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1527: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_STATUS_PENDING_CLOSE');
1528: FND_MSG_PUB.add;
1529: END IF;
1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532: END LOOP;

Line 1778: FND_MSG_PUB.count_and_get(

1774:
1775: END IF; --IF l_split_flag = 'YES' THEN
1776:
1777:
1778: FND_MSG_PUB.count_and_get(
1779: p_encoded => FND_API.g_false,
1780: p_count => x_msg_count,
1781: p_data => x_msg_data
1782: );

Line 1791: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1787: EXCEPTION
1788: WHEN FND_API.G_EXC_ERROR THEN
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: -- Standard call to get message count and if count=1, get the message
1791: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1792: ,p_count => x_msg_count
1793: ,p_data => x_msg_data
1794: );
1795:

Line 1799: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1795:
1796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1798: -- Standard call to get message count and if count=1, get the message
1799: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1800: ,p_count => x_msg_count
1801: ,p_data => x_msg_data
1802: );
1803:

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

1802: );
1803:
1804: WHEN OTHERS THEN
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1807: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
1808: FND_MSG_PUB.add;
1809: END IF;
1810: -- Standard call to get message count and if count=1, get the message

Line 1808: FND_MSG_PUB.add;

1804: WHEN OTHERS THEN
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1807: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
1808: FND_MSG_PUB.add;
1809: END IF;
1810: -- Standard call to get message count and if count=1, get the message
1811: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1812: ,p_count => x_msg_count

Line 1811: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1807: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
1808: FND_MSG_PUB.add;
1809: END IF;
1810: -- Standard call to get message count and if count=1, get the message
1811: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1812: ,p_count => x_msg_count
1813: ,p_data => x_msg_data
1814: );
1815:

Line 2048: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2044: END IF;
2045: END IF;
2046:
2047: IF l_status_code = 'PENDING_CLOSE' THEN
2048: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2049: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_STATUS_PENDING_CLOSE');
2050: FND_MSG_PUB.add;
2051: END IF;
2052: RAISE FND_API.G_EXC_ERROR;

Line 2050: FND_MSG_PUB.add;

2046:
2047: IF l_status_code = 'PENDING_CLOSE' THEN
2048: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2049: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_STATUS_PENDING_CLOSE');
2050: FND_MSG_PUB.add;
2051: END IF;
2052: RAISE FND_API.G_EXC_ERROR;
2053: END IF;
2054:

Line 2251: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2247: Write_Log(l_full_name, 'Update Allowed ? ' || l_update_allowed_flag );
2248:
2249: IF l_update_allowed_flag = 'N' THEN
2250:
2251: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2252: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_STATUS_PENDING_CLOSE');
2253: FND_MSG_PUB.add;
2254: END IF;
2255: RAISE FND_API.G_EXC_ERROR;

Line 2253: FND_MSG_PUB.add;

2249: IF l_update_allowed_flag = 'N' THEN
2250:
2251: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2252: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_STATUS_PENDING_CLOSE');
2253: FND_MSG_PUB.add;
2254: END IF;
2255: RAISE FND_API.G_EXC_ERROR;
2256: END IF;
2257:

Line 2464: FND_MSG_PUB.Count_And_Get

2460: END LOOP;
2461: END IF; --IF l_split_flag = 'YES' THEN
2462:
2463: -- Standard call to get message count and if count is 1, get message info.
2464: FND_MSG_PUB.Count_And_Get
2465: (p_count => x_msg_count,
2466: p_data => x_msg_data
2467: );
2468:

Line 2475: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 2483: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

2479:
2480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2482: -- Standard call to get message count and if count=1, get the message
2483: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2484: ,p_count => x_msg_count
2485: ,p_data => x_msg_data
2486: );
2487: WHEN OTHERS THEN

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

2485: ,p_data => x_msg_data
2486: );
2487: WHEN OTHERS THEN
2488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2489: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2490: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
2491: FND_MSG_PUB.add;
2492: END IF;
2493: -- Standard call to get message count and if count=1, get the message

Line 2491: FND_MSG_PUB.add;

2487: WHEN OTHERS THEN
2488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2489: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2490: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
2491: FND_MSG_PUB.add;
2492: END IF;
2493: -- Standard call to get message count and if count=1, get the message
2494: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2495: ,p_count => x_msg_count

Line 2494: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

2490: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
2491: FND_MSG_PUB.add;
2492: END IF;
2493: -- Standard call to get message count and if count=1, get the message
2494: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2495: ,p_count => x_msg_count
2496: ,p_data => x_msg_data
2497: );
2498:

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

2563:
2564: EXCEPTION
2565: WHEN OTHERS THEN
2566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2567: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2568: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
2569: FND_MSG_PUB.add;
2570: END IF;
2571: FND_MSG_PUB.Count_And_Get (

Line 2569: FND_MSG_PUB.add;

2565: WHEN OTHERS THEN
2566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2567: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2568: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
2569: FND_MSG_PUB.add;
2570: END IF;
2571: FND_MSG_PUB.Count_And_Get (
2572: p_encoded => FND_API.G_FALSE,
2573: p_count => x_msg_count,

Line 2571: FND_MSG_PUB.Count_And_Get (

2567: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2568: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
2569: FND_MSG_PUB.add;
2570: END IF;
2571: FND_MSG_PUB.Count_And_Get (
2572: p_encoded => FND_API.G_FALSE,
2573: p_count => x_msg_count,
2574: p_data => x_msg_data
2575: );

Line 2742: FND_MSG_PUB.initialize;

2738: END IF;
2739:
2740: -- Initialize message list if p_init_msg_list is set to TRUE.
2741: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2742: FND_MSG_PUB.initialize;
2743: END IF;
2744:
2745: -- Initialize API return status to SUCCESS
2746: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2754: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2750: -----------------------------------------
2751: -- "claim_id" or "source_object_id" is required field for updat_deduction
2752: IF l_deduction_rec.claim_id IS NULL AND
2753: l_deduction_rec.source_object_id IS NULL THEN
2754: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2755: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INSUFFICIENT_VAL');
2756: FND_MSG_PUB.add;
2757: END IF;
2758: RAISE FND_API.G_EXC_ERROR;

Line 2756: FND_MSG_PUB.add;

2752: IF l_deduction_rec.claim_id IS NULL AND
2753: l_deduction_rec.source_object_id IS NULL THEN
2754: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2755: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INSUFFICIENT_VAL');
2756: FND_MSG_PUB.add;
2757: END IF;
2758: RAISE FND_API.G_EXC_ERROR;
2759: END IF;
2760:

Line 2763: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2759: END IF;
2760:
2761: IF l_deduction_rec.applied_action_type IS NULL OR
2762: l_deduction_rec.applied_action_type NOT IN ('A','U') THEN
2763: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2764: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_ACTION');
2765: FND_MSG_PUB.add;
2766: END IF;
2767: RAISE FND_API.G_EXC_ERROR;

Line 2765: FND_MSG_PUB.add;

2761: IF l_deduction_rec.applied_action_type IS NULL OR
2762: l_deduction_rec.applied_action_type NOT IN ('A','U') THEN
2763: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2764: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_ACTION');
2765: FND_MSG_PUB.add;
2766: END IF;
2767: RAISE FND_API.G_EXC_ERROR;
2768: ELSE
2769: IF l_deduction_rec.applied_action_type = 'A' THEN

Line 2772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2768: ELSE
2769: IF l_deduction_rec.applied_action_type = 'A' THEN
2770: IF l_deduction_rec.amount IS NULL OR
2771: l_deduction_rec.receipt_id IS NULL THEN
2772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2773: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_INSUFFICIENT_VAL_A');
2774: FND_MSG_PUB.add;
2775: END IF;
2776: RAISE FND_API.G_EXC_ERROR;

Line 2774: FND_MSG_PUB.add;

2770: IF l_deduction_rec.amount IS NULL OR
2771: l_deduction_rec.receipt_id IS NULL THEN
2772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2773: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_INSUFFICIENT_VAL_A');
2774: FND_MSG_PUB.add;
2775: END IF;
2776: RAISE FND_API.G_EXC_ERROR;
2777: END IF;
2778: ELSIF l_deduction_rec.applied_action_type = 'U' THEN

Line 2782: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2778: ELSIF l_deduction_rec.applied_action_type = 'U' THEN
2779: IF l_deduction_rec.amount IS NULL OR
2780: l_deduction_rec.amount_applied IS NULL OR
2781: l_deduction_rec.applied_receipt_id IS NULL THEN
2782: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2783: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_INSUFFICIENT_VAL_U');
2784: FND_MSG_PUB.add;
2785: END IF;
2786: RAISE FND_API.G_EXC_ERROR;

Line 2784: FND_MSG_PUB.add;

2780: l_deduction_rec.amount_applied IS NULL OR
2781: l_deduction_rec.applied_receipt_id IS NULL THEN
2782: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2783: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_INSUFFICIENT_VAL_U');
2784: FND_MSG_PUB.add;
2785: END IF;
2786: RAISE FND_API.G_EXC_ERROR;
2787: END IF;
2788: END IF;

Line 2838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2834: ) OR
2835: (l_deduction_rec.amount IS NULL OR
2836: l_deduction_rec.amount = FND_API.G_MISS_NUM
2837: ) THEN
2838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2839: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INSUF_VAL_UPD');
2840: FND_MSG_PUB.add;
2841: END IF;
2842: RAISE FND_API.G_EXC_ERROR;

Line 2840: FND_MSG_PUB.add;

2836: l_deduction_rec.amount = FND_API.G_MISS_NUM
2837: ) THEN
2838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2839: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INSUF_VAL_UPD');
2840: FND_MSG_PUB.add;
2841: END IF;
2842: RAISE FND_API.G_EXC_ERROR;
2843: ELSE
2844: IF l_deduction_rec.applied_action_type = 'A' THEN

Line 2851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2847: ) OR
2848: (l_deduction_rec.applied_receipt_id IS NULL OR
2849: l_deduction_rec.applied_receipt_id = FND_API.G_MISS_NUM
2850: ) THEN
2851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2852: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INSUF_VAL_UPD');
2853: FND_MSG_PUB.add;
2854: END IF;
2855: RAISE FND_API.G_EXC_ERROR;

Line 2853: FND_MSG_PUB.add;

2849: l_deduction_rec.applied_receipt_id = FND_API.G_MISS_NUM
2850: ) THEN
2851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2852: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INSUF_VAL_UPD');
2853: FND_MSG_PUB.add;
2854: END IF;
2855: RAISE FND_API.G_EXC_ERROR;
2856: END IF;
2857: ELSIF l_deduction_rec.applied_action_type = 'U' THEN

Line 2864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2860: ) OR
2861: (l_deduction_rec.applied_receipt_id IS NULL OR
2862: l_deduction_rec.applied_receipt_id = FND_API.G_MISS_NUM
2863: ) THEN
2864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2865: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INSUF_VAL_UPD');
2866: FND_MSG_PUB.add;
2867: END IF;
2868: RAISE FND_API.G_EXC_ERROR;

Line 2866: FND_MSG_PUB.add;

2862: l_deduction_rec.applied_receipt_id = FND_API.G_MISS_NUM
2863: ) THEN
2864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2865: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INSUF_VAL_UPD');
2866: FND_MSG_PUB.add;
2867: END IF;
2868: RAISE FND_API.G_EXC_ERROR;
2869: END IF;
2870: ELSE

Line 2871: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2867: END IF;
2868: RAISE FND_API.G_EXC_ERROR;
2869: END IF;
2870: ELSE
2871: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2872: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_ACTION_UPD');
2873: FND_MSG_PUB.add;
2874: END IF;
2875: RAISE FND_API.G_EXC_ERROR;

Line 2873: FND_MSG_PUB.add;

2869: END IF;
2870: ELSE
2871: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2872: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_ACTION_UPD');
2873: FND_MSG_PUB.add;
2874: END IF;
2875: RAISE FND_API.G_EXC_ERROR;
2876: END IF;
2877: END IF;

Line 2997: FND_MSG_PUB.Count_And_Get(

2993: COMMIT WORK;
2994: END IF;
2995:
2996: -- Standard call to get message count and if count is 1, get message info.
2997: FND_MSG_PUB.Count_And_Get(
2998: p_count => x_msg_count,
2999: p_data => x_msg_data
3000: );
3001:

Line 3006: FND_MSG_PUB.Count_And_Get (

3002: EXCEPTION
3003: WHEN FND_API.G_EXC_ERROR THEN
3004: ROLLBACK TO UPDATE_CLAIM_GRP;
3005: x_return_status := FND_API.G_RET_STS_ERROR;
3006: FND_MSG_PUB.Count_And_Get (
3007: p_encoded => FND_API.G_FALSE,
3008: p_count => x_msg_count,
3009: p_data => x_msg_data
3010: );

Line 3015: FND_MSG_PUB.Count_And_Get (

3011:
3012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3013: ROLLBACK TO UPDATE_CLAIM_GRP;
3014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3015: FND_MSG_PUB.Count_And_Get (
3016: p_encoded => FND_API.G_FALSE,
3017: p_count => x_msg_count,
3018: p_data => x_msg_data
3019: );

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

3020:
3021: WHEN OTHERS THEN
3022: ROLLBACK TO UPDATE_claim_GRP;
3023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3024: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3025: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
3026: FND_MSG_PUB.add;
3027: END IF;
3028: FND_MSG_PUB.Count_And_Get (

Line 3026: FND_MSG_PUB.add;

3022: ROLLBACK TO UPDATE_claim_GRP;
3023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3024: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3025: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
3026: FND_MSG_PUB.add;
3027: END IF;
3028: FND_MSG_PUB.Count_And_Get (
3029: p_encoded => FND_API.G_FALSE,
3030: p_count => x_msg_count,

Line 3028: FND_MSG_PUB.Count_And_Get (

3024: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3025: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
3026: FND_MSG_PUB.add;
3027: END IF;
3028: FND_MSG_PUB.Count_And_Get (
3029: p_encoded => FND_API.G_FALSE,
3030: p_count => x_msg_count,
3031: p_data => x_msg_data
3032: );

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

3237: WHEN OTHERS THEN
3238: IF csr_get_claim_dtls%ISOPEN THEN
3239: CLOSE csr_get_claim_dtls;
3240: END IF;
3241: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3242: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3243: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3244: FND_MSG_PUB.Add;
3245: END IF;

Line 3244: FND_MSG_PUB.Add;

3240: END IF;
3241: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3242: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3243: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3244: FND_MSG_PUB.Add;
3245: END IF;
3246: x_application_ref_num := NULL;
3247: x_secondary_appl_ref_id := NULL;
3248: x_customer_reference := NULL;