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_CAMP_SCHEDULE_PVT dependencies on AMS_UTILITY_PVT

Line 21: -- 01-Aug-2001 ptendulk Replaced ams_utility_pvt check_uniqueness call with

17: -- 08-Jul-2001 ptendulk Modified Validate_schedule_rec api, refer bug# 1856924
18: -- 17-Jul-2001 ptendulk Moved the code to start trigger workflow in business rules api
19: -- Change the call to the bus rule api.
20: -- 19-Jul-2001 ptendulk Added columns for eBlast
21: -- 01-Aug-2001 ptendulk Replaced ams_utility_pvt check_uniqueness call with
22: -- manual check. Refer bug #1913448
23: -- 18-Aug-2001 ptendulk Added else if to take the schedule id from the api input
24: -- parameter if passed.
25: -- 11-Sep-2001 ptendulk Added code to add the access to the schedule upon creation

Line 167: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

163:
164: -- Debug Message
165: IF (AMS_DEBUG_HIGH_ON) THEN
166:
167: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
168: END IF;
169:
170:
171: -- Initialize API return status to SUCCESS

Line 178: AMS_UTILITY_PVT.debug_message('before handle_shced_source_code');

174: IF (AMS_DEBUG_HIGH_ON) THEN
175:
176:
177:
178: AMS_UTILITY_PVT.debug_message('before handle_shced_source_code');
179:
180: END IF;
181: -- Handle Status
182: AMS_ScheduleRules_PVT.Handle_Status(

Line 196: AMS_UTILITY_PVT.debug_message('After handle_status');

192: END IF;
193: --
194: IF (AMS_DEBUG_HIGH_ON) THEN
195:
196: AMS_UTILITY_PVT.debug_message('After handle_status');
197: END IF;
198: -- default campaign calendar
199: IF p_schedule_rec.campaign_calendar IS NULL
200: AND (p_schedule_rec.start_period_name IS NOT NULL

Line 210: AMS_UTILITY_PVT.debug_message('before handle_shced_source_code '||p_schedule_rec.campaign_id||'');

206: IF (AMS_DEBUG_HIGH_ON) THEN
207:
208:
209:
210: AMS_UTILITY_PVT.debug_message('before handle_shced_source_code *'||p_schedule_rec.campaign_id||'*');
211:
212: END IF;
213: -- default source_code
214: AMS_ScheduleRules_PVT.Handle_Schedule_Source_Code(

Line 228: AMS_UTILITY_PVT.debug_message('After handle_shced_source_code');

224: RAISE FND_API.g_exc_unexpected_error;
225: END IF;
226: IF (AMS_DEBUG_HIGH_ON) THEN
227:
228: AMS_UTILITY_PVT.debug_message('After handle_shced_source_code');
229: END IF;
230:
231: -- Added BY soagrawa ON 12-oct-2001
232: -- to capitalize the automatically generated source code

Line 240: AMS_Utility_PVT.debug_message('Source code : ' ||l_schedule_rec.source_code );

236: IF (AMS_DEBUG_HIGH_ON) THEN
237:
238:
239:
240: AMS_Utility_PVT.debug_message('Source code : ' ||l_schedule_rec.source_code );
241:
242: END IF;
243: --
244: --

Line 270: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_USER_PROFILE_MISSING' );

266: -- Validate Environment
267: -- =========================================================================
268: IF FND_GLOBAL.User_Id IS NULL
269: THEN
270: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_USER_PROFILE_MISSING' );
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:
274: -- If activity type code = 'EVENTS' create the underlying event for R12

Line 338: AMS_UTILITY_PVT.debug_message('before calling create event offer');

334: l_event_offer_rec.FUND_AMOUNT_TC := NULL;
335:
336: -- Debug message
337: IF (AMS_DEBUG_HIGH_ON) THEN
338: AMS_UTILITY_PVT.debug_message('before calling create event offer');
339: END IF;
340:
341: AMS_EventOffer_PUB.create_EventOffer(
342: p_api_version => 1.0,

Line 356: AMS_UTILITY_PVT.debug_message('after calling create event offer '||l_new_event_offer_id);

352:
353:
354: -- Debug message
355: IF (AMS_DEBUG_HIGH_ON) THEN
356: AMS_UTILITY_PVT.debug_message('after calling create event offer '||l_new_event_offer_id);
357: END IF;
358:
359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: RAISE FND_API.G_EXC_ERROR;

Line 375: AMS_UTILITY_PVT.debug_message('Private API: Validate_Camp_Schedule');

371: THEN
372: -- Debug message
373: IF (AMS_DEBUG_HIGH_ON) THEN
374:
375: AMS_UTILITY_PVT.debug_message('Private API: Validate_Camp_Schedule');
376: END IF;
377:
378: -- Invoke validation procedures
379: Validate_camp_schedule(

Line 408: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler source :'||p_schedule_rec.source_code); END IF;

404: ) ;
405: END IF ;
406:
407: -- Debug Message
408: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler source :'||p_schedule_rec.source_code); END IF;
409:
410: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row)
411: AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row(
412: px_schedule_id => l_schedule_id,

Line 538: AMS_Utility_PVT.debug_message('Before Source code : '||l_schedule_id );

534: END IF;
535:
536:
537: IF (AMS_DEBUG_HIGH_ON) THEN
538: AMS_Utility_PVT.debug_message('Before Source code : '||l_schedule_id );
539: END IF;
540:
541: -- need to push the source code to ams_source_codes
542: IF p_schedule_rec.use_parent_code_flag = 'N' THEN

Line 638: AMS_Utility_PVT.debug_message('Metrics Copied Status '||x_return_status);

634: p_act_metric_used_by_type => NULL
635: );
636: IF (AMS_DEBUG_HIGH_ON) THEN
637:
638: AMS_Utility_PVT.debug_message('Metrics Copied Status '||x_return_status);
639: END IF;
640: IF x_return_status = FND_API.g_ret_sts_error THEN
641: RAISE FND_API.g_exc_error;
642: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 645: AMS_Utility_PVT.debug_message('Errr '||sqlerrm);

641: RAISE FND_API.g_exc_error;
642: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
643: IF (AMS_DEBUG_HIGH_ON) THEN
644:
645: AMS_Utility_PVT.debug_message('Errr '||sqlerrm);
646: END IF;
647: RAISE FND_API.g_exc_unexpected_error;
648: END IF;
649:

Line 654: AMS_Utility_PVT.debug_message('Create Target Group for schedule : '||l_schedule_id );

650: IF (AMS_DEBUG_HIGH_ON) THEN
651:
652:
653:
654: AMS_Utility_PVT.debug_message('Create Target Group for schedule : '||l_schedule_id );
655:
656: END IF;
657: IF p_schedule_rec.activity_type_code IN ('DIRECT_MARKETING','INTERNET','DEAL','TRADE_PROMOTION') THEN
658: AMS_ScheduleRules_PVT.Create_list(

Line 667: AMS_Utility_PVT.debug_message('Errr '||sqlerrm);

663: RAISE FND_API.g_exc_error;
664: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
665: IF (AMS_DEBUG_HIGH_ON) THEN
666:
667: AMS_Utility_PVT.debug_message('Errr '||sqlerrm);
668: END IF;
669: RAISE FND_API.g_exc_unexpected_error;
670: END IF;
671: END IF ;

Line 687: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

683:
684: -- Debug Message
685: IF (AMS_DEBUG_HIGH_ON) THEN
686:
687: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
688: END IF;
689:
690: -- Standard call to get message count and if count is 1, get message info.
691: FND_MSG_PUB.Count_And_Get

Line 697: WHEN AMS_Utility_PVT.resource_locked THEN

693: p_data => x_msg_data
694: );
695: EXCEPTION
696:
697: WHEN AMS_Utility_PVT.resource_locked THEN
698: x_return_status := FND_API.g_ret_sts_error;
699: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');
700:
701: WHEN FND_API.G_EXC_ERROR THEN

Line 699: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');

695: EXCEPTION
696:
697: WHEN AMS_Utility_PVT.resource_locked THEN
698: x_return_status := FND_API.g_ret_sts_error;
699: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');
700:
701: WHEN FND_API.G_EXC_ERROR THEN
702: ROLLBACK TO CREATE_Camp_Schedule_PVT;
703: x_return_status := FND_API.G_RET_STS_ERROR;

Line 832: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

828:
829: -- Debug Message
830: IF (AMS_DEBUG_HIGH_ON) THEN
831:
832: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
833: END IF;
834:
835:
836: -- Initialize API return status to SUCCESS

Line 842: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

838:
839: -- Debug Message
840: IF (AMS_DEBUG_HIGH_ON) THEN
841:
842: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
843: END IF;
844:
845:
846: OPEN c_get_Camp_Schedule(l_tar_schedule_rec.schedule_id);

Line 861: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');

857: END IF;
858: -- Debug Message
859: IF (AMS_DEBUG_HIGH_ON) THEN
860:
861: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
862: END IF;
863: CLOSE c_get_Camp_Schedule;
864:
865:

Line 906: AMS_Utility_PVT.Error_Message('AMS_TRIG_DETAILS_NO_UPDATE');

902: OR l_complete_rec.trigger_id <> l_trigger_id
903: OR l_complete_rec.trig_repeat_flag <> l_trig_repeat_flag
904: OR l_complete_rec.tgrp_exclude_prev_flag <> l_tgrp_exclude_prev_flag)
905: THEN
906: AMS_Utility_PVT.Error_Message('AMS_TRIG_DETAILS_NO_UPDATE');
907: x_return_status := FND_API.G_RET_STS_ERROR;
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;
910: END IF;

Line 1053: AMS_Utility_PVT.validate_locking_rules(

1049: l_change_indicator_array(20) := 'Y';
1050: END IF;
1051:
1052:
1053: AMS_Utility_PVT.validate_locking_rules(
1054: 'AMS'
1055: , 'CSCH'
1056: , 'DETL'
1057: , l_ref_schedule_rec.status_code

Line 1086: AMS_UTILITY_PVT.debug_message('Private API: Validate_Camp_Schedule');

1082: THEN
1083: -- Debug message
1084: IF (AMS_DEBUG_HIGH_ON) THEN
1085:
1086: AMS_UTILITY_PVT.debug_message('Private API: Validate_Camp_Schedule');
1087: END IF;
1088:
1089: -- Invoke validation procedures
1090: Validate_camp_schedule(

Line 1118: AMS_Utility_PVT.debug_message(l_api_name ||': update source code');

1114:
1115: if p_schedule_rec.source_code IS NULL THEN
1116: IF (AMS_DEBUG_HIGH_ON) THEN
1117:
1118: AMS_Utility_PVT.debug_message(l_api_name ||': update source code');
1119: END IF;
1120: end if ;
1121: IF p_schedule_rec.use_parent_code_flag = FND_API.g_miss_char
1122: AND p_schedule_rec.source_code = FND_API.g_miss_char

Line 1130: AMS_Utility_PVT.debug_message(l_api_name ||': update source code222');

1126: -- NULL ;
1127: ELSE
1128: IF (AMS_DEBUG_HIGH_ON) THEN
1129:
1130: AMS_Utility_PVT.debug_message(l_api_name ||': update source code222');
1131: END IF;
1132: AMS_ScheduleRules_PVT.Check_Source_Code(
1133: p_schedule_rec => p_schedule_rec,
1134: x_return_status => x_return_status,

Line 1140: AMS_Utility_PVT.debug_message(l_api_name ||': updated source code '||l_source_code);

1136: x_source_code => l_source_code -- l_complete_rec.source_code
1137: ) ;
1138: IF (AMS_DEBUG_HIGH_ON) THEN
1139:
1140: AMS_Utility_PVT.debug_message(l_api_name ||': updated source code '||l_source_code);
1141: END IF;
1142: IF x_return_status = FND_API.g_ret_sts_error THEN
1143: RAISE FND_API.g_exc_error;
1144: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1157: AMS_Utility_pvt.debug_message('Transaction curr : '||p_schedule_rec.transaction_currency_code);

1153: IF p_schedule_rec.budget_amount_tc IS NOT NULL AND
1154: p_schedule_rec.budget_amount_tc <> FND_API.G_MISS_NUM THEN
1155: IF (AMS_DEBUG_HIGH_ON) THEN
1156:
1157: AMS_Utility_pvt.debug_message('Transaction curr : '||p_schedule_rec.transaction_currency_code);
1158: END IF;
1159: AMS_CampaignRules_PVT.Convert_Camp_Currency(
1160: p_tc_curr => p_schedule_rec.transaction_currency_code,
1161: p_tc_amt => p_schedule_rec.budget_amount_tc,

Line 1199: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler sched : '||to_char(p_schedule_rec.schedule_id));

1195:
1196: -- Debug Message
1197: IF (AMS_DEBUG_HIGH_ON) THEN
1198:
1199: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler sched : '||to_char(p_schedule_rec.schedule_id));
1200: END IF;
1201:
1202: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row)
1203: AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row(

Line 1358: AMS_Utility_PVT.Debug_Message('User Status Id : '||l_complete_rec.user_status_id) ;

1354: IF (AMS_DEBUG_HIGH_ON) THEN
1355:
1356:
1357:
1358: AMS_Utility_PVT.Debug_Message('User Status Id : '||l_complete_rec.user_status_id) ;
1359:
1360: END IF;
1361:
1362: --insert_log_mesg('Anirban got value of asn_group_id in api Update_Camp_Schedule in amsvschb.pls as :'||p_schedule_rec.asn_group_id);

Line 1391: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1387:
1388: -- Debug Message
1389: IF (AMS_DEBUG_HIGH_ON) THEN
1390:
1391: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1392: END IF;
1393:
1394: -- Standard call to get message count and if count is 1, get message info.
1395: FND_MSG_PUB.Count_And_Get

Line 1401: WHEN AMS_Utility_PVT.resource_locked THEN

1397: p_data => x_msg_data
1398: );
1399: EXCEPTION
1400:
1401: WHEN AMS_Utility_PVT.resource_locked THEN
1402: x_return_status := FND_API.g_ret_sts_error;
1403: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');
1404:
1405: WHEN FND_API.G_EXC_ERROR THEN

Line 1403: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');

1399: EXCEPTION
1400:
1401: WHEN AMS_Utility_PVT.resource_locked THEN
1402: x_return_status := FND_API.g_ret_sts_error;
1403: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');
1404:
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: ROLLBACK TO UPDATE_Camp_Schedule_PVT;
1407: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1515: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1511:
1512: -- Debug Message
1513: IF (AMS_DEBUG_HIGH_ON) THEN
1514:
1515: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1516: END IF;
1517:
1518: -- Initialize API return status to SUCCESS
1519: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1525: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');

1521: OPEN c_camp_schedule;
1522: FETCH c_camp_schedule INTO l_campaign_id, l_schedule_id, l_status_code, l_cascade_flag, l_source_code;
1523: IF (c_camp_schedule%NOTFOUND) THEN
1524: CLOSE c_camp_schedule;
1525: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
1526: RAISE FND_API.g_exc_error;
1527: END IF;
1528: CLOSE c_camp_schedule;
1529:

Line 1536: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

1532: --
1533: -- Debug Message
1534: IF (AMS_DEBUG_HIGH_ON) THEN
1535:
1536: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1537: END IF;
1538:
1539: -- Delete schedule only if the status is new.
1540: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row)

Line 1586: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1582:
1583: -- Debug Message
1584: IF (AMS_DEBUG_HIGH_ON) THEN
1585:
1586: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1587: END IF;
1588:
1589: -- Standard call to get message count and if count is 1, get message info.
1590: FND_MSG_PUB.Count_And_Get

Line 1596: WHEN AMS_Utility_PVT.resource_locked THEN

1592: p_data => x_msg_data
1593: );
1594: EXCEPTION
1595:
1596: WHEN AMS_Utility_PVT.resource_locked THEN
1597: x_return_status := FND_API.g_ret_sts_error;
1598: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
1599:
1600: WHEN FND_API.G_EXC_ERROR THEN

Line 1598: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');

1594: EXCEPTION
1595:
1596: WHEN AMS_Utility_PVT.resource_locked THEN
1597: x_return_status := FND_API.g_ret_sts_error;
1598: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
1599:
1600: WHEN FND_API.G_EXC_ERROR THEN
1601: ROLLBACK TO DELETE_Camp_Schedule_PVT;
1602: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1677: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1673:
1674: -- Debug Message
1675: IF (AMS_DEBUG_HIGH_ON) THEN
1676:
1677: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1678: END IF;
1679:
1680: -- Initialize message list if p_init_msg_list is set to TRUE.
1681: IF FND_API.to_Boolean( p_init_msg_list )

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

1702: IF (AMS_DEBUG_HIGH_ON) THEN
1703:
1704:
1705:
1706: AMS_Utility_PVT.debug_message(l_full_name||': start');
1707:
1708: END IF;
1709: OPEN c_Camp_Schedule;
1710: FETCH c_Camp_Schedule INTO l_SCHEDULE_ID;

Line 1714: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');

1710: FETCH c_Camp_Schedule INTO l_SCHEDULE_ID;
1711:
1712: IF (c_Camp_Schedule%NOTFOUND) THEN
1713: CLOSE c_Camp_Schedule;
1714: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
1715: RAISE FND_API.g_exc_error;
1716: END IF;
1717: CLOSE c_Camp_Schedule;
1718:

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

1722: p_count => x_msg_count,
1723: p_data => x_msg_data);
1724: IF (AMS_DEBUG_HIGH_ON) THEN
1725:
1726: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1727: END IF;
1728: EXCEPTION
1729:
1730: WHEN AMS_Utility_PVT.resource_locked THEN

Line 1730: WHEN AMS_Utility_PVT.resource_locked THEN

1726: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1727: END IF;
1728: EXCEPTION
1729:
1730: WHEN AMS_Utility_PVT.resource_locked THEN
1731: x_return_status := FND_API.g_ret_sts_error;
1732: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
1733:
1734: WHEN FND_API.G_EXC_ERROR THEN

Line 1732: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');

1728: EXCEPTION
1729:
1730: WHEN AMS_Utility_PVT.resource_locked THEN
1731: x_return_status := FND_API.g_ret_sts_error;
1732: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
1733:
1734: WHEN FND_API.G_EXC_ERROR THEN
1735: ROLLBACK TO LOCK_Camp_Schedule_PVT;
1736: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1792: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

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

Line 1797: AMS_Utility_PVT.Error_Message('AMS_CSCH_ID_DUPLICATE');

1793: 'ams_campaign_schedules_b',
1794: 'schedule_id = ' || p_schedule_rec.schedule_id
1795: );
1796: IF l_valid_flag = FND_API.g_false THEN
1797: AMS_Utility_PVT.Error_Message('AMS_CSCH_ID_DUPLICATE');
1798: x_return_status := FND_API.g_ret_sts_error;
1799: RETURN;
1800: END IF;
1801: END IF;

Line 1805: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

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

Line 1810: AMS_Utility_PVT.Error_Message('AMS_EVO_DUPLICATE_ID');

1806: 'ams_campaign_schedules_b',
1807: 'related_event_id = ' || p_schedule_rec.related_event_id
1808: );
1809: IF l_valid_flag = FND_API.g_false THEN
1810: AMS_Utility_PVT.Error_Message('AMS_EVO_DUPLICATE_ID');
1811: x_return_status := FND_API.g_ret_sts_error;
1812: RETURN;
1813: END IF;
1814: END IF;

Line 1842: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CAMP_ID') ;

1838:
1839: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1840:
1841: IF p_schedule_rec.campaign_id = FND_API.g_miss_num OR p_schedule_rec.campaign_id IS NULL THEN
1842: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CAMP_ID') ;
1843: x_return_status := FND_API.g_ret_sts_error;
1844: RETURN;
1845: END IF;
1846:

Line 1849: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_STATUS_ID') ;

1845: END IF;
1846:
1847:
1848: IF p_schedule_rec.user_status_id = FND_API.g_miss_num OR p_schedule_rec.user_status_id IS NULL THEN
1849: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_STATUS_ID') ;
1850: x_return_status := FND_API.g_ret_sts_error;
1851: RETURN;
1852: END IF;
1853:

Line 1856: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_MEDIA_TYPE') ;

1852: END IF;
1853:
1854:
1855: IF p_schedule_rec.activity_type_code = FND_API.g_miss_char OR p_schedule_rec.activity_type_code IS NULL THEN
1856: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_MEDIA_TYPE') ;
1857: x_return_status := FND_API.g_ret_sts_error;
1858: RETURN;
1859: END IF;
1860:

Line 1862: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CUS_SETUP') ;

1858: RETURN;
1859: END IF;
1860:
1861: IF p_schedule_rec.custom_setup_id = FND_API.g_miss_num OR p_schedule_rec.custom_setup_id IS NULL THEN
1862: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CUS_SETUP') ;
1863: x_return_status := FND_API.g_ret_sts_error;
1864: RETURN;
1865: END IF;
1866:

Line 1868: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_TRIG_FLAG') ;

1864: RETURN;
1865: END IF;
1866:
1867: IF p_schedule_rec.triggerable_flag = FND_API.g_miss_char OR p_schedule_rec.triggerable_flag IS NULL THEN
1868: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_TRIG_FLAG') ;
1869: x_return_status := FND_API.g_ret_sts_error;
1870: RETURN;
1871: END IF;
1872:

Line 1874: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_OWNER') ;

1870: RETURN;
1871: END IF;
1872:
1873: IF p_schedule_rec.owner_user_id = FND_API.g_miss_num OR p_schedule_rec.owner_user_id IS NULL THEN
1874: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_OWNER') ;
1875: x_return_status := FND_API.g_ret_sts_error;
1876: RETURN;
1877: END IF;
1878:

Line 1881: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_ACTIVE_FLAG') ;

1877: END IF;
1878:
1879:
1880: IF p_schedule_rec.active_flag = FND_API.g_miss_char OR p_schedule_rec.active_flag IS NULL THEN
1881: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_ACTIVE_FLAG') ;
1882: x_return_status := FND_API.g_ret_sts_error;
1883: RETURN;
1884: END IF;
1885:

Line 1887: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_COUNTRY') ;

1883: RETURN;
1884: END IF;
1885:
1886: IF p_schedule_rec.country_id = FND_API.g_miss_num OR p_schedule_rec.country_id IS NULL THEN
1887: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_COUNTRY') ;
1888: x_return_status := FND_API.g_ret_sts_error;
1889: RETURN;
1890: END IF;
1891:

Line 1893: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_NAME') ;

1889: RETURN;
1890: END IF;
1891:
1892: IF p_schedule_rec.schedule_name = FND_API.g_miss_char OR p_schedule_rec.schedule_name IS NULL THEN
1893: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_NAME') ;
1894: x_return_status := FND_API.g_ret_sts_error;
1895: RETURN;
1896: END IF;
1897: ELSE

Line 1899: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CAMP_ID') ;

1895: RETURN;
1896: END IF;
1897: ELSE
1898: IF p_schedule_rec.campaign_id IS NULL THEN
1899: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CAMP_ID') ;
1900: x_return_status := FND_API.g_ret_sts_error;
1901: RETURN;
1902: END IF;
1903:

Line 1905: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_STATUS_ID') ;

1901: RETURN;
1902: END IF;
1903:
1904: IF p_schedule_rec.user_status_id IS NULL THEN
1905: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_STATUS_ID') ;
1906: x_return_status := FND_API.g_ret_sts_error;
1907: RETURN;
1908: END IF;
1909:

Line 1911: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_MEDIA_TYPE') ;

1907: RETURN;
1908: END IF;
1909:
1910: IF p_schedule_rec.activity_type_code IS NULL THEN
1911: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_MEDIA_TYPE') ;
1912: x_return_status := FND_API.g_ret_sts_error;
1913: RETURN;
1914: END IF;
1915:

Line 1917: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CUS_SETUP') ;

1913: RETURN;
1914: END IF;
1915:
1916: IF p_schedule_rec.custom_setup_id IS NULL THEN
1917: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CUS_SETUP') ;
1918: x_return_status := FND_API.g_ret_sts_error;
1919: RETURN;
1920: END IF;
1921:

Line 1923: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_TRIG_FLAG') ;

1919: RETURN;
1920: END IF;
1921:
1922: IF p_schedule_rec.triggerable_flag IS NULL THEN
1923: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_TRIG_FLAG') ;
1924: x_return_status := FND_API.g_ret_sts_error;
1925: RETURN;
1926: END IF;
1927:

Line 1929: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_OWNER') ;

1925: RETURN;
1926: END IF;
1927:
1928: IF p_schedule_rec.owner_user_id IS NULL THEN
1929: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_OWNER') ;
1930: x_return_status := FND_API.g_ret_sts_error;
1931: RETURN;
1932: END IF;
1933:

Line 1935: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_ACTIVE_FLAG') ;

1931: RETURN;
1932: END IF;
1933:
1934: IF p_schedule_rec.active_flag IS NULL THEN
1935: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_ACTIVE_FLAG') ;
1936: x_return_status := FND_API.g_ret_sts_error;
1937: RETURN;
1938: END IF;
1939:

Line 1941: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_COUNTRY') ;

1937: RETURN;
1938: END IF;
1939:
1940: IF p_schedule_rec.country_id IS NULL THEN
1941: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_COUNTRY') ;
1942: x_return_status := FND_API.g_ret_sts_error;
1943: RETURN;
1944: END IF;
1945:

Line 1947: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_NAME') ;

1943: RETURN;
1944: END IF;
1945:
1946: IF p_schedule_rec.schedule_name IS NULL THEN
1947: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_NAME') ;
1948: x_return_status := FND_API.g_ret_sts_error;
1949: RETURN;
1950: END IF;
1951: END IF;

Line 1985: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;

1981: IF p_schedule_rec.campaign_id <> FND_API.g_miss_num THEN
1982: l_table_name := 'ams_campaigns_all_b' ;
1983: l_pk_name := 'campaign_id' ;
1984: l_pk_value := p_schedule_rec.campaign_id ;
1985: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
1986: l_additional_where_clause := NULL ;
1987:
1988: IF AMS_Utility_PVT.check_fk_exists(
1989: p_table_name => l_table_name,

Line 1988: IF AMS_Utility_PVT.check_fk_exists(

1984: l_pk_value := p_schedule_rec.campaign_id ;
1985: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
1986: l_additional_where_clause := NULL ;
1987:
1988: IF AMS_Utility_PVT.check_fk_exists(
1989: p_table_name => l_table_name,
1990: p_pk_name => l_pk_name,
1991: p_pk_value => l_pk_value,
1992: p_pk_data_type => l_pk_data_type,

Line 1996: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_CAMP_ID') ;

1992: p_pk_data_type => l_pk_data_type,
1993: p_additional_where_clause => l_additional_where_clause
1994: ) = FND_API.g_false
1995: THEN
1996: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_CAMP_ID') ;
1997: x_return_status := FND_API.g_ret_sts_error;
1998: RETURN;
1999: END IF;
2000: END IF;

Line 2007: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;

2003: IF p_schedule_rec.user_status_id <> FND_API.g_miss_num THEN
2004: l_table_name := 'ams_user_statuses_b' ;
2005: l_pk_name := 'user_status_id' ;
2006: l_pk_value := p_schedule_rec.user_status_id ;
2007: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2008: l_additional_where_clause := ' NVL(start_date_active,SYSDATE) <= SYSDATE ' ||
2009: ' AND NVL(end_date_active,SYSDATE) >= SYSDATE ';
2010:
2011: IF AMS_Utility_PVT.check_fk_exists(

Line 2011: IF AMS_Utility_PVT.check_fk_exists(

2007: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2008: l_additional_where_clause := ' NVL(start_date_active,SYSDATE) <= SYSDATE ' ||
2009: ' AND NVL(end_date_active,SYSDATE) >= SYSDATE ';
2010:
2011: IF AMS_Utility_PVT.check_fk_exists(
2012: p_table_name => l_table_name,
2013: p_pk_name => l_pk_name,
2014: p_pk_value => l_pk_value,
2015: p_pk_data_type => l_pk_data_type,

Line 2019: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_USER_STATUS') ;

2015: p_pk_data_type => l_pk_data_type,
2016: p_additional_where_clause => l_additional_where_clause
2017: ) = FND_API.g_false
2018: THEN
2019: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_USER_STATUS') ;
2020: x_return_status := FND_API.g_ret_sts_error;
2021: RETURN;
2022: END IF;
2023: END IF;

Line 2030: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;

2026: IF p_schedule_rec.timezone_id <> FND_API.g_miss_num
2027: AND p_schedule_rec.timezone_id IS NOT NULL THEN
2028: l_table_name := 'fnd_timezones_b';
2029: l_pk_name := 'upgrade_tz_id' ;
2030: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2031: l_pk_value := p_schedule_rec.timezone_id ;
2032: l_additional_where_clause := null ;
2033:
2034: IF AMS_Utility_PVT.check_fk_exists(

Line 2034: IF AMS_Utility_PVT.check_fk_exists(

2030: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2031: l_pk_value := p_schedule_rec.timezone_id ;
2032: l_additional_where_clause := null ;
2033:
2034: IF AMS_Utility_PVT.check_fk_exists(
2035: p_table_name => l_table_name,
2036: p_pk_name => l_pk_name,
2037: p_pk_value => l_pk_value,
2038: p_pk_data_type => l_pk_data_type,

Line 2042: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_CAMP_ID') ;

2038: p_pk_data_type => l_pk_data_type,
2039: p_additional_where_clause => l_additional_where_clause
2040: ) = FND_API.g_false
2041: THEN
2042: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_CAMP_ID') ;
2043: x_return_status := FND_API.g_ret_sts_error;
2044: RETURN;
2045: END IF;
2046: END IF;

Line 2052: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;

2048: -- Check Custom Setup Id
2049: IF p_schedule_rec.custom_setup_id <> FND_API.g_miss_num THEN
2050: l_table_name := 'ams_custom_setups_b';
2051: l_pk_name := 'custom_setup_id' ;
2052: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2053: l_pk_value := p_schedule_rec.custom_setup_id ;
2054: l_additional_where_clause := null ;
2055:
2056: IF AMS_Utility_PVT.check_fk_exists(

Line 2056: IF AMS_Utility_PVT.check_fk_exists(

2052: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2053: l_pk_value := p_schedule_rec.custom_setup_id ;
2054: l_additional_where_clause := null ;
2055:
2056: IF AMS_Utility_PVT.check_fk_exists(
2057: p_table_name => l_table_name,
2058: p_pk_name => l_pk_name,
2059: p_pk_value => l_pk_value,
2060: p_pk_data_type => l_pk_data_type,

Line 2064: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_SETUP') ;

2060: p_pk_data_type => l_pk_data_type,
2061: p_additional_where_clause => l_additional_where_clause
2062: ) = FND_API.g_false
2063: THEN
2064: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_SETUP') ;
2065: x_return_status := FND_API.g_ret_sts_error;
2066: RETURN;
2067: END IF;
2068: END IF;

Line 2076: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;

2072: IF p_schedule_rec.trigger_id <> FND_API.g_miss_num AND
2073: p_schedule_rec.trigger_id IS NOT NULL THEN
2074: l_table_name := 'ams_triggers';
2075: l_pk_name := 'trigger_id' ;
2076: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2077: l_pk_value := p_schedule_rec.trigger_id ;
2078: l_additional_where_clause := null ;
2079:
2080: IF AMS_Utility_PVT.check_fk_exists(

Line 2080: IF AMS_Utility_PVT.check_fk_exists(

2076: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2077: l_pk_value := p_schedule_rec.trigger_id ;
2078: l_additional_where_clause := null ;
2079:
2080: IF AMS_Utility_PVT.check_fk_exists(
2081: p_table_name => l_table_name,
2082: p_pk_name => l_pk_name,
2083: p_pk_value => l_pk_value,
2084: p_pk_data_type => l_pk_data_type,

Line 2088: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_TRIGGER') ;

2084: p_pk_data_type => l_pk_data_type,
2085: p_additional_where_clause => l_additional_where_clause
2086: ) = FND_API.g_false
2087: THEN
2088: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_TRIGGER') ;
2089: x_return_status := FND_API.g_ret_sts_error;
2090: RETURN;
2091: END IF;
2092: END IF;

Line 2099: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;

2095: IF p_schedule_rec.notify_user_id <> FND_API.g_miss_num AND
2096: p_schedule_rec.notify_user_id IS NOT NULL THEN
2097: l_table_name := 'ams_jtf_rs_emp_v';
2098: l_pk_name := 'resource_id' ;
2099: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2100: l_pk_value := p_schedule_rec.notify_user_id ;
2101: l_additional_where_clause := null ;
2102:
2103: IF AMS_Utility_PVT.check_fk_exists(

Line 2103: IF AMS_Utility_PVT.check_fk_exists(

2099: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2100: l_pk_value := p_schedule_rec.notify_user_id ;
2101: l_additional_where_clause := null ;
2102:
2103: IF AMS_Utility_PVT.check_fk_exists(
2104: p_table_name => l_table_name,
2105: p_pk_name => l_pk_name,
2106: p_pk_value => l_pk_value,
2107: p_pk_data_type => l_pk_data_type,

Line 2111: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_NOTIFY_TO') ;

2107: p_pk_data_type => l_pk_data_type,
2108: p_additional_where_clause => l_additional_where_clause
2109: ) = FND_API.g_false
2110: THEN
2111: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_NOTIFY_TO') ;
2112: x_return_status := FND_API.g_ret_sts_error;
2113: RETURN;
2114: END IF;
2115: END IF;

Line 2122: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;

2118: IF p_schedule_rec.approver_user_id <> FND_API.g_miss_num AND
2119: p_schedule_rec.approver_user_id IS NOT NULL THEN
2120: l_table_name := 'ams_jtf_rs_emp_v';
2121: l_pk_name := 'resource_id' ;
2122: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2123: l_pk_value := p_schedule_rec.approver_user_id ;
2124: l_additional_where_clause := null ;
2125:
2126: IF AMS_Utility_PVT.check_fk_exists(

Line 2126: IF AMS_Utility_PVT.check_fk_exists(

2122: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2123: l_pk_value := p_schedule_rec.approver_user_id ;
2124: l_additional_where_clause := null ;
2125:
2126: IF AMS_Utility_PVT.check_fk_exists(
2127: p_table_name => l_table_name,
2128: p_pk_name => l_pk_name,
2129: p_pk_value => l_pk_value,
2130: p_pk_data_type => l_pk_data_type,

Line 2134: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_APPROVER') ;

2130: p_pk_data_type => l_pk_data_type,
2131: p_additional_where_clause => l_additional_where_clause
2132: ) = FND_API.g_false
2133: THEN
2134: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_APPROVER') ;
2135: x_return_status := FND_API.g_ret_sts_error;
2136: RETURN;
2137: END IF;
2138: END IF;

Line 2150: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;

2146: IF p_schedule_rec.cover_letter_id <> FND_API.g_miss_num AND
2147: p_schedule_rec.cover_letter_id IS NOT NULL THEN
2148: l_table_name := 'jtf_amv_items_b';
2149: l_pk_name := 'item_id' ;
2150: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2151: l_pk_value := p_schedule_rec.cover_letter_id ;
2152: l_additional_where_clause := ' content_type_id = 20 ' ;
2153:
2154: IF AMS_Utility_PVT.check_fk_exists(

Line 2154: IF AMS_Utility_PVT.check_fk_exists(

2150: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2151: l_pk_value := p_schedule_rec.cover_letter_id ;
2152: l_additional_where_clause := ' content_type_id = 20 ' ;
2153:
2154: IF AMS_Utility_PVT.check_fk_exists(
2155: p_table_name => l_table_name,
2156: p_pk_name => l_pk_name,
2157: p_pk_value => l_pk_value,
2158: p_pk_data_type => l_pk_data_type,

Line 2162: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_COVER_LETTER') ;

2158: p_pk_data_type => l_pk_data_type,
2159: p_additional_where_clause => l_additional_where_clause
2160: ) = FND_API.g_false
2161: THEN
2162: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_COVER_LETTER') ;
2163: x_return_status := FND_API.g_ret_sts_error;
2164: RETURN;
2165: END IF;
2166: END IF;

Line 2173: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;

2169: IF p_schedule_rec.cover_letter_id <> FND_API.g_miss_num AND
2170: p_schedule_rec.cover_letter_id IS NOT NULL THEN
2171: l_table_name := 'ibc_content_items';
2172: l_pk_name := 'content_item_id' ;
2173: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2174: l_pk_value := p_schedule_rec.cover_letter_id ;
2175: -- soagrawa modified on 03-nov-2003 for 11.5.10
2176: --l_additional_where_clause := ' content_type_code = ''AMF_TEMPLATE'' ' ;
2177: l_additional_where_clause := NULL;

Line 2179: IF AMS_Utility_PVT.check_fk_exists(

2175: -- soagrawa modified on 03-nov-2003 for 11.5.10
2176: --l_additional_where_clause := ' content_type_code = ''AMF_TEMPLATE'' ' ;
2177: l_additional_where_clause := NULL;
2178:
2179: IF AMS_Utility_PVT.check_fk_exists(
2180: p_table_name => l_table_name,
2181: p_pk_name => l_pk_name,
2182: p_pk_value => l_pk_value,
2183: p_pk_data_type => l_pk_data_type,

Line 2187: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_COVER_LETTER') ;

2183: p_pk_data_type => l_pk_data_type,
2184: p_additional_where_clause => l_additional_where_clause
2185: ) = FND_API.g_false
2186: THEN
2187: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_COVER_LETTER') ;
2188: x_return_status := FND_API.g_ret_sts_error;
2189: RETURN;
2190: END IF;
2191: END IF;

Line 2200: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;

2196: IF p_schedule_rec.country_id <> FND_API.g_miss_num AND
2197: p_schedule_rec.country_id IS NOT NULL THEN
2198: l_table_name := 'jtf_loc_hierarchies_b';
2199: l_pk_name := 'location_hierarchy_id' ;
2200: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2201: l_pk_value := p_schedule_rec.country_id ;
2202: l_additional_where_clause := null ;
2203:
2204: IF AMS_Utility_PVT.check_fk_exists(

Line 2204: IF AMS_Utility_PVT.check_fk_exists(

2200: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2201: l_pk_value := p_schedule_rec.country_id ;
2202: l_additional_where_clause := null ;
2203:
2204: IF AMS_Utility_PVT.check_fk_exists(
2205: p_table_name => l_table_name,
2206: p_pk_name => l_pk_name,
2207: p_pk_value => l_pk_value,
2208: p_pk_data_type => l_pk_data_type,

Line 2212: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_COUNTRY') ;

2208: p_pk_data_type => l_pk_data_type,
2209: p_additional_where_clause => l_additional_where_clause
2210: ) = FND_API.g_false
2211: THEN
2212: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_COUNTRY') ;
2213: x_return_status := FND_API.g_ret_sts_error;
2214: RETURN;
2215: END IF;
2216: END IF;

Line 2223: l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2 ;

2219: IF p_schedule_rec.language_code <> FND_API.g_miss_char AND
2220: p_schedule_rec.language_code IS NOT NULL THEN
2221: l_table_name := 'fnd_languages';
2222: l_pk_name := 'language_code' ;
2223: l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2 ;
2224: l_pk_value := p_schedule_rec.language_code ;
2225: l_additional_where_clause := null ;
2226:
2227: IF AMS_Utility_PVT.check_fk_exists(

Line 2227: IF AMS_Utility_PVT.check_fk_exists(

2223: l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2 ;
2224: l_pk_value := p_schedule_rec.language_code ;
2225: l_additional_where_clause := null ;
2226:
2227: IF AMS_Utility_PVT.check_fk_exists(
2228: p_table_name => l_table_name,
2229: p_pk_name => l_pk_name,
2230: p_pk_value => l_pk_value,
2231: p_pk_data_type => l_pk_data_type,

Line 2235: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_LANG') ;

2231: p_pk_data_type => l_pk_data_type,
2232: p_additional_where_clause => l_additional_where_clause
2233: ) = FND_API.g_false
2234: THEN
2235: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_LANG') ;
2236: x_return_status := FND_API.g_ret_sts_error;
2237: RETURN;
2238: END IF;
2239: END IF;

Line 2246: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;

2242: IF p_schedule_rec.task_id <> FND_API.g_miss_num AND
2243: p_schedule_rec.task_id IS NOT NULL THEN
2244: l_table_name := 'jtf_tasks_b';
2245: l_pk_name := 'task_id' ;
2246: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2247: l_pk_value := p_schedule_rec.task_id ;
2248: l_additional_where_clause := null ;
2249:
2250: IF AMS_Utility_PVT.check_fk_exists(

Line 2250: IF AMS_Utility_PVT.check_fk_exists(

2246: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2247: l_pk_value := p_schedule_rec.task_id ;
2248: l_additional_where_clause := null ;
2249:
2250: IF AMS_Utility_PVT.check_fk_exists(
2251: p_table_name => l_table_name,
2252: p_pk_name => l_pk_name,
2253: p_pk_value => l_pk_value,
2254: p_pk_data_type => l_pk_data_type,

Line 2258: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_TASK') ;

2254: p_pk_data_type => l_pk_data_type,
2255: p_additional_where_clause => l_additional_where_clause
2256: ) = FND_API.g_false
2257: THEN
2258: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_TASK') ;
2259: x_return_status := FND_API.g_ret_sts_error;
2260: RETURN;
2261: END IF;
2262: END IF;

Line 2290: IF AMS_Utility_PVT.Check_Lookup_Exists

2286:
2287: -- Check status code
2288: IF p_schedule_rec.status_code <> FND_API.G_MISS_CHAR
2289: THEN
2290: IF AMS_Utility_PVT.Check_Lookup_Exists
2291: ( p_lookup_table_name => 'AMS_LOOKUPS'
2292: ,p_lookup_type => 'AMS_CAMPAIGN_SCHEDULE_STATUS'
2293: ,p_lookup_code => p_schedule_rec.status_code ) = FND_API.G_FALSE
2294: THEN

Line 2295: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_STATUS') ;

2291: ( p_lookup_table_name => 'AMS_LOOKUPS'
2292: ,p_lookup_type => 'AMS_CAMPAIGN_SCHEDULE_STATUS'
2293: ,p_lookup_code => p_schedule_rec.status_code ) = FND_API.G_FALSE
2294: THEN
2295: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_STATUS') ;
2296: x_return_status := FND_API.g_ret_sts_error;
2297: RETURN;
2298:
2299: END IF;

Line 2305: IF AMS_Utility_PVT.Check_Lookup_Exists

2301:
2302: -- Check Activity type code
2303: IF p_schedule_rec.activity_type_code <> FND_API.G_MISS_CHAR
2304: THEN
2305: IF AMS_Utility_PVT.Check_Lookup_Exists
2306: ( p_lookup_table_name => 'AMS_LOOKUPS'
2307: ,p_lookup_type => 'AMS_MEDIA_TYPE'
2308: ,p_lookup_code => p_schedule_rec.activity_type_code ) = FND_API.G_FALSE
2309: THEN

Line 2310: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_ACTIVITY_TYPE') ;

2306: ( p_lookup_table_name => 'AMS_LOOKUPS'
2307: ,p_lookup_type => 'AMS_MEDIA_TYPE'
2308: ,p_lookup_code => p_schedule_rec.activity_type_code ) = FND_API.G_FALSE
2309: THEN
2310: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_ACTIVITY_TYPE') ;
2311: x_return_status := FND_API.g_ret_sts_error;
2312: RETURN;
2313: END IF;
2314: END IF;

Line 2319: IF AMS_Utility_PVT.Check_Lookup_Exists

2315:
2316: -- Check Objective
2317: IF p_schedule_rec.objective_code <> FND_API.G_MISS_CHAR
2318: THEN
2319: IF AMS_Utility_PVT.Check_Lookup_Exists
2320: ( p_lookup_table_name => 'AMS_LOOKUPS'
2321: ,p_lookup_type => 'AMS_SCHEDULE_OBJECTIVE'
2322: ,p_lookup_code => p_schedule_rec.objective_code ) = FND_API.G_FALSE
2323: THEN

Line 2324: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_OBJECTIVE') ;

2320: ( p_lookup_table_name => 'AMS_LOOKUPS'
2321: ,p_lookup_type => 'AMS_SCHEDULE_OBJECTIVE'
2322: ,p_lookup_code => p_schedule_rec.objective_code ) = FND_API.G_FALSE
2323: THEN
2324: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_OBJECTIVE') ;
2325: x_return_status := FND_API.g_ret_sts_error;
2326: RETURN;
2327: END IF;
2328: END IF;

Line 2333: IF AMS_Utility_PVT.Check_Lookup_Exists

2329:
2330: -- Check Priority
2331: IF p_schedule_rec.priority <> FND_API.G_MISS_CHAR
2332: THEN
2333: IF AMS_Utility_PVT.Check_Lookup_Exists
2334: ( p_lookup_table_name => 'AMS_LOOKUPS'
2335: ,p_lookup_type => 'AMS_PRIORITY'
2336: ,p_lookup_code => p_schedule_rec.priority ) = FND_API.G_FALSE
2337: THEN

Line 2338: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_PRIORITY') ;

2334: ( p_lookup_table_name => 'AMS_LOOKUPS'
2335: ,p_lookup_type => 'AMS_PRIORITY'
2336: ,p_lookup_code => p_schedule_rec.priority ) = FND_API.G_FALSE
2337: THEN
2338: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_PRIORITY') ;
2339: x_return_status := FND_API.g_ret_sts_error;
2340: RETURN;
2341: END IF;
2342: END IF;

Line 2370: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.use_parent_code_flag) = FND_API.g_false

2366: -- Check Use parent code flag
2367: IF p_schedule_rec.use_parent_code_flag <> FND_API.g_miss_char
2368: AND p_schedule_rec.use_parent_code_flag IS NOT NULL
2369: THEN
2370: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.use_parent_code_flag) = FND_API.g_false
2371: THEN
2372: AMS_Utility_PVT.Error_Message('AMS_CAMP_BAD_PARENT_FLAG');
2373: x_return_status := FND_API.g_ret_sts_error;
2374: RETURN;

Line 2372: AMS_Utility_PVT.Error_Message('AMS_CAMP_BAD_PARENT_FLAG');

2368: AND p_schedule_rec.use_parent_code_flag IS NOT NULL
2369: THEN
2370: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.use_parent_code_flag) = FND_API.g_false
2371: THEN
2372: AMS_Utility_PVT.Error_Message('AMS_CAMP_BAD_PARENT_FLAG');
2373: x_return_status := FND_API.g_ret_sts_error;
2374: RETURN;
2375: END IF;
2376: END IF;

Line 2382: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.triggerable_flag) = FND_API.g_false

2378: -- Check Use parent code flag
2379: IF p_schedule_rec.triggerable_flag <> FND_API.g_miss_char
2380: AND p_schedule_rec.triggerable_flag IS NOT NULL
2381: THEN
2382: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.triggerable_flag) = FND_API.g_false
2383: THEN
2384: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_TRIG_FLAG');
2385: x_return_status := FND_API.g_ret_sts_error;
2386: RETURN;

Line 2384: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_TRIG_FLAG');

2380: AND p_schedule_rec.triggerable_flag IS NOT NULL
2381: THEN
2382: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.triggerable_flag) = FND_API.g_false
2383: THEN
2384: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_TRIG_FLAG');
2385: x_return_status := FND_API.g_ret_sts_error;
2386: RETURN;
2387: END IF;
2388: END IF;

Line 2394: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.active_flag) = FND_API.g_false

2390: -- Check Active flag
2391: IF p_schedule_rec.active_flag <> FND_API.g_miss_char
2392: AND p_schedule_rec.active_flag IS NOT NULL
2393: THEN
2394: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.active_flag) = FND_API.g_false
2395: THEN
2396: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_ACTIVE_FLAG');
2397: x_return_status := FND_API.g_ret_sts_error;
2398: RETURN;

Line 2396: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_ACTIVE_FLAG');

2392: AND p_schedule_rec.active_flag IS NOT NULL
2393: THEN
2394: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.active_flag) = FND_API.g_false
2395: THEN
2396: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_ACTIVE_FLAG');
2397: x_return_status := FND_API.g_ret_sts_error;
2398: RETURN;
2399: END IF;
2400: END IF;

Line 2406: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.accounts_closed_flag) = FND_API.g_false

2402: -- Check accounts_closed_flag
2403: IF p_schedule_rec.accounts_closed_flag <> FND_API.g_miss_char
2404: AND p_schedule_rec.accounts_closed_flag IS NOT NULL
2405: THEN
2406: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.accounts_closed_flag) = FND_API.g_false
2407: THEN
2408: AMS_Utility_PVT.Error_Message('AMS_CSCH_ACC_CLOSED_FLAG');
2409: x_return_status := FND_API.g_ret_sts_error;
2410: RETURN;

Line 2408: AMS_Utility_PVT.Error_Message('AMS_CSCH_ACC_CLOSED_FLAG');

2404: AND p_schedule_rec.accounts_closed_flag IS NOT NULL
2405: THEN
2406: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.accounts_closed_flag) = FND_API.g_false
2407: THEN
2408: AMS_Utility_PVT.Error_Message('AMS_CSCH_ACC_CLOSED_FLAG');
2409: x_return_status := FND_API.g_ret_sts_error;
2410: RETURN;
2411: END IF;
2412: END IF;

Line 2516: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');

2512: OPEN c_schedule;
2513: FETCH c_schedule INTO l_schedule_rec;
2514: IF c_schedule%NOTFOUND THEN
2515: CLOSE c_schedule;
2516: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
2517: RAISE FND_API.g_exc_error;
2518: END IF;
2519: CLOSE c_schedule;
2520:

Line 2530: x_complete_rec.status_code := AMS_Utility_PVT.get_system_status_code(

2526: x_complete_rec.user_status_id := l_schedule_rec.user_status_id;
2527: END IF;
2528:
2529: -- status_code will go with user_status_id
2530: x_complete_rec.status_code := AMS_Utility_PVT.get_system_status_code(
2531: x_complete_rec.user_status_id
2532: );
2533:
2534: IF p_schedule_rec.status_date = FND_API.g_miss_date

Line 2955: AMS_Utility_PVT.debug_message('After Item validation');

2951:
2952: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
2953: IF (AMS_DEBUG_HIGH_ON) THEN
2954:
2955: AMS_Utility_PVT.debug_message('After Item validation');
2956: END IF;
2957: Complete_schedule_Rec(
2958: p_schedule_rec => p_schedule_rec,
2959: x_complete_rec => l_schedule_rec

Line 2967: AMS_Utility_PVT.debug_message('Rec Level Validation');

2963: IF (AMS_DEBUG_HIGH_ON) THEN
2964:
2965:
2966:
2967: AMS_Utility_PVT.debug_message('Rec Level Validation');
2968:
2969: END IF;
2970: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
2971: Validate_schedule_Rec(

Line 2990: AMS_Utility_PVT.debug_message('Inter Entity Level Validation');

2986: IF (AMS_DEBUG_HIGH_ON) THEN
2987:
2988:
2989:
2990: AMS_Utility_PVT.debug_message('Inter Entity Level Validation');
2991:
2992: END IF;
2993: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
2994: Check_Schedule_Inter_Entity(

Line 3010: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

3006:
3007: -- Debug Message
3008: IF (AMS_DEBUG_HIGH_ON) THEN
3009:
3010: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3011: END IF;
3012:
3013: -- Initialize API return status to SUCCESS
3014: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3019: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

3015:
3016: -- Debug Message
3017: IF (AMS_DEBUG_HIGH_ON) THEN
3018:
3019: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3020: END IF;
3021:
3022: -- Standard call to get message count and if count is 1, get message info.
3023: FND_MSG_PUB.Count_And_Get

Line 3029: WHEN AMS_Utility_PVT.resource_locked THEN

3025: p_data => x_msg_data
3026: );
3027: EXCEPTION
3028:
3029: WHEN AMS_Utility_PVT.resource_locked THEN
3030: x_return_status := FND_API.g_ret_sts_error;
3031: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
3032:
3033: WHEN FND_API.G_EXC_ERROR THEN

Line 3031: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');

3027: EXCEPTION
3028:
3029: WHEN AMS_Utility_PVT.resource_locked THEN
3030: x_return_status := FND_API.g_ret_sts_error;
3031: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
3032:
3033: WHEN FND_API.G_EXC_ERROR THEN
3034: ROLLBACK TO VALIDATE_Camp_Schedule_;
3035: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3109: AMS_UTILITY_PVT.debug_message('Private API: Validate_Schedule_Rec');

3105:
3106: -- Debug Message
3107: IF (AMS_DEBUG_HIGH_ON) THEN
3108:
3109: AMS_UTILITY_PVT.debug_message('Private API: Validate_Schedule_Rec');
3110: END IF;
3111:
3112: -- budget amount must come with budget currency
3113: IF p_schedule_rec.transaction_currency_code IS NULL

Line 3116: AMS_Utility_PVT.Error_Message('AMS_CAMP_BUDGET_NO_CURRENCY');

3112: -- budget amount must come with budget currency
3113: IF p_schedule_rec.transaction_currency_code IS NULL
3114: AND p_schedule_rec.budget_amount_tc IS NOT NULL
3115: THEN
3116: AMS_Utility_PVT.Error_Message('AMS_CAMP_BUDGET_NO_CURRENCY');
3117: x_return_status := FND_API.g_ret_sts_error;
3118: END IF;
3119:
3120: IF p_schedule_rec.end_date_time IS NOT NULL THEN

Line 3122: AMS_Utility_PVT.Error_Message('AMS_CAMP_START_AFTER_END');

3118: END IF;
3119:
3120: IF p_schedule_rec.end_date_time IS NOT NULL THEN
3121: IF p_schedule_rec.start_date_time > p_schedule_rec.end_date_time THEN
3122: AMS_Utility_PVT.Error_Message('AMS_CAMP_START_AFTER_END');
3123: x_return_status := FND_API.g_ret_sts_error;
3124: END IF ;
3125: END IF ;
3126:

Line 3131: AMS_Utility_PVT.Error_Message('AMS_CSCH_END_DATE_MAND');

3127: -- added by soagrawa on 03-dec-2001 : end date mandatory for schedules of type events
3128: -- bug# 2131521
3129: IF p_schedule_rec.activity_type_code = 'EVENTS' THEN
3130: IF p_schedule_rec.end_date_time IS NULL THEN
3131: AMS_Utility_PVT.Error_Message('AMS_CSCH_END_DATE_MAND');
3132: x_return_status := FND_API.G_RET_STS_ERROR;
3133: RETURN;
3134: END IF;
3135: END IF ;

Line 3142: AMS_Utility_PVT.Error_Message('AMS_SELECT_TRIGGER');

3138: --added by anchaudh on 27-jun-2003 : triggers related validations
3139: -- following validations modified by soagrawa on 22-nov-2003 for 11.5.10 repeating schedules' addition
3140:
3141: IF (p_schedule_rec.triggerable_flag = 'Y' AND p_schedule_rec.trigger_id IS NULL) THEN
3142: AMS_Utility_PVT.Error_Message('AMS_SELECT_TRIGGER');
3143: x_return_status := FND_API.G_RET_STS_ERROR;
3144: RETURN;
3145: END IF;
3146:

Line 3148: AMS_Utility_PVT.Error_Message('AMS_DONOT_TRIG_TGRP');

3144: RETURN;
3145: END IF;
3146:
3147: /* IF (p_schedule_rec.triggerable_flag = 'N' AND p_schedule_rec.tgrp_exclude_prev_flag = 'Y') THEN
3148: AMS_Utility_PVT.Error_Message('AMS_DONOT_TRIG_TGRP');
3149: x_return_status := FND_API.G_RET_STS_ERROR;
3150: RETURN;
3151: END IF;
3152: */

Line 3157: AMS_Utility_PVT.Error_Message('AMS_TRIG_EXCLUDE_TGRP');

3153:
3154: -- soagrawa added clause p_schedule_rec.triggerable_flag = 'Y'
3155: -- on 23-mar-2004
3156: IF (p_schedule_rec.trig_repeat_flag = 'N' AND p_schedule_rec.triggerable_flag = 'Y' AND p_schedule_rec.tgrp_exclude_prev_flag = 'Y') THEN
3157: AMS_Utility_PVT.Error_Message('AMS_TRIG_EXCLUDE_TGRP');
3158: x_return_status := FND_API.G_RET_STS_ERROR;
3159: RETURN;
3160: END IF;
3161:

Line 3164: AMS_Utility_PVT.Error_Message('AMS_DONOT_TRIG_REPEAT');

3160: END IF;
3161:
3162: /*
3163: IF (p_schedule_rec.triggerable_flag = 'N' AND p_schedule_rec.trig_repeat_flag = 'Y') THEN
3164: AMS_Utility_PVT.Error_Message('AMS_DONOT_TRIG_REPEAT');
3165: x_return_status := FND_API.G_RET_STS_ERROR;
3166: RETURN;
3167: END IF;
3168: */

Line 3196: -- 2.Replaced ams_utility_pvt.check_uniqueness check

3192: -- 22-Jan-2001 PTENDULK Created
3193: -- 24-May-2001 ptendulk Added check to validate that event schedule is
3194: -- can not be created for event promotions.
3195: -- 01-Aug-2001 ptendulk 1.Added two more cursors for duplicate check
3196: -- 2.Replaced ams_utility_pvt.check_uniqueness check
3197: -- with manual check. Refer bug #1913448
3198: --===================================================================
3199: PROCEDURE Check_Schedule_Inter_Entity( p_schedule_rec IN schedule_rec_type,
3200: p_complete_rec IN schedule_rec_type,

Line 3281: AMS_Utility_PVT.Error_Message('AMS_CSCH_INVALID_CAMP_STAT');

3277: OR l_status_code = 'CANCELLED'
3278: OR l_status_code = 'COMPLETED'
3279: OR l_status_code = 'ON_HOLD'
3280: THEN
3281: AMS_Utility_PVT.Error_Message('AMS_CSCH_INVALID_CAMP_STAT');
3282: x_return_status := FND_API.G_RET_STS_ERROR;
3283: RETURN;
3284: END IF ;
3285:

Line 3289: AMS_Utility_PVT.Error_Message('AMS_CSCH_INVALID_EVENT_SCH');

3285:
3286: -- Following validation is added by ptendulk on 24-May-2001 to
3287: -- ensure that event type schedules can not be created for event type campaigns.
3288: IF l_rollup_type = 'EVCAM' AND p_complete_rec.activity_type_code = 'EVENTS' THEN
3289: AMS_Utility_PVT.Error_Message('AMS_CSCH_INVALID_EVENT_SCH');
3290: x_return_status := FND_API.G_RET_STS_ERROR;
3291: RETURN;
3292: END IF ;
3293:

Line 3306: AMS_Utility_PVT.Get_Qual_Table_Name_And_PK (

3302: IF (p_schedule_rec.related_event_id IS NOT NULL AND p_schedule_rec.related_event_id <> FND_API.g_miss_num)
3303: OR (p_schedule_rec.related_event_from IS NOT NULL AND p_schedule_rec.related_event_from <> FND_API.g_miss_char)
3304: THEN
3305: -- Get table_name and pk_name for the ARC qualifier.
3306: AMS_Utility_PVT.Get_Qual_Table_Name_And_PK (
3307: p_sys_qual => p_complete_rec.related_event_from,
3308: x_return_status => x_return_status,
3309: x_table_name => l_table_name,
3310: x_pk_name => l_pk_name

Line 3314: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;

3310: x_pk_name => l_pk_name
3311: );
3312:
3313: l_pk_value := p_complete_rec.related_event_id ;
3314: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
3315: l_where_clause := NULL;
3316:
3317: IF AMS_Utility_PVT.Check_FK_Exists (
3318: p_table_name => l_table_name

Line 3317: IF AMS_Utility_PVT.Check_FK_Exists (

3313: l_pk_value := p_complete_rec.related_event_id ;
3314: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
3315: l_where_clause := NULL;
3316:
3317: IF AMS_Utility_PVT.Check_FK_Exists (
3318: p_table_name => l_table_name
3319: ,p_pk_name => l_pk_name
3320: ,p_pk_value => l_pk_value
3321: ,p_pk_data_type => l_pk_data_type

Line 3325: AMS_UTILITY_PVT.Error_Message('AMS_CAMP_INVALID_EVENT');

3321: ,p_pk_data_type => l_pk_data_type
3322: ,p_additional_where_clause => l_where_clause
3323: ) = FND_API.G_FALSE
3324: THEN
3325: AMS_UTILITY_PVT.Error_Message('AMS_CAMP_INVALID_EVENT');
3326: x_return_status := FND_API.G_RET_STS_ERROR;
3327: RETURN;
3328: END IF;
3329: END IF ;*/

Line 3393: --l_valid_flag := AMS_Utility_PVT.check_uniqueness( p_table_name => l_table_name,

3389: --IF p_validation_mode = JTF_PLSQL_API.g_update THEN
3390: -- l_where_clause := l_where_clause || ' AND schedule_id <> '||p_complete_rec.schedule_id ;
3391: --END IF ;
3392:
3393: --l_valid_flag := AMS_Utility_PVT.check_uniqueness( p_table_name => l_table_name,
3394: -- p_where_clause => l_where_clause) ;
3395: --IF l_valid_flag = FND_API.g_false THEN
3396: -- AMS_Utility_PVT.Error_Message('AMS_CSCH_DUPLICATE_ID');
3397: -- x_return_status := FND_API.g_ret_sts_error;

Line 3396: -- AMS_Utility_PVT.Error_Message('AMS_CSCH_DUPLICATE_ID');

3392:
3393: --l_valid_flag := AMS_Utility_PVT.check_uniqueness( p_table_name => l_table_name,
3394: -- p_where_clause => l_where_clause) ;
3395: --IF l_valid_flag = FND_API.g_false THEN
3396: -- AMS_Utility_PVT.Error_Message('AMS_CSCH_DUPLICATE_ID');
3397: -- x_return_status := FND_API.g_ret_sts_error;
3398: -- RETURN;
3399: --END IF;
3400: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

Line 3412: AMS_Utility_PVT.Error_Message('AMS_CSCH_DUPLICATE_ID');

3408: END IF ;
3409:
3410: IF l_dummy IS NOT NULL THEN
3411: -- Duplicate Schedule
3412: AMS_Utility_PVT.Error_Message('AMS_CSCH_DUPLICATE_ID');
3413: x_return_status := FND_API.g_ret_sts_error;
3414: RETURN;
3415: END IF ;
3416:

Line 3440: AMS_Utility_PVT.Error_Message('AMS_CSCH_BAD_PARENT_CODE_FLAG');

3436: -- check parent source flag
3437: IF p_schedule_rec.activity_type_code = 'EVENTS' AND
3438: p_schedule_rec.use_parent_code_flag = 'Y'
3439: THEN
3440: AMS_Utility_PVT.Error_Message('AMS_CSCH_BAD_PARENT_CODE_FLAG');
3441: x_return_status := FND_API.g_ret_sts_error;
3442: END IF;
3443:
3444: END Check_Schedule_Inter_Entity;

Line 3807: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

3803:
3804: -- Debug Message
3805: IF (AMS_DEBUG_HIGH_ON) THEN
3806:
3807: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3808: END IF;
3809:
3810:
3811: -- Initialize API return status to SUCCESS

Line 3963: -- l_schedule_rec.user_status_id := AMS_Utility_PVT.get_default_user_status() ;-- NEW l_reference_rec.user_status_id

3959: -- Mandatory fields for CSCH are Start Date and End Date
3960: -- ------------------------------
3961:
3962: l_schedule_rec.timezone_id := l_reference_rec.timezone_id;
3963: -- l_schedule_rec.user_status_id := AMS_Utility_PVT.get_default_user_status() ;-- NEW l_reference_rec.user_status_id
3964: l_schedule_rec.user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_SCHEDULE_STATUS','NEW') ;
3965: l_schedule_rec.status_code := 'NEW';
3966:
3967:

Line 3964: l_schedule_rec.user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_SCHEDULE_STATUS','NEW') ;

3960: -- ------------------------------
3961:
3962: l_schedule_rec.timezone_id := l_reference_rec.timezone_id;
3963: -- l_schedule_rec.user_status_id := AMS_Utility_PVT.get_default_user_status() ;-- NEW l_reference_rec.user_status_id
3964: l_schedule_rec.user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_SCHEDULE_STATUS','NEW') ;
3965: l_schedule_rec.status_code := 'NEW';
3966:
3967:
3968: -- -------------------------------------------

Line 4106: AMS_UTILITY_PVT.Debug_Message('change use parent flag to N for Event type schedule

4102: -- #Fix for bug 2989203 by asaha
4103: IF(l_schedule_rec.activity_type_code = 'EVENTS' AND
4104: l_schedule_rec.use_parent_code_flag = 'Y') THEN
4105: IF(AMS_DEBUG_HIGH_ON) THEN
4106: AMS_UTILITY_PVT.Debug_Message('change use parent flag to N for Event type schedule
4107: ');
4108: END IF;
4109: l_schedule_rec.use_parent_code_flag := 'N';
4110: END IF;

Line 4117: AMS_UTILITY_PVT.debug_message('before copying event '||l_schedule_rec.activity_type_code);

4113:
4114:
4115: -- AMS_CpyUtility_PVT.get_column_value ('', p_copy_columns_table, l_schedule_rec.);
4116:
4117: AMS_UTILITY_PVT.debug_message('before copying event '||l_schedule_rec.activity_type_code);
4118: AMS_UTILITY_PVT.debug_message('before copying event '||l_reference_rec.related_event_id);
4119:
4120: -- added by soagrawa on 11-jan-2002
4121: -- copy event details into a new EONE and update new schedule with that new id

Line 4118: AMS_UTILITY_PVT.debug_message('before copying event '||l_reference_rec.related_event_id);

4114:
4115: -- AMS_CpyUtility_PVT.get_column_value ('', p_copy_columns_table, l_schedule_rec.);
4116:
4117: AMS_UTILITY_PVT.debug_message('before copying event '||l_schedule_rec.activity_type_code);
4118: AMS_UTILITY_PVT.debug_message('before copying event '||l_reference_rec.related_event_id);
4119:
4120: -- added by soagrawa on 11-jan-2002
4121: -- copy event details into a new EONE and update new schedule with that new id
4122: IF l_schedule_rec.activity_type_code = 'EVENTS'

Line 4197: AMS_UTILITY_PVT.debug_message('before req_items>'||l_event_offer_rec.event_delivery_method_id||'<');

4193: l_event_offer_rec.FUND_AMOUNT_TC := NULL;
4194:
4195: IF (AMS_DEBUG_HIGH_ON) THEN
4196:
4197: AMS_UTILITY_PVT.debug_message('before req_items>'||l_event_offer_rec.event_delivery_method_id||'<');
4198:
4199: END IF;
4200: IF (AMS_DEBUG_HIGH_ON) THEN
4201:

Line 4202: AMS_UTILITY_PVT.debug_message('before req_items>'||l_reference_event_rec.event_delivery_method_id||'<');

4198:
4199: END IF;
4200: IF (AMS_DEBUG_HIGH_ON) THEN
4201:
4202: AMS_UTILITY_PVT.debug_message('before req_items>'||l_reference_event_rec.event_delivery_method_id||'<');
4203: END IF;
4204:
4205: AMS_UTILITY_PVT.debug_message('before calling create event offer');
4206:

Line 4205: AMS_UTILITY_PVT.debug_message('before calling create event offer');

4201:
4202: AMS_UTILITY_PVT.debug_message('before req_items>'||l_reference_event_rec.event_delivery_method_id||'<');
4203: END IF;
4204:
4205: AMS_UTILITY_PVT.debug_message('before calling create event offer');
4206:
4207: -- created the event EONE
4208: -- dhsingh, 28.07.2004, Bug# 3798545.
4209: /*

Line 4236: AMS_UTILITY_PVT.debug_message('after calling create event offer '||l_new_event_offer_id);

4232: );
4233:
4234: -- END dhsingh
4235:
4236: AMS_UTILITY_PVT.debug_message('after calling create event offer '||l_new_event_offer_id);
4237:
4238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4239: RAISE FND_API.G_EXC_ERROR;
4240: END IF;

Line 4378: AMS_UTILITY_PVT.debug_message('Copy Attributes, usage is LITE and COLT component is selected' );

4374: THEN
4375: l_attr_list.p_COLT := 'Y';
4376: -- Debug Message
4377: IF (AMS_DEBUG_HIGH_ON) THEN
4378: AMS_UTILITY_PVT.debug_message('Copy Attributes, usage is LITE and COLT component is selected' );
4379: END IF;
4380: ELSE
4381: -- Debug Message
4382: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4383: AMS_UTILITY_PVT.debug_message('Copy Attributes, usage is LITE but COLT component is not selected' );

4379: END IF;
4380: ELSE
4381: -- Debug Message
4382: IF (AMS_DEBUG_HIGH_ON) THEN
4383: AMS_UTILITY_PVT.debug_message('Copy Attributes, usage is LITE but COLT component is not selected' );
4384: END IF;
4385: END IF;
4386: ELSE
4387: l_attr_list.p_COLT := 'Y';

Line 4390: AMS_UTILITY_PVT.debug_message('Copy Attributes, usage is PHAT thus setting copy COLT to true' );

4386: ELSE
4387: l_attr_list.p_COLT := 'Y';
4388: -- Debug Message
4389: IF (AMS_DEBUG_HIGH_ON) THEN
4390: AMS_UTILITY_PVT.debug_message('Copy Attributes, usage is PHAT thus setting copy COLT to true' );
4391: END IF;
4392: END IF;
4393:
4394: IF AMS_CpyUtility_PVT.is_copy_attribute ('COLT', p_attributes_table) = FND_API.G_TRUE

Line 4443: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

4439:
4440: -- Debug Message
4441: IF (AMS_DEBUG_HIGH_ON) THEN
4442:
4443: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
4444: END IF;
4445:
4446: -- Standard call to get message count and if count is 1, get message info.
4447: FND_MSG_PUB.Count_And_Get