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_FMP_MR_ROUTE_SEQNCE_PVT dependencies on FND_API

Line 134: IF P_X_MR_ROUTESEQ_TBL(I).MR_ROUTE_SEQUENCE_ID= FND_API.G_MISS_NUM

130: OPEN CurGetSeqDet(P_X_MR_ROUTESEQ_TBL(I).MR_ROUTE_SEQUENCE_ID);
131: FETCH CurGetSeqDet into l_routeseq_rec;
132: CLOSE CurGetSeqDet;
133:
134: IF P_X_MR_ROUTESEQ_TBL(I).MR_ROUTE_SEQUENCE_ID= FND_API.G_MISS_NUM
135: THEN
136: P_X_MR_ROUTESEQ_TBL(I).MR_ROUTE_SEQUENCE_ID:=NULL;
137: ELSIF P_X_MR_ROUTESEQ_TBL(I).MR_ROUTE_SEQUENCE_ID IS NULL
138: THEN

Line 141: IF P_X_MR_ROUTESEQ_TBL(I).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM

137: ELSIF P_X_MR_ROUTESEQ_TBL(I).MR_ROUTE_SEQUENCE_ID IS NULL
138: THEN
139: P_X_MR_ROUTESEQ_TBL(I).MR_ROUTE_SEQUENCE_ID:=l_routeseq_rec.MR_ROUTE_SEQUENCE_ID;
140: END IF;
141: IF P_X_MR_ROUTESEQ_TBL(I).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM
142: THEN
143: P_X_MR_ROUTESEQ_TBL(I).OBJECT_VERSION_NUMBER:=NULL;
144: ELSIF P_X_MR_ROUTESEQ_TBL(I).OBJECT_VERSION_NUMBER IS NULL
145: THEN

Line 148: IF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_DATE=FND_API.G_MISS_DATE

144: ELSIF P_X_MR_ROUTESEQ_TBL(I).OBJECT_VERSION_NUMBER IS NULL
145: THEN
146: P_X_MR_ROUTESEQ_TBL(I).OBJECT_VERSION_NUMBER:=l_routeseq_rec.OBJECT_VERSION_NUMBER;
147: END IF;
148: IF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_DATE=FND_API.G_MISS_DATE
149: THEN
150: P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_DATE:=NULL;
151: ELSIF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_DATE IS NULL
152: THEN

Line 155: IF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATED_BY= FND_API.G_MISS_NUM

151: ELSIF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_DATE IS NULL
152: THEN
153: P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_DATE:=l_routeseq_rec.LAST_UPDATE_DATE;
154: END IF;
155: IF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATED_BY= FND_API.G_MISS_NUM
156: THEN
157: P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATED_BY:=NULL;
158: ELSIF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATED_BY IS NULL
159: THEN

Line 162: IF P_X_MR_ROUTESEQ_TBL(I).CREATION_DATE=FND_API.G_MISS_DATE

158: ELSIF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATED_BY IS NULL
159: THEN
160: P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATED_BY:=l_routeseq_rec.LAST_UPDATED_BY;
161: END IF;
162: IF P_X_MR_ROUTESEQ_TBL(I).CREATION_DATE=FND_API.G_MISS_DATE
163: THEN
164: P_X_MR_ROUTESEQ_TBL(I).CREATION_DATE:=NULL;
165: ELSIF P_X_MR_ROUTESEQ_TBL(I).CREATION_DATE IS NULL
166: THEN

Line 169: IF P_X_MR_ROUTESEQ_TBL(I).SEQUENCE_CODE= FND_API.G_MISS_CHAR

165: ELSIF P_X_MR_ROUTESEQ_TBL(I).CREATION_DATE IS NULL
166: THEN
167: P_X_MR_ROUTESEQ_TBL(I).CREATION_DATE:=l_routeseq_rec.CREATION_DATE;
168: END IF;
169: IF P_X_MR_ROUTESEQ_TBL(I).SEQUENCE_CODE= FND_API.G_MISS_CHAR
170: THEN
171: P_X_MR_ROUTESEQ_TBL(I).SEQUENCE_CODE:=NULL;
172: ELSIF P_X_MR_ROUTESEQ_TBL(I).SEQUENCE_CODE IS NULL
173: THEN

Line 176: IF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM

172: ELSIF P_X_MR_ROUTESEQ_TBL(I).SEQUENCE_CODE IS NULL
173: THEN
174: P_X_MR_ROUTESEQ_TBL(I).SEQUENCE_CODE:=l_routeseq_rec.SEQUENCE_CODE;
175: END IF;
176: IF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM
177: THEN
178: P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_LOGIN:=NULL;
179: ELSIF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_LOGIN IS NULL
180: THEN

Line 183: IF P_X_MR_ROUTESEQ_TBL(I).MR_ROUTE_ID= FND_API.G_MISS_NUM

179: ELSIF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_LOGIN IS NULL
180: THEN
181: P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_LOGIN:=l_routeseq_rec.LAST_UPDATE_LOGIN;
182: END IF;
183: IF P_X_MR_ROUTESEQ_TBL(I).MR_ROUTE_ID= FND_API.G_MISS_NUM
184: THEN
185: P_X_MR_ROUTESEQ_TBL(I).MR_ROUTE_ID:=NULL;
186: ELSIF P_X_MR_ROUTESEQ_TBL(I).MR_ROUTE_ID IS NULL
187: THEN

Line 190: IF P_X_MR_ROUTESEQ_TBL(I).RELATED_MR_ROUTE_ID= FND_API.G_MISS_NUM

186: ELSIF P_X_MR_ROUTESEQ_TBL(I).MR_ROUTE_ID IS NULL
187: THEN
188: P_X_MR_ROUTESEQ_TBL(I).MR_ROUTE_ID:=l_routeseq_rec.MR_ROUTE_ID;
189: END IF;
190: IF P_X_MR_ROUTESEQ_TBL(I).RELATED_MR_ROUTE_ID= FND_API.G_MISS_NUM
191: THEN
192: P_X_MR_ROUTESEQ_TBL(I).RELATED_MR_ROUTE_ID:=NULL;
193: ELSIF P_X_MR_ROUTESEQ_TBL(I).RELATED_MR_ROUTE_ID IS NULL
194: THEN

Line 197: IF P_X_MR_ROUTESEQ_TBL(I).CREATED_BY= FND_API.G_MISS_NUM

193: ELSIF P_X_MR_ROUTESEQ_TBL(I).RELATED_MR_ROUTE_ID IS NULL
194: THEN
195: P_X_MR_ROUTESEQ_TBL(I).RELATED_MR_ROUTE_ID:=l_routeseq_rec.RELATED_MR_ROUTE_ID;
196: END IF;
197: IF P_X_MR_ROUTESEQ_TBL(I).CREATED_BY= FND_API.G_MISS_NUM
198: THEN
199: P_X_MR_ROUTESEQ_TBL(I).CREATED_BY:=NULL;
200: ELSIF P_X_MR_ROUTESEQ_TBL(I).CREATED_BY IS NULL
201: THEN

Line 204: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE3= FND_API.G_MISS_CHAR

200: ELSIF P_X_MR_ROUTESEQ_TBL(I).CREATED_BY IS NULL
201: THEN
202: P_X_MR_ROUTESEQ_TBL(I).CREATED_BY:=l_routeseq_rec.CREATED_BY;
203: END IF;
204: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE3= FND_API.G_MISS_CHAR
205: THEN
206: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE3:=NULL;
207: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE3 IS NULL
208: THEN

Line 211: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR

207: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE3 IS NULL
208: THEN
209: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE3:=l_routeseq_rec.ATTRIBUTE3;
210: END IF;
211: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR
212: THEN
213: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE_CATEGORY:=NULL;
214: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE_CATEGORY IS NULL
215: THEN

Line 218: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE1= FND_API.G_MISS_CHAR

214: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE_CATEGORY IS NULL
215: THEN
216: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE_CATEGORY:=l_routeseq_rec.ATTRIBUTE_CATEGORY;
217: END IF;
218: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE1= FND_API.G_MISS_CHAR
219: THEN
220: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE1:=NULL;
221: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE1 IS NULL
222: THEN

Line 225: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE2= FND_API.G_MISS_CHAR

221: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE1 IS NULL
222: THEN
223: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE1:=l_routeseq_rec.ATTRIBUTE1;
224: END IF;
225: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE2= FND_API.G_MISS_CHAR
226: THEN
227: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE2:=NULL;
228: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE2 IS NULL
229: THEN

Line 232: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE4= FND_API.G_MISS_CHAR

228: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE2 IS NULL
229: THEN
230: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE2:=l_routeseq_rec.ATTRIBUTE2;
231: END IF;
232: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE4= FND_API.G_MISS_CHAR
233: THEN
234: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE4:=NULL;
235: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE4 IS NULL
236: THEN

Line 239: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE5= FND_API.G_MISS_CHAR

235: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE4 IS NULL
236: THEN
237: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE4:=l_routeseq_rec.ATTRIBUTE4;
238: END IF;
239: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE5= FND_API.G_MISS_CHAR
240: THEN
241: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE5:=NULL;
242: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE5 IS NULL
243: THEN

Line 246: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE6= FND_API.G_MISS_CHAR

242: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE5 IS NULL
243: THEN
244: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE5:=l_routeseq_rec.ATTRIBUTE5;
245: END IF;
246: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE6= FND_API.G_MISS_CHAR
247: THEN
248: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE6:=NULL;
249: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE6 IS NULL
250: THEN

Line 253: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE7= FND_API.G_MISS_CHAR

249: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE6 IS NULL
250: THEN
251: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE6:=l_routeseq_rec.ATTRIBUTE6;
252: END IF;
253: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE7= FND_API.G_MISS_CHAR
254: THEN
255: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE7:=NULL;
256: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE7 IS NULL
257: THEN

Line 260: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE8= FND_API.G_MISS_CHAR

256: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE7 IS NULL
257: THEN
258: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE7:=l_routeseq_rec.ATTRIBUTE7;
259: END IF;
260: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE8= FND_API.G_MISS_CHAR
261: THEN
262: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE8:=NULL;
263: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE8 IS NULL
264: THEN

Line 267: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE9= FND_API.G_MISS_CHAR

263: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE8 IS NULL
264: THEN
265: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE8:=l_routeseq_rec.ATTRIBUTE8;
266: END IF;
267: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE9= FND_API.G_MISS_CHAR
268: THEN
269: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE9:=NULL;
270: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE9 IS NULL
271: THEN

Line 274: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE10= FND_API.G_MISS_CHAR

270: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE9 IS NULL
271: THEN
272: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE9:=l_routeseq_rec.ATTRIBUTE9;
273: END IF;
274: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE10= FND_API.G_MISS_CHAR
275: THEN
276: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE10:=NULL;
277: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE10 IS NULL
278: THEN

Line 281: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE11= FND_API.G_MISS_CHAR

277: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE10 IS NULL
278: THEN
279: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE10:=l_routeseq_rec.ATTRIBUTE10;
280: END IF;
281: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE11= FND_API.G_MISS_CHAR
282: THEN
283: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE11:=NULL;
284: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE11 IS NULL
285: THEN

Line 288: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE12= FND_API.G_MISS_CHAR

284: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE11 IS NULL
285: THEN
286: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE11:=l_routeseq_rec.ATTRIBUTE11;
287: END IF;
288: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE12= FND_API.G_MISS_CHAR
289: THEN
290: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE12:=NULL;
291: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE12 IS NULL
292: THEN

Line 295: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE13= FND_API.G_MISS_CHAR

291: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE12 IS NULL
292: THEN
293: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE12:=l_routeseq_rec.ATTRIBUTE12;
294: END IF;
295: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE13= FND_API.G_MISS_CHAR
296: THEN
297: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE13:=NULL;
298: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE13 IS NULL
299: THEN

Line 302: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE14= FND_API.G_MISS_CHAR

298: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE13 IS NULL
299: THEN
300: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE13:=l_routeseq_rec.ATTRIBUTE13;
301: END IF;
302: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE14= FND_API.G_MISS_CHAR
303: THEN
304: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE14:=NULL;
305: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE14 IS NULL
306: THEN

Line 309: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE15= FND_API.G_MISS_CHAR

305: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE14 IS NULL
306: THEN
307: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE14:=l_routeseq_rec.ATTRIBUTE14;
308: END IF;
309: IF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE15= FND_API.G_MISS_CHAR
310: THEN
311: P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE15:=NULL;
312: ELSIF P_X_MR_ROUTESEQ_TBL(I).ATTRIBUTE15 IS NULL
313: THEN

Line 362: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

358: l_num_rec NUMBER;
359: l_msg_count NUMBER;
360: l_msg_data VARCHAR2(2000);
361: l_return_status VARCHAR2(1);
362: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
363: l_mr_header_id NUMBER:=0;
364: l_counter NUMBER:=0;
365: l_counter2 NUMBER:=0;
366: l_counter3 NUMBER:=0;

Line 373: x_return_status:=FND_API.G_RET_STS_SUCCESS;

369: l_lookup_code VARCHAR2(30):='';
370: l_appln_code VARCHAR2(30);
371: l_check_flag VARCHAR2(1):='N';
372: BEGIN
373: x_return_status:=FND_API.G_RET_STS_SUCCESS;
374:
375: IF g_appln_usage is null
376: THEN
377: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');

Line 383: IF (p_mr_route_Seq_rec.MR_ROUTE_SEQUENCE_ID IS NULL OR p_mr_route_Seq_rec.MR_ROUTE_SEQUENCE_ID=FND_API.G_MISS_NUM) AND p_mr_route_Seq_rec.dml_operation<>'C'

379: RETURN;
380: END IF;
381:
382:
383: IF (p_mr_route_Seq_rec.MR_ROUTE_SEQUENCE_ID IS NULL OR p_mr_route_Seq_rec.MR_ROUTE_SEQUENCE_ID=FND_API.G_MISS_NUM) AND p_mr_route_Seq_rec.dml_operation<>'C'
384: THEN
385: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_SEQ_ID_NULL');
386: FND_MSG_PUB.ADD;
387: END IF;

Line 389: IF (p_mr_route_Seq_rec.OBJECT_VERSION_NUMBER IS NULL OR p_mr_route_Seq_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM) and p_mr_route_Seq_rec.dml_operation<>'C'

385: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_SEQ_ID_NULL');
386: FND_MSG_PUB.ADD;
387: END IF;
388:
389: IF (p_mr_route_Seq_rec.OBJECT_VERSION_NUMBER IS NULL OR p_mr_route_Seq_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM) and p_mr_route_Seq_rec.dml_operation<>'C'
390: THEN
391: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRRD_OBJ_VERSION_NULL');
392: FND_MESSAGE.SET_TOKEN('RECORD',p_mr_route_Seq_rec.ROUTE_NUMBER ,false);
393: FND_MSG_PUB.ADD;

Line 396: IF p_mr_ROUTE_SEQ_rec.MR_HEADER_ID IS NULL OR p_mr_ROUTE_SEQ_rec.MR_HEADER_ID=FND_API.G_MISS_NUM

392: FND_MESSAGE.SET_TOKEN('RECORD',p_mr_route_Seq_rec.ROUTE_NUMBER ,false);
393: FND_MSG_PUB.ADD;
394: END IF;
395:
396: IF p_mr_ROUTE_SEQ_rec.MR_HEADER_ID IS NULL OR p_mr_ROUTE_SEQ_rec.MR_HEADER_ID=FND_API.G_MISS_NUM
397: THEN
398: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_NULL');
399: FND_MSG_PUB.ADD;
400: ELSE

Line 427: p_mr_route_Seq_rec.RELATED_MR_ROUTE_ID=FND_API.G_MISS_NUM) AND p_mr_route_Seq_rec.dml_operation<>'D'

423:
424: IF p_mr_route_Seq_rec.dml_operation<>'D'
425: THEN
426: IF (p_mr_route_Seq_rec.RELATED_MR_ROUTE_ID IS NULL OR
427: p_mr_route_Seq_rec.RELATED_MR_ROUTE_ID=FND_API.G_MISS_NUM) AND p_mr_route_Seq_rec.dml_operation<>'D'
428: THEN
429: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_ID_NULL');
430: FND_MESSAGE.SET_TOKEN('RECORD',p_mr_route_Seq_rec.ROUTE_NUMBER ,false);
431: FND_MSG_PUB.ADD;

Line 446: IF (p_mr_route_Seq_rec.MR_ROUTE_ID IS NOT NULL OR p_mr_route_Seq_rec.MR_ROUTE_ID<>FND_API.G_MISS_NUM

442: END IF;
443: l_counter2:=0;
444:
445: -- Check for uniq ness of the Route Sequences
446: IF (p_mr_route_Seq_rec.MR_ROUTE_ID IS NOT NULL OR p_mr_route_Seq_rec.MR_ROUTE_ID<>FND_API.G_MISS_NUM
447: OR p_mr_route_Seq_rec.related_mr_route_id IS NOT NULL OR p_mr_route_Seq_rec.related_mr_route_id<>FND_API.G_MISS_NUM
448: OR p_mr_route_Seq_rec.sequence_code IS NOT NULL OR p_mr_route_Seq_rec.sequence_code<>FND_API.G_MISS_CHAR)
449: THEN
450:

Line 447: OR p_mr_route_Seq_rec.related_mr_route_id IS NOT NULL OR p_mr_route_Seq_rec.related_mr_route_id<>FND_API.G_MISS_NUM

443: l_counter2:=0;
444:
445: -- Check for uniq ness of the Route Sequences
446: IF (p_mr_route_Seq_rec.MR_ROUTE_ID IS NOT NULL OR p_mr_route_Seq_rec.MR_ROUTE_ID<>FND_API.G_MISS_NUM
447: OR p_mr_route_Seq_rec.related_mr_route_id IS NOT NULL OR p_mr_route_Seq_rec.related_mr_route_id<>FND_API.G_MISS_NUM
448: OR p_mr_route_Seq_rec.sequence_code IS NOT NULL OR p_mr_route_Seq_rec.sequence_code<>FND_API.G_MISS_CHAR)
449: THEN
450:
451: IF p_mr_route_Seq_rec.sequence_code='BEFORE' and p_mr_route_Seq_rec.dml_operation<>'D'

Line 448: OR p_mr_route_Seq_rec.sequence_code IS NOT NULL OR p_mr_route_Seq_rec.sequence_code<>FND_API.G_MISS_CHAR)

444:
445: -- Check for uniq ness of the Route Sequences
446: IF (p_mr_route_Seq_rec.MR_ROUTE_ID IS NOT NULL OR p_mr_route_Seq_rec.MR_ROUTE_ID<>FND_API.G_MISS_NUM
447: OR p_mr_route_Seq_rec.related_mr_route_id IS NOT NULL OR p_mr_route_Seq_rec.related_mr_route_id<>FND_API.G_MISS_NUM
448: OR p_mr_route_Seq_rec.sequence_code IS NOT NULL OR p_mr_route_Seq_rec.sequence_code<>FND_API.G_MISS_CHAR)
449: THEN
450:
451: IF p_mr_route_Seq_rec.sequence_code='BEFORE' and p_mr_route_Seq_rec.dml_operation<>'D'
452: THEN

Line 531: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

527: l_num_rec NUMBER;
528: l_msg_count NUMBER;
529: l_msg_data VARCHAR2(2000);
530: l_return_status VARCHAR2(1);
531: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
532: l_mr_header_id NUMBER:=0;
533: l_counter NUMBER:=0;
534: l_counter2 NUMBER:=0;
535: l_counter3 NUMBER:=0;

Line 542: x_return_status:=FND_API.G_RET_STS_SUCCESS;

538: l_lookup_code VARCHAR2(30):='';
539: l_check_flag VARCHAR2(1):='N';
540: BEGIN
541:
542: x_return_status:=FND_API.G_RET_STS_SUCCESS;
543: -- validation moved to main procedure
544: -- Changed for 11.5.10 Public API.
545: /*
546: IF (p_x_mr_route_seq_rec.MR_HEADER_ID IS NULL OR p_x_mr_route_seq_rec.MR_HEADER_ID=FND_API.G_MISS_NUM) AND p_x_mr_route_seq_rec.dml_operation<>'D'

Line 546: IF (p_x_mr_route_seq_rec.MR_HEADER_ID IS NULL OR p_x_mr_route_seq_rec.MR_HEADER_ID=FND_API.G_MISS_NUM) AND p_x_mr_route_seq_rec.dml_operation<>'D'

542: x_return_status:=FND_API.G_RET_STS_SUCCESS;
543: -- validation moved to main procedure
544: -- Changed for 11.5.10 Public API.
545: /*
546: IF (p_x_mr_route_seq_rec.MR_HEADER_ID IS NULL OR p_x_mr_route_seq_rec.MR_HEADER_ID=FND_API.G_MISS_NUM) AND p_x_mr_route_seq_rec.dml_operation<>'D'
547: THEN
548: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_NULL');
549: FND_MSG_PUB.ADD;
550: END IF;

Line 553: IF (p_x_mr_route_seq_rec.ROUTE_NUMBER IS NULL OR p_x_mr_route_seq_rec.ROUTE_NUMBER=FND_API.G_MISS_CHAR) AND p_x_mr_route_seq_rec.dml_operation<>'D'

549: FND_MSG_PUB.ADD;
550: END IF;
551: */
552:
553: IF (p_x_mr_route_seq_rec.ROUTE_NUMBER IS NULL OR p_x_mr_route_seq_rec.ROUTE_NUMBER=FND_API.G_MISS_CHAR) AND p_x_mr_route_seq_rec.dml_operation<>'D'
554: THEN
555: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_NUMBR_NULL');
556: FND_MSG_PUB.ADD;
557: ELSIF p_x_mr_route_seq_rec.dml_operation<>'D'

Line 584: IF l_route_id is not null or l_route_id<>fnd_api.g_miss_num

580: CLOSE get_route_frm;
581:
582: -- p_x_mr_route_seq_rec.route_id:=l_route_id;
583:
584: IF l_route_id is not null or l_route_id<>fnd_api.g_miss_num
585: THEN
586: Select count(MR_ROUTE_ID) into l_counter
587: From AHL_MR_ROUTES_APP_V
588: Where ROUTE_ID=l_route_id

Line 593: p_x_mr_route_seq_rec.related_mr_route_id<>fnd_api.g_miss_num)

589: And MR_HEADER_ID=p_x_mr_route_seq_rec.mr_header_id;
590:
591: IF l_counter>1 and
592: (p_x_mr_route_seq_rec.related_mr_route_id is not null OR
593: p_x_mr_route_seq_rec.related_mr_route_id<>fnd_api.g_miss_num)
594: THEN
595: select count(*) into l_counter3
596: from ahl_mr_routes_APP_V
597: where mr_header_id=p_x_mr_route_seq_rec.mr_header_id

Line 636: OR p_x_mr_route_seq_rec.RELATED_MR_ROUTE_ID =FND_API.G_MISS_NUM)

632: END IF;
633: END IF;
634:
635: IF (p_x_mr_route_seq_rec.RELATED_MR_ROUTE_ID IS NULL
636: OR p_x_mr_route_seq_rec.RELATED_MR_ROUTE_ID =FND_API.G_MISS_NUM)
637: AND p_x_mr_route_seq_rec.dml_operation<>'D'
638: THEN
639: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_ID_NULL');
640: FND_MESSAGE.SET_TOKEN('RECORD',p_x_mr_route_seq_rec.ROUTE_NUMBER ,false);

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

644:
645: PROCEDURE NON_CYCLIC_ENF
646: (
647: p_api_version IN NUMBER:=1.0,
648: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE ,
649: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
650: p_module_type IN VARCHAR2:='JSP',
651: x_return_status OUT NOCOPY VARCHAR2,
652: x_msg_count OUT NOCOPY NUMBER,

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

645: PROCEDURE NON_CYCLIC_ENF
646: (
647: p_api_version IN NUMBER:=1.0,
648: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE ,
649: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
650: p_module_type IN VARCHAR2:='JSP',
651: x_return_status OUT NOCOPY VARCHAR2,
652: x_msg_count OUT NOCOPY NUMBER,
653: x_msg_data OUT NOCOPY VARCHAR2,

Line 663: x_return_status:=FND_API.G_RET_STS_SUCCESS;

659: l_cyclic_loop EXCEPTION;
660: PRAGMA EXCEPTION_INIT(l_cyclic_loop,-1436);
661: l_counter NUMBER;
662: BEGIN
663: x_return_status:=FND_API.G_RET_STS_SUCCESS;
664:
665: SELECT COUNT(*) INTO l_counter
666: FROM AHL_MR_ROUTE_SEQUENCES A
667: WHERE MR_ROUTE_ID IN(SELECT MR_ROUTE_ID FROM AHL_MR_ROUTES_APP_V

Line 677: x_return_status := FND_API.G_RET_STS_ERROR;

673: WHEN l_cyclic_loop THEN
674: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTENO_INVALID_CYC');
675: FND_MESSAGE.SET_TOKEN('RECORD',p_mr_ROUTE_NUMBER ,false);
676: FND_MSG_PUB.ADD;
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
681: p_count => x_msg_count,

Line 678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

674: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTENO_INVALID_CYC');
675: FND_MESSAGE.SET_TOKEN('RECORD',p_mr_ROUTE_NUMBER ,false);
676: FND_MSG_PUB.ADD;
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
681: p_count => x_msg_count,
682: p_data => x_msg_data);

Line 679: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

675: FND_MESSAGE.SET_TOKEN('RECORD',p_mr_ROUTE_NUMBER ,false);
676: FND_MSG_PUB.ADD;
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
681: p_count => x_msg_count,
682: p_data => x_msg_data);
683:

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

676: FND_MSG_PUB.ADD;
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
681: p_count => x_msg_count,
682: p_data => x_msg_data);
683:
684: WHEN FND_API.G_EXC_ERROR THEN

Line 684: WHEN FND_API.G_EXC_ERROR THEN

680: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
681: p_count => x_msg_count,
682: p_data => x_msg_data);
683:
684: WHEN FND_API.G_EXC_ERROR THEN
685: X_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => X_msg_data);

Line 685: X_return_status := FND_API.G_RET_STS_ERROR;

681: p_count => x_msg_count,
682: p_data => x_msg_data);
683:
684: WHEN FND_API.G_EXC_ERROR THEN
685: X_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => X_msg_data);
689: WHEN OTHERS THEN

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

682: p_data => x_msg_data);
683:
684: WHEN FND_API.G_EXC_ERROR THEN
685: X_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => X_msg_data);
689: WHEN OTHERS THEN
690: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 690: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

686: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => X_msg_data);
689: WHEN OTHERS THEN
690: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
692: THEN
693: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_MR_ASSOCIATIONS_PVT',
694: p_procedure_name => 'NON_CYCLIC_ENF',

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

693: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_MR_ASSOCIATIONS_PVT',
694: p_procedure_name => 'NON_CYCLIC_ENF',
695: p_error_text => SUBSTR(SQLERRM,1,240));
696: END IF;
697: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
698: p_count => x_msg_count,
699: p_data => X_msg_data);
700: END;
701:

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

702:
703: PROCEDURE PROCESS_MR_ROUTE_SEQ
704: (
705: p_api_version IN NUMBER := 1.0,
706: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
707: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
708: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
709: p_default IN VARCHAR2 := FND_API.G_FALSE,
710: p_module_type IN VARCHAR2 := NULL,

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

703: PROCEDURE PROCESS_MR_ROUTE_SEQ
704: (
705: p_api_version IN NUMBER := 1.0,
706: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
707: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
708: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
709: p_default IN VARCHAR2 := FND_API.G_FALSE,
710: p_module_type IN VARCHAR2 := NULL,
711: x_return_status OUT NOCOPY VARCHAR2,

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

704: (
705: p_api_version IN NUMBER := 1.0,
706: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
707: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
708: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
709: p_default IN VARCHAR2 := FND_API.G_FALSE,
710: p_module_type IN VARCHAR2 := NULL,
711: x_return_status OUT NOCOPY VARCHAR2,
712: x_msg_count OUT NOCOPY NUMBER,

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

705: p_api_version IN NUMBER := 1.0,
706: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
707: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
708: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
709: p_default IN VARCHAR2 := FND_API.G_FALSE,
710: p_module_type IN VARCHAR2 := NULL,
711: x_return_status OUT NOCOPY VARCHAR2,
712: x_msg_count OUT NOCOPY NUMBER,
713: x_msg_data OUT NOCOPY VARCHAR2,

Line 734: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;

730: l_num_rec NUMBER;
731: l_msg_count NUMBER;
732: l_msg_data VARCHAR2(2000);
733: l_return_status VARCHAR2(1);
734: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;
735: l_commit VARCHAR2(1):= FND_API.G_FALSE;
736: l_MR_ROUTE_SEQ_ID NUMBER:=0;
737: l_mr_route_seq_tbl MR_route_SEQ_TBL:=p_x_mr_route_seq_tbl;
738: l_mr_route_seq_rec MR_ROUTE_SEQ_REC;

Line 735: l_commit VARCHAR2(1):= FND_API.G_FALSE;

731: l_msg_count NUMBER;
732: l_msg_data VARCHAR2(2000);
733: l_return_status VARCHAR2(1);
734: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;
735: l_commit VARCHAR2(1):= FND_API.G_FALSE;
736: l_MR_ROUTE_SEQ_ID NUMBER:=0;
737: l_mr_route_seq_tbl MR_route_SEQ_TBL:=p_x_mr_route_seq_tbl;
738: l_mr_route_seq_rec MR_ROUTE_SEQ_REC;
739: l_mr_route_id NUMBER:=0;

Line 748: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

744:
745: SAVEPOINT PROCESS_MR_ROUTE_SEQ;
746:
747: -- Standard call to check for call compatibility.
748: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
749: p_api_version,
750: l_api_name,G_PKG_NAME) THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: END IF;

Line 751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

747: -- Standard call to check for call compatibility.
748: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
749: p_api_version,
750: l_api_name,G_PKG_NAME) THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: END IF;
753:
754: -- Initialize message list if p_init_msg_list is set to TRUE.
755: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 755: IF FND_API.to_boolean(p_init_msg_list) THEN

751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: END IF;
753:
754: -- Initialize message list if p_init_msg_list is set to TRUE.
755: IF FND_API.to_boolean(p_init_msg_list) THEN
756: FND_MSG_PUB.initialize;
757: END IF;
758:
759: -- Debug info.

Line 769: x_return_status := FND_API.G_RET_STS_SUCCESS;

765:
766:
767: -- Initialize API return status to success
768:
769: x_return_status := FND_API.G_RET_STS_SUCCESS;
770:
771:
772: --Start of API Body
773:

Line 781: p_x_mr_route_seq_tbl(i).mr_header_id = FND_API.G_MISS_NUM

777: -- Added the code for public API.
778: -- code for Value_To_ID conversion for parent MR.
779: IF (
780: p_x_mr_route_seq_tbl(i).mr_header_id IS NULL OR
781: p_x_mr_route_seq_tbl(i).mr_header_id = FND_API.G_MISS_NUM
782: )
783: THEN
784: -- Function to convert mr_title,mr_version_number to id
785: AHL_FMP_COMMON_PVT.mr_title_version_to_id(

Line 791: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

787: p_mr_version_number => p_x_mr_route_seq_tbl(i).mr_version_number,
788: x_mr_header_id => p_x_mr_route_seq_tbl(i).mr_header_id,
789: x_return_status => x_return_status
790: );
791: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
792: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
793: fnd_log.string
794: (
795: fnd_log.level_statement,

Line 800: RAISE FND_API.G_EXC_ERROR;

796: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
797: 'Invalid MR Title, Version Number provided'
798: );
799: END IF;
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802: END IF;
803:
804: if p_x_mr_route_seq_tbl(i).DML_OPERATION='C'

Line 813: p_x_mr_route_seq_tbl(i).mr_route_id = FND_API.G_MISS_NUM

809: -- Code for getting mr_route_id if one is not provided.
810: -- Added in 11.5.10 for public API.
811: IF (
812: p_x_mr_route_seq_tbl(i).mr_route_id IS NULL OR
813: p_x_mr_route_seq_tbl(i).mr_route_id = FND_API.G_MISS_NUM
814: )
815: AND
816: (
817: p_x_mr_route_seq_tbl(i).dml_operation<>'D' AND

Line 828: x_return_status := FND_API.G_RET_STS_ERROR;

824: );
825: FETCH get_mr_route_id_type INTO p_x_mr_route_seq_tbl(i).mr_route_id;
826: IF p_x_mr_route_seq_tbl(i).mr_route_id IS NULL
827: THEN
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_NUMBR_INVALID');
830: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_route_seq_tbl(i).mr_route_number);
831: FND_MSG_PUB.ADD;
832: CLOSE get_mr_route_id_type;

Line 833: RAISE FND_API.G_EXC_ERROR;

829: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_NUMBR_INVALID');
830: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_route_seq_tbl(i).mr_route_number);
831: FND_MSG_PUB.ADD;
832: CLOSE get_mr_route_id_type;
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;
835: CLOSE get_mr_route_id_type;
836: END IF;
837:

Line 857: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

853: END LOOP;
854: l_msg_count := FND_MSG_PUB.count_msg;
855: IF l_msg_count > 0 THEN
856: X_msg_count := l_msg_count;
857: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:
861: IF FND_API.to_boolean(p_default)

Line 858: RAISE FND_API.G_EXC_ERROR;

854: l_msg_count := FND_MSG_PUB.count_msg;
855: IF l_msg_count > 0 THEN
856: X_msg_count := l_msg_count;
857: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:
861: IF FND_API.to_boolean(p_default)
862: THEN

Line 861: IF FND_API.to_boolean(p_default)

857: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:
861: IF FND_API.to_boolean(p_default)
862: THEN
863: DEFAULT_MISSING_ATTRIBS
864: (
865: p_x_mr_routeseq_tbl =>p_x_mr_route_seq_tbl

Line 873: x_return_status := FND_API.G_RET_STS_SUCCESS;

869:
870: FOR i IN P_X_MR_ROUTE_SEQ_TBL.FIRST.. P_X_MR_ROUTE_SEQ_TBL.LAST
871: LOOP
872:
873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875: IF G_DEBUG='Y' THEN
876: AHL_DEBUG_PUB.debug( '<---MR ROUTE_ID---> ',TO_CHAR(p_x_mr_route_seq_tbl(i).mr_route_id));
877: AHL_DEBUG_PUB.debug( '<---RELATED MR ROUTE_ID---> ',TO_CHAR(p_x_mr_route_seq_tbl(i).related_mr_route_id));

Line 882: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )

878: END IF;
879:
880: l_mr_route_seq_rec:=P_X_MR_ROUTE_SEQ_TBL(I);
881:
882: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
883: THEN
884:
885: IF G_DEBUG='Y' THEN
886: AHL_DEBUG_PUB.debug( 'Enter Validations level');

Line 1017: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1013: -- TAMAL
1014: l_msg_count := FND_MSG_PUB.count_msg;
1015: IF l_msg_count > 0 THEN
1016: X_msg_count := l_msg_count;
1017: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;
1020:
1021:

Line 1018: RAISE FND_API.G_EXC_ERROR;

1014: l_msg_count := FND_MSG_PUB.count_msg;
1015: IF l_msg_count > 0 THEN
1016: X_msg_count := l_msg_count;
1017: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;
1020:
1021:
1022: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 1022: IF FND_API.TO_BOOLEAN(p_commit) THEN

1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;
1020:
1021:
1022: IF FND_API.TO_BOOLEAN(p_commit) THEN
1023: COMMIT;
1024: END IF;
1025: -- Debug info
1026:

Line 1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1034: AHL_DEBUG_PUB.disable_debug;
1035: END IF;
1036:
1037: EXCEPTION
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: ROLLBACK TO PROCESS_MR_ROUTE_SEQ;
1040: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1042: p_count => x_msg_count,

Line 1040: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1036:
1037: EXCEPTION
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: ROLLBACK TO PROCESS_MR_ROUTE_SEQ;
1040: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1042: p_count => x_msg_count,
1043: p_data => x_msg_data);
1044:

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

1037: EXCEPTION
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: ROLLBACK TO PROCESS_MR_ROUTE_SEQ;
1040: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1042: p_count => x_msg_count,
1043: p_data => x_msg_data);
1044:
1045: WHEN FND_API.G_EXC_ERROR THEN

Line 1045: WHEN FND_API.G_EXC_ERROR THEN

1041: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1042: p_count => x_msg_count,
1043: p_data => x_msg_data);
1044:
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: ROLLBACK TO PROCESS_MR_ROUTE_SEQ;
1047: X_return_status := FND_API.G_RET_STS_ERROR;
1048: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1049: p_count => x_msg_count,

Line 1047: X_return_status := FND_API.G_RET_STS_ERROR;

1043: p_data => x_msg_data);
1044:
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: ROLLBACK TO PROCESS_MR_ROUTE_SEQ;
1047: X_return_status := FND_API.G_RET_STS_ERROR;
1048: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1049: p_count => x_msg_count,
1050: p_data => X_msg_data);
1051: WHEN OTHERS THEN

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

1044:
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: ROLLBACK TO PROCESS_MR_ROUTE_SEQ;
1047: X_return_status := FND_API.G_RET_STS_ERROR;
1048: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1049: p_count => x_msg_count,
1050: p_data => X_msg_data);
1051: WHEN OTHERS THEN
1052: ROLLBACK TO PROCESS_MR_ROUTE_SEQ;

Line 1053: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1049: p_count => x_msg_count,
1050: p_data => X_msg_data);
1051: WHEN OTHERS THEN
1052: ROLLBACK TO PROCESS_MR_ROUTE_SEQ;
1053: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1054:
1055: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1056: THEN
1057: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_ROUTE_SEQNCE_PVT',

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

1057: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_ROUTE_SEQNCE_PVT',
1058: p_procedure_name => 'PROCESS_MR_ROUTE_SEQ',
1059: p_error_text => SUBSTR(SQLERRM,1,240));
1060: END IF;
1061: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1062: p_count => x_msg_count,
1063: p_data => X_msg_data);
1064: END;
1065: