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 506: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');

502: from pa_projects_all
503: where project_id = p_project_id;
504: IF (p_start_date IS NOT NULL and
505: l_start_date > p_start_date) THEN
506: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
507: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510:

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

509: END IF;
510:
511: IF (l_end_date IS NOT NULL and
512: p_start_date > l_end_date) THEN
513: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
514: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517:

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

533: from pa_tasks
534: where task_id = p_parent_task_id;
535: IF (p_start_date is NOT NULL and
536: l_start_date > p_start_date) THEN
537: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');
538: x_msg_data := 'PA_PARENT_TASK_GREATER';
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: IF (l_end_date IS NOT NULL and

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

539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: IF (l_end_date IS NOT NULL and
542: p_start_date > l_end_date) THEN
543: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');
544: x_msg_data := 'PA_PARENT_TASK_GREATER';
545: RAISE FND_API.G_EXC_ERROR;
546: END IF;
547:

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

603: FETCH c1 INTO l_start_date, l_end_date;
604: EXIT WHEN c1%NOTFOUND;
605: IF (p_start_date is NOT NULL and
606: l_start_date < p_start_date) THEN -- Bug 7386335
607: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_TASK_DATE_EARLIER');
608: x_msg_data := 'PA_CHILD_TASK_DATE_EARLIER';
609: CLOSE c1;
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;

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

610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612: IF (l_end_date IS NOT NULL and
613: p_start_date > l_end_date) THEN
614: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_TASK_DATE_EARLIER');
615: x_msg_data := 'PA_CHILD_TASK_DATE_EARLIER';
616: CLOSE c1;
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;

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

686: from pa_projects_all
687: where project_id = p_project_id;
688: IF (p_end_date IS NOT NULL and
689: l_end_date < p_end_date) THEN
690: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
691: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
692: RAISE FND_API.G_EXC_ERROR;
693: END IF;
694: IF (p_end_date IS NOT NULL and

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

692: RAISE FND_API.G_EXC_ERROR;
693: END IF;
694: IF (p_end_date IS NOT NULL and
695: l_start_date > p_end_date) THEN
696: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');
697: x_msg_data := 'PA_TK_OUTSIDE_PROJECT_RANGE';
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;
700:

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

717: from pa_tasks
718: where task_id = p_parent_task_id;
719: IF (p_end_date is NOT NULL and
720: l_end_date < p_end_date) THEN
721: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_COMPLETION_EARLIER');
722: x_msg_data := 'PA_PARENT_COMPLETION_EARLIER';
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;
725: IF (p_end_date is NOT NULL and

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

723: RAISE FND_API.G_EXC_ERROR;
724: END IF;
725: IF (p_end_date is NOT NULL and
726: l_start_date > p_end_date) THEN
727: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_COMPLETION_EARLIER');
728: x_msg_data := 'PA_PARENT_COMPLETION_EARLIER';
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;
731:

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

786: FETCH c1 INTO l_start_date, l_end_date;
787: EXIT WHEN c1%NOTFOUND;
788: IF (p_end_date is NOT NULL and
789: l_end_date > p_end_date) THEN
790: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_CHILD_COMPLETION_LATER');
791: x_msg_data := 'PA_CHILD_COMPLETION_LATER';
792: CLOSE c1;
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;

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

793: RAISE FND_API.G_EXC_ERROR;
794: END IF;
795: IF (p_end_date is NOT NULL and
796: l_start_date > p_end_date) THEN
797: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PARENT_TASK_GREATER');
798: x_msg_data := 'PA_CHILD_COMPLETION_LATER';
799: CLOSE c1;
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;

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

896: p_update_start_date_flag => l_f1,
897: p_update_end_date_flag => l_f2,
898: p_return_status => l_ret);
899: IF (l_ret <> 'S') THEN
900: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_INVALID_SCH_DATES');
901: --commenting the following line after discussing with
902: --sakthi. The reason is that there are two messages being appended
903: --for the same error.
904: --x_msg_data := 'PA_INVALID_SCH_DATES';

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

908:
909: OPEN c1;
910: FETCH c1 INTO l_start_date, l_finish_date;
911: IF c1%NOTFOUND THEN
912: PA_UTILS.ADD_MESSAGE('PA', 'PA_PROJ_NOT_EXIST');
913: x_msg_data := 'PA_PROJ_NOT_EXIST';
914: CLOSE c1;
915: RAISE FND_API.G_EXC_ERROR;
916: END IF;

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

916: END IF;
917: CLOSE c1;
918:
919: IF (p_sch_start_date IS NOT NULL and l_start_date > p_sch_start_date) THEN
920: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE');
921: x_msg_data := 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE';
922: RAISE FND_API.G_EXC_ERROR;
923: END IF;
924:

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

922: RAISE FND_API.G_EXC_ERROR;
923: END IF;
924:
925: IF (p_sch_end_date IS NOT NULL and l_finish_date < p_sch_end_date) THEN
926: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE');
927: x_msg_data := 'PA_SCH_DATE_OUTSIDE_PROJ_RANGE';
928: RAISE FND_API.G_EXC_ERROR;
929: END IF;
930:

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

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

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

1019: p_update_start_date_flag => l_f1,
1020: p_update_end_date_flag => l_f2,
1021: p_return_status => l_ret);
1022: IF (l_ret <> 'S') THEN
1023: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_INVALID_ACTUAL_DATES');
1024: x_msg_data := 'PA_INVALID_ACTUAL_DATES';
1025: RAISE FND_API.G_EXC_ERROR;
1026: END IF;
1027: END IF;

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

2070: FOR UPDATE OF record_version_number NOWAIT;
2071:
2072: EXCEPTION
2073: WHEN TIMEOUT_ON_RESOURCE THEN
2074: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2075: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2076: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2077: x_return_status := 'E' ;
2078: WHEN NO_DATA_FOUND THEN

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

2076: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2077: x_return_status := 'E' ;
2078: WHEN NO_DATA_FOUND THEN
2079: if p_calling_module = 'FORM' then
2080: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
2081: p_msg_name => 'FORM_RECORD_CHANGED');
2082: x_msg_data := 'FORM_RECORD_CHANGED';
2083: else
2084: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

2080: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
2081: p_msg_name => 'FORM_RECORD_CHANGED');
2082: x_msg_data := 'FORM_RECORD_CHANGED';
2083: else
2084: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2085: p_msg_name => 'PA_XC_RECORD_CHANGED');
2086: x_msg_data := 'PA_XC_RECORD_CHANGED';
2087: end if;
2088: x_return_status := 'E' ;

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

2087: end if;
2088: x_return_status := 'E' ;
2089: WHEN OTHERS THEN
2090: IF SQLCODE = -54 THEN
2091: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2092: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2093: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2094: x_return_status := 'E' ;
2095: ELSE

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

2105: AND wbs_record_version_number = p_wbs_record_version_number;
2106: EXCEPTION
2107: WHEN NO_DATA_FOUND THEN
2108: if p_calling_module = 'FORM' then
2109: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
2110: p_msg_name => 'FORM_RECORD_CHANGED');
2111: x_msg_data := 'FORM_RECORD_CHANGED';
2112: else
2113: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

2109: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
2110: p_msg_name => 'FORM_RECORD_CHANGED');
2111: x_msg_data := 'FORM_RECORD_CHANGED';
2112: else
2113: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2114: p_msg_name => 'PA_XC_RECORD_CHANGED');
2115: x_msg_data := 'PA_XC_RECORD_CHANGED';
2116: end if;
2117: x_return_status := 'E' ;

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

2116: end if;
2117: x_return_status := 'E' ;
2118: WHEN OTHERS THEN
2119: IF SQLCODE = -54 THEN
2120: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2121: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2122: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2123: x_return_status := 'E' ;
2124: END IF;

Line 2501: PA_UTILS.ADD_MESSAGE

2497: p_end_date < x_ei_date ) THEN
2498: close cur_date;
2499: -- Start Changes for bug 6467429
2500: l_task_num := pa_task_utils.get_task_number(p_task_id);
2501: PA_UTILS.ADD_MESSAGE
2502: (p_app_short_name => 'PA',
2503: p_msg_name => 'PA_EI_INVALID_DATES_TSK',
2504: p_token1 => 'TASKNUM',
2505: p_value1 => l_task_num,

Line 2510: PA_UTILS.ADD_MESSAGE

2506: p_token2 => 'EIFINISHDATE',
2507: p_value2 => x_ei_date);
2508: x_msg_data := 'PA_EI_INVALID_DATES_TSK';
2509: /*
2510: PA_UTILS.ADD_MESSAGE
2511: (p_app_short_name => 'PA',
2512: p_msg_name => 'PA_EI_INVALID_DATES',
2513: p_token1 => 'EIDATE',
2514: p_value1 => x_ei_date);

Line 2591: PA_UTILS.ADD_MESSAGE

2587: p_start_date > x_ei_min_date ) THEN
2588: close cur_start_date;
2589: -- Start Changes for Bug 6633233
2590: l_task_num := pa_task_utils.get_task_number(p_task_id);
2591: PA_UTILS.ADD_MESSAGE
2592: (p_app_short_name => 'PA',
2593: p_msg_name => 'PA_EI_INVALID_START_DATE_TSK',
2594: p_token1 => 'TASKNUM',
2595: p_value1 => l_task_num,

Line 2600: PA_UTILS.ADD_MESSAGE

2596: p_token2 => 'EISTARTDATE',
2597: p_value2 => x_ei_min_date);
2598: x_msg_data := 'PA_EI_INVALID_START_DATE_TSK';
2599: /*
2600: PA_UTILS.ADD_MESSAGE
2601: (p_app_short_name => 'PA',
2602: p_msg_name => 'PA_EI_INVALID_START_DATE',
2603: p_token1 => 'EISTARTDATE',
2604: p_value1 => x_ei_min_date);