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

Line 72: hr_utility.set_location('Entering : global_super_values',1);

68:
69:
70:
71: begin
72: hr_utility.set_location('Entering : global_super_values',1);
73: hr_utility.trace('p_effective_date'||p_effective_date);
74:
75:
76: -- /* select all global value(legislative) */

Line 73: hr_utility.trace('p_effective_date'||p_effective_date);

69:
70:
71: begin
72: hr_utility.set_location('Entering : global_super_values',1);
73: hr_utility.trace('p_effective_date'||p_effective_date);
74:
75:
76: -- /* select all global value(legislative) */
77:

Line 107: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;

103:
104:
105: Exception
106: when others then
107: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
108: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.gobal_super_values ');
109: hr_utility.set_message_token('STEP','body') ;
110: hr_utility.raise_error ;
111:

Line 108: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.gobal_super_values ');

104:
105: Exception
106: when others then
107: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
108: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.gobal_super_values ');
109: hr_utility.set_message_token('STEP','body') ;
110: hr_utility.raise_error ;
111:
112: end global_super_values;

Line 109: hr_utility.set_message_token('STEP','body') ;

105: Exception
106: when others then
107: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
108: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.gobal_super_values ');
109: hr_utility.set_message_token('STEP','body') ;
110: hr_utility.raise_error ;
111:
112: end global_super_values;
113:

Line 110: hr_utility.raise_error ;

106: when others then
107: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
108: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.gobal_super_values ');
109: hr_utility.set_message_token('STEP','body') ;
110: hr_utility.raise_error ;
111:
112: end global_super_values;
113:
114:

Line 167: hr_utility.set_location('Entering: function compliance_mesg',2);

163:
164:
165:
166: begin
167: hr_utility.set_location('Entering: function compliance_mesg',2);
168: /*Bug 2610141 - Portion added to get the latest assignment action id*/
169: open get_latest_id(p_assignment_id,p_effective_date);
170: fetch get_latest_id into l_assignment_action_id;
171: close get_latest_id;

Line 206: hr_utility.trace('hrs_worked = '||l_hrs_worked);

202: l_age:=p_employee_age;
203: end if;
204:
205:
206: hr_utility.trace('hrs_worked = '||l_hrs_worked);
207: hr_utility.trace('employee_age = '||l_age);
208:
209:
210: ------------------ /* to get the SGC Contribution for the month */--------------------------------

Line 207: hr_utility.trace('employee_age = '||l_age);

203: end if;
204:
205:
206: hr_utility.trace('hrs_worked = '||l_hrs_worked);
207: hr_utility.trace('employee_age = '||l_age);
208:
209:
210: ------------------ /* to get the SGC Contribution for the month */--------------------------------
211: /*Bug 2610141 --- Added this portion to accomodate for the BRA changes */

Line 271: hr_utility.trace('Out : function compliance_mesg');

267: l_compliance_mesg := 'EXCEPTION' ;
268: END IF;
269:
270:
271: hr_utility.trace('Out : function compliance_mesg');
272:
273:
274: return l_compliance_mesg;
275: --

Line 278: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;

274: return l_compliance_mesg;
275: --
276: Exception
277: when others then
278: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
279: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.compliance_mesg') ;
280: hr_utility.set_message_token('STEP','body') ;
281: hr_utility.raise_error ;
282:

Line 279: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.compliance_mesg') ;

275: --
276: Exception
277: when others then
278: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
279: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.compliance_mesg') ;
280: hr_utility.set_message_token('STEP','body') ;
281: hr_utility.raise_error ;
282:
283: END compliance_mesg;

Line 280: hr_utility.set_message_token('STEP','body') ;

276: Exception
277: when others then
278: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
279: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.compliance_mesg') ;
280: hr_utility.set_message_token('STEP','body') ;
281: hr_utility.raise_error ;
282:
283: END compliance_mesg;
284:

Line 281: hr_utility.raise_error ;

277: when others then
278: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
279: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.compliance_mesg') ;
280: hr_utility.set_message_token('STEP','body') ;
281: hr_utility.raise_error ;
282:
283: END compliance_mesg;
284:
285:

Line 335: hr_utility.set_location(' Entering : employee_super_details',3);

331: l_super_guarantee_bal_id_qtd pay_defined_balances.defined_balance_id%type; --2610141
332:
333:
334: begin
335: hr_utility.set_location(' Entering : employee_super_details',3);
336: hr_utility.trace('p_assgnment_id ='||p_assignment_id);
337: hr_utility.trace('p_effective_date ='||p_effective_date);
338:
339: /*Bug 2610141 - Portion added to get the latest assignment action id*/

Line 336: hr_utility.trace('p_assgnment_id ='||p_assignment_id);

332:
333:
334: begin
335: hr_utility.set_location(' Entering : employee_super_details',3);
336: hr_utility.trace('p_assgnment_id ='||p_assignment_id);
337: hr_utility.trace('p_effective_date ='||p_effective_date);
338:
339: /*Bug 2610141 - Portion added to get the latest assignment action id*/
340: open get_latest_id(p_assignment_id,p_effective_date);

Line 337: hr_utility.trace('p_effective_date ='||p_effective_date);

333:
334: begin
335: hr_utility.set_location(' Entering : employee_super_details',3);
336: hr_utility.trace('p_assgnment_id ='||p_assignment_id);
337: hr_utility.trace('p_effective_date ='||p_effective_date);
338:
339: /*Bug 2610141 - Portion added to get the latest assignment action id*/
340: open get_latest_id(p_assignment_id,p_effective_date);
341: fetch get_latest_id into l_assignment_action_id;

Line 344: hr_utility.trace('Assgmt Action Id ='||l_assignment_action_id);

340: open get_latest_id(p_assignment_id,p_effective_date);
341: fetch get_latest_id into l_assignment_action_id;
342: close get_latest_id;
343:
344: hr_utility.trace('Assgmt Action Id ='||l_assignment_action_id);
345: l_sgc_rate:=(p_sgc_rate/100);
346:
347:
348:

Line 417: hr_utility.trace('balance_id :'||l_bal_id);

413:
414: p_superable_sal:= l_min_superable_salary;
415:
416:
417: hr_utility.trace('balance_id :'||l_bal_id);
418: hr_utility.trace('superable_salary :'||l_salary);
419:
420:
421: -------- /* get warning message if superable salary across funds are different */-----------

Line 418: hr_utility.trace('superable_salary :'||l_salary);

414: p_superable_sal:= l_min_superable_salary;
415:
416:
417: hr_utility.trace('balance_id :'||l_bal_id);
418: hr_utility.trace('superable_salary :'||l_salary);
419:
420:
421: -------- /* get warning message if superable salary across funds are different */-----------
422:

Line 424: hr_utility.set_message(801,'HR_AU_SGC_WARNING_MESG');

420:
421: -------- /* get warning message if superable salary across funds are different */-----------
422:
423: IF l_max_superable_salary <> l_min_superable_salary then
424: hr_utility.set_message(801,'HR_AU_SGC_WARNING_MESG');
425: p_warning_mesg := hr_utility.get_message;
426: ELSE
427: p_warning_mesg := '';
428: END IF;

Line 425: p_warning_mesg := hr_utility.get_message;

421: -------- /* get warning message if superable salary across funds are different */-----------
422:
423: IF l_max_superable_salary <> l_min_superable_salary then
424: hr_utility.set_message(801,'HR_AU_SGC_WARNING_MESG');
425: p_warning_mesg := hr_utility.get_message;
426: ELSE
427: p_warning_mesg := '';
428: END IF;
429:

Line 458: hr_utility.set_message(801,'HR_AU_SGC_MONTHLY_THRESHOLD');

454: ELSIF
455: pay_au_paye_ff.round_to_5c( p_superable_sal * l_sgc_rate) > p_sgc_contribution then
456: IF p_superable_sal < g_monthly_threshold then
457:
458: hr_utility.set_message(801,'HR_AU_SGC_MONTHLY_THRESHOLD');
459: hr_utility.set_message_token('MONTHLY',g_monthly_threshold);
460: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));
461: p_compliance_mesg := hr_utility.get_message;
462:

Line 459: hr_utility.set_message_token('MONTHLY',g_monthly_threshold);

455: pay_au_paye_ff.round_to_5c( p_superable_sal * l_sgc_rate) > p_sgc_contribution then
456: IF p_superable_sal < g_monthly_threshold then
457:
458: hr_utility.set_message(801,'HR_AU_SGC_MONTHLY_THRESHOLD');
459: hr_utility.set_message_token('MONTHLY',g_monthly_threshold);
460: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));
461: p_compliance_mesg := hr_utility.get_message;
462:
463: ELSIF l_age > g_age then

Line 460: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));

456: IF p_superable_sal < g_monthly_threshold then
457:
458: hr_utility.set_message(801,'HR_AU_SGC_MONTHLY_THRESHOLD');
459: hr_utility.set_message_token('MONTHLY',g_monthly_threshold);
460: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));
461: p_compliance_mesg := hr_utility.get_message;
462:
463: ELSIF l_age > g_age then
464:

Line 461: p_compliance_mesg := hr_utility.get_message;

457:
458: hr_utility.set_message(801,'HR_AU_SGC_MONTHLY_THRESHOLD');
459: hr_utility.set_message_token('MONTHLY',g_monthly_threshold);
460: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));
461: p_compliance_mesg := hr_utility.get_message;
462:
463: ELSIF l_age > g_age then
464:
465: hr_utility.set_message(801,'HR_AU_SGC_MAX_AGE');

Line 465: hr_utility.set_message(801,'HR_AU_SGC_MAX_AGE');

461: p_compliance_mesg := hr_utility.get_message;
462:
463: ELSIF l_age > g_age then
464:
465: hr_utility.set_message(801,'HR_AU_SGC_MAX_AGE');
466: hr_utility.set_message_token('AGE',g_age);
467: p_compliance_mesg := hr_utility.get_message;
468:
469: ELSIF l_age < g_age_min and l_hrs_worked < g_min_hrs_worked then

Line 466: hr_utility.set_message_token('AGE',g_age);

462:
463: ELSIF l_age > g_age then
464:
465: hr_utility.set_message(801,'HR_AU_SGC_MAX_AGE');
466: hr_utility.set_message_token('AGE',g_age);
467: p_compliance_mesg := hr_utility.get_message;
468:
469: ELSIF l_age < g_age_min and l_hrs_worked < g_min_hrs_worked then
470:

Line 467: p_compliance_mesg := hr_utility.get_message;

463: ELSIF l_age > g_age then
464:
465: hr_utility.set_message(801,'HR_AU_SGC_MAX_AGE');
466: hr_utility.set_message_token('AGE',g_age);
467: p_compliance_mesg := hr_utility.get_message;
468:
469: ELSIF l_age < g_age_min and l_hrs_worked < g_min_hrs_worked then
470:
471: hr_utility.set_message(801,'HR_AU_SGC_AGE_HRS_WORKED');

Line 471: hr_utility.set_message(801,'HR_AU_SGC_AGE_HRS_WORKED');

467: p_compliance_mesg := hr_utility.get_message;
468:
469: ELSIF l_age < g_age_min and l_hrs_worked < g_min_hrs_worked then
470:
471: hr_utility.set_message(801,'HR_AU_SGC_AGE_HRS_WORKED');
472: hr_utility.set_message_token('MINAGE',g_age_min);
473: hr_utility.set_message_token('HOURS',g_min_hrs_worked);
474: p_compliance_mesg := hr_utility.get_message;
475:

Line 472: hr_utility.set_message_token('MINAGE',g_age_min);

468:
469: ELSIF l_age < g_age_min and l_hrs_worked < g_min_hrs_worked then
470:
471: hr_utility.set_message(801,'HR_AU_SGC_AGE_HRS_WORKED');
472: hr_utility.set_message_token('MINAGE',g_age_min);
473: hr_utility.set_message_token('HOURS',g_min_hrs_worked);
474: p_compliance_mesg := hr_utility.get_message;
475:
476:

Line 473: hr_utility.set_message_token('HOURS',g_min_hrs_worked);

469: ELSIF l_age < g_age_min and l_hrs_worked < g_min_hrs_worked then
470:
471: hr_utility.set_message(801,'HR_AU_SGC_AGE_HRS_WORKED');
472: hr_utility.set_message_token('MINAGE',g_age_min);
473: hr_utility.set_message_token('HOURS',g_min_hrs_worked);
474: p_compliance_mesg := hr_utility.get_message;
475:
476:
477: ELSIF l_SGC_qtd > g_qtd_threshold then

Line 474: p_compliance_mesg := hr_utility.get_message;

470:
471: hr_utility.set_message(801,'HR_AU_SGC_AGE_HRS_WORKED');
472: hr_utility.set_message_token('MINAGE',g_age_min);
473: hr_utility.set_message_token('HOURS',g_min_hrs_worked);
474: p_compliance_mesg := hr_utility.get_message;
475:
476:
477: ELSIF l_SGC_qtd > g_qtd_threshold then
478:

Line 479: hr_utility.set_message(801,'HR_AU_SGC_YTD_EMPLOYER_SGC');

475:
476:
477: ELSIF l_SGC_qtd > g_qtd_threshold then
478:
479: hr_utility.set_message(801,'HR_AU_SGC_YTD_EMPLOYER_SGC');
480: hr_utility.set_message_token('VALUE',g_qtd_threshold * 4);
481: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));
482: p_compliance_mesg := hr_utility.get_message;
483:

Line 480: hr_utility.set_message_token('VALUE',g_qtd_threshold * 4);

476:
477: ELSIF l_SGC_qtd > g_qtd_threshold then
478:
479: hr_utility.set_message(801,'HR_AU_SGC_YTD_EMPLOYER_SGC');
480: hr_utility.set_message_token('VALUE',g_qtd_threshold * 4);
481: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));
482: p_compliance_mesg := hr_utility.get_message;
483:
484:

Line 481: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));

477: ELSIF l_SGC_qtd > g_qtd_threshold then
478:
479: hr_utility.set_message(801,'HR_AU_SGC_YTD_EMPLOYER_SGC');
480: hr_utility.set_message_token('VALUE',g_qtd_threshold * 4);
481: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));
482: p_compliance_mesg := hr_utility.get_message;
483:
484:
485: ELSE

Line 482: p_compliance_mesg := hr_utility.get_message;

478:
479: hr_utility.set_message(801,'HR_AU_SGC_YTD_EMPLOYER_SGC');
480: hr_utility.set_message_token('VALUE',g_qtd_threshold * 4);
481: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));
482: p_compliance_mesg := hr_utility.get_message;
483:
484:
485: ELSE
486: hr_utility.set_message(801,'HR_AU_SGC_NON_COMPLIANT');

Line 486: hr_utility.set_message(801,'HR_AU_SGC_NON_COMPLIANT');

482: p_compliance_mesg := hr_utility.get_message;
483:
484:
485: ELSE
486: hr_utility.set_message(801,'HR_AU_SGC_NON_COMPLIANT');
487: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));
488: p_compliance_mesg := hr_utility.get_message;
489:
490:

Line 487: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));

483:
484:
485: ELSE
486: hr_utility.set_message(801,'HR_AU_SGC_NON_COMPLIANT');
487: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));
488: p_compliance_mesg := hr_utility.get_message;
489:
490:
491: END IF;

Line 488: p_compliance_mesg := hr_utility.get_message;

484:
485: ELSE
486: hr_utility.set_message(801,'HR_AU_SGC_NON_COMPLIANT');
487: hr_utility.set_message_token('AMOUNT',pay_au_paye_ff.round_to_5c(p_superable_sal * l_sgc_rate));
488: p_compliance_mesg := hr_utility.get_message;
489:
490:
491: END IF;
492: END IF;

Line 495: -- hr_utility.trace('Out : employee_super_details');

491: END IF;
492: END IF;
493:
494:
495: -- hr_utility.trace('Out : employee_super_details');
496:
497: Exception
498: when others then
499: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;

Line 499: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;

495: -- hr_utility.trace('Out : employee_super_details');
496:
497: Exception
498: when others then
499: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
500: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.employee_super_details') ;
501: hr_utility.set_message_token('STEP','body') ;
502: hr_utility.raise_error ;
503:

Line 500: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.employee_super_details') ;

496:
497: Exception
498: when others then
499: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
500: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.employee_super_details') ;
501: hr_utility.set_message_token('STEP','body') ;
502: hr_utility.raise_error ;
503:
504: END employee_super_details;

Line 501: hr_utility.set_message_token('STEP','body') ;

497: Exception
498: when others then
499: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
500: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.employee_super_details') ;
501: hr_utility.set_message_token('STEP','body') ;
502: hr_utility.raise_error ;
503:
504: END employee_super_details;
505:

Line 502: hr_utility.raise_error ;

498: when others then
499: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
500: hr_utility.set_message_token('PROCEDURE', 'pay_au_sgc_pkg.employee_super_details') ;
501: hr_utility.set_message_token('STEP','body') ;
502: hr_utility.raise_error ;
503:
504: END employee_super_details;
505:
506: