APPS.IGS_AD_IMP_011 dependencies on IGS_PE_SN_SERVICE_PKG

Line 1956: igs_pe_sn_service_pkg.insert_row (

1952: -- kumma, 2608360 Added two more parameters for start_dt and end_dt
1953:
1954: IF l_success = 'Y' THEN -- Successful Validation
1955:
1956: igs_pe_sn_service_pkg.insert_row (
1957: x_rowid => l_rowid ,
1958: x_sn_service_id => l_sn_service_id,
1959: x_disability_id => p_disability_id,
1960: x_special_service_cd => p_sn_service_rec.special_service_cd,

Line 1995: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.insert_row'

1991:
1992: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_service.exception'||l_error_code;
1993:
1994: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_SN_Service '
1995: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.insert_row'
1996: ||' for INTERFACE SN SERVICE ID :'
1997: || p_sn_service_rec.interface_sn_service_id
1998: || ' Status : 3'
1999: || ' ErrorCode :' || l_error_code

Line 2266: igs_pe_sn_service_pkg.update_row (

2262: IF l_rule = 'I' THEN
2263: BEGIN
2264: validate_sn_service(sn_service_rec, p_person_id, l_success, l_error_code);
2265: IF l_success = 'Y' THEN -- Successful Validation
2266: igs_pe_sn_service_pkg.update_row (
2267: x_rowid => dup_chk_sn_service_rec.ROWID,
2268: x_sn_service_id => dup_chk_sn_service_rec.sn_service_id,
2269: x_disability_id => dup_chk_sn_service_rec.disability_id,
2270: x_special_service_cd => sn_service_rec.special_service_cd,

Line 2305: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.update_row'

2301:
2302: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_service.exception'||l_error_code;
2303:
2304: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Service '
2305: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.update_row'
2306: ||' for INTERFACE SN SERVICE ID :'
2307: || sn_service_rec.interface_sn_service_id
2308: || ' Status : 3'
2309: || ' ErrorCode :' || l_error_code

Line 2330: igs_pe_sn_service_pkg.update_row (

2326:
2327: validate_sn_service(sn_service_rec, p_person_id, l_success, l_error_code);
2328:
2329: IF l_success = 'Y' THEN -- Successful Validation
2330: igs_pe_sn_service_pkg.update_row (
2331: x_rowid => dup_chk_sn_service_rec.rowid ,
2332: x_sn_service_id => dup_chk_sn_service_rec.sn_service_id,
2333: x_disability_id => p_disability_id,
2334: x_special_service_cd => sn_service_rec.special_service_cd,

Line 2370: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.update_row'

2366:
2367: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_service.exception'||l_error_code;
2368:
2369: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Service '
2370: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.update_row'
2371: ||' for INTERFACE SN SERVICE ID :'
2372: || sn_service_rec.interface_sn_service_id
2373: || ' Status : 3'
2374: || ' ErrorCode :' || l_error_code