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_CPYUTILITY_PVT

Line 76: AMS_CPYutility_pvt.refresh_log_mesg;

72: x_transaction_id OUT NOCOPY NUMBER,
73: p_source_code IN VARCHAR2 := NULL) IS
74: BEGIN
75:
76: AMS_CPYutility_pvt.refresh_log_mesg;
77: copy_event_header(
78: p_api_version => p_api_version,
79: p_init_msg_list => p_init_msg_list,
80: x_return_status => x_return_status,

Line 91: AMS_CPYutility_pvt.insert_log_mesg(x_transaction_id);

87: p_eveh_elements_rec => p_eveh_elements_rec,
88: p_start_date => p_start_date,
89: p_end_date => p_end_date ,
90: p_source_code => p_source_code);
91: AMS_CPYutility_pvt.insert_log_mesg(x_transaction_id);
92: END;
93:
94: PROCEDURE copy_event_offer(
95: p_api_version IN NUMBER,

Line 111: AMS_CPYutility_pvt.refresh_log_mesg;

107: p_end_date IN DATE := NULL,
108: x_transaction_id OUT NOCOPY NUMBER ,
109: p_source_code IN VARCHAR2 :=NULL) IS
110: BEGIN
111: AMS_CPYutility_pvt.refresh_log_mesg;
112: copy_event_offer(
113: p_api_version => p_api_version,
114: p_init_msg_list => p_init_msg_list,
115: x_return_status => x_return_status,

Line 127: AMS_CPYutility_pvt.insert_log_mesg(x_transaction_id);

123: p_eveo_elements_rec => p_eveo_elements_rec,
124: p_start_date => p_start_date,
125: p_end_date => p_end_date,
126: p_source_code => p_source_code );
127: AMS_CPYutility_pvt.insert_log_mesg(x_transaction_id);
128: END;
129: PROCEDURE copy_deliverables(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

Line 143: AMS_CPYutility_pvt.refresh_log_mesg;

139: p_deli_elements_rec IN deli_elements_rec_type,
140: p_new_version IN VARCHAR2,
141: x_transaction_id OUT NOCOPY NUMBER) IS
142: BEGIN
143: AMS_CPYutility_pvt.refresh_log_mesg;
144:
145: copy_deliverables( p_api_version => p_api_version,
146: p_init_msg_list => p_init_msg_list ,
147: x_return_status => x_return_status ,

Line 157: AMS_CPYutility_pvt.insert_log_mesg(x_transaction_id);

153: p_new_deliv_code => p_new_deliv_code,
154: p_deli_elements_rec => p_deli_elements_rec,
155: p_new_version => p_new_version );
156:
157: AMS_CPYutility_pvt.insert_log_mesg(x_transaction_id);
158:
159: END;
160:
161: PROCEDURE copy_campaign(

Line 178: AMS_CPYutility_pvt.refresh_log_mesg;

174: p_start_date IN DATE := NULL,
175: x_transaction_id OUT NOCOPY NUMBER) IS
176: BEGIN
177:
178: AMS_CPYutility_pvt.refresh_log_mesg;
179:
180: copy_campaign( p_api_version => p_api_version,
181: p_init_msg_list => p_init_msg_list,
182: x_return_status => x_return_status,

Line 194: AMS_CPYutility_pvt.insert_log_mesg(x_transaction_id);

190: p_camp_elements_rec => p_camp_elements_rec,
191: p_end_date => p_end_date,
192: p_start_date => p_start_date );
193:
194: AMS_CPYutility_pvt.insert_log_mesg(x_transaction_id);
195:
196: END;
197: ---------------------------------------------------------------------
198:

Line 219: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,

215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
217:
218: p_source_object_id IN NUMBER,
219: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
220: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
221:
222: x_new_object_id OUT NOCOPY NUMBER,
223: x_custom_setup_id OUT NOCOPY NUMBER

Line 220: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,

216: x_msg_data OUT NOCOPY VARCHAR2,
217:
218: p_source_object_id IN NUMBER,
219: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
220: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
221:
222: x_new_object_id OUT NOCOPY NUMBER,
223: x_custom_setup_id OUT NOCOPY NUMBER
224: )

Line 399: l_date_number := ams_cpyutility_pvt.get_dates('CAMP',

395: l_camp_rec.status_date := SYSDATE;
396:
397: -- l_date number is the difference between start date of source
398: -- Campaign and end data of source campaign date
399: l_date_number := ams_cpyutility_pvt.get_dates('CAMP',
400: p_source_object_id,
401: l_return_status);
402:
403: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 410: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_camp_rec.campaign_name);

406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
407: END IF;
408:
409: -- Following code is added by ptendulk on 18Aug2001
410: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_camp_rec.campaign_name);
411: l_camp_rec.campaign_name := NVL (l_camp_rec.campaign_name, l_reference_rec.campaign_name);
412:
413: AMS_CpyUtility_PVT.get_column_value ('startDate', p_copy_columns_table, l_camp_rec.actual_exec_start_date);
414: l_camp_rec.actual_exec_start_date := NVL (l_camp_rec.actual_exec_start_date, l_reference_rec.actual_exec_start_date);

Line 413: AMS_CpyUtility_PVT.get_column_value ('startDate', p_copy_columns_table, l_camp_rec.actual_exec_start_date);

409: -- Following code is added by ptendulk on 18Aug2001
410: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_camp_rec.campaign_name);
411: l_camp_rec.campaign_name := NVL (l_camp_rec.campaign_name, l_reference_rec.campaign_name);
412:
413: AMS_CpyUtility_PVT.get_column_value ('startDate', p_copy_columns_table, l_camp_rec.actual_exec_start_date);
414: l_camp_rec.actual_exec_start_date := NVL (l_camp_rec.actual_exec_start_date, l_reference_rec.actual_exec_start_date);
415:
416: /* mayjain 8-Aug-2005
417: -- End date of copied(new) campaign is start date(user input)+l_date_number

Line 422: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_camp_rec.campaign_name);

418: l_camp_rec.actual_exec_end_date := l_camp_rec.actual_exec_start_date + l_date_number ;
419: */
420:
421:
422: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_camp_rec.campaign_name);
423: l_camp_rec.campaign_name := NVL (l_camp_rec.campaign_name, l_reference_rec.campaign_name);
424:
425: AMS_CpyUtility_PVT.get_column_value ('sourceCode', p_copy_columns_table, l_camp_rec.source_code);
426:

Line 425: AMS_CpyUtility_PVT.get_column_value ('sourceCode', p_copy_columns_table, l_camp_rec.source_code);

421:
422: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_camp_rec.campaign_name);
423: l_camp_rec.campaign_name := NVL (l_camp_rec.campaign_name, l_reference_rec.campaign_name);
424:
425: AMS_CpyUtility_PVT.get_column_value ('sourceCode', p_copy_columns_table, l_camp_rec.source_code);
426:
427: -- Getting owner value from UI. Changed by rrajesh on 10/05.
428: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_camp_rec.owner_user_id);
429:

Line 428: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_camp_rec.owner_user_id);

424:
425: AMS_CpyUtility_PVT.get_column_value ('sourceCode', p_copy_columns_table, l_camp_rec.source_code);
426:
427: -- Getting owner value from UI. Changed by rrajesh on 10/05.
428: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_camp_rec.owner_user_id);
429:
430: -- version to be taken from the screen: modified by soagrawa on 07-nov-2001, bug# 2082641
431: AMS_CpyUtility_PVT.get_column_value ('versionNum', p_copy_columns_table, l_camp_rec.version_no);
432: l_camp_rec.version_no := NVL (l_camp_rec.version_no, l_reference_rec.version_no);

Line 431: AMS_CpyUtility_PVT.get_column_value ('versionNum', p_copy_columns_table, l_camp_rec.version_no);

427: -- Getting owner value from UI. Changed by rrajesh on 10/05.
428: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_camp_rec.owner_user_id);
429:
430: -- version to be taken from the screen: modified by soagrawa on 07-nov-2001, bug# 2082641
431: AMS_CpyUtility_PVT.get_column_value ('versionNum', p_copy_columns_table, l_camp_rec.version_no);
432: l_camp_rec.version_no := NVL (l_camp_rec.version_no, l_reference_rec.version_no);
433:
434: /* mayjain 8-Aug-2005 */
435: /* changes foe R12 */

Line 436: AMS_CpyUtility_PVT.get_column_value ('endDate', p_copy_columns_table, l_camp_rec.actual_exec_end_date);

432: l_camp_rec.version_no := NVL (l_camp_rec.version_no, l_reference_rec.version_no);
433:
434: /* mayjain 8-Aug-2005 */
435: /* changes foe R12 */
436: AMS_CpyUtility_PVT.get_column_value ('endDate', p_copy_columns_table, l_camp_rec.actual_exec_end_date);
437: --l_camp_rec.actual_exec_end_date := NVL (l_camp_rec.actual_exec_end_date, l_reference_rec.actual_exec_end_date);
438:
439: AMS_CpyUtility_PVT.get_column_value ('parentCampaignId', p_copy_columns_table, l_camp_rec.parent_campaign_id);
440: --l_camp_rec.parent_campaign_id := NVL (l_camp_rec.parent_campaign_id, l_reference_rec.parent_campaign_id);

Line 439: AMS_CpyUtility_PVT.get_column_value ('parentCampaignId', p_copy_columns_table, l_camp_rec.parent_campaign_id);

435: /* changes foe R12 */
436: AMS_CpyUtility_PVT.get_column_value ('endDate', p_copy_columns_table, l_camp_rec.actual_exec_end_date);
437: --l_camp_rec.actual_exec_end_date := NVL (l_camp_rec.actual_exec_end_date, l_reference_rec.actual_exec_end_date);
438:
439: AMS_CpyUtility_PVT.get_column_value ('parentCampaignId', p_copy_columns_table, l_camp_rec.parent_campaign_id);
440: --l_camp_rec.parent_campaign_id := NVL (l_camp_rec.parent_campaign_id, l_reference_rec.parent_campaign_id);
441:
442: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_camp_rec.description);
443: --l_camp_rec.description := NVL (l_camp_rec.description, l_reference_rec.description);

Line 442: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_camp_rec.description);

438:
439: AMS_CpyUtility_PVT.get_column_value ('parentCampaignId', p_copy_columns_table, l_camp_rec.parent_campaign_id);
440: --l_camp_rec.parent_campaign_id := NVL (l_camp_rec.parent_campaign_id, l_reference_rec.parent_campaign_id);
441:
442: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_camp_rec.description);
443: --l_camp_rec.description := NVL (l_camp_rec.description, l_reference_rec.description);
444:
445: AMS_CpyUtility_PVT.get_column_value ('attribute_category', p_copy_columns_table, l_camp_rec.attribute_category);
446: --l_camp_rec.attribute_category := NVL (l_camp_rec.attribute_category, l_reference_rec.attribute_category);

Line 445: AMS_CpyUtility_PVT.get_column_value ('attribute_category', p_copy_columns_table, l_camp_rec.attribute_category);

441:
442: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_camp_rec.description);
443: --l_camp_rec.description := NVL (l_camp_rec.description, l_reference_rec.description);
444:
445: AMS_CpyUtility_PVT.get_column_value ('attribute_category', p_copy_columns_table, l_camp_rec.attribute_category);
446: --l_camp_rec.attribute_category := NVL (l_camp_rec.attribute_category, l_reference_rec.attribute_category);
447:
448: AMS_CpyUtility_PVT.get_column_value ('attribute1', p_copy_columns_table, l_camp_rec.attribute1);
449: --l_camp_rec.attribute1 := NVL (l_camp_rec.attribute1, l_reference_rec.attribute1);

Line 448: AMS_CpyUtility_PVT.get_column_value ('attribute1', p_copy_columns_table, l_camp_rec.attribute1);

444:
445: AMS_CpyUtility_PVT.get_column_value ('attribute_category', p_copy_columns_table, l_camp_rec.attribute_category);
446: --l_camp_rec.attribute_category := NVL (l_camp_rec.attribute_category, l_reference_rec.attribute_category);
447:
448: AMS_CpyUtility_PVT.get_column_value ('attribute1', p_copy_columns_table, l_camp_rec.attribute1);
449: --l_camp_rec.attribute1 := NVL (l_camp_rec.attribute1, l_reference_rec.attribute1);
450:
451: AMS_CpyUtility_PVT.get_column_value ('attribute2', p_copy_columns_table, l_camp_rec.attribute2);
452: --l_camp_rec.attribute2 := NVL (l_camp_rec.attribute2, l_reference_rec.attribute2);

Line 451: AMS_CpyUtility_PVT.get_column_value ('attribute2', p_copy_columns_table, l_camp_rec.attribute2);

447:
448: AMS_CpyUtility_PVT.get_column_value ('attribute1', p_copy_columns_table, l_camp_rec.attribute1);
449: --l_camp_rec.attribute1 := NVL (l_camp_rec.attribute1, l_reference_rec.attribute1);
450:
451: AMS_CpyUtility_PVT.get_column_value ('attribute2', p_copy_columns_table, l_camp_rec.attribute2);
452: --l_camp_rec.attribute2 := NVL (l_camp_rec.attribute2, l_reference_rec.attribute2);
453:
454: AMS_CpyUtility_PVT.get_column_value ('attribute3', p_copy_columns_table, l_camp_rec.attribute3);
455: --l_camp_rec.attribute3 := NVL (l_camp_rec.attribute3, l_reference_rec.attribute3);

Line 454: AMS_CpyUtility_PVT.get_column_value ('attribute3', p_copy_columns_table, l_camp_rec.attribute3);

450:
451: AMS_CpyUtility_PVT.get_column_value ('attribute2', p_copy_columns_table, l_camp_rec.attribute2);
452: --l_camp_rec.attribute2 := NVL (l_camp_rec.attribute2, l_reference_rec.attribute2);
453:
454: AMS_CpyUtility_PVT.get_column_value ('attribute3', p_copy_columns_table, l_camp_rec.attribute3);
455: --l_camp_rec.attribute3 := NVL (l_camp_rec.attribute3, l_reference_rec.attribute3);
456:
457: AMS_CpyUtility_PVT.get_column_value ('attribute4', p_copy_columns_table, l_camp_rec.attribute4);
458: --l_camp_rec.attribute4 := NVL (l_camp_rec.attribute1, l_reference_rec.attribute4);

Line 457: AMS_CpyUtility_PVT.get_column_value ('attribute4', p_copy_columns_table, l_camp_rec.attribute4);

453:
454: AMS_CpyUtility_PVT.get_column_value ('attribute3', p_copy_columns_table, l_camp_rec.attribute3);
455: --l_camp_rec.attribute3 := NVL (l_camp_rec.attribute3, l_reference_rec.attribute3);
456:
457: AMS_CpyUtility_PVT.get_column_value ('attribute4', p_copy_columns_table, l_camp_rec.attribute4);
458: --l_camp_rec.attribute4 := NVL (l_camp_rec.attribute1, l_reference_rec.attribute4);
459:
460: AMS_CpyUtility_PVT.get_column_value ('attribute5', p_copy_columns_table, l_camp_rec.attribute5);
461: --l_camp_rec.attribute5 := NVL (l_camp_rec.attribute5, l_reference_rec.attribute5);

Line 460: AMS_CpyUtility_PVT.get_column_value ('attribute5', p_copy_columns_table, l_camp_rec.attribute5);

456:
457: AMS_CpyUtility_PVT.get_column_value ('attribute4', p_copy_columns_table, l_camp_rec.attribute4);
458: --l_camp_rec.attribute4 := NVL (l_camp_rec.attribute1, l_reference_rec.attribute4);
459:
460: AMS_CpyUtility_PVT.get_column_value ('attribute5', p_copy_columns_table, l_camp_rec.attribute5);
461: --l_camp_rec.attribute5 := NVL (l_camp_rec.attribute5, l_reference_rec.attribute5);
462:
463: AMS_CpyUtility_PVT.get_column_value ('attribute6', p_copy_columns_table, l_camp_rec.attribute6);
464: --l_camp_rec.attribute6 := NVL (l_camp_rec.attribute6, l_reference_rec.attribute6);

Line 463: AMS_CpyUtility_PVT.get_column_value ('attribute6', p_copy_columns_table, l_camp_rec.attribute6);

459:
460: AMS_CpyUtility_PVT.get_column_value ('attribute5', p_copy_columns_table, l_camp_rec.attribute5);
461: --l_camp_rec.attribute5 := NVL (l_camp_rec.attribute5, l_reference_rec.attribute5);
462:
463: AMS_CpyUtility_PVT.get_column_value ('attribute6', p_copy_columns_table, l_camp_rec.attribute6);
464: --l_camp_rec.attribute6 := NVL (l_camp_rec.attribute6, l_reference_rec.attribute6);
465:
466: AMS_CpyUtility_PVT.get_column_value ('attribute7', p_copy_columns_table, l_camp_rec.attribute7);
467: --l_camp_rec.attribute7 := NVL (l_camp_rec.attribute7, l_reference_rec.attribute7);

Line 466: AMS_CpyUtility_PVT.get_column_value ('attribute7', p_copy_columns_table, l_camp_rec.attribute7);

462:
463: AMS_CpyUtility_PVT.get_column_value ('attribute6', p_copy_columns_table, l_camp_rec.attribute6);
464: --l_camp_rec.attribute6 := NVL (l_camp_rec.attribute6, l_reference_rec.attribute6);
465:
466: AMS_CpyUtility_PVT.get_column_value ('attribute7', p_copy_columns_table, l_camp_rec.attribute7);
467: --l_camp_rec.attribute7 := NVL (l_camp_rec.attribute7, l_reference_rec.attribute7);
468:
469: AMS_CpyUtility_PVT.get_column_value ('attribute8', p_copy_columns_table, l_camp_rec.attribute8);
470: --l_camp_rec.attribute8 := NVL (l_camp_rec.attribute8, l_reference_rec.attribute8);

Line 469: AMS_CpyUtility_PVT.get_column_value ('attribute8', p_copy_columns_table, l_camp_rec.attribute8);

465:
466: AMS_CpyUtility_PVT.get_column_value ('attribute7', p_copy_columns_table, l_camp_rec.attribute7);
467: --l_camp_rec.attribute7 := NVL (l_camp_rec.attribute7, l_reference_rec.attribute7);
468:
469: AMS_CpyUtility_PVT.get_column_value ('attribute8', p_copy_columns_table, l_camp_rec.attribute8);
470: --l_camp_rec.attribute8 := NVL (l_camp_rec.attribute8, l_reference_rec.attribute8);
471:
472: AMS_CpyUtility_PVT.get_column_value ('attribute9', p_copy_columns_table, l_camp_rec.attribute9);
473: --l_camp_rec.attribute9 := NVL (l_camp_rec.attribute9, l_reference_rec.attribute9);

Line 472: AMS_CpyUtility_PVT.get_column_value ('attribute9', p_copy_columns_table, l_camp_rec.attribute9);

468:
469: AMS_CpyUtility_PVT.get_column_value ('attribute8', p_copy_columns_table, l_camp_rec.attribute8);
470: --l_camp_rec.attribute8 := NVL (l_camp_rec.attribute8, l_reference_rec.attribute8);
471:
472: AMS_CpyUtility_PVT.get_column_value ('attribute9', p_copy_columns_table, l_camp_rec.attribute9);
473: --l_camp_rec.attribute9 := NVL (l_camp_rec.attribute9, l_reference_rec.attribute9);
474:
475: AMS_CpyUtility_PVT.get_column_value ('attribute10', p_copy_columns_table, l_camp_rec.attribute10);
476: --l_camp_rec.attribute10 := NVL (l_camp_rec.attribute10, l_reference_rec.attribute10);

Line 475: AMS_CpyUtility_PVT.get_column_value ('attribute10', p_copy_columns_table, l_camp_rec.attribute10);

471:
472: AMS_CpyUtility_PVT.get_column_value ('attribute9', p_copy_columns_table, l_camp_rec.attribute9);
473: --l_camp_rec.attribute9 := NVL (l_camp_rec.attribute9, l_reference_rec.attribute9);
474:
475: AMS_CpyUtility_PVT.get_column_value ('attribute10', p_copy_columns_table, l_camp_rec.attribute10);
476: --l_camp_rec.attribute10 := NVL (l_camp_rec.attribute10, l_reference_rec.attribute10);
477:
478: AMS_CpyUtility_PVT.get_column_value ('attribute11', p_copy_columns_table, l_camp_rec.attribute11);
479: --l_camp_rec.attribute11 := NVL (l_camp_rec.attribute11, l_reference_rec.attribute11);

Line 478: AMS_CpyUtility_PVT.get_column_value ('attribute11', p_copy_columns_table, l_camp_rec.attribute11);

474:
475: AMS_CpyUtility_PVT.get_column_value ('attribute10', p_copy_columns_table, l_camp_rec.attribute10);
476: --l_camp_rec.attribute10 := NVL (l_camp_rec.attribute10, l_reference_rec.attribute10);
477:
478: AMS_CpyUtility_PVT.get_column_value ('attribute11', p_copy_columns_table, l_camp_rec.attribute11);
479: --l_camp_rec.attribute11 := NVL (l_camp_rec.attribute11, l_reference_rec.attribute11);
480:
481: AMS_CpyUtility_PVT.get_column_value ('attribute12', p_copy_columns_table, l_camp_rec.attribute12);
482: --l_camp_rec.attribute12 := NVL (l_camp_rec.attribute12, l_reference_rec.attribute12);

Line 481: AMS_CpyUtility_PVT.get_column_value ('attribute12', p_copy_columns_table, l_camp_rec.attribute12);

477:
478: AMS_CpyUtility_PVT.get_column_value ('attribute11', p_copy_columns_table, l_camp_rec.attribute11);
479: --l_camp_rec.attribute11 := NVL (l_camp_rec.attribute11, l_reference_rec.attribute11);
480:
481: AMS_CpyUtility_PVT.get_column_value ('attribute12', p_copy_columns_table, l_camp_rec.attribute12);
482: --l_camp_rec.attribute12 := NVL (l_camp_rec.attribute12, l_reference_rec.attribute12);
483:
484: AMS_CpyUtility_PVT.get_column_value ('attribute13', p_copy_columns_table, l_camp_rec.attribute13);
485: --l_camp_rec.attribute13 := NVL (l_camp_rec.attribute13, l_reference_rec.attribute13);

Line 484: AMS_CpyUtility_PVT.get_column_value ('attribute13', p_copy_columns_table, l_camp_rec.attribute13);

480:
481: AMS_CpyUtility_PVT.get_column_value ('attribute12', p_copy_columns_table, l_camp_rec.attribute12);
482: --l_camp_rec.attribute12 := NVL (l_camp_rec.attribute12, l_reference_rec.attribute12);
483:
484: AMS_CpyUtility_PVT.get_column_value ('attribute13', p_copy_columns_table, l_camp_rec.attribute13);
485: --l_camp_rec.attribute13 := NVL (l_camp_rec.attribute13, l_reference_rec.attribute13);
486:
487: AMS_CpyUtility_PVT.get_column_value ('attribute14', p_copy_columns_table, l_camp_rec.attribute14);
488: --l_camp_rec.attribute14 := NVL (l_camp_rec.attribute14, l_reference_rec.attribute14);

Line 487: AMS_CpyUtility_PVT.get_column_value ('attribute14', p_copy_columns_table, l_camp_rec.attribute14);

483:
484: AMS_CpyUtility_PVT.get_column_value ('attribute13', p_copy_columns_table, l_camp_rec.attribute13);
485: --l_camp_rec.attribute13 := NVL (l_camp_rec.attribute13, l_reference_rec.attribute13);
486:
487: AMS_CpyUtility_PVT.get_column_value ('attribute14', p_copy_columns_table, l_camp_rec.attribute14);
488: --l_camp_rec.attribute14 := NVL (l_camp_rec.attribute14, l_reference_rec.attribute14);
489:
490: AMS_CpyUtility_PVT.get_column_value ('attribute15', p_copy_columns_table, l_camp_rec.attribute15);
491: --l_camp_rec.attribute15 := NVL (l_camp_rec.attribute15, l_reference_rec.attribute15);

Line 490: AMS_CpyUtility_PVT.get_column_value ('attribute15', p_copy_columns_table, l_camp_rec.attribute15);

486:
487: AMS_CpyUtility_PVT.get_column_value ('attribute14', p_copy_columns_table, l_camp_rec.attribute14);
488: --l_camp_rec.attribute14 := NVL (l_camp_rec.attribute14, l_reference_rec.attribute14);
489:
490: AMS_CpyUtility_PVT.get_column_value ('attribute15', p_copy_columns_table, l_camp_rec.attribute15);
491: --l_camp_rec.attribute15 := NVL (l_camp_rec.attribute15, l_reference_rec.attribute15);
492: /* mayjain 8-Aug-2005 */
493: /* changes foe R12 */
494:

Line 530: --WRITE_TO_ACT_LOG('Copy Sched Attrib'|| AMS_CpyUtility_PVT.is_copy_attribute ('CSCH', p_attributes_table), 'CAMP',1111);

526: -- Partners PTNR
527: -- Schedules
528: -- Subcamp
529:
530: --WRITE_TO_ACT_LOG('Copy Sched Attrib'|| AMS_CpyUtility_PVT.is_copy_attribute ('CSCH', p_attributes_table), 'CAMP',1111);
531:
532: IF AMS_CpyUtility_PVT.is_copy_attribute ('CSCH', p_attributes_table) = FND_API.G_TRUE
533: THEN
534: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'CSCH') = FND_API.G_TRUE -- Bug fix: 2081684

Line 532: IF AMS_CpyUtility_PVT.is_copy_attribute ('CSCH', p_attributes_table) = FND_API.G_TRUE

528: -- Subcamp
529:
530: --WRITE_TO_ACT_LOG('Copy Sched Attrib'|| AMS_CpyUtility_PVT.is_copy_attribute ('CSCH', p_attributes_table), 'CAMP',1111);
531:
532: IF AMS_CpyUtility_PVT.is_copy_attribute ('CSCH', p_attributes_table) = FND_API.G_TRUE
533: THEN
534: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'CSCH') = FND_API.G_TRUE -- Bug fix: 2081684
535: THEN
536: --Following code is modified by rrajesh on 08/31/01.

Line 534: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'CSCH') = FND_API.G_TRUE -- Bug fix: 2081684

530: --WRITE_TO_ACT_LOG('Copy Sched Attrib'|| AMS_CpyUtility_PVT.is_copy_attribute ('CSCH', p_attributes_table), 'CAMP',1111);
531:
532: IF AMS_CpyUtility_PVT.is_copy_attribute ('CSCH', p_attributes_table) = FND_API.G_TRUE
533: THEN
534: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'CSCH') = FND_API.G_TRUE -- Bug fix: 2081684
535: THEN
536: --Following code is modified by rrajesh on 08/31/01.
537: --To copy selected schedules
538: /*ams_copyelements_pvt.copy_act_schedules

Line 551: AMS_CpyUtility_PVT.get_column_value ('scheduleIdRec', p_copy_columns_table, x_schedule_ids);

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:
554: IF (AMS_DEBUG_HIGH_ON) THEN
555:

Line 625: IF AMS_CpyUtility_PVT.is_copy_attribute ('MESG', p_attributes_table) = FND_API.G_TRUE

621: END IF; -- Bug fix: 2081684
622:
623: END IF;
624: --WRITE_TO_ACT_LOG('schedules copied succesfully','CAMP',1111);
625: IF AMS_CpyUtility_PVT.is_copy_attribute ('MESG', p_attributes_table) = FND_API.G_TRUE
626: THEN
627: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'MESG') = FND_API.G_TRUE -- Bug fix: 2081684
628: THEN
629: ams_copyelements_pvt.copy_act_messages

Line 627: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'MESG') = FND_API.G_TRUE -- Bug fix: 2081684

623: END IF;
624: --WRITE_TO_ACT_LOG('schedules copied succesfully','CAMP',1111);
625: IF AMS_CpyUtility_PVT.is_copy_attribute ('MESG', p_attributes_table) = FND_API.G_TRUE
626: THEN
627: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'MESG') = FND_API.G_TRUE -- Bug fix: 2081684
628: THEN
629: ams_copyelements_pvt.copy_act_messages
630: ( p_src_act_type =>'CAMP',
631: p_src_act_id =>p_source_object_id,

Line 638: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE

634: p_errcode =>l_errcode,
635: p_errmsg =>l_errmsg);
636: END IF;
637: END IF;
638: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE
639: THEN
640: -- modified by soagrawa on 31-jan-2002 bug# 2207969
641: IF ams_cpyutility_pvt.check_attrib_exists('AMS_CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684
642: -- IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684

Line 641: IF ams_cpyutility_pvt.check_attrib_exists('AMS_CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684

637: END IF;
638: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE
639: THEN
640: -- modified by soagrawa on 31-jan-2002 bug# 2207969
641: IF ams_cpyutility_pvt.check_attrib_exists('AMS_CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684
642: -- IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684
643: THEN
644: -- Modified by rrajesh on 10/18/01
645: /*ams_copyelements_pvt.copy_act_attachments

Line 642: -- IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684

638: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE
639: THEN
640: -- modified by soagrawa on 31-jan-2002 bug# 2207969
641: IF ams_cpyutility_pvt.check_attrib_exists('AMS_CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684
642: -- IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684
643: THEN
644: -- Modified by rrajesh on 10/18/01
645: /*ams_copyelements_pvt.copy_act_attachments
646: ( p_src_act_type =>'CAMP',

Line 663: IF AMS_CpyUtility_PVT.is_copy_attribute ('GEOS', p_attributes_table) = FND_API.G_TRUE

659: -- end change 10/18/01
660: END IF;
661: END IF;
662: -- Added by rrajesh on 10/18/01
663: IF AMS_CpyUtility_PVT.is_copy_attribute ('GEOS', p_attributes_table) = FND_API.G_TRUE
664: THEN
665: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'GEOS') = FND_API.G_TRUE -- Bug fix: 2081684
666: THEN
667: ams_copyelements_pvt.copy_act_geo_areas

Line 665: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'GEOS') = FND_API.G_TRUE -- Bug fix: 2081684

661: END IF;
662: -- Added by rrajesh on 10/18/01
663: IF AMS_CpyUtility_PVT.is_copy_attribute ('GEOS', p_attributes_table) = FND_API.G_TRUE
664: THEN
665: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'GEOS') = FND_API.G_TRUE -- Bug fix: 2081684
666: THEN
667: ams_copyelements_pvt.copy_act_geo_areas
668: ( p_src_act_type => 'CAMP',
669: p_src_act_id => p_source_object_id,

Line 676: IF AMS_CpyUtility_PVT.is_copy_attribute ('DELV', p_attributes_table) = FND_API.G_TRUE

672: p_errcode => l_errcode,
673: p_errmsg => l_errmsg);
674: END IF;
675: END IF;
676: IF AMS_CpyUtility_PVT.is_copy_attribute ('DELV', p_attributes_table) = FND_API.G_TRUE
677: THEN
678: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'DELV') = FND_API.G_TRUE -- Bug fix: 2081684
679: THEN
680: ams_copyelements_pvt.copy_object_associations

Line 678: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'DELV') = FND_API.G_TRUE -- Bug fix: 2081684

674: END IF;
675: END IF;
676: IF AMS_CpyUtility_PVT.is_copy_attribute ('DELV', p_attributes_table) = FND_API.G_TRUE
677: THEN
678: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'DELV') = FND_API.G_TRUE -- Bug fix: 2081684
679: THEN
680: ams_copyelements_pvt.copy_object_associations
681: ( p_src_act_type => 'CAMP',
682: p_src_act_id =>p_source_object_id,

Line 691: IF AMS_CpyUtility_PVT.is_copy_attribute ('PROD', p_attributes_table) = FND_API.G_TRUE

687: END IF;
688: END IF;
689:
690: -- end change 10/18/01
691: IF AMS_CpyUtility_PVT.is_copy_attribute ('PROD', p_attributes_table) = FND_API.G_TRUE
692: THEN
693: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'PROD') = FND_API.G_TRUE -- Bug fix: 2081684
694: THEN
695: ams_copyelements_pvt.copy_act_prod

Line 693: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'PROD') = FND_API.G_TRUE -- Bug fix: 2081684

689:
690: -- end change 10/18/01
691: IF AMS_CpyUtility_PVT.is_copy_attribute ('PROD', p_attributes_table) = FND_API.G_TRUE
692: THEN
693: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'PROD') = FND_API.G_TRUE -- Bug fix: 2081684
694: THEN
695: ams_copyelements_pvt.copy_act_prod
696: ( p_src_act_type => 'CAMP',
697: p_src_act_id =>p_source_object_id,

Line 704: IF AMS_CpyUtility_PVT.is_copy_attribute ('CELL', p_attributes_table) = FND_API.G_TRUE

700: p_errcode => l_errcode,
701: p_errmsg => l_errmsg);
702: END IF;
703: END IF;
704: IF AMS_CpyUtility_PVT.is_copy_attribute ('CELL', p_attributes_table) = FND_API.G_TRUE
705: THEN
706: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'CELL') = FND_API.G_TRUE -- Bug fix: 2081684
707: THEN
708: ams_copyelements_pvt.copy_act_market_segments

Line 706: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'CELL') = FND_API.G_TRUE -- Bug fix: 2081684

702: END IF;
703: END IF;
704: IF AMS_CpyUtility_PVT.is_copy_attribute ('CELL', p_attributes_table) = FND_API.G_TRUE
705: THEN
706: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'CELL') = FND_API.G_TRUE -- Bug fix: 2081684
707: THEN
708: ams_copyelements_pvt.copy_act_market_segments
709: ( p_src_act_type =>'CAMP',
710: p_src_act_id =>p_source_object_id,

Line 717: IF AMS_CpyUtility_PVT.is_copy_attribute ('PTNR', p_attributes_table) = FND_API.G_TRUE

713: p_errcode =>l_errcode,
714: p_errmsg =>l_errmsg);
715: END IF;
716: END IF;
717: IF AMS_CpyUtility_PVT.is_copy_attribute ('PTNR', p_attributes_table) = FND_API.G_TRUE
718: THEN
719: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'PTNR') = FND_API.G_TRUE -- Bug fix: 2081684
720: THEN
721: -- Bug fix:2072789

Line 719: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'PTNR') = FND_API.G_TRUE -- Bug fix: 2081684

715: END IF;
716: END IF;
717: IF AMS_CpyUtility_PVT.is_copy_attribute ('PTNR', p_attributes_table) = FND_API.G_TRUE
718: THEN
719: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'PTNR') = FND_API.G_TRUE -- Bug fix: 2081684
720: THEN
721: -- Bug fix:2072789
722: /*ams_copyelements_pvt.copy_partners
723: (p_init_msg_list => fnd_api.g_true,

Line 879: ams_cpyutility_pvt.write_log_mesg('DELV', p_src_deliv_id,

875: fnd_message.set_name('AMS', 'AMS_COPY_ELEMENTS');
876: fnd_message.set_token('ELEMENTS', l_lookup_meaning, TRUE);
877: l_mesg_text := fnd_message.get;
878: -- Writing to the Pl/SQLtable
879: ams_cpyutility_pvt.write_log_mesg('DELV', p_src_deliv_id,
880: l_mesg_text, 'GENERAL');
881: l_return_status := NULL;
882: l_msg_count := 0;
883: l_msg_data := NULL;

Line 991: ams_cpyutility_pvt.write_log_mesg( 'DELV',

987: LOOP
988: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
989: p_errmsg := SUBSTR( l_mesg_text || ',): ' || l_counter ||
990: ' OF ' || l_msg_count, 1, 3000);
991: ams_cpyutility_pvt.write_log_mesg( 'DELV',
992: p_src_deliv_id,
993: p_errmsg,
994: 'ERROR');
995: END LOOP;

Line 1003: ams_cpyutility_pvt.write_log_mesg('DELV',

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');
1005: IF l_return_status = fnd_api.g_ret_sts_error then
1006: RAISE fnd_api.g_exc_error;
1007: ELSE

Line 1252: ams_cpyutility_pvt.write_log_mesg('EVEO', p_src_eveo_id, l_mesg_text, 'GENERAL');

1248: fnd_message.set_name('AMS', 'AMS_COPY_ELEMENTS');
1249: fnd_message.set_token('ELEMENTS', l_lookup_meaning, TRUE);
1250: l_mesg_text := fnd_message.get;
1251: -- Writing to the Pl/SQLtable
1252: ams_cpyutility_pvt.write_log_mesg('EVEO', p_src_eveo_id, l_mesg_text, 'GENERAL');
1253: l_return_status := NULL;
1254: l_msg_count := 0;
1255: l_msg_data := NULL;
1256: -- selects the event offers to copy

Line 1306: ams_cpyutility_pvt.get_dates('EVEO',

1302: l_eveo_rec.event_start_date := p_start_date;
1303: END IF;
1304:
1305: l_date_number :=
1306: ams_cpyutility_pvt.get_dates('EVEO',
1307: p_src_eveo_id, l_return_status);
1308:
1309: IF l_eventoffer_rec.event_end_date IS NOT NULL
1310: THEN

Line 1439: ams_cpyutility_pvt.write_log_mesg( 'EVEO',

1435: FOR l_counter IN 1 .. l_msg_count LOOP
1436: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1437: p_errmsg := SUBSTR( l_mesg_text || '): ' || l_counter || ' OF ' ||
1438: l_msg_count, 1, 3000);
1439: ams_cpyutility_pvt.write_log_mesg( 'EVEO',
1440: p_src_eveo_id,
1441: p_errmsg,
1442: 'ERROR');
1443: END LOOP;

Line 1451: ams_cpyutility_pvt.write_log_mesg('EVEO',

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,
1454: 'ERROR');
1455: -- Is failed write a copy failed message in the log table

Line 1759: ams_cpyutility_pvt.write_log_mesg('EVEH',

1755: fnd_message.set_name('AMS', 'AMS_COPY_ELEMENTS');
1756: fnd_message.set_token('ELEMENTS', l_lookup_meaning, TRUE);
1757: l_mesg_text := fnd_message.get;
1758: -- Writing to the Pl/SQLtable
1759: ams_cpyutility_pvt.write_log_mesg('EVEH',
1760: p_src_eveh_id,
1761: l_mesg_text,
1762: 'GENERAL');
1763: l_return_status := NULL;

Line 1810: ams_cpyutility_pvt.get_dates('EVEH',

1806: l_eveh_rec.active_from_date := p_start_date;
1807: END IF;
1808:
1809: l_date_number :=
1810: ams_cpyutility_pvt.get_dates('EVEH',
1811: p_src_eveh_id,
1812: l_return_status);
1813:
1814: IF l_eventheader_rec.active_to_date IS NOT NULL

Line 1907: ams_cpyutility_pvt.write_log_mesg( 'EVEH',

1903: FOR l_counter IN 1 .. l_msg_count LOOP
1904: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1905: p_errmsg := SUBSTR( l_mesg_text || '): ' || l_counter ||
1906: ' OF ' || l_msg_count, 1, 3000);
1907: ams_cpyutility_pvt.write_log_mesg( 'EVEH',
1908: p_src_eveh_id,
1909: p_errmsg,
1910: 'ERROR');
1911: END LOOP;

Line 1918: ams_cpyutility_pvt.write_log_mesg('EVEH',

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,
1921: 'ERROR');
1922: -- Is failed write a copy failed message in the log table

Line 2259: ams_cpyutility_pvt.write_log_mesg( 'CAMP',

2255: fnd_message.set_token('ELEMENTS',l_lookup_meaning,TRUE);
2256: l_mesg_text := fnd_message.get ;
2257:
2258: -- Writing to PL/SQL table
2259: ams_cpyutility_pvt.write_log_mesg( 'CAMP',
2260: p_src_camp_id,
2261: l_mesg_text,
2262: 'GENERAL');
2263: -- Get the source campaign details

Line 2393: l_date_number := ams_cpyutility_pvt.get_dates('CAMP',

2389:
2390: -- End Date Algorithm
2391: -- l_date number is the difference between start date of source
2392: -- Campaign and end data of source campaign date
2393: l_date_number := ams_cpyutility_pvt.get_dates('CAMP',
2394: p_src_camp_id,
2395: l_return_status);
2396:
2397: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2455: ams_cpyutility_pvt.write_log_mesg( 'CAMP',

2451: LOOP
2452: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2453: l_errmsg := SUBSTR( l_mesg_text || '): ' || l_counter ||
2454: ' OF ' || l_msg_count, 1, 3000);
2455: ams_cpyutility_pvt.write_log_mesg( 'CAMP',
2456: p_src_camp_id,
2457: l_errmsg,
2458: 'ERROR');
2459: END LOOP;

Line 2468: ams_cpyutility_pvt.write_log_mesg('CAMP',

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 ,
2471: 'ERROR');
2472: END IF ;

Line 2664: ams_cpyutility_pvt.write_log_mesg( 'CAMP',

2660: fnd_message.set_token('ELEMENT_NAME',p_new_camp_name,TRUE);
2661: l_mesg_text := fnd_message.get ;
2662:
2663: -- Writing to PL/SQL table
2664: ams_cpyutility_pvt.write_log_mesg( 'CAMP',
2665: p_src_camp_id,
2666: l_mesg_text,
2667: 'GENERAL');
2668: