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 FND_FILE

Line 35: --fnd_file.put_line(fnd_file.log,'TEMPLATE_ID ===='||l_psp_template_id);

31:
32: l_psp_template_id := get_parameter_value('TEMPLATE_ID', param_string);
33:
34:
35: --fnd_file.put_line(fnd_file.log,'TEMPLATE_ID ===='||l_psp_template_id);
36: --fnd_file.put_line(fnd_file.log,'Return String '||get_parameter_value('START_DATE', param_string));
37:
38:
39: l_psp_effort_start:= trunc(fnd_date.canonical_to_date(get_parameter_value('START_DATE', param_string)));

Line 36: --fnd_file.put_line(fnd_file.log,'Return String '||get_parameter_value('START_DATE', param_string));

32: l_psp_template_id := get_parameter_value('TEMPLATE_ID', param_string);
33:
34:
35: --fnd_file.put_line(fnd_file.log,'TEMPLATE_ID ===='||l_psp_template_id);
36: --fnd_file.put_line(fnd_file.log,'Return String '||get_parameter_value('START_DATE', param_string));
37:
38:
39: l_psp_effort_start:= trunc(fnd_date.canonical_to_date(get_parameter_value('START_DATE', param_string)));
40: --fnd_file.put_line(fnd_file.log,'start_date ===='||l_psp_effort_start);

Line 40: --fnd_file.put_line(fnd_file.log,'start_date ===='||l_psp_effort_start);

36: --fnd_file.put_line(fnd_file.log,'Return String '||get_parameter_value('START_DATE', param_string));
37:
38:
39: l_psp_effort_start:= trunc(fnd_date.canonical_to_date(get_parameter_value('START_DATE', param_string)));
40: --fnd_file.put_line(fnd_file.log,'start_date ===='||l_psp_effort_start);
41:
42: l_psp_effort_end:= trunc(fnd_date.canonical_to_date(get_parameter_value('END_DATE', param_string)));
43: --fnd_file.put_line(fnd_file.log,'end date ===='||l_psp_effort_end);
44:

Line 43: --fnd_file.put_line(fnd_file.log,'end date ===='||l_psp_effort_end);

39: l_psp_effort_start:= trunc(fnd_date.canonical_to_date(get_parameter_value('START_DATE', param_string)));
40: --fnd_file.put_line(fnd_file.log,'start_date ===='||l_psp_effort_start);
41:
42: l_psp_effort_end:= trunc(fnd_date.canonical_to_date(get_parameter_value('END_DATE', param_string)));
43: --fnd_file.put_line(fnd_file.log,'end date ===='||l_psp_effort_end);
44:
45: l_psp_report_layout := get_parameter_value('REPORT_LAYOUT', param_string);
46: l_psp_sort_option1 := get_parameter_value('FIRST_SORT', param_string);
47: l_psp_order_by1 := get_parameter_value('FIRST_ORDER' , param_string);

Line 56: -- fnd_file.put_line(fnd_file.log,'sort option 1 ===='||l_psp_sort_option1);

52: l_psp_sort_option4 := get_parameter_value('FOURTH_SORT', param_string);
53: l_psp_order_by4 := get_parameter_value('FOURTH_ORDER' , param_string);
54:
55:
56: -- fnd_file.put_line(fnd_file.log,'sort option 1 ===='||l_psp_sort_option1);
57: -- fnd_file.put_line(fnd_file.log,'ORDER BY ===='||l_psp_order_by1);
58: -- fnd_file.put_line(fnd_file.log,' sort option 2 ===='||l_psp_sort_option2);
59: -- fnd_file.put_line(fnd_file.log,'order_by_2 ===='||l_psp_order_by2);
60: -- fnd_file.put_line(fnd_file.log,'layout ===='||l_psp_report_layout);

Line 57: -- fnd_file.put_line(fnd_file.log,'ORDER BY ===='||l_psp_order_by1);

53: l_psp_order_by4 := get_parameter_value('FOURTH_ORDER' , param_string);
54:
55:
56: -- fnd_file.put_line(fnd_file.log,'sort option 1 ===='||l_psp_sort_option1);
57: -- fnd_file.put_line(fnd_file.log,'ORDER BY ===='||l_psp_order_by1);
58: -- fnd_file.put_line(fnd_file.log,' sort option 2 ===='||l_psp_sort_option2);
59: -- fnd_file.put_line(fnd_file.log,'order_by_2 ===='||l_psp_order_by2);
60: -- fnd_file.put_line(fnd_file.log,'layout ===='||l_psp_report_layout);
61:

Line 58: -- fnd_file.put_line(fnd_file.log,' sort option 2 ===='||l_psp_sort_option2);

54:
55:
56: -- fnd_file.put_line(fnd_file.log,'sort option 1 ===='||l_psp_sort_option1);
57: -- fnd_file.put_line(fnd_file.log,'ORDER BY ===='||l_psp_order_by1);
58: -- fnd_file.put_line(fnd_file.log,' sort option 2 ===='||l_psp_sort_option2);
59: -- fnd_file.put_line(fnd_file.log,'order_by_2 ===='||l_psp_order_by2);
60: -- fnd_file.put_line(fnd_file.log,'layout ===='||l_psp_report_layout);
61:
62:

Line 59: -- fnd_file.put_line(fnd_file.log,'order_by_2 ===='||l_psp_order_by2);

55:
56: -- fnd_file.put_line(fnd_file.log,'sort option 1 ===='||l_psp_sort_option1);
57: -- fnd_file.put_line(fnd_file.log,'ORDER BY ===='||l_psp_order_by1);
58: -- fnd_file.put_line(fnd_file.log,' sort option 2 ===='||l_psp_sort_option2);
59: -- fnd_file.put_line(fnd_file.log,'order_by_2 ===='||l_psp_order_by2);
60: -- fnd_file.put_line(fnd_file.log,'layout ===='||l_psp_report_layout);
61:
62:
63: /* insert record in psp_report_templates_h */

Line 60: -- fnd_file.put_line(fnd_file.log,'layout ===='||l_psp_report_layout);

56: -- fnd_file.put_line(fnd_file.log,'sort option 1 ===='||l_psp_sort_option1);
57: -- fnd_file.put_line(fnd_file.log,'ORDER BY ===='||l_psp_order_by1);
58: -- fnd_file.put_line(fnd_file.log,' sort option 2 ===='||l_psp_sort_option2);
59: -- fnd_file.put_line(fnd_file.log,'order_by_2 ===='||l_psp_order_by2);
60: -- fnd_file.put_line(fnd_file.log,'layout ===='||l_psp_report_layout);
61:
62:
63: /* insert record in psp_report_templates_h */
64:

Line 120: fnd_file.put_line(fnd_file.log, 'Insert into Template History failed '||sqlerrm);

116: p_error_message => l_sqlerrm,
117: -- p_payroll_action_id => pactid,
118: p_return_status => l_return_status);
119:
120: fnd_file.put_line(fnd_file.log, 'Insert into Template History failed '||sqlerrm);
121: raise fnd_api.g_exc_unexpected_error;
122:
123: END;
124:

Line 151: --fnd_file.put_line(fnd_file.log,'Before Insert in template history ');

147:
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 );

Line 187: --fnd_file.put_line(fnd_file.log,'==== After Insert in template history ');

183: l_migration_status:= psp_general.is_effort_report_migrated;
184:
185: IF l_migration_status then
186:
187: --fnd_file.put_line(fnd_file.log,'==== After Insert in template history ');
188:
189: get_final_selection_list(errBuf, retCode, l_request_id, TRUE);
190:
191: --fnd_file.put_line(fnd_file.log,'==== After getting sleection list ');

Line 191: --fnd_file.put_line(fnd_file.log,'==== After getting sleection list ');

187: --fnd_file.put_line(fnd_file.log,'==== After Insert in template history ');
188:
189: get_final_selection_list(errBuf, retCode, l_request_id, TRUE);
190:
191: --fnd_file.put_line(fnd_file.log,'==== After getting sleection list ');
192:
193: SELECT nvl(count( person_id),0) into l_cnt from psp_selected_persons_t where
194: request_id = l_request_id;
195:

Line 196: --fnd_file.put_line(fnd_file.log,'==== count is '|| l_cnt);

192:
193: SELECT nvl(count( person_id),0) into l_cnt from psp_selected_persons_t where
194: request_id = l_request_id;
195:
196: --fnd_file.put_line(fnd_file.log,'==== count is '|| l_cnt);
197:
198: IF l_cnt=0 then
199:
200: fnd_message.set_name('PSP', 'PSP_EFF_NO_EMP_FOUND');

Line 225: -- fnd_file.put_line(fnd_file.log,'==== cnt sleection '||l_cnt);

221:
222: END IF;
223:
224:
225: -- fnd_file.put_line(fnd_file.log,'==== cnt sleection '||l_cnt);
226:
227: sqlstr := 'select distinct person_id from psp_selected_persons_t pspt,
228: pay_payroll_actions pact
229: where pact.payroll_action_id = :payroll_action_id and

Line 262: psp_message_s.print_error(p_mode=>FND_FILE.log,

258: -- hr_utility.trace_off;
259:
260: EXCEPTION WHEN OTHERS THEN
261:
262: psp_message_s.print_error(p_mode=>FND_FILE.log,
263:
264: p_print_header=>FND_API.G_TRUE);
265:
266: sqlstr:= NULL;

Line 316: ---fnd_file.put_line(fnd_file.log,' after get lowest cardinality ');

312:
313:
314: IF (l_template_selection = 'EMP') THEN
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:

Line 324: ---fnd_file.put_line(fnd_file.log,' after initial person list ');

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;
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 ' );

Line 332: --fnd_file.put_line(fnd_file.log,' after prune person list ');

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 ');
333: hr_utility.trace( 'get_template_selection-> After prune initial_person_list ' );
334: END IF;
335:
336:

Line 338: --fnd_file.put_line(fnd_file.log,' after apply excl criteria ');

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);
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:

Line 378: -- fnd_file.put_line(fnd_file.log,' after ff exclusion ');

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 ');
379: hr_utility.trace( 'get_template_selection-> After apply_ff_formula_exclusion ' );
380:
381:
382: --fnd_file.put_line(fnd_file.log,' before count ');

Line 382: --fnd_file.put_line(fnd_file.log,' before count ');

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:
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 );

Line 385: --fnd_file.put_line(fnd_file.log,' after count ' || l_count);

381:
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:

Line 394: -- fnd_file.put_line(fnd_file.log,' after gather stats ');

390: If l_count > 0 then
391:
392:
393: FND_STATS.GATHER_TABLE_STATS(ownname=>'PSP', tabname=>'PSP_SELECTED_PERSONS_T');
394: -- fnd_file.put_line(fnd_file.log,' after gather stats ');
395:
396: end if;
397: EXCEPTION
398: WHEN OTHERS THEN

Line 400: fnd_file.put_line(fnd_file.log,' after gather error '||sqlerrm);

396: end if;
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:

Line 806: -- fnd_file.put_line(fnd_file.log, ' dyn_criteria is ' ||l_dyn_criteria);

802:
803: ELSIF template_rec.array_sel_criteria(i)='PPG' THEN
804:
805: l_dyn_criteria:='PPG';
806: -- fnd_file.put_line(fnd_file.log, ' dyn_criteria is ' ||l_dyn_criteria);
807:
808: ELSIF template_rec.array_sel_criteria(i)='GLA' THEN
809:
810: l_dyn_criteria:='GLA';

Line 811: -- fnd_file.put_line(fnd_file.log, ' dyn_criteria is ' ||l_dyn_criteria);

807:
808: ELSIF template_rec.array_sel_criteria(i)='GLA' THEN
809:
810: l_dyn_criteria:='GLA';
811: -- fnd_file.put_line(fnd_file.log, ' dyn_criteria is ' ||l_dyn_criteria);
812:
813: END IF;
814:
815: END LOOP;

Line 828: -- fnd_file.put_line(fnd_file.log, ' g_lookup_code is '||g_lookup_code);

824:
825: IF g_lookup_code is not null then
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

Line 838: -- fnd_file.put_line(fnd_file.log, ' g_lookup_code is '||g_lookup_code);

834: OPEN get_zero_cardinality_csr;
835: FETCH get_zero_cardinality_csr into 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

Line 864: -- fnd_file.put_line(fnd_file.log, ' g_lookup_code is null ');

860: /* when no static selection criteria have been chosen, then invoke the dynamic selection criteria
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';

Line 874: -- fnd_file.put_line(fnd_file.log, 'after fetch of ppg cursor ');

870:
871: OPEN ppg_cursor;
872:
873: FETCH PPG_CURSOR into l_criteria_value1, l_criteria_value2;
874: -- fnd_file.put_line(fnd_file.log, 'after fetch of ppg cursor ');
875: IF l_criteria_value1 is not null then
876:
877:
878: l_sql_string := l_criteria_value1 ||' = '||''''|| l_criteria_value2 ||'''' ;

Line 885: -- fnd_file.put_line(fnd_file.log, 'after second fetch of ppg cursor ');

881:
882: LOOP
883:
884: FETCH PPG_CURSOR INTO l_criteria_value1, l_criteria_value2;
885: -- fnd_file.put_line(fnd_file.log, 'after second fetch of ppg cursor ');
886: EXIT WHEN PPG_CURSOR%NOTFOUND;
887:
888: /*
889: select l_sql_string

Line 922: -- fnd_file.put_line(fnd_file.log , ' g_exec_string 1 is '||g_exec_string);

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;
925: g_lookup_code := 'PPG';
926: END IF;

Line 961: -- fnd_file.put_line(fnd_file.log,' before isnerting g_exec_string in GL criteria ');

957: close gla_cursor;
958:
959: -- l_sql_string:= g_exec_string;
960:
961: -- fnd_file.put_line(fnd_file.log,' before isnerting g_exec_string in GL criteria ');
962: if l_sql_string is not null then
963: g_exec_string := 'insert into psp_selection_cardinality_gt(lookup_code, total_count)
964: ( select '|| '''' || 'GLA' || ''''|| ' , count( distinct psl.person_id)
965: from psp_summary_lines psl, psp_distribution_lines_history pdnh, psp_pre_gen_dist_lines_history ppg,

Line 1000: -- fnd_file.put_line(fnd_file.log,' g_exec_string '||g_exec_string);

996: where ' || l_sql_string
997: || ' )) ';
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';

Line 1023: fnd_file.put_line(fnd_file.log, ' EXCEPTION '||sqlerrm);

1019:
1020: END IF;
1021:
1022: EXCEPTION WHEN OTHERS THEN
1023: fnd_file.put_line(fnd_file.log, ' EXCEPTION '||sqlerrm);
1024:
1025:
1026: END;
1027:

Line 1296: -- fnd_file.put_line(fnd_file.log,'after insert into psp_selected_persons_t '||l_cnt);

1292: NVL(palh.original_line_flag, 'N') ='N')));
1293:
1294: -- select count(person_id) into l_cnt from psp_selected_persons_t where request_id = p_request_id;
1295:
1296: -- fnd_file.put_line(fnd_file.log,'after insert into psp_selected_persons_t '||l_cnt);
1297:
1298:
1299:
1300: ELSIF g_lookup_code ='PRJ' then

Line 1725: -- fnd_file.put_line(fnd_file.log, 'g_exec_string2 = '||g_exec_string);

1721: AND psl.assignment_id = paf.assignment_id
1722: AND reversal_entry_flag IS NULL
1723: AND rownum=1)))';
1724:
1725: -- fnd_file.put_line(fnd_file.log, 'g_exec_string2 = '||g_exec_string);
1726:
1727: execute immediate g_exec_string using IN p_request_id, p_effort_start, p_effort_end,
1728: p_effort_start, p_effort_end, p_effort_start, p_effort_end, p_effort_start, p_effort_end;
1729: end if;

Line 1797: -- fnd_file.put_line(fnd_file.log, 'g_exec_string 2= '||g_exec_string);

1793: gcc.code_combination_id in (select code_combination_id from gl_code_combinations
1794: where ' || l_sql_string
1795: || ' )) ';
1796:
1797: -- fnd_file.put_line(fnd_file.log, 'g_exec_string 2= '||g_exec_string);
1798:
1799: execute immediate g_exec_string using iN p_request_id, p_effort_start, p_effort_end, p_effort_start, p_effort_end, p_effort_start, p_effort_end;
1800:
1801:

Line 2575: --fnd_file.put_line(fnd_file.log , ' g_exec_string 3 is '||g_exec_string);

2571: AND reversal_entry_flag IS NULL
2572: AND rownum=1)))';
2573:
2574:
2575: --fnd_file.put_line(fnd_file.log , ' g_exec_string 3 is '||g_exec_string);
2576:
2577: EXECUTE IMMEDIATE g_exec_string USING IN p_request_id, p_Effort_start, p_effort_end, p_Effort_start, p_effort_end, p_Effort_start, p_effort_end;
2578: end if;
2579: end if;

Line 2643: -- fnd_file.put_line(fnd_file.log , ' g_exec_string 3 is '||g_exec_string);

2639: gcc.code_combination_id in (select code_combination_id from gl_code_combinations
2640: where ' || l_sql_string
2641: || ' )) and request_id = :request_id';
2642:
2643: -- fnd_file.put_line(fnd_file.log , ' g_exec_string 3 is '||g_exec_string);
2644:
2645: 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, p_request_id;
2646:
2647: end if;

Line 3337: --fnd_file.put_line(fnd_file.log, 'ppg check is '||g_exec_string);

3333: AND rownum=1))
3334: ) and request_id = :request_id';
3335:
3336:
3337: --fnd_file.put_line(fnd_file.log, 'ppg check is '||g_exec_string);
3338:
3339: 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, p_request_id;
3340:
3341: END IF;

Line 3405: --fnd_file.put_line(fnd_file.log,'g_exec_string ===='||g_exec_string);

3401: where ' || l_sql_string
3402: || ' )) and request_id = :request_id';
3403:
3404:
3405: --fnd_file.put_line(fnd_file.log,'g_exec_string ===='||g_exec_string);
3406:
3407: 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, p_request_id;
3408:
3409: END IF;

Line 4132: fnd_file.put_line(fnd_file.log, ' EXCEPTION '||sqlerrm);

4128: END IF;
4129:
4130: EXCEPTION
4131: WHEN OTHERS THEN
4132: fnd_file.put_line(fnd_file.log, ' EXCEPTION '||sqlerrm);
4133: END get_asg_lowest_cardinality;
4134:
4135: PROCEDURE prepare_initial_asg_list (p_request_id IN NUMBER,
4136: p_effort_start IN DATE,