APPS.IGR_IMP_001 dependencies on IGS_AD_ADDR_INT

Line 1142: /* Validate the data in Self Service table for not null before inseting into igs_ad_addr_int */

1138: UPDATE igr_is_contact SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1139: END LOOP;
1140:
1141: FOR inq_per_addr_rec IN inq_per_addr_cur(inq_rec.inq_person_id) LOOP
1142: /* Validate the data in Self Service table for not null before inseting into igs_ad_addr_int */
1143: validate_addr_int(inq_per_addr_rec, l_status,l_tokenstr);
1144: IF l_status = 1 THEN /*Validation Successfull*/
1145: BEGIN
1146: INSERT INTO igs_ad_addr_int

Line 1146: INSERT INTO igs_ad_addr_int

1142: /* Validate the data in Self Service table for not null before inseting into igs_ad_addr_int */
1143: validate_addr_int(inq_per_addr_rec, l_status,l_tokenstr);
1144: IF l_status = 1 THEN /*Validation Successfull*/
1145: BEGIN
1146: INSERT INTO igs_ad_addr_int
1147: (
1148: interface_addr_id ,
1149: interface_id ,
1150: addr_line_1 ,

Line 1186: igs_ad_addr_int_s.nextval,

1182: last_update_login ,
1183: creation_date
1184: ) VALUES
1185: (
1186: igs_ad_addr_int_s.nextval,
1187: l_interface_id ,
1188: inq_per_addr_rec.addr_line_1 ,
1189: inq_rec.org_id ,
1190: inq_per_addr_rec.addr_line_2 ,

Line 1225: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_ADDR_INT failed '||SQLERRM);

1221: sysdate
1222: );
1223: EXCEPTION WHEN OTHERS THEN
1224: l_status:=0;
1225: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_ADDR_INT failed '||SQLERRM);
1226: RAISE;
1227: END;
1228:
1229: ELSE /* l_status = 0 i.e Validation failed*/

Line 1231: fnd_message.set_token('TABLE_NAME','igs_ad_addr_int');

1227: END;
1228:
1229: ELSE /* l_status = 0 i.e Validation failed*/
1230: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1231: fnd_message.set_token('TABLE_NAME','igs_ad_addr_int');
1232: fnd_message.set_token('COL_NAMES',l_tokenstr);
1233: fnd_message.set_token('ID',inq_rec.inq_person_id);
1234: fnd_file.put_line(fnd_file.log,fnd_message.get);
1235: RAISE null_validation_fails;

Line 1268: igs_ad_addr_int_s.currval,

1264: fnd_global.conc_request_id,
1265: fnd_global.prog_appl_id,
1266: fnd_global.conc_program_id,
1267: sysdate ,
1268: igs_ad_addr_int_s.currval,
1269: inq_rec.org_id ,
1270: igs_ad_addrusage_int_s.nextval,
1271: inq_per_addr_rec.addr_usage ,
1272: null ,