eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSR_SCHEDULER_PVT dependencies on FND_MSG_PUB

Line 23: fnd_msg_pub.ADD;

19: IF p_arg_value IS NULL THEN
20: fnd_message.set_name('CSR', 'CSR_MANDATORY_FIELD_MISSING');
21: fnd_message.set_token('FIELD', p_arg_name);
22: fnd_message.set_token('TASK', p_api_name);
23: fnd_msg_pub.ADD;
24: RETURN FALSE;
25: END IF;
26: RETURN TRUE;
27: END valid_argument;

Line 105: fnd_msg_pub.initialize;

101: RAISE fnd_api.g_exc_unexpected_error;
102: END IF;
103:
104: IF fnd_api.to_boolean(p_init_msg_list) THEN
105: fnd_msg_pub.initialize;
106: END IF;
107:
108: x_return_status := fnd_api.g_ret_sts_success;
109:

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

174: END IF;
175: EXCEPTION
176: WHEN fnd_api.g_exc_error THEN
177: x_return_status := fnd_api.g_ret_sts_error;
178: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
179: WHEN fnd_api.g_exc_unexpected_error THEN
180: x_return_status := fnd_api.g_ret_sts_unexp_error;
181: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
182: WHEN OTHERS THEN

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

177: x_return_status := fnd_api.g_ret_sts_error;
178: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
179: WHEN fnd_api.g_exc_unexpected_error THEN
180: x_return_status := fnd_api.g_ret_sts_unexp_error;
181: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
182: WHEN OTHERS THEN
183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
185: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

180: x_return_status := fnd_api.g_ret_sts_unexp_error;
181: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
182: WHEN OTHERS THEN
183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
185: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
186: END IF;
187: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
188: END get_geometry;

Line 185: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

181: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
182: WHEN OTHERS THEN
183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
185: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
186: END IF;
187: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
188: END get_geometry;
189:

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

183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
185: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
186: END IF;
187: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
188: END get_geometry;
189:
190: /**
191: * Gets the Server Timezone configured in the E-Business Suite

Line 392: fnd_msg_pub.initialize;

388: RAISE fnd_api.g_exc_unexpected_error;
389: END IF;
390:
391: IF fnd_api.to_boolean(p_init_msg_list) THEN
392: fnd_msg_pub.initialize;
393: END IF;
394:
395: x_return_status := fnd_api.g_ret_sts_success;
396:

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

463:
464: EXCEPTION
465: WHEN fnd_api.g_exc_error THEN
466: x_return_status := fnd_api.g_ret_sts_error;
467: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
468: WHEN fnd_api.g_exc_unexpected_error THEN
469: x_return_status := fnd_api.g_ret_sts_unexp_error;
470: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
471: WHEN OTHERS THEN

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

466: x_return_status := fnd_api.g_ret_sts_error;
467: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
468: WHEN fnd_api.g_exc_unexpected_error THEN
469: x_return_status := fnd_api.g_ret_sts_unexp_error;
470: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
471: WHEN OTHERS THEN
472: x_return_status := fnd_api.g_ret_sts_unexp_error;
473: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
474: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 473: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

469: x_return_status := fnd_api.g_ret_sts_unexp_error;
470: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
471: WHEN OTHERS THEN
472: x_return_status := fnd_api.g_ret_sts_unexp_error;
473: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
474: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
475: END IF;
476: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
477: END create_search_request;

Line 474: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

470: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
471: WHEN OTHERS THEN
472: x_return_status := fnd_api.g_ret_sts_unexp_error;
473: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
474: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
475: END IF;
476: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
477: END create_search_request;
478:

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

472: x_return_status := fnd_api.g_ret_sts_unexp_error;
473: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
474: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
475: END IF;
476: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
477: END create_search_request;
478:
479: /**
480: * This API creates a request of type 'ScheduleOption'

Line 516: fnd_msg_pub.initialize;

512: RAISE fnd_api.g_exc_unexpected_error;
513: END IF;
514:
515: IF fnd_api.to_boolean(p_init_msg_list) THEN
516: fnd_msg_pub.initialize;
517: END IF;
518:
519: x_return_status := fnd_api.g_ret_sts_success;
520:

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

542:
543: EXCEPTION
544: WHEN fnd_api.g_exc_error THEN
545: x_return_status := fnd_api.g_ret_sts_error;
546: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
547: WHEN fnd_api.g_exc_unexpected_error THEN
548: x_return_status := fnd_api.g_ret_sts_unexp_error;
549: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
550: WHEN OTHERS THEN

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

545: x_return_status := fnd_api.g_ret_sts_error;
546: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
547: WHEN fnd_api.g_exc_unexpected_error THEN
548: x_return_status := fnd_api.g_ret_sts_unexp_error;
549: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
550: WHEN OTHERS THEN
551: x_return_status := fnd_api.g_ret_sts_unexp_error;
552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
553: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

548: x_return_status := fnd_api.g_ret_sts_unexp_error;
549: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
550: WHEN OTHERS THEN
551: x_return_status := fnd_api.g_ret_sts_unexp_error;
552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
553: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
554: END IF;
555: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
556: END create_schedule_option_request;

Line 553: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

549: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
550: WHEN OTHERS THEN
551: x_return_status := fnd_api.g_ret_sts_unexp_error;
552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
553: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
554: END IF;
555: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
556: END create_schedule_option_request;
557:

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

551: x_return_status := fnd_api.g_ret_sts_unexp_error;
552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
553: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
554: END IF;
555: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
556: END create_schedule_option_request;
557:
558: PROCEDURE create_auto_request(
559: x_return_status OUT NOCOPY VARCHAR2

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

668: END LOOP;
669: EXCEPTION
670: WHEN fnd_api.g_exc_error THEN
671: x_return_status := fnd_api.g_ret_sts_error;
672: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
673: WHEN fnd_api.g_exc_unexpected_error THEN
674: x_return_status := fnd_api.g_ret_sts_unexp_error;
675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
676: WHEN OTHERS THEN

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

671: x_return_status := fnd_api.g_ret_sts_error;
672: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
673: WHEN fnd_api.g_exc_unexpected_error THEN
674: x_return_status := fnd_api.g_ret_sts_unexp_error;
675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
676: WHEN OTHERS THEN
677: x_return_status := fnd_api.g_ret_sts_unexp_error;
678: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
679: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 678: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

674: x_return_status := fnd_api.g_ret_sts_unexp_error;
675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
676: WHEN OTHERS THEN
677: x_return_status := fnd_api.g_ret_sts_unexp_error;
678: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
679: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
680: END IF;
681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
682: END create_auto_request;

Line 679: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
676: WHEN OTHERS THEN
677: x_return_status := fnd_api.g_ret_sts_unexp_error;
678: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
679: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
680: END IF;
681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
682: END create_auto_request;
683:

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

677: x_return_status := fnd_api.g_ret_sts_unexp_error;
678: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
679: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
680: END IF;
681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
682: END create_auto_request;
683:
684: PROCEDURE fill_request_resources(
685: p_api_version IN NUMBER

Line 733: fnd_msg_pub.initialize;

729: RAISE fnd_api.g_exc_unexpected_error;
730: END IF;
731:
732: IF fnd_api.to_boolean(p_init_msg_list) THEN
733: fnd_msg_pub.initialize;
734: END IF;
735:
736: x_return_status := fnd_api.g_ret_sts_success;
737:

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

785: EXCEPTION
786: WHEN fnd_api.g_exc_error THEN
787: ROLLBACK TO fill_request_resources;
788: x_return_status := fnd_api.g_ret_sts_error;
789: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
790: WHEN fnd_api.g_exc_unexpected_error THEN
791: ROLLBACK TO fill_request_resources;
792: x_return_status := fnd_api.g_ret_sts_unexp_error;
793: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

789: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
790: WHEN fnd_api.g_exc_unexpected_error THEN
791: ROLLBACK TO fill_request_resources;
792: x_return_status := fnd_api.g_ret_sts_unexp_error;
793: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
794: WHEN OTHERS THEN
795: x_return_status := fnd_api.g_ret_sts_unexp_error;
796: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
797: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 796: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

792: x_return_status := fnd_api.g_ret_sts_unexp_error;
793: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
794: WHEN OTHERS THEN
795: x_return_status := fnd_api.g_ret_sts_unexp_error;
796: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
797: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
798: END IF;
799: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
800: ROLLBACK TO fill_request_resources;

Line 797: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

793: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
794: WHEN OTHERS THEN
795: x_return_status := fnd_api.g_ret_sts_unexp_error;
796: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
797: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
798: END IF;
799: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
800: ROLLBACK TO fill_request_resources;
801: END fill_request_resources;

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

795: x_return_status := fnd_api.g_ret_sts_unexp_error;
796: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
797: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
798: END IF;
799: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
800: ROLLBACK TO fill_request_resources;
801: END fill_request_resources;
802:
803: PROCEDURE search_and_schedule_auto(

Line 824: fnd_msg_pub.initialize;

820: RAISE fnd_api.g_exc_unexpected_error;
821: END IF;
822:
823: IF fnd_api.to_boolean(p_init_msg_list) THEN
824: fnd_msg_pub.initialize;
825: END IF;
826:
827: x_return_status := fnd_api.g_ret_sts_success;
828:

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

868: EXCEPTION
869: WHEN fnd_api.g_exc_error THEN
870: ROLLBACK TO search_and_schedule_auto_pub;
871: x_return_status := fnd_api.g_ret_sts_error;
872: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
873: WHEN fnd_api.g_exc_unexpected_error THEN
874: ROLLBACK TO search_and_schedule_auto_pub;
875: x_return_status := fnd_api.g_ret_sts_unexp_error;
876: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

872: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
873: WHEN fnd_api.g_exc_unexpected_error THEN
874: ROLLBACK TO search_and_schedule_auto_pub;
875: x_return_status := fnd_api.g_ret_sts_unexp_error;
876: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
877: WHEN OTHERS THEN
878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
880: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 879: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

875: x_return_status := fnd_api.g_ret_sts_unexp_error;
876: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
877: WHEN OTHERS THEN
878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
880: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
881: END IF;
882: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
883: ROLLBACK TO search_and_schedule_auto_pub;

Line 880: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

876: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
877: WHEN OTHERS THEN
878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
880: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
881: END IF;
882: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
883: ROLLBACK TO search_and_schedule_auto_pub;
884: END search_and_schedule_auto;

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

878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
880: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
881: END IF;
882: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
883: ROLLBACK TO search_and_schedule_auto_pub;
884: END search_and_schedule_auto;
885:
886: PROCEDURE create_auto_request(

Line 911: fnd_msg_pub.initialize;

907: RAISE fnd_api.g_exc_error;
908: END IF;
909:
910: IF fnd_api.to_boolean(p_init_msg_list) THEN
911: fnd_msg_pub.initialize;
912: END IF;
913:
914: IF NOT valid_argument(p_query_id, 'query_id', l_api_name) THEN
915: RAISE fnd_api.g_exc_error;

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

954: EXCEPTION
955: WHEN fnd_api.g_exc_error THEN
956: ROLLBACK TO create_auto_request_pub;
957: x_return_status := fnd_api.g_ret_sts_error;
958: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
959: WHEN fnd_api.g_exc_unexpected_error THEN
960: ROLLBACK TO create_auto_request_pub;
961: x_return_status := fnd_api.g_ret_sts_unexp_error;
962: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

958: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
959: WHEN fnd_api.g_exc_unexpected_error THEN
960: ROLLBACK TO create_auto_request_pub;
961: x_return_status := fnd_api.g_ret_sts_unexp_error;
962: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
963: WHEN OTHERS THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
966: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 965: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

961: x_return_status := fnd_api.g_ret_sts_unexp_error;
962: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
963: WHEN OTHERS THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
966: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
967: END IF;
968: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
969: ROLLBACK TO create_auto_request_pub;

Line 966: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

962: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
963: WHEN OTHERS THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
966: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
967: END IF;
968: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
969: ROLLBACK TO create_auto_request_pub;
970: END create_auto_request;

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

964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
966: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
967: END IF;
968: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
969: ROLLBACK TO create_auto_request_pub;
970: END create_auto_request;
971:
972: PROCEDURE create_optimize_trips_request(

Line 1005: fnd_msg_pub.initialize;

1001: RAISE fnd_api.g_exc_error;
1002: END IF;
1003:
1004: IF fnd_api.to_boolean(p_init_msg_list) THEN
1005: fnd_msg_pub.initialize;
1006: END IF;
1007:
1008: OPEN c_resources;
1009: FETCH c_resources BULK COLLECT INTO l_res_id_tbl, l_res_type_tbl;

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

1043: EXCEPTION
1044: WHEN fnd_api.g_exc_error THEN
1045: ROLLBACK TO create_opt_request_pub;
1046: x_return_status := fnd_api.g_ret_sts_error;
1047: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1048: WHEN fnd_api.g_exc_unexpected_error THEN
1049: ROLLBACK TO create_opt_request_pub;
1050: x_return_status := fnd_api.g_ret_sts_unexp_error;
1051: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1047: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1048: WHEN fnd_api.g_exc_unexpected_error THEN
1049: ROLLBACK TO create_opt_request_pub;
1050: x_return_status := fnd_api.g_ret_sts_unexp_error;
1051: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1052: WHEN OTHERS THEN
1053: x_return_status := fnd_api.g_ret_sts_unexp_error;
1054: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1055: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 1054: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1050: x_return_status := fnd_api.g_ret_sts_unexp_error;
1051: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1052: WHEN OTHERS THEN
1053: x_return_status := fnd_api.g_ret_sts_unexp_error;
1054: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1055: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1056: END IF;
1057: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1058: ROLLBACK TO create_opt_request_pub;

Line 1055: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1051: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1052: WHEN OTHERS THEN
1053: x_return_status := fnd_api.g_ret_sts_unexp_error;
1054: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1055: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1056: END IF;
1057: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1058: ROLLBACK TO create_opt_request_pub;
1059: END create_optimize_trips_request;

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

1053: x_return_status := fnd_api.g_ret_sts_unexp_error;
1054: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1055: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1056: END IF;
1057: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1058: ROLLBACK TO create_opt_request_pub;
1059: END create_optimize_trips_request;
1060:
1061: PROCEDURE get_qualified_resources(

Line 1096: fnd_msg_pub.initialize;

1092: RAISE fnd_api.g_exc_error;
1093: END IF;
1094:
1095: IF fnd_api.to_boolean(p_init_msg_list) THEN
1096: fnd_msg_pub.initialize;
1097: END IF;
1098:
1099: x_return_status := fnd_api.g_ret_sts_success;
1100:

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

1161: END LOOP;
1162: EXCEPTION
1163: WHEN fnd_api.g_exc_error THEN
1164: x_return_status := fnd_api.g_ret_sts_error;
1165: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1166: WHEN fnd_api.g_exc_unexpected_error THEN
1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1169: WHEN OTHERS THEN

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

1164: x_return_status := fnd_api.g_ret_sts_error;
1165: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1166: WHEN fnd_api.g_exc_unexpected_error THEN
1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1169: WHEN OTHERS THEN
1170: x_return_status := fnd_api.g_ret_sts_unexp_error;
1171: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1172: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 1171: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1169: WHEN OTHERS THEN
1170: x_return_status := fnd_api.g_ret_sts_unexp_error;
1171: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1172: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1173: END IF;
1174: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1175: END get_qualified_resources;

Line 1172: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1168: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1169: WHEN OTHERS THEN
1170: x_return_status := fnd_api.g_ret_sts_unexp_error;
1171: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1172: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1173: END IF;
1174: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1175: END get_qualified_resources;
1176:

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

1170: x_return_status := fnd_api.g_ret_sts_unexp_error;
1171: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1172: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1173: END IF;
1174: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1175: END get_qualified_resources;
1176:
1177: FUNCTION check_material_for_task(p_task_assignment_id IN NUMBER)
1178: RETURN VARCHAR2 IS

Line 1299: fnd_msg_pub.initialize;

1295: RAISE fnd_api.g_exc_error;
1296: END IF;
1297:
1298: IF fnd_api.to_boolean(p_init_msg_list) THEN
1299: fnd_msg_pub.initialize;
1300: END IF;
1301:
1302: x_return_status := fnd_api.g_ret_sts_success;
1303:

Line 1325: fnd_msg_pub.ADD;

1321: END LOOP;
1322:
1323: IF NOT l_objects_locked THEN
1324: fnd_message.set_name ('CSR', 'CSR_LOCKING_RES_TRIPS_FAILED');
1325: fnd_msg_pub.ADD;
1326: RAISE fnd_api.g_exc_error;
1327: END IF;
1328:
1329: EXCEPTION

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

1328:
1329: EXCEPTION
1330: WHEN fnd_api.g_exc_error THEN
1331: x_return_status := fnd_api.g_ret_sts_error;
1332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1333: WHEN OTHERS THEN
1334: x_return_status := fnd_api.g_ret_sts_unexp_error;
1335: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1336: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 1335: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1331: x_return_status := fnd_api.g_ret_sts_error;
1332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1333: WHEN OTHERS THEN
1334: x_return_status := fnd_api.g_ret_sts_unexp_error;
1335: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1336: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1337: END IF;
1338: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1339: END lock_trips_and_tasks;

Line 1336: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1333: WHEN OTHERS THEN
1334: x_return_status := fnd_api.g_ret_sts_unexp_error;
1335: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1336: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1337: END IF;
1338: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1339: END lock_trips_and_tasks;
1340:

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

1334: x_return_status := fnd_api.g_ret_sts_unexp_error;
1335: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1336: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1337: END IF;
1338: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1339: END lock_trips_and_tasks;
1340:
1341: END csr_scheduler_pvt;