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.

APPS.HZ_CUSTOMER_PROFILE_V2PUB dependencies on HZ_CUST_PROFILE_AMTS

Line 1623: FROM HZ_CUST_PROFILE_AMTS

1619:
1620: BEGIN
1621: SELECT CUST_ACCT_PROFILE_AMT_ID, OBJECT_VERSION_NUMBER
1622: INTO l_cust_acct_profile_amt_id, l_amt_object_version_number
1623: FROM HZ_CUST_PROFILE_AMTS
1624: WHERE CUST_ACCOUNT_PROFILE_ID = p_customer_profile_rec.cust_account_profile_id
1625: AND CURRENCY_CODE = l_cust_profile_amt_rec.currency_code;
1626:
1627: -- The currency exist for the customer profile. Update it.

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 1755: l_site_use_id HZ_CUST_PROFILE_AMTS.SITE_USE_ID%TYPE;

1751: x_return_status IN OUT NOCOPY VARCHAR2
1752: ) IS
1753:
1754: l_debug_prefix VARCHAR2(30) := ''; --'do_create_cust_profile_amt'
1755: l_site_use_id HZ_CUST_PROFILE_AMTS.SITE_USE_ID%TYPE;
1756: BEGIN
1757:
1758: -- Debug info.
1759: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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 1984: FROM HZ_CUST_PROFILE_AMTS

1980: -- Lock record.
1981: BEGIN
1982: SELECT ROWID, OBJECT_VERSION_NUMBER
1983: INTO l_rowid, l_object_version_number
1984: FROM HZ_CUST_PROFILE_AMTS
1985: WHERE CUST_ACCT_PROFILE_AMT_ID = p_cust_profile_amt_rec.cust_acct_profile_amt_id
1986: FOR UPDATE NOWAIT;
1987:
1988: IF NOT (

Line 1995: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_profile_amts' );

1991: l_object_version_number IS NOT NULL AND
1992: p_object_version_number = l_object_version_number ) )
1993: THEN
1994: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1995: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_profile_amts' );
1996: FND_MSG_PUB.ADD;
1997: RAISE FND_API.G_EXC_ERROR;
1998: END IF;
1999:

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 3037: HZ_POPULATE_BOT_PKG.pop_hz_cust_profile_amts(

3033: l_cust_profile_amt_rec );
3034: END IF;
3035:
3036: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3037: HZ_POPULATE_BOT_PKG.pop_hz_cust_profile_amts(
3038: p_operation => 'I',
3039: p_cust_acct_profile_amt_id => x_cust_acct_profile_amt_id);
3040: END IF;
3041: END IF;

Line 3244: HZ_POPULATE_BOT_PKG.pop_hz_cust_profile_amts(

3240: l_cust_profile_amt_rec , l_old_cust_profile_amt_rec );
3241: END IF;
3242:
3243: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3244: HZ_POPULATE_BOT_PKG.pop_hz_cust_profile_amts(
3245: p_operation => 'U',
3246: p_cust_acct_profile_amt_id => l_cust_profile_amt_rec.cust_acct_profile_amt_id);
3247: END IF;
3248: END IF;

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: