DBA Data[Home] [Help]

APPS.AHL_DI_ASSO_DOC_GEN_PVT dependencies on FND_MESSAGE

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

212: close get_mr_type_code ;
213:
214: IF L_TYPE_CODE='PROGRAM'
215: THEN
216: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MR_NOTEDITABLE');
217: FND_MSG_PUB.ADD;
218: END IF;
219:
220: END IF;

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

233: l_aso_object_type_code,
234: l_aso_object_id;
235: IF(get_doc_assos_rec_b_info%NOTFOUND)
236: THEN
237: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TITLE_INVALID');
238: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
239: FND_MSG_PUB.ADD;
240: CLOSE get_doc_assos_rec_b_info;
241: RETURN;

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

234: l_aso_object_id;
235: IF(get_doc_assos_rec_b_info%NOTFOUND)
236: THEN
237: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TITLE_INVALID');
238: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
239: FND_MSG_PUB.ADD;
240: CLOSE get_doc_assos_rec_b_info;
241: RETURN;
242: END IF;

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

254: OPEN get_doc_assos_ovn(p_doc_title_asso_id);
255: FETCH get_doc_assos_ovn INTO l_object_version_number;
256: IF (get_doc_assos_ovn%NOTFOUND)
257: THEN
258: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_INVALID');
259: FND_MSG_PUB.ADD;
260: END IF;
261: CLOSE get_doc_assos_ovn;
262: -- Check for version number

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

261: CLOSE get_doc_assos_ovn;
262: -- Check for version number
263: IF (l_object_version_number <> p_object_version_num)
264: THEN
265: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_CHANGED');
266: FND_MSG_PUB.ADD;
267: END IF;
268: END IF;
269:

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

275: FETCH get_operation_status INTO l_status;
276: CLOSE get_operation_status;
277: IF l_status <> 'DRAFT' AND l_status <> 'APPROVAL_REJECTED'
278: THEN
279: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_STAT_DRFT_ASO');
280: FND_MSG_PUB.ADD;
281: RETURN;
282: END IF;
283: END IF;

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

288: CLOSE get_route_status;
289:
290: IF l_status <> 'DRAFT' AND l_status <> 'APPROVAL_REJECTED'
291: THEN
292: FND_MESSAGE.SET_NAME('AHL','AHL_RM_ROU_STAT_DRFT_ASO');
293: FND_MSG_PUB.ADD;
294: RETURN;
295: END IF;
296: END IF;

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

300: OPEN get_rev_dat(p_doc_revision_id);
301: FETCH get_rev_dat INTO l_rev_rec1;
302: IF get_rev_dat%notfound
303: then
304: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_INVALID');
305: FND_MESSAGE.SET_TOKEN('field',l_record);
306: FND_MSG_PUB.ADD;
307: CLOSE get_rev_dat;
308: RETURN;

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

301: FETCH get_rev_dat INTO l_rev_rec1;
302: IF get_rev_dat%notfound
303: then
304: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_INVALID');
305: FND_MESSAGE.SET_TOKEN('field',l_record);
306: FND_MSG_PUB.ADD;
307: CLOSE get_rev_dat;
308: RETURN;
309: else

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

308: RETURN;
309: else
310: IF TRUNC(NVL(l_rev_rec1.obsolete_date,SYSDATE+1)) <= TRUNC(sysdate)
311: THEN
312: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');
313: FND_MESSAGE.SET_TOKEN('FIELD1',l_record);
314: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);
315: --FND_MESSAGE.SET_TOKEN('RECORD',l_record);
316: FND_MSG_PUB.ADD;

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

309: else
310: IF TRUNC(NVL(l_rev_rec1.obsolete_date,SYSDATE+1)) <= TRUNC(sysdate)
311: THEN
312: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');
313: FND_MESSAGE.SET_TOKEN('FIELD1',l_record);
314: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);
315: --FND_MESSAGE.SET_TOKEN('RECORD',l_record);
316: FND_MSG_PUB.ADD;
317: CLOSE get_rev_dat;

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

310: IF TRUNC(NVL(l_rev_rec1.obsolete_date,SYSDATE+1)) <= TRUNC(sysdate)
311: THEN
312: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');
313: FND_MESSAGE.SET_TOKEN('FIELD1',l_record);
314: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);
315: --FND_MESSAGE.SET_TOKEN('RECORD',l_record);
316: FND_MSG_PUB.ADD;
317: CLOSE get_rev_dat;
318: RETURN;

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

311: THEN
312: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_OBSOLETE');
313: FND_MESSAGE.SET_TOKEN('FIELD1',l_record);
314: FND_MESSAGE.SET_TOKEN('FIELD2',l_rev_Rec1.REVISION_NO);
315: --FND_MESSAGE.SET_TOKEN('RECORD',l_record);
316: FND_MSG_PUB.ADD;
317: CLOSE get_rev_dat;
318: RETURN;
319: END IF;

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

326: OR
327: ((p_doc_title_asso_id IS NOT NULL AND
328: p_doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_document_id IS NULL)
329: THEN
330: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_ID_NULL');
331: FND_MSG_PUB.ADD;
332: RETURN;
333: END IF;
334:

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

342: ((p_doc_title_asso_id IS NOT NULL AND
343: p_doc_title_asso_id <> FND_API.G_MISS_NUM)
344: AND l_aso_object_type_code IS NULL)
345: THEN
346: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_TYPE_NULL');
347: FND_MSG_PUB.ADD;
348: RETURN;
349: END IF;
350:

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

356: OR
357: ((p_doc_title_asso_id IS NOT NULL AND
358: p_doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_aso_object_id IS NULL)
359: THEN
360: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_ID_NULL');
361: FND_MSG_PUB.ADD;
362: RETURN;
363: END IF;
364:

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

370: OPEN get_aso_obj_type_code(p_aso_object_type_code);
371: FETCH get_aso_obj_type_code INTO l_dummy;
372: IF get_aso_obj_type_code%NOTFOUND
373: THEN
374: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJ_TYPE_NOT_EXISTS');
375: FND_MSG_PUB.ADD;
376: CLOSE get_aso_obj_type_code;
377: RETURN;
378: END IF;

Line 404: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_DUP_YES');

400: AND use_latest_rev_flag<>NVL(p_use_latest_rev_flag,'N');
401:
402: if l_counter1>0
403: then
404: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_DUP_YES');
405: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
406: FND_MSG_PUB.ADD;
407:
408: elsif (l_counter>0 and p_DML_OPERATION='C') OR (l_counter>1 and p_DML_OPERATION='U')

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

401:
402: if l_counter1>0
403: then
404: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_DUP_YES');
405: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
406: FND_MSG_PUB.ADD;
407:
408: elsif (l_counter>0 and p_DML_OPERATION='C') OR (l_counter>1 and p_DML_OPERATION='U')
409: then

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

410: 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'));
411: fetch CheckLatestRevFlag into l_dummy_char;
412: IF CheckLatestRevFlag%FOUND
413: THEN
414: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_FLAG');
415: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
416: FND_MSG_PUB.ADD;
417: RETURN;
418: END IF;

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

411: fetch CheckLatestRevFlag into l_dummy_char;
412: IF CheckLatestRevFlag%FOUND
413: THEN
414: FND_MESSAGE.SET_NAME('AHL','AHL_DI_USE_LATEST_FLAG');
415: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
416: FND_MSG_PUB.ADD;
417: RETURN;
418: END IF;
419: close CheckLatestRevFlag;

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

515: FETCH get_doc_assos_rec_b_info INTO l_rowid,
516: l_object_version_number;
517: IF (get_doc_assos_rec_b_info%NOTFOUND)
518: THEN
519: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_INVALID');
520: FND_MSG_PUB.ADD;
521: END IF;
522: CLOSE get_doc_assos_rec_b_info;
523:

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

523:
524: -- Check for version number
525: IF (l_object_version_number <> p_association_rec.object_version_number)
526: THEN
527: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_CHANGED');
528: FND_MSG_PUB.ADD;
529: END IF;
530: /*-------------------------------------------------------- */
531: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.DELETE_ROW */

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

911: p_x_association_tbl(j).figure = p_x_association_tbl(i).figure
912: )
913: THEN
914:
915: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
916: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
917: FND_MSG_PUB.ADD;
918: RAISE FND_API.G_EXC_ERROR;
919:

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

912: )
913: THEN
914:
915: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
916: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
917: FND_MSG_PUB.ADD;
918: RAISE FND_API.G_EXC_ERROR;
919:
920: END IF;

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

922:
923: END LOOP;
924: IF l_found_flag = 'N'
925: THEN
926: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
927: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
928: FND_MSG_PUB.ADD;
929: RAISE FND_API.G_EXC_ERROR;
930: END IF;

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

923: END LOOP;
924: IF l_found_flag = 'N'
925: THEN
926: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
927: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
928: FND_MSG_PUB.ADD;
929: RAISE FND_API.G_EXC_ERROR;
930: END IF;
931:

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

971: p_x_association_tbl(j).figure = p_x_association_tbl(i).figure
972: )
973: THEN
974:
975: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
976: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
977: FND_MSG_PUB.ADD;
978: RAISE FND_API.G_EXC_ERROR;
979:

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

972: )
973: THEN
974:
975: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
976: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
977: FND_MSG_PUB.ADD;
978: RAISE FND_API.G_EXC_ERROR;
979:
980: END IF;

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

982:
983: END LOOP;
984: IF l_found_flag = 'N'
985: THEN
986: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
987: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
988: FND_MSG_PUB.ADD;
989: RAISE FND_API.G_EXC_ERROR;
990: END IF;

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

983: END LOOP;
984: IF l_found_flag = 'N'
985: THEN
986: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
987: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
988: FND_MSG_PUB.ADD;
989: RAISE FND_API.G_EXC_ERROR;
990: END IF;
991:

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

1013: p_x_association_tbl(j).doc_revision_id = p_x_association_tbl(i).doc_revision_id
1014: )
1015: THEN
1016:
1017: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1018: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1019: FND_MSG_PUB.ADD;
1020: RAISE FND_API.G_EXC_ERROR;
1021:

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

1014: )
1015: THEN
1016:
1017: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1018: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1019: FND_MSG_PUB.ADD;
1020: RAISE FND_API.G_EXC_ERROR;
1021:
1022: END IF;

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

1024:
1025: END LOOP;
1026: IF l_found_flag = 'N'
1027: THEN
1028: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1029: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1030: FND_MSG_PUB.ADD;
1031: RAISE FND_API.G_EXC_ERROR;
1032: END IF;

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

1025: END LOOP;
1026: IF l_found_flag = 'N'
1027: THEN
1028: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1029: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1030: FND_MSG_PUB.ADD;
1031: RAISE FND_API.G_EXC_ERROR;
1032: END IF;
1033: END IF;

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

1088: CLOSE get_doc_assos_rec_tl_info;
1089:
1090: IF (l_association_upd_info.object_version_number <>p_x_association_tbl(i).object_version_number)
1091: THEN
1092: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1093: FND_MSG_PUB.ADD;
1094: ELSE
1095: IF G_DEBUG='Y' THEN
1096: AHL_DEBUG_PUB.debug( 'bafore 3 update Association','+DOBJASS+');

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

1628: c_page => p_association_rec.page,
1629: c_figure => p_association_rec.figure);
1630: FETCH dup_rec_check INTO l_dummy;
1631: IF dup_rec_check%FOUND THEN
1632: Fnd_Message.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1633: Fnd_Message.SET_TOKEN('DUPRECORD',l_document_no);
1634: Fnd_Msg_Pub.ADD;
1635: RAISE Fnd_Api.G_EXC_ERROR;
1636: END IF;

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

1629: c_figure => p_association_rec.figure);
1630: FETCH dup_rec_check INTO l_dummy;
1631: IF dup_rec_check%FOUND THEN
1632: Fnd_Message.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1633: Fnd_Message.SET_TOKEN('DUPRECORD',l_document_no);
1634: Fnd_Msg_Pub.ADD;
1635: RAISE Fnd_Api.G_EXC_ERROR;
1636: END IF;
1637: CLOSE dup_rec_check;

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

1641: p_association_rec.document_id,
1642: p_association_rec.doc_revision_id);
1643: FETCH dup_rec INTO l_dummy;
1644: IF dup_rec%FOUND THEN
1645: Fnd_Message.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1646: Fnd_Message.SET_TOKEN('DUPRECORD',l_document_no);
1647: Fnd_Msg_Pub.ADD;
1648: RAISE Fnd_Api.G_EXC_ERROR;
1649: END IF;

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

1642: p_association_rec.doc_revision_id);
1643: FETCH dup_rec INTO l_dummy;
1644: IF dup_rec%FOUND THEN
1645: Fnd_Message.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1646: Fnd_Message.SET_TOKEN('DUPRECORD',l_document_no);
1647: Fnd_Msg_Pub.ADD;
1648: RAISE Fnd_Api.G_EXC_ERROR;
1649: END IF;
1650: CLOSE dup_rec;

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

1870: AND object_version_number
1871: = l_association_rec.object_version_number
1872: FOR UPDATE OF aso_object_id NOWAIT;
1873: EXCEPTION WHEN TIMEOUT_ON_RESOURCE THEN
1874: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1875: Fnd_Msg_Pub.ADD;
1876: x_msg_data := 'AHL_COM_RECORD_CHANGED';
1877: x_return_status := 'E' ;
1878: WHEN NO_DATA_FOUND THEN

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

1875: Fnd_Msg_Pub.ADD;
1876: x_msg_data := 'AHL_COM_RECORD_CHANGED';
1877: x_return_status := 'E' ;
1878: WHEN NO_DATA_FOUND THEN
1879: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1880: Fnd_Msg_Pub.ADD;
1881: x_msg_data := 'AHL_COM_RECORD_CHANGED';
1882: x_return_status := 'E' ;
1883: WHEN OTHERS THEN

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

1881: x_msg_data := 'AHL_COM_RECORD_CHANGED';
1882: x_return_status := 'E' ;
1883: WHEN OTHERS THEN
1884: IF SQLCODE = -54 THEN
1885: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1886: Fnd_Msg_Pub.ADD;
1887: x_msg_data := 'AHL_COM_RECORD_CHANGED';
1888: x_return_status := 'E' ;
1889: ELSE

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

2080: IF get_all_doc_assos%FOUND
2081: THEN
2082:
2083: l_count_assoc := l_count_assoc + 1;
2084: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_NOT_FOUND');
2085: FND_MSG_PUB.ADD;
2086: 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);
2087: END IF;
2088:

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

2091: CLOSE get_all_doc_assos;
2092:
2093: IF l_count_assoc = 0
2094: THEN
2095: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_NOT_FOUND');
2096: FND_MSG_PUB.ADD;
2097: AHL_DEBUG_PUB.debug( 'no revisions found that are attached to the object id'|| p_aso_object_id );
2098: ELSE
2099:

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

2096: FND_MSG_PUB.ADD;
2097: AHL_DEBUG_PUB.debug( 'no revisions found that are attached to the object id'|| p_aso_object_id );
2098: ELSE
2099:
2100: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DELETED');
2101: FND_MSG_PUB.ADD;
2102: AHL_DEBUG_PUB.debug( 'number of revisions found that are attached to the object id'|| p_aso_object_id ||' are '|| l_count_assoc);
2103:
2104: END IF;