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;
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:
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;
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:
967:
968: BEGIN
969:
970:
971: g_debug := hr_utility.debug_enabled;
972:
973: debug_enter(l_proc_name);
974:
975: ---------------------
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:
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:
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
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:
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...
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))
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:
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;
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: --
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;
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:
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 ...
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;
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: