eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_002 dependencies on IGS_PE_PERSON

Line 155: P_PERSON_ID OUT NOCOPY IGS_PE_PERSON.PERSON_ID%TYPE) AS

151:
152: PROCEDURE CREATE_PERSON(P_person_rec IN IGS_AD_INTERFACE_DTL_DSCP_V%ROWTYPE,
153: P_ADDR_TYPE IN VARCHAR2,
154: P_PERSON_ID_TYPE IN VARCHAR2,
155: P_PERSON_ID OUT NOCOPY IGS_PE_PERSON.PERSON_ID%TYPE) AS
156: /*
157: || Created By : nsinha
158: || Created On : 22-JUN-2001
159: || Purpose : This procedure process the Application

Line 221: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS

217: AND ai.status IN ('1','4'); --4035277, if address errors out, it sets status =4 for ad_interface
218: -- furture processing should happen..so always check for 1,4 in ad_interface
219:
220: -- Cursor to get format mask to validate person alternate id.
221: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
222: SELECT format_mask
223: FROM igs_pe_person_id_typ
224: WHERE person_id_type = cp_person_id_type;
225:

Line 223: FROM igs_pe_person_id_typ

219:
220: -- Cursor to get format mask to validate person alternate id.
221: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
222: SELECT format_mask
223: FROM igs_pe_person_id_typ
224: WHERE person_id_type = cp_person_id_type;
225:
226: api_type_rec api_type_cur%ROWTYPE;
227: api_rec api_cur%ROWTYPE;

Line 233: FROM IGS_PE_PERSON_ID_TYP

229:
230: /* Following cursor is added as a fix for bug number 2333026 */
231: CURSOR c_pref_alt_id_type IS
232: SELECT PERSON_ID_TYPE
233: FROM IGS_PE_PERSON_ID_TYP
234: WHERE PREFERRED_IND ='Y';
235:
236: CURSOR pe_hz_parties_cur(cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
237: SELECT pehz.ROWID, pehz.*

Line 241: l_pref_altid_type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;

237: SELECT pehz.ROWID, pehz.*
238: FROM IGS_PE_HZ_PARTIES pehz
239: WHERE party_id = cp_person_id;
240:
241: l_pref_altid_type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
242: l_pref_altid p_person_rec.PREF_ALTERNATE_ID%TYPE;
243: tlinfo2 pe_hz_parties_cur%ROWTYPE;
244: l_rowid VARCHAR2(25);
245: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;

Line 245: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;

241: l_pref_altid_type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
242: l_pref_altid p_person_rec.PREF_ALTERNATE_ID%TYPE;
243: tlinfo2 pe_hz_parties_cur%ROWTYPE;
244: l_rowid VARCHAR2(25);
245: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;
246: l_person_number VARCHAR2(30);
247: l_PrefPersonIDType IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
248: l_statistics_id NUMBER;
249: l_Return_Status VARCHAR2(1);

Line 247: l_PrefPersonIDType IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;

243: tlinfo2 pe_hz_parties_cur%ROWTYPE;
244: l_rowid VARCHAR2(25);
245: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;
246: l_person_number VARCHAR2(30);
247: l_PrefPersonIDType IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
248: l_statistics_id NUMBER;
249: l_Return_Status VARCHAR2(1);
250: l_Status VARCHAR2(1);
251: l_Msg_Data VARCHAR2(4000);

Line 424: IGS_PE_PERSON_PKG.INSERT_ROW( X_MSG_COUNT => l_msg_count,

420: ELSE
421: l_preferred_given_name := p_person_rec.preferred_given_name;
422: END IF;
423:
424: IGS_PE_PERSON_PKG.INSERT_ROW( X_MSG_COUNT => l_msg_count,
425: X_MSG_DATA => l_msg_data,
426: X_RETURN_STATUS=> l_return_status,
427: X_ROWID=> l_rowid,
428: X_PERSON_ID => l_person_id,

Line 596: l_debug_str := 'IGS_AD_IMP_002.Create_Person' || ' Exception from IGS_PE_PERSON_PKG '|| ' Interface Id : ' || (P_person_rec.INTERFACE_ID) ||

592: END IF;
593:
594: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||l_error_code;
595:
596: l_debug_str := 'IGS_AD_IMP_002.Create_Person' || ' Exception from IGS_PE_PERSON_PKG '|| ' Interface Id : ' || (P_person_rec.INTERFACE_ID) ||
597: ' Status : 3' || ' ErrorCode:'||l_error_code||' SQLERRM '|| SQLERRM ;
598:
599: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
600: END IF;

Line 678: CURSOR c_mar_eff_dt(cp_person_id igs_pe_person.person_id%TYPE) IS

674: END;
675: END IF;
676: IF stat_rec.MARITAL_STATUS_EFFECTIVE_DATE IS NOT NULL THEN
677: DECLARE
678: CURSOR c_mar_eff_dt(cp_person_id igs_pe_person.person_id%TYPE) IS
679: SELECT BIRTH_DATE
680: FROM IGS_PE_PERSON_BASE_V WHERE
681: PERSON_ID =cp_person_id;
682: l_birth_date IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;

Line 680: FROM IGS_PE_PERSON_BASE_V WHERE

676: IF stat_rec.MARITAL_STATUS_EFFECTIVE_DATE IS NOT NULL THEN
677: DECLARE
678: CURSOR c_mar_eff_dt(cp_person_id igs_pe_person.person_id%TYPE) IS
679: SELECT BIRTH_DATE
680: FROM IGS_PE_PERSON_BASE_V WHERE
681: PERSON_ID =cp_person_id;
682: l_birth_date IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;
683: BEGIN
684: IF l_birth_date IS NOT NULL THEN

Line 682: l_birth_date IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;

678: CURSOR c_mar_eff_dt(cp_person_id igs_pe_person.person_id%TYPE) IS
679: SELECT BIRTH_DATE
680: FROM IGS_PE_PERSON_BASE_V WHERE
681: PERSON_ID =cp_person_id;
682: l_birth_date IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;
683: BEGIN
684: IF l_birth_date IS NOT NULL THEN
685: OPEN c_mar_eff_dt(p_person_id);
686: FETCH c_mar_eff_dt INTO l_birth_date;

Line 1025: P_PERSON_ID IN IGS_PE_PERSON.PERSON_ID%TYPE) AS

1021:
1022: PROCEDURE UPDATE_PERSON( p_person_rec IN IGS_AD_INTERFACE_DTL_DSCP_V%ROWTYPE,
1023: P_ADDR_TYPE IN VARCHAR2,
1024: P_PERSON_ID_TYPE IN VARCHAR2,
1025: P_PERSON_ID IN IGS_PE_PERSON.PERSON_ID%TYPE) AS
1026: /*
1027: || Created By : nsinha
1028: || Created On : 22-JUN-2001
1029: || Purpose : This procedure process the Application

Line 1078: CURSOR c_null_hdlg_per_cur(cp_person_id igs_pe_person.person_id%TYPE) IS

1074: api_rec api_cur%ROWTYPE;
1075:
1076: -- Cursor for Null handling Rule.
1077: -- Cursor for Null handling Rule
1078: CURSOR c_null_hdlg_per_cur(cp_person_id igs_pe_person.person_id%TYPE) IS
1079: SELECT
1080: p.rowid row_id,
1081: p.party_id person_id,
1082: p.party_number person_number,

Line 1145: igs_pe_person_id_type_v pit

1141: FROM
1142: hz_parties p,
1143: igs_pe_hz_parties pd,
1144: hz_person_profiles pp,
1145: igs_pe_person_id_type_v pit
1146: WHERE p.party_id = cp_person_id
1147: AND p.party_id = pit.pe_person_id (+)
1148: AND p.party_id = pd.party_id (+)
1149: AND p.party_id = pp.party_id

Line 1153: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS

1149: AND p.party_id = pp.party_id
1150: AND SYSDATE BETWEEN pp.effective_start_date AND NVL(pp.effective_end_date,SYSDATE);
1151:
1152: -- Cursor to get format mask to validate person alternate id.
1153: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
1154: SELECT format_mask
1155: FROM igs_pe_person_id_typ
1156: WHERE person_id_type = cp_person_id_type;
1157:

Line 1155: FROM igs_pe_person_id_typ

1151:
1152: -- Cursor to get format mask to validate person alternate id.
1153: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
1154: SELECT format_mask
1155: FROM igs_pe_person_id_typ
1156: WHERE person_id_type = cp_person_id_type;
1157:
1158: api_type_rec api_type_cur%ROWTYPE;
1159:

Line 1162: FROM IGS_PE_PERSON_ID_TYP

1158: api_type_rec api_type_cur%ROWTYPE;
1159:
1160: CURSOR c_pref_alt_id_type IS
1161: SELECT PERSON_ID_TYPE
1162: FROM IGS_PE_PERSON_ID_TYP
1163: WHERE PREFERRED_IND ='Y';
1164:
1165: CURSOR pe_hz_parties_cur(cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
1166: SELECT pehz.ROWID, pehz.*

Line 1175: l_pref_altid_type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;

1171: SELECT last_update_date, ROWID
1172: FROM hz_parties
1173: WHERE party_id = cp_person_id;
1174:
1175: l_pref_altid_type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
1176: l_pref_altid p_person_rec.PREF_ALTERNATE_ID%TYPE;
1177: tlinfo2 pe_hz_parties_cur%ROWTYPE;
1178: c_null_hdlg_per_rec c_null_hdlg_per_cur%ROWTYPE;
1179: lv_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;

Line 1183: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;

1179: lv_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
1180:
1181: l_location_Id NUMBER;
1182: l_rowid VARCHAR2(25);
1183: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;
1184: l_PrefPersonIDType IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
1185: l_status VARCHAR2(2);
1186: l_error_code VARCHAR2(6);
1187: l_Last_Update_Date DATE;

Line 1184: l_PrefPersonIDType IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;

1180:
1181: l_location_Id NUMBER;
1182: l_rowid VARCHAR2(25);
1183: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;
1184: l_PrefPersonIDType IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
1185: l_status VARCHAR2(2);
1186: l_error_code VARCHAR2(6);
1187: l_Last_Update_Date DATE;
1188: l_Error_Code_Num NUMBER;

Line 1378: IGS_PE_PERSON_PKG.UPDATE_ROW(

1374: SAVEPOINT BEFORE_UPDATE;
1375:
1376: BEGIN
1377: -- Update Person
1378: IGS_PE_PERSON_PKG.UPDATE_ROW(
1379: X_LAST_UPDATE_DATE => l_last_update_date,
1380: X_MSG_COUNT => l_msg_count,
1381: X_MSG_DATA => l_msg_data,
1382: X_RETURN_STATUS=> l_return_status,

Line 1521: l_debug_str := 'IGS_AD_IMP_002.Update_Person' || ' Exception from IGS_PE_PERSON_PKG ' ||

1517: END IF;
1518:
1519: l_label := 'igs.plsql.igs_ad_imp_002.update_person.exception'||l_error_code;
1520:
1521: l_debug_str := 'IGS_AD_IMP_002.Update_Person' || ' Exception from IGS_PE_PERSON_PKG ' ||
1522: ' Interface Id : ' || ( P_person_rec.INTERFACE_ID) ||
1523: ' Status : 3' || ' ErrorCode : '||l_error_code||' SQLERRM:' || SQLERRM;
1524:
1525: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

Line 1553: l_debug_str := 'IGS_AD_IMP_002.Update_Person ' || 'Error from IGS_PE_PERSON_PKG. HzMesg : ' || l_msg_data ||

1549: END IF;
1550:
1551: l_label := 'igs.plsql.igs_ad_imp_002.update_person.exception'||'E014';
1552:
1553: l_debug_str := 'IGS_AD_IMP_002.Update_Person ' || 'Error from IGS_PE_PERSON_PKG. HzMesg : ' || l_msg_data ||
1554: ' Interface Id : ' || (P_person_rec.INTERFACE_ID) ||
1555: ' Status : 3' || ' ErrorCode : E014';
1556:
1557: fnd_log.string_with_context( fnd_log.level_exception,

Line 1708: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,

1704: END UPDATE_PERSON;
1705:
1706:
1707: PROCEDURE CREATE_API(p_api_rec IN IGS_AD_API_INT_ALL%ROWTYPE,
1708: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
1709: p_status OUT NOCOPY VARCHAR2,
1710: p_error_code OUT NOCOPY VARCHAR2) AS
1711:
1712: /*

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 1762: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS

1758: */
1759:
1760: l_exists VARCHAR2(1);
1761:
1762: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
1763: SELECT format_mask, region_ind
1764: FROM igs_pe_person_id_typ
1765: WHERE person_id_type = cp_person_id_type
1766: AND closed_ind = 'N';

Line 1764: FROM igs_pe_person_id_typ

1760: l_exists VARCHAR2(1);
1761:
1762: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
1763: SELECT format_mask, region_ind
1764: FROM igs_pe_person_id_typ
1765: WHERE person_id_type = cp_person_id_type
1766: AND closed_ind = 'N';
1767:
1768: CURSOR region_cd_cur(cp_geography_type hz_geographies.geography_type%TYPE,

Line 2144: P_PERSON_ID IN IGS_PE_PERSON.PERSON_ID%TYPE,

2140: END IF;
2141: END create_api;
2142:
2143: PROCEDURE CREATE_ADDRESS(P_addr_rec IN IGS_ad_Addr_int_all%ROWTYPE,
2144: P_PERSON_ID IN IGS_PE_PERSON.PERSON_ID%TYPE,
2145: P_STATUS OUT NOCOPY VARCHAR2,
2146: p_error_code OUT NOCOPY VARCHAR2) AS
2147: l_rowid VARCHAR2(25);
2148: l_return_status VARCHAR2(100);

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 2558: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,

2554:
2555:
2556: PROCEDURE UPDATE_ADDRESS(
2557: p_addr_rec IN IGS_AD_ADDR_INT_ALL%ROWTYPE,
2558: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
2559: p_location_id IN hz_party_sites.location_id%TYPE,
2560: p_party_site_id IN hz_party_sites.party_site_id%TYPE) AS
2561:
2562: l_rowid VARCHAR2(25);

Line 2578: CURSOR null_hand_addr_cur(cp_location_id IGS_PE_PERSON_ADDR_V.location_id%TYPE,

2574: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
2575: l_location_ovn hz_locations.object_version_number%TYPE;
2576:
2577:
2578: CURSOR null_hand_addr_cur(cp_location_id IGS_PE_PERSON_ADDR_V.location_id%TYPE,
2579: cp_party_site_id IGS_PE_PERSON_ADDR_V.party_site_id%TYPE)IS
2580: SELECT *
2581: FROM IGS_PE_PERSON_ADDR_V
2582: WHERE location_id = cp_location_id AND

Line 2579: cp_party_site_id IGS_PE_PERSON_ADDR_V.party_site_id%TYPE)IS

2575: l_location_ovn hz_locations.object_version_number%TYPE;
2576:
2577:
2578: CURSOR null_hand_addr_cur(cp_location_id IGS_PE_PERSON_ADDR_V.location_id%TYPE,
2579: cp_party_site_id IGS_PE_PERSON_ADDR_V.party_site_id%TYPE)IS
2580: SELECT *
2581: FROM IGS_PE_PERSON_ADDR_V
2582: WHERE location_id = cp_location_id AND
2583: party_site_id = cp_party_site_id;

Line 2581: FROM IGS_PE_PERSON_ADDR_V

2577:
2578: CURSOR null_hand_addr_cur(cp_location_id IGS_PE_PERSON_ADDR_V.location_id%TYPE,
2579: cp_party_site_id IGS_PE_PERSON_ADDR_V.party_site_id%TYPE)IS
2580: SELECT *
2581: FROM IGS_PE_PERSON_ADDR_V
2582: WHERE location_id = cp_location_id AND
2583: party_site_id = cp_party_site_id;
2584:
2585: null_hand_addr_rec null_hand_addr_cur%ROWTYPE;

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),

Line 2906: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Error from IGS_PE_PERSON_ADDRESS_PKG : HzMesg'

2902: END IF;
2903:
2904: l_label := 'igs.plsql.igs_ad_imp_002.update_address.exception'||p_error_code;
2905:
2906: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Error from IGS_PE_PERSON_ADDRESS_PKG : HzMesg'
2907: || l_msg_data || ' Interface Addr Id : '
2908: || (P_addr_REC.INTERFACE_ADDR_ID) ||' Status : 3' || ' ErrorCode : E014 ';
2909:
2910: fnd_log.string_with_context( fnd_log.level_exception,

Line 2933: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Warning from IGS_PE_PERSON_ADDRESS_PKG : HzMesg'

2929: END IF;
2930:
2931: l_label := 'igs.plsql.igs_ad_imp_002.update_address.warning'||p_error_code;
2932:
2933: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Warning from IGS_PE_PERSON_ADDRESS_PKG : HzMesg'
2934: || l_msg_data || ' Interface Addr Id : '
2935: || (P_addr_REC.INTERFACE_ADDR_ID) ||' Status : 4' || ' ErrorCode : E073';
2936:
2937: fnd_log.string_with_context( fnd_log.level_exception,

Line 2978: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Exception from IGS_PE_PERSON_ADDRESS_PKG : HzMesg '

2974: END IF;
2975:
2976: l_label := 'igs.plsql.igs_ad_imp_002.update_address.exception'||'E014';
2977:
2978: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Exception from IGS_PE_PERSON_ADDRESS_PKG : HzMesg '
2979: || l_msg_data || ' Interface Addr Id : '
2980: || (P_addr_REC.INTERFACE_ADDR_ID) || ' Status : 3' ||
2981: ' ErrorCode : '||p_error_code;
2982:

Line 3051: CURSOR c_null_hdlg_per_cur(cp_person_id igs_pe_person.person_id%TYPE) IS

3047: AND batch_id = cp_d_batch_id
3048: AND source_type_id = cp_d_source_type_id;
3049:
3050: -- Cursor for Null handling Rule
3051: CURSOR c_null_hdlg_per_cur(cp_person_id igs_pe_person.person_id%TYPE) IS
3052: SELECT
3053: p.person_last_name surname,
3054: p.person_first_name given_names,
3055: p.person_middle_name middle_name,

Line 3087: CURSOR discrepancy_exist_cur(cp_person_id igs_pe_person.person_id%TYPE,

3083: AND md.data_element =cp_type;
3084:
3085:
3086: --Cursor for record level Review
3087: CURSOR discrepancy_exist_cur(cp_person_id igs_pe_person.person_id%TYPE,
3088: c_person_rec person_cur%ROWTYPE) IS
3089: SELECT 'X'
3090: FROM hz_parties p,
3091: igs_pe_hz_parties pd,

Line 3093: igs_pe_person_id_type_v pit

3089: SELECT 'X'
3090: FROM hz_parties p,
3091: igs_pe_hz_parties pd,
3092: hz_person_profiles pp,
3093: igs_pe_person_id_type_v pit
3094: WHERE p.party_id = cp_person_id
3095: AND p.party_id = pit.pe_person_id (+)
3096: AND p.party_id = pd.party_id (+)
3097: AND p.party_id = pp.party_id

Line 3573: p_person_id IN igs_pe_person_base_v.PERSON_ID%TYPE,

3569: END prc_pe_dtls;
3570:
3571:
3572: PROCEDURE validate_address (p_addr_rec IN IGS_AD_ADDR_INT_ALL%ROWTYPE,
3573: p_person_id IN igs_pe_person_base_v.PERSON_ID%TYPE,
3574: p_status OUT NOCOPY VARCHAR2,
3575: p_error_code OUT NOCOPY VARCHAR2) AS
3576:
3577: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

Line 3577: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

3573: p_person_id IN igs_pe_person_base_v.PERSON_ID%TYPE,
3574: p_status OUT NOCOPY VARCHAR2,
3575: p_error_code OUT NOCOPY VARCHAR2) AS
3576:
3577: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
3578: SELECT birth_date
3579: FROM igs_pe_person_base_v
3580: WHERE person_id = cp_person_id;
3581:

Line 3579: FROM igs_pe_person_base_v

3575: p_error_code OUT NOCOPY VARCHAR2) AS
3576:
3577: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
3578: SELECT birth_date
3579: FROM igs_pe_person_base_v
3580: WHERE person_id = cp_person_id;
3581:
3582: CURSOR terr_name_cur(cp_territory_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE) IS
3583: SELECT territory_short_name

Line 3587: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;

3583: SELECT territory_short_name
3584: FROM FND_TERRITORIES_VL
3585: WHERE territory_code = UPPER(cp_territory_code);
3586:
3587: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
3588: l_territory_short_name FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
3589: BEGIN
3590:
3591: