APPS.AHL_CMP_PVT dependencies on FND_MESSAGE

Line 354: FND_MESSAGE.Set_Name('AHL','AHL_CMP_MTLXFR_ERROR');

350: IF G_DEBUG='Y' THEN
351: AHL_DEBUG_PUB.debug('Error in transaction['||l_error_msg||']');
352: END IF;
353:
354: FND_MESSAGE.Set_Name('AHL','AHL_CMP_MTLXFR_ERROR');
355: FND_MESSAGE.Set_Token('MSG',l_error_msg);
356: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
357: FND_MSG_PUB.ADD;
358: l_error := true;

Line 355: FND_MESSAGE.Set_Token('MSG',l_error_msg);

351: AHL_DEBUG_PUB.debug('Error in transaction['||l_error_msg||']');
352: END IF;
353:
354: FND_MESSAGE.Set_Name('AHL','AHL_CMP_MTLXFR_ERROR');
355: FND_MESSAGE.Set_Token('MSG',l_error_msg);
356: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
357: FND_MSG_PUB.ADD;
358: l_error := true;
359: END IF;

Line 356: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

352: END IF;
353:
354: FND_MESSAGE.Set_Name('AHL','AHL_CMP_MTLXFR_ERROR');
355: FND_MESSAGE.Set_Token('MSG',l_error_msg);
356: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
357: FND_MSG_PUB.ADD;
358: l_error := true;
359: END IF;
360: CLOSE Txn_Error_cur;

Line 507: FND_MESSAGE.Set_Name('AHL','AHL_CMP_TXNTYPE_NULL');

503: END IF;
504:
505: -- Validate transaction type
506: IF p_x_ahl_mtlxfr_rec.Transaction_Type_Id IS NULL THEN
507: FND_MESSAGE.Set_Name('AHL','AHL_CMP_TXNTYPE_NULL');
508: FND_MSG_PUB.ADD;
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: ELSE
511: OPEN TRX_ACTION_CUR(P_X_AHL_MTLXFR_REC.TRANSACTION_TYPE_ID);

Line 514: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXNTYPE');

510: ELSE
511: OPEN TRX_ACTION_CUR(P_X_AHL_MTLXFR_REC.TRANSACTION_TYPE_ID);
512: FETCH TRX_ACTION_CUR INTO l_txn_type;
513: IF(TRX_ACTION_CUR%NOTFOUND) THEN
514: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXNTYPE');
515: FND_MSG_PUB.ADD;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: END IF;
518: CLOSE TRX_ACTION_CUR;

Line 527: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');

523: AHL_DEBUG_PUB.debug('Validating quantity...['||to_Char(p_x_ahl_mtlxfr_rec.Quantity)||']');
524: END IF;
525:
526: IF(nvl(p_x_ahl_mtlxfr_rec.Quantity,0) <= 0) THEN
527: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');
528: FND_MESSAGE.Set_Token('QUANTITY',p_x_ahl_mtlxfr_rec.Quantity);
529: FND_MSG_PUB.ADD;
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: END IF;

Line 528: FND_MESSAGE.Set_Token('QUANTITY',p_x_ahl_mtlxfr_rec.Quantity);

524: END IF;
525:
526: IF(nvl(p_x_ahl_mtlxfr_rec.Quantity,0) <= 0) THEN
527: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');
528: FND_MESSAGE.Set_Token('QUANTITY',p_x_ahl_mtlxfr_rec.Quantity);
529: FND_MSG_PUB.ADD;
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: END IF;
532:

Line 545: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');

541: OPEN AHL_ITEM_ID_CUR(p_x_ahl_mtlxfr_rec.Organization_ID,
542: p_x_ahl_mtlxfr_rec.Inventory_Item_Id);
543: FETCH AHL_ITEM_ID_CUR INTO l_serial_Control, l_lot_control, l_revision_control, l_location_control, l_primary_uom_code, l_concatenated_segments;
544: IF(AHL_ITEM_ID_CUR%NOTFOUND) THEN
545: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');
546: FND_MESSAGE.Set_Token('FIELD',p_x_ahl_mtlxfr_rec.Inventory_Item_Id);
547: FND_MSG_PUB.ADD;
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: END IF;

Line 546: FND_MESSAGE.Set_Token('FIELD',p_x_ahl_mtlxfr_rec.Inventory_Item_Id);

542: p_x_ahl_mtlxfr_rec.Inventory_Item_Id);
543: FETCH AHL_ITEM_ID_CUR INTO l_serial_Control, l_lot_control, l_revision_control, l_location_control, l_primary_uom_code, l_concatenated_segments;
544: IF(AHL_ITEM_ID_CUR%NOTFOUND) THEN
545: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');
546: FND_MESSAGE.Set_Token('FIELD',p_x_ahl_mtlxfr_rec.Inventory_Item_Id);
547: FND_MSG_PUB.ADD;
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: END IF;
550: CLOSE AHL_ITEM_ID_CUR;

Line 553: FND_MESSAGE.Set_Name('AHL','AHL_CMP_ORG_NULL');

549: END IF;
550: CLOSE AHL_ITEM_ID_CUR;
551: ELSE
552: IF p_x_ahl_mtlxfr_rec.Organization_ID IS NULL THEN
553: FND_MESSAGE.Set_Name('AHL','AHL_CMP_ORG_NULL');
554: FND_MSG_PUB.ADD;
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: END IF;
557: IF p_x_ahl_mtlxfr_rec.Inventory_Item_Id IS NULL THEN

Line 558: FND_MESSAGE.Set_Name('AHL','AHL_CMP_ITEM_NULL');

554: FND_MSG_PUB.ADD;
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: END IF;
557: IF p_x_ahl_mtlxfr_rec.Inventory_Item_Id IS NULL THEN
558: FND_MESSAGE.Set_Name('AHL','AHL_CMP_ITEM_NULL');
559: FND_MSG_PUB.ADD;
560: x_return_status := FND_API.G_RET_STS_ERROR;
561: END IF;
562:

Line 573: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');

569:
570: -- If the item is of serial controlled check if the serial numebr is null
571: IF(p_x_ahl_mtlxfr_rec.Serial_Number IS NULL
572: AND (nvl(l_serial_Control,0) <> nvl(C_NO_SERIAL_CONTROL,0)) ) THEN
573: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');
574: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
575: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
576: FND_MSG_PUB.ADD;
577: x_return_status := FND_API.G_RET_STS_ERROR;

Line 574: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);

570: -- If the item is of serial controlled check if the serial numebr is null
571: IF(p_x_ahl_mtlxfr_rec.Serial_Number IS NULL
572: AND (nvl(l_serial_Control,0) <> nvl(C_NO_SERIAL_CONTROL,0)) ) THEN
573: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');
574: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
575: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
576: FND_MSG_PUB.ADD;
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: END IF;

Line 575: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

571: IF(p_x_ahl_mtlxfr_rec.Serial_Number IS NULL
572: AND (nvl(l_serial_Control,0) <> nvl(C_NO_SERIAL_CONTROL,0)) ) THEN
573: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');
574: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
575: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
576: FND_MSG_PUB.ADD;
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: END IF;
579:

Line 582: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');

578: END IF;
579:
580: IF (p_x_ahl_mtlxfr_rec.Serial_Number IS NOT NULL AND
581: nvl(l_serial_Control,1) = 1) THEN
582: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');
583: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
584: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
585: FND_MSG_PUB.ADD;
586: x_return_status := FND_API.G_RET_STS_ERROR;

Line 583: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);

579:
580: IF (p_x_ahl_mtlxfr_rec.Serial_Number IS NOT NULL AND
581: nvl(l_serial_Control,1) = 1) THEN
582: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');
583: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
584: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
585: FND_MSG_PUB.ADD;
586: x_return_status := FND_API.G_RET_STS_ERROR;
587: END IF;

Line 584: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

580: IF (p_x_ahl_mtlxfr_rec.Serial_Number IS NOT NULL AND
581: nvl(l_serial_Control,1) = 1) THEN
582: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');
583: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
584: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
585: FND_MSG_PUB.ADD;
586: x_return_status := FND_API.G_RET_STS_ERROR;
587: END IF;
588:

Line 598: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');

594: -- If the item is of lot controlled check if the lot number is null
595: IF((p_x_ahl_mtlxfr_rec.Lot_Number IS NULL
596: OR p_x_ahl_mtlxfr_rec.Lot_Number = FND_API.G_MISS_CHAR)
597: AND (l_lot_Control <> C_NO_LOT_CONTROL) ) THEN
598: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');
599: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtlxfr_rec.Lot_Number);
600: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
601: FND_MSG_PUB.ADD;
602: x_return_status := FND_API.G_RET_STS_ERROR;

Line 599: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtlxfr_rec.Lot_Number);

595: IF((p_x_ahl_mtlxfr_rec.Lot_Number IS NULL
596: OR p_x_ahl_mtlxfr_rec.Lot_Number = FND_API.G_MISS_CHAR)
597: AND (l_lot_Control <> C_NO_LOT_CONTROL) ) THEN
598: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');
599: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtlxfr_rec.Lot_Number);
600: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
601: FND_MSG_PUB.ADD;
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: END IF;

Line 600: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

596: OR p_x_ahl_mtlxfr_rec.Lot_Number = FND_API.G_MISS_CHAR)
597: AND (l_lot_Control <> C_NO_LOT_CONTROL) ) THEN
598: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');
599: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtlxfr_rec.Lot_Number);
600: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
601: FND_MSG_PUB.ADD;
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: END IF;
604: -- validate lot number.

Line 611: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');

607: p_x_ahl_mtlxfr_rec.inventory_item_id,
608: p_x_ahl_mtlxfr_rec.Lot_Number);
609: FETCH mtl_lot_num_csr INTO l_junk;
610: IF (mtl_lot_num_csr%NOTFOUND) THEN
611: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');
612: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtlxfr_rec.Lot_Number);
613: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
614: FND_MSG_PUB.ADD;
615: x_return_status := FND_API.G_RET_STS_ERROR;

Line 612: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtlxfr_rec.Lot_Number);

608: p_x_ahl_mtlxfr_rec.Lot_Number);
609: FETCH mtl_lot_num_csr INTO l_junk;
610: IF (mtl_lot_num_csr%NOTFOUND) THEN
611: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');
612: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtlxfr_rec.Lot_Number);
613: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
614: FND_MSG_PUB.ADD;
615: x_return_status := FND_API.G_RET_STS_ERROR;
616: END IF;

Line 613: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

609: FETCH mtl_lot_num_csr INTO l_junk;
610: IF (mtl_lot_num_csr%NOTFOUND) THEN
611: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOT');
612: FND_MESSAGE.Set_Token('LOT',p_x_ahl_mtlxfr_rec.Lot_Number);
613: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
614: FND_MSG_PUB.ADD;
615: x_return_status := FND_API.G_RET_STS_ERROR;
616: END IF;
617: CLOSE mtl_lot_num_csr;

Line 622: FND_MESSAGE.Set_Name('AHL','AHL_PRD_LOT_NOTNULL');

618: END IF;
619:
620: -- raise error if item is not lot controlled.
621: IF (p_x_ahl_mtlxfr_rec.Lot_Number IS NOT NULL AND (l_lot_Control = C_NO_LOT_CONTROL) ) THEN
622: FND_MESSAGE.Set_Name('AHL','AHL_PRD_LOT_NOTNULL');
623: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
624: FND_MSG_PUB.ADD;
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: END IF;

Line 623: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

619:
620: -- raise error if item is not lot controlled.
621: IF (p_x_ahl_mtlxfr_rec.Lot_Number IS NOT NULL AND (l_lot_Control = C_NO_LOT_CONTROL) ) THEN
622: FND_MESSAGE.Set_Name('AHL','AHL_PRD_LOT_NOTNULL');
623: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
624: FND_MSG_PUB.ADD;
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: END IF;
627:

Line 634: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVL_SRC_SUBINV');

630: OPEN AHL_SUBINV_CUR(p_x_ahl_mtlxfr_rec.Organization_ID,
631: p_x_ahl_mtlxfr_rec.Src_Subinv_Name);
632: FETCH AHL_SUBINV_CUR INTO l_Count;
633: IF(AHL_SUBINV_CUR%NOTFOUND) THEN
634: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVL_SRC_SUBINV');
635: FND_MESSAGE.Set_Token('INV',p_x_ahl_mtlxfr_rec.Src_Subinv_Name);
636: FND_MSG_PUB.ADD;
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: END IF;

Line 635: FND_MESSAGE.Set_Token('INV',p_x_ahl_mtlxfr_rec.Src_Subinv_Name);

631: p_x_ahl_mtlxfr_rec.Src_Subinv_Name);
632: FETCH AHL_SUBINV_CUR INTO l_Count;
633: IF(AHL_SUBINV_CUR%NOTFOUND) THEN
634: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVL_SRC_SUBINV');
635: FND_MESSAGE.Set_Token('INV',p_x_ahl_mtlxfr_rec.Src_Subinv_Name);
636: FND_MSG_PUB.ADD;
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: END IF;
639: CLOSE AHL_SUBINV_CUR;

Line 646: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVL_DST_SUBINV');

642: OPEN AHL_SUBINV_CUR(p_x_ahl_mtlxfr_rec.Organization_ID,
643: p_x_ahl_mtlxfr_rec.Dst_SubInv_Name);
644: FETCH AHL_SUBINV_CUR INTO l_Count;
645: IF(AHL_SUBINV_CUR%NOTFOUND) THEN
646: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVL_DST_SUBINV');
647: FND_MESSAGE.Set_Token('INV',p_x_ahl_mtlxfr_rec.Dst_SubInv_Name);
648: FND_MSG_PUB.ADD;
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: END IF;

Line 647: FND_MESSAGE.Set_Token('INV',p_x_ahl_mtlxfr_rec.Dst_SubInv_Name);

643: p_x_ahl_mtlxfr_rec.Dst_SubInv_Name);
644: FETCH AHL_SUBINV_CUR INTO l_Count;
645: IF(AHL_SUBINV_CUR%NOTFOUND) THEN
646: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVL_DST_SUBINV');
647: FND_MESSAGE.Set_Token('INV',p_x_ahl_mtlxfr_rec.Dst_SubInv_Name);
648: FND_MSG_PUB.ADD;
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: END IF;
651: CLOSE AHL_SUBINV_CUR;

Line 658: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVL_SRC_LOCATOR');

654: OPEN AHL_LOCATOR_CUR(p_x_ahl_mtlxfr_rec.Organization_ID,
655: p_x_ahl_mtlxfr_rec.Src_Locator_Id);
656: FETCH AHL_LOCATOR_CUR INTO l_Count;
657: IF(AHL_LOCATOR_CUR%NOTFOUND) THEN
658: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVL_SRC_LOCATOR');
659: FND_MESSAGE.Set_Token('LOC',p_x_ahl_mtlxfr_rec.Src_Locator_Id);
660: FND_MSG_PUB.ADD;
661: x_return_status := FND_API.G_RET_STS_ERROR;
662: END IF;

Line 659: FND_MESSAGE.Set_Token('LOC',p_x_ahl_mtlxfr_rec.Src_Locator_Id);

655: p_x_ahl_mtlxfr_rec.Src_Locator_Id);
656: FETCH AHL_LOCATOR_CUR INTO l_Count;
657: IF(AHL_LOCATOR_CUR%NOTFOUND) THEN
658: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVL_SRC_LOCATOR');
659: FND_MESSAGE.Set_Token('LOC',p_x_ahl_mtlxfr_rec.Src_Locator_Id);
660: FND_MSG_PUB.ADD;
661: x_return_status := FND_API.G_RET_STS_ERROR;
662: END IF;
663: CLOSE AHL_LOCATOR_CUR;

Line 672: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVL_DST_LOCATOR');

668: OPEN AHL_LOCATOR_CUR(p_x_ahl_mtlxfr_rec.Organization_ID,
669: p_x_ahl_mtlxfr_rec.Dst_Locator_Id);
670: FETCH AHL_LOCATOR_CUR INTO l_Count;
671: IF(AHL_LOCATOR_CUR%NOTFOUND) THEN
672: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVL_DST_LOCATOR');
673: FND_MESSAGE.Set_Token('LOC',p_x_ahl_mtlxfr_rec.Dst_Locator_Id);
674: FND_MSG_PUB.ADD;
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: END IF;

Line 673: FND_MESSAGE.Set_Token('LOC',p_x_ahl_mtlxfr_rec.Dst_Locator_Id);

669: p_x_ahl_mtlxfr_rec.Dst_Locator_Id);
670: FETCH AHL_LOCATOR_CUR INTO l_Count;
671: IF(AHL_LOCATOR_CUR%NOTFOUND) THEN
672: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVL_DST_LOCATOR');
673: FND_MESSAGE.Set_Token('LOC',p_x_ahl_mtlxfr_rec.Dst_Locator_Id);
674: FND_MSG_PUB.ADD;
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: END IF;
677: CLOSE AHL_LOCATOR_CUR;

Line 692: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');

688: IF (nvl(l_revision_control, -1) = 2)
689: THEN
690: IF p_x_ahl_mtlxfr_rec.Revision IS NULL
691: THEN
692: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');
693: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtlxfr_rec.Revision);
694: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
695: FND_MSG_PUB.ADD;
696: x_return_status := FND_API.G_RET_STS_ERROR;

Line 693: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtlxfr_rec.Revision);

689: THEN
690: IF p_x_ahl_mtlxfr_rec.Revision IS NULL
691: THEN
692: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');
693: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtlxfr_rec.Revision);
694: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
695: FND_MSG_PUB.ADD;
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: ELSE

Line 694: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

690: IF p_x_ahl_mtlxfr_rec.Revision IS NULL
691: THEN
692: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');
693: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtlxfr_rec.Revision);
694: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
695: FND_MSG_PUB.ADD;
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: ELSE
698: OPEN AHL_REVISION_CUR

Line 707: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');

703: );
704: FETCH AHL_REVISION_CUR INTO l_Count;
705: IF (AHL_REVISION_CUR%NOTFOUND)
706: THEN
707: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');
708: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtlxfr_rec.Revision);
709: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
710: FND_MSG_PUB.ADD;
711: x_return_status := FND_API.G_RET_STS_ERROR;

Line 708: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtlxfr_rec.Revision);

704: FETCH AHL_REVISION_CUR INTO l_Count;
705: IF (AHL_REVISION_CUR%NOTFOUND)
706: THEN
707: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');
708: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtlxfr_rec.Revision);
709: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
710: FND_MSG_PUB.ADD;
711: x_return_status := FND_API.G_RET_STS_ERROR;
712:

Line 709: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

705: IF (AHL_REVISION_CUR%NOTFOUND)
706: THEN
707: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REVISION');
708: FND_MESSAGE.Set_Token('REVISION',p_x_ahl_mtlxfr_rec.Revision);
709: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
710: FND_MSG_PUB.ADD;
711: x_return_status := FND_API.G_RET_STS_ERROR;
712:
713: END IF;

Line 719: FND_MESSAGE.Set_Name('AHL','AHL_PRD_REVNUM_NOTMAND');

715: END IF;
716: ELSE
717: IF p_x_ahl_mtlxfr_rec.Revision IS NOT NULL
718: THEN
719: FND_MESSAGE.Set_Name('AHL','AHL_PRD_REVNUM_NOTMAND');
720: FND_MESSAGE.Set_Token('REV',p_x_ahl_mtlxfr_rec.Revision);
721: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
722: FND_MSG_PUB.ADD;
723: x_return_status := FND_API.G_RET_STS_ERROR;

Line 720: FND_MESSAGE.Set_Token('REV',p_x_ahl_mtlxfr_rec.Revision);

716: ELSE
717: IF p_x_ahl_mtlxfr_rec.Revision IS NOT NULL
718: THEN
719: FND_MESSAGE.Set_Name('AHL','AHL_PRD_REVNUM_NOTMAND');
720: FND_MESSAGE.Set_Token('REV',p_x_ahl_mtlxfr_rec.Revision);
721: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
722: FND_MSG_PUB.ADD;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: END IF;

Line 721: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

717: IF p_x_ahl_mtlxfr_rec.Revision IS NOT NULL
718: THEN
719: FND_MESSAGE.Set_Name('AHL','AHL_PRD_REVNUM_NOTMAND');
720: FND_MESSAGE.Set_Token('REV',p_x_ahl_mtlxfr_rec.Revision);
721: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
722: FND_MSG_PUB.ADD;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: END IF;
725: END IF;

Line 737: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_ITEM_QTY');

733: END IF;
734:
735: IF ((p_x_ahl_mtlxfr_rec.Serial_Number IS NOT NULL) AND nvl(l_serial_Control,1) <> 1) THEN
736: IF (p_x_ahl_mtlxfr_rec.Quantity <> 1) THEN
737: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_ITEM_QTY');
738: FND_MESSAGE.Set_Token('PRIM_UOM',l_primary_uom_code);
739: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
740: FND_MSG_PUB.ADD;
741: x_return_status := FND_API.G_RET_STS_ERROR;

Line 738: FND_MESSAGE.Set_Token('PRIM_UOM',l_primary_uom_code);

734:
735: IF ((p_x_ahl_mtlxfr_rec.Serial_Number IS NOT NULL) AND nvl(l_serial_Control,1) <> 1) THEN
736: IF (p_x_ahl_mtlxfr_rec.Quantity <> 1) THEN
737: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_ITEM_QTY');
738: FND_MESSAGE.Set_Token('PRIM_UOM',l_primary_uom_code);
739: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
740: FND_MSG_PUB.ADD;
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: END IF;

Line 739: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

735: IF ((p_x_ahl_mtlxfr_rec.Serial_Number IS NOT NULL) AND nvl(l_serial_Control,1) <> 1) THEN
736: IF (p_x_ahl_mtlxfr_rec.Quantity <> 1) THEN
737: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_ITEM_QTY');
738: FND_MESSAGE.Set_Token('PRIM_UOM',l_primary_uom_code);
739: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
740: FND_MSG_PUB.ADD;
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: END IF;
743: END IF;

Line 764: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SUB_CODE');

760: END IF;
761:
762: IF (p_x_ahl_mtlxfr_rec.Src_Subinv_Name IS NOT NULL AND
763: p_x_ahl_mtlxfr_rec.Src_Subinv_Name <> l_curr_subinventory_code) THEN
764: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SUB_CODE');
765: FND_MESSAGE.Set_Token('CODE',l_curr_subinventory_code);
766: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
767: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
768: FND_MSG_PUB.ADD;

Line 765: FND_MESSAGE.Set_Token('CODE',l_curr_subinventory_code);

761:
762: IF (p_x_ahl_mtlxfr_rec.Src_Subinv_Name IS NOT NULL AND
763: p_x_ahl_mtlxfr_rec.Src_Subinv_Name <> l_curr_subinventory_code) THEN
764: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SUB_CODE');
765: FND_MESSAGE.Set_Token('CODE',l_curr_subinventory_code);
766: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
767: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
768: FND_MSG_PUB.ADD;
769: x_return_status := FND_API.G_RET_STS_ERROR;

Line 766: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

762: IF (p_x_ahl_mtlxfr_rec.Src_Subinv_Name IS NOT NULL AND
763: p_x_ahl_mtlxfr_rec.Src_Subinv_Name <> l_curr_subinventory_code) THEN
764: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SUB_CODE');
765: FND_MESSAGE.Set_Token('CODE',l_curr_subinventory_code);
766: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
767: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
768: FND_MSG_PUB.ADD;
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: END IF;

Line 767: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);

763: p_x_ahl_mtlxfr_rec.Src_Subinv_Name <> l_curr_subinventory_code) THEN
764: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SUB_CODE');
765: FND_MESSAGE.Set_Token('CODE',l_curr_subinventory_code);
766: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
767: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
768: FND_MSG_PUB.ADD;
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: END IF;
771:

Line 778: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOC_CODE');

774: END IF;
775:
776: IF (p_x_ahl_mtlxfr_rec.Src_Locator_Id IS NOT NULL AND l_curr_locator_id IS NOT NULL AND
777: p_x_ahl_mtlxfr_rec.Src_Locator_Id <> l_curr_locator_id) THEN
778: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOC_CODE');
779: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
780: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
781: FND_MSG_PUB.ADD;
782: x_return_status := FND_API.G_RET_STS_ERROR;

Line 779: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

775:
776: IF (p_x_ahl_mtlxfr_rec.Src_Locator_Id IS NOT NULL AND l_curr_locator_id IS NOT NULL AND
777: p_x_ahl_mtlxfr_rec.Src_Locator_Id <> l_curr_locator_id) THEN
778: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOC_CODE');
779: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
780: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
781: FND_MSG_PUB.ADD;
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: END IF;

Line 780: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);

776: IF (p_x_ahl_mtlxfr_rec.Src_Locator_Id IS NOT NULL AND l_curr_locator_id IS NOT NULL AND
777: p_x_ahl_mtlxfr_rec.Src_Locator_Id <> l_curr_locator_id) THEN
778: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_LOC_CODE');
779: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
780: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
781: FND_MSG_PUB.ADD;
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: END IF;
784: ELSE

Line 786: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');

782: x_return_status := FND_API.G_RET_STS_ERROR;
783: END IF;
784: ELSE
785: -- serial number not found.
786: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');
787: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
788: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
789: FND_MSG_PUB.ADD;
790: x_return_status := FND_API.G_RET_STS_ERROR;

Line 787: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

783: END IF;
784: ELSE
785: -- serial number not found.
786: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');
787: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
788: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
789: FND_MSG_PUB.ADD;
790: x_return_status := FND_API.G_RET_STS_ERROR;
791: END IF;

Line 788: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);

784: ELSE
785: -- serial number not found.
786: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SRLNUM');
787: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
788: FND_MESSAGE.Set_Token('SER',p_x_ahl_mtlxfr_rec.Serial_Number);
789: FND_MSG_PUB.ADD;
790: x_return_status := FND_API.G_RET_STS_ERROR;
791: END IF;
792:

Line 1174: FND_MESSAGE.Set_Name('AHL','AHL_CMP_MTLXFR_ERROR');

1170: IF G_DEBUG='Y' THEN
1171: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn interface' || SQLCODE);
1172: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
1173: END IF;
1174: FND_MESSAGE.Set_Name('AHL','AHL_CMP_MTLXFR_ERROR');
1175: FND_MESSAGE.Set_Token('MSG',SQLERRM);
1176: FND_MESSAGE.Set_Token('ITEM',p_x_ahl_mtlxfr_rec.Inventory_Item_Id);
1177: FND_MSG_PUB.ADD;
1178: RAISE FND_API.G_EXC_ERROR;

Line 1175: FND_MESSAGE.Set_Token('MSG',SQLERRM);

1171: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn interface' || SQLCODE);
1172: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
1173: END IF;
1174: FND_MESSAGE.Set_Name('AHL','AHL_CMP_MTLXFR_ERROR');
1175: FND_MESSAGE.Set_Token('MSG',SQLERRM);
1176: FND_MESSAGE.Set_Token('ITEM',p_x_ahl_mtlxfr_rec.Inventory_Item_Id);
1177: FND_MSG_PUB.ADD;
1178: RAISE FND_API.G_EXC_ERROR;
1179:

Line 1176: FND_MESSAGE.Set_Token('ITEM',p_x_ahl_mtlxfr_rec.Inventory_Item_Id);

1172: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
1173: END IF;
1174: FND_MESSAGE.Set_Name('AHL','AHL_CMP_MTLXFR_ERROR');
1175: FND_MESSAGE.Set_Token('MSG',SQLERRM);
1176: FND_MESSAGE.Set_Token('ITEM',p_x_ahl_mtlxfr_rec.Inventory_Item_Id);
1177: FND_MSG_PUB.ADD;
1178: RAISE FND_API.G_EXC_ERROR;
1179:
1180: END INSERT_MTL_TXN_INTF;

Line 1472: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');

1468: -- item and instance are invalid
1469: IF (l_log_statement >= l_log_current_level) THEN
1470: FND_LOG.string(l_log_statement, l_full_name, 'item and instance are invalid');
1471: END IF;
1472: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1473: FND_MESSAGE.Set_Token('NAME', 'p_inv_item_id');
1474: FND_MESSAGE.Set_Token('VALUE', p_inv_item_id);
1475: FND_MSG_PUB.ADD;
1476: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');

Line 1473: FND_MESSAGE.Set_Token('NAME', 'p_inv_item_id');

1469: IF (l_log_statement >= l_log_current_level) THEN
1470: FND_LOG.string(l_log_statement, l_full_name, 'item and instance are invalid');
1471: END IF;
1472: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1473: FND_MESSAGE.Set_Token('NAME', 'p_inv_item_id');
1474: FND_MESSAGE.Set_Token('VALUE', p_inv_item_id);
1475: FND_MSG_PUB.ADD;
1476: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1477: FND_MESSAGE.Set_Token('NAME', 'p_item_mstr_org_id');

Line 1474: FND_MESSAGE.Set_Token('VALUE', p_inv_item_id);

1470: FND_LOG.string(l_log_statement, l_full_name, 'item and instance are invalid');
1471: END IF;
1472: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1473: FND_MESSAGE.Set_Token('NAME', 'p_inv_item_id');
1474: FND_MESSAGE.Set_Token('VALUE', p_inv_item_id);
1475: FND_MSG_PUB.ADD;
1476: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1477: FND_MESSAGE.Set_Token('NAME', 'p_item_mstr_org_id');
1478: FND_MESSAGE.Set_Token('VALUE', p_item_mstr_org_id);

Line 1476: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');

1472: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1473: FND_MESSAGE.Set_Token('NAME', 'p_inv_item_id');
1474: FND_MESSAGE.Set_Token('VALUE', p_inv_item_id);
1475: FND_MSG_PUB.ADD;
1476: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1477: FND_MESSAGE.Set_Token('NAME', 'p_item_mstr_org_id');
1478: FND_MESSAGE.Set_Token('VALUE', p_item_mstr_org_id);
1479: FND_MSG_PUB.ADD;
1480: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');

Line 1477: FND_MESSAGE.Set_Token('NAME', 'p_item_mstr_org_id');

1473: FND_MESSAGE.Set_Token('NAME', 'p_inv_item_id');
1474: FND_MESSAGE.Set_Token('VALUE', p_inv_item_id);
1475: FND_MSG_PUB.ADD;
1476: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1477: FND_MESSAGE.Set_Token('NAME', 'p_item_mstr_org_id');
1478: FND_MESSAGE.Set_Token('VALUE', p_item_mstr_org_id);
1479: FND_MSG_PUB.ADD;
1480: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1481: FND_MESSAGE.Set_Token('NAME', 'p_item_inv_org_id');

Line 1478: FND_MESSAGE.Set_Token('VALUE', p_item_mstr_org_id);

1474: FND_MESSAGE.Set_Token('VALUE', p_inv_item_id);
1475: FND_MSG_PUB.ADD;
1476: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1477: FND_MESSAGE.Set_Token('NAME', 'p_item_mstr_org_id');
1478: FND_MESSAGE.Set_Token('VALUE', p_item_mstr_org_id);
1479: FND_MSG_PUB.ADD;
1480: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1481: FND_MESSAGE.Set_Token('NAME', 'p_item_inv_org_id');
1482: FND_MESSAGE.Set_Token('VALUE', p_item_inv_org_id);

Line 1480: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');

1476: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1477: FND_MESSAGE.Set_Token('NAME', 'p_item_mstr_org_id');
1478: FND_MESSAGE.Set_Token('VALUE', p_item_mstr_org_id);
1479: FND_MSG_PUB.ADD;
1480: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1481: FND_MESSAGE.Set_Token('NAME', 'p_item_inv_org_id');
1482: FND_MESSAGE.Set_Token('VALUE', p_item_inv_org_id);
1483: FND_MSG_PUB.ADD;
1484: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');

Line 1481: FND_MESSAGE.Set_Token('NAME', 'p_item_inv_org_id');

1477: FND_MESSAGE.Set_Token('NAME', 'p_item_mstr_org_id');
1478: FND_MESSAGE.Set_Token('VALUE', p_item_mstr_org_id);
1479: FND_MSG_PUB.ADD;
1480: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1481: FND_MESSAGE.Set_Token('NAME', 'p_item_inv_org_id');
1482: FND_MESSAGE.Set_Token('VALUE', p_item_inv_org_id);
1483: FND_MSG_PUB.ADD;
1484: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1485: FND_MESSAGE.Set_Token('NAME', 'p_instance_id');

Line 1482: FND_MESSAGE.Set_Token('VALUE', p_item_inv_org_id);

1478: FND_MESSAGE.Set_Token('VALUE', p_item_mstr_org_id);
1479: FND_MSG_PUB.ADD;
1480: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1481: FND_MESSAGE.Set_Token('NAME', 'p_item_inv_org_id');
1482: FND_MESSAGE.Set_Token('VALUE', p_item_inv_org_id);
1483: FND_MSG_PUB.ADD;
1484: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1485: FND_MESSAGE.Set_Token('NAME', 'p_instance_id');
1486: FND_MESSAGE.Set_Token('VALUE', p_instance_id);

Line 1484: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');

1480: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1481: FND_MESSAGE.Set_Token('NAME', 'p_item_inv_org_id');
1482: FND_MESSAGE.Set_Token('VALUE', p_item_inv_org_id);
1483: FND_MSG_PUB.ADD;
1484: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1485: FND_MESSAGE.Set_Token('NAME', 'p_instance_id');
1486: FND_MESSAGE.Set_Token('VALUE', p_instance_id);
1487: FND_MSG_PUB.ADD;
1488: END IF;

Line 1485: FND_MESSAGE.Set_Token('NAME', 'p_instance_id');

1481: FND_MESSAGE.Set_Token('NAME', 'p_item_inv_org_id');
1482: FND_MESSAGE.Set_Token('VALUE', p_item_inv_org_id);
1483: FND_MSG_PUB.ADD;
1484: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1485: FND_MESSAGE.Set_Token('NAME', 'p_instance_id');
1486: FND_MESSAGE.Set_Token('VALUE', p_instance_id);
1487: FND_MSG_PUB.ADD;
1488: END IF;
1489: CLOSE get_item_inst_det_csr;

Line 1486: FND_MESSAGE.Set_Token('VALUE', p_instance_id);

1482: FND_MESSAGE.Set_Token('VALUE', p_item_inv_org_id);
1483: FND_MSG_PUB.ADD;
1484: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1485: FND_MESSAGE.Set_Token('NAME', 'p_instance_id');
1486: FND_MESSAGE.Set_Token('VALUE', p_instance_id);
1487: FND_MSG_PUB.ADD;
1488: END IF;
1489: CLOSE get_item_inst_det_csr;
1490:

Line 1497: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');

1493: -- operation flag is invalid
1494: IF (l_log_statement >= l_log_current_level) THEN
1495: FND_LOG.string(l_log_statement, l_full_name, 'operation flag is invalid');
1496: END IF;
1497: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1498: FND_MESSAGE.Set_Token('NAME', 'p_opr_flag');
1499: FND_MESSAGE.Set_Token('VALUE', p_opr_flag);
1500: FND_MSG_PUB.ADD;
1501: END IF;

Line 1498: FND_MESSAGE.Set_Token('NAME', 'p_opr_flag');

1494: IF (l_log_statement >= l_log_current_level) THEN
1495: FND_LOG.string(l_log_statement, l_full_name, 'operation flag is invalid');
1496: END IF;
1497: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1498: FND_MESSAGE.Set_Token('NAME', 'p_opr_flag');
1499: FND_MESSAGE.Set_Token('VALUE', p_opr_flag);
1500: FND_MSG_PUB.ADD;
1501: END IF;
1502:

Line 1499: FND_MESSAGE.Set_Token('VALUE', p_opr_flag);

1495: FND_LOG.string(l_log_statement, l_full_name, 'operation flag is invalid');
1496: END IF;
1497: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1498: FND_MESSAGE.Set_Token('NAME', 'p_opr_flag');
1499: FND_MESSAGE.Set_Token('VALUE', p_opr_flag);
1500: FND_MSG_PUB.ADD;
1501: END IF;
1502:
1503: -- 3) Validate the source sub-inventory locator

Line 1511: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');

1507: -- source sub-inventory locator is invalid
1508: IF (l_log_statement >= l_log_current_level) THEN
1509: FND_LOG.string(l_log_statement, l_full_name, 'source sub-inventory locator is invalid');
1510: END IF;
1511: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1512: FND_MESSAGE.Set_Token('NAME', 'p_src_subinv_name');
1513: FND_MESSAGE.Set_Token('VALUE', p_src_subinv_name);
1514: FND_MSG_PUB.ADD;
1515: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');

Line 1512: FND_MESSAGE.Set_Token('NAME', 'p_src_subinv_name');

1508: IF (l_log_statement >= l_log_current_level) THEN
1509: FND_LOG.string(l_log_statement, l_full_name, 'source sub-inventory locator is invalid');
1510: END IF;
1511: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1512: FND_MESSAGE.Set_Token('NAME', 'p_src_subinv_name');
1513: FND_MESSAGE.Set_Token('VALUE', p_src_subinv_name);
1514: FND_MSG_PUB.ADD;
1515: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1516: FND_MESSAGE.Set_Token('NAME', 'p_src_locator_id');

Line 1513: FND_MESSAGE.Set_Token('VALUE', p_src_subinv_name);

1509: FND_LOG.string(l_log_statement, l_full_name, 'source sub-inventory locator is invalid');
1510: END IF;
1511: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1512: FND_MESSAGE.Set_Token('NAME', 'p_src_subinv_name');
1513: FND_MESSAGE.Set_Token('VALUE', p_src_subinv_name);
1514: FND_MSG_PUB.ADD;
1515: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1516: FND_MESSAGE.Set_Token('NAME', 'p_src_locator_id');
1517: FND_MESSAGE.Set_Token('VALUE', p_src_locator_id);

Line 1515: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');

1511: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1512: FND_MESSAGE.Set_Token('NAME', 'p_src_subinv_name');
1513: FND_MESSAGE.Set_Token('VALUE', p_src_subinv_name);
1514: FND_MSG_PUB.ADD;
1515: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1516: FND_MESSAGE.Set_Token('NAME', 'p_src_locator_id');
1517: FND_MESSAGE.Set_Token('VALUE', p_src_locator_id);
1518: FND_MSG_PUB.ADD;
1519: END IF;

Line 1516: FND_MESSAGE.Set_Token('NAME', 'p_src_locator_id');

1512: FND_MESSAGE.Set_Token('NAME', 'p_src_subinv_name');
1513: FND_MESSAGE.Set_Token('VALUE', p_src_subinv_name);
1514: FND_MSG_PUB.ADD;
1515: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1516: FND_MESSAGE.Set_Token('NAME', 'p_src_locator_id');
1517: FND_MESSAGE.Set_Token('VALUE', p_src_locator_id);
1518: FND_MSG_PUB.ADD;
1519: END IF;
1520: CLOSE chk_locator_csr;

Line 1517: FND_MESSAGE.Set_Token('VALUE', p_src_locator_id);

1513: FND_MESSAGE.Set_Token('VALUE', p_src_subinv_name);
1514: FND_MSG_PUB.ADD;
1515: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1516: FND_MESSAGE.Set_Token('NAME', 'p_src_locator_id');
1517: FND_MESSAGE.Set_Token('VALUE', p_src_locator_id);
1518: FND_MSG_PUB.ADD;
1519: END IF;
1520: CLOSE chk_locator_csr;
1521:

Line 1531: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');

1527: -- source repair batch name is invalid
1528: IF (l_log_statement >= l_log_current_level) THEN
1529: FND_LOG.string(l_log_statement, l_full_name, 'source repair batch name is invalid');
1530: END IF;
1531: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1532: FND_MESSAGE.Set_Token('NAME', 'p_src_rpr_batch_name');
1533: FND_MESSAGE.Set_Token('VALUE', p_src_rpr_batch_name);
1534: FND_MSG_PUB.ADD;
1535: END IF;

Line 1532: FND_MESSAGE.Set_Token('NAME', 'p_src_rpr_batch_name');

1528: IF (l_log_statement >= l_log_current_level) THEN
1529: FND_LOG.string(l_log_statement, l_full_name, 'source repair batch name is invalid');
1530: END IF;
1531: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1532: FND_MESSAGE.Set_Token('NAME', 'p_src_rpr_batch_name');
1533: FND_MESSAGE.Set_Token('VALUE', p_src_rpr_batch_name);
1534: FND_MSG_PUB.ADD;
1535: END IF;
1536: CLOSE chk_rpr_batch_csr;

Line 1533: FND_MESSAGE.Set_Token('VALUE', p_src_rpr_batch_name);

1529: FND_LOG.string(l_log_statement, l_full_name, 'source repair batch name is invalid');
1530: END IF;
1531: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_API_PARAMETER_INVALID');
1532: FND_MESSAGE.Set_Token('NAME', 'p_src_rpr_batch_name');
1533: FND_MESSAGE.Set_Token('VALUE', p_src_rpr_batch_name);
1534: FND_MSG_PUB.ADD;
1535: END IF;
1536: CLOSE chk_rpr_batch_csr;
1537: END IF;

Line 1558: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_RPR_QTY_INVLD');

1554: IF (l_log_statement >= l_log_current_level) THEN
1555: FND_LOG.string(l_log_statement, l_full_name, 'repair quantity is NULL or greater than instance quantity');
1556: END IF;
1557: -- Please enter a positive number for the repair quantity, less than or equal to the instance quantity.
1558: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_RPR_QTY_INVLD');
1559: FND_MSG_PUB.ADD;
1560: RAISE FND_API.G_EXC_ERROR;
1561: ELSIF (p_repair_qty IS NOT NULL AND p_repair_qty = l_item_inst_det_csr.quantity) THEN
1562: -- if the repair status is 'PLANNING' or 'PRODUCTION', then check the workorders for the instance

Line 1573: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_COMP_QTY_INVLD');

1569: IF (l_log_statement >= l_log_current_level) THEN
1570: FND_LOG.string(l_log_statement, l_full_name, 'repair quantity cant be complete');
1571: END IF;
1572: -- Please complete the open workorders for the instance before moving complete quantity.
1573: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_COMP_QTY_INVLD');
1574: FND_MSG_PUB.ADD;
1575: RAISE FND_API.G_EXC_ERROR;
1576: END IF;
1577: l_dummy := NULL;

Line 1594: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_RPR_BATCH_INVLD');

1590: IF (l_log_statement >= l_log_current_level) THEN
1591: FND_LOG.string(l_log_statement, l_full_name, 'destination repair batch name is invalid');
1592: END IF;
1593: -- The repair batch REPAIR_BATCH is invalid for the item ITEM.
1594: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_RPR_BATCH_INVLD');
1595: FND_MESSAGE.Set_Token('REPAIR_BATCH', p_x_dst_rpr_batch_name);
1596: FND_MESSAGE.Set_Token('ITEM', l_item_inst_det_csr.concatenated_segments);
1597: FND_MSG_PUB.ADD;
1598: RAISE FND_API.G_EXC_ERROR;

Line 1595: FND_MESSAGE.Set_Token('REPAIR_BATCH', p_x_dst_rpr_batch_name);

1591: FND_LOG.string(l_log_statement, l_full_name, 'destination repair batch name is invalid');
1592: END IF;
1593: -- The repair batch REPAIR_BATCH is invalid for the item ITEM.
1594: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_RPR_BATCH_INVLD');
1595: FND_MESSAGE.Set_Token('REPAIR_BATCH', p_x_dst_rpr_batch_name);
1596: FND_MESSAGE.Set_Token('ITEM', l_item_inst_det_csr.concatenated_segments);
1597: FND_MSG_PUB.ADD;
1598: RAISE FND_API.G_EXC_ERROR;
1599: END IF;

Line 1596: FND_MESSAGE.Set_Token('ITEM', l_item_inst_det_csr.concatenated_segments);

1592: END IF;
1593: -- The repair batch REPAIR_BATCH is invalid for the item ITEM.
1594: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_RPR_BATCH_INVLD');
1595: FND_MESSAGE.Set_Token('REPAIR_BATCH', p_x_dst_rpr_batch_name);
1596: FND_MESSAGE.Set_Token('ITEM', l_item_inst_det_csr.concatenated_segments);
1597: FND_MSG_PUB.ADD;
1598: RAISE FND_API.G_EXC_ERROR;
1599: END IF;
1600: CLOSE chk_rpr_batch_csr;

Line 1608: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_LOT_UPDATE_INVLD');

1604: IF (l_log_statement >= l_log_current_level) THEN
1605: FND_LOG.string(l_log_statement, l_full_name, 'repair batch update not allowed for lot controlled items');
1606: END IF;
1607: -- The repair batch REPAIR_BATCH can contain only one lot-controlled item instance.
1608: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_LOT_UPDATE_INVLD');
1609: FND_MESSAGE.Set_Token('REPAIR_BATCH', p_x_dst_rpr_batch_name);
1610: FND_MSG_PUB.ADD;
1611: RAISE FND_API.G_EXC_ERROR;
1612: END IF;

Line 1609: FND_MESSAGE.Set_Token('REPAIR_BATCH', p_x_dst_rpr_batch_name);

1605: FND_LOG.string(l_log_statement, l_full_name, 'repair batch update not allowed for lot controlled items');
1606: END IF;
1607: -- The repair batch REPAIR_BATCH can contain only one lot-controlled item instance.
1608: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_LOT_UPDATE_INVLD');
1609: FND_MESSAGE.Set_Token('REPAIR_BATCH', p_x_dst_rpr_batch_name);
1610: FND_MSG_PUB.ADD;
1611: RAISE FND_API.G_EXC_ERROR;
1612: END IF;
1613:

Line 1623: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_CANNOT_ADD_INSTANCES');

1619: IF (l_log_statement >= l_log_current_level) THEN
1620: FND_LOG.string(l_log_statement, l_full_name, 'destination repair batch belongs to a past dated visit.');
1621: END IF;
1622: -- Cannot add instances to the repair batch REPAIR_BATCH as it belongs to a past dated visit.
1623: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_CANNOT_ADD_INSTANCES');
1624: FND_MESSAGE.Set_Token('REPAIR_BATCH', p_x_dst_rpr_batch_name);
1625: FND_MSG_PUB.ADD;
1626: RAISE FND_API.G_EXC_ERROR;
1627: END IF;

Line 1624: FND_MESSAGE.Set_Token('REPAIR_BATCH', p_x_dst_rpr_batch_name);

1620: FND_LOG.string(l_log_statement, l_full_name, 'destination repair batch belongs to a past dated visit.');
1621: END IF;
1622: -- Cannot add instances to the repair batch REPAIR_BATCH as it belongs to a past dated visit.
1623: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_CANNOT_ADD_INSTANCES');
1624: FND_MESSAGE.Set_Token('REPAIR_BATCH', p_x_dst_rpr_batch_name);
1625: FND_MSG_PUB.ADD;
1626: RAISE FND_API.G_EXC_ERROR;
1627: END IF;
1628: CLOSE Check_Past_Dated_Visit;

Line 1649: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_COMP_VISIT_NULL');

1645: OPEN get_org_name_csr (p_item_inv_org_id);
1646: FETCH get_org_name_csr INTO l_org_name;
1647: CLOSE get_org_name_csr;
1648: -- No valid Component Visit exists for the organization 'ORG_NAME'.
1649: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_COMP_VISIT_NULL');
1650: FND_MESSAGE.Set_Token('ORG_NAME', l_org_name);
1651: FND_MSG_PUB.ADD;
1652: RAISE FND_API.G_EXC_ERROR;
1653: END IF;

Line 1650: FND_MESSAGE.Set_Token('ORG_NAME', l_org_name);

1646: FETCH get_org_name_csr INTO l_org_name;
1647: CLOSE get_org_name_csr;
1648: -- No valid Component Visit exists for the organization 'ORG_NAME'.
1649: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CMP_COMP_VISIT_NULL');
1650: FND_MESSAGE.Set_Token('ORG_NAME', l_org_name);
1651: FND_MSG_PUB.ADD;
1652: RAISE FND_API.G_EXC_ERROR;
1653: END IF;
1654:

Line 2059: FND_MESSAGE.SET_NAME('AHL','AHL_CMP_CANNOT_CLOSE');

2055: FETCH get_batch_details INTO l_batch_dtl_rec;
2056: CLOSE get_batch_details;
2057:
2058: IF l_batch_dtl_rec.status_code IS NOT NULL AND l_batch_dtl_rec.status_code IN ('CLOSED','CANCELLED','DELETED') THEN
2059: FND_MESSAGE.SET_NAME('AHL','AHL_CMP_CANNOT_CLOSE');
2060: FND_MESSAGE.Set_Token('BATCH', l_batch_dtl_rec.repair_batch_name);
2061: FND_MSG_PUB.ADD;
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;

Line 2060: FND_MESSAGE.Set_Token('BATCH', l_batch_dtl_rec.repair_batch_name);

2056: CLOSE get_batch_details;
2057:
2058: IF l_batch_dtl_rec.status_code IS NOT NULL AND l_batch_dtl_rec.status_code IN ('CLOSED','CANCELLED','DELETED') THEN
2059: FND_MESSAGE.SET_NAME('AHL','AHL_CMP_CANNOT_CLOSE');
2060: FND_MESSAGE.Set_Token('BATCH', l_batch_dtl_rec.repair_batch_name);
2061: FND_MSG_PUB.ADD;
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;
2064:

Line 2081: FND_MESSAGE.SET_NAME('AHL','AHL_CMP_BATCH_QTY_NOT_ZERO');

2077: IF l_close_wo_flag THEN -- Either all the associated Workorders have come to an end state(Complete,Closed,Cancelled,Complete-No-Charge)/no workorders have been associated.
2078:
2079: l_batch_qty := AHL_CMP_UTIL_PKG.Get_Batch_Qty(l_batch_dtl_rec.repair_batch_name);
2080: IF l_batch_qty <> 0 THEN
2081: FND_MESSAGE.SET_NAME('AHL','AHL_CMP_BATCH_QTY_NOT_ZERO');
2082: FND_MESSAGE.Set_Token('BATCH', l_batch_dtl_rec.repair_batch_name);
2083: FND_MSG_PUB.ADD;
2084: RAISE FND_API.G_EXC_ERROR;
2085: END IF;

Line 2082: FND_MESSAGE.Set_Token('BATCH', l_batch_dtl_rec.repair_batch_name);

2078:
2079: l_batch_qty := AHL_CMP_UTIL_PKG.Get_Batch_Qty(l_batch_dtl_rec.repair_batch_name);
2080: IF l_batch_qty <> 0 THEN
2081: FND_MESSAGE.SET_NAME('AHL','AHL_CMP_BATCH_QTY_NOT_ZERO');
2082: FND_MESSAGE.Set_Token('BATCH', l_batch_dtl_rec.repair_batch_name);
2083: FND_MSG_PUB.ADD;
2084: RAISE FND_API.G_EXC_ERROR;
2085: END IF;
2086:

Line 2089: FND_MESSAGE.SET_NAME('AHL','AHL_CMP_WO_QTY_NOT_ZERO');

2085: END IF;
2086:
2087: l_batch_wo_qty := AHL_CMP_UTIL_PKG.Get_Workorder_Qty(l_batch_dtl_rec.repair_batch_name);
2088: IF l_batch_wo_qty <> 0 THEN
2089: FND_MESSAGE.SET_NAME('AHL','AHL_CMP_WO_QTY_NOT_ZERO');
2090: FND_MESSAGE.Set_Token('BATCH', l_batch_dtl_rec.repair_batch_name);
2091: FND_MSG_PUB.ADD;
2092: RAISE FND_API.G_EXC_ERROR;
2093: END IF;

Line 2090: FND_MESSAGE.Set_Token('BATCH', l_batch_dtl_rec.repair_batch_name);

2086:
2087: l_batch_wo_qty := AHL_CMP_UTIL_PKG.Get_Workorder_Qty(l_batch_dtl_rec.repair_batch_name);
2088: IF l_batch_wo_qty <> 0 THEN
2089: FND_MESSAGE.SET_NAME('AHL','AHL_CMP_WO_QTY_NOT_ZERO');
2090: FND_MESSAGE.Set_Token('BATCH', l_batch_dtl_rec.repair_batch_name);
2091: FND_MSG_PUB.ADD;
2092: RAISE FND_API.G_EXC_ERROR;
2093: END IF;
2094:

Line 2193: FND_MESSAGE.SET_NAME('AHL','AHL_CMP_OPEN_WO_EXISTS'); --Repair Batch cannot be Closed as it has Open workorders.

2189: WHERE visit_task_id = p_repair_batch_id ;
2190:
2191: ELSE
2192:
2193: FND_MESSAGE.SET_NAME('AHL','AHL_CMP_OPEN_WO_EXISTS'); --Repair Batch cannot be Closed as it has Open workorders.
2194: FND_MESSAGE.Set_Token('REPAIR_BATCH', l_batch_dtl_rec.repair_batch_name);
2195: FND_MSG_PUB.ADD;
2196: RAISE FND_API.G_EXC_ERROR;
2197: END IF;

Line 2194: FND_MESSAGE.Set_Token('REPAIR_BATCH', l_batch_dtl_rec.repair_batch_name);

2190:
2191: ELSE
2192:
2193: FND_MESSAGE.SET_NAME('AHL','AHL_CMP_OPEN_WO_EXISTS'); --Repair Batch cannot be Closed as it has Open workorders.
2194: FND_MESSAGE.Set_Token('REPAIR_BATCH', l_batch_dtl_rec.repair_batch_name);
2195: FND_MSG_PUB.ADD;
2196: RAISE FND_API.G_EXC_ERROR;
2197: END IF;
2198:

Line 2753: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_DELETED');

2749: FETCH get_csi_obj_ver_num INTO l_dummy;
2750:
2751: IF (get_csi_obj_ver_num%NOTFOUND) THEN
2752: CLOSE get_csi_obj_ver_num;
2753: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_DELETED');
2754: FND_MSG_PUB.add;
2755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2756: ELSE
2757: CLOSE get_csi_obj_ver_num;

Line 2966: FND_MESSAGE.set_name('AHL', 'AHL_UC_ATTRIB_CODE_MISSING');

2962:
2963: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_MFG_DATE', l_attribute_id, l_return_val);
2964:
2965: IF NOT(l_return_val) THEN
2966: FND_MESSAGE.set_name('AHL', 'AHL_UC_ATTRIB_CODE_MISSING');
2967: FND_MESSAGE.set_token('CODE', 'AHL_MFG_DATE');
2968: FND_MSG_PUB.ADD;
2969: RAISE FND_API.G_EXC_ERROR;
2970: ELSE

Line 2967: FND_MESSAGE.set_token('CODE', 'AHL_MFG_DATE');

2963: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_MFG_DATE', l_attribute_id, l_return_val);
2964:
2965: IF NOT(l_return_val) THEN
2966: FND_MESSAGE.set_name('AHL', 'AHL_UC_ATTRIB_CODE_MISSING');
2967: FND_MESSAGE.set_token('CODE', 'AHL_MFG_DATE');
2968: FND_MSG_PUB.ADD;
2969: RAISE FND_API.G_EXC_ERROR;
2970: ELSE
2971: l_csi_extend_attrib_rec.attribute_id := l_attribute_id;

Line 2997: FND_MESSAGE.Set_Name('AHL', 'AHL_UC_TXNCODE_INVALID');

2993: -- Build CSI transaction record, first get transaction_type_id
2994: AHL_UTIL_UC_PKG.getcsi_transaction_id('CMRO_MAINTENANCE_WORK_ORDER', l_transaction_type_id, l_return_val);
2995:
2996: IF NOT(l_return_val) THEN
2997: FND_MESSAGE.Set_Name('AHL', 'AHL_UC_TXNCODE_INVALID');
2998: FND_MESSAGE.Set_Token('CODE', 'CMRO_MAINTENANCE_WORK_ORDER');
2999: FND_MSG_PUB.ADD;
3000: RAISE FND_API.G_EXC_ERROR;
3001: END IF;

Line 2998: FND_MESSAGE.Set_Token('CODE', 'CMRO_MAINTENANCE_WORK_ORDER');

2994: AHL_UTIL_UC_PKG.getcsi_transaction_id('CMRO_MAINTENANCE_WORK_ORDER', l_transaction_type_id, l_return_val);
2995:
2996: IF NOT(l_return_val) THEN
2997: FND_MESSAGE.Set_Name('AHL', 'AHL_UC_TXNCODE_INVALID');
2998: FND_MESSAGE.Set_Token('CODE', 'CMRO_MAINTENANCE_WORK_ORDER');
2999: FND_MSG_PUB.ADD;
3000: RAISE FND_API.G_EXC_ERROR;
3001: END IF;
3002:

Line 3321: FND_MESSAGE.Set_Name('AHL','AHL_CMP_RTN_QTY_NULL'); -- Return quantity cannot be null.

3317: AHL_DEBUG_PUB.debug('Validating quantity...['||to_Char(p_x_ahl_mtlrtn_rec.Return_Qty)||']');
3318: END IF;
3319:
3320: IF p_x_ahl_mtlrtn_rec.Return_Qty IS NULL THEN
3321: FND_MESSAGE.Set_Name('AHL','AHL_CMP_RTN_QTY_NULL'); -- Return quantity cannot be null.
3322: FND_MSG_PUB.ADD;
3323: x_return_status := FND_API.G_RET_STS_ERROR;
3324: ELSIF p_x_ahl_mtlrtn_rec.Return_Qty <= 0 THEN
3325: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVALID_RTN_QTY'); -- Invalid Return quantity specified.

Line 3325: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVALID_RTN_QTY'); -- Invalid Return quantity specified.

3321: FND_MESSAGE.Set_Name('AHL','AHL_CMP_RTN_QTY_NULL'); -- Return quantity cannot be null.
3322: FND_MSG_PUB.ADD;
3323: x_return_status := FND_API.G_RET_STS_ERROR;
3324: ELSIF p_x_ahl_mtlrtn_rec.Return_Qty <= 0 THEN
3325: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVALID_RTN_QTY'); -- Invalid Return quantity specified.
3326: FND_MESSAGE.Set_Token('QUANTITY',p_x_ahl_mtlrtn_rec.Return_Qty);
3327: FND_MSG_PUB.ADD;
3328: x_return_status := FND_API.G_RET_STS_ERROR;
3329: END IF;

Line 3326: FND_MESSAGE.Set_Token('QUANTITY',p_x_ahl_mtlrtn_rec.Return_Qty);

3322: FND_MSG_PUB.ADD;
3323: x_return_status := FND_API.G_RET_STS_ERROR;
3324: ELSIF p_x_ahl_mtlrtn_rec.Return_Qty <= 0 THEN
3325: FND_MESSAGE.Set_Name('AHL','AHL_CMP_INVALID_RTN_QTY'); -- Invalid Return quantity specified.
3326: FND_MESSAGE.Set_Token('QUANTITY',p_x_ahl_mtlrtn_rec.Return_Qty);
3327: FND_MSG_PUB.ADD;
3328: x_return_status := FND_API.G_RET_STS_ERROR;
3329: END IF;
3330:

Line 3333: FND_MESSAGE.Set_Name('AHL','AHL_CMP_RTNQTY_GRTR_INSTQTY'); -- Return quantity cannot be greater than instance quantity.

3329: END IF;
3330:
3331: IF p_x_ahl_mtlrtn_rec.Instance_Qty IS NOT NULL THEN
3332: IF p_x_ahl_mtlrtn_rec.Return_Qty > p_x_ahl_mtlrtn_rec.Instance_Qty THEN
3333: FND_MESSAGE.Set_Name('AHL','AHL_CMP_RTNQTY_GRTR_INSTQTY'); -- Return quantity cannot be greater than instance quantity.
3334: FND_MSG_PUB.ADD;
3335: x_return_status := FND_API.G_RET_STS_ERROR;
3336: END IF;
3337: END IF;

Line 3340: FND_MESSAGE.Set_Name('AHL','AHL_CMP_RET_COND_NULL'); -- Condition cannot be null.

3336: END IF;
3337: END IF;
3338:
3339: IF p_x_ahl_mtlrtn_rec.Return_Condition IS NULL THEN
3340: FND_MESSAGE.Set_Name('AHL','AHL_CMP_RET_COND_NULL'); -- Condition cannot be null.
3341: FND_MSG_PUB.ADD;
3342: x_return_status := FND_API.G_RET_STS_ERROR;
3343: END IF;
3344:

Line 3346: FND_MESSAGE.Set_Name('AHL','AHL_CMP_SUBINV_NULL'); -- Sub Inventory cannot be null.

3342: x_return_status := FND_API.G_RET_STS_ERROR;
3343: END IF;
3344:
3345: IF p_x_ahl_mtlrtn_rec.Dst_SubInv_Name IS NULL THEN
3346: FND_MESSAGE.Set_Name('AHL','AHL_CMP_SUBINV_NULL'); -- Sub Inventory cannot be null.
3347: FND_MSG_PUB.ADD;
3348: x_return_status := FND_API.G_RET_STS_ERROR;
3349: END IF;
3350:

Line 3352: FND_MESSAGE.Set_Name('AHL','AHL_CMP_LOCATOR_NULL'); -- Locator cannot be null.

3348: x_return_status := FND_API.G_RET_STS_ERROR;
3349: END IF;
3350:
3351: IF (p_x_ahl_mtlrtn_rec.Dst_Locator_Id IS NULL AND p_x_ahl_mtlrtn_rec.Dst_Locator_Segments IS NULL) THEN
3352: FND_MESSAGE.Set_Name('AHL','AHL_CMP_LOCATOR_NULL'); -- Locator cannot be null.
3353: FND_MSG_PUB.ADD;
3354: x_return_status := FND_API.G_RET_STS_ERROR;
3355: END IF;
3356:

Line 3367: FND_MESSAGE.Set_Name('AHL','AHL_CMP_CANNOT_RETURN'); -- Cannot perform return as there exists open workorders associated to the instance

3363: FETCH Get_Srl_Ctrl_Code INTO l_srl_ctrl_code;
3364: CLOSE Get_Srl_Ctrl_Code;
3365:
3366: IF (nvl(l_srl_ctrl_code,0) <> nvl(C_NO_SERIAL_CONTROL,0) ) THEN --Serialized Item
3367: FND_MESSAGE.Set_Name('AHL','AHL_CMP_CANNOT_RETURN'); -- Cannot perform return as there exists open workorders associated to the instance
3368: FND_MESSAGE.Set_Token('INSTANCE',p_x_ahl_mtlrtn_rec.Instance_Id);
3369: FND_MSG_PUB.ADD;
3370: x_return_status := FND_API.G_RET_STS_ERROR;
3371: ELSE

Line 3368: FND_MESSAGE.Set_Token('INSTANCE',p_x_ahl_mtlrtn_rec.Instance_Id);

3364: CLOSE Get_Srl_Ctrl_Code;
3365:
3366: IF (nvl(l_srl_ctrl_code,0) <> nvl(C_NO_SERIAL_CONTROL,0) ) THEN --Serialized Item
3367: FND_MESSAGE.Set_Name('AHL','AHL_CMP_CANNOT_RETURN'); -- Cannot perform return as there exists open workorders associated to the instance
3368: FND_MESSAGE.Set_Token('INSTANCE',p_x_ahl_mtlrtn_rec.Instance_Id);
3369: FND_MSG_PUB.ADD;
3370: x_return_status := FND_API.G_RET_STS_ERROR;
3371: ELSE
3372: FND_MESSAGE.Set_Name('AHL','AHL_CMP_CANNOT_RTN_FULL_QTY'); -- Cannot return complete quantity as there exists open workorders associated to the instance

Line 3372: FND_MESSAGE.Set_Name('AHL','AHL_CMP_CANNOT_RTN_FULL_QTY'); -- Cannot return complete quantity as there exists open workorders associated to the instance

3368: FND_MESSAGE.Set_Token('INSTANCE',p_x_ahl_mtlrtn_rec.Instance_Id);
3369: FND_MSG_PUB.ADD;
3370: x_return_status := FND_API.G_RET_STS_ERROR;
3371: ELSE
3372: FND_MESSAGE.Set_Name('AHL','AHL_CMP_CANNOT_RTN_FULL_QTY'); -- Cannot return complete quantity as there exists open workorders associated to the instance
3373: FND_MESSAGE.Set_Token('INSTANCE',p_x_ahl_mtlrtn_rec.Instance_Id);
3374: FND_MSG_PUB.ADD;
3375: x_return_status := FND_API.G_RET_STS_ERROR;
3376: END IF;

Line 3373: FND_MESSAGE.Set_Token('INSTANCE',p_x_ahl_mtlrtn_rec.Instance_Id);

3369: FND_MSG_PUB.ADD;
3370: x_return_status := FND_API.G_RET_STS_ERROR;
3371: ELSE
3372: FND_MESSAGE.Set_Name('AHL','AHL_CMP_CANNOT_RTN_FULL_QTY'); -- Cannot return complete quantity as there exists open workorders associated to the instance
3373: FND_MESSAGE.Set_Token('INSTANCE',p_x_ahl_mtlrtn_rec.Instance_Id);
3374: FND_MSG_PUB.ADD;
3375: x_return_status := FND_API.G_RET_STS_ERROR;
3376: END IF;
3377: END IF;