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 473: x_return_status:=FND_API.G_RET_STS_SUCCESS;

469:
470: l_act_rec CHECK_DUP_VISIT_CODE%ROWTYPE;
471: l_mr_visit_type_id NUMBER:=0;
472: BEGIN
473: x_return_status:=FND_API.G_RET_STS_SUCCESS;
474:
475: -- Check Profile value
476: IF (G_APPLN_USAGE IS NULL)
477: THEN

Line 485: x_return_status := FND_API.G_RET_STS_ERROR;

481: ELSIF (G_APPLN_USAGE = 'PM')
482: THEN
483: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_MRV_PM_INSTALL' );
484: FND_MSG_PUB.add;
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: RETURN;
487: END IF;
488:
489: 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 489: 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)

485: x_return_status := FND_API.G_RET_STS_ERROR;
486: RETURN;
487: END IF;
488:
489: 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)
490: AND p_mr_visit_type_rec.dml_operation<>'C'
491: THEN
492: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_VSTYPE_ID_NULL');
493: FND_MSG_PUB.ADD;

Line 496: 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)

492: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_VSTYPE_ID_NULL');
493: FND_MSG_PUB.ADD;
494: END IF;
495:
496: 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)
497: AND p_mr_visit_type_rec.dml_operation<>'C'
498: THEN
499: OPEN get_visit_id(p_mr_visit_type_rec.mr_visit_type_id ,p_mr_visit_type_rec.object_version_number) ;
500: FETCH get_visit_id INTO l_mr_visit_type_id;

Line 510: 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)

506: END IF;
507: CLOSE get_visit_id;
508: END IF;
509:
510: 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)
511: and p_mr_visit_type_rec.dml_operation<>'C'
512: THEN
513: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRA_OBJ_VERSION_NULL');
514: FND_MSG_PUB.ADD;

Line 517: 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

513: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRA_OBJ_VERSION_NULL');
514: FND_MSG_PUB.ADD;
515: END IF;
516:
517: 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
518: THEN
519: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_NULL');
520: FND_MSG_PUB.ADD;
521: ELSE

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

578:
579: PROCEDURE PROCESS_MR_VISIT_TYPES
580: (
581: p_api_version IN NUMBER,
582: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
583: p_commit IN VARCHAR2 := FND_API.G_FALSE,
584: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
585: p_default IN VARCHAR2 := FND_API.G_FALSE,
586: p_module_type IN VARCHAR2,

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

579: PROCEDURE PROCESS_MR_VISIT_TYPES
580: (
581: p_api_version IN NUMBER,
582: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
583: p_commit IN VARCHAR2 := FND_API.G_FALSE,
584: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
585: p_default IN VARCHAR2 := FND_API.G_FALSE,
586: p_module_type IN VARCHAR2,
587: x_return_status OUT NOCOPY VARCHAR2,

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

580: (
581: p_api_version IN NUMBER,
582: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
583: p_commit IN VARCHAR2 := FND_API.G_FALSE,
584: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
585: p_default IN VARCHAR2 := FND_API.G_FALSE,
586: p_module_type IN VARCHAR2,
587: x_return_status OUT NOCOPY VARCHAR2,
588: x_msg_count OUT NOCOPY NUMBER,

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

581: p_api_version IN NUMBER,
582: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
583: p_commit IN VARCHAR2 := FND_API.G_FALSE,
584: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
585: p_default IN VARCHAR2 := FND_API.G_FALSE,
586: p_module_type IN VARCHAR2,
587: x_return_status OUT NOCOPY VARCHAR2,
588: x_msg_count OUT NOCOPY NUMBER,
589: x_msg_data OUT NOCOPY VARCHAR2,

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

606: SAVEPOINT process_mr_visit_types_pvt;
607:
608: -- Standard call to check for call compatibility.
609:
610: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613:
614: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

607:
608: -- Standard call to check for call compatibility.
609:
610: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613:
614: -- Initialize message list if p_init_msg_list is set to TRUE.
615:

Line 616: IF FND_API.to_boolean(p_init_msg_list) THEN

612: END IF;
613:
614: -- Initialize message list if p_init_msg_list is set to TRUE.
615:
616: IF FND_API.to_boolean(p_init_msg_list) THEN
617: FND_MSG_PUB.initialize;
618: END IF;
619:
620: -- Initialize API return status to success

Line 622: x_return_status:=FND_API.G_RET_STS_SUCCESS;

618: END IF;
619:
620: -- Initialize API return status to success
621:
622: x_return_status:=FND_API.G_RET_STS_SUCCESS;
623:
624: IF p_x_mr_visit_type_tbl.COUNT <1
625: THEN
626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

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

647: if p_x_mr_visit_type_tbl(i).dml_operation<>'D'
648: then
649: p_x_mr_visit_type_tbl(i).mr_visit_type_code:=NULL;
650: end if;
651: --p_x_mr_visit_type_tbl(i).mr_visit_type_code:=FND_API.G_MISS_CHAR;
652: END LOOP;
653: END IF;
654:
655: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 730: RAISE FND_API.G_EXC_ERROR;

726: 'Local procedure TRANS_VALUE_ID',
727: 'End of TRANS_VALUE_ID');
728: END IF;
729:
730: RAISE FND_API.G_EXC_ERROR;
731: END IF;
732:
733:
734: --Start of API Body

Line 766: RAISE FND_API.G_EXC_ERROR;

762: END LOOP;
763:
764: x_msg_count := FND_MSG_PUB.count_msg;
765: IF x_msg_count > 0 THEN
766: RAISE FND_API.G_EXC_ERROR;
767: END IF;
768:
769:
770: IF FND_API.TO_BOOLEAN(p_commit)

Line 770: IF FND_API.TO_BOOLEAN(p_commit)

766: RAISE FND_API.G_EXC_ERROR;
767: END IF;
768:
769:
770: IF FND_API.TO_BOOLEAN(p_commit)
771: THEN
772: COMMIT;
773: END IF;
774:

Line 776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

772: COMMIT;
773: END IF;
774:
775: EXCEPTION
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: ROLLBACK TO process_mr_visit_types_pvt;
778: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
780: p_count => x_msg_count,

Line 778: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

774:
775: EXCEPTION
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: ROLLBACK TO process_mr_visit_types_pvt;
778: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
780: p_count => x_msg_count,
781: p_data => x_msg_data);
782:

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

775: EXCEPTION
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: ROLLBACK TO process_mr_visit_types_pvt;
778: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
780: p_count => x_msg_count,
781: p_data => x_msg_data);
782:
783: WHEN FND_API.G_EXC_ERROR THEN

Line 783: WHEN FND_API.G_EXC_ERROR THEN

779: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
780: p_count => x_msg_count,
781: p_data => x_msg_data);
782:
783: WHEN FND_API.G_EXC_ERROR THEN
784: ROLLBACK TO process_mr_visit_types_pvt;
785: X_return_status := FND_API.G_RET_STS_ERROR;
786: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
787: p_count => x_msg_count,

Line 785: X_return_status := FND_API.G_RET_STS_ERROR;

781: p_data => x_msg_data);
782:
783: WHEN FND_API.G_EXC_ERROR THEN
784: ROLLBACK TO process_mr_visit_types_pvt;
785: X_return_status := FND_API.G_RET_STS_ERROR;
786: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
787: p_count => x_msg_count,
788: p_data => X_msg_data);
789: WHEN OTHERS THEN

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

782:
783: WHEN FND_API.G_EXC_ERROR THEN
784: ROLLBACK TO process_mr_visit_types_pvt;
785: X_return_status := FND_API.G_RET_STS_ERROR;
786: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
787: p_count => x_msg_count,
788: p_data => X_msg_data);
789: WHEN OTHERS THEN
790: ROLLBACK TO process_mr_visit_types_pvt;

Line 791: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

787: p_count => x_msg_count,
788: p_data => X_msg_data);
789: WHEN OTHERS THEN
790: ROLLBACK TO process_mr_visit_types_pvt;
791: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
793: THEN
794: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
795: p_procedure_name =>l_api_name,

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

795: p_procedure_name =>l_api_name,
796: p_error_text =>SUBSTR(SQLERRM,1,240)
797: );
798: END IF;
799: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
800: p_count => x_msg_count,
801: p_data => X_msg_data);
802: END;
803: END AHL_FMP_MR_VISIT_TYPES_PVT;