DBA Data[Home] [Help]

APPS.OZF_CLAIM_LINES_INT_PVT dependencies on FND_MSG_PUB

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

16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Claim_Lines_Int_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvclib.pls';
19:
20: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
21:
22: -- Hint: Primary key needs to be returned.
23: PROCEDURE Create_Claim_Lines_Int(
24: p_api_version_number IN NUMBER,

Line 71: FND_MSG_PUB.initialize;

67:
68: -- Initialize message list if p_init_msg_list is set to TRUE.
69: IF FND_API.to_Boolean( p_init_msg_list )
70: THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: -- Debug Message
75: IF g_debug THEN

Line 221: FND_MSG_PUB.Count_And_Get

217: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
218: END IF;
219:
220: -- Standard call to get message count and if count is 1, get message info.
221: FND_MSG_PUB.Count_And_Get
222: (p_count => x_msg_count,
223: p_data => x_msg_data
224: );
225: EXCEPTION

Line 235: FND_MSG_PUB.Count_And_Get (

231: WHEN FND_API.G_EXC_ERROR THEN
232: ROLLBACK TO CREATE_Claim_Lines_Int_PVT;
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: -- Standard call to get message count and if count=1, get the message
235: FND_MSG_PUB.Count_And_Get (
236: p_encoded => FND_API.G_FALSE,
237: p_count => x_msg_count,
238: p_data => x_msg_data
239: );

Line 245: FND_MSG_PUB.Count_And_Get (

241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242: ROLLBACK TO CREATE_Claim_Lines_Int_PVT;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: -- Standard call to get message count and if count=1, get the message
245: FND_MSG_PUB.Count_And_Get (
246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,
248: p_data => x_msg_data
249: );

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

250:
251: WHEN OTHERS THEN
252: ROLLBACK TO CREATE_Claim_Lines_Int_PVT;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
257: END IF;
258: -- Standard call to get message count and if count=1, get the message

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

252: ROLLBACK TO CREATE_Claim_Lines_Int_PVT;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
257: END IF;
258: -- Standard call to get message count and if count=1, get the message
259: FND_MSG_PUB.Count_And_Get (
260: p_encoded => FND_API.G_FALSE,

Line 259: FND_MSG_PUB.Count_And_Get (

255: THEN
256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
257: END IF;
258: -- Standard call to get message count and if count=1, get the message
259: FND_MSG_PUB.Count_And_Get (
260: p_encoded => FND_API.G_FALSE,
261: p_count => x_msg_count,
262: p_data => x_msg_data
263: );

Line 313: FND_MSG_PUB.initialize;

309:
310: -- Initialize message list if p_init_msg_list is set to TRUE.
311: IF FND_API.to_Boolean( p_init_msg_list )
312: THEN
313: FND_MSG_PUB.initialize;
314: END IF;
315:
316: -- Debug Message
317: IF g_debug THEN

Line 382: OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

378:
379:
380: -- Debug Message
381: IF g_debug THEN
382: OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
383: END IF;
384:
385: -- Invoke table handler(OZF_CLAIM_LINES_INT_PKG.Update_Row)
386: OZF_CLAIM_LINES_INT_PKG.Update_Row(

Line 464: FND_MSG_PUB.Count_And_Get

460: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
461: END IF;
462:
463: -- Standard call to get message count and if count is 1, get message info.
464: FND_MSG_PUB.Count_And_Get
465: (p_count => x_msg_count,
466: p_data => x_msg_data
467: );
468: EXCEPTION

Line 478: FND_MSG_PUB.Count_And_Get (

474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO UPDATE_Claim_Lines_Int_PVT;
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: -- Standard call to get message count and if count=1, get the message
478: FND_MSG_PUB.Count_And_Get (
479: p_encoded => FND_API.G_FALSE,
480: p_count => x_msg_count,
481: p_data => x_msg_data
482: );

Line 488: FND_MSG_PUB.Count_And_Get (

484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: ROLLBACK TO UPDATE_Claim_Lines_Int_PVT;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
487: -- Standard call to get message count and if count=1, get the message
488: FND_MSG_PUB.Count_And_Get (
489: p_encoded => FND_API.G_FALSE,
490: p_count => x_msg_count,
491: p_data => x_msg_data
492: );

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

493:
494: WHEN OTHERS THEN
495: ROLLBACK TO UPDATE_Claim_Lines_Int_PVT;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
498: THEN
499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
500: END IF;
501: -- Standard call to get message count and if count=1, get the message

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

495: ROLLBACK TO UPDATE_Claim_Lines_Int_PVT;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
498: THEN
499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
500: END IF;
501: -- Standard call to get message count and if count=1, get the message
502: FND_MSG_PUB.Count_And_Get (
503: p_encoded => FND_API.G_FALSE,

Line 502: FND_MSG_PUB.Count_And_Get (

498: THEN
499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
500: END IF;
501: -- Standard call to get message count and if count=1, get the message
502: FND_MSG_PUB.Count_And_Get (
503: p_encoded => FND_API.G_FALSE,
504: p_count => x_msg_count,
505: p_data => x_msg_data
506: );

Line 543: FND_MSG_PUB.initialize;

539:
540: -- Initialize message list if p_init_msg_list is set to TRUE.
541: IF FND_API.to_Boolean( p_init_msg_list )
542: THEN
543: FND_MSG_PUB.initialize;
544: END IF;
545:
546: -- Debug Message
547: IF g_debug THEN

Line 583: FND_MSG_PUB.Count_And_Get

579: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
580: END IF;
581:
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 597: FND_MSG_PUB.Count_And_Get (

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

Line 607: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 621: FND_MSG_PUB.Count_And_Get (

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

Line 666: FND_MSG_PUB.initialize;

662:
663: -- Initialize message list if p_init_msg_list is set to TRUE.
664: IF FND_API.to_Boolean( p_init_msg_list )
665: THEN
666: FND_MSG_PUB.initialize;
667: END IF;
668:
669: -- Standard call to check for call compatibility.
670: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

690: FETCH c_Claim_Lines_Int INTO l_INTERFACE_CLAIM_LINE_ID;
691:
692: IF (c_Claim_Lines_Int%NOTFOUND) THEN
693: CLOSE c_Claim_Lines_Int;
694: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
695: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
696: FND_MSG_PUB.add;
697: END IF;
698: RAISE FND_API.g_exc_error;

Line 696: FND_MSG_PUB.add;

692: IF (c_Claim_Lines_Int%NOTFOUND) THEN
693: CLOSE c_Claim_Lines_Int;
694: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
695: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
696: FND_MSG_PUB.add;
697: END IF;
698: RAISE FND_API.g_exc_error;
699: END IF;
700:

Line 704: FND_MSG_PUB.count_and_get(

700:
701: CLOSE c_Claim_Lines_Int;
702:
703: -------------------- finish --------------------------
704: FND_MSG_PUB.count_and_get(
705: p_encoded => FND_API.g_false,
706: p_count => x_msg_count,
707: p_data => x_msg_data);
708: IF g_debug THEN

Line 721: FND_MSG_PUB.Count_And_Get (

717: WHEN FND_API.G_EXC_ERROR THEN
718: ROLLBACK TO LOCK_Claim_Lines_Int_PVT;
719: x_return_status := FND_API.G_RET_STS_ERROR;
720: -- Standard call to get message count and if count=1, get the message
721: FND_MSG_PUB.Count_And_Get (
722: p_encoded => FND_API.G_FALSE,
723: p_count => x_msg_count,
724: p_data => x_msg_data
725: );

Line 731: FND_MSG_PUB.Count_And_Get (

727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
728: ROLLBACK TO LOCK_Claim_Lines_Int_PVT;
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: -- Standard call to get message count and if count=1, get the message
731: FND_MSG_PUB.Count_And_Get (
732: p_encoded => FND_API.G_FALSE,
733: p_count => x_msg_count,
734: p_data => x_msg_data
735: );

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

736:
737: WHEN OTHERS THEN
738: ROLLBACK TO LOCK_Claim_Lines_Int_PVT;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
741: THEN
742: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
743: END IF;
744: -- Standard call to get message count and if count=1, get the message

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

738: ROLLBACK TO LOCK_Claim_Lines_Int_PVT;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
741: THEN
742: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
743: END IF;
744: -- Standard call to get message count and if count=1, get the message
745: FND_MSG_PUB.Count_And_Get (
746: p_encoded => FND_API.G_FALSE,

Line 745: FND_MSG_PUB.Count_And_Get (

741: THEN
742: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
743: END IF;
744: -- Standard call to get message count and if count=1, get the message
745: FND_MSG_PUB.Count_And_Get (
746: p_encoded => FND_API.G_FALSE,
747: p_count => x_msg_count,
748: p_data => x_msg_data
749: );

Line 1557: FND_MSG_PUB.initialize;

1553:
1554: -- Initialize message list if p_init_msg_list is set to TRUE.
1555: IF FND_API.to_Boolean( p_init_msg_list )
1556: THEN
1557: FND_MSG_PUB.initialize;
1558: END IF;
1559: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1560: Check_claim_lines_int_Items(
1561: p_claim_lines_int_rec => p_claim_lines_int_rec,

Line 1611: FND_MSG_PUB.Count_And_Get

1607: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1608: END IF;
1609:
1610: -- Standard call to get message count and if count is 1, get message info.
1611: FND_MSG_PUB.Count_And_Get
1612: (p_count => x_msg_count,
1613: p_data => x_msg_data
1614: );
1615: EXCEPTION

Line 1625: FND_MSG_PUB.Count_And_Get (

1621: WHEN FND_API.G_EXC_ERROR THEN
1622: ROLLBACK TO VALIDATE_Claim_Lines_Int_;
1623: x_return_status := FND_API.G_RET_STS_ERROR;
1624: -- Standard call to get message count and if count=1, get the message
1625: FND_MSG_PUB.Count_And_Get (
1626: p_encoded => FND_API.G_FALSE,
1627: p_count => x_msg_count,
1628: p_data => x_msg_data
1629: );

Line 1635: FND_MSG_PUB.Count_And_Get (

1631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1632: ROLLBACK TO VALIDATE_Claim_Lines_Int_;
1633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1634: -- Standard call to get message count and if count=1, get the message
1635: FND_MSG_PUB.Count_And_Get (
1636: p_encoded => FND_API.G_FALSE,
1637: p_count => x_msg_count,
1638: p_data => x_msg_data
1639: );

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

1640:
1641: WHEN OTHERS THEN
1642: ROLLBACK TO VALIDATE_Claim_Lines_Int_;
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1645: THEN
1646: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1647: END IF;
1648: -- Standard call to get message count and if count=1, get the message

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

1642: ROLLBACK TO VALIDATE_Claim_Lines_Int_;
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1645: THEN
1646: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1647: END IF;
1648: -- Standard call to get message count and if count=1, get the message
1649: FND_MSG_PUB.Count_And_Get (
1650: p_encoded => FND_API.G_FALSE,

Line 1649: FND_MSG_PUB.Count_And_Get (

1645: THEN
1646: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1647: END IF;
1648: -- Standard call to get message count and if count=1, get the message
1649: FND_MSG_PUB.Count_And_Get (
1650: p_encoded => FND_API.G_FALSE,
1651: p_count => x_msg_count,
1652: p_data => x_msg_data
1653: );

Line 1670: FND_MSG_PUB.initialize;

1666: BEGIN
1667: -- Initialize message list if p_init_msg_list is set to TRUE.
1668: IF FND_API.to_Boolean( p_init_msg_list )
1669: THEN
1670: FND_MSG_PUB.initialize;
1671: END IF;
1672:
1673: -- Initialize API return status to SUCCESS
1674: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1686: FND_MSG_PUB.Count_And_Get

1682: IF g_debug THEN
1683: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1684: END IF;
1685: -- Standard call to get message count and if count is 1, get message info.
1686: FND_MSG_PUB.Count_And_Get
1687: (p_count => x_msg_count,
1688: p_data => x_msg_data
1689: );
1690: END Validate_claim_lines_int_Rec;