DBA Data[Home] [Help]

APPS.AMS_CAMPAIGNRULES_PVT dependencies on FND_MSG_PUB

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

3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):='AMS_CampaignRules_PVT';
6:
7: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
8: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
9: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10:
11: PROCEDURE Archive_Schedules(

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

4:
5: g_pkg_name CONSTANT VARCHAR2(30):='AMS_CampaignRules_PVT';
6:
7: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
8: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
9: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10:
11: PROCEDURE Archive_Schedules(
12: p_campaign_id IN NUMBER

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

5: g_pkg_name CONSTANT VARCHAR2(30):='AMS_CampaignRules_PVT';
6:
7: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
8: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
9: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10:
11: PROCEDURE Archive_Schedules(
12: p_campaign_id IN NUMBER
13: );

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

635: OPEN c_camp;
636: FETCH c_camp INTO l_camp_rec;
637: IF c_camp%NOTFOUND THEN
638: CLOSE c_camp;
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
640: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
641: FND_MSG_PUB.add;
642: END IF;
643: RAISE FND_API.g_exc_error;

Line 641: FND_MSG_PUB.add;

637: IF c_camp%NOTFOUND THEN
638: CLOSE c_camp;
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
640: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
641: FND_MSG_PUB.add;
642: END IF;
643: RAISE FND_API.g_exc_error;
644: END IF;
645: CLOSE c_camp;

Line 1353: FND_MSG_PUB.add;

1349: l_parent_status_code := AMS_Utility_PVT.get_system_status_code(l_old_status_id);
1350:
1351: If p_status_code = 'ACTIVE' and l_parent_status_code <> 'ACTIVE' THEN
1352: FND_MESSAGE.set_name('AMS', 'AMS_PROGRAM_NOT_ACTIVE');
1353: FND_MSG_PUB.add;
1354: RAISE FND_API.g_exc_error;
1355: END IF;
1356:
1357: END check_camp_status_vs_parent;

Line 2021: -- FND_MSG_PUB.add;

2017:
2018: -- -- cannot update to null
2019: -- IF p_csch_rec.source_code IS NULL THEN
2020: -- FND_MESSAGE.set_name('AMS', 'AMS_CAMP_NO_SOURCE_CODE');
2021: -- FND_MSG_PUB.add;
2022: -- END IF;
2023: --
2024: -- -- query the campaign_id and the old source_code
2025: -- OPEN c_csch;

Line 2029: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2025: -- OPEN c_csch;
2026: -- FETCH c_csch INTO l_camp_id, l_source_code;
2027: -- IF c_csch%NOTFOUND THEN
2028: -- CLOSE c_csch;
2029: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2030: -- FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2031: -- FND_MSG_PUB.add;
2032: -- END IF;
2033: -- RAISE FND_API.g_exc_error;

Line 2031: -- FND_MSG_PUB.add;

2027: -- IF c_csch%NOTFOUND THEN
2028: -- CLOSE c_csch;
2029: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2030: -- FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2031: -- FND_MSG_PUB.add;
2032: -- END IF;
2033: -- RAISE FND_API.g_exc_error;
2034: -- END IF;
2035: -- CLOSE c_csch;