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.JTF_TASK_PHONES_PUB dependencies on FND_API

Line 96: x_return_status := fnd_api.g_ret_sts_success;

92: FROM jtf_task_phones
93: WHERE ROWID = l_rowid;
94: BEGIN
95: SAVEPOINT create_task_phones_pub;
96: x_return_status := fnd_api.g_ret_sts_success;
97:
98: IF NOT fnd_api.compatible_api_call (
99: l_api_version,
100: p_api_version,

Line 98: IF NOT fnd_api.compatible_api_call (

94: BEGIN
95: SAVEPOINT create_task_phones_pub;
96: x_return_status := fnd_api.g_ret_sts_success;
97:
98: IF NOT fnd_api.compatible_api_call (
99: l_api_version,
100: p_api_version,
101: l_api_name,
102: g_pkg_name

Line 105: RAISE fnd_api.g_exc_unexpected_error;

101: l_api_name,
102: g_pkg_name
103: )
104: THEN
105: RAISE fnd_api.g_exc_unexpected_error;
106: END IF;
107:
108: IF fnd_api.to_boolean (p_init_msg_list)
109: THEN

Line 108: IF fnd_api.to_boolean (p_init_msg_list)

104: THEN
105: RAISE fnd_api.g_exc_unexpected_error;
106: END IF;
107:
108: IF fnd_api.to_boolean (p_init_msg_list)
109: THEN
110: fnd_msg_pub.initialize;
111: END IF;
112:

Line 118: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

114: p_owner_table_name => p_owner_table_name,
115: x_return_status => x_return_status
116: );
117:
118: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
119: THEN
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121: RAISE fnd_api.g_exc_unexpected_error;
122: END IF;

Line 120: x_return_status := fnd_api.g_ret_sts_unexp_error;

116: );
117:
118: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
119: THEN
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121: RAISE fnd_api.g_exc_unexpected_error;
122: END IF;
123:
124: jtf_task_utl.validate_missing_phone_id (

Line 121: RAISE fnd_api.g_exc_unexpected_error;

117:
118: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
119: THEN
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121: RAISE fnd_api.g_exc_unexpected_error;
122: END IF;
123:
124: jtf_task_utl.validate_missing_phone_id (
125: p_task_phone_id => p_phone_id,

Line 129: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

125: p_task_phone_id => p_phone_id,
126: x_return_status => x_return_status
127: );
128:
129: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
130: THEN
131: x_return_status := fnd_api.g_ret_sts_unexp_error;
132: RAISE fnd_api.g_exc_unexpected_error;
133: END IF;

Line 131: x_return_status := fnd_api.g_ret_sts_unexp_error;

127: );
128:
129: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
130: THEN
131: x_return_status := fnd_api.g_ret_sts_unexp_error;
132: RAISE fnd_api.g_exc_unexpected_error;
133: END IF;
134:
135: jtf_task_utl.validate_missing_contact_id (

Line 132: RAISE fnd_api.g_exc_unexpected_error;

128:
129: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
130: THEN
131: x_return_status := fnd_api.g_ret_sts_unexp_error;
132: RAISE fnd_api.g_exc_unexpected_error;
133: END IF;
134:
135: jtf_task_utl.validate_missing_contact_id (
136: p_task_contact_id => p_task_contact_id,

Line 140: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

136: p_task_contact_id => p_task_contact_id,
137: x_return_status => x_return_status
138: );
139:
140: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
141: THEN
142: x_return_status := fnd_api.g_ret_sts_unexp_error;
143: RAISE fnd_api.g_exc_unexpected_error;
144: END IF;

Line 142: x_return_status := fnd_api.g_ret_sts_unexp_error;

138: );
139:
140: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
141: THEN
142: x_return_status := fnd_api.g_ret_sts_unexp_error;
143: RAISE fnd_api.g_exc_unexpected_error;
144: END IF;
145:
146: jtf_task_utl.validate_contact_point (

Line 143: RAISE fnd_api.g_exc_unexpected_error;

139:
140: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
141: THEN
142: x_return_status := fnd_api.g_ret_sts_unexp_error;
143: RAISE fnd_api.g_exc_unexpected_error;
144: END IF;
145:
146: jtf_task_utl.validate_contact_point (
147: p_contact_id => p_task_contact_id,

Line 153: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

149: x_return_status => x_return_status,
150: p_owner_table_name => p_owner_table_name
151: );
152:
153: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
154: THEN
155: x_return_status := fnd_api.g_ret_sts_unexp_error;
156: RAISE fnd_api.g_exc_unexpected_error;
157: END IF;

Line 155: x_return_status := fnd_api.g_ret_sts_unexp_error;

151: );
152:
153: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
154: THEN
155: x_return_status := fnd_api.g_ret_sts_unexp_error;
156: RAISE fnd_api.g_exc_unexpected_error;
157: END IF;
158:
159: jtf_task_utl.validate_flag (

Line 156: RAISE fnd_api.g_exc_unexpected_error;

152:
153: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
154: THEN
155: x_return_status := fnd_api.g_ret_sts_unexp_error;
156: RAISE fnd_api.g_exc_unexpected_error;
157: END IF;
158:
159: jtf_task_utl.validate_flag (
160: p_flag_name => jtf_task_utl.get_translated_lookup (

Line 168: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

164: p_flag_value => p_primary_flag,
165: x_return_status => x_return_status
166: );
167:
168: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
169: THEN
170: x_return_status := fnd_api.g_ret_sts_unexp_error;
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;

Line 170: x_return_status := fnd_api.g_ret_sts_unexp_error;

166: );
167:
168: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
169: THEN
170: x_return_status := fnd_api.g_ret_sts_unexp_error;
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
174: SELECT jtf_task_phones_s.nextval

Line 171: RAISE fnd_api.g_exc_unexpected_error;

167:
168: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
169: THEN
170: x_return_status := fnd_api.g_ret_sts_unexp_error;
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
174: SELECT jtf_task_phones_s.nextval
175: INTO l_task_phone_id

Line 230: x_return_status := fnd_api.g_ret_sts_unexp_error;

226: FETCH c_jtf_task_phones INTO x;
227:
228: IF c_jtf_task_phones%NOTFOUND
229: THEN
230: x_return_status := fnd_api.g_ret_sts_unexp_error;
231: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_PHONE');
232: fnd_msg_pub.add;
233: RAISE fnd_api.g_exc_unexpected_error;
234: ELSE

Line 233: RAISE fnd_api.g_exc_unexpected_error;

229: THEN
230: x_return_status := fnd_api.g_ret_sts_unexp_error;
231: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_PHONE');
232: fnd_msg_pub.add;
233: RAISE fnd_api.g_exc_unexpected_error;
234: ELSE
235: x_task_phone_id := l_task_phone_id;
236: END IF;
237:

Line 238: IF fnd_api.to_boolean (p_commit)

234: ELSE
235: x_task_phone_id := l_task_phone_id;
236: END IF;
237:
238: IF fnd_api.to_boolean (p_commit)
239: THEN
240: COMMIT WORK;
241: END IF;
242:

Line 245: WHEN fnd_api.g_exc_unexpected_error

241: END IF;
242:
243: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
244: EXCEPTION
245: WHEN fnd_api.g_exc_unexpected_error
246: THEN
247: ROLLBACK TO create_task_phones_pub;
248: x_return_status := fnd_api.g_ret_sts_unexp_error;
249: fnd_msg_pub.count_and_get (

Line 248: x_return_status := fnd_api.g_ret_sts_unexp_error;

244: EXCEPTION
245: WHEN fnd_api.g_exc_unexpected_error
246: THEN
247: ROLLBACK TO create_task_phones_pub;
248: x_return_status := fnd_api.g_ret_sts_unexp_error;
249: fnd_msg_pub.count_and_get (
250: p_count => x_msg_count,
251: p_data => x_msg_data
252: );

Line 259: x_return_status := fnd_api.g_ret_sts_unexp_error;

255: ROLLBACK TO create_task_phones_pub;
256: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
257: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
258: fnd_msg_pub.add;
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260: fnd_msg_pub.count_and_get (
261: p_count => x_msg_count,
262: p_data => x_msg_data
263: );

Line 283: x_return_status := fnd_api.g_ret_sts_success;

279: resource_locked EXCEPTION;
280: PRAGMA EXCEPTION_INIT (resource_locked, -54);
281: BEGIN
282: SAVEPOINT lock_task_phones_pub;
283: x_return_status := fnd_api.g_ret_sts_success;
284:
285: IF NOT fnd_api.compatible_api_call (
286: l_api_version,
287: p_api_version,

Line 285: IF NOT fnd_api.compatible_api_call (

281: BEGIN
282: SAVEPOINT lock_task_phones_pub;
283: x_return_status := fnd_api.g_ret_sts_success;
284:
285: IF NOT fnd_api.compatible_api_call (
286: l_api_version,
287: p_api_version,
288: l_api_name,
289: g_pkg_name

Line 292: RAISE fnd_api.g_exc_unexpected_error;

288: l_api_name,
289: g_pkg_name
290: )
291: THEN
292: RAISE fnd_api.g_exc_unexpected_error;
293: END IF;
294:
295: IF fnd_api.to_boolean (p_init_msg_list)
296: THEN

Line 295: IF fnd_api.to_boolean (p_init_msg_list)

291: THEN
292: RAISE fnd_api.g_exc_unexpected_error;
293: END IF;
294:
295: IF fnd_api.to_boolean (p_init_msg_list)
296: THEN
297: fnd_msg_pub.initialize;
298: END IF;
299:

Line 300: x_return_status := fnd_api.g_ret_sts_success;

296: THEN
297: fnd_msg_pub.initialize;
298: END IF;
299:
300: x_return_status := fnd_api.g_ret_sts_success;
301: jtf_task_phones_pkg.lock_row (
302: x_task_phone_id => p_task_phone_id,
303: x_object_version_number => p_object_version_number
304: );

Line 313: x_return_status := fnd_api.g_ret_sts_unexp_error;

309: ROLLBACK TO lock_task_phones_pub;
310: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
311: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
312: fnd_msg_pub.add;
313: x_return_status := fnd_api.g_ret_sts_unexp_error;
314: fnd_msg_pub.count_and_get (
315: p_count => x_msg_count,
316: p_data => x_msg_data
317: );

Line 318: WHEN fnd_api.g_exc_unexpected_error

314: fnd_msg_pub.count_and_get (
315: p_count => x_msg_count,
316: p_data => x_msg_data
317: );
318: WHEN fnd_api.g_exc_unexpected_error
319: THEN
320: ROLLBACK TO lock_task_phones_pub;
321: x_return_status := fnd_api.g_ret_sts_unexp_error;
322: fnd_msg_pub.count_and_get (

Line 321: x_return_status := fnd_api.g_ret_sts_unexp_error;

317: );
318: WHEN fnd_api.g_exc_unexpected_error
319: THEN
320: ROLLBACK TO lock_task_phones_pub;
321: x_return_status := fnd_api.g_ret_sts_unexp_error;
322: fnd_msg_pub.count_and_get (
323: p_count => x_msg_count,
324: p_data => x_msg_data
325: );

Line 332: x_return_status := fnd_api.g_ret_sts_unexp_error;

328: ROLLBACK TO lock_task_phones_pub;
329: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
330: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
331: fnd_msg_pub.add;
332: x_return_status := fnd_api.g_ret_sts_unexp_error;
333: fnd_msg_pub.count_and_get (
334: p_count => x_msg_count,
335: p_data => x_msg_data
336: );

Line 380: fnd_api.g_miss_char, attribute1,

376: CURSOR c_task_phones
377: IS
378: SELECT DECODE (
379: p_attribute1,
380: fnd_api.g_miss_char, attribute1,
381: p_attribute1
382: ) attribute1,
383: DECODE (
384: p_attribute2,

Line 385: fnd_api.g_miss_char, attribute2,

381: p_attribute1
382: ) attribute1,
383: DECODE (
384: p_attribute2,
385: fnd_api.g_miss_char, attribute2,
386: p_attribute2
387: ) attribute2,
388: DECODE (
389: p_attribute3,

Line 390: fnd_api.g_miss_char, attribute3,

386: p_attribute2
387: ) attribute2,
388: DECODE (
389: p_attribute3,
390: fnd_api.g_miss_char, attribute3,
391: p_attribute3
392: ) attribute3,
393: DECODE (
394: p_attribute4,

Line 395: fnd_api.g_miss_char, attribute4,

391: p_attribute3
392: ) attribute3,
393: DECODE (
394: p_attribute4,
395: fnd_api.g_miss_char, attribute4,
396: p_attribute4
397: ) attribute4,
398: DECODE (
399: p_attribute5,

Line 400: fnd_api.g_miss_char, attribute5,

396: p_attribute4
397: ) attribute4,
398: DECODE (
399: p_attribute5,
400: fnd_api.g_miss_char, attribute5,
401: p_attribute5
402: ) attribute5,
403: DECODE (
404: p_attribute6,

Line 405: fnd_api.g_miss_char, attribute6,

401: p_attribute5
402: ) attribute5,
403: DECODE (
404: p_attribute6,
405: fnd_api.g_miss_char, attribute6,
406: p_attribute6
407: ) attribute6,
408: DECODE (
409: p_attribute7,

Line 410: fnd_api.g_miss_char, attribute7,

406: p_attribute6
407: ) attribute6,
408: DECODE (
409: p_attribute7,
410: fnd_api.g_miss_char, attribute7,
411: p_attribute7
412: ) attribute7,
413: DECODE (
414: p_attribute8,

Line 415: fnd_api.g_miss_char, attribute8,

411: p_attribute7
412: ) attribute7,
413: DECODE (
414: p_attribute8,
415: fnd_api.g_miss_char, attribute8,
416: p_attribute8
417: ) attribute8,
418: DECODE (
419: p_attribute9,

Line 420: fnd_api.g_miss_char, attribute9,

416: p_attribute8
417: ) attribute8,
418: DECODE (
419: p_attribute9,
420: fnd_api.g_miss_char, attribute9,
421: p_attribute9
422: ) attribute9,
423: DECODE (
424: p_attribute10,

Line 425: fnd_api.g_miss_char, attribute10,

421: p_attribute9
422: ) attribute9,
423: DECODE (
424: p_attribute10,
425: fnd_api.g_miss_char, attribute10,
426: p_attribute10
427: ) attribute10,
428: DECODE (
429: p_attribute11,

Line 430: fnd_api.g_miss_char, attribute11,

426: p_attribute10
427: ) attribute10,
428: DECODE (
429: p_attribute11,
430: fnd_api.g_miss_char, attribute11,
431: p_attribute11
432: ) attribute11,
433: DECODE (
434: p_attribute12,

Line 435: fnd_api.g_miss_char, attribute12,

431: p_attribute11
432: ) attribute11,
433: DECODE (
434: p_attribute12,
435: fnd_api.g_miss_char, attribute12,
436: p_attribute12
437: ) attribute12,
438: DECODE (
439: p_attribute13,

Line 440: fnd_api.g_miss_char, attribute13,

436: p_attribute12
437: ) attribute12,
438: DECODE (
439: p_attribute13,
440: fnd_api.g_miss_char, attribute13,
441: p_attribute13
442: ) attribute13,
443: DECODE (
444: p_attribute14,

Line 445: fnd_api.g_miss_char, attribute14,

441: p_attribute13
442: ) attribute13,
443: DECODE (
444: p_attribute14,
445: fnd_api.g_miss_char, attribute14,
446: p_attribute14
447: ) attribute14,
448: DECODE (
449: p_attribute15,

Line 450: fnd_api.g_miss_char, attribute15,

446: p_attribute14
447: ) attribute14,
448: DECODE (
449: p_attribute15,
450: fnd_api.g_miss_char, attribute15,
451: p_attribute15
452: ) attribute15,
453: DECODE (
454: p_attribute_category,

Line 455: fnd_api.g_miss_char, attribute_category,

451: p_attribute15
452: ) attribute15,
453: DECODE (
454: p_attribute_category,
455: fnd_api.g_miss_char, attribute_category,
456: p_attribute_category
457: ) attribute_category,
458: DECODE (
459: p_primary_flag,

Line 460: fnd_api.g_miss_char, primary_flag,

456: p_attribute_category
457: ) attribute_category,
458: DECODE (
459: p_primary_flag,
460: fnd_api.g_miss_char, primary_flag,
461: p_primary_flag
462: ) primary_flag,
463: owner_table_name
464: FROM jtf_task_phones

Line 471: x_return_status := fnd_api.g_ret_sts_success;

467: task_phones c_task_phones%ROWTYPE;
468: l_owner_table_name VARCHAR2(30);
469: BEGIN
470: SAVEPOINT update_task_phones_pub;
471: x_return_status := fnd_api.g_ret_sts_success;
472:
473: IF NOT fnd_api.compatible_api_call (
474: l_api_version,
475: p_api_version,

Line 473: IF NOT fnd_api.compatible_api_call (

469: BEGIN
470: SAVEPOINT update_task_phones_pub;
471: x_return_status := fnd_api.g_ret_sts_success;
472:
473: IF NOT fnd_api.compatible_api_call (
474: l_api_version,
475: p_api_version,
476: l_api_name,
477: g_pkg_name

Line 480: RAISE fnd_api.g_exc_unexpected_error;

476: l_api_name,
477: g_pkg_name
478: )
479: THEN
480: RAISE fnd_api.g_exc_unexpected_error;
481: END IF;
482:
483: IF fnd_api.to_boolean (p_init_msg_list)
484: THEN

Line 483: IF fnd_api.to_boolean (p_init_msg_list)

479: THEN
480: RAISE fnd_api.g_exc_unexpected_error;
481: END IF;
482:
483: IF fnd_api.to_boolean (p_init_msg_list)
484: THEN
485: fnd_msg_pub.initialize;
486: END IF;
487:

Line 492: x_return_status := fnd_api.g_ret_sts_unexp_error;

488: IF p_task_phone_id IS NULL
489: THEN
490: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_PHONE_ID');
491: fnd_msg_pub.add;
492: x_return_status := fnd_api.g_ret_sts_unexp_error;
493: RAISE fnd_api.g_exc_unexpected_error;
494: END IF;
495:
496: BEGIN

Line 493: RAISE fnd_api.g_exc_unexpected_error;

489: THEN
490: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_PHONE_ID');
491: fnd_msg_pub.add;
492: x_return_status := fnd_api.g_ret_sts_unexp_error;
493: RAISE fnd_api.g_exc_unexpected_error;
494: END IF;
495:
496: BEGIN
497: --- Added the nvl clause for backward compatibility

Line 509: x_return_status := fnd_api.g_ret_sts_unexp_error;

505: WHEN NO_DATA_FOUND
506: THEN
507: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE');
508: fnd_msg_pub.add;
509: x_return_status := fnd_api.g_ret_sts_unexp_error;
510: RAISE fnd_api.g_exc_unexpected_error;
511: END;
512:
513: IF l_owner_table_name = 'JTF_TASK_CONTACTS'

Line 510: RAISE fnd_api.g_exc_unexpected_error;

506: THEN
507: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE');
508: fnd_msg_pub.add;
509: x_return_status := fnd_api.g_ret_sts_unexp_error;
510: RAISE fnd_api.g_exc_unexpected_error;
511: END;
512:
513: IF l_owner_table_name = 'JTF_TASK_CONTACTS'
514: THEN

Line 525: x_return_status := fnd_api.g_ret_sts_unexp_error;

521: WHEN NO_DATA_FOUND
522: THEN
523: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACT');
524: fnd_msg_pub.add;
525: x_return_status := fnd_api.g_ret_sts_unexp_error;
526: RAISE fnd_api.g_exc_unexpected_error;
527: END;
528: ELSE
529: BEGIN

Line 526: RAISE fnd_api.g_exc_unexpected_error;

522: THEN
523: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACT');
524: fnd_msg_pub.add;
525: x_return_status := fnd_api.g_ret_sts_unexp_error;
526: RAISE fnd_api.g_exc_unexpected_error;
527: END;
528: ELSE
529: BEGIN
530: SELECT customer_id

Line 539: x_return_status := fnd_api.g_ret_sts_unexp_error;

535: WHEN NO_DATA_FOUND
536: THEN
537: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE');
538: fnd_msg_pub.add;
539: x_return_status := fnd_api.g_ret_sts_unexp_error;
540: RAISE fnd_api.g_exc_unexpected_error;
541: END;
542: END IF;
543:

Line 540: RAISE fnd_api.g_exc_unexpected_error;

536: THEN
537: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE');
538: fnd_msg_pub.add;
539: x_return_status := fnd_api.g_ret_sts_unexp_error;
540: RAISE fnd_api.g_exc_unexpected_error;
541: END;
542: END IF;
543:
544: IF p_phone_id IS NULL

Line 548: x_return_status := fnd_api.g_ret_sts_unexp_error;

544: IF p_phone_id IS NULL
545: THEN
546: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_PHONE');
547: fnd_msg_pub.add;
548: x_return_status := fnd_api.g_ret_sts_unexp_error;
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;
551:
552: OPEN c_task_phones;

Line 549: RAISE fnd_api.g_exc_unexpected_error;

545: THEN
546: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_PHONE');
547: fnd_msg_pub.add;
548: x_return_status := fnd_api.g_ret_sts_unexp_error;
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;
551:
552: OPEN c_task_phones;
553: FETCH c_task_phones INTO task_phones;

Line 561: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

557: x_return_status => x_return_status,
558: p_owner_table_name => task_phones.owner_table_name
559: );
560:
561: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
562: THEN
563: x_return_status := fnd_api.g_ret_sts_unexp_error;
564: RAISE fnd_api.g_exc_unexpected_error;
565: END IF;

Line 563: x_return_status := fnd_api.g_ret_sts_unexp_error;

559: );
560:
561: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
562: THEN
563: x_return_status := fnd_api.g_ret_sts_unexp_error;
564: RAISE fnd_api.g_exc_unexpected_error;
565: END IF;
566:
567: BEGIN

Line 564: RAISE fnd_api.g_exc_unexpected_error;

560:
561: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
562: THEN
563: x_return_status := fnd_api.g_ret_sts_unexp_error;
564: RAISE fnd_api.g_exc_unexpected_error;
565: END IF;
566:
567: BEGIN
568: SELECT 1

Line 578: RAISE fnd_api.g_exc_unexpected_error;

574: THEN
575: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE');
576: fnd_message.set_token ('P_TASK_PHONE_ID', p_task_phone_id);
577: fnd_msg_pub.add;
578: RAISE fnd_api.g_exc_unexpected_error;
579: END;
580:
581: jtf_task_phones_pub.lock_task_phones (
582: p_api_version => 1.0,

Line 583: p_init_msg_list => fnd_api.g_false,

579: END;
580:
581: jtf_task_phones_pub.lock_task_phones (
582: p_api_version => 1.0,
583: p_init_msg_list => fnd_api.g_false,
584: p_commit => fnd_api.g_false,
585: p_task_phone_id => p_task_phone_id,
586: p_object_version_number => p_object_version_number,
587: x_return_status => x_return_status,

Line 584: p_commit => fnd_api.g_false,

580:
581: jtf_task_phones_pub.lock_task_phones (
582: p_api_version => 1.0,
583: p_init_msg_list => fnd_api.g_false,
584: p_commit => fnd_api.g_false,
585: p_task_phone_id => p_task_phone_id,
586: p_object_version_number => p_object_version_number,
587: x_return_status => x_return_status,
588: x_msg_data => x_msg_data,

Line 592: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

588: x_msg_data => x_msg_data,
589: x_msg_count => x_msg_count
590: );
591:
592: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
593: THEN
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: RAISE fnd_api.g_exc_unexpected_error;
596: END IF;

Line 594: x_return_status := fnd_api.g_ret_sts_unexp_error;

590: );
591:
592: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
593: THEN
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: RAISE fnd_api.g_exc_unexpected_error;
596: END IF;
597:
598: jtf_task_utl.validate_flag (

Line 595: RAISE fnd_api.g_exc_unexpected_error;

591:
592: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
593: THEN
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: RAISE fnd_api.g_exc_unexpected_error;
596: END IF;
597:
598: jtf_task_utl.validate_flag (
599: p_flag_name => jtf_task_utl.get_translated_lookup (

Line 607: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

603: p_flag_value => task_phones.primary_flag,
604: x_return_status => x_return_status
605: );
606:
607: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
608: THEN
609: x_return_status := fnd_api.g_ret_sts_unexp_error;
610: RAISE fnd_api.g_exc_unexpected_error;
611: END IF;

Line 609: x_return_status := fnd_api.g_ret_sts_unexp_error;

605: );
606:
607: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
608: THEN
609: x_return_status := fnd_api.g_ret_sts_unexp_error;
610: RAISE fnd_api.g_exc_unexpected_error;
611: END IF;
612:
613: --Unmark the previous contact points with primary flag = 'Y'.

Line 610: RAISE fnd_api.g_exc_unexpected_error;

606:
607: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
608: THEN
609: x_return_status := fnd_api.g_ret_sts_unexp_error;
610: RAISE fnd_api.g_exc_unexpected_error;
611: END IF;
612:
613: --Unmark the previous contact points with primary flag = 'Y'.
614: IF p_primary_flag = jtf_task_utl.g_yes

Line 654: IF fnd_api.to_boolean (p_commit)

650: -- Increase ovn when all the process is successfully completed
651: -- bug 2667735
652: p_object_version_number := p_object_version_number + 1;
653:
654: IF fnd_api.to_boolean (p_commit)
655: THEN
656: COMMIT WORK;
657: END IF;
658:

Line 661: WHEN fnd_api.g_exc_unexpected_error

657: END IF;
658:
659: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
660: EXCEPTION
661: WHEN fnd_api.g_exc_unexpected_error
662: THEN
663: ROLLBACK TO update_task_phones_pub;
664: x_return_status := fnd_api.g_ret_sts_unexp_error;
665: fnd_msg_pub.count_and_get (

Line 664: x_return_status := fnd_api.g_ret_sts_unexp_error;

660: EXCEPTION
661: WHEN fnd_api.g_exc_unexpected_error
662: THEN
663: ROLLBACK TO update_task_phones_pub;
664: x_return_status := fnd_api.g_ret_sts_unexp_error;
665: fnd_msg_pub.count_and_get (
666: p_count => x_msg_count,
667: p_data => x_msg_data
668: );

Line 675: x_return_status := fnd_api.g_ret_sts_unexp_error;

671: ROLLBACK TO update_task_phones_pub;
672: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
673: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
674: fnd_msg_pub.add;
675: x_return_status := fnd_api.g_ret_sts_unexp_error;
676: fnd_msg_pub.count_and_get (
677: p_count => x_msg_count,
678: p_data => x_msg_data
679: );

Line 704: x_return_status := fnd_api.g_ret_sts_success;

700: FROM jtf_task_phones
701: WHERE task_phone_id = p_task_phone_id;
702: BEGIN
703: SAVEPOINT delete_task_phones_pub;
704: x_return_status := fnd_api.g_ret_sts_success;
705:
706: IF NOT fnd_api.compatible_api_call (
707: l_api_version,
708: p_api_version,

Line 706: IF NOT fnd_api.compatible_api_call (

702: BEGIN
703: SAVEPOINT delete_task_phones_pub;
704: x_return_status := fnd_api.g_ret_sts_success;
705:
706: IF NOT fnd_api.compatible_api_call (
707: l_api_version,
708: p_api_version,
709: l_api_name,
710: g_pkg_name

Line 713: RAISE fnd_api.g_exc_unexpected_error;

709: l_api_name,
710: g_pkg_name
711: )
712: THEN
713: RAISE fnd_api.g_exc_unexpected_error;
714: END IF;
715:
716: IF fnd_api.to_boolean (p_init_msg_list)
717: THEN

Line 716: IF fnd_api.to_boolean (p_init_msg_list)

712: THEN
713: RAISE fnd_api.g_exc_unexpected_error;
714: END IF;
715:
716: IF fnd_api.to_boolean (p_init_msg_list)
717: THEN
718: fnd_msg_pub.initialize;
719: END IF;
720:

Line 723: p_init_msg_list => fnd_api.g_false,

719: END IF;
720:
721: jtf_task_phones_pub.lock_task_phones (
722: p_api_version => 1.0,
723: p_init_msg_list => fnd_api.g_false,
724: p_commit => fnd_api.g_false,
725: p_task_phone_id => p_task_phone_id,
726: p_object_version_number => p_object_version_number,
727: x_return_status => x_return_status,

Line 724: p_commit => fnd_api.g_false,

720:
721: jtf_task_phones_pub.lock_task_phones (
722: p_api_version => 1.0,
723: p_init_msg_list => fnd_api.g_false,
724: p_commit => fnd_api.g_false,
725: p_task_phone_id => p_task_phone_id,
726: p_object_version_number => p_object_version_number,
727: x_return_status => x_return_status,
728: x_msg_data => x_msg_data,

Line 732: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

728: x_msg_data => x_msg_data,
729: x_msg_count => x_msg_count
730: );
731:
732: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
733: THEN
734: x_return_status := fnd_api.g_ret_sts_unexp_error;
735: RAISE fnd_api.g_exc_unexpected_error;
736: END IF;

Line 734: x_return_status := fnd_api.g_ret_sts_unexp_error;

730: );
731:
732: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
733: THEN
734: x_return_status := fnd_api.g_ret_sts_unexp_error;
735: RAISE fnd_api.g_exc_unexpected_error;
736: END IF;
737:
738: jtf_task_phones_pkg.delete_row (x_task_phone_id => p_task_phone_id);

Line 735: RAISE fnd_api.g_exc_unexpected_error;

731:
732: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
733: THEN
734: x_return_status := fnd_api.g_ret_sts_unexp_error;
735: RAISE fnd_api.g_exc_unexpected_error;
736: END IF;
737:
738: jtf_task_phones_pkg.delete_row (x_task_phone_id => p_task_phone_id);
739: OPEN c_jtf_task_phones;

Line 744: x_return_status := fnd_api.g_ret_sts_unexp_error;

740: FETCH c_jtf_task_phones INTO x;
741:
742: IF c_jtf_task_phones%FOUND
743: THEN
744: x_return_status := fnd_api.g_ret_sts_unexp_error;
745: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_PHONES');
746: fnd_msg_pub.add;
747: RAISE fnd_api.g_exc_unexpected_error;
748: END IF;

Line 747: RAISE fnd_api.g_exc_unexpected_error;

743: THEN
744: x_return_status := fnd_api.g_ret_sts_unexp_error;
745: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_PHONES');
746: fnd_msg_pub.add;
747: RAISE fnd_api.g_exc_unexpected_error;
748: END IF;
749:
750: IF fnd_api.to_boolean (p_commit)
751: THEN

Line 750: IF fnd_api.to_boolean (p_commit)

746: fnd_msg_pub.add;
747: RAISE fnd_api.g_exc_unexpected_error;
748: END IF;
749:
750: IF fnd_api.to_boolean (p_commit)
751: THEN
752: COMMIT WORK;
753: END IF;
754:

Line 757: WHEN fnd_api.g_exc_unexpected_error

753: END IF;
754:
755: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
756: EXCEPTION
757: WHEN fnd_api.g_exc_unexpected_error
758: THEN
759: ROLLBACK TO delete_task_phones_pub;
760: x_return_status := fnd_api.g_ret_sts_unexp_error;
761: fnd_msg_pub.count_and_get (

Line 760: x_return_status := fnd_api.g_ret_sts_unexp_error;

756: EXCEPTION
757: WHEN fnd_api.g_exc_unexpected_error
758: THEN
759: ROLLBACK TO delete_task_phones_pub;
760: x_return_status := fnd_api.g_ret_sts_unexp_error;
761: fnd_msg_pub.count_and_get (
762: p_count => x_msg_count,
763: p_data => x_msg_data
764: );

Line 771: x_return_status := fnd_api.g_ret_sts_unexp_error;

767: ROLLBACK TO delete_task_phones_pub;
768: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
769: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
770: fnd_msg_pub.add;
771: x_return_status := fnd_api.g_ret_sts_unexp_error;
772: fnd_msg_pub.count_and_get (
773: p_count => x_msg_count,
774: p_data => x_msg_data
775: );