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

Line 90: FND_MSG_PUB.initialize;

86: END IF;
87: -- Initialize message list if p_init_msg_list is set to TRUE.
88: IF FND_API.to_boolean(l_init_msg_list)
89: THEN
90: FND_MSG_PUB.initialize;
91: END IF;
92:
93: -- Initialize API return status to success
94: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 112: FND_MSG_PUB.ADD;

108: WHERE DOC_REVISION_ID = p_x_ahl_fileupload_rec.p_revision_id;
109: EXCEPTION
110: WHEN no_data_found THEN
111: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');
112: FND_MSG_PUB.ADD;
113: IF G_DEBUG='Y' THEN
114: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_DOC REV ID:'||p_x_ahl_fileupload_rec.p_revision_id||': invalid');
115:
116:

Line 125: FND_MSG_PUB.ADD;

121: RAISE;
122: END;
123: ELSE
124: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_NULL');
125: FND_MSG_PUB.ADD;
126: IF G_DEBUG='Y' THEN
127: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_DOC REV null');
128:
129: END IF;

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

264: EXCEPTION
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO UPLOAD_ITEM;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
269: p_count => x_msg_count,
270: p_data => x_msg_data);
271: IF G_DEBUG='Y' THEN
272: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

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

279:
280: WHEN FND_API.G_EXC_ERROR THEN
281: ROLLBACK TO UPLOAD_ITEM;
282: X_return_status := FND_API.G_RET_STS_ERROR;
283: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,
285: p_data => X_msg_data);
286: -- Debug info.
287: IF G_DEBUG='Y' THEN

Line 299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

295:
296: WHEN OTHERS THEN
297: ROLLBACK TO UPLOAD_ITEM;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
300: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
301: p_procedure_name => l_api_name,
302: p_error_text => SUBSTR(SQLERRM,1,240));
303: END IF;

Line 300: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

296: WHEN OTHERS THEN
297: ROLLBACK TO UPLOAD_ITEM;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
300: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
301: p_procedure_name => l_api_name,
302: p_error_text => SUBSTR(SQLERRM,1,240));
303: END IF;
304: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

300: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
301: p_procedure_name => l_api_name,
302: p_error_text => SUBSTR(SQLERRM,1,240));
303: END IF;
304: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
305: p_count => x_msg_count,
306: p_data => x_msg_data);
307:
308: -- Debug info.

Line 374: FND_MSG_PUB.initialize;

370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
371: END IF;
372: -- Initialize message list if p_init_msg_list is set to TRUE.
373: IF FND_API.to_boolean(l_init_msg_list) THEN
374: FND_MSG_PUB.initialize;
375: END IF;
376:
377: -- Initialize API return status to success
378: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 406: FND_MSG_PUB.ADD;

402:
403:
404: END IF;
405: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');
406: FND_MSG_PUB.ADD;
407: x_return_status := FND_API.G_RET_STS_ERROR;
408: WHEN OTHERS THEN
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: RAISE;

Line 419: FND_MSG_PUB.ADD;

415:
416:
417: END IF;
418: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');
419: FND_MSG_PUB.ADD;
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: END IF;
422:
423:

Line 475: FND_MSG_PUB.ADD;

471: -- if association id not found then raise error.
472: IF(l_assoc_id = 0)THEN
473:
474: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_FILE_ASSOC_INVALID');
475: FND_MSG_PUB.ADD;
476: x_return_status := FND_API.G_RET_STS_ERROR;
477:
478: IF G_DEBUG='Y' THEN
479: AHL_DEBUG_PUB.debug( 'ERROR: the file association to be deleted is not found ');

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

511: EXCEPTION
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: ROLLBACK TO Delete_Item;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
516: p_count => x_msg_count,
517: p_data => x_msg_data);
518: IF G_DEBUG='Y' THEN
519: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

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

527:
528: WHEN FND_API.G_EXC_ERROR THEN
529: ROLLBACK TO Delete_Item;
530: X_return_status := FND_API.G_RET_STS_ERROR;
531: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
532: p_count => x_msg_count,
533: p_data => X_msg_data);
534: -- Debug info.
535: IF G_DEBUG='Y' THEN

Line 548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

544:
545: WHEN OTHERS THEN
546: ROLLBACK TO Delete_Item;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
549: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
550: p_procedure_name => l_api_name,
551: p_error_text => SUBSTR(SQLERRM,1,240));
552: END IF;

Line 549: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

545: WHEN OTHERS THEN
546: ROLLBACK TO Delete_Item;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
549: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
550: p_procedure_name => l_api_name,
551: p_error_text => SUBSTR(SQLERRM,1,240));
552: END IF;
553: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

549: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
550: p_procedure_name => l_api_name,
551: p_error_text => SUBSTR(SQLERRM,1,240));
552: END IF;
553: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
554: p_count => x_msg_count,
555: p_data => x_msg_data);
556:
557: -- Debug info.

Line 616: FND_MSG_PUB.initialize;

612: END IF;
613: -- Initialize message list if p_init_msg_list is set to TRUE.
614: IF FND_API.to_boolean(l_init_msg_list)
615: THEN
616: FND_MSG_PUB.initialize;
617: END IF;
618:
619: -- Initialize API return status to success
620: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

658: EXCEPTION
659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: ROLLBACK TO process_item;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data);
665: IF G_DEBUG='Y' THEN
666: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

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

674:
675: WHEN FND_API.G_EXC_ERROR THEN
676: ROLLBACK TO process_item;
677: X_return_status := FND_API.G_RET_STS_ERROR;
678: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,
680: p_data => X_msg_data);
681: -- Debug info.
682: IF G_DEBUG='Y' THEN

Line 695: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

691:
692: WHEN OTHERS THEN
693: ROLLBACK TO process_item;
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
696: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
697: p_procedure_name => l_api_name,
698: p_error_text => SUBSTR(SQLERRM,1,240));
699: END IF;

Line 696: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

692: WHEN OTHERS THEN
693: ROLLBACK TO process_item;
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
696: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
697: p_procedure_name => l_api_name,
698: p_error_text => SUBSTR(SQLERRM,1,240));
699: END IF;
700: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

696: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
697: p_procedure_name => l_api_name,
698: p_error_text => SUBSTR(SQLERRM,1,240));
699: END IF;
700: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,
702: p_data => x_msg_data);
703:
704: -- Debug info.