APPS.IGS_AD_IMP_002 dependencies on IGS_PE_PERSON_ADDR_PKG

Line 1722: || asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row changed

1718: || Who When What
1719: || (reverse chronological order - newest change first)
1720: || pkpatel 15-JAN-2003 Bug NO: 2397876
1721: || Added all the missing validations and replaced E008 with proper error codes
1722: || asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row changed
1723: */
1724:
1725: CURSOR source_type_cur(cp_source_type igs_pe_src_types_all.source_type%TYPE) Is
1726: SELECT source_type_id

Line 2388: IGS_PE_PERSON_ADDR_PKG.Insert_Row(

2384: p_error_code => p_error_code);
2385:
2386: IF ( p_status = '2' ) THEN
2387:
2388: IGS_PE_PERSON_ADDR_PKG.Insert_Row(
2389: P_ACTION => 'INSERT',
2390: P_ROWID => l_RowId,
2391: P_LOCATION_ID => l_location_Id,
2392: P_START_DT => p_addr_rec.Start_date,

Line 2444: || 'Error from IGS_PE_PERSON_ADDR_PKG.INSERT_ROW HzMesg : ' || l_msg_data

2440:
2441: l_label := 'igs.plsql.igs_ad_imp_002.create_address.exception'||'E006';
2442:
2443: l_debug_str := 'IGS_AD_IMP_002.Create_Address '
2444: || 'Error from IGS_PE_PERSON_ADDR_PKG.INSERT_ROW HzMesg : ' || l_msg_data
2445: || ' Interface Addr Id : ' || p_addr_rec.interface_addr_id
2446: || ' Status : 3' || ' ErrorCode : E006';
2447:
2448: fnd_log.string_with_context( fnd_log.level_exception,

Line 2473: || 'Warning from IGS_PE_PERSON_ADDR_PKG.INSERT_ROW HzMesg : ' || l_msg_data

2469:
2470: l_label := 'igs.plsql.igs_ad_imp_002.create_address.warning'||'E073';
2471:
2472: l_debug_str := 'IGS_AD_IMP_002.Create_Address '
2473: || 'Warning from IGS_PE_PERSON_ADDR_PKG.INSERT_ROW HzMesg : ' || l_msg_data
2474: || ' Interface Addr Id : ' || p_addr_rec.interface_addr_id
2475: || ' Status : 4' || ' ErrorCode : E073';
2476:
2477: fnd_log.string_with_context( fnd_log.level_exception,

Line 2539: || 'Error from IGS_PE_PERSON_ADDR_PKG .INSERT_ROW :' || l_msg_data

2535:
2536: l_label := 'igs.plsql.igs_ad_imp_002.create_address.exception'||'E006';
2537:
2538: l_debug_str := 'IGS_AD_IMP_002.Create_Address '
2539: || 'Error from IGS_PE_PERSON_ADDR_PKG .INSERT_ROW :' || l_msg_data
2540: || ' Interface addr Id : ' || P_addr_REC.INTERFACE_addr_ID
2541: || ' Status : 3' || ' ErrorCode : E006';
2542:
2543: fnd_log.string_with_context( fnd_log.level_exception,

Line 2853: IGS_PE_PERSON_ADDR_PKG.Update_Row(

2849: l_party_site_ovn := null_hand_addr_rec.party_site_ovn;
2850: l_location_id := p_location_id;
2851: l_party_site_id := p_party_site_id;
2852:
2853: IGS_PE_PERSON_ADDR_PKG.Update_Row(
2854: P_ACTION => 'UPDATE',
2855: P_ROWID => l_RowId,
2856: P_LOCATION_ID => l_location_Id,
2857: P_START_DT => nvl(p_addr_rec.Start_date,null_hand_addr_rec.start_dt),