DBA Data[Home] [Help]

APPS.GCS_TRANS_DYNAMIC_PKG dependencies on FND_LOG

Line 44: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN

40: (p_module VARCHAR2,
41: p_action_type VARCHAR2) IS
42: BEGIN
43: -- Only print if the log level is set at the appropriate level
44: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
45: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || '.' || p_module,
46: p_action_type || ' ' || p_module || '() ' ||
47: to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
48: END IF;

Line 45: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || '.' || p_module,

41: p_action_type VARCHAR2) IS
42: BEGIN
43: -- Only print if the log level is set at the appropriate level
44: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
45: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || '.' || p_module,
46: p_action_type || ' ' || p_module || '() ' ||
47: to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
48: END IF;
49: FND_FILE.PUT_LINE(FND_FILE.LOG, p_action_type || ' ' || p_module ||

Line 78: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN

74: text_with_date_len NUMBER;
75: curr_index NUMBER;
76: BEGIN
77: -- Only print if the log level is set at the appropriate level
78: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN
79: api_module_concat := g_api || '.' || p_module;
80: text_with_date := to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||g_nl||p_text;
81: text_with_date_len := length(text_with_date);
82: curr_index := 1;

Line 84: fnd_log.string(p_level, api_module_concat,

80: text_with_date := to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||g_nl||p_text;
81: text_with_date_len := length(text_with_date);
82: curr_index := 1;
83: WHILE curr_index <= text_with_date_len LOOP
84: fnd_log.string(p_level, api_module_concat,
85: substr(text_with_date, curr_index, 3500));
86: curr_index := curr_index + 3500;
87: END LOOP;
88: END IF;

Line 208: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);

204: p_eq_xlate_mode VARCHAR2,
205: p_hier_li_id NUMBER) IS
206: module VARCHAR2(30) := 'ROLL_FORWARD_RATES:PUBLIC';
207: BEGIN
208: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
209:
210: GCS_TRANS_HRATES_DYNAMIC_PKG.Roll_Forward_Historical_Rates
211: (p_hier_dataset_code,
212: p_source_system_code,

Line 236: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);

232: p_to_ccy,
233: p_eq_xlate_mode,
234: p_hier_li_id);
235:
236: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
237: END Roll_Forward_Rates;
238:
239:
240: --

Line 259: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);

255: p_round_factor NUMBER,
256: p_hier_li_id NUMBER) IS
257: module VARCHAR2(50) := 'TRANSLATE_FIRST_EVER_PERIOD:PUBLIC';
258: BEGIN
259: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
260:
261: GCS_TRANS_HRATES_DYNAMIC_PKG.Trans_HRates_First_Per
262: (p_hier_dataset_code,
263: p_source_system_code,

Line 297: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);

293: p_round_factor,
294: p_hier_li_id);
295: END IF;
296:
297: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
298: END Translate_First_Ever_Period;
299:
300:
301: --

Line 321: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);

317: p_source_system_code NUMBER,
318: p_hier_li_id NUMBER) IS
319: module VARCHAR2(50) := 'TRANSLATE_SUBSEQUENT_PERIOD:PUBLIC';
320: BEGIN
321: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
322:
323: GCS_TRANS_HRATES_DYNAMIC_PKG.Trans_HRates_Subseq_Per
324: (p_hier_dataset_code,
325: p_cal_period_id,

Line 361: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);

357: p_source_system_code,
358: p_hier_li_id);
359: END IF;
360:
361: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
362: END Translate_Subsequent_Period;
363:
364:
365: -- Create_New_Entry will not split as it does not use gcs_historical_rates table.

Line 383: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);

379: -- Used because we need an IN OUT parameter
380: new_entry_id NUMBER := p_new_entry_id;
381:
382: BEGIN
383: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
384:
385:
386: -- Create the entry
387: GCS_ENTRY_PKG.create_entry_header(

Line 407: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

403: IF retcode IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) THEN
404: raise GCS_CCY_ENTRY_CREATE_FAILED;
405: END IF;
406:
407: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
408: 'INSERT /*+ parallel (gcs_entry_lines) */ INTO gcs_entry_lines(entry_id, ' ||
409: 'line_item_id, company_cost_center_org_id, ' ||
410: 'intercompany_id, financial_elem_id, product_id, ' ||
411: 'natural_account_id, channel_id, project_id, customer_id, task_id, ' ||

Line 448: gcs_translation_pkg.g_fnd_login_id || g_nl ||

444: 'fxata.number_assign_value * (tgt.xlate_ytd_dr - tgt.xlate_ytd_cr),' || g_nl ||
445: 'tgt.xlate_ptd_dr, tgt.xlate_ptd_cr, tgt.xlate_ytd_dr, tgt.xlate_ytd_cr, sysdate, ' ||
446: gcs_translation_pkg.g_fnd_user_id || ', sysdate, ' ||
447: gcs_translation_pkg.g_fnd_user_id || ', ' ||
448: gcs_translation_pkg.g_fnd_login_id || g_nl ||
449: 'FROM gcs_translation_gt, tgt,' || g_nl ||
450: ' fem_ln_items_attr li,' || g_nl ||
451: ' fem_ext_acct_types_attr fxata' || g_nl ||
452: 'WHERE li.line_item_id = tgt.line_item_id' || g_nl ||

Line 500: gcs_translation_pkg.g_fnd_user_id, gcs_translation_pkg.g_fnd_login_id

496: tgt.xlate_ytd_dr - tgt.xlate_ytd_cr),
497: fxata.number_assign_value * (tgt.xlate_ytd_dr - tgt.xlate_ytd_cr),
498: tgt.xlate_ptd_dr, tgt.xlate_ptd_cr, tgt.xlate_ytd_dr, tgt.xlate_ytd_cr,
499: sysdate, gcs_translation_pkg.g_fnd_user_id, sysdate,
500: gcs_translation_pkg.g_fnd_user_id, gcs_translation_pkg.g_fnd_login_id
501: FROM gcs_translation_gt tgt,
502: fem_ln_items_attr li,
503: fem_ext_acct_types_attr fxata
504: WHERE li.line_item_id = tgt.line_item_id

Line 511: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);

507: AND fxata.ext_account_type_code = li.dim_attribute_varchar_member
508: AND fxata.attribute_id = gcs_translation_pkg.g_xat_sign_attr_id
509: AND fxata.version_id = gcs_translation_pkg.g_xat_sign_v_id;
510:
511: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
512: EXCEPTION
513: WHEN GCS_CCY_ENTRY_CREATE_FAILED THEN
514: module_log_write(module, g_module_failure);
515: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;

Line 519: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);

515: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
516: WHEN OTHERS THEN
517: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NEW_ENTRY_UNEXP_ERR');
518: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
519: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
520: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
521: module_log_write(module, g_module_failure);
522: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
523:

Line 520: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);

516: WHEN OTHERS THEN
517: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NEW_ENTRY_UNEXP_ERR');
518: GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;
519: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);
520: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
521: module_log_write(module, g_module_failure);
522: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
523:
524:

Line 525: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);

521: module_log_write(module, g_module_failure);
522: raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;
523:
524:
525: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);
526: END Create_New_Entry;
527:
528:
529: END GCS_TRANS_DYNAMIC_PKG;