DBA Data[Home] [Help]

APPS.JTF_TASK_REFERENCES_PUB dependencies on FND_MSG_PUB

Line 85: fnd_msg_pub.initialize;

81: END IF;
82:
83: IF fnd_api.to_boolean (p_init_msg_list)
84: THEN
85: fnd_msg_pub.initialize;
86: END IF;
87:
88:
89:

Line 108: fnd_msg_pub.add;

104:
105: IF l_task_id IS NULL
106: THEN
107: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
108: fnd_msg_pub.add;
109: x_return_status := fnd_api.g_ret_sts_unexp_error;
110: RAISE fnd_api.g_exc_unexpected_error;
111: END IF;
112: ----

Line 155: fnd_msg_pub.add;

151:
152: IF l_object_type_code IS NULL
153: THEN
154: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_OBJECT_CODE');
155: fnd_msg_pub.add;
156: x_return_status := fnd_api.g_ret_sts_unexp_error;
157: RAISE fnd_api.g_exc_unexpected_error;
158: END IF;
159:

Line 174: fnd_msg_pub.add;

170: IF c_references%NOTFOUND
171: THEN
172: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');
173: fnd_message.set_token('P_OBJECT_CODE',p_object_type_code);
174: fnd_msg_pub.add;
175: RAISE fnd_api.g_exc_unexpected_error;
176: END IF;
177:
178: */

Line 190: fnd_msg_pub.add;

186:
187: IF p_object_name IS NULL
188: THEN
189: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_OBJECT_NAME');
190: fnd_msg_pub.add;
191: RAISE fnd_api.g_exc_unexpected_error;
192: END IF;
193:
194: */

Line 221: fnd_msg_pub.add;

217: IF l_object_id <> p_object_id
218: THEN
219: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_ID');
220: fnd_message.set_token('P_OBJECT_ID', p_object_id );
221: fnd_msg_pub.add;
222: RAISE fnd_api.g_exc_unexpected_error;
223: END IF;
224: END IF;
225: */

Line 237: fnd_msg_pub.add;

233:
234: IF c_reference_codes%NOTFOUND
235: THEN
236: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_REFER_CODE');
237: fnd_msg_pub.add;
238: RAISE fnd_api.g_exc_unexpected_error;
239: END IF;
240: END IF;
241:

Line 293: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

289: close c_references ;
290: end if;
291:
292:
293: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
294:
295:
296:
297:

Line 308: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

304: end if;
305:
306: rollback to create_references_Pub ;
307: x_return_status := fnd_api.g_ret_sts_unexp_error;
308: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
309: WHEN NO_DATA_FOUND
310: THEN
311:
312: if c_references%isopen then

Line 318: fnd_msg_pub.add;

314: end if;
315: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
316: fnd_message.set_token('P_OBJECT_TYPE_CODE',p_object_type_code );
317: fnd_message.set_token('P_OBJECT_NAME', p_object_name );
318: fnd_msg_pub.add;
319: x_return_status := fnd_api.g_ret_sts_unexp_error;
320:
321: WHEN OTHERS
322: THEN

Line 329: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

325: end if;
326: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
327: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
328: x_return_status := fnd_api.g_ret_sts_unexp_error;
329: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
330: END;
331: -------------------------------------------------
332: -------------------------------------------------
333: -------------------------------------------------

Line 365: fnd_msg_pub.initialize;

361: END IF;
362:
363: IF fnd_api.to_boolean (p_init_msg_list)
364: THEN
365: fnd_msg_pub.initialize;
366: END IF;
367:
368: x_return_status := fnd_api.g_ret_sts_success;
369:

Line 375: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

371: x_task_reference_id => p_task_reference_id ,
372: x_object_version_number => p_object_version_number );
373:
374:
375: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
376: EXCEPTION
377: WHEN Resource_Locked then
378: ROLLBACK TO lock_references_pub;
379: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');

Line 381: fnd_msg_pub.add;

377: WHEN Resource_Locked then
378: ROLLBACK TO lock_references_pub;
379: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
380: fnd_message.set_token ('P_LOCKED_RESOURCE', 'References');
381: fnd_msg_pub.add;
382: x_return_status := fnd_api.g_ret_sts_unexp_error;
383: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
384: WHEN fnd_api.g_exc_unexpected_error
385: THEN

Line 383: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

379: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
380: fnd_message.set_token ('P_LOCKED_RESOURCE', 'References');
381: fnd_msg_pub.add;
382: x_return_status := fnd_api.g_ret_sts_unexp_error;
383: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
384: WHEN fnd_api.g_exc_unexpected_error
385: THEN
386: ROLLBACK TO lock_references_pub;
387: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 388: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

384: WHEN fnd_api.g_exc_unexpected_error
385: THEN
386: ROLLBACK TO lock_references_pub;
387: x_return_status := fnd_api.g_ret_sts_unexp_error;
388: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
389: WHEN OTHERS
390: THEN
391: ROLLBACK TO lock_references_pub;
392: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 394: fnd_msg_pub.add;

390: THEN
391: ROLLBACK TO lock_references_pub;
392: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
393: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
394: fnd_msg_pub.add;
395: x_return_status := fnd_api.g_ret_sts_unexp_error;
396: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
397: END;
398: -------------------------------------------------

Line 396: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

392: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
393: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
394: fnd_msg_pub.add;
395: x_return_status := fnd_api.g_ret_sts_unexp_error;
396: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
397: END;
398: -------------------------------------------------
399: -------------------------------------------------
400: -------------------------------------------------

Line 443: fnd_msg_pub.add;

439: THEN
440:
441: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');
442: fnd_message.set_token('P_OBJECT_TYPE_CODE',p_object_type_code);
443: fnd_msg_pub.add;
444: RAISE fnd_api.g_exc_unexpected_error;
445: END IF;
446:
447:

Line 473: fnd_msg_pub.add;

469: THEN
470: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
471: fnd_message.set_token('P_OBJECT_TYPE_CODE',p_object_type_code );
472: fnd_message.set_token('P_OBJECT_NAME', p_object_name );
473: fnd_msg_pub.add;
474: x_return_status := fnd_api.g_ret_sts_unexp_error;
475: RAISE fnd_api.g_exc_unexpected_error;
476: END IF;
477: END IF;

Line 583: fnd_msg_pub.initialize;

579: END IF;
580:
581: IF fnd_api.to_boolean (p_init_msg_list)
582: THEN
583: fnd_msg_pub.initialize;
584: END IF;
585:
586: IF l_task_reference_id IS NULL
587: THEN

Line 589: fnd_msg_pub.add;

585:
586: IF l_task_reference_id IS NULL
587: THEN
588: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_REFER');
589: fnd_msg_pub.add;
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591: RAISE fnd_api.g_exc_unexpected_error;
592: END IF;
593:

Line 601: fnd_msg_pub.add;

597: IF c_task_reference%NOTFOUND
598: THEN
599: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_REFER');
600: fnd_message.set_token('P_TASK_REFERENCE_ID',p_task_reference_id);
601: fnd_msg_pub.add;
602: x_return_status := fnd_api.g_ret_sts_unexp_error;
603: RAISE fnd_api.g_exc_unexpected_error;
604: END IF;
605:

Line 647: fnd_msg_pub.add;

643:
644: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
645: THEN
646: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_REFER_DETAILS');
647: fnd_msg_pub.add;
648: x_return_status := fnd_api.g_ret_sts_unexp_error;
649: RAISE fnd_api.g_exc_unexpected_error;
650: END IF;
651: */

Line 740: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

736: THEN
737: COMMIT WORK;
738: END IF;
739:
740: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
741:
742: if c_task_reference%isopen then
743: close c_task_reference ;
744: end if;

Line 752: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

748: WHEN fnd_api.g_exc_unexpected_error
749: THEN
750: ROLLBACK TO update_task_reference_pub;
751: x_return_status := fnd_api.g_ret_sts_unexp_error;
752: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
753: if c_task_reference%isopen then
754: close c_task_reference ;
755: end if;
756:

Line 762: fnd_msg_pub.add;

758: THEN
759: ROLLBACK TO update_task_reference_pub;
760: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
761: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
762: fnd_msg_pub.add;
763: x_return_status := fnd_api.g_ret_sts_unexp_error;
764: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
765: if c_task_reference%isopen then
766: close c_task_reference ;

Line 764: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

760: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
761: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
762: fnd_msg_pub.add;
763: x_return_status := fnd_api.g_ret_sts_unexp_error;
764: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
765: if c_task_reference%isopen then
766: close c_task_reference ;
767: end if;
768:

Line 803: fnd_msg_pub.initialize;

799: END IF;
800:
801: IF fnd_api.to_boolean (p_init_msg_list)
802: THEN
803: fnd_msg_pub.initialize;
804: END IF;
805:
806: jtf_task_references_pub.lock_references
807: ( P_API_VERSION => 1.0,

Line 843: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

839: THEN
840: COMMIT WORK;
841: END IF;
842:
843: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
844: EXCEPTION
845: WHEN fnd_api.g_exc_unexpected_error
846: THEN
847: ROLLBACK TO delete_task_reference_pub;

Line 849: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

845: WHEN fnd_api.g_exc_unexpected_error
846: THEN
847: ROLLBACK TO delete_task_reference_pub;
848: x_return_status := fnd_api.g_ret_sts_unexp_error;
849: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
850: WHEN OTHERS
851: THEN
852: ROLLBACK TO delete_task_reference_pub;
853: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 855: fnd_msg_pub.add;

851: THEN
852: ROLLBACK TO delete_task_reference_pub;
853: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
854: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
855: fnd_msg_pub.add;
856: x_return_status := fnd_api.g_ret_sts_unexp_error;
857: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
858: END;
859: END;

Line 857: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

853: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
854: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
855: fnd_msg_pub.add;
856: x_return_status := fnd_api.g_ret_sts_unexp_error;
857: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
858: END;
859: END;