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.IGS_AD_IMP_008 dependencies on IGS_AD_RELADDR_INT_ALL

Line 710: FROM igs_ad_reladdr_int_all

706:
707: --1. Pick up all the records from the table IGS_AD_RELADDR_INT
708: CURSOR reladdr_rec_c( cp_Interface_Relations_Id NUMBER ) IS
709: SELECT *
710: FROM igs_ad_reladdr_int_all
711: WHERE status = '2'
712: AND interface_relations_id = cp_interface_relations_id;
713:
714: --3. Validate to see if this address already exist for this person.

Line 849: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E014','IGS_AD_RELADDR_INT_ALL');

845:
846: IF l_return_status IN ('E','U') THEN
847: l_flag_check_status := 'N';
848: IF l_enable_log = 'Y' THEN
849: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E014','IGS_AD_RELADDR_INT_ALL');
850: END IF;
851: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
852: IF (l_request_id IS NULL) THEN
853: l_request_id := fnd_global.conc_request_id;

Line 868: UPDATE Igs_Ad_RelAddr_Int_all

864: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
865: );
866: END IF;
867:
868: UPDATE Igs_Ad_RelAddr_Int_all
869: SET Error_Code = 'E014',
870: Status = '3'
871: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;
872: ELSIF l_return_status = 'W' THEN

Line 875: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E073','IGS_AD_RELADDR_INT_ALL');

871: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;
872: ELSIF l_return_status = 'W' THEN
873: l_addr_warning := 'Y';
874: IF l_enable_log = 'Y' THEN
875: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E073','IGS_AD_RELADDR_INT_ALL');
876: END IF;
877: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
878: IF (l_request_id IS NULL) THEN
879: l_request_id := fnd_global.conc_request_id;

Line 894: UPDATE Igs_Ad_RelAddr_Int_all

890: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
891: );
892: END IF;
893:
894: UPDATE Igs_Ad_RelAddr_Int_all
895: SET Error_Code = 'E073',
896: Status = '4'
897: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;
898: END IF;

Line 941: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E244','IGS_AD_RELADDR_INT_ALL');

937: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
938: );
939: END IF;
940: IF l_enable_log = 'Y' THEN
941: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E244','IGS_AD_RELADDR_INT_ALL');
942: END IF;
943: UPDATE Igs_Ad_RelAddr_Int_all
944: SET Error_Code = 'E244',
945: Status = '3'

Line 943: UPDATE Igs_Ad_RelAddr_Int_all

939: END IF;
940: IF l_enable_log = 'Y' THEN
941: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E244','IGS_AD_RELADDR_INT_ALL');
942: END IF;
943: UPDATE Igs_Ad_RelAddr_Int_all
944: SET Error_Code = 'E244',
945: Status = '3'
946: WHERE INTERFACE_RELADDR_ID = reladdr_rec.INTERFACE_RELADDR_ID;
947: END IF;

Line 994: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E244','IGS_AD_RELADDR_INT_ALL');

990: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
991: );
992: END IF;
993: IF l_enable_log = 'Y' THEN
994: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E244','IGS_AD_RELADDR_INT_ALL');
995: END IF;
996: UPDATE Igs_Ad_RelAddr_Int_all
997: SET Error_Code = 'E244',
998: Status = l_Status

Line 996: UPDATE Igs_Ad_RelAddr_Int_all

992: END IF;
993: IF l_enable_log = 'Y' THEN
994: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E244','IGS_AD_RELADDR_INT_ALL');
995: END IF;
996: UPDATE Igs_Ad_RelAddr_Int_all
997: SET Error_Code = 'E244',
998: Status = l_Status
999: WHERE INTERFACE_RELADDR_ID = reladdr_rec.INTERFACE_RELADDR_ID;
1000: END IF;

Line 1006: UPDATE igs_ad_reladdr_int_all

1002: CLOSE site_c;
1003: END IF;
1004:
1005: IF l_flag_check_status = 'Y' AND l_addr_warning = 'N' THEN
1006: UPDATE igs_ad_reladdr_int_all
1007: SET error_code = NULL,
1008: match_ind = '18',
1009: status = '1'
1010: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;

Line 1035: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E014','IGS_AD_RELADDR_INT_ALL');

1031: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
1032: );
1033: END IF;
1034: IF l_enable_log = 'Y' THEN
1035: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E014','IGS_AD_RELADDR_INT_ALL');
1036: END IF;
1037:
1038: UPDATE Igs_Ad_RelAddr_Int_all
1039: SET Error_Code = 'E014',

Line 1038: UPDATE Igs_Ad_RelAddr_Int_all

1034: IF l_enable_log = 'Y' THEN
1035: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E014','IGS_AD_RELADDR_INT_ALL');
1036: END IF;
1037:
1038: UPDATE Igs_Ad_RelAddr_Int_all
1039: SET Error_Code = 'E014',
1040: Status = '3'
1041: WHERE Interface_Reladdr_Id = reladdr_rec.Interface_Reladdr_Id;
1042: END Update_Addr;

Line 1064: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E211','IGS_AD_RELADDR_INT_ALL');

1060: l_Status := '3';
1061: IF (reladdr_rec.site_use_code_1 IS NOT NULL) THEN
1062: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('PARTY_SITE_USE_CODE',reladdr_rec.site_use_code_1,222)) THEN
1063: IF l_enable_log = 'Y' THEN
1064: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E211','IGS_AD_RELADDR_INT_ALL');
1065: END IF;
1066:
1067: UPDATE igs_ad_reladdr_int_all
1068: SET error_code = 'E211', status = '3'

Line 1067: UPDATE igs_ad_reladdr_int_all

1063: IF l_enable_log = 'Y' THEN
1064: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E211','IGS_AD_RELADDR_INT_ALL');
1065: END IF;
1066:
1067: UPDATE igs_ad_reladdr_int_all
1068: SET error_code = 'E211', status = '3'
1069: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;
1070:
1071: l_check := 'TRUE';

Line 1079: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E211','IGS_AD_RELADDR_INT_ALL');

1075:
1076: IF (reladdr_rec.site_use_code_2 IS NOT NULL) THEN
1077: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('PARTY_SITE_USE_CODE',reladdr_rec.site_use_code_2,222)) THEN
1078: IF l_enable_log = 'Y' THEN
1079: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E211','IGS_AD_RELADDR_INT_ALL');
1080: END IF;
1081: UPDATE igs_ad_reladdr_int_all
1082: SET error_code = 'E211', status = '3'
1083: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;

Line 1081: UPDATE igs_ad_reladdr_int_all

1077: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('PARTY_SITE_USE_CODE',reladdr_rec.site_use_code_2,222)) THEN
1078: IF l_enable_log = 'Y' THEN
1079: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E211','IGS_AD_RELADDR_INT_ALL');
1080: END IF;
1081: UPDATE igs_ad_reladdr_int_all
1082: SET error_code = 'E211', status = '3'
1083: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;
1084: l_Check:='TRUE';
1085: RETURN;

Line 1092: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E449','IGS_AD_RELADDR_INT_ALL');

1088: -- Also site_use_code_1 should not be the same as site_use_code_2.
1089: IF (reladdr_rec.site_use_code_1 IS NOT NULL AND reladdr_rec.site_use_code_2 IS NOT NULL) THEN
1090: IF reladdr_rec.site_use_code_1 = reladdr_rec.site_use_code_2 THEN
1091: IF l_enable_log = 'Y' THEN
1092: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E449','IGS_AD_RELADDR_INT_ALL');
1093: END IF;
1094:
1095: UPDATE igs_ad_reladdr_int_all
1096: SET error_code = 'E449', status = '3'

Line 1095: UPDATE igs_ad_reladdr_int_all

1091: IF l_enable_log = 'Y' THEN
1092: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E449','IGS_AD_RELADDR_INT_ALL');
1093: END IF;
1094:
1095: UPDATE igs_ad_reladdr_int_all
1096: SET error_code = 'E449', status = '3'
1097: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;
1098:
1099: l_Check:='TRUE';

Line 1109: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E209','IGS_AD_RELADDR_INT_ALL');

1105: OPEN terr_name_cur(reladdr_rec.country);
1106: FETCH terr_name_cur INTO l_territory_short_name ;
1107: IF terr_name_cur%NOTFOUND THEN
1108: IF l_enable_log = 'Y' THEN
1109: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E209','IGS_AD_RELADDR_INT_ALL');
1110: END IF;
1111:
1112: UPDATE igs_ad_reladdr_int_all
1113: SET error_code = 'E209', status = '3'

Line 1112: UPDATE igs_ad_reladdr_int_all

1108: IF l_enable_log = 'Y' THEN
1109: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E209','IGS_AD_RELADDR_INT_ALL');
1110: END IF;
1111:
1112: UPDATE igs_ad_reladdr_int_all
1113: SET error_code = 'E209', status = '3'
1114: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;
1115: l_check := 'TRUE';
1116: CLOSE terr_name_cur;

Line 1124: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E213','IGS_AD_RELADDR_INT_ALL');

1120:
1121: IF reladdr_rec.correspondence IS NOT NULL THEN
1122: IF reladdr_rec.correspondence NOT IN ('Y','N') THEN
1123: IF l_enable_log = 'Y' THEN
1124: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E213','IGS_AD_RELADDR_INT_ALL');
1125: END IF;
1126:
1127: UPDATE igs_ad_reladdr_int_all
1128: SET error_code = 'E213', status = '3'

Line 1127: UPDATE igs_ad_reladdr_int_all

1123: IF l_enable_log = 'Y' THEN
1124: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E213','IGS_AD_RELADDR_INT_ALL');
1125: END IF;
1126:
1127: UPDATE igs_ad_reladdr_int_all
1128: SET error_code = 'E213', status = '3'
1129: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;
1130:
1131: l_Check:='TRUE';

Line 1138: igs_ad_imp_001.logerrormessage( reladdr_rec.interface_reladdr_id,'E407','IGS_AD_RELADDR_INT_ALL');

1134: END IF;
1135:
1136: IF reladdr_rec.start_dt IS NULL AND reladdr_rec.end_dt IS NOT NULL THEN
1137: IF l_enable_log = 'Y' THEN
1138: igs_ad_imp_001.logerrormessage( reladdr_rec.interface_reladdr_id,'E407','IGS_AD_RELADDR_INT_ALL');
1139: END IF;
1140:
1141: UPDATE igs_ad_reladdr_int_all
1142: SET error_code = 'E407', status = '3'

Line 1141: UPDATE igs_ad_reladdr_int_all

1137: IF l_enable_log = 'Y' THEN
1138: igs_ad_imp_001.logerrormessage( reladdr_rec.interface_reladdr_id,'E407','IGS_AD_RELADDR_INT_ALL');
1139: END IF;
1140:
1141: UPDATE igs_ad_reladdr_int_all
1142: SET error_code = 'E407', status = '3'
1143: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;
1144: l_Check:='TRUE';
1145: RETURN;

Line 1151: igs_ad_imp_001.logerrormessage( reladdr_rec.interface_reladdr_id,'E406','IGS_AD_RELADDR_INT_ALL');

1147:
1148: IF reladdr_rec.start_dt IS NOT NULL AND reladdr_rec.end_dt IS NOT NULL THEN
1149: IF reladdr_rec.start_dt > reladdr_rec.end_dt THEN
1150: IF l_enable_log = 'Y' THEN
1151: igs_ad_imp_001.logerrormessage( reladdr_rec.interface_reladdr_id,'E406','IGS_AD_RELADDR_INT_ALL');
1152: END IF;
1153:
1154: UPDATE igs_ad_reladdr_int_all
1155: SET error_code = 'E406', status = '3'

Line 1154: UPDATE igs_ad_reladdr_int_all

1150: IF l_enable_log = 'Y' THEN
1151: igs_ad_imp_001.logerrormessage( reladdr_rec.interface_reladdr_id,'E406','IGS_AD_RELADDR_INT_ALL');
1152: END IF;
1153:
1154: UPDATE igs_ad_reladdr_int_all
1155: SET error_code = 'E406', status = '3'
1156: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;
1157:
1158: l_Check:='TRUE';

Line 1171: igs_ad_imp_001.logerrormessage( reladdr_rec.interface_reladdr_id,'E222','IGS_AD_RELADDR_INT_ALL');

1167: -- start date must be greater than birth date
1168: IF l_birth_date IS NOT NULL THEN
1169: IF reladdr_rec.start_dt < l_birth_date THEN
1170: IF l_enable_log = 'Y' THEN
1171: igs_ad_imp_001.logerrormessage( reladdr_rec.interface_reladdr_id,'E222','IGS_AD_RELADDR_INT_ALL');
1172: END IF;
1173: UPDATE igs_ad_reladdr_int_all
1174: SET error_code = 'E222', status = '3'
1175: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;

Line 1173: UPDATE igs_ad_reladdr_int_all

1169: IF reladdr_rec.start_dt < l_birth_date THEN
1170: IF l_enable_log = 'Y' THEN
1171: igs_ad_imp_001.logerrormessage( reladdr_rec.interface_reladdr_id,'E222','IGS_AD_RELADDR_INT_ALL');
1172: END IF;
1173: UPDATE igs_ad_reladdr_int_all
1174: SET error_code = 'E222', status = '3'
1175: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;
1176: l_check := 'TRUE';
1177: RETURN;

Line 1214: UPDATE Igs_Ad_RelAddr_Int_all

1210:
1211: l_rule := Igs_Ad_Imp_001.Find_Source_Cat_Rule(p_source_type_id,'RELATIONS_ADDRESS');
1212: --1. If rule is E or I, then if the match_ind is not null, the combination is invalid
1213: IF l_rule IN ('E','I') THEN
1214: UPDATE Igs_Ad_RelAddr_Int_all
1215: SET status = '3',
1216: ERROR_CODE = 'E695' -- Error code depicting incorrect combination
1217: WHERE match_ind IS NOT NULL
1218: AND status = '2'

Line 1224: UPDATE Igs_Ad_RelAddr_Int_all mi

1220: END IF;
1221:
1222: --2. If rule is E and duplicate exists, update match_ind to 19 and status to 1
1223: IF l_rule = 'E' THEN
1224: UPDATE Igs_Ad_RelAddr_Int_all mi
1225: SET status = '1',
1226: match_ind = '19'
1227: WHERE mi.interface_relations_id = p_interface_relations_id
1228: AND mi.status = '2'

Line 1248: UPDATE Igs_Ad_RelAddr_Int_all

1244:
1245: --3. If rule is R and there match_ind is 18,19,22 or 23 then the records must have been
1246: -- processed in prior runs and didn't get updated .. update to status 1
1247: IF l_rule = 'R' THEN
1248: UPDATE Igs_Ad_RelAddr_Int_all
1249: SET status = '1'
1250: WHERE interface_relations_id = p_interface_relations_id
1251: AND match_ind IN ('18','19','22','23')
1252: AND status = '2';

Line 1257: UPDATE Igs_Ad_RelAddr_Int_all

1253: END IF;
1254:
1255: --4. If rule is R and match_ind is neither 21 nor 25 then error
1256: IF l_rule = 'R' THEN
1257: UPDATE Igs_Ad_RelAddr_Int_all
1258: SET status = '3',
1259: ERROR_CODE = 'E695'
1260: WHERE interface_relations_id = p_interface_relations_id
1261: AND status = 2

Line 1267: UPDATE Igs_Ad_RelAddr_Int_all mi

1263: END IF;
1264:
1265: --5. If rule is R, set duplicated records with no discrepancy to status 1 and match_ind 23
1266: IF l_rule = 'R' THEN
1267: UPDATE Igs_Ad_RelAddr_Int_all mi
1268: SET status = '1',
1269: match_ind = '23'
1270: WHERE mi.interface_relations_id = p_interface_relations_id
1271: AND mi.match_ind IS NULL

Line 1297: UPDATE Igs_Ad_RelAddr_Int_all mi

1293: END IF;
1294:
1295: --6. If rule is R records still exist, they are duplicates and have discrepancy .. update status=3,match_ind=20
1296: IF l_rule = 'R' THEN
1297: UPDATE Igs_Ad_RelAddr_Int_all mi
1298: SET status = '3',
1299: match_ind = '20'
1300: WHERE mi.interface_relations_id = p_interface_relations_id
1301: AND mi.match_ind IS NULL

Line 1412: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E322','IGS_AD_RELADDR_INT_ALL');

1408: );
1409: END IF;
1410:
1411: IF l_enable_log = 'Y' THEN
1412: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E322','IGS_AD_RELADDR_INT_ALL');
1413: END IF;
1414: UPDATE Igs_Ad_RelAddr_Int_all
1415: SET Error_Code = 'E322',
1416: Status = '3'

Line 1414: UPDATE Igs_Ad_RelAddr_Int_all

1410:
1411: IF l_enable_log = 'Y' THEN
1412: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E322','IGS_AD_RELADDR_INT_ALL');
1413: END IF;
1414: UPDATE Igs_Ad_RelAddr_Int_all
1415: SET Error_Code = 'E322',
1416: Status = '3'
1417: WHERE INTERFACE_RELADDR_ID = reladdr_rec.INTERFACE_RELADDR_ID;
1418: ELSIF l_return_status = 'W' THEN

Line 1437: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E073','IGS_AD_RELADDR_INT_ALL');

1433: );
1434: END IF;
1435:
1436: IF l_enable_log = 'Y' THEN
1437: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E073','IGS_AD_RELADDR_INT_ALL');
1438: END IF;
1439: UPDATE Igs_Ad_RelAddr_Int_all
1440: SET Error_Code = 'E073',
1441: Status = '4'

Line 1439: UPDATE Igs_Ad_RelAddr_Int_all

1435:
1436: IF l_enable_log = 'Y' THEN
1437: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E073','IGS_AD_RELADDR_INT_ALL');
1438: END IF;
1439: UPDATE Igs_Ad_RelAddr_Int_all
1440: SET Error_Code = 'E073',
1441: Status = '4'
1442: WHERE INTERFACE_RELADDR_ID = reladdr_rec.INTERFACE_RELADDR_ID;
1443:

Line 1483: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E322','IGS_AD_RELADDR_INT_ALL');

1479: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
1480: );
1481: END IF;
1482: IF l_enable_log = 'Y' THEN
1483: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E322','IGS_AD_RELADDR_INT_ALL');
1484: END IF;
1485: UPDATE Igs_Ad_RelAddr_Int_all
1486: SET Error_Code = 'E322',
1487: Status = '3'

Line 1485: UPDATE Igs_Ad_RelAddr_Int_all

1481: END IF;
1482: IF l_enable_log = 'Y' THEN
1483: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E322','IGS_AD_RELADDR_INT_ALL');
1484: END IF;
1485: UPDATE Igs_Ad_RelAddr_Int_all
1486: SET Error_Code = 'E322',
1487: Status = '3'
1488: WHERE INTERFACE_RELADDR_ID = reladdr_rec.INTERFACE_RELADDR_ID;
1489: END IF;

Line 1534: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E244','IGS_AD_RELADDR_INT_ALL');

1530: );
1531: END IF;
1532:
1533: IF l_enable_log = 'Y' THEN
1534: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E244','IGS_AD_RELADDR_INT_ALL');
1535: END IF;
1536:
1537: UPDATE Igs_Ad_RelAddr_Int_all
1538: SET Error_Code = 'E244',

Line 1537: UPDATE Igs_Ad_RelAddr_Int_all

1533: IF l_enable_log = 'Y' THEN
1534: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E244','IGS_AD_RELADDR_INT_ALL');
1535: END IF;
1536:
1537: UPDATE Igs_Ad_RelAddr_Int_all
1538: SET Error_Code = 'E244',
1539: Status = '3'
1540: WHERE INTERFACE_RELADDR_ID = reladdr_rec.INTERFACE_RELADDR_ID;
1541: END IF;

Line 1545: UPDATE igs_ad_reladdr_int_all

1541: END IF;
1542: END IF;
1543:
1544: IF l_flag_check_status = 'Y' AND l_addr_warning = 'N' THEN
1545: UPDATE igs_ad_reladdr_int_all
1546: SET error_code = NULL,
1547: status = '1'
1548: WHERE interface_reladdr_id = reladdr_rec.interface_reladdr_id;
1549:

Line 1575: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E518','IGS_AD_RELADDR_INT_ALL');

1571: );
1572: END IF;
1573:
1574: IF l_enable_log = 'Y' THEN
1575: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E518','IGS_AD_RELADDR_INT_ALL');
1576: END IF;
1577:
1578: UPDATE Igs_Ad_RelAddr_Int_all
1579: SET Error_Code = 'E518',

Line 1578: UPDATE Igs_Ad_RelAddr_Int_all

1574: IF l_enable_log = 'Y' THEN
1575: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E518','IGS_AD_RELADDR_INT_ALL');
1576: END IF;
1577:
1578: UPDATE Igs_Ad_RelAddr_Int_all
1579: SET Error_Code = 'E518',
1580: Status = '3'
1581: WHERE Interface_Reladdr_Id = reladdr_rec.Interface_Reladdr_Id;
1582: END;