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

Line 34: raise hr_utility.hr_error;

30: open csr_defined_balance;
31: fetch csr_defined_balance into l_defined_balance_id;
32: if csr_defined_balance%notfound then
33: close csr_defined_balance;
34: raise hr_utility.hr_error;
35: else
36: close csr_defined_balance;
37: end if;
38:

Line 85: hr_utility.trace('l_resides_true =' || l_resides_true);

81: EXCEPTION when no_data_found then
82: l_resides_true := '0';
83: END;
84:
85: hr_utility.trace('l_resides_true =' || l_resides_true);
86:
87: IF (l_resides_true = '1' AND
88: pay_balance_pkg.get_value(bal_db_item('GROSS_EARNINGS_PER_GRE_QTD'),
89: p_assignment_id, least(p_period_end, p_effective_end_date)) > 0) THEN

Line 91: hr_utility.trace('Returning TRUE from check_residence_state');

87: IF (l_resides_true = '1' AND
88: pay_balance_pkg.get_value(bal_db_item('GROSS_EARNINGS_PER_GRE_QTD'),
89: p_assignment_id, least(p_period_end, p_effective_end_date)) > 0) THEN
90:
91: hr_utility.trace('Returning TRUE from check_residence_state');
92:
93: RETURN TRUE;
94: ELSE
95: RETURN FALSE;

Line 124: hr_utility.trace('1099R_ind is Y');

120: bal_db_item('SIT_WITHHELD_PER_JD_GRE_QTD') ,
121: p_assignment_id,
122: least(p_period_end, p_effective_end_date)) > 0 );
123: l_resides_in_state := l_ret_value;
124: hr_utility.trace('1099R_ind is Y');
125: ELSE
126: l_ret_value := l_resides_in_state;
127: END IF;
128: END IF;

Line 282: -- hr_utility.trace_on('Y','ORACLE');

278:
279: --
280: --
281: begin
282: -- hr_utility.trace_on('Y','ORACLE');
283: hr_utility.set_location('pay_negbal_pkg.procngb',1);
284: select pay_negbal_pkg.get_parameter('TRANSFER_STATE',
285: ppa.legislative_parameters) state_abbrev,
286: ppa.start_date,

Line 283: hr_utility.set_location('pay_negbal_pkg.procngb',1);

279: --
280: --
281: begin
282: -- hr_utility.trace_on('Y','ORACLE');
283: hr_utility.set_location('pay_negbal_pkg.procngb',1);
284: select pay_negbal_pkg.get_parameter('TRANSFER_STATE',
285: ppa.legislative_parameters) state_abbrev,
286: ppa.start_date,
287: ppa.effective_date,

Line 320: hr_utility.set_location('pay_negbal_pkg.procngb',2);

316: prevperid := -1;
317: prevgreid := -1;
318: l_value := 0;
319: loop
320: hr_utility.set_location('pay_negbal_pkg.procngb',2);
321: fetch c_actions into lockedactid,assignid,personid,
322: greid,effdt,jd_code;
323: if c_actions%found then num := num + 1; end if;
324: exit when c_actions%notfound;

Line 335: hr_utility.set_location('pay_negbal_pkg.procngb',22);

331: end if;
332: close c_transmitter;
333: exception
334: when others then
335: hr_utility.set_location('pay_negbal_pkg.procngb',22);
336: raise;
337: end;
338: -- we need to insert one action for each of the
339: -- assignments that we return from the cursor.

Line 343: hr_utility.set_location('pay_negbal_pkg.procngb',3);

339: -- assignments that we return from the cursor.
340: if personid = prevperid and greid = prevgreid then
341: null;
342: else
343: hr_utility.set_location('pay_negbal_pkg.procngb',3);
344: -- set up contexts required to test the balance.
345: pay_balance_pkg.set_context('TAX_UNIT_ID',greid);
346: pay_balance_pkg.set_context('JURISDICTION_CODE',jd_code);
347:

Line 367: hr_utility.set_location('pay_negbal_pkg.procngb',4);

363: and ptax.effective_end_date >= l_qtr_start
364: and pst.state_code = ptax.state_code
365: and pst.state_abbrev = l_state
366: and ptax.sui_exempt = 'N') ;
367: hr_utility.set_location('pay_negbal_pkg.procngb',4);
368: if l_sui_exempt = 0 then
369: hr_utility.set_location('pay_negbal_pkg.procngb',5);
370: if nvl(transmitter_code,'N') <> 'Y' then
371: hr_utility.set_location('pay_negbal_pkg.procngb',6);

Line 369: hr_utility.set_location('pay_negbal_pkg.procngb',5);

365: and pst.state_abbrev = l_state
366: and ptax.sui_exempt = 'N') ;
367: hr_utility.set_location('pay_negbal_pkg.procngb',4);
368: if l_sui_exempt = 0 then
369: hr_utility.set_location('pay_negbal_pkg.procngb',5);
370: if nvl(transmitter_code,'N') <> 'Y' then
371: hr_utility.set_location('pay_negbal_pkg.procngb',6);
372: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id,
373: p_assignment_action_id => lockedactid);

Line 371: hr_utility.set_location('pay_negbal_pkg.procngb',6);

367: hr_utility.set_location('pay_negbal_pkg.procngb',4);
368: if l_sui_exempt = 0 then
369: hr_utility.set_location('pay_negbal_pkg.procngb',5);
370: if nvl(transmitter_code,'N') <> 'Y' then
371: hr_utility.set_location('pay_negbal_pkg.procngb',6);
372: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id,
373: p_assignment_action_id => lockedactid);
374: else
375: l_value := 0;

Line 383: hr_utility.set_location('pay_negbal_pkg.procngb',7);

379: if ((l_value > 0 ) OR
380: report_person_on_tape(assignid,l_period_start,l_period_end,
381: l_state, effdt,transmitter_code)) then
382:
383: hr_utility.set_location('pay_negbal_pkg.procngb',7);
384: select pay_assignment_actions_s.nextval
385: into lockingactid
386: from dual;
387: -- insert the action record.

Line 388: hr_utility.set_location('pay_negbal_pkg.procngb',8);

384: select pay_assignment_actions_s.nextval
385: into lockingactid
386: from dual;
387: -- insert the action record.
388: hr_utility.set_location('pay_negbal_pkg.procngb',8);
389: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
390: hr_utility.set_location('pay_negbal_pkg.procngb',9);
391: -- insert an interlock to this action
392: -- Bug fix 1850043

Line 390: hr_utility.set_location('pay_negbal_pkg.procngb',9);

386: from dual;
387: -- insert the action record.
388: hr_utility.set_location('pay_negbal_pkg.procngb',8);
389: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
390: hr_utility.set_location('pay_negbal_pkg.procngb',9);
391: -- insert an interlock to this action
392: -- Bug fix 1850043
393: -- hr_nonrun_asact.insint(lockingactid,lockedactid);
394: hr_utility.set_location('pay_negbal_pkg.procngb',10);

Line 394: hr_utility.set_location('pay_negbal_pkg.procngb',10);

390: hr_utility.set_location('pay_negbal_pkg.procngb',9);
391: -- insert an interlock to this action
392: -- Bug fix 1850043
393: -- hr_nonrun_asact.insint(lockingactid,lockedactid);
394: hr_utility.set_location('pay_negbal_pkg.procngb',10);
395: end if;
396: end if;
397: prevperid := personid;
398: prevgreid := greid;

Line 401: hr_utility.set_location('pay_negbal_pkg.procngb',11);

397: prevperid := personid;
398: prevgreid := greid;
399: --
400: end loop;
401: hr_utility.set_location('pay_negbal_pkg.procngb',11);
402: close c_actions;
403: end action_creation;
404: ---------------------------------- sort_action ----------------------------------
405: procedure sort_action

Line 413: hr_utility.set_location('pay_negbal_pkg.sort_action',1);

409: len out number /* length of the sql string */
410: ) is
411: begin
412:
413: hr_utility.set_location('pay_negbal_pkg.sort_action',1);
414: sqlstr := 'select paa.rowid
415: from pay_payroll_actions ppa,
416: pay_assignment_actions paa,
417: per_all_assignments_f paf, -- #1894165

Line 447: hr_utility.set_location('pay_negbal_pkg.sort_action',2);

443: order by hou.name,hou1.name,paf.assignment_number
444: for update of paf.assignment_id';
445:
446: len := length(sqlstr); -- return the length of the string.
447: hr_utility.set_location('pay_negbal_pkg.sort_action',2);
448: end sort_action;
449: --
450: ------------------------------ get_parameter -------------------------------
451: function get_parameter(name in varchar2,