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.2.12010000.5 2008/08/08 15:14:15 namgoyal 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 1560: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',10);

1556: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1557:
1558: BEGIN
1559:
1560: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',10);
1561: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1562: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1563: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);
1564:

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

1557:
1558: BEGIN
1559:
1560: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',10);
1561: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1562: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1563: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);
1564:
1565: OPEN csr_get_element;

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

1558: BEGIN
1559:
1560: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',10);
1561: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1562: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1563: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);
1564:
1565: OPEN csr_get_element;
1566: FETCH csr_get_element INTO l_element_name;

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

1559:
1560: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',10);
1561: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1562: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1563: hr_utility.set_location('p_element_type_id :' ||p_element_type_id,10);
1564:
1565: OPEN csr_get_element;
1566: FETCH csr_get_element INTO l_element_name;
1567: CLOSE csr_get_element;

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

1565: OPEN csr_get_element;
1566: FETCH csr_get_element INTO l_element_name;
1567: CLOSE csr_get_element;
1568:
1569: hr_utility.set_location('l_element_name :' ||l_element_name,11);
1570:
1571: IF (l_element_name = 'Court Order'
1572: OR l_element_name = 'Court Order NTPP')--element is Court Order
1573: THEN

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

1571: IF (l_element_name = 'Court Order'
1572: OR l_element_name = 'Court Order NTPP')--element is Court Order
1573: THEN
1574:
1575: hr_utility.set_location('Element is Court Order',12);
1576:
1577: OPEN csr_get_ele_ent_values;
1578: FETCH csr_get_ele_ent_values INTO l_type, l_reference;
1579: CLOSE csr_get_ele_ent_values;

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

1577: OPEN csr_get_ele_ent_values;
1578: FETCH csr_get_ele_ent_values INTO l_type, l_reference;
1579: CLOSE csr_get_ele_ent_values;
1580:
1581: hr_utility.set_location('l_type :' ||l_type,12);
1582: hr_utility.set_location('l_reference :' ||l_reference,12);
1583:
1584: IF (l_type = 'CCAEO'
1585: OR l_type = 'CTO'

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

1578: FETCH csr_get_ele_ent_values INTO l_type, l_reference;
1579: CLOSE csr_get_ele_ent_values;
1580:
1581: hr_utility.set_location('l_type :' ||l_type,12);
1582: hr_utility.set_location('l_reference :' ||l_reference,12);
1583:
1584: IF (l_type = 'CCAEO'
1585: OR l_type = 'CTO'
1586: OR l_type = 'AEO_PERCENT'

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

1585: OR l_type = 'CTO'
1586: OR l_type = 'AEO_PERCENT'
1587: OR l_type = 'CTO_POST_APRIL_2007')
1588: THEN
1589: hr_utility.set_location('Type is applicable',13);
1590:
1591: IF l_reference IS NULL
1592: THEN
1593: hr_utility.set_location('Ref is NULL: Raise Error',14);

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

1589: hr_utility.set_location('Type is applicable',13);
1590:
1591: IF l_reference IS NULL
1592: THEN
1593: hr_utility.set_location('Ref is NULL: Raise Error',14);
1594:
1595: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');
1596: hr_utility.raise_error;
1597: END IF;

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

1591: IF l_reference IS NULL
1592: THEN
1593: hr_utility.set_location('Ref is NULL: Raise Error',14);
1594:
1595: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');
1596: hr_utility.raise_error;
1597: END IF;
1598: END IF;
1599: END IF;

Line 1596: hr_utility.raise_error;

1592: THEN
1593: hr_utility.set_location('Ref is NULL: Raise Error',14);
1594:
1595: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');
1596: hr_utility.raise_error;
1597: END IF;
1598: END IF;
1599: END IF;
1600:

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

1597: END IF;
1598: END IF;
1599: END IF;
1600:
1601: hr_utility.set_location('Leaving procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',15);
1602:
1603: END AI_VAL_REF_COURT_ORDER;
1604:
1605: -----------------------------------------------------------------------------

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

1700: v_exists VARCHAR2(100) := 'N';
1701: v_value varchar2(100) := 'Unknown';
1702:
1703: BEGIN
1704: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',10);
1705: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);
1706: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);
1707: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1708: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);

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

1701: v_value varchar2(100) := 'Unknown';
1702:
1703: BEGIN
1704: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',10);
1705: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);
1706: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);
1707: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1708: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1709: hr_utility.set_location('p_element_type_id_o :' ||p_element_type_id_o,10);

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

1702:
1703: BEGIN
1704: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',10);
1705: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);
1706: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);
1707: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1708: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1709: hr_utility.set_location('p_element_type_id_o :' ||p_element_type_id_o,10);
1710:

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

1703: BEGIN
1704: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',10);
1705: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);
1706: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);
1707: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1708: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1709: hr_utility.set_location('p_element_type_id_o :' ||p_element_type_id_o,10);
1710:
1711: OPEN csr_get_element;

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

1704: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',10);
1705: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);
1706: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);
1707: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1708: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1709: hr_utility.set_location('p_element_type_id_o :' ||p_element_type_id_o,10);
1710:
1711: OPEN csr_get_element;
1712: FETCH csr_get_element INTO l_element_name;

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

1705: hr_utility.set_location('p_effective_date :' ||p_effective_date,10);
1706: hr_utility.set_location('p_datetrack_mode :' ||p_datetrack_mode,10);
1707: hr_utility.set_location('p_effective_start_date :' ||p_effective_start_date,10);
1708: hr_utility.set_location('p_element_entry_id :' ||p_element_entry_id,10);
1709: hr_utility.set_location('p_element_type_id_o :' ||p_element_type_id_o,10);
1710:
1711: OPEN csr_get_element;
1712: FETCH csr_get_element INTO l_element_name;
1713: CLOSE csr_get_element;

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

1711: OPEN csr_get_element;
1712: FETCH csr_get_element INTO l_element_name;
1713: CLOSE csr_get_element;
1714:
1715: hr_utility.set_location('l_element_name :' ||l_element_name,11);
1716:
1717: IF (l_element_name = 'Court Order'
1718: OR l_element_name = 'Court Order NTPP')--element is Court Order
1719: THEN

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

1717: IF (l_element_name = 'Court Order'
1718: OR l_element_name = 'Court Order NTPP')--element is Court Order
1719: THEN
1720:
1721: hr_utility.set_location('Element is Court Order',12);
1722:
1723: OPEN csr_get_ele_ent_values;
1724: FETCH csr_get_ele_ent_values INTO l_type, l_reference;
1725: CLOSE csr_get_ele_ent_values;

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

1723: OPEN csr_get_ele_ent_values;
1724: FETCH csr_get_ele_ent_values INTO l_type, l_reference;
1725: CLOSE csr_get_ele_ent_values;
1726:
1727: hr_utility.set_location('l_type :' ||l_type,12);
1728: hr_utility.set_location('l_reference :' ||l_reference,12);
1729:
1730: IF (l_type = 'CCAEO'
1731: OR l_type = 'CTO'

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

1724: FETCH csr_get_ele_ent_values INTO l_type, l_reference;
1725: CLOSE csr_get_ele_ent_values;
1726:
1727: hr_utility.set_location('l_type :' ||l_type,12);
1728: hr_utility.set_location('l_reference :' ||l_reference,12);
1729:
1730: IF (l_type = 'CCAEO'
1731: OR l_type = 'CTO'
1732: OR l_type = 'AEO_PERCENT'

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

1731: OR l_type = 'CTO'
1732: OR l_type = 'AEO_PERCENT'
1733: OR l_type = 'CTO_POST_APRIL_2007')
1734: THEN
1735: hr_utility.set_location('Type is applicable',13);
1736:
1737: OPEN csr_get_results;
1738: FETCH csr_get_results INTO v_exists;
1739:

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

1739:
1740: IF csr_get_results%NOTFOUND
1741: THEN
1742:
1743: hr_utility.set_location('No payroll run for this element',14);
1744:
1745: IF (l_reference is null)
1746: THEN
1747: hr_utility.set_location('Ref is NULL: Raise Error',15);

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

1743: hr_utility.set_location('No payroll run for this element',14);
1744:
1745: IF (l_reference is null)
1746: THEN
1747: hr_utility.set_location('Ref is NULL: Raise Error',15);
1748:
1749: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');
1750: hr_utility.raise_error;
1751: END IF;

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

1745: IF (l_reference is null)
1746: THEN
1747: hr_utility.set_location('Ref is NULL: Raise Error',15);
1748:
1749: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');
1750: hr_utility.raise_error;
1751: END IF;
1752:
1753: ELSE

Line 1750: hr_utility.raise_error;

1746: THEN
1747: hr_utility.set_location('Ref is NULL: Raise Error',15);
1748:
1749: hr_utility.set_message(801, 'PAY_GB_78138_NULL_CO_REF');
1750: hr_utility.raise_error;
1751: END IF;
1752:
1753: ELSE
1754:

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

1754:
1755: OPEN csr_get_reference;
1756: FETCH csr_get_reference INTO v_value;
1757:
1758: hr_utility.set_location('v_value :' ||v_value,16);
1759:
1760: --v_value can't be null as we are fetching it from payroll run
1761: IF (l_reference is null
1762: or v_value <> l_reference

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

1761: IF (l_reference is null
1762: or v_value <> l_reference
1763: )
1764: THEN
1765: hr_utility.set_location('Ref is changed since previous payroll run: Raise Error',17);
1766:
1767: hr_utility.set_message(801, 'PAY_GB_78139_INVALID_CO_REF');
1768: hr_utility.set_message_token('REFERENCE', l_reference);
1769: hr_utility.raise_error;

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

1763: )
1764: THEN
1765: hr_utility.set_location('Ref is changed since previous payroll run: Raise Error',17);
1766:
1767: hr_utility.set_message(801, 'PAY_GB_78139_INVALID_CO_REF');
1768: hr_utility.set_message_token('REFERENCE', l_reference);
1769: hr_utility.raise_error;
1770: END IF;
1771:

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

1764: THEN
1765: hr_utility.set_location('Ref is changed since previous payroll run: Raise Error',17);
1766:
1767: hr_utility.set_message(801, 'PAY_GB_78139_INVALID_CO_REF');
1768: hr_utility.set_message_token('REFERENCE', l_reference);
1769: hr_utility.raise_error;
1770: END IF;
1771:
1772: CLOSE csr_get_reference;

Line 1769: hr_utility.raise_error;

1765: hr_utility.set_location('Ref is changed since previous payroll run: Raise Error',17);
1766:
1767: hr_utility.set_message(801, 'PAY_GB_78139_INVALID_CO_REF');
1768: hr_utility.set_message_token('REFERENCE', l_reference);
1769: hr_utility.raise_error;
1770: END IF;
1771:
1772: CLOSE csr_get_reference;
1773: END IF;

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

1775: CLOSE csr_get_results;
1776: END IF;
1777: END IF;
1778:
1779: hr_utility.set_location('Leaving procedure pqp_gb_ad_ee.AU_VAL_REF_COURT_ORDER',18);
1780:
1781: END AU_VAL_REF_COURT_ORDER;
1782:
1783: --For bug 7294977: End