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_BATCH_ELEMENT_ENTRY_API dependencies on HR_UTILITY

Line 220: hr_utility.set_location('Entering:'|| l_proc, 10);

216: l_proc varchar2(72) := g_package||'convert_date_to_canonical';
217: --
218: begin
219: --
220: hr_utility.set_location('Entering:'|| l_proc, 10);
221:
222: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_date_prof_value);
223: l_date_prof_value := nvl(l_date_prof_value,'DD-MON-RRRR');
224: --

Line 728: hr_utility.set_location('Leaving:'|| l_proc, 20);

724: end loop;
725: --
726: close csr_table_inp_ids;
727: --
728: hr_utility.set_location('Leaving:'|| l_proc, 20);
729: --
730: exception
731: when others then
732: --fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 775: hr_utility.set_location('Entering:'|| l_proc, 10);

771: l_object_version_number pay_batch_headers.object_version_number%TYPE;
772: l_session_date date;
773: --
774: begin
775: hr_utility.set_location('Entering:'|| l_proc, 10);
776: --
777: -- Issue a savepoint
778: --
779: savepoint create_batch_header;

Line 830: hr_utility.set_message(801, 'PAY_500013_BEE_DUPL_HEADER');

826: from pay_batch_headers
827: where upper(batch_name) = upper(p_batch_name)
828: and business_group_id = p_business_group_id);
829:
830: hr_utility.set_message(801, 'PAY_500013_BEE_DUPL_HEADER');
831: hr_utility.raise_error;
832:
833: exception
834: when no_data_found then

Line 831: hr_utility.raise_error;

827: where upper(batch_name) = upper(p_batch_name)
828: and business_group_id = p_business_group_id);
829:
830: hr_utility.set_message(801, 'PAY_500013_BEE_DUPL_HEADER');
831: hr_utility.raise_error;
832:
833: exception
834: when no_data_found then
835: null;

Line 905: hr_utility.set_location(' Leaving:'||l_proc, 70);

901: --
902: p_batch_id := l_batch_id;
903: p_object_version_number := l_object_version_number;
904: --
905: hr_utility.set_location(' Leaving:'||l_proc, 70);
906: exception
907: when hr_api.validate_enabled then
908: --
909: -- As the Validate_Enabled exception has been raised

Line 920: hr_utility.set_location(' Leaving:'||l_proc, 80);

916: -- when validation only mode is being used.)
917: --
918: p_batch_id := null;
919: p_object_version_number := null;
920: hr_utility.set_location(' Leaving:'||l_proc, 80);
921: when others then
922: --
923: -- A validation or unexpected error has occured
924: --

Line 928: hr_utility.set_location(' Leaving:'||l_proc, 90);

924: --
925: rollback to create_batch_header;
926: p_batch_id := null;
927: p_object_version_number := null;
928: hr_utility.set_location(' Leaving:'||l_proc, 90);
929: raise;
930: end create_batch_header;
931: --
932: --

Line 1099: hr_utility.set_location('Entering:'|| l_proc, 10);

1095: --
1096: LR_CHECK_FND_SESSION CSR_CHECK_FND_SESSION%ROWTYPE;
1097: --
1098: begin
1099: hr_utility.set_location('Entering:'|| l_proc, 10);
1100: --
1101: -- Issue a savepoint
1102: --
1103: savepoint create_batch_line;

Line 1136: hr_utility.set_message(800, 'HR_449106_BEE_UPGRADING');

1132: --
1133: -- Check whether the upgrade process is in progress.
1134: --
1135: if l_bee_iv_upgrade = 'E' then
1136: hr_utility.set_message(800, 'HR_449106_BEE_UPGRADING');
1137: hr_utility.raise_error;
1138: end if;
1139: --
1140: if p_iv_all_internal_format = 'Y' and l_bee_iv_upgrade = 'N' then

Line 1137: hr_utility.raise_error;

1133: -- Check whether the upgrade process is in progress.
1134: --
1135: if l_bee_iv_upgrade = 'E' then
1136: hr_utility.set_message(800, 'HR_449106_BEE_UPGRADING');
1137: hr_utility.raise_error;
1138: end if;
1139: --
1140: if p_iv_all_internal_format = 'Y' and l_bee_iv_upgrade = 'N' then
1141: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

Line 1572: hr_utility.set_location(' Leaving:'||l_proc, 70);

1568: --
1569: p_batch_line_id := l_batch_line_id;
1570: p_object_version_number := l_object_version_number;
1571: --
1572: hr_utility.set_location(' Leaving:'||l_proc, 70);
1573: exception
1574: when hr_api.validate_enabled then
1575: --
1576: -- As the Validate_Enabled exception has been raised

Line 1587: hr_utility.set_location(' Leaving:'||l_proc, 80);

1583: -- when validation only mode is being used.)
1584: --
1585: p_batch_line_id := null;
1586: p_object_version_number := null;
1587: hr_utility.set_location(' Leaving:'||l_proc, 80);
1588: when others then
1589: --
1590: -- A validation or unexpected error has occured
1591: --

Line 1595: hr_utility.set_location(' Leaving:'||l_proc, 90);

1591: --
1592: rollback to create_batch_line;
1593: p_batch_line_id := null;
1594: p_object_version_number := null;
1595: hr_utility.set_location(' Leaving:'||l_proc, 90);
1596: raise;
1597: end create_batch_line;
1598: --
1599: --

Line 1651: hr_utility.set_location('Entering:'|| l_proc, 10);

1647: --
1648: /* Changes for Bug 10373368 ends here */
1649: --
1650: begin
1651: hr_utility.set_location('Entering:'|| l_proc, 10);
1652: --
1653: -- Issue a savepoint
1654: --
1655: savepoint create_batch_total;

Line 1683: hr_utility.set_location(l_proc, 20);

1679: /* Changes for Bug 10373368 starts here.
1680: These changes are done to make sure control total is rounded depending
1681: on unit of measure of the element for which control total is created */
1682: v_control_total := p_control_total;
1683: hr_utility.set_location(l_proc, 20);
1684: begin
1685: open batch_total_validate(p_batch_id, p_control_type,p_control_column_name);
1686: fetch batch_total_validate into l_input_curr_code, l_uom;
1687: close batch_total_validate;

Line 1699: hr_utility.set_location(l_proc||', status: '||lv_rgrflg, 30);

1695: 'Y',
1696: lv_rgrflg,
1697: l_input_curr_code
1698: );
1699: hr_utility.set_location(l_proc||', status: '||lv_rgrflg, 30);
1700: end if;
1701: exception
1702: when others then
1703: v_control_total := p_control_total;

Line 1704: hr_utility.set_location(l_proc, 40);

1700: end if;
1701: exception
1702: when others then
1703: v_control_total := p_control_total;
1704: hr_utility.set_location(l_proc, 40);
1705: end;
1706: hr_utility.set_location(l_proc, 50);
1707: /*Changes for Bug 10373368 ends here */
1708: --

Line 1706: hr_utility.set_location(l_proc, 50);

1702: when others then
1703: v_control_total := p_control_total;
1704: hr_utility.set_location(l_proc, 40);
1705: end;
1706: hr_utility.set_location(l_proc, 50);
1707: /*Changes for Bug 10373368 ends here */
1708: --
1709: -- Validation in addition to Row Handlers
1710: --

Line 1754: hr_utility.set_location(' Leaving:'||l_proc, 70);

1750: --
1751: p_batch_control_id := l_batch_control_id;
1752: p_object_version_number := l_object_version_number;
1753: --
1754: hr_utility.set_location(' Leaving:'||l_proc, 70);
1755: exception
1756: when hr_api.validate_enabled then
1757: --
1758: -- As the Validate_Enabled exception has been raised

Line 1769: hr_utility.set_location(' Leaving:'||l_proc, 80);

1765: -- when validation only mode is being used.)
1766: --
1767: p_batch_control_id := null;
1768: p_object_version_number := null;
1769: hr_utility.set_location(' Leaving:'||l_proc, 80);
1770: when others then
1771: --
1772: -- A validation or unexpected error has occured
1773: --

Line 1777: hr_utility.set_location(' Leaving:'||l_proc, 90);

1773: --
1774: rollback to create_batch_total;
1775: p_batch_control_id := null;
1776: p_object_version_number := null;
1777: hr_utility.set_location(' Leaving:'||l_proc, 90);
1778: raise;
1779: end create_batch_total;
1780: --
1781: --

Line 1814: hr_utility.set_location('Entering:'|| l_proc, 10);

1810: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1811: l_session_date date;
1812: --
1813: begin
1814: hr_utility.set_location('Entering:'|| l_proc, 10);
1815: --
1816: -- Issue a savepoint
1817: --
1818: savepoint update_batch_header;

Line 1922: hr_utility.set_location(' Leaving:'||l_proc, 70);

1918: -- Set all output arguments
1919: --
1920: p_object_version_number := l_object_version_number;
1921: --
1922: hr_utility.set_location(' Leaving:'||l_proc, 70);
1923: exception
1924: when hr_api.validate_enabled then
1925: --
1926: -- As the Validate_Enabled exception has been raised

Line 1935: hr_utility.set_location(' Leaving:'||l_proc, 80);

1931: -- Only set output warning arguments
1932: -- (Any key or derived arguments must be set to null
1933: -- when validation only mode is being used.)
1934: --
1935: hr_utility.set_location(' Leaving:'||l_proc, 80);
1936: when others then
1937: --
1938: -- A validation or unexpected error has occured
1939: --

Line 1942: hr_utility.set_location(' Leaving:'||l_proc, 90);

1938: -- A validation or unexpected error has occured
1939: --
1940: rollback to update_batch_header;
1941: p_object_version_number := l_object_version_number;
1942: hr_utility.set_location(' Leaving:'||l_proc, 90);
1943: raise;
1944: end update_batch_header;
1945: --
1946: --

Line 2102: hr_utility.set_location('Entering:'|| l_proc, 10);

2098: --
2099: l_bee_iv_upgrade varchar2(1);
2100: --
2101: begin
2102: hr_utility.set_location('Entering:'|| l_proc, 10);
2103: --
2104: -- Issue a savepoint
2105: --
2106: savepoint update_batch_line;

Line 2125: hr_utility.set_message(800, 'HR_449106_BEE_UPGRADING');

2121: --
2122: -- Check whether the upgrade process is in progress.
2123: --
2124: if l_bee_iv_upgrade = 'E' then
2125: hr_utility.set_message(800, 'HR_449106_BEE_UPGRADING');
2126: hr_utility.raise_error;
2127: end if;
2128: --
2129: if p_iv_all_internal_format = 'Y' and l_bee_iv_upgrade = 'N' then

Line 2126: hr_utility.raise_error;

2122: -- Check whether the upgrade process is in progress.
2123: --
2124: if l_bee_iv_upgrade = 'E' then
2125: hr_utility.set_message(800, 'HR_449106_BEE_UPGRADING');
2126: hr_utility.raise_error;
2127: end if;
2128: --
2129: if p_iv_all_internal_format = 'Y' and l_bee_iv_upgrade = 'N' then
2130: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

Line 2297: hr_utility.set_location(l_proc, 11);

2293: ,p_hook_type => 'BP'
2294: );
2295: end;
2296: --
2297: hr_utility.set_location(l_proc, 11);
2298: --
2299: -- Validation in addition to Row Handlers
2300: --
2301: --

Line 2422: hr_utility.set_location(l_proc, 12);

2418: ,p_subpriority => p_subpriority
2419: ,p_effective_start_date => l_effective_start_date
2420: ,p_effective_end_date => l_effective_end_date);
2421: --
2422: hr_utility.set_location(l_proc, 12);
2423: --
2424: --
2425: -- Call After Process User Hook
2426: --

Line 2564: hr_utility.set_location(' Leaving:'||l_proc, 70);

2560: -- Set all output arguments
2561: --
2562: p_object_version_number := l_object_version_number;
2563: --
2564: hr_utility.set_location(' Leaving:'||l_proc, 70);
2565: exception
2566: when hr_api.validate_enabled then
2567: --
2568: -- As the Validate_Enabled exception has been raised

Line 2577: hr_utility.set_location(' Leaving:'||l_proc, 80);

2573: -- Only set output warning arguments
2574: -- (Any key or derived arguments must be set to null
2575: -- when validation only mode is being used.)
2576: --
2577: hr_utility.set_location(' Leaving:'||l_proc, 80);
2578: when others then
2579: --
2580: -- A validation or unexpected error has occured
2581: --

Line 2584: hr_utility.set_location(' Leaving:'||l_proc, 90);

2580: -- A validation or unexpected error has occured
2581: --
2582: rollback to update_batch_line;
2583: p_object_version_number := l_object_version_number;
2584: hr_utility.set_location(' Leaving:'||l_proc, 90);
2585: raise;
2586: end update_batch_line;
2587: --
2588: --

Line 2610: hr_utility.set_location('Entering:'|| l_proc, 10);

2606: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;
2607: l_session_date date;
2608: --
2609: begin
2610: hr_utility.set_location('Entering:'|| l_proc, 10);
2611: --
2612: -- Issue a savepoint
2613: --
2614: savepoint update_batch_total;

Line 2685: hr_utility.set_location(' Leaving:'||l_proc, 70);

2681: -- Set all output arguments
2682: --
2683: p_object_version_number := l_object_version_number;
2684: --
2685: hr_utility.set_location(' Leaving:'||l_proc, 70);
2686: exception
2687: when hr_api.validate_enabled then
2688: --
2689: -- As the Validate_Enabled exception has been raised

Line 2698: hr_utility.set_location(' Leaving:'||l_proc, 80);

2694: -- Only set output warning arguments
2695: -- (Any key or derived arguments must be set to null
2696: -- when validation only mode is being used.)
2697: --
2698: hr_utility.set_location(' Leaving:'||l_proc, 80);
2699: when others then
2700: --
2701: -- A validation or unexpected error has occured
2702: --

Line 2705: hr_utility.set_location(' Leaving:'||l_proc, 90);

2701: -- A validation or unexpected error has occured
2702: --
2703: rollback to update_batch_total;
2704: p_object_version_number := l_object_version_number;
2705: hr_utility.set_location(' Leaving:'||l_proc, 90);
2706: raise;
2707: end update_batch_total;
2708: --
2709: --

Line 2735: hr_utility.set_location('Entering:'|| l_proc, 5);

2731: from pay_batch_control_totals bct
2732: where bct.batch_id = p_batch_id;
2733: --
2734: begin
2735: hr_utility.set_location('Entering:'|| l_proc, 5);
2736: --
2737: -- Issue a savepoint if operating in validation only mode.
2738: --
2739: savepoint delete_batch_header;

Line 2757: hr_utility.set_location(l_proc, 7);

2753: );
2754: end;
2755: --
2756: --
2757: hr_utility.set_location(l_proc, 7);
2758: --
2759: -- Process Logic
2760: --
2761: --

Line 2778: hr_utility.set_location(l_proc, 10);

2774: ,p_object_version_number => cssr.object_version_number
2775: );
2776: end loop;
2777: --
2778: hr_utility.set_location(l_proc, 10);
2779: --
2780: -- Deletes all batch control totals
2781: --
2782: for cssr in csr_batch_ctl_totals loop

Line 2796: hr_utility.set_location(l_proc, 15);

2792: ,p_object_version_number => cssr.object_version_number
2793: );
2794: end loop;
2795: --
2796: hr_utility.set_location(l_proc, 15);
2797: --
2798: -- Deletes all messages
2799: --
2800: delete from pay_message_lines

Line 2811: hr_utility.set_location(l_proc, 20);

2807: (p_batch_id => p_batch_id
2808: ,p_object_version_number => p_object_version_number
2809: );
2810: --
2811: hr_utility.set_location(l_proc, 20);
2812: --
2813: --
2814: -- Call After Process User Hook
2815: --

Line 2835: hr_utility.set_location(' Leaving:'||l_proc, 21);

2831: if p_validate then
2832: raise hr_api.validate_enabled;
2833: end if;
2834: --
2835: hr_utility.set_location(' Leaving:'||l_proc, 21);
2836: exception
2837: when hr_api.validate_enabled then
2838: --
2839: -- As the Validate_Enabled exception has been raised

Line 2844: hr_utility.set_location(' Leaving:'||l_proc, 22);

2840: -- we must rollback to the savepoint
2841: --
2842: ROLLBACK TO delete_batch_header;
2843: --
2844: hr_utility.set_location(' Leaving:'||l_proc, 22);
2845: --
2846: when others then
2847: --
2848: --

Line 2871: hr_utility.set_location('Entering:'|| l_proc, 5);

2867: --
2868: l_proc varchar2(72) := g_package||'delete_batch_line';
2869: --
2870: begin
2871: hr_utility.set_location('Entering:'|| l_proc, 5);
2872: --
2873: -- Issue a savepoint if operating in validation only mode.
2874: --
2875: savepoint delete_batch_line;

Line 2893: hr_utility.set_location(l_proc, 7);

2889: );
2890: end;
2891: --
2892: --
2893: hr_utility.set_location(l_proc, 7);
2894: --
2895: -- Process Logic
2896: --
2897: --

Line 2911: hr_utility.set_location(l_proc, 20);

2907: (p_batch_line_id => p_batch_line_id
2908: ,p_object_version_number => p_object_version_number
2909: );
2910: --
2911: hr_utility.set_location(l_proc, 20);
2912: --
2913: --
2914: -- Call After Process User Hook
2915: --

Line 2935: hr_utility.set_location(' Leaving:'||l_proc, 21);

2931: if p_validate then
2932: raise hr_api.validate_enabled;
2933: end if;
2934: --
2935: hr_utility.set_location(' Leaving:'||l_proc, 21);
2936: exception
2937: when hr_api.validate_enabled then
2938: --
2939: -- As the Validate_Enabled exception has been raised

Line 2944: hr_utility.set_location(' Leaving:'||l_proc, 22);

2940: -- we must rollback to the savepoint
2941: --
2942: ROLLBACK TO delete_batch_line;
2943: --
2944: hr_utility.set_location(' Leaving:'||l_proc, 22);
2945: --
2946: when others then
2947: --
2948: --

Line 2971: hr_utility.set_location('Entering:'|| l_proc, 5);

2967: --
2968: l_proc varchar2(72) := g_package||'delete_batch_total';
2969: --
2970: begin
2971: hr_utility.set_location('Entering:'|| l_proc, 5);
2972: --
2973: -- Issue a savepoint if operating in validation only mode.
2974: --
2975: savepoint delete_batch_total;

Line 2993: hr_utility.set_location(l_proc, 7);

2989: );
2990: end;
2991: --
2992: --
2993: hr_utility.set_location(l_proc, 7);
2994: --
2995: -- Process Logic
2996: --
2997: --

Line 3011: hr_utility.set_location(l_proc, 20);

3007: (p_batch_control_id => p_batch_control_id
3008: ,p_object_version_number => p_object_version_number
3009: );
3010: --
3011: hr_utility.set_location(l_proc, 20);
3012: --
3013: --
3014: -- Call After Process User Hook
3015: --

Line 3035: hr_utility.set_location(' Leaving:'||l_proc, 21);

3031: if p_validate then
3032: raise hr_api.validate_enabled;
3033: end if;
3034: --
3035: hr_utility.set_location(' Leaving:'||l_proc, 21);
3036: exception
3037: when hr_api.validate_enabled then
3038: --
3039: -- As the Validate_Enabled exception has been raised

Line 3044: hr_utility.set_location(' Leaving:'||l_proc, 22);

3040: -- we must rollback to the savepoint
3041: --
3042: ROLLBACK TO delete_batch_total;
3043: --
3044: hr_utility.set_location(' Leaving:'||l_proc, 22);
3045: --
3046: when others then
3047: --
3048: --