DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PROGRESS_PUB dependencies on PA_UTILS

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

67: l_percent_complete NUMBER ;
68:
69: l_percent_complete_flag VARCHAR2(1) ;
70: l_rollup_rec_ver_number NUMBER ;
71: l_published_by_party_id NUMBER := PA_UTILS.get_party_id( l_user_id ) ;
72: l_del_status VARCHAR2(150) ;
73: l_del_status2 VARCHAR2(150) ;
74: l_working_aod DATE ;
75: l_aod DATE ;

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

283: --Added for BUG 3762650, by rtarway, added check for task's cancelled status
284: --if associated task status is CANCELLED, dlvr progress cant be entered
285: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, l_task_id)) = 'CANCELLED'
286: THEN
287: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
288: ,p_msg_name => 'PA_TP_DLVR_CANT_NTER_PRG_CANCEL');
289: x_msg_data := 'PA_TP_DLVR_CANT_NTER_PRG_CANCEL';
290: x_return_status := 'E';
291: RAISE FND_API.G_EXC_ERROR;

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

309: --IF ( l_deliverable_status = 'DLVR_CANCELLED' OR l_deliverable_status = 'DLVR_ON_HOLD' )
310: --Changed for BUG 3762650, by rtarway, removed check for DLVR_ON_HOLD status
311: IF ( l_deliverable_status = 'DLVR_CANCELLED')
312: THEN
313: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
314: ,p_msg_name => 'PA_TP_CANT_NTER_DEL_CANCEL_AMG'
315: ,p_token1 => 'DEL_NAME' -- Bug 6497559
316: ,p_value1 => l_del_name
317: );

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

355: END IF;
356:
357: IF (nvl(l_del_type_prog_enabled,'N') = 'N')
358: THEN
359: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
360: ,p_msg_name => 'PA_TP_CANT_ENTER_DEL_PROG_AMG'
361: ,p_token1 => 'DEL_NAME' -- Bug 6497559
362: ,p_value1 => l_del_name);
363: x_msg_data := 'PA_TP_CANT_ENTER_DEL_PROG_AMG';

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

366: END IF;
367:
368: IF p_progress_mode <> 'FUTURE'
369: THEN
370: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
371: ,p_msg_name => 'PA_TP_WRONG_PRG_MODE4');
372: x_msg_data := 'PA_TP_WRONG_PRG_MODE4';
373: x_return_status := FND_API.G_RET_STS_ERROR;
374: RAISE FND_API.G_EXC_ERROR;

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

375: END IF;
376:
377: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL
378: THEN
379: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
380: ,p_msg_name => 'PA_TP_INV_AOD_AMG'
381: ,p_token1 => 'DEL_NAME' -- Bug 6497559
382: ,p_value1 => l_del_name);
383: x_msg_data := 'PA_TP_INV_AOD';

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

387:
388: /* FPM Dev CR 3
389: IF p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_progress_status_code IS NULL
390: THEN
391: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
392: ,p_msg_name => 'PA_TP_INV_PRG_STAT');
393: x_msg_data := 'PA_TP_INV_PRG_STAT';
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: RAISE FND_API.G_EXC_ERROR;

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

404: END IF;
405:
406: IF p_del_status = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_del_status IS NULL
407: THEN
408: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
409: ,p_msg_name => 'PA_TP_INV_DLV_STAT_AMG' -- Bug 6497559
410: ,p_token1 => 'DEL_NAME'
411: ,p_value1 => l_del_name
412: ); -- FPM Dev CR 1 : Changed message

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

497: l_brief_overview := p_brief_overview;
498: END IF;
499:
500: IF (l_percent_complete < 0 or l_percent_complete > 100) THEN
501: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
502: ,p_msg_name => 'PA_PERC_COMP_INV_DLV_AMG' -- Bug 6497559
503: ,p_token1 => 'DEL_NAME'
504: ,p_value1 => l_del_name
505: );

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

523: WHERE status_type = 'DELIVERABLE'
524: AND project_status_code = l_del_status;
525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN
527: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
528: p_msg_name => 'PA_TP_INV_DEL_STATUS',
529: P_TOKEN1 => 'OBJECT_ID',
530: P_VALUE1 => p_object_id);
531: x_msg_data := 'PA_TP_INV_DEL_STATUS';

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

542: WHERE status_type = 'PROGRESS'
543: AND project_status_code = l_progress_status_code;
544: EXCEPTION
545: WHEN NO_DATA_FOUND THEN
546: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
547: p_msg_name => 'PA_INVALID_PROG_STATUS',
548: P_TOKEN1 => 'OBJECT_ID',
549: P_VALUE1 => p_object_id);
550: x_msg_data := 'PA_INVALID_PROG_STATUS';

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

616: THEN
617: --Commented by rtarway for BUG 3668168, if condition
618: --IF l_percent_complete_flag = 'Y'
619: --THEN
620: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
621: ,p_msg_name => 'PA_DELP_STAT_DTES_PC_COMB_AMG'
622: ,p_token1 => 'DEL_NAME' -- Bug 6497559
623: ,p_value1 => l_del_name);
624: x_msg_data := 'PA_DELP_STAT_DTES_PC_COMB_AMG';

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

630: ELSIF l_percent_complete_flag = 'N'
631: THEN
632: IF l_percent_complete > 0
633: THEN
634: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
635: ,p_msg_name => 'PA_TP_PCC_DISABL_AMG'
636: ,p_token1 => 'TASK_NAME' -- Bug 6497559
637: ,p_value1 => PA_TASK_UTILS.get_task_name(p_task_id)
638: ,p_token2 => 'TASK_NUMBER'

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

650: l_del_status2 = 'DLVR_IN_PROGRESS' AND NOT ( l_actual_finish_date IS NULL ) OR
651: l_del_status2 = 'DLVR_COMPLETED' AND NOT ( l_actual_finish_date IS NOT NULL ) OR
652: (l_del_status2 is NULL) OR (l_del_status2 = '')
653: THEN
654: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
655: ,p_msg_name => 'PA_DELP_STAT_DTES_PC_COMB_AMG'
656: ,p_token1 => 'DEL_NAME' -- Bug 6497559
657: ,p_value1 => l_del_name);
658: x_msg_data := 'PA_DELP_STAT_DTES_PC_COMB_AMG';

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

699: WHERE status_type = 'DELIVERABLE'
700: AND project_status_code = l_del_status;
701: EXCEPTION
702: WHEN NO_DATA_FOUND THEN
703: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
704: p_msg_name => 'PA_TP_INV_DEL_STATUS',
705: P_TOKEN1 => 'OBJECT_ID',
706: P_VALUE1 => p_object_id);
707: x_msg_data := 'PA_TP_INV_DEL_STATUS';

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

718: WHERE status_type = 'PROGRESS'
719: AND project_status_code = l_progress_status_code;
720: EXCEPTION
721: WHEN NO_DATA_FOUND THEN
722: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
723: p_msg_name => 'PA_INVALID_PROG_STATUS',
724: P_TOKEN1 => 'OBJECT_ID',
725: P_VALUE1 => p_object_id);
726: x_msg_data := 'PA_INVALID_PROG_STATUS';

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

784: --AND l_working_aod IS NULL -- progress exists after as of date
785: THEN
786: --You cannot create a future progress when there exists a progress
787: --after AS_OF_DATE for this deliverable.
788: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
789: p_msg_name => 'PA_TP_INV_AOD2');
790:
791: x_msg_data := 'PA_TP_WRONG_DEL_PRG_MODE3';
792: x_return_status := FND_API.G_RET_STS_ERROR;

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

793: RAISE FND_API.G_EXC_ERROR;
794: --Commented by rtarway for Correction flow
795: -- FPM Dev CR 1 : Added the following IF condition
796: /*ELSIF trunc(p_as_of_date) <= trunc(NVL( l_last_progress_date, p_as_of_date-1)) AND l_progress_exists_on_aod = 'PUBLISHED' THEN
797: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
798: ,p_msg_name => 'PA_TP_INV_AOD2');
799: x_msg_data := 'PA_TP_INV_AOD2';
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: RAISE FND_API.G_EXC_ERROR;*/

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

813: THEN
814: --Add message
815: --Invalid as of date
816: --Message Changed by rtarway during Correction flow changes
817: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
818: ,p_msg_name => 'PA_TP_INV_AOD2');
819: x_msg_data := 'PA_TP_INV_AOD2';
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: RAISE FND_API.G_EXC_ERROR;

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

1803: ,x_msg_data => l_msg_data );
1804:
1805: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1806: THEN
1807: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1808: p_msg_name => l_msg_data
1809: );
1810: x_msg_data := l_msg_data;
1811: x_return_status := FND_API.G_RET_STS_ERROR;