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 FND_API

Line 24: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
26: --change due to performance reason
27: /*
28: SELECT 'Y', 'PA_STATUS_EXIST_IN_ASGMT'

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

88:
89: pa_debug.reset_err_stack;
90: EXCEPTION
91: WHEN NO_DATA_FOUND THEN
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93: x_in_use_flag := 'N';
94:
95: -- 4537865 : RESET Out params to proper values
96: -- Make x_error_message_code as NULL as in this case we consider return status as 'S'

Line 112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
115:
116: --

Line 144: x_return_status := FND_API.G_RET_STS_ERROR;

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;
145: x_error_message_code := 'PA_COMPETENCY_INVALID_AMBIGOUS';
146: CLOSE l_bg_csr;
147: pa_debug.reset_err_stack;
148: RETURN;

Line 156: x_return_status := FND_API.G_RET_STS_ERROR;

152:
153: --BUG: 1904822 Get project business group id instead of from pa_implementations
154: IF ( l_comp_bg_id IS NOT NULL
155: AND l_comp_bg_id <> pa_project_utils2.Get_project_business_group ( p_project_id)) THEN
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: x_error_message_code := 'PA_ASGMT_COMPETENCY_INVALID';
158: pa_debug.reset_err_stack;
159: RETURN;
160: END IF;

Line 161: x_return_status := FND_API.G_RET_STS_SUCCESS;

157: x_error_message_code := 'PA_ASGMT_COMPETENCY_INVALID';
158: pa_debug.reset_err_stack;
159: RETURN;
160: END IF;
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162: pa_debug.reset_err_stack;
163: EXCEPTION
164: WHEN OTHERS THEN
165: -- 4537865 : RESET Out params to proper values

Line 172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
175:
176: -- PROCEDURE

Line 199: x_return_status := FND_API.G_RET_STS_ERROR;

195: -- in order for the assignments to be marked as filled whenever
196: -- an open assignment is filled with a resource
197:
198: IF x_starting_fa_status IS NULL THEN
199: x_return_status := FND_API.G_RET_STS_ERROR;
200: x_error_message_code := 'PA_NO_DEF_FA_STATUS';
201: ELSE
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203: END IF;

Line 202: x_return_status := FND_API.G_RET_STS_SUCCESS;

198: IF x_starting_fa_status IS NULL THEN
199: x_return_status := FND_API.G_RET_STS_ERROR;
200: x_error_message_code := 'PA_NO_DEF_FA_STATUS';
201: ELSE
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203: END IF;
204: pa_debug.reset_err_stack;
205: EXCEPTION
206: WHEN OTHERS THEN

Line 218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
221:
222: -- FUNCTION

Line 380: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
382: --Change due to Performance Reason
383: /*
384: SELECT 'Y', 'PA_PROJ_ASSIGNMENTS_EXIST'

Line 400: x_return_status := FND_API.G_RET_STS_SUCCESS;

396:
397: pa_debug.reset_err_stack;
398: EXCEPTION
399: WHEN NO_DATA_FOUND THEN
400: x_return_status := FND_API.G_RET_STS_SUCCESS;
401: x_assignments_exist_flag := 'N';
402: WHEN OTHERS THEN
403: -- 4537865 : Start : RESET OUT PARAMS to proper values
404: x_assignments_exist_flag := NULL ;

Line 411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
414:
415: PROCEDURE Check_Assignment_Number_Or_Id( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

Line 431: IF p_assignment_id IS NOT NULL AND p_assignment_id <> FND_API.G_MISS_NUM THEN

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
435: FROM pa_project_assignments

Line 480: x_return_status := FND_API.G_RET_STS_SUCCESS;

476: ELSE
477: x_assignment_id := NULL;
478: END IF;
479: END IF;
480: x_return_status := FND_API.G_RET_STS_SUCCESS;
481: pa_debug.reset_err_stack;
482: EXCEPTION
483: WHEN NO_DATA_FOUND THEN
484: x_return_status := FND_API.G_RET_STS_ERROR;

Line 484: x_return_status := FND_API.G_RET_STS_ERROR;

480: x_return_status := FND_API.G_RET_STS_SUCCESS;
481: pa_debug.reset_err_stack;
482: EXCEPTION
483: WHEN NO_DATA_FOUND THEN
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: x_error_message_code := 'PA_ASGN_NUMBER_INV_AMBIGOUS';
486: x_assignment_id := NULL;
487: WHEN TOO_MANY_ROWS THEN
488: x_assignment_id := NULL;

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485: x_error_message_code := 'PA_ASGN_NUMBER_INV_AMBIGOUS';
486: x_assignment_id := NULL;
487: WHEN TOO_MANY_ROWS THEN
488: x_assignment_id := NULL;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: x_error_message_code := 'PA_ASGN_NUMBER_INV_AMBIGOUS';
491: WHEN OTHERS THEN
492: -- 4537865 : Start : RESET OUT PARAMS to proper values
493: x_error_message_code := SQLCODE;

Line 499: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

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;
502: END Check_Assignment_Number_Or_Id;
503:

Line 513: IF p_staffing_priority_code IS NOT NULL AND p_staffing_priority_code<>FND_API.G_MISS_CHAR THEN

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
516: INTO x_staffing_priority_code
517: FROM pa_lookups

Line 532: x_return_status := FND_API.G_RET_STS_SUCCESS;

528: WHERE lookup_type = 'STAFFING_PRIORITY_CODE'
529: AND meaning = p_staffing_priority_name;
530: END IF;
531:
532: x_return_status := FND_API.G_RET_STS_SUCCESS;
533:
534: EXCEPTION
535: WHEN NO_DATA_FOUND THEN
536: x_return_status := FND_API.G_RET_STS_ERROR;

Line 536: x_return_status := FND_API.G_RET_STS_ERROR;

532: x_return_status := FND_API.G_RET_STS_SUCCESS;
533:
534: EXCEPTION
535: WHEN NO_DATA_FOUND THEN
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: x_error_message_code := 'PA_STF_PRIORITY_INVALID';
538: WHEN TOO_MANY_ROWS THEN
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: x_error_message_code := 'PA_STF_PRIORITY_INVALID';

Line 539: x_return_status := FND_API.G_RET_STS_ERROR;

535: WHEN NO_DATA_FOUND THEN
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: x_error_message_code := 'PA_STF_PRIORITY_INVALID';
538: WHEN TOO_MANY_ROWS THEN
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: x_error_message_code := 'PA_STF_PRIORITY_INVALID';
541: WHEN OTHERS THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
543: -- 4537865 : Start

Line 542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

538: WHEN TOO_MANY_ROWS THEN
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: x_error_message_code := 'PA_STF_PRIORITY_INVALID';
541: WHEN OTHERS THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
543: -- 4537865 : Start
544: x_staffing_priority_code := p_staffing_priority_code ;
545: x_error_message_code := SQLCODE ;
546: -- 4537865 : End

Line 872: x_return_status := FND_API.G_RET_STS_SUCCESS;

868: ORDER BY assignment_start_date DESC;
869:
870: BEGIN
871:
872: x_return_status := FND_API.G_RET_STS_SUCCESS;
873: --dbms_output.put_line ('Assignment Name is ' || x_assignment_name);
874:
875: IF x_assignment_name IS NOT NULL AND x_assignment_name <> FND_API.G_MISS_CHAR THEN
876:

Line 875: IF x_assignment_name IS NOT NULL AND x_assignment_name <> FND_API.G_MISS_CHAR THEN

871:
872: x_return_status := FND_API.G_RET_STS_SUCCESS;
873: --dbms_output.put_line ('Assignment Name is ' || x_assignment_name);
874:
875: IF x_assignment_name IS NOT NULL AND x_assignment_name <> FND_API.G_MISS_CHAR THEN
876:
877: IF p_person_id = g_person_id_w_name AND p_project_id = g_project_id_w_name AND p_ei_date = g_ei_date_w_name AND x_assignment_name = g_in_asgmt_name THEN
878: l_found := TRUE;
879: --x_assignment_name := x_assignment_name;

Line 950: x_return_status := FND_API.G_RET_STS_SUCCESS;

946: x_assignment_name := l_assignment_name;
947: END IF;
948: END IF;
949:
950: x_return_status := FND_API.G_RET_STS_SUCCESS;
951:
952: EXCEPTION
953:
954: WHEN NO_DATA_FOUND THEN

Line 957: x_return_status := FND_API.G_RET_STS_ERROR;

953:
954: WHEN NO_DATA_FOUND THEN
955: x_assignment_id := NULL;
956: x_assignment_name := NULL;
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: x_error_message_code := 'PA_NO_ASSIGNMENT';
959: WHEN OTHERS THEN
960: x_assignment_id := NULL;
961: x_assignment_name := NULL;

Line 962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

958: x_error_message_code := 'PA_NO_ASSIGNMENT';
959: WHEN OTHERS THEN
960: x_assignment_id := NULL;
961: x_assignment_name := NULL;
962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
963: RAISE;
964: END Get_Person_Asgmt;
965:
966: ------------------------------------------------------------------------------------

Line 1250: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;

1246: l_person_type_tbl var30_table_type;
1247: l_assignment_name_tbl var80_table_type;
1248:
1249:
1250: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
1251:
1252: cursor get_proj_rec_ver_num is
1253: select record_version_number
1254: from pa_projects_all

Line 1374: x_return_status := FND_API.G_RET_STS_ERROR;

1370:
1371: IF l_team_role_exists = 'T' THEN
1372: PA_UTILS.Add_Message(p_app_short_name => 'PA',
1373: p_msg_name => 'PA_NO_UP_RL_TR');
1374: x_return_status := FND_API.G_RET_STS_ERROR;
1375: RETURN;
1376: END IF;
1377: */
1378: IF p_new_resource_list_id is not null THEN

Line 1394: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1390: 'req_format_id='||l_req_res_format_id
1391: ,x_log_level => li_message_level);
1392: END IF;
1393:
1394: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1395: x_return_status := l_return_status;
1396: RETURN;
1397: END IF;
1398:

Line 1411: ( p_init_msg_list => FND_API.G_FALSE

1407: CLOSE get_proj_rec_ver_num;
1408:
1409: -- store default formats
1410: pa_resource_setup_pvt.UPDATE_ADDITIONAL_STAFF_INFO
1411: ( p_init_msg_list => FND_API.G_FALSE
1412: ,p_validate_only => FND_API.G_FALSE
1413: ,p_project_id => p_project_id
1414: ,p_record_version_number => l_proj_rec_ver_num
1415: ,p_proj_req_res_format_id => l_req_res_format_id

Line 1412: ,p_validate_only => FND_API.G_FALSE

1408:
1409: -- store default formats
1410: pa_resource_setup_pvt.UPDATE_ADDITIONAL_STAFF_INFO
1411: ( p_init_msg_list => FND_API.G_FALSE
1412: ,p_validate_only => FND_API.G_FALSE
1413: ,p_project_id => p_project_id
1414: ,p_record_version_number => l_proj_rec_ver_num
1415: ,p_proj_req_res_format_id => l_req_res_format_id
1416: ,p_proj_asgmt_res_format_id => l_asgmt_res_format_id

Line 1421: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1417: ,x_return_status => l_return_status
1418: ,x_msg_count => x_msg_count
1419: ,x_msg_data => x_msg_data );
1420:
1421: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1422: x_return_status := l_return_status;
1423: RETURN;
1424: END IF;
1425:

Line 1523: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1519:
1520: x_msg_count := FND_MSG_PUB.Count_Msg;
1521:
1522: IF x_msg_count = 1 THEN
1523: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1524: ,p_msg_index => 1
1525: ,p_data => x_msg_data
1526: ,p_msg_index_out => l_msg_index_out
1527: );

Line 1532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1528: END IF;
1529: -- 4537865 : Included Exception block
1530: EXCEPTION
1531: WHEN OTHERS THEN
1532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1533: x_msg_count := 1 ;
1534: x_msg_data := SUBSTRB(SQLERRM,1,240);
1535:
1536: Fnd_Msg_Pub.add_exc_msg