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

Line 102: hr_utility.set_location ('In Overloaded ASG_PROC_PTD_EC',10);

98: ) is
99:
100: begin
101:
102: hr_utility.set_location ('In Overloaded ASG_PROC_PTD_EC',10);
103: hr_utility.set_location ('Namish:p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
104: hr_utility.set_location ('Namish:p_owner_effective_date:'||p_owner_effective_date,10);
105: hr_utility.set_location ('Namish:p_user_payroll_action_id:'||p_user_payroll_action_id,10);
106: hr_utility.set_location ('Namish:p_user_effective_date:'||p_user_effective_date,10);

Line 103: hr_utility.set_location ('Namish:p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);

99:
100: begin
101:
102: hr_utility.set_location ('In Overloaded ASG_PROC_PTD_EC',10);
103: hr_utility.set_location ('Namish:p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
104: hr_utility.set_location ('Namish:p_owner_effective_date:'||p_owner_effective_date,10);
105: hr_utility.set_location ('Namish:p_user_payroll_action_id:'||p_user_payroll_action_id,10);
106: hr_utility.set_location ('Namish:p_user_effective_date:'||p_user_effective_date,10);
107: hr_utility.set_location ('Nam - Asg Action ID: '||p_owner_assignment_action_id||' - '||p_user_assignment_action_id||' - '||p_dimension_name,11);

Line 104: hr_utility.set_location ('Namish:p_owner_effective_date:'||p_owner_effective_date,10);

100: begin
101:
102: hr_utility.set_location ('In Overloaded ASG_PROC_PTD_EC',10);
103: hr_utility.set_location ('Namish:p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
104: hr_utility.set_location ('Namish:p_owner_effective_date:'||p_owner_effective_date,10);
105: hr_utility.set_location ('Namish:p_user_payroll_action_id:'||p_user_payroll_action_id,10);
106: hr_utility.set_location ('Namish:p_user_effective_date:'||p_user_effective_date,10);
107: hr_utility.set_location ('Nam - Asg Action ID: '||p_owner_assignment_action_id||' - '||p_user_assignment_action_id||' - '||p_dimension_name,11);
108:

Line 105: hr_utility.set_location ('Namish:p_user_payroll_action_id:'||p_user_payroll_action_id,10);

101:
102: hr_utility.set_location ('In Overloaded ASG_PROC_PTD_EC',10);
103: hr_utility.set_location ('Namish:p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
104: hr_utility.set_location ('Namish:p_owner_effective_date:'||p_owner_effective_date,10);
105: hr_utility.set_location ('Namish:p_user_payroll_action_id:'||p_user_payroll_action_id,10);
106: hr_utility.set_location ('Namish:p_user_effective_date:'||p_user_effective_date,10);
107: hr_utility.set_location ('Nam - Asg Action ID: '||p_owner_assignment_action_id||' - '||p_user_assignment_action_id||' - '||p_dimension_name,11);
108:
109: /* 11887149 begin

Line 106: hr_utility.set_location ('Namish:p_user_effective_date:'||p_user_effective_date,10);

102: hr_utility.set_location ('In Overloaded ASG_PROC_PTD_EC',10);
103: hr_utility.set_location ('Namish:p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
104: hr_utility.set_location ('Namish:p_owner_effective_date:'||p_owner_effective_date,10);
105: hr_utility.set_location ('Namish:p_user_payroll_action_id:'||p_user_payroll_action_id,10);
106: hr_utility.set_location ('Namish:p_user_effective_date:'||p_user_effective_date,10);
107: hr_utility.set_location ('Nam - Asg Action ID: '||p_owner_assignment_action_id||' - '||p_user_assignment_action_id||' - '||p_dimension_name,11);
108:
109: /* 11887149 begin
110: SELECT ptp.end_date

Line 107: hr_utility.set_location ('Nam - Asg Action ID: '||p_owner_assignment_action_id||' - '||p_user_assignment_action_id||' - '||p_dimension_name,11);

103: hr_utility.set_location ('Namish:p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
104: hr_utility.set_location ('Namish:p_owner_effective_date:'||p_owner_effective_date,10);
105: hr_utility.set_location ('Namish:p_user_payroll_action_id:'||p_user_payroll_action_id,10);
106: hr_utility.set_location ('Namish:p_user_effective_date:'||p_user_effective_date,10);
107: hr_utility.set_location ('Nam - Asg Action ID: '||p_owner_assignment_action_id||' - '||p_user_assignment_action_id||' - '||p_dimension_name,11);
108:
109: /* 11887149 begin
110: SELECT ptp.end_date
111: INTO p_expiry_information

Line 129: hr_utility.set_location ('p_expiry_information:'||p_expiry_information,10);

125: --11887149 end;
126:
127:
128:
129: hr_utility.set_location ('p_expiry_information:'||p_expiry_information,10);
130: end ASG_PROC_PTD_EC;
131:
132:
133: /*------------------------------ ASG_PROC_YTD_EC ----------------------------*/

Line 217: hr_utility.set_location ('In Overloaded ASG_PROC_YTD',10);

213: p_expiry_information out nocopy date -- dimension expired flag.
214: ) is
215: begin
216:
217: hr_utility.set_location ('In Overloaded ASG_PROC_YTD',10);
218: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
219: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);
220: hr_utility.set_location ('p_dimension_name:'||p_dimension_name,10);
221:

Line 218: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);

214: ) is
215: begin
216:
217: hr_utility.set_location ('In Overloaded ASG_PROC_YTD',10);
218: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
219: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);
220: hr_utility.set_location ('p_dimension_name:'||p_dimension_name,10);
221:
222: SELECT to_date('05-04-' ||to_char(fnd_number.canonical_to_number(

Line 219: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);

215: begin
216:
217: hr_utility.set_location ('In Overloaded ASG_PROC_YTD',10);
218: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
219: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);
220: hr_utility.set_location ('p_dimension_name:'||p_dimension_name,10);
221:
222: SELECT to_date('05-04-' ||to_char(fnd_number.canonical_to_number(
223: to_char( PTP.regular_payment_date,'YYYY'))

Line 220: hr_utility.set_location ('p_dimension_name:'||p_dimension_name,10);

216:
217: hr_utility.set_location ('In Overloaded ASG_PROC_YTD',10);
218: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
219: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);
220: hr_utility.set_location ('p_dimension_name:'||p_dimension_name,10);
221:
222: SELECT to_date('05-04-' ||to_char(fnd_number.canonical_to_number(
223: to_char( PTP.regular_payment_date,'YYYY'))
224: + decode(sign( PTP.regular_payment_date -

Line 233: hr_utility.set_location ('p_expiry_information:'||p_expiry_information,10);

229: pay_payroll_actions BACT
230: WHERE BACT.payroll_action_id = p_owner_payroll_action_id
231: AND PTP.time_period_id = BACT.time_period_id;
232:
233: hr_utility.set_location ('p_expiry_information:'||p_expiry_information,10);
234:
235: end ASG_PROC_YTD_EC;
236:
237:

Line 325: hr_utility.set_location ('In Overloaded ASG_PEN_YTD_EC',10);

321: p_expiry_information out nocopy date -- dimension expired date.
322: ) is
323: begin
324:
325: hr_utility.set_location ('In Overloaded ASG_PEN_YTD_EC',10);
326: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
327: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);
328:
329: SELECT to_date('31-03-' ||to_char(fnd_number.canonical_to_number(

Line 326: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);

322: ) is
323: begin
324:
325: hr_utility.set_location ('In Overloaded ASG_PEN_YTD_EC',10);
326: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
327: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);
328:
329: SELECT to_date('31-03-' ||to_char(fnd_number.canonical_to_number(
330: to_char( PTP.regular_payment_date,'YYYY'))

Line 327: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);

323: begin
324:
325: hr_utility.set_location ('In Overloaded ASG_PEN_YTD_EC',10);
326: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
327: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);
328:
329: SELECT to_date('31-03-' ||to_char(fnd_number.canonical_to_number(
330: to_char( PTP.regular_payment_date,'YYYY'))
331: + decode(sign( PTP.regular_payment_date -

Line 340: hr_utility.set_location ('p_expiry_information:'||p_expiry_information,10);

336: pay_payroll_actions BACT
337: WHERE BACT.payroll_action_id = p_owner_payroll_action_id
338: AND PTP.time_period_id = BACT.time_period_id;
339:
340: hr_utility.set_location ('p_expiry_information:'||p_expiry_information,10);
341:
342: end ASG_PEN_YTD_EC;
343:
344:

Line 400: hr_utility.set_location ('In Overloaded ASG_STAT_YTD_EC',10);

396: p_expiry_information out nocopy date -- dimension expired flag.
397: ) is
398: begin
399:
400: hr_utility.set_location ('In Overloaded ASG_STAT_YTD_EC',10);
401: hr_utility.set_location ('Namish:p_owner_assignment_action_id:'||p_owner_assignment_action_id,10);
402: hr_utility.set_location ('Namish:p_owner_effective_date:'||p_owner_effective_date,10);
403:
404: SELECT to_date('05-04-' ||to_char(fnd_number.canonical_to_number(

Line 401: hr_utility.set_location ('Namish:p_owner_assignment_action_id:'||p_owner_assignment_action_id,10);

397: ) is
398: begin
399:
400: hr_utility.set_location ('In Overloaded ASG_STAT_YTD_EC',10);
401: hr_utility.set_location ('Namish:p_owner_assignment_action_id:'||p_owner_assignment_action_id,10);
402: hr_utility.set_location ('Namish:p_owner_effective_date:'||p_owner_effective_date,10);
403:
404: SELECT to_date('05-04-' ||to_char(fnd_number.canonical_to_number(
405: to_char( p_owner_effective_date,'YYYY'))

Line 402: hr_utility.set_location ('Namish:p_owner_effective_date:'||p_owner_effective_date,10);

398: begin
399:
400: hr_utility.set_location ('In Overloaded ASG_STAT_YTD_EC',10);
401: hr_utility.set_location ('Namish:p_owner_assignment_action_id:'||p_owner_assignment_action_id,10);
402: hr_utility.set_location ('Namish:p_owner_effective_date:'||p_owner_effective_date,10);
403:
404: SELECT to_date('05-04-' ||to_char(fnd_number.canonical_to_number(
405: to_char( p_owner_effective_date,'YYYY'))
406: + decode(sign(p_owner_effective_date -

Line 412: hr_utility.set_location ('p_expiry_information'||p_expiry_information,10);

408: -1,0,1)),'DD-MM-YYYY') finyear_end
409: INTO p_expiry_information
410: FROM dual;
411:
412: hr_utility.set_location ('p_expiry_information'||p_expiry_information,10);
413:
414: end ASG_STAT_YTD_EC;
415:
416: /*------------------------------ ASG_USER_EC ----------------------------*/

Line 506: hr_utility.set_location ('In Overloaded ASG_USER_EC',10);

502: l_start_reset NUMBER;
503:
504: begin
505:
506: hr_utility.set_location ('In Overloaded ASG_USER_EC',10);
507: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
508: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);
509:
510: -- find the regular payment date for the owning action

Line 507: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);

503:
504: begin
505:
506: hr_utility.set_location ('In Overloaded ASG_USER_EC',10);
507: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
508: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);
509:
510: -- find the regular payment date for the owning action
511: select regular_payment_date

Line 508: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);

504: begin
505:
506: hr_utility.set_location ('In Overloaded ASG_USER_EC',10);
507: hr_utility.set_location ('p_owner_payroll_action_id:'||p_owner_payroll_action_id,10);
508: hr_utility.set_location ('p_owner_effective_date:'||p_owner_effective_date,10);
509:
510: -- find the regular payment date for the owning action
511: select regular_payment_date
512: into l_owning_regular_payment_date

Line 532: hr_utility.set_location ('p_expiry_information:'||p_expiry_information,10);

528: ,l_frequency
529: ,l_start_dd_mon);
530: END IF;
531:
532: hr_utility.set_location ('p_expiry_information:'||p_expiry_information,10);
533:
534:
535: end ASG_USER_EC;
536:

Line 655: hr_utility.set_location ('IN ASG_PROC_TWO_YTD_EC',10);

651: l_adjust number;
652:
653: begin
654:
655: hr_utility.set_location ('IN ASG_PROC_TWO_YTD_EC',10);
656: hr_utility.set_location ('p_dimension_name'||p_dimension_name,10);
657: hr_utility.set_location ('p_owner_payroll_action_id'||p_owner_payroll_action_id,10);
658:
659: Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(

Line 656: hr_utility.set_location ('p_dimension_name'||p_dimension_name,10);

652:
653: begin
654:
655: hr_utility.set_location ('IN ASG_PROC_TWO_YTD_EC',10);
656: hr_utility.set_location ('p_dimension_name'||p_dimension_name,10);
657: hr_utility.set_location ('p_owner_payroll_action_id'||p_owner_payroll_action_id,10);
658:
659: Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
660: to_char( PTP.regular_payment_date,'YYYY'))

Line 657: hr_utility.set_location ('p_owner_payroll_action_id'||p_owner_payroll_action_id,10);

653: begin
654:
655: hr_utility.set_location ('IN ASG_PROC_TWO_YTD_EC',10);
656: hr_utility.set_location ('p_dimension_name'||p_dimension_name,10);
657: hr_utility.set_location ('p_owner_payroll_action_id'||p_owner_payroll_action_id,10);
658:
659: Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
660: to_char( PTP.regular_payment_date,'YYYY'))
661: + decode(sign( PTP.regular_payment_date - to_date('06-04-'

Line 699: hr_utility.set_location ('p_expiry_information:'||p_expiry_information,10);

695: p_expiry_information := to_date('06-04-' || to_char(fnd_number.canonical_to_number(
696: to_char(l_tax_year_start,'yyyy')) + l_adjust)
697: ,'DD-MM-YYYY') - 1;
698:
699: hr_utility.set_location ('p_expiry_information:'||p_expiry_information,10);
700:
701: end ASG_PROC_TWO_YTD_EC;
702:
703: