1: PACKAGE BODY FA_MASS_TRANSFERS_PKG AS
2: /* $Header: FAXMTFRB.pls 120.5 2005/10/20 14:40:52 bridgway noship $ */
3:
4: /** The following describes what this function expects as parameters
5: x_mass_transfer_id valid mass transfer id
55: segment27,
56: segment28,
57: segment29,
58: segment30
59: from fa_mass_transfers
60: where mass_transfer_id = x_mass_transfer_id;
61:
62: mtfr_rec c_mtfr%ROWTYPE := null;
63:
179: when flex_error THEN
180: v_message := FND_FLEX_EXT.GET_ENCODED_MESSAGE;
181: fnd_msg_pub.add;
182:
183: FA_SRVR_MSG.add_message(CALLING_FN => 'FA_MASS_TRANSFERS_PKG.famtgcc',
184: p_log_level_rec => p_log_level_rec);
185:
186: RETURN (FALSE);
187:
198: end if;
199: end loop;
200:
201: FA_SRVR_MSG.ADD_MESSAGE(
202: CALLING_FN=>'FA_MASS_TRANSFERS.famtgcc',
203: NAME=>'FA_FLEXBUILDER_FAIL_CCID',
204: TOKEN1 => 'ACCOUNT_TYPE',
205: VALUE1 => 'DEPRN_EXP',
206: TOKEN2 => 'BOOK_TYPE_CODE',
217:
218: when others then
219:
220: FA_SRVR_MSG.ADD_SQL_ERROR (
221: CALLING_FN => 'FA_MASS_TRANSFERS.famtgcc'
222: ,p_log_level_rec => p_log_level_rec);
223: RETURN (FALSE);
224: END ;
225:
256: segment11, segment12, segment13, segment14, segment15,
257: segment16, segment17, segment18, segment19, segment20,
258: segment21, segment22, segment23, segment24, segment25,
259: segment26, segment27, segment28, segment29, segment30
260: from fa_mass_transfers
261: where mass_transfer_id = x_mass_transfer_id;
262:
263: mtfr_rec c_mtfr%ROWTYPE := null;
264: BEGIN
355: return TRUE;
356: exception
357: when others then
358: FA_SRVR_MSG.ADD_SQL_ERROR (
359: CALLING_FN => 'FA_MASS_TRANSFERS.get_segarray'
360: ,p_log_level_rec => p_log_level_rec);
361: RETURN (FALSE);
362:
363: END get_segarray;
401: return TRUE;
402: exception
403: when others then
404: FA_SRVR_MSG.ADD_SQL_ERROR (
405: CALLING_FN => 'FA_MASS_TRANSFERS.get_conc_segments'
406: ,p_log_level_rec => p_log_level_rec);
407: RETURN (FALSE);
408:
409: END get_conc_segments;
408:
409: END get_conc_segments;
410:
411:
412: END FA_MASS_TRANSFERS_PKG;