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

Line 65: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

61: l_org_id NUMBER;
62: l_re_required VARCHAR2(1);
63: l_api_name VARCHAR2 (30) := 'CALCULATE_RE';
64: BEGIN
65: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
66: THEN
67: fnd_log.STRING (fnd_log.level_procedure,
68: g_pkg_name || '.' || l_api_name,
69: gcs_utility_pkg.g_module_enter

Line 67: fnd_log.STRING (fnd_log.level_procedure,

63: l_api_name VARCHAR2 (30) := 'CALCULATE_RE';
64: BEGIN
65: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
66: THEN
67: fnd_log.STRING (fnd_log.level_procedure,
68: g_pkg_name || '.' || l_api_name,
69: gcs_utility_pkg.g_module_enter
70: || ' '
71: || l_api_name

Line 77: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

73: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
74: );
75: END IF;
76:
77: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
78: THEN
79: fnd_log.STRING (fnd_log.level_statement,
80: g_pkg_name || '.' || l_api_name,
81: 'SELECT ''X'''

Line 79: fnd_log.STRING (fnd_log.level_statement,

75: END IF;
76:
77: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
78: THEN
79: fnd_log.STRING (fnd_log.level_statement,
80: g_pkg_name || '.' || l_api_name,
81: 'SELECT ''X'''
82: || g_nl
83: || 'FROM gcs_entry_headers '

Line 107: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

103: ELSE
104: l_re_required := 'Y';
105: END IF;
106:
107: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
108: THEN
109: fnd_log.STRING (fnd_log.level_statement,
110: g_pkg_name || '.' || l_api_name,
111: 'SELECT hb.balance_by_org_flag, hb.column_name'

Line 109: fnd_log.STRING (fnd_log.level_statement,

105: END IF;
106:
107: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
108: THEN
109: fnd_log.STRING (fnd_log.level_statement,
110: g_pkg_name || '.' || l_api_name,
111: 'SELECT hb.balance_by_org_flag, hb.column_name'
112: || g_nl
113: || 'FROM gcs_hierarchies_b hb '

Line 135: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

131: END IF;
132:
133: CLOSE hierarchy_c;
134:
135: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
136: THEN
137: fnd_log.STRING (fnd_log.level_statement,
138: g_pkg_name || '.' || l_api_name,
139: 'SELECT specific_intercompany_id FROM gcs_hierarchies_b '

Line 137: fnd_log.STRING (fnd_log.level_statement,

133: CLOSE hierarchy_c;
134:
135: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
136: THEN
137: fnd_log.STRING (fnd_log.level_statement,
138: g_pkg_name || '.' || l_api_name,
139: 'SELECT specific_intercompany_id FROM gcs_hierarchies_b '
140: || ' WHERE hierarchy_id = ' || p_hierarchy_id
141: || ' AND INTERCOMPANY_ORG_TYPE_CODE = ''SPECIFIC_VALUE''');

Line 153: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

149:
150: CLOSE intercompany_c;
151:
152: -- Get the signage of the suspense line item
153: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
154: THEN
155: fnd_log.STRING (fnd_log.level_statement,
156: g_pkg_name || '.' || l_api_name,
157: 'SELECT fxata.number_assign_value' || g_nl ||

Line 155: fnd_log.STRING (fnd_log.level_statement,

151:
152: -- Get the signage of the suspense line item
153: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
154: THEN
155: fnd_log.STRING (fnd_log.level_statement,
156: g_pkg_name || '.' || l_api_name,
157: 'SELECT fxata.number_assign_value' || g_nl ||
158: 'FROM gcs_dimension_templates dt, ' || g_nl ||
159: ' fem_ln_items_attr flia,' || g_nl ||

Line 191: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

187: IF org_tracking_flag = 'N'
188: THEN
189: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,
190: p_hierarchy_id => p_hierarchy_id);
191: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
192: THEN
193: fnd_log.STRING (fnd_log.level_statement,
194: g_pkg_name || '.' || l_api_name,
195: 'l_org_id = ' || l_org_id

Line 193: fnd_log.STRING (fnd_log.level_statement,

189: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,
190: p_hierarchy_id => p_hierarchy_id);
191: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
192: THEN
193: fnd_log.STRING (fnd_log.level_statement,
194: g_pkg_name || '.' || l_api_name,
195: 'l_org_id = ' || l_org_id
196: );
197: END IF;

Line 264: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

260: decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
261: SYSDATE, :3, SYSDATE, :3, :4)
262: ';
263:
264: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
265: THEN
266: fnd_log.STRING (fnd_log.level_statement,
267: g_pkg_name || '.' || l_api_name,
268: 'l_merge_statement = '|| l_merge_statement

Line 266: fnd_log.STRING (fnd_log.level_statement,

262: ';
263:
264: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
265: THEN
266: fnd_log.STRING (fnd_log.level_statement,
267: g_pkg_name || '.' || l_api_name,
268: 'l_merge_statement = '|| l_merge_statement
269: );
270: END IF;

Line 344: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

340: decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
341: SYSDATE, :3, SYSDATE, :3, :4)
342: ';
343:
344: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
345: THEN
346: fnd_log.STRING (fnd_log.level_statement,
347: g_pkg_name || '.' || l_api_name,
348: 'l_merge_statement = '|| l_merge_statement

Line 346: fnd_log.STRING (fnd_log.level_statement,

342: ';
343:
344: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
345: THEN
346: fnd_log.STRING (fnd_log.level_statement,
347: g_pkg_name || '.' || l_api_name,
348: 'l_merge_statement = '|| l_merge_statement
349: );
350: END IF;

Line 423: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

419: decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
420: SYSDATE, :3, SYSDATE, :3, :4)
421: ';
422:
423: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
424: THEN
425: fnd_log.STRING (fnd_log.level_statement,
426: g_pkg_name || '.' || l_api_name,
427: 'l_merge_statement = '|| l_merge_statement

Line 425: fnd_log.STRING (fnd_log.level_statement,

421: ';
422:
423: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
424: THEN
425: fnd_log.STRING (fnd_log.level_statement,
426: g_pkg_name || '.' || l_api_name,
427: 'l_merge_statement = '|| l_merge_statement
428: );
429: END IF;

Line 500: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

496: decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
497: SYSDATE, :3, SYSDATE, :3, :4)
498: ';
499:
500: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
501: THEN
502: fnd_log.STRING (fnd_log.level_statement,
503: g_pkg_name || '.' || l_api_name,
504: 'l_merge_statement = '|| l_merge_statement

Line 502: fnd_log.STRING (fnd_log.level_statement,

498: ';
499:
500: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
501: THEN
502: fnd_log.STRING (fnd_log.level_statement,
503: g_pkg_name || '.' || l_api_name,
504: 'l_merge_statement = '|| l_merge_statement
505: );
506: END IF;

Line 522: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

518: fnd_global.user_id,
519: fnd_global.login_id;
520: END IF;
521:
522: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
523: THEN
524: fnd_log.STRING (fnd_log.level_procedure,
525: g_pkg_name || '.' || l_api_name,
526: gcs_utility_pkg.g_module_success

Line 524: fnd_log.STRING (fnd_log.level_procedure,

520: END IF;
521:
522: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
523: THEN
524: fnd_log.STRING (fnd_log.level_procedure,
525: g_pkg_name || '.' || l_api_name,
526: gcs_utility_pkg.g_module_success
527: || ' '
528: || l_api_name

Line 538: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

534: WHEN gcs_tmp_invalid_sign
535: THEN
536: fnd_message.set_name ('GCS', 'GCS_TMP_INVALID_SIGN');
537:
538: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
539: THEN
540: fnd_log.STRING (fnd_log.level_procedure,
541: g_pkg_name || '.' || l_api_name,
542: gcs_utility_pkg.g_module_failure

Line 540: fnd_log.STRING (fnd_log.level_procedure,

536: fnd_message.set_name ('GCS', 'GCS_TMP_INVALID_SIGN');
537:
538: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
539: THEN
540: fnd_log.STRING (fnd_log.level_procedure,
541: g_pkg_name || '.' || l_api_name,
542: gcs_utility_pkg.g_module_failure
543: || ' '
544: || l_api_name

Line 597: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

593: l_org_id NUMBER;
594: l_api_name VARCHAR2 (30) := 'CALCULATE_DP_RE';
595: BEGIN
596:
597: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
598: THEN
599: fnd_log.STRING (fnd_log.level_statement,
600: g_pkg_name || '.' || l_api_name,
601: 'SELECT hb.balance_by_org_flag, hb.column_name'

Line 599: fnd_log.STRING (fnd_log.level_statement,

595: BEGIN
596:
597: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
598: THEN
599: fnd_log.STRING (fnd_log.level_statement,
600: g_pkg_name || '.' || l_api_name,
601: 'SELECT hb.balance_by_org_flag, hb.column_name'
602: || g_nl
603: || 'FROM gcs_hierarchies_b hb '

Line 635: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

631: END IF;
632:
633: CLOSE hierarchy_c;
634:
635: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
636: THEN
637: fnd_log.STRING (fnd_log.level_statement,
638: g_pkg_name || '.' || l_api_name,
639: 'SELECT specific_intercompany_id FROM gcs_hierarchies_b '

Line 637: fnd_log.STRING (fnd_log.level_statement,

633: CLOSE hierarchy_c;
634:
635: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
636: THEN
637: fnd_log.STRING (fnd_log.level_statement,
638: g_pkg_name || '.' || l_api_name,
639: 'SELECT specific_intercompany_id FROM gcs_hierarchies_b '
640: || ' WHERE hierarchy_id = ' || p_hierarchy_id
641: || ' AND INTERCOMPANY_ORG_TYPE_CODE = ''SPECIFIC_VALUE''');

Line 653: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

649:
650: CLOSE intercompany_c;
651:
652: -- Get the signage of the suspense line item
653: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
654: THEN
655: fnd_log.STRING (fnd_log.level_statement,
656: g_pkg_name || '.' || l_api_name,
657: 'SELECT fxata.number_assign_value' || g_nl ||

Line 655: fnd_log.STRING (fnd_log.level_statement,

651:
652: -- Get the signage of the suspense line item
653: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
654: THEN
655: fnd_log.STRING (fnd_log.level_statement,
656: g_pkg_name || '.' || l_api_name,
657: 'SELECT fxata.number_assign_value' || g_nl ||
658: 'FROM gcs_dimension_templates dt' || g_nl ||
659: ' fem_ln_items_attr flia,' || g_nl ||

Line 691: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

687: IF org_tracking_flag = 'N'
688: THEN
689: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,
690: p_hierarchy_id => p_hierarchy_id);
691: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
692: THEN
693: fnd_log.STRING (fnd_log.level_statement,
694: g_pkg_name || '.' || l_api_name,
695: 'l_org_id = ' || l_org_id

Line 693: fnd_log.STRING (fnd_log.level_statement,

689: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,
690: p_hierarchy_id => p_hierarchy_id);
691: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
692: THEN
693: fnd_log.STRING (fnd_log.level_statement,
694: g_pkg_name || '.' || l_api_name,
695: 'l_org_id = ' || l_org_id
696: );
697: END IF;

Line 768: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

764: decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
765: SYSDATE, :3, SYSDATE, :3, :4)
766: ';
767:
768: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
769: THEN
770: fnd_log.STRING (fnd_log.level_statement,
771: g_pkg_name || '.' || l_api_name,
772: 'l_merge_statement = '|| l_merge_statement

Line 770: fnd_log.STRING (fnd_log.level_statement,

766: ';
767:
768: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
769: THEN
770: fnd_log.STRING (fnd_log.level_statement,
771: g_pkg_name || '.' || l_api_name,
772: 'l_merge_statement = '|| l_merge_statement
773: );
774: END IF;

Line 853: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

849: decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
850: SYSDATE, :3, SYSDATE, :3, :4)
851: ';
852:
853: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
854: THEN
855: fnd_log.STRING (fnd_log.level_statement,
856: g_pkg_name || '.' || l_api_name,
857: 'l_merge_statement = '|| l_merge_statement

Line 855: fnd_log.STRING (fnd_log.level_statement,

851: ';
852:
853: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
854: THEN
855: fnd_log.STRING (fnd_log.level_statement,
856: g_pkg_name || '.' || l_api_name,
857: 'l_merge_statement = '|| l_merge_statement
858: );
859: END IF;

Line 936: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

932: decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
933: SYSDATE, :3, SYSDATE, :3, :4)
934: ';
935:
936: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
937: THEN
938: fnd_log.STRING (fnd_log.level_statement,
939: g_pkg_name || '.' || l_api_name,
940: 'l_merge_statement = '|| l_merge_statement

Line 938: fnd_log.STRING (fnd_log.level_statement,

934: ';
935:
936: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
937: THEN
938: fnd_log.STRING (fnd_log.level_statement,
939: g_pkg_name || '.' || l_api_name,
940: 'l_merge_statement = '|| l_merge_statement
941: );
942: END IF;

Line 1017: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1013: decode(sign(src.amount), 1, 0, -src.amount), decode(sign(src.amount), 1, src.amount, 0),
1014: SYSDATE, :3, SYSDATE, :3, :4)
1015: ';
1016:
1017: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1018: THEN
1019: fnd_log.STRING (fnd_log.level_statement,
1020: g_pkg_name || '.' || l_api_name,
1021: 'l_merge_statement = '|| l_merge_statement

Line 1019: fnd_log.STRING (fnd_log.level_statement,

1015: ';
1016:
1017: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1018: THEN
1019: fnd_log.STRING (fnd_log.level_statement,
1020: g_pkg_name || '.' || l_api_name,
1021: 'l_merge_statement = '|| l_merge_statement
1022: );
1023: END IF;

Line 1044: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

1040: WHEN gcs_tmp_invalid_sign
1041: THEN
1042: fnd_message.set_name ('GCS', 'GCS_TMP_INVALID_SIGN');
1043:
1044: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1045: THEN
1046: fnd_log.STRING (fnd_log.level_procedure,
1047: g_pkg_name || '.' || l_api_name,
1048: gcs_utility_pkg.g_module_failure

Line 1046: fnd_log.STRING (fnd_log.level_procedure,

1042: fnd_message.set_name ('GCS', 'GCS_TMP_INVALID_SIGN');
1043:
1044: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1045: THEN
1046: fnd_log.STRING (fnd_log.level_procedure,
1047: g_pkg_name || '.' || l_api_name,
1048: gcs_utility_pkg.g_module_failure
1049: || ' '
1050: || l_api_name

Line 1119: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

1115: l_threshold_amount NUMBER;
1116: l_api_name VARCHAR2 (30) := 'BALANCE';
1117: l_enforce_balancing_flag VARCHAR2(1); -- Bug 5085697 : SMATAM
1118: BEGIN
1119: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1120: THEN
1121: fnd_log.STRING (fnd_log.level_procedure,
1122: g_pkg_name || '.' || l_api_name,
1123: gcs_utility_pkg.g_module_enter

Line 1121: fnd_log.STRING (fnd_log.level_procedure,

1117: l_enforce_balancing_flag VARCHAR2(1); -- Bug 5085697 : SMATAM
1118: BEGIN
1119: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1120: THEN
1121: fnd_log.STRING (fnd_log.level_procedure,
1122: g_pkg_name || '.' || l_api_name,
1123: gcs_utility_pkg.g_module_enter
1124: || ' '
1125: || l_api_name

Line 1131: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

1127: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1128: );
1129: END IF;
1130: -- Bug 5085697 : start : SMATAM
1131: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1132: fnd_log.STRING(fnd_log.level_statement,
1133: g_pkg_name || '.' || l_api_name,
1134: 'SELECT enforce_balancing_flag' || g_nl ||
1135: 'FROM gcs_data_type_codes_b ' || g_nl ||

Line 1132: fnd_log.STRING(fnd_log.level_statement,

1128: );
1129: END IF;
1130: -- Bug 5085697 : start : SMATAM
1131: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1132: fnd_log.STRING(fnd_log.level_statement,
1133: g_pkg_name || '.' || l_api_name,
1134: 'SELECT enforce_balancing_flag' || g_nl ||
1135: 'FROM gcs_data_type_codes_b ' || g_nl ||
1136: 'WHERE data_type_code = ' || p_bal_type_code);

Line 1145: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

1141: WHERE data_type_code = p_bal_type_code;
1142:
1143: IF (l_enforce_balancing_flag IS NULL OR l_enforce_balancing_flag = 'N') THEN
1144: --Log that no balancing is needed
1145: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1146: fnd_log.STRING(fnd_log.level_statement,
1147: g_pkg_name || '.' || l_api_name,
1148: 'No Balancing is required for the balance_type_code, ' || p_bal_type_code);
1149: END IF;

Line 1146: fnd_log.STRING(fnd_log.level_statement,

1142:
1143: IF (l_enforce_balancing_flag IS NULL OR l_enforce_balancing_flag = 'N') THEN
1144: --Log that no balancing is needed
1145: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1146: fnd_log.STRING(fnd_log.level_statement,
1147: g_pkg_name || '.' || l_api_name,
1148: 'No Balancing is required for the balance_type_code, ' || p_bal_type_code);
1149: END IF;
1150: return;

Line 1154: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1150: return;
1151: END IF;
1152:
1153: -- Bug 5085697 : End : SMATAM
1154: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1155: THEN
1156: fnd_log.STRING (fnd_log.level_statement,
1157: g_pkg_name || '.' || l_api_name,
1158: 'SELECT hb.balance_by_org_flag, hb.column_name'

Line 1156: fnd_log.STRING (fnd_log.level_statement,

1152:
1153: -- Bug 5085697 : End : SMATAM
1154: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1155: THEN
1156: fnd_log.STRING (fnd_log.level_statement,
1157: g_pkg_name || '.' || l_api_name,
1158: 'SELECT hb.balance_by_org_flag, hb.column_name'
1159: || g_nl
1160: || 'FROM gcs_hierarchies_b hb '

Line 1182: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1178: END IF;
1179:
1180: CLOSE hierarchy_c;
1181:
1182: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1183: THEN
1184: fnd_log.STRING (fnd_log.level_statement,
1185: g_pkg_name || '.' || l_api_name,
1186: 'SELECT category_code'

Line 1184: fnd_log.STRING (fnd_log.level_statement,

1180: CLOSE hierarchy_c;
1181:
1182: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1183: THEN
1184: fnd_log.STRING (fnd_log.level_statement,
1185: g_pkg_name || '.' || l_api_name,
1186: 'SELECT category_code'
1187: || g_nl
1188: || 'FROM gcs_entry_headers '

Line 1205: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1201: CLOSE category_c;
1202:
1203: -- end of bug fix 3797306
1204:
1205: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1206: THEN
1207: fnd_log.STRING (fnd_log.level_statement,
1208: g_pkg_name || '.' || l_api_name,
1209: 'SELECT specific_intercompany_id FROM gcs_hierarchies_b '

Line 1207: fnd_log.STRING (fnd_log.level_statement,

1203: -- end of bug fix 3797306
1204:
1205: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1206: THEN
1207: fnd_log.STRING (fnd_log.level_statement,
1208: g_pkg_name || '.' || l_api_name,
1209: 'SELECT specific_intercompany_id FROM gcs_hierarchies_b '
1210: || ' WHERE hierarchy_id = ' || p_hierarchy_id
1211: || ' AND INTERCOMPANY_ORG_TYPE_CODE = ''SPECIFIC_VALUE''');

Line 1223: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1219:
1220: CLOSE intercompany_c;
1221:
1222: -- Get the signage of the suspense line item
1223: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1224: THEN
1225: fnd_log.STRING (fnd_log.level_statement,
1226: g_pkg_name || '.' || l_api_name,
1227: 'SELECT fxata.number_assign_value' || g_nl ||

Line 1225: fnd_log.STRING (fnd_log.level_statement,

1221:
1222: -- Get the signage of the suspense line item
1223: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1224: THEN
1225: fnd_log.STRING (fnd_log.level_statement,
1226: g_pkg_name || '.' || l_api_name,
1227: 'SELECT fxata.number_assign_value' || g_nl ||
1228: 'FROM fem_ln_items_attr flia,' || g_nl ||
1229: ' fem_ext_acct_types_attr fxata' || g_nl ||

Line 1256: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1252:
1253: l_threshold_amount := p_threshold;
1254: IF p_threshold_currency_code IS NOT NULL
1255: THEN
1256: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1257: THEN
1258: fnd_log.STRING (fnd_log.level_statement,
1259: g_pkg_name || '.' || l_api_name,
1260: ' select start_cal_period_id, currency_code

Line 1258: fnd_log.STRING (fnd_log.level_statement,

1254: IF p_threshold_currency_code IS NOT NULL
1255: THEN
1256: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1257: THEN
1258: fnd_log.STRING (fnd_log.level_statement,
1259: g_pkg_name || '.' || l_api_name,
1260: ' select start_cal_period_id, currency_code
1261: into l_cal_period_id, l_currency_code
1262: from gcs_entry_headers

Line 1283: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1279: P_errbuf => l_errbuf,
1280: p_errcode => l_errcode);
1281:
1282: l_threshold_amount := l_corp_rate * p_threshold;
1283: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1284: THEN
1285: fnd_log.STRING (fnd_log.level_statement,
1286: g_pkg_name || '.' || l_api_name,
1287: 'p_threshold = '||p_threshold||', l_corp_rate = ' || l_corp_rate

Line 1285: fnd_log.STRING (fnd_log.level_statement,

1281:
1282: l_threshold_amount := l_corp_rate * p_threshold;
1283: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1284: THEN
1285: fnd_log.STRING (fnd_log.level_statement,
1286: g_pkg_name || '.' || l_api_name,
1287: 'p_threshold = '||p_threshold||', l_corp_rate = ' || l_corp_rate
1288: || ', l_threshold_amount = ' || l_threshold_amount
1289: );

Line 1299: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1295: IF org_tracking_flag = 'N'
1296: THEN
1297: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,
1298: p_hierarchy_id => p_hierarchy_id);
1299: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1300: THEN
1301: fnd_log.STRING (fnd_log.level_statement,
1302: g_pkg_name || '.' || l_api_name,
1303: 'l_org_id = ' || l_org_id

Line 1301: fnd_log.STRING (fnd_log.level_statement,

1297: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,
1298: p_hierarchy_id => p_hierarchy_id);
1299: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1300: THEN
1301: fnd_log.STRING (fnd_log.level_statement,
1302: g_pkg_name || '.' || l_api_name,
1303: 'l_org_id = ' || l_org_id
1304: );
1305: END IF;

Line 1376: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1372: decode(sign(src.ytd_amount), -1, 0, src.ytd_amount), decode(sign(src.ytd_amount), -1, -src.ytd_amount, 0),
1373: SYSDATE, :3, SYSDATE, :3, :4)
1374: ';
1375:
1376: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1377: THEN
1378: fnd_log.STRING (fnd_log.level_statement,
1379: g_pkg_name || '.' || l_api_name,
1380: 'l_merge_statement = '|| l_merge_statement

Line 1378: fnd_log.STRING (fnd_log.level_statement,

1374: ';
1375:
1376: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1377: THEN
1378: fnd_log.STRING (fnd_log.level_statement,
1379: g_pkg_name || '.' || l_api_name,
1380: 'l_merge_statement = '|| l_merge_statement
1381: );
1382: END IF;

Line 1467: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1463: decode(sign(src.ytd_amount), -1, 0, src.ytd_amount), decode(sign(src.ytd_amount), -1, -src.ytd_amount, 0),
1464: SYSDATE, :3, SYSDATE, :3, :4)
1465: ';
1466:
1467: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1468: THEN
1469: fnd_log.STRING (fnd_log.level_statement,
1470: g_pkg_name || '.' || l_api_name,
1471: 'l_merge_statement = '|| l_merge_statement

Line 1469: fnd_log.STRING (fnd_log.level_statement,

1465: ';
1466:
1467: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1468: THEN
1469: fnd_log.STRING (fnd_log.level_statement,
1470: g_pkg_name || '.' || l_api_name,
1471: 'l_merge_statement = '|| l_merge_statement
1472: );
1473: END IF;

Line 1556: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1552: decode(sign(src.ytd_amount), -1, 0, src.ytd_amount), decode(sign(src.ytd_amount), -1, -src.ytd_amount, 0),
1553: SYSDATE, :3, SYSDATE, :3, :4)
1554: ';
1555:
1556: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1557: THEN
1558: fnd_log.STRING (fnd_log.level_statement,
1559: g_pkg_name || '.' || l_api_name,
1560: 'l_merge_statement = '|| l_merge_statement

Line 1558: fnd_log.STRING (fnd_log.level_statement,

1554: ';
1555:
1556: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1557: THEN
1558: fnd_log.STRING (fnd_log.level_statement,
1559: g_pkg_name || '.' || l_api_name,
1560: 'l_merge_statement = '|| l_merge_statement
1561: );
1562: END IF;

Line 1644: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1640: decode(sign(src.ytd_amount), -1, 0, src.ytd_amount), decode(sign(src.ytd_amount), -1, -src.ytd_amount, 0),
1641: SYSDATE, :3, SYSDATE, :3, :4)
1642: ';
1643:
1644: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1645: THEN
1646: fnd_log.STRING (fnd_log.level_statement,
1647: g_pkg_name || '.' || l_api_name,
1648: 'l_merge_statement = '|| l_merge_statement

Line 1646: fnd_log.STRING (fnd_log.level_statement,

1642: ';
1643:
1644: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1645: THEN
1646: fnd_log.STRING (fnd_log.level_statement,
1647: g_pkg_name || '.' || l_api_name,
1648: 'l_merge_statement = '|| l_merge_statement
1649: );
1650: END IF;

Line 1697: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

1693: SET suspense_exceeded_flag = 'Y'
1694: WHERE entry_id = p_entry_id;
1695: END IF;
1696:
1697: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1698: THEN
1699: fnd_log.STRING (fnd_log.level_procedure,
1700: g_pkg_name || '.' || l_api_name,
1701: gcs_utility_pkg.g_module_success

Line 1699: fnd_log.STRING (fnd_log.level_procedure,

1695: END IF;
1696:
1697: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1698: THEN
1699: fnd_log.STRING (fnd_log.level_procedure,
1700: g_pkg_name || '.' || l_api_name,
1701: gcs_utility_pkg.g_module_success
1702: || ' '
1703: || l_api_name

Line 1715: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

1711: THEN
1712: fnd_message.set_name ('GCS', 'GCS_TMP_NO_HIERARCHY');
1713: fnd_message.set_token ('ENTRY_ID', p_entry_id);
1714:
1715: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1716: THEN
1717: fnd_log.STRING (fnd_log.level_procedure,
1718: g_pkg_name || '.' || l_api_name,
1719: gcs_utility_pkg.g_module_failure

Line 1717: fnd_log.STRING (fnd_log.level_procedure,

1713: fnd_message.set_token ('ENTRY_ID', p_entry_id);
1714:
1715: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1716: THEN
1717: fnd_log.STRING (fnd_log.level_procedure,
1718: g_pkg_name || '.' || l_api_name,
1719: gcs_utility_pkg.g_module_failure
1720: || ' '
1721: || l_api_name

Line 1732: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

1728: WHEN gcs_tmp_invalid_sign
1729: THEN
1730: fnd_message.set_name ('GCS', 'GCS_TMP_INVALID_SIGN');
1731:
1732: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1733: THEN
1734: fnd_log.STRING (fnd_log.level_procedure,
1735: g_pkg_name || '.' || l_api_name,
1736: gcs_utility_pkg.g_module_failure

Line 1734: fnd_log.STRING (fnd_log.level_procedure,

1730: fnd_message.set_name ('GCS', 'GCS_TMP_INVALID_SIGN');
1731:
1732: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1733: THEN
1734: fnd_log.STRING (fnd_log.level_procedure,
1735: g_pkg_name || '.' || l_api_name,
1736: gcs_utility_pkg.g_module_failure
1737: || ' '
1738: || l_api_name

Line 1749: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

1745: WHEN OTHERS
1746: THEN
1747: fnd_file.put_line (fnd_file.LOG, SQLERRM);
1748: fnd_message.set_name ('GCS', 'GCS_TMP_UNEXPECTED');
1749: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1750: THEN
1751: fnd_log.STRING (fnd_log.level_procedure,
1752: g_pkg_name || '.' || l_api_name,
1753: gcs_utility_pkg.g_module_failure

Line 1751: fnd_log.STRING (fnd_log.level_procedure,

1747: fnd_file.put_line (fnd_file.LOG, SQLERRM);
1748: fnd_message.set_name ('GCS', 'GCS_TMP_UNEXPECTED');
1749: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1750: THEN
1751: fnd_log.STRING (fnd_log.level_procedure,
1752: g_pkg_name || '.' || l_api_name,
1753: gcs_utility_pkg.g_module_failure
1754: || ' '
1755: || l_api_name