eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TIMELINE_PVT dependencies on FND_API

Line 35: x_return_status := FND_API.G_RET_STS_SUCCESS;

31:
32: l_sum NUMBER :=0;
33:
34: BEGIN
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36:
37: SELECT start_date, end_date
38: INTO l_start_date, l_end_date
39: FROM pa_project_assignments

Line 43: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

39: FROM pa_project_assignments
40: WHERE assignment_id = p_assignment_id;
41:
42: -- Generate forecast items.
43: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
44: PA_FORECASTITEM_PVT.Create_Forecast_Item(
45: p_assignment_id => p_assignment_id,
46: p_start_date => l_start_date,
47: p_end_date => l_end_date,

Line 54: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

50: x_msg_count => x_msg_count,
51: x_msg_data => x_msg_data);
52: END IF;
53:
54: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
55: -- Compute assignment effort and update pa_project_assignments table.
56:
57: l_sum := PA_SCHEDULE_UTILS.get_num_hours(
58: p_project_id => null,

Line 71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

67: EXCEPTION
68: WHEN OTHERS THEN
69: x_msg_count := 1;
70: x_msg_data := sqlerrm;
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TIMELINE_PVT',
73: p_procedure_name => 'Create_Timeline assignment');
74: RAISE;
75:

Line 130: x_return_status := FND_API.G_RET_STS_SUCCESS;

126: l_no_timeline_to_create EXCEPTION;
127: l_debug_mode VARCHAR2(20) := 'N';
128:
129: BEGIN
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132: -- Add the following two lines so that debug messages get written to the log file.
133: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
134: IF l_debug_mode = 'Y' THEN -- Added for bug 4345291

Line 218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

214:
215: WHEN OTHERS THEN
216: x_msg_count := 1;
217: x_msg_data := sqlerrm;
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TIMELINE_PVT',
220: p_procedure_name => 'Create_Timeline Resource');
221: RAISE;
222:

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

266: li_commit_size NUMBER:=1;
267: pi_commit_size NUMBER :=1000;
268:
269: BEGIN
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271: pa_timeline_util.debug('Start Date and Time ' || TO_CHAR(SYSDATE,'DD-MON-YYYY HH:MM:SS'));
272:
273: FOR cur_clndar_rec IN cur_clndar LOOP
274:

Line 299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

295: EXCEPTION
296: WHEN OTHERS THEN
297: x_msg_count := 1;
298: x_msg_data := sqlerrm;
299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
300: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TIMELINE_PVT',
301: p_procedure_name => 'Create_Timeline Calendar');
302: RAISE;
303:

Line 316: x_return_status := FND_API.G_RET_STS_SUCCESS;

312: l_start_date DATE;
313: l_end_date DATE;
314: l_resource_id NUMBER;
315: BEGIN
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317:
318: PA_FORECASTITEM_PVT.Delete_FI (p_assignment_id => p_assignment_id ,
319: x_return_status => x_return_status,
320: x_msg_count => x_msg_count,

Line 324: IF (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

320: x_msg_count => x_msg_count,
321: x_msg_data => x_msg_data);
322:
323: -- Regenerate Resource FIs for the period
324: IF (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
325: select start_date, end_date, resource_id
326: into l_start_date, l_end_date, l_resource_id
327: from pa_project_assignments
328: where assignment_id = p_assignment_id;

Line 346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

342: EXCEPTION
343: WHEN OTHERS THEN
344: x_msg_count := 1;
345: x_msg_data := sqlerrm;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TIMELINE_PVT',
348: p_procedure_name => 'Delete_Timeline');
349: RAISE;
350:

Line 373: x_return_status := FND_API.G_RET_STS_SUCCESS;

369: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
370: IS
371:
372: BEGIN
373: x_return_status := FND_API.G_RET_STS_SUCCESS;
374:
375: PA_FORECASTITEM_PVT.copy_requirement_fi(p_requirement_id_tbl => p_assignment_id_tbl,
376: p_requirement_source_id => p_assignment_source_id,
377: x_return_status => x_return_status,

Line 385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

381: EXCEPTION
382: WHEN OTHERS THEN
383: x_msg_count := 1;
384: x_msg_data := sqlerrm;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TIMELINE_PVT',
387: p_procedure_name => 'Copy_Open_Asgn_Timeline');
388: RAISE;
389:

Line 439: x_return_status := FND_API.G_RET_STS_SUCCESS;

435: l_count NUMBER;
436: prm_license VARCHAR(1);
437:
438: BEGIN
439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440: pa_timeline_util.debug('************************************');
441: pa_timeline_util.debug('Entering populate_time_chart_table');
442: pa_timeline_util.debug('p_timeline_type: '|| p_timeline_type);
443: pa_timeline_util.debug('p_resource_id: ' || p_resource_id);

Line 3145: x_return_status := FND_API.G_RET_STS_SUCCESS;

3141:
3142: END LOOP;
3143: END IF;
3144:
3145: x_return_status := FND_API.G_RET_STS_SUCCESS;
3146: EXCEPTION
3147: WHEN OTHERS THEN
3148: x_msg_count := 1;
3149: x_msg_data := sqlerrm;

Line 3150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3146: EXCEPTION
3147: WHEN OTHERS THEN
3148: x_msg_count := 1;
3149: x_msg_data := sqlerrm;
3150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3151: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TIMELINE_PVT',
3152: p_procedure_name => 'Poplulate_Time_Chart_Table');
3153: RAISE;
3154: