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_PERIOD_INIT_DYN_BUILD_PKG dependencies on GCS_UTILITY_PKG

Line 29: GCS_UTILITY_PKG.g_module_enter || fn_name ||

25: fn_name := 'BUILD_DIM_STR';
26: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
27: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
28: g_api || '.' || fn_name,
29: GCS_UTILITY_PKG.g_module_enter || fn_name ||
30: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
31: END IF;
32: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
33: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 32: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

28: g_api || '.' || fn_name,
29: GCS_UTILITY_PKG.g_module_enter || fn_name ||
30: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
31: END IF;
32: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
33: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
34:
35: -- **************************************************
36:

Line 37: dim_required := GCS_UTILITY_PKG.get_dimension_required(UPPER(p_dim_col));

33: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
34:
35: -- **************************************************
36:
37: dim_required := GCS_UTILITY_PKG.get_dimension_required(UPPER(p_dim_col));
38:
39: IF (dim_required = 'Y') THEN
40: dim_str := ',
41: decode(p_sec_track_col,

Line 56: GCS_UTILITY_PKG.g_module_success || fn_name ||

52:
53: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
54: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
55: g_api || '.' || fn_name,
56: GCS_UTILITY_PKG.g_module_success || fn_name ||
57: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
58: END IF;
59: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
60: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 59: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

55: g_api || '.' || fn_name,
56: GCS_UTILITY_PKG.g_module_success || fn_name ||
57: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
58: END IF;
59: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
60: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
61:
62: EXCEPTION
63: WHEN OTHERS THEN

Line 67: GCS_UTILITY_PKG.g_module_failure || fn_name ||

63: WHEN OTHERS THEN
64: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
65: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
66: g_api || '.' || fn_name,
67: GCS_UTILITY_PKG.g_module_failure || fn_name ||
68: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
69: END IF;
70: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
71: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 70: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

66: g_api || '.' || fn_name,
67: GCS_UTILITY_PKG.g_module_failure || fn_name ||
68: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
69: END IF;
70: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
71: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
72: RAISE;
73: END build_dim_str;
74:

Line 89: GCS_UTILITY_PKG.g_module_enter || fn_name ||

85: fn_name := 'BUILD_RE_STMT';
86: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
87: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
88: g_api || '.' || fn_name,
89: GCS_UTILITY_PKG.g_module_enter || fn_name ||
90: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
91: END IF;
92: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
93: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 92: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

88: g_api || '.' || fn_name,
89: GCS_UTILITY_PKG.g_module_enter || fn_name ||
90: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
91: END IF;
92: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
93: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
94:
95: -- **************************************************
96:

Line 146: GCS_UTILITY_PKG.g_module_success || fn_name ||

142:
143: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
144: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
145: g_api || '.' || fn_name,
146: GCS_UTILITY_PKG.g_module_success || fn_name ||
147: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
148: END IF;
149: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
150: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 149: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

145: g_api || '.' || fn_name,
146: GCS_UTILITY_PKG.g_module_success || fn_name ||
147: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
148: END IF;
149: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
150: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
151:
152: EXCEPTION
153: WHEN OTHERS THEN

Line 157: GCS_UTILITY_PKG.g_module_failure || fn_name ||

153: WHEN OTHERS THEN
154: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
155: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
156: g_api || '.' || fn_name,
157: GCS_UTILITY_PKG.g_module_failure || fn_name ||
158: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
159: END IF;
160: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
161: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 160: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

156: g_api || '.' || fn_name,
157: GCS_UTILITY_PKG.g_module_failure || fn_name ||
158: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
159: END IF;
160: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
161: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
162: RAISE;
163: END build_re_stmt;
164:

Line 186: GCS_UTILITY_PKG.g_module_enter || fn_name ||

182: fn_name := 'CREATE_PACKAGE';
183: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
185: g_api || '.' || fn_name,
186: GCS_UTILITY_PKG.g_module_enter || fn_name ||
187: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
188: END IF;
189: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
190: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 189: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

185: g_api || '.' || fn_name,
186: GCS_UTILITY_PKG.g_module_enter || fn_name ||
187: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
188: END IF;
189: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
190: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
191:
192: -- initialization
193: GCS_UTILITY_PKG.init_dimension_info;

Line 193: GCS_UTILITY_PKG.init_dimension_info;

189: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
190: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
191:
192: -- initialization
193: GCS_UTILITY_PKG.init_dimension_info;
194: build_re_stmt;
195:
196: body_block :=
197: 'CREATE OR REPLACE PACKAGE BODY GCS_PERIOD_INIT_DYNAMIC_PKG AS

Line 204: g_li_eat_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info

200: --
201: -- PRIVATE GLOBAL VARIABLES
202: --
203: g_api VARCHAR2(40) := ''gcs.plsql.GCS_PERIOD_INIT_DYNAMIC_PKG'';
204: g_li_eat_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
205: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
206: g_li_eat_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
207: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
208: g_acct_type_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info

Line 206: g_li_eat_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info

202: --
203: g_api VARCHAR2(40) := ''gcs.plsql.GCS_PERIOD_INIT_DYNAMIC_PKG'';
204: g_li_eat_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
205: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
206: g_li_eat_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
207: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
208: g_acct_type_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
209: (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
210: g_acct_type_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info

Line 208: g_acct_type_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info

204: g_li_eat_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
205: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
206: g_li_eat_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
207: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
208: g_acct_type_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
209: (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
210: g_acct_type_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
211: (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
212:

Line 210: g_acct_type_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info

206: g_li_eat_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
207: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
208: g_acct_type_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
209: (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
210: g_acct_type_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
211: (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
212:
213:
214: --

Line 264: GCS_UTILITY_PKG.g_module_enter || fn_name ||

260: BEGIN
261: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
263: g_api || ''.'' || fn_name,
264: GCS_UTILITY_PKG.g_module_enter || fn_name ||
265: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
266: END IF;
267:
268: --Bugfix 5449718: Adding information on key parameters

Line 462: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

458: line_num := line_num + 1;
459: END LOOP;
460:
461: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
462: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
463:
464: body_block :=
465: ' xtd_balance_e,
466: ytd_balance_e,

Line 494: ' l2.', GCS_UTILITY_PKG.g_nl, '', line_num);

490: line_num := line_num + 1;
491: END LOOP;
492:
493: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
494: ' l2.', GCS_UTILITY_PKG.g_nl, '', line_num);
495:
496: body_block :=
497: ' decode(feata.dim_attribute_varchar_member,
498: ''REVENUE'', NVL(ytd_credit_balance_e,0) - NVL(ytd_debit_balance_e,0),

Line 559: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

555: line_num := line_num + 1;
556: END LOOP;
557:
558: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
559: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
560:
561: body_block :=
562: ' xtd_balance_e,
563: ytd_balance_e,

Line 589: ' l2.', GCS_UTILITY_PKG.g_nl, '', line_num);

585: line_num := line_num + 1;
586: END LOOP;
587:
588: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
589: ' l2.', GCS_UTILITY_PKG.g_nl, '', line_num);
590:
591: body_block :=
592: ' --XTD Balance should be determined by the line type code
593: DECODE(l2.line_type_code, ''PROFIT_LOSS'', NVL(ytd_credit_balance_e, 0) - NVL(ytd_debit_balance_e, 0),

Line 619: l_default_org_id := GCS_UTILITY_PKG.get_org_id(p_entity_id,

615: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.'' || fn_name, ''Processing for Next Year with Net to RE set to N'');
616: END IF;
617:
618: -- find default org id for RE, in case bal_by_org is ''N''
619: l_default_org_id := GCS_UTILITY_PKG.get_org_id(p_entity_id,
620: p_hierarchy_id);
621:
622: -- find default intercompany id for RE if specified
623: SELECT specific_intercompany_id

Line 661: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

657: line_num := line_num + 1;
658: END LOOP;
659:
660: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
661: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
662:
663: body_block :=
664: ' xtd_balance_e,
665: ytd_balance_e,

Line 745: l_default_org_id := GCS_UTILITY_PKG.get_org_id(p_entity_id,

741: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.'' || fn_name, ''Processing for Next Year with Net to RE set to Y'');
742: END IF;
743:
744: -- find default org id for RE, in case bal_by_org is ''N''
745: l_default_org_id := GCS_UTILITY_PKG.get_org_id(p_entity_id,
746: p_hierarchy_id);
747:
748: -- find default intercompany id for RE if specified
749: SELECT specific_intercompany_id

Line 787: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

783: line_num := line_num + 1;
784: END LOOP;
785:
786: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
787: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
788:
789: body_block :=
790: ' xtd_balance_e,
791: ytd_balance_e,

Line 898: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

894: line_num := line_num + 1;
895: END LOOP;
896:
897: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
898: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
899:
900: body_block :=
901: ' xtd_balance_e,
902: ytd_balance_e,

Line 927: ' l2.', GCS_UTILITY_PKG.g_nl, '', line_num);

923: line_num := line_num + 1;
924: END LOOP;
925:
926: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
927: ' l2.', GCS_UTILITY_PKG.g_nl, '', line_num);
928:
929: body_block := '
930: --Bugfix 5449718: If net to re flag is N then all balances except ptd debit and ptd credit will be zero
931: 0,

Line 983: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

979: line_num := line_num + 1;
980: END LOOP;
981:
982: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
983: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
984:
985: body_block :=
986: '
987: xtd_balance_e,

Line 1016: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

1012: line_num := line_num + 1;
1013: END LOOP;
1014:
1015: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
1016: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
1017:
1018: body_block :=
1019: '
1020: SUM(NVL(xtd_balance_e,0)),

Line 1048: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

1044: line_num := line_num + 1;
1045: END LOOP;
1046:
1047: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
1048: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
1049:
1050: body_block :=
1051: ' intercompany_id;
1052:

Line 1066: GCS_UTILITY_PKG.g_module_success || fn_name ||

1062:
1063: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1064: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1065: g_api || ''.'' || fn_name,
1066: GCS_UTILITY_PKG.g_module_success || fn_name ||
1067: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
1068: END IF;
1069: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
1070: -- fn_name || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));

Line 1069: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

1065: g_api || ''.'' || fn_name,
1066: GCS_UTILITY_PKG.g_module_success || fn_name ||
1067: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
1068: END IF;
1069: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
1070: -- fn_name || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
1071:
1072: EXCEPTION
1073: WHEN OTHERS THEN

Line 1077: GCS_UTILITY_PKG.g_module_failure || fn_name ||

1073: WHEN OTHERS THEN
1074: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1075: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1076: g_api || ''.'' || fn_name,
1077: GCS_UTILITY_PKG.g_module_failure || fn_name ||
1078: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
1079: END IF;
1080: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
1081: fn_name || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));

Line 1080: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

1076: g_api || ''.'' || fn_name,
1077: GCS_UTILITY_PKG.g_module_failure || fn_name ||
1078: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
1079: END IF;
1080: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
1081: fn_name || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
1082: RAISE;
1083: END insert_entry_lines;
1084:

Line 1103: GCS_UTILITY_PKG.g_module_success || fn_name ||

1099:
1100: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1101: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1102: g_api || '.' || fn_name,
1103: GCS_UTILITY_PKG.g_module_success || fn_name ||
1104: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1105: END IF;
1106: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
1107: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 1106: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

1102: g_api || '.' || fn_name,
1103: GCS_UTILITY_PKG.g_module_success || fn_name ||
1104: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1105: END IF;
1106: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
1107: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1108:
1109: EXCEPTION
1110: WHEN OTHERS THEN

Line 1117: GCS_UTILITY_PKG.g_module_failure || fn_name ||

1113: g_api || '.' || fn_name,
1114: SUBSTR(SQLERRM, 1, 4000));
1115: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1116: g_api || '.' || fn_name,
1117: GCS_UTILITY_PKG.g_module_failure || fn_name ||
1118: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1119: END IF;
1120: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
1121: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 1120: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

1116: g_api || '.' || fn_name,
1117: GCS_UTILITY_PKG.g_module_failure || fn_name ||
1118: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1119: END IF;
1120: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
1121: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1122: END create_package;
1123:
1124: