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_TRANSLATION_PKG dependencies on FND_LOG

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

78: (p_module VARCHAR2,
79: p_action_type VARCHAR2) IS
80: BEGIN
81: -- Only print if the log level is set at the appropriate level
82: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
83: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || '.' || p_module,
84: p_action_type || ' ' || p_module || '() ' ||
85: to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
86: END IF;

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

79: p_action_type VARCHAR2) IS
80: BEGIN
81: -- Only print if the log level is set at the appropriate level
82: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
83: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_api || '.' || p_module,
84: p_action_type || ' ' || p_module || '() ' ||
85: to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
86: END IF;
87: -- FND_FILE.PUT_LINE(FND_FILE.LOG, p_action_type || ' ' || p_module ||

Line 116: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN

112: text_with_date_len NUMBER;
113: curr_index NUMBER;
114: BEGIN
115: -- Only print if the log level is set at the appropriate level
116: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN
117: api_module_concat := g_api || '.' || p_module;
118: text_with_date := to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||g_nl||p_text;
119: text_with_date_len := length(text_with_date);
120: curr_index := 1;

Line 122: fnd_log.string(p_level, api_module_concat,

118: text_with_date := to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||g_nl||p_text;
119: text_with_date_len := length(text_with_date);
120: curr_index := 1;
121: WHILE curr_index <= text_with_date_len LOOP
122: fnd_log.string(p_level, api_module_concat,
123: substr(text_with_date, curr_index, 3500));
124: curr_index := curr_index + 3500;
125: END LOOP;
126: END IF;

Line 145: g_fnd_login_id := fnd_global.login_id;

141: module := 'SET_GLOBALS';
142: module_log_write(module, g_module_enter);
143:
144: g_fnd_user_id := fnd_global.user_id;
145: g_fnd_login_id := fnd_global.login_id;
146:
147: -- Initialize the dimension attribute and dimension information.
148: GCS_UTILITY_PKG.init_dimension_attr_info;
149: GCS_UTILITY_PKG.init_dimension_info;

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

173: raise GCS_CCY_SUBPROGRAM_RAISED;
174: WHEN OTHERS THEN
175: FND_MESSAGE.set_name('GCS', 'GCS_CCY_GLOBALS_UNEXP_ERR');
176: g_error_text := FND_MESSAGE.get;
177: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
178: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
179: module_log_write(module, g_module_failure);
180: raise GCS_CCY_SUBPROGRAM_RAISED;
181: END Set_Globals;

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

174: WHEN OTHERS THEN
175: FND_MESSAGE.set_name('GCS', 'GCS_CCY_GLOBALS_UNEXP_ERR');
176: g_error_text := FND_MESSAGE.get;
177: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
178: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
179: module_log_write(module, g_module_failure);
180: raise GCS_CCY_SUBPROGRAM_RAISED;
181: END Set_Globals;
182:

Line 428: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

424: module := 'GET_SETUP_DATA';
425: my_lang := userenv('LANG');
426: module_log_write(module, g_module_enter);
427:
428: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
429: 'SELECT rel.hierarchy_id, rel.child_entity_id, ' ||
430: 'rel.parent_entity_id, rel.curr_treatment_id' || g_nl ||
431: 'FROM gcs_cons_relationships rel' || g_nl ||
432: 'WHERE rel.cons_relationship_id = ' || p_cons_relationship_id);

Line 452: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

448: when others then
449: raise GCS_CCY_INVALID_PERIOD;
450: end;
451:
452: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
453: 'SELECT cal_period_name' || g_nl ||
454: 'FROM fem_cal_periods_tl' || g_nl ||
455: 'WHERE cal_period_id = ' || p_cal_period_id || g_nl ||
456: 'AND language = ''' || my_lang || '''');

Line 468: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

464: END IF;
465: CLOSE period_name_c;
466:
467:
468: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
469: 'SELECT balance_by_org_flag, column_name, fem_ledger_id' || g_nl||
470: 'FROM gcs_hierarchies_b' || g_nl ||
471: 'WHERE hierarchy_id = ' || x_hierarchy_id);
472:

Line 483: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

479: END IF;
480: CLOSE hierarchy_c;
481:
482:
483: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
484: 'SELECT specific_intercompany_id' || g_nl||
485: 'FROM gcs_categories_b' || g_nl ||
486: 'WHERE category_code = ''INTRACOMPANY''');
487:

Line 498: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

494: END IF;
495: CLOSE category_c;
496:
497:
498: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
499: 'SELECT equity_mode_code, inc_stmt_mode_code, ending_rate_type, ' ||
500: 'average_rate_type, financial_elem_id, ' ||
501: 'product_id, natural_account_id, channel_id, line_item_id, project_id, ' ||
502: 'customer_id, task_id, cta_user_dim1_id, cta_user_dim2_id, ' ||

Line 527: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

523: raise GCS_CCY_INVALID_CCY_TREAT;
524: END IF;
525: CLOSE curr_treatment_c;
526:
527: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
528: 'SELECT user_conversion_type' || g_nl ||
529: 'FROM gl_daily_conversion_types' || g_nl ||
530: 'WHERE conversion_type = ''' || per_rate_type || '''');
531:

Line 540: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

536: raise GCS_CCY_END_RATE_NOT_FOUND;
537: END IF;
538: CLOSE rate_type_name_c;
539:
540: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
541: 'SELECT user_conversion_type' || g_nl ||
542: 'FROM gl_daily_conversion_types' || g_nl ||
543: 'WHERE conversion_type = ''' || per_avg_rate_type || '''');
544:

Line 555: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

551: CLOSE rate_type_name_c;
552:
553:
554:
555: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
556: 'SELECT eca.currency_code' || g_nl ||
557: 'FROM gcs_entity_cons_attrs eca' || g_nl ||
558: 'WHERE eca.entity_id = ' || x_child_entity_id || g_nl ||
559: 'AND eca.hierarchy_id = ' || x_hierarchy_id);

Line 570: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

566: raise GCS_CCY_INVALID_CHILD;
567: END IF;
568: CLOSE entity_c;
569:
570: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
571: 'SELECT eca.currency_code' || g_nl ||
572: 'FROM gcs_entity_cons_attrs eca' || g_nl ||
573: 'WHERE eca.entity_id = ' || x_parent_entity_id || g_nl ||
574: 'AND eca.hierarchy_id = ' || x_hierarchy_id);

Line 585: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

581: raise GCS_CCY_INVALID_PARENT;
582: END IF;
583: CLOSE entity_c;
584:
585: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
586: 'SELECT fcpa_period_end_date.date_assign_value' || g_nl ||
587: 'FROM fem_cal_periods_attr fcpa_period_end_date' || g_nl ||
588: 'WHERE fcpa_period_end_date.cal_period_id = ' || p_cal_period_id || g_nl ||
589: 'AND fcpa_period_end_date.attribute_id = ' || g_cp_end_date_attr_id || g_nl ||

Line 627: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

623: when others then
624: raise GCS_CCY_NO_AVG_RATE;
625: end;
626:
627: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
628: 'SELECT financial_elem_id, product_id, ' ||
629: 'natural_account_id, channel_id, line_item_id, project_id, customer_id, ' ||
630: 'task_id, user_dim1_id, user_dim2_id, user_dim3_id, user_dim4_id, ' ||
631: 'user_dim5_id, user_dim6_id, user_dim7_id, user_dim8_id, user_dim9_id, ' ||

Line 646: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

642: raise GCS_CCY_NO_RE_TEMPLATE;
643: END IF;
644: CLOSE re_template_c;
645:
646: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
647: 'SELECT nvl(minimum_accountable_unit, power(10, -precision))' || g_nl ||
648: 'FROM fnd_currencies' || g_nl ||
649: 'WHERE currency_code = ''' || x_target_currency || '''');
650:

Line 660: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

656: raise GCS_CCY_INVALID_TARGET_CCY;
657: END IF;
658: CLOSE ccy_mau_c;
659:
660: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
661: 'SELECT decode(earliest_ever_period_id, ' || p_cal_period_id ||
662: ', ''Y'', ''N'')' || g_nl ||
663: 'FROM gcs_translation_track_h' || g_nl ||
664: 'WHERE cons_relationship_id = ' || p_cons_relationship_id || g_nl ||

Line 678: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

674: x_first_ever_period := 'Y';
675: END IF;
676: CLOSE is_earliest_period_c;
677:
678: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
679: 'SELECT source_system_code' || g_nl ||
680: 'FROM fem_source_systems_b' || g_nl ||
681: 'WHERE source_system_display_code = ''GCS''');
682:

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

733: raise GCS_CCY_SUBPROGRAM_RAISED;
734: WHEN GCS_CCY_NO_SS_CODE THEN
735: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_SS_CODE_ERR');
736: g_error_text := FND_MESSAGE.get;
737: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
738: module_log_write(module, g_module_failure);
739: raise GCS_CCY_SUBPROGRAM_RAISED;
740: WHEN GCS_CCY_NO_SPECIFIC_INTERCO THEN
741: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_INTERCO_ERR');

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

739: raise GCS_CCY_SUBPROGRAM_RAISED;
740: WHEN GCS_CCY_NO_SPECIFIC_INTERCO THEN
741: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_INTERCO_ERR');
742: g_error_text := FND_MESSAGE.get;
743: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
744: module_log_write(module, g_module_failure);
745: raise GCS_CCY_SUBPROGRAM_RAISED;
746: WHEN GCS_CCY_INVALID_PERIOD THEN
747: FND_MESSAGE.set_name('GCS', 'GCS_CCY_INVALID_PERIOD_ERR');

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

746: WHEN GCS_CCY_INVALID_PERIOD THEN
747: FND_MESSAGE.set_name('GCS', 'GCS_CCY_INVALID_PERIOD_ERR');
748: FND_MESSAGE.set_token('CAL_PERIOD_ID', p_cal_period_id);
749: g_error_text := FND_MESSAGE.get;
750: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
751: module_log_write(module, g_module_failure);
752: raise GCS_CCY_SUBPROGRAM_RAISED;
753: WHEN GCS_CCY_INVALID_REL THEN
754: FND_MESSAGE.set_name('GCS', 'GCS_CCY_INVALID_REL_ERR');

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

753: WHEN GCS_CCY_INVALID_REL THEN
754: FND_MESSAGE.set_name('GCS', 'GCS_CCY_INVALID_REL_ERR');
755: FND_MESSAGE.set_token('RELATIONSHIP_ID', p_cons_relationship_id);
756: g_error_text := FND_MESSAGE.get;
757: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
758: module_log_write(module, g_module_failure);
759: raise GCS_CCY_SUBPROGRAM_RAISED;
760: WHEN GCS_CCY_INVALID_CCY_TREAT THEN
761: FND_MESSAGE.set_name('GCS', 'GCS_CCY_INVALID_CCY_TREAT_ERR');

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

761: FND_MESSAGE.set_name('GCS', 'GCS_CCY_INVALID_CCY_TREAT_ERR');
762: FND_MESSAGE.set_token('RELATIONSHIP_ID', p_cons_relationship_id);
763: FND_MESSAGE.set_token('TREATMENT_ID', x_curr_treatment_id);
764: g_error_text := FND_MESSAGE.get;
765: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
766: module_log_write(module, g_module_failure);
767: raise GCS_CCY_SUBPROGRAM_RAISED;
768: WHEN GCS_CCY_INVALID_CHILD THEN
769: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_CHILD_ENTITY_ERR');

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

768: WHEN GCS_CCY_INVALID_CHILD THEN
769: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_CHILD_ENTITY_ERR');
770: FND_MESSAGE.set_token('ENTITY_ID', x_child_entity_id);
771: g_error_text := FND_MESSAGE.get;
772: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
773: module_log_write(module, g_module_failure);
774: raise GCS_CCY_SUBPROGRAM_RAISED;
775: WHEN GCS_CCY_INVALID_PARENT THEN
776: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_PARENT_ENTITY_ERR');

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

775: WHEN GCS_CCY_INVALID_PARENT THEN
776: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_PARENT_ENTITY_ERR');
777: FND_MESSAGE.set_token('ENTITY_ID', x_parent_entity_id);
778: g_error_text := FND_MESSAGE.get;
779: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
780: module_log_write(module, g_module_failure);
781: raise GCS_CCY_SUBPROGRAM_RAISED;
782: WHEN GCS_CCY_INVALID_HIERARCHY THEN
783: FND_MESSAGE.set_name('GCS', 'GCS_CCY_INVALID_HIERARCHY_ERR');

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

782: WHEN GCS_CCY_INVALID_HIERARCHY THEN
783: FND_MESSAGE.set_name('GCS', 'GCS_CCY_INVALID_HIERARCHY_ERR');
784: FND_MESSAGE.set_token('HIERARCHY_ID', x_hierarchy_id);
785: g_error_text := FND_MESSAGE.get;
786: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
787: module_log_write(module, g_module_failure);
788: raise GCS_CCY_SUBPROGRAM_RAISED;
789: WHEN GCS_CCY_NO_DATASET THEN
790: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_DATASET_ERR');

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

790: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_DATASET_ERR');
791: FND_MESSAGE.set_token('BAL_TYPE', p_balance_type_code);
792: FND_MESSAGE.set_token('HIERARCHY_ID', x_hierarchy_id);
793: g_error_text := FND_MESSAGE.get;
794: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
795: module_log_write(module, g_module_failure);
796: raise GCS_CCY_SUBPROGRAM_RAISED;
797: WHEN GCS_CCY_NO_END_DATE THEN
798: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_END_DATE_ERR');

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

797: WHEN GCS_CCY_NO_END_DATE THEN
798: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_END_DATE_ERR');
799: FND_MESSAGE.set_token('PERIOD_NAME', period_name);
800: g_error_text := FND_MESSAGE.get;
801: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
802: module_log_write(module, g_module_failure);
803: raise GCS_CCY_SUBPROGRAM_RAISED;
804: WHEN GCS_CCY_AVG_RATE_NOT_FOUND THEN
805: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RATE_NOT_FOUND_ERR');

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

804: WHEN GCS_CCY_AVG_RATE_NOT_FOUND THEN
805: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RATE_NOT_FOUND_ERR');
806: FND_MESSAGE.set_token('RATE_TYPE', per_avg_rate_type);
807: g_error_text := FND_MESSAGE.get;
808: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
809: module_log_write(module, g_module_failure);
810: raise GCS_CCY_SUBPROGRAM_RAISED;
811: WHEN GCS_CCY_END_RATE_NOT_FOUND THEN
812: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RATE_NOT_FOUND_ERR');

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

811: WHEN GCS_CCY_END_RATE_NOT_FOUND THEN
812: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RATE_NOT_FOUND_ERR');
813: FND_MESSAGE.set_token('RATE_TYPE', per_rate_type);
814: g_error_text := FND_MESSAGE.get;
815: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
816: module_log_write(module, g_module_failure);
817: raise GCS_CCY_SUBPROGRAM_RAISED;
818: WHEN GCS_CCY_NO_END_RATE THEN
819: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_END_RATE_ERR');

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

819: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_END_RATE_ERR');
820: FND_MESSAGE.set_token('PERIOD_NAME', period_name);
821: FND_MESSAGE.set_token('RATE_TYPE', x_per_rate_type_name);
822: g_error_text := FND_MESSAGE.get;
823: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
824: module_log_write(module, g_module_failure);
825: raise GCS_CCY_SUBPROGRAM_RAISED;
826: WHEN GCS_CCY_NO_AVG_RATE THEN
827: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_AVG_RATE_ERR');

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

827: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_AVG_RATE_ERR');
828: FND_MESSAGE.set_token('PERIOD_NAME', period_name);
829: FND_MESSAGE.set_token('RATE_TYPE', x_per_avg_rate_type_name);
830: g_error_text := FND_MESSAGE.get;
831: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
832: module_log_write(module, g_module_failure);
833: raise GCS_CCY_SUBPROGRAM_RAISED;
834: WHEN GCS_CCY_NO_RE_TEMPLATE THEN
835: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_RE_TEMPLATE_ERR');

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

834: WHEN GCS_CCY_NO_RE_TEMPLATE THEN
835: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_RE_TEMPLATE_ERR');
836: FND_MESSAGE.set_token('HIERARCHY_ID', x_hierarchy_id);
837: g_error_text := FND_MESSAGE.get;
838: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
839: module_log_write(module, g_module_failure);
840: raise GCS_CCY_SUBPROGRAM_RAISED;
841: WHEN GCS_CCY_INVALID_TARGET_CCY THEN
842: FND_MESSAGE.set_name('GCS', 'GCS_CCY_INFO_NOT_FOUND_ERR');

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

841: WHEN GCS_CCY_INVALID_TARGET_CCY THEN
842: FND_MESSAGE.set_name('GCS', 'GCS_CCY_INFO_NOT_FOUND_ERR');
843: FND_MESSAGE.set_token('CURRENCY', x_target_currency);
844: g_error_text := FND_MESSAGE.get;
845: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
846: module_log_write(module, g_module_failure);
847: raise GCS_CCY_SUBPROGRAM_RAISED;
848: WHEN OTHERS THEN
849: FND_MESSAGE.set_name('GCS', 'GCS_CCY_SETUP_UNEXPECTED_ERR');

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

847: raise GCS_CCY_SUBPROGRAM_RAISED;
848: WHEN OTHERS THEN
849: FND_MESSAGE.set_name('GCS', 'GCS_CCY_SETUP_UNEXPECTED_ERR');
850: g_error_text := FND_MESSAGE.get;
851: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
852: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
853: module_log_write(module, g_module_failure);
854: raise GCS_CCY_SUBPROGRAM_RAISED;
855: END Get_Setup_Data;

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

848: WHEN OTHERS THEN
849: FND_MESSAGE.set_name('GCS', 'GCS_CCY_SETUP_UNEXPECTED_ERR');
850: g_error_text := FND_MESSAGE.get;
851: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
852: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
853: module_log_write(module, g_module_failure);
854: raise GCS_CCY_SUBPROGRAM_RAISED;
855: END Get_Setup_Data;
856:

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

911: raise GCS_CCY_SUBPROGRAM_RAISED;
912: WHEN OTHERS THEN
913: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RE_SEC_TRK_UNEXP_ERR');
914: g_error_text := FND_MESSAGE.get;
915: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
916: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
917: module_log_write(module, g_module_failure);
918: raise GCS_CCY_SUBPROGRAM_RAISED;
919: END Create_RE_Sec_Tracking_Text;

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

912: WHEN OTHERS THEN
913: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RE_SEC_TRK_UNEXP_ERR');
914: g_error_text := FND_MESSAGE.get;
915: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
916: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
917: module_log_write(module, g_module_failure);
918: raise GCS_CCY_SUBPROGRAM_RAISED;
919: END Create_RE_Sec_Tracking_Text;
920:

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

980: raise GCS_CCY_SUBPROGRAM_RAISED;
981: WHEN OTHERS THEN
982: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RE_SEC_TRK_UNEXP_ERR');
983: g_error_text := FND_MESSAGE.get;
984: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
985: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
986: module_log_write(module, g_module_failure);
987: raise GCS_CCY_SUBPROGRAM_RAISED;
988: END Create_RE_Rate_Sec_Track_Text;

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

981: WHEN OTHERS THEN
982: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RE_SEC_TRK_UNEXP_ERR');
983: g_error_text := FND_MESSAGE.get;
984: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
985: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
986: module_log_write(module, g_module_failure);
987: raise GCS_CCY_SUBPROGRAM_RAISED;
988: END Create_RE_Rate_Sec_Track_Text;
989:

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

1098: raise GCS_CCY_SUBPROGRAM_RAISED;
1099: WHEN OTHERS THEN
1100: FND_MESSAGE.set_name('GCS', 'GCS_CCY_ALL_RE_TRK_UNEXP_ERR');
1101: g_error_text := FND_MESSAGE.get;
1102: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
1103: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1104: module_log_write(module, g_module_failure);
1105: raise GCS_CCY_SUBPROGRAM_RAISED;
1106: END Create_All_RE_Tracking_Text;

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

1099: WHEN OTHERS THEN
1100: FND_MESSAGE.set_name('GCS', 'GCS_CCY_ALL_RE_TRK_UNEXP_ERR');
1101: g_error_text := FND_MESSAGE.get;
1102: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
1103: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1104: module_log_write(module, g_module_failure);
1105: raise GCS_CCY_SUBPROGRAM_RAISED;
1106: END Create_All_RE_Tracking_Text;
1107:

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

1224: raise GCS_CCY_SUBPROGRAM_RAISED;
1225: WHEN OTHERS THEN
1226: FND_MESSAGE.set_name('GCS', 'GCS_CCY_ALL_RE_TRK_UNEXP_ERR');
1227: g_error_text := FND_MESSAGE.get;
1228: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
1229: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1230: module_log_write(module, g_module_failure);
1231: raise GCS_CCY_SUBPROGRAM_RAISED;
1232: END Create_All_RE_Rate_Track_Text;

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

1225: WHEN OTHERS THEN
1226: FND_MESSAGE.set_name('GCS', 'GCS_CCY_ALL_RE_TRK_UNEXP_ERR');
1227: g_error_text := FND_MESSAGE.get;
1228: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
1229: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1230: module_log_write(module, g_module_failure);
1231: raise GCS_CCY_SUBPROGRAM_RAISED;
1232: END Create_All_RE_Rate_Track_Text;
1233:

Line 1398: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

1394: 'AND fb.ledger_id = ' || p_ledger_id || g_nl ||
1395: 'AND fb.entity_id = ' || p_entity_id || g_nl ||
1396: ins_join;
1397:
1398: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
1399: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_acct_text);
1400: write_to_log(module, FND_LOG.LEVEL_STATEMENT, pl_text);
1401: write_to_log(module, FND_LOG.LEVEL_STATEMENT, ins_re_text);
1402: write_to_log(module, FND_LOG.LEVEL_STATEMENT, upd_re_text);

Line 1399: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_acct_text);

1395: 'AND fb.entity_id = ' || p_entity_id || g_nl ||
1396: ins_join;
1397:
1398: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
1399: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_acct_text);
1400: write_to_log(module, FND_LOG.LEVEL_STATEMENT, pl_text);
1401: write_to_log(module, FND_LOG.LEVEL_STATEMENT, ins_re_text);
1402: write_to_log(module, FND_LOG.LEVEL_STATEMENT, upd_re_text);
1403: END IF;

Line 1400: write_to_log(module, FND_LOG.LEVEL_STATEMENT, pl_text);

1396: ins_join;
1397:
1398: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
1399: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_acct_text);
1400: write_to_log(module, FND_LOG.LEVEL_STATEMENT, pl_text);
1401: write_to_log(module, FND_LOG.LEVEL_STATEMENT, ins_re_text);
1402: write_to_log(module, FND_LOG.LEVEL_STATEMENT, upd_re_text);
1403: END IF;
1404:

Line 1401: write_to_log(module, FND_LOG.LEVEL_STATEMENT, ins_re_text);

1397:
1398: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
1399: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_acct_text);
1400: write_to_log(module, FND_LOG.LEVEL_STATEMENT, pl_text);
1401: write_to_log(module, FND_LOG.LEVEL_STATEMENT, ins_re_text);
1402: write_to_log(module, FND_LOG.LEVEL_STATEMENT, upd_re_text);
1403: END IF;
1404:
1405:

Line 1402: write_to_log(module, FND_LOG.LEVEL_STATEMENT, upd_re_text);

1398: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
1399: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_acct_text);
1400: write_to_log(module, FND_LOG.LEVEL_STATEMENT, pl_text);
1401: write_to_log(module, FND_LOG.LEVEL_STATEMENT, ins_re_text);
1402: write_to_log(module, FND_LOG.LEVEL_STATEMENT, upd_re_text);
1403: END IF;
1404:
1405:
1406: IF p_sec_dim_col IS NOT NULL AND p_org_track_flag = 'Y' THEN

Line 1411: write_to_log(module, FND_LOG.LEVEL_STATEMENT, dims_cv_text);

1407: dims_cv_text :=
1408: 'SELECT DISTINCT ' || p_sec_dim_col ||
1409: ', COMPANY_COST_CENTER_ORG_ID FROM gcs_translation_gt';
1410:
1411: write_to_log(module, FND_LOG.LEVEL_STATEMENT, dims_cv_text);
1412:
1413: OPEN dims_cv FOR dims_cv_text;
1414: FETCH dims_cv INTO sec_dim_val_id, org_id;
1415: WHILE dims_cv%FOUND LOOP

Line 1475: write_to_log(module, FND_LOG.LEVEL_STATEMENT, dims_cv_text);

1471: ELSIF p_sec_dim_col IS NOT NULL THEN
1472: dims_cv_text := 'SELECT DISTINCT ' || p_sec_dim_col ||
1473: ' FROM gcs_translation_gt';
1474:
1475: write_to_log(module, FND_LOG.LEVEL_STATEMENT, dims_cv_text);
1476:
1477: OPEN dims_cv FOR dims_cv_text;
1478: FETCH dims_cv INTO sec_dim_val_id;
1479: WHILE dims_cv%FOUND LOOP

Line 1516: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

1512: FETCH dims_cv INTO sec_dim_val_id;
1513: END LOOP;
1514: CLOSE dims_cv;
1515: ELSIF p_org_track_flag = 'Y' THEN
1516: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
1517: 'SELECT DISTINCT company_cost_center_org_id org_id FROM gcs_translation_gt');
1518:
1519: FOR org IN all_orgs LOOP
1520: org_id := org.org_id;

Line 1597: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

1593: END IF;
1594: END IF;
1595: END IF;
1596:
1597: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
1598: 'UPDATE GCS_TRANSLATION_GT tg' || g_nl ||
1599: 'SET begin_ytd_dr = 0,' || g_nl ||
1600: ' begin_ytd_cr = 0' || g_nl ||
1601: 'WHERE EXISTS' || g_nl ||

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

1634: raise GCS_CCY_SUBPROGRAM_RAISED;
1635: WHEN GCS_CCY_NO_RE_ACCT_CREATED THEN
1636: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_RE_CREATED_ERR');
1637: g_error_text := FND_MESSAGE.get;
1638: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
1639: module_log_write(module, g_module_failure);
1640: raise GCS_CCY_SUBPROGRAM_RAISED;
1641: WHEN GCS_CCY_NO_RE_ACCT_UPDATED THEN
1642: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_RE_UPDATED_ERR');

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

1640: raise GCS_CCY_SUBPROGRAM_RAISED;
1641: WHEN GCS_CCY_NO_RE_ACCT_UPDATED THEN
1642: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_RE_UPDATED_ERR');
1643: g_error_text := FND_MESSAGE.get;
1644: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
1645: module_log_write(module, g_module_failure);
1646: raise GCS_CCY_SUBPROGRAM_RAISED;
1647: WHEN OTHERS THEN
1648: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RE_UNEXPECTED_ERR');

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

1646: raise GCS_CCY_SUBPROGRAM_RAISED;
1647: WHEN OTHERS THEN
1648: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RE_UNEXPECTED_ERR');
1649: g_error_text := FND_MESSAGE.get;
1650: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
1651: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1652: module_log_write(module, g_module_failure);
1653: raise GCS_CCY_SUBPROGRAM_RAISED;
1654: END Calculate_RE_Amt;

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

1647: WHEN OTHERS THEN
1648: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RE_UNEXPECTED_ERR');
1649: g_error_text := FND_MESSAGE.get;
1650: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
1651: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1652: module_log_write(module, g_module_failure);
1653: raise GCS_CCY_SUBPROGRAM_RAISED;
1654: END Calculate_RE_Amt;
1655:

Line 1803: ' last_update_login = ' || g_fnd_login_id || g_nl ||

1799: ' translated_amount = null,' || g_nl ||
1800: ' rate_type_code = ''C'',' || g_nl ||
1801: ' last_update_date = sysdate,' || g_nl ||
1802: ' last_updated_by = ' || g_fnd_user_id || ',' || g_nl ||
1803: ' last_update_login = ' || g_fnd_login_id || g_nl ||
1804: 'WHERE entity_id = ' || p_entity_id || g_nl ||
1805: 'AND hierarchy_id = ' || p_hierarchy_id || g_nl ||
1806: 'AND from_currency = ''' || p_from_ccy || '''' || g_nl ||
1807: 'AND to_currency = ''' || p_to_ccy || '''' || g_nl ||

Line 1852: ', ' || g_fnd_login_id || ', sysdate, ' || g_fnd_user_id || ')';

1848:
1849:
1850: re_ins_rate := re_ins_rate ||
1851: ':re_rate, null, ''C'', ''N'', ''EQUITY'', ''N'', sysdate, ' || g_fnd_user_id ||
1852: ', ' || g_fnd_login_id || ', sysdate, ' || g_fnd_user_id || ')';
1853:
1854: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
1855: write_to_log(module, FND_LOG.LEVEL_STATEMENT, amounts_text);
1856: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_rate_text);

Line 1854: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

1850: re_ins_rate := re_ins_rate ||
1851: ':re_rate, null, ''C'', ''N'', ''EQUITY'', ''N'', sysdate, ' || g_fnd_user_id ||
1852: ', ' || g_fnd_login_id || ', sysdate, ' || g_fnd_user_id || ')';
1853:
1854: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
1855: write_to_log(module, FND_LOG.LEVEL_STATEMENT, amounts_text);
1856: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_rate_text);
1857: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_ins_rate);
1858: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_upd_rate);

Line 1855: write_to_log(module, FND_LOG.LEVEL_STATEMENT, amounts_text);

1851: ':re_rate, null, ''C'', ''N'', ''EQUITY'', ''N'', sysdate, ' || g_fnd_user_id ||
1852: ', ' || g_fnd_login_id || ', sysdate, ' || g_fnd_user_id || ')';
1853:
1854: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
1855: write_to_log(module, FND_LOG.LEVEL_STATEMENT, amounts_text);
1856: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_rate_text);
1857: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_ins_rate);
1858: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_upd_rate);
1859: END IF;

Line 1856: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_rate_text);

1852: ', ' || g_fnd_login_id || ', sysdate, ' || g_fnd_user_id || ')';
1853:
1854: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
1855: write_to_log(module, FND_LOG.LEVEL_STATEMENT, amounts_text);
1856: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_rate_text);
1857: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_ins_rate);
1858: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_upd_rate);
1859: END IF;
1860:

Line 1857: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_ins_rate);

1853:
1854: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
1855: write_to_log(module, FND_LOG.LEVEL_STATEMENT, amounts_text);
1856: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_rate_text);
1857: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_ins_rate);
1858: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_upd_rate);
1859: END IF;
1860:
1861:

Line 1858: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_upd_rate);

1854: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
1855: write_to_log(module, FND_LOG.LEVEL_STATEMENT, amounts_text);
1856: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_rate_text);
1857: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_ins_rate);
1858: write_to_log(module, FND_LOG.LEVEL_STATEMENT, re_upd_rate);
1859: END IF;
1860:
1861:
1862: IF p_sec_dim_col IS NOT NULL AND p_org_track_flag = 'Y' THEN

Line 1867: write_to_log(module, FND_LOG.LEVEL_STATEMENT, dims_cv_text);

1863: dims_cv_text :=
1864: 'SELECT DISTINCT ' || p_sec_dim_col ||
1865: ', COMPANY_COST_CENTER_ORG_ID FROM gcs_entry_lines where entry_id = ' || p_entry_id;
1866:
1867: write_to_log(module, FND_LOG.LEVEL_STATEMENT, dims_cv_text);
1868:
1869: OPEN dims_cv FOR dims_cv_text;
1870: FETCH dims_cv INTO sec_dim_val_id, org_id;
1871: WHILE dims_cv%FOUND LOOP

Line 1930: write_to_log(module, FND_LOG.LEVEL_STATEMENT, dims_cv_text);

1926: ELSIF p_sec_dim_col IS NOT NULL THEN
1927: dims_cv_text := 'SELECT DISTINCT ' || p_sec_dim_col ||
1928: ' FROM gcs_entry_lines WHERE entry_id = ' || p_entry_id;
1929:
1930: write_to_log(module, FND_LOG.LEVEL_STATEMENT, dims_cv_text);
1931:
1932: OPEN dims_cv FOR dims_cv_text;
1933: FETCH dims_cv INTO sec_dim_val_id;
1934: WHILE dims_cv%FOUND LOOP

Line 1968: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

1964: FETCH dims_cv INTO sec_dim_val_id;
1965: END LOOP;
1966: CLOSE dims_cv;
1967: ELSIF p_org_track_flag = 'Y' THEN
1968: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
1969: 'SELECT DISTINCT company_cost_center_org_id org_id FROM gcs_entry_lines WHERE entry_id = ' || p_entry_id);
1970:
1971: FOR org IN all_orgs LOOP
1972: org_id := org.org_id;

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

2053: raise GCS_CCY_SUBPROGRAM_RAISED;
2054: WHEN GCS_CCY_NO_RATE_CREATED THEN
2055: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_RE_RT_CREATED_ERR');
2056: g_error_text := FND_MESSAGE.get;
2057: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
2058: module_log_write(module, g_module_failure);
2059: raise GCS_CCY_SUBPROGRAM_RAISED;
2060: WHEN GCS_CCY_NO_RATE_UPDATED THEN
2061: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_RE_RT_UPDATED_ERR');

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

2059: raise GCS_CCY_SUBPROGRAM_RAISED;
2060: WHEN GCS_CCY_NO_RATE_UPDATED THEN
2061: FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_RE_RT_UPDATED_ERR');
2062: g_error_text := FND_MESSAGE.get;
2063: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
2064: module_log_write(module, g_module_failure);
2065: raise GCS_CCY_SUBPROGRAM_RAISED;
2066: WHEN OTHERS THEN
2067: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RE_UNEXPECTED_ERR');

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

2065: raise GCS_CCY_SUBPROGRAM_RAISED;
2066: WHEN OTHERS THEN
2067: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RE_UNEXPECTED_ERR');
2068: g_error_text := FND_MESSAGE.get;
2069: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
2070: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
2071: module_log_write(module, g_module_failure);
2072: raise GCS_CCY_SUBPROGRAM_RAISED;
2073: END Calculate_RE_Rate;

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

2066: WHEN OTHERS THEN
2067: FND_MESSAGE.set_name('GCS', 'GCS_CCY_RE_UNEXPECTED_ERR');
2068: g_error_text := FND_MESSAGE.get;
2069: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
2070: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
2071: module_log_write(module, g_module_failure);
2072: raise GCS_CCY_SUBPROGRAM_RAISED;
2073: END Calculate_RE_Rate;
2074:

Line 2091: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

2087: BEGIN
2088: module := 'CALCULATE_XLATED_PTD_YTD';
2089: module_log_write(module, g_module_enter);
2090:
2091: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
2092: 'UPDATE gcs_translation_gt' || g_nl ||
2093: 'SET xlate_ptd_dr = t_amount_dr,' || g_nl ||
2094: ' xlate_ptd_cr = t_amount_cr,' || g_nl ||
2095: ' xlate_ytd_dr = t_amount_dr + begin_ytd_dr,' || g_nl ||

Line 2107: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

2103: xlate_ytd_dr = t_amount_dr + begin_ytd_dr,
2104: xlate_ytd_cr = t_amount_cr + begin_ytd_cr
2105: WHERE translate_rule_code = 'PTD';
2106:
2107: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
2108: 'UPDATE gcs_translation_gt' || g_nl ||
2109: 'SET xlate_ptd_dr = t_amount_dr - begin_ytd_dr,' || g_nl ||
2110: ' xlate_ptd_cr = t_amount_cr - begin_ytd_cr,' || g_nl ||
2111: ' xlate_ytd_dr = t_amount_dr,' || g_nl ||

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

2127: raise GCS_CCY_SUBPROGRAM_RAISED;
2128: WHEN OTHERS THEN
2129: FND_MESSAGE.set_name('GCS', 'GCS_CCY_PTDYTD_UNEXPECTED_ERR');
2130: g_error_text := FND_MESSAGE.get;
2131: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
2132: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
2133: module_log_write(module, g_module_failure);
2134: raise GCS_CCY_SUBPROGRAM_RAISED;
2135: END Calculate_Xlated_PTD_YTD;

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

2128: WHEN OTHERS THEN
2129: FND_MESSAGE.set_name('GCS', 'GCS_CCY_PTDYTD_UNEXPECTED_ERR');
2130: g_error_text := FND_MESSAGE.get;
2131: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
2132: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
2133: module_log_write(module, g_module_failure);
2134: raise GCS_CCY_SUBPROGRAM_RAISED;
2135: END Calculate_Xlated_PTD_YTD;
2136:

Line 2197: g_fnd_user_id, g_fnd_login_id);

2193: last_updated_by, last_update_login)
2194: VALUES(
2195: p_hierarchy_id, p_entity_id, p_currency_code, p_cal_period_id,
2196: p_hier_dataset_code, 'C', '', sysdate, g_fnd_user_id, sysdate,
2197: g_fnd_user_id, g_fnd_login_id);
2198: ELSE
2199: CLOSE status_check_c;
2200: IF status <> 'C' THEN
2201: UPDATE gcs_translation_statuses

Line 2224: g_fnd_user_id, sysdate, g_fnd_login_id);

2220: creation_date, last_updated_by, last_update_date, last_update_login)
2221: VALUES(
2222: p_hierarchy_id, p_entity_id, p_currency_code, p_hier_dataset_code,
2223: p_cal_period_id, p_cal_period_id, g_fnd_user_id, sysdate,
2224: g_fnd_user_id, sysdate, g_fnd_login_id);
2225: ELSE
2226: CLOSE tracking_check_c;
2227: GCS_UTILITY_PKG.get_cal_period_details
2228: (earliest_period_id, earliest_period_info);

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

2286: raise GCS_CCY_SUBPROGRAM_RAISED;
2287: WHEN OTHERS THEN
2288: FND_MESSAGE.set_name('GCS', 'GCS_CCY_TRACK_UNEXPECTED_ERR');
2289: g_error_text := FND_MESSAGE.get;
2290: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
2291: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
2292: module_log_write(module, g_module_failure);
2293: raise GCS_CCY_SUBPROGRAM_RAISED;
2294: END Update_Status_Tracking;

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

2287: WHEN OTHERS THEN
2288: FND_MESSAGE.set_name('GCS', 'GCS_CCY_TRACK_UNEXPECTED_ERR');
2289: g_error_text := FND_MESSAGE.get;
2290: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, g_error_text);
2291: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
2292: module_log_write(module, g_module_failure);
2293: raise GCS_CCY_SUBPROGRAM_RAISED;
2294: END Update_Status_Tracking;
2295:

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

2543: x_retcode := '2';
2544: module_log_write(module, g_module_failure);
2545: WHEN OTHERS THEN
2546: ROLLBACK TO gcs_ccy_translation_start;
2547: write_to_log(module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
2548: x_errbuf := SQLERRM;
2549: x_retcode := '2';
2550: module_log_write(module, g_module_failure);
2551: END Translate;