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.FUN_SEQ_BATCH dependencies on FUN_SEQ_BATCH

Line 1: PACKAGE BODY fun_seq_batch AS

1: PACKAGE BODY fun_seq_batch AS
2: /* $Header: funsqbtb.pls 120.43 2006/08/30 16:06:48 esayyed noship $ */
3: --
4: -- For debuggin
5: --

Line 6: g_module CONSTANT VARCHAR2(30) := 'fun.plsql.fun_seq_batch';

2: /* $Header: funsqbtb.pls 120.43 2006/08/30 16:06:48 esayyed noship $ */
3: --
4: -- For debuggin
5: --
6: g_module CONSTANT VARCHAR2(30) := 'fun.plsql.fun_seq_batch';
7: -- added global variable for sort by GL Date at posting event
8: g_sort_option_code fun_seq_contexts.sort_option%TYPE;
9: -- PROCEDURE NAME:
10: -- Batch_Init

Line 388: 'fun.plsql.fun_seq_batch.generate_bulk_numbers.begin',

384: --
385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
386: FND_LOG.STRING(
387: FND_LOG.LEVEL_PROCEDURE,
388: 'fun.plsql.fun_seq_batch.generate_bulk_numbers.begin',
389: 'Beginning of generate_bulk_numbers');
390: END IF;
391: --
392: -- Hold parameters in local variables

Line 460: 'fun.plsql.fun_seq_batch.generate_bulk_numbers.end',

456: --
457: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
458: FND_LOG.STRING(
459: FND_LOG.LEVEL_PROCEDURE,
460: 'fun.plsql.fun_seq_batch.generate_bulk_numbers.end',
461: 'Generate_bulk_numbers completes successfully.');
462: END IF;
463: EXCEPTION
464: WHEN OTHERS THEN

Line 499: 'fun.plsql.fun_seq_batch.populate_acct_seq_info.begin',

495: --
496: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
497: FND_LOG.STRING(
498: FND_LOG.LEVEL_PROCEDURE,
499: 'fun.plsql.fun_seq_batch.populate_acct_seq_info.begin',
500: 'Calling fun_seq_batch.populate_acct_seq_info:'||
501: 'p_calling_program => ' || p_calling_program ||', ' ||
502: 'p_request_id => ' || p_request_id );
503: END IF;

Line 500: 'Calling fun_seq_batch.populate_acct_seq_info:'||

496: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
497: FND_LOG.STRING(
498: FND_LOG.LEVEL_PROCEDURE,
499: 'fun.plsql.fun_seq_batch.populate_acct_seq_info.begin',
500: 'Calling fun_seq_batch.populate_acct_seq_info:'||
501: 'p_calling_program => ' || p_calling_program ||', ' ||
502: 'p_request_id => ' || p_request_id );
503: END IF;
504:

Line 521: 'fun.plsql.fun_seq_batch.populate_acct_seq_info.end',

517: --
518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
519: FND_LOG.STRING(
520: FND_LOG.LEVEL_PROCEDURE,
521: 'fun.plsql.fun_seq_batch.populate_acct_seq_info.end',
522: 'Calling fun_seq_batch.populate_acct_seq_info:'||
523: 'p_calling_program => ' || p_calling_program ||', ' ||
524: 'p_request_id => ' || p_request_id );
525: END IF;

Line 522: 'Calling fun_seq_batch.populate_acct_seq_info:'||

518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
519: FND_LOG.STRING(
520: FND_LOG.LEVEL_PROCEDURE,
521: 'fun.plsql.fun_seq_batch.populate_acct_seq_info.end',
522: 'Calling fun_seq_batch.populate_acct_seq_info:'||
523: 'p_calling_program => ' || p_calling_program ||', ' ||
524: 'p_request_id => ' || p_request_id );
525: END IF;
526: EXCEPTION

Line 535: => 'fun.plsql.fun_seq_batch.populate_acct_seq_info.error',

531: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
532: fnd_log.string(
533: log_level => fnd_log.level_error,
534: module
535: => 'fun.plsql.fun_seq_batch.populate_acct_seq_info.error',
536: message => 'p_request_id: ' || p_request_id ||', ' ||
537: 'SQLERRM: ' || SQLERRM);
538: END IF;
539: --

Line 554: => 'fun.plsql.fun_seq_batch.populate_acct_seq_info.exception',

550: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
551: fnd_log.string(
552: log_level => fnd_log.level_exception,
553: module
554: => 'fun.plsql.fun_seq_batch.populate_acct_seq_info.exception',
555: message => 'p_request_id: ' || p_request_id ||', ' ||
556: 'SQLERRM: ' || SQLERRM);
557: END IF;
558: --

Line 599: 'fun.plsql.fun_seq_batch.populate_seq_info.begin',

595: --
596: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
597: FND_LOG.STRING(
598: FND_LOG.LEVEL_PROCEDURE,
599: 'fun.plsql.fun_seq_batch.populate_seq_info.begin',
600: 'Beginning of Populate_Seq_Info');
601: END IF;
602: --
603: -- GL date is the only Sequence Control Date Type

Line 611: -- Bulk Collect Journal Entry Information from fun_seq_batch_gt

607: l_ctrl_date_tbl(1).date_type := 'GL_DATE';
608: -- gl date is populated within the loop
609:
610: --
611: -- Bulk Collect Journal Entry Information from fun_seq_batch_gt
612: --
613: SELECT jh.ledger_id,
614: bg.source_id,
615: jh.actual_flag,

Line 626: FROM fun_seq_batch_gt bg,

622: l_actual_flag_tbl,
623: l_je_source_tbl,
624: l_je_category_tbl,
625: l_gl_date_tbl
626: FROM fun_seq_batch_gt bg,
627: gl_je_headers jh
628: WHERE bg.source_id = jh.je_header_id;
629: --
630: -- Loop for journal entries in fun_seq_batch_gt

Line 630: -- Loop for journal entries in fun_seq_batch_gt

626: FROM fun_seq_batch_gt bg,
627: gl_je_headers jh
628: WHERE bg.source_id = jh.je_header_id;
629: --
630: -- Loop for journal entries in fun_seq_batch_gt
631: --
632: FOR i IN l_je_header_id_tbl.FIRST .. l_je_header_id_tbl.LAST LOOP
633: l_debug_je_header_id := l_je_header_id_tbl(i);
634: --

Line 647: 'fun.plsql.fun_seq_batch.populate_seq_info.config',

643: --
644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(
646: FND_LOG.LEVEL_PROCEDURE,
647: 'fun.plsql.fun_seq_batch.populate_seq_info.config',
648: 'Calling fun_seq.get_assigned_sequence_info... '
649: ||', '||
650: 'l_debug_je_header_id: '
651: || l_debug_je_header_id ||', '||

Line 689: 'fun.plsql.fun_seq_batch.populate_seq_info.config',

685: --
686: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.STRING(
688: FND_LOG.LEVEL_PROCEDURE,
689: 'fun.plsql.fun_seq_batch.populate_seq_info.config',
690: 'Returning from fun_seq.get_assigned_sequence_info... '
691: ||', '||
692: 'l_seq_ver_id_tbl(i): ' || l_seq_ver_id_tbl(i) ||', '||
693: 'l_assign_id_tbl(i): ' || l_assign_id_tbl(i) ||', '||

Line 706: -- [Update GL_JE_HEADERS with the information in FUN_SEQ_BATCH_GT

702: -- Meaning of each Status
703: -- [No action is required]
704: -- NO_ASSIGN_CONTEXT
705: -- NO_ASSIGNMENT
706: -- [Update GL_JE_HEADERS with the information in FUN_SEQ_BATCH_GT
707: -- DO_NOT_SEQUENCE
708: -- SEQ_VER_FOUND
709: -- [Critical Error]
710: -- ENFORCE_NO_ASSIGNMENT

Line 717: -- Bulk Update fun_seq_batch_gt

713: RAISE no_assigned_seq_info;
714: END IF;
715: END LOOP;
716: --
717: -- Bulk Update fun_seq_batch_gt
718: --
719: IF l_assign_id_tbl.COUNT > 0 THEN
720: FORALL i IN l_assign_id_tbl.FIRST .. l_assign_id_tbl.LAST
721: UPDATE fun_seq_batch_gt

Line 721: UPDATE fun_seq_batch_gt

717: -- Bulk Update fun_seq_batch_gt
718: --
719: IF l_assign_id_tbl.COUNT > 0 THEN
720: FORALL i IN l_assign_id_tbl.FIRST .. l_assign_id_tbl.LAST
721: UPDATE fun_seq_batch_gt
722: SET assignment_id = l_assign_id_tbl(i),
723: seq_version_id = l_seq_ver_id_tbl(i),
724: status_code = l_error_code_tbl(i)
725: WHERE source_id = l_je_header_id_tbl(i);

Line 733: 'fun.plsql.fun_seq_batch.populate_seq_info.end',

729: --
730: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
731: FND_LOG.STRING(
732: FND_LOG.LEVEL_PROCEDURE,
733: 'fun.plsql.fun_seq_batch.populate_seq_info.end',
734: 'Populate_Seq_Info completes successfully.');
735: END IF;
736: EXCEPTION
737: WHEN no_assigned_seq_info THEN

Line 752: => 'fun.plsql.fun_seq_batch.populate_seq_info.exception',

748: -- The longer version is stored in the database via FND logging.
749: fnd_log.string (
750: log_level => fnd_log.level_error,
751: module
752: => 'fun.plsql.fun_seq_batch.populate_seq_info.exception',
753: message
754: => 'EXCEPTION: no_assigned_seq_info' || ', ' ||
755: fnd_message.get); -- Retrive mesg from the stack
756: END IF;

Line 772: module => 'fun.plsql.fun_seq_batch.populate_seq_info',

768: --
769: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
770: fnd_log.string(
771: log_level => fnd_log.level_exception,
772: module => 'fun.plsql.fun_seq_batch.populate_seq_info',
773: message => 'SQLERRM: ' || SQLERRM);
774: END IF;
775: --
776: -- Raise Exception

Line 803: 'fun.plsql.fun_seq_batch.populate_numbers.begin',

799: --
800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
801: FND_LOG.STRING(
802: FND_LOG.LEVEL_PROCEDURE,
803: 'fun.plsql.fun_seq_batch.populate_numbers.begin',
804: 'Beginning of populate_numbers');
805: END IF;
806: --
807: -- Bulk Collect Sequence Info. for GL Journal Entries

Line 820: FROM fun_seq_batch_gt bg,

816: BULK COLLECT
817: INTO l_source_id_tbl,
818: l_seq_ver_id_tbl,
819: l_assign_id_tbl
820: FROM fun_seq_batch_gt bg,
821: gl_je_headers jh
822: WHERE jh.je_header_id =bg.source_id and
823: bg.status_code = 'SEQ_VER_FOUND'
824: ORDER BY bg.seq_version_id,

Line 835: FROM fun_seq_batch_gt

831: BULK COLLECT
832: INTO l_source_id_tbl,
833: l_seq_ver_id_tbl,
834: l_assign_id_tbl
835: FROM fun_seq_batch_gt
836: WHERE status_code = 'SEQ_VER_FOUND'
837: ORDER BY seq_version_id,
838: assignment_id;
839: END IF;

Line 851: -- Bulk Update fun_seq_batch_gt

847: p_assign_id_tbl => l_assign_id_tbl,
848: x_seq_value_tbl => l_seq_value_tbl,
849: x_seq_date_tbl => l_seq_date_tbl); -- Not used here
850: --
851: -- Bulk Update fun_seq_batch_gt
852: --
853: IF l_source_id_tbl.COUNT > 0 THEN
854: FORALL i IN l_source_id_tbl.FIRST..l_source_id_tbl.LAST
855: UPDATE fun_seq_batch_gt gt

Line 855: UPDATE fun_seq_batch_gt gt

851: -- Bulk Update fun_seq_batch_gt
852: --
853: IF l_source_id_tbl.COUNT > 0 THEN
854: FORALL i IN l_source_id_tbl.FIRST..l_source_id_tbl.LAST
855: UPDATE fun_seq_batch_gt gt
856: SET gt.seq_version_id = l_seq_ver_id_tbl(i),
857: gt.assignment_id = l_assign_id_tbl(i),
858: gt.seq_value = l_seq_value_tbl(i)
859: WHERE gt.source_id = l_source_id_tbl(i);

Line 867: 'fun.plsql.fun_seq_batch.populate_numbers.end',

863: --
864: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
865: FND_LOG.STRING(
866: FND_LOG.LEVEL_PROCEDURE,
867: 'fun.plsql.fun_seq_batch.populate_numbers.end',
868: 'Populate_numbers completes successfully.');
869: END IF;
870: --
871: -- Return posting date

Line 882: module => 'fun.plsql.fun_seq_batch.populate_numbers.exception',

878: --
879: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
880: fnd_log.string (
881: log_level => fnd_log.level_exception,
882: module => 'fun.plsql.fun_seq_batch.populate_numbers.exception',
883: message => 'SQLERRM: ' || SQLERRM);
884: END IF;
885: --
886: -- Raise Exception

Line 1259: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.begin',

1255: --
1256: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1257: FND_LOG.STRING(
1258: FND_LOG.LEVEL_PROCEDURE,
1259: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.begin',
1260: 'p_request_id => ' || p_request_id );
1261: END IF;
1262:
1263: --

Line 1323: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.config',

1319: --
1320: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1321: FND_LOG.STRING(
1322: FND_LOG.LEVEL_PROCEDURE,
1323: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.config',
1324: 'Before calling fun_seq.get_assigned_sequence_info... '
1325: ||', '||
1326: 'l_debug_ae_header_id: '
1327: || l_debug_ae_header_id ||', '||

Line 1370: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.config',

1366: --
1367: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1368: FND_LOG.STRING(
1369: FND_LOG.LEVEL_PROCEDURE,
1370: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.config',
1371: 'After calling fun_seq.get_assigned_sequence_info... '
1372: ||', '||
1373: 'l_seq_ver_id_tbl(i): ' || l_seq_ver_id_tbl(i) ||', '||
1374: 'l_assign_id_tbl(i): ' || l_assign_id_tbl(i) ||', '||

Line 1461: 'fun.plsql.fun_seq_batchpopulate_acct_seq_prog_view.end',

1457: --
1458: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1459: FND_LOG.STRING(
1460: FND_LOG.LEVEL_PROCEDURE,
1461: 'fun.plsql.fun_seq_batchpopulate_acct_seq_prog_view.end',
1462: 'p_request_id: ' || p_request_id );
1463: END IF;
1464:
1465: EXCEPTION

Line 1473: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view',

1469: --
1470: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1471: fnd_log.string(
1472: fnd_log.level_exception,
1473: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view',
1474: 'p_request_id: ' || p_request_id ||', ' ||
1475: 'ae_header_id: ' || l_debug_ae_header_id|| ', ' ||
1476: 'SQLERRM: ' || SQLERRM);
1477: END IF;

Line 1492: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view',

1488: --
1489: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1490: fnd_log.string(
1491: fnd_log.level_exception,
1492: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view',
1493: 'Unexpected exception in Populate_Acct_Seq_Prog_View' || ', ' ||
1494: 'p_request_id: ' || p_request_id ||', ' ||
1495: 'ae_header_id: ' || l_debug_ae_header_id|| ', ' ||
1496: 'SQLERRM: ' || SQLERRM);

Line 1572: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.begin',

1568: --
1569: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1570: FND_LOG.STRING(
1571: FND_LOG.LEVEL_PROCEDURE,
1572: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.begin',
1573: 'p_request_id => ' || p_request_id );
1574: END IF;
1575:
1576: --

Line 1644: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',

1640: --
1641: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1642: FND_LOG.STRING(
1643: FND_LOG.LEVEL_EVENT,
1644: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1645: 'Before calling fun_seq.get_assigned_sequence_info... '
1646: ||', '||
1647: 'l_debug_ae_header_id: '
1648: || l_debug_ae_header_id ||', '||

Line 1688: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',

1684: --
1685: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1686: FND_LOG.STRING(
1687: FND_LOG.LEVEL_EVENT,
1688: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1689: 'After calling fun_seq.get_assigned_sequence_info... '
1690: ||', '||
1691: 'l_seq_ver_id_tbl(i): ' || l_seq_ver_id_tbl(i) ||', '||
1692: 'l_assign_id_tbl(i): ' || l_assign_id_tbl(i) ||', '||

Line 1740: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',

1736: --
1737: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1738: FND_LOG.STRING(
1739: FND_LOG.LEVEL_STATEMENT,
1740: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1741: 'Before calling Sort_Acct_Entires: Sort Option - ' ||
1742: l_sort_option_code);
1743: END IF;
1744:

Line 1776: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',

1772: --
1773: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1774: FND_LOG.STRING(
1775: FND_LOG.LEVEL_STATEMENT,
1776: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.config',
1777: 'After calling Sort_Acct_Entires');
1778: END IF;
1779:
1780: --

Line 1811: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.end',

1807: --
1808: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1809: FND_LOG.STRING(
1810: FND_LOG.LEVEL_PROCEDURE,
1811: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt.end',
1812: 'p_request_id: ' || p_request_id );
1813: END IF;
1814: EXCEPTION
1815: WHEN no_assigned_seq_info THEN

Line 1822: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',

1818: --
1819: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1820: fnd_log.string(
1821: fnd_log.level_exception,
1822: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',
1823: 'p_request_id: ' || p_request_id ||', ' ||
1824: 'ae_header_id: ' || l_debug_ae_header_id|| ', ' ||
1825: 'SQLERRM: ' || SQLERRM);
1826: END IF;

Line 1852: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',

1848: --
1849: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1850: fnd_log.string(
1851: fnd_log.level_exception,
1852: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',
1853: 'p_request_id: ' || p_request_id || ', ' ||
1854: 'ae_header_id: ' || l_debug_ae_header_id|| ', ' ||
1855: 'sort_option_code: ' || l_sort_option_code || ', ' ||
1856: 'SQLERRM: ' || SQLERRM);

Line 1870: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',

1866: --
1867: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1868: fnd_log.string(
1869: fnd_log.level_exception,
1870: 'fun.plsql.fun_seq_batch.populate_rep_seq_prog_gt',
1871: 'Unexpected exception in populate_rep_seq_prog_gt' || ', ' ||
1872: 'p_request_id: ' || p_request_id ||', ' ||
1873: 'ae_header_id: ' || l_debug_ae_header_id|| ', ' ||
1874: 'SQLERRM: ' || SQLERRM);

Line 1903: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.begin',

1899: --
1900: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1901: FND_LOG.STRING(
1902: FND_LOG.LEVEL_PROCEDURE,
1903: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.begin',
1904: 'p_ae_header_id_tbl.count => ' || p_ae_header_id_tbl.COUNT);
1905: END IF;
1906: --
1907: -- Populate Sequence Info in Table Type

Line 1948: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.config',

1944: --
1945: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1946: FND_LOG.STRING(
1947: FND_LOG.LEVEL_STATEMENT,
1948: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.config',
1949: 'Local temp table has been populated: ' || p_calling_program);
1950: END IF;
1951:
1952: --

Line 1990: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.config',

1986: --
1987: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1988: FND_LOG.STRING(
1989: FND_LOG.LEVEL_STATEMENT,
1990: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.config',
1991: 'Local temp table has been populated: ' || p_calling_program);
1992: END IF;
1993:
1994: --

Line 2021: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.end',

2017: --
2018: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2019: FND_LOG.STRING(
2020: FND_LOG.LEVEL_PROCEDURE,
2021: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.end',
2022: 'p_ae_header_id_tbl.count => ' || p_ae_header_id_tbl.COUNT);
2023: END IF;
2024: EXCEPTION
2025: WHEN OTHERS THEN

Line 2032: module => 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.Exception',

2028: --
2029: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2030: fnd_log.string(
2031: log_level => fnd_log.level_exception,
2032: module => 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.Exception',
2033: message => 'SQLERRM: ' || SQLERRM);
2034: END IF;
2035: app_exception.raise_exception;
2036: END Sort_Acct_Entries;

Line 2037: END fun_seq_batch;

2033: message => 'SQLERRM: ' || SQLERRM);
2034: END IF;
2035: app_exception.raise_exception;
2036: END Sort_Acct_Entries;
2037: END fun_seq_batch;