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.12010000.4 2010/01/18 12:17:35 degoel ship $ */
3: --
4: -- For debuggin
5: --

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

2: /* $Header: funsqbtb.pls 120.43.12010000.4 2010/01/18 12:17:35 degoel ship $ */
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 1260: 'fun.plsql.fun_seq_batch.populate_acct_seq_prog_view.begin',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2051: --
2052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2053: FND_LOG.STRING(
2054: FND_LOG.LEVEL_PROCEDURE,
2055: 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.end',
2056: 'p_ae_header_id_tbl.count => ' || p_ae_header_id_tbl.COUNT);
2057: END IF;
2058: EXCEPTION
2059: WHEN OTHERS THEN

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

2062: --
2063: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2064: fnd_log.string(
2065: log_level => fnd_log.level_exception,
2066: module => 'fun.plsql.fun_seq_batch.Sort_Acct_Entries.Exception',
2067: message => 'SQLERRM: ' || SQLERRM);
2068: END IF;
2069: app_exception.raise_exception;
2070: END Sort_Acct_Entries;

Line 2071: END fun_seq_batch;

2067: message => 'SQLERRM: ' || SQLERRM);
2068: END IF;
2069: app_exception.raise_exception;
2070: END Sort_Acct_Entries;
2071: END fun_seq_batch;