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

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

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

303: --IF ( l_deliverable_status = 'DLVR_CANCELLED' OR l_deliverable_status = 'DLVR_ON_HOLD' )
304: --Changed for BUG 3762650, by rtarway, removed check for DLVR_ON_HOLD status
305: IF ( l_deliverable_status = 'DLVR_CANCELLED')
306: THEN
307: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
308: ,p_msg_name => 'PA_TP_CANT_NTER_DEL_PRG_CANCEL');
309: x_msg_data := 'PA_TP_CANT_NTER_DEL_PRG_CANCEL';
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: RAISE FND_API.G_EXC_ERROR;

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

346: END IF;
347:
348: IF (nvl(l_del_type_prog_enabled,'N') = 'N')
349: THEN
350: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
351: ,p_msg_name => 'PA_TP_CANT_ENTER_DEL_PROG');
352: x_msg_data := 'PA_TP_CANT_ENTER_DEL_PROG';
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: RAISE FND_API.G_EXC_ERROR;

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

355: END IF;
356:
357: IF p_progress_mode <> 'FUTURE'
358: THEN
359: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
360: ,p_msg_name => 'PA_TP_WRONG_PRG_MODE4');
361: x_msg_data := 'PA_TP_WRONG_PRG_MODE4';
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: RAISE FND_API.G_EXC_ERROR;

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

364: END IF;
365:
366: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL
367: THEN
368: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
369: ,p_msg_name => 'PA_TP_INV_AOD');
370: x_msg_data := 'PA_TP_INV_AOD';
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: RAISE FND_API.G_EXC_ERROR;

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

374:
375: /* FPM Dev CR 3
376: IF p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_progress_status_code IS NULL
377: THEN
378: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
379: ,p_msg_name => 'PA_TP_INV_PRG_STAT');
380: x_msg_data := 'PA_TP_INV_PRG_STAT';
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: RAISE FND_API.G_EXC_ERROR;

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

391: END IF;
392:
393: IF p_del_status = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_del_status IS NULL
394: THEN
395: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
396: ,p_msg_name => 'PA_TP_INV_DLV_STAT'); -- FPM Dev CR 1 : Changed message
397: x_msg_data := 'PA_TP_INV_DLV_STAT';
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: RAISE FND_API.G_EXC_ERROR;

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

481: l_brief_overview := p_brief_overview;
482: END IF;
483:
484: IF (l_percent_complete < 0 or l_percent_complete > 100) THEN
485: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
486: ,p_msg_name => 'PA_PERC_COMP_INV');
487: x_msg_data := 'PA_PERC_COMP_INV';
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: RAISE FND_API.G_EXC_ERROR;

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

504: WHERE status_type = 'DELIVERABLE'
505: AND project_status_code = l_del_status;
506: EXCEPTION
507: WHEN NO_DATA_FOUND THEN
508: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
509: p_msg_name => 'PA_TP_INV_DEL_STATUS',
510: P_TOKEN1 => 'OBJECT_ID',
511: P_VALUE1 => p_object_id);
512: x_msg_data := 'PA_TP_INV_DEL_STATUS';

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

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

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

597: THEN
598: --Commented by rtarway for BUG 3668168, if condition
599: --IF l_percent_complete_flag = 'Y'
600: --THEN
601: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
602: ,p_msg_name => 'PA_DELP_STAT_DTES_PC_COMB' );
603: x_msg_data := 'PA_DELP_STAT_DTES_PC_COMB';
604: x_return_status := FND_API.G_RET_STS_ERROR;
605: RAISE FND_API.G_EXC_ERROR;

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

609: ELSIF l_percent_complete_flag = 'N'
610: THEN
611: IF l_percent_complete > 0
612: THEN
613: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
614: p_msg_name => 'PA_TP_PCC_DISABL');
615: x_msg_data := 'PA_TP_PCC_DISABL';
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: RAISE FND_API.G_EXC_ERROR;

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

621: l_del_status2 = 'DLVR_IN_PROGRESS' AND NOT ( l_actual_finish_date IS NULL ) OR
622: l_del_status2 = 'DLVR_COMPLETED' AND NOT ( l_actual_finish_date IS NOT NULL ) OR
623: (l_del_status2 is NULL) OR (l_del_status2 = '')
624: THEN
625: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
626: ,p_msg_name => 'PA_DELP_STAT_DTES_PC_COMB' );
627: x_msg_data := 'PA_DELP_STAT_DTES_PC_COMB';
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: RAISE FND_API.G_EXC_ERROR;

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

668: WHERE status_type = 'DELIVERABLE'
669: AND project_status_code = l_del_status;
670: EXCEPTION
671: WHEN NO_DATA_FOUND THEN
672: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
673: p_msg_name => 'PA_TP_INV_DEL_STATUS',
674: P_TOKEN1 => 'OBJECT_ID',
675: P_VALUE1 => p_object_id);
676: x_msg_data := 'PA_TP_INV_DEL_STATUS';

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

687: WHERE status_type = 'PROGRESS'
688: AND project_status_code = l_progress_status_code;
689: EXCEPTION
690: WHEN NO_DATA_FOUND THEN
691: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
692: p_msg_name => 'PA_INVALID_PROG_STATUS',
693: P_TOKEN1 => 'OBJECT_ID',
694: P_VALUE1 => p_object_id);
695: x_msg_data := 'PA_INVALID_PROG_STATUS';

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

753: --AND l_working_aod IS NULL -- progress exists after as of date
754: THEN
755: --You cannot create a future progress when there exists a progress
756: --after AS_OF_DATE for this deliverable.
757: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
758: p_msg_name => 'PA_TP_INV_AOD2');
759:
760: x_msg_data := 'PA_TP_WRONG_DEL_PRG_MODE3';
761: x_return_status := FND_API.G_RET_STS_ERROR;

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

762: RAISE FND_API.G_EXC_ERROR;
763: --Commented by rtarway for Correction flow
764: -- FPM Dev CR 1 : Added the following IF condition
765: /*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
766: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
767: ,p_msg_name => 'PA_TP_INV_AOD2');
768: x_msg_data := 'PA_TP_INV_AOD2';
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: RAISE FND_API.G_EXC_ERROR;*/

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

782: THEN
783: --Add message
784: --Invalid as of date
785: --Message Changed by rtarway during Correction flow changes
786: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
787: ,p_msg_name => 'PA_TP_INV_AOD2');
788: x_msg_data := 'PA_TP_INV_AOD2';
789: x_return_status := FND_API.G_RET_STS_ERROR;
790: RAISE FND_API.G_EXC_ERROR;

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

1772: ,x_msg_data => l_msg_data );
1773:
1774: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1775: THEN
1776: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1777: p_msg_name => l_msg_data
1778: );
1779: x_msg_data := l_msg_data;
1780: x_return_status := FND_API.G_RET_STS_ERROR;