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

Line 141: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );

137:
138: -- Validate the input parameter
139: IF (p_uc_parent_rec.node_type IS NULL OR p_uc_parent_rec.node_type NOT IN ('I', 'E', 'X') OR
140: (p_uc_parent_rec.instance_id IS NULL AND p_uc_parent_rec.relationship_id IS NULL))THEN
141: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );
142: FND_MSG_PUB.add;
143: END IF;
144: IF p_uc_parent_rec.node_type = 'I' THEN
145: IF p_uc_parent_rec.instance_id IS NULL OR p_uc_parent_rec.relationship_id IS NULL THEN

Line 146: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );

142: FND_MSG_PUB.add;
143: END IF;
144: IF p_uc_parent_rec.node_type = 'I' THEN
145: IF p_uc_parent_rec.instance_id IS NULL OR p_uc_parent_rec.relationship_id IS NULL THEN
146: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );
147: FND_MSG_PUB.add;
148: ELSE
149: OPEN check_installed_instance;
150: FETCH check_installed_instance INTO l_dummy;

Line 152: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );

148: ELSE
149: OPEN check_installed_instance;
150: FETCH check_installed_instance INTO l_dummy;
151: IF check_installed_instance%NOTFOUND THEN
152: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );
153: FND_MSG_PUB.add;
154: END IF;
155: CLOSE check_installed_instance;
156: END IF;

Line 159: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );

155: CLOSE check_installed_instance;
156: END IF;
157: ELSIF p_uc_parent_rec.node_type = 'M' THEN
158: IF p_uc_parent_rec.instance_id IS NOT NULL OR p_uc_parent_rec.relationship_id IS NULL THEN
159: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );
160: FND_MSG_PUB.add;
161: ELSE
162: OPEN check_relationship;
163: FETCH check_relationship INTO l_dummy;

Line 165: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );

161: ELSE
162: OPEN check_relationship;
163: FETCH check_relationship INTO l_dummy;
164: IF check_relationship%NOTFOUND THEN
165: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );
166: FND_MSG_PUB.add;
167: END IF;
168: CLOSE check_relationship;
169: END IF;

Line 172: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );

168: CLOSE check_relationship;
169: END IF;
170: ELSIF p_uc_parent_rec.node_type = 'X' THEN
171: IF p_uc_parent_rec.instance_id IS NULL THEN
172: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );
173: FND_MSG_PUB.add;
174: ELSE
175: OPEN check_instance;
176: FETCH check_instance INTO l_dummy;

Line 178: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );

174: ELSE
175: OPEN check_instance;
176: FETCH check_instance INTO l_dummy;
177: IF check_instance%NOTFOUND THEN
178: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );
179: FND_MSG_PUB.add;
180: END IF;
181: CLOSE check_instance;
182: END IF;

Line 607: FND_MESSAGE.set_name( 'AHL','AHL_UC_POSITION_INVALID' );

603: ELSE
604: OPEN get_position_necessity(p_relationship_id);
605: FETCH get_position_necessity INTO l_pos_necessity_meaning;
606: IF get_position_necessity%NOTFOUND THEN
607: FND_MESSAGE.set_name( 'AHL','AHL_UC_POSITION_INVALID' );
608: FND_MESSAGE.set_token('POSITION', p_relationship_id);
609: FND_MSG_PUB.add;
610: CLOSE get_position_necessity;
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 608: FND_MESSAGE.set_token('POSITION', p_relationship_id);

604: OPEN get_position_necessity(p_relationship_id);
605: FETCH get_position_necessity INTO l_pos_necessity_meaning;
606: IF get_position_necessity%NOTFOUND THEN
607: FND_MESSAGE.set_name( 'AHL','AHL_UC_POSITION_INVALID' );
608: FND_MESSAGE.set_token('POSITION', p_relationship_id);
609: FND_MSG_PUB.add;
610: CLOSE get_position_necessity;
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: ELSE

Line 634: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_INVALID' );

630: BEGIN
631: OPEN get_part_info(p_instance_id);
632: FETCH get_part_info INTO l_part_info;
633: IF get_part_info%NOTFOUND THEN
634: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_INVALID' );
635: FND_MESSAGE.set_token('INSTANCE', p_instance_id);
636: FND_MSG_PUB.add;
637: CLOSE get_part_info;
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 635: FND_MESSAGE.set_token('INSTANCE', p_instance_id);

631: OPEN get_part_info(p_instance_id);
632: FETCH get_part_info INTO l_part_info;
633: IF get_part_info%NOTFOUND THEN
634: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_INVALID' );
635: FND_MESSAGE.set_token('INSTANCE', p_instance_id);
636: FND_MSG_PUB.add;
637: CLOSE get_part_info;
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: ELSE

Line 674: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_ID_INVALID' );

670: -- SATHAPLI::Enigma code changes, 02-Sep-2008 - fetch the ata_code as well
671: OPEN get_uc_header_attr(p_uc_header_id);
672: FETCH get_uc_header_attr INTO l_root_instance_id, l_root_mc_hdr_id, l_root_relationship_id, l_root_ata_code;
673: IF get_uc_header_attr%NOTFOUND THEN
674: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_ID_INVALID' );
675: FND_MESSAGE.set_token('UC_HEADER_ID', p_uc_header_id);
676: FND_MSG_PUB.add;
677: CLOSE get_uc_header_attr;
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 675: FND_MESSAGE.set_token('UC_HEADER_ID', p_uc_header_id);

671: OPEN get_uc_header_attr(p_uc_header_id);
672: FETCH get_uc_header_attr INTO l_root_instance_id, l_root_mc_hdr_id, l_root_relationship_id, l_root_ata_code;
673: IF get_uc_header_attr%NOTFOUND THEN
674: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_ID_INVALID' );
675: FND_MESSAGE.set_token('UC_HEADER_ID', p_uc_header_id);
676: FND_MSG_PUB.add;
677: CLOSE get_uc_header_attr;
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679: ELSE

Line 1377: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');

1373: --Validate input parameter p_uc_header_id, its two status
1374: OPEN check_uc_header;
1375: FETCH check_uc_header INTO l_uc_header_attr;
1376: IF check_uc_header%NOTFOUND THEN
1377: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
1378: FND_MESSAGE.set_token('NAME', 'uc_header_id');
1379: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
1380: FND_MSG_PUB.add;
1381: CLOSE check_uc_header;

Line 1378: FND_MESSAGE.set_token('NAME', 'uc_header_id');

1374: OPEN check_uc_header;
1375: FETCH check_uc_header INTO l_uc_header_attr;
1376: IF check_uc_header%NOTFOUND THEN
1377: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
1378: FND_MESSAGE.set_token('NAME', 'uc_header_id');
1379: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
1380: FND_MSG_PUB.add;
1381: CLOSE check_uc_header;
1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1379: FND_MESSAGE.set_token('VALUE', p_uc_header_id);

1375: FETCH check_uc_header INTO l_uc_header_attr;
1376: IF check_uc_header%NOTFOUND THEN
1377: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
1378: FND_MESSAGE.set_token('NAME', 'uc_header_id');
1379: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
1380: FND_MSG_PUB.add;
1381: CLOSE check_uc_header;
1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1383: ELSE

Line 1387: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );

1383: ELSE
1384:
1385: -- ACL :: Changes for R12
1386: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN
1387: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
1388: FND_MSG_PUB.add;
1389: CLOSE check_uc_header;
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: END IF;

Line 1401: FND_MESSAGE.set_name( 'AHL','AHL_UC_STATUS_PENDING' );

1397: l_root_active_uc_status_code,
1398: l_root_uc_ovn);
1399: IF (l_root_uc_status_code = 'APPROVAL_PENDING' OR
1400: l_root_active_uc_status_code = 'APPROVAL_PENDING') THEN
1401: FND_MESSAGE.set_name( 'AHL','AHL_UC_STATUS_PENDING' );
1402: FND_MESSAGE.set_token('UC_HEADER_ID', l_root_uc_header_id);
1403: FND_MSG_PUB.add;
1404: CLOSE check_uc_header;
1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1402: FND_MESSAGE.set_token('UC_HEADER_ID', l_root_uc_header_id);

1398: l_root_uc_ovn);
1399: IF (l_root_uc_status_code = 'APPROVAL_PENDING' OR
1400: l_root_active_uc_status_code = 'APPROVAL_PENDING') THEN
1401: FND_MESSAGE.set_name( 'AHL','AHL_UC_STATUS_PENDING' );
1402: FND_MESSAGE.set_token('UC_HEADER_ID', l_root_uc_header_id);
1403: FND_MSG_PUB.add;
1404: CLOSE check_uc_header;
1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1406: ELSE

Line 1419: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');

1415: l_mc_top_rel_id,
1416: l_mc_name,
1417: l_mc_revision;
1418: IF check_mc_header%NOTFOUND THEN
1419: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
1420: FND_MESSAGE.set_token('NAME', 'mc_header_id');
1421: FND_MESSAGE.set_token('VALUE', p_mc_header_id);
1422: FND_MSG_PUB.add;
1423: CLOSE check_mc_header;

Line 1420: FND_MESSAGE.set_token('NAME', 'mc_header_id');

1416: l_mc_name,
1417: l_mc_revision;
1418: IF check_mc_header%NOTFOUND THEN
1419: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
1420: FND_MESSAGE.set_token('NAME', 'mc_header_id');
1421: FND_MESSAGE.set_token('VALUE', p_mc_header_id);
1422: FND_MSG_PUB.add;
1423: CLOSE check_mc_header;
1424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1421: FND_MESSAGE.set_token('VALUE', p_mc_header_id);

1417: l_mc_revision;
1418: IF check_mc_header%NOTFOUND THEN
1419: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
1420: FND_MESSAGE.set_token('NAME', 'mc_header_id');
1421: FND_MESSAGE.set_token('VALUE', p_mc_header_id);
1422: FND_MSG_PUB.add;
1423: CLOSE check_mc_header;
1424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1425: ELSE

Line 1427: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_NOT_COMPLETE' );

1423: CLOSE check_mc_header;
1424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1425: ELSE
1426: IF l_mc_status_code <> 'COMPLETE' THEN
1427: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_NOT_COMPLETE' );
1428: FND_MESSAGE.set_token('NAME', l_mc_name);
1429: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1430: FND_MSG_PUB.add;
1431: CLOSE check_mc_header;

Line 1428: FND_MESSAGE.set_token('NAME', l_mc_name);

1424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1425: ELSE
1426: IF l_mc_status_code <> 'COMPLETE' THEN
1427: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_NOT_COMPLETE' );
1428: FND_MESSAGE.set_token('NAME', l_mc_name);
1429: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1430: FND_MSG_PUB.add;
1431: CLOSE check_mc_header;
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1429: FND_MESSAGE.set_token('REVISION', l_mc_revision);

1425: ELSE
1426: IF l_mc_status_code <> 'COMPLETE' THEN
1427: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_NOT_COMPLETE' );
1428: FND_MESSAGE.set_token('NAME', l_mc_name);
1429: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1430: FND_MSG_PUB.add;
1431: CLOSE check_mc_header;
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1433: ELSIF l_mc_header_id = l_uc_header_attr.mc_header_id THEN

Line 1434: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_MIGRATE_SAME' );

1430: FND_MSG_PUB.add;
1431: CLOSE check_mc_header;
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1433: ELSIF l_mc_header_id = l_uc_header_attr.mc_header_id THEN
1434: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_MIGRATE_SAME' );
1435: FND_MESSAGE.set_token('NAME', l_mc_name);
1436: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1437: FND_MSG_PUB.add;
1438: CLOSE check_mc_header;

Line 1435: FND_MESSAGE.set_token('NAME', l_mc_name);

1431: CLOSE check_mc_header;
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1433: ELSIF l_mc_header_id = l_uc_header_attr.mc_header_id THEN
1434: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_MIGRATE_SAME' );
1435: FND_MESSAGE.set_token('NAME', l_mc_name);
1436: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1437: FND_MSG_PUB.add;
1438: CLOSE check_mc_header;
1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1436: FND_MESSAGE.set_token('REVISION', l_mc_revision);

1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1433: ELSIF l_mc_header_id = l_uc_header_attr.mc_header_id THEN
1434: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_MIGRATE_SAME' );
1435: FND_MESSAGE.set_token('NAME', l_mc_name);
1436: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1437: FND_MSG_PUB.add;
1438: CLOSE check_mc_header;
1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1440: ELSE

Line 1468: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_NOT_MATCH' );

1464: --dbms_output.put_line('l_root_uc_header_id='||l_root_uc_header_id||' l_mc_top_rel_id='||l_mc_top_rel_id);
1465: --dbms_output.put_line('inventory_item_id='||l_uc_header_attr.inventory_item_id||' inventory_org_id='||l_uc_header_attr.inventory_org_id);
1466: --dbms_output.put_line('revision='||l_uc_header_attr.inventory_revision||' quantity='||l_uc_header_attr.quantity);
1467: --dbms_output.put_line('uom='||l_uc_header_attr.unit_of_measure);
1468: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_NOT_MATCH' );
1469: FND_MSG_PUB.add;
1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1471: ELSE
1472: --Item matches, can be migrated and thus change the mc_header_id of the UC header

Line 1488: FND_MESSAGE.set_name( 'AHL','AHL_UC_UNIT_UNINSTALLED' );

1484: --Get its position_reference
1485: OPEN get_position_reference(l_parent_instance_id, l_uc_header_attr.instance_id);
1486: FETCH get_position_reference INTO l_position_info;
1487: IF get_position_reference%NOTFOUND THEN
1488: FND_MESSAGE.set_name( 'AHL','AHL_UC_UNIT_UNINSTALLED' );
1489: FND_MESSAGE.set_token('CHILD',l_uc_header_attr.instance_id);
1490: FND_MESSAGE.set_token('PARENT',l_parent_instance_id);
1491: FND_MSG_PUB.add;
1492: CLOSE get_position_reference;

Line 1489: FND_MESSAGE.set_token('CHILD',l_uc_header_attr.instance_id);

1485: OPEN get_position_reference(l_parent_instance_id, l_uc_header_attr.instance_id);
1486: FETCH get_position_reference INTO l_position_info;
1487: IF get_position_reference%NOTFOUND THEN
1488: FND_MESSAGE.set_name( 'AHL','AHL_UC_UNIT_UNINSTALLED' );
1489: FND_MESSAGE.set_token('CHILD',l_uc_header_attr.instance_id);
1490: FND_MESSAGE.set_token('PARENT',l_parent_instance_id);
1491: FND_MSG_PUB.add;
1492: CLOSE get_position_reference;
1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1490: FND_MESSAGE.set_token('PARENT',l_parent_instance_id);

1486: FETCH get_position_reference INTO l_position_info;
1487: IF get_position_reference%NOTFOUND THEN
1488: FND_MESSAGE.set_name( 'AHL','AHL_UC_UNIT_UNINSTALLED' );
1489: FND_MESSAGE.set_token('CHILD',l_uc_header_attr.instance_id);
1490: FND_MESSAGE.set_token('PARENT',l_parent_instance_id);
1491: FND_MSG_PUB.add;
1492: CLOSE get_position_reference;
1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1494: END IF;

Line 1515: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_NOT_MATCH' );

1511: l_uc_header_attr.inventory_revision,
1512: l_uc_header_attr.quantity,
1513: l_uc_header_attr.unit_of_measure);
1514: IF NOT l_item_match THEN
1515: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_NOT_MATCH' );
1516: FND_MSG_PUB.add;
1517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1518: ELSE
1519: --Make the sub unit an extra node in its parent unit context and

Line 1562: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_NOT_MATCH' );

1558: l_uc_header_attr.inventory_revision,
1559: l_uc_header_attr.quantity,
1560: l_uc_header_attr.unit_of_measure);
1561: IF NOT l_item_match THEN
1562: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_NOT_MATCH' );
1563: FND_MSG_PUB.add;
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: ELSE
1566: --Could be migrated but will be still extra node to its parent unit

Line 1595: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

1591: WHERE unit_config_header_id = p_uc_header_id
1592: AND object_version_number = l_uc_header_attr.object_version_number;
1593: END IF;
1594: IF SQL%ROWCOUNT = 0 THEN
1595: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );
1596: FND_MSG_PUB.add;
1597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1598: END IF;
1599:

Line 1604: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');

1600: --Copy the change to UC history table
1601: ahl_util_uc_pkg.copy_uc_header_to_history(p_uc_header_id, l_return_status);
1602: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1604: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1605: FND_MSG_PUB.add;
1606: END IF;
1607:
1608: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1773: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

1769: last_update_login = fnd_global.login_id
1770: WHERE unit_config_header_id = l_root_uc_header_id
1771: AND object_version_number = l_root_uc_ovn;
1772: IF SQL%ROWCOUNT = 0 THEN
1773: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );
1774: FND_MSG_PUB.add;
1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1776: END IF;
1777:

Line 1782: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');

1778: --Copy the change to UC history table
1779: ahl_util_uc_pkg.copy_uc_header_to_history(l_root_uc_header_id, l_return_status);
1780: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1781: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1782: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1783: FND_MSG_PUB.add;
1784: END IF;
1785: ELSIF (l_evaluation_status = 'F' AND l_root_uc_status_code = 'COMPLETE') THEN
1786: UPDATE ahl_unit_config_headers

Line 1796: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

1792: last_update_login = fnd_global.login_id
1793: WHERE unit_config_header_id = l_root_uc_header_id
1794: AND object_version_number = l_root_uc_ovn;
1795: IF SQL%ROWCOUNT = 0 THEN
1796: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );
1797: FND_MSG_PUB.add;
1798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1799: END IF;
1800:

Line 1805: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');

1801: --Copy the change to UC history table
1802: ahl_util_uc_pkg.copy_uc_header_to_history(l_root_uc_header_id, l_return_status);
1803: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1805: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1806: FND_MSG_PUB.add;
1807: END IF;
1808: ELSIF (l_root_uc_status_code IN ('COMPLETE', 'INCOMPLETE') AND
1809: (l_root_active_uc_status_code IS NULL OR

Line 1820: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

1816: last_update_login = fnd_global.login_id
1817: WHERE unit_config_header_id = l_root_uc_header_id
1818: AND object_version_number = l_root_uc_ovn;
1819: IF SQL%ROWCOUNT = 0 THEN
1820: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );
1821: FND_MSG_PUB.add;
1822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1823: END IF;
1824:

Line 1829: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');

1825: --Copy the change to UC history table
1826: ahl_util_uc_pkg.copy_uc_header_to_history(l_root_uc_header_id, l_return_status);
1827: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1828: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1829: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1830: FND_MSG_PUB.add;
1831: END IF;
1832: END IF;
1833:

Line 2099: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

2095: --Validate the input parameter p_instance_id
2096: OPEN check_uc_instance;
2097: FETCH check_uc_instance INTO l_check_uc_instance;
2098: IF check_uc_instance%NOTFOUND THEN
2099: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2100: FND_MESSAGE.set_token('NAME', 'instance_id');
2101: FND_MESSAGE.set_token('VALUE', p_instance_id);
2102: FND_MSG_PUB.add;
2103: CLOSE check_uc_instance;

Line 2100: FND_MESSAGE.set_token('NAME', 'instance_id');

2096: OPEN check_uc_instance;
2097: FETCH check_uc_instance INTO l_check_uc_instance;
2098: IF check_uc_instance%NOTFOUND THEN
2099: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2100: FND_MESSAGE.set_token('NAME', 'instance_id');
2101: FND_MESSAGE.set_token('VALUE', p_instance_id);
2102: FND_MSG_PUB.add;
2103: CLOSE check_uc_instance;
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2101: FND_MESSAGE.set_token('VALUE', p_instance_id);

2097: FETCH check_uc_instance INTO l_check_uc_instance;
2098: IF check_uc_instance%NOTFOUND THEN
2099: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2100: FND_MESSAGE.set_token('NAME', 'instance_id');
2101: FND_MESSAGE.set_token('VALUE', p_instance_id);
2102: FND_MSG_PUB.add;
2103: CLOSE check_uc_instance;
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2105: ELSE

Line 2113: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

2109: --Validate the input parameter p_relationship_id
2110: OPEN check_mc_relationship;
2111: FETCH check_mc_relationship INTO l_check_mc_relationship;
2112: IF check_mc_relationship%NOTFOUND THEN
2113: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2114: FND_MESSAGE.set_token('NAME', 'relationship_id');
2115: FND_MESSAGE.set_token('VALUE', p_relationship_id);
2116: FND_MSG_PUB.add;
2117: CLOSE check_mc_relationship;

Line 2114: FND_MESSAGE.set_token('NAME', 'relationship_id');

2110: OPEN check_mc_relationship;
2111: FETCH check_mc_relationship INTO l_check_mc_relationship;
2112: IF check_mc_relationship%NOTFOUND THEN
2113: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2114: FND_MESSAGE.set_token('NAME', 'relationship_id');
2115: FND_MESSAGE.set_token('VALUE', p_relationship_id);
2116: FND_MSG_PUB.add;
2117: CLOSE check_mc_relationship;
2118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2115: FND_MESSAGE.set_token('VALUE', p_relationship_id);

2111: FETCH check_mc_relationship INTO l_check_mc_relationship;
2112: IF check_mc_relationship%NOTFOUND THEN
2113: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2114: FND_MESSAGE.set_token('NAME', 'relationship_id');
2115: FND_MESSAGE.set_token('VALUE', p_relationship_id);
2116: FND_MSG_PUB.add;
2117: CLOSE check_mc_relationship;
2118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2119: ELSE

Line 2141: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_NOT_MATCH' );

2137: END IF;
2138: END LOOP;
2139: */
2140: IF NOT l_item_match THEN
2141: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_NOT_MATCH' );
2142: FND_MESSAGE.set_token('INSTANCE', p_instance_id);
2143: FND_MSG_PUB.add;
2144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2145: END IF;

Line 2142: FND_MESSAGE.set_token('INSTANCE', p_instance_id);

2138: END LOOP;
2139: */
2140: IF NOT l_item_match THEN
2141: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_NOT_MATCH' );
2142: FND_MESSAGE.set_token('INSTANCE', p_instance_id);
2143: FND_MSG_PUB.add;
2144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2145: END IF;
2146:

Line 2232: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_HARD_FAIL' );

2228: --Positions match but items or sub-configs don't match, then we define it as a hard failure
2229: --in Part Change but still an extra node in migration. Both position_key and position_ref_code
2230: --are unique across siblings.
2231: IF NOT l_matched THEN
2232: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_HARD_FAIL' );
2233: FND_MESSAGE.set_token('INSTANCE', l_get_csi_child.instance_id);
2234: FND_MSG_PUB.add;
2235: RAISE FND_API.G_EXC_ERROR;
2236: END IF;

Line 2233: FND_MESSAGE.set_token('INSTANCE', l_get_csi_child.instance_id);

2229: --in Part Change but still an extra node in migration. Both position_key and position_ref_code
2230: --are unique across siblings.
2231: IF NOT l_matched THEN
2232: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_HARD_FAIL' );
2233: FND_MESSAGE.set_token('INSTANCE', l_get_csi_child.instance_id);
2234: FND_MSG_PUB.add;
2235: RAISE FND_API.G_EXC_ERROR;
2236: END IF;
2237: END IF; --whether position_key or position_ref_code matches