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

Line 186: hr_utility.set_location(' Leaving: range code',110);

182: sqlstr := 'select 1 '||
183: '/* ERROR - Employer Details Fetch failed with: '||
184: sqlerrm(sqlcode)||' */ '||
185: 'from dual where to_char(:payroll_action_id) = dummy';
186: hr_utility.set_location(' Leaving: range code',110);
187: END archive_range_code;
188: --------------------------------------------------------------------------------
189: -- get_defined_balance_id pay_nl_wage_report_pkg.get_defined_balance_id
190: --------------------------------------------------------------------------------

Line 2410: hr_utility.set_location('Entering get_lca_details',1);

2406: l_lca_payments_bal_id pay_defined_balances.defined_balance_id%TYPE;
2407: l_action_info_id pay_action_information.action_information_id%TYPE;
2408: l_ovn pay_action_information.object_version_number%type;
2409: BEGIN
2410: hr_utility.set_location('Entering get_lca_details',1);
2411: OPEN csr_get_org_lca_data(p_tax_unit_id, p_date);
2412: FETCH csr_get_org_lca_data INTO r_get_org_lca_data;
2413: IF csr_get_org_lca_data%NOTFOUND THEN
2414: CLOSE csr_get_org_lca_data;

Line 2462: hr_utility.set_location('Method 1 Normal calculation',100);

2458: ,p_payroll_id => NULL);
2459:
2460: --------------------------------------------------------------------------------
2461: IF r_get_org_lca_data.method=1 THEN
2462: hr_utility.set_location('Method 1 Normal calculation',100);
2463: l_lca_threshold := ROUND(GREATEST(p_taxable_income,0) * l_lca_threshold_rate/100);
2464: l_lca_taxable := ROUND(GREATEST(l_lca_payments - l_lca_threshold,0));
2465: l_lca_tax := ROUND(l_lca_taxable * l_lca_tax_rate/100);
2466:

Line 2473: hr_utility.set_location('Recalculation',400);

2469: /* Last period Recalculation */
2470: IF (p_payroll_type='WEEK' AND TRUNC(p_date+7,'YYYY')>TRUNC(p_date,'YYYY'))
2471: OR (p_payroll_type='LMONTH' AND TRUNC(p_date+27,'YYYY')>TRUNC(p_date,'YYYY'))
2472: OR (p_payroll_type='MONTH' AND TRUNC(p_date+31,'YYYY')>TRUNC(p_date,'YYYY')) THEN
2473: hr_utility.set_location('Recalculation',400);
2474: l_recalculation := 'Y';
2475: l_taxable_income_ytd := p_taxable_income;
2476: /* Fetch YTD Values from previous Locked Wage Report Archives*/
2477: OPEN csr_get_ytd_values(c_bg_id => l_bg_id

Line 2517: hr_utility.set_location('Method 2 Normal calculation',200);

2513: ELSE
2514: /* Other Periods */
2515: IF r_get_org_lca_data.method =2 THEN
2516: /* Method 2*/
2517: hr_utility.set_location('Method 2 Normal calculation',200);
2518: OPEN csr_get_no_pay_period(p_payroll_type);
2519: FETCH csr_get_no_pay_period INTO l_number_of_periods;
2520: CLOSE csr_get_no_pay_period;
2521:

Line 2531: hr_utility.set_location('Method 3 Normal calculation',300);

2527: --------------------------------------------------------------------------------
2528: ELSIF r_get_org_lca_data.method =3 THEN
2529: /* Method 3*/
2530: /* Fetch LCA Payments YTD Value */
2531: hr_utility.set_location('Method 3 Normal calculation',300);
2532: l_lca_payments_bal_id := get_defined_balance_id(l_balance_name,l_balance_dim_ytd);
2533:
2534: l_lca_payments_ytd := pay_balance_pkg.get_value
2535: (p_defined_balance_id => l_lca_payments_bal_id

Line 2569: hr_utility.set_location('Archiving LCA details',800);

2565: --------------------------------------------------------------------------------
2566: END IF;
2567: END IF;
2568: END IF;
2569: hr_utility.set_location('Archiving LCA details',800);
2570: /* Archive the LCA variables for audit */
2571: pay_action_information_api.create_action_information
2572: (
2573: p_action_information_id => l_action_info_id

Line 2603: hr_utility.set_location('Leaving get_lca_details',900);

2599: , p_action_information28 => l_recalculation --Recalculation flag
2600: , p_action_information29 => fnd_number.number_to_canonical(NVL(l_seq_no,0)) --Sequence
2601: , p_action_information30 => fnd_date.date_to_canonical(l_start_date) --Start Date
2602: );
2603: hr_utility.set_location('Leaving get_lca_details',900);
2604: RETURN NVL(l_lca_tax,0);
2605: EXCEPTION
2606: WHEN OTHERS THEN
2607: hr_utility.set_location(sqlerrm(sqlcode),999);

Line 2607: hr_utility.set_location(sqlerrm(sqlcode),999);

2603: hr_utility.set_location('Leaving get_lca_details',900);
2604: RETURN NVL(l_lca_tax,0);
2605: EXCEPTION
2606: WHEN OTHERS THEN
2607: hr_utility.set_location(sqlerrm(sqlcode),999);
2608: END get_lca_details;
2609:
2610:
2611: BEGIN

Line 3322: hr_utility.set_location(y,2);

3318: p_collXMLTable(y).Tagvalue := p_collXMLTable(y).Tagvalue + NVL(l_co_col_BijdrZvw,0);
3319: p_emp_total := p_emp_total + ROUND(p_collXMLTable(y).Tagvalue);
3320: --
3321: y:= y+1;
3322: hr_utility.set_location(y,2);
3323: p_collXMLTable(y).TagName := 'TotWghZvw'; -- 92..93 ZVWS
3324: p_collXMLTable(y).Mandatory:= 'Y';
3325: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotWghZvw'));
3326: p_collXMLTable(y).Tagvalue:=0;

Line 3328: hr_utility.set_location(g_col_bal_def_table(i).balance_value || ' '||+ g_col_bal_def_table(i).balance_value2,100.01);

3324: p_collXMLTable(y).Mandatory:= 'Y';
3325: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotWghZvw'));
3326: p_collXMLTable(y).Tagvalue:=0;
3327: FOR i in 92..93 LOOP
3328: hr_utility.set_location(g_col_bal_def_table(i).balance_value || ' '||+ g_col_bal_def_table(i).balance_value2,100.01);
3329: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
3330: + g_col_bal_def_table(i).balance_value2;
3331: END LOOP;
3332: p_collXMLTable(y).Tagvalue := p_collXMLTable(y).Tagvalue + NVL(l_co_col_VergZvw,0);

Line 3949: hr_utility.set_location(sqlerrm(sqlcode),110);

3945: EXCEPTION
3946: WHEN OTHERS THEN
3947: -- Return cursor that selects no rows
3948: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
3949: hr_utility.set_location(sqlerrm(sqlcode),110);
3950: END arch_deinit_prev_corr_yr;
3951: --10100628
3952:
3953: --------------------------------------------------------------------------------

Line 4055: --hr_utility.trace_on(null,'NL_WR');

4051: l_prev_corr_bal NUMBER;
4052: --
4053: --
4054: BEGIN
4055: --hr_utility.trace_on(null,'NL_WR');
4056: --Fnd_file.put_line(FND_FILE.LOG,' Entering deinit code ');
4057: /*Delete all data archived for the current payroll_action_id - to handle assignment level retry*/
4058: DELETE pay_action_information
4059: WHERE action_context_id = p_actid

Line 4122: hr_utility.set_location(sqlerrm(sqlcode),110);

4118: EXCEPTION
4119: WHEN OTHERS THEN
4120: -- Return cursor that selects no rows
4121: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
4122: hr_utility.set_location(sqlerrm(sqlcode),110);
4123: END archive_deinit_code_yearly;
4124: --------------------------------------------------------------------------------
4125: -- DEINITIALIZE_CODE pay_nl_wage_report_pkg.archive_deinit_code
4126: --------------------------------------------------------------------------------

Line 4716: -- hr_utility.trace_on(null,'NL_WR');

4712: l_co_col_PrLnPrSectFnds NUMBER :=0;
4713: --10100628
4714:
4715: BEGIN
4716: -- hr_utility.trace_on(null,'NL_WR');
4717: --Fnd_file.put_line(FND_FILE.LOG,' Entering deinit code ');
4718: /*Delete all data archived for the current payroll_action_id - to handle assignment level retry*/
4719: DELETE pay_action_information
4720: WHERE action_context_id = p_actid

Line 7165: hr_utility.set_location(sqlerrm(sqlcode),110);

7161: EXCEPTION
7162: WHEN OTHERS THEN
7163: -- Return cursor that selects no rows
7164: -- Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
7165: hr_utility.set_location(sqlerrm(sqlcode),110);
7166: END archive_deinit_code;
7167: --------------------------------------------------------------------------------
7168: -- ACTION_CREATION_CODE
7169: --------------------------------------------------------------------------------

Line 7638: --hr_utility.trace_on(null,'NL_WR');

7634: l_arc_pactid NUMBER;
7635: --
7636: BEGIN
7637: --
7638: --hr_utility.trace_on(null,'NL_WR');
7639: --
7640: l_arc_pactid := TO_NUMBER(get_parameters(p_actid,'REQUEST_ID'));
7641: --
7642: FOR csr_rec IN csr_assignment_actions(l_arc_pactid) LOOP

Line 14774: --hr_utility.trace_on(null,'NL_WR');

14770: l_er_only VARCHAR2(10);
14771:
14772: BEGIN
14773: -- get Employee data
14774: --hr_utility.trace_on(null,'NL_WR');
14775: --
14776: --Fnd_file.put_line(FND_FILE.LOG,' Entering Archive Code for Assignment :'||p_assactid);
14777: select payroll_action_id,assignment_id
14778: into l_pactid, l_assignment_id