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_DI_ASSO_DOCASO_PVT dependencies on FND_MESSAGE

Line 507: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJ_TYP_NOT_EXISTS');

503: THEN
504: IF p_x_association_tbl(i).aso_object_type_code IS NULL or
505: p_x_association_tbl(i).aso_object_type_code = FND_API.G_MISS_CHAR
506: Then
507: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJ_TYP_NOT_EXISTS');
508: FND_MSG_PUB.ADD;
509: END IF;
510: END IF;
511:

Line 525: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_NULL');

521: THEN
522: IF (p_x_association_tbl(i).document_no IS NULL or
523: p_x_association_tbl(i).document_no=FND_API.G_MISS_CHAR)
524: THEN
525: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_NULL');
526: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
527: FND_MSG_PUB.ADD;
528: IF G_DEBUG='Y' THEN
529: AHL_DEBUG_PUB.debug( 'Stage 002');

Line 526: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

522: IF (p_x_association_tbl(i).document_no IS NULL or
523: p_x_association_tbl(i).document_no=FND_API.G_MISS_CHAR)
524: THEN
525: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_NULL');
526: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
527: FND_MSG_PUB.ADD;
528: IF G_DEBUG='Y' THEN
529: AHL_DEBUG_PUB.debug( 'Stage 002');
530: END IF;

Line 537: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_NULL');

533: ELSE
534: IF (p_x_association_tbl(i).document_no IS NULL or
535: p_x_association_tbl(i).document_no=FND_API.G_MISS_CHAR)
536: THEN
537: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_NULL');
538: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
539: FND_MSG_PUB.ADD;
540: IF G_DEBUG='Y' THEN
541: AHL_DEBUG_PUB.debug( 'Document number Null');

Line 538: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

534: IF (p_x_association_tbl(i).document_no IS NULL or
535: p_x_association_tbl(i).document_no=FND_API.G_MISS_CHAR)
536: THEN
537: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_NULL');
538: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
539: FND_MSG_PUB.ADD;
540: IF G_DEBUG='Y' THEN
541: AHL_DEBUG_PUB.debug( 'Document number Null');
542: END IF;

Line 549: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_INVALID');

545: OPEN GetDocCheck(p_x_association_tbl(i).document_no);
546: FETCH GetDocCheck INTO l_counter2;
547: IF l_counter2=0
548: THEN
549: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_INVALID');
550: FND_MESSAGE.SET_TOKEN('FIELD',p_x_association_tbl(i).document_no);
551: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
552: FND_MSG_PUB.ADD;
553: IF G_DEBUG='Y' THEN

Line 550: FND_MESSAGE.SET_TOKEN('FIELD',p_x_association_tbl(i).document_no);

546: FETCH GetDocCheck INTO l_counter2;
547: IF l_counter2=0
548: THEN
549: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_INVALID');
550: FND_MESSAGE.SET_TOKEN('FIELD',p_x_association_tbl(i).document_no);
551: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
552: FND_MSG_PUB.ADD;
553: IF G_DEBUG='Y' THEN
554: AHL_DEBUG_PUB.debug( 'Document number Does not exist');

Line 551: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

547: IF l_counter2=0
548: THEN
549: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_INVALID');
550: FND_MESSAGE.SET_TOKEN('FIELD',p_x_association_tbl(i).document_no);
551: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
552: FND_MSG_PUB.ADD;
553: IF G_DEBUG='Y' THEN
554: AHL_DEBUG_PUB.debug( 'Document number Does not exist');
555: END IF;

Line 572: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCNO_WITHNO_REV');

568: AND upper(a.document_no)=upper(p_x_association_tbl(i).document_no);
569:
570: IF l_counter3=0
571: THEN
572: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCNO_WITHNO_REV');
573: FND_MESSAGE.SET_TOKEN('FIELD',p_x_association_tbl(i).document_no);
574: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
575: FND_MSG_PUB.ADD;
576: IF G_DEBUG='Y' THEN

Line 573: FND_MESSAGE.SET_TOKEN('FIELD',p_x_association_tbl(i).document_no);

569:
570: IF l_counter3=0
571: THEN
572: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCNO_WITHNO_REV');
573: FND_MESSAGE.SET_TOKEN('FIELD',p_x_association_tbl(i).document_no);
574: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
575: FND_MSG_PUB.ADD;
576: IF G_DEBUG='Y' THEN
577: AHL_DEBUG_PUB.debug( 'Revision for Document number does not exist');

Line 574: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

570: IF l_counter3=0
571: THEN
572: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCNO_WITHNO_REV');
573: FND_MESSAGE.SET_TOKEN('FIELD',p_x_association_tbl(i).document_no);
574: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
575: FND_MSG_PUB.ADD;
576: IF G_DEBUG='Y' THEN
577: AHL_DEBUG_PUB.debug( 'Revision for Document number does not exist');
578: END IF;

Line 591: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_REVISION_NO_NULL');

587: p_x_association_tbl(i).revision_no=fnd_api.g_miss_char)
588: THEN
589: IF l_counter2<>1
590: THEN
591: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_REVISION_NO_NULL');
592: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
593: FND_MSG_PUB.ADD;
594: IF G_DEBUG='Y' THEN
595: AHL_DEBUG_PUB.debug( 'Revision for Document is null');

Line 592: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

588: THEN
589: IF l_counter2<>1
590: THEN
591: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_REVISION_NO_NULL');
592: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
593: FND_MSG_PUB.ADD;
594: IF G_DEBUG='Y' THEN
595: AHL_DEBUG_PUB.debug( 'Revision for Document is null');
596: END IF;

Line 599: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');

595: AHL_DEBUG_PUB.debug( 'Revision for Document is null');
596: END IF;
597:
598: l_check_flag:='N';
599: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');
600: FND_MSG_PUB.ADD;
601: IF G_DEBUG='Y' THEN
602: AHL_DEBUG_PUB.debug( 'Select document from lov');
603: END IF;

Line 611: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_REVISION_NO_INVALID');

607: OPEN GetRevCheck(p_x_association_tbl(i).revision_no);
608: FETCH GetRevCheck INTO l_counter2;
609: IF l_counter2=0
610: THEN
611: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_REVISION_NO_INVALID');
612: FND_MESSAGE.SET_TOKEN('FIELD',p_x_association_tbl(i).revision_no);
613: FND_MESSAGE.SET_TOKEN('RECORD',l_record,false);
614: FND_MSG_PUB.ADD;
615: IF G_DEBUG='Y' THEN

Line 612: FND_MESSAGE.SET_TOKEN('FIELD',p_x_association_tbl(i).revision_no);

608: FETCH GetRevCheck INTO l_counter2;
609: IF l_counter2=0
610: THEN
611: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_REVISION_NO_INVALID');
612: FND_MESSAGE.SET_TOKEN('FIELD',p_x_association_tbl(i).revision_no);
613: FND_MESSAGE.SET_TOKEN('RECORD',l_record,false);
614: FND_MSG_PUB.ADD;
615: IF G_DEBUG='Y' THEN
616: AHL_DEBUG_PUB.debug( 'Revision for Document number is invalid');

Line 613: FND_MESSAGE.SET_TOKEN('RECORD',l_record,false);

609: IF l_counter2=0
610: THEN
611: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_REVISION_NO_INVALID');
612: FND_MESSAGE.SET_TOKEN('FIELD',p_x_association_tbl(i).revision_no);
613: FND_MESSAGE.SET_TOKEN('RECORD',l_record,false);
614: FND_MSG_PUB.ADD;
615: IF G_DEBUG='Y' THEN
616: AHL_DEBUG_PUB.debug( 'Revision for Document number is invalid');
617: END IF;

Line 631: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');

627: OPEN GetdocCount(p_x_association_tbl(i).document_no);
628: FETCH GetdocCount INTO l_counter;
629: IF l_counter=0
630: THEN
631: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');
632: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);
633: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);
634: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
635: FND_MSG_PUB.ADD;

Line 632: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);

628: FETCH GetdocCount INTO l_counter;
629: IF l_counter=0
630: THEN
631: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');
632: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);
633: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);
634: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
635: FND_MSG_PUB.ADD;
636: IF G_DEBUG='Y' THEN

Line 633: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);

629: IF l_counter=0
630: THEN
631: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');
632: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);
633: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);
634: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
635: FND_MSG_PUB.ADD;
636: IF G_DEBUG='Y' THEN
637: AHL_DEBUG_PUB.debug( 'Revision and Document number combination does not exist');

Line 634: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

630: THEN
631: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');
632: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);
633: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);
634: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
635: FND_MSG_PUB.ADD;
636: IF G_DEBUG='Y' THEN
637: AHL_DEBUG_PUB.debug( 'Revision and Document number combination does not exist');
638: END IF;

Line 653: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');

649: p_x_association_tbl(i).document_id :=l_doc_rec.document_id;
650: p_x_association_tbl(i).revision_no:=l_doc_rec.Revision_no;
651: p_x_association_tbl(i).doc_revision_id:=l_doc_rec.doc_Revision_id;
652: ELSE
653: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');
654: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);
655: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);
656: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
657: FND_MSG_PUB.ADD;

Line 654: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);

650: p_x_association_tbl(i).revision_no:=l_doc_rec.Revision_no;
651: p_x_association_tbl(i).doc_revision_id:=l_doc_rec.doc_Revision_id;
652: ELSE
653: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');
654: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);
655: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);
656: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
657: FND_MSG_PUB.ADD;
658:

Line 655: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);

651: p_x_association_tbl(i).doc_revision_id:=l_doc_rec.doc_Revision_id;
652: ELSE
653: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');
654: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);
655: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);
656: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
657: FND_MSG_PUB.ADD;
658:
659: IF G_DEBUG='Y' THEN

Line 656: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

652: ELSE
653: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');
654: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);
655: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);
656: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
657: FND_MSG_PUB.ADD;
658:
659: IF G_DEBUG='Y' THEN
660: AHL_DEBUG_PUB.debug( 'Revision and Document number combination does not exist');

Line 678: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');

674: p_x_association_tbl(i).document_id :=l_docdet_rec.document_id;
675: p_x_association_tbl(i).revision_no:=l_docdet_rec.Revision_no;
676: p_x_association_tbl(i).doc_revision_id:=l_docdet_rec.doc_Revision_id;
677: ELSE
678: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');
679: FND_MSG_PUB.ADD;
680: END IF;
681: ELSE
682: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');

Line 682: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');

678: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');
679: FND_MSG_PUB.ADD;
680: END IF;
681: ELSE
682: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');
683: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);
684: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);
685: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
686: FND_MSG_PUB.ADD;

Line 683: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);

679: FND_MSG_PUB.ADD;
680: END IF;
681: ELSE
682: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');
683: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);
684: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);
685: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
686: FND_MSG_PUB.ADD;
687: END IF;

Line 684: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);

680: END IF;
681: ELSE
682: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');
683: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);
684: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);
685: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
686: FND_MSG_PUB.ADD;
687: END IF;
688: CLOSE GetDocDetail;

Line 685: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

681: ELSE
682: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOC_REV_COMB_INVLD');
683: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);
684: FND_MESSAGE.SET_TOKEN('FIELD2',p_x_association_tbl(i).document_no);
685: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
686: FND_MSG_PUB.ADD;
687: END IF;
688: CLOSE GetDocDetail;
689: END IF;

Line 861: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MR_NOTEDITABLE');

857: WHERE MR_HEADER_ID=p_association_rec.ASO_OBJECT_ID;
858:
859: IF L_TYPE_CODE='PROGRAM'
860: THEN
861: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MR_NOTEDITABLE');
862: FND_MSG_PUB.ADD;
863: END IF;
864:
865: END IF;

Line 894: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_STAT_DRFT_ASO');

890: FETCH get_operation_status INTO l_status;
891: CLOSE get_operation_status;
892: IF l_status <> 'DRAFT' AND l_status <> 'APPROVAL_REJECTED'
893: THEN
894: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_STAT_DRFT_ASO');
895: FND_MSG_PUB.ADD;
896: RETURN;
897: END IF;
898: END IF;

Line 907: FND_MESSAGE.SET_NAME('AHL','AHL_RM_ROU_STAT_DRFT_ASO');

903: CLOSE get_route_status;
904:
905: IF l_status <> 'DRAFT' AND l_status <> 'APPROVAL_REJECTED'
906: THEN
907: FND_MESSAGE.SET_NAME('AHL','AHL_RM_ROU_STAT_DRFT_ASO');
908: FND_MSG_PUB.ADD;
909: RETURN;
910: END IF;
911: END IF;

Line 919: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_INVALID');

915: OPEN GetRevDet(p_association_rec.doc_revision_id);
916: FETCH GetRevDet INTO l_rev_rec1;
917: IF GetRevDet%notfound
918: then
919: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_INVALID');
920: FND_MESSAGE.SET_TOKEN('field',l_record);
921: FND_MSG_PUB.ADD;
922: RETURN;
923: else

Line 920: FND_MESSAGE.SET_TOKEN('field',l_record);

916: FETCH GetRevDet INTO l_rev_rec1;
917: IF GetRevDet%notfound
918: then
919: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_INVALID');
920: FND_MESSAGE.SET_TOKEN('field',l_record);
921: FND_MSG_PUB.ADD;
922: RETURN;
923: else
924: IF TRUNC(NVL(l_rev_rec1.obsolete_date,SYSDATE+1)) < TRUNC(sysdate)

Line 926: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');

922: RETURN;
923: else
924: IF TRUNC(NVL(l_rev_rec1.obsolete_date,SYSDATE+1)) < TRUNC(sysdate)
925: THEN
926: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');
927: FND_MESSAGE.SET_TOKEN('FIELD1',p_association_rec.document_no);
928: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);
929: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
930: FND_MSG_PUB.ADD;

Line 927: FND_MESSAGE.SET_TOKEN('FIELD1',p_association_rec.document_no);

923: else
924: IF TRUNC(NVL(l_rev_rec1.obsolete_date,SYSDATE+1)) < TRUNC(sysdate)
925: THEN
926: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');
927: FND_MESSAGE.SET_TOKEN('FIELD1',p_association_rec.document_no);
928: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);
929: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
930: FND_MSG_PUB.ADD;
931: END IF;

Line 928: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);

924: IF TRUNC(NVL(l_rev_rec1.obsolete_date,SYSDATE+1)) < TRUNC(sysdate)
925: THEN
926: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');
927: FND_MESSAGE.SET_TOKEN('FIELD1',p_association_rec.document_no);
928: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);
929: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
930: FND_MSG_PUB.ADD;
931: END IF;
932: END IF;

Line 929: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

925: THEN
926: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');
927: FND_MESSAGE.SET_TOKEN('FIELD1',p_association_rec.document_no);
928: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);
929: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
930: FND_MSG_PUB.ADD;
931: END IF;
932: END IF;
933:

Line 946: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_ID_NULL');

942: OR
943: ((p_association_rec.doc_title_asso_id IS NOT NULL OR
944: p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_document_id IS NULL)
945: THEN
946: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_ID_NULL');
947: FND_MSG_PUB.ADD;
948: END IF;
949:
950: -- This condition checks for Aso Object Type Code is Null

Line 961: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_TYPE_NULL');

957: ((p_association_rec.doc_title_asso_id IS NOT NULL OR
958: p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM)
959: AND l_aso_object_type_code IS NULL)
960: THEN
961: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_TYPE_NULL');
962: FND_MSG_PUB.ADD;
963: END IF;
964:
965: -- This condiiton checks for Aso Object Id Value Is Null

Line 974: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_ID_NULL');

970: OR
971: ((p_association_rec.doc_title_asso_id IS NOT NULL OR
972: p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_aso_object_id IS NULL)
973: THEN
974: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_ID_NULL');
975: FND_MSG_PUB.ADD;
976: END IF;
977:
978: --Check for Aso Object Type Code in fnd lookups

Line 987: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJ_TYPE_NOT_EXISTS');

983: OPEN get_aso_obj_type_code(p_association_rec.aso_object_type_code);
984: FETCH get_aso_obj_type_code INTO l_dummy;
985: IF get_aso_obj_type_code%NOTFOUND
986: THEN
987: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJ_TYPE_NOT_EXISTS');
988: FND_MSG_PUB.ADD;
989: END IF;
990: CLOSE get_aso_obj_type_code;
991: END IF;

Line 1015: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TABDOC_ASSOS_DUP_RECORD');

1011: IF dup_Rec%found
1012: then
1013: IF p_association_rec.DML_OPERATION='C'
1014: THEN
1015: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TABDOC_ASSOS_DUP_RECORD');
1016: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
1017: FND_MSG_PUB.ADD;
1018: END IF;
1019: --bug fix : pbarman : May 23 rd 2003

Line 1016: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

1012: then
1013: IF p_association_rec.DML_OPERATION='C'
1014: THEN
1015: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TABDOC_ASSOS_DUP_RECORD');
1016: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
1017: FND_MSG_PUB.ADD;
1018: END IF;
1019: --bug fix : pbarman : May 23 rd 2003
1020: --IF p_association_rec.DML_OPERATION='U'

Line 1027: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_TABDOC_ASSOS_DUP_RECORD');

1023: -- IF nvl(p_association_rec.doc_title_asso_id,0)<>nvl(l_dup_rec.doc_title_asso_id,0)
1024: -- THEN
1025:
1026:
1027: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_TABDOC_ASSOS_DUP_RECORD');
1028: -- FND_MESSAGE.SET_TOKEN('RECORD',l_record);
1029: -- FND_MSG_PUB.ADD;
1030: -- IF G_DEBUG='Y' THEN
1031: -- AHL_DEBUG_PUB.debug( 'Dup_record Not Found' ,'+DOBJASS+');

Line 1028: -- FND_MESSAGE.SET_TOKEN('RECORD',l_record);

1024: -- THEN
1025:
1026:
1027: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_TABDOC_ASSOS_DUP_RECORD');
1028: -- FND_MESSAGE.SET_TOKEN('RECORD',l_record);
1029: -- FND_MSG_PUB.ADD;
1030: -- IF G_DEBUG='Y' THEN
1031: -- AHL_DEBUG_PUB.debug( 'Dup_record Not Found' ,'+DOBJASS+');
1032: -- END IF;

Line 1060: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_DUP_YES');

1056: AND use_latest_rev_flag<>NVL(p_association_rec.use_latest_rev_flag,'N');
1057:
1058: if l_counter1>0
1059: then
1060: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_DUP_YES');
1061: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
1062: FND_MSG_PUB.ADD;
1063:
1064: elsif (l_counter>0 and p_association_rec.DML_OPERATION='C') OR (l_counter>1 and p_association_rec.DML_OPERATION='U')

Line 1061: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

1057:
1058: if l_counter1>0
1059: then
1060: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_DUP_YES');
1061: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
1062: FND_MSG_PUB.ADD;
1063:
1064: elsif (l_counter>0 and p_association_rec.DML_OPERATION='C') OR (l_counter>1 and p_association_rec.DML_OPERATION='U')
1065: then

Line 1070: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_FLAG');

1066: open CheckLatestRevFlag(NVL(p_association_rec.DOC_TITLE_ASSO_ID,0),p_association_rec.aso_object_id,p_association_rec.aso_object_type_code,p_association_rec.document_id,NVL(p_association_rec.use_latest_rev_flag,'X'));
1067: fetch CheckLatestRevFlag intO l_lat_rec;
1068: IF CheckLatestRevFlag%FOUND
1069: THEN
1070: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_FLAG');
1071: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
1072: FND_MSG_PUB.ADD;
1073: END IF;
1074: close CheckLatestRevFlag;

Line 1071: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

1067: fetch CheckLatestRevFlag intO l_lat_rec;
1068: IF CheckLatestRevFlag%FOUND
1069: THEN
1070: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_FLAG');
1071: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
1072: FND_MSG_PUB.ADD;
1073: END IF;
1074: close CheckLatestRevFlag;
1075: end if;

Line 1298: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TABDOC_ASSOS_DUP_RECORD');

1294: )
1295: THEN
1296:
1297:
1298: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TABDOC_ASSOS_DUP_RECORD');
1299: RECORD_IDENTIFIER
1300: (
1301: p_association_rec =>p_x_association_tbl(i),
1302: x_record =>l_record

Line 1305: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

1301: p_association_rec =>p_x_association_tbl(i),
1302: x_record =>l_record
1303: );
1304:
1305: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
1306: FND_MSG_PUB.ADD;
1307: RAISE FND_API.G_EXC_ERROR;
1308:
1309: END IF;

Line 1317: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TABDOC_ASSOS_DUP_RECORD');

1313:
1314: IF l_found_flag = 'N'
1315: THEN
1316:
1317: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TABDOC_ASSOS_DUP_RECORD');
1318: RECORD_IDENTIFIER
1319: (
1320: p_association_rec =>p_x_association_tbl(i),
1321: x_record =>l_record

Line 1324: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

1320: p_association_rec =>p_x_association_tbl(i),
1321: x_record =>l_record
1322: );
1323:
1324: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
1325: FND_MSG_PUB.ADD;
1326: RAISE FND_API.G_EXC_ERROR;
1327: END IF;
1328:

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

1339: delete from AHL_DOC_TITLE_ASSOS_TL
1340: where DOC_TITLE_ASSO_ID = p_x_association_tbl(I).DOC_TITLE_ASSO_ID;
1341: IF (sql%notfound)
1342: THEN
1343: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1344: FND_MSG_PUB.ADD;
1345: ELSE
1346: delete from AHL_DOC_TITLE_ASSOS_B
1347: where DOC_TITLE_ASSO_ID = p_x_association_tbl(I).DOC_TITLE_ASSO_ID

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

1348: and OBJECT_VERSION_NUMBER=p_x_association_tbl(I).OBJECT_VERSION_NUMBER;
1349:
1350: IF (sql%notfound)
1351: THEN
1352: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1353: FND_MSG_PUB.ADD;
1354: END IF;
1355: END IF;
1356: ELSIF p_x_association_tbl(i).DML_OPERATION ='U'

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

1388:
1389:
1390: IF (sql%notfound)
1391: THEN
1392: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1393: FND_MSG_PUB.ADD;
1394: ELSE
1395: update AHL_DOC_TITLE_ASSOS_TL set
1396: CHAPTER = p_x_association_tbl(i).CHAPTER,

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

1406: where DOC_TITLE_ASSO_ID = p_x_association_tbl(i).DOC_TITLE_ASSO_ID
1407: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1408: IF (sql%notfound)
1409: THEN
1410: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1411: FND_MSG_PUB.ADD;
1412: END IF;
1413: END IF;
1414: ELSIF p_x_association_tbl(i).DML_OPERATION ='C'