DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_CUST_ACCT_SITES_PKG

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 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 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 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 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 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: