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 251: FND_MSG_PUB.Initialize;

247: END IF;
248:
249: -- Initialize message list if p_init_msg_list is set to TRUE
250: IF FND_API.To_Boolean(p_init_msg_list) THEN
251: FND_MSG_PUB.Initialize;
252: END IF;
253:
254: -- Initialize API return status to success
255: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

263: p_request_type => p_request_type,
264: p_visit_id => p_visit_id,
265: x_route_id => l_route_id);
266:
267: IF (FND_MSG_PUB.Count_Msg > 0) THEN
268: -- There are validation errors: Raise error
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:

Line 375: FND_MSG_PUB.Count_And_Get

371: END LOOP;
372: END IF;
373:
374: -- Standard call to get message count and if count is 1, get message info
375: FND_MSG_PUB.Count_And_Get
376: ( p_count => x_msg_count,
377: p_data => x_msg_data,
378: p_encoded => fnd_api.g_false
379: );

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

384:
385: EXCEPTION
386: WHEN FND_API.G_EXC_ERROR THEN
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
389: p_data => x_msg_data,
390: p_encoded => fnd_api.g_false);
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

390: p_encoded => fnd_api.g_false);
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
395: p_data => x_msg_data,
396: p_encoded => fnd_api.g_false);
397:
398: WHEN OTHERS THEN

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

396: p_encoded => fnd_api.g_false);
397:
398: WHEN OTHERS THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
401: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
402: p_procedure_name => 'Get_Route_Mtl_Req',
403: p_error_text => SUBSTR(SQLERRM,1,240));
404: END IF;

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

397:
398: WHEN OTHERS THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
401: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
402: p_procedure_name => 'Get_Route_Mtl_Req',
403: p_error_text => SUBSTR(SQLERRM,1,240));
404: END IF;
405: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

401: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
402: p_procedure_name => 'Get_Route_Mtl_Req',
403: p_error_text => SUBSTR(SQLERRM,1,240));
404: END IF;
405: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
406: p_data => x_msg_data,
407: p_encoded => fnd_api.g_false);
408:
409: END Get_Route_Mtl_Req;

Line 591: FND_MSG_PUB.ADD;

587:
588: -- Get the Route Id
589: IF (p_route_id IS NULL AND p_mr_route_id IS NULL) THEN
590: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_ROUTE_ID_NULL');
591: FND_MSG_PUB.ADD;
592: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
593: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
594: END IF;
595: ELSIF (p_route_id IS NULL) THEN

Line 609: FND_MSG_PUB.ADD;

605: FETCH validate_route_id_csr INTO l_dummy;
606: IF (validate_route_id_csr%NOTFOUND) THEN
607: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_ROUTE_ID_INVALID');
608: FND_MESSAGE.Set_Token('ROUTE_ID', x_route_id);
609: FND_MSG_PUB.ADD;
610: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
611: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
612: END IF;
613: END IF;

Line 619: FND_MSG_PUB.ADD;

615:
616: -- Validate the Instance Id
617: IF (p_item_instance_id IS NULL) THEN
618: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_INST_ID_NULL');
619: FND_MSG_PUB.ADD;
620: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
621: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
622: END IF;
623: ELSE

Line 632: FND_MSG_PUB.ADD;

628: FETCH validate_instance_id_csr INTO l_dummy;
629: IF (validate_instance_id_csr%NOTFOUND) THEN
630: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_INST_ID_INVALID');
631: FND_MESSAGE.Set_Token('INST_ID', p_item_instance_id);
632: FND_MSG_PUB.ADD;
633: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
634: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
635: END IF;
636: END IF;

Line 645: FND_MSG_PUB.ADD;

641:
642: -- Validate the Request Type
643: IF (p_request_type IS NULL) THEN
644: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_TYPE_NULL');
645: FND_MSG_PUB.ADD;
646: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
647: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
648: END IF;
649: ELSIF (p_request_type NOT IN (G_REQ_TYPE_FORECAST, G_REQ_TYPE_PLANNED)) THEN

Line 652: FND_MSG_PUB.ADD;

648: END IF;
649: ELSIF (p_request_type NOT IN (G_REQ_TYPE_FORECAST, G_REQ_TYPE_PLANNED)) THEN
650: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_TYPE_INVALID');
651: FND_MESSAGE.Set_Token('REQ_TYPE', p_request_type);
652: FND_MSG_PUB.ADD;
653: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
654: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
655: END IF;
656: END IF;

Line 661: FND_MSG_PUB.ADD;

657:
658: -- Validate the Requirement Date
659: IF (p_requirement_date IS NULL) THEN
660: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_DATE_NULL');
661: FND_MSG_PUB.ADD;
662: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
663: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
664: END IF;
665: -- SKPATHAK :: Bug 8343599 :: 13-APR-2009

Line 671: FND_MSG_PUB.ADD;

667: /**
668: ELSIF (TRUNC(p_requirement_date) < TRUNC(SYSDATE)) THEN
669: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_DATE_PAST');
670: FND_MESSAGE.Set_Token('REQ_DATE', p_requirement_date);
671: FND_MSG_PUB.ADD;
672: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
674: END IF;
675: **/

Line 2167: FND_MSG_PUB.initialize;

2163: END IF;
2164:
2165: --Initialize message list if p_init_msg_list is set to TRUE.
2166: IF FND_API.to_boolean( p_init_msg_list ) THEN
2167: FND_MSG_PUB.initialize;
2168: END IF;
2169:
2170: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2171: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

Line 2299: FND_MSG_PUB.add;

2295: IF l_quantity IS NULL THEN
2296: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
2297: FND_MESSAGE.Set_Token('FUOM', l_uom_code);
2298: FND_MESSAGE.Set_Token('TUOM', p_x_route_mtl_reqs(p_x_index).uom_code);
2299: FND_MSG_PUB.add;
2300: RAISE FND_API.G_EXC_ERROR;
2301: END IF;
2302:
2303: -- Fetching the primary UOM defined for the derived item

Line 2319: FND_MSG_PUB.add;

2315: IF l_remaining_qty IS NULL THEN
2316: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
2317: FND_MESSAGE.Set_Token('FUOM', l_cp_uom);
2318: FND_MESSAGE.Set_Token('TUOM', p_x_route_mtl_reqs(p_x_index).uom_code);
2319: FND_MSG_PUB.add;
2320: RAISE FND_API.G_EXC_ERROR;
2321: END IF;
2322:
2323: -- Fetching the primary UOM defined for the derived item

Line 2369: l_msg_count := FND_MSG_PUB.count_msg;

2365: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
2366: END IF;
2367:
2368: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2369: l_msg_count := FND_MSG_PUB.count_msg;
2370: IF l_msg_count > 0 THEN
2371: x_msg_count := l_msg_count;
2372: RAISE FND_API.G_EXC_ERROR;
2373: END IF;

Line 2376: FND_MSG_PUB.count_and_get(

2372: RAISE FND_API.G_EXC_ERROR;
2373: END IF;
2374:
2375: -- Count and Get messages (optional)
2376: FND_MSG_PUB.count_and_get(
2377: p_encoded => FND_API.G_FALSE,
2378: p_count => x_msg_count,
2379: p_data => x_msg_data);
2380:

Line 2385: FND_MSG_PUB.count_and_get(

2381: EXCEPTION
2382: WHEN FND_API.G_EXC_ERROR THEN
2383: ROLLBACK TO get_material_req_for_pos;
2384: x_return_status := FND_API.G_RET_STS_ERROR ;
2385: FND_MSG_PUB.count_and_get(
2386: p_encoded => FND_API.G_FALSE,
2387: p_count => x_msg_count,
2388: p_data => x_msg_data);
2389:

Line 2393: FND_MSG_PUB.count_and_get(

2389:
2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2391: ROLLBACK TO get_material_req_for_pos;
2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2393: FND_MSG_PUB.count_and_get(
2394: p_encoded => FND_API.G_FALSE,
2395: p_count => x_msg_count,
2396: p_data => x_msg_data);
2397:

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

2397:
2398: WHEN OTHERS THEN
2399: ROLLBACK TO get_material_req_for_pos;
2400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2402: THEN
2403: FND_MSG_PUB.add_exc_msg(
2404: p_pkg_name => G_PKG_NAME,
2405: p_procedure_name => l_api_name,

Line 2403: FND_MSG_PUB.add_exc_msg(

2399: ROLLBACK TO get_material_req_for_pos;
2400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2402: THEN
2403: FND_MSG_PUB.add_exc_msg(
2404: p_pkg_name => G_PKG_NAME,
2405: p_procedure_name => l_api_name,
2406: p_error_text => SUBSTRB(SQLERRM,1,240));
2407: END IF;

Line 2408: FND_MSG_PUB.count_and_get(

2404: p_pkg_name => G_PKG_NAME,
2405: p_procedure_name => l_api_name,
2406: p_error_text => SUBSTRB(SQLERRM,1,240));
2407: END IF;
2408: FND_MSG_PUB.count_and_get(
2409: p_encoded => FND_API.G_FALSE,
2410: p_count => x_msg_count,
2411: p_data => x_msg_data);
2412:

Line 2724: FND_MSG_PUB.initialize;

2720: END IF;
2721:
2722: --Initialize message list if p_init_msg_list is set to TRUE.
2723: IF FND_API.to_boolean( p_init_msg_list ) THEN
2724: FND_MSG_PUB.initialize;
2725: END IF;
2726:
2727: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2728: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

Line 2737: Fnd_Msg_Pub.ADD;

2733: END IF;
2734:
2735: IF p_schedule_material_id IS NULL THEN
2736: Fnd_Message.SET_NAME('AHL','AHL_LTP_MAT_ID_INVALID');
2737: Fnd_Msg_Pub.ADD;
2738: RAISE Fnd_Api.G_EXC_ERROR;
2739: END IF;
2740:
2741: OPEN get_asm_req_details_csr(p_schedule_material_id);

Line 2745: Fnd_Msg_Pub.ADD;

2741: OPEN get_asm_req_details_csr(p_schedule_material_id);
2742: FETCH get_asm_req_details_csr INTO l_asm_req_rec;
2743: IF get_asm_req_details_csr%NOTFOUND THEN
2744: Fnd_Message.SET_NAME('AHL','AHL_LTP_MAT_ID_INVALID');
2745: Fnd_Msg_Pub.ADD;
2746: CLOSE get_asm_req_details_csr;
2747: RAISE Fnd_Api.G_EXC_ERROR;
2748: END IF;
2749: CLOSE get_asm_req_details_csr;

Line 2846: l_msg_count := FND_MSG_PUB.count_msg;

2842: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
2843: END IF;
2844:
2845: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2846: l_msg_count := FND_MSG_PUB.count_msg;
2847: IF l_msg_count > 0 THEN
2848: x_msg_count := l_msg_count;
2849: RAISE FND_API.G_EXC_ERROR;
2850: END IF;

Line 2853: FND_MSG_PUB.count_and_get(

2849: RAISE FND_API.G_EXC_ERROR;
2850: END IF;
2851:
2852: -- Count and Get messages (optional)
2853: FND_MSG_PUB.count_and_get(
2854: p_encoded => FND_API.G_FALSE,
2855: p_count => x_msg_count,
2856: p_data => x_msg_data);
2857:

Line 2861: FND_MSG_PUB.count_and_get(

2857:
2858: EXCEPTION
2859: WHEN FND_API.G_EXC_ERROR THEN
2860: x_return_status := FND_API.G_RET_STS_ERROR ;
2861: FND_MSG_PUB.count_and_get(
2862: p_encoded => FND_API.G_FALSE,
2863: p_count => x_msg_count,
2864: p_data => x_msg_data);
2865:

Line 2868: FND_MSG_PUB.count_and_get(

2864: p_data => x_msg_data);
2865:
2866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2868: FND_MSG_PUB.count_and_get(
2869: p_encoded => FND_API.G_FALSE,
2870: p_count => x_msg_count,
2871: p_data => x_msg_data);
2872:

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

2871: p_data => x_msg_data);
2872:
2873: WHEN OTHERS THEN
2874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2876: THEN
2877: FND_MSG_PUB.add_exc_msg(
2878: p_pkg_name => G_PKG_NAME,
2879: p_procedure_name => l_api_name,

Line 2877: FND_MSG_PUB.add_exc_msg(

2873: WHEN OTHERS THEN
2874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2876: THEN
2877: FND_MSG_PUB.add_exc_msg(
2878: p_pkg_name => G_PKG_NAME,
2879: p_procedure_name => l_api_name,
2880: p_error_text => SUBSTRB(SQLERRM,1,240));
2881: END IF;

Line 2882: FND_MSG_PUB.count_and_get(

2878: p_pkg_name => G_PKG_NAME,
2879: p_procedure_name => l_api_name,
2880: p_error_text => SUBSTRB(SQLERRM,1,240));
2881: END IF;
2882: FND_MSG_PUB.count_and_get(
2883: p_encoded => FND_API.G_FALSE,
2884: p_count => x_msg_count,
2885: p_data => x_msg_data);
2886: END Get_Alternate_Items;