DBA Data[Home] [Help]

APPS.CSF_REQUESTS_PVT dependencies on FND_MSG_PUB

Line 46: fnd_msg_pub.initialize;

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;

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

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);

Line 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

Line 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;

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

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:

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

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

Line 176: fnd_msg_pub.initialize;

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

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

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);

Line 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

Line 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;

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

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:

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

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

Line 287: fnd_msg_pub.initialize;

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;

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

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);

Line 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:

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

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);

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

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;

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

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

Line 399: fnd_msg_pub.initialize;

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;

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

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);

Line 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:

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

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);

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

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;

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

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

Line 487: fnd_msg_pub.initialize;

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;

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

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);

Line 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:

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

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);

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

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;

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

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

Line 568: fnd_msg_pub.initialize;

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;

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

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;

Line 603: 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;
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;

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

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);

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

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;

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

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

Line 678: fnd_msg_pub.initialize;

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;

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

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);

Line 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:

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

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;

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

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:

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

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

Line 824: fnd_msg_pub.initialize;

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;

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

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);

Line 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:

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

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;

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

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;

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

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;