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_ASSIGNMENT_UTILS dependencies on PA_ASSIGNMENT_UTILS

Line 1: PACKAGE BODY pa_assignment_utils AS

1: PACKAGE BODY pa_assignment_utils AS
2: -- $Header: PARAUTLB.pls 120.10.12010000.2 2008/09/23 17:22:56 jcgeorge ship $
3:
4: --
5: -- PROCEDURE

Line 21: pa_debug.init_err_stack ('pa_assignment_utils.check_status_is_in_use');

17: ,x_in_use_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
18: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
19: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
20: BEGIN
21: pa_debug.init_err_stack ('pa_assignment_utils.check_status_is_in_use');
22: x_error_message_code := NULL;
23: x_in_use_flag := 'N';
24: x_return_status := FND_API.G_RET_STS_SUCCESS;
25:

Line 110: (p_pkg_name => 'PA_ASSIGNMENT_UTILS',

106: x_in_use_flag := NULL ;
107: -- 4537865 : End
108:
109: fnd_msg_pub.add_exc_msg
110: (p_pkg_name => 'PA_ASSIGNMENT_UTILS',
111: p_procedure_name => pa_debug.g_err_stack );
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
113: RAISE;
114: END check_status_is_in_use;

Line 140: pa_debug.init_err_stack ('pa_assignment_utils.Validate_Asgmt_Competency');

136: SELECT business_group_id FROM per_competences
137: WHERE competence_id = p_competence_id;
138:
139: BEGIN
140: pa_debug.init_err_stack ('pa_assignment_utils.Validate_Asgmt_Competency');
141: OPEN l_bg_csr;
142: FETCH l_bg_csr INTO l_comp_bg_id;
143: IF l_bg_csr%NOTFOUND THEN
144: x_return_status := FND_API.G_RET_STS_ERROR;

Line 170: (p_pkg_name => 'PA_ASSIGNMENT_UTILS',

166: x_error_message_code := SQLCODE ;
167: -- 4537865 : End
168:
169: fnd_msg_pub.add_exc_msg
170: (p_pkg_name => 'PA_ASSIGNMENT_UTILS',
171: p_procedure_name => pa_debug.g_err_stack );
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
173: RAISE;
174: END Validate_Asgmt_Competency;

Line 189: pa_debug.init_err_stack ('pa_assignment_utils.Get_Def_Asgmt_Statuses');

185: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
186: x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
187:
188: BEGIN
189: pa_debug.init_err_stack ('pa_assignment_utils.Get_Def_Asgmt_Statuses');
190: x_starting_oa_status := fnd_profile.value ('DEF_OA_STARTING_STATUS');
191: x_starting_sa_status := fnd_profile.value ('DEF_SA_STARTING_STATUS');
192: x_starting_fa_status := fnd_profile.value ('DEF_FA_STATUS');
193: -- While it is ok for the other two statuses to be not defined,

Line 216: (p_pkg_name => 'PA_ASSIGNMENT_UTILS',

212: x_error_message_code := SQLCODE;
213: -- 4537865 :ENd
214:
215: fnd_msg_pub.add_exc_msg
216: (p_pkg_name => 'PA_ASSIGNMENT_UTILS',
217: p_procedure_name => pa_debug.g_err_stack );
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
219: RAISE;
220: END Get_Def_Asgmt_Statuses;

Line 230: pa_debug.init_err_stack ('pa_assignment_utils.Get_Project_Id');

226: -- 17-JUL-2000 R. Krishnamurthy Created
227: FUNCTION Get_Project_Id (p_assignment_id IN NUMBER) RETURN NUMBER IS
228: l_project_id NUMBER ;
229: BEGIN
230: pa_debug.init_err_stack ('pa_assignment_utils.Get_Project_Id');
231: SELECT project_id
232: INTO l_project_id
233: FROM pa_project_assignments
234: WHERE assignment_id = p_assignment_id ;

Line 242: (p_pkg_name => 'PA_ASSIGNMENT_UTILS',

238: WHEN NO_DATA_FOUND THEN
239: RETURN NULL;
240: WHEN OTHERS THEN
241: fnd_msg_pub.add_exc_msg
242: (p_pkg_name => 'PA_ASSIGNMENT_UTILS',
243: p_procedure_name => pa_debug.g_err_stack );
244: RAISE;
245: END Get_Project_Id;
246:

Line 377: pa_debug.init_err_stack ('pa_assignment_utils.Check_proj_Assignments_Exist');

373: ,x_assignments_exist_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
374: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
375: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
376: BEGIN
377: pa_debug.init_err_stack ('pa_assignment_utils.Check_proj_Assignments_Exist');
378: x_assignments_exist_flag := 'N';
379: x_error_message_code := NULL;
380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381:

Line 409: (p_pkg_name => 'PA_ASSIGNMENT_UTILS',

405: x_error_message_code := SQLCODE ;
406: -- 4537865 : End
407:
408: fnd_msg_pub.add_exc_msg
409: (p_pkg_name => 'PA_ASSIGNMENT_UTILS',
410: p_procedure_name => pa_debug.g_err_stack );
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
412: RAISE;
413: END check_proj_assignments_exist;

Line 430: pa_debug.init_err_stack ('pa_assignment_utils.check_assignment_number_or_id');

426: l_id_found_flag VARCHAR2(1);
427: l_current_id pa_project_assignments.assignment_id%TYPE;
428: l_num_ids NUMBER;
429: BEGIN
430: pa_debug.init_err_stack ('pa_assignment_utils.check_assignment_number_or_id');
431: IF p_assignment_id IS NOT NULL AND p_assignment_id <> FND_API.G_MISS_NUM THEN
432: IF p_check_id_flag = 'Y' THEN
433: SELECT assignment_id
434: INTO x_assignment_id

Line 497: (p_pkg_name => 'PA_ASSIGNMENT_UTILS',

493: x_error_message_code := SQLCODE;
494: -- 4537865 : End
495:
496: fnd_msg_pub.add_exc_msg
497: (p_pkg_name => 'PA_ASSIGNMENT_UTILS',
498: p_procedure_name => pa_debug.g_err_stack );
499: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
500: x_assignment_id := NULL;
501: RAISE;

Line 511: pa_debug.init_err_stack ('pa_assignment_utils.Check_STF_PriorityName_Or_Code');

507: ,x_staffing_priority_code OUT NOCOPY pa_project_assignments.staffing_priority_code%TYPE --File.Sql.39 bug 4440895
508: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
509: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
510: BEGIN
511: pa_debug.init_err_stack ('pa_assignment_utils.Check_STF_PriorityName_Or_Code');
512:
513: IF p_staffing_priority_code IS NOT NULL AND p_staffing_priority_code<>FND_API.G_MISS_CHAR THEN
514: IF p_check_id_flag = 'Y' THEN
515: SELECT lookup_code

Line 657: IF pa_assignment_utils.g_team_template_name_token IS NULL AND pa_assignment_utils.g_team_role_name_token IS NULL THEN

653: --if the team_template_name and/or team_role_name global variables are set and there
654: --are any validation errors, then the team_template_name and assignment_name will
655: --be prepended to the error message.
656: --If the globals are NULL then the message will appear normally (nothing prepended).
657: IF pa_assignment_utils.g_team_template_name_token IS NULL AND pa_assignment_utils.g_team_role_name_token IS NULL THEN
658:
659: IF p_token1 IS NULL THEN
660: --message text appear with no prepended values.
661: PA_UTILS.Add_Message(p_app_short_name => p_app_short_name,

Line 671: ELSIF pa_assignment_utils.g_team_template_id IS NOT NULL THEN

667: p_token1 => p_token1,
668: p_value1 => p_value1);
669: END IF;
670:
671: ELSIF pa_assignment_utils.g_team_template_id IS NOT NULL THEN
672:
673: --get the message text
674: OPEN get_message;
675: FETCH get_message INTO l_message_text;

Line 692: IF pa_assignment_utils.g_team_role_name_token IS NULL THEN

688: --the team role name token value is not set then this a team template level
689: --error, so the message will be displayed in the format:
690: --"Team Template Name: Error Message"
691: --both the team template name and error message are tokens.
692: IF pa_assignment_utils.g_team_role_name_token IS NULL THEN
693:
694: IF p_token1 IS NULL THEN
695: PA_UTILS.Add_Message(p_app_short_name => p_app_short_name,
696: p_msg_name => 'PA_TEAM_TEMP_ERR_MSG',

Line 698: p_value1 => pa_assignment_utils.g_team_template_name_token,

694: IF p_token1 IS NULL THEN
695: PA_UTILS.Add_Message(p_app_short_name => p_app_short_name,
696: p_msg_name => 'PA_TEAM_TEMP_ERR_MSG',
697: p_token1 => 'TEAM_TEMPLATE_NAME',
698: p_value1 => pa_assignment_utils.g_team_template_name_token,
699: p_token2 => 'ERROR_MESSAGE',
700: p_value2 => l_message_text);
701: ELSE
702: PA_UTILS.Add_Message(p_app_short_name => p_app_short_name,

Line 705: p_value1 => pa_assignment_utils.g_team_template_name_token,

701: ELSE
702: PA_UTILS.Add_Message(p_app_short_name => p_app_short_name,
703: p_msg_name => 'PA_TEAM_TEMP_ERR_MSG',
704: p_token1 => 'TEAM_TEMPLATE_NAME',
705: p_value1 => pa_assignment_utils.g_team_template_name_token,
706: p_token2 => 'ERROR_MESSAGE',
707: p_value2 => l_message_text,
708: p_token3 => p_token1,
709: p_value3 => p_value1);

Line 718: ELSIF pa_assignment_utils.g_team_role_name_token IS NOT NULL THEN

714: --the team template is being applied to a project.
715: --The message will be displayed in the format:
716: --"Team Template Name: Team Role Name: Error Message"
717: --The team template name, team role name, and error message are tokens.
718: ELSIF pa_assignment_utils.g_team_role_name_token IS NOT NULL THEN
719:
720: IF pa_assignment_utils.g_team_role_name_token IS NULL THEN
721: PA_UTILS.Add_Message(p_app_short_name => p_app_short_name,
722: p_msg_name => 'PA_TEAM_TEMP_ROLE_ERR_MSG',

Line 720: IF pa_assignment_utils.g_team_role_name_token IS NULL THEN

716: --"Team Template Name: Team Role Name: Error Message"
717: --The team template name, team role name, and error message are tokens.
718: ELSIF pa_assignment_utils.g_team_role_name_token IS NOT NULL THEN
719:
720: IF pa_assignment_utils.g_team_role_name_token IS NULL THEN
721: PA_UTILS.Add_Message(p_app_short_name => p_app_short_name,
722: p_msg_name => 'PA_TEAM_TEMP_ROLE_ERR_MSG',
723: p_token1 => 'TEAM_TEMPLATE_NAME',
724: p_value1 => pa_assignment_utils.g_team_template_name_token,

Line 724: p_value1 => pa_assignment_utils.g_team_template_name_token,

720: IF pa_assignment_utils.g_team_role_name_token IS NULL THEN
721: PA_UTILS.Add_Message(p_app_short_name => p_app_short_name,
722: p_msg_name => 'PA_TEAM_TEMP_ROLE_ERR_MSG',
723: p_token1 => 'TEAM_TEMPLATE_NAME',
724: p_value1 => pa_assignment_utils.g_team_template_name_token,
725: p_token2 => 'TEAM_ROLE_NAME',
726: p_value2 => pa_assignment_utils.g_team_role_name_token,
727: p_token3 => 'ERROR_MESSAGE',
728: p_value3 => l_message_text);

Line 726: p_value2 => pa_assignment_utils.g_team_role_name_token,

722: p_msg_name => 'PA_TEAM_TEMP_ROLE_ERR_MSG',
723: p_token1 => 'TEAM_TEMPLATE_NAME',
724: p_value1 => pa_assignment_utils.g_team_template_name_token,
725: p_token2 => 'TEAM_ROLE_NAME',
726: p_value2 => pa_assignment_utils.g_team_role_name_token,
727: p_token3 => 'ERROR_MESSAGE',
728: p_value3 => l_message_text);
729: ELSE
730: PA_UTILS.Add_Message(p_app_short_name => p_app_short_name,

Line 733: p_value1 => pa_assignment_utils.g_team_template_name_token,

729: ELSE
730: PA_UTILS.Add_Message(p_app_short_name => p_app_short_name,
731: p_msg_name => 'PA_TEAM_TEMP_ROLE_ERR_MSG',
732: p_token1 => 'TEAM_TEMPLATE_NAME',
733: p_value1 => pa_assignment_utils.g_team_template_name_token,
734: p_token2 => 'TEAM_ROLE_NAME',
735: p_value2 => pa_assignment_utils.g_team_role_name_token,
736: p_token3 => 'ERROR_MESSAGE',
737: p_value3 => l_message_text,

Line 735: p_value2 => pa_assignment_utils.g_team_role_name_token,

731: p_msg_name => 'PA_TEAM_TEMP_ROLE_ERR_MSG',
732: p_token1 => 'TEAM_TEMPLATE_NAME',
733: p_value1 => pa_assignment_utils.g_team_template_name_token,
734: p_token2 => 'TEAM_ROLE_NAME',
735: p_value2 => pa_assignment_utils.g_team_role_name_token,
736: p_token3 => 'ERROR_MESSAGE',
737: p_value3 => l_message_text,
738: p_token4 => p_token1,
739: p_value4 => p_value1);

Line 814: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENT_UTILS.is_asgmt_allow_stus_ctl_check'

810: EXCEPTION
811: WHEN OTHERS THEN
812: --
813: -- Set the excetption Message and the stack
814: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENT_UTILS.is_asgmt_allow_stus_ctl_check'
815: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
816: --
817: RAISE; -- This is optional depending on the needs
818:

Line 1350: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENT_UTILS.Associate_Planning_Resources'

1346: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345129
1347:
1348: BEGIN
1349: IF l_debug_mode = 'Y' THEN -- 5345129
1350: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENT_UTILS.Associate_Planning_Resources'
1351: ,x_msg => 'old_pls_id='||p_old_resource_list_id||
1352: 'new_pls_id='||p_new_resource_list_id
1353: ,x_log_level => li_message_level);
1354: END IF;

Line 1388: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENT_UTILS.Associate_Planning_Resources'

1384: --dbms_output.put_line ('x_return_status ' || l_return_status);
1385: --dbms_output.put_line ('Assignment res format ' || l_asgmt_res_format_id);
1386: --dbms_output.put_line ('Requirement res format ' || l_req_res_format_id);
1387: IF l_debug_mode = 'Y' THEN -- 5345129
1388: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENT_UTILS.Associate_Planning_Resources'
1389: ,x_msg => 'asgmt_format_id='||l_asgmt_res_format_id||
1390: 'req_format_id='||l_req_res_format_id
1391: ,x_log_level => li_message_level);
1392: END IF;

Line 1537: ( p_pkg_name => 'PA_ASSIGNMENT_UTILS'

1533: x_msg_count := 1 ;
1534: x_msg_data := SUBSTRB(SQLERRM,1,240);
1535:
1536: Fnd_Msg_Pub.add_exc_msg
1537: ( p_pkg_name => 'PA_ASSIGNMENT_UTILS'
1538: , p_procedure_name => 'ASSOCIATE_PLANNING_RESOURCES'
1539: , p_error_text => x_msg_data);
1540:
1541: RAISE;

Line 1904: END PA_ASSIGNMENT_UTILS;

1900: RETURN l_ou_id;
1901:
1902: END Get_Dft_Info;
1903:
1904: END PA_ASSIGNMENT_UTILS;