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.PSP_ARCHIVE_RETRIEVE dependencies on HR_UTILITY

Line 1783: g_debug_enabled := hr_utility.Debug_enabled();

1779: BEGIN
1780:
1781: hr_general.g_data_migrator_mode := 'Y';
1782:
1783: g_debug_enabled := hr_utility.Debug_enabled();
1784:
1785: IF g_debug_enabled THEN
1786: hr_utility.Trace('Entering DI Archive');
1787: END IF;

Line 1786: hr_utility.Trace('Entering DI Archive');

1782:
1783: g_debug_enabled := hr_utility.Debug_enabled();
1784:
1785: IF g_debug_enabled THEN
1786: hr_utility.Trace('Entering DI Archive');
1787: END IF;
1788:
1789: SELECT To_number(fnd_profile.VALUE ('PER_BUSINESS_GROUP_ID'))
1790: INTO l_business_group_id

Line 1798: hr_utility.Trace('Business_group_id '||l_business_group_id);

1794: INTO l_set_of_books_id
1795: FROM dual;
1796:
1797: IF g_debug_enabled THEN
1798: hr_utility.Trace('Business_group_id '||l_business_group_id);
1799: hr_utility.Trace('Set_of_books_id '||l_set_of_books_id);
1800: END IF;
1801:
1802: fnd_file.Put_line(fnd_file.log,'-----------------------------------------------------------------------');

Line 1799: hr_utility.Trace('Set_of_books_id '||l_set_of_books_id);

1795: FROM dual;
1796:
1797: IF g_debug_enabled THEN
1798: hr_utility.Trace('Business_group_id '||l_business_group_id);
1799: hr_utility.Trace('Set_of_books_id '||l_set_of_books_id);
1800: END IF;
1801:
1802: fnd_file.Put_line(fnd_file.log,'-----------------------------------------------------------------------');
1803: fnd_file.Put_line(fnd_file.log,' Archiving Pre-Gen Distribution Interface for the following parameters ');

Line 1819: hr_utility.Trace('After - batch_name_rec.batch_name.count: '||batch_name_rec.batch_name.COUNT);

1815: FETCH batch_name_cur BULK COLLECT INTO batch_name_rec.batch_name,batch_name_rec.batch_size,batch_name_rec.min_dist_date,batch_name_rec.max_dist_date;
1816: CLOSE batch_name_cur;
1817:
1818: IF g_debug_enabled THEN
1819: hr_utility.Trace('After - batch_name_rec.batch_name.count: '||batch_name_rec.batch_name.COUNT);
1820: END IF;
1821:
1822: fnd_file.Put_line(fnd_file.log,'The following '||batch_name_rec.batch_name.COUNT||' batches are selected for archival');
1823:

Line 1829: hr_utility.Trace('Batch: '||batch_name_rec.Batch_name(i));

1825:
1826: FOR i IN 1..batch_name_rec.batch_name.COUNT
1827: LOOP
1828: IF g_debug_enabled THEN
1829: hr_utility.Trace('Batch: '||batch_name_rec.Batch_name(i));
1830: END IF;
1831: fnd_file.Put_line(fnd_file.log,' '||i||' - '||batch_name_rec.Batch_name(i));
1832: END LOOP;
1833:

Line 1838: hr_utility.Trace('No Batches to process');

1834:
1835: IF batch_name_rec.batch_name.COUNT = 0
1836: THEN
1837: IF g_debug_enabled THEN
1838: hr_utility.Trace('No Batches to process');
1839: END IF;
1840: fnd_file.Put_line(fnd_file.log,'No Valid batches to archive for period '||p_begin_date||' - '||p_end_date);
1841: RETURN; --Control returns back if there are no batches to be archived.
1842: END IF;

Line 1854: hr_utility.Trace(j||' - Processing Batch: '||batch_name_rec.Batch_name(j));

1850: FOR j IN batch_name_rec.batch_name.first..batch_name_rec.batch_name.last
1851: LOOP
1852: IF batch_name_rec.batch_name.EXISTS(j) THEN
1853: IF g_debug_enabled THEN
1854: hr_utility.Trace(j||' - Processing Batch: '||batch_name_rec.Batch_name(j));
1855: END IF;
1856:
1857: -- Creates a control record in the control table for EVERY BATCH with the request id,archival_code,batch_size,archival dates and the distribution dates.
1858: -- Archival Process dates --> start_date and end_date

Line 1948: hr_utility.Trace('count: '||r_batch_rec.t_distribution_interface_id.COUNT);

1944: ,r_batch_rec.t_suspense_auto_exp_type
1945: LIMIT 500;
1946:
1947: IF g_debug_enabled THEN
1948: hr_utility.Trace('count: '||r_batch_rec.t_distribution_interface_id.COUNT);
1949: END IF;
1950:
1951: exit WHEN r_batch_rec.t_distribution_interface_id.COUNT = 0;
1952:

Line 2064: hr_utility.Trace('g_bulk_row_count: '||g_bulk_row_count);

2060: g_bulk_row_count := g_bulk_row_count + SQL%bulk_rowcount(bulk_idx);
2061: END LOOP;
2062:
2063: IF g_debug_enabled THEN
2064: hr_utility.Trace('g_bulk_row_count: '||g_bulk_row_count);
2065: END IF;
2066:
2067: -- Deletion of archived data from original table
2068:

Line 2081: hr_utility.Trace('update psp_arch_ret_requests count: '||SQL%rowcount);

2077: WHERE request_id = l_request_id
2078: AND batch_name LIKE batch_name_rec.Batch_name(j);
2079:
2080: IF g_debug_enabled THEN
2081: hr_utility.Trace('update psp_arch_ret_requests count: '||SQL%rowcount);
2082: END IF;
2083:
2084: COMMIT; -- Committing partial batch
2085:

Line 2093: hr_utility.Trace(j||' - Successfully processed batch: '|| batch_name_rec.Batch_name(j));

2089:
2090:
2091:
2092: IF g_debug_enabled THEN
2093: hr_utility.Trace(j||' - Successfully processed batch: '|| batch_name_rec.Batch_name(j));
2094: END IF;
2095:
2096: --Once the complete data is archived the corresponding BATCH is updated as A.
2097:

Line 2104: hr_utility.Trace('Updated psp_arch_ret_requests setting to A: '||SQL%rowcount);

2100: WHERE request_id = l_request_id
2101: AND batch_name = batch_name_rec.Batch_name(j);
2102:
2103: IF g_debug_enabled THEN
2104: hr_utility.Trace('Updated psp_arch_ret_requests setting to A: '||SQL%rowcount);
2105: END IF;
2106:
2107: -- Below query helps to validate whether the complete data is archived or not
2108:

Line 2131: hr_utility.Trace('Archive Distribtuion Interface processed successfully ');

2127:
2128:
2129: fnd_file.Put_line(fnd_file.log,' Archive Distribtuion Interface processed successfully');
2130: IF g_debug_enabled THEN
2131: hr_utility.Trace('Archive Distribtuion Interface processed successfully ');
2132: END IF;
2133:
2134: EXCEPTION
2135: WHEN OTHERS THEN

Line 2329: g_debug_enabled := hr_utility.Debug_enabled();

2325: BEGIN
2326:
2327: hr_general.g_data_migrator_mode := 'Y';
2328:
2329: g_debug_enabled := hr_utility.Debug_enabled();
2330:
2331: IF g_debug_enabled THEN
2332: hr_utility.Trace('Entering DI Retrieve');
2333: END IF;

Line 2332: hr_utility.Trace('Entering DI Retrieve');

2328:
2329: g_debug_enabled := hr_utility.Debug_enabled();
2330:
2331: IF g_debug_enabled THEN
2332: hr_utility.Trace('Entering DI Retrieve');
2333: END IF;
2334:
2335:
2336: -- Selects archival code information which is same for all the batchs for the corresponding arch request id

Line 2353: hr_utility.Trace('updated batches in psp_arch_ret_requests set to R - count: '||SQL%rowcount);

2349: SET arch_ret_flag = 'R' -- Locking the batches to be retrieved
2350: WHERE request_id = p_arch_request_id;
2351:
2352: IF g_debug_enabled THEN
2353: hr_utility.Trace('updated batches in psp_arch_ret_requests set to R - count: '||SQL%rowcount);
2354: END IF;
2355:
2356: COMMIT;
2357:

Line 2370: hr_utility.Trace('Batch: '||batch_name_rec.Batch_name(i));

2366:
2367: FOR i IN 1..batch_name_rec.batch_name.COUNT
2368: LOOP
2369: IF g_debug_enabled THEN
2370: hr_utility.Trace('Batch: '||batch_name_rec.Batch_name(i));
2371: END IF;
2372: fnd_file.Put_line(fnd_file.log,' '||i||' - '||batch_name_rec.Batch_name(i));
2373: END LOOP;
2374:

Line 2451: hr_utility.Trace('count: '||r_batch_rec.t_distribution_interface_id.COUNT);

2447: ,r_batch_rec.t_suspense_auto_exp_type
2448: LIMIT 500;
2449:
2450: IF g_debug_enabled THEN
2451: hr_utility.Trace('count: '||r_batch_rec.t_distribution_interface_id.COUNT);
2452: END IF;
2453:
2454: exit WHEN r_batch_rec.t_distribution_interface_id.COUNT = 0;
2455:

Line 2564: hr_utility.Trace('g_bulk_row_count insert : '||g_bulk_row_count);

2560: g_bulk_row_count := g_bulk_row_count + SQL%bulk_rowcount(bulk_idx);
2561: END LOOP;
2562:
2563: IF g_debug_enabled THEN
2564: hr_utility.Trace('g_bulk_row_count insert : '||g_bulk_row_count);
2565: END IF;
2566:
2567: -- Deletes the records from the archive table once the records get created in main table.
2568:

Line 2580: hr_utility.Trace('g_bulk_row_count delete: '||g_bulk_row_count);

2576: g_bulk_row_count := g_bulk_row_count + SQL%bulk_rowcount(bulk_idx);
2577: END LOOP;
2578:
2579: IF g_debug_enabled THEN
2580: hr_utility.Trace('g_bulk_row_count delete: '||g_bulk_row_count);
2581: END IF;
2582:
2583: -- Reduces the size of the batch from control table when the records were moved partially from archive to main table.
2584: UPDATE psp_arch_ret_requests

Line 2590: hr_utility.Trace('Batch Name: '||batch_name_rec.Batch_name(i)|| ' request_id: '||p_arch_request_id);

2586: WHERE request_id = p_arch_request_id
2587: AND batch_name = batch_name_rec.Batch_name(i);
2588:
2589: IF g_debug_enabled THEN
2590: hr_utility.Trace('Batch Name: '||batch_name_rec.Batch_name(i)|| ' request_id: '||p_arch_request_id);
2591: hr_utility.Trace('Updated psp_arch_ret_requests: '||SQL%rowcount);
2592: END IF;
2593:
2594: COMMIT; -- Committing partial batch Jbz

Line 2591: hr_utility.Trace('Updated psp_arch_ret_requests: '||SQL%rowcount);

2587: AND batch_name = batch_name_rec.Batch_name(i);
2588:
2589: IF g_debug_enabled THEN
2590: hr_utility.Trace('Batch Name: '||batch_name_rec.Batch_name(i)|| ' request_id: '||p_arch_request_id);
2591: hr_utility.Trace('Updated psp_arch_ret_requests: '||SQL%rowcount);
2592: END IF;
2593:
2594: COMMIT; -- Committing partial batch Jbz
2595: END LOOP;

Line 2605: hr_utility.Trace('after select: '||l_remaining_records||' : '||l_original_batch_size);

2601: FETCH batch_counts_cur INTO l_remaining_records,l_original_batch_size;
2602: CLOSE batch_counts_cur;
2603:
2604: IF g_debug_enabled THEN
2605: hr_utility.Trace('after select: '||l_remaining_records||' : '||l_original_batch_size);
2606: END IF;
2607:
2608: IF l_remaining_records = 0 THEN
2609: fnd_file.Put_line(fnd_file.log,i||'. '||batch_name_rec.Batch_name(i)||' '||batch_name_rec.Min_dist_date(i)||' '||batch_name_rec.Max_dist_date(i)||' '||l_original_batch_size);

Line 2626: hr_utility.Trace('delete count: '||SQL%rowcount);

2622: DELETE FROM psp_arch_ret_requests
2623: WHERE request_id = p_arch_request_id;
2624:
2625: IF g_debug_enabled THEN
2626: hr_utility.Trace('delete count: '||SQL%rowcount);
2627: END IF;
2628:
2629: COMMIT;
2630: