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.

[Home] [Help]

APPS.PAY_SOE_GLB dependencies on HR_UTILITY

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: package body PAY_SOE_GLB as
2: /* $Header: pysoeglb.pkb 120.8.12010000.1 2008/07/27 23:42:38 appldev ship $ */
3: --
4: l_sql long;
5: g_debug boolean := hr_utility.debug_enabled;
6: g_max_action number;
7: g_min_action number;
8:
9: --

Line 72: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);

68: --
69: begin
70: --
71: if g_debug then
72: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);
73: end if;
74: --
75: -- Prepay change
76: select action_type

Line 128: hr_utility.trace('p_payroll_id = ' || p.payroll_id);

124: 'PREPAY_MIN_ACTION:' ||l_min_action ||':'||
125: 'CURRENCY_NAME:' ||p.currency_name ||':'||
126: 'ASSIGNMENT_ACTION_ID:'||p_assignment_action_id||':';
127: if g_debug then
128: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
129: hr_utility.trace('jsqldate = ' || p.jsqldate);
130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);

Line 129: hr_utility.trace('jsqldate = ' || p.jsqldate);

125: 'CURRENCY_NAME:' ||p.currency_name ||':'||
126: 'ASSIGNMENT_ACTION_ID:'||p_assignment_action_id||':';
127: if g_debug then
128: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
129: hr_utility.trace('jsqldate = ' || p.jsqldate);
130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);

Line 130: hr_utility.trace('effective_date = ' || p.effective_date);

126: 'ASSIGNMENT_ACTION_ID:'||p_assignment_action_id||':';
127: if g_debug then
128: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
129: hr_utility.trace('jsqldate = ' || p.jsqldate);
130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
134: hr_utility.trace('g_currency_code = ' || g_currency_code);

Line 131: hr_utility.trace('assignment_id = ' || p.assignment_id);

127: if g_debug then
128: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
129: hr_utility.trace('jsqldate = ' || p.jsqldate);
130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
134: hr_utility.trace('g_currency_code = ' || g_currency_code);
135: hr_utility.trace('action_clause = ' || l_actions);

Line 132: hr_utility.trace('business_group_id = ' || p.business_group_id);

128: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
129: hr_utility.trace('jsqldate = ' || p.jsqldate);
130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
134: hr_utility.trace('g_currency_code = ' || g_currency_code);
135: hr_utility.trace('action_clause = ' || l_actions);
136: end if;

Line 133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);

129: hr_utility.trace('jsqldate = ' || p.jsqldate);
130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
134: hr_utility.trace('g_currency_code = ' || g_currency_code);
135: hr_utility.trace('action_clause = ' || l_actions);
136: end if;
137: g_currency_code := p.currency_code;

Line 134: hr_utility.trace('g_currency_code = ' || g_currency_code);

130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
134: hr_utility.trace('g_currency_code = ' || g_currency_code);
135: hr_utility.trace('action_clause = ' || l_actions);
136: end if;
137: g_currency_code := p.currency_code;
138: l_action_type := p.action_type;

Line 135: hr_utility.trace('action_clause = ' || l_actions);

131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
134: hr_utility.trace('g_currency_code = ' || g_currency_code);
135: hr_utility.trace('action_clause = ' || l_actions);
136: end if;
137: g_currency_code := p.currency_code;
138: l_action_type := p.action_type;
139: end loop;

Line 150: hr_utility.trace('l_parameters = ' || l_parameters);

146: ' in ('||l_actions ||')' ||':';
147: end if;
148: --
149: if g_debug then
150: hr_utility.trace('l_parameters = ' || l_parameters);
151: hr_utility.set_location('Leaving pay_soe_glb.setParameters', 20);
152: end if;
153: --
154: return l_parameters;

Line 151: hr_utility.set_location('Leaving pay_soe_glb.setParameters', 20);

147: end if;
148: --
149: if g_debug then
150: hr_utility.trace('l_parameters = ' || l_parameters);
151: hr_utility.set_location('Leaving pay_soe_glb.setParameters', 20);
152: end if;
153: --
154: return l_parameters;
155: end;

Line 188: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);

184: l_assignment_id number;
185: begin
186: --
187: if g_debug then
188: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);
189: end if;
190: --
191: l_assignment_id := p_assignment_id;
192: if l_assignment_id is null then

Line 218: hr_utility.set_location('Entering pay_soe_glb.Employee', 10);

214: --
215: begin
216: --
217: if g_debug then
218: hr_utility.set_location('Entering pay_soe_glb.Employee', 10);
219: end if;
220: --
221: l_sql :=
222: 'Select org.name COL01

Line 285: hr_utility.set_location('Leaving pay_soe_glb.Employee', 20);

281: and hl.lookup_code (+) =peo.nationality';
282: --
283: --
284: if g_debug then
285: hr_utility.set_location('Leaving pay_soe_glb.Employee', 20);
286: end if;
287: --
288: return l_sql;
289: --

Line 311: hr_utility.set_location('Entering pay_soe_glb.Period', 10);

307:
308: begin
309: --
310: if g_debug then
311: hr_utility.set_location('Entering pay_soe_glb.Period', 10);
312: end if;
313: --
314:
315: open periodDates;

Line 399: hr_utility.set_location('Leaving pay_soe_glb.Period', 20);

395: end if;
396: --
397: --
398: if g_debug then
399: hr_utility.set_location('Leaving pay_soe_glb.Period', 20);
400: end if;
401: --
402: return l_sql;
403: end Period;

Line 416: hr_utility.set_location('Entering pay_soe_glb.getElements', 10);

412: begin
413: --
414: --
415: if g_debug then
416: hr_utility.set_location('Entering pay_soe_glb.getElements', 10);
417: end if;
418: --
419: -- Bugfix 5724212
420: -- Return null if p_element_set_name is NULL (since the SQL statement below

Line 476: hr_utility.set_location('Leaving pay_soe_glb.getElements', 20);

472: end if;
473: --
474: --
475: if g_debug then
476: hr_utility.set_location('Leaving pay_soe_glb.getElements', 20);
477: end if;
478: --
479: return l_sql;
480: --

Line 622: hr_utility.set_location('Entering pay_soe_glb.getBalances', 10);

618: --
619: begin
620: --
621: if g_debug then
622: hr_utility.set_location('Entering pay_soe_glb.getBalances', 10);
623: end if;
624: --
625: open getAction;
626: fetch getAction into l_payroll_id,

Line 640: hr_utility.set_location('pay_soe_glb.getBalances', 20);

636: --
637: i := 0;
638: --
639: if g_debug then
640: hr_utility.set_location('pay_soe_glb.getBalances', 20);
641: end if;
642: --
643: for db in getDBal loop
644: i := i + 1;

Line 673: hr_utility.set_location('pay_soe_glb.getBalances', 30);

669: --
670: i := 0;
671: if l_save_asg_run_bal = 'Y' then
672: if g_debug then
673: hr_utility.set_location('pay_soe_glb.getBalances', 30);
674: end if;
675: for ctx in getRBContexts loop
676: i := i + 1;
677: l_context_lst(i).TAX_UNIT_ID := ctx.TAX_UNIT_ID;

Line 686: hr_utility.set_location('pay_soe_glb.getBalances', 40);

682: l_context_lst(i).SOURCE_TEXT2 := ctx.SOURCE_TEXT2;
683: end loop;
684: else
685: if g_debug then
686: hr_utility.set_location('pay_soe_glb.getBalances', 40);
687: end if;
688: -- Check whether the SOURCE_ID, SOURCE_TEXT contexts are used.
689: l_si_needed_chr := 'N';
690: l_st_needed_chr := 'N';

Line 740: hr_utility.set_location('pay_soe_glb.getBalances', 50);

736: end if;
737: --
738: --
739: if g_debug then
740: hr_utility.set_location('pay_soe_glb.getBalances', 50);
741: end if;
742: --
743: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id
744: ,p_defined_balance_lst => l_defined_balance_lst

Line 754: hr_utility.set_location('pay_soe_glb.getBalances', 60);

750: balCount := 0;
751: if l_output_table.count > 0 then
752: --
753: if g_debug then
754: hr_utility.set_location('pay_soe_glb.getBalances', 60);
755: end if;
756: --
757: for i in l_output_table.first..l_output_table.last loop
758: if l_output_table(i).balance_value <> 0 then

Line 814: hr_utility.trace('in getInformation' || p_element_set_name || p_assignment_action_id);

810: function getInformation(p_assignment_action_id number
811: ,p_element_set_name varchar2) return long is
812: begin
813: --
814: hr_utility.trace('in getInformation' || p_element_set_name || p_assignment_action_id);
815: --
816: -- Bugfix 5724212
817: -- Return null if p_element_set_name is NULL (since the SQL statement below
818: -- will not fetch any rows anyway).

Line 943: hr_utility.trace('Entering elements1');

939: Text
940: ------------------------------------------------------------------------ */
941: function Elements1(p_assignment_action_id number) return long is
942: begin
943: hr_utility.trace('Entering elements1');
944: return getElements(p_assignment_action_id
945: ,pay_soe_util.getConfig('ELEMENTS1'));
946: hr_utility.trace('Leaving Elements1');
947: end Elements1;

Line 946: hr_utility.trace('Leaving Elements1');

942: begin
943: hr_utility.trace('Entering elements1');
944: return getElements(p_assignment_action_id
945: ,pay_soe_util.getConfig('ELEMENTS1'));
946: hr_utility.trace('Leaving Elements1');
947: end Elements1;
948: --
949: /* ---------------------------------------------------------------------
950: Function : SetParameters

Line 1017: hr_utility.trace('in Information1');

1013: Text
1014: ------------------------------------------------------------------------ */
1015: function Information1(p_assignment_action_id number) return long is
1016: begin
1017: hr_utility.trace('in Information1');
1018: return getInformation(p_assignment_action_id
1019: ,pay_soe_util.getConfig('INFORMATION1'));
1020: end Information1;
1021: --

Line 1171: hr_utility.set_location('Entering: '||l_period_obtained_flag,1);

1167:
1168:
1169: begin
1170: l_period_obtained_flag:=1;
1171: hr_utility.set_location('Entering: '||l_period_obtained_flag,1);
1172:
1173: OPEN c_get_creator_type(p_element_entry_id,p_date_earned);
1174: FETCH c_get_creator_type INTO l_creator_type ;
1175: CLOSE c_get_creator_type;

Line 1214: hr_utility.set_location('Entering element entry id: '||p_element_entry_id,4);

1210: CLOSE get_retro_period_ee;
1211: l_period_obtained_flag:=1;
1212: end if;
1213:
1214: hr_utility.set_location('Entering element entry id: '||p_element_entry_id,4);
1215: hr_utility.set_location('Entering start date earned : '||p_date_earned,5);
1216: hr_utility.set_location('Entering period obtained flag: '||l_period_obtained_flag,6);
1217:
1218: if p_call_type = 1 then

Line 1215: hr_utility.set_location('Entering start date earned : '||p_date_earned,5);

1211: l_period_obtained_flag:=1;
1212: end if;
1213:
1214: hr_utility.set_location('Entering element entry id: '||p_element_entry_id,4);
1215: hr_utility.set_location('Entering start date earned : '||p_date_earned,5);
1216: hr_utility.set_location('Entering period obtained flag: '||l_period_obtained_flag,6);
1217:
1218: if p_call_type = 1 then
1219: return l_retro_start_date;

Line 1216: hr_utility.set_location('Entering period obtained flag: '||l_period_obtained_flag,6);

1212: end if;
1213:
1214: hr_utility.set_location('Entering element entry id: '||p_element_entry_id,4);
1215: hr_utility.set_location('Entering start date earned : '||p_date_earned,5);
1216: hr_utility.set_location('Entering period obtained flag: '||l_period_obtained_flag,6);
1217:
1218: if p_call_type = 1 then
1219: return l_retro_start_date;
1220: elsif p_call_type = 2 then