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:

Line 293: FND_MESSAGE.set_name( 'AHL','AHL_RM_ASO_RES_INVALID_VALUE' );

289:
290: --pekambar added for ER # 9014609 -- Start
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;

Line 294: FND_MESSAGE.set_token( 'BOMRES',p_aso_resource_rec.one_bomres_org);

290: --pekambar added for ER # 9014609 -- Start
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

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

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

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

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

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

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

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

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

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

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

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

743: l_old_bom_resource_rec.attribute14,
744: l_old_bom_resource_rec.attribute15;
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1127: /*OPEN get_bom_res_org (p_aso_resource_id);
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;

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

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

Line 1160: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MUL_BOM_RES_PER_DPT_ORG' );

1156: OPEN get_bom_res_org_dept (p_aso_resource_id);
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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