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

Line 372: hr_utility.set_location('Entering '||l_proc,10);

368: rec_cert_details csr_cert_details%rowtype;
369: l_ass_act_id pay_assignment_actions.assignment_action_id%type;
370: rec_other_ass_actions csr_other_ass_actions%rowtype;
371: begin
372: hr_utility.set_location('Entering '||l_proc,10);
373: hr_utility.set_location('p_bgid :'||p_bgid,10);
374: hr_utility.set_location('p_tax_year :'||p_tax_year,10);
375: hr_utility.set_location('p_legal_entity_id :'||p_legal_entity_id,10);
376: hr_utility.set_location('p_pay_action_id :'||p_pay_action_id,10);

Line 373: hr_utility.set_location('p_bgid :'||p_bgid,10);

369: l_ass_act_id pay_assignment_actions.assignment_action_id%type;
370: rec_other_ass_actions csr_other_ass_actions%rowtype;
371: begin
372: hr_utility.set_location('Entering '||l_proc,10);
373: hr_utility.set_location('p_bgid :'||p_bgid,10);
374: hr_utility.set_location('p_tax_year :'||p_tax_year,10);
375: hr_utility.set_location('p_legal_entity_id :'||p_legal_entity_id,10);
376: hr_utility.set_location('p_pay_action_id :'||p_pay_action_id,10);
377: hr_utility.set_location('p_asg_id :'||p_asg_id,10);

Line 374: hr_utility.set_location('p_tax_year :'||p_tax_year,10);

370: rec_other_ass_actions csr_other_ass_actions%rowtype;
371: begin
372: hr_utility.set_location('Entering '||l_proc,10);
373: hr_utility.set_location('p_bgid :'||p_bgid,10);
374: hr_utility.set_location('p_tax_year :'||p_tax_year,10);
375: hr_utility.set_location('p_legal_entity_id :'||p_legal_entity_id,10);
376: hr_utility.set_location('p_pay_action_id :'||p_pay_action_id,10);
377: hr_utility.set_location('p_asg_id :'||p_asg_id,10);
378: hr_utility.set_location('p_temp_cert_no :'||p_temp_cert_no,10);

Line 375: hr_utility.set_location('p_legal_entity_id :'||p_legal_entity_id,10);

371: begin
372: hr_utility.set_location('Entering '||l_proc,10);
373: hr_utility.set_location('p_bgid :'||p_bgid,10);
374: hr_utility.set_location('p_tax_year :'||p_tax_year,10);
375: hr_utility.set_location('p_legal_entity_id :'||p_legal_entity_id,10);
376: hr_utility.set_location('p_pay_action_id :'||p_pay_action_id,10);
377: hr_utility.set_location('p_asg_id :'||p_asg_id,10);
378: hr_utility.set_location('p_temp_cert_no :'||p_temp_cert_no,10);
379: hr_utility.set_location('p_tax_cert_no :'||p_tax_cert_no,10);

Line 376: hr_utility.set_location('p_pay_action_id :'||p_pay_action_id,10);

372: hr_utility.set_location('Entering '||l_proc,10);
373: hr_utility.set_location('p_bgid :'||p_bgid,10);
374: hr_utility.set_location('p_tax_year :'||p_tax_year,10);
375: hr_utility.set_location('p_legal_entity_id :'||p_legal_entity_id,10);
376: hr_utility.set_location('p_pay_action_id :'||p_pay_action_id,10);
377: hr_utility.set_location('p_asg_id :'||p_asg_id,10);
378: hr_utility.set_location('p_temp_cert_no :'||p_temp_cert_no,10);
379: hr_utility.set_location('p_tax_cert_no :'||p_tax_cert_no,10);
380:

Line 377: hr_utility.set_location('p_asg_id :'||p_asg_id,10);

373: hr_utility.set_location('p_bgid :'||p_bgid,10);
374: hr_utility.set_location('p_tax_year :'||p_tax_year,10);
375: hr_utility.set_location('p_legal_entity_id :'||p_legal_entity_id,10);
376: hr_utility.set_location('p_pay_action_id :'||p_pay_action_id,10);
377: hr_utility.set_location('p_asg_id :'||p_asg_id,10);
378: hr_utility.set_location('p_temp_cert_no :'||p_temp_cert_no,10);
379: hr_utility.set_location('p_tax_cert_no :'||p_tax_cert_no,10);
380:
381: -- Get the assignment action for particular preprocess

Line 378: hr_utility.set_location('p_temp_cert_no :'||p_temp_cert_no,10);

374: hr_utility.set_location('p_tax_year :'||p_tax_year,10);
375: hr_utility.set_location('p_legal_entity_id :'||p_legal_entity_id,10);
376: hr_utility.set_location('p_pay_action_id :'||p_pay_action_id,10);
377: hr_utility.set_location('p_asg_id :'||p_asg_id,10);
378: hr_utility.set_location('p_temp_cert_no :'||p_temp_cert_no,10);
379: hr_utility.set_location('p_tax_cert_no :'||p_tax_cert_no,10);
380:
381: -- Get the assignment action for particular preprocess
382: open csr_ass_act_id;

Line 379: hr_utility.set_location('p_tax_cert_no :'||p_tax_cert_no,10);

375: hr_utility.set_location('p_legal_entity_id :'||p_legal_entity_id,10);
376: hr_utility.set_location('p_pay_action_id :'||p_pay_action_id,10);
377: hr_utility.set_location('p_asg_id :'||p_asg_id,10);
378: hr_utility.set_location('p_temp_cert_no :'||p_temp_cert_no,10);
379: hr_utility.set_location('p_tax_cert_no :'||p_tax_cert_no,10);
380:
381: -- Get the assignment action for particular preprocess
382: open csr_ass_act_id;
383: fetch csr_ass_act_id into l_ass_act_id;

Line 387: hr_utility.set_location('Retrieving certificate details for this preprocess',12);

383: fetch csr_ass_act_id into l_ass_act_id;
384: close csr_ass_act_id;
385:
386: -- Retrieve the archived certificate numbers/indicators for the selected assignment action
387: hr_utility.set_location('Retrieving certificate details for this preprocess',12);
388: open csr_cert_details(l_ass_act_id,p_temp_cert_no);
389: fetch csr_cert_details into rec_cert_details;
390: close csr_cert_details;
391:

Line 394: hr_utility.set_location('Selected preprocess has electronic certificate issued',14);

390: close csr_cert_details;
391:
392: -- Electronically generated certificate already exists
393: if rec_cert_details.cert_num is not null then
394: hr_utility.set_location('Selected preprocess has electronic certificate issued',14);
395: p_errmsg := 'A Electronically generated or Reissued Tax Certificate Number already exist.';
396: p_errcode := 20001;
397: return;
398: else

Line 405: hr_utility.set_location('Directive Number selected is MAIN',16);

401: --If it is main then check whether any previous main certificate is
402: --issued electronically. If not then check whether any directive present
403: --in the selected MAIN has previous Lump sum certificate electronically issued.
404: if rec_cert_details.cert_type = 'MAIN' then
405: hr_utility.set_location('Directive Number selected is MAIN',16);
406: -- Check the previous MAIN certificates if issued electronically
407: open csr_other_ass_actions('MAIN');
408: loop
409: hr_utility.set_location('Loop through the previous MAIN certificates',18);

Line 409: hr_utility.set_location('Loop through the previous MAIN certificates',18);

405: hr_utility.set_location('Directive Number selected is MAIN',16);
406: -- Check the previous MAIN certificates if issued electronically
407: open csr_other_ass_actions('MAIN');
408: loop
409: hr_utility.set_location('Loop through the previous MAIN certificates',18);
410: fetch csr_other_ass_actions into rec_other_ass_actions;
411: exit when csr_other_ass_actions%notfound;
412:
413: --Certificate number will be generated only when the IRP5/

Line 417: hr_utility.set_location('Previous preprocess has electronic certificate issued',22);

413: --Certificate number will be generated only when the IRP5/
414: --IT3A is run. If Certificate number is not null suggests
415: --electronic certificate is already issued.
416: if rec_other_ass_actions.cert_num is not null then
417: hr_utility.set_location('Previous preprocess has electronic certificate issued',22);
418: p_errmsg := 'A Electronically generated or Reissued Tax Certificate Number already exist.';
419: p_errcode := 20001;
420: close csr_other_ass_actions;
421: return;

Line 423: hr_utility.set_location('Previous preprocess has manual certificate issued',24);

419: p_errcode := 20001;
420: close csr_other_ass_actions;
421: return;
422: elsif rec_other_ass_actions.cert_ind='M' then
423: hr_utility.set_location('Previous preprocess has manual certificate issued',24);
424: update pay_action_information
425: set action_information28 ='OM'
426: where action_information_id=rec_other_ass_actions.act_inf_id;
427: end if;

Line 437: hr_utility.set_location('Check the previous Lump sums',30);

433: -- previously issued electronic lump sum certificate.
434: if rec_cert_details.directive1 is not null OR rec_cert_details.directive2 is not null
435: OR rec_cert_details.directive3 is not null
436: then
437: hr_utility.set_location('Check the previous Lump sums',30);
438: open csr_other_ass_actions('LMPSM');
439: loop
440: hr_utility.set_location('Loop through the previous LMPSM certificates',32);
441: fetch csr_other_ass_actions into rec_other_ass_actions;

Line 440: hr_utility.set_location('Loop through the previous LMPSM certificates',32);

436: then
437: hr_utility.set_location('Check the previous Lump sums',30);
438: open csr_other_ass_actions('LMPSM');
439: loop
440: hr_utility.set_location('Loop through the previous LMPSM certificates',32);
441: fetch csr_other_ass_actions into rec_other_ass_actions;
442: exit when csr_other_ass_actions%notfound;
443:
444: if ((rec_cert_details.directive1 = rec_other_ass_actions.directive1)

Line 450: hr_utility.set_location('Previous preprocess has electronic certificate issued',36);

446: (rec_cert_details.directive2 = rec_other_ass_actions.directive1)
447: OR
448: (rec_cert_details.directive3 = rec_other_ass_actions.directive1))
449: AND rec_other_ass_actions.cert_num is not null then
450: hr_utility.set_location('Previous preprocess has electronic certificate issued',36);
451: p_errmsg := 'A Electronically generated or Reissued Tax Certificate Number already exist.';
452: p_errcode := 20001;
453: close csr_other_ass_actions;
454: return;

Line 462: hr_utility.set_location('Previous preprocess has manual certificate issued',40);

458: OR
459: (rec_cert_details.directive3 = rec_other_ass_actions.directive1))
460: AND rec_other_ass_actions.cert_num is null
461: AND rec_other_ass_actions.cert_ind='M' then
462: hr_utility.set_location('Previous preprocess has manual certificate issued',40);
463: update pay_action_information
464: set action_information28 ='OM'
465: where action_information_id=rec_other_ass_actions.act_inf_id;
466: end if;

Line 477: hr_utility.set_location('Directive Number selected is LMPSM',42);

473: --previous lump sum certificate issued for same directive.
474: --If not, then check the directives in the issued main certificates, if it
475: --matches with the lump sum directive
476: else
477: hr_utility.set_location('Directive Number selected is LMPSM',42);
478: open csr_other_ass_actions('LMPSM');
479: loop
480: fetch csr_other_ass_actions into rec_other_ass_actions;
481: exit when csr_other_ass_actions%notfound;

Line 488: hr_utility.set_location('Previous preprocess has electronic certificate issued.',44);

484: --IT3A is run. If Certificate number is not null suggests
485: --electronic certificate is already issued.
486: if rec_other_ass_actions.directive1 = rec_cert_details.directive1
487: AND rec_other_ass_actions.cert_num is not null then
488: hr_utility.set_location('Previous preprocess has electronic certificate issued.',44);
489: p_errmsg := 'A Electronically generated or Reissued Tax Certificate Number already exist.';
490: p_errcode := 20001;
491: close csr_other_ass_actions;
492: return;

Line 495: hr_utility.set_location('Previous preprocess has manual certificate issued.',46);

491: close csr_other_ass_actions;
492: return;
493: elsif rec_other_ass_actions.directive1 = rec_cert_details.directive1
494: AND rec_other_ass_actions.cert_ind='M' then
495: hr_utility.set_location('Previous preprocess has manual certificate issued.',46);
496: update pay_action_information
497: set action_information28 ='OM'
498: where action_information_id=rec_other_ass_actions.act_inf_id;
499: end if;

Line 520: hr_utility.set_location('Previous preprocess has electronic certificate issued',48);

516: (rec_other_ass_actions.directive2 = rec_cert_details.directive1)
517: OR
518: (rec_other_ass_actions.directive3 = rec_cert_details.directive1))
519: AND rec_other_ass_actions.cert_num is not null then
520: hr_utility.set_location('Previous preprocess has electronic certificate issued',48);
521: p_errmsg := 'A Electronically generated or Reissued Tax Certificate Number already exist.';
522: p_errcode := 20001;
523: close csr_other_ass_actions;
524: return;

Line 536: hr_utility.set_location('Update with manual certificate details',60);

532: end if;
533: end if; -- End rec_cert_details.cert_num is not null
534:
535: --Update the Certificate Indicator and manual certificate number
536: hr_utility.set_location('Update with manual certificate details',60);
537: update pay_action_information
538: set action_information28='M', action_information29=p_tax_cert_no
539: where action_information_id=rec_cert_details.act_inf_id;
540:

Line 542: hr_utility.set_location('Committing the record',70);

538: set action_information28='M', action_information29=p_tax_cert_no
539: where action_information_id=rec_cert_details.act_inf_id;
540:
541: -- Commit the record
542: hr_utility.set_location('Committing the record',70);
543: commit;
544: p_errmsg := 'Tax Certificate Number Issued.';
545:
546: exception