DBA Data[Home] [Help]

APPS.WMS_RULE_EXTN_PVT dependencies on FND_MSG_PUB

Line 213: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then

209: if iteminfo%isopen then
210: close iteminfo;
211: end if;
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
214: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
215: end if;
216: fnd_msg_pub.count_and_get( p_count => x_msg_count
217: ,p_data => x_msg_data );

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

210: close iteminfo;
211: end if;
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
214: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
215: end if;
216: fnd_msg_pub.count_and_get( p_count => x_msg_count
217: ,p_data => x_msg_data );
218: If (l_debug = 1) then

Line 216: fnd_msg_pub.count_and_get( p_count => x_msg_count

212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
214: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
215: end if;
216: fnd_msg_pub.count_and_get( p_count => x_msg_count
217: ,p_data => x_msg_data );
218: If (l_debug = 1) then
219: log_error(l_api_name, 'error', 'Error in InitQtyTree - ' || x_msg_data);
220: End if;

Line 384: fnd_msg_pub.initialize;

380:
381: --
382: -- Initialize message list if p_init_msg_list is set to true
383: IF fnd_api.to_boolean(p_init_msg_list) THEN
384: fnd_msg_pub.initialize;
385: END IF;
386:
387: log_procedure(l_api_name, 'start', 'Start suggest_reservations');
388: --

Line 466: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => l_message, p_encoded => 'F');

462: IF ( l_debug = 1 ) THEN
463: log_error(l_api_name, 'Suggest Reservations', 'l_return_status = '|| x_return_status);
464: log_error(l_api_name, 'Suggest Reservations', 'Detailing Failed ');
465: END IF;
466: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => l_message, p_encoded => 'F');
467:
468: IF (x_msg_count = 0) THEN
469: IF ( l_debug = 1) THEN
470: log_error(l_api_name, 'Suggest Reservations', 'no message from detailing engine');

Line 478: l_message := fnd_msg_pub.get(i, 'F');

474: log_error(l_api_name, 'Suggest_Reservations', l_message);
475: END IF;
476: ELSE
477: FOR i IN 1 .. x_msg_count LOOP
478: l_message := fnd_msg_pub.get(i, 'F');
479: IF ( l_debug = 1) THEN
480: log_error(l_api_name, 'Suggest_Reservations', l_message);
481: END IF;
482: END LOOP;

Line 484: fnd_msg_pub.delete_msg();

480: log_error(l_api_name, 'Suggest_Reservations', l_message);
481: END IF;
482: END LOOP;
483:
484: fnd_msg_pub.delete_msg();
485: END IF;
486:
487: ROLLBACK TO suggest_reservations_sa;
488:

Line 491: fnd_msg_pub.ADD;

487: ROLLBACK TO suggest_reservations_sa;
488:
489: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
490: fnd_message.set_token('LINE_NUM', TO_CHAR(p_mo_line_rec.line_number));
491: fnd_msg_pub.ADD;
492: x_msg_count := 1;
493: RAISE fnd_api.g_exc_unexpected_error;
494: END IF;
495:

Line 675: fnd_msg_pub.ADD;

671: IF (l_debug = 1) THEN
672: log_error(l_api_name, 'Suggest_Reservations','expected error in transfer reservation');
673: END IF;
674: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
675: fnd_msg_pub.ADD;
676: RAISE fnd_api.g_exc_error;
677: END IF;
678:
679: -- Return an error if the transfer reservation call failed

Line 685: fnd_msg_pub.ADD;

681: IF (l_debug = 1) THEN
682: log_error(l_api_name, 'Suggest_Reservations','error in transfer reservation');
683: END IF;
684: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
685: fnd_msg_pub.ADD;
686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;
688: IF l_debug = 1 THEN
689: log_event(l_api_name, 'Suggest Reservations', 'After calling transfer from ' || l_orig_reservation.reservation_id || ' to ' || l_new_reservation_id);

Line 723: fnd_msg_pub.ADD;

719: IF (l_debug = 1) THEN
720: log_error(l_api_name, 'Suggest_Reservations','error in update reservation');
721: END IF;
722: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
723: fnd_msg_pub.ADD;
724: RAISE fnd_api.g_exc_unexpected_error;
725: END IF;
726:
727: ELSE -- reservtion ID is null

Line 795: fnd_msg_pub.ADD;

791: IF (l_debug = 1) THEN
792: log_error(l_api_name, 'Process_Reservations','error in create reservation');
793: END IF;
794: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
795: fnd_msg_pub.ADD;
796: RAISE fnd_api.g_exc_unexpected_error;
797: END IF;
798: END IF;
799: END LOOP;

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

825: EXCEPTION
826: WHEN fnd_api.g_exc_error THEN
827: --ROLLBACK TO suggest_reservations_sa;
828: x_return_status := fnd_api.g_ret_sts_error;
829: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
830: IF l_debug = 1 THEN
831: log_error(l_api_name, 'error', 'Error in suggest_reservations - ' || x_msg_data);
832: END IF ;
833: --

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

833: --
834: WHEN fnd_api.g_exc_unexpected_error THEN
835: --ROLLBACK TO suggest_reservations_sa;
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
838: IF l_debug = 1 THEN
839: log_error(l_api_name, 'unexp_error', 'Unexpected error ' || 'in suggest_reservations - ' || x_msg_data);
840: END IF;
841: --

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

842: WHEN OTHERS THEN
843: ROLLBACK TO suggest_reservations_sa;
844: x_return_status := fnd_api.g_ret_sts_unexp_error;
845:
846: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
847: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
848: END IF;
849: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
850: IF l_debug = 1 THEN

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

843: ROLLBACK TO suggest_reservations_sa;
844: x_return_status := fnd_api.g_ret_sts_unexp_error;
845:
846: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
847: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
848: END IF;
849: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
850: IF l_debug = 1 THEN
851: log_error(l_api_name, 'other_error', 'Other error ' || 'in suggest_reservations - ' || x_msg_data);

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

845:
846: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
847: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
848: END IF;
849: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
850: IF l_debug = 1 THEN
851: log_error(l_api_name, 'other_error', 'Other error ' || 'in suggest_reservations - ' || x_msg_data);
852: log_error(l_api_name, 'other_error', 'SQL Error ' || SQLERRM);
853: END IF;