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.PA_RESOURCE_PVT dependencies on FND_NEW_MESSAGES

Line 226: l_err_msg_code fnd_new_messages.message_name%TYPE;

222: IS
223: l_resource_denorm_rec PA_RESOURCE_PVT.Resource_denorm_Rec_type;
224: l_resource_id pa_resources_denorm.resource_id%TYPE := NULL;
225: l_return_status VARCHAR2(1);
226: l_err_msg_code fnd_new_messages.message_name%TYPE;
227: l_msg_index_out NUMBER;
228: l_rows_exists VARCHAR2(1);
229: BEGIN
230: -- Initialize the Error Stack

Line 465: l_err_msg_code fnd_new_messages.message_name%TYPE;

461: l_resource_denorm_new_rec PA_RESOURCE_PVT.Resource_denorm_Rec_type;
462: l_resource_id NUMBER;
463: l_exists VARCHAR2(1);
464: l_return_status VARCHAR2(1);
465: l_err_msg_code fnd_new_messages.message_name%TYPE;
466: l_msg_index_out NUMBER;
467:
468: BEGIN
469: -- Initialize the Error Stack

Line 617: l_err_msg_code fnd_new_messages.message_name%TYPE;

613: x_err_msg_code OUT NOCOPY VARCHAR) --File.Sql.39 bug 4440895
614: IS
615: num_of_rec NUMBER;
616: l_return_status VARCHAR2(1);
617: l_err_msg_code fnd_new_messages.message_name%TYPE;
618:
619: BEGIN
620: -- Initialize the return status to success
621: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 887: -- l_err_msg_code fnd_new_messages.message_name%TYPE;

883: IS
884: -- l_manager_id pa_resources_denorm.manager_id%TYPE;
885: -- l_msg_index_out NUMBER;
886: -- l_return_status VARCHAR2(1);
887: -- l_err_msg_code fnd_new_messages.message_name%TYPE;
888:
889: BEGIN
890: -- Initialize the return status to success
891: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1562: l_error_message_code fnd_new_messages.message_name%TYPE;

1558: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1559: IS
1560: l_return_status VARCHAR2(1);
1561: l_msg_data VARCHAR2(2000);
1562: l_error_message_code fnd_new_messages.message_name%TYPE;
1563: l_resource_type_id NUMBER;
1564: l_msg_index_out NUMBER;
1565: l_msg_count NUMBER;
1566: BEGIN

Line 2971: l_error_message_code fnd_new_messages.message_name%TYPE;

2967: RETURN VARCHAR2
2968: IS
2969: l_org_id NUMBER;
2970: l_return_status VARCHAR2(1);
2971: l_error_message_code fnd_new_messages.message_name%TYPE;
2972: BEGIN
2973:
2974: l_org_id := fnd_profile.value_specific(
2975: name => 'PA_STAFF_HOME_DEF_ORG',