DBA Data[Home] [Help]

APPS.PQP_GB_UNPAID_TEMPLATE dependencies on HR_UTILITY

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

660: IF csr_chk_uniq_type%FOUND THEN
661:
662: -- Raise error
663: CLOSE csr_chk_uniq_type;
664: hr_utility.set_message(0, 'QC-DUPLICATE TYPE');
665: hr_utility.raise_error;
666:
667: END IF; -- End if of unique lookup type check ...
668: CLOSE csr_chk_uniq_type;

Line 665: hr_utility.raise_error;

661:
662: -- Raise error
663: CLOSE csr_chk_uniq_type;
664: hr_utility.set_message(0, 'QC-DUPLICATE TYPE');
665: hr_utility.raise_error;
666:
667: END IF; -- End if of unique lookup type check ...
668: CLOSE csr_chk_uniq_type;
669:

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

680: IF csr_chk_uniq_meaning%FOUND THEN
681:
682: -- Raise error
683: CLOSE csr_chk_uniq_meaning;
684: hr_utility.set_message(0, 'QC-DUPLICATE TYPE MEANING');
685: hr_utility.raise_error;
686:
687: END IF; -- End if of unique lookup type meaning check ...
688: CLOSE csr_chk_uniq_meaning;

Line 685: hr_utility.raise_error;

681:
682: -- Raise error
683: CLOSE csr_chk_uniq_meaning;
684: hr_utility.set_message(0, 'QC-DUPLICATE TYPE MEANING');
685: hr_utility.raise_error;
686:
687: END IF; -- End if of unique lookup type meaning check ...
688: CLOSE csr_chk_uniq_meaning;
689:

Line 971: g_debug := hr_utility.debug_enabled;

967:
968: BEGIN
969:
970:
971: g_debug := hr_utility.debug_enabled;
972:
973: debug_enter(l_proc_name);
974:
975: ---------------------

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

986: END IF;
987:
988: --
989:
990: IF (hr_utility.chk_product_install('Oracle Payroll',g_template_leg_code))
991: THEN
992:
993: l_exc_sec_days_bf := NULL;
994:

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

1008: IF csr_chk_primary_exists%NOTFOUND THEN
1009:
1010: -- Raise Error
1011: CLOSE csr_chk_primary_exists;
1012: hr_utility.set_message(8303, 'PQP_230608_OSP_PRIM_NOT_FOUND');
1013: hr_utility.raise_error;
1014:
1015: END IF; -- End if of primary element check...
1016:

Line 1013: hr_utility.raise_error;

1009:
1010: -- Raise Error
1011: CLOSE csr_chk_primary_exists;
1012: hr_utility.set_message(8303, 'PQP_230608_OSP_PRIM_NOT_FOUND');
1013: hr_utility.raise_error;
1014:
1015: END IF; -- End if of primary element check...
1016:
1017: -- Exclude balance feeds to generic days balance for secondary elements

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

1025: IF csr_chk_primary_exists%FOUND THEN
1026:
1027: -- Raise Error
1028: CLOSE csr_chk_primary_exists;
1029: hr_utility.set_message(8303, 'PQP_230666_OSP_PRIMARY_EXISTS');
1030: hr_utility.raise_error;
1031:
1032: END IF; -- End if of primary element check...
1033:

Line 1030: hr_utility.raise_error;

1026:
1027: -- Raise Error
1028: CLOSE csr_chk_primary_exists;
1029: hr_utility.set_message(8303, 'PQP_230666_OSP_PRIMARY_EXISTS');
1030: hr_utility.raise_error;
1031:
1032: END IF; -- End if of primary element check...
1033:
1034: END IF; -- End if of abs primary yes or no check...

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

1528: END IF;
1529:
1530: ELSE
1531:
1532: hr_utility.set_message(8303, 'PQP_230535_GBORAPAY_NOT_FOUND');
1533: hr_utility.raise_error;
1534:
1535:
1536: END IF; -- IF chk_product_install('Oracle Payroll',g_template_leg_code))

Line 1533: hr_utility.raise_error;

1529:
1530: ELSE
1531:
1532: hr_utility.set_message(8303, 'PQP_230535_GBORAPAY_NOT_FOUND');
1533: hr_utility.raise_error;
1534:
1535:
1536: END IF; -- IF chk_product_install('Oracle Payroll',g_template_leg_code))
1537:

Line 1545: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1541:
1542: EXCEPTION
1543: WHEN OTHERS THEN
1544: clear_cache;
1545: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1546: debug_others(l_proc_name,l_proc_step);
1547: IF g_debug THEN
1548: debug('Leaving: '||l_proc_name,-999);
1549: END IF;

Line 2092: g_debug := hr_utility.debug_enabled;

2088: -- for Multi Messages
2089: hr_multi_message.enable_message_list;
2090:
2091: --
2092: g_debug := hr_utility.debug_enabled;
2093: IF g_debug THEN
2094: debug_enter(l_proc_name);
2095: END IF;
2096: --

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

2139: IF csr_chk_sec_ele%FOUND THEN
2140:
2141: -- Raise error
2142: CLOSE csr_chk_sec_ele;
2143: hr_utility.set_message (8303,'PQP_230607_OSP_SEC_ELE_EXISTS');
2144: hr_utility.raise_error;
2145:
2146: END IF; -- End if of sec element check ...
2147: CLOSE csr_chk_sec_ele;

Line 2144: hr_utility.raise_error;

2140:
2141: -- Raise error
2142: CLOSE csr_chk_sec_ele;
2143: hr_utility.set_message (8303,'PQP_230607_OSP_SEC_ELE_EXISTS');
2144: hr_utility.raise_error;
2145:
2146: END IF; -- End if of sec element check ...
2147: CLOSE csr_chk_sec_ele;
2148:

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

2185: IF csr_chk_ele_in_ben%FOUND THEN
2186:
2187: -- Raise Error
2188: Close csr_chk_ele_in_ben;
2189: hr_utility.set_message (800,'PER_74880_CHILD_RECORD');
2190: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');
2191: hr_utility.raise_error;
2192:
2193: END IF; -- End if of element in ben check ...

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

2186:
2187: -- Raise Error
2188: Close csr_chk_ele_in_ben;
2189: hr_utility.set_message (800,'PER_74880_CHILD_RECORD');
2190: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');
2191: hr_utility.raise_error;
2192:
2193: END IF; -- End if of element in ben check ...
2194: CLOSE csr_chk_ele_in_ben;

Line 2191: hr_utility.raise_error;

2187: -- Raise Error
2188: Close csr_chk_ele_in_ben;
2189: hr_utility.set_message (800,'PER_74880_CHILD_RECORD');
2190: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');
2191: hr_utility.raise_error;
2192:
2193: END IF; -- End if of element in ben check ...
2194: CLOSE csr_chk_ele_in_ben;
2195: