499: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
500: END IF;
501: --dbms_output.put_line('Project Id:' || l_project_id);
502:
503: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN
504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
505: THEN
506: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS N..');
507: pa_interface_utils_pub.map_new_amg_msg
502:
503: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN
504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
505: THEN
506: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS N..');
507: pa_interface_utils_pub.map_new_amg_msg
508: ( p_old_message_code => 'PA_PS_WP_NOT_SEP_FN_AMG'
509: ,p_msg_attribute => 'CHANGE'
510: ,p_resize_flag => 'N'
517: END IF;
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520:
521: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS Fine..');
522: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
523: pa_debug.g_err_stage:='PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS function check successful.' || L_FuncProc;
524: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
525: END IF;
519: END IF;
520:
521: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS Fine..');
522: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
523: pa_debug.g_err_stage:='PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS function check successful.' || L_FuncProc;
524: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
525: END IF;
526:
527: IF p_pa_structure_version_id IS NOT NULL AND