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_CUSTOMER_PROFILES

Line 261: * HZ_CUSTOMER_PROFILES_PKG.Insert_Row

257: * Private procedure to create customer profile.
258: *
259: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
260: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_customer_profile
261: * HZ_CUSTOMER_PROFILES_PKG.Insert_Row
262: * HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row
263: *
264: * ARGUMENTS
265: * IN:

Line 328: from hz_customer_profiles

324: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
325:
326: cursor c_acct_use_profile_dtls IS
327: select cons_bill_level, cons_inv_type
328: from hz_customer_profiles
329: where cust_account_id = p_customer_profile_rec.cust_account_id
330: and site_use_id is NULL
331: and cons_inv_flag = 'Y';
332:

Line 616: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (+)',

612: -- Table_handler is taking care of default customer profile to profile class.
613:
614: -- Debug info.
615: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
616: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (+)',
617: p_prefix=>l_debug_prefix,
618: p_msg_level=>fnd_log.level_procedure);
619: END IF;
620:

Line 621: HZ_CUSTOMER_PROFILES_PKG.Insert_Row (

617: p_prefix=>l_debug_prefix,
618: p_msg_level=>fnd_log.level_procedure);
619: END IF;
620:
621: HZ_CUSTOMER_PROFILES_PKG.Insert_Row (
622: X_CUST_ACCOUNT_PROFILE_ID => p_customer_profile_rec.cust_account_profile_id,
623: X_CUST_ACCOUNT_ID => p_customer_profile_rec.cust_account_id,
624: X_STATUS => p_customer_profile_rec.status,
625: X_COLLECTOR_ID => p_customer_profile_rec.collector_id,

Line 738: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (-) ' ||

734: x_cust_account_profile_id := p_customer_profile_rec.cust_account_profile_id;
735:
736: -- Debug info.
737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
738: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (-) ' ||
739: 'x_cust_account_profile_id = ' || x_cust_account_profile_id,
740: p_prefix=>l_debug_prefix,
741: p_msg_level=>fnd_log.level_procedure);
742: END IF;

Line 931: * HZ_CUSTOMER_PROFILES_PKG.Update_Row

927: * Private procedure to update customer profile.
928: *
929: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
930: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_customer_profile
931: * HZ_CUSTOMER_PROFILES_PKG.Update_Row
932: * HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row
933: *
934: * ARGUMENTS
935: * IN/OUT:

Line 975: l_created_by_module HZ_CUSTOMER_PROFILES.created_by_module%TYPE;

971: l_profile_class_id NUMBER;
972: l_cust_acct_profile_amt_id NUMBER;
973: l_object_version_number NUMBER;
974: l_amt_object_version_number NUMBER;
975: l_created_by_module HZ_CUSTOMER_PROFILES.created_by_module%TYPE;
976: l_application_id NUMBER;
977:
978: l_party_id NUMBER;
979: l_last_credit_review_date DATE;

Line 994: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;

990: v_entity_id NUMBER(15);
991: l_cons_inv_flag VARCHAR2(1);
992: l_cons_inv_type VARCHAR2(30);
993: l_cons_bill_level VARCHAR2(30);
994: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
995: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
996: l_message_text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
997: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
998: l_standard_terms NUMBER;

Line 995: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;

991: l_cons_inv_flag VARCHAR2(1);
992: l_cons_inv_type VARCHAR2(30);
993: l_cons_bill_level VARCHAR2(30);
994: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
995: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
996: l_message_text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
997: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
998: l_standard_terms NUMBER;
999: l_profile_class_changed VARCHAR2(10);

Line 996: l_message_text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;

992: l_cons_inv_type VARCHAR2(30);
993: l_cons_bill_level VARCHAR2(30);
994: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
995: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
996: l_message_text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
997: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
998: l_standard_terms NUMBER;
999: l_profile_class_changed VARCHAR2(10);
1000:

Line 1003: from hz_customer_profiles

999: l_profile_class_changed VARCHAR2(10);
1000:
1001: cursor c_acct_use_profile_dtls IS
1002: select cons_bill_level, cons_inv_type
1003: from hz_customer_profiles
1004: where cust_account_id = l_cust_account_id
1005: and site_use_id is NULL
1006: and cons_inv_flag = 'Y';
1007:

Line 1030: FROM HZ_CUSTOMER_PROFILES

1026: INTO l_rowid, l_object_version_number, l_cust_account_id, l_site_use_id,
1027: l_created_by_module, l_application_id,l_profile_class_id, l_party_id,
1028: l_credit_hold, l_cons_inv_flag, l_cons_inv_type, l_cons_bill_level,
1029: l_late_charge_type, l_late_charge_term_id, l_message_text_id, l_standard_terms
1030: FROM HZ_CUSTOMER_PROFILES
1031: WHERE CUST_ACCOUNT_PROFILE_ID = p_customer_profile_rec.cust_account_profile_id
1032: FOR UPDATE NOWAIT;
1033:
1034: IF NOT (

Line 1041: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );

1037: l_object_version_number IS NOT NULL AND
1038: p_object_version_number = l_object_version_number ) )
1039: THEN
1040: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1041: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );
1042: FND_MSG_PUB.ADD;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;
1045:

Line 1282: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (+)',

1278: -- Table_handler is taking care of default customer profile to profile class.
1279:
1280: -- Debug info.
1281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1282: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (+)',
1283: p_prefix=>l_debug_prefix,
1284: p_msg_level=>fnd_log.level_procedure);
1285: END IF;
1286:

Line 1287: HZ_CUSTOMER_PROFILES_PKG.Update_Row (

1283: p_prefix=>l_debug_prefix,
1284: p_msg_level=>fnd_log.level_procedure);
1285: END IF;
1286:
1287: HZ_CUSTOMER_PROFILES_PKG.Update_Row (
1288: X_Rowid => l_rowid,
1289: X_CUST_ACCOUNT_PROFILE_ID => p_customer_profile_rec.cust_account_profile_id,
1290: X_CUST_ACCOUNT_ID => p_customer_profile_rec.cust_account_id,
1291: X_STATUS => p_customer_profile_rec.status,

Line 1403: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (-)',

1399: --raji
1400:
1401: -- Debug info.
1402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1403: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (-)',
1404: p_prefix=>l_debug_prefix,
1405: p_msg_level=>fnd_log.level_procedure);
1406: END IF;
1407:

Line 1416: update HZ_CUSTOMER_PROFILES

1412: if (l_site_use_id is NULL and
1413: p_customer_profile_rec.cons_bill_level = 'SITE' and
1414: l_cons_bill_level = 'ACCOUNT') then
1415: begin
1416: update HZ_CUSTOMER_PROFILES
1417: set cons_bill_level = 'SITE'
1418: where site_use_id is NOT NULL
1419: and cons_inv_flag = 'Y'
1420: and cust_account_id = l_cust_account_id;

Line 1750: FROM hz_customer_profiles

1746: IF p_cust_profile_amt_rec.site_use_id IS NULL OR p_CUST_PROFILE_AMT_REC.site_use_id = FND_API.G_MISS_NUM THEN
1747: BEGIN
1748: SELECT site_use_id
1749: INTO l_site_use_id
1750: FROM hz_customer_profiles
1751: WHERE cust_account_id = p_cust_profile_amt_rec.cust_account_id
1752: AND cust_account_profile_id = p_cust_profile_amt_rec.cust_account_profile_id ;
1753:
1754: p_cust_profile_amt_rec.site_use_id := l_site_use_id ;

Line 2274: HZ_POPULATE_BOT_PKG.pop_hz_customer_profiles(

2270: p_create_profile_amt );
2271: END IF;
2272:
2273: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2274: HZ_POPULATE_BOT_PKG.pop_hz_customer_profiles(
2275: p_operation => 'I',
2276: p_cust_account_profile_id => x_cust_account_profile_id);
2277: END IF;
2278: END IF;

Line 2479: HZ_POPULATE_BOT_PKG.pop_hz_customer_profiles(

2475: l_customer_profile_rec , l_old_customer_profile_rec);
2476: END IF;
2477:
2478: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2479: HZ_POPULATE_BOT_PKG.pop_hz_customer_profiles(
2480: p_operation => 'U',
2481: p_cust_account_profile_id => l_customer_profile_rec.cust_account_profile_id);
2482: END IF;
2483: END IF;

Line 2592: * HZ_CUSTOMER_PROFILES_PKG.Select_Row

2588: * DESCRIPTION
2589: * Gets customer profile record
2590: *
2591: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2592: * HZ_CUSTOMER_PROFILES_PKG.Select_Row
2593: *
2594: * ARGUMENTS
2595: * IN:
2596: * p_init_msg_list Initialize message stack if it is set to

Line 2659: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (+)',

2655: x_customer_profile_rec.cust_account_profile_id := p_cust_account_profile_id;
2656:
2657: -- Debug info.
2658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2659: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (+)',
2660: p_prefix=>l_debug_prefix,
2661: p_msg_level=>fnd_log.level_procedure);
2662: END IF;
2663:

Line 2665: HZ_CUSTOMER_PROFILES_PKG.Select_Row (

2661: p_msg_level=>fnd_log.level_procedure);
2662: END IF;
2663:
2664: -- Call table-handler.
2665: HZ_CUSTOMER_PROFILES_PKG.Select_Row (
2666: X_CUST_ACCOUNT_PROFILE_ID => x_customer_profile_rec.cust_account_profile_id,
2667: X_CUST_ACCOUNT_ID => x_customer_profile_rec.cust_account_id,
2668: X_STATUS => x_customer_profile_rec.status,
2669: X_COLLECTOR_ID => x_customer_profile_rec.collector_id,

Line 2779: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (-)',

2775: --raji
2776:
2777: -- Debug info.
2778: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2779: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (-)',
2780: p_prefix=>l_debug_prefix,
2781: p_msg_level=>fnd_log.level_procedure);
2782: END IF;
2783: