DBA Data[Home] [Help]

APPS.CSF_REQUESTS_PVT dependencies on FND_MSG_PUB

Line 42: fnd_msg_pub.initialize;

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;

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

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

Line 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

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

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

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:

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

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

Line 161: fnd_msg_pub.initialize;

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

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

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

Line 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

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

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

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:

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

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

Line 267: fnd_msg_pub.initialize;

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;

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

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

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

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

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

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

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;

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

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

Line 377: fnd_msg_pub.initialize;

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;

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

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

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

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

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

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

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;

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

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

Line 465: fnd_msg_pub.initialize;

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;

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

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

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

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

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

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

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;

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

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

Line 546: fnd_msg_pub.initialize;

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;

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

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;

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

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

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

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

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;

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

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

Line 648: fnd_msg_pub.initialize;

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;

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

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

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

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

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;

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

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:

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

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

Line 764: fnd_msg_pub.initialize;

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;

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

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

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

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

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;

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

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;

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

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;