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

Line 30: gcs_utility_pkg.g_dimension_attr_info

26: SELECT dim_attribute_numeric_member
27: FROM fem_entities_attr
28: WHERE entity_id = p_consolidation_entity_id
29: AND attribute_id =
30: gcs_utility_pkg.g_dimension_attr_info
31: ('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
32: AND version_id =
33: gcs_utility_pkg.g_dimension_attr_info
34: ('ENTITY_ID-ELIMINATION_ENTITY').version_id;

Line 33: gcs_utility_pkg.g_dimension_attr_info

29: AND attribute_id =
30: gcs_utility_pkg.g_dimension_attr_info
31: ('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
32: AND version_id =
33: gcs_utility_pkg.g_dimension_attr_info
34: ('ENTITY_ID-ELIMINATION_ENTITY').version_id;
35:
36: l_elim_entity_id NUMBER;
37: l_api_name VARCHAR2 (30) := 'GET_ELIM_ENTITY_ID';

Line 55: gcs_utility_pkg.g_module_failure

51: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
52: THEN
53: fnd_log.STRING (fnd_log.level_error,
54: g_pkg_name || '.' || l_api_name,
55: gcs_utility_pkg.g_module_failure
56: || ' '
57: || SQLERRM
58: || ' '
59: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 101: gcs_utility_pkg.g_module_enter

97: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
98: THEN
99: fnd_log.STRING (fnd_log.level_procedure,
100: g_pkg_name || '.' || l_api_name,
101: gcs_utility_pkg.g_module_enter
102: || ' p_xns_id = '
103: || p_xns_id
104: || ' p_entry_name = '
105: || p_entry_name

Line 136: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id ||'

132: || 'FROM fem_cal_periods_attr fcpa, gcs_ad_transactions gat'
133: || g_nl
134: || ' WHERE fcpa.cal_period_id = gat.cal_period_id
135: AND fcpa.attribute_id = ' ||
136: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id ||'
137: AND fcpa.version_id = ' ||
138: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id ||'
139: AND gat.AD_TRANSACTION_ID = '
140: || p_xns_id

Line 138: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id ||'

134: || ' WHERE fcpa.cal_period_id = gat.cal_period_id
135: AND fcpa.attribute_id = ' ||
136: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id ||'
137: AND fcpa.version_id = ' ||
138: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id ||'
139: AND gat.AD_TRANSACTION_ID = '
140: || p_xns_id
141: );
142: END IF;

Line 149: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id

145: INTO l_entry_id, l_cal_period_id, l_year_to_apply_re
146: FROM fem_cal_periods_attr fcpa, gcs_ad_transactions gat
147: WHERE fcpa.cal_period_id = gat.cal_period_id
148: AND fcpa.attribute_id =
149: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id
150: AND fcpa.version_id =
151: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id
152: AND gat.ad_transaction_id = p_xns_id;
153:

Line 151: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id

147: WHERE fcpa.cal_period_id = gat.cal_period_id
148: AND fcpa.attribute_id =
149: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id
150: AND fcpa.version_id =
151: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id
152: AND gat.ad_transaction_id = p_xns_id;
153:
154:
155: IF l_entry_id IS NULL

Line 389: gcs_utility_pkg.g_module_success

385: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
386: THEN
387: fnd_log.STRING (fnd_log.level_procedure,
388: g_pkg_name || '.' || l_api_name,
389: gcs_utility_pkg.g_module_success
390: || ' '
391: || l_api_name
392: || '() '
393: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 412: gcs_utility_pkg.g_module_failure

408: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
409: THEN
410: fnd_log.STRING (fnd_log.level_error,
411: g_pkg_name || '.' || l_api_name,
412: gcs_utility_pkg.g_module_failure
413: || ' '
414: || l_api_name
415: || '() ' || SQLERRM
416: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 432: gcs_utility_pkg.g_module_failure

428: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
429: THEN
430: fnd_log.STRING (fnd_log.level_error,
431: g_pkg_name || '.' || l_api_name,
432: gcs_utility_pkg.g_module_failure
433: || ' '
434: || l_api_name
435: || '() ' || SQLERRM
436: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 500: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;

496: l_org_code VARCHAR2 (30);
497: p_xns_id NUMBER(15) := TO_NUMBER(p_xns_id_char);
498:
499: l_line_item_vs_id NUMBER :=
500: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
501: l_ext_acct_type_attr NUMBER :=
502: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
503: l_ext_acct_type_version NUMBER :=
504: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;

Line 502: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;

498:
499: l_line_item_vs_id NUMBER :=
500: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
501: l_ext_acct_type_attr NUMBER :=
502: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
503: l_ext_acct_type_version NUMBER :=
504: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
505: l_basic_acct_type_attr NUMBER :=
506: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;

Line 504: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;

500: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
501: l_ext_acct_type_attr NUMBER :=
502: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
503: l_ext_acct_type_version NUMBER :=
504: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
505: l_basic_acct_type_attr NUMBER :=
506: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
507: l_basic_acct_type_version NUMBER :=
508: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;

Line 506: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;

502: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
503: l_ext_acct_type_version NUMBER :=
504: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
505: l_basic_acct_type_attr NUMBER :=
506: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
507: l_basic_acct_type_version NUMBER :=
508: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
509: BEGIN
510:

Line 508: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;

504: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
505: l_basic_acct_type_attr NUMBER :=
506: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
507: l_basic_acct_type_version NUMBER :=
508: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
509: BEGIN
510:
511: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ENTER');
512: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 518: gcs_utility_pkg.g_module_enter

514: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
515: THEN
516: fnd_log.STRING (fnd_log.level_procedure,
517: g_pkg_name || '.' || l_api_name,
518: gcs_utility_pkg.g_module_enter
519: || ' p_xns_id = '
520: || p_xns_id
521: || ' p_entry_name = '
522: || p_entry_name

Line 615: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id || '

611: fem_ln_items_attr flia
612: WHERE gcs_entry_lines.line_item_id =
613: flia.line_item_id
614: AND flia.value_set_id =' ||
615: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id || '
616: AND flia.attribute_id = '||
617: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || '
618: AND flia.version_id = '||
619: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || '

Line 617: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || '

613: flia.line_item_id
614: AND flia.value_set_id =' ||
615: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id || '
616: AND flia.attribute_id = '||
617: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || '
618: AND flia.version_id = '||
619: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || '
620: AND feata.attribute_id = '||
621: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id || '

Line 619: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || '

615: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id || '
616: AND flia.attribute_id = '||
617: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || '
618: AND flia.version_id = '||
619: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || '
620: AND feata.attribute_id = '||
621: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id || '
622: AND feata.version_id = '||
623: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id || '

Line 621: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id || '

617: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || '
618: AND flia.version_id = '||
619: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || '
620: AND feata.attribute_id = '||
621: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id || '
622: AND feata.version_id = '||
623: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id || '
624: AND feata.ext_account_type_code =
625: flia.dim_attribute_varchar_member), ''REVENUE'', ''PROFIT_LOSS'',

Line 623: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id || '

619: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || '
620: AND feata.attribute_id = '||
621: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id || '
622: AND feata.version_id = '||
623: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id || '
624: AND feata.ext_account_type_code =
625: flia.dim_attribute_varchar_member), ''REVENUE'', ''PROFIT_LOSS'',
626: ''EXPENSE'', ''PROFIT_LOSS'', ''BALANCE_SHEET'') '
627: || g_nl

Line 721: gcs_utility_pkg.g_module_failure

717: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
718: THEN
719: fnd_log.STRING (fnd_log.level_error,
720: g_pkg_name || '.' || l_api_name,
721: gcs_utility_pkg.g_module_failure
722: || ' entry XML Gen failed: '
723: || SQLERRM
724: || ' '
725: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 772: gcs_utility_pkg.g_module_failure

768: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
769: THEN
770: fnd_log.STRING (fnd_log.level_error,
771: g_pkg_name || '.' || l_api_name,
772: gcs_utility_pkg.g_module_failure
773: || ' '
774: || SQLERRM
775: || ' '
776: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 787: gcs_utility_pkg.g_module_success

783: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
784: THEN
785: fnd_log.STRING (fnd_log.level_procedure,
786: g_pkg_name || '.' || l_api_name,
787: gcs_utility_pkg.g_module_success
788: || ' '
789: || l_api_name
790: || '() '
791: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 811: gcs_utility_pkg.g_module_failure

807: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
808: THEN
809: fnd_log.STRING (fnd_log.level_error,
810: g_pkg_name || '.' || l_api_name,
811: gcs_utility_pkg.g_module_failure
812: || ' '
813: || x_errbuf
814: || ' '
815: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 832: gcs_utility_pkg.g_module_failure

828: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
829: THEN
830: fnd_log.STRING (fnd_log.level_error,
831: g_pkg_name || '.' || l_api_name,
832: gcs_utility_pkg.g_module_failure
833: || ' '
834: || x_errbuf
835: || ' '
836: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 877: gcs_utility_pkg.g_module_enter

873: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
874: THEN
875: fnd_log.STRING (fnd_log.level_procedure,
876: g_pkg_name || '.' || l_api_name,
877: gcs_utility_pkg.g_module_enter
878: || ' p_xns_id = '
879: || p_xns_id
880: || ' p_entry_name = '
881: || p_entry_name

Line 1010: gcs_utility_pkg.g_module_failure

1006: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1007: THEN
1008: fnd_log.STRING (fnd_log.level_error,
1009: g_pkg_name || '.' || l_api_name,
1010: gcs_utility_pkg.g_module_failure
1011: || ' XML Gen failed: '
1012: || SQLERRM
1013: || ' '
1014: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1036: gcs_utility_pkg.g_module_failure

1032: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1033: THEN
1034: fnd_log.STRING (fnd_log.level_procedure,
1035: g_pkg_name || '.' || l_api_name,
1036: gcs_utility_pkg.g_module_failure
1037: || ' AD_ENGINE failed '
1038: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1039: );
1040: END IF;

Line 1060: gcs_utility_pkg.g_module_failure

1056: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1057: THEN
1058: fnd_log.STRING (fnd_log.level_error,
1059: g_pkg_name || '.' || l_api_name,
1060: gcs_utility_pkg.g_module_failure
1061: || ' XML Gen failed: '
1062: || SQLERRM
1063: || ' '
1064: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1111: gcs_utility_pkg.g_module_failure

1107: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1108: THEN
1109: fnd_log.STRING (fnd_log.level_error,
1110: g_pkg_name || '.' || l_api_name,
1111: gcs_utility_pkg.g_module_failure
1112: || ' '
1113: || SQLERRM
1114: || ' '
1115: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1129: gcs_utility_pkg.g_module_success

1125: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1126: THEN
1127: fnd_log.STRING (fnd_log.level_procedure,
1128: g_pkg_name || '.' || l_api_name,
1129: gcs_utility_pkg.g_module_success
1130: || ' '
1131: || l_api_name
1132: || '() '
1133: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1153: gcs_utility_pkg.g_module_failure

1149: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1150: THEN
1151: fnd_log.STRING (fnd_log.level_error,
1152: g_pkg_name || '.' || l_api_name,
1153: gcs_utility_pkg.g_module_failure
1154: || ' '
1155: || x_errbuf
1156: || '() '
1157: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1194: gcs_utility_pkg.g_module_enter

1190: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1191: THEN
1192: fnd_log.STRING (fnd_log.level_procedure,
1193: g_pkg_name || '.' || l_api_name,
1194: gcs_utility_pkg.g_module_enter
1195: || ' p_xns_id = '
1196: || p_xns_id
1197: || ' '
1198: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1288: gcs_utility_pkg.g_module_success

1284: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1285: THEN
1286: fnd_log.STRING (fnd_log.level_procedure,
1287: g_pkg_name || '.' || l_api_name,
1288: gcs_utility_pkg.g_module_success
1289: || ' '
1290: || l_api_name
1291: || '() '
1292: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1306: gcs_utility_pkg.g_module_failure

1302: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1303: THEN
1304: fnd_log.STRING (fnd_log.level_error,
1305: g_pkg_name || '.' || l_api_name,
1306: gcs_utility_pkg.g_module_failure
1307: || ' '
1308: || x_errbuf
1309: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1310: );