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_THRESHOLD_PVT dependencies on FND_MSG_PUB

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

29: -- ===============================================================
30:
31: G_PKG_NAME CONSTANT VARCHAR2(20) :='OZF_THRESHOLD_PVT';
32: G_FILE_NAME CONSTANT VARCHAR2(20) :='ozfvtreb.pls';
33: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
34:
35:
36: PROCEDURE start_process(
37: p_api_version_number IN NUMBER

Line 106: FND_MSG_PUB.Count_And_Get (

102:
103: WHEN FND_API.G_EXC_ERROR THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: -- Standard call to get message count and if count=1, get the message
106: FND_MSG_PUB.Count_And_Get (
107: p_encoded => FND_API.G_FALSE,
108: p_count => x_msg_count,
109: p_data => x_msg_data
110: );

Line 115: FND_MSG_PUB.Count_And_Get (

111:
112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: -- Standard call to get message count and if count=1, get the message
115: FND_MSG_PUB.Count_And_Get (
116: p_encoded => FND_API.G_FALSE,
117: p_count => x_msg_count,
118: p_data => x_msg_data
119: );

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

119: );
120:
121: WHEN OTHERS THEN
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
124: THEN
125: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
126: END IF;
127: -- Standard call to get message count and if count=1, get the message

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

121: WHEN OTHERS THEN
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
124: THEN
125: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
126: END IF;
127: -- Standard call to get message count and if count=1, get the message
128: FND_MSG_PUB.Count_And_Get (
129: p_encoded => FND_API.G_FALSE,

Line 128: FND_MSG_PUB.Count_And_Get (

124: THEN
125: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
126: END IF;
127: -- Standard call to get message count and if count=1, get the message
128: FND_MSG_PUB.Count_And_Get (
129: p_encoded => FND_API.G_FALSE,
130: p_count => x_msg_count,
131: p_data => x_msg_data
132: );

Line 259: -- FND_MSG_PUB.initialize;

255:
256: -- Initialize message list if p_init_msg_list is set to TRUE.
257: -- IF FND_API.to_Boolean( p_init_msg_list )
258: -- THEN
259: -- FND_MSG_PUB.initialize;
260: -- END IF;
261:
262: -- Debug Message
263: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 350: FND_MSG_PUB.Count_And_Get

346:
347: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
348:
349: -- Standard call to get message count and if count is 1, get message info.
350: FND_MSG_PUB.Count_And_Get
351: (p_count => x_msg_count,
352: p_data => x_msg_data
353: );
354: EXCEPTION

Line 359: FND_MSG_PUB.Count_And_Get (

355:
356: WHEN FND_API.G_EXC_ERROR THEN
357: x_return_status := FND_API.G_RET_STS_ERROR;
358: -- Standard call to get message count and if count=1, get the message
359: FND_MSG_PUB.Count_And_Get (
360: -- p_encoded => FND_API.G_FALSE,
361: p_count => x_msg_count,
362: p_data => x_msg_data
363: );

Line 368: FND_MSG_PUB.Count_And_Get (

364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: -- Standard call to get message count and if count=1, get the message
368: FND_MSG_PUB.Count_And_Get (
369: --p_encoded => FND_API.G_FALSE,
370: p_count => x_msg_count,
371: p_data => x_msg_data
372: );

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

372: );
373:
374: WHEN OTHERS THEN
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
377: THEN
378: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
379: END IF;
380: -- Standard call to get message count and if count=1, get the message

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

374: WHEN OTHERS THEN
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
377: THEN
378: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
379: END IF;
380: -- Standard call to get message count and if count=1, get the message
381: FND_MSG_PUB.Count_And_Get (
382: -- p_encoded => FND_API.G_FALSE,

Line 381: FND_MSG_PUB.Count_And_Get (

377: THEN
378: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
379: END IF;
380: -- Standard call to get message count and if count=1, get the message
381: FND_MSG_PUB.Count_And_Get (
382: -- p_encoded => FND_API.G_FALSE,
383: p_count => x_msg_count,
384: p_data => x_msg_data
385: );

Line 469: FND_MSG_PUB.initialize;

465:
466: -- Initialize message list if p_init_msg_list is set to TRUE.
467: IF FND_API.to_Boolean( p_init_msg_list )
468: THEN
469: FND_MSG_PUB.initialize;
470: END IF;
471:
472: -- Debug Message
473: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 556: FND_MSG_PUB.Count_And_Get

552:
553: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
554:
555: -- Standard call to get message count and if count is 1, get message info.
556: FND_MSG_PUB.Count_And_Get
557: (p_count => x_msg_count,
558: p_data => x_msg_data
559: );
560: EXCEPTION

Line 565: FND_MSG_PUB.Count_And_Get (

561:
562: WHEN FND_API.G_EXC_ERROR THEN
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: -- Standard call to get message count and if count=1, get the message
565: FND_MSG_PUB.Count_And_Get (
566: p_encoded => FND_API.G_FALSE,
567: p_count => x_msg_count,
568: p_data => x_msg_data
569: );

Line 574: FND_MSG_PUB.Count_And_Get (

570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573: -- Standard call to get message count and if count=1, get the message
574: FND_MSG_PUB.Count_And_Get (
575: p_encoded => FND_API.G_FALSE,
576: p_count => x_msg_count,
577: p_data => x_msg_data
578: );

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

578: );
579:
580: WHEN OTHERS THEN
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
583: THEN
584: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
585: END IF;
586: -- Standard call to get message count and if count=1, get the message

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

580: WHEN OTHERS THEN
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
583: THEN
584: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
585: END IF;
586: -- Standard call to get message count and if count=1, get the message
587: FND_MSG_PUB.Count_And_Get (
588: p_encoded => FND_API.G_FALSE,

Line 587: FND_MSG_PUB.Count_And_Get (

583: THEN
584: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
585: END IF;
586: -- Standard call to get message count and if count=1, get the message
587: FND_MSG_PUB.Count_And_Get (
588: p_encoded => FND_API.G_FALSE,
589: p_count => x_msg_count,
590: p_data => x_msg_data
591: );

Line 628: FND_MSG_PUB.initialize;

624:
625: -- Initialize message list if p_init_msg_list is set to TRUE.
626: IF FND_API.to_Boolean( p_init_msg_list )
627: THEN
628: FND_MSG_PUB.initialize;
629: END IF;
630:
631: -- Debug Message
632: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 667: FND_MSG_PUB.Count_And_Get

663:
664: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
665:
666: -- Standard call to get message count and if count is 1, get message info.
667: FND_MSG_PUB.Count_And_Get
668: (p_count => x_msg_count,
669: p_data => x_msg_data
670: );
671:

Line 677: FND_MSG_PUB.Count_And_Get (

673:
674: WHEN FND_API.G_EXC_ERROR THEN
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,
680: p_data => x_msg_data
681: );

Line 686: FND_MSG_PUB.Count_And_Get (

682:
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: -- Standard call to get message count and if count=1, get the message
686: FND_MSG_PUB.Count_And_Get (
687: p_encoded => FND_API.G_FALSE,
688: p_count => x_msg_count,
689: p_data => x_msg_data
690: );

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

690: );
691:
692: WHEN OTHERS THEN
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
694: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
695: THEN
696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
697: END IF;
698: -- Standard call to get message count and if count=1, get the message

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

692: WHEN OTHERS THEN
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
694: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
695: THEN
696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
697: END IF;
698: -- Standard call to get message count and if count=1, get the message
699: FND_MSG_PUB.Count_And_Get (
700: p_encoded => FND_API.G_FALSE,

Line 699: FND_MSG_PUB.Count_And_Get (

695: THEN
696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
697: END IF;
698: -- Standard call to get message count and if count=1, get the message
699: FND_MSG_PUB.Count_And_Get (
700: p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,
702: p_data => x_msg_data
703: );

Line 771: FND_MSG_PUB.initialize;

767:
768: -- Initialize message list if p_init_msg_list is set to TRUE.
769: IF FND_API.to_Boolean( p_init_msg_list )
770: THEN
771: FND_MSG_PUB.initialize;
772: END IF;
773:
774: -- Debug Message
775: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 826: FND_MSG_PUB.Count_And_Get

822: OZF_UTILITY_PVT.debug_message('Private API: Notified day' || l_notify_freq_days || ' end ' ||x_result );
823: END IF;
824:
825: -- Standard call to get message count and if count is 1, get message info.
826: FND_MSG_PUB.Count_And_Get
827: (p_count => x_msg_count,
828: p_data => x_msg_data
829: );
830: EXCEPTION

Line 835: FND_MSG_PUB.Count_And_Get (

831:
832: WHEN FND_API.G_EXC_ERROR THEN
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: -- Standard call to get message count and if count=1, get the message
835: FND_MSG_PUB.Count_And_Get (
836: p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data
839: );

Line 844: FND_MSG_PUB.Count_And_Get (

840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843: -- Standard call to get message count and if count=1, get the message
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,
846: p_count => x_msg_count,
847: p_data => x_msg_data
848: );

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

848: );
849:
850: WHEN OTHERS THEN
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
853: THEN
854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
855: END IF;
856: -- Standard call to get message count and if count=1, get the message

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

850: WHEN OTHERS THEN
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
853: THEN
854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
855: END IF;
856: -- Standard call to get message count and if count=1, get the message
857: FND_MSG_PUB.Count_And_Get (
858: p_encoded => FND_API.G_FALSE,

Line 857: FND_MSG_PUB.Count_And_Get (

853: THEN
854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
855: END IF;
856: -- Standard call to get message count and if count=1, get the message
857: FND_MSG_PUB.Count_And_Get (
858: p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data
861: );