192: THEN
193: p_errcode := SQLCODE;
194: p_errnum := 4;
195: l_stmt_num := 5;
196: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
197: fnd_message.set_token ('ELEMENTS','AMS_COPY_DELIVMETHODS', TRUE);
198: l_mesg_text := fnd_message.get;
199: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
200: ',' || '): ' || p_errcode || SQLERRM, 1, 4000);
193: p_errcode := SQLCODE;
194: p_errnum := 4;
195: l_stmt_num := 5;
196: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
197: fnd_message.set_token ('ELEMENTS','AMS_COPY_DELIVMETHODS', TRUE);
198: l_mesg_text := fnd_message.get;
199: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
200: ',' || '): ' || p_errcode || SQLERRM, 1, 4000);
201: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
194: p_errnum := 4;
195: l_stmt_num := 5;
196: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
197: fnd_message.set_token ('ELEMENTS','AMS_COPY_DELIVMETHODS', TRUE);
198: l_mesg_text := fnd_message.get;
199: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
200: ',' || '): ' || p_errcode || SQLERRM, 1, 4000);
201: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
202: p_src_act_id,
377: 'AGEN',
378: l_return_status,
379: l_lookup_meaning
380: );
381: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
382: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
383: l_mesg_text := fnd_message.get;
384: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
385: p_src_act_id,
378: l_return_status,
379: l_lookup_meaning
380: );
381: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
382: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
383: l_mesg_text := fnd_message.get;
384: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
385: p_src_act_id,
386: l_mesg_text,
379: l_lookup_meaning
380: );
381: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
382: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
383: l_mesg_text := fnd_message.get;
384: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
385: p_src_act_id,
386: l_mesg_text,
387: 'GENERAL'
460: p_errmsg,
461: 'ERROR'
462: );
463: END LOOP;
464: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
465: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
466: l_mesg_text := fnd_message.get;
467:
468: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
461: 'ERROR'
462: );
463: END LOOP;
464: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
465: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
466: l_mesg_text := fnd_message.get;
467:
468: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
469: AMS_EventSchedule_Copy_PVT.get_agenda_name (
462: );
463: END LOOP;
464: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
465: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
466: l_mesg_text := fnd_message.get;
467:
468: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
469: AMS_EventSchedule_Copy_PVT.get_agenda_name (
470: agenda_rec.parent_event_offer_id
479: WHEN OTHERS THEN
480: p_errcode := SQLCODE;
481: p_errnum := 3;
482: l_stmt_num := 4;
483: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR');
484: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
485: l_mesg_text := fnd_message.get;
486: p_errmsg := SUBSTR ( l_mesg_text ||
487: ',' || TO_CHAR (l_stmt_num) ||
480: p_errcode := SQLCODE;
481: p_errnum := 3;
482: l_stmt_num := 4;
483: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR');
484: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
485: l_mesg_text := fnd_message.get;
486: p_errmsg := SUBSTR ( l_mesg_text ||
487: ',' || TO_CHAR (l_stmt_num) ||
488: ',' || '): ' || p_errcode ||
481: p_errnum := 3;
482: l_stmt_num := 4;
483: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR');
484: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
485: l_mesg_text := fnd_message.get;
486: p_errmsg := SUBSTR ( l_mesg_text ||
487: ',' || TO_CHAR (l_stmt_num) ||
488: ',' || '): ' || p_errcode ||
489: SQLERRM, 1, 4000);
486: p_errmsg := SUBSTR ( l_mesg_text ||
487: ',' || TO_CHAR (l_stmt_num) ||
488: ',' || '): ' || p_errcode ||
489: SQLERRM, 1, 4000);
490: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
491: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
492: l_mesg_text := fnd_message.get;
493: p_errmsg := SUBSTR ( l_mesg_text ||
494: AMS_EventSchedule_Copy_PVT.get_agenda_name (
487: ',' || TO_CHAR (l_stmt_num) ||
488: ',' || '): ' || p_errcode ||
489: SQLERRM, 1, 4000);
490: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
491: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
492: l_mesg_text := fnd_message.get;
493: p_errmsg := SUBSTR ( l_mesg_text ||
494: AMS_EventSchedule_Copy_PVT.get_agenda_name (
495: agenda_rec.parent_event_offer_id
488: ',' || '): ' || p_errcode ||
489: SQLERRM, 1, 4000);
490: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
491: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
492: l_mesg_text := fnd_message.get;
493: p_errmsg := SUBSTR ( l_mesg_text ||
494: AMS_EventSchedule_Copy_PVT.get_agenda_name (
495: agenda_rec.parent_event_offer_id
496: ) || p_errmsg, 1, 4000);
507: THEN
508: p_errcode := SQLCODE;
509: p_errnum := 4;
510: l_stmt_num := 5;
511: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
512: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
513: l_mesg_text := fnd_message.get;
514: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
515: ',' || '): ' || p_errcode || SQLERRM,
508: p_errcode := SQLCODE;
509: p_errnum := 4;
510: l_stmt_num := 5;
511: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
512: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
513: l_mesg_text := fnd_message.get;
514: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
515: ',' || '): ' || p_errcode || SQLERRM,
516: 1, 4000);
509: p_errnum := 4;
510: l_stmt_num := 5;
511: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
512: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
513: l_mesg_text := fnd_message.get;
514: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
515: ',' || '): ' || p_errcode || SQLERRM,
516: 1, 4000);
517: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
589: l_return_status,
590: l_lookup_meaning
591: );
592:
593: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
594: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
595:
596: l_mesg_text := fnd_message.get;
597: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
590: l_lookup_meaning
591: );
592:
593: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
594: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
595:
596: l_mesg_text := fnd_message.get;
597: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
598: p_src_act_id,
592:
593: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
594: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
595:
596: l_mesg_text := fnd_message.get;
597: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
598: p_src_act_id,
599: l_mesg_text,
600: 'GENERAL'
675: 'ERROR'
676: );
677: END LOOP;
678:
679: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
680: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
681: l_mesg_text := fnd_message.get;
682:
683: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
676: );
677: END LOOP;
678:
679: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
680: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
681: l_mesg_text := fnd_message.get;
682:
683: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
684: AMS_EventSchedule_Copy_PVT.get_agenda_name (
677: END LOOP;
678:
679: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
680: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
681: l_mesg_text := fnd_message.get;
682:
683: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
684: AMS_EventSchedule_Copy_PVT.get_agenda_name (
685: l_track_cur.agenda_id
758: 'ERROR'
759: );
760: END LOOP;
761:
762: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
763: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
764: l_mesg_text := fnd_message.get;
765:
766: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
759: );
760: END LOOP;
761:
762: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
763: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
764: l_mesg_text := fnd_message.get;
765:
766: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
767: AMS_EventSchedule_Copy_PVT.get_agenda_name (
760: END LOOP;
761:
762: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
763: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
764: l_mesg_text := fnd_message.get;
765:
766: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
767: AMS_EventSchedule_Copy_PVT.get_agenda_name (
768: l_session_cur.agenda_id
781: WHEN OTHERS THEN
782: p_errcode := SQLCODE;
783: p_errnum := 3;
784: l_stmt_num := 4;
785: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR');
786: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
787: l_mesg_text := fnd_message.get;
788: p_errmsg := SUBSTR ( l_mesg_text ||
789: ',' || TO_CHAR (l_stmt_num) ||
782: p_errcode := SQLCODE;
783: p_errnum := 3;
784: l_stmt_num := 4;
785: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR');
786: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
787: l_mesg_text := fnd_message.get;
788: p_errmsg := SUBSTR ( l_mesg_text ||
789: ',' || TO_CHAR (l_stmt_num) ||
790: ',' || '): ' || p_errcode ||
783: p_errnum := 3;
784: l_stmt_num := 4;
785: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR');
786: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
787: l_mesg_text := fnd_message.get;
788: p_errmsg := SUBSTR ( l_mesg_text ||
789: ',' || TO_CHAR (l_stmt_num) ||
790: ',' || '): ' || p_errcode ||
791: SQLERRM, 1, 4000);
788: p_errmsg := SUBSTR ( l_mesg_text ||
789: ',' || TO_CHAR (l_stmt_num) ||
790: ',' || '): ' || p_errcode ||
791: SQLERRM, 1, 4000);
792: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
793: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
794: l_mesg_text := fnd_message.get;
795: p_errmsg := SUBSTR ( l_mesg_text ||
796: AMS_EventSchedule_Copy_PVT.get_agenda_name (
789: ',' || TO_CHAR (l_stmt_num) ||
790: ',' || '): ' || p_errcode ||
791: SQLERRM, 1, 4000);
792: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
793: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
794: l_mesg_text := fnd_message.get;
795: p_errmsg := SUBSTR ( l_mesg_text ||
796: AMS_EventSchedule_Copy_PVT.get_agenda_name (
797: l_new_track_cur.agenda_id
790: ',' || '): ' || p_errcode ||
791: SQLERRM, 1, 4000);
792: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
793: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
794: l_mesg_text := fnd_message.get;
795: p_errmsg := SUBSTR ( l_mesg_text ||
796: AMS_EventSchedule_Copy_PVT.get_agenda_name (
797: l_new_track_cur.agenda_id
798: ) || p_errmsg, 1, 4000);
809: THEN
810: p_errcode := SQLCODE;
811: p_errnum := 4;
812: l_stmt_num := 5;
813: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
814: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
815: l_mesg_text := fnd_message.get;
816: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
817: ',' || '): ' || p_errcode || SQLERRM,
810: p_errcode := SQLCODE;
811: p_errnum := 4;
812: l_stmt_num := 5;
813: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
814: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
815: l_mesg_text := fnd_message.get;
816: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
817: ',' || '): ' || p_errcode || SQLERRM,
818: 1, 4000);
811: p_errnum := 4;
812: l_stmt_num := 5;
813: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');
814: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
815: l_mesg_text := fnd_message.get;
816: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
817: ',' || '): ' || p_errcode || SQLERRM,
818: 1, 4000);
819: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,