DBA Data[Home] [Help]

APPS.AHL_DI_ASSO_DOC_ASO_PUB dependencies on FND_MESSAGE

Line 180: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_NO_NULL');

176: --{{adharia-- bug #2450326 - added- 9/7/2002
177: IF (p_x_association_tbl(i).document_no IS NULL) OR
178: (p_x_association_tbl(i).document_no = FND_API.G_MISS_CHAR)
179: THEN
180: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_NO_NULL');
181: FND_MSG_PUB.ADD;
182: ELSE
183:
184: OPEN get_doc_id_info(p_x_association_tbl(i).document_no);

Line 190: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ID_INVALID');

186: IF get_doc_id_info%FOUND
187: THEN
188: l_association_tbl(i).document_id := l_document_id;
189: ELSE
190: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ID_INVALID');
191: FND_MSG_PUB.ADD;
192: END IF;
193: CLOSE get_doc_id_info;
194:

Line 209: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');

205: IF get_doc_rev_info%FOUND
206: THEN
207: l_association_tbl(i).doc_revision_id := l_doc_revision_id;
208: ELSE
209: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');
210: FND_MSG_PUB.ADD;
211: END IF;
212: CLOSE get_doc_rev_info;
213: ELSIF l_rev_count > 1

Line 223: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');

219: IF get_doc_rev_id_info%FOUND
220: THEN
221: l_association_tbl(i).doc_revision_id := l_doc_revision_id;
222: ELSE
223: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');
224: FND_MSG_PUB.ADD;
225: END IF;
226: CLOSE get_doc_rev_id_info;
227: END IF;

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

241: x_return_status => l_return_status);
242:
243: IF nvl(l_return_status, 'X') <> 'S'
244: THEN
245: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJ_TYP_NOT_EXISTS');
246: FND_MSG_PUB.ADD;
247: END IF;
248: END IF;
249: -- If Type Code presents

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

252: THEN
253: l_association_tbl(i).aso_object_type_code := p_x_association_tbl(i).aso_object_type_code;
254: --If both missing
255: ELSE
256: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_TYPE_NULL');
257: FND_MSG_PUB.ADD;
258: END IF;
259: l_association_tbl(i).aso_object_id := p_x_association_tbl(i).aso_object_id;
260: l_association_tbl(i).use_latest_rev_flag := p_x_association_tbl(i).use_latest_rev_flag;

Line 650: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_NO_NULL');

646: THEN
647: IF (p_x_association_tbl(i).document_no IS NULL) OR
648: (p_x_association_tbl(i).document_no = FND_API.G_MISS_CHAR)
649: THEN
650: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_NO_NULL');
651: FND_MSG_PUB.ADD;
652: ELSE
653: -- For document id
654: OPEN get_doc_id_info(p_x_association_tbl(i).document_no);

Line 660: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ID_INVALID');

656: IF get_doc_id_info%FOUND
657: THEN
658: l_association_tbl(i).document_id := l_document_id;
659: ELSE
660: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ID_INVALID');
661: FND_MSG_PUB.ADD;
662: END IF;
663: CLOSE get_doc_id_info;
664:

Line 683: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');

679: IF get_doc_rev_info%FOUND
680: THEN
681: l_association_tbl(i).doc_revision_id := l_doc_revision_id;
682: ELSE
683: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');
684: FND_MSG_PUB.ADD;
685: END IF;
686: CLOSE get_doc_rev_info;
687: -- if more than one rev are present then check if the rev id passes is valid else throw error

Line 698: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');

694: IF get_doc_rev_id_info%FOUND
695: THEN
696: l_association_tbl(i).doc_revision_id := l_doc_revision_id;
697: ELSE
698: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');
699: FND_MSG_PUB.ADD;
700: END IF;
701: CLOSE get_doc_rev_id_info;
702: END IF;

Line 724: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ID_INVALID');

720: IF get_doc_id_info%FOUND
721: THEN
722: l_association_tbl(i).document_id := l_document_id;
723: ELSE
724: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ID_INVALID');
725: FND_MSG_PUB.ADD;
726: END IF;
727: CLOSE get_doc_id_info;
728: --If Document Id is present

Line 754: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');

750: IF get_doc_rev_id_info%FOUND
751: THEN
752: l_association_tbl(i).doc_revision_id := l_doc_revision_id;
753: ELSE
754: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');
755: FND_MSG_PUB.ADD;
756: END IF;
757: CLOSE get_doc_rev_id_info;
758: --If Doc Revision Id is present

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

779: x_return_status => l_return_status);
780:
781: IF nvl(l_return_status, 'X') <> 'S'
782: THEN
783: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJ_TYPE_NOT_EXISTS');
784: FND_MSG_PUB.ADD;
785: END IF;
786: END IF;
787: -- If Type Code presents

Line 1140: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ID_INVALID');

1136: IF get_doc_id_info%FOUND
1137: THEN
1138: l_association_tbl(i).document_id := l_document_id;
1139: ELSE
1140: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ID_INVALID');
1141: FND_MSG_PUB.ADD;
1142: END IF;
1143: CLOSE get_doc_id_info;
1144: --If Document Id is present

Line 1169: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');

1165: IF get_doc_rev_id_info%FOUND
1166: THEN
1167: l_association_tbl(i).doc_revision_id := l_doc_revision_id;
1168: ELSE
1169: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');
1170: FND_MSG_PUB.ADD;
1171: END IF;
1172: CLOSE get_doc_rev_id_info;
1173: --If Doc Revision Id is present

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

1191: x_return_status => l_return_status);
1192:
1193: IF nvl(l_return_status, 'X') <> 'S'
1194: THEN
1195: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJ_TYPE_NOT_EXISTS');
1196: FND_MSG_PUB.ADD;
1197: END IF;
1198: END IF;
1199: -- If Type Code presents

Line 1223: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_REF_NOT_EXISTS');

1219: x_return_status => l_return_status);
1220:
1221: IF nvl(l_return_status, 'X') <> 'S'
1222: THEN
1223: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_REF_NOT_EXISTS');
1224: FND_MSG_PUB.ADD;
1225: END IF;
1226: END IF;
1227:

Line 1336: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ID_INVALID');

1332: IF get_doc_id_info%FOUND
1333: THEN
1334: l_association_tblc(i).document_id := l_document_id;
1335: ELSE
1336: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ID_INVALID');
1337: FND_MSG_PUB.ADD;
1338: END IF;
1339: CLOSE get_doc_id_info;
1340: ELSE

Line 1341: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ID_INVALID');

1337: FND_MSG_PUB.ADD;
1338: END IF;
1339: CLOSE get_doc_id_info;
1340: ELSE
1341: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ID_INVALID');
1342: FND_MSG_PUB.ADD;
1343: END IF;
1344:
1345: --If Document Id is present

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

1348: THEN
1349: l_association_tblc(i).document_id := p_x_association_tblc(i).document_id;
1350: ELSE
1351: --Both Document Id and Name are missing
1352: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ID_NOT_EXISTS');
1353: FND_MSG_PUB.ADD;
1354: END IF;
1355: -- For Document Revision Id
1356: IF (p_x_association_tblc(i).doc_revision_id IS NULL OR

Line 1372: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');

1368: IF get_doc_rev_id_info%FOUND
1369: THEN
1370: l_association_tblc(i).doc_revision_id := l_doc_revision_id;
1371: ELSE
1372: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');
1373: FND_MSG_PUB.ADD;
1374: END IF;
1375: CLOSE get_doc_rev_id_info;
1376: ELSE

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

1399: x_return_status => l_return_status);
1400:
1401: IF nvl(l_return_status, 'X') <> 'S'
1402: THEN
1403: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJ_TYP_NOT_EXISTS');
1404: FND_MSG_PUB.ADD;
1405: END IF;
1406: END IF;
1407: -- If Type Code presents

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

1410: THEN
1411: l_association_tblc(i).aso_object_type_code := p_x_association_tblc(i).aso_object_type_code;
1412: --If both missing
1413: ELSE
1414: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_TYPE_NULL');
1415: FND_MSG_PUB.ADD;
1416: END IF;
1417: -- For Source Ref Code, meaning presents
1418: /* IF p_x_association_tblc(i).source_ref_mean IS NOT NULL AND

Line 1432: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_REF_NOT_EXISTS');

1428: x_return_status => l_return_status);
1429:
1430: IF nvl(l_return_status, 'X') <> 'S'
1431: THEN
1432: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_REF_NOT_EXISTS');
1433: FND_MSG_PUB.ADD;
1434: END IF;
1435: END IF; */
1436: IF G_DEBUG='Y' THEN