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 FND_FILE

Line 595: psp_message_s.print_error(p_mode=>FND_FILE.log,

591: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
592: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
593: fnd_msg_pub.add;
594: --psp_message_s.print_success;
595: psp_message_s.print_error(p_mode=>FND_FILE.log,
596: p_print_header=>FND_API.G_FALSE);
597: retcode := 0;
598: EXCEPTION
599:

Line 604: psp_message_s.print_error( p_mode => FND_FILE.LOG,

600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: /* Following added for bug 2482603 */
602: g_error_api_path := SUBSTR('ARCHIVE_DISTRIBUTION '||g_error_api_path,1,230);
603: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);
604: psp_message_s.print_error( p_mode => FND_FILE.LOG,
605: p_print_header => FND_API.G_TRUE);
606: retcode := 2;
607:
608: WHEN OTHERS THEN

Line 612: psp_message_s.print_error( p_mode => FND_FILE.LOG,

608: WHEN OTHERS THEN
609: /* Following added for bug 2482603 */
610: g_error_api_path := SUBSTR('ARCHIVE_DISTRIBUTION '||g_error_api_path,1,230);
611: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);
612: psp_message_s.print_error( p_mode => FND_FILE.LOG,
613: p_print_header => FND_API.G_TRUE);
614: retcode := 2;
615: END archive_distribution;
616:

Line 1016: psp_message_s.print_error(p_mode=>FND_FILE.log,

1012: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
1013: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
1014: fnd_msg_pub.add;
1015: --psp_message_s.print_success;
1016: psp_message_s.print_error(p_mode=>FND_FILE.log,
1017: p_print_header=>FND_API.G_FALSE);
1018: retcode := 0;
1019: EXCEPTION
1020: WHEN OTHERS THEN

Line 1024: psp_message_s.print_error( p_mode => FND_FILE.LOG,

1020: WHEN OTHERS THEN
1021: /* Following Added for bug 2482603 */
1022: g_error_api_path := SUBSTR('RETRIEVE_DISTRIBUTION '||g_error_api_path,1,230);
1023: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);
1024: psp_message_s.print_error( p_mode => FND_FILE.LOG,
1025: p_print_header => FND_API.G_TRUE);
1026: retcode := 2;
1027: END retrieve_distribution;
1028:

Line 1298: psp_message_s.print_error( p_mode => FND_FILE.LOG,

1294: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1295: fnd_msg_pub.add;
1296:
1297: -- Write all the accumulated messages into the log
1298: psp_message_s.print_error( p_mode => FND_FILE.LOG,
1299: p_print_header => FND_API.G_FALSE);
1300: retcode := 0;
1301:
1302: --Exception handling starts here

Line 1310: psp_message_s.print_error( p_mode => FND_FILE.LOG,

1306: -- Update the log with the messages accumulated so far
1307: /* Following added for bug 2482603 */
1308: g_error_api_path := SUBSTR('ARCHIVE_ENCUMBRANCE '||g_error_api_path,1,230);
1309: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);
1310: psp_message_s.print_error( p_mode => FND_FILE.LOG,
1311: p_print_header => FND_API.G_TRUE);
1312: retcode := 2;
1313:
1314: -- For any other exception, ROLLBACK

Line 1319: psp_message_s.print_error( p_mode => FND_FILE.LOG,

1315: When OTHERS Then
1316: /* Following added for bug 2482603 */
1317: g_error_api_path := SUBSTR('ARCHIVE_ENCUMBRANCE '||g_error_api_path,1,230);
1318: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);
1319: psp_message_s.print_error( p_mode => FND_FILE.LOG,
1320: p_print_header => FND_API.G_TRUE);
1321: retcode := 2;
1322: End archive_encumbrance;
1323:

Line 1550: psp_message_s.print_error( p_mode => FND_FILE.LOG,

1546: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1547: fnd_msg_pub.add;
1548:
1549: -- Write all messages into Log
1550: psp_message_s.print_error( p_mode => FND_FILE.LOG,
1551: p_print_header => FND_API.G_FALSE);
1552: retcode := 0;
1553:
1554: --Exception handling starts here

Line 1561: psp_message_s.print_error( p_mode => FND_FILE.LOG,

1557: When OTHERS Then
1558: /* Folllowing is added for bug 2482603 */
1559: g_error_api_path := SUBSTR('RETRIEVE_ENCUMBRANCE '||g_error_api_path,1,230);
1560: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);
1561: psp_message_s.print_error( p_mode => FND_FILE.LOG,
1562: p_print_header => FND_API.G_TRUE);
1563: retcode := 2;
1564: End retrieve_encumbrance;
1565:

Line 1802: fnd_file.Put_line(fnd_file.log,'-----------------------------------------------------------------------');

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 ');
1804: fnd_file.Put_line(fnd_file.log,' Begin date of the batch: '||p_begin_date);
1805: fnd_file.Put_line(fnd_file.log,' End date of the batch: '||p_end_date);
1806: fnd_file.Put_line(fnd_file.log,' Archival Code: '||p_archival_code);

Line 1803: fnd_file.Put_line(fnd_file.log,' Archiving Pre-Gen Distribution Interface for the following parameters ');

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 ');
1804: fnd_file.Put_line(fnd_file.log,' Begin date of the batch: '||p_begin_date);
1805: fnd_file.Put_line(fnd_file.log,' End date of the batch: '||p_end_date);
1806: fnd_file.Put_line(fnd_file.log,' Archival Code: '||p_archival_code);
1807: fnd_file.Put_line(fnd_file.log,' Business_group_id: '||l_business_group_id);

Line 1804: fnd_file.Put_line(fnd_file.log,' Begin date of the batch: '||p_begin_date);

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 ');
1804: fnd_file.Put_line(fnd_file.log,' Begin date of the batch: '||p_begin_date);
1805: fnd_file.Put_line(fnd_file.log,' End date of the batch: '||p_end_date);
1806: fnd_file.Put_line(fnd_file.log,' Archival Code: '||p_archival_code);
1807: fnd_file.Put_line(fnd_file.log,' Business_group_id: '||l_business_group_id);
1808: fnd_file.Put_line(fnd_file.log,' Set_of_books_id: '||l_set_of_books_id);

Line 1805: fnd_file.Put_line(fnd_file.log,' End date of the batch: '||p_end_date);

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 ');
1804: fnd_file.Put_line(fnd_file.log,' Begin date of the batch: '||p_begin_date);
1805: fnd_file.Put_line(fnd_file.log,' End date of the batch: '||p_end_date);
1806: fnd_file.Put_line(fnd_file.log,' Archival Code: '||p_archival_code);
1807: fnd_file.Put_line(fnd_file.log,' Business_group_id: '||l_business_group_id);
1808: fnd_file.Put_line(fnd_file.log,' Set_of_books_id: '||l_set_of_books_id);
1809: fnd_file.Put_line(fnd_file.log,'-----------------------------------------------------------------------');

Line 1806: fnd_file.Put_line(fnd_file.log,' Archival Code: '||p_archival_code);

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 ');
1804: fnd_file.Put_line(fnd_file.log,' Begin date of the batch: '||p_begin_date);
1805: fnd_file.Put_line(fnd_file.log,' End date of the batch: '||p_end_date);
1806: fnd_file.Put_line(fnd_file.log,' Archival Code: '||p_archival_code);
1807: fnd_file.Put_line(fnd_file.log,' Business_group_id: '||l_business_group_id);
1808: fnd_file.Put_line(fnd_file.log,' Set_of_books_id: '||l_set_of_books_id);
1809: fnd_file.Put_line(fnd_file.log,'-----------------------------------------------------------------------');
1810:

Line 1807: fnd_file.Put_line(fnd_file.log,' Business_group_id: '||l_business_group_id);

1803: fnd_file.Put_line(fnd_file.log,' Archiving Pre-Gen Distribution Interface for the following parameters ');
1804: fnd_file.Put_line(fnd_file.log,' Begin date of the batch: '||p_begin_date);
1805: fnd_file.Put_line(fnd_file.log,' End date of the batch: '||p_end_date);
1806: fnd_file.Put_line(fnd_file.log,' Archival Code: '||p_archival_code);
1807: fnd_file.Put_line(fnd_file.log,' Business_group_id: '||l_business_group_id);
1808: fnd_file.Put_line(fnd_file.log,' Set_of_books_id: '||l_set_of_books_id);
1809: fnd_file.Put_line(fnd_file.log,'-----------------------------------------------------------------------');
1810:
1811:

Line 1808: fnd_file.Put_line(fnd_file.log,' Set_of_books_id: '||l_set_of_books_id);

1804: fnd_file.Put_line(fnd_file.log,' Begin date of the batch: '||p_begin_date);
1805: fnd_file.Put_line(fnd_file.log,' End date of the batch: '||p_end_date);
1806: fnd_file.Put_line(fnd_file.log,' Archival Code: '||p_archival_code);
1807: fnd_file.Put_line(fnd_file.log,' Business_group_id: '||l_business_group_id);
1808: fnd_file.Put_line(fnd_file.log,' Set_of_books_id: '||l_set_of_books_id);
1809: fnd_file.Put_line(fnd_file.log,'-----------------------------------------------------------------------');
1810:
1811:
1812: -- Picks the batch informations i.e batch_name, batch size, min distribution date and max distribution date basing on the start date and end date of the archival process.

Line 1809: fnd_file.Put_line(fnd_file.log,'-----------------------------------------------------------------------');

1805: fnd_file.Put_line(fnd_file.log,' End date of the batch: '||p_end_date);
1806: fnd_file.Put_line(fnd_file.log,' Archival Code: '||p_archival_code);
1807: fnd_file.Put_line(fnd_file.log,' Business_group_id: '||l_business_group_id);
1808: fnd_file.Put_line(fnd_file.log,' Set_of_books_id: '||l_set_of_books_id);
1809: fnd_file.Put_line(fnd_file.log,'-----------------------------------------------------------------------');
1810:
1811:
1812: -- Picks the batch informations i.e batch_name, batch size, min distribution date and max distribution date basing on the start date and end date of the archival process.
1813:

Line 1822: fnd_file.Put_line(fnd_file.log,'The following '||batch_name_rec.batch_name.COUNT||' batches are selected for archival');

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:
1824: -- To display the batch names which were selected for archival process.
1825:
1826: FOR i IN 1..batch_name_rec.batch_name.COUNT

Line 1831: fnd_file.Put_line(fnd_file.log,' '||i||' - '||batch_name_rec.Batch_name(i));

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:
1834:
1835: IF batch_name_rec.batch_name.COUNT = 0

Line 1840: fnd_file.Put_line(fnd_file.log,'No Valid batches to archive for period '||p_begin_date||' - '||p_end_date);

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;
1843:
1844: l_request_id := fnd_global.conc_request_id;

Line 1846: fnd_file.Put_line(fnd_file.log,'--------------------------------------------------------------------------------------------------------------------');

1842: END IF;
1843:
1844: l_request_id := fnd_global.conc_request_id;
1845:
1846: fnd_file.Put_line(fnd_file.log,'--------------------------------------------------------------------------------------------------------------------');
1847: fnd_file.Put_line(fnd_file.log,' Batch Name Minimum Distribution Date Maximum Distribution Date Batch Size');
1848: fnd_file.Put_line(fnd_file.log,'---------------------------------------------------------------------------------------------------------------------');
1849:
1850: FOR j IN batch_name_rec.batch_name.first..batch_name_rec.batch_name.last

Line 1847: fnd_file.Put_line(fnd_file.log,' Batch Name Minimum Distribution Date Maximum Distribution Date Batch Size');

1843:
1844: l_request_id := fnd_global.conc_request_id;
1845:
1846: fnd_file.Put_line(fnd_file.log,'--------------------------------------------------------------------------------------------------------------------');
1847: fnd_file.Put_line(fnd_file.log,' Batch Name Minimum Distribution Date Maximum Distribution Date Batch Size');
1848: fnd_file.Put_line(fnd_file.log,'---------------------------------------------------------------------------------------------------------------------');
1849:
1850: FOR j IN batch_name_rec.batch_name.first..batch_name_rec.batch_name.last
1851: LOOP

Line 1848: fnd_file.Put_line(fnd_file.log,'---------------------------------------------------------------------------------------------------------------------');

1844: l_request_id := fnd_global.conc_request_id;
1845:
1846: fnd_file.Put_line(fnd_file.log,'--------------------------------------------------------------------------------------------------------------------');
1847: fnd_file.Put_line(fnd_file.log,' Batch Name Minimum Distribution Date Maximum Distribution Date Batch Size');
1848: fnd_file.Put_line(fnd_file.log,'---------------------------------------------------------------------------------------------------------------------');
1849:
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

Line 2117: fnd_file.Put_line(fnd_file.log,j||'. '||batch_name_rec.Batch_name(j)||' '||batch_name_rec.Min_dist_date(j)||' '||batch_name_rec.Max_dist_date(j)||' '||l_original_size);

2113: AND batch_name = batch_name_rec.Batch_name(j);
2114:
2115:
2116: IF l_original_size = l_archived_batch_size THEN
2117: fnd_file.Put_line(fnd_file.log,j||'. '||batch_name_rec.Batch_name(j)||' '||batch_name_rec.Min_dist_date(j)||' '||batch_name_rec.Max_dist_date(j)||' '||l_original_size);
2118: ELSE
2119: fnd_file.Put_line(fnd_file.log,j||'. '||batch_name_rec.Batch_name(j)||' '||batch_name_rec.Min_dist_date(j)||' '||batch_name_rec.Max_dist_date(j)||' '||l_original_size|| ' Archival Incomplete');
2120: END IF;
2121:

Line 2119: fnd_file.Put_line(fnd_file.log,j||'. '||batch_name_rec.Batch_name(j)||' '||batch_name_rec.Min_dist_date(j)||' '||batch_name_rec.Max_dist_date(j)||' '||l_original_size|| ' Archival Incomplete');

2115:
2116: IF l_original_size = l_archived_batch_size THEN
2117: fnd_file.Put_line(fnd_file.log,j||'. '||batch_name_rec.Batch_name(j)||' '||batch_name_rec.Min_dist_date(j)||' '||batch_name_rec.Max_dist_date(j)||' '||l_original_size);
2118: ELSE
2119: fnd_file.Put_line(fnd_file.log,j||'. '||batch_name_rec.Batch_name(j)||' '||batch_name_rec.Min_dist_date(j)||' '||batch_name_rec.Max_dist_date(j)||' '||l_original_size|| ' Archival Incomplete');
2120: END IF;
2121:
2122:
2123: COMMIT; -- Commit updates

Line 2126: fnd_file.Put_line(fnd_file.log,'---------------------------------------------------------------------------------------------------------------------');

2122:
2123: COMMIT; -- Commit updates
2124: END IF;
2125: END LOOP;
2126: fnd_file.Put_line(fnd_file.log,'---------------------------------------------------------------------------------------------------------------------');
2127:
2128:
2129: fnd_file.Put_line(fnd_file.log,' Archive Distribtuion Interface processed successfully');
2130: IF g_debug_enabled THEN

Line 2129: fnd_file.Put_line(fnd_file.log,' Archive Distribtuion Interface processed successfully');

2125: END LOOP;
2126: fnd_file.Put_line(fnd_file.log,'---------------------------------------------------------------------------------------------------------------------');
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:

Line 2137: fnd_file.Put_line(fnd_file.log,dbms_utility.format_error_backtrace);

2133:
2134: EXCEPTION
2135: WHEN OTHERS THEN
2136:
2137: fnd_file.Put_line(fnd_file.log,dbms_utility.format_error_backtrace);
2138: fnd_file.Put_line(fnd_file.log,'ARCHIVE_DISTRIBUTION_INT---> exception '||sqlerrm);
2139:
2140: END archive_distribution_int;
2141:

Line 2138: fnd_file.Put_line(fnd_file.log,'ARCHIVE_DISTRIBUTION_INT---> exception '||sqlerrm);

2134: EXCEPTION
2135: WHEN OTHERS THEN
2136:
2137: fnd_file.Put_line(fnd_file.log,dbms_utility.format_error_backtrace);
2138: fnd_file.Put_line(fnd_file.log,'ARCHIVE_DISTRIBUTION_INT---> exception '||sqlerrm);
2139:
2140: END archive_distribution_int;
2141:
2142:

Line 2344: fnd_file.Put_line(fnd_file.log,'Retrieve Distribution Interface for Archival Code: '||l_archival_code|| ' for Start Date: '||l_begin_date||' and End Date: '||l_end_date);

2340: FROM psp_arch_ret_requests
2341: WHERE request_id = p_arch_request_id
2342: AND rownum < 2;
2343:
2344: fnd_file.Put_line(fnd_file.log,'Retrieve Distribution Interface for Archival Code: '||l_archival_code|| ' for Start Date: '||l_begin_date||' and End Date: '||l_end_date);
2345:
2346: -- Initially the arch_ret_flag will be A, before the retrieval process begins the flag will change to R for all the batches of the request
2347:
2348: UPDATE psp_arch_ret_requests

Line 2364: fnd_file.Put_line(fnd_file.log,'The following '||batch_name_rec.batch_name.COUNT||' batches are selected for Retrieval'); --13923287

2360: OPEN batch_name_cur(p_arch_request_id);
2361: 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;
2362: CLOSE batch_name_cur;
2363:
2364: fnd_file.Put_line(fnd_file.log,'The following '||batch_name_rec.batch_name.COUNT||' batches are selected for Retrieval'); --13923287
2365:
2366:
2367: FOR i IN 1..batch_name_rec.batch_name.COUNT
2368: LOOP

Line 2372: fnd_file.Put_line(fnd_file.log,' '||i||' - '||batch_name_rec.Batch_name(i));

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:
2375:
2376:

Line 2377: fnd_file.Put_line(fnd_file.log,'--------------------------------------------------------------------------------------------------------------------');

2373: END LOOP;
2374:
2375:
2376:
2377: fnd_file.Put_line(fnd_file.log,'--------------------------------------------------------------------------------------------------------------------');
2378: fnd_file.Put_line(fnd_file.log,' Batch Name Minimum Distribution Date Maximum Distribution Date Batch Size');
2379: fnd_file.Put_line(fnd_file.log,'---------------------------------------------------------------------------------------------------------------------');
2380:
2381:

Line 2378: fnd_file.Put_line(fnd_file.log,' Batch Name Minimum Distribution Date Maximum Distribution Date Batch Size');

2374:
2375:
2376:
2377: fnd_file.Put_line(fnd_file.log,'--------------------------------------------------------------------------------------------------------------------');
2378: fnd_file.Put_line(fnd_file.log,' Batch Name Minimum Distribution Date Maximum Distribution Date Batch Size');
2379: fnd_file.Put_line(fnd_file.log,'---------------------------------------------------------------------------------------------------------------------');
2380:
2381:
2382: FOR i IN 1..batch_name_rec.batch_name.COUNT

Line 2379: fnd_file.Put_line(fnd_file.log,'---------------------------------------------------------------------------------------------------------------------');

2375:
2376:
2377: fnd_file.Put_line(fnd_file.log,'--------------------------------------------------------------------------------------------------------------------');
2378: fnd_file.Put_line(fnd_file.log,' Batch Name Minimum Distribution Date Maximum Distribution Date Batch Size');
2379: fnd_file.Put_line(fnd_file.log,'---------------------------------------------------------------------------------------------------------------------');
2380:
2381:
2382: FOR i IN 1..batch_name_rec.batch_name.COUNT
2383: LOOP

Line 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);

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);
2610: ELSE
2611: 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|| ' Retrival Incomplete');
2612: END IF;
2613:

Line 2611: 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|| ' Retrival Incomplete');

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);
2610: ELSE
2611: 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|| ' Retrival Incomplete');
2612: END IF;
2613:
2614: -- Once the complete batch is processed then the next batch will start for retrival process
2615:

Line 2618: fnd_file.Put_line(fnd_file.log,'---------------------------------------------------------------------------------------------------------------------');

2614: -- Once the complete batch is processed then the next batch will start for retrival process
2615:
2616: END LOOP;
2617:
2618: fnd_file.Put_line(fnd_file.log,'---------------------------------------------------------------------------------------------------------------------');
2619:
2620: -- Once all the batches were completed the records corresponding to the arch request id will be deleted from the control table.
2621:
2622: DELETE FROM psp_arch_ret_requests

Line 2631: fnd_file.Put_line(fnd_file.log,'Retrieve Distribution Interface successfully completed');

2627: END IF;
2628:
2629: COMMIT;
2630:
2631: fnd_file.Put_line(fnd_file.log,'Retrieve Distribution Interface successfully completed');
2632:
2633: EXCEPTION
2634: WHEN OTHERS THEN
2635:

Line 2636: fnd_file.Put_line(fnd_file.log,dbms_utility.format_error_backtrace);

2632:
2633: EXCEPTION
2634: WHEN OTHERS THEN
2635:
2636: fnd_file.Put_line(fnd_file.log,dbms_utility.format_error_backtrace);
2637: fnd_file.Put_line(fnd_file.log,'RETRIEVE_DISTRIBUTION_INT---> exception '||sqlerrm);
2638:
2639:
2640: END retrieve_distribution_int;

Line 2637: fnd_file.Put_line(fnd_file.log,'RETRIEVE_DISTRIBUTION_INT---> exception '||sqlerrm);

2633: EXCEPTION
2634: WHEN OTHERS THEN
2635:
2636: fnd_file.Put_line(fnd_file.log,dbms_utility.format_error_backtrace);
2637: fnd_file.Put_line(fnd_file.log,'RETRIEVE_DISTRIBUTION_INT---> exception '||sqlerrm);
2638:
2639:
2640: END retrieve_distribution_int;
2641: