DBA Data[Home] [Help]

APPS.PQP_GB_AD_EE dependencies on PQP_GB_AD_EE

Line 1: PACKAGE BODY pqp_gb_ad_ee AS

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.';

Line 5: g_package varchar2(33) := 'pqp_gb_ad_ee.';

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
9: -- the next payroll run.

Line 37: 'pqp_gb_ad_ee.open_cm_ele_entries');

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;
41:

Line 58: 'pqp_gb_ad_ee.open_cm_ele_entries');

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;
62:

Line 500: 'pqp_gb_ad_ee.open_cm_ele_entries');

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;
504:

Line 513: 'pqp_gb_ad_ee.open_cm_ele_entries');

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;
517:

Line 570: 'pqp_gb_ad_ee.open_cm_ele_entries');

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;
574:

Line 592: 'pqp_gb_ad_ee.open_cm_ele_entries');

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;*/
596:

Line 615: 'pqp_gb_ad_ee.open_cm_ele_entries');

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;
619:

Line 639: 'pqp_gb_ad_ee.open_cm_ele_entries');

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;
643:

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 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 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 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 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

Line 1785: END pqp_gb_ad_ee;

1781: END AU_VAL_REF_COURT_ORDER;
1782:
1783: --For bug 7294977: End
1784:
1785: END pqp_gb_ad_ee;