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_LABOR_DIST dependencies on HR_UTILITY

Line 298: hr_utility.trace('CDL procedure begin');

294:
295: l_tgl_revb_acc_date varchar2(10);
296:
297: BEGIN
298: hr_utility.trace('CDL procedure begin');
299: g_msg := '';
300: g_error_api_path := '';
301:
302: hr_utility.trace('CDL procedure: g_cap_element_set_id = '||g_cap_element_set_id);

Line 302: hr_utility.trace('CDL procedure: g_cap_element_set_id = '||g_cap_element_set_id);

298: hr_utility.trace('CDL procedure begin');
299: g_msg := '';
300: g_error_api_path := '';
301:
302: hr_utility.trace('CDL procedure: g_cap_element_set_id = '||g_cap_element_set_id);
303: hr_utility.trace('CDL procedure: g_salary_cap_option='|| g_salary_cap_option);
304:
305: open get_tgl_revb_acc_date;
306: fetch get_tgl_revb_acc_date into l_TGL_REVB_ACC_DATE;

Line 303: hr_utility.trace('CDL procedure: g_salary_cap_option='|| g_salary_cap_option);

299: g_msg := '';
300: g_error_api_path := '';
301:
302: hr_utility.trace('CDL procedure: g_cap_element_set_id = '||g_cap_element_set_id);
303: hr_utility.trace('CDL procedure: g_salary_cap_option='|| g_salary_cap_option);
304:
305: open get_tgl_revb_acc_date;
306: fetch get_tgl_revb_acc_date into l_TGL_REVB_ACC_DATE;
307: if get_tgl_revb_acc_date%NOTFOUND then

Line 333: hr_utility.trace('CDL procedure: payroll_rec='|| payroll_control_rec.payroll_control_id);

329: LOOP
330: l_sub_line_dist_amount := 0;
331: g_tot_dist_amount := 0;
332: FETCH payroll_cur INTO payroll_rec;
333: hr_utility.trace('CDL procedure: payroll_rec='|| payroll_control_rec.payroll_control_id);
334: --#fnd_file.put_line(fnd_file.log,'asg id, payroll_sub_line_id ='|| payroll_Rec.assignment_id||','||payroll_rec.payroll_sub_line_id);
335:
336: IF payroll_cur%NOTFOUND
337: THEN

Line 407: hr_utility.trace('l_payroll_action_type ='||payroll_rec.payroll_action_type||'start date, assig id ='|| l_payroll_start_date||','||payroll_rec.assignment_id);

403: l_effective_date := payroll_rec.effective_date;
404: end if;
405: l_count := 0;
406: if payroll_rec.payroll_action_type <> 'R' then --- only for non regular runs
407: hr_utility.trace('l_payroll_action_type ='||payroll_rec.payroll_action_type||'start date, assig id ='|| l_payroll_start_date||','||payroll_rec.assignment_id);
408: open check_adj_exists;
409: fetch check_adj_exists into l_count;
410: close check_adj_exists;
411: end if;

Line 418: hr_utility.trace('l_count = '||l_count);

414: BEGIN
415: fnd_file.put_line (fnd_file.LOG,'Entering begin inside loop3');
416:
417: if payroll_rec.payroll_action_type <> 'R' and l_count > 0 then --- only for non regular runs and pre-adjusted
418: hr_utility.trace('l_count = '||l_count);
419: open get_adjusted_percentages;
420: Fetch get_adjusted_percentages bulk collect into project_id_array,
421: Task_id_array,
422: award_id_array,

Line 448: hr_utility.trace('Close get_adjusted_percentages array_size='||project_id_array.count);

444: when others then
445: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','ADJUSTED_PERCENTAGES');
446: raise;
447: end;
448: hr_utility.trace('Close get_adjusted_percentages array_size='||project_id_array.count);
449: l_sum_adj_amount := 0;
450: for I in 1..adj_amount_array.count
451: loop
452: l_sum_adj_amount := l_sum_adj_amount + adj_amount_array(i);

Line 458: hr_utility.trace('adj_amount_array-100');

454: for I in 1..adj_amount_array.count
455: loop
456: adj_percent_array(i) := adj_amount_array(i) * 100 / l_sum_adj_amount;
457: end loop;
458: hr_utility.trace('adj_amount_array-100');
459: -----create distributions based on this array.
460: L_tot_dist_amount := 0;
461: for I in 1..adj_amount_array.count
462: loop

Line 463: hr_utility.trace('Entered array loop.. adj array');

459: -----create distributions based on this array.
460: L_tot_dist_amount := 0;
461: for I in 1..adj_amount_array.count
462: loop
463: hr_utility.trace('Entered array loop.. adj array');
464: if project_id_array(i) is null then
465: l_gl_project_flag :='G';
466: if nvl(g_use_eff_date, 'N') <> 'Y' then
467: l_effective_date := g_gl_effective_date;

Line 474: hr_utility.trace('l_daily_rate, l_dist_amount, adj_percent ='|| l_daily_rate||','||l_dist_amount||','||adj_percent_array(i));

470: l_gl_project_flag := 'P';
471: end if;
472: if i < adj_amount_array.count then
473: l_dist_amount := round((l_daily_rate * adj_percent_array(i)/100), g_precision);
474: hr_utility.trace('l_daily_rate, l_dist_amount, adj_percent ='|| l_daily_rate||','||l_dist_amount||','||adj_percent_array(i));
475: l_tot_dist_amount := l_tot_dist_amount + l_dist_amount;
476: else --- last line will have the remaining amount.
477: l_dist_amount :=l_daily_rate - l_tot_dist_amount;
478: l_dist_amount := round(l_dist_amount, g_precision);

Line 557: hr_utility.trace('Calling Get_distribution_lines');

553: end loop;
554:
555: else
556: -- dbms_output.put_line('before get dist lines');
557: hr_utility.trace('Calling Get_distribution_lines');
558: Get_Distribution_Lines
559: (p_proc_executed => l_proc_executed,
560: p_person_id => payroll_rec.person_id,
561: p_sub_line_id => payroll_rec.payroll_sub_line_id,

Line 700: hr_utility.trace(' CDL --> create lines --> before call to apply_salary_cap, g_salary_cap = '||g_salary_cap_option);

696: p_return_status => l_return_status);
697: END IF;
698:
699:
700: hr_utility.trace(' CDL --> create lines --> before call to apply_salary_cap, g_salary_cap = '||g_salary_cap_option);
701: -- if Salary Cap is set to Y then call Apply_salary_cap. Enh 4304623
702: If g_salary_cap_option = 'Y' then
703: apply_salary_cap(payroll_control_rec.payroll_control_id,
704: payroll_control_rec.currency_code,

Line 3146: hr_utility.trace('entered org labor schedules proce');

3142: -- total distribution amount by adding the distribution amount in each of the lines.
3143: -- If the schedule line(s) does not exist,set the p_proc_executed flag as FALSE
3144:
3145: OPEN org_labor_schedule_cur(p_assignment_id,p_payroll_start_date);
3146: hr_utility.trace('entered org labor schedules proce');
3147:
3148: LOOP
3149: l_linkage_status := NULL;
3150: l_patc_status := NULL;

Line 3219: hr_utility.trace('inserting dist line for g_org_schedule_autopop ='||g_org_schedule_autopop);

3215: --- l_effective_date := p_effective_date; Bug 1874696
3216: l_gl_project_flag := 'G';
3217:
3218: -- insert the record in psp_distribution_lines
3219: hr_utility.trace('inserting dist line for g_org_schedule_autopop ='||g_org_schedule_autopop);
3220: insert_into_distribution_lines(
3221: P_SUB_LINE_ID, -- payroll sub-lines id
3222: P_PAYROLL_START_DATE, -- distribution date
3223: G_GL_EFFECTIVE_DATE, -- changed from p_effective date Bug 2663344

Line 3268: hr_utility.trace('g_org_schedule_autopop = Y');

3264: ELSIF l_gl_code_combination_id IS NULL THEN
3265:
3266: ---IF (g_auto_population = 'Y' and p_mode='I') THEN -- commented for 5080403
3267: if (g_org_schedule_autopop = 'Y') then
3268: hr_utility.trace('g_org_schedule_autopop = Y');
3269:
3270: -- bug fix 2023955
3271: l_gl_project_flag:='P';
3272:

Line 4115: hr_utility.trace('CDL process --> suspense account proc entered');

4111: l_award_status varchar2(200);
4112:
4113: BEGIN
4114: -- dbms_output.put_line('Entereing suspense');
4115: hr_utility.trace('CDL process --> suspense account proc entered');
4116: p_proc_executed := 'TRUE';
4117: OPEN org_name_cur(p_payroll_start_date,p_assignment_id);
4118: FETCH org_name_cur INTO l_organization_id,l_organization_name;
4119: CLOSE org_name_cur;

Line 4234: hr_utility.trace('CDL process --> suspense account --> suspense l_gl_project_flag ='||l_gl_project_flag);

4230: -- dbms_output.put_line('Payroll date ='||to_char(p_payroll_start_date));
4231: -- dbms_output.put_line('Exp. type ='||l_expenditure_type);
4232: -- dbms_output.put_line('Award id ='||to_char(l_award_id));
4233: */
4234: hr_utility.trace('CDL process --> suspense account --> suspense l_gl_project_flag ='||l_gl_project_flag);
4235: IF l_gl_code_combination_id IS NOT NULL THEN
4236: ---l_effective_date := p_effective_date; Bug 1874696
4237: l_gl_project_flag := 'G';
4238:

Line 4243: hr_utility.trace('CDL process --> suspense account --> dist line not null ='||p_dist_line_id);

4239: -- if (g_auto_population= 'Y' and p_mode='I') then --- for autopop perf bug fixing
4240:
4241: if p_dist_line_id is not null then
4242: -- commented first check and introduced above for bug fix 2463092
4243: hr_utility.trace('CDL process --> suspense account --> dist line not null ='||p_dist_line_id);
4244:
4245: update psp_distribution_lines set
4246: suspense_org_account_id = l_organization_account_id,
4247: suspense_reason_code= p_suspense_reason_code,

Line 5750: hr_utility.trace('Before calling element_type hierarchy-100 parent element id = '||g_retro_parent_element_id);

5746: END IF;
5747: ---5090002 retro parent element.
5748: if g_retro_parent_element_id is not null
5749: and l_proc_executed = 'FALSE' then
5750: hr_utility.trace('Before calling element_type hierarchy-100 parent element id = '||g_retro_parent_element_id);
5751: element_type_hierarchy(
5752: l_proc_executed,
5753: p_person_id,
5754: g_sub_line_id,

Line 6174: hr_utility.trace(' 201 Parent element id = '||autopop_exc_rec.element_type_id);

6170: l_prev_cost_id := autopop_exc_rec.cost_id;
6171: g_retro_parent_element_id := nvl(get_retro_parent_element_id(autopop_exc_rec.cost_id), autopop_exc_rec.element_type_id);
6172: end if;
6173: autopop_exc_rec.element_type_id := g_retro_parent_element_id;
6174: hr_utility.trace(' 201 Parent element id = '||autopop_exc_rec.element_type_id);
6175: end if;
6176: --#fnd_file.put_line(fnd_file.log,'autopop for sched lines exp type, glccid, psob, pbg ='|| autopop_exc_rec.expenditure_type||','||autopop_exc_rec.gl_code_combination_id||','|| p_set_of_books_id||','||p_business_group_id);
6177: if autopop_exc_rec.gl_code_combination_id is null then
6178: l_acct_type:='E';

Line 7025: hr_utility.trace('CDL procedure: --> apply_salary_cap proc Start');

7021: l_msg_token3 varchar2(2000);
7022: l_award_status varchar2(200);
7023: begin
7024:
7025: hr_utility.trace('CDL procedure: --> apply_salary_cap proc Start');
7026:
7027: open get_control_details(p_payroll_control_id);
7028: fetch get_control_details into control_details_rec;
7029: close get_control_details;

Line 7035: hr_utility.trace('CDL program --> apply_salary_cap l_tp_start and end date ='||

7031: open get_period_dates(control_details_rec.time_period_id);
7032: fetch get_period_dates into l_tp_start_date, l_tp_end_date;
7033: close get_period_dates;
7034:
7035: hr_utility.trace('CDL program --> apply_salary_cap l_tp_start and end date ='||
7036: l_tp_start_date||','||l_tp_end_date);
7037:
7038: open get_units_per_year(control_details_rec.payroll_id);
7039: fetch get_units_per_year into l_no_units_per_year;

Line 7048: hr_utility.trace('CDL program --> apply_salary_cap l_sponsor_code (lkup)= '||l_sponsor_code );

7044:
7045: open get_funding_source_codes(l_tp_start_date);
7046: loop
7047: fetch get_funding_source_codes into l_sponsor_code;
7048: hr_utility.trace('CDL program --> apply_salary_cap l_sponsor_code (lkup)= '||l_sponsor_code );
7049: if get_funding_source_codes%notfound then
7050: close get_funding_source_codes;
7051: exit;
7052: end if;

Line 7058: hr_utility.trace('CDL program --> apply_salary_cap WITHIN LOOP l_sponsor_str= '||l_sponsor_str );

7054: psp_general.get_configuration_option_value(p_business_group_id,
7055: 'PSP_SET_SPONSORS_FOR_CAPPING',
7056: l_sponsor_code);
7057: l_sponsor_str := l_sponsor_str ||'@@@'|| l_sponsor_code||rpad(to_char(l_sponsor_id),15);
7058: hr_utility.trace('CDL program --> apply_salary_cap WITHIN LOOP l_sponsor_str= '||l_sponsor_str );
7059: end loop;
7060:
7061: hr_utility.trace('CDL program --> apply_salary_cap l_sponsor_str= '||l_sponsor_str );
7062: l_sponsor_id := 0;

Line 7061: hr_utility.trace('CDL program --> apply_salary_cap l_sponsor_str= '||l_sponsor_str );

7057: l_sponsor_str := l_sponsor_str ||'@@@'|| l_sponsor_code||rpad(to_char(l_sponsor_id),15);
7058: hr_utility.trace('CDL program --> apply_salary_cap WITHIN LOOP l_sponsor_str= '||l_sponsor_str );
7059: end loop;
7060:
7061: hr_utility.trace('CDL program --> apply_salary_cap l_sponsor_str= '||l_sponsor_str );
7062: l_sponsor_id := 0;
7063: open get_salary_cap_setups;
7064: loop
7065: fetch get_salary_cap_setups into cap_rec;

Line 7071: hr_utility.trace('CDL program --> apply_salary_cap cap_rec.sponsor_id, cap_rec.project_id, cap_rec.start_date, cap_rec.enc_date, cap_rec.annual_salary_cap , daily_cap_rate = '||

7067: close get_salary_cap_setups;
7068: exit;
7069: end if;
7070:
7071: hr_utility.trace('CDL program --> apply_salary_cap cap_rec.sponsor_id, cap_rec.project_id, cap_rec.start_date, cap_rec.enc_date, cap_rec.annual_salary_cap , daily_cap_rate = '||
7072: cap_rec.sponsor_id||','||cap_rec.project_id||','|| cap_rec.start_date||','|| cap_rec.end_date||','|| cap_rec.annual_salary_cap||' , '||cap_rec.daily_cap_rate);
7073:
7074: --#fnd_file.put_line(fnd_file.log,
7075: ---'CDL program --> apply_salary_cap cap_rec.sponsor_id, cap_rec.project_id, cap_rec.start_date, cap_rec.enc_date, cap_rec.annual_salary_cap , daily_cap_rate , l_no_units_per_year , l_tp_no_of_work_days= '

Line 7079: hr_utility.trace('CDL program --> apply_salary_cap constructiong element_str');

7075: ---'CDL program --> apply_salary_cap cap_rec.sponsor_id, cap_rec.project_id, cap_rec.start_date, cap_rec.enc_date, cap_rec.annual_salary_cap , daily_cap_rate , l_no_units_per_year , l_tp_no_of_work_days= '
7076: ---|| cap_rec.sponsor_id||','||cap_rec.project_id||','|| cap_rec.start_date||','|| cap_rec.end_date||','|| cap_rec.annual_salary_cap||' , '||cap_rec.daily_cap_rate||' , '||l_no_units_per_year ||' , '||l_tp_no_of_work_days);
7077:
7078: --- removed hard coded strings and replaced with parameters. 5530231
7079: hr_utility.trace('CDL program --> apply_salary_cap constructiong element_str');
7080: --- added assignment_type = E check for 5575398
7081: if g_cap_element_set_id is null then
7082: l_element_sql_str :=
7083: 'and (ppl.assignment_id, ppl.element_type_id) in

Line 7115: hr_utility.trace('CDL program --> apply_salary_cap DONE constructiong element_str');

7111: from pay_element_type_rules petr1
7112: where petr1.include_or_exclude='||''''||'E'||''''||'
7113: and petr1.element_set_id = '||g_cap_element_set_id||');';
7114: end if;
7115: hr_utility.trace('CDL program --> apply_salary_cap DONE constructiong element_str');
7116: if cap_rec.project_id is not null then
7117: hr_utility.trace('CDL program --> apply_salary_cap cap project not null id='||cap_rec.project_id);
7118: l_sql_str :=
7119: 'Select pdl.distribution_line_id,

Line 7117: hr_utility.trace('CDL program --> apply_salary_cap cap project not null id='||cap_rec.project_id);

7113: and petr1.element_set_id = '||g_cap_element_set_id||');';
7114: end if;
7115: hr_utility.trace('CDL program --> apply_salary_cap DONE constructiong element_str');
7116: if cap_rec.project_id is not null then
7117: hr_utility.trace('CDL program --> apply_salary_cap cap project not null id='||cap_rec.project_id);
7118: l_sql_str :=
7119: 'Select pdl.distribution_line_id,
7120: pdl.distribution_date,
7121: pdl.distribution_amount,

Line 7171: hr_utility.trace('CDL program --> apply_salary_cap capping for sponsor ');

7167: nvl(pod.project_id,
7168: nvl(pea.project_id,
7169: pdls.project_id))) = '||cap_rec.project_id;
7170: else --- sponsor_id is not null
7171: hr_utility.trace('CDL program --> apply_salary_cap capping for sponsor ');
7172: l_sql_str :=
7173: ' select pdl.distribution_line_id,
7174: pdl.distribution_date,
7175: pdl.distribution_amount,

Line 7230: hr_utility.trace('CDL program --> After the dist line string is built');

7226: and over.funding_source_code = '||''''||cap_rec.funding_source_code||''''||'
7227: and pdl.distribution_date between over.start_date and over.end_date)';
7228: end if;
7229:
7230: hr_utility.trace('CDL program --> After the dist line string is built');
7231: --#fnd_file.put_line(fnd_file.log,'l_sql_str0 ='||l_sql_str);
7232: if psp_salary_cap_custom.g_parent_sponsor_field is null then
7233: -- by default gms.funding_source_id has sponsor.
7234: l_parent_sponsor_sql_str :=

Line 7250: hr_utility.trace('CDL program --> apply_salary_cap --> l_sql_str=');

7246: || l_element_sql_str ||' '||
7247: ' end; ';
7248:
7249:
7250: hr_utility.trace('CDL program --> apply_salary_cap --> l_sql_str=');
7251: hr_utility.trace(substr(l_sql_str,1,200));
7252: hr_utility.trace(substr(l_sql_str,201,200));
7253: hr_utility.trace(substr(l_sql_str,401,200));
7254: hr_utility.trace(substr(l_sql_str,601,200));

Line 7251: hr_utility.trace(substr(l_sql_str,1,200));

7247: ' end; ';
7248:
7249:
7250: hr_utility.trace('CDL program --> apply_salary_cap --> l_sql_str=');
7251: hr_utility.trace(substr(l_sql_str,1,200));
7252: hr_utility.trace(substr(l_sql_str,201,200));
7253: hr_utility.trace(substr(l_sql_str,401,200));
7254: hr_utility.trace(substr(l_sql_str,601,200));
7255: hr_utility.trace(substr(l_sql_str,801,200));

Line 7252: hr_utility.trace(substr(l_sql_str,201,200));

7248:
7249:
7250: hr_utility.trace('CDL program --> apply_salary_cap --> l_sql_str=');
7251: hr_utility.trace(substr(l_sql_str,1,200));
7252: hr_utility.trace(substr(l_sql_str,201,200));
7253: hr_utility.trace(substr(l_sql_str,401,200));
7254: hr_utility.trace(substr(l_sql_str,601,200));
7255: hr_utility.trace(substr(l_sql_str,801,200));
7256: hr_utility.trace(substr(l_sql_str,1001,200));

Line 7253: hr_utility.trace(substr(l_sql_str,401,200));

7249:
7250: hr_utility.trace('CDL program --> apply_salary_cap --> l_sql_str=');
7251: hr_utility.trace(substr(l_sql_str,1,200));
7252: hr_utility.trace(substr(l_sql_str,201,200));
7253: hr_utility.trace(substr(l_sql_str,401,200));
7254: hr_utility.trace(substr(l_sql_str,601,200));
7255: hr_utility.trace(substr(l_sql_str,801,200));
7256: hr_utility.trace(substr(l_sql_str,1001,200));
7257: hr_utility.trace(substr(l_sql_str,1201,200));

Line 7254: hr_utility.trace(substr(l_sql_str,601,200));

7250: hr_utility.trace('CDL program --> apply_salary_cap --> l_sql_str=');
7251: hr_utility.trace(substr(l_sql_str,1,200));
7252: hr_utility.trace(substr(l_sql_str,201,200));
7253: hr_utility.trace(substr(l_sql_str,401,200));
7254: hr_utility.trace(substr(l_sql_str,601,200));
7255: hr_utility.trace(substr(l_sql_str,801,200));
7256: hr_utility.trace(substr(l_sql_str,1001,200));
7257: hr_utility.trace(substr(l_sql_str,1201,200));
7258: hr_utility.trace(substr(l_sql_str,1401,200));

Line 7255: hr_utility.trace(substr(l_sql_str,801,200));

7251: hr_utility.trace(substr(l_sql_str,1,200));
7252: hr_utility.trace(substr(l_sql_str,201,200));
7253: hr_utility.trace(substr(l_sql_str,401,200));
7254: hr_utility.trace(substr(l_sql_str,601,200));
7255: hr_utility.trace(substr(l_sql_str,801,200));
7256: hr_utility.trace(substr(l_sql_str,1001,200));
7257: hr_utility.trace(substr(l_sql_str,1201,200));
7258: hr_utility.trace(substr(l_sql_str,1401,200));
7259: hr_utility.trace(substr(l_sql_str,1601,200));

Line 7256: hr_utility.trace(substr(l_sql_str,1001,200));

7252: hr_utility.trace(substr(l_sql_str,201,200));
7253: hr_utility.trace(substr(l_sql_str,401,200));
7254: hr_utility.trace(substr(l_sql_str,601,200));
7255: hr_utility.trace(substr(l_sql_str,801,200));
7256: hr_utility.trace(substr(l_sql_str,1001,200));
7257: hr_utility.trace(substr(l_sql_str,1201,200));
7258: hr_utility.trace(substr(l_sql_str,1401,200));
7259: hr_utility.trace(substr(l_sql_str,1601,200));
7260: hr_utility.trace(substr(l_sql_str,1801,200));

Line 7257: hr_utility.trace(substr(l_sql_str,1201,200));

7253: hr_utility.trace(substr(l_sql_str,401,200));
7254: hr_utility.trace(substr(l_sql_str,601,200));
7255: hr_utility.trace(substr(l_sql_str,801,200));
7256: hr_utility.trace(substr(l_sql_str,1001,200));
7257: hr_utility.trace(substr(l_sql_str,1201,200));
7258: hr_utility.trace(substr(l_sql_str,1401,200));
7259: hr_utility.trace(substr(l_sql_str,1601,200));
7260: hr_utility.trace(substr(l_sql_str,1801,200));
7261: hr_utility.trace(substr(l_sql_str,2001,200));

Line 7258: hr_utility.trace(substr(l_sql_str,1401,200));

7254: hr_utility.trace(substr(l_sql_str,601,200));
7255: hr_utility.trace(substr(l_sql_str,801,200));
7256: hr_utility.trace(substr(l_sql_str,1001,200));
7257: hr_utility.trace(substr(l_sql_str,1201,200));
7258: hr_utility.trace(substr(l_sql_str,1401,200));
7259: hr_utility.trace(substr(l_sql_str,1601,200));
7260: hr_utility.trace(substr(l_sql_str,1801,200));
7261: hr_utility.trace(substr(l_sql_str,2001,200));
7262: hr_utility.trace(substr(l_sql_str,2201,200));

Line 7259: hr_utility.trace(substr(l_sql_str,1601,200));

7255: hr_utility.trace(substr(l_sql_str,801,200));
7256: hr_utility.trace(substr(l_sql_str,1001,200));
7257: hr_utility.trace(substr(l_sql_str,1201,200));
7258: hr_utility.trace(substr(l_sql_str,1401,200));
7259: hr_utility.trace(substr(l_sql_str,1601,200));
7260: hr_utility.trace(substr(l_sql_str,1801,200));
7261: hr_utility.trace(substr(l_sql_str,2001,200));
7262: hr_utility.trace(substr(l_sql_str,2201,200));
7263: hr_utility.trace(substr(l_sql_str,2401,200));

Line 7260: hr_utility.trace(substr(l_sql_str,1801,200));

7256: hr_utility.trace(substr(l_sql_str,1001,200));
7257: hr_utility.trace(substr(l_sql_str,1201,200));
7258: hr_utility.trace(substr(l_sql_str,1401,200));
7259: hr_utility.trace(substr(l_sql_str,1601,200));
7260: hr_utility.trace(substr(l_sql_str,1801,200));
7261: hr_utility.trace(substr(l_sql_str,2001,200));
7262: hr_utility.trace(substr(l_sql_str,2201,200));
7263: hr_utility.trace(substr(l_sql_str,2401,200));
7264: hr_utility.trace(substr(l_sql_str,2601,200));

Line 7261: hr_utility.trace(substr(l_sql_str,2001,200));

7257: hr_utility.trace(substr(l_sql_str,1201,200));
7258: hr_utility.trace(substr(l_sql_str,1401,200));
7259: hr_utility.trace(substr(l_sql_str,1601,200));
7260: hr_utility.trace(substr(l_sql_str,1801,200));
7261: hr_utility.trace(substr(l_sql_str,2001,200));
7262: hr_utility.trace(substr(l_sql_str,2201,200));
7263: hr_utility.trace(substr(l_sql_str,2401,200));
7264: hr_utility.trace(substr(l_sql_str,2601,200));
7265: hr_utility.trace(substr(l_sql_str,2801,200));

Line 7262: hr_utility.trace(substr(l_sql_str,2201,200));

7258: hr_utility.trace(substr(l_sql_str,1401,200));
7259: hr_utility.trace(substr(l_sql_str,1601,200));
7260: hr_utility.trace(substr(l_sql_str,1801,200));
7261: hr_utility.trace(substr(l_sql_str,2001,200));
7262: hr_utility.trace(substr(l_sql_str,2201,200));
7263: hr_utility.trace(substr(l_sql_str,2401,200));
7264: hr_utility.trace(substr(l_sql_str,2601,200));
7265: hr_utility.trace(substr(l_sql_str,2801,200));
7266: --- added more trace for 5899407

Line 7263: hr_utility.trace(substr(l_sql_str,2401,200));

7259: hr_utility.trace(substr(l_sql_str,1601,200));
7260: hr_utility.trace(substr(l_sql_str,1801,200));
7261: hr_utility.trace(substr(l_sql_str,2001,200));
7262: hr_utility.trace(substr(l_sql_str,2201,200));
7263: hr_utility.trace(substr(l_sql_str,2401,200));
7264: hr_utility.trace(substr(l_sql_str,2601,200));
7265: hr_utility.trace(substr(l_sql_str,2801,200));
7266: --- added more trace for 5899407
7267: if substr(l_sql_str,3000,200) is not null then

Line 7264: hr_utility.trace(substr(l_sql_str,2601,200));

7260: hr_utility.trace(substr(l_sql_str,1801,200));
7261: hr_utility.trace(substr(l_sql_str,2001,200));
7262: hr_utility.trace(substr(l_sql_str,2201,200));
7263: hr_utility.trace(substr(l_sql_str,2401,200));
7264: hr_utility.trace(substr(l_sql_str,2601,200));
7265: hr_utility.trace(substr(l_sql_str,2801,200));
7266: --- added more trace for 5899407
7267: if substr(l_sql_str,3000,200) is not null then
7268: hr_utility.trace(substr(l_sql_str,3000,200));

Line 7265: hr_utility.trace(substr(l_sql_str,2801,200));

7261: hr_utility.trace(substr(l_sql_str,2001,200));
7262: hr_utility.trace(substr(l_sql_str,2201,200));
7263: hr_utility.trace(substr(l_sql_str,2401,200));
7264: hr_utility.trace(substr(l_sql_str,2601,200));
7265: hr_utility.trace(substr(l_sql_str,2801,200));
7266: --- added more trace for 5899407
7267: if substr(l_sql_str,3000,200) is not null then
7268: hr_utility.trace(substr(l_sql_str,3000,200));
7269: end if;

Line 7268: hr_utility.trace(substr(l_sql_str,3000,200));

7264: hr_utility.trace(substr(l_sql_str,2601,200));
7265: hr_utility.trace(substr(l_sql_str,2801,200));
7266: --- added more trace for 5899407
7267: if substr(l_sql_str,3000,200) is not null then
7268: hr_utility.trace(substr(l_sql_str,3000,200));
7269: end if;
7270: if substr(l_sql_str,3201,200) is not null then
7271: hr_utility.trace(substr(l_sql_str,3201,200));
7272: end if;

Line 7271: hr_utility.trace(substr(l_sql_str,3201,200));

7267: if substr(l_sql_str,3000,200) is not null then
7268: hr_utility.trace(substr(l_sql_str,3000,200));
7269: end if;
7270: if substr(l_sql_str,3201,200) is not null then
7271: hr_utility.trace(substr(l_sql_str,3201,200));
7272: end if;
7273: if substr(l_sql_str,3401,200) is not null then
7274: hr_utility.trace(substr(l_sql_str,3401,200));
7275: end if;

Line 7274: hr_utility.trace(substr(l_sql_str,3401,200));

7270: if substr(l_sql_str,3201,200) is not null then
7271: hr_utility.trace(substr(l_sql_str,3201,200));
7272: end if;
7273: if substr(l_sql_str,3401,200) is not null then
7274: hr_utility.trace(substr(l_sql_str,3401,200));
7275: end if;
7276:
7277: --#fnd_file.put_line(fnd_file.log,' before exec immediate l_sql_str ='||l_sql_str);
7278: execute immediate l_sql_str

Line 7287: hr_utility.trace('CDL program --> apply_salary_cap --> dist_line_id.count='||t_dist_line_id.count);

7283: out t_assignment_id,
7284: out t_excess_account,
7285: out t_excess_line_id;
7286:
7287: hr_utility.trace('CDL program --> apply_salary_cap --> dist_line_id.count='||t_dist_line_id.count);
7288: for i in 1..t_dist_line_id.count
7289: loop
7290: open org_excess_act(t_assignment_id(i), t_dist_date(i), cap_rec.funding_source_code); -- introduced sponsor 4744285
7291: fetch org_excess_act into l_account_id;

Line 7299: hr_utility.trace('CDL program --> apply_salary_cap --> NO_EXCESS_ACCOUNT for asg, date ='||t_assignment_id(i)||','|| t_dist_date(i));

7295: fetch generic_excess_act into l_account_id;
7296: if generic_excess_act%notfound then
7297: close org_excess_act;
7298: close generic_excess_act;
7299: hr_utility.trace('CDL program --> apply_salary_cap --> NO_EXCESS_ACCOUNT for asg, date ='||t_assignment_id(i)||','|| t_dist_date(i));
7300:
7301: open get_asg_number(t_assignment_id(i));
7302: fetch get_asg_number into l_person_id, l_asg_number;
7303: close get_asg_number;

Line 7379: hr_utility.trace('CDL Program --> apply_salary_cap --> Excess array count='||t_excess_line_id.count);

7375: funding_source_code = cap_rec.funding_source_code,
7376: annual_salary_cap = cap_rec.annual_salary_cap
7377: where distribution_line_id = t_dist_line_id(i);
7378:
7379: hr_utility.trace('CDL Program --> apply_salary_cap --> Excess array count='||t_excess_line_id.count);
7380: for i in 1..t_excess_line_id.count
7381: loop
7382: open check_excess_poeta(t_excess_line_id(i));
7383: fetch check_excess_poeta into check_excess_poeta_rec;

Line 7385: hr_utility.trace(

7381: loop
7382: open check_excess_poeta(t_excess_line_id(i));
7383: fetch check_excess_poeta into check_excess_poeta_rec;
7384: if check_excess_poeta%found then
7385: hr_utility.trace(
7386: 'CDL program --> apply_salary_cap --> Excess account Suspense check for dist line id ='||
7387: t_excess_line_id(i));
7388:
7389: hr_utility.trace(

Line 7389: hr_utility.trace(

7385: hr_utility.trace(
7386: 'CDL program --> apply_salary_cap --> Excess account Suspense check for dist line id ='||
7387: t_excess_line_id(i));
7388:
7389: hr_utility.trace(
7390: 'CDL program --> apply_salary_cap --> calling pa_txn_pub x_project_id=>'||
7391: check_excess_poeta_rec.cap_excess_project_id||
7392: ', x_task_id=>'|| check_excess_poeta_rec.cap_excess_task_id||
7393: ', x_ei_date=>'|| check_excess_poeta_rec.effective_date||

Line 7417: hr_utility.trace(

7413: x_billable_flag => l_billable_flag,
7414: p_sys_link_function => 'ST'); --Bug 5639589: Added parameter
7415:
7416:
7417: hr_utility.trace(
7418: 'CDL program --> apply_salary_cap --> Excess account Suspense l_patc ='||l_patc_status);
7419: if check_excess_poeta_rec.cap_excess_award_id is not null and l_patc_status is null
7420: then
7421: gms_transactions_pub.validate_transaction

Line 7430: hr_utility.trace(

7426: check_excess_poeta_rec.effective_date,
7427: 'PSPLDCDB',
7428: l_award_status);
7429:
7430: hr_utility.trace(
7431: 'CDL program --> apply_salary_cap --> Excess account Suspense l_award_status ='||
7432: l_award_status);
7433:
7434: if l_award_status IS NOT NULL then

Line 7441: hr_utility.trace( 'CDL program --> apply_salary_cap --> invoke suspense_acc prarams ='||

7437: end if;
7438: IF ( l_patc_status IS NOT NULL ) OR
7439: (l_award_status is not null ) THEN
7440:
7441: hr_utility.trace( 'CDL program --> apply_salary_cap --> invoke suspense_acc prarams ='||
7442: check_excess_poeta_rec.person_id||','||
7443: check_excess_poeta_rec.payroll_sub_line_id||','||
7444: check_excess_poeta_rec.assignment_id||','||
7445: check_excess_poeta_rec.distribution_date||','||

Line 7970: hr_utility.trace('Entering generic_account_autopop');

7966: and paf.assignment_id = p_assignment_id
7967: and p_eff_date between paf.effective_start_date and paf.effective_end_date
7968: and paf.organization_id = hou.organization_id;
7969: begin
7970: hr_utility.trace('Entering generic_account_autopop');
7971:
7972: if p_schedule_type = 'GLOBAL_ELEMENT' then
7973: open global_elem_account_cur;
7974: fetch global_elem_account_cur bulk collect into t_payroll_sub_line_id,

Line 8114: hr_utility.trace('generic_account_autopop gl_ccid = '||t_gl_code_combination_id(i));

8110: if p_schedule_type = 'SUSPENSE' then
8111: open get_person_details(t_person_id(i), t_assignment_id(i), l_effective_date);
8112: fetch get_person_details into l_employee_name, l_asg_num, l_organization_name;
8113: close get_person_details;
8114: hr_utility.trace('generic_account_autopop gl_ccid = '||t_gl_code_combination_id(i));
8115: psp_enc_crt_xml.p_set_of_books_id := p_set_of_books_id;
8116: psp_enc_crt_xml.p_business_group_id := p_business_group_id;
8117: l_account :=
8118: psp_enc_crt_xml.cf_charging_instformula(t_gl_code_combination_id(i),

Line 8393: ---hr_utility.trace_on('Y','CDL-1');

8389: and legislation_code is null
8390: and nvl(business_group_id, g_business_group_id) = g_business_group_id;
8391:
8392: begin
8393: ---hr_utility.trace_on('Y','CDL-1');
8394: select get_parameter('SOURCE_TYPE',ppa.legislative_parameters) ,
8395: get_parameter('SOURCE_CODE',ppa.legislative_parameters) ,
8396: get_parameter('TIME_PERIOD_ID',ppa.legislative_parameters),
8397: get_parameter('BATCH_NAME',ppa.legislative_parameters),

Line 8439: hr_utility.trace('CDL procedure: setting g_cap_element_set_id');

8435:
8436: g_dff_grouping_option := psp_general.get_act_dff_grouping_option(g_business_group_id); -- Introduced for bug fix 2908859
8437:
8438: g_salary_cap_option := psp_general.get_configuration_option_value(g_business_group_id, 'PSP_ENABLE_SALARY_CAP');
8439: hr_utility.trace('CDL procedure: setting g_cap_element_set_id');
8440: if g_salary_cap_option = 'Y' then
8441: g_cap_element_set_id := psp_general.get_configuration_option_value(g_business_group_id, 'PSP_CAP_ELEMENT_SET_ID');
8442: g_gen_excess_org_id := -- 4744285
8443: psp_general.get_configuration_option_value(g_business_group_id, 'PSP_GENERIC_EXCESS_ACCT_ORG');

Line 8522: --- hr_utility.trace_on('Y','CDL-2');

8518:
8519: l_payroll_control_id integer;
8520:
8521: begin
8522: --- hr_utility.trace_on('Y','CDL-2');
8523: select get_parameter('SOURCE_TYPE',ppa.legislative_parameters) ,
8524: get_parameter('SOURCE_CODE',ppa.legislative_parameters) ,
8525: get_parameter('TIME_PERIOD_ID',ppa.legislative_parameters),
8526: get_parameter('BATCH_NAME',ppa.legislative_parameters),

Line 8559: hr_utility.trace('CDL process --> range_code --> source_type, source_code, time_period_id, batch_name = '||

8555:
8556: if psp_general.get_configuration_option_value(g_business_group_id, 'PSP_ENABLE_SALARY_CAP') = 'Y' then
8557: l_error_flag := 'N';
8558:
8559: hr_utility.trace('CDL process --> range_code --> source_type, source_code, time_period_id, batch_name = '||
8560: g_source_code||','||g_source_type||','||g_time_period_id||','||g_batch_name);
8561:
8562: open get_min_max_dist_date;
8563: fetch get_min_max_dist_date into l_begin_dist_date, l_end_dist_date;

Line 8567: hr_utility.trace('CDL process --> range_code --> l_begin_dist_date = '||l_begin_dist_date);

8563: fetch get_min_max_dist_date into l_begin_dist_date, l_end_dist_date;
8564: close get_min_max_dist_date;
8565:
8566: --fnd_file.put_line(fnd_file.log,' l_begin_dist_date = '||l_begin_dist_date||' , l_end_dist_date='||l_end_dist_date);
8567: hr_utility.trace('CDL process --> range_code --> l_begin_dist_date = '||l_begin_dist_date);
8568:
8569: l_gen_excess_org_id := -- 4744285
8570: psp_general.get_configuration_option_value(g_business_group_id,
8571: 'PSP_GENERIC_EXCESS_ACCT_ORG');

Line 8701: hr_utility.trace('CHUNK_STATUS = '||l_chunk_status);

8697:
8698: open get_chunk_status;
8699: fetch get_chunk_status into l_chunk_status;
8700:
8701: hr_utility.trace('CHUNK_STATUS = '||l_chunk_status);
8702: if l_chunk_status <> 'C' then
8703:
8704: hr_utility.trace('########START_ARCHIVE##### g_source_type, g_source_code, g_payroll_id, g_time_period_id, g_batch_name, g_business_group_id, l_chunk_status)='|| g_source_type||','||
8705: g_source_code||','||

Line 8704: hr_utility.trace('########START_ARCHIVE##### g_source_type, g_source_code, g_payroll_id, g_time_period_id, g_batch_name, g_business_group_id, l_chunk_status)='|| g_source_type||','||

8700:
8701: hr_utility.trace('CHUNK_STATUS = '||l_chunk_status);
8702: if l_chunk_status <> 'C' then
8703:
8704: hr_utility.trace('########START_ARCHIVE##### g_source_type, g_source_code, g_payroll_id, g_time_period_id, g_batch_name, g_business_group_id, l_chunk_status)='|| g_source_type||','||
8705: g_source_code||','||
8706: g_payroll_id||','||
8707: g_time_period_id||','||
8708: g_batch_name||','||

Line 8746: hr_utility.trace('########START_ARCHIVE#####SLEEP');

8742: g_set_of_books_id,
8743: l_start_asg,
8744: l_end_asg);
8745: /*if 12467 between l_start_asg and l_end_asg then
8746: hr_utility.trace('########START_ARCHIVE#####SLEEP');
8747: raise no_data_found;
8748: end if; */
8749: end if;
8750: close get_chunk_status;

Line 8875: hr_utility.trace('CDL process --> deinit action_status ='||l_count_fail_actions);

8871: end if;
8872:
8873:
8874: --#fnd_file.put_line(fnd_file.log,'########entered deinit#######');
8875: hr_utility.trace('CDL process --> deinit action_status ='||l_count_fail_actions);
8876:
8877: if l_count_fail_actions = 0 then
8878: open payroll_control_cur;
8879: loop