APPS.IGS_AD_IMP_012 dependencies on IGS_PE_ATHLETIC_DTL_PKG

Line 1668: igs_pe_athletic_dtl_pkg.insert_row (

1664: l_debug_str, NULL,
1665: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1666: END IF;
1667:
1668: igs_pe_athletic_dtl_pkg.insert_row (
1669: x_rowid => l_rowid,
1670: x_athletic_details_id => l_athletic_details_id,
1671: x_person_id => p_ath_dtl_rec.person_id,
1672: x_athletic_gpa => p_ath_dtl_rec.athletic_gpa,

Line 1705: ||' Exception from igs_pe_athletic_dtl_Pkg.Insert_Row '

1701:
1702: l_label := 'igs.plsql.igs_ad_imp_003.crt_apcnt_ath_dtl.exception '||'E093';
1703:
1704: l_debug_str := 'igs_ad_imp_003.prc_apcnt_ath_dtls.crt_apcnt_ath_dtl'
1705: ||' Exception from igs_pe_athletic_dtl_Pkg.Insert_Row '
1706: || ' INTERFACE_ATHLETIC_DTLS_ID : ' ||
1707: (p_ath_dtl_rec.interface_athletic_dtls_id) ||
1708: ' Status : ' || '3' || ' ErrorCode : ' || l_error_code
1709: ||' SQLERRM:' || SQLERRM;

Line 1975: igs_pe_athletic_dtl_pkg.update_row (

1971:
1972: IF l_rule = 'I' THEN
1973:
1974: BEGIN
1975: igs_pe_athletic_dtl_pkg.update_row (
1976: x_rowid => dup_chk_ath_dtl_rec.rowid,
1977: x_athletic_details_id => dup_chk_ath_dtl_rec.athletic_details_id,
1978: x_person_id => NVL(ath_dtl_rec.person_id,dup_chk_ath_dtl_rec.person_id),
1979: x_athletic_gpa => NVL(ath_dtl_rec.athletic_gpa,dup_chk_ath_dtl_rec.athletic_gpa),

Line 2016: ||' Exception from igs_pe_athletic_dtl_Pkg.Update_Row '

2012:
2013: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_dtls.exception2 '||l_error_code;
2014:
2015: l_debug_str := 'igs_ad_imp_003.prc_apcnt_ath_dtls'
2016: ||' Exception from igs_pe_athletic_dtl_Pkg.Update_Row '
2017: || ' INTERFACE_ATHLETIC_DTLS_ID : ' ||
2018: (ath_dtl_rec.interface_athletic_dtls_id) ||
2019: ' Status : ' || '3' || ' ErrorCode : ' ||
2020: l_error_code ||' SQLERRM:' || SQLERRM;

Line 2037: igs_pe_athletic_dtl_pkg.update_row (

2033:
2034: ELSIF l_rule = 'R' THEN
2035: IF ath_dtl_rec.match_ind = '21' THEN -- '21' Match reviewed and to be imported
2036: BEGIN
2037: igs_pe_athletic_dtl_pkg.update_row (
2038: x_rowid => dup_chk_ath_dtl_rec.rowid,
2039: x_athletic_details_id => dup_chk_ath_dtl_rec.athletic_details_id,
2040: x_person_id => NVL(ath_dtl_rec.person_id,dup_chk_ath_dtl_rec.person_id),
2041: x_athletic_gpa => NVL(ath_dtl_rec.athletic_gpa,dup_chk_ath_dtl_rec.athletic_gpa),

Line 2078: ||' Exception from igs_pe_athletic_dtl_Pkg.Update_Row '

2074:
2075: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_dtls.exception1 '||l_error_code;
2076:
2077: l_debug_str := 'igs_ad_imp_003.prc_apcnt_ath_dtls'
2078: ||' Exception from igs_pe_athletic_dtl_Pkg.Update_Row '
2079: || ' INTERFACE_ATHLETIC_DTLS_ID : ' ||
2080: (ath_dtl_rec.interface_athletic_dtls_id) ||
2081: ' Status : ' || '3' || ' ErrorCode : ' ||
2082: l_error_code ||' SQLERRM:' || SQLERRM;