DBA Data[Home] [Help]

APPS.AHL_FMP_MR_VISIT_TYPES_PVT dependencies on FND_MESSAGE

Line 108: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

104: WHERE MR_VISIT_TYPE_ID=P_MR_VISIT_TYPE_REC.mr_visit_type_ID
105: and object_version_number=P_MR_VISIT_TYPE_REC.object_version_number;
106: if (sql%ROWCOUNT=0)
107: then
108: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
109: FND_MSG_PUB.ADD;
110: end if;
111:
112: END;

Line 126: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

122: and object_version_number=p_mr_visit_type_rec .object_version_number;
123:
124: if (sql%ROWCOUNT=0)
125: then
126: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
127: FND_MSG_PUB.ADD;
128: end if;
129: END;
130:

Line 409: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRVSTTYPE_CODE_NULL');

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
412: OPEN get_lookup_meaning_to_code('AHL_PLANNING_VISIT_TYPE',p_x_mr_visit_type_rec.mr_visit_type);
413: FETCH get_lookup_meaning_to_code INTO p_x_mr_visit_type_rec.mr_visit_type_CODE;

Line 417: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRVSTYPE_CODE_INVALID');

413: FETCH get_lookup_meaning_to_code INTO p_x_mr_visit_type_rec.mr_visit_type_CODE;
414:
415: IF get_lookup_meaning_to_code%NOTFOUND
416: THEN
417: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRVSTYPE_CODE_INVALID');
418: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_visit_type_rec.mr_visit_type,false);
419: FND_MSG_PUB.ADD;
420: END IF;
421: CLOSE get_lookup_meaning_to_code;

Line 418: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_visit_type_rec.mr_visit_type,false);

414:
415: IF get_lookup_meaning_to_code%NOTFOUND
416: THEN
417: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRVSTYPE_CODE_INVALID');
418: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_visit_type_rec.mr_visit_type,false);
419: FND_MSG_PUB.ADD;
420: END IF;
421: CLOSE get_lookup_meaning_to_code;
422: END IF;

Line 510: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');

506:
507: -- Check Profile value
508: IF (G_APPLN_USAGE IS NULL)
509: THEN
510: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
511: FND_MSG_PUB.ADD;
512: RETURN;
513: ELSIF (G_APPLN_USAGE = 'PM')
514: THEN

Line 515: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_MRV_PM_INSTALL' );

511: FND_MSG_PUB.ADD;
512: RETURN;
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;

Line 524: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_VSTYPE_ID_NULL');

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

Line 536: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

532: FETCH get_visit_id INTO l_mr_visit_type_id;
533:
534: IF GET_VISIT_ID%NOTFOUND
535: THEN
536: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
537: FND_MSG_PUB.ADD;
538: END IF;
539: CLOSE get_visit_id;
540: END IF;

Line 545: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRA_OBJ_VERSION_NULL');

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

Line 551: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_NULL');

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
554: OPEN GetMrDet(p_mr_visit_type_rec.MR_HEADER_ID);
555:

Line 560: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_EDIT_STATUS_INVALID');

556: FETCH GetMrDet into l_mr_rec;
557:
558: IF GetMrDet%NOTFOUND
559: THEN
560: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_EDIT_STATUS_INVALID');
561: FND_MSG_PUB.ADD;
562: -- pdoki Commented for Auto Visit Forecasting Enhancement, Start.
563: /* ELSE
564: IF l_mr_rec.IMPLEMENT_STATUS_CODE<>'OPTIONAL_DO_NOT_IMPLEMENT'

Line 567: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_NOTOPT_DONOT_IMPL');

563: /* ELSE
564: IF l_mr_rec.IMPLEMENT_STATUS_CODE<>'OPTIONAL_DO_NOT_IMPLEMENT'
565: AND p_mr_visit_type_rec.dml_operation<>'D'
566: THEN
567: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_NOTOPT_DONOT_IMPL');
568: FND_MSG_PUB.ADD;
569: END IF;
570: NULL; */
571: -- pdoki Commented for Auto Visit Forecasting Enhancement, End.

Line 586: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRVSTYOE_CODE_DUP');

582: IF CHECK_DUP_VISIT_CODE%FOUND
583: THEN
584: IF p_mr_visit_type_rec.dml_operation='C'
585: THEN
586: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRVSTYOE_CODE_DUP');
587: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_visit_type_rec.mr_visit_type,'')||'-''-',false);
588: FND_MSG_PUB.ADD;
589: ELSIF p_mr_visit_type_rec.dml_operation='U'
590: and l_act_Rec.mr_visit_type_id<>p_mr_visit_type_rec.mr_visit_type_ID

Line 587: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_visit_type_rec.mr_visit_type,'')||'-''-',false);

583: THEN
584: IF p_mr_visit_type_rec.dml_operation='C'
585: THEN
586: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRVSTYOE_CODE_DUP');
587: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_visit_type_rec.mr_visit_type,'')||'-''-',false);
588: FND_MSG_PUB.ADD;
589: ELSIF p_mr_visit_type_rec.dml_operation='U'
590: and l_act_Rec.mr_visit_type_id<>p_mr_visit_type_rec.mr_visit_type_ID
591: THEN

Line 592: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRVSTYPE_CODE_DUP');

588: FND_MSG_PUB.ADD;
589: ELSIF p_mr_visit_type_rec.dml_operation='U'
590: and l_act_Rec.mr_visit_type_id<>p_mr_visit_type_rec.mr_visit_type_ID
591: THEN
592: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRVSTYPE_CODE_DUP');
593: FND_MESSAGE.SET_TOKEN('RECORD',p_mr_visit_type_rec.mr_visit_type,false);
594: FND_MSG_PUB.ADD;
595: END IF;
596: END IF;

Line 593: FND_MESSAGE.SET_TOKEN('RECORD',p_mr_visit_type_rec.mr_visit_type,false);

589: ELSIF p_mr_visit_type_rec.dml_operation='U'
590: and l_act_Rec.mr_visit_type_id<>p_mr_visit_type_rec.mr_visit_type_ID
591: THEN
592: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRVSTYPE_CODE_DUP');
593: FND_MESSAGE.SET_TOKEN('RECORD',p_mr_visit_type_rec.mr_visit_type,false);
594: FND_MSG_PUB.ADD;
595: END IF;
596: END IF;
597: CLOSE CHECK_DUP_VISIT_CODE;

Line 604: FND_MESSAGE.SET_NAME('AHL', 'AHL_FMP_MRV_MO_PROC');

600: OPEN check_mo_proc(p_mr_visit_type_rec.MR_HEADER_ID);
601: FETCH check_mo_proc INTO l_dummy_char;
602: IF (check_mo_proc%FOUND)
603: THEN
604: FND_MESSAGE.SET_NAME('AHL', 'AHL_FMP_MRV_MO_PROC');
605: -- Cannot associate visit types to a Maintenance Requirement of (M) and (0) procedure program type.
606: FND_MSG_PUB.ADD;
607: END IF;
608: -- Tamal [MEL/CDL] -- End changes

Line 616: FND_MESSAGE.SET_NAME('AHL', 'AHL_FMP_CANNOT_ASSIGN_VST_TYPE');

612: OPEN Check_Visit_Type(p_mr_visit_type_rec.MR_HEADER_ID);
613: FETCH Check_Visit_Type INTO l_dummy_char;
614: IF (Check_Visit_Type%FOUND)
615: THEN
616: FND_MESSAGE.SET_NAME('AHL', 'AHL_FMP_CANNOT_ASSIGN_VST_TYPE');
617: -- Cannot associate more than one visit type to a Planned Maintenance Requirement.
618: FND_MSG_PUB.ADD;
619: END IF;
620: CLOSE Check_Visit_Type;

Line 630: FND_MESSAGE.SET_NAME('AHL', 'AHL_FMP_NO_MAINT_ORG');

626: IF (Get_Plan_MR_title%FOUND) THEN
627: OPEN Check_MR_Org(l_mr_title);
628: FETCH Check_MR_Org INTO l_dummy_char;
629: IF (Check_MR_Org%NOTFOUND) THEN
630: FND_MESSAGE.SET_NAME('AHL', 'AHL_FMP_NO_MAINT_ORG');
631: FND_MSG_PUB.ADD;
632: END IF;
633: CLOSE Check_MR_Org;
634: END IF;