[Home] [Help]
409: END IF;
410:
411: IF p_object_type <> 'PA_TASKS'
412: THEN
413: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NOT_TASK_OBJECT');
414: l_msg_data := 'PA_PS_NOT_TASK_OBJECT';
415: END IF;
416:
417: --hsiu: bug 2669388
437: /*Bug 11676550. ENDS HERE */
438:
439: IF p_task_number IS NULL
440: THEN
441: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
442: p_msg_name => 'PA_PS_TASK_NUMBER_NULL');
443: raise FND_API.G_EXC_ERROR;
444: END IF;
445:
445:
446: --dbms_output.put_line('task name');
447: IF p_task_name IS NULL
448: THEN
449: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
450: p_msg_name => 'PA_PS_TASK_NAME_NULL');
451: raise FND_API.G_EXC_ERROR;
452: END IF;
453:
464: ) = 'N'
465: THEN
466: IF p_pm_product_code = 'MSPROJECT'
467: THEN
468: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
469: ,p_msg_name => 'PA_PS_TASK_NOT_NUM_UNIQ_MSP' -- Bug 6497559
470: ,p_token1 => 'TASK_NAME'
471: ,p_value1 => la_task_name
472: ,p_token2 => 'TASK_NUMBER'
473: ,p_value2 => l_task_number
474: );
475: raise FND_API.G_EXC_ERROR;
476: ELSE
477: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
478: ,p_msg_name => 'PA_PS_TASK_NOT_NUM_UNIQ_AMG' -- Bug 6497559
479: ,p_token1 => 'TASK_ID'
480: ,p_value1 => x_task_id
481: );
490: NULL,
491: p_project_id,
492: p_structure_id) <> 'Y') THEN
493: --Name is not unique
494: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_TASK_NUMBER_UNIQUE');
495: l_msg_data := 'PA_PS_TASK_NUMBER_UNIQUE';
496: /* bug 3459905 Check if there is any error. */
497: l_msg_count := FND_MSG_PUB.count_msg;
498: IF l_msg_count > 0 THEN
966: ,l_return_status
967: ,l_error_message_code );
968:
969: IF (l_return_status <> 'Y') THEN
970: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
971: p_msg_name => l_error_message_code);
972: raise FND_API.G_EXC_ERROR;
973: END IF;
974: END IF; -- 13102269: bypassing all validations of Check_create_subtask_ok API for peer task. end.
1184: --( l_dummy_char2 IS NOT NULL ) --is a structure version id not a valid ref task id from pa_task
1185: THEN
1186: --Not a valid ref task. Tasks exists in pa_tasks
1187: --dbms_output.put_line('error with ref tsk');
1188: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_INV_REF_TASK_ID');
1189: l_msg_data := 'PA_PS_INV_REF_TASK_ID';
1190: -- start of bug 3459905
1191: --Check if there is any error.
1192: l_msg_count := FND_MSG_PUB.count_msg;
1977: p_task_id,
1978: v_cur_proj_elems_rec.project_id,
1979: v_cur_proj_elems_rec.PARENT_STRUCTURE_ID) <> 'Y') THEN
1980: --Name is not unique
1981: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_TASK_NUMBER_UNIQUE');
1982: l_msg_data := 'PA_PS_TASK_NUMBER_UNIQUE';
1983: -- start of bug 3459905
1984: l_msg_count := FND_MSG_PUB.count_msg;
1985: IF l_msg_count > 0 THEN
2014: -- check if it is top task
2015: IF ('N' = pa_proj_elements_utils.IS_TOP_TASK_ACROSS_ALL_VER(
2016: p_task_id)) THEN
2017: --Is not a top task across all versions. Error
2018: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_NOT_ALL_TOP_TASKS');
2019: -- start of bug 3459905
2020: --Check if there is any error.
2021: l_msg_count := FND_MSG_PUB.count_msg;
2022: IF l_msg_count > 0 THEN
2033: IF ('Y' = pa_proj_elements_utils.CHECK_PHASE_IN_USE(
2034: p_task_id,
2035: p_phase_version_id)) THEN
2036: -- Phase already in use in the structure. Error
2037: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_PHASE_IN_USE');
2038: -- start of bug 3459905
2039: --Check if there is any error.
2040: l_msg_count := FND_MSG_PUB.count_msg;
2041: IF l_msg_count > 0 THEN
2133: x_msg_data => l_msg_data
2134: );
2135:
2136: IF (l_change_allowed = 'N') THEN
2137: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_CHG_TASK_TYPE_ERR');
2138: l_msg_data := 'PA_PS_CHG_TASK_TYPE_ERR';
2139: --Check if there is any error.
2140: -- start of bug 3459905
2141: l_msg_count := FND_MSG_PUB.count_msg;
2149: -- end of bug 3459905
2150: END IF;
2151:
2152: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_effective(p_type_id)) THEN
2153: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_EFF_TASK_TYPE_ERR');
2154: l_msg_data := 'PA_PS_EFF_TASK_TYPE_ERR';
2155: -- start of bug 3459905
2156: --Check if there is any error.
2157: l_msg_count := FND_MSG_PUB.count_msg;
2372: -- Amit : Code added so that task status can't be changed for a cancelled task
2373: IF (v_cur_proj_elems_rec.STATUS_CODE <> p_STATUS_CODE AND
2374: PA_PROGRESS_UTILS.get_system_task_status(v_cur_proj_elems_rec.STATUS_CODE)= 'CANCELLED')
2375: THEN
2376: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2377: p_msg_name => 'PA_TSK_STS_CANT_CHANGED');
2378: raise FND_API.G_EXC_ERROR;
2379: END IF;
2380: --marked as changed only if different
2400: l_del_cnt:=PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hie_upd(l_task_version_id);
2401: -- IF l_del_cnt >=1 AND p_Base_Perc_Comp_Deriv_Code LIKE 'DELIVERABLE' THEN --Jun 28th
2402: IF l_del_cnt >=1 AND (p_Base_Perc_Comp_Deriv_Code LIKE 'DELIVERABLE'
2403: OR l_tt_base_perc_comp_der_cd LIKE 'DELIVERABLE' ) THEN --Jun 28th
2404: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2405: p_msg_name => 'PA_PS_CHK_DELIV_UPDATE');
2406: raise FND_API.G_EXC_ERROR;
2407: END IF;
2408: END LOOP;
2415: l_del_cnt:=PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hie_upd(l_task_version_id);
2416: -- IF l_del_cnt >=1 AND p_Base_Perc_Comp_Deriv_Code LIKE 'DELIVERABLE' THEN --Jun 28th
2417: IF l_del_cnt >=1 AND (p_Base_Perc_Comp_Deriv_Code LIKE 'DELIVERABLE'
2418: OR l_tt_base_perc_comp_der_cd LIKE 'DELIVERABLE' ) THEN --Jun 28th
2419: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2420: p_msg_name => 'PA_PS_CHK_DELIV_UPDATE');
2421: raise FND_API.G_EXC_ERROR;
2422: END IF;
2423: END LOOP;
2827: -- Bug#3491609 : Workflow Chanegs FP M
2828: );
2829: ELSE
2830: CLOSE cur_proj_elems;
2831: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_INVALID_TASK_ID');
2832: l_msg_data := 'PA_PS_INVALID_TASK_ID';
2833: RAISE FND_API.G_EXC_ERROR;
2834: END IF;
2835:
3123: ,x_return_status => l_return_status
3124: ,x_error_message_code => l_error_message_code
3125: );
3126: IF (l_return_status <> 'S') THEN
3127: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3128: p_msg_name => l_error_message_code);
3129: raise FND_API.G_EXC_ERROR;
3130: END IF;
3131: END IF;
3527: FETCH get_task_detail INTO l_base_deriv_code;
3528: CLOSE get_task_detail;
3529: IF l_base_deriv_code LIKE 'DELIVERABLE' THEN
3530: IF PA_PROJ_ELEMENTS_UTILS.check_task_parents_deliv(l_ref_parent_task_ver_id) = 'Y' THEN
3531: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3532: p_msg_name => 'PA_TASK_AND_PARENTTASK_DEL');
3533: raise FND_API.G_EXC_ERROR;
3534: END IF;
3535: END IF;
3624: ,x_error_message_code => l_error_message_code
3625: );
3626:
3627: IF (l_return_status <> 'Y') THEN
3628: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3629: p_msg_name => l_error_message_code);
3630: raise FND_API.G_EXC_ERROR;
3631: END IF;
3632: END IF;
3656: ,x_error_message_code => l_error_message_code
3657: );
3658:
3659: IF (l_return_status <> 'Y') THEN
3660: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3661: p_msg_name => l_error_message_code);
3662: raise FND_API.G_EXC_ERROR;
3663: END IF;
3664: END IF;
3875: END IF;
3876: END IF; -- end changes for bug 13923366
3877: ELSE
3878: CLOSE cur_proj_elems;
3879: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_INV_REF_TASK_ID');
3880: l_msg_data := 'PA_PS_INV_REF_TASK_ID';
3881: RAISE FND_API.G_EXC_ERROR;
3882: END IF;
3883: CLOSE cur_proj_elems;
4273: --Bug No 3450684 Smukka 04/Mar/04 Checking for deliverable
4274: --Bug No 3475920 SMukka Commented out following logic to check for deliverable.
4275: -- IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,p_task_version_id) = 'Y' THEN
4276: -- IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,p_ref_task_version_id) = 'Y' THEN
4277: -- PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4278: -- p_msg_name => 'PA_PS_CHK_DELIV_UPDATE');
4279: -- raise FND_API.G_EXC_ERROR;
4280: -- END IF;
4281:
4584: END;
4585: END IF; --<< p_action = MOVE >>;
4586: ELSE
4587: CLOSE cur_proj_elems;
4588: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_INVALID_TASK_ID');
4589: l_msg_data := 'PA_PS_INVALID_TASK_ID';
4590: RAISE FND_API.G_EXC_ERROR;
4591: END IF;
4592: CLOSE cur_proj_elems;
4591: END IF;
4592: CLOSE cur_proj_elems;
4593: -- ELSE
4594: -- CLOSE cur_ref_task;
4595: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_INV_REF_TASK_ID');
4596: -- l_msg_data := 'PA_PS_INV_REF_TASK_ID';
4597: -- RAISE FND_API.G_EXC_ERROR;
4598: -- END IF;
4599:
4676: ,x_msg_count => l_msg_count
4677: ,x_msg_data => l_msg_data
4678: );
4679: IF l_return_status <> 'S' THEN
4680: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4681: p_msg_name => 'PA_ERROR_REFRESHING_STRUCTURE');
4682: RAISE FND_API.G_EXC_ERROR;
4683: END IF;
4684: end if;
5694: p_structure_version_id,
5695: p_task_version_id)) THEN
5696: --deleting linked task. Error
5697: x_return_status := FND_API.G_RET_STS_ERROR;
5698: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NO_DEL_LINKED_TASK');
5699: l_msg_data := 'PA_PS_NO_DEL_LINKED_TASK';
5700: RAISE FND_API.G_EXC_ERROR;
5701: END IF;
5702: END IF;
5932:
5933: --dbms_output.put_line('status = '||l_return_status||','||l_error_message_code);
5934: IF (l_return_status <> 'S') THEN
5935: x_return_status := l_return_status;
5936: PA_UTILS.ADD_MESSAGE('PA', l_error_message_code);
5937: l_msg_data := l_error_message_code;
5938: RAISE FND_API.G_EXC_ERROR;
5939: END IF;
5940: */
6618: AND (display_sequence > l_selected_seq_num)
6619: AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N';
6620: EXCEPTION
6621: WHEN OTHERS THEN
6622: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
6623: raise FND_API.G_EXC_ERROR;
6624: END;
6625:
6626: END IF; -- End of changes for bug 13923366
7201: ELSE
7202: l_ext_act_duration := p_ext_act_duration;
7203: --hsiu: bug 3638195
7204: IF l_ext_act_duration < 0 THEN
7205: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NEG_EXT_ACT_ERR');
7206: l_msg_data := l_error_message_code;
7207: RAISE FND_API.G_EXC_ERROR;
7208: END IF;
7209: END IF;
7214: ELSE
7215: l_ext_remain_duration := p_ext_remain_duration;
7216: --hsiu: bug 3638195
7217: IF l_ext_remain_duration < 0 THEN
7218: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NEG_EXT_RMN_ERR');
7219: l_msg_data := l_error_message_code;
7220: RAISE FND_API.G_EXC_ERROR;
7221: END IF;
7222: END IF;
7227: ELSE
7228: l_ext_sch_duration := p_ext_sch_duration;
7229: --hsiu: bug 3638195
7230: IF l_ext_sch_duration < 0 THEN
7231: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NEG_EXT_SCH_ERR');
7232: l_msg_data := l_error_message_code;
7233: RAISE FND_API.G_EXC_ERROR;
7234: END IF;
7235: END IF;
7349: ,x_return_status => l_return_status
7350: ,x_error_message_code => l_error_message_code );
7351:
7352: IF (l_return_status <> 'S') THEN
7353: PA_UTILS.ADD_MESSAGE('PA', l_error_message_code);
7354: l_msg_data := l_error_message_code;
7355: RAISE FND_API.G_EXC_ERROR;
7356: END IF;
7357:
7486:
7487: /* IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
7488: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(l_project_id)) THEN
7489: --error message
7490: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_CANT_ENT_WQ_ATTR1');
7491: x_msg_data := 'PA_PS_CANT_ENT_WQ_ATTR1';
7492: RAISE FND_API.G_EXC_ERROR;
7493: ELSE */
7494: -- Above code is commented and moved below to first check whether any value has been passed in p_wq_planned_quantity
7507: IF (l_wq_planned_quantity IS NOT NULL) THEN
7508: /*
7509: IF (l_wq_planned_quantity < 0) THEN
7510: --error message
7511: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NEG_PLAN_QTY_ERR');
7512: x_msg_data := 'PA_PS_NEG_PLAN_QTY_ERR';
7513: RAISE FND_API.G_EXC_ERROR;
7514: -- Else condition added for Bug No. : 2791413
7515: ELSE
7516: */
7517: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
7518: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(l_project_id)) THEN
7519: --error message
7520: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_CANT_ENT_WQ_ATTR1');
7521: x_msg_data := 'PA_PS_CANT_ENT_WQ_ATTR1';
7522: RAISE FND_API.G_EXC_ERROR;
7523: End IF;
7524: -- END IF;
7537: /*
7538: IF (l_planned_effort IS NOT NULL) THEN
7539: IF (l_planned_effort < 0) THEN
7540: --error message
7541: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NEG_PLAN_EFF_ERR');
7542: x_msg_data := 'PA_PS_NEG_PLAN_EFF_ERR';
7543: RAISE FND_API.G_EXC_ERROR;
7544: END IF;
7545: END IF;
7682: ,X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
7683: );
7684: ELSE
7685: CLOSE cur_proj_elem_ver;
7686: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_INVALID_TASK_ID');
7687: l_msg_data := 'PA_PS_INVALID_TASK_ID';
7688: RAISE FND_API.G_EXC_ERROR;
7689: END IF;
7690: CLOSE cur_proj_elem_ver;
7994:
7995: /* IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
7996: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(cur_val_rec.project_id)) THEN
7997: -- Bug 2791413 Added error message
7998: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_CANT_ENT_WQ_ATTR1');
7999: x_msg_data := 'PA_PS_CANT_ENT_WQ_ATTR1';
8000: RAISE FND_API.G_EXC_ERROR;
8001: ELSE
8002: IF (p_wq_planned_quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
8012: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(cur_val_rec.project_id)) THEN
8013: -- If condition added for Bug No. : 2791413
8014: IF (p_wq_planned_quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_wq_planned_quantity IS NOT NULL) THEN
8015: -- Bug 2791413 Added error message
8016: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_CANT_ENT_WQ_ATTR1');
8017: x_msg_data := 'PA_PS_CANT_ENT_WQ_ATTR1';
8018: RAISE FND_API.G_EXC_ERROR;
8019: END IF;
8020: l_wq_planned_quantity := NULL;
8033: /*
8034: IF (l_wq_planned_quantity IS NOT NULL) THEN
8035: IF (l_wq_planned_quantity < 0) THEN
8036: --error message
8037: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NEG_PLAN_QTY_ERR');
8038: x_msg_data := 'PA_PS_NEG_PLAN_QTY_ERR';
8039: RAISE FND_API.G_EXC_ERROR;
8040: END IF;
8041: END IF;
8169: IF l_scheduled_start_date IS NULL
8170: THEN
8171: -- For bug 2625650
8172: -- l_scheduled_start_date := cur_val_rec.SCHEDULED_START_DATE;
8173: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_SCH_DATES_REQD');
8174: l_msg_data := 'PA_PS_SCH_DATES_REQD';
8175: RAISE FND_API.G_EXC_ERROR;
8176: -- End of bug fix
8177: -- ELSE
8182: IF l_scheduled_end_date IS NULL
8183: THEN
8184: -- For bug 2625650
8185: --l_scheduled_end_date := cur_val_rec.SCHEDULED_FINISH_DATE;
8186: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_SCH_DATES_REQD');
8187: l_msg_data := 'PA_PS_SCH_DATES_REQD';
8188: RAISE FND_API.G_EXC_ERROR;
8189: -- End of bug fix
8190: -- ELSE
8288: l_ext_act_duration := cur_val_rec.ext_act_duration;
8289: ELSE
8290: l_ext_act_duration := p_ext_act_duration;
8291: IF l_ext_act_duration < 0 THEN
8292: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NEG_EXT_ACT_ERR');
8293: l_msg_data := l_error_message_code;
8294: RAISE FND_API.G_EXC_ERROR;
8295: END IF;
8296: END IF;
8300: l_ext_remain_duration := cur_val_rec.ext_remain_duration;
8301: ELSE
8302: l_ext_remain_duration := p_ext_remain_duration;
8303: IF l_ext_remain_duration < 0 THEN
8304: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NEG_EXT_RMN_ERR');
8305: l_msg_data := l_error_message_code;
8306: RAISE FND_API.G_EXC_ERROR;
8307: END IF;
8308: END IF;
8312: l_ext_sch_duration := cur_val_rec.ext_sch_duration;
8313: ELSE
8314: l_ext_sch_duration := p_ext_sch_duration;
8315: IF l_ext_sch_duration < 0 THEN
8316: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NEG_EXT_SCH_ERR');
8317: l_msg_data := l_error_message_code;
8318: RAISE FND_API.G_EXC_ERROR;
8319: END IF;
8320: END IF;
8492: ,x_return_status => l_return_status
8493: ,x_error_message_code => l_error_message_code );
8494:
8495: IF (l_return_status <> 'S') THEN
8496: PA_UTILS.ADD_MESSAGE('PA', l_error_message_code);
8497: l_msg_data := l_error_message_code;
8498: RAISE FND_API.G_EXC_ERROR;
8499: END IF;
8500:
8679: /*
8680: IF (l_planned_effort IS NOT NULL) THEN
8681: IF (l_planned_effort < 0) THEN
8682: --error message
8683: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NEG_PLAN_EFF_ERR');
8684: x_msg_data := 'PA_PS_NEG_PLAN_EFF_ERR';
8685: RAISE FND_API.G_EXC_ERROR;
8686: END IF;
8687: END IF;
8926: ,X_ATTRIBUTE15 => l_ATTRIBUTE15
8927: );
8928: ELSE
8929: CLOSE cur_proj_elem_ver_sch;
8930: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_INV_PEV_SCH_ID');
8931: l_msg_data := 'PA_PS_INV_PEV_SCH_ID';
8932: RAISE FND_API.G_EXC_ERROR;
8933: END IF;
8934:
9955: x_err_stage => l_err_stage,
9956: x_err_stack => l_err_stack);
9957:
9958: If (l_err_code <> 0) THEN
9959: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9960: p_msg_name => substrb(l_err_stage,1,30)); --3935874 : Changed Substr to Substrb
9961: CLOSE cur_pa_tasks;
9962: raise FND_API.G_EXC_ERROR;
9963: END IF;
10273: AND (display_sequence > l_selected_seq_num)
10274: AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N';
10275: EXCEPTION
10276: WHEN OTHERS THEN
10277: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
10278: raise FND_API.G_EXC_ERROR;
10279: END;
10280:
10281: --hsiu added, for dates rollup