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 601: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

597: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date);
598: l_prog_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(p_as_of_date);
599: exception
600: WHEN OTHERS THEN
601: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
602: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
603: x_msg_data := 'PA_FP_INVALID_DATE_RANGE';
604: x_return_status := 'E';
605: x_msg_count := fnd_msg_pub.count_msg;

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

775: -- 3970229 actuals can be -ive
776: /*--3779387, 3958686 this error should not be raised for hidden assignment as in this case it is being called from update_task_progress
777: IF l_actual_effort_this_period < 0 AND l_ta_display_flag = 'Y'
778: THEN
779: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
780: ,p_msg_name => 'PA_TP_NO_NEG_ACT');
781: x_msg_data := 'PA_TP_NO_NEG_ACT';
782: x_return_status := 'E';
783: RAISE FND_API.G_EXC_ERROR;

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

798: /* 5726773
799: --bug 3779387
800: IF l_etc_effort_this_period < 0
801: THEN
802: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
803: ,p_msg_name => 'PA_TP_NO_NEG_ETC');
804: x_msg_data := 'PA_TP_NO_NEG_ETC';
805: x_return_status := 'E';
806: RAISE FND_API.G_EXC_ERROR;

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

873: ---- 3970229 actuals can be -ive
874: /* --3779387
875: IF l_actual_raw_cost_this_period < 0
876: THEN
877: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
878: ,p_msg_name => 'PA_TP_NO_NEG_ACT');
879: x_msg_data := 'PA_TP_NO_NEG_ACT';
880: x_return_status := 'E';
881: RAISE FND_API.G_EXC_ERROR;

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

903: /* 5726773
904: --bug 3779387 ---4378391 Added l_etc_effort_this_period is null
905: IF l_etc_raw_cost_this_period < 0 and l_etc_effort_this_period is null
906: THEN
907: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
908: ,p_msg_name => 'PA_TP_NO_NEG_ETC');
909: x_msg_data := 'PA_TP_NO_NEG_ETC';
910: x_return_status := 'E';
911: RAISE FND_API.G_EXC_ERROR;

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

930: and p_etc_cost_this_period IS NOT NULL) OR
931: (p_etc_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
932: and p_etc_effort_this_period IS NOT NULL )
933: THEN
934: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
935: ,p_msg_name => 'PA_WP_VD_CANT_UPDATE_ETC');
936: x_msg_data := 'PA_WP_VD_CANT_UPDATE_ETC';
937: x_return_status := 'E';
938: RAISE FND_API.G_EXC_ERROR;

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

942: -- Bug 16573693 End
943: ---- if status is CANCELLED
944: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_task_id)) = 'CANCELLED'
945: THEN
946: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
947: ,p_msg_name => 'PA_TP_ASSG_CANT_NTER_PRG_CNCEL');
948: x_msg_data := 'PA_TP_ASSG_CANT_NTER_PRG_CNCEL';
949: x_return_status := 'E';
950: RAISE FND_API.G_EXC_ERROR;

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

954: /* Commented by rtarway for BUG 3762650
955: ---- if status is ON HOLD
956: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_task_id)) = 'ON HOLD'
957: THEN
958: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
959: ,p_msg_name => 'PA_TP_ASSG_CANT_NTER_PRG_ONHOLD');
960: x_msg_data := 'PA_TP_ASSG_CANT_NTER_PRG_ONHOLD';
961: x_return_status := 'E';
962: RAISE FND_API.G_EXC_ERROR;

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

975: THEN
976: IF (p_actual_cost_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_cost_this_period >0)
977: OR (p_actual_effort_this_period <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_actual_effort_this_period >0)
978: THEN
979: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
980: ,p_msg_name => 'PA_TP_CANT_NTER_ACT_SHR_STR');
981: x_msg_data := 'PA_TP_CANT_NTER_ACT_SHR_STR';
982: x_return_status := 'E';
983: RAISE FND_API.G_EXC_ERROR;

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

991: IF (l_actual_effort IS NOT NULL AND l_actual_effort >0)
992: OR (l_actual_raw_cost IS NOT NULL AND l_actual_raw_cost >0)
993: THEN
994:
995: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
996: ,p_msg_name => 'PA_TP_CANT_NTER_ACT_SHR_STR');
997: x_msg_data := 'PA_TP_CANT_NTER_ACT_SHR_STR';
998: x_return_status := 'E';
999: RAISE FND_API.G_EXC_ERROR;

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

1003:
1004: ----- Wrong MODE
1005: IF p_progress_mode not in ( 'FUTURE' )
1006: THEN
1007: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1008: ,p_msg_name => 'PA_TP_WRONG_PRG_MODE4');
1009: x_msg_data := 'PA_TP_WRONG_PRG_MODE4';
1010: x_return_status := 'E';
1011: RAISE FND_API.G_EXC_ERROR;

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

1014:
1015: ----- Invalid DATE
1016: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL
1017: THEN
1018: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1019: ,p_msg_name => 'PA_TP_INV_AOD');
1020: x_msg_data := 'PA_TP_INV_AOD';
1021: x_return_status := 'E';
1022: RAISE FND_API.G_EXC_ERROR;

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

1030: THEN
1031: IF (p_estimated_finish_date < p_estimated_start_date)
1032: THEN
1033: x_return_status := FND_API.G_RET_STS_ERROR;
1034: pa_utils.add_message(p_app_short_name => 'PA',
1035: p_msg_name => 'PA_EST_DATES_INV');
1036: raise fnd_api.g_exc_error;
1037: END IF;
1038: END IF;

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

1136: EXCEPTION
1137: WHEN NO_DATA_FOUND THEN
1138:
1139: IF l_cbs_element_id is null THEN
1140: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1141: p_msg_name => 'PA_TP_INV_ASSGN_AMG',
1142: P_TOKEN1 => 'OBJECT_ID',
1143: P_VALUE1 => l_resource_list_member_id);
1144: x_msg_data := 'PA_TP_INV_ASSGN_AMG';

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

1144: x_msg_data := 'PA_TP_INV_ASSGN_AMG';
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146: RAISE FND_API.G_EXC_ERROR;
1147: ELSE
1148: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1149: p_msg_name => 'PA_CBS_TP_INV_ASSGN_AMG',
1150: P_TOKEN1 => 'OBJECT_ID',
1151: P_VALUE1 => l_resource_list_member_id);
1152: x_msg_data := 'PA_CBS_TP_INV_ASSGN_AMG';

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

1185: END IF;
1186:
1187: IF l_estimated_finish_date is not null and l_estimated_finish_date < nvl(l_estimated_start_date,l_estimated_finish_date+1) THEN
1188: x_return_status := FND_API.G_RET_STS_ERROR;
1189: pa_utils.add_message(p_app_short_name => 'PA',
1190: p_msg_name => 'PA_EST_DATES_INV');
1191: raise fnd_api.g_exc_error;
1192: END IF;
1193: -- Bug 3979303 : End

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

1454: --AND l_working_aod IS NULL -- progress exists after as of date -- commented as not needed Satish
1455: THEN
1456: --You cannot create a future progress when there exists a progress
1457: --after AS_OF_DATE for this task.
1458: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1459: p_msg_name => 'PA_TP_ASSG_WRONG_PRG_MODE3',
1460: p_token1 => 'AS_OF_DATE',
1461: p_value1 => p_as_of_date );
1462: x_msg_data := 'PA_TP_ASSG_WRONG_PRG_MODE3';

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

1475: l_db_action := 'CREATE';*/
1476: /* commenting out as now we will allow to create a working rec if published record exists on that as_of_date
1477: --You cannot save progress when there exists a published progress
1478: --for this as of date.
1479: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1480: p_msg_name => 'PA_TP_ASSG_WRONG_ACTION',
1481: p_token1 => 'AS_OF_DATE',
1482: p_value1 => p_as_of_date );
1483: x_msg_data := 'PA_TP_ASSG_WRONG_ACTION';

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

1499: AND nvl(l_last_progress_date,p_as_of_date + 1 ) <> p_as_of_date
1500: THEN
1501: --Add message
1502: --Invalid as of date
1503: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1504: ,p_msg_name => 'PA_TP_INV_AOD2');
1505: x_msg_data := 'PA_TP_INV_AOD2';
1506: x_return_status := 'E';
1507: RAISE FND_API.G_EXC_ERROR;

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

2080: -- Bug 3956299 : We can default actual finish date in this case from scheduled_finish_date
2081: l_actual_finish_date := l_scheduled_finish_date;
2082: IF l_actual_finish_date is null THEN
2083: --You have to pass actual finish date if etc is 0
2084: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2085: ,p_msg_name => 'PA_TP_ASSG_NTER_FIN_DATE');
2086: x_msg_data := 'PA_TP_ASSG_NTER_FIN_DATE';
2087: x_return_status := 'E';
2088: RAISE FND_API.G_EXC_ERROR;

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

2777: -- Bug 3956299 : We can default actual finish date in this case from scheduled_finish_date
2778: l_actual_finish_date := l_scheduled_finish_date;
2779: IF l_actual_finish_date is null THEN
2780: --You have to pass actual finish date if etc is 0
2781: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2782: ,p_msg_name => 'PA_TP_ASSG_NTER_FIN_DATE');
2783: x_msg_data := 'PA_TP_ASSG_NTER_FIN_DATE';
2784: x_return_status := 'E';
2785: RAISE FND_API.G_EXC_ERROR;