APPS.IGS_AD_IMP_011 dependencies on IGS_PE_SN_CONTACT_PKG

Line 2060: igs_pe_sn_contact_pkg.insert_row (

2056: validate_sn_contact(p_sn_contact_rec, p_person_id, l_success, l_error_code);
2057:
2058: IF l_success = 'Y' THEN -- Successful Validation
2059:
2060: igs_pe_sn_contact_pkg.insert_row (
2061: x_rowid => l_rowid ,
2062: x_sn_contact_id => l_sn_contact_id,
2063: x_disability_id => p_disability_id,
2064: x_contact_name => p_sn_contact_rec.contact_name,

Line 2100: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.insert_row'

2096:
2097: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_contact.exception'||l_error_code;
2098:
2099: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_SN_Contact '
2100: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.insert_row'
2101: ||' for INTERFACE SN CONTACT ID :'
2102: || p_sn_contact_rec.interface_sn_contact_id
2103: || 'Status : 3'
2104: || 'ErrorCode :' || l_error_code

Line 2538: igs_pe_sn_contact_pkg.update_row (

2534: BEGIN
2535:
2536: validate_sn_contact(sn_contact_rec, p_person_id, l_success, l_error_code);
2537: IF l_success = 'Y' THEN -- Successful Validation
2538: igs_pe_sn_contact_pkg.update_row (
2539: x_rowid => dup_chk_sn_contact_rec.rowid ,
2540: x_sn_contact_id => dup_chk_sn_contact_rec.sn_contact_id,
2541: x_disability_id => dup_chk_sn_contact_rec.disability_id,
2542: x_contact_name => NVL(sn_contact_rec.contact_name,dup_chk_sn_contact_rec.contact_name),

Line 2576: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.update_row'

2572:
2573: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.exception'||l_error_code;
2574:
2575: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Contact '
2576: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.update_row'
2577: ||' for INTERFACE SN CONTACT ID :'
2578: || sn_contact_rec.interface_sn_contact_id
2579: || ' Status : 3'
2580: || ' ErrorCode :' || l_error_code

Line 2603: igs_pe_sn_contact_pkg.update_row (

2599: validate_sn_contact(sn_contact_rec, p_person_id, l_success, l_error_code);
2600:
2601: IF l_success = 'Y' THEN -- Successful Validation
2602:
2603: igs_pe_sn_contact_pkg.update_row (
2604: x_rowid => dup_chk_sn_contact_rec.rowid ,
2605: x_sn_contact_id => dup_chk_sn_contact_rec.sn_contact_id,
2606: x_disability_id => dup_chk_sn_contact_rec.disability_id,
2607: x_contact_name => NVL(sn_contact_rec.contact_name,dup_chk_sn_contact_rec.contact_name),

Line 2642: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.update_row'

2638:
2639: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.exception'||l_error_code;
2640:
2641: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Contact '
2642: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.update_row'
2643: ||' for INTERFACE SN CONTACT ID :'
2644: || sn_contact_rec.interface_sn_contact_id
2645: || ' Status : 3'
2646: || ' ErrorCode :' || l_error_code