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 425: fnd_msg_pub.initialize;

421:
422: --
423: -- Initialize message list if p_init_msg_list is set to true
424: IF fnd_api.to_boolean(p_init_msg_list) THEN
425: fnd_msg_pub.initialize;
426: END IF;
427:
428: log_procedure(l_api_name, 'start', 'Start suggest_reservations');
429: --

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

599: IF ( l_debug = 1 ) THEN
600: log_error(l_api_name, 'Suggest_Reservations', 'l_return_status = '|| x_return_status);
601: log_error(l_api_name, 'Suggest_Reservations', 'Detailing Failed ');
602: END IF;
603: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => l_message, p_encoded => 'F');
604:
605: IF (x_msg_count = 0) THEN
606: IF ( l_debug = 1) THEN
607: log_error(l_api_name, 'Suggest_Reservations', 'no message from detailing engine');

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

611: log_error(l_api_name, 'Suggest_Reservations', l_message);
612: END IF;
613: ELSE
614: FOR i IN 1 .. x_msg_count LOOP
615: l_message := fnd_msg_pub.get(i, 'F');
616: IF ( l_debug = 1) THEN
617: log_error(l_api_name, 'Suggest_Reservations', l_message);
618: END IF;
619: END LOOP;

Line 621: fnd_msg_pub.delete_msg();

617: log_error(l_api_name, 'Suggest_Reservations', l_message);
618: END IF;
619: END LOOP;
620:
621: fnd_msg_pub.delete_msg();
622: END IF;
623:
624: ROLLBACK TO suggest_reservations_sa;
625:

Line 628: fnd_msg_pub.ADD;

624: ROLLBACK TO suggest_reservations_sa;
625:
626: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
627: fnd_message.set_token('LINE_NUM', TO_CHAR(p_mo_line_rec.line_number));
628: fnd_msg_pub.ADD;
629: x_msg_count := 1;
630: RAISE fnd_api.g_exc_unexpected_error;
631: END IF;
632:

Line 833: fnd_msg_pub.ADD;

829: IF (l_debug = 1) THEN
830: log_error(l_api_name, 'Suggest_Reservations','expected error in transfer reservation');
831: END IF;
832: fnd_message.set_name('INV', 'INV_TRANSFER_RSV_FAILED');
833: fnd_msg_pub.ADD;
834: RAISE fnd_api.g_exc_error;
835: END IF;
836:
837: -- Return an error if the transfer reservation call failed

Line 843: fnd_msg_pub.ADD;

839: IF (l_debug = 1) THEN
840: log_error(l_api_name, 'Suggest_Reservations','error in transfer reservation');
841: END IF;
842: fnd_message.set_name('INV', 'INV_TRANSFER_RSV_FAILED');
843: fnd_msg_pub.ADD;
844: RAISE fnd_api.g_exc_unexpected_error;
845: END IF;
846: IF l_debug = 1 THEN
847: log_event(l_api_name, 'Suggest_Reservations', 'After calling transfer from ' || l_orig_reservation.reservation_id || ' to ' || l_new_reservation_id);

Line 872: fnd_msg_pub.ADD;

868: IF (l_debug = 1) THEN
869: log_error(l_api_name, 'Suggest_Reservations','error in update reservation');
870: END IF;
871: fnd_message.set_name('INV', 'INV_UPDATE_RSV_FAILED');
872: fnd_msg_pub.ADD;
873: RAISE fnd_api.g_exc_unexpected_error;
874: END IF;
875:
876: END IF; --}

Line 908: fnd_msg_pub.ADD;

904: IF (l_debug = 1) THEN
905: log_error(l_api_name, 'Suggest_Reservations','error in update reservation');
906: END IF;
907: fnd_message.set_name('INV', 'INV_UPDATE_RSV_FAILED');
908: fnd_msg_pub.ADD;
909: RAISE fnd_api.g_exc_unexpected_error;
910: END IF;
911:
912: ELSE -- reservtion ID is null

Line 980: fnd_msg_pub.ADD;

976: IF (l_debug = 1) THEN
977: log_error(l_api_name, 'Suggest_Reservations','error in create reservation');
978: END IF;
979: fnd_message.set_name('INV', 'INV_CREATE_RSV_FAILED');
980: fnd_msg_pub.ADD;
981: RAISE fnd_api.g_exc_unexpected_error;
982: END IF;
983: END IF;
984: END LOOP; --}

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

1044:
1045: WHEN fnd_api.g_exc_error THEN
1046: --ROLLBACK TO suggest_reservations_sa;
1047: x_return_status := fnd_api.g_ret_sts_error;
1048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1049: IF l_debug = 1 THEN
1050: log_error(l_api_name, 'error', 'Error in suggest_reservations - ' || x_msg_data);
1051: END IF ;
1052: --

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

1052: --
1053: WHEN fnd_api.g_exc_unexpected_error THEN
1054: --ROLLBACK TO suggest_reservations_sa;
1055: x_return_status := fnd_api.g_ret_sts_unexp_error;
1056: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1057: IF l_debug = 1 THEN
1058: log_error(l_api_name, 'unexp_error', 'Unexpected error ' || 'in suggest_reservations - ' || x_msg_data);
1059: END IF;
1060: --

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

1061: WHEN OTHERS THEN
1062: ROLLBACK TO suggest_reservations_sa;
1063: x_return_status := fnd_api.g_ret_sts_unexp_error;
1064:
1065: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1066: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1067: END IF;
1068: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1069: IF l_debug = 1 THEN

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

1062: ROLLBACK TO suggest_reservations_sa;
1063: x_return_status := fnd_api.g_ret_sts_unexp_error;
1064:
1065: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1066: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1067: END IF;
1068: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1069: IF l_debug = 1 THEN
1070: log_error(l_api_name, 'other_error', 'Other error ' || 'in suggest_reservations - ' || x_msg_data);

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

1064:
1065: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1066: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1067: END IF;
1068: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1069: IF l_debug = 1 THEN
1070: log_error(l_api_name, 'other_error', 'Other error ' || 'in suggest_reservations - ' || x_msg_data);
1071: log_error(l_api_name, 'other_error', 'SQL Error ' || SQLERRM);
1072: END IF;