DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_CUST_SITE_USES_PKG

Line 987: * HZ_CUST_SITE_USES_PKG.Insert_Row

983: * Private procedure to create customer account site use.
984: *
985: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
986: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_site_use
987: * HZ_CUST_SITE_USES_PKG.Insert_Row
988: *
989: * ARGUMENTS
990: * IN:
991: * p_create_profile If it is set to FND_API.G_TRUE, API create customer

Line 1171: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',

1167: END IF;
1168:
1169: -- Debug info.
1170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1171: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1172: p_prefix=>l_debug_prefix,
1173: p_msg_level=>fnd_log.level_procedure);
1174: END IF;
1175:

Line 1246: HZ_CUST_SITE_USES_PKG.Insert_Row (

1242: END IF;
1243: END IF;
1244:
1245: -- Call table-handler.
1246: HZ_CUST_SITE_USES_PKG.Insert_Row (
1247: X_SITE_USE_ID => p_cust_site_use_rec.site_use_id,
1248: X_CUST_ACCT_SITE_ID => p_cust_site_use_rec.cust_acct_site_id,
1249: X_SITE_USE_CODE => p_cust_site_use_rec.site_use_code,
1250: X_PRIMARY_FLAG => p_cust_site_use_rec.primary_flag,

Line 1354: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (-) ' ||

1350: );
1351:
1352: -- Debug info.
1353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1354: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (-) ' ||
1355: 'x_site_use_id = ' || p_cust_site_use_rec.site_use_id,
1356: p_prefix=>l_debug_prefix,
1357: p_msg_level=>fnd_log.level_procedure);
1358: END IF;

Line 1500: * HZ_CUST_SITE_USES_PKG.Update_Row

1496: * Private procedure to update customer account site use.
1497: *
1498: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1499: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_site_use
1500: * HZ_CUST_SITE_USES_PKG.Update_Row
1501: *
1502: * ARGUMENTS
1503: * IN/OUT:
1504: * p_cust_site_use_rec Customer account site use record.

Line 1685: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',

1681: END IF;
1682:
1683: -- Debug info.
1684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1685: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1686: p_prefix=>l_debug_prefix,
1687: p_msg_level=>fnd_log.level_procedure);
1688: END IF;
1689: --Bug Fix:5036975

Line 1703: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (+)',

1699: end if;
1700:
1701: -- Debug info.
1702: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1703: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (+)',
1704: p_prefix=>l_debug_prefix,
1705: p_msg_level=>fnd_log.level_procedure);
1706: END IF;
1707:

Line 1846: HZ_CUST_SITE_USES_PKG.Update_Row (

1842: END IF;
1843: END IF;
1844:
1845: -- Call table-handler.
1846: HZ_CUST_SITE_USES_PKG.Update_Row (
1847: X_Rowid => l_rowid,
1848: X_SITE_USE_ID => p_cust_site_use_rec.site_use_id,
1849: X_CUST_ACCT_SITE_ID => p_cust_site_use_rec.cust_acct_site_id,
1850: X_SITE_USE_CODE => p_cust_site_use_rec.site_use_code,

Line 1954: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (-)',

1950: );
1951:
1952: -- Debug info.
1953: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1954: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (-)',
1955: p_prefix=>l_debug_prefix,
1956: p_msg_level=>fnd_log.level_procedure);
1957: END IF;
1958:

Line 3240: * HZ_CUST_SITE_USES_PKG.Select_Row

3236: * DESCRIPTION
3237: * Gets customer account site use record
3238: *
3239: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3240: * HZ_CUST_SITE_USES_PKG.Select_Row
3241: *
3242: * ARGUMENTS
3243: * IN:
3244: * p_init_msg_list Initialize message stack if it is set to

Line 3312: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Select_Row (+)',

3308: x_cust_site_use_rec.site_use_id := p_site_use_id;
3309:
3310: -- Debug info.
3311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3312: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Select_Row (+)',
3313: p_prefix=>l_debug_prefix,
3314: p_msg_level=>fnd_log.level_procedure);
3315: END IF;
3316:

Line 3318: HZ_CUST_SITE_USES_PKG.Select_Row (

3314: p_msg_level=>fnd_log.level_procedure);
3315: END IF;
3316:
3317: -- Call table-handler.
3318: HZ_CUST_SITE_USES_PKG.Select_Row (
3319: X_SITE_USE_ID => x_cust_site_use_rec.site_use_id,
3320: X_CUST_ACCT_SITE_ID => x_cust_site_use_rec.cust_acct_site_id,
3321: X_SITE_USE_CODE => x_cust_site_use_rec.site_use_code,
3322: X_PRIMARY_FLAG => x_cust_site_use_rec.primary_flag,

Line 3424: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_SITE_USES_PKG.Select_Row (-)',

3420: );
3421:
3422: -- Debug info.
3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3424: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_SITE_USES_PKG.Select_Row (-)',
3425: p_prefix=>l_debug_prefix,
3426: p_msg_level=>fnd_log.level_procedure);
3427: END IF;
3428: