DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PA_UTILS

Line 118: l_person_id := pa_utils.getempidfromuser(p_user_id);

114: p_project_id IN NUMBER) return VARCHAR2 is
115: l_person_id number;
116: x_val varchar2(1) := 'N';
117: BEGIN
118: l_person_id := pa_utils.getempidfromuser(p_user_id);
119:
120: select 'Y'
121: into x_val
122: from pa_project_parties

Line 2592: l_person_id := PA_UTILS.GetEmpIdFromUser(p_user_id);

2588: l_latest_pub_structure_ver_id NUMBER;
2589: l_element_version_id NUMBER;
2590: BEGIN
2591: l_is_task_manager := 'N';
2592: l_person_id := PA_UTILS.GetEmpIdFromUser(p_user_id);
2593:
2594: /*
2595: OPEN l_get_latest_pub_structure_ver;
2596: FETCH l_get_latest_pub_structure_ver INTO l_latest_pub_structure_ver_id;

Line 3219: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

3215: END IF;
3216:
3217: IF p_calling_mode = 'PLAN_RATES' AND (l_pc_conv = 'N' OR l_pfc_conv = 'N') THEN
3218: IF p_budget_version_id IS NULL OR p_res_assignment_id IS NULL THEN
3219: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3220: ,p_msg_name => 'PA_INV_PARAM_PASSED');
3221: x_msg_data := 'PA_INV_PARAM_PASSED';
3222: x_return_status := FND_API.G_RET_STS_ERROR;
3223: RAISE FND_API.G_EXC_ERROR;

Line 3274: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

3270: P_project_exch_rate := l_project_cost_exchange_rate;
3271: P_project_raw_cost := P_txn_cost * P_project_exch_rate;
3272:
3273: IF l_project_cost_exchange_rate IS NULL THEN
3274: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3275: ,p_msg_name => 'PA_FP_USER_EXCH_RATE_REQ');
3276: x_msg_data := 'PA_FP_USER_EXCH_RATE_REQ';
3277: x_return_status := FND_API.G_RET_STS_ERROR;
3278: RAISE FND_API.G_EXC_ERROR;

Line 3323: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

3319: P_projfunc_cost_exch_rate := l_projfunc_cost_exchange_rate;
3320: P_projfunc_raw_cost := P_txn_cost * P_projfunc_cost_exch_rate;
3321:
3322: IF l_projfunc_cost_exchange_rate IS NULL THEN
3323: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3324: ,p_msg_name => 'PA_FP_USER_EXCH_RATE_REQ');
3325: x_msg_data := 'PA_FP_USER_EXCH_RATE_REQ';
3326: x_return_status := FND_API.G_RET_STS_ERROR;
3327: RAISE FND_API.G_EXC_ERROR;

Line 3374: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

3370: P_project_exch_rate := l_project_cost_exchange_rate;
3371: P_project_raw_cost := P_txn_cost * P_project_exch_rate;
3372:
3373: IF l_project_cost_exchange_rate IS NULL THEN
3374: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3375: ,p_msg_name => 'PA_FP_USER_EXCH_RATE_REQ');
3376: x_msg_data := 'PA_FP_USER_EXCH_RATE_REQ';
3377: x_return_status := FND_API.G_RET_STS_ERROR;
3378: RAISE FND_API.G_EXC_ERROR;

Line 3417: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

3413: P_projfunc_cost_exch_rate := l_projfunc_cost_exchange_rate;
3414: P_projfunc_raw_cost := P_txn_cost * P_projfunc_cost_exch_rate;
3415:
3416: IF l_projfunc_cost_exchange_rate IS NULL THEN
3417: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3418: ,p_msg_name => 'PA_FP_USER_EXCH_RATE_REQ');
3419: x_msg_data := 'PA_FP_USER_EXCH_RATE_REQ';
3420: x_return_status := FND_API.G_RET_STS_ERROR;
3421: RAISE FND_API.G_EXC_ERROR;

Line 3532: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

3528:
3529: END;
3530: --bug 3828542 start
3531: IF ( l_status IS NOT NULL ) THEN
3532: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3533: ,p_msg_name => l_status);
3534: x_msg_data := l_status;
3535: l_return_status := 'E';
3536: END IF;

Line 5938: l_Period_Name := PA_UTILS2.get_pa_period_name (p_txn_date => p_Date,

5934: ELSE
5935: l_Org_ID := p_org_id;
5936: END IF;
5937:
5938: l_Period_Name := PA_UTILS2.get_pa_period_name (p_txn_date => p_Date,
5939: p_org_id => l_Org_ID );
5940:
5941: Return l_Period_Name;
5942: END Prog_Get_Pa_Period_Name;

Line 5959: l_Period_Name := PA_UTILS2.get_GL_period_name (p_gl_date => p_Date,

5955: ELSE
5956: l_Org_ID := p_org_id;
5957: END IF;
5958:
5959: l_Period_Name := PA_UTILS2.get_GL_period_name (p_gl_date => p_Date,
5960: p_org_id => l_Org_ID );
5961:
5962: Return l_Period_Name;
5963:

Line 7031: l_person_id := pa_utils.GetEmpIdFromUser( FND_GLOBAL.USER_ID );

7027: --l_labor_cost_flag := PA_SECURITY.view_labor_costs(p_project_id); /* Commented for Bug 3964394 */
7028:
7029: /* Start Bug 3964394 - Changed the function call from view_labor_costs to check_labor_cost_access */
7030: IF ( FND_GLOBAL.USER_ID IS NOT NULL ) THEN
7031: l_person_id := pa_utils.GetEmpIdFromUser( FND_GLOBAL.USER_ID );
7032: l_labor_cost_flag := PA_SECURITY.check_labor_cost_access(l_person_id, p_project_id);
7033: ELSE
7034: l_labor_cost_flag := 'N'; -- In case the user_id is null then don't show the region.
7035: END IF;

Line 7366: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

7362: x_msg_count := l_msg_count;
7363: x_msg_data := l_msg_data;
7364:
7365: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7366: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
7367: p_msg_name => l_msg_data);
7368: x_msg_data := l_msg_data;
7369: x_return_status := 'E';
7370: x_msg_count := l_msg_count;

Line 9108: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

9104: raise fnd_api.g_exc_error;
9105: END;
9106:
9107: IF l_return_status <> 'S' AND l_msg_data IS NOT NULL THEN
9108: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9109: p_msg_name => l_msg_data);
9110: x_msg_data := l_msg_data;
9111: x_return_status := 'E';
9112: x_msg_count := fnd_msg_pub.count_msg;

Line 9418: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

9414: -- FPM Dev CR 8 : Added error stack population
9415: -- It is subjected to change if values are coming from lookups.
9416: IF l_raw_cost_rejection_code IS NOT NULL AND l_raw_override_rate IS NULL --bug 3821299 do not throw error if there is override.
9417: THEN
9418: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9419: p_msg_name => l_raw_cost_rejection_code);
9420: x_msg_data := l_raw_cost_rejection_code;
9421: x_return_status := 'E';
9422: x_msg_count := fnd_msg_pub.count_msg;

Line 9428: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

9424: END IF;
9425:
9426: IF l_burden_cost_rejection_code IS NOT NULL AND l_burden_override_rate IS NULL --bug 3821299 do not throw error if there is override.
9427: THEN
9428: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9429: p_msg_name => l_burden_cost_rejection_code);
9430: x_msg_data := l_burden_cost_rejection_code;
9431: x_return_status := 'E';
9432: x_msg_count := fnd_msg_pub.count_msg;

Line 9499: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

9495:
9496: --maansari6/5
9497: IF l_return_status <> 'S' AND l_msg_data IS NOT NULL
9498: THEN
9499: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9500: p_msg_name => l_msg_data);
9501: x_msg_data := l_msg_data;
9502: x_return_status := 'E';
9503: x_msg_count := fnd_msg_pub.count_msg;

Line 9538: PA_UTILS.add_message('PA','PA_PROG_INSUFFICIENT_PARA',

9534: x_resource_burden_rate := NULL ;
9535: X_burden_multiplier := NULL ;
9536:
9537: WHEN l_insufficient_paramters THEN
9538: PA_UTILS.add_message('PA','PA_PROG_INSUFFICIENT_PARA',
9539: 'RES_NAME', l_resource_alias);
9540: x_return_status := FND_API.G_RET_STS_ERROR;
9541: x_msg_data := 'PA_PROG_INSUFFICIENT_PARA';
9542: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 10230: PA_UTILS.ADD_MESSAGE

10226: --that has a similar check.
10227: l_error_msg := substrb(l_error_msg,1,1700);
10228:
10229: IF p_context = 'PUBLISH_STRUCTURE' THEN
10230: PA_UTILS.ADD_MESSAGE
10231: (
10232: p_app_short_name => 'PA',
10233: p_msg_name => 'PA_PUB_MISM_CUR_ERR',
10234: p_token1 => 'PL_RES_LIST',

Line 10238: PA_UTILS.ADD_MESSAGE

10234: p_token1 => 'PL_RES_LIST',
10235: p_value1 => l_error_msg
10236: );
10237: ELSIF p_context = 'APPLY_PROGRESS' THEN
10238: PA_UTILS.ADD_MESSAGE
10239: (
10240: p_app_short_name => 'PA',
10241: p_msg_name => 'PA_APPLY_PROG_MISM_CUR_ERR',
10242: p_token1 => 'PL_RES_LIST',

Line 10465: PA_UTILS.ADD_MESSAGE

10461:
10462: x_return_status := FND_API.G_RET_STS_ERROR;
10463:
10464: IF l_viol_indicator = 1 THEN
10465: PA_UTILS.ADD_MESSAGE
10466: (
10467: p_app_short_name => 'PA',
10468: p_msg_name => 'PA_UP_TA_CUR_ERR',
10469: p_token1 => 'ACTUAL_CURRENCY',

Line 10473: PA_UTILS.ADD_MESSAGE

10469: p_token1 => 'ACTUAL_CURRENCY',
10470: p_value1 => l_actual_cur_tbl(k)
10471: );
10472: ELSIF l_viol_indicator = 2 OR l_viol_indicator = 3 THEN
10473: PA_UTILS.ADD_MESSAGE
10474: (
10475: p_app_short_name => 'PA',
10476: p_msg_name => 'PA_UP_TA_PL_RES_ERR'
10477: );

Line 10479: PA_UTILS.ADD_MESSAGE

10475: p_app_short_name => 'PA',
10476: p_msg_name => 'PA_UP_TA_PL_RES_ERR'
10477: );
10478: ELSIF l_viol_indicator = 4 THEN
10479: PA_UTILS.ADD_MESSAGE
10480: (
10481: p_app_short_name => 'PA',
10482: p_msg_name => 'PA_UP_TA_DECR_QTY_ERR'
10483: );

Line 10485: PA_UTILS.ADD_MESSAGE

10481: p_app_short_name => 'PA',
10482: p_msg_name => 'PA_UP_TA_DECR_QTY_ERR'
10483: );
10484: ELSIF l_viol_indicator = 6 OR l_viol_indicator = 7 THEN
10485: PA_UTILS.ADD_MESSAGE
10486: (
10487: p_app_short_name => 'PA',
10488: p_msg_name => 'PA_UP_TA_ASMT_END_ERR'
10489: );