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

Line 147: FND_MESSAGE.Set_Name('AHL','AHL_MC_PATH_NODE_INV');

143: OPEN check_mc_ids_csr(l_pos_rec.mc_id, l_pos_rec.version_number,
144: l_pos_rec.position_key);
145: FETCH check_mc_ids_csr INTO l_junk;
146: IF (check_mc_ids_csr%NOTFOUND) THEN
147: FND_MESSAGE.Set_Name('AHL','AHL_MC_PATH_NODE_INV');
148: FND_MESSAGE.Set_Token('MC_ID',l_pos_rec.mc_id);
149: FND_MESSAGE.Set_Token('VER',l_pos_rec.version_number);
150: FND_MESSAGE.Set_Token('POS_KEY',l_pos_rec.position_key);
151: FND_MSG_PUB.ADD;

Line 148: FND_MESSAGE.Set_Token('MC_ID',l_pos_rec.mc_id);

144: l_pos_rec.position_key);
145: FETCH check_mc_ids_csr INTO l_junk;
146: IF (check_mc_ids_csr%NOTFOUND) THEN
147: FND_MESSAGE.Set_Name('AHL','AHL_MC_PATH_NODE_INV');
148: FND_MESSAGE.Set_Token('MC_ID',l_pos_rec.mc_id);
149: FND_MESSAGE.Set_Token('VER',l_pos_rec.version_number);
150: FND_MESSAGE.Set_Token('POS_KEY',l_pos_rec.position_key);
151: FND_MSG_PUB.ADD;
152: END IF;

Line 149: FND_MESSAGE.Set_Token('VER',l_pos_rec.version_number);

145: FETCH check_mc_ids_csr INTO l_junk;
146: IF (check_mc_ids_csr%NOTFOUND) THEN
147: FND_MESSAGE.Set_Name('AHL','AHL_MC_PATH_NODE_INV');
148: FND_MESSAGE.Set_Token('MC_ID',l_pos_rec.mc_id);
149: FND_MESSAGE.Set_Token('VER',l_pos_rec.version_number);
150: FND_MESSAGE.Set_Token('POS_KEY',l_pos_rec.position_key);
151: FND_MSG_PUB.ADD;
152: END IF;
153: CLOSE check_mc_ids_csr;

Line 150: FND_MESSAGE.Set_Token('POS_KEY',l_pos_rec.position_key);

146: IF (check_mc_ids_csr%NOTFOUND) THEN
147: FND_MESSAGE.Set_Name('AHL','AHL_MC_PATH_NODE_INV');
148: FND_MESSAGE.Set_Token('MC_ID',l_pos_rec.mc_id);
149: FND_MESSAGE.Set_Token('VER',l_pos_rec.version_number);
150: FND_MESSAGE.Set_Token('POS_KEY',l_pos_rec.position_key);
151: FND_MSG_PUB.ADD;
152: END IF;
153: CLOSE check_mc_ids_csr;
154:

Line 168: FND_MESSAGE.Set_Name('AHL','AHL_MC_PATH_RELNSHIP_INV');

164: p_path_position_tbl(i+1).mc_id,
165: p_path_position_tbl(i+1).version_number);
166: FETCH check_mc_relationships_csr INTO l_junk;
167: IF (check_mc_relationships_csr%NOTFOUND) THEN
168: FND_MESSAGE.Set_Name('AHL','AHL_MC_PATH_RELNSHIP_INV');
169: FND_MESSAGE.Set_Token('MC_ID',p_path_position_tbl(i+1).mc_id);
170: FND_MESSAGE.Set_Token('VER',p_path_position_tbl(i+1).version_number);
171: FND_MESSAGE.Set_Token('POS_KEY',l_pos_rec.position_key);
172: FND_MSG_PUB.ADD;

Line 169: FND_MESSAGE.Set_Token('MC_ID',p_path_position_tbl(i+1).mc_id);

165: p_path_position_tbl(i+1).version_number);
166: FETCH check_mc_relationships_csr INTO l_junk;
167: IF (check_mc_relationships_csr%NOTFOUND) THEN
168: FND_MESSAGE.Set_Name('AHL','AHL_MC_PATH_RELNSHIP_INV');
169: FND_MESSAGE.Set_Token('MC_ID',p_path_position_tbl(i+1).mc_id);
170: FND_MESSAGE.Set_Token('VER',p_path_position_tbl(i+1).version_number);
171: FND_MESSAGE.Set_Token('POS_KEY',l_pos_rec.position_key);
172: FND_MSG_PUB.ADD;
173: END IF;

Line 170: FND_MESSAGE.Set_Token('VER',p_path_position_tbl(i+1).version_number);

166: FETCH check_mc_relationships_csr INTO l_junk;
167: IF (check_mc_relationships_csr%NOTFOUND) THEN
168: FND_MESSAGE.Set_Name('AHL','AHL_MC_PATH_RELNSHIP_INV');
169: FND_MESSAGE.Set_Token('MC_ID',p_path_position_tbl(i+1).mc_id);
170: FND_MESSAGE.Set_Token('VER',p_path_position_tbl(i+1).version_number);
171: FND_MESSAGE.Set_Token('POS_KEY',l_pos_rec.position_key);
172: FND_MSG_PUB.ADD;
173: END IF;
174: CLOSE check_mc_relationships_csr;

Line 171: FND_MESSAGE.Set_Token('POS_KEY',l_pos_rec.position_key);

167: IF (check_mc_relationships_csr%NOTFOUND) THEN
168: FND_MESSAGE.Set_Name('AHL','AHL_MC_PATH_RELNSHIP_INV');
169: FND_MESSAGE.Set_Token('MC_ID',p_path_position_tbl(i+1).mc_id);
170: FND_MESSAGE.Set_Token('VER',p_path_position_tbl(i+1).version_number);
171: FND_MESSAGE.Set_Token('POS_KEY',l_pos_rec.position_key);
172: FND_MSG_PUB.ADD;
173: END IF;
174: CLOSE check_mc_relationships_csr;
175: END IF;

Line 191: FND_MESSAGE.Set_Name('AHL','AHL_MC_POSREF_INVALID');

187: p_position_ref_meaning,
188: l_position_ref_code,
189: l_return_val);
190: IF NOT(l_return_val) THEN
191: FND_MESSAGE.Set_Name('AHL','AHL_MC_POSREF_INVALID');
192: FND_MESSAGE.Set_Token('POSREF',p_position_ref_meaning);
193: FND_MSG_PUB.ADD;
194: END IF;
195: END IF;

Line 192: FND_MESSAGE.Set_Token('POSREF',p_position_ref_meaning);

188: l_position_ref_code,
189: l_return_val);
190: IF NOT(l_return_val) THEN
191: FND_MESSAGE.Set_Name('AHL','AHL_MC_POSREF_INVALID');
192: FND_MESSAGE.Set_Token('POSREF',p_position_ref_meaning);
193: FND_MSG_PUB.ADD;
194: END IF;
195: END IF;
196: ELSE

Line 217: FND_MESSAGE.Set_Name('AHL','AHL_MC_POSREF_DUPLICATE');

213: FETCH get_sibling_poskey_csr INTO l_path_tbl(l_path_tbl.LAST).position_key;
214: EXIT WHEN get_sibling_poskey_csr%NOTFOUND;
215: l_sib_pos_ref_code := get_posref_by_path(l_path_tbl, FND_API.G_TRUE);
216: IF (l_sib_pos_ref_code = l_position_ref_code) THEN
217: FND_MESSAGE.Set_Name('AHL','AHL_MC_POSREF_DUPLICATE');
218: FND_MESSAGE.Set_Token('POSREF',l_position_ref_code);
219: FND_MSG_PUB.ADD;
220: END IF;
221: END LOOP;

Line 218: FND_MESSAGE.Set_Token('POSREF',l_position_ref_code);

214: EXIT WHEN get_sibling_poskey_csr%NOTFOUND;
215: l_sib_pos_ref_code := get_posref_by_path(l_path_tbl, FND_API.G_TRUE);
216: IF (l_sib_pos_ref_code = l_position_ref_code) THEN
217: FND_MESSAGE.Set_Name('AHL','AHL_MC_POSREF_DUPLICATE');
218: FND_MESSAGE.Set_Token('POSREF',l_position_ref_code);
219: FND_MSG_PUB.ADD;
220: END IF;
221: END LOOP;
222: CLOSE get_sibling_poskey_csr;

Line 1096: FND_MESSAGE.Set_Name('AHL','AHL_MC_POS_INSTANCE_ID_NULL');

1092: END IF;
1093:
1094: --Step 0) Validate that p_csi_item_instance is not null and valid
1095: IF (p_csi_item_instance_id IS NULL) THEN
1096: FND_MESSAGE.Set_Name('AHL','AHL_MC_POS_INSTANCE_ID_NULL');
1097: FND_MSG_PUB.ADD;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: --Validate that the input instance is a unit

Line 1104: FND_MESSAGE.Set_Name('AHL','AHL_MC_POS_INSTANCE_ID_INV');

1100: --Validate that the input instance is a unit
1101: OPEN check_instance_top_csr (p_csi_item_instance_id);
1102: FETCH check_instance_top_csr INTO l_dummy;
1103: IF (check_instance_top_csr%NOTFOUND) THEN
1104: FND_MESSAGE.Set_Name('AHL','AHL_MC_POS_INSTANCE_ID_INV');
1105: FND_MSG_PUB.ADD;
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108: CLOSE check_instance_top_csr;

Line 1128: FND_MESSAGE.Set_Name('AHL','AHL_MC_POS_PATH_ID_INV');

1124: --Step 2) Traverse the table if there are multiple levels.
1125: -- Populate the lowest level instance id based on this query.
1126: --If table is less than 1 in size, this is invalid path
1127: IF (l_path_tbl.COUNT<1) THEN
1128: FND_MESSAGE.Set_Name('AHL','AHL_MC_POS_PATH_ID_INV');
1129: FND_MSG_PUB.ADD;
1130: RAISE FND_API.G_EXC_ERROR;
1131:
1132: --If there is only 1 row, then lowest level UC = p_csi_instance_id

Line 1433: FND_MESSAGE.Set_Name('AHL','AHL_UC_MC_HEADER_ID_INVALID');

1429: --Check Status of MC allows for editing
1430: OPEN check_mc_status_csr(p_to_mc_header_id);
1431: FETCH check_mc_status_csr INTO l_status_code, l_status;
1432: IF (check_mc_status_csr%NOTFOUND) THEN
1433: FND_MESSAGE.Set_Name('AHL','AHL_UC_MC_HEADER_ID_INVALID');
1434: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_to_mc_header_id);
1435: FND_MSG_PUB.ADD;
1436: CLOSE check_mc_status_csr;
1437: RAISE FND_API.G_EXC_ERROR;

Line 1434: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_to_mc_header_id);

1430: OPEN check_mc_status_csr(p_to_mc_header_id);
1431: FETCH check_mc_status_csr INTO l_status_code, l_status;
1432: IF (check_mc_status_csr%NOTFOUND) THEN
1433: FND_MESSAGE.Set_Name('AHL','AHL_UC_MC_HEADER_ID_INVALID');
1434: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_to_mc_header_id);
1435: FND_MSG_PUB.ADD;
1436: CLOSE check_mc_status_csr;
1437: RAISE FND_API.G_EXC_ERROR;
1438: ELSIF ( l_status_code <> 'DRAFT' AND

Line 1440: FND_MESSAGE.Set_Name('AHL','AHL_MC_EDIT_INV_MC');

1436: CLOSE check_mc_status_csr;
1437: RAISE FND_API.G_EXC_ERROR;
1438: ELSIF ( l_status_code <> 'DRAFT' AND
1439: l_status_code <> 'APPROVAL_REJECTED') THEN
1440: FND_MESSAGE.Set_Name('AHL','AHL_MC_EDIT_INV_MC');
1441: FND_MESSAGE.Set_Token('STATUS', l_status);
1442: FND_MSG_PUB.ADD;
1443: CLOSE check_mc_status_csr;
1444: RAISE FND_API.G_EXC_ERROR;

Line 1441: FND_MESSAGE.Set_Token('STATUS', l_status);

1437: RAISE FND_API.G_EXC_ERROR;
1438: ELSIF ( l_status_code <> 'DRAFT' AND
1439: l_status_code <> 'APPROVAL_REJECTED') THEN
1440: FND_MESSAGE.Set_Name('AHL','AHL_MC_EDIT_INV_MC');
1441: FND_MESSAGE.Set_Token('STATUS', l_status);
1442: FND_MSG_PUB.ADD;
1443: CLOSE check_mc_status_csr;
1444: RAISE FND_API.G_EXC_ERROR;
1445: END IF;

Line 1626: FND_MESSAGE.Set_Name('AHL','AHL_MC_HEADER_ID_INVALID');

1622: --Fetch the to mc_header_id information
1623: OPEN get_mc_id_ver_csr(p_to_mc_header_id);
1624: FETCH get_mc_id_ver_csr INTO l_mc_id, l_version_number;
1625: IF (get_mc_id_ver_csr%NOTFOUND) THEN
1626: FND_MESSAGE.Set_Name('AHL','AHL_MC_HEADER_ID_INVALID');
1627: FND_MESSAGE.Set_Token('NAME','');
1628: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_to_mc_header_id);
1629: FND_MSG_PUB.ADD;
1630: CLOSE get_mc_id_ver_csr;

Line 1627: FND_MESSAGE.Set_Token('NAME','');

1623: OPEN get_mc_id_ver_csr(p_to_mc_header_id);
1624: FETCH get_mc_id_ver_csr INTO l_mc_id, l_version_number;
1625: IF (get_mc_id_ver_csr%NOTFOUND) THEN
1626: FND_MESSAGE.Set_Name('AHL','AHL_MC_HEADER_ID_INVALID');
1627: FND_MESSAGE.Set_Token('NAME','');
1628: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_to_mc_header_id);
1629: FND_MSG_PUB.ADD;
1630: CLOSE get_mc_id_ver_csr;
1631: RAISE FND_API.G_EXC_ERROR;

Line 1628: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_to_mc_header_id);

1624: FETCH get_mc_id_ver_csr INTO l_mc_id, l_version_number;
1625: IF (get_mc_id_ver_csr%NOTFOUND) THEN
1626: FND_MESSAGE.Set_Name('AHL','AHL_MC_HEADER_ID_INVALID');
1627: FND_MESSAGE.Set_Token('NAME','');
1628: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_to_mc_header_id);
1629: FND_MSG_PUB.ADD;
1630: CLOSE get_mc_id_ver_csr;
1631: RAISE FND_API.G_EXC_ERROR;
1632: END IF;

Line 1853: FND_MESSAGE.Set_Name('AHL','AHL_MC_HEADER_ID_INVALID');

1849: --Check Status of MC allows for editing
1850: OPEN check_mc_status_csr(p_mc_header_id);
1851: FETCH check_mc_status_csr INTO l_status_code, l_status;
1852: IF (check_mc_status_csr%NOTFOUND) THEN
1853: FND_MESSAGE.Set_Name('AHL','AHL_MC_HEADER_ID_INVALID');
1854: FND_MESSAGE.Set_Token('NAME','');
1855: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_mc_header_id);
1856: FND_MSG_PUB.ADD;
1857: CLOSE check_mc_status_csr;

Line 1854: FND_MESSAGE.Set_Token('NAME','');

1850: OPEN check_mc_status_csr(p_mc_header_id);
1851: FETCH check_mc_status_csr INTO l_status_code, l_status;
1852: IF (check_mc_status_csr%NOTFOUND) THEN
1853: FND_MESSAGE.Set_Name('AHL','AHL_MC_HEADER_ID_INVALID');
1854: FND_MESSAGE.Set_Token('NAME','');
1855: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_mc_header_id);
1856: FND_MSG_PUB.ADD;
1857: CLOSE check_mc_status_csr;
1858: RAISE FND_API.G_EXC_ERROR;

Line 1855: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_mc_header_id);

1851: FETCH check_mc_status_csr INTO l_status_code, l_status;
1852: IF (check_mc_status_csr%NOTFOUND) THEN
1853: FND_MESSAGE.Set_Name('AHL','AHL_MC_HEADER_ID_INVALID');
1854: FND_MESSAGE.Set_Token('NAME','');
1855: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_mc_header_id);
1856: FND_MSG_PUB.ADD;
1857: CLOSE check_mc_status_csr;
1858: RAISE FND_API.G_EXC_ERROR;
1859: ELSIF ( l_status_code <> 'DRAFT' AND

Line 1861: FND_MESSAGE.Set_Name('AHL','AHL_MC_EDIT_INV_MC');

1857: CLOSE check_mc_status_csr;
1858: RAISE FND_API.G_EXC_ERROR;
1859: ELSIF ( l_status_code <> 'DRAFT' AND
1860: l_status_code <> 'APPROVAL_REJECTED') THEN
1861: FND_MESSAGE.Set_Name('AHL','AHL_MC_EDIT_INV_MC');
1862: FND_MESSAGE.Set_Token('STATUS', l_status);
1863: FND_MSG_PUB.ADD;
1864: CLOSE check_mc_status_csr;
1865: RAISE FND_API.G_EXC_ERROR;

Line 1862: FND_MESSAGE.Set_Token('STATUS', l_status);

1858: RAISE FND_API.G_EXC_ERROR;
1859: ELSIF ( l_status_code <> 'DRAFT' AND
1860: l_status_code <> 'APPROVAL_REJECTED') THEN
1861: FND_MESSAGE.Set_Name('AHL','AHL_MC_EDIT_INV_MC');
1862: FND_MESSAGE.Set_Token('STATUS', l_status);
1863: FND_MSG_PUB.ADD;
1864: CLOSE check_mc_status_csr;
1865: RAISE FND_API.G_EXC_ERROR;
1866: END IF;