DBA Data[Home] [Help]

APPS.AMS_LIST_PURGE_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: -- 12/12/2001 yxliu add logic to purge ams_list_entries
21: -- add parameter force_purge_flag
22: -- 01/10/2002 yxliu add delete cancelled imp list headers
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 Purge_Expired_List_Headers

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

21: -- add parameter force_purge_flag
22: -- 01/10/2002 yxliu add delete cancelled imp list headers
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 Purge_Expired_List_Headers
29: (

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

22: -- 01/10/2002 yxliu add delete cancelled imp list headers
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 Purge_Expired_List_Headers
29: (
30: force_purge_flag IN VARCHAR2 := FND_API.g_false,

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

532: CLOSE c_all_imp_list_rec;
533: END IF;
534: ROLLBACK TO Purge_Expired_List_Header;
535: x_return_status := FND_API.g_ret_sts_unexp_error;
536: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
537: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_ERR_PURGE');
538: FND_MSG_PUB.add;
539: END IF;
540:

Line 538: FND_MSG_PUB.add;

534: ROLLBACK TO Purge_Expired_List_Header;
535: x_return_status := FND_API.g_ret_sts_unexp_error;
536: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
537: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_ERR_PURGE');
538: FND_MSG_PUB.add;
539: END IF;
540:
541: END Purge_Expired_List_Headers;
542:

Line 570: FND_MSG_PUB.initialize;

566: l_msg_count NUMBER ;
567: l_msg_data VARCHAR2(2000);
568: BEGIN
569:
570: FND_MSG_PUB.initialize;
571: -- Call the procedure to purge expired list headers
572:
573: Purge_Expired_List_Headers
574: ( force_purge_flag => force_purge_flag,

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

767: CLOSE c_all_target_rec;
768: END IF;
769: ROLLBACK TO Purge_Purged_Target;
770: x_return_status := FND_API.g_ret_sts_unexp_error;
771: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
772: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_ERR_PURGE');
773: FND_MSG_PUB.add;
774: END IF;
775:

Line 773: FND_MSG_PUB.add;

769: ROLLBACK TO Purge_Purged_Target;
770: x_return_status := FND_API.g_ret_sts_unexp_error;
771: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
772: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_ERR_PURGE');
773: FND_MSG_PUB.add;
774: END IF;
775:
776: END Purge_Purged_Target;
777:

Line 803: FND_MSG_PUB.initialize;

799: l_msg_count NUMBER ;
800: l_msg_data VARCHAR2(2000);
801: BEGIN
802:
803: FND_MSG_PUB.initialize;
804: -- Call the procedure to purge purged target
805:
806: Purge_Purged_Target
807: ( x_return_status => l_return_status,

Line 880: FND_MSG_PUB.initialize;

876:
877: END IF;
878:
879: IF FND_API.to_boolean(p_init_msg_list) THEN
880: FND_MSG_PUB.initialize;
881: END IF;
882:
883: IF NOT FND_API.compatible_api_call(
884: l_api_version,

Line 927: FND_MSG_PUB.count_and_get(

923: IF FND_API.to_boolean(p_commit) THEN
924: COMMIT;
925: END IF;
926:
927: FND_MSG_PUB.count_and_get(
928: p_encoded => FND_API.g_false,
929: p_count => x_msg_count,
930: p_data => x_msg_data
931: );

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

950: END IF;
951:
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
953:
954: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
955: THEN
956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
957: END IF;
958: FND_MSG_PUB.Count_AND_Get

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

952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
953:
954: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
955: THEN
956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
957: END IF;
958: FND_MSG_PUB.Count_AND_Get
959: ( p_count => x_msg_count,
960: p_data => x_msg_data,

Line 958: FND_MSG_PUB.Count_AND_Get

954: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
955: THEN
956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
957: END IF;
958: FND_MSG_PUB.Count_AND_Get
959: ( p_count => x_msg_count,
960: p_data => x_msg_data,
961: p_encoded => FND_API.G_FALSE
962: );