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

Line 689: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

685: AOG_FLAG = X_AOG_FLAG
686: WHERE SCHEDULED_MATERIAL_ID = X_SCHEDULED_MATERIAL_ID
687: AND OBJECT_VERSION_NUMBER=X_OBJECT_VERSION_NUMBER;
688: IF SQL%rowcount=0 THEN
689: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
690: Fnd_Msg_Pub.ADD;
691: END IF;
692: END UPDATE_ROW;
693: -- Delete procedure to remove record from schedule materials

Line 1470: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');

1466: x_return_status => l_return_status,
1467: x_error_msg_code => l_msg_data);
1468: IF NVL(l_return_status,'x') <> 'S'
1469: THEN
1470: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');
1471: Fnd_Msg_Pub.ADD;
1472: END IF;
1473: --
1474: END IF;

Line 1489: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_CRT_MTL_UNTLCKD');

1485: p_visit_id => NULL,
1486: p_item_instance_id => NULL
1487: );
1488: IF l_return_status = FND_API.G_TRUE THEN
1489: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_CRT_MTL_UNTLCKD');
1490: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
1491: FND_MSG_PUB.ADD;
1492: RAISE FND_API.G_EXC_ERROR;
1493: END IF;

Line 1490: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);

1486: p_item_instance_id => NULL
1487: );
1488: IF l_return_status = FND_API.G_TRUE THEN
1489: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_CRT_MTL_UNTLCKD');
1490: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
1491: FND_MSG_PUB.ADD;
1492: RAISE FND_API.G_EXC_ERROR;
1493: END IF;
1494: -- rroy

Line 1509: Fnd_Message.SET_NAME('AHL','AHL_PP_VISIT_TASK_NOT_EXIST');

1505: x_return_status => l_return_status,
1506: x_error_msg_code => l_msg_data);
1507: IF NVL(l_return_status,'x') <> 'S'
1508: THEN
1509: Fnd_Message.SET_NAME('AHL','AHL_PP_VISIT_TASK_NOT_EXIST');
1510: Fnd_Msg_Pub.ADD;
1511: END IF;
1512: END IF;
1513: -- Assign

Line 1530: Fnd_Message.SET_NAME('AHL','AHL_PP_ORG_ID_NOT_EXISTS');

1526: x_project_id => l_project_id
1527: );
1528: -- Validate for organization
1529: IF l_organization_id IS NULL THEN
1530: Fnd_Message.SET_NAME('AHL','AHL_PP_ORG_ID_NOT_EXISTS');
1531: Fnd_Msg_Pub.ADD;
1532: END IF;
1533: -- rroy
1534: -- ACL Changes

Line 1567: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');

1563: CLOSE Check_stg_workorder_csr;
1564: END IF;
1565:
1566: IF ( l_error_flag ) THEN
1567: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');
1568: Fnd_Msg_Pub.ADD;
1569: END IF;
1570: END IF;
1571: --

Line 1605: Fnd_Message.SET_NAME('AHL',l_msg_data);

1601: x_return_status => l_return_status,
1602: x_msg_data => l_msg_data );
1603: IF NVL(l_return_status,'x') <> 'S'
1604: THEN
1605: Fnd_Message.SET_NAME('AHL',l_msg_data);
1606: IF ( p_x_req_material_tbl(i).mc_name IS NULL OR
1607: p_x_req_material_tbl(i).mc_name = FND_API.G_MISS_CHAR ) THEN
1608: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_header_id );
1609: ELSE

Line 1608: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_header_id );

1604: THEN
1605: Fnd_Message.SET_NAME('AHL',l_msg_data);
1606: IF ( p_x_req_material_tbl(i).mc_name IS NULL OR
1607: p_x_req_material_tbl(i).mc_name = FND_API.G_MISS_CHAR ) THEN
1608: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_header_id );
1609: ELSE
1610: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_name );
1611: END IF;
1612: Fnd_Msg_Pub.ADD;

Line 1610: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_name );

1606: IF ( p_x_req_material_tbl(i).mc_name IS NULL OR
1607: p_x_req_material_tbl(i).mc_name = FND_API.G_MISS_CHAR ) THEN
1608: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_header_id );
1609: ELSE
1610: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_name );
1611: END IF;
1612: Fnd_Msg_Pub.ADD;
1613: END IF;
1614: --Assign the returned value

Line 1631: Fnd_Message.SET_NAME('AHL',l_msg_data);

1627: x_return_status => l_return_status,
1628: x_msg_data => l_msg_data );
1629: IF NVL(l_return_status,'x') <> 'S'
1630: THEN
1631: Fnd_Message.SET_NAME('AHL',l_msg_data);
1632: IF ( p_x_req_material_tbl(i).mc_position IS NULL OR
1633: p_x_req_material_tbl(i).mc_position = FND_API.G_MISS_CHAR ) THEN
1634: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_position_key );
1635: ELSE

Line 1634: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_position_key );

1630: THEN
1631: Fnd_Message.SET_NAME('AHL',l_msg_data);
1632: IF ( p_x_req_material_tbl(i).mc_position IS NULL OR
1633: p_x_req_material_tbl(i).mc_position = FND_API.G_MISS_CHAR ) THEN
1634: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_position_key );
1635: ELSE
1636: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_position );
1637: END IF;
1638: Fnd_Msg_Pub.ADD;

Line 1636: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_position );

1632: IF ( p_x_req_material_tbl(i).mc_position IS NULL OR
1633: p_x_req_material_tbl(i).mc_position = FND_API.G_MISS_CHAR ) THEN
1634: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_position_key );
1635: ELSE
1636: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).mc_position );
1637: END IF;
1638: Fnd_Msg_Pub.ADD;
1639: END IF;
1640: --Assign the returned value

Line 1656: Fnd_Message.SET_NAME('AHL',l_msg_data);

1652: x_return_status => l_return_status,
1653: x_msg_data => l_msg_data );
1654: IF NVL(l_return_status,'x') <> 'S'
1655: THEN
1656: Fnd_Message.SET_NAME('AHL',l_msg_data);
1657: IF ( p_x_req_material_tbl(i).item_group_name IS NULL OR
1658: p_x_req_material_tbl(i).item_group_name = FND_API.G_MISS_CHAR ) THEN
1659: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).item_group_id );
1660: ELSE

Line 1659: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).item_group_id );

1655: THEN
1656: Fnd_Message.SET_NAME('AHL',l_msg_data);
1657: IF ( p_x_req_material_tbl(i).item_group_name IS NULL OR
1658: p_x_req_material_tbl(i).item_group_name = FND_API.G_MISS_CHAR ) THEN
1659: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).item_group_id );
1660: ELSE
1661: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).item_group_name );
1662: END IF;
1663: Fnd_Msg_Pub.ADD;

Line 1661: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).item_group_name );

1657: IF ( p_x_req_material_tbl(i).item_group_name IS NULL OR
1658: p_x_req_material_tbl(i).item_group_name = FND_API.G_MISS_CHAR ) THEN
1659: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).item_group_id );
1660: ELSE
1661: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).item_group_name );
1662: END IF;
1663: Fnd_Msg_Pub.ADD;
1664: END IF;
1665: --Assign the returned value

Line 1700: Fnd_Message.SET_NAME('AHL',l_msg_data);

1696: x_return_status => l_return_status,
1697: x_msg_data => l_msg_data);
1698: IF NVL(l_return_status,'x') <> 'S'
1699: THEN
1700: Fnd_Message.SET_NAME('AHL',l_msg_data);
1701: IF ( p_x_req_material_tbl(i).concatenated_segments IS NULL OR
1702: p_x_req_material_tbl(i).concatenated_segments = FND_API.G_MISS_CHAR ) THEN
1703: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).inventory_item_id );
1704: ELSE

Line 1703: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).inventory_item_id );

1699: THEN
1700: Fnd_Message.SET_NAME('AHL',l_msg_data);
1701: IF ( p_x_req_material_tbl(i).concatenated_segments IS NULL OR
1702: p_x_req_material_tbl(i).concatenated_segments = FND_API.G_MISS_CHAR ) THEN
1703: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).inventory_item_id );
1704: ELSE
1705: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).concatenated_segments );
1706: END IF;
1707: Fnd_Msg_Pub.ADD;

Line 1705: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).concatenated_segments );

1701: IF ( p_x_req_material_tbl(i).concatenated_segments IS NULL OR
1702: p_x_req_material_tbl(i).concatenated_segments = FND_API.G_MISS_CHAR ) THEN
1703: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).inventory_item_id );
1704: ELSE
1705: FND_MESSAGE.set_token( 'FIELD', p_x_req_material_tbl(i).concatenated_segments );
1706: END IF;
1707: Fnd_Msg_Pub.ADD;
1708: END IF;
1709: ELSE

Line 1720: Fnd_Message.SET_NAME('AHL','AHL_PP_INVALID_ITEM');

1716: x_return_status => l_return_status,
1717: x_error_msg_code => l_msg_data);
1718: IF NVL(l_return_status,'x') <> 'S'
1719: THEN
1720: Fnd_Message.SET_NAME('AHL','AHL_PP_INVALID_ITEM');
1721: Fnd_Msg_Pub.ADD;
1722: END IF;
1723: END IF;
1724: ELSE

Line 1725: Fnd_Message.SET_NAME('AHL','AHL_PP_INV_ID_REQUIRED');

1721: Fnd_Msg_Pub.ADD;
1722: END IF;
1723: END IF;
1724: ELSE
1725: Fnd_Message.SET_NAME('AHL','AHL_PP_INV_ID_REQUIRED');
1726: Fnd_Msg_Pub.ADD;
1727: END IF;
1728: --Assign the returned value
1729: p_x_req_material_tbl(i).inventory_item_id := l_inventory_item_id;

Line 1740: Fnd_Message.SET_NAME('AHL',l_msg_data);

1736: x_msg_data => l_msg_data
1737: );
1738: IF NVL(l_return_status,'x') <> 'S'
1739: THEN
1740: Fnd_Message.SET_NAME('AHL',l_msg_data);
1741: Fnd_Msg_Pub.ADD;
1742: END IF;
1743: --ALSO ONLY IN CASE P_INTERFACE_FLAG IS NULL OR Y.
1744: l_uc_header_id := null;

Line 1774: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_REQUIRED');

1770: END IF;
1771: -- Validate for Requested Quantity
1772: IF (p_x_req_material_tbl(i).requested_quantity IS NULL OR
1773: p_x_req_material_tbl(i).requested_quantity = FND_API.G_MISS_NUM ) THEN
1774: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_REQUIRED');
1775: Fnd_Msg_Pub.ADD;
1776: ELSIF (p_x_req_material_tbl(i).requested_quantity IS NOT NULL AND
1777: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN
1778: -- Fix for FP bug# 6642084. -- Allow 0 quantity.

Line 1780: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_INVALID');

1776: ELSIF (p_x_req_material_tbl(i).requested_quantity IS NOT NULL AND
1777: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN
1778: -- Fix for FP bug# 6642084. -- Allow 0 quantity.
1779: IF p_x_req_material_tbl(i).requested_quantity < 0 THEN
1780: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_INVALID');
1781: Fnd_Msg_Pub.ADD;
1782: END IF;
1783: END IF;
1784: --

Line 1795: FND_MESSAGE.set_name('AHL', 'AHL_PP_SCHLD_QUANTITY_INVLD');

1791: IF ( p_x_req_material_tbl(i).scheduled_quantity IS NOT NULL AND
1792: p_x_req_material_tbl(i).scheduled_quantity <> FND_API.G_MISS_NUM ) THEN
1793:
1794: IF ( p_x_req_material_tbl(i).scheduled_quantity < 0 ) THEN
1795: FND_MESSAGE.set_name('AHL', 'AHL_PP_SCHLD_QUANTITY_INVLD');
1796: FND_MSG_PUB.add;
1797: END IF;
1798:
1799: END IF;

Line 1811: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_REQUIRED');

1807: IF ((p_interface_flag = 'Y' OR p_interface_flag is null ) AND (p_module_type <> 'VWP'))THEN
1808: -- Validate for Requested Date
1809: IF (p_x_req_material_tbl(i).requested_date IS NULL OR
1810: p_x_req_material_tbl(i).requested_date = FND_API.G_MISS_DATE ) THEN
1811: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_REQUIRED');
1812: Fnd_Msg_Pub.ADD;
1813: ELSIF (p_x_req_material_tbl(i).requested_date IS NOT NULL AND
1814: p_x_req_material_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN
1815: IF p_x_req_material_tbl(i).requested_date < trunc(SYSDATE) THEN

Line 1816: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_GT_SYSD');

1812: Fnd_Msg_Pub.ADD;
1813: ELSIF (p_x_req_material_tbl(i).requested_date IS NOT NULL AND
1814: p_x_req_material_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN
1815: IF p_x_req_material_tbl(i).requested_date < trunc(SYSDATE) THEN
1816: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_GT_SYSD');
1817: Fnd_Msg_Pub.ADD;
1818: END IF;
1819: END IF;
1820: END IF;

Line 1837: Fnd_Message.SET_NAME('AHL','AHL_PP_OPER_SEQ_REQD');

1833: --
1834: OPEN Get_Operation_Seq_cur(p_x_req_material_tbl(i).workorder_operation_id);
1835: FETCH Get_Operation_Seq_cur INTO p_x_req_material_tbl(i).operation_sequence;
1836: IF Get_Operation_Seq_cur%NOTFOUND THEN
1837: Fnd_Message.SET_NAME('AHL','AHL_PP_OPER_SEQ_REQD');
1838: Fnd_Msg_Pub.ADD;
1839: END IF;
1840: CLOSE Get_Operation_Seq_cur;
1841: END IF;

Line 1867: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_OP_ID_NOT_EXIST');

1863: x_return_status => l_return_status,
1864: x_error_msg_code => l_msg_data);
1865: IF NVL(l_return_status,'x') <> 'S'
1866: THEN
1867: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_OP_ID_NOT_EXIST');
1868: Fnd_Msg_Pub.ADD;
1869: --
1870: END IF;
1871: END IF;

Line 1909: Fnd_Message.SET_NAME('AHL','AHL_PP_RE_DATE_SCH_DATE');

1905: trunc(p_x_req_material_tbl(i).requested_date)) ;
1906: FETCH Get_sch_dates_cur INTO l_dummy;
1907: --
1908: IF Get_sch_dates_cur%NOTFOUND THEN
1909: Fnd_Message.SET_NAME('AHL','AHL_PP_RE_DATE_SCH_DATE');
1910: Fnd_Msg_Pub.ADD;
1911: END IF;
1912: --
1913: CLOSE Get_sch_dates_cur;

Line 1935: Fnd_Message.SET_NAME('AHL','AHL_MAT_RECORD_EXIST');

1931: p_x_req_material_tbl(i).operation_sequence);
1932: FETCH Check_unique_cur INTO l_dummy;
1933: --
1934: IF Check_unique_cur%FOUND THEN
1935: Fnd_Message.SET_NAME('AHL','AHL_MAT_RECORD_EXIST');
1936: FND_MESSAGE.SET_TOKEN('ITEM',p_x_req_material_tbl(i).concatenated_segments,false);
1937: Fnd_Msg_Pub.ADD;
1938: END IF;
1939: --

Line 1936: FND_MESSAGE.SET_TOKEN('ITEM',p_x_req_material_tbl(i).concatenated_segments,false);

1932: FETCH Check_unique_cur INTO l_dummy;
1933: --
1934: IF Check_unique_cur%FOUND THEN
1935: Fnd_Message.SET_NAME('AHL','AHL_MAT_RECORD_EXIST');
1936: FND_MESSAGE.SET_TOKEN('ITEM',p_x_req_material_tbl(i).concatenated_segments,false);
1937: Fnd_Msg_Pub.ADD;
1938: END IF;
1939: --
1940: CLOSE Check_unique_cur;

Line 3059: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');

3055: x_return_status => l_return_status,
3056: x_error_msg_code => l_msg_data);
3057: IF NVL(l_return_status,'x') <> 'S'
3058: THEN
3059: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');
3060: Fnd_Msg_Pub.ADD;
3061: END IF;
3062: --
3063: ELSE

Line 3064: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_REQUIRED');

3060: Fnd_Msg_Pub.ADD;
3061: END IF;
3062: --
3063: ELSE
3064: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_REQUIRED');
3065: Fnd_Msg_Pub.ADD;
3066: END IF;
3067: --
3068: p_x_req_material_tbl(i).workorder_id := l_workorder_id;

Line 3080: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_UPD_MTL_UNTLCKD');

3076: IF l_return_status = FND_API.G_TRUE THEN
3077: OPEN get_job_number(p_x_req_material_tbl(i).workorder_id);
3078: FETCH get_job_number INTO l_workorder_name;
3079: CLOSE get_job_number;
3080: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_UPD_MTL_UNTLCKD');
3081: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
3082: FND_MSG_PUB.ADD;
3083: RAISE FND_API.G_EXC_ERROR;
3084: END IF;

Line 3081: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);

3077: OPEN get_job_number(p_x_req_material_tbl(i).workorder_id);
3078: FETCH get_job_number INTO l_workorder_name;
3079: CLOSE get_job_number;
3080: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_UPD_MTL_UNTLCKD');
3081: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
3082: FND_MSG_PUB.ADD;
3083: RAISE FND_API.G_EXC_ERROR;
3084: END IF;
3085: -- rroy

Line 3119: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_REQUIRED');

3115: END IF;
3116: -- Validate for Requested Quantity
3117: IF (p_x_req_material_tbl(i).requested_quantity IS NULL OR
3118: p_x_req_material_tbl(i).requested_quantity = FND_API.G_MISS_NUM) THEN
3119: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_REQUIRED');
3120: Fnd_Msg_Pub.ADD;
3121: ELSIF (p_x_req_material_tbl(i).requested_quantity IS NOT NULL AND
3122: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN
3123: IF p_x_req_material_tbl(i).requested_quantity < 0 THEN

Line 3124: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_INVALID');

3120: Fnd_Msg_Pub.ADD;
3121: ELSIF (p_x_req_material_tbl(i).requested_quantity IS NOT NULL AND
3122: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN
3123: IF p_x_req_material_tbl(i).requested_quantity < 0 THEN
3124: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_INVALID');
3125: Fnd_Msg_Pub.ADD;
3126: END IF;
3127: -- added in R12: Serial Reservation project.
3128: -- If requested quantity changed -

Line 3141: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_RESRV_QTY');

3137: FETCH get_count_resrv_cur INTO l_reserved_quantity;
3138: CLOSE get_count_resrv_cur;
3139: IF (p_x_req_material_tbl(i).requested_quantity < l_reserved_quantity)
3140: THEN
3141: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_RESRV_QTY');
3142: Fnd_Message.SET_TOKEN('REQ_QTY',p_x_req_material_tbl(i).requested_quantity);
3143: Fnd_Message.SET_TOKEN('RRV_QTY',l_reserved_quantity);
3144: Fnd_Msg_Pub.ADD;
3145: END IF;-- p_x_req_material_tbl(i).requested_quantity <

Line 3142: Fnd_Message.SET_TOKEN('REQ_QTY',p_x_req_material_tbl(i).requested_quantity);

3138: CLOSE get_count_resrv_cur;
3139: IF (p_x_req_material_tbl(i).requested_quantity < l_reserved_quantity)
3140: THEN
3141: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_RESRV_QTY');
3142: Fnd_Message.SET_TOKEN('REQ_QTY',p_x_req_material_tbl(i).requested_quantity);
3143: Fnd_Message.SET_TOKEN('RRV_QTY',l_reserved_quantity);
3144: Fnd_Msg_Pub.ADD;
3145: END IF;-- p_x_req_material_tbl(i).requested_quantity <
3146: END IF; --p_x_req_material_tbl(i).requested_quantity <>

Line 3143: Fnd_Message.SET_TOKEN('RRV_QTY',l_reserved_quantity);

3139: IF (p_x_req_material_tbl(i).requested_quantity < l_reserved_quantity)
3140: THEN
3141: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_RESRV_QTY');
3142: Fnd_Message.SET_TOKEN('REQ_QTY',p_x_req_material_tbl(i).requested_quantity);
3143: Fnd_Message.SET_TOKEN('RRV_QTY',l_reserved_quantity);
3144: Fnd_Msg_Pub.ADD;
3145: END IF;-- p_x_req_material_tbl(i).requested_quantity <
3146: END IF; --p_x_req_material_tbl(i).requested_quantity <>
3147: END IF;

Line 3157: FND_MESSAGE.set_name('AHL', 'AHL_PP_SCHLD_QUANTITY_INVLD');

3153: IF ( p_x_req_material_tbl(i).scheduled_quantity IS NOT NULL AND
3154: p_x_req_material_tbl(i).scheduled_quantity <> FND_API.G_MISS_NUM ) THEN
3155:
3156: IF ( p_x_req_material_tbl(i).scheduled_quantity < 0 ) THEN
3157: FND_MESSAGE.set_name('AHL', 'AHL_PP_SCHLD_QUANTITY_INVLD');
3158: FND_MSG_PUB.add;
3159: END IF;
3160:
3161: -- If scheduled quantity is changed, then check for reservations if any.

Line 3177: FND_MESSAGE.set_name('AHL', 'AHL_PP_SCHLD_RESRV_QTY');

3173: CLOSE get_count_resrv_cur;
3174: END IF;
3175:
3176: IF ( p_x_req_material_tbl(i).scheduled_quantity < l_reserved_quantity ) THEN
3177: FND_MESSAGE.set_name('AHL', 'AHL_PP_SCHLD_RESRV_QTY');
3178: FND_MESSAGE.set_token('SCHLD_QTY', p_x_req_material_tbl(i).scheduled_quantity);
3179: FND_MESSAGE.set_token('RRV_QTY' , l_reserved_quantity);
3180: FND_MSG_PUB.add;
3181: END IF;

Line 3178: FND_MESSAGE.set_token('SCHLD_QTY', p_x_req_material_tbl(i).scheduled_quantity);

3174: END IF;
3175:
3176: IF ( p_x_req_material_tbl(i).scheduled_quantity < l_reserved_quantity ) THEN
3177: FND_MESSAGE.set_name('AHL', 'AHL_PP_SCHLD_RESRV_QTY');
3178: FND_MESSAGE.set_token('SCHLD_QTY', p_x_req_material_tbl(i).scheduled_quantity);
3179: FND_MESSAGE.set_token('RRV_QTY' , l_reserved_quantity);
3180: FND_MSG_PUB.add;
3181: END IF;
3182:

Line 3179: FND_MESSAGE.set_token('RRV_QTY' , l_reserved_quantity);

3175:
3176: IF ( p_x_req_material_tbl(i).scheduled_quantity < l_reserved_quantity ) THEN
3177: FND_MESSAGE.set_name('AHL', 'AHL_PP_SCHLD_RESRV_QTY');
3178: FND_MESSAGE.set_token('SCHLD_QTY', p_x_req_material_tbl(i).scheduled_quantity);
3179: FND_MESSAGE.set_token('RRV_QTY' , l_reserved_quantity);
3180: FND_MSG_PUB.add;
3181: END IF;
3182:
3183: END IF; -- p_x_req_material_tbl(i).scheduled_quantity <> l_req_material_rec.scheduled_quantity

Line 3195: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_REQUIRED');

3191: IF p_module_type NOT IN ('API', 'VWP') THEN --bug 14137417 :: added VWP by tchimira :: below validation should not occur for VWP flows
3192: -- Validate for Requested Date
3193: IF (p_x_req_material_tbl(i).requested_date IS NULL OR
3194: p_x_req_material_tbl(i).requested_date = FND_API.G_MISS_DATE) THEN
3195: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_REQUIRED');
3196: Fnd_Msg_Pub.ADD;
3197: ELSIF (p_x_req_material_tbl(i).requested_date IS NOT NULL AND
3198: P_X_REQ_MATERIAL_TBL(I).REQUESTED_DATE <> FND_API.G_MISS_DATE) THEN
3199:

Line 3205: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_GT_EQ_SYSD');

3201: IF(( P_X_REQ_MATERIAL_TBL(I).AOG_FLAG = L_REQ_MATERIAL_REC.AOG_FLAG ) AND
3202: ( P_X_REQ_MATERIAL_TBL(I).REQUESTED_DATE < TRUNC(SYSDATE) ) AND
3203: (( P_X_REQ_MATERIAL_TBL(I).REQUESTED_QUANTITY <> L_REQ_MATERIAL_REC.REQUESTED_QUANTITY ) OR
3204: ( P_X_REQ_MATERIAL_TBL(I).REQUESTED_DATE <> L_REQ_MATERIAL_REC.REQUESTED_DATE ))) THEN
3205: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_GT_EQ_SYSD');
3206: Fnd_Msg_Pub.ADD;
3207: END IF;
3208: END IF;
3209: IF G_DEBUG='Y' THEN

Line 3215: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');

3211: END IF;
3212: -- Validate for Schedule Material ID
3213: IF (p_x_req_material_tbl(i).schedule_material_id IS NULL AND
3214: p_x_req_material_tbl(i).schedule_material_id = FND_API.G_MISS_NUM) THEN
3215: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');
3216: Fnd_Msg_Pub.ADD;
3217: END IF;
3218: IF G_DEBUG='Y' THEN
3219: AHL_DEBUG_PUB.debug( 'SCHID :'||p_x_req_material_tbl(i).schedule_material_id);

Line 3231: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVLD');

3227: /* MANESING::NR Analysis, 03-Jun-2011,
3228: * give appropriate error message based on the flow in which this API is called.
3229: */
3230: IF ( p_module_type = 'VWP' ) THEN
3231: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVLD');
3232: ELSE
3233: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');
3234: END IF;
3235:

Line 3233: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');

3229: */
3230: IF ( p_module_type = 'VWP' ) THEN
3231: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVLD');
3232: ELSE
3233: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');
3234: END IF;
3235:
3236: Fnd_Msg_Pub.ADD;
3237: END IF;

Line 3960: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');

3956: -- Bug # 6680137 - start
3957: OPEN Get_job_details(p_x_req_material_tbl(i).workorder_id);
3958: FETCH Get_job_details INTO l_workorder_name;
3959: IF Get_job_details%NOTFOUND THEN
3960: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');
3961: Fnd_Msg_Pub.ADD;
3962: CLOSE Get_job_details;
3963: RAISE FND_API.G_EXC_ERROR;
3964: END IF;

Line 3975: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');

3971: FETCH c_get_wo_status INTO l_wo_status;
3972: CLOSE c_get_wo_status;
3973: IF l_wo_status IN ('7', '5', '12')
3974: THEN
3975: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');
3976: Fnd_Msg_Pub.ADD;
3977: RAISE FND_API.G_EXC_ERROR;
3978: END IF;
3979: -- Bug # 6680137 - end

Line 3990: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_MTL_UNTLCKD');

3986: p_ue_id => NULL,
3987: p_visit_id => NULL,
3988: p_item_instance_id => NULL);
3989: IF l_return_status = FND_API.G_TRUE THEN
3990: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_MTL_UNTLCKD');
3991: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
3992: FND_MSG_PUB.ADD;
3993: RAISE FND_API.G_EXC_ERROR;
3994: END IF;

Line 3991: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);

3987: p_visit_id => NULL,
3988: p_item_instance_id => NULL);
3989: IF l_return_status = FND_API.G_TRUE THEN
3990: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_MTL_UNTLCKD');
3991: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
3992: FND_MSG_PUB.ADD;
3993: RAISE FND_API.G_EXC_ERROR;
3994: END IF;
3995: -- rroy

Line 4000: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');

3996: -- ACL Changes
3997: -- Check for Schedule Material ID
3998: IF (p_x_req_material_tbl(i).schedule_material_id IS NULL OR
3999: p_x_req_material_tbl(i).schedule_material_id = FND_API.G_MISS_NUM) THEN
4000: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');
4001: Fnd_Msg_Pub.ADD;
4002: END IF;
4003: --
4004: IF G_DEBUG='Y' THEN

Line 4019: Fnd_Message.SET_NAME('AHL','AHL_PP_RECORD_CHANGED');

4015: WHERE scheduled_material_id = p_x_req_material_tbl(i).schedule_material_id
4016: FOR UPDATE OF STATUS NOWAIT;
4017: --
4018: IF p_x_req_material_tbl(i).object_version_number <> l_object_version_number THEN
4019: Fnd_Message.SET_NAME('AHL','AHL_PP_RECORD_CHANGED');
4020: Fnd_Msg_Pub.ADD;
4021: RAISE Fnd_Api.G_EXC_ERROR;
4022: END IF;
4023: --

Line 4396: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');

4392: l_schedule_material_id := p_x_req_material_tbl(i).schedule_material_id;
4393: -- Check for Schedule Material ID
4394: IF (l_schedule_material_id IS NULL OR
4395: l_schedule_material_id = FND_API.G_MISS_NUM) THEN
4396: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');
4397: Fnd_Msg_Pub.ADD;
4398: RAISE FND_API.G_EXC_ERROR;
4399: END IF;
4400:

Line 4418: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');

4414: -- Check for existance of valid work order
4415: OPEN Get_job_details_for_exe(l_material_req_rec.workorder_id);
4416: FETCH Get_job_details_for_exe INTO l_workorder_name;
4417: IF Get_job_details_for_exe%NOTFOUND THEN
4418: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');
4419: Fnd_Msg_Pub.ADD;
4420: CLOSE Get_job_details_for_exe;
4421: RAISE FND_API.G_EXC_ERROR;
4422: END IF;

Line 4429: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');

4425: -- Check for existance of valid work order
4426: OPEN Get_job_details(l_material_req_rec.workorder_id);
4427: FETCH Get_job_details INTO l_workorder_name;
4428: IF Get_job_details%NOTFOUND THEN
4429: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');
4430: Fnd_Msg_Pub.ADD;
4431: CLOSE Get_job_details;
4432: RAISE FND_API.G_EXC_ERROR;
4433: END IF;

Line 4444: Fnd_Message.SET_NAME('AHL','AHL_PP_TXN_ISSUED_ITEM'); -- Issued item cannot be changed.

4440: CLOSE Get_Item_Name_Cur;
4441:
4442: -- Check whether the item is issued
4443: IF (l_material_req_rec.completed_quantity > 0 ) THEN
4444: Fnd_Message.SET_NAME('AHL','AHL_PP_TXN_ISSUED_ITEM'); -- Issued item cannot be changed.
4445: FND_MESSAGE.Set_Token('ITEM', l_item_name);
4446: Fnd_Msg_Pub.ADD;
4447: END IF;
4448:

Line 4445: FND_MESSAGE.Set_Token('ITEM', l_item_name);

4441:
4442: -- Check whether the item is issued
4443: IF (l_material_req_rec.completed_quantity > 0 ) THEN
4444: Fnd_Message.SET_NAME('AHL','AHL_PP_TXN_ISSUED_ITEM'); -- Issued item cannot be changed.
4445: FND_MESSAGE.Set_Token('ITEM', l_item_name);
4446: Fnd_Msg_Pub.ADD;
4447: END IF;
4448:
4449: -- Check whether the item is reserved

Line 4451: Fnd_Message.SET_NAME('AHL','AHL_PP_RESERVED_ITEM'); -- Reserved item cannot be changed.

4447: END IF;
4448:
4449: -- Check whether the item is reserved
4450: IF (l_material_req_rec.reserved_quantity > 0 ) THEN
4451: Fnd_Message.SET_NAME('AHL','AHL_PP_RESERVED_ITEM'); -- Reserved item cannot be changed.
4452: FND_MESSAGE.Set_Token('ITEM', l_item_name);
4453: Fnd_Msg_Pub.ADD;
4454: END IF;
4455:

Line 4452: FND_MESSAGE.Set_Token('ITEM', l_item_name);

4448:
4449: -- Check whether the item is reserved
4450: IF (l_material_req_rec.reserved_quantity > 0 ) THEN
4451: Fnd_Message.SET_NAME('AHL','AHL_PP_RESERVED_ITEM'); -- Reserved item cannot be changed.
4452: FND_MESSAGE.Set_Token('ITEM', l_item_name);
4453: Fnd_Msg_Pub.ADD;
4454: END IF;
4455:
4456: --Check whether the item is locked.

Line 4464: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_MTL_UNTLCKD');

4460: p_ue_id => NULL,
4461: p_visit_id => NULL,
4462: p_item_instance_id => NULL);
4463: IF l_return_status = FND_API.G_TRUE THEN
4464: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_MTL_UNTLCKD');
4465: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
4466: FND_MSG_PUB.ADD;
4467: RAISE FND_API.G_EXC_ERROR;
4468: END IF;

Line 4465: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);

4461: p_visit_id => NULL,
4462: p_item_instance_id => NULL);
4463: IF l_return_status = FND_API.G_TRUE THEN
4464: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_MTL_UNTLCKD');
4465: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
4466: FND_MSG_PUB.ADD;
4467: RAISE FND_API.G_EXC_ERROR;
4468: END IF;
4469:

Line 4477: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_INVALID');

4473: -- Check for valid requested quantity
4474: IF (p_x_req_material_tbl(i).requested_quantity IS NULL OR (p_x_req_material_tbl(i).requested_quantity = FND_API.G_MISS_NUM)) THEN
4475: p_x_req_material_tbl(i).requested_quantity := l_material_req_rec.old_requested_quantity;
4476: ELSIF p_x_req_material_tbl(i).requested_quantity < 0 THEN
4477: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_INVALID');
4478: Fnd_Msg_Pub.ADD;
4479: END IF;
4480:
4481: -- Check for valid requested date

Line 4485: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_GT_EQ_SYSD');

4481: -- Check for valid requested date
4482: IF (p_x_req_material_tbl(i).requested_date IS NULL OR (p_x_req_material_tbl(i).requested_date = FND_API.G_MISS_DATE)) THEN
4483: p_x_req_material_tbl(i).requested_date := l_material_req_rec.old_requested_date;
4484: ELSIF p_x_req_material_tbl(i).requested_date < trunc(SYSDATE) THEN
4485: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_GT_EQ_SYSD');
4486: Fnd_Msg_Pub.ADD;
4487: END IF;
4488:
4489: --Standard check to count messages

Line 4594: Fnd_Message.SET_NAME('AHL','AHL_PP_WIP_REQ_EXISTS'); -- WIP requirement already exists for the new item

4590: OPEN Get_Item_Name_Cur(p_x_req_material_tbl(i).inventory_item_id,
4591: l_material_req_rec.organization_id);
4592: FETCH Get_Item_Name_Cur INTO l_item_name;
4593: CLOSE Get_Item_Name_Cur;
4594: Fnd_Message.SET_NAME('AHL','AHL_PP_WIP_REQ_EXISTS'); -- WIP requirement already exists for the new item
4595: FND_MESSAGE.Set_Token('ITEM', l_item_name);
4596: Fnd_Msg_Pub.ADD;
4597: RAISE FND_API.G_EXC_ERROR;
4598: ELSE

Line 4595: FND_MESSAGE.Set_Token('ITEM', l_item_name);

4591: l_material_req_rec.organization_id);
4592: FETCH Get_Item_Name_Cur INTO l_item_name;
4593: CLOSE Get_Item_Name_Cur;
4594: Fnd_Message.SET_NAME('AHL','AHL_PP_WIP_REQ_EXISTS'); -- WIP requirement already exists for the new item
4595: FND_MESSAGE.Set_Token('ITEM', l_item_name);
4596: Fnd_Msg_Pub.ADD;
4597: RAISE FND_API.G_EXC_ERROR;
4598: ELSE
4599: -- If no WIP requirement exists for the new item then create a WIP requirement.

Line 4651: Fnd_Message.SET_NAME('AHL','AHL_RSV_INVALID_MTRLREQ'); -- Material Requirement is Invalid.

4647: ELSE
4648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4649: AHL_DEBUG_PUB.debug( 'Invalid Scedule Material Id: '||l_schedule_material_id);
4650: END IF;
4651: Fnd_Message.SET_NAME('AHL','AHL_RSV_INVALID_MTRLREQ'); -- Material Requirement is Invalid.
4652: Fnd_Msg_Pub.ADD;
4653: END IF; -- End of existance of ASM requirement for the original item check.
4654: END LOOP; -- End of p_x_req_material_tbl loop
4655: IF (l_material_req_re_tbl.COUNT > 0 ) THEN

Line 6249: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_ADDED_NTF');

6245: FOR i IN l_Req_Material_Tbl.FIRST..l_Req_Material_Tbl.LAST
6246: LOOP
6247: IF l_Req_Material_Tbl(i).operation_flag = 'C' THEN
6248: IF l_Req_Material_Tbl(i).concatenated_segments IS NOT NULL THEN
6249: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_ADDED_NTF');
6250: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
6251: l_text := fnd_message.get;
6252: --Include quantity and date
6253: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');

Line 6250: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);

6246: LOOP
6247: IF l_Req_Material_Tbl(i).operation_flag = 'C' THEN
6248: IF l_Req_Material_Tbl(i).concatenated_segments IS NOT NULL THEN
6249: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_ADDED_NTF');
6250: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
6251: l_text := fnd_message.get;
6252: --Include quantity and date
6253: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');
6254: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);

Line 6251: l_text := fnd_message.get;

6247: IF l_Req_Material_Tbl(i).operation_flag = 'C' THEN
6248: IF l_Req_Material_Tbl(i).concatenated_segments IS NOT NULL THEN
6249: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_ADDED_NTF');
6250: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
6251: l_text := fnd_message.get;
6252: --Include quantity and date
6253: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');
6254: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
6255: l_body := fnd_message.get;

Line 6253: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');

6249: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_ADDED_NTF');
6250: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
6251: l_text := fnd_message.get;
6252: --Include quantity and date
6253: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');
6254: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
6255: l_body := fnd_message.get;
6256: l_Req_Material_Tbl(i).notify_text := l_text ||''||l_body
6257: ||'; For Workorder:'||l_Req_Material_Tbl(i).job_number

Line 6254: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);

6250: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
6251: l_text := fnd_message.get;
6252: --Include quantity and date
6253: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');
6254: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
6255: l_body := fnd_message.get;
6256: l_Req_Material_Tbl(i).notify_text := l_text ||''||l_body
6257: ||'; For Workorder:'||l_Req_Material_Tbl(i).job_number
6258: || '; Required date:'||l_Req_Material_Tbl(i).requested_date;

Line 6255: l_body := fnd_message.get;

6251: l_text := fnd_message.get;
6252: --Include quantity and date
6253: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');
6254: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
6255: l_body := fnd_message.get;
6256: l_Req_Material_Tbl(i).notify_text := l_text ||''||l_body
6257: ||'; For Workorder:'||l_Req_Material_Tbl(i).job_number
6258: || '; Required date:'||l_Req_Material_Tbl(i).requested_date;
6259: END IF;

Line 6262: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_UPDATE');

6258: || '; Required date:'||l_Req_Material_Tbl(i).requested_date;
6259: END IF;
6260: ELSE
6261: --Update
6262: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_UPDATE');
6263: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
6264: l_text := fnd_message.get;
6265: --Include quantity and date
6266: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');

Line 6263: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);

6259: END IF;
6260: ELSE
6261: --Update
6262: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_UPDATE');
6263: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
6264: l_text := fnd_message.get;
6265: --Include quantity and date
6266: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');
6267: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);

Line 6264: l_text := fnd_message.get;

6260: ELSE
6261: --Update
6262: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_UPDATE');
6263: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
6264: l_text := fnd_message.get;
6265: --Include quantity and date
6266: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');
6267: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
6268: l_body := fnd_message.get;

Line 6266: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');

6262: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_UPDATE');
6263: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
6264: l_text := fnd_message.get;
6265: --Include quantity and date
6266: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');
6267: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
6268: l_body := fnd_message.get;
6269: l_Req_Material_Tbl(i).notify_text := l_text ||''||l_body
6270: || ';For Workorder:'||l_Req_Material_Tbl(i).job_number

Line 6267: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);

6263: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
6264: l_text := fnd_message.get;
6265: --Include quantity and date
6266: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');
6267: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
6268: l_body := fnd_message.get;
6269: l_Req_Material_Tbl(i).notify_text := l_text ||''||l_body
6270: || ';For Workorder:'||l_Req_Material_Tbl(i).job_number
6271: || ';Required date:'||l_Req_Material_Tbl(i).requested_date;

Line 6268: l_body := fnd_message.get;

6264: l_text := fnd_message.get;
6265: --Include quantity and date
6266: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');
6267: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
6268: l_body := fnd_message.get;
6269: l_Req_Material_Tbl(i).notify_text := l_text ||''||l_body
6270: || ';For Workorder:'||l_Req_Material_Tbl(i).job_number
6271: || ';Required date:'||l_Req_Material_Tbl(i).requested_date;
6272: END IF;

Line 6297: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_CONTENT');

6293: END IF;
6294: OPEN CursorNotify(l_object);
6295: FETCH CursorNotify INTO l_rec;
6296: CLOSE CursorNotify;
6297: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_CONTENT');
6298: l_subject := fnd_message.get;
6299: l_role_name:=l_rec.approver_name;
6300: l_return_status := FND_API.G_RET_STS_SUCCESS;
6301: l_notif_id := WF_NOTIFICATION.Send

Line 6298: l_subject := fnd_message.get;

6294: OPEN CursorNotify(l_object);
6295: FETCH CursorNotify INTO l_rec;
6296: CLOSE CursorNotify;
6297: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_CONTENT');
6298: l_subject := fnd_message.get;
6299: l_role_name:=l_rec.approver_name;
6300: l_return_status := FND_API.G_RET_STS_SUCCESS;
6301: l_notif_id := WF_NOTIFICATION.Send
6302: ( role => l_role_name

Line 6541: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_MAT_ID_INVALID');

6537: OPEN Get_WO_Mat_Details(p_asm_id);
6538: FETCH Get_WO_Mat_Details INTO l_current_mat_dtl_rec;
6539: IF (Get_WO_Mat_Details%NOTFOUND) THEN
6540: CLOSE Get_WO_Mat_Details;
6541: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_MAT_ID_INVALID');
6542: FND_MSG_PUB.ADD;
6543: RAISE FND_API.G_EXC_ERROR;
6544: END IF;
6545: CLOSE Get_WO_Mat_Details;

Line 6549: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_ALT_ITEM_SAME'); --Old and New Items are same.

6545: CLOSE Get_WO_Mat_Details;
6546:
6547: --Check old and new items are same or different. If same Items then Raise Error.
6548: IF (p_alternate_item_id = l_current_mat_dtl_rec.inventory_item_id) THEN
6549: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_ALT_ITEM_SAME'); --Old and New Items are same.
6550: FND_MSG_PUB.ADD;
6551: RAISE FND_API.G_EXC_ERROR;
6552: END IF;
6553:

Line 6568: Fnd_Message.SET_NAME('AHL',l_msg_data);

6564: x_msg_data => l_msg_data
6565: );
6566: IF NVL(l_return_status,'x') <> 'S' THEN
6567: --If alternate item is not a valid item in item group, then raise exception.
6568: Fnd_Message.SET_NAME('AHL',l_msg_data);
6569: FND_MESSAGE.set_token( 'FIELD', p_alternate_item_id ); -- Invalid Item 1
6570: Fnd_Msg_Pub.ADD;
6571: RAISE FND_API.G_EXC_ERROR;
6572: END IF;

Line 6569: FND_MESSAGE.set_token( 'FIELD', p_alternate_item_id ); -- Invalid Item 1

6565: );
6566: IF NVL(l_return_status,'x') <> 'S' THEN
6567: --If alternate item is not a valid item in item group, then raise exception.
6568: Fnd_Message.SET_NAME('AHL',l_msg_data);
6569: FND_MESSAGE.set_token( 'FIELD', p_alternate_item_id ); -- Invalid Item 1
6570: Fnd_Msg_Pub.ADD;
6571: RAISE FND_API.G_EXC_ERROR;
6572: END IF;
6573: ELSIF(l_current_mat_dtl_rec.position_key IS NOT NULL) THEN

Line 6586: Fnd_Message.SET_NAME('AHL',l_msg_data);

6582: x_msg_data => l_msg_data
6583: );
6584: IF NVL(l_return_status,'x') <> 'S' THEN
6585: --If alternate item is not a valid item in item group, then raise exception.
6586: Fnd_Message.SET_NAME('AHL',l_msg_data);
6587: FND_MESSAGE.set_token( 'FIELD', p_alternate_item_id ); -- Invalid Item 1
6588: Fnd_Msg_Pub.ADD;
6589: RAISE FND_API.G_EXC_ERROR;
6590: END IF;

Line 6587: FND_MESSAGE.set_token( 'FIELD', p_alternate_item_id ); -- Invalid Item 1

6583: );
6584: IF NVL(l_return_status,'x') <> 'S' THEN
6585: --If alternate item is not a valid item in item group, then raise exception.
6586: Fnd_Message.SET_NAME('AHL',l_msg_data);
6587: FND_MESSAGE.set_token( 'FIELD', p_alternate_item_id ); -- Invalid Item 1
6588: Fnd_Msg_Pub.ADD;
6589: RAISE FND_API.G_EXC_ERROR;
6590: END IF;
6591: --Get UC associated with workorder

Line 6611: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_IVLD_REQ_FOR_CHG'); --Item Change is not posible for Item Based requirement type.

6607: );
6608: END IF;
6609: ELSE
6610: --Only item based requirement. In this case Raise Exception as item change is only possible for item group or position based demand.
6611: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_IVLD_REQ_FOR_CHG'); --Item Change is not posible for Item Based requirement type.
6612: RAISE FND_API.G_EXC_ERROR;
6613: END IF;
6614: --Get primary uom of new item
6615: OPEN Get_Item_Uom_Code(p_alternate_item_id,l_current_mat_dtl_rec.organization_id);

Line 6619: Fnd_Message.SET_NAME('AHL','AHL_ITEM_UOM_MISSING'); --Missing UOM at Item Setup for Item 1

6615: OPEN Get_Item_Uom_Code(p_alternate_item_id,l_current_mat_dtl_rec.organization_id);
6616: FETCH Get_Item_Uom_Code INTO l_item_name, l_uom_code;
6617: CLOSE Get_Item_Uom_Code;
6618: IF (l_uom_code IS NULL) THEN
6619: Fnd_Message.SET_NAME('AHL','AHL_ITEM_UOM_MISSING'); --Missing UOM at Item Setup for Item 1
6620: FND_MESSAGE.set_token( 'ITEM', l_item_name );
6621: Fnd_Msg_Pub.ADD;
6622: RAISE FND_API.G_EXC_ERROR;
6623: END IF;

Line 6620: FND_MESSAGE.set_token( 'ITEM', l_item_name );

6616: FETCH Get_Item_Uom_Code INTO l_item_name, l_uom_code;
6617: CLOSE Get_Item_Uom_Code;
6618: IF (l_uom_code IS NULL) THEN
6619: Fnd_Message.SET_NAME('AHL','AHL_ITEM_UOM_MISSING'); --Missing UOM at Item Setup for Item 1
6620: FND_MESSAGE.set_token( 'ITEM', l_item_name );
6621: Fnd_Msg_Pub.ADD;
6622: RAISE FND_API.G_EXC_ERROR;
6623: END IF;
6624: --After Validation of item under item group or position. call item change procedure.