DBA Data[Home] [Help]

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.8 2009/04/16 15:07:19 bridgway ship $ */
3:
4:
5:

Line 33: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcat', p_log_level_rec => p_log_level_rec);

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

Line 49: (CALLING_FN=>'FA_TRX_APPROVAL_PKG.faxcat', p_log_level_rec => p_log_level_rec);

45: X_asset_id=>X_asset_id ,
46: X_trx_type=>X_trx_type ,
47: X_txn_status=>h_result, p_log_level_rec => p_log_level_rec)) THEN
48: FA_SRVR_MSG.add_message
49: (CALLING_FN=>'FA_TRX_APPROVAL_PKG.faxcat', p_log_level_rec => p_log_level_rec);
50: RETURN (h_result); /*FALSE*/
51: END IF;
52:
53: RETURN (h_result); /*TRUE*/

Line 58: (CALLING_FN=>'FA_TRX_APPROVAL_PKG.faxcat', p_log_level_rec => p_log_level_rec);

54:
55: EXCEPTION
56: WHEN OTHERS THEN
57: FA_SRVR_MSG.Add_SQL_Error
58: (CALLING_FN=>'FA_TRX_APPROVAL_PKG.faxcat', p_log_level_rec => p_log_level_rec);
59: h_result := FALSE;
60: RETURN (h_result); /*FALSE*/
61: --dbms_output.put_line('end of func1');
62:

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

142: /* correcting BUG# 1340968 to not use "!=" */
143: IF (h_mrc_book_count <> 0) THEN
144: IF (h_count <> (h_count_mrc/h_mrc_book_count)) THEN
145: FA_SRVR_MSG.add_message
146: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',
147: NAME => 'FA_SHARED_PENDING_RETIREMENT', p_log_level_rec => p_log_level_rec);
148: X_result := FALSE;
149: RETURN (X_result); /*FALSE*/
150: ELSE

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

155: END IF;
156: ELSE
157: IF (h_count + h_count_mrc > 0) THEN
158: FA_SRVR_MSG.add_message
159: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',
160: NAME => 'FA_SHARED_PENDING_RETIREMENT', p_log_level_rec => p_log_level_rec);
161: X_result := FALSE;
162: RETURN (X_result); /*FALSE*/
163: ELSE

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

208: /* correcting BUG# 1340968 to not use "!=" */
209: IF (h_mrc_book_count <> 0) THEN
210: IF (h_count <> (h_count_mrc/h_mrc_book_count)) THEN
211: FA_SRVR_MSG.add_message
212: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',
213: NAME => 'FA_SHARED_PENDING_RETIREMENT'
214: ,p_log_level_rec => p_log_level_rec);
215: X_result := FALSE;
216: RETURN (X_result); /*FALSE*/

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

222: END IF;
223: ELSE
224: IF (h_count + h_count_mrc > 0) THEN
225: FA_SRVR_MSG.add_message
226: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',
227: NAME => 'FA_SHARED_PENDING_RETIREMENT'
228: ,p_log_level_rec => p_log_level_rec);
229: X_result := FALSE;
230: RETURN (X_result); /*FALSE*/

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

258: END IF;
259:
260: IF (h_ah_units <> h_dh_units) THEN
261: FA_SRVR_MSG.add_message
262: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti',
263: NAME => 'FA_SHARED_UNITS_UNBAL', p_log_level_rec => p_log_level_rec);
264: X_result := FALSE;
265: RETURN (X_result); /*FALSE*/
266: ELSE

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

287:
288: EXCEPTION
289: WHEN OTHERS THEN
290: FA_SRVR_MSG.Add_SQL_Error
291: (CALLING_FN => 'FA_TRX_APPROVAL_PKG.faxcti', p_log_level_rec => p_log_level_rec);
292: X_result := FALSE;
293: RETURN (X_result); /*FALSE*/
294:
295:

Line 299: END FA_TRX_APPROVAL_PKG;

295:
296: END faxcti;
297:
298:
299: END FA_TRX_APPROVAL_PKG;