305: AND org_information2 = p_org_information2
306: AND organization_id = p_organization_id;
307: BEGIN
308:
309: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
310: IF g_debug THEN
311: pay_in_utils.trace('IN Legislation not installed. Not performing the validations',NULL);
312: END IF;
313: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
314: RETURN;
315: END IF;
316:
317: l_procedure := g_package||'check_unique_num_ins';
318: g_debug := hr_utility.debug_enabled;
319: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
320:
321: IF g_debug THEN
322: pay_in_utils.trace('**************************************************','********************');
829: AND organization_id = p_organization_id;
830:
831: BEGIN
832:
833: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
834: IF g_debug THEN
835: pay_in_utils.trace('IN Legislation not installed. Not performing the validations',NULL);
836: END IF;
837: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
838: RETURN;
839: END IF;
840:
841: l_procedure := g_package||'check_unique_num_upd';
842: g_debug := hr_utility.debug_enabled;
843: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
844:
845: IF g_debug THEN
846: pay_in_utils.trace('**************************************************','********************');
1202: l_message VARCHAR2(300);
1203: BEGIN
1204:
1205: l_procedure := g_package||'validate_date';
1206: g_debug := hr_utility.debug_enabled;
1207: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1208:
1209: IF g_debug THEN
1210: pay_in_utils.trace('**************************************************','********************');
1272: i NUMBER;
1273: BEGIN
1274:
1275: l_procedure := g_package||'validate_corporate_number';
1276: g_debug := hr_utility.debug_enabled;
1277: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1278:
1279: IF g_debug THEN
1280: pay_in_utils.trace('**************************************************','********************');
1408:
1409:
1410: BEGIN
1411:
1412: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
1413: IF g_debug THEN
1414: pay_in_utils.trace('IN Legislation not installed. Not performing the validations',NULL);
1415: END IF;
1416: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1417: RETURN;
1418: END IF;
1419:
1420: l_procedure := g_package||'check_rep_ins';
1421: g_debug := hr_utility.debug_enabled;
1422: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1423:
1424: IF g_debug THEN
1425: pay_in_utils.trace('**************************************************','********************');
1695:
1696:
1697: BEGIN
1698:
1699: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
1700: IF g_debug THEN
1701: pay_in_utils.trace('IN Legislation not installed. Not performing the validations',NULL);
1702: END IF;
1703: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1704: RETURN;
1705: END IF;
1706:
1707: l_procedure := g_package||'check_rep_upd';
1708: g_debug := hr_utility.debug_enabled;
1709: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1710:
1711: IF g_debug THEN
1712: pay_in_utils.trace('**************************************************','********************');
1974: l_procedure VARCHAR2(100);
1975: l_message VARCHAR2(300);
1976: BEGIN
1977:
1978: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
1979: IF g_debug THEN
1980: pay_in_utils.trace('IN Legislation not installed. Not performing the validations',NULL);
1981: END IF;
1982: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1984: END IF;
1985: p_message_name := 'SUCCESS';
1986: pay_in_utils.null_message(p_token_name, p_token_value);
1987: l_procedure := g_package||'CHECK_PF_CHALLANS';
1988: g_debug := hr_utility.debug_enabled;
1989: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1990:
1991: IF g_debug THEN
1992: pay_in_utils.trace('**************************************************','********************');
2071: l_procedure VARCHAR2(100);
2072: l_message VARCHAR2(300);
2073: BEGIN
2074:
2075: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
2076: IF g_debug THEN
2077: pay_in_utils.trace('IN Legislation not installed. Not performing the validations',NULL);
2078: END IF;
2079: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
2081: END IF;
2082: p_message_name := 'SUCCESS';
2083: pay_in_utils.null_message(p_token_name, p_token_value);
2084: l_procedure := g_package||'chk_mon_pf_chn_acc';
2085: g_debug := hr_utility.debug_enabled;
2086: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
2087:
2088: IF g_debug THEN
2089: pay_in_utils.trace('**************************************************','********************');
2183: l_procedure VARCHAR2(100);
2184: l_message VARCHAR2(300);
2185: BEGIN
2186:
2187: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
2188: IF g_debug THEN
2189: pay_in_utils.trace('IN Legislation not installed. Not performing the validations',NULL);
2190: END IF;
2191: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
2193: END IF;
2194: p_message_name := 'SUCCESS';
2195: pay_in_utils.null_message(p_token_name, p_token_value);
2196: l_procedure := g_package||'check_lwf_challan_accounts';
2197: g_debug := hr_utility.debug_enabled;
2198: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
2199:
2200: IF g_debug THEN
2201: pay_in_utils.trace('**************************************************','********************');
2257: l_procedure VARCHAR2(100);
2258: l_message VARCHAR2(300);
2259: BEGIN
2260:
2261: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
2262: IF g_debug THEN
2263: pay_in_utils.trace('IN Legislation not installed. Not performing the validations',NULL);
2264: END IF;
2265: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
2267: END IF;
2268: p_message_name := 'SUCCESS';
2269: pay_in_utils.null_message(p_token_name, p_token_value);
2270: l_procedure := g_package||'check_lwf_contribution_freq';
2271: g_debug := hr_utility.debug_enabled;
2272: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
2273:
2274: IF g_debug THEN
2275: pay_in_utils.trace('**************************************************','********************');
2374: BEGIN
2375:
2376:
2377: l_procedure := g_package||'check_org_internal';
2378: g_debug := hr_utility.debug_enabled;
2379: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
2380:
2381: IF g_debug THEN
2382: pay_in_utils.trace('**************************************************','********************');
2393:
2394: p_message_name := 'SUCCESS';
2395: pay_in_utils.null_message(p_token_name, p_token_value);
2396:
2397: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
2398: IF g_debug THEN
2399: pay_in_utils.trace('IN Legislation not installed. Not performing the validations',NULL);
2400: END IF;
2401: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
2476:
2477: BEGIN
2478:
2479: l_procedure := g_package||'check_organization_update';
2480: g_debug := hr_utility.debug_enabled;
2481: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
2482:
2483: IF g_debug THEN
2484: pay_in_utils.trace('**************************************************','********************');
2586:
2587: BEGIN
2588:
2589: l_procedure := g_package||'check_org_class_internal';
2590: g_debug := hr_utility.debug_enabled;
2591: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
2592:
2593: IF g_debug THEN
2594: pay_in_utils.trace('**************************************************','********************');
2663:
2664: BEGIN
2665:
2666: l_procedure := g_package||'check_org_class_create';
2667: g_debug := hr_utility.debug_enabled;
2668: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
2669:
2670: IF g_debug THEN
2671: pay_in_utils.trace('**************************************************','********************');
2846: l_pf_chn_no_chk VARCHAR2(2);
2847:
2848: BEGIN
2849: l_procedure := g_package||'check_org_info_internal';
2850: g_debug := hr_utility.debug_enabled;
2851: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
2852:
2853: p_message_name := 'SUCCESS';
2854: pay_in_utils.null_message(p_token_name, p_token_value);
2852:
2853: p_message_name := 'SUCCESS';
2854: pay_in_utils.null_message(p_token_name, p_token_value);
2855:
2856: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
2857: IF g_debug THEN
2858: pay_in_utils.trace('IN Legislation not installed. Not performing the validations',NULL);
2859: END IF;
2860: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
3586:
3587: BEGIN
3588:
3589: l_procedure := g_package||'check_org_info_create';
3590: g_debug := hr_utility.debug_enabled;
3591: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
3592:
3593: IF g_debug THEN
3594: pay_in_utils.trace('**************************************************','********************');
3784:
3785: BEGIN
3786:
3787: l_procedure := g_package||'check_org_info_update';
3788: g_debug := hr_utility.debug_enabled;
3789: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
3790:
3791: IF g_debug THEN
3792: pay_in_utils.trace('**************************************************','********************');