eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_AE_HEADER_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_Ae_Header_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvaehb.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_Ae_Header(
24: p_api_version_number IN NUMBER,

Line 70: FND_MSG_PUB.initialize;

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

Line 205: FND_MSG_PUB.Count_And_Get

201: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
202: END IF;
203:
204: -- Standard call to get message count and if count is 1, get message info.
205: FND_MSG_PUB.Count_And_Get
206: (p_count => x_msg_count,
207: p_data => x_msg_data
208: );
209: EXCEPTION

Line 218: FND_MSG_PUB.Count_And_Get (

214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO CREATE_Ae_Header_PVT;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: -- Standard call to get message count and if count=1, get the message
218: FND_MSG_PUB.Count_And_Get (
219: p_encoded => FND_API.G_FALSE,
220: p_count => x_msg_count,
221: p_data => x_msg_data
222: );

Line 227: FND_MSG_PUB.Count_And_Get (

223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO CREATE_Ae_Header_PVT;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: -- Standard call to get message count and if count=1, get the message
227: FND_MSG_PUB.Count_And_Get (
228: p_encoded => FND_API.G_FALSE,
229: p_count => x_msg_count,
230: p_data => x_msg_data
231: );

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

231: );
232: WHEN OTHERS THEN
233: ROLLBACK TO CREATE_Ae_Header_PVT;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
236: THEN
237: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
238: END IF;
239: -- Standard call to get message count and if count=1, get the message

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

233: ROLLBACK TO CREATE_Ae_Header_PVT;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
236: THEN
237: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
238: END IF;
239: -- Standard call to get message count and if count=1, get the message
240: FND_MSG_PUB.Count_And_Get (
241: p_encoded => FND_API.G_FALSE,

Line 240: FND_MSG_PUB.Count_And_Get (

236: THEN
237: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
238: END IF;
239: -- Standard call to get message count and if count=1, get the message
240: FND_MSG_PUB.Count_And_Get (
241: p_encoded => FND_API.G_FALSE,
242: p_count => x_msg_count,
243: p_data => x_msg_data
244: );

Line 293: FND_MSG_PUB.initialize;

289:
290: -- Initialize message list if p_init_msg_list is set to TRUE.
291: IF FND_API.to_Boolean( p_init_msg_list )
292: THEN
293: FND_MSG_PUB.initialize;
294: END IF;
295:
296: -- Debug Message
297: IF g_debug THEN

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

358:
359:
360: -- Debug Message
361: IF g_debug THEN
362: OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
363: END IF;
364:
365: -- Invoke table handler(OZF_AE_HEADERS_PKG.Update_Row)
366: OZF_AE_HEADERS_PKG.Update_Row(

Line 424: FND_MSG_PUB.Count_And_Get

420: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
421: END IF;
422:
423: -- Standard call to get message count and if count is 1, get message info.
424: FND_MSG_PUB.Count_And_Get
425: (p_count => x_msg_count,
426: p_data => x_msg_data
427: );
428: EXCEPTION

Line 438: FND_MSG_PUB.Count_And_Get (

434: WHEN FND_API.G_EXC_ERROR THEN
435: ROLLBACK TO UPDATE_Ae_Header_PVT;
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: -- Standard call to get message count and if count=1, get the message
438: FND_MSG_PUB.Count_And_Get (
439: p_encoded => FND_API.G_FALSE,
440: p_count => x_msg_count,
441: p_data => x_msg_data
442: );

Line 448: FND_MSG_PUB.Count_And_Get (

444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: ROLLBACK TO UPDATE_Ae_Header_PVT;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: -- Standard call to get message count and if count=1, get the message
448: FND_MSG_PUB.Count_And_Get (
449: p_encoded => FND_API.G_FALSE,
450: p_count => x_msg_count,
451: p_data => x_msg_data
452: );

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

453:
454: WHEN OTHERS THEN
455: ROLLBACK TO UPDATE_Ae_Header_PVT;
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
458: THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
460: END IF;
461: -- Standard call to get message count and if count=1, get the message

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

455: ROLLBACK TO UPDATE_Ae_Header_PVT;
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
458: THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
460: END IF;
461: -- Standard call to get message count and if count=1, get the message
462: FND_MSG_PUB.Count_And_Get (
463: p_encoded => FND_API.G_FALSE,

Line 462: FND_MSG_PUB.Count_And_Get (

458: THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
460: END IF;
461: -- Standard call to get message count and if count=1, get the message
462: FND_MSG_PUB.Count_And_Get (
463: p_encoded => FND_API.G_FALSE,
464: p_count => x_msg_count,
465: p_data => x_msg_data
466: );

Line 503: FND_MSG_PUB.initialize;

499:
500: -- Initialize message list if p_init_msg_list is set to TRUE.
501: IF FND_API.to_Boolean( p_init_msg_list )
502: THEN
503: FND_MSG_PUB.initialize;
504: END IF;
505:
506: -- Debug Message
507: IF g_debug THEN

Line 543: FND_MSG_PUB.Count_And_Get

539: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
540: END IF;
541:
542: -- Standard call to get message count and if count is 1, get message info.
543: FND_MSG_PUB.Count_And_Get
544: (p_count => x_msg_count,
545: p_data => x_msg_data
546: );
547: EXCEPTION

Line 557: FND_MSG_PUB.Count_And_Get (

553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO DELETE_Ae_Header_PVT;
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: -- Standard call to get message count and if count=1, get the message
557: FND_MSG_PUB.Count_And_Get (
558: p_encoded => FND_API.G_FALSE,
559: p_count => x_msg_count,
560: p_data => x_msg_data
561: );

Line 567: FND_MSG_PUB.Count_And_Get (

563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: ROLLBACK TO DELETE_Ae_Header_PVT;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566: -- Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (
568: p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count,
570: p_data => x_msg_data
571: );

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

572:
573: WHEN OTHERS THEN
574: ROLLBACK TO DELETE_Ae_Header_PVT;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
577: THEN
578: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
579: END IF;
580: -- Standard call to get message count and if count=1, get the message

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

574: ROLLBACK TO DELETE_Ae_Header_PVT;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
577: THEN
578: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
579: END IF;
580: -- Standard call to get message count and if count=1, get the message
581: FND_MSG_PUB.Count_And_Get (
582: p_encoded => FND_API.G_FALSE,

Line 581: FND_MSG_PUB.Count_And_Get (

577: THEN
578: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
579: END IF;
580: -- Standard call to get message count and if count=1, get the message
581: FND_MSG_PUB.Count_And_Get (
582: p_encoded => FND_API.G_FALSE,
583: p_count => x_msg_count,
584: p_data => x_msg_data
585: );

Line 626: FND_MSG_PUB.initialize;

622:
623: -- Initialize message list if p_init_msg_list is set to TRUE.
624: IF FND_API.to_Boolean( p_init_msg_list )
625: THEN
626: FND_MSG_PUB.initialize;
627: END IF;
628:
629: -- Standard call to check for call compatibility.
630: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

650: FETCH c_Ae_Header INTO l_AE_HEADER_ID;
651:
652: IF (c_Ae_Header%NOTFOUND) THEN
653: CLOSE c_Ae_Header;
654: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
655: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
656: FND_MSG_PUB.add;
657: END IF;
658: RAISE FND_API.g_exc_error;

Line 656: FND_MSG_PUB.add;

652: IF (c_Ae_Header%NOTFOUND) THEN
653: CLOSE c_Ae_Header;
654: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
655: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
656: FND_MSG_PUB.add;
657: END IF;
658: RAISE FND_API.g_exc_error;
659: END IF;
660:

Line 664: FND_MSG_PUB.count_and_get(

660:
661: CLOSE c_Ae_Header;
662:
663: -------------------- finish --------------------------
664: FND_MSG_PUB.count_and_get(
665: p_encoded => FND_API.g_false,
666: p_count => x_msg_count,
667: p_data => x_msg_data);
668: IF g_debug THEN

Line 681: FND_MSG_PUB.Count_And_Get (

677: WHEN FND_API.G_EXC_ERROR THEN
678: ROLLBACK TO LOCK_Ae_Header_PVT;
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: -- Standard call to get message count and if count=1, get the message
681: FND_MSG_PUB.Count_And_Get (
682: p_encoded => FND_API.G_FALSE,
683: p_count => x_msg_count,
684: p_data => x_msg_data
685: );

Line 691: FND_MSG_PUB.Count_And_Get (

687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
688: ROLLBACK TO LOCK_Ae_Header_PVT;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data
695: );

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

696:
697: WHEN OTHERS THEN
698: ROLLBACK TO LOCK_Ae_Header_PVT;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
703: END IF;
704: -- Standard call to get message count and if count=1, get the message

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

698: ROLLBACK TO LOCK_Ae_Header_PVT;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
703: END IF;
704: -- Standard call to get message count and if count=1, get the message
705: FND_MSG_PUB.Count_And_Get (
706: p_encoded => FND_API.G_FALSE,

Line 705: FND_MSG_PUB.Count_And_Get (

701: THEN
702: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
703: END IF;
704: -- Standard call to get message count and if count=1, get the message
705: FND_MSG_PUB.Count_And_Get (
706: p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data
709: );

Line 1413: FND_MSG_PUB.initialize;

1409:
1410: -- Initialize message list if p_init_msg_list is set to TRUE.
1411: IF FND_API.to_Boolean( p_init_msg_list )
1412: THEN
1413: FND_MSG_PUB.initialize;
1414: END IF;
1415: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1416: Check_ae_header_Items(
1417: p_ae_header_rec => p_ae_header_rec,

Line 1467: FND_MSG_PUB.Count_And_Get

1463: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1464: END IF;
1465:
1466: -- Standard call to get message count and if count is 1, get message info.
1467: FND_MSG_PUB.Count_And_Get
1468: (p_count => x_msg_count,
1469: p_data => x_msg_data
1470: );
1471: EXCEPTION

Line 1481: FND_MSG_PUB.Count_And_Get (

1477: WHEN FND_API.G_EXC_ERROR THEN
1478: ROLLBACK TO VALIDATE_Ae_Header_;
1479: x_return_status := FND_API.G_RET_STS_ERROR;
1480: -- Standard call to get message count and if count=1, get the message
1481: FND_MSG_PUB.Count_And_Get (
1482: p_encoded => FND_API.G_FALSE,
1483: p_count => x_msg_count,
1484: p_data => x_msg_data
1485: );

Line 1491: FND_MSG_PUB.Count_And_Get (

1487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1488: ROLLBACK TO VALIDATE_Ae_Header_;
1489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1490: -- Standard call to get message count and if count=1, get the message
1491: FND_MSG_PUB.Count_And_Get (
1492: p_encoded => FND_API.G_FALSE,
1493: p_count => x_msg_count,
1494: p_data => x_msg_data
1495: );

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

1496:
1497: WHEN OTHERS THEN
1498: ROLLBACK TO VALIDATE_Ae_Header_;
1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1501: THEN
1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1503: END IF;
1504: -- Standard call to get message count and if count=1, get the message

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

1498: ROLLBACK TO VALIDATE_Ae_Header_;
1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1501: THEN
1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1503: END IF;
1504: -- Standard call to get message count and if count=1, get the message
1505: FND_MSG_PUB.Count_And_Get (
1506: p_encoded => FND_API.G_FALSE,

Line 1505: FND_MSG_PUB.Count_And_Get (

1501: THEN
1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1503: END IF;
1504: -- Standard call to get message count and if count=1, get the message
1505: FND_MSG_PUB.Count_And_Get (
1506: p_encoded => FND_API.G_FALSE,
1507: p_count => x_msg_count,
1508: p_data => x_msg_data
1509: );

Line 1526: FND_MSG_PUB.initialize;

1522: BEGIN
1523: -- Initialize message list if p_init_msg_list is set to TRUE.
1524: IF FND_API.to_Boolean( p_init_msg_list )
1525: THEN
1526: FND_MSG_PUB.initialize;
1527: END IF;
1528:
1529: -- Initialize API return status to SUCCESS
1530: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1542: FND_MSG_PUB.Count_And_Get

1538: IF g_debug THEN
1539: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1540: END IF;
1541: -- Standard call to get message count and if count is 1, get message info.
1542: FND_MSG_PUB.Count_And_Get
1543: (p_count => x_msg_count,
1544: p_data => x_msg_data
1545: );
1546: END Validate_ae_header_Rec;