DBA Data[Home] [Help]

APPS.JL_CMERGE dependencies on JL_CMERGE

Line 1: PACKAGE BODY jl_cmerge AS

1: PACKAGE BODY jl_cmerge AS
2: /* $Header: jlzzmrgb.pls 120.5.12010000.2 2009/04/21 10:16:59 nivnaray ship $ */
3:
4: -----------------------Private Variables------------------------------------
5: g_count NUMBER :=0;

Line 643: arp_message.set_line ('JL_CMERGE.JL_BR_JOURNALS_UPD()+');

639: l_count NUMBER;
640:
641: BEGIN
642:
643: arp_message.set_line ('JL_CMERGE.JL_BR_JOURNALS_UPD()+');
644:
645: IF (process_mode = 'LOCK' ) THEN
646: arp_message.set_name ('AR', 'AR_LOCKING_TABLE');
647: arp_message.set_token ('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);

Line 799: arp_message.set_line('JL_CMERGE.JL_BR_JOURNALS_UPD()-');

795: arp_message.set_name ('AR','AR_ROWS_UPDATED');
796: arp_message.set_token ('NUM_ROWS', to_char(l_count) );
797:
798: END IF ;
799: arp_message.set_line('JL_CMERGE.JL_BR_JOURNALS_UPD()-');
800:
801: EXCEPTION
802: WHEN OTHERS THEN
803: arp_message.set_error ('JL_CMERGE.JL_BR_JOURNALS_UPD');

Line 803: arp_message.set_error ('JL_CMERGE.JL_BR_JOURNALS_UPD');

799: arp_message.set_line('JL_CMERGE.JL_BR_JOURNALS_UPD()-');
800:
801: EXCEPTION
802: WHEN OTHERS THEN
803: arp_message.set_error ('JL_CMERGE.JL_BR_JOURNALS_UPD');
804: RAISE;
805: END jl_br_journals_upd;
806:
807:

Line 1528: arp_message.set_line ('JL_CMERGE.JL_BR_BALANCES_UPD()+');

1524: END BALANCES;
1525:
1526: BEGIN
1527:
1528: arp_message.set_line ('JL_CMERGE.JL_BR_BALANCES_UPD()+');
1529:
1530: IF (process_mode = 'LOCK' ) THEN
1531: arp_message.set_name ('AR', 'AR_LOCKING_TABLE');
1532: arp_message.set_token ('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);

Line 1678: arp_message.set_line('JL_CMERGE.JL_BR_BALANCES_UPD()-');

1674: -- now in the merged customer.
1675: Balances;
1676:
1677: END IF ;
1678: arp_message.set_line('JL_CMERGE.JL_BR_BALANCES_UPD()-');
1679:
1680: EXCEPTION
1681: WHEN OTHERS THEN
1682: arp_message.set_error ('JL_CMERGE.JL_BR_BALANCES_UPD');

Line 1682: arp_message.set_error ('JL_CMERGE.JL_BR_BALANCES_UPD');

1678: arp_message.set_line('JL_CMERGE.JL_BR_BALANCES_UPD()-');
1679:
1680: EXCEPTION
1681: WHEN OTHERS THEN
1682: arp_message.set_error ('JL_CMERGE.JL_BR_BALANCES_UPD');
1683: RAISE;
1684: END jl_br_balances_upd ;
1685:
1686:

Line 1720: arp_message.set_line ('JL_CMERGE.MERGE()+');

1716: return;
1717: end if;
1718:
1719:
1720: arp_message.set_line ('JL_CMERGE.MERGE()+');
1721: jl_br_bank_rtrn_upd (req_id, set_num, process_mode);
1722: jl_br_occ_doc_upd (req_id, set_num, process_mode);
1723: jl_br_pay_sch_upd (req_id,set_num,process_mode);
1724: jl_zz_tx_cus_cls_upd (req_id,set_num,process_mode);

Line 1729: arp_message.set_line ('JL_CMERGE.MERGE()-');

1725: jl_zz_tx_exc_cus_upd (req_id,set_num,process_mode);
1726: jl_zz_tx_lgl_msg_upd (req_id,set_num,process_mode);
1727: --jl_br_journals_upd (req_id,set_num,process_mode); -- bug 8362076 Commented the call as the journals table is not in use
1728: --jl_br_balances_upd (req_id,set_num,process_mode); -- bug 8362076 Commented the call as the balances table is not in use
1729: arp_message.set_line ('JL_CMERGE.MERGE()-');
1730:
1731: END merge;
1732: END jl_cmerge;

Line 1732: END jl_cmerge;

1728: --jl_br_balances_upd (req_id,set_num,process_mode); -- bug 8362076 Commented the call as the balances table is not in use
1729: arp_message.set_line ('JL_CMERGE.MERGE()-');
1730:
1731: END merge;
1732: END jl_cmerge;