APPS.IGS_AD_IMP_012 dependencies on IGS_PE_ATHLETIC_PRG_PKG

Line 2204: igs_pe_athletic_prg_pkg.insert_row (

2200: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2201: END IF;
2202:
2203:
2204: igs_pe_athletic_prg_pkg.insert_row (
2205: x_rowid => l_rowid,
2206: x_athletic_prg_id => l_athletic_prg_id,
2207: x_person_id => p_ath_prg_rec.person_id,
2208: x_athletic_prg_code => p_ath_prg_rec.athletic_prg_code,

Line 2242: ||' Exception from igs_pe_athletic_prg_Pkg.Insert_Row '

2238:
2239: l_label := 'igs.plsql.igs_ad_imp_003.crt_apcnt_ath_dtl.exception '||l_error_code;
2240:
2241: l_debug_str := 'igs_ad_imp_003.prc_apcnt_ath_prg.crt_apcnt_ath_prg'
2242: ||' Exception from igs_pe_athletic_prg_Pkg.Insert_Row '
2243: || ' INTERFACE_ATHLETIC_PRG_ID : ' ||
2244: (p_ath_prg_rec.interface_athletic_prg_id) ||
2245: ' Status : ' || '3' || ' ErrorCode : ' || l_error_code
2246: ||' SQLERRM:' || SQLERRM;

Line 2509: igs_pe_athletic_prg_pkg.update_row (

2505: --If its a duplicate record find the source category rule for that Source Category.
2506: IF dup_chk_ath_prg_rec.athletic_prg_id IS NOT NULL THEN
2507: IF l_rule = 'I' THEN
2508: BEGIN
2509: igs_pe_athletic_prg_pkg.update_row (
2510: x_rowid => dup_chk_ath_prg_rec.rowid,
2511: x_athletic_prg_id => dup_chk_ath_prg_rec.athletic_prg_id,
2512: x_person_id => NVL(ath_prg_rec.person_id,dup_chk_ath_prg_rec.person_id),
2513: x_athletic_prg_code => ath_prg_rec.athletic_prg_code,

Line 2551: ||' Exception from igs_pe_athletic_prg_Pkg.Update_Row '

2547:
2548: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_prg.exception1 '||l_error_code;
2549:
2550: l_debug_str := 'igs_ad_imp_003.prc_apcnt_ath_prg'
2551: ||' Exception from igs_pe_athletic_prg_Pkg.Update_Row '
2552: || ' INTERFACE_ATHLETIC_PRG_ID : ' ||
2553: (ath_prg_rec.interface_athletic_prg_id) ||
2554: ' Status : ' || '3' || ' ErrorCode : ' ||
2555: l_error_code||' SQLERRM:' || SQLERRM;

Line 2572: igs_pe_athletic_prg_pkg.update_row (

2568:
2569: ELSIF l_rule = 'R' THEN
2570: IF ath_prg_rec.match_ind = '21' THEN -- '21' Match reviewed and to be imported
2571: BEGIN
2572: igs_pe_athletic_prg_pkg.update_row (
2573: x_rowid => dup_chk_ath_prg_rec.rowid,
2574: x_athletic_prg_id => dup_chk_ath_prg_rec.athletic_prg_id,
2575: x_person_id => NVL(ath_prg_rec.person_id,dup_chk_ath_prg_rec.person_id),
2576: x_athletic_prg_code => ath_prg_rec.athletic_prg_code,

Line 2614: ||' Exception from igs_pe_athletic_prg_Pkg.Update_Row '

2610:
2611: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_prg.exception2 '||l_error_code;
2612:
2613: l_debug_str := 'igs_ad_imp_003.prc_apcnt_ath_prg'
2614: ||' Exception from igs_pe_athletic_prg_Pkg.Update_Row '
2615: || ' INTERFACE_ATHLETIC_PRG_ID : ' ||
2616: (ath_prg_rec.interface_athletic_prg_id) ||
2617: ' Status : ' || '3' || ' ErrorCode : ' ||
2618: l_error_code||' SQLERRM:' || SQLERRM;