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 646: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (+)',

642: -- Table_handler is taking care of default customer profile to profile class.
643:
644: -- Debug info.
645: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
646: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (+)',
647: p_prefix=>l_debug_prefix,
648: p_msg_level=>fnd_log.level_procedure);
649: END IF;
650:

Line 651: HZ_CUSTOMER_PROFILES_PKG.Insert_Row (

647: p_prefix=>l_debug_prefix,
648: p_msg_level=>fnd_log.level_procedure);
649: END IF;
650:
651: HZ_CUSTOMER_PROFILES_PKG.Insert_Row (
652: X_CUST_ACCOUNT_PROFILE_ID => p_customer_profile_rec.cust_account_profile_id,
653: X_CUST_ACCOUNT_ID => p_customer_profile_rec.cust_account_id,
654: X_STATUS => p_customer_profile_rec.status,
655: X_COLLECTOR_ID => p_customer_profile_rec.collector_id,

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

765: x_cust_account_profile_id := p_customer_profile_rec.cust_account_profile_id;
766:
767: -- Debug info.
768: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
769: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (-) ' ||
770: 'x_cust_account_profile_id = ' || x_cust_account_profile_id,
771: p_prefix=>l_debug_prefix,
772: p_msg_level=>fnd_log.level_procedure);
773: END IF;

Line 962: * HZ_CUSTOMER_PROFILES_PKG.Update_Row

958: * Private procedure to update customer profile.
959: *
960: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
961: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_customer_profile
962: * HZ_CUSTOMER_PROFILES_PKG.Update_Row
963: * HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row
964: *
965: * ARGUMENTS
966: * IN/OUT:

Line 1006: l_created_by_module HZ_CUSTOMER_PROFILES.created_by_module%TYPE;

1002: l_profile_class_id NUMBER;
1003: l_cust_acct_profile_amt_id NUMBER;
1004: l_object_version_number NUMBER;
1005: l_amt_object_version_number NUMBER;
1006: l_created_by_module HZ_CUSTOMER_PROFILES.created_by_module%TYPE;
1007: l_application_id NUMBER;
1008:
1009: l_party_id NUMBER;
1010: l_last_credit_review_date DATE;

Line 1025: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;

1021: v_entity_id NUMBER(15);
1022: l_cons_inv_flag VARCHAR2(1);
1023: l_cons_inv_type VARCHAR2(30);
1024: l_cons_bill_level VARCHAR2(30);
1025: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
1026: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
1027: l_message_text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
1028: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
1029: l_standard_terms NUMBER;

Line 1026: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;

1022: l_cons_inv_flag VARCHAR2(1);
1023: l_cons_inv_type VARCHAR2(30);
1024: l_cons_bill_level VARCHAR2(30);
1025: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
1026: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
1027: l_message_text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
1028: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
1029: l_standard_terms NUMBER;
1030: l_automatch_set_id NUMBER;

Line 1027: l_message_text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;

1023: l_cons_inv_type VARCHAR2(30);
1024: l_cons_bill_level VARCHAR2(30);
1025: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
1026: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
1027: l_message_text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
1028: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
1029: l_standard_terms NUMBER;
1030: l_automatch_set_id NUMBER;
1031: l_profile_class_changed VARCHAR2(10);

Line 1035: from hz_customer_profiles

1031: l_profile_class_changed VARCHAR2(10);
1032:
1033: cursor c_acct_use_profile_dtls IS
1034: select cons_bill_level, cons_inv_type
1035: from hz_customer_profiles
1036: where cust_account_id = l_cust_account_id
1037: and site_use_id is NULL
1038: and cons_inv_flag = 'Y';
1039:

Line 1064: FROM HZ_CUSTOMER_PROFILES

1060: l_created_by_module, l_application_id,l_profile_class_id, l_party_id,
1061: l_credit_hold, l_cons_inv_flag, l_cons_inv_type, l_cons_bill_level,
1062: l_late_charge_type, l_late_charge_term_id, l_message_text_id, l_standard_terms,
1063: l_automatch_set_id
1064: FROM HZ_CUSTOMER_PROFILES
1065: WHERE CUST_ACCOUNT_PROFILE_ID = p_customer_profile_rec.cust_account_profile_id
1066: FOR UPDATE NOWAIT;
1067:
1068: IF NOT (

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

1071: l_object_version_number IS NOT NULL AND
1072: p_object_version_number = l_object_version_number ) )
1073: THEN
1074: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1075: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );
1076: FND_MSG_PUB.ADD;
1077: RAISE FND_API.G_EXC_ERROR;
1078: END IF;
1079:

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

1340: -- Table_handler is taking care of default customer profile to profile class.
1341:
1342: -- Debug info.
1343: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1344: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (+)',
1345: p_prefix=>l_debug_prefix,
1346: p_msg_level=>fnd_log.level_procedure);
1347: END IF;
1348:

Line 1349: HZ_CUSTOMER_PROFILES_PKG.Update_Row (

1345: p_prefix=>l_debug_prefix,
1346: p_msg_level=>fnd_log.level_procedure);
1347: END IF;
1348:
1349: HZ_CUSTOMER_PROFILES_PKG.Update_Row (
1350: X_Rowid => l_rowid,
1351: X_CUST_ACCOUNT_PROFILE_ID => p_customer_profile_rec.cust_account_profile_id,
1352: X_CUST_ACCOUNT_ID => p_customer_profile_rec.cust_account_id,
1353: X_STATUS => p_customer_profile_rec.status,

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

1462: --raji
1463:
1464: -- Debug info.
1465: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1466: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (-)',
1467: p_prefix=>l_debug_prefix,
1468: p_msg_level=>fnd_log.level_procedure);
1469: END IF;
1470:

Line 1479: update HZ_CUSTOMER_PROFILES

1475: if (l_site_use_id is NULL and
1476: p_customer_profile_rec.cons_bill_level = 'SITE' and
1477: l_cons_bill_level = 'ACCOUNT') then
1478: begin
1479: update HZ_CUSTOMER_PROFILES
1480: set cons_bill_level = 'SITE'
1481: where site_use_id is NOT NULL
1482: and cons_inv_flag = 'Y'
1483: and cust_account_id = l_cust_account_id;

Line 1813: FROM hz_customer_profiles

1809: 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
1810: BEGIN
1811: SELECT site_use_id
1812: INTO l_site_use_id
1813: FROM hz_customer_profiles
1814: WHERE cust_account_id = p_cust_profile_amt_rec.cust_account_id
1815: AND cust_account_profile_id = p_cust_profile_amt_rec.cust_account_profile_id ;
1816:
1817: p_cust_profile_amt_rec.site_use_id := l_site_use_id ;

Line 2337: HZ_POPULATE_BOT_PKG.pop_hz_customer_profiles(

2333: p_create_profile_amt );
2334: END IF;
2335:
2336: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2337: HZ_POPULATE_BOT_PKG.pop_hz_customer_profiles(
2338: p_operation => 'I',
2339: p_cust_account_profile_id => x_cust_account_profile_id);
2340: END IF;
2341: END IF;

Line 2542: HZ_POPULATE_BOT_PKG.pop_hz_customer_profiles(

2538: l_customer_profile_rec , l_old_customer_profile_rec);
2539: END IF;
2540:
2541: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2542: HZ_POPULATE_BOT_PKG.pop_hz_customer_profiles(
2543: p_operation => 'U',
2544: p_cust_account_profile_id => l_customer_profile_rec.cust_account_profile_id);
2545: END IF;
2546: END IF;

Line 2655: * HZ_CUSTOMER_PROFILES_PKG.Select_Row

2651: * DESCRIPTION
2652: * Gets customer profile record
2653: *
2654: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2655: * HZ_CUSTOMER_PROFILES_PKG.Select_Row
2656: *
2657: * ARGUMENTS
2658: * IN:
2659: * p_init_msg_list Initialize message stack if it is set to

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

2718: x_customer_profile_rec.cust_account_profile_id := p_cust_account_profile_id;
2719:
2720: -- Debug info.
2721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2722: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (+)',
2723: p_prefix=>l_debug_prefix,
2724: p_msg_level=>fnd_log.level_procedure);
2725: END IF;
2726:

Line 2728: HZ_CUSTOMER_PROFILES_PKG.Select_Row (

2724: p_msg_level=>fnd_log.level_procedure);
2725: END IF;
2726:
2727: -- Call table-handler.
2728: HZ_CUSTOMER_PROFILES_PKG.Select_Row (
2729: X_CUST_ACCOUNT_PROFILE_ID => x_customer_profile_rec.cust_account_profile_id,
2730: X_CUST_ACCOUNT_ID => x_customer_profile_rec.cust_account_id,
2731: X_STATUS => x_customer_profile_rec.status,
2732: X_COLLECTOR_ID => x_customer_profile_rec.collector_id,

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

2839: --raji
2840:
2841: -- Debug info.
2842: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2843: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (-)',
2844: p_prefix=>l_debug_prefix,
2845: p_msg_level=>fnd_log.level_procedure);
2846: END IF;
2847: