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.

[Home] [Help]

APPS.RRS_IMPORT_INTERFACE_PKG dependencies on FND_MESSAGE

Line 312: fnd_message.set_name('RRS', 'RRS_IMP_SITE_DUP');

308: IF l_site_counts.count > 0 Then
309:
310: x_return_status := 'E';
311:
312: fnd_message.set_name('RRS', 'RRS_IMP_SITE_DUP');
313: fnd_message.set_token('NUM', l_site_counts(1).site_identification_number);
314: l_msg := fnd_message.get;
315:
316:

Line 313: fnd_message.set_token('NUM', l_site_counts(1).site_identification_number);

309:
310: x_return_status := 'E';
311:
312: fnd_message.set_name('RRS', 'RRS_IMP_SITE_DUP');
313: fnd_message.set_token('NUM', l_site_counts(1).site_identification_number);
314: l_msg := fnd_message.get;
315:
316:
317: prepare_error_mesg(

Line 314: l_msg := fnd_message.get;

310: x_return_status := 'E';
311:
312: fnd_message.set_name('RRS', 'RRS_IMP_SITE_DUP');
313: fnd_message.set_token('NUM', l_site_counts(1).site_identification_number);
314: l_msg := fnd_message.get;
315:
316:
317: prepare_error_mesg(
318: p_site_id => NULL

Line 638: fnd_message.set_name('RRS', 'RRS_IMP_SITE_EXIST');

634: -- dbms_output.put_line('Site Identification Number validation succeeded ');
635: elsif x_return_flag = 'E' then
636: l_row_status := 'E';
637:
638: fnd_message.set_name('RRS', 'RRS_IMP_SITE_EXIST');
639: l_msg := fnd_message.get;
640:
641: prepare_error_mesg(
642: p_site_id => NULL

Line 639: l_msg := fnd_message.get;

635: elsif x_return_flag = 'E' then
636: l_row_status := 'E';
637:
638: fnd_message.set_name('RRS', 'RRS_IMP_SITE_EXIST');
639: l_msg := fnd_message.get;
640:
641: prepare_error_mesg(
642: p_site_id => NULL
643: ,p_site_id_num => site_data.site_identification_number

Line 660: fnd_message.set_name('RRS', 'RRS_IMP_NAME_NULL');

656:
657: If site_data.site_name is NULL Then
658: l_row_status := 'E';
659:
660: fnd_message.set_name('RRS', 'RRS_IMP_NAME_NULL');
661: fnd_message.set_token('NUM', site_data.site_identification_number);
662: l_msg := fnd_message.get;
663:
664: prepare_error_mesg(

Line 661: fnd_message.set_token('NUM', site_data.site_identification_number);

657: If site_data.site_name is NULL Then
658: l_row_status := 'E';
659:
660: fnd_message.set_name('RRS', 'RRS_IMP_NAME_NULL');
661: fnd_message.set_token('NUM', site_data.site_identification_number);
662: l_msg := fnd_message.get;
663:
664: prepare_error_mesg(
665: p_site_id => NULL

Line 662: l_msg := fnd_message.get;

658: l_row_status := 'E';
659:
660: fnd_message.set_name('RRS', 'RRS_IMP_NAME_NULL');
661: fnd_message.set_token('NUM', site_data.site_identification_number);
662: l_msg := fnd_message.get;
663:
664: prepare_error_mesg(
665: p_site_id => NULL
666: ,p_site_id_num => site_data.site_identification_number

Line 692: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_STATUS');

688: -- dbms_output.put_line('Site status code validation succeeded ');
689: elsif x_return_flag = 'E' then
690: l_row_status := 'E';
691:
692: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_STATUS');
693: fnd_message.set_token('NUM', site_data.site_identification_number);
694: l_msg := fnd_message.get;
695:
696: prepare_error_mesg(

Line 693: fnd_message.set_token('NUM', site_data.site_identification_number);

689: elsif x_return_flag = 'E' then
690: l_row_status := 'E';
691:
692: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_STATUS');
693: fnd_message.set_token('NUM', site_data.site_identification_number);
694: l_msg := fnd_message.get;
695:
696: prepare_error_mesg(
697: p_site_id => NULL

Line 694: l_msg := fnd_message.get;

690: l_row_status := 'E';
691:
692: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_STATUS');
693: fnd_message.set_token('NUM', site_data.site_identification_number);
694: l_msg := fnd_message.get;
695:
696: prepare_error_mesg(
697: p_site_id => NULL
698: ,p_site_id_num => site_data.site_identification_number

Line 715: fnd_message.set_name('RRS', 'RRS_IMP_NULL_STATUS');

711:
712: else
713: l_row_status := 'E';
714:
715: fnd_message.set_name('RRS', 'RRS_IMP_NULL_STATUS');
716: fnd_message.set_token('NUM', site_data.site_identification_number);
717: l_msg := fnd_message.get;
718:
719: prepare_error_mesg(

Line 716: fnd_message.set_token('NUM', site_data.site_identification_number);

712: else
713: l_row_status := 'E';
714:
715: fnd_message.set_name('RRS', 'RRS_IMP_NULL_STATUS');
716: fnd_message.set_token('NUM', site_data.site_identification_number);
717: l_msg := fnd_message.get;
718:
719: prepare_error_mesg(
720: p_site_id => NULL

Line 717: l_msg := fnd_message.get;

713: l_row_status := 'E';
714:
715: fnd_message.set_name('RRS', 'RRS_IMP_NULL_STATUS');
716: fnd_message.set_token('NUM', site_data.site_identification_number);
717: l_msg := fnd_message.get;
718:
719: prepare_error_mesg(
720: p_site_id => NULL
721: ,p_site_id_num => site_data.site_identification_number

Line 750: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_BRAND');

746: -- dbms_output.put_line('Brandname code code validation succeeded ');
747: elsif x_return_flag = 'E' then
748: l_row_status := 'E';
749:
750: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_BRAND');
751: fnd_message.set_token('NUM', site_data.site_identification_number);
752: l_msg := fnd_message.get;
753:
754: prepare_error_mesg(

Line 751: fnd_message.set_token('NUM', site_data.site_identification_number);

747: elsif x_return_flag = 'E' then
748: l_row_status := 'E';
749:
750: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_BRAND');
751: fnd_message.set_token('NUM', site_data.site_identification_number);
752: l_msg := fnd_message.get;
753:
754: prepare_error_mesg(
755: p_site_id => NULL

Line 752: l_msg := fnd_message.get;

748: l_row_status := 'E';
749:
750: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_BRAND');
751: fnd_message.set_token('NUM', site_data.site_identification_number);
752: l_msg := fnd_message.get;
753:
754: prepare_error_mesg(
755: p_site_id => NULL
756: ,p_site_id_num => site_data.site_identification_number

Line 784: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_CAL');

780: -- dbms_output.put_line('Calendar code validation succeeded ');
781: elsif x_return_flag = 'E' then
782: l_row_status := 'E';
783:
784: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_CAL');
785: fnd_message.set_token('NUM', site_data.site_identification_number);
786: l_msg := fnd_message.get;
787:
788: prepare_error_mesg(

Line 785: fnd_message.set_token('NUM', site_data.site_identification_number);

781: elsif x_return_flag = 'E' then
782: l_row_status := 'E';
783:
784: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_CAL');
785: fnd_message.set_token('NUM', site_data.site_identification_number);
786: l_msg := fnd_message.get;
787:
788: prepare_error_mesg(
789: p_site_id => NULL

Line 786: l_msg := fnd_message.get;

782: l_row_status := 'E';
783:
784: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_CAL');
785: fnd_message.set_token('NUM', site_data.site_identification_number);
786: l_msg := fnd_message.get;
787:
788: prepare_error_mesg(
789: p_site_id => NULL
790: ,p_site_id_num => site_data.site_identification_number

Line 816: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_USE_CODE');

812: -- dbms_output.put_line('Site use type code validation succeeded ');
813: elsif x_return_flag = 'E' then
814: l_row_status := 'E';
815:
816: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_USE_CODE');
817: fnd_message.set_token('NUM', site_data.site_identification_number);
818: l_msg := fnd_message.get;
819:
820: prepare_error_mesg(

Line 817: fnd_message.set_token('NUM', site_data.site_identification_number);

813: elsif x_return_flag = 'E' then
814: l_row_status := 'E';
815:
816: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_USE_CODE');
817: fnd_message.set_token('NUM', site_data.site_identification_number);
818: l_msg := fnd_message.get;
819:
820: prepare_error_mesg(
821: p_site_id => NULL

Line 818: l_msg := fnd_message.get;

814: l_row_status := 'E';
815:
816: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_USE_CODE');
817: fnd_message.set_token('NUM', site_data.site_identification_number);
818: l_msg := fnd_message.get;
819:
820: prepare_error_mesg(
821: p_site_id => NULL
822: ,p_site_id_num => site_data.site_identification_number

Line 852: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_COUNTRY');

848: -- dbms_output.put_line('Country code validation succeeded ');
849: elsif x_return_flag = 'E' then
850: l_row_status := 'E';
851:
852: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_COUNTRY');
853: fnd_message.set_token('NUM', site_data.site_identification_number);
854: l_msg := fnd_message.get;
855:
856: prepare_error_mesg(

Line 853: fnd_message.set_token('NUM', site_data.site_identification_number);

849: elsif x_return_flag = 'E' then
850: l_row_status := 'E';
851:
852: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_COUNTRY');
853: fnd_message.set_token('NUM', site_data.site_identification_number);
854: l_msg := fnd_message.get;
855:
856: prepare_error_mesg(
857: p_site_id => NULL

Line 854: l_msg := fnd_message.get;

850: l_row_status := 'E';
851:
852: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_COUNTRY');
853: fnd_message.set_token('NUM', site_data.site_identification_number);
854: l_msg := fnd_message.get;
855:
856: prepare_error_mesg(
857: p_site_id => NULL
858: ,p_site_id_num => site_data.site_identification_number

Line 874: fnd_message.set_name('RRS', 'RRS_IMP_NULL_COUNTRY');

870: end if;
871: else
872: l_row_status := 'E';
873:
874: fnd_message.set_name('RRS', 'RRS_IMP_NULL_COUNTRY');
875: fnd_message.set_token('NUM', site_data.site_identification_number);
876: l_msg := fnd_message.get;
877:
878: prepare_error_mesg(

Line 875: fnd_message.set_token('NUM', site_data.site_identification_number);

871: else
872: l_row_status := 'E';
873:
874: fnd_message.set_name('RRS', 'RRS_IMP_NULL_COUNTRY');
875: fnd_message.set_token('NUM', site_data.site_identification_number);
876: l_msg := fnd_message.get;
877:
878: prepare_error_mesg(
879: p_site_id => NULL

Line 876: l_msg := fnd_message.get;

872: l_row_status := 'E';
873:
874: fnd_message.set_name('RRS', 'RRS_IMP_NULL_COUNTRY');
875: fnd_message.set_token('NUM', site_data.site_identification_number);
876: l_msg := fnd_message.get;
877:
878: prepare_error_mesg(
879: p_site_id => NULL
880: ,p_site_id_num => site_data.site_identification_number

Line 908: fnd_message.set_name('RRS', 'RRS_IMP_LOC_STATUS_INVALID');

904: -- dbms_output.put_line('Location ID validation succeeded 1');
905: elsif x_return_flag = 'E' then
906: l_row_status := 'E';
907:
908: fnd_message.set_name('RRS', 'RRS_IMP_LOC_STATUS_INVALID');
909: fnd_message.set_token('NUM', site_data.site_identification_number);
910: l_msg := fnd_message.get;
911:
912: prepare_error_mesg(

Line 909: fnd_message.set_token('NUM', site_data.site_identification_number);

905: elsif x_return_flag = 'E' then
906: l_row_status := 'E';
907:
908: fnd_message.set_name('RRS', 'RRS_IMP_LOC_STATUS_INVALID');
909: fnd_message.set_token('NUM', site_data.site_identification_number);
910: l_msg := fnd_message.get;
911:
912: prepare_error_mesg(
913: p_site_id => NULL

Line 910: l_msg := fnd_message.get;

906: l_row_status := 'E';
907:
908: fnd_message.set_name('RRS', 'RRS_IMP_LOC_STATUS_INVALID');
909: fnd_message.set_token('NUM', site_data.site_identification_number);
910: l_msg := fnd_message.get;
911:
912: prepare_error_mesg(
913: p_site_id => NULL
914: ,p_site_id_num => site_data.site_identification_number

Line 943: fnd_message.set_name('RRS', 'RRS_IMP_ADD_INVALID');

939: -- dbms_output.put_line('Location ID validation succeeded 2');
940: elsif x_return_flag = 'E' then
941: l_row_status := 'E';
942:
943: fnd_message.set_name('RRS', 'RRS_IMP_ADD_INVALID');
944: fnd_message.set_token('NUM', site_data.site_identification_number);
945: l_msg := fnd_message.get;
946:
947: prepare_error_mesg(

Line 944: fnd_message.set_token('NUM', site_data.site_identification_number);

940: elsif x_return_flag = 'E' then
941: l_row_status := 'E';
942:
943: fnd_message.set_name('RRS', 'RRS_IMP_ADD_INVALID');
944: fnd_message.set_token('NUM', site_data.site_identification_number);
945: l_msg := fnd_message.get;
946:
947: prepare_error_mesg(
948: p_site_id => NULL

Line 945: l_msg := fnd_message.get;

941: l_row_status := 'E';
942:
943: fnd_message.set_name('RRS', 'RRS_IMP_ADD_INVALID');
944: fnd_message.set_token('NUM', site_data.site_identification_number);
945: l_msg := fnd_message.get;
946:
947: prepare_error_mesg(
948: p_site_id => NULL
949: ,p_site_id_num => site_data.site_identification_number

Line 982: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_LOC_COMB');

978:
979: elsif x_return_flag = 'E' then
980: l_row_status := 'E';
981:
982: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_LOC_COMB');
983: fnd_message.set_token('NUM', site_data.site_identification_number);
984: l_msg := fnd_message.get;
985:
986: prepare_error_mesg(

Line 983: fnd_message.set_token('NUM', site_data.site_identification_number);

979: elsif x_return_flag = 'E' then
980: l_row_status := 'E';
981:
982: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_LOC_COMB');
983: fnd_message.set_token('NUM', site_data.site_identification_number);
984: l_msg := fnd_message.get;
985:
986: prepare_error_mesg(
987: p_site_id => NULL

Line 984: l_msg := fnd_message.get;

980: l_row_status := 'E';
981:
982: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_LOC_COMB');
983: fnd_message.set_token('NUM', site_data.site_identification_number);
984: l_msg := fnd_message.get;
985:
986: prepare_error_mesg(
987: p_site_id => NULL
988: ,p_site_id_num => site_data.site_identification_number

Line 1005: fnd_message.set_name('RRS', 'RRS_IMP_LOC_STATUS_INVALID');

1001:
1002: elsIf site_data.location_status = 'N' and site_data.location_id is NOT NULL Then
1003: l_row_status := 'E';
1004:
1005: fnd_message.set_name('RRS', 'RRS_IMP_LOC_STATUS_INVALID');
1006: fnd_message.set_token('NUM', site_data.site_identification_number);
1007: l_msg := fnd_message.get;
1008:
1009: prepare_error_mesg(

Line 1006: fnd_message.set_token('NUM', site_data.site_identification_number);

1002: elsIf site_data.location_status = 'N' and site_data.location_id is NOT NULL Then
1003: l_row_status := 'E';
1004:
1005: fnd_message.set_name('RRS', 'RRS_IMP_LOC_STATUS_INVALID');
1006: fnd_message.set_token('NUM', site_data.site_identification_number);
1007: l_msg := fnd_message.get;
1008:
1009: prepare_error_mesg(
1010: p_site_id => NULL

Line 1007: l_msg := fnd_message.get;

1003: l_row_status := 'E';
1004:
1005: fnd_message.set_name('RRS', 'RRS_IMP_LOC_STATUS_INVALID');
1006: fnd_message.set_token('NUM', site_data.site_identification_number);
1007: l_msg := fnd_message.get;
1008:
1009: prepare_error_mesg(
1010: p_site_id => NULL
1011: ,p_site_id_num => site_data.site_identification_number

Line 1027: fnd_message.set_name('RRS', 'RRS_IMP_ADD_INVALID');

1023:
1024: elsif site_data.location_status = 'N' and (site_data.address1 is NULL OR site_data.country is NULL) Then
1025: l_row_status := 'E';
1026:
1027: fnd_message.set_name('RRS', 'RRS_IMP_ADD_INVALID');
1028: fnd_message.set_token('NUM', site_data.site_identification_number);
1029: l_msg := fnd_message.get;
1030:
1031: prepare_error_mesg(

Line 1028: fnd_message.set_token('NUM', site_data.site_identification_number);

1024: elsif site_data.location_status = 'N' and (site_data.address1 is NULL OR site_data.country is NULL) Then
1025: l_row_status := 'E';
1026:
1027: fnd_message.set_name('RRS', 'RRS_IMP_ADD_INVALID');
1028: fnd_message.set_token('NUM', site_data.site_identification_number);
1029: l_msg := fnd_message.get;
1030:
1031: prepare_error_mesg(
1032: p_site_id => NULL

Line 1029: l_msg := fnd_message.get;

1025: l_row_status := 'E';
1026:
1027: fnd_message.set_name('RRS', 'RRS_IMP_ADD_INVALID');
1028: fnd_message.set_token('NUM', site_data.site_identification_number);
1029: l_msg := fnd_message.get;
1030:
1031: prepare_error_mesg(
1032: p_site_id => NULL
1033: ,p_site_id_num => site_data.site_identification_number

Line 1048: fnd_message.set_name('RRS', 'RRS_IMP_LOC_INVALID');

1044: );
1045: else
1046: l_row_status := 'E';
1047:
1048: fnd_message.set_name('RRS', 'RRS_IMP_LOC_INVALID');
1049: fnd_message.set_token('NUM', site_data.site_identification_number);
1050: l_msg := fnd_message.get;
1051:
1052: prepare_error_mesg(

Line 1049: fnd_message.set_token('NUM', site_data.site_identification_number);

1045: else
1046: l_row_status := 'E';
1047:
1048: fnd_message.set_name('RRS', 'RRS_IMP_LOC_INVALID');
1049: fnd_message.set_token('NUM', site_data.site_identification_number);
1050: l_msg := fnd_message.get;
1051:
1052: prepare_error_mesg(
1053: p_site_id => NULL

Line 1050: l_msg := fnd_message.get;

1046: l_row_status := 'E';
1047:
1048: fnd_message.set_name('RRS', 'RRS_IMP_LOC_INVALID');
1049: fnd_message.set_token('NUM', site_data.site_identification_number);
1050: l_msg := fnd_message.get;
1051:
1052: prepare_error_mesg(
1053: p_site_id => NULL
1054: ,p_site_id_num => site_data.site_identification_number

Line 1074: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_LONG_LAT');

1070: ( site_data.LONGITUDE is NULL and site_data.LATITUDE is NOT NULL )) Then
1071:
1072: l_row_status := 'E';
1073:
1074: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_LONG_LAT');
1075: fnd_message.set_token('NUM', site_data.site_identification_number);
1076: l_msg := fnd_message.get;
1077:
1078: prepare_error_mesg(

Line 1075: fnd_message.set_token('NUM', site_data.site_identification_number);

1071:
1072: l_row_status := 'E';
1073:
1074: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_LONG_LAT');
1075: fnd_message.set_token('NUM', site_data.site_identification_number);
1076: l_msg := fnd_message.get;
1077:
1078: prepare_error_mesg(
1079: p_site_id => NULL

Line 1076: l_msg := fnd_message.get;

1072: l_row_status := 'E';
1073:
1074: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_LONG_LAT');
1075: fnd_message.set_token('NUM', site_data.site_identification_number);
1076: l_msg := fnd_message.get;
1077:
1078: prepare_error_mesg(
1079: p_site_id => NULL
1080: ,p_site_id_num => site_data.site_identification_number

Line 1097: fnd_message.set_name('RRS', 'RRS_IMP_LONG_RANGE');

1093: elsif ( site_data.LONGITUDE is NOT NULL AND site_data.LATITUDE is NOT NULL ) then
1094: if (site_data.Longitude < -180 OR site_data.Longitude > 180 ) then
1095: l_row_status := 'E';
1096:
1097: fnd_message.set_name('RRS', 'RRS_IMP_LONG_RANGE');
1098: fnd_message.set_token('NUM', site_data.site_identification_number);
1099: l_msg := fnd_message.get;
1100:
1101: prepare_error_mesg(

Line 1098: fnd_message.set_token('NUM', site_data.site_identification_number);

1094: if (site_data.Longitude < -180 OR site_data.Longitude > 180 ) then
1095: l_row_status := 'E';
1096:
1097: fnd_message.set_name('RRS', 'RRS_IMP_LONG_RANGE');
1098: fnd_message.set_token('NUM', site_data.site_identification_number);
1099: l_msg := fnd_message.get;
1100:
1101: prepare_error_mesg(
1102: p_site_id => NULL

Line 1099: l_msg := fnd_message.get;

1095: l_row_status := 'E';
1096:
1097: fnd_message.set_name('RRS', 'RRS_IMP_LONG_RANGE');
1098: fnd_message.set_token('NUM', site_data.site_identification_number);
1099: l_msg := fnd_message.get;
1100:
1101: prepare_error_mesg(
1102: p_site_id => NULL
1103: ,p_site_id_num => site_data.site_identification_number

Line 1119: fnd_message.set_name('RRS', 'RRS_IMP_LAT_RANGE');

1115:
1116: elsif ( site_data.latitude < -90 OR site_data.latitude > 90 ) then
1117: l_row_status := 'E';
1118:
1119: fnd_message.set_name('RRS', 'RRS_IMP_LAT_RANGE');
1120: fnd_message.set_token('NUM', site_data.site_identification_number);
1121: l_msg := fnd_message.get;
1122:
1123: prepare_error_mesg(

Line 1120: fnd_message.set_token('NUM', site_data.site_identification_number);

1116: elsif ( site_data.latitude < -90 OR site_data.latitude > 90 ) then
1117: l_row_status := 'E';
1118:
1119: fnd_message.set_name('RRS', 'RRS_IMP_LAT_RANGE');
1120: fnd_message.set_token('NUM', site_data.site_identification_number);
1121: l_msg := fnd_message.get;
1122:
1123: prepare_error_mesg(
1124: p_site_id => NULL

Line 1121: l_msg := fnd_message.get;

1117: l_row_status := 'E';
1118:
1119: fnd_message.set_name('RRS', 'RRS_IMP_LAT_RANGE');
1120: fnd_message.set_token('NUM', site_data.site_identification_number);
1121: l_msg := fnd_message.get;
1122:
1123: prepare_error_mesg(
1124: p_site_id => NULL
1125: ,p_site_id_num => site_data.site_identification_number

Line 1155: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_GEO_SRC');

1151: -- dbms_output.put_line('Site use type code validation succeeded ');
1152: elsif x_return_flag = 'E' then
1153: l_row_status := 'E';
1154:
1155: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_GEO_SRC');
1156: fnd_message.set_token('NUM', site_data.site_identification_number);
1157: l_msg := fnd_message.get;
1158:
1159: prepare_error_mesg(

Line 1156: fnd_message.set_token('NUM', site_data.site_identification_number);

1152: elsif x_return_flag = 'E' then
1153: l_row_status := 'E';
1154:
1155: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_GEO_SRC');
1156: fnd_message.set_token('NUM', site_data.site_identification_number);
1157: l_msg := fnd_message.get;
1158:
1159: prepare_error_mesg(
1160: p_site_id => NULL

Line 1157: l_msg := fnd_message.get;

1153: l_row_status := 'E';
1154:
1155: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_GEO_SRC');
1156: fnd_message.set_token('NUM', site_data.site_identification_number);
1157: l_msg := fnd_message.get;
1158:
1159: prepare_error_mesg(
1160: p_site_id => NULL
1161: ,p_site_id_num => site_data.site_identification_number

Line 1218: fnd_message.set_name('RRS', 'RRS_IMP_GEO_SRC');

1214:
1215: elsif site_data.GEOMETRY_SOURCE = 'RRS_GOOGLE' and site_data.LONGITUDE is NOT NULL and site_data.LATITUDE is NOT NULL then
1216: l_row_status := 'E';
1217:
1218: fnd_message.set_name('RRS', 'RRS_IMP_GEO_SRC');
1219: fnd_message.set_token('NUM', site_data.site_identification_number);
1220: l_msg := fnd_message.get;
1221:
1222: prepare_error_mesg(

Line 1219: fnd_message.set_token('NUM', site_data.site_identification_number);

1215: elsif site_data.GEOMETRY_SOURCE = 'RRS_GOOGLE' and site_data.LONGITUDE is NOT NULL and site_data.LATITUDE is NOT NULL then
1216: l_row_status := 'E';
1217:
1218: fnd_message.set_name('RRS', 'RRS_IMP_GEO_SRC');
1219: fnd_message.set_token('NUM', site_data.site_identification_number);
1220: l_msg := fnd_message.get;
1221:
1222: prepare_error_mesg(
1223: p_site_id => NULL

Line 1220: l_msg := fnd_message.get;

1216: l_row_status := 'E';
1217:
1218: fnd_message.set_name('RRS', 'RRS_IMP_GEO_SRC');
1219: fnd_message.set_token('NUM', site_data.site_identification_number);
1220: l_msg := fnd_message.get;
1221:
1222: prepare_error_mesg(
1223: p_site_id => NULL
1224: ,p_site_id_num => site_data.site_identification_number

Line 1242: fnd_message.set_name('RRS', 'RRS_IMP_NULL_TYPE');

1238:
1239: If site_data.site_type_code is NULL then
1240: l_row_status := 'E';
1241:
1242: fnd_message.set_name('RRS', 'RRS_IMP_NULL_TYPE');
1243: fnd_message.set_token('NUM', site_data.site_identification_number);
1244: l_msg := fnd_message.get;
1245:
1246: prepare_error_mesg(

Line 1243: fnd_message.set_token('NUM', site_data.site_identification_number);

1239: If site_data.site_type_code is NULL then
1240: l_row_status := 'E';
1241:
1242: fnd_message.set_name('RRS', 'RRS_IMP_NULL_TYPE');
1243: fnd_message.set_token('NUM', site_data.site_identification_number);
1244: l_msg := fnd_message.get;
1245:
1246: prepare_error_mesg(
1247: p_site_id => NULL

Line 1244: l_msg := fnd_message.get;

1240: l_row_status := 'E';
1241:
1242: fnd_message.set_name('RRS', 'RRS_IMP_NULL_TYPE');
1243: fnd_message.set_token('NUM', site_data.site_identification_number);
1244: l_msg := fnd_message.get;
1245:
1246: prepare_error_mesg(
1247: p_site_id => NULL
1248: ,p_site_id_num => site_data.site_identification_number

Line 1273: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_TYPE');

1269: -- dbms_output.put_line('Site type code validation succeeded ');
1270: elsif x_return_flag = 'E' then
1271: l_row_status := 'E';
1272:
1273: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_TYPE');
1274: fnd_message.set_token('NUM', site_data.site_identification_number);
1275: l_msg := fnd_message.get;
1276:
1277: prepare_error_mesg(

Line 1274: fnd_message.set_token('NUM', site_data.site_identification_number);

1270: elsif x_return_flag = 'E' then
1271: l_row_status := 'E';
1272:
1273: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_TYPE');
1274: fnd_message.set_token('NUM', site_data.site_identification_number);
1275: l_msg := fnd_message.get;
1276:
1277: prepare_error_mesg(
1278: p_site_id => NULL

Line 1275: l_msg := fnd_message.get;

1271: l_row_status := 'E';
1272:
1273: fnd_message.set_name('RRS', 'RRS_IMP_INVALID_TYPE');
1274: fnd_message.set_token('NUM', site_data.site_identification_number);
1275: l_msg := fnd_message.get;
1276:
1277: prepare_error_mesg(
1278: p_site_id => NULL
1279: ,p_site_id_num => site_data.site_identification_number