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

1556:
1557: BEGIN
1558: SELECT CUST_ACCT_PROFILE_AMT_ID, OBJECT_VERSION_NUMBER
1559: INTO l_cust_acct_profile_amt_id, l_amt_object_version_number
1560: FROM HZ_CUST_PROFILE_AMTS
1561: WHERE CUST_ACCOUNT_PROFILE_ID = p_customer_profile_rec.cust_account_profile_id
1562: AND CURRENCY_CODE = l_cust_profile_amt_rec.currency_code;
1563:
1564: -- The currency exist for the customer profile. Update it.

Line 1659: * HZ_CUST_PROFILE_AMTS_PKG.Insert_Row

1655: * Private procedure to create customer profile amount.
1656: *
1657: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1658: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_profile_amt
1659: * HZ_CUST_PROFILE_AMTS_PKG.Insert_Row
1660: *
1661: * ARGUMENTS
1662: * IN:
1663: * p_check_foreign_key If do foreign key checking on cust_account_id

Line 1692: l_site_use_id HZ_CUST_PROFILE_AMTS.SITE_USE_ID%TYPE;

1688: x_return_status IN OUT NOCOPY VARCHAR2
1689: ) IS
1690:
1691: l_debug_prefix VARCHAR2(30) := ''; --'do_create_cust_profile_amt'
1692: l_site_use_id HZ_CUST_PROFILE_AMTS.SITE_USE_ID%TYPE;
1693: BEGIN
1694:
1695: -- Debug info.
1696: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1733: END IF;
1734:
1735: -- Debug info.
1736: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1737: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (+)',
1738: p_prefix=>l_debug_prefix,
1739: p_msg_level=>fnd_log.level_procedure);
1740: END IF;
1741:

Line 1763: HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (

1759: END;
1760: END IF;
1761:
1762: -- Call table-handler.
1763: HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (
1764: X_CUST_ACCT_PROFILE_AMT_ID => p_cust_profile_amt_rec.cust_acct_profile_amt_id,
1765: X_CUST_ACCOUNT_PROFILE_ID => p_cust_profile_amt_rec.cust_account_profile_id,
1766: X_CURRENCY_CODE => p_cust_profile_amt_rec.currency_code,
1767: X_TRX_CREDIT_LIMIT => p_cust_profile_amt_rec.trx_credit_limit,

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

1851: x_cust_acct_profile_amt_id := p_cust_profile_amt_rec.cust_acct_profile_amt_id;
1852:
1853: -- Debug info.
1854: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1855: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (-) ' ||
1856: 'x_cust_acct_profile_amt_id = ' || x_cust_acct_profile_amt_id,
1857: p_prefix=>l_debug_prefix,
1858: p_msg_level=>fnd_log.level_procedure);
1859: END IF;

Line 1878: * HZ_CUST_PROFILE_AMTS_PKG.Update_Row

1874: * Private procedure to update customer profile amount.
1875: *
1876: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1877: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_profile_amt
1878: * HZ_CUST_PROFILE_AMTS_PKG.Update_Row
1879: *
1880: * ARGUMENTS
1881: * IN/OUT:
1882: * p_cust_profile_amt_rec Customer profile amount record.

Line 1921: FROM HZ_CUST_PROFILE_AMTS

1917: -- Lock record.
1918: BEGIN
1919: SELECT ROWID, OBJECT_VERSION_NUMBER
1920: INTO l_rowid, l_object_version_number
1921: FROM HZ_CUST_PROFILE_AMTS
1922: WHERE CUST_ACCT_PROFILE_AMT_ID = p_cust_profile_amt_rec.cust_acct_profile_amt_id
1923: FOR UPDATE NOWAIT;
1924:
1925: IF NOT (

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

1928: l_object_version_number IS NOT NULL AND
1929: p_object_version_number = l_object_version_number ) )
1930: THEN
1931: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1932: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_profile_amts' );
1933: FND_MSG_PUB.ADD;
1934: RAISE FND_API.G_EXC_ERROR;
1935: END IF;
1936:

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

1980: END IF;
1981:
1982: -- Debug info.
1983: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1984: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Update_Row (+)',
1985: p_prefix=>l_debug_prefix,
1986: p_msg_level=>fnd_log.level_procedure);
1987: END IF;
1988:

Line 1990: HZ_CUST_PROFILE_AMTS_PKG.Update_Row (

1986: p_msg_level=>fnd_log.level_procedure);
1987: END IF;
1988:
1989: -- Call table-handler.
1990: HZ_CUST_PROFILE_AMTS_PKG.Update_Row (
1991: X_Rowid => l_rowid,
1992: X_CUST_ACCT_PROFILE_AMT_ID => p_cust_profile_amt_rec.cust_acct_profile_amt_id,
1993: X_CUST_ACCOUNT_PROFILE_ID => p_cust_profile_amt_rec.cust_account_profile_id,
1994: X_CURRENCY_CODE => p_cust_profile_amt_rec.currency_code,

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

2077: );
2078:
2079: -- Debug info.
2080: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2081: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Update_Row (-)',
2082: p_prefix=>l_debug_prefix,
2083: p_msg_level=>fnd_log.level_procedure);
2084: END IF;
2085:

Line 2973: HZ_POPULATE_BOT_PKG.pop_hz_cust_profile_amts(

2969: l_cust_profile_amt_rec );
2970: END IF;
2971:
2972: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2973: HZ_POPULATE_BOT_PKG.pop_hz_cust_profile_amts(
2974: p_operation => 'I',
2975: p_cust_acct_profile_amt_id => x_cust_acct_profile_amt_id);
2976: END IF;
2977: END IF;

Line 3180: HZ_POPULATE_BOT_PKG.pop_hz_cust_profile_amts(

3176: l_cust_profile_amt_rec , l_old_cust_profile_amt_rec );
3177: END IF;
3178:
3179: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3180: HZ_POPULATE_BOT_PKG.pop_hz_cust_profile_amts(
3181: p_operation => 'U',
3182: p_cust_acct_profile_amt_id => l_cust_profile_amt_rec.cust_acct_profile_amt_id);
3183: END IF;
3184: END IF;

Line 3298: * HZ_CUST_PROFILE_AMTS_PKG.Select_Row

3294: * DESCRIPTION
3295: * Gets customer profile amount record
3296: *
3297: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3298: * HZ_CUST_PROFILE_AMTS_PKG.Select_Row
3299: *
3300: * ARGUMENTS
3301: * IN:
3302: * p_init_msg_list Initialize message stack if it is set to

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

3361: x_cust_profile_amt_rec.cust_acct_profile_amt_id := p_cust_acct_profile_amt_id;
3362:
3363: -- Debug info.
3364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3365: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (+)',
3366: p_prefix=>l_debug_prefix,
3367: p_msg_level=>fnd_log.level_procedure);
3368: END IF;
3369:

Line 3371: HZ_CUST_PROFILE_AMTS_PKG.Select_Row (

3367: p_msg_level=>fnd_log.level_procedure);
3368: END IF;
3369:
3370: -- Call table-handler.
3371: HZ_CUST_PROFILE_AMTS_PKG.Select_Row (
3372: X_CUST_ACCT_PROFILE_AMT_ID => x_cust_profile_amt_rec.cust_acct_profile_amt_id,
3373: X_CUST_ACCOUNT_PROFILE_ID => x_cust_profile_amt_rec.cust_account_profile_id,
3374: X_CURRENCY_CODE => x_cust_profile_amt_rec.currency_code,
3375: X_TRX_CREDIT_LIMIT => x_cust_profile_amt_rec.trx_credit_limit,

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

3456: );
3457:
3458: -- Debug info.
3459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3460: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (-)',
3461: p_prefix=>l_debug_prefix,
3462: p_msg_level=>fnd_log.level_procedure);
3463: END IF;
3464: