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.HZ_IMP_LOAD_PARTIES_PKG dependencies on HZ_PARTIES

Line 271: 'HZ_PARTIES',

267: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE24', l_attr24(i));
268:
269: IF (NOT FND_FLEX_DESCVAL.validate_desccols(
270: 'AR',
271: 'HZ_PARTIES',
272: 'V',
273: p_validation_date)) THEN
274: l_flex_val_errors(i) := 1;
275: END IF;

Line 341: 'HZ_PARTIES',

337: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE24', p_attr24);
338:
339: IF (FND_FLEX_DESCVAL.validate_desccols(
340: 'AR',
341: 'HZ_PARTIES',
342: 'V',
343: p_validation_date)) THEN
344: return 'Y';
345: ELSE

Line 371: p_db_object_name => 'HZ_PARTIES',

367: FOR i IN 1..l_party_orig_system_reference.count LOOP
368: l_dss_security_errors(i) :=
369: hz_dss_util_pub.test_instance(
370: p_operation_code => 'UPDATE',
371: p_db_object_name => 'HZ_PARTIES',
372: p_instance_pk1_value => l_party_id(i),
373: p_user_name => fnd_global.user_name,
374: x_return_status => dss_return_status,
375: x_msg_count => dss_msg_count,

Line 537: decode(l_flex_val_errors(j),'1', null, 'Y'), --????? AR_RAPI_DESC_FLEX_INVALID,DFF_NAME,HZ_PARTIES

533: decode(l_party_type(j), 'PERSON', nvl2(l_death_date_errors(j),'Y', null), 'Y'), --HZ_API_DATE_GREATER,DATE2,SYSDATE,DATE1,DATE_OF_DEATH
534: decode(l_party_type(j), 'PERSON', nvl2(l_birth_death_errors(j),'Y', null), 'Y'), --HZ_API_DATE_GREATER,DATE2,DATE_OF_DEATH,DATE1,DATE_OF_BIRTH
535: nvl2(l_party_type_errors(j),'Y', null), --HZ_IMP_PARTY_TYPE_ERROR
536: nvl2(l_own_rent_errors(j),'Y', null), --HZ_API_INVALID_LOOKUP,COLUMN,RENT_OWN_IND,LOOKUP_TYPE,OWN_RENT_IND
537: decode(l_flex_val_errors(j),'1', null, 'Y'), --????? AR_RAPI_DESC_FLEX_INVALID,DFF_NAME,HZ_PARTIES
538: nvl2(l_tca_party_id(j), nvl2(l_party_name(j),'Y', null), 'Y'), --HZ_IMP_PARTY_NAME_ERROR
539: -- Bug 3871136
540: decode(l_dss_security_errors(j), FND_API.G_FALSE,decode(l_party_type(j),'PERSON','P',
541: 'ORGANIZATION','O',null),'Y'), --HZ_DSS_SECURITY_FAIL

Line 582: if(instr(P_SQL_ERRM, 'HZ_PARTIES_PK')>0) then

578:
579: /* other entities need to add checking for other constraints */
580: if (P_DUP_VAL_EXP = 'Y') then
581: other_exp_val := null;
582: if(instr(P_SQL_ERRM, 'HZ_PARTIES_PK')>0) then
583: dup_val_exp_val := 'A';
584: else -- '_U2'
585: dup_val_exp_val := 'B';
586: end if;

Line 703: ''HZ_PARTIES'',

699: :4, -- last_update_login
700: hz_orig_system_ref_s.nextval,
701: party_orig_system,
702: party_orig_system_reference,
703: ''HZ_PARTIES'',
704: party_id,
705: party_id,
706: ''A'',
707: :3, -- sysdate

Line 710: into hz_parties (

706: ''A'',
707: :3, -- sysdate
708: created_by_module,
709: 1)
710: into hz_parties (
711: application_id,
712: created_by,
713: creation_date,
714: last_updated_by,

Line 2928: -- HZ_PARTIES_PK, HZ_PARTIES_U2

2924: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
2925:
2926: x_return_status := FND_API.G_RET_STS_ERROR;
2927:
2928: -- HZ_PARTIES_PK, HZ_PARTIES_U2
2929: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2930: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2931: FND_MSG_PUB.ADD;
2932:

Line 2967: 'SELECT /*+ index(p, HZ_PARTIES_U1) use_nl(pi

2963: l_debug_prefix VARCHAR2(30) := '';
2964: --l_prof_version VARCHAR2(1000) := P_DML_RECORD.PROFILE_VERSION;
2965:
2966: l_update_sql varchar2(32767) :=
2967: 'SELECT /*+ index(p, HZ_PARTIES_U1) use_nl(pi
2968: party_type_l month_l legal_status_l local_bus_iden_type_l reg_type_l
2969: own_rent_l hq_branch_l tot_emp_est_l tot_emp_min_l tot_emp_ind_l
2970: emp_at_pri_adr_est_ind_l emp_at_pri_adr_min_ind_l marital_status_l
2971: contact_title_l gender_l person_iden_type_l) */

Line 3235: FROM HZ_IMP_PARTIES_INT pi, HZ_IMP_PARTIES_SG ps, HZ_PARTIES p,

3231: p.status status,
3232: ps.party_id,
3233: ps.new_osr_exists_flag,
3234: ps.old_orig_system_reference
3235: FROM HZ_IMP_PARTIES_INT pi, HZ_IMP_PARTIES_SG ps, HZ_PARTIES p,
3236: HZ_PERSON_PROFILES pp,
3237: HZ_ORGANIZATION_PROFILES op,
3238: fnd_lookup_values party_type_l,
3239: fnd_lookup_values month_l,

Line 4551: /* Update HZ_PARTIES */

4547: hz_utility_v2pub.debug('count = ' || l_party_orig_system_reference.count);
4548:
4549:
4550: /******************************/
4551: /*** Update HZ_PARTIES ***/
4552: /******************************/
4553:
4554: /* Loop to handle duplicate party_id or party_number exceptions. Only
4555: needed for hz_parties. When inserting into hz_organization_profiles or

Line 4555: needed for hz_parties. When inserting into hz_organization_profiles or

4551: /*** Update HZ_PARTIES ***/
4552: /******************************/
4553:
4554: /* Loop to handle duplicate party_id or party_number exceptions. Only
4555: needed for hz_parties. When inserting into hz_organization_profiles or
4556: hz_person_profiles, l_num_row_processed is used to determine if an interface
4557: record was inserted successfully, which excludes problem with duplicate
4558: party_id as well. So this problem will not be reported again. Then when
4559: inserting into profiles table, whenever there is any exception, just

Line 4561: hz_parties */

4557: record was inserted successfully, which excludes problem with duplicate
4558: party_id as well. So this problem will not be reported again. Then when
4559: inserting into profiles table, whenever there is any exception, just
4560: exit as it'll be some unknown error not encountered while updating into
4561: hz_parties */
4562:
4563: BEGIN
4564: IF l_content_source_type = 'USER_ENTERED' OR
4565: l_org_mixnmatch_enabled = 'N' OR l_per_mixnmatch_enabled = 'N' THEN

Line 4567: /* Update hz_parties. Update party_name and other columns that are

4563: BEGIN
4564: IF l_content_source_type = 'USER_ENTERED' OR
4565: l_org_mixnmatch_enabled = 'N' OR l_per_mixnmatch_enabled = 'N' THEN
4566:
4567: /* Update hz_parties. Update party_name and other columns that are
4568: supposed to be denormalized from SST only if OS is USER_ENTERED
4569: and mix and match disabled. Otherwise, mix and match proc will update
4570: party name */
4571: ForAll j in 1..l_party_orig_system_reference.count SAVE EXCEPTIONS

Line 4572: update hz_parties set

4568: supposed to be denormalized from SST only if OS is USER_ENTERED
4569: and mix and match disabled. Otherwise, mix and match proc will update
4570: party name */
4571: ForAll j in 1..l_party_orig_system_reference.count SAVE EXCEPTIONS
4572: update hz_parties set
4573: PARTY_NAME = decode(l_party_type(j), 'PERSON', l_person_name(j), l_party_name(j)),
4574: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
4575: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
4576: SALUTATION =

Line 4903: /* Update hz_parties */

4899: and l_dss_security_errors(j) = 'T'
4900: and l_party_name(j) is not null
4901: and l_tca_party_id(j) is not null;
4902: ELSE
4903: /* Update hz_parties */
4904: ForAll j in 1..l_party_orig_system_reference.count SAVE EXCEPTIONS
4905: update hz_parties set
4906: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
4907: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,

Line 4905: update hz_parties set

4901: and l_tca_party_id(j) is not null;
4902: ELSE
4903: /* Update hz_parties */
4904: ForAll j in 1..l_party_orig_system_reference.count SAVE EXCEPTIONS
4905: update hz_parties set
4906: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
4907: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
4908: SALUTATION =
4909: DECODE(l_salutation(j),

Line 9264: and OWNER_TABLE_NAME = 'HZ_PARTIES'

9260: OBJECT_VERSION_NUMBER = NVL(OBJECT_VERSION_NUMBER,1)+1
9261: where
9262: ORIG_SYSTEM = l_party_orig_system(j)
9263: and ORIG_SYSTEM_REFERENCE = l_old_orig_system_reference(j)
9264: and OWNER_TABLE_NAME = 'HZ_PARTIES'
9265: and OWNER_TABLE_ID = l_party_id(j)
9266: and l_num_row_processed(j) = 1
9267: and status = 'A'
9268: and trunc(nvl(end_date_active, P_DML_RECORD.SYSDATE)) >= trunc(P_DML_RECORD.SYSDATE);

Line 9287: and OWNER_TABLE_NAME = 'HZ_PARTIES'

9283: OBJECT_VERSION_NUMBER = NVL(OBJECT_VERSION_NUMBER,1)+1
9284: where
9285: ORIG_SYSTEM = l_party_orig_system(j)
9286: and ORIG_SYSTEM_REFERENCE = l_party_orig_system_reference(j)
9287: and OWNER_TABLE_NAME = 'HZ_PARTIES'
9288: and l_new_osr_exists(j) in ('Y', 'R')
9289: and l_num_row_processed(j) = 1
9290: and status = 'A'
9291: and trunc(nvl(end_date_active, P_DML_RECORD.SYSDATE)) >= trunc(P_DML_RECORD.SYSDATE);

Line 9319: 'HZ_PARTIES',

9315: select
9316: HZ_ORIG_SYSTEM_REF_S.NEXTVAL,
9317: l_party_orig_system(j),
9318: l_party_orig_system_reference(j),
9319: 'HZ_PARTIES',
9320: l_party_id(j),
9321: l_party_id(j),
9322: 'A',
9323: l_old_orig_system_reference(j),

Line 9371: 'HZ_PARTIES',

9367: select
9368: HZ_ORIG_SYSTEM_REF_S.NEXTVAL,
9369: l_party_orig_system(j),
9370: l_party_orig_system_reference(j),
9371: 'HZ_PARTIES',
9372: l_party_id(j),
9373: l_party_id(j),
9374: 'A',
9375: P_DML_RECORD.SYSDATE,

Line 9464: FROM HZ_PARTIES party,HZ_IMP_PARTIES_SG ps, HZ_IMP_PARTIES_INT pint

9460: FND_GLOBAL.User_ID CREATED_BY,
9461: SYSDATE LAST_UPDATE_DATE,
9462: FND_GLOBAL.User_ID LAST_UPDATED_BY,
9463: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
9464: FROM HZ_PARTIES party,HZ_IMP_PARTIES_SG ps, HZ_IMP_PARTIES_INT pint
9465: WHERE party.request_id = p_request_id
9466: AND party.party_id = ps.party_id
9467: AND ps.batch_mode_flag = p_batch_mode_flag
9468: AND ps.batch_id = p_batch_id