DBA Data[Home] [Help]

APPS.JTF_TASK_DATES_PVT dependencies on FND_MSG_PUB

Line 62: fnd_msg_pub.initialize;

58: END IF;
59:
60: IF fnd_api.to_boolean (p_init_msg_list)
61: THEN
62: fnd_msg_pub.initialize;
63: END IF;
64:
65: x_return_status := fnd_api.g_ret_sts_success;
66:

Line 108: fnd_msg_pub.add;

104: IF c_jtf_task_dates%NOTFOUND
105: THEN
106: x_return_status := fnd_api.g_ret_sts_unexp_error;
107: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_DATE');
108: fnd_msg_pub.add;
109: RAISE fnd_api.g_exc_unexpected_error;
110: ELSE
111: x_task_date_id := l_task_date_id;
112: END IF;

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

115: THEN
116: COMMIT WORK;
117: END IF;
118:
119: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
120:
121: EXCEPTION
122: WHEN fnd_api.g_exc_unexpected_error
123: THEN

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

122: WHEN fnd_api.g_exc_unexpected_error
123: THEN
124: rollback to create_task_dates_pvt;
125: x_return_status := fnd_api.g_ret_sts_unexp_error;
126: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
127: WHEN OTHERS
128: THEN
129: rollback to create_task_dates_pvt;
130: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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

129: rollback to create_task_dates_pvt;
130: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
131: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
132: x_return_status := fnd_api.g_ret_sts_unexp_error;
133: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
134: END;
135:
136: PROCEDURE update_task_dates (
137: p_api_version IN NUMBER,

Line 209: fnd_msg_pub.initialize;

205: END IF;
206:
207: IF fnd_api.to_boolean (p_init_msg_list)
208: THEN
209: fnd_msg_pub.initialize;
210: END IF;
211:
212: x_return_status := fnd_api.g_ret_sts_success;
213:

Line 221: fnd_msg_pub.add;

217: IF c_update_task_dates%NOTFOUND
218: THEN
219: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATE');
220: fnd_message.set_token('P_TASK_DATE_ID',P_TASK_DATE_ID);
221: fnd_msg_pub.add;
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: RAISE fnd_api.g_exc_unexpected_error;
224: END IF;
225:

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

300: THEN
301: COMMIT WORK;
302: END IF;
303:
304: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
305: EXCEPTION
306: WHEN fnd_api.g_exc_unexpected_error
307: THEN
308: ROLLBACK TO update_task_dates_pvt;

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

306: WHEN fnd_api.g_exc_unexpected_error
307: THEN
308: ROLLBACK TO update_task_dates_pvt;
309: x_return_status := fnd_api.g_ret_sts_unexp_error;
310: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
311: WHEN OTHERS
312: THEN
313: ROLLBACK TO update_task_dates_pvt;
314: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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

313: ROLLBACK TO update_task_dates_pvt;
314: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
315: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
316: x_return_status := fnd_api.g_ret_sts_unexp_error;
317: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
318: END;
319:
320: ---- Delete task dates
321: PROCEDURE delete_task_dates (

Line 350: fnd_msg_pub.initialize;

346: END IF;
347:
348: IF fnd_api.to_boolean (p_init_msg_list)
349: THEN
350: fnd_msg_pub.initialize;
351: END IF;
352:
353:
354: x_return_status := fnd_api.g_ret_sts_success;

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

377: THEN
378: COMMIT WORK;
379: END IF;
380:
381: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
382: EXCEPTION
383: WHEN fnd_api.g_exc_unexpected_error
384: THEN
385: ROLLBACK TO delete_task_dates_pvt;

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

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

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

390: ROLLBACK TO delete_task_dates_pvt;
391: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
392: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
393: x_return_status := fnd_api.g_ret_sts_unexp_error;
394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
395: END;
396: END; -- CREATE OR REPLACE PACKAGE spec