DBA Data[Home] [Help]

APPS.INV_RCV_MOBILE_PROCESS_TXN dependencies on FND_API

Line 120: x_return_status := fnd_api.g_ret_sts_success;

116: IS
117: v_req_id NUMBER;
118: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
119: BEGIN
120: x_return_status := fnd_api.g_ret_sts_success;
121:
122: v_req_id :=
123: fnd_request.submit_request('PO',
124: 'RVCTP',

Line 153: x_return_status := fnd_api.g_ret_sts_error;

149: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
150: NULL, NULL, NULL, NULL, NULL, NULL, NULL);
151:
152: if (v_req_id <= 0 or v_req_id is null) then
153: x_return_status := fnd_api.g_ret_sts_error;
154: x_msg_data := FND_MESSAGE.get;
155: ELSE
156: COMMIT;
157: end if;

Line 168: l_return_status VARCHAR2(5) := fnd_api.g_ret_sts_success;

164: rc NUMBER;
165: l_timeout NUMBER ;
166: l_outcome VARCHAR2(200) := NULL;
167: l_message VARCHAR2(2000) := NULL;
168: l_return_status VARCHAR2(5) := fnd_api.g_ret_sts_success;
169: l_msg_count NUMBER;
170: x_str varchar2(6000) := NULL;
171: DELETE_ROWS BOOLEAN := FALSE;
172: r_val1 varchar2(300) := NULL;

Line 196: x_return_status := fnd_api.g_ret_sts_success;

192: l_progress VARCHAR2(10) := '10';
193: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
194: l_group_id NUMBER := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
195: BEGIN
196: x_return_status := fnd_api.g_ret_sts_success;
197:
198: -- Bug 5046328
199: -- Get the timeout value from profile
200:

Line 260: x_return_status := fnd_api.g_ret_sts_unexp_error;

256: NULL;
257: END;
258:
259: IF (l_outcome = 'ERROR') THEN
260: x_return_status := fnd_api.g_ret_sts_unexp_error;
261: IF (l_debug = 1) THEN
262: print_debug('rcv_online_request 29.99 finished with error at: '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
263: END IF;
264: ELSE

Line 291: x_return_status := fnd_api.g_ret_sts_error;

287:
288: END IF;
289:
290: l_progress := '50';
291: x_return_status := fnd_api.g_ret_sts_error;
292:
293: --x_msg_data := FND_MESSAGE.get;
294:
295: -- Since IF TIMEOUT Happens the Return comes back to client

Line 340: x_return_status := fnd_api.g_ret_sts_error;

336: fnd_msg_pub.ADD;
337: DELETE_ROWS := TRUE;
338: END IF;
339:
340: x_return_status := fnd_api.g_ret_sts_error;
341: --x_msg_data := FND_MESSAGE.get;
342: l_progress := '80';
343:
344: inv_receiving_transaction.txn_complete

Line 409: x_return_status := fnd_api.g_ret_sts_error;

405:
406: DELETE_ROWS := TRUE;
407: END IF;
408:
409: x_return_status := fnd_api.g_ret_sts_error;
410: --x_msg_data := FND_MESSAGE.get;
411:
412: l_progress := '109';
413: inv_receiving_transaction.txn_complete

Line 469: x_return_status := fnd_api.g_ret_sts_unexp_error ;

465: COMMIT;
466:
467: EXCEPTION
468: WHEN OTHERS THEN
469: x_return_status := fnd_api.g_ret_sts_unexp_error ;
470: IF SQLCODE IS NOT NULL THEN
471: inv_mobile_helper_functions.sql_error('INV_RCV_MOBILE_PROCESS_TXN.rcv_online_request', l_progress, SQLCODE);
472: END IF;
473: IF (l_debug = 1) THEN

Line 482: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;

478:
479: PROCEDURE rcv_process_receive_txn(x_return_status OUT nocopy VARCHAR2,
480: x_msg_data OUT nocopy VARCHAR2)
481: IS
482: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;
483: l_msg_count NUMBER;
484: l_msg_data VARCHAR2(400);
485: l_progress VARCHAR2(10);
486: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 488: x_return_status := fnd_api.g_ret_sts_success;

484: l_msg_data VARCHAR2(400);
485: l_progress VARCHAR2(10);
486: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
487: BEGIN
488: x_return_status := fnd_api.g_ret_sts_success;
489: IF (l_debug = 1) THEN
490: print_debug('rcv_process_receive_txn 10: '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
491: END IF;
492: l_progress := '10';

Line 520: --IF l_return_status = FND_API.g_ret_sts_error THEN

516: -- x_return_status ,
517: -- x_msg_data );
518: -- l_progress := '10.1';
519:
520: --IF l_return_status = FND_API.g_ret_sts_error THEN
521: -- FND_MESSAGE.SET_NAME('INV', 'INV_RCV_IMMEDIATE_TXN_FAIL');
522: -- FND_MSG_PUB.ADD;
523: -- IF (l_debug = 1) THEN
524: -- print_debug('rcv_process_receive_txn 10.1: rcv_immediate_transaction RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);

Line 524: -- print_debug('rcv_process_receive_txn 10.1: rcv_immediate_transaction RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);

520: --IF l_return_status = FND_API.g_ret_sts_error THEN
521: -- FND_MESSAGE.SET_NAME('INV', 'INV_RCV_IMMEDIATE_TXN_FAIL');
522: -- FND_MSG_PUB.ADD;
523: -- IF (l_debug = 1) THEN
524: -- print_debug('rcv_process_receive_txn 10.1: rcv_immediate_transaction RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
525: -- END IF;
526: -- RAISE FND_API.G_EXC_ERROR;
527: -- END IF;
528: --

Line 526: -- RAISE FND_API.G_EXC_ERROR;

522: -- FND_MSG_PUB.ADD;
523: -- IF (l_debug = 1) THEN
524: -- print_debug('rcv_process_receive_txn 10.1: rcv_immediate_transaction RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
525: -- END IF;
526: -- RAISE FND_API.G_EXC_ERROR;
527: -- END IF;
528: --
529: -- IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
530: -- FND_MESSAGE.SET_NAME('INV', 'INV_RCV_IMMEDIATE_TXN_FAIL');

Line 529: -- IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

525: -- END IF;
526: -- RAISE FND_API.G_EXC_ERROR;
527: -- END IF;
528: --
529: -- IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
530: -- FND_MESSAGE.SET_NAME('INV', 'INV_RCV_IMMEDIATE_TXN_FAIL');
531: -- FND_MSG_PUB.ADD;
532: -- IF (l_debug = 1) THEN
533: -- print_debug('rcv_process_receive_txn 10.2: rcv_immediate_transaction RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);

Line 533: -- print_debug('rcv_process_receive_txn 10.2: rcv_immediate_transaction RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);

529: -- IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
530: -- FND_MESSAGE.SET_NAME('INV', 'INV_RCV_IMMEDIATE_TXN_FAIL');
531: -- FND_MSG_PUB.ADD;
532: -- IF (l_debug = 1) THEN
533: -- print_debug('rcv_process_receive_txn 10.2: rcv_immediate_transaction RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
534: -- END IF;
535: -- RAISE FND_API.g_exc_unexpected_error;
536: -- END IF;
537: -- ************************************

Line 535: -- RAISE FND_API.g_exc_unexpected_error;

531: -- FND_MSG_PUB.ADD;
532: -- IF (l_debug = 1) THEN
533: -- print_debug('rcv_process_receive_txn 10.2: rcv_immediate_transaction RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
534: -- END IF;
535: -- RAISE FND_API.g_exc_unexpected_error;
536: -- END IF;
537: -- ************************************
538:
539:

Line 554: IF l_return_status = FND_API.g_ret_sts_error THEN

550: x_msg_data => l_msg_data);
551:
552: l_progress := '20';
553:
554: IF l_return_status = FND_API.g_ret_sts_error THEN
555: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_IMMEDIATE_TXN_FAIL');
556: FND_MSG_PUB.ADD;
557: IF (l_debug = 1) THEN
558: print_debug('rcv_process_receive_txn 20.1: rcv_immediate_transaction RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);

Line 558: print_debug('rcv_process_receive_txn 20.1: rcv_immediate_transaction RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);

554: IF l_return_status = FND_API.g_ret_sts_error THEN
555: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_IMMEDIATE_TXN_FAIL');
556: FND_MSG_PUB.ADD;
557: IF (l_debug = 1) THEN
558: print_debug('rcv_process_receive_txn 20.1: rcv_immediate_transaction RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
559: END IF;
560: RAISE FND_API.G_EXC_ERROR;
561: END IF;
562:

Line 560: RAISE FND_API.G_EXC_ERROR;

556: FND_MSG_PUB.ADD;
557: IF (l_debug = 1) THEN
558: print_debug('rcv_process_receive_txn 20.1: rcv_immediate_transaction RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
559: END IF;
560: RAISE FND_API.G_EXC_ERROR;
561: END IF;
562:
563:
564: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 564: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

560: RAISE FND_API.G_EXC_ERROR;
561: END IF;
562:
563:
564: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
565: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_IMMEDIATE_TXN_FAIL');
566: FND_MSG_PUB.ADD;
567: IF (l_debug = 1) THEN
568: print_debug('rcv_process_receive_txn 20.2: rcv_immediate_transaction RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);

Line 568: print_debug('rcv_process_receive_txn 20.2: rcv_immediate_transaction RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);

564: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
565: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_IMMEDIATE_TXN_FAIL');
566: FND_MSG_PUB.ADD;
567: IF (l_debug = 1) THEN
568: print_debug('rcv_process_receive_txn 20.2: rcv_immediate_transaction RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
569: END IF;
570: RAISE FND_API.g_exc_unexpected_error;
571: END IF;
572:

Line 570: RAISE FND_API.g_exc_unexpected_error;

566: FND_MSG_PUB.ADD;
567: IF (l_debug = 1) THEN
568: print_debug('rcv_process_receive_txn 20.2: rcv_immediate_transaction RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
569: END IF;
570: RAISE FND_API.g_exc_unexpected_error;
571: END IF;
572:
573: ELSE
574: l_progress := '30';

Line 579: IF l_return_status = FND_API.g_ret_sts_error THEN

575: COMMIT;
576: rcv_online_request(x_return_status => l_return_status,
577: x_msg_data => l_msg_data);
578:
579: IF l_return_status = FND_API.g_ret_sts_error THEN
580: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_ONLINE_TXN_FAIL');
581: FND_MSG_PUB.ADD;
582: IF (l_debug = 1) THEN
583: print_debug('rcv_process_receive_txn 30.1: rcv_online_request RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);

Line 583: print_debug('rcv_process_receive_txn 30.1: rcv_online_request RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);

579: IF l_return_status = FND_API.g_ret_sts_error THEN
580: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_ONLINE_TXN_FAIL');
581: FND_MSG_PUB.ADD;
582: IF (l_debug = 1) THEN
583: print_debug('rcv_process_receive_txn 30.1: rcv_online_request RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
584: END IF;
585: RAISE FND_API.G_EXC_ERROR;
586: END IF;
587:

Line 585: RAISE FND_API.G_EXC_ERROR;

581: FND_MSG_PUB.ADD;
582: IF (l_debug = 1) THEN
583: print_debug('rcv_process_receive_txn 30.1: rcv_online_request RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
584: END IF;
585: RAISE FND_API.G_EXC_ERROR;
586: END IF;
587:
588:
589: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 589: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

585: RAISE FND_API.G_EXC_ERROR;
586: END IF;
587:
588:
589: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
590: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_ONLINE_TXN_FAIL');
591: FND_MSG_PUB.ADD;
592: IF (l_debug = 1) THEN
593: print_debug('rcv_process_receive_txn 30.2: rcv_online_request RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);

Line 593: print_debug('rcv_process_receive_txn 30.2: rcv_online_request RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);

589: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
590: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_ONLINE_TXN_FAIL');
591: FND_MSG_PUB.ADD;
592: IF (l_debug = 1) THEN
593: print_debug('rcv_process_receive_txn 30.2: rcv_online_request RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
594: END IF;
595: RAISE FND_API.g_exc_unexpected_error;
596: END IF;
597:

Line 595: RAISE FND_API.g_exc_unexpected_error;

591: FND_MSG_PUB.ADD;
592: IF (l_debug = 1) THEN
593: print_debug('rcv_process_receive_txn 30.2: rcv_online_request RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
594: END IF;
595: RAISE FND_API.g_exc_unexpected_error;
596: END IF;
597:
598: COMMIT;
599: END IF;

Line 601: IF l_return_status = fnd_api.g_ret_sts_success THEN

597:
598: COMMIT;
599: END IF;
600:
601: IF l_return_status = fnd_api.g_ret_sts_success THEN
602: rcv_print_traveller;
603: END IF;
604: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := '';
605:

Line 607: WHEN fnd_api.g_exc_error THEN

603: END IF;
604: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := '';
605:
606: EXCEPTION
607: WHEN fnd_api.g_exc_error THEN
608: rcv_print_traveller;
609:
610: x_return_status := fnd_api.g_ret_sts_error;
611:

Line 610: x_return_status := fnd_api.g_ret_sts_error;

606: EXCEPTION
607: WHEN fnd_api.g_exc_error THEN
608: rcv_print_traveller;
609:
610: x_return_status := fnd_api.g_ret_sts_error;
611:
612: fnd_msg_pub.count_and_get
613: (p_encoded => FND_API.g_false,
614: p_count => l_msg_count,

Line 613: (p_encoded => FND_API.g_false,

609:
610: x_return_status := fnd_api.g_ret_sts_error;
611:
612: fnd_msg_pub.count_and_get
613: (p_encoded => FND_API.g_false,
614: p_count => l_msg_count,
615: p_data => x_msg_data
616: );
617:

Line 618: WHEN fnd_api.g_exc_unexpected_error THEN

614: p_count => l_msg_count,
615: p_data => x_msg_data
616: );
617:
618: WHEN fnd_api.g_exc_unexpected_error THEN
619: rcv_print_traveller;
620:
621: x_return_status := fnd_api.g_ret_sts_unexp_error ;
622:

Line 621: x_return_status := fnd_api.g_ret_sts_unexp_error ;

617:
618: WHEN fnd_api.g_exc_unexpected_error THEN
619: rcv_print_traveller;
620:
621: x_return_status := fnd_api.g_ret_sts_unexp_error ;
622:
623: fnd_msg_pub.count_and_get
624: (p_encoded => FND_API.g_false,
625: p_count => l_msg_count,

Line 624: (p_encoded => FND_API.g_false,

620:
621: x_return_status := fnd_api.g_ret_sts_unexp_error ;
622:
623: fnd_msg_pub.count_and_get
624: (p_encoded => FND_API.g_false,
625: p_count => l_msg_count,
626: p_data => x_msg_data
627: );
628:

Line 632: x_return_status := fnd_api.g_ret_sts_unexp_error ;

628:
629: WHEN OTHERS THEN
630: rcv_print_traveller;
631:
632: x_return_status := fnd_api.g_ret_sts_unexp_error ;
633:
634: IF SQLCODE IS NOT NULL THEN
635: inv_mobile_helper_functions.sql_error('INV_RCV_MOBILE_PROCESS_TXN.rcv_process_receive_txn', l_progress, SQLCODE);
636: END IF;

Line 638: (p_encoded => FND_API.g_false,

634: IF SQLCODE IS NOT NULL THEN
635: inv_mobile_helper_functions.sql_error('INV_RCV_MOBILE_PROCESS_TXN.rcv_process_receive_txn', l_progress, SQLCODE);
636: END IF;
637: fnd_msg_pub.count_and_get
638: (p_encoded => FND_API.g_false,
639: p_count => l_msg_count,
640: p_data => x_msg_data
641: );
642:

Line 757: IF x_return_status = fnd_api.g_ret_sts_error THEN

753: , x_msg_count => l_msg_count
754: , x_msg_data => l_msg_data
755: , x_sequence => l_sequence
756: );
757: IF x_return_status = fnd_api.g_ret_sts_error THEN
758: RAISE fnd_api.g_exc_error;
759: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
760: RAISE fnd_api.g_exc_unexpected_error;
761: ELSE

Line 758: RAISE fnd_api.g_exc_error;

754: , x_msg_data => l_msg_data
755: , x_sequence => l_sequence
756: );
757: IF x_return_status = fnd_api.g_ret_sts_error THEN
758: RAISE fnd_api.g_exc_error;
759: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
760: RAISE fnd_api.g_exc_unexpected_error;
761: ELSE
762: l_return_status:= fnd_api.g_ret_sts_success;

Line 759: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

755: , x_sequence => l_sequence
756: );
757: IF x_return_status = fnd_api.g_ret_sts_error THEN
758: RAISE fnd_api.g_exc_error;
759: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
760: RAISE fnd_api.g_exc_unexpected_error;
761: ELSE
762: l_return_status:= fnd_api.g_ret_sts_success;
763: END IF;

Line 760: RAISE fnd_api.g_exc_unexpected_error;

756: );
757: IF x_return_status = fnd_api.g_ret_sts_error THEN
758: RAISE fnd_api.g_exc_error;
759: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
760: RAISE fnd_api.g_exc_unexpected_error;
761: ELSE
762: l_return_status:= fnd_api.g_ret_sts_success;
763: END IF;
764: END IF;

Line 762: l_return_status:= fnd_api.g_ret_sts_success;

758: RAISE fnd_api.g_exc_error;
759: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
760: RAISE fnd_api.g_exc_unexpected_error;
761: ELSE
762: l_return_status:= fnd_api.g_ret_sts_success;
763: END IF;
764: END IF;
765:
766: x_return_status:= l_return_status;

Line 770: WHEN fnd_api.g_exc_error THEN

766: x_return_status:= l_return_status;
767:
768:
769: EXCEPTION
770: WHEN fnd_api.g_exc_error THEN
771: x_return_status := fnd_api.g_ret_sts_error;
772:
773: WHEN fnd_api.g_exc_unexpected_error THEN
774: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 771: x_return_status := fnd_api.g_ret_sts_error;

767:
768:
769: EXCEPTION
770: WHEN fnd_api.g_exc_error THEN
771: x_return_status := fnd_api.g_ret_sts_error;
772:
773: WHEN fnd_api.g_exc_unexpected_error THEN
774: x_return_status := fnd_api.g_ret_sts_unexp_error ;
775:

Line 773: WHEN fnd_api.g_exc_unexpected_error THEN

769: EXCEPTION
770: WHEN fnd_api.g_exc_error THEN
771: x_return_status := fnd_api.g_ret_sts_error;
772:
773: WHEN fnd_api.g_exc_unexpected_error THEN
774: x_return_status := fnd_api.g_ret_sts_unexp_error ;
775:
776: END lot_uom_conversion;
777: PROCEDURE check_existing_lot

Line 774: x_return_status := fnd_api.g_ret_sts_unexp_error ;

770: WHEN fnd_api.g_exc_error THEN
771: x_return_status := fnd_api.g_ret_sts_error;
772:
773: WHEN fnd_api.g_exc_unexpected_error THEN
774: x_return_status := fnd_api.g_ret_sts_unexp_error ;
775:
776: END lot_uom_conversion;
777: PROCEDURE check_existing_lot
778: ( p_org_id IN NUMBER

Line 835: x_return_status := fnd_api.g_ret_sts_success;

831: ELSE
832: x_lot_exist := 0;
833: END IF;
834: END IF;
835: x_return_status := fnd_api.g_ret_sts_success;
836: END check_existing_lot;
837: --end of 8539263 changes
838: END INV_RCV_MOBILE_PROCESS_TXN;
839: