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

Line 219: IF p_x_mr_visit_type_tbl(I).MR_HEADER_ID= FND_API.G_MISS_NUM

215: OPEN CurMrVisitType(p_x_mr_visit_type_tbl(i).mr_visit_type_ID);
216: fetch CurMrVisitType into l_mrvisittype_rec ;
217: CLOSE CurMrVisitType;
218:
219: IF p_x_mr_visit_type_tbl(I).MR_HEADER_ID= FND_API.G_MISS_NUM
220: THEN
221: p_x_mr_visit_type_tbl(I).MR_HEADER_ID:=NULL;
222: ELSIF p_x_mr_visit_type_tbl(I).MR_HEADER_ID IS NULL
223: THEN

Line 227: IF p_x_mr_visit_type_tbl(I).mr_visit_type_CODE= FND_API.G_MISS_CHAR

223: THEN
224: p_x_mr_visit_type_tbl(I).MR_HEADER_ID:=l_mrVisitType_rec.MR_HEADER_ID;
225: END IF;
226:
227: IF p_x_mr_visit_type_tbl(I).mr_visit_type_CODE= FND_API.G_MISS_CHAR
228: THEN
229: p_x_mr_visit_type_tbl(I).mr_visit_type_CODE:=NULL;
230: ELSIF p_x_mr_visit_type_tbl(I).mr_visit_type_CODE IS NULL
231: THEN

Line 235: IF p_x_mr_visit_type_tbl(I).mr_visit_type= FND_API.G_MISS_CHAR

231: THEN
232: p_x_mr_visit_type_tbl(I).mr_visit_type_CODE:=l_mrVisitType_rec.mr_visit_type_CODE;
233: END IF;
234:
235: IF p_x_mr_visit_type_tbl(I).mr_visit_type= FND_API.G_MISS_CHAR
236: THEN
237: p_x_mr_visit_type_tbl(I).mr_visit_type:=NULL;
238: ELSIF p_x_mr_visit_type_tbl(I).mr_visit_type IS NULL
239: THEN

Line 243: IF p_x_mr_visit_type_tbl(I).mr_visit_type_ID= FND_API.G_MISS_NUM

239: THEN
240: p_x_mr_visit_type_tbl(I).mr_visit_type:=l_mrVisitType_rec.mr_visit_type;
241: END IF;
242:
243: IF p_x_mr_visit_type_tbl(I).mr_visit_type_ID= FND_API.G_MISS_NUM
244: THEN
245: p_x_mr_visit_type_tbl(I).mr_visit_type_ID:=NULL;
246: END IF;
247:

Line 248: IF p_x_mr_visit_type_tbl(I).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM

244: THEN
245: p_x_mr_visit_type_tbl(I).mr_visit_type_ID:=NULL;
246: END IF;
247:
248: IF p_x_mr_visit_type_tbl(I).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM
249: THEN
250: p_x_mr_visit_type_tbl(I).OBJECT_VERSION_NUMBER:=null;
251: ELSIF p_x_mr_visit_type_tbl(I).OBJECT_VERSION_NUMBER IS NULL
252: THEN

Line 256: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR

252: THEN
253: p_x_mr_visit_type_tbl(I).OBJECT_VERSION_NUMBER:=l_mrVisitType_rec.OBJECT_VERSION_NUMBER;
254: END IF;
255:
256: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR
257: THEN
258: p_x_mr_visit_type_tbl(I).ATTRIBUTE_CATEGORY:=NULL;
259: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE_CATEGORY IS NULL
260: THEN

Line 264: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE1= FND_API.G_MISS_CHAR

260: THEN
261: p_x_mr_visit_type_tbl(I).ATTRIBUTE_CATEGORY:=l_mrVisitType_rec.ATTRIBUTE_CATEGORY;
262: END IF;
263:
264: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE1= FND_API.G_MISS_CHAR
265: THEN
266: p_x_mr_visit_type_tbl(I).ATTRIBUTE1:=NULL;
267: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE1 IS NULL
268: THEN

Line 272: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE2= FND_API.G_MISS_CHAR

268: THEN
269: p_x_mr_visit_type_tbl(I).ATTRIBUTE1:=l_mrVisitType_rec.ATTRIBUTE1;
270: END IF;
271:
272: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE2= FND_API.G_MISS_CHAR
273: THEN
274: p_x_mr_visit_type_tbl(I).ATTRIBUTE2:=NULL;
275: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE2 IS NULL
276: THEN

Line 280: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE3= FND_API.G_MISS_CHAR

276: THEN
277: p_x_mr_visit_type_tbl(I).ATTRIBUTE2:=l_mrVisitType_rec.ATTRIBUTE2;
278: END IF;
279:
280: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE3= FND_API.G_MISS_CHAR
281: THEN
282: p_x_mr_visit_type_tbl(I).ATTRIBUTE3:=NULL;
283: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE3 IS NULL
284: THEN

Line 288: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE4= FND_API.G_MISS_CHAR

284: THEN
285: p_x_mr_visit_type_tbl(I).ATTRIBUTE3:=l_mrVisitType_rec.ATTRIBUTE3;
286: END IF;
287:
288: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE4= FND_API.G_MISS_CHAR
289: THEN
290: p_x_mr_visit_type_tbl(I).ATTRIBUTE4:=NULL;
291: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE4 IS NULL
292: THEN

Line 296: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE5= FND_API.G_MISS_CHAR

292: THEN
293: p_x_mr_visit_type_tbl(I).ATTRIBUTE4:=l_mrVisitType_rec.ATTRIBUTE4;
294: END IF;
295:
296: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE5= FND_API.G_MISS_CHAR
297: THEN
298: p_x_mr_visit_type_tbl(I).ATTRIBUTE5:=NULL;
299: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE5 IS NULL
300: THEN

Line 304: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE6= FND_API.G_MISS_CHAR

300: THEN
301: p_x_mr_visit_type_tbl(I).ATTRIBUTE5:=l_mrVisitType_rec.ATTRIBUTE5;
302: END IF;
303:
304: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE6= FND_API.G_MISS_CHAR
305: THEN
306: p_x_mr_visit_type_tbl(I).ATTRIBUTE6:=NULL;
307: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE6 IS NULL
308: THEN

Line 312: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE7= FND_API.G_MISS_CHAR

308: THEN
309: p_x_mr_visit_type_tbl(I).ATTRIBUTE6:=l_mrVisitType_rec.ATTRIBUTE6;
310: END IF;
311:
312: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE7= FND_API.G_MISS_CHAR
313: THEN
314: p_x_mr_visit_type_tbl(I).ATTRIBUTE7:=NULL;
315: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE7 IS NULL
316: THEN

Line 320: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE8= FND_API.G_MISS_CHAR

316: THEN
317: p_x_mr_visit_type_tbl(I).ATTRIBUTE7:=l_mrVisitType_rec.ATTRIBUTE7;
318: END IF;
319:
320: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE8= FND_API.G_MISS_CHAR
321: THEN
322: p_x_mr_visit_type_tbl(I).ATTRIBUTE8:=NULL;
323: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE8 IS NULL
324: THEN

Line 328: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE9= FND_API.G_MISS_CHAR

324: THEN
325: p_x_mr_visit_type_tbl(I).ATTRIBUTE8:=l_mrVisitType_rec.ATTRIBUTE8;
326: END IF;
327:
328: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE9= FND_API.G_MISS_CHAR
329: THEN
330: p_x_mr_visit_type_tbl(I).ATTRIBUTE9:=NULL;
331: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE9 IS NULL
332: THEN

Line 336: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE10= FND_API.G_MISS_CHAR

332: THEN
333: p_x_mr_visit_type_tbl(I).ATTRIBUTE9:=l_mrVisitType_rec.ATTRIBUTE9;
334: END IF;
335:
336: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE10= FND_API.G_MISS_CHAR
337: THEN
338: p_x_mr_visit_type_tbl(I).ATTRIBUTE10:=NULL;
339: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE10 IS NULL
340: THEN

Line 344: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE11= FND_API.G_MISS_CHAR

340: THEN
341: p_x_mr_visit_type_tbl(I).ATTRIBUTE10:=l_mrVisitType_rec.ATTRIBUTE10;
342: END IF;
343:
344: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE11= FND_API.G_MISS_CHAR
345: THEN
346: p_x_mr_visit_type_tbl(I).ATTRIBUTE11:=NULL;
347: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE11 IS NULL
348: THEN

Line 352: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE12= FND_API.G_MISS_CHAR

348: THEN
349: p_x_mr_visit_type_tbl(I).ATTRIBUTE11:=l_mrVisitType_rec.ATTRIBUTE11;
350: END IF;
351:
352: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE12= FND_API.G_MISS_CHAR
353: THEN
354: p_x_mr_visit_type_tbl(I).ATTRIBUTE12:=NULL;
355: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE12 IS NULL
356: THEN

Line 360: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE13= FND_API.G_MISS_CHAR

356: THEN
357: p_x_mr_visit_type_tbl(I).ATTRIBUTE12:=l_mrVisitType_rec.ATTRIBUTE12;
358: END IF;
359:
360: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE13= FND_API.G_MISS_CHAR
361: THEN
362: p_x_mr_visit_type_tbl(I).ATTRIBUTE13:=NULL;
363: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE13 IS NULL
364: THEN

Line 368: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE14= FND_API.G_MISS_CHAR

364: THEN
365: p_x_mr_visit_type_tbl(I).ATTRIBUTE13:=l_mrVisitType_rec.ATTRIBUTE13;
366: END IF;
367:
368: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE14= FND_API.G_MISS_CHAR
369: THEN
370: p_x_mr_visit_type_tbl(I).ATTRIBUTE14:=NULL;
371: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE14 IS NULL
372: THEN

Line 376: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE15= FND_API.G_MISS_CHAR

372: THEN
373: p_x_mr_visit_type_tbl(I).ATTRIBUTE14:=l_mrVisitType_rec.ATTRIBUTE14;
374: END IF;
375:
376: IF p_x_mr_visit_type_tbl(I).ATTRIBUTE15= FND_API.G_MISS_CHAR
377: THEN
378: p_x_mr_visit_type_tbl(I).ATTRIBUTE15:=NULL;
379: ELSIF p_x_mr_visit_type_tbl(I).ATTRIBUTE15 IS NULL
380: THEN

Line 407: OR p_x_mr_visit_type_rec.mr_visit_type=FND_API.G_MISS_CHAR

403: AND nvl(end_date_active,sysdate);
404: BEGIN
405:
406: IF p_x_mr_visit_type_rec.mr_visit_type is null
407: OR p_x_mr_visit_type_rec.mr_visit_type=FND_API.G_MISS_CHAR
408: THEN
409: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRVSTTYPE_CODE_NULL');
410: FND_MSG_PUB.ADD;
411: ELSE

Line 505: x_return_status:=FND_API.G_RET_STS_SUCCESS;

501:
502: -- Kasridha: Changes for Bug#13741458 Ends
503:
504: BEGIN
505: x_return_status:=FND_API.G_RET_STS_SUCCESS;
506:
507: -- Check Profile value
508: IF (G_APPLN_USAGE IS NULL)
509: THEN

Line 517: x_return_status := FND_API.G_RET_STS_ERROR;

513: ELSIF (G_APPLN_USAGE = 'PM')
514: THEN
515: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_MRV_PM_INSTALL' );
516: FND_MSG_PUB.add;
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: RETURN;
519: END IF;
520:
521: IF (p_mr_visit_type_rec.mr_visit_type_ID IS NULL OR p_mr_visit_type_rec.mr_visit_type_ID=FND_API.G_MISS_NUM)

Line 521: IF (p_mr_visit_type_rec.mr_visit_type_ID IS NULL OR p_mr_visit_type_rec.mr_visit_type_ID=FND_API.G_MISS_NUM)

517: x_return_status := FND_API.G_RET_STS_ERROR;
518: RETURN;
519: END IF;
520:
521: IF (p_mr_visit_type_rec.mr_visit_type_ID IS NULL OR p_mr_visit_type_rec.mr_visit_type_ID=FND_API.G_MISS_NUM)
522: AND p_mr_visit_type_rec.dml_operation<>'C'
523: THEN
524: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_VSTYPE_ID_NULL');
525: FND_MSG_PUB.ADD;

Line 528: IF (p_mr_visit_type_rec.mr_visit_type_ID IS NOT NULL and p_mr_visit_type_rec.mr_visit_type_ID<>FND_API.G_MISS_NUM)

524: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_VSTYPE_ID_NULL');
525: FND_MSG_PUB.ADD;
526: END IF;
527:
528: IF (p_mr_visit_type_rec.mr_visit_type_ID IS NOT NULL and p_mr_visit_type_rec.mr_visit_type_ID<>FND_API.G_MISS_NUM)
529: AND p_mr_visit_type_rec.dml_operation<>'C'
530: THEN
531: OPEN get_visit_id(p_mr_visit_type_rec.mr_visit_type_id ,p_mr_visit_type_rec.object_version_number) ;
532: FETCH get_visit_id INTO l_mr_visit_type_id;

Line 542: IF (p_mr_visit_type_rec.OBJECT_VERSION_NUMBER IS NULL OR p_mr_visit_type_rec.OBJECT_vERSION_NUMBER=FND_API.G_MISS_num)

538: END IF;
539: CLOSE get_visit_id;
540: END IF;
541:
542: IF (p_mr_visit_type_rec.OBJECT_VERSION_NUMBER IS NULL OR p_mr_visit_type_rec.OBJECT_vERSION_NUMBER=FND_API.G_MISS_num)
543: and p_mr_visit_type_rec.dml_operation<>'C'
544: THEN
545: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRA_OBJ_VERSION_NULL');
546: FND_MSG_PUB.ADD;

Line 549: IF p_mr_visit_type_rec.MR_HEADER_ID IS NULL OR p_mr_visit_type_rec.MR_HEADER_ID=FND_API.G_MISS_NUM

545: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRA_OBJ_VERSION_NULL');
546: FND_MSG_PUB.ADD;
547: END IF;
548:
549: IF p_mr_visit_type_rec.MR_HEADER_ID IS NULL OR p_mr_visit_type_rec.MR_HEADER_ID=FND_API.G_MISS_NUM
550: THEN
551: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_NULL');
552: FND_MSG_PUB.ADD;
553: ELSE

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

639:
640: PROCEDURE PROCESS_MR_VISIT_TYPES
641: (
642: p_api_version IN NUMBER,
643: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
644: p_commit IN VARCHAR2 := FND_API.G_FALSE,
645: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
646: p_default IN VARCHAR2 := FND_API.G_FALSE,
647: p_module_type IN VARCHAR2,

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

640: PROCEDURE PROCESS_MR_VISIT_TYPES
641: (
642: p_api_version IN NUMBER,
643: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
644: p_commit IN VARCHAR2 := FND_API.G_FALSE,
645: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
646: p_default IN VARCHAR2 := FND_API.G_FALSE,
647: p_module_type IN VARCHAR2,
648: x_return_status OUT NOCOPY VARCHAR2,

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

641: (
642: p_api_version IN NUMBER,
643: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
644: p_commit IN VARCHAR2 := FND_API.G_FALSE,
645: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
646: p_default IN VARCHAR2 := FND_API.G_FALSE,
647: p_module_type IN VARCHAR2,
648: x_return_status OUT NOCOPY VARCHAR2,
649: x_msg_count OUT NOCOPY NUMBER,

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

642: p_api_version IN NUMBER,
643: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
644: p_commit IN VARCHAR2 := FND_API.G_FALSE,
645: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
646: p_default IN VARCHAR2 := FND_API.G_FALSE,
647: p_module_type IN VARCHAR2,
648: x_return_status OUT NOCOPY VARCHAR2,
649: x_msg_count OUT NOCOPY NUMBER,
650: x_msg_data OUT NOCOPY VARCHAR2,

Line 671: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

667: SAVEPOINT process_mr_visit_types_pvt;
668:
669: -- Standard call to check for call compatibility.
670:
671: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
673: END IF;
674:
675: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

668:
669: -- Standard call to check for call compatibility.
670:
671: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
673: END IF;
674:
675: -- Initialize message list if p_init_msg_list is set to TRUE.
676:

Line 677: IF FND_API.to_boolean(p_init_msg_list) THEN

673: END IF;
674:
675: -- Initialize message list if p_init_msg_list is set to TRUE.
676:
677: IF FND_API.to_boolean(p_init_msg_list) THEN
678: FND_MSG_PUB.initialize;
679: END IF;
680:
681: -- Initialize API return status to success

Line 683: x_return_status:=FND_API.G_RET_STS_SUCCESS;

679: END IF;
680:
681: -- Initialize API return status to success
682:
683: x_return_status:=FND_API.G_RET_STS_SUCCESS;
684:
685: IF p_x_mr_visit_type_tbl.COUNT <1
686: THEN
687: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 712: --p_x_mr_visit_type_tbl(i).mr_visit_type_code:=FND_API.G_MISS_CHAR;

708: if p_x_mr_visit_type_tbl(i).dml_operation<>'D'
709: then
710: p_x_mr_visit_type_tbl(i).mr_visit_type_code:=NULL;
711: end if;
712: --p_x_mr_visit_type_tbl(i).mr_visit_type_code:=FND_API.G_MISS_CHAR;
713: END LOOP;
714: END IF;
715:
716: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 791: RAISE FND_API.G_EXC_ERROR;

787: 'Local procedure TRANS_VALUE_ID',
788: 'End of TRANS_VALUE_ID');
789: END IF;
790:
791: RAISE FND_API.G_EXC_ERROR;
792: END IF;
793:
794:
795: --Start of API Body

Line 827: RAISE FND_API.G_EXC_ERROR;

823: END LOOP;
824:
825: x_msg_count := FND_MSG_PUB.count_msg;
826: IF x_msg_count > 0 THEN
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829:
830:
831: IF FND_API.TO_BOOLEAN(p_commit)

Line 831: IF FND_API.TO_BOOLEAN(p_commit)

827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829:
830:
831: IF FND_API.TO_BOOLEAN(p_commit)
832: THEN
833: COMMIT;
834: END IF;
835:

Line 837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

833: COMMIT;
834: END IF;
835:
836: EXCEPTION
837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
838: ROLLBACK TO process_mr_visit_types_pvt;
839: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
840: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
841: p_count => x_msg_count,

Line 839: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

835:
836: EXCEPTION
837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
838: ROLLBACK TO process_mr_visit_types_pvt;
839: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
840: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
841: p_count => x_msg_count,
842: p_data => x_msg_data);
843:

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

836: EXCEPTION
837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
838: ROLLBACK TO process_mr_visit_types_pvt;
839: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
840: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
841: p_count => x_msg_count,
842: p_data => x_msg_data);
843:
844: WHEN FND_API.G_EXC_ERROR THEN

Line 844: WHEN FND_API.G_EXC_ERROR THEN

840: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
841: p_count => x_msg_count,
842: p_data => x_msg_data);
843:
844: WHEN FND_API.G_EXC_ERROR THEN
845: ROLLBACK TO process_mr_visit_types_pvt;
846: X_return_status := FND_API.G_RET_STS_ERROR;
847: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
848: p_count => x_msg_count,

Line 846: X_return_status := FND_API.G_RET_STS_ERROR;

842: p_data => x_msg_data);
843:
844: WHEN FND_API.G_EXC_ERROR THEN
845: ROLLBACK TO process_mr_visit_types_pvt;
846: X_return_status := FND_API.G_RET_STS_ERROR;
847: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
848: p_count => x_msg_count,
849: p_data => X_msg_data);
850: WHEN OTHERS THEN

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

843:
844: WHEN FND_API.G_EXC_ERROR THEN
845: ROLLBACK TO process_mr_visit_types_pvt;
846: X_return_status := FND_API.G_RET_STS_ERROR;
847: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
848: p_count => x_msg_count,
849: p_data => X_msg_data);
850: WHEN OTHERS THEN
851: ROLLBACK TO process_mr_visit_types_pvt;

Line 852: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

848: p_count => x_msg_count,
849: p_data => X_msg_data);
850: WHEN OTHERS THEN
851: ROLLBACK TO process_mr_visit_types_pvt;
852: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
854: THEN
855: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
856: p_procedure_name =>l_api_name,

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

856: p_procedure_name =>l_api_name,
857: p_error_text =>SUBSTR(SQLERRM,1,240)
858: );
859: END IF;
860: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
861: p_count => x_msg_count,
862: p_data => X_msg_data);
863: END;
864: END AHL_FMP_MR_VISIT_TYPES_PVT;