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_STD_TRANSFER_APIS dependencies on INV_RCV_COMMON_APIS

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

41: l_destination_context RCV_TRANSACTIONS_INTERFACE.DESTINATION_CONTEXT%TYPE := 'RECEIVING';
42: l_parent_transaction_id NUMBER := p_rcv_transaction_rec.rcv_transaction_id;
43: l_movement_id NUMBER;
44: l_bom_resource_id NUMBER := NULL;
45: l_group_id NUMBER := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
46: l_user_id NUMBER := inv_rcv_common_apis.g_po_startup_value.user_id;
47: l_employee_id NUMBER := inv_rcv_common_apis.g_po_startup_value.employee_id;
48: l_logon_id NUMBER := inv_rcv_common_apis.g_po_startup_value.logon_id;
49: l_transaction_mode VARCHAR2(10) := inv_rcv_common_apis.g_po_startup_value.transaction_mode;

Line 46: l_user_id NUMBER := inv_rcv_common_apis.g_po_startup_value.user_id;

42: l_parent_transaction_id NUMBER := p_rcv_transaction_rec.rcv_transaction_id;
43: l_movement_id NUMBER;
44: l_bom_resource_id NUMBER := NULL;
45: l_group_id NUMBER := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
46: l_user_id NUMBER := inv_rcv_common_apis.g_po_startup_value.user_id;
47: l_employee_id NUMBER := inv_rcv_common_apis.g_po_startup_value.employee_id;
48: l_logon_id NUMBER := inv_rcv_common_apis.g_po_startup_value.logon_id;
49: l_transaction_mode VARCHAR2(10) := inv_rcv_common_apis.g_po_startup_value.transaction_mode;
50: l_trx_date DATE;

Line 47: l_employee_id NUMBER := inv_rcv_common_apis.g_po_startup_value.employee_id;

43: l_movement_id NUMBER;
44: l_bom_resource_id NUMBER := NULL;
45: l_group_id NUMBER := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
46: l_user_id NUMBER := inv_rcv_common_apis.g_po_startup_value.user_id;
47: l_employee_id NUMBER := inv_rcv_common_apis.g_po_startup_value.employee_id;
48: l_logon_id NUMBER := inv_rcv_common_apis.g_po_startup_value.logon_id;
49: l_transaction_mode VARCHAR2(10) := inv_rcv_common_apis.g_po_startup_value.transaction_mode;
50: l_trx_date DATE;
51: l_currency_conv_date DATE;

Line 48: l_logon_id NUMBER := inv_rcv_common_apis.g_po_startup_value.logon_id;

44: l_bom_resource_id NUMBER := NULL;
45: l_group_id NUMBER := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
46: l_user_id NUMBER := inv_rcv_common_apis.g_po_startup_value.user_id;
47: l_employee_id NUMBER := inv_rcv_common_apis.g_po_startup_value.employee_id;
48: l_logon_id NUMBER := inv_rcv_common_apis.g_po_startup_value.logon_id;
49: l_transaction_mode VARCHAR2(10) := inv_rcv_common_apis.g_po_startup_value.transaction_mode;
50: l_trx_date DATE;
51: l_currency_conv_date DATE;
52: l_validation_flag VARCHAR2(1);

Line 49: l_transaction_mode VARCHAR2(10) := inv_rcv_common_apis.g_po_startup_value.transaction_mode;

45: l_group_id NUMBER := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
46: l_user_id NUMBER := inv_rcv_common_apis.g_po_startup_value.user_id;
47: l_employee_id NUMBER := inv_rcv_common_apis.g_po_startup_value.employee_id;
48: l_logon_id NUMBER := inv_rcv_common_apis.g_po_startup_value.logon_id;
49: l_transaction_mode VARCHAR2(10) := inv_rcv_common_apis.g_po_startup_value.transaction_mode;
50: l_trx_date DATE;
51: l_currency_conv_date DATE;
52: l_validation_flag VARCHAR2(1);
53: l_lpn_group_id NUMBER;

Line 95: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

91:
92: --Truncate the transaction_date to store only the date part
93: l_trx_date := TRUNC(p_rcv_transaction_rec.transaction_date_nb);
94: -- bug 3452845
95: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
96: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
97: l_trx_date := Sysdate;
98: ELSE
99: l_trx_date := Trunc(Sysdate);

Line 96: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

92: --Truncate the transaction_date to store only the date part
93: l_trx_date := TRUNC(p_rcv_transaction_rec.transaction_date_nb);
94: -- bug 3452845
95: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
96: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
97: l_trx_date := Sysdate;
98: ELSE
99: l_trx_date := Trunc(Sysdate);
100: END IF;

Line 109: l_operating_unit_id := inv_rcv_common_apis.get_operating_unit_id( p_rcv_transaction_rec.receipt_source_code,

105: l_validation_flag := 'Y';
106: l_lpn_group_id := l_group_id;
107:
108: --
109: l_operating_unit_id := inv_rcv_common_apis.get_operating_unit_id( p_rcv_transaction_rec.receipt_source_code,
110: p_rcv_transaction_rec.po_header_id,
111: p_rcv_transaction_rec.req_line_id,
112: p_rcv_transaction_rec.oe_order_header_id );
113:

Line 655: IF (NVL(inv_rcv_common_apis.g_rcv_global_var.express_mode, 'NO') <> 'YES') THEN

651: IF (l_debug = 1) THEN
652: print_debug('Inserting the RTI for TRANSFER transaction', 4);
653: END IF;
654:
655: IF (NVL(inv_rcv_common_apis.g_rcv_global_var.express_mode, 'NO') <> 'YES') THEN
656: --Call the helper routine to create the RTI record
657: l_interface_txn_id := insert_interface_code (
658: p_rcv_transaction_rec => p_rcv_transaction_rec);
659:

Line 2446: inv_rcv_common_apis.init_startup_values(p_organization_id);

2442: END IF;
2443:
2444: --Initialize the receiving parameters for the organization id
2445: BEGIN
2446: inv_rcv_common_apis.init_startup_values(p_organization_id);
2447: EXCEPTION
2448: WHEN OTHERS THEN
2449: IF (l_debug = 1) THEN
2450: print_debug('Failed at progress : ' || l_progress ||

Line 2462: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN

2458: END;
2459:
2460: --First check if the transaction date satisfies the validation.
2461: --If the transaction date is invalid then error out the transaction
2462: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
2463: --Bug # 3444214
2464: --For better performance, using hr_organization_information to fetch set_of_books_id
2465: SELECT TO_NUMBER(hoi.org_information1)
2466: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

Line 2466: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

2462: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
2463: --Bug # 3444214
2464: --For better performance, using hr_organization_information to fetch set_of_books_id
2465: SELECT TO_NUMBER(hoi.org_information1)
2466: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
2467: FROM hr_organization_information hoi
2468: WHERE hoi.organization_id = p_organization_id
2469: AND (hoi.org_information_context || '') = 'Accounting Information';
2470: END IF;

Line 2474: inv_rcv_common_apis.validate_trx_date(

2470: END IF;
2471:
2472: l_progress := 15;
2473:
2474: inv_rcv_common_apis.validate_trx_date(
2475: p_trx_date => SYSDATE
2476: , p_organization_id => p_organization_id
2477: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
2478: , x_return_status => x_return_status

Line 2477: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id

2473:
2474: inv_rcv_common_apis.validate_trx_date(
2475: p_trx_date => SYSDATE
2476: , p_organization_id => p_organization_id
2477: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
2478: , x_return_status => x_return_status
2479: , x_error_code => l_message
2480: );
2481:

Line 2493: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN

2489: IF (l_debug = 1) THEN
2490: print_debug('Setting group_id for the current txn', 4);
2491: END IF;
2492:
2493: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2494: SELECT rcv_interface_groups_s.NEXTVAL
2495: INTO l_group_id
2496: FROM sys.dual;
2497: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;

Line 2497: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;

2493: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2494: SELECT rcv_interface_groups_s.NEXTVAL
2495: INTO l_group_id
2496: FROM sys.dual;
2497: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2498: ELSE
2499: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2500: END IF;
2501:

Line 2499: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

2495: INTO l_group_id
2496: FROM sys.dual;
2497: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2498: ELSE
2499: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2500: END IF;
2501:
2502: --Set the package variable for uom_code
2503: g_transfer_uom_code := p_transfer_uom_code;