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_CONTACT_PREFERENCE_VALIDATE dependencies on HZ_CONTACT_PREFERENCES

Line 147: FROM HZ_CONTACT_PREFERENCES

143: x_updated_cp_rec.MAX_NO_OF_INTERACT_UOM_CODE,
144: x_updated_cp_rec.REQUESTED_BY,
145: x_updated_cp_rec.REASON_CODE,
146: x_updated_cp_rec.STATUS
147: FROM HZ_CONTACT_PREFERENCES
148: WHERE CONTACT_PREFERENCE_ID = p_contact_preference_id;
149:
150:
151: END get_updated_record;

Line 167: l_contact_level_table HZ_CONTACT_PREFERENCES.contact_level_table%TYPE;

163: l_debug_prefix VARCHAR2(100) := ''; -- 'validate_contact_preference'
164:
165: l_contact_preference_id NUMBER;
166: l_contact_pref_dup_id NUMBER;
167: l_contact_level_table HZ_CONTACT_PREFERENCES.contact_level_table%TYPE;
168: l_contact_level_table_id NUMBER;
169: l_contact_type HZ_CONTACT_PREFERENCES.contact_type%TYPE;
170: l_preference_code HZ_CONTACT_PREFERENCES.preference_code%TYPE;
171: l_preference_start_date HZ_CONTACT_PREFERENCES.preference_start_date%TYPE;

Line 169: l_contact_type HZ_CONTACT_PREFERENCES.contact_type%TYPE;

165: l_contact_preference_id NUMBER;
166: l_contact_pref_dup_id NUMBER;
167: l_contact_level_table HZ_CONTACT_PREFERENCES.contact_level_table%TYPE;
168: l_contact_level_table_id NUMBER;
169: l_contact_type HZ_CONTACT_PREFERENCES.contact_type%TYPE;
170: l_preference_code HZ_CONTACT_PREFERENCES.preference_code%TYPE;
171: l_preference_start_date HZ_CONTACT_PREFERENCES.preference_start_date%TYPE;
172: l_preference_end_date HZ_CONTACT_PREFERENCES.preference_end_date%TYPE;
173: l_preference_start_time_hr NUMBER;

Line 170: l_preference_code HZ_CONTACT_PREFERENCES.preference_code%TYPE;

166: l_contact_pref_dup_id NUMBER;
167: l_contact_level_table HZ_CONTACT_PREFERENCES.contact_level_table%TYPE;
168: l_contact_level_table_id NUMBER;
169: l_contact_type HZ_CONTACT_PREFERENCES.contact_type%TYPE;
170: l_preference_code HZ_CONTACT_PREFERENCES.preference_code%TYPE;
171: l_preference_start_date HZ_CONTACT_PREFERENCES.preference_start_date%TYPE;
172: l_preference_end_date HZ_CONTACT_PREFERENCES.preference_end_date%TYPE;
173: l_preference_start_time_hr NUMBER;
174: l_preference_end_time_hr NUMBER;

Line 171: l_preference_start_date HZ_CONTACT_PREFERENCES.preference_start_date%TYPE;

167: l_contact_level_table HZ_CONTACT_PREFERENCES.contact_level_table%TYPE;
168: l_contact_level_table_id NUMBER;
169: l_contact_type HZ_CONTACT_PREFERENCES.contact_type%TYPE;
170: l_preference_code HZ_CONTACT_PREFERENCES.preference_code%TYPE;
171: l_preference_start_date HZ_CONTACT_PREFERENCES.preference_start_date%TYPE;
172: l_preference_end_date HZ_CONTACT_PREFERENCES.preference_end_date%TYPE;
173: l_preference_start_time_hr NUMBER;
174: l_preference_end_time_hr NUMBER;
175: l_preference_start_time_mi NUMBER;

Line 172: l_preference_end_date HZ_CONTACT_PREFERENCES.preference_end_date%TYPE;

168: l_contact_level_table_id NUMBER;
169: l_contact_type HZ_CONTACT_PREFERENCES.contact_type%TYPE;
170: l_preference_code HZ_CONTACT_PREFERENCES.preference_code%TYPE;
171: l_preference_start_date HZ_CONTACT_PREFERENCES.preference_start_date%TYPE;
172: l_preference_end_date HZ_CONTACT_PREFERENCES.preference_end_date%TYPE;
173: l_preference_start_time_hr NUMBER;
174: l_preference_end_time_hr NUMBER;
175: l_preference_start_time_mi NUMBER;
176: l_preference_end_time_mi NUMBER;

Line 178: l_created_by_module HZ_CONTACT_PREFERENCES.created_by_module%TYPE;

174: l_preference_end_time_hr NUMBER;
175: l_preference_start_time_mi NUMBER;
176: l_preference_end_time_mi NUMBER;
177: l_contact_point_type HZ_CONTACT_POINTS.contact_point_type%TYPE;
178: l_created_by_module HZ_CONTACT_PREFERENCES.created_by_module%TYPE;
179: l_application_id NUMBER;
180: l_dummy VARCHAR2(1);
181: l_tag FND_LOOKUP_VALUES.tag%TYPE;
182: l_time_comparison VARCHAR2(30) := FND_API.G_TRUE;

Line 185: l_preference_topic_type HZ_CONTACT_PREFERENCES.preference_topic_type%TYPE;

181: l_tag FND_LOOKUP_VALUES.tag%TYPE;
182: l_time_comparison VARCHAR2(30) := FND_API.G_TRUE;
183: l_correct_contact_type VARCHAR2(30);
184: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
185: l_preference_topic_type HZ_CONTACT_PREFERENCES.preference_topic_type%TYPE;
186: l_preference_topic_type_code HZ_CONTACT_PREFERENCES.preference_topic_type_code%TYPE;
187: l_max_no_of_interact_uom_code HZ_CONTACT_PREFERENCES.max_no_of_interact_uom_code%TYPE;
188: l_reason_code HZ_CONTACT_PREFERENCES.reason_code%TYPE;
189: l_requested_by HZ_CONTACT_PREFERENCES.requested_by%TYPE;

Line 186: l_preference_topic_type_code HZ_CONTACT_PREFERENCES.preference_topic_type_code%TYPE;

182: l_time_comparison VARCHAR2(30) := FND_API.G_TRUE;
183: l_correct_contact_type VARCHAR2(30);
184: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
185: l_preference_topic_type HZ_CONTACT_PREFERENCES.preference_topic_type%TYPE;
186: l_preference_topic_type_code HZ_CONTACT_PREFERENCES.preference_topic_type_code%TYPE;
187: l_max_no_of_interact_uom_code HZ_CONTACT_PREFERENCES.max_no_of_interact_uom_code%TYPE;
188: l_reason_code HZ_CONTACT_PREFERENCES.reason_code%TYPE;
189: l_requested_by HZ_CONTACT_PREFERENCES.requested_by%TYPE;
190: l_status HZ_CONTACT_PREFERENCES.status%TYPE;

Line 187: l_max_no_of_interact_uom_code HZ_CONTACT_PREFERENCES.max_no_of_interact_uom_code%TYPE;

183: l_correct_contact_type VARCHAR2(30);
184: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
185: l_preference_topic_type HZ_CONTACT_PREFERENCES.preference_topic_type%TYPE;
186: l_preference_topic_type_code HZ_CONTACT_PREFERENCES.preference_topic_type_code%TYPE;
187: l_max_no_of_interact_uom_code HZ_CONTACT_PREFERENCES.max_no_of_interact_uom_code%TYPE;
188: l_reason_code HZ_CONTACT_PREFERENCES.reason_code%TYPE;
189: l_requested_by HZ_CONTACT_PREFERENCES.requested_by%TYPE;
190: l_status HZ_CONTACT_PREFERENCES.status%TYPE;
191:

Line 188: l_reason_code HZ_CONTACT_PREFERENCES.reason_code%TYPE;

184: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
185: l_preference_topic_type HZ_CONTACT_PREFERENCES.preference_topic_type%TYPE;
186: l_preference_topic_type_code HZ_CONTACT_PREFERENCES.preference_topic_type_code%TYPE;
187: l_max_no_of_interact_uom_code HZ_CONTACT_PREFERENCES.max_no_of_interact_uom_code%TYPE;
188: l_reason_code HZ_CONTACT_PREFERENCES.reason_code%TYPE;
189: l_requested_by HZ_CONTACT_PREFERENCES.requested_by%TYPE;
190: l_status HZ_CONTACT_PREFERENCES.status%TYPE;
191:
192: BEGIN

Line 189: l_requested_by HZ_CONTACT_PREFERENCES.requested_by%TYPE;

185: l_preference_topic_type HZ_CONTACT_PREFERENCES.preference_topic_type%TYPE;
186: l_preference_topic_type_code HZ_CONTACT_PREFERENCES.preference_topic_type_code%TYPE;
187: l_max_no_of_interact_uom_code HZ_CONTACT_PREFERENCES.max_no_of_interact_uom_code%TYPE;
188: l_reason_code HZ_CONTACT_PREFERENCES.reason_code%TYPE;
189: l_requested_by HZ_CONTACT_PREFERENCES.requested_by%TYPE;
190: l_status HZ_CONTACT_PREFERENCES.status%TYPE;
191:
192: BEGIN
193:

Line 190: l_status HZ_CONTACT_PREFERENCES.status%TYPE;

186: l_preference_topic_type_code HZ_CONTACT_PREFERENCES.preference_topic_type_code%TYPE;
187: l_max_no_of_interact_uom_code HZ_CONTACT_PREFERENCES.max_no_of_interact_uom_code%TYPE;
188: l_reason_code HZ_CONTACT_PREFERENCES.reason_code%TYPE;
189: l_requested_by HZ_CONTACT_PREFERENCES.requested_by%TYPE;
190: l_status HZ_CONTACT_PREFERENCES.status%TYPE;
191:
192: BEGIN
193:
194: -- Check if API is called in debug mode. If yes, enable debug.

Line 211: FROM HZ_CONTACT_PREFERENCES

207: p_contact_preference_rec.contact_preference_id <> FND_API.G_MISS_NUM
208: THEN
209: BEGIN
210: SELECT 'Y' INTO l_dummy
211: FROM HZ_CONTACT_PREFERENCES
212: WHERE CONTACT_PREFERENCE_ID = p_contact_preference_rec.contact_preference_id;
213:
214: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
215: FND_MESSAGE.SET_TOKEN('COLUMN', 'contact_preference_id');

Line 250: FROM HZ_CONTACT_PREFERENCES

246: l_preference_start_time_hr, l_preference_end_time_hr,
247: l_preference_start_time_mi, l_preference_end_time_mi,
248: l_max_no_of_interact_uom_code, l_reason_code, l_requested_by, l_status ,
249: l_created_by_module, l_application_id
250: FROM HZ_CONTACT_PREFERENCES
251: WHERE ROWID = p_rowid;
252: END IF;
253:
254: ----------------------------------------------

Line 1100: FROM HZ_CONTACT_PREFERENCES

1096: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1097: IF p_create_update_flag = 'C' THEN
1098: BEGIN
1099: SELECT contact_preference_id INTO l_contact_pref_dup_id
1100: FROM HZ_CONTACT_PREFERENCES
1101: WHERE
1102: -- check contact_level_table and contact_level_table_id
1103: contact_level_table = p_contact_preference_rec.contact_level_table AND
1104: contact_level_table_id = p_contact_preference_rec.contact_level_table_id AND

Line 1143: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_contact_preferences' );

1139:
1140: -- Bug 2787484
1141: /*
1142: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_RECORD');
1143: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_contact_preferences' );
1144: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'contact_preference_id' );
1145: FND_MESSAGE.SET_TOKEN( 'ID', to_char(l_contact_pref_dup_id) );
1146: */
1147: IF p_contact_preference_rec.contact_level_table = 'HZ_PARTIES'

Line 1173: FROM HZ_CONTACT_PREFERENCES

1169: x_updated_cp_rec => l_contact_preference_rec
1170: );
1171:
1172: SELECT contact_preference_id INTO l_contact_pref_dup_id
1173: FROM HZ_CONTACT_PREFERENCES
1174: WHERE
1175: -- check contact_level_table and contact_level_table_id
1176: contact_preference_id <> l_contact_preference_id AND
1177: contact_level_table = l_contact_preference_rec.contact_level_table AND

Line 1217: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_contact_preferences' );

1213:
1214: -- Bug 2787484
1215: /*
1216: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_RECORD');
1217: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_contact_preferences' );
1218: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'contact_preference_id' );
1219: FND_MESSAGE.SET_TOKEN( 'ID', to_char(l_contact_pref_dup_id) );
1220: */
1221: IF l_contact_preference_rec.contact_level_table = 'HZ_PARTIES'