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

Line 64: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_NULL' );

60:
61: -- Check if a valid value is passed in p_association_type_code
62: IF ( p_association_type_code = FND_API.G_MISS_CHAR OR
63: p_association_type_code IS NULL ) THEN
64: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_NULL' );
65: FND_MSG_PUB.add;
66: x_return_status := FND_API.G_RET_STS_ERROR;
67: RETURN;
68: ELSIF ( p_association_type_code <> 'OPERATION' AND

Line 70: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_INVALID' );

66: x_return_status := FND_API.G_RET_STS_ERROR;
67: RETURN;
68: ELSIF ( p_association_type_code <> 'OPERATION' AND
69: p_association_type_code <> 'ROUTE' ) THEN
70: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_INVALID' );
71: FND_MESSAGE.set_token( 'FIELD', p_association_type_code );
72: FND_MSG_PUB.add;
73: x_return_status := FND_API.G_RET_STS_ERROR;
74: RETURN;

Line 71: FND_MESSAGE.set_token( 'FIELD', p_association_type_code );

67: RETURN;
68: ELSIF ( p_association_type_code <> 'OPERATION' AND
69: p_association_type_code <> 'ROUTE' ) THEN
70: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_INVALID' );
71: FND_MESSAGE.set_token( 'FIELD', p_association_type_code );
72: FND_MSG_PUB.add;
73: x_return_status := FND_API.G_RET_STS_ERROR;
74: RETURN;
75: END IF;

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

82: x_return_status => l_return_status,
83: x_msg_data => l_msg_data
84: );
85: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
86: FND_MESSAGE.set_name( 'AHL', l_msg_data );
87: FND_MSG_PUB.add;
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: RETURN;
90: END IF;

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

95: x_return_status => l_return_status,
96: x_msg_data => l_msg_data
97: );
98: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
99: FND_MESSAGE.set_name( 'AHL', l_msg_data );
100: FND_MSG_PUB.add;
101: x_return_status := FND_API.G_RET_STS_ERROR;
102: RETURN;
103: END IF;

Line 108: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );

104: END IF;
105:
106: -- Check if at least one record is passed in p_rt_oper_resource_tbl
107: IF ( p_rt_oper_resource_tbl.count < 1 ) THEN
108: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
109: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME1 );
110: FND_MSG_PUB.add;
111: x_return_status := FND_API.G_RET_STS_ERROR;
112: RETURN;

Line 109: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME1 );

105:
106: -- Check if at least one record is passed in p_rt_oper_resource_tbl
107: IF ( p_rt_oper_resource_tbl.count < 1 ) THEN
108: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
109: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME1 );
110: FND_MSG_PUB.add;
111: x_return_status := FND_API.G_RET_STS_ERROR;
112: RETURN;
113: END IF;

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

121: p_rt_oper_resource_tbl(i).dml_operation <> 'D'
122: )
123: )
124: THEN
125: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
126: FND_MESSAGE.set_token( 'FIELD', p_rt_oper_resource_tbl(i).dml_operation );
127: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_tbl(i) ) );
128: FND_MSG_PUB.add;
129: x_return_status := FND_API.G_RET_STS_ERROR;

Line 126: FND_MESSAGE.set_token( 'FIELD', p_rt_oper_resource_tbl(i).dml_operation );

122: )
123: )
124: THEN
125: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
126: FND_MESSAGE.set_token( 'FIELD', p_rt_oper_resource_tbl(i).dml_operation );
127: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_tbl(i) ) );
128: FND_MSG_PUB.add;
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: RETURN;

Line 127: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_tbl(i) ) );

123: )
124: THEN
125: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
126: FND_MESSAGE.set_token( 'FIELD', p_rt_oper_resource_tbl(i).dml_operation );
127: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_tbl(i) ) );
128: FND_MSG_PUB.add;
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: RETURN;
131: END IF;

Line 189: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RESOURCE_TYPE' );

185: );
186:
187: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
188: IF ( l_msg_data = 'AHL_COM_INVALID_MFG_LOOKUP' ) THEN
189: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RESOURCE_TYPE' );
190: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_MFG_LOOKUPS' ) THEN
191: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_RESOURCE_TYPES' );
192: ELSE
193: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 191: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_RESOURCE_TYPES' );

187: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
188: IF ( l_msg_data = 'AHL_COM_INVALID_MFG_LOOKUP' ) THEN
189: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RESOURCE_TYPE' );
190: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_MFG_LOOKUPS' ) THEN
191: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_RESOURCE_TYPES' );
192: ELSE
193: FND_MESSAGE.set_name( 'AHL', l_msg_data );
194: END IF;
195:

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

189: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RESOURCE_TYPE' );
190: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_MFG_LOOKUPS' ) THEN
191: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_RESOURCE_TYPES' );
192: ELSE
193: FND_MESSAGE.set_name( 'AHL', l_msg_data );
194: END IF;
195:
196: IF ( p_x_rt_oper_resource_rec.resource_type IS NULL OR
197: p_x_rt_oper_resource_rec.resource_type = FND_API.G_MISS_CHAR ) THEN

Line 198: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_resource_rec.resource_type_id ) );

194: END IF;
195:
196: IF ( p_x_rt_oper_resource_rec.resource_type IS NULL OR
197: p_x_rt_oper_resource_rec.resource_type = FND_API.G_MISS_CHAR ) THEN
198: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_resource_rec.resource_type_id ) );
199: ELSE
200: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_resource_rec.resource_type );
201: END IF;
202:

Line 200: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_resource_rec.resource_type );

196: IF ( p_x_rt_oper_resource_rec.resource_type IS NULL OR
197: p_x_rt_oper_resource_rec.resource_type = FND_API.G_MISS_CHAR ) THEN
198: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_resource_rec.resource_type_id ) );
199: ELSE
200: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_resource_rec.resource_type );
201: END IF;
202:
203: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_rec ) );
204: FND_MSG_PUB.add;

Line 203: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_rec ) );

199: ELSE
200: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_resource_rec.resource_type );
201: END IF;
202:
203: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_rec ) );
204: FND_MSG_PUB.add;
205: END IF;
206:
207: END IF;

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

221: p_x_aso_resource_id => p_x_rt_oper_resource_rec.aso_resource_id
222: );
223:
224: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
225: FND_MESSAGE.set_name( 'AHL', l_msg_data );
226:
227: IF ( p_x_rt_oper_resource_rec.aso_resource_name IS NULL OR
228: p_x_rt_oper_resource_rec.aso_resource_name = FND_API.G_MISS_CHAR ) THEN
229: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_resource_rec.aso_resource_id ) );

Line 229: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_resource_rec.aso_resource_id ) );

225: FND_MESSAGE.set_name( 'AHL', l_msg_data );
226:
227: IF ( p_x_rt_oper_resource_rec.aso_resource_name IS NULL OR
228: p_x_rt_oper_resource_rec.aso_resource_name = FND_API.G_MISS_CHAR ) THEN
229: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_resource_rec.aso_resource_id ) );
230: ELSE
231: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_resource_rec.aso_resource_name );
232: END IF;
233:

Line 231: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_resource_rec.aso_resource_name );

227: IF ( p_x_rt_oper_resource_rec.aso_resource_name IS NULL OR
228: p_x_rt_oper_resource_rec.aso_resource_name = FND_API.G_MISS_CHAR ) THEN
229: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_resource_rec.aso_resource_id ) );
230: ELSE
231: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_resource_rec.aso_resource_name );
232: END IF;
233:
234: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_rec ) );
235: FND_MSG_PUB.add;

Line 234: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_rec ) );

230: ELSE
231: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_resource_rec.aso_resource_name );
232: END IF;
233:
234: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_rec ) );
235: FND_MSG_PUB.add;
236: END IF;
237:
238: END IF;

Line 259: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SCHEDULE_TYPE' );

255: );
256:
257: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
258: IF ( l_msg_data = 'AHL_RM_INVALID_MFG_LOOKUP' ) THEN
259: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SCHEDULE_TYPE' );
260: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
261: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SCHEDULE_TYPES' );
262: ELSE
263: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 261: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SCHEDULE_TYPES' );

257: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
258: IF ( l_msg_data = 'AHL_RM_INVALID_MFG_LOOKUP' ) THEN
259: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SCHEDULE_TYPE' );
260: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
261: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SCHEDULE_TYPES' );
262: ELSE
263: FND_MESSAGE.set_name( 'AHL', l_msg_data );
264: END IF;
265:

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

259: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SCHEDULE_TYPE' );
260: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
261: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SCHEDULE_TYPES' );
262: ELSE
263: FND_MESSAGE.set_name( 'AHL', l_msg_data );
264: END IF;
265:
266: IF ( p_x_rt_oper_resource_rec.scheduled_type IS NULL OR
267: p_x_rt_oper_resource_rec.scheduled_type = FND_API.G_MISS_CHAR ) THEN

Line 268: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_resource_rec.scheduled_type_id ) );

264: END IF;
265:
266: IF ( p_x_rt_oper_resource_rec.scheduled_type IS NULL OR
267: p_x_rt_oper_resource_rec.scheduled_type = FND_API.G_MISS_CHAR ) THEN
268: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_resource_rec.scheduled_type_id ) );
269: ELSE
270: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_resource_rec.scheduled_type);
271: END IF;
272:

Line 270: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_resource_rec.scheduled_type);

266: IF ( p_x_rt_oper_resource_rec.scheduled_type IS NULL OR
267: p_x_rt_oper_resource_rec.scheduled_type = FND_API.G_MISS_CHAR ) THEN
268: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_resource_rec.scheduled_type_id ) );
269: ELSE
270: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_resource_rec.scheduled_type);
271: END IF;
272:
273: FND_MSG_PUB.add;
274: END IF;

Line 496: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES_REC' );

492: l_old_rt_oper_resource_rec.schedule_seq ;
493: -- Bug # 7644260 (FP for ER # 6998882) -- end
494:
495: IF get_old_rec%NOTFOUND THEN
496: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES_REC' );
497: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_rec ) );
498: FND_MSG_PUB.add;
499: CLOSE get_old_rec;
500: RAISE FND_API.G_EXC_ERROR;

Line 497: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_rec ) );

493: -- Bug # 7644260 (FP for ER # 6998882) -- end
494:
495: IF get_old_rec%NOTFOUND THEN
496: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES_REC' );
497: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_rec ) );
498: FND_MSG_PUB.add;
499: CLOSE get_old_rec;
500: RAISE FND_API.G_EXC_ERROR;
501: END IF;

Line 712: FND_MESSAGE.set_name( 'AHL','AHL_RM_ASO_RES_NULL' );

708: IF ( ( p_rt_oper_resource_rec.dml_operation = 'C' AND
709: p_rt_oper_resource_rec.aso_resource_id IS NULL ) OR
710: ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
711: p_rt_oper_resource_rec.aso_resource_id = FND_API.G_MISS_NUM ) ) THEN
712: FND_MESSAGE.set_name( 'AHL','AHL_RM_ASO_RES_NULL' );
713: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
714: FND_MSG_PUB.add;
715: END IF;
716:

Line 713: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

709: p_rt_oper_resource_rec.aso_resource_id IS NULL ) OR
710: ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
711: p_rt_oper_resource_rec.aso_resource_id = FND_API.G_MISS_NUM ) ) THEN
712: FND_MESSAGE.set_name( 'AHL','AHL_RM_ASO_RES_NULL' );
713: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
714: FND_MSG_PUB.add;
715: END IF;
716:
717: -- Check if the mandatory quantity column contains a positive value.

Line 722: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_QTY_NULL' );

718: IF ( ( p_rt_oper_resource_rec.dml_operation = 'C' AND
719: p_rt_oper_resource_rec.quantity IS NULL ) OR
720: ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
721: p_rt_oper_resource_rec.quantity = FND_API.G_MISS_NUM ) ) THEN
722: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_QTY_NULL' );
723: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
724: FND_MSG_PUB.add;
725: ELSIF ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
726: p_rt_oper_resource_rec.quantity <= 0 ) THEN

Line 723: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

719: p_rt_oper_resource_rec.quantity IS NULL ) OR
720: ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
721: p_rt_oper_resource_rec.quantity = FND_API.G_MISS_NUM ) ) THEN
722: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_QTY_NULL' );
723: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
724: FND_MSG_PUB.add;
725: ELSIF ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
726: p_rt_oper_resource_rec.quantity <= 0 ) THEN
727: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_QTY_LESS_ZERO' );

Line 727: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_QTY_LESS_ZERO' );

723: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
724: FND_MSG_PUB.add;
725: ELSIF ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
726: p_rt_oper_resource_rec.quantity <= 0 ) THEN
727: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_QTY_LESS_ZERO' );
728: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
729: FND_MSG_PUB.add;
730: END IF;
731:

Line 728: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

724: FND_MSG_PUB.add;
725: ELSIF ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
726: p_rt_oper_resource_rec.quantity <= 0 ) THEN
727: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_QTY_LESS_ZERO' );
728: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
729: FND_MSG_PUB.add;
730: END IF;
731:
732: -- Check if the mandatory duration column contains a positive value.

Line 737: FND_MESSAGE.set_name( 'AHL','AHL_RM_DURATION_NULL' );

733: IF ( ( p_rt_oper_resource_rec.dml_operation = 'C' AND
734: p_rt_oper_resource_rec.duration IS NULL ) OR
735: ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
736: p_rt_oper_resource_rec.duration = FND_API.G_MISS_NUM ) ) THEN
737: FND_MESSAGE.set_name( 'AHL','AHL_RM_DURATION_NULL' );
738: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
739: FND_MSG_PUB.add;
740: ELSIF ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
741: p_rt_oper_resource_rec.duration <= 0 ) THEN

Line 738: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

734: p_rt_oper_resource_rec.duration IS NULL ) OR
735: ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
736: p_rt_oper_resource_rec.duration = FND_API.G_MISS_NUM ) ) THEN
737: FND_MESSAGE.set_name( 'AHL','AHL_RM_DURATION_NULL' );
738: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
739: FND_MSG_PUB.add;
740: ELSIF ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
741: p_rt_oper_resource_rec.duration <= 0 ) THEN
742: FND_MESSAGE.set_name( 'AHL','AHL_RM_DURATION_LESS_ZERO' );

Line 742: FND_MESSAGE.set_name( 'AHL','AHL_RM_DURATION_LESS_ZERO' );

738: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
739: FND_MSG_PUB.add;
740: ELSIF ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
741: p_rt_oper_resource_rec.duration <= 0 ) THEN
742: FND_MESSAGE.set_name( 'AHL','AHL_RM_DURATION_LESS_ZERO' );
743: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
744: FND_MSG_PUB.add;
745: END IF;
746:

Line 743: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

739: FND_MSG_PUB.add;
740: ELSIF ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
741: p_rt_oper_resource_rec.duration <= 0 ) THEN
742: FND_MESSAGE.set_name( 'AHL','AHL_RM_DURATION_LESS_ZERO' );
743: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
744: FND_MSG_PUB.add;
745: END IF;
746:
747: -- Bug # 7644260 (FP for ER # 6998882) -- start

Line 753: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_SEQ_LESS_ZERO' );

749: IF ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
750: p_rt_oper_resource_rec.schedule_seq IS NOT NULL AND
751: p_rt_oper_resource_rec.schedule_seq <> FND_API.G_MISS_NUM AND
752: p_rt_oper_resource_rec.schedule_seq <= 0 ) THEN
753: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_SEQ_LESS_ZERO' );
754: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
755: FND_MSG_PUB.add;
756: --Check if the schedule sequence column contains a whole number.
757: ELSIF ( p_rt_oper_resource_rec.dml_operation <> 'D' AND

Line 754: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

750: p_rt_oper_resource_rec.schedule_seq IS NOT NULL AND
751: p_rt_oper_resource_rec.schedule_seq <> FND_API.G_MISS_NUM AND
752: p_rt_oper_resource_rec.schedule_seq <= 0 ) THEN
753: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_SEQ_LESS_ZERO' );
754: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
755: FND_MSG_PUB.add;
756: --Check if the schedule sequence column contains a whole number.
757: ELSIF ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
758: p_rt_oper_resource_rec.schedule_seq IS NOT NULL AND

Line 761: FND_MESSAGE.set_name( 'AHL','AHL_COM_SCHED_SEQ_INV' );

757: ELSIF ( p_rt_oper_resource_rec.dml_operation <> 'D' AND
758: p_rt_oper_resource_rec.schedule_seq IS NOT NULL AND
759: p_rt_oper_resource_rec.schedule_seq <> FND_API.G_MISS_NUM AND
760: TRUNC(p_rt_oper_resource_rec.schedule_seq) <> p_rt_oper_resource_rec.schedule_seq ) THEN
761: FND_MESSAGE.set_name( 'AHL','AHL_COM_SCHED_SEQ_INV' );
762: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
763: FND_MSG_PUB.add;
764: END IF;
765: -- Bug # 7644260 (FP for ER # 6998882) -- end

Line 762: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

758: p_rt_oper_resource_rec.schedule_seq IS NOT NULL AND
759: p_rt_oper_resource_rec.schedule_seq <> FND_API.G_MISS_NUM AND
760: TRUNC(p_rt_oper_resource_rec.schedule_seq) <> p_rt_oper_resource_rec.schedule_seq ) THEN
761: FND_MESSAGE.set_name( 'AHL','AHL_COM_SCHED_SEQ_INV' );
762: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
763: FND_MSG_PUB.add;
764: END IF;
765: -- Bug # 7644260 (FP for ER # 6998882) -- end
766:

Line 773: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_TYPE_NULL' );

769: ( p_rt_oper_resource_rec.resource_type IS NULL OR
770: p_rt_oper_resource_rec.resource_type = FND_API.G_MISS_CHAR ) AND
771: ( p_rt_oper_resource_rec.resource_type_id IS NULL OR
772: p_rt_oper_resource_rec.resource_type_id = FND_API.G_MISS_NUM ) ) THEN
773: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_TYPE_NULL' );
774: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
775: FND_MSG_PUB.add;
776: ELSIF ( p_rt_oper_resource_rec.dml_operation = 'U' AND
777: p_rt_oper_resource_rec.resource_type = FND_API.G_MISS_CHAR AND

Line 774: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

770: p_rt_oper_resource_rec.resource_type = FND_API.G_MISS_CHAR ) AND
771: ( p_rt_oper_resource_rec.resource_type_id IS NULL OR
772: p_rt_oper_resource_rec.resource_type_id = FND_API.G_MISS_NUM ) ) THEN
773: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_TYPE_NULL' );
774: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
775: FND_MSG_PUB.add;
776: ELSIF ( p_rt_oper_resource_rec.dml_operation = 'U' AND
777: p_rt_oper_resource_rec.resource_type = FND_API.G_MISS_CHAR AND
778: p_rt_oper_resource_rec.resource_type_id = FND_API.G_MISS_NUM ) THEN

Line 779: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_TYPE_NULL' );

775: FND_MSG_PUB.add;
776: ELSIF ( p_rt_oper_resource_rec.dml_operation = 'U' AND
777: p_rt_oper_resource_rec.resource_type = FND_API.G_MISS_CHAR AND
778: p_rt_oper_resource_rec.resource_type_id = FND_API.G_MISS_NUM ) THEN
779: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_TYPE_NULL' );
780: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
781: FND_MSG_PUB.add;
782: END IF;
783: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception

Line 780: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

776: ELSIF ( p_rt_oper_resource_rec.dml_operation = 'U' AND
777: p_rt_oper_resource_rec.resource_type = FND_API.G_MISS_CHAR AND
778: p_rt_oper_resource_rec.resource_type_id = FND_API.G_MISS_NUM ) THEN
779: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_TYPE_NULL' );
780: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
781: FND_MSG_PUB.add;
782: END IF;
783: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
784: l_msg_count := FND_MSG_PUB.count_msg;

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

804: x_max_rt_time_span => l_max_rt_time_span
805: );
806:
807: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
808: FND_MESSAGE.set_name( 'AHL', l_msg_data );
809: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.duration );
810: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );
811: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
812: FND_MSG_PUB.add;

Line 809: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.duration );

805: );
806:
807: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
808: FND_MESSAGE.set_name( 'AHL', l_msg_data );
809: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.duration );
810: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );
811: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
812: FND_MSG_PUB.add;
813: END IF;

Line 810: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );

806:
807: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
808: FND_MESSAGE.set_name( 'AHL', l_msg_data );
809: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.duration );
810: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );
811: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
812: FND_MSG_PUB.add;
813: END IF;
814: END IF;

Line 811: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

807: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
808: FND_MESSAGE.set_name( 'AHL', l_msg_data );
809: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.duration );
810: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );
811: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
812: FND_MSG_PUB.add;
813: END IF;
814: END IF;
815: -- end changes for fix 6512803. */

Line 825: FND_MESSAGE.set_name( 'AHL','AHL_RM_ALTERNATE_RES_EXISTS' );

821: -- Check if the ASO resource already existing as an alternate resource when updating the primary ASO resource.
822: OPEN check_alternate_resource(p_rt_oper_resource_rec.rt_oper_resource_id, p_rt_oper_resource_rec.aso_resource_id);
823: FETCH check_alternate_resource into l_dummy;
824: IF check_alternate_resource%FOUND THEN
825: FND_MESSAGE.set_name( 'AHL','AHL_RM_ALTERNATE_RES_EXISTS' );
826: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
827: FND_MSG_PUB.add;
828: END IF;
829: CLOSE check_alternate_resource;

Line 826: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

822: OPEN check_alternate_resource(p_rt_oper_resource_rec.rt_oper_resource_id, p_rt_oper_resource_rec.aso_resource_id);
823: FETCH check_alternate_resource into l_dummy;
824: IF check_alternate_resource%FOUND THEN
825: FND_MESSAGE.set_name( 'AHL','AHL_RM_ALTERNATE_RES_EXISTS' );
826: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
827: FND_MSG_PUB.add;
828: END IF;
829: CLOSE check_alternate_resource;
830:

Line 834: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_OBJ_VERSION_NULL' );

830:
831: -- Check if the mandatory Object Version Number column contains a null value.
832: IF ( p_rt_oper_resource_rec.object_version_number IS NULL OR
833: p_rt_oper_resource_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
834: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_OBJ_VERSION_NULL' );
835: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
836: FND_MSG_PUB.add;
837: END IF;
838:

Line 835: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

831: -- Check if the mandatory Object Version Number column contains a null value.
832: IF ( p_rt_oper_resource_rec.object_version_number IS NULL OR
833: p_rt_oper_resource_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
834: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_OBJ_VERSION_NULL' );
835: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
836: FND_MSG_PUB.add;
837: END IF;
838:
839: -- Check if the mandatory rt_oper_resource ID column contains a null value.

Line 842: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_OPER_RES_ID_NULL' );

838:
839: -- Check if the mandatory rt_oper_resource ID column contains a null value.
840: IF ( p_rt_oper_resource_rec.rt_oper_resource_id IS NULL OR
841: p_rt_oper_resource_rec.rt_oper_resource_id = FND_API.G_MISS_NUM ) THEN
842: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_OPER_RES_ID_NULL' );
843: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
844: FND_MSG_PUB.add;
845: END IF;
846:

Line 843: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

839: -- Check if the mandatory rt_oper_resource ID column contains a null value.
840: IF ( p_rt_oper_resource_rec.rt_oper_resource_id IS NULL OR
841: p_rt_oper_resource_rec.rt_oper_resource_id = FND_API.G_MISS_NUM ) THEN
842: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_OPER_RES_ID_NULL' );
843: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
844: FND_MSG_PUB.add;
845: END IF;
846:
847: -- Get the old record from AHL_RT_OPER_RESOURCES.

Line 864: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RES_TYPE_NO_CHG' );

860: FETCH alternate_resource_csr INTO l_alternate_resource_id;
861: -- Check if alternate resources are defined for the primary resource, if so throw error that
862: -- "Resource type cannot be changed if alternate resources are defined".
863: IF alternate_resource_csr%FOUND THEN
864: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RES_TYPE_NO_CHG' );
865: -- get_record_identifier can't be used here as it takes old record as parameter.
866: FND_MESSAGE.set_token( 'RECORD', l_old_rt_oper_resource_rec.resource_type
867: || ' - '
868: || l_old_rt_oper_resource_rec.aso_resource_name);

Line 866: FND_MESSAGE.set_token( 'RECORD', l_old_rt_oper_resource_rec.resource_type

862: -- "Resource type cannot be changed if alternate resources are defined".
863: IF alternate_resource_csr%FOUND THEN
864: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RES_TYPE_NO_CHG' );
865: -- get_record_identifier can't be used here as it takes old record as parameter.
866: FND_MESSAGE.set_token( 'RECORD', l_old_rt_oper_resource_rec.resource_type
867: || ' - '
868: || l_old_rt_oper_resource_rec.aso_resource_name);
869: FND_MSG_PUB.add;
870: RAISE FND_API.G_EXC_ERROR;

Line 926: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_TYPE_ASO_RES' );

922:
923: IF ( check_resource_type%NOTFOUND ) THEN
924:
925: x_return_status := FND_API.G_RET_STS_ERROR ;
926: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_TYPE_ASO_RES' );
927:
928: IF ( p_rt_oper_resource_rec.aso_resource_name IS NULL ) THEN
929: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_rt_oper_resource_rec.aso_resource_id ) );
930: ELSE

Line 929: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_rt_oper_resource_rec.aso_resource_id ) );

925: x_return_status := FND_API.G_RET_STS_ERROR ;
926: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_TYPE_ASO_RES' );
927:
928: IF ( p_rt_oper_resource_rec.aso_resource_name IS NULL ) THEN
929: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_rt_oper_resource_rec.aso_resource_id ) );
930: ELSE
931: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.aso_resource_name );
932: END IF;
933:

Line 931: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.aso_resource_name );

927:
928: IF ( p_rt_oper_resource_rec.aso_resource_name IS NULL ) THEN
929: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_rt_oper_resource_rec.aso_resource_id ) );
930: ELSE
931: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.aso_resource_name );
932: END IF;
933:
934: IF ( p_rt_oper_resource_rec.resource_type IS NULL ) THEN
935: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_rt_oper_resource_rec.resource_type_id ) );

Line 935: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_rt_oper_resource_rec.resource_type_id ) );

931: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.aso_resource_name );
932: END IF;
933:
934: IF ( p_rt_oper_resource_rec.resource_type IS NULL ) THEN
935: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_rt_oper_resource_rec.resource_type_id ) );
936: ELSE
937: FND_MESSAGE.set_token( 'FIELD2', p_rt_oper_resource_rec.resource_type );
938: END IF;
939:

Line 937: FND_MESSAGE.set_token( 'FIELD2', p_rt_oper_resource_rec.resource_type );

933:
934: IF ( p_rt_oper_resource_rec.resource_type IS NULL ) THEN
935: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_rt_oper_resource_rec.resource_type_id ) );
936: ELSE
937: FND_MESSAGE.set_token( 'FIELD2', p_rt_oper_resource_rec.resource_type );
938: END IF;
939:
940: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
941: FND_MSG_PUB.add;

Line 940: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

936: ELSE
937: FND_MESSAGE.set_token( 'FIELD2', p_rt_oper_resource_rec.resource_type );
938: END IF;
939:
940: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
941: FND_MSG_PUB.add;
942: END IF;
943: END IF;
944:

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

964: );
965:
966: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
967: x_return_status := FND_API.G_RET_STS_ERROR ;
968: FND_MESSAGE.set_name( 'AHL', l_msg_data );
969: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.duration );
970: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );
971: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
972: FND_MSG_PUB.add;

Line 969: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.duration );

965:
966: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
967: x_return_status := FND_API.G_RET_STS_ERROR ;
968: FND_MESSAGE.set_name( 'AHL', l_msg_data );
969: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.duration );
970: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );
971: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
972: FND_MSG_PUB.add;
973: --dbms_output.put_line('validate_resource_duration error');

Line 970: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );

966: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
967: x_return_status := FND_API.G_RET_STS_ERROR ;
968: FND_MESSAGE.set_name( 'AHL', l_msg_data );
969: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.duration );
970: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );
971: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
972: FND_MSG_PUB.add;
973: --dbms_output.put_line('validate_resource_duration error');
974: END IF;

Line 971: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );

967: x_return_status := FND_API.G_RET_STS_ERROR ;
968: FND_MESSAGE.set_name( 'AHL', l_msg_data );
969: FND_MESSAGE.set_token( 'FIELD1', p_rt_oper_resource_rec.duration );
970: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );
971: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
972: FND_MSG_PUB.add;
973: --dbms_output.put_line('validate_resource_duration error');
974: END IF;
975: END IF;

Line 1075: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_RESOURCE_DUP' );

1071: END LOOP;
1072:
1073: IF ( get_dup_rec%ROWCOUNT > 0 ) THEN
1074: CLOSE get_dup_rec;
1075: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_RESOURCE_DUP' );
1076: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_rt_oper_resource_rec ) );
1077: FND_MSG_PUB.add;
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: RETURN;

Line 1076: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_rt_oper_resource_rec ) );

1072:
1073: IF ( get_dup_rec%ROWCOUNT > 0 ) THEN
1074: CLOSE get_dup_rec;
1075: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_RESOURCE_DUP' );
1076: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_rt_oper_resource_rec ) );
1077: FND_MSG_PUB.add;
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: RETURN;
1080: END IF;

Line 1092: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_CONFLICT_RES' );

1088: FETCH get_dept_conflicts INTO l_dummy;
1089:
1090: IF ( get_dept_conflicts%FOUND ) THEN
1091: CLOSE get_dept_conflicts;
1092: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_CONFLICT_RES' );
1093: FND_MSG_PUB.add;
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095: RETURN;
1096: END IF;

Line 1114: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_CONFLICT_RES' );

1110: FETCH get_dept_conflicts_alt_res INTO l_dummy;
1111:
1112: IF ( get_dept_conflicts_alt_res%FOUND ) THEN
1113: CLOSE get_dept_conflicts_alt_res;
1114: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_CONFLICT_RES' );
1115: FND_MSG_PUB.add;
1116: x_return_status := FND_API.G_RET_STS_ERROR;
1117: RAISE FND_API.G_EXC_ERROR;
1118: END IF;

Line 1391: FND_MESSAGE.SET_NAME('AHL',l_msg_data);

1387: l_return_status
1388: );
1389:
1390: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1391: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
1392: FND_MSG_PUB.ADD;
1393: x_return_status := l_return_status;
1394: RETURN;
1395: END IF;

Line 1422: FND_MESSAGE.SET_NAME('AHL',l_msg_data);

1418: l_return_status
1419: );
1420:
1421: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1422: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
1423: FND_MSG_PUB.ADD;
1424: x_return_status := l_return_status;
1425: RETURN;
1426: END IF;

Line 1531: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_RESOURCE_DUP' );

1527:
1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: IF ( SQLCODE = -1 ) THEN
1531: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_RESOURCE_DUP' );
1532: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_x_rt_oper_resource_tbl(i) ) );
1533: FND_MSG_PUB.add;
1534: ELSE
1535: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

Line 1532: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_x_rt_oper_resource_tbl(i) ) );

1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: IF ( SQLCODE = -1 ) THEN
1531: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_RESOURCE_DUP' );
1532: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_x_rt_oper_resource_tbl(i) ) );
1533: FND_MSG_PUB.add;
1534: ELSE
1535: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1536: fnd_log.string

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

1580: AND object_version_number = p_x_rt_oper_resource_tbl(i).object_version_number;
1581:
1582: -- If the record does not exist, then, abort API.
1583: IF ( SQL%ROWCOUNT = 0 ) THEN
1584: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1585: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_tbl(i) ) );
1586: FND_MSG_PUB.add;
1587: END IF;
1588:

Line 1585: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_tbl(i) ) );

1581:
1582: -- If the record does not exist, then, abort API.
1583: IF ( SQL%ROWCOUNT = 0 ) THEN
1584: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1585: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_tbl(i) ) );
1586: FND_MSG_PUB.add;
1587: END IF;
1588:
1589: -- Set OUT values

Line 1595: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_RESOURCE_DUP' );

1591:
1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: IF ( SQLCODE = -1 ) THEN
1595: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_RESOURCE_DUP' );
1596: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_tbl(i) ) );
1597: FND_MSG_PUB.add;
1598: ELSE
1599: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

Line 1596: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_tbl(i) ) );

1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: IF ( SQLCODE = -1 ) THEN
1595: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_RESOURCE_DUP' );
1596: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_resource_tbl(i) ) );
1597: FND_MSG_PUB.add;
1598: ELSE
1599: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1600: fnd_log.string

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

1620: AND object_version_number = p_x_rt_oper_resource_tbl(i).object_version_number;
1621:
1622: -- If the record does not exist, then, abort API.
1623: IF ( SQL%ROWCOUNT = 0 ) THEN
1624: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1625: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
1626: FND_MSG_PUB.add;
1627: END IF;
1628: END IF;

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

1621:
1622: -- If the record does not exist, then, abort API.
1623: IF ( SQL%ROWCOUNT = 0 ) THEN
1624: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1625: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
1626: FND_MSG_PUB.add;
1627: END IF;
1628: END IF;
1629: END LOOP;

Line 1780: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_COST_BASIS' );

1776: );
1777:
1778: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1779: IF ( l_msg_data = 'AHL_RM_INVALID_MFG_LOOKUP' ) THEN
1780: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_COST_BASIS' );
1781: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
1782: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_COST_BASIS' );
1783: ELSE
1784: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 1782: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_COST_BASIS' );

1778: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1779: IF ( l_msg_data = 'AHL_RM_INVALID_MFG_LOOKUP' ) THEN
1780: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_COST_BASIS' );
1781: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
1782: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_COST_BASIS' );
1783: ELSE
1784: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1785: END IF;
1786:

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

1780: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_COST_BASIS' );
1781: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
1782: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_COST_BASIS' );
1783: ELSE
1784: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1785: END IF;
1786:
1787: IF ( p_x_rt_oper_cost_rec.cost_basis IS NULL OR
1788: p_x_rt_oper_cost_rec.cost_basis = FND_API.G_MISS_CHAR ) THEN

Line 1789: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.cost_basis_id ) );

1785: END IF;
1786:
1787: IF ( p_x_rt_oper_cost_rec.cost_basis IS NULL OR
1788: p_x_rt_oper_cost_rec.cost_basis = FND_API.G_MISS_CHAR ) THEN
1789: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.cost_basis_id ) );
1790: ELSE
1791: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.cost_basis );
1792: END IF;
1793:

Line 1791: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.cost_basis );

1787: IF ( p_x_rt_oper_cost_rec.cost_basis IS NULL OR
1788: p_x_rt_oper_cost_rec.cost_basis = FND_API.G_MISS_CHAR ) THEN
1789: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.cost_basis_id ) );
1790: ELSE
1791: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.cost_basis );
1792: END IF;
1793:
1794: FND_MSG_PUB.add;
1795: END IF;

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

1811: p_x_activity_id => p_x_rt_oper_cost_rec.activity_id
1812: );
1813:
1814: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1815: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1816:
1817: IF ( p_x_rt_oper_cost_rec.activity IS NULL OR
1818: p_x_rt_oper_cost_rec.activity = FND_API.G_MISS_CHAR ) THEN
1819: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.activity_id ) );

Line 1819: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.activity_id ) );

1815: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1816:
1817: IF ( p_x_rt_oper_cost_rec.activity IS NULL OR
1818: p_x_rt_oper_cost_rec.activity = FND_API.G_MISS_CHAR ) THEN
1819: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.activity_id ) );
1820: ELSE
1821: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.activity );
1822: END IF;
1823:

Line 1821: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.activity );

1817: IF ( p_x_rt_oper_cost_rec.activity IS NULL OR
1818: p_x_rt_oper_cost_rec.activity = FND_API.G_MISS_CHAR ) THEN
1819: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.activity_id ) );
1820: ELSE
1821: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.activity );
1822: END IF;
1823:
1824: FND_MSG_PUB.add;
1825: END IF;

Line 1847: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SCHEDULE_TYPE' );

1843: );
1844:
1845: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1846: IF ( l_msg_data = 'AHL_RM_INVALID_MFG_LOOKUP' ) THEN
1847: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SCHEDULE_TYPE' );
1848: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
1849: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SCHEDULE_TYPES' );
1850: ELSE
1851: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 1849: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SCHEDULE_TYPES' );

1845: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1846: IF ( l_msg_data = 'AHL_RM_INVALID_MFG_LOOKUP' ) THEN
1847: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SCHEDULE_TYPE' );
1848: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
1849: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SCHEDULE_TYPES' );
1850: ELSE
1851: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1852: END IF;
1853:

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

1847: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SCHEDULE_TYPE' );
1848: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
1849: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SCHEDULE_TYPES' );
1850: ELSE
1851: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1852: END IF;
1853:
1854: IF ( p_x_rt_oper_cost_rec.scheduled_type IS NULL OR
1855: p_x_rt_oper_cost_rec.scheduled_type = FND_API.G_MISS_CHAR ) THEN

Line 1856: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.scheduled_type_id ) );

1852: END IF;
1853:
1854: IF ( p_x_rt_oper_cost_rec.scheduled_type IS NULL OR
1855: p_x_rt_oper_cost_rec.scheduled_type = FND_API.G_MISS_CHAR ) THEN
1856: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.scheduled_type_id ) );
1857: ELSE
1858: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.scheduled_type );
1859: END IF;
1860:

Line 1858: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.scheduled_type );

1854: IF ( p_x_rt_oper_cost_rec.scheduled_type IS NULL OR
1855: p_x_rt_oper_cost_rec.scheduled_type = FND_API.G_MISS_CHAR ) THEN
1856: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.scheduled_type_id ) );
1857: ELSE
1858: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.scheduled_type );
1859: END IF;
1860:
1861: FND_MSG_PUB.add;
1862: END IF;

Line 1884: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ACHARGE_TYPE' );

1880: );
1881:
1882: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1883: IF ( l_msg_data = 'AHL_RM_INVALID_MFG_LOOKUP' ) THEN
1884: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ACHARGE_TYPE' );
1885: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
1886: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ACHARGE_TYPES' );
1887: ELSE
1888: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 1886: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ACHARGE_TYPES' );

1882: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1883: IF ( l_msg_data = 'AHL_RM_INVALID_MFG_LOOKUP' ) THEN
1884: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ACHARGE_TYPE' );
1885: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
1886: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ACHARGE_TYPES' );
1887: ELSE
1888: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1889: END IF;
1890:

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

1884: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ACHARGE_TYPE' );
1885: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
1886: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ACHARGE_TYPES' );
1887: ELSE
1888: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1889: END IF;
1890:
1891: IF ( p_x_rt_oper_cost_rec.autocharge_type IS NULL OR
1892: p_x_rt_oper_cost_rec.autocharge_type = FND_API.G_MISS_CHAR ) THEN

Line 1893: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.autocharge_type_id ) );

1889: END IF;
1890:
1891: IF ( p_x_rt_oper_cost_rec.autocharge_type IS NULL OR
1892: p_x_rt_oper_cost_rec.autocharge_type = FND_API.G_MISS_CHAR ) THEN
1893: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.autocharge_type_id ) );
1894: ELSE
1895: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.autocharge_type );
1896: END IF;
1897:

Line 1895: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.autocharge_type );

1891: IF ( p_x_rt_oper_cost_rec.autocharge_type IS NULL OR
1892: p_x_rt_oper_cost_rec.autocharge_type = FND_API.G_MISS_CHAR ) THEN
1893: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.autocharge_type_id ) );
1894: ELSE
1895: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.autocharge_type );
1896: END IF;
1897:
1898: FND_MSG_PUB.add;
1899: END IF;

Line 1921: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STD_RATE' );

1917: );
1918:
1919: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1920: IF ( l_msg_data = 'AHL_RM_INVALID_MFG_LOOKUP' ) THEN
1921: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STD_RATE' );
1922: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
1923: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STD_RATES' );
1924: ELSE
1925: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 1923: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STD_RATES' );

1919: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1920: IF ( l_msg_data = 'AHL_RM_INVALID_MFG_LOOKUP' ) THEN
1921: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STD_RATE' );
1922: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
1923: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STD_RATES' );
1924: ELSE
1925: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1926: END IF;
1927:

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

1921: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STD_RATE' );
1922: ELSIF ( l_msg_data = 'AHL_RM_TOO_MANY_MFG_LOOKUPS' ) THEN
1923: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STD_RATES' );
1924: ELSE
1925: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1926: END IF;
1927:
1928: IF ( p_x_rt_oper_cost_rec.standard_rate IS NULL OR
1929: p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN

Line 1930: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.standard_rate_flag ) );

1926: END IF;
1927:
1928: IF ( p_x_rt_oper_cost_rec.standard_rate IS NULL OR
1929: p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
1930: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.standard_rate_flag ) );
1931: ELSE
1932: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.standard_rate );
1933: END IF;
1934:

Line 1932: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.standard_rate );

1928: IF ( p_x_rt_oper_cost_rec.standard_rate IS NULL OR
1929: p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
1930: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.standard_rate_flag ) );
1931: ELSE
1932: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.standard_rate );
1933: END IF;
1934:
1935: FND_MSG_PUB.add;
1936: END IF;

Line 1983: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES' );

1979: l_old_rt_oper_cost_rec.standard_rate_flag,
1980: l_old_rt_oper_cost_rec.standard_rate;
1981:
1982: IF get_old_rec%NOTFOUND THEN
1983: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES' );
1984: FND_MSG_PUB.add;
1985: CLOSE get_old_rec;
1986: RAISE FND_API.G_EXC_ERROR;
1987: END IF;

Line 2172: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_OBJECT' );

2168: l_resource_type_id , -- added for 6512803.
2169: l_duration ,
2170: l_name ;
2171: IF get_object_rec%NOTFOUND THEN
2172: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_OBJECT' );
2173: FND_MSG_PUB.add;
2174: RAISE FND_API.G_EXC_ERROR;
2175: END IF;
2176: CLOSE get_object_rec;

Line 2187: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES_SCHEDULE_TY' );

2183: IF (p_x_rt_oper_cost_rec.scheduled_type_id IS NOT NULL) AND
2184: (p_x_rt_oper_cost_rec.scheduled_type_id <> FND_API.G_MISS_NUM) THEN
2185: /*
2186: IF (p_x_rt_oper_cost_rec.scheduled_type_id = 1) AND (l_resource_type_id NOT IN (1,2)) THEN
2187: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES_SCHEDULE_TY' );
2188: IF ( p_x_rt_oper_cost_rec.scheduled_type IS NULL OR
2189: p_x_rt_oper_cost_rec.scheduled_type = FND_API.G_MISS_CHAR ) THEN
2190: SELECT meaning
2191: INTO p_x_rt_oper_cost_rec.scheduled_type

Line 2197: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.scheduled_type );

2193: WHERE lookup_type = 'BOM_RESOURCE_SCHEDULE_TYPE'
2194: AND lookup_code = p_x_rt_oper_cost_rec.scheduled_type_id;
2195:
2196: END IF;
2197: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.scheduled_type );
2198: FND_MSG_PUB.add;
2199: RAISE FND_API.G_EXC_ERROR;
2200: END IF; -- p_x_rt_oper_cost_rec.scheduled_type_id = 1
2201: */

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

2211: x_max_rt_time_span => l_max_rt_time_span
2212: );
2213:
2214: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2215: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2216: FND_MESSAGE.set_token( 'FIELD1', l_duration );
2217: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );
2218: FND_MESSAGE.set_token( 'RECORD', l_name);
2219: FND_MSG_PUB.add;

Line 2216: FND_MESSAGE.set_token( 'FIELD1', l_duration );

2212: );
2213:
2214: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2215: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2216: FND_MESSAGE.set_token( 'FIELD1', l_duration );
2217: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );
2218: FND_MESSAGE.set_token( 'RECORD', l_name);
2219: FND_MSG_PUB.add;
2220: --dbms_output.put_line('Cost: validate_resource_duration error');

Line 2217: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );

2213:
2214: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2215: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2216: FND_MESSAGE.set_token( 'FIELD1', l_duration );
2217: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );
2218: FND_MESSAGE.set_token( 'RECORD', l_name);
2219: FND_MSG_PUB.add;
2220: --dbms_output.put_line('Cost: validate_resource_duration error');
2221: END IF;

Line 2218: FND_MESSAGE.set_token( 'RECORD', l_name);

2214: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2215: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2216: FND_MESSAGE.set_token( 'FIELD1', l_duration );
2217: FND_MESSAGE.set_token( 'FIELD2', l_max_rt_time_span );
2218: FND_MESSAGE.set_token( 'RECORD', l_name);
2219: FND_MSG_PUB.add;
2220: --dbms_output.put_line('Cost: validate_resource_duration error');
2221: END IF;
2222: END IF;

Line 2259: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_OBJECT' );

2255: FETCH get_object_rec INTO
2256: l_object_id ,
2257: l_association_type_code ;
2258: IF get_object_rec%NOTFOUND THEN
2259: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_OBJECT' );
2260: FND_MSG_PUB.add;
2261: RAISE FND_API.G_EXC_ERROR;
2262: END IF;
2263: CLOSE get_object_rec;

Line 2283: FND_MESSAGE.SET_NAME('AHL',l_msg_data);

2279: l_return_status
2280: );
2281:
2282: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2283: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
2284: FND_MSG_PUB.ADD;
2285: x_return_status := l_return_status;
2286: RETURN;
2287: END IF;

Line 2331: FND_MESSAGE.SET_NAME('AHL',l_msg_data);

2327: l_return_status
2328: );
2329:
2330: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2331: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
2332: FND_MSG_PUB.ADD;
2333: x_return_status := l_return_status;
2334: RETURN;
2335: END IF;

Line 2373: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');

2369: AND object_version_number = p_x_rt_oper_cost_rec.object_version_number;
2370:
2371: -- If the record does not exist, then, abort API.
2372: IF ( SQL%ROWCOUNT = 0 ) THEN
2373: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
2374: FND_MSG_PUB.add;
2375: END IF;
2376:
2377: -- Set OUT values

Line 2484: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_RES_NULL' );

2480:
2481: -- Check if a valid value is passed in p_rt_oper_resource_id
2482: IF ( p_rt_oper_resource_id = FND_API.G_MISS_NUM OR
2483: p_rt_oper_resource_id IS NULL ) THEN
2484: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_RES_NULL' );
2485: FND_MSG_PUB.add;
2486: x_return_status := FND_API.G_RET_STS_ERROR;
2487: RAISE FND_API.G_EXC_ERROR;
2488: END IF;

Line 2492: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );

2488: END IF;
2489:
2490: -- Check if at least one record is passed in p_rt_oper_resource_tbl
2491: IF ( p_alt_resource_tbl.count < 1 ) THEN
2492: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
2493: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME3 );
2494: FND_MSG_PUB.add;
2495: x_return_status := FND_API.G_RET_STS_ERROR;
2496: RAISE FND_API.G_EXC_ERROR;

Line 2493: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME3 );

2489:
2490: -- Check if at least one record is passed in p_rt_oper_resource_tbl
2491: IF ( p_alt_resource_tbl.count < 1 ) THEN
2492: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
2493: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME3 );
2494: FND_MSG_PUB.add;
2495: x_return_status := FND_API.G_RET_STS_ERROR;
2496: RAISE FND_API.G_EXC_ERROR;
2497: END IF;

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

2505: p_alt_resource_tbl(i).dml_operation <> 'D'
2506: )
2507: )
2508: THEN
2509: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
2510: FND_MESSAGE.set_token( 'FIELD', p_alt_resource_tbl(i).dml_operation );
2511: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_tbl(i).aso_resource_name );
2512: FND_MSG_PUB.add;
2513: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2510: FND_MESSAGE.set_token( 'FIELD', p_alt_resource_tbl(i).dml_operation );

2506: )
2507: )
2508: THEN
2509: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
2510: FND_MESSAGE.set_token( 'FIELD', p_alt_resource_tbl(i).dml_operation );
2511: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_tbl(i).aso_resource_name );
2512: FND_MSG_PUB.add;
2513: x_return_status := FND_API.G_RET_STS_ERROR;
2514: RAISE FND_API.G_EXC_ERROR;

Line 2511: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_tbl(i).aso_resource_name );

2507: )
2508: THEN
2509: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
2510: FND_MESSAGE.set_token( 'FIELD', p_alt_resource_tbl(i).dml_operation );
2511: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_tbl(i).aso_resource_name );
2512: FND_MSG_PUB.add;
2513: x_return_status := FND_API.G_RET_STS_ERROR;
2514: RAISE FND_API.G_EXC_ERROR;
2515: END IF;

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

2561: p_x_aso_resource_id => p_x_alt_resource_rec.aso_resource_id
2562: );
2563:
2564: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2565: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2566:
2567: IF ( p_x_alt_resource_rec.aso_resource_name IS NULL OR
2568: p_x_alt_resource_rec.aso_resource_name = FND_API.G_MISS_CHAR ) THEN
2569: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_alt_resource_rec.aso_resource_id ) );

Line 2569: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_alt_resource_rec.aso_resource_id ) );

2565: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2566:
2567: IF ( p_x_alt_resource_rec.aso_resource_name IS NULL OR
2568: p_x_alt_resource_rec.aso_resource_name = FND_API.G_MISS_CHAR ) THEN
2569: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_alt_resource_rec.aso_resource_id ) );
2570: ELSE
2571: FND_MESSAGE.set_token( 'FIELD', p_x_alt_resource_rec.aso_resource_name );
2572: END IF;
2573:

Line 2571: FND_MESSAGE.set_token( 'FIELD', p_x_alt_resource_rec.aso_resource_name );

2567: IF ( p_x_alt_resource_rec.aso_resource_name IS NULL OR
2568: p_x_alt_resource_rec.aso_resource_name = FND_API.G_MISS_CHAR ) THEN
2569: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_alt_resource_rec.aso_resource_id ) );
2570: ELSE
2571: FND_MESSAGE.set_token( 'FIELD', p_x_alt_resource_rec.aso_resource_name );
2572: END IF;
2573:
2574: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_rec.aso_resource_name );
2575: FND_MSG_PUB.add;

Line 2574: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_rec.aso_resource_name );

2570: ELSE
2571: FND_MESSAGE.set_token( 'FIELD', p_x_alt_resource_rec.aso_resource_name );
2572: END IF;
2573:
2574: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_rec.aso_resource_name );
2575: FND_MSG_PUB.add;
2576: END IF;
2577: x_return_status := l_return_status;
2578: END IF;

Line 2753: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ALT_RES_REC' );

2749: l_old_alt_resource_rec.attribute14,
2750: l_old_alt_resource_rec.attribute15;
2751:
2752: IF get_old_rec%NOTFOUND THEN
2753: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ALT_RES_REC' );
2754: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_rec.aso_resource_name );
2755: FND_MSG_PUB.add;
2756: CLOSE get_old_rec;
2757: RAISE FND_API.G_EXC_ERROR;

Line 2754: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_rec.aso_resource_name );

2750: l_old_alt_resource_rec.attribute15;
2751:
2752: IF get_old_rec%NOTFOUND THEN
2753: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ALT_RES_REC' );
2754: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_rec.aso_resource_name );
2755: FND_MSG_PUB.add;
2756: CLOSE get_old_rec;
2757: RAISE FND_API.G_EXC_ERROR;
2758: END IF;

Line 2902: FND_MESSAGE.set_name( 'AHL','AHL_RM_PRIORITY_NULL' );

2898: IF ( ( p_alt_resource_rec.dml_operation = 'C' AND
2899: p_alt_resource_rec.priority IS NULL ) OR
2900: ( p_alt_resource_rec.dml_operation <> 'D' AND
2901: p_alt_resource_rec.priority = FND_API.G_MISS_NUM ) ) THEN
2902: FND_MESSAGE.set_name( 'AHL','AHL_RM_PRIORITY_NULL' );
2903: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2904: FND_MSG_PUB.add;
2905: ELSIF ( p_alt_resource_rec.dml_operation <> 'D' AND
2906: p_alt_resource_rec.priority <= 0 ) THEN

Line 2903: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );

2899: p_alt_resource_rec.priority IS NULL ) OR
2900: ( p_alt_resource_rec.dml_operation <> 'D' AND
2901: p_alt_resource_rec.priority = FND_API.G_MISS_NUM ) ) THEN
2902: FND_MESSAGE.set_name( 'AHL','AHL_RM_PRIORITY_NULL' );
2903: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2904: FND_MSG_PUB.add;
2905: ELSIF ( p_alt_resource_rec.dml_operation <> 'D' AND
2906: p_alt_resource_rec.priority <= 0 ) THEN
2907: FND_MESSAGE.set_name( 'AHL','AHL_RM_PRIORITY_LESS_ZERO' );

Line 2907: FND_MESSAGE.set_name( 'AHL','AHL_RM_PRIORITY_LESS_ZERO' );

2903: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2904: FND_MSG_PUB.add;
2905: ELSIF ( p_alt_resource_rec.dml_operation <> 'D' AND
2906: p_alt_resource_rec.priority <= 0 ) THEN
2907: FND_MESSAGE.set_name( 'AHL','AHL_RM_PRIORITY_LESS_ZERO' );
2908: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2909: FND_MSG_PUB.add;
2910: ELSIF ( p_alt_resource_rec.dml_operation <> 'D' AND
2911: p_alt_resource_rec.priority > 0 ) THEN

Line 2908: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );

2904: FND_MSG_PUB.add;
2905: ELSIF ( p_alt_resource_rec.dml_operation <> 'D' AND
2906: p_alt_resource_rec.priority <= 0 ) THEN
2907: FND_MESSAGE.set_name( 'AHL','AHL_RM_PRIORITY_LESS_ZERO' );
2908: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2909: FND_MSG_PUB.add;
2910: ELSIF ( p_alt_resource_rec.dml_operation <> 'D' AND
2911: p_alt_resource_rec.priority > 0 ) THEN
2912: BEGIN

Line 2916: FND_MESSAGE.set_name( 'AHL','AHL_RM_PRIORITY_NOT_INTEGER' );

2912: BEGIN
2913: l_dummy := TO_NUMBER(TO_CHAR(p_alt_resource_rec.priority), '999999');
2914: EXCEPTION
2915: WHEN OTHERS THEN
2916: FND_MESSAGE.set_name( 'AHL','AHL_RM_PRIORITY_NOT_INTEGER' );
2917: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2918: FND_MSG_PUB.add;
2919: END;
2920: END IF;

Line 2917: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );

2913: l_dummy := TO_NUMBER(TO_CHAR(p_alt_resource_rec.priority), '999999');
2914: EXCEPTION
2915: WHEN OTHERS THEN
2916: FND_MESSAGE.set_name( 'AHL','AHL_RM_PRIORITY_NOT_INTEGER' );
2917: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2918: FND_MSG_PUB.add;
2919: END;
2920: END IF;
2921:

Line 2929: FND_MESSAGE.set_name( 'AHL','AHL_RM_ALT_OBJ_VER_NUM_NULL' );

2925:
2926: -- Check if the mandatory Object Version Number column contains a null value.
2927: IF ( p_alt_resource_rec.dml_operation <> 'D' AND (p_alt_resource_rec.object_version_number IS NULL OR
2928: p_alt_resource_rec.object_version_number = FND_API.G_MISS_NUM) ) THEN
2929: FND_MESSAGE.set_name( 'AHL','AHL_RM_ALT_OBJ_VER_NUM_NULL' );
2930: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2931: FND_MSG_PUB.add;
2932: END IF;
2933:

Line 2930: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );

2926: -- Check if the mandatory Object Version Number column contains a null value.
2927: IF ( p_alt_resource_rec.dml_operation <> 'D' AND (p_alt_resource_rec.object_version_number IS NULL OR
2928: p_alt_resource_rec.object_version_number = FND_API.G_MISS_NUM) ) THEN
2929: FND_MESSAGE.set_name( 'AHL','AHL_RM_ALT_OBJ_VER_NUM_NULL' );
2930: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2931: FND_MSG_PUB.add;
2932: END IF;
2933:
2934: -- Check if the mandatory rt_oper_resource ID column contains a null value.

Line 2937: FND_MESSAGE.set_name( 'AHL','AHL_RM_ALT_RES_ID_NULL' );

2933:
2934: -- Check if the mandatory rt_oper_resource ID column contains a null value.
2935: IF ( p_alt_resource_rec.dml_operation <> 'D' AND (p_alt_resource_rec.alternate_resource_id IS NULL OR
2936: p_alt_resource_rec.alternate_resource_id = FND_API.G_MISS_NUM) ) THEN
2937: FND_MESSAGE.set_name( 'AHL','AHL_RM_ALT_RES_ID_NULL' );
2938: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2939: FND_MSG_PUB.add;
2940: END IF;
2941:

Line 2938: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );

2934: -- Check if the mandatory rt_oper_resource ID column contains a null value.
2935: IF ( p_alt_resource_rec.dml_operation <> 'D' AND (p_alt_resource_rec.alternate_resource_id IS NULL OR
2936: p_alt_resource_rec.alternate_resource_id = FND_API.G_MISS_NUM) ) THEN
2937: FND_MESSAGE.set_name( 'AHL','AHL_RM_ALT_RES_ID_NULL' );
2938: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2939: FND_MSG_PUB.add;
2940: END IF;
2941:
2942: END validate_alt_attributes;

Line 2972: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_RT_OPER_RES_ID' );

2968: x_return_status := FND_API.G_RET_STS_SUCCESS;
2969: OPEN check_resource_type1( p_rt_oper_resource_id);
2970: FETCH check_resource_type1 INTO l_res_type1;
2971: IF ( check_resource_type1%NOTFOUND ) THEN
2972: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_RT_OPER_RES_ID' );
2973: FND_MSG_PUB.add;
2974: x_return_status := FND_API.G_RET_STS_ERROR;
2975: ELSE
2976: OPEN check_resource_type2( p_alt_resource_rec.aso_resource_id);

Line 2979: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ASO_RES_ID' );

2975: ELSE
2976: OPEN check_resource_type2( p_alt_resource_rec.aso_resource_id);
2977: FETCH check_resource_type2 INTO l_res_type2;
2978: IF ( check_resource_type2%NOTFOUND ) THEN
2979: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ASO_RES_ID' );
2980: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2981: FND_MSG_PUB.add;
2982: x_return_status := FND_API.G_RET_STS_ERROR;
2983: ELSIF l_res_type1 <> l_res_type2 THEN

Line 2980: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );

2976: OPEN check_resource_type2( p_alt_resource_rec.aso_resource_id);
2977: FETCH check_resource_type2 INTO l_res_type2;
2978: IF ( check_resource_type2%NOTFOUND ) THEN
2979: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ASO_RES_ID' );
2980: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2981: FND_MSG_PUB.add;
2982: x_return_status := FND_API.G_RET_STS_ERROR;
2983: ELSIF l_res_type1 <> l_res_type2 THEN
2984: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_TYPE_DIFF' );

Line 2984: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_TYPE_DIFF' );

2980: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2981: FND_MSG_PUB.add;
2982: x_return_status := FND_API.G_RET_STS_ERROR;
2983: ELSIF l_res_type1 <> l_res_type2 THEN
2984: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_TYPE_DIFF' );
2985: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2986: FND_MSG_PUB.add;
2987: x_return_status := FND_API.G_RET_STS_ERROR;
2988: END IF;

Line 2985: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );

2981: FND_MSG_PUB.add;
2982: x_return_status := FND_API.G_RET_STS_ERROR;
2983: ELSIF l_res_type1 <> l_res_type2 THEN
2984: FND_MESSAGE.set_name( 'AHL','AHL_RM_RES_TYPE_DIFF' );
2985: FND_MESSAGE.set_token( 'RECORD', p_alt_resource_rec.aso_resource_name );
2986: FND_MSG_PUB.add;
2987: x_return_status := FND_API.G_RET_STS_ERROR;
2988: END IF;
2989: CLOSE check_resource_type2;

Line 3081: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RT_OPER_RES_ID' );

3077: OPEN get_primary_res_name (p_rt_oper_resource_id);
3078: FETCH get_primary_res_name INTO l_primary_name;
3079: IF get_primary_res_name%NOTFOUND THEN
3080: CLOSE get_primary_res_name;
3081: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RT_OPER_RES_ID' );
3082: FND_MSG_PUB.add;
3083: x_return_status := FND_API.G_RET_STS_ERROR;
3084: RAISE FND_API.G_EXC_ERROR;
3085: ELSE

Line 3091: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_PRIMARY_RESOURCE_NAME' );

3087: OPEN get_alt_res_name (p_rt_oper_resource_id, l_primary_name);
3088: FETCH get_alt_res_name INTO l_res_name;
3089: IF get_alt_res_name%FOUND THEN
3090: CLOSE get_alt_res_name;
3091: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_PRIMARY_RESOURCE_NAME' );
3092: FND_MESSAGE.set_token( 'RECORD', l_primary_name);
3093: FND_MSG_PUB.add;
3094: x_return_status := FND_API.G_RET_STS_ERROR;
3095: RAISE FND_API.G_EXC_ERROR;

Line 3092: FND_MESSAGE.set_token( 'RECORD', l_primary_name);

3088: FETCH get_alt_res_name INTO l_res_name;
3089: IF get_alt_res_name%FOUND THEN
3090: CLOSE get_alt_res_name;
3091: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_PRIMARY_RESOURCE_NAME' );
3092: FND_MESSAGE.set_token( 'RECORD', l_primary_name);
3093: FND_MSG_PUB.add;
3094: x_return_status := FND_API.G_RET_STS_ERROR;
3095: RAISE FND_API.G_EXC_ERROR;
3096: ELSE

Line 3108: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ALT_RESOURCE_DUP' );

3104: EXIT WHEN get_dup_rec1%NOTFOUND;
3105: END LOOP;
3106: IF ( get_dup_rec1%ROWCOUNT > 0 ) THEN
3107: CLOSE get_dup_rec1;
3108: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ALT_RESOURCE_DUP' );
3109: FND_MESSAGE.set_token( 'RECORD', l_res_name );
3110: FND_MSG_PUB.add;
3111: x_return_status := FND_API.G_RET_STS_ERROR;
3112: RAISE FND_API.G_EXC_ERROR;

Line 3109: FND_MESSAGE.set_token( 'RECORD', l_res_name );

3105: END LOOP;
3106: IF ( get_dup_rec1%ROWCOUNT > 0 ) THEN
3107: CLOSE get_dup_rec1;
3108: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ALT_RESOURCE_DUP' );
3109: FND_MESSAGE.set_token( 'RECORD', l_res_name );
3110: FND_MSG_PUB.add;
3111: x_return_status := FND_API.G_RET_STS_ERROR;
3112: RAISE FND_API.G_EXC_ERROR;
3113: END IF;

Line 3123: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ALT_RES_PRIORITY_DUP' );

3119: EXIT WHEN get_dup_rec2%NOTFOUND;
3120: END LOOP;
3121: IF ( get_dup_rec2%ROWCOUNT > 0 ) THEN
3122: CLOSE get_dup_rec2;
3123: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ALT_RES_PRIORITY_DUP' );
3124: FND_MESSAGE.set_token( 'RECORD', l_priority );
3125: FND_MSG_PUB.add;
3126: x_return_status := FND_API.G_RET_STS_ERROR;
3127: RAISE FND_API.G_EXC_ERROR;

Line 3124: FND_MESSAGE.set_token( 'RECORD', l_priority );

3120: END LOOP;
3121: IF ( get_dup_rec2%ROWCOUNT > 0 ) THEN
3122: CLOSE get_dup_rec2;
3123: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ALT_RES_PRIORITY_DUP' );
3124: FND_MESSAGE.set_token( 'RECORD', l_priority );
3125: FND_MSG_PUB.add;
3126: x_return_status := FND_API.G_RET_STS_ERROR;
3127: RAISE FND_API.G_EXC_ERROR;
3128: END IF;

Line 3147: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_CONFLICT_RES' );

3143: OPEN get_dept_conflicts( l_object_id, l_association_type_code, l_aso_res_id, l_alt_res_id);
3144: FETCH get_dept_conflicts INTO l_dummy;
3145: IF ( get_dept_conflicts%FOUND ) THEN
3146: CLOSE get_dept_conflicts;
3147: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_CONFLICT_RES' );
3148: FND_MSG_PUB.add;
3149: x_return_status := FND_API.G_RET_STS_ERROR;
3150: RAISE FND_API.G_EXC_ERROR;
3151: END IF;

Line 3417: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ALT_RESOURCE_DUP' );

3413:
3414: EXCEPTION
3415: WHEN OTHERS THEN
3416: IF ( SQLCODE = -1 ) THEN
3417: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ALT_RESOURCE_DUP' );
3418: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_tbl(i).aso_resource_name );
3419: FND_MSG_PUB.add;
3420: ELSE
3421: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

Line 3418: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_tbl(i).aso_resource_name );

3414: EXCEPTION
3415: WHEN OTHERS THEN
3416: IF ( SQLCODE = -1 ) THEN
3417: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ALT_RESOURCE_DUP' );
3418: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_tbl(i).aso_resource_name );
3419: FND_MSG_PUB.add;
3420: ELSE
3421: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
3422: fnd_log.string

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

3460: AND object_version_number = p_x_alt_resource_tbl(i).object_version_number;
3461:
3462: -- If the record does not exist, then, abort API.
3463: IF ( SQL%ROWCOUNT = 0 ) THEN
3464: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
3465: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_tbl(i).aso_resource_name );
3466: FND_MSG_PUB.add;
3467: END IF;
3468:

Line 3465: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_tbl(i).aso_resource_name );

3461:
3462: -- If the record does not exist, then, abort API.
3463: IF ( SQL%ROWCOUNT = 0 ) THEN
3464: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
3465: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_tbl(i).aso_resource_name );
3466: FND_MSG_PUB.add;
3467: END IF;
3468:
3469: -- Set OUT values

Line 3475: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ALT_RESOURCE_DUP' );

3471:
3472: EXCEPTION
3473: WHEN OTHERS THEN
3474: IF ( SQLCODE = -1 ) THEN
3475: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ALT_RESOURCE_DUP' );
3476: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_tbl(i).aso_resource_name );
3477: FND_MSG_PUB.add;
3478: ELSE
3479: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

Line 3476: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_tbl(i).aso_resource_name );

3472: EXCEPTION
3473: WHEN OTHERS THEN
3474: IF ( SQLCODE = -1 ) THEN
3475: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ALT_RESOURCE_DUP' );
3476: FND_MESSAGE.set_token( 'RECORD', p_x_alt_resource_tbl(i).aso_resource_name );
3477: FND_MSG_PUB.add;
3478: ELSE
3479: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
3480: fnd_log.string

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

3495: AND object_version_number = p_x_alt_resource_tbl(i).object_version_number;
3496:
3497: -- If the record does not exist, then, abort API.
3498: IF ( SQL%ROWCOUNT = 0 ) THEN
3499: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
3500: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
3501: FND_MSG_PUB.add;
3502: END IF;
3503: END IF;

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

3496:
3497: -- If the record does not exist, then, abort API.
3498: IF ( SQL%ROWCOUNT = 0 ) THEN
3499: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
3500: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
3501: FND_MSG_PUB.add;
3502: END IF;
3503: END IF;
3504: END LOOP;