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 198: hr_utility.set_location('Entering:'|| l_proc, 10);

194: l_proc varchar2(72) := g_package||'convert_date_to_canonical';
195: --
196: begin
197: --
198: hr_utility.set_location('Entering:'|| l_proc, 10);
199: --
200: if p_effective_date = hr_api.g_date then
201: select effective_date
202: into l_effective_date

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

403: end loop;
404: --
405: close csr_table_inp_ids;
406: --
407: hr_utility.set_location('Leaving:'|| l_proc, 20);
408: --
409: exception
410: when others then
411: --fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

450: l_object_version_number pay_batch_headers.object_version_number%TYPE;
451: l_session_date date;
452: --
453: begin
454: hr_utility.set_location('Entering:'|| l_proc, 10);
455: --
456: -- Issue a savepoint
457: --
458: savepoint create_batch_header;

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

556: --
557: p_batch_id := l_batch_id;
558: p_object_version_number := l_object_version_number;
559: --
560: hr_utility.set_location(' Leaving:'||l_proc, 70);
561: exception
562: when hr_api.validate_enabled then
563: --
564: -- As the Validate_Enabled exception has been raised

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

571: -- when validation only mode is being used.)
572: --
573: p_batch_id := null;
574: p_object_version_number := null;
575: hr_utility.set_location(' Leaving:'||l_proc, 80);
576: when others then
577: --
578: -- A validation or unexpected error has occured
579: --

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

579: --
580: rollback to create_batch_header;
581: p_batch_id := null;
582: p_object_version_number := null;
583: hr_utility.set_location(' Leaving:'||l_proc, 90);
584: raise;
585: end create_batch_header;
586: --
587: --

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

741: --
742: l_bee_iv_upgrade varchar2(1);
743: --
744: begin
745: hr_utility.set_location('Entering:'|| l_proc, 10);
746: --
747: -- Issue a savepoint
748: --
749: savepoint create_batch_line;

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

760: --
761: -- Check whether the upgrade process is in progress.
762: --
763: if l_bee_iv_upgrade = 'E' then
764: hr_utility.set_message(800, 'HR_449106_BEE_UPGRADING');
765: hr_utility.raise_error;
766: end if;
767: --
768: if p_iv_all_internal_format = 'Y' and l_bee_iv_upgrade = 'N' then

Line 765: hr_utility.raise_error;

761: -- Check whether the upgrade process is in progress.
762: --
763: if l_bee_iv_upgrade = 'E' then
764: hr_utility.set_message(800, 'HR_449106_BEE_UPGRADING');
765: hr_utility.raise_error;
766: end if;
767: --
768: if p_iv_all_internal_format = 'Y' and l_bee_iv_upgrade = 'N' then
769: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

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

1196: --
1197: p_batch_line_id := l_batch_line_id;
1198: p_object_version_number := l_object_version_number;
1199: --
1200: hr_utility.set_location(' Leaving:'||l_proc, 70);
1201: exception
1202: when hr_api.validate_enabled then
1203: --
1204: -- As the Validate_Enabled exception has been raised

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

1211: -- when validation only mode is being used.)
1212: --
1213: p_batch_line_id := null;
1214: p_object_version_number := null;
1215: hr_utility.set_location(' Leaving:'||l_proc, 80);
1216: when others then
1217: --
1218: -- A validation or unexpected error has occured
1219: --

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

1219: --
1220: rollback to create_batch_line;
1221: p_batch_line_id := null;
1222: p_object_version_number := null;
1223: hr_utility.set_location(' Leaving:'||l_proc, 90);
1224: raise;
1225: end create_batch_line;
1226: --
1227: --

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

1247: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;
1248: l_session_date date;
1249: --
1250: begin
1251: hr_utility.set_location('Entering:'|| l_proc, 10);
1252: --
1253: -- Issue a savepoint
1254: --
1255: savepoint create_batch_total;

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

1320: --
1321: p_batch_control_id := l_batch_control_id;
1322: p_object_version_number := l_object_version_number;
1323: --
1324: hr_utility.set_location(' Leaving:'||l_proc, 70);
1325: exception
1326: when hr_api.validate_enabled then
1327: --
1328: -- As the Validate_Enabled exception has been raised

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

1335: -- when validation only mode is being used.)
1336: --
1337: p_batch_control_id := null;
1338: p_object_version_number := null;
1339: hr_utility.set_location(' Leaving:'||l_proc, 80);
1340: when others then
1341: --
1342: -- A validation or unexpected error has occured
1343: --

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

1343: --
1344: rollback to create_batch_total;
1345: p_batch_control_id := null;
1346: p_object_version_number := null;
1347: hr_utility.set_location(' Leaving:'||l_proc, 90);
1348: raise;
1349: end create_batch_total;
1350: --
1351: --

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

1380: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1381: l_session_date date;
1382: --
1383: begin
1384: hr_utility.set_location('Entering:'|| l_proc, 10);
1385: --
1386: -- Issue a savepoint
1387: --
1388: savepoint update_batch_header;

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

1488: -- Set all output arguments
1489: --
1490: p_object_version_number := l_object_version_number;
1491: --
1492: hr_utility.set_location(' Leaving:'||l_proc, 70);
1493: exception
1494: when hr_api.validate_enabled then
1495: --
1496: -- As the Validate_Enabled exception has been raised

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

1501: -- Only set output warning arguments
1502: -- (Any key or derived arguments must be set to null
1503: -- when validation only mode is being used.)
1504: --
1505: hr_utility.set_location(' Leaving:'||l_proc, 80);
1506: when others then
1507: --
1508: -- A validation or unexpected error has occured
1509: --

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

1508: -- A validation or unexpected error has occured
1509: --
1510: rollback to update_batch_header;
1511: p_object_version_number := l_object_version_number;
1512: hr_utility.set_location(' Leaving:'||l_proc, 90);
1513: raise;
1514: end update_batch_header;
1515: --
1516: --

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

1668: --
1669: l_bee_iv_upgrade varchar2(1);
1670: --
1671: begin
1672: hr_utility.set_location('Entering:'|| l_proc, 10);
1673: --
1674: -- Issue a savepoint
1675: --
1676: savepoint update_batch_line;

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

1691: --
1692: -- Check whether the upgrade process is in progress.
1693: --
1694: if l_bee_iv_upgrade = 'E' then
1695: hr_utility.set_message(800, 'HR_449106_BEE_UPGRADING');
1696: hr_utility.raise_error;
1697: end if;
1698: --
1699: if p_iv_all_internal_format = 'Y' and l_bee_iv_upgrade = 'N' then

Line 1696: hr_utility.raise_error;

1692: -- Check whether the upgrade process is in progress.
1693: --
1694: if l_bee_iv_upgrade = 'E' then
1695: hr_utility.set_message(800, 'HR_449106_BEE_UPGRADING');
1696: hr_utility.raise_error;
1697: end if;
1698: --
1699: if p_iv_all_internal_format = 'Y' and l_bee_iv_upgrade = 'N' then
1700: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

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

1863: ,p_hook_type => 'BP'
1864: );
1865: end;
1866: --
1867: hr_utility.set_location(l_proc, 11);
1868: --
1869: -- Validation in addition to Row Handlers
1870: --
1871: --

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

1988: ,p_subpriority => p_subpriority
1989: ,p_effective_start_date => l_effective_start_date
1990: ,p_effective_end_date => l_effective_end_date);
1991: --
1992: hr_utility.set_location(l_proc, 12);
1993: --
1994: --
1995: -- Call After Process User Hook
1996: --

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

2130: -- Set all output arguments
2131: --
2132: p_object_version_number := l_object_version_number;
2133: --
2134: hr_utility.set_location(' Leaving:'||l_proc, 70);
2135: exception
2136: when hr_api.validate_enabled then
2137: --
2138: -- As the Validate_Enabled exception has been raised

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

2143: -- Only set output warning arguments
2144: -- (Any key or derived arguments must be set to null
2145: -- when validation only mode is being used.)
2146: --
2147: hr_utility.set_location(' Leaving:'||l_proc, 80);
2148: when others then
2149: --
2150: -- A validation or unexpected error has occured
2151: --

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

2150: -- A validation or unexpected error has occured
2151: --
2152: rollback to update_batch_line;
2153: p_object_version_number := l_object_version_number;
2154: hr_utility.set_location(' Leaving:'||l_proc, 90);
2155: raise;
2156: end update_batch_line;
2157: --
2158: --

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

2176: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;
2177: l_session_date date;
2178: --
2179: begin
2180: hr_utility.set_location('Entering:'|| l_proc, 10);
2181: --
2182: -- Issue a savepoint
2183: --
2184: savepoint update_batch_total;

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

2251: -- Set all output arguments
2252: --
2253: p_object_version_number := l_object_version_number;
2254: --
2255: hr_utility.set_location(' Leaving:'||l_proc, 70);
2256: exception
2257: when hr_api.validate_enabled then
2258: --
2259: -- As the Validate_Enabled exception has been raised

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

2264: -- Only set output warning arguments
2265: -- (Any key or derived arguments must be set to null
2266: -- when validation only mode is being used.)
2267: --
2268: hr_utility.set_location(' Leaving:'||l_proc, 80);
2269: when others then
2270: --
2271: -- A validation or unexpected error has occured
2272: --

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

2271: -- A validation or unexpected error has occured
2272: --
2273: rollback to update_batch_total;
2274: p_object_version_number := l_object_version_number;
2275: hr_utility.set_location(' Leaving:'||l_proc, 90);
2276: raise;
2277: end update_batch_total;
2278: --
2279: --

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

2301: from pay_batch_control_totals bct
2302: where bct.batch_id = p_batch_id;
2303: --
2304: begin
2305: hr_utility.set_location('Entering:'|| l_proc, 5);
2306: --
2307: -- Issue a savepoint if operating in validation only mode.
2308: --
2309: savepoint delete_batch_header;

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

2323: );
2324: end;
2325: --
2326: --
2327: hr_utility.set_location(l_proc, 7);
2328: --
2329: -- Process Logic
2330: --
2331: --

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

2344: ,p_object_version_number => cssr.object_version_number
2345: );
2346: end loop;
2347: --
2348: hr_utility.set_location(l_proc, 10);
2349: --
2350: -- Deletes all batch control totals
2351: --
2352: for cssr in csr_batch_ctl_totals loop

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

2362: ,p_object_version_number => cssr.object_version_number
2363: );
2364: end loop;
2365: --
2366: hr_utility.set_location(l_proc, 15);
2367: --
2368: -- Deletes all messages
2369: --
2370: delete from pay_message_lines

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

2377: (p_batch_id => p_batch_id
2378: ,p_object_version_number => p_object_version_number
2379: );
2380: --
2381: hr_utility.set_location(l_proc, 20);
2382: --
2383: --
2384: -- Call After Process User Hook
2385: --

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

2401: if p_validate then
2402: raise hr_api.validate_enabled;
2403: end if;
2404: --
2405: hr_utility.set_location(' Leaving:'||l_proc, 21);
2406: exception
2407: when hr_api.validate_enabled then
2408: --
2409: -- As the Validate_Enabled exception has been raised

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

2410: -- we must rollback to the savepoint
2411: --
2412: ROLLBACK TO delete_batch_header;
2413: --
2414: hr_utility.set_location(' Leaving:'||l_proc, 22);
2415: --
2416: when others then
2417: --
2418: --

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

2437: --
2438: l_proc varchar2(72) := g_package||'delete_batch_line';
2439: --
2440: begin
2441: hr_utility.set_location('Entering:'|| l_proc, 5);
2442: --
2443: -- Issue a savepoint if operating in validation only mode.
2444: --
2445: savepoint delete_batch_line;

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

2459: );
2460: end;
2461: --
2462: --
2463: hr_utility.set_location(l_proc, 7);
2464: --
2465: -- Process Logic
2466: --
2467: --

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

2477: (p_batch_line_id => p_batch_line_id
2478: ,p_object_version_number => p_object_version_number
2479: );
2480: --
2481: hr_utility.set_location(l_proc, 20);
2482: --
2483: --
2484: -- Call After Process User Hook
2485: --

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

2501: if p_validate then
2502: raise hr_api.validate_enabled;
2503: end if;
2504: --
2505: hr_utility.set_location(' Leaving:'||l_proc, 21);
2506: exception
2507: when hr_api.validate_enabled then
2508: --
2509: -- As the Validate_Enabled exception has been raised

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

2510: -- we must rollback to the savepoint
2511: --
2512: ROLLBACK TO delete_batch_line;
2513: --
2514: hr_utility.set_location(' Leaving:'||l_proc, 22);
2515: --
2516: when others then
2517: --
2518: --

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

2537: --
2538: l_proc varchar2(72) := g_package||'delete_batch_total';
2539: --
2540: begin
2541: hr_utility.set_location('Entering:'|| l_proc, 5);
2542: --
2543: -- Issue a savepoint if operating in validation only mode.
2544: --
2545: savepoint delete_batch_total;

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

2559: );
2560: end;
2561: --
2562: --
2563: hr_utility.set_location(l_proc, 7);
2564: --
2565: -- Process Logic
2566: --
2567: --

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

2577: (p_batch_control_id => p_batch_control_id
2578: ,p_object_version_number => p_object_version_number
2579: );
2580: --
2581: hr_utility.set_location(l_proc, 20);
2582: --
2583: --
2584: -- Call After Process User Hook
2585: --

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

2601: if p_validate then
2602: raise hr_api.validate_enabled;
2603: end if;
2604: --
2605: hr_utility.set_location(' Leaving:'||l_proc, 21);
2606: exception
2607: when hr_api.validate_enabled then
2608: --
2609: -- As the Validate_Enabled exception has been raised

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

2610: -- we must rollback to the savepoint
2611: --
2612: ROLLBACK TO delete_batch_total;
2613: --
2614: hr_utility.set_location(' Leaving:'||l_proc, 22);
2615: --
2616: when others then
2617: --
2618: --