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_CONTACTS_PUB dependencies on FND_API

Line 96: x_return_status := fnd_api.g_ret_sts_success;

92: FROM jtf_task_contacts
93: WHERE ROWID = l_rowid;
94: BEGIN
95: SAVEPOINT create_task_contacts_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_contacts_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 120: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

116: p_task_number => p_task_number,
117: x_task_id => l_task_id
118: );
119:
120: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
121: THEN
122: x_return_status := fnd_api.g_ret_sts_unexp_error;
123: RAISE fnd_api.g_exc_unexpected_error;
124: END IF;

Line 122: x_return_status := fnd_api.g_ret_sts_unexp_error;

118: );
119:
120: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
121: THEN
122: x_return_status := fnd_api.g_ret_sts_unexp_error;
123: RAISE fnd_api.g_exc_unexpected_error;
124: END IF;
125:
126:

Line 123: RAISE fnd_api.g_exc_unexpected_error;

119:
120: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
121: THEN
122: x_return_status := fnd_api.g_ret_sts_unexp_error;
123: RAISE fnd_api.g_exc_unexpected_error;
124: END IF;
125:
126:
127:

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

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

Line 135: x_return_status := fnd_api.g_ret_sts_unexp_error;

131: );
132:
133: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
134: THEN
135: x_return_status := fnd_api.g_ret_sts_unexp_error;
136: RAISE fnd_api.g_exc_unexpected_error;
137: END IF;
138:
139:

Line 136: RAISE fnd_api.g_exc_unexpected_error;

132:
133: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
134: THEN
135: x_return_status := fnd_api.g_ret_sts_unexp_error;
136: RAISE fnd_api.g_exc_unexpected_error;
137: END IF;
138:
139:
140:

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

142: p_task_contact_id => p_contact_id,
143: x_return_status => x_return_status
144: );
145:
146: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
147: THEN
148: x_return_status := fnd_api.g_ret_sts_unexp_error;
149: RAISE fnd_api.g_exc_unexpected_error;
150: END IF;

Line 148: x_return_status := fnd_api.g_ret_sts_unexp_error;

144: );
145:
146: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
147: THEN
148: x_return_status := fnd_api.g_ret_sts_unexp_error;
149: RAISE fnd_api.g_exc_unexpected_error;
150: END IF;
151:
152:

Line 149: RAISE fnd_api.g_exc_unexpected_error;

145:
146: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
147: THEN
148: x_return_status := fnd_api.g_ret_sts_unexp_error;
149: RAISE fnd_api.g_exc_unexpected_error;
150: END IF;
151:
152:
153:

Line 160: x_return_status := fnd_api.g_ret_sts_unexp_error;

156: NVL (p_contact_type_code, 'CUST'),
157: 'Escalation Contact Point ( JTF_EC_CONTACT_TYPE)'
158: )
159: THEN
160: x_return_status := fnd_api.g_ret_sts_unexp_error;
161: RAISE fnd_api.g_exc_unexpected_error;
162: END IF;
163:
164: jtf_task_utl.validate_contact (

Line 161: RAISE fnd_api.g_exc_unexpected_error;

157: 'Escalation Contact Point ( JTF_EC_CONTACT_TYPE)'
158: )
159: THEN
160: x_return_status := fnd_api.g_ret_sts_unexp_error;
161: RAISE fnd_api.g_exc_unexpected_error;
162: END IF;
163:
164: jtf_task_utl.validate_contact (
165: p_contact_id => p_contact_id,

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

167: p_contact_type_code => NVL (p_contact_type_code, 'CUST'),
168: x_return_status => x_return_status
169: );
170:
171: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
172: THEN
173:
174: x_return_status := fnd_api.g_ret_sts_unexp_error;
175: RAISE fnd_api.g_exc_unexpected_error;

Line 174: x_return_status := fnd_api.g_ret_sts_unexp_error;

170:
171: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
172: THEN
173:
174: x_return_status := fnd_api.g_ret_sts_unexp_error;
175: RAISE fnd_api.g_exc_unexpected_error;
176: END IF;
177:
178: jtf_task_utl.validate_flag (

Line 175: RAISE fnd_api.g_exc_unexpected_error;

171: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
172: THEN
173:
174: x_return_status := fnd_api.g_ret_sts_unexp_error;
175: RAISE fnd_api.g_exc_unexpected_error;
176: END IF;
177:
178: jtf_task_utl.validate_flag (
179: p_flag_name => jtf_task_utl.get_translated_lookup (

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

183: p_flag_value => p_escalation_notify_flag,
184: x_return_status => x_return_status
185: );
186:
187: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
188: THEN
189: x_return_status := fnd_api.g_ret_sts_unexp_error;
190: RAISE fnd_api.g_exc_unexpected_error;
191: END IF;

Line 189: x_return_status := fnd_api.g_ret_sts_unexp_error;

185: );
186:
187: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
188: THEN
189: x_return_status := fnd_api.g_ret_sts_unexp_error;
190: RAISE fnd_api.g_exc_unexpected_error;
191: END IF;
192:
193: jtf_task_utl.validate_flag (

Line 190: RAISE fnd_api.g_exc_unexpected_error;

186:
187: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
188: THEN
189: x_return_status := fnd_api.g_ret_sts_unexp_error;
190: RAISE fnd_api.g_exc_unexpected_error;
191: END IF;
192:
193: jtf_task_utl.validate_flag (
194: p_flag_name => jtf_task_utl.get_translated_lookup (

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

198: p_flag_value => p_escalation_requester_flag,
199: x_return_status => x_return_status
200: );
201:
202: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
203: THEN
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205: RAISE fnd_api.g_exc_unexpected_error;
206: END IF;

Line 204: x_return_status := fnd_api.g_ret_sts_unexp_error;

200: );
201:
202: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
203: THEN
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205: RAISE fnd_api.g_exc_unexpected_error;
206: END IF;
207:
208: -- Added this call for bug# 5140139

Line 205: RAISE fnd_api.g_exc_unexpected_error;

201:
202: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
203: THEN
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205: RAISE fnd_api.g_exc_unexpected_error;
206: END IF;
207:
208: -- Added this call for bug# 5140139
209: jtf_task_utl.check_duplicate_contact (

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

213: p_task_contact_id => NULL,
214: x_return_status => x_return_status
215: );
216:
217: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
218: THEN
219: x_return_status := fnd_api.g_ret_sts_unexp_error;
220: RAISE fnd_api.g_exc_unexpected_error;
221: END IF;

Line 219: x_return_status := fnd_api.g_ret_sts_unexp_error;

215: );
216:
217: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
218: THEN
219: x_return_status := fnd_api.g_ret_sts_unexp_error;
220: RAISE fnd_api.g_exc_unexpected_error;
221: END IF;
222:
223: SELECT jtf_task_contacts_s.nextval

Line 220: RAISE fnd_api.g_exc_unexpected_error;

216:
217: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
218: THEN
219: x_return_status := fnd_api.g_ret_sts_unexp_error;
220: RAISE fnd_api.g_exc_unexpected_error;
221: END IF;
222:
223: SELECT jtf_task_contacts_s.nextval
224: INTO l_task_contact_id

Line 276: x_return_status := fnd_api.g_ret_sts_unexp_error;

272: FETCH c_jtf_task_contacts INTO x;
273:
274: IF c_jtf_task_contacts%NOTFOUND
275: THEN
276: x_return_status := fnd_api.g_ret_sts_unexp_error;
277: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_CONTACTS');
278: fnd_msg_pub.add;
279: RAISE fnd_api.g_exc_unexpected_error;
280: ELSE

Line 279: RAISE fnd_api.g_exc_unexpected_error;

275: THEN
276: x_return_status := fnd_api.g_ret_sts_unexp_error;
277: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_CONTACTS');
278: fnd_msg_pub.add;
279: RAISE fnd_api.g_exc_unexpected_error;
280: ELSE
281: x_task_contact_id := l_task_contact_id;
282: END IF;
283:

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

293: x_msg_count => x_msg_count,
294: x_msg_data => x_msg_data,
295: x_return_status => x_return_status);
296:
297: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
298: THEN
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300: RAISE fnd_api.g_exc_unexpected_error;
301: END IF;

Line 299: x_return_status := fnd_api.g_ret_sts_unexp_error;

295: x_return_status => x_return_status);
296:
297: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
298: THEN
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300: RAISE fnd_api.g_exc_unexpected_error;
301: END IF;
302:
303: IF fnd_api.to_boolean (p_commit)

Line 300: RAISE fnd_api.g_exc_unexpected_error;

296:
297: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
298: THEN
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300: RAISE fnd_api.g_exc_unexpected_error;
301: END IF;
302:
303: IF fnd_api.to_boolean (p_commit)
304: THEN

Line 303: IF fnd_api.to_boolean (p_commit)

299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300: RAISE fnd_api.g_exc_unexpected_error;
301: END IF;
302:
303: IF fnd_api.to_boolean (p_commit)
304: THEN
305: COMMIT WORK;
306: END IF;
307:

Line 310: WHEN fnd_api.g_exc_unexpected_error

306: END IF;
307:
308: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
309: EXCEPTION
310: WHEN fnd_api.g_exc_unexpected_error
311: THEN
312: ROLLBACK TO create_task_contacts_pub;
313: x_return_status := fnd_api.g_ret_sts_unexp_error;
314: fnd_msg_pub.count_and_get (

Line 313: x_return_status := fnd_api.g_ret_sts_unexp_error;

309: EXCEPTION
310: WHEN fnd_api.g_exc_unexpected_error
311: THEN
312: ROLLBACK TO create_task_contacts_pub;
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 323: x_return_status := fnd_api.g_ret_sts_unexp_error;

319: THEN
320: ROLLBACK TO create_task_contacts_pub;
321: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
322: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
323: x_return_status := fnd_api.g_ret_sts_unexp_error;
324: fnd_msg_pub.count_and_get (
325: p_count => x_msg_count,
326: p_data => x_msg_data
327: );

Line 347: x_return_status := fnd_api.g_ret_sts_success;

343: resource_locked EXCEPTION;
344: PRAGMA EXCEPTION_INIT (resource_locked, -54);
345: BEGIN
346: SAVEPOINT lock_task_contacts_pub;
347: x_return_status := fnd_api.g_ret_sts_success;
348:
349:
350:
351: IF NOT fnd_api.compatible_api_call (

Line 351: IF NOT fnd_api.compatible_api_call (

347: x_return_status := fnd_api.g_ret_sts_success;
348:
349:
350:
351: IF NOT fnd_api.compatible_api_call (
352: l_api_version,
353: p_api_version,
354: l_api_name,
355: g_pkg_name

Line 358: RAISE fnd_api.g_exc_unexpected_error;

354: l_api_name,
355: g_pkg_name
356: )
357: THEN
358: RAISE fnd_api.g_exc_unexpected_error;
359: END IF;
360:
361: IF fnd_api.to_boolean (p_init_msg_list)
362: THEN

Line 361: IF fnd_api.to_boolean (p_init_msg_list)

357: THEN
358: RAISE fnd_api.g_exc_unexpected_error;
359: END IF;
360:
361: IF fnd_api.to_boolean (p_init_msg_list)
362: THEN
363: fnd_msg_pub.initialize;
364: END IF;
365:

Line 366: x_return_status := fnd_api.g_ret_sts_success;

362: THEN
363: fnd_msg_pub.initialize;
364: END IF;
365:
366: x_return_status := fnd_api.g_ret_sts_success;
367: jtf_task_contacts_pkg.lock_row (
368: x_task_contact_id => p_task_contact_id,
369: x_object_version_number => p_object_version_number);
370: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 380: x_return_status := fnd_api.g_ret_sts_unexp_error;

376: ROLLBACK TO lock_task_contacts_pub;
377: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
378: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
379: fnd_msg_pub.add;
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: fnd_msg_pub.count_and_get (
382: p_count => x_msg_count,
383: p_data => x_msg_data
384: );

Line 385: WHEN fnd_api.g_exc_unexpected_error

381: fnd_msg_pub.count_and_get (
382: p_count => x_msg_count,
383: p_data => x_msg_data
384: );
385: WHEN fnd_api.g_exc_unexpected_error
386: THEN
387:
388: ROLLBACK TO lock_task_contacts_pub;
389: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 389: x_return_status := fnd_api.g_ret_sts_unexp_error;

385: WHEN fnd_api.g_exc_unexpected_error
386: THEN
387:
388: ROLLBACK TO lock_task_contacts_pub;
389: x_return_status := fnd_api.g_ret_sts_unexp_error;
390: fnd_msg_pub.count_and_get (
391: p_count => x_msg_count,
392: p_data => x_msg_data
393: );

Line 400: x_return_status := fnd_api.g_ret_sts_unexp_error;

396: ROLLBACK TO lock_task_contacts_pub;
397: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
398: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
399: fnd_msg_pub.add;
400: x_return_status := fnd_api.g_ret_sts_unexp_error;
401: fnd_msg_pub.count_and_get (
402: p_count => x_msg_count,
403: p_data => x_msg_data
404: );

Line 451: fnd_api.g_miss_num, contact_id,

447: SELECT task_contact_id,
448: task_id,
449: DECODE (
450: p_contact_id,
451: fnd_api.g_miss_num, contact_id,
452: p_contact_id
453: ) contact_id,
454: DECODE (
455: p_contact_type_code,

Line 456: fnd_api.g_miss_char, contact_type_code,

452: p_contact_id
453: ) contact_id,
454: DECODE (
455: p_contact_type_code,
456: fnd_api.g_miss_char, contact_type_code,
457: p_contact_type_code
458: ) contact_type_code,
459: DECODE (
460: p_escalation_notify_flag,

Line 461: fnd_api.g_miss_char, escalation_notify_flag,

457: p_contact_type_code
458: ) contact_type_code,
459: DECODE (
460: p_escalation_notify_flag,
461: fnd_api.g_miss_char, escalation_notify_flag,
462: p_escalation_notify_flag
463: ) escalation_notify_flag,
464: DECODE (
465: p_escalation_requester_flag,

Line 466: fnd_api.g_miss_char, escalation_requester_flag,

462: p_escalation_notify_flag
463: ) escalation_notify_flag,
464: DECODE (
465: p_escalation_requester_flag,
466: fnd_api.g_miss_char, escalation_requester_flag,
467: p_escalation_requester_flag
468: ) escalation_requester_flag,
469: DECODE (
470: p_attribute1,

Line 471: fnd_api.g_miss_char, attribute1,

467: p_escalation_requester_flag
468: ) escalation_requester_flag,
469: DECODE (
470: p_attribute1,
471: fnd_api.g_miss_char, attribute1,
472: p_attribute1
473: ) attribute1,
474: DECODE (
475: p_attribute2,

Line 476: fnd_api.g_miss_char, attribute2,

472: p_attribute1
473: ) attribute1,
474: DECODE (
475: p_attribute2,
476: fnd_api.g_miss_char, attribute2,
477: p_attribute2
478: ) attribute2,
479: DECODE (
480: p_attribute3,

Line 481: fnd_api.g_miss_char, attribute3,

477: p_attribute2
478: ) attribute2,
479: DECODE (
480: p_attribute3,
481: fnd_api.g_miss_char, attribute3,
482: p_attribute3
483: ) attribute3,
484: DECODE (
485: p_attribute4,

Line 486: fnd_api.g_miss_char, attribute4,

482: p_attribute3
483: ) attribute3,
484: DECODE (
485: p_attribute4,
486: fnd_api.g_miss_char, attribute4,
487: p_attribute4
488: ) attribute4,
489: DECODE (
490: p_attribute5,

Line 491: fnd_api.g_miss_char, attribute5,

487: p_attribute4
488: ) attribute4,
489: DECODE (
490: p_attribute5,
491: fnd_api.g_miss_char, attribute5,
492: p_attribute5
493: ) attribute5,
494: DECODE (
495: p_attribute6,

Line 496: fnd_api.g_miss_char, attribute6,

492: p_attribute5
493: ) attribute5,
494: DECODE (
495: p_attribute6,
496: fnd_api.g_miss_char, attribute6,
497: p_attribute6
498: ) attribute6,
499: DECODE (
500: p_attribute7,

Line 501: fnd_api.g_miss_char, attribute7,

497: p_attribute6
498: ) attribute6,
499: DECODE (
500: p_attribute7,
501: fnd_api.g_miss_char, attribute7,
502: p_attribute7
503: ) attribute7,
504: DECODE (
505: p_attribute8,

Line 506: fnd_api.g_miss_char, attribute8,

502: p_attribute7
503: ) attribute7,
504: DECODE (
505: p_attribute8,
506: fnd_api.g_miss_char, attribute8,
507: p_attribute8
508: ) attribute8,
509: DECODE (
510: p_attribute9,

Line 511: fnd_api.g_miss_char, attribute9,

507: p_attribute8
508: ) attribute8,
509: DECODE (
510: p_attribute9,
511: fnd_api.g_miss_char, attribute9,
512: p_attribute9
513: ) attribute9,
514: DECODE (
515: p_attribute10,

Line 516: fnd_api.g_miss_char, attribute10,

512: p_attribute9
513: ) attribute9,
514: DECODE (
515: p_attribute10,
516: fnd_api.g_miss_char, attribute10,
517: p_attribute10
518: ) attribute10,
519: DECODE (
520: p_attribute11,

Line 521: fnd_api.g_miss_char, attribute11,

517: p_attribute10
518: ) attribute10,
519: DECODE (
520: p_attribute11,
521: fnd_api.g_miss_char, attribute11,
522: p_attribute11
523: ) attribute11,
524: DECODE (
525: p_attribute12,

Line 526: fnd_api.g_miss_char, attribute12,

522: p_attribute11
523: ) attribute11,
524: DECODE (
525: p_attribute12,
526: fnd_api.g_miss_char, attribute12,
527: p_attribute12
528: ) attribute12,
529: DECODE (
530: p_attribute13,

Line 531: fnd_api.g_miss_char, attribute13,

527: p_attribute12
528: ) attribute12,
529: DECODE (
530: p_attribute13,
531: fnd_api.g_miss_char, attribute13,
532: p_attribute13
533: ) attribute13,
534: DECODE (
535: p_attribute14,

Line 536: fnd_api.g_miss_char, attribute14,

532: p_attribute13
533: ) attribute13,
534: DECODE (
535: p_attribute14,
536: fnd_api.g_miss_char, attribute14,
537: p_attribute14
538: ) attribute14,
539: DECODE (
540: p_attribute15,

Line 541: fnd_api.g_miss_char, attribute15,

537: p_attribute14
538: ) attribute14,
539: DECODE (
540: p_attribute15,
541: fnd_api.g_miss_char, attribute15,
542: p_attribute15
543: ) attribute15,
544: DECODE (
545: p_attribute_category,

Line 546: fnd_api.g_miss_char, attribute_category,

542: p_attribute15
543: ) attribute15,
544: DECODE (
545: p_attribute_category,
546: fnd_api.g_miss_char, attribute_category,
547: p_attribute_category
548: ) attribute_category,
549: DECODE (
550: p_primary_flag,

Line 551: fnd_api.g_miss_char, primary_flag,

547: p_attribute_category
548: ) attribute_category,
549: DECODE (
550: p_primary_flag,
551: fnd_api.g_miss_char, primary_flag,
552: p_primary_flag
553: ) primary_flag
554: FROM jtf_task_contacts
555: WHERE task_contact_id = p_task_contact_id;

Line 571: x_return_status := fnd_api.g_ret_sts_success;

567: l_orig_con_id jtf_task_contacts.contact_id%type;
568: l_orig_type_code jtf_task_contacts.contact_type_code%type;
569: BEGIN
570: SAVEPOINT update_task_contacts_pub;
571: x_return_status := fnd_api.g_ret_sts_success;
572:
573: IF NOT fnd_api.compatible_api_call (
574: l_api_version,
575: p_api_version,

Line 573: IF NOT fnd_api.compatible_api_call (

569: BEGIN
570: SAVEPOINT update_task_contacts_pub;
571: x_return_status := fnd_api.g_ret_sts_success;
572:
573: IF NOT fnd_api.compatible_api_call (
574: l_api_version,
575: p_api_version,
576: l_api_name,
577: g_pkg_name

Line 580: RAISE fnd_api.g_exc_unexpected_error;

576: l_api_name,
577: g_pkg_name
578: )
579: THEN
580: RAISE fnd_api.g_exc_unexpected_error;
581: END IF;
582:
583:
584: IF fnd_api.to_boolean (p_init_msg_list)

Line 584: IF fnd_api.to_boolean (p_init_msg_list)

580: RAISE fnd_api.g_exc_unexpected_error;
581: END IF;
582:
583:
584: IF fnd_api.to_boolean (p_init_msg_list)
585: THEN
586: fnd_msg_pub.initialize;
587: END IF;
588:

Line 589: x_return_status := fnd_api.g_ret_sts_success;

585: THEN
586: fnd_msg_pub.initialize;
587: END IF;
588:
589: x_return_status := fnd_api.g_ret_sts_success;
590:
591:
592:
593:

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

596: p_task_contact_id => p_contact_id,
597: x_return_status => x_return_status
598: );
599:
600: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
601: THEN
602:
603: x_return_status := fnd_api.g_ret_sts_unexp_error;
604: RAISE fnd_api.g_exc_unexpected_error;

Line 603: x_return_status := fnd_api.g_ret_sts_unexp_error;

599:
600: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
601: THEN
602:
603: x_return_status := fnd_api.g_ret_sts_unexp_error;
604: RAISE fnd_api.g_exc_unexpected_error;
605: END IF;
606:
607:

Line 604: RAISE fnd_api.g_exc_unexpected_error;

600: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
601: THEN
602:
603: x_return_status := fnd_api.g_ret_sts_unexp_error;
604: RAISE fnd_api.g_exc_unexpected_error;
605: END IF;
606:
607:
608:

Line 617: x_return_status := fnd_api.g_ret_sts_unexp_error;

613: IF c_task_contacts%NOTFOUND
614: THEN
615: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACTS');
616: fnd_msg_pub.add;
617: x_return_status := fnd_api.g_ret_sts_unexp_error;
618: RAISE fnd_api.g_exc_unexpected_error;
619: END IF;
620:
621:

Line 618: RAISE fnd_api.g_exc_unexpected_error;

614: THEN
615: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACTS');
616: fnd_msg_pub.add;
617: x_return_status := fnd_api.g_ret_sts_unexp_error;
618: RAISE fnd_api.g_exc_unexpected_error;
619: END IF;
620:
621:
622:

Line 629: x_return_status := fnd_api.g_ret_sts_unexp_error;

625: NVL (task_contacts.contact_type_code, 'CUST'),
626: 'Escalation Contact Point( JTF_EC_CONTACT_TYPE)'
627: )
628: THEN
629: x_return_status := fnd_api.g_ret_sts_unexp_error;
630: RAISE fnd_api.g_exc_unexpected_error;
631: END IF;
632:
633:

Line 630: RAISE fnd_api.g_exc_unexpected_error;

626: 'Escalation Contact Point( JTF_EC_CONTACT_TYPE)'
627: )
628: THEN
629: x_return_status := fnd_api.g_ret_sts_unexp_error;
630: RAISE fnd_api.g_exc_unexpected_error;
631: END IF;
632:
633:
634:

Line 645: x_return_status := fnd_api.g_ret_sts_unexp_error;

641: WHEN NO_DATA_FOUND
642: THEN
643: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACTS');
644: fnd_msg_pub.add;
645: x_return_status := fnd_api.g_ret_sts_unexp_error;
646: RAISE fnd_api.g_exc_unexpected_error;
647: END;
648:
649:

Line 646: RAISE fnd_api.g_exc_unexpected_error;

642: THEN
643: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACTS');
644: fnd_msg_pub.add;
645: x_return_status := fnd_api.g_ret_sts_unexp_error;
646: RAISE fnd_api.g_exc_unexpected_error;
647: END;
648:
649:
650: jtf_task_utl.validate_contact (

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

653: p_contact_type_code => task_contacts.contact_type_code,
654: x_return_status => x_return_status
655: );
656:
657: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
658: THEN
659: x_return_status := fnd_api.g_ret_sts_unexp_error;
660: RAISE fnd_api.g_exc_unexpected_error;
661: END IF;

Line 659: x_return_status := fnd_api.g_ret_sts_unexp_error;

655: );
656:
657: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
658: THEN
659: x_return_status := fnd_api.g_ret_sts_unexp_error;
660: RAISE fnd_api.g_exc_unexpected_error;
661: END IF;
662:
663:

Line 660: RAISE fnd_api.g_exc_unexpected_error;

656:
657: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
658: THEN
659: x_return_status := fnd_api.g_ret_sts_unexp_error;
660: RAISE fnd_api.g_exc_unexpected_error;
661: END IF;
662:
663:
664:

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

670: p_flag_value => task_contacts.escalation_notify_flag,
671: x_return_status => x_return_status
672: );
673:
674: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
675: THEN
676: x_return_status := fnd_api.g_ret_sts_unexp_error;
677: RAISE fnd_api.g_exc_unexpected_error;
678: END IF;

Line 676: x_return_status := fnd_api.g_ret_sts_unexp_error;

672: );
673:
674: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
675: THEN
676: x_return_status := fnd_api.g_ret_sts_unexp_error;
677: RAISE fnd_api.g_exc_unexpected_error;
678: END IF;
679:
680:

Line 677: RAISE fnd_api.g_exc_unexpected_error;

673:
674: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
675: THEN
676: x_return_status := fnd_api.g_ret_sts_unexp_error;
677: RAISE fnd_api.g_exc_unexpected_error;
678: END IF;
679:
680:
681:

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

687: p_flag_value => task_contacts.escalation_requester_flag,
688: x_return_status => x_return_status
689: );
690:
691: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
692: THEN
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: RAISE fnd_api.g_exc_unexpected_error;
695: END IF;

Line 693: x_return_status := fnd_api.g_ret_sts_unexp_error;

689: );
690:
691: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
692: THEN
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: RAISE fnd_api.g_exc_unexpected_error;
695: END IF;
696:
697: -- Added this call for bug# 5140139

Line 694: RAISE fnd_api.g_exc_unexpected_error;

690:
691: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
692: THEN
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: RAISE fnd_api.g_exc_unexpected_error;
695: END IF;
696:
697: -- Added this call for bug# 5140139
698: jtf_task_utl.check_duplicate_contact(

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

702: p_task_contact_id => p_task_contact_id,
703: x_return_status => x_return_status
704: );
705:
706: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
707: THEN
708: x_return_status := fnd_api.g_ret_sts_unexp_error;
709: RAISE fnd_api.g_exc_unexpected_error;
710: END IF;

Line 708: x_return_status := fnd_api.g_ret_sts_unexp_error;

704: );
705:
706: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
707: THEN
708: x_return_status := fnd_api.g_ret_sts_unexp_error;
709: RAISE fnd_api.g_exc_unexpected_error;
710: END IF;
711:
712: jtf_task_contacts_pub.lock_task_contacts (

Line 709: RAISE fnd_api.g_exc_unexpected_error;

705:
706: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
707: THEN
708: x_return_status := fnd_api.g_ret_sts_unexp_error;
709: RAISE fnd_api.g_exc_unexpected_error;
710: END IF;
711:
712: jtf_task_contacts_pub.lock_task_contacts (
713: p_api_version => 1.0,

Line 714: p_init_msg_list => fnd_api.g_false,

710: END IF;
711:
712: jtf_task_contacts_pub.lock_task_contacts (
713: p_api_version => 1.0,
714: p_init_msg_list => fnd_api.g_false,
715: p_commit => fnd_api.g_false,
716: p_task_contact_id => p_task_contact_id,
717: p_object_version_number => p_object_version_number,
718: x_return_status => x_return_status,

Line 715: p_commit => fnd_api.g_false,

711:
712: jtf_task_contacts_pub.lock_task_contacts (
713: p_api_version => 1.0,
714: p_init_msg_list => fnd_api.g_false,
715: p_commit => fnd_api.g_false,
716: p_task_contact_id => p_task_contact_id,
717: p_object_version_number => p_object_version_number,
718: x_return_status => x_return_status,
719: x_msg_data => x_msg_data,

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

719: x_msg_data => x_msg_data,
720: x_msg_count => x_msg_count
721: );
722:
723: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
724: THEN
725: x_return_status := fnd_api.g_ret_sts_unexp_error;
726: RAISE fnd_api.g_exc_unexpected_error;
727: END IF;

Line 725: x_return_status := fnd_api.g_ret_sts_unexp_error;

721: );
722:
723: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
724: THEN
725: x_return_status := fnd_api.g_ret_sts_unexp_error;
726: RAISE fnd_api.g_exc_unexpected_error;
727: END IF;
728:
729:

Line 726: RAISE fnd_api.g_exc_unexpected_error;

722:
723: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
724: THEN
725: x_return_status := fnd_api.g_ret_sts_unexp_error;
726: RAISE fnd_api.g_exc_unexpected_error;
727: END IF;
728:
729:
730: --unmark the previous task id with primary flag = 'Y'.

Line 747: RAISE fnd_api.g_exc_unexpected_error;

743: l_orig_type_code;
744:
745: IF con_con_orig%NOTFOUND
746: THEN
747: RAISE fnd_api.g_exc_unexpected_error;
748: END IF;
749:
750:
751: jtf_task_contacts_pkg.update_row (

Line 785: if (nvl(l_contact_id, 0) <> fnd_api.g_miss_num and

781: l_contact_id := task_contacts.contact_id;
782: -- ------------------------------------------------------------------------
783: -- Update reference to contact if changed, fix enh #1845501
784: -- ------------------------------------------------------------------------
785: if (nvl(l_contact_id, 0) <> fnd_api.g_miss_num and
786: nvl(l_contact_id, 0) <> nvl(l_orig_con_id, 0)) then
787: -- delete the old one
788: jtf_task_utl.delete_party_reference(
789: p_reference_from => 'CONTACT',

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

793: x_msg_count => x_msg_count,
794: x_msg_data => x_msg_data,
795: x_return_status => x_return_status);
796:
797: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
798: THEN
799: x_return_status := fnd_api.g_ret_sts_unexp_error;
800: RAISE fnd_api.g_exc_unexpected_error;
801: END IF;

Line 799: x_return_status := fnd_api.g_ret_sts_unexp_error;

795: x_return_status => x_return_status);
796:
797: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
798: THEN
799: x_return_status := fnd_api.g_ret_sts_unexp_error;
800: RAISE fnd_api.g_exc_unexpected_error;
801: END IF;
802: -- create a new one
803: jtf_task_utl.create_party_reference(

Line 800: RAISE fnd_api.g_exc_unexpected_error;

796:
797: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
798: THEN
799: x_return_status := fnd_api.g_ret_sts_unexp_error;
800: RAISE fnd_api.g_exc_unexpected_error;
801: END IF;
802: -- create a new one
803: jtf_task_utl.create_party_reference(
804: p_reference_from => 'CONTACT',

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

808: x_msg_count => x_msg_count,
809: x_msg_data => x_msg_data,
810: x_return_status => x_return_status);
811:
812: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
813: THEN
814: x_return_status := fnd_api.g_ret_sts_unexp_error;
815: RAISE fnd_api.g_exc_unexpected_error;
816: END IF;

Line 814: x_return_status := fnd_api.g_ret_sts_unexp_error;

810: x_return_status => x_return_status);
811:
812: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
813: THEN
814: x_return_status := fnd_api.g_ret_sts_unexp_error;
815: RAISE fnd_api.g_exc_unexpected_error;
816: END IF;
817: end if;
818:

Line 815: RAISE fnd_api.g_exc_unexpected_error;

811:
812: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
813: THEN
814: x_return_status := fnd_api.g_ret_sts_unexp_error;
815: RAISE fnd_api.g_exc_unexpected_error;
816: END IF;
817: end if;
818:
819: IF con_con_orig%ISOPEN

Line 824: IF fnd_api.to_boolean (p_commit)

820: THEN
821: CLOSE con_con_orig;
822: END IF;
823:
824: IF fnd_api.to_boolean (p_commit)
825: THEN
826: COMMIT WORK;
827: END IF;
828:

Line 832: WHEN fnd_api.g_exc_unexpected_error

828:
829: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
830: p_object_version_number := p_object_version_number + 1;
831: EXCEPTION
832: WHEN fnd_api.g_exc_unexpected_error
833: THEN
834: ROLLBACK TO update_task_contacts_pub;
835: x_return_status := fnd_api.g_ret_sts_unexp_error;
836: fnd_msg_pub.count_and_get (

Line 835: x_return_status := fnd_api.g_ret_sts_unexp_error;

831: EXCEPTION
832: WHEN fnd_api.g_exc_unexpected_error
833: THEN
834: ROLLBACK TO update_task_contacts_pub;
835: x_return_status := fnd_api.g_ret_sts_unexp_error;
836: fnd_msg_pub.count_and_get (
837: p_count => x_msg_count,
838: p_data => x_msg_data
839: );

Line 845: x_return_status := fnd_api.g_ret_sts_unexp_error;

841: THEN
842: ROLLBACK TO update_task_contacts_pub;
843: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
844: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
845: x_return_status := fnd_api.g_ret_sts_unexp_error;
846: fnd_msg_pub.count_and_get (
847: p_count => x_msg_count,
848: p_data => x_msg_data
849: );

Line 877: x_return_status := fnd_api.g_ret_sts_success;

873: contact_type_code
874: FROM jtf_task_contacts
875: WHERE task_contact_id = b_task_contact_id;
876: BEGIN
877: x_return_status := fnd_api.g_ret_sts_success;
878: SAVEPOINT delete_task_contacts_pvt;
879: x_return_status := fnd_api.g_ret_sts_success;
880:
881: IF NOT fnd_api.compatible_api_call (

Line 879: x_return_status := fnd_api.g_ret_sts_success;

875: WHERE task_contact_id = b_task_contact_id;
876: BEGIN
877: x_return_status := fnd_api.g_ret_sts_success;
878: SAVEPOINT delete_task_contacts_pvt;
879: x_return_status := fnd_api.g_ret_sts_success;
880:
881: IF NOT fnd_api.compatible_api_call (
882: l_api_version,
883: p_api_version,

Line 881: IF NOT fnd_api.compatible_api_call (

877: x_return_status := fnd_api.g_ret_sts_success;
878: SAVEPOINT delete_task_contacts_pvt;
879: x_return_status := fnd_api.g_ret_sts_success;
880:
881: IF NOT fnd_api.compatible_api_call (
882: l_api_version,
883: p_api_version,
884: l_api_name,
885: g_pkg_name

Line 888: RAISE fnd_api.g_exc_unexpected_error;

884: l_api_name,
885: g_pkg_name
886: )
887: THEN
888: RAISE fnd_api.g_exc_unexpected_error;
889: END IF;
890:
891: IF fnd_api.to_boolean (p_init_msg_list)
892: THEN

Line 891: IF fnd_api.to_boolean (p_init_msg_list)

887: THEN
888: RAISE fnd_api.g_exc_unexpected_error;
889: END IF;
890:
891: IF fnd_api.to_boolean (p_init_msg_list)
892: THEN
893: fnd_msg_pub.initialize;
894: END IF;
895:

Line 896: x_return_status := fnd_api.g_ret_sts_success;

892: THEN
893: fnd_msg_pub.initialize;
894: END IF;
895:
896: x_return_status := fnd_api.g_ret_sts_success;
897:
898: jtf_task_utl.validate_missing_contact_id (
899: p_task_contact_id => p_task_contact_id,
900: x_return_status => x_return_status

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

899: p_task_contact_id => p_task_contact_id,
900: x_return_status => x_return_status
901: );
902:
903: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
904: THEN
905: x_return_status := fnd_api.g_ret_sts_unexp_error;
906: RAISE fnd_api.g_exc_unexpected_error;
907: END IF;

Line 905: x_return_status := fnd_api.g_ret_sts_unexp_error;

901: );
902:
903: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
904: THEN
905: x_return_status := fnd_api.g_ret_sts_unexp_error;
906: RAISE fnd_api.g_exc_unexpected_error;
907: END IF;
908:
909: BEGIN

Line 906: RAISE fnd_api.g_exc_unexpected_error;

902:
903: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
904: THEN
905: x_return_status := fnd_api.g_ret_sts_unexp_error;
906: RAISE fnd_api.g_exc_unexpected_error;
907: END IF;
908:
909: BEGIN
910: SELECT task_id

Line 919: x_return_status := fnd_api.g_ret_sts_unexp_error;

915: WHEN NO_DATA_FOUND
916: THEN
917: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACTS');
918: fnd_msg_pub.add;
919: x_return_status := fnd_api.g_ret_sts_unexp_error;
920: RAISE fnd_api.g_exc_unexpected_error;
921: END;
922:
923:

Line 920: RAISE fnd_api.g_exc_unexpected_error;

916: THEN
917: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACTS');
918: fnd_msg_pub.add;
919: x_return_status := fnd_api.g_ret_sts_unexp_error;
920: RAISE fnd_api.g_exc_unexpected_error;
921: END;
922:
923:
924: jtf_task_contacts_pub.lock_task_contacts (

Line 926: p_init_msg_list => fnd_api.g_false,

922:
923:
924: jtf_task_contacts_pub.lock_task_contacts (
925: p_api_version => 1.0,
926: p_init_msg_list => fnd_api.g_false,
927: p_commit => fnd_api.g_false,
928: p_task_contact_id => p_task_contact_id,
929: p_object_version_number => p_object_version_number,
930: x_return_status => x_return_status,

Line 927: p_commit => fnd_api.g_false,

923:
924: jtf_task_contacts_pub.lock_task_contacts (
925: p_api_version => 1.0,
926: p_init_msg_list => fnd_api.g_false,
927: p_commit => fnd_api.g_false,
928: p_task_contact_id => p_task_contact_id,
929: p_object_version_number => p_object_version_number,
930: x_return_status => x_return_status,
931: x_msg_data => x_msg_data,

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

931: x_msg_data => x_msg_data,
932: x_msg_count => x_msg_count
933: );
934:
935: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
936: THEN
937: x_return_status := fnd_api.g_ret_sts_unexp_error;
938: RAISE fnd_api.g_exc_unexpected_error;
939: END IF;

Line 937: x_return_status := fnd_api.g_ret_sts_unexp_error;

933: );
934:
935: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
936: THEN
937: x_return_status := fnd_api.g_ret_sts_unexp_error;
938: RAISE fnd_api.g_exc_unexpected_error;
939: END IF;
940:
941: --Delete the associated contact points in JTF_TASK_PHONES

Line 938: RAISE fnd_api.g_exc_unexpected_error;

934:
935: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
936: THEN
937: x_return_status := fnd_api.g_ret_sts_unexp_error;
938: RAISE fnd_api.g_exc_unexpected_error;
939: END IF;
940:
941: --Delete the associated contact points in JTF_TASK_PHONES
942: IF p_delete_cascade = jtf_task_utl.g_yes THEN

Line 958: RAISE fnd_api.g_exc_unexpected_error;

954: l_contact_type_code;
955:
956: IF con_con_orig%NOTFOUND
957: THEN
958: RAISE fnd_api.g_exc_unexpected_error;
959: END IF;
960:
961: jtf_task_contacts_pkg.delete_row (
962: x_task_contact_id => p_task_contact_id

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

973: x_msg_count => x_msg_count,
974: x_msg_data => x_msg_data,
975: x_return_status => x_return_status);
976:
977: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
978: THEN
979: x_return_status := fnd_api.g_ret_sts_unexp_error;
980: RAISE fnd_api.g_exc_unexpected_error;
981: END IF;

Line 979: x_return_status := fnd_api.g_ret_sts_unexp_error;

975: x_return_status => x_return_status);
976:
977: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
978: THEN
979: x_return_status := fnd_api.g_ret_sts_unexp_error;
980: RAISE fnd_api.g_exc_unexpected_error;
981: END IF;
982:
983: IF con_con_orig%ISOPEN

Line 980: RAISE fnd_api.g_exc_unexpected_error;

976:
977: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
978: THEN
979: x_return_status := fnd_api.g_ret_sts_unexp_error;
980: RAISE fnd_api.g_exc_unexpected_error;
981: END IF;
982:
983: IF con_con_orig%ISOPEN
984: THEN

Line 988: IF fnd_api.to_boolean (p_commit)

984: THEN
985: CLOSE con_con_orig;
986: END IF;
987:
988: IF fnd_api.to_boolean (p_commit)
989: THEN
990: COMMIT WORK;
991: END IF;
992:

Line 995: WHEN fnd_api.g_exc_unexpected_error

991: END IF;
992:
993: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
994: EXCEPTION
995: WHEN fnd_api.g_exc_unexpected_error
996: THEN
997: ROLLBACK TO delete_task_contacts_pvt;
998: x_return_status := fnd_api.g_ret_sts_unexp_error;
999: fnd_msg_pub.count_and_get (

Line 998: x_return_status := fnd_api.g_ret_sts_unexp_error;

994: EXCEPTION
995: WHEN fnd_api.g_exc_unexpected_error
996: THEN
997: ROLLBACK TO delete_task_contacts_pvt;
998: x_return_status := fnd_api.g_ret_sts_unexp_error;
999: fnd_msg_pub.count_and_get (
1000: p_count => x_msg_count,
1001: p_data => x_msg_data
1002: );

Line 1008: x_return_status := fnd_api.g_ret_sts_unexp_error;

1004: THEN
1005: ROLLBACK TO delete_task_contacts_pvt;
1006: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1007: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1008: x_return_status := fnd_api.g_ret_sts_unexp_error;
1009: fnd_msg_pub.count_and_get (
1010: p_count => x_msg_count,
1011: p_data => x_msg_data
1012: );