DBA Data[Home] [Help]

APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_SOURCECODE_PVT

Line 494: EXIT WHEN AMS_SourceCode_PVT.is_source_code_unique (l_source_code) = FND_API.g_true;

490: -- Update the generate code with the new
491: -- upper limit of the numeric sequence.
492: LOOP
493: l_source_code := p_campaign_source_code || l_suffix || TO_CHAR(l_seq + 1) ;
494: EXIT WHEN AMS_SourceCode_PVT.is_source_code_unique (l_source_code) = FND_API.g_true;
495: l_seq := l_seq + 1 ;
496: END LOOP;
497:
498: UPDATE ams_generated_codes gde

Line 563: --x_source_code := AMS_SourceCode_PVT.get_new_source_code(

559: END IF;
560: ELSE
561: IF p_source_code IS NULL THEN
562: l_dummy_src_code := Generate_Schedule_Code(l_source_code,p_setup_id);
563: --x_source_code := AMS_SourceCode_PVT.get_new_source_code(
564: -- 'CSCH', p_setup_id, l_global_flag);
565: --anchaudh bug fix 3861594 starts
566: IF(length(l_dummy_src_code) > 30) THEN
567: x_return_status := FND_API.g_ret_sts_error;

Line 571: --x_source_code := AMS_SourceCode_PVT.get_new_source_code(

567: x_return_status := FND_API.g_ret_sts_error;
568: AMS_Utility_PVT.error_message('AMS_CSCH_SRC_CODE_ERROR');
569: ELSE
570: x_source_code := l_dummy_src_code; --Generate_Schedule_Code(l_source_code,p_setup_id);
571: --x_source_code := AMS_SourceCode_PVT.get_new_source_code(
572: -- 'CSCH', p_setup_id, l_global_flag);
573: END IF;
574: --anchaudh bug fix 3861594 ends
575: ELSIF AMS_SourceCode_PVT.is_source_code_unique(p_source_code) = FND_API.g_false

Line 575: ELSIF AMS_SourceCode_PVT.is_source_code_unique(p_source_code) = FND_API.g_false

571: --x_source_code := AMS_SourceCode_PVT.get_new_source_code(
572: -- 'CSCH', p_setup_id, l_global_flag);
573: END IF;
574: --anchaudh bug fix 3861594 ends
575: ELSIF AMS_SourceCode_PVT.is_source_code_unique(p_source_code) = FND_API.g_false
576: THEN
577: x_return_status := FND_API.g_ret_sts_error;
578: AMS_Utility_PVT.error_message('AMS_CAMP_DUPLICATE_CODE');
579: END IF;

Line 612: AMS_SourceCode_PVT.Create_SourceCode(

608: l_msg_data VARCHAR2(2000);
609:
610: BEGIN
611:
612: AMS_SourceCode_PVT.Create_SourceCode(
613: p_api_version => 1.0,
614: p_init_msg_list => FND_API.g_false,
615: p_commit => FND_API.g_false,
616: p_validation_level => FND_API.g_valid_level_full,

Line 758: AMS_SourceCode_PVT.revoke_sourcecode(

754:
755: AMS_Utility_PVT.debug_message('Revoke Source Code ');
756:
757: END IF;
758: AMS_SourceCode_PVT.revoke_sourcecode(
759: p_api_version => 1.0,
760: p_init_msg_list => FND_API.g_false,
761: p_commit => FND_API.g_false,
762: p_validation_level => FND_API.g_valid_level_full,

Line 782: AMS_SourceCode_PVT.create_sourcecode(

778:
779: AMS_Utility_PVT.debug_message('Create Source Code ');
780:
781: END IF;
782: AMS_SourceCode_PVT.create_sourcecode(
783: p_api_version => 1.0,
784: p_init_msg_list => FND_API.g_false,
785: p_commit => FND_API.g_false,
786: p_validation_level => FND_API.g_valid_level_full,

Line 951: AMS_SourceCode_PVT.revoke_sourcecode(

947: IF (AMS_DEBUG_HIGH_ON) THEN
948:
949: AMS_Utility_PVT.debug_message('revoke previous, and put campaign source code');
950: END IF;
951: AMS_SourceCode_PVT.revoke_sourcecode(
952: p_api_version => 1.0,
953: p_init_msg_list => FND_API.g_false,
954: p_commit => FND_API.g_false,
955: p_validation_level => FND_API.g_valid_level_full,

Line 1009: AMS_SourceCode_PVT.revoke_sourcecode(

1005: IF (AMS_DEBUG_HIGH_ON) THEN
1006:
1007: AMS_Utility_PVT.debug_message('Revoke Source Code '||p_sch_source_code);
1008: END IF;
1009: AMS_SourceCode_PVT.revoke_sourcecode(
1010: p_api_version => 1.0,
1011: p_init_msg_list => FND_API.g_false,
1012: p_commit => FND_API.g_false,
1013: p_validation_level => FND_API.g_valid_level_full,

Line 1060: IF AMS_SourceCode_PVT.is_source_code_unique(p_schedule_rec.source_code) = FND_API.g_false

1056: IF (AMS_DEBUG_HIGH_ON) THEN
1057:
1058: AMS_Utility_PVT.debug_message('is it unique? '||p_schedule_rec.source_code);
1059: END IF;
1060: IF AMS_SourceCode_PVT.is_source_code_unique(p_schedule_rec.source_code) = FND_API.g_false
1061: THEN
1062: -- if not unique
1063: x_return_status := FND_API.g_ret_sts_error;
1064: AMS_Utility_PVT.error_message('AMS_CAMP_DUPLICATE_CODE');

Line 1075: AMS_SourceCode_PVT.revoke_sourcecode(

1071: IF (AMS_DEBUG_HIGH_ON) THEN
1072:
1073: AMS_Utility_PVT.debug_message('Revoke Source Code '||p_sch_source_code);
1074: END IF;
1075: AMS_SourceCode_PVT.revoke_sourcecode(
1076: p_api_version => 1.0,
1077: p_init_msg_list => FND_API.g_false,
1078: p_commit => FND_API.g_false,
1079: p_validation_level => FND_API.g_valid_level_full,