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.31 2011/12/29 09:11:41 jrkumar 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 279: last_updated_by = fnd_global.user_id,

275:
276: UPDATE csi_txn_errors
277: SET error_text = l_error_message,
278: last_update_date = sysdate,
279: last_updated_by = fnd_global.user_id,
280: last_update_login = fnd_global.login_id
281: WHERE transaction_error_id = l_txn_error_id;
282:
283: EXCEPTION

Line 280: last_update_login = fnd_global.login_id

276: UPDATE csi_txn_errors
277: SET error_text = l_error_message,
278: last_update_date = sysdate,
279: last_updated_by = fnd_global.user_id,
280: last_update_login = fnd_global.login_id
281: WHERE transaction_error_id = l_txn_error_id;
282:
283: EXCEPTION
284: WHEN no_data_found THEN

Line 327: last_updated_by = fnd_global.user_id,

323:
324: UPDATE csi_txn_errors
325: SET error_text = l_error_message,
326: last_update_date = sysdate,
327: last_updated_by = fnd_global.user_id,
328: last_update_login = fnd_global.login_id
329: WHERE transaction_error_id = l_txn_error_id;
330: EXCEPTION
331: WHEN no_data_found THEN

Line 328: last_update_login = fnd_global.login_id

324: UPDATE csi_txn_errors
325: SET error_text = l_error_message,
326: last_update_date = sysdate,
327: last_updated_by = fnd_global.user_id,
328: last_update_login = fnd_global.login_id
329: WHERE transaction_error_id = l_txn_error_id;
330: EXCEPTION
331: WHEN no_data_found THEN
332: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;

Line 1295: source_group_ref_id = fnd_global.conc_request_id,

1291: END IF;
1292:
1293: UPDATE csi_txn_errors
1294: SET processed_flag = 'S',
1295: source_group_ref_id = fnd_global.conc_request_id,
1296: last_update_date = sysdate,
1297: last_updated_by = fnd_global.user_id
1298: WHERE transaction_error_id = txn_rec.transaction_error_id;
1299:

Line 1297: last_updated_by = fnd_global.user_id

1293: UPDATE csi_txn_errors
1294: SET processed_flag = 'S',
1295: source_group_ref_id = fnd_global.conc_request_id,
1296: last_update_date = sysdate,
1297: last_updated_by = fnd_global.user_id
1298: WHERE transaction_error_id = txn_rec.transaction_error_id;
1299:
1300: commit work;
1301:

Line 1309: source_group_ref_id = fnd_global.conc_request_id,

1305: rollback to eachtxn;
1306:
1307: UPDATE csi_txn_errors
1308: SET error_text = x_error_message,
1309: source_group_ref_id = fnd_global.conc_request_id,
1310: last_update_date = sysdate,
1311: last_updated_by = fnd_global.user_id
1312: WHERE transaction_error_id = txn_rec.transaction_error_id;
1313:

Line 1311: last_updated_by = fnd_global.user_id

1307: UPDATE csi_txn_errors
1308: SET error_text = x_error_message,
1309: source_group_ref_id = fnd_global.conc_request_id,
1310: last_update_date = sysdate,
1311: last_updated_by = fnd_global.user_id
1312: WHERE transaction_error_id = txn_rec.transaction_error_id;
1313:
1314: commit work;
1315: