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: END IF;
290:

Line 301: FND_MSG_PUB.add;

297: IF (p_bom_resource_tbl(i).bom_resource_id IS NULL OR
298: p_bom_resource_tbl(i).bom_resource_id = FND_API.G_MISS_NUM) THEN
299: FND_MESSAGE.set_name( 'AHL','AHL_RM_BOM_RES_ID_NULL' );
300: FND_MESSAGE.set_token( 'RECORD',TO_CHAR(i));
301: FND_MSG_PUB.add;
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304: IF (p_bom_resource_tbl(i).bom_org_id IS NULL OR
305: p_bom_resource_tbl(i).bom_org_id = FND_API.G_MISS_NUM) THEN

Line 308: FND_MSG_PUB.add;

304: IF (p_bom_resource_tbl(i).bom_org_id IS NULL OR
305: p_bom_resource_tbl(i).bom_org_id = FND_API.G_MISS_NUM) THEN
306: FND_MESSAGE.set_name( 'AHL','AHL_RM_BOM_ORG_ID_NULL' );
307: FND_MESSAGE.set_token( 'RECORD',p_bom_resource_tbl(i).bom_resource_code);
308: FND_MSG_PUB.add;
309: RAISE FND_API.G_EXC_ERROR;
310: END IF;
311: END IF;
312: END LOOP;

Line 557: FND_MSG_PUB.add;

553: l_old_aso_resource_rec.attribute15;
554:
555: IF get_old_aso_rec%NOTFOUND THEN
556: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ASO_REC' );
557: FND_MSG_PUB.add;
558: CLOSE get_old_aso_rec;
559: RAISE FND_API.G_EXC_ERROR;
560: END IF;
561:

Line 734: FND_MSG_PUB.add;

730:
731: IF get_old_bom_rec%NOTFOUND THEN
732: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_MAPPING_REC' );
733: FND_MESSAGE.set_token( 'RECORD', p_x_bom_resource_rec.bom_resource_code);
734: FND_MSG_PUB.add;
735: CLOSE get_old_bom_rec;
736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
738:

Line 880: FND_MSG_PUB.add;

876: FETCH get_bom_rec INTO l_get_bom_rec;
877: IF get_bom_rec%NOTFOUND THEN
878: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_BOM_RES_REC' );
879: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code);
880: FND_MSG_PUB.add;
881: l_return_status := FND_API.G_RET_STS_ERROR;
882: ELSIF trunc(nvl(l_get_bom_rec.disable_date,sysdate)) 883: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_OUTDATED' );
884: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code);

Line 885: FND_MSG_PUB.add;

881: l_return_status := FND_API.G_RET_STS_ERROR;
882: ELSIF trunc(nvl(l_get_bom_rec.disable_date,sysdate)) 883: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_OUTDATED' );
884: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code);
885: FND_MSG_PUB.add;
886: l_return_status := FND_API.G_RET_STS_ERROR;
887: ELSIF (l_get_bom_rec.resource_type <> p_aso_resource_rec.resource_type_id
888: OR l_get_bom_rec.resource_type IS NULL) THEN
889: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_TYPE_NOT_MATCH' );

Line 891: FND_MSG_PUB.add;

887: ELSIF (l_get_bom_rec.resource_type <> p_aso_resource_rec.resource_type_id
888: OR l_get_bom_rec.resource_type IS NULL) THEN
889: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_TYPE_NOT_MATCH' );
890: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code);
891: FND_MSG_PUB.add;
892: l_return_status := FND_API.G_RET_STS_ERROR;
893: END IF;
894: CLOSE get_bom_rec;
895: END IF;

Line 928: FND_MSG_PUB.add;

924: FETCH get_dup_rec INTO l_name;
925: IF ( get_dup_rec%FOUND ) THEN
926: CLOSE get_dup_rec;
927: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASO_RESOURCE_DUP' );
928: FND_MSG_PUB.add;
929: RAISE FND_API.G_EXC_ERROR;
930: ELSE
931: CLOSE get_dup_rec;
932: END IF;

Line 948: FND_MSG_PUB.add;

944: BEGIN
945: IF (p_aso_resource_rec.dml_operation = 'C' AND
946: p_bom_resource_tbl.COUNT = 0) THEN
947: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_COUNT_ZERO' );
948: FND_MSG_PUB.add;
949: IF G_DEBUG = 'Y' THEN
950: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Inside validate_records procedure');
951: END IF;
952: RAISE FND_API.G_EXC_ERROR;

Line 1080: FND_MSG_PUB.add;

1076: FETCH get_bom_res_num INTO l_dummy_num;
1077: IF l_dummy_num < 1 THEN
1078: CLOSE get_bom_res_num;
1079: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_COUNT_ZERO' );
1080: FND_MSG_PUB.add;
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;
1083: CLOSE get_bom_res_num;
1084:

Line 1090: FND_MSG_PUB.add;

1086: FETCH get_bom_res_org INTO l_dummy_num;
1087: IF get_bom_res_org%FOUND THEN
1088: CLOSE get_bom_res_org;
1089: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MUL_BOM_RES_PER_ORG' );
1090: FND_MSG_PUB.add;
1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;
1093: CLOSE get_bom_res_org;
1094:

Line 1100: FND_MSG_PUB.add;

1096: FETCH get_bom_res_dup INTO l_dummy_num;
1097: IF get_bom_res_dup%FOUND THEN
1098: CLOSE get_bom_res_dup;
1099: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RESOURCE_DUP' );
1100: FND_MSG_PUB.add;
1101: RAISE FND_API.G_EXC_ERROR;
1102: END IF;
1103: CLOSE get_bom_res_dup;
1104:

Line 1121: FND_MSG_PUB.add;

1117: FETCH get_dept_conflicts INTO l_dummy;
1118: IF ( get_dept_conflicts%FOUND ) THEN
1119: CLOSE get_dept_conflicts;
1120: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_UPD_RES_CONFLICT' );
1121: FND_MSG_PUB.add;
1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: CLOSE get_dept_conflicts;
1125:

Line 1137: FND_MSG_PUB.add;

1133: FETCH get_dept_conflicts_alt_res INTO l_dummy;
1134: IF ( get_dept_conflicts_alt_res%FOUND ) THEN
1135: CLOSE get_dept_conflicts_alt_res;
1136: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_UPD_RES_CONFLICT' );
1137: FND_MSG_PUB.add;
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140: CLOSE get_dept_conflicts_alt_res;
1141: END LOOP;

Line 1166: FND_MSG_PUB.add;

1162: FETCH get_dept_conflicts_alt_pri INTO l_dummy;
1163: IF ( get_dept_conflicts_alt_pri%FOUND ) THEN
1164: CLOSE get_dept_conflicts_alt_pri;
1165: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_UPD_RES_CONFLICT' );
1166: FND_MSG_PUB.add;
1167: RAISE FND_API.G_EXC_ERROR;
1168: END IF;
1169: CLOSE get_dept_conflicts_alt_pri;
1170:

Line 1224: FND_MSG_PUB.initialize;

1220: END IF;
1221:
1222: -- Initialize message list if p_init_msg_list is set to TRUE.
1223: IF FND_API.to_boolean( p_init_msg_list ) THEN
1224: FND_MSG_PUB.initialize;
1225: END IF;
1226:
1227: IF G_DEBUG = 'Y' THEN
1228: AHL_DEBUG_PUB.enable_debug;

Line 1511: FND_MSG_PUB.add;

1507:
1508: -- If the record does not exist, then, abort API.
1509: IF ( SQL%ROWCOUNT = 0 ) THEN
1510: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1511: FND_MSG_PUB.add;
1512: ELSE
1513: -- Update(Insert or Delete) the records in details table
1514: IF p_x_bom_resource_tbl.count > 0 THEN
1515: FOR i IN p_x_bom_resource_tbl.FIRST..p_x_bom_resource_tbl.LAST LOOP

Line 1604: FND_MSG_PUB.add;

1600: WHERE resource_mapping_id = p_x_bom_resource_tbl(i).resource_mapping_id
1601: AND object_version_number = p_x_bom_resource_tbl(i).object_version_number;
1602: IF ( SQL%ROWCOUNT = 0 ) THEN
1603: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1604: FND_MSG_PUB.add;
1605: ELSE
1606: p_x_bom_resource_tbl(i).object_version_number := p_x_bom_resource_tbl(i).object_version_number+1;
1607: END IF;
1608: ELSIF p_x_bom_resource_tbl(i).dml_operation = 'D' THEN

Line 1614: FND_MSG_PUB.add;

1610: WHERE resource_mapping_id = p_x_bom_resource_tbl(i).resource_mapping_id
1611: AND object_version_number = p_x_bom_resource_tbl(i).object_version_number;
1612: IF ( SQL%ROWCOUNT = 0 ) THEN
1613: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1614: FND_MSG_PUB.add;
1615: END IF;
1616: END IF;
1617: END LOOP;
1618: END IF;

Line 1632: FND_MSG_PUB.add;

1628: FETCH check_aso_resource_used INTO l_resource_id;
1629: IF check_aso_resource_used%FOUND THEN
1630: CLOSE check_aso_resource_used;
1631: FND_MESSAGE.set_name('AHL','AHL_RM_ASO_RES_BEING_USED');
1632: FND_MSG_PUB.add;
1633: ELSE
1634: CLOSE check_aso_resource_used;
1635: /*
1636: DELETE FROM AHL_RESOURCE_SKILLS

Line 1646: FND_MSG_PUB.add;

1642:
1643: -- If the record does not exist, then, abort API.
1644: IF ( SQL%ROWCOUNT = 0 ) THEN
1645: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1646: FND_MSG_PUB.add;
1647: -- Delete the detailed records in ahl_resource_skills
1648: ELSE
1649: DELETE FROM AHL_RESOURCE_MAPPINGS
1650: WHERE aso_resource_id = p_x_aso_resource_rec.resource_id;

Line 1672: l_msg_count := FND_MSG_PUB.count_msg;

1668: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : The last cross records validation was processed after DML operation' );
1669: END IF;
1670:
1671: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1672: l_msg_count := FND_MSG_PUB.count_msg;
1673: IF l_msg_count > 0 THEN
1674: x_msg_count := l_msg_count;
1675: RAISE FND_API.G_EXC_ERROR;
1676: END IF;

Line 1684: FND_MSG_PUB.count_and_get

1680: COMMIT WORK;
1681: END IF;
1682:
1683: -- Count and Get messages (optional)
1684: FND_MSG_PUB.count_and_get
1685: (
1686: p_encoded => FND_API.G_FALSE,
1687: p_count => x_msg_count,
1688: p_data => x_msg_data

Line 1699: FND_MSG_PUB.count_and_get

1695: EXCEPTION
1696: WHEN FND_API.G_EXC_ERROR THEN
1697: ROLLBACK TO PROCESS_ASO_RESOURCE_PVT;
1698: x_return_status := FND_API.G_RET_STS_ERROR ;
1699: FND_MSG_PUB.count_and_get
1700: (
1701: p_encoded => FND_API.G_FALSE,
1702: p_count => x_msg_count,
1703: p_data => x_msg_data

Line 1713: FND_MSG_PUB.count_and_get

1709:
1710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1711: ROLLBACK TO process_aso_resource_PVT;
1712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1713: FND_MSG_PUB.count_and_get
1714: (
1715: p_encoded => FND_API.G_FALSE,
1716: p_count => x_msg_count,
1717: p_data => x_msg_data

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

1724:
1725: WHEN OTHERS THEN
1726: ROLLBACK TO process_aso_resource_PVT;
1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1728: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1729: THEN
1730: FND_MSG_PUB.add_exc_msg
1731: (
1732: p_pkg_name => G_PKG_NAME,

Line 1730: FND_MSG_PUB.add_exc_msg

1726: ROLLBACK TO process_aso_resource_PVT;
1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1728: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1729: THEN
1730: FND_MSG_PUB.add_exc_msg
1731: (
1732: p_pkg_name => G_PKG_NAME,
1733: p_procedure_name => G_API_NAME,
1734: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 1737: FND_MSG_PUB.count_and_get

1733: p_procedure_name => G_API_NAME,
1734: p_error_text => SUBSTRB(SQLERRM,1,240)
1735: );
1736: END IF;
1737: FND_MSG_PUB.count_and_get
1738: (
1739: p_encoded => FND_API.G_FALSE,
1740: p_count => x_msg_count,
1741: p_data => x_msg_data