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.CS_INTERACTION_PVT dependencies on CS_CORE_UTIL

Line 119: cs_core_util.add_null_parameter_msg(l_api_name_full, 'p_user_id');

115:
116: -- Validate user and login session IDs
117: --------------------------------------
118: IF (p_user_id IS NULL) THEN
119: cs_core_util.add_null_parameter_msg(l_api_name_full, 'p_user_id');
120: RAISE fnd_api.g_exc_error;
121: ELSE
122: cs_core_util.validate_who_info
123: ( p_api_name => l_api_name_full,

Line 122: cs_core_util.validate_who_info

118: IF (p_user_id IS NULL) THEN
119: cs_core_util.add_null_parameter_msg(l_api_name_full, 'p_user_id');
120: RAISE fnd_api.g_exc_error;
121: ELSE
122: cs_core_util.validate_who_info
123: ( p_api_name => l_api_name_full,
124: p_parameter_name_usr => 'p_user_id',
125: p_parameter_name_log => 'p_login_id',
126: p_user_id => p_user_id,

Line 136: IF cs_core_util.is_multiorg_enabled THEN

132: END IF;
133:
134: -- Validate operating unit ID
135: -----------------------------
136: IF cs_core_util.is_multiorg_enabled THEN
137: IF (p_org_id IS NULL) THEN
138: cs_core_util.add_null_parameter_msg(l_api_name_full,
139: 'p_org_id');
140: RAISE fnd_api.g_exc_error;

Line 138: cs_core_util.add_null_parameter_msg(l_api_name_full,

134: -- Validate operating unit ID
135: -----------------------------
136: IF cs_core_util.is_multiorg_enabled THEN
137: IF (p_org_id IS NULL) THEN
138: cs_core_util.add_null_parameter_msg(l_api_name_full,
139: 'p_org_id');
140: RAISE fnd_api.g_exc_error;
141: ELSE
142: cs_core_util.validate_operating_unit

Line 142: cs_core_util.validate_operating_unit

138: cs_core_util.add_null_parameter_msg(l_api_name_full,
139: 'p_org_id');
140: RAISE fnd_api.g_exc_error;
141: ELSE
142: cs_core_util.validate_operating_unit
143: ( p_api_name => l_api_name_full,
144: p_parameter_name => 'p_org_id',
145: p_org_id => p_org_id,
146: x_return_status => l_return_status );

Line 153: cs_core_util.add_param_ignored_msg(l_api_name_full, 'p_org_id');

149: END IF;
150: END IF;
151: ELSE
152: IF (p_org_id IS NOT NULL) THEN
153: cs_core_util.add_param_ignored_msg(l_api_name_full, 'p_org_id');
154: l_org_id := NULL;
155: END IF;
156: END IF;
157:

Line 161: cs_core_util.add_null_parameter_msg(l_api_name_full,

157:
158: -- Validate customer ID
159: -----------------------
160: IF (p_customer_id IS NULL) THEN
161: cs_core_util.add_null_parameter_msg(l_api_name_full,
162: 'p_customer_id');
163: RAISE fnd_api.g_exc_error;
164: ELSE
165: cs_core_util.validate_customer

Line 165: cs_core_util.validate_customer

161: cs_core_util.add_null_parameter_msg(l_api_name_full,
162: 'p_customer_id');
163: RAISE fnd_api.g_exc_error;
164: ELSE
165: cs_core_util.validate_customer
166: ( p_api_name => l_api_name_full,
167: p_parameter_name => 'p_customer_id',
168: p_customer_id => p_customer_id,
169: x_return_status => l_return_status );

Line 178: cs_core_util.validate_customer_contact

174:
175: -- Validate contact ID
176: ----------------------
177: IF (p_contact_id IS NOT NULL) THEN
178: cs_core_util.validate_customer_contact
179: ( p_api_name => l_api_name_full,
180: p_parameter_name => 'p_contact_id',
181: p_customer_contact_id => p_contact_id,
182: p_customer_id => p_customer_id,

Line 193: cs_core_util.validate_person

189:
190: -- Validate employee ID
191: -----------------------
192: IF (p_employee_id IS NOT NULL) THEN
193: cs_core_util.validate_person
194: ( p_api_name => l_api_name_full,
195: p_parameter_name => 'p_employee_id',
196: p_person_id => p_employee_id,
197: x_return_status => l_return_status );

Line 208: cs_core_util.add_null_parameter_msg(l_api_name_full,

204:
205: -- Validate interaction type code
206: ---------------------------------
207: IF (p_interaction_type_code IS NULL) THEN
208: cs_core_util.add_null_parameter_msg(l_api_name_full,
209: 'p_interaction_type_code');
210: RAISE fnd_api.g_exc_error;
211: ELSE
212: cs_core_util.validate_lookup_code

Line 212: cs_core_util.validate_lookup_code

208: cs_core_util.add_null_parameter_msg(l_api_name_full,
209: 'p_interaction_type_code');
210: RAISE fnd_api.g_exc_error;
211: ELSE
212: cs_core_util.validate_lookup_code
213: ( p_api_name => l_api_name_full,
214: p_parameter_name => 'p_interaction_type_code',
215: p_lookup_code => p_interaction_type_code,
216: p_lookup_type => 'INTERACTION_TYPE',

Line 226: cs_core_util.add_null_parameter_msg(l_api_name_full,

222:
223: -- Validate interaction category code
224: -------------------------------------
225: IF (p_interaction_category_code IS NULL) THEN
226: cs_core_util.add_null_parameter_msg(l_api_name_full,
227: 'p_interaction_category_code');
228: RAISE fnd_api.g_exc_error;
229: ELSE
230: cs_core_util.validate_lookup_code

Line 230: cs_core_util.validate_lookup_code

226: cs_core_util.add_null_parameter_msg(l_api_name_full,
227: 'p_interaction_category_code');
228: RAISE fnd_api.g_exc_error;
229: ELSE
230: cs_core_util.validate_lookup_code
231: ( p_api_name => l_api_name_full,
232: p_parameter_name => 'p_interaction_category_code',
233: p_lookup_code => p_interaction_category_code,
234: p_lookup_type => 'INTERACTION_CATEGORY',

Line 244: cs_core_util.add_null_parameter_msg(l_api_name_full,

240:
241: -- Validate interaction method code
242: -----------------------------------
243: IF (p_interaction_method_code IS NULL) THEN
244: cs_core_util.add_null_parameter_msg(l_api_name_full,
245: 'p_interaction_method_code');
246: RAISE fnd_api.g_exc_error;
247: ELSE
248: cs_core_util.validate_lookup_code

Line 248: cs_core_util.validate_lookup_code

244: cs_core_util.add_null_parameter_msg(l_api_name_full,
245: 'p_interaction_method_code');
246: RAISE fnd_api.g_exc_error;
247: ELSE
248: cs_core_util.validate_lookup_code
249: ( p_api_name => l_api_name_full,
250: p_parameter_name => 'p_interaction_method_code',
251: p_lookup_code => p_interaction_method_code,
252: p_lookup_type => 'INTERACTION_METHOD',

Line 262: cs_core_util.add_null_parameter_msg(l_api_name_full,

258:
259: -- Validate interaction date
260: ----------------------------
261: IF (p_interaction_date IS NULL) THEN
262: cs_core_util.add_null_parameter_msg(l_api_name_full,
263: 'p_interaction_date');
264: RAISE fnd_api.g_exc_error;
265: END IF;
266:

Line 270: cs_core_util.validate_lookup_code

266:
267: -- Validate interaction document code
268: -------------------------------------
269: IF (p_interaction_document_code IS NOT NULL) THEN
270: cs_core_util.validate_lookup_code
271: ( p_api_name => l_api_name_full,
272: p_parameter_name => 'p_interaction_document_code',
273: p_lookup_code => p_interaction_document_code,
274: p_lookup_type => 'INTERACTION_DOCUMENT',

Line 283: cs_core_util.trunc_string_length(l_api_name_full, 'p_source_document_name',

279: --
280: -- Validate document number when document type is not null
281: --
282: IF (p_source_document_name IS NOT NULL) then
283: cs_core_util.trunc_string_length(l_api_name_full, 'p_source_document_name',
284: p_source_document_name, 80,
285: l_source_document_name);
286: --
287: -- Validate document form and status when document number is not

Line 291: cs_core_util.trunc_string_length(l_api_name_full, 'p_reference_form',

287: -- Validate document form and status when document number is not
288: -- null
289: --
290: IF (p_reference_form IS NOT NULL) then
291: cs_core_util.trunc_string_length(l_api_name_full, 'p_reference_form',
292: p_reference_form, 2000, l_reference_form);
293: END IF;
294: IF (p_source_document_status IS NOT NULL) then
295: cs_core_util.trunc_string_length(l_api_name_full, 'p_source_document_status',

Line 295: cs_core_util.trunc_string_length(l_api_name_full, 'p_source_document_status',

291: cs_core_util.trunc_string_length(l_api_name_full, 'p_reference_form',
292: p_reference_form, 2000, l_reference_form);
293: END IF;
294: IF (p_source_document_status IS NOT NULL) then
295: cs_core_util.trunc_string_length(l_api_name_full, 'p_source_document_status',
296: p_source_document_status, 80,
297: l_source_document_status);
298: END IF;
299: ELSE

Line 304: cs_core_util.add_param_ignored_msg(l_api_name_full,

300: --
301: -- Ignore document form and status when document number is null
302: --
303: IF (p_reference_form IS NOT NULL) then
304: cs_core_util.add_param_ignored_msg(l_api_name_full,
305: 'p_reference_form');
306: END IF;
307: IF (p_source_document_status IS NOT NULL) then
308: cs_core_util.add_param_ignored_msg(l_api_name_full,

Line 308: cs_core_util.add_param_ignored_msg(l_api_name_full,

304: cs_core_util.add_param_ignored_msg(l_api_name_full,
305: 'p_reference_form');
306: END IF;
307: IF (p_source_document_status IS NOT NULL) then
308: cs_core_util.add_param_ignored_msg(l_api_name_full,
309: 'p_source_document_status');
310: END IF;
311: END IF;
312: ELSE

Line 318: cs_core_util.add_param_ignored_msg(l_api_name_full,

314: -- Ignore document ID, number, form and status when document type is
315: -- null
316: --
317: IF (p_source_document_id IS NOT NULL) THEN
318: cs_core_util.add_param_ignored_msg(l_api_name_full,
319: 'p_source_document_id');
320: l_source_document_id := NULL;
321: END IF;
322: IF (p_source_document_name IS NOT NULL) THEN

Line 323: cs_core_util.add_param_ignored_msg(l_api_name_full,

319: 'p_source_document_id');
320: l_source_document_id := NULL;
321: END IF;
322: IF (p_source_document_name IS NOT NULL) THEN
323: cs_core_util.add_param_ignored_msg(l_api_name_full,
324: 'p_source_document_name');
325: END IF;
326: IF (p_reference_form IS NOT NULL) then
327: cs_core_util.add_param_ignored_msg(l_api_name_full,

Line 327: cs_core_util.add_param_ignored_msg(l_api_name_full,

323: cs_core_util.add_param_ignored_msg(l_api_name_full,
324: 'p_source_document_name');
325: END IF;
326: IF (p_reference_form IS NOT NULL) then
327: cs_core_util.add_param_ignored_msg(l_api_name_full,
328: 'p_reference_form');
329: END IF;
330: IF (p_source_document_status IS NOT NULL) then
331: cs_core_util.add_param_ignored_msg(l_api_name_full,

Line 331: cs_core_util.add_param_ignored_msg(l_api_name_full,

327: cs_core_util.add_param_ignored_msg(l_api_name_full,
328: 'p_reference_form');
329: END IF;
330: IF (p_source_document_status IS NOT NULL) then
331: cs_core_util.add_param_ignored_msg(l_api_name_full,
332: 'p_source_document_status');
333: END IF;
334: END IF; /* p_interaction_document_code IS NOT NULL */
335:

Line 339: cs_core_util.add_invalid_argument_msg(l_api_name_full, p_public_flag,

335:
336: -- Validate public flag
337: -----------------------
338: IF (p_public_flag <> 'Y') AND (p_public_flag <> 'N') THEN
339: cs_core_util.add_invalid_argument_msg(l_api_name_full, p_public_flag,
340: 'p_public_flag');
341: RAISE fnd_api.g_exc_error;
342: END IF;
343:

Line 365: cs_core_util.validate_desc_flex

361: p_attribute5 || p_attribute6 || p_attribute7 || p_attribute8 ||
362: p_attribute9 || p_attribute10 || p_attribute11 || p_attribute12 ||
363: p_attribute13 || p_attribute14 || p_attribute15 ||
364: p_attribute_category) IS NOT NULL) THEN
365: cs_core_util.validate_desc_flex
366: ( p_api_name => l_api_name_full,
367: p_desc_flex_name => 'CS_INTERACTIONS',
368: p_column_name1 => 'ATTRIBUTE1',
369: p_column_name2 => 'ATTRIBUTE2',

Line 410: cs_core_util.trunc_string_length(l_api_name_full, 'p_phone_area_code',

406:
407: -- Validate string lengths
408: --------------------------
409: IF (p_phone_area_code IS NOT NULL) then
410: cs_core_util.trunc_string_length(l_api_name_full, 'p_phone_area_code',
411: p_phone_area_code, 10,
412: l_phone_area_code);
413: END IF;
414: IF (p_phone_number IS NOT NULL) then

Line 415: cs_core_util.trunc_string_length(l_api_name_full, 'p_phone_number',

411: p_phone_area_code, 10,
412: l_phone_area_code);
413: END IF;
414: IF (p_phone_number IS NOT NULL) then
415: cs_core_util.trunc_string_length(l_api_name_full, 'p_phone_number',
416: p_phone_number, 25, l_phone_number);
417: END IF;
418: IF (p_phone_extension IS NOT NULL) then
419: cs_core_util.trunc_string_length(l_api_name_full, 'p_phone_extension',

Line 419: cs_core_util.trunc_string_length(l_api_name_full, 'p_phone_extension',

415: cs_core_util.trunc_string_length(l_api_name_full, 'p_phone_number',
416: p_phone_number, 25, l_phone_number);
417: END IF;
418: IF (p_phone_extension IS NOT NULL) then
419: cs_core_util.trunc_string_length(l_api_name_full, 'p_phone_extension',
420: p_phone_extension, 20,
421: l_phone_extension);
422: END IF;
423: IF (p_fax_area_code IS NOT NULL) then

Line 424: cs_core_util.trunc_string_length(l_api_name_full, 'p_fax_area_code',

420: p_phone_extension, 20,
421: l_phone_extension);
422: END IF;
423: IF (p_fax_area_code IS NOT NULL) then
424: cs_core_util.trunc_string_length(l_api_name_full, 'p_fax_area_code',
425: p_fax_area_code, 10,
426: l_fax_area_code);
427: END IF;
428: IF (p_fax_number IS NOT NULL) then

Line 429: cs_core_util.trunc_string_length(l_api_name_full, 'p_fax_number',

425: p_fax_area_code, 10,
426: l_fax_area_code);
427: END IF;
428: IF (p_fax_number IS NOT NULL) then
429: cs_core_util.trunc_string_length(l_api_name_full, 'p_fax_number',
430: p_fax_number, 25, l_fax_number);
431: END IF;
432: IF (p_email_address IS NOT NULL) then
433: cs_core_util.trunc_string_length(l_api_name_full, 'p_email_address',

Line 433: cs_core_util.trunc_string_length(l_api_name_full, 'p_email_address',

429: cs_core_util.trunc_string_length(l_api_name_full, 'p_fax_number',
430: p_fax_number, 25, l_fax_number);
431: END IF;
432: IF (p_email_address IS NOT NULL) then
433: cs_core_util.trunc_string_length(l_api_name_full, 'p_email_address',
434: p_email_address, 240,
435: l_email_address);
436: END IF;
437: IF (p_follow_up_action IS NOT NULL) then

Line 438: cs_core_util.trunc_string_length(l_api_name_full,

434: p_email_address, 240,
435: l_email_address);
436: END IF;
437: IF (p_follow_up_action IS NOT NULL) then
438: cs_core_util.trunc_string_length(l_api_name_full,
439: 'p_follow_up_action',
440: p_follow_up_action, 80,
441: l_follow_up_action);
442: END IF;

Line 444: cs_core_util.trunc_string_length(l_api_name_full, 'p_notes', p_notes,

440: p_follow_up_action, 80,
441: l_follow_up_action);
442: END IF;
443: IF (p_notes IS NOT NULL) then
444: cs_core_util.trunc_string_length(l_api_name_full, 'p_notes', p_notes,
445: 2000, l_notes);
446: END IF;
447:
448: ELSE