56: END IF;
57:
58: -- Initialize message list if p_init_msg_list is set to TRUE
59: IF fnd_api.to_boolean(p_init_msg_list) THEN
60: fnd_msg_pub.initialize;
61: END IF;
62:
63: -- Initialize API return status to success
64: x_return_status := fnd_api.g_ret_sts_success;
119: COMMIT WORK;
120: END IF;
121:
122: -- Standard call to get message count and if count is 1, get message info
123: fnd_msg_pub.count_and_get( p_count => x_msg_count
124: , p_data => x_msg_data );
125:
126: EXCEPTION
127: WHEN fnd_api.g_exc_error THEN
126: EXCEPTION
127: WHEN fnd_api.g_exc_error THEN
128: ROLLBACK TO copy_schedule_entries_pub;
129: x_return_status := fnd_api.g_ret_sts_error;
130: fnd_msg_pub.count_and_get( p_count => x_msg_count
131: , p_data => x_msg_data );
132: WHEN fnd_api.g_exc_unexpected_error THEN
133: ROLLBACK TO copy_schedule_entries_pub;
134: x_return_status := fnd_api.g_ret_sts_unexp_error;
131: , p_data => x_msg_data );
132: WHEN fnd_api.g_exc_unexpected_error THEN
133: ROLLBACK TO copy_schedule_entries_pub;
134: x_return_status := fnd_api.g_ret_sts_unexp_error;
135: fnd_msg_pub.count_and_get( p_count => x_msg_count
136: , p_data => x_msg_data );
137: WHEN OTHERS THEN
138: ROLLBACK TO copy_schedule_entries_pub;
139: x_return_status := fnd_api.g_ret_sts_unexp_error;
136: , p_data => x_msg_data );
137: WHEN OTHERS THEN
138: ROLLBACK TO copy_schedule_entries_pub;
139: x_return_status := fnd_api.g_ret_sts_unexp_error;
140: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
141: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
142: END IF;
143: fnd_msg_pub.count_and_get( p_count => x_msg_count
144: , p_data => x_msg_data );
137: WHEN OTHERS THEN
138: ROLLBACK TO copy_schedule_entries_pub;
139: x_return_status := fnd_api.g_ret_sts_unexp_error;
140: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
141: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
142: END IF;
143: fnd_msg_pub.count_and_get( p_count => x_msg_count
144: , p_data => x_msg_data );
145:
139: x_return_status := fnd_api.g_ret_sts_unexp_error;
140: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
141: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
142: END IF;
143: fnd_msg_pub.count_and_get( p_count => x_msg_count
144: , p_data => x_msg_data );
145:
146: END CopyScheduleEntries;
147:
198: END IF;
199:
200: -- Initialize message list if p_init_msg_list is set to TRUE
201: IF fnd_api.to_boolean(p_init_msg_list) THEN
202: fnd_msg_pub.initialize;
203: END IF;
204:
205: -- Initialize API return status to success
206: x_return_status := fnd_api.g_ret_sts_success;
261: COMMIT WORK;
262: END IF;
263:
264: -- Standard call to get message count and if count is 1, get message info
265: fnd_msg_pub.count_and_get( p_count => x_msg_count
266: , p_data => x_msg_data );
267:
268: EXCEPTION
269: WHEN fnd_api.g_exc_error THEN
268: EXCEPTION
269: WHEN fnd_api.g_exc_error THEN
270: ROLLBACK TO move_schedule_entries_pub;
271: x_return_status := fnd_api.g_ret_sts_error;
272: fnd_msg_pub.count_and_get( p_count => x_msg_count
273: , p_data => x_msg_data );
274: WHEN fnd_api.g_exc_unexpected_error THEN
275: ROLLBACK TO move_schedule_entries_pub;
276: x_return_status := fnd_api.g_ret_sts_unexp_error;
273: , p_data => x_msg_data );
274: WHEN fnd_api.g_exc_unexpected_error THEN
275: ROLLBACK TO move_schedule_entries_pub;
276: x_return_status := fnd_api.g_ret_sts_unexp_error;
277: fnd_msg_pub.count_and_get( p_count => x_msg_count
278: , p_data => x_msg_data );
279: WHEN OTHERS THEN
280: ROLLBACK TO move_schedule_entries_pub;
281: x_return_status := fnd_api.g_ret_sts_unexp_error;
278: , p_data => x_msg_data );
279: WHEN OTHERS THEN
280: ROLLBACK TO move_schedule_entries_pub;
281: x_return_status := fnd_api.g_ret_sts_unexp_error;
282: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
283: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
284: END IF;
285: fnd_msg_pub.count_and_get( p_count => x_msg_count
286: , p_data => x_msg_data );
279: WHEN OTHERS THEN
280: ROLLBACK TO move_schedule_entries_pub;
281: x_return_status := fnd_api.g_ret_sts_unexp_error;
282: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
283: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
284: END IF;
285: fnd_msg_pub.count_and_get( p_count => x_msg_count
286: , p_data => x_msg_data );
287:
281: x_return_status := fnd_api.g_ret_sts_unexp_error;
282: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
283: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
284: END IF;
285: fnd_msg_pub.count_and_get( p_count => x_msg_count
286: , p_data => x_msg_data );
287:
288: END MoveScheduleEntries;
289:
337: END IF;
338:
339: -- Initialize message list if p_init_msg_list is set to TRUE
340: IF fnd_api.to_boolean(p_init_msg_list) THEN
341: fnd_msg_pub.initialize;
342: END IF;
343:
344: -- Initialize API return status to success
345: x_return_status := fnd_api.g_ret_sts_success;
398: COMMIT WORK;
399: END IF;
400:
401: -- Standard call to get message count and if count is 1, get message info
402: fnd_msg_pub.count_and_get( p_count => x_msg_count
403: , p_data => x_msg_data );
404:
405: EXCEPTION
406: WHEN fnd_api.g_exc_error THEN
405: EXCEPTION
406: WHEN fnd_api.g_exc_error THEN
407: ROLLBACK TO purge_schedule_entries_pub;
408: x_return_status := fnd_api.g_ret_sts_error;
409: fnd_msg_pub.count_and_get( p_count => x_msg_count
410: , p_data => x_msg_data );
411: WHEN fnd_api.g_exc_unexpected_error THEN
412: ROLLBACK TO purge_schedule_entries_pub;
413: x_return_status := fnd_api.g_ret_sts_unexp_error;
410: , p_data => x_msg_data );
411: WHEN fnd_api.g_exc_unexpected_error THEN
412: ROLLBACK TO purge_schedule_entries_pub;
413: x_return_status := fnd_api.g_ret_sts_unexp_error;
414: fnd_msg_pub.count_and_get( p_count => x_msg_count
415: , p_data => x_msg_data );
416: WHEN OTHERS THEN
417: ROLLBACK TO purge_schedule_entries_pub;
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
415: , p_data => x_msg_data );
416: WHEN OTHERS THEN
417: ROLLBACK TO purge_schedule_entries_pub;
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
420: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
421: END IF;
422: fnd_msg_pub.count_and_get( p_count => x_msg_count
423: , p_data => x_msg_data );
416: WHEN OTHERS THEN
417: ROLLBACK TO purge_schedule_entries_pub;
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
420: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
421: END IF;
422: fnd_msg_pub.count_and_get( p_count => x_msg_count
423: , p_data => x_msg_data );
424:
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
420: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
421: END IF;
422: fnd_msg_pub.count_and_get( p_count => x_msg_count
423: , p_data => x_msg_data );
424:
425: END PurgeScheduleEntries;
426:
474: END IF;
475:
476: -- Initialize message list if p_init_msg_list is set to TRUE
477: IF fnd_api.to_boolean(p_init_msg_list) THEN
478: fnd_msg_pub.initialize;
479: END IF;
480:
481: -- Initialize API return status to success
482: x_return_status := fnd_api.g_ret_sts_success;
535: COMMIT WORK;
536: END IF;
537:
538: -- Standard call to get message count and if count is 1, get message info
539: fnd_msg_pub.count_and_get( p_count => x_msg_count
540: , p_data => x_msg_data );
541:
542: EXCEPTION
543: WHEN fnd_api.g_exc_error THEN
542: EXCEPTION
543: WHEN fnd_api.g_exc_error THEN
544: ROLLBACK TO stop_schedule_pub;
545: x_return_status := fnd_api.g_ret_sts_error;
546: fnd_msg_pub.count_and_get( p_count => x_msg_count
547: , p_data => x_msg_data );
548: WHEN fnd_api.g_exc_unexpected_error THEN
549: ROLLBACK TO stop_schedule_pub;
550: x_return_status := fnd_api.g_ret_sts_unexp_error;
547: , p_data => x_msg_data );
548: WHEN fnd_api.g_exc_unexpected_error THEN
549: ROLLBACK TO stop_schedule_pub;
550: x_return_status := fnd_api.g_ret_sts_unexp_error;
551: fnd_msg_pub.count_and_get( p_count => x_msg_count
552: , p_data => x_msg_data );
553: WHEN OTHERS THEN
554: ROLLBACK TO stop_schedule_pub;
555: x_return_status := fnd_api.g_ret_sts_unexp_error;
552: , p_data => x_msg_data );
553: WHEN OTHERS THEN
554: ROLLBACK TO stop_schedule_pub;
555: x_return_status := fnd_api.g_ret_sts_unexp_error;
556: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
557: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
558: END IF;
559: fnd_msg_pub.count_and_get( p_count => x_msg_count
560: , p_data => x_msg_data );
553: WHEN OTHERS THEN
554: ROLLBACK TO stop_schedule_pub;
555: x_return_status := fnd_api.g_ret_sts_unexp_error;
556: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
557: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
558: END IF;
559: fnd_msg_pub.count_and_get( p_count => x_msg_count
560: , p_data => x_msg_data );
561:
555: x_return_status := fnd_api.g_ret_sts_unexp_error;
556: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
557: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
558: END IF;
559: fnd_msg_pub.count_and_get( p_count => x_msg_count
560: , p_data => x_msg_data );
561:
562: END StopScheduleExecution;
563: