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_RM_ASO_RESOURCE_PVT dependencies on FND_MSG_PUB

Line 25: FND_MSG_PUB.add;

21: p_aso_resource_rec.dml_operation <> 'U' AND
22: p_aso_resource_rec.dml_operation <> 'C' ) THEN
23: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
24: FND_MESSAGE.set_token( 'FIELD', p_aso_resource_rec.dml_operation );
25: FND_MSG_PUB.add;
26: RAISE FND_API.G_EXC_ERROR;
27: END IF;
28: IF p_bom_resource_tbl.count > 0 THEN
29: FOR i IN p_bom_resource_tbl.FIRST..p_bom_resource_tbl.LAST LOOP

Line 36: FND_MSG_PUB.add;

32: p_bom_resource_tbl(i).dml_operation <> 'C' ) THEN
33: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
34: FND_MESSAGE.set_token( 'FIELD', p_bom_resource_tbl(i).dml_operation );
35: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code ) ;
36: FND_MSG_PUB.add;
37: RAISE FND_API.G_EXC_ERROR;
38: END IF;
39: END LOOP;
40: END IF;

Line 47: FND_MSG_PUB.add;

43: IF p_bom_resource_tbl(i).dml_operation <> 'C' THEN
44: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
45: FND_MESSAGE.set_token( 'FIELD', p_bom_resource_tbl(i).dml_operation );
46: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code ) ;
47: FND_MSG_PUB.add;
48: RAISE FND_API.G_EXC_ERROR;
49: END IF;
50: END LOOP;
51: END IF;

Line 130: FND_MSG_PUB.add;

126: ELSE
127: FND_MESSAGE.set_token( 'FIELD', p_x_aso_resource_rec.resource_type );
128: END IF;
129:
130: FND_MSG_PUB.add;
131: l_total_return_status := FND_API.G_RET_STS_ERROR;
132: END IF;
133: END IF;
134: END IF;

Line 164: FND_MSG_PUB.add;

160: ELSE
161: FND_MESSAGE.set_token( 'FIELD', p_x_bom_resource_tbl(i).bom_resource_code );
162: FND_MESSAGE.set_token( 'RECORD', p_x_bom_resource_tbl(i).bom_resource_code );
163: END IF;
164: FND_MSG_PUB.add;
165: l_total_return_status := FND_API.G_RET_STS_ERROR;
166: END IF;
167: END IF;
168:

Line 180: FND_MSG_PUB.add;

176: IF (p_x_bom_resource_tbl(i).bom_resource_id IS NULL OR p_x_bom_resource_tbl(i).bom_resource_id = FND_API.G_MISS_NUM)
177: THEN
178: FND_MESSAGE.set_name( 'AHL','AHL_RM_BOM_RES_ID_NULL' );
179: FND_MESSAGE.set_token( 'RECORD',TO_CHAR(i));
180: FND_MSG_PUB.add;
181: l_total_return_status := FND_API.G_RET_STS_ERROR;
182: ELSE
183: AHL_RM_ROUTE_UTIL.validate_bom_res_dep
184: (

Line 201: FND_MSG_PUB.add;

197: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( p_x_bom_resource_tbl(i).department_id ) );
198: ELSE
199: FND_MESSAGE.set_token( 'RECORD', p_x_bom_resource_tbl(i).department_name );
200: END IF;
201: FND_MSG_PUB.add;
202: l_total_return_status := FND_API.G_RET_STS_ERROR;
203: END IF;
204: END IF;
205: END IF;

Line 270: FND_MSG_PUB.add;

266: IF ( (p_aso_resource_rec.resource_type_id IS NULL OR
267: p_aso_resource_rec.resource_type_id = FND_API.G_MISS_NUM) AND
268: p_aso_resource_rec.dml_operation <> 'U' ) THEN
269: FND_MESSAGE.set_name( 'AHL','AHL_RM_ASO_RES_TYPE_NULL' );
270: FND_MSG_PUB.add;
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:
274: -- Check if the mandatory name column contains a value.

Line 278: FND_MSG_PUB.add;

274: -- Check if the mandatory name column contains a value.
275: IF ( p_aso_resource_rec.name IS NULL OR
276: p_aso_resource_rec.name = FND_API.G_MISS_CHAR ) THEN
277: FND_MESSAGE.set_name( 'AHL','AHL_RM_ASO_RES_NAME_NULL' );
278: FND_MSG_PUB.add;
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281:
282: -- Check if the mandatory description column contains a value.

Line 286: FND_MSG_PUB.add;

282: -- Check if the mandatory description column contains a value.
283: IF ( p_aso_resource_rec.description IS NULL OR
284: p_aso_resource_rec.description = FND_API.G_MISS_CHAR ) THEN
285: FND_MESSAGE.set_name( 'AHL','AHL_RM_ASO_RES_DESC_NULL' );
286: FND_MSG_PUB.add;
287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
289:
290: --pekambar added for ER # 9014609 -- Start

Line 295: FND_MSG_PUB.add;

291: -- If p_x_aso_resource_rec.one_bomres_org is other than Y or N throw an error
292: IF ( p_aso_resource_rec.one_bomres_org IS NOT NULL AND ( p_aso_resource_rec.one_bomres_org <> 'Y' AND p_aso_resource_rec.one_bomres_org <> 'N') ) THEN
293: FND_MESSAGE.set_name( 'AHL','AHL_RM_ASO_RES_INVALID_VALUE' );
294: FND_MESSAGE.set_token( 'BOMRES',p_aso_resource_rec.one_bomres_org);
295: FND_MSG_PUB.add;
296: RAISE FND_API.G_EXC_ERROR;
297: END IF;
298: --pekambar added for ER # 9014609 -- End
299: END IF;

Line 310: FND_MSG_PUB.add;

306: IF (p_bom_resource_tbl(i).bom_resource_id IS NULL OR
307: p_bom_resource_tbl(i).bom_resource_id = FND_API.G_MISS_NUM) THEN
308: FND_MESSAGE.set_name( 'AHL','AHL_RM_BOM_RES_ID_NULL' );
309: FND_MESSAGE.set_token( 'RECORD',TO_CHAR(i));
310: FND_MSG_PUB.add;
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313: IF (p_bom_resource_tbl(i).bom_org_id IS NULL OR
314: p_bom_resource_tbl(i).bom_org_id = FND_API.G_MISS_NUM) THEN

Line 317: FND_MSG_PUB.add;

313: IF (p_bom_resource_tbl(i).bom_org_id IS NULL OR
314: p_bom_resource_tbl(i).bom_org_id = FND_API.G_MISS_NUM) THEN
315: FND_MESSAGE.set_name( 'AHL','AHL_RM_BOM_ORG_ID_NULL' );
316: FND_MESSAGE.set_token( 'RECORD',p_bom_resource_tbl(i).bom_resource_code);
317: FND_MSG_PUB.add;
318: RAISE FND_API.G_EXC_ERROR;
319: END IF;
320: END IF;
321: END LOOP;

Line 572: FND_MSG_PUB.add;

568: l_old_aso_resource_rec.attribute15;
569:
570: IF get_old_aso_rec%NOTFOUND THEN
571: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ASO_REC' );
572: FND_MSG_PUB.add;
573: CLOSE get_old_aso_rec;
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576:

Line 749: FND_MSG_PUB.add;

745:
746: IF get_old_bom_rec%NOTFOUND THEN
747: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_MAPPING_REC' );
748: FND_MESSAGE.set_token( 'RECORD', p_x_bom_resource_rec.bom_resource_code);
749: FND_MSG_PUB.add;
750: CLOSE get_old_bom_rec;
751: RAISE FND_API.G_EXC_ERROR;
752: END IF;
753:

Line 895: FND_MSG_PUB.add;

891: FETCH get_bom_rec INTO l_get_bom_rec;
892: IF get_bom_rec%NOTFOUND THEN
893: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_BOM_RES_REC' );
894: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code);
895: FND_MSG_PUB.add;
896: l_return_status := FND_API.G_RET_STS_ERROR;
897: ELSIF trunc(nvl(l_get_bom_rec.disable_date,sysdate)) 898: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_OUTDATED' );
899: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code);

Line 900: FND_MSG_PUB.add;

896: l_return_status := FND_API.G_RET_STS_ERROR;
897: ELSIF trunc(nvl(l_get_bom_rec.disable_date,sysdate)) 898: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_OUTDATED' );
899: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code);
900: FND_MSG_PUB.add;
901: l_return_status := FND_API.G_RET_STS_ERROR;
902: ELSIF (l_get_bom_rec.resource_type <> p_aso_resource_rec.resource_type_id
903: OR l_get_bom_rec.resource_type IS NULL) THEN
904: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_TYPE_NOT_MATCH' );

Line 906: FND_MSG_PUB.add;

902: ELSIF (l_get_bom_rec.resource_type <> p_aso_resource_rec.resource_type_id
903: OR l_get_bom_rec.resource_type IS NULL) THEN
904: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_TYPE_NOT_MATCH' );
905: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code);
906: FND_MSG_PUB.add;
907: l_return_status := FND_API.G_RET_STS_ERROR;
908: END IF;
909: CLOSE get_bom_rec;
910: END IF;

Line 943: FND_MSG_PUB.add;

939: FETCH get_dup_rec INTO l_name;
940: IF ( get_dup_rec%FOUND ) THEN
941: CLOSE get_dup_rec;
942: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASO_RESOURCE_DUP' );
943: FND_MSG_PUB.add;
944: RAISE FND_API.G_EXC_ERROR;
945: ELSE
946: CLOSE get_dup_rec;
947: END IF;

Line 963: FND_MSG_PUB.add;

959: BEGIN
960: IF (p_aso_resource_rec.dml_operation = 'C' AND
961: p_bom_resource_tbl.COUNT = 0) THEN
962: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_COUNT_ZERO' );
963: FND_MSG_PUB.add;
964: IF G_DEBUG = 'Y' THEN
965: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Inside validate_records procedure');
966: END IF;
967: RAISE FND_API.G_EXC_ERROR;

Line 1118: FND_MSG_PUB.add;

1114: FETCH get_bom_res_num INTO l_dummy_num;
1115: IF l_dummy_num < 1 THEN
1116: CLOSE get_bom_res_num;
1117: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_COUNT_ZERO' );
1118: FND_MSG_PUB.add;
1119: RAISE FND_API.G_EXC_ERROR;
1120: END IF;
1121: CLOSE get_bom_res_num;
1122:

Line 1132: FND_MSG_PUB.add;

1128: FETCH get_bom_res_org INTO l_dummy_num;
1129: IF get_bom_res_org%FOUND THEN
1130: CLOSE get_bom_res_org;
1131: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MUL_BOM_RES_PER_ORG' );
1132: FND_MSG_PUB.add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;
1135: CLOSE get_bom_res_org;
1136: */

Line 1149: FND_MSG_PUB.add;

1145: FETCH get_bom_res_org INTO l_dummy_num;
1146: IF get_bom_res_org%FOUND THEN
1147: CLOSE get_bom_res_org;
1148: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MUL_BOM_RES_PER_ORG' );
1149: FND_MSG_PUB.add;
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;
1152: CLOSE get_bom_res_org;
1153:

Line 1161: FND_MSG_PUB.add;

1157: FETCH get_bom_res_org_dept INTO l_dummy_num;
1158: IF get_bom_res_org_dept%FOUND THEN
1159: CLOSE get_bom_res_org_dept;
1160: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MUL_BOM_RES_PER_DPT_ORG' );
1161: FND_MSG_PUB.add;
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;
1164: CLOSE get_bom_res_org_dept;
1165: END IF;

Line 1174: FND_MSG_PUB.add;

1170: FETCH get_bom_res_dup INTO l_dummy_num;
1171: IF get_bom_res_dup%FOUND THEN
1172: CLOSE get_bom_res_dup;
1173: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RESOURCE_DUP' );
1174: FND_MSG_PUB.add;
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177: CLOSE get_bom_res_dup;
1178:

Line 1198: FND_MSG_PUB.add;

1194: FETCH get_dept_conflicts INTO l_dummy;
1195: IF ( get_dept_conflicts%FOUND ) THEN
1196: CLOSE get_dept_conflicts;
1197: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_UPD_RES_CONFLICT' );
1198: FND_MSG_PUB.add;
1199: RAISE FND_API.G_EXC_ERROR;
1200: END IF;
1201: CLOSE get_dept_conflicts;
1202:

Line 1214: FND_MSG_PUB.add;

1210: FETCH get_dept_conflicts_alt_res INTO l_dummy;
1211: IF ( get_dept_conflicts_alt_res%FOUND ) THEN
1212: CLOSE get_dept_conflicts_alt_res;
1213: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_UPD_RES_CONFLICT' );
1214: FND_MSG_PUB.add;
1215: RAISE FND_API.G_EXC_ERROR;
1216: END IF;
1217: CLOSE get_dept_conflicts_alt_res;
1218: END LOOP;

Line 1243: FND_MSG_PUB.add;

1239: FETCH get_dept_conflicts_alt_pri INTO l_dummy;
1240: IF ( get_dept_conflicts_alt_pri%FOUND ) THEN
1241: CLOSE get_dept_conflicts_alt_pri;
1242: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_UPD_RES_CONFLICT' );
1243: FND_MSG_PUB.add;
1244: RAISE FND_API.G_EXC_ERROR;
1245: END IF;
1246: CLOSE get_dept_conflicts_alt_pri;
1247:

Line 1303: FND_MSG_PUB.initialize;

1299: END IF;
1300:
1301: -- Initialize message list if p_init_msg_list is set to TRUE.
1302: IF FND_API.to_boolean( p_init_msg_list ) THEN
1303: FND_MSG_PUB.initialize;
1304: END IF;
1305:
1306: IF G_DEBUG = 'Y' THEN
1307: AHL_DEBUG_PUB.enable_debug;

Line 1594: FND_MSG_PUB.add;

1590:
1591: -- If the record does not exist, then, abort API.
1592: IF ( SQL%ROWCOUNT = 0 ) THEN
1593: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1594: FND_MSG_PUB.add;
1595: ELSE
1596: -- Update(Insert or Delete) the records in details table
1597: IF p_x_bom_resource_tbl.count > 0 THEN
1598: FOR i IN p_x_bom_resource_tbl.FIRST..p_x_bom_resource_tbl.LAST LOOP

Line 1687: FND_MSG_PUB.add;

1683: WHERE resource_mapping_id = p_x_bom_resource_tbl(i).resource_mapping_id
1684: AND object_version_number = p_x_bom_resource_tbl(i).object_version_number;
1685: IF ( SQL%ROWCOUNT = 0 ) THEN
1686: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1687: FND_MSG_PUB.add;
1688: ELSE
1689: p_x_bom_resource_tbl(i).object_version_number := p_x_bom_resource_tbl(i).object_version_number+1;
1690: END IF;
1691: ELSIF p_x_bom_resource_tbl(i).dml_operation = 'D' THEN

Line 1697: FND_MSG_PUB.add;

1693: WHERE resource_mapping_id = p_x_bom_resource_tbl(i).resource_mapping_id
1694: AND object_version_number = p_x_bom_resource_tbl(i).object_version_number;
1695: IF ( SQL%ROWCOUNT = 0 ) THEN
1696: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1697: FND_MSG_PUB.add;
1698: END IF;
1699: END IF;
1700: END LOOP;
1701: END IF;

Line 1715: FND_MSG_PUB.add;

1711: FETCH check_aso_resource_used INTO l_resource_id;
1712: IF check_aso_resource_used%FOUND THEN
1713: CLOSE check_aso_resource_used;
1714: FND_MESSAGE.set_name('AHL','AHL_RM_ASO_RES_BEING_USED');
1715: FND_MSG_PUB.add;
1716: ELSE
1717: CLOSE check_aso_resource_used;
1718: /*
1719: DELETE FROM AHL_RESOURCE_SKILLS

Line 1729: FND_MSG_PUB.add;

1725:
1726: -- If the record does not exist, then, abort API.
1727: IF ( SQL%ROWCOUNT = 0 ) THEN
1728: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1729: FND_MSG_PUB.add;
1730: -- Delete the detailed records in ahl_resource_skills
1731: ELSE
1732: DELETE FROM AHL_RESOURCE_MAPPINGS
1733: WHERE aso_resource_id = p_x_aso_resource_rec.resource_id;

Line 1755: l_msg_count := FND_MSG_PUB.count_msg;

1751: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : The last cross records validation was processed after DML operation' );
1752: END IF;
1753:
1754: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1755: l_msg_count := FND_MSG_PUB.count_msg;
1756: IF l_msg_count > 0 THEN
1757: x_msg_count := l_msg_count;
1758: RAISE FND_API.G_EXC_ERROR;
1759: END IF;

Line 1767: FND_MSG_PUB.count_and_get

1763: COMMIT WORK;
1764: END IF;
1765:
1766: -- Count and Get messages (optional)
1767: FND_MSG_PUB.count_and_get
1768: (
1769: p_encoded => FND_API.G_FALSE,
1770: p_count => x_msg_count,
1771: p_data => x_msg_data

Line 1782: FND_MSG_PUB.count_and_get

1778: EXCEPTION
1779: WHEN FND_API.G_EXC_ERROR THEN
1780: ROLLBACK TO PROCESS_ASO_RESOURCE_PVT;
1781: x_return_status := FND_API.G_RET_STS_ERROR ;
1782: FND_MSG_PUB.count_and_get
1783: (
1784: p_encoded => FND_API.G_FALSE,
1785: p_count => x_msg_count,
1786: p_data => x_msg_data

Line 1796: FND_MSG_PUB.count_and_get

1792:
1793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1794: ROLLBACK TO process_aso_resource_PVT;
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1796: FND_MSG_PUB.count_and_get
1797: (
1798: p_encoded => FND_API.G_FALSE,
1799: p_count => x_msg_count,
1800: p_data => x_msg_data

Line 1811: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1807:
1808: WHEN OTHERS THEN
1809: ROLLBACK TO process_aso_resource_PVT;
1810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1811: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1812: THEN
1813: FND_MSG_PUB.add_exc_msg
1814: (
1815: p_pkg_name => G_PKG_NAME,

Line 1813: FND_MSG_PUB.add_exc_msg

1809: ROLLBACK TO process_aso_resource_PVT;
1810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1811: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1812: THEN
1813: FND_MSG_PUB.add_exc_msg
1814: (
1815: p_pkg_name => G_PKG_NAME,
1816: p_procedure_name => G_API_NAME,
1817: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 1820: FND_MSG_PUB.count_and_get

1816: p_procedure_name => G_API_NAME,
1817: p_error_text => SUBSTRB(SQLERRM,1,240)
1818: );
1819: END IF;
1820: FND_MSG_PUB.count_and_get
1821: (
1822: p_encoded => FND_API.G_FALSE,
1823: p_count => x_msg_count,
1824: p_data => x_msg_data