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 508: l_orig_sys_reference_rec.owner_table_name := 'HZ_PARTY_SITES';

504: and p_party_site_rec.orig_system <>fnd_api.g_miss_char
505: then
506: l_orig_sys_reference_rec.orig_system := p_party_site_rec.orig_system;
507: l_orig_sys_reference_rec.orig_system_reference := p_party_site_rec.orig_system_reference;
508: l_orig_sys_reference_rec.owner_table_name := 'HZ_PARTY_SITES';
509: l_orig_sys_reference_rec.owner_table_id := p_party_site_rec.party_site_id;
510: l_orig_sys_reference_rec.created_by_module := p_party_site_rec.created_by_module;
511:
512: hz_orig_system_ref_pub.create_orig_system_reference(

Line 629: | to HZ_PARTY_SITES.

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

Line 646: db_actual_content_source hz_party_sites.actual_content_source%TYPE;

642: l_object_version_number NUMBER;
643: l_rowid ROWID;
644: ldup_rowid ROWID;
645: db_identifying_address_flag VARCHAR2(1);
646: db_actual_content_source hz_party_sites.actual_content_source%TYPE;
647: db_party_id NUMBER;
648: db_location_id NUMBER;
649: db_status VARCHAR2(1);
650: l_identifying_location_id NUMBER;

Line 681: FROM HZ_PARTY_SITES

677: db_identifying_address_flag,
678: db_status,
679: l_rowid,
680: db_actual_content_source
681: FROM HZ_PARTY_SITES
682: WHERE PARTY_SITE_ID = p_party_site_rec.party_site_id
683: FOR UPDATE OF PARTY_SITE_ID NOWAIT;
684:
685: IF NOT

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

692: )
693: )
694: THEN
695: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
696: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
697: FND_MSG_PUB.ADD;
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;
700:

Line 785: FROM HZ_PARTY_SITES

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

Line 788: FROM hz_party_sites

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

Line 808: UPDATE HZ_PARTY_SITES

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

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

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

Line 871: HZ_PARTY_SITES_PKG.Update_Row (

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

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

913: );
914:
915: -- Debug info.
916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
917: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Update_Row (-) ',
918: p_prefix=>l_debug_prefix,
919: p_msg_level=>fnd_log.level_procedure);
920: END IF;
921: --

Line 1064: FROM HZ_PARTY_SITES

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

Line 1074: FROM HZ_PARTY_SITES PS

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

Line 1238: FROM HZ_PARTY_SITES

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

Line 1280: FROM HZ_PARTY_SITES

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

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

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

Line 1491: | unmark the identifying_address_flag in hz_party_sites

Line 1528: FROM hz_party_sites

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

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

1544: CLOSE c_party_sites;
1545: EXCEPTION
1546: WHEN OTHERS THEN
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1548: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITES');
1549: FND_MSG_PUB.ADD;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END;
1552:

Line 1554: UPDATE hz_party_sites

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

Line 1569: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(

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

Line 1621: FROM HZ_PARTY_SITES PS

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

Line 1798: p_db_object_name => 'HZ_PARTY_SITES',

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

Line 1838: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(

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

Line 2037: p_owner_table_name => 'HZ_PARTY_SITES',

2033: and (p_party_site_rec.party_site_id = FND_API.G_MISS_NUM or p_party_site_rec.party_site_id is null) THEN
2034: hz_orig_system_ref_pub.get_owner_table_id
2035: (p_orig_system => p_party_site_rec.orig_system,
2036: p_orig_system_reference => p_party_site_rec.orig_system_reference,
2037: p_owner_table_name => 'HZ_PARTY_SITES',
2038: x_owner_table_id => l_party_site_rec.party_site_id,
2039: x_return_status => x_return_status);
2040: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2041: RAISE FND_API.G_EXC_ERROR;

Line 2067: p_db_object_name => 'HZ_PARTY_SITES',

2063: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
2064: l_test_security :=
2065: hz_dss_util_pub.test_instance(
2066: p_operation_code => 'UPDATE',
2067: p_db_object_name => 'HZ_PARTY_SITES',
2068: p_instance_pk1_value => l_party_site_rec.party_site_id,
2069: p_user_name => fnd_global.user_name,
2070: x_return_status => dss_return_status,
2071: x_msg_count => dss_msg_count,

Line 2146: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(

2142: END IF;
2143:
2144: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2145: -- populate function for integration service
2146: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(
2147: p_operation => 'U',
2148: p_party_site_id => l_party_site_rec.party_site_id);
2149: END IF;
2150:

Line 2714: | to HZ_PARTY_SITES.

2710: |
2711: | MODIFICATION HISTORY
2712: |
2713: | 20-APR-2004 Rajib Ranjan Borah o Bug 3175816. Added global_location_number
2714: | to HZ_PARTY_SITES.
2715: +===========================================================================*/
2716:
2717: PROCEDURE get_party_site_rec (
2718: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 2750: HZ_PARTY_SITES_PKG.Select_Row (

2746: END IF;
2747:
2748: x_party_site_rec.party_site_id := p_party_site_id;
2749:
2750: HZ_PARTY_SITES_PKG.Select_Row (
2751: X_PARTY_SITE_ID => x_party_site_rec.party_site_id,
2752: X_PARTY_ID => x_party_site_rec.party_id,
2753: X_LOCATION_ID => x_party_site_rec.location_id,
2754: X_PARTY_SITE_NUMBER => x_party_site_rec.party_site_number,