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_MSG_PUB

Line 217: FND_MSG_PUB.ADD;

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;
221:

Line 239: FND_MSG_PUB.ADD;

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;
243: CLOSE get_doc_assos_rec_b_info;

Line 259: FND_MSG_PUB.ADD;

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
263: IF (l_object_version_number <> p_object_version_num)

Line 266: FND_MSG_PUB.ADD;

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:
270:

Line 280: FND_MSG_PUB.ADD;

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;
284:

Line 293: FND_MSG_PUB.ADD;

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;
297:

Line 306: FND_MSG_PUB.ADD;

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
310: IF TRUNC(NVL(l_rev_rec1.obsolete_date,SYSDATE+1)) <= TRUNC(sysdate)

Line 316: FND_MSG_PUB.ADD;

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;
320: END IF;

Line 331: FND_MSG_PUB.ADD;

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:
335: -- This condition checks for Aso Object Type Code is Null

Line 347: FND_MSG_PUB.ADD;

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:
351: -- This condiiton checks for Aso Object Id Value Is Null

Line 361: FND_MSG_PUB.ADD;

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:
365: --Check for Aso Object Type Code in fnd lookups

Line 375: FND_MSG_PUB.ADD;

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;
379: CLOSE get_aso_obj_type_code;

Line 406: FND_MSG_PUB.ADD;

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
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'));

Line 416: FND_MSG_PUB.ADD;

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;
420: end if;

Line 428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

424: END IF;
425: EXCEPTION
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
429: p_count => x_msg_count,
430: p_data => x_msg_data);
431: WHEN FND_API.G_EXC_ERROR THEN
432: X_return_status := FND_API.G_RET_STS_ERROR;

Line 433: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

429: p_count => x_msg_count,
430: p_data => x_msg_data);
431: WHEN FND_API.G_EXC_ERROR THEN
432: X_return_status := FND_API.G_RET_STS_ERROR;
433: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
434: p_count => x_msg_count,
435: p_data => X_msg_data);
436: WHEN OTHERS THEN
437: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 438: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

434: p_count => x_msg_count,
435: p_data => X_msg_data);
436: WHEN OTHERS THEN
437: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: fnd_msg_pub.add_exc_msg(p_pkg_name =>g_pkg_name,
441: p_procedure_name =>'VALIDATE_ASSOCIATION',
442: p_error_text =>SUBSTR(SQLERRM,1,240));

Line 440: fnd_msg_pub.add_exc_msg(p_pkg_name =>g_pkg_name,

436: WHEN OTHERS THEN
437: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: fnd_msg_pub.add_exc_msg(p_pkg_name =>g_pkg_name,
441: p_procedure_name =>'VALIDATE_ASSOCIATION',
442: p_error_text =>SUBSTR(SQLERRM,1,240));
443: END IF;
444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

440: fnd_msg_pub.add_exc_msg(p_pkg_name =>g_pkg_name,
441: p_procedure_name =>'VALIDATE_ASSOCIATION',
442: p_error_text =>SUBSTR(SQLERRM,1,240));
443: END IF;
444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
445: p_count => x_msg_count,
446: p_data => X_msg_data);
447: END;
448:

Line 502: FND_MSG_PUB.initialize;

498: END IF;
499: -- Standard call to check for call compatibility.
500: IF FND_API.to_boolean(p_init_msg_list)
501: THEN
502: FND_MSG_PUB.initialize;
503: END IF;
504: -- Initialize API return status to success
505: x_return_status := 'S';
506: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 520: FND_MSG_PUB.ADD;

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:
524: -- Check for version number

Line 528: FND_MSG_PUB.ADD;

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 */
532: /* description : Added by Senthil to call Table Handler */

Line 568: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

564: EXCEPTION
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO delete_association;
567: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count,
570: p_data => x_msg_data);
571: --Debug Info
572: IF G_DEBUG='Y' THEN

Line 586: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

582:
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO delete_association;
585: X_return_status := FND_API.G_RET_STS_ERROR;
586: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
587: p_count => x_msg_count,
588: p_data => X_msg_data);
589: -- Debug info.
590: IF G_DEBUG='Y' THEN

Line 603: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

599:
600: WHEN OTHERS THEN
601: ROLLBACK TO delete_association;
602: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
604: THEN
605: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
606: p_procedure_name => 'DELETE_ASSOCIATION',
607: p_error_text => SUBSTR(SQLERRM,1,240));

Line 605: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',

601: ROLLBACK TO delete_association;
602: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
604: THEN
605: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
606: p_procedure_name => 'DELETE_ASSOCIATION',
607: p_error_text => SUBSTR(SQLERRM,1,240));
608: END IF;
609: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 609: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

605: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
606: p_procedure_name => 'DELETE_ASSOCIATION',
607: p_error_text => SUBSTR(SQLERRM,1,240));
608: END IF;
609: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
610: p_count => x_msg_count,
611: p_data => X_msg_data);
612: -- Debug info.
613: IF G_DEBUG='Y' THEN

Line 800: FND_MSG_PUB.initialize;

796: END IF;
797: -- Standard call to check for call compatibility.
798: IF FND_API.to_boolean(p_init_msg_list)
799: THEN
800: FND_MSG_PUB.initialize;
801: END IF;
802: -- Initialize API return status to success
803: x_return_status := 'S';
804: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 856: l_msg_count := FND_MSG_PUB.count_msg;

852:
853:
854:
855: --Standard call to message count
856: l_msg_count := FND_MSG_PUB.count_msg;
857:
858: IF l_msg_count > 0 THEN
859: X_msg_count := l_msg_count;
860: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 917: FND_MSG_PUB.ADD;

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;
921: END IF;

Line 928: FND_MSG_PUB.ADD;

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:
932: END IF;

Line 977: FND_MSG_PUB.ADD;

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;
981: END IF;

Line 988: FND_MSG_PUB.ADD;

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:
992: END IF;

Line 1019: FND_MSG_PUB.ADD;

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;
1023: END IF;

Line 1030: FND_MSG_PUB.ADD;

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;
1034: CLOSE dup_rec;

Line 1048: l_msg_count := FND_MSG_PUB.count_msg;

1044: AHL_DEBUG_PUB.debug( 'after dup check: '||l_record,'+adharia+');
1045: END IF;
1046:
1047: --Standard call to message count
1048: l_msg_count := FND_MSG_PUB.count_msg;
1049:
1050: IF l_msg_count > 0 THEN
1051: X_msg_count := l_msg_count;
1052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1093: FND_MSG_PUB.ADD;

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+');
1097: END IF;

Line 1207: l_msg_count := FND_MSG_PUB.count_msg;

1203: IF G_DEBUG='Y' THEN
1204: AHL_DEBUG_PUB.debug( 'afte all update Association','+DOBJASS+');
1205: END IF;
1206:
1207: l_msg_count := FND_MSG_PUB.count_msg;
1208:
1209: IF l_msg_count > 0 THEN
1210: X_msg_count := l_msg_count;
1211: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1235: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1231: EXCEPTION
1232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1233: ROLLBACK TO process_association;
1234: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1236: p_count => x_msg_count,
1237: p_data => x_msg_data);
1238:
1239: --Debug Info

Line 1253: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1249:
1250: WHEN FND_API.G_EXC_ERROR THEN
1251: ROLLBACK TO process_association;
1252: X_return_status := FND_API.G_RET_STS_ERROR;
1253: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1254: p_count => x_msg_count,
1255: p_data => X_msg_data);
1256:
1257: -- Debug info.

Line 1271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1267:
1268: WHEN OTHERS THEN
1269: ROLLBACK TO process_association;
1270: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1272: THEN
1273: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1274: p_procedure_name => 'PROCESS_ASSOCIATION',
1275: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1273: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',

1269: ROLLBACK TO process_association;
1270: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1272: THEN
1273: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1274: p_procedure_name => 'PROCESS_ASSOCIATION',
1275: p_error_text => SUBSTR(SQLERRM,1,240));
1276: END IF;
1277: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1277: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1273: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1274: p_procedure_name => 'PROCESS_ASSOCIATION',
1275: p_error_text => SUBSTR(SQLERRM,1,240));
1276: END IF;
1277: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1278: p_count => x_msg_count,
1279: p_data => X_msg_data);
1280: -- Debug info.
1281: IF G_DEBUG='Y' THEN

Line 1383: Fnd_Msg_Pub.initialize;

1379: END IF;
1380: -- Standard call to check for call compatibility.
1381: IF Fnd_Api.to_boolean(p_init_msg_list)
1382: THEN
1383: Fnd_Msg_Pub.initialize;
1384: END IF;
1385: -- Initialize API return status to success
1386: x_return_status := 'S';
1387: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1413: l_msg_count := Fnd_Msg_Pub.count_msg;

1409: P_RECORD => L_RECORD
1410: );
1411:
1412: --Standard call to message count
1413: l_msg_count := Fnd_Msg_Pub.count_msg;
1414:
1415: IF l_msg_count > 0 THEN
1416: X_msg_count := l_msg_count;
1417: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1634: Fnd_Msg_Pub.ADD;

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;
1638: ELSE

Line 1647: Fnd_Msg_Pub.ADD;

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;
1651: END IF;

Line 1703: l_msg_count := Fnd_Msg_Pub.count_msg;

1699: X_LAST_UPDATE_DATE => sysdate,
1700: X_LAST_UPDATED_BY => fnd_global.user_id,
1701: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1702: --Standard check to count messages
1703: l_msg_count := Fnd_Msg_Pub.count_msg;
1704:
1705: IF l_msg_count > 0 THEN
1706: X_msg_count := l_msg_count;
1707: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1730: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1726: EXCEPTION
1727: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1728: ROLLBACK TO insert_assoc_rec;
1729: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1730: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1731: p_count => x_msg_count,
1732: p_data => x_msg_data);
1733:
1734: --Debug Info

Line 1748: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1744:
1745: WHEN Fnd_Api.G_EXC_ERROR THEN
1746: ROLLBACK TO insert_assoc_rec;
1747: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1748: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1749: p_count => x_msg_count,
1750: p_data => X_msg_data);
1751:
1752: -- Debug info.

Line 1766: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

1762:
1763: WHEN OTHERS THEN
1764: ROLLBACK TO insert_assoc_rec;
1765: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1766: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1767: THEN
1768: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1769: p_procedure_name => 'INSERT_ASSOC_REC',
1770: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1768: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',

1764: ROLLBACK TO insert_assoc_rec;
1765: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1766: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1767: THEN
1768: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1769: p_procedure_name => 'INSERT_ASSOC_REC',
1770: p_error_text => SUBSTR(SQLERRM,1,240));
1771: END IF;
1772: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 1772: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1768: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1769: p_procedure_name => 'INSERT_ASSOC_REC',
1770: p_error_text => SUBSTR(SQLERRM,1,240));
1771: END IF;
1772: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1773: p_count => x_msg_count,
1774: p_data => X_msg_data);
1775: -- Debug info.
1776: IF G_DEBUG='Y' THEN

Line 1843: Fnd_Msg_Pub.initialize;

1839: END IF;
1840: -- Standard call to check for call compatibility.
1841: IF Fnd_Api.to_boolean(p_init_msg_list)
1842: THEN
1843: Fnd_Msg_Pub.initialize;
1844: END IF;
1845: -- Initialize API return status to success
1846: x_return_status := 'S';
1847: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1875: Fnd_Msg_Pub.ADD;

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
1879: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

Line 1880: 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
1884: IF SQLCODE = -54 THEN

Line 1886: Fnd_Msg_Pub.ADD;

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
1890: RAISE;

Line 1893: l_msg_count := Fnd_Msg_Pub.count_msg;

1889: ELSE
1890: RAISE;
1891: END IF;
1892: END;
1893: l_msg_count := Fnd_Msg_Pub.count_msg;
1894: IF l_msg_count > 0 THEN
1895: x_msg_count := l_msg_count;
1896: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1897: RAISE Fnd_Api.G_EXC_ERROR;

Line 1919: l_msg_count := Fnd_Msg_Pub.count_msg;

1915:
1916: END LOOP;
1917: CLOSE get_assos_b_cur;
1918: --Standard check to count messages
1919: l_msg_count := Fnd_Msg_Pub.count_msg;
1920:
1921: IF l_msg_count > 0 THEN
1922: X_msg_count := l_msg_count;
1923: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1945: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1941: EXCEPTION
1942: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1943: ROLLBACK TO copy_association;
1944: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1945: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1946: p_count => x_msg_count,
1947: p_data => x_msg_data);
1948:
1949: --Debug Info

Line 1963: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1959:
1960: WHEN Fnd_Api.G_EXC_ERROR THEN
1961: ROLLBACK TO copy_association;
1962: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1963: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1964: p_count => x_msg_count,
1965: p_data => X_msg_data);
1966: -- Debug info.
1967: IF G_DEBUG='Y' THEN

Line 1980: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

1976:
1977: WHEN OTHERS THEN
1978: ROLLBACK TO copy_association;
1979: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1980: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1981: THEN
1982: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1983: p_procedure_name => 'COPY_ASSOCIATION',
1984: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1982: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',

1978: ROLLBACK TO copy_association;
1979: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1980: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1981: THEN
1982: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1983: p_procedure_name => 'COPY_ASSOCIATION',
1984: p_error_text => SUBSTR(SQLERRM,1,240));
1985: END IF;
1986: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 1986: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1982: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1983: p_procedure_name => 'COPY_ASSOCIATION',
1984: p_error_text => SUBSTR(SQLERRM,1,240));
1985: END IF;
1986: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1987: p_count => x_msg_count,
1988: p_data => X_msg_data);
1989:
1990: -- Debug info.

Line 2053: Fnd_Msg_Pub.initialize;

2049:
2050: -- Standard call to check for call compatibility.
2051: IF Fnd_Api.to_boolean(p_init_msg_list)
2052: THEN
2053: Fnd_Msg_Pub.initialize;
2054: END IF;
2055: -- Initialize API return status to success
2056: x_return_status := 'S';
2057: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2085: FND_MSG_PUB.ADD;

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:
2089: END LOOP;

Line 2096: FND_MSG_PUB.ADD;

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:
2100: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DELETED');

Line 2101: 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;
2105:

Line 2129: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

2125: EXCEPTION
2126: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2127: ROLLBACK TO copy_association;
2128: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2129: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2130: p_count => x_msg_count,
2131: p_data => x_msg_data);
2132:
2133: --Debug Info

Line 2147: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

2143:
2144: WHEN Fnd_Api.G_EXC_ERROR THEN
2145: ROLLBACK TO copy_association;
2146: X_return_status := Fnd_Api.G_RET_STS_ERROR;
2147: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2148: p_count => x_msg_count,
2149: p_data => X_msg_data);
2150: -- Debug info.
2151: IF G_DEBUG='Y' THEN

Line 2164: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

2160:
2161: WHEN OTHERS THEN
2162: ROLLBACK TO copy_association;
2163: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2164: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2165: THEN
2166: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
2167: p_procedure_name => 'DELETE_ALL_ASSOCIATION',
2168: p_error_text => SUBSTR(SQLERRM,1,240));

Line 2166: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',

2162: ROLLBACK TO copy_association;
2163: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2164: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2165: THEN
2166: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
2167: p_procedure_name => 'DELETE_ALL_ASSOCIATION',
2168: p_error_text => SUBSTR(SQLERRM,1,240));
2169: END IF;
2170: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 2170: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

2166: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
2167: p_procedure_name => 'DELETE_ALL_ASSOCIATION',
2168: p_error_text => SUBSTR(SQLERRM,1,240));
2169: END IF;
2170: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2171: p_count => x_msg_count,
2172: p_data => X_msg_data);
2173:
2174: -- Debug info.