DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_UTILS

Line 66: PA_UTILS_SQNUM_PKG.get_unique_proj_num('PA_PROJECTS',

62: x_err_code := 10;
63: x_err_stage := 'PA_NO_GEN_MODE';
64: return;
65: elsif proj_number_gen_mode = 'AUTOMATIC' then
66: PA_UTILS_SQNUM_PKG.get_unique_proj_num('PA_PROJECTS',
67: FND_GLOBAL.USER_ID,
68: unique_id,
69: status);
70: if status = 0 then

Line 138: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',

134: PROCEDURE revert_proj_number(p_proj_number_gen_mode IN VARCHAR2,
135: p_project_number IN VARCHAR2 ) IS
136: BEGIN
137: IF p_proj_number_gen_mode = 'AUTOMATIC' THEN
138: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',
139: p_user_id => FND_GLOBAL.USER_ID,
140: p_unique_number => TO_NUMBER(p_project_number));
141: END IF;
142: END revert_proj_number;

Line 815: If pa_utils2.IsProjectClosed(p1_rec.project_system_status_code) = 'Y' then

811: fetch p1 into p1_rec;
812: close p1;
813:
814: /* If p1_rec.project_system_status_code = 'CLOSED' then */
815: If pa_utils2.IsProjectClosed(p1_rec.project_system_status_code) = 'Y' then
816: p_closed_date := sysdate;
817: Else
818: p_closed_date := null;
819: End If;

Line 828: If pa_utils2.IsProjectClosed(p2_rec.project_system_status_code)= 'Y' then

824: If p2_rec.starting_status_flag = 'Y' then
825: p_project_status_code := p2_rec.project_status_code;
826:
827: /* If p2_rec.project_system_status_code = 'CLOSED' then */
828: If pa_utils2.IsProjectClosed(p2_rec.project_system_status_code)= 'Y' then
829: p_closed_date := sysdate;
830: Else
831: p_closed_date := null;
832: End If;

Line 840: If pa_utils2.IsProjectClosed(p3_rec.project_system_status_code) = 'Y' then

836: close p3;
837: p_project_status_code := p3_rec.project_status_code;
838:
839: /* If p3_rec.project_system_status_code = 'CLOSED' then */
840: If pa_utils2.IsProjectClosed(p3_rec.project_system_status_code) = 'Y' then
841: p_closed_date := sysdate;
842: Else
843: p_closed_date := null;
844: End If;

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

3304: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3305: THEN
3306: IF NOT pa_project_pvt.check_valid_message(x_err_stage)
3307: THEN
3308: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3309: p_msg_name =>
3310: 'PA_GET_CUSTOMER_INFO_FAILED');
3311: ELSE
3312: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

3308: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3309: p_msg_name =>
3310: 'PA_GET_CUSTOMER_INFO_FAILED');
3311: ELSE
3312: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3313: p_msg_name => x_err_stage);
3314: END IF;
3315: END IF;
3316: return;

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

3456: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3457: THEN
3458: IF NOT pa_project_pvt.check_valid_message(x_err_stage)
3459: THEN
3460: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3461: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
3462: ELSE
3463: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3464: p_msg_name => x_err_stage);

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

3459: THEN
3460: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3461: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
3462: ELSE
3463: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3464: p_msg_name => x_err_stage);
3465: END IF;
3466: rollback to copy_project;
3467: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

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

3469: END IF;
3470:
3471: ELSIF x_err_code < 0
3472: THEN
3473: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3474: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
3475: rollback to copy_project;
3476: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3477: return;

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

3520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3521: THEN
3522: IF NOT pa_project_pvt.check_valid_message(x_err_stage)
3523: THEN
3524: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3525: p_msg_name =>
3526: 'PA_GET_CUSTOMER_INFO_FAILED');
3527: ELSE
3528: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

3524: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3525: p_msg_name =>
3526: 'PA_GET_CUSTOMER_INFO_FAILED');
3527: ELSE
3528: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3529: p_msg_name => x_err_stage);
3530: END IF;
3531: END IF;
3532: return;

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

3663: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3664: THEN
3665: IF NOT pa_project_pvt.check_valid_message(x_err_stage)
3666: THEN
3667: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3668: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
3669: ELSE
3670: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3671: p_msg_name => x_err_stage);

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

3666: THEN
3667: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3668: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
3669: ELSE
3670: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3671: p_msg_name => x_err_stage);
3672: END IF;
3673: rollback to copy_project;
3674: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

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

3676: END IF;
3677:
3678: ELSIF x_err_code < 0
3679: THEN
3680: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3681: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
3682: rollback to copy_project;
3683: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3684: return;