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

Line 81: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

77: l_api_name CONSTANT VARCHAR2(30) := 'datasub_upload';
78:
79: BEGIN
80:
81: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
82: fnd_log.STRING(fnd_log.level_procedure,
83: g_pkg_name || '.' || l_api_name,
84: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
85: '() p_load_id= ' || p_load_id ||

Line 82: fnd_log.STRING(fnd_log.level_procedure,

78:
79: BEGIN
80:
81: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
82: fnd_log.STRING(fnd_log.level_procedure,
83: g_pkg_name || '.' || l_api_name,
84: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
85: '() p_load_id= ' || p_load_id ||
86: ' p_load_name= ' || p_load_name ||

Line 178: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

174: null,
175: null,
176: null);
177:
178: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
179: fnd_log.STRING(fnd_log.level_procedure,
180: g_pkg_name || '.' || l_api_name,
181: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
182: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 179: fnd_log.STRING(fnd_log.level_procedure,

175: null,
176: null);
177:
178: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
179: fnd_log.STRING(fnd_log.level_procedure,
180: g_pkg_name || '.' || l_api_name,
181: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
182: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
183: END IF;

Line 207: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

203: FND_FILE.PUT_LINE(FND_FILE.LOG,
204: g_pkg_name || '.' || l_api_name || ' ENTER');
205: FND_FILE.NEW_LINE(FND_FILE.LOG);
206:
207: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
208: fnd_log.STRING(fnd_log.level_procedure,
209: g_pkg_name || '.' || l_api_name,
210: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
211: '() p_hierarchy_id= ' || p_hierarchy_id ||

Line 208: fnd_log.STRING(fnd_log.level_procedure,

204: g_pkg_name || '.' || l_api_name || ' ENTER');
205: FND_FILE.NEW_LINE(FND_FILE.LOG);
206:
207: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
208: fnd_log.STRING(fnd_log.level_procedure,
209: g_pkg_name || '.' || l_api_name,
210: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
211: '() p_hierarchy_id= ' || p_hierarchy_id ||
212: ' p_entity_id= ' || p_entity_id ||

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

215: END IF;
216:
217: -- Bug Fix : 5352902
218: /***
219: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
220: fnd_log.STRING(fnd_log.level_statement,
221: g_pkg_name || '.' || l_api_name,
222: 'DELETE FROM gcs_historical_rates ' || g_nl ||
223: ' WHERE hierarchy_id = ' || p_hierarchy_id || g_nl ||

Line 220: fnd_log.STRING(fnd_log.level_statement,

216:
217: -- Bug Fix : 5352902
218: /***
219: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
220: fnd_log.STRING(fnd_log.level_statement,
221: g_pkg_name || '.' || l_api_name,
222: 'DELETE FROM gcs_historical_rates ' || g_nl ||
223: ' WHERE hierarchy_id = ' || p_hierarchy_id || g_nl ||
224: ' AND entity_id = ' || p_entity_id || g_nl ||

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

233: AND update_flag = 'N';
234:
235: ***/
236:
237: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
238: fnd_log.STRING(fnd_log.level_statement,
239: g_pkg_name || '.' || l_api_name,
240: ' UPDATE gcs_historical_rates ghr set update_flag = ''N'', account_type_code = ' || g_nl ||
241: '( select dim_attribute_varchar_member from fem_ln_items_attr ' || g_nl ||

Line 238: fnd_log.STRING(fnd_log.level_statement,

234:
235: ***/
236:
237: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
238: fnd_log.STRING(fnd_log.level_statement,
239: g_pkg_name || '.' || l_api_name,
240: ' UPDATE gcs_historical_rates ghr set update_flag = ''N'', account_type_code = ' || g_nl ||
241: '( select dim_attribute_varchar_member from fem_ln_items_attr ' || g_nl ||
242: ' where attribute_id = ' ||

Line 291: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

287: FND_FILE.PUT_LINE(FND_FILE.LOG,
288: g_pkg_name || '.' || l_api_name ||
289: ' WF_EVENT FAILED');
290: FND_FILE.NEW_LINE(FND_FILE.LOG);
291: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
292: fnd_log.STRING(fnd_log.level_error,
293: g_pkg_name || '.' || l_api_name,
294: ' wf_event.raise failed ' || ' ' ||
295: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 292: fnd_log.STRING(fnd_log.level_error,

288: g_pkg_name || '.' || l_api_name ||
289: ' WF_EVENT FAILED');
290: FND_FILE.NEW_LINE(FND_FILE.LOG);
291: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
292: fnd_log.STRING(fnd_log.level_error,
293: g_pkg_name || '.' || l_api_name,
294: ' wf_event.raise failed ' || ' ' ||
295: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
296: END IF;

Line 303: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

299: FND_FILE.PUT_LINE(FND_FILE.LOG,
300: g_pkg_name || '.' || l_api_name || ' EXIT');
301: FND_FILE.NEW_LINE(FND_FILE.LOG);
302:
303: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
304: fnd_log.STRING(fnd_log.level_procedure,
305: g_pkg_name || '.' || l_api_name,
306: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
307: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 304: fnd_log.STRING(fnd_log.level_procedure,

300: g_pkg_name || '.' || l_api_name || ' EXIT');
301: FND_FILE.NEW_LINE(FND_FILE.LOG);
302:
303: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
304: fnd_log.STRING(fnd_log.level_procedure,
305: g_pkg_name || '.' || l_api_name,
306: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
307: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
308: END IF;

Line 320: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

316: SQLERRM);
317: FND_FILE.NEW_LINE(FND_FILE.LOG);
318:
319: -- Write the appropriate information to the execution report
320: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
321: fnd_log.STRING(fnd_log.level_error,
322: g_pkg_name || '.' || l_api_name,
323: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM || ' ' ||
324: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 321: fnd_log.STRING(fnd_log.level_error,

317: FND_FILE.NEW_LINE(FND_FILE.LOG);
318:
319: -- Write the appropriate information to the execution report
320: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
321: fnd_log.STRING(fnd_log.level_error,
322: g_pkg_name || '.' || l_api_name,
323: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM || ' ' ||
324: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
325: END IF;

Line 390: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

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

Line 391: fnd_log.STRING(fnd_log.level_procedure,

387:
388: BEGIN
389:
390: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
391: fnd_log.STRING(fnd_log.level_procedure,
392: g_pkg_name || '.' || l_api_name,
393: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
394: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
395: END IF;

Line 400: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

396:
397: gcs_utility_pkg.init_dimension_info;
398:
399: -- Bugfix 5052607: Adding checks for dimension information count
400: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
401: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
402: 'Active dimension count: ' || gcs_utility_pkg.g_gcs_dimension_info.COUNT);
403: END IF;
404:

Line 401: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

397: gcs_utility_pkg.init_dimension_info;
398:
399: -- Bugfix 5052607: Adding checks for dimension information count
400: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
401: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
402: 'Active dimension count: ' || gcs_utility_pkg.g_gcs_dimension_info.COUNT);
403: END IF;
404:
405: IF (gcs_utility_pkg.g_gcs_dimension_info.COUNT = 0) THEN

Line 701: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

697: END LOOP;
698:
699:
700: -- Bugfix 5052607: Added additional debug information
701: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
702: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
703: 'Select Columns: ' || l_select_cols);
704: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
705: 'From Clause: ' || l_from_clause);

Line 702: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

698:
699:
700: -- Bugfix 5052607: Added additional debug information
701: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
702: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
703: 'Select Columns: ' || l_select_cols);
704: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
705: 'From Clause: ' || l_from_clause);
706: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

Line 704: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

700: -- Bugfix 5052607: Added additional debug information
701: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
702: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
703: 'Select Columns: ' || l_select_cols);
704: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
705: 'From Clause: ' || l_from_clause);
706: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
707: 'Where Clause: ' || l_where_clause);
708: END IF;

Line 706: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

702: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
703: 'Select Columns: ' || l_select_cols);
704: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
705: 'From Clause: ' || l_from_clause);
706: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
707: 'Where Clause: ' || l_where_clause);
708: END IF;
709:
710:

Line 835: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

831:
832: body := ' CREATE OR REPLACE FORCE VIEW GCS_TB_WEBADI_VL AS ' || l_query;
833:
834: -- Bugfix 5052607: Adding additional debug information
835: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
836: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
837: 'View Definition for GCS_TB_WEBADI_VL');
838: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
839: body);

Line 836: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

832: body := ' CREATE OR REPLACE FORCE VIEW GCS_TB_WEBADI_VL AS ' || l_query;
833:
834: -- Bugfix 5052607: Adding additional debug information
835: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
836: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
837: 'View Definition for GCS_TB_WEBADI_VL');
838: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
839: body);
840:

Line 838: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

834: -- Bugfix 5052607: Adding additional debug information
835: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
836: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
837: 'View Definition for GCS_TB_WEBADI_VL');
838: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
839: body);
840:
841: END IF;
842:

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

854: ' FROM gcs_tb_webadi_vl ' ||
855: ' WHERE ad_transaction_id = $param$.xns_id ';
856:
857: -- update stored SQL
858: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
859: fnd_log.STRING(fnd_log.level_statement,
860: g_pkg_name || '.' || l_api_name,
861: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
862: gcs_utility_pkg.g_nl ||

Line 859: fnd_log.STRING(fnd_log.level_statement,

855: ' WHERE ad_transaction_id = $param$.xns_id ';
856:
857: -- update stored SQL
858: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
859: fnd_log.STRING(fnd_log.level_statement,
860: g_pkg_name || '.' || l_api_name,
861: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
862: gcs_utility_pkg.g_nl ||
863: ' WHERE application_id=l_app_id AND content_code=''GCS_AD_TB_CNT''');

Line 903: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

899: body := ' CREATE OR REPLACE FORCE VIEW GCS_ADENTRY_WEBADI_VL AS ' ||
900: l_query;
901:
902: -- Bugfix 5052607: Adding additional debug information
903: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
904: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
905: 'View Definition for GCS_ADENTRY_WEBADI_VL');
906: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
907: body);

Line 904: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

900: l_query;
901:
902: -- Bugfix 5052607: Adding additional debug information
903: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
904: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
905: 'View Definition for GCS_ADENTRY_WEBADI_VL');
906: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
907: body);
908:

Line 906: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

902: -- Bugfix 5052607: Adding additional debug information
903: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
904: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
905: 'View Definition for GCS_ADENTRY_WEBADI_VL');
906: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
907: body);
908:
909: END IF;
910:

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

922: ' consideration_amount, ' || ' lines_description,' ||
923: ' credit_amount, debit_amount' || l_view_select_cols ||
924: ' FROM gcs_adentry_webadi_vl ' ||
925: ' WHERE ad_transaction_id = $param$.xns_id ';
926: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
927: fnd_log.STRING(fnd_log.level_statement,
928: g_pkg_name || '.' || l_api_name,
929: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
930: gcs_utility_pkg.g_nl ||

Line 927: fnd_log.STRING(fnd_log.level_statement,

923: ' credit_amount, debit_amount' || l_view_select_cols ||
924: ' FROM gcs_adentry_webadi_vl ' ||
925: ' WHERE ad_transaction_id = $param$.xns_id ';
926: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
927: fnd_log.STRING(fnd_log.level_statement,
928: g_pkg_name || '.' || l_api_name,
929: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
930: gcs_utility_pkg.g_nl ||
931: ' WHERE application_id=l_app_id AND content_code=''GCS_AD_ENTRY_CNT''');

Line 966: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

962:
963: body := ' CREATE OR REPLACE FORCE VIEW GCS_HR_RE_WEBADI_VL AS ' || l_query;
964:
965: -- Bugfix 5052607: Adding additional debug information
966: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
967: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
968: 'View Definition for GCS_HR_RE_WEBADI_VL');
969: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
970: body);

Line 967: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

963: body := ' CREATE OR REPLACE FORCE VIEW GCS_HR_RE_WEBADI_VL AS ' || l_query;
964:
965: -- Bugfix 5052607: Adding additional debug information
966: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
967: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
968: 'View Definition for GCS_HR_RE_WEBADI_VL');
969: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
970: body);
971:

Line 969: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

965: -- Bugfix 5052607: Adding additional debug information
966: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
967: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
968: 'View Definition for GCS_HR_RE_WEBADI_VL');
969: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
970: body);
971:
972: END IF;
973:

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

982: l_view_select_cols || ' FROM gcs_hr_re_webadi_vl tb ' ||
983: ' WHERE hierarchy_id = $param$.hierarchy_id AND entity_id = $param$.entity_id ' ||
984: ' AND cal_period_id = $param$.cal_period_id ';
985:
986: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
987: fnd_log.STRING(fnd_log.level_statement,
988: g_pkg_name || '.' || l_api_name,
989: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
990: gcs_utility_pkg.g_nl ||

Line 987: fnd_log.STRING(fnd_log.level_statement,

983: ' WHERE hierarchy_id = $param$.hierarchy_id AND entity_id = $param$.entity_id ' ||
984: ' AND cal_period_id = $param$.cal_period_id ';
985:
986: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
987: fnd_log.STRING(fnd_log.level_statement,
988: g_pkg_name || '.' || l_api_name,
989: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
990: gcs_utility_pkg.g_nl ||
991: ' WHERE application_id=l_app_id AND content_code=''GCS_HRATE_RE_CNT''');

Line 1023: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

1019:
1020: body := ' CREATE OR REPLACE FORCE VIEW GCS_HR_WEBADI_VL AS ' || l_query;
1021:
1022: -- Bugfix 5052607: Adding additional debug information
1023: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
1024: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
1025: 'View Definition for GCS_HR_WEBADI_VL');
1026: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
1027: body);

Line 1024: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

1020: body := ' CREATE OR REPLACE FORCE VIEW GCS_HR_WEBADI_VL AS ' || l_query;
1021:
1022: -- Bugfix 5052607: Adding additional debug information
1023: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
1024: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
1025: 'View Definition for GCS_HR_WEBADI_VL');
1026: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
1027: body);
1028:

Line 1026: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

1022: -- Bugfix 5052607: Adding additional debug information
1023: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
1024: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
1025: 'View Definition for GCS_HR_WEBADI_VL');
1026: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
1027: body);
1028:
1029: END IF;
1030:

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

1040: ' WHERE hierarchy_id = $param$.hierarchy_id AND entity_id = $param$.entity_id ' ||
1041: ' AND cal_period_id = $param$.cal_period_id ';
1042:
1043:
1044: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1045: fnd_log.STRING(fnd_log.level_statement,
1046: g_pkg_name || '.' || l_api_name,
1047: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
1048: gcs_utility_pkg.g_nl ||

Line 1045: fnd_log.STRING(fnd_log.level_statement,

1041: ' AND cal_period_id = $param$.cal_period_id ';
1042:
1043:
1044: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1045: fnd_log.STRING(fnd_log.level_statement,
1046: g_pkg_name || '.' || l_api_name,
1047: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
1048: gcs_utility_pkg.g_nl ||
1049: ' WHERE application_id=l_app_id AND content_code=''GCS_HRATE_CNT''');

Line 1090: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

1086: body := ' CREATE OR REPLACE FORCE VIEW GCS_ENTRY_WEBADI_VL AS ' ||
1087: l_query;
1088:
1089: -- Bugfix 5052607: Adding additional debug information
1090: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
1091: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
1092: 'View Definition for GCS_ENTRY_WEBADI_VL');
1093: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
1094: body);

Line 1091: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

1087: l_query;
1088:
1089: -- Bugfix 5052607: Adding additional debug information
1090: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
1091: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
1092: 'View Definition for GCS_ENTRY_WEBADI_VL');
1093: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
1094: body);
1095:

Line 1093: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

1089: -- Bugfix 5052607: Adding additional debug information
1090: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
1091: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
1092: 'View Definition for GCS_ENTRY_WEBADI_VL');
1093: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
1094: body);
1095:
1096: END IF;
1097:

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

1107: ' end_period, entry_name, entry_id, ENTRY_LINES_DESCRIPTION ' || l_view_select_cols ||
1108: ' FROM gcs_entry_webadi_vl tb ' ||
1109: ' WHERE tb.entry_id=$PARAM$.entry_id ';
1110:
1111: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1112: fnd_log.STRING(fnd_log.level_statement,
1113: g_pkg_name || '.' || l_api_name,
1114: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
1115: gcs_utility_pkg.g_nl ||

Line 1112: fnd_log.STRING(fnd_log.level_statement,

1108: ' FROM gcs_entry_webadi_vl tb ' ||
1109: ' WHERE tb.entry_id=$PARAM$.entry_id ';
1110:
1111: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1112: fnd_log.STRING(fnd_log.level_statement,
1113: g_pkg_name || '.' || l_api_name,
1114: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
1115: gcs_utility_pkg.g_nl ||
1116: ' WHERE application_id=l_app_id AND content_code=''GCS_ENTRY_LINES_CNT''');

Line 1129: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1125:
1126: COMMIT;
1127:
1128: -- Write the appropriate information to the execution report
1129: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1130: fnd_log.STRING(fnd_log.level_procedure,
1131: g_pkg_name || '.' || l_api_name,
1132: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
1133: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1130: fnd_log.STRING(fnd_log.level_procedure,

1126: COMMIT;
1127:
1128: -- Write the appropriate information to the execution report
1129: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1130: fnd_log.STRING(fnd_log.level_procedure,
1131: g_pkg_name || '.' || l_api_name,
1132: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
1133: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1134: END IF;

Line 1144: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1140: --Bugfix 5052607: Commented calling WF_CORE APIs and setting message name
1141: --fnd_message.set_name('GCS', 'GCS_AD_TB_UNEXPECTED_ERR');
1142:
1143: -- Write the appropriate information to the execution report
1144: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1145: fnd_log.STRING(fnd_log.level_error,
1146: g_pkg_name || '.' || l_api_name,
1147: gcs_utility_pkg.g_module_failure || ' ' ||
1148: l_api_name || '() ' ||

Line 1145: fnd_log.STRING(fnd_log.level_error,

1141: --fnd_message.set_name('GCS', 'GCS_AD_TB_UNEXPECTED_ERR');
1142:
1143: -- Write the appropriate information to the execution report
1144: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1145: fnd_log.STRING(fnd_log.level_error,
1146: g_pkg_name || '.' || l_api_name,
1147: gcs_utility_pkg.g_module_failure || ' ' ||
1148: l_api_name || '() ' ||
1149: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1150: fnd_log.STRING(fnd_log.level_error,

1146: g_pkg_name || '.' || l_api_name,
1147: gcs_utility_pkg.g_module_failure || ' ' ||
1148: l_api_name || '() ' ||
1149: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1150: fnd_log.STRING(fnd_log.level_error,
1151: g_pkg_name || '.' || l_api_name,
1152: SQLERRM);
1153: END IF;
1154:

Line 1207: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Parameters');
1204: FND_FILE.NEW_LINE(FND_FILE.LOG);
1205:
1206:
1207: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1208: fnd_log.STRING(fnd_log.level_procedure,
1209: g_pkg_name || '.' || l_api_name,
1210: gcs_utility_pkg.g_module_enter || ' p_sequence_num = ' ||
1211: p_sequence_num || ', p_dimension_varchar_label = ' ||

Line 1208: fnd_log.STRING(fnd_log.level_procedure,

1204: FND_FILE.NEW_LINE(FND_FILE.LOG);
1205:
1206:
1207: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1208: fnd_log.STRING(fnd_log.level_procedure,
1209: g_pkg_name || '.' || l_api_name,
1210: gcs_utility_pkg.g_module_enter || ' p_sequence_num = ' ||
1211: p_sequence_num || ', p_dimension_varchar_label = ' ||
1212: p_dimension_varchar_label || ' ' ||

Line 1411: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1407: FND_FILE.NEW_LINE(FND_FILE.LOG);
1408: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1409: FND_FILE.NEW_LINE(FND_FILE.LOG);
1410:
1411: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1412: fnd_log.STRING(fnd_log.level_procedure,
1413: g_pkg_name || '.' || l_api_name, FND_MESSAGE.get );
1414: END IF;
1415:

Line 1412: fnd_log.STRING(fnd_log.level_procedure,

1408: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1409: FND_FILE.NEW_LINE(FND_FILE.LOG);
1410:
1411: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1412: fnd_log.STRING(fnd_log.level_procedure,
1413: g_pkg_name || '.' || l_api_name, FND_MESSAGE.get );
1414: END IF;
1415:
1416: ELSE

Line 1451: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1447: WHERE sequence_num = p_sequence_num;
1448:
1449:
1450: -- Write the appropriate information to the execution report
1451: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1452: fnd_log.STRING(fnd_log.level_error,
1453: g_pkg_name || '.' || l_api_name,
1454: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf || ' ' ||
1455: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1452: fnd_log.STRING(fnd_log.level_error,

1448:
1449:
1450: -- Write the appropriate information to the execution report
1451: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1452: fnd_log.STRING(fnd_log.level_error,
1453: g_pkg_name || '.' || l_api_name,
1454: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf || ' ' ||
1455: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1456: END IF;

Line 1478: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1474: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1475: FND_FILE.NEW_LINE(FND_FILE.LOG);
1476:
1477: -- Write the appropriate information to the execution report
1478: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1479: fnd_log.STRING(fnd_log.level_error,
1480: g_pkg_name || '.' || l_api_name,
1481: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf || ' ' ||
1482: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1479: fnd_log.STRING(fnd_log.level_error,

1475: FND_FILE.NEW_LINE(FND_FILE.LOG);
1476:
1477: -- Write the appropriate information to the execution report
1478: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1479: fnd_log.STRING(fnd_log.level_error,
1480: g_pkg_name || '.' || l_api_name,
1481: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf || ' ' ||
1482: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1483: END IF;

Line 1551: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1547: p_analysis_flag || ', p_mvs_flag = ' || p_mvs_flag ||
1548: ', p_parent_vs_display_code = ' ||
1549: p_parent_vs_display_code);
1550:
1551: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1552: fnd_log.STRING(fnd_log.level_procedure,
1553: g_pkg_name || '.' || l_api_name,
1554: gcs_utility_pkg.g_module_enter ||
1555: ' p_sequence_num = ' || p_sequence_num ||

Line 1552: fnd_log.STRING(fnd_log.level_procedure,

1548: ', p_parent_vs_display_code = ' ||
1549: p_parent_vs_display_code);
1550:
1551: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1552: fnd_log.STRING(fnd_log.level_procedure,
1553: g_pkg_name || '.' || l_api_name,
1554: gcs_utility_pkg.g_module_enter ||
1555: ' p_sequence_num = ' || p_sequence_num ||
1556: ', p_dimension_varchar_label = ' ||

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

1687: USERENV(''LANG'')
1688: FROM gcs_hier_members_t
1689: WHERE sequence_num = :3 ';
1690:
1691: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1692: fnd_log.STRING(fnd_log.level_statement,
1693: g_pkg_name || '.' || l_api_name,
1694: ' l_statement = ' || l_statement);
1695: END IF;

Line 1692: fnd_log.STRING(fnd_log.level_statement,

1688: FROM gcs_hier_members_t
1689: WHERE sequence_num = :3 ';
1690:
1691: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1692: fnd_log.STRING(fnd_log.level_statement,
1693: g_pkg_name || '.' || l_api_name,
1694: ' l_statement = ' || l_statement);
1695: END IF;
1696:

Line 1833: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1829: FND_FILE.PUT_LINE(FND_FILE.LOG,
1830: g_pkg_name || '.' || l_api_name || ' EXIT');
1831: FND_FILE.NEW_LINE(FND_FILE.LOG);
1832:
1833: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1834: fnd_log.STRING(fnd_log.level_procedure,
1835: g_pkg_name || '.' || l_api_name,
1836: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
1837: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1834: fnd_log.STRING(fnd_log.level_procedure,

1830: g_pkg_name || '.' || l_api_name || ' EXIT');
1831: FND_FILE.NEW_LINE(FND_FILE.LOG);
1832:
1833: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1834: fnd_log.STRING(fnd_log.level_procedure,
1835: g_pkg_name || '.' || l_api_name,
1836: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
1837: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1838: END IF;

Line 1870: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1866: x_errbuf);
1867: FND_FILE.NEW_LINE(FND_FILE.LOG);
1868:
1869: -- Write the appropriate information to the execution report
1870: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1871: fnd_log.STRING(fnd_log.level_error,
1872: g_pkg_name || '.' || l_api_name,
1873: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf || ' ' ||
1874: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1871: fnd_log.STRING(fnd_log.level_error,

1867: FND_FILE.NEW_LINE(FND_FILE.LOG);
1868:
1869: -- Write the appropriate information to the execution report
1870: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1871: fnd_log.STRING(fnd_log.level_error,
1872: g_pkg_name || '.' || l_api_name,
1873: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf || ' ' ||
1874: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1875: END IF;

Line 1912: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1908: BEGIN
1909: FND_FILE.NEW_LINE(FND_FILE.LOG);
1910: FND_FILE.PUT_LINE(FND_FILE.LOG,
1911: g_pkg_name || '.' || l_api_name );
1912: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1913: fnd_log.STRING(fnd_log.level_procedure,
1914: g_pkg_name || '.' || l_api_name ,'Begin');
1915: END IF;
1916: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

Line 1913: fnd_log.STRING(fnd_log.level_procedure,

1909: FND_FILE.NEW_LINE(FND_FILE.LOG);
1910: FND_FILE.PUT_LINE(FND_FILE.LOG,
1911: g_pkg_name || '.' || l_api_name );
1912: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1913: fnd_log.STRING(fnd_log.level_procedure,
1914: g_pkg_name || '.' || l_api_name ,'Begin');
1915: END IF;
1916: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1917: fnd_log.STRING(fnd_log.level_procedure,

Line 1916: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1912: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1913: fnd_log.STRING(fnd_log.level_procedure,
1914: g_pkg_name || '.' || l_api_name ,'Begin');
1915: END IF;
1916: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1917: fnd_log.STRING(fnd_log.level_procedure,
1918: g_pkg_name || '.' || l_api_name ,
1919: ' SELECT count(*)
1920: INTO l_cnt

Line 1917: fnd_log.STRING(fnd_log.level_procedure,

1913: fnd_log.STRING(fnd_log.level_procedure,
1914: g_pkg_name || '.' || l_api_name ,'Begin');
1915: END IF;
1916: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1917: fnd_log.STRING(fnd_log.level_procedure,
1918: g_pkg_name || '.' || l_api_name ,
1919: ' SELECT count(*)
1920: INTO l_cnt
1921: FROM gcs_interco_map_dtls; ');

Line 1928: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1924: INTO l_cnt
1925: FROM gcs_interco_map_dtls;
1926:
1927: IF l_cnt > 0 THEN
1928: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1929: fnd_log.STRING(fnd_log.level_procedure,
1930: g_pkg_name || '.' || l_api_name ,
1931: ' UPDATE GCS_SYSTEM_OPTIONS
1932: SET INTERCO_MAP_ENABLED_FLAG = ''Y''; ');

Line 1929: fnd_log.STRING(fnd_log.level_procedure,

1925: FROM gcs_interco_map_dtls;
1926:
1927: IF l_cnt > 0 THEN
1928: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1929: fnd_log.STRING(fnd_log.level_procedure,
1930: g_pkg_name || '.' || l_api_name ,
1931: ' UPDATE GCS_SYSTEM_OPTIONS
1932: SET INTERCO_MAP_ENABLED_FLAG = ''Y''; ');
1933: END IF;

Line 1938: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1934: UPDATE GCS_SYSTEM_OPTIONS
1935: SET INTERCO_MAP_ENABLED_FLAG = 'Y';
1936:
1937: ELSE
1938: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1939: fnd_log.STRING(fnd_log.level_procedure,
1940: g_pkg_name || '.' || l_api_name ,
1941: ' UPDATE GCS_SYSTEM_OPTIONS
1942: SET INTERCO_MAP_ENABLED_FLAG = ''N''; ');

Line 1939: fnd_log.STRING(fnd_log.level_procedure,

1935: SET INTERCO_MAP_ENABLED_FLAG = 'Y';
1936:
1937: ELSE
1938: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1939: fnd_log.STRING(fnd_log.level_procedure,
1940: g_pkg_name || '.' || l_api_name ,
1941: ' UPDATE GCS_SYSTEM_OPTIONS
1942: SET INTERCO_MAP_ENABLED_FLAG = ''N''; ');
1943: END IF;