159: 'EVEO',
160: l_return_status,
161: l_lookup_meaning
162: );
163: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
164: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
165: l_mesg_text := fnd_message.get;
166: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
167: l_event_header_id,
160: l_return_status,
161: l_lookup_meaning
162: );
163: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
164: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
165: l_mesg_text := fnd_message.get;
166: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
167: l_event_header_id,
168: l_mesg_text,
161: l_lookup_meaning
162: );
163: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
164: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
165: l_mesg_text := fnd_message.get;
166: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
167: l_event_header_id,
168: l_mesg_text,
169: 'GENERAL'
221: p_errmsg,
222: 'ERROR'
223: );
224: END LOOP;
225: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
226: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
227: l_mesg_text := fnd_message.get;
228: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
229: AMS_Event_Objects_Copy_PVT.get_offer_name (
222: 'ERROR'
223: );
224: END LOOP;
225: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
226: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
227: l_mesg_text := fnd_message.get;
228: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
229: AMS_Event_Objects_Copy_PVT.get_offer_name (
230: p_src_act_id
223: );
224: END LOOP;
225: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
226: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
227: l_mesg_text := fnd_message.get;
228: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
229: AMS_Event_Objects_Copy_PVT.get_offer_name (
230: p_src_act_id
231: ), 1, 4000);
380: THEN
381: p_errcode := SQLCODE;
382: p_errnum := 4;
383: l_stmt_num := 5;
384: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
385: fnd_message.set_token ('ELEMENTS','AMS_COPY_DELIVMETHODS', TRUE);
386: l_mesg_text := fnd_message.get;
387: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
388: ',' || '): ' || p_errcode || SQLERRM, 1, 4000);
381: p_errcode := SQLCODE;
382: p_errnum := 4;
383: l_stmt_num := 5;
384: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
385: fnd_message.set_token ('ELEMENTS','AMS_COPY_DELIVMETHODS', TRUE);
386: l_mesg_text := fnd_message.get;
387: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
388: ',' || '): ' || p_errcode || SQLERRM, 1, 4000);
389: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
382: p_errnum := 4;
383: l_stmt_num := 5;
384: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
385: fnd_message.set_token ('ELEMENTS','AMS_COPY_DELIVMETHODS', TRUE);
386: l_mesg_text := fnd_message.get;
387: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
388: ',' || '): ' || p_errcode || SQLERRM, 1, 4000);
389: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
390: p_src_act_id,
516: 'AGEN',
517: l_return_status,
518: l_lookup_meaning
519: );
520: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
521: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
522: l_mesg_text := fnd_message.get;
523: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
524: p_src_act_id,
517: l_return_status,
518: l_lookup_meaning
519: );
520: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
521: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
522: l_mesg_text := fnd_message.get;
523: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
524: p_src_act_id,
525: l_mesg_text,
518: l_lookup_meaning
519: );
520: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
521: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
522: l_mesg_text := fnd_message.get;
523: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
524: p_src_act_id,
525: l_mesg_text,
526: 'GENERAL'
596: p_errmsg,
597: 'ERROR'
598: );
599: END LOOP;
600: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
601: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
602: l_mesg_text := fnd_message.get;
603:
604: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
597: 'ERROR'
598: );
599: END LOOP;
600: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
601: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
602: l_mesg_text := fnd_message.get;
603:
604: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
605: AMS_Event_Objects_Copy_PVT.get_agenda_name (
598: );
599: END LOOP;
600: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
601: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
602: l_mesg_text := fnd_message.get;
603:
604: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
605: AMS_Event_Objects_Copy_PVT.get_agenda_name (
606: agenda_rec.parent_event_header_id
615: WHEN OTHERS THEN
616: p_errcode := SQLCODE;
617: p_errnum := 3;
618: l_stmt_num := 4;
619: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR');
620: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
621: l_mesg_text := fnd_message.get;
622: p_errmsg := SUBSTR ( l_mesg_text ||
623: ',' || TO_CHAR (l_stmt_num) ||
616: p_errcode := SQLCODE;
617: p_errnum := 3;
618: l_stmt_num := 4;
619: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR');
620: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
621: l_mesg_text := fnd_message.get;
622: p_errmsg := SUBSTR ( l_mesg_text ||
623: ',' || TO_CHAR (l_stmt_num) ||
624: ',' || '): ' || p_errcode ||
617: p_errnum := 3;
618: l_stmt_num := 4;
619: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR');
620: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
621: l_mesg_text := fnd_message.get;
622: p_errmsg := SUBSTR ( l_mesg_text ||
623: ',' || TO_CHAR (l_stmt_num) ||
624: ',' || '): ' || p_errcode ||
625: SQLERRM, 1, 4000);
622: p_errmsg := SUBSTR ( l_mesg_text ||
623: ',' || TO_CHAR (l_stmt_num) ||
624: ',' || '): ' || p_errcode ||
625: SQLERRM, 1, 4000);
626: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
627: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
628: l_mesg_text := fnd_message.get;
629: p_errmsg := SUBSTR ( l_mesg_text ||
630: AMS_Event_Objects_Copy_PVT.get_agenda_name (
623: ',' || TO_CHAR (l_stmt_num) ||
624: ',' || '): ' || p_errcode ||
625: SQLERRM, 1, 4000);
626: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
627: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
628: l_mesg_text := fnd_message.get;
629: p_errmsg := SUBSTR ( l_mesg_text ||
630: AMS_Event_Objects_Copy_PVT.get_agenda_name (
631: agenda_rec.parent_event_header_id
624: ',' || '): ' || p_errcode ||
625: SQLERRM, 1, 4000);
626: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
627: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
628: l_mesg_text := fnd_message.get;
629: p_errmsg := SUBSTR ( l_mesg_text ||
630: AMS_Event_Objects_Copy_PVT.get_agenda_name (
631: agenda_rec.parent_event_header_id
632: ) || p_errmsg, 1, 4000);
643: THEN
644: p_errcode := SQLCODE;
645: p_errnum := 4;
646: l_stmt_num := 5;
647: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
648: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
649: l_mesg_text := fnd_message.get;
650: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
651: ',' || '): ' || p_errcode || SQLERRM,
644: p_errcode := SQLCODE;
645: p_errnum := 4;
646: l_stmt_num := 5;
647: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
648: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
649: l_mesg_text := fnd_message.get;
650: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
651: ',' || '): ' || p_errcode || SQLERRM,
652: 1, 4000);
645: p_errnum := 4;
646: l_stmt_num := 5;
647: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
648: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
649: l_mesg_text := fnd_message.get;
650: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
651: ',' || '): ' || p_errcode || SQLERRM,
652: 1, 4000);
653: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,