DBA Data[Home] [Help]

APPS.PA_WORKPLAN_WORKFLOW dependencies on FND_PROFILE

Line 292: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

288: where project_id = l_project_id
289: and WP_AUTO_PUBLISH_FLAG = 'Y';
290:
291: -- 4609421 : Following three variables
292: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
293: l_msg_index_out NUMBER;
294: l_data VARCHAR2(300);
295:
296: BEGIN

Line 754: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

750:
751: BEGIN
752: x_msg_count := 0;
753: x_return_status := FND_API.G_RET_STS_SUCCESS;
754: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
755:
756: IF l_debug_mode = 'Y' THEN
757: PA_DEBUG.set_curr_function( p_function => 'START_PROJECT_EXECUTION_WF',
758: p_debug_mode => l_debug_mode );

Line 968: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

964: get_all_tasks_rec get_all_tasks%ROWTYPE ;
965:
966: BEGIN
967:
968: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
969:
970: IF l_debug_mode = 'Y' THEN
971: PA_DEBUG.set_curr_function( p_function => 'START_TASK_EXECUTION_WF',
972: p_debug_mode => l_debug_mode );

Line 1127: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

1123: task_info_rec task_info%ROWTYPE ;
1124:
1125: BEGIN
1126:
1127: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1128:
1129: IF l_debug_mode = 'Y' THEN
1130: PA_DEBUG.set_curr_function( p_function => 'RESTART_TASK_EXECUTION_WF',
1131: p_debug_mode => l_debug_mode );

Line 1250: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

1246:
1247: BEGIN
1248:
1249: x_return_status := FND_API.g_ret_sts_success;
1250: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1251:
1252: IF l_debug_mode = 'Y' THEN
1253: Pa_Debug.g_err_stage:= 'CANCEL_TASK_EXECUTION_WF : Cancel Task Execution Workflow';
1254: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

Line 1306: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

1302: proj_status_cur_rec proj_status_cur%ROWTYPE ;
1303:
1304: BEGIN
1305:
1306: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1307:
1308: IF l_debug_mode = 'Y' THEN
1309: PA_DEBUG.set_curr_function( p_function => 'IS_PROJECT_CLOSED',
1310: p_debug_mode => l_debug_mode );