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