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 2041: l_schedule_status_code VARCHAR2(30) := AMS_Utility_PVT.get_system_status_code(p_user_status_id) ;

2037: l_status_code VARCHAR2(30);
2038: l_activity_type_code VARCHAR2(30);
2039: l_activity_id NUMBER ;
2040: l_marketing_med_id NUMBER ;
2041: l_schedule_status_code VARCHAR2(30) := AMS_Utility_PVT.get_system_status_code(p_user_status_id) ;
2042: l_custom_setup_id NUMBER;
2043: l_cover_letter_id NUMBER ;
2044:
2045: l_msg_count NUMBER ;

Line 2074: AMS_Utility_PVT.check_new_status_change(

2070: -- Follwing code is modified by ptendulk on 10-Jul-2001
2071: -- The old procedure is replaced by new to check the type
2072: -- of the approval required as ams_object_attribute table is
2073: -- obsoleted now.
2074: AMS_Utility_PVT.check_new_status_change(
2075: p_object_type => 'CSCH',
2076: p_object_id => p_schedule_id,
2077: p_old_status_id => l_old_status_id,
2078: p_new_status_id => p_user_status_id,

Line 2093: 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);

2089: -- dbiswas added the following pretty url check for bug 4472099
2090: IF l_schedule_status_code = 'SUBMITTED_BA'
2091: THEN
2092: IF (AMS_DEBUG_HIGH_ON) THEN
2093: 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);
2094: END IF;
2095: IF (((l_activity_type_code = 'DIRECT_MARKETING') AND ((l_activity_id <> 20) AND (l_activity_id <> 460 )))
2096: OR((l_activity_type_code = 'BROADCAST') OR (l_activity_type_code = 'PUBLIC_RELATIONS') OR (l_activity_type_code = 'IN_STORE')))
2097: THEN

Line 2099: 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);

2095: IF (((l_activity_type_code = 'DIRECT_MARKETING') AND ((l_activity_id <> 20) AND (l_activity_id <> 460 )))
2096: OR((l_activity_type_code = 'BROADCAST') OR (l_activity_type_code = 'PUBLIC_RELATIONS') OR (l_activity_type_code = 'IN_STORE')))
2097: THEN
2098: IF (AMS_DEBUG_HIGH_ON) THEN
2099: 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);
2100: END IF;
2101: OPEN c_system_url(p_schedule_id);
2102: FETCH c_system_url INTO l_system_url, l_pretty_url_id, l_ctd_id ;
2103: CLOSE c_system_url;

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

2167: -- following line added by soagrawa on 04-dec-2001
2168: -- modified by soagrawa on 15-aug-2002 for bug# 2515493 - added direct mail 480
2169: 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
2170: IF FND_API.G_FALSE = Target_Group_Exist(p_schedule_id) THEN
2171: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_TARGET_GROUP');
2172: RAISE FND_API.g_exc_error;
2173: END IF ;
2174: END IF;
2175:

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

2180: CLOSE c_cover_letter_det;
2181: -- soagrawa added 480 on 30-sep-2003 for 11.5.10
2182: IF (l_activity_id = 20 OR l_activity_id = 10 OR l_activity_id = 480)
2183: AND l_cover_letter_ver_id IS NULL THEN
2184: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_COVER_LETTER');
2185: RAISE FND_API.g_exc_error;
2186: END IF ;
2187:
2188: -- soagrawa added printer validation on 18-nov-2003 for 11.5.10

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

2189: l_fulfilment := FND_PROFILE.Value('AMS_FULFILL_ENABLE_FLAG');
2190: IF l_activity_id = 480
2191: AND l_fulfilment <> 'N'
2192: AND l_printer_address IS NULL THEN
2193: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_PRINTER');
2194: RAISE FND_API.g_exc_error;
2195: END IF ;
2196:
2197: END IF ;

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

2205: IF (l_attr_available = 'Y') THEN
2206: AMS_ActProduct_PVT.IS_ALL_CONTENT_APPROVED (p_schedule_id => p_schedule_id,
2207: x_return_status => l_return_status);
2208: IF l_return_status <> 'Y'
2209: THEN AMS_Utility_PVT.Error_Message('AMS_CONTENT_NOT_APPROVED');
2210: RAISE FND_API.g_exc_error;
2211: END IF ;
2212: END IF;*/
2213:

Line 2219: 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);

2215:
2216:
2217: --dbiswas added pretty URL uniqueness check for pretty URL region on May 26, 2005 for 11.5.10.RUP4
2218: IF (AMS_DEBUG_HIGH_ON) THEN
2219: 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);
2220: END IF;
2221: IF (((l_activity_type_code = 'DIRECT_MARKETING') AND ((l_activity_id <> 20) AND (l_activity_id <> 460 )))
2222: OR((l_activity_type_code = 'BROADCAST') OR (l_activity_type_code = 'PUBLIC_RELATIONS') OR (l_activity_type_code = 'IN_STORE')))
2223: THEN

Line 2225: 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);

2221: IF (((l_activity_type_code = 'DIRECT_MARKETING') AND ((l_activity_id <> 20) AND (l_activity_id <> 460 )))
2222: OR((l_activity_type_code = 'BROADCAST') OR (l_activity_type_code = 'PUBLIC_RELATIONS') OR (l_activity_type_code = 'IN_STORE')))
2223: THEN
2224: IF (AMS_DEBUG_HIGH_ON) THEN
2225: 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);
2226: END IF;
2227: OPEN c_system_url(p_schedule_id);
2228: FETCH c_system_url INTO l_system_url, l_pretty_url_id, l_ctd_id;
2229: CLOSE c_system_url;

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

2281: l_activity_type_code <> 'TRADE_PROMOTION' AND
2282: -- Following Line of code is added by asaha on 09-Sep-2003 for Sales Channel
2283: l_activity_type_code <> 'DIRECT_SALES'
2284: THEN
2285: AMS_Utility_PVT.Error_Message('AMS_CAMP_CHANNEL_REQUIRED');
2286: RAISE FND_API.g_exc_error;
2287: END IF ;
2288: END IF ;
2289:

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

2291: FETCH c_camp_status INTO l_status_code ;
2292: CLOSE c_camp_status;
2293:
2294: IF l_status_code <> 'ACTIVE' THEN
2295: AMS_Utility_PVT.Error_Message('AMS_CSCH_CAMP_NO_ACTIVE');
2296: RAISE FND_API.g_exc_error;
2297: END IF ;
2298: END IF ; -- Active or Available
2299:

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

2305: p_activity_id => p_schedule_id,
2306: p_activity_type => 'CSCH',
2307: p_approval_type => 'BUDGET',
2308: p_act_budget_id => null,
2309: p_requestor_id => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
2310: x_must_preview => l_start_wf_process,
2311: x_return_status => l_return_status);
2312:
2313: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2322: l_new_status_id := AMS_Utility_PVT.get_default_user_status(

2318:
2319: /* vmodur 19-Dec-2005 */
2320: IF (l_start_wf_process = 'Y') THEN -- If the user is not the approver and budget approval reqd
2321: -- start budget approval process
2322: l_new_status_id := AMS_Utility_PVT.get_default_user_status(
2323: 'AMS_CAMPAIGN_SCHEDULE_STATUS',
2324: 'SUBMITTED_BA'
2325: );
2326: l_deny_status_id := AMS_Utility_PVT.get_default_user_status(

Line 2326: l_deny_status_id := AMS_Utility_PVT.get_default_user_status(

2322: l_new_status_id := AMS_Utility_PVT.get_default_user_status(
2323: 'AMS_CAMPAIGN_SCHEDULE_STATUS',
2324: 'SUBMITTED_BA'
2325: );
2326: l_deny_status_id := AMS_Utility_PVT.get_default_user_status(
2327: 'AMS_CAMPAIGN_SCHEDULE_STATUS',
2328: 'DENIED_BA'
2329: );
2330:

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

2335: p_object_version_number => l_object_version,
2336: p_orig_stat_id => l_old_status_id,
2337: p_new_stat_id => p_user_status_id,
2338: p_reject_stat_id => l_deny_status_id,
2339: p_requester_userid => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
2340: p_workflowprocess => 'AMS_APPROVAL',
2341: p_item_type => 'AMSAPRV'
2342: );
2343: ELSE -- If user equals approver and budget approval reqd

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

2341: p_item_type => 'AMSAPRV'
2342: );
2343: ELSE -- If user equals approver and budget approval reqd
2344: IF (AMS_DEBUG_HIGH_ON) THEN
2345: AMS_Utility_PVT.Debug_Message('No need to start Workflow Process for Approval, Status Code ' || l_schedule_status_code );
2346: END IF;
2347: -- Following budget line api call added by soagrawa on 25-oct-2002
2348: -- for enhancement # 2445453
2349:

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

2372:
2373: ELSE -- No BUDGET Approval
2374:
2375: IF (AMS_DEBUG_HIGH_ON) THEN
2376: AMS_Utility_PVT.Debug_Message('No Approval' || l_schedule_status_code );
2377: END IF;
2378: -- Following budget line api call added by soagrawa on 25-oct-2002
2379: -- for enhancement # 2445453
2380:

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

2404: --insert_log_mesg('Anirban got value of asn_group_id in api Update_Schedule_Status in amsvsbrb.pls as :'||p_asn_group_id);
2405:
2406: update_status(p_schedule_id => p_schedule_id,
2407: p_new_status_id => l_new_status_id,
2408: p_new_status_code => AMS_Utility_PVT.get_system_status_code(l_new_status_id),
2409: p_asn_group_id => p_asn_group_id -- anchaudh added for leads bug.
2410: );
2411:
2412: END Update_Schedule_Status;

Line 2457: 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');

2453: /* Following code is modified by ptendulk on 25-Oct-2001
2454: As we don't have to create the target group for schedules at
2455: schedule creation.
2456: -- AMS_ListHeader_PVT.init_listheader_rec(l_list_header_rec);
2457: 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');
2458: l_list_header_rec.list_type := 'TARGET';
2459: -- Have to be removed.
2460: l_list_header_rec.list_source_type := 'PERSON_LIST' ;
2461: l_list_header_rec.owner_user_id := p_owner_id;

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

2776: RETURN;
2777: END IF;
2778:
2779: IF (AMS_DEBUG_HIGH_ON) THEN
2780: AMS_Utility_PVT.debug_message('Write interaction: created media item ');
2781: END IF;
2782:
2783: -- loop for each party id found
2784: OPEN c_parties_det;

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

2789: IF (AMS_DEBUG_HIGH_ON) THEN
2790:
2791:
2792:
2793: AMS_Utility_PVT.debug_message('Write interaction: looping for party id ');
2794:
2795: END IF;
2796:
2797: -- populate interaction record

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

2999: CLOSE c_sch_det;
3000:
3001: UPDATE ams_campaign_schedules_b
3002: SET user_status_id = p_new_status_id,
3003: status_code = p_new_status_code, -- AMS_Utility_PVT.get_system_status_code(p_new_status_id),
3004: status_date = SYSDATE,
3005: object_version_number = object_version_number + 1,
3006: last_update_date = SYSDATE
3007: WHERE schedule_id = p_schedule_id;

Line 3045: AMS_UTILITY_PVT.Convert_Timezone(

3041: wf_event.AddParameterToList(p_name => 'SCHEDULE_ID',
3042: p_value => p_schedule_id,
3043: p_parameterlist => l_parameter_list);
3044:
3045: AMS_UTILITY_PVT.Convert_Timezone(
3046: p_init_msg_list => FND_API.G_TRUE,
3047: x_return_status => l_return_status,
3048: x_msg_count => l_msg_count,
3049: x_msg_data => l_msg_data,

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

3061: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3062: l_start_time := SYSDATE;
3063: END IF;
3064:
3065: AMS_Utility_PVT.debug_message('Raise Business event for Repeating Schedule');
3066: WF_EVENT.Raise
3067: ( p_event_name => 'oracle.apps.ams.campaign.RepeatScheduleEvent',
3068: p_event_key => l_new_item_key,
3069: p_parameters => l_parameter_list,

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

3094:
3095: END IF;
3096:
3097:
3098: l_RESOURCE_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
3099: --insert_log_mesg('Anirban passing value of l_RESOURCE_id in WF, in amsvsbrb.pls as :'||l_RESOURCE_id);
3100: wf_event.AddParameterToList(p_name => 'ASN_RESOURCE_ID',
3101: p_value => l_RESOURCE_id,
3102: p_parameterlist => l_parameter_list);

Line 3106: AMS_UTILITY_PVT.Convert_Timezone(

3102: p_parameterlist => l_parameter_list);
3103:
3104: --ANCHAUDH starts modification for the leads bug.
3105:
3106: AMS_UTILITY_PVT.Convert_Timezone(
3107: p_init_msg_list => FND_API.G_TRUE,
3108: x_return_status => l_return_status,
3109: x_msg_count => l_msg_count,
3110: x_msg_data => l_msg_data,

Line 3126: AMS_Utility_PVT.Create_Log (

3122: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: l_sys_start_time := SYSDATE;
3124: END IF;
3125:
3126: AMS_Utility_PVT.Create_Log (
3127: x_return_status => l_return_status,
3128: p_arc_log_used_by => 'CSCH',
3129: p_log_used_by_id => p_schedule_id,
3130: p_msg_data => 'Before Raise : started with : '||TO_CHAR(l_user_id)||' '||TO_CHAR(l_resp_id)||' '||TO_CHAR(l_resp_appl_id),

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

3130: p_msg_data => 'Before Raise : started with : '||TO_CHAR(l_user_id)||' '||TO_CHAR(l_resp_id)||' '||TO_CHAR(l_resp_appl_id),
3131: p_msg_type => 'DEBUG'
3132: );
3133:
3134: AMS_Utility_PVT.debug_message('Raise Business event for schedule execution');
3135: WF_EVENT.Raise
3136: ( p_event_name => 'oracle.apps.ams.campaign.ExecuteSchedule',
3137: p_event_key => l_new_item_key,
3138: p_parameters => l_parameter_list,

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

3155: END IF;
3156:
3157: IF l_activity_type_code = 'EVENTS'
3158: THEN
3159: l_new_status_id := AMS_Utility_PVT.get_default_user_status('AMS_EVENT_STATUS',p_new_status_code);
3160:
3161: --Added by ANSKUMAR for Fulfilment
3162:
3163: IF p_new_status_code='ACTIVE' OR p_new_status_code='CANCELLED'

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

3260: -- the following 2 lines added by soagrawa on 18-jun-2002
3261: -- for bug# 2421601
3262: IF (AMS_DEBUG_HIGH_ON) THEN
3263:
3264: AMS_Utility_PVT.debug_message('Update schedule owner ');
3265: END IF;
3266: x_return_status := FND_API.g_ret_sts_success;
3267:
3268: OPEN c_owner ;

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

3268: OPEN c_owner ;
3269: FETCH c_owner INTO l_old_owner, l_campaign_id ;
3270: IF c_owner%NOTFOUND THEN
3271: CLOSE c_owner;
3272: AMS_Utility_Pvt.Error_Message('AMS_API_RECORD_NOT_FOUND');
3273: RAISE FND_API.g_exc_error;
3274: END IF;
3275: CLOSE c_owner ;
3276:

Line 3405: AMS_Utility_PVT.Create_Log (

3401: itemtype => p_itemtype,
3402: itemkey => p_itemkey ,
3403: aname => 'SCHEDULE_ID');
3404:
3405: AMS_Utility_PVT.Create_Log (
3406: x_return_status => l_return_status,
3407: p_arc_log_used_by => 'CSCH',
3408: p_log_used_by_id => l_schedule_id,
3409: p_msg_data => 'Error Message handling',

Line 3486: AMS_Utility_PVT.Create_Log (

3482: l_user_id := FND_GLOBAL.USER_ID;
3483: l_resp_id := FND_GLOBAL.RESP_ID;
3484: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3485:
3486: AMS_Utility_PVT.Create_Log (
3487: x_return_status => l_return_status,
3488: p_arc_log_used_by => 'CSCH',
3489: p_log_used_by_id => l_schedule_id,
3490: 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 3629: AMS_Utility_PVT.Create_Log (

3625: itemtype => p_itemtype,
3626: itemkey => p_itemkey ,
3627: aname => 'SCHEDULE_ID');
3628:
3629: AMS_Utility_PVT.Create_Log (
3630: x_return_status => l_return_status,
3631: p_arc_log_used_by => 'CSCH',
3632: p_log_used_by_id => l_schedule_id,
3633: 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 3652: AMS_Utility_PVT.Create_Log (

3648: CLOSE c_user_resp_dtl;
3649:
3650: l_resp_appl_id := 530;
3651:
3652: AMS_Utility_PVT.Create_Log (
3653: x_return_status => l_return_status,
3654: p_arc_log_used_by => 'CSCH',
3655: p_log_used_by_id => l_schedule_id,
3656: 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 3689: AMS_Utility_PVT.Create_Log (

3685: l_resp_appl_id := 530;
3686:
3687: -- Set the database session context which also sets the org
3688: --FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
3689: AMS_Utility_PVT.Create_Log (
3690: x_return_status => l_return_status,
3691: p_arc_log_used_by => 'CSCH',
3692: p_log_used_by_id => l_schedule_id,
3693: 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 3739: AMS_Utility_PVT.Create_Log (

3735: itemtype => itemtype,
3736: itemkey => itemkey ,
3737: aname => 'SCHEDULE_ID' );
3738:
3739: AMS_Utility_PVT.Create_Log (
3740: x_return_status => l_return_status,
3741: p_arc_log_used_by => 'CSCH',
3742: p_log_used_by_id => l_schedule_id,
3743: p_msg_data => 'Check_Schedule_Status : started',

Line 3831: AMS_Utility_PVT.Create_Log (

3827: itemtype => itemtype,
3828: itemkey => itemkey ,
3829: aname => 'SCHEDULE_ID' );
3830:
3831: AMS_Utility_PVT.Create_Log (
3832: x_return_status => l_return_status,
3833: p_arc_log_used_by => 'CSCH',
3834: p_log_used_by_id => l_schedule_id,
3835: p_msg_data => 'Update_Schedule_Status : started',

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

3842: OPEN c_csch_det(l_schedule_id);
3843: FETCH c_csch_det INTO l_old_status_code,l_related_event_id,l_activity_type_code;
3844: CLOSE c_csch_det;
3845:
3846: l_user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_SCHEDULE_STATUS','ACTIVE') ;
3847:
3848: UPDATE ams_campaign_schedules_b
3849: SET status_code = 'ACTIVE',
3850: user_status_id = l_user_status_id,

Line 3860: l_event_status_id := AMS_Utility_PVT.get_default_user_status('AMS_EVENT_STATUS','ACTIVE');

3856: WHERE schedule_id = l_schedule_id ;
3857: --dkailash update AMS_EVENT_OFFERS_ALL_B table for l_activity_type_code ='EVENTS' added for bug #11830352
3858: IF (l_related_event_id IS NOT NULL and l_activity_type_code ='EVENTS')
3859: THEN
3860: l_event_status_id := AMS_Utility_PVT.get_default_user_status('AMS_EVENT_STATUS','ACTIVE');
3861:
3862: UPDATE AMS_EVENT_OFFERS_ALL_B
3863: SET SYSTEM_STATUS_CODE = 'ACTIVE',
3864: USER_STATUS_ID=l_event_status_id,

Line 3929: AMS_Utility_PVT.Create_Log (

3925: itemtype => itemtype,
3926: itemkey => itemkey ,
3927: aname => 'SCHEDULE_ID' );
3928:
3929: AMS_Utility_PVT.Create_Log (
3930: x_return_status => l_return_status,
3931: p_arc_log_used_by => 'CSCH',
3932: p_log_used_by_id => l_schedule_id,
3933: p_msg_data => 'Check_Schedule_Act_Type : started',

Line 4060: AMS_Utility_PVT.Create_Log (

4056: itemtype => itemtype,
4057: itemkey => itemkey ,
4058: aname => 'SCHEDULE_ID' );
4059:
4060: AMS_Utility_PVT.Create_Log (
4061: x_return_status => l_log_return_status,
4062: p_arc_log_used_by => 'CSCH',
4063: p_log_used_by_id => l_schedule_id,
4064: p_msg_data => 'Execute_Direct_Marketing : started for schedule id '||l_schedule_id,

Line 4087: AMS_Utility_PVT.Create_Log (

4083: THEN
4084: --
4085: -- Yes => 1.1 Increase usage
4086: --
4087: AMS_Utility_PVT.Create_Log (
4088: x_return_status => l_log_return_status,
4089: p_arc_log_used_by => 'CSCH',
4090: p_log_used_by_id => l_schedule_id,
4091: p_msg_data => 'Execute_Direct_Marketing : Increase usage',

Line 4124: AMS_Utility_PVT.Create_Log (

4120: -- 1.2 Is channel Email, Print, Fax
4121: --
4122: IF (l_activity_id = 10 OR l_activity_id = 20 OR l_activity_id = 480)
4123: THEN
4124: AMS_Utility_PVT.Create_Log (
4125: x_return_status => l_log_return_status,
4126: p_arc_log_used_by => 'CSCH',
4127: p_log_used_by_id => l_schedule_id,
4128: p_msg_data => 'Execute_Direct_Marketing : update previously contacted',

Line 4172: /*AMS_Utility_PVT.Create_Log (

4168: --
4169: -- 1.2.2 Stamp version in ibc_associations table
4170: -- anchaudh : from R12 onwards this stamping of cover letter version will take place in the new event subscription api.
4171: --
4172: /*AMS_Utility_PVT.Create_Log (
4173: x_return_status => l_log_return_status,
4174: p_arc_log_used_by => 'CSCH',
4175: p_log_used_by_id => l_schedule_id,
4176: p_msg_data => 'Execute_Direct_Marketing : Stamping version',

Line 4204: AMS_Utility_PVT.Create_Log (

4200:
4201: --
4202: -- 1.2.3 Send Fulfillment Request
4203: --
4204: AMS_Utility_PVT.Create_Log (
4205: x_return_status => l_log_return_status,
4206: p_arc_log_used_by => 'CSCH',
4207: p_log_used_by_id => l_schedule_id,
4208: p_msg_data => 'Execute_Direct_Marketing : Call to fulfillment',

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

4223: x_msg_data => l_msg_data,
4224: x_request_history_id => l_request_id,
4225: p_schedule_id => l_schedule_id,
4226: -- user id passing added by anchaudh on 09-nov-2004 for bug# 3799053
4227: p_user_id => Ams_Utility_pvt.get_user_id(l_csch_owner_user_id)
4228: ) ;
4229:
4230: AMS_Utility_PVT.Create_Log (
4231: x_return_status => l_log_return_status,

Line 4230: AMS_Utility_PVT.Create_Log (

4226: -- user id passing added by anchaudh on 09-nov-2004 for bug# 3799053
4227: p_user_id => Ams_Utility_pvt.get_user_id(l_csch_owner_user_id)
4228: ) ;
4229:
4230: AMS_Utility_PVT.Create_Log (
4231: x_return_status => l_log_return_status,
4232: p_arc_log_used_by => 'CSCH',
4233: p_log_used_by_id => l_schedule_id,
4234: p_msg_data => 'Execute_Direct_Marketing : Call to fulfillment : Return status is '||l_return_status,

Line 4253: AMS_Utility_PVT.Create_Log (

4249:
4250: --
4251: -- 1.2.4 Update list sent out date
4252: --
4253: AMS_Utility_PVT.Create_Log (
4254: x_return_status => l_log_return_status,
4255: p_arc_log_used_by => 'CSCH',
4256: p_log_used_by_id => l_schedule_id,
4257: p_msg_data => 'Execute_Direct_Marketing : calling update_list_send_out_date ',

Line 4272: AMS_Utility_PVT.Create_Log (

4268: x_msg_data => l_msg_data,
4269:
4270: p_list_header_id => l_list_id);
4271:
4272: AMS_Utility_PVT.Create_Log (
4273: x_return_status => l_log_return_status,
4274: p_arc_log_used_by => 'CSCH',
4275: p_log_used_by_id => l_schedule_id,
4276: p_msg_data => 'Execute_Direct_Marketing : update_list_send_out_date : Return status is '||l_return_status,

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

4296: -- pls refer bug# 3553087
4297:
4298: ELSE
4299: -- if TGRP does not exist
4300: -- AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_TARGET_GROUP');
4301:
4302: -- Throw a valid error, if TG does not exist.. Filter should be on channel email.fax/print and Telemarketing.
4303: -- fix for bug # 4184571
4304: IF (l_activity_id = 10 OR l_activity_id = 20 OR l_activity_id = 460 OR l_activity_id = 480)

Line 4307: AMS_Utility_PVT.Create_Log (

4303: -- fix for bug # 4184571
4304: IF (l_activity_id = 10 OR l_activity_id = 20 OR l_activity_id = 460 OR l_activity_id = 480)
4305: THEN
4306:
4307: AMS_Utility_PVT.Create_Log (
4308: x_return_status => l_log_return_status,
4309: p_arc_log_used_by => 'CSCH',
4310: p_log_used_by_id => l_schedule_id,
4311: p_msg_data => 'Execute_Direct_Marketing : Target Group is empty',

Line 4396: AMS_Utility_PVT.Create_Log (

4392: l_user_id := FND_GLOBAL.USER_ID;
4393: l_resp_id := FND_GLOBAL.RESP_ID;
4394: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
4395:
4396: AMS_Utility_PVT.Create_Log (
4397: x_return_status => l_return_status,
4398: p_arc_log_used_by => 'CSCH',
4399: p_log_used_by_id => l_schedule_id,
4400: p_msg_data => 'Execute_Sales : started with '||TO_CHAR(l_user_id)||' '||TO_CHAR(l_resp_id)||' '||TO_CHAR(l_resp_appl_id),

Line 4408: AMS_Utility_PVT.Create_Log (

4404: -- Call the api to execute the sales schedule , return the error flag in l_return_status
4405: --generate_leads(l_schedule_id,'CSCH',l_return_status);
4406: generate_leads(l_schedule_id,'CSCH',l_return_status,itemtype,itemkey);--anchaudh changed the signature of this api for the leads bug.
4407:
4408: AMS_Utility_PVT.Create_Log (
4409: x_return_status => l_return_status,
4410: p_arc_log_used_by => 'CSCH',
4411: p_log_used_by_id => l_schedule_id,
4412: p_msg_data => 'Execute_Sales : done',

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

4606: BEGIN
4607: x_return_status := FND_API.g_ret_sts_success;
4608:
4609: IF (AMS_DEBUG_HIGH_ON) THEN
4610: AMS_Utility_PVT.debug_message('generate_leads: Enter');
4611: END IF;
4612:
4613: IF(p_obj_type <> 'CSCH') THEN
4614:

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

4612:
4613: IF(p_obj_type <> 'CSCH') THEN
4614:
4615: IF (AMS_DEBUG_HIGH_ON) THEN
4616: AMS_UTILITY_Pvt.debug_message('generate_leads: Unsupported object type : '||p_obj_type);
4617: END IF;
4618:
4619: x_return_status := FND_API.g_ret_sts_error;
4620: return;

Line 4623: AMS_Utility_PVT.Create_Log (

4619: x_return_status := FND_API.g_ret_sts_error;
4620: return;
4621: END IF;
4622:
4623: AMS_Utility_PVT.Create_Log (
4624: x_return_status => l_return_status,
4625: p_arc_log_used_by => 'CSCH',
4626: p_log_used_by_id => p_obj_id,
4627: p_msg_data => 'Starting lead generation process schedule id is ' || to_char(p_obj_id),

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

4657: OPEN c_schedule_details_csr(p_obj_id);
4658: FETCH c_schedule_details_csr INTO l_schedule_details;
4659: IF(c_schedule_details_csr%NOTFOUND) THEN
4660: IF (AMS_DEBUG_HIGH_ON) THEN
4661: AMS_UTILITY_Pvt.debug_message('generate_leads: No Schedule details found for '||TO_CHAR(p_obj_id));
4662: END IF;
4663: CLOSE c_schedule_details_csr;
4664: x_return_status := FND_API.g_ret_sts_error;
4665: return;

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

4669: OPEN c_batch_id;
4670: FETCH c_batch_id INTO l_batch_id;
4671: CLOSE c_batch_id;
4672: IF (AMS_DEBUG_HIGH_ON) THEN
4673: AMS_UTILITY_Pvt.debug_message('generate_leads: generated batch id: '||TO_CHAR(l_batch_id));
4674: END IF;
4675:
4676: -- bulk collect party related info
4677: -- soagrawa 09-dec-2005 added LIMIT on this bulk collect bug 4461415 and moved it to a cursor

Line 4686: AMS_Utility_PVT.Create_Log (

4682: fetch c_parties
4683: BULK COLLECT INTO l_party_types, l_contact_point_party_ids, l_main_party_ids, l_rel_party_ids
4684: LIMIT l_batch_size;
4685:
4686: AMS_Utility_PVT.Create_Log (
4687: x_return_status => l_return_status,
4688: p_arc_log_used_by => 'CSCH',
4689: p_log_used_by_id => p_obj_id,
4690: p_msg_data => 'Lead interface processing ' || l_main_party_ids.count,

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

4751:
4752: close c_parties;
4753:
4754: IF (AMS_DEBUG_HIGH_ON) THEN
4755: AMS_Utility_PVT.debug_message('generate_leads: insertion done in lead interface tables');
4756: END IF;
4757:
4758:
4759:

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

4821:
4822:
4823:
4824: IF (AMS_DEBUG_HIGH_ON) THEN
4825: AMS_UTILITY_Pvt.debug_message('generate_leads: No. of Products/Categories : '||TO_CHAR(l_no_of_prods));
4826: END IF;
4827:
4828: -- At this point we will have added all the records in as_import_interface table.
4829: -- Now we can call the concurrent program for lead process.

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

4831: FETCH c_loaded_rows_for_lead INTO l_loaded_rows;
4832: CLOSE c_loaded_rows_for_lead;
4833:
4834: IF (AMS_DEBUG_HIGH_ON) THEN
4835: AMS_Utility_PVT.debug_message('generate_leads: No of lead header rows created : '||TO_CHAR(l_loaded_rows));
4836: END IF;
4837:
4838: AMS_Utility_PVT.Create_Log (
4839: x_return_status => l_return_status,

Line 4838: AMS_Utility_PVT.Create_Log (

4834: IF (AMS_DEBUG_HIGH_ON) THEN
4835: AMS_Utility_PVT.debug_message('generate_leads: No of lead header rows created : '||TO_CHAR(l_loaded_rows));
4836: END IF;
4837:
4838: AMS_Utility_PVT.Create_Log (
4839: x_return_status => l_return_status,
4840: p_arc_log_used_by => 'CSCH',
4841: p_log_used_by_id => p_obj_id,
4842: p_msg_data => 'No. of lead headers generated '||TO_CHAR(l_loaded_rows),

Line 4879: AMS_Utility_PVT.Create_Log (

4875: );
4876:
4877: --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);
4878:
4879: AMS_Utility_PVT.Create_Log (
4880: x_return_status => l_return_status,
4881: p_arc_log_used_by => 'CSCH',
4882: p_log_used_by_id => p_obj_id,
4883: 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 4889: AMS_Utility_PVT.Create_Log (

4885: );
4886:
4887: IF l_request_id = 0 THEN
4888: l_msg_data := fnd_message.get;
4889: AMS_Utility_PVT.Create_Log (
4890: x_return_status => l_return_status,
4891: p_arc_log_used_by => 'CSCH',
4892: p_log_used_by_id => p_obj_id,
4893: p_msg_data => l_msg_data,

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

4899: END IF;
4900:
4901: -- Import completed successfully
4902: IF (AMS_DEBUG_HIGH_ON) THEN
4903: AMS_Utility_PVT.debug_message('generate_leads: Submitted Lead import request with request id : '||TO_CHAR(l_request_id));
4904: AMS_Utility_PVT.debug_message('generate_leads: End');
4905: END IF;
4906:
4907: END generate_leads;

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

4900:
4901: -- Import completed successfully
4902: IF (AMS_DEBUG_HIGH_ON) THEN
4903: AMS_Utility_PVT.debug_message('generate_leads: Submitted Lead import request with request id : '||TO_CHAR(l_request_id));
4904: AMS_Utility_PVT.debug_message('generate_leads: End');
4905: END IF;
4906:
4907: END generate_leads;
4908:

Line 4945: AMS_Utility_PVT.Create_Log (

4941: itemtype => itemtype,
4942: itemkey => itemkey ,
4943: aname => 'SCHEDULE_ID' );
4944:
4945: AMS_Utility_PVT.Create_Log (
4946: x_return_status => l_return_status,
4947: p_arc_log_used_by => 'CSCH',
4948: p_log_used_by_id => l_schedule_id,
4949: p_msg_data => 'Check_WF_Error : started',

Line 5004: AMS_Utility_PVT.debug_message (

5000: l_return_status VARCHAR2(1);
5001: BEGIN
5002: l_api_name := p_api_name;
5003: l_log_mesg := p_log_message;
5004: AMS_Utility_PVT.debug_message (
5005: p_log_level => g_log_level,
5006: p_module_name => 'ams.plsql.'||'.'|| g_pkg_name||'.'||l_api_name||'.'||l_log_mesg,
5007: p_text => p_log_message
5008: );

Line 5010: AMS_Utility_PVT.Create_Log (

5006: p_module_name => 'ams.plsql.'||'.'|| g_pkg_name||'.'||l_api_name||'.'||l_log_mesg,
5007: p_text => p_log_message
5008: );
5009:
5010: AMS_Utility_PVT.Create_Log (
5011: x_return_status => l_return_status,
5012: p_arc_log_used_by => 'CSCH',
5013: p_log_used_by_id => 1,
5014: p_msg_data => p_log_message,

Line 5702: /*AMS_UTILITY_PVT.Convert_Timezone(

5698: itemkey => itemkey ,
5699: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');
5700:
5701: --anchaudh: commented out on 11 Jun '05 to fix bug#4477717 .
5702: /*AMS_UTILITY_PVT.Convert_Timezone(
5703: p_init_msg_list => FND_API.G_TRUE,
5704: x_return_status => l_return_status,
5705: x_msg_count => l_msg_count,
5706: x_msg_data => l_msg_data,

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

5948:
5949: -- input debug messages.
5950: IF (AMS_DEBUG_HIGH_ON) THEN
5951:
5952: AMS_Utility_PVT.debug_message(l_api_name || ': start');
5953:
5954: END IF;
5955:
5956:

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

6010: p_parameterlist => l_parameter_list);
6011:
6012: IF (AMS_DEBUG_HIGH_ON) THEN
6013:
6014: AMS_Utility_PVT.debug_message('Raise Business event for User Status Change' || ' ' || l_new_item_key);
6015:
6016: END IF;
6017:
6018:

Line 6071: AMS_Utility_PVT.Create_Log (

6067: LOOP
6068: FETCH c_citem_assoc INTO l_association_id, l_citem_id, l_citem_ver_id;
6069: EXIT WHEN c_citem_assoc%NOTFOUND;
6070:
6071: AMS_Utility_PVT.Create_Log (
6072: x_return_status => l_log_return_status,
6073: p_arc_log_used_by => 'CSCH',
6074: p_log_used_by_id => l_schedule_id,
6075: p_msg_data => 'HANDLE_COLLATERAL : Stamping collateral versions',

Line 6200: AMS_Utility_PVT.Create_Log (

6196: itemtype => itemtype,
6197: itemkey => itemkey ,
6198: aname => 'SCHEDULE_ID' ));
6199:
6200: AMS_Utility_PVT.Create_Log (
6201: x_return_status => l_return_status,
6202: p_arc_log_used_by => 'CSCH',
6203: p_log_used_by_id => l_schedule_id,
6204: p_msg_data => 'CHECK_NOTIFICATION_PREFERENCE : started',

Line 6214: AMS_Utility_PVT.Create_Log (

6210: CLOSE l_sch_det;
6211:
6212: IF ( l_flag is not null and l_flag = 'Y' ) THEN
6213: result := 'COMPLETE:T' ;
6214: AMS_Utility_PVT.Create_Log (
6215: x_return_status => l_return_status,
6216: p_arc_log_used_by => 'CSCH',
6217: p_log_used_by_id => l_schedule_id,
6218: p_msg_data => 'CHECK_NOTIFICATION_PREFERENCE : NOTIFICATION PREFERENCE IS YES for schedule id '||l_schedule_id,

Line 6223: AMS_Utility_PVT.Create_Log (

6219: p_msg_type => 'DEBUG'
6220: );
6221:
6222: ELSE
6223: AMS_Utility_PVT.Create_Log (
6224: x_return_status => l_return_status,
6225: p_arc_log_used_by => 'CSCH',
6226: p_log_used_by_id => l_schedule_id,
6227: p_msg_data => 'CHECK_NOTIFICATION_PREFERENCE : NOTIFICATION PREFERENCE IS NO for schedule id '||l_schedule_id,