eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_UTILITY_PVT

Line 87: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_USER_STATUS');

83: CLOSE c_status_code;
84:
85: IF l_status_code IS NULL THEN
86: x_return_status := FND_API.g_ret_sts_error;
87: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_USER_STATUS');
88: END IF;
89:
90: x_status_code := l_status_code;
91:

Line 548: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_ID');

544: FETCH c_camp INTO l_source_code, l_global_flag;
545: IF c_camp%NOTFOUND THEN -- campaign_id is invalid
546: CLOSE c_camp;
547: x_return_status := FND_API.g_ret_sts_error;
548: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_ID');
549: RAISE FND_API.g_exc_error;
550: END IF;
551: CLOSE c_camp;
552:

Line 558: AMS_Utility_PVT.error_message('AMS_CSCH_CODE_NOT_CASCADE');

554: IF p_source_code IS NULL THEN
555: x_source_code := l_source_code;
556: ELSIF p_source_code <> l_source_code THEN
557: x_return_status := FND_API.g_ret_sts_error;
558: AMS_Utility_PVT.error_message('AMS_CSCH_CODE_NOT_CASCADE');
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);

Line 568: AMS_Utility_PVT.error_message('AMS_CSCH_SRC_CODE_ERROR');

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;
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);

Line 578: AMS_Utility_PVT.error_message('AMS_CAMP_DUPLICATE_CODE');

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;
580: END IF;
581:
582: END Handle_Schedule_Source_Code;

Line 687: AMS_Utility_PVT.debug_message('Check Source Code ');

683:
684: BEGIN
685: IF (AMS_DEBUG_HIGH_ON) THEN
686:
687: AMS_Utility_PVT.debug_message('Check Source Code ');
688: END IF;
689: x_return_status := FND_API.g_ret_sts_success;
690:
691: -- cannot update to null

Line 693: AMS_Utility_PVT.Error_Message('AMS_CAMP_NO_SOURCE_CODE');

689: x_return_status := FND_API.g_ret_sts_success;
690:
691: -- cannot update to null
692: IF p_schedule_rec.source_code IS NULL THEN
693: AMS_Utility_PVT.Error_Message('AMS_CAMP_NO_SOURCE_CODE');
694: RAISE FND_API.g_exc_error;
695: END IF;
696:
697: -- query the campaign_id and the old source_code

Line 720: AMS_Utility_PVT.error_message('AMS_CSCH_CODE_NOT_CASCADE');

716:
717: -- check if source code is cascaded from campaign
718: IF l_cascade_flag = 'Y' THEN
719: x_return_status := FND_API.g_ret_sts_error;
720: AMS_Utility_PVT.error_message('AMS_CSCH_CODE_NOT_CASCADE');
721: RETURN;
722: END IF;
723: IF (AMS_DEBUG_HIGH_ON) THEN
724:

Line 725: AMS_Utility_PVT.debug_message('Check Source Code uniqueness ');

721: RETURN;
722: END IF;
723: IF (AMS_DEBUG_HIGH_ON) THEN
724:
725: AMS_Utility_PVT.debug_message('Check Source Code uniqueness ');
726: END IF;
727: -- check if the new source code is unique
728: OPEN c_source_code;
729: FETCH c_source_code INTO l_dummy;

Line 733: AMS_Utility_PVT.debug_message('Dup Code '||l_dummy);

729: FETCH c_source_code INTO l_dummy;
730: CLOSE c_source_code;
731: IF (AMS_DEBUG_HIGH_ON) THEN
732:
733: AMS_Utility_PVT.debug_message('Dup Code '||l_dummy);
734: END IF;
735: IF l_dummy IS NOT NULL THEN
736: AMS_Utility_PVT.error_message('AMS_CAMP_DUPLICATE_CODE');
737: x_return_status := FND_API.g_ret_sts_error;

Line 736: AMS_Utility_PVT.error_message('AMS_CAMP_DUPLICATE_CODE');

732:
733: AMS_Utility_PVT.debug_message('Dup Code '||l_dummy);
734: END IF;
735: IF l_dummy IS NOT NULL THEN
736: AMS_Utility_PVT.error_message('AMS_CAMP_DUPLICATE_CODE');
737: x_return_status := FND_API.g_ret_sts_error;
738: RETURN;
739: END IF;
740:

Line 746: AMS_Utility_PVT.error_message('AMS_CSCH_UPDATE_SOURCE_CODE');

742: OPEN c_list_header;
743: FETCH c_list_header INTO l_dummy;
744: CLOSE c_list_header;
745: IF l_dummy IS NOT NULL THEN
746: AMS_Utility_PVT.error_message('AMS_CSCH_UPDATE_SOURCE_CODE');
747: x_return_status := FND_API.g_ret_sts_error;
748: RETURN;
749: END IF;
750:

Line 755: AMS_Utility_PVT.debug_message('Revoke Source Code ');

751: IF (AMS_DEBUG_HIGH_ON) THEN
752:
753:
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,

Line 779: AMS_Utility_PVT.debug_message('Create Source Code ');

775: IF (AMS_DEBUG_HIGH_ON) THEN
776:
777:
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,

Line 853: AMS_Utility_PVT.debug_message('Check Source Code ');

849:
850: BEGIN
851: IF (AMS_DEBUG_HIGH_ON) THEN
852:
853: AMS_Utility_PVT.debug_message('Check Source Code ');
854: END IF;
855: x_return_status := FND_API.g_ret_sts_success;
856:
857:

Line 882: AMS_Utility_PVT.error_message('AMS_CSCH_UPDATE_SOURCE_CODE');

878: OPEN c_list_header;
879: FETCH c_list_header INTO l_dummy;
880: CLOSE c_list_header;
881: IF l_dummy IS NOT NULL THEN
882: AMS_Utility_PVT.error_message('AMS_CSCH_UPDATE_SOURCE_CODE');
883: x_return_status := FND_API.g_ret_sts_error;
884: RETURN;
885: END IF;
886: */

Line 897: AMS_Utility_PVT.Error_Message('AMS_CSCH_UPDATE_SOURCE_CODE');

893: END IF;
894:
895: -- following code added by soagrawa on 31-jan-2002 for bug# 2207286
896: IF FND_API.G_TRUE = Target_Group_Exist(p_schedule_rec.schedule_id) THEN
897: AMS_Utility_PVT.Error_Message('AMS_CSCH_UPDATE_SOURCE_CODE');
898: RAISE FND_API.g_exc_error;
899: END IF ;
900:
901: -- get campaign's source code

Line 907: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_ID');

903: FETCH c_camp INTO l_camp_source_code, l_camp_global_flag;
904: IF c_camp%NOTFOUND THEN -- campaign_id is invalid
905: CLOSE c_camp;
906: x_return_status := FND_API.g_ret_sts_error;
907: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_ID');
908: RAISE FND_API.g_exc_error;
909: RETURN;
910: END IF;
911: CLOSE c_camp;

Line 926: AMS_Utility_PVT.debug_message('Check Source Code: use parent source code flag is '||p_schedule_rec.use_parent_code_flag);

922: IF (AMS_DEBUG_HIGH_ON) THEN
923:
924:
925:
926: AMS_Utility_PVT.debug_message('Check Source Code: use parent source code flag is '||p_schedule_rec.use_parent_code_flag);
927:
928: END IF;
929: l_cascade_flag := p_schedule_rec.use_parent_code_flag;
930:

Line 936: AMS_Utility_PVT.debug_message('Check Source Code: use parent source code flag is Y');

932: -- check if source code is cascaded from campaign
933: IF l_cascade_flag = 'Y' THEN
934: IF (AMS_DEBUG_HIGH_ON) THEN
935:
936: AMS_Utility_PVT.debug_message('Check Source Code: use parent source code flag is Y');
937: END IF;
938: IF l_source_code = l_camp_source_code
939: THEN
940: IF (AMS_DEBUG_HIGH_ON) THEN

Line 942: AMS_Utility_PVT.debug_message('nothing to change');

938: IF l_source_code = l_camp_source_code
939: THEN
940: IF (AMS_DEBUG_HIGH_ON) THEN
941:
942: AMS_Utility_PVT.debug_message('nothing to change');
943: END IF;
944: RETURN;
945: ELSE
946: -- revoke old source code

Line 949: AMS_Utility_PVT.debug_message('revoke previous, and put campaign source code');

945: ELSE
946: -- revoke old source code
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,

Line 972: AMS_Utility_PVT.debug_message('put campaign source code - all OK');

968: -- populate camp's srccd into schedule
969: x_source_code := l_camp_source_code;
970: IF (AMS_DEBUG_HIGH_ON) THEN
971:
972: AMS_Utility_PVT.debug_message('put campaign source code - all OK');
973: END IF;
974: END IF;
975:
976:

Line 990: AMS_Utility_PVT.debug_message('Check Source Code: use parent source code flag is N');

986:
987: ELSE -- cascade flag is N
988: IF (AMS_DEBUG_HIGH_ON) THEN
989:
990: AMS_Utility_PVT.debug_message('Check Source Code: use parent source code flag is N');
991: END IF;
992: IF p_schedule_rec.source_code IS NULL
993: OR p_schedule_rec.source_code = FND_API.g_miss_char
994: OR p_schedule_rec.source_code = ''

Line 998: AMS_Utility_PVT.debug_message('Gotta system generate it');

994: OR p_schedule_rec.source_code = ''
995: THEN
996: IF (AMS_DEBUG_HIGH_ON) THEN
997:
998: AMS_Utility_PVT.debug_message('Gotta system generate it');
999: END IF;
1000: -- system generate it
1001: x_source_code := Generate_Schedule_Code(l_camp_source_code,p_schedule_rec.custom_setup_id);
1002: -- see if current in database is same as campaign's

Line 1007: AMS_Utility_PVT.debug_message('Revoke Source Code '||p_sch_source_code);

1003: IF p_sch_source_code <> l_camp_source_code THEN
1004: -- revoke
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,

Line 1031: AMS_Utility_PVT.debug_message('push it '||x_source_code);

1027: IF (AMS_DEBUG_HIGH_ON) THEN
1028:
1029:
1030:
1031: AMS_Utility_PVT.debug_message('push it '||x_source_code);
1032:
1033: END IF;
1034: -- push system generated one into source code table
1035:

Line 1058: AMS_Utility_PVT.debug_message('is it unique? '||p_schedule_rec.source_code);

1054:
1055: ELSE -- source code is not null
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

Line 1064: AMS_Utility_PVT.error_message('AMS_CAMP_DUPLICATE_CODE');

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');
1065: RETURN;
1066: ELSE
1067: -- yes unique
1068: -- remove whatever was earlier

Line 1073: AMS_Utility_PVT.debug_message('Revoke Source Code '||p_sch_source_code);

1069: IF p_sch_source_code <> l_camp_source_code THEN
1070: -- revoke
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,

Line 1123: AMS_Utility_PVT.debug_message('Final source code is '||x_source_code);

1119: IF (AMS_DEBUG_HIGH_ON) THEN
1120:
1121:
1122:
1123: AMS_Utility_PVT.debug_message('Final source code is '||x_source_code);
1124:
1125: END IF;
1126:
1127: END Check_Source_Code;

Line 1170: AMS_Utility_PVT.error_message('AMS_CSCH_NO_CAMP_ID');

1166: FETCH c_campaign INTO l_parent_start_date, l_parent_end_date;
1167: IF c_campaign%NOTFOUND THEN
1168: CLOSE c_campaign;
1169: x_return_status := FND_API.g_ret_sts_error;
1170: AMS_Utility_PVT.error_message('AMS_CSCH_NO_CAMP_ID');
1171: RAISE FND_API.g_exc_error;
1172: END IF;
1173: CLOSE c_campaign;
1174:

Line 1179: AMS_Utility_PVT.error_message('AMS_CSCH_CAMP_START_NULL');

1175: ---------------------- start date ----------------------------
1176: IF p_start_date IS NOT NULL THEN
1177: IF l_parent_start_date IS NULL THEN
1178: x_return_status := FND_API.g_ret_sts_error;
1179: AMS_Utility_PVT.error_message('AMS_CSCH_CAMP_START_NULL');
1180: ELSIF p_start_date < l_parent_start_date THEN
1181: x_return_status := FND_API.g_ret_sts_error;
1182: AMS_Utility_PVT.error_message('AMS_CSCH_START_BEF_CAMP_START');
1183: ELSIF p_start_date > l_parent_end_date THEN

Line 1182: AMS_Utility_PVT.error_message('AMS_CSCH_START_BEF_CAMP_START');

1178: x_return_status := FND_API.g_ret_sts_error;
1179: AMS_Utility_PVT.error_message('AMS_CSCH_CAMP_START_NULL');
1180: ELSIF p_start_date < l_parent_start_date THEN
1181: x_return_status := FND_API.g_ret_sts_error;
1182: AMS_Utility_PVT.error_message('AMS_CSCH_START_BEF_CAMP_START');
1183: ELSIF p_start_date > l_parent_end_date THEN
1184: x_return_status := FND_API.g_ret_sts_error;
1185: AMS_Utility_PVT.error_message('AMS_CSCH_START_AFT_CAMP_END');
1186: END IF;

Line 1185: AMS_Utility_PVT.error_message('AMS_CSCH_START_AFT_CAMP_END');

1181: x_return_status := FND_API.g_ret_sts_error;
1182: AMS_Utility_PVT.error_message('AMS_CSCH_START_BEF_CAMP_START');
1183: ELSIF p_start_date > l_parent_end_date THEN
1184: x_return_status := FND_API.g_ret_sts_error;
1185: AMS_Utility_PVT.error_message('AMS_CSCH_START_AFT_CAMP_END');
1186: END IF;
1187: END IF;
1188:
1189: ---------------------- end date ------------------------------

Line 1193: AMS_Utility_PVT.error_message('AMS_CSCH_CAMP_END_NULL');

1189: ---------------------- end date ------------------------------
1190: IF p_end_date IS NOT NULL THEN
1191: IF l_parent_end_date IS NULL THEN
1192: x_return_status := FND_API.g_ret_sts_error;
1193: AMS_Utility_PVT.error_message('AMS_CSCH_CAMP_END_NULL');
1194: ELSIF p_end_date > l_parent_end_date THEN
1195: x_return_status := FND_API.g_ret_sts_error;
1196: AMS_Utility_PVT.error_message('AMS_CSCH_END_AFT_CAMP_END');
1197: ELSIF p_end_date < l_parent_start_date THEN

Line 1196: AMS_Utility_PVT.error_message('AMS_CSCH_END_AFT_CAMP_END');

1192: x_return_status := FND_API.g_ret_sts_error;
1193: AMS_Utility_PVT.error_message('AMS_CSCH_CAMP_END_NULL');
1194: ELSIF p_end_date > l_parent_end_date THEN
1195: x_return_status := FND_API.g_ret_sts_error;
1196: AMS_Utility_PVT.error_message('AMS_CSCH_END_AFT_CAMP_END');
1197: ELSIF p_end_date < l_parent_start_date THEN
1198: x_return_status := FND_API.g_ret_sts_error;
1199: AMS_Utility_PVT.error_message('AMS_CSCH_END_BEF_CAMP_START');
1200: END IF;

Line 1199: AMS_Utility_PVT.error_message('AMS_CSCH_END_BEF_CAMP_START');

1195: x_return_status := FND_API.g_ret_sts_error;
1196: AMS_Utility_PVT.error_message('AMS_CSCH_END_AFT_CAMP_END');
1197: ELSIF p_end_date < l_parent_start_date THEN
1198: x_return_status := FND_API.g_ret_sts_error;
1199: AMS_Utility_PVT.error_message('AMS_CSCH_END_BEF_CAMP_START');
1200: END IF;
1201: END IF;
1202:
1203: END Check_Sched_Dates_Vs_Camp;

Line 1280: AMS_Utility_PVT.error_message('AMS_CAMP_NO_ACCESS');

1276: p_user_or_role_id => l_resource,
1277: p_user_or_role_type => 'USER');
1278:
1279: IF l_access = 'N' THEN
1280: AMS_Utility_PVT.error_message('AMS_CAMP_NO_ACCESS');
1281: x_return_status := FND_API.g_ret_sts_error;
1282: RETURN;
1283: END IF ;
1284:

Line 1308: AMS_Utility_PVT.error_message('AMS_CAMP_OWNER_ACCESS');

1304: -- for fixing reopened bug# 2406677
1305: -- AND p_schedule_rec.owner_user_id <> l_resource
1306: AND l_schedule_rec.owner_user_id <> l_resource
1307: THEN
1308: AMS_Utility_PVT.error_message('AMS_CAMP_OWNER_ACCESS');
1309: x_return_status := FND_API.g_ret_sts_error;
1310: END IF;
1311:
1312: OPEN c_bud_line ;

Line 1320: AMS_Utility_PVT.error_message('AMS_CSCH_BUD_PRESENT');

1316: IF p_schedule_rec.transaction_currency_code <> FND_API.g_miss_char
1317: AND p_schedule_rec.transaction_currency_code <> l_schedule_rec.transaction_currency_code
1318: AND l_bud_exist IS NOT NULL
1319: THEN
1320: AMS_Utility_PVT.error_message('AMS_CSCH_BUD_PRESENT');
1321: x_return_status := FND_API.g_ret_sts_error;
1322: END IF ;
1323:
1324:

Line 1397: AMS_Utility_PVT.error_message('AMS_CSCH_NO_MEDIA_TYPE');

1393: x_return_status := FND_API.g_ret_sts_success;
1394:
1395: -- for execution campaigns, media_type and media are required
1396: IF p_activity_type IS NULL THEN
1397: AMS_Utility_PVT.error_message('AMS_CSCH_NO_MEDIA_TYPE');
1398: x_return_status := FND_API.g_ret_sts_error;
1399: RETURN;
1400: END IF;
1401:

Line 1403: AMS_Utility_PVT.error_message('AMS_CSCH_NO_MEDIA');

1399: RETURN;
1400: END IF;
1401:
1402: IF p_activity_type <> 'EVENTS' AND p_activity_id IS NULL THEN
1403: AMS_Utility_PVT.error_message('AMS_CSCH_NO_MEDIA');
1404: x_return_status := FND_API.g_ret_sts_error;
1405: RETURN;
1406: END IF;
1407:

Line 1409: AMS_Utility_PVT.error_message('AMS_CAMP_EC_NO_EVENT_TYPE');

1405: RETURN;
1406: END IF;
1407:
1408: IF p_activity_type = 'EVENTS' AND p_activity_type IS NULL THEN
1409: AMS_Utility_PVT.error_message('AMS_CAMP_EC_NO_EVENT_TYPE');
1410: x_return_status := FND_API.g_ret_sts_error;
1411: RETURN;
1412: END IF;
1413:

Line 1421: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_MEDIA_ID');

1417: FETCH c_media INTO l_type;
1418: CLOSE c_media;
1419:
1420: IF l_type <> p_activity_type THEN
1421: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_MEDIA_ID');
1422: x_return_status := FND_API.g_ret_sts_error;
1423: RETURN;
1424: END IF;
1425: END IF;

Line 1435: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_CHANNEL');

1431: FETCH c_channel_media INTO l_dummy;
1432: CLOSE c_channel_media;
1433:
1434: IF l_dummy IS NULL OR p_activity_id IS NULL THEN
1435: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_CHANNEL');
1436: x_return_status := FND_API.g_ret_sts_error;
1437: RETURN;
1438: END IF;
1439: END IF;

Line 1451: -- AMS_Utility_PVT.error_message('AMS_CAMP_EVENT_REQUIRED');

1447: AND p_status_code IN ('SUBMITTED_BA', 'AVAILABLE', 'ACTIVE')
1448: THEN
1449: IF p_activity_type = 'EVENTS' THEN
1450: -- dbiswas commented out the following error mesg for R12.
1451: -- AMS_Utility_PVT.error_message('AMS_CAMP_EVENT_REQUIRED');
1452: null;
1453: ELSE
1454: AMS_Utility_PVT.error_message('AMS_CAMP_CHANNEL_REQUIRED');
1455: x_return_status := FND_API.g_ret_sts_error;

Line 1454: AMS_Utility_PVT.error_message('AMS_CAMP_CHANNEL_REQUIRED');

1450: -- dbiswas commented out the following error mesg for R12.
1451: -- AMS_Utility_PVT.error_message('AMS_CAMP_EVENT_REQUIRED');
1452: null;
1453: ELSE
1454: AMS_Utility_PVT.error_message('AMS_CAMP_CHANNEL_REQUIRED');
1455: x_return_status := FND_API.g_ret_sts_error;
1456: END IF;
1457: -- x_return_status := FND_API.g_ret_sts_error;
1458: RETURN;

Line 1470: -- AMS_Utility_PVT.error_message('AMS_CAMP_BAD_CHANNEL');

1466: -- OPEN c_eveo;
1467: -- FETCH c_eveo INTO l_type;
1468: -- IF c_eveo%NOTFOUND OR l_type <> p_event_type THEN
1469: -- x_return_status := FND_API.g_ret_sts_error;
1470: -- AMS_Utility_PVT.error_message('AMS_CAMP_BAD_CHANNEL');
1471: -- END IF;
1472: -- CLOSE c_eveo;
1473: -- ELSIF p_arc_channel_from = 'EVEH' THEN
1474: -- OPEN c_eveh;

Line 1478: -- AMS_Utility_PVT.error_message('AMS_CAMP_BAD_CHANNEL');

1474: -- OPEN c_eveh;
1475: -- FETCH c_eveh INTO l_type;
1476: -- IF c_eveh%NOTFOUND OR l_type <> p_event_type THEN
1477: -- x_return_status := FND_API.g_ret_sts_error;
1478: -- AMS_Utility_PVT.error_message('AMS_CAMP_BAD_CHANNEL');
1479: -- END IF;
1480: -- CLOSE c_eveh;
1481: -- ELSE
1482: -- x_return_status := FND_API.g_ret_sts_error;

Line 1483: -- AMS_Utility_PVT.error_message('AMS_CAMP_BAD_ARC_CHANNEL');

1479: -- END IF;
1480: -- CLOSE c_eveh;
1481: -- ELSE
1482: -- x_return_status := FND_API.g_ret_sts_error;
1483: -- AMS_Utility_PVT.error_message('AMS_CAMP_BAD_ARC_CHANNEL');
1484: -- END IF;
1485:
1486: -- event associated to a campaign cannot be associated to other campaigns
1487: -- OPEN c_camp_event;

Line 1491: -- AMS_Utility_PVT.error_message('AMS_CAMP_EVENT_IN_USE');

1487: -- OPEN c_camp_event;
1488: -- FETCH c_camp_event INTO l_dummy;
1489: -- IF c_camp_event%FOUND THEN
1490: -- x_return_status := FND_API.g_ret_sts_error;
1491: -- AMS_Utility_PVT.error_message('AMS_CAMP_EVENT_IN_USE');
1492: -- END IF;
1493: -- CLOSE c_camp_event;
1494: -- END IF;
1495:

Line 1552: AMS_Utility_PVT.debug_message(l_full_name||': start');

1548: -- Debug Message
1549: --
1550: IF (AMS_DEBUG_HIGH_ON) THEN
1551:
1552: AMS_Utility_PVT.debug_message(l_full_name||': start');
1553: END IF;
1554:
1555: --
1556: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 1638: AMS_Utility_PVT.debug_message(l_full_name ||': end');

1634: IF (AMS_DEBUG_HIGH_ON) THEN
1635:
1636:
1637:
1638: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1639:
1640: END IF;
1641:
1642:

Line 1748: AMS_Utility_PVT.debug_message(l_api_name || ': start');

1744: -- Debug Message
1745: --
1746: IF (AMS_DEBUG_HIGH_ON) THEN
1747:
1748: AMS_Utility_PVT.debug_message(l_api_name || ': start');
1749: END IF;
1750:
1751: --
1752: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 1780: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_USER_STATUS');

1776: OPEN c_status('COMPLETED') ;
1777: FETCH c_status INTO l_status_id ;
1778: IF c_status%NOTFOUND THEN
1779: CLOSE c_status;
1780: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_USER_STATUS');
1781: RETURN ;
1782: END IF ;
1783: CLOSE c_status ;
1784:

Line 1827: AMS_Utility_PVT.debug_message(l_api_name ||' : end Status : ' || x_return_status);

1823: IF (AMS_DEBUG_HIGH_ON) THEN
1824:
1825:
1826:
1827: AMS_Utility_PVT.debug_message(l_api_name ||' : end Status : ' || x_return_status);
1828:
1829: END IF;
1830:
1831:

Line 1915: Ams_Utility_Pvt.Write_Conc_log ;

1911: x_msg_count => l_msg_count,
1912: x_msg_data => l_msg_data
1913: ) ;
1914: -- Write_log ;
1915: Ams_Utility_Pvt.Write_Conc_log ;
1916:
1917: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)THEN
1918: retcode :=0;
1919: ELSE

Line 2029: l_schedule_status_code VARCHAR2(30) := AMS_Utility_PVT.get_system_status_code(p_user_status_id) ;

2025: l_status_code VARCHAR2(30);
2026: l_activity_type_code VARCHAR2(30);
2027: l_activity_id NUMBER ;
2028: l_marketing_med_id NUMBER ;
2029: l_schedule_status_code VARCHAR2(30) := AMS_Utility_PVT.get_system_status_code(p_user_status_id) ;
2030: l_custom_setup_id NUMBER;
2031: l_cover_letter_id NUMBER ;
2032:
2033: l_msg_count NUMBER ;

Line 2062: AMS_Utility_PVT.check_new_status_change(

2058: -- Follwing code is modified by ptendulk on 10-Jul-2001
2059: -- The old procedure is replaced by new to check the type
2060: -- of the approval required as ams_object_attribute table is
2061: -- obsoleted now.
2062: AMS_Utility_PVT.check_new_status_change(
2063: p_object_type => 'CSCH',
2064: p_object_id => p_schedule_id,
2065: p_old_status_id => l_old_status_id,
2066: p_new_status_id => p_user_status_id,

Line 2081: AMS_Utility_PVT.debug_message('Is Pretty URL supported for schedule '||p_schedule_id||' with Activity Type = '||l_activity_type_code ||' and activity id = '||l_activity_id);

2077: -- dbiswas added the following pretty url check for bug 4472099
2078: IF l_schedule_status_code = 'SUBMITTED_BA'
2079: THEN
2080: IF (AMS_DEBUG_HIGH_ON) THEN
2081: AMS_Utility_PVT.debug_message('Is Pretty URL supported for schedule '||p_schedule_id||' with Activity Type = '||l_activity_type_code ||' and activity id = '||l_activity_id);
2082: END IF;
2083: IF (((l_activity_type_code = 'DIRECT_MARKETING') AND ((l_activity_id <> 20) AND (l_activity_id <> 460 )))
2084: OR((l_activity_type_code = 'BROADCAST') OR (l_activity_type_code = 'PUBLIC_RELATIONS') OR (l_activity_type_code = 'IN_STORE')))
2085: THEN

Line 2087: AMS_Utility_PVT.debug_message('Pretty URL IS supported for schedule '||p_schedule_id||' with Activity Type = '||l_activity_type_code ||' and activity id = '||l_activity_id);

2083: IF (((l_activity_type_code = 'DIRECT_MARKETING') AND ((l_activity_id <> 20) AND (l_activity_id <> 460 )))
2084: OR((l_activity_type_code = 'BROADCAST') OR (l_activity_type_code = 'PUBLIC_RELATIONS') OR (l_activity_type_code = 'IN_STORE')))
2085: THEN
2086: IF (AMS_DEBUG_HIGH_ON) THEN
2087: AMS_Utility_PVT.debug_message('Pretty URL IS supported for schedule '||p_schedule_id||' with Activity Type = '||l_activity_type_code ||' and activity id = '||l_activity_id);
2088: END IF;
2089: OPEN c_system_url(p_schedule_id);
2090: FETCH c_system_url INTO l_system_url, l_pretty_url_id, l_ctd_id ;
2091: CLOSE c_system_url;

Line 2159: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_TARGET_GROUP');

2155: -- following line added by soagrawa on 04-dec-2001
2156: -- modified by soagrawa on 15-aug-2002 for bug# 2515493 - added direct mail 480
2157: IF (l_activity_id = 10 OR l_activity_id = 20 OR l_activity_id = 460 OR l_activity_id = 480 OR l_activity_id = 500) THEN
2158: IF FND_API.G_FALSE = Target_Group_Exist(p_schedule_id) THEN
2159: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_TARGET_GROUP');
2160: RAISE FND_API.g_exc_error;
2161: END IF ;
2162: END IF;
2163:

Line 2172: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_COVER_LETTER');

2168: CLOSE c_cover_letter_det;
2169: -- soagrawa added 480 on 30-sep-2003 for 11.5.10
2170: IF (l_activity_id = 20 OR l_activity_id = 10 OR l_activity_id = 480)
2171: AND l_cover_letter_ver_id IS NULL THEN
2172: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_COVER_LETTER');
2173: RAISE FND_API.g_exc_error;
2174: END IF ;
2175:
2176: -- soagrawa added printer validation on 18-nov-2003 for 11.5.10

Line 2181: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_PRINTER');

2177: l_fulfilment := FND_PROFILE.Value('AMS_FULFILL_ENABLE_FLAG');
2178: IF l_activity_id = 480
2179: AND l_fulfilment <> 'N'
2180: AND l_printer_address IS NULL THEN
2181: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_PRINTER');
2182: RAISE FND_API.g_exc_error;
2183: END IF ;
2184:
2185: END IF ;

Line 2197: THEN AMS_Utility_PVT.Error_Message('AMS_CONTENT_NOT_APPROVED');

2193: IF (l_attr_available = 'Y') THEN
2194: AMS_ActProduct_PVT.IS_ALL_CONTENT_APPROVED (p_schedule_id => p_schedule_id,
2195: x_return_status => l_return_status);
2196: IF l_return_status <> 'Y'
2197: THEN AMS_Utility_PVT.Error_Message('AMS_CONTENT_NOT_APPROVED');
2198: RAISE FND_API.g_exc_error;
2199: END IF ;
2200: END IF;*/
2201:

Line 2207: AMS_Utility_PVT.debug_message('Is Pretty URL supported for schedule '||p_schedule_id||' with Activity Type = '||l_activity_type_code ||' and activity id = '||l_activity_id);

2203:
2204:
2205: --dbiswas added pretty URL uniqueness check for pretty URL region on May 26, 2005 for 11.5.10.RUP4
2206: IF (AMS_DEBUG_HIGH_ON) THEN
2207: AMS_Utility_PVT.debug_message('Is Pretty URL supported for schedule '||p_schedule_id||' with Activity Type = '||l_activity_type_code ||' and activity id = '||l_activity_id);
2208: END IF;
2209: IF (((l_activity_type_code = 'DIRECT_MARKETING') AND ((l_activity_id <> 20) AND (l_activity_id <> 460 )))
2210: OR((l_activity_type_code = 'BROADCAST') OR (l_activity_type_code = 'PUBLIC_RELATIONS') OR (l_activity_type_code = 'IN_STORE')))
2211: THEN

Line 2213: AMS_Utility_PVT.debug_message('Pretty URL IS supported for schedule '||p_schedule_id||' with Activity Type = '||l_activity_type_code ||' and activity id = '||l_activity_id);

2209: IF (((l_activity_type_code = 'DIRECT_MARKETING') AND ((l_activity_id <> 20) AND (l_activity_id <> 460 )))
2210: OR((l_activity_type_code = 'BROADCAST') OR (l_activity_type_code = 'PUBLIC_RELATIONS') OR (l_activity_type_code = 'IN_STORE')))
2211: THEN
2212: IF (AMS_DEBUG_HIGH_ON) THEN
2213: AMS_Utility_PVT.debug_message('Pretty URL IS supported for schedule '||p_schedule_id||' with Activity Type = '||l_activity_type_code ||' and activity id = '||l_activity_id);
2214: END IF;
2215: OPEN c_system_url(p_schedule_id);
2216: FETCH c_system_url INTO l_system_url, l_pretty_url_id, l_ctd_id;
2217: CLOSE c_system_url;

Line 2273: AMS_Utility_PVT.Error_Message('AMS_CAMP_CHANNEL_REQUIRED');

2269: l_activity_type_code <> 'TRADE_PROMOTION' AND
2270: -- Following Line of code is added by asaha on 09-Sep-2003 for Sales Channel
2271: l_activity_type_code <> 'DIRECT_SALES'
2272: THEN
2273: AMS_Utility_PVT.Error_Message('AMS_CAMP_CHANNEL_REQUIRED');
2274: RAISE FND_API.g_exc_error;
2275: END IF ;
2276: END IF ;
2277:

Line 2283: AMS_Utility_PVT.Error_Message('AMS_CSCH_CAMP_NO_ACTIVE');

2279: FETCH c_camp_status INTO l_status_code ;
2280: CLOSE c_camp_status;
2281:
2282: IF l_status_code <> 'ACTIVE' THEN
2283: AMS_Utility_PVT.Error_Message('AMS_CSCH_CAMP_NO_ACTIVE');
2284: RAISE FND_API.g_exc_error;
2285: END IF ;
2286: END IF ; -- Active or Available
2287:

Line 2297: p_requestor_id => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),

2293: p_activity_id => p_schedule_id,
2294: p_activity_type => 'CSCH',
2295: p_approval_type => 'BUDGET',
2296: p_act_budget_id => null,
2297: p_requestor_id => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
2298: x_must_preview => l_start_wf_process,
2299: x_return_status => l_return_status);
2300:
2301: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2310: l_new_status_id := AMS_Utility_PVT.get_default_user_status(

2306:
2307: /* vmodur 19-Dec-2005 */
2308: IF (l_start_wf_process = 'Y') THEN -- If the user is not the approver and budget approval reqd
2309: -- start budget approval process
2310: l_new_status_id := AMS_Utility_PVT.get_default_user_status(
2311: 'AMS_CAMPAIGN_SCHEDULE_STATUS',
2312: 'SUBMITTED_BA'
2313: );
2314: l_deny_status_id := AMS_Utility_PVT.get_default_user_status(

Line 2314: l_deny_status_id := AMS_Utility_PVT.get_default_user_status(

2310: l_new_status_id := AMS_Utility_PVT.get_default_user_status(
2311: 'AMS_CAMPAIGN_SCHEDULE_STATUS',
2312: 'SUBMITTED_BA'
2313: );
2314: l_deny_status_id := AMS_Utility_PVT.get_default_user_status(
2315: 'AMS_CAMPAIGN_SCHEDULE_STATUS',
2316: 'DENIED_BA'
2317: );
2318:

Line 2327: p_requester_userid => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),

2323: p_object_version_number => l_object_version,
2324: p_orig_stat_id => l_old_status_id,
2325: p_new_stat_id => p_user_status_id,
2326: p_reject_stat_id => l_deny_status_id,
2327: p_requester_userid => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
2328: p_workflowprocess => 'AMS_APPROVAL',
2329: p_item_type => 'AMSAPRV'
2330: );
2331: ELSE -- If user equals approver and budget approval reqd

Line 2333: AMS_Utility_PVT.Debug_Message('No need to start Workflow Process for Approval, Status Code ' || l_schedule_status_code );

2329: p_item_type => 'AMSAPRV'
2330: );
2331: ELSE -- If user equals approver and budget approval reqd
2332: IF (AMS_DEBUG_HIGH_ON) THEN
2333: AMS_Utility_PVT.Debug_Message('No need to start Workflow Process for Approval, Status Code ' || l_schedule_status_code );
2334: END IF;
2335: -- Following budget line api call added by soagrawa on 25-oct-2002
2336: -- for enhancement # 2445453
2337:

Line 2364: AMS_Utility_PVT.Debug_Message('No Approval' || l_schedule_status_code );

2360:
2361: ELSE -- No BUDGET Approval
2362:
2363: IF (AMS_DEBUG_HIGH_ON) THEN
2364: AMS_Utility_PVT.Debug_Message('No Approval' || l_schedule_status_code );
2365: END IF;
2366: -- Following budget line api call added by soagrawa on 25-oct-2002
2367: -- for enhancement # 2445453
2368:

Line 2396: p_new_status_code => AMS_Utility_PVT.get_system_status_code(l_new_status_id),

2392: --insert_log_mesg('Anirban got value of asn_group_id in api Update_Schedule_Status in amsvsbrb.pls as :'||p_asn_group_id);
2393:
2394: update_status(p_schedule_id => p_schedule_id,
2395: p_new_status_id => l_new_status_id,
2396: p_new_status_code => AMS_Utility_PVT.get_system_status_code(l_new_status_id),
2397: p_asn_group_id => p_asn_group_id -- anchaudh added for leads bug.
2398: );
2399:
2400: END Update_Schedule_Status;

Line 2445: l_list_header_rec.list_name := p_schedule_name ||TO_CHAR(p_schedule_id)||' - '||AMS_Utility_PVT.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','TGRP');

2441: /* Following code is modified by ptendulk on 25-Oct-2001
2442: As we don't have to create the target group for schedules at
2443: schedule creation.
2444: -- AMS_ListHeader_PVT.init_listheader_rec(l_list_header_rec);
2445: l_list_header_rec.list_name := p_schedule_name ||TO_CHAR(p_schedule_id)||' - '||AMS_Utility_PVT.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','TGRP');
2446: l_list_header_rec.list_type := 'TARGET';
2447: -- Have to be removed.
2448: l_list_header_rec.list_source_type := 'PERSON_LIST' ;
2449: l_list_header_rec.owner_user_id := p_owner_id;

Line 2768: AMS_Utility_PVT.debug_message('Write interaction: created media item ');

2764: RETURN;
2765: END IF;
2766:
2767: IF (AMS_DEBUG_HIGH_ON) THEN
2768: AMS_Utility_PVT.debug_message('Write interaction: created media item ');
2769: END IF;
2770:
2771: -- loop for each party id found
2772: OPEN c_parties_det;

Line 2781: AMS_Utility_PVT.debug_message('Write interaction: looping for party id ');

2777: IF (AMS_DEBUG_HIGH_ON) THEN
2778:
2779:
2780:
2781: AMS_Utility_PVT.debug_message('Write interaction: looping for party id ');
2782:
2783: END IF;
2784:
2785: -- populate interaction record

Line 2991: status_code = p_new_status_code, -- AMS_Utility_PVT.get_system_status_code(p_new_status_id),

2987: CLOSE c_sch_det;
2988:
2989: UPDATE ams_campaign_schedules_b
2990: SET user_status_id = p_new_status_id,
2991: status_code = p_new_status_code, -- AMS_Utility_PVT.get_system_status_code(p_new_status_id),
2992: status_date = SYSDATE,
2993: object_version_number = object_version_number + 1,
2994: last_update_date = SYSDATE
2995: WHERE schedule_id = p_schedule_id;

Line 3033: AMS_UTILITY_PVT.Convert_Timezone(

3029: wf_event.AddParameterToList(p_name => 'SCHEDULE_ID',
3030: p_value => p_schedule_id,
3031: p_parameterlist => l_parameter_list);
3032:
3033: AMS_UTILITY_PVT.Convert_Timezone(
3034: p_init_msg_list => FND_API.G_TRUE,
3035: x_return_status => l_return_status,
3036: x_msg_count => l_msg_count,
3037: x_msg_data => l_msg_data,

Line 3053: AMS_Utility_PVT.debug_message('Raise Business event for Repeating Schedule');

3049: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3050: l_start_time := SYSDATE;
3051: END IF;
3052:
3053: AMS_Utility_PVT.debug_message('Raise Business event for Repeating Schedule');
3054: WF_EVENT.Raise
3055: ( p_event_name => 'oracle.apps.ams.campaign.RepeatScheduleEvent',
3056: p_event_key => l_new_item_key,
3057: p_parameters => l_parameter_list,

Line 3086: l_RESOURCE_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);

3082:
3083: END IF;
3084:
3085:
3086: l_RESOURCE_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
3087: --insert_log_mesg('Anirban passing value of l_RESOURCE_id in WF, in amsvsbrb.pls as :'||l_RESOURCE_id);
3088: wf_event.AddParameterToList(p_name => 'ASN_RESOURCE_ID',
3089: p_value => l_RESOURCE_id,
3090: p_parameterlist => l_parameter_list);

Line 3094: AMS_UTILITY_PVT.Convert_Timezone(

3090: p_parameterlist => l_parameter_list);
3091:
3092: --ANCHAUDH starts modification for the leads bug.
3093:
3094: AMS_UTILITY_PVT.Convert_Timezone(
3095: p_init_msg_list => FND_API.G_TRUE,
3096: x_return_status => l_return_status,
3097: x_msg_count => l_msg_count,
3098: x_msg_data => l_msg_data,

Line 3114: AMS_Utility_PVT.Create_Log (

3110: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3111: l_sys_start_time := SYSDATE;
3112: END IF;
3113:
3114: AMS_Utility_PVT.Create_Log (
3115: x_return_status => l_return_status,
3116: p_arc_log_used_by => 'CSCH',
3117: p_log_used_by_id => p_schedule_id,
3118: p_msg_data => 'Before Raise : started with : '||TO_CHAR(l_user_id)||' '||TO_CHAR(l_resp_id)||' '||TO_CHAR(l_resp_appl_id),

Line 3122: AMS_Utility_PVT.debug_message('Raise Business event for schedule execution');

3118: p_msg_data => 'Before Raise : started with : '||TO_CHAR(l_user_id)||' '||TO_CHAR(l_resp_id)||' '||TO_CHAR(l_resp_appl_id),
3119: p_msg_type => 'DEBUG'
3120: );
3121:
3122: AMS_Utility_PVT.debug_message('Raise Business event for schedule execution');
3123: WF_EVENT.Raise
3124: ( p_event_name => 'oracle.apps.ams.campaign.ExecuteSchedule',
3125: p_event_key => l_new_item_key,
3126: p_parameters => l_parameter_list,

Line 3147: l_new_status_id := AMS_Utility_PVT.get_default_user_status('AMS_EVENT_STATUS',p_new_status_code);

3143: END IF;
3144:
3145: IF l_activity_type_code = 'EVENTS'
3146: THEN
3147: l_new_status_id := AMS_Utility_PVT.get_default_user_status('AMS_EVENT_STATUS',p_new_status_code);
3148:
3149: --Added by ANSKUMAR for Fulfilment
3150:
3151: IF p_new_status_code='ACTIVE' OR p_new_status_code='CANCELLED'

Line 3252: AMS_Utility_PVT.debug_message('Update schedule owner ');

3248: -- the following 2 lines added by soagrawa on 18-jun-2002
3249: -- for bug# 2421601
3250: IF (AMS_DEBUG_HIGH_ON) THEN
3251:
3252: AMS_Utility_PVT.debug_message('Update schedule owner ');
3253: END IF;
3254: x_return_status := FND_API.g_ret_sts_success;
3255:
3256: OPEN c_owner ;

Line 3260: AMS_Utility_Pvt.Error_Message('AMS_API_RECORD_NOT_FOUND');

3256: OPEN c_owner ;
3257: FETCH c_owner INTO l_old_owner, l_campaign_id ;
3258: IF c_owner%NOTFOUND THEN
3259: CLOSE c_owner;
3260: AMS_Utility_Pvt.Error_Message('AMS_API_RECORD_NOT_FOUND');
3261: RAISE FND_API.g_exc_error;
3262: END IF;
3263: CLOSE c_owner ;
3264:

Line 3393: AMS_Utility_PVT.Create_Log (

3389: itemtype => p_itemtype,
3390: itemkey => p_itemkey ,
3391: aname => 'SCHEDULE_ID');
3392:
3393: AMS_Utility_PVT.Create_Log (
3394: x_return_status => l_return_status,
3395: p_arc_log_used_by => 'CSCH',
3396: p_log_used_by_id => l_schedule_id,
3397: p_msg_data => 'Error Message handling',

Line 3474: AMS_Utility_PVT.Create_Log (

3470: l_user_id := FND_GLOBAL.USER_ID;
3471: l_resp_id := FND_GLOBAL.RESP_ID;
3472: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3473:
3474: AMS_Utility_PVT.Create_Log (
3475: x_return_status => l_return_status,
3476: p_arc_log_used_by => 'CSCH',
3477: p_log_used_by_id => l_schedule_id,
3478: p_msg_data => 'Init_Schedule_val : started with '||TO_CHAR(l_user_id)||' '||TO_CHAR(l_resp_id)||' '||TO_CHAR(l_resp_appl_id),

Line 3617: AMS_Utility_PVT.Create_Log (

3613: itemtype => p_itemtype,
3614: itemkey => p_itemkey ,
3615: aname => 'SCHEDULE_ID');
3616:
3617: AMS_Utility_PVT.Create_Log (
3618: x_return_status => l_return_status,
3619: p_arc_log_used_by => 'CSCH',
3620: p_log_used_by_id => l_schedule_id,
3621: p_msg_data => 'Ams_Selector TEST_CTX : started with : '||TO_CHAR(l_user_id)||' '||TO_CHAR(l_resp_id)||' '||TO_CHAR(l_resp_appl_id),

Line 3640: AMS_Utility_PVT.Create_Log (

3636: CLOSE c_user_resp_dtl;
3637:
3638: l_resp_appl_id := 530;
3639:
3640: AMS_Utility_PVT.Create_Log (
3641: x_return_status => l_return_status,
3642: p_arc_log_used_by => 'CSCH',
3643: p_log_used_by_id => l_schedule_id,
3644: p_msg_data => 'Ams_Selector TEST_CTX : setting the apps ctx to : '||TO_CHAR(l_user_id)||' '||TO_CHAR(l_resp_id)||' '||TO_CHAR(l_resp_appl_id),

Line 3677: AMS_Utility_PVT.Create_Log (

3673: l_resp_appl_id := 530;
3674:
3675: -- Set the database session context which also sets the org
3676: --FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
3677: AMS_Utility_PVT.Create_Log (
3678: x_return_status => l_return_status,
3679: p_arc_log_used_by => 'CSCH',
3680: p_log_used_by_id => l_schedule_id,
3681: p_msg_data => 'Ams_Selector SET_CTX : setting the apps ctx to : '||TO_CHAR(l_user_id)||' '||TO_CHAR(l_resp_id)||' '||TO_CHAR(l_resp_appl_id),

Line 3727: AMS_Utility_PVT.Create_Log (

3723: itemtype => itemtype,
3724: itemkey => itemkey ,
3725: aname => 'SCHEDULE_ID' );
3726:
3727: AMS_Utility_PVT.Create_Log (
3728: x_return_status => l_return_status,
3729: p_arc_log_used_by => 'CSCH',
3730: p_log_used_by_id => l_schedule_id,
3731: p_msg_data => 'Check_Schedule_Status : started',

Line 3816: AMS_Utility_PVT.Create_Log (

3812: itemtype => itemtype,
3813: itemkey => itemkey ,
3814: aname => 'SCHEDULE_ID' );
3815:
3816: AMS_Utility_PVT.Create_Log (
3817: x_return_status => l_return_status,
3818: p_arc_log_used_by => 'CSCH',
3819: p_log_used_by_id => l_schedule_id,
3820: p_msg_data => 'Update_Schedule_Status : started',

Line 3830: l_user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_SCHEDULE_STATUS','ACTIVE') ;

3826: OPEN c_csch_det(l_schedule_id);
3827: FETCH c_csch_det INTO l_old_status_code;
3828: CLOSE c_csch_det;
3829:
3830: l_user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_SCHEDULE_STATUS','ACTIVE') ;
3831:
3832: UPDATE ams_campaign_schedules_b
3833: SET status_code = 'ACTIVE',
3834: user_status_id = l_user_status_id,

Line 3899: AMS_Utility_PVT.Create_Log (

3895: itemtype => itemtype,
3896: itemkey => itemkey ,
3897: aname => 'SCHEDULE_ID' );
3898:
3899: AMS_Utility_PVT.Create_Log (
3900: x_return_status => l_return_status,
3901: p_arc_log_used_by => 'CSCH',
3902: p_log_used_by_id => l_schedule_id,
3903: p_msg_data => 'Check_Schedule_Act_Type : started',

Line 4030: AMS_Utility_PVT.Create_Log (

4026: itemtype => itemtype,
4027: itemkey => itemkey ,
4028: aname => 'SCHEDULE_ID' );
4029:
4030: AMS_Utility_PVT.Create_Log (
4031: x_return_status => l_log_return_status,
4032: p_arc_log_used_by => 'CSCH',
4033: p_log_used_by_id => l_schedule_id,
4034: p_msg_data => 'Execute_Direct_Marketing : started for schedule id '||l_schedule_id,

Line 4057: AMS_Utility_PVT.Create_Log (

4053: THEN
4054: --
4055: -- Yes => 1.1 Increase usage
4056: --
4057: AMS_Utility_PVT.Create_Log (
4058: x_return_status => l_log_return_status,
4059: p_arc_log_used_by => 'CSCH',
4060: p_log_used_by_id => l_schedule_id,
4061: p_msg_data => 'Execute_Direct_Marketing : Increase usage',

Line 4094: AMS_Utility_PVT.Create_Log (

4090: -- 1.2 Is channel Email, Print, Fax
4091: --
4092: IF (l_activity_id = 10 OR l_activity_id = 20 OR l_activity_id = 480)
4093: THEN
4094: AMS_Utility_PVT.Create_Log (
4095: x_return_status => l_log_return_status,
4096: p_arc_log_used_by => 'CSCH',
4097: p_log_used_by_id => l_schedule_id,
4098: p_msg_data => 'Execute_Direct_Marketing : update previously contacted',

Line 4142: /*AMS_Utility_PVT.Create_Log (

4138: --
4139: -- 1.2.2 Stamp version in ibc_associations table
4140: -- anchaudh : from R12 onwards this stamping of cover letter version will take place in the new event subscription api.
4141: --
4142: /*AMS_Utility_PVT.Create_Log (
4143: x_return_status => l_log_return_status,
4144: p_arc_log_used_by => 'CSCH',
4145: p_log_used_by_id => l_schedule_id,
4146: p_msg_data => 'Execute_Direct_Marketing : Stamping version',

Line 4174: AMS_Utility_PVT.Create_Log (

4170:
4171: --
4172: -- 1.2.3 Send Fulfillment Request
4173: --
4174: AMS_Utility_PVT.Create_Log (
4175: x_return_status => l_log_return_status,
4176: p_arc_log_used_by => 'CSCH',
4177: p_log_used_by_id => l_schedule_id,
4178: p_msg_data => 'Execute_Direct_Marketing : Call to fulfillment',

Line 4197: p_user_id => Ams_Utility_pvt.get_user_id(l_csch_owner_user_id)

4193: x_msg_data => l_msg_data,
4194: x_request_history_id => l_request_id,
4195: p_schedule_id => l_schedule_id,
4196: -- user id passing added by anchaudh on 09-nov-2004 for bug# 3799053
4197: p_user_id => Ams_Utility_pvt.get_user_id(l_csch_owner_user_id)
4198: ) ;
4199:
4200: AMS_Utility_PVT.Create_Log (
4201: x_return_status => l_log_return_status,

Line 4200: AMS_Utility_PVT.Create_Log (

4196: -- user id passing added by anchaudh on 09-nov-2004 for bug# 3799053
4197: p_user_id => Ams_Utility_pvt.get_user_id(l_csch_owner_user_id)
4198: ) ;
4199:
4200: AMS_Utility_PVT.Create_Log (
4201: x_return_status => l_log_return_status,
4202: p_arc_log_used_by => 'CSCH',
4203: p_log_used_by_id => l_schedule_id,
4204: p_msg_data => 'Execute_Direct_Marketing : Call to fulfillment : Return status is '||l_return_status,

Line 4223: AMS_Utility_PVT.Create_Log (

4219:
4220: --
4221: -- 1.2.4 Update list sent out date
4222: --
4223: AMS_Utility_PVT.Create_Log (
4224: x_return_status => l_log_return_status,
4225: p_arc_log_used_by => 'CSCH',
4226: p_log_used_by_id => l_schedule_id,
4227: p_msg_data => 'Execute_Direct_Marketing : calling update_list_send_out_date ',

Line 4242: AMS_Utility_PVT.Create_Log (

4238: x_msg_data => l_msg_data,
4239:
4240: p_list_header_id => l_list_id);
4241:
4242: AMS_Utility_PVT.Create_Log (
4243: x_return_status => l_log_return_status,
4244: p_arc_log_used_by => 'CSCH',
4245: p_log_used_by_id => l_schedule_id,
4246: p_msg_data => 'Execute_Direct_Marketing : update_list_send_out_date : Return status is '||l_return_status,

Line 4270: -- AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_TARGET_GROUP');

4266: -- pls refer bug# 3553087
4267:
4268: ELSE
4269: -- if TGRP does not exist
4270: -- AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_TARGET_GROUP');
4271:
4272: -- Throw a valid error, if TG does not exist.. Filter should be on channel email.fax/print and Telemarketing.
4273: -- fix for bug # 4184571
4274: IF (l_activity_id = 10 OR l_activity_id = 20 OR l_activity_id = 460 OR l_activity_id = 480)

Line 4277: AMS_Utility_PVT.Create_Log (

4273: -- fix for bug # 4184571
4274: IF (l_activity_id = 10 OR l_activity_id = 20 OR l_activity_id = 460 OR l_activity_id = 480)
4275: THEN
4276:
4277: AMS_Utility_PVT.Create_Log (
4278: x_return_status => l_log_return_status,
4279: p_arc_log_used_by => 'CSCH',
4280: p_log_used_by_id => l_schedule_id,
4281: p_msg_data => 'Execute_Direct_Marketing : Target Group is empty',

Line 4366: AMS_Utility_PVT.Create_Log (

4362: l_user_id := FND_GLOBAL.USER_ID;
4363: l_resp_id := FND_GLOBAL.RESP_ID;
4364: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
4365:
4366: AMS_Utility_PVT.Create_Log (
4367: x_return_status => l_return_status,
4368: p_arc_log_used_by => 'CSCH',
4369: p_log_used_by_id => l_schedule_id,
4370: p_msg_data => 'Execute_Sales : started with '||TO_CHAR(l_user_id)||' '||TO_CHAR(l_resp_id)||' '||TO_CHAR(l_resp_appl_id),

Line 4378: AMS_Utility_PVT.Create_Log (

4374: -- Call the api to execute the sales schedule , return the error flag in l_return_status
4375: --generate_leads(l_schedule_id,'CSCH',l_return_status);
4376: generate_leads(l_schedule_id,'CSCH',l_return_status,itemtype,itemkey);--anchaudh changed the signature of this api for the leads bug.
4377:
4378: AMS_Utility_PVT.Create_Log (
4379: x_return_status => l_return_status,
4380: p_arc_log_used_by => 'CSCH',
4381: p_log_used_by_id => l_schedule_id,
4382: p_msg_data => 'Execute_Sales : done',

Line 4580: AMS_Utility_PVT.debug_message('generate_leads: Enter');

4576: BEGIN
4577: x_return_status := FND_API.g_ret_sts_success;
4578:
4579: IF (AMS_DEBUG_HIGH_ON) THEN
4580: AMS_Utility_PVT.debug_message('generate_leads: Enter');
4581: END IF;
4582:
4583: IF(p_obj_type <> 'CSCH') THEN
4584:

Line 4586: AMS_UTILITY_Pvt.debug_message('generate_leads: Unsupported object type : '||p_obj_type);

4582:
4583: IF(p_obj_type <> 'CSCH') THEN
4584:
4585: IF (AMS_DEBUG_HIGH_ON) THEN
4586: AMS_UTILITY_Pvt.debug_message('generate_leads: Unsupported object type : '||p_obj_type);
4587: END IF;
4588:
4589: x_return_status := FND_API.g_ret_sts_error;
4590: return;

Line 4593: AMS_Utility_PVT.Create_Log (

4589: x_return_status := FND_API.g_ret_sts_error;
4590: return;
4591: END IF;
4592:
4593: AMS_Utility_PVT.Create_Log (
4594: x_return_status => l_return_status,
4595: p_arc_log_used_by => 'CSCH',
4596: p_log_used_by_id => p_obj_id,
4597: p_msg_data => 'Starting lead generation process schedule id is ' || to_char(p_obj_id),

Line 4631: AMS_UTILITY_Pvt.debug_message('generate_leads: No Schedule details found for '||TO_CHAR(p_obj_id));

4627: OPEN c_schedule_details_csr(p_obj_id);
4628: FETCH c_schedule_details_csr INTO l_schedule_details;
4629: IF(c_schedule_details_csr%NOTFOUND) THEN
4630: IF (AMS_DEBUG_HIGH_ON) THEN
4631: AMS_UTILITY_Pvt.debug_message('generate_leads: No Schedule details found for '||TO_CHAR(p_obj_id));
4632: END IF;
4633: CLOSE c_schedule_details_csr;
4634: x_return_status := FND_API.g_ret_sts_error;
4635: return;

Line 4643: AMS_UTILITY_Pvt.debug_message('generate_leads: generated batch id: '||TO_CHAR(l_batch_id));

4639: OPEN c_batch_id;
4640: FETCH c_batch_id INTO l_batch_id;
4641: CLOSE c_batch_id;
4642: IF (AMS_DEBUG_HIGH_ON) THEN
4643: AMS_UTILITY_Pvt.debug_message('generate_leads: generated batch id: '||TO_CHAR(l_batch_id));
4644: END IF;
4645:
4646: -- bulk collect party related info
4647: -- soagrawa 09-dec-2005 added LIMIT on this bulk collect bug 4461415 and moved it to a cursor

Line 4656: AMS_Utility_PVT.Create_Log (

4652: fetch c_parties
4653: BULK COLLECT INTO l_party_types, l_contact_point_party_ids, l_main_party_ids, l_rel_party_ids
4654: LIMIT l_batch_size;
4655:
4656: AMS_Utility_PVT.Create_Log (
4657: x_return_status => l_return_status,
4658: p_arc_log_used_by => 'CSCH',
4659: p_log_used_by_id => p_obj_id,
4660: p_msg_data => 'Lead interface processing ' || l_main_party_ids.count,

Line 4725: AMS_Utility_PVT.debug_message('generate_leads: insertion done in lead interface tables');

4721:
4722: close c_parties;
4723:
4724: IF (AMS_DEBUG_HIGH_ON) THEN
4725: AMS_Utility_PVT.debug_message('generate_leads: insertion done in lead interface tables');
4726: END IF;
4727:
4728:
4729:

Line 4795: AMS_UTILITY_Pvt.debug_message('generate_leads: No. of Products/Categories : '||TO_CHAR(l_no_of_prods));

4791:
4792:
4793:
4794: IF (AMS_DEBUG_HIGH_ON) THEN
4795: AMS_UTILITY_Pvt.debug_message('generate_leads: No. of Products/Categories : '||TO_CHAR(l_no_of_prods));
4796: END IF;
4797:
4798: -- At this point we will have added all the records in as_import_interface table.
4799: -- Now we can call the concurrent program for lead process.

Line 4805: AMS_Utility_PVT.debug_message('generate_leads: No of lead header rows created : '||TO_CHAR(l_loaded_rows));

4801: FETCH c_loaded_rows_for_lead INTO l_loaded_rows;
4802: CLOSE c_loaded_rows_for_lead;
4803:
4804: IF (AMS_DEBUG_HIGH_ON) THEN
4805: AMS_Utility_PVT.debug_message('generate_leads: No of lead header rows created : '||TO_CHAR(l_loaded_rows));
4806: END IF;
4807:
4808: AMS_Utility_PVT.Create_Log (
4809: x_return_status => l_return_status,

Line 4808: AMS_Utility_PVT.Create_Log (

4804: IF (AMS_DEBUG_HIGH_ON) THEN
4805: AMS_Utility_PVT.debug_message('generate_leads: No of lead header rows created : '||TO_CHAR(l_loaded_rows));
4806: END IF;
4807:
4808: AMS_Utility_PVT.Create_Log (
4809: x_return_status => l_return_status,
4810: p_arc_log_used_by => 'CSCH',
4811: p_log_used_by_id => p_obj_id,
4812: p_msg_data => 'No. of lead headers generated '||TO_CHAR(l_loaded_rows),

Line 4849: AMS_Utility_PVT.Create_Log (

4845: );
4846:
4847: --insert_log_mesg('Anirban inside generate_leads api, value of l_batch_id and l_request_id after submitting Conc. request is :'||l_batch_id || ' '||l_request_id);
4848:
4849: AMS_Utility_PVT.Create_Log (
4850: x_return_status => l_return_status,
4851: p_arc_log_used_by => 'CSCH',
4852: p_log_used_by_id => p_obj_id,
4853: p_msg_data => 'Starting LEAD program (ASXSLIMP) -- concurrent program_id is ' || to_char(l_request_id) ||' for batch id '||TO_CHAR(l_batch_id),

Line 4859: AMS_Utility_PVT.Create_Log (

4855: );
4856:
4857: IF l_request_id = 0 THEN
4858: l_msg_data := fnd_message.get;
4859: AMS_Utility_PVT.Create_Log (
4860: x_return_status => l_return_status,
4861: p_arc_log_used_by => 'CSCH',
4862: p_log_used_by_id => p_obj_id,
4863: p_msg_data => l_msg_data,

Line 4873: AMS_Utility_PVT.debug_message('generate_leads: Submitted Lead import request with request id : '||TO_CHAR(l_request_id));

4869: END IF;
4870:
4871: -- Import completed successfully
4872: IF (AMS_DEBUG_HIGH_ON) THEN
4873: AMS_Utility_PVT.debug_message('generate_leads: Submitted Lead import request with request id : '||TO_CHAR(l_request_id));
4874: AMS_Utility_PVT.debug_message('generate_leads: End');
4875: END IF;
4876:
4877: END generate_leads;

Line 4874: AMS_Utility_PVT.debug_message('generate_leads: End');

4870:
4871: -- Import completed successfully
4872: IF (AMS_DEBUG_HIGH_ON) THEN
4873: AMS_Utility_PVT.debug_message('generate_leads: Submitted Lead import request with request id : '||TO_CHAR(l_request_id));
4874: AMS_Utility_PVT.debug_message('generate_leads: End');
4875: END IF;
4876:
4877: END generate_leads;
4878:

Line 4915: AMS_Utility_PVT.Create_Log (

4911: itemtype => itemtype,
4912: itemkey => itemkey ,
4913: aname => 'SCHEDULE_ID' );
4914:
4915: AMS_Utility_PVT.Create_Log (
4916: x_return_status => l_return_status,
4917: p_arc_log_used_by => 'CSCH',
4918: p_log_used_by_id => l_schedule_id,
4919: p_msg_data => 'Check_WF_Error : started',

Line 4974: AMS_Utility_PVT.debug_message (

4970: l_return_status VARCHAR2(1);
4971: BEGIN
4972: l_api_name := p_api_name;
4973: l_log_mesg := p_log_message;
4974: AMS_Utility_PVT.debug_message (
4975: p_log_level => g_log_level,
4976: p_module_name => 'ams.plsql.'||'.'|| g_pkg_name||'.'||l_api_name||'.'||l_log_mesg,
4977: p_text => p_log_message
4978: );

Line 4980: AMS_Utility_PVT.Create_Log (

4976: p_module_name => 'ams.plsql.'||'.'|| g_pkg_name||'.'||l_api_name||'.'||l_log_mesg,
4977: p_text => p_log_message
4978: );
4979:
4980: AMS_Utility_PVT.Create_Log (
4981: x_return_status => l_return_status,
4982: p_arc_log_used_by => 'CSCH',
4983: p_log_used_by_id => 1,
4984: p_msg_data => p_log_message,

Line 5672: /*AMS_UTILITY_PVT.Convert_Timezone(

5668: itemkey => itemkey ,
5669: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');
5670:
5671: --anchaudh: commented out on 11 Jun '05 to fix bug#4477717 .
5672: /*AMS_UTILITY_PVT.Convert_Timezone(
5673: p_init_msg_list => FND_API.G_TRUE,
5674: x_return_status => l_return_status,
5675: x_msg_count => l_msg_count,
5676: x_msg_data => l_msg_data,

Line 5922: AMS_Utility_PVT.debug_message(l_api_name || ': start');

5918:
5919: -- input debug messages.
5920: IF (AMS_DEBUG_HIGH_ON) THEN
5921:
5922: AMS_Utility_PVT.debug_message(l_api_name || ': start');
5923:
5924: END IF;
5925:
5926:

Line 5984: AMS_Utility_PVT.debug_message('Raise Business event for User Status Change' || ' ' || l_new_item_key);

5980: p_parameterlist => l_parameter_list);
5981:
5982: IF (AMS_DEBUG_HIGH_ON) THEN
5983:
5984: AMS_Utility_PVT.debug_message('Raise Business event for User Status Change' || ' ' || l_new_item_key);
5985:
5986: END IF;
5987:
5988:

Line 6041: AMS_Utility_PVT.Create_Log (

6037: LOOP
6038: FETCH c_citem_assoc INTO l_association_id, l_citem_id, l_citem_ver_id;
6039: EXIT WHEN c_citem_assoc%NOTFOUND;
6040:
6041: AMS_Utility_PVT.Create_Log (
6042: x_return_status => l_log_return_status,
6043: p_arc_log_used_by => 'CSCH',
6044: p_log_used_by_id => l_schedule_id,
6045: p_msg_data => 'HANDLE_COLLATERAL : Stamping collateral versions',

Line 6170: AMS_Utility_PVT.Create_Log (

6166: itemtype => itemtype,
6167: itemkey => itemkey ,
6168: aname => 'SCHEDULE_ID' ));
6169:
6170: AMS_Utility_PVT.Create_Log (
6171: x_return_status => l_return_status,
6172: p_arc_log_used_by => 'CSCH',
6173: p_log_used_by_id => l_schedule_id,
6174: p_msg_data => 'CHECK_NOTIFICATION_PREFERENCE : started',

Line 6184: AMS_Utility_PVT.Create_Log (

6180: CLOSE l_sch_det;
6181:
6182: IF ( l_flag is not null and l_flag = 'Y' ) THEN
6183: result := 'COMPLETE:T' ;
6184: AMS_Utility_PVT.Create_Log (
6185: x_return_status => l_return_status,
6186: p_arc_log_used_by => 'CSCH',
6187: p_log_used_by_id => l_schedule_id,
6188: p_msg_data => 'CHECK_NOTIFICATION_PREFERENCE : NOTIFICATION PREFERENCE IS YES for schedule id '||l_schedule_id,

Line 6193: AMS_Utility_PVT.Create_Log (

6189: p_msg_type => 'DEBUG'
6190: );
6191:
6192: ELSE
6193: AMS_Utility_PVT.Create_Log (
6194: x_return_status => l_return_status,
6195: p_arc_log_used_by => 'CSCH',
6196: p_log_used_by_id => l_schedule_id,
6197: p_msg_data => 'CHECK_NOTIFICATION_PREFERENCE : NOTIFICATION PREFERENCE IS NO for schedule id '||l_schedule_id,