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

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 8: g_sort_option_code fun_seq_contexts.sort_option%TYPE;

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
11: -- *** For XLA Accounting Program ***
12: -- DESCRIPTION:

Line 13: -- Populate Sequencing setup data in fun_seq_request

9: -- PROCEDURE NAME:
10: -- Batch_Init
11: -- *** For XLA Accounting Program ***
12: -- DESCRIPTION:
13: -- Populate Sequencing setup data in fun_seq_request
14: -- This procedure is called from Accounting and Reporting Sequencing
15: -- Program.
16: -- INPUT:
17: -- - p_application_id

Line 51: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;

47: x_status OUT NOCOPY VARCHAR2,
48: x_seq_context_id OUT NOCOPY NUMBER)
49: IS
50: PRAGMA AUTONOMOUS_TRANSACTION;
51: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
52: l_control_date_type fun_seq_contexts.date_type%TYPE;
53: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
54: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
55: l_sequence_type fun_seq_headers.gapless_flag%TYPE;

Line 52: l_control_date_type fun_seq_contexts.date_type%TYPE;

48: x_seq_context_id OUT NOCOPY NUMBER)
49: IS
50: PRAGMA AUTONOMOUS_TRANSACTION;
51: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
52: l_control_date_type fun_seq_contexts.date_type%TYPE;
53: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
54: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
55: l_sequence_type fun_seq_headers.gapless_flag%TYPE;
56:

Line 53: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;

49: IS
50: PRAGMA AUTONOMOUS_TRANSACTION;
51: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
52: l_control_date_type fun_seq_contexts.date_type%TYPE;
53: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
54: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
55: l_sequence_type fun_seq_headers.gapless_flag%TYPE;
56:
57: l_seq_context_found BOOLEAN DEFAULT FALSE;

Line 54: l_sort_option_code fun_seq_contexts.sort_option%TYPE;

50: PRAGMA AUTONOMOUS_TRANSACTION;
51: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
52: l_control_date_type fun_seq_contexts.date_type%TYPE;
53: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
54: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
55: l_sequence_type fun_seq_headers.gapless_flag%TYPE;
56:
57: l_seq_context_found BOOLEAN DEFAULT FALSE;
58: l_module CONSTANT VARCHAR2(100) DEFAULT

Line 55: l_sequence_type fun_seq_headers.gapless_flag%TYPE;

51: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
52: l_control_date_type fun_seq_contexts.date_type%TYPE;
53: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
54: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
55: l_sequence_type fun_seq_headers.gapless_flag%TYPE;
56:
57: l_seq_context_found BOOLEAN DEFAULT FALSE;
58: l_module CONSTANT VARCHAR2(100) DEFAULT
59: g_module || '.' || 'batch_init';

Line 86: fun_seq.get_assign_context_info(

82: -- Retrieve Sequencing Context Information
83: --
84: IF p_context_value_tbl.COUNT > 0 THEN
85: FOR i IN p_context_value_tbl.FIRST .. p_context_value_tbl.LAST LOOP
86: fun_seq.get_assign_context_info(
87: p_context_type => p_context_type,
88: p_context_value => p_context_value_tbl(i),
89: p_application_id => p_application_id,
90: p_table_name => p_table_name,

Line 99: -- Create Sequencing Setup Records in FUN_SEQ_REQUESTS

95: x_req_assign_flag => l_req_assign_flag,
96: x_sort_option_code => l_sort_option_code);
97:
98: --
99: -- Create Sequencing Setup Records in FUN_SEQ_REQUESTS
100: --
101: IF l_seq_context_id IS NOT NULL THEN
102: --
103: -- Make Sequencing Setup pages display only

Line 160: -- Populate Sequencing setup data in fun_seq_request

156:
157: -- PROCEDURE NAME:
158: -- Batch_Init
159: -- DESCRIPTION:
160: -- Populate Sequencing setup data in fun_seq_request
161: -- **** For GL Posting Program ****
162: PROCEDURE Batch_Init(
163: p_request_id IN NUMBER,
164: p_ledgers_tbl IN num15_tbl_type,

Line 169: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;

165: x_ledgers_locked_tbl OUT NOCOPY num15_tbl_type,
166: x_ledgers_locked_cnt OUT NOCOPY NUMBER) IS
167:
168: PRAGMA AUTONOMOUS_TRANSACTION;
169: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
170: l_date_type fun_seq_contexts.date_type%TYPE;
171: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
172: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
173: l_assign_id_tbl assign_id_tbl_type;

Line 170: l_date_type fun_seq_contexts.date_type%TYPE;

166: x_ledgers_locked_cnt OUT NOCOPY NUMBER) IS
167:
168: PRAGMA AUTONOMOUS_TRANSACTION;
169: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
170: l_date_type fun_seq_contexts.date_type%TYPE;
171: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
172: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
173: l_assign_id_tbl assign_id_tbl_type;
174: l_seq_type_tbl seq_type_tbl_type;

Line 171: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;

167:
168: PRAGMA AUTONOMOUS_TRANSACTION;
169: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
170: l_date_type fun_seq_contexts.date_type%TYPE;
171: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
172: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
173: l_assign_id_tbl assign_id_tbl_type;
174: l_seq_type_tbl seq_type_tbl_type;
175: l_seq_head_id_tbl seq_head_id_tbl_type;

Line 172: l_sort_option_code fun_seq_contexts.sort_option%TYPE;

168: PRAGMA AUTONOMOUS_TRANSACTION;
169: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
170: l_date_type fun_seq_contexts.date_type%TYPE;
171: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
172: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
173: l_assign_id_tbl assign_id_tbl_type;
174: l_seq_type_tbl seq_type_tbl_type;
175: l_seq_head_id_tbl seq_head_id_tbl_type;
176:

Line 202: fun_seq.get_assign_context_info(

198: FOR i IN p_ledgers_tbl.FIRST .. p_ledgers_tbl.LAST LOOP
199: --
200: -- Retrieve Sequencing Context Information
201: --
202: fun_seq.get_assign_context_info(
203: p_context_type => 'LEDGER_AND_CURRENCY',
204: p_context_value => p_ledgers_tbl(i),
205: p_application_id => 101,
206: p_table_name => 'GL_JE_HEADERS',

Line 216: -- insert a record into fun_seq_requests.

212: x_sort_option_code => l_sort_option_code);
213:
214: --
215: -- If a valid sequencing context is found,
216: -- insert a record into fun_seq_requests.
217: --
218: IF l_seq_context_id IS NOT NULL THEN
219: populate_seq_requests (
220: p_request_id => p_request_id,

Line 271: -- Unlocks setup data by deleting records from fun_seq_requests

267:
268: --
269: -- Procedure Name: Batch_Exit
270: -- Description:
271: -- Unlocks setup data by deleting records from fun_seq_requests
272: -- The exception in this program is not considered critical.
273: -- So, even if the caller receives 'FAILURE', they should not
274: -- raise an exception.
275: -- INPUT

Line 374: l_current_value fun_seq_versions.current_value%TYPE;

370:
371: l_seq_ver_id_tbl seq_ver_id_tbl_type;
372: l_assign_id_tbl assign_id_tbl_type;
373:
374: l_current_value fun_seq_versions.current_value%TYPE;
375: l_sequenced_date DATE;
376: l_error_code VARCHAR2(30);
377:
378: l_module CONSTANT VARCHAR2(100) DEFAULT

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 414: fun_seq.generate_sequence_number(

410: IF (ind_prior IS NULL) OR
411: (l_assign_id_tbl(ind_prior) <> l_assign_id_tbl(i) OR
412: l_seq_ver_id_tbl(ind_prior) <> l_seq_ver_id_tbl(i))
413: THEN
414: fun_seq.generate_sequence_number(
415: p_assignment_id => l_assign_id_tbl(i),
416: p_seq_version_id => l_seq_ver_id_tbl(i),
417: p_sequence_type => 'G',
418: p_request_id => NVL(p_request_id,-99),

Line 447: UPDATE fun_seq_versions

443: THEN
444: --
445: -- Update the current_value
446: --
447: UPDATE fun_seq_versions
448: SET current_value = l_current_value
449: WHERE seq_version_id = l_seq_ver_id_tbl(i);
450: END IF; -- Update the Last Used Number or Not
451: END IF; -- Call Generate Sequence Number or Not

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 542: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_ASSGN_FOUND');

538: END IF;
539: --
540: -- Raise Exception
541: --
542: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_ASSGN_FOUND');
543: fnd_message.set_token ('SEQ_CONTEXT_NAME',
544: fun_seq.get_seq_context_name(null));
545: app_exception.raise_exception;
546: WHEN OTHERS THEN

Line 544: fun_seq.get_seq_context_name(null));

540: -- Raise Exception
541: --
542: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_ASSGN_FOUND');
543: fnd_message.set_token ('SEQ_CONTEXT_NAME',
544: fun_seq.get_seq_context_name(null));
545: app_exception.raise_exception;
546: WHEN OTHERS THEN
547: --
548: -- Logging

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 577: l_ctrl_attr_rec fun_seq.control_attribute_rec_type;

573: l_je_source_tbl je_source_tbl_type;
574: l_je_category_tbl je_category_tbl_type;
575: l_gl_date_tbl date_tbl_type;
576:
577: l_ctrl_attr_rec fun_seq.control_attribute_rec_type;
578: l_ctrl_date_tbl fun_seq.control_date_tbl_type
579: := fun_seq.control_date_tbl_type();
580:
581: l_seq_ver_id_tbl seq_ver_id_tbl_type;

Line 578: l_ctrl_date_tbl fun_seq.control_date_tbl_type

574: l_je_category_tbl je_category_tbl_type;
575: l_gl_date_tbl date_tbl_type;
576:
577: l_ctrl_attr_rec fun_seq.control_attribute_rec_type;
578: l_ctrl_date_tbl fun_seq.control_date_tbl_type
579: := fun_seq.control_date_tbl_type();
580:
581: l_seq_ver_id_tbl seq_ver_id_tbl_type;
582: l_assign_id_tbl assign_id_tbl_type;

Line 579: := fun_seq.control_date_tbl_type();

575: l_gl_date_tbl date_tbl_type;
576:
577: l_ctrl_attr_rec fun_seq.control_attribute_rec_type;
578: l_ctrl_date_tbl fun_seq.control_date_tbl_type
579: := fun_seq.control_date_tbl_type();
580:
581: l_seq_ver_id_tbl seq_ver_id_tbl_type;
582: l_assign_id_tbl assign_id_tbl_type;
583: l_out_ctrl_dt_tbl date_tbl_type;

Line 588: l_dummy fun_seq_headers.gapless_flag%TYPE;

584: l_req_assign_flag_tbl req_assign_flag_tbl_type;
585: l_error_code_tbl error_code_tbl_type;
586: l_dummy_tbl vc30_tbl_type; -- For Sort Option
587:
588: l_dummy fun_seq_headers.gapless_flag%TYPE;
589: no_assigned_seq_info EXCEPTION;
590:
591: l_debug_je_header_id NUMBER;
592: BEGIN

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 648: 'Calling fun_seq.get_assigned_sequence_info... '

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 ||', '||
652: 'l_ctrl_date_tbl(1).date_value (GL_DATE): '

Line 665: fun_seq.get_assigned_sequence_info(

661: END IF;
662: --
663: -- Get Sequencing Context and Assignment Information
664: --
665: fun_seq.get_assigned_sequence_info(
666: p_context_type => 'LEDGER_AND_CURRENCY',
667: p_context_value => l_ledger_id_tbl(i),
668: p_application_Id => 101,
669: p_table_name => 'GL_JE_HEADERS',

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 690: 'Returning from fun_seq.get_assigned_sequence_info... '

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) ||', '||
694: 'l_out_ctrl_dt_tbl(i): '|| l_out_ctrl_dt_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 742: -- Retrieve FUN_SEQ_NO_ACTIVE_ASSGN_FOUND from the message stack

738: --
739: -- Logging
740: --
741: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
742: -- Retrieve FUN_SEQ_NO_ACTIVE_ASSGN_FOUND from the message stack
743: -- and clear the message from the message stack.
744: -- See fun_seq.get_assigned_seq_info.
745: -- This is necessary to use the shorter version of the message
746: -- for concurrent program logs of posting program. Message text

Line 744: -- See fun_seq.get_assigned_seq_info.

740: --
741: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
742: -- Retrieve FUN_SEQ_NO_ACTIVE_ASSGN_FOUND from the message stack
743: -- and clear the message from the message stack.
744: -- See fun_seq.get_assigned_seq_info.
745: -- This is necessary to use the shorter version of the message
746: -- for concurrent program logs of posting program. Message text
747: -- longer than 70 chars is not allowed in Pro*C code.
748: -- The longer version is stored in the database via FND logging.

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 760: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_ASSGN_SHORT');

756: END IF;
757: --
758: -- Set the shorter version of the error message on the stack
759: --
760: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_ASSGN_SHORT');
761: --
762: -- Raise Exception
763: --
764: app_exception.raise_exception;

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 913: -- fun_seq_requests

909: --
910: fnd_file.put_line(fnd_file.log, 'Starting Release_Lock... ');
911: --
912: -- If p_request_id is null, delete all complete requests from
913: -- fun_seq_requests
914: --
915: delete_seq_requests(p_request_id => p_request_id);
916: --
917: -- Populate Return Values 'SUCCESS'

Line 953: -- Populate Sequencing Context in Fun_Seq_Requests

949: l_module CONSTANT VARCHAR2(100) DEFAULT
950: g_module || '.' || 'populate_seq_requests';
951: BEGIN
952: --
953: -- Populate Sequencing Context in Fun_Seq_Requests
954: --
955: Populate_Seq_Context (
956: p_request_id => p_request_id,
957: p_seq_context_id => p_seq_context_id);

Line 960: -- Populate Sequence Headers in Fun_Seq_Requests

956: p_request_id => p_request_id,
957: p_seq_context_id => p_seq_context_id);
958:
959: --
960: -- Populate Sequence Headers in Fun_Seq_Requests
961: --
962: Populate_Seq_Headers (
963: p_request_id => p_request_id,
964: p_Seq_Context_Id => p_seq_context_id);

Line 997: INSERT INTO fun_seq_requests (

993: BEGIN
994: l_user_id := fnd_global.user_id;
995: l_login_id := fnd_global.login_id;
996:
997: INSERT INTO fun_seq_requests (
998: request_id,
999: source_type,
1000: source_id,
1001: last_update_date,

Line 1052: FROM fun_seq_assignments sa

1048:
1049: SELECT sa.seq_header_id
1050: BULK COLLECT
1051: INTO l_seq_headers
1052: FROM fun_seq_assignments sa
1053: WHERE sa.seq_context_id = p_seq_context_id
1054: AND sa.use_status_code IN ('NEW','USED');
1055:
1056: IF l_seq_headers.COUNT > 0 THEN

Line 1058: INSERT INTO fun_seq_requests(

1054: AND sa.use_status_code IN ('NEW','USED');
1055:
1056: IF l_seq_headers.COUNT > 0 THEN
1057: FORALL i IN l_seq_headers.FIRST .. l_seq_headers.LAST
1058: INSERT INTO fun_seq_requests(
1059: request_id,
1060: source_type,
1061: source_id,
1062: last_update_date,

Line 1118: -- Bulk collect request ids in fun_seq_requests

1114: pragma exception_init(more_rows, -1422);
1115:
1116: BEGIN
1117: --
1118: -- Bulk collect request ids in fun_seq_requests
1119: --
1120: IF p_request_id IS NULL THEN
1121: SELECT request_id
1122: BULK COLLECT

Line 1124: FROM fun_seq_requests;

1120: IF p_request_id IS NULL THEN
1121: SELECT request_id
1122: BULK COLLECT
1123: INTO l_req_id_tbl
1124: FROM fun_seq_requests;
1125: ELSE
1126:
1127: begin
1128: --

Line 1135: delete from fun_seq_requests where request_id=p_request_id;

1131: select distinct phase_code into l_phase_code from fnd_concurrent_requests
1132: where parent_request_id= p_request_id;
1133: -- all childs completed
1134: if l_phase_code ='C' then
1135: delete from fun_seq_requests where request_id=p_request_id;
1136: -- childs may be pending or paused ..
1137: else
1138: null; -- do not release the lock
1139: end if;

Line 1143: delete from fun_seq_requests where request_id=p_request_id;

1139: end if;
1140: EXCEPTION
1141: -- this is not a parent request
1142: WHEN NO_DATA_FOUND THEN
1143: delete from fun_seq_requests where request_id=p_request_id;
1144: -- all child are not completed yet
1145: WHEN more_rows THEN
1146: null;
1147: end;

Line 1179: FROM fun_seq_requests

1175: --
1176: IF l_comp_req_id_tbl.COUNT > 0 THEN
1177: FORALL i IN l_comp_req_id_tbl.FIRST .. l_comp_req_id_tbl.LAST
1178: DELETE
1179: FROM fun_seq_requests
1180: WHERE request_id = l_comp_req_id_tbl(i);
1181: END IF;
1182: END IF;
1183:

Line 1223: l_ctrl_attr_rec fun_seq.control_attribute_rec_type;

1219: l_out_ctrl_dt_tbl date_tbl_type;
1220: l_req_assign_flag_tbl req_assign_flag_tbl_type;
1221: l_error_code_tbl error_code_tbl_type;
1222:
1223: l_ctrl_attr_rec fun_seq.control_attribute_rec_type;
1224: l_ctrl_date_tbl fun_seq.control_date_tbl_type
1225: := fun_seq.control_date_tbl_type();
1226:
1227: --

Line 1224: l_ctrl_date_tbl fun_seq.control_date_tbl_type

1220: l_req_assign_flag_tbl req_assign_flag_tbl_type;
1221: l_error_code_tbl error_code_tbl_type;
1222:
1223: l_ctrl_attr_rec fun_seq.control_attribute_rec_type;
1224: l_ctrl_date_tbl fun_seq.control_date_tbl_type
1225: := fun_seq.control_date_tbl_type();
1226:
1227: --
1228: -- Values to be stored in XLA View

Line 1225: := fun_seq.control_date_tbl_type();

1221: l_error_code_tbl error_code_tbl_type;
1222:
1223: l_ctrl_attr_rec fun_seq.control_attribute_rec_type;
1224: l_ctrl_date_tbl fun_seq.control_date_tbl_type
1225: := fun_seq.control_date_tbl_type();
1226:
1227: --
1228: -- Values to be stored in XLA View
1229: --

Line 1244: l_dummy fun_seq_headers.gapless_flag%TYPE;

1240: l_sorted_seq_value_tbl seq_value_tbl_type;
1241:
1242: l_sorted_seq_date_tbl date_tbl_type;
1243:
1244: l_dummy fun_seq_headers.gapless_flag%TYPE;
1245: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
1246: l_date_dummy_tbl date_tbl_type; -- For Sorting Key
1247:
1248: no_assigned_seq_info EXCEPTION;

Line 1245: l_sort_option_code fun_seq_contexts.sort_option%TYPE;

1241:
1242: l_sorted_seq_date_tbl date_tbl_type;
1243:
1244: l_dummy fun_seq_headers.gapless_flag%TYPE;
1245: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
1246: l_date_dummy_tbl date_tbl_type; -- For Sorting Key
1247:
1248: no_assigned_seq_info EXCEPTION;
1249: j BINARY_INTEGER DEFAULT 1;

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 1324: 'Before calling fun_seq.get_assigned_sequence_info... '

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 ||', '||
1328: 'l_ctrl_date_tbl(1).date_value: '

Line 1347: fun_seq.get_assigned_sequence_info(

1343: END IF;
1344: --
1345: -- Get Assignment and Version
1346: --
1347: fun_seq.get_assigned_sequence_info(
1348: p_context_type => 'LEDGER_AND_CURRENCY',
1349: p_context_value => l_ledger_id_tbl(i),
1350: p_application_Id => 602,
1351: p_table_name => 'XLA_AE_HEADERS',

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 1371: 'After calling fun_seq.get_assigned_sequence_info... '

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) ||', '||
1375: 'l_out_ctrl_dt_tbl(i): '|| l_out_ctrl_dt_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 1481: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_ASSGN_FOUND');

1477: END IF;
1478: --
1479: -- Raise Exception
1480: --
1481: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_ASSGN_FOUND');
1482: fnd_message.set_token ('SEQ_CONTEXT_NAME',
1483: fun_seq.get_seq_context_name(null));
1484: app_exception.raise_exception;
1485: WHEN OTHERS THEN

Line 1483: fun_seq.get_seq_context_name(null));

1479: -- Raise Exception
1480: --
1481: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_ASSGN_FOUND');
1482: fnd_message.set_token ('SEQ_CONTEXT_NAME',
1483: fun_seq.get_seq_context_name(null));
1484: app_exception.raise_exception;
1485: WHEN OTHERS THEN
1486: --
1487: -- Logging

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 1519: l_ctrl_attr_rec fun_seq.control_attribute_rec_type;

1515: l_gl_date_tbl date_tbl_type;
1516: l_reference_date_tbl date_tbl_type;
1517: l_completion_date_tbl date_tbl_type; -- Completion /Posted Date
1518:
1519: l_ctrl_attr_rec fun_seq.control_attribute_rec_type;
1520: l_ctrl_date_tbl fun_seq.control_date_tbl_type
1521: := fun_seq.control_date_tbl_type();
1522:
1523: --

Line 1520: l_ctrl_date_tbl fun_seq.control_date_tbl_type

1516: l_reference_date_tbl date_tbl_type;
1517: l_completion_date_tbl date_tbl_type; -- Completion /Posted Date
1518:
1519: l_ctrl_attr_rec fun_seq.control_attribute_rec_type;
1520: l_ctrl_date_tbl fun_seq.control_date_tbl_type
1521: := fun_seq.control_date_tbl_type();
1522:
1523: --
1524: -- Values to be stored in the XLA Temporary Table

Line 1521: := fun_seq.control_date_tbl_type();

1517: l_completion_date_tbl date_tbl_type; -- Completion /Posted Date
1518:
1519: l_ctrl_attr_rec fun_seq.control_attribute_rec_type;
1520: l_ctrl_date_tbl fun_seq.control_date_tbl_type
1521: := fun_seq.control_date_tbl_type();
1522:
1523: --
1524: -- Values to be stored in the XLA Temporary Table
1525: --

Line 1542: l_sort_option_code fun_seq_contexts.sort_option%TYPE;

1538: l_req_assign_flag_tbl req_assign_flag_tbl_type;
1539: l_sorting_key_tbl date_tbl_type;
1540: l_error_code_tbl error_code_tbl_type;
1541:
1542: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
1543: l_dummy fun_seq_headers.gapless_flag%TYPE;
1544:
1545: l_sorted_application_id_tbl num_tbl_type;
1546: l_sorted_ae_header_id_tbl ae_header_id_tbl_type;

Line 1543: l_dummy fun_seq_headers.gapless_flag%TYPE;

1539: l_sorting_key_tbl date_tbl_type;
1540: l_error_code_tbl error_code_tbl_type;
1541:
1542: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
1543: l_dummy fun_seq_headers.gapless_flag%TYPE;
1544:
1545: l_sorted_application_id_tbl num_tbl_type;
1546: l_sorted_ae_header_id_tbl ae_header_id_tbl_type;
1547: l_sorted_seq_ver_id_tbl seq_ver_id_tbl_type;

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 1645: 'Before calling fun_seq.get_assigned_sequence_info... '

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 ||', '||
1649: 'l_ctrl_date_tbl(1).date_value: '

Line 1664: fun_seq.get_assigned_sequence_info(

1660: --
1661: -- Sorting options of sequencing contexts are identical
1662: -- within the temporary table.
1663: --
1664: fun_seq.get_assigned_sequence_info(
1665: p_context_type => 'LEDGER_AND_CURRENCY',
1666: p_context_value => l_ledger_id_tbl(i),
1667: p_application_id => l_application_id_tbl(i),
1668: p_table_name => l_table_name_tbl(i),

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 1689: 'After calling fun_seq.get_assigned_sequence_info... '

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) ||', '||
1693: 'l_out_ctrl_dt_tbl(i): '|| l_out_ctrl_dt_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 1830: FROM fun_seq_contexts WHERE

1826: END IF;
1827:
1828: SELECT name
1829: INTO l_context_name
1830: FROM fun_seq_contexts WHERE
1831: context_type=l_context_type AND
1832: context_value=l_context_value AND
1833: application_id=l_application_id AND
1834: table_name=l_table_name AND

Line 1840: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_ASSGN_FOUND');

1836:
1837: --
1838: -- Raise Exception
1839: --
1840: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_ASSGN_FOUND');
1841: fnd_message.set_token ('SEQ_CONTEXT_NAME',l_context_name);
1842:
1843: app_exception.raise_exception;
1844:

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 1893: l_temp_tab fun_seq_bt_tbl_type;

1889: x_ae_header_id_tbl OUT NOCOPY ae_header_id_tbl_type,
1890: x_assign_id_tbl OUT NOCOPY assign_id_tbl_type,
1891: x_seq_ver_id_tbl OUT NOCOPY seq_ver_id_tbl_type) IS
1892:
1893: l_temp_tab fun_seq_bt_tbl_type;
1894:
1895: BEGIN
1896: l_temp_tab := fun_seq_bt_tbl_type();
1897: --

Line 1896: l_temp_tab := fun_seq_bt_tbl_type();

1892:
1893: l_temp_tab fun_seq_bt_tbl_type;
1894:
1895: BEGIN
1896: l_temp_tab := fun_seq_bt_tbl_type();
1897: --
1898: -- Debug Information
1899: --
1900: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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 1922: fun_seq_bt_obj_type(

1918: -- bug# 5373090 - Italian requirement
1919: FOR i IN p_ae_header_id_tbl.FIRST .. p_ae_header_id_tbl.LAST LOOP
1920: l_temp_tab.EXTEND;
1921: l_temp_tab(i) :=
1922: fun_seq_bt_obj_type(
1923: NULL, -- Application Id for Reporting Sequencing
1924: p_ae_header_id_tbl(i),
1925: p_assign_id_tbl(i),
1926: p_seq_ver_id_tbl(i),

Line 1933: fun_seq_bt_obj_type(

1929: ELSE
1930: FOR i IN p_ae_header_id_tbl.FIRST .. p_ae_header_id_tbl.LAST LOOP
1931: l_temp_tab.EXTEND;
1932: l_temp_tab(i) :=
1933: fun_seq_bt_obj_type(
1934: NULL, -- Application Id for Reporting Sequencing
1935: p_ae_header_id_tbl(i),
1936: p_assign_id_tbl(i),
1937: p_seq_ver_id_tbl(i),

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 1963: FROM THE (SELECT CAST( l_temp_tab as fun_seq_bt_tbl_type)

1959: BULK COLLECT
1960: INTO x_ae_header_id_tbl,
1961: x_assign_id_tbl,
1962: x_seq_ver_id_tbl
1963: FROM THE (SELECT CAST( l_temp_tab as fun_seq_bt_tbl_type)
1964: FROM dual ) sqtmp
1965: ORDER BY
1966: sqtmp.seq_version_id,
1967: sqtmp.sorting_key;

Line 1976: fun_seq_bt_obj_type(

1972: --
1973: FOR i IN p_ae_header_id_tbl.FIRST .. p_ae_header_id_tbl.LAST LOOP
1974: l_temp_tab.EXTEND;
1975: l_temp_tab(i) :=
1976: fun_seq_bt_obj_type(
1977: p_application_id_tbl(i),
1978: p_ae_header_id_tbl(i),
1979: p_assign_id_tbl(i),
1980: p_seq_ver_id_tbl(i),

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 2006: FROM THE (SELECT CAST( l_temp_tab as fun_seq_bt_tbl_type)

2002: INTO x_application_id_tbl,
2003: x_ae_header_id_tbl,
2004: x_assign_id_tbl,
2005: x_seq_ver_id_tbl
2006: FROM THE (SELECT CAST( l_temp_tab as fun_seq_bt_tbl_type)
2007: FROM dual ) sqtmp
2008: ORDER BY
2009: sqtmp.seq_version_id,
2010: sqtmp.sorting_key;

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;