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

Line 119: -- Wrapper for hr_utility.trace_on --

115: -------------------------------------------------------------------------------
116:
117: -------------------------------------------------------------------------------
118: -- StartHrTrace --
119: -- Wrapper for hr_utility.trace_on --
120: -------------------------------------------------------------------------------
121: PROCEDURE StartHrTrace AS
122: BEGIN
123: IF g_HrTraceEnabled THEN

Line 124: hr_utility.trace_on(null,g_HrTracePipeName);

120: -------------------------------------------------------------------------------
121: PROCEDURE StartHrTrace AS
122: BEGIN
123: IF g_HrTraceEnabled THEN
124: hr_utility.trace_on(null,g_HrTracePipeName);
125: END IF;
126: END StartHrTrace;
127: -------------------------------------------------------------------------------
128: -- WriteHrTrace --

Line 129: -- Wrapper for hr_utility.trace --

125: END IF;
126: END StartHrTrace;
127: -------------------------------------------------------------------------------
128: -- WriteHrTrace --
129: -- Wrapper for hr_utility.trace --
130: -------------------------------------------------------------------------------
131: PROCEDURE WriteHrTrace(
132: p_Buffer VARCHAR2
133: )

Line 138: hr_utility.trace(p_Buffer);

134: AS
135: BEGIN
136: IF g_HrTraceEnabled THEN
137: -- Write the Line
138: hr_utility.trace(p_Buffer);
139: END IF;
140: END WriteHrTrace;
141: -------------------------------------------------------------------------------
142: -- StopHrTrace --

Line 143: -- Wrapper for hr_utility.trace_off --

139: END IF;
140: END WriteHrTrace;
141: -------------------------------------------------------------------------------
142: -- StopHrTrace --
143: -- Wrapper for hr_utility.trace_off --
144: -------------------------------------------------------------------------------
145: PROCEDURE StopHrTrace AS
146: BEGIN
147: IF g_HrTraceEnabled THEN

Line 148: hr_utility.trace_off;

144: -------------------------------------------------------------------------------
145: PROCEDURE StopHrTrace AS
146: BEGIN
147: IF g_HrTraceEnabled THEN
148: hr_utility.trace_off;
149: END IF;
150: END StopHrTrace;
151: -------------------------------------------------------------------------------
152: -- LatePayPeriod --

Line 159: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',1);

155: -- Variables
156: l_CurTxYear NUMBER(15);
157: BEGIN
158: g_indent := g_indent||' ';
159: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',1);
160: -- IF the employee's assignment ended before the current tax year
161: -- it's a Late Pay Period
162: IF dbi_ZA_ACT_END_DTE < dbi_ZA_TX_YR_STRT THEN
163:

Line 164: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',2);

160: -- IF the employee's assignment ended before the current tax year
161: -- it's a Late Pay Period
162: IF dbi_ZA_ACT_END_DTE < dbi_ZA_TX_YR_STRT THEN
163:
164: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',2);
165:
166: -- Valid Late Pay Period?
167: --
168: -- Current Tax Year

Line 171: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',3);

167: --
168: -- Current Tax Year
169: l_CurTxYear := to_number(to_char(dbi_ZA_TX_YR_END,'YYYY'));
170:
171: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',3);
172:
173: IF (l_CurTxYear - dbi_ZA_ASG_TX_YR) > 1 THEN
174: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',4);
175: hr_utility.set_message(801, 'Late Payment Across Two Tax Years!');

Line 174: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',4);

170:
171: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',3);
172:
173: IF (l_CurTxYear - dbi_ZA_ASG_TX_YR) > 1 THEN
174: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',4);
175: hr_utility.set_message(801, 'Late Payment Across Two Tax Years!');
176: hr_utility.raise_error;
177: ELSE
178: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',5);

Line 175: hr_utility.set_message(801, 'Late Payment Across Two Tax Years!');

171: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',3);
172:
173: IF (l_CurTxYear - dbi_ZA_ASG_TX_YR) > 1 THEN
174: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',4);
175: hr_utility.set_message(801, 'Late Payment Across Two Tax Years!');
176: hr_utility.raise_error;
177: ELSE
178: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',5);
179: g_indent := substr(g_indent,1,length(g_indent)-3);

Line 176: hr_utility.raise_error;

172:
173: IF (l_CurTxYear - dbi_ZA_ASG_TX_YR) > 1 THEN
174: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',4);
175: hr_utility.set_message(801, 'Late Payment Across Two Tax Years!');
176: hr_utility.raise_error;
177: ELSE
178: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',5);
179: g_indent := substr(g_indent,1,length(g_indent)-3);
180: RETURN TRUE;

Line 178: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',5);

174: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',4);
175: hr_utility.set_message(801, 'Late Payment Across Two Tax Years!');
176: hr_utility.raise_error;
177: ELSE
178: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',5);
179: g_indent := substr(g_indent,1,length(g_indent)-3);
180: RETURN TRUE;
181: END IF;
182:

Line 184: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',6);

180: RETURN TRUE;
181: END IF;
182:
183: ELSE
184: hr_utility.set_location(g_indent||'py_za_total_package.LatePayPeriod',6);
185: g_indent := substr(g_indent,1,length(g_indent)-3);
186: RETURN FALSE;
187: END IF;
188: EXCEPTION

Line 204: hr_utility.set_location(g_indent||'py_za_total_package.LstPeriod',1);

200: g_indent := g_indent||' ';
201: -- Is this the last period for the tax year
202: --
203: IF dbi_ZA_PAY_PRDS_LFT = 1 THEN
204: hr_utility.set_location(g_indent||'py_za_total_package.LstPeriod',1);
205: g_indent := substr(g_indent,1,length(g_indent)-3);
206: RETURN TRUE;
207: ELSE
208: hr_utility.set_location(g_indent||'py_za_total_package.LstPeriod',2);

Line 208: hr_utility.set_location(g_indent||'py_za_total_package.LstPeriod',2);

204: hr_utility.set_location(g_indent||'py_za_total_package.LstPeriod',1);
205: g_indent := substr(g_indent,1,length(g_indent)-3);
206: RETURN TRUE;
207: ELSE
208: hr_utility.set_location(g_indent||'py_za_total_package.LstPeriod',2);
209: g_indent := substr(g_indent,1,length(g_indent)-3);
210: RETURN FALSE;
211: END IF;
212: EXCEPTION

Line 231: hr_utility.set_location(g_indent||'py_za_total_package.EmpTermInPeriod',1);

227: --
228: IF dbi_ZA_ACT_END_DTE BETWEEN dbi_ZA_CUR_PRD_STRT_DTE
229: AND dbi_ZA_CUR_PRD_END_DTE
230: THEN
231: hr_utility.set_location(g_indent||'py_za_total_package.EmpTermInPeriod',1);
232: g_indent := substr(g_indent,1,length(g_indent)-3);
233: RETURN TRUE;
234: ELSE
235: hr_utility.set_location(g_indent||'py_za_total_package.EmpTermInPeriod',2);

Line 235: hr_utility.set_location(g_indent||'py_za_total_package.EmpTermInPeriod',2);

231: hr_utility.set_location(g_indent||'py_za_total_package.EmpTermInPeriod',1);
232: g_indent := substr(g_indent,1,length(g_indent)-3);
233: RETURN TRUE;
234: ELSE
235: hr_utility.set_location(g_indent||'py_za_total_package.EmpTermInPeriod',2);
236: g_indent := substr(g_indent,1,length(g_indent)-3);
237: RETURN FALSE;
238: END IF;
239: EXCEPTION

Line 256: hr_utility.set_location(g_indent||'py_za_total_package.EmpTermPrePeriod',1);

252: g_indent := g_indent||' ';
253: -- Was the employee terminated before the current period
254: --
255: IF dbi_ZA_ACT_END_DTE <= dbi_ZA_CUR_PRD_STRT_DTE THEN
256: hr_utility.set_location(g_indent||'py_za_total_package.EmpTermPrePeriod',1);
257: g_indent := substr(g_indent,1,length(g_indent)-3);
258: RETURN TRUE;
259: ELSE
260: hr_utility.set_location(g_indent||'py_za_total_package.EmpTermPrePeriod',2);

Line 260: hr_utility.set_location(g_indent||'py_za_total_package.EmpTermPrePeriod',2);

256: hr_utility.set_location(g_indent||'py_za_total_package.EmpTermPrePeriod',1);
257: g_indent := substr(g_indent,1,length(g_indent)-3);
258: RETURN TRUE;
259: ELSE
260: hr_utility.set_location(g_indent||'py_za_total_package.EmpTermPrePeriod',2);
261: g_indent := substr(g_indent,1,length(g_indent)-3);
262: RETURN FALSE;
263: END IF;
264: EXCEPTION

Line 298: hr_utility.set_location(g_indent||'py_za_total_package.PreErnPeriod',1);

294: WriteHrTrace(g_indent||'trc_AnnPymPtd: '||to_char(trc_AnnPymPtd));
295:
296: -- Annual Type PTD Income with no Period Type PTD Income
297: IF (trc_AnnBonPtd + trc_AnnPymPtd) <> 0 AND trc_TxbIncPtd <= 0 THEN
298: hr_utility.set_location(g_indent||'py_za_total_package.PreErnPeriod',1);
299: g_indent := substr(g_indent,1,length(g_indent)-3);
300: RETURN TRUE;
301: ELSE
302: hr_utility.set_location(g_indent||'py_za_total_package.PreErnPeriod',2);

Line 302: hr_utility.set_location(g_indent||'py_za_total_package.PreErnPeriod',2);

298: hr_utility.set_location(g_indent||'py_za_total_package.PreErnPeriod',1);
299: g_indent := substr(g_indent,1,length(g_indent)-3);
300: RETURN TRUE;
301: ELSE
302: hr_utility.set_location(g_indent||'py_za_total_package.PreErnPeriod',2);
303: g_indent := substr(g_indent,1,length(g_indent)-3);
304: RETURN FALSE;
305: END IF;
306: EXCEPTION

Line 326: hr_utility.set_location(g_indent||'py_za_total_package.NegPtd',1);

322: -------------------------------------------------------------------
323: BEGIN -- NegPtd - MAIN --
324: -------------------------------------------------------------------
325: g_indent := g_indent||' ';
326: hr_utility.set_location(g_indent||'py_za_total_package.NegPtd',1);
327: -- If any period ptd income value is negative
328: -- a site calc has to be done
329:
330: IF LEAST( bal_TOT_TXB_NI_PTD

Line 336: hr_utility.set_location(g_indent||'py_za_total_package.NegPtd',2);

332: , bal_TOT_TXB_TA_PTD
333: , bal_BP_PTD
334: ) < 0
335: THEN
336: hr_utility.set_location(g_indent||'py_za_total_package.NegPtd',2);
337: trc_NegPtd := TRUE;
338: END IF;
339:
340: hr_utility.set_location(g_indent||'py_za_total_package.NegPtd',3);

Line 340: hr_utility.set_location(g_indent||'py_za_total_package.NegPtd',3);

336: hr_utility.set_location(g_indent||'py_za_total_package.NegPtd',2);
337: trc_NegPtd := TRUE;
338: END IF;
339:
340: hr_utility.set_location(g_indent||'py_za_total_package.NegPtd',3);
341: g_indent := substr(g_indent,1,length(g_indent)-3);
342: RETURN trc_NegPtd;
343: EXCEPTION
344: WHEN OTHERS THEN

Line 361: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',1);

357: l_tot_inc_ytd BALANCE;
358: l_tot_inc_ptd BALANCE;
359: BEGIN
360: g_indent := g_indent||' ';
361: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',1);
362:
363: l_tot_inc_ytd := bal_TOT_TXB_NI_YTD
364: + bal_TOT_TXB_FB_YTD
365: + bal_TOT_TXB_TA_YTD;

Line 370: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',2);

366: l_tot_inc_ptd := bal_TOT_TXB_NI_PTD
367: + bal_TOT_TXB_FB_PTD
368: + bal_TOT_TXB_TA_PTD;
369:
370: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',2);
371:
372: IF dbi_ZA_TX_YR_STRT < dbi_ZA_ACT_STRT_DTE THEN
373: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',3);
374:

Line 373: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',3);

369:
370: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',2);
371:
372: IF dbi_ZA_TX_YR_STRT < dbi_ZA_ACT_STRT_DTE THEN
373: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',3);
374:
375: IF l_tot_inc_ytd = l_tot_inc_ptd THEN
376: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',4);
377: -- i.e. first pay period for the person

Line 376: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',4);

372: IF dbi_ZA_TX_YR_STRT < dbi_ZA_ACT_STRT_DTE THEN
373: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',3);
374:
375: IF l_tot_inc_ytd = l_tot_inc_ptd THEN
376: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',4);
377: -- i.e. first pay period for the person
378: trc_PrdFactor :=
379: ( dbi_ZA_CUR_PRD_END_DTE
380: - dbi_ZA_ACT_STRT_DTE

Line 389: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',5);

385: - dbi_ZA_CUR_PRD_STRT_DTE
386: + 1
387: );
388: ELSE
389: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',5);
390: trc_PrdFactor := 1;
391: END IF;
392:
393: ELSE

Line 394: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',6);

390: trc_PrdFactor := 1;
391: END IF;
392:
393: ELSE
394: hr_utility.set_location(g_indent||'py_za_total_package.PeriodFactor',6);
395: trc_PrdFactor := 1;
396: END IF;
397:
398: WriteHrTrace(g_indent||'dbi_ZA_TX_YR_STRT: '

Line 425: hr_utility.set_location(g_indent||'py_za_total_package.PPF',1);

421: PROCEDURE PossiblePeriodsFactor AS
422: BEGIN
423: g_indent := g_indent||' ';
424: IF dbi_ZA_TX_YR_STRT >= dbi_ZA_ACT_STRT_DTE THEN
425: hr_utility.set_location(g_indent||'py_za_total_package.PPF',1);
426: trc_PosFactor := 1;
427: ELSE
428: IF trc_PrdFactor <> 1 THEN
429: hr_utility.set_location(g_indent||'py_za_total_package.PPF',2);

Line 429: hr_utility.set_location(g_indent||'py_za_total_package.PPF',2);

425: hr_utility.set_location(g_indent||'py_za_total_package.PPF',1);
426: trc_PosFactor := 1;
427: ELSE
428: IF trc_PrdFactor <> 1 THEN
429: hr_utility.set_location(g_indent||'py_za_total_package.PPF',2);
430: --
431: trc_PosFactor :=
432: dbi_ZA_DYS_IN_YR
433: / ( dbi_ZA_TX_YR_END

Line 438: hr_utility.set_location(g_indent||'py_za_total_package.PPF',3);

434: - dbi_ZA_CUR_PRD_STRT_DTE
435: + 1
436: );
437: ELSE
438: hr_utility.set_location(g_indent||'py_za_total_package.PPF',3);
439: --
440: trc_PosFactor :=
441: dbi_ZA_DYS_IN_YR
442: / ( dbi_ZA_TX_YR_END

Line 471: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',1);

467: l_AnnFig4 BALANCE;
468:
469: BEGIN
470: g_indent := g_indent||' ';
471: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',1);
472: -- 1
473: l_AnnFig1 := p_PtdInc / trc_PrdFactor;
474: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',2);
475: -- 2

Line 474: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',2);

470: g_indent := g_indent||' ';
471: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',1);
472: -- 1
473: l_AnnFig1 := p_PtdInc / trc_PrdFactor;
474: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',2);
475: -- 2
476: l_AnnFig2 := l_AnnFig1 * dbi_ZA_PAY_PRDS_LFT;
477: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',3);
478: -- 3

Line 477: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',3);

473: l_AnnFig1 := p_PtdInc / trc_PrdFactor;
474: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',2);
475: -- 2
476: l_AnnFig2 := l_AnnFig1 * dbi_ZA_PAY_PRDS_LFT;
477: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',3);
478: -- 3
479: l_AnnFig3 := l_AnnFig2 + p_YtdInc - p_PtdInc;
480: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',4);
481: -- 4

Line 480: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',4);

476: l_AnnFig2 := l_AnnFig1 * dbi_ZA_PAY_PRDS_LFT;
477: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',3);
478: -- 3
479: l_AnnFig3 := l_AnnFig2 + p_YtdInc - p_PtdInc;
480: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',4);
481: -- 4
482: l_AnnFig4 := l_AnnFig3 * trc_PosFactor;
483: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',5);
484: --

Line 483: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',5);

479: l_AnnFig3 := l_AnnFig2 + p_YtdInc - p_PtdInc;
480: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',4);
481: -- 4
482: l_AnnFig4 := l_AnnFig3 * trc_PosFactor;
483: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',5);
484: --
485: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',6);
486: --
487: WriteHrTrace(g_indent||'p_PtdInc: '||to_char(p_PtdInc ));

Line 485: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',6);

481: -- 4
482: l_AnnFig4 := l_AnnFig3 * trc_PosFactor;
483: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',5);
484: --
485: hr_utility.set_location(g_indent||'py_za_total_package.Annualise',6);
486: --
487: WriteHrTrace(g_indent||'p_PtdInc: '||to_char(p_PtdInc ));
488: WriteHrTrace(g_indent||'trc_PrdFactor: '||to_char(trc_PrdFactor ));
489: WriteHrTrace(g_indent||'l_AnnFig1: '||to_char(l_AnnFig1 ));

Line 523: hr_utility.set_location(g_indent||'py_za_total_package.DaysWorked',1);

519:
520: BEGIN
521: g_indent := g_indent||' ';
522: IF trc_AnnualisationType = 'YtdCalc' THEN
523: hr_utility.set_location(g_indent||'py_za_total_package.DaysWorked',1);
524: l_EndDte := dbi_ZA_CUR_PRD_STRT_DTE - 1;
525: l_StrtDte := GREATEST(dbi_ZA_ACT_STRT_DTE, dbi_ZA_TX_YR_STRT);
526:
527: ELSIF trc_AnnualisationType = 'CalCalc' THEN

Line 528: hr_utility.set_location(g_indent||'py_za_total_package.DaysWorked',2);

524: l_EndDte := dbi_ZA_CUR_PRD_STRT_DTE - 1;
525: l_StrtDte := GREATEST(dbi_ZA_ACT_STRT_DTE, dbi_ZA_TX_YR_STRT);
526:
527: ELSIF trc_AnnualisationType = 'CalCalc' THEN
528: hr_utility.set_location(g_indent||'py_za_total_package.DaysWorked',2);
529: l_EndDte := dbi_ZA_TX_YR_STRT - 1;
530: l_StrtDte := GREATEST(dbi_ZA_ACT_STRT_DTE,
531: to_date('01/01/'||to_char(to_number(to_char(dbi_ZA_TX_YR_END,'YYYY'))-1),'DD/MM/YYYY'));
532:

Line 534: hr_utility.set_location(g_indent||'py_za_total_package.DaysWorked',3);

530: l_StrtDte := GREATEST(dbi_ZA_ACT_STRT_DTE,
531: to_date('01/01/'||to_char(to_number(to_char(dbi_ZA_TX_YR_END,'YYYY'))-1),'DD/MM/YYYY'));
532:
533: ELSIF trc_AnnualisationType = 'SitCalc' AND trc_NegPtd THEN
534: hr_utility.set_location(g_indent||'py_za_total_package.DaysWorked',3);
535: l_EndDte := LEAST(dbi_ZA_ACT_END_DTE, dbi_ZA_CUR_PRD_END_DTE);
536: l_StrtDte := GREATEST(dbi_ZA_ACT_STRT_DTE, dbi_ZA_TX_YR_STRT);
537:
538: ELSIF trc_AnnualisationType = 'SitCalc' THEN

Line 539: hr_utility.set_location(g_indent||'py_za_total_package.DaysWorked',4);

535: l_EndDte := LEAST(dbi_ZA_ACT_END_DTE, dbi_ZA_CUR_PRD_END_DTE);
536: l_StrtDte := GREATEST(dbi_ZA_ACT_STRT_DTE, dbi_ZA_TX_YR_STRT);
537:
538: ELSIF trc_AnnualisationType = 'SitCalc' THEN
539: hr_utility.set_location(g_indent||'py_za_total_package.DaysWorked',4);
540: l_EndDte := LEAST(dbi_ZA_ACT_END_DTE, dbi_ZA_TX_YR_END);
541: l_StrtDte := GREATEST(dbi_ZA_ACT_STRT_DTE, dbi_ZA_TX_YR_STRT);
542: END IF;
543:

Line 567: hr_utility.set_location(g_indent||'py_za_total_package.ClearGlobals',1);

563: PROCEDURE ClearGlobals AS
564:
565: BEGIN
566: g_indent := g_indent||' ';
567: hr_utility.set_location(g_indent||'py_za_total_package.ClearGlobals',1);
568:
569: -- Trace Globals
570: trc_AnnBonPtd := 0;
571: trc_AnnPymPtd := 0;

Line 664: -- Set hr_utility globals if debugging

660:
661: -------------------------------------------------------------------------------
662: BEGIN-- MAIN --
663: -------------------------------------------------------------------------------
664: -- Set hr_utility globals if debugging
665: --
666: --g_HrTraceEnabled := TRUE;
667: --g_HrTracePipeName := 'ZATOTPKG';
668:

Line 669: -- Call hr_utility start procedure

665: --
666: --g_HrTraceEnabled := TRUE;
667: --g_HrTracePipeName := 'ZATOTPKG';
668:
669: -- Call hr_utility start procedure
670: StartHrTrace;
671:
672: WriteHrTrace(' ');
673: WriteHrTrace(' ');

Line 722: hr_utility.set_location('py_za_total_package.split_totpkg',1);

718: WriteHrTrace('p_TXB_PKG_CMP_RFI_YTD '||to_char(p_TXB_PKG_CMP_RFI_YTD ));
719: WriteHrTrace('p_TXB_PKG_CMP_YTD '||to_char(p_TXB_PKG_CMP_YTD ));
720: WriteHrTrace('-- Out Parameters');
721: --
722: hr_utility.set_location('py_za_total_package.split_totpkg',1);
723: -------------------------------------------------------------------------------
724: -- Set variables
725: -------------------------------------------------------------------------------
726: -- Database Items

Line 770: hr_utility.set_location('py_za_total_package.split_totpkg',2);

766: bal_TXB_PKG_CMP_RFI_YTD := p_TXB_PKG_CMP_RFI_YTD;
767: bal_TXB_PKG_CMP_YTD := p_TXB_PKG_CMP_YTD;
768:
769:
770: hr_utility.set_location('py_za_total_package.split_totpkg',2);
771:
772: -------------------------------------------------------------------------------
773: -- Calculate PTD RFIable Total Package value
774: -------------------------------------------------------------------------------

Line 776: hr_utility.set_location('py_za_total_package.split_totpkg',3);

772: -------------------------------------------------------------------------------
773: -- Calculate PTD RFIable Total Package value
774: -------------------------------------------------------------------------------
775: trc_RFIableTotPkgPTD := dbi_TOT_PKG * (dbi_FXD_PRC / 100) / dbi_ZA_PAY_PRDS_PER_YR;
776: hr_utility.set_location('py_za_total_package.split_totpkg',3);
777: -- Calculate the update value
778: --
779: trc_RFIableTotPkgPTD_Upd := trc_RFIableTotPkgPTD - bal_RFIABLE_TOT_PKG_PTD;
780:

Line 789: hr_utility.set_location('py_za_total_package.split_totpkg',4);

785: --
786: trc_TotTxbPkgCmp := bal_TXB_PKG_CMP_YTD + bal_ANN_TXB_PKG_CMP_YTD;
787:
788: IF trc_TotTxbPkgCmp <> 0 THEN
789: hr_utility.set_location('py_za_total_package.split_totpkg',4);
790: -- Annualisation Check
791: --
792: IF LatePayPeriod THEN
793: hr_utility.set_location('py_za_total_package.split_totpkg',5);

Line 793: hr_utility.set_location('py_za_total_package.split_totpkg',5);

789: hr_utility.set_location('py_za_total_package.split_totpkg',4);
790: -- Annualisation Check
791: --
792: IF LatePayPeriod THEN
793: hr_utility.set_location('py_za_total_package.split_totpkg',5);
794: trc_AnnualisationType := 'LteCalc';
795: -- Is this a SITE Period?
796: ELSIF EmpTermPrePeriod THEN
797: hr_utility.set_location('py_za_total_package.split_totpkg',6);

Line 797: hr_utility.set_location('py_za_total_package.split_totpkg',6);

793: hr_utility.set_location('py_za_total_package.split_totpkg',5);
794: trc_AnnualisationType := 'LteCalc';
795: -- Is this a SITE Period?
796: ELSIF EmpTermPrePeriod THEN
797: hr_utility.set_location('py_za_total_package.split_totpkg',6);
798: trc_AnnualisationType := 'SitCalc';
799: ELSIF LstPeriod OR EmpTermInPeriod THEN
800: hr_utility.set_location('py_za_total_package.split_totpkg',7);
801: IF PreErnPeriod THEN

Line 800: hr_utility.set_location('py_za_total_package.split_totpkg',7);

796: ELSIF EmpTermPrePeriod THEN
797: hr_utility.set_location('py_za_total_package.split_totpkg',6);
798: trc_AnnualisationType := 'SitCalc';
799: ELSIF LstPeriod OR EmpTermInPeriod THEN
800: hr_utility.set_location('py_za_total_package.split_totpkg',7);
801: IF PreErnPeriod THEN
802: hr_utility.set_location('py_za_total_package.split_totpkg',8);
803: trc_AnnualisationType := 'YtdCalc';
804: ELSE

Line 802: hr_utility.set_location('py_za_total_package.split_totpkg',8);

798: trc_AnnualisationType := 'SitCalc';
799: ELSIF LstPeriod OR EmpTermInPeriod THEN
800: hr_utility.set_location('py_za_total_package.split_totpkg',7);
801: IF PreErnPeriod THEN
802: hr_utility.set_location('py_za_total_package.split_totpkg',8);
803: trc_AnnualisationType := 'YtdCalc';
804: ELSE
805: hr_utility.set_location('py_za_total_package.split_totpkg',9);
806: trc_AnnualisationType := 'SitCalc';

Line 805: hr_utility.set_location('py_za_total_package.split_totpkg',9);

801: IF PreErnPeriod THEN
802: hr_utility.set_location('py_za_total_package.split_totpkg',8);
803: trc_AnnualisationType := 'YtdCalc';
804: ELSE
805: hr_utility.set_location('py_za_total_package.split_totpkg',9);
806: trc_AnnualisationType := 'SitCalc';
807: END IF;
808: ElSE
809: hr_utility.set_location('py_za_total_package.split_totpkg',10);

Line 809: hr_utility.set_location('py_za_total_package.split_totpkg',10);

805: hr_utility.set_location('py_za_total_package.split_totpkg',9);
806: trc_AnnualisationType := 'SitCalc';
807: END IF;
808: ElSE
809: hr_utility.set_location('py_za_total_package.split_totpkg',10);
810: -- The employee has NOT been terminated!
811: IF PreErnPeriod THEN
812: hr_utility.set_location('py_za_total_package.split_totpkg',11);
813: trc_AnnualisationType := 'YtdCalc';

Line 812: hr_utility.set_location('py_za_total_package.split_totpkg',11);

808: ElSE
809: hr_utility.set_location('py_za_total_package.split_totpkg',10);
810: -- The employee has NOT been terminated!
811: IF PreErnPeriod THEN
812: hr_utility.set_location('py_za_total_package.split_totpkg',11);
813: trc_AnnualisationType := 'YtdCalc';
814: --Bug 4346955 bug 5148830
815: /* ELSIF dbi_ZA_ASG_TX_RTR_PRD = 'Y' THEN
816: hr_utility.set_location('py_za_total_package.split_totpkg',12);

Line 816: hr_utility.set_location('py_za_total_package.split_totpkg',12);

812: hr_utility.set_location('py_za_total_package.split_totpkg',11);
813: trc_AnnualisationType := 'YtdCalc';
814: --Bug 4346955 bug 5148830
815: /* ELSIF dbi_ZA_ASG_TX_RTR_PRD = 'Y' THEN
816: hr_utility.set_location('py_za_total_package.split_totpkg',12);
817: IF dbi_ZA_ASG_TAX_RTR_RSLTS = 'Y' THEN
818: hr_utility.set_location('py_za_total_package.split_totpkg',13);
819: trc_AnnualisationType := 'SitCalc';
820: ELSIF NegPtd THEN

Line 818: hr_utility.set_location('py_za_total_package.split_totpkg',13);

814: --Bug 4346955 bug 5148830
815: /* ELSIF dbi_ZA_ASG_TX_RTR_PRD = 'Y' THEN
816: hr_utility.set_location('py_za_total_package.split_totpkg',12);
817: IF dbi_ZA_ASG_TAX_RTR_RSLTS = 'Y' THEN
818: hr_utility.set_location('py_za_total_package.split_totpkg',13);
819: trc_AnnualisationType := 'SitCalc';
820: ELSIF NegPtd THEN
821: hr_utility.set_location('py_za_total_package.split_totpkg',14);
822: trc_AnnualisationType := 'SitCalc';

Line 821: hr_utility.set_location('py_za_total_package.split_totpkg',14);

817: IF dbi_ZA_ASG_TAX_RTR_RSLTS = 'Y' THEN
818: hr_utility.set_location('py_za_total_package.split_totpkg',13);
819: trc_AnnualisationType := 'SitCalc';
820: ELSIF NegPtd THEN
821: hr_utility.set_location('py_za_total_package.split_totpkg',14);
822: trc_AnnualisationType := 'SitCalc';
823: ELSE
824: hr_utility.set_location('py_za_total_package.split_totpkg',15);
825: trc_AnnualisationType := 'NorCalc';

Line 824: hr_utility.set_location('py_za_total_package.split_totpkg',15);

820: ELSIF NegPtd THEN
821: hr_utility.set_location('py_za_total_package.split_totpkg',14);
822: trc_AnnualisationType := 'SitCalc';
823: ELSE
824: hr_utility.set_location('py_za_total_package.split_totpkg',15);
825: trc_AnnualisationType := 'NorCalc';
826: END IF; */
827: ELSIF NegPtd THEN
828: hr_utility.set_location('py_za_total_package.split_totpkg',16);

Line 828: hr_utility.set_location('py_za_total_package.split_totpkg',16);

824: hr_utility.set_location('py_za_total_package.split_totpkg',15);
825: trc_AnnualisationType := 'NorCalc';
826: END IF; */
827: ELSIF NegPtd THEN
828: hr_utility.set_location('py_za_total_package.split_totpkg',16);
829: trc_AnnualisationType := 'SitCalc';
830: ELSE
831: hr_utility.set_location('py_za_total_package.split_totpkg',17);
832: trc_AnnualisationType := 'NorCalc';

Line 831: hr_utility.set_location('py_za_total_package.split_totpkg',17);

827: ELSIF NegPtd THEN
828: hr_utility.set_location('py_za_total_package.split_totpkg',16);
829: trc_AnnualisationType := 'SitCalc';
830: ELSE
831: hr_utility.set_location('py_za_total_package.split_totpkg',17);
832: trc_AnnualisationType := 'NorCalc';
833: END IF;
834: END IF;
835: --

Line 839: hr_utility.set_location('py_za_total_package.split_totpkg',18);

835: --
836: -- Pre-Earnings Check
837: --
838: IF trc_AnnualisationType = 'YtdCalc' THEN
839: hr_utility.set_location('py_za_total_package.split_totpkg',18);
840: -- Ytd Taxable Income
841: --
842: trc_TxbIncYtd := ( bal_TOT_TXB_NI_YTD
843: + bal_TOT_TXB_FB_YTD

Line 850: hr_utility.set_location('py_za_total_package.split_totpkg',19);

846: );
847: -- If the Ytd Taxable Income = 0, execute the CalCalc
848: --
849: IF trc_TxbIncYtd = 0 THEN
850: hr_utility.set_location('py_za_total_package.split_totpkg',19);
851: -- Calendar Ytd Taxable Income
852: --
853: trc_TxbIncYtd := ( bal_TOT_TXB_NI_CYTD
854: + bal_TOT_TXB_FB_CYTD

Line 859: hr_utility.set_location('py_za_total_package.split_totpkg',20);

855: + bal_TOT_TXB_TA_CYTD );
856: -- If there is no Income Execute the Base calculation
857: --
858: IF trc_TxbIncYtd = 0 THEN
859: hr_utility.set_location('py_za_total_package.split_totpkg',20);
860: trc_AnnualisationType := 'BasCalc';
861: ELSE
862: hr_utility.set_location('py_za_total_package.split_totpkg',21);
863: trc_AnnualisationType := 'CalCalc';

Line 862: hr_utility.set_location('py_za_total_package.split_totpkg',21);

858: IF trc_TxbIncYtd = 0 THEN
859: hr_utility.set_location('py_za_total_package.split_totpkg',20);
860: trc_AnnualisationType := 'BasCalc';
861: ELSE
862: hr_utility.set_location('py_za_total_package.split_totpkg',21);
863: trc_AnnualisationType := 'CalCalc';
864: END IF;
865: END IF;
866:

Line 872: hr_utility.set_location('py_za_total_package.split_totpkg',22);

868:
869: -- Set Factors
870: --
871: IF trc_AnnualisationType IN ('SitCalc','YtdCalc','CalCalc') THEN
872: hr_utility.set_location('py_za_total_package.split_totpkg',22);
873: trc_SitFactor := dbi_ZA_DYS_IN_YR / DaysWorked;
874: END IF;
875:
876: IF trc_AnnualisationType = 'NorCalc' THEN

Line 877: hr_utility.set_location('py_za_total_package.split_totpkg',23);

873: trc_SitFactor := dbi_ZA_DYS_IN_YR / DaysWorked;
874: END IF;
875:
876: IF trc_AnnualisationType = 'NorCalc' THEN
877: hr_utility.set_location('py_za_total_package.split_totpkg',23);
878: PeriodFactor;
879: PossiblePeriodsFactor;
880: END IF;
881:

Line 900: hr_utility.set_location('py_za_total_package.split_totpkg',24);

896: -- Annualise TxbPkgCmps
897: trc_TxbPkgCmp := Annualise(p_YtdInc => bal_TXB_PKG_CMP_YTD
898: ,p_PtdInc => bal_TXB_PKG_CMP_PTD
899: );
900: hr_utility.set_location('py_za_total_package.split_totpkg',24);
901: --
902: trc_TotTxbPkgCmp := trc_TxbPkgCmp + bal_ANN_TXB_PKG_CMP_YTD;
903: -- Calculate Split %
904: --

Line 909: hr_utility.set_location('py_za_total_package.split_totpkg',25);

905: trc_TxbPrc := least((trc_PrjRFIableTotPkg / trc_TotTxbPkgCmp),1);
906:
907: -- Calculate Split Values
908: -- Periodic
909: hr_utility.set_location('py_za_total_package.split_totpkg',25);
910: trc_TxbPkgCmpRFI := bal_TXB_PKG_CMP_YTD * trc_TxbPrc;
911: trc_TxbPkgCmpNRFI := bal_TXB_PKG_CMP_YTD - trc_TxbPkgCmpRFI;
912: -- Annual
913: hr_utility.set_location('py_za_total_package.split_totpkg',26);

Line 913: hr_utility.set_location('py_za_total_package.split_totpkg',26);

909: hr_utility.set_location('py_za_total_package.split_totpkg',25);
910: trc_TxbPkgCmpRFI := bal_TXB_PKG_CMP_YTD * trc_TxbPrc;
911: trc_TxbPkgCmpNRFI := bal_TXB_PKG_CMP_YTD - trc_TxbPkgCmpRFI;
912: -- Annual
913: hr_utility.set_location('py_za_total_package.split_totpkg',26);
914: trc_AnnTxbPkgCmpRFI := bal_ANN_TXB_PKG_CMP_YTD * trc_TxbPrc;
915: trc_AnnTxbPkgCmpNRFI := bal_ANN_TXB_PKG_CMP_YTD - trc_AnnTxbPkgCmpRFI;
916:
917: -- Calculate Update Values

Line 919: hr_utility.set_location('py_za_total_package.split_totpkg',27);

915: trc_AnnTxbPkgCmpNRFI := bal_ANN_TXB_PKG_CMP_YTD - trc_AnnTxbPkgCmpRFI;
916:
917: -- Calculate Update Values
918: -- Periodic
919: hr_utility.set_location('py_za_total_package.split_totpkg',27);
920: trc_TxbPkgCmpRFI_Upd := trc_TxbPkgCmpRFI - bal_TXB_PKG_CMP_RFI_YTD;
921: trc_TxbPkgCmpNRFI_Upd := trc_TxbPkgCmpNRFI - bal_TXB_PKG_CMP_NRFI_YTD;
922: -- Annual
923: hr_utility.set_location('py_za_total_package.split_totpkg',28);

Line 923: hr_utility.set_location('py_za_total_package.split_totpkg',28);

919: hr_utility.set_location('py_za_total_package.split_totpkg',27);
920: trc_TxbPkgCmpRFI_Upd := trc_TxbPkgCmpRFI - bal_TXB_PKG_CMP_RFI_YTD;
921: trc_TxbPkgCmpNRFI_Upd := trc_TxbPkgCmpNRFI - bal_TXB_PKG_CMP_NRFI_YTD;
922: -- Annual
923: hr_utility.set_location('py_za_total_package.split_totpkg',28);
924: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
925: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
926:
927: hr_utility.set_location('py_za_total_package.split_totpkg',29);

Line 927: hr_utility.set_location('py_za_total_package.split_totpkg',29);

923: hr_utility.set_location('py_za_total_package.split_totpkg',28);
924: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
925: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
926:
927: hr_utility.set_location('py_za_total_package.split_totpkg',29);
928:
929: -------------------------------------------------------------------------
930: ELSIF trc_AnnualisationType = 'SitCalc' THEN --
931: -------------------------------------------------------------------------

Line 950: hr_utility.set_location('py_za_total_package.split_totpkg',30);

946: --
947: --
948: -- Periodic
949: --
950: hr_utility.set_location('py_za_total_package.split_totpkg',30);
951: trc_TxbPkgCmpRFI := bal_TXB_PKG_CMP_YTD * trc_TxbPrc;
952: trc_TxbPkgCmpNRFI := bal_TXB_PKG_CMP_YTD - trc_TxbPkgCmpRFI;
953: --
954: -- Annual

Line 956: hr_utility.set_location('py_za_total_package.split_totpkg',31);

952: trc_TxbPkgCmpNRFI := bal_TXB_PKG_CMP_YTD - trc_TxbPkgCmpRFI;
953: --
954: -- Annual
955: --
956: hr_utility.set_location('py_za_total_package.split_totpkg',31);
957: trc_AnnTxbPkgCmpRFI := bal_ANN_TXB_PKG_CMP_YTD * trc_TxbPrc;
958: trc_AnnTxbPkgCmpNRFI := bal_ANN_TXB_PKG_CMP_YTD - trc_AnnTxbPkgCmpRFI;
959: --
960: -- Calculate Update Values

Line 965: hr_utility.set_location('py_za_total_package.split_totpkg',32);

961: --
962: --
963: -- Periodic
964: --
965: hr_utility.set_location('py_za_total_package.split_totpkg',32);
966: trc_TxbPkgCmpRFI_Upd := trc_TxbPkgCmpRFI - bal_TXB_PKG_CMP_RFI_YTD;
967: trc_TxbPkgCmpNRFI_Upd := trc_TxbPkgCmpNRFI - bal_TXB_PKG_CMP_NRFI_YTD;
968: --
969: -- Annual

Line 971: hr_utility.set_location('py_za_total_package.split_totpkg',33);

967: trc_TxbPkgCmpNRFI_Upd := trc_TxbPkgCmpNRFI - bal_TXB_PKG_CMP_NRFI_YTD;
968: --
969: -- Annual
970: --
971: hr_utility.set_location('py_za_total_package.split_totpkg',33);
972: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
973: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
974: --
975: hr_utility.set_location('py_za_total_package.split_totpkg',34);

Line 975: hr_utility.set_location('py_za_total_package.split_totpkg',34);

971: hr_utility.set_location('py_za_total_package.split_totpkg',33);
972: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
973: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
974: --
975: hr_utility.set_location('py_za_total_package.split_totpkg',34);
976: --
977: -------------------------------------------------------------------------
978: ELSIF trc_AnnualisationType = 'YtdCalc' THEN --
979: -------------------------------------------------------------------------

Line 992: hr_utility.set_location('py_za_total_package.split_totpkg',35);

988: trc_TxbPrc := least((trc_PrjRFIableTotPkg / trc_TotTxbPkgCmp),1);
989:
990: -- Calculate Split Values
991: -- Annual
992: hr_utility.set_location('py_za_total_package.split_totpkg',35);
993: trc_AnnTxbPkgCmpRFI := bal_ANN_TXB_PKG_CMP_YTD * trc_TxbPrc;
994: trc_AnnTxbPkgCmpNRFI := bal_ANN_TXB_PKG_CMP_YTD - trc_AnnTxbPkgCmpRFI;
995:
996: -- Calculate Update Values

Line 998: hr_utility.set_location('py_za_total_package.split_totpkg',36);

994: trc_AnnTxbPkgCmpNRFI := bal_ANN_TXB_PKG_CMP_YTD - trc_AnnTxbPkgCmpRFI;
995:
996: -- Calculate Update Values
997: -- Annual
998: hr_utility.set_location('py_za_total_package.split_totpkg',36);
999: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
1000: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
1001:
1002: hr_utility.set_location('py_za_total_package.split_totpkg',37);

Line 1002: hr_utility.set_location('py_za_total_package.split_totpkg',37);

998: hr_utility.set_location('py_za_total_package.split_totpkg',36);
999: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
1000: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
1001:
1002: hr_utility.set_location('py_za_total_package.split_totpkg',37);
1003:
1004: -------------------------------------------------------------------------
1005: ELSIF trc_AnnualisationType = 'CalCalc' THEN --
1006: -------------------------------------------------------------------------

Line 1019: hr_utility.set_location('py_za_total_package.split_totpkg',38);

1015: trc_TxbPrc := least((trc_PrjRFIableTotPkg / trc_TotTxbPkgCmp),1);
1016:
1017: -- Calculate Split Values
1018: -- Annual
1019: hr_utility.set_location('py_za_total_package.split_totpkg',38);
1020: trc_AnnTxbPkgCmpRFI := bal_ANN_TXB_PKG_CMP_YTD * trc_TxbPrc;
1021: trc_AnnTxbPkgCmpNRFI := bal_ANN_TXB_PKG_CMP_YTD - trc_AnnTxbPkgCmpRFI;
1022:
1023: -- Calculate Update Values

Line 1025: hr_utility.set_location('py_za_total_package.split_totpkg',39);

1021: trc_AnnTxbPkgCmpNRFI := bal_ANN_TXB_PKG_CMP_YTD - trc_AnnTxbPkgCmpRFI;
1022:
1023: -- Calculate Update Values
1024: -- Annual
1025: hr_utility.set_location('py_za_total_package.split_totpkg',39);
1026: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
1027: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
1028:
1029: hr_utility.set_location('py_za_total_package.split_totpkg',40);

Line 1029: hr_utility.set_location('py_za_total_package.split_totpkg',40);

1025: hr_utility.set_location('py_za_total_package.split_totpkg',39);
1026: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
1027: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
1028:
1029: hr_utility.set_location('py_za_total_package.split_totpkg',40);
1030:
1031: -------------------------------------------------------------------------
1032: ELSIF trc_AnnualisationType = 'BasCalc' THEN --
1033: -------------------------------------------------------------------------

Line 1046: hr_utility.set_location('py_za_total_package.split_totpkg',41);

1042: trc_TxbPrc := least((trc_PrjRFIableTotPkg / trc_TotTxbPkgCmp),1);
1043:
1044: -- Calculate Split Values
1045: -- Annual
1046: hr_utility.set_location('py_za_total_package.split_totpkg',41);
1047: trc_AnnTxbPkgCmpRFI := bal_ANN_TXB_PKG_CMP_YTD * trc_TxbPrc;
1048: trc_AnnTxbPkgCmpNRFI := bal_ANN_TXB_PKG_CMP_YTD - trc_AnnTxbPkgCmpRFI;
1049:
1050: -- Calculate Update Values

Line 1052: hr_utility.set_location('py_za_total_package.split_totpkg',42);

1048: trc_AnnTxbPkgCmpNRFI := bal_ANN_TXB_PKG_CMP_YTD - trc_AnnTxbPkgCmpRFI;
1049:
1050: -- Calculate Update Values
1051: -- Annual
1052: hr_utility.set_location('py_za_total_package.split_totpkg',42);
1053: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
1054: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
1055:
1056: hr_utility.set_location('py_za_total_package.split_totpkg',43);

Line 1056: hr_utility.set_location('py_za_total_package.split_totpkg',43);

1052: hr_utility.set_location('py_za_total_package.split_totpkg',42);
1053: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
1054: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
1055:
1056: hr_utility.set_location('py_za_total_package.split_totpkg',43);
1057:
1058: -------------------------------------------------------------------------
1059: ELSIF trc_AnnualisationType = 'LteCalc' THEN --
1060: -------------------------------------------------------------------------

Line 1074: hr_utility.set_location('py_za_total_package.split_totpkg',44);

1070: trc_TxbPrc := least((trc_PrjRFIableTotPkg / trc_TotTxbPkgCmp),1);
1071:
1072: -- Calculate Split Values
1073: -- Periodic
1074: hr_utility.set_location('py_za_total_package.split_totpkg',44);
1075: trc_TxbPkgCmpRFI := bal_TXB_PKG_CMP_YTD * trc_TxbPrc;
1076: trc_TxbPkgCmpNRFI := bal_TXB_PKG_CMP_YTD - trc_TxbPkgCmpRFI;
1077: -- Annual
1078: hr_utility.set_location('py_za_total_package.split_totpkg',45);

Line 1078: hr_utility.set_location('py_za_total_package.split_totpkg',45);

1074: hr_utility.set_location('py_za_total_package.split_totpkg',44);
1075: trc_TxbPkgCmpRFI := bal_TXB_PKG_CMP_YTD * trc_TxbPrc;
1076: trc_TxbPkgCmpNRFI := bal_TXB_PKG_CMP_YTD - trc_TxbPkgCmpRFI;
1077: -- Annual
1078: hr_utility.set_location('py_za_total_package.split_totpkg',45);
1079: trc_AnnTxbPkgCmpRFI := bal_ANN_TXB_PKG_CMP_YTD * trc_TxbPrc;
1080: trc_AnnTxbPkgCmpNRFI := bal_ANN_TXB_PKG_CMP_YTD - trc_AnnTxbPkgCmpRFI;
1081:
1082: -- Calculate Update Values

Line 1084: hr_utility.set_location('py_za_total_package.split_totpkg',46);

1080: trc_AnnTxbPkgCmpNRFI := bal_ANN_TXB_PKG_CMP_YTD - trc_AnnTxbPkgCmpRFI;
1081:
1082: -- Calculate Update Values
1083: -- Periodic
1084: hr_utility.set_location('py_za_total_package.split_totpkg',46);
1085: trc_TxbPkgCmpRFI_Upd := trc_TxbPkgCmpRFI - bal_TXB_PKG_CMP_RFI_YTD;
1086: trc_TxbPkgCmpNRFI_Upd := trc_TxbPkgCmpNRFI - bal_TXB_PKG_CMP_NRFI_YTD;
1087: -- Annual
1088: hr_utility.set_location('py_za_total_package.split_totpkg',47);

Line 1088: hr_utility.set_location('py_za_total_package.split_totpkg',47);

1084: hr_utility.set_location('py_za_total_package.split_totpkg',46);
1085: trc_TxbPkgCmpRFI_Upd := trc_TxbPkgCmpRFI - bal_TXB_PKG_CMP_RFI_YTD;
1086: trc_TxbPkgCmpNRFI_Upd := trc_TxbPkgCmpNRFI - bal_TXB_PKG_CMP_NRFI_YTD;
1087: -- Annual
1088: hr_utility.set_location('py_za_total_package.split_totpkg',47);
1089: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
1090: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
1091:
1092: hr_utility.set_location('py_za_total_package.split_totpkg',48);

Line 1092: hr_utility.set_location('py_za_total_package.split_totpkg',48);

1088: hr_utility.set_location('py_za_total_package.split_totpkg',47);
1089: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
1090: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
1091:
1092: hr_utility.set_location('py_za_total_package.split_totpkg',48);
1093:
1094: -------------------------------------------------------------------------
1095: END IF;-- End CalcTyp Check
1096: -------------------------------------------------------------------------

Line 1102: hr_utility.set_location('py_za_total_package.split_totpkg',49);

1098: -- There exist no taxable package component values
1099: -- Calculate PTD update values
1100: --
1101: -- Periodic
1102: hr_utility.set_location('py_za_total_package.split_totpkg',49);
1103: trc_TxbPkgCmpRFI_Upd := trc_TxbPkgCmpRFI - bal_TXB_PKG_CMP_RFI_YTD;
1104: trc_TxbPkgCmpNRFI_Upd := trc_TxbPkgCmpNRFI - bal_TXB_PKG_CMP_NRFI_YTD;
1105: -- Annual
1106: hr_utility.set_location('py_za_total_package.split_totpkg',50);

Line 1106: hr_utility.set_location('py_za_total_package.split_totpkg',50);

1102: hr_utility.set_location('py_za_total_package.split_totpkg',49);
1103: trc_TxbPkgCmpRFI_Upd := trc_TxbPkgCmpRFI - bal_TXB_PKG_CMP_RFI_YTD;
1104: trc_TxbPkgCmpNRFI_Upd := trc_TxbPkgCmpNRFI - bal_TXB_PKG_CMP_NRFI_YTD;
1105: -- Annual
1106: hr_utility.set_location('py_za_total_package.split_totpkg',50);
1107: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
1108: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
1109:
1110: hr_utility.set_location('py_za_total_package.split_totpkg',51);

Line 1110: hr_utility.set_location('py_za_total_package.split_totpkg',51);

1106: hr_utility.set_location('py_za_total_package.split_totpkg',50);
1107: trc_AnnTxbPkgCmpRFI_Upd := trc_AnnTxbPkgCmpRFI - bal_ANN_TXB_PKG_CMP_RFI_YTD;
1108: trc_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI - bal_ANN_TXB_PKG_CMP_NRFI_YTD;
1109:
1110: hr_utility.set_location('py_za_total_package.split_totpkg',51);
1111:
1112: END IF;
1113:
1114: -- Set output parameters

Line 1122: hr_utility.set_location('py_za_total_package.split_totpkg',52);

1118: p_AnnTxbPkgCmpNRFI_Upd := trc_AnnTxbPkgCmpNRFI_Upd;
1119: p_TxbPkgCmpRFI_Upd := trc_TxbPkgCmpRFI_Upd;
1120: p_TxbPkgCmpNRFI_Upd := trc_TxbPkgCmpNRFI_Upd;
1121:
1122: hr_utility.set_location('py_za_total_package.split_totpkg',52);
1123:
1124: WriteHrTrace('-- Trace Variables');
1125: WriteHrTrace('trc_AnnBonPtd '||to_char(trc_AnnBonPtd ));
1126: WriteHrTrace('trc_AnnPymPtd '||to_char(trc_AnnPymPtd ));

Line 1148: hr_utility.set_location('py_za_total_package.split_totpkg',53);

1144: WriteHrTrace('trc_TxbPkgCmpRFI '||to_char(trc_TxbPkgCmpRFI ));
1145: WriteHrTrace('trc_TxbPkgCmpRFI_Upd '||to_char(trc_TxbPkgCmpRFI_Upd ));
1146: WriteHrTrace('trc_TxbPrc '||to_char(trc_TxbPrc ));
1147:
1148: hr_utility.set_location('py_za_total_package.split_totpkg',53);
1149:
1150: ClearGlobals;
1151:
1152: -- End off Trace File

Line 1168: hr_utility.set_location('py_za_total_package.split_totpkg',54);

1164: RETURN l_Dum;
1165:
1166: EXCEPTION
1167: WHEN OTHERS THEN
1168: hr_utility.set_location('py_za_total_package.split_totpkg',54);
1169: WriteHrTrace('Sql error code: '||TO_CHAR(SQLCODE));
1170: WriteHrTrace('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
1171: StopHrTrace;
1172: hr_utility.set_message(801, 'py_za_total_package: '||TO_CHAR(SQLCODE));

Line 1172: hr_utility.set_message(801, 'py_za_total_package: '||TO_CHAR(SQLCODE));

1168: hr_utility.set_location('py_za_total_package.split_totpkg',54);
1169: WriteHrTrace('Sql error code: '||TO_CHAR(SQLCODE));
1170: WriteHrTrace('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
1171: StopHrTrace;
1172: hr_utility.set_message(801, 'py_za_total_package: '||TO_CHAR(SQLCODE));
1173: hr_utility.raise_error;
1174:
1175: END split_totpkg;
1176:

Line 1173: hr_utility.raise_error;

1169: WriteHrTrace('Sql error code: '||TO_CHAR(SQLCODE));
1170: WriteHrTrace('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
1171: StopHrTrace;
1172: hr_utility.set_message(801, 'py_za_total_package: '||TO_CHAR(SQLCODE));
1173: hr_utility.raise_error;
1174:
1175: END split_totpkg;
1176:
1177: END py_za_total_package;