DBA Data[Home] [Help]

APPS.AMS_EVENTSCHEDULE_COPY_PVT dependencies on FND_MESSAGE

Line 196: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');

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);

Line 197: fnd_message.set_token ('ELEMENTS','AMS_COPY_DELIVMETHODS', TRUE);

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,

Line 198: l_mesg_text := fnd_message.get;

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,

Line 381: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');

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,

Line 382: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);

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,

Line 383: l_mesg_text := fnd_message.get;

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'

Line 464: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');

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 || ' - ' ||

Line 465: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);

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 (

Line 466: l_mesg_text := fnd_message.get;

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

Line 483: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR');

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) ||

Line 484: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);

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 ||

Line 485: l_mesg_text := fnd_message.get;

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);

Line 490: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');

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 (

Line 491: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);

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

Line 492: l_mesg_text := fnd_message.get;

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);

Line 511: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');

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,

Line 512: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);

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);

Line 513: l_mesg_text := fnd_message.get;

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,

Line 593: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');

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,

Line 594: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);

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,

Line 596: l_mesg_text := fnd_message.get;

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'

Line 679: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');

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 || ' - ' ||

Line 680: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);

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 (

Line 681: l_mesg_text := fnd_message.get;

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

Line 762: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');

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 || ' - ' ||

Line 763: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);

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 (

Line 764: l_mesg_text := fnd_message.get;

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

Line 785: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR');

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) ||

Line 786: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);

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 ||

Line 787: l_mesg_text := fnd_message.get;

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);

Line 792: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');

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 (

Line 793: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);

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

Line 794: l_mesg_text := fnd_message.get;

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);

Line 813: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR3');

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,

Line 814: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);

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);

Line 815: l_mesg_text := fnd_message.get;

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,