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 269: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 315: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 372: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 438: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3090: x_return_status := FND_API.G_RET_STS_SUCCESS;

3086:
3087: END LOOP;
3088: END IF;
3089:
3090: x_return_status := FND_API.G_RET_STS_SUCCESS;
3091: EXCEPTION
3092: WHEN OTHERS THEN
3093: x_msg_count := 1;
3094: x_msg_data := sqlerrm;

Line 3095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3091: EXCEPTION
3092: WHEN OTHERS THEN
3093: x_msg_count := 1;
3094: x_msg_data := sqlerrm;
3095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3096: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_TIMELINE_PVT',
3097: p_procedure_name => 'Poplulate_Time_Chart_Table');
3098: RAISE;
3099: