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_PARTY_CONTACT_V2PUB dependencies on HZ_ORG_CONTACTS

Line 204: FROM HZ_ORG_CONTACTS

200: THEN
201: BEGIN
202: SELECT 'Y'
203: INTO l_dummy
204: FROM HZ_ORG_CONTACTS
205: WHERE ORG_CONTACT_ID = l_org_contact_id;
206:
207: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
208: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_contact_id');

Line 231: FROM HZ_ORG_CONTACTS

227:
228: BEGIN
229: SELECT 1
230: INTO l_count
231: FROM HZ_ORG_CONTACTS
232: WHERE CONTACT_NUMBER = l_contact_number;
233: l_count := 1;
234:
235: EXCEPTION

Line 356: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (+)',

352: END IF;
353:
354: -- Debug info.
355: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
356: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (+)',
357: p_prefix=>l_debug_prefix,
358: p_msg_level=>fnd_log.level_procedure);
359: END IF;
360:

Line 362: HZ_ORG_CONTACTS_PKG.Insert_Row (

358: p_msg_level=>fnd_log.level_procedure);
359: END IF;
360:
361: -- call table-handler.
362: HZ_ORG_CONTACTS_PKG.Insert_Row (
363: X_ORG_CONTACT_ID => p_org_contact_rec.org_contact_id,
364: X_PARTY_RELATIONSHIP_ID => x_party_rel_id,
365: X_COMMENTS => p_org_contact_rec.comments,
366: X_CONTACT_NUMBER => l_contact_number,

Line 410: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (-)',

406: );
407:
408: -- Debug info.
409: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
410: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (-)',
411: p_prefix=>l_debug_prefix,
412: p_msg_level=>fnd_log.level_procedure);
413: END IF;
414:

Line 422: l_orig_sys_reference_rec.owner_table_name := 'HZ_ORG_CONTACTS';

418: and p_org_contact_rec.orig_system <>fnd_api.g_miss_char
419: then
420: l_orig_sys_reference_rec.orig_system := p_org_contact_rec.orig_system;
421: l_orig_sys_reference_rec.orig_system_reference := p_org_contact_rec.orig_system_reference;
422: l_orig_sys_reference_rec.owner_table_name := 'HZ_ORG_CONTACTS';
423: l_orig_sys_reference_rec.owner_table_id := p_org_contact_rec.org_contact_id;
424: l_orig_sys_reference_rec.created_by_module := p_org_contact_rec.created_by_module;
425:
426: hz_orig_system_ref_pub.create_orig_system_reference(

Line 475: | do not fetch it from HZ_ORG_CONTACTS.

471: |
472: | MODIFICATION HISTORY
473: | 28-SEP-2007 Neeraj Shinde BUG# 6335274:1.relationship_id is non-updatable field.
474: | If relationship_id is not supplied,
475: | do not fetch it from HZ_ORG_CONTACTS.
476: | 2.If update_relationship API results
477: | in error, Error has to be raised.
478: +===========================================================================*/
479:

Line 515: FROM HZ_ORG_CONTACTS

511: SELECT ROWID,
512: OBJECT_VERSION_NUMBER
513: INTO l_rowid,
514: l_object_version_number
515: FROM HZ_ORG_CONTACTS
516: WHERE ORG_CONTACT_ID = p_org_contact_rec.org_contact_id
517: FOR UPDATE OF ORG_CONTACT_ID NOWAIT;
518:
519: IF NOT (

Line 526: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_org_contacts' );

522: l_object_version_number IS NOT NULL AND
523: p_cont_object_version_number = l_object_version_number ) )
524: THEN
525: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
526: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_org_contacts' );
527: FND_MSG_PUB.ADD;
528: RAISE FND_API.G_EXC_ERROR;
529: END IF;
530:

Line 590: FROM HZ_ORG_CONTACTS

586: /*
587: SELECT ROWID,
588: PARTY_RELATIONSHIP_ID
589: INTO l_rowid, l_party_relationship_id
590: FROM HZ_ORG_CONTACTS
591: WHERE ORG_CONTACT_ID = p_org_contact_rec.org_contact_id;*/
592:
593: IF (l_party_relationship_id IS NOT NULL) THEN
594: --user passes optional relationship_id

Line 598: FROM HZ_ORG_CONTACTS

594: --user passes optional relationship_id
595: SELECT ROWID,
596: PARTY_RELATIONSHIP_ID
597: INTO l_rowid, l_party_relationship_id
598: FROM HZ_ORG_CONTACTS
599: WHERE ORG_CONTACT_ID = p_org_contact_rec.org_contact_id;
600: END IF;
601: --BUG# 6335274: End
602:

Line 612: FROM HZ_PARTIES P, HZ_RELATIONSHIPS R, HZ_ORG_CONTACTS C

608: THEN
609: BEGIN
610: SELECT P.PERSON_PRE_NAME_ADJUNCT,P.PARTY_ID INTO
611: l_person_pre_name,l_party_id
612: FROM HZ_PARTIES P, HZ_RELATIONSHIPS R, HZ_ORG_CONTACTS C
613: WHERE
614: C.ORG_CONTACT_ID = p_org_contact_rec.org_contact_id
615: AND R.RELATIONSHIP_ID = C.PARTY_RELATIONSHIP_ID
616: AND R.DIRECTIONAL_FLAG = 'F'

Line 648: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (+) ',

644: end if;
645:
646: -- Debug info.
647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (+) ',
649: p_prefix=>l_debug_prefix,
650: p_msg_level=>fnd_log.level_procedure);
651: END IF;
652: -- call to table-handler

Line 653: HZ_ORG_CONTACTS_PKG.Update_Row (

649: p_prefix=>l_debug_prefix,
650: p_msg_level=>fnd_log.level_procedure);
651: END IF;
652: -- call to table-handler
653: HZ_ORG_CONTACTS_PKG.Update_Row (
654: X_Rowid => l_rowid,
655: X_ORG_CONTACT_ID => p_org_contact_rec.org_contact_id,
656: X_PARTY_RELATIONSHIP_ID => p_org_contact_rec.party_rel_rec.relationship_id,
657: X_COMMENTS => p_org_contact_rec.comments,

Line 701: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (-) ',

697: X_STATUS => l_org_status
698: );
699: -- Debug info.
700: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
701: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (-) ',
702: p_prefix=>l_debug_prefix,
703: p_msg_level=>fnd_log.level_procedure);
704: END IF;
705:

Line 706: -- update party relationship. party_relationship_id in hz_org_contacts is

702: p_prefix=>l_debug_prefix,
703: p_msg_level=>fnd_log.level_procedure);
704: END IF;
705:
706: -- update party relationship. party_relationship_id in hz_org_contacts is
707: -- non-updateable and l_party_relationship_id is selected from table.
708: IF nvl(p_rel_object_version_number, 1) <> FND_API.G_MISS_NUM
709: THEN
710: IF l_party_relationship_id IS NOT NULL THEN

Line 1212: HZ_POPULATE_BOT_PKG.pop_hz_org_contacts(

1208: END IF;
1209:
1210: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1211: -- populate function for integration service
1212: HZ_POPULATE_BOT_PKG.pop_hz_org_contacts(
1213: p_operation => 'I',
1214: p_org_contact_id => x_org_contact_id);
1215: END IF;
1216: END IF;

Line 1407: p_owner_table_name => 'HZ_ORG_CONTACTS',

1403: and (p_org_contact_rec.org_contact_id = FND_API.G_MISS_NUM or p_org_contact_rec.org_contact_id is null) THEN
1404: hz_orig_system_ref_pub.get_owner_table_id
1405: (p_orig_system => p_org_contact_rec.orig_system,
1406: p_orig_system_reference => p_org_contact_rec.orig_system_reference,
1407: p_owner_table_name => 'HZ_ORG_CONTACTS',
1408: x_owner_table_id => l_org_contact_rec.org_contact_id,
1409: x_return_status => x_return_status);
1410: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1411: RAISE FND_API.G_EXC_ERROR;

Line 1464: HZ_POPULATE_BOT_PKG.pop_hz_org_contacts(

1460: END IF;
1461:
1462: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1463: -- populate function for integration service
1464: HZ_POPULATE_BOT_PKG.pop_hz_org_contacts(
1465: p_operation => 'U',
1466: p_org_contact_id => l_org_contact_rec.org_contact_id);
1467: END IF;
1468: END IF;

Line 2045: HZ_ORG_CONTACTS_PKG.Select_Row (

2041: END IF;
2042:
2043: x_org_contact_rec.org_contact_id := p_org_contact_id;
2044:
2045: HZ_ORG_CONTACTS_PKG.Select_Row (
2046: X_ORG_CONTACT_ID => x_org_contact_rec.org_contact_id,
2047: X_PARTY_RELATIONSHIP_ID => l_party_relationship_id,
2048: X_COMMENTS => x_org_contact_rec.comments,
2049: X_CONTACT_NUMBER => x_org_contact_rec.contact_number,