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 2924: -- HZ_PARTIES_PK, HZ_PARTIES_U2

2920: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
2921:
2922: x_return_status := FND_API.G_RET_STS_ERROR;
2923:
2924: -- HZ_PARTIES_PK, HZ_PARTIES_U2
2925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2927: FND_MSG_PUB.ADD;
2928:

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

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

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

3225: p.status status,
3226: ps.party_id,
3227: ps.new_osr_exists_flag,
3228: ps.old_orig_system_reference
3229: FROM HZ_IMP_PARTIES_INT pi, HZ_IMP_PARTIES_SG ps, HZ_PARTIES p,
3230: HZ_PERSON_PROFILES pp,
3231: HZ_ORGANIZATION_PROFILES op,
3232: fnd_lookup_values party_type_l,
3233: fnd_lookup_values month_l,

Line 4533: /* Update HZ_PARTIES */

4529: hz_utility_v2pub.debug('count = ' || l_party_orig_system_reference.count);
4530:
4531:
4532: /******************************/
4533: /*** Update HZ_PARTIES ***/
4534: /******************************/
4535:
4536: /* Loop to handle duplicate party_id or party_number exceptions. Only
4537: needed for hz_parties. When inserting into hz_organization_profiles or

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

4533: /*** Update HZ_PARTIES ***/
4534: /******************************/
4535:
4536: /* Loop to handle duplicate party_id or party_number exceptions. Only
4537: needed for hz_parties. When inserting into hz_organization_profiles or
4538: hz_person_profiles, l_num_row_processed is used to determine if an interface
4539: record was inserted successfully, which excludes problem with duplicate
4540: party_id as well. So this problem will not be reported again. Then when
4541: inserting into profiles table, whenever there is any exception, just

Line 4543: hz_parties */

4539: record was inserted successfully, which excludes problem with duplicate
4540: party_id as well. So this problem will not be reported again. Then when
4541: inserting into profiles table, whenever there is any exception, just
4542: exit as it'll be some unknown error not encountered while updating into
4543: hz_parties */
4544:
4545: BEGIN
4546: IF l_content_source_type = 'USER_ENTERED' OR
4547: l_org_mixnmatch_enabled = 'N' OR l_per_mixnmatch_enabled = 'N' THEN

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

4545: BEGIN
4546: IF l_content_source_type = 'USER_ENTERED' OR
4547: l_org_mixnmatch_enabled = 'N' OR l_per_mixnmatch_enabled = 'N' THEN
4548:
4549: /* Update hz_parties. Update party_name and other columns that are
4550: supposed to be denormalized from SST only if OS is USER_ENTERED
4551: and mix and match disabled. Otherwise, mix and match proc will update
4552: party name */
4553: ForAll j in 1..l_party_orig_system_reference.count SAVE EXCEPTIONS

Line 4554: update hz_parties set

4550: supposed to be denormalized from SST only if OS is USER_ENTERED
4551: and mix and match disabled. Otherwise, mix and match proc will update
4552: party name */
4553: ForAll j in 1..l_party_orig_system_reference.count SAVE EXCEPTIONS
4554: update hz_parties set
4555: PARTY_NAME = decode(l_party_type(j), 'PERSON', l_person_name(j), l_party_name(j)),
4556: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
4557: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
4558: SALUTATION =

Line 4885: /* Update hz_parties */

4881: and l_dss_security_errors(j) = 'T'
4882: and l_party_name(j) is not null
4883: and l_tca_party_id(j) is not null;
4884: ELSE
4885: /* Update hz_parties */
4886: ForAll j in 1..l_party_orig_system_reference.count SAVE EXCEPTIONS
4887: update hz_parties set
4888: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
4889: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,

Line 4887: update hz_parties set

4883: and l_tca_party_id(j) is not null;
4884: ELSE
4885: /* Update hz_parties */
4886: ForAll j in 1..l_party_orig_system_reference.count SAVE EXCEPTIONS
4887: update hz_parties set
4888: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
4889: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
4890: SALUTATION =
4891: DECODE(l_salutation(j),

Line 9246: and OWNER_TABLE_NAME = 'HZ_PARTIES'

9242: OBJECT_VERSION_NUMBER = NVL(OBJECT_VERSION_NUMBER,1)+1
9243: where
9244: ORIG_SYSTEM = l_party_orig_system(j)
9245: and ORIG_SYSTEM_REFERENCE = l_old_orig_system_reference(j)
9246: and OWNER_TABLE_NAME = 'HZ_PARTIES'
9247: and OWNER_TABLE_ID = l_party_id(j)
9248: and l_num_row_processed(j) = 1
9249: and status = 'A'
9250: and trunc(nvl(end_date_active, P_DML_RECORD.SYSDATE)) >= trunc(P_DML_RECORD.SYSDATE);

Line 9269: and OWNER_TABLE_NAME = 'HZ_PARTIES'

9265: OBJECT_VERSION_NUMBER = NVL(OBJECT_VERSION_NUMBER,1)+1
9266: where
9267: ORIG_SYSTEM = l_party_orig_system(j)
9268: and ORIG_SYSTEM_REFERENCE = l_party_orig_system_reference(j)
9269: and OWNER_TABLE_NAME = 'HZ_PARTIES'
9270: and l_new_osr_exists(j) in ('Y', 'R')
9271: and l_num_row_processed(j) = 1
9272: and status = 'A'
9273: and trunc(nvl(end_date_active, P_DML_RECORD.SYSDATE)) >= trunc(P_DML_RECORD.SYSDATE);

Line 9301: 'HZ_PARTIES',

9297: select
9298: HZ_ORIG_SYSTEM_REF_S.NEXTVAL,
9299: l_party_orig_system(j),
9300: l_party_orig_system_reference(j),
9301: 'HZ_PARTIES',
9302: l_party_id(j),
9303: l_party_id(j),
9304: 'A',
9305: l_old_orig_system_reference(j),

Line 9353: 'HZ_PARTIES',

9349: select
9350: HZ_ORIG_SYSTEM_REF_S.NEXTVAL,
9351: l_party_orig_system(j),
9352: l_party_orig_system_reference(j),
9353: 'HZ_PARTIES',
9354: l_party_id(j),
9355: l_party_id(j),
9356: 'A',
9357: P_DML_RECORD.SYSDATE,

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

9442: FND_GLOBAL.User_ID CREATED_BY,
9443: SYSDATE LAST_UPDATE_DATE,
9444: FND_GLOBAL.User_ID LAST_UPDATED_BY,
9445: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
9446: FROM HZ_PARTIES party,HZ_IMP_PARTIES_SG ps, HZ_IMP_PARTIES_INT pint
9447: WHERE party.request_id = p_request_id
9448: AND party.party_id = ps.party_id
9449: AND ps.batch_mode_flag = p_batch_mode_flag
9450: AND ps.batch_id = p_batch_id