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 827: If pa_utils2.IsProjectClosed(p1_rec.project_system_status_code) = 'Y' then

823: fetch p1 into p1_rec;
824: close p1;
825:
826: /* If p1_rec.project_system_status_code = 'CLOSED' then */
827: If pa_utils2.IsProjectClosed(p1_rec.project_system_status_code) = 'Y' then
828: p_closed_date := sysdate;
829: Else
830: p_closed_date := null;
831: End If;

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

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

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

848: close p3;
849: p_project_status_code := p3_rec.project_status_code;
850:
851: /* If p3_rec.project_system_status_code = 'CLOSED' then */
852: If pa_utils2.IsProjectClosed(p3_rec.project_system_status_code) = 'Y' then
853: p_closed_date := sysdate;
854: Else
855: p_closed_date := null;
856: End If;

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

3347: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3348: THEN
3349: IF NOT pa_project_pvt.check_valid_message(x_err_stage)
3350: THEN
3351: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3352: p_msg_name =>
3353: 'PA_GET_CUSTOMER_INFO_FAILED');
3354: ELSE
3355: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

3351: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3352: p_msg_name =>
3353: 'PA_GET_CUSTOMER_INFO_FAILED');
3354: ELSE
3355: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3356: p_msg_name => x_err_stage);
3357: END IF;
3358: END IF;
3359: return;

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

3499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3500: THEN
3501: IF NOT pa_project_pvt.check_valid_message(x_err_stage)
3502: THEN
3503: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3504: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
3505: ELSE
3506: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3507: p_msg_name => x_err_stage);

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

3502: THEN
3503: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3504: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
3505: ELSE
3506: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3507: p_msg_name => x_err_stage);
3508: END IF;
3509: rollback to copy_project;
3510: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

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

3512: END IF;
3513:
3514: ELSIF x_err_code < 0
3515: THEN
3516: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3517: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
3518: rollback to copy_project;
3519: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3520: return;

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

3563: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3564: THEN
3565: IF NOT pa_project_pvt.check_valid_message(x_err_stage)
3566: THEN
3567: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3568: p_msg_name =>
3569: 'PA_GET_CUSTOMER_INFO_FAILED');
3570: ELSE
3571: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

3567: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3568: p_msg_name =>
3569: 'PA_GET_CUSTOMER_INFO_FAILED');
3570: ELSE
3571: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3572: p_msg_name => x_err_stage);
3573: END IF;
3574: END IF;
3575: return;

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

3706: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3707: THEN
3708: IF NOT pa_project_pvt.check_valid_message(x_err_stage)
3709: THEN
3710: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3711: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
3712: ELSE
3713: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3714: p_msg_name => x_err_stage);

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

3709: THEN
3710: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3711: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
3712: ELSE
3713: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3714: p_msg_name => x_err_stage);
3715: END IF;
3716: rollback to copy_project;
3717: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

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

3719: END IF;
3720:
3721: ELSIF x_err_code < 0
3722: THEN
3723: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3724: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
3725: rollback to copy_project;
3726: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3727: return;