DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_PROFILE_V2PUB dependencies on HZ_CUST_PROFILE_AMTS_PKG

Line 1722: * HZ_CUST_PROFILE_AMTS_PKG.Insert_Row

1718: * Private procedure to create customer profile amount.
1719: *
1720: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1721: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_profile_amt
1722: * HZ_CUST_PROFILE_AMTS_PKG.Insert_Row
1723: *
1724: * ARGUMENTS
1725: * IN:
1726: * p_check_foreign_key If do foreign key checking on cust_account_id

Line 1800: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (+)',

1796: END IF;
1797:
1798: -- Debug info.
1799: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1800: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (+)',
1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: END IF;
1804:

Line 1826: HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (

1822: END;
1823: END IF;
1824:
1825: -- Call table-handler.
1826: HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (
1827: X_CUST_ACCT_PROFILE_AMT_ID => p_cust_profile_amt_rec.cust_acct_profile_amt_id,
1828: X_CUST_ACCOUNT_PROFILE_ID => p_cust_profile_amt_rec.cust_account_profile_id,
1829: X_CURRENCY_CODE => p_cust_profile_amt_rec.currency_code,
1830: X_TRX_CREDIT_LIMIT => p_cust_profile_amt_rec.trx_credit_limit,

Line 1918: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (-) ' ||

1914: x_cust_acct_profile_amt_id := p_cust_profile_amt_rec.cust_acct_profile_amt_id;
1915:
1916: -- Debug info.
1917: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1918: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (-) ' ||
1919: 'x_cust_acct_profile_amt_id = ' || x_cust_acct_profile_amt_id,
1920: p_prefix=>l_debug_prefix,
1921: p_msg_level=>fnd_log.level_procedure);
1922: END IF;

Line 1941: * HZ_CUST_PROFILE_AMTS_PKG.Update_Row

1937: * Private procedure to update customer profile amount.
1938: *
1939: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1940: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_profile_amt
1941: * HZ_CUST_PROFILE_AMTS_PKG.Update_Row
1942: *
1943: * ARGUMENTS
1944: * IN/OUT:
1945: * p_cust_profile_amt_rec Customer profile amount record.

Line 2047: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Update_Row (+)',

2043: END IF;
2044:
2045: -- Debug info.
2046: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2047: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Update_Row (+)',
2048: p_prefix=>l_debug_prefix,
2049: p_msg_level=>fnd_log.level_procedure);
2050: END IF;
2051:

Line 2053: HZ_CUST_PROFILE_AMTS_PKG.Update_Row (

2049: p_msg_level=>fnd_log.level_procedure);
2050: END IF;
2051:
2052: -- Call table-handler.
2053: HZ_CUST_PROFILE_AMTS_PKG.Update_Row (
2054: X_Rowid => l_rowid,
2055: X_CUST_ACCT_PROFILE_AMT_ID => p_cust_profile_amt_rec.cust_acct_profile_amt_id,
2056: X_CUST_ACCOUNT_PROFILE_ID => p_cust_profile_amt_rec.cust_account_profile_id,
2057: X_CURRENCY_CODE => p_cust_profile_amt_rec.currency_code,

Line 2144: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Update_Row (-)',

2140: );
2141:
2142: -- Debug info.
2143: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2144: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Update_Row (-)',
2145: p_prefix=>l_debug_prefix,
2146: p_msg_level=>fnd_log.level_procedure);
2147: END IF;
2148:

Line 3362: * HZ_CUST_PROFILE_AMTS_PKG.Select_Row

3358: * DESCRIPTION
3359: * Gets customer profile amount record
3360: *
3361: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3362: * HZ_CUST_PROFILE_AMTS_PKG.Select_Row
3363: *
3364: * ARGUMENTS
3365: * IN:
3366: * p_init_msg_list Initialize message stack if it is set to

Line 3429: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (+)',

3425: x_cust_profile_amt_rec.cust_acct_profile_amt_id := p_cust_acct_profile_amt_id;
3426:
3427: -- Debug info.
3428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3429: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (+)',
3430: p_prefix=>l_debug_prefix,
3431: p_msg_level=>fnd_log.level_procedure);
3432: END IF;
3433:

Line 3435: HZ_CUST_PROFILE_AMTS_PKG.Select_Row (

3431: p_msg_level=>fnd_log.level_procedure);
3432: END IF;
3433:
3434: -- Call table-handler.
3435: HZ_CUST_PROFILE_AMTS_PKG.Select_Row (
3436: X_CUST_ACCT_PROFILE_AMT_ID => x_cust_profile_amt_rec.cust_acct_profile_amt_id,
3437: X_CUST_ACCOUNT_PROFILE_ID => x_cust_profile_amt_rec.cust_account_profile_id,
3438: X_CURRENCY_CODE => x_cust_profile_amt_rec.currency_code,
3439: X_TRX_CREDIT_LIMIT => x_cust_profile_amt_rec.trx_credit_limit,

Line 3524: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (-)',

3520: );
3521:
3522: -- Debug info.
3523: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3524: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (-)',
3525: p_prefix=>l_debug_prefix,
3526: p_msg_level=>fnd_log.level_procedure);
3527: END IF;
3528: