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.

[Home] [Help]

APPS.HR_AU_TAX_API dependencies on HR_UTILITY

Line 77: g_debug boolean := hr_utility.debug_enabled;

73: g_paye_input14 constant varchar2(60) := 'TAX FILE NUMBER';
74: g_paye_input15 constant varchar2(60) := 'SFSS';
75: g_legislation_code constant varchar2(2) := 'AU';
76:
77: g_debug boolean := hr_utility.debug_enabled;
78:
79:
80: PROCEDURE maintain_PAYE_tax_info
81: (p_validate IN BOOLEAN DEFAULT FALSE

Line 409: hr_utility.trace('after leave loading');

405: OPEN csr_leave_loading_flag (p_assignment_id, l_session_date);
406: FETCH csr_leave_loading_flag INTO l_lev_lod_flg;
407: CLOSE csr_leave_loading_flag;
408:
409: hr_utility.trace('after leave loading');
410:
411: --SFSS Value cannot exist before 31-JUL-2000
412: -- Bug#5258625
413: if ((l_session_date < to_date('31/07/2000','DD/MM/YYYY')) and (substr(P_help_sfss_flag,2,1) is not null)) then

Line 414: hr_utility.set_message(801,'HR_AU_SFSS_NOT_VALID');

410:
411: --SFSS Value cannot exist before 31-JUL-2000
412: -- Bug#5258625
413: if ((l_session_date < to_date('31/07/2000','DD/MM/YYYY')) and (substr(P_help_sfss_flag,2,1) is not null)) then
414: hr_utility.set_message(801,'HR_AU_SFSS_NOT_VALID');
415: hr_utility.raise_error;
416: end If;
417:
418: -- MLS is not valid before 01-JUL-2000

Line 415: hr_utility.raise_error;

411: --SFSS Value cannot exist before 31-JUL-2000
412: -- Bug#5258625
413: if ((l_session_date < to_date('31/07/2000','DD/MM/YYYY')) and (substr(P_help_sfss_flag,2,1) is not null)) then
414: hr_utility.set_message(801,'HR_AU_SFSS_NOT_VALID');
415: hr_utility.raise_error;
416: end If;
417:
418: -- MLS is not valid before 01-JUL-2000
419: if ((l_session_date < to_date('01/07/2000','DD/MM/YYYY')) and (substr(p_spouse_mls_flag,2,1) =

Line 422: hr_utility.set_message(801,'HR_AU_MLS_NOT_VALID');

418: -- MLS is not valid before 01-JUL-2000
419: if ((l_session_date < to_date('01/07/2000','DD/MM/YYYY')) and (substr(p_spouse_mls_flag,2,1) =
420: 'Y'))
421: then
422: hr_utility.set_message(801,'HR_AU_MLS_NOT_VALID');
423: hr_utility.raise_error;
424: end If;
425:
426:

Line 423: hr_utility.raise_error;

419: if ((l_session_date < to_date('01/07/2000','DD/MM/YYYY')) and (substr(p_spouse_mls_flag,2,1) =
420: 'Y'))
421: then
422: hr_utility.set_message(801,'HR_AU_MLS_NOT_VALID');
423: hr_utility.raise_error;
424: end If;
425:
426:
427: -- Derive the tax scale

Line 437: hr_utility.trace('Tax Scale : '||to_char(L_tax_scale));

433: ,p_lev_lod_flg => l_lev_lod_flg
434: ,p_medicare_levy_variation_code => p_medicare_levy_variation_code
435: ,p_tax_variation_type => substr(p_tax_variation_type,1,1) /*Bug 4598178*/
436: );
437: hr_utility.trace('Tax Scale : '||to_char(L_tax_scale));
438: --
439: -- Get the element type id for the Tax element
440: hr_utility.trace('element_type_id');
441: --

Line 440: hr_utility.trace('element_type_id');

436: );
437: hr_utility.trace('Tax Scale : '||to_char(L_tax_scale));
438: --
439: -- Get the element type id for the Tax element
440: hr_utility.trace('element_type_id');
441: --
442: OPEN csr_paye_tax_element;
443: fetch csr_paye_tax_element into l_element_type_id;
444: IF (csr_paye_tax_element%NOTFOUND)

Line 447: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');

443: fetch csr_paye_tax_element into l_element_type_id;
444: IF (csr_paye_tax_element%NOTFOUND)
445: THEN
446: CLOSE csr_paye_tax_element;
447: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
448: hr_utility.raise_error;
449: END IF;
450: CLOSE csr_paye_tax_element;
451:

Line 448: hr_utility.raise_error;

444: IF (csr_paye_tax_element%NOTFOUND)
445: THEN
446: CLOSE csr_paye_tax_element;
447: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
448: hr_utility.raise_error;
449: END IF;
450: CLOSE csr_paye_tax_element;
451:
452: --

Line 455: hr_utility.trace('input value id');

451:
452: --
453: -- Get the Input Value Id for each Tax Input
454:
455: hr_utility.trace('input value id');
456:
457: --
458: FOR rec_paye_tax_element in csr_paye_tax_input_values(l_element_type_id) LOOP
459: IF UPPER(rec_paye_tax_element.name) = 'AUSTRALIAN RESIDENT' THEN

Line 515: hr_utility.set_message(801,'HR_AU_ELE_LNK_NOT_FND');

511:
512:
513: IF (l_element_link_id IS NULL OR l_element_link_id = 0)
514: THEN
515: hr_utility.set_message(801,'HR_AU_ELE_LNK_NOT_FND');
516: hr_utility.raise_error;
517: END IF;
518:
519:

Line 516: hr_utility.raise_error;

512:
513: IF (l_element_link_id IS NULL OR l_element_link_id = 0)
514: THEN
515: hr_utility.set_message(801,'HR_AU_ELE_LNK_NOT_FND');
516: hr_utility.raise_error;
517: END IF;
518:
519:
520: IF (l_mode IN ('CORRECTION','UPDATE','UPDATE_CHANGE_INSERT','UPDATE_OVERRIDE')) THEN

Line 524: hr_utility.set_location('hr_au_tax_api.maintain_tax_info' ,7);

520: IF (l_mode IN ('CORRECTION','UPDATE','UPDATE_CHANGE_INSERT','UPDATE_OVERRIDE')) THEN
521: -----------------------------------------------------------------------------
522: -- Get the element entry of the tax element entry that is to be updated
523: ------------------------------------------------------------------------------
524: hr_utility.set_location('hr_au_tax_api.maintain_tax_info' ,7);
525:
526: OPEN csr_ele_entry(l_element_link_id, l_inp_value_id_table(1));
527: FETCH csr_ele_entry INTO l_element_entry_id,l_object_version_number;
528: IF (csr_ele_entry%NOTFOUND) THEN

Line 530: hr_utility.set_message(801,'HR_AU_ELE_ENT_NOT_FND');

526: OPEN csr_ele_entry(l_element_link_id, l_inp_value_id_table(1));
527: FETCH csr_ele_entry INTO l_element_entry_id,l_object_version_number;
528: IF (csr_ele_entry%NOTFOUND) THEN
529: CLOSE csr_ele_entry;
530: hr_utility.set_message(801,'HR_AU_ELE_ENT_NOT_FND');
531: hr_utility.raise_error;
532: END IF;
533: CLOSE csr_ele_entry;
534:

Line 531: hr_utility.raise_error;

527: FETCH csr_ele_entry INTO l_element_entry_id,l_object_version_number;
528: IF (csr_ele_entry%NOTFOUND) THEN
529: CLOSE csr_ele_entry;
530: hr_utility.set_message(801,'HR_AU_ELE_ENT_NOT_FND');
531: hr_utility.raise_error;
532: END IF;
533: CLOSE csr_ele_entry;
534:
535:

Line 559: hr_utility.trace('Session Date = '||l_session_date);

555: ELSE
556: l_upd_tax_scale := l_tax_scale;
557: END IF;
558:
559: hr_utility.trace('Session Date = '||l_session_date);
560: hr_utility.trace('to_date = '||to_date('01/07/2008','DD/MM/YYYY'));
561:
562: /* Bug 7042960: 2008 Statutory Updates - FTA Claim Changes */
563: IF (l_session_date >= to_date('01/07/2008','DD/MM/YYYY')) THEN

Line 560: hr_utility.trace('to_date = '||to_date('01/07/2008','DD/MM/YYYY'));

556: l_upd_tax_scale := l_tax_scale;
557: END IF;
558:
559: hr_utility.trace('Session Date = '||l_session_date);
560: hr_utility.trace('to_date = '||to_date('01/07/2008','DD/MM/YYYY'));
561:
562: /* Bug 7042960: 2008 Statutory Updates - FTA Claim Changes */
563: IF (l_session_date >= to_date('01/07/2008','DD/MM/YYYY')) THEN
564: open get_fta_claim_flag(p_fta_claim_flag);

Line 567: hr_utility.trace('Inside IF: l_fta_claim_flag Value = '||l_fta_claim_flag);

563: IF (l_session_date >= to_date('01/07/2008','DD/MM/YYYY')) THEN
564: open get_fta_claim_flag(p_fta_claim_flag);
565: fetch get_fta_claim_flag into l_fta_claim_flag;
566: close get_fta_claim_flag;
567: hr_utility.trace('Inside IF: l_fta_claim_flag Value = '||l_fta_claim_flag);
568: ELSE
569: l_fta_claim_flag := p_fta_claim_flag;
570: hr_utility.trace('Inside ELSE: l_fta_claim_flag Value = '||l_fta_claim_flag);
571: END IF;

Line 570: hr_utility.trace('Inside ELSE: l_fta_claim_flag Value = '||l_fta_claim_flag);

566: close get_fta_claim_flag;
567: hr_utility.trace('Inside IF: l_fta_claim_flag Value = '||l_fta_claim_flag);
568: ELSE
569: l_fta_claim_flag := p_fta_claim_flag;
570: hr_utility.trace('Inside ELSE: l_fta_claim_flag Value = '||l_fta_claim_flag);
571: END IF;
572:
573: -- Check if the API is called from Tax Declaration form or not
574:

Line 662: hr_utility.trace('Upd Tax Scale' || l_upd_tax_scale);

658: l_entry_information_category := 'AU_TAX DEDUCTIONS';
659: l_entry_information1 := null;
660: END IF;
661:
662: hr_utility.trace('Upd Tax Scale' || l_upd_tax_scale);
663: hr_utility.trace('fta_claim_flag' || p_fta_claim_flag);
664: py_element_entry_api.update_element_entry
665: (p_validate => p_validate
666: ,p_datetrack_update_mode=> l_mode

Line 663: hr_utility.trace('fta_claim_flag' || p_fta_claim_flag);

659: l_entry_information1 := null;
660: END IF;
661:
662: hr_utility.trace('Upd Tax Scale' || l_upd_tax_scale);
663: hr_utility.trace('fta_claim_flag' || p_fta_claim_flag);
664: py_element_entry_api.update_element_entry
665: (p_validate => p_validate
666: ,p_datetrack_update_mode=> l_mode
667: ,p_effective_date => l_session_date

Line 857: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');

853: FETCH csr_paye_tax_element INTO l_element_type_id;
854: IF (csr_paye_tax_element%NOTFOUND)
855: THEN
856: CLOSE csr_paye_tax_element;
857: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
858: hr_utility.raise_error;
859: END IF;
860: CLOSE csr_paye_tax_element;
861:

Line 858: hr_utility.raise_error;

854: IF (csr_paye_tax_element%NOTFOUND)
855: THEN
856: CLOSE csr_paye_tax_element;
857: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
858: hr_utility.raise_error;
859: END IF;
860: CLOSE csr_paye_tax_element;
861:
862: --

Line 880: hr_utility.set_message(801,'HR_AU_ELE_LNK_NOT_FND');

876: ,p_element_type_id => l_element_type_id
877: ,p_session_date => l_session_date);
878: IF (l_element_link_id IS NULL OR l_element_link_id = 0)
879: THEN
880: hr_utility.set_message(801,'HR_AU_ELE_LNK_NOT_FND');
881: hr_utility.raise_error;
882: END IF;
883:
884: IF (p_mode IN ('CORRECTION','UPDATE','UPDATE_CHANGE_INSERT','UPDATE_OVERRIDE')) THEN

Line 881: hr_utility.raise_error;

877: ,p_session_date => l_session_date);
878: IF (l_element_link_id IS NULL OR l_element_link_id = 0)
879: THEN
880: hr_utility.set_message(801,'HR_AU_ELE_LNK_NOT_FND');
881: hr_utility.raise_error;
882: END IF;
883:
884: IF (p_mode IN ('CORRECTION','UPDATE','UPDATE_CHANGE_INSERT','UPDATE_OVERRIDE')) THEN
885:

Line 890: hr_utility.set_location('hr_au_tax_api.maintain_tax_info' ,7);

886: -----------------------------------------------------------------------------
887: -- Get the element entry of the tax element entry that is to be updated
888: ------------------------------------------------------------------------------
889:
890: hr_utility.set_location('hr_au_tax_api.maintain_tax_info' ,7);
891:
892: OPEN csr_ele_entry(l_element_link_id, l_inp_value_id_table(1));
893: FETCH csr_ele_entry INTO l_element_entry_id,l_object_version_number;
894: IF (csr_ele_entry%NOTFOUND) THEN

Line 896: hr_utility.set_message(801,'HR_AU_ELE_ENT_NOT_FND');

892: OPEN csr_ele_entry(l_element_link_id, l_inp_value_id_table(1));
893: FETCH csr_ele_entry INTO l_element_entry_id,l_object_version_number;
894: IF (csr_ele_entry%NOTFOUND) THEN
895: CLOSE csr_ele_entry;
896: hr_utility.set_message(801,'HR_AU_ELE_ENT_NOT_FND');
897: hr_utility.raise_error;
898: END IF;
899: CLOSE csr_ele_entry;
900:

Line 897: hr_utility.raise_error;

893: FETCH csr_ele_entry INTO l_element_entry_id,l_object_version_number;
894: IF (csr_ele_entry%NOTFOUND) THEN
895: CLOSE csr_ele_entry;
896: hr_utility.set_message(801,'HR_AU_ELE_ENT_NOT_FND');
897: hr_utility.raise_error;
898: END IF;
899: CLOSE csr_ele_entry;
900:
901: -- Bug 2601218 : Update 'Tax Information' segment 1 as last update date

Line 1002: hr_utility.set_location(g_package||l_procedure, 1);

998: BEGIN
999: l_procedure := 'tax_scale'; -- Bug No: 3648796
1000: L_tax_scale := -1; -- Bug No: 3648796
1001:
1002: hr_utility.set_location(g_package||l_procedure, 1);
1003: hr_utility.trace('p_tax_file_number - '||p_tax_file_number);
1004: hr_utility.trace('p_australian_resident_flag - '||p_australian_resident_flag);
1005: hr_utility.trace('p_tax_free_threshold_flag - '||p_tax_free_threshold_flag);
1006: hr_utility.trace('p_lev_lod_flg - '||p_lev_lod_flg);

Line 1003: hr_utility.trace('p_tax_file_number - '||p_tax_file_number);

999: l_procedure := 'tax_scale'; -- Bug No: 3648796
1000: L_tax_scale := -1; -- Bug No: 3648796
1001:
1002: hr_utility.set_location(g_package||l_procedure, 1);
1003: hr_utility.trace('p_tax_file_number - '||p_tax_file_number);
1004: hr_utility.trace('p_australian_resident_flag - '||p_australian_resident_flag);
1005: hr_utility.trace('p_tax_free_threshold_flag - '||p_tax_free_threshold_flag);
1006: hr_utility.trace('p_lev_lod_flg - '||p_lev_lod_flg);
1007: hr_utility.trace('p_medicare_levy_variation_code - '||p_medicare_levy_variation_code);

Line 1004: hr_utility.trace('p_australian_resident_flag - '||p_australian_resident_flag);

1000: L_tax_scale := -1; -- Bug No: 3648796
1001:
1002: hr_utility.set_location(g_package||l_procedure, 1);
1003: hr_utility.trace('p_tax_file_number - '||p_tax_file_number);
1004: hr_utility.trace('p_australian_resident_flag - '||p_australian_resident_flag);
1005: hr_utility.trace('p_tax_free_threshold_flag - '||p_tax_free_threshold_flag);
1006: hr_utility.trace('p_lev_lod_flg - '||p_lev_lod_flg);
1007: hr_utility.trace('p_medicare_levy_variation_code - '||p_medicare_levy_variation_code);
1008: hr_utility.trace('p_tax_variation_type - '||p_tax_variation_type);

Line 1005: hr_utility.trace('p_tax_free_threshold_flag - '||p_tax_free_threshold_flag);

1001:
1002: hr_utility.set_location(g_package||l_procedure, 1);
1003: hr_utility.trace('p_tax_file_number - '||p_tax_file_number);
1004: hr_utility.trace('p_australian_resident_flag - '||p_australian_resident_flag);
1005: hr_utility.trace('p_tax_free_threshold_flag - '||p_tax_free_threshold_flag);
1006: hr_utility.trace('p_lev_lod_flg - '||p_lev_lod_flg);
1007: hr_utility.trace('p_medicare_levy_variation_code - '||p_medicare_levy_variation_code);
1008: hr_utility.trace('p_tax_variation_type - '||p_tax_variation_type);
1009: --

Line 1006: hr_utility.trace('p_lev_lod_flg - '||p_lev_lod_flg);

1002: hr_utility.set_location(g_package||l_procedure, 1);
1003: hr_utility.trace('p_tax_file_number - '||p_tax_file_number);
1004: hr_utility.trace('p_australian_resident_flag - '||p_australian_resident_flag);
1005: hr_utility.trace('p_tax_free_threshold_flag - '||p_tax_free_threshold_flag);
1006: hr_utility.trace('p_lev_lod_flg - '||p_lev_lod_flg);
1007: hr_utility.trace('p_medicare_levy_variation_code - '||p_medicare_levy_variation_code);
1008: hr_utility.trace('p_tax_variation_type - '||p_tax_variation_type);
1009: --
1010: -- Check if a valid TFN has been supplied

Line 1007: hr_utility.trace('p_medicare_levy_variation_code - '||p_medicare_levy_variation_code);

1003: hr_utility.trace('p_tax_file_number - '||p_tax_file_number);
1004: hr_utility.trace('p_australian_resident_flag - '||p_australian_resident_flag);
1005: hr_utility.trace('p_tax_free_threshold_flag - '||p_tax_free_threshold_flag);
1006: hr_utility.trace('p_lev_lod_flg - '||p_lev_lod_flg);
1007: hr_utility.trace('p_medicare_levy_variation_code - '||p_medicare_levy_variation_code);
1008: hr_utility.trace('p_tax_variation_type - '||p_tax_variation_type);
1009: --
1010: -- Check if a valid TFN has been supplied
1011: IF nvl(P_Tax_File_number,'000 000 000') ='000 000 000' THEN

Line 1008: hr_utility.trace('p_tax_variation_type - '||p_tax_variation_type);

1004: hr_utility.trace('p_australian_resident_flag - '||p_australian_resident_flag);
1005: hr_utility.trace('p_tax_free_threshold_flag - '||p_tax_free_threshold_flag);
1006: hr_utility.trace('p_lev_lod_flg - '||p_lev_lod_flg);
1007: hr_utility.trace('p_medicare_levy_variation_code - '||p_medicare_levy_variation_code);
1008: hr_utility.trace('p_tax_variation_type - '||p_tax_variation_type);
1009: --
1010: -- Check if a valid TFN has been supplied
1011: IF nvl(P_Tax_File_number,'000 000 000') ='000 000 000' THEN
1012: L_valid_tfn_provided := FALSE;

Line 1023: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));

1019: L_tax_scale := 8;
1020:
1021: -- No further processing needed.
1022: -- Bug 980658
1023: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));
1024: return (L_tax_scale);
1025: END IF;
1026:
1027: -- TAX SCALE 9

Line 1032: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));

1028: IF P_tax_variation_Type = 'P' THEN
1029: L_tax_scale := 9;
1030: -- No further processing needed.
1031: -- Bug 980658
1032: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));
1033: return (L_tax_scale);
1034: END IF;
1035:
1036: -- TAX SCALE 10

Line 1041: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));

1037: IF P_tax_variation_Type = 'F' THEN
1038: L_tax_scale := 10;
1039: -- No further processing needed.
1040: -- Bug 980658
1041: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));
1042: return (L_tax_scale);
1043: END IF;
1044:
1045: -- TAX SCALE 4

Line 1052: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));

1048: L_tax_scale := 4;
1049:
1050: -- No further processing necessary, is no valid TFN supplied
1051: -- then always scale 4. Refer to bug 971984
1052: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));
1053: return (L_tax_scale);
1054: END IF;
1055:
1056: -- TAX SCALE 3

Line 1064: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));

1060:
1061: -- No further processing needed.
1062: -- If a person has a TFN and is non resident the scale is
1063: -- always 3, refer to bug 971982
1064: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));
1065: return (L_tax_scale);
1066: END IF;
1067:
1068: -- TAX SCALE 1

Line 1076: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));

1072: L_tax_scale := 1;
1073:
1074: -- No further processing needed.
1075: -- Bug 971980
1076: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));
1077: return (L_tax_scale);
1078: END IF;
1079:
1080: -- Bug 2145933 - Tax Scales 11 - 13 based on Tax Scales C,S,I

Line 1085: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));

1081:
1082: IF L_valid_tfn_provided
1083: AND substr(p_australian_resident_flag,2,1) = 'S' THEN
1084: L_tax_scale := 11;
1085: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));
1086: return(L_tax_scale);
1087: END IF;
1088:
1089: IF L_valid_tfn_provided

Line 1092: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));

1088:
1089: IF L_valid_tfn_provided
1090: AND substr(p_australian_resident_flag,2,1) = 'I' THEN
1091: L_tax_scale := 12;
1092: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));
1093: return(L_tax_scale);
1094: END IF;
1095:
1096: IF L_valid_tfn_provided

Line 1099: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));

1095:
1096: IF L_valid_tfn_provided
1097: AND substr(p_australian_resident_flag,2,1) = 'C' THEN
1098: L_tax_scale := 13;
1099: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));
1100: return(L_tax_scale);
1101: END IF;
1102:
1103:

Line 1112: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));

1108: AND P_medicare_levy_variation_code = 'F' THEN
1109: L_tax_scale := 5;
1110: -- No further processing needed.
1111: -- Bug 971978
1112: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));
1113: return (L_tax_scale);
1114: END IF;
1115:
1116: -- TAX SCALE 6

Line 1122: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));

1118: AND substr(P_australian_resident_flag,1,1) = 'Y' /* Bug 2145933 */
1119: AND P_tax_free_threshold_flag = 'Y'
1120: AND p_medicare_levy_variation_code in ('H','HA') THEN
1121: L_tax_scale := 6;
1122: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));
1123: return (L_tax_scale);
1124: END IF;
1125:
1126: -- TAX SCALE 2

Line 1132: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));

1128: AND substr(P_australian_resident_flag,1,1) = 'Y' /* Bug 2145933 */
1129: AND P_tax_free_threshold_flag = 'Y'
1130: AND P_lev_lod_flg = 'Y' THEN
1131: L_tax_scale := 2;
1132: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));
1133: return (L_tax_scale);
1134: END IF;
1135:
1136: -- TAX SCALE 7

Line 1142: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));

1138: AND substr(P_australian_resident_flag,1,1) = 'Y' /* Bug 2145933 */
1139: AND P_tax_free_threshold_flag = 'Y'
1140: AND P_lev_lod_flg = 'N' THEN
1141: L_tax_scale := 7;
1142: hr_utility.trace('tax_scale - '||to_char(l_tax_scale));
1143: return (L_tax_scale);
1144: END IF;
1145:
1146: return (L_tax_scale);

Line 1206: hr_utility.set_message(801, 'HR_AU_INVALID_NATIONAL_ID');

1202: '222 222 222' ) THEN
1203: null;
1204:
1205: ELSE
1206: hr_utility.set_message(801, 'HR_AU_INVALID_NATIONAL_ID');
1207: hr_utility.raise_error;
1208:
1209: END IF;
1210: EXCEPTION WHEN OTHERS THEN

Line 1207: hr_utility.raise_error;

1203: null;
1204:
1205: ELSE
1206: hr_utility.set_message(801, 'HR_AU_INVALID_NATIONAL_ID');
1207: hr_utility.raise_error;
1208:
1209: END IF;
1210: EXCEPTION WHEN OTHERS THEN
1211: hr_utility.set_message(801, 'HR_AU_INVALID_NATIONAL_ID');

Line 1211: hr_utility.set_message(801, 'HR_AU_INVALID_NATIONAL_ID');

1207: hr_utility.raise_error;
1208:
1209: END IF;
1210: EXCEPTION WHEN OTHERS THEN
1211: hr_utility.set_message(801, 'HR_AU_INVALID_NATIONAL_ID');
1212: hr_utility.raise_error;
1213:
1214: END VALIDATE_TFN;
1215: --

Line 1212: hr_utility.raise_error;

1208:
1209: END IF;
1210: EXCEPTION WHEN OTHERS THEN
1211: hr_utility.set_message(801, 'HR_AU_INVALID_NATIONAL_ID');
1212: hr_utility.raise_error;
1213:
1214: END VALIDATE_TFN;
1215: --
1216: --

Line 1253: hr_utility.set_location(g_package||l_procedure, 1);

1249: begin
1250: --
1251: -- get the element type id for the paye element
1252: --
1253: hr_utility.set_location(g_package||l_procedure, 1);
1254: --
1255: open csr_paye_element(p_effective_date);
1256: fetch csr_paye_element
1257: into p_element_type_id;

Line 1261: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));

1257: into p_element_type_id;
1258: if (csr_paye_element%notfound)
1259: then
1260: close csr_paye_element;
1261: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
1262: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
1263: hr_utility.raise_error;
1264: end if;
1265: close csr_paye_element;

Line 1262: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');

1258: if (csr_paye_element%notfound)
1259: then
1260: close csr_paye_element;
1261: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
1262: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
1263: hr_utility.raise_error;
1264: end if;
1265: close csr_paye_element;
1266: --

Line 1263: hr_utility.raise_error;

1259: then
1260: close csr_paye_element;
1261: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
1262: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
1263: hr_utility.raise_error;
1264: end if;
1265: close csr_paye_element;
1266: --
1267: -- get the input value id for each tax input

Line 1334: hr_utility.trace('p_element_type_id: '||to_char(p_element_type_id));

1330: then
1331: p_inp_value_id_table(15) := rec_paye_element.input_value_id; --
1332:
1333: else
1334: hr_utility.trace('p_element_type_id: '||to_char(p_element_type_id));
1335: hr_utility.trace('Input name: '||rec_paye_element.name);
1336: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
1337: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
1338: hr_utility.raise_error;

Line 1335: hr_utility.trace('Input name: '||rec_paye_element.name);

1331: p_inp_value_id_table(15) := rec_paye_element.input_value_id; --
1332:
1333: else
1334: hr_utility.trace('p_element_type_id: '||to_char(p_element_type_id));
1335: hr_utility.trace('Input name: '||rec_paye_element.name);
1336: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
1337: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
1338: hr_utility.raise_error;
1339: end if;

Line 1336: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));

1332:
1333: else
1334: hr_utility.trace('p_element_type_id: '||to_char(p_element_type_id));
1335: hr_utility.trace('Input name: '||rec_paye_element.name);
1336: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
1337: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
1338: hr_utility.raise_error;
1339: end if;
1340: end loop;

Line 1337: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');

1333: else
1334: hr_utility.trace('p_element_type_id: '||to_char(p_element_type_id));
1335: hr_utility.trace('Input name: '||rec_paye_element.name);
1336: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
1337: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
1338: hr_utility.raise_error;
1339: end if;
1340: end loop;
1341: --

Line 1338: hr_utility.raise_error;

1334: hr_utility.trace('p_element_type_id: '||to_char(p_element_type_id));
1335: hr_utility.trace('Input name: '||rec_paye_element.name);
1336: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
1337: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
1338: hr_utility.raise_error;
1339: end if;
1340: end loop;
1341: --
1342: hr_utility.set_location(g_package||l_procedure, 10);

Line 1342: hr_utility.set_location(g_package||l_procedure, 10);

1338: hr_utility.raise_error;
1339: end if;
1340: end loop;
1341: --
1342: hr_utility.set_location(g_package||l_procedure, 10);
1343: --
1344: end get_paye_input_ids;
1345: --
1346: ---------------------------------------------------------------------------------------------

Line 1364: hr_utility.set_location(g_package||l_procedure, 1);

1360: from per_business_groups
1361: where business_group_id = p_business_group_id;
1362: --
1363: begin
1364: hr_utility.set_location(g_package||l_procedure, 1);
1365: open csr_per_business_groups;
1366: fetch csr_per_business_groups
1367: into l_legislation_code;
1368: if csr_per_business_groups%notfound

Line 1371: hr_utility.set_location(g_package||l_procedure, 2);

1367: into l_legislation_code;
1368: if csr_per_business_groups%notfound
1369: then
1370: close csr_per_business_groups;
1371: hr_utility.set_location(g_package||l_procedure, 2);
1372: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
1373: return false;
1374: end if;
1375: close csr_per_business_groups;

Line 1372: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));

1368: if csr_per_business_groups%notfound
1369: then
1370: close csr_per_business_groups;
1371: hr_utility.set_location(g_package||l_procedure, 2);
1372: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
1373: return false;
1374: end if;
1375: close csr_per_business_groups;
1376: --

Line 1377: hr_utility.set_location(g_package||l_procedure, 10);

1373: return false;
1374: end if;
1375: close csr_per_business_groups;
1376: --
1377: hr_utility.set_location(g_package||l_procedure, 10);
1378: if l_legislation_code = g_legislation_code
1379: then
1380: return true;
1381: else

Line 1464: hr_utility.set_location(g_package||l_procedure, 1);

1460: --
1461: begin
1462: l_procedure := 'create_paye_tax_info'; -- Bug No: 3648796
1463:
1464: hr_utility.set_location(g_package||l_procedure, 1);
1465: --
1466: -- Ensure business group supplied is Australian
1467: --
1468: if not valid_business_group(p_business_group_id)

Line 1470: hr_utility.set_location(g_package||l_procedure, 2);

1466: -- Ensure business group supplied is Australian
1467: --
1468: if not valid_business_group(p_business_group_id)
1469: then
1470: hr_utility.set_location(g_package||l_procedure, 2);
1471: hr_utility.set_message(801,'HR_7208_API_BUS_GRP_INVALID');
1472: hr_utility.raise_error;
1473: end if;
1474: --

Line 1471: hr_utility.set_message(801,'HR_7208_API_BUS_GRP_INVALID');

1467: --
1468: if not valid_business_group(p_business_group_id)
1469: then
1470: hr_utility.set_location(g_package||l_procedure, 2);
1471: hr_utility.set_message(801,'HR_7208_API_BUS_GRP_INVALID');
1472: hr_utility.raise_error;
1473: end if;
1474: --
1475: -- Get Element type id and input value ids

Line 1472: hr_utility.raise_error;

1468: if not valid_business_group(p_business_group_id)
1469: then
1470: hr_utility.set_location(g_package||l_procedure, 2);
1471: hr_utility.set_message(801,'HR_7208_API_BUS_GRP_INVALID');
1472: hr_utility.raise_error;
1473: end if;
1474: --
1475: -- Get Element type id and input value ids
1476: --

Line 1488: hr_utility.set_message(801,'HR_AU_NZ_ELE_LNK_NOT_FND');

1484: ,p_session_date => p_effective_date
1485: );
1486: if (l_element_link_id is null or l_element_link_id = 0)
1487: then
1488: hr_utility.set_message(801,'HR_AU_NZ_ELE_LNK_NOT_FND');
1489: hr_utility.raise_error;
1490: end if;
1491: --
1492: validate_tfn(p_tax_file_number);

Line 1489: hr_utility.raise_error;

1485: );
1486: if (l_element_link_id is null or l_element_link_id = 0)
1487: then
1488: hr_utility.set_message(801,'HR_AU_NZ_ELE_LNK_NOT_FND');
1489: hr_utility.raise_error;
1490: end if;
1491: --
1492: validate_tfn(p_tax_file_number);
1493: --

Line 1585: hr_utility.set_location(g_package||l_procedure, 30);

1581: ,p_tax_file_number => p_tax_file_number
1582: ,p_update_warning => l_update_warning
1583: );
1584: --
1585: hr_utility.set_location(g_package||l_procedure, 30);
1586:
1587: end create_paye_tax_info;
1588:
1589: ---------------------------------------------------------------------------------------------

Line 1688: g_debug := hr_utility.debug_enabled;

1684: l_spouse_mls_flag varchar2(20);
1685: l_tax_variation_type varchar2(20);
1686: --
1687: begin
1688: g_debug := hr_utility.debug_enabled;
1689: if g_debug then
1690: hr_utility.set_location(l_procedure,10);
1691: hr_utility.trace('p_assignment_id => '||p_assignment_id);
1692: hr_utility.trace('p_business_group_id => '||p_business_group_id);

Line 1690: hr_utility.set_location(l_procedure,10);

1686: --
1687: begin
1688: g_debug := hr_utility.debug_enabled;
1689: if g_debug then
1690: hr_utility.set_location(l_procedure,10);
1691: hr_utility.trace('p_assignment_id => '||p_assignment_id);
1692: hr_utility.trace('p_business_group_id => '||p_business_group_id);
1693: hr_utility.trace('p_hire_date => '||p_hire_date);
1694: hr_utility.trace('p_payroll_id => '||to_char(p_payroll_id));

Line 1691: hr_utility.trace('p_assignment_id => '||p_assignment_id);

1687: begin
1688: g_debug := hr_utility.debug_enabled;
1689: if g_debug then
1690: hr_utility.set_location(l_procedure,10);
1691: hr_utility.trace('p_assignment_id => '||p_assignment_id);
1692: hr_utility.trace('p_business_group_id => '||p_business_group_id);
1693: hr_utility.trace('p_hire_date => '||p_hire_date);
1694: hr_utility.trace('p_payroll_id => '||to_char(p_payroll_id));
1695: END if;

Line 1692: hr_utility.trace('p_business_group_id => '||p_business_group_id);

1688: g_debug := hr_utility.debug_enabled;
1689: if g_debug then
1690: hr_utility.set_location(l_procedure,10);
1691: hr_utility.trace('p_assignment_id => '||p_assignment_id);
1692: hr_utility.trace('p_business_group_id => '||p_business_group_id);
1693: hr_utility.trace('p_hire_date => '||p_hire_date);
1694: hr_utility.trace('p_payroll_id => '||to_char(p_payroll_id));
1695: END if;
1696: --

Line 1693: hr_utility.trace('p_hire_date => '||p_hire_date);

1689: if g_debug then
1690: hr_utility.set_location(l_procedure,10);
1691: hr_utility.trace('p_assignment_id => '||p_assignment_id);
1692: hr_utility.trace('p_business_group_id => '||p_business_group_id);
1693: hr_utility.trace('p_hire_date => '||p_hire_date);
1694: hr_utility.trace('p_payroll_id => '||to_char(p_payroll_id));
1695: END if;
1696: --
1697: -- Need the object_version_number to update the assignment

Line 1694: hr_utility.trace('p_payroll_id => '||to_char(p_payroll_id));

1690: hr_utility.set_location(l_procedure,10);
1691: hr_utility.trace('p_assignment_id => '||p_assignment_id);
1692: hr_utility.trace('p_business_group_id => '||p_business_group_id);
1693: hr_utility.trace('p_hire_date => '||p_hire_date);
1694: hr_utility.trace('p_payroll_id => '||to_char(p_payroll_id));
1695: END if;
1696: --
1697: -- Need the object_version_number to update the assignment
1698: --

Line 1728: hr_utility.set_location(l_procedure,20);

1724: ,p_no_managers_warning => l_no_managers_warning -- out parameter
1725: ,p_other_manager_warning => l_other_manager_warning -- out parameter
1726: );
1727: IF g_debug THEN
1728: hr_utility.set_location(l_procedure,20);
1729: hr_utility.trace('l_object_version_number => '||l_object_version_number);
1730: END if;
1731:
1732: --

Line 1729: hr_utility.trace('l_object_version_number => '||l_object_version_number);

1725: ,p_other_manager_warning => l_other_manager_warning -- out parameter
1726: );
1727: IF g_debug THEN
1728: hr_utility.set_location(l_procedure,20);
1729: hr_utility.trace('l_object_version_number => '||l_object_version_number);
1730: END if;
1731:
1732: --
1733: -- The intended use of the following API call is to allow the update of

Line 1760: hr_utility.set_location(l_procedure,30);

1756: ,p_concatenated_segments => l_concatenated_segments
1757: );
1758:
1759: IF g_debug THEN
1760: hr_utility.set_location(l_procedure,30);
1761: hr_utility.trace('p_australian_resident_flag => '||p_australian_resident);
1762: hr_utility.trace('p_senior_australian => '||p_senior_australian);
1763: hr_utility.trace('p_payroll_id => '||to_char(p_payroll_id));
1764:

Line 1761: hr_utility.trace('p_australian_resident_flag => '||p_australian_resident);

1757: );
1758:
1759: IF g_debug THEN
1760: hr_utility.set_location(l_procedure,30);
1761: hr_utility.trace('p_australian_resident_flag => '||p_australian_resident);
1762: hr_utility.trace('p_senior_australian => '||p_senior_australian);
1763: hr_utility.trace('p_payroll_id => '||to_char(p_payroll_id));
1764:
1765: END if;

Line 1762: hr_utility.trace('p_senior_australian => '||p_senior_australian);

1758:
1759: IF g_debug THEN
1760: hr_utility.set_location(l_procedure,30);
1761: hr_utility.trace('p_australian_resident_flag => '||p_australian_resident);
1762: hr_utility.trace('p_senior_australian => '||p_senior_australian);
1763: hr_utility.trace('p_payroll_id => '||to_char(p_payroll_id));
1764:
1765: END if;
1766:

Line 1763: hr_utility.trace('p_payroll_id => '||to_char(p_payroll_id));

1759: IF g_debug THEN
1760: hr_utility.set_location(l_procedure,30);
1761: hr_utility.trace('p_australian_resident_flag => '||p_australian_resident);
1762: hr_utility.trace('p_senior_australian => '||p_senior_australian);
1763: hr_utility.trace('p_payroll_id => '||to_char(p_payroll_id));
1764:
1765: END if;
1766:
1767: --

Line 1789: hr_utility.set_location(l_procedure,31);

1785: else
1786: l_australian_resident_flag := p_australian_resident || p_senior_australian;
1787: end if;
1788: if g_debug then
1789: hr_utility.set_location(l_procedure,31);
1790: end if;
1791:
1792: -- ---------------------------------------
1793: -- PAYMENT BASIS and FTB CLAIM

Line 1801: hr_utility.set_location(l_procedure,32);

1797: --l_fta_claim_flag values N,NC,NF,NP,Y,YC,YF,YP
1798: --
1799: l_fta_claim_flag := p_ftb_claim || p_basis_of_payment;
1800: if g_debug then
1801: hr_utility.set_location(l_procedure,32);
1802: end if;
1803:
1804: -- ---------------------------------------
1805: -- HECS and SFSS

Line 1818: hr_utility.set_location(l_procedure,33);

1814: l_hecs_sfss_flag := p_hecs || p_sfss;
1815: end if;
1816: --
1817: if g_debug then
1818: hr_utility.set_location(l_procedure,33);
1819: end if;
1820:
1821: -- ---------------------------------------
1822: -- SPOUSE and MLS

Line 1848: hr_utility.set_location(l_procedure,40);

1844: l_tax_variation_type := p_tax_variation_type || p_tax_variation_bonus;
1845: end if;
1846:
1847: if g_debug then
1848: hr_utility.set_location(l_procedure,40);
1849: hr_utility.trace('l_australian_resident_flag => '||l_australian_resident_flag);
1850: hr_utility.trace('l_fta_claim_flag => '||l_fta_claim_flag);
1851: hr_utility.trace('l_hecs_sfss_flag => '||l_hecs_sfss_flag);
1852: hr_utility.trace('l_spouse_mls_flag => '||l_spouse_mls_flag);

Line 1849: hr_utility.trace('l_australian_resident_flag => '||l_australian_resident_flag);

1845: end if;
1846:
1847: if g_debug then
1848: hr_utility.set_location(l_procedure,40);
1849: hr_utility.trace('l_australian_resident_flag => '||l_australian_resident_flag);
1850: hr_utility.trace('l_fta_claim_flag => '||l_fta_claim_flag);
1851: hr_utility.trace('l_hecs_sfss_flag => '||l_hecs_sfss_flag);
1852: hr_utility.trace('l_spouse_mls_flag => '||l_spouse_mls_flag);
1853: hr_utility.trace('l_tax_variation_type => '||l_tax_variation_type);

Line 1850: hr_utility.trace('l_fta_claim_flag => '||l_fta_claim_flag);

1846:
1847: if g_debug then
1848: hr_utility.set_location(l_procedure,40);
1849: hr_utility.trace('l_australian_resident_flag => '||l_australian_resident_flag);
1850: hr_utility.trace('l_fta_claim_flag => '||l_fta_claim_flag);
1851: hr_utility.trace('l_hecs_sfss_flag => '||l_hecs_sfss_flag);
1852: hr_utility.trace('l_spouse_mls_flag => '||l_spouse_mls_flag);
1853: hr_utility.trace('l_tax_variation_type => '||l_tax_variation_type);
1854: end if;

Line 1851: hr_utility.trace('l_hecs_sfss_flag => '||l_hecs_sfss_flag);

1847: if g_debug then
1848: hr_utility.set_location(l_procedure,40);
1849: hr_utility.trace('l_australian_resident_flag => '||l_australian_resident_flag);
1850: hr_utility.trace('l_fta_claim_flag => '||l_fta_claim_flag);
1851: hr_utility.trace('l_hecs_sfss_flag => '||l_hecs_sfss_flag);
1852: hr_utility.trace('l_spouse_mls_flag => '||l_spouse_mls_flag);
1853: hr_utility.trace('l_tax_variation_type => '||l_tax_variation_type);
1854: end if;
1855:

Line 1852: hr_utility.trace('l_spouse_mls_flag => '||l_spouse_mls_flag);

1848: hr_utility.set_location(l_procedure,40);
1849: hr_utility.trace('l_australian_resident_flag => '||l_australian_resident_flag);
1850: hr_utility.trace('l_fta_claim_flag => '||l_fta_claim_flag);
1851: hr_utility.trace('l_hecs_sfss_flag => '||l_hecs_sfss_flag);
1852: hr_utility.trace('l_spouse_mls_flag => '||l_spouse_mls_flag);
1853: hr_utility.trace('l_tax_variation_type => '||l_tax_variation_type);
1854: end if;
1855:
1856: -- If the Tax Information already exists for this assignment then

Line 1853: hr_utility.trace('l_tax_variation_type => '||l_tax_variation_type);

1849: hr_utility.trace('l_australian_resident_flag => '||l_australian_resident_flag);
1850: hr_utility.trace('l_fta_claim_flag => '||l_fta_claim_flag);
1851: hr_utility.trace('l_hecs_sfss_flag => '||l_hecs_sfss_flag);
1852: hr_utility.trace('l_spouse_mls_flag => '||l_spouse_mls_flag);
1853: hr_utility.trace('l_tax_variation_type => '||l_tax_variation_type);
1854: end if;
1855:
1856: -- If the Tax Information already exists for this assignment then
1857: -- call maintain_paye_tax_info... otherwise call call create_paye_tax_info.

Line 1870: hr_utility.set_location(l_procedure, 50);

1866: if (csr_tax_element%notfound)
1867: then
1868: close csr_tax_element;
1869: IF g_debug THEN
1870: hr_utility.set_location(l_procedure, 50);
1871: hr_utility.trace('p_effective_date: '||to_char(p_hire_date,'MM/DD/YYYY'));
1872: END if;
1873: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
1874: hr_utility.raise_error;

Line 1871: hr_utility.trace('p_effective_date: '||to_char(p_hire_date,'MM/DD/YYYY'));

1867: then
1868: close csr_tax_element;
1869: IF g_debug THEN
1870: hr_utility.set_location(l_procedure, 50);
1871: hr_utility.trace('p_effective_date: '||to_char(p_hire_date,'MM/DD/YYYY'));
1872: END if;
1873: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
1874: hr_utility.raise_error;
1875: end if;

Line 1873: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');

1869: IF g_debug THEN
1870: hr_utility.set_location(l_procedure, 50);
1871: hr_utility.trace('p_effective_date: '||to_char(p_hire_date,'MM/DD/YYYY'));
1872: END if;
1873: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
1874: hr_utility.raise_error;
1875: end if;
1876: close csr_tax_element;
1877:

Line 1874: hr_utility.raise_error;

1870: hr_utility.set_location(l_procedure, 50);
1871: hr_utility.trace('p_effective_date: '||to_char(p_hire_date,'MM/DD/YYYY'));
1872: END if;
1873: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
1874: hr_utility.raise_error;
1875: end if;
1876: close csr_tax_element;
1877:
1878: if g_debug then

Line 1879: hr_utility.set_location(l_procedure,60);

1875: end if;
1876: close csr_tax_element;
1877:
1878: if g_debug then
1879: hr_utility.set_location(l_procedure,60);
1880: hr_utility.trace('p_assignment_id => '||p_assignment_id);
1881: hr_utility.trace('l_element_type_id => '||l_element_type_id);
1882: end if;
1883: --

Line 1880: hr_utility.trace('p_assignment_id => '||p_assignment_id);

1876: close csr_tax_element;
1877:
1878: if g_debug then
1879: hr_utility.set_location(l_procedure,60);
1880: hr_utility.trace('p_assignment_id => '||p_assignment_id);
1881: hr_utility.trace('l_element_type_id => '||l_element_type_id);
1882: end if;
1883: --
1884: -- Got the element_type_id so can now get the element_link_id

Line 1881: hr_utility.trace('l_element_type_id => '||l_element_type_id);

1877:
1878: if g_debug then
1879: hr_utility.set_location(l_procedure,60);
1880: hr_utility.trace('p_assignment_id => '||p_assignment_id);
1881: hr_utility.trace('l_element_type_id => '||l_element_type_id);
1882: end if;
1883: --
1884: -- Got the element_type_id so can now get the element_link_id
1885: l_element_link_id := hr_entry_api.get_link

Line 1893: hr_utility.set_location(l_procedure, 61);

1889: );
1890: if (l_element_link_id is null or l_element_link_id = 0)
1891: then
1892: if g_debug then
1893: hr_utility.set_location(l_procedure, 61);
1894: end if;
1895: --
1896: -- It is possible that the current assignment is on a payroll for which an element link does
1897: -- not exist, therefore we need to check the link before we create.

Line 1924: --hr_utility.set_message(801,'HR_AU_NZ_ELE_LNK_NOT_FND');

1920: ,P_EFFECTIVE_END_DATE => l_effective_end_date
1921: );
1922:
1923: end if;
1924: --hr_utility.set_message(801,'HR_AU_NZ_ELE_LNK_NOT_FND');
1925: --hr_utility.raise_error;
1926: end if;
1927: --
1928: if g_debug then

Line 1925: --hr_utility.raise_error;

1921: );
1922:
1923: end if;
1924: --hr_utility.set_message(801,'HR_AU_NZ_ELE_LNK_NOT_FND');
1925: --hr_utility.raise_error;
1926: end if;
1927: --
1928: if g_debug then
1929: hr_utility.set_location(l_procedure, 62);

Line 1929: hr_utility.set_location(l_procedure, 62);

1925: --hr_utility.raise_error;
1926: end if;
1927: --
1928: if g_debug then
1929: hr_utility.set_location(l_procedure, 62);
1930: hr_utility.trace('l_element_link_id = '||to_char(l_element_link_id));
1931: end if;
1932: --
1933: -- Verify whether an element entry exists.

Line 1930: hr_utility.trace('l_element_link_id = '||to_char(l_element_link_id));

1926: end if;
1927: --
1928: if g_debug then
1929: hr_utility.set_location(l_procedure, 62);
1930: hr_utility.trace('l_element_link_id = '||to_char(l_element_link_id));
1931: end if;
1932: --
1933: -- Verify whether an element entry exists.
1934: -- (This is where to use the element_link_id)

Line 1940: hr_utility.set_location(l_procedure,70);

1936: open csr_element_entry(l_element_link_id);
1937: fetch csr_element_entry into l_element_entry_id;
1938: if csr_element_entry%notfound then
1939: if g_debug then
1940: hr_utility.set_location(l_procedure,70);
1941: end if;
1942: --
1943: -- The element entry does not exist so call the CREATE API
1944: --

Line 1973: hr_utility.set_location(l_procedure,80);

1969: ,p_create_warning => l_create_warning
1970: );
1971: else
1972: if g_debug then
1973: hr_utility.set_location(l_procedure,80);
1974: hr_utility.trace('dep children = '||p_medicare_levy_dep_children);
1975:
1976: end if;
1977: --

Line 1974: hr_utility.trace('dep children = '||p_medicare_levy_dep_children);

1970: );
1971: else
1972: if g_debug then
1973: hr_utility.set_location(l_procedure,80);
1974: hr_utility.trace('dep children = '||p_medicare_levy_dep_children);
1975:
1976: end if;
1977: --
1978: -- The element entry exists so call the UPDATE API

Line 2009: hr_utility.set_location(l_procedure,90);

2005: );
2006: end if;
2007: --
2008: if g_debug then
2009: hr_utility.set_location(l_procedure,90);
2010: end if;
2011: end update_adi_tax_crp;
2012:
2013: END hr_au_tax_api ;