APPS.FA_TRX_APPROVAL_PKG dependencies on FA_TRX_APPROVAL_PKG

Line 1: PACKAGE BODY FA_TRX_APPROVAL_PKG AS

1: PACKAGE BODY FA_TRX_APPROVAL_PKG AS
2: /* $Header: FATRXAPB.pls 120.5.12010000.2 2008/07/31 06:55:49 sbhaskar ship $ */
3:
4:
5:

Line 36: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcat'

32: X_trx_date=>X_trx_date,
33: X_result=>h_result
34: ,p_log_level_rec => p_log_level_rec) THEN
35: FA_SRVR_MSG.add_message
36: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcat'
37: ,p_log_level_rec => p_log_level_rec);
38: RETURN (h_result); /*FALSE */
39: END IF;
40:

Line 55: (CALLING_FN=>'FA_TRX_APPROVAL_PKG.faxcat'

51: X_trx_type=>X_trx_type ,
52: X_txn_status=>h_result
53: ,p_log_level_rec => p_log_level_rec)) THEN
54: FA_SRVR_MSG.add_message
55: (CALLING_FN=>'FA_TRX_APPROVAL_PKG.faxcat'
56: ,p_log_level_rec => p_log_level_rec);
57: RETURN (h_result); /*FALSE*/
58: END IF;
59:

Line 65: (CALLING_FN=>'FA_TRX_APPROVAL_PKG.faxcat'

61:
62: EXCEPTION
63: WHEN OTHERS THEN
64: FA_SRVR_MSG.Add_SQL_Error
65: (CALLING_FN=>'FA_TRX_APPROVAL_PKG.faxcat'
66: ,p_log_level_rec => p_log_level_rec);
67: h_result := FALSE;
68: RETURN (h_result); /*FALSE*/
69: --dbms_output.put_line('end of func1');

Line 165: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',

161: /* correcting BUG# 1340968 to not use "!=" */
162: IF (h_mrc_book_count <> 0) THEN
163: IF (h_count <> (h_count_mrc/h_mrc_book_count)) THEN
164: FA_SRVR_MSG.add_message
165: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',
166: NAME => 'FA_SHARED_PENDING_RETIREMENT'
167: ,p_log_level_rec => p_log_level_rec);
168: X_result := FALSE;
169: RETURN (X_result); /*FALSE*/

Line 179: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',

175: END IF;
176: ELSE
177: IF (h_count + h_count_mrc > 0) THEN
178: FA_SRVR_MSG.add_message
179: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',
180: NAME => 'FA_SHARED_PENDING_RETIREMENT'
181: ,p_log_level_rec => p_log_level_rec);
182: X_result := FALSE;
183: RETURN (X_result); /*FALSE*/

Line 237: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',

233: /* correcting BUG# 1340968 to not use "!=" */
234: IF (h_mrc_book_count <> 0) THEN
235: IF (h_count <> (h_count_mrc/h_mrc_book_count)) THEN
236: FA_SRVR_MSG.add_message
237: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',
238: NAME => 'FA_SHARED_PENDING_RETIREMENT'
239: ,p_log_level_rec => p_log_level_rec);
240: X_result := FALSE;
241: RETURN (X_result); /*FALSE*/

Line 251: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',

247: END IF;
248: ELSE
249: IF (h_count + h_count_mrc > 0) THEN
250: FA_SRVR_MSG.add_message
251: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',
252: NAME => 'FA_SHARED_PENDING_RETIREMENT'
253: ,p_log_level_rec => p_log_level_rec);
254: X_result := FALSE;
255: RETURN (X_result); /*FALSE*/

Line 291: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',

287: END IF;
288:
289: IF (h_ah_units <> h_dh_units) THEN
290: FA_SRVR_MSG.add_message
291: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',
292: NAME => 'FA_SHARED_UNITS_UNBAL'
293: ,p_log_level_rec => p_log_level_rec);
294: X_result := FALSE;
295: RETURN (X_result); /*FALSE*/

Line 319: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti'

315:
316: EXCEPTION
317: WHEN ERROR_FOUND THEN
318: FA_SRVR_MSG.Add_Message
319: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti'
320: ,p_log_level_rec => p_log_level_rec);
321: X_result := FALSE;
322: RETURN (X_result); /*FALSE*/
323:

Line 326: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti'

322: RETURN (X_result); /*FALSE*/
323:
324: WHEN OTHERS THEN
325: FA_SRVR_MSG.Add_SQL_Error
326: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti'
327: ,p_log_level_rec => p_log_level_rec);
328: X_result := FALSE;
329: RETURN (X_result); /*FALSE*/
330:

Line 335: END FA_TRX_APPROVAL_PKG;

331:
332: END faxcti;
333:
334:
335: END FA_TRX_APPROVAL_PKG;