DBA Data[Home] [Help]

APPS.FA_GENACCTS_PKG dependencies on FA_GENACCTS_PKG

Line 1: PACKAGE BODY FA_GENACCTS_PKG as

1: PACKAGE BODY FA_GENACCTS_PKG as
2: /* $Header: fagendab.pls 120.22.12010000.1 2008/07/28 13:21:48 appldev ship $ */
3:
4:
5: G_gen_expense varchar2(1) := NULL;

Line 36: l_calling_fn varchar2(40) := 'FA_GENACCTS_PKG.GEN_ACCTS';

32: ) IS
33:
34: l_batch_size number;
35: l_dist_source_book varchar2(15);
36: l_calling_fn varchar2(40) := 'FA_GENACCTS_PKG.GEN_ACCTS';
37:
38: -- book variables
39: h_default_ccid number;
40: h_flex_num number;

Line 614: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts'

610: EXCEPTION
611: WHEN OTHERS THEN
612:
613: FA_SRVR_MSG.ADD_SQL_ERROR(
614: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts'
615: ,p_log_level_rec => g_log_level_rec);
616:
617: UPDATE FA_WORKER_JOBS
618: SET status = 'FAILED'

Line 657: fa_srvr_msg.add_message(calling_fn => 'fa_genaccts_pkg.gen_accts'

653:
654: WHEN error_found then
655: x_success_count := G_success_count;
656: x_failure_count := G_failure_count;
657: fa_srvr_msg.add_message(calling_fn => 'fa_genaccts_pkg.gen_accts'
658: ,p_log_level_rec => g_log_level_rec);
659:
660: -- Commented for bugfix 4672237
661: -- if (g_log_level_rec.statement_level) then

Line 670: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts'

666: WHEN OTHERS THEN
667: x_success_count := G_success_count;
668: x_failure_count := G_failure_count;
669: FA_SRVR_MSG.ADD_SQL_ERROR(
670: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts'
671: ,p_log_level_rec => g_log_level_rec);
672:
673: -- Commented for bugfix 4672237
674: -- if (g_log_level_rec.statement_level) then

Line 1781: CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID'

1777:
1778: EXCEPTION
1779: WHEN OTHERS THEN
1780: FA_SRVR_MSG.ADD_SQL_ERROR(
1781: CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID'
1782: ,p_log_level_rec => p_log_level_rec);
1783: ROLLBACK WORK;
1784: wf_core.context('FA_FLEX_PKG',
1785: 'StartProcess',

Line 1818: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',

1814:
1815: if (g_log_level_rec.statement_level) then
1816:
1817: FA_SRVR_MSG.ADD_MESSAGE
1818: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',
1819: NAME => 'FA_ASSET_NUMBER',
1820: TOKEN1 => 'ASSET_NUMBER',
1821: VALUE1 => X_asset_number
1822: ,p_log_level_rec => p_log_level_rec);

Line 1824: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',

1820: TOKEN1 => 'ASSET_NUMBER',
1821: VALUE1 => X_asset_number
1822: ,p_log_level_rec => p_log_level_rec);
1823: FA_SRVR_MSG.ADD_MESSAGE
1824: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',
1825: NAME => 'FA_ASSET_ID',
1826: TOKEN1 => 'ASSET_ID',
1827: VALUE1 => X_asset_id
1828: ,p_log_level_rec => p_log_level_rec);

Line 1831: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',

1827: VALUE1 => X_asset_id
1828: ,p_log_level_rec => p_log_level_rec);
1829:
1830: FA_SRVR_MSG.ADD_MESSAGE
1831: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',
1832: NAME => 'FA_FLEX_ACCOUNT_SEGMENT',
1833: TOKEN1 => 'ACCOUNT_SEGMENT',
1834: VALUE1 => X_acct_seg
1835: ,p_log_level_rec => p_log_level_rec);

Line 1837: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',

1833: TOKEN1 => 'ACCOUNT_SEGMENT',
1834: VALUE1 => X_acct_seg
1835: ,p_log_level_rec => p_log_level_rec);
1836: FA_SRVR_MSG.ADD_MESSAGE
1837: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',
1838: NAME => 'FA_FLEX_ACCOUNT_CCID',
1839: TOKEN1 => 'ACCOUNT_CCID',
1840: VALUE1 => X_account_ccid
1841: ,p_log_level_rec => p_log_level_rec);

Line 1843: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',

1839: TOKEN1 => 'ACCOUNT_CCID',
1840: VALUE1 => X_account_ccid
1841: ,p_log_level_rec => p_log_level_rec);
1842: FA_SRVR_MSG.ADD_MESSAGE
1843: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',
1844: NAME => 'FA_FLEX_DEFAULT_CCID',
1845: TOKEN1 => 'DEFAULT_CCID',
1846: VALUE1 => X_default_ccid
1847: ,p_log_level_rec => p_log_level_rec);

Line 1849: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',

1845: TOKEN1 => 'DEFAULT_CCID',
1846: VALUE1 => X_default_ccid
1847: ,p_log_level_rec => p_log_level_rec);
1848: FA_SRVR_MSG.ADD_MESSAGE
1849: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',
1850: NAME => 'FA_FLEX_DISTRIBUTION_CCID',
1851: TOKEN1 => 'DISTRIBUTION_CCID',
1852: VALUE1 => X_dist_ccid
1853: ,p_log_level_rec => p_log_level_rec);

Line 1870: l_calling_fn varchar2(60) := 'FA_GENACCTS_PKG.Load_Workers';

1866: ) is
1867:
1868: l_batch_size number;
1869: l_dist_source_book varchar2(15);
1870: l_calling_fn varchar2(60) := 'FA_GENACCTS_PKG.Load_Workers';
1871:
1872: error_found exception;
1873:
1874: BEGIN

Line 1926: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts'

1922: x_return_status := 2;
1923:
1924: WHEN OTHERS THEN
1925: FA_SRVR_MSG.ADD_SQL_ERROR(
1926: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts'
1927: ,p_log_level_rec => g_log_level_rec);
1928: rollback;
1929:
1930: -- Commented for bugfix 4672237

Line 1940: END FA_GENACCTS_PKG;

1936: END Load_Workers;
1937:
1938: -----------------------------------------------------------------------
1939:
1940: END FA_GENACCTS_PKG;