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

Line 93: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',

89: AND arc_act_product_used_by = p_src_act_type;
90: BEGIN
91:
92:
93: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
94: 'PROD',
95: l_return_status,
96: l_lookup_meaning
97: );

Line 281: AMS_UTILITY_PVT.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER',

277: p_errcode := NULL;
278: p_errnum := 0;
279: p_errmsg := NULL;
280: -------have to add once sysarc qualifier is created----------------------
281: AMS_UTILITY_PVT.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER',
282: 'MESG',
283: l_return_status,
284: l_lookup_meaning);
285:

Line 478: ams_utility_pvt.get_lookup_meaning ( 'AMS_OBJECT_USAGE_TYPE',

474: := association_rec.using_object_type;
475: l_association_rec.using_object_id
476: := association_rec.using_object_id;
477: l_association_rec.primary_flag := association_rec.primary_flag;
478: ams_utility_pvt.get_lookup_meaning ( 'AMS_OBJECT_USAGE_TYPE',
479: 'USED_BY',
480: l_return_status,
481: l_usage_type
482: );

Line 574: ams_utility_pvt.get_object_name (

570: TRUE
571: );
572: l_mesg_text := fnd_message.get;
573: p_errmsg := SUBSTR (l_mesg_text ||
574: ams_utility_pvt.get_object_name (
575: l_association_rec.using_object_type,
576: l_association_rec.using_object_id),
577: 1,
578: 4000

Line 607: ams_utility_pvt.get_object_name (

603: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
604: fnd_message.set_token ('ELEMENTS','AMS_COPY_ASSOCIATIONS', TRUE);
605: l_mesg_text := fnd_message.get;
606: p_errmsg := l_mesg_text ||
607: ams_utility_pvt.get_object_name (
608: l_association_rec.master_object_type,
609: l_association_rec.master_object_id)
610: || p_errmsg;
611: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

Line 679: ams_utility_pvt.get_lookup_meaning (

675: BEGIN
676: p_errcode := NULL;
677: p_errnum := 0;
678: p_errmsg := NULL;
679: ams_utility_pvt.get_lookup_meaning (
680: 'AMS_SYS_ARC_QUALIFIER',
681: 'GEOS',
682: l_return_status,
683: l_lookup_meaning

Line 869: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',

865: BEGIN
866: p_errcode := NULL;
867: p_errnum := 0;
868: p_errmsg := NULL;
869: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
870: 'RESC',
871: l_return_status,
872: l_lookup_meaning
873: );

Line 1075: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',

1071:
1072: p_errcode := NULL;
1073: p_errnum := 0;
1074: p_errmsg := NULL;
1075: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
1076: 'ATCH',
1077: l_return_status,
1078: l_lookup_meaning
1079: );

Line 1659: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',

1655: BEGIN
1656: p_errcode := NULL;
1657: p_errnum := 0;
1658: p_errmsg := NULL;
1659: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
1660: 'CELL',
1661: l_return_status,
1662: l_lookup_meaning
1663: );

Line 1838: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',

1834: BEGIN
1835: p_errcode := NULL;
1836: p_errnum := 0;
1837: p_errmsg := NULL;
1838: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
1839: 'CATG',
1840: l_return_status,
1841: l_lookup_meaning
1842: );

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

2309: BEGIN
2310: SAVEPOINT copy_campaign_schedules;
2311: IF (AMS_DEBUG_HIGH_ON) THEN
2312:
2313: ams_utility_pvt.debug_message (l_full_name || ': start');
2314: END IF;
2315:
2316: IF fnd_api.to_boolean (p_init_msg_list) THEN
2317: fnd_msg_pub.initialize;

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

2330: x_return_status := fnd_api.g_ret_sts_success;
2331: ----------------------- insert -----------------------
2332: IF (AMS_DEBUG_HIGH_ON) THEN
2333:
2334: ams_utility_pvt.debug_message (l_full_name || ': start');
2335: END IF;
2336:
2337: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
2338: 'CSCH',

Line 2337: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',

2333:
2334: ams_utility_pvt.debug_message (l_full_name || ': start');
2335: END IF;
2336:
2337: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
2338: 'CSCH',
2339: l_return_status,
2340: l_lookup_meaning
2341: );

Line 2441: ams_utility_pvt.get_object_name ('CAMP', p_new_camp_id)

2437: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
2438: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
2439: l_mesg_text := fnd_message.get;
2440: p_errmsg := l_mesg_text ||
2441: ams_utility_pvt.get_object_name ('CAMP', p_new_camp_id)
2442: || p_errmsg;
2443: ams_cpyutility_pvt.write_log_mesg ( 'CSCH',
2444: p_src_camp_schedule_id,
2445: p_errmsg,

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

2530: IF (AMS_DEBUG_HIGH_ON) THEN
2531:
2532:
2533:
2534: ams_utility_pvt.debug_message (l_full_name || ': start');
2535:
2536: END IF;
2537: IF fnd_api.to_boolean (p_init_msg_list)
2538: THEN

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

2551: x_return_status := fnd_api.g_ret_sts_success;
2552: ----------------------- insert -----------------------
2553: IF (AMS_DEBUG_HIGH_ON) THEN
2554:
2555: ams_utility_pvt.debug_message (l_full_name || ': start');
2556: END IF;
2557:
2558: ams_utility_pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',
2559: 'TASK',

Line 2558: ams_utility_pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',

2554:
2555: ams_utility_pvt.debug_message (l_full_name || ': start');
2556: END IF;
2557:
2558: ams_utility_pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',
2559: 'TASK',
2560: l_return_status,
2561: l_lookup_meaning
2562: );

Line 2626: ams_utility_pvt.get_object_name ('CAMP', p_new_camp_id)

2622: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
2623: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
2624: l_mesg_text := fnd_message.get;
2625: p_errmsg := l_mesg_text ||
2626: ams_utility_pvt.get_object_name ('CAMP', p_new_camp_id)
2627: || p_errmsg;
2628: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2629: p_old_camp_id,
2630: p_errmsg,

Line 2674: p_errmsg := l_mesg_text || ams_utility_pvt.get_object_name

2670: ROLLBACK TO ams_task_assgn;
2671: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
2672: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
2673: l_mesg_text := fnd_message.get;
2674: p_errmsg := l_mesg_text || ams_utility_pvt.get_object_name
2675: ('CAMP', p_new_camp_id) || p_errmsg;
2676: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2677: p_old_camp_id,
2678: p_errmsg,

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

2760: IF (AMS_DEBUG_HIGH_ON) THEN
2761:
2762:
2763:
2764: ams_utility_pvt.debug_message (l_full_name || ': start');
2765:
2766: END IF;
2767:
2768: IF fnd_api.to_boolean (p_init_msg_list)

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

2783: x_return_status := fnd_api.g_ret_sts_success;
2784: ----------------------- insert -----------------------
2785: IF (AMS_DEBUG_HIGH_ON) THEN
2786:
2787: ams_utility_pvt.debug_message (l_full_name || ': start');
2788: END IF;
2789:
2790: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
2791: 'PTNR',

Line 2790: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',

2786:
2787: ams_utility_pvt.debug_message (l_full_name || ': start');
2788: END IF;
2789:
2790: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
2791: 'PTNR',
2792: l_return_status,
2793: l_lookup_meaning
2794: );

Line 2903: ams_utility_pvt.get_object_name ('CAMP',

2899: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
2900: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
2901: l_mesg_text := fnd_message.get;
2902: p_errmsg := l_mesg_text ||
2903: ams_utility_pvt.get_object_name ('CAMP',
2904: p_new_camp_id) ||
2905: p_errmsg;
2906: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2907: p_old_camp_id,

Line 2935: p_errmsg := l_mesg_text || ams_utility_pvt.get_object_name

2931:
2932: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
2933: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
2934: l_mesg_text := fnd_message.get;
2935: p_errmsg := l_mesg_text || ams_utility_pvt.get_object_name
2936: ('CAMP', p_new_camp_id) || p_errmsg;
2937: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2938: p_old_camp_id,
2939: p_errmsg,

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

3045: IF (AMS_DEBUG_HIGH_ON) THEN
3046:
3047:
3048:
3049: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
3050:
3051: END IF;
3052:
3053: -- Initialize API return status to SUCCESS

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

3096:
3097: -- Debug Message
3098: IF (AMS_DEBUG_HIGH_ON) THEN
3099:
3100: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
3101: END IF;
3102:
3103: -- Standard call to get message count and if count is 1, get message info.
3104: FND_MSG_PUB.Count_And_Get (

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

3176: IF (AMS_DEBUG_HIGH_ON) THEN
3177:
3178:
3179:
3180: ams_utility_pvt.debug_message (l_full_name || ': start');
3181:
3182: END IF;
3183:
3184: IF fnd_api.to_boolean (p_init_msg_list)

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

3199: x_return_status := fnd_api.g_ret_sts_success;
3200: ----------------------- insert -----------------------
3201: IF (AMS_DEBUG_HIGH_ON) THEN
3202:
3203: ams_utility_pvt.debug_message (l_full_name || ': start');
3204: END IF;
3205:
3206: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
3207: 'PTNR',

Line 3206: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',

3202:
3203: ams_utility_pvt.debug_message (l_full_name || ': start');
3204: END IF;
3205:
3206: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
3207: 'PTNR',
3208: l_return_status,
3209: l_lookup_meaning
3210: );

Line 3311: ams_utility_pvt.get_object_name (p_type,

3307: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
3308: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
3309: l_mesg_text := fnd_message.get;
3310: p_errmsg := l_mesg_text ||
3311: ams_utility_pvt.get_object_name (p_type,
3312: p_new_id) ||
3313: p_errmsg;
3314: ams_cpyutility_pvt.write_log_mesg ( p_type,
3315: p_old_id,

Line 3343: p_errmsg := l_mesg_text || ams_utility_pvt.get_object_name

3339:
3340: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
3341: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
3342: l_mesg_text := fnd_message.get;
3343: p_errmsg := l_mesg_text || ams_utility_pvt.get_object_name
3344: (p_type, p_new_id) || p_errmsg;
3345: ams_cpyutility_pvt.write_log_mesg ( p_type,
3346: p_old_id,
3347: p_errmsg,

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

3434:
3435: -- Debug Message
3436: IF (AMS_DEBUG_HIGH_ON) THEN
3437:
3438: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3439: END IF;
3440: -- Initialize API return status to SUCCESS
3441: x_return_status := FND_API.G_RET_STS_SUCCESS;
3442:

Line 3529: AMS_Utility_PVT.Debug_Message('Copy Timezone and other details');

3525: IF (AMS_DEBUG_HIGH_ON) THEN
3526:
3527:
3528:
3529: AMS_Utility_PVT.Debug_Message('Copy Timezone and other details');
3530:
3531: END IF;
3532: l_schedule_rec.timezone_id := l_reference_rec.timezone_id;
3533: l_schedule_rec.user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_SCHEDULE_STATUS','NEW') ;

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

3529: AMS_Utility_PVT.Debug_Message('Copy Timezone and other details');
3530:
3531: END IF;
3532: l_schedule_rec.timezone_id := l_reference_rec.timezone_id;
3533: l_schedule_rec.user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_SCHEDULE_STATUS','NEW') ;
3534: l_schedule_rec.status_code := 'NEW';
3535: l_schedule_rec.campaign_id := p_new_camp_id ;
3536: l_schedule_rec.source_code := null;
3537: l_schedule_rec.use_parent_code_flag := l_reference_rec.use_parent_code_flag;

Line 3547: AMS_Utility_PVT.Debug_Message('Create Schedule');

3543: IF (AMS_DEBUG_HIGH_ON) THEN
3544:
3545:
3546:
3547: AMS_Utility_PVT.Debug_Message('Create Schedule');
3548:
3549: END IF;
3550: AMS_Camp_Schedule_PVT.Create_Camp_Schedule(
3551: p_api_version_number => 1,

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

3569:
3570: -- Debug Message
3571: IF (AMS_DEBUG_HIGH_ON) THEN
3572:
3573: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3574: END IF;
3575:
3576: -- Standard call to get message count and if count is 1, get message info.
3577: FND_MSG_PUB.Count_And_Get

Line 3583: WHEN AMS_Utility_PVT.resource_locked THEN

3579: p_data => x_msg_data
3580: );
3581: EXCEPTION
3582:
3583: WHEN AMS_Utility_PVT.resource_locked THEN
3584: IF c_schedule_det%ISOPEN THEN
3585: CLOSE c_schedule_det ;
3586: END IF ;
3587: x_return_status := FND_API.g_ret_sts_error;

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

3584: IF c_schedule_det%ISOPEN THEN
3585: CLOSE c_schedule_det ;
3586: END IF ;
3587: x_return_status := FND_API.g_ret_sts_error;
3588: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');
3589:
3590: WHEN FND_API.G_EXC_ERROR THEN
3591: ROLLBACK TO Copy_Act_Schedule;
3592: IF c_schedule_det%ISOPEN THEN

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

3708:
3709: -- Debug Message
3710: IF (AMS_DEBUG_HIGH_ON) THEN
3711:
3712: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3713: END IF;
3714: -- Initialize API return status to SUCCESS
3715: x_return_status := FND_API.G_RET_STS_SUCCESS;
3716:

Line 3829: AMS_Utility_PVT.Debug_Message('Copy Timezone and other details');

3825: IF (AMS_DEBUG_HIGH_ON) THEN
3826:
3827:
3828:
3829: AMS_Utility_PVT.Debug_Message('Copy Timezone and other details');
3830:
3831: END IF;
3832: l_schedule_rec.timezone_id := l_reference_rec.timezone_id;
3833: l_schedule_rec.user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_SCHEDULE_STATUS','NEW') ;

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

3829: AMS_Utility_PVT.Debug_Message('Copy Timezone and other details');
3830:
3831: END IF;
3832: l_schedule_rec.timezone_id := l_reference_rec.timezone_id;
3833: l_schedule_rec.user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_SCHEDULE_STATUS','NEW') ;
3834: l_schedule_rec.status_code := 'NEW';
3835: l_schedule_rec.campaign_id := p_new_camp_id ;
3836: l_schedule_rec.source_code := null;
3837: l_schedule_rec.use_parent_code_flag := l_reference_rec.use_parent_code_flag;

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

3839: -- #Fix for bug 2989203 by asaha
3840: IF(l_schedule_rec.activity_type_code = 'EVENTS' AND
3841: l_schedule_rec.use_parent_code_flag = 'Y') THEN
3842: IF(AMS_DEBUG_HIGH_ON) THEN
3843: AMS_UTILITY_PVT.Debug_Message('change use parent flag to N for Event type schedule');
3844: END IF;
3845: l_schedule_rec.use_parent_code_flag := 'N';
3846: END IF;
3847: -- end of Fix for bug 2989203

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

3931: IF (AMS_DEBUG_HIGH_ON) THEN
3932:
3933:
3934:
3935: AMS_UTILITY_PVT.debug_message('before req_items>'||l_event_offer_rec.event_delivery_method_id||'<');
3936:
3937: END IF;
3938: IF (AMS_DEBUG_HIGH_ON) THEN
3939:

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

3936:
3937: END IF;
3938: IF (AMS_DEBUG_HIGH_ON) THEN
3939:
3940: AMS_UTILITY_PVT.debug_message('before req_items>'||l_reference_event_rec.event_delivery_method_id||'<');
3941: END IF;
3942:
3943:
3944: -- created the event EONE

Line 4005: AMS_Utility_PVT.Debug_Message('Create Schedule');

4001:
4002:
4003:
4004:
4005: AMS_Utility_PVT.Debug_Message('Create Schedule');
4006:
4007:
4008:
4009: END IF;

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

4057:
4058: -- Debug Message
4059: IF (AMS_DEBUG_HIGH_ON) THEN
4060:
4061: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
4062: END IF;
4063:
4064: -- Standard call to get message count and if count is 1, get message info.
4065: FND_MSG_PUB.Count_And_Get

Line 4071: WHEN AMS_Utility_PVT.resource_locked THEN

4067: p_data => x_msg_data
4068: );
4069: EXCEPTION
4070:
4071: WHEN AMS_Utility_PVT.resource_locked THEN
4072: IF c_schedule_details%ISOPEN THEN
4073: CLOSE c_schedule_details ;
4074: END IF ;
4075: x_return_status := FND_API.g_ret_sts_error;

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

4072: IF c_schedule_details%ISOPEN THEN
4073: CLOSE c_schedule_details ;
4074: END IF ;
4075: x_return_status := FND_API.g_ret_sts_error;
4076: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');
4077:
4078: WHEN FND_API.G_EXC_ERROR THEN
4079: ROLLBACK TO Copy_Act_Schedule;
4080: IF c_schedule_details%ISOPEN THEN

Line 4166: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',

4162:
4163: p_errcode := NULL;
4164: p_errnum := 0;
4165: p_errmsg := NULL;
4166: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
4167: 'ATCH',
4168: l_return_status,
4169: l_lookup_meaning
4170: );

Line 4487: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',

4483: AND source_object_type_code = p_src_act_type;
4484: BEGIN
4485:
4486:
4487: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
4488: 'TASK',
4489: l_return_status,
4490: l_lookup_meaning
4491: );