DBA Data[Home] [Help]

APPS.CSE_FAC_INSERVICE_PKG dependencies on FND_GLOBAL

Line 5: g_request_id NUMBER := NVL(FND_GLOBAL.conc_request_id,-1);

1: PACKAGE BODY cse_fac_inservice_pkg AS
2: /* $Header: CSEFPISB.pls 120.23.12010000.3 2008/10/09 19:52:49 rsinn ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('CSE_DEBUG_OPTION'),'N');
5: g_request_id NUMBER := NVL(FND_GLOBAL.conc_request_id,-1);
6:
7: PROCEDURE debug(
8: p_message IN varchar2)
9: IS

Line 13: IF nvl(fnd_global.conc_request_id,-1) <> -1 THEN

9: IS
10: BEGIN
11: IF l_debug = 'Y' THEN
12: cse_debug_pub.add(p_message);
13: IF nvl(fnd_global.conc_request_id,-1) <> -1 THEN
14: fnd_file.put_line(fnd_file.log,p_message);
15: END IF;
16: END IF;
17: EXCEPTION

Line 36: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;

32:
33: x_return_status := fnd_api.g_ret_sts_success;
34:
35: l_txn_rec.transaction_id := p_csi_txn_id;
36: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;
37: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;
38:
39: SELECT object_version_number
40: INTO l_txn_rec.object_version_number

Line 266: last_updated_by = fnd_global.user_id,

262:
263: UPDATE csi_txn_errors
264: SET error_text = l_error_message,
265: last_update_date = sysdate,
266: last_updated_by = fnd_global.user_id,
267: last_update_login = fnd_global.login_id
268: WHERE transaction_error_id = l_txn_error_id;
269:
270: EXCEPTION

Line 267: last_update_login = fnd_global.login_id

263: UPDATE csi_txn_errors
264: SET error_text = l_error_message,
265: last_update_date = sysdate,
266: last_updated_by = fnd_global.user_id,
267: last_update_login = fnd_global.login_id
268: WHERE transaction_error_id = l_txn_error_id;
269:
270: EXCEPTION
271: WHEN no_data_found THEN

Line 314: last_updated_by = fnd_global.user_id,

310:
311: UPDATE csi_txn_errors
312: SET error_text = l_error_message,
313: last_update_date = sysdate,
314: last_updated_by = fnd_global.user_id,
315: last_update_login = fnd_global.login_id
316: WHERE transaction_error_id = l_txn_error_id;
317: EXCEPTION
318: WHEN no_data_found THEN

Line 315: last_update_login = fnd_global.login_id

311: UPDATE csi_txn_errors
312: SET error_text = l_error_message,
313: last_update_date = sysdate,
314: last_updated_by = fnd_global.user_id,
315: last_update_login = fnd_global.login_id
316: WHERE transaction_error_id = l_txn_error_id;
317: EXCEPTION
318: WHEN no_data_found THEN
319: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;

Line 1260: source_group_ref_id = fnd_global.conc_request_id,

1256: END IF;
1257:
1258: UPDATE csi_txn_errors
1259: SET processed_flag = 'S',
1260: source_group_ref_id = fnd_global.conc_request_id,
1261: last_update_date = sysdate,
1262: last_updated_by = fnd_global.user_id
1263: WHERE transaction_error_id = txn_rec.transaction_error_id;
1264:

Line 1262: last_updated_by = fnd_global.user_id

1258: UPDATE csi_txn_errors
1259: SET processed_flag = 'S',
1260: source_group_ref_id = fnd_global.conc_request_id,
1261: last_update_date = sysdate,
1262: last_updated_by = fnd_global.user_id
1263: WHERE transaction_error_id = txn_rec.transaction_error_id;
1264:
1265: commit work;
1266:

Line 1274: source_group_ref_id = fnd_global.conc_request_id,

1270: rollback to eachtxn;
1271:
1272: UPDATE csi_txn_errors
1273: SET error_text = x_error_message,
1274: source_group_ref_id = fnd_global.conc_request_id,
1275: last_update_date = sysdate,
1276: last_updated_by = fnd_global.user_id
1277: WHERE transaction_error_id = txn_rec.transaction_error_id;
1278:

Line 1276: last_updated_by = fnd_global.user_id

1272: UPDATE csi_txn_errors
1273: SET error_text = x_error_message,
1274: source_group_ref_id = fnd_global.conc_request_id,
1275: last_update_date = sysdate,
1276: last_updated_by = fnd_global.user_id
1277: WHERE transaction_error_id = txn_rec.transaction_error_id;
1278:
1279: commit work;
1280: