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

Line 57: IF P_X_MR_ROUTE_TBL(I).MR_ROUTE_ID= FND_API.G_MISS_NUM

53: open CurGetRouteDet(P_X_MR_ROUTE_TBL(I).MR_ROUTE_ID);
54: fetch CurGetRouteDet into l_mr_route_Rec;
55: close CurGetRouteDet;
56:
57: IF P_X_MR_ROUTE_TBL(I).MR_ROUTE_ID= FND_API.G_MISS_NUM
58: THEN
59: P_X_MR_ROUTE_TBL(I).MR_ROUTE_ID:=NULL;
60: ELSIF P_X_MR_ROUTE_TBL(I).MR_ROUTE_ID IS NULL
61: THEN

Line 64: IF P_X_MR_ROUTE_TBL(I).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM

60: ELSIF P_X_MR_ROUTE_TBL(I).MR_ROUTE_ID IS NULL
61: THEN
62: P_X_MR_ROUTE_TBL(I).MR_ROUTE_ID:=l_mr_route_rec.MR_ROUTE_ID;
63: END IF;
64: IF P_X_MR_ROUTE_TBL(I).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM
65: THEN
66: P_X_MR_ROUTE_TBL(I).OBJECT_VERSION_NUMBER:=NULL;
67: ELSIF P_X_MR_ROUTE_TBL(I).OBJECT_VERSION_NUMBER IS NULL
68: THEN

Line 71: IF P_X_MR_ROUTE_TBL(I).MR_HEADER_ID= FND_API.G_MISS_NUM

67: ELSIF P_X_MR_ROUTE_TBL(I).OBJECT_VERSION_NUMBER IS NULL
68: THEN
69: P_X_MR_ROUTE_TBL(I).OBJECT_VERSION_NUMBER:=l_mr_route_rec.OBJECT_VERSION_NUMBER;
70: END IF;
71: IF P_X_MR_ROUTE_TBL(I).MR_HEADER_ID= FND_API.G_MISS_NUM
72: THEN
73: P_X_MR_ROUTE_TBL(I).MR_HEADER_ID:=NULL;
74: ELSIF P_X_MR_ROUTE_TBL(I).MR_HEADER_ID IS NULL
75: THEN

Line 78: IF P_X_MR_ROUTE_TBL(I).ROUTE_ID= FND_API.G_MISS_NUM

74: ELSIF P_X_MR_ROUTE_TBL(I).MR_HEADER_ID IS NULL
75: THEN
76: P_X_MR_ROUTE_TBL(I).MR_HEADER_ID:=l_mr_route_rec.MR_HEADER_ID;
77: END IF;
78: IF P_X_MR_ROUTE_TBL(I).ROUTE_ID= FND_API.G_MISS_NUM
79: THEN
80: P_X_MR_ROUTE_TBL(I).ROUTE_ID:=NULL;
81: ELSIF P_X_MR_ROUTE_TBL(I).ROUTE_ID IS NULL
82: THEN

Line 85: IF P_X_MR_ROUTE_TBL(I).ROUTE_NUMBER= FND_API.G_MISS_CHAR

81: ELSIF P_X_MR_ROUTE_TBL(I).ROUTE_ID IS NULL
82: THEN
83: P_X_MR_ROUTE_TBL(I).ROUTE_ID:=l_mr_route_rec.ROUTE_ID;
84: END IF;
85: IF P_X_MR_ROUTE_TBL(I).ROUTE_NUMBER= FND_API.G_MISS_CHAR
86: THEN
87: P_X_MR_ROUTE_TBL(I).ROUTE_NUMBER:=NULL;
88: ELSIF P_X_MR_ROUTE_TBL(I).ROUTE_NUMBER IS NULL
89: THEN

Line 93: IF P_X_MR_ROUTE_TBL(I).ROUTE_REVISION_NUMBER= FND_API.G_MISS_NUM

89: THEN
90: P_X_MR_ROUTE_TBL(I).ROUTE_NUMBER:=l_mr_route_rec.ROUTE_NUMBER;
91: END IF;
92: /*
93: IF P_X_MR_ROUTE_TBL(I).ROUTE_REVISION_NUMBER= FND_API.G_MISS_NUM
94: THEN
95: P_X_MR_ROUTE_TBL(I).ROUTE_REVISION_NUMBER:=NULL;
96: ELSIF P_X_MR_ROUTE_TBL(I).ROUTE_REVISION_NUMBER IS NULL
97: THEN

Line 101: IF P_X_MR_ROUTE_TBL(I).ROUTE_DESCRIPTION= FND_API.G_MISS_CHAR

97: THEN
98: P_X_MR_ROUTE_TBL(I).ROUTE_REVISION_NUMBER:=l_mr_route_rec.ROUTE_REVISION_NUMBER;
99: END IF;
100: */
101: IF P_X_MR_ROUTE_TBL(I).ROUTE_DESCRIPTION= FND_API.G_MISS_CHAR
102: THEN
103: P_X_MR_ROUTE_TBL(I).ROUTE_DESCRIPTION:=NULL;
104: ELSIF P_X_MR_ROUTE_TBL(I).ROUTE_DESCRIPTION IS NULL
105: THEN

Line 108: IF P_X_MR_ROUTE_TBL(I).PRODUCT_TYPE= FND_API.G_MISS_CHAR

104: ELSIF P_X_MR_ROUTE_TBL(I).ROUTE_DESCRIPTION IS NULL
105: THEN
106: P_X_MR_ROUTE_TBL(I).ROUTE_DESCRIPTION:=l_mr_route_rec.ROUTE_DESCRIPTION;
107: END IF;
108: IF P_X_MR_ROUTE_TBL(I).PRODUCT_TYPE= FND_API.G_MISS_CHAR
109: THEN
110: P_X_MR_ROUTE_TBL(I).PRODUCT_TYPE:=NULL;
111: ELSIF P_X_MR_ROUTE_TBL(I).PRODUCT_TYPE IS NULL
112: THEN

Line 115: IF P_X_MR_ROUTE_TBL(I).OPERATOR= FND_API.G_MISS_CHAR

111: ELSIF P_X_MR_ROUTE_TBL(I).PRODUCT_TYPE IS NULL
112: THEN
113: P_X_MR_ROUTE_TBL(I).PRODUCT_TYPE:=l_mr_route_rec.PRODUCT_TYPE;
114: END IF;
115: IF P_X_MR_ROUTE_TBL(I).OPERATOR= FND_API.G_MISS_CHAR
116: THEN
117: P_X_MR_ROUTE_TBL(I).OPERATOR:=NULL;
118: ELSIF P_X_MR_ROUTE_TBL(I).OPERATOR IS NULL
119: THEN

Line 122: IF P_X_MR_ROUTE_TBL(I).STAGE= FND_API.G_MISS_NUM

118: ELSIF P_X_MR_ROUTE_TBL(I).OPERATOR IS NULL
119: THEN
120: P_X_MR_ROUTE_TBL(I).OPERATOR:=l_mr_route_rec.OPERATOR;
121: END IF;
122: IF P_X_MR_ROUTE_TBL(I).STAGE= FND_API.G_MISS_NUM
123: THEN
124: P_X_MR_ROUTE_TBL(I).STAGE:=NULL;
125: ELSIF P_X_MR_ROUTE_TBL(I).STAGE IS NULL
126: THEN

Line 129: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR

125: ELSIF P_X_MR_ROUTE_TBL(I).STAGE IS NULL
126: THEN
127: P_X_MR_ROUTE_TBL(I).STAGE:=l_mr_route_rec.STAGE;
128: END IF;
129: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR
130: THEN
131: P_X_MR_ROUTE_TBL(I).ATTRIBUTE_CATEGORY:=NULL;
132: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE_CATEGORY IS NULL
133: THEN

Line 136: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE1= FND_API.G_MISS_CHAR

132: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE_CATEGORY IS NULL
133: THEN
134: P_X_MR_ROUTE_TBL(I).ATTRIBUTE_CATEGORY:=l_mr_route_rec.ATTRIBUTE_CATEGORY;
135: END IF;
136: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE1= FND_API.G_MISS_CHAR
137: THEN
138: P_X_MR_ROUTE_TBL(I).ATTRIBUTE1:=NULL;
139: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE1 IS NULL
140: THEN

Line 143: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE2= FND_API.G_MISS_CHAR

139: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE1 IS NULL
140: THEN
141: P_X_MR_ROUTE_TBL(I).ATTRIBUTE1:=l_mr_route_rec.ATTRIBUTE1;
142: END IF;
143: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE2= FND_API.G_MISS_CHAR
144: THEN
145: P_X_MR_ROUTE_TBL(I).ATTRIBUTE2:=NULL;
146: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE2 IS NULL
147: THEN

Line 150: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE3= FND_API.G_MISS_CHAR

146: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE2 IS NULL
147: THEN
148: P_X_MR_ROUTE_TBL(I).ATTRIBUTE2:=l_mr_route_rec.ATTRIBUTE2;
149: END IF;
150: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE3= FND_API.G_MISS_CHAR
151: THEN
152: P_X_MR_ROUTE_TBL(I).ATTRIBUTE3:=NULL;
153: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE3 IS NULL
154: THEN

Line 157: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE4= FND_API.G_MISS_CHAR

153: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE3 IS NULL
154: THEN
155: P_X_MR_ROUTE_TBL(I).ATTRIBUTE3:=l_mr_route_rec.ATTRIBUTE3;
156: END IF;
157: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE4= FND_API.G_MISS_CHAR
158: THEN
159: P_X_MR_ROUTE_TBL(I).ATTRIBUTE4:=NULL;
160: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE4 IS NULL
161: THEN

Line 164: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE5= FND_API.G_MISS_CHAR

160: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE4 IS NULL
161: THEN
162: P_X_MR_ROUTE_TBL(I).ATTRIBUTE4:=l_mr_route_rec.ATTRIBUTE4;
163: END IF;
164: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE5= FND_API.G_MISS_CHAR
165: THEN
166: P_X_MR_ROUTE_TBL(I).ATTRIBUTE5:=NULL;
167: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE5 IS NULL
168: THEN

Line 171: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE6= FND_API.G_MISS_CHAR

167: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE5 IS NULL
168: THEN
169: P_X_MR_ROUTE_TBL(I).ATTRIBUTE5:=l_mr_route_rec.ATTRIBUTE5;
170: END IF;
171: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE6= FND_API.G_MISS_CHAR
172: THEN
173: P_X_MR_ROUTE_TBL(I).ATTRIBUTE6:=NULL;
174: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE6 IS NULL
175: THEN

Line 178: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE7= FND_API.G_MISS_CHAR

174: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE6 IS NULL
175: THEN
176: P_X_MR_ROUTE_TBL(I).ATTRIBUTE6:=l_mr_route_rec.ATTRIBUTE6;
177: END IF;
178: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE7= FND_API.G_MISS_CHAR
179: THEN
180: P_X_MR_ROUTE_TBL(I).ATTRIBUTE7:=NULL;
181: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE7 IS NULL
182: THEN

Line 185: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE8= FND_API.G_MISS_CHAR

181: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE7 IS NULL
182: THEN
183: P_X_MR_ROUTE_TBL(I).ATTRIBUTE7:=l_mr_route_rec.ATTRIBUTE7;
184: END IF;
185: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE8= FND_API.G_MISS_CHAR
186: THEN
187: P_X_MR_ROUTE_TBL(I).ATTRIBUTE8:=NULL;
188: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE8 IS NULL
189: THEN

Line 192: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE9= FND_API.G_MISS_CHAR

188: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE8 IS NULL
189: THEN
190: P_X_MR_ROUTE_TBL(I).ATTRIBUTE8:=l_mr_route_rec.ATTRIBUTE8;
191: END IF;
192: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE9= FND_API.G_MISS_CHAR
193: THEN
194: P_X_MR_ROUTE_TBL(I).ATTRIBUTE9:=NULL;
195: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE9 IS NULL
196: THEN

Line 199: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE10= FND_API.G_MISS_CHAR

195: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE9 IS NULL
196: THEN
197: P_X_MR_ROUTE_TBL(I).ATTRIBUTE9:=l_mr_route_rec.ATTRIBUTE9;
198: END IF;
199: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE10= FND_API.G_MISS_CHAR
200: THEN
201: P_X_MR_ROUTE_TBL(I).ATTRIBUTE10:=NULL;
202: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE10 IS NULL
203: THEN

Line 206: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE11= FND_API.G_MISS_CHAR

202: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE10 IS NULL
203: THEN
204: P_X_MR_ROUTE_TBL(I).ATTRIBUTE10:=l_mr_route_rec.ATTRIBUTE10;
205: END IF;
206: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE11= FND_API.G_MISS_CHAR
207: THEN
208: P_X_MR_ROUTE_TBL(I).ATTRIBUTE11:=NULL;
209: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE11 IS NULL
210: THEN

Line 213: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE12= FND_API.G_MISS_CHAR

209: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE11 IS NULL
210: THEN
211: P_X_MR_ROUTE_TBL(I).ATTRIBUTE11:=l_mr_route_rec.ATTRIBUTE11;
212: END IF;
213: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE12= FND_API.G_MISS_CHAR
214: THEN
215: P_X_MR_ROUTE_TBL(I).ATTRIBUTE12:=NULL;
216: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE12 IS NULL
217: THEN

Line 220: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE13= FND_API.G_MISS_CHAR

216: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE12 IS NULL
217: THEN
218: P_X_MR_ROUTE_TBL(I).ATTRIBUTE12:=l_mr_route_rec.ATTRIBUTE12;
219: END IF;
220: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE13= FND_API.G_MISS_CHAR
221: THEN
222: P_X_MR_ROUTE_TBL(I).ATTRIBUTE13:=NULL;
223: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE13 IS NULL
224: THEN

Line 227: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE14= FND_API.G_MISS_CHAR

223: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE13 IS NULL
224: THEN
225: P_X_MR_ROUTE_TBL(I).ATTRIBUTE13:=l_mr_route_rec.ATTRIBUTE13;
226: END IF;
227: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE14= FND_API.G_MISS_CHAR
228: THEN
229: P_X_MR_ROUTE_TBL(I).ATTRIBUTE14:=NULL;
230: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE14 IS NULL
231: THEN

Line 235: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE15= FND_API.G_MISS_CHAR

231: THEN
232: P_X_MR_ROUTE_TBL(I).ATTRIBUTE14:=l_mr_route_rec.ATTRIBUTE14;
233: END IF;
234:
235: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE15= FND_API.G_MISS_CHAR
236: THEN
237: P_X_MR_ROUTE_TBL(I).ATTRIBUTE15:=NULL;
238: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE15 IS NULL
239: THEN

Line 279: x_return_status:=FND_API.G_RET_STS_SUCCESS;

275: AND REVISION_STATUS_CODE='COMPLETE';*/
276:
277: l_route_rec get_route_frm%rowtype;
278: BEGIN
279: x_return_status:=FND_API.G_RET_STS_SUCCESS;
280: IF G_DEBUG='Y' THEN
281: AHL_DEBUG_PUB.enable_debug;
282: AHL_DEBUG_PUB.debug( 'Route Revision number'||p_x_mr_route_rec.route_revision_number);
283: END IF;

Line 286: p_x_mr_route_rec.route_number=FND_API.G_MISS_CHAR) and

282: AHL_DEBUG_PUB.debug( 'Route Revision number'||p_x_mr_route_rec.route_revision_number);
283: END IF;
284:
285: IF (p_x_mr_route_rec.route_number IS NULL or
286: p_x_mr_route_rec.route_number=FND_API.G_MISS_CHAR) and
287: p_x_mr_route_rec.dml_operation<>'D'
288: THEN
289: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_NUMBR_NULL');
290: FND_MSG_PUB.ADD;

Line 338: x_return_status:=FND_API.G_RET_STS_SUCCESS;

334: l_route_type varchar2(30);
335: -- Tamal [MEL/CDL] -- End changes
336:
337: BEGIN
338: x_return_status:=FND_API.G_RET_STS_SUCCESS;
339:
340: IF G_APPLN_USAGE IS NULL
341: THEN
342: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');

Line 349: IF (p_mr_route_rec.route_revision_number IS NULL OR p_mr_route_rec.route_revision_number=FND_API.G_MISS_NUM) AND p_mr_route_rec.dml_operation<>'D'

345: END IF;
346:
347: -- AHL_FMP_MR_SELCT_RT_FROM_LOV (ROUTE_NUMBER
348:
349: IF (p_mr_route_rec.route_revision_number IS NULL OR p_mr_route_rec.route_revision_number=FND_API.G_MISS_NUM) AND p_mr_route_rec.dml_operation<>'D'
350: THEN
351: --AMSRINIV : Bug 4913924 . Below commented query tuned.
352: SELECT
353: COUNT(*) into l_counter

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

373: END IF;
374: END IF;
375:
376:
377: IF (p_mr_route_rec.MR_HEADER_ID IS NULL OR p_mr_route_rec.MR_HEADER_ID=FND_API.G_MISS_NUM) AND p_mr_route_rec.dml_operation<>'D'
378: THEN
379: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_NULL');
380: FND_MSG_PUB.ADD;
381: ELSE

Line 404: IF (p_mr_route_rec.OBJECT_VERSION_NUMBER IS NULL OR p_mr_route_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_num) and p_mr_route_rec.dml_operation<>'C'

400: END IF;
401: CLOSE GetMrDet;
402: END IF;
403:
404: IF (p_mr_route_rec.OBJECT_VERSION_NUMBER IS NULL OR p_mr_route_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_num) and p_mr_route_rec.dml_operation<>'C'
405: THEN
406: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRR_OBJ_VERSION_NULL');
407: FND_MESSAGE.SET_TOKEN('RECORD',p_mr_route_rec.route_number,false);
408: FND_MSG_PUB.ADD;

Line 411: IF (p_mr_route_rec.MR_ROUTE_ID IS NULL OR p_mr_route_rec.MR_ROUTE_ID=FND_API.G_MISS_NUM) AND p_mr_route_rec.dml_operation<>'C'

407: FND_MESSAGE.SET_TOKEN('RECORD',p_mr_route_rec.route_number,false);
408: FND_MSG_PUB.ADD;
409: END IF;
410:
411: IF (p_mr_route_rec.MR_ROUTE_ID IS NULL OR p_mr_route_rec.MR_ROUTE_ID=FND_API.G_MISS_NUM) AND p_mr_route_rec.dml_operation<>'C'
412: THEN
413: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_ID_NULL');
414: FND_MESSAGE.SET_TOKEN('RECORD',p_mr_route_rec.ROUTE_NUMBER,false);
415: FND_MSG_PUB.ADD;

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

444:
445: PROCEDURE PROCESS_MR_ROUTE
446: (
447: p_api_version IN NUMBER := 1.0,
448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
449: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
450: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
451: p_default IN VARCHAR2 := FND_API.G_FALSE,
452: p_module_type IN VARCHAR2 := NULL,

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

445: PROCEDURE PROCESS_MR_ROUTE
446: (
447: p_api_version IN NUMBER := 1.0,
448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
449: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
450: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
451: p_default IN VARCHAR2 := FND_API.G_FALSE,
452: p_module_type IN VARCHAR2 := NULL,
453: x_return_status OUT NOCOPY VARCHAR2,

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

446: (
447: p_api_version IN NUMBER := 1.0,
448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
449: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
450: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
451: p_default IN VARCHAR2 := FND_API.G_FALSE,
452: p_module_type IN VARCHAR2 := NULL,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,

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

447: p_api_version IN NUMBER := 1.0,
448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
449: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
450: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
451: p_default IN VARCHAR2 := FND_API.G_FALSE,
452: p_module_type IN VARCHAR2 := NULL,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,

Line 481: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

477: SAVEPOINT PROCESS_MR_ROUTES_PVT;
478:
479: -- Standard call to check for call compatibility.
480:
481: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
482: p_api_version,
483: l_api_name,G_PKG_NAME) THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;

Line 484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

480:
481: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
482: p_api_version,
483: l_api_name,G_PKG_NAME) THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;
486:
487: -- Initialize message list if p_init_msg_list is set to TRUE.
488:

Line 489: IF FND_API.to_boolean(p_init_msg_list) THEN

485: END IF;
486:
487: -- Initialize message list if p_init_msg_list is set to TRUE.
488:
489: IF FND_API.to_boolean(p_init_msg_list) THEN
490: FND_MSG_PUB.initialize;
491: END IF;
492:
493: -- Enable Debug

Line 504: x_return_status := FND_API.G_RET_STS_SUCCESS;

500:
501:
502: -- Initialize API return status to success
503:
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:
506: IF FND_API.to_boolean(p_default)
507: THEN
508: DEFAULT_MISSING_ATTRIBS

Line 506: IF FND_API.to_boolean(p_default)

502: -- Initialize API return status to success
503:
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:
506: IF FND_API.to_boolean(p_default)
507: THEN
508: DEFAULT_MISSING_ATTRIBS
509: (
510: p_x_mr_route_tbl =>p_x_mr_route_tbl

Line 521: p_x_mr_route_tbl(i).mr_header_id = FND_API.G_MISS_NUM

517:
518: -- code for Value_To_ID conversion for parent MR.
519: IF (
520: p_x_mr_route_tbl(i).mr_header_id IS NULL OR
521: p_x_mr_route_tbl(i).mr_header_id = FND_API.G_MISS_NUM
522: )
523: THEN
524: -- Function to convert mr_title,mr_version_number to id
525: AHL_FMP_COMMON_PVT.mr_title_version_to_id(

Line 531: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

527: p_mr_version_number => p_x_mr_route_tbl(i).mr_version_number,
528: x_mr_header_id => p_x_mr_route_tbl(i).mr_header_id,
529: x_return_status => x_return_status
530: );
531: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
532: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
533: fnd_log.string
534: (
535: fnd_log.level_statement,

Line 540: RAISE FND_API.G_EXC_ERROR;

536: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
537: 'Invalid MR Title, Version Number provided'
538: );
539: END IF;
540: RAISE FND_API.G_EXC_ERROR;
541: END IF;
542: END IF;
543:
544: -- If The Module Type is JSP then Null out the IDs for the attributes based on LOVs.

Line 554: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )

550: IF P_X_MR_ROUTE_TBL(I).DML_OPERATION<>'D'
551: THEN
552:
553: l_mr_route_rec:=p_x_MR_ROUTE_TBL(i);
554: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
555: THEN
556: IF P_X_MR_ROUTE_TBL(i).DML_OPERATION<>'D'
557: THEN
558:

Line 574: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

570:
571: l_msg_count := FND_MSG_PUB.count_msg;
572: IF l_msg_count > 0 THEN
573: X_msg_count := l_msg_count;
574: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: RAISE FND_API.G_EXC_ERROR;
576: END IF;
577:
578: FOR i IN P_X_MR_ROUTE_TBL.FIRST.. P_X_MR_ROUTE_TBL.LAST

Line 575: RAISE FND_API.G_EXC_ERROR;

571: l_msg_count := FND_MSG_PUB.count_msg;
572: IF l_msg_count > 0 THEN
573: X_msg_count := l_msg_count;
574: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: RAISE FND_API.G_EXC_ERROR;
576: END IF;
577:
578: FOR i IN P_X_MR_ROUTE_TBL.FIRST.. P_X_MR_ROUTE_TBL.LAST
579: LOOP

Line 581: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )

577:
578: FOR i IN P_X_MR_ROUTE_TBL.FIRST.. P_X_MR_ROUTE_TBL.LAST
579: LOOP
580: l_mr_route_rec:=p_x_MR_ROUTE_TBL(i);
581: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
582: THEN
583:
584: VALIDATE_MR_ROUTE
585: (

Line 706: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

702:
703: l_msg_count := FND_MSG_PUB.count_msg;
704: IF l_msg_count > 0 THEN
705: X_msg_count := l_msg_count;
706: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709:
710:

Line 707: RAISE FND_API.G_EXC_ERROR;

703: l_msg_count := FND_MSG_PUB.count_msg;
704: IF l_msg_count > 0 THEN
705: X_msg_count := l_msg_count;
706: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709:
710:
711: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 711: IF FND_API.TO_BOOLEAN(p_commit) THEN

707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709:
710:
711: IF FND_API.TO_BOOLEAN(p_commit) THEN
712: COMMIT;
713: END IF;
714:
715: IF G_DEBUG='Y' THEN

Line 720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

716: AHL_DEBUG_PUB.disable_debug;
717: END IF;
718:
719: EXCEPTION
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
722: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
724: p_count => x_msg_count,

Line 722: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

718:
719: EXCEPTION
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
722: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
724: p_count => x_msg_count,
725: p_data => x_msg_data);
726: IF G_DEBUG='Y' THEN

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

719: EXCEPTION
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
722: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
724: p_count => x_msg_count,
725: p_data => x_msg_data);
726: IF G_DEBUG='Y' THEN
727: AHL_DEBUG_PUB.disable_debug;

Line 731: WHEN FND_API.G_EXC_ERROR THEN

727: AHL_DEBUG_PUB.disable_debug;
728: END IF;
729:
730:
731: WHEN FND_API.G_EXC_ERROR THEN
732: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
733: X_return_status := FND_API.G_RET_STS_ERROR;
734: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
735: p_count => x_msg_count,

Line 733: X_return_status := FND_API.G_RET_STS_ERROR;

729:
730:
731: WHEN FND_API.G_EXC_ERROR THEN
732: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
733: X_return_status := FND_API.G_RET_STS_ERROR;
734: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
735: p_count => x_msg_count,
736: p_data => X_msg_data);
737: IF G_DEBUG='Y' THEN

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

730:
731: WHEN FND_API.G_EXC_ERROR THEN
732: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
733: X_return_status := FND_API.G_RET_STS_ERROR;
734: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
735: p_count => x_msg_count,
736: p_data => X_msg_data);
737: IF G_DEBUG='Y' THEN
738: AHL_DEBUG_PUB.disable_debug;

Line 743: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

739: END IF;
740:
741: WHEN OTHERS THEN
742: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
743: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
745: THEN
746: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_ROUTE_PVT',
747: p_procedure_name => 'PROCESS_MR_ROUTE',

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

746: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_ROUTE_PVT',
747: p_procedure_name => 'PROCESS_MR_ROUTE',
748: p_error_text => SUBSTR(SQLERRM,1,240));
749: END IF;
750: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
751: p_count => x_msg_count,
752: p_data => X_msg_data);
753: IF G_DEBUG='Y' THEN
754: AHL_DEBUG_PUB.disable_debug;