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.PAY_CN_DEDUCTIONS dependencies on HR_CN_API

Line 56: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);

52:
53: BEGIN
54:
55: g_procedure_name := g_package_name||'get_phf_high_limit_exempt';
56: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);
57:
58: -- Check if user has eneter values for Employee contribution rates
59: OPEN c_phf_high_limit_exempt;
60: FETCH c_phf_high_limit_exempt INTO l_exempt_flag;

Line 63: hr_cn_api.set_location(g_debug,'l_exempt_flag: '|| l_exempt_flag, 15);

59: OPEN c_phf_high_limit_exempt;
60: FETCH c_phf_high_limit_exempt INTO l_exempt_flag;
61: CLOSE c_phf_high_limit_exempt;
62:
63: hr_cn_api.set_location(g_debug,'l_exempt_flag: '|| l_exempt_flag, 15);
64:
65: IF g_debug THEN
66: hr_utility.trace(' =======================================================');
67: hr_utility.trace(' . Exempt Flag : '||l_exempt_flag);

Line 353: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);

349: IS
350: l_message VARCHAR2(250);
351: BEGIN
352: g_procedure_name := g_package_name||'validate_cont_base_method';
353: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);
354:
355: IF p_cont_base_method in ( 'CITY AVE 60' , 'PROV AVE 60' ) THEN /* modified for 6828199 */
356:
357: IF p_average_salary IS NULL THEN

Line 359: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);

355: IF p_cont_base_method in ( 'CITY AVE 60' , 'PROV AVE 60' ) THEN /* modified for 6828199 */
356:
357: IF p_average_salary IS NULL THEN
358: p_return_segment := 'Average Salary'; --Bug#:3034481
359: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
360: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
361: RETURN FALSE;
362: END IF;
363:

Line 360: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);

356:
357: IF p_average_salary IS NULL THEN
358: p_return_segment := 'Average Salary'; --Bug#:3034481
359: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
360: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
361: RETURN FALSE;
362: END IF;
363:
364: ELSIF p_cont_base_method = 'CITY LOW LAST YR' THEN

Line 368: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);

364: ELSIF p_cont_base_method = 'CITY LOW LAST YR' THEN
365:
366: IF p_lowest_avg_salary IS NULL THEN
367: p_return_segment := 'Lowest Average Salary'; --Bug#:3034481
368: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
369: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
370: RETURN FALSE;
371: END IF;
372:

Line 369: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);

365:
366: IF p_lowest_avg_salary IS NULL THEN
367: p_return_segment := 'Lowest Average Salary'; --Bug#:3034481
368: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
369: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
370: RETURN FALSE;
371: END IF;
372:
373: ELSIF p_cont_base_method = 'FIXED' THEN

Line 378: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);

374:
375: IF p_fixed_amount IS NULL THEN
376: --Bug#:3034481
377: p_return_segment := 'Fixed Amount';
378: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
379: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
380: RETURN FALSE;
381: END IF;
382:

Line 379: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);

375: IF p_fixed_amount IS NULL THEN
376: --Bug#:3034481
377: p_return_segment := 'Fixed Amount';
378: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
379: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
380: RETURN FALSE;
381: END IF;
382:
383: END IF;

Line 385: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 30);

381: END IF;
382:
383: END IF;
384:
385: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 30);
386: RETURN TRUE;
387:
388: EXCEPTION
389: WHEN OTHERS THEN

Line 390: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

386: RETURN TRUE;
387:
388: EXCEPTION
389: WHEN OTHERS THEN
390: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
391: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
392: hr_utility.trace(l_message);
393: RETURN FALSE;
394:

Line 391: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);

387:
388: EXCEPTION
389: WHEN OTHERS THEN
390: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
391: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
392: hr_utility.trace(l_message);
393: RETURN FALSE;
394:
395: END validate_cont_base_method;

Line 431: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);

427: l_message VARCHAR2(250);
428: BEGIN
429:
430: g_procedure_name := g_package_name||'validate_switch_with_cont_base';
431: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);
432:
433:
434: IF p_switch_periodicity = 'YEARLY' THEN
435: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);

Line 435: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);

431: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);
432:
433:
434: IF p_switch_periodicity = 'YEARLY' THEN
435: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
436:
437: IF ( p_cont_base_method = 'AVE MTH' or p_cont_base_method = 'EMP PRIOR SWITCH' ) THEN
438: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 30);
439: RETURN TRUE;

Line 438: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 30);

434: IF p_switch_periodicity = 'YEARLY' THEN
435: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
436:
437: IF ( p_cont_base_method = 'AVE MTH' or p_cont_base_method = 'EMP PRIOR SWITCH' ) THEN
438: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 30);
439: RETURN TRUE;
440: ELSE
441: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 40);
442: RETURN FALSE;

Line 441: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 40);

437: IF ( p_cont_base_method = 'AVE MTH' or p_cont_base_method = 'EMP PRIOR SWITCH' ) THEN
438: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 30);
439: RETURN TRUE;
440: ELSE
441: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 40);
442: RETURN FALSE;
443: END IF;
444:
445: ELSIF p_switch_periodicity = 'MONTHLY' THEN

Line 446: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);

442: RETURN FALSE;
443: END IF;
444:
445: ELSIF p_switch_periodicity = 'MONTHLY' THEN
446: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);
447: IF ( p_cont_base_method = 'AVE MTH' or p_cont_base_method = 'EMP PRIOR SWITCH') THEN
448: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 60);
449: RETURN FALSE;
450: ELSE

Line 448: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 60);

444:
445: ELSIF p_switch_periodicity = 'MONTHLY' THEN
446: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);
447: IF ( p_cont_base_method = 'AVE MTH' or p_cont_base_method = 'EMP PRIOR SWITCH') THEN
448: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 60);
449: RETURN FALSE;
450: ELSE
451: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 70);
452: RETURN TRUE;

Line 451: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 70);

447: IF ( p_cont_base_method = 'AVE MTH' or p_cont_base_method = 'EMP PRIOR SWITCH') THEN
448: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 60);
449: RETURN FALSE;
450: ELSE
451: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 70);
452: RETURN TRUE;
453: END IF;
454:
455: END IF;

Line 457: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 80);

453: END IF;
454:
455: END IF;
456:
457: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 80);
458: RETURN TRUE;
459:
460: EXCEPTION
461: WHEN OTHERS THEN

Line 462: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

458: RETURN TRUE;
459:
460: EXCEPTION
461: WHEN OTHERS THEN
462: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
463: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 90);
464: hr_utility.trace(l_message);
465: RETURN FALSE;
466:

Line 463: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 90);

459:
460: EXCEPTION
461: WHEN OTHERS THEN
462: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
463: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 90);
464: hr_utility.trace(l_message);
465: RETURN FALSE;
466:
467:

Line 507: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);

503: l_message VARCHAR2(250);
504: BEGIN
505:
506: g_procedure_name := g_package_name||'validate_low_limit_method';
507: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);
508:
509: IF p_low_limit_method = 'CITY LOW AVE' THEN
510:
511: IF p_lowest_avg_salary IS NULL THEN

Line 513: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);

509: IF p_low_limit_method = 'CITY LOW AVE' THEN
510:
511: IF p_lowest_avg_salary IS NULL THEN
512: p_return_segment := 'Lowest Average Salary'; --Bug#:3034481
513: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
514: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
515: RETURN FALSE;
516: END IF;
517:

Line 514: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);

510:
511: IF p_lowest_avg_salary IS NULL THEN
512: p_return_segment := 'Lowest Average Salary'; --Bug#:3034481
513: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
514: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
515: RETURN FALSE;
516: END IF;
517:
518: ELSIF p_low_limit_method in ( 'MTH AVE PREV YEAR','PROV AVE PREV YEAR') THEN -- bug 6828199

Line 522: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);

518: ELSIF p_low_limit_method in ( 'MTH AVE PREV YEAR','PROV AVE PREV YEAR') THEN -- bug 6828199
519:
520: IF p_average_salary IS NULL THEN
521: p_return_segment := 'Average Salary'; --Bug#:3034481
522: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
523: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
524: RETURN FALSE;
525: END IF;
526:

Line 523: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);

519:
520: IF p_average_salary IS NULL THEN
521: p_return_segment := 'Average Salary'; --Bug#:3034481
522: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
523: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
524: RETURN FALSE;
525: END IF;
526:
527: ELSIF p_low_limit_method = 'FIXED' THEN

Line 531: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);

527: ELSIF p_low_limit_method = 'FIXED' THEN
528:
529: IF p_fixed_amount IS NULL THEN
530: p_return_segment := 'Low Limit Amount'; --Bug#:3034481
531: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
532: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
533: RETURN FALSE;
534: END IF;
535:

Line 532: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);

528:
529: IF p_fixed_amount IS NULL THEN
530: p_return_segment := 'Low Limit Amount'; --Bug#:3034481
531: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
532: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
533: RETURN FALSE;
534: END IF;
535:
536: END IF;

Line 538: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 30);

534: END IF;
535:
536: END IF;
537:
538: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 30);
539: RETURN TRUE;
540:
541: EXCEPTION
542: WHEN OTHERS THEN

Line 543: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

539: RETURN TRUE;
540:
541: EXCEPTION
542: WHEN OTHERS THEN
543: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
544: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
545: hr_utility.trace(l_message);
546: RETURN FALSE;
547:

Line 544: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);

540:
541: EXCEPTION
542: WHEN OTHERS THEN
543: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
544: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
545: hr_utility.trace(l_message);
546: RETURN FALSE;
547:
548: END validate_low_limit_method;

Line 585: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);

581: l_message VARCHAR2(250);
582: BEGIN
583:
584: g_procedure_name := g_package_name||'validate_high_limit_method';
585: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);
586:
587: IF p_high_limit_method in ( 'MTH AVE PREV YEAR' , 'PROV AVE PREV YEAR' ,'CTY AVE PREV YEAR') THEN -- Bug 6828199
588:
589: IF p_average_salary IS NULL THEN

Line 591: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);

587: IF p_high_limit_method in ( 'MTH AVE PREV YEAR' , 'PROV AVE PREV YEAR' ,'CTY AVE PREV YEAR') THEN -- Bug 6828199
588:
589: IF p_average_salary IS NULL THEN
590: p_return_segment := 'Average Salary'; --Bug#:3034481
591: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
592: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
593: RETURN FALSE;
594: END IF;
595:

Line 592: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);

588:
589: IF p_average_salary IS NULL THEN
590: p_return_segment := 'Average Salary'; --Bug#:3034481
591: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
592: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
593: RETURN FALSE;
594: END IF;
595:
596: ELSIF p_high_limit_method = 'FIXED' THEN

Line 600: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);

596: ELSIF p_high_limit_method = 'FIXED' THEN
597:
598: IF p_fixed_amount IS NULL THEN
599: p_return_segment := 'High Limit Amount'; --Bug#:3034481
600: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
601: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
602: RETURN FALSE;
603: END IF;
604:

Line 601: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);

597:
598: IF p_fixed_amount IS NULL THEN
599: p_return_segment := 'High Limit Amount'; --Bug#:3034481
600: hr_cn_api.set_location(g_debug,' Return Segment : '||p_return_segment,15);
601: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
602: RETURN FALSE;
603: END IF;
604:
605: END IF;

Line 607: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 30);

603: END IF;
604:
605: END IF;
606:
607: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 30);
608: RETURN TRUE;
609:
610: EXCEPTION
611: WHEN OTHERS THEN

Line 612: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

608: RETURN TRUE;
609:
610: EXCEPTION
611: WHEN OTHERS THEN
612: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
613: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
614: hr_utility.trace(l_message);
615: RETURN FALSE;
616:

Line 613: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);

609:
610: EXCEPTION
611: WHEN OTHERS THEN
612: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
613: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
614: hr_utility.trace(l_message);
615: RETURN FALSE;
616:
617: END validate_high_limit_method;

Line 646: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);

642: l_amount NUMBER ;
643: l_message VARCHAR2(255);
644: BEGIN
645: g_procedure_name := g_package_name||'get_rounded_value';
646: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);
647: IF g_debug THEN
648: hr_utility.trace('=======================================================');
649: hr_utility.trace(' P_Value : '||TO_CHAR(p_value));
650: hr_utility.trace(' P_Rounding_Method : '||p_rounding_method);

Line 679: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);

675: IF g_debug THEN
676: hr_utility.trace(' P_Rounded_Value : '||TO_CHAR(l_amount));
677: hr_utility.trace('=======================================================');
678: END IF ;
679: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
680: RETURN l_amount;
681:
682: EXCEPTION
683: WHEN OTHERS THEN

Line 684: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

680: RETURN l_amount;
681:
682: EXCEPTION
683: WHEN OTHERS THEN
684: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
685: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
686: hr_utility.trace(l_message);
687: RETURN 0;
688: END get_rounded_value;

Line 685: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);

681:
682: EXCEPTION
683: WHEN OTHERS THEN
684: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
685: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
686: hr_utility.trace(l_message);
687: RETURN 0;
688: END get_rounded_value;
689:

Line 840: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);

836:
837: BEGIN
838:
839: g_procedure_name := g_package_name||'get_cont_base_methods';
840: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);
841:
842: l_found_flag := 'Y';
843: --
844: -- Check for the given hukou_type

Line 867: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);

863:
864: IF c_cont1%NOTFOUND THEN
865: --
866: OPEN c_cont2 ;
867: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
868: --
869: -- Bug 3017511 changes. FETCH c_cont1 changed to FETCH c_cont2
870: --
871: FETCH c_cont2 INTO

Line 889: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);

885: ,p_tax_thrhld_amount; -- added for bug 6828199
886:
887: IF c_cont2%NOTFOUND THEN
888: --
889: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);
890: l_found_flag := 'N';
891: --
892: END IF;
893: CLOSE c_cont2;

Line 898: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);

894: --
895: END IF;
896: CLOSE c_cont1;
897:
898: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);
899:
900: IF g_debug THEN
901: hr_utility.trace(' =======================================================');
902: hr_utility.trace(' . EE Cont Base Method : '||p_ee_cont_base_method);

Line 921: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);

917: END IF;
918:
919: IF l_found_flag = 'N' THEN
920: --Bug 3034481
921: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);
922: l_lookup_meaning := hr_general.decode_lookup(p_lookup_type => 'CN_PHF_SI_CODE'
923: ,p_lookup_code => p_phf_si_type
924: );
925: l_message := hr_cn_api.get_pay_message('HR_374609_CONT_BASE_MISSING','PHFSI:'||l_lookup_meaning);

Line 925: l_message := hr_cn_api.get_pay_message('HR_374609_CONT_BASE_MISSING','PHFSI:'||l_lookup_meaning);

921: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);
922: l_lookup_meaning := hr_general.decode_lookup(p_lookup_type => 'CN_PHF_SI_CODE'
923: ,p_lookup_code => p_phf_si_type
924: );
925: l_message := hr_cn_api.get_pay_message('HR_374609_CONT_BASE_MISSING','PHFSI:'||l_lookup_meaning);
926: --Bug 3034481
927:
928: -- Bug 3017511 added the following return clause
929: RETURN l_message;

Line 932: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 60);

928: -- Bug 3017511 added the following return clause
929: RETURN l_message;
930:
931: ELSE
932: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 60);
933: l_message := 'SUCCESS';
934: END IF;
935:
936: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 140);

Line 936: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 140);

932: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 60);
933: l_message := 'SUCCESS';
934: END IF;
935:
936: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 140);
937:
938: RETURN l_message;
939:
940:

Line 954: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

950: IF c_cont2%ISOPEN THEN
951: CLOSE c_cont2;
952: END IF;
953:
954: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
955: hr_utility.trace(l_message);
956: RETURN l_message;
957:
958: END get_cont_base_methods;

Line 1188: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);

1184:
1185: BEGIN
1186:
1187: g_procedure_name := g_package_name||'get_phf_si_rates';
1188: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);
1189:
1190: l_message :='SUCCESS';
1191: --
1192: -- Bug 3593118

Line 1196: hr_cn_api.set_location(g_debug,' Enerprise Annuity ', 11);

1192: -- Bug 3593118
1193: -- Enterprise Annuity Starts
1194: --
1195: IF p_phf_si_type = 'ENTANN' THEN
1196: hr_cn_api.set_location(g_debug,' Enerprise Annuity ', 11);
1197: --
1198: -- Find Number of Years of Service for the assignment
1199: --
1200: IF p_assignment_id IS NULL THEN

Line 1209: hr_cn_api.set_location(g_debug,' Years of Service '|| l_yrs_of_srvc, 12);

1205: FETCH csr_years_of_service INTO l_yrs_of_srvc;
1206: CLOSE csr_years_of_service;
1207: END IF;
1208:
1209: hr_cn_api.set_location(g_debug,' Years of Service '|| l_yrs_of_srvc, 12);
1210:
1211: -- Check if user has eneter values for Employer contribution rates
1212: OPEN csr_count_inst('China Enterprise Annuity Contribution Rate','Employer Rate', p_effective_date);
1213: FETCH csr_count_inst INTO l_count_ut;

Line 1216: hr_cn_api.set_location(g_debug,' Employer rate specified in UT, Num of records '|| l_count_ut, 13);

1212: OPEN csr_count_inst('China Enterprise Annuity Contribution Rate','Employer Rate', p_effective_date);
1213: FETCH csr_count_inst INTO l_count_ut;
1214: CLOSE csr_count_inst;
1215:
1216: hr_cn_api.set_location(g_debug,' Employer rate specified in UT, Num of records '|| l_count_ut, 13);
1217:
1218: IF l_count_ut > 0 THEN
1219: -- Fetch Employer Contribution Rate
1220: l_er_rate := fnd_number.canonical_to_number(hr_cn_api.get_user_table_value

Line 1220: l_er_rate := fnd_number.canonical_to_number(hr_cn_api.get_user_table_value

1216: hr_cn_api.set_location(g_debug,' Employer rate specified in UT, Num of records '|| l_count_ut, 13);
1217:
1218: IF l_count_ut > 0 THEN
1219: -- Fetch Employer Contribution Rate
1220: l_er_rate := fnd_number.canonical_to_number(hr_cn_api.get_user_table_value
1221: (p_business_group_id => p_business_group_id
1222: ,p_table_name => 'China Enterprise Annuity Contribution Rate'
1223: ,p_column_name => 'Employer Rate'
1224: ,p_row_name => 'Employer Rate'

Line 1229: hr_cn_api.set_location(g_debug,' Employer rate '|| l_er_rate, 14);

1225: ,p_row_value => fnd_number.number_to_canonical(l_yrs_of_srvc)
1226: ,p_effective_date => p_effective_date
1227: ,p_message => l_ut_message));
1228:
1229: hr_cn_api.set_location(g_debug,' Employer rate '|| l_er_rate, 14);
1230:
1231: IF l_ut_message <> 'SUCCESS' THEN
1232: -- If user has not specified matching range values, then
1233: -- go on to fetch from PHF/SI rates set up at organization level.

Line 1234: hr_cn_api.set_location(g_debug,' Returned message Not Success', 14);

1230:
1231: IF l_ut_message <> 'SUCCESS' THEN
1232: -- If user has not specified matching range values, then
1233: -- go on to fetch from PHF/SI rates set up at organization level.
1234: hr_cn_api.set_location(g_debug,' Returned message Not Success', 14);
1235: l_er_rate := NULL;
1236: END IF;
1237: END IF;
1238:

Line 1244: hr_cn_api.set_location(g_debug,' Employee rate specified in UT, Num of records '|| l_count_ut, 15);

1240: OPEN csr_count_inst('China Enterprise Annuity Contribution Rate', 'Employee Rate', p_effective_date);
1241: FETCH csr_count_inst INTO l_count_ut;
1242: CLOSE csr_count_inst;
1243:
1244: hr_cn_api.set_location(g_debug,' Employee rate specified in UT, Num of records '|| l_count_ut, 15);
1245:
1246: IF l_count_ut > 0 THEN
1247: -- Fetch Employee Contribution Rate
1248: l_ee_rate := fnd_number.canonical_to_number(hr_cn_api.get_user_table_value

Line 1248: l_ee_rate := fnd_number.canonical_to_number(hr_cn_api.get_user_table_value

1244: hr_cn_api.set_location(g_debug,' Employee rate specified in UT, Num of records '|| l_count_ut, 15);
1245:
1246: IF l_count_ut > 0 THEN
1247: -- Fetch Employee Contribution Rate
1248: l_ee_rate := fnd_number.canonical_to_number(hr_cn_api.get_user_table_value
1249: (p_business_group_id => p_business_group_id
1250: ,p_table_name => 'China Enterprise Annuity Contribution Rate'
1251: ,p_column_name => 'Employee Rate'
1252: ,p_row_name => 'Employee Rate'

Line 1257: hr_cn_api.set_location(g_debug,' Employee rate '|| l_ee_rate, 16);

1253: ,p_row_value => fnd_number.number_to_canonical(l_yrs_of_srvc)
1254: ,p_effective_date => p_effective_date
1255: ,p_message => l_ut_message));
1256:
1257: hr_cn_api.set_location(g_debug,' Employee rate '|| l_ee_rate, 16);
1258:
1259: IF l_ut_message <> 'SUCCESS' THEN
1260: -- If user has not specified matching range values, then
1261: -- go on to fetch from PHF/SI rates set up at organization level.

Line 1262: hr_cn_api.set_location(g_debug,' Returned message Not Success', 16);

1258:
1259: IF l_ut_message <> 'SUCCESS' THEN
1260: -- If user has not specified matching range values, then
1261: -- go on to fetch from PHF/SI rates set up at organization level.
1262: hr_cn_api.set_location(g_debug,' Returned message Not Success', 16);
1263: l_ee_rate := NULL;
1264: END IF;
1265:
1266: END IF;

Line 1269: hr_cn_api.set_location(g_debug,' Both Employee and Employer rate Specified at UT', 17);

1265:
1266: END IF;
1267:
1268: IF l_er_rate IS NOT NULL AND l_ee_rate IS NOT NULL THEN
1269: hr_cn_api.set_location(g_debug,' Both Employee and Employer rate Specified at UT', 17);
1270: p_er_rate := l_er_rate;
1271: p_ee_rate := l_ee_rate;
1272: p_er_rate_type := 'PERCENTAGE';
1273: p_ee_rate_type := 'PERCENTAGE';

Line 1323: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);

1319:
1320:
1321: IF c_org1%NOTFOUND THEN
1322: --
1323: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
1324: OPEN c_org2;
1325: FETCH c_org2 INTO
1326: p_ee_rate
1327: ,p_ee_rate_type

Line 1339: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);

1335:
1336:
1337: IF c_org2%NOTFOUND THEN
1338:
1339: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);
1340: OPEN c_org3;
1341: FETCH c_org3 INTO
1342: p_ee_rate
1343: ,p_ee_rate_type

Line 1354: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);

1350:
1351:
1352: IF c_org3%NOTFOUND THEN
1353:
1354: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);
1355: OPEN c_org4;
1356: FETCH c_org4 INTO
1357: p_ee_rate
1358: ,p_ee_rate_type

Line 1368: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);

1364: ,p_er_thrhld_rate; -- for bug 6828199
1365:
1366:
1367: IF c_org4%NOTFOUND THEN
1368: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);
1369: l_message := hr_cn_api.get_pay_message('HR_374608_PHF_SI_RATES_MISSING','PHFSI:'||p_phf_si_type);
1370: IF g_debug THEN
1371: hr_utility.trace(l_message);
1372: END IF;

Line 1369: l_message := hr_cn_api.get_pay_message('HR_374608_PHF_SI_RATES_MISSING','PHFSI:'||p_phf_si_type);

1365:
1366:
1367: IF c_org4%NOTFOUND THEN
1368: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);
1369: l_message := hr_cn_api.get_pay_message('HR_374608_PHF_SI_RATES_MISSING','PHFSI:'||p_phf_si_type);
1370: IF g_debug THEN
1371: hr_utility.trace(l_message);
1372: END IF;
1373: END IF;

Line 1423: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 70);

1419: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);
1420: hr_utility.trace(' =======================================================');
1421: END IF;
1422:
1423: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 70);
1424: RETURN l_message;
1425:
1426: EXCEPTION
1427: WHEN OTHERS THEN

Line 1428: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

1424: RETURN l_message;
1425:
1426: EXCEPTION
1427: WHEN OTHERS THEN
1428: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1429:
1430: IF c_org4%ISOPEN THEN
1431: CLOSE c_org4;
1432: END IF;

Line 1495: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);

1491: l_message VARCHAR2(255);
1492:
1493: BEGIN
1494: g_procedure_name := g_package_name||'get_cont_base_amount';
1495: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);
1496:
1497: l_message := '';
1498:
1499: IF p_cont_base_method = 'AVE MTH' THEN

Line 1505: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);

1501: -- Bug 3017511 Changed the SELECT DECODE.. to IF..THEN..ELSE conditions
1502: --
1503: IF p_phf_si_earnings_asg_avg = 0 THEN
1504: IF p_phf_si_earnings_asg_pmth = 0 THEN
1505: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
1506: l_cont_base_amount := p_phf_si_earnings_asg_ptd;
1507: ELSE
1508: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);
1509: l_cont_base_amount := p_phf_si_earnings_asg_pmth;

Line 1508: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);

1504: IF p_phf_si_earnings_asg_pmth = 0 THEN
1505: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
1506: l_cont_base_amount := p_phf_si_earnings_asg_ptd;
1507: ELSE
1508: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);
1509: l_cont_base_amount := p_phf_si_earnings_asg_pmth;
1510: END IF;
1511: ELSE
1512: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);

Line 1512: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);

1508: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);
1509: l_cont_base_amount := p_phf_si_earnings_asg_pmth;
1510: END IF;
1511: ELSE
1512: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);
1513: l_cont_base_amount := p_phf_si_earnings_asg_avg;
1514: END IF;
1515:
1516: ELSIF p_cont_base_method = 'CURRENT' THEN

Line 1517: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);

1513: l_cont_base_amount := p_phf_si_earnings_asg_avg;
1514: END IF;
1515:
1516: ELSIF p_cont_base_method = 'CURRENT' THEN
1517: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);
1518: l_cont_base_amount:= p_phf_si_earnings_asg_ptd;
1519: --
1520: -- Bug 3038490. Changed the mis-spelt EMP PRIOR SWITCH
1521: --

Line 1523: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 60);

1519: --
1520: -- Bug 3038490. Changed the mis-spelt EMP PRIOR SWITCH
1521: --
1522: ELSIF p_cont_base_method in ('PREVIOUS','EMP PRIOR SWITCH') THEN
1523: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 60);
1524: --
1525: -- Bug 3017511 Changed the SELECT DECODE.. to IF..THEN..ELSE conditions
1526: --
1527: IF p_phf_si_earnings_asg_pmth = 0 THEN

Line 1528: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 70);

1524: --
1525: -- Bug 3017511 Changed the SELECT DECODE.. to IF..THEN..ELSE conditions
1526: --
1527: IF p_phf_si_earnings_asg_pmth = 0 THEN
1528: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 70);
1529: l_cont_base_amount := p_phf_si_earnings_asg_ptd;
1530: ELSE
1531: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 80);
1532: l_cont_base_amount := p_phf_si_earnings_asg_pmth;

Line 1531: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 80);

1527: IF p_phf_si_earnings_asg_pmth = 0 THEN
1528: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 70);
1529: l_cont_base_amount := p_phf_si_earnings_asg_ptd;
1530: ELSE
1531: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 80);
1532: l_cont_base_amount := p_phf_si_earnings_asg_pmth;
1533: END IF;
1534:
1535: ELSIF p_cont_base_method in ( 'CITY AVE 60', 'PROV AVE 60' ) THEN /* modified for 6828199 */

Line 1536: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 90);

1532: l_cont_base_amount := p_phf_si_earnings_asg_pmth;
1533: END IF;
1534:
1535: ELSIF p_cont_base_method in ( 'CITY AVE 60', 'PROV AVE 60' ) THEN /* modified for 6828199 */
1536: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 90);
1537: l_cont_base_amount:= 0.6*p_average_salary;
1538:
1539: ELSIF p_cont_base_method = 'CITY LOW LAST YR' THEN
1540: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 100);

Line 1540: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 100);

1536: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 90);
1537: l_cont_base_amount:= 0.6*p_average_salary;
1538:
1539: ELSIF p_cont_base_method = 'CITY LOW LAST YR' THEN
1540: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 100);
1541:
1542: l_cont_base_amount:= p_lowest_average_salary;
1543:
1544: ELSIF p_cont_base_method = 'FIXED' THEN

Line 1545: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 110);

1541:
1542: l_cont_base_amount:= p_lowest_average_salary;
1543:
1544: ELSIF p_cont_base_method = 'FIXED' THEN
1545: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 110);
1546:
1547: l_cont_base_amount:= p_fixed_amount;
1548:
1549: ELSIF p_cont_base_method = 'N/A' THEN

Line 1550: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 120);

1546:
1547: l_cont_base_amount:= p_fixed_amount;
1548:
1549: ELSIF p_cont_base_method = 'N/A' THEN
1550: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 120);
1551:
1552: l_cont_base_amount:= 0;
1553:
1554: END IF;

Line 1572: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 130);

1568: hr_utility.trace(' ==============================================');
1569: END IF;
1570:
1571: l_message:='SUCCESS';
1572: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 130);
1573: RETURN l_message;
1574:
1575: EXCEPTION
1576: WHEN OTHERS THEN

Line 1578: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

1574:
1575: EXCEPTION
1576: WHEN OTHERS THEN
1577: p_cont_base_amount := hr_api.g_number;
1578: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1579: hr_utility.trace(l_message);
1580: RETURN l_message;
1581: END get_cont_base_amount;
1582:

Line 1624: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);

1620: l_message VARCHAR2(255);
1621: BEGIN
1622:
1623: g_procedure_name := g_package_name||'get_recalculate_flag';
1624: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);
1625: l_return_value := 'N';
1626: --
1627: -- Bug 3039614: Calculation Date can either be g_start_date or
1628: -- the last recalculation date as updated by update_element_entry

Line 1636: hr_cn_api.set_location(g_debug, g_procedure_name, 30);

1632: --
1633:
1634: IF p_switch_periodicity = 'YEARLY' THEN
1635: --
1636: hr_cn_api.set_location(g_debug, g_procedure_name, 30);
1637: --
1638: -- Bug 3127638
1639: -- Changed to incorporate the new lookup of CN_CALENDAR_MONTH being 'MM' in place of 'MON'
1640: --

Line 1644: hr_cn_api.set_location(g_debug, g_procedure_name, 35);

1640: --
1641: l_temp_date := TO_DATE('01-'||p_switch_month||'-'||TO_CHAR(p_calculation_date,'YYYY'),'DD-MM-YYYY');
1642:
1643: IF p_calculation_date = g_start_date OR TO_CHAR(p_calculation_date,'MM') = p_switch_month THEN
1644: hr_cn_api.set_location(g_debug, g_procedure_name, 35);
1645: l_temp_date := ADD_MONTHS(l_temp_date,12);
1646: END IF;
1647: --
1648: ELSIF p_switch_periodicity = 'MONTHLY' THEN

Line 1649: hr_cn_api.set_location (g_debug, g_procedure_name, 40);

1645: l_temp_date := ADD_MONTHS(l_temp_date,12);
1646: END IF;
1647: --
1648: ELSIF p_switch_periodicity = 'MONTHLY' THEN
1649: hr_cn_api.set_location (g_debug, g_procedure_name, 40);
1650: l_temp_date := TRUNC(ADD_MONTHS(p_calculation_date,1),'MM');
1651: --
1652: -- Bug 3555258 changes start
1653: --

Line 1676: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 50);

1672: hr_utility.trace(' . Recalculate Flag : '||l_return_value);
1673: hr_utility.trace(' ==============================================');
1674: END IF;
1675: --
1676: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 50);
1677: RETURN l_return_value;
1678: --
1679: EXCEPTION
1680: WHEN OTHERS THEN

Line 1681: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

1677: RETURN l_return_value;
1678: --
1679: EXCEPTION
1680: WHEN OTHERS THEN
1681: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1682: hr_utility.trace (l_message);
1683: RETURN 'E';
1684: END get_recalculate_flag;
1685:

Line 1738: hr_cn_api.set_location(g_debug,' Entering : '||g_procedure_name, 10);

1734:
1735: g_procedure_name := g_package_name||'get_in_limit';
1736: p_message := 'SUCCESS';
1737:
1738: hr_cn_api.set_location(g_debug,' Entering : '||g_procedure_name, 10);
1739:
1740: --
1741: -- Step 1: Fix the low limit amount
1742: --

Line 1825: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);

1821: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1822: hr_utility.trace(' . Rounded Amount : '||p_amount);
1823: hr_utility.trace(' ==============================================');
1824: END IF;
1825: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
1826:
1827: EXCEPTION
1828: WHEN OTHERS THEN
1829: p_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

Line 1829: p_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

1825: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
1826:
1827: EXCEPTION
1828: WHEN OTHERS THEN
1829: p_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1830: hr_utility.trace (p_message);
1831:
1832: END get_in_limit;
1833:

Line 1953: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);

1949: BEGIN
1950: g_procedure_name := g_package_name||'update_element_entry';
1951: l_message := 'SUCCESS';
1952:
1953: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);
1954: --
1955: -- Bug 3050951: Added the following check for active assignments
1956: --
1957:

Line 1971: hr_cn_api.set_location (g_debug,'Employee is terminated. Not calling pay_element_entry_api.',15);

1967: --
1968: --
1969: IF l_asg_status = 'TERM_ASSIGN' THEN
1970: --
1971: hr_cn_api.set_location (g_debug,'Employee is terminated. Not calling pay_element_entry_api.',15);
1972: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,15);
1973: RETURN l_message;
1974: --
1975: END IF;

Line 1972: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,15);

1968: --
1969: IF l_asg_status = 'TERM_ASSIGN' THEN
1970: --
1971: hr_cn_api.set_location (g_debug,'Employee is terminated. Not calling pay_element_entry_api.',15);
1972: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,15);
1973: RETURN l_message;
1974: --
1975: END IF;
1976: --

Line 1995: hr_cn_api.set_location(g_debug,' Element Entry is end-dated this month. Not calling pay_element_entry_api.',18);

1991: --
1992: IF c_ee_end%FOUND THEN
1993: --
1994: CLOSE c_ee_end;
1995: hr_cn_api.set_location(g_debug,' Element Entry is end-dated this month. Not calling pay_element_entry_api.',18);
1996: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,18);
1997: RETURN l_message;
1998: --
1999: ELSE

Line 1996: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,18);

1992: IF c_ee_end%FOUND THEN
1993: --
1994: CLOSE c_ee_end;
1995: hr_cn_api.set_location(g_debug,' Element Entry is end-dated this month. Not calling pay_element_entry_api.',18);
1996: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,18);
1997: RETURN l_message;
1998: --
1999: ELSE
2000: --

Line 2002: hr_cn_api.set_location(g_debug,' Element Entry is active this month. Can call pay_element_entry_api.',19);

1998: --
1999: ELSE
2000: --
2001: CLOSE c_ee_end;
2002: hr_cn_api.set_location(g_debug,' Element Entry is active this month. Can call pay_element_entry_api.',19);
2003: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,19);
2004: --
2005: END IF;
2006: --

Line 2003: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,19);

1999: ELSE
2000: --
2001: CLOSE c_ee_end;
2002: hr_cn_api.set_location(g_debug,' Element Entry is active this month. Can call pay_element_entry_api.',19);
2003: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,19);
2004: --
2005: END IF;
2006: --
2007: END IF;

Line 2013: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,20);

2009: -- Bug 3053186 Changes end
2010: --
2011: CLOSE c_iv;
2012: --
2013: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,20);
2014: hr_cn_api.set_location(g_debug,' Input Value ID : '||to_char(l_iv_id),25);
2015: --
2016: OPEN c_exists (l_iv_id);
2017: FETCH c_exists

Line 2014: hr_cn_api.set_location(g_debug,' Input Value ID : '||to_char(l_iv_id),25);

2010: --
2011: CLOSE c_iv;
2012: --
2013: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,20);
2014: hr_cn_api.set_location(g_debug,' Input Value ID : '||to_char(l_iv_id),25);
2015: --
2016: OPEN c_exists (l_iv_id);
2017: FETCH c_exists
2018: INTO l_eff_start_date;

Line 2022: hr_cn_api.set_location (g_debug, g_procedure_name, 32);

2018: INTO l_eff_start_date;
2019: --
2020: IF c_exists%NOTFOUND THEN
2021: --
2022: hr_cn_api.set_location (g_debug, g_procedure_name, 32);
2023: --
2024: -- Bug 3456162 added the code
2025: --
2026: OPEN c_asg_status (p_calculation_date + 1);

Line 2032: hr_cn_api.set_location(g_debug,' Employee is terminated on last day. Not calling pay_element_entry_api.',33);

2028: INTO l_asg_status;
2029:
2030: IF c_asg_status%NOTFOUND THEN
2031: --
2032: hr_cn_api.set_location(g_debug,' Employee is terminated on last day. Not calling pay_element_entry_api.',33);
2033: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,33);
2034: RETURN l_message;
2035: --
2036: END IF;

Line 2033: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,33);

2029:
2030: IF c_asg_status%NOTFOUND THEN
2031: --
2032: hr_cn_api.set_location(g_debug,' Employee is terminated on last day. Not calling pay_element_entry_api.',33);
2033: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,33);
2034: RETURN l_message;
2035: --
2036: END IF;
2037: CLOSE c_asg_status;

Line 2052: hr_cn_api.set_location (g_debug, g_procedure_name, 34);

2048: ELSE
2049: --
2050: -- Bug 3057542 changes
2051: --
2052: hr_cn_api.set_location (g_debug, g_procedure_name, 34);
2053:
2054: IF (l_eff_start_date = p_calculation_date + 1) THEN
2055:
2056: OPEN c_ovn (p_calculation_date+1);

Line 2065: hr_cn_api.set_location (g_debug, g_procedure_name, 36);

2061: l_upd_mode := 'CORRECTION';
2062: --
2063: ELSE
2064:
2065: hr_cn_api.set_location (g_debug, g_procedure_name, 36);
2066:
2067: OPEN c_ovn (p_calculation_date);
2068: FETCH c_ovn
2069: INTO l_ovn;

Line 2082: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,40);

2078: --
2079: END IF;
2080: CLOSE c_exists;
2081: --
2082: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,40);
2083: IF g_debug THEN
2084: hr_utility.trace(' ==============================================');
2085: hr_utility.trace ('. Calling pay_element_entry_api.');
2086: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));

Line 2112: hr_cn_api.set_location(g_debug,' . Error in pay_element_entry_api.',5);

2108:
2109: EXCEPTION
2110: WHEN OTHERS THEN
2111: --
2112: hr_cn_api.set_location(g_debug,' . Error in pay_element_entry_api.',5);
2113: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,5);
2114: l_message := SUBSTRB(SQLERRM,1,240);
2115: RETURN l_message;
2116: --

Line 2113: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,5);

2109: EXCEPTION
2110: WHEN OTHERS THEN
2111: --
2112: hr_cn_api.set_location(g_debug,' . Error in pay_element_entry_api.',5);
2113: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,5);
2114: l_message := SUBSTRB(SQLERRM,1,240);
2115: RETURN l_message;
2116: --
2117: END;

Line 2119: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,50);

2115: RETURN l_message;
2116: --
2117: END;
2118: --
2119: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,50);
2120: RETURN l_message;
2121: --
2122: EXCEPTION
2123: WHEN OTHERS THEN

Line 2124: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

2120: RETURN l_message;
2121: --
2122: EXCEPTION
2123: WHEN OTHERS THEN
2124: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2125: RETURN l_message;
2126:
2127: END update_element_entry;
2128:

Line 2165: hr_cn_api.set_location(g_debug,' Entering : '||g_procedure_name, 10);

2161: IS
2162: l_amount NUMBER;
2163: BEGIN
2164: g_procedure_name := g_package_name||'get_cont_amount';
2165: hr_cn_api.set_location(g_debug,' Entering : '||g_procedure_name, 10);
2166:
2167: p_message := 'SUCCESS';
2168: IF g_debug THEN
2169: hr_utility.trace(' ==============================================');

Line 2194: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);

2190: hr_utility.trace(' . Rounded Amount : '||l_amount);
2191: hr_utility.trace(' ==============================================');
2192: END IF;
2193:
2194: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
2195: RETURN l_amount;
2196:
2197: EXCEPTION
2198: WHEN OTHERS THEN

Line 2199: p_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

2195: RETURN l_amount;
2196:
2197: EXCEPTION
2198: WHEN OTHERS THEN
2199: p_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2200: RETURN hr_api.g_number;
2201:
2202: END get_cont_amount;
2203:

Line 2259: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);

2255: l_probation_flag VARCHAR2(1);
2256: l_temp NUMBER;
2257: BEGIN
2258: g_procedure_name := g_package_name||'get_phf_si_deferred_amounts';
2259: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);
2260:
2261: l_message := 'SUCCESS';
2262: l_default_date := TO_DATE ('01-01-0001','DD-MM-YYYY');
2263:

Line 2289: hr_cn_api.set_location (g_debug,'Probation End Date : '||l_probation_end_date,15);

2285: ELSE
2286: l_probation_end_date := p_actual_probation_end_date;
2287: END IF;
2288:
2289: hr_cn_api.set_location (g_debug,'Probation End Date : '||l_probation_end_date,15);
2290:
2291: IF l_probation_end_date = pay_cn_deductions.g_start_date THEN
2292: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
2293: l_probation_flag := 'N';

Line 2292: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);

2288:
2289: hr_cn_api.set_location (g_debug,'Probation End Date : '||l_probation_end_date,15);
2290:
2291: IF l_probation_end_date = pay_cn_deductions.g_start_date THEN
2292: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
2293: l_probation_flag := 'N';
2294: END IF;
2295:
2296: hr_cn_api.set_location (g_debug,'Probation Flag After being Set : '||l_probation_flag,25);

Line 2296: hr_cn_api.set_location (g_debug,'Probation Flag After being Set : '||l_probation_flag,25);

2292: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
2293: l_probation_flag := 'N';
2294: END IF;
2295:
2296: hr_cn_api.set_location (g_debug,'Probation Flag After being Set : '||l_probation_flag,25);
2297: --3042788
2298: --
2299: -- Bug 3017511 changes. Logic Changed since deduct in probation expiry was not
2300: -- being considered at all

Line 2314: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);

2310: )
2311: THEN
2312:
2313: IF p_undeducted_ee_phf_ltd >0 THEN
2314: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);
2315: p_ee_phf_si_amount := p_ee_phf_si_amount + p_undeducted_ee_phf_ltd;
2316: p_undeducted_ee_phf_ltd := 0 - p_undeducted_ee_phf_ltd;
2317:
2318: END IF;

Line 2321: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);

2317:
2318: END IF;
2319:
2320: IF p_undeducted_er_phf_ltd >0 THEN
2321: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);
2322: p_er_phf_si_amount := p_er_phf_si_amount + p_undeducted_er_phf_ltd;
2323: p_undeducted_er_phf_ltd := 0 - p_undeducted_er_phf_ltd;
2324: END IF;
2325:

Line 2331: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);

2327: --
2328: -- Bug 3017511 changes. Logic Changed since in case of deferment, undeducted phf
2329: -- was getting incorrectly fed.
2330: --
2331: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);
2332: p_undeducted_ee_phf_ltd := p_ee_phf_si_amount;
2333: p_ee_phf_si_amount := 0;
2334:
2335: p_undeducted_er_phf_ltd := p_er_phf_si_amount;

Line 2349: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 60);

2345: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2346: hr_utility.trace(' ==============================================');
2347: END IF;
2348:
2349: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 60);
2350: RETURN l_message;
2351:
2352: EXCEPTION
2353: WHEN OTHERS THEN

Line 2354: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

2350: RETURN l_message;
2351:
2352: EXCEPTION
2353: WHEN OTHERS THEN
2354: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2355: RETURN l_message;
2356: END get_phf_si_deferred_amounts;
2357:
2358: ----------------------------------------------------------------------------

Line 2415: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

2411: RETURN l_def_bal_id;
2412:
2413: EXCEPTION
2414: WHEN OTHERS THEN
2415: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2416: hr_utility.trace(l_message);
2417:
2418: END get_def_bal_id ;
2419:

Line 2480: hr_cn_api.set_location(g_debug,' Entering : '||g_procedure_name, 10);

2476: l_message VARCHAR2(80);
2477: BEGIN
2478: g_procedure_name := g_package_name||'get_phf_si_balances';
2479:
2480: hr_cn_api.set_location(g_debug,' Entering : '||g_procedure_name, 10);
2481:
2482: l_message := 'SUCCESS';
2483:
2484: --

Line 2539: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);

2535: IF g_debug THEN
2536: hr_utility.trace ('===================== Balance Values =========================');
2537: END IF;
2538:
2539: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
2540:
2541: EXCEPTION
2542: WHEN OTHERS THEN
2543: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

Line 2543: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

2539: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
2540:
2541: EXCEPTION
2542: WHEN OTHERS THEN
2543: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2544: hr_utility.trace(l_message);
2545:
2546: END get_phf_si_balances;
2547:

Line 2698: hr_cn_api.set_location(g_debug,' Entering PHF and SI Enhancements started from 1-Jan-2006 : ', 230);

2694:
2695: BEGIN
2696:
2697:
2698: hr_cn_api.set_location(g_debug,' Entering PHF and SI Enhancements started from 1-Jan-2006 : ', 230);
2699:
2700:
2701: IF g_debug THEN
2702: hr_utility.trace(' =======================================================');

Line 2868: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 240);

2864: ,p_fixed_amount => l_ee_hi_cont_base_amount
2865: ,p_cont_base_amount => l_out_ee_hi_cont_base_amount);
2866:
2867: IF l_out_ee_hi_cont_base_amount = hr_api.g_number AND l_message <> 'SUCCESS' THEN
2868: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 240);
2869: RAISE initialize_on_error;
2870: END IF;
2871: END IF;
2872:

Line 2886: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 250);

2882: ,p_fixed_amount => l_er_hi_cont_base_amount
2883: ,p_cont_base_amount => l_out_er_hi_cont_base_amount);
2884:
2885: IF l_out_er_hi_cont_base_amount = hr_api.g_number AND l_message <> 'SUCCESS' THEN
2886: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 250);
2887: RAISE initialize_on_error;
2888: END IF;
2889: END IF;
2890:

Line 2900: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount_higher : '||l_ee_phf_si_amount_higher, 260);

2896: ,p_rate_amount => l_ee_hi_cont_amt
2897: ,p_rounding_method => l_ee_rate_rounding_method
2898: ,p_message => l_message);
2899:
2900: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount_higher : '||l_ee_phf_si_amount_higher, 260);
2901:
2902: IF l_message <> 'SUCCESS' THEN
2903: l_ee_phf_si_amount_higher := 0;
2904: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 270);

Line 2904: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 270);

2900: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount_higher : '||l_ee_phf_si_amount_higher, 260);
2901:
2902: IF l_message <> 'SUCCESS' THEN
2903: l_ee_phf_si_amount_higher := 0;
2904: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 270);
2905: RETURN l_message;
2906: END IF;
2907:
2908: l_er_phf_si_amount_higher :=

Line 2916: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount_higher : '||l_er_phf_si_amount_higher, 280);

2912: ,p_rate_amount => l_er_hi_cont_amt
2913: ,p_rounding_method => l_er_rate_rounding_method
2914: ,p_message => l_message);
2915:
2916: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount_higher : '||l_er_phf_si_amount_higher, 280);
2917:
2918: IF l_message <> 'SUCCESS' THEN
2919: l_er_phf_si_amount_higher := 0;
2920: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 290);

Line 2920: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 290);

2916: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount_higher : '||l_er_phf_si_amount_higher, 280);
2917:
2918: IF l_message <> 'SUCCESS' THEN
2919: l_er_phf_si_amount_higher := 0;
2920: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 290);
2921: RETURN l_message;
2922: END IF;
2923:
2924:

Line 2987: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 305);

2983: ,p_message => l_message);
2984:
2985: IF l_message <> 'SUCCESS' THEN
2986: l_ee_phf_si_amount := 0;
2987: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 305);
2988: RETURN l_message;
2989: END IF;
2990:
2991: ELSE

Line 3002: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 310);

2998: ,p_message => l_message);
2999:
3000: IF l_message <> 'SUCCESS' THEN
3001: l_ee_phf_si_amount := 0;
3002: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 310);
3003: RETURN l_message;
3004: END IF;
3005: END IF;
3006: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount : '||l_ee_phf_si_amount, 320);

Line 3006: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount : '||l_ee_phf_si_amount, 320);

3002: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 310);
3003: RETURN l_message;
3004: END IF;
3005: END IF;
3006: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount : '||l_ee_phf_si_amount, 320);
3007: ELSE
3008:
3009: IF l_ee_tax_thrhld_rate IS NULL THEN
3010:

Line 3027: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 330);

3023: END IF;
3024:
3025: IF l_message <> 'SUCCESS' THEN
3026: l_ee_phf_si_amount := 0;
3027: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 330);
3028: RETURN l_message;
3029: END IF;
3030:
3031: hr_cn_api.set_location(g_debug,' l_ee_stat_fixed_amount : '||l_ee_stat_fixed_amount, 340);

Line 3031: hr_cn_api.set_location(g_debug,' l_ee_stat_fixed_amount : '||l_ee_stat_fixed_amount, 340);

3027: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 330);
3028: RETURN l_message;
3029: END IF;
3030:
3031: hr_cn_api.set_location(g_debug,' l_ee_stat_fixed_amount : '||l_ee_stat_fixed_amount, 340);
3032: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount_higher : '||l_ee_phf_si_amount_higher, 350);
3033:
3034: IF (l_ee_phf_si_amount_higher >l_ee_stat_fixed_amount) THEN
3035: l_ee_phf_si_amount := l_ee_stat_fixed_amount;

Line 3032: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount_higher : '||l_ee_phf_si_amount_higher, 350);

3028: RETURN l_message;
3029: END IF;
3030:
3031: hr_cn_api.set_location(g_debug,' l_ee_stat_fixed_amount : '||l_ee_stat_fixed_amount, 340);
3032: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount_higher : '||l_ee_phf_si_amount_higher, 350);
3033:
3034: IF (l_ee_phf_si_amount_higher >l_ee_stat_fixed_amount) THEN
3035: l_ee_phf_si_amount := l_ee_stat_fixed_amount;
3036: ELSE

Line 3039: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount : '||l_ee_phf_si_amount, 360);

3035: l_ee_phf_si_amount := l_ee_stat_fixed_amount;
3036: ELSE
3037: l_ee_phf_si_amount := l_ee_phf_si_amount_higher;
3038: END IF;
3039: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount : '||l_ee_phf_si_amount, 360);
3040: END IF;
3041:
3042: IF (l_er_hi_cont_type = 'PERCENTAGE') THEN
3043: IF(l_er_hi_cont_amt > l_er_stat_percentage) THEN

Line 3054: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 370);

3050: ,p_message => l_message);
3051:
3052: IF l_message <> 'SUCCESS' THEN
3053: l_er_phf_si_amount := 0;
3054: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 370);
3055: RETURN l_message;
3056: END IF;
3057: ELSE
3058: l_er_phf_si_amount :=

Line 3068: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 380);

3064: ,p_message => l_message);
3065:
3066: IF l_message <> 'SUCCESS' THEN
3067: l_er_phf_si_amount := 0;
3068: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 380);
3069: RETURN l_message;
3070: END IF;
3071: END IF;
3072: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount : '||l_er_phf_si_amount, 390);

Line 3072: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount : '||l_er_phf_si_amount, 390);

3068: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 380);
3069: RETURN l_message;
3070: END IF;
3071: END IF;
3072: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount : '||l_er_phf_si_amount, 390);
3073: ELSE
3074:
3075: IF l_er_tax_thrhld_rate IS NULL THEN
3076:

Line 3093: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 400);

3089: END IF;
3090:
3091: IF l_message <> 'SUCCESS' THEN
3092: l_er_phf_si_amount := 0;
3093: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 400);
3094: RETURN l_message;
3095: END IF;
3096:
3097: hr_cn_api.set_location(g_debug,' l_er_stat_fixed_amount : '||l_er_stat_fixed_amount, 410);

Line 3097: hr_cn_api.set_location(g_debug,' l_er_stat_fixed_amount : '||l_er_stat_fixed_amount, 410);

3093: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 400);
3094: RETURN l_message;
3095: END IF;
3096:
3097: hr_cn_api.set_location(g_debug,' l_er_stat_fixed_amount : '||l_er_stat_fixed_amount, 410);
3098: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount_higher : '||l_er_phf_si_amount_higher, 420);
3099:
3100: IF (l_er_phf_si_amount_higher >l_er_stat_fixed_amount) THEN
3101: l_er_phf_si_amount := l_er_stat_fixed_amount;

Line 3098: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount_higher : '||l_er_phf_si_amount_higher, 420);

3094: RETURN l_message;
3095: END IF;
3096:
3097: hr_cn_api.set_location(g_debug,' l_er_stat_fixed_amount : '||l_er_stat_fixed_amount, 410);
3098: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount_higher : '||l_er_phf_si_amount_higher, 420);
3099:
3100: IF (l_er_phf_si_amount_higher >l_er_stat_fixed_amount) THEN
3101: l_er_phf_si_amount := l_er_stat_fixed_amount;
3102: ELSE

Line 3105: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount : '||l_er_phf_si_amount, 430);

3101: l_er_phf_si_amount := l_er_stat_fixed_amount;
3102: ELSE
3103: l_er_phf_si_amount := l_er_phf_si_amount_higher;
3104: END IF;
3105: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount : '||l_er_phf_si_amount, 430);
3106: END IF;
3107:
3108: l_ee_taxable_cont := GREATEST(l_ee_phf_si_amount_higher - l_ee_phf_si_amount, 0);
3109: l_er_taxable_cont := GREATEST(l_er_phf_si_amount_higher - l_er_phf_si_amount, 0);

Line 3117: hr_cn_api.set_location(g_debug,' l_ee_taxable_cont : '|| l_ee_taxable_cont, 440);

3113:
3114: END IF;
3115:
3116:
3117: hr_cn_api.set_location(g_debug,' l_ee_taxable_cont : '|| l_ee_taxable_cont, 440);
3118: hr_cn_api.set_location(g_debug,' l_er_taxable_cont : '|| l_er_taxable_cont, 450);
3119:
3120: p_ee_taxable_cont := l_ee_taxable_cont;
3121: p_er_taxable_cont := l_er_taxable_cont;

Line 3118: hr_cn_api.set_location(g_debug,' l_er_taxable_cont : '|| l_er_taxable_cont, 450);

3114: END IF;
3115:
3116:
3117: hr_cn_api.set_location(g_debug,' l_ee_taxable_cont : '|| l_ee_taxable_cont, 440);
3118: hr_cn_api.set_location(g_debug,' l_er_taxable_cont : '|| l_er_taxable_cont, 450);
3119:
3120: p_ee_taxable_cont := l_ee_taxable_cont;
3121: p_er_taxable_cont := l_er_taxable_cont;
3122: p_ee_phf_si_amount := l_ee_phf_si_amount_higher;

Line 3141: hr_cn_api.set_location(g_debug,' Leaving PHF and SI Enhancements started from 1-Jan-2006: ', 460);

3137: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );
3138: hr_utility.trace(' =======================================================');
3139: END IF;
3140:
3141: hr_cn_api.set_location(g_debug,' Leaving PHF and SI Enhancements started from 1-Jan-2006: ', 460);
3142:
3143: ---------------------------------------------------------------------------------------------
3144: /* End Bug 5563042 (PHF and SI Enhancements) check for employee level data */
3145: ---------------------------------------------------------------------------------------------

Line 3150: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

3146: RETURN 'SUCCESS';
3147:
3148: EXCEPTION
3149: WHEN OTHERS THEN
3150: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
3151: RETURN l_message;
3152:
3153: END calculate_cont_jan_2006;
3154:

Line 3368: hr_cn_api.set_location(g_debug, ' Entering: '||g_procedure_name, 10);

3364:
3365: g_debug := hr_utility.debug_enabled;
3366: g_procedure_name := g_package_name || 'calculate_contribution';
3367:
3368: hr_cn_api.set_location(g_debug, ' Entering: '||g_procedure_name, 10);
3369:
3370: l_ee_cont_base_amount := p_ee_cont_base_amount;
3371: l_er_cont_base_amount := p_er_cont_base_amount;
3372: l_calculation_date := p_calculation_date;

Line 3427: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 25);

3423:
3424: hr_utility.trace(' Calculate_contribution : Message=>' || l_message);
3425: IF l_message <> 'SUCCESS'
3426: THEN
3427: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 25);
3428: RAISE initialize_on_error;
3429: END IF;
3430:
3431: --

Line 3461: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 45);

3457: hr_utility.trace(' get_cont_base_method : Message=>' || l_message);
3458:
3459: IF l_message <> 'SUCCESS'
3460: THEN
3461: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 45);
3462: RAISE initialize_on_error;
3463: END IF;
3464:
3465: --

Line 3534: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 105);

3530: ,p_fixed_amount => l_ee_fixed_amount
3531: ,p_cont_base_amount => l_ee_cont_base_amount);
3532:
3533: IF l_ee_cont_base_amount = hr_api.g_number AND l_message <> 'SUCCESS' THEN
3534: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 105);
3535: RAISE initialize_on_error;
3536: END IF;
3537:
3538: END IF;

Line 3556: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 115);

3552: ,p_message => l_message
3553: );
3554:
3555: IF l_message <> 'SUCCESS' THEN
3556: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 115);
3557: RAISE initialize_on_error;
3558: END IF;
3559:
3560: IF NVL(l_er_cont_base_amount,0) = 0 THEN

Line 3574: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 145);

3570: ,p_fixed_amount => l_er_fixed_amount
3571: ,p_cont_base_amount => l_er_cont_base_amount);
3572:
3573: IF l_er_cont_base_amount = hr_api.g_number AND l_message <> 'SUCCESS' THEN
3574: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 145);
3575: RAISE initialize_on_error;
3576: END IF;
3577:
3578: END IF;

Line 3593: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 155);

3589: ,p_message => l_message
3590: );
3591:
3592: IF l_message <> 'SUCCESS' THEN
3593: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 155);
3594: RAISE initialize_on_error;
3595: END IF;
3596:
3597: --

Line 3611: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 90);

3607: );
3608:
3609: IF l_message <> 'SUCCESS'
3610: THEN
3611: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 90);
3612: RAISE initialize_on_error;
3613: END IF; */
3614:
3615: l_new_ee_cont_base_amount := l_ee_cont_base_amount - l_ee_cont_base_asg_ltd;

Line 3668: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 210);

3664:
3665:
3666: IF l_message <> 'SUCCESS' THEN
3667: l_ee_phf_si_amount := 0;
3668: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 210);
3669: RETURN l_message;
3670: END IF;
3671:
3672: IF g_debug THEN

Line 3691: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 220);

3687: ,p_message => l_message);
3688:
3689: IF l_message <> 'SUCCESS' THEN
3690: l_er_phf_si_amount := 0;
3691: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 220);
3692: RETURN l_message;
3693: END IF;
3694:
3695:

Line 3794: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 220);

3790:
3791: );
3792:
3793: IF l_message <> 'SUCCESS' THEN
3794: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 220);
3795: RETURN l_message;
3796: END IF;
3797: END IF;
3798: END IF;

Line 3839: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 285);

3835: );
3836:
3837: IF l_message <> 'SUCCESS' THEN
3838: l_ee_phf_si_amount := 0;
3839: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 285);
3840: RETURN l_message;
3841: END IF;
3842:
3843: --

Line 3900: hr_cn_api.set_location(g_debug,' Leaving ' || g_procedure_name,300);

3896: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);
3897: hr_utility.trace(' =====================================================================');
3898: END IF;
3899:
3900: hr_cn_api.set_location(g_debug,' Leaving ' || g_procedure_name,300);
3901: RETURN l_message;
3902:
3903:
3904: EXCEPTION

Line 3922: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

3918: p_new_ee_cont_base_amount := NULL;
3919: p_new_er_cont_base_amount := NULL;
3920: p_undeducted_ee_phf_si_amount := NULL;
3921: p_undeducted_er_phf_si_amount := NULL;
3922: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
3923: RETURN l_message;
3924: END calculate_contribution;
3925:
3926: --------------------------------------------------------------------------

Line 3955: -- p_token_name NOCOPY hr_cn_api.char_tab_type --

3951: -- p_effective_start_date DATE --
3952: -- p_effective_end_date DATE --
3953: -- IN/ OUT : --
3954: -- OUT : p_message_name NOCOPY VARCHAR2 --
3955: -- p_token_name NOCOPY hr_cn_api.char_tab_type --
3956: -- p_token_value NOCOPY hr_cn_api.char_tab_type --
3957: -- --
3958: -- Change History : --
3959: --------------------------------------------------------------------------

Line 3956: -- p_token_value NOCOPY hr_cn_api.char_tab_type --

3952: -- p_effective_end_date DATE --
3953: -- IN/ OUT : --
3954: -- OUT : p_message_name NOCOPY VARCHAR2 --
3955: -- p_token_name NOCOPY hr_cn_api.char_tab_type --
3956: -- p_token_value NOCOPY hr_cn_api.char_tab_type --
3957: -- --
3958: -- Change History : --
3959: --------------------------------------------------------------------------
3960: -- Rev# Date Userid Description --

Line 3987: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type

3983: ,p_er_fixed_amount IN NUMBER
3984: ,p_effective_start_date IN DATE
3985: ,p_effective_end_date IN DATE
3986: ,p_message_name OUT NOCOPY VARCHAR2
3987: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
3988: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
3989: )
3990: AS
3991:

Line 3988: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type

3984: ,p_effective_start_date IN DATE
3985: ,p_effective_end_date IN DATE
3986: ,p_message_name OUT NOCOPY VARCHAR2
3987: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
3988: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
3989: )
3990: AS
3991:
3992: l_flag BOOLEAN;

Line 4017: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Periodicity'

4013: IF NOT l_flag THEN
4014:
4015: hr_utility.trace('Invalid Contribution Base Setup');
4016:
4017: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Periodicity'
4018: ,p_dff => 'Org Developer DF'
4019: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4020: );
4021:

Line 4022: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'EE Cont Base Method'

4018: ,p_dff => 'Org Developer DF'
4019: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4020: );
4021:
4022: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'EE Cont Base Method'
4023: ,p_dff => 'Org Developer DF'
4024: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4025: );
4026:

Line 4053: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'EE Cont Base Method'

4049: );
4050:
4051: IF NOT l_flag THEN
4052:
4053: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'EE Cont Base Method'
4054: ,p_dff => 'Org Developer DF'
4055: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4056: );
4057:

Line 4062: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => l_return_segment

4058: IF l_return_segment = 'Fixed Amount' THEN
4059: l_return_segment := 'EE Fixed Amount';
4060: END IF;
4061:
4062: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => l_return_segment
4063: ,p_dff => 'Org Developer DF'
4064: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4065: );
4066:

Line 4089: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Periodicity'

4085: );
4086:
4087: IF NOT l_flag THEN
4088:
4089: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Periodicity'
4090: ,p_dff => 'Org Developer DF'
4091: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4092: );
4093:

Line 4094: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'ER Cont Base Method'

4090: ,p_dff => 'Org Developer DF'
4091: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4092: );
4093:
4094: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'ER Cont Base Method'
4095: ,p_dff => 'Org Developer DF'
4096: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4097: );
4098:

Line 4125: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'ER Cont Base Method'

4121: );
4122:
4123: IF NOT l_flag THEN
4124:
4125: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'ER Cont Base Method'
4126: ,p_dff => 'Org Developer DF'
4127: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4128: );
4129:

Line 4134: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => l_return_segment

4130: IF l_return_segment = 'Fixed Amount' THEN
4131: l_return_segment := 'EE Fixed Amount';
4132: END IF;
4133:
4134: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => l_return_segment
4135: ,p_dff => 'Org Developer DF'
4136: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4137: );
4138:

Line 4167: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Low Limit Method'

4163:
4164: IF NOT l_flag THEN
4165:
4166:
4167: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Low Limit Method'
4168: ,p_dff => 'Org Developer DF'
4169: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4170: );
4171:

Line 4172: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => l_return_segment

4168: ,p_dff => 'Org Developer DF'
4169: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4170: );
4171:
4172: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => l_return_segment
4173: ,p_dff => 'Org Developer DF'
4174: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4175: );
4176:

Line 4205: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'High Limit Method'

4201: );
4202:
4203: IF NOT l_flag THEN
4204:
4205: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'High Limit Method'
4206: ,p_dff => 'Org Developer DF'
4207: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4208: );
4209:

Line 4210: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => l_return_segment

4206: ,p_dff => 'Org Developer DF'
4207: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4208: );
4209:
4210: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => l_return_segment
4211: ,p_dff => 'Org Developer DF'
4212: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4213: );
4214:

Line 4234: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Periodicity'

4230: END IF;
4231:
4232: IF p_switch_periodicity = 'YEARLY' AND p_switch_month IS NULL THEN
4233:
4234: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Periodicity'
4235: ,p_dff => 'Org Developer DF'
4236: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4237: );
4238:

Line 4239: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Month'

4235: ,p_dff => 'Org Developer DF'
4236: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4237: );
4238:
4239: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Month'
4240: ,p_dff => 'Org Developer DF'
4241: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4242: );
4243:

Line 4279: -- p_token_name NOCOPY hr_cn_api.char_tab_type --

4275: -- p_effective_start_date DATE --
4276: -- p_effective_end_date DATE --
4277: -- IN/ OUT : --
4278: -- OUT : p_message_name NOCOPY VARCHAR2 --
4279: -- p_token_name NOCOPY hr_cn_api.char_tab_type --
4280: -- p_token_value NOCOPY hr_cn_api.char_tab_type --
4281: -- --
4282: -- Change History : --
4283: --------------------------------------------------------------------------

Line 4280: -- p_token_value NOCOPY hr_cn_api.char_tab_type --

4276: -- p_effective_end_date DATE --
4277: -- IN/ OUT : --
4278: -- OUT : p_message_name NOCOPY VARCHAR2 --
4279: -- p_token_name NOCOPY hr_cn_api.char_tab_type --
4280: -- p_token_value NOCOPY hr_cn_api.char_tab_type --
4281: -- --
4282: -- Change History : --
4283: --------------------------------------------------------------------------
4284: -- Rev# Date Userid Description --

Line 4298: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type

4294: ,p_hukou_type IN VARCHAR2
4295: ,p_effective_start_date IN DATE
4296: ,p_effective_end_date IN DATE
4297: ,p_message_name OUT NOCOPY VARCHAR2
4298: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
4299: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
4300: )
4301: AS
4302:

Line 4299: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type

4295: ,p_effective_start_date IN DATE
4296: ,p_effective_end_date IN DATE
4297: ,p_message_name OUT NOCOPY VARCHAR2
4298: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
4299: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
4300: )
4301: AS
4302:
4303: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

Line 4315: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Hukou Type'

4311:
4312: -- Code commented for bug 6943573
4313: /*
4314: IF p_hukou_type IS NOT NULL AND p_organization IS NULL THEN
4315: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Hukou Type'
4316: ,p_dff => 'Org Developer DF'
4317: ,p_dff_context_code => 'PER_CONT_AREA_PHF_SI_RATES_CN'
4318: );
4319:

Line 4320: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Organization'

4316: ,p_dff => 'Org Developer DF'
4317: ,p_dff_context_code => 'PER_CONT_AREA_PHF_SI_RATES_CN'
4318: );
4319:
4320: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Organization'
4321: ,p_dff => 'Org Developer DF'
4322: ,p_dff_context_code => 'PER_CONT_AREA_PHF_SI_RATES_CN'
4323: );
4324: