DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on INV_RCV_COMMON_APIS

Line 5631: inv_rcv_common_apis.rcv_clear_global;

5627: l_progress := '990';
5628:
5629: -- Also need to clean up the TM variables. This is needed because
5630: -- in an online transactions, the variables will not be reset
5631: inv_rcv_common_apis.rcv_clear_global;
5632:
5633: EXCEPTION
5634: WHEN fnd_api.g_exc_error THEN
5635: x_return_status := fnd_api.g_ret_sts_error;

Line 7032: l_old_txn_mode_code := inv_rcv_common_apis.g_po_startup_value.transaction_mode;

7028: END LOOP;
7029:
7030: --End of BUG FIX 3359835
7031:
7032: l_old_txn_mode_code := inv_rcv_common_apis.g_po_startup_value.transaction_mode;
7033: inv_rcv_common_apis.g_po_startup_value.transaction_mode := 'ONLINE';
7034:
7035: l_progress := 100;
7036:

Line 7033: inv_rcv_common_apis.g_po_startup_value.transaction_mode := 'ONLINE';

7029:
7030: --End of BUG FIX 3359835
7031:
7032: l_old_txn_mode_code := inv_rcv_common_apis.g_po_startup_value.transaction_mode;
7033: inv_rcv_common_apis.g_po_startup_value.transaction_mode := 'ONLINE';
7034:
7035: l_progress := 100;
7036:
7037: BEGIN

Line 7044: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;

7040: ,x_msg_data => x_msg_data
7041: );
7042: EXCEPTION
7043: WHEN OTHERS THEN
7044: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;
7045: IF (l_debug = 1) THEN
7046: DEBUG('xxx: Error - Rcv TM Failed','load_lpn',9);
7047: END IF;
7048: RAISE fnd_api.g_exc_error;

Line 7055: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;

7051: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
7052: IF (l_debug = 1) THEN
7053: DEBUG('xxx: Error - Rcv TM Failed','load_lpn',9);
7054: END IF;
7055: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;
7056: RAISE fnd_api.g_exc_error;
7057: END IF;
7058:
7059: l_progress := 150;

Line 7061: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;

7057: END IF;
7058:
7059: l_progress := 150;
7060:
7061: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;
7062: inv_rcv_common_apis.rcv_clear_global;
7063: END IF;
7064:
7065: -- RCV TM would call complete_operation_instance

Line 7062: inv_rcv_common_apis.rcv_clear_global;

7058:
7059: l_progress := 150;
7060:
7061: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;
7062: inv_rcv_common_apis.rcv_clear_global;
7063: END IF;
7064:
7065: -- RCV TM would call complete_operation_instance
7066: IF (l_is_rcv_tm_call_needed <> TRUE) THEN

Line 7206: inv_rcv_common_apis.init_startup_values(l_from_org);

7202: debug(' p_org_id => '||l_from_org, 'insert_rti',9);
7203: END IF;
7204:
7205: BEGIN
7206: inv_rcv_common_apis.init_startup_values(l_from_org);
7207: EXCEPTION
7208: WHEN NO_DATA_FOUND THEN
7209: fnd_message.set_name('INV', 'INV_RCV_PARAM');
7210: fnd_msg_pub.ADD;

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

7212: END;
7213:
7214: l_progress := '2';
7215:
7216: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
7217: --BUG 3435079: For performance reason, do not go against the view
7218: --org_organization_definitions. instead, use
7219: --the query below
7220: SELECT TO_NUMBER(hoi.org_information1)

Line 7221: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

7217: --BUG 3435079: For performance reason, do not go against the view
7218: --org_organization_definitions. instead, use
7219: --the query below
7220: SELECT TO_NUMBER(hoi.org_information1)
7221: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
7222: FROM hr_organization_information hoi
7223: WHERE hoi.organization_id = l_from_org
7224: AND (hoi.org_information_context || '') = 'Accounting Information';
7225:

Line 7235: inv_rcv_common_apis.validate_trx_date

7231: debug('init_startup_value exited. Calling validate_trx_date'
7232: ,'insert_rti', 9);
7233: END IF;
7234:
7235: inv_rcv_common_apis.validate_trx_date
7236: (
7237: p_trx_date => SYSDATE
7238: , p_organization_id => l_from_org
7239: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id

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

7235: inv_rcv_common_apis.validate_trx_date
7236: (
7237: p_trx_date => SYSDATE
7238: , p_organization_id => l_from_org
7239: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
7240: , x_return_status => x_return_status
7241: , x_error_code => l_error_code
7242: );
7243:

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

7256: INTO l_interface_transaction_id
7257: FROM dual;
7258:
7259: -- init_start_values should have called gen_txn_group_id
7260: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
7261:
7262: IF (l_debug = 1) THEN
7263: DEBUG('Calling rcv_trx_interface_insert_pkg.insert_row',
7264: 'insert_rti', 9);

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

7537: END;
7538:
7539: -- Get LPN group Id
7540: IF p_lpn_context = 3 THEN
7541: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
7542: SELECT rcv_interface_groups_s.NEXTVAL
7543: INTO l_group_id
7544: FROM DUAL;
7545: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;

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

7541: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
7542: SELECT rcv_interface_groups_s.NEXTVAL
7543: INTO l_group_id
7544: FROM DUAL;
7545: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
7546: ELSE
7547: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
7548: END IF;
7549: END IF;

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

7543: INTO l_group_id
7544: FROM DUAL;
7545: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
7546: ELSE
7547: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
7548: END IF;
7549: END IF;
7550:
7551: -- Drop Entire LPN,

Line 8424: l_old_txn_mode_code := inv_rcv_common_apis.g_po_startup_value.transaction_mode;

8420: IF (l_debug = 1) THEN
8421: DEBUG('xxx: Calling rcv_process_receive_txn','transfer_contents',9);
8422: END IF;
8423:
8424: l_old_txn_mode_code := inv_rcv_common_apis.g_po_startup_value.transaction_mode;
8425: inv_rcv_common_apis.g_po_startup_value.transaction_mode := 'ONLINE';
8426:
8427: l_progress := '135';
8428:

Line 8425: inv_rcv_common_apis.g_po_startup_value.transaction_mode := 'ONLINE';

8421: DEBUG('xxx: Calling rcv_process_receive_txn','transfer_contents',9);
8422: END IF;
8423:
8424: l_old_txn_mode_code := inv_rcv_common_apis.g_po_startup_value.transaction_mode;
8425: inv_rcv_common_apis.g_po_startup_value.transaction_mode := 'ONLINE';
8426:
8427: l_progress := '135';
8428:
8429: BEGIN

Line 8436: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;

8432: ,x_msg_data => x_msg_data
8433: );
8434: EXCEPTION
8435: WHEN OTHERS THEN
8436: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;
8437: IF (l_debug = 1) THEN
8438: DEBUG('xxx: Error - Rcv TM Failed','transfer_contents',9);
8439: END IF;
8440: RAISE fnd_api.g_exc_error;

Line 8447: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;

8443: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
8444: IF (l_debug = 1) THEN
8445: DEBUG('xxx: Error - Rcv TM Failed','transfer_contents',9);
8446: END IF;
8447: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;
8448: RAISE fnd_api.g_exc_error;
8449: END IF;
8450:
8451: l_progress := '140';

Line 8453: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;

8449: END IF;
8450:
8451: l_progress := '140';
8452:
8453: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;
8454: inv_rcv_common_apis.rcv_clear_global;
8455:
8456: ELSE -- No loose items and no sub/loc change
8457: IF (l_debug = 1) THEN

Line 8454: inv_rcv_common_apis.rcv_clear_global;

8450:
8451: l_progress := '140';
8452:
8453: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_old_txn_mode_code;
8454: inv_rcv_common_apis.rcv_clear_global;
8455:
8456: ELSE -- No loose items and no sub/loc change
8457: IF (l_debug = 1) THEN
8458: DEBUG('xxx: No loose items exist','transfer_contents',9);

Line 11166: inv_rcv_common_apis.rcv_clear_global;

11162: p_del_type => 1
11163: , p_group_id => p_group_id);
11164:
11165: -- Call the API to clear the receiving global variables
11166: inv_rcv_common_apis.rcv_clear_global;
11167:
11168: --At last, I'm done for the current group. Can go ahead and commit my work!
11169: COMMIT;
11170: