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.AHL_OSP_SHIPMENT_PUB dependencies on CSI_TXN_TYPES

Line 4925: CURSOR csi_txn_types_csr(p_source_txn_type IN VARCHAR2) IS

4921: p_csi_instance_id IN NUMBER)
4922: IS
4923:
4924: -- get csi transaction type.
4925: CURSOR csi_txn_types_csr(p_source_txn_type IN VARCHAR2) IS
4926: SELECT transaction_type_id
4927: FROM csi_txn_types
4928: WHERE source_transaction_type = p_source_txn_type;
4929:

Line 4927: FROM csi_txn_types

4923:
4924: -- get csi transaction type.
4925: CURSOR csi_txn_types_csr(p_source_txn_type IN VARCHAR2) IS
4926: SELECT transaction_type_id
4927: FROM csi_txn_types
4928: WHERE source_transaction_type = p_source_txn_type;
4929:
4930: /* Commented out by jeli on 11/30/05 for ER 4746426
4931: -- get sub-type id based on transaction.

Line 5029: OPEN csi_txn_types_csr(G_OM_ORDER);

5025:
5026: IF (p_oe_line_type = 'ORDER') THEN
5027:
5028: -- get transaction type ID for OM-Shipment.
5029: OPEN csi_txn_types_csr(G_OM_ORDER);
5030: FETCH csi_txn_types_csr INTO l_om_order_id;
5031: IF (csi_txn_types_csr%NOTFOUND) THEN
5032: CLOSE csi_txn_types_csr;
5033: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');

Line 5030: FETCH csi_txn_types_csr INTO l_om_order_id;

5026: IF (p_oe_line_type = 'ORDER') THEN
5027:
5028: -- get transaction type ID for OM-Shipment.
5029: OPEN csi_txn_types_csr(G_OM_ORDER);
5030: FETCH csi_txn_types_csr INTO l_om_order_id;
5031: IF (csi_txn_types_csr%NOTFOUND) THEN
5032: CLOSE csi_txn_types_csr;
5033: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5034: FND_MESSAGE.Set_Token('TYPE',G_OM_ORDER);

Line 5031: IF (csi_txn_types_csr%NOTFOUND) THEN

5027:
5028: -- get transaction type ID for OM-Shipment.
5029: OPEN csi_txn_types_csr(G_OM_ORDER);
5030: FETCH csi_txn_types_csr INTO l_om_order_id;
5031: IF (csi_txn_types_csr%NOTFOUND) THEN
5032: CLOSE csi_txn_types_csr;
5033: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5034: FND_MESSAGE.Set_Token('TYPE',G_OM_ORDER);
5035: FND_MSG_PUB.ADD;

Line 5032: CLOSE csi_txn_types_csr;

5028: -- get transaction type ID for OM-Shipment.
5029: OPEN csi_txn_types_csr(G_OM_ORDER);
5030: FETCH csi_txn_types_csr INTO l_om_order_id;
5031: IF (csi_txn_types_csr%NOTFOUND) THEN
5032: CLOSE csi_txn_types_csr;
5033: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5034: FND_MESSAGE.Set_Token('TYPE',G_OM_ORDER);
5035: FND_MSG_PUB.ADD;
5036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5039: CLOSE csi_txn_types_csr;

5035: FND_MSG_PUB.ADD;
5036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5037: RETURN;
5038: END IF;
5039: CLOSE csi_txn_types_csr;
5040:
5041: -- get csi transaction ID for sub type based on OSP Order type
5042: IF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE THEN
5043: --l_subtxn_name := G_SUBTXN_EXC_ORDER; --for ER 4746426

Line 5148: OPEN csi_txn_types_csr(G_OM_RETURN);

5144: */
5145: ELSIF (p_oe_line_type = 'RETURN') THEN
5146:
5147: -- get transaction type ID for RMA-Receipt.
5148: OPEN csi_txn_types_csr(G_OM_RETURN);
5149: FETCH csi_txn_types_csr INTO l_om_order_id;
5150: IF (csi_txn_types_csr%NOTFOUND) THEN
5151: CLOSE csi_txn_types_csr;
5152: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');

Line 5149: FETCH csi_txn_types_csr INTO l_om_order_id;

5145: ELSIF (p_oe_line_type = 'RETURN') THEN
5146:
5147: -- get transaction type ID for RMA-Receipt.
5148: OPEN csi_txn_types_csr(G_OM_RETURN);
5149: FETCH csi_txn_types_csr INTO l_om_order_id;
5150: IF (csi_txn_types_csr%NOTFOUND) THEN
5151: CLOSE csi_txn_types_csr;
5152: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5153: FND_MESSAGE.Set_Token('TYPE',G_OM_RETURN);

Line 5150: IF (csi_txn_types_csr%NOTFOUND) THEN

5146:
5147: -- get transaction type ID for RMA-Receipt.
5148: OPEN csi_txn_types_csr(G_OM_RETURN);
5149: FETCH csi_txn_types_csr INTO l_om_order_id;
5150: IF (csi_txn_types_csr%NOTFOUND) THEN
5151: CLOSE csi_txn_types_csr;
5152: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5153: FND_MESSAGE.Set_Token('TYPE',G_OM_RETURN);
5154: FND_MSG_PUB.ADD;

Line 5151: CLOSE csi_txn_types_csr;

5147: -- get transaction type ID for RMA-Receipt.
5148: OPEN csi_txn_types_csr(G_OM_RETURN);
5149: FETCH csi_txn_types_csr INTO l_om_order_id;
5150: IF (csi_txn_types_csr%NOTFOUND) THEN
5151: CLOSE csi_txn_types_csr;
5152: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5153: FND_MESSAGE.Set_Token('TYPE',G_OM_RETURN);
5154: FND_MSG_PUB.ADD;
5155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5158: CLOSE csi_txn_types_csr;

5154: FND_MSG_PUB.ADD;
5155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5156: RETURN;
5157: END IF;
5158: CLOSE csi_txn_types_csr;
5159:
5160: -- get csi transaction ID for sub type based on OSP Order type
5161: IF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE THEN
5162: --l_subtxn_name := G_SUBTXN_EXC_RETURN; --for ER 4746426