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_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_CUST_ACCT_SITES

Line 147: * HZ_CUST_ACCT_SITES_PKG.Insert_Row

143: * Private procedure to create customer account site.
144: *
145: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
146: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_acct_site
147: * HZ_CUST_ACCT_SITES_PKG.Insert_Row
148: *
149: * ARGUMENTS
150: * IN/OUT:
151: * p_cust_acct_site_rec Customer account site record.

Line 199: select 'Y' from hz_cust_acct_sites_all

195: l_cust_acct_site_orig_sys VARCHAR2(255);
196:
197: /* 3456489 Added org_id for Shared Service Uptake */
198: CURSOR check_orig_sys_ref IS
199: select 'Y' from hz_cust_acct_sites_all
200: where orig_system_reference =
201: p_cust_acct_site_rec.orig_system_reference
202: and org_id = p_cust_acct_site_rec.org_id;
203:

Line 217: FROM hz_cust_acct_sites_all

213: p_cust_account_id NUMBER,
214: p_org_id NUMBER
215: ) IS
216: SELECT null
217: FROM hz_cust_acct_sites_all
218: WHERE cust_account_id = p_cust_account_id
219: AND org_id = p_org_id
220: AND status NOT IN ('M', 'D')
221: AND ROWNUM = 1;

Line 408: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (+)',

404: CLOSE c_check_first_site;
405:
406: -- Debug info.
407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
408: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (+)',
409: p_prefix=>l_debug_prefix,
410: p_msg_level=>fnd_log.level_procedure);
411: END IF;
412:

Line 414: HZ_CUST_ACCT_SITES_PKG.Insert_Row (

410: p_msg_level=>fnd_log.level_procedure);
411: END IF;
412:
413: -- Call table-handler.
414: HZ_CUST_ACCT_SITES_PKG.Insert_Row (
415: X_CUST_ACCT_SITE_ID => p_cust_acct_site_rec.cust_acct_site_id,
416: X_CUST_ACCOUNT_ID => p_cust_acct_site_rec.cust_account_id,
417: X_PARTY_SITE_ID => p_cust_acct_site_rec.party_site_id,
418: X_ATTRIBUTE_CATEGORY => p_cust_acct_site_rec.attribute_category,

Line 482: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (-) ' ||

478:
479:
480: -- Debug info.
481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
482: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (-) ' ||
483: 'x_cust_acct_site_id = ' || p_cust_acct_site_rec.cust_acct_site_id,
484: p_prefix=>l_debug_prefix,
485: p_msg_level=>fnd_log.level_procedure);
486: END IF;

Line 494: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_ACCT_SITES_ALL';

490: if (p_cust_acct_site_rec.orig_system is not null and p_cust_acct_site_rec.orig_system <>fnd_api.g_miss_char)
491: then
492: l_orig_sys_reference_rec.orig_system := p_cust_acct_site_rec.orig_system;
493: l_orig_sys_reference_rec.orig_system_reference := l_orig_system_reference;
494: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_ACCT_SITES_ALL';
495: l_orig_sys_reference_rec.owner_table_id := p_cust_acct_site_rec.cust_acct_site_id;
496: l_orig_sys_reference_rec.created_by_module := p_cust_acct_site_rec.created_by_module;
497:
498: hz_orig_system_ref_pub.create_orig_system_reference(

Line 516: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489

512:
513: SELECT LOC.LOCATION_ID INTO l_location_id
514: FROM HZ_LOCATIONS LOC,
515: HZ_PARTY_SITES PARTY_SITE,
516: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
517: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
518: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
519: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
520:

Line 560: hz_cust_acct_sites_all cas,

556:
557: CURSOR c_site (l_cust_acct_id VARCHAR2) IS
558: SELECT su.site_use_id,su.cust_acct_site_id
559: FROM hz_cust_accounts a,
560: hz_cust_acct_sites_all cas,
561: hz_cust_site_uses_all su
562: WHERE a.cust_account_id = l_cust_acct_id
563: AND l_cust_acct_id = cas.cust_account_id
564: AND cas.cust_acct_site_id = su.cust_acct_site_id

Line 579: FROM hz_cust_acct_sites_all -- Bug 3456489

575: BEGIN
576:
577: BEGIN
578: SELECT cust_account_id into l_cust_acct_id
579: FROM hz_cust_acct_sites_all -- Bug 3456489
580: WHERE cust_acct_site_id = p_cust_acct_site_id;
581: END;
582:
583:

Line 589: hz_cust_acct_sites_all cas, -- Bug 3456489

585: -- Modified for fix 3294182.
586: SELECT su.site_use_id,su.cust_acct_site_id
587: INTO l_site_use_id,l_cust_acct_site_id
588: FROM hz_cust_accounts a,
589: hz_cust_acct_sites_all cas, -- Bug 3456489
590: hz_cust_site_uses_all su -- Bug 3456489
591: WHERE a.cust_account_id = l_cust_acct_id
592: AND l_cust_acct_id = cas.cust_account_id
593: AND cas.cust_acct_site_id = su.cust_acct_site_id

Line 671: * HZ_CUST_ACCT_SITES_PKG.Update_Row

667: * Private procedure to update customer account site.
668: *
669: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
670: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_acct_site
671: * HZ_CUST_ACCT_SITES_PKG.Update_Row
672: *
673: * ARGUMENTS
674: * IN/OUT:
675: * p_cust_acct_site_rec Customer account site record.

Line 720: select 'Y' from hz_cust_acct_sites_all

716:
717: /* 3456489 Added org_id for Shared Service Uptake */
718:
719: CURSOR check_orig_sys_ref IS
720: select 'Y' from hz_cust_acct_sites_all
721: where orig_system_reference =
722: p_cust_acct_site_rec.orig_system_reference
723: and org_id = p_cust_acct_site_rec.org_id;
724:

Line 729: l_party_site_id HZ_CUST_ACCT_SITES.party_site_id%TYPE;

725: l_orig_system_reference varchar2(255) :=p_cust_acct_site_rec.orig_system_reference;
726: l_tmp varchar2(1);
727: l_status varchar2(1);
728: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
729: l_party_site_id HZ_CUST_ACCT_SITES.party_site_id%TYPE;
730: -- l_ps_rowid ROWID := NULL;
731: l_ps_object_version_number NUMBER;
732: -- l_dummy VARCHAR2(1);
733:

Line 751: FROM HZ_CUST_ACCT_SITES

747: BEGIN
748: SELECT ROWID, OBJECT_VERSION_NUMBER,status, PARTY_SITE_ID, org_id
749: INTO l_rowid, l_object_version_number,l_status, l_party_site_id,
750: p_cust_acct_site_rec.org_id
751: FROM HZ_CUST_ACCT_SITES
752: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
753: FOR UPDATE NOWAIT;
754:
755: IF NOT (

Line 762: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_sites' );

758: l_object_version_number IS NOT NULL AND
759: p_object_version_number = l_object_version_number ) )
760: THEN
761: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
762: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_sites' );
763: FND_MSG_PUB.ADD;
764: RAISE FND_API.G_EXC_ERROR;
765: END IF;
766:

Line 862: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (+)',

858: END IF; -- End of account site status check
859: END IF;
860: -- Debug info.
861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
862: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (+)',
863: p_prefix=>l_debug_prefix,
864: p_msg_level=>fnd_log.level_procedure);
865: END IF;
866:

Line 870: HZ_CUST_ACCT_SITES_PKG.Update_Row (

866:
867: --Bug10332578
868: --X_STATUS is set back to Acct Site Status to handle bad data issues.
869: -- Call table-handler.
870: HZ_CUST_ACCT_SITES_PKG.Update_Row (
871: X_Rowid => l_rowid,
872: X_CUST_ACCT_SITE_ID => p_cust_acct_site_rec.cust_acct_site_id,
873: X_CUST_ACCOUNT_ID => p_cust_acct_site_rec.cust_account_id,
874: X_PARTY_SITE_ID => p_cust_acct_site_rec.party_site_id,

Line 940: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489

936: -- Bug Fix : 2230802.
937: SELECT LOC.LOCATION_ID INTO l_location_id
938: FROM HZ_LOCATIONS LOC,
939: HZ_PARTY_SITES PARTY_SITE,
940: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
941: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
942: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
943: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
944:

Line 965: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (-)',

961: END IF;
962:
963: -- Debug info.
964: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
965: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (-)',
966: p_prefix=>l_debug_prefix,
967: p_msg_level=>fnd_log.level_procedure);
968: END IF;
969:

Line 1043: l_bill_to_flag HZ_CUST_ACCT_SITES.bill_to_flag%TYPE;

1039: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
1040: l_party_site_id NUMBER;
1041: l_party_site_use_id NUMBER;
1042: l_cust_account_profile_id NUMBER;
1043: l_bill_to_flag HZ_CUST_ACCT_SITES.bill_to_flag%TYPE;
1044: l_ship_to_flag HZ_CUST_ACCT_SITES.ship_to_flag%TYPE;
1045: l_market_flag HZ_CUST_ACCT_SITES.market_flag%TYPE;
1046: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1047:

Line 1044: l_ship_to_flag HZ_CUST_ACCT_SITES.ship_to_flag%TYPE;

1040: l_party_site_id NUMBER;
1041: l_party_site_use_id NUMBER;
1042: l_cust_account_profile_id NUMBER;
1043: l_bill_to_flag HZ_CUST_ACCT_SITES.bill_to_flag%TYPE;
1044: l_ship_to_flag HZ_CUST_ACCT_SITES.ship_to_flag%TYPE;
1045: l_market_flag HZ_CUST_ACCT_SITES.market_flag%TYPE;
1046: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1047:
1048: l_cnt number := 1;

Line 1045: l_market_flag HZ_CUST_ACCT_SITES.market_flag%TYPE;

1041: l_party_site_use_id NUMBER;
1042: l_cust_account_profile_id NUMBER;
1043: l_bill_to_flag HZ_CUST_ACCT_SITES.bill_to_flag%TYPE;
1044: l_ship_to_flag HZ_CUST_ACCT_SITES.ship_to_flag%TYPE;
1045: l_market_flag HZ_CUST_ACCT_SITES.market_flag%TYPE;
1046: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1047:
1048: l_cnt number := 1;
1049: l_cust_acct_id number;

Line 1076: FROM HZ_CUST_ACCT_SITES_ALL

1072: p_cust_site_use_rec.org_id = fnd_api.g_miss_num) then
1073: BEGIN
1074: SELECT org_id
1075: INTO p_cust_site_use_rec.org_id
1076: FROM HZ_CUST_ACCT_SITES_ALL
1077: WHERE cust_acct_site_id
1078: = p_cust_site_use_rec.cust_acct_site_id;
1079: EXCEPTION
1080: WHEN NO_DATA_FOUND THEN

Line 1136: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

1132: x_return_status := FND_API.G_RET_STS_SUCCESS;
1133: ELSE
1134: -- Create party site use
1135: SELECT PARTY_SITE_ID INTO l_party_site_id
1136: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1137: WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
1138:
1139: BEGIN
1140: SELECT 'Y' INTO l_dummy

Line 1194: FROM hz_cust_acct_sites_all -- Bug 3456489

1190: ELSE
1191:
1192: BEGIN
1193: SELECT cust_account_id into l_cust_acct_id
1194: FROM hz_cust_acct_sites_all -- Bug 3456489
1195: WHERE cust_acct_site_id = p_cust_site_use_rec.cust_acct_site_id;
1196: EXCEPTION
1197: WHEN NO_DATA_FOUND THEN
1198: l_cnt := 0;

Line 1208: hz_cust_acct_sites_all cas,

1204: -- Bug 6315081 : FORWARD PORT BUG 6132727
1205: -- New Query Below
1206: SELECT count(*) into l_cnt
1207: FROM hz_cust_accounts a,
1208: hz_cust_acct_sites_all cas,
1209: hz_cust_site_uses_all su
1210: WHERE
1211: a.cust_account_id = l_cust_acct_id
1212: and a.cust_account_id = cas.cust_account_id

Line 1221: FROM hz_cust_acct_sites_all cas,

1217: and cas.org_id = p_cust_site_use_rec.org_id -- TCA SSA Uptake (Bug 3456489)
1218: and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
1219:
1220: SELECT count(*) into l_cnt
1221: FROM hz_cust_acct_sites_all cas,
1222: hz_cust_site_uses_all su
1223: WHERE
1224: cas.cust_account_id = l_cust_acct_id
1225: and cas.status = 'A'

Line 1427: -- set the appropriate denormalized flag in hz_cust_acct_sites.

1423:
1424: end if;
1425:
1426: -- If this is a active bill_to or ship_to or market,
1427: -- set the appropriate denormalized flag in hz_cust_acct_sites.
1428:
1429: IF p_cust_site_use_rec.site_use_code IN ('BILL_TO', 'SHIP_TO', 'MARKET' ) THEN
1430: IF p_cust_site_use_rec.status = 'A' OR
1431: p_cust_site_use_rec.status IS NULL OR

Line 1459: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

1455: p_customer_profile_rec.created_by_module := p_cust_site_use_rec.created_by_module;
1456: p_customer_profile_rec.application_id := p_cust_site_use_rec.application_id;
1457:
1458: SELECT CUST_ACCOUNT_ID INTO p_customer_profile_rec.cust_account_id
1459: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1460: WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
1461:
1462: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
1463: p_customer_profile_rec => p_customer_profile_rec,

Line 1648: FROM HZ_CUST_ACCT_SITES_ALL

1644: ELSE
1645: -- Create party site use
1646:
1647: SELECT PARTY_SITE_ID INTO l_party_site_id
1648: FROM HZ_CUST_ACCT_SITES_ALL
1649: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
1650: BEGIN
1651: SELECT 'Y' INTO l_dummy
1652: FROM HZ_PARTY_SITE_USES

Line 1738: FROM hz_cust_acct_sites_all -- Bug 3456489

1734:
1735:
1736: BEGIN
1737: SELECT cust_account_id into l_cust_acct_id
1738: FROM hz_cust_acct_sites_all -- Bug 3456489
1739: WHERE cust_acct_site_id = l_cust_acct_site_id;
1740: EXCEPTION
1741: WHEN NO_DATA_FOUND THEN
1742: l_cnt := 0;

Line 1752: hz_cust_acct_sites_all cas,

1748: -- Bug 6315081 : FORWARD PORT BUG 6132727
1749: -- New Query Below
1750: SELECT count(*) into l_cnt
1751: FROM hz_cust_accounts a,
1752: hz_cust_acct_sites_all cas,
1753: hz_cust_site_uses_all su
1754: WHERE
1755: a.cust_account_id = l_cust_acct_id
1756: and a.cust_account_id = cas.cust_account_id

Line 1766: FROM hz_cust_acct_sites_all cas,

1762: and cas.org_id = p_cust_site_use_rec.org_id -- TCA SSA Uptake (Bug 3456489)
1763: and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
1764:
1765: SELECT count(*) into l_cnt
1766: FROM hz_cust_acct_sites_all cas,
1767: hz_cust_site_uses_all su
1768: WHERE
1769: cas.cust_account_id = l_cust_acct_id
1770: and cas.status = 'A'

Line 1797: FROM hz_cust_acct_sites_all -- Bug 3456489

1793: p_cust_site_use_rec.primary_flag := 'N';
1794:
1795: BEGIN
1796: SELECT cust_account_id into l_cust_acct_id
1797: FROM hz_cust_acct_sites_all -- Bug 3456489
1798: WHERE cust_acct_site_id = l_cust_acct_site_id;
1799: EXCEPTION
1800: WHEN NO_DATA_FOUND THEN
1801: l_cnt := 0;

Line 1808: hz_cust_acct_sites_all cas, -- Bug 3456489

1804: IF l_cnt > 0 THEN
1805: BEGIN
1806: SELECT min(su.rowid),count(*) into l_minrowid,l_cnt
1807: FROM hz_cust_accounts a,
1808: hz_cust_acct_sites_all cas, -- Bug 3456489
1809: hz_cust_site_uses_all su -- Bug 3456489
1810: WHERE
1811: a.cust_account_id = l_cust_acct_id
1812: and a.cust_account_id = cas.cust_account_id

Line 1960: -- set the appropriate denormalized flag in hz_cust_acct_sites.

1956: p_msg_level=>fnd_log.level_procedure);
1957: END IF;
1958:
1959: -- If this is a active bill_to or ship_to or market,
1960: -- set the appropriate denormalized flag in hz_cust_acct_sites.
1961: -- Please note, primary_flag cannot be updated to NULL.
1962:
1963: IF l_site_use_code IN ('BILL_TO', 'SHIP_TO', 'MARKET' )
1964: THEN

Line 2035: * in hz_cust_acct_sites.

2031: * PRIVATE PROCEDURE denormalize_site_use_flag
2032: *
2033: * DESCRIPTION
2034: * Private procedure to denormalize bill_to_flag, ship_to_flag, market_flag
2035: * in hz_cust_acct_sites.
2036: *
2037: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2038: *
2039: * ARGUMENTS

Line 2073: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

2069: END IF;
2070:
2071:
2072: IF p_site_use_code = 'BILL_TO' THEN
2073: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
2074: SET BILL_TO_FLAG = p_flag,
2075: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
2076: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
2077: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;

Line 2079: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

2075: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
2076: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
2077: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2078: ELSIF p_site_use_code = 'SHIP_TO' THEN
2079: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
2080: SET SHIP_TO_FLAG = p_flag,
2081: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
2082: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
2083: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;

Line 2085: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

2081: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
2082: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
2083: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2084: ELSIF p_site_use_code = 'MARKET' THEN
2085: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
2086: SET MARKET_FLAG = p_flag,
2087: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
2088: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
2089: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;

Line 2200: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(

2196: END IF;
2197:
2198: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2199: -- populate function for integration service
2200: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(
2201: p_operation => 'I',
2202: p_cust_acct_site_id => x_cust_acct_site_id );
2203: END IF;
2204: END IF;

Line 2385: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',

2381:
2382: hz_orig_system_ref_pub.get_owner_table_id
2383: (p_orig_system => p_cust_acct_site_rec.orig_system,
2384: p_orig_system_reference => p_cust_acct_site_rec.orig_system_reference,
2385: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',
2386: x_owner_table_id => l_cust_acct_site_rec.cust_acct_site_id,
2387: x_return_status => x_return_status);
2388: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2389: RAISE FND_API.G_EXC_ERROR;

Line 2439: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(

2435: END IF;
2436:
2437: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2438: -- populate function for integration service
2439: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(
2440: p_operation => 'U',
2441: p_cust_acct_site_id => l_cust_acct_site_rec.cust_acct_site_id );
2442: END IF;
2443: END IF;

Line 2556: * HZ_CUST_ACCT_SITES_PKG.Select_Row

2552: * DESCRIPTION
2553: * Gets customer account site record
2554: *
2555: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2556: * HZ_CUST_ACCT_SITES_PKG.Select_Row
2557: *
2558: * ARGUMENTS
2559: * IN:
2560: * p_init_msg_list Initialize message stack if it is set to

Line 2623: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Select_Row (+)',

2619: x_cust_acct_site_rec.cust_acct_site_id := p_cust_acct_site_id;
2620:
2621: -- Debug info.
2622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2623: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Select_Row (+)',
2624: p_prefix=>l_debug_prefix,
2625: p_msg_level=>fnd_log.level_procedure);
2626: END IF;
2627:

Line 2629: HZ_CUST_ACCT_SITES_PKG.Select_Row (

2625: p_msg_level=>fnd_log.level_procedure);
2626: END IF;
2627:
2628: -- Call table-handler.
2629: HZ_CUST_ACCT_SITES_PKG.Select_Row (
2630: X_CUST_ACCT_SITE_ID => x_cust_acct_site_rec.cust_acct_site_id,
2631: X_CUST_ACCOUNT_ID => x_cust_acct_site_rec.cust_account_id,
2632: X_PARTY_SITE_ID => x_cust_acct_site_rec.party_site_id,
2633: X_ATTRIBUTE_CATEGORY => x_cust_acct_site_rec.attribute_category,

Line 2694: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_ACCT_SITES_PKG.Select_Row (-)',

2690: );
2691:
2692: -- Debug info.
2693: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2694: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_ACCT_SITES_PKG.Select_Row (-)',
2695: p_prefix=>l_debug_prefix,
2696: p_msg_level=>fnd_log.level_procedure);
2697: END IF;
2698: