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_SITE_V2PUB dependencies on HZ_PARTY_SITES

Line 204: | to HZ_PARTY_SITES.

200: |
201: | MODIFICATION HISTORY
202: |
203: | 19-APR-2004 Rajib Ranjan Borah o Bug 3175816. Added GLOBAL_LOCATION_NUMBER
204: | to HZ_PARTY_SITES.
205: | 04-JAN-2005 Rajib Ranjan Borah o SSM SST Integration and Extension.
206: | For non-profile entities, the concept of
207: | select/de-select data-sources is obsoleted.
208: +===========================================================================*/

Line 225: -- hz_party_sites from hz_locations.

221: l_dummy VARCHAR2(1);
222: l_debug_prefix VARCHAR2(30) := '';
223:
224: -- Bug 2197181: Added l_loc_actual_content_source to denormalize actual_content_source into
225: -- hz_party_sites from hz_locations.
226:
227: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;
228: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
229: l_msg_count NUMBER;

Line 249: FROM HZ_PARTY_SITES

245: THEN
246: BEGIN
247: SELECT 'Y'
248: INTO l_dummy
249: FROM HZ_PARTY_SITES
250: WHERE PARTY_SITE_ID = l_party_site_id;
251:
252: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
253: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_id');

Line 284: FROM HZ_PARTY_SITES

280:
281: BEGIN
282: SELECT 'Y'
283: INTO l_dummy
284: FROM HZ_PARTY_SITES
285: WHERE PARTY_SITE_NUMBER = l_party_site_number;
286:
287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
288: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_number');

Line 316: -- actual_content_source into hz_party_sites from hz_locations.

312:
313: x_party_site_number := l_party_site_number;
314:
315: -- Bug 2197181: Added l_loc_actual_content_source to denormalize
316: -- actual_content_source into hz_party_sites from hz_locations.
317:
318: HZ_REGISTRY_VALIDATE_V2PUB.validate_party_site(
319: 'C',
320: p_party_site_rec,

Line 373: FROM HZ_PARTY_SITES

369: -- For non-profile entities, the concept of select/de-select data-sources is obsoleted.
370: -- There is no need to check if the data-source is selected.
371:
372: SELECT 'Y' INTO l_dummy
373: FROM HZ_PARTY_SITES
374: WHERE PARTY_ID = p_party_site_rec.party_id
375: AND STATUS = 'A'
376: /* AND HZ_MIXNM_UTILITY.isDataSourceSelected (
377: g_pst_selected_datasources, actual_content_source ) = 'Y'*/

Line 446: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Insert_Row (+)',

442:
443:
444: -- Debug info.
445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
446: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Insert_Row (+)',
447: p_prefix=>l_debug_prefix,
448: p_msg_level=>fnd_log.level_procedure);
449: END IF;
450:

Line 452: HZ_PARTY_SITES_PKG.Insert_Row (

448: p_msg_level=>fnd_log.level_procedure);
449: END IF;
450:
451: -- call table-handler.
452: HZ_PARTY_SITES_PKG.Insert_Row (
453: X_PARTY_SITE_ID => p_party_site_rec.party_site_id,
454: X_PARTY_ID => p_party_site_rec.party_id,
455: X_LOCATION_ID => p_party_site_rec.location_id,
456: X_PARTY_SITE_NUMBER => p_party_site_rec.party_site_number,

Line 497: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Insert_Row (-) ' ||

493:
494:
495: -- Debug info.
496: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
497: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Insert_Row (-) ' ||
498: 'x_party_site_id = ' || p_party_site_rec.party_site_id,
499: p_prefix=>l_debug_prefix,
500: p_msg_level=>fnd_log.level_procedure);
501: END IF;

Line 512: l_orig_sys_reference_rec.owner_table_name := 'HZ_PARTY_SITES';

508: and p_party_site_rec.orig_system <>fnd_api.g_miss_char
509: then
510: l_orig_sys_reference_rec.orig_system := p_party_site_rec.orig_system;
511: l_orig_sys_reference_rec.orig_system_reference := p_party_site_rec.orig_system_reference;
512: l_orig_sys_reference_rec.owner_table_name := 'HZ_PARTY_SITES';
513: l_orig_sys_reference_rec.owner_table_id := p_party_site_rec.party_site_id;
514: l_orig_sys_reference_rec.created_by_module := p_party_site_rec.created_by_module;
515:
516: hz_orig_system_ref_pub.create_orig_system_reference(

Line 633: | to HZ_PARTY_SITES.

629: | the only site present is made inactive.
630: | 28-OCT-2003 Ramesh Ch Bug#2914238. Updated who columns.
631: |
632: | 19-APR-2004 Rajib Ranjan Borah o Bug 3175816. Added GLOBAL_LOCATION_NUMBER
633: | to HZ_PARTY_SITES.
634: | 04-JAN-2005 Rajib Ranjan Borah o SSM SST Integration and Extension.
635: | For non-profile entities, the concept of
636: | select/de-select data-sources is obsoleted.
637: |

Line 650: db_actual_content_source hz_party_sites.actual_content_source%TYPE;

646: l_object_version_number NUMBER;
647: l_rowid ROWID;
648: ldup_rowid ROWID;
649: db_identifying_address_flag VARCHAR2(1);
650: db_actual_content_source hz_party_sites.actual_content_source%TYPE;
651: db_party_id NUMBER;
652: db_location_id NUMBER;
653: db_status VARCHAR2(1);
654: l_identifying_location_id NUMBER;

Line 685: FROM HZ_PARTY_SITES

681: db_identifying_address_flag,
682: db_status,
683: l_rowid,
684: db_actual_content_source
685: FROM HZ_PARTY_SITES
686: WHERE PARTY_SITE_ID = p_party_site_rec.party_site_id
687: FOR UPDATE OF PARTY_SITE_ID NOWAIT;
688:
689: IF NOT

Line 700: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');

696: )
697: )
698: THEN
699: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
700: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
701: FND_MSG_PUB.ADD;
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704:

Line 789: FROM HZ_PARTY_SITES

785: -- Check if any other active, visible, party site is present.
786:
787: SELECT ROWID, location_id
788: INTO ldup_rowid, l_identifying_location_id
789: FROM HZ_PARTY_SITES
790: WHERE party_site_id = (
791: SELECT min(party_site_id)
792: FROM hz_party_sites
793: WHERE party_id = db_party_id

Line 792: FROM hz_party_sites

788: INTO ldup_rowid, l_identifying_location_id
789: FROM HZ_PARTY_SITES
790: WHERE party_site_id = (
791: SELECT min(party_site_id)
792: FROM hz_party_sites
793: WHERE party_id = db_party_id
794: AND status = 'A'
795: AND party_site_id <> p_party_site_rec.party_site_id
796: -- Bug 2197181: added for mix-n-match project: the identifying_flag

Line 812: UPDATE HZ_PARTY_SITES

808: -- set the new party site as identifying address and
809: -- set the current record as non identifying address.
810:
811: IF p_party_site_rec.status = 'I' THEN
812: UPDATE HZ_PARTY_SITES
813: SET IDENTIFYING_ADDRESS_FLAG = 'Y',
814: last_update_date = hz_utility_v2pub.last_update_date,
815: last_updated_by = hz_utility_v2pub.last_updated_by,
816: last_update_login = hz_utility_v2pub.last_update_login,

Line 869: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Update_Row (+) ',

865: end if;
866:
867: -- Debug info.
868: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
869: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Update_Row (+) ',
870: p_prefix=>l_debug_prefix,
871: p_msg_level=>fnd_log.level_procedure);
872: END IF;
873:

Line 875: HZ_PARTY_SITES_PKG.Update_Row (

871: p_msg_level=>fnd_log.level_procedure);
872: END IF;
873:
874: --Call to table-handler
875: HZ_PARTY_SITES_PKG.Update_Row (
876: X_Rowid => l_rowid,
877: X_PARTY_SITE_ID => p_party_site_rec.party_site_id,
878: X_PARTY_ID => p_party_site_rec.party_id,
879: X_LOCATION_ID => p_party_site_rec.location_id,

Line 921: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Update_Row (-) ',

917: );
918:
919: -- Debug info.
920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
921: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Update_Row (-) ',
922: p_prefix=>l_debug_prefix,
923: p_msg_level=>fnd_log.level_procedure);
924: END IF;
925: --

Line 1068: FROM HZ_PARTY_SITES

1064: -- if this is the first active party site use per type,,
1065: -- we need to mark it with primary_per_type = 'Y'.
1066: SELECT PARTY_ID
1067: INTO l_party_id
1068: FROM HZ_PARTY_SITES
1069: WHERE PARTY_SITE_ID = p_party_site_use_rec.party_site_id;
1070:
1071:
1072: BEGIN

Line 1078: FROM HZ_PARTY_SITES PS

1074: INTO l_exist
1075: FROM HZ_PARTY_SITE_USES SU
1076: WHERE PARTY_SITE_ID IN (
1077: SELECT PARTY_SITE_ID
1078: FROM HZ_PARTY_SITES PS
1079: WHERE PS.PARTY_ID = l_party_id )
1080: AND SU.SITE_USE_TYPE = p_party_site_use_rec.site_use_type
1081: AND STATUS = 'A' -- Bug 2065191
1082: AND ROWNUM = 1;

Line 1242: FROM HZ_PARTY_SITES

1238: BEGIN
1239: -- Modified for Bug Fix: 3651716
1240: SELECT PARTY_ID
1241: INTO l_party_id
1242: FROM HZ_PARTY_SITES
1243: WHERE PARTY_SITE_ID = l_party_site_id;
1244:
1245: IF p_party_site_use_rec.primary_per_type = 'Y' AND
1246: p_party_site_use_rec.status = 'I' AND

Line 1284: FROM HZ_PARTY_SITES

1280: SELECT min(PARTY_SITE_USE_ID)
1281: FROM HZ_PARTY_SITE_USES
1282: WHERE PARTY_SITE_ID IN (
1283: SELECT PARTY_SITE_ID
1284: FROM HZ_PARTY_SITES
1285: WHERE PARTY_ID = l_party_id )
1286: AND STATUS = 'A'
1287: AND SITE_USE_TYPE = l_site_use_type
1288: AND PARTY_SITE_USE_ID <> p_party_site_use_rec.party_site_use_id);

Line 1319: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');

1315: WHEN NO_DATA_FOUND THEN
1316: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1317: FND_MESSAGE.SET_TOKEN('FK', 'party site id');
1318: FND_MESSAGE.SET_TOKEN('COLUMN', 'party site id');
1319: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
1320: FND_MSG_PUB.ADD;
1321: RAISE FND_API.G_EXC_ERROR;
1322: END;
1323:

Line 1495: | unmark the identifying_address_flag in hz_party_sites

Line 1532: FROM hz_party_sites

1528: ) IS
1529:
1530: CURSOR c_party_sites IS
1531: SELECT rowid, party_site_id
1532: FROM hz_party_sites
1533: WHERE party_id = p_party_id
1534: AND party_site_id <> nvl(p_party_site_id,-999)
1535: AND identifying_address_flag = 'Y'
1536: AND rownum = 1

Line 1552: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITES');

1548: CLOSE c_party_sites;
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1552: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITES');
1553: FND_MSG_PUB.ADD;
1554: RAISE FND_API.G_EXC_ERROR;
1555: END;
1556:

Line 1558: UPDATE hz_party_sites

1554: RAISE FND_API.G_EXC_ERROR;
1555: END;
1556:
1557: IF l_rowid IS NOT NULL THEN
1558: UPDATE hz_party_sites
1559: SET identifying_address_flag= 'N',
1560: --Bug number 2914238 .Updated the who columns.
1561: last_update_date = hz_utility_v2pub.last_update_date,
1562: last_updated_by = hz_utility_v2pub.last_updated_by,

Line 1573: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(

1569:
1570: --bug #5203798
1571: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1572: -- populate function for integration service
1573: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(
1574: p_operation => p_mode,
1575: p_party_site_id => l_party_site_id);
1576: END IF;
1577:

Line 1625: FROM HZ_PARTY_SITES PS

1621: SELECT ROWID, PARTY_SITE_USE_ID
1622: FROM HZ_PARTY_SITE_USES SU
1623: WHERE SU.PARTY_SITE_ID IN (
1624: SELECT PS.PARTY_SITE_ID
1625: FROM HZ_PARTY_SITES PS
1626: WHERE PARTY_ID = p_party_id )
1627: AND SU.PARTY_SITE_ID <> p_party_site_id
1628: AND SU.SITE_USE_TYPE = p_site_use_type
1629: AND SU.PRIMARY_PER_TYPE = 'Y'

Line 1802: p_db_object_name => 'HZ_PARTY_SITES',

1798: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
1799: l_test_security :=
1800: hz_dss_util_pub.test_instance(
1801: p_operation_code => 'INSERT',
1802: p_db_object_name => 'HZ_PARTY_SITES',
1803: p_instance_pk1_value => x_party_site_id,
1804: p_user_name => fnd_global.user_name,
1805: x_return_status => dss_return_status,
1806: x_msg_count => dss_msg_count,

Line 1842: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(

1838: END IF;
1839:
1840: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1841: -- populate function for integration service
1842: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(
1843: p_operation => 'I',
1844: p_party_site_id => x_party_site_id);
1845: END IF;
1846:

Line 2044: p_owner_table_name => 'HZ_PARTY_SITES',

2040: and (p_party_site_rec.party_site_id = FND_API.G_MISS_NUM or p_party_site_rec.party_site_id is null) THEN
2041: hz_orig_system_ref_pub.get_owner_table_id
2042: (p_orig_system => p_party_site_rec.orig_system,
2043: p_orig_system_reference => p_party_site_rec.orig_system_reference,
2044: p_owner_table_name => 'HZ_PARTY_SITES',
2045: x_owner_table_id => l_party_site_rec.party_site_id,
2046: x_return_status => x_return_status);
2047: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2048: RAISE FND_API.G_EXC_ERROR;

Line 2074: p_db_object_name => 'HZ_PARTY_SITES',

2070: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
2071: l_test_security :=
2072: hz_dss_util_pub.test_instance(
2073: p_operation_code => 'UPDATE',
2074: p_db_object_name => 'HZ_PARTY_SITES',
2075: p_instance_pk1_value => l_party_site_rec.party_site_id,
2076: p_user_name => fnd_global.user_name,
2077: x_return_status => dss_return_status,
2078: x_msg_count => dss_msg_count,

Line 2153: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(

2149: END IF;
2150:
2151: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2152: -- populate function for integration service
2153: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(
2154: p_operation => 'U',
2155: p_party_site_id => l_party_site_rec.party_site_id);
2156: END IF;
2157:

Line 2721: | to HZ_PARTY_SITES.

2717: |
2718: | MODIFICATION HISTORY
2719: |
2720: | 20-APR-2004 Rajib Ranjan Borah o Bug 3175816. Added global_location_number
2721: | to HZ_PARTY_SITES.
2722: +===========================================================================*/
2723:
2724: PROCEDURE get_party_site_rec (
2725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 2757: HZ_PARTY_SITES_PKG.Select_Row (

2753: END IF;
2754:
2755: x_party_site_rec.party_site_id := p_party_site_id;
2756:
2757: HZ_PARTY_SITES_PKG.Select_Row (
2758: X_PARTY_SITE_ID => x_party_site_rec.party_site_id,
2759: X_PARTY_ID => x_party_site_rec.party_id,
2760: X_LOCATION_ID => x_party_site_rec.location_id,
2761: X_PARTY_SITE_NUMBER => x_party_site_rec.party_site_number,