DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_PROGRESS_PUB dependencies on PA_UTILS

Line 85: l_published_by_party_id NUMBER := PA_UTILS.get_party_id( l_user_id ) ;

81: l_estimated_start_date DATE ;
82: l_estimated_finish_date DATE ;
83: l_est_remaining_eff_flag VARCHAR2(1) ;
84: l_rollup_rec_ver_number NUMBER ;
85: l_published_by_party_id NUMBER := PA_UTILS.get_party_id( l_user_id ) ;
86: l_working_aod DATE ;
87: l_aod DATE ;
88: l_progress_entry_enable_flag VARCHAR2(1) ;
89: l_object_type VARCHAR2(15) := 'PA_ASSIGNMENTS' ;

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

551: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date);
552: l_prog_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(p_as_of_date);
553: exception
554: WHEN OTHERS THEN
555: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
556: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
557: x_msg_data := 'PA_FP_INVALID_DATE_RANGE';
558: x_return_status := 'E';
559: x_msg_count := fnd_msg_pub.count_msg;

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

723: -- 3970229 actuals can be -ive
724: /*--3779387, 3958686 this error should not be raised for hidden assignment as in this case it is being called from update_task_progress
725: IF l_actual_effort_this_period < 0 AND l_ta_display_flag = 'Y'
726: THEN
727: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
728: ,p_msg_name => 'PA_TP_NO_NEG_ACT');
729: x_msg_data := 'PA_TP_NO_NEG_ACT';
730: x_return_status := 'E';
731: RAISE FND_API.G_EXC_ERROR;

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

746: /* 5726773
747: --bug 3779387
748: IF l_etc_effort_this_period < 0
749: THEN
750: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
751: ,p_msg_name => 'PA_TP_NO_NEG_ETC');
752: x_msg_data := 'PA_TP_NO_NEG_ETC';
753: x_return_status := 'E';
754: RAISE FND_API.G_EXC_ERROR;

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

821: ---- 3970229 actuals can be -ive
822: /* --3779387
823: IF l_actual_raw_cost_this_period < 0
824: THEN
825: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
826: ,p_msg_name => 'PA_TP_NO_NEG_ACT');
827: x_msg_data := 'PA_TP_NO_NEG_ACT';
828: x_return_status := 'E';
829: RAISE FND_API.G_EXC_ERROR;

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

851: /* 5726773
852: --bug 3779387 ---4378391 Added l_etc_effort_this_period is null
853: IF l_etc_raw_cost_this_period < 0 and l_etc_effort_this_period is null
854: THEN
855: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
856: ,p_msg_name => 'PA_TP_NO_NEG_ETC');
857: x_msg_data := 'PA_TP_NO_NEG_ETC';
858: x_return_status := 'E';
859: RAISE FND_API.G_EXC_ERROR;

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

869:
870: ---- if status is CANCELLED
871: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_task_id)) = 'CANCELLED'
872: THEN
873: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
874: ,p_msg_name => 'PA_TP_ASSG_CANT_NTER_PRG_CNCEL');
875: x_msg_data := 'PA_TP_ASSG_CANT_NTER_PRG_CNCEL';
876: x_return_status := 'E';
877: RAISE FND_API.G_EXC_ERROR;

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

881: /* Commented by rtarway for BUG 3762650
882: ---- if status is ON HOLD
883: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_task_id)) = 'ON HOLD'
884: THEN
885: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
886: ,p_msg_name => 'PA_TP_ASSG_CANT_NTER_PRG_ONHOLD');
887: x_msg_data := 'PA_TP_ASSG_CANT_NTER_PRG_ONHOLD';
888: x_return_status := 'E';
889: RAISE FND_API.G_EXC_ERROR;

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

902: THEN
903: IF (p_actual_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_cost_this_period >0)
904: OR (p_actual_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_effort_this_period >0)
905: THEN
906: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
907: ,p_msg_name => 'PA_TP_CANT_NTER_ACT_SHR_STR');
908: x_msg_data := 'PA_TP_CANT_NTER_ACT_SHR_STR';
909: x_return_status := 'E';
910: RAISE FND_API.G_EXC_ERROR;

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

918: IF (l_actual_effort IS NOT NULL AND l_actual_effort >0)
919: OR (l_actual_raw_cost IS NOT NULL AND l_actual_raw_cost >0)
920: THEN
921:
922: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
923: ,p_msg_name => 'PA_TP_CANT_NTER_ACT_SHR_STR');
924: x_msg_data := 'PA_TP_CANT_NTER_ACT_SHR_STR';
925: x_return_status := 'E';
926: RAISE FND_API.G_EXC_ERROR;

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

930:
931: ----- Wrong MODE
932: IF p_progress_mode not in ( 'FUTURE' )
933: THEN
934: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
935: ,p_msg_name => 'PA_TP_WRONG_PRG_MODE4');
936: x_msg_data := 'PA_TP_WRONG_PRG_MODE4';
937: x_return_status := 'E';
938: RAISE FND_API.G_EXC_ERROR;

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

941:
942: ----- Invalid DATE
943: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL
944: THEN
945: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
946: ,p_msg_name => 'PA_TP_INV_AOD');
947: x_msg_data := 'PA_TP_INV_AOD';
948: x_return_status := 'E';
949: RAISE FND_API.G_EXC_ERROR;

Line 961: pa_utils.add_message(p_app_short_name => 'PA',

957: THEN
958: IF (p_estimated_finish_date < p_estimated_start_date)
959: THEN
960: x_return_status := FND_API.G_RET_STS_ERROR;
961: pa_utils.add_message(p_app_short_name => 'PA',
962: p_msg_name => 'PA_EST_DATES_INV');
963: raise fnd_api.g_exc_error;
964: END IF;
965: END IF;

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

1054: AND pra.task_id = p_task_id
1055: AND pra.wbs_element_version_id = p_object_version_id;
1056: EXCEPTION
1057: WHEN NO_DATA_FOUND THEN
1058: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1059: p_msg_name => 'PA_TP_INV_ASSGN_AMG',
1060: P_TOKEN1 => 'OBJECT_ID',
1061: P_VALUE1 => l_resource_list_member_id);
1062: x_msg_data := 'PA_TP_INV_ASSGN_AMG';

Line 1095: pa_utils.add_message(p_app_short_name => 'PA',

1091: END IF;
1092:
1093: IF l_estimated_finish_date is not null and l_estimated_finish_date < nvl(l_estimated_start_date,l_estimated_finish_date+1) THEN
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095: pa_utils.add_message(p_app_short_name => 'PA',
1096: p_msg_name => 'PA_EST_DATES_INV');
1097: raise fnd_api.g_exc_error;
1098: END IF;
1099: -- Bug 3979303 : End

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

1344: --AND l_working_aod IS NULL -- progress exists after as of date -- commented as not needed Satish
1345: THEN
1346: --You cannot create a future progress when there exists a progress
1347: --after AS_OF_DATE for this task.
1348: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1349: p_msg_name => 'PA_TP_ASSG_WRONG_PRG_MODE3',
1350: p_token1 => 'AS_OF_DATE',
1351: p_value1 => p_as_of_date );
1352: x_msg_data := 'PA_TP_ASSG_WRONG_PRG_MODE3';

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

1365: l_db_action := 'CREATE';*/
1366: /* commenting out as now we will allow to create a working rec if published record exists on that as_of_date
1367: --You cannot save progress when there exists a published progress
1368: --for this as of date.
1369: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1370: p_msg_name => 'PA_TP_ASSG_WRONG_ACTION',
1371: p_token1 => 'AS_OF_DATE',
1372: p_value1 => p_as_of_date );
1373: x_msg_data := 'PA_TP_ASSG_WRONG_ACTION';

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

1389: AND nvl(l_last_progress_date,p_as_of_date + 1 ) <> p_as_of_date
1390: THEN
1391: --Add message
1392: --Invalid as of date
1393: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1394: ,p_msg_name => 'PA_TP_INV_AOD2');
1395: x_msg_data := 'PA_TP_INV_AOD2';
1396: x_return_status := 'E';
1397: RAISE FND_API.G_EXC_ERROR;

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

1966: -- Bug 3956299 : We can default actual finish date in this case from scheduled_finish_date
1967: l_actual_finish_date := l_scheduled_finish_date;
1968: IF l_actual_finish_date is null THEN
1969: --You have to pass actual finish date if etc is 0
1970: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1971: ,p_msg_name => 'PA_TP_ASSG_NTER_FIN_DATE');
1972: x_msg_data := 'PA_TP_ASSG_NTER_FIN_DATE';
1973: x_return_status := 'E';
1974: RAISE FND_API.G_EXC_ERROR;

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

2660: -- Bug 3956299 : We can default actual finish date in this case from scheduled_finish_date
2661: l_actual_finish_date := l_scheduled_finish_date;
2662: IF l_actual_finish_date is null THEN
2663: --You have to pass actual finish date if etc is 0
2664: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2665: ,p_msg_name => 'PA_TP_ASSG_NTER_FIN_DATE');
2666: x_msg_data := 'PA_TP_ASSG_NTER_FIN_DATE';
2667: x_return_status := 'E';
2668: RAISE FND_API.G_EXC_ERROR;