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 397: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (+)',

393: CLOSE c_check_first_site;
394:
395: -- Debug info.
396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
397: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (+)',
398: p_prefix=>l_debug_prefix,
399: p_msg_level=>fnd_log.level_procedure);
400: END IF;
401:

Line 403: HZ_CUST_ACCT_SITES_PKG.Insert_Row (

399: p_msg_level=>fnd_log.level_procedure);
400: END IF;
401:
402: -- Call table-handler.
403: HZ_CUST_ACCT_SITES_PKG.Insert_Row (
404: X_CUST_ACCT_SITE_ID => p_cust_acct_site_rec.cust_acct_site_id,
405: X_CUST_ACCOUNT_ID => p_cust_acct_site_rec.cust_account_id,
406: X_PARTY_SITE_ID => p_cust_acct_site_rec.party_site_id,
407: X_ATTRIBUTE_CATEGORY => p_cust_acct_site_rec.attribute_category,

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

467:
468:
469: -- Debug info.
470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
471: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (-) ' ||
472: 'x_cust_acct_site_id = ' || p_cust_acct_site_rec.cust_acct_site_id,
473: p_prefix=>l_debug_prefix,
474: p_msg_level=>fnd_log.level_procedure);
475: END IF;

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

479: if (p_cust_acct_site_rec.orig_system is not null and p_cust_acct_site_rec.orig_system <>fnd_api.g_miss_char)
480: then
481: l_orig_sys_reference_rec.orig_system := p_cust_acct_site_rec.orig_system;
482: l_orig_sys_reference_rec.orig_system_reference := l_orig_system_reference;
483: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_ACCT_SITES_ALL';
484: l_orig_sys_reference_rec.owner_table_id := p_cust_acct_site_rec.cust_acct_site_id;
485: l_orig_sys_reference_rec.created_by_module := p_cust_acct_site_rec.created_by_module;
486:
487: hz_orig_system_ref_pub.create_orig_system_reference(

Line 505: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489

501:
502: SELECT LOC.LOCATION_ID INTO l_location_id
503: FROM HZ_LOCATIONS LOC,
504: HZ_PARTY_SITES PARTY_SITE,
505: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
506: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
507: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
508: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
509:

Line 550: FROM hz_cust_acct_sites_all -- Bug 3456489

546: BEGIN
547:
548: BEGIN
549: SELECT cust_account_id into l_cust_acct_id
550: FROM hz_cust_acct_sites_all -- Bug 3456489
551: WHERE cust_acct_site_id = p_cust_acct_site_id;
552: END;
553:
554:

Line 560: hz_cust_acct_sites_all cas, -- Bug 3456489

556: -- Modified for fix 3294182.
557: SELECT su.site_use_id,su.cust_acct_site_id
558: INTO l_site_use_id,l_cust_acct_site_id
559: FROM hz_cust_accounts a,
560: hz_cust_acct_sites_all cas, -- Bug 3456489
561: hz_cust_site_uses_all su -- Bug 3456489
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 592: * HZ_CUST_ACCT_SITES_PKG.Update_Row

588: * Private procedure to update customer account site.
589: *
590: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
591: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_acct_site
592: * HZ_CUST_ACCT_SITES_PKG.Update_Row
593: *
594: * ARGUMENTS
595: * IN/OUT:
596: * p_cust_acct_site_rec Customer account site record.

Line 641: select 'Y' from hz_cust_acct_sites_all

637:
638: /* 3456489 Added org_id for Shared Service Uptake */
639:
640: CURSOR check_orig_sys_ref IS
641: select 'Y' from hz_cust_acct_sites_all
642: where orig_system_reference =
643: p_cust_acct_site_rec.orig_system_reference
644: and org_id = p_cust_acct_site_rec.org_id;
645:

Line 650: l_party_site_id HZ_CUST_ACCT_SITES.party_site_id%TYPE;

646: l_orig_system_reference varchar2(255) :=p_cust_acct_site_rec.orig_system_reference;
647: l_tmp varchar2(1);
648: l_status varchar2(1);
649: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
650: l_party_site_id HZ_CUST_ACCT_SITES.party_site_id%TYPE;
651: -- l_ps_rowid ROWID := NULL;
652: l_ps_object_version_number NUMBER;
653: -- l_dummy VARCHAR2(1);
654:

Line 672: FROM HZ_CUST_ACCT_SITES

668: BEGIN
669: SELECT ROWID, OBJECT_VERSION_NUMBER,status, PARTY_SITE_ID, org_id
670: INTO l_rowid, l_object_version_number,l_status, l_party_site_id,
671: p_cust_acct_site_rec.org_id
672: FROM HZ_CUST_ACCT_SITES
673: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
674: FOR UPDATE NOWAIT;
675:
676: IF NOT (

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

679: l_object_version_number IS NOT NULL AND
680: p_object_version_number = l_object_version_number ) )
681: THEN
682: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
683: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_sites' );
684: FND_MSG_PUB.ADD;
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:

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

779: END IF; -- End of account site status check
780: END IF;
781: -- Debug info.
782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
783: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (+)',
784: p_prefix=>l_debug_prefix,
785: p_msg_level=>fnd_log.level_procedure);
786: END IF;
787:

Line 789: HZ_CUST_ACCT_SITES_PKG.Update_Row (

785: p_msg_level=>fnd_log.level_procedure);
786: END IF;
787:
788: -- Call table-handler.
789: HZ_CUST_ACCT_SITES_PKG.Update_Row (
790: X_Rowid => l_rowid,
791: X_CUST_ACCT_SITE_ID => p_cust_acct_site_rec.cust_acct_site_id,
792: X_CUST_ACCOUNT_ID => p_cust_acct_site_rec.cust_account_id,
793: X_PARTY_SITE_ID => p_cust_acct_site_rec.party_site_id,

Line 858: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489

854: -- Bug Fix : 2230802.
855: SELECT LOC.LOCATION_ID INTO l_location_id
856: FROM HZ_LOCATIONS LOC,
857: HZ_PARTY_SITES PARTY_SITE,
858: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
859: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
860: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
861: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
862:

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

879: END IF;
880:
881: -- Debug info.
882: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
883: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (-)',
884: p_prefix=>l_debug_prefix,
885: p_msg_level=>fnd_log.level_procedure);
886: END IF;
887:

Line 961: l_bill_to_flag HZ_CUST_ACCT_SITES.bill_to_flag%TYPE;

957: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
958: l_party_site_id NUMBER;
959: l_party_site_use_id NUMBER;
960: l_cust_account_profile_id NUMBER;
961: l_bill_to_flag HZ_CUST_ACCT_SITES.bill_to_flag%TYPE;
962: l_ship_to_flag HZ_CUST_ACCT_SITES.ship_to_flag%TYPE;
963: l_market_flag HZ_CUST_ACCT_SITES.market_flag%TYPE;
964: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
965:

Line 962: l_ship_to_flag HZ_CUST_ACCT_SITES.ship_to_flag%TYPE;

958: l_party_site_id NUMBER;
959: l_party_site_use_id NUMBER;
960: l_cust_account_profile_id NUMBER;
961: l_bill_to_flag HZ_CUST_ACCT_SITES.bill_to_flag%TYPE;
962: l_ship_to_flag HZ_CUST_ACCT_SITES.ship_to_flag%TYPE;
963: l_market_flag HZ_CUST_ACCT_SITES.market_flag%TYPE;
964: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
965:
966: l_cnt number := 1;

Line 963: l_market_flag HZ_CUST_ACCT_SITES.market_flag%TYPE;

959: l_party_site_use_id NUMBER;
960: l_cust_account_profile_id NUMBER;
961: l_bill_to_flag HZ_CUST_ACCT_SITES.bill_to_flag%TYPE;
962: l_ship_to_flag HZ_CUST_ACCT_SITES.ship_to_flag%TYPE;
963: l_market_flag HZ_CUST_ACCT_SITES.market_flag%TYPE;
964: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
965:
966: l_cnt number := 1;
967: l_cust_acct_id number;

Line 984: FROM HZ_CUST_ACCT_SITES_ALL

980: p_cust_site_use_rec.org_id = fnd_api.g_miss_num) then
981: BEGIN
982: SELECT org_id
983: INTO p_cust_site_use_rec.org_id
984: FROM HZ_CUST_ACCT_SITES_ALL
985: WHERE cust_acct_site_id
986: = p_cust_site_use_rec.cust_acct_site_id;
987: EXCEPTION
988: WHEN NO_DATA_FOUND THEN

Line 1044: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

1040: x_return_status := FND_API.G_RET_STS_SUCCESS;
1041: ELSE
1042: -- Create party site use
1043: SELECT PARTY_SITE_ID INTO l_party_site_id
1044: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1045: WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
1046:
1047: BEGIN
1048: SELECT 'Y' INTO l_dummy

Line 1102: FROM hz_cust_acct_sites_all -- Bug 3456489

1098: ELSE
1099:
1100: BEGIN
1101: SELECT cust_account_id into l_cust_acct_id
1102: FROM hz_cust_acct_sites_all -- Bug 3456489
1103: WHERE cust_acct_site_id = p_cust_site_use_rec.cust_acct_site_id;
1104: EXCEPTION
1105: WHEN NO_DATA_FOUND THEN
1106: l_cnt := 0;

Line 1116: hz_cust_acct_sites_all cas,

1112: -- Bug 6315081 : FORWARD PORT BUG 6132727
1113: -- New Query Below
1114: SELECT count(*) into l_cnt
1115: FROM hz_cust_accounts a,
1116: hz_cust_acct_sites_all cas,
1117: hz_cust_site_uses_all su
1118: WHERE
1119: a.cust_account_id = l_cust_acct_id
1120: and a.cust_account_id = cas.cust_account_id

Line 1129: FROM hz_cust_acct_sites_all cas,

1125: and cas.org_id = p_cust_site_use_rec.org_id -- TCA SSA Uptake (Bug 3456489)
1126: and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
1127:
1128: SELECT count(*) into l_cnt
1129: FROM hz_cust_acct_sites_all cas,
1130: hz_cust_site_uses_all su
1131: WHERE
1132: cas.cust_account_id = l_cust_acct_id
1133: and cas.status = 'A'

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

1292:
1293: end if;
1294:
1295: -- If this is a active bill_to or ship_to or market,
1296: -- set the appropriate denormalized flag in hz_cust_acct_sites.
1297:
1298: IF p_cust_site_use_rec.site_use_code IN ('BILL_TO', 'SHIP_TO', 'MARKET' ) THEN
1299: IF p_cust_site_use_rec.status = 'A' OR
1300: p_cust_site_use_rec.status IS NULL OR

Line 1328: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

1324: p_customer_profile_rec.created_by_module := p_cust_site_use_rec.created_by_module;
1325: p_customer_profile_rec.application_id := p_cust_site_use_rec.application_id;
1326:
1327: SELECT CUST_ACCOUNT_ID INTO p_customer_profile_rec.cust_account_id
1328: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1329: WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
1330:
1331: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
1332: p_customer_profile_rec => p_customer_profile_rec,

Line 1517: FROM HZ_CUST_ACCT_SITES_ALL

1513: ELSE
1514: -- Create party site use
1515:
1516: SELECT PARTY_SITE_ID INTO l_party_site_id
1517: FROM HZ_CUST_ACCT_SITES_ALL
1518: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
1519: BEGIN
1520: SELECT 'Y' INTO l_dummy
1521: FROM HZ_PARTY_SITE_USES

Line 1607: FROM hz_cust_acct_sites_all -- Bug 3456489

1603:
1604:
1605: BEGIN
1606: SELECT cust_account_id into l_cust_acct_id
1607: FROM hz_cust_acct_sites_all -- Bug 3456489
1608: WHERE cust_acct_site_id = l_cust_acct_site_id;
1609: EXCEPTION
1610: WHEN NO_DATA_FOUND THEN
1611: l_cnt := 0;

Line 1621: hz_cust_acct_sites_all cas,

1617: -- Bug 6315081 : FORWARD PORT BUG 6132727
1618: -- New Query Below
1619: SELECT count(*) into l_cnt
1620: FROM hz_cust_accounts a,
1621: hz_cust_acct_sites_all cas,
1622: hz_cust_site_uses_all su
1623: WHERE
1624: a.cust_account_id = l_cust_acct_id
1625: and a.cust_account_id = cas.cust_account_id

Line 1635: FROM hz_cust_acct_sites_all cas,

1631: and cas.org_id = p_cust_site_use_rec.org_id -- TCA SSA Uptake (Bug 3456489)
1632: and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
1633:
1634: SELECT count(*) into l_cnt
1635: FROM hz_cust_acct_sites_all cas,
1636: hz_cust_site_uses_all su
1637: WHERE
1638: cas.cust_account_id = l_cust_acct_id
1639: and cas.status = 'A'

Line 1666: FROM hz_cust_acct_sites_all -- Bug 3456489

1662: p_cust_site_use_rec.primary_flag := 'N';
1663:
1664: BEGIN
1665: SELECT cust_account_id into l_cust_acct_id
1666: FROM hz_cust_acct_sites_all -- Bug 3456489
1667: WHERE cust_acct_site_id = l_cust_acct_site_id;
1668: EXCEPTION
1669: WHEN NO_DATA_FOUND THEN
1670: l_cnt := 0;

Line 1677: hz_cust_acct_sites_all cas, -- Bug 3456489

1673: IF l_cnt > 0 THEN
1674: BEGIN
1675: SELECT min(su.rowid),count(*) into l_minrowid,l_cnt
1676: FROM hz_cust_accounts a,
1677: hz_cust_acct_sites_all cas, -- Bug 3456489
1678: hz_cust_site_uses_all su -- Bug 3456489
1679: WHERE
1680: a.cust_account_id = l_cust_acct_id
1681: and a.cust_account_id = cas.cust_account_id

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

1823: p_msg_level=>fnd_log.level_procedure);
1824: END IF;
1825:
1826: -- If this is a active bill_to or ship_to or market,
1827: -- set the appropriate denormalized flag in hz_cust_acct_sites.
1828: -- Please note, primary_flag cannot be updated to NULL.
1829:
1830: IF l_site_use_code IN ('BILL_TO', 'SHIP_TO', 'MARKET' )
1831: THEN

Line 1902: * in hz_cust_acct_sites.

1898: * PRIVATE PROCEDURE denormalize_site_use_flag
1899: *
1900: * DESCRIPTION
1901: * Private procedure to denormalize bill_to_flag, ship_to_flag, market_flag
1902: * in hz_cust_acct_sites.
1903: *
1904: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1905: *
1906: * ARGUMENTS

Line 1940: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

1936: END IF;
1937:
1938:
1939: IF p_site_use_code = 'BILL_TO' THEN
1940: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1941: SET BILL_TO_FLAG = p_flag
1942: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
1943: ELSIF p_site_use_code = 'SHIP_TO' THEN
1944: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

Line 1944: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

1940: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1941: SET BILL_TO_FLAG = p_flag
1942: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
1943: ELSIF p_site_use_code = 'SHIP_TO' THEN
1944: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1945: SET SHIP_TO_FLAG = p_flag
1946: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
1947: ELSIF p_site_use_code = 'MARKET' THEN
1948: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

Line 1948: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

1944: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1945: SET SHIP_TO_FLAG = p_flag
1946: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
1947: ELSIF p_site_use_code = 'MARKET' THEN
1948: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1949: SET MARKET_FLAG = p_flag
1950: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
1951: END IF;
1952:

Line 2061: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(

2057: END IF;
2058:
2059: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2060: -- populate function for integration service
2061: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(
2062: p_operation => 'I',
2063: p_cust_acct_site_id => x_cust_acct_site_id );
2064: END IF;
2065: END IF;

Line 2246: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',

2242:
2243: hz_orig_system_ref_pub.get_owner_table_id
2244: (p_orig_system => p_cust_acct_site_rec.orig_system,
2245: p_orig_system_reference => p_cust_acct_site_rec.orig_system_reference,
2246: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',
2247: x_owner_table_id => l_cust_acct_site_rec.cust_acct_site_id,
2248: x_return_status => x_return_status);
2249: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2250: RAISE FND_API.G_EXC_ERROR;

Line 2300: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(

2296: END IF;
2297:
2298: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2299: -- populate function for integration service
2300: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(
2301: p_operation => 'U',
2302: p_cust_acct_site_id => l_cust_acct_site_rec.cust_acct_site_id );
2303: END IF;
2304: END IF;

Line 2417: * HZ_CUST_ACCT_SITES_PKG.Select_Row

2413: * DESCRIPTION
2414: * Gets customer account site record
2415: *
2416: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2417: * HZ_CUST_ACCT_SITES_PKG.Select_Row
2418: *
2419: * ARGUMENTS
2420: * IN:
2421: * p_init_msg_list Initialize message stack if it is set to

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

2480: x_cust_acct_site_rec.cust_acct_site_id := p_cust_acct_site_id;
2481:
2482: -- Debug info.
2483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2484: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Select_Row (+)',
2485: p_prefix=>l_debug_prefix,
2486: p_msg_level=>fnd_log.level_procedure);
2487: END IF;
2488:

Line 2490: HZ_CUST_ACCT_SITES_PKG.Select_Row (

2486: p_msg_level=>fnd_log.level_procedure);
2487: END IF;
2488:
2489: -- Call table-handler.
2490: HZ_CUST_ACCT_SITES_PKG.Select_Row (
2491: X_CUST_ACCT_SITE_ID => x_cust_acct_site_rec.cust_acct_site_id,
2492: X_CUST_ACCOUNT_ID => x_cust_acct_site_rec.cust_account_id,
2493: X_PARTY_SITE_ID => x_cust_acct_site_rec.party_site_id,
2494: X_ATTRIBUTE_CATEGORY => x_cust_acct_site_rec.attribute_category,

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

2551: );
2552:
2553: -- Debug info.
2554: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2555: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_ACCT_SITES_PKG.Select_Row (-)',
2556: p_prefix=>l_debug_prefix,
2557: p_msg_level=>fnd_log.level_procedure);
2558: END IF;
2559: