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.25 2010/12/20 12:34:08 gigupta ship $ */
3:
4:
5: G_gen_expense varchar2(1) := NULL;

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

29: x_worker_jobs OUT NOCOPY number) IS
30:
31: l_batch_size number;
32: l_dist_source_book varchar2(30);
33: l_calling_fn varchar2(40) := 'FA_GENACCTS_PKG.GEN_ACCTS';
34:
35: -- book variables
36: h_default_ccid number;
37: h_flex_num number;

Line 635: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts', p_log_level_rec => g_log_level_rec);

631: EXCEPTION
632: WHEN OTHERS THEN
633:
634: FA_SRVR_MSG.ADD_SQL_ERROR(
635: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts', p_log_level_rec => g_log_level_rec);
636:
637: UPDATE FA_WORKER_JOBS
638: SET status = 'FAILED'
639: WHERE request_id = p_parent_request_id

Line 675: fa_srvr_msg.add_message(calling_fn => 'fa_genaccts_pkg.gen_accts', p_log_level_rec => g_log_level_rec);

671:
672: WHEN error_found then
673: x_success_count := G_success_count;
674: x_failure_count := G_failure_count;
675: fa_srvr_msg.add_message(calling_fn => 'fa_genaccts_pkg.gen_accts', p_log_level_rec => g_log_level_rec);
676: if (g_log_level_rec.statement_level) then
677: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
678: end if;
679: x_return_status := 2;

Line 685: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts', p_log_level_rec => g_log_level_rec);

681: WHEN OTHERS THEN
682: x_success_count := G_success_count;
683: x_failure_count := G_failure_count;
684: FA_SRVR_MSG.ADD_SQL_ERROR(
685: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts', p_log_level_rec => g_log_level_rec);
686: if (g_log_level_rec.statement_level) then
687: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
688: end if;
689: x_return_status := 2;

Line 1987: CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID', p_log_level_rec => g_log_level_rec);

1983:
1984: EXCEPTION
1985: WHEN OTHERS THEN
1986: FA_SRVR_MSG.ADD_SQL_ERROR(
1987: CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID', p_log_level_rec => g_log_level_rec);
1988: ROLLBACK WORK;
1989: wf_core.context('FA_FLEX_PKG',
1990: 'StartProcess',
1991: X_book_type_code,

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

2018:
2019: if (g_log_level_rec.statement_level) then
2020:
2021: FA_SRVR_MSG.ADD_MESSAGE
2022: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',
2023: NAME => 'FA_ASSET_NUMBER',
2024: TOKEN1 => 'ASSET_NUMBER',
2025: VALUE1 => X_asset_number, p_log_level_rec => g_log_level_rec);
2026: FA_SRVR_MSG.ADD_MESSAGE

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

2023: NAME => 'FA_ASSET_NUMBER',
2024: TOKEN1 => 'ASSET_NUMBER',
2025: VALUE1 => X_asset_number, p_log_level_rec => g_log_level_rec);
2026: FA_SRVR_MSG.ADD_MESSAGE
2027: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',
2028: NAME => 'FA_ASSET_ID',
2029: TOKEN1 => 'ASSET_ID',
2030: VALUE1 => X_asset_id, p_log_level_rec => g_log_level_rec);
2031:

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

2029: TOKEN1 => 'ASSET_ID',
2030: VALUE1 => X_asset_id, p_log_level_rec => g_log_level_rec);
2031:
2032: FA_SRVR_MSG.ADD_MESSAGE
2033: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',
2034: NAME => 'FA_FLEX_ACCOUNT_SEGMENT',
2035: TOKEN1 => 'ACCOUNT_SEGMENT',
2036: VALUE1 => X_acct_seg, p_log_level_rec => g_log_level_rec);
2037: FA_SRVR_MSG.ADD_MESSAGE

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

2034: NAME => 'FA_FLEX_ACCOUNT_SEGMENT',
2035: TOKEN1 => 'ACCOUNT_SEGMENT',
2036: VALUE1 => X_acct_seg, p_log_level_rec => g_log_level_rec);
2037: FA_SRVR_MSG.ADD_MESSAGE
2038: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',
2039: NAME => 'FA_FLEX_ACCOUNT_CCID',
2040: TOKEN1 => 'ACCOUNT_CCID',
2041: VALUE1 => X_account_ccid, p_log_level_rec => g_log_level_rec);
2042: FA_SRVR_MSG.ADD_MESSAGE

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

2039: NAME => 'FA_FLEX_ACCOUNT_CCID',
2040: TOKEN1 => 'ACCOUNT_CCID',
2041: VALUE1 => X_account_ccid, p_log_level_rec => g_log_level_rec);
2042: FA_SRVR_MSG.ADD_MESSAGE
2043: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',
2044: NAME => 'FA_FLEX_DEFAULT_CCID',
2045: TOKEN1 => 'DEFAULT_CCID',
2046: VALUE1 => X_default_ccid, p_log_level_rec => g_log_level_rec);
2047: FA_SRVR_MSG.ADD_MESSAGE

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

2044: NAME => 'FA_FLEX_DEFAULT_CCID',
2045: TOKEN1 => 'DEFAULT_CCID',
2046: VALUE1 => X_default_ccid, p_log_level_rec => g_log_level_rec);
2047: FA_SRVR_MSG.ADD_MESSAGE
2048: (CALLING_FN => 'FA_GENACCTS_PKG.GEN_CCID',
2049: NAME => 'FA_FLEX_DISTRIBUTION_CCID',
2050: TOKEN1 => 'DISTRIBUTION_CCID',
2051: VALUE1 => X_dist_ccid, p_log_level_rec => g_log_level_rec);
2052: end if;

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

2063: x_return_status OUT NOCOPY number) IS
2064:
2065: l_batch_size number;
2066: l_dist_source_book varchar2(30);
2067: l_calling_fn varchar2(60) := 'FA_GENACCTS_PKG.Load_Workers';
2068:
2069: error_found exception;
2070:
2071: BEGIN

Line 2117: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts', p_log_level_rec => g_log_level_rec);

2113: x_return_status := 2;
2114:
2115: WHEN OTHERS THEN
2116: FA_SRVR_MSG.ADD_SQL_ERROR(
2117: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts', p_log_level_rec => g_log_level_rec);
2118: rollback;
2119: if (g_log_level_rec.statement_level) then
2120: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
2121: end if;

Line 2128: END FA_GENACCTS_PKG;

2124: END Load_Workers;
2125:
2126: -----------------------------------------------------------------------
2127:
2128: END FA_GENACCTS_PKG;