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 59: IF P_X_MR_ROUTE_TBL(I).MR_ROUTE_ID= FND_API.G_MISS_NUM

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 126: IF P_X_MR_ROUTE_TBL(I).STAGE_TYPE_CODE = FND_API.G_MISS_CHAR THEN

122: P_X_MR_ROUTE_TBL(I).OPERATOR:=l_mr_route_rec.OPERATOR;
123: END IF;
124:
125: --MANESING::VWP Enhancements, 21-Jan-2011, included changes for stage type code column
126: IF P_X_MR_ROUTE_TBL(I).STAGE_TYPE_CODE = FND_API.G_MISS_CHAR THEN
127: P_X_MR_ROUTE_TBL(I).STAGE_TYPE_CODE := NULL;
128: ELSIF P_X_MR_ROUTE_TBL(I).STAGE_TYPE_CODE IS NULL THEN
129: P_X_MR_ROUTE_TBL(I).STAGE_TYPE_CODE := l_mr_route_rec.STAGE_TYPE_CODE;
130: END IF;

Line 141: /*IF P_X_MR_ROUTE_TBL(I).STAGE= FND_API.G_MISS_NUM THEN

137: IF P_X_MR_ROUTE_TBL(I).STAGE_TYPE_CODE IS NOT NULL THEN
138: P_X_MR_ROUTE_TBL(I).STAGE := NULL;
139:
140: ELSE
141: /*IF P_X_MR_ROUTE_TBL(I).STAGE= FND_API.G_MISS_NUM THEN
142: P_X_MR_ROUTE_TBL(I).STAGE:=NULL; -- code commented since Stage cannot be updated
143: */
144: IF P_X_MR_ROUTE_TBL(I).STAGE IS NULL THEN
145: P_X_MR_ROUTE_TBL(I).STAGE := l_mr_route_rec.STAGE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

229: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE11 IS NULL
230: THEN
231: P_X_MR_ROUTE_TBL(I).ATTRIBUTE11:=l_mr_route_rec.ATTRIBUTE11;
232: END IF;
233: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE12= FND_API.G_MISS_CHAR
234: THEN
235: P_X_MR_ROUTE_TBL(I).ATTRIBUTE12:=NULL;
236: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE12 IS NULL
237: THEN

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

236: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE12 IS NULL
237: THEN
238: P_X_MR_ROUTE_TBL(I).ATTRIBUTE12:=l_mr_route_rec.ATTRIBUTE12;
239: END IF;
240: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE13= FND_API.G_MISS_CHAR
241: THEN
242: P_X_MR_ROUTE_TBL(I).ATTRIBUTE13:=NULL;
243: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE13 IS NULL
244: THEN

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

243: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE13 IS NULL
244: THEN
245: P_X_MR_ROUTE_TBL(I).ATTRIBUTE13:=l_mr_route_rec.ATTRIBUTE13;
246: END IF;
247: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE14= FND_API.G_MISS_CHAR
248: THEN
249: P_X_MR_ROUTE_TBL(I).ATTRIBUTE14:=NULL;
250: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE14 IS NULL
251: THEN

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

251: THEN
252: P_X_MR_ROUTE_TBL(I).ATTRIBUTE14:=l_mr_route_rec.ATTRIBUTE14;
253: END IF;
254:
255: IF P_X_MR_ROUTE_TBL(I).ATTRIBUTE15= FND_API.G_MISS_CHAR
256: THEN
257: P_X_MR_ROUTE_TBL(I).ATTRIBUTE15:=NULL;
258: ELSIF P_X_MR_ROUTE_TBL(I).ATTRIBUTE15 IS NULL
259: THEN

Line 299: x_return_status:=FND_API.G_RET_STS_SUCCESS;

295: AND REVISION_STATUS_CODE='COMPLETE';*/
296:
297: l_route_rec get_route_frm%rowtype;
298: BEGIN
299: x_return_status:=FND_API.G_RET_STS_SUCCESS;
300: IF G_DEBUG='Y' THEN
301: AHL_DEBUG_PUB.enable_debug;
302: AHL_DEBUG_PUB.debug( 'Route Revision number'||p_x_mr_route_rec.route_revision_number);
303: END IF;

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

302: AHL_DEBUG_PUB.debug( 'Route Revision number'||p_x_mr_route_rec.route_revision_number);
303: END IF;
304:
305: IF (p_x_mr_route_rec.route_number IS NULL or
306: p_x_mr_route_rec.route_number=FND_API.G_MISS_CHAR) and
307: p_x_mr_route_rec.dml_operation<>'D'
308: THEN
309: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_NUMBR_NULL');
310: FND_MSG_PUB.ADD;

Line 363: x_return_status:=FND_API.G_RET_STS_SUCCESS;

359: l_curr_stage_number NUMBER;
360: l_passed_stage_number NUMBER;
361:
362: BEGIN
363: x_return_status:=FND_API.G_RET_STS_SUCCESS;
364:
365: IF G_APPLN_USAGE IS NULL
366: THEN
367: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');

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

370: END IF;
371:
372: -- AHL_FMP_MR_SELCT_RT_FROM_LOV (ROUTE_NUMBER
373:
374: IF (p_x_mr_route_rec.route_revision_number IS NULL OR p_x_mr_route_rec.route_revision_number=FND_API.G_MISS_NUM) AND p_x_mr_route_rec.dml_operation<>'D'
375: THEN
376: --AMSRINIV : Bug 4913924 . Below commented query tuned.
377: SELECT
378: COUNT(*) into l_counter

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

398: END IF;
399: END IF;
400:
401:
402: IF (p_x_mr_route_rec.MR_HEADER_ID IS NULL OR p_x_mr_route_rec.MR_HEADER_ID=FND_API.G_MISS_NUM) AND p_x_mr_route_rec.dml_operation<>'D'
403: THEN
404: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_NULL');
405: FND_MSG_PUB.ADD;
406: ELSE

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

425: END IF;
426: CLOSE GetMrDet;
427: END IF;
428:
429: IF (p_x_mr_route_rec.OBJECT_VERSION_NUMBER IS NULL OR p_x_mr_route_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_num) and p_x_mr_route_rec.dml_operation<>'C'
430: THEN
431: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRR_OBJ_VERSION_NULL');
432: FND_MESSAGE.SET_TOKEN('RECORD',p_x_mr_route_rec.route_number,false);
433: FND_MSG_PUB.ADD;

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

432: FND_MESSAGE.SET_TOKEN('RECORD',p_x_mr_route_rec.route_number,false);
433: FND_MSG_PUB.ADD;
434: END IF;
435:
436: IF (p_x_mr_route_rec.MR_ROUTE_ID IS NULL OR p_x_mr_route_rec.MR_ROUTE_ID=FND_API.G_MISS_NUM) AND p_x_mr_route_rec.dml_operation<>'C'
437: THEN
438: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_ID_NULL');
439: FND_MESSAGE.SET_TOKEN('RECORD',p_x_mr_route_rec.ROUTE_NUMBER,false);
440: FND_MSG_PUB.ADD;

Line 471: p_x_mr_route_rec.stage_type_code <> FND_API.G_MISS_CHAR) OR

467: -- Tamal [MEL/CDL] -- End changes
468:
469: --MANESING::VWP Enhancements, 21-Jan-2011, added validation for Stage Type Lookup
470: IF ( (p_x_mr_route_rec.stage_type_code IS NOT NULL AND
471: p_x_mr_route_rec.stage_type_code <> FND_API.G_MISS_CHAR) OR
472: (p_x_mr_route_rec.stage_type_meaning IS NOT NULL AND
473: p_x_mr_route_rec.stage_type_meaning <> FND_API.G_MISS_CHAR) ) THEN
474:
475: AHL_FMP_COMMON_PVT.validate_lookup

Line 473: p_x_mr_route_rec.stage_type_meaning <> FND_API.G_MISS_CHAR) ) THEN

469: --MANESING::VWP Enhancements, 21-Jan-2011, added validation for Stage Type Lookup
470: IF ( (p_x_mr_route_rec.stage_type_code IS NOT NULL AND
471: p_x_mr_route_rec.stage_type_code <> FND_API.G_MISS_CHAR) OR
472: (p_x_mr_route_rec.stage_type_meaning IS NOT NULL AND
473: p_x_mr_route_rec.stage_type_meaning <> FND_API.G_MISS_CHAR) ) THEN
474:
475: AHL_FMP_COMMON_PVT.validate_lookup
476: (
477: x_return_status => x_return_status,

Line 484: IF ( NVL(x_return_status, 'X') <> FND_API.G_RET_STS_SUCCESS ) THEN

480: p_lookup_meaning => p_x_mr_route_rec.stage_type_meaning,
481: p_x_lookup_code => p_x_mr_route_rec.stage_type_code
482: );
483:
484: IF ( NVL(x_return_status, 'X') <> FND_API.G_RET_STS_SUCCESS ) THEN
485: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
486: FND_MESSAGE.set_name( 'AHL', 'AHL_VWP_INVALID_STAGE_TYPE' );
487: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
488: FND_MESSAGE.set_name( 'AHL', 'AHL_VWP_TOO_MANY_STAGE_TYPES' );

Line 494: p_x_mr_route_rec.stage_type_meaning = FND_API.G_MISS_CHAR ) THEN

490: FND_MESSAGE.set_name( 'AHL', l_msg_data );
491: END IF;
492:
493: IF ( p_x_mr_route_rec.stage_type_meaning IS NULL OR
494: p_x_mr_route_rec.stage_type_meaning = FND_API.G_MISS_CHAR ) THEN
495: FND_MESSAGE.set_token( 'FIELD', p_x_mr_route_rec.stage_type_code );
496: ELSE
497: FND_MESSAGE.set_token( 'FIELD', p_x_mr_route_rec.stage_type_meaning );
498: END IF;

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

522:
523: PROCEDURE PROCESS_MR_ROUTE
524: (
525: p_api_version IN NUMBER := 1.0,
526: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
527: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
528: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
529: p_default IN VARCHAR2 := FND_API.G_FALSE,
530: p_module_type IN VARCHAR2 := NULL,

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

523: PROCEDURE PROCESS_MR_ROUTE
524: (
525: p_api_version IN NUMBER := 1.0,
526: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
527: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
528: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
529: p_default IN VARCHAR2 := FND_API.G_FALSE,
530: p_module_type IN VARCHAR2 := NULL,
531: x_return_status OUT NOCOPY VARCHAR2,

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

524: (
525: p_api_version IN NUMBER := 1.0,
526: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
527: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
528: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
529: p_default IN VARCHAR2 := FND_API.G_FALSE,
530: p_module_type IN VARCHAR2 := NULL,
531: x_return_status OUT NOCOPY VARCHAR2,
532: x_msg_count OUT NOCOPY NUMBER,

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

525: p_api_version IN NUMBER := 1.0,
526: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
527: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
528: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
529: p_default IN VARCHAR2 := FND_API.G_FALSE,
530: p_module_type IN VARCHAR2 := NULL,
531: x_return_status OUT NOCOPY VARCHAR2,
532: x_msg_count OUT NOCOPY NUMBER,
533: x_msg_data OUT NOCOPY VARCHAR2,

Line 559: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

555: SAVEPOINT PROCESS_MR_ROUTES_PVT;
556:
557: -- Standard call to check for call compatibility.
558:
559: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
560: p_api_version,
561: l_api_name,G_PKG_NAME) THEN
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: END IF;

Line 562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

558:
559: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
560: p_api_version,
561: l_api_name,G_PKG_NAME) THEN
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: END IF;
564:
565: -- Initialize message list if p_init_msg_list is set to TRUE.
566:

Line 567: IF FND_API.to_boolean(p_init_msg_list) THEN

563: END IF;
564:
565: -- Initialize message list if p_init_msg_list is set to TRUE.
566:
567: IF FND_API.to_boolean(p_init_msg_list) THEN
568: FND_MSG_PUB.initialize;
569: END IF;
570:
571: -- Enable Debug

Line 582: x_return_status := FND_API.G_RET_STS_SUCCESS;

578:
579:
580: -- Initialize API return status to success
581:
582: x_return_status := FND_API.G_RET_STS_SUCCESS;
583:
584: IF FND_API.to_boolean(p_default)
585: THEN
586: DEFAULT_MISSING_ATTRIBS

Line 584: IF FND_API.to_boolean(p_default)

580: -- Initialize API return status to success
581:
582: x_return_status := FND_API.G_RET_STS_SUCCESS;
583:
584: IF FND_API.to_boolean(p_default)
585: THEN
586: DEFAULT_MISSING_ATTRIBS
587: (
588: p_x_mr_route_tbl =>p_x_mr_route_tbl

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

595:
596: -- code for Value_To_ID conversion for parent MR.
597: IF (
598: p_x_mr_route_tbl(i).mr_header_id IS NULL OR
599: p_x_mr_route_tbl(i).mr_header_id = FND_API.G_MISS_NUM
600: )
601: THEN
602: -- Function to convert mr_title,mr_version_number to id
603: AHL_FMP_COMMON_PVT.mr_title_version_to_id(

Line 609: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

605: p_mr_version_number => p_x_mr_route_tbl(i).mr_version_number,
606: x_mr_header_id => p_x_mr_route_tbl(i).mr_header_id,
607: x_return_status => x_return_status
608: );
609: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
611: fnd_log.string
612: (
613: fnd_log.level_statement,

Line 618: RAISE FND_API.G_EXC_ERROR;

614: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
615: 'Invalid MR Title, Version Number provided'
616: );
617: END IF;
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620: END IF;
621:
622: -- If The Module Type is JSP then Null out the IDs for the attributes based on LOVs.

Line 632: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )

628: IF P_X_MR_ROUTE_TBL(I).DML_OPERATION<>'D'
629: THEN
630:
631: l_mr_route_rec:=p_x_MR_ROUTE_TBL(i);
632: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
633: THEN
634: IF P_X_MR_ROUTE_TBL(i).DML_OPERATION<>'D'
635: THEN
636:

Line 652: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

648:
649: l_msg_count := FND_MSG_PUB.count_msg;
650: IF l_msg_count > 0 THEN
651: X_msg_count := l_msg_count;
652: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;
655:
656: FOR i IN P_X_MR_ROUTE_TBL.FIRST.. P_X_MR_ROUTE_TBL.LAST

Line 653: RAISE FND_API.G_EXC_ERROR;

649: l_msg_count := FND_MSG_PUB.count_msg;
650: IF l_msg_count > 0 THEN
651: X_msg_count := l_msg_count;
652: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;
655:
656: FOR i IN P_X_MR_ROUTE_TBL.FIRST.. P_X_MR_ROUTE_TBL.LAST
657: LOOP

Line 659: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )

655:
656: FOR i IN P_X_MR_ROUTE_TBL.FIRST.. P_X_MR_ROUTE_TBL.LAST
657: LOOP
658: l_mr_route_rec:=p_x_MR_ROUTE_TBL(i);
659: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
660: THEN
661:
662: VALIDATE_MR_ROUTE
663: (

Line 793: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

789:
790: l_msg_count := FND_MSG_PUB.count_msg;
791: IF l_msg_count > 0 THEN
792: X_msg_count := l_msg_count;
793: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796:
797:

Line 794: RAISE FND_API.G_EXC_ERROR;

790: l_msg_count := FND_MSG_PUB.count_msg;
791: IF l_msg_count > 0 THEN
792: X_msg_count := l_msg_count;
793: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796:
797:
798: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 798: IF FND_API.TO_BOOLEAN(p_commit) THEN

794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796:
797:
798: IF FND_API.TO_BOOLEAN(p_commit) THEN
799: COMMIT;
800: END IF;
801:
802: IF G_DEBUG='Y' THEN

Line 807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

803: AHL_DEBUG_PUB.disable_debug;
804: END IF;
805:
806: EXCEPTION
807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
809: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
811: p_count => x_msg_count,

Line 809: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

805:
806: EXCEPTION
807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
809: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
811: p_count => x_msg_count,
812: p_data => x_msg_data);
813: IF G_DEBUG='Y' THEN

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

806: EXCEPTION
807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
809: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
811: p_count => x_msg_count,
812: p_data => x_msg_data);
813: IF G_DEBUG='Y' THEN
814: AHL_DEBUG_PUB.disable_debug;

Line 818: WHEN FND_API.G_EXC_ERROR THEN

814: AHL_DEBUG_PUB.disable_debug;
815: END IF;
816:
817:
818: WHEN FND_API.G_EXC_ERROR THEN
819: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
820: X_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
822: p_count => x_msg_count,

Line 820: X_return_status := FND_API.G_RET_STS_ERROR;

816:
817:
818: WHEN FND_API.G_EXC_ERROR THEN
819: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
820: X_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
822: p_count => x_msg_count,
823: p_data => X_msg_data);
824: IF G_DEBUG='Y' THEN

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

817:
818: WHEN FND_API.G_EXC_ERROR THEN
819: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
820: X_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
822: p_count => x_msg_count,
823: p_data => X_msg_data);
824: IF G_DEBUG='Y' THEN
825: AHL_DEBUG_PUB.disable_debug;

Line 830: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

826: END IF;
827:
828: WHEN OTHERS THEN
829: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
830: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
832: THEN
833: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_ROUTE_PVT',
834: p_procedure_name => 'PROCESS_MR_ROUTE',

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

833: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_ROUTE_PVT',
834: p_procedure_name => 'PROCESS_MR_ROUTE',
835: p_error_text => SUBSTR(SQLERRM,1,240));
836: END IF;
837: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
838: p_count => x_msg_count,
839: p_data => X_msg_data);
840: IF G_DEBUG='Y' THEN
841: AHL_DEBUG_PUB.disable_debug;