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 26: fnd_msg_pub.ADD;

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

Line 112: fnd_msg_pub.initialize;

108: RAISE fnd_api.g_exc_unexpected_error;
109: END IF;
110:
111: IF fnd_api.to_boolean(p_init_msg_list) THEN
112: fnd_msg_pub.initialize;
113: END IF;
114:
115: x_return_status := fnd_api.g_ret_sts_success;
116:

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

186: END IF;
187: EXCEPTION
188: WHEN fnd_api.g_exc_error THEN
189: x_return_status := fnd_api.g_ret_sts_error;
190: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
191: WHEN fnd_api.g_exc_unexpected_error THEN
192: x_return_status := fnd_api.g_ret_sts_unexp_error;
193: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
194: WHEN OTHERS THEN

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

189: x_return_status := fnd_api.g_ret_sts_error;
190: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
191: WHEN fnd_api.g_exc_unexpected_error THEN
192: x_return_status := fnd_api.g_ret_sts_unexp_error;
193: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
194: WHEN OTHERS THEN
195: x_return_status := fnd_api.g_ret_sts_unexp_error;
196: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
197: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

192: x_return_status := fnd_api.g_ret_sts_unexp_error;
193: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
194: WHEN OTHERS THEN
195: x_return_status := fnd_api.g_ret_sts_unexp_error;
196: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
197: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
198: END IF;
199: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
200: END get_geometry;

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

193: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
194: WHEN OTHERS THEN
195: x_return_status := fnd_api.g_ret_sts_unexp_error;
196: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
197: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
198: END IF;
199: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
200: END get_geometry;
201:

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

195: x_return_status := fnd_api.g_ret_sts_unexp_error;
196: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
197: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
198: END IF;
199: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
200: END get_geometry;
201:
202: /**
203: * Gets the Server Timezone configured in the E-Business Suite

Line 406: fnd_msg_pub.initialize;

402: RAISE fnd_api.g_exc_unexpected_error;
403: END IF;
404:
405: IF fnd_api.to_boolean(p_init_msg_list) THEN
406: fnd_msg_pub.initialize;
407: END IF;
408:
409: x_return_status := fnd_api.g_ret_sts_success;
410:

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

479:
480: EXCEPTION
481: WHEN fnd_api.g_exc_error THEN
482: x_return_status := fnd_api.g_ret_sts_error;
483: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
484: WHEN fnd_api.g_exc_unexpected_error THEN
485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
487: WHEN OTHERS THEN

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

482: x_return_status := fnd_api.g_ret_sts_error;
483: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
484: WHEN fnd_api.g_exc_unexpected_error THEN
485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
487: WHEN OTHERS THEN
488: x_return_status := fnd_api.g_ret_sts_unexp_error;
489: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
490: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
487: WHEN OTHERS THEN
488: x_return_status := fnd_api.g_ret_sts_unexp_error;
489: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
490: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
491: END IF;
492: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
493: END create_search_request;

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

486: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
487: WHEN OTHERS THEN
488: x_return_status := fnd_api.g_ret_sts_unexp_error;
489: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
490: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
491: END IF;
492: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
493: END create_search_request;
494:

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

488: x_return_status := fnd_api.g_ret_sts_unexp_error;
489: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
490: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
491: END IF;
492: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
493: END create_search_request;
494:
495: /**
496: * This API creates a request of type 'ScheduleOption'

Line 532: fnd_msg_pub.initialize;

528: RAISE fnd_api.g_exc_unexpected_error;
529: END IF;
530:
531: IF fnd_api.to_boolean(p_init_msg_list) THEN
532: fnd_msg_pub.initialize;
533: END IF;
534:
535: x_return_status := fnd_api.g_ret_sts_success;
536:

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

558:
559: EXCEPTION
560: WHEN fnd_api.g_exc_error THEN
561: x_return_status := fnd_api.g_ret_sts_error;
562: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
563: WHEN fnd_api.g_exc_unexpected_error THEN
564: x_return_status := fnd_api.g_ret_sts_unexp_error;
565: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
566: WHEN OTHERS THEN

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

561: x_return_status := fnd_api.g_ret_sts_error;
562: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
563: WHEN fnd_api.g_exc_unexpected_error THEN
564: x_return_status := fnd_api.g_ret_sts_unexp_error;
565: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
566: WHEN OTHERS THEN
567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
569: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

564: x_return_status := fnd_api.g_ret_sts_unexp_error;
565: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
566: WHEN OTHERS THEN
567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
569: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
570: END IF;
571: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
572: END create_schedule_option_request;

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

565: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
566: WHEN OTHERS THEN
567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
569: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
570: END IF;
571: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
572: END create_schedule_option_request;
573:

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

567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
569: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
570: END IF;
571: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
572: END create_schedule_option_request;
573:
574: PROCEDURE create_auto_request(
575: x_return_status OUT NOCOPY VARCHAR2

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

683: END LOOP;
684: EXCEPTION
685: WHEN fnd_api.g_exc_error THEN
686: x_return_status := fnd_api.g_ret_sts_error;
687: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
688: WHEN fnd_api.g_exc_unexpected_error THEN
689: x_return_status := fnd_api.g_ret_sts_unexp_error;
690: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
691: WHEN OTHERS THEN

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

686: x_return_status := fnd_api.g_ret_sts_error;
687: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
688: WHEN fnd_api.g_exc_unexpected_error THEN
689: x_return_status := fnd_api.g_ret_sts_unexp_error;
690: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
691: WHEN OTHERS THEN
692: x_return_status := fnd_api.g_ret_sts_unexp_error;
693: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
694: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

689: x_return_status := fnd_api.g_ret_sts_unexp_error;
690: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
691: WHEN OTHERS THEN
692: x_return_status := fnd_api.g_ret_sts_unexp_error;
693: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
694: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
695: END IF;
696: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
697: END create_auto_request;

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

690: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
691: WHEN OTHERS THEN
692: x_return_status := fnd_api.g_ret_sts_unexp_error;
693: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
694: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
695: END IF;
696: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
697: END create_auto_request;
698:

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

692: x_return_status := fnd_api.g_ret_sts_unexp_error;
693: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
694: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
695: END IF;
696: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
697: END create_auto_request;
698:
699: PROCEDURE fill_request_resources(
700: p_api_version IN NUMBER

Line 759: fnd_msg_pub.initialize;

755: RAISE fnd_api.g_exc_unexpected_error;
756: END IF;
757:
758: IF fnd_api.to_boolean(p_init_msg_list) THEN
759: fnd_msg_pub.initialize;
760: END IF;
761:
762: x_return_status := fnd_api.g_ret_sts_success;
763:

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

850: EXCEPTION
851: WHEN fnd_api.g_exc_error THEN
852: ROLLBACK TO fill_request_resources;
853: x_return_status := fnd_api.g_ret_sts_error;
854: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
855: WHEN fnd_api.g_exc_unexpected_error THEN
856: ROLLBACK TO fill_request_resources;
857: x_return_status := fnd_api.g_ret_sts_unexp_error;
858: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

854: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
855: WHEN fnd_api.g_exc_unexpected_error THEN
856: ROLLBACK TO fill_request_resources;
857: x_return_status := fnd_api.g_ret_sts_unexp_error;
858: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
859: WHEN OTHERS THEN
860: x_return_status := fnd_api.g_ret_sts_unexp_error;
861: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
862: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

857: x_return_status := fnd_api.g_ret_sts_unexp_error;
858: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
859: WHEN OTHERS THEN
860: x_return_status := fnd_api.g_ret_sts_unexp_error;
861: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
862: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
863: END IF;
864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
865: ROLLBACK TO fill_request_resources;

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

858: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
859: WHEN OTHERS THEN
860: x_return_status := fnd_api.g_ret_sts_unexp_error;
861: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
862: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
863: END IF;
864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
865: ROLLBACK TO fill_request_resources;
866: END fill_request_resources;

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

860: x_return_status := fnd_api.g_ret_sts_unexp_error;
861: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
862: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
863: END IF;
864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
865: ROLLBACK TO fill_request_resources;
866: END fill_request_resources;
867:
868: PROCEDURE search_and_schedule_auto(

Line 889: fnd_msg_pub.initialize;

885: RAISE fnd_api.g_exc_unexpected_error;
886: END IF;
887:
888: IF fnd_api.to_boolean(p_init_msg_list) THEN
889: fnd_msg_pub.initialize;
890: END IF;
891:
892: x_return_status := fnd_api.g_ret_sts_success;
893:

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

933: EXCEPTION
934: WHEN fnd_api.g_exc_error THEN
935: ROLLBACK TO search_and_schedule_auto_pub;
936: x_return_status := fnd_api.g_ret_sts_error;
937: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
938: WHEN fnd_api.g_exc_unexpected_error THEN
939: ROLLBACK TO search_and_schedule_auto_pub;
940: x_return_status := fnd_api.g_ret_sts_unexp_error;
941: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

937: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
938: WHEN fnd_api.g_exc_unexpected_error THEN
939: ROLLBACK TO search_and_schedule_auto_pub;
940: x_return_status := fnd_api.g_ret_sts_unexp_error;
941: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
942: WHEN OTHERS THEN
943: x_return_status := fnd_api.g_ret_sts_unexp_error;
944: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
945: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

940: x_return_status := fnd_api.g_ret_sts_unexp_error;
941: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
942: WHEN OTHERS THEN
943: x_return_status := fnd_api.g_ret_sts_unexp_error;
944: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
945: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
946: END IF;
947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
948: ROLLBACK TO search_and_schedule_auto_pub;

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

941: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
942: WHEN OTHERS THEN
943: x_return_status := fnd_api.g_ret_sts_unexp_error;
944: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
945: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
946: END IF;
947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
948: ROLLBACK TO search_and_schedule_auto_pub;
949: END search_and_schedule_auto;

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

943: x_return_status := fnd_api.g_ret_sts_unexp_error;
944: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
945: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
946: END IF;
947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
948: ROLLBACK TO search_and_schedule_auto_pub;
949: END search_and_schedule_auto;
950:
951: PROCEDURE create_auto_request(

Line 976: fnd_msg_pub.initialize;

972: RAISE fnd_api.g_exc_error;
973: END IF;
974:
975: IF fnd_api.to_boolean(p_init_msg_list) THEN
976: fnd_msg_pub.initialize;
977: END IF;
978:
979: IF NOT valid_argument(p_query_id, 'query_id', l_api_name) THEN
980: RAISE fnd_api.g_exc_error;

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

1019: EXCEPTION
1020: WHEN fnd_api.g_exc_error THEN
1021: ROLLBACK TO create_auto_request_pub;
1022: x_return_status := fnd_api.g_ret_sts_error;
1023: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1024: WHEN fnd_api.g_exc_unexpected_error THEN
1025: ROLLBACK TO create_auto_request_pub;
1026: x_return_status := fnd_api.g_ret_sts_unexp_error;
1027: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1023: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1024: WHEN fnd_api.g_exc_unexpected_error THEN
1025: ROLLBACK TO create_auto_request_pub;
1026: x_return_status := fnd_api.g_ret_sts_unexp_error;
1027: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1028: WHEN OTHERS THEN
1029: x_return_status := fnd_api.g_ret_sts_unexp_error;
1030: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1031: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

1026: x_return_status := fnd_api.g_ret_sts_unexp_error;
1027: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1028: WHEN OTHERS THEN
1029: x_return_status := fnd_api.g_ret_sts_unexp_error;
1030: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1031: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1032: END IF;
1033: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1034: ROLLBACK TO create_auto_request_pub;

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

1027: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1028: WHEN OTHERS THEN
1029: x_return_status := fnd_api.g_ret_sts_unexp_error;
1030: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1031: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1032: END IF;
1033: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1034: ROLLBACK TO create_auto_request_pub;
1035: END create_auto_request;

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

1029: x_return_status := fnd_api.g_ret_sts_unexp_error;
1030: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1031: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1032: END IF;
1033: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1034: ROLLBACK TO create_auto_request_pub;
1035: END create_auto_request;
1036:
1037: PROCEDURE create_optimize_trips_request(

Line 1078: fnd_msg_pub.initialize;

1074: RAISE fnd_api.g_exc_error;
1075: END IF;
1076:
1077: IF fnd_api.to_boolean(p_init_msg_list) THEN
1078: fnd_msg_pub.initialize;
1079: END IF;
1080:
1081: OPEN c_resources;
1082: FETCH c_resources BULK COLLECT INTO l_res_id_tbl, l_res_type_tbl, l_res_terrid_tbl;

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

1117: EXCEPTION
1118: WHEN fnd_api.g_exc_error THEN
1119: ROLLBACK TO create_opt_request_pub;
1120: x_return_status := fnd_api.g_ret_sts_error;
1121: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1122: WHEN fnd_api.g_exc_unexpected_error THEN
1123: ROLLBACK TO create_opt_request_pub;
1124: x_return_status := fnd_api.g_ret_sts_unexp_error;
1125: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1121: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1122: WHEN fnd_api.g_exc_unexpected_error THEN
1123: ROLLBACK TO create_opt_request_pub;
1124: x_return_status := fnd_api.g_ret_sts_unexp_error;
1125: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1126: WHEN OTHERS THEN
1127: x_return_status := fnd_api.g_ret_sts_unexp_error;
1128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1129: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

1124: x_return_status := fnd_api.g_ret_sts_unexp_error;
1125: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1126: WHEN OTHERS THEN
1127: x_return_status := fnd_api.g_ret_sts_unexp_error;
1128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1129: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1130: END IF;
1131: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1132: ROLLBACK TO create_opt_request_pub;

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

1125: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1126: WHEN OTHERS THEN
1127: x_return_status := fnd_api.g_ret_sts_unexp_error;
1128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1129: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1130: END IF;
1131: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1132: ROLLBACK TO create_opt_request_pub;
1133: END create_optimize_trips_request;

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

1127: x_return_status := fnd_api.g_ret_sts_unexp_error;
1128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1129: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1130: END IF;
1131: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1132: ROLLBACK TO create_opt_request_pub;
1133: END create_optimize_trips_request;
1134:
1135: PROCEDURE get_qualified_resources(

Line 1171: fnd_msg_pub.initialize;

1167: RAISE fnd_api.g_exc_error;
1168: END IF;
1169:
1170: IF fnd_api.to_boolean(p_init_msg_list) THEN
1171: fnd_msg_pub.initialize;
1172: END IF;
1173:
1174: x_return_status := fnd_api.g_ret_sts_success;
1175:

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

1242: END LOOP;
1243: EXCEPTION
1244: WHEN fnd_api.g_exc_error THEN
1245: x_return_status := fnd_api.g_ret_sts_error;
1246: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1247: WHEN fnd_api.g_exc_unexpected_error THEN
1248: x_return_status := fnd_api.g_ret_sts_unexp_error;
1249: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1250: WHEN OTHERS THEN

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

1245: x_return_status := fnd_api.g_ret_sts_error;
1246: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1247: WHEN fnd_api.g_exc_unexpected_error THEN
1248: x_return_status := fnd_api.g_ret_sts_unexp_error;
1249: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1250: WHEN OTHERS THEN
1251: x_return_status := fnd_api.g_ret_sts_unexp_error;
1252: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1253: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

1248: x_return_status := fnd_api.g_ret_sts_unexp_error;
1249: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1250: WHEN OTHERS THEN
1251: x_return_status := fnd_api.g_ret_sts_unexp_error;
1252: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1253: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1254: END IF;
1255: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1256: END get_qualified_resources;

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

1249: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1250: WHEN OTHERS THEN
1251: x_return_status := fnd_api.g_ret_sts_unexp_error;
1252: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1253: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1254: END IF;
1255: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1256: END get_qualified_resources;
1257:

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

1251: x_return_status := fnd_api.g_ret_sts_unexp_error;
1252: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1253: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1254: END IF;
1255: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1256: END get_qualified_resources;
1257:
1258: FUNCTION check_material_for_task(p_task_assignment_id IN NUMBER)
1259: RETURN VARCHAR2 IS

Line 1380: fnd_msg_pub.initialize;

1376: RAISE fnd_api.g_exc_error;
1377: END IF;
1378:
1379: IF fnd_api.to_boolean(p_init_msg_list) THEN
1380: fnd_msg_pub.initialize;
1381: END IF;
1382:
1383: x_return_status := fnd_api.g_ret_sts_success;
1384:

Line 1406: fnd_msg_pub.ADD;

1402: END LOOP;
1403:
1404: IF NOT l_objects_locked THEN
1405: fnd_message.set_name ('CSR', 'CSR_LOCKING_RES_TRIPS_FAILED');
1406: fnd_msg_pub.ADD;
1407: RAISE fnd_api.g_exc_error;
1408: END IF;
1409:
1410: EXCEPTION

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

1409:
1410: EXCEPTION
1411: WHEN fnd_api.g_exc_error THEN
1412: x_return_status := fnd_api.g_ret_sts_error;
1413: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1414: WHEN OTHERS THEN
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1417: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

1412: x_return_status := fnd_api.g_ret_sts_error;
1413: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1414: WHEN OTHERS THEN
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1417: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1418: END IF;
1419: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1420: END lock_trips_and_tasks;

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

1413: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1414: WHEN OTHERS THEN
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1417: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1418: END IF;
1419: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1420: END lock_trips_and_tasks;
1421:

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

1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1417: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1418: END IF;
1419: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1420: END lock_trips_and_tasks;
1421:
1422: FUNCTION get_third_party_res_role(
1423: p_resource_id IN NUMBER