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 2567: l_person_id := PA_UTILS.GetEmpIdFromUser(p_user_id);

2563: l_latest_pub_structure_ver_id NUMBER;
2564: l_element_version_id NUMBER;
2565: BEGIN
2566: l_is_task_manager := 'N';
2567: l_person_id := PA_UTILS.GetEmpIdFromUser(p_user_id);
2568:
2569: /*
2570: OPEN l_get_latest_pub_structure_ver;
2571: FETCH l_get_latest_pub_structure_ver INTO l_latest_pub_structure_ver_id;

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

3190: END IF;
3191:
3192: IF p_calling_mode = 'PLAN_RATES' AND (l_pc_conv = 'N' OR l_pfc_conv = 'N') THEN
3193: IF p_budget_version_id IS NULL OR p_res_assignment_id IS NULL THEN
3194: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3195: ,p_msg_name => 'PA_INV_PARAM_PASSED');
3196: x_msg_data := 'PA_INV_PARAM_PASSED';
3197: x_return_status := FND_API.G_RET_STS_ERROR;
3198: RAISE FND_API.G_EXC_ERROR;

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

3245: P_project_exch_rate := l_project_cost_exchange_rate;
3246: P_project_raw_cost := P_txn_cost * P_project_exch_rate;
3247:
3248: IF l_project_cost_exchange_rate IS NULL THEN
3249: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3250: ,p_msg_name => 'PA_FP_USER_EXCH_RATE_REQ');
3251: x_msg_data := 'PA_FP_USER_EXCH_RATE_REQ';
3252: x_return_status := FND_API.G_RET_STS_ERROR;
3253: RAISE FND_API.G_EXC_ERROR;

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

3294: P_projfunc_cost_exch_rate := l_projfunc_cost_exchange_rate;
3295: P_projfunc_raw_cost := P_txn_cost * P_projfunc_cost_exch_rate;
3296:
3297: IF l_projfunc_cost_exchange_rate IS NULL THEN
3298: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3299: ,p_msg_name => 'PA_FP_USER_EXCH_RATE_REQ');
3300: x_msg_data := 'PA_FP_USER_EXCH_RATE_REQ';
3301: x_return_status := FND_API.G_RET_STS_ERROR;
3302: RAISE FND_API.G_EXC_ERROR;

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

3345: P_project_exch_rate := l_project_cost_exchange_rate;
3346: P_project_raw_cost := P_txn_cost * P_project_exch_rate;
3347:
3348: IF l_project_cost_exchange_rate IS NULL THEN
3349: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3350: ,p_msg_name => 'PA_FP_USER_EXCH_RATE_REQ');
3351: x_msg_data := 'PA_FP_USER_EXCH_RATE_REQ';
3352: x_return_status := FND_API.G_RET_STS_ERROR;
3353: RAISE FND_API.G_EXC_ERROR;

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

3388: P_projfunc_cost_exch_rate := l_projfunc_cost_exchange_rate;
3389: P_projfunc_raw_cost := P_txn_cost * P_projfunc_cost_exch_rate;
3390:
3391: IF l_projfunc_cost_exchange_rate IS NULL THEN
3392: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3393: ,p_msg_name => 'PA_FP_USER_EXCH_RATE_REQ');
3394: x_msg_data := 'PA_FP_USER_EXCH_RATE_REQ';
3395: x_return_status := FND_API.G_RET_STS_ERROR;
3396: RAISE FND_API.G_EXC_ERROR;

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

3503:
3504: END;
3505: --bug 3828542 start
3506: IF ( l_status IS NOT NULL ) THEN
3507: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
3508: ,p_msg_name => l_status);
3509: x_msg_data := l_status;
3510: l_return_status := 'E';
3511: END IF;

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

5899: ELSE
5900: l_Org_ID := p_org_id;
5901: END IF;
5902:
5903: l_Period_Name := PA_UTILS2.get_pa_period_name (p_txn_date => p_Date,
5904: p_org_id => l_Org_ID );
5905:
5906: Return l_Period_Name;
5907: END Prog_Get_Pa_Period_Name;

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

5920: ELSE
5921: l_Org_ID := p_org_id;
5922: END IF;
5923:
5924: l_Period_Name := PA_UTILS2.get_GL_period_name (p_gl_date => p_Date,
5925: p_org_id => l_Org_ID );
5926:
5927: Return l_Period_Name;
5928:

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

6987: --l_labor_cost_flag := PA_SECURITY.view_labor_costs(p_project_id); /* Commented for Bug 3964394 */
6988:
6989: /* Start Bug 3964394 - Changed the function call from view_labor_costs to check_labor_cost_access */
6990: IF ( FND_GLOBAL.USER_ID IS NOT NULL ) THEN
6991: l_person_id := pa_utils.GetEmpIdFromUser( FND_GLOBAL.USER_ID );
6992: l_labor_cost_flag := PA_SECURITY.check_labor_cost_access(l_person_id, p_project_id);
6993: ELSE
6994: l_labor_cost_flag := 'N'; -- In case the user_id is null then don't show the region.
6995: END IF;

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

7322: x_msg_count := l_msg_count;
7323: x_msg_data := l_msg_data;
7324:
7325: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7326: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
7327: p_msg_name => l_msg_data);
7328: x_msg_data := l_msg_data;
7329: x_return_status := 'E';
7330: x_msg_count := l_msg_count;

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

9048: raise fnd_api.g_exc_error;
9049: END;
9050:
9051: IF l_return_status <> 'S' AND l_msg_data IS NOT NULL THEN
9052: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9053: p_msg_name => l_msg_data);
9054: x_msg_data := l_msg_data;
9055: x_return_status := 'E';
9056: x_msg_count := fnd_msg_pub.count_msg;

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

9340: -- FPM Dev CR 8 : Added error stack population
9341: -- It is subjected to change if values are coming from lookups.
9342: 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.
9343: THEN
9344: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9345: p_msg_name => l_raw_cost_rejection_code);
9346: x_msg_data := l_raw_cost_rejection_code;
9347: x_return_status := 'E';
9348: x_msg_count := fnd_msg_pub.count_msg;

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

9350: END IF;
9351:
9352: 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.
9353: THEN
9354: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9355: p_msg_name => l_burden_cost_rejection_code);
9356: x_msg_data := l_burden_cost_rejection_code;
9357: x_return_status := 'E';
9358: x_msg_count := fnd_msg_pub.count_msg;

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

9421:
9422: --maansari6/5
9423: IF l_return_status <> 'S' AND l_msg_data IS NOT NULL
9424: THEN
9425: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9426: p_msg_name => l_msg_data);
9427: x_msg_data := l_msg_data;
9428: x_return_status := 'E';
9429: x_msg_count := fnd_msg_pub.count_msg;

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

9460: x_resource_burden_rate := NULL ;
9461: X_burden_multiplier := NULL ;
9462:
9463: WHEN l_insufficient_paramters THEN
9464: PA_UTILS.add_message('PA','PA_PROG_INSUFFICIENT_PARA',
9465: 'RES_NAME', l_resource_alias);
9466: x_return_status := FND_API.G_RET_STS_ERROR;
9467: x_msg_data := 'PA_PROG_INSUFFICIENT_PARA';
9468: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 10156: PA_UTILS.ADD_MESSAGE

10152: --that has a similar check.
10153: l_error_msg := substrb(l_error_msg,1,1700);
10154:
10155: IF p_context = 'PUBLISH_STRUCTURE' THEN
10156: PA_UTILS.ADD_MESSAGE
10157: (
10158: p_app_short_name => 'PA',
10159: p_msg_name => 'PA_PUB_MISM_CUR_ERR',
10160: p_token1 => 'PL_RES_LIST',

Line 10164: PA_UTILS.ADD_MESSAGE

10160: p_token1 => 'PL_RES_LIST',
10161: p_value1 => l_error_msg
10162: );
10163: ELSIF p_context = 'APPLY_PROGRESS' THEN
10164: PA_UTILS.ADD_MESSAGE
10165: (
10166: p_app_short_name => 'PA',
10167: p_msg_name => 'PA_APPLY_PROG_MISM_CUR_ERR',
10168: p_token1 => 'PL_RES_LIST',

Line 10390: PA_UTILS.ADD_MESSAGE

10386:
10387: x_return_status := FND_API.G_RET_STS_ERROR;
10388:
10389: IF l_viol_indicator = 1 THEN
10390: PA_UTILS.ADD_MESSAGE
10391: (
10392: p_app_short_name => 'PA',
10393: p_msg_name => 'PA_UP_TA_CUR_ERR',
10394: p_token1 => 'ACTUAL_CURRENCY',

Line 10398: PA_UTILS.ADD_MESSAGE

10394: p_token1 => 'ACTUAL_CURRENCY',
10395: p_value1 => l_actual_cur_tbl(k)
10396: );
10397: ELSIF l_viol_indicator = 2 OR l_viol_indicator = 3 THEN
10398: PA_UTILS.ADD_MESSAGE
10399: (
10400: p_app_short_name => 'PA',
10401: p_msg_name => 'PA_UP_TA_PL_RES_ERR'
10402: );

Line 10404: PA_UTILS.ADD_MESSAGE

10400: p_app_short_name => 'PA',
10401: p_msg_name => 'PA_UP_TA_PL_RES_ERR'
10402: );
10403: ELSIF l_viol_indicator = 4 THEN
10404: PA_UTILS.ADD_MESSAGE
10405: (
10406: p_app_short_name => 'PA',
10407: p_msg_name => 'PA_UP_TA_DECR_QTY_ERR'
10408: );

Line 10410: PA_UTILS.ADD_MESSAGE

10406: p_app_short_name => 'PA',
10407: p_msg_name => 'PA_UP_TA_DECR_QTY_ERR'
10408: );
10409: ELSIF l_viol_indicator = 6 OR l_viol_indicator = 7 THEN
10410: PA_UTILS.ADD_MESSAGE
10411: (
10412: p_app_short_name => 'PA',
10413: p_msg_name => 'PA_UP_TA_ASMT_END_ERR'
10414: );