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_MSG_PUB

Line 310: FND_MSG_PUB.ADD;

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;
311: ELSE
312: OPEN get_route_frm(p_x_mr_route_rec.route_number,p_x_mr_route_rec.route_revision_number);
313: FETCH get_route_frm INTO l_route_rec;
314:

Line 319: FND_MSG_PUB.ADD;

315: IF get_route_frm%NOTFOUND
316: THEN
317: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_NUMBR_INVALID');
318: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_route_rec.route_number,false);
319: FND_MSG_PUB.ADD;
320: ELSE
321: p_x_mr_route_rec.ROUTE_ID:=l_route_rec.route_id;
322: END IF;
323: CLOSE get_route_frm;

Line 368: FND_MSG_PUB.ADD;

364:
365: IF G_APPLN_USAGE IS NULL
366: THEN
367: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
368: FND_MSG_PUB.ADD;
369: RETURN;
370: END IF;
371:
372: -- AHL_FMP_MR_SELCT_RT_FROM_LOV (ROUTE_NUMBER

Line 397: FND_MSG_PUB.ADD;

393: IF l_counter >1
394: THEN
395: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_SELCT_RT_FROM_LOV');
396: FND_MESSAGE.SET_TOKEN('ROUTE_NUMBER',p_x_mr_route_rec.route_number,false);
397: FND_MSG_PUB.ADD;
398: END IF;
399: END IF;
400:
401:

Line 405: FND_MSG_PUB.ADD;

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
407: OPEN GetMrDet(p_x_mr_route_rec.MR_HEADER_ID);
408:
409: FETCH GetMrDet into l_mr_rec;

Line 414: FND_MSG_PUB.ADD;

410:
411: IF GetMrDet%NOTFOUND
412: THEN
413: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_EDIT_STATUS_INVALID');
414: FND_MSG_PUB.ADD;
415: ELSE
416: -- PM Code
417: IF G_APPLN_USAGE='PM'
418: THEN

Line 422: FND_MSG_PUB.ADD;

418: THEN
419: IF l_mr_rec.TYPE_CODE='PROGRAM'
420: THEN
421: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TYPE_CODE_PROGRAM');
422: FND_MSG_PUB.ADD;
423: END IF;
424: END IF;
425: END IF;
426: CLOSE GetMrDet;

Line 433: FND_MSG_PUB.ADD;

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;
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

Line 440: FND_MSG_PUB.ADD;

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;
441: END IF;
442:
443: -- Tamal [MEL/CDL] -- Begin changes
444: IF (p_x_mr_route_rec.dml_operation <> 'D')

Line 464: FND_MSG_PUB.ADD;

460: THEN
461: FND_MESSAGE.SET_NAME('AHL', 'AHL_FMP_MR_ROUTE_TYPE_INV');
462: -- Cannot associate route "" of non (M), (O) procedure type to maintenance requirement of (M) and (O) procedure program type.
463: FND_MESSAGE.SET_TOKEN('RECORD', p_x_mr_route_rec.ROUTE_NUMBER, false);
464: FND_MSG_PUB.ADD;
465: END IF;
466: END IF;
467: -- Tamal [MEL/CDL] -- End changes
468:

Line 500: FND_MSG_PUB.add;

496: ELSE
497: FND_MESSAGE.set_token( 'FIELD', p_x_mr_route_rec.stage_type_meaning );
498: END IF;
499:
500: FND_MSG_PUB.add;
501: END IF;
502: END IF;
503:
504: /* MANESING::VWP Enhancements, 26-May-2011

Line 519: FND_MSG_PUB.add;

515: IF ( (p_x_mr_route_rec.dml_operation = 'C' AND p_x_mr_route_rec.stage IS NOT NULL) OR
516: (p_x_mr_route_rec.dml_operation = 'U' AND p_x_mr_route_rec.stage_type_code IS NULL AND
517: l_curr_stage_number <> l_passed_stage_number) ) THEN
518: FND_MESSAGE.set_name('AHL', 'AHL_VWP_STAGE_NUM_NO_UPD');
519: FND_MSG_PUB.add;
520: END IF;
521: END;
522:
523: PROCEDURE PROCESS_MR_ROUTE

Line 568: FND_MSG_PUB.initialize;

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
572:

Line 649: l_msg_count := FND_MSG_PUB.count_msg;

645: END IF;
646: END IF;
647: END LOOP;
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;

Line 684: FND_MSG_PUB.ADD;

680:
681: IF sql%rowcount=0 then
682: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_RECORD_CHANGED');
683: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_route_tbl(i).route_number,false);
684: FND_MSG_PUB.ADD;
685: END IF;
686:
687: ELSIF P_X_MR_ROUTE_TBL(i).DML_operation='U' then
688:

Line 772: FND_MSG_PUB.ADD;

768: THEN
769: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INV_STAGE_CRT');
770: FND_MESSAGE.SET_TOKEN('ROUTE',P_X_MR_ROUTE_TBL(i).route_number, false);
771: FND_MESSAGE.SET_TOKEN('MAX',l_max_route_num, false);
772: FND_MSG_PUB.ADD;
773: END IF;
774: ELSE
775: AHL_FMP_MR_ROUTE_SEQNCE_PVT.VALIDATE_ROUTE_STAGE_SEQ(P_X_MR_ROUTE_TBL(i).MR_ROUTE_ID, true);
776: END IF;

Line 783: FND_MSG_PUB.ADD;

779: THEN
780: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INV_STAGE_CRT');
781: FND_MESSAGE.SET_TOKEN('ROUTE',P_X_MR_ROUTE_TBL(i).route_number, false);
782: FND_MESSAGE.SET_TOKEN('MAX',l_max_route_num, false);
783: FND_MSG_PUB.ADD;
784: END IF;
785: END LOOP;
786: END IF;
787: */

Line 790: l_msg_count := FND_MSG_PUB.count_msg;

786: END IF;
787: */
788: -- TAMAL
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;

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 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 831: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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',
835: p_error_text => SUBSTR(SQLERRM,1,240));

Line 833: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_ROUTE_PVT',

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',
835: p_error_text => SUBSTR(SQLERRM,1,240));
836: END IF;
837: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

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;