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

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

211: (p_doc_revision_id IS NOT NULL
212: AND l_document_id IS NULL))
213:
214: THEN
215: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_ID_NULL');
216: FND_MSG_PUB.ADD;
217: END IF;
218: --This condition checks fro Revision Number, when the action is insert or update
219: IF ((p_doc_revision_id IS NULL AND

Line 226: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REVISION_NO_NULL');

222:
223: (p_doc_revision_id IS NOT NULL
224: AND l_revision_no IS NULL))
225: THEN
226: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REVISION_NO_NULL');
227: FND_MSG_PUB.ADD;
228: END IF;
229: --This condition checks for Revision Type Code
230: IF ((p_doc_revision_id IS NULL AND

Line 237: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_TYPE_CODE_NULL');

233:
234: (p_doc_revision_id IS NOT NULL
235: AND l_revision_type_code IS NULL))
236: THEN
237: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_TYPE_CODE_NULL');
238: FND_MSG_PUB.ADD;
239: END IF;
240: --This condition checks for Revision Status Code
241: IF ((p_doc_revision_id IS NULL AND

Line 249: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_STATUS_CODE_NULL');

245: (p_doc_revision_id IS NOT NULL
246: AND l_revision_status_code IS NULL))
247:
248: THEN
249: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_STATUS_CODE_NULL');
250: FND_MSG_PUB.ADD;
251: END IF;
252: -- Checks for existence of Revision type code in fnd lookups
253: IF p_revision_type_code IS NOT NULL

Line 259: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_TYPE_CODE_NOT_EXIST');

255: OPEN get_revision_type_code(p_revision_type_code);
256: FETCH get_revision_type_code INTO l_dummy;
257: IF get_revision_type_code%NOTFOUND
258: THEN
259: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_TYPE_CODE_NOT_EXIST');
260: FND_MSG_PUB.ADD;
261: END IF;
262: CLOSE get_revision_type_code;
263: END IF;

Line 271: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_STAT_CODE_NOT_EXIST');

267: OPEN get_revision_status_code(p_revision_status_code);
268: FETCH get_revision_status_code INTO l_dummy;
269: IF get_revision_status_code%NOTFOUND
270: THEN
271: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_STAT_CODE_NOT_EXIST');
272: FND_MSG_PUB.ADD;
273: END IF;
274: CLOSE get_revision_status_code;
275: END IF;

Line 283: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_CODE_NOT_EXISTS');

279: OPEN get_media_type_code(p_media_type_code);
280: FETCH get_media_type_code INTO l_dummy;
281: IF get_media_type_code%NOTFOUND
282: THEN
283: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_CODE_NOT_EXISTS');
284: FND_MSG_PUB.ADD;
285: END IF;
286: CLOSE get_media_type_code;
287: END IF;

Line 301: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_NOT_EFILE');

297: SELECT MEANING into l_media_type_meaning
298: FROM FND_LOOKUP_VALUES_VL
299: WHERE LOOKUP_TYPE='AHL_MEDIA_TYPE' AND LOOKUP_CODE='E-FILE';
300:
301: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_NOT_EFILE');
302: FND_MESSAGE.SET_TOKEN('EFILE',l_media_type_meaning);
303: FND_MSG_PUB.ADD;
304: END IF;
305: CLOSE get_record_from_AHL;

Line 302: FND_MESSAGE.SET_TOKEN('EFILE',l_media_type_meaning);

298: FROM FND_LOOKUP_VALUES_VL
299: WHERE LOOKUP_TYPE='AHL_MEDIA_TYPE' AND LOOKUP_CODE='E-FILE';
300:
301: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_NOT_EFILE');
302: FND_MESSAGE.SET_TOKEN('EFILE',l_media_type_meaning);
303: FND_MSG_PUB.ADD;
304: END IF;
305: CLOSE get_record_from_AHL;
306: END IF;

Line 317: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_ID_NOT_EXISTS');

313: OPEN Check_doc_info(p_document_id);
314: FETCH Check_doc_info INTO l_dummy;
315: IF Check_doc_info%NOTFOUND
316: THEN
317: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_ID_NOT_EXISTS');
318: FND_MSG_PUB.ADD;
319: END IF;
320: CLOSE Check_doc_info;
321: END IF;

Line 330: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ISSUE_NUM_INVALID');

326: l_issue_number IS NOT NULL
327: THEN
328: IF(p_issue_number <= 0 or l_issue_number <= 0)
329: THEN
330: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ISSUE_NUM_INVALID');
331: FND_MSG_PUB.ADD;
332: END IF;
333: END IF;
334: --Validations for Duplicate Record

Line 340: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REVISION_DUP_RECORD');

336: THEN
337: OPEN dup_rec(l_document_id, l_revision_no);
338: FETCH dup_rec INTO l_dummy;
339: IF dup_rec%FOUND THEN
340: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REVISION_DUP_RECORD');
341: FND_MSG_PUB.ADD;
342: END IF;
343: CLOSE dup_rec;
344: END IF;

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

758: -- This bug fix when concurrent users update
759: -- updating same record...02/05/02
760: if (l_revision_info.object_version_number <>p_x_revision_tbl(i).object_version_number)
761: then
762: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
763: FND_MSG_PUB.ADD;
764: RAISE FND_API.G_EXC_ERROR;
765: end if;
766: -- The following conditions compare the new record value with old record

Line 996: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REVI_RECORD_INVALID');

992: l_obsolete_date,
993: l_object_version_number;
994: IF (get_revision_rec_b_info%NOTFOUND)
995: THEN
996: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REVI_RECORD_INVALID');
997: FND_MSG_PUB.ADD;
998: END IF;
999: CLOSE get_revision_rec_b_info;
1000: -- Check for version number

Line 1003: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REVI_RECORD_CHANGED');

999: CLOSE get_revision_rec_b_info;
1000: -- Check for version number
1001: IF (l_object_version_number <> p_x_revision_tbl(i).object_version_number)
1002: THEN
1003: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REVI_RECORD_CHANGED');
1004: FND_MSG_PUB.ADD;
1005: END IF;
1006: -- Validate with end date
1007: IF (l_obsolete_date IS NOT NULL AND l_obsolete_date <= SYSDATE)

Line 1009: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REVI_RECORD_CLOSED');

1005: END IF;
1006: -- Validate with end date
1007: IF (l_obsolete_date IS NOT NULL AND l_obsolete_date <= SYSDATE)
1008: THEN
1009: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REVI_RECORD_CLOSED');
1010: FND_MSG_PUB.ADD;
1011: END IF;
1012: IF (TRUNC(NVL(l_obsolete_date, SYSDATE)) >
1013: TRUNC(NVL(p_x_revision_tbl(i).obsolete_date,SYSDATE)))

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

1011: END IF;
1012: IF (TRUNC(NVL(l_obsolete_date, SYSDATE)) >
1013: TRUNC(NVL(p_x_revision_tbl(i).obsolete_date,SYSDATE)))
1014: THEN
1015: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSOLETE_DATE_INVALID');
1016: FND_MSG_PUB.ADD;
1017: END IF;
1018: -- Update the end date in subscriptions table
1019: UPDATE AHL_DOC_REVISIONS_B