DBA Data[Home] [Help]

APPS.AHL_OSP_SHIPMENT_PUB dependencies on AHL_UTIL_UC_PKG

Line 6940: AHL_UTIL_UC_PKG.GetCSI_Attribute_Value (l_serialnum_change_rec.instance_id,

6936: RAISE FND_API.G_EXC_ERROR;
6937: END IF;
6938:
6939: -- Retrieve existing value of serialNum_Tag_Code if present.
6940: AHL_UTIL_UC_PKG.GetCSI_Attribute_Value (l_serialnum_change_rec.instance_id,
6941: 'AHL_TEMP_SERIAL_NUM',
6942: l_attribute_value,
6943: l_attribute_value_id,
6944: l_object_version_number,

Line 7095: AHL_UTIL_UC_PKG.GetCSI_Attribute_ID('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);

7091: END IF;
7092: ELSIF (l_serial_tag_rec_found = 'N' ) THEN
7093: IF (l_serialnum_change_rec.New_Serial_Tag_Code IS NOT NULL) THEN
7094: -- create extended attributes.
7095: AHL_UTIL_UC_PKG.GetCSI_Attribute_ID('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);
7096: IF NOT(l_return_val) THEN
7097: FND_MESSAGE.Set_Name('AHL','AHL_ATTRIB_CODE_MISSING');
7098: FND_MESSAGE.Set_Token('CODE', 'AHL_TEMP_SERIAL_NUM');
7099: FND_MSG_PUB.ADD;

Line 7125: AHL_UTIL_UC_PKG.GetCSI_Transaction_ID('ITEM_SERIAL_CHANGE',l_transaction_type_id, l_return_val);

7121: l_csi_transaction_rec.source_transaction_date := sysdate;
7122:
7123: -- get transaction_type_id .
7124: -- Balaji modified the transaction id type to 205--ITEM_SERIAL_CHANGE
7125: AHL_UTIL_UC_PKG.GetCSI_Transaction_ID('ITEM_SERIAL_CHANGE',l_transaction_type_id, l_return_val);
7126: IF NOT(l_return_val) THEN
7127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7128: END IF;
7129: