200:
201:
202: x_msg_count := 0;
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
204: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
205:
206: IF l_debug_mode = 'Y' THEN
207: PA_DEBUG.set_curr_function( p_function => 'CHECK_CREATE_MAPPING_OK',
208: p_debug_mode => l_debug_mode );
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
204: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
205:
206: IF l_debug_mode = 'Y' THEN
207: PA_DEBUG.set_curr_function( p_function => 'CHECK_CREATE_MAPPING_OK',
208: p_debug_mode => l_debug_mode );
209: END IF;
210:
211: IF l_debug_mode = 'Y' THEN
208: p_debug_mode => l_debug_mode );
209: END IF;
210:
211: IF l_debug_mode = 'Y' THEN
212: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_UTILS : CHECK_CREATE_MAPPING_OK : Printing Input parameters';
213: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
214: l_debug_level3);
215:
216: Pa_Debug.WRITE(g_module_name,'p_task_version_id_WP'||':'||p_task_version_id_WP,
209: END IF;
210:
211: IF l_debug_mode = 'Y' THEN
212: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_UTILS : CHECK_CREATE_MAPPING_OK : Printing Input parameters';
213: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
214: l_debug_level3);
215:
216: Pa_Debug.WRITE(g_module_name,'p_task_version_id_WP'||':'||p_task_version_id_WP,
217: l_debug_level3);
212: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_UTILS : CHECK_CREATE_MAPPING_OK : Printing Input parameters';
213: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
214: l_debug_level3);
215:
216: Pa_Debug.WRITE(g_module_name,'p_task_version_id_WP'||':'||p_task_version_id_WP,
217: l_debug_level3);
218:
219: Pa_Debug.WRITE(g_module_name,'p_task_version_id_FP'||':'||p_task_version_id_FP,
220: l_debug_level3);
215:
216: Pa_Debug.WRITE(g_module_name,'p_task_version_id_WP'||':'||p_task_version_id_WP,
217: l_debug_level3);
218:
219: Pa_Debug.WRITE(g_module_name,'p_task_version_id_FP'||':'||p_task_version_id_FP,
220: l_debug_level3);
221: END IF;
222:
223:
221: END IF;
222:
223:
224: IF l_debug_mode = 'Y' THEN
225: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_UTILS : CHECK_CREATE_MAPPING_OK : Validating Business rule: Financial task is lowest';
226: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
227: l_debug_level3);
228: END IF;
229:
222:
223:
224: IF l_debug_mode = 'Y' THEN
225: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_UTILS : CHECK_CREATE_MAPPING_OK : Validating Business rule: Financial task is lowest';
226: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
227: l_debug_level3);
228: END IF;
229:
230: -- Check for FP TASK to be lowest
241:
242:
243: IF (l_debug_mode = 'Y') THEN
244:
245: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_UTILS : CHECK_CREATE_MAPPING_OK : Validating Business rule: Duplicate mapping exists for WP task';
246: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level3);
247: END IF;
248:
249:
242:
243: IF (l_debug_mode = 'Y') THEN
244:
245: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_UTILS : CHECK_CREATE_MAPPING_OK : Validating Business rule: Duplicate mapping exists for WP task';
246: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level3);
247: END IF;
248:
249:
250: --This loop checks for if any mapping already exists either on upper or lower ladder for the passed WP task id
284: ,p_procedure_name => 'CHECK_CREATE_MAPPING_OK'
285: ,p_error_text => x_msg_data);
286:
287: IF l_debug_mode = 'Y' THEN
288: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
289: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
290: l_debug_level5);
291: Pa_Debug.reset_curr_function;
292: END IF;
285: ,p_error_text => x_msg_data);
286:
287: IF l_debug_mode = 'Y' THEN
288: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
289: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
290: l_debug_level5);
291: Pa_Debug.reset_curr_function;
292: END IF;
293: RAISE;
287: IF l_debug_mode = 'Y' THEN
288: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
289: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
290: l_debug_level5);
291: Pa_Debug.reset_curr_function;
292: END IF;
293: RAISE;
294:
295: END CHECK_CREATE_MAPPING_OK;