APPS.OZF_CLAIM_PUB dependencies on FND_MSG_PUB

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

30: -- ===============================================================
31: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_CLAIM_PUB';
32: G_FILE_NAME CONSTANT VARCHAR2(14) := 'ozfpclab.pls';
33:
34: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
35:
36: ---------------------------------------------------------------------
37: -- PROCEDURE
38: -- create_claim

Line 103: FND_MSG_PUB.initialize;

99: END IF;
100: -- Initialize message list if p_init_msg_list is set to TRUE.
101: IF FND_API.to_Boolean( p_init_msg_list )
102: THEN
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');

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

309:
310: IF(l_item_uom IS NOT NULL) THEN
311: l_claim_line_tbl(i).QUANTITY_UOM := l_item_uom;
312: ELSE
313: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
314: FND_MESSAGE.set_name('OZF', 'OZF_METR_INVALID_UOM');
315: --//Unit of Measurement is Invalid
316: FND_MSG_PUB.add;
317: END IF;

Line 316: FND_MSG_PUB.add;

312: ELSE
313: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
314: FND_MESSAGE.set_name('OZF', 'OZF_METR_INVALID_UOM');
315: --//Unit of Measurement is Invalid
316: FND_MSG_PUB.add;
317: END IF;
318: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: RETURN;

Line 355: FND_MSG_PUB.Count_And_Get (

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,
358: p_data => x_msg_data
359: );

Line 365: FND_MSG_PUB.Count_And_Get (

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
369: );

Line 374: FND_MSG_PUB.Count_And_Get (

370: WHEN FND_API.G_EXC_ERROR THEN
371: ROLLBACK TO CREATE_Claim_PUB;
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: -- Standard call to get message count and if count=1, get the message
374: FND_MSG_PUB.Count_And_Get (
375: p_encoded => FND_API.G_FALSE,
376: p_count => x_msg_count,
377: p_data => x_msg_data
378: );

Line 383: FND_MSG_PUB.Count_And_Get (

379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO CREATE_Claim_PUB;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: -- Standard call to get message count and if count=1, get the message
383: FND_MSG_PUB.Count_And_Get (
384: p_encoded => FND_API.G_FALSE,
385: p_count => x_msg_count,
386: p_data => x_msg_data
387: );

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

387: );
388: WHEN OTHERS THEN
389: ROLLBACK TO CREATE_Claim_PUB;
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
392: THEN
393: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
394: END IF;
395: -- Standard call to get message count and if count=1, get the message

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

389: ROLLBACK TO CREATE_Claim_PUB;
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
392: THEN
393: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
394: END IF;
395: -- Standard call to get message count and if count=1, get the message
396: FND_MSG_PUB.Count_And_Get (
397: p_encoded => FND_API.G_FALSE,

Line 396: FND_MSG_PUB.Count_And_Get (

392: THEN
393: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
394: END IF;
395: -- Standard call to get message count and if count=1, get the message
396: FND_MSG_PUB.Count_And_Get (
397: p_encoded => FND_API.G_FALSE,
398: p_count => x_msg_count,
399: p_data => x_msg_data
400: );

Line 451: FND_MSG_PUB.initialize;

447: END IF;
448: -- Initialize message list if p_init_msg_list is set to TRUE.
449: IF FND_API.to_Boolean( p_init_msg_list )
450: THEN
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');

Line 583: FND_MSG_PUB.Count_And_Get

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,
585: p_data => x_msg_data
586: );
587: EXCEPTION

Line 592: FND_MSG_PUB.Count_And_Get (

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
596: );

Line 601: FND_MSG_PUB.Count_And_Get (

597: WHEN FND_API.G_EXC_ERROR THEN
598: ROLLBACK TO Create_Claim_Line_Tbl;
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: -- Standard call to get message count and if count=1, get the message
601: FND_MSG_PUB.Count_And_Get (
602: p_encoded => FND_API.G_FALSE,
603: p_count => x_msg_count,
604: p_data => x_msg_data
605: );

Line 610: FND_MSG_PUB.Count_And_Get (

606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: ROLLBACK TO Create_Claim_Line_Tbl;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: -- Standard call to get message count and if count=1, get the message
610: FND_MSG_PUB.Count_And_Get (
611: p_encoded => FND_API.G_FALSE,
612: p_count => x_msg_count,
613: p_data => x_msg_data
614: );

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

614: );
615: WHEN OTHERS THEN
616: ROLLBACK TO Create_Claim_Line_Tbl;
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
619: THEN
620: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
621: END IF;
622: -- Standard call to get message count and if count=1, get the message

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

616: ROLLBACK TO Create_Claim_Line_Tbl;
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
619: THEN
620: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
621: END IF;
622: -- Standard call to get message count and if count=1, get the message
623: FND_MSG_PUB.Count_And_Get (
624: p_encoded => FND_API.G_FALSE,

Line 623: FND_MSG_PUB.Count_And_Get (

619: THEN
620: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
621: END IF;
622: -- Standard call to get message count and if count=1, get the message
623: FND_MSG_PUB.Count_And_Get (
624: p_encoded => FND_API.G_FALSE,
625: p_count => x_msg_count,
626: p_data => x_msg_data
627: );

Line 706: FND_MSG_PUB.initialize;

702: END IF;
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.to_Boolean( p_init_msg_list )
705: THEN
706: FND_MSG_PUB.initialize;
707: END IF;
708:
709: -- Debug Message
710: IF g_debug THEN

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

896:
897: IF(l_item_uom IS NOT NULL) THEN
898: l_claim_line_tbl(i).QUANTITY_UOM := l_item_uom;
899: ELSE
900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
901: FND_MESSAGE.set_name('OZF', 'OZF_METR_INVALID_UOM');
902: --//Unit of Measurement is Invalid
903: FND_MSG_PUB.add;
904: END IF;

Line 903: FND_MSG_PUB.add;

899: ELSE
900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
901: FND_MESSAGE.set_name('OZF', 'OZF_METR_INVALID_UOM');
902: --//Unit of Measurement is Invalid
903: FND_MSG_PUB.add;
904: END IF;
905: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
907: RETURN;

Line 965: FND_MSG_PUB.Count_And_Get

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,
967: p_data => x_msg_data
968: );
969: EXCEPTION

Line 974: FND_MSG_PUB.Count_And_Get (

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
978: );

Line 983: FND_MSG_PUB.Count_And_Get (

979: WHEN FND_API.G_EXC_ERROR THEN
980: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
981: x_return_status := FND_API.G_RET_STS_ERROR;
982: -- Standard call to get message count and if count=1, get the message
983: FND_MSG_PUB.Count_And_Get (
984: p_encoded => FND_API.G_FALSE,
985: p_count => x_msg_count,
986: p_data => x_msg_data
987: );

Line 992: FND_MSG_PUB.Count_And_Get (

988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
989: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
991: -- Standard call to get message count and if count=1, get the message
992: FND_MSG_PUB.Count_And_Get (
993: p_encoded => FND_API.G_FALSE,
994: p_count => x_msg_count,
995: p_data => x_msg_data
996: );

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

996: );
997: WHEN OTHERS THEN
998: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1000: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1001: THEN
1002: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1003: END IF;
1004: -- Standard call to get message count and if count=1, get the message

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

998: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1000: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1001: THEN
1002: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1003: END IF;
1004: -- Standard call to get message count and if count=1, get the message
1005: FND_MSG_PUB.Count_And_Get (
1006: p_encoded => FND_API.G_FALSE,

Line 1005: FND_MSG_PUB.Count_And_Get (

1001: THEN
1002: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1003: END IF;
1004: -- Standard call to get message count and if count=1, get the message
1005: FND_MSG_PUB.Count_And_Get (
1006: p_encoded => FND_API.G_FALSE,
1007: p_count => x_msg_count,
1008: p_data => x_msg_data
1009: );

Line 1168: FND_MSG_PUB.initialize;

1164: END IF;
1165: -- Initialize message list if p_init_msg_list is set to TRUE.
1166: IF FND_API.to_Boolean( p_init_msg_list )
1167: THEN
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');

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

1466: ,p_lookup_type =>'OZF_CLAIM_LINE_ITEM_TYPE'
1467: ,p_lookup_code => l_claim_line_tbl(i).item_type);
1468:
1469: IF l_lookup_stat = FND_API.g_false THEN
1470: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1471: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_ITEM_TYPE');
1472: --//Item type provided is invalid, Please provide a valid item type.
1473: FND_MSG_PUB.add;
1474: END IF;

Line 1473: FND_MSG_PUB.add;

1469: IF l_lookup_stat = FND_API.g_false THEN
1470: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1471: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_ITEM_TYPE');
1472: --//Item type provided is invalid, Please provide a valid item type.
1473: FND_MSG_PUB.add;
1474: END IF;
1475: x_return_status := fnd_api.g_ret_sts_error;
1476: RETURN;
1477: END IF;

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

1486: FETCH c_inventory_item_id INTO l_item_id,l_pvt_claim_line_tbl(i).item_description;
1487: CLOSE c_inventory_item_id;
1488:
1489: IF l_item_id IS NULL THEN
1490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1491: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_INVENTORY_ITEM_ID');
1492: --//Inventory item identifier provided is Invalid.
1493: FND_MSG_PUB.add;
1494: END IF;

Line 1493: FND_MSG_PUB.add;

1489: IF l_item_id IS NULL THEN
1490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1491: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_INVENTORY_ITEM_ID');
1492: --//Inventory item identifier provided is Invalid.
1493: FND_MSG_PUB.add;
1494: END IF;
1495: x_return_status := fnd_api.g_ret_sts_error;
1496: RETURN;
1497: END IF;

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

1505:
1506: --//Fix for bug 13398807
1507: --IF l_pvt_claim_line_tbl(i).item_id IS NULL THEN
1508: IF l_item_id IS NULL THEN
1509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1510: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_CATEGORY_ID');
1511: --//Item Category identifier provided is Invalid.
1512: FND_MSG_PUB.add;
1513: END IF;

Line 1512: FND_MSG_PUB.add;

1508: IF l_item_id IS NULL THEN
1509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1510: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_CATEGORY_ID');
1511: --//Item Category identifier provided is Invalid.
1512: FND_MSG_PUB.add;
1513: END IF;
1514: x_return_status := fnd_api.g_ret_sts_error;
1515: RETURN;
1516: END IF;

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

1522: FETCH c_media_channel INTO l_item_id,l_pvt_claim_line_tbl(i).item_description;
1523: CLOSE c_media_channel;
1524:
1525: IF l_item_id IS NULL THEN
1526: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1527: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_MEDIA_CHANNEL_ID');
1528: --//Media channel identifier provided is Invalid.
1529: FND_MSG_PUB.add;
1530: END IF;

Line 1529: FND_MSG_PUB.add;

1525: IF l_item_id IS NULL THEN
1526: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1527: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_MEDIA_CHANNEL_ID');
1528: --//Media channel identifier provided is Invalid.
1529: FND_MSG_PUB.add;
1530: END IF;
1531: x_return_status := fnd_api.g_ret_sts_error;
1532: RETURN;
1533: END IF;

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

1539: FETCH c_memo_line INTO l_item_id,l_pvt_claim_line_tbl(i).item_description;
1540: CLOSE c_memo_line;
1541:
1542: IF l_item_id IS NULL THEN
1543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1544: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_MEMO_LINE_ID');
1545: --//Memo line identifier provided is Invalid.
1546: FND_MSG_PUB.add;
1547: END IF;

Line 1546: FND_MSG_PUB.add;

1542: IF l_item_id IS NULL THEN
1543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1544: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_MEMO_LINE_ID');
1545: --//Memo line identifier provided is Invalid.
1546: FND_MSG_PUB.add;
1547: END IF;
1548: x_return_status := fnd_api.g_ret_sts_error;
1549: RETURN;
1550: END IF;

Line 1736: FND_MSG_PUB.Count_And_Get

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,
1738: p_data => x_msg_data
1739: );
1740: EXCEPTION

Line 1744: FND_MSG_PUB.Count_And_Get (

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,
1746: p_count => x_msg_count,
1747: p_data => x_msg_data
1748: );

Line 1754: FND_MSG_PUB.Count_And_Get (

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
1754: FND_MSG_PUB.Count_And_Get (
1755: p_encoded => FND_API.G_FALSE,
1756: p_count => x_msg_count,
1757: p_data => x_msg_data
1758: );

Line 1763: FND_MSG_PUB.Count_And_Get (

1759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1760: ROLLBACK TO Update_Claim_Line_Tbl;
1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1762: -- Standard call to get message count and if count=1, get the message
1763: FND_MSG_PUB.Count_And_Get (
1764: p_encoded => FND_API.G_FALSE,
1765: p_count => x_msg_count,
1766: p_data => x_msg_data
1767: );

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

1767: );
1768: WHEN OTHERS THEN
1769: ROLLBACK TO Update_Claim_Line_Tbl;
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1771: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1772: THEN
1773: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1774: END IF;
1775: -- Standard call to get message count and if count=1, get the message

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

1769: ROLLBACK TO Update_Claim_Line_Tbl;
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1771: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1772: THEN
1773: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1774: END IF;
1775: -- Standard call to get message count and if count=1, get the message
1776: FND_MSG_PUB.Count_And_Get (
1777: p_encoded => FND_API.G_FALSE,

Line 1776: FND_MSG_PUB.Count_And_Get (

1772: THEN
1773: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1774: END IF;
1775: -- Standard call to get message count and if count=1, get the message
1776: FND_MSG_PUB.Count_And_Get (
1777: p_encoded => FND_API.G_FALSE,
1778: p_count => x_msg_count,
1779: p_data => x_msg_data
1780: );

Line 1829: FND_MSG_PUB.initialize;

1825: END IF;
1826: -- Initialize message list if p_init_msg_list is set to TRUE.
1827: IF FND_API.to_Boolean( p_init_msg_list )
1828: THEN
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');

Line 1866: FND_MSG_PUB.Count_And_Get

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,
1868: p_data => x_msg_data
1869: );
1870: EXCEPTION

Line 1874: FND_MSG_PUB.Count_And_Get (

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,
1876: p_count => x_msg_count,
1877: p_data => x_msg_data
1878: );

Line 1884: FND_MSG_PUB.Count_And_Get (

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
1884: FND_MSG_PUB.Count_And_Get (
1885: p_encoded => FND_API.G_FALSE,
1886: p_count => x_msg_count,
1887: p_data => x_msg_data
1888: );

Line 1893: FND_MSG_PUB.Count_And_Get (

1889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1890: ROLLBACK TO DELETE_Claim_PUB;
1891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1892: -- Standard call to get message count and if count=1, get the message
1893: FND_MSG_PUB.Count_And_Get (
1894: p_encoded => FND_API.G_FALSE,
1895: p_count => x_msg_count,
1896: p_data => x_msg_data
1897: );

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

1897: );
1898: WHEN OTHERS THEN
1899: ROLLBACK TO DELETE_Claim_PUB;
1900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1901: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1902: THEN
1903: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1904: END IF;
1905: -- Standard call to get message count and if count=1, get the message

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

1899: ROLLBACK TO DELETE_Claim_PUB;
1900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1901: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1902: THEN
1903: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1904: END IF;
1905: -- Standard call to get message count and if count=1, get the message
1906: FND_MSG_PUB.Count_And_Get (
1907: p_encoded => FND_API.G_FALSE,

Line 1906: FND_MSG_PUB.Count_And_Get (

1902: THEN
1903: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1904: END IF;
1905: -- Standard call to get message count and if count=1, get the message
1906: FND_MSG_PUB.Count_And_Get (
1907: p_encoded => FND_API.G_FALSE,
1908: p_count => x_msg_count,
1909: p_data => x_msg_data
1910: );

Line 1960: FND_MSG_PUB.initialize;

1956: END IF;
1957: -- Initialize message list if p_init_msg_list is set to TRUE.
1958: IF FND_API.to_Boolean( p_init_msg_list )
1959: THEN
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');

Line 2013: FND_MSG_PUB.Count_And_Get

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,
2015: p_data => x_msg_data
2016: );
2017: EXCEPTION

Line 2022: FND_MSG_PUB.Count_And_Get (

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 (
2023: p_encoded => FND_API.G_FALSE,
2024: p_count => x_msg_count,
2025: p_data => x_msg_data
2026: );

Line 2032: FND_MSG_PUB.Count_And_Get (

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
2032: FND_MSG_PUB.Count_And_Get (
2033: p_encoded => FND_API.G_FALSE,
2034: p_count => x_msg_count,
2035: p_data => x_msg_data
2036: );

Line 2041: FND_MSG_PUB.Count_And_Get (

2037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2038: ROLLBACK TO DELETE_Claim_Line_PUB;
2039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2040: -- Standard call to get message count and if count=1, get the message
2041: FND_MSG_PUB.Count_And_Get (
2042: p_encoded => FND_API.G_FALSE,
2043: p_count => x_msg_count,
2044: p_data => x_msg_data
2045: );

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

2045: );
2046: WHEN OTHERS THEN
2047: ROLLBACK TO DELETE_Claim_PUB;
2048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2049: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2050: THEN
2051: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2052: END IF;
2053: -- Standard call to get message count and if count=1, get the message

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

2047: ROLLBACK TO DELETE_Claim_PUB;
2048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2049: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2050: THEN
2051: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2052: END IF;
2053: -- Standard call to get message count and if count=1, get the message
2054: FND_MSG_PUB.Count_And_Get (
2055: p_encoded => FND_API.G_FALSE,

Line 2054: FND_MSG_PUB.Count_And_Get (

2050: THEN
2051: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2052: END IF;
2053: -- Standard call to get message count and if count=1, get the message
2054: FND_MSG_PUB.Count_And_Get (
2055: p_encoded => FND_API.G_FALSE,
2056: p_count => x_msg_count,
2057: p_data => x_msg_data
2058: );

Line 2119: FND_MSG_PUB.initialize;

2115: END IF;
2116:
2117: -- Initialize message list if p_init_msg_list is set to TRUE.
2118: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2119: FND_MSG_PUB.initialize;
2120: END IF;
2121:
2122: -- Initialize API return status to SUCCESS
2123: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2189: FND_MSG_PUB.Count_And_Get(

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(
2190: p_count => x_msg_count,
2191: p_data => x_msg_data
2192: );
2193:

Line 2198: FND_MSG_PUB.Count_And_Get (

2194: EXCEPTION
2195: WHEN FND_API.G_EXC_ERROR THEN
2196: ROLLBACK TO Asso_Accruals_To_Claim;
2197: x_return_status := FND_API.G_RET_STS_ERROR;
2198: FND_MSG_PUB.Count_And_Get (
2199: p_encoded => FND_API.G_FALSE,
2200: p_count => x_msg_count,
2201: p_data => x_msg_data
2202: );

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

2203:
2204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2205: ROLLBACK TO Asso_Accruals_To_Claim;
2206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2207: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2208: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2209: FND_MSG_PUB.add;
2210: END IF;
2211: FND_MSG_PUB.Count_And_Get (

Line 2209: FND_MSG_PUB.add;

2205: ROLLBACK TO Asso_Accruals_To_Claim;
2206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2207: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2208: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2209: FND_MSG_PUB.add;
2210: END IF;
2211: FND_MSG_PUB.Count_And_Get (
2212: p_encoded => FND_API.G_FALSE,
2213: p_count => x_msg_count,

Line 2211: FND_MSG_PUB.Count_And_Get (

2207: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2208: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2209: FND_MSG_PUB.add;
2210: END IF;
2211: FND_MSG_PUB.Count_And_Get (
2212: p_encoded => FND_API.G_FALSE,
2213: p_count => x_msg_count,
2214: p_data => x_msg_data
2215: );

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

2216:
2217: WHEN OTHERS THEN
2218: ROLLBACK TO Asso_Accruals_To_Claim;
2219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2220: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2221: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2222: FND_MSG_PUB.add;
2223: END IF;
2224: FND_MSG_PUB.Count_And_Get (

Line 2222: FND_MSG_PUB.add;

2218: ROLLBACK TO Asso_Accruals_To_Claim;
2219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2220: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2221: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2222: FND_MSG_PUB.add;
2223: END IF;
2224: FND_MSG_PUB.Count_And_Get (
2225: p_encoded => FND_API.G_FALSE,
2226: p_count => x_msg_count,

Line 2224: FND_MSG_PUB.Count_And_Get (

2220: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2221: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2222: FND_MSG_PUB.add;
2223: END IF;
2224: FND_MSG_PUB.Count_And_Get (
2225: p_encoded => FND_API.G_FALSE,
2226: p_count => x_msg_count,
2227: p_data => x_msg_data
2228: );

Line 2283: FND_MSG_PUB.initialize;

2279: END IF;
2280:
2281: -- Initialize message list if p_init_msg_list is set to TRUE.
2282: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2283: FND_MSG_PUB.initialize;
2284: END IF;
2285:
2286: -- Initialize API return status to SUCCESS
2287: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2321: FND_MSG_PUB.Count_And_Get(

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(
2322: p_count => x_msg_count,
2323: p_data => x_msg_data
2324: );
2325:

Line 2330: FND_MSG_PUB.Count_And_Get (

2326: EXCEPTION
2327: WHEN FND_API.G_EXC_ERROR THEN
2328: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2329: x_return_status := FND_API.G_RET_STS_ERROR;
2330: FND_MSG_PUB.Count_And_Get (
2331: p_encoded => FND_API.G_FALSE,
2332: p_count => x_msg_count,
2333: p_data => x_msg_data
2334: );

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

2335:
2336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2337: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2339: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2340: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2341: FND_MSG_PUB.add;
2342: END IF;
2343: FND_MSG_PUB.Count_And_Get (

Line 2341: FND_MSG_PUB.add;

2337: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2339: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2340: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2341: FND_MSG_PUB.add;
2342: END IF;
2343: FND_MSG_PUB.Count_And_Get (
2344: p_encoded => FND_API.G_FALSE,
2345: p_count => x_msg_count,

Line 2343: FND_MSG_PUB.Count_And_Get (

2339: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2340: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2341: FND_MSG_PUB.add;
2342: END IF;
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 OTHERS THEN
2350: ROLLBACK TO Asso_Accruals_To_Claim_Line;
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 Asso_Accruals_To_Claim_Line;
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 2422: FND_MSG_PUB.initialize;

2418: END IF;
2419:
2420: -- Initialize message list if p_init_msg_list is set to TRUE.
2421: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2422: FND_MSG_PUB.initialize;
2423: END IF;
2424:
2425: -- Initialize API return status to SUCCESS
2426: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2563: FND_MSG_PUB.Count_And_Get(

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(
2564: p_count => x_msg_count,
2565: p_data => x_msg_data
2566: );
2567:

Line 2572: FND_MSG_PUB.Count_And_Get (

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

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

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

Line 2583: FND_MSG_PUB.add;

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

Line 2585: FND_MSG_PUB.Count_And_Get (

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

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

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

Line 2596: FND_MSG_PUB.add;

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

Line 2598: FND_MSG_PUB.Count_And_Get (

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

Line 2664: FND_MSG_PUB.initialize;

2660: END IF;
2661:
2662: -- Initialize message list if p_init_msg_list is set to TRUE.
2663: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2664: FND_MSG_PUB.initialize;
2665: END IF;
2666:
2667: -- Initialize API return status to SUCCESS
2668: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2800: FND_MSG_PUB.Count_And_Get(

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(
2801: p_count => x_msg_count,
2802: p_data => x_msg_data
2803: );
2804:

Line 2809: FND_MSG_PUB.Count_And_Get (

2805: EXCEPTION
2806: WHEN FND_API.G_EXC_ERROR THEN
2807: ROLLBACK TO Pay_Claim_For_Accruals;
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809: FND_MSG_PUB.Count_And_Get (
2810: p_encoded => FND_API.G_FALSE,
2811: p_count => x_msg_count,
2812: p_data => x_msg_data
2813: );

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

2814:
2815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2816: ROLLBACK TO Pay_Claim_For_Accruals;
2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2818: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2819: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2820: FND_MSG_PUB.add;
2821: END IF;
2822: FND_MSG_PUB.Count_And_Get (

Line 2820: FND_MSG_PUB.add;

2816: ROLLBACK TO Pay_Claim_For_Accruals;
2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2818: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2819: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2820: FND_MSG_PUB.add;
2821: END IF;
2822: FND_MSG_PUB.Count_And_Get (
2823: p_encoded => FND_API.G_FALSE,
2824: p_count => x_msg_count,

Line 2822: FND_MSG_PUB.Count_And_Get (

2818: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2819: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2820: FND_MSG_PUB.add;
2821: END IF;
2822: FND_MSG_PUB.Count_And_Get (
2823: p_encoded => FND_API.G_FALSE,
2824: p_count => x_msg_count,
2825: p_data => x_msg_data
2826: );

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

2827:
2828: WHEN OTHERS THEN
2829: ROLLBACK TO Pay_Claim_For_Accruals;
2830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2831: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2832: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2833: FND_MSG_PUB.add;
2834: END IF;
2835: FND_MSG_PUB.Count_And_Get (

Line 2833: FND_MSG_PUB.add;

2829: ROLLBACK TO Pay_Claim_For_Accruals;
2830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2831: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2832: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2833: FND_MSG_PUB.add;
2834: END IF;
2835: FND_MSG_PUB.Count_And_Get (
2836: p_encoded => FND_API.G_FALSE,
2837: p_count => x_msg_count,

Line 2835: FND_MSG_PUB.Count_And_Get (

2831: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2832: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2833: FND_MSG_PUB.add;
2834: END IF;
2835: FND_MSG_PUB.Count_And_Get (
2836: p_encoded => FND_API.G_FALSE,
2837: p_count => x_msg_count,
2838: p_data => x_msg_data
2839: );

Line 2939: FND_MSG_PUB.initialize;

2935: -- Initialize message list if p_init_msg_list is set to TRUE.
2936:
2937: IF FND_API.to_Boolean( p_init_msg_list )
2938: THEN
2939: FND_MSG_PUB.initialize;
2940: END IF;
2941:
2942: -- Initialize API return status to SUCCESS
2943: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2951: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

2947:
2948: --//Validations
2949: --//Parent claim Id validation
2950: IF p_parent_claim_id = FND_API.g_miss_num OR p_parent_claim_id IS NULL THEN
2951: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2952: FND_MESSAGE.Set_Name('OZF','OZF_NO_CLAIM_ID');
2953: FND_MSG_PUB.Add;
2954: END IF;
2955: RAISE FND_API.G_EXC_ERROR;

Line 2953: FND_MSG_PUB.Add;

2949: --//Parent claim Id validation
2950: IF p_parent_claim_id = FND_API.g_miss_num OR p_parent_claim_id IS NULL THEN
2951: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2952: FND_MESSAGE.Set_Name('OZF','OZF_NO_CLAIM_ID');
2953: FND_MSG_PUB.Add;
2954: END IF;
2955: RAISE FND_API.G_EXC_ERROR;
2956: ELSE
2957: OPEN parent_claim_id_csr(p_parent_claim_id);

Line 2962: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

2958: FETCH parent_claim_id_csr INTO l_claim_id,l_parent_objver_no,l_status_code,l_amount_remaining;
2959: CLOSE parent_claim_id_csr;
2960:
2961: IF l_claim_id IS NULL THEN
2962: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2963: FND_MESSAGE.Set_Name('OZF','OZF_INVALID_CLAIM_ID');
2964: FND_MSG_PUB.Add;
2965: END IF;
2966: RAISE FND_API.G_EXC_ERROR;

Line 2964: FND_MSG_PUB.Add;

2960:
2961: IF l_claim_id IS NULL THEN
2962: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2963: FND_MESSAGE.Set_Name('OZF','OZF_INVALID_CLAIM_ID');
2964: FND_MSG_PUB.Add;
2965: END IF;
2966: RAISE FND_API.G_EXC_ERROR;
2967: END IF;
2968: END IF;

Line 2971: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

2967: END IF;
2968: END IF;
2969:
2970: IF l_status_code <> 'OPEN' THEN
2971: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2972: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_WRONG_SPLIT_STATUS');
2973: FND_MSG_PUB.Add;
2974: END IF;
2975: RAISE FND_API.G_EXC_ERROR;

Line 2973: FND_MSG_PUB.Add;

2969:
2970: IF l_status_code <> 'OPEN' THEN
2971: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2972: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_WRONG_SPLIT_STATUS');
2973: FND_MSG_PUB.Add;
2974: END IF;
2975: RAISE FND_API.G_EXC_ERROR;
2976: END IF;
2977:

Line 2985: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

2981: l_sum_split_amt := NVL(l_sum_split_amt,0) + NVL(px_child_claim_tbl(i).amount,0);
2982: END LOOP;
2983:
2984: IF l_sum_split_amt > l_amount_remaining THEN
2985: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2986: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_SPLT_NG_NOPM');
2987: --//Failed to split the claim: The amount of deduction or claim should be positive after the split.
2988: FND_MSG_PUB.Add;
2989: END IF;

Line 2988: FND_MSG_PUB.Add;

2984: IF l_sum_split_amt > l_amount_remaining THEN
2985: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2986: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_SPLT_NG_NOPM');
2987: --//Failed to split the claim: The amount of deduction or claim should be positive after the split.
2988: FND_MSG_PUB.Add;
2989: END IF;
2990: RAISE FND_API.G_EXC_ERROR;
2991: END IF;
2992: END IF;

Line 2999: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

2995: IF px_child_claim_tbl.COUNT > 0 THEN
2996: FOR i IN px_child_claim_tbl.FIRST..px_child_claim_tbl.LAST
2997: LOOP
2998: IF px_child_claim_tbl(i).amount = FND_API.g_miss_num OR px_child_claim_tbl(i).amount IS NULL THEN
2999: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3000: FND_MESSAGE.Set_Name('OZF','OZF_NO_SPLIT_CLAIM_AMT');
3001: --//Split amount is mandatory to create a split claim.
3002: FND_MSG_PUB.Add;
3003: END IF;

Line 3002: FND_MSG_PUB.Add;

2998: IF px_child_claim_tbl(i).amount = FND_API.g_miss_num OR px_child_claim_tbl(i).amount IS NULL THEN
2999: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3000: FND_MESSAGE.Set_Name('OZF','OZF_NO_SPLIT_CLAIM_AMT');
3001: --//Split amount is mandatory to create a split claim.
3002: FND_MSG_PUB.Add;
3003: END IF;
3004: RAISE FND_API.G_EXC_ERROR;
3005: END IF;
3006:

Line 3015: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

3011: FETCH claim_type_id_csr INTO l_claim_type;
3012: CLOSE claim_type_id_csr;
3013:
3014: IF l_claim_type IS NULL THEN
3015: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3016: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_CLAIM_TYPE_NOT_IN_DB');
3017: FND_MSG_PUB.Add;
3018: END IF;
3019: RAISE FND_API.G_EXC_ERROR;

Line 3017: FND_MSG_PUB.Add;

3013:
3014: IF l_claim_type IS NULL THEN
3015: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3016: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_CLAIM_TYPE_NOT_IN_DB');
3017: FND_MSG_PUB.Add;
3018: END IF;
3019: RAISE FND_API.G_EXC_ERROR;
3020: END IF;
3021: END IF;

Line 3030: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

3026: FETCH reason_code_id_csr INTO l_claim_reason;
3027: CLOSE reason_code_id_csr;
3028:
3029: IF l_claim_reason IS NULL THEN
3030: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3031: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_REASON_CD_NOT_IN_DB');
3032: FND_MSG_PUB.Add;
3033: END IF;
3034: RAISE FND_API.G_EXC_ERROR;

Line 3032: FND_MSG_PUB.Add;

3028:
3029: IF l_claim_reason IS NULL THEN
3030: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3031: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_REASON_CD_NOT_IN_DB');
3032: FND_MSG_PUB.Add;
3033: END IF;
3034: RAISE FND_API.G_EXC_ERROR;
3035: END IF;
3036: END IF;

Line 3058: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

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
3059: FND_MESSAGE.Set_Name('OZF','OZF_INVALID_CLAIM_LINE_ID');
3060: FND_MESSAGE.set_token('CLAIMLINEID', px_child_claim_tbl(i).claim_line_id_tbl(j).claim_line_id, false);
3061: --//Claim line id (l_claim_line_tbl(j).claim_line_id ) provided is invalid. Please enter a valid claim line id.
3062: FND_MSG_PUB.Add;

Line 3062: FND_MSG_PUB.Add;

3058: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3059: FND_MESSAGE.Set_Name('OZF','OZF_INVALID_CLAIM_LINE_ID');
3060: FND_MESSAGE.set_token('CLAIMLINEID', px_child_claim_tbl(i).claim_line_id_tbl(j).claim_line_id, false);
3061: --//Claim line id (l_claim_line_tbl(j).claim_line_id ) provided is invalid. Please enter a valid claim line id.
3062: FND_MSG_PUB.Add;
3063: END IF;
3064: RAISE FND_API.G_EXC_ERROR;
3065: ELSE
3066: l_line_table := l_line_table ||','|| l_claim_line_id;

Line 3074: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

3070:
3071: END IF;
3072:
3073: IF l_line_sum_amount > px_child_claim_tbl(i).amount THEN
3074: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3075: FND_MESSAGE.Set_Name('OZF','OZF_SPLIT_LINE_AMT');
3076: FND_MESSAGE.set_token('AMOUNT', px_child_claim_tbl(i).amount, false);
3077: FND_MESSAGE.set_token('LINEAMOUNT', l_line_sum_amount, false);
3078: FND_MSG_PUB.Add;

Line 3078: FND_MSG_PUB.Add;

3074: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3075: FND_MESSAGE.Set_Name('OZF','OZF_SPLIT_LINE_AMT');
3076: FND_MESSAGE.set_token('AMOUNT', px_child_claim_tbl(i).amount, false);
3077: FND_MESSAGE.set_token('LINEAMOUNT', l_line_sum_amount, false);
3078: FND_MSG_PUB.Add;
3079: END IF;
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;
3082:

Line 3116: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

3112: FOR k IN px_child_claim_tbl.FIRST..px_child_claim_tbl.LAST LOOP
3113: px_child_claim_tbl(k).split_claim_id := l_child_claim_tbl(k).child_claim_id;
3114: END LOOP;
3115: ELSE
3116: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3117: FND_MESSAGE.Set_Name('OZF','OZF_NO_SPLIT_CLAIM_AMT');
3118: --//Split amount is mandatory to create a split claim.
3119: FND_MSG_PUB.Add;
3120: END IF;

Line 3119: FND_MSG_PUB.Add;

3115: ELSE
3116: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3117: FND_MESSAGE.Set_Name('OZF','OZF_NO_SPLIT_CLAIM_AMT');
3118: --//Split amount is mandatory to create a split claim.
3119: FND_MSG_PUB.Add;
3120: END IF;
3121: RAISE FND_API.G_EXC_ERROR;
3122: END IF;
3123:

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

3131: COMMIT WORK;
3132: END IF;
3133:
3134: -- Standard call to get message count and if count is 1, get message info.
3135: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.G_FALSE
3136: , p_count => x_msg_count
3137: , p_data => x_msg_data
3138: );
3139:

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

3141: WHEN FND_API.G_EXC_ERROR THEN
3142: ROLLBACK TO Create_split_claims;
3143: x_return_status := FND_API.G_RET_STS_ERROR;
3144: -- Standard call to get message count and if count=1, get the message
3145: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.G_FALSE
3146: , p_count => x_msg_count
3147: , p_data => x_msg_data
3148: );
3149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3150: ROLLBACK TO Create_split_claims;
3151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3152: -- Standard call to get message count and if count=1, get the message
3153: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.G_FALSE
3154: , p_count => x_msg_count
3155: , p_data => x_msg_data
3156: );
3157: WHEN OTHERS THEN

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

3156: );
3157: WHEN OTHERS THEN
3158: ROLLBACK TO Create_split_claims;
3159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3160: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3161: THEN
3162: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3163: END IF;
3164: -- Standard call to get message count and if count=1, get the message

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

3158: ROLLBACK TO Create_split_claims;
3159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3160: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3161: THEN
3162: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3163: END IF;
3164: -- Standard call to get message count and if count=1, get the message
3165: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.G_FALSE
3166: , p_count => x_msg_count

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

3161: THEN
3162: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3163: END IF;
3164: -- Standard call to get message count and if count=1, get the message
3165: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.G_FALSE
3166: , p_count => x_msg_count
3167: , p_data => x_msg_data
3168: );
3169: End Create_split_claims;

Line 3299: FND_MSG_PUB.initialize;

3295: END IF;
3296:
3297: -- Initialize message list if p_init_msg_list is set to TRUE.
3298: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3299: FND_MSG_PUB.initialize;
3300: END IF;
3301:
3302: -- Debug Message
3303: IF G_DEBUG THEN

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

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
3333: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_CLAIM_ID');
3334: --//Invalid Claim Id. Please provide a valid Claim ID
3335: FND_MSG_PUB.add;
3336: END IF;

Line 3335: FND_MSG_PUB.add;

3331: IF l_claim_id IS NULL THEN
3332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3333: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_CLAIM_ID');
3334: --//Invalid Claim Id. Please provide a valid Claim ID
3335: FND_MSG_PUB.add;
3336: END IF;
3337: x_return_status := fnd_api.g_ret_sts_error;
3338: RETURN;
3339: END IF;

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

3338: RETURN;
3339: END IF;
3340:
3341: IF l_status_code NOT IN ('PENDING_CLOSE','CLOSED') THEN
3342: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3343: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_STATUS_CODE');
3344: --//Claim status should be Pending Close or Closed to create SLA event
3345: FND_MSG_PUB.add;
3346: END IF;

Line 3345: FND_MSG_PUB.add;

3341: IF l_status_code NOT IN ('PENDING_CLOSE','CLOSED') THEN
3342: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3343: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_STATUS_CODE');
3344: --//Claim status should be Pending Close or Closed to create SLA event
3345: FND_MSG_PUB.add;
3346: END IF;
3347: x_return_status := fnd_api.g_ret_sts_error;
3348: RETURN;
3349: END IF;

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

3363: l_settle_method_match := FALSE;
3364: END IF;
3365:
3366: IF NOT l_settle_method_match THEN
3367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3368: FND_MESSAGE.set_name('OZF', 'OZF_INCORRECT_EVENT_TYPE');
3369: --// Please use correct event type code for this settlement method.
3370: FND_MSG_PUB.add;
3371: END IF;

Line 3370: FND_MSG_PUB.add;

3366: IF NOT l_settle_method_match THEN
3367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3368: FND_MESSAGE.set_name('OZF', 'OZF_INCORRECT_EVENT_TYPE');
3369: --// Please use correct event type code for this settlement method.
3370: FND_MSG_PUB.add;
3371: END IF;
3372: x_return_status := fnd_api.g_ret_sts_error;
3373: RETURN;
3374: IF G_DEBUG THEN

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

3394: END IF;
3395: END IF;
3396:
3397: IF NOT l_settle_method_match THEN
3398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3399: FND_MESSAGE.set_name('OZF', 'OZF_INCORRECT_EVENT_TYPE');
3400: --// Please use correct event type code for this settlement method.
3401: FND_MSG_PUB.add;
3402: END IF;

Line 3401: FND_MSG_PUB.add;

3397: IF NOT l_settle_method_match THEN
3398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3399: FND_MESSAGE.set_name('OZF', 'OZF_INCORRECT_EVENT_TYPE');
3400: --// Please use correct event type code for this settlement method.
3401: FND_MSG_PUB.add;
3402: END IF;
3403: x_return_status := fnd_api.g_ret_sts_error;
3404: RETURN;
3405: END IF;

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

3409: FETCH csr_event_type_chk INTO l_event_type_code;
3410: CLOSE csr_event_type_chk;
3411:
3412: IF l_event_type_code IS NULL THEN
3413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3414: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_EVENT_TYPE_CODE');
3415: --//Event type code provided is invalid.Please provide a valid event type code.
3416: FND_MSG_PUB.add;
3417: END IF;

Line 3416: FND_MSG_PUB.add;

3412: IF l_event_type_code IS NULL THEN
3413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3414: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_EVENT_TYPE_CODE');
3415: --//Event type code provided is invalid.Please provide a valid event type code.
3416: FND_MSG_PUB.add;
3417: END IF;
3418: x_return_status := fnd_api.g_ret_sts_error;
3419: RETURN;
3420: END IF;

Line 3431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) 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');
3433: --//Invalid Post to GL flag.
3434: FND_MSG_PUB.add;
3435: END IF;

Line 3434: FND_MSG_PUB.add;

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');
3433: --//Invalid Post to GL flag.
3434: FND_MSG_PUB.add;
3435: END IF;
3436: x_return_status := fnd_api.g_ret_sts_error;
3437: RETURN;
3438: END IF;

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

3443: FETCH csr_is_promo_claim INTO l_promo_count;
3444: CLOSE csr_is_promo_claim;
3445:
3446: IF l_promo_count = 0 THEN
3447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3448: FND_MESSAGE.set_name('OZF', 'OZF_PROMO_CLAIM_REQD');
3449: --//Only promotional claims are eligible to create SLA event.
3450: FND_MSG_PUB.add;
3451: END IF;

Line 3450: FND_MSG_PUB.add;

3446: IF l_promo_count = 0 THEN
3447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3448: FND_MESSAGE.set_name('OZF', 'OZF_PROMO_CLAIM_REQD');
3449: --//Only promotional claims are eligible to create SLA event.
3450: FND_MSG_PUB.add;
3451: END IF;
3452: x_return_status := fnd_api.g_ret_sts_error;
3453: RETURN;
3454: END IF;

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

3453: RETURN;
3454: END IF;
3455:
3456: IF NVL(p_reversal_flag,'N') NOT IN ('Y','N') THEN
3457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3458: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_REVERSAL_FLAG');
3459: --//Value of Reversal flag provided is invalid.Please provide a valid value.
3460: FND_MSG_PUB.add;
3461: END IF;

Line 3460: FND_MSG_PUB.add;

3456: IF NVL(p_reversal_flag,'N') NOT IN ('Y','N') THEN
3457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3458: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_REVERSAL_FLAG');
3459: --//Value of Reversal flag provided is invalid.Please provide a valid value.
3460: FND_MSG_PUB.add;
3461: END IF;
3462: x_return_status := fnd_api.g_ret_sts_error;
3463: RETURN;
3464: END IF;

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

3463: RETURN;
3464: END IF;
3465:
3466: IF p_event_type_code = 'CLAIM_SETTLEMENT_REVERSAL' AND NVL(p_reversal_flag,'N') <> 'Y' THEN
3467: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3468: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_RV_FLAG_FOR_EVT');
3469: --// Reversal flag should be Y for event type code CLAIM_SETTLEMENT_REVERSAL.
3470: FND_MSG_PUB.add;
3471: END IF;

Line 3470: FND_MSG_PUB.add;

3466: IF p_event_type_code = 'CLAIM_SETTLEMENT_REVERSAL' AND NVL(p_reversal_flag,'N') <> 'Y' THEN
3467: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3468: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_RV_FLAG_FOR_EVT');
3469: --// Reversal flag should be Y for event type code CLAIM_SETTLEMENT_REVERSAL.
3470: FND_MSG_PUB.add;
3471: END IF;
3472: x_return_status := fnd_api.g_ret_sts_error;
3473: RETURN;
3474: END IF;

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

3482: ,'SETTLE_INTERNAL_SHIP_DEBIT'
3483: ,'SETTLE_BY_AR_AP_NETTING'
3484: ,'SETTLE_BY_AR_CUSTOM'
3485: ,'SETTLE_BY_AP_CUSTOM') THEN
3486: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3487: FND_MESSAGE.set_name('OZF', 'OZF_INCORRECT_REV_EVENT_TYPE');
3488: --// Please use correct event type code for reversal event.
3489: FND_MSG_PUB.add;
3490: END IF;

Line 3489: FND_MSG_PUB.add;

3485: ,'SETTLE_BY_AP_CUSTOM') THEN
3486: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3487: FND_MESSAGE.set_name('OZF', 'OZF_INCORRECT_REV_EVENT_TYPE');
3488: --// Please use correct event type code for reversal event.
3489: FND_MSG_PUB.add;
3490: END IF;
3491: x_return_status := fnd_api.g_ret_sts_error;
3492: RETURN;
3493: END IF;

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

3503: FETCH csr_chk_event_exists INTO l_exists;
3504: CLOSE csr_chk_event_exists;
3505:
3506: IF l_exists <> 1 THEN
3507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3508: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_EVENT_MISMATCH');
3509: --// Reversal Event should be passed for the same Event Class as parent event.
3510: FND_MSG_PUB.add;
3511: END IF;

Line 3510: FND_MSG_PUB.add;

3506: IF l_exists <> 1 THEN
3507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3508: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_EVENT_MISMATCH');
3509: --// Reversal Event should be passed for the same Event Class as parent event.
3510: FND_MSG_PUB.add;
3511: END IF;
3512: x_return_status := fnd_api.g_ret_sts_error;
3513: RETURN;
3514: END IF;

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

3531: END IF;
3532:
3533: IF l_claim_event_tbl.COUNT = 1 AND NVL(p_reversal_flag,'N') <> 'Y' THEN
3534:
3535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3536: FND_MESSAGE.set_name('OZF', 'OZF_SLA_DUPLICATE_EVENT');
3537: --//SLA event is already created for this Claim.
3538: FND_MSG_PUB.add;
3539: END IF;

Line 3538: FND_MSG_PUB.add;

3534:
3535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3536: FND_MESSAGE.set_name('OZF', 'OZF_SLA_DUPLICATE_EVENT');
3537: --//SLA event is already created for this Claim.
3538: FND_MSG_PUB.add;
3539: END IF;
3540: x_return_status := fnd_api.g_ret_sts_error;
3541: RETURN;
3542: END IF;

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

3542: END IF;
3543:
3544: IF l_claim_event_tbl.COUNT = 2 THEN
3545: IF l_claim_event_tbl(2).event_count = l_claim_event_tbl(1).event_count AND NVL(p_reversal_flag,'N') <> 'N' THEN
3546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3547: FND_MESSAGE.set_name('OZF', 'OZF_SLA_DUPLICATE_EVENT');
3548: --//SLA event is already created for this Claim.
3549: FND_MSG_PUB.add;
3550: END IF;

Line 3549: FND_MSG_PUB.add;

3545: IF l_claim_event_tbl(2).event_count = l_claim_event_tbl(1).event_count AND NVL(p_reversal_flag,'N') <> 'N' THEN
3546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3547: FND_MESSAGE.set_name('OZF', 'OZF_SLA_DUPLICATE_EVENT');
3548: --//SLA event is already created for this Claim.
3549: FND_MSG_PUB.add;
3550: END IF;
3551: x_return_status := fnd_api.g_ret_sts_error;
3552: RETURN;
3553:

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

3551: x_return_status := fnd_api.g_ret_sts_error;
3552: RETURN;
3553:
3554: ELSIF l_claim_event_tbl(2).event_count <> l_claim_event_tbl(1).event_count AND NVL(p_reversal_flag,'N') <> 'Y' THEN
3555: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3556: FND_MESSAGE.set_name('OZF', 'OZF_SLA_DUPLICATE_EVENT');
3557: --//SLA event is already created for this Claim.
3558: FND_MSG_PUB.add;
3559: END IF;

Line 3558: FND_MSG_PUB.add;

3554: ELSIF l_claim_event_tbl(2).event_count <> l_claim_event_tbl(1).event_count AND NVL(p_reversal_flag,'N') <> 'Y' THEN
3555: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3556: FND_MESSAGE.set_name('OZF', 'OZF_SLA_DUPLICATE_EVENT');
3557: --//SLA event is already created for this Claim.
3558: FND_MSG_PUB.add;
3559: END IF;
3560: x_return_status := fnd_api.g_ret_sts_error;
3561: RETURN;
3562: END IF;

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

3562: END IF;
3563: END IF;
3564: ELSE
3565: IF NVL(p_reversal_flag,'N') <> 'N' THEN
3566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3567: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_REVERSAL_EVENT');
3568: --//You cannot create first event of a claim as Reversal event.
3569: FND_MSG_PUB.add;
3570: END IF;

Line 3569: FND_MSG_PUB.add;

3565: IF NVL(p_reversal_flag,'N') <> 'N' THEN
3566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3567: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_REVERSAL_EVENT');
3568: --//You cannot create first event of a claim as Reversal event.
3569: FND_MSG_PUB.add;
3570: END IF;
3571: x_return_status := fnd_api.g_ret_sts_error;
3572: RETURN;
3573: END IF;

Line 3609: FND_MSG_PUB.Count_And_Get (

3605: THEN
3606: COMMIT WORK;
3607: END IF;
3608:
3609: FND_MSG_PUB.Count_And_Get (
3610: p_encoded => FND_API.G_FALSE,
3611: p_count => x_msg_count,
3612: p_data => x_msg_data
3613: );

Line 3620: FND_MSG_PUB.Count_And_Get (

3616: WHEN FND_API.G_EXC_ERROR THEN
3617: ROLLBACK TO Create_event;
3618: x_return_status := FND_API.G_RET_STS_ERROR;
3619: -- Standard call to get message count and if count=1, get the message
3620: FND_MSG_PUB.Count_And_Get (
3621: p_encoded => FND_API.G_FALSE,
3622: p_count => x_msg_count,
3623: p_data => x_msg_data
3624: );

Line 3629: FND_MSG_PUB.Count_And_Get (

3625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3626: ROLLBACK TO Create_event;
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3628: -- Standard call to get message count and if count=1, get the message
3629: FND_MSG_PUB.Count_And_Get (
3630: p_encoded => FND_API.G_FALSE,
3631: p_count => x_msg_count,
3632: p_data => x_msg_data
3633: );

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

3633: );
3634: WHEN OTHERS THEN
3635: ROLLBACK TO Create_event;
3636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3637: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3638: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3639: END IF;
3640: -- Standard call to get message count and if count=1, get the message
3641: FND_MSG_PUB.Count_And_Get (

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

3634: WHEN OTHERS THEN
3635: ROLLBACK TO Create_event;
3636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3637: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3638: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3639: END IF;
3640: -- Standard call to get message count and if count=1, get the message
3641: FND_MSG_PUB.Count_And_Get (
3642: p_encoded => FND_API.G_FALSE,

Line 3641: FND_MSG_PUB.Count_And_Get (

3637: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3638: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3639: END IF;
3640: -- Standard call to get message count and if count=1, get the message
3641: FND_MSG_PUB.Count_And_Get (
3642: p_encoded => FND_API.G_FALSE,
3643: p_count => x_msg_count,
3644: p_data => x_msg_data
3645: );