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

Line 81: FND_MSG_PUB.initialize;

77: END IF;
78: -- Standard call to check for call compatibility.
79: IF FND_API.to_boolean(l_init_msg_list)
80: THEN
81: FND_MSG_PUB.initialize;
82: END IF;
83: -- Initialize API return status to success
84: x_return_status := 'S';
85: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 111: FND_MSG_PUB.ADD;

107: FETCH lookup_code_value INTO l_doc_type_code;
108: IF lookup_code_value%NOTFOUND
109: THEN
110: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NOT_EXIST');
111: FND_MSG_PUB.ADD;
112: ELSE
113: l_doc_type_assoc_tbl(i).doc_type_code := l_doc_type_code;
114: END IF;
115: CLOSE lookup_code_value;

Line 124: FND_MSG_PUB.ADD;

120: l_doc_type_assoc_tbl(i).doc_type_code := p_x_doc_type_assoc_tbl(i).doc_type_code;
121: --Both missing
122: ELSE
123: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NULL');
124: FND_MSG_PUB.ADD;
125: END IF;
126:
127: --For Sub Type Code
128: IF p_x_doc_type_assoc_tbl(i).doc_sub_type_desc IS NOT NULL

Line 137: FND_MSG_PUB.ADD;

133: IF lookup_code_value%NOTFOUND
134: THEN
135: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUB_CODE_NOT_EXIST');
136: FND_MESSAGE.SET_TOKEN('SUBTYPE',p_x_doc_type_assoc_tbl(i).doc_sub_type_desc);
137: FND_MSG_PUB.ADD;
138: ELSE
139: l_doc_type_assoc_tbl(i).doc_sub_type_code := l_doc_sub_type_code;
140: END IF;
141: CLOSE lookup_code_value;

Line 149: FND_MSG_PUB.ADD;

145: l_doc_type_assoc_tbl(i).doc_sub_type_code := p_x_doc_type_assoc_tbl(i).doc_sub_type_code;
146: -- If both missing
147: ELSE
148: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUB_TYPE_CODE_NULL');
149: FND_MSG_PUB.ADD;
150: END IF;
151:
152: l_doc_type_assoc_tbl(i).document_sub_type_id := p_x_doc_type_assoc_tbl(i).document_sub_type_id;
153: l_doc_type_assoc_tbl(i).attribute_category := p_x_doc_type_assoc_tbl(i).attribute_category;

Line 172: l_msg_count := FND_MSG_PUB.count_msg;

168: l_doc_type_assoc_tbl(i).attribute15 := p_x_doc_type_assoc_tbl(i).attribute15;
169: l_doc_type_assoc_tbl(i).delete_flag := p_x_doc_type_assoc_tbl(i).delete_flag;
170: l_doc_type_assoc_tbl(i).object_version_number := p_x_doc_type_assoc_tbl(i).object_version_number;
171: --Standard check for messages
172: l_msg_count := FND_MSG_PUB.count_msg;
173:
174: IF l_msg_count > 0 THEN
175: X_msg_count := l_msg_count;
176: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

Line 271: l_msg_count := FND_MSG_PUB.count_msg;

267: x_msg_data => l_msg_data
268: );
269:
270: -- Standard check for messages assigns out variable
271: l_msg_count := FND_MSG_PUB.count_msg;
272:
273: IF l_msg_count > 0 THEN
274: X_msg_count := l_msg_count;
275: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

375: EXCEPTION
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377: ROLLBACK TO create_doc_type_assoc;
378: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
380: p_count => x_msg_count,
381: p_data => x_msg_data);
382: IF G_DEBUG='Y' THEN
383: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

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

391:
392: WHEN FND_API.G_EXC_ERROR THEN
393: ROLLBACK TO create_doc_type_assoc;
394: X_return_status := FND_API.G_RET_STS_ERROR;
395: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
396: p_count => x_msg_count,
397: p_data => X_msg_data);
398: -- Debug info.
399: IF G_DEBUG='Y' THEN

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

407:
408: WHEN OTHERS THEN
409: ROLLBACK TO create_doc_type_assoc;
410: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
412: THEN
413: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PUB',
414: p_procedure_name => 'CREATE_DOC_TYPE_ASSOC',
415: p_error_text => SUBSTR(SQLERRM,1,240));

Line 413: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PUB',

409: ROLLBACK TO create_doc_type_assoc;
410: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
412: THEN
413: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PUB',
414: p_procedure_name => 'CREATE_DOC_TYPE_ASSOC',
415: p_error_text => SUBSTR(SQLERRM,1,240));
416: END IF;
417: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

413: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PUB',
414: p_procedure_name => 'CREATE_DOC_TYPE_ASSOC',
415: p_error_text => SUBSTR(SQLERRM,1,240));
416: END IF;
417: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
418: p_count => x_msg_count,
419: p_data => X_msg_data);
420:
421: -- Debug info.

Line 507: FND_MSG_PUB.initialize;

503: END IF;
504: -- Standard call to check for call compatibility.
505: IF FND_API.to_boolean(l_init_msg_list)
506: THEN
507: FND_MSG_PUB.initialize;
508: END IF;
509: -- Initialize API return status to success
510: x_return_status := 'S';
511: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 537: FND_MSG_PUB.ADD;

533: FETCH lookup_code_info INTO l_doc_type_code;
534: IF lookup_code_info%NOTFOUND
535: THEN
536: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NOT_EXIST');
537: FND_MSG_PUB.ADD;
538: ELSE
539: l_doc_type_assoc_tbl(i).doc_type_code := l_doc_type_code;
540: END IF;
541: CLOSE lookup_code_info;

Line 557: FND_MSG_PUB.ADD;

553: IF lookup_code_value%NOTFOUND
554: THEN
555: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUB_CODE_NOT_EXIST');
556: FND_MESSAGE.SET_TOKEN('SUBTYPE',p_x_doc_type_assoc_tbl(i).doc_sub_type_desc);
557: FND_MSG_PUB.ADD;
558: ELSE
559: l_doc_type_assoc_tbl(i).doc_sub_type_code := l_doc_sub_type_code;
560: END IF;
561: CLOSE lookup_code_value;

Line 568: FND_MSG_PUB.ADD;

564: THEN
565: l_doc_type_assoc_tbl(i).doc_sub_type_code := p_x_doc_type_assoc_tbl(i).doc_sub_type_code;
566: ELSE
567: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUB_TYPE_CODE_NULL');
568: FND_MSG_PUB.ADD;
569: END IF;
570: --
571: l_doc_type_assoc_tbl(i).document_sub_type_id := p_x_doc_type_assoc_tbl(i).document_sub_type_id;
572: l_doc_type_assoc_tbl(i).attribute_category := p_x_doc_type_assoc_tbl(i).attribute_category;

Line 591: l_msg_count := FND_MSG_PUB.count_msg;

587: l_doc_type_assoc_tbl(i).attribute15 := p_x_doc_type_assoc_tbl(i).attribute15;
588: l_doc_type_assoc_tbl(i).delete_flag := p_x_doc_type_assoc_tbl(i).delete_flag;
589: l_doc_type_assoc_tbl(i).object_version_number := p_x_doc_type_assoc_tbl(i).object_version_number;
590: --Standard check for messages
591: l_msg_count := FND_MSG_PUB.count_msg;
592:
593: IF l_msg_count > 0 THEN
594: X_msg_count := l_msg_count;
595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

Line 691: l_msg_count := FND_MSG_PUB.count_msg;

687: x_msg_count => l_msg_count,
688: x_msg_data => l_msg_data
689: );
690:
691: l_msg_count := FND_MSG_PUB.count_msg;
692:
693: IF l_msg_count > 0 THEN
694: X_msg_count := l_msg_count;
695: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

791: EXCEPTION
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
793: ROLLBACK TO modify_doc_type_assoc;
794: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
796: p_count => x_msg_count,
797: p_data => x_msg_data);
798: IF G_DEBUG='Y' THEN
799: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

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

807:
808: WHEN FND_API.G_EXC_ERROR THEN
809: ROLLBACK TO modify_doc_type_assoc;
810: X_return_status := FND_API.G_RET_STS_ERROR;
811: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
812: p_count => x_msg_count,
813: p_data => X_msg_data);
814: -- Debug info.
815: IF G_DEBUG='Y' THEN

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

824:
825: WHEN OTHERS THEN
826: ROLLBACK TO modify_doc_type_assoc;
827: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
829: THEN
830: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PUB',
831: p_procedure_name => 'MODIFY_DOC_TYPE_ASSOC',
832: p_error_text => SUBSTR(SQLERRM,1,240));

Line 830: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PUB',

826: ROLLBACK TO modify_doc_type_assoc;
827: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
829: THEN
830: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PUB',
831: p_procedure_name => 'MODIFY_DOC_TYPE_ASSOC',
832: p_error_text => SUBSTR(SQLERRM,1,240));
833: END IF;
834: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

830: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PUB',
831: p_procedure_name => 'MODIFY_DOC_TYPE_ASSOC',
832: p_error_text => SUBSTR(SQLERRM,1,240));
833: END IF;
834: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
835: p_count => x_msg_count,
836: p_data => X_msg_data);
837:
838: -- Debug info.