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_MSG_PUB

Line 508: FND_MSG_PUB.ADD;

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:
512: RECORD_IDENTIFIER

Line 527: FND_MSG_PUB.ADD;

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;
531: l_check_flag:='N';

Line 539: FND_MSG_PUB.ADD;

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;
543: l_check_flag:='N';

Line 552: FND_MSG_PUB.ADD;

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;
556: l_check_flag:='N';

Line 575: FND_MSG_PUB.ADD;

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

Line 593: FND_MSG_PUB.ADD;

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

Line 600: FND_MSG_PUB.ADD;

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;
604: END IF;

Line 614: FND_MSG_PUB.ADD;

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

Line 635: FND_MSG_PUB.ADD;

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

Line 657: FND_MSG_PUB.ADD;

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');
661: END IF;

Line 679: FND_MSG_PUB.ADD;

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');
683: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_association_tbl(i).revision_no);

Line 686: FND_MSG_PUB.ADD;

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;
690: END IF;

Line 862: FND_MSG_PUB.ADD;

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

Line 895: FND_MSG_PUB.ADD;

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

Line 908: FND_MSG_PUB.ADD;

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

Line 921: FND_MSG_PUB.ADD;

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)
925: THEN

Line 930: FND_MSG_PUB.ADD;

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

Line 947: FND_MSG_PUB.ADD;

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

Line 962: FND_MSG_PUB.ADD;

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
966: IF ((p_association_rec.doc_title_asso_id IS NULL OR

Line 975: FND_MSG_PUB.ADD;

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

Line 988: FND_MSG_PUB.ADD;

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

Line 1017: FND_MSG_PUB.ADD;

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'
1021: --THEN

Line 1029: -- FND_MSG_PUB.ADD;

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;
1033: -- END IF;

Line 1062: FND_MSG_PUB.ADD;

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

Line 1072: FND_MSG_PUB.ADD;

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

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

1083: END IF;
1084: EXCEPTION
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1086: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1088: p_count => x_msg_count,
1089: p_data => x_msg_data);
1090: WHEN FND_API.G_EXC_ERROR THEN
1091: X_return_status := FND_API.G_RET_STS_ERROR;

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

1088: p_count => x_msg_count,
1089: p_data => x_msg_data);
1090: WHEN FND_API.G_EXC_ERROR THEN
1091: X_return_status := FND_API.G_RET_STS_ERROR;
1092: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1093: p_count => x_msg_count,
1094: p_data => X_msg_data);
1095: WHEN OTHERS THEN
1096: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1093: p_count => x_msg_count,
1094: p_data => X_msg_data);
1095: WHEN OTHERS THEN
1096: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1098: THEN
1099: fnd_msg_pub.add_exc_msg(p_pkg_name =>g_pkg_name,
1100: p_procedure_name =>'VALIDATE_DOC_ASSOCIATION',
1101: p_error_text =>SUBSTR(SQLERRM,1,240));

Line 1099: fnd_msg_pub.add_exc_msg(p_pkg_name =>g_pkg_name,

1095: WHEN OTHERS THEN
1096: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1098: THEN
1099: fnd_msg_pub.add_exc_msg(p_pkg_name =>g_pkg_name,
1100: p_procedure_name =>'VALIDATE_DOC_ASSOCIATION',
1101: p_error_text =>SUBSTR(SQLERRM,1,240));
1102: END IF;
1103: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1099: fnd_msg_pub.add_exc_msg(p_pkg_name =>g_pkg_name,
1100: p_procedure_name =>'VALIDATE_DOC_ASSOCIATION',
1101: p_error_text =>SUBSTR(SQLERRM,1,240));
1102: END IF;
1103: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1104: p_count => x_msg_count,
1105: p_data => X_msg_data);
1106: END;
1107:

Line 1182: FND_MSG_PUB.initialize;

1178:
1179: -- Initialize message list if p_init_msg_list is set to TRUE.
1180: IF FND_API.to_boolean(p_init_msg_list)
1181: THEN
1182: FND_MSG_PUB.initialize;
1183: END IF;
1184:
1185: -- Initialize API return status to success
1186:

Line 1226: l_msg_count := FND_MSG_PUB.count_msg;

1222: x_return_status =>x_return_Status,
1223: p_x_association_tbl =>p_x_association_tbl
1224: );
1225:
1226: l_msg_count := FND_MSG_PUB.count_msg;
1227:
1228: IF l_msg_count > 0 THEN
1229: X_msg_count := l_msg_count;
1230: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1243: l_msg_count := FND_MSG_PUB.count_msg;

1239: LOOP
1240: l_return_status := FND_API.G_RET_STS_SUCCESS;
1241: l_msg_count:=0;
1242: IF l_msg_count > 0 THEN
1243: l_msg_count := FND_MSG_PUB.count_msg;
1244: l_msg_count := l_msg_count;
1245: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: END IF;
1247:

Line 1306: FND_MSG_PUB.ADD;

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;
1310: END IF;

Line 1325: FND_MSG_PUB.ADD;

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:
1329: END IF;

Line 1344: FND_MSG_PUB.ADD;

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
1348: and OBJECT_VERSION_NUMBER=p_x_association_tbl(I).OBJECT_VERSION_NUMBER;

Line 1353: FND_MSG_PUB.ADD;

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'
1357: THEN

Line 1393: FND_MSG_PUB.ADD;

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,
1397: SECTION = p_x_association_tbl(i).SECTION,

Line 1411: FND_MSG_PUB.ADD;

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'
1415: THEN

Line 1463: l_msg_count := FND_MSG_PUB.count_msg;

1459: END LOOP;
1460:
1461: END IF;
1462:
1463: l_msg_count := FND_MSG_PUB.count_msg;
1464:
1465: IF l_msg_count > 0 THEN
1466: X_msg_count := l_msg_count;
1467: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1484: EXCEPTION
1485: WHEN FND_API.G_EXC_ERROR THEN
1486: ROLLBACK TO PROCESS_association;
1487: X_return_status := FND_API.G_RET_STS_ERROR;
1488: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1489: p_count => x_msg_count,
1490: p_data => X_msg_data);
1491: -- Debug info.
1492: IF G_DEBUG='Y' THEN

Line 1501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1497:
1498: WHEN OTHERS THEN
1499: ROLLBACK TO PROCESS_association;
1500: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1502: THEN
1503: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME ,
1504: p_procedure_name => 'PROCESS_ASSOCIATION',
1505: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1503: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME ,

1499: ROLLBACK TO PROCESS_association;
1500: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1502: THEN
1503: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME ,
1504: p_procedure_name => 'PROCESS_ASSOCIATION',
1505: p_error_text => SUBSTR(SQLERRM,1,240));
1506: END IF;
1507: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1503: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME ,
1504: p_procedure_name => 'PROCESS_ASSOCIATION',
1505: p_error_text => SUBSTR(SQLERRM,1,240));
1506: END IF;
1507: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1508: p_count => x_msg_count,
1509: p_data => X_msg_data);
1510:
1511: END PROCESS_ASSOCIATION;