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_PRD_SERN_CHANGE_PVT dependencies on FND_MESSAGE

Line 35: FND_MESSAGE.Set_Name('AHL','AHL__TXNCODE_INVALID');

31: -- get transaction_type_id .
32: OPEN csi_txn_types_csr(p_txn_code);
33: FETCH csi_txn_types_csr INTO l_txn_type_id;
34: IF (csi_txn_types_csr%NOTFOUND) THEN
35: FND_MESSAGE.Set_Name('AHL','AHL__TXNCODE_INVALID');
36: FND_MESSAGE.Set_Token('CODE',p_txn_code);
37: FND_MSG_PUB.ADD;
38: --dbms_output.put_line('Transaction code not found');
39: l_return_val := FALSE;

Line 36: FND_MESSAGE.Set_Token('CODE',p_txn_code);

32: OPEN csi_txn_types_csr(p_txn_code);
33: FETCH csi_txn_types_csr INTO l_txn_type_id;
34: IF (csi_txn_types_csr%NOTFOUND) THEN
35: FND_MESSAGE.Set_Name('AHL','AHL__TXNCODE_INVALID');
36: FND_MESSAGE.Set_Token('CODE',p_txn_code);
37: FND_MSG_PUB.ADD;
38: --dbms_output.put_line('Transaction code not found');
39: l_return_val := FALSE;
40: END IF;

Line 184: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NULL');

180: -- 3 = Dynamic Entry at inventory receipt.)
181: IF (nvl(p_serial_number_control,0) IN (2,5,6)) THEN
182: -- serial number is mandatory.
183: IF (p_Serial_Number IS NULL) OR (p_Serial_Number = FND_API.G_MISS_CHAR) THEN
184: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NULL');
185: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
186: FND_MSG_PUB.ADD;
187: --dbms_output.put_line('Serial Number is null');
188: ELSE

Line 185: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);

181: IF (nvl(p_serial_number_control,0) IN (2,5,6)) THEN
182: -- serial number is mandatory.
183: IF (p_Serial_Number IS NULL) OR (p_Serial_Number = FND_API.G_MISS_CHAR) THEN
184: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NULL');
185: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
186: FND_MSG_PUB.ADD;
187: --dbms_output.put_line('Serial Number is null');
188: ELSE
189: -- If serial tag code = INVENTORY then validate serial number against inventory.

Line 194: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_INVALID');

190: IF (p_serialnum_tag_code = 'INVENTORY') THEN
191: OPEN mtl_serial_numbers_csr(p_Inventory_id,p_Serial_Number);
192: FETCH mtl_serial_numbers_csr INTO l_junk;
193: IF (mtl_serial_numbers_csr%NOTFOUND) THEN
194: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_INVALID');
195: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
196: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
197: FND_MSG_PUB.ADD;
198: --dbms_output.put_line('Serial Number does not exist in master ');

Line 195: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);

191: OPEN mtl_serial_numbers_csr(p_Inventory_id,p_Serial_Number);
192: FETCH mtl_serial_numbers_csr INTO l_junk;
193: IF (mtl_serial_numbers_csr%NOTFOUND) THEN
194: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_INVALID');
195: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
196: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
197: FND_MSG_PUB.ADD;
198: --dbms_output.put_line('Serial Number does not exist in master ');
199: END IF;

Line 196: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);

192: FETCH mtl_serial_numbers_csr INTO l_junk;
193: IF (mtl_serial_numbers_csr%NOTFOUND) THEN
194: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_INVALID');
195: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
196: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
197: FND_MSG_PUB.ADD;
198: --dbms_output.put_line('Serial Number does not exist in master ');
199: END IF;
200: CLOSE mtl_serial_numbers_csr;

Line 208: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NOTNULL');

204: END IF;
205: ELSE
206: -- if not serialized item, then serial number must be null.
207: IF (p_Serial_Number <> FND_API.G_MISS_CHAR) AND (p_Serial_Number IS NOT NULL) THEN
208: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NOTNULL');
209: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
210: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
211: FND_MSG_PUB.ADD;
212: --dbms_output.put_line('Serial Number is not null');

Line 209: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);

205: ELSE
206: -- if not serialized item, then serial number must be null.
207: IF (p_Serial_Number <> FND_API.G_MISS_CHAR) AND (p_Serial_Number IS NOT NULL) THEN
208: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NOTNULL');
209: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
210: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
211: FND_MSG_PUB.ADD;
212: --dbms_output.put_line('Serial Number is not null');
213: END IF;

Line 210: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);

206: -- if not serialized item, then serial number must be null.
207: IF (p_Serial_Number <> FND_API.G_MISS_CHAR) AND (p_Serial_Number IS NOT NULL) THEN
208: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NOTNULL');
209: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
210: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
211: FND_MSG_PUB.ADD;
212: --dbms_output.put_line('Serial Number is not null');
213: END IF;
214:

Line 641: FND_MESSAGE.Set_Name('AHL','AHL_COM_REQD_PARAM_MISSING');

637: AND
638: l_serialnum_change_rec.OSP_LINE_ID IS NULL
639: )
640: THEN
641: FND_MESSAGE.Set_Name('AHL','AHL_COM_REQD_PARAM_MISSING');
642: FND_MSG_PUB.ADD;
643: RAISE FND_API.G_EXC_ERROR;
644: END IF;
645:

Line 733: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_MISSING');

729: l_serialnum_change_rec.job_number);
730: FETCH get_workorder_csr INTO l_get_workorder_rec;
731: IF l_get_workorder_rec.workorder_id IS NULL
732: THEN
733: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_MISSING');
734: FND_MESSAGE.Set_Token('JOBNUMBER',l_serialnum_change_rec.job_number);
735: FND_MSG_PUB.ADD;
736: CLOSE get_workorder_csr;
737: RAISE FND_API.G_EXC_ERROR;

Line 734: FND_MESSAGE.Set_Token('JOBNUMBER',l_serialnum_change_rec.job_number);

730: FETCH get_workorder_csr INTO l_get_workorder_rec;
731: IF l_get_workorder_rec.workorder_id IS NULL
732: THEN
733: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_MISSING');
734: FND_MESSAGE.Set_Token('JOBNUMBER',l_serialnum_change_rec.job_number);
735: FND_MSG_PUB.ADD;
736: CLOSE get_workorder_csr;
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;

Line 748: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_SNC_UNTLCKD');

744: p_ue_id => NULL,
745: p_visit_id => NULL,
746: p_item_instance_id => NULL);
747: IF l_return_status = FND_API.G_TRUE THEN
748: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_SNC_UNTLCKD');
749: FND_MSG_PUB.ADD;
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;
752:

Line 774: FND_MESSAGE.Set_Name('AHL','AHL_PP_INV_ID_REQUIRED');

770: FETCH c_get_inv_item_id INTO l_new_inventory_item_id;
771: CLOSE c_get_inv_item_id;
772: --l_inventory_item_id := l_new_inventory_item_id;
773: ELSE
774: FND_MESSAGE.Set_Name('AHL','AHL_PP_INV_ID_REQUIRED');
775: FND_MSG_PUB.ADD;
776: RAISE FND_API.G_EXC_ERROR;
777: END IF;
778:

Line 789: FND_MESSAGE.Set_Name('AHL','AHL_INVALID_INSTANCE');

785: CLOSE c_instance_details;
786:
787: IF l_instance_dtls_rec.instance_id IS NULL
788: THEN
789: FND_MESSAGE.Set_Name('AHL','AHL_INVALID_INSTANCE');
790: FND_MSG_PUB.ADD;
791: RAISE FND_API.G_EXC_ERROR;
792: END IF;
793:

Line 805: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INST_LOC_INVALID');

801: THEN
802: -- new message that will be seeded.
803: IF (l_instance_dtls_rec.location_type_code IN ('PO','IN-TRANSIT','PROJECT','INVENTORY'))
804: THEN
805: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INST_LOC_INVALID');
806: FND_MSG_PUB.ADD;
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809: END IF;

Line 826: FND_MESSAGE.Set_Name('AHL','AHL_PRD_CHG_ITEM_INVALID');

822: FETCH c_is_item_valid INTO l_junk;
823: CLOSE c_is_item_valid;
824: IF l_junk IS NULL
825: THEN
826: FND_MESSAGE.Set_Name('AHL','AHL_PRD_CHG_ITEM_INVALID');
827: -- Source or Destination item should be serial controlled.
828: FND_MSG_PUB.ADD;
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;

Line 845: FND_MESSAGE.Set_Name('AHL','AHL_PRD_ITEM_POS_MISMATCH');

841: p_instance_id => l_serialnum_change_rec.instance_id,
842: x_matches_flag => l_matches_flag);
843: IF l_matches_flag = FND_API.G_FALSE
844: THEN
845: FND_MESSAGE.Set_Name('AHL','AHL_PRD_ITEM_POS_MISMATCH');
846: FND_MESSAGE.Set_Token('ITEM',l_serialnum_change_rec.NEW_ITEM_NUMBER);
847: FND_MSG_PUB.ADD;
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;

Line 846: FND_MESSAGE.Set_Token('ITEM',l_serialnum_change_rec.NEW_ITEM_NUMBER);

842: x_matches_flag => l_matches_flag);
843: IF l_matches_flag = FND_API.G_FALSE
844: THEN
845: FND_MESSAGE.Set_Name('AHL','AHL_PRD_ITEM_POS_MISMATCH');
846: FND_MESSAGE.Set_Token('ITEM',l_serialnum_change_rec.NEW_ITEM_NUMBER);
847: FND_MSG_PUB.ADD;
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850: END IF;

Line 871: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TAGMEANING_INVALID');

867: l_serialnum_change_rec.New_Serial_Tag_Mean,
868: l_lookup_code,
869: l_return_val);
870: IF NOT(l_return_val) THEN
871: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TAGMEANING_INVALID');
872: FND_MESSAGE.Set_Token('TAG',l_serialnum_change_rec.New_Serial_Tag_Mean);
873: FND_MSG_PUB.ADD;
874: RAISE FND_API.G_EXC_ERROR;
875: ELSE

Line 872: FND_MESSAGE.Set_Token('TAG',l_serialnum_change_rec.New_Serial_Tag_Mean);

868: l_lookup_code,
869: l_return_val);
870: IF NOT(l_return_val) THEN
871: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TAGMEANING_INVALID');
872: FND_MESSAGE.Set_Token('TAG',l_serialnum_change_rec.New_Serial_Tag_Mean);
873: FND_MSG_PUB.ADD;
874: RAISE FND_API.G_EXC_ERROR;
875: ELSE
876: l_serialnum_change_rec.New_Serial_Tag_Code := l_lookup_code;

Line 952: FND_MESSAGE.Set_Name('AHL','AHL_ATTRIB_CODE_MISSING');

948: IF (l_serialnum_change_rec.New_Serial_Tag_Code IS NOT NULL) THEN
949: -- create extended attributes.
950: GetCSI_Attribute_ID('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);
951: IF NOT(l_return_val) THEN
952: FND_MESSAGE.Set_Name('AHL','AHL_ATTRIB_CODE_MISSING');
953: FND_MESSAGE.Set_Token('CODE', 'AHL_TEMP_SERIAL_NUM');
954: FND_MSG_PUB.ADD;
955: ELSE
956: l_csi_extend_attrib_rec1.attribute_id := l_attribute_id;

Line 953: FND_MESSAGE.Set_Token('CODE', 'AHL_TEMP_SERIAL_NUM');

949: -- create extended attributes.
950: GetCSI_Attribute_ID('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);
951: IF NOT(l_return_val) THEN
952: FND_MESSAGE.Set_Name('AHL','AHL_ATTRIB_CODE_MISSING');
953: FND_MESSAGE.Set_Token('CODE', 'AHL_TEMP_SERIAL_NUM');
954: FND_MSG_PUB.ADD;
955: ELSE
956: l_csi_extend_attrib_rec1.attribute_id := l_attribute_id;
957: l_csi_extend_attrib_rec1.attribute_value := l_serialnum_change_rec.New_Serial_Tag_Code;