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.FA_SORP_UTIL_PVT dependencies on FA_DEBUG_PKG

Line 27: fa_debug_pkg.add

23: l_sorp_enabled_flag VARCHAR2(1);
24: l_calling_fn varchar2(35) := 'FA_SORP_UTIL_PVT.IS_SORP_ENABLED';
25: BEGIN
26: IF (p_log_level_rec.statement_level) then
27: fa_debug_pkg.add
28: (l_calling_fn,
29: 'Book Type Code Passed is ',
30: p_book_type_code, p_log_level_rec => p_log_level_rec);
31: End If;

Line 39: fa_debug_pkg.add

35: FROM FA_BOOK_CONTROLS
36: WHERE BOOK_TYPE_CODE = p_book_type_code;
37:
38: IF (p_log_level_rec.statement_level) then
39: fa_debug_pkg.add
40: (l_calling_fn,
41: 'SORP Enabled Flag is ',
42: l_sorp_enabled_flag, p_log_level_rec => p_log_level_rec);
43: End If;

Line 90: fa_debug_pkg.add(l_calling_fn,'Entering overloaded function', 'true', p_log_level_rec => p_log_level_rec);

86: l_mode varchar2(20) := 'neutralizing';
87: BEGIN
88:
89: if (p_log_level_rec.statement_level) then
90: fa_debug_pkg.add(l_calling_fn,'Entering overloaded function', 'true', p_log_level_rec => p_log_level_rec);
91: fa_debug_pkg.add(l_calling_fn,'p_amount', p_amount, p_log_level_rec => p_log_level_rec);
92: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);
93: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);
94: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);

Line 91: fa_debug_pkg.add(l_calling_fn,'p_amount', p_amount, p_log_level_rec => p_log_level_rec);

87: BEGIN
88:
89: if (p_log_level_rec.statement_level) then
90: fa_debug_pkg.add(l_calling_fn,'Entering overloaded function', 'true', p_log_level_rec => p_log_level_rec);
91: fa_debug_pkg.add(l_calling_fn,'p_amount', p_amount, p_log_level_rec => p_log_level_rec);
92: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);
93: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);
94: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);
95: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);

Line 92: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);

88:
89: if (p_log_level_rec.statement_level) then
90: fa_debug_pkg.add(l_calling_fn,'Entering overloaded function', 'true', p_log_level_rec => p_log_level_rec);
91: fa_debug_pkg.add(l_calling_fn,'p_amount', p_amount, p_log_level_rec => p_log_level_rec);
92: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);
93: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);
94: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);
95: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);
96: end if;

Line 93: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);

89: if (p_log_level_rec.statement_level) then
90: fa_debug_pkg.add(l_calling_fn,'Entering overloaded function', 'true', p_log_level_rec => p_log_level_rec);
91: fa_debug_pkg.add(l_calling_fn,'p_amount', p_amount, p_log_level_rec => p_log_level_rec);
92: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);
93: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);
94: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);
95: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);
96: end if;
97:

Line 94: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);

90: fa_debug_pkg.add(l_calling_fn,'Entering overloaded function', 'true', p_log_level_rec => p_log_level_rec);
91: fa_debug_pkg.add(l_calling_fn,'p_amount', p_amount, p_log_level_rec => p_log_level_rec);
92: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);
93: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);
94: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);
95: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);
96: end if;
97:
98: if not create_sorp_neutral_acct(

Line 95: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);

91: fa_debug_pkg.add(l_calling_fn,'p_amount', p_amount, p_log_level_rec => p_log_level_rec);
92: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);
93: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);
94: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);
95: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);
96: end if;
97:
98: if not create_sorp_neutral_acct(
99: p_amount => p_amount,

Line 109: fa_debug_pkg.add(l_calling_fn,'create_sorp_neutral_acct', 'failed', p_log_level_rec => p_log_level_rec);

105: p_last_updated_by => NULL,
106: p_last_update_login => NULL,
107: p_who_mode => 'CREATE',
108: p_log_level_rec => p_log_level_rec) then
109: fa_debug_pkg.add(l_calling_fn,'create_sorp_neutral_acct', 'failed', p_log_level_rec => p_log_level_rec);
110: return false;
111: end if;
112:
113: return true;

Line 116: fa_debug_pkg.add(l_calling_fn,'unexpected error', l_mode, p_log_level_rec => p_log_level_rec);

112:
113: return true;
114: EXCEPTION
115: WHEN OTHERS THEN
116: fa_debug_pkg.add(l_calling_fn,'unexpected error', l_mode, p_log_level_rec => p_log_level_rec);
117: return false;
118: END create_sorp_neutral_acct;
119:
120:

Line 164: fa_debug_pkg.add(l_calling_fn,'p_amount', p_amount, p_log_level_rec => p_log_level_rec);

160: l_leveling_flag boolean;
161: BEGIN
162:
163: if (p_log_level_rec.statement_level) then
164: fa_debug_pkg.add(l_calling_fn,'p_amount', p_amount, p_log_level_rec => p_log_level_rec);
165: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);
166: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);
167: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);
168: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);

Line 165: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);

161: BEGIN
162:
163: if (p_log_level_rec.statement_level) then
164: fa_debug_pkg.add(l_calling_fn,'p_amount', p_amount, p_log_level_rec => p_log_level_rec);
165: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);
166: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);
167: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);
168: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);
169: fa_debug_pkg.add(l_calling_fn,'p_last_update_date', p_last_update_date, p_log_level_rec => p_log_level_rec);

Line 166: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);

162:
163: if (p_log_level_rec.statement_level) then
164: fa_debug_pkg.add(l_calling_fn,'p_amount', p_amount, p_log_level_rec => p_log_level_rec);
165: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);
166: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);
167: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);
168: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);
169: fa_debug_pkg.add(l_calling_fn,'p_last_update_date', p_last_update_date, p_log_level_rec => p_log_level_rec);
170: fa_debug_pkg.add(l_calling_fn,'p_last_updated_by', p_last_updated_by, p_log_level_rec => p_log_level_rec);

Line 167: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);

163: if (p_log_level_rec.statement_level) then
164: fa_debug_pkg.add(l_calling_fn,'p_amount', p_amount, p_log_level_rec => p_log_level_rec);
165: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);
166: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);
167: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);
168: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);
169: fa_debug_pkg.add(l_calling_fn,'p_last_update_date', p_last_update_date, p_log_level_rec => p_log_level_rec);
170: fa_debug_pkg.add(l_calling_fn,'p_last_updated_by', p_last_updated_by, p_log_level_rec => p_log_level_rec);
171: fa_debug_pkg.add(l_calling_fn,'p_last_update_login', p_last_update_login, p_log_level_rec => p_log_level_rec);

Line 168: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);

164: fa_debug_pkg.add(l_calling_fn,'p_amount', p_amount, p_log_level_rec => p_log_level_rec);
165: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);
166: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);
167: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);
168: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);
169: fa_debug_pkg.add(l_calling_fn,'p_last_update_date', p_last_update_date, p_log_level_rec => p_log_level_rec);
170: fa_debug_pkg.add(l_calling_fn,'p_last_updated_by', p_last_updated_by, p_log_level_rec => p_log_level_rec);
171: fa_debug_pkg.add(l_calling_fn,'p_last_update_login', p_last_update_login, p_log_level_rec => p_log_level_rec);
172: fa_debug_pkg.add(l_calling_fn,'p_who_mode', p_who_mode, p_log_level_rec => p_log_level_rec);

Line 169: fa_debug_pkg.add(l_calling_fn,'p_last_update_date', p_last_update_date, p_log_level_rec => p_log_level_rec);

165: fa_debug_pkg.add(l_calling_fn,'p_reversal', p_reversal, p_log_level_rec => p_log_level_rec);
166: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);
167: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);
168: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);
169: fa_debug_pkg.add(l_calling_fn,'p_last_update_date', p_last_update_date, p_log_level_rec => p_log_level_rec);
170: fa_debug_pkg.add(l_calling_fn,'p_last_updated_by', p_last_updated_by, p_log_level_rec => p_log_level_rec);
171: fa_debug_pkg.add(l_calling_fn,'p_last_update_login', p_last_update_login, p_log_level_rec => p_log_level_rec);
172: fa_debug_pkg.add(l_calling_fn,'p_who_mode', p_who_mode, p_log_level_rec => p_log_level_rec);
173: fa_debug_pkg.add(l_calling_fn,'p_adj.leveling_flag',p_adj.leveling_flag, p_log_level_rec => p_log_level_rec);

Line 170: fa_debug_pkg.add(l_calling_fn,'p_last_updated_by', p_last_updated_by, p_log_level_rec => p_log_level_rec);

166: fa_debug_pkg.add(l_calling_fn,'p_adj.book_type_code', p_adj.book_type_code, p_log_level_rec => p_log_level_rec);
167: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);
168: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);
169: fa_debug_pkg.add(l_calling_fn,'p_last_update_date', p_last_update_date, p_log_level_rec => p_log_level_rec);
170: fa_debug_pkg.add(l_calling_fn,'p_last_updated_by', p_last_updated_by, p_log_level_rec => p_log_level_rec);
171: fa_debug_pkg.add(l_calling_fn,'p_last_update_login', p_last_update_login, p_log_level_rec => p_log_level_rec);
172: fa_debug_pkg.add(l_calling_fn,'p_who_mode', p_who_mode, p_log_level_rec => p_log_level_rec);
173: fa_debug_pkg.add(l_calling_fn,'p_adj.leveling_flag',p_adj.leveling_flag, p_log_level_rec => p_log_level_rec);
174: end if;

Line 171: fa_debug_pkg.add(l_calling_fn,'p_last_update_login', p_last_update_login, p_log_level_rec => p_log_level_rec);

167: fa_debug_pkg.add(l_calling_fn,'p_created_by', p_created_by, p_log_level_rec => p_log_level_rec);
168: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);
169: fa_debug_pkg.add(l_calling_fn,'p_last_update_date', p_last_update_date, p_log_level_rec => p_log_level_rec);
170: fa_debug_pkg.add(l_calling_fn,'p_last_updated_by', p_last_updated_by, p_log_level_rec => p_log_level_rec);
171: fa_debug_pkg.add(l_calling_fn,'p_last_update_login', p_last_update_login, p_log_level_rec => p_log_level_rec);
172: fa_debug_pkg.add(l_calling_fn,'p_who_mode', p_who_mode, p_log_level_rec => p_log_level_rec);
173: fa_debug_pkg.add(l_calling_fn,'p_adj.leveling_flag',p_adj.leveling_flag, p_log_level_rec => p_log_level_rec);
174: end if;
175:

Line 172: fa_debug_pkg.add(l_calling_fn,'p_who_mode', p_who_mode, p_log_level_rec => p_log_level_rec);

168: fa_debug_pkg.add(l_calling_fn,'p_creation_date', p_creation_date, p_log_level_rec => p_log_level_rec);
169: fa_debug_pkg.add(l_calling_fn,'p_last_update_date', p_last_update_date, p_log_level_rec => p_log_level_rec);
170: fa_debug_pkg.add(l_calling_fn,'p_last_updated_by', p_last_updated_by, p_log_level_rec => p_log_level_rec);
171: fa_debug_pkg.add(l_calling_fn,'p_last_update_login', p_last_update_login, p_log_level_rec => p_log_level_rec);
172: fa_debug_pkg.add(l_calling_fn,'p_who_mode', p_who_mode, p_log_level_rec => p_log_level_rec);
173: fa_debug_pkg.add(l_calling_fn,'p_adj.leveling_flag',p_adj.leveling_flag, p_log_level_rec => p_log_level_rec);
174: end if;
175:
176: l_leveling_flag := p_adj.leveling_flag;

Line 173: fa_debug_pkg.add(l_calling_fn,'p_adj.leveling_flag',p_adj.leveling_flag, p_log_level_rec => p_log_level_rec);

169: fa_debug_pkg.add(l_calling_fn,'p_last_update_date', p_last_update_date, p_log_level_rec => p_log_level_rec);
170: fa_debug_pkg.add(l_calling_fn,'p_last_updated_by', p_last_updated_by, p_log_level_rec => p_log_level_rec);
171: fa_debug_pkg.add(l_calling_fn,'p_last_update_login', p_last_update_login, p_log_level_rec => p_log_level_rec);
172: fa_debug_pkg.add(l_calling_fn,'p_who_mode', p_who_mode, p_log_level_rec => p_log_level_rec);
173: fa_debug_pkg.add(l_calling_fn,'p_adj.leveling_flag',p_adj.leveling_flag, p_log_level_rec => p_log_level_rec);
174: end if;
175:
176: l_leveling_flag := p_adj.leveling_flag;
177: p_adj.leveling_flag := FALSE;

Line 194: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Impairment

190: p_adj.debit_credit_flag := 'DR';
191: end if;
192:
193: if (p_log_level_rec.statement_level) then
194: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Impairment
195: Neutralizing Entry - Capital Adjustment', p_log_level_rec => p_log_level_rec);
196: end if;
197:
198: if p_who_mode = 'CREATE' then

Line 228: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Impairment

224: p_adj.debit_credit_flag := 'CR';
225: end if;
226:
227: if (p_log_level_rec.statement_level) then
228: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Impairment
229: Neutralizing Entry - General Fund Balance', p_log_level_rec => p_log_level_rec);
230: end if;
231:
232: if p_who_mode = 'CREATE' then

Line 250: fa_debug_pkg.add(l_calling_fn,'create_sorp_neutral_acct completed', 'Success', p_log_level_rec => p_log_level_rec);

246: end if;
247: end if; --End If (p_amount <> 0)
248:
249: if (p_log_level_rec.statement_level) then
250: fa_debug_pkg.add(l_calling_fn,'create_sorp_neutral_acct completed', 'Success', p_log_level_rec => p_log_level_rec);
251: end if;
252:
253: p_adj.leveling_flag := l_leveling_flag;
254:

Line 261: fa_debug_pkg.add(l_calling_fn,'exception at create_sorp_neutral_acct', 'pos_err', p_log_level_rec => p_log_level_rec);

257: EXCEPTION
258: WHEN pos_err THEN
259:
260: if (p_log_level_rec.statement_level) then
261: fa_debug_pkg.add(l_calling_fn,'exception at create_sorp_neutral_acct', 'pos_err', p_log_level_rec => p_log_level_rec);
262: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
263: end if;
264:
265: return false;

Line 262: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));

258: WHEN pos_err THEN
259:
260: if (p_log_level_rec.statement_level) then
261: fa_debug_pkg.add(l_calling_fn,'exception at create_sorp_neutral_acct', 'pos_err', p_log_level_rec => p_log_level_rec);
262: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
263: end if;
264:
265: return false;
266:

Line 270: fa_debug_pkg.add(l_calling_fn,'exception at create_sorp_neutral_acct', 'OTHERS', p_log_level_rec => p_log_level_rec);

266:
267: WHEN OTHERS THEN
268:
269: if (p_log_level_rec.statement_level) then
270: fa_debug_pkg.add(l_calling_fn,'exception at create_sorp_neutral_acct', 'OTHERS', p_log_level_rec => p_log_level_rec);
271: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
272: end if;
273:
274: return false;

Line 271: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));

267: WHEN OTHERS THEN
268:
269: if (p_log_level_rec.statement_level) then
270: fa_debug_pkg.add(l_calling_fn,'exception at create_sorp_neutral_acct', 'OTHERS', p_log_level_rec => p_log_level_rec);
271: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
272: end if;
273:
274: return false;
275: