DBA Data[Home] [Help]

APPS.AMS_PARTY_SEG_LOADER_PVT dependencies on FND_MSG_PUB

Line 24: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

20: -- no longer valid in Hornet.
21: --
22: -- 08/30/2001 yxliu Modified, use buck update
23: -------------------------------------------------------------------------------
24: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
25: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
26: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
27:
28: PROCEDURE Get_Party_Tab

Line 25: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

21: --
22: -- 08/30/2001 yxliu Modified, use buck update
23: -------------------------------------------------------------------------------
24: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
25: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
26: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
27:
28: PROCEDURE Get_Party_Tab
29: (

Line 26: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

22: -- 08/30/2001 yxliu Modified, use buck update
23: -------------------------------------------------------------------------------
24: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
25: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
26: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
27:
28: PROCEDURE Get_Party_Tab
29: (
30: p_cell_id IN NUMBER,

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

140: END IF;
141:
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
143:
144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148:

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

142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
143:
144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148:
149: FND_MSG_PUB.Count_AND_Get
150: ( p_count => x_msg_count,

Line 149: FND_MSG_PUB.Count_AND_Get

145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148:
149: FND_MSG_PUB.Count_AND_Get
150: ( p_count => x_msg_count,
151: p_data => x_msg_data,
152: p_encoded => FND_API.G_FALSE
153: );

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

224: CLOSE C_expired_party_ids;
225: END IF;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227:
228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
229: THEN
230: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
231: END IF;
232:

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

226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227:
228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
229: THEN
230: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
231: END IF;
232:
233: FND_MSG_PUB.Count_AND_Get
234: ( p_count => x_msg_count,

Line 233: FND_MSG_PUB.Count_AND_Get

229: THEN
230: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
231: END IF;
232:
233: FND_MSG_PUB.Count_AND_Get
234: ( p_count => x_msg_count,
235: p_data => x_msg_data,
236: p_encoded => FND_API.G_FALSE
237: );

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

334: END IF;
335:
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
337:
338: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
339: THEN
340: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
341: END IF;
342:

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

336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
337:
338: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
339: THEN
340: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
341: END IF;
342:
343: FND_MSG_PUB.Count_AND_Get
344: ( p_count => x_msg_count,

Line 343: FND_MSG_PUB.Count_AND_Get

339: THEN
340: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
341: END IF;
342:
343: FND_MSG_PUB.Count_AND_Get
344: ( p_count => x_msg_count,
345: p_data => x_msg_data,
346: p_encoded => FND_API.G_FALSE
347: );

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

491: END IF;
492:
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
494:
495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499:

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

493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
494:
495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499:
500: FND_MSG_PUB.Count_AND_Get
501: ( p_count => x_msg_count,

Line 500: FND_MSG_PUB.Count_AND_Get

496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499:
500: FND_MSG_PUB.Count_AND_Get
501: ( p_count => x_msg_count,
502: p_data => x_msg_data,
503: p_encoded => FND_API.G_FALSE
504: );

Line 688: FND_MSG_PUB.count_and_get (

684: EXCEPTION
685: WHEN FND_API.g_exc_unexpected_error THEN
686: ROLLBACK TO Load_Party_Seg;
687: x_return_status := FND_API.g_ret_sts_unexp_error ;
688: FND_MSG_PUB.count_and_get (
689: p_encoded => FND_API.g_false,
690: p_count => x_msg_count,
691: p_data => x_msg_data
692: );

Line 697: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

693: WHEN OTHERS THEN
694: ROLLBACK TO Load_Party_Seg;
695: x_return_status := FND_API.g_ret_sts_unexp_error ;
696:
697: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
698: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
699: END IF;
700:
701: FND_MSG_PUB.count_and_get (

Line 698: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

694: ROLLBACK TO Load_Party_Seg;
695: x_return_status := FND_API.g_ret_sts_unexp_error ;
696:
697: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
698: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
699: END IF;
700:
701: FND_MSG_PUB.count_and_get (
702: p_encoded => FND_API.g_false,

Line 701: FND_MSG_PUB.count_and_get (

697: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
698: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
699: END IF;
700:
701: FND_MSG_PUB.count_and_get (
702: p_encoded => FND_API.g_false,
703: p_count => x_msg_count,
704: p_data => x_msg_data
705: );

Line 767: FND_MSG_PUB.count_and_get (

763: );
764:
765: IF x_return_status = FND_API.g_ret_sts_error THEN
766: x_return_status := FND_API.g_ret_sts_error ;
767: FND_MSG_PUB.count_and_get (
768: p_encoded => FND_API.g_false,
769: p_count => x_msg_count,
770: p_data => x_msg_data
771: );

Line 775: FND_MSG_PUB.count_and_get (

771: );
772: failed_flag := 'Y';
773: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
774: x_return_status := FND_API.g_ret_sts_unexp_error ;
775: FND_MSG_PUB.count_and_get (
776: p_encoded => FND_API.g_false,
777: p_count => x_msg_count,
778: p_data => x_msg_data
779: );

Line 806: FND_MSG_PUB.count_and_get (

802: );
803:
804: IF x_return_status = FND_API.g_ret_sts_error THEN
805: x_return_status := FND_API.g_ret_sts_error ;
806: FND_MSG_PUB.count_and_get (
807: p_encoded => FND_API.g_false,
808: p_count => x_msg_count,
809: p_data => x_msg_data
810: );

Line 814: FND_MSG_PUB.count_and_get (

810: );
811: failed_flag := 'Y';
812: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
813: x_return_status := FND_API.g_ret_sts_unexp_error ;
814: FND_MSG_PUB.count_and_get (
815: p_encoded => FND_API.g_false,
816: p_count => x_msg_count,
817: p_data => x_msg_data
818: );

Line 857: FND_MSG_PUB.initialize;

853: l_return_status VARCHAR2(1) ;
854: l_msg_count NUMBER ;
855: l_msg_data VARCHAR2(2000);
856: BEGIN
857: FND_MSG_PUB.initialize;
858: -- Call the procedure to refresh Segment
859: Load_Party_Seg
860: ( p_cell_id => p_cell_id,
861: x_return_status => l_return_status,