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 4970: CURSOR csi_txn_types_csr(p_source_txn_type IN VARCHAR2) IS

4966: p_csi_instance_id IN NUMBER)
4967: IS
4968:
4969: -- get csi transaction type.
4970: CURSOR csi_txn_types_csr(p_source_txn_type IN VARCHAR2) IS
4971: SELECT transaction_type_id
4972: FROM csi_txn_types
4973: WHERE source_transaction_type = p_source_txn_type;
4974:

Line 4972: FROM csi_txn_types

4968:
4969: -- get csi transaction type.
4970: CURSOR csi_txn_types_csr(p_source_txn_type IN VARCHAR2) IS
4971: SELECT transaction_type_id
4972: FROM csi_txn_types
4973: WHERE source_transaction_type = p_source_txn_type;
4974:
4975: /* Commented out by jeli on 11/30/05 for ER 4746426
4976: -- get sub-type id based on transaction.

Line 5074: OPEN csi_txn_types_csr(G_OM_ORDER);

5070:
5071: IF (p_oe_line_type = 'ORDER') THEN
5072:
5073: -- get transaction type ID for OM-Shipment.
5074: OPEN csi_txn_types_csr(G_OM_ORDER);
5075: FETCH csi_txn_types_csr INTO l_om_order_id;
5076: IF (csi_txn_types_csr%NOTFOUND) THEN
5077: CLOSE csi_txn_types_csr;
5078: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');

Line 5075: FETCH csi_txn_types_csr INTO l_om_order_id;

5071: IF (p_oe_line_type = 'ORDER') THEN
5072:
5073: -- get transaction type ID for OM-Shipment.
5074: OPEN csi_txn_types_csr(G_OM_ORDER);
5075: FETCH csi_txn_types_csr INTO l_om_order_id;
5076: IF (csi_txn_types_csr%NOTFOUND) THEN
5077: CLOSE csi_txn_types_csr;
5078: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5079: FND_MESSAGE.Set_Token('TYPE',G_OM_ORDER);

Line 5076: IF (csi_txn_types_csr%NOTFOUND) THEN

5072:
5073: -- get transaction type ID for OM-Shipment.
5074: OPEN csi_txn_types_csr(G_OM_ORDER);
5075: FETCH csi_txn_types_csr INTO l_om_order_id;
5076: IF (csi_txn_types_csr%NOTFOUND) THEN
5077: CLOSE csi_txn_types_csr;
5078: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5079: FND_MESSAGE.Set_Token('TYPE',G_OM_ORDER);
5080: FND_MSG_PUB.ADD;

Line 5077: CLOSE csi_txn_types_csr;

5073: -- get transaction type ID for OM-Shipment.
5074: OPEN csi_txn_types_csr(G_OM_ORDER);
5075: FETCH csi_txn_types_csr INTO l_om_order_id;
5076: IF (csi_txn_types_csr%NOTFOUND) THEN
5077: CLOSE csi_txn_types_csr;
5078: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5079: FND_MESSAGE.Set_Token('TYPE',G_OM_ORDER);
5080: FND_MSG_PUB.ADD;
5081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5084: CLOSE csi_txn_types_csr;

5080: FND_MSG_PUB.ADD;
5081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5082: RETURN;
5083: END IF;
5084: CLOSE csi_txn_types_csr;
5085:
5086: -- get csi transaction ID for sub type based on OSP Order type
5087: IF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE THEN
5088: --l_subtxn_name := G_SUBTXN_EXC_ORDER; --for ER 4746426

Line 5193: OPEN csi_txn_types_csr(G_OM_RETURN);

5189: */
5190: ELSIF (p_oe_line_type = 'RETURN') THEN
5191:
5192: -- get transaction type ID for RMA-Receipt.
5193: OPEN csi_txn_types_csr(G_OM_RETURN);
5194: FETCH csi_txn_types_csr INTO l_om_order_id;
5195: IF (csi_txn_types_csr%NOTFOUND) THEN
5196: CLOSE csi_txn_types_csr;
5197: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');

Line 5194: FETCH csi_txn_types_csr INTO l_om_order_id;

5190: ELSIF (p_oe_line_type = 'RETURN') THEN
5191:
5192: -- get transaction type ID for RMA-Receipt.
5193: OPEN csi_txn_types_csr(G_OM_RETURN);
5194: FETCH csi_txn_types_csr INTO l_om_order_id;
5195: IF (csi_txn_types_csr%NOTFOUND) THEN
5196: CLOSE csi_txn_types_csr;
5197: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5198: FND_MESSAGE.Set_Token('TYPE',G_OM_RETURN);

Line 5195: IF (csi_txn_types_csr%NOTFOUND) THEN

5191:
5192: -- get transaction type ID for RMA-Receipt.
5193: OPEN csi_txn_types_csr(G_OM_RETURN);
5194: FETCH csi_txn_types_csr INTO l_om_order_id;
5195: IF (csi_txn_types_csr%NOTFOUND) THEN
5196: CLOSE csi_txn_types_csr;
5197: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5198: FND_MESSAGE.Set_Token('TYPE',G_OM_RETURN);
5199: FND_MSG_PUB.ADD;

Line 5196: CLOSE csi_txn_types_csr;

5192: -- get transaction type ID for RMA-Receipt.
5193: OPEN csi_txn_types_csr(G_OM_RETURN);
5194: FETCH csi_txn_types_csr INTO l_om_order_id;
5195: IF (csi_txn_types_csr%NOTFOUND) THEN
5196: CLOSE csi_txn_types_csr;
5197: FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_TXN_NOTFOUND');
5198: FND_MESSAGE.Set_Token('TYPE',G_OM_RETURN);
5199: FND_MSG_PUB.ADD;
5200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5203: CLOSE csi_txn_types_csr;

5199: FND_MSG_PUB.ADD;
5200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5201: RETURN;
5202: END IF;
5203: CLOSE csi_txn_types_csr;
5204:
5205: -- get csi transaction ID for sub type based on OSP Order type
5206: IF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE THEN
5207: --l_subtxn_name := G_SUBTXN_EXC_RETURN; --for ER 4746426