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_SUM_TRANS dependencies on PSP_DISTRIBUTION_LINES_S

Line 992: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines setting summary_line_id : '||l_summary_line_id);

988: l_dist_line_id := dist_line_id(j);
989:
990: IF gl_sum_lines_rec.tab_flag = 'D' THEN
991:
992: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines setting summary_line_id : '||l_summary_line_id);
993:
994: UPDATE psp_distribution_lines
995: SET summary_line_id = l_summary_line_id WHERE distribution_line_id = l_dist_line_id;
996: ELSIF gl_sum_lines_rec.tab_flag = 'P' THEN

Line 1091: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines status_code to N and summary_line_id to '||l_summary_line_id||' for dist_line_id: '||l_dist_line_id);

1087: FOR j IN 1 .. dist_line_id.COUNT LOOP
1088: l_dist_line_id := dist_line_id(j);
1089:
1090: IF gl_sum_lines_rec.tab_flag = 'D' THEN
1091: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines status_code to N and summary_line_id to '||l_summary_line_id||' for dist_line_id: '||l_dist_line_id);
1092:
1093: UPDATE psp_distribution_lines
1094: SET summary_line_id = l_summary_line_id,
1095: status_code = 'N'

Line 1099: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines status_code to N and summary_line_id to '||l_summary_line_id||' for dist_line_id: '||l_dist_line_id);

1095: status_code = 'N'
1096: WHERE distribution_line_id = l_dist_line_id;
1097: ELSIF gl_sum_lines_rec.tab_flag = 'P' THEN
1098:
1099: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines status_code to N and summary_line_id to '||l_summary_line_id||' for dist_line_id: '||l_dist_line_id);
1100:
1101: UPDATE psp_pre_gen_dist_lines
1102: SET summary_line_id = l_summary_line_id,
1103: status_code = 'N'

Line 2586: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code = A count: '||sql%rowcount);

2582: IF p_source_type = 'O' OR p_source_type = 'N' THEN
2583:
2584: UPDATE psp_distribution_lines
2585: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2586: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code = A count: '||sql%rowcount);
2587:
2588: -- move the transferred records to psp_distribution_lines_history
2589: INSERT INTO psp_distribution_lines_history
2590: (distribution_line_id,payroll_sub_line_id,distribution_date,

Line 2827: (PSP_DISTRIBUTION_LINES_S.NEXTVAL,dist_reversal_entry_rec.payroll_sub_line_id,

2823: (distribution_line_id,payroll_sub_line_id,distribution_date,effective_date,
2824: distribution_amount,status_code,gl_project_flag,reversal_entry_flag,
2825: business_group_id, set_of_books_id)
2826: values
2827: (PSP_DISTRIBUTION_LINES_S.NEXTVAL,dist_reversal_entry_rec.payroll_sub_line_id,
2828: dist_reversal_entry_rec.effective_date,dist_reversal_entry_rec.effective_date,
2829: dist_reversal_entry_rec.reversal_dist_amount,'N','G','Y',
2830: dist_reversal_entry_rec.business_group_id, dist_reversal_entry_rec.set_of_books_id);
2831:

Line 2901: values (psp_distribution_lines_s.nextval, pg_reversal_entry_rec.distribution_interface_id,

2897: element_type_id, distribution_date, effective_date, distribution_amount,
2898: dr_cr_flag, payroll_control_id, source_type, source_code, time_period_id,
2899: batch_name, status_code, set_of_books_id, business_group_id, gl_code_combination_id,
2900: reversal_entry_flag)
2901: values (psp_distribution_lines_s.nextval, pg_reversal_entry_rec.distribution_interface_id,
2902: pg_reversal_entry_rec.person_id, pg_reversal_entry_rec.assignment_id,
2903: pg_reversal_entry_rec.element_type_id, pg_reversal_entry_rec.distribution_date,
2904: pg_reversal_entry_rec.effective_date, pg_reversal_entry_rec.reversal_dist_amount,
2905: pg_reversal_entry_rec.dr_cr_flag, p_payroll_control_id, pg_reversal_entry_rec.source_type,

Line 4765: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_distribution_lines set status_code A count: '||sql%rowcount);

4761: UPDATE psp_distribution_lines
4762: SET status_code = 'A'
4763: WHERE rowid = l_rowid;
4764:
4765: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_distribution_lines set status_code A count: '||sql%rowcount);
4766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code in psp_distribution_lines to A for rowid :'||l_rowid);
4767:
4768: INSERT INTO psp_distribution_lines_history
4769: (distribution_line_id,payroll_sub_line_id,distribution_date,

Line 5087: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set pre_distribution_run_flag count: '||sql%rowcount);

5083: -- effective_date = l_effective_date, ---uncommented this line for Bug 2663344 -- Commented for Bug 10181561
5084: suspense_auto_glccid = l_new_glccid, --- added suspense_auto for 5080403
5085: suspense_auto_exp_type = l_new_expenditure_type
5086: WHERE rowid = l_rowid;
5087: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set pre_distribution_run_flag count: '||sql%rowcount);
5088:
5089: ELSIF p_source_type = 'P' THEN
5090: UPDATE psp_pre_gen_dist_lines
5091: SET suspense_org_account_id = l_organization_account_id,

Line 5332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code to A count: '||sql%rowcount);

5328: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update psp_distribution_lines for summary_line_id'||l_summary_line_id);
5329:
5330: UPDATE psp_distribution_lines
5331: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
5332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code to A count: '||sql%rowcount);
5333:
5334:
5335: -- move the transferred records to psp_distribution_lines_history
5336: INSERT INTO psp_distribution_lines_history