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.GML_RCV_DIR_RCPT_APIS dependencies on INV_RCV_COMMON_APIS

Line 295: inv_rcv_common_apis.init_startup_values(p_organization_id);

291: l_progress := '10';
292:
293: -- query po_startup_value
294: Begin
295: inv_rcv_common_apis.init_startup_values(p_organization_id);
296: Exception
297: when NO_DATA_FOUND then
298: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_PARAM');
299: FND_MSG_PUB.ADD;

Line 305: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN

301: End;
302:
303: l_progress := '20';
304: -- default l_group_id ? clear group id after done
305: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
306: SELECT rcv_interface_groups_s.nextval
307: INTO l_group_id
308: FROM dual;
309: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;

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

305: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
306: SELECT rcv_interface_groups_s.nextval
307: INTO l_group_id
308: FROM dual;
309: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
310: ELSE
311: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
312: END IF;
313:

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

307: INTO l_group_id
308: FROM dual;
309: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
310: ELSE
311: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
312: END IF;
313:
314: l_progress := '30';
315: OPEN l_curs_rcpt_detail(p_po_distribution_id);

Line 476: inv_rcv_common_apis.do_check

472: p_lot_control_code => NULL,
473: p_serial_control_code => NULL);
474:
475: l_progress := '65';
476: inv_rcv_common_apis.do_check
477: (p_organization_id => p_organization_id,
478: p_inventory_item_id => p_item_id,
479: p_transaction_type_id => 18,
480: p_primary_quantity => l_total_primary_qty,

Line 758: inv_rcv_common_apis.init_startup_values(p_organization_id);

754: l_progress := '10';
755:
756: -- query po_startup_value
757: Begin
758: inv_rcv_common_apis.init_startup_values(p_organization_id);
759: Exception
760: when NO_DATA_FOUND then
761: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_PARAM');
762: FND_MSG_PUB.ADD;

Line 768: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN

764: End;
765:
766: l_progress := '20';
767: -- default l_group_id ? clear group id after done
768: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
769: SELECT rcv_interface_groups_s.nextval
770: INTO l_group_id
771: FROM dual;
772: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;

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

768: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
769: SELECT rcv_interface_groups_s.nextval
770: INTO l_group_id
771: FROM dual;
772: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
773: ELSE
774: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
775: END IF;
776:

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

770: INTO l_group_id
771: FROM dual;
772: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
773: ELSE
774: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
775: END IF;
776:
777: l_progress := '30';
778: -- initialize input record for matching algorithm

Line 1018: inv_rcv_common_apis.do_check

1014: l_progress := '90';
1015:
1016: /** Shortage checking not supported by OPM
1017:
1018: inv_rcv_common_apis.do_check
1019: (p_organization_id => p_organization_id,
1020: p_inventory_item_id => p_item_id,
1021: p_transaction_type_id => 18,
1022: p_primary_quantity => l_total_primary_qty,

Line 1110: l_rcpt_match_table_detail INV_RCV_COMMON_APIS.cascaded_trans_tab_type; -- output for matching algorithm

1106: )
1107:
1108: IS
1109:
1110: l_rcpt_match_table_detail INV_RCV_COMMON_APIS.cascaded_trans_tab_type; -- output for matching algorithm
1111:
1112: l_rcv_transaction_rec gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
1113:
1114: l_transaction_type VARCHAR2(20) := 'DELIVER';

Line 1314: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;

1310: FROM rcv_shipment_headers
1311: WHERE shipment_header_id = p_shipment_header_id
1312: AND ship_to_org_id = p_organization_id;
1313:
1314: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
1315: EXCEPTION
1316: WHEN NO_DATA_FOUND THEN
1317: l_receipt_num := NULL;
1318: END;

Line 1319: inv_rcv_common_apis.init_startup_values(p_organization_id);

1315: EXCEPTION
1316: WHEN NO_DATA_FOUND THEN
1317: l_receipt_num := NULL;
1318: END;
1319: inv_rcv_common_apis.init_startup_values(p_organization_id);
1320: Exception
1321: when NO_DATA_FOUND then
1322: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_PARAM');
1323: FND_MSG_PUB.ADD;

Line 1329: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN

1325: End;
1326:
1327: l_progress := '20';
1328: -- default l_group_id ? clear group id after done
1329: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
1330: SELECT rcv_interface_groups_s.nextval
1331: INTO l_group_id
1332: FROM dual;
1333: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;

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

1329: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
1330: SELECT rcv_interface_groups_s.nextval
1331: INTO l_group_id
1332: FROM dual;
1333: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1334: ELSE
1335: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1336: END IF;
1337:

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

1331: INTO l_group_id
1332: FROM dual;
1333: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1334: ELSE
1335: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1336: END IF;
1337:
1338: l_progress := '30';
1339: -- initialize input record for matching algorithm

Line 1512: inv_rcv_common_apis.do_check

1508: -- append index in input table where the line to be detailed needs to be inserted
1509: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
1510:
1511: l_progress := '90';
1512: inv_rcv_common_apis.do_check
1513: (p_organization_id => p_organization_id,
1514: p_inventory_item_id => p_item_id,
1515: p_transaction_type_id => 61,
1516: p_primary_quantity => l_total_primary_qty,

Line 1600: l_rcpt_match_table_detail INV_RCV_COMMON_APIS.cascaded_trans_tab_type; -- output for matching algorithm

1596: p_country_code IN VARCHAR2 DEFAULT NULL
1597: )
1598: IS
1599:
1600: l_rcpt_match_table_detail INV_RCV_COMMON_APIS.cascaded_trans_tab_type; -- output for matching algorithm
1601:
1602: l_rcv_transaction_rec gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
1603:
1604: l_transaction_type VARCHAR2(20) := 'DELIVER';

Line 1778: inv_rcv_common_apis.init_startup_values(p_organization_id);

1774: SAVEPOINT crt_rma_rti_sp;
1775:
1776: -- query po_startup_value
1777: Begin
1778: inv_rcv_common_apis.init_startup_values(p_organization_id);
1779: Exception
1780: when NO_DATA_FOUND then
1781: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_PARAM');
1782: FND_MSG_PUB.ADD;

Line 1788: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN

1784: End;
1785:
1786: l_progress := '20';
1787: -- default l_group_id ? clear group id after done
1788: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
1789: SELECT rcv_interface_groups_s.nextval
1790: INTO l_group_id
1791: FROM dual;
1792: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;

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

1788: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
1789: SELECT rcv_interface_groups_s.nextval
1790: INTO l_group_id
1791: FROM dual;
1792: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1793: ELSE
1794: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1795: END IF;
1796:

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

1790: INTO l_group_id
1791: FROM dual;
1792: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1793: ELSE
1794: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1795: END IF;
1796:
1797: -- initialize input record for matching algorithm
1798: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';

Line 1941: inv_rcv_common_apis.do_check

1937: -- append index in input table where the line to be detailed needs to be inserted
1938: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
1939:
1940: l_progress := '90';
1941: inv_rcv_common_apis.do_check
1942: (p_organization_id => p_organization_id,
1943: p_inventory_item_id => p_item_id,
1944: p_transaction_type_id => 15,
1945: p_primary_quantity => l_total_primary_qty,

Line 2028: l_rcpt_match_table_detail INV_RCV_COMMON_APIS.cascaded_trans_tab_type; -- output for matching algorithm

2024: p_country_code IN VARCHAR2 DEFAULT NULL,
2025: p_item_desc IN VARCHAR2 DEFAULT NULL
2026: )
2027: IS
2028: l_rcpt_match_table_detail INV_RCV_COMMON_APIS.cascaded_trans_tab_type; -- output for matching algorithm
2029:
2030: l_rcv_transaction_rec gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
2031:
2032: l_transaction_type VARCHAR2(20) := 'DELIVER';

Line 2400: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;

2396: FROM rcv_shipment_headers
2397: WHERE shipment_header_id = p_shipment_header_id
2398: AND ship_to_org_id = p_organization_id;
2399:
2400: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
2401: EXCEPTION
2402: WHEN NO_DATA_FOUND THEN
2403: l_receipt_num := NULL;
2404: END;

Line 2405: INV_rcv_common_apis.init_startup_values(p_organization_id);

2401: EXCEPTION
2402: WHEN NO_DATA_FOUND THEN
2403: l_receipt_num := NULL;
2404: END;
2405: INV_rcv_common_apis.init_startup_values(p_organization_id);
2406: Exception
2407: when NO_DATA_FOUND then
2408: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_PARAM');
2409: FND_MSG_PUB.ADD;

Line 2420: IF INV_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN

2416:
2417: l_progress := '20';
2418:
2419: -- default l_group_id ? clear group id after done
2420: IF INV_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
2421: SELECT rcv_interface_groups_s.nextval
2422: INTO l_group_id
2423: FROM dual;
2424: INV_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;

Line 2424: INV_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;

2420: IF INV_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
2421: SELECT rcv_interface_groups_s.nextval
2422: INTO l_group_id
2423: FROM dual;
2424: INV_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2425: ELSE
2426: l_group_id := INV_rcv_common_apis.g_rcv_global_var.interface_group_id;
2427: END IF;
2428:

Line 2426: l_group_id := INV_rcv_common_apis.g_rcv_global_var.interface_group_id;

2422: INTO l_group_id
2423: FROM dual;
2424: INV_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2425: ELSE
2426: l_group_id := INV_rcv_common_apis.g_rcv_global_var.interface_group_id;
2427: END IF;
2428:
2429: l_progress := '30';
2430:

Line 2667: inv_rcv_common_apis.do_check

2663: l_progress := '110';
2664:
2665:
2666: l_progress := '120';
2667: inv_rcv_common_apis.do_check
2668: (p_organization_id => p_organization_id,
2669: p_inventory_item_id => p_item_id,
2670: p_transaction_type_id => 18,
2671: p_primary_quantity => l_total_primary_qty,

Line 2946: inv_rcv_common_apis.insert_lot

2942: END IF;
2943:
2944: l_primary_qty := l_quantity * l_uom_conv_ratio;
2945:
2946: inv_rcv_common_apis.insert_lot
2947: (p_transaction_temp_id => l_transaction_temp_id,
2948: p_created_by => fnd_global.user_id,
2949: p_transaction_qty => l_quantity,
2950: p_primary_qty => l_primary_qty,

Line 3116: source_header_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id

3112:
3113:
3114: update wms_lpn_histories
3115: set source_name = 'ASNEXP',
3116: source_header_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id
3117: where lpn_context = 7
3118: and parent_lpn_id in (select lpn_id
3119: from wms_license_plate_numbers
3120: WHERE source_header_id = p_shipment_header_id

Line 3203: WHERE rti.group_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id

3199: /* Group BY LPN_ID is changed for Express Receipts */
3200: /* Also duplicate print of LPN labels is avoided */
3201: SELECT MAX(rti.interface_transaction_id)
3202: FROM rcv_transactions_interface rti
3203: WHERE rti.group_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id
3204: GROUP BY decode(p_source_type, 'ASNEXP',rti.interface_transaction_id,'SHIPMENTEXP',rti.interface_transaction_id,null) ;
3205: -- GROUP BY rti.lpn_id;
3206: BEGIN
3207: x_status := fnd_api.g_ret_sts_success;

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

3206: BEGIN
3207: x_status := fnd_api.g_ret_sts_success;
3208: l_progress := '10';
3209:
3210: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
3211: select ood.set_of_books_id
3212: into inv_rcv_common_apis.g_po_startup_value.sob_id
3213: FROM org_organization_definitions ood,
3214: gl_sets_of_books sob

Line 3212: into inv_rcv_common_apis.g_po_startup_value.sob_id

3208: l_progress := '10';
3209:
3210: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
3211: select ood.set_of_books_id
3212: into inv_rcv_common_apis.g_po_startup_value.sob_id
3213: FROM org_organization_definitions ood,
3214: gl_sets_of_books sob
3215: WHERE organization_id = p_organization_id
3216: AND sob.set_of_books_id = ood.set_of_books_id;

Line 3221: inv_rcv_common_apis.validate_trx_date(p_trx_date => Sysdate,

3217: END IF;
3218:
3219: l_progress := '10';
3220: -- first check if the transaction date satisfies the validation.
3221: inv_rcv_common_apis.validate_trx_date(p_trx_date => Sysdate,
3222: p_organization_id => p_organization_id,
3223: p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id,
3224: x_return_status => x_status,
3225: x_error_code => x_message);

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

3219: l_progress := '10';
3220: -- first check if the transaction date satisfies the validation.
3221: inv_rcv_common_apis.validate_trx_date(p_trx_date => Sysdate,
3222: p_organization_id => p_organization_id,
3223: p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id,
3224: x_return_status => x_status,
3225: x_error_code => x_message);
3226:
3227: IF x_status <> fnd_api.g_ret_sts_success THEN

Line 3381: WHERE rti.group_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id

3377: /* Also duplicate print of LPN labels is avoided */
3378:
3379: SELECT MAX(rti.interface_transaction_id)
3380: FROM rcv_transactions_interface rti
3381: WHERE rti.group_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id
3382: GROUP BY decode(p_source_type, 'ASNEXP',rti.interface_transaction_id,'SHIPMENTEXP',rti.interface_transaction_id,null) ;
3383: -- GROUP BY rti.lpn_id;
3384: BEGIN
3385: x_status := fnd_api.g_ret_sts_success;

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

3384: BEGIN
3385: x_status := fnd_api.g_ret_sts_success;
3386: l_progress := '10';
3387:
3388: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
3389: select ood.set_of_books_id
3390: into inv_rcv_common_apis.g_po_startup_value.sob_id
3391: FROM org_organization_definitions ood,
3392: gl_sets_of_books sob

Line 3390: into inv_rcv_common_apis.g_po_startup_value.sob_id

3386: l_progress := '10';
3387:
3388: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
3389: select ood.set_of_books_id
3390: into inv_rcv_common_apis.g_po_startup_value.sob_id
3391: FROM org_organization_definitions ood,
3392: gl_sets_of_books sob
3393: WHERE organization_id = p_organization_id
3394: AND sob.set_of_books_id = ood.set_of_books_id;

Line 3399: inv_rcv_common_apis.validate_trx_date(p_trx_date => Sysdate,

3395: END IF;
3396:
3397: l_progress := '10';
3398: -- first check if the transaction date satisfies the validation.
3399: inv_rcv_common_apis.validate_trx_date(p_trx_date => Sysdate,
3400: p_organization_id => p_organization_id,
3401: p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id,
3402: x_return_status => x_status,
3403: x_error_code => x_message);

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

3397: l_progress := '10';
3398: -- first check if the transaction date satisfies the validation.
3399: inv_rcv_common_apis.validate_trx_date(p_trx_date => Sysdate,
3400: p_organization_id => p_organization_id,
3401: p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id,
3402: x_return_status => x_status,
3403: x_error_code => x_message);
3404:
3405: IF x_status <> fnd_api.g_ret_sts_success THEN

Line 3734: (p_trx_hdr_id => inv_rcv_common_apis.g_rcv_global_var.transaction_header_id,

3730: l_return_status NUMBER;
3731: BEGIN
3732:
3733: l_return_status := inv_lpn_trx_pub.process_lpn_trx
3734: (p_trx_hdr_id => inv_rcv_common_apis.g_rcv_global_var.transaction_header_id,
3735: p_mode => 2, -- putaway mode
3736: p_commit => 'F',
3737: x_proc_msg => l_proc_msg);
3738: