210: l_unique_record VARCHAR2(1);
211:
212: BEGIN
213:
214: g1_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
215:
216: IF g1_debug_mode = 'Y' THEN
217: pa_debug.init_err_stack ('PA_PROGRESS_PUB.UPDATE_PROGRESS');
218: END IF;
1608: l_ACTUAL_EFFORT_TO_DATE NUMBER;
1609:
1610: BEGIN
1611:
1612: g1_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1613:
1614: IF g1_debug_mode = 'Y' THEN
1615: pa_debug.init_err_stack ('PA_PROGRESS_PUB.LOAD_TASK_PROGRESS');
1616: END IF;
2138: IF FND_API.to_boolean(p_init_msg_list)
2139: THEN
2140: FND_MSG_PUB.initialize;
2141: END IF;
2142: g1_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2143: savepoint Execute_Update_Task_Progress;
2144:
2145:
2146: p_return_status := FND_API.G_RET_STS_SUCCESS;
3391: end;
3392:
3393:
3394: -- Set the G_ROLLUP_FLAG based on profile options
3395: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
3396: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
3397: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'PROGRESS',x_msg_data,x_return_status);
3398: IF x_return_status <> 'S'
3399: THEN