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

Line 221: FND_MSG_PUB.Initialize;

217: END IF;
218:
219: -- Initialize message list if p_init_msg_list is set to TRUE
220: IF FND_API.To_Boolean(p_init_msg_list) THEN
221: FND_MSG_PUB.Initialize;
222: END IF;
223:
224: -- Initialize API return status to success
225: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 236: IF (FND_MSG_PUB.Count_Msg > 0) THEN

232: p_requirement_date => p_requirement_date,
233: p_request_type => p_request_type,
234: x_route_id => l_route_id);
235:
236: IF (FND_MSG_PUB.Count_Msg > 0) THEN
237: -- There are validation errors: Raise error
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240:

Line 338: FND_MSG_PUB.Count_And_Get

334: END LOOP;
335: END IF;
336:
337: -- Standard call to get message count and if count is 1, get message info
338: FND_MSG_PUB.Count_And_Get
339: ( p_count => x_msg_count,
340: p_data => x_msg_data,
341: p_encoded => fnd_api.g_false
342: );

Line 351: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

347:
348: EXCEPTION
349: WHEN FND_API.G_EXC_ERROR THEN
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
352: p_data => x_msg_data,
353: p_encoded => fnd_api.g_false);
354:
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 357: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

353: p_encoded => fnd_api.g_false);
354:
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
358: p_data => x_msg_data,
359: p_encoded => fnd_api.g_false);
360:
361: WHEN OTHERS THEN

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

359: p_encoded => fnd_api.g_false);
360:
361: WHEN OTHERS THEN
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
363: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
364: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
365: p_procedure_name => 'Get_Route_Mtl_Req',
366: p_error_text => SUBSTR(SQLERRM,1,240));
367: END IF;

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

360:
361: WHEN OTHERS THEN
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
363: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
364: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
365: p_procedure_name => 'Get_Route_Mtl_Req',
366: p_error_text => SUBSTR(SQLERRM,1,240));
367: END IF;
368: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 368: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

364: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
365: p_procedure_name => 'Get_Route_Mtl_Req',
366: p_error_text => SUBSTR(SQLERRM,1,240));
367: END IF;
368: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
369: p_data => x_msg_data,
370: p_encoded => fnd_api.g_false);
371:
372: END Get_Route_Mtl_Req;

Line 543: FND_MSG_PUB.ADD;

539:
540: -- Get the Route Id
541: IF (p_route_id IS NULL AND p_mr_route_id IS NULL) THEN
542: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_ROUTE_ID_NULL');
543: FND_MSG_PUB.ADD;
544: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
545: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
546: END IF;
547: ELSIF (p_route_id IS NULL) THEN

Line 561: FND_MSG_PUB.ADD;

557: FETCH validate_route_id_csr INTO l_dummy;
558: IF (validate_route_id_csr%NOTFOUND) THEN
559: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_ROUTE_ID_INVALID');
560: FND_MESSAGE.Set_Token('ROUTE_ID', x_route_id);
561: FND_MSG_PUB.ADD;
562: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
564: END IF;
565: END IF;

Line 571: FND_MSG_PUB.ADD;

567:
568: -- Validate the Instance Id
569: IF (p_item_instance_id IS NULL) THEN
570: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_INST_ID_NULL');
571: FND_MSG_PUB.ADD;
572: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
573: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
574: END IF;
575: ELSE

Line 581: FND_MSG_PUB.ADD;

577: FETCH validate_instance_id_csr INTO l_dummy;
578: IF (validate_instance_id_csr%NOTFOUND) THEN
579: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_INST_ID_INVALID');
580: FND_MESSAGE.Set_Token('INST_ID', p_item_instance_id);
581: FND_MSG_PUB.ADD;
582: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
583: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
584: END IF;
585: END IF;

Line 592: FND_MSG_PUB.ADD;

588:
589: -- Validate the Request Type
590: IF (p_request_type IS NULL) THEN
591: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_TYPE_NULL');
592: FND_MSG_PUB.ADD;
593: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
594: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
595: END IF;
596: ELSIF (p_request_type NOT IN (G_REQ_TYPE_FORECAST, G_REQ_TYPE_PLANNED)) THEN

Line 599: FND_MSG_PUB.ADD;

595: END IF;
596: ELSIF (p_request_type NOT IN (G_REQ_TYPE_FORECAST, G_REQ_TYPE_PLANNED)) THEN
597: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_TYPE_INVALID');
598: FND_MESSAGE.Set_Token('REQ_TYPE', p_request_type);
599: FND_MSG_PUB.ADD;
600: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
601: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
602: END IF;
603: END IF;

Line 608: FND_MSG_PUB.ADD;

604:
605: -- Validate the Requirement Date
606: IF (p_requirement_date IS NULL) THEN
607: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_DATE_NULL');
608: FND_MSG_PUB.ADD;
609: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
610: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
611: END IF;
612: ELSIF (TRUNC(p_requirement_date) < TRUNC(SYSDATE)) THEN

Line 615: FND_MSG_PUB.ADD;

611: END IF;
612: ELSIF (TRUNC(p_requirement_date) < TRUNC(SYSDATE)) THEN
613: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_DATE_PAST');
614: FND_MESSAGE.Set_Token('REQ_DATE', p_requirement_date);
615: FND_MSG_PUB.ADD;
616: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
618: END IF;
619: END IF;