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.

[Home] [Help]

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 580: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (-) ' ||

576: p_msg_level=>fnd_log.level_procedure);
577: END IF;
578: -- Debug info.
579: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
580: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (-) ' ||
581: 'x_cust_account_id = ' || p_cust_account_rec.cust_account_id || ' ' ||
582: 'x_account_number = ' || p_cust_account_rec.account_number,
583: p_prefix=>l_debug_prefix,
584: p_msg_level=>fnd_log.level_procedure);

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

587: if (p_cust_account_rec.orig_system is not null and p_cust_account_rec.orig_system <>fnd_api.g_miss_char)
588: then
589: l_orig_system_ref_rec.orig_system := p_cust_account_rec.orig_system;
590: l_orig_system_ref_rec.orig_system_reference := l_orig_system_reference;
591: l_orig_system_ref_rec.owner_table_name := 'HZ_CUST_ACCOUNTS';
592: l_orig_system_ref_rec.owner_table_id := p_cust_account_rec.cust_account_id;
593: l_orig_system_ref_rec.created_by_module := p_cust_account_rec.created_by_module;
594:
595: hz_orig_system_ref_pub.create_orig_system_reference(

Line 711: * HZ_CUST_ACCOUNTS_PKG.Update_Row

707: * Private procedure to update customer account.
708: *
709: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
710: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_account
711: * HZ_CUST_ACCOUNTS_PKG.Update_Row
712: *
713: * ARGUMENTS
714: * IN/OUT:
715: * p_cust_account_rec Customer account record.

Line 744: select 'Y' from hz_cust_accounts

740: l_object_version_number NUMBER;
741: l_orig_system_ref_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
742:
743: CURSOR check_orig_sys_ref IS
744: select 'Y' from hz_cust_accounts
745: where ORIG_SYSTEM_REFERENCE = p_cust_account_rec.orig_system_reference;
746:
747: l_orig_system_reference varchar2(255) :=p_cust_account_rec.orig_system_reference;
748: l_tmp varchar2(1);

Line 762: FROM hz_cust_accounts

758: p_party_id NUMBER,
759: p_cust_account_id NUMBER
760: ) IS
761: SELECT null
762: FROM hz_cust_accounts
763: WHERE party_id = p_party_id
764: AND status = 'A'
765: AND cust_account_id <> p_cust_account_id
766: AND rownum = 1;

Line 782: FROM HZ_CUST_ACCOUNTS

778: -- Lock record.
779: BEGIN
780: SELECT ROWID, OBJECT_VERSION_NUMBER, party_id, status
781: INTO l_rowid, l_object_version_number, l_party_id, l_status
782: FROM HZ_CUST_ACCOUNTS
783: WHERE CUST_ACCOUNT_ID = p_cust_account_rec.cust_account_id
784: FOR UPDATE NOWAIT;
785:
786: IF NOT (

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

789: l_object_version_number IS NOT NULL AND
790: p_object_version_number = l_object_version_number ) )
791: THEN
792: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
793: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );
794: FND_MSG_PUB.ADD;
795: RAISE FND_API.G_EXC_ERROR;
796: END IF;
797:

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

830: end if;
831:
832: -- Debug info.
833: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
834: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (+)',
835: p_prefix=>l_debug_prefix,
836: p_msg_level=>fnd_log.level_procedure);
837: END IF;
838:

Line 840: HZ_CUST_ACCOUNTS_PKG.Update_Row (

836: p_msg_level=>fnd_log.level_procedure);
837: END IF;
838:
839: -- Call table-handler.
840: HZ_CUST_ACCOUNTS_PKG.Update_Row (
841: X_Rowid => l_rowid,
842: X_CUST_ACCOUNT_ID => p_cust_account_rec.cust_account_id,
843: X_PARTY_ID => NULL, -- no need to update
844: X_ACCOUNT_NUMBER => p_cust_account_rec.account_number,

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

948: );
949:
950: -- Debug info.
951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
952: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (-)',
953: p_prefix=>l_debug_prefix,
954: p_msg_level=>fnd_log.level_procedure);
955: END IF;
956:

Line 1622: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(

1618: END IF;
1619:
1620: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1621: -- populate function for integration service
1622: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(
1623: p_operation => 'I',
1624: p_cust_account_id => x_cust_account_id );
1625: END IF;
1626: END IF;

Line 1870: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(

1866: END IF;
1867:
1868: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1869: -- populate function for integration service
1870: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(
1871: p_operation => 'I',
1872: p_cust_account_id => x_cust_account_id );
1873: END IF;
1874: END IF;

Line 2073: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

2069: and (p_cust_account_rec.cust_account_id = FND_API.G_MISS_NUM or p_cust_account_rec.cust_account_id is null) THEN
2070: hz_orig_system_ref_pub.get_owner_table_id
2071: (p_orig_system => p_cust_account_rec.orig_system,
2072: p_orig_system_reference => p_cust_account_rec.orig_system_reference,
2073: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
2074: x_owner_table_id => l_cust_account_rec.cust_account_id,
2075: x_return_status => x_return_status);
2076: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2077: RAISE FND_API.G_EXC_ERROR;

Line 2126: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(

2122: END IF;
2123:
2124: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2125: -- populate function for integration service
2126: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(
2127: p_operation => 'U',
2128: p_cust_account_id => l_cust_account_rec.cust_account_id );
2129: END IF;
2130: END IF;

Line 2249: * HZ_CUST_ACCOUNTS_PKG.Select_Row

2245: * DESCRIPTION
2246: * Gets customer account record
2247: *
2248: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2249: * HZ_CUST_ACCOUNTS_PKG.Select_Row
2250: * HZ_CUSTOMER_PROFILE_V2PUB.get_customer_profile_rec
2251: *
2252: * ARGUMENTS
2253: * IN:

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

2321:
2322: x_cust_account_rec.cust_account_id := p_cust_account_id;
2323:
2324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2325: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (+)',
2326: p_prefix=>l_debug_prefix,
2327: p_msg_level=>fnd_log.level_procedure);
2328: END IF;
2329:

Line 2331: HZ_CUST_ACCOUNTS_PKG.Select_Row (

2327: p_msg_level=>fnd_log.level_procedure);
2328: END IF;
2329:
2330: -- Call table-handler.
2331: HZ_CUST_ACCOUNTS_PKG.Select_Row (
2332: X_CUST_ACCOUNT_ID => x_cust_account_rec.cust_account_id,
2333: X_ACCOUNT_NUMBER => x_cust_account_rec.account_number,
2334: X_ATTRIBUTE_CATEGORY => x_cust_account_rec.attribute_category,
2335: X_ATTRIBUTE1 => x_cust_account_rec.attribute1,

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

2437:
2438:
2439:
2440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2441: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (-)',
2442: p_prefix=>l_debug_prefix,
2443: p_msg_level=>fnd_log.level_procedure);
2444: END IF;
2445: