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

Line 241: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

237:
238: EXCEPTION
239: WHEN OTHERS THEN
240: clear_cache;
241: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
242: debug_others(l_proc_name,l_proc_step);
243: IF g_debug THEN
244: debug('Leaving: '||l_proc_name,-999);
245: END IF;

Line 271: g_debug := hr_utility.debug_enabled;

267: l_input_name VARCHAR2(40);
268:
269: BEGIN
270:
271: g_debug := hr_utility.debug_enabled;
272: debug_enter(l_proc_name);
273:
274: -- what to automate ?
275: -- 1. making plans active

Line 474: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

470:
471: EXCEPTION
472: WHEN OTHERS THEN
473: clear_cache;
474: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
475: debug_others(l_proc_name,l_proc_step);
476: IF g_debug THEN
477: debug('Leaving: '||l_proc_name,-999);
478: END IF;

Line 1564: hr_utility.set_message(0, 'QC-DUPLICATE TYPE');

1560: IF csr_chk_uniq_type%FOUND THEN
1561:
1562: -- Raise error
1563: CLOSE csr_chk_uniq_type;
1564: hr_utility.set_message(0, 'QC-DUPLICATE TYPE');
1565: hr_utility.raise_error;
1566:
1567: END IF; -- End if of unique lookup type check ...
1568: CLOSE csr_chk_uniq_type;

Line 1565: hr_utility.raise_error;

1561:
1562: -- Raise error
1563: CLOSE csr_chk_uniq_type;
1564: hr_utility.set_message(0, 'QC-DUPLICATE TYPE');
1565: hr_utility.raise_error;
1566:
1567: END IF; -- End if of unique lookup type check ...
1568: CLOSE csr_chk_uniq_type;
1569:

Line 1584: hr_utility.set_message(0, 'QC-DUPLICATE TYPE MEANING');

1580: IF csr_chk_uniq_meaning%FOUND THEN
1581:
1582: -- Raise error
1583: CLOSE csr_chk_uniq_meaning;
1584: hr_utility.set_message(0, 'QC-DUPLICATE TYPE MEANING');
1585: hr_utility.raise_error;
1586:
1587: END IF; -- End if of unique lookup type meaning check ...
1588: CLOSE csr_chk_uniq_meaning;

Line 1585: hr_utility.raise_error;

1581:
1582: -- Raise error
1583: CLOSE csr_chk_uniq_meaning;
1584: hr_utility.set_message(0, 'QC-DUPLICATE TYPE MEANING');
1585: hr_utility.raise_error;
1586:
1587: END IF; -- End if of unique lookup type meaning check ...
1588: CLOSE csr_chk_uniq_meaning;
1589:

Line 1724: hr_utility.set_message(0, 'QC-DUPLICATE TYPE');

1720: IF csr_chk_uniq_type%FOUND THEN
1721:
1722: -- Raise error
1723: CLOSE csr_chk_uniq_type;
1724: hr_utility.set_message(0, 'QC-DUPLICATE TYPE');
1725: hr_utility.raise_error;
1726:
1727: END IF; -- End if of unique lookup type check ...
1728: CLOSE csr_chk_uniq_type;

Line 1725: hr_utility.raise_error;

1721:
1722: -- Raise error
1723: CLOSE csr_chk_uniq_type;
1724: hr_utility.set_message(0, 'QC-DUPLICATE TYPE');
1725: hr_utility.raise_error;
1726:
1727: END IF; -- End if of unique lookup type check ...
1728: CLOSE csr_chk_uniq_type;
1729:

Line 1744: hr_utility.set_message(0, 'QC-DUPLICATE TYPE MEANING');

1740: IF csr_chk_uniq_meaning%FOUND THEN
1741:
1742: -- Raise error
1743: CLOSE csr_chk_uniq_meaning;
1744: hr_utility.set_message(0, 'QC-DUPLICATE TYPE MEANING');
1745: hr_utility.raise_error;
1746:
1747: END IF; -- End if of unique lookup type meaning check ...
1748: CLOSE csr_chk_uniq_meaning;

Line 1745: hr_utility.raise_error;

1741:
1742: -- Raise error
1743: CLOSE csr_chk_uniq_meaning;
1744: hr_utility.set_message(0, 'QC-DUPLICATE TYPE MEANING');
1745: hr_utility.raise_error;
1746:
1747: END IF; -- End if of unique lookup type meaning check ...
1748: CLOSE csr_chk_uniq_meaning;
1749:

Line 1844: g_debug := hr_utility.debug_enabled;

1840:
1841: BEGIN
1842:
1843:
1844: g_debug := hr_utility.debug_enabled;
1845:
1846: debug_enter(l_proc_name);
1847:
1848: ---------------------

Line 1863: IF (hr_utility.chk_product_install('Oracle Payroll',g_template_leg_code))

1859: END IF;
1860:
1861: --
1862:
1863: IF (hr_utility.chk_product_install('Oracle Payroll',g_template_leg_code))
1864: THEN
1865:
1866: l_exc_sec_days_bf := NULL;
1867:

Line 1885: hr_utility.set_message(8303, 'PQP_230608_OSP_PRIM_NOT_FOUND');

1881: IF csr_chk_primary_exists%NOTFOUND THEN
1882:
1883: -- Raise Error
1884: CLOSE csr_chk_primary_exists;
1885: hr_utility.set_message(8303, 'PQP_230608_OSP_PRIM_NOT_FOUND');
1886: hr_utility.raise_error;
1887:
1888: END IF; -- End if of primary element check...
1889:

Line 1886: hr_utility.raise_error;

1882:
1883: -- Raise Error
1884: CLOSE csr_chk_primary_exists;
1885: hr_utility.set_message(8303, 'PQP_230608_OSP_PRIM_NOT_FOUND');
1886: hr_utility.raise_error;
1887:
1888: END IF; -- End if of primary element check...
1889:
1890: -- Exclude balance feeds to generic days balance for secondary elements

Line 1902: hr_utility.set_message(8303, 'PQP_230666_OSP_PRIMARY_EXISTS');

1898: IF csr_chk_primary_exists%FOUND THEN
1899:
1900: -- Raise Error
1901: CLOSE csr_chk_primary_exists;
1902: hr_utility.set_message(8303, 'PQP_230666_OSP_PRIMARY_EXISTS');
1903: hr_utility.raise_error;
1904:
1905: END IF; -- End if of primary element check...
1906:

Line 1903: hr_utility.raise_error;

1899:
1900: -- Raise Error
1901: CLOSE csr_chk_primary_exists;
1902: hr_utility.set_message(8303, 'PQP_230666_OSP_PRIMARY_EXISTS');
1903: hr_utility.raise_error;
1904:
1905: END IF; -- End if of primary element check...
1906:
1907: END IF; -- End if of abs primary yes or no check...

Line 3189: hr_utility.set_message(8303, 'PQP_230535_GBORAPAY_NOT_FOUND');

3185:
3186:
3187: ELSE
3188:
3189: hr_utility.set_message(8303, 'PQP_230535_GBORAPAY_NOT_FOUND');
3190: hr_utility.raise_error;
3191:
3192:
3193: END IF; -- IF chk_product_install('Oracle Payroll',g_template_leg_code))

Line 3190: hr_utility.raise_error;

3186:
3187: ELSE
3188:
3189: hr_utility.set_message(8303, 'PQP_230535_GBORAPAY_NOT_FOUND');
3190: hr_utility.raise_error;
3191:
3192:
3193: END IF; -- IF chk_product_install('Oracle Payroll',g_template_leg_code))
3194:

Line 3202: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

3198:
3199: EXCEPTION
3200: WHEN OTHERS THEN
3201: clear_cache;
3202: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
3203: debug_others(l_proc_name,l_proc_step);
3204: IF g_debug THEN
3205: debug('Leaving: '||l_proc_name,-999);
3206: END IF;

Line 3755: g_debug := hr_utility.debug_enabled;

3751: -- for Multi Messages
3752: hr_multi_message.enable_message_list;
3753:
3754: --
3755: g_debug := hr_utility.debug_enabled;
3756: IF g_debug THEN
3757: debug_enter(l_proc_name);
3758: END IF;
3759: --

Line 3821: hr_utility.set_message (8303,'PQP_230607_OSP_SEC_ELE_EXISTS');

3817: IF csr_chk_sec_ele%FOUND THEN
3818:
3819: -- Raise error
3820: CLOSE csr_chk_sec_ele;
3821: hr_utility.set_message (8303,'PQP_230607_OSP_SEC_ELE_EXISTS');
3822: hr_utility.raise_error;
3823:
3824: END IF; -- End if of sec element check ...
3825: CLOSE csr_chk_sec_ele;

Line 3822: hr_utility.raise_error;

3818:
3819: -- Raise error
3820: CLOSE csr_chk_sec_ele;
3821: hr_utility.set_message (8303,'PQP_230607_OSP_SEC_ELE_EXISTS');
3822: hr_utility.raise_error;
3823:
3824: END IF; -- End if of sec element check ...
3825: CLOSE csr_chk_sec_ele;
3826:

Line 3869: hr_utility.set_message (800,'PER_74880_CHILD_RECORD');

3865: IF csr_chk_ele_in_ben%FOUND THEN
3866:
3867: -- Raise Error
3868: Close csr_chk_ele_in_ben;
3869: hr_utility.set_message (800,'PER_74880_CHILD_RECORD');
3870: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');
3871: hr_utility.raise_error;
3872:
3873: END IF; -- End if of element in ben check ...

Line 3870: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');

3866:
3867: -- Raise Error
3868: Close csr_chk_ele_in_ben;
3869: hr_utility.set_message (800,'PER_74880_CHILD_RECORD');
3870: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');
3871: hr_utility.raise_error;
3872:
3873: END IF; -- End if of element in ben check ...
3874: CLOSE csr_chk_ele_in_ben;

Line 3871: hr_utility.raise_error;

3867: -- Raise Error
3868: Close csr_chk_ele_in_ben;
3869: hr_utility.set_message (800,'PER_74880_CHILD_RECORD');
3870: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');
3871: hr_utility.raise_error;
3872:
3873: END IF; -- End if of element in ben check ...
3874: CLOSE csr_chk_ele_in_ben;
3875:

Line 4191: hr_utility.set_message(0, 'QC-DUPLICATE TYPE MEANING');

4187: IF csr_chk_uniq_meaning%FOUND THEN
4188:
4189: -- Raise error
4190: CLOSE csr_chk_uniq_meaning;
4191: hr_utility.set_message(0, 'QC-DUPLICATE TYPE MEANING');
4192: hr_utility.raise_error;
4193:
4194: END IF; -- End if of unique lookup type meaning check ...
4195: CLOSE csr_chk_uniq_meaning;

Line 4192: hr_utility.raise_error;

4188:
4189: -- Raise error
4190: CLOSE csr_chk_uniq_meaning;
4191: hr_utility.set_message(0, 'QC-DUPLICATE TYPE MEANING');
4192: hr_utility.raise_error;
4193:
4194: END IF; -- End if of unique lookup type meaning check ...
4195: CLOSE csr_chk_uniq_meaning;
4196:

Line 4261: hr_utility.set_message(0, 'QC-DUPLICATE MEANING');

4257: IF csr_chk_uniq_value_meaning%FOUND THEN
4258:
4259: -- Raise error
4260: CLOSE csr_chk_uniq_value_meaning;
4261: hr_utility.set_message(0, 'QC-DUPLICATE MEANING');
4262: hr_utility.raise_error;
4263:
4264: END IF; -- End if of lookup code meaning check ...
4265: CLOSE csr_chk_uniq_value_meaning;

Line 4262: hr_utility.raise_error;

4258:
4259: -- Raise error
4260: CLOSE csr_chk_uniq_value_meaning;
4261: hr_utility.set_message(0, 'QC-DUPLICATE MEANING');
4262: hr_utility.raise_error;
4263:
4264: END IF; -- End if of lookup code meaning check ...
4265: CLOSE csr_chk_uniq_value_meaning;
4266: