DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_UTILS dependencies on PA_UTILS

Line 442: PA_UTILS.ADD_MESSAGE('PA',substr(x_err_stage,1,30));

438: x_err_code,
439: x_err_stage,
440: x_err_stack);
441: IF (x_err_code <> 0) THEN
442: PA_UTILS.ADD_MESSAGE('PA',substr(x_err_stage,1,30));
443: return;
444: END IF;
445:
446: If Pa_Task_Utils.Check_Unique_Task_number (p_project_id,

Line 449: PA_UTILS.ADD_MESSAGE('PA','PA_ALL_DUPLICATE_NUM');

445:
446: If Pa_Task_Utils.Check_Unique_Task_number (p_project_id,
447: p_task_number,
448: p_rowid ) <> 1 Then
449: PA_UTILS.ADD_MESSAGE('PA','PA_ALL_DUPLICATE_NUM');
450: return;
451: END IF;
452: END CHECK_TASK_NUMBER_DISP;
453:

Line 492: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');

488: from pa_projects_all
489: where project_id = p_project_id;
490: IF (p_start_date IS NOT NULL and
491: l_start_date > p_start_date) THEN
492: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
493: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496:

Line 499: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');

495: END IF;
496:
497: IF (l_end_date IS NOT NULL and
498: p_start_date > l_end_date) THEN
499: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
500: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503:

Line 512: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');

508: from pa_tasks
509: where task_id = p_parent_task_id;
510: IF (p_start_date is NOT NULL and
511: l_start_date > p_start_date) THEN
512: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');
513: x_msg_data := 'PA_PARENT_TASK_GREATER';
514: RAISE FND_API.G_EXC_ERROR;
515: END IF;
516: IF (l_end_date IS NOT NULL and

Line 518: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');

514: RAISE FND_API.G_EXC_ERROR;
515: END IF;
516: IF (l_end_date IS NOT NULL and
517: p_start_date > l_end_date) THEN
518: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');
519: x_msg_data := 'PA_PARENT_TASK_GREATER';
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522:

Line 582: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_TASK_DATE_EARLIER');

578: FETCH c1 INTO l_start_date, l_end_date;
579: EXIT WHEN c1%NOTFOUND;
580: IF (p_start_date is NOT NULL and
581: l_start_date < p_start_date) THEN -- Bug 7386335
582: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_TASK_DATE_EARLIER');
583: x_msg_data := 'PA_CHILD_TASK_DATE_EARLIER';
584: CLOSE c1;
585: RAISE FND_API.G_EXC_ERROR;
586: END IF;

Line 589: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_TASK_DATE_EARLIER');

585: RAISE FND_API.G_EXC_ERROR;
586: END IF;
587: IF (l_end_date IS NOT NULL and
588: p_start_date > l_end_date) THEN
589: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_TASK_DATE_EARLIER');
590: x_msg_data := 'PA_CHILD_TASK_DATE_EARLIER';
591: CLOSE c1;
592: RAISE FND_API.G_EXC_ERROR;
593: END IF;

Line 651: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');

647: from pa_projects_all
648: where project_id = p_project_id;
649: IF (p_end_date IS NOT NULL and
650: l_end_date < p_end_date) THEN
651: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
652: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;
655: IF (p_end_date IS NOT NULL and

Line 657: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');

653: RAISE FND_API.G_EXC_ERROR;
654: END IF;
655: IF (p_end_date IS NOT NULL and
656: l_start_date > p_end_date) THEN
657: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
658: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
659: RAISE FND_API.G_EXC_ERROR;
660: END IF;
661:

Line 670: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_COMPLETION_EARLIER');

666: from pa_tasks
667: where task_id = p_parent_task_id;
668: IF (p_end_date is NOT NULL and
669: l_end_date < p_end_date) THEN
670: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_COMPLETION_EARLIER');
671: x_msg_data := 'PA_PARENT_COMPLETION_EARLIER';
672: RAISE FND_API.G_EXC_ERROR;
673: END IF;
674: IF (p_end_date is NOT NULL and

Line 676: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_COMPLETION_EARLIER');

672: RAISE FND_API.G_EXC_ERROR;
673: END IF;
674: IF (p_end_date is NOT NULL and
675: l_start_date > p_end_date) THEN
676: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_COMPLETION_EARLIER');
677: x_msg_data := 'PA_PARENT_COMPLETION_EARLIER';
678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680:

Line 739: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_COMPLETION_LATER');

735: FETCH c1 INTO l_start_date, l_end_date;
736: EXIT WHEN c1%NOTFOUND;
737: IF (p_end_date is NOT NULL and
738: l_end_date > p_end_date) THEN
739: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_COMPLETION_LATER');
740: x_msg_data := 'PA_CHILD_COMPLETION_LATER';
741: CLOSE c1;
742: RAISE FND_API.G_EXC_ERROR;
743: END IF;

Line 746: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');

742: RAISE FND_API.G_EXC_ERROR;
743: END IF;
744: IF (p_end_date is NOT NULL and
745: l_start_date > p_end_date) THEN
746: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');
747: x_msg_data := 'PA_CHILD_COMPLETION_LATER';
748: CLOSE c1;
749: RAISE FND_API.G_EXC_ERROR;
750: END IF;

Line 849: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_INVALID_SCH_DATES');

845: p_update_start_date_flag => l_f1,
846: p_update_end_date_flag => l_f2,
847: p_return_status => l_ret);
848: IF (l_ret <> 'S') THEN
849: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_INVALID_SCH_DATES');
850: --commenting the following line after discussing with
851: --sakthi. The reason is that there are two messages being appended
852: --for the same error.
853: --x_msg_data := 'PA_INVALID_SCH_DATES';

Line 861: PA_UTILS.ADD_MESSAGE('PA', 'PA_PROJ_NOT_EXIST');

857:
858: OPEN c1;
859: FETCH c1 INTO l_start_date, l_finish_date;
860: IF c1%NOTFOUND THEN
861: PA_UTILS.ADD_MESSAGE('PA', 'PA_PROJ_NOT_EXIST');
862: x_msg_data := 'PA_PROJ_NOT_EXIST';
863: CLOSE c1;
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;

Line 869: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE');

865: END IF;
866: CLOSE c1;
867:
868: IF (p_sch_start_date IS NOT NULL and l_start_date > p_sch_start_date) THEN
869: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE');
870: x_msg_data := 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE';
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873:

Line 875: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE');

871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873:
874: IF (p_sch_end_date IS NOT NULL and l_finish_date < p_sch_end_date) THEN
875: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE');
876: x_msg_data := 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE';
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879:

Line 923: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_INVALID_EST_DATES');

919: p_update_start_date_flag => l_f1,
920: p_update_end_date_flag => l_f2,
921: p_return_status => l_ret);
922: IF (l_ret <> 'S') THEN
923: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_INVALID_EST_DATES');
924: x_msg_data := 'PA_INVALID_EST_DATES';
925: RAISE FND_API.G_EXC_ERROR;
926: END IF;
927: END IF;

Line 972: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_INVALID_ACTUAL_DATES');

968: p_update_start_date_flag => l_f1,
969: p_update_end_date_flag => l_f2,
970: p_return_status => l_ret);
971: IF (l_ret <> 'S') THEN
972: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_INVALID_ACTUAL_DATES');
973: x_msg_data := 'PA_INVALID_ACTUAL_DATES';
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976: END IF;

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

2019: FOR UPDATE OF record_version_number NOWAIT;
2020:
2021: EXCEPTION
2022: WHEN TIMEOUT_ON_RESOURCE THEN
2023: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2024: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2025: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2026: x_return_status := 'E' ;
2027: WHEN NO_DATA_FOUND THEN

Line 2029: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

2025: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2026: x_return_status := 'E' ;
2027: WHEN NO_DATA_FOUND THEN
2028: if p_calling_module = 'FORM' then
2029: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
2030: p_msg_name => 'FORM_RECORD_CHANGED');
2031: x_msg_data := 'FORM_RECORD_CHANGED';
2032: else
2033: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

2029: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
2030: p_msg_name => 'FORM_RECORD_CHANGED');
2031: x_msg_data := 'FORM_RECORD_CHANGED';
2032: else
2033: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2034: p_msg_name => 'PA_XC_RECORD_CHANGED');
2035: x_msg_data := 'PA_XC_RECORD_CHANGED';
2036: end if;
2037: x_return_status := 'E' ;

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

2036: end if;
2037: x_return_status := 'E' ;
2038: WHEN OTHERS THEN
2039: IF SQLCODE = -54 THEN
2040: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2041: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2042: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2043: x_return_status := 'E' ;
2044: ELSE

Line 2058: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

2054: AND wbs_record_version_number = p_wbs_record_version_number;
2055: EXCEPTION
2056: WHEN NO_DATA_FOUND THEN
2057: if p_calling_module = 'FORM' then
2058: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
2059: p_msg_name => 'FORM_RECORD_CHANGED');
2060: x_msg_data := 'FORM_RECORD_CHANGED';
2061: else
2062: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

2058: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
2059: p_msg_name => 'FORM_RECORD_CHANGED');
2060: x_msg_data := 'FORM_RECORD_CHANGED';
2061: else
2062: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2063: p_msg_name => 'PA_XC_RECORD_CHANGED');
2064: x_msg_data := 'PA_XC_RECORD_CHANGED';
2065: end if;
2066: x_return_status := 'E' ;

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

2065: end if;
2066: x_return_status := 'E' ;
2067: WHEN OTHERS THEN
2068: IF SQLCODE = -54 THEN
2069: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2070: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2071: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2072: x_return_status := 'E' ;
2073: END IF;

Line 2445: PA_UTILS.ADD_MESSAGE

2441: IF (x_ei_date IS NOT NULL AND
2442: p_end_date IS NOT NULL AND
2443: p_end_date < x_ei_date ) THEN
2444: close cur_date;
2445: PA_UTILS.ADD_MESSAGE
2446: (p_app_short_name => 'PA',
2447: p_msg_name => 'PA_EI_INVALID_DATES',
2448: p_token1 => 'EIDATE',
2449: p_value1 => x_ei_date);

Line 2519: PA_UTILS.ADD_MESSAGE

2515: IF (x_ei_min_date IS NOT NULL AND
2516: p_start_date IS NOT NULL AND
2517: p_start_date > x_ei_min_date ) THEN
2518: close cur_start_date;
2519: PA_UTILS.ADD_MESSAGE
2520: (p_app_short_name => 'PA',
2521: p_msg_name => 'PA_EI_INVALID_START_DATE',
2522: p_token1 => 'EISTARTDATE',
2523: p_value1 => x_ei_min_date);