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_MESSAGE

Line 23: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );

19: -- Validate DML Operation
20: IF ( p_aso_resource_rec.dml_operation <> 'D' AND
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;

Line 24: FND_MESSAGE.set_token( 'FIELD', p_aso_resource_rec.dml_operation );

20: IF ( p_aso_resource_rec.dml_operation <> 'D' AND
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

Line 33: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );

29: FOR i IN p_bom_resource_tbl.FIRST..p_bom_resource_tbl.LAST LOOP
30: IF ( p_bom_resource_tbl(i).dml_operation <> 'D' AND
31: p_bom_resource_tbl(i).dml_operation <> 'U' AND
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;

Line 34: FND_MESSAGE.set_token( 'FIELD', p_bom_resource_tbl(i).dml_operation );

30: IF ( p_bom_resource_tbl(i).dml_operation <> 'D' AND
31: p_bom_resource_tbl(i).dml_operation <> 'U' AND
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;

Line 35: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code ) ;

31: p_bom_resource_tbl(i).dml_operation <> 'U' AND
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;

Line 44: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );

40: END IF;
41: IF ( p_aso_resource_rec.dml_operation = 'C' and p_bom_resource_tbl.count >0 ) THEN
42: FOR i IN p_bom_resource_tbl.FIRST..p_bom_resource_tbl.LAST LOOP
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;

Line 45: FND_MESSAGE.set_token( 'FIELD', p_bom_resource_tbl(i).dml_operation );

41: IF ( p_aso_resource_rec.dml_operation = 'C' and p_bom_resource_tbl.count >0 ) THEN
42: FOR i IN p_bom_resource_tbl.FIRST..p_bom_resource_tbl.LAST LOOP
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;

Line 46: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code ) ;

42: FOR i IN p_bom_resource_tbl.FIRST..p_bom_resource_tbl.LAST LOOP
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;

Line 116: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES_TYPE' );

112: );
113:
114: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
115: IF ( l_msg_data = 'AHL_COM_INVALID_MFG_LOOKUP' ) THEN
116: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES_TYPE' );
117: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
118: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_RES_TYPES' );
119: ELSE
120: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 118: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_RES_TYPES' );

114: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
115: IF ( l_msg_data = 'AHL_COM_INVALID_MFG_LOOKUP' ) THEN
116: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES_TYPE' );
117: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
118: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_RES_TYPES' );
119: ELSE
120: FND_MESSAGE.set_name( 'AHL', l_msg_data );
121: END IF;
122:

Line 120: FND_MESSAGE.set_name( 'AHL', l_msg_data );

116: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES_TYPE' );
117: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
118: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_RES_TYPES' );
119: ELSE
120: FND_MESSAGE.set_name( 'AHL', l_msg_data );
121: END IF;
122:
123: IF ( p_x_aso_resource_rec.resource_type IS NULL OR
124: p_x_aso_resource_rec.resource_type = FND_API.G_MISS_CHAR ) THEN

Line 125: FND_MESSAGE.set_token( 'FIELD', p_x_aso_resource_rec.resource_type_id );

121: END IF;
122:
123: IF ( p_x_aso_resource_rec.resource_type IS NULL OR
124: p_x_aso_resource_rec.resource_type = FND_API.G_MISS_CHAR ) THEN
125: FND_MESSAGE.set_token( 'FIELD', p_x_aso_resource_rec.resource_type_id );
126: ELSE
127: FND_MESSAGE.set_token( 'FIELD', p_x_aso_resource_rec.resource_type );
128: END IF;
129:

Line 127: FND_MESSAGE.set_token( 'FIELD', p_x_aso_resource_rec.resource_type );

123: IF ( p_x_aso_resource_rec.resource_type IS NULL OR
124: p_x_aso_resource_rec.resource_type = FND_API.G_MISS_CHAR ) THEN
125: FND_MESSAGE.set_token( 'FIELD', p_x_aso_resource_rec.resource_type_id );
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;

Line 155: FND_MESSAGE.set_name( 'AHL', l_msg_data );

151: p_x_bom_org_id => p_x_bom_resource_tbl(i).bom_org_id
152: );
153:
154: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
155: FND_MESSAGE.set_name( 'AHL', l_msg_data );
156: IF ( p_x_bom_resource_tbl(i).bom_resource_code IS NULL OR
157: p_x_bom_resource_tbl(i).bom_resource_code = FND_API.G_MISS_CHAR ) THEN
158: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_bom_resource_tbl(i).bom_resource_id ) );
159: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( p_x_bom_resource_tbl(i).bom_resource_id ) );

Line 158: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_bom_resource_tbl(i).bom_resource_id ) );

154: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
155: FND_MESSAGE.set_name( 'AHL', l_msg_data );
156: IF ( p_x_bom_resource_tbl(i).bom_resource_code IS NULL OR
157: p_x_bom_resource_tbl(i).bom_resource_code = FND_API.G_MISS_CHAR ) THEN
158: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_bom_resource_tbl(i).bom_resource_id ) );
159: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( p_x_bom_resource_tbl(i).bom_resource_id ) );
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 );

Line 159: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( p_x_bom_resource_tbl(i).bom_resource_id ) );

155: FND_MESSAGE.set_name( 'AHL', l_msg_data );
156: IF ( p_x_bom_resource_tbl(i).bom_resource_code IS NULL OR
157: p_x_bom_resource_tbl(i).bom_resource_code = FND_API.G_MISS_CHAR ) THEN
158: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_bom_resource_tbl(i).bom_resource_id ) );
159: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( p_x_bom_resource_tbl(i).bom_resource_id ) );
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;

Line 161: FND_MESSAGE.set_token( 'FIELD', p_x_bom_resource_tbl(i).bom_resource_code );

157: p_x_bom_resource_tbl(i).bom_resource_code = FND_API.G_MISS_CHAR ) THEN
158: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_bom_resource_tbl(i).bom_resource_id ) );
159: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( p_x_bom_resource_tbl(i).bom_resource_id ) );
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;

Line 162: FND_MESSAGE.set_token( 'RECORD', p_x_bom_resource_tbl(i).bom_resource_code );

158: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_bom_resource_tbl(i).bom_resource_id ) );
159: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( p_x_bom_resource_tbl(i).bom_resource_id ) );
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;

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

174: p_x_bom_resource_tbl(i).department_id <> FND_API.G_MISS_NUM ) ) THEN
175:
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

Line 179: FND_MESSAGE.set_token( 'RECORD',TO_CHAR(i));

175:
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

Line 194: FND_MESSAGE.set_name( 'AHL', l_msg_data );

190: p_x_bom_department_id => p_x_bom_resource_tbl(i).department_id
191: );
192:
193: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
194: FND_MESSAGE.set_name( 'AHL', l_msg_data );
195: IF ( p_x_bom_resource_tbl(i).department_name IS NULL OR
196: p_x_bom_resource_tbl(i).department_name = FND_API.G_MISS_CHAR ) THEN
197: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( p_x_bom_resource_tbl(i).department_id ) );
198: ELSE

Line 197: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( p_x_bom_resource_tbl(i).department_id ) );

193: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
194: FND_MESSAGE.set_name( 'AHL', l_msg_data );
195: IF ( p_x_bom_resource_tbl(i).department_name IS NULL OR
196: p_x_bom_resource_tbl(i).department_name = FND_API.G_MISS_CHAR ) THEN
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;

Line 199: FND_MESSAGE.set_token( 'RECORD', p_x_bom_resource_tbl(i).department_name );

195: IF ( p_x_bom_resource_tbl(i).department_name IS NULL OR
196: p_x_bom_resource_tbl(i).department_name = FND_API.G_MISS_CHAR ) THEN
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;

Line 269: FND_MESSAGE.set_name( 'AHL','AHL_RM_ASO_RES_TYPE_NULL' );

265: -- Check if the mandatory resource_type column contains a value.
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:

Line 277: FND_MESSAGE.set_name( 'AHL','AHL_RM_ASO_RES_NAME_NULL' );

273:
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:

Line 285: FND_MESSAGE.set_name( 'AHL','AHL_RM_ASO_RES_DESC_NULL' );

281:
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;

Line 299: FND_MESSAGE.set_name( 'AHL','AHL_RM_BOM_RES_ID_NULL' );

295: p_bom_resource_tbl(i).dml_operation = 'U' ) THEN
296:
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;

Line 300: FND_MESSAGE.set_token( 'RECORD',TO_CHAR(i));

296:
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

Line 306: FND_MESSAGE.set_name( 'AHL','AHL_RM_BOM_ORG_ID_NULL' );

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
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;

Line 307: FND_MESSAGE.set_token( 'RECORD',p_bom_resource_tbl(i).bom_resource_code);

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
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;

Line 556: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ASO_REC' );

552: l_old_aso_resource_rec.attribute14,
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;

Line 732: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_MAPPING_REC' );

728: l_old_bom_resource_rec.attribute14,
729: l_old_bom_resource_rec.attribute15;
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;

Line 733: FND_MESSAGE.set_token( 'RECORD', p_x_bom_resource_rec.bom_resource_code);

729: l_old_bom_resource_rec.attribute15;
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;

Line 878: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_BOM_RES_REC' );

874: IF p_bom_resource_tbl(i).dml_operation <> 'D' THEN
875: OPEN get_bom_rec(p_bom_resource_tbl(i).bom_resource_id);
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))

Line 879: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code);

875: OPEN get_bom_rec(p_bom_resource_tbl(i).bom_resource_id);
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' );

Line 883: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_OUTDATED' );

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);
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

Line 884: 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);
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

Line 889: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_TYPE_NOT_MATCH' );

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' );
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;

Line 890: FND_MESSAGE.set_token( 'RECORD', p_bom_resource_tbl(i).bom_resource_code);

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' );
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;

Line 927: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASO_RESOURCE_DUP' );

923: OPEN get_dup_rec( p_aso_resource_rec.resource_id, p_aso_resource_rec.NAME);
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;

Line 947: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_COUNT_ZERO' );

943:
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;

Line 1079: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RES_COUNT_ZERO' );

1075: OPEN get_bom_res_num (p_aso_resource_id);
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;

Line 1089: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MUL_BOM_RES_PER_ORG' );

1085: OPEN get_bom_res_org (p_aso_resource_id);
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;

Line 1099: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_BOM_RESOURCE_DUP' );

1095: OPEN get_bom_res_dup (p_aso_resource_id);
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;

Line 1120: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_UPD_RES_CONFLICT' );

1116: OPEN get_dept_conflicts( l_object_id, l_association_type_code );
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;

Line 1136: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_UPD_RES_CONFLICT' );

1132: OPEN get_dept_conflicts_alt_res( l_object_id, l_association_type_code, l_rt_oper_res_id);
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;

Line 1165: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_UPD_RES_CONFLICT' );

1161: OPEN get_dept_conflicts_alt_pri( l_object_id, l_association_type_code, l_aso_res_id, p_aso_resource_id);
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;

Line 1510: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');

1506: AND object_version_number = p_x_aso_resource_rec.object_version_number;
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

Line 1603: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');

1599: attribute15 = p_x_bom_resource_tbl(i).attribute15
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;

Line 1613: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');

1609: DELETE FROM AHL_RESOURCE_MAPPINGS
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;

Line 1631: FND_MESSAGE.set_name('AHL','AHL_RM_ASO_RES_BEING_USED');

1627: OPEN check_aso_resource_used(p_x_aso_resource_rec.resource_id);
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: /*

Line 1645: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');

1641: AND object_version_number = p_x_aso_resource_rec.object_version_number;
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