APPS.AMS_CAMP_SCHEDULE_PVT dependencies on JTF_PLSQL_API

Line 384: p_validation_mode => JTF_PLSQL_API.g_create,

380: p_api_version_number => 1.0,
381: p_init_msg_list => FND_API.G_FALSE,
382: p_validation_level => p_validation_level,
383: p_schedule_rec => l_schedule_rec,
384: p_validation_mode => JTF_PLSQL_API.g_create,
385: x_return_status => x_return_status,
386: x_msg_count => x_msg_count,
387: x_msg_data => x_msg_data);
388: END IF;

Line 1095: p_validation_mode => JTF_PLSQL_API.g_update,

1091: p_api_version_number => 1.0,
1092: p_init_msg_list => FND_API.G_FALSE,
1093: p_validation_level => p_validation_level,
1094: p_schedule_rec => p_schedule_rec,
1095: p_validation_mode => JTF_PLSQL_API.g_update,
1096: x_return_status => x_return_status,
1097: x_msg_count => x_msg_count,
1098: x_msg_data => x_msg_data);
1099: END IF;

Line 1783: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1779: -- 22-Jan-2001 PTENDULK Created
1780: --===================================================================
1781: PROCEDURE Check_Schedule_Uk_Items(
1782: p_schedule_rec IN schedule_rec_type,
1783: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1784: x_return_status OUT NOCOPY VARCHAR2)
1785: IS
1786: l_valid_flag VARCHAR2(1);
1787:

Line 1791: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1787:
1788: BEGIN
1789: x_return_status := FND_API.g_ret_sts_success;
1790:
1791: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1792: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1793: 'ams_campaign_schedules_b',
1794: 'schedule_id = ' || p_schedule_rec.schedule_id
1795: );

Line 1804: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1800: END IF;
1801: END IF;
1802:
1803: -- added by soagrawa on 11-jan-2002
1804: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1805: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1806: 'ams_campaign_schedules_b',
1807: 'related_event_id = ' || p_schedule_rec.related_event_id
1808: );

Line 1832: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1828: -- 22-Jan-2001 PTENDULK Created
1829: --===================================================================
1830: PROCEDURE Check_Schedule_Req_Items(
1831: p_schedule_rec IN schedule_rec_type,
1832: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1833: x_return_status OUT NOCOPY VARCHAR2
1834: )
1835: IS
1836: BEGIN

Line 1839: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1835: IS
1836: BEGIN
1837: x_return_status := FND_API.g_ret_sts_success;
1838:
1839: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1840:
1841: IF p_schedule_rec.campaign_id = FND_API.g_miss_num OR p_schedule_rec.campaign_id IS NULL THEN
1842: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CAMP_ID') ;
1843: x_return_status := FND_API.g_ret_sts_error;

Line 2938: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2934: THEN
2935: FND_MSG_PUB.initialize;
2936: END IF;
2937:
2938: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2939: Check_schedule_Items(
2940: p_schedule_rec => p_schedule_rec,
2941: p_validation_mode => JTF_PLSQL_API.g_update,
2942: x_return_status => x_return_status

Line 2941: p_validation_mode => JTF_PLSQL_API.g_update,

2937:
2938: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2939: Check_schedule_Items(
2940: p_schedule_rec => p_schedule_rec,
2941: p_validation_mode => JTF_PLSQL_API.g_update,
2942: x_return_status => x_return_status
2943: );
2944:
2945: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2952: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

2948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2949: END IF;
2950: END IF;
2951:
2952: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
2953: IF (AMS_DEBUG_HIGH_ON) THEN
2954:
2955: AMS_Utility_PVT.debug_message('After Item validation');
2956: END IF;

Line 2970: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

2966:
2967: AMS_Utility_PVT.debug_message('Rec Level Validation');
2968:
2969: END IF;
2970: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
2971: Validate_schedule_Rec(
2972: p_api_version_number => 1.0,
2973: p_init_msg_list => FND_API.G_FALSE,
2974: x_return_status => x_return_status,

Line 2993: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

2989:
2990: AMS_Utility_PVT.debug_message('Inter Entity Level Validation');
2991:
2992: END IF;
2993: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
2994: Check_Schedule_Inter_Entity(
2995: p_schedule_rec => p_schedule_rec,
2996: p_complete_rec => l_schedule_rec,
2997: p_validation_mode => p_validation_mode,

Line 3271: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

3267:
3268: -- Check the campaign
3269: -- No schedules can be added to campaigns in Archieved ,cancelled ,completed campaigns or on hold campaigns
3270: -- Campaign - Schedule rule 1
3271: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
3272: OPEN c_camp_status ;
3273: FETCH c_camp_status INTO l_status_code,l_rollup_type ;
3274: CLOSE c_camp_status ;
3275:

Line 3389: --IF p_validation_mode = JTF_PLSQL_API.g_update THEN

3385: --l_table_name := 'ams_campaign_schedules_vl' ;
3386: --l_where_clause := 'campaign_id = '||p_complete_rec.campaign_id ;
3387: --l_where_clause := l_where_clause || ' AND UPPER(schedule_name) = '''||UPPER(p_complete_rec.schedule_name)||'''' ;
3388:
3389: --IF p_validation_mode = JTF_PLSQL_API.g_update THEN
3390: -- l_where_clause := l_where_clause || ' AND schedule_id <> '||p_complete_rec.schedule_id ;
3391: --END IF ;
3392:
3393: --l_valid_flag := AMS_Utility_PVT.check_uniqueness( p_table_name => l_table_name,

Line 3400: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

3396: -- AMS_Utility_PVT.Error_Message('AMS_CSCH_DUPLICATE_ID');
3397: -- x_return_status := FND_API.g_ret_sts_error;
3398: -- RETURN;
3399: --END IF;
3400: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
3401: OPEN c_sch_name_updt;
3402: FETCH c_sch_name_updt INTO l_dummy ;
3403: CLOSE c_sch_name_updt ;
3404: ELSE