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.30 2010/10/31 20:36:40 nisinha 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 311: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.check_exp_OU');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1504: --dbms_output.put_line('Calling Update_OU_resource');
1505: --dbms_output.put_line('End date for OU:' || p_default_OU_new || 'end date:' || P_end_date_new);
1506:
1507: -- Initialize the Error stack
1508: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_OU_resource');
1509: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1510:
1511: FOR rec IN res_denorm_recs LOOP
1512:

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

1548: WHEN OTHERS THEN -- Set the exception Message and the stack
1549: -- 4537865 : RESET x_msg_count and x_msg_data also
1550: x_msg_count := 1 ;
1551: x_msg_data := SUBSTRB(SQLERRM ,1,240);
1552: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_OU_resource'
1553: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1555: raise;
1556: END Update_OU_resource;

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

1621:
1622: BEGIN
1623:
1624: -- Initialize the Error stack
1625: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Default_OU_Change');
1626: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1627: -- for each resource found for the default ou changes update
1628: -- pa resource ou entity with new default OU
1629:

Line 1655: pa_hr_update_api.check_exp_OU

1651: PA_DEBUG.Reset_Err_Stack;
1652: Return;
1653: End if;
1654:
1655: pa_hr_update_api.check_exp_OU
1656: (p_org_id => v_default_OU
1657: ,x_return_status => v_return_status
1658: ,x_error_message_code => v_error_message_code
1659: );

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

1860: -- 4537865 : RESET x_msg_count and x_msg_data also
1861: x_msg_count := 1 ;
1862: x_msg_data := SUBSTRB(SQLERRM ,1,240);
1863: -- Set the exception Message and the stack
1864: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Default_OU_Change'
1865: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1867: raise;
1868:

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

1904:
1905: BEGIN
1906:
1907: -- Initialize the Error stack
1908: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Proj_Res_Job_Group_Change');
1909: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1910:
1911: l_proj_job_group_old := TO_NUMBER(p_proj_job_group_old);
1912: l_proj_job_group_new := TO_NUMBER(p_proj_job_group_new);

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

2043: -- 4537865 : RESET x_msg_count and x_msg_data also
2044: x_msg_count := 1 ;
2045: x_msg_data := SUBSTRB(SQLERRM ,1,240);
2046: -- Set the exception Message and the stack
2047: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Proj_Res_Job_Group_Change'
2048: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2050: raise;
2051:

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

2087: ORDER BY ind.person_id;
2088:
2089: BEGIN
2090: -- Initialize the Error stack
2091: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.pull_resources');
2092: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2093:
2094: open get_all_resource(p_organization_id);
2095: LOOP

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

2148: -- 4537865 : RESET x_msg_count and x_msg_data also
2149: x_msg_count := 1 ;
2150: x_msg_data := SUBSTRB(SQLERRM ,1,240);
2151: -- Set the exception Message and the stack
2152: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.pull_resources'
2153: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2154:
2155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2156: raise;

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

2291: AND rownum = 1 );
2292:
2293: BEGIN
2294: -- Initialize the Error stack
2295: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.make_resource_inactive');
2296: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2297:
2298: --dbms_output.put_line('Inside make resource inactive');
2299: --dbms_output.put_line('Default OU:' || p_default_ou);

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

2367: -- 4537865 : RESET x_msg_count and x_msg_data also
2368: x_msg_count := 1 ;
2369: x_msg_data := SUBSTRB(SQLERRM ,1,240);
2370: -- Set the exception Message and the stack
2371: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.make_resource_inactive'
2372: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2374: raise;
2375:

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

2481:
2482:
2483: BEGIN
2484: -- Initialize the Error stack
2485: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.call_forcast_api');
2486: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2487:
2488: If (P_table_name = 'PER_JOB_EXTRA_INFO' or
2489: P_table_name = 'PER_VALID_GRADES' or

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

2577: -- 4537865 : RESET x_msg_count and x_msg_data also
2578: x_msg_count := 1 ;
2579: x_msg_data := SUBSTRB(SQLERRM ,1,240);
2580: -- Set the exception Message and the stack
2581: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.call_forcast_api'
2582: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2584: raise;
2585:

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

2620:
2621: BEGIN
2622:
2623: -- Initialize the Error stack
2624: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.call_billable_resoruce_denorm');
2625: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2626: v_job_id_new := P_job_id_new;
2627: v_job_id_old := P_job_id_old;
2628:

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

2694: -- 4537865 : RESET x_msg_count and x_msg_data also
2695: x_msg_count := 1 ;
2696: x_msg_data := SUBSTRB(SQLERRM ,1,240);
2697: -- Set the exception Message and the stack
2698: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.call_billable_resoruce_denorm'
2699: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2701: raise;
2702:

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

2763: WHERE res.job_id = p_job_id;
2764:
2765: BEGIN
2766: -- Initialize the Error stack
2767: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_job_extra_billability');
2768: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2769:
2770: IF P_DEBUG_MODE = 'Y' THEN
2771: log_message('beginning of per_job_extra_billability, P_calling_mode:'|| P_calling_mode || ', job_id: '||P_job_id);

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

3019: -- 4537865 : RESET x_msg_count and x_msg_data also
3020: x_msg_count := 1 ;
3021: x_msg_data := SUBSTRB(SQLERRM ,1,240);
3022: -- Set the exception Message and the stack
3023: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.per_job_extra_billability'
3024: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3026: RAISE;
3027: END per_job_extra_billability;

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

3071:
3072: BEGIN
3073:
3074: -- Initialize the Error stack
3075: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.withdraw_cand_nominations');
3076: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3077:
3078: l_resource_id := PA_RESOURCE_UTILS.get_resource_id(p_person_id);
3079:

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

3167: -- 4537865 : RESET x_msg_count and x_msg_data also
3168: x_msg_count := 1 ;
3169: x_msg_data := SUBSTRB(SQLERRM ,1,240);
3170: -- Set the exception Message and the stack
3171: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.withdraw_cand_nominations'
3172: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3174: raise;
3175: END withdraw_cand_nominations;

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

3241: --dbms_output.put_line('Person Id:' || p_person_id);
3242: --dbms_output.put_line('New End Date:' || p_new_end_date);
3243:
3244: -- Initialize the Error stack
3245: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_EndDate');
3246: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3247:
3248: l_count := 0; -- bug 7147575 : None records in pa_resources_denorm so far.
3249:

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

3437: -- 4537865 : RESET x_msg_count and x_msg_data also
3438: x_msg_count := 1 ;
3439: x_msg_data := SUBSTRB(SQLERRM ,1,240);
3440: -- Set the exception Message and the stack
3441: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_EndDate'
3442: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3444: raise;
3445: END Update_EndDate;

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

3491:
3492: --dbms_output.put_line('Inside Update Org');
3493:
3494: -- Initialize the Error stack
3495: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Org');
3496:
3497: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3498:
3499: /* Check if new organization belongs to an expenditure

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

3649: -- 4537865 : RESET x_msg_count and x_msg_data also
3650: x_msg_count := 1 ;
3651: x_msg_data := SUBSTRB(SQLERRM ,1,240);
3652: -- Set the exception Message and the stack
3653: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_Org'
3654: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3656: raise;
3657: END Update_Org;

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

3824: --Bug 9047714 End
3825:
3826: BEGIN
3827: -- Initialize the Error stack
3828: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Job');
3829: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3830: IF P_DEBUG_MODE = 'Y' THEN
3831: log_message('beginning of Update_Job');
3832: END IF;

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

3979: -- 4537865 : RESET x_msg_count and x_msg_data also
3980: x_msg_count := 1 ;
3981: x_msg_data := SUBSTRB(SQLERRM ,1,240);
3982: -- Set the exception Message and the stack
3983: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_Job'
3984: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3986: RAISE;
3987: END Update_Job;

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

4023:
4024: BEGIN
4025:
4026: -- Initialize the Error stack
4027: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Supervisor');
4028: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4029:
4030: --Set the values for the Resources Denorm Record Type
4031: l_resource_rec_old.person_id := p_person_id;

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

4065: -- 4537865 : RESET x_msg_count and x_msg_data also
4066: x_msg_count := 1 ;
4067: x_msg_data := SUBSTRB(SQLERRM ,1,240);
4068: -- Set the exception Message and the stack
4069: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_Supervisor'
4070: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4072: raise;
4073: END Update_Supervisor;

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

4090: l_return_status VARCHAR2(1);
4091:
4092: BEGIN
4093: -- Initialize the Error stack
4094: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_PrimaryFlag');
4095: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4096:
4097: --Call Update_EndDate to end date the resource_ou record.
4098: -- Commented the end date change in PA as this is not required

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

4132: -- 4537865 : RESET x_msg_count and x_msg_data also
4133: x_msg_count := 1 ;
4134: x_msg_data := SUBSTRB(SQLERRM ,1,240);
4135: -- Set the exception Message and the stack
4136: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_PrimaryFlag'
4137: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4139: raise;
4140: END Update_PrimaryFlag;

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

4156: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4157: BEGIN
4158:
4159: --Initialize the Error stack
4160: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Name');
4161: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4162:
4163: --Get resource_id for person_id
4164: l_resource_id := pa_resource_utils.get_resource_id(p_person_id);

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

4199: -- 4537865 : RESET x_msg_count and x_msg_data also
4200: x_msg_count := 1 ;
4201: x_msg_data := SUBSTRB(SQLERRM ,1,240);
4202: -- Set the exception Message and the stack
4203: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Update_Name'
4204: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4206: raise;
4207: END Update_Name;

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

4379: ;
4380:
4381: BEGIN
4382: -- Initialize the Error stack
4383: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Delete_PA_Resource_Denorm');
4384: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4385:
4386: FOR rec IN res_denorm_recs LOOP
4387: --Delete the record

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

4403: -- 4537865 : RESET x_msg_count and x_msg_data also
4404: x_msg_count := 1 ;
4405: x_msg_data := SUBSTRB(SQLERRM ,1,240);
4406: -- Set the exception Message and the stack
4407: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.Delete_PA_Resource_Denorm'
4408: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4410: raise;
4411: END Delete_PA_Resource_Denorm;

Line 4413: END PA_HR_UPDATE_API;

4409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4410: raise;
4411: END Delete_PA_Resource_Denorm;
4412:
4413: END PA_HR_UPDATE_API;