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 HR_UTILITY

Line 70: ---hr_utility.trace_on('Y','SandT');

66:
67: BEGIN
68: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering sum_and_transfer ');
69:
70: ---hr_utility.trace_on('Y','SandT');
71: g_error_api_path := '';
72: fnd_msg_pub.initialize;
73: psp_general.TRANSACTION_CHANGE_PURGEBLE;
74:

Line 4159: hr_utility.trace(' deriving l_txn_source = '|| l_txn_source);

4155: l_txn_source := l_gms_transaction_source;
4156: else
4157: l_txn_source := l_transaction_source;
4158: end if;
4159: hr_utility.trace(' deriving l_txn_source = '|| l_txn_source);
4160: end if; --- phase = 'Summarize_GL_Lines' ..2444657
4161: IF l_rec_count > 0 and gms_batch_rec.phase = 'Summarize_GMS_Lines' THEN ---2444657 -- change
4162:
4163: g_skip_flag_gms := 'N';

Line 4246: hr_utility.trace(' before loop for gms_tie_back');

4242:
4243: -- mark the successfully transferred records as 'A' in psp_summary_lines and psp_distribution_lines
4244: -- and transfer the successful records to the history table
4245: --- Bug 2663344 reverted NULL to l_period_end_date in tie back call
4246: hr_utility.trace(' before loop for gms_tie_back');
4247: FOR I in 1..org_id_tab.count
4248: LOOP
4249: hr_utility.trace(' tab_count ='||i);
4250: l_gms_batch_name := gms_batch_name_tab(I);

Line 4249: hr_utility.trace(' tab_count ='||i);

4245: --- Bug 2663344 reverted NULL to l_period_end_date in tie back call
4246: hr_utility.trace(' before loop for gms_tie_back');
4247: FOR I in 1..org_id_tab.count
4248: LOOP
4249: hr_utility.trace(' tab_count ='||i);
4250: l_gms_batch_name := gms_batch_name_tab(I);
4251: hr_utility.trace(' tab_count 2nd time='||i);
4252:
4253: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gl_tie_back for org_id: '||org_id_tab(I));

Line 4251: hr_utility.trace(' tab_count 2nd time='||i);

4247: FOR I in 1..org_id_tab.count
4248: LOOP
4249: hr_utility.trace(' tab_count ='||i);
4250: l_gms_batch_name := gms_batch_name_tab(I);
4251: hr_utility.trace(' tab_count 2nd time='||i);
4252:
4253: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gl_tie_back for org_id: '||org_id_tab(I));
4254:
4255: gms_tie_back(gms_batch_rec.payroll_control_id,

Line 4264: hr_utility.trace(' after tie back call to gms_tie_back');

4260: p_set_of_books_id,
4261: l_txn_source,
4262: 'N', --Introduced as part of Bug fix #1776606
4263: l_return_status);
4264: hr_utility.trace(' after tie back call to gms_tie_back');
4265:
4266: /* Bug 1617846 LD Recovery LOV not showing up fialed S and T */
4267: /* introduced ELSE clause */
4268:

Line 4624: hr_utility.trace('entered gms_tie_back');

4620: end PROCESS_COMPLETE;
4621:
4622: BEGIN
4623:
4624: hr_utility.trace('entered gms_tie_back');
4625: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' entered gms_tie_back');
4626:
4627:
4628: if NOT PROCESS_COMPLETE then

Line 4637: hr_utility.trace('entered gms_tie_back2');

4633: fnd_msg_pub.add;
4634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4635: end if;
4636: end if;
4637: hr_utility.trace('entered gms_tie_back2');
4638: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' entered gms_tie_back2');
4639:
4640: -- Status codes have been added to transaction import process,
4641: -- to accomodate pre and post import extensions in 11i

Line 4657: hr_utility.trace('entered gms_tie_back3');

4653: /* moved this statement to beginning for 2444657 */
4654: UPDATE psp_payroll_controls
4655: SET phase = 'GL_Tie_Back'
4656: WHERE payroll_control_id = p_payroll_control_id;
4657: hr_utility.trace('entered gms_tie_back3');
4658: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' update psp_payroll_controls SQL%ROWCOUNT :'||SQL%ROWCOUNT);
4659: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' entered gms_tie_back3');
4660:
4661:

Line 4710: hr_utility.trace('entered gms_tie_back4');

4706: SELECT summary_amount,dr_cr_flag
4707: INTO l_summary_amount,l_dr_cr_flag
4708: FROM psp_summary_lines
4709: WHERE summary_line_id = to_number(l_orig_trx_reference) ;
4710: hr_utility.trace('entered gms_tie_back4');
4711: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' entered gms_tie_back4');
4712:
4713:
4714: IF l_dr_cr_flag = 'D' THEN

Line 4721: hr_utility.trace('before open assign_susp_ac_cur');

4717: -- credit is marked as -ve for posting to Oracle Projects
4718: l_cr_summary_amount := l_cr_summary_amount - l_summary_amount;
4719: END IF;
4720: END IF;
4721: hr_utility.trace('before open assign_susp_ac_cur');
4722: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' before open assign_susp_ac_cur');
4723:
4724: OPEN assign_susp_ac_cur(l_orig_trx_reference);
4725: LOOP

Line 4754: hr_utility.trace('entered gms_tie_back5');

4750:
4751: /*Bug 7376898 End*/
4752: END IF;
4753:
4754: hr_utility.trace('entered gms_tie_back5');
4755: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' entered gms_tie_back5');
4756:
4757: IF l_trx_status_code = 'A' THEN
4758: IF p_source_type = 'O' OR p_source_type = 'N' THEN

Line 4805: hr_utility.trace('after insert into dist lines');

4801: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into psp_distribution_lines_history for summary_line_id: '||l_orig_trx_reference
4802: ||'number of rows SQL%ROWCOUNT: '||SQL%ROWCOUNT);
4803: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' after insert into dist lines');
4804:
4805: hr_utility.trace('after insert into dist lines');
4806: DELETE FROM psp_distribution_lines
4807: WHERE status_code = 'A'
4808: AND summary_line_id = to_number(l_orig_trx_reference);
4809:

Line 4856: hr_utility.trace('after insert into pregen lines');

4852: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into psp_pre_gen_distribution_lines_history for summary_line_id: '||l_orig_trx_reference
4853: ||'number of rows SQL%ROWCOUNT: '||SQL%ROWCOUNT);
4854: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' after insert into pregen lines');
4855:
4856: hr_utility.trace('after insert into pregen lines');
4857: DELETE FROM psp_pre_gen_dist_lines
4858: WHERE status_code = 'A'
4859: AND summary_line_id = to_number(l_orig_trx_reference);
4860: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting from psp_pre_gen_distribution_lines for summary_line_id: '||l_orig_trx_reference

Line 5109: hr_utility.trace('update control record');

5105: END IF;
5106:
5107: END LOOP;
5108: END LOOP;
5109: hr_utility.trace('update control record');
5110: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' update control record');
5111:
5112: UPDATE psp_payroll_controls
5113: SET ogm_dr_amount = nvl(ogm_dr_amount,0) + l_dr_summary_amount,

Line 6257: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> Superceded notifier types not found');

6253: fetch get_notify_types into notify_type;
6254: if get_notify_types%notfound then
6255: if get_notify_types%rowcount = 0 then
6256: close get_notify_types;
6257: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> Superceded notifier types not found');
6258: return;
6259: end if;
6260: close get_notify_types;
6261: exit;

Line 6265: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> p_apporver_notify');

6261: exit;
6262: end if;
6263: if notify_type = 'A' then
6264: p_approver_notify := true;
6265: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> p_apporver_notify');
6266: elsif notify_type = 'I' then
6267: p_initiator_notify := true;
6268: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> initiator_notify');
6269: elsif notify_type = 'F' then

Line 6268: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> initiator_notify');

6264: p_approver_notify := true;
6265: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> p_apporver_notify');
6266: elsif notify_type = 'I' then
6267: p_initiator_notify := true;
6268: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> initiator_notify');
6269: elsif notify_type = 'F' then
6270: p_final_recip_notify := true;
6271: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> final_recip_notify');
6272: elsif notify_type = 'E' then

Line 6271: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> final_recip_notify');

6267: p_initiator_notify := true;
6268: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> initiator_notify');
6269: elsif notify_type = 'F' then
6270: p_final_recip_notify := true;
6271: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> final_recip_notify');
6272: elsif notify_type = 'E' then
6273: p_employee_notify := true;
6274: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> p_employee_notify');
6275: end if;

Line 6274: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> p_employee_notify');

6270: p_final_recip_notify := true;
6271: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> final_recip_notify');
6272: elsif notify_type = 'E' then
6273: p_employee_notify := true;
6274: hr_utility.trace( 'SandT_Supercede--> GET_RECIVER_TYPES--> p_employee_notify');
6275: end if;
6276: end loop;
6277:
6278: EXCEPTION

Line 6281: hr_utility.trace( 'SandT_Supercede-->send notifications --> GET_RECEIVER_TYPES when others '||sqlerrm);

6277:
6278: EXCEPTION
6279: when others then
6280: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6281: hr_utility.trace( 'SandT_Supercede-->send notifications --> GET_RECEIVER_TYPES when others '||sqlerrm);
6282: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GET_RECEIVER_TYPES');
6283: raise;
6284: END GET_RECEIVER_TYPES;
6285:

Line 6305: hr_utility.trace('SandT_Supercede--> send_notifications --> call_wf Parameters: p_supercede_reqid_str = '||

6301: l_superceding_proc_param varchar2(500);
6302:
6303: BEGIN
6304:
6305: hr_utility.trace('SandT_Supercede--> send_notifications --> call_wf Parameters: p_supercede_reqid_str = '||
6306: p_supercede_reqid_str||', p_wf_user ='|| p_wf_user||', p_SandT_reqid='||
6307: p_SandT_reqid||
6308: ', p_person_id='||p_person_id||', p_approver_type = '||p_approver_type||
6309: ', p_source_type='|| p_source_type ||', p_source_code='|| p_source_code||

Line 6388: hr_utility.trace( 'SandT_Supercede-->send notifications --> call_wf when others '||sqlerrm);

6384: EXCEPTION
6385: when others then
6386: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6387:
6388: hr_utility.trace( 'SandT_Supercede-->send notifications --> call_wf when others '||sqlerrm);
6389: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CALL_WF');
6390: raise;
6391: END CALL_WF;
6392:

Line 6395: hr_utility.trace( 'SandT_Supercede--> send_notifications--> Begin params : p_supercede_reqid_str= '||

6391: END CALL_WF;
6392:
6393:
6394: BEGIN -- send notifications
6395: hr_utility.trace( 'SandT_Supercede--> send_notifications--> Begin params : p_supercede_reqid_str= '||
6396: p_supercede_reqid_str ||', p_template_id = '||p_template_id ||
6397: ', p_SandT_reqid = '||p_SandT_reqid ||
6398: ', p_batch_name = '||p_batch_name ||
6399: ', p_source_type = '||p_source_type ||

Line 6402: hr_utility.trace( 'SandT_Supercede--> send_notifications-->get_receiver_types');

6398: ', p_batch_name = '||p_batch_name ||
6399: ', p_source_type = '||p_source_type ||
6400: ', p_source_code = '|| p_source_code ||
6401: ', p_time_period_id = '|| p_time_period_id );
6402: hr_utility.trace( 'SandT_Supercede--> send_notifications-->get_receiver_types');
6403: get_receiver_types(p_template_id,
6404: l_init_notify,
6405: l_frp_notify,
6406: l_approver_notify,

Line 6484: hr_utility.trace( 'SandT_Supercede-->send_notifications--> has dynamic part for approver start');

6480: p_time_period_id);
6481: end loop;
6482: end if;
6483:
6484: hr_utility.trace( 'SandT_Supercede-->send_notifications--> has dynamic part for approver start');
6485: if l_approver_notify then
6486: open get_app_wf_names;
6487: fetch get_app_wf_names bulk collect into t_wf_roles;
6488: close get_app_wf_names;

Line 6509: hr_utility.trace( 'SandT_Supercede-->send notifications when others '||sqlerrm);

6505: EXCEPTION
6506: when others then
6507: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6508:
6509: hr_utility.trace( 'SandT_Supercede-->send notifications when others '||sqlerrm);
6510: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SEND_NOTIFICATIONS');
6511: raise;
6512: END SEND_NOTIFICATIONS;
6513: BEGIN ----SUPERCEDE_ER

Line 6515: ---hr_utility.trace_on('Y','ZX');

6511: raise;
6512: END SEND_NOTIFICATIONS;
6513: BEGIN ----SUPERCEDE_ER
6514: --- comment trace.. debug
6515: ---hr_utility.trace_on('Y','ZX');
6516: hr_utility.trace( 'SandT_Supercede--> Begin p_run_id='||p_run_id);
6517: fnd_signon.set_session(to_char(sysdate,'dd-mon-yyyy'));
6518: p_return_status := fnd_api.g_ret_sts_success;
6519: l_S_and_T_reqid := fnd_global.conc_request_id;

Line 6516: hr_utility.trace( 'SandT_Supercede--> Begin p_run_id='||p_run_id);

6512: END SEND_NOTIFICATIONS;
6513: BEGIN ----SUPERCEDE_ER
6514: --- comment trace.. debug
6515: ---hr_utility.trace_on('Y','ZX');
6516: hr_utility.trace( 'SandT_Supercede--> Begin p_run_id='||p_run_id);
6517: fnd_signon.set_session(to_char(sysdate,'dd-mon-yyyy'));
6518: p_return_status := fnd_api.g_ret_sts_success;
6519: l_S_and_T_reqid := fnd_global.conc_request_id;
6520: fnd_stats.gather_table_stats(ownname => 'PSP',

Line 6530: hr_utility.trace( 'SandT_Supercede--> template_id.count='||t_template_id.count);

6526: if t_template_id.count = 0 then
6527: return; --- no template found to supercede
6528: end if;
6529:
6530: hr_utility.trace( 'SandT_Supercede--> template_id.count='||t_template_id.count);
6531:
6532: l_supercede_reqid_str := null;
6533:
6534: delete psp_supercede_persons_gt;

Line 6558: hr_utility.trace( 'SandT_Supercede--> Main Loop Entered');

6554: open check_emp_match_option;
6555: fetch check_emp_match_option into l_count_emp_match;
6556: close check_emp_match_option;
6557: ---fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_count_emp_match = '||l_count_emp_match);
6558: hr_utility.trace( 'SandT_Supercede--> Main Loop Entered');
6559: hr_utility.trace( 'SandT_Supercede--> reqid string, p_source_type, template_id ='||
6560: l_supercede_reqid_str||':'||p_source_type||':'||t_template_id(k));
6561: if l_count_emp_match > 0 then
6562: if p_source_type = 'A' then --- from adjustments s_and_t process.

Line 6559: hr_utility.trace( 'SandT_Supercede--> reqid string, p_source_type, template_id ='||

6555: fetch check_emp_match_option into l_count_emp_match;
6556: close check_emp_match_option;
6557: ---fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_count_emp_match = '||l_count_emp_match);
6558: hr_utility.trace( 'SandT_Supercede--> Main Loop Entered');
6559: hr_utility.trace( 'SandT_Supercede--> reqid string, p_source_type, template_id ='||
6560: l_supercede_reqid_str||':'||p_source_type||':'||t_template_id(k));
6561: if l_count_emp_match > 0 then
6562: if p_source_type = 'A' then --- from adjustments s_and_t process.
6563: open adj_er_supercede;

Line 6599: hr_utility.trace( 'SandT_Supercede--> loaded the superceded persons, count ='|| t_efforts_table.count);

6595: fetch all_asg_er_supercede bulk collect into t_efforts_table, t_person_table, t_sum_line_id;
6596: close all_asg_er_Supercede;
6597: end if; --- source type adjustments
6598: end if;
6599: hr_utility.trace( 'SandT_Supercede--> loaded the superceded persons, count ='|| t_efforts_table.count);
6600: --fnd_file.put_line(fnd_file.log, 'SandT_Supercede--> loaded the superceded persons, count ='|| t_efforts_table.count);
6601: open supercede_tolerance(t_template_id(k));
6602: fetch supercede_tolerance into l_tolerance_amt, l_tolerance_percent;
6603: close supercede_tolerance;

Line 6604: hr_utility.trace( 'SandT_Supercede--> get_tolerance limits AMT, %'||

6600: --fnd_file.put_line(fnd_file.log, 'SandT_Supercede--> loaded the superceded persons, count ='|| t_efforts_table.count);
6601: open supercede_tolerance(t_template_id(k));
6602: fetch supercede_tolerance into l_tolerance_amt, l_tolerance_percent;
6603: close supercede_tolerance;
6604: hr_utility.trace( 'SandT_Supercede--> get_tolerance limits AMT, %'||
6605: nvl(l_tolerance_amt,0)||','|| nvl(l_tolerance_percent,0));
6606:
6607: if t_efforts_table.count > 0 then
6608: hr_utility.trace( 'SandT_Supercede--> t_efforts_table.count > 0');

Line 6608: hr_utility.trace( 'SandT_Supercede--> t_efforts_table.count > 0');

6604: hr_utility.trace( 'SandT_Supercede--> get_tolerance limits AMT, %'||
6605: nvl(l_tolerance_amt,0)||','|| nvl(l_tolerance_percent,0));
6606:
6607: if t_efforts_table.count > 0 then
6608: hr_utility.trace( 'SandT_Supercede--> t_efforts_table.count > 0');
6609: if l_tolerance_amt = -999 and l_tolerance_percent = -999 then
6610: --- if tolerance is not setup then all emps are superceded
6611: --- Summarize/Transfer run will be superceeded.
6612:

Line 6613: hr_utility.trace( 'SandT_Supercede--> Before update Eff table 1');

6609: if l_tolerance_amt = -999 and l_tolerance_percent = -999 then
6610: --- if tolerance is not setup then all emps are superceded
6611: --- Summarize/Transfer run will be superceeded.
6612:
6613: hr_utility.trace( 'SandT_Supercede--> Before update Eff table 1');
6614: i := 1;
6615: loop
6616: if i > t_efforts_table.count then
6617: exit;

Line 6619: hr_utility.trace( 'SandT_Supercede--> Effort report id ='||t_efforts_table(i));

6615: loop
6616: if i > t_efforts_table.count then
6617: exit;
6618: end if;
6619: hr_utility.trace( 'SandT_Supercede--> Effort report id ='||t_efforts_table(i));
6620:
6621: OPEN get_Con_Program_name_csr;
6622: FETCH get_Con_Program_name_csr into l_Con_Program_name;
6623: CLOSE get_Con_Program_name_csr;

Line 6637: hr_utility.trace( 'SandT_Supercede--> Updated the ER table, to put S');

6633:
6634: if sql%rowcount > 0 then
6635: l_superceded_flag := true;
6636: end if;
6637: hr_utility.trace( 'SandT_Supercede--> Updated the ER table, to put S');
6638: i := i + 1;
6639: end loop;
6640: else -- tolerance set to non null value
6641: --- load session temp table

Line 6642: hr_utility.trace( 'SandT_Supercede--> purge GT table - 1');

6638: i := i + 1;
6639: end loop;
6640: else -- tolerance set to non null value
6641: --- load session temp table
6642: hr_utility.trace( 'SandT_Supercede--> purge GT table - 1');
6643: forall i in 1..t_person_table.count
6644: insert into psp_supercede_persons_gt
6645: (person_id)
6646: values (t_person_table(i));

Line 6647: hr_utility.trace( 'SandT_Supercede--> insert into GT potential persons Number of recodrs=' ||t_person_table.count||'person_id =' ||t_person_table(1));

6643: forall i in 1..t_person_table.count
6644: insert into psp_supercede_persons_gt
6645: (person_id)
6646: values (t_person_table(i));
6647: hr_utility.trace( 'SandT_Supercede--> insert into GT potential persons Number of recodrs=' ||t_person_table.count||'person_id =' ||t_person_table(1));
6648: savepoint populate_er_tables;
6649:
6650: -- create fresh ER for comparison
6651: hr_utility.trace( 'SandT_Supercede--> before call to psp_create_eff_reports.populate_eff_tables');

Line 6651: hr_utility.trace( 'SandT_Supercede--> before call to psp_create_eff_reports.populate_eff_tables');

6647: hr_utility.trace( 'SandT_Supercede--> insert into GT potential persons Number of recodrs=' ||t_person_table.count||'person_id =' ||t_person_table(1));
6648: savepoint populate_er_tables;
6649:
6650: -- create fresh ER for comparison
6651: hr_utility.trace( 'SandT_Supercede--> before call to psp_create_eff_reports.populate_eff_tables');
6652: for n in 1..t_template_id.count
6653: loop
6654: if t_template_id(n) = t_template_id(k) then
6655: hr_utility.trace('SandT_Supercede--> call CREATE_EFF params : superced_request='||

Line 6655: hr_utility.trace('SandT_Supercede--> call CREATE_EFF params : superced_request='||

6651: hr_utility.trace( 'SandT_Supercede--> before call to psp_create_eff_reports.populate_eff_tables');
6652: for n in 1..t_template_id.count
6653: loop
6654: if t_template_id(n) = t_template_id(k) then
6655: hr_utility.trace('SandT_Supercede--> call CREATE_EFF params : superced_request='||
6656: t_request_id(n)||' , template_id = '||t_template_id(n));
6657: psp_create_eff_reports.populate_eff_tables(errBuf ,
6658: retCode,
6659: null,

Line 6663: hr_utility.trace('SandT_Supercede--> g_summarization_criteria = '|| PSP_CREATE_EFF_REPORTS.g_summarization_criteria);

6659: null,
6660: t_request_id(n),
6661: null,
6662: 'Y');
6663: hr_utility.trace('SandT_Supercede--> g_summarization_criteria = '|| PSP_CREATE_EFF_REPORTS.g_summarization_criteria);
6664:
6665: end if;
6666: end loop;
6667: hr_utility.trace( 'SandT_Supercede--> after call to psp_create_eff_reports.populate_eff_tables');

Line 6667: hr_utility.trace( 'SandT_Supercede--> after call to psp_create_eff_reports.populate_eff_tables');

6663: hr_utility.trace('SandT_Supercede--> g_summarization_criteria = '|| PSP_CREATE_EFF_REPORTS.g_summarization_criteria);
6664:
6665: end if;
6666: end loop;
6667: hr_utility.trace( 'SandT_Supercede--> after call to psp_create_eff_reports.populate_eff_tables');
6668:
6669: if l_tolerance_amt <> -999 then --- tolerance_amt is not null then
6670: l_sql_string := ' begin
6671: select distinct er.request_id, er.person_id

Line 6716: hr_utility.trace( 'SandT_Supercede--> before exec immediate for tol amt'||l_sql_string);

6712: END IF;
6713: -- Bug 4319874 : END
6714:
6715:
6716: hr_utility.trace( 'SandT_Supercede--> before exec immediate for tol amt'||l_sql_string);
6717: hr_utility.trace( 'SandT_Supercede--> sql_string ='||l_sql_string);
6718: execute immediate l_sql_string
6719: using out t_tolerance_req,
6720: out t_tolerance_per,

Line 6717: hr_utility.trace( 'SandT_Supercede--> sql_string ='||l_sql_string);

6713: -- Bug 4319874 : END
6714:
6715:
6716: hr_utility.trace( 'SandT_Supercede--> before exec immediate for tol amt'||l_sql_string);
6717: hr_utility.trace( 'SandT_Supercede--> sql_string ='||l_sql_string);
6718: execute immediate l_sql_string
6719: using out t_tolerance_req,
6720: out t_tolerance_per,
6721: in abs(l_tolerance_amt);

Line 6722: hr_utility.trace( 'SandT_Supercede--> after exec immediate for tol amt = '||abs(l_tolerance_amt));

6718: execute immediate l_sql_string
6719: using out t_tolerance_req,
6720: out t_tolerance_per,
6721: in abs(l_tolerance_amt);
6722: hr_utility.trace( 'SandT_Supercede--> after exec immediate for tol amt = '||abs(l_tolerance_amt));
6723: else
6724: l_sql_string := ' begin
6725: select distinct er.request_id, er.person_id
6726: bulk collect into :reqtable, :pertable

Line 6769: hr_utility.trace( 'SandT_Supercede--> before exec immediate for tol %');

6765: END IF;
6766: -- Bug 4319874 : END
6767:
6768:
6769: hr_utility.trace( 'SandT_Supercede--> before exec immediate for tol %');
6770: hr_utility.trace( 'SandT_Supercede--> sql_string ='||l_sql_string);
6771: execute immediate l_sql_string
6772: using out t_tolerance_req,
6773: out t_tolerance_per,

Line 6770: hr_utility.trace( 'SandT_Supercede--> sql_string ='||l_sql_string);

6766: -- Bug 4319874 : END
6767:
6768:
6769: hr_utility.trace( 'SandT_Supercede--> before exec immediate for tol %');
6770: hr_utility.trace( 'SandT_Supercede--> sql_string ='||l_sql_string);
6771: execute immediate l_sql_string
6772: using out t_tolerance_req,
6773: out t_tolerance_per,
6774: in abs(l_tolerance_percent);

Line 6775: hr_utility.trace( 'SandT_Supercede--> after exec immediate for tol %');

6771: execute immediate l_sql_string
6772: using out t_tolerance_req,
6773: out t_tolerance_per,
6774: in abs(l_tolerance_percent);
6775: hr_utility.trace( 'SandT_Supercede--> after exec immediate for tol %');
6776: end if;
6777: ---- debug;
6778: ---commit; --- remove commit;
6779: rollback to populate_er_tables;

Line 6780: hr_utility.trace( 'SandT_Supercede--> before tolerance_req.count = '||t_tolerance_req.count);

6776: end if;
6777: ---- debug;
6778: ---commit; --- remove commit;
6779: rollback to populate_er_tables;
6780: hr_utility.trace( 'SandT_Supercede--> before tolerance_req.count = '||t_tolerance_req.count);
6781: for i in 1..t_tolerance_req.count
6782: loop
6783: hr_utility.trace( 'SandT999_Supercede--> before tolerance_req.count = '||t_tolerance_req.count);
6784: open get_eff_id(t_tolerance_req(i), t_tolerance_per(i));

Line 6783: hr_utility.trace( 'SandT999_Supercede--> before tolerance_req.count = '||t_tolerance_req.count);

6779: rollback to populate_er_tables;
6780: hr_utility.trace( 'SandT_Supercede--> before tolerance_req.count = '||t_tolerance_req.count);
6781: for i in 1..t_tolerance_req.count
6782: loop
6783: hr_utility.trace( 'SandT999_Supercede--> before tolerance_req.count = '||t_tolerance_req.count);
6784: open get_eff_id(t_tolerance_req(i), t_tolerance_per(i));
6785: fetch get_eff_id into l_eff_id;
6786: close get_eff_id;
6787: hr_utility.trace( 'SandTTTTTTupercede--> before tolerance_req.count = '||t_tolerance_req.count);

Line 6787: hr_utility.trace( 'SandTTTTTTupercede--> before tolerance_req.count = '||t_tolerance_req.count);

6783: hr_utility.trace( 'SandT999_Supercede--> before tolerance_req.count = '||t_tolerance_req.count);
6784: open get_eff_id(t_tolerance_req(i), t_tolerance_per(i));
6785: fetch get_eff_id into l_eff_id;
6786: close get_eff_id;
6787: hr_utility.trace( 'SandTTTTTTupercede--> before tolerance_req.count = '||t_tolerance_req.count);
6788: t_tolerance_erid(i) := l_eff_id;
6789: hr_utility.trace( 'Sand%%%%%%%%%%cede--> before tolerance_req.count = '||t_tolerance_req.count);
6790: end loop;
6791:

Line 6789: hr_utility.trace( 'Sand%%%%%%%%%%cede--> before tolerance_req.count = '||t_tolerance_req.count);

6785: fetch get_eff_id into l_eff_id;
6786: close get_eff_id;
6787: hr_utility.trace( 'SandTTTTTTupercede--> before tolerance_req.count = '||t_tolerance_req.count);
6788: t_tolerance_erid(i) := l_eff_id;
6789: hr_utility.trace( 'Sand%%%%%%%%%%cede--> before tolerance_req.count = '||t_tolerance_req.count);
6790: end loop;
6791:
6792: hr_utility.trace( 'SandT_Supercede--> before tolerance_erid.count = '||t_tolerance_erid.count);
6793: if t_tolerance_erid.count > 0 then

Line 6792: hr_utility.trace( 'SandT_Supercede--> before tolerance_erid.count = '||t_tolerance_erid.count);

6788: t_tolerance_erid(i) := l_eff_id;
6789: hr_utility.trace( 'Sand%%%%%%%%%%cede--> before tolerance_req.count = '||t_tolerance_req.count);
6790: end loop;
6791:
6792: hr_utility.trace( 'SandT_Supercede--> before tolerance_erid.count = '||t_tolerance_erid.count);
6793: if t_tolerance_erid.count > 0 then
6794: for i in 1..t_tolerance_erid.count
6795: loop
6796: hr_utility.trace( 'SandT_Supercede--> tolerance_erid='||t_tolerance_erid(i));

Line 6796: hr_utility.trace( 'SandT_Supercede--> tolerance_erid='||t_tolerance_erid(i));

6792: hr_utility.trace( 'SandT_Supercede--> before tolerance_erid.count = '||t_tolerance_erid.count);
6793: if t_tolerance_erid.count > 0 then
6794: for i in 1..t_tolerance_erid.count
6795: loop
6796: hr_utility.trace( 'SandT_Supercede--> tolerance_erid='||t_tolerance_erid(i));
6797: for j in 1..t_efforts_table.count
6798: loop
6799: if t_tolerance_erid(i) = t_efforts_table(j) then
6800: hr_utility.trace( 'SandT_Supercede--> MATCH t_Efforts_Table ='|| t_efforts_table(j));

Line 6800: hr_utility.trace( 'SandT_Supercede--> MATCH t_Efforts_Table ='|| t_efforts_table(j));

6796: hr_utility.trace( 'SandT_Supercede--> tolerance_erid='||t_tolerance_erid(i));
6797: for j in 1..t_efforts_table.count
6798: loop
6799: if t_tolerance_erid(i) = t_efforts_table(j) then
6800: hr_utility.trace( 'SandT_Supercede--> MATCH t_Efforts_Table ='|| t_efforts_table(j));
6801: t_tolerance_sline(i) := t_sum_line_id(j);
6802: end if;
6803: end loop;
6804: end loop;

Line 6811: hr_utility.trace( 'SandT_Supercede--> erid='|| t_tolerance_erid(i));

6807: loop
6808: if i > t_tolerance_erid.count then
6809: exit;
6810: end if;
6811: hr_utility.trace( 'SandT_Supercede--> erid='|| t_tolerance_erid(i));
6812: if t_tolerance_sline.exists(i) then
6813: -- found ERs to be superceded.
6814:
6815: OPEN get_Con_Program_name_csr;

Line 6827: hr_utility.trace( 'SandT_Supercede--> Updated erid='|| t_tolerance_erid(i));

6823: superceding_summary_line_id = t_tolerance_sline(i),
6824: superceding_request_id = l_S_and_T_reqid,
6825: superceding_program_name = l_Con_Program_name
6826: where effort_report_id = t_tolerance_erid(i);
6827: hr_utility.trace( 'SandT_Supercede--> Updated erid='|| t_tolerance_erid(i));
6828: if sql%rowcount > 0 then
6829: l_superceded_flag := true;
6830: end if;
6831: end if;

Line 6876: hr_utility.trace( 'SandT_Supercede--> EXITING');

6872: t_tolerance_erid.delete;
6873: t_request_id.delete;
6874: t_template_id.delete;
6875: t_tolerance_sline.delete;
6876: hr_utility.trace( 'SandT_Supercede--> EXITING');
6877: EXCEPTION
6878: when others then
6879: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6880: hr_utility.trace( 'SandT_Supercede--> when others in supercede_er'||sqlerrm) ;

Line 6880: hr_utility.trace( 'SandT_Supercede--> when others in supercede_er'||sqlerrm) ;

6876: hr_utility.trace( 'SandT_Supercede--> EXITING');
6877: EXCEPTION
6878: when others then
6879: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6880: hr_utility.trace( 'SandT_Supercede--> when others in supercede_er'||sqlerrm) ;
6881: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS', 'SUPERCEDE_ER');
6882: p_return_status := fnd_api.g_ret_sts_unexp_error;
6883: END supercede_er;
6884: