APPS.PA_RESOURCE_SETUP_PUB dependencies on PA_RESOURCE_SETUP_PUB

Line 1: PACKAGE BODY PA_RESOURCE_SETUP_PUB AS

1: PACKAGE BODY PA_RESOURCE_SETUP_PUB AS
2: /* $Header: PARESTPB.pls 120.2 2006/06/30 21:50:31 ramurthy noship $ */
3:
4:
5: -- API name : update_addition_staff_info

Line 53: pa_debug.init_err_stack('PA_RESOURCE_SETUP_PUB.update_addition_staff_info');

49: SAVEPOINT update_addition_staff_info;
50: END IF;
51:
52: IF l_debug_mode = 'Y' THEN
53: pa_debug.init_err_stack('PA_RESOURCE_SETUP_PUB.update_addition_staff_info');
54: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_RESOURCE_SETUP_PUB.update_addition_staff_info.begin'
55: ,x_msg => 'Beginning of PA_RESOURCE_SETUP_PUB.update_addition_staff_info'
56: ,x_log_level => 5);
57: END IF;

Line 54: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_RESOURCE_SETUP_PUB.update_addition_staff_info.begin'

50: END IF;
51:
52: IF l_debug_mode = 'Y' THEN
53: pa_debug.init_err_stack('PA_RESOURCE_SETUP_PUB.update_addition_staff_info');
54: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_RESOURCE_SETUP_PUB.update_addition_staff_info.begin'
55: ,x_msg => 'Beginning of PA_RESOURCE_SETUP_PUB.update_addition_staff_info'
56: ,x_log_level => 5);
57: END IF;
58:

Line 55: ,x_msg => 'Beginning of PA_RESOURCE_SETUP_PUB.update_addition_staff_info'

51:
52: IF l_debug_mode = 'Y' THEN
53: pa_debug.init_err_stack('PA_RESOURCE_SETUP_PUB.update_addition_staff_info');
54: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_RESOURCE_SETUP_PUB.update_addition_staff_info.begin'
55: ,x_msg => 'Beginning of PA_RESOURCE_SETUP_PUB.update_addition_staff_info'
56: ,x_log_level => 5);
57: END IF;
58:
59: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

Line 66: pa_debug.write(x_module => 'pa.plsql.PA_RESOURCE_SETUP_PUB.update_addition_staff_info'

62:
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64:
65: IF l_debug_mode = 'Y' THEN
66: pa_debug.write(x_module => 'pa.plsql.PA_RESOURCE_SETUP_PUB.update_addition_staff_info'
67: ,x_msg => 'adv_id='||p_adv_action_set_id||
68: ' adv_name='||p_adv_action_set_name||
69: ' req_format='||p_proj_req_res_format_id||
70: ' asgmt_format='||p_proj_asgmt_res_format_id

Line 173: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RESOURCE_SETUP_PUB',

169: IF p_commit = FND_API.G_TRUE THEN
170: ROLLBACK TO update_addition_staff_info;
171: END IF;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RESOURCE_SETUP_PUB',
174: p_procedure_name => 'UPDATE_ADDITIONAL_STAFF_INFO',
175: p_error_text => SUBSTRB(SQLERRM,1,240));
176:
177: raise;

Line 182: END PA_RESOURCE_SETUP_PUB;

178:
179: END UPDATE_ADDITIONAL_STAFF_INFO;
180:
181:
182: END PA_RESOURCE_SETUP_PUB;