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.GCS_TRANS_DYN_BUILD_PKG dependencies on FND_LOG

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

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

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

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

Line 82: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN

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

Line 88: fnd_log.string(p_level, api_module_concat,

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

Line 373: ad_ddl.build_statement(' IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN', r); r:=r+1;

369: ad_ddl.build_statement(' (p_module VARCHAR2,', r); r:=r+1;
370: ad_ddl.build_statement(' p_action_type VARCHAR2) IS', r); r:=r+1;
371: ad_ddl.build_statement(' BEGIN', r); r:=r+1;
372: ad_ddl.build_statement(' -- Only print if the log level is set at the appropriate level', r); r:=r+1;
373: ad_ddl.build_statement(' IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN', r); r:=r+1;
374: ad_ddl.build_statement(' fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || ''.'' || p_module,', r); r:=r+1;
375: ad_ddl.build_statement(' p_action_type || '' '' || p_module || ''() '' ||', r); r:=r+1;
376: ad_ddl.build_statement(' to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));', r); r:=r+1;
377: ad_ddl.build_statement(' END IF;', r); r:=r+1;

Line 374: ad_ddl.build_statement(' fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || ''.'' || p_module,', r); r:=r+1;

370: ad_ddl.build_statement(' p_action_type VARCHAR2) IS', r); r:=r+1;
371: ad_ddl.build_statement(' BEGIN', r); r:=r+1;
372: ad_ddl.build_statement(' -- Only print if the log level is set at the appropriate level', r); r:=r+1;
373: ad_ddl.build_statement(' IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN', r); r:=r+1;
374: ad_ddl.build_statement(' fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || ''.'' || p_module,', r); r:=r+1;
375: ad_ddl.build_statement(' p_action_type || '' '' || p_module || ''() '' ||', r); r:=r+1;
376: ad_ddl.build_statement(' to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));', r); r:=r+1;
377: ad_ddl.build_statement(' END IF;', r); r:=r+1;
378: ad_ddl.build_statement(' FND_FILE.PUT_LINE(FND_FILE.LOG, p_action_type || '' '' || p_module ||', r); r:=r+1;

Line 407: ad_ddl.build_statement(' IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN', r); r:=r+1;

403: ad_ddl.build_statement(' text_with_date_len NUMBER;', r); r:=r+1;
404: ad_ddl.build_statement(' curr_index NUMBER;', r); r:=r+1;
405: ad_ddl.build_statement(' BEGIN', r); r:=r+1;
406: ad_ddl.build_statement(' -- Only print if the log level is set at the appropriate level', r); r:=r+1;
407: ad_ddl.build_statement(' IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN', r); r:=r+1;
408: ad_ddl.build_statement(' api_module_concat := g_api || ''.'' || p_module;', r); r:=r+1;
409: ad_ddl.build_statement(' text_with_date := to_char(sysdate,''DD-MON-YYYY HH:MI:SS'')||g_nl||p_text;', r); r:=r+1;
410: ad_ddl.build_statement(' text_with_date_len := length(text_with_date);', r); r:=r+1;
411: ad_ddl.build_statement(' curr_index := 1;', r); r:=r+1;

Line 413: ad_ddl.build_statement(' fnd_log.string(p_level, api_module_concat,', r); r:=r+1;

409: ad_ddl.build_statement(' text_with_date := to_char(sysdate,''DD-MON-YYYY HH:MI:SS'')||g_nl||p_text;', r); r:=r+1;
410: ad_ddl.build_statement(' text_with_date_len := length(text_with_date);', r); r:=r+1;
411: ad_ddl.build_statement(' curr_index := 1;', r); r:=r+1;
412: ad_ddl.build_statement(' WHILE curr_index <= text_with_date_len LOOP', r); r:=r+1;
413: ad_ddl.build_statement(' fnd_log.string(p_level, api_module_concat,', r); r:=r+1;
414: ad_ddl.build_statement(' substr(text_with_date, curr_index, 3500));', r); r:=r+1;
415: ad_ddl.build_statement(' curr_index := curr_index + 3500;', r); r:=r+1;
416: ad_ddl.build_statement(' END LOOP;', r); r:=r+1;
417: ad_ddl.build_statement(' END IF;', r); r:=r+1;

Line 537: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);', r); r:=r+1;

533: ad_ddl.build_statement(' p_eq_xlate_mode VARCHAR2,', r); r:=r+1;
534: ad_ddl.build_statement(' p_hier_li_id NUMBER) IS', r); r:=r+1;
535: ad_ddl.build_statement(' module VARCHAR2(30) := ''ROLL_FORWARD_RATES:PUBLIC'';', r); r:=r+1;
536: ad_ddl.build_statement(' BEGIN', r); r:=r+1;
537: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);', r); r:=r+1;
538: ad_ddl.build_statement(' ', r); r:=r+1;
539: ad_ddl.build_statement(' GCS_TRANS_HRATES_DYNAMIC_PKG.Roll_Forward_Historical_Rates', r); r:=r+1;
540: ad_ddl.build_statement(' (p_hier_dataset_code, ', r); r:=r+1;
541: ad_ddl.build_statement(' p_source_system_code, ', r); r:=r+1;

Line 565: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);', r); r:=r+1;

561: ad_ddl.build_statement(' p_to_ccy, ', r); r:=r+1;
562: ad_ddl.build_statement(' p_eq_xlate_mode, ', r); r:=r+1;
563: ad_ddl.build_statement(' p_hier_li_id);', r); r:=r+1;
564: ad_ddl.build_statement(' ', r); r:=r+1;
565: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);', r); r:=r+1;
566: ad_ddl.build_statement(' END Roll_Forward_Rates;', r); r:=r+1;
567: ad_ddl.build_statement(' ', r); r:=r+1;
568: ad_ddl.build_statement(' ', r); r:=r+1;
569: ad_ddl.build_statement('--', r); r:=r+1;

Line 588: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);', r); r:=r+1;

584: ad_ddl.build_statement(' p_round_factor NUMBER,', r); r:=r+1;
585: ad_ddl.build_statement(' p_hier_li_id NUMBER) IS', r); r:=r+1;
586: ad_ddl.build_statement(' module VARCHAR2(50) := ''TRANSLATE_FIRST_EVER_PERIOD:PUBLIC'';', r); r:=r+1;
587: ad_ddl.build_statement(' BEGIN', r); r:=r+1;
588: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);', r); r:=r+1;
589: ad_ddl.build_statement(' ', r); r:=r+1;
590: ad_ddl.build_statement(' GCS_TRANS_HRATES_DYNAMIC_PKG.Trans_HRates_First_Per', r); r:=r+1;
591: ad_ddl.build_statement(' (p_hier_dataset_code,', r); r:=r+1;
592: ad_ddl.build_statement(' p_source_system_code,', r); r:=r+1;

Line 626: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);', r); r:=r+1;

622: ad_ddl.build_statement(' p_round_factor,', r); r:=r+1;
623: ad_ddl.build_statement(' p_hier_li_id);', r); r:=r+1;
624: ad_ddl.build_statement(' END IF;', r); r:=r+1;
625: ad_ddl.build_statement(' ', r); r:=r+1;
626: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);', r); r:=r+1;
627: ad_ddl.build_statement(' END Translate_First_Ever_Period;', r); r:=r+1;
628: ad_ddl.build_statement(' ', r); r:=r+1;
629: ad_ddl.build_statement(' ', r); r:=r+1;
630: ad_ddl.build_statement('--', r); r:=r+1;

Line 650: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);', r); r:=r+1;

646: ad_ddl.build_statement(' p_source_system_code NUMBER,', r); r:=r+1;
647: ad_ddl.build_statement(' p_hier_li_id NUMBER) IS', r); r:=r+1;
648: ad_ddl.build_statement(' module VARCHAR2(50) := ''TRANSLATE_SUBSEQUENT_PERIOD:PUBLIC'';', r); r:=r+1;
649: ad_ddl.build_statement(' BEGIN', r); r:=r+1;
650: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);', r); r:=r+1;
651: ad_ddl.build_statement(' ', r); r:=r+1;
652: ad_ddl.build_statement(' GCS_TRANS_HRATES_DYNAMIC_PKG.Trans_HRates_Subseq_Per', r); r:=r+1;
653: ad_ddl.build_statement(' (p_hier_dataset_code,', r); r:=r+1;
654: ad_ddl.build_statement(' p_cal_period_id,', r); r:=r+1;

Line 690: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);', r); r:=r+1;

686: ad_ddl.build_statement(' p_source_system_code,', r); r:=r+1;
687: ad_ddl.build_statement(' p_hier_li_id);', r); r:=r+1;
688: ad_ddl.build_statement(' END IF;', r); r:=r+1;
689: ad_ddl.build_statement(' ', r); r:=r+1;
690: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);', r); r:=r+1;
691: ad_ddl.build_statement(' END Translate_Subsequent_Period;', r); r:=r+1;
692: ad_ddl.build_statement(' ', r); r:=r+1;
693: ad_ddl.build_statement(' ', r); r:=r+1;
694: ad_ddl.build_statement('-- Create_New_Entry will not split as it does not use gcs_historical_rates table.', r); r:=r+1;

Line 712: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);', r); r:=r+1;

708: ad_ddl.build_statement(' -- Used because we need an IN OUT parameter', r); r:=r+1;
709: ad_ddl.build_statement(' new_entry_id NUMBER := p_new_entry_id;', r); r:=r+1;
710: ad_ddl.build_statement(' ', r); r:=r+1;
711: ad_ddl.build_statement(' BEGIN', r); r:=r+1;
712: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);', r); r:=r+1;
713: ad_ddl.build_statement(' ', r); r:=r+1;
714: ad_ddl.build_statement(' ', r); r:=r+1;
715: ad_ddl.build_statement(' -- Create the entry', r); r:=r+1;
716: ad_ddl.build_statement(' GCS_ENTRY_PKG.create_entry_header(', r); r:=r+1;

Line 736: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_STATEMENT,', r); r:=r+1;

732: ad_ddl.build_statement(' IF retcode IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) THEN', r); r:=r+1;
733: ad_ddl.build_statement(' raise GCS_CCY_ENTRY_CREATE_FAILED;', r); r:=r+1;
734: ad_ddl.build_statement(' END IF;', r); r:=r+1;
735: ad_ddl.build_statement(' ', r); r:=r+1;
736: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_STATEMENT,', r); r:=r+1;
737: ad_ddl.build_statement(' ''INSERT /*+ parallel (gcs_entry_lines) */ INTO gcs_entry_lines(entry_id, '' ||', r); r:=r+1;
738: ad_ddl.build_statement(' ''line_item_id, company_cost_center_org_id, '' ||', r); r:=r+1;
739: ad_ddl.build_statement(' ''intercompany_id, financial_elem_id, product_id, '' ||', r); r:=r+1;
740: ad_ddl.build_statement(' ''natural_account_id, channel_id, project_id, customer_id, task_id, '' ||', r); r:=r+1;

Line 759: ad_ddl.build_statement(' gcs_translation_pkg.g_fnd_login_id || g_nl ||', r); r:=r+1;

755: ad_ddl.build_statement(' ''fxata.number_assign_value * (tgt.xlate_ytd_dr - tgt.xlate_ytd_cr),'' || g_nl ||', r); r:=r+1;
756: ad_ddl.build_statement(' ''tgt.xlate_ptd_dr, tgt.xlate_ptd_cr, tgt.xlate_ytd_dr, tgt.xlate_ytd_cr, sysdate, '' ||', r); r:=r+1;
757: ad_ddl.build_statement(' gcs_translation_pkg.g_fnd_user_id || '', sysdate, '' ||', r); r:=r+1;
758: ad_ddl.build_statement(' gcs_translation_pkg.g_fnd_user_id || '', '' ||', r); r:=r+1;
759: ad_ddl.build_statement(' gcs_translation_pkg.g_fnd_login_id || g_nl ||', r); r:=r+1;
760: ad_ddl.build_statement(' ''FROM gcs_translation_gt, tgt,'' || g_nl ||', r); r:=r+1;
761: ad_ddl.build_statement(' '' fem_ln_items_attr li,'' || g_nl ||', r); r:=r+1;
762: ad_ddl.build_statement(' '' fem_ext_acct_types_attr fxata'' || g_nl ||', r); r:=r+1;
763: ad_ddl.build_statement(' ''WHERE li.line_item_id = tgt.line_item_id'' || g_nl ||', r); r:=r+1;

Line 793: ad_ddl.build_statement(' gcs_translation_pkg.g_fnd_user_id, gcs_translation_pkg.g_fnd_login_id', r); r:=r+1;

789: ad_ddl.build_statement(' tgt.xlate_ytd_dr - tgt.xlate_ytd_cr),', r); r:=r+1;
790: ad_ddl.build_statement(' fxata.number_assign_value * (tgt.xlate_ytd_dr - tgt.xlate_ytd_cr),', r); r:=r+1;
791: ad_ddl.build_statement(' tgt.xlate_ptd_dr, tgt.xlate_ptd_cr, tgt.xlate_ytd_dr, tgt.xlate_ytd_cr,', r); r:=r+1;
792: ad_ddl.build_statement(' sysdate, gcs_translation_pkg.g_fnd_user_id, sysdate,', r); r:=r+1;
793: ad_ddl.build_statement(' gcs_translation_pkg.g_fnd_user_id, gcs_translation_pkg.g_fnd_login_id', r); r:=r+1;
794: ad_ddl.build_statement(' FROM gcs_translation_gt tgt,', r); r:=r+1;
795: ad_ddl.build_statement(' fem_ln_items_attr li,', r); r:=r+1;
796: ad_ddl.build_statement(' fem_ext_acct_types_attr fxata', r); r:=r+1;
797: ad_ddl.build_statement(' WHERE li.line_item_id = tgt.line_item_id', r); r:=r+1;

Line 804: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);', r); r:=r+1;

800: ad_ddl.build_statement(' AND fxata.ext_account_type_code = li.dim_attribute_varchar_member', r); r:=r+1;
801: ad_ddl.build_statement(' AND fxata.attribute_id = gcs_translation_pkg.g_xat_sign_attr_id', r); r:=r+1;
802: ad_ddl.build_statement(' AND fxata.version_id = gcs_translation_pkg.g_xat_sign_v_id;', r); r:=r+1;
803: ad_ddl.build_statement(' ', r); r:=r+1;
804: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);', r); r:=r+1;
805: ad_ddl.build_statement(' EXCEPTION', r); r:=r+1;
806: ad_ddl.build_statement(' WHEN GCS_CCY_ENTRY_CREATE_FAILED THEN', r); r:=r+1;
807: ad_ddl.build_statement(' module_log_write(module, g_module_failure);', r); r:=r+1;
808: ad_ddl.build_statement(' raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;', r); r:=r+1;

Line 812: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);', r); r:=r+1;

808: ad_ddl.build_statement(' raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;', r); r:=r+1;
809: ad_ddl.build_statement(' WHEN OTHERS THEN', r); r:=r+1;
810: ad_ddl.build_statement(' FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_NEW_ENTRY_UNEXP_ERR'');', r); r:=r+1;
811: ad_ddl.build_statement(' GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;', r); r:=r+1;
812: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);', r); r:=r+1;
813: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);', r); r:=r+1;
814: ad_ddl.build_statement(' module_log_write(module, g_module_failure);', r); r:=r+1;
815: ad_ddl.build_statement(' raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;', r); r:=r+1;
816: ad_ddl.build_statement(' ', r); r:=r+1;

Line 813: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);', r); r:=r+1;

809: ad_ddl.build_statement(' WHEN OTHERS THEN', r); r:=r+1;
810: ad_ddl.build_statement(' FND_MESSAGE.set_name(''GCS'', ''GCS_CCY_NEW_ENTRY_UNEXP_ERR'');', r); r:=r+1;
811: ad_ddl.build_statement(' GCS_TRANSLATION_PKG.g_error_text := FND_MESSAGE.get;', r); r:=r+1;
812: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, GCS_TRANSLATION_PKG.g_error_text);', r); r:=r+1;
813: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);', r); r:=r+1;
814: ad_ddl.build_statement(' module_log_write(module, g_module_failure);', r); r:=r+1;
815: ad_ddl.build_statement(' raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;', r); r:=r+1;
816: ad_ddl.build_statement(' ', r); r:=r+1;
817: ad_ddl.build_statement(' ', r); r:=r+1;

Line 818: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);', r); r:=r+1;

814: ad_ddl.build_statement(' module_log_write(module, g_module_failure);', r); r:=r+1;
815: ad_ddl.build_statement(' raise GCS_TRANSLATION_PKG.GCS_CCY_SUBPROGRAM_RAISED;', r); r:=r+1;
816: ad_ddl.build_statement(' ', r); r:=r+1;
817: ad_ddl.build_statement(' ', r); r:=r+1;
818: ad_ddl.build_statement(' write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_success);', r); r:=r+1;
819: ad_ddl.build_statement(' END Create_New_Entry;', r); r:=r+1;
820: ad_ddl.build_statement(' ', r); r:=r+1;
821: ad_ddl.build_statement(' ', r); r:=r+1;
822: ad_ddl.build_statement('END GCS_TRANS_DYNAMIC_PKG;', r);

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

831: EXCEPTION
832: WHEN GCS_CCY_APPLSYS_NOT_FOUND THEN
833: FND_MESSAGE.SET_NAME('GCS', 'GCS_APPLSYS_NOT_FOUND');
834: g_error_text := FND_MESSAGE.get;
835: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
836: x_errbuf := g_error_text;
837: x_retcode := '2';
838: module_log_write(module, g_module_failure);
839: WHEN GCS_CCY_DYN_PKG_BUILD_ERR THEN

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

838: module_log_write(module, g_module_failure);
839: WHEN GCS_CCY_DYN_PKG_BUILD_ERR THEN
840: FND_MESSAGE.set_name('GCS', 'GCS_CCY_DYN_PKG_BUILD_ERR');
841: g_error_text := FND_MESSAGE.get;
842: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
843: x_errbuf := g_error_text;
844: x_retcode := '2';
845: module_log_write(module, g_module_failure);
846: WHEN OTHERS THEN

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

845: module_log_write(module, g_module_failure);
846: WHEN OTHERS THEN
847: FND_MESSAGE.set_name('GCS', 'GCS_CCY_DYN_PKG_ERR');
848: g_error_text := FND_MESSAGE.get;
849: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
850: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
851: x_errbuf := g_error_text;
852: x_retcode := '2';
853: module_log_write(module, g_module_failure);

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

846: WHEN OTHERS THEN
847: FND_MESSAGE.set_name('GCS', 'GCS_CCY_DYN_PKG_ERR');
848: g_error_text := FND_MESSAGE.get;
849: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
850: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
851: x_errbuf := g_error_text;
852: x_retcode := '2';
853: module_log_write(module, g_module_failure);
854: END Create_Package;