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 486: x_return_status := FND_API.G_RET_STS_SUCCESS;

482: l_msg_data VARCHAR2(2000);
483: l_step NUMBER;
484:
485: BEGIN
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487:
488: -- Check if the Operation is NULL
489: IF ( ( p_route_operation_rec.dml_operation = 'C' AND
490: p_route_operation_rec.operation_id IS NULL AND

Line 493: p_route_operation_rec.operation_id = FND_API.G_MISS_NUM AND

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 581: x_return_status := FND_API.G_RET_STS_SUCCESS;

577: WHERE operation_id = c_operation_id
578: AND TRUNC( NVL( END_DATE_ACTIVE, SYSDATE + 1 ) ) > TRUNC( SYSDATE );
579:
580: BEGIN
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: IF ( p_route_operation_rec.operation_id IS NOT NULL ) THEN
584:
585: -- Check if the Operation is Active

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

598: END IF;
599:
600: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
601: FND_MSG_PUB.add;
602: --x_return_status := FND_API.G_RET_STS_ERROR;
603: END IF;
604:
605: CLOSE get_active_operation;
606:

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

614: x_rt_time_span => l_rt_time_span,
615: x_op_max_res_duration => l_op_max_res_duration
616: );
617:
618: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
619: FND_MESSAGE.set_name( 'AHL', l_msg_data );
620: FND_MESSAGE.set_token( 'FIELD1', l_op_max_res_duration );
621: FND_MESSAGE.set_token( 'FIELD2', l_rt_time_span );
622: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );

Line 624: x_return_status := FND_API.G_RET_STS_ERROR;

620: FND_MESSAGE.set_token( 'FIELD1', l_op_max_res_duration );
621: FND_MESSAGE.set_token( 'FIELD2', l_rt_time_span );
622: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
623: FND_MSG_PUB.add;
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: END IF;
626:
627: END IF;
628:

Line 671: x_return_status := FND_API.G_RET_STS_ERROR;

667: l_step = l_prev_step ) THEN
668: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );
669: FND_MESSAGE.set_token( 'FIELD', to_char(l_step) );
670: FND_MSG_PUB.add;
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: END IF;
673:
674: l_prev_step := l_step;
675: l_prev_operation := l_operation;

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

682:
683: PROCEDURE process_route_operation_as
684: (
685: p_api_version IN NUMBER := 1.0,
686: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
687: p_commit IN VARCHAR2 := FND_API.G_FALSE,
688: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
689: p_default IN VARCHAR2 := FND_API.G_FALSE,
690: p_module_type IN VARCHAR2 := NULL,

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

683: PROCEDURE process_route_operation_as
684: (
685: p_api_version IN NUMBER := 1.0,
686: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
687: p_commit IN VARCHAR2 := FND_API.G_FALSE,
688: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
689: p_default IN VARCHAR2 := FND_API.G_FALSE,
690: p_module_type IN VARCHAR2 := NULL,
691: x_return_status OUT NOCOPY VARCHAR2,

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

684: (
685: p_api_version IN NUMBER := 1.0,
686: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
687: p_commit IN VARCHAR2 := FND_API.G_FALSE,
688: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
689: p_default IN VARCHAR2 := FND_API.G_FALSE,
690: p_module_type IN VARCHAR2 := NULL,
691: x_return_status OUT NOCOPY VARCHAR2,
692: x_msg_count OUT NOCOPY NUMBER,

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

685: p_api_version IN NUMBER := 1.0,
686: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
687: p_commit IN VARCHAR2 := FND_API.G_FALSE,
688: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
689: p_default IN VARCHAR2 := FND_API.G_FALSE,
690: p_module_type IN VARCHAR2 := NULL,
691: x_return_status OUT NOCOPY VARCHAR2,
692: x_msg_count OUT NOCOPY NUMBER,
693: x_msg_data OUT NOCOPY VARCHAR2,

Line 715: x_return_status := FND_API.G_RET_STS_SUCCESS;

711: l_route_status VARCHAR2(30);
712:
713: BEGIN
714: -- Initialize API return status to success
715: x_return_status := FND_API.G_RET_STS_SUCCESS;
716:
717: -- Standard Start of API savepoint
718: SAVEPOINT process_route_operation_pvt;
719:

Line 721: IF NOT FND_API.compatible_api_call

717: -- Standard Start of API savepoint
718: SAVEPOINT process_route_operation_pvt;
719:
720: -- Standard call to check for call compatibility.
721: IF NOT FND_API.compatible_api_call
722: (
723: l_api_version,
724: p_api_version,
725: G_API_NAME,

Line 729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

725: G_API_NAME,
726: G_PKG_NAME
727: )
728: THEN
729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;
731:
732: -- Initialize message list if p_init_msg_list is set to TRUE.
733: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 733: IF FND_API.to_boolean( p_init_msg_list ) THEN

729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;
731:
732: -- Initialize message list if p_init_msg_list is set to TRUE.
733: IF FND_API.to_boolean( p_init_msg_list ) THEN
734: FND_MSG_PUB.initialize;
735: END IF;
736:
737: IF G_DEBUG = 'Y' THEN

Line 753: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

749: x_msg_data => x_msg_data
750: );
751:
752: -- If any severe error occurs, then, abort API.
753: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
754: RAISE FND_API.G_EXC_ERROR;
755: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: END IF;

Line 754: RAISE FND_API.G_EXC_ERROR;

750: );
751:
752: -- If any severe error occurs, then, abort API.
753: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
754: RAISE FND_API.G_EXC_ERROR;
755: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: END IF;
758:

Line 755: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

751:
752: -- If any severe error occurs, then, abort API.
753: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
754: RAISE FND_API.G_EXC_ERROR;
755: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: END IF;
758:
759:

Line 756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

752: -- If any severe error occurs, then, abort API.
753: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
754: RAISE FND_API.G_EXC_ERROR;
755: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: END IF;
758:
759:
760: -- Validate all the inputs of the API

Line 769: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

765: l_return_status -- OUT
766: );
767:
768: -- If any severe error occurs, then, abort API.
769: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
770: RAISE FND_API.G_EXC_ERROR;
771: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: END IF;

Line 770: RAISE FND_API.G_EXC_ERROR;

766: );
767:
768: -- If any severe error occurs, then, abort API.
769: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
770: RAISE FND_API.G_EXC_ERROR;
771: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: END IF;
774:

Line 771: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

767:
768: -- If any severe error occurs, then, abort API.
769: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
770: RAISE FND_API.G_EXC_ERROR;
771: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: END IF;
774:
775: -- Code added by Balaji to get operation_id if it is not provided from

Line 772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

768: -- If any severe error occurs, then, abort API.
769: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
770: RAISE FND_API.G_EXC_ERROR;
771: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: END IF;
774:
775: -- Code added by Balaji to get operation_id if it is not provided from
776: -- Operation_number and operation_revision.

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

775: -- Code added by Balaji to get operation_id if it is not provided from
776: -- Operation_number and operation_revision.
777: FOR i IN 1..p_x_route_operation_tbl.count LOOP
778: IF ( p_x_route_operation_tbl(i).operation_id IS NULL OR
779: p_x_route_operation_tbl(i).operation_id = FND_API.G_MISS_NUM )
780: THEN
781: -- Function to convert Operation number, operation revision to id
782: AHL_RM_ROUTE_UTIL.Operation_Number_To_Id
783: (

Line 789: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

785: p_operation_revision => p_x_route_operation_tbl(i).revision_number,
786: x_operation_id => p_x_route_operation_tbl(i).operation_id,
787: x_return_status => x_return_status
788: );
789: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
791: fnd_log.string
792: (
793: fnd_log.level_statement,

Line 798: RAISE FND_API.G_EXC_ERROR;

794: 'ahl.plsql.'||g_pkg_name||'.'||g_api_name||':',
795: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
796: );
797: END IF;
798: RAISE FND_API.G_EXC_ERROR;
799: END IF;
800: END IF;
801: END LOOP;
802:

Line 825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

821: l_return_status -- OUT
822: );
823:
824: -- If any severe error occurs, then, abort API.
825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;

Line 826: RAISE FND_API.G_EXC_ERROR;

822: );
823:
824: -- If any severe error occurs, then, abort API.
825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830: END IF;

Line 827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

823:
824: -- If any severe error occurs, then, abort API.
825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830: END IF;
831: END LOOP;

Line 828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

824: -- If any severe error occurs, then, abort API.
825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830: END IF;
831: END LOOP;
832:

Line 854: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

850: );
851:
852: /*
853: -- If any severe error occurs, then, abort API.
854: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
855: RAISE FND_API.G_EXC_ERROR;
856: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858: END IF;

Line 855: RAISE FND_API.G_EXC_ERROR;

851:
852: /*
853: -- If any severe error occurs, then, abort API.
854: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
855: RAISE FND_API.G_EXC_ERROR;
856: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858: END IF;
859: */

Line 856: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

852: /*
853: -- If any severe error occurs, then, abort API.
854: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
855: RAISE FND_API.G_EXC_ERROR;
856: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858: END IF;
859: */
860: END LOOP;

Line 857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

853: -- If any severe error occurs, then, abort API.
854: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
855: RAISE FND_API.G_EXC_ERROR;
856: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858: END IF;
859: */
860: END LOOP;
861: -- Check Error Message stack.

Line 865: RAISE FND_API.G_EXC_ERROR;

861: -- Check Error Message stack.
862: x_msg_count := FND_MSG_PUB.count_msg;
863: IF x_msg_count > 0
864: THEN
865: RAISE FND_API.G_EXC_ERROR;
866: END IF;
867:
868:
869: IF G_DEBUG = 'Y' THEN

Line 904: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

900: l_return_status -- OUT
901: );
902:
903: -- If any severe error occurs, then, abort API.
904: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
905: RAISE FND_API.G_EXC_ERROR;
906: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: END IF;

Line 905: RAISE FND_API.G_EXC_ERROR;

901: );
902:
903: -- If any severe error occurs, then, abort API.
904: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
905: RAISE FND_API.G_EXC_ERROR;
906: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: END IF;
909: END IF;

Line 906: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

902:
903: -- If any severe error occurs, then, abort API.
904: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
905: RAISE FND_API.G_EXC_ERROR;
906: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: END IF;
909: END IF;
910: END LOOP;

Line 907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

903: -- If any severe error occurs, then, abort API.
904: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
905: RAISE FND_API.G_EXC_ERROR;
906: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: END IF;
909: END IF;
910: END LOOP;
911:

Line 932: RAISE FND_API.G_EXC_ERROR;

928: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
929: l_msg_count := FND_MSG_PUB.count_msg;
930: IF l_msg_count > 0 THEN
931: x_msg_count := l_msg_count;
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934:
935: -- Perform the DML statement directly.
936: FOR i IN 1..p_x_route_operation_tbl.count LOOP

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

1055: IF ( SQL%ROWCOUNT = 0 ) THEN
1056: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1057: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_operation_tbl(i) ) );
1058: FND_MSG_PUB.add;
1059: -- x_return_status := FND_API.G_RET_STS_ERROR;
1060: END IF;
1061:
1062: -- Set OUT values
1063: p_x_route_operation_tbl(i).object_version_number := p_x_route_operation_tbl(i).object_version_number + 1;

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

1067: IF ( SQLCODE = -1 ) THEN
1068: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );
1069: FND_MESSAGE.set_token( 'FIELD', to_char(p_x_route_operation_tbl(i).step) );
1070: FND_MSG_PUB.add;
1071: -- x_return_status := FND_API.G_RET_STS_ERROR;
1072: END IF;
1073: END;
1074:
1075: ELSIF ( p_x_route_operation_tbl(i).dml_operation = 'D' ) THEN

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

1082: IF ( SQL%ROWCOUNT = 0 ) THEN
1083: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1084: FND_MESSAGE.set_token( 'RECORD', to_char(i) );
1085: FND_MSG_PUB.add;
1086: --x_return_status := FND_API.G_RET_STS_ERROR;
1087: END IF;
1088: END IF;
1089: END LOOP;
1090:

Line 1099: RAISE FND_API.G_EXC_ERROR;

1095: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1096: l_msg_count := FND_MSG_PUB.count_msg;
1097: IF l_msg_count > 0 THEN
1098: x_msg_count := l_msg_count;
1099: RAISE FND_API.G_EXC_ERROR;
1100: END IF;
1101:
1102: -- Perform cross records validations and duplicate records check
1103: /*

Line 1111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1107: l_return_status -- OUT
1108: );
1109:
1110: -- If any severe error occurs, then, abort API.
1111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1112: RAISE FND_API.G_EXC_ERROR;
1113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1115: END IF;

Line 1112: RAISE FND_API.G_EXC_ERROR;

1108: );
1109:
1110: -- If any severe error occurs, then, abort API.
1111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1112: RAISE FND_API.G_EXC_ERROR;
1113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1115: END IF;
1116: */

Line 1113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1109:
1110: -- If any severe error occurs, then, abort API.
1111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1112: RAISE FND_API.G_EXC_ERROR;
1113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1115: END IF;
1116: */
1117:

Line 1114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1110: -- If any severe error occurs, then, abort API.
1111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1112: RAISE FND_API.G_EXC_ERROR;
1113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1115: END IF;
1116: */
1117:
1118: IF G_DEBUG = 'Y' THEN

Line 1123: IF FND_API.to_boolean( p_commit ) THEN

1119: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records ' || p_route_id );
1120: END IF;
1121:
1122: -- Perform the Commit (if requested)
1123: IF FND_API.to_boolean( p_commit ) THEN
1124: COMMIT WORK;
1125: END IF;
1126:
1127: -- Count and Get messages (optional)

Line 1130: p_encoded => FND_API.G_FALSE,

1126:
1127: -- Count and Get messages (optional)
1128: FND_MSG_PUB.count_and_get
1129: (
1130: p_encoded => FND_API.G_FALSE,
1131: p_count => x_msg_count,
1132: p_data => x_msg_data
1133: );
1134:

Line 1142: WHEN FND_API.G_EXC_ERROR THEN

1138: END IF;
1139:
1140: EXCEPTION
1141:
1142: WHEN FND_API.G_EXC_ERROR THEN
1143: ROLLBACK TO process_route_operation_pvt;
1144: x_return_status := FND_API.G_RET_STS_ERROR ;
1145: FND_MSG_PUB.count_and_get
1146: (

Line 1144: x_return_status := FND_API.G_RET_STS_ERROR ;

1140: EXCEPTION
1141:
1142: WHEN FND_API.G_EXC_ERROR THEN
1143: ROLLBACK TO process_route_operation_pvt;
1144: x_return_status := FND_API.G_RET_STS_ERROR ;
1145: FND_MSG_PUB.count_and_get
1146: (
1147: p_encoded => FND_API.G_FALSE,
1148: p_count => x_msg_count,

Line 1147: p_encoded => FND_API.G_FALSE,

1143: ROLLBACK TO process_route_operation_pvt;
1144: x_return_status := FND_API.G_RET_STS_ERROR ;
1145: FND_MSG_PUB.count_and_get
1146: (
1147: p_encoded => FND_API.G_FALSE,
1148: p_count => x_msg_count,
1149: p_data => x_msg_data
1150: );
1151:

Line 1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1153: IF G_DEBUG = 'Y' THEN
1154: AHL_DEBUG_PUB.disable_debug;
1155: END IF;
1156:
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: ROLLBACK TO process_route_operation_pvt;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1160: FND_MSG_PUB.count_and_get
1161: (

Line 1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1155: END IF;
1156:
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: ROLLBACK TO process_route_operation_pvt;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1160: FND_MSG_PUB.count_and_get
1161: (
1162: p_encoded => FND_API.G_FALSE,
1163: p_count => x_msg_count,

Line 1162: p_encoded => FND_API.G_FALSE,

1158: ROLLBACK TO process_route_operation_pvt;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1160: FND_MSG_PUB.count_and_get
1161: (
1162: p_encoded => FND_API.G_FALSE,
1163: p_count => x_msg_count,
1164: p_data => x_msg_data
1165: );
1166:

Line 1174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1170: END IF;
1171:
1172: WHEN OTHERS THEN
1173: ROLLBACK TO process_route_operation_pvt;
1174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1175: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1176: THEN
1177: FND_MSG_PUB.add_exc_msg
1178: (

Line 1186: p_encoded => FND_API.G_FALSE,

1182: );
1183: END IF;
1184: FND_MSG_PUB.count_and_get
1185: (
1186: p_encoded => FND_API.G_FALSE,
1187: p_count => x_msg_count,
1188: p_data => x_msg_data
1189: );
1190: