1006: -- Bug 2378114 Add a row for Phone and Email separately
1007: FOR inq_per_contacts_rec IN inq_per_contacts_cur(inq_rec.inq_person_id) LOOP
1008: IF inq_per_contacts_rec.phone_number IS NOT NULL THEN
1009: BEGIN
1010: INSERT INTO igs_ad_contacts_int
1011: (
1012: phone_extension,
1013: status,
1014: match_ind,
1050: fnd_global.prog_appl_id,
1051: fnd_global.conc_program_id,
1052: SYSDATE,
1053: inq_rec.org_id,
1054: igs_ad_contacts_int_s.nextval,
1055: l_interface_id,
1056: 'PHONE',
1057: NULL,
1058: NULL,
1063: inq_per_contacts_rec.phone_number
1064: );
1065: EXCEPTION WHEN OTHERS THEN
1066: l_status:=0;
1067: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_CONTACTS_INT failed '||SQLERRM);
1068: RAISE;
1069: END;
1070:
1071: END IF;
1070:
1071: END IF;
1072: IF inq_per_contacts_rec.email_address IS NOT NULL THEN
1073: BEGIN
1074: INSERT INTO igs_ad_contacts_int
1075: (
1076: phone_extension,
1077: status,
1078: match_ind,
1114: fnd_global.prog_appl_id,
1115: fnd_global.conc_program_id,
1116: SYSDATE,
1117: inq_rec.org_id,
1118: igs_ad_contacts_int_s.nextval,
1119: l_interface_id,
1120: 'EMAIL',
1121: inq_per_contacts_rec.email_address,
1122: 'MAILTEXT', -- kamohan // Bug 2712105
1127: NULL
1128: );
1129: EXCEPTION WHEN OTHERS THEN
1130: l_status:=0;
1131: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_CONTACTS_INT failed '||SQLERRM);
1132: RAISE;
1133: END;
1134:
1135: END IF; -- kamohan Bug 2378114 End of Fix