APPS.IGS_AD_IMP_007 dependencies on IGS_PE_FUND_SOURCE

Line 3310: l_fund_source_id igs_pe_fund_source.fund_source_id%TYPE;

3306: l_dup_var BOOLEAN;
3307: l_rule VARCHAR2(1);
3308:
3309: pfs_rec c_pfs%ROWTYPE;
3310: l_fund_source_id igs_pe_fund_source.fund_source_id%TYPE;
3311: l_status pfs_rec.status%TYPE;
3312: l_error_code pfs_rec.error_code%TYPE;
3313: l_match_ind pfs_rec.match_ind%TYPE;
3314: l_processed_records NUMBER(5) := 0;

Line 3335: igs_pe_fund_source_pkg.insert_row(

3331: */
3332: AS
3333:
3334: BEGIN
3335: igs_pe_fund_source_pkg.insert_row(
3336: x_rowid => l_rowid,
3337: x_fund_source_id => l_fund_source_id,
3338: x_person_id => pfs_rec.person_id,
3339: x_fund_source_code => pfs_rec.fund_source_code,

Line 3363: || ' Exception from Igs_Pe_Fund_Source_Pkg.Insert_Row '

3359:
3360: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_fund_source.exception '||'E133';
3361:
3362: l_debug_str := 'IGS_AD_IMP_007.crt_pe_fund_source '
3363: || ' Exception from Igs_Pe_Fund_Source_Pkg.Insert_Row '
3364: || 'Interface Fund Source Id : '
3365: || (pfs_rec.interface_fund_source_id)
3366: || 'Status : 3' || 'ErrorCode : E133 SQLERRM:' || SQLERRM;
3367: