DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on INV_PROJECTLOCATOR_PUB

Line 4754: l_phy_result := inv_projectlocator_pub.GET_PHYSICAL_LOCATION(

4750: WHEN NO_DATA_FOUND THEN
4751: l_project_ref_enabled := 0;
4752: END;
4753: IF l_project_ref_enabled = 1 AND nvl(v_mmtt.locator_id,-1) <> -1 THEN
4754: l_phy_result := inv_projectlocator_pub.GET_PHYSICAL_LOCATION(
4755: P_ORGANIZATION_ID => v_mmtt.organization_id
4756: , P_LOCATOR_ID => v_mmtt.locator_id
4757: );
4758: IF (l_phy_result = FALSE) THEN

Line 4760: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for locator_id'||v_mmtt.locator_id, 'INV_LPN_TRX_PUB', 9);

4756: , P_LOCATOR_ID => v_mmtt.locator_id
4757: );
4758: IF (l_phy_result = FALSE) THEN
4759: IF (l_debug = 1) THEN
4760: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for locator_id'||v_mmtt.locator_id, 'INV_LPN_TRX_PUB', 9);
4761: END IF;
4762: fnd_message.set_name('INV', 'INV_INT_LOCEXP');
4763: fnd_msg_pub.ADD;
4764: RAISE fnd_api.g_exc_error;

Line 4770: l_phy_result := inv_projectlocator_pub.GET_PHYSICAL_LOCATION(

4766: END IF;
4767: --for move order/direct org xfer/sub xfer,we need also check the transfer location
4768: IF(v_mmtt.transaction_source_type_id=4) then--move order
4769: IF l_project_ref_enabled = 1 AND nvl(v_mmtt.transfer_to_location,-1) <> -1 THEN
4770: l_phy_result := inv_projectlocator_pub.GET_PHYSICAL_LOCATION(
4771: P_ORGANIZATION_ID => v_mmtt.organization_id
4772: , P_LOCATOR_ID => v_mmtt.transfer_to_location
4773: );
4774: IF (l_phy_result = FALSE) THEN

Line 4776: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for transfer_to_location'||v_mmtt.transfer_to_location, 'INV_LPN_TRX_PUB', 9);

4772: , P_LOCATOR_ID => v_mmtt.transfer_to_location
4773: );
4774: IF (l_phy_result = FALSE) THEN
4775: IF (l_debug = 1) THEN
4776: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for transfer_to_location'||v_mmtt.transfer_to_location, 'INV_LPN_TRX_PUB', 9);
4777: END IF;
4778: fnd_message.set_name('INV', 'INV_INT_LOCEXP');
4779: fnd_msg_pub.ADD;
4780: RAISE fnd_api.g_exc_error;

Line 4785: l_phy_result := inv_projectlocator_pub.GET_PHYSICAL_LOCATION(

4781: END IF;
4782: END IF;
4783: ELSIF(v_mmtt.transaction_source_type_id=13 AND v_mmtt.transaction_action_id=2) THEN --sub xfer
4784: IF l_project_ref_enabled = 1 AND nvl(v_mmtt.transfer_to_location,-1) <> -1 THEN
4785: l_phy_result := inv_projectlocator_pub.GET_PHYSICAL_LOCATION(
4786: P_ORGANIZATION_ID => v_mmtt.organization_id
4787: , P_LOCATOR_ID => v_mmtt.transfer_to_location
4788: );
4789: IF (l_phy_result = FALSE) THEN

Line 4791: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for transfer_to_location'||v_mmtt.transfer_to_location, 'INV_LPN_TRX_PUB', 9);

4787: , P_LOCATOR_ID => v_mmtt.transfer_to_location
4788: );
4789: IF (l_phy_result = FALSE) THEN
4790: IF (l_debug = 1) THEN
4791: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for transfer_to_location'||v_mmtt.transfer_to_location, 'INV_LPN_TRX_PUB', 9);
4792: END IF;
4793: fnd_message.set_name('INV', 'INV_INT_LOCEXP');
4794: fnd_msg_pub.ADD;
4795: RAISE fnd_api.g_exc_error;

Line 4809: l_phy_result := inv_projectlocator_pub.GET_PHYSICAL_LOCATION(

4805: WHEN NO_DATA_FOUND THEN
4806: l_project_ref_enabled := 0;
4807: END;
4808: IF l_project_ref_enabled = 1 AND nvl(v_mmtt.transfer_to_location,-1) <> -1 THEN
4809: l_phy_result := inv_projectlocator_pub.GET_PHYSICAL_LOCATION(
4810: P_ORGANIZATION_ID => v_mmtt.transfer_organization
4811: , P_LOCATOR_ID => v_mmtt.transfer_to_location
4812: );
4813: IF (l_phy_result = FALSE) THEN

Line 4815: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for transfer_to_location'||v_mmtt.transfer_to_location, 'INV_LPN_TRX_PUB', 9);

4811: , P_LOCATOR_ID => v_mmtt.transfer_to_location
4812: );
4813: IF (l_phy_result = FALSE) THEN
4814: IF (l_debug = 1) THEN
4815: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for transfer_to_location'||v_mmtt.transfer_to_location, 'INV_LPN_TRX_PUB', 9);
4816: END IF;
4817: fnd_message.set_name('INV', 'INV_INT_LOCEXP');
4818: fnd_msg_pub.ADD;
4819: RAISE fnd_api.g_exc_error;