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_DATASUB_WF_PKG dependencies on FND_GLOBAL

Line 185: FND_GLOBAL.USER_NAME);

181: WF_ENGINE.CreateProcess('DATASUB',
182: l_event_key,
183: 'GCSDATASUB',
184: l_event_key,
185: FND_GLOBAL.USER_NAME);
186: WF_ENGINE.SetItemAttrNumber('DATASUB',
187: l_event_key,
188: 'LOAD_ID',
189: p_load_id);

Line 301: last_updated_by = FND_GLOBAL.USER_ID,

297: -- Transformation or Validation Failed
298: UPDATE gcs_data_sub_dtls
299: SET status_code = 'ERROR',
300: end_time = sysdate,
301: last_updated_by = FND_GLOBAL.USER_ID,
302: last_update_login = FND_GLOBAL.LOGIN_ID,
303: last_update_date = sysdate
304: WHERE load_id = p_load_id;
305:

Line 302: last_update_login = FND_GLOBAL.LOGIN_ID,

298: UPDATE gcs_data_sub_dtls
299: SET status_code = 'ERROR',
300: end_time = sysdate,
301: last_updated_by = FND_GLOBAL.USER_ID,
302: last_update_login = FND_GLOBAL.LOGIN_ID,
303: last_update_date = sysdate
304: WHERE load_id = p_load_id;
305:
306: --gcs_xml_gen_pkg.generate_ds_xml(p_load_id => p_load_id);

Line 363: WHERE gdsd.associated_request_id = FND_GLOBAL.CONC_REQUEST_ID;

359:
360: CURSOR c_generated_loads IS
361: SELECT gdsd.load_id
362: FROM gcs_data_sub_dtls gdsd
363: WHERE gdsd.associated_request_id = FND_GLOBAL.CONC_REQUEST_ID;
364:
365: --Bugfix 4507953: Rely on translated balances select, rather than REQUEST_ID select
366: CURSOR c_translated_balances(p_request_id NUMBER, p_object_id NUMBER, p_ledger_id NUMBER, p_cal_period_id NUMBER) IS
367:

Line 466: fnd_global.user_id,

462: gdsd.measure_type_code,
463: gdsd.notify_options_code,
464: gdsd.notification_text,
465: sysdate,
466: fnd_global.user_id,
467: sysdate,
468: fnd_global.user_id,
469: fnd_global.login_id,
470: 1,

Line 468: fnd_global.user_id,

464: gdsd.notification_text,
465: sysdate,
466: fnd_global.user_id,
467: sysdate,
468: fnd_global.user_id,
469: fnd_global.login_id,
470: 1,
471: gdsd.start_time,
472: gdsd.locked_flag,

Line 469: fnd_global.login_id,

465: sysdate,
466: fnd_global.user_id,
467: sysdate,
468: fnd_global.user_id,
469: fnd_global.login_id,
470: 1,
471: gdsd.start_time,
472: gdsd.locked_flag,
473: gdsd.most_recent_flag,

Line 524: fnd_global.user_id,

520: gdsd.measure_type_code,
521: gdsd.notify_options_code,
522: gdsd.notification_text,
523: SYSDATE,
524: fnd_global.user_id,
525: SYSDATE,
526: fnd_global.user_id,
527: fnd_global.login_id,
528: 1,

Line 526: fnd_global.user_id,

522: gdsd.notification_text,
523: SYSDATE,
524: fnd_global.user_id,
525: SYSDATE,
526: fnd_global.user_id,
527: fnd_global.login_id,
528: 1,
529: gdsd.start_time,
530: gdsd.locked_flag,

Line 527: fnd_global.login_id,

523: SYSDATE,
524: fnd_global.user_id,
525: SYSDATE,
526: fnd_global.user_id,
527: fnd_global.login_id,
528: 1,
529: gdsd.start_time,
530: gdsd.locked_flag,
531: gdsd.most_recent_flag,

Line 538: WHERE gdsd.associated_request_id = FND_GLOBAL.CONC_REQUEST_ID

534: gdsd.balances_rule_id
535: FROM gcs_data_sub_dtls gdsd,
536: gcs_entities_attr gea,
537: fem_cal_periods_attr fcpa
538: WHERE gdsd.associated_request_id = FND_GLOBAL.CONC_REQUEST_ID
539: AND gea.entity_id <> p_datasub_info.entity_id
540: AND gea.balances_rule_id = gdsd.balances_rule_id
541: AND gea.data_type_code = gdsd.balance_type_code
542: AND fcpa.cal_period_id = gdsd.cal_period_id

Line 715: FOR v_translated_balances IN c_translated_balances(FND_GLOBAL.CONC_REQUEST_ID,

711: IF (NOT l_error_occurred) THEN
712:
713: fnd_file.put_line(fnd_file.log, 'Reviewing translation balances');
714:
715: FOR v_translated_balances IN c_translated_balances(FND_GLOBAL.CONC_REQUEST_ID,
716: p_datasub_info.balances_rule_id,
717: p_datasub_info.ledger_id,
718: p_datasub_info.cal_period_id) LOOP
719: INSERT INTO gcs_data_sub_dtls

Line 757: fnd_global.user_id,

753: gdsd.measure_type_code,
754: gdsd.notify_options_code,
755: gdsd.notification_text,
756: SYSDATE,
757: fnd_global.user_id,
758: SYSDATE,
759: fnd_global.user_id,
760: fnd_global.login_id,
761: 1,

Line 759: fnd_global.user_id,

755: gdsd.notification_text,
756: SYSDATE,
757: fnd_global.user_id,
758: SYSDATE,
759: fnd_global.user_id,
760: fnd_global.login_id,
761: 1,
762: gdsd.start_time,
763: gdsd.locked_flag,

Line 760: fnd_global.login_id,

756: SYSDATE,
757: fnd_global.user_id,
758: SYSDATE,
759: fnd_global.user_id,
760: fnd_global.login_id,
761: 1,
762: gdsd.start_time,
763: gdsd.locked_flag,
764: gdsd.most_recent_flag,

Line 769: WHERE gdsd.associated_request_id = FND_GLOBAL.CONC_REQUEST_ID;

765: gdsd.associated_request_id,
766: 'IN_PROGRESS',
767: gdsd.balances_rule_id
768: FROM gcs_data_sub_dtls gdsd
769: WHERE gdsd.associated_request_id = FND_GLOBAL.CONC_REQUEST_ID;
770:
771: END LOOP;
772:
773: fnd_file.put_line(fnd_file.log,

Line 779: WHERE request_id = FND_GLOBAL.conc_request_id;

775:
776: SELECT status_code
777: INTO l_status_code
778: FROM fnd_concurrent_requests
779: WHERE request_id = FND_GLOBAL.conc_request_id;
780:
781: UPDATE gcs_data_sub_dtls
782: SET status_code = DECODE(l_status_code,
783: 'C',

Line 791: last_updated_by = FND_GLOBAL.USER_ID,

787: 'W',
788: 'WARNING',
789: 'WARNING'),
790: end_time = SYSDATE,
791: last_updated_by = FND_GLOBAL.USER_ID,
792: last_update_login = FND_GLOBAL.LOGIN_ID,
793: last_update_date = SYSDATE
794: WHERE associated_request_id = FND_GLOBAL.conc_request_id;
795:

Line 792: last_update_login = FND_GLOBAL.LOGIN_ID,

788: 'WARNING',
789: 'WARNING'),
790: end_time = SYSDATE,
791: last_updated_by = FND_GLOBAL.USER_ID,
792: last_update_login = FND_GLOBAL.LOGIN_ID,
793: last_update_date = SYSDATE
794: WHERE associated_request_id = FND_GLOBAL.conc_request_id;
795:
796: -- Bugfix 5347804: Need to update the most recent flag to 'N' for prior loads

Line 794: WHERE associated_request_id = FND_GLOBAL.conc_request_id;

790: end_time = SYSDATE,
791: last_updated_by = FND_GLOBAL.USER_ID,
792: last_update_login = FND_GLOBAL.LOGIN_ID,
793: last_update_date = SYSDATE
794: WHERE associated_request_id = FND_GLOBAL.conc_request_id;
795:
796: -- Bugfix 5347804: Need to update the most recent flag to 'N' for prior loads
797: UPDATE gcs_data_sub_dtls prev_runs
798: SET most_recent_flag = 'N'

Line 802: FND_GLOBAL.conc_request_id

798: SET most_recent_flag = 'N'
799: WHERE EXISTS (SELECT 'X'
800: FROM gcs_data_sub_dtls curr_run
801: WHERE curr_run.associated_request_id =
802: FND_GLOBAL.conc_request_id
803: AND curr_run.entity_id = prev_runs.entity_id
804: AND curr_run.cal_period_id = prev_runs.cal_period_id
805: AND curr_run.currency_code = prev_runs.currency_code
806: AND curr_run.balance_type_code =

Line 876: last_updated_by = FND_GLOBAL.USER_ID,

872: 'W',
873: 'WARNING',
874: 'WARNING'),
875: end_time = sysdate,
876: last_updated_by = FND_GLOBAL.USER_ID,
877: last_update_login = FND_GLOBAL.LOGIN_ID,
878: last_update_date = sysdate
879: WHERE associated_request_id = FND_GLOBAL.conc_request_id;
880:

Line 877: last_update_login = FND_GLOBAL.LOGIN_ID,

873: 'WARNING',
874: 'WARNING'),
875: end_time = sysdate,
876: last_updated_by = FND_GLOBAL.USER_ID,
877: last_update_login = FND_GLOBAL.LOGIN_ID,
878: last_update_date = sysdate
879: WHERE associated_request_id = FND_GLOBAL.conc_request_id;
880:
881: --gcs_xml_gen_pkg.generate_ds_xml(p_load_id => p_load_id);

Line 879: WHERE associated_request_id = FND_GLOBAL.conc_request_id;

875: end_time = sysdate,
876: last_updated_by = FND_GLOBAL.USER_ID,
877: last_update_login = FND_GLOBAL.LOGIN_ID,
878: last_update_date = sysdate
879: WHERE associated_request_id = FND_GLOBAL.conc_request_id;
880:
881: --gcs_xml_gen_pkg.generate_ds_xml(p_load_id => p_load_id);
882: --Bugfix 5347804: Commenting out call to XML Generation if the process ends in error
883: -- l_request_id := fnd_request.submit_request(

Line 916: last_updated_by = FND_GLOBAL.USER_ID,

912: 'W',
913: 'WARNING',
914: 'WARNING'),
915: end_time = SYSDATE,
916: last_updated_by = FND_GLOBAL.USER_ID,
917: last_update_login = FND_GLOBAL.LOGIN_ID,
918: last_update_date = SYSDATE
919: WHERE associated_request_id = FND_GLOBAL.conc_request_id;
920:

Line 917: last_update_login = FND_GLOBAL.LOGIN_ID,

913: 'WARNING',
914: 'WARNING'),
915: end_time = SYSDATE,
916: last_updated_by = FND_GLOBAL.USER_ID,
917: last_update_login = FND_GLOBAL.LOGIN_ID,
918: last_update_date = SYSDATE
919: WHERE associated_request_id = FND_GLOBAL.conc_request_id;
920:
921: -- Bugfix 5347804: Need to update the most recent flag to 'N' for prior loads

Line 919: WHERE associated_request_id = FND_GLOBAL.conc_request_id;

915: end_time = SYSDATE,
916: last_updated_by = FND_GLOBAL.USER_ID,
917: last_update_login = FND_GLOBAL.LOGIN_ID,
918: last_update_date = SYSDATE
919: WHERE associated_request_id = FND_GLOBAL.conc_request_id;
920:
921: -- Bugfix 5347804: Need to update the most recent flag to 'N' for prior loads
922: UPDATE gcs_data_sub_dtls prev_runs
923: SET most_recent_flag = 'N'

Line 927: FND_GLOBAL.conc_request_id

923: SET most_recent_flag = 'N'
924: WHERE EXISTS (SELECT 'X'
925: FROM gcs_data_sub_dtls curr_run
926: WHERE curr_run.associated_request_id =
927: FND_GLOBAL.conc_request_id
928: AND curr_run.entity_id = prev_runs.entity_id
929: AND curr_run.cal_period_id = prev_runs.cal_period_id
930: AND curr_run.currency_code = prev_runs.currency_code
931: AND curr_run.balance_type_code = prev_runs.balance_type_code

Line 990: associated_request_id = FND_GLOBAL.conc_request_id

986: AND balance_type_code = l_datasub_info.balance_type_code;
987:
988: UPDATE gcs_data_sub_dtls
989: SET most_recent_flag = 'Y',
990: associated_request_id = FND_GLOBAL.conc_request_id
991: WHERE load_id = p_load_id;
992:
993: COMMIT;
994:

Line 2119: WHERE request_id = FND_GLOBAL.conc_request_id;

2115:
2116: SELECT status_code
2117: INTO l_status_code
2118: FROM fnd_concurrent_requests
2119: WHERE request_id = FND_GLOBAL.conc_request_id;
2120:
2121: UPDATE gcs_data_sub_dtls
2122: SET status_code = DECODE(l_status_code,
2123: 'C',

Line 2131: last_updated_by = FND_GLOBAL.USER_ID,

2127: 'W',
2128: 'WARNING',
2129: 'WARNING'),
2130: end_time = sysdate,
2131: last_updated_by = FND_GLOBAL.USER_ID,
2132: last_update_login = FND_GLOBAL.LOGIN_ID,
2133: last_update_date = sysdate
2134: WHERE load_id = l_datasub_info.load_id;
2135:

Line 2132: last_update_login = FND_GLOBAL.LOGIN_ID,

2128: 'WARNING',
2129: 'WARNING'),
2130: end_time = sysdate,
2131: last_updated_by = FND_GLOBAL.USER_ID,
2132: last_update_login = FND_GLOBAL.LOGIN_ID,
2133: last_update_date = sysdate
2134: WHERE load_id = l_datasub_info.load_id;
2135:
2136: IF (l_status_code <> 'C') THEN

Line 2141: FND_GLOBAL.conc_request_id ||

2137: IF (l_status_code = 'E') THEN
2138: -- Update the entire set of rows with the same error message
2139: UPDATE gcs_bal_interface_t
2140: SET error_message_code = 'Please refer to concurrent request : ' ||
2141: FND_GLOBAL.conc_request_id ||
2142: ' for more details.'
2143: WHERE load_id = l_datasub_info.load_id;
2144: ELSE
2145: -- Update the rows to check FEM_BAL_INTERFACE_T for remaining issues

Line 2376: l_user_id := FND_GLOBAL.user_id;

2372: l_bsv_high := WF_EVENT.getValueForParameter('BSV_RANGE_HIGH',
2373: l_parameter_list);
2374: l_status_code := WF_EVENT.getValueForParameter('STATUS_CODE',
2375: l_parameter_list);
2376: l_user_id := FND_GLOBAL.user_id;
2377: l_login_id := FND_GLOBAL.login_id;
2378: l_data_sub_exists_via_ui := 'N';
2379:
2380: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2377: l_login_id := FND_GLOBAL.login_id;

2373: l_parameter_list);
2374: l_status_code := WF_EVENT.getValueForParameter('STATUS_CODE',
2375: l_parameter_list);
2376: l_user_id := FND_GLOBAL.user_id;
2377: l_login_id := FND_GLOBAL.login_id;
2378: l_data_sub_exists_via_ui := 'N';
2379:
2380: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,