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

Line 152: hr_utility.trace('Entering:' || 'pay_hk_soe.total_balances');

148:
149: begin
150:
151: IF g_debug THEN
152: hr_utility.trace('Entering:' || 'pay_hk_soe.total_balances');
153: END IF;
154:
155:
156: /*------------- for payment values -----------------*/

Line 191: hr_utility.trace('_PAYMENTS balances');

187: v_direct_pay_this_run := p_result_table(6).balance_value;
188: v_total_pay_this_run := p_result_table(7).balance_value;
189:
190: if g_debug THEN
191: hr_utility.trace('_PAYMENTS balances');
192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);

Line 192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);

188: v_total_pay_this_run := p_result_table(7).balance_value;
189:
190: if g_debug THEN
191: hr_utility.trace('_PAYMENTS balances');
192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);

Line 193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);

189:
190: if g_debug THEN
191: hr_utility.trace('_PAYMENTS balances');
192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
197:

Line 194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);

190: if g_debug THEN
191: hr_utility.trace('_PAYMENTS balances');
192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
197:
198: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);

Line 195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);

191: hr_utility.trace('_PAYMENTS balances');
192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
197:
198: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
199: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);

Line 196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);

192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
197:
198: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
199: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
200: end if;

Line 198: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);

194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
197:
198: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
199: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
200: end if;
201:
202:

Line 199: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);

195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
197:
198: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
199: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
200: end if;
201:
202:
203: /*----------------------------------- for YTD values --------------------*/

Line 233: hr_utility.trace('_ASG_LE_YTD balances');

229: v_direct_pay_ytd := p_result_table(6).balance_value;
230: v_total_pay_ytd := p_result_table(7).balance_value;
231:
232: if g_debug THEN
233: hr_utility.trace('_ASG_LE_YTD balances');
234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);

Line 234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);

230: v_total_pay_ytd := p_result_table(7).balance_value;
231:
232: if g_debug THEN
233: hr_utility.trace('_ASG_LE_YTD balances');
234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);

Line 235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);

231:
232: if g_debug THEN
233: hr_utility.trace('_ASG_LE_YTD balances');
234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);

Line 236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);

232: if g_debug THEN
233: hr_utility.trace('_ASG_LE_YTD balances');
234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
240: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);

Line 237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);

233: hr_utility.trace('_ASG_LE_YTD balances');
234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
240: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
241: end if;

Line 238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);

234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
240: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
241: end if;
242:

Line 239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);

235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
240: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
241: end if;
242:
243:

Line 240: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);

236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
240: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
241: end if;
242:
243:
244: -- Set the output balance amounts.

Line 264: hr_utility.trace('Leaving:' || 'pay_hk_soe.total_balances');

260: p_total_payment_ytd := v_total_pay_ytd;
261:
262:
263: if g_debug then
264: hr_utility.trace('Leaving:' || 'pay_hk_soe.total_balances');
265: end if;
266:
267: end balance_totals;
268:

Line 295: hr_utility.trace('Entering: ' || 'pay_hk_soe.getelements');

291: WHERE locking_action_id = p_assignment_action_id;
292:
293: BEGIN
294:
295: hr_utility.trace('Entering: ' || 'pay_hk_soe.getelements');
296:
297: OPEN csr_locked_action_id;
298: FETCH csr_locked_action_id INTO l_assignment_action_id;
299: CLOSE csr_locked_action_id;

Line 323: hr_utility.trace ('Leaving: ' || 'pay_hk_soe.getelements');

319: ORDER BY phaev.element_reporting_name';
320:
321: END IF;
322:
323: hr_utility.trace ('Leaving: ' || 'pay_hk_soe.getelements');
324: RETURN g_sql;
325: --
326: END getelements;
327:

Line 346: hr_utility.trace ('Entering: ' || 'pay_hk_soe.get_earnings');

342: IS
343:
344: BEGIN
345:
346: hr_utility.trace ('Entering: ' || 'pay_hk_soe.get_earnings');
347: RETURN getElements(p_assignment_action_id => p_assignment_action_id
348: ,p_classification_name => 'Earnings'
349: );
350:

Line 370: hr_utility.trace ('Entering: ' || 'pay_hk_soe.get_deductions');

366: IS
367:
368: BEGIN
369:
370: hr_utility.trace ('Entering: ' || 'pay_hk_soe.get_deductions');
371: RETURN getElements(p_assignment_action_id => p_assignment_action_id
372: ,p_classification_name => 'Deductions'
373: );
374:

Line 395: hr_utility.trace ('Entering: ' || 'pay_hk_soe.get_employer_liabilities');

391: IS
392:
393: BEGIN
394:
395: hr_utility.trace ('Entering: ' || 'pay_hk_soe.get_employer_liabilities');
396: RETURN getElements(p_assignment_action_id => p_assignment_action_id
397: ,p_classification_name => 'Employer Liabilities'
398: );
399:

Line 438: hr_utility.trace('Entering: '|| 'pay_hk_soe_pkg.get_balances');

434: AND paa.assignment_action_id = p_assignment_action_id;
435:
436: BEGIN
437:
438: hr_utility.trace('Entering: '|| 'pay_hk_soe_pkg.get_balances');
439:
440: OPEN csr_locked_action_id;
441: FETCH csr_locked_action_id INTO l_assignment_action_id;
442: CLOSE csr_locked_action_id;

Line 507: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_balances');

503: , ''NET'',5
504: , ''DIRECT_PAYMENTS'',6
505: , ''TOTAL_PAYMENTS'',7)';
506:
507: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_balances');
508:
509: RETURN g_sql;
510:
511: END get_balances;

Line 529: hr_utility.trace('Entering: '|| 'pay_hk_soe_pkg.get_payment_methods');

525: RETURN LONG
526: IS
527: BEGIN
528:
529: hr_utility.trace('Entering: '|| 'pay_hk_soe_pkg.get_payment_methods');
530:
531: g_sql := 'SELECT /*+
532: INDEX(opm PAY_ORG_PAYMENT_METHODS_F_PK) */
533: org_payment_method_name COL01

Line 562: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_payment_methods');

558: AND opm.effective_end_date
559: AND opm.payment_type_id = pt.payment_type_id
560: AND pt.language = USERENV(''LANG'')';
561:
562: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_payment_methods');
563:
564: RETURN g_sql;
565:
566: END get_payment_methods;

Line 604: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_other_element_information');

600: AND paa.assignment_action_id = p_assignment_action_id;
601:
602: BEGIN
603:
604: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_other_element_information');
605:
606: OPEN csr_prepayment;
607: FETCH csr_prepayment INTO l_assignment_action_id;
608: CLOSE csr_prepayment;

Line 659: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_other_element_information');

655: AND prr.element_type_id = org.org_information2
656: AND prv.input_value_id = org.org_information3
657: AND prv.result_value IS NOT NULL';
658:
659: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_other_element_information');
660:
661: RETURN g_sql;
662:
663: END get_other_element_information;

Line 703: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_other_balance_information');

699:
700: BEGIN
701:
702:
703: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_other_balance_information');
704:
705: OPEN csr_locked_action_id;
706: FETCH csr_locked_action_id INTO l_assignment_action_id;
707: CLOSE csr_locked_action_id;

Line 747: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_other_balance_information');

743: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')
744: , NULL
745: , NULL) <> 0';
746:
747: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_other_balance_information');
748:
749: RETURN g_sql;
750:
751: END get_other_balance_information;

Line 838: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_annual_leave_information');

834:
835: BEGIN
836:
837:
838: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_annual_leave_information');
839:
840: OPEN csr_prepayment;
841: FETCH csr_prepayment INTO l_assignment_action_id;
842: CLOSE csr_prepayment;

Line 888: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_annual_leave_information');

884: , TO_CHAR(' || l_annual_leave_balance|| ',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
885: , ''' || l_uom || ''' COL03
886: FROM DUAL';
887:
888: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_annual_leave_information');
889:
890: ELSE
891: CLOSE csr_get_annual_leave_details;
892: END IF;

Line 926: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_leave_taken');

922:
923: BEGIN
924:
925:
926: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_leave_taken');
927:
928: OPEN csr_prepayment;
929: FETCH csr_prepayment INTO l_assignment_action_id;
930: CLOSE csr_prepayment;

Line 975: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_leave_taken');

971: AND ppa.effective_date BETWEEN piv.effective_start_date
972: AND piv.effective_end_date';
973:
974:
975: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_leave_taken');
976:
977: RETURN g_sql;
978:
979: END get_leave_taken;

Line 984: g_debug := hr_utility.debug_enabled;

980:
981: begin
982: g_def_bal_id_populated_payment := FALSE; /* Bug 4210525 */
983: g_def_bal_id_populated_ytd := FALSE; /* Bug 4210525 */
984: g_debug := hr_utility.debug_enabled;
985:
986: end pay_hk_soe_pkg;