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 1661: l_error_message_code fnd_new_messages.message_name%TYPE;

1657: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1658: IS
1659: l_return_status VARCHAR2(1);
1660: l_msg_data VARCHAR2(2000);
1661: l_error_message_code fnd_new_messages.message_name%TYPE;
1662: l_resource_type_id NUMBER;
1663: l_msg_index_out NUMBER;
1664: l_msg_count NUMBER;
1665: BEGIN

Line 3070: l_error_message_code fnd_new_messages.message_name%TYPE;

3066: RETURN VARCHAR2
3067: IS
3068: l_org_id NUMBER;
3069: l_return_status VARCHAR2(1);
3070: l_error_message_code fnd_new_messages.message_name%TYPE;
3071: BEGIN
3072:
3073: l_org_id := fnd_profile.value_specific(
3074: name => 'PA_STAFF_HOME_DEF_ORG',