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

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY pqp_gb_ad_ee AS
2: /* $Header: pqgbadee.pkb 120.14.12020000.4 2013/01/30 13:20:36 rsadhana ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: g_package varchar2(33) := 'pqp_gb_ad_ee.';
6: -----------------------------------------------------------------------------
7: -- ASG_EXPIRES
8: -- This function checks to make sure that the ASG does not expire before

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

31: effective_start_date
32: AND effective_end_date;
33:
34: EXCEPTION WHEN NO_DATA_FOUND THEN
35: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
36: hr_utility.set_message_token('PROCEDURE',
37: 'pqp_gb_ad_ee.open_cm_ele_entries');
38: hr_utility.set_message_token('STEP','7');
39: hr_utility.raise_error;

Line 36: hr_utility.set_message_token('PROCEDURE',

32: AND effective_end_date;
33:
34: EXCEPTION WHEN NO_DATA_FOUND THEN
35: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
36: hr_utility.set_message_token('PROCEDURE',
37: 'pqp_gb_ad_ee.open_cm_ele_entries');
38: hr_utility.set_message_token('STEP','7');
39: hr_utility.raise_error;
40: END;

Line 38: hr_utility.set_message_token('STEP','7');

34: EXCEPTION WHEN NO_DATA_FOUND THEN
35: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
36: hr_utility.set_message_token('PROCEDURE',
37: 'pqp_gb_ad_ee.open_cm_ele_entries');
38: hr_utility.set_message_token('STEP','7');
39: hr_utility.raise_error;
40: END;
41:
42: BEGIN

Line 39: hr_utility.raise_error;

35: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
36: hr_utility.set_message_token('PROCEDURE',
37: 'pqp_gb_ad_ee.open_cm_ele_entries');
38: hr_utility.set_message_token('STEP','7');
39: hr_utility.raise_error;
40: END;
41:
42: BEGIN
43:

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

52: and act.action_status='C')
53: AND ROWNUM = 1;
54:
55: EXCEPTION WHEN NO_DATA_FOUND THEN
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE',
58: 'pqp_gb_ad_ee.open_cm_ele_entries');
59: hr_utility.set_message_token('STEP','8');
60: hr_utility.raise_error;

Line 57: hr_utility.set_message_token('PROCEDURE',

53: AND ROWNUM = 1;
54:
55: EXCEPTION WHEN NO_DATA_FOUND THEN
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE',
58: 'pqp_gb_ad_ee.open_cm_ele_entries');
59: hr_utility.set_message_token('STEP','8');
60: hr_utility.raise_error;
61: END;

Line 59: hr_utility.set_message_token('STEP','8');

55: EXCEPTION WHEN NO_DATA_FOUND THEN
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE',
58: 'pqp_gb_ad_ee.open_cm_ele_entries');
59: hr_utility.set_message_token('STEP','8');
60: hr_utility.raise_error;
61: END;
62:
63: IF l_asg_ed < l_py_ed THEN

Line 60: hr_utility.raise_error;

56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE',
58: 'pqp_gb_ad_ee.open_cm_ele_entries');
59: hr_utility.set_message_token('STEP','8');
60: hr_utility.raise_error;
61: END;
62:
63: IF l_asg_ed < l_py_ed THEN
64: RAISE asg_expires;

Line 72: hr_utility.raise_error;

68:
69: EXCEPTION
70:
71: WHEN asg_expires THEN
72: hr_utility.raise_error;
73:
74: END asg_expires;
75: */
76: -----------------------------------------------------------------------------

Line 185: hr_utility.set_message(8303,'PQP_230531_MULT_ASG_MILE_ADJ');

181: WHEN NO_DATA_FOUND THEN
182: RETURN FALSE;
183:
184: WHEN ASG_OVERLAP THEN
185: hr_utility.set_message(8303,'PQP_230531_MULT_ASG_MILE_ADJ');
186: hr_utility.raise_error;
187:
188: END asg_overlap;
189:

Line 186: hr_utility.raise_error;

182: RETURN FALSE;
183:
184: WHEN ASG_OVERLAP THEN
185: hr_utility.set_message(8303,'PQP_230531_MULT_ASG_MILE_ADJ');
186: hr_utility.raise_error;
187:
188: END asg_overlap;
189:
190: -----------------------------------------------------------------------------

Line 439: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN

435: BEGIN
436: --
437: -- Added for GSI Bug 5472781
438: --
439: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
440: --
441: -- Check if the element entry is for a Car and Mileage element.
442: -- The entries should be opened only for these elements.
443:

Line 485: hr_utility.set_message(8303, 'PQP_230575_FUTURE_RUN_EXISTS');

481: l_chk_start_date:=TO_DATE('04/05/'||(to_char(l_ee_effdate ,'YYYY')),'MM/DD/YYYY');
482: END IF;
483: IF l_chk_effdate > l_chk_start_date THEN
484:
485: hr_utility.set_message(8303, 'PQP_230575_FUTURE_RUN_EXISTS');
486: hr_utility.raise_error;
487: END IF;
488:
489: BEGIN

Line 486: hr_utility.raise_error;

482: END IF;
483: IF l_chk_effdate > l_chk_start_date THEN
484:
485: hr_utility.set_message(8303, 'PQP_230575_FUTURE_RUN_EXISTS');
486: hr_utility.raise_error;
487: END IF;
488:
489: BEGIN
490: OPEN scr_val_cur ('Claim End Date',p_element_entry_id);

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

494: l_claim_end_date := TRUNC(l_claim_end_date);
495: l_current_year := TO_CHAR(l_claim_end_date,'RRRR');
496:
497: EXCEPTION WHEN NO_DATA_FOUND THEN
498: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
499: hr_utility.set_message_token('PROCEDURE',
500: 'pqp_gb_ad_ee.open_cm_ele_entries');
501: hr_utility.set_message_token('STEP','1');
502: hr_utility.raise_error;

Line 499: hr_utility.set_message_token('PROCEDURE',

495: l_current_year := TO_CHAR(l_claim_end_date,'RRRR');
496:
497: EXCEPTION WHEN NO_DATA_FOUND THEN
498: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
499: hr_utility.set_message_token('PROCEDURE',
500: 'pqp_gb_ad_ee.open_cm_ele_entries');
501: hr_utility.set_message_token('STEP','1');
502: hr_utility.raise_error;
503: END;

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

497: EXCEPTION WHEN NO_DATA_FOUND THEN
498: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
499: hr_utility.set_message_token('PROCEDURE',
500: 'pqp_gb_ad_ee.open_cm_ele_entries');
501: hr_utility.set_message_token('STEP','1');
502: hr_utility.raise_error;
503: END;
504:
505: BEGIN

Line 502: hr_utility.raise_error;

498: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
499: hr_utility.set_message_token('PROCEDURE',
500: 'pqp_gb_ad_ee.open_cm_ele_entries');
501: hr_utility.set_message_token('STEP','1');
502: hr_utility.raise_error;
503: END;
504:
505: BEGIN
506: OPEN vehicle_type_cur(p_element_entry_id);

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

507: FETCH vehicle_type_cur INTO l_car_type;
508: CLOSE vehicle_type_cur;
509:
510: EXCEPTION WHEN NO_DATA_FOUND THEN
511: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
512: hr_utility.set_message_token('PROCEDURE',
513: 'pqp_gb_ad_ee.open_cm_ele_entries');
514: hr_utility.set_message_token('STEP','2');
515: hr_utility.raise_error;

Line 512: hr_utility.set_message_token('PROCEDURE',

508: CLOSE vehicle_type_cur;
509:
510: EXCEPTION WHEN NO_DATA_FOUND THEN
511: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
512: hr_utility.set_message_token('PROCEDURE',
513: 'pqp_gb_ad_ee.open_cm_ele_entries');
514: hr_utility.set_message_token('STEP','2');
515: hr_utility.raise_error;
516: END;

Line 514: hr_utility.set_message_token('STEP','2');

510: EXCEPTION WHEN NO_DATA_FOUND THEN
511: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
512: hr_utility.set_message_token('PROCEDURE',
513: 'pqp_gb_ad_ee.open_cm_ele_entries');
514: hr_utility.set_message_token('STEP','2');
515: hr_utility.raise_error;
516: END;
517:
518: -- Check for overlapping ASG's

Line 515: hr_utility.raise_error;

511: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
512: hr_utility.set_message_token('PROCEDURE',
513: 'pqp_gb_ad_ee.open_cm_ele_entries');
514: hr_utility.set_message_token('STEP','2');
515: hr_utility.raise_error;
516: END;
517:
518: -- Check for overlapping ASG's
519: IF NOT asg_overlap(p_assignment_id_o

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

564: FETCH vehicle_type_cur1 INTO l_ee_vehicle_type;
565: CLOSE vehicle_type_cur1;
566:
567: EXCEPTION WHEN NO_DATA_FOUND THEN
568: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
569: hr_utility.set_message_token('PROCEDURE',
570: 'pqp_gb_ad_ee.open_cm_ele_entries');
571: hr_utility.set_message_token('STEP','3');
572: hr_utility.raise_error;

Line 569: hr_utility.set_message_token('PROCEDURE',

565: CLOSE vehicle_type_cur1;
566:
567: EXCEPTION WHEN NO_DATA_FOUND THEN
568: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
569: hr_utility.set_message_token('PROCEDURE',
570: 'pqp_gb_ad_ee.open_cm_ele_entries');
571: hr_utility.set_message_token('STEP','3');
572: hr_utility.raise_error;
573: END;

Line 571: hr_utility.set_message_token('STEP','3');

567: EXCEPTION WHEN NO_DATA_FOUND THEN
568: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
569: hr_utility.set_message_token('PROCEDURE',
570: 'pqp_gb_ad_ee.open_cm_ele_entries');
571: hr_utility.set_message_token('STEP','3');
572: hr_utility.raise_error;
573: END;
574:
575: -- Code commented out to open both Essential and Casual vehicles OR

Line 572: hr_utility.raise_error;

568: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
569: hr_utility.set_message_token('PROCEDURE',
570: 'pqp_gb_ad_ee.open_cm_ele_entries');
571: hr_utility.set_message_token('STEP','3');
572: hr_utility.raise_error;
573: END;
574:
575: -- Code commented out to open both Essential and Casual vehicles OR
576: -- Primary and Secondary vehicles.

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

586: FETCH scr_val_cur1 INTO l_paye_taxable;
587: CLOSE scr_val_cur1;
588:
589: EXCEPTION WHEN NO_DATA_FOUND THEN
590: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
591: hr_utility.set_message_token('PROCEDURE',
592: 'pqp_gb_ad_ee.open_cm_ele_entries');
593: hr_utility.set_message_token('STEP','4');
594: hr_utility.raise_error;

Line 591: hr_utility.set_message_token('PROCEDURE',

587: CLOSE scr_val_cur1;
588:
589: EXCEPTION WHEN NO_DATA_FOUND THEN
590: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
591: hr_utility.set_message_token('PROCEDURE',
592: 'pqp_gb_ad_ee.open_cm_ele_entries');
593: hr_utility.set_message_token('STEP','4');
594: hr_utility.raise_error;
595: END;*/

Line 593: hr_utility.set_message_token('STEP','4');

589: EXCEPTION WHEN NO_DATA_FOUND THEN
590: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
591: hr_utility.set_message_token('PROCEDURE',
592: 'pqp_gb_ad_ee.open_cm_ele_entries');
593: hr_utility.set_message_token('STEP','4');
594: hr_utility.raise_error;
595: END;*/
596:
597:

Line 594: hr_utility.raise_error;

590: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
591: hr_utility.set_message_token('PROCEDURE',
592: 'pqp_gb_ad_ee.open_cm_ele_entries');
593: hr_utility.set_message_token('STEP','4');
594: hr_utility.raise_error;
595: END;*/
596:
597:
598: -- IF l_paye_taxable <> 'Y' THEN

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

609: (l_ee_scr_val,1,11),'RRRR/MM/DD');
610: l_ee_claim_end_date := TRUNC(l_ee_claim_end_date);
611:
612: EXCEPTION WHEN NO_DATA_FOUND THEN
613: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
614: hr_utility.set_message_token('PROCEDURE',
615: 'pqp_gb_ad_ee.open_cm_ele_entries');
616: hr_utility.set_message_token('STEP','5');
617: hr_utility.raise_error;

Line 614: hr_utility.set_message_token('PROCEDURE',

610: l_ee_claim_end_date := TRUNC(l_ee_claim_end_date);
611:
612: EXCEPTION WHEN NO_DATA_FOUND THEN
613: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
614: hr_utility.set_message_token('PROCEDURE',
615: 'pqp_gb_ad_ee.open_cm_ele_entries');
616: hr_utility.set_message_token('STEP','5');
617: hr_utility.raise_error;
618: END;

Line 616: hr_utility.set_message_token('STEP','5');

612: EXCEPTION WHEN NO_DATA_FOUND THEN
613: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
614: hr_utility.set_message_token('PROCEDURE',
615: 'pqp_gb_ad_ee.open_cm_ele_entries');
616: hr_utility.set_message_token('STEP','5');
617: hr_utility.raise_error;
618: END;
619:
620:

Line 617: hr_utility.raise_error;

613: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
614: hr_utility.set_message_token('PROCEDURE',
615: 'pqp_gb_ad_ee.open_cm_ele_entries');
616: hr_utility.set_message_token('STEP','5');
617: hr_utility.raise_error;
618: END;
619:
620:
621: -- Check if the claim end date falls in the fiscal yr.

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

633: effective_start_date
634: AND effective_end_date;
635:
636: EXCEPTION WHEN NO_DATA_FOUND THEN
637: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
638: hr_utility.set_message_token('PROCEDURE',
639: 'pqp_gb_ad_ee.open_cm_ele_entries');
640: hr_utility.set_message_token('STEP','6');
641: hr_utility.raise_error;

Line 638: hr_utility.set_message_token('PROCEDURE',

634: AND effective_end_date;
635:
636: EXCEPTION WHEN NO_DATA_FOUND THEN
637: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
638: hr_utility.set_message_token('PROCEDURE',
639: 'pqp_gb_ad_ee.open_cm_ele_entries');
640: hr_utility.set_message_token('STEP','6');
641: hr_utility.raise_error;
642: END;

Line 640: hr_utility.set_message_token('STEP','6');

636: EXCEPTION WHEN NO_DATA_FOUND THEN
637: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
638: hr_utility.set_message_token('PROCEDURE',
639: 'pqp_gb_ad_ee.open_cm_ele_entries');
640: hr_utility.set_message_token('STEP','6');
641: hr_utility.raise_error;
642: END;
643:
644: -- Cannot call the API as it can go in an infinite loop.

Line 641: hr_utility.raise_error;

637: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
638: hr_utility.set_message_token('PROCEDURE',
639: 'pqp_gb_ad_ee.open_cm_ele_entries');
640: hr_utility.set_message_token('STEP','6');
641: hr_utility.raise_error;
642: END;
643:
644: -- Cannot call the API as it can go in an infinite loop.
645: -- Manually update the effective_end_date to

Line 686: END IF; -- hr_utility.chk_product_install('Oracle Human Resources', 'GB')

682: ELSE
683: -- No Car and Mileage entries found . No action required.
684: CLOSE chk_cur;
685: END IF; -- Check if the entries are for C and M elements
686: END IF; -- hr_utility.chk_product_install('Oracle Human Resources', 'GB')
687: /*EXCEPTION WHEN OTHERS THEN
688: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
689: hr_utility.set_message_token('PROCEDURE','pqp_gb_ad_ee.open_cm_ele_entries');
690: hr_utility.set_message_token('STEP','7');

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

684: CLOSE chk_cur;
685: END IF; -- Check if the entries are for C and M elements
686: END IF; -- hr_utility.chk_product_install('Oracle Human Resources', 'GB')
687: /*EXCEPTION WHEN OTHERS THEN
688: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
689: hr_utility.set_message_token('PROCEDURE','pqp_gb_ad_ee.open_cm_ele_entries');
690: hr_utility.set_message_token('STEP','7');
691: hr_utility.raise_error;
692: */

Line 689: hr_utility.set_message_token('PROCEDURE','pqp_gb_ad_ee.open_cm_ele_entries');

685: END IF; -- Check if the entries are for C and M elements
686: END IF; -- hr_utility.chk_product_install('Oracle Human Resources', 'GB')
687: /*EXCEPTION WHEN OTHERS THEN
688: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
689: hr_utility.set_message_token('PROCEDURE','pqp_gb_ad_ee.open_cm_ele_entries');
690: hr_utility.set_message_token('STEP','7');
691: hr_utility.raise_error;
692: */
693:

Line 690: hr_utility.set_message_token('STEP','7');

686: END IF; -- hr_utility.chk_product_install('Oracle Human Resources', 'GB')
687: /*EXCEPTION WHEN OTHERS THEN
688: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
689: hr_utility.set_message_token('PROCEDURE','pqp_gb_ad_ee.open_cm_ele_entries');
690: hr_utility.set_message_token('STEP','7');
691: hr_utility.raise_error;
692: */
693:
694: END;

Line 691: hr_utility.raise_error;

687: /*EXCEPTION WHEN OTHERS THEN
688: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
689: hr_utility.set_message_token('PROCEDURE','pqp_gb_ad_ee.open_cm_ele_entries');
690: hr_utility.set_message_token('STEP','7');
691: hr_utility.raise_error;
692: */
693:
694: END;
695:

Line 814: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN

810: BEGIN
811: --
812: -- Added for GSI Bug 5472781
813: --
814: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
815: --
816: l_ele_type :=NULL;
817: l_term :='N';
818: l_exist:='N';

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

817: l_term :='N';
818: l_exist:='N';
819:
820: IF g_debug then
821: hr_utility.set_location('Entering:'|| l_proc, 10);
822: END IF;
823: --Check if the element is Car and Mileage element
824: OPEN c_ele_type (p_element_type_id);
825: FETCH c_ele_type INTO l_ele_type;

Line 829: hr_utility.set_location('Leaving c_ele_type :'|| l_proc, 20);

825: FETCH c_ele_type INTO l_ele_type;
826: CLOSE c_ele_type;
827:
828: IF g_debug then
829: hr_utility.set_location('Leaving c_ele_type :'|| l_proc, 20);
830: END IF;
831: IF l_ele_type IS NOT NULL THEN
832: --Check if employee is terminated.
833: OPEN c_term;

Line 838: hr_utility.set_location('Leaving c_term :'|| l_proc, 30);

834: FETCH c_term INTO l_term;
835: CLOSE c_term;
836:
837: IF g_debug then
838: hr_utility.set_location('Leaving c_term :'|| l_proc, 30);
839: END IF;
840: IF l_term ='Y' THEN
841: --Get element link info
842: IF g_debug then

Line 843: hr_utility.set_location('Terminated :'|| l_proc, 50);

839: END IF;
840: IF l_term ='Y' THEN
841: --Get element link info
842: IF g_debug then
843: hr_utility.set_location('Terminated :'|| l_proc, 50);
844: END IF;
845:
846: OPEN c_element_details;
847: FETCH c_element_details INTO l_element_details;

Line 851: hr_utility.set_location('Link :'||l_element_details.element_link_id

847: FETCH c_element_details INTO l_element_details;
848: CLOSE c_element_details;
849:
850: IF g_debug then
851: hr_utility.set_location('Link :'||l_element_details.element_link_id
852: || l_proc, 40);
853: END IF;
854:
855: ---Check if the entry already esists

Line 861: hr_utility.set_location('Entry Exists :' || l_proc, 50);

857: FETCH c_entry_exist INTO l_exist;
858: CLOSE c_entry_exist;
859: IF l_exist <> 'Y' THEN
860: IF g_debug then
861: hr_utility.set_location('Entry Exists :' || l_proc, 50);
862: END IF;
863: BEGIN
864: --Create entry
865: pay_element_entry_api.create_element_entry

Line 890: hr_utility.set_location('Leaving :' || l_proc, 60);

886:
887: END IF;
888:
889: IF g_debug then
890: hr_utility.set_location('Leaving :' || l_proc, 60);
891: END IF;
892: END IF; -- hr_utility.chk_product_install('Oracle Human Resources', 'GB')
893: END create_term_ele_entries;
894:

Line 892: END IF; -- hr_utility.chk_product_install('Oracle Human Resources', 'GB')

888:
889: IF g_debug then
890: hr_utility.set_location('Leaving :' || l_proc, 60);
891: END IF;
892: END IF; -- hr_utility.chk_product_install('Oracle Human Resources', 'GB')
893: END create_term_ele_entries;
894:
895: --For bug 7013325
896: -----------------------------------------------------------------------------

Line 1072: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.update_ass_dff_col',10);

1068: --
1069:
1070: BEGIN
1071:
1072: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.update_ass_dff_col',10);
1073: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1074: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1075: hr_utility.set_location('p_assignment_id :' ||p_assignment_id,10);
1076: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);

Line 1073: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);

1069:
1070: BEGIN
1071:
1072: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.update_ass_dff_col',10);
1073: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1074: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1075: hr_utility.set_location('p_assignment_id :' ||p_assignment_id,10);
1076: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);
1077:

Line 1074: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);

1070: BEGIN
1071:
1072: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.update_ass_dff_col',10);
1073: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1074: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1075: hr_utility.set_location('p_assignment_id :' ||p_assignment_id,10);
1076: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);
1077:
1078: --Get current assignment details

Line 1075: hr_utility.set_location('p_assignment_id :' ||p_assignment_id,10);

1071:
1072: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.update_ass_dff_col',10);
1073: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1074: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1075: hr_utility.set_location('p_assignment_id :' ||p_assignment_id,10);
1076: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);
1077:
1078: --Get current assignment details
1079: OPEN csr_get_curr_asg_dtls;

Line 1076: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);

1072: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.update_ass_dff_col',10);
1073: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1074: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1075: hr_utility.set_location('p_assignment_id :' ||p_assignment_id,10);
1076: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);
1077:
1078: --Get current assignment details
1079: OPEN csr_get_curr_asg_dtls;
1080: FETCH csr_get_curr_asg_dtls INTO l_rec_curr_asg_dtls;

Line 1083: hr_utility.set_location('Emp Context :' ||l_rec_curr_asg_dtls.ass_attribute_category,11);

1079: OPEN csr_get_curr_asg_dtls;
1080: FETCH csr_get_curr_asg_dtls INTO l_rec_curr_asg_dtls;
1081: CLOSE csr_get_curr_asg_dtls;
1082:
1083: hr_utility.set_location('Emp Context :' ||l_rec_curr_asg_dtls.ass_attribute_category,11);
1084: hr_utility.set_location('Emp Category :' ||l_rec_curr_asg_dtls.employment_category,11);
1085: hr_utility.set_location('Business Group :' ||l_rec_curr_asg_dtls.business_group_id,11);
1086: hr_utility.set_location('Effective Start date :' ||l_rec_curr_asg_dtls.effective_start_date,11);
1087: hr_utility.set_location('Effective End date :' ||l_rec_curr_asg_dtls.effective_end_date,11);

Line 1084: hr_utility.set_location('Emp Category :' ||l_rec_curr_asg_dtls.employment_category,11);

1080: FETCH csr_get_curr_asg_dtls INTO l_rec_curr_asg_dtls;
1081: CLOSE csr_get_curr_asg_dtls;
1082:
1083: hr_utility.set_location('Emp Context :' ||l_rec_curr_asg_dtls.ass_attribute_category,11);
1084: hr_utility.set_location('Emp Category :' ||l_rec_curr_asg_dtls.employment_category,11);
1085: hr_utility.set_location('Business Group :' ||l_rec_curr_asg_dtls.business_group_id,11);
1086: hr_utility.set_location('Effective Start date :' ||l_rec_curr_asg_dtls.effective_start_date,11);
1087: hr_utility.set_location('Effective End date :' ||l_rec_curr_asg_dtls.effective_end_date,11);
1088:

Line 1085: hr_utility.set_location('Business Group :' ||l_rec_curr_asg_dtls.business_group_id,11);

1081: CLOSE csr_get_curr_asg_dtls;
1082:
1083: hr_utility.set_location('Emp Context :' ||l_rec_curr_asg_dtls.ass_attribute_category,11);
1084: hr_utility.set_location('Emp Category :' ||l_rec_curr_asg_dtls.employment_category,11);
1085: hr_utility.set_location('Business Group :' ||l_rec_curr_asg_dtls.business_group_id,11);
1086: hr_utility.set_location('Effective Start date :' ||l_rec_curr_asg_dtls.effective_start_date,11);
1087: hr_utility.set_location('Effective End date :' ||l_rec_curr_asg_dtls.effective_end_date,11);
1088:
1089: --Check if element is Nuvos or Partnership

Line 1086: hr_utility.set_location('Effective Start date :' ||l_rec_curr_asg_dtls.effective_start_date,11);

1082:
1083: hr_utility.set_location('Emp Context :' ||l_rec_curr_asg_dtls.ass_attribute_category,11);
1084: hr_utility.set_location('Emp Category :' ||l_rec_curr_asg_dtls.employment_category,11);
1085: hr_utility.set_location('Business Group :' ||l_rec_curr_asg_dtls.business_group_id,11);
1086: hr_utility.set_location('Effective Start date :' ||l_rec_curr_asg_dtls.effective_start_date,11);
1087: hr_utility.set_location('Effective End date :' ||l_rec_curr_asg_dtls.effective_end_date,11);
1088:
1089: --Check if element is Nuvos or Partnership
1090: For rec_get_nuv_part_elements in csr_get_nuv_part_elements(l_rec_curr_asg_dtls.business_group_id)

Line 1087: hr_utility.set_location('Effective End date :' ||l_rec_curr_asg_dtls.effective_end_date,11);

1083: hr_utility.set_location('Emp Context :' ||l_rec_curr_asg_dtls.ass_attribute_category,11);
1084: hr_utility.set_location('Emp Category :' ||l_rec_curr_asg_dtls.employment_category,11);
1085: hr_utility.set_location('Business Group :' ||l_rec_curr_asg_dtls.business_group_id,11);
1086: hr_utility.set_location('Effective Start date :' ||l_rec_curr_asg_dtls.effective_start_date,11);
1087: hr_utility.set_location('Effective End date :' ||l_rec_curr_asg_dtls.effective_end_date,11);
1088:
1089: --Check if element is Nuvos or Partnership
1090: For rec_get_nuv_part_elements in csr_get_nuv_part_elements(l_rec_curr_asg_dtls.business_group_id)
1091: Loop

Line 1095: hr_utility.set_location('Element is a Nuvos or Partnership element',12);

1091: Loop
1092: IF rec_get_nuv_part_elements.pcv_information1 = p_element_type_id
1093: THEN
1094: l_nuv_part_flag := 'Y';
1095: hr_utility.set_location('Element is a Nuvos or Partnership element',12);
1096: hr_utility.set_location('Element_type_id :'
1097: ||rec_get_nuv_part_elements.pcv_information1,12);
1098: Exit;
1099: End IF;

Line 1096: hr_utility.set_location('Element_type_id :'

1092: IF rec_get_nuv_part_elements.pcv_information1 = p_element_type_id
1093: THEN
1094: l_nuv_part_flag := 'Y';
1095: hr_utility.set_location('Element is a Nuvos or Partnership element',12);
1096: hr_utility.set_location('Element_type_id :'
1097: ||rec_get_nuv_part_elements.pcv_information1,12);
1098: Exit;
1099: End IF;
1100: End Loop;

Line 1110: hr_utility.set_location('Mapped Context is :'

1106: OPEN csr_get_mapped_context(l_rec_curr_asg_dtls.business_group_id);
1107: FETCH csr_get_mapped_context INTO l_rec_get_mapped_context;
1108: CLOSE csr_get_mapped_context;
1109:
1110: hr_utility.set_location('Mapped Context is :'
1111: ||l_rec_get_mapped_context.pcv_information1,13);
1112:
1113: IF(l_rec_get_mapped_context.pcv_information3 IS NOT NULL)
1114: THEN

Line 1115: hr_utility.set_location('DFF Segment is mapped on config page',13);

1111: ||l_rec_get_mapped_context.pcv_information1,13);
1112:
1113: IF(l_rec_get_mapped_context.pcv_information3 IS NOT NULL)
1114: THEN
1115: hr_utility.set_location('DFF Segment is mapped on config page',13);
1116: hr_utility.set_location('Mapped segment column is :'
1117: ||l_rec_get_mapped_context.pcv_information3,13);
1118:
1119: --check if this is a penserver employee

Line 1116: hr_utility.set_location('Mapped segment column is :'

1112:
1113: IF(l_rec_get_mapped_context.pcv_information3 IS NOT NULL)
1114: THEN
1115: hr_utility.set_location('DFF Segment is mapped on config page',13);
1116: hr_utility.set_location('Mapped segment column is :'
1117: ||l_rec_get_mapped_context.pcv_information3,13);
1118:
1119: --check if this is a penserver employee
1120: --For bug 7202378:Logic modifed for checking penserver emp

Line 1127: hr_utility.set_location('l_segment_val_query: '||l_segment_val_query,14);

1123: 'where assignment_id = '||p_assignment_id||' '||
1124: 'and to_date('''||TO_CHAR(p_effective_start_date,'dd/mm/yyyy')||''',''dd/mm/yyyy'') between effective_start_date'||' '||
1125: 'and effective_end_date';
1126:
1127: hr_utility.set_location('l_segment_val_query: '||l_segment_val_query,14);
1128:
1129: OPEN c_get_segment_val FOR l_segment_val_query;
1130: FETCH c_get_segment_val INTO l_segment_value;
1131: CLOSE c_get_segment_val;

Line 1135: hr_utility.set_location('Segment field value is NOT NULL', 14);

1131: CLOSE c_get_segment_val;
1132:
1133: IF l_segment_value IS NOT NULL
1134: THEN
1135: hr_utility.set_location('Segment field value is NOT NULL', 14);
1136: hr_utility.set_location('l_segment_value'||l_segment_value,14);
1137:
1138: IF l_rec_get_mapped_context.pcv_information1 = 'Global Data Elements'
1139: THEN

Line 1136: hr_utility.set_location('l_segment_value'||l_segment_value,14);

1132:
1133: IF l_segment_value IS NOT NULL
1134: THEN
1135: hr_utility.set_location('Segment field value is NOT NULL', 14);
1136: hr_utility.set_location('l_segment_value'||l_segment_value,14);
1137:
1138: IF l_rec_get_mapped_context.pcv_information1 = 'Global Data Elements'
1139: THEN
1140: l_penserv_emp := 'Y';

Line 1155: hr_utility.set_location('This is a penserver employee',14);

1151: END IF;
1152:
1153: IF l_penserv_emp = 'Y'
1154: THEN
1155: hr_utility.set_location('This is a penserver employee',14);
1156: hr_utility.set_location('Mapped Context is :'
1157: ||l_rec_get_mapped_context.pcv_information1,14);
1158:
1159: --Check if employee is Casual

Line 1156: hr_utility.set_location('Mapped Context is :'

1152:
1153: IF l_penserv_emp = 'Y'
1154: THEN
1155: hr_utility.set_location('This is a penserver employee',14);
1156: hr_utility.set_location('Mapped Context is :'
1157: ||l_rec_get_mapped_context.pcv_information1,14);
1158:
1159: --Check if employee is Casual
1160: For rec_get_casual_emp_cate in csr_get_casual_emp_cate(l_rec_curr_asg_dtls.business_group_id)

Line 1165: hr_utility.set_location('Employee is Casual',15);

1161: Loop
1162: IF rec_get_casual_emp_cate.pcv_information1 = l_rec_curr_asg_dtls.employment_category
1163: THEN
1164: l_emp_is_casual_flag := 'Y';
1165: hr_utility.set_location('Employee is Casual',15);
1166: hr_utility.set_location('Employment Categoty :'
1167: ||rec_get_casual_emp_cate.pcv_information1,15);
1168: Exit;
1169: End IF;

Line 1166: hr_utility.set_location('Employment Categoty :'

1162: IF rec_get_casual_emp_cate.pcv_information1 = l_rec_curr_asg_dtls.employment_category
1163: THEN
1164: l_emp_is_casual_flag := 'Y';
1165: hr_utility.set_location('Employee is Casual',15);
1166: hr_utility.set_location('Employment Categoty :'
1167: ||rec_get_casual_emp_cate.pcv_information1,15);
1168: Exit;
1169: End IF;
1170: End Loop;

Line 1184: hr_utility.set_location('l_prior_asg_dtls_query: '||l_prior_asg_dtls_query,16);

1180: 'from per_all_assignments_f'||' '||
1181: 'where assignment_id = '||p_assignment_id||' '||
1182: 'and to_date('''||TO_CHAR(p_effective_start_date,'dd/mm/yyyy')||''',''dd/mm/yyyy'') > effective_start_date';
1183:
1184: hr_utility.set_location('l_prior_asg_dtls_query: '||l_prior_asg_dtls_query,16);
1185:
1186: OPEN c_get_prior_asg_dtls FOR l_prior_asg_dtls_query;
1187: Loop
1188: FETCH c_get_prior_asg_dtls INTO l_prior_emp_cate, l_prior_ass_att_cate, l_prior_ass_att_xx;

Line 1190: hr_utility.set_location('l_prior_emp_cate: '||l_prior_emp_cate,16);

1186: OPEN c_get_prior_asg_dtls FOR l_prior_asg_dtls_query;
1187: Loop
1188: FETCH c_get_prior_asg_dtls INTO l_prior_emp_cate, l_prior_ass_att_cate, l_prior_ass_att_xx;
1189: EXIT WHEN c_get_prior_asg_dtls%NOTFOUND;
1190: hr_utility.set_location('l_prior_emp_cate: '||l_prior_emp_cate,16);
1191: hr_utility.set_location('l_prior_ass_att_cate: '||l_prior_ass_att_cate,16);
1192: hr_utility.set_location('l_prior_ass_att_xx: '||l_prior_ass_att_xx,16);
1193:
1194: For rec_get_non_casual_emp_cate IN csr_get_non_casual_emp_cate(l_rec_curr_asg_dtls.business_group_id)

Line 1191: hr_utility.set_location('l_prior_ass_att_cate: '||l_prior_ass_att_cate,16);

1187: Loop
1188: FETCH c_get_prior_asg_dtls INTO l_prior_emp_cate, l_prior_ass_att_cate, l_prior_ass_att_xx;
1189: EXIT WHEN c_get_prior_asg_dtls%NOTFOUND;
1190: hr_utility.set_location('l_prior_emp_cate: '||l_prior_emp_cate,16);
1191: hr_utility.set_location('l_prior_ass_att_cate: '||l_prior_ass_att_cate,16);
1192: hr_utility.set_location('l_prior_ass_att_xx: '||l_prior_ass_att_xx,16);
1193:
1194: For rec_get_non_casual_emp_cate IN csr_get_non_casual_emp_cate(l_rec_curr_asg_dtls.business_group_id)
1195: Loop

Line 1192: hr_utility.set_location('l_prior_ass_att_xx: '||l_prior_ass_att_xx,16);

1188: FETCH c_get_prior_asg_dtls INTO l_prior_emp_cate, l_prior_ass_att_cate, l_prior_ass_att_xx;
1189: EXIT WHEN c_get_prior_asg_dtls%NOTFOUND;
1190: hr_utility.set_location('l_prior_emp_cate: '||l_prior_emp_cate,16);
1191: hr_utility.set_location('l_prior_ass_att_cate: '||l_prior_ass_att_cate,16);
1192: hr_utility.set_location('l_prior_ass_att_xx: '||l_prior_ass_att_xx,16);
1193:
1194: For rec_get_non_casual_emp_cate IN csr_get_non_casual_emp_cate(l_rec_curr_asg_dtls.business_group_id)
1195: Loop
1196: IF l_prior_emp_cate = rec_get_non_casual_emp_cate.pcv_information1

Line 1203: hr_utility.set_location('Employee was a non casual earlier',16);

1199: THEN
1200: IF l_gde_context_flag = 'Y'
1201: THEN
1202: l_emp_prior_non_casual_flag := 'Y';
1203: hr_utility.set_location('Employee was a non casual earlier',16);
1204: hr_utility.set_location('Prior Employment Categoty :'
1205: ||l_prior_emp_cate,16);
1206: Exit;
1207: ELSE

Line 1204: hr_utility.set_location('Prior Employment Categoty :'

1200: IF l_gde_context_flag = 'Y'
1201: THEN
1202: l_emp_prior_non_casual_flag := 'Y';
1203: hr_utility.set_location('Employee was a non casual earlier',16);
1204: hr_utility.set_location('Prior Employment Categoty :'
1205: ||l_prior_emp_cate,16);
1206: Exit;
1207: ELSE
1208: IF l_prior_ass_att_cate = l_rec_get_mapped_context.pcv_information1

Line 1211: hr_utility.set_location('Employee was a non casual earlier',16);

1207: ELSE
1208: IF l_prior_ass_att_cate = l_rec_get_mapped_context.pcv_information1
1209: THEN
1210: l_emp_prior_non_casual_flag := 'Y';
1211: hr_utility.set_location('Employee was a non casual earlier',16);
1212: hr_utility.set_location('Prior Employment Categoty :'
1213: ||l_prior_emp_cate,16);
1214: Exit;
1215: END IF;

Line 1212: hr_utility.set_location('Prior Employment Categoty :'

1208: IF l_prior_ass_att_cate = l_rec_get_mapped_context.pcv_information1
1209: THEN
1210: l_emp_prior_non_casual_flag := 'Y';
1211: hr_utility.set_location('Employee was a non casual earlier',16);
1212: hr_utility.set_location('Prior Employment Categoty :'
1213: ||l_prior_emp_cate,16);
1214: Exit;
1215: END IF;
1216: END IF; --end of l_gde_context_flag

Line 1238: hr_utility.set_location('Employee was a non casual earlier',16);

1234: THEN
1235: IF rec_get_prior_asg_dtls.ass_attribute_category = l_rec_get_mapped_context.pcv_information1
1236: THEN
1237: l_emp_prior_non_casual_flag := 'Y';
1238: hr_utility.set_location('Employee was a non casual earlier',16);
1239: hr_utility.set_location('Prior Employment Categoty :'
1240: ||rec_get_prior_asg_dtls.employment_category,16);
1241: Exit;
1242: END IF;

Line 1239: hr_utility.set_location('Prior Employment Categoty :'

1235: IF rec_get_prior_asg_dtls.ass_attribute_category = l_rec_get_mapped_context.pcv_information1
1236: THEN
1237: l_emp_prior_non_casual_flag := 'Y';
1238: hr_utility.set_location('Employee was a non casual earlier',16);
1239: hr_utility.set_location('Prior Employment Categoty :'
1240: ||rec_get_prior_asg_dtls.employment_category,16);
1241: Exit;
1242: END IF;
1243: End IF;

Line 1261: hr_utility.set_location('Casual start date :'||l_get_casual_asg_start_dt,17);

1257: OPEN csr_get_casual_asg_start_dt(l_rec_curr_asg_dtls.employment_category);
1258: FETCH csr_get_casual_asg_start_dt INTO l_get_casual_asg_start_dt;
1259: CLOSE csr_get_casual_asg_start_dt;
1260:
1261: hr_utility.set_location('Casual start date :'||l_get_casual_asg_start_dt,17);
1262:
1263: For rec_get_ele_type_since_casual in csr_get_ele_type_since_casual(l_get_casual_asg_start_dt)
1264: Loop
1265: For rec_get_nuv_part_elements in csr_get_nuv_part_elements(l_rec_curr_asg_dtls.business_group_id)

Line 1270: hr_utility.set_location('This is not the first element for this Casual Employee',17);

1266: Loop
1267: IF rec_get_nuv_part_elements.pcv_information1 = rec_get_ele_type_since_casual.element_type_id
1268: THEN
1269: l_prior_nuv_part_flag := 'Y';
1270: hr_utility.set_location('This is not the first element for this Casual Employee',17);
1271: hr_utility.set_location('Element_type_id :'
1272: ||rec_get_nuv_part_elements.pcv_information1,17);
1273: Exit;
1274: End IF;

Line 1271: hr_utility.set_location('Element_type_id :'

1267: IF rec_get_nuv_part_elements.pcv_information1 = rec_get_ele_type_since_casual.element_type_id
1268: THEN
1269: l_prior_nuv_part_flag := 'Y';
1270: hr_utility.set_location('This is not the first element for this Casual Employee',17);
1271: hr_utility.set_location('Element_type_id :'
1272: ||rec_get_nuv_part_elements.pcv_information1,17);
1273: Exit;
1274: End IF;
1275: End Loop;

Line 1291: hr_utility.set_location('l_query: '||l_query,18);

1287: 'where assignment_id = '||p_assignment_id||' '||
1288: 'and to_date('''||TO_CHAR(p_effective_start_date,'dd/mm/yyyy')||''',''dd/mm/yyyy'') between effective_start_date'||' '||
1289: 'and effective_end_date';
1290:
1291: hr_utility.set_location('l_query: '||l_query,18);
1292:
1293: OPEN c_get_dff_val FOR l_query;
1294: FETCH c_get_dff_val INTO l_value;
1295: CLOSE c_get_dff_val;

Line 1299: hr_utility.set_location('DFF field value is NULL', 19);

1295: CLOSE c_get_dff_val;
1296:
1297: IF l_value IS NULL
1298: THEN
1299: hr_utility.set_location('DFF field value is NULL', 19);
1300: hr_utility.set_location('l_value'||l_value,18);
1301:
1302: --Decide the mode
1303: IF p_effective_start_date = l_rec_curr_asg_dtls.effective_start_date

Line 1300: hr_utility.set_location('l_value'||l_value,18);

1296:
1297: IF l_value IS NULL
1298: THEN
1299: hr_utility.set_location('DFF field value is NULL', 19);
1300: hr_utility.set_location('l_value'||l_value,18);
1301:
1302: --Decide the mode
1303: IF p_effective_start_date = l_rec_curr_asg_dtls.effective_start_date
1304: THEN

Line 1305: hr_utility.set_location('Call update asg API in correction mode', 19);

1301:
1302: --Decide the mode
1303: IF p_effective_start_date = l_rec_curr_asg_dtls.effective_start_date
1304: THEN
1305: hr_utility.set_location('Call update asg API in correction mode', 19);
1306: l_call_mode := 'CORRECTION';
1307: ELSIF l_rec_curr_asg_dtls.effective_end_date < hr_general.end_of_time
1308: THEN
1309: hr_utility.set_location('Call update asg API in update_change_insert mode', 20);

Line 1309: hr_utility.set_location('Call update asg API in update_change_insert mode', 20);

1305: hr_utility.set_location('Call update asg API in correction mode', 19);
1306: l_call_mode := 'CORRECTION';
1307: ELSIF l_rec_curr_asg_dtls.effective_end_date < hr_general.end_of_time
1308: THEN
1309: hr_utility.set_location('Call update asg API in update_change_insert mode', 20);
1310: l_call_mode := 'UPDATE_CHANGE_INSERT';
1311: ELSE
1312: hr_utility.set_location('Call update asg API in update mode', 19);
1313: l_call_mode := 'UPDATE';

Line 1312: hr_utility.set_location('Call update asg API in update mode', 19);

1308: THEN
1309: hr_utility.set_location('Call update asg API in update_change_insert mode', 20);
1310: l_call_mode := 'UPDATE_CHANGE_INSERT';
1311: ELSE
1312: hr_utility.set_location('Call update asg API in update mode', 19);
1313: l_call_mode := 'UPDATE';
1314: END IF; --End of decide the mode
1315:
1316: --Decide DFF column values

Line 1438: hr_utility.set_location('Invalid DFF segment mapped to penserver', 20);

1434: THEN
1435: l_rec_curr_asg_dtls.ass_attribute30 := TO_CHAR(p_effective_start_date,'dd-Mon-yy');
1436:
1437: ELSE
1438: hr_utility.set_location('Invalid DFF segment mapped to penserver', 20);
1439: END IF;
1440:
1441:
1442: l_object_version_number := l_rec_curr_asg_dtls.object_version_number;

Line 1495: hr_utility.set_location('Update of assignment complete',21);

1491: ,p_other_manager_warning => l_other_manager_warning
1492: ,p_hourly_salaried_warning => l_hourly_salaried_warning
1493: );
1494:
1495: hr_utility.set_location('Update of assignment complete',21);
1496: hr_utility.set_location('l_effective_start_date :'||l_effective_start_date,21);
1497: hr_utility.set_location('l_effective_end_date :'||l_effective_end_date,21);
1498:
1499:

Line 1496: hr_utility.set_location('l_effective_start_date :'||l_effective_start_date,21);

1492: ,p_hourly_salaried_warning => l_hourly_salaried_warning
1493: );
1494:
1495: hr_utility.set_location('Update of assignment complete',21);
1496: hr_utility.set_location('l_effective_start_date :'||l_effective_start_date,21);
1497: hr_utility.set_location('l_effective_end_date :'||l_effective_end_date,21);
1498:
1499:
1500: END IF; --End of if DFF segment column is null

Line 1497: hr_utility.set_location('l_effective_end_date :'||l_effective_end_date,21);

1493: );
1494:
1495: hr_utility.set_location('Update of assignment complete',21);
1496: hr_utility.set_location('l_effective_start_date :'||l_effective_start_date,21);
1497: hr_utility.set_location('l_effective_end_date :'||l_effective_end_date,21);
1498:
1499:
1500: END IF; --End of if DFF segment column is null
1501: END IF; --End of if any prior penserver element was not attached since he became casual

Line 1508: hr_utility.set_location('Leaving procedure pqp_gb_ad_ee.update_ass_dff_col',22);

1504: END IF; --End of if this is a penserver employee
1505: END IF; --End of if DFF segment mapped on config page
1506: End If; --End of if element is nuvos or partnership
1507:
1508: hr_utility.set_location('Leaving procedure pqp_gb_ad_ee.update_ass_dff_col',22);
1509: EXCEPTION
1510: WHEN OTHERS
1511: THEN
1512: hr_utility.set_location('Proc: pqp_gb_ad_ee.update_ass_dff_col: Exception Section',23);

Line 1512: hr_utility.set_location('Proc: pqp_gb_ad_ee.update_ass_dff_col: Exception Section',23);

1508: hr_utility.set_location('Leaving procedure pqp_gb_ad_ee.update_ass_dff_col',22);
1509: EXCEPTION
1510: WHEN OTHERS
1511: THEN
1512: hr_utility.set_location('Proc: pqp_gb_ad_ee.update_ass_dff_col: Exception Section',23);
1513:
1514: END UPDATE_PSI_ASS_DFF_COL;
1515:
1516:

Line 1600: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',10);

1596: l_pension varchar2(2);
1597:
1598: BEGIN
1599:
1600: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',10);
1601: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1602: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1603: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);
1604:

Line 1601: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);

1597:
1598: BEGIN
1599:
1600: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',10);
1601: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1602: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1603: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);
1604:
1605: OPEN csr_get_element;

Line 1602: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);

1598: BEGIN
1599:
1600: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',10);
1601: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1602: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1603: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);
1604:
1605: OPEN csr_get_element;
1606: FETCH csr_get_element INTO l_element_name;

Line 1603: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);

1599:
1600: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',10);
1601: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1602: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1603: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);
1604:
1605: OPEN csr_get_element;
1606: FETCH csr_get_element INTO l_element_name;
1607: CLOSE csr_get_element;

Line 1609: hr_utility.set_location('l_element_name :' ||l_element_name,11);

1605: OPEN csr_get_element;
1606: FETCH csr_get_element INTO l_element_name;
1607: CLOSE csr_get_element;
1608:
1609: hr_utility.set_location('l_element_name :' ||l_element_name,11);
1610:
1611: IF (l_element_name = 'Court Order'
1612: OR l_element_name = 'Court Order NTPP')--element is Court Order
1613: THEN

Line 1615: hr_utility.set_location('Element is Court Order',12);

1611: IF (l_element_name = 'Court Order'
1612: OR l_element_name = 'Court Order NTPP')--element is Court Order
1613: THEN
1614:
1615: hr_utility.set_location('Element is Court Order',12);
1616:
1617: OPEN csr_get_ele_ent_values;
1618: FETCH csr_get_ele_ent_values INTO l_type, l_reference, l_amount,l_override_ndr;
1619: CLOSE csr_get_ele_ent_values;

Line 1621: hr_utility.set_location('l_type :' ||l_type,12);

1617: OPEN csr_get_ele_ent_values;
1618: FETCH csr_get_ele_ent_values INTO l_type, l_reference, l_amount,l_override_ndr;
1619: CLOSE csr_get_ele_ent_values;
1620:
1621: hr_utility.set_location('l_type :' ||l_type,12);
1622: hr_utility.set_location('l_reference :' ||l_reference,12);
1623:
1624: IF (l_type = 'CCAEO'
1625: OR l_type = 'CTO'

Line 1622: hr_utility.set_location('l_reference :' ||l_reference,12);

1618: FETCH csr_get_ele_ent_values INTO l_type, l_reference, l_amount,l_override_ndr;
1619: CLOSE csr_get_ele_ent_values;
1620:
1621: hr_utility.set_location('l_type :' ||l_type,12);
1622: hr_utility.set_location('l_reference :' ||l_reference,12);
1623:
1624: IF (l_type = 'CCAEO'
1625: OR l_type = 'CTO'
1626: OR l_type = 'AEO_PERCENT'

Line 1630: hr_utility.set_location('Type is applicable',13);

1626: OR l_type = 'AEO_PERCENT'
1627: OR l_type = 'CTO_POST_APRIL_2007'
1628: OR l_type = 'CMS_DEO')
1629: THEN
1630: hr_utility.set_location('Type is applicable',13);
1631:
1632: IF l_reference IS NULL
1633: THEN
1634: hr_utility.set_location('Ref is NULL: Raise Error',14);

Line 1634: hr_utility.set_location('Ref is NULL: Raise Error',14);

1630: hr_utility.set_location('Type is applicable',13);
1631:
1632: IF l_reference IS NULL
1633: THEN
1634: hr_utility.set_location('Ref is NULL: Raise Error',14);
1635:
1636: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');
1637: hr_utility.raise_error;
1638: END IF;

Line 1636: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');

1632: IF l_reference IS NULL
1633: THEN
1634: hr_utility.set_location('Ref is NULL: Raise Error',14);
1635:
1636: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');
1637: hr_utility.raise_error;
1638: END IF;
1639: END IF;
1640:

Line 1637: hr_utility.raise_error;

1633: THEN
1634: hr_utility.set_location('Ref is NULL: Raise Error',14);
1635:
1636: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');
1637: hr_utility.raise_error;
1638: END IF;
1639: END IF;
1640:
1641: if l_type = 'CMS_DEO' then

Line 1643: hr_utility.set_location('Order Amount is NULL: Raise Error',14);

1639: END IF;
1640:
1641: if l_type = 'CMS_DEO' then
1642: if l_amount is null then
1643: hr_utility.set_location('Order Amount is NULL: Raise Error',14);
1644:
1645: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_MAND_NDR');
1646: hr_utility.raise_error;
1647: end if;

Line 1645: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_MAND_NDR');

1641: if l_type = 'CMS_DEO' then
1642: if l_amount is null then
1643: hr_utility.set_location('Order Amount is NULL: Raise Error',14);
1644:
1645: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_MAND_NDR');
1646: hr_utility.raise_error;
1647: end if;
1648:
1649: OPEN csr_is_paye_aggregated;

Line 1646: hr_utility.raise_error;

1642: if l_amount is null then
1643: hr_utility.set_location('Order Amount is NULL: Raise Error',14);
1644:
1645: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_MAND_NDR');
1646: hr_utility.raise_error;
1647: end if;
1648:
1649: OPEN csr_is_paye_aggregated;
1650: FETCH csr_is_paye_aggregated into l_aggr_flag;

Line 1653: hr_utility.set_location('Overriding Frequency is NULL for aggregated assignment: Raise Error',14);

1649: OPEN csr_is_paye_aggregated;
1650: FETCH csr_is_paye_aggregated into l_aggr_flag;
1651: CLOSE csr_is_paye_aggregated;
1652: if l_override_ndr is null and l_aggr_flag = 'Y' then
1653: hr_utility.set_location('Overriding Frequency is NULL for aggregated assignment: Raise Error',14);
1654:
1655: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_OVR_FREQ');
1656: hr_utility.raise_error;
1657: end if;

Line 1655: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_OVR_FREQ');

1651: CLOSE csr_is_paye_aggregated;
1652: if l_override_ndr is null and l_aggr_flag = 'Y' then
1653: hr_utility.set_location('Overriding Frequency is NULL for aggregated assignment: Raise Error',14);
1654:
1655: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_OVR_FREQ');
1656: hr_utility.raise_error;
1657: end if;
1658:
1659: end if;

Line 1656: hr_utility.raise_error;

1652: if l_override_ndr is null and l_aggr_flag = 'Y' then
1653: hr_utility.set_location('Overriding Frequency is NULL for aggregated assignment: Raise Error',14);
1654:
1655: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_OVR_FREQ');
1656: hr_utility.raise_error;
1657: end if;
1658:
1659: end if;
1660: END IF;

Line 1672: hr_utility.trace('NI Element');

1668: selects any of these categories or pension.
1669: */
1670: if l_element_name = 'NI' then
1671:
1672: hr_utility.trace('NI Element');
1673: if p_effective_start_date >= to_Date('06-04-2012','dd-mm-yyyy') then
1674: open csr_ni_cate_pens_ent_values;
1675: fetch csr_ni_cate_pens_ent_values into l_category,l_pension;
1676: close csr_ni_cate_pens_ent_values;

Line 1679: hr_utility.trace('Invalid Category');

1675: fetch csr_ni_cate_pens_ent_values into l_category,l_pension;
1676: close csr_ni_cate_pens_ent_values;
1677:
1678: if l_category <> 'A' then
1679: hr_utility.trace('Invalid Category');
1680: hr_utility.set_message(800,'HR_78097_GB_NI_INV_CATEGORY');
1681: hr_utility.raise_error;
1682: end if;
1683: if l_pension = 'A' then

Line 1680: hr_utility.set_message(800,'HR_78097_GB_NI_INV_CATEGORY');

1676: close csr_ni_cate_pens_ent_values;
1677:
1678: if l_category <> 'A' then
1679: hr_utility.trace('Invalid Category');
1680: hr_utility.set_message(800,'HR_78097_GB_NI_INV_CATEGORY');
1681: hr_utility.raise_error;
1682: end if;
1683: if l_pension = 'A' then
1684: hr_utility.trace('Invalid Pension');

Line 1681: hr_utility.raise_error;

1677:
1678: if l_category <> 'A' then
1679: hr_utility.trace('Invalid Category');
1680: hr_utility.set_message(800,'HR_78097_GB_NI_INV_CATEGORY');
1681: hr_utility.raise_error;
1682: end if;
1683: if l_pension = 'A' then
1684: hr_utility.trace('Invalid Pension');
1685: hr_utility.set_message(800,'HR_78098_GB_NI_INV_PENSION');

Line 1684: hr_utility.trace('Invalid Pension');

1680: hr_utility.set_message(800,'HR_78097_GB_NI_INV_CATEGORY');
1681: hr_utility.raise_error;
1682: end if;
1683: if l_pension = 'A' then
1684: hr_utility.trace('Invalid Pension');
1685: hr_utility.set_message(800,'HR_78098_GB_NI_INV_PENSION');
1686: hr_utility.raise_error;
1687: end if;
1688:

Line 1685: hr_utility.set_message(800,'HR_78098_GB_NI_INV_PENSION');

1681: hr_utility.raise_error;
1682: end if;
1683: if l_pension = 'A' then
1684: hr_utility.trace('Invalid Pension');
1685: hr_utility.set_message(800,'HR_78098_GB_NI_INV_PENSION');
1686: hr_utility.raise_error;
1687: end if;
1688:
1689: end if;

Line 1686: hr_utility.raise_error;

1682: end if;
1683: if l_pension = 'A' then
1684: hr_utility.trace('Invalid Pension');
1685: hr_utility.set_message(800,'HR_78098_GB_NI_INV_PENSION');
1686: hr_utility.raise_error;
1687: end if;
1688:
1689: end if;
1690: end if;

Line 1691: hr_utility.set_location('Leaving procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',15);

1687: end if;
1688:
1689: end if;
1690: end if;
1691: hr_utility.set_location('Leaving procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',15);
1692:
1693: END AI_VAL_REF_COURT_ORDER;
1694:
1695: -----------------------------------------------------------------------------

Line 1936: --hr_utility.trace_on(null,'jag');

1932: l_pension varchar2(1);
1933:
1934: BEGIN
1935:
1936: --hr_utility.trace_on(null,'jag');
1937: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',10);
1938: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);
1939: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);
1940: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);

Line 1937: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',10);

1933:
1934: BEGIN
1935:
1936: --hr_utility.trace_on(null,'jag');
1937: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',10);
1938: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);
1939: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);
1940: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1941: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);

Line 1938: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);

1934: BEGIN
1935:
1936: --hr_utility.trace_on(null,'jag');
1937: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',10);
1938: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);
1939: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);
1940: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1941: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1942: hr_utility.set_location('p_element_type_id_o :' ||p_element_type_id_o,10);

Line 1939: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);

1935:
1936: --hr_utility.trace_on(null,'jag');
1937: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',10);
1938: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);
1939: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);
1940: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1941: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1942: hr_utility.set_location('p_element_type_id_o :' ||p_element_type_id_o,10);
1943:

Line 1940: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);

1936: --hr_utility.trace_on(null,'jag');
1937: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',10);
1938: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);
1939: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);
1940: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1941: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1942: hr_utility.set_location('p_element_type_id_o :' ||p_element_type_id_o,10);
1943:
1944: OPEN csr_get_element;

Line 1941: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);

1937: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',10);
1938: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);
1939: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);
1940: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1941: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1942: hr_utility.set_location('p_element_type_id_o :' ||p_element_type_id_o,10);
1943:
1944: OPEN csr_get_element;
1945: FETCH csr_get_element INTO l_element_name;

Line 1942: hr_utility.set_location('p_element_type_id_o :' ||p_element_type_id_o,10);

1938: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);
1939: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);
1940: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1941: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1942: hr_utility.set_location('p_element_type_id_o :' ||p_element_type_id_o,10);
1943:
1944: OPEN csr_get_element;
1945: FETCH csr_get_element INTO l_element_name;
1946: CLOSE csr_get_element;

Line 1948: hr_utility.set_location('l_element_name :' ||l_element_name,11);

1944: OPEN csr_get_element;
1945: FETCH csr_get_element INTO l_element_name;
1946: CLOSE csr_get_element;
1947:
1948: hr_utility.set_location('l_element_name :' ||l_element_name,11);
1949:
1950: IF (l_element_name = 'Court Order'
1951: OR l_element_name = 'Court Order NTPP')--element is Court Order
1952: THEN

Line 1954: hr_utility.set_location('Element is Court Order',12);

1950: IF (l_element_name = 'Court Order'
1951: OR l_element_name = 'Court Order NTPP')--element is Court Order
1952: THEN
1953:
1954: hr_utility.set_location('Element is Court Order',12);
1955:
1956: OPEN csr_get_ele_ent_values;
1957: FETCH csr_get_ele_ent_values INTO l_type, l_reference, l_amount,l_override_ndr;
1958: CLOSE csr_get_ele_ent_values;

Line 1960: hr_utility.set_location('l_type :' ||l_type,12);

1956: OPEN csr_get_ele_ent_values;
1957: FETCH csr_get_ele_ent_values INTO l_type, l_reference, l_amount,l_override_ndr;
1958: CLOSE csr_get_ele_ent_values;
1959:
1960: hr_utility.set_location('l_type :' ||l_type,12);
1961: hr_utility.set_location('l_reference :' ||l_reference,12);
1962:
1963: IF (l_type = 'CCAEO'
1964: OR l_type = 'CTO'

Line 1961: hr_utility.set_location('l_reference :' ||l_reference,12);

1957: FETCH csr_get_ele_ent_values INTO l_type, l_reference, l_amount,l_override_ndr;
1958: CLOSE csr_get_ele_ent_values;
1959:
1960: hr_utility.set_location('l_type :' ||l_type,12);
1961: hr_utility.set_location('l_reference :' ||l_reference,12);
1962:
1963: IF (l_type = 'CCAEO'
1964: OR l_type = 'CTO'
1965: OR l_type = 'AEO_PERCENT'

Line 1969: hr_utility.set_location('Type is applicable',13);

1965: OR l_type = 'AEO_PERCENT'
1966: OR l_type = 'CTO_POST_APRIL_2007'
1967: OR l_type = 'CMS_DEO')
1968: THEN
1969: hr_utility.set_location('Type is applicable',13);
1970:
1971: OPEN csr_get_results;
1972: FETCH csr_get_results INTO v_exists;
1973:

Line 1977: hr_utility.set_location('No payroll run for this element',14);

1973:
1974: IF csr_get_results%NOTFOUND
1975: THEN
1976:
1977: hr_utility.set_location('No payroll run for this element',14);
1978:
1979: IF (l_reference is null)
1980: THEN
1981: hr_utility.set_location('Ref is NULL: Raise Error',15);

Line 1981: hr_utility.set_location('Ref is NULL: Raise Error',15);

1977: hr_utility.set_location('No payroll run for this element',14);
1978:
1979: IF (l_reference is null)
1980: THEN
1981: hr_utility.set_location('Ref is NULL: Raise Error',15);
1982:
1983: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');
1984: hr_utility.raise_error;
1985: END IF;

Line 1983: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');

1979: IF (l_reference is null)
1980: THEN
1981: hr_utility.set_location('Ref is NULL: Raise Error',15);
1982:
1983: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');
1984: hr_utility.raise_error;
1985: END IF;
1986:
1987: ELSE

Line 1984: hr_utility.raise_error;

1980: THEN
1981: hr_utility.set_location('Ref is NULL: Raise Error',15);
1982:
1983: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');
1984: hr_utility.raise_error;
1985: END IF;
1986:
1987: ELSE
1988:

Line 1992: hr_utility.set_location('v_value :' ||v_value,16);

1988:
1989: OPEN csr_get_reference;
1990: FETCH csr_get_reference INTO v_value;
1991:
1992: hr_utility.set_location('v_value :' ||v_value,16);
1993:
1994: --v_value can't be null as we are fetching it from payroll run
1995: IF (l_reference is null
1996: or v_value <> l_reference

Line 1999: hr_utility.set_location('Ref is changed since previous payroll run: Raise Error',17);

1995: IF (l_reference is null
1996: or v_value <> l_reference
1997: )
1998: THEN
1999: hr_utility.set_location('Ref is changed since previous payroll run: Raise Error',17);
2000:
2001: hr_utility.set_message(801, 'PAY_GB_78139_INVALID_CO_REF');
2002: hr_utility.set_message_token('REFERENCE', l_reference);
2003: hr_utility.raise_error;

Line 2001: hr_utility.set_message(801, 'PAY_GB_78139_INVALID_CO_REF');

1997: )
1998: THEN
1999: hr_utility.set_location('Ref is changed since previous payroll run: Raise Error',17);
2000:
2001: hr_utility.set_message(801, 'PAY_GB_78139_INVALID_CO_REF');
2002: hr_utility.set_message_token('REFERENCE', l_reference);
2003: hr_utility.raise_error;
2004: END IF;
2005:

Line 2002: hr_utility.set_message_token('REFERENCE', l_reference);

1998: THEN
1999: hr_utility.set_location('Ref is changed since previous payroll run: Raise Error',17);
2000:
2001: hr_utility.set_message(801, 'PAY_GB_78139_INVALID_CO_REF');
2002: hr_utility.set_message_token('REFERENCE', l_reference);
2003: hr_utility.raise_error;
2004: END IF;
2005:
2006: CLOSE csr_get_reference;

Line 2003: hr_utility.raise_error;

1999: hr_utility.set_location('Ref is changed since previous payroll run: Raise Error',17);
2000:
2001: hr_utility.set_message(801, 'PAY_GB_78139_INVALID_CO_REF');
2002: hr_utility.set_message_token('REFERENCE', l_reference);
2003: hr_utility.raise_error;
2004: END IF;
2005:
2006: CLOSE csr_get_reference;
2007: END IF;

Line 2015: hr_utility.set_location('Order Amount is NULL: Raise Error',14);

2011: if l_type = 'CMS_DEO' then
2012:
2013:
2014: if l_amount is null then
2015: hr_utility.set_location('Order Amount is NULL: Raise Error',14);
2016:
2017: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_MAND_NDR');
2018: hr_utility.raise_error;
2019: end if;

Line 2017: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_MAND_NDR');

2013:
2014: if l_amount is null then
2015: hr_utility.set_location('Order Amount is NULL: Raise Error',14);
2016:
2017: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_MAND_NDR');
2018: hr_utility.raise_error;
2019: end if;
2020:
2021: OPEN csr_is_paye_aggregated;

Line 2018: hr_utility.raise_error;

2014: if l_amount is null then
2015: hr_utility.set_location('Order Amount is NULL: Raise Error',14);
2016:
2017: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_MAND_NDR');
2018: hr_utility.raise_error;
2019: end if;
2020:
2021: OPEN csr_is_paye_aggregated;
2022: FETCH csr_is_paye_aggregated into l_aggr_flag;

Line 2027: hr_utility.set_location('Overriding Frequency is NULL for aggregated assignment: Raise Error',14);

2023: CLOSE csr_is_paye_aggregated;
2024:
2025: if l_override_ndr is null and l_aggr_flag = 'Y' then
2026:
2027: hr_utility.set_location('Overriding Frequency is NULL for aggregated assignment: Raise Error',14);
2028:
2029: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_OVR_FREQ');
2030: hr_utility.raise_error;
2031: end if;

Line 2029: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_OVR_FREQ');

2025: if l_override_ndr is null and l_aggr_flag = 'Y' then
2026:
2027: hr_utility.set_location('Overriding Frequency is NULL for aggregated assignment: Raise Error',14);
2028:
2029: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_OVR_FREQ');
2030: hr_utility.raise_error;
2031: end if;
2032: end if;
2033:

Line 2030: hr_utility.raise_error;

2026:
2027: hr_utility.set_location('Overriding Frequency is NULL for aggregated assignment: Raise Error',14);
2028:
2029: hr_utility.set_message(800, 'PAY_GB_CMS_DEO_OVR_FREQ');
2030: hr_utility.raise_error;
2031: end if;
2032: end if;
2033:
2034:

Line 2042: hr_utility.set_location('PAYE g_global_paye_validation :'||g_global_paye_validation ,18);

2038: -- BEGIN
2039: -- For Bug 8485686
2040: -----------------------------
2041:
2042: hr_utility.set_location('PAYE g_global_paye_validation :'||g_global_paye_validation ,18);
2043:
2044: --Modifications for the bug fix# 10254292 starts here
2045: /*
2046: Below condition checks whether the current PAYE element has

Line 2060: hr_utility.set_message(800,'HR_78095_GB_PAYE_D1_CORR');

2056: FETCH csr_get_tax_code INTO l_tax_code;
2057: CLOSE csr_get_tax_code;
2058:
2059: if l_tax_code = 'D1' then
2060: hr_utility.set_message(800,'HR_78095_GB_PAYE_D1_CORR');
2061: hr_utility.raise_error;
2062: end if;
2063: end if;
2064: END IF;

Line 2061: hr_utility.raise_error;

2057: CLOSE csr_get_tax_code;
2058:
2059: if l_tax_code = 'D1' then
2060: hr_utility.set_message(800,'HR_78095_GB_PAYE_D1_CORR');
2061: hr_utility.raise_error;
2062: end if;
2063: end if;
2064: END IF;
2065: --Modifications for the bug fix# 10254292 ends here

Line 2073: hr_utility.set_location('PAYE l_element_name :'||l_element_name ,18);

2069:
2070: IF g_first_assignment = 'Y'
2071: THEN
2072:
2073: hr_utility.set_location('PAYE l_element_name :'||l_element_name ,18);
2074: -- Fix for Bug# 11924747
2075: /**
2076: The query now retrieves the assignment id by taking into consideration p_effective_start_date instead of p_effective_date.
2077: */

Line 2089: hr_utility.set_location('PAYE l_paye_assg_id :'||l_paye_assg_id ,18);

2085:
2086: g_first_assignment_id := l_paye_assg_id;
2087: g_first_assignment := 'N';
2088:
2089: hr_utility.set_location('PAYE l_paye_assg_id :'||l_paye_assg_id ,18);
2090:
2091: SELECT papf.per_information10
2092: INTO l_paye_agg
2093: FROM per_all_people_f papf,

Line 2100: hr_utility.set_location('PAYE l_paye_agg :'||l_paye_agg ,18);

2096: AND paaf.person_id = papf.person_id
2097: AND p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date
2098: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
2099:
2100: hr_utility.set_location('PAYE l_paye_agg :'||l_paye_agg ,18);
2101:
2102: IF l_paye_agg = 'Y'
2103: THEN
2104:

Line 2109: hr_utility.set_location('PAYE jag_ini_tax_district :'||l_paye_ini_tax_dist ,18);

2105: OPEN tax_district(l_paye_assg_id);
2106: FETCH tax_district INTO l_paye_ini_tax_dist;
2107: CLOSE tax_district;
2108:
2109: hr_utility.set_location('PAYE jag_ini_tax_district :'||l_paye_ini_tax_dist ,18);
2110:
2111: OPEN c_get_input_values;
2112: FETCH c_get_input_values into l_input_value_id1,
2113: l_tax_code,

Line 2128: hr_utility.set_location('PAYE l_tax_code :'||l_tax_code ,18);

2124: l_ele_information1,
2125: l_ele_information2;
2126: CLOSE c_get_input_values;
2127:
2128: hr_utility.set_location('PAYE l_tax_code :'||l_tax_code ,18);
2129: --10157179 Begin
2130: /*SESSION Date should be present for the view pay_paye_element_entries_v
2131: used in cursor cur_element_entry_id. */
2132: select count(*) into l_session_present from fnd_sessions ses

Line 2135: hr_utility.set_location('No session date so inserting ',18);

2131: used in cursor cur_element_entry_id. */
2132: select count(*) into l_session_present from fnd_sessions ses
2133: where ses.session_id = userenv('SESSIONID');
2134: If l_session_present <> 1 then
2135: hr_utility.set_location('No session date so inserting ',18);
2136: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
2137: values(userenv('sessionid'), p_effective_date);
2138: End if;
2139:

Line 2147: hr_utility.set_location('Fetched cur_element_entry_id' ,19);

2143: FETCH cur_element_entry_id bulk collect into g_element_entry_rec_tab;
2144: CLOSE cur_element_entry_id;
2145:
2146: --10157179 Begin
2147: hr_utility.set_location('Fetched cur_element_entry_id' ,19);
2148: --IF g_element_entry_rec_tab.COUNT > 1
2149: IF g_element_entry_rec_tab.COUNT > 0
2150: THEN
2151: l_agg_active_end := pay_gb_eoy_archive.get_agg_active_end(l_paye_assg_id, l_paye_ini_tax_dist, p_effective_date);

Line 2153: hr_utility.set_location('l_agg_active_end '||l_agg_active_end ,20);

2149: IF g_element_entry_rec_tab.COUNT > 0
2150: THEN
2151: l_agg_active_end := pay_gb_eoy_archive.get_agg_active_end(l_paye_assg_id, l_paye_ini_tax_dist, p_effective_date);
2152: l_agg_active_start := pay_gb_eoy_archive.get_agg_active_start(l_paye_assg_id, l_paye_ini_tax_dist, p_effective_date);
2153: hr_utility.set_location('l_agg_active_end '||l_agg_active_end ,20);
2154: hr_utility.set_location('l_agg_active_start'||l_agg_active_start ,20);
2155:
2156:
2157: l_cnt := g_element_entry_rec_tab.FIRST;

Line 2154: hr_utility.set_location('l_agg_active_start'||l_agg_active_start ,20);

2150: THEN
2151: l_agg_active_end := pay_gb_eoy_archive.get_agg_active_end(l_paye_assg_id, l_paye_ini_tax_dist, p_effective_date);
2152: l_agg_active_start := pay_gb_eoy_archive.get_agg_active_start(l_paye_assg_id, l_paye_ini_tax_dist, p_effective_date);
2153: hr_utility.set_location('l_agg_active_end '||l_agg_active_end ,20);
2154: hr_utility.set_location('l_agg_active_start'||l_agg_active_start ,20);
2155:
2156:
2157: l_cnt := g_element_entry_rec_tab.FIRST;
2158: LOOP

Line 2161: hr_utility.set_location('g_element_entry_rec_tab(l_cnt).aid'||g_element_entry_rec_tab(l_cnt).aid ,21);

2157: l_cnt := g_element_entry_rec_tab.FIRST;
2158: LOOP
2159:
2160: EXIT WHEN l_cnt IS NULL;
2161: hr_utility.set_location('g_element_entry_rec_tab(l_cnt).aid'||g_element_entry_rec_tab(l_cnt).aid ,21);
2162: hr_utility.set_location('g_first_assignment_id'||g_first_assignment_id ,21);
2163: /* 10157179 This condition is already added in cur_element_entry_id
2164: IF g_element_entry_rec_tab(l_cnt).aid <> g_first_assignment_id
2165: THEN

Line 2162: hr_utility.set_location('g_first_assignment_id'||g_first_assignment_id ,21);

2158: LOOP
2159:
2160: EXIT WHEN l_cnt IS NULL;
2161: hr_utility.set_location('g_element_entry_rec_tab(l_cnt).aid'||g_element_entry_rec_tab(l_cnt).aid ,21);
2162: hr_utility.set_location('g_first_assignment_id'||g_first_assignment_id ,21);
2163: /* 10157179 This condition is already added in cur_element_entry_id
2164: IF g_element_entry_rec_tab(l_cnt).aid <> g_first_assignment_id
2165: THEN
2166: */

Line 2174: hr_utility.set_location(g_element_entry_rec_tab(l_cnt).aid ||' share same aggregation period with '|| g_first_assignment_id,21);

2170: and
2171: pay_gb_eoy_archive.get_agg_active_start(g_element_entry_rec_tab(l_cnt).aid, l_paye_ini_tax_dist, p_effective_date) = l_agg_active_start
2172: THEN
2173:
2174: hr_utility.set_location(g_element_entry_rec_tab(l_cnt).aid ||' share same aggregation period with '|| g_first_assignment_id,21);
2175: --10157179 End
2176: OPEN tax_district(g_element_entry_rec_tab(l_cnt).aid);
2177: FETCH tax_district INTO l_paye_tax_dist;
2178: CLOSE tax_district;

Line 2180: hr_utility.set_location('PAYE l_paye_tax_dist :'||l_paye_tax_dist ,18);

2176: OPEN tax_district(g_element_entry_rec_tab(l_cnt).aid);
2177: FETCH tax_district INTO l_paye_tax_dist;
2178: CLOSE tax_district;
2179:
2180: hr_utility.set_location('PAYE l_paye_tax_dist :'||l_paye_tax_dist ,18);
2181:
2182: IF l_paye_tax_dist=l_paye_ini_tax_dist
2183: THEN
2184:

Line 2186: hr_utility.set_location('PAYE P_EFFECTIVE_DATE '|| P_EFFECTIVE_DATE ,18);

2182: IF l_paye_tax_dist=l_paye_ini_tax_dist
2183: THEN
2184:
2185:
2186: hr_utility.set_location('PAYE P_EFFECTIVE_DATE '|| P_EFFECTIVE_DATE ,18);
2187: --10157179 begin
2188: IF trunc(g_element_entry_rec_tab(l_cnt).eff_date) = trunc(P_EFFECTIVE_DATE) then
2189: L_DATETRACK_MODE := 'CORRECTION';
2190: ELSIF substr(P_DATETRACK_MODE,1,6) = 'DELETE' then

Line 2195: hr_utility.set_location(P_DATETRACK_MODE||'PAYE P_DATETRACK_MODE is changed to '|| L_DATETRACK_MODE ,23);

2191: L_DATETRACK_MODE := 'UPDATE';
2192: ELSE
2193: L_DATETRACK_MODE := P_DATETRACK_MODE;
2194: END IF;
2195: hr_utility.set_location(P_DATETRACK_MODE||'PAYE P_DATETRACK_MODE is changed to '|| L_DATETRACK_MODE ,23);
2196: --10157179 end
2197:
2198: --Modifications for the bug fix# 10254292 starts here
2199: /*

Line 2215: hr_utility.set_message(800,'HR_78096_GB_PAYE_D1_AGR_CORR');

2211: (trunc(g_element_entry_rec_tab(l_cnt).eff_date) < to_date('06-04-2011','DD-MM-YYYY')) and
2212: (p_datetrack_mode = 'CORRECTION'))
2213: then
2214: g_first_assignment := 'Y';
2215: hr_utility.set_message(800,'HR_78096_GB_PAYE_D1_AGR_CORR');
2216: hr_utility.raise_error;
2217: end if;
2218:
2219: --Modifications for the bug fix# 10254292 ends here

Line 2216: hr_utility.raise_error;

2212: (p_datetrack_mode = 'CORRECTION'))
2213: then
2214: g_first_assignment := 'Y';
2215: hr_utility.set_message(800,'HR_78096_GB_PAYE_D1_AGR_CORR');
2216: hr_utility.raise_error;
2217: end if;
2218:
2219: --Modifications for the bug fix# 10254292 ends here
2220:

Line 2280: hr_utility.trace('NI Element');

2276: We should throw the validation error if the user
2277: selects any of these categories or pension.
2278: */
2279: if l_element_name = 'NI' then
2280: hr_utility.trace('NI Element');
2281: if p_effective_date >= to_Date('06-04-2012','dd-mm-yyyy') then
2282: open csr_ni_cate_pens_ent_values;
2283: fetch csr_ni_cate_pens_ent_values into l_category,l_pension;
2284: close csr_ni_cate_pens_ent_values;

Line 2287: hr_utility.trace('Invalid Category');

2283: fetch csr_ni_cate_pens_ent_values into l_category,l_pension;
2284: close csr_ni_cate_pens_ent_values;
2285:
2286: if l_category <> 'A' then
2287: hr_utility.trace('Invalid Category');
2288: hr_utility.set_message(800,'HR_78097_GB_NI_INV_CATEGORY');
2289: hr_utility.raise_error;
2290: end if;
2291: if l_pension = 'A' then

Line 2288: hr_utility.set_message(800,'HR_78097_GB_NI_INV_CATEGORY');

2284: close csr_ni_cate_pens_ent_values;
2285:
2286: if l_category <> 'A' then
2287: hr_utility.trace('Invalid Category');
2288: hr_utility.set_message(800,'HR_78097_GB_NI_INV_CATEGORY');
2289: hr_utility.raise_error;
2290: end if;
2291: if l_pension = 'A' then
2292: hr_utility.trace('Invalid Pension');

Line 2289: hr_utility.raise_error;

2285:
2286: if l_category <> 'A' then
2287: hr_utility.trace('Invalid Category');
2288: hr_utility.set_message(800,'HR_78097_GB_NI_INV_CATEGORY');
2289: hr_utility.raise_error;
2290: end if;
2291: if l_pension = 'A' then
2292: hr_utility.trace('Invalid Pension');
2293: hr_utility.set_message(800,'HR_78098_GB_NI_INV_PENSION');

Line 2292: hr_utility.trace('Invalid Pension');

2288: hr_utility.set_message(800,'HR_78097_GB_NI_INV_CATEGORY');
2289: hr_utility.raise_error;
2290: end if;
2291: if l_pension = 'A' then
2292: hr_utility.trace('Invalid Pension');
2293: hr_utility.set_message(800,'HR_78098_GB_NI_INV_PENSION');
2294: hr_utility.raise_error;
2295: end if;
2296: end if;

Line 2293: hr_utility.set_message(800,'HR_78098_GB_NI_INV_PENSION');

2289: hr_utility.raise_error;
2290: end if;
2291: if l_pension = 'A' then
2292: hr_utility.trace('Invalid Pension');
2293: hr_utility.set_message(800,'HR_78098_GB_NI_INV_PENSION');
2294: hr_utility.raise_error;
2295: end if;
2296: end if;
2297: end if;

Line 2294: hr_utility.raise_error;

2290: end if;
2291: if l_pension = 'A' then
2292: hr_utility.trace('Invalid Pension');
2293: hr_utility.set_message(800,'HR_78098_GB_NI_INV_PENSION');
2294: hr_utility.raise_error;
2295: end if;
2296: end if;
2297: end if;
2298: -----

Line 2303: hr_utility.set_location('Leaving procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',18);

2299: -- END BUG - 13363065. NI Changes 2012.
2300: -----
2301:
2302:
2303: hr_utility.set_location('Leaving procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',18);
2304:
2305: END AU_VAL_REF_COURT_ORDER;
2306:
2307: --For bug 7294977: End