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 PA_TIMELINE_UTIL

Line 138: pa_timeline_util.debug(' Entering Create_Timeline for resource id or resource names ');

134: IF l_debug_mode = 'Y' THEN -- Added for bug 4345291
135: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
136: END IF;
137:
138: pa_timeline_util.debug(' Entering Create_Timeline for resource id or resource names ');
139: g_TimelineProfileSetup := PA_TIMELINE_UTIL.get_timeline_profile_setup;
140: availability_duration := nvl(g_TimelineProfileSetup.availability_duration,0);
141:
142: -- 2196924: If dates are null or greater than avail period,

Line 139: g_TimelineProfileSetup := PA_TIMELINE_UTIL.get_timeline_profile_setup;

135: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
136: END IF;
137:
138: pa_timeline_util.debug(' Entering Create_Timeline for resource id or resource names ');
139: g_TimelineProfileSetup := PA_TIMELINE_UTIL.get_timeline_profile_setup;
140: availability_duration := nvl(g_TimelineProfileSetup.availability_duration,0);
141:
142: -- 2196924: If dates are null or greater than avail period,
143: -- then default to availability period.

Line 146: pa_timeline_util.debug('availability_duration = 0');

142: -- 2196924: If dates are null or greater than avail period,
143: -- then default to availability period.
144:
145: if (availability_duration = 0) then
146: pa_timeline_util.debug('availability_duration = 0');
147: raise l_no_timeline_to_create;
148: end if;
149:
150: ld_start_date := NVL(p_start_date, ADD_MONTHS(sysdate, -12));

Line 166: ld_start_date := PA_TIMELINE_UTIL.Get_Week_End_Date(

162: raise l_no_timeline_to_create;
163: end if;
164:
165: /* 2196924: No longer necessary to find end date of week for timeline.
166: ld_start_date := PA_TIMELINE_UTIL.Get_Week_End_Date(
167: p_org_id=>-99,
168: p_given_date=>ld_start_date) - 6;
169:
170: ld_end_date := PA_TIMELINE_UTIL.Get_Week_End_Date(

Line 170: ld_end_date := PA_TIMELINE_UTIL.Get_Week_End_Date(

166: ld_start_date := PA_TIMELINE_UTIL.Get_Week_End_Date(
167: p_org_id=>-99,
168: p_given_date=>ld_start_date) - 6;
169:
170: ld_end_date := PA_TIMELINE_UTIL.Get_Week_End_Date(
171: p_org_id=>-99,
172: p_given_date=>ld_end_date);
173: */
174:

Line 178: pa_timeline_util.debug(' Processing Resource ID ' || to_char(cur_res_det_rec.resource_id));

174:
175: li_commit_size :=1;
176:
177: FOR cur_res_det_rec IN cur_res_det LOOP
178: pa_timeline_util.debug(' Processing Resource ID ' || to_char(cur_res_det_rec.resource_id));
179:
180:
181: pa_timeline_util.debug('Calling forecast item generation');
182:

Line 181: pa_timeline_util.debug('Calling forecast item generation');

177: FOR cur_res_det_rec IN cur_res_det LOOP
178: pa_timeline_util.debug(' Processing Resource ID ' || to_char(cur_res_det_rec.resource_id));
179:
180:
181: pa_timeline_util.debug('Calling forecast item generation');
182:
183: -- Generate forecast items.
184: PA_FORECASTITEM_PVT.Create_Forecast_Item(
185: p_resource_id => cur_res_det_rec.resource_id,

Line 192: pa_timeline_util.debug('End calling forecast item generation: 10');

188: p_process_mode => 'GENERATE',
189: x_return_status => x_return_status,
190: x_msg_count => x_msg_count,
191: x_msg_data => x_msg_data);
192: pa_timeline_util.debug('End calling forecast item generation: 10');
193:
194: -- jmarques (1569373):
195: -- When this procedure is called from a concurrent process,
196: -- we partially commit the data. If p_start_resource_name is not

Line 213: pa_timeline_util.debug('no timeline to create');

209:
210: EXCEPTION
211: WHEN l_no_timeline_to_create THEN
212: -- There is no timeline to create
213: pa_timeline_util.debug('no timeline to create');
214:
215: WHEN OTHERS THEN
216: x_msg_count := 1;
217: x_msg_data := sqlerrm;

Line 270: pa_timeline_util.debug('Start Date and Time ' || TO_CHAR(SYSDATE,'DD-MON-YYYY HH:MM:SS'));

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:
274: -- This call will rebuild the resource forecast items.

Line 292: pa_timeline_util.debug('End Date and Time ' || TO_CHAR(SYSDATE,'DD-MON-YYYY HH:MM:SS'));

288: li_commit_size := li_commit_size +1;
289:
290: END LOOP;
291:
292: pa_timeline_util.debug('End Date and Time ' || TO_CHAR(SYSDATE,'DD-MON-YYYY HH:MM:SS'));
293:
294: EXCEPTION
295: WHEN OTHERS THEN
296: x_msg_count := 1;

Line 439: pa_timeline_util.debug('************************************');

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);
443: pa_timeline_util.debug('p_conflict_group_id: '|| p_conflict_group_id);

Line 440: pa_timeline_util.debug('Entering populate_time_chart_table');

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);
443: pa_timeline_util.debug('p_conflict_group_id: '|| p_conflict_group_id);
444: pa_timeline_util.debug('p_assignment_id: '|| p_assignment_id);

Line 441: pa_timeline_util.debug('p_timeline_type: '|| p_timeline_type);

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);
443: pa_timeline_util.debug('p_conflict_group_id: '|| p_conflict_group_id);
444: pa_timeline_util.debug('p_assignment_id: '|| p_assignment_id);
445: pa_timeline_util.debug('p_start_date: ' || p_start_date);

Line 442: pa_timeline_util.debug('p_resource_id: ' || p_resource_id);

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);
443: pa_timeline_util.debug('p_conflict_group_id: '|| p_conflict_group_id);
444: pa_timeline_util.debug('p_assignment_id: '|| p_assignment_id);
445: pa_timeline_util.debug('p_start_date: ' || p_start_date);
446: pa_timeline_util.debug('p_end_date: ' || p_end_date);

Line 443: pa_timeline_util.debug('p_conflict_group_id: '|| p_conflict_group_id);

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);
443: pa_timeline_util.debug('p_conflict_group_id: '|| p_conflict_group_id);
444: pa_timeline_util.debug('p_assignment_id: '|| p_assignment_id);
445: pa_timeline_util.debug('p_start_date: ' || p_start_date);
446: pa_timeline_util.debug('p_end_date: ' || p_end_date);
447: pa_timeline_util.debug('p_scale_type: ' || p_scale_type);

Line 444: pa_timeline_util.debug('p_assignment_id: '|| p_assignment_id);

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);
443: pa_timeline_util.debug('p_conflict_group_id: '|| p_conflict_group_id);
444: pa_timeline_util.debug('p_assignment_id: '|| p_assignment_id);
445: pa_timeline_util.debug('p_start_date: ' || p_start_date);
446: pa_timeline_util.debug('p_end_date: ' || p_end_date);
447: pa_timeline_util.debug('p_scale_type: ' || p_scale_type);
448: pa_timeline_util.debug('p_delete_flag: ' || p_delete_flag);

Line 445: pa_timeline_util.debug('p_start_date: ' || p_start_date);

441: pa_timeline_util.debug('p_timeline_type: '|| p_timeline_type);
442: pa_timeline_util.debug('p_resource_id: ' || p_resource_id);
443: pa_timeline_util.debug('p_conflict_group_id: '|| p_conflict_group_id);
444: pa_timeline_util.debug('p_assignment_id: '|| p_assignment_id);
445: pa_timeline_util.debug('p_start_date: ' || p_start_date);
446: pa_timeline_util.debug('p_end_date: ' || p_end_date);
447: pa_timeline_util.debug('p_scale_type: ' || p_scale_type);
448: pa_timeline_util.debug('p_delete_flag: ' || p_delete_flag);
449: pa_timeline_util.debug('************************************');

Line 446: pa_timeline_util.debug('p_end_date: ' || p_end_date);

442: pa_timeline_util.debug('p_resource_id: ' || p_resource_id);
443: pa_timeline_util.debug('p_conflict_group_id: '|| p_conflict_group_id);
444: pa_timeline_util.debug('p_assignment_id: '|| p_assignment_id);
445: pa_timeline_util.debug('p_start_date: ' || p_start_date);
446: pa_timeline_util.debug('p_end_date: ' || p_end_date);
447: pa_timeline_util.debug('p_scale_type: ' || p_scale_type);
448: pa_timeline_util.debug('p_delete_flag: ' || p_delete_flag);
449: pa_timeline_util.debug('************************************');
450:

Line 447: pa_timeline_util.debug('p_scale_type: ' || p_scale_type);

443: pa_timeline_util.debug('p_conflict_group_id: '|| p_conflict_group_id);
444: pa_timeline_util.debug('p_assignment_id: '|| p_assignment_id);
445: pa_timeline_util.debug('p_start_date: ' || p_start_date);
446: pa_timeline_util.debug('p_end_date: ' || p_end_date);
447: pa_timeline_util.debug('p_scale_type: ' || p_scale_type);
448: pa_timeline_util.debug('p_delete_flag: ' || p_delete_flag);
449: pa_timeline_util.debug('************************************');
450:
451: pa_timeline_util.debug('g_res_capacity_percentage =' || g_res_capacity_percentage);

Line 448: pa_timeline_util.debug('p_delete_flag: ' || p_delete_flag);

444: pa_timeline_util.debug('p_assignment_id: '|| p_assignment_id);
445: pa_timeline_util.debug('p_start_date: ' || p_start_date);
446: pa_timeline_util.debug('p_end_date: ' || p_end_date);
447: pa_timeline_util.debug('p_scale_type: ' || p_scale_type);
448: pa_timeline_util.debug('p_delete_flag: ' || p_delete_flag);
449: pa_timeline_util.debug('************************************');
450:
451: pa_timeline_util.debug('g_res_capacity_percentage =' || g_res_capacity_percentage);
452: pa_timeline_util.debug('g_overcommitment_percentage = '|| g_overcommitment_percentage);

Line 449: pa_timeline_util.debug('************************************');

445: pa_timeline_util.debug('p_start_date: ' || p_start_date);
446: pa_timeline_util.debug('p_end_date: ' || p_end_date);
447: pa_timeline_util.debug('p_scale_type: ' || p_scale_type);
448: pa_timeline_util.debug('p_delete_flag: ' || p_delete_flag);
449: pa_timeline_util.debug('************************************');
450:
451: pa_timeline_util.debug('g_res_capacity_percentage =' || g_res_capacity_percentage);
452: pa_timeline_util.debug('g_overcommitment_percentage = '|| g_overcommitment_percentage);
453: pa_timeline_util.debug('g_availability_cal_period = '||g_availability_cal_period);

Line 451: pa_timeline_util.debug('g_res_capacity_percentage =' || g_res_capacity_percentage);

447: pa_timeline_util.debug('p_scale_type: ' || p_scale_type);
448: pa_timeline_util.debug('p_delete_flag: ' || p_delete_flag);
449: pa_timeline_util.debug('************************************');
450:
451: pa_timeline_util.debug('g_res_capacity_percentage =' || g_res_capacity_percentage);
452: pa_timeline_util.debug('g_overcommitment_percentage = '|| g_overcommitment_percentage);
453: pa_timeline_util.debug('g_availability_cal_period = '||g_availability_cal_period);
454:
455: IF p_delete_flag = 'Y' then

Line 452: pa_timeline_util.debug('g_overcommitment_percentage = '|| g_overcommitment_percentage);

448: pa_timeline_util.debug('p_delete_flag: ' || p_delete_flag);
449: pa_timeline_util.debug('************************************');
450:
451: pa_timeline_util.debug('g_res_capacity_percentage =' || g_res_capacity_percentage);
452: pa_timeline_util.debug('g_overcommitment_percentage = '|| g_overcommitment_percentage);
453: pa_timeline_util.debug('g_availability_cal_period = '||g_availability_cal_period);
454:
455: IF p_delete_flag = 'Y' then
456: PA_TIME_CHART_PKG.delete_row(x_return_status => x_return_status,

Line 453: pa_timeline_util.debug('g_availability_cal_period = '||g_availability_cal_period);

449: pa_timeline_util.debug('************************************');
450:
451: pa_timeline_util.debug('g_res_capacity_percentage =' || g_res_capacity_percentage);
452: pa_timeline_util.debug('g_overcommitment_percentage = '|| g_overcommitment_percentage);
453: pa_timeline_util.debug('g_availability_cal_period = '||g_availability_cal_period);
454:
455: IF p_delete_flag = 'Y' then
456: PA_TIME_CHART_PKG.delete_row(x_return_status => x_return_status,
457: x_msg_count => x_msg_count,

Line 461: pa_timeline_util.debug('After delete row');

457: x_msg_count => x_msg_count,
458: x_msg_data => x_msg_data);
459: END IF;
460:
461: pa_timeline_util.debug('After delete row');
462:
463: l_count := p_row_label_id_tbl.COUNT;
464: pa_timeline_util.debug('Count = '|| l_count);
465: prm_license := PA_INSTALL.IS_PRM_LICENSED();

Line 464: pa_timeline_util.debug('Count = '|| l_count);

460:
461: pa_timeline_util.debug('After delete row');
462:
463: l_count := p_row_label_id_tbl.COUNT;
464: pa_timeline_util.debug('Count = '|| l_count);
465: prm_license := PA_INSTALL.IS_PRM_LICENSED();
466:
467: IF l_count > 0 THEN
468: FOR j IN 1 .. (TRUNC(l_count/25)+1) LOOP

Line 469: pa_timeline_util.debug('Enter For loop');

465: prm_license := PA_INSTALL.IS_PRM_LICENSED();
466:
467: IF l_count > 0 THEN
468: FOR j IN 1 .. (TRUNC(l_count/25)+1) LOOP
469: pa_timeline_util.debug('Enter For loop');
470:
471: IF j < TRUNC(l_count/25) +1 THEN
472: FOR i IN 1 .. 25 LOOP
473: l_row_label_id_tbl(i) := p_row_label_id_tbl((j-1)*25+i);

Line 478: pa_timeline_util.debug('l_row_label_id = '|| l_row_label_id_tbl(i));

474: END LOOP;
475: ELSE
476: FOR i IN 1.. MOD(l_count, 25) LOOP
477: l_row_label_id_tbl(i) := p_row_label_id_tbl((j-1)*25+i);
478: pa_timeline_util.debug('l_row_label_id = '|| l_row_label_id_tbl(i));
479: END LOOP;
480: FOR i IN (MOD(l_count, 25)+1) .. 25 LOOP
481: l_row_label_id_tbl(i):= null;
482: pa_timeline_util.debug('l_row_label_id = '|| l_row_label_id_tbl(i));

Line 482: pa_timeline_util.debug('l_row_label_id = '|| l_row_label_id_tbl(i));

478: pa_timeline_util.debug('l_row_label_id = '|| l_row_label_id_tbl(i));
479: END LOOP;
480: FOR i IN (MOD(l_count, 25)+1) .. 25 LOOP
481: l_row_label_id_tbl(i):= null;
482: pa_timeline_util.debug('l_row_label_id = '|| l_row_label_id_tbl(i));
483: END LOOP;
484: END IF;
485:
486: IF p_timeline_type = 'ResourceSchedules' THEN

Line 1169: pa_timeline_util.debug('Resource Details: weekly month');

1165: col.render_priority
1166: );
1167:
1168: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'MONTH' and prm_license = 'Y' THEN
1169: pa_timeline_util.debug('Resource Details: weekly month');
1170: INSERT INTO pa_time_chart_temp (
1171: select
1172: decode(fi_week.availability_flag, 'Y', 'AVAILABLE', 'N', 'OVERCOMMITTED') time_chart_record_type,
1173: decode(fi_week.availability_flag, 'Y', -99, 'N', -100) row_label_id,

Line 1246: pa_timeline_util.debug('Resource Details: weekly month');

1242: 'STAFFED_ASGMT_PROV'))
1243: );
1244:
1245: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
1246: pa_timeline_util.debug('Resource Details: weekly month');
1247: INSERT INTO pa_time_chart_temp (
1248: select
1249: 'ASSIGNMENT' time_chart_record_type,
1250: fi.assignment_id row_label_id,

Line 1285: pa_timeline_util.debug('Resource Details: weekly | three_month');

1281: 'STAFFED_ASGMT_PROV'))
1282: );
1283:
1284: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
1285: pa_timeline_util.debug('Resource Details: weekly | three_month');
1286: INSERT INTO pa_time_chart_temp (
1287: select
1288: decode(fi_week.availability_flag, 'Y', 'AVAILABLE', 'N', 'OVERCOMMITTED') time_chart_record_type,
1289: decode(fi_week.availability_flag, 'Y', -99, 'N', -100) row_label_id,

Line 1371: pa_timeline_util.debug('Resource Details: weekly | three_month');

1367: col.file_name
1368: );
1369:
1370: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
1371: pa_timeline_util.debug('Resource Details: weekly | three_month');
1372: INSERT INTO pa_time_chart_temp (
1373: select
1374: 'ASSIGNMENT' time_chart_record_type,
1375: fi.assignment_id row_label_id,