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.PSP_TEMPLATE_SELECTION dependencies on HR_UTILITY

Line 152: --hr_utility.trace_on('Y','ORACLE');

148:
149: BEGIN
150:
151: --fnd_file.put_line(fnd_file.log,'Before Insert in template history ');
152: --hr_utility.trace_on('Y','ORACLE');
153:
154:
155: insert_into_template_history(pactid, l_request_id );
156: l_profile_bg_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

Line 258: -- hr_utility.trace_off;

254:
255: END IF;
256:
257:
258: -- hr_utility.trace_off;
259:
260: EXCEPTION WHEN OTHERS THEN
261:
262: psp_message_s.print_error(p_mode=>FND_FILE.log,

Line 319: hr_utility.trace( 'get_template_selection-> After get_lowest_cardinality' );

315: get_lowest_cardinality(p_request_id , l_effort_start, l_effort_end, l_business_group_id, l_set_of_books_id);
316: ---fnd_file.put_line(fnd_file.log,' after get lowest cardinality ');
317:
318:
319: hr_utility.trace( 'get_template_selection-> After get_lowest_cardinality' );
320:
321: prepare_initial_person_list(p_request_id , l_effort_start, l_effort_end, l_business_group_id, l_set_of_books_id);
322: ---select count(*) into l_count_x from psp_selected_persons_t where request_id
323: ---= p_request_id;

Line 328: hr_utility.trace( 'get_template_selection-> After prepare_initial_person_list ' );

324: ---fnd_file.put_line(fnd_file.log,' after initial person list ');
325:
326: FND_STATS.GATHER_TABLE_STATS(ownname=>'PSP', tabname=>'PSP_SELECTED_PERSONS_T');
327:
328: hr_utility.trace( 'get_template_selection-> After prepare_initial_person_list ' );
329: If g_lookup_code <> 'ALL' then
330:
331: prune_initial_person_list(p_request_id , l_effort_start, l_effort_end, l_business_group_id, l_set_of_books_id);
332: --fnd_file.put_line(fnd_file.log,' after prune person list ');

Line 333: hr_utility.trace( 'get_template_selection-> After prune initial_person_list ' );

329: If g_lookup_code <> 'ALL' then
330:
331: prune_initial_person_list(p_request_id , l_effort_start, l_effort_end, l_business_group_id, l_set_of_books_id);
332: --fnd_file.put_line(fnd_file.log,' after prune person list ');
333: hr_utility.trace( 'get_template_selection-> After prune initial_person_list ' );
334: END IF;
335:
336:
337: apply_exclusion_criteria(p_request_id , l_effort_start, l_effort_end, l_business_group_id, l_set_of_books_id);

Line 339: hr_utility.trace( 'get_template_selection-> After apply exclusion criteria ' );

335:
336:
337: apply_exclusion_criteria(p_request_id , l_effort_start, l_effort_end, l_business_group_id, l_set_of_books_id);
338: --fnd_file.put_line(fnd_file.log,' after apply excl criteria ');
339: hr_utility.trace( 'get_template_selection-> After apply exclusion criteria ' );
340:
341: END IF;
342:
343: IF (l_template_selection = 'ASG') THEN

Line 349: hr_utility.trace('get_template_selection-> After get_asg_lowest_cardinality');

345: p_effort_start => l_effort_start,
346: p_effort_end => l_effort_end,
347: p_business_group_id => l_business_group_id,
348: p_set_of_books_id => l_set_of_books_id);
349: hr_utility.trace('get_template_selection-> After get_asg_lowest_cardinality');
350:
351: prepare_initial_asg_list (p_request_id => p_request_id,
352: p_effort_start => l_effort_start,
353: p_effort_end => l_effort_end,

Line 356: hr_utility.trace('get_template_selection-> After prepare_initial_asg_list');

352: p_effort_start => l_effort_start,
353: p_effort_end => l_effort_end,
354: p_business_group_id => l_business_group_id,
355: p_set_of_books_id => l_set_of_books_id);
356: hr_utility.trace('get_template_selection-> After prepare_initial_asg_list');
357:
358: FND_STATS.GATHER_TABLE_STATS(ownname=>'PSP', tabname=>'PSP_SELECTED_PERSONS_T');
359:
360: IF g_lookup_code <> 'ALL' THEN

Line 366: hr_utility.trace('get_template_selection-> After prune initial_asg_list');

362: p_effort_start => l_effort_start,
363: p_effort_end => l_effort_end,
364: p_business_group_id => l_business_group_id,
365: p_set_of_books_id => l_set_of_books_id);
366: hr_utility.trace('get_template_selection-> After prune initial_asg_list');
367: END IF;
368:
369: apply_asg_exclusion_criteria (p_request_id => p_request_id,
370: p_effort_start => l_effort_start,

Line 374: hr_utility.trace('get_template_selection-> After apply asg exclusion criteria');

370: p_effort_start => l_effort_start,
371: p_effort_end => l_effort_end,
372: p_business_group_id => l_business_group_id,
373: p_set_of_books_id => l_set_of_books_id);
374: hr_utility.trace('get_template_selection-> After apply asg exclusion criteria');
375: END IF;
376:
377: apply_ff_formula_exclusion(p_request_id, l_effort_start, l_effort_end);
378: -- fnd_file.put_line(fnd_file.log,' after ff exclusion ');

Line 379: hr_utility.trace( 'get_template_selection-> After apply_ff_formula_exclusion ' );

375: END IF;
376:
377: apply_ff_formula_exclusion(p_request_id, l_effort_start, l_effort_end);
378: -- fnd_file.put_line(fnd_file.log,' after ff exclusion ');
379: hr_utility.trace( 'get_template_selection-> After apply_ff_formula_exclusion ' );
380:
381:
382: --fnd_file.put_line(fnd_file.log,' before count ');
383:

Line 386: hr_utility.trace( 'get_template_selection-> After getting count= '||l_count );

382: --fnd_file.put_line(fnd_file.log,' before count ');
383:
384: select nvl(count(person_id),0) into l_count from psp_Selected_persons_t where request_id=p_request_id;
385: --fnd_file.put_line(fnd_file.log,' after count ' || l_count);
386: hr_utility.trace( 'get_template_selection-> After getting count= '||l_count );
387:
388: COMMIT;
389:
390: If l_count > 0 then

Line 401: hr_utility.trace( 'get_template_selection->'||sqlerrm );

397: EXCEPTION
398: WHEN OTHERS THEN
399: BEGIN
400: fnd_file.put_line(fnd_file.log,' after gather error '||sqlerrm);
401: hr_utility.trace( 'get_template_selection->'||sqlerrm );
402:
403: END;
404:
405:

Line 830: hr_utility.trace( 'g_lookup_code -> '||g_lookup_code );

826: l_atleast_one_criteria:='Y';
827:
828: -- fnd_file.put_line(fnd_file.log, ' g_lookup_code is '||g_lookup_code);
829:
830: hr_utility.trace( 'g_lookup_code -> '||g_lookup_code );
831:
832: ELSE
833:
834: OPEN get_zero_cardinality_csr;

Line 840: hr_utility.trace( ' Inside zero cardinality => g_lookup_code= '||g_lookup_code );

836: CLOSE get_zero_cardinality_csr;
837:
838: -- fnd_file.put_line(fnd_file.log, ' g_lookup_code is '||g_lookup_code);
839:
840: hr_utility.trace( ' Inside zero cardinality => g_lookup_code= '||g_lookup_code );
841:
842: IF g_lookup_code is not null then
843: l_atleast_one_criteria:='Y';
844:

Line 865: hr_utility.trace( ' Inside zero cardinality => g_lookup_code is null');

861: */
862:
863:
864: -- fnd_file.put_line(fnd_file.log, ' g_lookup_code is null ');
865: hr_utility.trace( ' Inside zero cardinality => g_lookup_code is null');
866:
867: IF l_dyn_criteria ='PPG' then
868: l_atleast_one_criteria:='Y';
869:

Line 920: hr_utility.trace( ' g_exec_string = '||g_exec_string );

916: where ' || l_sql_string
917: || ' ))
918: ';
919:
920: hr_utility.trace( ' g_exec_string = '||g_exec_string );
921:
922: -- fnd_file.put_line(fnd_file.log , ' g_exec_string 1 is '||g_exec_string);
923:
924: execute immediate g_exec_string using IN p_effort_Start, p_effort_end;

Line 1002: hr_utility.trace( ' g_exec_string = '||g_exec_string );

998:
999:
1000: -- fnd_file.put_line(fnd_file.log,' g_exec_string '||g_exec_string);
1001:
1002: hr_utility.trace( ' g_exec_string = '||g_exec_string );
1003: execute immediate g_exec_string using IN p_effort_start, p_effort_end, p_effort_start, p_effort_end ,p_effort_start, p_effort_end;
1004: g_lookup_code :='GLA';
1005:
1006: END IF;

Line 3478: hr_utility.trace('Input 1 :PERSON_ID=' ||l_inputs(l_in_cnt).value);

3474: FOR l_in_cnt in l_inputs.first..l_inputs.last loop
3475:
3476: IF (l_inputs(l_in_cnt).name ='PERSON_ID') THEN
3477: l_inputs(l_in_cnt).value := fnd_number.number_to_canonical(r_ls_criteria_rec.l_person_id(k));
3478: hr_utility.trace('Input 1 :PERSON_ID=' ||l_inputs(l_in_cnt).value);
3479:
3480:
3481: ELSIF l_inputs(l_in_cnt).name='REQUEST_ID' THEN
3482: l_inputs(l_in_cnt).value := fnd_number.number_to_canonical(r_ls_criteria_rec.l_request_id(k));

Line 3484: hr_utility.trace( ' Input 2 :REQUEST_ID = '||l_inputs(l_in_cnt).value);

3480:
3481: ELSIF l_inputs(l_in_cnt).name='REQUEST_ID' THEN
3482: l_inputs(l_in_cnt).value := fnd_number.number_to_canonical(r_ls_criteria_rec.l_request_id(k));
3483:
3484: hr_utility.trace( ' Input 2 :REQUEST_ID = '||l_inputs(l_in_cnt).value);
3485:
3486: ELSIF l_inputs(l_in_cnt).name='START_DATE' THEN
3487: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(r_ls_criteria_rec.l_start_date(k));
3488: hr_utility.trace( ' Input 3 :START_DATE = '||l_inputs(l_in_cnt).value);

Line 3488: hr_utility.trace( ' Input 3 :START_DATE = '||l_inputs(l_in_cnt).value);

3484: hr_utility.trace( ' Input 2 :REQUEST_ID = '||l_inputs(l_in_cnt).value);
3485:
3486: ELSIF l_inputs(l_in_cnt).name='START_DATE' THEN
3487: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(r_ls_criteria_rec.l_start_date(k));
3488: hr_utility.trace( ' Input 3 :START_DATE = '||l_inputs(l_in_cnt).value);
3489:
3490: ELSIF l_inputs(l_in_cnt).name='END_DATE' THEN
3491: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(r_ls_criteria_rec.l_end_date(k));
3492: hr_utility.trace( ' Input 4 :END_DATE= '||l_inputs(l_in_cnt).value);

Line 3492: hr_utility.trace( ' Input 4 :END_DATE= '||l_inputs(l_in_cnt).value);

3488: hr_utility.trace( ' Input 3 :START_DATE = '||l_inputs(l_in_cnt).value);
3489:
3490: ELSIF l_inputs(l_in_cnt).name='END_DATE' THEN
3491: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(r_ls_criteria_rec.l_end_date(k));
3492: hr_utility.trace( ' Input 4 :END_DATE= '||l_inputs(l_in_cnt).value);
3493:
3494: ELSIF l_inputs(l_in_cnt).name ='ASSIGNMENT_ID' THEN
3495: l_inputs(l_in_cnt).value := fnd_number.number_to_canonical(r_ls_criteria_rec.l_assignment_id(k));
3496: hr_utility.trace('Input 5 :ASSIGNMENT_ID=' ||l_inputs(l_in_cnt).value);

Line 3496: hr_utility.trace('Input 5 :ASSIGNMENT_ID=' ||l_inputs(l_in_cnt).value);

3492: hr_utility.trace( ' Input 4 :END_DATE= '||l_inputs(l_in_cnt).value);
3493:
3494: ELSIF l_inputs(l_in_cnt).name ='ASSIGNMENT_ID' THEN
3495: l_inputs(l_in_cnt).value := fnd_number.number_to_canonical(r_ls_criteria_rec.l_assignment_id(k));
3496: hr_utility.trace('Input 5 :ASSIGNMENT_ID=' ||l_inputs(l_in_cnt).value);
3497:
3498: /*
3499: Commented out the below change as input 1 is person_id and addl. input is not required
3500:

Line 3971: hr_utility.trace( 'g_lookup_code -> '||g_lookup_code );

3967: CLOSE get_lowest_cardinality_csr;
3968:
3969: IF g_lookup_code is not null then
3970: l_atleast_one_criteria:='Y';
3971: hr_utility.trace( 'g_lookup_code -> '||g_lookup_code );
3972: ELSE
3973: OPEN get_zero_cardinality_csr;
3974: FETCH get_zero_cardinality_csr into g_lookup_code;
3975: CLOSE get_zero_cardinality_csr;

Line 3977: hr_utility.trace( ' Inside zero cardinality => g_lookup_code= '||g_lookup_code );

3973: OPEN get_zero_cardinality_csr;
3974: FETCH get_zero_cardinality_csr into g_lookup_code;
3975: CLOSE get_zero_cardinality_csr;
3976:
3977: hr_utility.trace( ' Inside zero cardinality => g_lookup_code= '||g_lookup_code );
3978:
3979: IF g_lookup_code is not null then
3980: l_atleast_one_criteria:='Y';
3981: END IF;

Line 3987: hr_utility.trace( ' Inside zero cardinality => g_lookup_code IS NULL');

3983:
3984: IF g_lookup_code IS NULL then
3985: BEGIN
3986: -- When no static selection criteria have been chosen, then invoke the dynamic selection criteria
3987: hr_utility.trace( ' Inside zero cardinality => g_lookup_code IS NULL');
3988:
3989: IF l_dyn_criteria ='PPG' then
3990: l_atleast_one_criteria:='Y';
3991:

Line 4019: hr_utility.trace( ' g_exec_string = '||g_exec_string );

4015: AND ppg.people_group_id IN (SELECT people_group_id
4016: FROM pay_people_groups
4017: WHERE ' || l_sql_string || ')';
4018:
4019: hr_utility.trace( ' g_exec_string = '||g_exec_string );
4020:
4021: EXECUTE IMMEDIATE g_exec_string USING IN p_effort_Start, p_effort_end;
4022: g_lookup_code := 'PPG';
4023: END IF;

Line 4083: hr_utility.trace( ' g_exec_string = '||g_exec_string );

4079: AND gcc.code_combination_id IN (SELECT code_combination_id
4080: FROM gl_code_combinations
4081: WHERE ' || l_sql_string || ')';
4082:
4083: hr_utility.trace( ' g_exec_string = '||g_exec_string );
4084: EXECUTE IMMEDIATE g_exec_string USING IN p_effort_start, p_effort_end,
4085: p_effort_start, p_effort_end ,p_effort_start, p_effort_end;
4086: g_lookup_code :='GLA';
4087: END IF;