eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: rcv_immediate_transaction

Line 545: IF l_return_status = FND_API.g_ret_sts_error THEN

541: x_msg_data => l_msg_data);
542:
543: l_progress := '20';
544:
545: IF l_return_status = FND_API.g_ret_sts_error THEN
546: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_IMMEDIATE_TXN_FAIL');
547: FND_MSG_PUB.ADD;
548: IF (l_debug = 1) THEN
549: 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 549: 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);

545: IF l_return_status = FND_API.g_ret_sts_error THEN
546: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_IMMEDIATE_TXN_FAIL');
547: FND_MSG_PUB.ADD;
548: IF (l_debug = 1) THEN
549: 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);
550: END IF;
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553:

Line 551: RAISE FND_API.G_EXC_ERROR;

547: FND_MSG_PUB.ADD;
548: IF (l_debug = 1) THEN
549: 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);
550: END IF;
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553:
554:
555: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 555: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553:
554:
555: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
556: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_IMMEDIATE_TXN_FAIL');
557: FND_MSG_PUB.ADD;
558: IF (l_debug = 1) THEN
559: 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 559: 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);

555: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
556: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_IMMEDIATE_TXN_FAIL');
557: FND_MSG_PUB.ADD;
558: IF (l_debug = 1) THEN
559: 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);
560: END IF;
561: RAISE FND_API.g_exc_unexpected_error;
562: END IF;
563:

Line 561: RAISE FND_API.g_exc_unexpected_error;

557: FND_MSG_PUB.ADD;
558: IF (l_debug = 1) THEN
559: 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);
560: END IF;
561: RAISE FND_API.g_exc_unexpected_error;
562: END IF;
563:
564: ELSE
565: l_progress := '30';

Line 570: IF l_return_status = FND_API.g_ret_sts_error THEN

566: COMMIT;
567: rcv_online_request(x_return_status => l_return_status,
568: x_msg_data => l_msg_data);
569:
570: IF l_return_status = FND_API.g_ret_sts_error THEN
571: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_ONLINE_TXN_FAIL');
572: FND_MSG_PUB.ADD;
573: IF (l_debug = 1) THEN
574: 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 574: 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);

570: IF l_return_status = FND_API.g_ret_sts_error THEN
571: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_ONLINE_TXN_FAIL');
572: FND_MSG_PUB.ADD;
573: IF (l_debug = 1) THEN
574: 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);
575: END IF;
576: RAISE FND_API.G_EXC_ERROR;
577: END IF;
578:

Line 576: RAISE FND_API.G_EXC_ERROR;

572: FND_MSG_PUB.ADD;
573: IF (l_debug = 1) THEN
574: 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);
575: END IF;
576: RAISE FND_API.G_EXC_ERROR;
577: END IF;
578:
579:
580: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 580: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

576: RAISE FND_API.G_EXC_ERROR;
577: END IF;
578:
579:
580: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
581: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_ONLINE_TXN_FAIL');
582: FND_MSG_PUB.ADD;
583: IF (l_debug = 1) THEN
584: 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 584: 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);

580: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
581: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_ONLINE_TXN_FAIL');
582: FND_MSG_PUB.ADD;
583: IF (l_debug = 1) THEN
584: 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);
585: END IF;
586: RAISE FND_API.g_exc_unexpected_error;
587: END IF;
588:

Line 586: RAISE FND_API.g_exc_unexpected_error;

582: FND_MSG_PUB.ADD;
583: IF (l_debug = 1) THEN
584: 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);
585: END IF;
586: RAISE FND_API.g_exc_unexpected_error;
587: END IF;
588:
589: COMMIT;
590: END IF;

Line 592: IF l_return_status = fnd_api.g_ret_sts_success THEN

588:
589: COMMIT;
590: END IF;
591:
592: IF l_return_status = fnd_api.g_ret_sts_success THEN
593: rcv_print_traveller;
594: END IF;
595: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := '';
596:

Line 598: WHEN fnd_api.g_exc_error THEN

594: END IF;
595: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := '';
596:
597: EXCEPTION
598: WHEN fnd_api.g_exc_error THEN
599: rcv_print_traveller;
600:
601: x_return_status := fnd_api.g_ret_sts_error;
602:

Line 601: x_return_status := fnd_api.g_ret_sts_error;

597: EXCEPTION
598: WHEN fnd_api.g_exc_error THEN
599: rcv_print_traveller;
600:
601: x_return_status := fnd_api.g_ret_sts_error;
602:
603: fnd_msg_pub.count_and_get
604: (p_encoded => FND_API.g_false,
605: p_count => l_msg_count,

Line 604: (p_encoded => FND_API.g_false,

600:
601: x_return_status := fnd_api.g_ret_sts_error;
602:
603: fnd_msg_pub.count_and_get
604: (p_encoded => FND_API.g_false,
605: p_count => l_msg_count,
606: p_data => x_msg_data
607: );
608:

Line 609: WHEN fnd_api.g_exc_unexpected_error THEN

605: p_count => l_msg_count,
606: p_data => x_msg_data
607: );
608:
609: WHEN fnd_api.g_exc_unexpected_error THEN
610: rcv_print_traveller;
611:
612: x_return_status := fnd_api.g_ret_sts_unexp_error ;
613:

Line 612: x_return_status := fnd_api.g_ret_sts_unexp_error ;

608:
609: WHEN fnd_api.g_exc_unexpected_error THEN
610: rcv_print_traveller;
611:
612: x_return_status := fnd_api.g_ret_sts_unexp_error ;
613:
614: fnd_msg_pub.count_and_get
615: (p_encoded => FND_API.g_false,
616: p_count => l_msg_count,

Line 615: (p_encoded => FND_API.g_false,

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

Line 623: x_return_status := fnd_api.g_ret_sts_unexp_error ;

619:
620: WHEN OTHERS THEN
621: rcv_print_traveller;
622:
623: x_return_status := fnd_api.g_ret_sts_unexp_error ;
624:
625: IF SQLCODE IS NOT NULL THEN
626: inv_mobile_helper_functions.sql_error('INV_RCV_MOBILE_PROCESS_TXN.rcv_process_receive_txn', l_progress, SQLCODE);
627: END IF;

Line 629: (p_encoded => FND_API.g_false,

625: IF SQLCODE IS NOT NULL THEN
626: inv_mobile_helper_functions.sql_error('INV_RCV_MOBILE_PROCESS_TXN.rcv_process_receive_txn', l_progress, SQLCODE);
627: END IF;
628: fnd_msg_pub.count_and_get
629: (p_encoded => FND_API.g_false,
630: p_count => l_msg_count,
631: p_data => x_msg_data
632: );
633: