APPS.IGS_AD_IMP_002 dependencies on IGS_PE_STAT_PKG

Line 716: igs_pe_stat_pkg.insert_row(

712: RAISE NO_DATA_FOUND;
713: END IF;
714: END;
715: END IF;
716: igs_pe_stat_pkg.insert_row(
717: X_ACTION=> 'INSERT',
718: X_ROWID=> l_rowid,
719: X_PERSON_ID => p_person_id,
720: X_ETHNIC_ORIGIN_ID =>stat_rec.ethnic_origin,

Line 827: l_debug_str := 'IGS_AD_IMP_002.Create_Person ' || 'Error from IGS_PE_STAT_PKG. HzMesg : '

823: END IF;
824:
825: l_label := 'igs.plsql.IGS_AD_IMP_002.create_person.exception:E005';
826:
827: l_debug_str := 'IGS_AD_IMP_002.Create_Person ' || 'Error from IGS_PE_STAT_PKG. HzMesg : '
828: || l_msg_data || ' Interface stat ID : ' || stat_rec.interface_stat_id||' Status : 3' || ' ErrorCode : E005';
829:
830: fnd_log.string_with_context( fnd_log.level_exception,
831: l_label,

Line 886: l_debug_str := 'IGS_AD_IMP_002.Create_Person ' || 'Error from IGS_PE_STAT_PKG' || l_msg_data ||

882: l_request_id := fnd_global.conc_request_id;
883: END IF;
884: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||'E005';
885:
886: l_debug_str := 'IGS_AD_IMP_002.Create_Person ' || 'Error from IGS_PE_STAT_PKG' || l_msg_data ||
887: ' Interface Stat Id : ' || stat_rec.interface_stat_id
888: || ' Status : 3' || ' ErrorCode: E005 SQLERRM:' || SQLERRM;
889:
890: fnd_log.string_with_context( fnd_log.level_exception,