APPS.AHL_RM_OP_ROUTE_AS_PVT dependencies on FND_API

Line 28: p_route_operation_rec.step <> FND_API.G_MISS_NUM ) THEN

24:
25: BEGIN
26:
27: IF ( p_route_operation_rec.step IS NOT NULL AND
28: p_route_operation_rec.step <> FND_API.G_MISS_NUM ) THEN
29: l_record_identifier := l_record_identifier || to_char(p_route_operation_rec.step);
30: END IF;
31:
32: l_record_identifier := l_record_identifier || ' - ';

Line 35: p_route_operation_rec.concatenated_segments <> FND_API.G_MISS_CHAR ) THEN

31:
32: l_record_identifier := l_record_identifier || ' - ';
33:
34: IF ( p_route_operation_rec.concatenated_segments IS NOT NULL AND
35: p_route_operation_rec.concatenated_segments <> FND_API.G_MISS_CHAR ) THEN
36: l_record_identifier := l_record_identifier || p_route_operation_rec.concatenated_segments;
37: END IF;
38:
39: l_record_identifier := l_record_identifier || ' - ';

Line 42: p_route_operation_rec.revision_number <> FND_API.G_MISS_CHAR ) THEN

38:
39: l_record_identifier := l_record_identifier || ' - ';
40:
41: IF ( p_route_operation_rec.revision_number IS NOT NULL AND
42: p_route_operation_rec.revision_number <> FND_API.G_MISS_CHAR ) THEN
43: l_record_identifier := l_record_identifier || p_route_operation_rec.revision_number;
44: END IF;
45:
46: l_record_identifier := l_record_identifier || ' - ';

Line 49: p_route_operation_rec.check_point_flag <> FND_API.G_MISS_CHAR ) THEN

45:
46: l_record_identifier := l_record_identifier || ' - ';
47:
48: IF ( p_route_operation_rec.check_point_flag IS NOT NULL AND
49: p_route_operation_rec.check_point_flag <> FND_API.G_MISS_CHAR ) THEN
50: l_record_identifier := l_record_identifier || p_route_operation_rec.check_point_flag;
51: END IF;
52:
53: RETURN l_record_identifier;

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: l_return_status VARCHAR2(1);
67: l_msg_data VARCHAR2(2000);
68:
69: BEGIN
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: -- Check if a valid value is passed in p_route_id
73: IF ( p_route_id = FND_API.G_MISS_NUM OR p_route_id IS NULL ) THEN
74: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_ID_NULL' );

Line 73: IF ( p_route_id = FND_API.G_MISS_NUM OR p_route_id IS NULL ) THEN

69: BEGIN
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: -- Check if a valid value is passed in p_route_id
73: IF ( p_route_id = FND_API.G_MISS_NUM OR p_route_id IS NULL ) THEN
74: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_ID_NULL' );
75: FND_MSG_PUB.add;
76: x_return_status := FND_API.G_RET_STS_ERROR;
77: RETURN;

Line 76: x_return_status := FND_API.G_RET_STS_ERROR;

72: -- Check if a valid value is passed in p_route_id
73: IF ( p_route_id = FND_API.G_MISS_NUM OR p_route_id IS NULL ) THEN
74: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_ID_NULL' );
75: FND_MSG_PUB.add;
76: x_return_status := FND_API.G_RET_STS_ERROR;
77: RETURN;
78: END IF;
79:
80: -- Check if the Route is existing and in Draft status

Line 88: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

84: l_msg_data,
85: l_return_status
86: );
87:
88: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
89: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
90: FND_MSG_PUB.ADD;
91: x_return_status := l_return_status;
92: RETURN;

Line 100: x_return_status := FND_API.G_RET_STS_ERROR;

96: IF ( p_route_operation_tbl.count < 1 ) THEN
97: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
98: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
99: FND_MSG_PUB.add;
100: x_return_status := FND_API.G_RET_STS_ERROR;
101: RETURN;
102: END IF;
103:
104: -- Validate DML Operation

Line 113: x_return_status := FND_API.G_RET_STS_ERROR;

109: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
110: FND_MESSAGE.set_token( 'FIELD', p_route_operation_tbl(i).dml_operation );
111: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_tbl(i) ) );
112: FND_MSG_PUB.add;
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: RETURN;
115: END IF;
116: END LOOP;
117:

Line 130: ELSIF ( p_x_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) THEN

126:
127: BEGIN
128: IF ( p_x_route_operation_rec.concatenated_segments IS NULL ) THEN
129: p_x_route_operation_rec.operation_id := NULL;
130: ELSIF ( p_x_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) THEN
131: p_x_route_operation_rec.operation_id := FND_API.G_MISS_NUM;
132: END IF;
133:
134: END clear_lov_attribute_ids;

Line 131: p_x_route_operation_rec.operation_id := FND_API.G_MISS_NUM;

127: BEGIN
128: IF ( p_x_route_operation_rec.concatenated_segments IS NULL ) THEN
129: p_x_route_operation_rec.operation_id := NULL;
130: ELSIF ( p_x_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) THEN
131: p_x_route_operation_rec.operation_id := FND_API.G_MISS_NUM;
132: END IF;
133:
134: END clear_lov_attribute_ids;
135:

Line 148: x_return_status := FND_API.G_RET_STS_SUCCESS;

144: l_return_status VARCHAR2(1);
145: l_msg_data VARCHAR2(2000);
146:
147: BEGIN
148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149:
150: -- Convert / Validate Operation
151: IF ( ( p_x_route_operation_rec.operation_id IS NOT NULL AND
152: p_x_route_operation_rec.operation_id <> FND_API.G_MISS_NUM ) OR

Line 152: p_x_route_operation_rec.operation_id <> FND_API.G_MISS_NUM ) OR

148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149:
150: -- Convert / Validate Operation
151: IF ( ( p_x_route_operation_rec.operation_id IS NOT NULL AND
152: p_x_route_operation_rec.operation_id <> FND_API.G_MISS_NUM ) OR
153: ( p_x_route_operation_rec.concatenated_segments IS NOT NULL AND
154: p_x_route_operation_rec.concatenated_segments <> FND_API.G_MISS_CHAR ) ) THEN
155:
156: AHL_RM_ROUTE_UTIL.validate_operation

Line 154: p_x_route_operation_rec.concatenated_segments <> FND_API.G_MISS_CHAR ) ) THEN

150: -- Convert / Validate Operation
151: IF ( ( p_x_route_operation_rec.operation_id IS NOT NULL AND
152: p_x_route_operation_rec.operation_id <> FND_API.G_MISS_NUM ) OR
153: ( p_x_route_operation_rec.concatenated_segments IS NOT NULL AND
154: p_x_route_operation_rec.concatenated_segments <> FND_API.G_MISS_CHAR ) ) THEN
155:
156: AHL_RM_ROUTE_UTIL.validate_operation
157: (
158: x_return_status => l_return_status,

Line 164: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

160: p_concatenated_segments => p_x_route_operation_rec.concatenated_segments,
161: p_x_operation_id => p_x_route_operation_rec.operation_id
162: );
163:
164: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
165: IF ( l_msg_data = 'AHL_RM_INVALID_OPERATION' ) THEN
166: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RTO_INVALID_OPERATION' );
167: ELSE
168: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 172: p_x_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) THEN

168: FND_MESSAGE.set_name( 'AHL', l_msg_data );
169: END IF;
170:
171: IF ( p_x_route_operation_rec.concatenated_segments IS NULL OR
172: p_x_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) THEN
173: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_operation_rec.operation_id ) );
174: ELSE
175: FND_MESSAGE.set_token( 'FIELD', p_x_route_operation_rec.concatenated_segments );
176: END IF;

Line 198: IF ( p_x_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) THEN

194:
195: BEGIN
196:
197: -- Convert G_MISS values to NULL
198: IF ( p_x_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) THEN
199: p_x_route_operation_rec.concatenated_segments := null;
200: END IF;
201:
202: IF ( p_x_route_operation_rec.operation_id = FND_API.G_MISS_NUM ) THEN

Line 202: IF ( p_x_route_operation_rec.operation_id = FND_API.G_MISS_NUM ) THEN

198: IF ( p_x_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) THEN
199: p_x_route_operation_rec.concatenated_segments := null;
200: END IF;
201:
202: IF ( p_x_route_operation_rec.operation_id = FND_API.G_MISS_NUM ) THEN
203: p_x_route_operation_rec.operation_id := null;
204: END IF;
205:
206: IF ( p_x_route_operation_rec.step = FND_API.G_MISS_NUM ) THEN

Line 206: IF ( p_x_route_operation_rec.step = FND_API.G_MISS_NUM ) THEN

202: IF ( p_x_route_operation_rec.operation_id = FND_API.G_MISS_NUM ) THEN
203: p_x_route_operation_rec.operation_id := null;
204: END IF;
205:
206: IF ( p_x_route_operation_rec.step = FND_API.G_MISS_NUM ) THEN
207: p_x_route_operation_rec.step := null;
208: END IF;
209:
210: IF ( p_x_route_operation_rec.check_point_flag = FND_API.G_MISS_CHAR ) THEN

Line 210: IF ( p_x_route_operation_rec.check_point_flag = FND_API.G_MISS_CHAR ) THEN

206: IF ( p_x_route_operation_rec.step = FND_API.G_MISS_NUM ) THEN
207: p_x_route_operation_rec.step := null;
208: END IF;
209:
210: IF ( p_x_route_operation_rec.check_point_flag = FND_API.G_MISS_CHAR ) THEN
211: p_x_route_operation_rec.check_point_flag := null;
212: END IF;
213:
214: IF ( p_x_route_operation_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

Line 214: IF ( p_x_route_operation_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

210: IF ( p_x_route_operation_rec.check_point_flag = FND_API.G_MISS_CHAR ) THEN
211: p_x_route_operation_rec.check_point_flag := null;
212: END IF;
213:
214: IF ( p_x_route_operation_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
215: p_x_route_operation_rec.attribute_category := null;
216: END IF;
217:
218: IF ( p_x_route_operation_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

Line 218: IF ( p_x_route_operation_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

214: IF ( p_x_route_operation_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
215: p_x_route_operation_rec.attribute_category := null;
216: END IF;
217:
218: IF ( p_x_route_operation_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
219: p_x_route_operation_rec.attribute1 := null;
220: END IF;
221:
222: IF ( p_x_route_operation_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

Line 222: IF ( p_x_route_operation_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

218: IF ( p_x_route_operation_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
219: p_x_route_operation_rec.attribute1 := null;
220: END IF;
221:
222: IF ( p_x_route_operation_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
223: p_x_route_operation_rec.attribute2 := null;
224: END IF;
225:
226: IF ( p_x_route_operation_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

Line 226: IF ( p_x_route_operation_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

222: IF ( p_x_route_operation_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
223: p_x_route_operation_rec.attribute2 := null;
224: END IF;
225:
226: IF ( p_x_route_operation_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
227: p_x_route_operation_rec.attribute3 := null;
228: END IF;
229:
230: IF ( p_x_route_operation_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

Line 230: IF ( p_x_route_operation_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

226: IF ( p_x_route_operation_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
227: p_x_route_operation_rec.attribute3 := null;
228: END IF;
229:
230: IF ( p_x_route_operation_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
231: p_x_route_operation_rec.attribute4 := null;
232: END IF;
233:
234: IF ( p_x_route_operation_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

Line 234: IF ( p_x_route_operation_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

230: IF ( p_x_route_operation_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
231: p_x_route_operation_rec.attribute4 := null;
232: END IF;
233:
234: IF ( p_x_route_operation_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
235: p_x_route_operation_rec.attribute5 := null;
236: END IF;
237:
238: IF ( p_x_route_operation_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

Line 238: IF ( p_x_route_operation_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

234: IF ( p_x_route_operation_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
235: p_x_route_operation_rec.attribute5 := null;
236: END IF;
237:
238: IF ( p_x_route_operation_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
239: p_x_route_operation_rec.attribute6 := null;
240: END IF;
241:
242: IF ( p_x_route_operation_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

Line 242: IF ( p_x_route_operation_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

238: IF ( p_x_route_operation_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
239: p_x_route_operation_rec.attribute6 := null;
240: END IF;
241:
242: IF ( p_x_route_operation_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
243: p_x_route_operation_rec.attribute7 := null;
244: END IF;
245:
246: IF ( p_x_route_operation_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

Line 246: IF ( p_x_route_operation_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

242: IF ( p_x_route_operation_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
243: p_x_route_operation_rec.attribute7 := null;
244: END IF;
245:
246: IF ( p_x_route_operation_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
247: p_x_route_operation_rec.attribute8 := null;
248: END IF;
249:
250: IF ( p_x_route_operation_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

Line 250: IF ( p_x_route_operation_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

246: IF ( p_x_route_operation_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
247: p_x_route_operation_rec.attribute8 := null;
248: END IF;
249:
250: IF ( p_x_route_operation_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
251: p_x_route_operation_rec.attribute9 := null;
252: END IF;
253:
254: IF ( p_x_route_operation_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

Line 254: IF ( p_x_route_operation_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

250: IF ( p_x_route_operation_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
251: p_x_route_operation_rec.attribute9 := null;
252: END IF;
253:
254: IF ( p_x_route_operation_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
255: p_x_route_operation_rec.attribute10 := null;
256: END IF;
257:
258: IF ( p_x_route_operation_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

Line 258: IF ( p_x_route_operation_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

254: IF ( p_x_route_operation_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
255: p_x_route_operation_rec.attribute10 := null;
256: END IF;
257:
258: IF ( p_x_route_operation_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
259: p_x_route_operation_rec.attribute11 := null;
260: END IF;
261:
262: IF ( p_x_route_operation_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

Line 262: IF ( p_x_route_operation_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

258: IF ( p_x_route_operation_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
259: p_x_route_operation_rec.attribute11 := null;
260: END IF;
261:
262: IF ( p_x_route_operation_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
263: p_x_route_operation_rec.attribute12 := null;
264: END IF;
265:
266: IF ( p_x_route_operation_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

Line 266: IF ( p_x_route_operation_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

262: IF ( p_x_route_operation_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
263: p_x_route_operation_rec.attribute12 := null;
264: END IF;
265:
266: IF ( p_x_route_operation_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
267: p_x_route_operation_rec.attribute13 := null;
268: END IF;
269:
270: IF ( p_x_route_operation_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

Line 270: IF ( p_x_route_operation_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

266: IF ( p_x_route_operation_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
267: p_x_route_operation_rec.attribute13 := null;
268: END IF;
269:
270: IF ( p_x_route_operation_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
271: p_x_route_operation_rec.attribute14 := null;
272: END IF;
273:
274: IF ( p_x_route_operation_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

Line 274: IF ( p_x_route_operation_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

270: IF ( p_x_route_operation_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
271: p_x_route_operation_rec.attribute14 := null;
272: END IF;
273:
274: IF ( p_x_route_operation_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
275: p_x_route_operation_rec.attribute15 := null;
276: END IF;
277:
278: END default_missing_attributes;

Line 346: RAISE FND_API.G_EXC_ERROR;

342: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RT_OPER_REC' );
343: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_operation_rec ) );
344: FND_MSG_PUB.add;
345: CLOSE get_old_rec;
346: RAISE FND_API.G_EXC_ERROR;
347: END IF;
348:
349: CLOSE get_old_rec;
350:

Line 353: IF ( p_x_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) THEN

349: CLOSE get_old_rec;
350:
351: -- Convert G_MISS values to NULL and NULL values to Old values
352:
353: IF ( p_x_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) THEN
354: p_x_route_operation_rec.concatenated_segments := null;
355: ELSIF ( p_x_route_operation_rec.concatenated_segments IS NULL ) THEN
356: p_x_route_operation_rec.concatenated_segments := l_old_route_operation_rec.concatenated_segments;
357: END IF;

Line 359: IF ( p_x_route_operation_rec.operation_id = FND_API.G_MISS_NUM ) THEN

355: ELSIF ( p_x_route_operation_rec.concatenated_segments IS NULL ) THEN
356: p_x_route_operation_rec.concatenated_segments := l_old_route_operation_rec.concatenated_segments;
357: END IF;
358:
359: IF ( p_x_route_operation_rec.operation_id = FND_API.G_MISS_NUM ) THEN
360: p_x_route_operation_rec.operation_id := null;
361: ELSIF ( p_x_route_operation_rec.operation_id IS NULL ) THEN
362: p_x_route_operation_rec.operation_id := l_old_route_operation_rec.operation_id;
363: END IF;

Line 365: IF ( p_x_route_operation_rec.step = FND_API.G_MISS_NUM ) THEN

361: ELSIF ( p_x_route_operation_rec.operation_id IS NULL ) THEN
362: p_x_route_operation_rec.operation_id := l_old_route_operation_rec.operation_id;
363: END IF;
364:
365: IF ( p_x_route_operation_rec.step = FND_API.G_MISS_NUM ) THEN
366: p_x_route_operation_rec.step := null;
367: ELSIF ( p_x_route_operation_rec.step IS NULL ) THEN
368: p_x_route_operation_rec.step := l_old_route_operation_rec.step;
369: END IF;

Line 371: IF ( p_x_route_operation_rec.check_point_flag = FND_API.G_MISS_CHAR ) THEN

367: ELSIF ( p_x_route_operation_rec.step IS NULL ) THEN
368: p_x_route_operation_rec.step := l_old_route_operation_rec.step;
369: END IF;
370:
371: IF ( p_x_route_operation_rec.check_point_flag = FND_API.G_MISS_CHAR ) THEN
372: p_x_route_operation_rec.check_point_flag := null;
373: ELSIF ( p_x_route_operation_rec.check_point_flag IS NULL ) THEN
374: p_x_route_operation_rec.check_point_flag := l_old_route_operation_rec.check_point_flag;
375: END IF;

Line 377: IF ( p_x_route_operation_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

373: ELSIF ( p_x_route_operation_rec.check_point_flag IS NULL ) THEN
374: p_x_route_operation_rec.check_point_flag := l_old_route_operation_rec.check_point_flag;
375: END IF;
376:
377: IF ( p_x_route_operation_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
378: p_x_route_operation_rec.attribute_category := null;
379: ELSIF ( p_x_route_operation_rec.attribute_category IS NULL ) THEN
380: p_x_route_operation_rec.attribute_category := l_old_route_operation_rec.attribute_category;
381: END IF;

Line 383: IF ( p_x_route_operation_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

379: ELSIF ( p_x_route_operation_rec.attribute_category IS NULL ) THEN
380: p_x_route_operation_rec.attribute_category := l_old_route_operation_rec.attribute_category;
381: END IF;
382:
383: IF ( p_x_route_operation_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
384: p_x_route_operation_rec.attribute1 := null;
385: ELSIF ( p_x_route_operation_rec.attribute1 IS NULL ) THEN
386: p_x_route_operation_rec.attribute1 := l_old_route_operation_rec.attribute1;
387: END IF;

Line 389: IF ( p_x_route_operation_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

385: ELSIF ( p_x_route_operation_rec.attribute1 IS NULL ) THEN
386: p_x_route_operation_rec.attribute1 := l_old_route_operation_rec.attribute1;
387: END IF;
388:
389: IF ( p_x_route_operation_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
390: p_x_route_operation_rec.attribute2 := null;
391: ELSIF ( p_x_route_operation_rec.attribute2 IS NULL ) THEN
392: p_x_route_operation_rec.attribute2 := l_old_route_operation_rec.attribute2;
393: END IF;

Line 395: IF ( p_x_route_operation_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

391: ELSIF ( p_x_route_operation_rec.attribute2 IS NULL ) THEN
392: p_x_route_operation_rec.attribute2 := l_old_route_operation_rec.attribute2;
393: END IF;
394:
395: IF ( p_x_route_operation_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
396: p_x_route_operation_rec.attribute3 := null;
397: ELSIF ( p_x_route_operation_rec.attribute3 IS NULL ) THEN
398: p_x_route_operation_rec.attribute3 := l_old_route_operation_rec.attribute3;
399: END IF;

Line 401: IF ( p_x_route_operation_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

397: ELSIF ( p_x_route_operation_rec.attribute3 IS NULL ) THEN
398: p_x_route_operation_rec.attribute3 := l_old_route_operation_rec.attribute3;
399: END IF;
400:
401: IF ( p_x_route_operation_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
402: p_x_route_operation_rec.attribute4 := null;
403: ELSIF ( p_x_route_operation_rec.attribute4 IS NULL ) THEN
404: p_x_route_operation_rec.attribute4 := l_old_route_operation_rec.attribute4;
405: END IF;

Line 407: IF ( p_x_route_operation_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

403: ELSIF ( p_x_route_operation_rec.attribute4 IS NULL ) THEN
404: p_x_route_operation_rec.attribute4 := l_old_route_operation_rec.attribute4;
405: END IF;
406:
407: IF ( p_x_route_operation_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
408: p_x_route_operation_rec.attribute5 := null;
409: ELSIF ( p_x_route_operation_rec.attribute5 IS NULL ) THEN
410: p_x_route_operation_rec.attribute5 := l_old_route_operation_rec.attribute5;
411: END IF;

Line 413: IF ( p_x_route_operation_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

409: ELSIF ( p_x_route_operation_rec.attribute5 IS NULL ) THEN
410: p_x_route_operation_rec.attribute5 := l_old_route_operation_rec.attribute5;
411: END IF;
412:
413: IF ( p_x_route_operation_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
414: p_x_route_operation_rec.attribute6 := null;
415: ELSIF ( p_x_route_operation_rec.attribute6 IS NULL ) THEN
416: p_x_route_operation_rec.attribute6 := l_old_route_operation_rec.attribute6;
417: END IF;

Line 419: IF ( p_x_route_operation_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

415: ELSIF ( p_x_route_operation_rec.attribute6 IS NULL ) THEN
416: p_x_route_operation_rec.attribute6 := l_old_route_operation_rec.attribute6;
417: END IF;
418:
419: IF ( p_x_route_operation_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
420: p_x_route_operation_rec.attribute7 := null;
421: ELSIF ( p_x_route_operation_rec.attribute7 IS NULL ) THEN
422: p_x_route_operation_rec.attribute7 := l_old_route_operation_rec.attribute7;
423: END IF;

Line 425: IF ( p_x_route_operation_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

421: ELSIF ( p_x_route_operation_rec.attribute7 IS NULL ) THEN
422: p_x_route_operation_rec.attribute7 := l_old_route_operation_rec.attribute7;
423: END IF;
424:
425: IF ( p_x_route_operation_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
426: p_x_route_operation_rec.attribute8 := null;
427: ELSIF ( p_x_route_operation_rec.attribute8 IS NULL ) THEN
428: p_x_route_operation_rec.attribute8 := l_old_route_operation_rec.attribute8;
429: END IF;

Line 431: IF ( p_x_route_operation_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

427: ELSIF ( p_x_route_operation_rec.attribute8 IS NULL ) THEN
428: p_x_route_operation_rec.attribute8 := l_old_route_operation_rec.attribute8;
429: END IF;
430:
431: IF ( p_x_route_operation_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
432: p_x_route_operation_rec.attribute9 := null;
433: ELSIF ( p_x_route_operation_rec.attribute9 IS NULL ) THEN
434: p_x_route_operation_rec.attribute9 := l_old_route_operation_rec.attribute9;
435: END IF;

Line 437: IF ( p_x_route_operation_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

433: ELSIF ( p_x_route_operation_rec.attribute9 IS NULL ) THEN
434: p_x_route_operation_rec.attribute9 := l_old_route_operation_rec.attribute9;
435: END IF;
436:
437: IF ( p_x_route_operation_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
438: p_x_route_operation_rec.attribute10 := null;
439: ELSIF ( p_x_route_operation_rec.attribute10 IS NULL ) THEN
440: p_x_route_operation_rec.attribute10 := l_old_route_operation_rec.attribute10;
441: END IF;

Line 443: IF ( p_x_route_operation_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

439: ELSIF ( p_x_route_operation_rec.attribute10 IS NULL ) THEN
440: p_x_route_operation_rec.attribute10 := l_old_route_operation_rec.attribute10;
441: END IF;
442:
443: IF ( p_x_route_operation_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
444: p_x_route_operation_rec.attribute11 := null;
445: ELSIF ( p_x_route_operation_rec.attribute11 IS NULL ) THEN
446: p_x_route_operation_rec.attribute11 := l_old_route_operation_rec.attribute11;
447: END IF;

Line 449: IF ( p_x_route_operation_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

445: ELSIF ( p_x_route_operation_rec.attribute11 IS NULL ) THEN
446: p_x_route_operation_rec.attribute11 := l_old_route_operation_rec.attribute11;
447: END IF;
448:
449: IF ( p_x_route_operation_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
450: p_x_route_operation_rec.attribute12 := null;
451: ELSIF ( p_x_route_operation_rec.attribute12 IS NULL ) THEN
452: p_x_route_operation_rec.attribute12 := l_old_route_operation_rec.attribute12;
453: END IF;

Line 455: IF ( p_x_route_operation_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

451: ELSIF ( p_x_route_operation_rec.attribute12 IS NULL ) THEN
452: p_x_route_operation_rec.attribute12 := l_old_route_operation_rec.attribute12;
453: END IF;
454:
455: IF ( p_x_route_operation_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
456: p_x_route_operation_rec.attribute13 := null;
457: ELSIF ( p_x_route_operation_rec.attribute13 IS NULL ) THEN
458: p_x_route_operation_rec.attribute13 := l_old_route_operation_rec.attribute13;
459: END IF;

Line 461: IF ( p_x_route_operation_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

457: ELSIF ( p_x_route_operation_rec.attribute13 IS NULL ) THEN
458: p_x_route_operation_rec.attribute13 := l_old_route_operation_rec.attribute13;
459: END IF;
460:
461: IF ( p_x_route_operation_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
462: p_x_route_operation_rec.attribute14 := null;
463: ELSIF ( p_x_route_operation_rec.attribute14 IS NULL ) THEN
464: p_x_route_operation_rec.attribute14 := l_old_route_operation_rec.attribute14;
465: END IF;

Line 467: IF ( p_x_route_operation_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

463: ELSIF ( p_x_route_operation_rec.attribute14 IS NULL ) THEN
464: p_x_route_operation_rec.attribute14 := l_old_route_operation_rec.attribute14;
465: END IF;
466:
467: IF ( p_x_route_operation_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
468: p_x_route_operation_rec.attribute15 := null;
469: ELSIF ( p_x_route_operation_rec.attribute15 IS NULL ) THEN
470: p_x_route_operation_rec.attribute15 := l_old_route_operation_rec.attribute15;
471: END IF;

Line 490: x_return_status := FND_API.G_RET_STS_SUCCESS;

486: -- Pekambar Added new Validation for VEE - USAF
487: l_dummy VARCHAR2(1);
488:
489: BEGIN
490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: -- Check if the Operation is NULL
493: IF ( ( p_route_operation_rec.dml_operation = 'C' AND
494: p_route_operation_rec.operation_id IS NULL AND

Line 497: p_route_operation_rec.operation_id = FND_API.G_MISS_NUM AND

493: IF ( ( p_route_operation_rec.dml_operation = 'C' AND
494: p_route_operation_rec.operation_id IS NULL AND
495: p_route_operation_rec.concatenated_segments IS NULL ) OR
496: ( p_route_operation_rec.dml_operation <> 'D' AND
497: p_route_operation_rec.operation_id = FND_API.G_MISS_NUM AND
498: p_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) ) THEN
499: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_NULL' );
500: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
501: FND_MSG_PUB.add;

Line 498: p_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) ) THEN

494: p_route_operation_rec.operation_id IS NULL AND
495: p_route_operation_rec.concatenated_segments IS NULL ) OR
496: ( p_route_operation_rec.dml_operation <> 'D' AND
497: p_route_operation_rec.operation_id = FND_API.G_MISS_NUM AND
498: p_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) ) THEN
499: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_NULL' );
500: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
501: FND_MSG_PUB.add;
502: --x_return_status := FND_API.G_RET_STS_ERROR;

Line 502: --x_return_status := FND_API.G_RET_STS_ERROR;

498: p_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) ) THEN
499: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_NULL' );
500: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
501: FND_MSG_PUB.add;
502: --x_return_status := FND_API.G_RET_STS_ERROR;
503: END IF;
504:
505: -- Check if the Step is NULL
506: -- Check if the Step Contains a positive value

Line 510: p_route_operation_rec.step = FND_API.G_MISS_NUM ) ) THEN

506: -- Check if the Step Contains a positive value
507: IF ( ( p_route_operation_rec.dml_operation = 'C' AND
508: p_route_operation_rec.step IS NULL ) OR
509: ( p_route_operation_rec.dml_operation <> 'D' AND
510: p_route_operation_rec.step = FND_API.G_MISS_NUM ) ) THEN
511: FND_MESSAGE.set_name( 'AHL','AHL_RM_STEP_NULL' );
512: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
513: FND_MSG_PUB.add;
514: --x_return_status := FND_API.G_RET_STS_ERROR;

Line 514: --x_return_status := FND_API.G_RET_STS_ERROR;

510: p_route_operation_rec.step = FND_API.G_MISS_NUM ) ) THEN
511: FND_MESSAGE.set_name( 'AHL','AHL_RM_STEP_NULL' );
512: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
513: FND_MSG_PUB.add;
514: --x_return_status := FND_API.G_RET_STS_ERROR;
515: ELSIF ( p_route_operation_rec.dml_operation <> 'D' AND
516: p_route_operation_rec.step <= 0 ) THEN
517: FND_MESSAGE.set_name( 'AHL','AHL_RM_STEP_LESS_ZERO' );
518: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );

Line 520: --x_return_status := FND_API.G_RET_STS_ERROR;

516: p_route_operation_rec.step <= 0 ) THEN
517: FND_MESSAGE.set_name( 'AHL','AHL_RM_STEP_LESS_ZERO' );
518: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
519: FND_MSG_PUB.add;
520: --x_return_status := FND_API.G_RET_STS_ERROR;
521: END IF;
522:
523:
524: IF ( p_route_operation_rec.step IS NOT NULL AND p_route_operation_rec.step <> FND_API.G_MISS_NUM ) THEN

Line 524: IF ( p_route_operation_rec.step IS NOT NULL AND p_route_operation_rec.step <> FND_API.G_MISS_NUM ) THEN

520: --x_return_status := FND_API.G_RET_STS_ERROR;
521: END IF;
522:
523:
524: IF ( p_route_operation_rec.step IS NOT NULL AND p_route_operation_rec.step <> FND_API.G_MISS_NUM ) THEN
525: BEGIN
526: SELECT TO_NUMBER( p_route_operation_rec.step, '999999999999999999999999999999' )
527: INTO l_step
528: FROM DUAL;

Line 534: -- x_return_status := FND_API.G_RET_STS_ERROR;

530: WHEN INVALID_NUMBER THEN
531: FND_MESSAGE.set_name( 'AHL','AHL_RM_STEP_DECIMAL' );
532: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
533: FND_MSG_PUB.add;
534: -- x_return_status := FND_API.G_RET_STS_ERROR;
535: END;
536: END IF;
537:
538: IF ( p_route_operation_rec.dml_operation = 'C' ) THEN

Line 544: p_route_operation_rec.route_operation_id = FND_API.G_MISS_NUM ) THEN

540: END IF;
541:
542: -- Check if the mandatory route_operation_id column contains a null value.
543: IF ( p_route_operation_rec.route_operation_id IS NULL OR
544: p_route_operation_rec.route_operation_id = FND_API.G_MISS_NUM ) THEN
545: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_OPER_ID_NULL' );
546: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
547: FND_MSG_PUB.add;
548: --x_return_status := FND_API.G_RET_STS_ERROR;

Line 548: --x_return_status := FND_API.G_RET_STS_ERROR;

544: p_route_operation_rec.route_operation_id = FND_API.G_MISS_NUM ) THEN
545: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_OPER_ID_NULL' );
546: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
547: FND_MSG_PUB.add;
548: --x_return_status := FND_API.G_RET_STS_ERROR;
549: END IF;
550:
551: -- Check if the mandatory Object Version Number column contains a null value.
552: IF ( p_route_operation_rec.object_version_number IS NULL OR

Line 553: p_route_operation_rec.object_version_number = FND_API.G_MISS_NUM ) THEN

549: END IF;
550:
551: -- Check if the mandatory Object Version Number column contains a null value.
552: IF ( p_route_operation_rec.object_version_number IS NULL OR
553: p_route_operation_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
554: FND_MESSAGE.set_name( 'AHL','AHL_RM_RTO_OBJ_VERSION_NULL' );
555: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
556: FND_MSG_PUB.add;
557: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 557: -- x_return_status := FND_API.G_RET_STS_ERROR;

553: p_route_operation_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
554: FND_MESSAGE.set_name( 'AHL','AHL_RM_RTO_OBJ_VERSION_NULL' );
555: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
556: FND_MSG_PUB.add;
557: -- x_return_status := FND_API.G_RET_STS_ERROR;
558: END IF;
559:
560:
561: END validate_attributes;

Line 586: x_return_status := FND_API.G_RET_STS_SUCCESS;

582: WHERE operation_id = c_operation_id
583: AND TRUNC( NVL( END_DATE_ACTIVE, SYSDATE + 1 ) ) > TRUNC( SYSDATE );
584:
585: BEGIN
586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587:
588: IF ( p_route_operation_rec.operation_id IS NOT NULL ) THEN
589:
590: -- Check if the Operation is Active

Line 607: --x_return_status := FND_API.G_RET_STS_ERROR;

603: END IF;
604:
605: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
606: FND_MSG_PUB.add;
607: --x_return_status := FND_API.G_RET_STS_ERROR;
608: END IF;
609:
610: CLOSE get_active_operation;
611:

Line 623: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

619: x_rt_time_span => l_rt_time_span,
620: x_op_max_res_duration => l_op_max_res_duration
621: );
622:
623: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
624: FND_MESSAGE.set_name( 'AHL', l_msg_data );
625: FND_MESSAGE.set_token( 'FIELD1', l_op_max_res_duration );
626: FND_MESSAGE.set_token( 'FIELD2', l_rt_time_span );
627: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );

Line 629: x_return_status := FND_API.G_RET_STS_ERROR;

625: FND_MESSAGE.set_token( 'FIELD1', l_op_max_res_duration );
626: FND_MESSAGE.set_token( 'FIELD2', l_rt_time_span );
627: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
628: FND_MSG_PUB.add;
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: END IF;
631:
632: END IF;
633:

Line 676: x_return_status := FND_API.G_RET_STS_ERROR;

672: l_step = l_prev_step ) THEN
673: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );
674: FND_MESSAGE.set_token( 'FIELD', to_char(l_step) );
675: FND_MSG_PUB.add;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: END IF;
678:
679: l_prev_step := l_step;
680: l_prev_operation := l_operation;

Line 691: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

687:
688: PROCEDURE process_route_operation_as
689: (
690: p_api_version IN NUMBER := 1.0,
691: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
692: p_commit IN VARCHAR2 := FND_API.G_FALSE,
693: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
694: p_default IN VARCHAR2 := FND_API.G_FALSE,
695: p_module_type IN VARCHAR2 := NULL,

Line 692: p_commit IN VARCHAR2 := FND_API.G_FALSE,

688: PROCEDURE process_route_operation_as
689: (
690: p_api_version IN NUMBER := 1.0,
691: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
692: p_commit IN VARCHAR2 := FND_API.G_FALSE,
693: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
694: p_default IN VARCHAR2 := FND_API.G_FALSE,
695: p_module_type IN VARCHAR2 := NULL,
696: x_return_status OUT NOCOPY VARCHAR2,

Line 693: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

689: (
690: p_api_version IN NUMBER := 1.0,
691: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
692: p_commit IN VARCHAR2 := FND_API.G_FALSE,
693: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
694: p_default IN VARCHAR2 := FND_API.G_FALSE,
695: p_module_type IN VARCHAR2 := NULL,
696: x_return_status OUT NOCOPY VARCHAR2,
697: x_msg_count OUT NOCOPY NUMBER,

Line 694: p_default IN VARCHAR2 := FND_API.G_FALSE,

690: p_api_version IN NUMBER := 1.0,
691: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
692: p_commit IN VARCHAR2 := FND_API.G_FALSE,
693: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
694: p_default IN VARCHAR2 := FND_API.G_FALSE,
695: p_module_type IN VARCHAR2 := NULL,
696: x_return_status OUT NOCOPY VARCHAR2,
697: x_msg_count OUT NOCOPY NUMBER,
698: x_msg_data OUT NOCOPY VARCHAR2,

Line 742: x_return_status := FND_API.G_RET_STS_SUCCESS;

738: l_route_no VARCHAR2(30);
739:
740: BEGIN
741: -- Initialize API return status to success
742: x_return_status := FND_API.G_RET_STS_SUCCESS;
743:
744: -- Standard Start of API savepoint
745: SAVEPOINT process_route_operation_pvt;
746:

Line 748: IF NOT FND_API.compatible_api_call

744: -- Standard Start of API savepoint
745: SAVEPOINT process_route_operation_pvt;
746:
747: -- Standard call to check for call compatibility.
748: IF NOT FND_API.compatible_api_call
749: (
750: l_api_version,
751: p_api_version,
752: G_API_NAME,

Line 756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

752: G_API_NAME,
753: G_PKG_NAME
754: )
755: THEN
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: END IF;
758:
759: -- Initialize message list if p_init_msg_list is set to TRUE.
760: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 760: IF FND_API.to_boolean( p_init_msg_list ) THEN

756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: END IF;
758:
759: -- Initialize message list if p_init_msg_list is set to TRUE.
760: IF FND_API.to_boolean( p_init_msg_list ) THEN
761: FND_MSG_PUB.initialize;
762: END IF;
763:
764: IF G_DEBUG = 'Y' THEN

Line 780: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

776: x_msg_data => x_msg_data
777: );
778:
779: -- If any severe error occurs, then, abort API.
780: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
781: RAISE FND_API.G_EXC_ERROR;
782: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784: END IF;

Line 781: RAISE FND_API.G_EXC_ERROR;

777: );
778:
779: -- If any severe error occurs, then, abort API.
780: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
781: RAISE FND_API.G_EXC_ERROR;
782: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784: END IF;
785:

Line 782: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

778:
779: -- If any severe error occurs, then, abort API.
780: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
781: RAISE FND_API.G_EXC_ERROR;
782: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784: END IF;
785:
786:

Line 783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

779: -- If any severe error occurs, then, abort API.
780: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
781: RAISE FND_API.G_EXC_ERROR;
782: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784: END IF;
785:
786:
787: -- Validate all the inputs of the API

Line 796: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

792: l_return_status -- OUT
793: );
794:
795: -- If any severe error occurs, then, abort API.
796: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
797: RAISE FND_API.G_EXC_ERROR;
798: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: END IF;

Line 797: RAISE FND_API.G_EXC_ERROR;

793: );
794:
795: -- If any severe error occurs, then, abort API.
796: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
797: RAISE FND_API.G_EXC_ERROR;
798: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801: --SNARKHED::Enigma Phase II --start

Line 798: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

794:
795: -- If any severe error occurs, then, abort API.
796: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
797: RAISE FND_API.G_EXC_ERROR;
798: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801: --SNARKHED::Enigma Phase II --start
802: --Operation association to automatic enigma Routes,can only be updated through reports sent by Enigma.

Line 799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

795: -- If any severe error occurs, then, abort API.
796: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
797: RAISE FND_API.G_EXC_ERROR;
798: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801: --SNARKHED::Enigma Phase II --start
802: --Operation association to automatic enigma Routes,can only be updated through reports sent by Enigma.
803: FOR i IN 1..p_x_route_operation_tbl.COUNT

Line 812: RAISE FND_API.G_EXC_ERROR;

808: IF (UPPER(l_route_source) = 'AUTOMATIC' AND UPPER(p_module_type) <> 'BPEL') THEN
809: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_ENG_ASS_ERR' );
810: FND_MESSAGE.set_token( 'FIELD', l_route_no );
811: FND_MSG_PUB.add;
812: RAISE FND_API.G_EXC_ERROR;
813: END IF;
814: END LOOP;
815: --End of changes by snarkhed
816:

Line 821: p_x_route_operation_tbl(i).operation_id = FND_API.G_MISS_NUM )

817: -- Code added by Balaji to get operation_id if it is not provided from
818: -- Operation_number and operation_revision.
819: FOR i IN 1..p_x_route_operation_tbl.count LOOP
820: IF ( p_x_route_operation_tbl(i).operation_id IS NULL OR
821: p_x_route_operation_tbl(i).operation_id = FND_API.G_MISS_NUM )
822: THEN
823: -- Function to convert Operation number, operation revision to id
824: AHL_RM_ROUTE_UTIL.Operation_Number_To_Id
825: (

Line 831: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

827: p_operation_revision => p_x_route_operation_tbl(i).revision_number,
828: x_operation_id => p_x_route_operation_tbl(i).operation_id,
829: x_return_status => x_return_status
830: );
831: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
833: fnd_log.string
834: (
835: fnd_log.level_statement,

Line 840: RAISE FND_API.G_EXC_ERROR;

836: 'ahl.plsql.'||g_pkg_name||'.'||g_api_name||':',
837: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
838: );
839: END IF;
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842: END IF;
843: END LOOP;
844:

Line 867: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

863: l_return_status -- OUT
864: );
865:
866: -- If any severe error occurs, then, abort API.
867: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
868: RAISE FND_API.G_EXC_ERROR;
869: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: END IF;

Line 868: RAISE FND_API.G_EXC_ERROR;

864: );
865:
866: -- If any severe error occurs, then, abort API.
867: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
868: RAISE FND_API.G_EXC_ERROR;
869: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: END IF;
872: END IF;

Line 869: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

865:
866: -- If any severe error occurs, then, abort API.
867: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
868: RAISE FND_API.G_EXC_ERROR;
869: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: END IF;
872: END IF;
873: END LOOP;

Line 870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

866: -- If any severe error occurs, then, abort API.
867: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
868: RAISE FND_API.G_EXC_ERROR;
869: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: END IF;
872: END IF;
873: END LOOP;
874:

Line 898: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

894: );
895:
896: /*
897: -- If any severe error occurs, then, abort API.
898: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
899: RAISE FND_API.G_EXC_ERROR;
900: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
902: END IF;

Line 899: RAISE FND_API.G_EXC_ERROR;

895:
896: /*
897: -- If any severe error occurs, then, abort API.
898: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
899: RAISE FND_API.G_EXC_ERROR;
900: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
902: END IF;
903: */

Line 900: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

896: /*
897: -- If any severe error occurs, then, abort API.
898: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
899: RAISE FND_API.G_EXC_ERROR;
900: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
902: END IF;
903: */
904: END LOOP;

Line 901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

897: -- If any severe error occurs, then, abort API.
898: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
899: RAISE FND_API.G_EXC_ERROR;
900: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
902: END IF;
903: */
904: END LOOP;
905: -- Check Error Message stack.

Line 909: RAISE FND_API.G_EXC_ERROR;

905: -- Check Error Message stack.
906: x_msg_count := FND_MSG_PUB.count_msg;
907: IF x_msg_count > 0
908: THEN
909: RAISE FND_API.G_EXC_ERROR;
910: END IF;
911:
912:
913: IF G_DEBUG = 'Y' THEN

Line 948: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

944: l_return_status -- OUT
945: );
946:
947: -- If any severe error occurs, then, abort API.
948: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
949: RAISE FND_API.G_EXC_ERROR;
950: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
952: END IF;

Line 949: RAISE FND_API.G_EXC_ERROR;

945: );
946:
947: -- If any severe error occurs, then, abort API.
948: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
949: RAISE FND_API.G_EXC_ERROR;
950: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
952: END IF;
953: END IF;

Line 950: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

946:
947: -- If any severe error occurs, then, abort API.
948: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
949: RAISE FND_API.G_EXC_ERROR;
950: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
952: END IF;
953: END IF;
954: END LOOP;

Line 951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

947: -- If any severe error occurs, then, abort API.
948: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
949: RAISE FND_API.G_EXC_ERROR;
950: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
952: END IF;
953: END IF;
954: END LOOP;
955:

Line 976: RAISE FND_API.G_EXC_ERROR;

972: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
973: l_msg_count := FND_MSG_PUB.count_msg;
974: IF l_msg_count > 0 THEN
975: x_msg_count := l_msg_count;
976: RAISE FND_API.G_EXC_ERROR;
977: END IF;
978:
979: -- Perform the DML statement directly.
980: FOR i IN 1..p_x_route_operation_tbl.count LOOP

Line 1103: -- x_return_status := FND_API.G_RET_STS_ERROR;

1099: IF ( SQL%ROWCOUNT = 0 ) THEN
1100: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1101: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_operation_tbl(i) ) );
1102: FND_MSG_PUB.add;
1103: -- x_return_status := FND_API.G_RET_STS_ERROR;
1104: END IF;
1105:
1106: --Pekambar (Praveen) Added for 12.2 - VEE -
1107: -- 6.Update Associated Dependencies

Line 1129: -- x_return_status := FND_API.G_RET_STS_ERROR;

1125: IF ( SQLCODE = -1 ) THEN
1126: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );
1127: FND_MESSAGE.set_token( 'FIELD', to_char(p_x_route_operation_tbl(i).step) );
1128: FND_MSG_PUB.add;
1129: -- x_return_status := FND_API.G_RET_STS_ERROR;
1130: END IF;
1131: END;
1132:
1133: ELSIF ( p_x_route_operation_tbl(i).dml_operation = 'D' ) THEN

Line 1144: --x_return_status := FND_API.G_RET_STS_ERROR;

1140: IF ( SQL%ROWCOUNT = 0 ) THEN
1141: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1142: FND_MESSAGE.set_token( 'RECORD', to_char(i) );
1143: FND_MSG_PUB.add;
1144: --x_return_status := FND_API.G_RET_STS_ERROR;
1145: END IF;
1146:
1147: --Pekambar (Praveen) Added for - VEE - USAF
1148: -- 6.Copy Associated Dependencies

Line 1168: RAISE FND_API.G_EXC_ERROR;

1164: IF ( duplicate_step%FOUND ) THEN
1165: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_DUP_STEP' );
1166: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_operation_tbl(i) ) );
1167: FND_MSG_PUB.add;
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;
1170: CLOSE duplicate_step;
1171: END IF;
1172:

Line 1183: RAISE FND_API.G_EXC_ERROR;

1179: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1180: l_msg_count := FND_MSG_PUB.count_msg;
1181: IF l_msg_count > 0 THEN
1182: x_msg_count := l_msg_count;
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;
1185:
1186: -- Perform cross records validations and duplicate records check
1187: /*

Line 1195: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1191: l_return_status -- OUT
1192: );
1193:
1194: -- If any severe error occurs, then, abort API.
1195: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1196: RAISE FND_API.G_EXC_ERROR;
1197: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1199: END IF;

Line 1196: RAISE FND_API.G_EXC_ERROR;

1192: );
1193:
1194: -- If any severe error occurs, then, abort API.
1195: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1196: RAISE FND_API.G_EXC_ERROR;
1197: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1199: END IF;
1200: */

Line 1197: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1193:
1194: -- If any severe error occurs, then, abort API.
1195: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1196: RAISE FND_API.G_EXC_ERROR;
1197: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1199: END IF;
1200: */
1201:

Line 1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1194: -- If any severe error occurs, then, abort API.
1195: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1196: RAISE FND_API.G_EXC_ERROR;
1197: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1199: END IF;
1200: */
1201:
1202: IF G_DEBUG = 'Y' THEN

Line 1207: IF FND_API.to_boolean( p_commit ) THEN

1203: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records ' || p_route_id );
1204: END IF;
1205:
1206: -- Perform the Commit (if requested)
1207: IF FND_API.to_boolean( p_commit ) THEN
1208: COMMIT WORK;
1209: END IF;
1210:
1211: -- Count and Get messages (optional)

Line 1214: p_encoded => FND_API.G_FALSE,

1210:
1211: -- Count and Get messages (optional)
1212: FND_MSG_PUB.count_and_get
1213: (
1214: p_encoded => FND_API.G_FALSE,
1215: p_count => x_msg_count,
1216: p_data => x_msg_data
1217: );
1218:

Line 1226: WHEN FND_API.G_EXC_ERROR THEN

1222: END IF;
1223:
1224: EXCEPTION
1225:
1226: WHEN FND_API.G_EXC_ERROR THEN
1227: ROLLBACK TO process_route_operation_pvt;
1228: x_return_status := FND_API.G_RET_STS_ERROR ;
1229: FND_MSG_PUB.count_and_get
1230: (

Line 1228: x_return_status := FND_API.G_RET_STS_ERROR ;

1224: EXCEPTION
1225:
1226: WHEN FND_API.G_EXC_ERROR THEN
1227: ROLLBACK TO process_route_operation_pvt;
1228: x_return_status := FND_API.G_RET_STS_ERROR ;
1229: FND_MSG_PUB.count_and_get
1230: (
1231: p_encoded => FND_API.G_FALSE,
1232: p_count => x_msg_count,

Line 1231: p_encoded => FND_API.G_FALSE,

1227: ROLLBACK TO process_route_operation_pvt;
1228: x_return_status := FND_API.G_RET_STS_ERROR ;
1229: FND_MSG_PUB.count_and_get
1230: (
1231: p_encoded => FND_API.G_FALSE,
1232: p_count => x_msg_count,
1233: p_data => x_msg_data
1234: );
1235:

Line 1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1237: IF G_DEBUG = 'Y' THEN
1238: AHL_DEBUG_PUB.disable_debug;
1239: END IF;
1240:
1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1242: ROLLBACK TO process_route_operation_pvt;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1244: FND_MSG_PUB.count_and_get
1245: (

Line 1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1239: END IF;
1240:
1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1242: ROLLBACK TO process_route_operation_pvt;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1244: FND_MSG_PUB.count_and_get
1245: (
1246: p_encoded => FND_API.G_FALSE,
1247: p_count => x_msg_count,

Line 1246: p_encoded => FND_API.G_FALSE,

1242: ROLLBACK TO process_route_operation_pvt;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1244: FND_MSG_PUB.count_and_get
1245: (
1246: p_encoded => FND_API.G_FALSE,
1247: p_count => x_msg_count,
1248: p_data => x_msg_data
1249: );
1250:

Line 1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1254: END IF;
1255:
1256: WHEN OTHERS THEN
1257: ROLLBACK TO process_route_operation_pvt;
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1259: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1260: THEN
1261: FND_MSG_PUB.add_exc_msg
1262: (

Line 1270: p_encoded => FND_API.G_FALSE,

1266: );
1267: END IF;
1268: FND_MSG_PUB.count_and_get
1269: (
1270: p_encoded => FND_API.G_FALSE,
1271: p_count => x_msg_count,
1272: p_data => x_msg_data
1273: );
1274: