42: END IF;
43:
44: -- Initialize message list if p_init_msg_list is set to TRUE
45: IF fnd_api.to_boolean(p_init_msg_list) THEN
46: fnd_msg_pub.initialize;
47: END IF;
48:
49: -- Initialize API return status to success
50: x_return_status := fnd_api.g_ret_sts_success;
135: EXCEPTION
136: WHEN fnd_api.g_exc_error THEN
137: ROLLBACK TO createschedulerrequest;
138: x_return_status := fnd_api.g_ret_sts_error;
139: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
140: WHEN fnd_api.g_exc_unexpected_error THEN
141: ROLLBACK TO createschedulerrequest;
142: x_return_status := fnd_api.g_ret_sts_unexp_error;
143: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
139: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
140: WHEN fnd_api.g_exc_unexpected_error THEN
141: ROLLBACK TO createschedulerrequest;
142: x_return_status := fnd_api.g_ret_sts_unexp_error;
143: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
144: WHEN OTHERS THEN
145: ROLLBACK TO createschedulerrequest;
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
143: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
144: WHEN OTHERS THEN
145: ROLLBACK TO createschedulerrequest;
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
148: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
149: END IF;
150: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
151: END create_scheduler_request;
144: WHEN OTHERS THEN
145: ROLLBACK TO createschedulerrequest;
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
148: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
149: END IF;
150: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
151: END create_scheduler_request;
152:
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
148: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
149: END IF;
150: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
151: END create_scheduler_request;
152:
153: PROCEDURE create_resource_results(
154: p_api_version IN NUMBER
172: END IF;
173:
174: -- Initialize message list if p_init_msg_list is set to TRUE
175: IF fnd_api.to_boolean(p_init_msg_list) THEN
176: fnd_msg_pub.initialize;
177: END IF;
178:
179: IF p_resource_tbl IS NOT NULL AND p_resource_tbl.COUNT > 0 THEN
180: FOR i IN 1 .. p_resource_tbl.LAST LOOP
216: EXCEPTION
217: WHEN fnd_api.g_exc_error THEN
218: ROLLBACK TO createresourceresults;
219: x_return_status := fnd_api.g_ret_sts_error;
220: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
221: WHEN fnd_api.g_exc_unexpected_error THEN
222: ROLLBACK TO createresourceresults;
223: x_return_status := fnd_api.g_ret_sts_unexp_error;
224: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
220: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
221: WHEN fnd_api.g_exc_unexpected_error THEN
222: ROLLBACK TO createresourceresults;
223: x_return_status := fnd_api.g_ret_sts_unexp_error;
224: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
225: WHEN OTHERS THEN
226: ROLLBACK TO createresourceresults;
227: x_return_status := fnd_api.g_ret_sts_unexp_error;
228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
224: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
225: WHEN OTHERS THEN
226: ROLLBACK TO createresourceresults;
227: x_return_status := fnd_api.g_ret_sts_unexp_error;
228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
229: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
230: END IF;
231: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
232: END create_resource_results;
225: WHEN OTHERS THEN
226: ROLLBACK TO createresourceresults;
227: x_return_status := fnd_api.g_ret_sts_unexp_error;
228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
229: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
230: END IF;
231: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
232: END create_resource_results;
233:
227: x_return_status := fnd_api.g_ret_sts_unexp_error;
228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
229: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
230: END IF;
231: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
232: END create_resource_results;
233:
234: PROCEDURE create_plan_option(
235: p_api_version IN NUMBER
283: END IF;
284:
285: -- Initialize message list if p_init_msg_list is set to TRUE
286: IF fnd_api.to_boolean(p_init_msg_list) THEN
287: fnd_msg_pub.initialize;
288: END IF;
289:
290: -- Initialize API return status to success
291: x_return_status := fnd_api.g_ret_sts_success;
351: EXCEPTION
352: WHEN fnd_api.g_exc_error THEN
353: ROLLBACK TO createplanoption;
354: x_return_status := fnd_api.g_ret_sts_error;
355: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
356: WHEN fnd_api.g_exc_unexpected_error THEN
357: ROLLBACK TO createplanoption;
358: x_return_status := fnd_api.g_ret_sts_unexp_error;
359: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
355: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
356: WHEN fnd_api.g_exc_unexpected_error THEN
357: ROLLBACK TO createplanoption;
358: x_return_status := fnd_api.g_ret_sts_unexp_error;
359: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
360: WHEN OTHERS THEN
361: ROLLBACK TO createplanoption;
362: x_return_status := fnd_api.g_ret_sts_unexp_error;
363:
360: WHEN OTHERS THEN
361: ROLLBACK TO createplanoption;
362: x_return_status := fnd_api.g_ret_sts_unexp_error;
363:
364: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
365: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
366: END IF;
367:
368: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
361: ROLLBACK TO createplanoption;
362: x_return_status := fnd_api.g_ret_sts_unexp_error;
363:
364: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
365: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
366: END IF;
367:
368: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
369: END create_plan_option;
364: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
365: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
366: END IF;
367:
368: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
369: END create_plan_option;
370:
371: PROCEDURE create_plan_option_task(
372: p_api_version IN NUMBER
395: END IF;
396:
397: -- Initialize message list if p_init_msg_list is set to TRUE
398: IF fnd_api.to_boolean(p_init_msg_list) THEN
399: fnd_msg_pub.initialize;
400: END IF;
401:
402: -- Initialize API return status to success
403: x_return_status := fnd_api.g_ret_sts_success;
433: EXCEPTION
434: WHEN fnd_api.g_exc_error THEN
435: ROLLBACK TO createplanoptiontask;
436: x_return_status := fnd_api.g_ret_sts_error;
437: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
438: WHEN fnd_api.g_exc_unexpected_error THEN
439: ROLLBACK TO createplanoptiontask;
440: x_return_status := fnd_api.g_ret_sts_unexp_error;
441: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
437: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
438: WHEN fnd_api.g_exc_unexpected_error THEN
439: ROLLBACK TO createplanoptiontask;
440: x_return_status := fnd_api.g_ret_sts_unexp_error;
441: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
442: WHEN OTHERS THEN
443: ROLLBACK TO createplanoptiontask;
444: x_return_status := fnd_api.g_ret_sts_unexp_error;
445:
442: WHEN OTHERS THEN
443: ROLLBACK TO createplanoptiontask;
444: x_return_status := fnd_api.g_ret_sts_unexp_error;
445:
446: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
447: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
448: END IF;
449:
450: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
443: ROLLBACK TO createplanoptiontask;
444: x_return_status := fnd_api.g_ret_sts_unexp_error;
445:
446: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
447: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
448: END IF;
449:
450: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
451: END create_plan_option_task;
446: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
447: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
448: END IF;
449:
450: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
451: END create_plan_option_task;
452:
453: PROCEDURE create_message(
454: p_api_version IN NUMBER
483: END IF;
484:
485: -- Initialize message list if p_init_msg_list is set to TRUE
486: IF fnd_api.to_boolean(p_init_msg_list) THEN
487: fnd_msg_pub.initialize;
488: END IF;
489:
490: -- Initialize API return status to success
491: x_return_status := fnd_api.g_ret_sts_success;
524: EXCEPTION
525: WHEN fnd_api.g_exc_error THEN
526: ROLLBACK TO createmessage;
527: x_return_status := fnd_api.g_ret_sts_error;
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
529: WHEN fnd_api.g_exc_unexpected_error THEN
530: ROLLBACK TO createmessage;
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);
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
529: WHEN fnd_api.g_exc_unexpected_error THEN
530: ROLLBACK TO createmessage;
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: WHEN OTHERS THEN
534: ROLLBACK TO createmessage;
535: x_return_status := fnd_api.g_ret_sts_unexp_error;
536:
533: WHEN OTHERS THEN
534: ROLLBACK TO createmessage;
535: x_return_status := fnd_api.g_ret_sts_unexp_error;
536:
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
538: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
539: END IF;
540:
541: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
534: ROLLBACK TO createmessage;
535: x_return_status := fnd_api.g_ret_sts_unexp_error;
536:
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
538: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
539: END IF;
540:
541: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
542: END create_message;
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
538: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
539: END IF;
540:
541: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
542: END create_message;
543:
544: PROCEDURE create_message_token(
545: p_api_version IN NUMBER
564: END IF;
565:
566: -- Initialize message list if p_init_msg_list is set to TRUE
567: IF fnd_api.to_boolean(p_init_msg_list) THEN
568: fnd_msg_pub.initialize;
569: END IF;
570:
571: -- Initialize API return status to success
572: x_return_status := fnd_api.g_ret_sts_success;
594: EXCEPTION
595: WHEN fnd_api.g_exc_error THEN
596: ROLLBACK TO createmessagetoken;
597: x_return_status := fnd_api.g_ret_sts_error;
598: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
599: --
600: WHEN fnd_api.g_exc_unexpected_error THEN
601: ROLLBACK TO createmessagetoken;
602: x_return_status := fnd_api.g_ret_sts_unexp_error;
599: --
600: WHEN fnd_api.g_exc_unexpected_error THEN
601: ROLLBACK TO createmessagetoken;
602: x_return_status := fnd_api.g_ret_sts_unexp_error;
603: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
604: --
605: WHEN OTHERS THEN
606: ROLLBACK TO createmessagetoken;
607: x_return_status := fnd_api.g_ret_sts_unexp_error;
605: WHEN OTHERS THEN
606: ROLLBACK TO createmessagetoken;
607: x_return_status := fnd_api.g_ret_sts_unexp_error;
608:
609: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
610: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
611: END IF;
612:
613: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
606: ROLLBACK TO createmessagetoken;
607: x_return_status := fnd_api.g_ret_sts_unexp_error;
608:
609: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
610: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
611: END IF;
612:
613: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
614: END create_message_token;
609: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
610: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
611: END IF;
612:
613: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
614: END create_message_token;
615:
616: PROCEDURE create_plan_options(
617: p_api_version IN NUMBER
674: END IF;
675:
676: -- Initialize message list if p_init_msg_list is set to TRUE
677: IF fnd_api.to_boolean(p_init_msg_list) THEN
678: fnd_msg_pub.initialize;
679: END IF;
680:
681: -- Initialize API return status to success
682: x_return_status := fnd_api.g_ret_sts_success;
776: EXCEPTION
777: WHEN fnd_api.g_exc_error THEN
778: ROLLBACK TO createplanoptions;
779: x_return_status := fnd_api.g_ret_sts_error;
780: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
781: WHEN fnd_api.g_exc_unexpected_error THEN
782: ROLLBACK TO createplanoptions;
783: x_return_status := fnd_api.g_ret_sts_unexp_error;
784: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
780: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
781: WHEN fnd_api.g_exc_unexpected_error THEN
782: ROLLBACK TO createplanoptions;
783: x_return_status := fnd_api.g_ret_sts_unexp_error;
784: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
785: WHEN OTHERS THEN
786: ROLLBACK TO createplanoptions;
787: x_return_status := fnd_api.g_ret_sts_unexp_error;
788:
785: WHEN OTHERS THEN
786: ROLLBACK TO createplanoptions;
787: x_return_status := fnd_api.g_ret_sts_unexp_error;
788:
789: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
790: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
791: END IF;
792: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
793: END create_plan_options;
786: ROLLBACK TO createplanoptions;
787: x_return_status := fnd_api.g_ret_sts_unexp_error;
788:
789: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
790: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
791: END IF;
792: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
793: END create_plan_options;
794:
788:
789: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
790: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
791: END IF;
792: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
793: END create_plan_options;
794:
795: PROCEDURE create_multi_trips_request(
796: p_api_version IN NUMBER
820: END IF;
821:
822: -- Initialize message list if p_init_msg_list is set to TRUE
823: IF fnd_api.to_boolean(p_init_msg_list) THEN
824: fnd_msg_pub.initialize;
825: END IF;
826:
827: -- Initialize API return status to success
828: x_return_status := fnd_api.g_ret_sts_success;
898: EXCEPTION
899: WHEN fnd_api.g_exc_error THEN
900: ROLLBACK TO create_opttrips_request;
901: x_return_status := fnd_api.g_ret_sts_error;
902: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
903: WHEN fnd_api.g_exc_unexpected_error THEN
904: ROLLBACK TO create_opttrips_request;
905: x_return_status := fnd_api.g_ret_sts_unexp_error;
906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
902: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
903: WHEN fnd_api.g_exc_unexpected_error THEN
904: ROLLBACK TO create_opttrips_request;
905: x_return_status := fnd_api.g_ret_sts_unexp_error;
906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
907: WHEN OTHERS THEN
908: ROLLBACK TO create_opttrips_request;
909: x_return_status := fnd_api.g_ret_sts_unexp_error;
910:
907: WHEN OTHERS THEN
908: ROLLBACK TO create_opttrips_request;
909: x_return_status := fnd_api.g_ret_sts_unexp_error;
910:
911: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
913: END IF;
914: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
915: END create_multi_trips_request;
908: ROLLBACK TO create_opttrips_request;
909: x_return_status := fnd_api.g_ret_sts_unexp_error;
910:
911: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
913: END IF;
914: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
915: END create_multi_trips_request;
916: END csf_requests_pvt;
910:
911: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
913: END IF;
914: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
915: END create_multi_trips_request;
916: END csf_requests_pvt;