eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RM_RT_OP_DEP_PVT dependencies on FND_API

Line 43: IF (p_x_rt_oper_dep_tbl(i).from_rt_op_id= FND_API.G_MISS_NUM OR

39: OPEN get_dep_details(p_x_rt_oper_dep_tbl(i).rt_op_dependency_id);
40: FETCH get_dep_details INTO l_opdep_rec;
41: CLOSE get_dep_details;
42:
43: IF (p_x_rt_oper_dep_tbl(i).from_rt_op_id= FND_API.G_MISS_NUM OR
44: p_x_rt_oper_dep_tbl(i).from_rt_op_id IS NULL)
45: THEN
46: p_x_rt_oper_dep_tbl(i).from_rt_op_id:=l_opdep_rec.from_rt_op_id;
47: END IF;

Line 49: IF (p_x_rt_oper_dep_tbl(i).from_op_step= FND_API.G_MISS_NUM OR

45: THEN
46: p_x_rt_oper_dep_tbl(i).from_rt_op_id:=l_opdep_rec.from_rt_op_id;
47: END IF;
48:
49: IF (p_x_rt_oper_dep_tbl(i).from_op_step= FND_API.G_MISS_NUM OR
50: p_x_rt_oper_dep_tbl(i).from_op_step IS NULL)
51: THEN
52: p_x_rt_oper_dep_tbl(i).from_op_step:=l_opdep_rec.from_op_step;
53: END IF;

Line 55: IF (p_x_rt_oper_dep_tbl(i).dependency_code= FND_API.G_MISS_CHAR

51: THEN
52: p_x_rt_oper_dep_tbl(i).from_op_step:=l_opdep_rec.from_op_step;
53: END IF;
54:
55: IF (p_x_rt_oper_dep_tbl(i).dependency_code= FND_API.G_MISS_CHAR
56: OR p_x_rt_oper_dep_tbl(i).dependency_code IS NULL)
57: THEN
58: p_x_rt_oper_dep_tbl(i).dependency_code:=l_opdep_rec.dependency_code;
59: END IF;

Line 61: IF (p_x_rt_oper_dep_tbl(i).to_rt_op_id= FND_API.G_MISS_NUM OR

57: THEN
58: p_x_rt_oper_dep_tbl(i).dependency_code:=l_opdep_rec.dependency_code;
59: END IF;
60:
61: IF (p_x_rt_oper_dep_tbl(i).to_rt_op_id= FND_API.G_MISS_NUM OR
62: p_x_rt_oper_dep_tbl(i).to_rt_op_id IS NULL)
63: THEN
64: p_x_rt_oper_dep_tbl(i).to_rt_op_id:=l_opdep_rec.to_rt_op_id;
65: END IF;

Line 67: IF (p_x_rt_oper_dep_tbl(i).to_op_step= FND_API.G_MISS_NUM OR

63: THEN
64: p_x_rt_oper_dep_tbl(i).to_rt_op_id:=l_opdep_rec.to_rt_op_id;
65: END IF;
66:
67: IF (p_x_rt_oper_dep_tbl(i).to_op_step= FND_API.G_MISS_NUM OR
68: p_x_rt_oper_dep_tbl(i).to_op_step IS NULL)
69: THEN
70: p_x_rt_oper_dep_tbl(i).to_op_step:=l_opdep_rec.to_op_step;
71: END IF;

Line 73: IF (p_x_rt_oper_dep_tbl(i).security_group_id= FND_API.G_MISS_NUM)

69: THEN
70: p_x_rt_oper_dep_tbl(i).to_op_step:=l_opdep_rec.to_op_step;
71: END IF;
72:
73: IF (p_x_rt_oper_dep_tbl(i).security_group_id= FND_API.G_MISS_NUM)
74: THEN
75: p_x_rt_oper_dep_tbl(i).security_group_id:=NULL;
76: ELSIF (p_x_rt_oper_dep_tbl(i).security_group_id IS NULL)
77: THEN

Line 81: IF (p_x_rt_oper_dep_tbl(i).attribute_category= FND_API.G_MISS_CHAR)

77: THEN
78: p_x_rt_oper_dep_tbl(i).security_group_id:=l_opdep_rec.security_group_id;
79: END IF;
80:
81: IF (p_x_rt_oper_dep_tbl(i).attribute_category= FND_API.G_MISS_CHAR)
82: THEN
83: p_x_rt_oper_dep_tbl(i).attribute_category:=NULL;
84: ELSIF (p_x_rt_oper_dep_tbl(i).attribute_category IS NULL)
85: THEN

Line 89: IF p_x_rt_oper_dep_tbl(i).attribute1= FND_API.G_MISS_CHAR

85: THEN
86: p_x_rt_oper_dep_tbl(i).attribute_category:=l_opdep_rec.attribute_category;
87: END IF;
88:
89: IF p_x_rt_oper_dep_tbl(i).attribute1= FND_API.G_MISS_CHAR
90: THEN
91: p_x_rt_oper_dep_tbl(i).attribute1:=NULL;
92: ELSIF p_x_rt_oper_dep_tbl(i).attribute1 IS NULL
93: THEN

Line 97: IF p_x_rt_oper_dep_tbl(i).attribute2= FND_API.G_MISS_CHAR

93: THEN
94: p_x_rt_oper_dep_tbl(i).attribute1:=l_opdep_rec.attribute1;
95: END IF;
96:
97: IF p_x_rt_oper_dep_tbl(i).attribute2= FND_API.G_MISS_CHAR
98: THEN
99: p_x_rt_oper_dep_tbl(i).attribute2:=NULL;
100: ELSIF p_x_rt_oper_dep_tbl(i).attribute2 IS NULL
101: THEN

Line 105: IF p_x_rt_oper_dep_tbl(i).attribute3= FND_API.G_MISS_CHAR

101: THEN
102: p_x_rt_oper_dep_tbl(i).attribute2:=l_opdep_rec.attribute2;
103: END IF;
104:
105: IF p_x_rt_oper_dep_tbl(i).attribute3= FND_API.G_MISS_CHAR
106: THEN
107: p_x_rt_oper_dep_tbl(i).attribute3:=NULL;
108: ELSIF p_x_rt_oper_dep_tbl(i).attribute3 IS NULL
109: THEN

Line 113: IF p_x_rt_oper_dep_tbl(i).attribute4= FND_API.G_MISS_CHAR

109: THEN
110: p_x_rt_oper_dep_tbl(i).attribute3:=l_opdep_rec.attribute3;
111: END IF;
112:
113: IF p_x_rt_oper_dep_tbl(i).attribute4= FND_API.G_MISS_CHAR
114: THEN
115: p_x_rt_oper_dep_tbl(i).attribute4:=NULL;
116: ELSIF p_x_rt_oper_dep_tbl(i).attribute4 IS NULL
117: THEN

Line 121: IF p_x_rt_oper_dep_tbl(i).attribute5= FND_API.G_MISS_CHAR

117: THEN
118: p_x_rt_oper_dep_tbl(i).attribute4:=l_opdep_rec.attribute4;
119: END IF;
120:
121: IF p_x_rt_oper_dep_tbl(i).attribute5= FND_API.G_MISS_CHAR
122: THEN
123: p_x_rt_oper_dep_tbl(i).attribute5:=NULL;
124: ELSIF p_x_rt_oper_dep_tbl(i).attribute5 IS NULL
125: THEN

Line 129: IF p_x_rt_oper_dep_tbl(i).attribute6= FND_API.G_MISS_CHAR

125: THEN
126: p_x_rt_oper_dep_tbl(i).attribute5:=l_opdep_rec.attribute5;
127: END IF;
128:
129: IF p_x_rt_oper_dep_tbl(i).attribute6= FND_API.G_MISS_CHAR
130: THEN
131: p_x_rt_oper_dep_tbl(i).attribute6:=NULL;
132: ELSIF p_x_rt_oper_dep_tbl(i).attribute6 IS NULL
133: THEN

Line 137: IF p_x_rt_oper_dep_tbl(i).attribute7= FND_API.G_MISS_CHAR

133: THEN
134: p_x_rt_oper_dep_tbl(i).attribute6:=l_opdep_rec.attribute6;
135: END IF;
136:
137: IF p_x_rt_oper_dep_tbl(i).attribute7= FND_API.G_MISS_CHAR
138: THEN
139: p_x_rt_oper_dep_tbl(i).attribute7:=NULL;
140: ELSIF p_x_rt_oper_dep_tbl(i).attribute7 IS NULL
141: THEN

Line 145: IF p_x_rt_oper_dep_tbl(i).attribute8= FND_API.G_MISS_CHAR

141: THEN
142: p_x_rt_oper_dep_tbl(i).attribute7:=l_opdep_rec.attribute7;
143: END IF;
144:
145: IF p_x_rt_oper_dep_tbl(i).attribute8= FND_API.G_MISS_CHAR
146: THEN
147: p_x_rt_oper_dep_tbl(i).attribute8:=NULL;
148: ELSIF p_x_rt_oper_dep_tbl(i).attribute8 IS NULL
149: THEN

Line 153: IF p_x_rt_oper_dep_tbl(i).attribute9= FND_API.G_MISS_CHAR

149: THEN
150: p_x_rt_oper_dep_tbl(i).attribute8:=l_opdep_rec.attribute8;
151: END IF;
152:
153: IF p_x_rt_oper_dep_tbl(i).attribute9= FND_API.G_MISS_CHAR
154: THEN
155: p_x_rt_oper_dep_tbl(i).attribute9:=NULL;
156: ELSIF p_x_rt_oper_dep_tbl(i).attribute9 IS NULL
157: THEN

Line 161: IF p_x_rt_oper_dep_tbl(i).attribute10= FND_API.G_MISS_CHAR

157: THEN
158: p_x_rt_oper_dep_tbl(i).attribute9:=l_opdep_rec.attribute9;
159: END IF;
160:
161: IF p_x_rt_oper_dep_tbl(i).attribute10= FND_API.G_MISS_CHAR
162: THEN
163: p_x_rt_oper_dep_tbl(i).attribute10:=NULL;
164: ELSIF p_x_rt_oper_dep_tbl(i).attribute10 IS NULL
165: THEN

Line 169: IF p_x_rt_oper_dep_tbl(i).attribute11= FND_API.G_MISS_CHAR

165: THEN
166: p_x_rt_oper_dep_tbl(i).attribute10:=l_opdep_rec.attribute10;
167: END IF;
168:
169: IF p_x_rt_oper_dep_tbl(i).attribute11= FND_API.G_MISS_CHAR
170: THEN
171: p_x_rt_oper_dep_tbl(i).attribute11:=NULL;
172: ELSIF p_x_rt_oper_dep_tbl(i).attribute11 IS NULL
173: THEN

Line 177: IF p_x_rt_oper_dep_tbl(i).attribute12= FND_API.G_MISS_CHAR

173: THEN
174: p_x_rt_oper_dep_tbl(i).attribute11:=l_opdep_rec.attribute11;
175: END IF;
176:
177: IF p_x_rt_oper_dep_tbl(i).attribute12= FND_API.G_MISS_CHAR
178: THEN
179: p_x_rt_oper_dep_tbl(i).attribute12:=NULL;
180: ELSIF p_x_rt_oper_dep_tbl(i).attribute12 IS NULL
181: THEN

Line 185: IF p_x_rt_oper_dep_tbl(i).attribute13= FND_API.G_MISS_CHAR

181: THEN
182: p_x_rt_oper_dep_tbl(i).attribute12:=l_opdep_rec.attribute12;
183: END IF;
184:
185: IF p_x_rt_oper_dep_tbl(i).attribute13= FND_API.G_MISS_CHAR
186: THEN
187: p_x_rt_oper_dep_tbl(i).attribute13:=NULL;
188: ELSIF p_x_rt_oper_dep_tbl(i).attribute13 IS NULL
189: THEN

Line 193: IF p_x_rt_oper_dep_tbl(i).attribute14= FND_API.G_MISS_CHAR

189: THEN
190: p_x_rt_oper_dep_tbl(i).attribute13:=l_opdep_rec.attribute13;
191: END IF;
192:
193: IF p_x_rt_oper_dep_tbl(i).attribute14= FND_API.G_MISS_CHAR
194: THEN
195: p_x_rt_oper_dep_tbl(i).attribute14:=NULL;
196: ELSIF p_x_rt_oper_dep_tbl(i).attribute14 IS NULL
197: THEN

Line 201: IF p_x_rt_oper_dep_tbl(i).attribute15= FND_API.G_MISS_CHAR

197: THEN
198: p_x_rt_oper_dep_tbl(i).attribute14:=l_opdep_rec.attribute14;
199: END IF;
200:
201: IF p_x_rt_oper_dep_tbl(i).attribute15= FND_API.G_MISS_CHAR
202: THEN
203: p_x_rt_oper_dep_tbl(i).attribute15:=NULL;
204: ELSIF p_x_rt_oper_dep_tbl(i).attribute15 IS NULL
205: THEN

Line 212: IF p_x_rt_oper_dep_tbl(i).security_group_id= FND_API.G_MISS_NUM

208:
209: ELSIF( p_x_rt_oper_dep_tbl(i).dml_operation = 'C' )
210: THEN
211:
212: IF p_x_rt_oper_dep_tbl(i).security_group_id= FND_API.G_MISS_NUM
213: THEN
214: p_x_rt_oper_dep_tbl(i).security_group_id:=NULL;
215: END IF;
216:

Line 217: IF p_x_rt_oper_dep_tbl(i).attribute_category= FND_API.G_MISS_CHAR

213: THEN
214: p_x_rt_oper_dep_tbl(i).security_group_id:=NULL;
215: END IF;
216:
217: IF p_x_rt_oper_dep_tbl(i).attribute_category= FND_API.G_MISS_CHAR
218: THEN
219: p_x_rt_oper_dep_tbl(i).attribute_category:=NULL;
220: END IF;
221:

Line 222: IF p_x_rt_oper_dep_tbl(i).attribute1= FND_API.G_MISS_CHAR

218: THEN
219: p_x_rt_oper_dep_tbl(i).attribute_category:=NULL;
220: END IF;
221:
222: IF p_x_rt_oper_dep_tbl(i).attribute1= FND_API.G_MISS_CHAR
223: THEN
224: p_x_rt_oper_dep_tbl(i).attribute1:=NULL;
225: END IF;
226:

Line 227: IF p_x_rt_oper_dep_tbl(i).attribute2= FND_API.G_MISS_CHAR

223: THEN
224: p_x_rt_oper_dep_tbl(i).attribute1:=NULL;
225: END IF;
226:
227: IF p_x_rt_oper_dep_tbl(i).attribute2= FND_API.G_MISS_CHAR
228: THEN
229: p_x_rt_oper_dep_tbl(i).attribute2:=NULL;
230: END IF;
231:

Line 232: IF p_x_rt_oper_dep_tbl(i).attribute3= FND_API.G_MISS_CHAR

228: THEN
229: p_x_rt_oper_dep_tbl(i).attribute2:=NULL;
230: END IF;
231:
232: IF p_x_rt_oper_dep_tbl(i).attribute3= FND_API.G_MISS_CHAR
233: THEN
234: p_x_rt_oper_dep_tbl(i).attribute3:=NULL;
235: END IF;
236:

Line 237: IF p_x_rt_oper_dep_tbl(i).attribute4= FND_API.G_MISS_CHAR

233: THEN
234: p_x_rt_oper_dep_tbl(i).attribute3:=NULL;
235: END IF;
236:
237: IF p_x_rt_oper_dep_tbl(i).attribute4= FND_API.G_MISS_CHAR
238: THEN
239: p_x_rt_oper_dep_tbl(i).attribute4:=NULL;
240: END IF;
241:

Line 242: IF p_x_rt_oper_dep_tbl(i).attribute5= FND_API.G_MISS_CHAR

238: THEN
239: p_x_rt_oper_dep_tbl(i).attribute4:=NULL;
240: END IF;
241:
242: IF p_x_rt_oper_dep_tbl(i).attribute5= FND_API.G_MISS_CHAR
243: THEN
244: p_x_rt_oper_dep_tbl(i).attribute5:=NULL;
245: END IF;
246:

Line 247: IF p_x_rt_oper_dep_tbl(i).attribute6= FND_API.G_MISS_CHAR

243: THEN
244: p_x_rt_oper_dep_tbl(i).attribute5:=NULL;
245: END IF;
246:
247: IF p_x_rt_oper_dep_tbl(i).attribute6= FND_API.G_MISS_CHAR
248: THEN
249: p_x_rt_oper_dep_tbl(i).attribute6:=NULL;
250: END IF;
251:

Line 252: IF p_x_rt_oper_dep_tbl(i).attribute7= FND_API.G_MISS_CHAR

248: THEN
249: p_x_rt_oper_dep_tbl(i).attribute6:=NULL;
250: END IF;
251:
252: IF p_x_rt_oper_dep_tbl(i).attribute7= FND_API.G_MISS_CHAR
253: THEN
254: p_x_rt_oper_dep_tbl(i).attribute7:=NULL;
255: END IF;
256:

Line 257: IF p_x_rt_oper_dep_tbl(i).attribute8= FND_API.G_MISS_CHAR

253: THEN
254: p_x_rt_oper_dep_tbl(i).attribute7:=NULL;
255: END IF;
256:
257: IF p_x_rt_oper_dep_tbl(i).attribute8= FND_API.G_MISS_CHAR
258: THEN
259: p_x_rt_oper_dep_tbl(i).attribute8:=NULL;
260: END IF;
261:

Line 262: IF p_x_rt_oper_dep_tbl(i).attribute9= FND_API.G_MISS_CHAR

258: THEN
259: p_x_rt_oper_dep_tbl(i).attribute8:=NULL;
260: END IF;
261:
262: IF p_x_rt_oper_dep_tbl(i).attribute9= FND_API.G_MISS_CHAR
263: THEN
264: p_x_rt_oper_dep_tbl(i).attribute9:=NULL;
265: END IF;
266:

Line 267: IF p_x_rt_oper_dep_tbl(i).attribute10= FND_API.G_MISS_CHAR

263: THEN
264: p_x_rt_oper_dep_tbl(i).attribute9:=NULL;
265: END IF;
266:
267: IF p_x_rt_oper_dep_tbl(i).attribute10= FND_API.G_MISS_CHAR
268: THEN
269: p_x_rt_oper_dep_tbl(i).attribute10:=NULL;
270: END IF;
271:

Line 272: IF p_x_rt_oper_dep_tbl(i).attribute11= FND_API.G_MISS_CHAR

268: THEN
269: p_x_rt_oper_dep_tbl(i).attribute10:=NULL;
270: END IF;
271:
272: IF p_x_rt_oper_dep_tbl(i).attribute11= FND_API.G_MISS_CHAR
273: THEN
274: p_x_rt_oper_dep_tbl(i).attribute11:=NULL;
275: END IF;
276:

Line 277: IF p_x_rt_oper_dep_tbl(i).attribute12= FND_API.G_MISS_CHAR

273: THEN
274: p_x_rt_oper_dep_tbl(i).attribute11:=NULL;
275: END IF;
276:
277: IF p_x_rt_oper_dep_tbl(i).attribute12= FND_API.G_MISS_CHAR
278: THEN
279: p_x_rt_oper_dep_tbl(i).attribute12:=NULL;
280: END IF;
281:

Line 282: IF p_x_rt_oper_dep_tbl(i).attribute13= FND_API.G_MISS_CHAR

278: THEN
279: p_x_rt_oper_dep_tbl(i).attribute12:=NULL;
280: END IF;
281:
282: IF p_x_rt_oper_dep_tbl(i).attribute13= FND_API.G_MISS_CHAR
283: THEN
284: p_x_rt_oper_dep_tbl(i).attribute13:=NULL;
285: END IF;
286:

Line 287: IF p_x_rt_oper_dep_tbl(i).attribute14= FND_API.G_MISS_CHAR

283: THEN
284: p_x_rt_oper_dep_tbl(i).attribute13:=NULL;
285: END IF;
286:
287: IF p_x_rt_oper_dep_tbl(i).attribute14= FND_API.G_MISS_CHAR
288: THEN
289: p_x_rt_oper_dep_tbl(i).attribute14:=NULL;
290: END IF;
291:

Line 292: IF p_x_rt_oper_dep_tbl(i).attribute15= FND_API.G_MISS_CHAR

288: THEN
289: p_x_rt_oper_dep_tbl(i).attribute14:=NULL;
290: END IF;
291:
292: IF p_x_rt_oper_dep_tbl(i).attribute15= FND_API.G_MISS_CHAR
293: THEN
294: p_x_rt_oper_dep_tbl(i).attribute15:=NULL;
295: END IF;
296:

Line 319: p_route_op_dep_rec.from_op_step <> FND_API.G_MISS_NUM ) THEN

315:
316: BEGIN
317:
318: IF ( p_route_op_dep_rec.from_op_step IS NOT NULL AND
319: p_route_op_dep_rec.from_op_step <> FND_API.G_MISS_NUM ) THEN
320: l_record_identifier := l_record_identifier || to_char(p_route_op_dep_rec.from_op_step);
321: END IF;
322:
323: l_record_identifier := l_record_identifier || ' - ';

Line 326: p_route_op_dep_rec.from_op_number <> FND_API.G_MISS_CHAR ) THEN

322:
323: l_record_identifier := l_record_identifier || ' - ';
324:
325: IF ( p_route_op_dep_rec.from_op_number IS NOT NULL AND
326: p_route_op_dep_rec.from_op_number <> FND_API.G_MISS_CHAR ) THEN
327: l_record_identifier := l_record_identifier || p_route_op_dep_rec.from_op_number;
328: END IF;
329:
330: l_record_identifier := l_record_identifier || ' - ';

Line 333: p_route_op_dep_rec.dependency_code <> FND_API.G_MISS_CHAR ) THEN

329:
330: l_record_identifier := l_record_identifier || ' - ';
331:
332: IF ( p_route_op_dep_rec.dependency_code IS NOT NULL AND
333: p_route_op_dep_rec.dependency_code <> FND_API.G_MISS_CHAR ) THEN
334: l_record_identifier := l_record_identifier || p_route_op_dep_rec.dependency_code;
335: END IF;
336:
337: l_record_identifier := l_record_identifier || ' - ';

Line 340: p_route_op_dep_rec.to_op_step <> FND_API.G_MISS_NUM ) THEN

336:
337: l_record_identifier := l_record_identifier || ' - ';
338:
339: IF ( p_route_op_dep_rec.to_op_step IS NOT NULL AND
340: p_route_op_dep_rec.to_op_step <> FND_API.G_MISS_NUM ) THEN
341: l_record_identifier := l_record_identifier || to_char(p_route_op_dep_rec.to_op_step);
342: END IF;
343:
344: l_record_identifier := l_record_identifier || ' - ';

Line 347: p_route_op_dep_rec.to_op_number <> FND_API.G_MISS_CHAR ) THEN

343:
344: l_record_identifier := l_record_identifier || ' - ';
345:
346: IF ( p_route_op_dep_rec.to_op_number IS NOT NULL AND
347: p_route_op_dep_rec.to_op_number <> FND_API.G_MISS_CHAR ) THEN
348: l_record_identifier := l_record_identifier || p_route_op_dep_rec.to_op_number;
349: END IF;
350:
351: RETURN l_record_identifier;

Line 371: x_return_status := FND_API.G_RET_STS_SUCCESS;

367: l_msg_data VARCHAR2(2000);
368: l_api_name CONSTANT VARCHAR2(30) := 'validate_api_inputs';
369:
370: BEGIN
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372:
373: IF G_DEBUG = 'Y' THEN
374: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
375: END IF;

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

375: END IF;
376:
377:
378: -- Check if a valid value is passed in p_route_id
379: IF ( p_route_id = FND_API.G_MISS_NUM OR p_route_id IS NULL ) THEN
380: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_ID_NULL' );
381: FND_MSG_PUB.add;
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: RETURN;

Line 382: x_return_status := FND_API.G_RET_STS_ERROR;

378: -- Check if a valid value is passed in p_route_id
379: IF ( p_route_id = FND_API.G_MISS_NUM OR p_route_id IS NULL ) THEN
380: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_ID_NULL' );
381: FND_MSG_PUB.add;
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: RETURN;
384: END IF;
385:
386: -- Check if the Route is existing and in Draft status

Line 394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

390: l_msg_data,
391: l_return_status
392: );
393:
394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
395: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
396: FND_MSG_PUB.ADD;
397: x_return_status := l_return_status;
398: RETURN;

Line 406: x_return_status := FND_API.G_RET_STS_ERROR;

402: IF ( p_x_rt_oper_dep_tbl.count < 1 ) THEN
403: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
404: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || l_api_name );
405: FND_MSG_PUB.add;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: RETURN;
408: END IF;
409:
410: -- Validate DML Operation

Line 419: x_return_status := FND_API.G_RET_STS_ERROR;

415: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
416: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dml_operation );
417: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_dep_tbl(i) ) );
418: FND_MSG_PUB.add;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: RETURN;
421: END IF;
422: -- Validation for Step,Operation Number and Status
423: IF ( p_x_rt_oper_dep_tbl(i).from_rt_op_id IS NULL OR

Line 424: p_x_rt_oper_dep_tbl(i).from_rt_op_id = FND_API.G_MISS_NUM )

420: RETURN;
421: END IF;
422: -- Validation for Step,Operation Number and Status
423: IF ( p_x_rt_oper_dep_tbl(i).from_rt_op_id IS NULL OR
424: p_x_rt_oper_dep_tbl(i).from_rt_op_id = FND_API.G_MISS_NUM )
425: THEN
426: IF ( (p_x_rt_oper_dep_tbl(i).from_op_step IS NULL OR
427: p_x_rt_oper_dep_tbl(i).from_op_step = FND_API.G_MISS_NUM ) OR(p_x_rt_oper_dep_tbl(i).from_op_number IS NULL OR
428: p_x_rt_oper_dep_tbl(i).from_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).from_op_status IS NULL OR

Line 427: p_x_rt_oper_dep_tbl(i).from_op_step = FND_API.G_MISS_NUM ) OR(p_x_rt_oper_dep_tbl(i).from_op_number IS NULL OR

423: IF ( p_x_rt_oper_dep_tbl(i).from_rt_op_id IS NULL OR
424: p_x_rt_oper_dep_tbl(i).from_rt_op_id = FND_API.G_MISS_NUM )
425: THEN
426: IF ( (p_x_rt_oper_dep_tbl(i).from_op_step IS NULL OR
427: p_x_rt_oper_dep_tbl(i).from_op_step = FND_API.G_MISS_NUM ) OR(p_x_rt_oper_dep_tbl(i).from_op_number IS NULL OR
428: p_x_rt_oper_dep_tbl(i).from_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).from_op_status IS NULL OR
429: p_x_rt_oper_dep_tbl(i).from_op_status = FND_API.G_MISS_CHAR ))
430: THEN
431: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );

Line 428: p_x_rt_oper_dep_tbl(i).from_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).from_op_status IS NULL OR

424: p_x_rt_oper_dep_tbl(i).from_rt_op_id = FND_API.G_MISS_NUM )
425: THEN
426: IF ( (p_x_rt_oper_dep_tbl(i).from_op_step IS NULL OR
427: p_x_rt_oper_dep_tbl(i).from_op_step = FND_API.G_MISS_NUM ) OR(p_x_rt_oper_dep_tbl(i).from_op_number IS NULL OR
428: p_x_rt_oper_dep_tbl(i).from_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).from_op_status IS NULL OR
429: p_x_rt_oper_dep_tbl(i).from_op_status = FND_API.G_MISS_CHAR ))
430: THEN
431: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );
432: FND_MSG_PUB.add;

Line 429: p_x_rt_oper_dep_tbl(i).from_op_status = FND_API.G_MISS_CHAR ))

425: THEN
426: IF ( (p_x_rt_oper_dep_tbl(i).from_op_step IS NULL OR
427: p_x_rt_oper_dep_tbl(i).from_op_step = FND_API.G_MISS_NUM ) OR(p_x_rt_oper_dep_tbl(i).from_op_number IS NULL OR
428: p_x_rt_oper_dep_tbl(i).from_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).from_op_status IS NULL OR
429: p_x_rt_oper_dep_tbl(i).from_op_status = FND_API.G_MISS_CHAR ))
430: THEN
431: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );
432: FND_MSG_PUB.add;
433: x_return_status := FND_API.G_RET_STS_ERROR;

Line 433: x_return_status := FND_API.G_RET_STS_ERROR;

429: p_x_rt_oper_dep_tbl(i).from_op_status = FND_API.G_MISS_CHAR ))
430: THEN
431: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );
432: FND_MSG_PUB.add;
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: RETURN;
435: END IF;
436: END IF;
437:

Line 439: p_x_rt_oper_dep_tbl(i).to_rt_op_id = FND_API.G_MISS_NUM )

435: END IF;
436: END IF;
437:
438: IF ( p_x_rt_oper_dep_tbl(i).to_rt_op_id IS NULL OR
439: p_x_rt_oper_dep_tbl(i).to_rt_op_id = FND_API.G_MISS_NUM )
440: THEN
441: IF ( (p_x_rt_oper_dep_tbl(i).to_op_step IS NULL OR
442: p_x_rt_oper_dep_tbl(i).to_op_step = FND_API.G_MISS_NUM ) OR(p_x_rt_oper_dep_tbl(i).to_op_number IS NULL OR
443: p_x_rt_oper_dep_tbl(i).to_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).to_op_status IS NULL OR

Line 442: p_x_rt_oper_dep_tbl(i).to_op_step = FND_API.G_MISS_NUM ) OR(p_x_rt_oper_dep_tbl(i).to_op_number IS NULL OR

438: IF ( p_x_rt_oper_dep_tbl(i).to_rt_op_id IS NULL OR
439: p_x_rt_oper_dep_tbl(i).to_rt_op_id = FND_API.G_MISS_NUM )
440: THEN
441: IF ( (p_x_rt_oper_dep_tbl(i).to_op_step IS NULL OR
442: p_x_rt_oper_dep_tbl(i).to_op_step = FND_API.G_MISS_NUM ) OR(p_x_rt_oper_dep_tbl(i).to_op_number IS NULL OR
443: p_x_rt_oper_dep_tbl(i).to_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).to_op_status IS NULL OR
444: p_x_rt_oper_dep_tbl(i).to_op_status = FND_API.G_MISS_CHAR ))
445: THEN
446: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );

Line 443: p_x_rt_oper_dep_tbl(i).to_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).to_op_status IS NULL OR

439: p_x_rt_oper_dep_tbl(i).to_rt_op_id = FND_API.G_MISS_NUM )
440: THEN
441: IF ( (p_x_rt_oper_dep_tbl(i).to_op_step IS NULL OR
442: p_x_rt_oper_dep_tbl(i).to_op_step = FND_API.G_MISS_NUM ) OR(p_x_rt_oper_dep_tbl(i).to_op_number IS NULL OR
443: p_x_rt_oper_dep_tbl(i).to_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).to_op_status IS NULL OR
444: p_x_rt_oper_dep_tbl(i).to_op_status = FND_API.G_MISS_CHAR ))
445: THEN
446: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );
447: FND_MSG_PUB.add;

Line 444: p_x_rt_oper_dep_tbl(i).to_op_status = FND_API.G_MISS_CHAR ))

440: THEN
441: IF ( (p_x_rt_oper_dep_tbl(i).to_op_step IS NULL OR
442: p_x_rt_oper_dep_tbl(i).to_op_step = FND_API.G_MISS_NUM ) OR(p_x_rt_oper_dep_tbl(i).to_op_number IS NULL OR
443: p_x_rt_oper_dep_tbl(i).to_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).to_op_status IS NULL OR
444: p_x_rt_oper_dep_tbl(i).to_op_status = FND_API.G_MISS_CHAR ))
445: THEN
446: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );
447: FND_MSG_PUB.add;
448: x_return_status := FND_API.G_RET_STS_ERROR;

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

444: p_x_rt_oper_dep_tbl(i).to_op_status = FND_API.G_MISS_CHAR ))
445: THEN
446: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );
447: FND_MSG_PUB.add;
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: END IF;
450: END IF;
451:
452: END LOOP;

Line 489: x_return_status := FND_API.G_RET_STS_SUCCESS;

485: l_api_name CONSTANT VARCHAR2(30) := 'Op_Step_To_Assocoation_id';
486:
487: BEGIN
488:
489: x_return_status := FND_API.G_RET_STS_SUCCESS;
490:
491: IF (G_DEBUG = 'Y') THEN
492: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
493: END IF;

Line 501: x_return_status := FND_API.G_RET_STS_ERROR;

497: CLOSE get_route_oper_id;
498:
499: IF (l_rt_operation_id IS NULL )
500: THEN
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MESSAGE.SET_NAME('AHL','AHL_RM_INV_ROUTE_OPER_ASSO');
503: FND_MESSAGE.SET_TOKEN('NUMBER', p_operation_number);
504: FND_MESSAGE.SET_TOKEN('STEP', p_operation_step);
505: FND_MESSAGE.SET_TOKEN('STATUS', p_operation_status);

Line 540: x_return_status := FND_API.G_RET_STS_SUCCESS;

536: PRAGMA EXCEPTION_INIT(l_cyclic_loop,-1436);
537: l_counter NUMBER;
538: l_api_name CONSTANT VARCHAR2(30) := 'validate_cyclic_dependencies';
539: BEGIN
540: x_return_status := FND_API.G_RET_STS_SUCCESS;
541:
542: IF G_DEBUG = 'Y' THEN
543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
544: END IF;

Line 574: x_return_status := FND_API.G_RET_STS_ERROR;

570: WHEN l_cyclic_loop THEN
571: FND_MESSAGE.SET_NAME('AHL','AHL_RM_RT_OPSTEP_INVALID_CYC');
572: FND_MESSAGE.SET_TOKEN('RECORD',p_from_op_step ,false);
573: FND_MSG_PUB.ADD;
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
576: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,

Line 575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

571: FND_MESSAGE.SET_NAME('AHL','AHL_RM_RT_OPSTEP_INVALID_CYC');
572: FND_MESSAGE.SET_TOKEN('RECORD',p_from_op_step ,false);
573: FND_MSG_PUB.ADD;
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
576: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data);

Line 576: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

572: FND_MESSAGE.SET_TOKEN('RECORD',p_from_op_step ,false);
573: FND_MSG_PUB.ADD;
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
576: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data);
580:

Line 577: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

573: FND_MSG_PUB.ADD;
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
576: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data);
580:
581: WHEN FND_API.G_EXC_ERROR THEN

Line 581: WHEN FND_API.G_EXC_ERROR THEN

577: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data);
580:
581: WHEN FND_API.G_EXC_ERROR THEN
582: X_return_status := FND_API.G_RET_STS_ERROR;
583: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
584: p_count => x_msg_count,
585: p_data => X_msg_data);

Line 582: X_return_status := FND_API.G_RET_STS_ERROR;

578: p_count => x_msg_count,
579: p_data => x_msg_data);
580:
581: WHEN FND_API.G_EXC_ERROR THEN
582: X_return_status := FND_API.G_RET_STS_ERROR;
583: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
584: p_count => x_msg_count,
585: p_data => X_msg_data);
586: WHEN OTHERS THEN

Line 583: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

579: p_data => x_msg_data);
580:
581: WHEN FND_API.G_EXC_ERROR THEN
582: X_return_status := FND_API.G_RET_STS_ERROR;
583: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
584: p_count => x_msg_count,
585: p_data => X_msg_data);
586: WHEN OTHERS THEN
587: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 587: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

583: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
584: p_count => x_msg_count,
585: p_data => X_msg_data);
586: WHEN OTHERS THEN
587: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_RT_OP_DEPEN_PVT',
591: p_procedure_name => 'VALIDATE_CYCLIC_DEPENDENCIES',

Line 594: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

590: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_RT_OP_DEPEN_PVT',
591: p_procedure_name => 'VALIDATE_CYCLIC_DEPENDENCIES',
592: p_error_text => SUBSTR(SQLERRM,1,240));
593: END IF;
594: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
595: p_count => x_msg_count,
596: p_data => X_msg_data);
597:
598: END validate_cyclic_dependencies;

Line 623: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

619:
620: PROCEDURE process_rt_oper_dep
621: (
622: p_api_version IN NUMBER := 1.0,
623: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
624: p_commit IN VARCHAR2 := FND_API.G_FALSE,
625: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
626: p_default IN VARCHAR2 := FND_API.G_FALSE,
627: p_module_type IN VARCHAR2 := NULL,

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

620: PROCEDURE process_rt_oper_dep
621: (
622: p_api_version IN NUMBER := 1.0,
623: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
624: p_commit IN VARCHAR2 := FND_API.G_FALSE,
625: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
626: p_default IN VARCHAR2 := FND_API.G_FALSE,
627: p_module_type IN VARCHAR2 := NULL,
628: x_return_status OUT NOCOPY VARCHAR2,

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

621: (
622: p_api_version IN NUMBER := 1.0,
623: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
624: p_commit IN VARCHAR2 := FND_API.G_FALSE,
625: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
626: p_default IN VARCHAR2 := FND_API.G_FALSE,
627: p_module_type IN VARCHAR2 := NULL,
628: x_return_status OUT NOCOPY VARCHAR2,
629: x_msg_count OUT NOCOPY NUMBER,

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

622: p_api_version IN NUMBER := 1.0,
623: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
624: p_commit IN VARCHAR2 := FND_API.G_FALSE,
625: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
626: p_default IN VARCHAR2 := FND_API.G_FALSE,
627: p_module_type IN VARCHAR2 := NULL,
628: x_return_status OUT NOCOPY VARCHAR2,
629: x_msg_count OUT NOCOPY NUMBER,
630: x_msg_data OUT NOCOPY VARCHAR2,

Line 681: x_return_status := FND_API.G_RET_STS_SUCCESS;

677:
678:
679: BEGIN
680: -- Initialize API return status to success
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682:
683: -- Standard Start of API savepoint
684: SAVEPOINT sp_process_rt_oper_dep_pvt;
685:

Line 687: IF NOT FND_API.compatible_api_call

683: -- Standard Start of API savepoint
684: SAVEPOINT sp_process_rt_oper_dep_pvt;
685:
686: -- Standard call to check for call compatibility.
687: IF NOT FND_API.compatible_api_call
688: (
689: l_api_version,
690: p_api_version,
691: l_api_name,

Line 695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

691: l_api_name,
692: G_PKG_NAME
693: )
694: THEN
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: END IF;
697:
698: -- Initialize message list if p_init_msg_list is set to TRUE.
699: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 699: IF FND_API.to_boolean( p_init_msg_list ) THEN

695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: END IF;
697:
698: -- Initialize message list if p_init_msg_list is set to TRUE.
699: IF FND_API.to_boolean( p_init_msg_list ) THEN
700: FND_MSG_PUB.initialize;
701: END IF;
702:
703: IF G_DEBUG = 'Y' THEN

Line 718: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

714: x_msg_data => l_msg_data
715: );
716:
717: -- If any severe error occurs, then, abort API.
718: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
719: RAISE FND_API.G_EXC_ERROR;
720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;

Line 719: RAISE FND_API.G_EXC_ERROR;

715: );
716:
717: -- If any severe error occurs, then, abort API.
718: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
719: RAISE FND_API.G_EXC_ERROR;
720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723:

Line 720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

716:
717: -- If any severe error occurs, then, abort API.
718: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
719: RAISE FND_API.G_EXC_ERROR;
720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723:
724: -- Validate all the inputs of the API

Line 721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

717: -- If any severe error occurs, then, abort API.
718: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
719: RAISE FND_API.G_EXC_ERROR;
720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723:
724: -- Validate all the inputs of the API
725: validate_api_inputs

Line 733: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

729: l_return_status -- OUT
730: );
731:
732: -- If any severe error occurs, then, abort API.
733: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
734: RAISE FND_API.G_EXC_ERROR;
735: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: END IF;

Line 734: RAISE FND_API.G_EXC_ERROR;

730: );
731:
732: -- If any severe error occurs, then, abort API.
733: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
734: RAISE FND_API.G_EXC_ERROR;
735: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: END IF;
738:

Line 735: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

731:
732: -- If any severe error occurs, then, abort API.
733: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
734: RAISE FND_API.G_EXC_ERROR;
735: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: END IF;
738:
739: FOR i IN 1..p_x_rt_oper_dep_tbl.count LOOP

Line 736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

732: -- If any severe error occurs, then, abort API.
733: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
734: RAISE FND_API.G_EXC_ERROR;
735: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: END IF;
738:
739: FOR i IN 1..p_x_rt_oper_dep_tbl.count LOOP
740: IF (p_x_rt_oper_dep_tbl(i).dml_operation <> 'D')

Line 759: IF l_return_status = FND_API.G_RET_STS_ERROR

755: IF G_DEBUG = 'Y' THEN
756: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : From_rt_op_id' || p_x_rt_oper_dep_tbl(i).from_rt_op_id );
757: END IF;
758:
759: IF l_return_status = FND_API.G_RET_STS_ERROR
760: THEN
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763:

Line 761: RAISE FND_API.G_EXC_ERROR;

757: END IF;
758:
759: IF l_return_status = FND_API.G_RET_STS_ERROR
760: THEN
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763:
764: ELSIF ( (p_x_rt_oper_dep_tbl(i).from_rt_op_id IS NOT NULL) AND (p_x_rt_oper_dep_tbl(i).from_op_step IS NULL OR
765: p_x_rt_oper_dep_tbl(i).from_op_step = FND_API.G_MISS_NUM) )

Line 765: p_x_rt_oper_dep_tbl(i).from_op_step = FND_API.G_MISS_NUM) )

761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763:
764: ELSIF ( (p_x_rt_oper_dep_tbl(i).from_rt_op_id IS NOT NULL) AND (p_x_rt_oper_dep_tbl(i).from_op_step IS NULL OR
765: p_x_rt_oper_dep_tbl(i).from_op_step = FND_API.G_MISS_NUM) )
766: THEN
767: -- Check Whether the operation is already associated to the route or not
768: OPEN validate_oper_step(p_route_id,p_x_rt_oper_dep_tbl(i).from_rt_op_id);
769: FETCH validate_oper_step INTO p_x_rt_oper_dep_tbl(i).from_op_step;

Line 796: IF l_return_status = FND_API.G_RET_STS_ERROR

792: IF G_DEBUG = 'Y' THEN
793: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : To_rt_op_id' || p_x_rt_oper_dep_tbl(i).to_rt_op_id );
794: END IF;
795:
796: IF l_return_status = FND_API.G_RET_STS_ERROR
797: THEN
798: RAISE FND_API.G_EXC_ERROR;
799: END IF;
800:

Line 798: RAISE FND_API.G_EXC_ERROR;

794: END IF;
795:
796: IF l_return_status = FND_API.G_RET_STS_ERROR
797: THEN
798: RAISE FND_API.G_EXC_ERROR;
799: END IF;
800:
801: ELSIF ( (p_x_rt_oper_dep_tbl(i).to_rt_op_id IS NOT NULL) AND (p_x_rt_oper_dep_tbl(i).to_op_step IS NULL OR
802: p_x_rt_oper_dep_tbl(i).to_op_step = FND_API.G_MISS_NUM) )

Line 802: p_x_rt_oper_dep_tbl(i).to_op_step = FND_API.G_MISS_NUM) )

798: RAISE FND_API.G_EXC_ERROR;
799: END IF;
800:
801: ELSIF ( (p_x_rt_oper_dep_tbl(i).to_rt_op_id IS NOT NULL) AND (p_x_rt_oper_dep_tbl(i).to_op_step IS NULL OR
802: p_x_rt_oper_dep_tbl(i).to_op_step = FND_API.G_MISS_NUM) )
803: THEN
804: -- Check Whether the operation is already associated to the route or not
805: OPEN validate_oper_step(p_route_id,p_x_rt_oper_dep_tbl(i).to_rt_op_id);
806: FETCH validate_oper_step INTO p_x_rt_oper_dep_tbl(i).to_op_step;

Line 818: p_x_rt_oper_dep_tbl(i).dependency_code <> FND_API.G_MISS_CHAR ) OR

814: END IF;
815:
816: -- Validate Dependency Type
817: IF ( ( p_x_rt_oper_dep_tbl(i).dependency_code IS NOT NULL AND
818: p_x_rt_oper_dep_tbl(i).dependency_code <> FND_API.G_MISS_CHAR ) OR
819: ( p_x_rt_oper_dep_tbl(i).dependency_mean IS NOT NULL AND
820: p_x_rt_oper_dep_tbl(i).dependency_mean <> FND_API.G_MISS_CHAR ) ) THEN
821:
822: AHL_RM_ROUTE_UTIL.validate_lookup

Line 820: p_x_rt_oper_dep_tbl(i).dependency_mean <> FND_API.G_MISS_CHAR ) ) THEN

816: -- Validate Dependency Type
817: IF ( ( p_x_rt_oper_dep_tbl(i).dependency_code IS NOT NULL AND
818: p_x_rt_oper_dep_tbl(i).dependency_code <> FND_API.G_MISS_CHAR ) OR
819: ( p_x_rt_oper_dep_tbl(i).dependency_mean IS NOT NULL AND
820: p_x_rt_oper_dep_tbl(i).dependency_mean <> FND_API.G_MISS_CHAR ) ) THEN
821:
822: AHL_RM_ROUTE_UTIL.validate_lookup
823: (
824: x_return_status => l_return_status,

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

827: p_lookup_meaning => p_x_rt_oper_dep_tbl(i).dependency_mean,
828: p_x_lookup_code => p_x_rt_oper_dep_tbl(i).dependency_code
829: );
830:
831: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
832: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
833: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_DEP_TYPE' );
834: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
835: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_DEP_TYPES' );

Line 841: p_x_rt_oper_dep_tbl(i).dependency_mean = FND_API.G_MISS_CHAR ) THEN

837: FND_MESSAGE.set_name( 'AHL', l_msg_data );
838: END IF;
839:
840: IF ( p_x_rt_oper_dep_tbl(i).dependency_mean IS NULL OR
841: p_x_rt_oper_dep_tbl(i).dependency_mean = FND_API.G_MISS_CHAR ) THEN
842: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dependency_code );
843: ELSE
844: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dependency_mean );
845: END IF;

Line 878: RAISE FND_API.G_EXC_ERROR;

874: -- Get all the error messages if any and raise the appropriate Exception
875: l_msg_count := FND_MSG_PUB.count_msg;
876: IF l_msg_count > 0 THEN
877: x_msg_count := l_msg_count;
878: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880:
881: END LOOP; -- End of Loop for Validations
882:

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

897: p_rou_start_date => l_route_start_date,
898: x_res_max_duration => l_res_max_duration
899: );
900:
901: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
902: FND_MESSAGE.SET_NAME( 'AHL', L_MSG_DATA );
903: -- sansatpa added the below if condition to distinguish between error messages
904: IF(L_MSG_DATA = 'AHL_COM_INVALID_PROCEDURE_CALL')
905: THEN

Line 942: RAISE FND_API.G_EXC_ERROR;

938: FND_MESSAGE.set_name('AHL', 'AHL_RM_DUP_DEPEND');
939: FND_MESSAGE.set_token( 'FROM_NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );
940: FND_MESSAGE.set_token( 'TO_NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );
941: FND_MSG_PUB.add;
942: RAISE FND_API.G_EXC_ERROR;
943: END IF;
944: CLOSE duplicate_depen;
945: END IF;
946:

Line 994: RAISE FND_API.G_EXC_ERROR;

990: FND_MESSAGE.set_name('AHL', 'AHL_RM_DUP_DEPEND');
991: FND_MESSAGE.set_token( 'FROM_NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );
992: FND_MESSAGE.set_token( 'TO_NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );
993: FND_MSG_PUB.add;
994: RAISE FND_API.G_EXC_ERROR;
995: END IF;
996: CLOSE duplicate_depen;
997:
998:

Line 1085: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1081: );
1082:
1083: --END IF; -- sansatpa commented for bug# 14135529.
1084:
1085: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1086: RAISE FND_API.G_EXC_ERROR;
1087: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;

Line 1086: RAISE FND_API.G_EXC_ERROR;

1082:
1083: --END IF; -- sansatpa commented for bug# 14135529.
1084:
1085: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1086: RAISE FND_API.G_EXC_ERROR;
1087: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090:

Line 1087: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1083: --END IF; -- sansatpa commented for bug# 14135529.
1084:
1085: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1086: RAISE FND_API.G_EXC_ERROR;
1087: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090:
1091: END IF;

Line 1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1084:
1085: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1086: RAISE FND_API.G_EXC_ERROR;
1087: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090:
1091: END IF;
1092:

Line 1095: IF FND_API.TO_BOOLEAN(p_commit) THEN

1091: END IF;
1092:
1093: END LOOP;
1094:
1095: IF FND_API.TO_BOOLEAN(p_commit) THEN
1096: COMMIT;
1097: END IF;
1098:
1099: IF G_DEBUG='Y' THEN

Line 1105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1101: END IF;
1102:
1103:
1104: EXCEPTION
1105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1106: ROLLBACK TO sp_process_rt_oper_dep_pvt;
1107: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1108: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1109: p_count => x_msg_count,

Line 1107: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1103:
1104: EXCEPTION
1105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1106: ROLLBACK TO sp_process_rt_oper_dep_pvt;
1107: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1108: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);
1111:

Line 1108: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1104: EXCEPTION
1105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1106: ROLLBACK TO sp_process_rt_oper_dep_pvt;
1107: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1108: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);
1111:
1112: WHEN FND_API.G_EXC_ERROR THEN

Line 1112: WHEN FND_API.G_EXC_ERROR THEN

1108: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);
1111:
1112: WHEN FND_API.G_EXC_ERROR THEN
1113: ROLLBACK TO sp_process_rt_oper_dep_pvt;
1114: X_return_status := FND_API.G_RET_STS_ERROR;
1115: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1116: p_count => x_msg_count,

Line 1114: X_return_status := FND_API.G_RET_STS_ERROR;

1110: p_data => x_msg_data);
1111:
1112: WHEN FND_API.G_EXC_ERROR THEN
1113: ROLLBACK TO sp_process_rt_oper_dep_pvt;
1114: X_return_status := FND_API.G_RET_STS_ERROR;
1115: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1116: p_count => x_msg_count,
1117: p_data => X_msg_data);
1118: WHEN OTHERS THEN

Line 1115: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1111:
1112: WHEN FND_API.G_EXC_ERROR THEN
1113: ROLLBACK TO sp_process_rt_oper_dep_pvt;
1114: X_return_status := FND_API.G_RET_STS_ERROR;
1115: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1116: p_count => x_msg_count,
1117: p_data => X_msg_data);
1118: WHEN OTHERS THEN
1119: ROLLBACK TO sp_process_rt_oper_dep_pvt;

Line 1120: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1116: p_count => x_msg_count,
1117: p_data => X_msg_data);
1118: WHEN OTHERS THEN
1119: ROLLBACK TO sp_process_rt_oper_dep_pvt;
1120: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1121:
1122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1123: THEN
1124: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_RT_OP_DEP_PVT',

Line 1128: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1124: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_RT_OP_DEP_PVT',
1125: p_procedure_name => 'PROCESS_RT_OPER_DEP',
1126: p_error_text => SUBSTR(SQLERRM,1,240));
1127: END IF;
1128: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1129: p_count => x_msg_count,
1130: p_data => X_msg_data);
1131:
1132: