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

Line 201: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APP_BY_PTY_ID_NOT_EXIST');

197: THEN
198:
199: p_x_revision_tbl(i).approved_by_party_id := l_approved_by_party_id;
200: ELSE
201: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APP_BY_PTY_ID_NOT_EXIST');
202: FND_MSG_PUB.ADD;
203: END IF;
204: CLOSE approved_by_party_desc;
205: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('I','S')

Line 231: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APP_BY_PTY_ID_NOT_EXIST');

227: EXIT WHEN get_party_name%NOTFOUND;
228: END LOOP;
229:
230: IF get_party_name%ROWCOUNT = 0 THEN
231: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APP_BY_PTY_ID_NOT_EXIST');
232: FND_MSG_PUB.ADD;
233: ELSIF get_party_name%ROWCOUNT = 1 THEN
234: p_x_revision_tbl(i).approved_by_party_id := l_approved_by_party_id;
235: ELSE

Line 239: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APPROVED_BY_USE_LOV');

235: ELSE
236: -- It will show the message to use LOV , so it would take care
237: -- for duplicate records as well
238:
239: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APPROVED_BY_USE_LOV');
240: FND_MSG_PUB.ADD;
241:
242: END IF;
243: CLOSE get_party_name;

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

271: x_return_status => l_return_status);
272:
273: IF nvl(l_return_status, 'X') <> 'S'
274: THEN
275: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_TYPE_CODE_NOT_EXIST');
276: FND_MSG_PUB.ADD;
277: END IF;
278: END IF;
279: -- If Code is present

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

297: x_return_status => l_return_status);
298:
299: IF nvl(l_return_status, 'X') <> 'S'
300: THEN
301: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_CODE_NOT_EXISTS');
302: FND_MSG_PUB.ADD;
303: END IF;
304: END IF;
305: -- If ID presnt

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

323: x_return_status => l_return_status);
324:
325: IF nvl(l_return_status, 'X') <> 'S'
326: THEN
327: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_STAT_CODE_NOT_EXIST');
328: FND_MSG_PUB.ADD;
329: END IF;
330: END IF;
331: -- If Revision status code presents

Line 354: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REVDT_LESS_SYSDT');

350: ELSE
351: SELECT SYSDATE into l_sysdate FROM DUAL;
352: IF p_x_revision_tbl(i).revision_date < TRUNC(l_sysdate)
353: THEN
354: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REVDT_LESS_SYSDT');
355: FND_MSG_PUB.ADD;
356: END IF;
357: */
358: END IF;

Line 366: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APVDT_LESS_REVDT');

362: IF p_x_revision_tbl(i).approved_date IS NOT NULL
363: THEN
364: IF p_x_revision_tbl(i).approved_date < p_x_revision_tbl(i).revision_date
365: THEN
366: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APVDT_LESS_REVDT');
367: FND_MSG_PUB.ADD;
368: END IF;
369: END IF;
370:

Line 381: FND_MESSAGE.SET_NAME('AHL', 'AHL_DI_ISSDT_LESS_REVDT');

377: IF p_x_revision_tbl(i).issue_date < nvl(p_x_revision_tbl(i).approved_date, p_x_revision_tbl(i).revision_date)
378: THEN
379: IF p_x_revision_tbl(i).approved_date IS NULL
380: THEN
381: FND_MESSAGE.SET_NAME('AHL', 'AHL_DI_ISSDT_LESS_REVDT');
382: FND_MSG_PUB.ADD;
383: ELSE
384: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ISSDT_LESS_APVDT');
385: FND_MSG_PUB.ADD;

Line 384: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ISSDT_LESS_APVDT');

380: THEN
381: FND_MESSAGE.SET_NAME('AHL', 'AHL_DI_ISSDT_LESS_REVDT');
382: FND_MSG_PUB.ADD;
383: ELSE
384: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ISSDT_LESS_APVDT');
385: FND_MSG_PUB.ADD;
386: END IF;
387: END IF;
388: END IF;

Line 399: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_REVDT');

395: IF p_x_revision_tbl(i).effective_date < nvl(p_x_revision_tbl(i).approved_date, p_x_revision_tbl(i).revision_date)
396: THEN
397: IF p_x_revision_tbl(i).approved_date IS NULL
398: THEN
399: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_REVDT');
400: FND_MSG_PUB.ADD;
401: ELSE
402: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_APVDT');
403: FND_MSG_PUB.ADD;

Line 402: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_APVDT');

398: THEN
399: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_REVDT');
400: FND_MSG_PUB.ADD;
401: ELSE
402: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_APVDT');
403: FND_MSG_PUB.ADD;
404: END IF;
405: END IF;
406: END IF;

Line 414: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECDT_GT_REVDT');

410: IF p_x_revision_tbl(i).received_date IS NOT NULL
411: THEN
412: IF p_x_revision_tbl(i).received_date > p_x_revision_tbl(i).revision_date
413: THEN
414: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECDT_GT_REVDT');
415: FND_MSG_PUB.ADD;
416: END IF;
417: END IF;
418: */

Line 424: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_REVDT');

420: IF p_x_revision_tbl(i).obsolete_date IS NOT NULL
421: THEN
422: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).revision_date
423: THEN
424: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_REVDT');
425: FND_MSG_PUB.ADD;
426: END IF;
427:
428: /* Removing following validations too for FP for bug 5930628

Line 431: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_APVDT');

427:
428: /* Removing following validations too for FP for bug 5930628
429: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).approved_date
430: THEN
431: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_APVDT');
432: FND_MSG_PUB.ADD;
433: END IF;
434:
435: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).effective_date

Line 437: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_EFFDT');

433: END IF;
434:
435: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).effective_date
436: THEN
437: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_EFFDT');
438: FND_MSG_PUB.ADD;
439: END IF;
440:
441: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).issue_date

Line 443: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_ISSDT');

439: END IF;
440:
441: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).issue_date
442: THEN
443: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_ISSDT');
444: FND_MSG_PUB.ADD;
445: END IF;
446:
447: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).received_date

Line 449: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_RECDT');

445: END IF;
446:
447: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).received_date
448: THEN
449: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_RECDT');
450: FND_MSG_PUB.ADD;
451: END IF;
452: */
453: END IF;

Line 936: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APP_BY_PTY_ID_NOT_EXIST');

932: IF approved_by_party_desc%FOUND
933: THEN
934: p_x_revision_tbl(i).approved_by_party_id := l_approved_by_party_id;
935: ELSE
936: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APP_BY_PTY_ID_NOT_EXIST');
937: FND_MSG_PUB.ADD;
938: END IF;
939: CLOSE approved_by_party_desc;
940:

Line 970: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APP_BY_PTY_ID_NOT_EXIST');

966: EXIT WHEN get_party_name%NOTFOUND;
967: END LOOP;
968:
969: IF get_party_name%ROWCOUNT = 0 THEN
970: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APP_BY_PTY_ID_NOT_EXIST');
971: FND_MSG_PUB.ADD;
972: ELSIF get_party_name%ROWCOUNT = 1 THEN
973: p_x_revision_tbl(i).approved_by_party_id := l_approved_by_party_id;
974: ELSE

Line 979: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APPROVED_BY_USE_LOV');

975: -- It will show the message to use LOV , so it would take care
976: -- for duplicate records as well
977:
978:
979: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APPROVED_BY_USE_LOV');
980: FND_MSG_PUB.ADD;
981:
982: END IF;
983: CLOSE get_party_name;

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

1009: x_return_status => l_return_status);
1010:
1011: IF nvl(l_return_status, 'X') <> 'S'
1012: THEN
1013: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_TYPE_CODE_NOT_EXIST');
1014: FND_MSG_PUB.ADD;
1015: END IF;
1016: END IF;
1017: -- If Code is present

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

1035: x_return_status => l_return_status);
1036:
1037: IF nvl(l_return_status, 'X') <> 'S'
1038: THEN
1039: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_CODE_NOT_EXISTS');
1040: FND_MSG_PUB.ADD;
1041: END IF;
1042: END IF;
1043: -- If ID presnt

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

1062: x_return_status => l_return_status);
1063:
1064: IF nvl(l_return_status, 'X') <> 'S'
1065: THEN
1066: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_STAT_CODE_NOT_EXIST');
1067: FND_MSG_PUB.ADD;
1068: END IF;
1069: END IF;
1070: -- If Revision status code presents

Line 1086: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REVDT_NULL');

1082: --if rev date is null then rev date = sysdate.
1083:
1084: IF p_x_revision_tbl(i).revision_date IS NULL OR p_x_revision_tbl(i).revision_date = FND_API.G_MISS_DATE
1085: THEN
1086: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REVDT_NULL');
1087: FND_MSG_PUB.ADD;
1088: ELSE
1089: -- select the current revision date. the edited date cannot be less than that.
1090: SELECT REVISION_DATE INTO l_current_revision_date from

Line 1099: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REVDT_LESS_PREVDATE');

1095: ahl_doc_revisions_b.document_id = p_x_revision_tbl(i).document_id;
1096:
1097: IF p_x_revision_tbl(i).revision_date < l_current_revision_date
1098: THEN
1099: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REVDT_LESS_PREVDATE');
1100: FND_MSG_PUB.ADD;
1101: END IF;
1102: END IF;
1103: /* Vineet - FP for Bug 5930628 - Removing all date validations as per PM discussion

Line 1110: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APVDT_LESS_REVDT');

1106: IF p_x_revision_tbl(i).approved_date IS NOT NULL
1107: THEN
1108: IF p_x_revision_tbl(i).approved_date < p_x_revision_tbl(i).revision_date
1109: THEN
1110: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APVDT_LESS_REVDT');
1111: FND_MSG_PUB.ADD;
1112: END IF;
1113: END IF;
1114:

Line 1124: FND_MESSAGE.SET_NAME('AHL', 'AHL_DI_ISSDT_LESS_REVDT');

1120: IF p_x_revision_tbl(i).issue_date < nvl(p_x_revision_tbl(i).approved_date, p_x_revision_tbl(i).revision_date)
1121: THEN
1122: IF p_x_revision_tbl(i).approved_date IS NULL
1123: THEN
1124: FND_MESSAGE.SET_NAME('AHL', 'AHL_DI_ISSDT_LESS_REVDT');
1125: FND_MSG_PUB.ADD;
1126: ELSE
1127: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ISSDT_LESS_APVDT');
1128: FND_MSG_PUB.ADD;

Line 1127: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ISSDT_LESS_APVDT');

1123: THEN
1124: FND_MESSAGE.SET_NAME('AHL', 'AHL_DI_ISSDT_LESS_REVDT');
1125: FND_MSG_PUB.ADD;
1126: ELSE
1127: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ISSDT_LESS_APVDT');
1128: FND_MSG_PUB.ADD;
1129: END IF;
1130: END IF;
1131:

Line 1143: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_REVDT');

1139: IF p_x_revision_tbl(i).effective_date < nvl(p_x_revision_tbl(i).approved_date, p_x_revision_tbl(i).revision_date)
1140: THEN
1141: IF p_x_revision_tbl(i).approved_date IS NULL
1142: THEN
1143: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_REVDT');
1144: FND_MSG_PUB.ADD;
1145: ELSE
1146: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_APVDT');
1147: FND_MSG_PUB.ADD;

Line 1146: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_APVDT');

1142: THEN
1143: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_REVDT');
1144: FND_MSG_PUB.ADD;
1145: ELSE
1146: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_APVDT');
1147: FND_MSG_PUB.ADD;
1148: END IF;
1149: END IF;
1150: END IF;

Line 1158: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECDT_GT_REVDT');

1154: IF p_x_revision_tbl(i).received_date IS NOT NULL
1155: THEN
1156: IF p_x_revision_tbl(i).received_date > p_x_revision_tbl(i).revision_date
1157: THEN
1158: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECDT_GT_REVDT');
1159: FND_MSG_PUB.ADD;
1160: END IF;
1161: END IF;
1162: */

Line 1168: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_REVDT');

1164: IF p_x_revision_tbl(i).obsolete_date IS NOT NULL
1165: THEN
1166: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).revision_date
1167: THEN
1168: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_REVDT');
1169: FND_MSG_PUB.ADD;
1170: END IF;
1171:
1172: /* IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).approved_date

Line 1174: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_APVDT');

1170: END IF;
1171:
1172: /* IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).approved_date
1173: THEN
1174: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_APVDT');
1175: FND_MSG_PUB.ADD;
1176: END IF;
1177:
1178: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).effective_date

Line 1180: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_EFFDT');

1176: END IF;
1177:
1178: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).effective_date
1179: THEN
1180: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_EFFDT');
1181: FND_MSG_PUB.ADD;
1182: END IF;
1183:
1184: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).issue_date

Line 1186: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_ISSDT');

1182: END IF;
1183:
1184: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).issue_date
1185: THEN
1186: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_ISSDT');
1187: FND_MSG_PUB.ADD;
1188: END IF;
1189:
1190: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).received_date

Line 1192: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_RECDT');

1188: END IF;
1189:
1190: IF p_x_revision_tbl(i).obsolete_date < p_x_revision_tbl(i).received_date
1191: THEN
1192: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSDT_LT_RECDT');
1193: FND_MSG_PUB.ADD;
1194: END IF;
1195: */
1196: END IF;

Line 1214: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_PREVDATE');

1210: OPEN get_current_effective_date(p_x_revision_tbl(i).doc_revision_id,p_x_revision_tbl(i).document_id);
1211: FETCH get_current_effective_date INTO l_current_effective_date;
1212: CLOSE get_current_effective_date;
1213: IF l_current_effective_date > p_x_revision_tbl(i).effective_date THEN
1214: FND_MESSAGE.SET_NAME('AHL','AHL_DI_EFFDT_LESS_PREVDATE');
1215: FND_MSG_PUB.ADD;
1216: END IF;
1217: -- FP end
1218: