2009: print_debug('task id = ' || x_cascaded_table(n).task_id);
2010: print_debug('parent txn id = ' || x_cascaded_table(n).parent_transaction_id);
2011: END IF;
2012:
2013: x_return_status := fnd_api.g_ret_sts_success;
2014:
2015: SAVEPOINT rcv_transactions_gen_sa;
2016:
2017: -- storing the passed value to match with the parent_txn_id in a local
2832: END IF;
2833:
2834: -- Bug 12732516 -- End
2835:
2836: IF l_return_status = fnd_api.g_ret_sts_error THEN
2837: RAISE fnd_api.g_exc_error;
2838: END IF;
2839: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2840: RAISE fnd_api.g_exc_unexpected_error;
2833:
2834: -- Bug 12732516 -- End
2835:
2836: IF l_return_status = fnd_api.g_ret_sts_error THEN
2837: RAISE fnd_api.g_exc_error;
2838: END IF;
2839: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2840: RAISE fnd_api.g_exc_unexpected_error;
2841: END IF;
2835:
2836: IF l_return_status = fnd_api.g_ret_sts_error THEN
2837: RAISE fnd_api.g_exc_error;
2838: END IF;
2839: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2840: RAISE fnd_api.g_exc_unexpected_error;
2841: END IF;
2842: IF l_po_in_cascaded_table(l_sh_result_count).error_status = 'E' THEN
2843: x_cascaded_table(n).error_status := l_po_in_cascaded_table(l_sh_result_count).error_status;
2836: IF l_return_status = fnd_api.g_ret_sts_error THEN
2837: RAISE fnd_api.g_exc_error;
2838: END IF;
2839: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2840: RAISE fnd_api.g_exc_unexpected_error;
2841: END IF;
2842: IF l_po_in_cascaded_table(l_sh_result_count).error_status = 'E' THEN
2843: x_cascaded_table(n).error_status := l_po_in_cascaded_table(l_sh_result_count).error_status;
2844: x_cascaded_table(n).error_message := l_po_in_cascaded_table(l_sh_result_count).error_message;
3184: fnd_message.set_token('COLUMN', 'Quantity');
3185: fnd_message.set_token('ROI_VALUE',x_cascaded_table(current_n).quantity);
3186: fnd_message.set_token('SYS_VALUE',l_rsl_qty);
3187: fnd_msg_pub.ADD;
3188: RAISE fnd_api.g_exc_error;
3189: END IF;
3190: IF (l_rsl_uom <> x_cascaded_table(current_n).unit_of_measure) THEN
3191: x_cascaded_table(n).error_status := 'E';
3192: x_cascaded_table(n).error_message := 'INV_INVALID_ROI_VALUE';
3199: fnd_message.set_token('COLUMN', 'Uom');
3200: fnd_message.set_token('ROI_VALUE',x_cascaded_table(current_n).unit_of_measure);
3201: fnd_message.set_token('SYS_VALUE',l_rsl_uom);
3202: fnd_msg_pub.ADD;
3203: RAISE fnd_api.g_exc_error;
3204: END IF;
3205: END IF;
3206: END IF;
3207: END IF;
3730:
3731:
3732:
3733: EXCEPTION
3734: WHEN fnd_api.g_exc_error THEN
3735: ROLLBACK TO rcv_transactions_gen_sa;
3736: x_return_status := fnd_api.g_ret_sts_error;
3737:
3738: -- Get message count and data
3732:
3733: EXCEPTION
3734: WHEN fnd_api.g_exc_error THEN
3735: ROLLBACK TO rcv_transactions_gen_sa;
3736: x_return_status := fnd_api.g_ret_sts_error;
3737:
3738: -- Get message count and data
3739: fnd_msg_pub.count_and_get
3740: ( p_count => x_msg_count
3814: IF count_asn_delivery_lines%isopen THEN
3815: CLOSE count_int_req_delivery_lines;
3816: END IF;
3817:
3818: WHEN fnd_api.g_exc_unexpected_error THEN
3819: ROLLBACK TO rcv_transactions_gen_sa;
3820: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3821:
3822: -- Get message count and data
3816: END IF;
3817:
3818: WHEN fnd_api.g_exc_unexpected_error THEN
3819: ROLLBACK TO rcv_transactions_gen_sa;
3820: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3821:
3822: -- Get message count and data
3823: fnd_msg_pub.count_and_get
3824: ( p_count => x_msg_count
3888: END IF;
3889:
3890: WHEN OTHERS THEN
3891: ROLLBACK TO rcv_transactions_gen_sa;
3892: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3893:
3894: IF SQLCODE IS NOT NULL THEN
3895: inv_mobile_helper_functions.sql_error('inv_rcv_txn_match.matching_logic', l_progress, SQLCODE);
3896: END IF;