38: END IF;
39:
40: -- Initialize message list if p_init_msg_list is set to TRUE
41: IF fnd_api.to_boolean(p_init_msg_list) THEN
42: fnd_msg_pub.initialize;
43: END IF;
44:
45: -- Initialize API return status to success
46: x_return_status := fnd_api.g_ret_sts_success;
120: EXCEPTION
121: WHEN fnd_api.g_exc_error THEN
122: ROLLBACK TO createschedulerrequest;
123: x_return_status := fnd_api.g_ret_sts_error;
124: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
125: WHEN fnd_api.g_exc_unexpected_error THEN
126: ROLLBACK TO createschedulerrequest;
127: x_return_status := fnd_api.g_ret_sts_unexp_error;
128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
124: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
125: WHEN fnd_api.g_exc_unexpected_error THEN
126: ROLLBACK TO createschedulerrequest;
127: x_return_status := fnd_api.g_ret_sts_unexp_error;
128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
129: WHEN OTHERS THEN
130: ROLLBACK TO createschedulerrequest;
131: x_return_status := fnd_api.g_ret_sts_unexp_error;
132: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
129: WHEN OTHERS THEN
130: ROLLBACK TO createschedulerrequest;
131: x_return_status := fnd_api.g_ret_sts_unexp_error;
132: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
133: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
134: END IF;
135: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
136: END create_scheduler_request;
129: WHEN OTHERS THEN
130: ROLLBACK TO createschedulerrequest;
131: x_return_status := fnd_api.g_ret_sts_unexp_error;
132: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
133: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
134: END IF;
135: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
136: END create_scheduler_request;
137:
131: x_return_status := fnd_api.g_ret_sts_unexp_error;
132: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
133: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
134: END IF;
135: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
136: END create_scheduler_request;
137:
138: PROCEDURE create_resource_results(
139: p_api_version IN NUMBER
157: END IF;
158:
159: -- Initialize message list if p_init_msg_list is set to TRUE
160: IF fnd_api.to_boolean(p_init_msg_list) THEN
161: fnd_msg_pub.initialize;
162: END IF;
163:
164: IF p_resource_tbl IS NOT NULL AND p_resource_tbl.COUNT > 0 THEN
165: FOR i IN 1 .. p_resource_tbl.LAST LOOP
197: EXCEPTION
198: WHEN fnd_api.g_exc_error THEN
199: ROLLBACK TO createresourceresults;
200: x_return_status := fnd_api.g_ret_sts_error;
201: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
202: WHEN fnd_api.g_exc_unexpected_error THEN
203: ROLLBACK TO createresourceresults;
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
201: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
202: WHEN fnd_api.g_exc_unexpected_error THEN
203: ROLLBACK TO createresourceresults;
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
206: WHEN OTHERS THEN
207: ROLLBACK TO createresourceresults;
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
205: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
206: WHEN OTHERS THEN
207: ROLLBACK TO createresourceresults;
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
210: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
211: END IF;
212: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
213: END create_resource_results;
206: WHEN OTHERS THEN
207: ROLLBACK TO createresourceresults;
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
210: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
211: END IF;
212: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
213: END create_resource_results;
214:
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
210: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
211: END IF;
212: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
213: END create_resource_results;
214:
215: PROCEDURE create_plan_option(
216: p_api_version IN NUMBER
263: END IF;
264:
265: -- Initialize message list if p_init_msg_list is set to TRUE
266: IF fnd_api.to_boolean(p_init_msg_list) THEN
267: fnd_msg_pub.initialize;
268: END IF;
269:
270: -- Initialize API return status to success
271: x_return_status := fnd_api.g_ret_sts_success;
329: EXCEPTION
330: WHEN fnd_api.g_exc_error THEN
331: ROLLBACK TO createplanoption;
332: x_return_status := fnd_api.g_ret_sts_error;
333: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error THEN
335: ROLLBACK TO createplanoption;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
333: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error THEN
335: ROLLBACK TO createplanoption;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
338: WHEN OTHERS THEN
339: ROLLBACK TO createplanoption;
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341:
338: WHEN OTHERS THEN
339: ROLLBACK TO createplanoption;
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341:
342: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
343: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
344: END IF;
345:
346: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
339: ROLLBACK TO createplanoption;
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341:
342: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
343: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
344: END IF;
345:
346: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
347: END create_plan_option;
342: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
343: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
344: END IF;
345:
346: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
347: END create_plan_option;
348:
349: PROCEDURE create_plan_option_task(
350: p_api_version IN NUMBER
373: END IF;
374:
375: -- Initialize message list if p_init_msg_list is set to TRUE
376: IF fnd_api.to_boolean(p_init_msg_list) THEN
377: fnd_msg_pub.initialize;
378: END IF;
379:
380: -- Initialize API return status to success
381: x_return_status := fnd_api.g_ret_sts_success;
411: EXCEPTION
412: WHEN fnd_api.g_exc_error THEN
413: ROLLBACK TO createplanoptiontask;
414: x_return_status := fnd_api.g_ret_sts_error;
415: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
416: WHEN fnd_api.g_exc_unexpected_error THEN
417: ROLLBACK TO createplanoptiontask;
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
415: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
416: WHEN fnd_api.g_exc_unexpected_error THEN
417: ROLLBACK TO createplanoptiontask;
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
420: WHEN OTHERS THEN
421: ROLLBACK TO createplanoptiontask;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423:
420: WHEN OTHERS THEN
421: ROLLBACK TO createplanoptiontask;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423:
424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
425: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
426: END IF;
427:
428: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
421: ROLLBACK TO createplanoptiontask;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423:
424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
425: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
426: END IF;
427:
428: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
429: END create_plan_option_task;
424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
425: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
426: END IF;
427:
428: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
429: END create_plan_option_task;
430:
431: PROCEDURE create_message(
432: p_api_version IN NUMBER
461: END IF;
462:
463: -- Initialize message list if p_init_msg_list is set to TRUE
464: IF fnd_api.to_boolean(p_init_msg_list) THEN
465: fnd_msg_pub.initialize;
466: END IF;
467:
468: -- Initialize API return status to success
469: x_return_status := fnd_api.g_ret_sts_success;
502: EXCEPTION
503: WHEN fnd_api.g_exc_error THEN
504: ROLLBACK TO createmessage;
505: x_return_status := fnd_api.g_ret_sts_error;
506: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
507: WHEN fnd_api.g_exc_unexpected_error THEN
508: ROLLBACK TO createmessage;
509: x_return_status := fnd_api.g_ret_sts_unexp_error;
510: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
506: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
507: WHEN fnd_api.g_exc_unexpected_error THEN
508: ROLLBACK TO createmessage;
509: x_return_status := fnd_api.g_ret_sts_unexp_error;
510: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
511: WHEN OTHERS THEN
512: ROLLBACK TO createmessage;
513: x_return_status := fnd_api.g_ret_sts_unexp_error;
514:
511: WHEN OTHERS THEN
512: ROLLBACK TO createmessage;
513: x_return_status := fnd_api.g_ret_sts_unexp_error;
514:
515: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
516: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
517: END IF;
518:
519: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
512: ROLLBACK TO createmessage;
513: x_return_status := fnd_api.g_ret_sts_unexp_error;
514:
515: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
516: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
517: END IF;
518:
519: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
520: END create_message;
515: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
516: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
517: END IF;
518:
519: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
520: END create_message;
521:
522: PROCEDURE create_message_token(
523: p_api_version IN NUMBER
542: END IF;
543:
544: -- Initialize message list if p_init_msg_list is set to TRUE
545: IF fnd_api.to_boolean(p_init_msg_list) THEN
546: fnd_msg_pub.initialize;
547: END IF;
548:
549: -- Initialize API return status to success
550: x_return_status := fnd_api.g_ret_sts_success;
572: EXCEPTION
573: WHEN fnd_api.g_exc_error THEN
574: ROLLBACK TO createmessagetoken;
575: x_return_status := fnd_api.g_ret_sts_error;
576: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
577: --
578: WHEN fnd_api.g_exc_unexpected_error THEN
579: ROLLBACK TO createmessagetoken;
580: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: --
578: WHEN fnd_api.g_exc_unexpected_error THEN
579: ROLLBACK TO createmessagetoken;
580: x_return_status := fnd_api.g_ret_sts_unexp_error;
581: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
582: --
583: WHEN OTHERS THEN
584: ROLLBACK TO createmessagetoken;
585: x_return_status := fnd_api.g_ret_sts_unexp_error;
583: WHEN OTHERS THEN
584: ROLLBACK TO createmessagetoken;
585: x_return_status := fnd_api.g_ret_sts_unexp_error;
586:
587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
588: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
589: END IF;
590:
591: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
584: ROLLBACK TO createmessagetoken;
585: x_return_status := fnd_api.g_ret_sts_unexp_error;
586:
587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
588: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
589: END IF;
590:
591: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
592: END create_message_token;
587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
588: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
589: END IF;
590:
591: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
592: END create_message_token;
593:
594: PROCEDURE create_plan_options(
595: p_api_version IN NUMBER
644: END IF;
645:
646: -- Initialize message list if p_init_msg_list is set to TRUE
647: IF fnd_api.to_boolean(p_init_msg_list) THEN
648: fnd_msg_pub.initialize;
649: END IF;
650:
651: -- Initialize API return status to success
652: x_return_status := fnd_api.g_ret_sts_success;
716: EXCEPTION
717: WHEN fnd_api.g_exc_error THEN
718: ROLLBACK TO createplanoptions;
719: x_return_status := fnd_api.g_ret_sts_error;
720: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
721: WHEN fnd_api.g_exc_unexpected_error THEN
722: ROLLBACK TO createplanoptions;
723: x_return_status := fnd_api.g_ret_sts_unexp_error;
724: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
720: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
721: WHEN fnd_api.g_exc_unexpected_error THEN
722: ROLLBACK TO createplanoptions;
723: x_return_status := fnd_api.g_ret_sts_unexp_error;
724: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
725: WHEN OTHERS THEN
726: ROLLBACK TO createplanoptions;
727: x_return_status := fnd_api.g_ret_sts_unexp_error;
728:
725: WHEN OTHERS THEN
726: ROLLBACK TO createplanoptions;
727: x_return_status := fnd_api.g_ret_sts_unexp_error;
728:
729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
730: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
731: END IF;
732: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
733: END create_plan_options;
726: ROLLBACK TO createplanoptions;
727: x_return_status := fnd_api.g_ret_sts_unexp_error;
728:
729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
730: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
731: END IF;
732: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
733: END create_plan_options;
734:
728:
729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
730: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
731: END IF;
732: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
733: END create_plan_options;
734:
735: PROCEDURE create_multi_trips_request(
736: p_api_version IN NUMBER
760: END IF;
761:
762: -- Initialize message list if p_init_msg_list is set to TRUE
763: IF fnd_api.to_boolean(p_init_msg_list) THEN
764: fnd_msg_pub.initialize;
765: END IF;
766:
767: -- Initialize API return status to success
768: x_return_status := fnd_api.g_ret_sts_success;
838: EXCEPTION
839: WHEN fnd_api.g_exc_error THEN
840: ROLLBACK TO create_opttrips_request;
841: x_return_status := fnd_api.g_ret_sts_error;
842: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
843: WHEN fnd_api.g_exc_unexpected_error THEN
844: ROLLBACK TO create_opttrips_request;
845: x_return_status := fnd_api.g_ret_sts_unexp_error;
846: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
842: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
843: WHEN fnd_api.g_exc_unexpected_error THEN
844: ROLLBACK TO create_opttrips_request;
845: x_return_status := fnd_api.g_ret_sts_unexp_error;
846: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
847: WHEN OTHERS THEN
848: ROLLBACK TO create_opttrips_request;
849: x_return_status := fnd_api.g_ret_sts_unexp_error;
850:
847: WHEN OTHERS THEN
848: ROLLBACK TO create_opttrips_request;
849: x_return_status := fnd_api.g_ret_sts_unexp_error;
850:
851: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
852: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
853: END IF;
854: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
855: END create_multi_trips_request;
848: ROLLBACK TO create_opttrips_request;
849: x_return_status := fnd_api.g_ret_sts_unexp_error;
850:
851: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
852: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
853: END IF;
854: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
855: END create_multi_trips_request;
856: END csf_requests_pvt;
850:
851: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
852: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
853: END IF;
854: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
855: END create_multi_trips_request;
856: END csf_requests_pvt;