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_V2PUB dependencies on HZ_CUST_ACCOUNTS

Line 138: * HZ_CUST_ACCOUNTS_PKG.Insert_Row

134: * Private procedure to create customer account.
135: *
136: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
137: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_account
138: * HZ_CUST_ACCOUNTS_PKG.Insert_Row
139: * HZ_PARTY_V2PUB.create_person
140: * HZ_PARTY_V2PUB.create_organization
141: * HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile
142: *

Line 217: select 'Y' from hz_cust_accounts

213: l_cust_account_profile_id NUMBER;
214: l_orig_system_ref_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
215:
216: CURSOR check_orig_sys_ref IS
217: select 'Y' from hz_cust_accounts
218: where ORIG_SYSTEM_REFERENCE = p_cust_account_rec.orig_system_reference;
219: l_orig_system_reference varchar2(255) :=p_cust_account_rec.orig_system_reference;
220: l_tmp varchar2(1);
221:

Line 231: FROM hz_cust_accounts

227: p_party_id NUMBER,
228: p_cust_account_id NUMBER
229: ) IS
230: SELECT null
231: FROM hz_cust_accounts
232: WHERE party_id = p_party_id
233: AND status = 'A'
234: AND cust_account_id <> p_cust_account_id
235: AND rownum = 1;

Line 454: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (+) ',

450:
451:
452: -- Debug info.
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (+) ',
455: p_prefix=>l_debug_prefix,
456: p_msg_level=>fnd_log.level_procedure);
457: END IF;
458:

Line 460: HZ_CUST_ACCOUNTS_PKG.Insert_Row (

456: p_msg_level=>fnd_log.level_procedure);
457: END IF;
458:
459: -- Call table-handler.
460: HZ_CUST_ACCOUNTS_PKG.Insert_Row (
461: X_CUST_ACCOUNT_ID => p_cust_account_rec.cust_account_id,
462: X_PARTY_ID => l_party_id,
463: X_ACCOUNT_NUMBER => p_cust_account_rec.account_number,
464: X_ATTRIBUTE_CATEGORY => p_cust_account_rec.attribute_category,

Line 567: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (-) ' ||

563: );
564:
565: -- Debug info.
566: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
567: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (-) ' ||
568: 'x_cust_account_id = ' || p_cust_account_rec.cust_account_id || ' ' ||
569: 'x_account_number = ' || p_cust_account_rec.account_number,
570: p_prefix=>l_debug_prefix,
571: p_msg_level=>fnd_log.level_procedure);

Line 578: l_orig_system_ref_rec.owner_table_name := 'HZ_CUST_ACCOUNTS';

574: if (p_cust_account_rec.orig_system is not null and p_cust_account_rec.orig_system <>fnd_api.g_miss_char)
575: then
576: l_orig_system_ref_rec.orig_system := p_cust_account_rec.orig_system;
577: l_orig_system_ref_rec.orig_system_reference := l_orig_system_reference;
578: l_orig_system_ref_rec.owner_table_name := 'HZ_CUST_ACCOUNTS';
579: l_orig_system_ref_rec.owner_table_id := p_cust_account_rec.cust_account_id;
580: l_orig_system_ref_rec.created_by_module := p_cust_account_rec.created_by_module;
581:
582: hz_orig_system_ref_pub.create_orig_system_reference(

Line 698: * HZ_CUST_ACCOUNTS_PKG.Update_Row

694: * Private procedure to update customer account.
695: *
696: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
697: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_account
698: * HZ_CUST_ACCOUNTS_PKG.Update_Row
699: *
700: * ARGUMENTS
701: * IN/OUT:
702: * p_cust_account_rec Customer account record.

Line 731: select 'Y' from hz_cust_accounts

727: l_object_version_number NUMBER;
728: l_orig_system_ref_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
729:
730: CURSOR check_orig_sys_ref IS
731: select 'Y' from hz_cust_accounts
732: where ORIG_SYSTEM_REFERENCE = p_cust_account_rec.orig_system_reference;
733:
734: l_orig_system_reference varchar2(255) :=p_cust_account_rec.orig_system_reference;
735: l_tmp varchar2(1);

Line 749: FROM hz_cust_accounts

745: p_party_id NUMBER,
746: p_cust_account_id NUMBER
747: ) IS
748: SELECT null
749: FROM hz_cust_accounts
750: WHERE party_id = p_party_id
751: AND status = 'A'
752: AND cust_account_id <> p_cust_account_id
753: AND rownum = 1;

Line 769: FROM HZ_CUST_ACCOUNTS

765: -- Lock record.
766: BEGIN
767: SELECT ROWID, OBJECT_VERSION_NUMBER, party_id, status
768: INTO l_rowid, l_object_version_number, l_party_id, l_status
769: FROM HZ_CUST_ACCOUNTS
770: WHERE CUST_ACCOUNT_ID = p_cust_account_rec.cust_account_id
771: FOR UPDATE NOWAIT;
772:
773: IF NOT (

Line 780: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );

776: l_object_version_number IS NOT NULL AND
777: p_object_version_number = l_object_version_number ) )
778: THEN
779: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
780: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );
781: FND_MSG_PUB.ADD;
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;
784:

Line 821: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (+)',

817: end if;
818:
819: -- Debug info.
820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
821: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (+)',
822: p_prefix=>l_debug_prefix,
823: p_msg_level=>fnd_log.level_procedure);
824: END IF;
825:

Line 827: HZ_CUST_ACCOUNTS_PKG.Update_Row (

823: p_msg_level=>fnd_log.level_procedure);
824: END IF;
825:
826: -- Call table-handler.
827: HZ_CUST_ACCOUNTS_PKG.Update_Row (
828: X_Rowid => l_rowid,
829: X_CUST_ACCOUNT_ID => p_cust_account_rec.cust_account_id,
830: X_PARTY_ID => NULL, -- no need to update
831: X_ACCOUNT_NUMBER => p_cust_account_rec.account_number,

Line 935: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (-)',

931: );
932:
933: -- Debug info.
934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
935: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (-)',
936: p_prefix=>l_debug_prefix,
937: p_msg_level=>fnd_log.level_procedure);
938: END IF;
939:

Line 1605: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(

1601: END IF;
1602:
1603: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1604: -- populate function for integration service
1605: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(
1606: p_operation => 'I',
1607: p_cust_account_id => x_cust_account_id );
1608: END IF;
1609: END IF;

Line 1853: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(

1849: END IF;
1850:
1851: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1852: -- populate function for integration service
1853: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(
1854: p_operation => 'I',
1855: p_cust_account_id => x_cust_account_id );
1856: END IF;
1857: END IF;

Line 2046: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

2042: and (p_cust_account_rec.cust_account_id = FND_API.G_MISS_NUM or p_cust_account_rec.cust_account_id is null) THEN
2043: hz_orig_system_ref_pub.get_owner_table_id
2044: (p_orig_system => p_cust_account_rec.orig_system,
2045: p_orig_system_reference => p_cust_account_rec.orig_system_reference,
2046: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
2047: x_owner_table_id => l_cust_account_rec.cust_account_id,
2048: x_return_status => x_return_status);
2049: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2050: RAISE FND_API.G_EXC_ERROR;

Line 2099: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(

2095: END IF;
2096:
2097: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2098: -- populate function for integration service
2099: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(
2100: p_operation => 'U',
2101: p_cust_account_id => l_cust_account_rec.cust_account_id );
2102: END IF;
2103: END IF;

Line 2222: * HZ_CUST_ACCOUNTS_PKG.Select_Row

2218: * DESCRIPTION
2219: * Gets customer account record
2220: *
2221: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2222: * HZ_CUST_ACCOUNTS_PKG.Select_Row
2223: * HZ_CUSTOMER_PROFILE_V2PUB.get_customer_profile_rec
2224: *
2225: * ARGUMENTS
2226: * IN:

Line 2298: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (+)',

2294:
2295: x_cust_account_rec.cust_account_id := p_cust_account_id;
2296:
2297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2298: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (+)',
2299: p_prefix=>l_debug_prefix,
2300: p_msg_level=>fnd_log.level_procedure);
2301: END IF;
2302:

Line 2304: HZ_CUST_ACCOUNTS_PKG.Select_Row (

2300: p_msg_level=>fnd_log.level_procedure);
2301: END IF;
2302:
2303: -- Call table-handler.
2304: HZ_CUST_ACCOUNTS_PKG.Select_Row (
2305: X_CUST_ACCOUNT_ID => x_cust_account_rec.cust_account_id,
2306: X_ACCOUNT_NUMBER => x_cust_account_rec.account_number,
2307: X_ATTRIBUTE_CATEGORY => x_cust_account_rec.attribute_category,
2308: X_ATTRIBUTE1 => x_cust_account_rec.attribute1,

Line 2408: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (-)',

2404: X_APPLICATION_ID => x_cust_account_rec.application_id
2405: );
2406:
2407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2408: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (-)',
2409: p_prefix=>l_debug_prefix,
2410: p_msg_level=>fnd_log.level_procedure);
2411: END IF;
2412: