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.XLA_TRANSFER_PKG dependencies on GL_BC_PACKETS

Line 377: This function inserts data in gl_bc_packets and on success

373:
374: --Added for bug 11855000 Start
375: /*----------------------------------------------------------------------
376: Function Reserve_funds
377: This function inserts data in gl_bc_packets and on success
378: returns a positive packet_id.
379: */----------------------------------------------------------------------
380:
381: FUNCTION reserve_funds

Line 393: SELECT gl_bc_packets_s.NEXTVAL

389: FROM dual;
390:
391:
392: CURSOR c_get_packet_id IS
393: SELECT gl_bc_packets_s.NEXTVAL
394: FROM dual;
395:
396: --local Variables
397: l_log_module VARCHAR2(240);

Line 442: fnd_message.set_token('SEQUENCE', 'GL_BC_PACKETS_S');

438: else
439: CLOSE c_get_arrival_seq;
440: l_packet_id := -1;
441: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
442: fnd_message.set_token('SEQUENCE', 'GL_BC_PACKETS_S');
443: app_exception.raise_exception;
444: END IF;
445:
446: --

Line 463: -- Insert data into gl_bc_packets

459: ,l_log_module);
460: END IF;
461:
462: --
463: -- Insert data into gl_bc_packets
464: --
465: FOR i in g_ledger_id_tab.FIRST..g_ledger_id_tab.LAST
466: loop
467:

Line 486: insert into gl_bc_packets

482: ,l_log_module);
483: END IF;
484:
485: if g_budgetary_control_flag = 'Y' AND l_ledger_category <> 'ALC' then
486: insert into gl_bc_packets
487: (PACKET_ID
488: ,APPLICATION_ID
489: ,LEDGER_ID
490: ,JE_SOURCE_NAME

Line 629: select 1 from gl_bc_packets glc

625: and xah.funds_status_code is null
626: and xah.balance_type_code in ('A', 'E')
627: and exists
628: (
629: select 1 from gl_bc_packets glc
630: where glc.group_id = xah.group_id
631: and glc.ae_header_id = xah.ae_header_id
632: and glc.packet_id = l_packet_id
633: and glc.event_id = xah.event_id

Line 644: UPDATE gl_bc_packets bp

640: ,C_LEVEL_STATEMENT
641: ,l_log_module);
642: END IF;
643: --update the funding budget version_id
644: UPDATE gl_bc_packets bp
645: SET bp.funding_budget_version_id =
646: (SELECT DECODE(pk.actual_flag, 'B', pk.budget_version_id, bo.funding_budget_version_id)
647: FROM gl_budget_assignments ba,
648: gl_budgets b ,

Line 651: gl_bc_packets pk ,

647: FROM gl_budget_assignments ba,
648: gl_budgets b ,
649: gl_budget_versions bv ,
650: gl_period_statuses ps ,
651: gl_bc_packets pk ,
652: gl_budorg_bc_options bo
653: WHERE ba.ledger_id(+) = g_ledger_id_tab(i)
654: AND ba.currency_code(+) = DECODE(PK.currency_code, 'STAT', 'STAT', pk.currency_code)
655: AND ba.code_combination_id (+) = PK.code_combination_id

Line 691: trace('No of rows updated in GL_BC_PACKETS with funding_budget_version_id = ' || SQL%ROWCOUNT

687: AND bp.funding_budget_version_id IS NULL
688: ;
689:
690: IF (C_LEVEL_EVENT >= g_log_level) THEN
691: trace('No of rows updated in GL_BC_PACKETS with funding_budget_version_id = ' || SQL%ROWCOUNT
692: ,C_LEVEL_STATEMENT
693: ,l_log_module);
694: END IF;
695: else

Line 709: fnd_message.set_token('SEQUENCE', 'GL_BC_PACKETS_S');

705: ELSE
706: CLOSE c_get_packet_id;
707: l_packet_id := -1;
708: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
709: fnd_message.set_token('SEQUENCE', 'GL_BC_PACKETS_S');
710: app_exception.raise_exception;
711: END IF;
712:
713: RETURN l_packet_id;

Line 1515: -- Delete rows from gl_bc_packets and update gl_interface control with packet_id as -1

1511:
1512: IF (g_group_id_tab.COUNT > 0) THEN
1513: --Added for bug 11855000 Start
1514: --
1515: -- Delete rows from gl_bc_packets and update gl_interface control with packet_id as -1
1516: --
1517: IF g_application_id = 200 THEN
1518:
1519: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST

Line 1526: select 1 from gl_bc_packets glc

1522: where group_id = g_group_id_tab(i)
1523: and funds_status_code = 'S'
1524: and exists
1525: (
1526: select 1 from gl_bc_packets glc
1527: where glc.group_id = xah.group_id
1528: and glc.ae_header_id = xah.ae_header_id
1529: and glc.event_id = xah.event_id
1530: and glc.application_id = xah.application_id

Line 1542: (select packet_id from gl_bc_packets

1538:
1539: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1540: DELETE gl_bc_packet_arrival_order
1541: where packet_id in
1542: (select packet_id from gl_bc_packets
1543: WHERE group_id = g_group_id_tab(i)
1544: and status_code = 'C')
1545: ;
1546:

Line 1552: DELETE gl_bc_packets

1548: trace(SQL%ROWCOUNT || 'Rows deleted from the gl_bc_packet_arrival_order in recover_batch',C_LEVEL_STATEMENT,l_log_module);
1549: END IF;
1550:
1551: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1552: DELETE gl_bc_packets
1553: WHERE group_id = g_group_id_tab(i)
1554: and status_code = 'C'
1555: ;
1556:

Line 1558: trace(SQL%ROWCOUNT || 'Rows deleted from the gl_bc_packets in recover_batch',C_LEVEL_STATEMENT,l_log_module);

1554: and status_code = 'C'
1555: ;
1556:
1557: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1558: trace(SQL%ROWCOUNT || 'Rows deleted from the gl_bc_packets in recover_batch',C_LEVEL_STATEMENT,l_log_module);
1559: END IF;
1560: ELSE
1561: trace('Funds check performed only for application_id 200. Provided application_id is '||g_application_id,C_LEVEL_STATEMENT,l_log_module);
1562: end if;

Line 3197: Need to update gl_bc_packets here because when GL posting happens,

3193: END IF;
3194:
3195: --Added for bug 11855000 Start
3196: /*
3197: Need to update gl_bc_packets here because when GL posting happens,
3198: data from gl_bc_packets gets flushed. Hence we update the
3199: gl_bc_packets as funds reserved and then call keep_batches
3200: where gl posting happens if customer has provided
3201: post_to_gl parameter as Yes.

Line 3198: data from gl_bc_packets gets flushed. Hence we update the

3194:
3195: --Added for bug 11855000 Start
3196: /*
3197: Need to update gl_bc_packets here because when GL posting happens,
3198: data from gl_bc_packets gets flushed. Hence we update the
3199: gl_bc_packets as funds reserved and then call keep_batches
3200: where gl posting happens if customer has provided
3201: post_to_gl parameter as Yes.
3202: */

Line 3199: gl_bc_packets as funds reserved and then call keep_batches

3195: --Added for bug 11855000 Start
3196: /*
3197: Need to update gl_bc_packets here because when GL posting happens,
3198: data from gl_bc_packets gets flushed. Hence we update the
3199: gl_bc_packets as funds reserved and then call keep_batches
3200: where gl posting happens if customer has provided
3201: post_to_gl parameter as Yes.
3202: */
3203:

Line 3208: trace('Updating gl_bc_packets ',C_LEVEL_STATEMENT,l_log_module);

3204: IF g_application_id = 200 then
3205:
3206: If (g_reserve_flag) then
3207: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3208: trace('Updating gl_bc_packets ',C_LEVEL_STATEMENT,l_log_module);
3209: END IF;
3210: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
3211: UPDATE gl_bc_packets
3212: SET status_code = 'A'

Line 3211: UPDATE gl_bc_packets

3207: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3208: trace('Updating gl_bc_packets ',C_LEVEL_STATEMENT,l_log_module);
3209: END IF;
3210: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
3211: UPDATE gl_bc_packets
3212: SET status_code = 'A'
3213: , result_code = 'P01'
3214: WHERE group_id = g_group_id_tab(i)
3215: AND application_id = g_application_id

Line 3219: trace('No of rows updated as Reserved in GL_BC_PACKETS ='||SQL%ROWCOUNT,C_LEVEL_PROCEDURE,l_log_module);

3215: AND application_id = g_application_id
3216: and status_code = 'C';
3217:
3218: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3219: trace('No of rows updated as Reserved in GL_BC_PACKETS ='||SQL%ROWCOUNT,C_LEVEL_PROCEDURE,l_log_module);
3220: END IF;
3221: end if;
3222: ELSE
3223: trace('Funds check performed only for application_id 200. Provided application_id is '||g_application_id,C_LEVEL_STATEMENT,l_log_module);

Line 3831: Need to update gl_bc_packets here because Journal import is disabled

3827: trace('Journal Import is Disabled',C_LEVEL_STATEMENT,l_log_module);
3828: set_transfer_status;
3829: --Added for bug 11855000 Start
3830: /*
3831: Need to update gl_bc_packets here because Journal import is disabled
3832: and funds in gl bc packets needs to be marked as reserved.
3833: */
3834:
3835: IF g_application_id = 200 then

Line 3832: and funds in gl bc packets needs to be marked as reserved.

3828: set_transfer_status;
3829: --Added for bug 11855000 Start
3830: /*
3831: Need to update gl_bc_packets here because Journal import is disabled
3832: and funds in gl bc packets needs to be marked as reserved.
3833: */
3834:
3835: IF g_application_id = 200 then
3836: If (g_reserve_flag) then

Line 3838: trace('Updating gl_bc_packets ',C_LEVEL_STATEMENT,l_log_module);

3834:
3835: IF g_application_id = 200 then
3836: If (g_reserve_flag) then
3837: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3838: trace('Updating gl_bc_packets ',C_LEVEL_STATEMENT,l_log_module);
3839: END IF;
3840: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
3841: UPDATE gl_bc_packets
3842: SET status_code = 'A'

Line 3841: UPDATE gl_bc_packets

3837: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3838: trace('Updating gl_bc_packets ',C_LEVEL_STATEMENT,l_log_module);
3839: END IF;
3840: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
3841: UPDATE gl_bc_packets
3842: SET status_code = 'A'
3843: WHERE group_id = g_group_id_tab(i)
3844: AND application_id = g_application_id
3845: and status_code = 'C';

Line 3848: trace('No of rows updated as Reserved in GL_BC_PACKETS ='||SQL%ROWCOUNT,C_LEVEL_PROCEDURE,l_log_module);

3844: AND application_id = g_application_id
3845: and status_code = 'C';
3846:
3847: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3848: trace('No of rows updated as Reserved in GL_BC_PACKETS ='||SQL%ROWCOUNT,C_LEVEL_PROCEDURE,l_log_module);
3849: END IF;
3850: END IF;
3851: ELSE
3852: trace('Funds check performed only for application_id 200. Provided application_id is '||g_application_id,C_LEVEL_STATEMENT,l_log_module);