DBA Data[Home] [Help]

APPS.JTF_TASK_DATES_PUB dependencies on FND_MSG_PUB

Line 66: fnd_msg_pub.initialize;

62: END IF;
63:
64: IF fnd_api.to_boolean (p_init_msg_list)
65: THEN
66: fnd_msg_pub.initialize;
67: END IF;
68:
69: jtf_task_utl.validate_task (
70: x_return_status => x_return_status,

Line 85: fnd_msg_pub.add;

81:
82: IF l_task_id IS NULL
83: THEN
84: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
85: fnd_msg_pub.add;
86: x_return_status := fnd_api.g_ret_sts_unexp_error;
87: RAISE fnd_api.g_exc_unexpected_error;
88: END IF;
89:

Line 101: fnd_msg_pub.add;

97: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
98: THEN
99: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATE_TYPE_ID');
100: fnd_message.set_token('P_DATE_TYPE_ID' , p_date_type_id );
101: fnd_msg_pub.add;
102: RAISE fnd_api.g_exc_unexpected_error;
103: END IF;
104:
105: IF l_date_type_id IS NULL

Line 108: fnd_msg_pub.add;

104:
105: IF l_date_type_id IS NULL
106: THEN
107: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_DATE_TYPE_ID');
108: fnd_msg_pub.add;
109: RAISE fnd_api.g_exc_unexpected_error;
110: END IF;
111:
112: IF p_date_value IS NULL

Line 115: fnd_msg_pub.add;

111:
112: IF p_date_value IS NULL
113: THEN
114: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_DATES');
115: fnd_msg_pub.add;
116: RAISE fnd_api.g_exc_unexpected_error;
117: END IF;
118:
119: jtf_task_dates_pvt.create_task_dates (

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

149: THEN
150: COMMIT WORK;
151: END IF;
152:
153: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
154:
155: EXCEPTION
156: WHEN fnd_api.g_exc_unexpected_error
157: THEN

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

156: WHEN fnd_api.g_exc_unexpected_error
157: THEN
158: ROLLBACK TO create_task_dates_pub ;
159: x_return_status := fnd_api.g_ret_sts_unexp_error;
160: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
161: WHEN OTHERS
162: THEN
163: ROLLBACK TO create_task_dates_pub ;
164: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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

163: ROLLBACK TO create_task_dates_pub ;
164: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
165: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
168: END;
169:
170: PROCEDURE lock_task_dates (
171: p_api_version IN NUMBER,

Line 199: fnd_msg_pub.initialize;

195: END IF;
196:
197: IF fnd_api.to_boolean (p_init_msg_list)
198: THEN
199: fnd_msg_pub.initialize;
200: END IF;
201:
202: x_return_status := fnd_api.g_ret_sts_success;
203:

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

205: x_task_date_id => p_task_date_id ,
206: x_object_version_number => p_object_version_number );
207:
208:
209: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
210:
211: EXCEPTION
212: WHEN Resource_Locked then
213: ROLLBACK TO lock_task_dates_pub;

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

213: ROLLBACK TO lock_task_dates_pub;
214: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
215: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
216: x_return_status := fnd_api.g_ret_sts_unexp_error;
217: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
218:
219: WHEN fnd_api.g_exc_unexpected_error
220: THEN
221: ROLLBACK TO lock_task_dates_pub;

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

219: WHEN fnd_api.g_exc_unexpected_error
220: THEN
221: ROLLBACK TO lock_task_dates_pub;
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
224: WHEN OTHERS
225: THEN
226: ROLLBACK TO lock_task_dates_pub;
227: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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

226: ROLLBACK TO lock_task_dates_pub;
227: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
228: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
229: x_return_status := fnd_api.g_ret_sts_unexp_error;
230: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
231: END;
232:
233: PROCEDURE update_task_dates (
234: p_api_version IN NUMBER,

Line 307: fnd_msg_pub.initialize;

303: END IF;
304:
305: IF fnd_api.to_boolean (p_init_msg_list)
306: THEN
307: fnd_msg_pub.initialize;
308: END IF;
309:
310:
311: x_return_status := fnd_api.g_ret_sts_success;

Line 320: fnd_msg_pub.add;

316: IF c_update_task_dates%NOTFOUND
317: THEN
318: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATE');
319: fnd_message.set_token('P_TASK_DATE_ID',P_TASK_DATE_ID);
320: fnd_msg_pub.add;
321: x_return_status := fnd_api.g_ret_sts_unexp_error;
322: RAISE fnd_api.g_exc_unexpected_error;
323: END IF;
324:

Line 358: fnd_msg_pub.add;

354: IF l_date_type_id IS NULL
355: THEN
356: x_return_status := fnd_api.g_ret_sts_unexp_error;
357: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_DATE_TYPE_ID');
358: fnd_msg_pub.add;
359: RAISE fnd_api.g_exc_unexpected_error;
360: END IF;
361: ELSE
362: l_date_type_id := task_dates.date_type_id;

Line 375: fnd_msg_pub.add;

371: IF l_date_value IS NULL
372: THEN
373: x_return_status := fnd_api.g_ret_sts_unexp_error;
374: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_DATES');
375: fnd_msg_pub.add;
376: RAISE fnd_api.g_exc_unexpected_error;
377: END IF;
378:
379: l_task_id := task_dates.task_id ;

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

434: THEN
435: COMMIT WORK;
436: END IF;
437:
438: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
439: EXCEPTION
440: WHEN fnd_api.g_exc_unexpected_error
441: THEN
442: rollback to update_task_dates_pub;

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

440: WHEN fnd_api.g_exc_unexpected_error
441: THEN
442: rollback to update_task_dates_pub;
443: x_return_status := fnd_api.g_ret_sts_unexp_error;
444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
445: WHEN OTHERS
446: THEN
447: rollback to update_task_dates_pub;
448: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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

447: rollback to update_task_dates_pub;
448: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
449: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
450: x_return_status := fnd_api.g_ret_sts_unexp_error;
451: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
452: END;
453:
454: PROCEDURE delete_task_dates (
455: p_api_version IN NUMBER,

Line 479: fnd_msg_pub.initialize;

475: END IF;
476:
477: IF fnd_api.to_boolean (p_init_msg_list)
478: THEN
479: fnd_msg_pub.initialize;
480: END IF;
481:
482: jtf_task_dates_pub.lock_task_dates
483: ( P_API_VERSION => 1.0 ,

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

515: THEN
516: COMMIT WORK;
517: END IF;
518:
519: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
520: EXCEPTION
521: WHEN fnd_api.g_exc_unexpected_error
522: THEN
523: ROLLBACK TO delete_task_date_pub;

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

521: WHEN fnd_api.g_exc_unexpected_error
522: THEN
523: ROLLBACK TO delete_task_date_pub;
524: x_return_status := fnd_api.g_ret_sts_unexp_error;
525: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
526: WHEN OTHERS
527: THEN
528: ROLLBACK TO delete_task_date_pub;
529: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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

528: ROLLBACK TO delete_task_date_pub;
529: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
530: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
531: x_return_status := fnd_api.g_ret_sts_unexp_error;
532: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
533: END; -- Delete Task Dates
534: END;