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_PRO_TYPE_ASO_PVT dependencies on FND_MSG_PUB

Line 98: FND_MSG_PUB.ADD;

94: (p_document_sub_type_id IS NOT NULL
95: AND l_doc_type_code IS NULL)
96: THEN
97: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NULL');
98: FND_MSG_PUB.ADD;
99: END IF;
100: -- This condition checks for doc sub type code
101: IF (p_document_sub_type_id IS NULL AND
102: p_doc_sub_type_code IS NULL) OR

Line 109: FND_MSG_PUB.ADD;

105: AND l_doc_sub_type_code IS NULL)
106:
107: THEN
108: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUB_TYPE_CODE_NULL');
109: FND_MSG_PUB.ADD;
110: END IF;
111: -- This condiiton checks for existence of Doc Type code in fnd lookups
112: IF p_doc_type_code IS NOT NULL
113: THEN

Line 119: FND_MSG_PUB.ADD;

115: FETCH get_doc_type_code INTO l_dummy;
116: IF get_doc_type_code%NOTFOUND
117: THEN
118: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NOT_EXIST');
119: FND_MSG_PUB.ADD;
120: END IF;
121: CLOSE get_doc_type_code;
122: END IF;
123: -- This condition checks for existence of Doc Sub Type code in fnd lookups

Line 131: FND_MSG_PUB.ADD;

127: FETCH get_doc_sub_type_code INTO l_dummy,l_meaning;
128: IF get_doc_sub_type_code%NOTFOUND
129: THEN
130: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUBT_COD_NOT_EXIST');
131: FND_MSG_PUB.ADD;
132: END IF;
133: CLOSE get_doc_sub_type_code;
134: END IF;
135: --Checks for Duplicate Record

Line 142: FND_MSG_PUB.ADD;

138: FETCH dup_rec INTO l_dummy;
139: IF dup_rec%FOUND THEN
140: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_DUP_RECORD');
141: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_meaning);
142: FND_MSG_PUB.ADD;
143: END IF;
144: CLOSE dup_rec;
145: */
146: END IF;

Line 230: FND_MSG_PUB.initialize;

226: END IF;
227: -- Standard call to check for call compatibility.
228: IF FND_API.to_boolean(p_init_msg_list)
229: THEN
230: FND_MSG_PUB.initialize;
231: END IF;
232: -- Initialize API return status to success
233: x_return_status := 'S';
234: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 256: FND_MSG_PUB.ADD;

252: l_doc_sub_type_code,
253: l_object_version_number;
254: IF (get_doc_sub_rec_info%NOTFOUND) THEN
255: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_REC_NOT_FOUND');
256: FND_MSG_PUB.ADD;
257: END IF;
258: CLOSE get_doc_sub_rec_info;
259:
260: -- Check for version number

Line 266: FND_MSG_PUB.ADD;

262: THEN
263: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');
264: FND_MESSAGE.SET_TOKEN('SUBTYPE',initcap(l_doc_sub_type_code));
265:
266: FND_MSG_PUB.ADD;
267: END IF;
268:
269: -- Check for association type Exists in Documents table
270: IF p_doc_type_assoc_tbl(i).document_sub_type_id IS NOT NULL

Line 284: -- FND_MSG_PUB.ADD;

280:
281: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REC_EXISTS');
282: -- FND_MESSAGE.SEt_TOKEN('SUBTYPNAME',l_meaning);
283:
284: -- FND_MSG_PUB.ADD;
285:
286:
287: CLOSE Check_Doc_Record;
288: ELSE

Line 301: l_msg_count := FND_MSG_PUB.count_msg;

297: END IF;
298: END LOOP;
299:
300: --Standard check to count messages
301: l_msg_count := FND_MSG_PUB.count_msg;
302:
303: IF l_msg_count > 0 THEN
304: X_msg_count := l_msg_count;
305: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

323: EXCEPTION
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: ROLLBACK TO delete_doc_type_assoc;
326: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data);
330: IF G_DEBUG='Y' THEN
331: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

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

339:
340: WHEN FND_API.G_EXC_ERROR THEN
341: ROLLBACK TO delete_doc_type_assoc;
342: X_return_status := FND_API.G_RET_STS_ERROR;
343: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
344: p_count => x_msg_count,
345: p_data => X_msg_data);
346: -- Debug info.
347: IF G_DEBUG='Y' THEN

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

356:
357: WHEN OTHERS THEN
358: ROLLBACK TO delete_doc_type_assoc;
359: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
361: THEN
362: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',
363: p_procedure_name => 'DELETE_DOC_TYPE_ASSOC',
364: p_error_text => SUBSTR(SQLERRM,1,240));

Line 362: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',

358: ROLLBACK TO delete_doc_type_assoc;
359: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
361: THEN
362: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',
363: p_procedure_name => 'DELETE_DOC_TYPE_ASSOC',
364: p_error_text => SUBSTR(SQLERRM,1,240));
365: END IF;
366: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

362: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',
363: p_procedure_name => 'DELETE_DOC_TYPE_ASSOC',
364: p_error_text => SUBSTR(SQLERRM,1,240));
365: END IF;
366: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
367: p_count => x_msg_count,
368: p_data => X_msg_data);
369:
370: -- Debug info.

Line 447: FND_MSG_PUB.initialize;

443: END IF;
444: -- Standard call to check for call compatibility.
445: IF FND_API.to_boolean(p_init_msg_list)
446: THEN
447: FND_MSG_PUB.initialize;
448: END IF;
449: -- Initialize API return status to success
450: x_return_status := 'S';
451: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 471: l_msg_count := FND_MSG_PUB.count_msg;

467: p_doc_sub_type_code => p_x_doc_type_assoc_tbl(i).doc_sub_type_code,
468: p_delete_flag => p_x_doc_type_assoc_tbl(i).delete_flag);
469: END LOOP;
470: --Standard check for count messages
471: l_msg_count := FND_MSG_PUB.count_msg;
472:
473: IF l_msg_count > 0 THEN
474: X_msg_count := l_msg_count;
475: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 510: FND_MSG_PUB.ADD;

506: FETCH get_doc_sub_type_code INTO l_dummy,l_meaning;
507: CLOSE get_doc_sub_type_code ;
508: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_DUP_RECORD');
509: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_meaning);
510: FND_MSG_PUB.ADD;
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513: CLOSE dup_rec;
514: --

Line 577: l_msg_count := FND_MSG_PUB.count_msg;

573: fnd_global.login_id
574: );
575: p_x_doc_type_assoc_tbl(i).document_sub_type_id := l_document_sub_type_id;
576: --Standard check for messages
577: l_msg_count := FND_MSG_PUB.count_msg;
578:
579: IF l_msg_count > 0 THEN
580: X_msg_count := l_msg_count;
581: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

602: EXCEPTION
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: ROLLBACK TO create_doc_type_assoc;
605: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
607: p_count => x_msg_count,
608: p_data => x_msg_data);
609: IF G_DEBUG='Y' THEN
610: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

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

618:
619: WHEN FND_API.G_EXC_ERROR THEN
620: ROLLBACK TO create_doc_type_assoc;
621: X_return_status := FND_API.G_RET_STS_ERROR;
622: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
623: p_count => x_msg_count,
624: p_data => X_msg_data);
625: -- Debug info.
626: IF G_DEBUG='Y' THEN

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

635:
636: WHEN OTHERS THEN
637: ROLLBACK TO create_doc_type_assoc;
638: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
640: THEN
641: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',
642: p_procedure_name => 'CREATE_DOC_TYPE_ASSOC',
643: p_error_text => SUBSTR(SQLERRM,1,240));

Line 641: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',

637: ROLLBACK TO create_doc_type_assoc;
638: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
640: THEN
641: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',
642: p_procedure_name => 'CREATE_DOC_TYPE_ASSOC',
643: p_error_text => SUBSTR(SQLERRM,1,240));
644: END IF;
645: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

641: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',
642: p_procedure_name => 'CREATE_DOC_TYPE_ASSOC',
643: p_error_text => SUBSTR(SQLERRM,1,240));
644: END IF;
645: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
646: p_count => x_msg_count,
647: p_data => X_msg_data);
648:
649: -- Debug info.

Line 773: FND_MSG_PUB.initialize;

769: END IF;
770: -- Standard call to check for call compatibility.
771: IF FND_API.to_boolean(p_init_msg_list)
772: THEN
773: FND_MSG_PUB.initialize;
774: END IF;
775: -- Initialize API return status to success
776: x_return_status := 'S';
777: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 797: l_msg_count := FND_MSG_PUB.count_msg;

793: p_doc_sub_type_code => p_x_doc_type_assoc_tbl(i).doc_sub_type_code,
794: p_delete_flag => p_x_doc_type_assoc_tbl(i).delete_flag);
795: END LOOP;
796: --Standard check for messages
797: l_msg_count := FND_MSG_PUB.count_msg;
798:
799: IF l_msg_count > 0 THEN
800: X_msg_count := l_msg_count;
801: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 820: -- FND_MSG_PUB.ADD;

816: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');
817: -- FND_MESSAGE.SET_TOKEN('SUBTYPE',initcap(l_doc_sub_type_code));
818:
819:
820: -- FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;
822: End IF;
823: */
824:

Line 903: FND_MSG_PUB.ADD;

899: FETCH get_doc_sub_type_code INTO l_meaning;
900: CLOSE get_doc_sub_type_code;
901: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCSUB_DUP_RECORD');
902: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_meaning);
903: FND_MSG_PUB.ADD;
904: END;
905:
906: IF G_DEBUG='Y' THEN
907: AHL_DEBUG_PUB.debug( 'The error count inside update'||FND_MSG_PUB.count_msg);

Line 907: AHL_DEBUG_PUB.debug( 'The error count inside update'||FND_MSG_PUB.count_msg);

903: FND_MSG_PUB.ADD;
904: END;
905:
906: IF G_DEBUG='Y' THEN
907: AHL_DEBUG_PUB.debug( 'The error count inside update'||FND_MSG_PUB.count_msg);
908:
909: END IF;
910:
911: END IF;

Line 928: FND_MSG_PUB.ADD;

924: FETCH get_doc_sub_rec_info INTO l_doc_type_assoc_info;
925: IF (get_doc_sub_rec_info%NOTFOUND) THEN
926: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBTYPE_REC_CHANGED');
927: FND_MESSAGE.SET_TOKEN('SUBTYPE',initcap(p_x_doc_type_assoc_tbl(i).doc_sub_type_code));
928: FND_MSG_PUB.ADD;
929: END IF;
930: CLOSE get_doc_sub_rec_info;
931:
932: -- Check for version number

Line 952: FND_MSG_PUB.ADD;

948: CLOSE get_doc_sub_type_code;
949:
950: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REC_EXISTS');
951: FND_MESSAGE.SET_TOKEN('SUBTYPNAME',l_meaning);
952: FND_MSG_PUB.ADD;
953:
954:
955: CLOSE Check_Doc_Record;
956: ELSE

Line 962: AHL_DEBUG_PUB.debug( 'The error count inside delete'||FND_MSG_PUB.count_msg);

958: END IF;
959: END IF;
960:
961: IF G_DEBUG='Y' THEN
962: AHL_DEBUG_PUB.debug( 'The error count inside delete'||FND_MSG_PUB.count_msg);
963:
964: END IF;
965: IF (NVL(FND_MSG_PUB.count_msg,0) = 0) THEN
966: -- Delete the record from document subtypes table

Line 965: IF (NVL(FND_MSG_PUB.count_msg,0) = 0) THEN

961: IF G_DEBUG='Y' THEN
962: AHL_DEBUG_PUB.debug( 'The error count inside delete'||FND_MSG_PUB.count_msg);
963:
964: END IF;
965: IF (NVL(FND_MSG_PUB.count_msg,0) = 0) THEN
966: -- Delete the record from document subtypes table
967: DELETE FROM AHL_DOCUMENT_SUB_TYPES
968: WHERE ROWID = l_doc_type_assoc_info.ROW_ID;
969: END IF;

Line 989: AHL_DEBUG_PUB.debug( 'The error count '||FND_MSG_PUB.count_msg);

985: END LOOP;
986: END IF;
987:
988: IF G_DEBUG='Y' THEN
989: AHL_DEBUG_PUB.debug( 'The error count '||FND_MSG_PUB.count_msg);
990:
991: END IF;
992: --Standard check for messages
993: l_msg_count := FND_MSG_PUB.count_msg;

Line 993: l_msg_count := FND_MSG_PUB.count_msg;

989: AHL_DEBUG_PUB.debug( 'The error count '||FND_MSG_PUB.count_msg);
990:
991: END IF;
992: --Standard check for messages
993: l_msg_count := FND_MSG_PUB.count_msg;
994:
995: IF l_msg_count > 0 THEN
996: X_msg_count := l_msg_count;
997: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1016: EXCEPTION
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: ROLLBACK TO modify_doc_type_assoc;
1019: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1021: p_count => x_msg_count,
1022: p_data => x_msg_data);
1023: IF G_DEBUG='Y' THEN
1024: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

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

1032:
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO modify_doc_type_assoc;
1035: X_return_status := FND_API.G_RET_STS_ERROR;
1036: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1037: p_count => x_msg_count,
1038: p_data => X_msg_data);
1039: -- Debug info.
1040: IF G_DEBUG='Y' THEN

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

1049:
1050: WHEN OTHERS THEN
1051: ROLLBACK TO modify_doc_type_assoc;
1052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1054: THEN
1055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',
1056: p_procedure_name => 'MODIFY_DOC_TYPE_ASSOC',
1057: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',

1051: ROLLBACK TO modify_doc_type_assoc;
1052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1054: THEN
1055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',
1056: p_procedure_name => 'MODIFY_DOC_TYPE_ASSOC',
1057: p_error_text => SUBSTR(SQLERRM,1,240));
1058: END IF;
1059: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',
1056: p_procedure_name => 'MODIFY_DOC_TYPE_ASSOC',
1057: p_error_text => SUBSTR(SQLERRM,1,240));
1058: END IF;
1059: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1060: p_count => x_msg_count,
1061: p_data => X_msg_data);
1062: -- Debug info.
1063: IF G_DEBUG='Y' THEN