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 271: pa_timeline_util.debug('Start Date and Time ' || TO_CHAR(SYSDATE,'DD-MON-YYYY HH:MM:SS'));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1189: col.render_priority
1190: );
1191:
1192: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'MONTH' and prm_license = 'Y' THEN
1193: pa_timeline_util.debug('Resource Details: weekly month');
1194: INSERT INTO pa_time_chart_temp (
1195: select
1196: decode(fi_week.availability_flag, 'Y', 'AVAILABLE', 'N', 'OVERCOMMITTED') time_chart_record_type,
1197: decode(fi_week.availability_flag, 'Y', -99, 'N', -100) row_label_id,

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

1269: 'STAFFED_ASGMT_PROV'))
1270: );
1271:
1272: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
1273: pa_timeline_util.debug('Resource Details: weekly month');
1274: INSERT INTO pa_time_chart_temp (
1275: select
1276: 'ASSIGNMENT' time_chart_record_type,
1277: fi.assignment_id row_label_id,

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

1309: 'STAFFED_ASGMT_PROV'))
1310: );
1311:
1312: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
1313: pa_timeline_util.debug('Resource Details: weekly | three_month');
1314: INSERT INTO pa_time_chart_temp (
1315: select
1316: decode(fi_week.availability_flag, 'Y', 'AVAILABLE', 'N', 'OVERCOMMITTED') time_chart_record_type,
1317: decode(fi_week.availability_flag, 'Y', -99, 'N', -100) row_label_id,

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

1398: col.file_name
1399: );
1400:
1401: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
1402: pa_timeline_util.debug('Resource Details: weekly | three_month');
1403: INSERT INTO pa_time_chart_temp (
1404: select
1405: 'ASSIGNMENT' time_chart_record_type,
1406: fi.assignment_id row_label_id,