DBA Data[Home] [Help]

APPS.AHL_DI_PRO_TYPE_ASO_PVT dependencies on FND_MESSAGE

Line 97: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NULL');

93:
94: (p_document_sub_type_id IS NOT NULL
95: AND l_doc_type_code IS NULL)
96: THEN
97: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NULL');
98: FND_MSG_PUB.ADD;
99: END IF;
100: -- This condition checks for doc sub type code
101: IF (p_document_sub_type_id IS NULL AND

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

104: (p_document_sub_type_id IS NOT NULL
105: AND l_doc_sub_type_code IS NULL)
106:
107: THEN
108: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUB_TYPE_CODE_NULL');
109: FND_MSG_PUB.ADD;
110: END IF;
111: -- This condiiton checks for existence of Doc Type code in fnd lookups
112: IF p_doc_type_code IS NOT NULL

Line 118: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NOT_EXIST');

114: OPEN get_doc_type_code(p_doc_type_code);
115: FETCH get_doc_type_code INTO l_dummy;
116: IF get_doc_type_code%NOTFOUND
117: THEN
118: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NOT_EXIST');
119: FND_MSG_PUB.ADD;
120: END IF;
121: CLOSE get_doc_type_code;
122: END IF;

Line 130: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUBT_COD_NOT_EXIST');

126: OPEN get_doc_sub_type_code(p_doc_sub_type_code);
127: FETCH get_doc_sub_type_code INTO l_dummy,l_meaning;
128: IF get_doc_sub_type_code%NOTFOUND
129: THEN
130: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUBT_COD_NOT_EXIST');
131: FND_MSG_PUB.ADD;
132: END IF;
133: CLOSE get_doc_sub_type_code;
134: END IF;

Line 140: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_DUP_RECORD');

136: -- For Bug No:2423646
137: /* OPEN dup_rec(l_doc_type_code , l_doc_sub_type_code );
138: FETCH dup_rec INTO l_dummy;
139: IF dup_rec%FOUND THEN
140: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_DUP_RECORD');
141: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_meaning);
142: FND_MSG_PUB.ADD;
143: END IF;
144: CLOSE dup_rec;

Line 141: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_meaning);

137: /* OPEN dup_rec(l_doc_type_code , l_doc_sub_type_code );
138: FETCH dup_rec INTO l_dummy;
139: IF dup_rec%FOUND THEN
140: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_DUP_RECORD');
141: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_meaning);
142: FND_MSG_PUB.ADD;
143: END IF;
144: CLOSE dup_rec;
145: */

Line 255: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_REC_NOT_FOUND');

251: l_doc_type_code,
252: l_doc_sub_type_code,
253: l_object_version_number;
254: IF (get_doc_sub_rec_info%NOTFOUND) THEN
255: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_REC_NOT_FOUND');
256: FND_MSG_PUB.ADD;
257: END IF;
258: CLOSE get_doc_sub_rec_info;
259:

Line 263: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');

259:
260: -- Check for version number
261: IF (l_object_version_number <> p_doc_type_assoc_tbl(i).object_version_number)
262: THEN
263: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');
264: FND_MESSAGE.SET_TOKEN('SUBTYPE',initcap(l_doc_sub_type_code));
265:
266: FND_MSG_PUB.ADD;
267: END IF;

Line 264: FND_MESSAGE.SET_TOKEN('SUBTYPE',initcap(l_doc_sub_type_code));

260: -- Check for version number
261: IF (l_object_version_number <> p_doc_type_assoc_tbl(i).object_version_number)
262: THEN
263: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');
264: FND_MESSAGE.SET_TOKEN('SUBTYPE',initcap(l_doc_sub_type_code));
265:
266: FND_MSG_PUB.ADD;
267: END IF;
268:

Line 281: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REC_EXISTS');

277: FETCH get_doc_sub_type_code INTO l_dummy,l_meaning;
278: CLOSE get_doc_sub_type_code;
279:
280:
281: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REC_EXISTS');
282: -- FND_MESSAGE.SEt_TOKEN('SUBTYPNAME',l_meaning);
283:
284: -- FND_MSG_PUB.ADD;
285:

Line 282: -- FND_MESSAGE.SEt_TOKEN('SUBTYPNAME',l_meaning);

278: CLOSE get_doc_sub_type_code;
279:
280:
281: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REC_EXISTS');
282: -- FND_MESSAGE.SEt_TOKEN('SUBTYPNAME',l_meaning);
283:
284: -- FND_MSG_PUB.ADD;
285:
286:

Line 508: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_DUP_RECORD');

504: IF dup_rec%FOUND THEN
505: OPEN get_doc_sub_type_code(p_x_doc_type_assoc_tbl(i).doc_sub_type_code);
506: FETCH get_doc_sub_type_code INTO l_dummy,l_meaning;
507: CLOSE get_doc_sub_type_code ;
508: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_DUP_RECORD');
509: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_meaning);
510: FND_MSG_PUB.ADD;
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;

Line 509: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_meaning);

505: OPEN get_doc_sub_type_code(p_x_doc_type_assoc_tbl(i).doc_sub_type_code);
506: FETCH get_doc_sub_type_code INTO l_dummy,l_meaning;
507: CLOSE get_doc_sub_type_code ;
508: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_DUP_RECORD');
509: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_meaning);
510: FND_MSG_PUB.ADD;
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513: CLOSE dup_rec;

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

811: -- updating same record...02/05/02
812: /*
813: IF (l_doc_type_assoc_info.object_version_number <>p_x_doc_type_assoc_tbl(i).object_version_number)
814: THEN
815: -- FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
816: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');
817: -- FND_MESSAGE.SET_TOKEN('SUBTYPE',initcap(l_doc_sub_type_code));
818:
819:

Line 816: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');

812: /*
813: IF (l_doc_type_assoc_info.object_version_number <>p_x_doc_type_assoc_tbl(i).object_version_number)
814: THEN
815: -- FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
816: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');
817: -- FND_MESSAGE.SET_TOKEN('SUBTYPE',initcap(l_doc_sub_type_code));
818:
819:
820: -- FND_MSG_PUB.ADD;

Line 817: -- FND_MESSAGE.SET_TOKEN('SUBTYPE',initcap(l_doc_sub_type_code));

813: IF (l_doc_type_assoc_info.object_version_number <>p_x_doc_type_assoc_tbl(i).object_version_number)
814: THEN
815: -- FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
816: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');
817: -- FND_MESSAGE.SET_TOKEN('SUBTYPE',initcap(l_doc_sub_type_code));
818:
819:
820: -- FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;

Line 901: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_DUP_RECORD');

897: WHEN DUP_VAL_ON_INDEX THEN
898: OPEN get_doc_sub_type_code(l_doc_type_assoc_info.doc_sub_type_code);
899: FETCH get_doc_sub_type_code INTO l_meaning;
900: CLOSE get_doc_sub_type_code;
901: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_DUP_RECORD');
902: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_meaning);
903: FND_MSG_PUB.ADD;
904: END;
905:

Line 902: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_meaning);

898: OPEN get_doc_sub_type_code(l_doc_type_assoc_info.doc_sub_type_code);
899: FETCH get_doc_sub_type_code INTO l_meaning;
900: CLOSE get_doc_sub_type_code;
901: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_DUP_RECORD');
902: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_meaning);
903: FND_MSG_PUB.ADD;
904: END;
905:
906: IF G_DEBUG='Y' THEN

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

922: --Checks for weather the exists or not
923: OPEN get_doc_sub_rec_info(p_x_doc_type_assoc_tbl(i).document_sub_type_id);
924: FETCH get_doc_sub_rec_info INTO l_doc_type_assoc_info;
925: IF (get_doc_sub_rec_info%NOTFOUND) THEN
926: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');
927: FND_MESSAGE.SET_TOKEN('SUBTYPE',initcap(p_x_doc_type_assoc_tbl(i).doc_sub_type_code));
928: FND_MSG_PUB.ADD;
929: END IF;
930: CLOSE get_doc_sub_rec_info;

Line 927: FND_MESSAGE.SET_TOKEN('SUBTYPE',initcap(p_x_doc_type_assoc_tbl(i).doc_sub_type_code));

923: OPEN get_doc_sub_rec_info(p_x_doc_type_assoc_tbl(i).document_sub_type_id);
924: FETCH get_doc_sub_rec_info INTO l_doc_type_assoc_info;
925: IF (get_doc_sub_rec_info%NOTFOUND) THEN
926: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');
927: FND_MESSAGE.SET_TOKEN('SUBTYPE',initcap(p_x_doc_type_assoc_tbl(i).doc_sub_type_code));
928: FND_MSG_PUB.ADD;
929: END IF;
930: CLOSE get_doc_sub_rec_info;
931:

Line 935: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');

931:
932: -- Check for version number
933: IF (l_object_version_number <>p_x_doc_type_assoc_tbl(i).object_version_number)
934: THEN
935: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');
936: FND_MESSAGE.SET_TOKEN('SUBTYPE',l_doc_sub_type_code);
937: END IF;
938:
939: -- Check for association type Exists in Documents table

Line 936: FND_MESSAGE.SET_TOKEN('SUBTYPE',l_doc_sub_type_code);

932: -- Check for version number
933: IF (l_object_version_number <>p_x_doc_type_assoc_tbl(i).object_version_number)
934: THEN
935: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');
936: FND_MESSAGE.SET_TOKEN('SUBTYPE',l_doc_sub_type_code);
937: END IF;
938:
939: -- Check for association type Exists in Documents table
940: IF p_x_doc_type_assoc_tbl(i).document_sub_type_id IS NOT NULL

Line 950: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REC_EXISTS');

946: OPEN get_doc_sub_type_code(l_doc_type_assoc_info.doc_sub_type_code);
947: FETCH get_doc_sub_type_code INTO l_meaning;
948: CLOSE get_doc_sub_type_code;
949:
950: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REC_EXISTS');
951: FND_MESSAGE.SET_TOKEN('SUBTYPNAME',l_meaning);
952: FND_MSG_PUB.ADD;
953:
954:

Line 951: FND_MESSAGE.SET_TOKEN('SUBTYPNAME',l_meaning);

947: FETCH get_doc_sub_type_code INTO l_meaning;
948: CLOSE get_doc_sub_type_code;
949:
950: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REC_EXISTS');
951: FND_MESSAGE.SET_TOKEN('SUBTYPNAME',l_meaning);
952: FND_MSG_PUB.ADD;
953:
954:
955: CLOSE Check_Doc_Record;