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

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

289:
290: -- Debug Message
291: IF (AMS_DEBUG_HIGH_ON) THEN
292:
293: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
294: END IF;
295:
296: -- Writing to PL/SQL table
297: --WRITE_TO_ACT_LOG('start new copy function','CAMP',1111);

Line 393: l_camp_rec.user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_STATUS','NEW');

389: l_camp_rec.city_id := TO_NUMBER(FND_PROFILE.value('AMS_SRCGEN_USER_CITY'));
390: -- Following line is commented out by rrajesh on 10/05/01.
391: -- getting owner from UI.
392: --l_camp_rec.owner_user_id := l_reference_rec.owner_user_id;
393: l_camp_rec.user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_STATUS','NEW');
394: l_camp_rec.status_code := 'NEW';
395: l_camp_rec.status_date := SYSDATE;
396:
397: -- l_date number is the difference between start date of source

Line 549: AMS_UTILITY_PVT.debug_message('Getting scheduleid values');

545:
546: -- Get the Schedule Ids as comma separated variables.
547: IF (AMS_DEBUG_HIGH_ON) THEN
548:
549: AMS_UTILITY_PVT.debug_message('Getting scheduleid values');
550: END IF;
551: AMS_CpyUtility_PVT.get_column_value ('scheduleIdRec', p_copy_columns_table, x_schedule_ids);
552: l_schedule_ids := NVL (x_schedule_ids, '');
553:

Line 558: AMS_UTILITY_PVT.debug_message('scheduleId Rec:' || l_schedule_ids ||';');

554: IF (AMS_DEBUG_HIGH_ON) THEN
555:
556:
557:
558: AMS_UTILITY_PVT.debug_message('scheduleId Rec:' || l_schedule_ids ||';');
559:
560: END IF;
561:
562: -- added by soagrawa on 19-aug-2002

Line 571: AMS_UTILITY_PVT.debug_message('scheduleId Rec:' || l_schedule_ids ||';');

567: IF (AMS_DEBUG_HIGH_ON) THEN
568:
569:
570:
571: AMS_UTILITY_PVT.debug_message('scheduleId Rec:' || l_schedule_ids ||';');
572:
573: END IF;
574:
575: --WRITE_TO_ACT_LOG('Schedule Id Rec:'|| l_schedule_ids ,'CAMP',1111);

Line 602: AMS_UTILITY_PVT.debug_message('calling schedule copy for schedule id:' || l_tmp_schedule_id);

598: THEN
599: --WRITE_TO_ACT_LOG('calling schedule copy for schedule id:' || l_tmp_schedule_id ,'CAMP',1111);
600: IF (AMS_DEBUG_HIGH_ON) THEN
601:
602: AMS_UTILITY_PVT.debug_message('calling schedule copy for schedule id:' || l_tmp_schedule_id);
603: END IF;
604: ams_copyelements_pvt.copy_selected_schedule
605: ( p_old_camp_id => p_source_object_id,
606: p_new_camp_id => l_new_campaign_id,

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

754:
755: -- Debug Message
756: IF (AMS_DEBUG_HIGH_ON) THEN
757:
758: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
759: END IF;
760:
761: -- Standard call to get message count and if count is 1, get message info.
762: FND_MSG_PUB.Count_And_Get

Line 844: ams_utility_pvt.debug_message(l_full_name || ': start');

840: BEGIN
841: SAVEPOINT copy_deliverables;
842: IF (AMS_DEBUG_HIGH_ON) THEN
843:
844: ams_utility_pvt.debug_message(l_full_name || ': start');
845: END IF;
846:
847: IF fnd_api.to_boolean(p_init_msg_list)
848: THEN

Line 865: ams_utility_pvt.debug_message(l_full_name || ': copy');

861: x_return_status := fnd_api.g_ret_sts_success;
862: ----------------------- insert -----------------------
863: IF (AMS_DEBUG_HIGH_ON) THEN
864:
865: ams_utility_pvt.debug_message(l_full_name || ': copy');
866: END IF;
867:
868: BEGIN
869: ams_utility_pvt.get_lookup_meaning(

Line 869: ams_utility_pvt.get_lookup_meaning(

865: ams_utility_pvt.debug_message(l_full_name || ': copy');
866: END IF;
867:
868: BEGIN
869: ams_utility_pvt.get_lookup_meaning(
870: 'AMS_SYS_ARC_QUALIFIER',
871: 'DELV',
872: l_return_status,
873: l_lookup_meaning);

Line 1000: ams_utility_pvt.get_object_name( 'DELV',

996: fnd_message.set_name('AMS', 'AMS_COPY_ERROR2');
997: fnd_message.set_token('ELEMENTS', l_lookup_meaning, TRUE);
998: l_mesg_text := fnd_message.get;
999: p_errmsg := SUBSTR( l_mesg_text || ' - ' ||
1000: ams_utility_pvt.get_object_name( 'DELV',
1001: l_deli_rec.deliverable_id),
1002: 1, 4000);
1003: ams_cpyutility_pvt.write_log_mesg('DELV',
1004: p_src_deliv_id, p_errmsg, 'ERROR');

Line 1111: ams_utility_pvt.debug_message(l_full_name || ': end');

1107: IF (AMS_DEBUG_HIGH_ON) THEN
1108:
1109:
1110:
1111: ams_utility_pvt.debug_message(l_full_name || ': end');
1112:
1113: END IF;
1114: EXCEPTION
1115: WHEN fnd_api.g_exc_error

Line 1217: ams_utility_pvt.debug_message(l_full_name || ': start');

1213: BEGIN
1214: SAVEPOINT copy_event_offer;
1215: IF (AMS_DEBUG_HIGH_ON) THEN
1216:
1217: ams_utility_pvt.debug_message(l_full_name || ': start');
1218: END IF;
1219:
1220: IF fnd_api.to_boolean(p_init_msg_list)
1221: THEN

Line 1238: ams_utility_pvt.debug_message(l_full_name || ': start');

1234: x_return_status := fnd_api.g_ret_sts_success;
1235: ----------------------- insert -----------------------
1236: IF (AMS_DEBUG_HIGH_ON) THEN
1237:
1238: ams_utility_pvt.debug_message(l_full_name || ': start');
1239: END IF;
1240:
1241: BEGIN
1242: ams_utility_pvt.get_lookup_meaning(

Line 1242: ams_utility_pvt.get_lookup_meaning(

1238: ams_utility_pvt.debug_message(l_full_name || ': start');
1239: END IF;
1240:
1241: BEGIN
1242: ams_utility_pvt.get_lookup_meaning(
1243: 'AMS_SYS_ARC_QUALIFIER',
1244: 'EVEO',
1245: l_return_status,
1246: l_lookup_meaning);

Line 1336: AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);

1332: l_eventoffer_rec.waitlist_action_type_code;
1333: l_eveo_rec.stream_type_code := l_eventoffer_rec.stream_type_code;
1334: -- l_eveo_rec.owner_user_id := l_eventoffer_rec.owner_user_id;
1335: l_eveo_rec.owner_user_id :=
1336: AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);
1337: -- changed again because eventsAPI has chaged--101;
1338:
1339: l_eveo_rec.event_full_flag := 'N';
1340: l_eveo_rec.source_code := p_source_code;

Line 1449: ams_utility_pvt.get_object_name('EVEO', p_src_eveo_id),

1445: fnd_message.set_name('AMS', 'AMS_COPY_ERROR2');
1446: fnd_message.set_token('ELEMENTS', l_lookup_meaning, TRUE);
1447: l_mesg_text := fnd_message.get;
1448: p_errmsg := SUBSTR( l_mesg_text || ' - ' ||
1449: ams_utility_pvt.get_object_name('EVEO', p_src_eveo_id),
1450: 1, 4000);
1451: ams_cpyutility_pvt.write_log_mesg('EVEO',
1452: p_src_eveo_id,
1453: p_errmsg,

Line 1631: ams_utility_pvt.debug_message(l_full_name || ': debug');

1627: ROLLBACK TO copy_event_offer;
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: IF (AMS_DEBUG_HIGH_ON) THEN
1630:
1631: ams_utility_pvt.debug_message(l_full_name || ': debug');
1632: END IF;
1633: fnd_msg_pub.count_and_get(
1634: p_encoded => fnd_api.g_false,
1635: p_count => x_msg_count,

Line 1725: ams_utility_pvt.debug_message(l_full_name || ': start');

1721: BEGIN
1722: SAVEPOINT copy_event_header;
1723: IF (AMS_DEBUG_HIGH_ON) THEN
1724:
1725: ams_utility_pvt.debug_message(l_full_name || ': start');
1726: END IF;
1727:
1728: IF fnd_api.to_boolean(p_init_msg_list)
1729: THEN

Line 1746: ams_utility_pvt.debug_message(l_full_name || ': start');

1742: x_return_status := fnd_api.g_ret_sts_success;
1743: ----------------------- insert -----------------------
1744: IF (AMS_DEBUG_HIGH_ON) THEN
1745:
1746: ams_utility_pvt.debug_message(l_full_name || ': start');
1747: END IF;
1748:
1749: BEGIN
1750: ams_utility_pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',

Line 1750: ams_utility_pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',

1746: ams_utility_pvt.debug_message(l_full_name || ': start');
1747: END IF;
1748:
1749: BEGIN
1750: ams_utility_pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',
1751: 'EVEH',
1752: l_return_status,
1753: l_lookup_meaning);
1754: -- General Message saying copying has started

Line 1826: l_eveh_rec.owner_user_id := AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);

1822: l_eventheader_rec.reg_minimum_capacity;
1823: l_eveh_rec.org_id := l_eventheader_rec.org_id;
1824: l_eveh_rec.stream_type_code := l_eventheader_rec.stream_type_code;
1825: -- l_eveh_rec.owner_user_id := l_eventheader_rec.owner_user_id;
1826: l_eveh_rec.owner_user_id := AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);
1827:
1828: l_eveh_rec.user_status_id := 1;
1829: l_eveh_rec.system_status_code := 'NEW';
1830: l_eveh_rec.cert_credit_type_code :=

Line 1916: ams_utility_pvt.get_object_name('EVEH',

1912: fnd_message.set_name('AMS', 'AMS_COPY_ERROR2');
1913: fnd_message.set_token('ELEMENTS', l_lookup_meaning, TRUE);
1914: l_mesg_text := fnd_message.get;
1915: p_errmsg := SUBSTR( l_mesg_text || ' - ' ||
1916: ams_utility_pvt.get_object_name('EVEH',
1917: p_src_eveh_id), 1, 4000);
1918: ams_cpyutility_pvt.write_log_mesg('EVEH',
1919: p_src_eveh_id,
1920: p_errmsg,

Line 2118: ams_utility_pvt.debug_message(l_full_name || ': debug');

2114: ROLLBACK TO copy_event_header;
2115: x_return_status := fnd_api.g_ret_sts_unexp_error;
2116: IF (AMS_DEBUG_HIGH_ON) THEN
2117:
2118: ams_utility_pvt.debug_message(l_full_name || ': debug');
2119: END IF;
2120: fnd_msg_pub.count_and_get(
2121: p_encoded => fnd_api.g_false,
2122: p_count => x_msg_count,

Line 2240: ams_utility_pvt.debug_message(l_full_name || ' :Start ');

2236: END IF;
2237: -- Lookup Meaning from ams_lookup for CAMP
2238: IF (AMS_DEBUG_HIGH_ON) THEN
2239:
2240: ams_utility_pvt.debug_message(l_full_name || ' :Start ');
2241: END IF;
2242: ams_utility_pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',
2243: 'CAMP',
2244: l_return_status,

Line 2242: ams_utility_pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',

2238: IF (AMS_DEBUG_HIGH_ON) THEN
2239:
2240: ams_utility_pvt.debug_message(l_full_name || ' :Start ');
2241: END IF;
2242: ams_utility_pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',
2243: 'CAMP',
2244: l_return_status,
2245: l_lookup_meaning);
2246: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2270: l_owner_user_id := ams_utility_pvt.get_resource_id(FND_GLOBAL.USER_ID);

2266: close cur_get_campaign;
2267:
2268: -- Call get_resource_id to get the resource id from jtf tables
2269: -- Returns -1 if the setup of resource was not done properly
2270: l_owner_user_id := ams_utility_pvt.get_resource_id(FND_GLOBAL.USER_ID);
2271: IF l_owner_user_id = -1 THEN
2272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2273: END IF;
2274:

Line 2466: ams_utility_pvt.get_object_name('CAMP',p_src_camp_id),

2462: fnd_message.set_name('AMS', 'AMS_COPY_ERROR2');
2463: fnd_message.set_token('ELEMENTS', l_lookup_meaning, TRUE);
2464: l_mesg_text := fnd_message.get;
2465: l_errmsg :=substr(l_mesg_text || ' - ' ||
2466: ams_utility_pvt.get_object_name('CAMP',p_src_camp_id),
2467: 1, 4000);
2468: ams_cpyutility_pvt.write_log_mesg('CAMP',
2469: p_src_camp_id,
2470: l_errmsg ,

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

2757: IF (AMS_DEBUG_HIGH_ON) THEN
2758:
2759:
2760:
2761: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
2762:
2763: END IF;
2764:
2765: -- Initialize API return status to SUCCESS

Line 2906: AMS_Utility_PVT.debug_message (

2902: -- added by sodixit on 04-oct-2003 for 11.5.10
2903: -- Copy Target Group
2904: IF p_attr_list.p_TGRP = 'Y'
2905: THEN
2906: AMS_Utility_PVT.debug_message (
2907: FND_LOG.LEVEL_EVENT,
2908: 'ams.plsql.ams_copyactivities_pvt.copy_schedule_attributes',
2909: 'Calling ams_copyelements_pvt.copy_target_group');
2910: AMS_Utility_PVT.debug_message (

Line 2910: AMS_Utility_PVT.debug_message (

2906: AMS_Utility_PVT.debug_message (
2907: FND_LOG.LEVEL_EVENT,
2908: 'ams.plsql.ams_copyactivities_pvt.copy_schedule_attributes',
2909: 'Calling ams_copyelements_pvt.copy_target_group');
2910: AMS_Utility_PVT.debug_message (
2911: FND_LOG.LEVEL_EVENT,
2912: 'ams.plsql.ams_copyactivities_pvt.copy_schedule_attributes',
2913: 'p_src_object_id='||p_src_object_id);
2914: AMS_Utility_PVT.debug_message (

Line 2914: AMS_Utility_PVT.debug_message (

2910: AMS_Utility_PVT.debug_message (
2911: FND_LOG.LEVEL_EVENT,
2912: 'ams.plsql.ams_copyactivities_pvt.copy_schedule_attributes',
2913: 'p_src_object_id='||p_src_object_id);
2914: AMS_Utility_PVT.debug_message (
2915: FND_LOG.LEVEL_EVENT,
2916: 'ams.plsql.ams_copyactivities_pvt.copy_schedule_attributes',
2917: 'p_tar_object_id='||p_tar_object_id);
2918: ams_copyelements_pvt.copy_target_group(

Line 2931: AMS_Utility_PVT.debug_message (

2927: -- added by sodixit on 04-oct-2003 for 11.5.10
2928: -- Copy Collateral
2929: IF p_attr_list.p_COLT = 'Y'
2930: THEN
2931: AMS_Utility_PVT.debug_message (
2932: FND_LOG.LEVEL_EVENT,
2933: 'ams.plsql.ams_copyactivities_pvt.copy_schedule_attributes',
2934: 'Calling ams_copyelements_pvt.copy_act_collateral');
2935: AMS_Utility_PVT.debug_message (

Line 2935: AMS_Utility_PVT.debug_message (

2931: AMS_Utility_PVT.debug_message (
2932: FND_LOG.LEVEL_EVENT,
2933: 'ams.plsql.ams_copyactivities_pvt.copy_schedule_attributes',
2934: 'Calling ams_copyelements_pvt.copy_act_collateral');
2935: AMS_Utility_PVT.debug_message (
2936: FND_LOG.LEVEL_EVENT,
2937: 'ams.plsql.ams_copyactivities_pvt.copy_schedule_attributes',
2938: 'p_src_object_id='||p_src_object_id);
2939: AMS_Utility_PVT.debug_message (

Line 2939: AMS_Utility_PVT.debug_message (

2935: AMS_Utility_PVT.debug_message (
2936: FND_LOG.LEVEL_EVENT,
2937: 'ams.plsql.ams_copyactivities_pvt.copy_schedule_attributes',
2938: 'p_src_object_id='||p_src_object_id);
2939: AMS_Utility_PVT.debug_message (
2940: FND_LOG.LEVEL_EVENT,
2941: 'ams.plsql.ams_copyactivities_pvt.copy_schedule_attributes',
2942: 'p_tar_object_id='||p_tar_object_id);
2943: ams_copyelements_pvt.copy_act_collateral(

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

2996:
2997: -- Debug Message
2998: IF (AMS_DEBUG_HIGH_ON) THEN
2999:
3000: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
3001: END IF;
3002:
3003: -- Standard call to get message count and if count is 1, get message info.
3004: FND_MSG_PUB.Count_And_Get (

Line 3048: AMS_UTILITY_PVT.CREATE_LOG(

3044: IS
3045: PRAGMA AUTONOMOUS_TRANSACTION;
3046: l_return_status VARCHAR2(1);
3047: BEGIN
3048: AMS_UTILITY_PVT.CREATE_LOG(
3049: x_return_status => l_return_status,
3050: p_arc_log_used_by => 'CAMP',
3051: p_log_used_by_id => p_log_used_by_id,
3052: p_msg_data => p_msg_data);