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 INV_RCV_COMMON_APIS

Line 68: IF Upper(inv_rcv_common_apis.g_po_startup_value.receipt_traveller) = 'Y' THEN -- ?

64:
65: /*
66: ** Check if we need to print receipt traveller
67: */
68: IF Upper(inv_rcv_common_apis.g_po_startup_value.receipt_traveller) = 'Y' THEN -- ?
69: v_qty_precision := fnd_profile.value('REPORT_QUANTITY_PRECISION');
70: v_req_id :=
71: fnd_request.submit_request('PO',
72: 'RCVDLPDT',

Line 76: 'P_group_id=' || inv_rcv_common_apis.g_rcv_global_var.interface_group_id,

72: 'RCVDLPDT',
73: null,
74: null,
75: false,
76: 'P_group_id=' || inv_rcv_common_apis.g_rcv_global_var.interface_group_id,
77: 'P_qty_precision='||v_qty_precision,
78: 'P_org_id=' || inv_rcv_common_apis.g_po_startup_value.inv_org_id,--NULL, --fnd_char.local_chr(0),----bug 5195963
79: NULL,
80: NULL,

Line 78: 'P_org_id=' || inv_rcv_common_apis.g_po_startup_value.inv_org_id,--NULL, --fnd_char.local_chr(0),----bug 5195963

74: null,
75: false,
76: 'P_group_id=' || inv_rcv_common_apis.g_rcv_global_var.interface_group_id,
77: 'P_qty_precision='||v_qty_precision,
78: 'P_org_id=' || inv_rcv_common_apis.g_po_startup_value.inv_org_id,--NULL, --fnd_char.local_chr(0),----bug 5195963
79: NULL,
80: NULL,
81: NULL,
82: NULL,

Line 129: inv_rcv_common_apis.g_rcv_global_var.interface_group_id,

125: null,
126: null,
127: false,
128: 'IMMEDIATE',
129: inv_rcv_common_apis.g_rcv_global_var.interface_group_id,
130: NULL, --fnd_char.local_chr(0), ?
131: NULL,
132: NULL,
133: NULL,

Line 194: l_group_id NUMBER := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

190: r_val19 varchar2(300) := NULL;
191: r_val20 varchar2(300) := NULL;
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

Line 211: print_debug('updating proceesing mode in rti for group id'||inv_rcv_common_apis.g_rcv_global_var.interface_group_id,1);

207: IF (l_debug = 1) THEN
208: print_debug('rcv_online_request - timeout : '|| l_timeout, 1);
209: END IF;
210: Begin
211: print_debug('updating proceesing mode in rti for group id'||inv_rcv_common_apis.g_rcv_global_var.interface_group_id,1);
212: UPDATE RCV_TRANSACTIONS_INTERFACE
213: SET PROCESSING_MODE_CODE = 'ONLINE'
214: WHERE GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
215: AND PROCESSING_MODE_CODE <> 'ONLINE';

Line 214: WHERE GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id

210: Begin
211: print_debug('updating proceesing mode in rti for group id'||inv_rcv_common_apis.g_rcv_global_var.interface_group_id,1);
212: UPDATE RCV_TRANSACTIONS_INTERFACE
213: SET PROCESSING_MODE_CODE = 'ONLINE'
214: WHERE GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
215: AND PROCESSING_MODE_CODE <> 'ONLINE';
216: COMMIT;
217: EXCEPTION
218: WHEN OTHERS THEN

Line 227: 'ONLINE', inv_rcv_common_apis.g_rcv_global_var.interface_group_id,

223:
224: rc := fnd_transaction.synchronous
225: (
226: l_timeout, l_outcome, l_message, 'PO', 'RCVTPO',
227: 'ONLINE', inv_rcv_common_apis.g_rcv_global_var.interface_group_id,
228: NULL, NULL, NULL, NULL, NULL, NULL,
229: NULL, NULL, NULL, NULL, NULL, NULL,
230: NULL, NULL, NULL, NULL, NULL, NULL);
231:

Line 274: IF (check_group_id(inv_rcv_common_apis.g_rcv_global_var.interface_group_id)) THEN

270: l_progress := '40';
271: IF (l_debug = 1) THEN
272: print_debug('rcv_online_request 40 finished with error rc = 1 at: '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
273: END IF;
274: IF (check_group_id(inv_rcv_common_apis.g_rcv_global_var.interface_group_id)) THEN
275: fnd_message.set_name('FND', 'TM-TIMEOUT');
276: --x_str := fnd_message.get;
277: --fnd_message.clear;
278: FND_MESSAGE.set_name('FND','CONC-Error running standalone');

Line 280: fnd_message.set_token('REQUEST', inv_rcv_common_apis.g_rcv_global_var.interface_group_id);

276: --x_str := fnd_message.get;
277: --fnd_message.clear;
278: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
279: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
280: fnd_message.set_token('REQUEST', inv_rcv_common_apis.g_rcv_global_var.interface_group_id);
281: fnd_message.set_token('REASON', x_str);
282: --fnd_message.clear;
283: fnd_msg_pub.ADD;
284:

Line 312: -- (p_group_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id,

308: the timeout value you are using.
309: */
310:
311: -- inv_receiving_transaction.txn_complete
312: -- (p_group_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id,
313: -- p_txn_status => 'FALSE',
314: -- p_txn_mode => 'ONLINE',
315: -- x_return_status => l_return_status,
316: -- x_msg_data => l_message,

Line 327: IF (check_group_id(inv_rcv_common_apis.g_rcv_global_var.interface_group_id)) THEN

323: l_progress := '70';
324: IF (l_debug = 1) THEN
325: print_debug('rcv_online_request 70 finished with error rc = 2 at: '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
326: END IF;
327: IF (check_group_id(inv_rcv_common_apis.g_rcv_global_var.interface_group_id)) THEN
328: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
329: --x_str := fnd_message.get;
330: --fnd_message.clear;
331: FND_MESSAGE.set_name('FND','CONC-Error running standalone');

Line 333: fnd_message.set_token('REQUEST', inv_rcv_common_apis.g_rcv_global_var.interface_group_id);

329: --x_str := fnd_message.get;
330: --fnd_message.clear;
331: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
332: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
333: fnd_message.set_token('REQUEST', inv_rcv_common_apis.g_rcv_global_var.interface_group_id);
334: fnd_message.set_token('REASON', x_str);
335: --fnd_message.clear;
336: fnd_msg_pub.ADD;
337: DELETE_ROWS := TRUE;

Line 345: (p_group_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id,

341: --x_msg_data := FND_MESSAGE.get;
342: l_progress := '80';
343:
344: inv_receiving_transaction.txn_complete
345: (p_group_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id,
346: p_txn_status => 'FALSE',
347: p_txn_mode => 'ONLINE',
348: x_return_status => l_return_status,
349: x_msg_data => l_message,

Line 358: print_debug('rcv_online_request 90 finished with error rc = 3 for:'||inv_rcv_common_apis.g_rcv_global_var.interface_group_id||' AT : '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);

354: so that both the cases of rc=3 or l_outcome warning or error is handled.*/
355: IF (rc = 3 or (l_outcome IN ('WARNING', 'ERROR'))) THEN
356: l_progress := '90';
357: IF (l_debug = 1) THEN
358: print_debug('rcv_online_request 90 finished with error rc = 3 for:'||inv_rcv_common_apis.g_rcv_global_var.interface_group_id||' AT : '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
359: END IF;
360:
361: -- txn_failure_clean_up;
362: IF (check_group_id(inv_rcv_common_apis.g_rcv_global_var.interface_group_id)) THEN

Line 362: IF (check_group_id(inv_rcv_common_apis.g_rcv_global_var.interface_group_id)) THEN

358: print_debug('rcv_online_request 90 finished with error rc = 3 for:'||inv_rcv_common_apis.g_rcv_global_var.interface_group_id||' AT : '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
359: END IF;
360:
361: -- txn_failure_clean_up;
362: IF (check_group_id(inv_rcv_common_apis.g_rcv_global_var.interface_group_id)) THEN
363: IF (l_debug = 1) THEN
364: print_debug('rcv_online_request 90.01 found the group id',4);
365: END IF;
366: l_progress := '95';

Line 414: (p_group_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id,

410: --x_msg_data := FND_MESSAGE.get;
411:
412: l_progress := '109';
413: inv_receiving_transaction.txn_complete
414: (p_group_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id,
415: p_txn_status => 'FALSE',
416: p_txn_mode => 'ONLINE',
417: x_return_status => l_return_status,
418: x_msg_data => l_message,

Line 435: WHERE group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;

431: */
432: /* UPDATE rcv_transactions_interface
433: SET processing_status_code = 'COMPLETED'
434: , transaction_status_code = 'ERROR'
435: WHERE group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;
436: */
437:
438: --No need to delete the record in RTI. FPJ enhancement
439: --delete from rcv_transactions_interface

Line 440: --where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;

436: */
437:
438: --No need to delete the record in RTI. FPJ enhancement
439: --delete from rcv_transactions_interface
440: --where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;
441:
442: /* Bug 4901912 -Deleting the errored RTIs */
443: IF (l_debug = 1) THEN
444: print_debug('INV_RCV_MOBILE_PROCESS_TXN.rcv_online_request in delete rows for group_id:'

Line 445: || inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id,4);

441:
442: /* Bug 4901912 -Deleting the errored RTIs */
443: IF (l_debug = 1) THEN
444: print_debug('INV_RCV_MOBILE_PROCESS_TXN.rcv_online_request in delete rows for group_id:'
445: || inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id,4);
446: END IF;
447:
448: delete from rcv_transactions_interface
449: where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;

Line 449: where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;

445: || inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id,4);
446: END IF;
447:
448: delete from rcv_transactions_interface
449: where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;
450:
451: /* Bug# 6081470
452: * Added code to also delete the rcv_headers_interface records as the
453: * corresponding rcv_transactions_interface records are being deleted above.

Line 457: where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;

453: * corresponding rcv_transactions_interface records are being deleted above.
454: * Hence this becomes an orphan RHI record and there is no use of this record.
455: */
456: delete from rcv_headers_interface
457: where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;
458:
459: /* End of fix for Bug 4901912 */
460:
461: EXCEPTION

Line 503: --inv_rcv_common_apis.g_po_startup_value.transaction_mode := 'ONLINE';

499: END IF;
500:
501:
502: -- We will remove this later ??
503: --inv_rcv_common_apis.g_po_startup_value.transaction_mode := 'ONLINE';
504:
505: IF Upper(inv_rcv_common_apis.g_po_startup_value.transaction_mode) = 'IMMEDIATE' OR
506: Upper(inv_rcv_common_apis.g_po_startup_value.transaction_mode) = 'BATCH' THEN
507:

Line 505: IF Upper(inv_rcv_common_apis.g_po_startup_value.transaction_mode) = 'IMMEDIATE' OR

501:
502: -- We will remove this later ??
503: --inv_rcv_common_apis.g_po_startup_value.transaction_mode := 'ONLINE';
504:
505: IF Upper(inv_rcv_common_apis.g_po_startup_value.transaction_mode) = 'IMMEDIATE' OR
506: Upper(inv_rcv_common_apis.g_po_startup_value.transaction_mode) = 'BATCH' THEN
507:
508: -- Call rma API First
509: -- This API returns without doing anything if the source is not customer

Line 506: Upper(inv_rcv_common_apis.g_po_startup_value.transaction_mode) = 'BATCH' THEN

502: -- We will remove this later ??
503: --inv_rcv_common_apis.g_po_startup_value.transaction_mode := 'ONLINE';
504:
505: IF Upper(inv_rcv_common_apis.g_po_startup_value.transaction_mode) = 'IMMEDIATE' OR
506: Upper(inv_rcv_common_apis.g_po_startup_value.transaction_mode) = 'BATCH' THEN
507:
508: -- Call rma API First
509: -- This API returns without doing anything if the source is not customer
510:

Line 515: --rcv_update_rma_info(inv_rcv_common_apis.g_rcv_global_var.interface_group_id,

511: -- *****************************
512: -- This call is commented in patchsetJ as this is not needed anymore
513: -- because Receiving TM would call it for immediate and batch mode also.
514: --
515: --rcv_update_rma_info(inv_rcv_common_apis.g_rcv_global_var.interface_group_id,
516: -- x_return_status ,
517: -- x_msg_data );
518: -- l_progress := '10.1';
519:

Line 541: IF ( NVL(inv_rcv_common_apis.g_rcv_global_var.interface_group_id,-999) <> -999 ) THEN

537: -- ************************************
538:
539:
540: /*Bug#8293126.Need to make sure all RTIs are with mode IMMEDIATE */
541: IF ( NVL(inv_rcv_common_apis.g_rcv_global_var.interface_group_id,-999) <> -999 ) THEN
542: UPDATE RCV_TRANSACTIONS_INTERFACE
543: SET PROCESSING_MODE_CODE = 'IMMEDIATE'
544: WHERE GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
545: AND PROCESSING_MODE_CODE <> 'IMMEDIATE';

Line 544: WHERE GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id

540: /*Bug#8293126.Need to make sure all RTIs are with mode IMMEDIATE */
541: IF ( NVL(inv_rcv_common_apis.g_rcv_global_var.interface_group_id,-999) <> -999 ) THEN
542: UPDATE RCV_TRANSACTIONS_INTERFACE
543: SET PROCESSING_MODE_CODE = 'IMMEDIATE'
544: WHERE GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
545: AND PROCESSING_MODE_CODE <> 'IMMEDIATE';
546: END IF;
547:
548: rcv_immediate_transaction

Line 604: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := '';

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:
606: EXCEPTION
607: WHEN fnd_api.g_exc_error THEN
608: rcv_print_traveller;