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_HR_UPDATE_API dependencies on PA_HR_UPDATE_API

Line 1: PACKAGE BODY PA_HR_UPDATE_API AS

1: PACKAGE BODY PA_HR_UPDATE_API AS
2: -- $Header: PARHRUPB.pls 120.17.12010000.3 2008/11/07 09:03:22 kjai ship $
3:
4: --FUNCTION Get_Country_name(p_country_code VARCHAR2) RETURN VARCHAR2 ;
5:

Line 51: pa_hr_update_api.check_exp_OU(p_org_id => p_org_id

47: v_return_status varchar2(1000);
48: v_error_message_code varchar2(1000);
49: BEGIN
50:
51: pa_hr_update_api.check_exp_OU(p_org_id => p_org_id
52: ,x_return_status => v_return_status
53: ,x_error_message_code => v_error_message_code
54: );
55:

Line 308: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.check_exp_OU');

304: v_return_status VARCHAR2(1);
305: v_dummy VARCHAR2(1):= 'N';
306: BEGIN
307: -- Initialize the Error stack
308: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.check_exp_OU');
309: -- Initialize the error status
310: x_return_status := FND_API.G_RET_STS_SUCCESS;
311:
312: If p_org_id is NOT NULL then

Line 339: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.check_exp_OU'

335:
336:
337: WHEN OTHERS THEN
338: -- Set the exception Message and the stack
339: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.check_exp_OU'
340: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: -- 4537865 : RESET x_error_message_code also
343: x_error_message_code := SQLCODE ;

Line 375: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.call_create_resoruce_denorm');

371: v_msg_data VARCHAR2(2000);
372: v_msg_count NUMBER;
373: BEGIN
374: -- Initialize the Error stack
375: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.call_create_resoruce_denorm');
376: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
377: v_job_id_new := P_job_id_new;
378: v_job_level_new := P_job_level_new;
379: v_job_id_old := P_job_id_old;

Line 424: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_HR_UPDATE_API.call_create_resource_denorm'

420: x_msg_count := 1 ;
421: x_msg_data := SUBSTRB(SQLERRM ,1,240);
422:
423: -- Set the exception Message and the stack
424: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_HR_UPDATE_API.call_create_resource_denorm'
425: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
427: raise;
428:

Line 457: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.update_job_level_res_denorm');

453: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
454:
455: BEGIN
456: -- Initialize the Error stack
457: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.update_job_level_res_denorm');
458: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
459:
460: l_job_id_new := P_job_id_new;
461: l_job_level_new := P_job_level_new;

Line 498: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.update_job_level_res_denorm'

494: x_msg_count := 1 ;
495: x_msg_data := SUBSTRB(SQLERRM ,1,240);
496:
497: -- Set the exception Message and the stack
498: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.update_job_level_res_denorm'
499: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501: raise;
502:

Line 552: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.update_all_jobs');

548:
549: BEGIN
550:
551: -- Initialize the Error stack
552: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.update_all_jobs');
553: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
554:
555: l_job_id := P_job_id;
556:

Line 602: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.update_all_jobs'

598: x_msg_count := 1 ;
599: x_msg_data := SUBSTRB(SQLERRM ,1,240);
600:
601: -- Set the exception Message and the stack
602: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.update_all_jobs'
603: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
605: raise;
606:

Line 634: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.pa_job_relation_job_id');

630: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
631:
632: BEGIN
633: -- Initialize the Error stack
634: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.pa_job_relation_job_id');
635: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
636:
637: IF P_DEBUG_MODE = 'Y' THEN
638: log_message('P_from_job_id_old = ' || P_from_job_id_old);

Line 909: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.pa_job_relation_job_id'

905: x_msg_count := 1 ;
906: x_msg_data := SUBSTRB(SQLERRM ,1,240);
907:
908: -- Set the exception Message and the stack
909: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.pa_job_relation_job_id'
910: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
912: raise;
913:

Line 956: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.perform_job_updates');

952:
953: BEGIN
954:
955: -- Initialize the Error stack
956: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.perform_job_updates');
957: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
958: IF P_DEBUG_MODE = 'Y' THEN
959: log_message('**** Performing Job Level Updates ****');
960: END IF;

Line 1032: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API',

1028: -- 4537865 : RESET x_msg_count and x_msg_data also
1029: x_msg_count := 1 ;
1030: x_msg_data := SUBSTRB(SQLERRM ,1,240);
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1032: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API',
1033: p_procedure_name => 'perform_job_updates',
1034: p_error_text => x_msg_data );
1035: RAISE ;
1036: END perform_job_updates;

Line 1062: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.update_job_level_dff');

1058:
1059: BEGIN
1060:
1061: -- Initialize the Error stack
1062: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.update_job_level_dff');
1063: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1064:
1065: l_job_id := P_job_id;
1066: l_job_level_old := P_job_level_old;

Line 1145: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API',

1141: -- 4537865 : RESET x_msg_count and x_msg_data also
1142: x_msg_count := 1 ;
1143: x_msg_data := SUBSTRB(SQLERRM ,1,240);
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API',
1146: p_procedure_name => 'update_job_level_dff',
1147: p_error_text => x_msg_data );
1148: RAISE ;
1149: END update_job_level_dff;

Line 1209: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_valid_grades_job_id');

1205: );
1206: BEGIN
1207:
1208: -- Initialize the Error stack
1209: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_valid_grades_job_id');
1210: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1211:
1212: -- if the grade id changes then update all the jobs which are affected and
1213: -- call PA_RESOURCE_PVT.UPDATE_RESOURCE_DENORM API to update the resource_denorm_table

Line 1251: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.per_valid_grades_job_id'

1247: -- 4537865 : RESET x_msg_count and x_msg_data also
1248: x_msg_count := 1 ;
1249: x_msg_data := SUBSTRB(SQLERRM ,1,240);
1250: -- Set the exception Message and the stack
1251: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.per_valid_grades_job_id'
1252: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1254: raise;
1255:

Line 1322: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_grades_job_id');

1318: BEGIN
1319:
1320:
1321: -- Initialize the Error stack
1322: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_grades_job_id');
1323: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1324:
1325: -- if the sequence is changes then update all the jobs which are affected due to
1326: -- call PA_RESOURCE_PVT.UPDATE_RESOURCE_DENORM API to update the resource_denorm_table

Line 1362: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.per_grades_job_id'

1358: -- 4537865 : RESET x_msg_count and x_msg_data also
1359: x_msg_count := 1 ;
1360: x_msg_data := SUBSTRB(SQLERRM ,1,240);
1361: -- Set the exception Message and the stack
1362: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.per_grades_job_id'
1363: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1365: raise;
1366:

Line 1411: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_job_levels');

1407: v_msg_count NUMBER;
1408:
1409: BEGIN
1410: -- Initialize the Error stack
1411: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_job_levels');
1412: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1413:
1414: -- Code for if job mapping has changed
1415:

Line 1447: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_job_levels'

1443: x_msg_count := 1 ;
1444: x_msg_data := SUBSTRB(SQLERRM ,1,240);
1445:
1446: -- Set the exception Message and the stack
1447: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_job_levels'
1448: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1450: raise;
1451:

Line 1501: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_OU_resource');

1497: --dbms_output.put_line('Calling Update_OU_resource');
1498: --dbms_output.put_line('End date for OU:' || p_default_OU_new || 'end date:' || P_end_date_new);
1499:
1500: -- Initialize the Error stack
1501: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_OU_resource');
1502: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1503:
1504: FOR rec IN res_denorm_recs LOOP
1505:

Line 1545: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_OU_resource'

1541: WHEN OTHERS THEN -- Set the exception Message and the stack
1542: -- 4537865 : RESET x_msg_count and x_msg_data also
1543: x_msg_count := 1 ;
1544: x_msg_data := SUBSTRB(SQLERRM ,1,240);
1545: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_OU_resource'
1546: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1548: raise;
1549: END Update_OU_resource;

Line 1618: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Default_OU_Change');

1614:
1615: BEGIN
1616:
1617: -- Initialize the Error stack
1618: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Default_OU_Change');
1619: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1620: -- for each resource found for the default ou changes update
1621: -- pa resource ou entity with new default OU
1622:

Line 1648: pa_hr_update_api.check_exp_OU

1644: PA_DEBUG.Reset_Err_Stack;
1645: Return;
1646: End if;
1647:
1648: pa_hr_update_api.check_exp_OU
1649: (p_org_id => v_default_OU
1650: ,x_return_status => v_return_status
1651: ,x_error_message_code => v_error_message_code
1652: );

Line 1857: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Default_OU_Change'

1853: -- 4537865 : RESET x_msg_count and x_msg_data also
1854: x_msg_count := 1 ;
1855: x_msg_data := SUBSTRB(SQLERRM ,1,240);
1856: -- Set the exception Message and the stack
1857: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Default_OU_Change'
1858: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1860: raise;
1861:

Line 1901: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Proj_Res_Job_Group_Change');

1897:
1898: BEGIN
1899:
1900: -- Initialize the Error stack
1901: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Proj_Res_Job_Group_Change');
1902: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1903:
1904: l_proj_job_group_old := TO_NUMBER(p_proj_job_group_old);
1905: l_proj_job_group_new := TO_NUMBER(p_proj_job_group_new);

Line 2040: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Proj_Res_Job_Group_Change'

2036: -- 4537865 : RESET x_msg_count and x_msg_data also
2037: x_msg_count := 1 ;
2038: x_msg_data := SUBSTRB(SQLERRM ,1,240);
2039: -- Set the exception Message and the stack
2040: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Proj_Res_Job_Group_Change'
2041: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2043: raise;
2044:

Line 2084: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.pull_resources');

2080: ORDER BY ind.person_id;
2081:
2082: BEGIN
2083: -- Initialize the Error stack
2084: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.pull_resources');
2085: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2086:
2087: open get_all_resource(p_organization_id);
2088: LOOP

Line 2145: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.pull_resources'

2141: -- 4537865 : RESET x_msg_count and x_msg_data also
2142: x_msg_count := 1 ;
2143: x_msg_data := SUBSTRB(SQLERRM ,1,240);
2144: -- Set the exception Message and the stack
2145: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.pull_resources'
2146: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2147:
2148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2149: raise;

Line 2288: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.make_resource_inactive');

2284: AND rownum = 1 );
2285:
2286: BEGIN
2287: -- Initialize the Error stack
2288: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.make_resource_inactive');
2289: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2290:
2291: --dbms_output.put_line('Inside make resource inactive');
2292: --dbms_output.put_line('Default OU:' || p_default_ou);

Line 2364: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.make_resource_inactive'

2360: -- 4537865 : RESET x_msg_count and x_msg_data also
2361: x_msg_count := 1 ;
2362: x_msg_data := SUBSTRB(SQLERRM ,1,240);
2363: -- Set the exception Message and the stack
2364: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.make_resource_inactive'
2365: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2367: raise;
2368:

Line 2478: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.call_forcast_api');

2474:
2475:
2476: BEGIN
2477: -- Initialize the Error stack
2478: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.call_forcast_api');
2479: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2480:
2481: If (P_table_name = 'PER_JOB_EXTRA_INFO' or
2482: P_table_name = 'PER_VALID_GRADES' or

Line 2574: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.call_forcast_api'

2570: -- 4537865 : RESET x_msg_count and x_msg_data also
2571: x_msg_count := 1 ;
2572: x_msg_data := SUBSTRB(SQLERRM ,1,240);
2573: -- Set the exception Message and the stack
2574: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.call_forcast_api'
2575: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2577: raise;
2578:

Line 2617: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.call_billable_resoruce_denorm');

2613:
2614: BEGIN
2615:
2616: -- Initialize the Error stack
2617: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.call_billable_resoruce_denorm');
2618: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2619: v_job_id_new := P_job_id_new;
2620: v_job_id_old := P_job_id_old;
2621:

Line 2691: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.call_billable_resoruce_denorm'

2687: -- 4537865 : RESET x_msg_count and x_msg_data also
2688: x_msg_count := 1 ;
2689: x_msg_data := SUBSTRB(SQLERRM ,1,240);
2690: -- Set the exception Message and the stack
2691: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.call_billable_resoruce_denorm'
2692: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2694: raise;
2695:

Line 2760: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_job_extra_billability');

2756: WHERE res.job_id = p_job_id;
2757:
2758: BEGIN
2759: -- Initialize the Error stack
2760: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_job_extra_billability');
2761: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2762:
2763: IF P_DEBUG_MODE = 'Y' THEN
2764: log_message('beginning of per_job_extra_billability, P_calling_mode:'|| P_calling_mode || ', job_id: '||P_job_id);

Line 3016: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.per_job_extra_billability'

3012: -- 4537865 : RESET x_msg_count and x_msg_data also
3013: x_msg_count := 1 ;
3014: x_msg_data := SUBSTRB(SQLERRM ,1,240);
3015: -- Set the exception Message and the stack
3016: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.per_job_extra_billability'
3017: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3019: RAISE;
3020: END per_job_extra_billability;

Line 3066: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.withdraw_cand_nominations');

3062:
3063: BEGIN
3064:
3065: -- Initialize the Error stack
3066: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.withdraw_cand_nominations');
3067: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3068:
3069: l_resource_id := PA_RESOURCE_UTILS.get_resource_id(p_person_id);
3070:

Line 3145: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.withdraw_cand_nominations'

3141: -- 4537865 : RESET x_msg_count and x_msg_data also
3142: x_msg_count := 1 ;
3143: x_msg_data := SUBSTRB(SQLERRM ,1,240);
3144: -- Set the exception Message and the stack
3145: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.withdraw_cand_nominations'
3146: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3148: raise;
3149: END withdraw_cand_nominations;

Line 3196: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_EndDate');

3192: --dbms_output.put_line('Person Id:' || p_person_id);
3193: --dbms_output.put_line('New End Date:' || p_new_end_date);
3194:
3195: -- Initialize the Error stack
3196: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_EndDate');
3197: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3198:
3199: l_count := 0; -- bug 7147575 : None records in pa_resources_denorm so far.
3200:

Line 3321: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_EndDate'

3317: -- 4537865 : RESET x_msg_count and x_msg_data also
3318: x_msg_count := 1 ;
3319: x_msg_data := SUBSTRB(SQLERRM ,1,240);
3320: -- Set the exception Message and the stack
3321: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_EndDate'
3322: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3324: raise;
3325: END Update_EndDate;

Line 3375: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Org');

3371:
3372: --dbms_output.put_line('Inside Update Org');
3373:
3374: -- Initialize the Error stack
3375: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Org');
3376:
3377: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3378:
3379: /* Check if new organization belongs to an expenditure

Line 3532: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_Org'

3528: -- 4537865 : RESET x_msg_count and x_msg_data also
3529: x_msg_count := 1 ;
3530: x_msg_data := SUBSTRB(SQLERRM ,1,240);
3531: -- Set the exception Message and the stack
3532: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_Org'
3533: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3535: raise;
3536: END Update_Org;

Line 3694: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Job');

3690: GROUP BY person_id;
3691:
3692: BEGIN
3693: -- Initialize the Error stack
3694: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Job');
3695: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3696: IF P_DEBUG_MODE = 'Y' THEN
3697: log_message('beginning of Update_Job');
3698: END IF;

Line 3847: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_Job'

3843: -- 4537865 : RESET x_msg_count and x_msg_data also
3844: x_msg_count := 1 ;
3845: x_msg_data := SUBSTRB(SQLERRM ,1,240);
3846: -- Set the exception Message and the stack
3847: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_Job'
3848: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3850: RAISE;
3851: END Update_Job;

Line 3891: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Supervisor');

3887:
3888: BEGIN
3889:
3890: -- Initialize the Error stack
3891: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Supervisor');
3892: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3893:
3894: --Set the values for the Resources Denorm Record Type
3895: l_resource_rec_old.person_id := p_person_id;

Line 3933: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_Supervisor'

3929: -- 4537865 : RESET x_msg_count and x_msg_data also
3930: x_msg_count := 1 ;
3931: x_msg_data := SUBSTRB(SQLERRM ,1,240);
3932: -- Set the exception Message and the stack
3933: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_Supervisor'
3934: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3936: raise;
3937: END Update_Supervisor;

Line 3958: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_PrimaryFlag');

3954: l_return_status VARCHAR2(1);
3955:
3956: BEGIN
3957: -- Initialize the Error stack
3958: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_PrimaryFlag');
3959: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3960:
3961: --Call Update_EndDate to end date the resource_ou record.
3962: -- Commented the end date change in PA as this is not required

Line 3997: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_PrimaryFlag'

3993: -- 4537865 : RESET x_msg_count and x_msg_data also
3994: x_msg_count := 1 ;
3995: x_msg_data := SUBSTRB(SQLERRM ,1,240);
3996: -- Set the exception Message and the stack
3997: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_PrimaryFlag'
3998: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4000: raise;
4001: END Update_PrimaryFlag;

Line 4021: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Name');

4017: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4018: BEGIN
4019:
4020: --Initialize the Error stack
4021: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Name');
4022: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4023:
4024: --Get resource_id for person_id
4025: l_resource_id := pa_resource_utils.get_resource_id(p_person_id);

Line 4064: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_Name'

4060: -- 4537865 : RESET x_msg_count and x_msg_data also
4061: x_msg_count := 1 ;
4062: x_msg_data := SUBSTRB(SQLERRM ,1,240);
4063: -- Set the exception Message and the stack
4064: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_Name'
4065: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4067: raise;
4068: END Update_Name;

Line 4244: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Delete_PA_Resource_Denorm');

4240: ;
4241:
4242: BEGIN
4243: -- Initialize the Error stack
4244: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Delete_PA_Resource_Denorm');
4245: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4246:
4247: FOR rec IN res_denorm_recs LOOP
4248: --Delete the record

Line 4268: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Delete_PA_Resource_Denorm'

4264: -- 4537865 : RESET x_msg_count and x_msg_data also
4265: x_msg_count := 1 ;
4266: x_msg_data := SUBSTRB(SQLERRM ,1,240);
4267: -- Set the exception Message and the stack
4268: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Delete_PA_Resource_Denorm'
4269: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4271: raise;
4272: END Delete_PA_Resource_Denorm;

Line 4274: END PA_HR_UPDATE_API;

4270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4271: raise;
4272: END Delete_PA_Resource_Denorm;
4273:
4274: END PA_HR_UPDATE_API;