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

Line 251: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MR_NOTEDITABLE');

247: close get_mr_type_code ;
248:
249: IF L_TYPE_CODE='PROGRAM'
250: THEN
251: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MR_NOTEDITABLE');
252: FND_MSG_PUB.ADD;
253: END IF;
254: END IF;
255: END IF;

Line 267: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TITLE_INVALID');

263: l_aso_object_type_code,
264: l_aso_object_id;
265: IF(get_doc_assos_rec_b_info%NOTFOUND)
266: THEN
267: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TITLE_INVALID');
268: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
269: FND_MSG_PUB.ADD;
270: CLOSE get_doc_assos_rec_b_info;
271: RETURN;

Line 268: FND_MESSAGE.SET_TOKEN('RECORD',l_record);

264: l_aso_object_id;
265: IF(get_doc_assos_rec_b_info%NOTFOUND)
266: THEN
267: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TITLE_INVALID');
268: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
269: FND_MSG_PUB.ADD;
270: CLOSE get_doc_assos_rec_b_info;
271: RETURN;
272: END IF;

Line 286: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_INVALID');

282: OPEN get_doc_assos_ovn(p_doc_title_asso_id);
283: FETCH get_doc_assos_ovn INTO l_object_version_number;
284: IF (get_doc_assos_ovn%NOTFOUND)
285: THEN
286: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_INVALID');
287: FND_MSG_PUB.ADD;
288: END IF;
289: CLOSE get_doc_assos_ovn;
290: -- Check for version number

Line 293: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_CHANGED');

289: CLOSE get_doc_assos_ovn;
290: -- Check for version number
291: IF (l_object_version_number <> p_object_version_num)
292: THEN
293: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_CHANGED');
294: FND_MSG_PUB.ADD;
295: END IF;
296: END IF;
297: /**/

Line 306: --FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_STAT_DRFT_ASO');

302: CLOSE get_operation_status;
303: --FP #8410484
304: --IF l_status <> 'DRAFT' AND l_status <> 'APPROVAL_REJECTED'
305: --THEN
306: --FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_STAT_DRFT_ASO');
307: --FND_MSG_PUB.ADD;
308: --RETURN;
309: --END IF;
310: -- End of FP #8410484

Line 320: --FND_MESSAGE.SET_NAME('AHL','AHL_RM_ROU_STAT_DRFT_ASO');

316: CLOSE get_route_status;
317: --FP #8410484
318: --IF l_status <> 'DRAFT' AND l_status <> 'APPROVAL_REJECTED'
319: --THEN
320: --FND_MESSAGE.SET_NAME('AHL','AHL_RM_ROU_STAT_DRFT_ASO');
321: --FND_MSG_PUB.ADD;
322: --RETURN;
323: --END IF;
324: -- End of FP #8410484

Line 358: FND_MESSAGE.SET_NAME('AHL','AHL_DI_INVALID_ASSOC_STATUS');

354: -- If object status is complete then only updation is allowed.This means there should be one
355: -- present in the table which have this association
356: IF (p_document_id <> l_document_id OR p_doc_revision_id <> l_doc_revision_id OR
357: l_aso_object_type_code <> p_aso_object_type_code OR l_aso_object_id <> p_aso_object_id) THEN
358: FND_MESSAGE.SET_NAME('AHL','AHL_DI_INVALID_ASSOC_STATUS');
359: FND_MSG_PUB.ADD;
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362: END IF;

Line 369: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBJ_STAT_INVALID');

365: END IF;
366: -- Document Association/Updation is only allowed in DRAFT,APPROVAL_REJECTED and COMPLETE status.
367: IF l_status <> 'DRAFT' AND l_status <> 'APPROVAL_REJECTED' AND l_status<>'COMPLETE'
368: THEN
369: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBJ_STAT_INVALID');
370: FND_MSG_PUB.ADD;
371: RETURN;
372: END IF;
373: -- End of FP #8410484

Line 380: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_INVALID');

376: OPEN get_rev_dat(p_doc_revision_id);
377: FETCH get_rev_dat INTO l_rev_rec1;
378: IF get_rev_dat%notfound
379: THEN
380: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_INVALID');
381: FND_MESSAGE.SET_TOKEN('field',l_record);
382: FND_MSG_PUB.ADD;
383: CLOSE get_rev_dat;
384: RETURN;

Line 381: FND_MESSAGE.SET_TOKEN('field',l_record);

377: FETCH get_rev_dat INTO l_rev_rec1;
378: IF get_rev_dat%notfound
379: THEN
380: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_INVALID');
381: FND_MESSAGE.SET_TOKEN('field',l_record);
382: FND_MSG_PUB.ADD;
383: CLOSE get_rev_dat;
384: RETURN;
385: ELSE

Line 388: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');

384: RETURN;
385: ELSE
386: IF TRUNC(NVL(l_rev_rec1.obsolete_date,SYSDATE+1)) <= TRUNC(sysdate)
387: THEN
388: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');
389: FND_MESSAGE.SET_TOKEN('FIELD1',l_record);
390: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);
391: --FND_MESSAGE.SET_TOKEN('RECORD',l_record);
392: FND_MSG_PUB.ADD;

Line 389: FND_MESSAGE.SET_TOKEN('FIELD1',l_record);

385: ELSE
386: IF TRUNC(NVL(l_rev_rec1.obsolete_date,SYSDATE+1)) <= TRUNC(sysdate)
387: THEN
388: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');
389: FND_MESSAGE.SET_TOKEN('FIELD1',l_record);
390: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);
391: --FND_MESSAGE.SET_TOKEN('RECORD',l_record);
392: FND_MSG_PUB.ADD;
393: CLOSE get_rev_dat;

Line 390: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);

386: IF TRUNC(NVL(l_rev_rec1.obsolete_date,SYSDATE+1)) <= TRUNC(sysdate)
387: THEN
388: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');
389: FND_MESSAGE.SET_TOKEN('FIELD1',l_record);
390: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);
391: --FND_MESSAGE.SET_TOKEN('RECORD',l_record);
392: FND_MSG_PUB.ADD;
393: CLOSE get_rev_dat;
394: RETURN;

Line 391: --FND_MESSAGE.SET_TOKEN('RECORD',l_record);

387: THEN
388: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');
389: FND_MESSAGE.SET_TOKEN('FIELD1',l_record);
390: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);
391: --FND_MESSAGE.SET_TOKEN('RECORD',l_record);
392: FND_MSG_PUB.ADD;
393: CLOSE get_rev_dat;
394: RETURN;
395: END IF;

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

401: OR
402: ((p_doc_title_asso_id IS NOT NULL AND
403: p_doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_document_id IS NULL)
404: THEN
405: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_ID_NULL');
406: FND_MSG_PUB.ADD;
407: RETURN;
408: END IF;
409:

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

417: ((p_doc_title_asso_id IS NOT NULL AND
418: p_doc_title_asso_id <> FND_API.G_MISS_NUM)
419: AND l_aso_object_type_code IS NULL)
420: THEN
421: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_TYPE_NULL');
422: FND_MSG_PUB.ADD;
423: RETURN;
424: END IF;
425:

Line 435: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_ID_NULL');

431: OR
432: ((p_doc_title_asso_id IS NOT NULL AND
433: p_doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_aso_object_id IS NULL)
434: THEN
435: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_ID_NULL');
436: FND_MSG_PUB.ADD;
437: RETURN;
438: END IF;
439:

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

444: OPEN get_aso_obj_type_code(p_aso_object_type_code);
445: FETCH get_aso_obj_type_code INTO l_dummy;
446: IF get_aso_obj_type_code%NOTFOUND
447: THEN
448: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJ_TYPE_NOT_EXISTS');
449: FND_MSG_PUB.ADD;
450: CLOSE get_aso_obj_type_code;
451: RETURN;
452: END IF;

Line 476: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_ERROR');

472: AND use_latest_rev_flag<>NVL(p_use_latest_rev_flag,'N');
473:
474: if l_counter1>0
475: then
476: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_ERROR');
477: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);
478: FND_MSG_PUB.ADD;
479: RAISE FND_API.G_EXC_ERROR;
480: elsif (l_counter>0 and p_DML_OPERATION='C') OR (l_counter>1 and p_DML_OPERATION='U')

Line 477: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);

473:
474: if l_counter1>0
475: then
476: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_ERROR');
477: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);
478: FND_MSG_PUB.ADD;
479: RAISE FND_API.G_EXC_ERROR;
480: elsif (l_counter>0 and p_DML_OPERATION='C') OR (l_counter>1 and p_DML_OPERATION='U')
481: then

Line 486: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_ERROR');

482: open CheckLatestRevFlag(NVL(p_DOC_TITLE_ASSO_ID,0),p_aso_object_id,p_aso_object_type_code,p_document_id,NVL(p_use_latest_rev_flag,'X'));
483: fetch CheckLatestRevFlag into l_dummy_char;
484: IF CheckLatestRevFlag%FOUND
485: THEN
486: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_ERROR');
487: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);
488: FND_MSG_PUB.ADD;
489: RAISE FND_API.G_EXC_ERROR;
490: RETURN;

Line 487: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);

483: fetch CheckLatestRevFlag into l_dummy_char;
484: IF CheckLatestRevFlag%FOUND
485: THEN
486: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_ERROR');
487: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);
488: FND_MSG_PUB.ADD;
489: RAISE FND_API.G_EXC_ERROR;
490: RETURN;
491: END IF;

Line 506: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSOLETE_DOC_ATTACH');

502: CLOSE get_revision_status_code;
503: --Obsolete document cannot be attached
504: IF l_revision_status_code = 'OBSOLETE'
505: THEN
506: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSOLETE_DOC_ATTACH');
507: FND_MSG_PUB.ADD;
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510:

Line 537: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_ERROR');

533:
534: -- If the new association is having Use Latest='Y' and some asssociaiton with this document id and object
535: -- is already there in the table OR the table have at least one record with Use Latest ='Y' then error
536: IF(P_USE_LATEST_REV_FLAG = 'Y' and l_counter1 >0) OR (l_counter > 0 ) Then
537: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_ERROR');
538: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);
539: FND_MSG_PUB.ADD;
540: RAISE FND_API.G_EXC_ERROR;
541: END IF;

Line 538: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);

534: -- If the new association is having Use Latest='Y' and some asssociaiton with this document id and object
535: -- is already there in the table OR the table have at least one record with Use Latest ='Y' then error
536: IF(P_USE_LATEST_REV_FLAG = 'Y' and l_counter1 >0) OR (l_counter > 0 ) Then
537: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_ERROR');
538: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);
539: FND_MSG_PUB.ADD;
540: RAISE FND_API.G_EXC_ERROR;
541: END IF;
542:

Line 562: FND_MESSAGE.SET_NAME('AHL','AHL_DI_NOT_LATEST_REVISION');

558: AND document_id = p_document_id
559: AND revision_status_code = 'CURRENT';
560:
561: IF(p_doc_revision_id <> l_latest_doc_revision_id) THEN
562: FND_MESSAGE.SET_NAME('AHL','AHL_DI_NOT_LATEST_REVISION');
563: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);
564: FND_MSG_PUB.ADD;
565: RAISE FND_API.G_EXC_ERROR;
566: END IF;

Line 563: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);

559: AND revision_status_code = 'CURRENT';
560:
561: IF(p_doc_revision_id <> l_latest_doc_revision_id) THEN
562: FND_MESSAGE.SET_NAME('AHL','AHL_DI_NOT_LATEST_REVISION');
563: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);
564: FND_MSG_PUB.ADD;
565: RAISE FND_API.G_EXC_ERROR;
566: END IF;
567: END IF;

Line 667: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_INVALID');

663: FETCH get_doc_assos_rec_b_info INTO l_rowid,
664: l_object_version_number;
665: IF (get_doc_assos_rec_b_info%NOTFOUND)
666: THEN
667: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_INVALID');
668: FND_MSG_PUB.ADD;
669: END IF;
670: CLOSE get_doc_assos_rec_b_info;
671:

Line 675: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_CHANGED');

671:
672: -- Check for version number
673: IF (l_object_version_number <> p_association_rec.object_version_number)
674: THEN
675: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_CHANGED');
676: FND_MSG_PUB.ADD;
677: END IF;
678: /*-------------------------------------------------------- */
679: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.DELETE_ROW */

Line 983: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_ERROR');

979: LOOP
980: IF((i <> j) AND (p_x_association_tbl(i).document_id=p_x_association_tbl(j).document_id) AND
981: (p_x_association_tbl(i).use_latest_rev_flag = 'Y' OR
982: p_x_association_tbl(j).use_latest_rev_flag = 'Y')) THEN
983: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_ERROR');
984: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);
985: FND_MSG_PUB.ADD;
986: RAISE FND_API.G_EXC_ERROR;
987: END IF;

Line 984: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);

980: IF((i <> j) AND (p_x_association_tbl(i).document_id=p_x_association_tbl(j).document_id) AND
981: (p_x_association_tbl(i).use_latest_rev_flag = 'Y' OR
982: p_x_association_tbl(j).use_latest_rev_flag = 'Y')) THEN
983: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_ERROR');
984: FND_MESSAGE.SET_TOKEN('DOC_NO',l_record);
985: FND_MSG_PUB.ADD;
986: RAISE FND_API.G_EXC_ERROR;
987: END IF;
988: END LOOP;

Line 1065: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');

1061: p_x_association_tbl(j).figure = p_x_association_tbl(i).figure
1062: )
1063: THEN
1064:
1065: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1066: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1067: FND_MSG_PUB.ADD;
1068: RAISE FND_API.G_EXC_ERROR;
1069:

Line 1066: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);

1062: )
1063: THEN
1064:
1065: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1066: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1067: FND_MSG_PUB.ADD;
1068: RAISE FND_API.G_EXC_ERROR;
1069:
1070: END IF;

Line 1076: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');

1072:
1073: END LOOP;
1074: IF l_found_flag = 'N'
1075: THEN
1076: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1077: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1078: FND_MSG_PUB.ADD;
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;

Line 1077: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);

1073: END LOOP;
1074: IF l_found_flag = 'N'
1075: THEN
1076: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1077: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1078: FND_MSG_PUB.ADD;
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081:

Line 1125: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');

1121: p_x_association_tbl(j).figure = p_x_association_tbl(i).figure
1122: )
1123: THEN
1124:
1125: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1126: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1127: FND_MSG_PUB.ADD;
1128: RAISE FND_API.G_EXC_ERROR;
1129:

Line 1126: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);

1122: )
1123: THEN
1124:
1125: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1126: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1127: FND_MSG_PUB.ADD;
1128: RAISE FND_API.G_EXC_ERROR;
1129:
1130: END IF;

Line 1136: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');

1132:
1133: END LOOP;
1134: IF l_found_flag = 'N'
1135: THEN
1136: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1137: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1138: FND_MSG_PUB.ADD;
1139: RAISE FND_API.G_EXC_ERROR;
1140: END IF;

Line 1137: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);

1133: END LOOP;
1134: IF l_found_flag = 'N'
1135: THEN
1136: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1137: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1138: FND_MSG_PUB.ADD;
1139: RAISE FND_API.G_EXC_ERROR;
1140: END IF;
1141:

Line 1167: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');

1163: p_x_association_tbl(j).doc_revision_id = p_x_association_tbl(i).doc_revision_id
1164: )
1165: THEN
1166:
1167: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1168: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1169: FND_MSG_PUB.ADD;
1170: RAISE FND_API.G_EXC_ERROR;
1171:

Line 1168: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);

1164: )
1165: THEN
1166:
1167: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1168: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1169: FND_MSG_PUB.ADD;
1170: RAISE FND_API.G_EXC_ERROR;
1171:
1172: END IF;

Line 1178: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');

1174:
1175: END LOOP;
1176: IF l_found_flag = 'N'
1177: THEN
1178: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1179: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1180: FND_MSG_PUB.ADD;
1181: RAISE FND_API.G_EXC_ERROR;
1182: END IF;

Line 1179: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);

1175: END LOOP;
1176: IF l_found_flag = 'N'
1177: THEN
1178: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1179: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1180: FND_MSG_PUB.ADD;
1181: RAISE FND_API.G_EXC_ERROR;
1182: END IF;
1183: END IF;

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

1238: CLOSE get_doc_assos_rec_tl_info;
1239:
1240: IF (l_association_upd_info.object_version_number <>p_x_association_tbl(i).object_version_number)
1241: THEN
1242: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1243: FND_MSG_PUB.ADD;
1244: ELSE
1245: IF G_DEBUG='Y' THEN
1246: AHL_DEBUG_PUB.debug( 'bafore 3 update Association','+DOBJASS+');

Line 1789: Fnd_Message.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');

1785: c_page => p_association_rec.page,
1786: c_figure => p_association_rec.figure);
1787: FETCH dup_rec_check INTO l_dummy;
1788: IF dup_rec_check%FOUND THEN
1789: Fnd_Message.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1790: Fnd_Message.SET_TOKEN('DUPRECORD',l_document_no);
1791: Fnd_Msg_Pub.ADD;
1792: RAISE Fnd_Api.G_EXC_ERROR;
1793: END IF;

Line 1790: Fnd_Message.SET_TOKEN('DUPRECORD',l_document_no);

1786: c_figure => p_association_rec.figure);
1787: FETCH dup_rec_check INTO l_dummy;
1788: IF dup_rec_check%FOUND THEN
1789: Fnd_Message.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1790: Fnd_Message.SET_TOKEN('DUPRECORD',l_document_no);
1791: Fnd_Msg_Pub.ADD;
1792: RAISE Fnd_Api.G_EXC_ERROR;
1793: END IF;
1794: CLOSE dup_rec_check;

Line 1802: Fnd_Message.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');

1798: p_association_rec.document_id,
1799: p_association_rec.doc_revision_id);
1800: FETCH dup_rec INTO l_dummy;
1801: IF dup_rec%FOUND THEN
1802: Fnd_Message.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1803: Fnd_Message.SET_TOKEN('DUPRECORD',l_document_no);
1804: Fnd_Msg_Pub.ADD;
1805: RAISE Fnd_Api.G_EXC_ERROR;
1806: END IF;

Line 1803: Fnd_Message.SET_TOKEN('DUPRECORD',l_document_no);

1799: p_association_rec.doc_revision_id);
1800: FETCH dup_rec INTO l_dummy;
1801: IF dup_rec%FOUND THEN
1802: Fnd_Message.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1803: Fnd_Message.SET_TOKEN('DUPRECORD',l_document_no);
1804: Fnd_Msg_Pub.ADD;
1805: RAISE Fnd_Api.G_EXC_ERROR;
1806: END IF;
1807: CLOSE dup_rec;

Line 2031: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

2027: AND object_version_number
2028: = l_association_rec.object_version_number
2029: FOR UPDATE OF aso_object_id NOWAIT;
2030: EXCEPTION WHEN TIMEOUT_ON_RESOURCE THEN
2031: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2032: Fnd_Msg_Pub.ADD;
2033: x_msg_data := 'AHL_COM_RECORD_CHANGED';
2034: x_return_status := 'E' ;
2035: WHEN NO_DATA_FOUND THEN

Line 2036: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

2032: Fnd_Msg_Pub.ADD;
2033: x_msg_data := 'AHL_COM_RECORD_CHANGED';
2034: x_return_status := 'E' ;
2035: WHEN NO_DATA_FOUND THEN
2036: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2037: Fnd_Msg_Pub.ADD;
2038: x_msg_data := 'AHL_COM_RECORD_CHANGED';
2039: x_return_status := 'E' ;
2040: WHEN OTHERS THEN

Line 2042: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

2038: x_msg_data := 'AHL_COM_RECORD_CHANGED';
2039: x_return_status := 'E' ;
2040: WHEN OTHERS THEN
2041: IF SQLCODE = -54 THEN
2042: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2043: Fnd_Msg_Pub.ADD;
2044: x_msg_data := 'AHL_COM_RECORD_CHANGED';
2045: x_return_status := 'E' ;
2046: ELSE

Line 2241: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_NOT_FOUND');

2237: IF get_all_doc_assos%FOUND
2238: THEN
2239:
2240: l_count_assoc := l_count_assoc + 1;
2241: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_NOT_FOUND');
2242: FND_MSG_PUB.ADD;
2243: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association: the revision id of revision deleted is '|| l_doc_asso_rec.doc_revision_id);
2244: END IF;
2245:

Line 2252: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_NOT_FOUND');

2248: CLOSE get_all_doc_assos;
2249:
2250: IF l_count_assoc = 0
2251: THEN
2252: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_NOT_FOUND');
2253: FND_MSG_PUB.ADD;
2254: AHL_DEBUG_PUB.debug( 'no revisions found that are attached to the object id'|| p_aso_object_id );
2255: ELSE
2256:

Line 2257: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DELETED');

2253: FND_MSG_PUB.ADD;
2254: AHL_DEBUG_PUB.debug( 'no revisions found that are attached to the object id'|| p_aso_object_id );
2255: ELSE
2256:
2257: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DELETED');
2258: FND_MSG_PUB.ADD;
2259: AHL_DEBUG_PUB.debug( 'number of revisions found that are attached to the object id'|| p_aso_object_id ||' are '|| l_count_assoc);
2260:
2261: END IF;