APPS.INV_RCV_TXN_MATCH dependencies on FND_API

Line 1812: x_return_status := fnd_api.g_ret_sts_success;

1808: print_debug('task id = ' || x_cascaded_table(n).task_id);
1809: print_debug('parent txn id = ' || x_cascaded_table(n).parent_transaction_id);
1810: END IF;
1811:
1812: x_return_status := fnd_api.g_ret_sts_success;
1813:
1814: SAVEPOINT rcv_transactions_gen_sa;
1815:
1816: -- storing the passed value to match with the parent_txn_id in a local

Line 2573: IF l_return_status = fnd_api.g_ret_sts_error THEN

2569: print_debug('after po matching l_msg_count = '|| l_msg_count, 4);
2570: print_debug('after po matching l_msg_data = '||l_msg_data , 4);
2571: END IF;
2572:
2573: IF l_return_status = fnd_api.g_ret_sts_error THEN
2574: RAISE fnd_api.g_exc_error;
2575: END IF;
2576: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2577: RAISE fnd_api.g_exc_unexpected_error;

Line 2574: RAISE fnd_api.g_exc_error;

2570: print_debug('after po matching l_msg_data = '||l_msg_data , 4);
2571: END IF;
2572:
2573: IF l_return_status = fnd_api.g_ret_sts_error THEN
2574: RAISE fnd_api.g_exc_error;
2575: END IF;
2576: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2577: RAISE fnd_api.g_exc_unexpected_error;
2578: END IF;

Line 2576: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2572:
2573: IF l_return_status = fnd_api.g_ret_sts_error THEN
2574: RAISE fnd_api.g_exc_error;
2575: END IF;
2576: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2577: RAISE fnd_api.g_exc_unexpected_error;
2578: END IF;
2579: IF l_po_in_cascaded_table(l_sh_result_count).error_status = 'E' THEN
2580: x_cascaded_table(n).error_status := l_po_in_cascaded_table(l_sh_result_count).error_status;

Line 2577: RAISE fnd_api.g_exc_unexpected_error;

2573: IF l_return_status = fnd_api.g_ret_sts_error THEN
2574: RAISE fnd_api.g_exc_error;
2575: END IF;
2576: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2577: RAISE fnd_api.g_exc_unexpected_error;
2578: END IF;
2579: IF l_po_in_cascaded_table(l_sh_result_count).error_status = 'E' THEN
2580: x_cascaded_table(n).error_status := l_po_in_cascaded_table(l_sh_result_count).error_status;
2581: x_cascaded_table(n).error_message := l_po_in_cascaded_table(l_sh_result_count).error_message;

Line 3423: WHEN fnd_api.g_exc_error THEN

3419:
3420:
3421:
3422: EXCEPTION
3423: WHEN fnd_api.g_exc_error THEN
3424: ROLLBACK TO rcv_transactions_gen_sa;
3425: x_return_status := fnd_api.g_ret_sts_error;
3426:
3427: -- Get message count and data

Line 3425: x_return_status := fnd_api.g_ret_sts_error;

3421:
3422: EXCEPTION
3423: WHEN fnd_api.g_exc_error THEN
3424: ROLLBACK TO rcv_transactions_gen_sa;
3425: x_return_status := fnd_api.g_ret_sts_error;
3426:
3427: -- Get message count and data
3428: fnd_msg_pub.count_and_get
3429: ( p_count => x_msg_count

Line 3507: WHEN fnd_api.g_exc_unexpected_error THEN

3503: IF count_asn_delivery_lines%isopen THEN
3504: CLOSE count_int_req_delivery_lines;
3505: END IF;
3506:
3507: WHEN fnd_api.g_exc_unexpected_error THEN
3508: ROLLBACK TO rcv_transactions_gen_sa;
3509: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3510:
3511: -- Get message count and data

Line 3509: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3505: END IF;
3506:
3507: WHEN fnd_api.g_exc_unexpected_error THEN
3508: ROLLBACK TO rcv_transactions_gen_sa;
3509: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3510:
3511: -- Get message count and data
3512: fnd_msg_pub.count_and_get
3513: ( p_count => x_msg_count

Line 3581: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3577: END IF;
3578:
3579: WHEN OTHERS THEN
3580: ROLLBACK TO rcv_transactions_gen_sa;
3581: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3582:
3583: IF SQLCODE IS NOT NULL THEN
3584: inv_mobile_helper_functions.sql_error('inv_rcv_txn_match.matching_logic', l_progress, SQLCODE);
3585: END IF;