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_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.8 2010/12/21 09:51:48 gigupta ship $tpershad ship */
3:
4: G_check_dist_accts boolean := TRUE;
5: g_custom_gen_ccid boolean := fa_cache_pkg.fa_custom_gen_ccid;

Line 139: ( CALLING_FN => 'FA_GCCID_PKG.fafb_load_functions', p_log_level_rec => p_log_level_rec);

135: return TRUE;
136: EXCEPTION
137: WHEN OTHERS THEN
138: FA_SRVR_MSG.ADD_SQL_ERROR
139: ( CALLING_FN => 'FA_GCCID_PKG.fafb_load_functions', p_log_level_rec => p_log_level_rec);
140: return FALSE;
141: end fafb_load_functions;
142:
143: ------------------------------------------------------------------

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

160: END LOOP;
161:
162: if h_j > FA_FLEX_TYPE.NUM_ACCTS then
163: FA_SRVR_MSG.ADD_MESSAGE
164: (CALLING_FN => 'FA_GCCID_PKG.fafb_search_functions',
165: NAME => 'FA_FLEX_NO_ACCOUNT', p_log_level_rec => p_log_level_rec);
166: return FALSE;
167: end if;
168: return TRUE;

Line 172: ( CALLING_FN => 'FA_GCCID_PKG.fafb_search_functions', p_log_level_rec => p_log_level_rec);

168: return TRUE;
169: EXCEPTION
170: WHEN OTHERS THEN
171: FA_SRVR_MSG.ADD_SQL_ERROR
172: ( CALLING_FN => 'FA_GCCID_PKG.fafb_search_functions', p_log_level_rec => p_log_level_rec);
173: return FALSE;
174: end fafb_search_functions;
175:
176: -------------------------------------------------------------------

Line 222: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc', p_log_level_rec => p_log_level_rec);

218:
219: h_ret_value := fafb_load_functions(p_log_level_rec);
220: if not h_ret_value then
221: FA_SRVR_MSG.ADD_MESSAGE
222: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc', p_log_level_rec => p_log_level_rec);
223: end if;
224:
225: -- no need to call the cache here as it will already be loaded
226: h_flex_num := FA_CACHE_PKG.fazcbc_record.accounting_flex_structure;

Line 234: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc', p_log_level_rec => p_log_level_rec);

230: X_function_code=>h_flex_function_code,
231: p_log_level_rec => p_log_level_rec);
232: if not h_ret_value then
233: FA_SRVR_MSG.ADD_MESSAGE
234: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc', p_log_level_rec => p_log_level_rec);
235: return FALSE;
236: end if;
237: if (p_log_level_rec.statement_level)
238: then

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

236: end if;
237: if (p_log_level_rec.statement_level)
238: then
239: FA_DEBUG_PKG.ADD(
240: fname => 'FA_GCCID_PKG.fafbgcc',
241: element => 'dist_ccid in fafbgcc is ',
242: value => X_dist_ccid, p_log_level_rec => p_log_level_rec);
243: FA_DEBUG_PKG.ADD(
244: fname => 'FA_GCCID_PKG.fafbgcc',

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

240: fname => 'FA_GCCID_PKG.fafbgcc',
241: element => 'dist_ccid in fafbgcc is ',
242: value => X_dist_ccid, p_log_level_rec => p_log_level_rec);
243: FA_DEBUG_PKG.ADD(
244: fname => 'FA_GCCID_PKG.fafbgcc',
245: element => 'flexbuilder defs ccid ',
246: value => h_segs_def_ccid, p_log_level_rec => p_log_level_rec);
247: end if;
248:

Line 261: fa_srvr_msg.add_message(calling_fn => 'fa_gccid_pkg.fafbgcc', p_log_level_rec => p_log_level_rec);

257: if not fa_cache_pkg.fazcdp
258: (x_book_type_code => x_book_type_code,
259: x_period_counter => null,
260: x_effective_date => null, p_log_level_rec => p_log_level_rec) then
261: fa_srvr_msg.add_message(calling_fn => 'fa_gccid_pkg.fafbgcc', p_log_level_rec => p_log_level_rec);
262: return false;
263: end if;
264: h_val_date := fa_cache_pkg.fazcdp_record.calendar_period_close_date;
265: else

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

271: */
272: if (p_log_level_rec.statement_level)
273: then
274: FA_DEBUG_PKG.ADD (
275: fname => 'FA_GCCID_PKG.fafbgcc',
276: element => 'validation_date in fafbgcb is ',
277: value =>h_val_date, p_log_level_rec => p_log_level_rec);
278:
279: FA_DEBUG_PKG.ADD (

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

276: element => 'validation_date in fafbgcb is ',
277: value =>h_val_date, p_log_level_rec => p_log_level_rec);
278:
279: FA_DEBUG_PKG.ADD (
280: fname => 'FA_GCCID_PKG.fafbgcc',
281: element => 'distribution ccid in fafbgcc is ',
282: value =>X_dist_ccid, p_log_level_rec => p_log_level_rec);
283: FA_DEBUG_PKG.ADD (
284: fname => 'FA_GCCID_PKG.fafbgcc',

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

280: fname => 'FA_GCCID_PKG.fafbgcc',
281: element => 'distribution ccid in fafbgcc is ',
282: value =>X_dist_ccid, p_log_level_rec => p_log_level_rec);
283: FA_DEBUG_PKG.ADD (
284: fname => 'FA_GCCID_PKG.fafbgcc',
285: element => 'Acct Type in fafbgcc is ',
286: value =>h_flex_function_code, p_log_level_rec => p_log_level_rec);
287: FA_DEBUG_PKG.ADD (
288: fname => 'FA_GCCID_PKG.fafbgcc',

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

284: fname => 'FA_GCCID_PKG.fafbgcc',
285: element => 'Acct Type in fafbgcc is ',
286: value =>h_flex_function_code, p_log_level_rec => p_log_level_rec);
287: FA_DEBUG_PKG.ADD (
288: fname => 'FA_GCCID_PKG.fafbgcc',
289: element => 'segval in fafbgcc is ',
290: value =>h_acct_segval, p_log_level_rec => p_log_level_rec);
291: FA_DEBUG_PKG.ADD (
292: fname => 'FA_GCCID_PKG.fafbgcc',

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

288: fname => 'FA_GCCID_PKG.fafbgcc',
289: element => 'segval in fafbgcc is ',
290: value =>h_acct_segval, p_log_level_rec => p_log_level_rec);
291: FA_DEBUG_PKG.ADD (
292: fname => 'FA_GCCID_PKG.fafbgcc',
293: element => 'seg defs ccid in fafbgcc is ',
294: value =>h_segs_def_ccid, p_log_level_rec => p_log_level_rec);
295: FA_DEBUG_PKG.ADD (
296: fname => 'FA_GCCID_PKG.fafbgcc',

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

292: fname => 'FA_GCCID_PKG.fafbgcc',
293: element => 'seg defs ccid in fafbgcc is ',
294: value =>h_segs_def_ccid, p_log_level_rec => p_log_level_rec);
295: FA_DEBUG_PKG.ADD (
296: fname => 'FA_GCCID_PKG.fafbgcc',
297: element => 'acct ccid in fafbgcc is ',
298: value =>h_acct_ccid, p_log_level_rec => p_log_level_rec);
299: FA_DEBUG_PKG.ADD (
300: fname => 'FA_GCCID_PKG.fafbgcc',

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

296: fname => 'FA_GCCID_PKG.fafbgcc',
297: element => 'acct ccid in fafbgcc is ',
298: value =>h_acct_ccid, p_log_level_rec => p_log_level_rec);
299: FA_DEBUG_PKG.ADD (
300: fname => 'FA_GCCID_PKG.fafbgcc',
301: element => 'flex num in fafbgcc is ',
302: value =>h_flex_num, p_log_level_rec => p_log_level_rec);
303: end if;
304:

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

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

Line 395: h_ccid_success := FA_GCCID_PKG.get_ccid(

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

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

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

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', p_log_level_rec => p_log_level_rec);
448: */
449:
450: X_rtn_ccid := -1;

Line 480: FA_SRVR_MSG.ADD_SQL_ERROR ( CALLING_FN => 'FA_GCCID_PKG.fafbgcc', p_log_level_rec => p_log_level_rec);

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

Line 524: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc', p_log_level_rec => g_log_level_rec);

520: -- for pro*c, we need to load the plsql cache for
521: -- book controls and profile options
522: if not FA_CACHE_PKG.fazcbc(X_book_type_code, p_log_level_rec => g_log_level_rec) then
523: FA_SRVR_MSG.ADD_MESSAGE
524: (CALLING_FN => 'FA_GCCID_PKG.fafbgcc', p_log_level_rec => g_log_level_rec);
525: X_return_value := 0;
526: return;
527: end if;
528:

Line 545: fa_srvr_msg.add_message(calling_fn => 'fa_gccid_pkg.fafbgcc', p_log_level_rec => g_log_level_rec);

541: (x_book_type_code => x_book_type_code,
542: x_period_counter => null,
543: x_effective_date => null, p_log_level_rec => g_log_level_rec) then
544: X_return_value := 0;
545: fa_srvr_msg.add_message(calling_fn => 'fa_gccid_pkg.fafbgcc', p_log_level_rec => g_log_level_rec);
546: return;
547: end if;
548: h_val_date := fa_cache_pkg.fazcdp_record.calendar_period_close_date;
549: else

Line 559: h_ccid_success := FA_GCCID_PKG.get_ccid(

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

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

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

Line 582: X_concat_segs := FA_GCCID_PKG.global_concat_segs;

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

Line 585: X_concat_segs := FA_GCCID_PKG.global_concat_segs;

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

Line 589: X_concat_segs := FA_GCCID_PKG.global_concat_segs;

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

Line 879: FA_GCCID_PKG.global_concat_segs :=

875: delim := FND_FLEX_EXT.get_delimiter(
876: application_short_name => 'SQLGL',
877: key_flex_code => 'GL#',
878: structure_number => h_flex_num);
879: FA_GCCID_PKG.global_concat_segs :=
880: FND_FLEX_EXT.concatenate_segments(
881: n_segments => n_segs,
882: segments => all_segments,
883: delimiter => delim);

Line 895: VALUE4 => FA_GCCID_PKG.global_concat_segs

891: VALUE2 => X_book_type_code,
892: TOKEN3 => 'DIST_ID',
893: VALUE3 => X_distribution_id,
894: TOKEN4 => 'CONCAT_SEGS',
895: VALUE4 => FA_GCCID_PKG.global_concat_segs
896: , p_log_level_rec => p_log_level_rec);
897:
898: fnd_message.set_name('FND', 'FLEX-COMBINATION DISABLED');
899: fnd_msg_pub.add; -- end 1504839

Line 952: END FA_GCCID_PKG;

948: end if;
949:
950: end fafbgcc_proc_msg;
951:
952: END FA_GCCID_PKG;