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 130: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );

126:
127: -- Validate the input parameter
128: IF (p_uc_parent_rec.node_type IS NULL OR p_uc_parent_rec.node_type NOT IN ('I', 'E', 'X') OR
129: (p_uc_parent_rec.instance_id IS NULL AND p_uc_parent_rec.relationship_id IS NULL))THEN
130: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );
131: FND_MSG_PUB.add;
132: END IF;
133: IF p_uc_parent_rec.node_type = 'I' THEN
134: IF p_uc_parent_rec.instance_id IS NULL OR p_uc_parent_rec.relationship_id IS NULL THEN

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

131: FND_MSG_PUB.add;
132: END IF;
133: IF p_uc_parent_rec.node_type = 'I' THEN
134: IF p_uc_parent_rec.instance_id IS NULL OR p_uc_parent_rec.relationship_id IS NULL THEN
135: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );
136: FND_MSG_PUB.add;
137: ELSE
138: OPEN check_installed_instance;
139: FETCH check_installed_instance INTO l_dummy;

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

137: ELSE
138: OPEN check_installed_instance;
139: FETCH check_installed_instance INTO l_dummy;
140: IF check_installed_instance%NOTFOUND THEN
141: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );
142: FND_MSG_PUB.add;
143: END IF;
144: CLOSE check_installed_instance;
145: END IF;

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

144: CLOSE check_installed_instance;
145: END IF;
146: ELSIF p_uc_parent_rec.node_type = 'M' THEN
147: IF p_uc_parent_rec.instance_id IS NOT NULL OR p_uc_parent_rec.relationship_id IS NULL THEN
148: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );
149: FND_MSG_PUB.add;
150: ELSE
151: OPEN check_relationship;
152: FETCH check_relationship INTO l_dummy;

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

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

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

157: CLOSE check_relationship;
158: END IF;
159: ELSIF p_uc_parent_rec.node_type = 'X' THEN
160: IF p_uc_parent_rec.instance_id IS NULL THEN
161: FND_MESSAGE.set_name( 'AHL','AHL_UC_NODE_INVALID' );
162: FND_MSG_PUB.add;
163: ELSE
164: OPEN check_instance;
165: FETCH check_instance INTO l_dummy;

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

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

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

589: ELSE
590: OPEN get_position_necessity(p_relationship_id);
591: FETCH get_position_necessity INTO l_pos_necessity_meaning;
592: IF get_position_necessity%NOTFOUND THEN
593: FND_MESSAGE.set_name( 'AHL','AHL_UC_POSITION_INVALID' );
594: FND_MESSAGE.set_token('POSITION', p_relationship_id);
595: FND_MSG_PUB.add;
596: CLOSE get_position_necessity;
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

590: OPEN get_position_necessity(p_relationship_id);
591: FETCH get_position_necessity INTO l_pos_necessity_meaning;
592: IF get_position_necessity%NOTFOUND THEN
593: FND_MESSAGE.set_name( 'AHL','AHL_UC_POSITION_INVALID' );
594: FND_MESSAGE.set_token('POSITION', p_relationship_id);
595: FND_MSG_PUB.add;
596: CLOSE get_position_necessity;
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: ELSE

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

616: BEGIN
617: OPEN get_part_info(p_instance_id);
618: FETCH get_part_info INTO l_part_info;
619: IF get_part_info%NOTFOUND THEN
620: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_INVALID' );
621: FND_MESSAGE.set_token('INSTANCE', p_instance_id);
622: FND_MSG_PUB.add;
623: CLOSE get_part_info;
624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

617: OPEN get_part_info(p_instance_id);
618: FETCH get_part_info INTO l_part_info;
619: IF get_part_info%NOTFOUND THEN
620: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_INVALID' );
621: FND_MESSAGE.set_token('INSTANCE', p_instance_id);
622: FND_MSG_PUB.add;
623: CLOSE get_part_info;
624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: ELSE

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

656: -- SATHAPLI::Enigma code changes, 02-Sep-2008 - fetch the ata_code as well
657: OPEN get_uc_header_attr(p_uc_header_id);
658: FETCH get_uc_header_attr INTO l_root_instance_id, l_root_mc_hdr_id, l_root_relationship_id, l_root_ata_code;
659: IF get_uc_header_attr%NOTFOUND THEN
660: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_ID_INVALID' );
661: FND_MESSAGE.set_token('UC_HEADER_ID', p_uc_header_id);
662: FND_MSG_PUB.add;
663: CLOSE get_uc_header_attr;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

657: OPEN get_uc_header_attr(p_uc_header_id);
658: FETCH get_uc_header_attr INTO l_root_instance_id, l_root_mc_hdr_id, l_root_relationship_id, l_root_ata_code;
659: IF get_uc_header_attr%NOTFOUND THEN
660: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_ID_INVALID' );
661: FND_MESSAGE.set_token('UC_HEADER_ID', p_uc_header_id);
662: FND_MSG_PUB.add;
663: CLOSE get_uc_header_attr;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: ELSE

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

1310: --Validate input parameter p_uc_header_id, its two status
1311: OPEN check_uc_header;
1312: FETCH check_uc_header INTO l_uc_header_attr;
1313: IF check_uc_header%NOTFOUND THEN
1314: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
1315: FND_MESSAGE.set_token('NAME', 'uc_header_id');
1316: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
1317: FND_MSG_PUB.add;
1318: CLOSE check_uc_header;

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

1311: OPEN check_uc_header;
1312: FETCH check_uc_header INTO l_uc_header_attr;
1313: IF check_uc_header%NOTFOUND THEN
1314: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
1315: FND_MESSAGE.set_token('NAME', 'uc_header_id');
1316: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
1317: FND_MSG_PUB.add;
1318: CLOSE check_uc_header;
1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1312: FETCH check_uc_header INTO l_uc_header_attr;
1313: IF check_uc_header%NOTFOUND THEN
1314: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
1315: FND_MESSAGE.set_token('NAME', 'uc_header_id');
1316: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
1317: FND_MSG_PUB.add;
1318: CLOSE check_uc_header;
1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1320: ELSE

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

1320: ELSE
1321:
1322: -- ACL :: Changes for R12
1323: 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
1324: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
1325: FND_MSG_PUB.add;
1326: CLOSE check_uc_header;
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END IF;

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

1334: l_root_active_uc_status_code,
1335: l_root_uc_ovn);
1336: IF (l_root_uc_status_code = 'APPROVAL_PENDING' OR
1337: l_root_active_uc_status_code = 'APPROVAL_PENDING') THEN
1338: FND_MESSAGE.set_name( 'AHL','AHL_UC_STATUS_PENDING' );
1339: FND_MESSAGE.set_token('UC_HEADER_ID', l_root_uc_header_id);
1340: FND_MSG_PUB.add;
1341: CLOSE check_uc_header;
1342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1335: l_root_uc_ovn);
1336: IF (l_root_uc_status_code = 'APPROVAL_PENDING' OR
1337: l_root_active_uc_status_code = 'APPROVAL_PENDING') THEN
1338: FND_MESSAGE.set_name( 'AHL','AHL_UC_STATUS_PENDING' );
1339: FND_MESSAGE.set_token('UC_HEADER_ID', l_root_uc_header_id);
1340: FND_MSG_PUB.add;
1341: CLOSE check_uc_header;
1342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1343: ELSE

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

1352: l_mc_top_rel_id,
1353: l_mc_name,
1354: l_mc_revision;
1355: IF check_mc_header%NOTFOUND THEN
1356: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
1357: FND_MESSAGE.set_token('NAME', 'mc_header_id');
1358: FND_MESSAGE.set_token('VALUE', p_mc_header_id);
1359: FND_MSG_PUB.add;
1360: CLOSE check_mc_header;

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

1353: l_mc_name,
1354: l_mc_revision;
1355: IF check_mc_header%NOTFOUND THEN
1356: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
1357: FND_MESSAGE.set_token('NAME', 'mc_header_id');
1358: FND_MESSAGE.set_token('VALUE', p_mc_header_id);
1359: FND_MSG_PUB.add;
1360: CLOSE check_mc_header;
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1354: l_mc_revision;
1355: IF check_mc_header%NOTFOUND THEN
1356: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
1357: FND_MESSAGE.set_token('NAME', 'mc_header_id');
1358: FND_MESSAGE.set_token('VALUE', p_mc_header_id);
1359: FND_MSG_PUB.add;
1360: CLOSE check_mc_header;
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1362: ELSE

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

1360: CLOSE check_mc_header;
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1362: ELSE
1363: IF l_mc_status_code <> 'COMPLETE' THEN
1364: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_NOT_COMPLETE' );
1365: FND_MESSAGE.set_token('NAME', l_mc_name);
1366: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1367: FND_MSG_PUB.add;
1368: CLOSE check_mc_header;

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

1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1362: ELSE
1363: IF l_mc_status_code <> 'COMPLETE' THEN
1364: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_NOT_COMPLETE' );
1365: FND_MESSAGE.set_token('NAME', l_mc_name);
1366: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1367: FND_MSG_PUB.add;
1368: CLOSE check_mc_header;
1369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1362: ELSE
1363: IF l_mc_status_code <> 'COMPLETE' THEN
1364: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_NOT_COMPLETE' );
1365: FND_MESSAGE.set_token('NAME', l_mc_name);
1366: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1367: FND_MSG_PUB.add;
1368: CLOSE check_mc_header;
1369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1370: ELSIF l_mc_header_id = l_uc_header_attr.mc_header_id THEN

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

1367: FND_MSG_PUB.add;
1368: CLOSE check_mc_header;
1369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1370: ELSIF l_mc_header_id = l_uc_header_attr.mc_header_id THEN
1371: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_MIGRATE_SAME' );
1372: FND_MESSAGE.set_token('NAME', l_mc_name);
1373: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1374: FND_MSG_PUB.add;
1375: CLOSE check_mc_header;

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

1368: CLOSE check_mc_header;
1369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1370: ELSIF l_mc_header_id = l_uc_header_attr.mc_header_id THEN
1371: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_MIGRATE_SAME' );
1372: FND_MESSAGE.set_token('NAME', l_mc_name);
1373: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1374: FND_MSG_PUB.add;
1375: CLOSE check_mc_header;
1376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1370: ELSIF l_mc_header_id = l_uc_header_attr.mc_header_id THEN
1371: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_MIGRATE_SAME' );
1372: FND_MESSAGE.set_token('NAME', l_mc_name);
1373: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1374: FND_MSG_PUB.add;
1375: CLOSE check_mc_header;
1376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1377: ELSE

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

1401: --dbms_output.put_line('l_root_uc_header_id='||l_root_uc_header_id||' l_mc_top_rel_id='||l_mc_top_rel_id);
1402: --dbms_output.put_line('inventory_item_id='||l_uc_header_attr.inventory_item_id||' inventory_org_id='||l_uc_header_attr.inventory_org_id);
1403: --dbms_output.put_line('revision='||l_uc_header_attr.inventory_revision||' quantity='||l_uc_header_attr.quantity);
1404: --dbms_output.put_line('uom='||l_uc_header_attr.unit_of_measure);
1405: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_NOT_MATCH' );
1406: FND_MSG_PUB.add;
1407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1408: ELSE
1409: --Item matches, can be migrated and thus change the mc_header_id of the UC header

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

1421: --Get its position_reference
1422: OPEN get_position_reference(l_parent_instance_id, l_uc_header_attr.instance_id);
1423: FETCH get_position_reference INTO l_position_info;
1424: IF get_position_reference%NOTFOUND THEN
1425: FND_MESSAGE.set_name( 'AHL','AHL_UC_UNIT_UNINSTALLED' );
1426: FND_MESSAGE.set_token('CHILD',l_uc_header_attr.instance_id);
1427: FND_MESSAGE.set_token('PARENT',l_parent_instance_id);
1428: FND_MSG_PUB.add;
1429: CLOSE get_position_reference;

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

1422: OPEN get_position_reference(l_parent_instance_id, l_uc_header_attr.instance_id);
1423: FETCH get_position_reference INTO l_position_info;
1424: IF get_position_reference%NOTFOUND THEN
1425: FND_MESSAGE.set_name( 'AHL','AHL_UC_UNIT_UNINSTALLED' );
1426: FND_MESSAGE.set_token('CHILD',l_uc_header_attr.instance_id);
1427: FND_MESSAGE.set_token('PARENT',l_parent_instance_id);
1428: FND_MSG_PUB.add;
1429: CLOSE get_position_reference;
1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1423: FETCH get_position_reference INTO l_position_info;
1424: IF get_position_reference%NOTFOUND THEN
1425: FND_MESSAGE.set_name( 'AHL','AHL_UC_UNIT_UNINSTALLED' );
1426: FND_MESSAGE.set_token('CHILD',l_uc_header_attr.instance_id);
1427: FND_MESSAGE.set_token('PARENT',l_parent_instance_id);
1428: FND_MSG_PUB.add;
1429: CLOSE get_position_reference;
1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1431: END IF;

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

1448: l_uc_header_attr.inventory_revision,
1449: l_uc_header_attr.quantity,
1450: l_uc_header_attr.unit_of_measure);
1451: IF NOT l_item_match THEN
1452: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_NOT_MATCH' );
1453: FND_MSG_PUB.add;
1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1455: ELSE
1456: --Make the sub unit an extra node in its parent unit context and

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

1495: l_uc_header_attr.inventory_revision,
1496: l_uc_header_attr.quantity,
1497: l_uc_header_attr.unit_of_measure);
1498: IF NOT l_item_match THEN
1499: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_NOT_MATCH' );
1500: FND_MSG_PUB.add;
1501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1502: ELSE
1503: --Could be migrated but will be still extra node to its parent unit

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

1528: WHERE unit_config_header_id = p_uc_header_id
1529: AND object_version_number = l_uc_header_attr.object_version_number;
1530: END IF;
1531: IF SQL%ROWCOUNT = 0 THEN
1532: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );
1533: FND_MSG_PUB.add;
1534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1535: END IF;
1536:

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

1537: --Copy the change to UC history table
1538: ahl_util_uc_pkg.copy_uc_header_to_history(p_uc_header_id, l_return_status);
1539: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1541: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1542: FND_MSG_PUB.add;
1543: END IF;
1544:
1545: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1706: last_update_login = fnd_global.login_id
1707: WHERE unit_config_header_id = l_root_uc_header_id
1708: AND object_version_number = l_root_uc_ovn;
1709: IF SQL%ROWCOUNT = 0 THEN
1710: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );
1711: FND_MSG_PUB.add;
1712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1713: END IF;
1714:

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

1715: --Copy the change to UC history table
1716: ahl_util_uc_pkg.copy_uc_header_to_history(l_root_uc_header_id, l_return_status);
1717: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1718: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1719: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1720: FND_MSG_PUB.add;
1721: END IF;
1722: ELSIF (l_evaluation_status = 'F' AND l_root_uc_status_code = 'COMPLETE') THEN
1723: UPDATE ahl_unit_config_headers

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

1729: last_update_login = fnd_global.login_id
1730: WHERE unit_config_header_id = l_root_uc_header_id
1731: AND object_version_number = l_root_uc_ovn;
1732: IF SQL%ROWCOUNT = 0 THEN
1733: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );
1734: FND_MSG_PUB.add;
1735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1736: END IF;
1737:

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

1738: --Copy the change to UC history table
1739: ahl_util_uc_pkg.copy_uc_header_to_history(l_root_uc_header_id, l_return_status);
1740: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1742: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1743: FND_MSG_PUB.add;
1744: END IF;
1745: ELSIF (l_root_uc_status_code IN ('COMPLETE', 'INCOMPLETE') AND
1746: (l_root_active_uc_status_code IS NULL OR

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

1753: last_update_login = fnd_global.login_id
1754: WHERE unit_config_header_id = l_root_uc_header_id
1755: AND object_version_number = l_root_uc_ovn;
1756: IF SQL%ROWCOUNT = 0 THEN
1757: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );
1758: FND_MSG_PUB.add;
1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1760: END IF;
1761:

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

1762: --Copy the change to UC history table
1763: ahl_util_uc_pkg.copy_uc_header_to_history(l_root_uc_header_id, l_return_status);
1764: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1765: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1766: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1767: FND_MSG_PUB.add;
1768: END IF;
1769: END IF;
1770:

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

2032: --Validate the input parameter p_instance_id
2033: OPEN check_uc_instance;
2034: FETCH check_uc_instance INTO l_check_uc_instance;
2035: IF check_uc_instance%NOTFOUND THEN
2036: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2037: FND_MESSAGE.set_token('NAME', 'instance_id');
2038: FND_MESSAGE.set_token('VALUE', p_instance_id);
2039: FND_MSG_PUB.add;
2040: CLOSE check_uc_instance;

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

2033: OPEN check_uc_instance;
2034: FETCH check_uc_instance INTO l_check_uc_instance;
2035: IF check_uc_instance%NOTFOUND THEN
2036: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2037: FND_MESSAGE.set_token('NAME', 'instance_id');
2038: FND_MESSAGE.set_token('VALUE', p_instance_id);
2039: FND_MSG_PUB.add;
2040: CLOSE check_uc_instance;
2041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2034: FETCH check_uc_instance INTO l_check_uc_instance;
2035: IF check_uc_instance%NOTFOUND THEN
2036: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2037: FND_MESSAGE.set_token('NAME', 'instance_id');
2038: FND_MESSAGE.set_token('VALUE', p_instance_id);
2039: FND_MSG_PUB.add;
2040: CLOSE check_uc_instance;
2041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2042: ELSE

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

2046: --Validate the input parameter p_relationship_id
2047: OPEN check_mc_relationship;
2048: FETCH check_mc_relationship INTO l_check_mc_relationship;
2049: IF check_mc_relationship%NOTFOUND THEN
2050: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2051: FND_MESSAGE.set_token('NAME', 'relationship_id');
2052: FND_MESSAGE.set_token('VALUE', p_relationship_id);
2053: FND_MSG_PUB.add;
2054: CLOSE check_mc_relationship;

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

2047: OPEN check_mc_relationship;
2048: FETCH check_mc_relationship INTO l_check_mc_relationship;
2049: IF check_mc_relationship%NOTFOUND THEN
2050: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2051: FND_MESSAGE.set_token('NAME', 'relationship_id');
2052: FND_MESSAGE.set_token('VALUE', p_relationship_id);
2053: FND_MSG_PUB.add;
2054: CLOSE check_mc_relationship;
2055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2048: FETCH check_mc_relationship INTO l_check_mc_relationship;
2049: IF check_mc_relationship%NOTFOUND THEN
2050: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2051: FND_MESSAGE.set_token('NAME', 'relationship_id');
2052: FND_MESSAGE.set_token('VALUE', p_relationship_id);
2053: FND_MSG_PUB.add;
2054: CLOSE check_mc_relationship;
2055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2056: ELSE

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

2074: END IF;
2075: END LOOP;
2076: */
2077: IF NOT l_item_match THEN
2078: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_NOT_MATCH' );
2079: FND_MESSAGE.set_token('INSTANCE', p_instance_id);
2080: FND_MSG_PUB.add;
2081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2082: END IF;

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

2075: END LOOP;
2076: */
2077: IF NOT l_item_match THEN
2078: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_NOT_MATCH' );
2079: FND_MESSAGE.set_token('INSTANCE', p_instance_id);
2080: FND_MSG_PUB.add;
2081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2082: END IF;
2083:

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

2165: --Positions match but items or sub-configs don't match, then we define it as a hard failure
2166: --in Part Change but still an extra node in migration. Both position_key and position_ref_code
2167: --are unique across siblings.
2168: IF NOT l_matched THEN
2169: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_HARD_FAIL' );
2170: FND_MESSAGE.set_token('INSTANCE', l_get_csi_child.instance_id);
2171: FND_MSG_PUB.add;
2172: RAISE FND_API.G_EXC_ERROR;
2173: END IF;

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

2166: --in Part Change but still an extra node in migration. Both position_key and position_ref_code
2167: --are unique across siblings.
2168: IF NOT l_matched THEN
2169: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_HARD_FAIL' );
2170: FND_MESSAGE.set_token('INSTANCE', l_get_csi_child.instance_id);
2171: FND_MSG_PUB.add;
2172: RAISE FND_API.G_EXC_ERROR;
2173: END IF;
2174: END IF; --whether position_key or position_ref_code matches