DBA Data[Home] [Help]

APPS.FA_GCCID_PKG dependencies on FA_GCCID_PKG

Line 1: PACKAGE BODY FA_GCCID_PKG as

1: PACKAGE BODY FA_GCCID_PKG as
2: /* $Header: FAFBGCB.pls 120.6.12010000.1 2008/07/28 13:11:56 appldev ship $tpershad ship */
3:
4: G_check_dist_accts boolean := TRUE;
5:

Line 118: ( CALLING_FN => 'FA_GCCID_PKG.fafb_load_functions'

114: return TRUE;
115: EXCEPTION
116: WHEN OTHERS THEN
117: FA_SRVR_MSG.ADD_SQL_ERROR
118: ( CALLING_FN => 'FA_GCCID_PKG.fafb_load_functions'
119: ,p_log_level_rec => p_log_level_rec);
120: return FALSE;
121: end fafb_load_functions;
122:

Line 145: (CALLING_FN => 'FA_GCCID_PKG.fafb_search_functions',

141: END LOOP;
142:
143: if h_j > FA_FLEX_TYPE.NUM_ACCTS then
144: FA_SRVR_MSG.ADD_MESSAGE
145: (CALLING_FN => 'FA_GCCID_PKG.fafb_search_functions',
146: NAME => 'FA_FLEX_NO_ACCOUNT',
147: p_log_level_rec => p_log_level_rec);
148: return FALSE;
149: end if;

Line 154: ( CALLING_FN => 'FA_GCCID_PKG.fafb_search_functions'

150: return TRUE;
151: EXCEPTION
152: WHEN OTHERS THEN
153: FA_SRVR_MSG.ADD_SQL_ERROR
154: ( CALLING_FN => 'FA_GCCID_PKG.fafb_search_functions'
155: ,p_log_level_rec => p_log_level_rec);
156: return FALSE;
157: end fafb_search_functions;
158:

Line 204: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc',

200:
201: h_ret_value := fafb_load_functions;
202: if not h_ret_value then
203: FA_SRVR_MSG.ADD_MESSAGE
204: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc',
205: p_log_level_rec => p_log_level_rec);
206: end if;
207:
208: -- no need to call the cache here as it will already be loaded

Line 217: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc',

213: X_function_code => h_flex_function_code,
214: p_log_level_rec => p_log_level_rec);
215: if not h_ret_value then
216: FA_SRVR_MSG.ADD_MESSAGE
217: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc',
218: p_log_level_rec => p_log_level_rec);
219: return FALSE;
220: end if;
221: if (p_log_level_rec.statement_level)

Line 224: fname => 'FA_GCCID_PKG.fafbgcc',

220: end if;
221: if (p_log_level_rec.statement_level)
222: then
223: FA_DEBUG_PKG.ADD(
224: fname => 'FA_GCCID_PKG.fafbgcc',
225: element => 'dist_ccid in fafbgcc is ',
226: value => X_dist_ccid,
227: p_log_level_rec => p_log_level_rec);
228: FA_DEBUG_PKG.ADD(

Line 229: fname => 'FA_GCCID_PKG.fafbgcc',

225: element => 'dist_ccid in fafbgcc is ',
226: value => X_dist_ccid,
227: p_log_level_rec => p_log_level_rec);
228: FA_DEBUG_PKG.ADD(
229: fname => 'FA_GCCID_PKG.fafbgcc',
230: element => 'flexbuilder defs ccid ',
231: value => h_segs_def_ccid,
232: p_log_level_rec => p_log_level_rec);
233: end if;

Line 249: fa_srvr_msg.add_message(calling_fn => 'fa_gccid_pkg.fafbgcc',

245: x_period_counter => null,
246: x_effective_date => null,
247: p_log_level_rec => p_log_level_rec) then
248:
249: fa_srvr_msg.add_message(calling_fn => 'fa_gccid_pkg.fafbgcc',
250: p_log_level_rec => p_log_level_rec);
251: return false;
252: end if;
253: h_val_date := fa_cache_pkg.fazcdp_record.calendar_period_close_date;

Line 264: fname => 'FA_GCCID_PKG.fafbgcc',

260: */
261: if (p_log_level_rec.statement_level)
262: then
263: FA_DEBUG_PKG.ADD (
264: fname => 'FA_GCCID_PKG.fafbgcc',
265: element => 'validation_date in fafbgcb is ',
266: value =>h_val_date,
267: p_log_level_rec => p_log_level_rec);
268:

Line 270: fname => 'FA_GCCID_PKG.fafbgcc',

266: value =>h_val_date,
267: p_log_level_rec => p_log_level_rec);
268:
269: FA_DEBUG_PKG.ADD (
270: fname => 'FA_GCCID_PKG.fafbgcc',
271: element => 'distribution ccid in fafbgcc is ',
272: value =>X_dist_ccid,
273: p_log_level_rec => p_log_level_rec);
274: FA_DEBUG_PKG.ADD (

Line 275: fname => 'FA_GCCID_PKG.fafbgcc',

271: element => 'distribution ccid in fafbgcc is ',
272: value =>X_dist_ccid,
273: p_log_level_rec => p_log_level_rec);
274: FA_DEBUG_PKG.ADD (
275: fname => 'FA_GCCID_PKG.fafbgcc',
276: element => 'Acct Type in fafbgcc is ',
277: value =>h_flex_function_code,
278: p_log_level_rec => p_log_level_rec);
279: FA_DEBUG_PKG.ADD (

Line 280: fname => 'FA_GCCID_PKG.fafbgcc',

276: element => 'Acct Type in fafbgcc is ',
277: value =>h_flex_function_code,
278: p_log_level_rec => p_log_level_rec);
279: FA_DEBUG_PKG.ADD (
280: fname => 'FA_GCCID_PKG.fafbgcc',
281: element => 'segval in fafbgcc is ',
282: value =>h_acct_segval,
283: p_log_level_rec => p_log_level_rec);
284: FA_DEBUG_PKG.ADD (

Line 285: fname => 'FA_GCCID_PKG.fafbgcc',

281: element => 'segval in fafbgcc is ',
282: value =>h_acct_segval,
283: p_log_level_rec => p_log_level_rec);
284: FA_DEBUG_PKG.ADD (
285: fname => 'FA_GCCID_PKG.fafbgcc',
286: element => 'seg defs ccid in fafbgcc is ',
287: value =>h_segs_def_ccid,
288: p_log_level_rec => p_log_level_rec);
289: FA_DEBUG_PKG.ADD (

Line 290: fname => 'FA_GCCID_PKG.fafbgcc',

286: element => 'seg defs ccid in fafbgcc is ',
287: value =>h_segs_def_ccid,
288: p_log_level_rec => p_log_level_rec);
289: FA_DEBUG_PKG.ADD (
290: fname => 'FA_GCCID_PKG.fafbgcc',
291: element => 'acct ccid in fafbgcc is ',
292: value =>h_acct_ccid,
293: p_log_level_rec => p_log_level_rec);
294: FA_DEBUG_PKG.ADD (

Line 295: fname => 'FA_GCCID_PKG.fafbgcc',

291: element => 'acct ccid in fafbgcc is ',
292: value =>h_acct_ccid,
293: p_log_level_rec => p_log_level_rec);
294: FA_DEBUG_PKG.ADD (
295: fname => 'FA_GCCID_PKG.fafbgcc',
296: element => 'flex num in fafbgcc is ',
297: value =>h_flex_num,
298: p_log_level_rec => p_log_level_rec);
299: end if;

Line 320: fname => 'FA_GCCID_PKG.fafbgcc',

316: if (g_custom_gen_ccid) then
317:
318: if (p_log_level_rec.statement_level) then
319: FA_DEBUG_PKG.ADD(
320: fname => 'FA_GCCID_PKG.fafbgcc',
321: element => 'entering ',
322: value => 'custom gen ccid logic',
323: p_log_level_rec => p_log_level_rec);
324: end if;

Line 393: h_ccid_success := FA_GCCID_PKG.get_ccid(

389: --- ELSE DO NOT USE CUSTOM GEN CCID
390: else
391:
392: if (G_check_dist_accts) then
393: h_ccid_success := FA_GCCID_PKG.get_ccid(
394: X_book_type_code,
395: X_distribution_id,
396: X_fn_trx_code,
397: h_val_date,

Line 432: fname => 'FA_GCCID_PKG.fafbgcc',

428: ,p_log_level_rec => p_log_level_rec);
429: if (p_log_level_rec.statement_level)
430: then
431: FA_DEBUG_PKG.ADD (
432: fname => 'FA_GCCID_PKG.fafbgcc',
433: element => ' return from Start Process ',
434: value =>h_ret_value,
435: p_log_level_rec => p_log_level_rec);
436: end if;

Line 446: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc',

442: Flexbuilder failed to generate the code combination id. Pls
443: inform your systems administrator
444:
445: FA_SRVR_MSG.ADD_MESSAGE
446: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc',
447: NAME => 'FA_FLEX_FUNCTION_FAILED',
448: p_log_level_rec => p_log_level_rec);
449: */
450:

Line 481: FA_SRVR_MSG.ADD_SQL_ERROR ( CALLING_FN => 'FA_GCCID_PKG.fafbgcc'

477: return h_ret_value;
478:
479: EXCEPTION
480: WHEN OTHERS THEN
481: FA_SRVR_MSG.ADD_SQL_ERROR ( CALLING_FN => 'FA_GCCID_PKG.fafbgcc'
482: ,p_log_level_rec => p_log_level_rec);
483: return FALSE;
484:
485: END ; /* fafbgcc */

Line 517: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc',

513: -- for pro*c, we need to load the plsql cache for
514: -- book controls and profile options
515: if not FA_CACHE_PKG.fazcbc(X_book_type_code, p_log_level_rec) then
516: FA_SRVR_MSG.ADD_MESSAGE
517: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc',
518: p_log_level_rec => p_log_level_rec);
519: X_return_value := 0;
520: return;
521: end if;

Line 540: fa_srvr_msg.add_message(calling_fn => 'fa_gccid_pkg.fafbgcc',

536: x_period_counter => null,
537: x_effective_date => null,
538: p_log_level_rec => p_log_level_rec) then
539: X_return_value := 0;
540: fa_srvr_msg.add_message(calling_fn => 'fa_gccid_pkg.fafbgcc',
541: p_log_level_rec => p_log_level_rec);
542: return;
543: end if;
544: h_val_date := fa_cache_pkg.fazcdp_record.calendar_period_close_date;

Line 555: h_ccid_success := FA_GCCID_PKG.get_ccid(

551: -- and need to call fafbgcc to generate the ccid
552:
553: if not g_custom_gen_ccid then
554: G_check_dist_accts := FALSE;
555: h_ccid_success := FA_GCCID_PKG.get_ccid(
556: X_book_type_code,
557: to_number(X_distribution_id),
558: X_fn_trx_code,
559: h_val_date,

Line 566: h_ret_value := FA_GCCID_PKG.fafbgcc(X_book_type_code,

562: p_log_level_rec);
563: end if;
564:
565: if (not h_ccid_found OR h_rtn_ccid = -1) then
566: h_ret_value := FA_GCCID_PKG.fafbgcc(X_book_type_code,
567: X_fn_trx_code,
568: to_number(X_dist_ccid),
569: X_acct_segval,
570: to_number(X_account_ccid),

Line 580: X_concat_segs := FA_GCCID_PKG.global_concat_segs;

576: else
577: X_return_value := 0; /* False */
578: end if;
579: X_rtn_ccid := h_rtn_ccid;
580: X_concat_segs := FA_GCCID_PKG.global_concat_segs;
581: elsif (not h_ccid_success) then
582: X_rtn_ccid := h_rtn_ccid;
583: X_concat_segs := FA_GCCID_PKG.global_concat_segs;
584: X_return_value := 0; /* False */

Line 583: X_concat_segs := FA_GCCID_PKG.global_concat_segs;

579: X_rtn_ccid := h_rtn_ccid;
580: X_concat_segs := FA_GCCID_PKG.global_concat_segs;
581: elsif (not h_ccid_success) then
582: X_rtn_ccid := h_rtn_ccid;
583: X_concat_segs := FA_GCCID_PKG.global_concat_segs;
584: X_return_value := 0; /* False */
585: else
586: X_rtn_ccid := h_rtn_ccid;
587: X_concat_segs := FA_GCCID_PKG.global_concat_segs;

Line 587: X_concat_segs := FA_GCCID_PKG.global_concat_segs;

583: X_concat_segs := FA_GCCID_PKG.global_concat_segs;
584: X_return_value := 0; /* False */
585: else
586: X_rtn_ccid := h_rtn_ccid;
587: X_concat_segs := FA_GCCID_PKG.global_concat_segs;
588: X_return_value := 1; /* True */
589: end if;
590:
591: -- in case there is some problem and ccid is not generated

Line 847: FA_GCCID_PKG.global_concat_segs :=

843: delim := FND_FLEX_EXT.get_delimiter(
844: application_short_name => 'SQLGL',
845: key_flex_code => 'GL#',
846: structure_number => h_flex_num);
847: FA_GCCID_PKG.global_concat_segs :=
848: FND_FLEX_EXT.concatenate_segments(
849: n_segments => n_segs,
850: segments => all_segments,
851: delimiter => delim);

Line 863: VALUE4 => FA_GCCID_PKG.global_concat_segs,

859: VALUE2 => X_book_type_code,
860: TOKEN3 => 'DIST_ID',
861: VALUE3 => X_distribution_id,
862: TOKEN4 => 'CONCAT_SEGS',
863: VALUE4 => FA_GCCID_PKG.global_concat_segs,
864: p_log_level_rec => p_log_level_rec);
865:
866: fnd_message.set_name('FND', 'FLEX-COMBINATION DISABLED');
867: fnd_msg_pub.add; -- end 1504839

Line 921: END FA_GCCID_PKG;

917: end if;
918:
919: end fafbgcc_proc_msg;
920:
921: END FA_GCCID_PKG;