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 1190: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1434: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);
1435: hr_utility.trace(' =======================================================');
1436: END IF;
1437:
1438: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 70);
1439: RETURN l_message;
1440:
1441: EXCEPTION
1442: WHEN OTHERS THEN

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

1439: RETURN l_message;
1440:
1441: EXCEPTION
1442: WHEN OTHERS THEN
1443: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1444:
1445: IF c_org4%ISOPEN THEN
1446: CLOSE c_org4;
1447: END IF;

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

1506: l_message VARCHAR2(255);
1507:
1508: BEGIN
1509: g_procedure_name := g_package_name||'get_cont_base_amount';
1510: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);
1511:
1512: l_message := '';
1513:
1514: IF p_cont_base_method = 'AVE MTH' THEN

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

1516: -- Bug 3017511 Changed the SELECT DECODE.. to IF..THEN..ELSE conditions
1517: --
1518: IF p_phf_si_earnings_asg_avg = 0 THEN
1519: IF p_phf_si_earnings_asg_pmth = 0 THEN
1520: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
1521: l_cont_base_amount := p_phf_si_earnings_asg_ptd;
1522: ELSE
1523: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);
1524: l_cont_base_amount := p_phf_si_earnings_asg_pmth;

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

1519: IF p_phf_si_earnings_asg_pmth = 0 THEN
1520: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
1521: l_cont_base_amount := p_phf_si_earnings_asg_ptd;
1522: ELSE
1523: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);
1524: l_cont_base_amount := p_phf_si_earnings_asg_pmth;
1525: END IF;
1526: ELSE
1527: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);

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

1523: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);
1524: l_cont_base_amount := p_phf_si_earnings_asg_pmth;
1525: END IF;
1526: ELSE
1527: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);
1528: l_cont_base_amount := p_phf_si_earnings_asg_avg;
1529: END IF;
1530:
1531: ELSIF p_cont_base_method = 'CURRENT' THEN

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

1528: l_cont_base_amount := p_phf_si_earnings_asg_avg;
1529: END IF;
1530:
1531: ELSIF p_cont_base_method = 'CURRENT' THEN
1532: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);
1533: l_cont_base_amount:= p_phf_si_earnings_asg_ptd;
1534: --
1535: -- Bug 3038490. Changed the mis-spelt EMP PRIOR SWITCH
1536: --

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

1534: --
1535: -- Bug 3038490. Changed the mis-spelt EMP PRIOR SWITCH
1536: --
1537: ELSIF p_cont_base_method in ('PREVIOUS','EMP PRIOR SWITCH') THEN
1538: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 60);
1539: --
1540: -- Bug 3017511 Changed the SELECT DECODE.. to IF..THEN..ELSE conditions
1541: --
1542: IF p_phf_si_earnings_asg_pmth = 0 THEN

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

1539: --
1540: -- Bug 3017511 Changed the SELECT DECODE.. to IF..THEN..ELSE conditions
1541: --
1542: IF p_phf_si_earnings_asg_pmth = 0 THEN
1543: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 70);
1544: l_cont_base_amount := p_phf_si_earnings_asg_ptd;
1545: ELSE
1546: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 80);
1547: l_cont_base_amount := p_phf_si_earnings_asg_pmth;

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

1542: IF p_phf_si_earnings_asg_pmth = 0 THEN
1543: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 70);
1544: l_cont_base_amount := p_phf_si_earnings_asg_ptd;
1545: ELSE
1546: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 80);
1547: l_cont_base_amount := p_phf_si_earnings_asg_pmth;
1548: END IF;
1549:
1550: ELSIF p_cont_base_method in ( 'CITY AVE 60', 'PROV AVE 60' ) THEN /* modified for 6828199 */

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

1547: l_cont_base_amount := p_phf_si_earnings_asg_pmth;
1548: END IF;
1549:
1550: ELSIF p_cont_base_method in ( 'CITY AVE 60', 'PROV AVE 60' ) THEN /* modified for 6828199 */
1551: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 90);
1552: l_cont_base_amount:= 0.6*p_average_salary;
1553:
1554: ELSIF p_cont_base_method = 'CITY LOW LAST YR' THEN
1555: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 100);

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

1551: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 90);
1552: l_cont_base_amount:= 0.6*p_average_salary;
1553:
1554: ELSIF p_cont_base_method = 'CITY LOW LAST YR' THEN
1555: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 100);
1556:
1557: l_cont_base_amount:= p_lowest_average_salary;
1558:
1559: ELSIF p_cont_base_method = 'FIXED' THEN

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

1556:
1557: l_cont_base_amount:= p_lowest_average_salary;
1558:
1559: ELSIF p_cont_base_method = 'FIXED' THEN
1560: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 110);
1561:
1562: l_cont_base_amount:= p_fixed_amount;
1563:
1564: ELSIF p_cont_base_method = 'N/A' THEN

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

1561:
1562: l_cont_base_amount:= p_fixed_amount;
1563:
1564: ELSIF p_cont_base_method = 'N/A' THEN
1565: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 120);
1566:
1567: l_cont_base_amount:= 0;
1568:
1569: END IF;

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

1583: hr_utility.trace(' ==============================================');
1584: END IF;
1585:
1586: l_message:='SUCCESS';
1587: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 130);
1588: RETURN l_message;
1589:
1590: EXCEPTION
1591: WHEN OTHERS THEN

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

1589:
1590: EXCEPTION
1591: WHEN OTHERS THEN
1592: p_cont_base_amount := hr_api.g_number;
1593: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1594: hr_utility.trace(l_message);
1595: RETURN l_message;
1596: END get_cont_base_amount;
1597:

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

1639: l_message VARCHAR2(255);
1640: BEGIN
1641:
1642: g_procedure_name := g_package_name||'get_recalculate_flag';
1643: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);
1644: l_return_value := 'N';
1645: --
1646: -- Bug 3039614: Calculation Date can either be g_start_date or
1647: -- the last recalculation date as updated by update_element_entry

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

1651: --
1652:
1653: IF p_switch_periodicity = 'YEARLY' THEN
1654: --
1655: hr_cn_api.set_location(g_debug, g_procedure_name, 30);
1656: --
1657: -- Bug 3127638
1658: -- Changed to incorporate the new lookup of CN_CALENDAR_MONTH being 'MM' in place of 'MON'
1659: /* 8328944 - Used Process Date instead of calculation date */

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

1666: END IF;
1667:
1668: --
1669: ELSIF p_switch_periodicity = 'MONTHLY' THEN
1670: hr_cn_api.set_location (g_debug, g_procedure_name, 40);
1671: /* 8838185 - Remove unnecessary code and always return Y always */
1672: l_return_value := 'Y';
1673: END IF;
1674:

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

1682: hr_utility.trace(' . Recalculate Flag : '||l_return_value);
1683: hr_utility.trace(' ==============================================');
1684: END IF;
1685: --
1686: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 50);
1687: RETURN l_return_value;
1688: --
1689: EXCEPTION
1690: WHEN OTHERS THEN

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

1687: RETURN l_return_value;
1688: --
1689: EXCEPTION
1690: WHEN OTHERS THEN
1691: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1692: hr_utility.trace (l_message);
1693: RETURN 'E';
1694: END get_recalculate_flag;
1695:

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

1744:
1745: g_procedure_name := g_package_name||'get_in_limit';
1746: p_message := 'SUCCESS';
1747:
1748: hr_cn_api.set_location(g_debug,' Entering : '||g_procedure_name, 10);
1749:
1750: --
1751: -- Step 1: Fix the low limit amount
1752: --

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

1831: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1832: hr_utility.trace(' . Rounded Amount : '||p_amount);
1833: hr_utility.trace(' ==============================================');
1834: END IF;
1835: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
1836:
1837: EXCEPTION
1838: WHEN OTHERS THEN
1839: p_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

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

1835: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
1836:
1837: EXCEPTION
1838: WHEN OTHERS THEN
1839: p_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1840: hr_utility.trace (p_message);
1841:
1842: END get_in_limit;
1843:

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

1959: BEGIN
1960: g_procedure_name := g_package_name||'update_element_entry';
1961: l_message := 'SUCCESS';
1962:
1963: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);
1964: --
1965: -- Bug 3050951: Added the following check for active assignments
1966: --
1967:

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

1977: --
1978: --
1979: IF l_asg_status = 'TERM_ASSIGN' THEN
1980: --
1981: hr_cn_api.set_location (g_debug,'Employee is terminated. Not calling pay_element_entry_api.',15);
1982: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,15);
1983: RETURN l_message;
1984: --
1985: END IF;

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

1978: --
1979: IF l_asg_status = 'TERM_ASSIGN' THEN
1980: --
1981: hr_cn_api.set_location (g_debug,'Employee is terminated. Not calling pay_element_entry_api.',15);
1982: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,15);
1983: RETURN l_message;
1984: --
1985: END IF;
1986: --

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

2001: --
2002: IF c_ee_end%FOUND THEN
2003: --
2004: CLOSE c_ee_end;
2005: hr_cn_api.set_location(g_debug,' Element Entry is end-dated this month. Not calling pay_element_entry_api.',18);
2006: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,18);
2007: RETURN l_message;
2008: --
2009: ELSE

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

2002: IF c_ee_end%FOUND THEN
2003: --
2004: CLOSE c_ee_end;
2005: hr_cn_api.set_location(g_debug,' Element Entry is end-dated this month. Not calling pay_element_entry_api.',18);
2006: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,18);
2007: RETURN l_message;
2008: --
2009: ELSE
2010: --

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

2008: --
2009: ELSE
2010: --
2011: CLOSE c_ee_end;
2012: hr_cn_api.set_location(g_debug,' Element Entry is active this month. Can call pay_element_entry_api.',19);
2013: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,19);
2014: --
2015: END IF;
2016: --

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

2009: ELSE
2010: --
2011: CLOSE c_ee_end;
2012: hr_cn_api.set_location(g_debug,' Element Entry is active this month. Can call pay_element_entry_api.',19);
2013: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,19);
2014: --
2015: END IF;
2016: --
2017: END IF;

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

2019: -- Bug 3053186 Changes end
2020: --
2021: CLOSE c_iv;
2022: --
2023: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,20);
2024: hr_cn_api.set_location(g_debug,' Input Value ID : '||to_char(l_iv_id),25);
2025: --
2026: OPEN c_exists (l_iv_id);
2027: FETCH c_exists

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

2020: --
2021: CLOSE c_iv;
2022: --
2023: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,20);
2024: hr_cn_api.set_location(g_debug,' Input Value ID : '||to_char(l_iv_id),25);
2025: --
2026: OPEN c_exists (l_iv_id);
2027: FETCH c_exists
2028: INTO l_eff_start_date;

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

2028: INTO l_eff_start_date;
2029: --
2030: IF c_exists%NOTFOUND THEN
2031: --
2032: hr_cn_api.set_location (g_debug, g_procedure_name, 32);
2033: --
2034: -- Bug 3456162 added the code
2035: --
2036: OPEN c_asg_status (p_calculation_date + 1);

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

2038: INTO l_asg_status;
2039:
2040: IF c_asg_status%NOTFOUND THEN
2041: --
2042: hr_cn_api.set_location(g_debug,' Employee is terminated on last day. Not calling pay_element_entry_api.',33);
2043: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,33);
2044: RETURN l_message;
2045: --
2046: END IF;

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

2039:
2040: IF c_asg_status%NOTFOUND THEN
2041: --
2042: hr_cn_api.set_location(g_debug,' Employee is terminated on last day. Not calling pay_element_entry_api.',33);
2043: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,33);
2044: RETURN l_message;
2045: --
2046: END IF;
2047: CLOSE c_asg_status;

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

2058: ELSE
2059: --
2060: -- Bug 3057542 changes
2061: --
2062: hr_cn_api.set_location (g_debug, g_procedure_name, 34);
2063:
2064: IF (l_eff_start_date = p_calculation_date + 1) THEN
2065:
2066: OPEN c_ovn (p_calculation_date+1);

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

2071: l_upd_mode := 'CORRECTION';
2072: --
2073: ELSE
2074:
2075: hr_cn_api.set_location (g_debug, g_procedure_name, 36);
2076:
2077: OPEN c_ovn (p_calculation_date);
2078: FETCH c_ovn
2079: INTO l_ovn;

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

2088: --
2089: END IF;
2090: CLOSE c_exists;
2091: --
2092: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,40);
2093: IF g_debug THEN
2094: hr_utility.trace(' ==============================================');
2095: hr_utility.trace ('. Calling pay_element_entry_api.');
2096: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));

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

2118:
2119: EXCEPTION
2120: WHEN OTHERS THEN
2121: --
2122: hr_cn_api.set_location(g_debug,' . Error in pay_element_entry_api.',5);
2123: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,5);
2124: l_message := SUBSTRB(SQLERRM,1,240);
2125: RETURN l_message;
2126: --

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

2119: EXCEPTION
2120: WHEN OTHERS THEN
2121: --
2122: hr_cn_api.set_location(g_debug,' . Error in pay_element_entry_api.',5);
2123: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,5);
2124: l_message := SUBSTRB(SQLERRM,1,240);
2125: RETURN l_message;
2126: --
2127: END;

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

2125: RETURN l_message;
2126: --
2127: END;
2128: --
2129: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name,50);
2130: RETURN l_message;
2131: --
2132: EXCEPTION
2133: WHEN OTHERS THEN

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

2130: RETURN l_message;
2131: --
2132: EXCEPTION
2133: WHEN OTHERS THEN
2134: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2135: RETURN l_message;
2136:
2137: END update_element_entry;
2138:

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

2171: IS
2172: l_amount NUMBER;
2173: BEGIN
2174: g_procedure_name := g_package_name||'get_cont_amount';
2175: hr_cn_api.set_location(g_debug,' Entering : '||g_procedure_name, 10);
2176:
2177: p_message := 'SUCCESS';
2178: IF g_debug THEN
2179: hr_utility.trace(' ==============================================');

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

2200: hr_utility.trace(' . Rounded Amount : '||l_amount);
2201: hr_utility.trace(' ==============================================');
2202: END IF;
2203:
2204: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
2205: RETURN l_amount;
2206:
2207: EXCEPTION
2208: WHEN OTHERS THEN

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

2205: RETURN l_amount;
2206:
2207: EXCEPTION
2208: WHEN OTHERS THEN
2209: p_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2210: RETURN hr_api.g_number;
2211:
2212: END get_cont_amount;
2213:

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

2265: l_probation_flag VARCHAR2(1);
2266: l_temp NUMBER;
2267: BEGIN
2268: g_procedure_name := g_package_name||'get_phf_si_deferred_amounts';
2269: hr_cn_api.set_location(g_debug,' Entering: '||g_procedure_name, 10);
2270:
2271: l_message := 'SUCCESS';
2272: l_default_date := TO_DATE ('01-01-0001','DD-MM-YYYY');
2273:

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

2295: ELSE
2296: l_probation_end_date := p_actual_probation_end_date;
2297: END IF;
2298:
2299: hr_cn_api.set_location (g_debug,'Probation End Date : '||l_probation_end_date,15);
2300:
2301: IF l_probation_end_date = pay_cn_deductions.g_start_date THEN
2302: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
2303: l_probation_flag := 'N';

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

2298:
2299: hr_cn_api.set_location (g_debug,'Probation End Date : '||l_probation_end_date,15);
2300:
2301: IF l_probation_end_date = pay_cn_deductions.g_start_date THEN
2302: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
2303: l_probation_flag := 'N';
2304: END IF;
2305:
2306: hr_cn_api.set_location (g_debug,'Probation Flag After being Set : '||l_probation_flag,25);

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

2302: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 20);
2303: l_probation_flag := 'N';
2304: END IF;
2305:
2306: hr_cn_api.set_location (g_debug,'Probation Flag After being Set : '||l_probation_flag,25);
2307: --3042788
2308: --
2309: -- Bug 3017511 changes. Logic Changed since deduct in probation expiry was not
2310: -- being considered at all

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

2320: )
2321: THEN
2322:
2323: IF p_undeducted_ee_phf_ltd >0 THEN
2324: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 30);
2325: p_ee_phf_si_amount := p_ee_phf_si_amount + p_undeducted_ee_phf_ltd;
2326: p_undeducted_ee_phf_ltd := 0 - p_undeducted_ee_phf_ltd;
2327:
2328: END IF;

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

2327:
2328: END IF;
2329:
2330: IF p_undeducted_er_phf_ltd >0 THEN
2331: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);
2332: p_er_phf_si_amount := p_er_phf_si_amount + p_undeducted_er_phf_ltd;
2333: p_undeducted_er_phf_ltd := 0 - p_undeducted_er_phf_ltd;
2334: END IF;
2335:

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

2337: --
2338: -- Bug 3017511 changes. Logic Changed since in case of deferment, undeducted phf
2339: -- was getting incorrectly fed.
2340: --
2341: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);
2342: p_undeducted_ee_phf_ltd := p_ee_phf_si_amount;
2343: p_ee_phf_si_amount := 0;
2344:
2345: p_undeducted_er_phf_ltd := p_er_phf_si_amount;

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

2355: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2356: hr_utility.trace(' ==============================================');
2357: END IF;
2358:
2359: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 60);
2360: RETURN l_message;
2361:
2362: EXCEPTION
2363: WHEN OTHERS THEN

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

2360: RETURN l_message;
2361:
2362: EXCEPTION
2363: WHEN OTHERS THEN
2364: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2365: RETURN l_message;
2366: END get_phf_si_deferred_amounts;
2367:
2368: ----------------------------------------------------------------------------

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

2425: RETURN l_def_bal_id;
2426:
2427: EXCEPTION
2428: WHEN OTHERS THEN
2429: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2430: hr_utility.trace(l_message);
2431:
2432: END get_def_bal_id ;
2433:

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

2490: l_message VARCHAR2(80);
2491: BEGIN
2492: g_procedure_name := g_package_name||'get_phf_si_balances';
2493:
2494: hr_cn_api.set_location(g_debug,' Entering : '||g_procedure_name, 10);
2495:
2496: l_message := 'SUCCESS';
2497:
2498: --

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

2549: IF g_debug THEN
2550: hr_utility.trace ('===================== Balance Values =========================');
2551: END IF;
2552:
2553: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
2554:
2555: EXCEPTION
2556: WHEN OTHERS THEN
2557: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);

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

2553: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
2554:
2555: EXCEPTION
2556: WHEN OTHERS THEN
2557: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2558: hr_utility.trace(l_message);
2559:
2560: END get_phf_si_balances;
2561:

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

2708:
2709: BEGIN
2710:
2711:
2712: hr_cn_api.set_location(g_debug,' Entering PHF and SI Enhancements started from 1-Jan-2006 : ', 230);
2713:
2714:
2715: IF g_debug THEN
2716: hr_utility.trace(' =======================================================');

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

2882: l_out_ee_hi_cont_base_amount := 0;
2883: END IF;
2884: /* Changes for bug 8838185 end */
2885: IF l_out_ee_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, 240);
2887: RAISE initialize_on_error;
2888: END IF;
2889:
2890: END IF;

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

2905: l_out_er_hi_cont_base_amount := 0;
2906: END IF;
2907: /* Changes for bug 8838185 end */
2908: IF l_out_er_hi_cont_base_amount = hr_api.g_number AND l_message <> 'SUCCESS' THEN
2909: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 250);
2910: RAISE initialize_on_error;
2911: END IF;
2912: END IF;
2913:

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

2919: ,p_rate_amount => l_ee_hi_cont_amt
2920: ,p_rounding_method => l_ee_rate_rounding_method
2921: ,p_message => l_message);
2922:
2923: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount_higher : '||l_ee_phf_si_amount_higher, 260);
2924:
2925: IF l_message <> 'SUCCESS' THEN
2926: l_ee_phf_si_amount_higher := 0;
2927: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 270);

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

2923: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount_higher : '||l_ee_phf_si_amount_higher, 260);
2924:
2925: IF l_message <> 'SUCCESS' THEN
2926: l_ee_phf_si_amount_higher := 0;
2927: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 270);
2928: RETURN l_message;
2929: END IF;
2930:
2931: l_er_phf_si_amount_higher :=

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

2935: ,p_rate_amount => l_er_hi_cont_amt
2936: ,p_rounding_method => l_er_rate_rounding_method
2937: ,p_message => l_message);
2938:
2939: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount_higher : '||l_er_phf_si_amount_higher, 280);
2940:
2941: IF l_message <> 'SUCCESS' THEN
2942: l_er_phf_si_amount_higher := 0;
2943: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 290);

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

2939: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount_higher : '||l_er_phf_si_amount_higher, 280);
2940:
2941: IF l_message <> 'SUCCESS' THEN
2942: l_er_phf_si_amount_higher := 0;
2943: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 290);
2944: RETURN l_message;
2945: END IF;
2946:
2947:

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

3026: ,p_message => l_message);
3027:
3028: IF l_message <> 'SUCCESS' THEN
3029: l_ee_phf_si_amount := 0;
3030: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 305);
3031: RETURN l_message;
3032: END IF;
3033:
3034: ELSE

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

3041: ,p_message => l_message);
3042:
3043: IF l_message <> 'SUCCESS' THEN
3044: l_ee_phf_si_amount := 0;
3045: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 310);
3046: RETURN l_message;
3047: END IF;
3048: END IF;
3049: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount : '||l_ee_phf_si_amount, 320);

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

3045: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 310);
3046: RETURN l_message;
3047: END IF;
3048: END IF;
3049: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount : '||l_ee_phf_si_amount, 320);
3050: ELSE
3051:
3052: IF l_ee_tax_thrhld_rate IS NULL THEN
3053:

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

3066: END IF;
3067:
3068: IF l_message <> 'SUCCESS' THEN
3069: l_ee_phf_si_amount := 0;
3070: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 330);
3071: RETURN l_message;
3072: END IF;
3073:
3074: hr_cn_api.set_location(g_debug,' l_ee_stat_fixed_amount : '||l_ee_stat_fixed_amount, 340);

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

3070: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 330);
3071: RETURN l_message;
3072: END IF;
3073:
3074: hr_cn_api.set_location(g_debug,' l_ee_stat_fixed_amount : '||l_ee_stat_fixed_amount, 340);
3075: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount_higher : '||l_ee_phf_si_amount_higher, 350);
3076:
3077: IF (l_ee_phf_si_amount_higher >l_ee_stat_fixed_amount) THEN
3078: l_ee_phf_si_amount := l_ee_stat_fixed_amount;

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

3071: RETURN l_message;
3072: END IF;
3073:
3074: hr_cn_api.set_location(g_debug,' l_ee_stat_fixed_amount : '||l_ee_stat_fixed_amount, 340);
3075: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount_higher : '||l_ee_phf_si_amount_higher, 350);
3076:
3077: IF (l_ee_phf_si_amount_higher >l_ee_stat_fixed_amount) THEN
3078: l_ee_phf_si_amount := l_ee_stat_fixed_amount;
3079: ELSE

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

3078: l_ee_phf_si_amount := l_ee_stat_fixed_amount;
3079: ELSE
3080: l_ee_phf_si_amount := l_ee_phf_si_amount_higher;
3081: END IF;
3082: hr_cn_api.set_location(g_debug,' l_ee_phf_si_amount : '||l_ee_phf_si_amount, 360);
3083: END IF;
3084:
3085: IF (l_er_hi_cont_type = 'PERCENTAGE') THEN
3086: IF(l_er_hi_cont_amt > l_er_stat_percentage) THEN

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

3093: ,p_message => l_message);
3094:
3095: IF l_message <> 'SUCCESS' THEN
3096: l_er_phf_si_amount := 0;
3097: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 370);
3098: RETURN l_message;
3099: END IF;
3100: ELSE
3101: l_er_phf_si_amount :=

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

3107: ,p_message => l_message);
3108:
3109: IF l_message <> 'SUCCESS' THEN
3110: l_er_phf_si_amount := 0;
3111: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 380);
3112: RETURN l_message;
3113: END IF;
3114: END IF;
3115: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount : '||l_er_phf_si_amount, 390);

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

3111: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 380);
3112: RETURN l_message;
3113: END IF;
3114: END IF;
3115: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount : '||l_er_phf_si_amount, 390);
3116: ELSE
3117:
3118: IF l_er_tax_thrhld_rate IS NULL THEN
3119:

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

3132: END IF;
3133:
3134: IF l_message <> 'SUCCESS' THEN
3135: l_er_phf_si_amount := 0;
3136: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 400);
3137: RETURN l_message;
3138: END IF;
3139:
3140: hr_cn_api.set_location(g_debug,' l_er_stat_fixed_amount : '||l_er_stat_fixed_amount, 410);

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

3136: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 400);
3137: RETURN l_message;
3138: END IF;
3139:
3140: hr_cn_api.set_location(g_debug,' l_er_stat_fixed_amount : '||l_er_stat_fixed_amount, 410);
3141: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount_higher : '||l_er_phf_si_amount_higher, 420);
3142:
3143: IF (l_er_phf_si_amount_higher >l_er_stat_fixed_amount) THEN
3144: l_er_phf_si_amount := l_er_stat_fixed_amount;

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

3137: RETURN l_message;
3138: END IF;
3139:
3140: hr_cn_api.set_location(g_debug,' l_er_stat_fixed_amount : '||l_er_stat_fixed_amount, 410);
3141: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount_higher : '||l_er_phf_si_amount_higher, 420);
3142:
3143: IF (l_er_phf_si_amount_higher >l_er_stat_fixed_amount) THEN
3144: l_er_phf_si_amount := l_er_stat_fixed_amount;
3145: ELSE

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

3144: l_er_phf_si_amount := l_er_stat_fixed_amount;
3145: ELSE
3146: l_er_phf_si_amount := l_er_phf_si_amount_higher;
3147: END IF;
3148: hr_cn_api.set_location(g_debug,' l_er_phf_si_amount : '||l_er_phf_si_amount, 430);
3149: END IF;
3150:
3151: l_ee_taxable_cont := GREATEST(l_ee_phf_si_amount_higher - l_ee_phf_si_amount, 0);
3152: l_er_taxable_cont := GREATEST(l_er_phf_si_amount_higher - l_er_phf_si_amount, 0);

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

3156:
3157: END IF;
3158:
3159:
3160: hr_cn_api.set_location(g_debug,' l_ee_taxable_cont : '|| l_ee_taxable_cont, 440);
3161: hr_cn_api.set_location(g_debug,' l_er_taxable_cont : '|| l_er_taxable_cont, 450);
3162:
3163: p_ee_taxable_cont := l_ee_taxable_cont;
3164: p_er_taxable_cont := l_er_taxable_cont;

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

3157: END IF;
3158:
3159:
3160: hr_cn_api.set_location(g_debug,' l_ee_taxable_cont : '|| l_ee_taxable_cont, 440);
3161: hr_cn_api.set_location(g_debug,' l_er_taxable_cont : '|| l_er_taxable_cont, 450);
3162:
3163: p_ee_taxable_cont := l_ee_taxable_cont;
3164: p_er_taxable_cont := l_er_taxable_cont;
3165: p_ee_phf_si_amount := l_ee_phf_si_amount_higher;

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

3180: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );
3181: hr_utility.trace(' =======================================================');
3182: END IF;
3183:
3184: hr_cn_api.set_location(g_debug,' Leaving PHF and SI Enhancements started from 1-Jan-2006: ', 460);
3185:
3186: ---------------------------------------------------------------------------------------------
3187: /* End Bug 5563042 (PHF and SI Enhancements) check for employee level data */
3188: ---------------------------------------------------------------------------------------------

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

3189: RETURN 'SUCCESS';
3190:
3191: EXCEPTION
3192: WHEN OTHERS THEN
3193: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
3194: RETURN l_message;
3195:
3196: END calculate_cont_jan_2006;
3197:

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

3411:
3412: g_debug := hr_utility.debug_enabled;
3413: g_procedure_name := g_package_name || 'calculate_contribution';
3414:
3415: hr_cn_api.set_location(g_debug, ' Entering: '||g_procedure_name, 10);
3416:
3417: l_ee_cont_base_amount := p_ee_cont_base_amount;
3418: l_er_cont_base_amount := p_er_cont_base_amount;
3419: l_calculation_date := p_calculation_date;

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

3478:
3479: hr_utility.trace(' Calculate_contribution : Message=>' || l_message);
3480: IF l_message <> 'SUCCESS'
3481: THEN
3482: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 25);
3483: RAISE initialize_on_error;
3484: END IF;
3485:
3486: --

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

3512: hr_utility.trace(' get_cont_base_method : Message=>' || l_message);
3513:
3514: IF l_message <> 'SUCCESS'
3515: THEN
3516: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 45);
3517: RAISE initialize_on_error;
3518: END IF;
3519:
3520: --

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

3576: ,p_message => l_message
3577: );
3578:
3579: IF l_message <> 'SUCCESS' THEN
3580: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 115);
3581: RAISE initialize_on_error;
3582: END IF;
3583:
3584: IF l_er_cont_base_asg_ltd = 0 THEN

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

3603: ,p_message => l_message
3604: );
3605:
3606: IF l_message <> 'SUCCESS' THEN
3607: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 155);
3608: RAISE initialize_on_error;
3609: END IF;
3610:
3611: l_calculation_date := g_end_date;

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

3628: ,p_fixed_amount => l_ee_fixed_amount
3629: ,p_cont_base_amount => l_ee_cont_base_amount);
3630:
3631: IF l_ee_cont_base_amount = hr_api.g_number AND l_message <> 'SUCCESS' THEN
3632: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 105);
3633: RAISE initialize_on_error;
3634: END IF;
3635:
3636: END IF;

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

3650: ,p_message => l_message
3651: );
3652:
3653: IF l_message <> 'SUCCESS' THEN
3654: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 115);
3655: RAISE initialize_on_error;
3656: END IF;
3657:
3658: IF NVL(l_er_cont_base_amount,0) = 0 THEN

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

3668: ,p_fixed_amount => l_er_fixed_amount
3669: ,p_cont_base_amount => l_er_cont_base_amount);
3670:
3671: IF l_er_cont_base_amount = hr_api.g_number AND l_message <> 'SUCCESS' THEN
3672: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 145);
3673: RAISE initialize_on_error;
3674: END IF;
3675:
3676: END IF;

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

3687: ,p_message => l_message
3688: );
3689:
3690: IF l_message <> 'SUCCESS' THEN
3691: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 155);
3692: RAISE initialize_on_error;
3693: END IF;
3694:
3695: --

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

3705: );
3706:
3707: IF l_message <> 'SUCCESS'
3708: THEN
3709: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 90);
3710: RAISE initialize_on_error;
3711: END IF; */
3712:
3713: END IF;

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

3759:
3760:
3761: IF l_message <> 'SUCCESS' THEN
3762: l_ee_phf_si_amount := 0;
3763: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 210);
3764: RETURN l_message;
3765: END IF;
3766:
3767: IF g_debug THEN

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

3782: ,p_message => l_message);
3783:
3784: IF l_message <> 'SUCCESS' THEN
3785: l_er_phf_si_amount := 0;
3786: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 220);
3787: RETURN l_message;
3788: END IF;
3789:
3790:

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

3899:
3900: );
3901:
3902: IF l_message <> 'SUCCESS' THEN
3903: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 220);
3904: RETURN l_message;
3905: END IF;
3906: END IF;
3907: END IF;

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

3950: );
3951:
3952: IF l_message <> 'SUCCESS' THEN
3953: l_ee_phf_si_amount := 0;
3954: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 285);
3955: RETURN l_message;
3956: END IF;
3957:
3958: --

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

4011: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);
4012: hr_utility.trace(' =====================================================================');
4013: END IF;
4014:
4015: hr_cn_api.set_location(g_debug,' Leaving ' || g_procedure_name,300);
4016: RETURN l_message;
4017:
4018:
4019: EXCEPTION

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

4033: p_new_ee_cont_base_amount := NULL;
4034: p_new_er_cont_base_amount := NULL;
4035: p_undeducted_ee_phf_si_amount := NULL;
4036: p_undeducted_er_phf_si_amount := NULL;
4037: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
4038: RETURN l_message;
4039: END calculate_contribution;
4040:
4041: --------------------------------------------------------------------------

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

4066: -- p_effective_start_date DATE --
4067: -- p_effective_end_date DATE --
4068: -- IN/ OUT : --
4069: -- OUT : p_message_name NOCOPY VARCHAR2 --
4070: -- p_token_name NOCOPY hr_cn_api.char_tab_type --
4071: -- p_token_value NOCOPY hr_cn_api.char_tab_type --
4072: -- --
4073: -- Change History : --
4074: --------------------------------------------------------------------------

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

4067: -- p_effective_end_date DATE --
4068: -- IN/ OUT : --
4069: -- OUT : p_message_name NOCOPY VARCHAR2 --
4070: -- p_token_name NOCOPY hr_cn_api.char_tab_type --
4071: -- p_token_value NOCOPY hr_cn_api.char_tab_type --
4072: -- --
4073: -- Change History : --
4074: --------------------------------------------------------------------------
4075: -- Rev# Date Userid Description --

Line 4102: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type

4098: ,p_er_fixed_amount IN NUMBER
4099: ,p_effective_start_date IN DATE
4100: ,p_effective_end_date IN DATE
4101: ,p_message_name OUT NOCOPY VARCHAR2
4102: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
4103: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
4104: )
4105: AS
4106:

Line 4103: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type

4099: ,p_effective_start_date IN DATE
4100: ,p_effective_end_date IN DATE
4101: ,p_message_name OUT NOCOPY VARCHAR2
4102: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
4103: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
4104: )
4105: AS
4106:
4107: l_flag BOOLEAN;

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

4128: IF NOT l_flag THEN
4129:
4130: hr_utility.trace('Invalid Contribution Base Setup');
4131:
4132: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Periodicity'
4133: ,p_dff => 'Org Developer DF'
4134: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4135: );
4136:

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

4133: ,p_dff => 'Org Developer DF'
4134: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4135: );
4136:
4137: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'EE Cont Base Method'
4138: ,p_dff => 'Org Developer DF'
4139: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4140: );
4141:

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

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

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

4173: IF l_return_segment = 'Fixed Amount' THEN
4174: l_return_segment := 'EE Fixed Amount';
4175: END IF;
4176:
4177: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => l_return_segment
4178: ,p_dff => 'Org Developer DF'
4179: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4180: );
4181:

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

4200: );
4201:
4202: IF NOT l_flag THEN
4203:
4204: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Periodicity'
4205: ,p_dff => 'Org Developer DF'
4206: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4207: );
4208:

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

4205: ,p_dff => 'Org Developer DF'
4206: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4207: );
4208:
4209: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'ER Cont Base Method'
4210: ,p_dff => 'Org Developer DF'
4211: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4212: );
4213:

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

4236: );
4237:
4238: IF NOT l_flag THEN
4239:
4240: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'ER Cont Base Method'
4241: ,p_dff => 'Org Developer DF'
4242: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4243: );
4244:

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

4245: IF l_return_segment = 'Fixed Amount' THEN
4246: l_return_segment := 'EE Fixed Amount';
4247: END IF;
4248:
4249: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => l_return_segment
4250: ,p_dff => 'Org Developer DF'
4251: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4252: );
4253:

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

4278:
4279: IF NOT l_flag THEN
4280:
4281:
4282: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Low Limit Method'
4283: ,p_dff => 'Org Developer DF'
4284: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4285: );
4286:

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

4283: ,p_dff => 'Org Developer DF'
4284: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4285: );
4286:
4287: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => l_return_segment
4288: ,p_dff => 'Org Developer DF'
4289: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4290: );
4291:

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

4316: );
4317:
4318: IF NOT l_flag THEN
4319:
4320: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'High Limit Method'
4321: ,p_dff => 'Org Developer DF'
4322: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4323: );
4324:

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

4321: ,p_dff => 'Org Developer DF'
4322: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4323: );
4324:
4325: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => l_return_segment
4326: ,p_dff => 'Org Developer DF'
4327: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4328: );
4329:

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

4345: END IF;
4346:
4347: IF p_switch_periodicity = 'YEARLY' AND p_switch_month IS NULL THEN
4348:
4349: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Periodicity'
4350: ,p_dff => 'Org Developer DF'
4351: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4352: );
4353:

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

4350: ,p_dff => 'Org Developer DF'
4351: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4352: );
4353:
4354: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Month'
4355: ,p_dff => 'Org Developer DF'
4356: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'
4357: );
4358:

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

4390: -- p_effective_start_date DATE --
4391: -- p_effective_end_date DATE --
4392: -- IN/ OUT : --
4393: -- OUT : p_message_name NOCOPY VARCHAR2 --
4394: -- p_token_name NOCOPY hr_cn_api.char_tab_type --
4395: -- p_token_value NOCOPY hr_cn_api.char_tab_type --
4396: -- --
4397: -- Change History : --
4398: --------------------------------------------------------------------------

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

4391: -- p_effective_end_date DATE --
4392: -- IN/ OUT : --
4393: -- OUT : p_message_name NOCOPY VARCHAR2 --
4394: -- p_token_name NOCOPY hr_cn_api.char_tab_type --
4395: -- p_token_value NOCOPY hr_cn_api.char_tab_type --
4396: -- --
4397: -- Change History : --
4398: --------------------------------------------------------------------------
4399: -- Rev# Date Userid Description --

Line 4413: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type

4409: ,p_hukou_type IN VARCHAR2
4410: ,p_effective_start_date IN DATE
4411: ,p_effective_end_date IN DATE
4412: ,p_message_name OUT NOCOPY VARCHAR2
4413: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
4414: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
4415: )
4416: AS
4417:

Line 4414: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type

4410: ,p_effective_start_date IN DATE
4411: ,p_effective_end_date IN DATE
4412: ,p_message_name OUT NOCOPY VARCHAR2
4413: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
4414: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
4415: )
4416: AS
4417:
4418: l_indep_seg fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

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

4426:
4427: -- Code commented for bug 6943573
4428: /*
4429: IF p_hukou_type IS NOT NULL AND p_organization IS NULL THEN
4430: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Hukou Type'
4431: ,p_dff => 'Org Developer DF'
4432: ,p_dff_context_code => 'PER_CONT_AREA_PHF_SI_RATES_CN'
4433: );
4434:

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

4431: ,p_dff => 'Org Developer DF'
4432: ,p_dff_context_code => 'PER_CONT_AREA_PHF_SI_RATES_CN'
4433: );
4434:
4435: l_dep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Organization'
4436: ,p_dff => 'Org Developer DF'
4437: ,p_dff_context_code => 'PER_CONT_AREA_PHF_SI_RATES_CN'
4438: );
4439:

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

4574: hr_utility.trace(' get_cont_base_method : Message=>' || l_message);
4575:
4576: IF l_message <> 'SUCCESS'
4577: THEN
4578: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 10);
4579: RAISE initialize_on_error;
4580: END IF;
4581:
4582: IF l_switch_periodicity = 'YEARLY' THEN

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

4675: return l_message;
4676:
4677: EXCEPTION
4678: WHEN initialize_on_error THEN
4679: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
4680: WHEN OTHERS THEN
4681: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
4682: END get_phf_si_earnings;
4683:

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

4677: EXCEPTION
4678: WHEN initialize_on_error THEN
4679: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
4680: WHEN OTHERS THEN
4681: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
4682: END get_phf_si_earnings;
4683:
4684: --------------------------------------------------------------------------
4685: -- --