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.CN_TRANSACTION_LOAD_PKG dependencies on FND_GLOBAL

Line 68: l_user_id NUMBER(15) := fnd_global.user_id;

64: -- Unlockable batches will remain for the requred number of retries
65: -- Called just before program completes to purge the table of any remaining
66: -- unprocessed records that were not procesed during retries.
67: PROCEDURE void_batches(p_physical_batch_id NUMBER, p_logical_batch_id NUMBER) IS
68: l_user_id NUMBER(15) := fnd_global.user_id;
69: l_resp_id NUMBER(15) := fnd_global.resp_id;
70: l_login_id NUMBER(15) := fnd_global.login_id;
71: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
72: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 69: l_resp_id NUMBER(15) := fnd_global.resp_id;

65: -- Called just before program completes to purge the table of any remaining
66: -- unprocessed records that were not procesed during retries.
67: PROCEDURE void_batches(p_physical_batch_id NUMBER, p_logical_batch_id NUMBER) IS
68: l_user_id NUMBER(15) := fnd_global.user_id;
69: l_resp_id NUMBER(15) := fnd_global.resp_id;
70: l_login_id NUMBER(15) := fnd_global.login_id;
71: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
72: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
73: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

Line 70: l_login_id NUMBER(15) := fnd_global.login_id;

66: -- unprocessed records that were not procesed during retries.
67: PROCEDURE void_batches(p_physical_batch_id NUMBER, p_logical_batch_id NUMBER) IS
68: l_user_id NUMBER(15) := fnd_global.user_id;
69: l_resp_id NUMBER(15) := fnd_global.resp_id;
70: l_login_id NUMBER(15) := fnd_global.login_id;
71: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
72: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
73: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
74: BEGIN

Line 71: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

67: PROCEDURE void_batches(p_physical_batch_id NUMBER, p_logical_batch_id NUMBER) IS
68: l_user_id NUMBER(15) := fnd_global.user_id;
69: l_resp_id NUMBER(15) := fnd_global.resp_id;
70: l_login_id NUMBER(15) := fnd_global.login_id;
71: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
72: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
73: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
74: BEGIN
75: debugmsg(

Line 72: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

68: l_user_id NUMBER(15) := fnd_global.user_id;
69: l_resp_id NUMBER(15) := fnd_global.resp_id;
70: l_login_id NUMBER(15) := fnd_global.login_id;
71: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
72: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
73: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
74: BEGIN
75: debugmsg(
76: 'Void_batches : For physical batch : '

Line 73: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

69: l_resp_id NUMBER(15) := fnd_global.resp_id;
70: l_login_id NUMBER(15) := fnd_global.login_id;
71: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
72: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
73: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
74: BEGIN
75: debugmsg(
76: 'Void_batches : For physical batch : '
77: || p_physical_batch_id

Line 122: l_user_id NUMBER(15) := fnd_global.user_id;

118: x_physical_batch_id NUMBER;
119: l_srp_trx_count NUMBER := 0;
120: l_trx_count NUMBER := 0; -- number of trx in current physical batch
121: l_srp_count NUMBER := 0; -- number of srp in current physical batch
122: l_user_id NUMBER(15) := fnd_global.user_id;
123: l_resp_id NUMBER(15) := fnd_global.resp_id;
124: l_login_id NUMBER(15) := fnd_global.login_id;
125: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
126: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 123: l_resp_id NUMBER(15) := fnd_global.resp_id;

119: l_srp_trx_count NUMBER := 0;
120: l_trx_count NUMBER := 0; -- number of trx in current physical batch
121: l_srp_count NUMBER := 0; -- number of srp in current physical batch
122: l_user_id NUMBER(15) := fnd_global.user_id;
123: l_resp_id NUMBER(15) := fnd_global.resp_id;
124: l_login_id NUMBER(15) := fnd_global.login_id;
125: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
126: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
127: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

Line 124: l_login_id NUMBER(15) := fnd_global.login_id;

120: l_trx_count NUMBER := 0; -- number of trx in current physical batch
121: l_srp_count NUMBER := 0; -- number of srp in current physical batch
122: l_user_id NUMBER(15) := fnd_global.user_id;
123: l_resp_id NUMBER(15) := fnd_global.resp_id;
124: l_login_id NUMBER(15) := fnd_global.login_id;
125: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
126: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
127: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
128:

Line 125: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

121: l_srp_count NUMBER := 0; -- number of srp in current physical batch
122: l_user_id NUMBER(15) := fnd_global.user_id;
123: l_resp_id NUMBER(15) := fnd_global.resp_id;
124: l_login_id NUMBER(15) := fnd_global.login_id;
125: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
126: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
127: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
128:
129: CURSOR logical_batches IS

Line 126: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

122: l_user_id NUMBER(15) := fnd_global.user_id;
123: l_resp_id NUMBER(15) := fnd_global.resp_id;
124: l_login_id NUMBER(15) := fnd_global.login_id;
125: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
126: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
127: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
128:
129: CURSOR logical_batches IS
130: SELECT salesrep_id

Line 127: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

123: l_resp_id NUMBER(15) := fnd_global.resp_id;
124: l_login_id NUMBER(15) := fnd_global.login_id;
125: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
126: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
127: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
128:
129: CURSOR logical_batches IS
130: SELECT salesrep_id
131: , SUM(sales_lines_total) srp_trx_count

Line 258: l_user_id NUMBER(15) := fnd_global.user_id;

254: -- RAISE;
255: END assign;
256:
257: PROCEDURE update_error(x_physical_batch_id NUMBER) IS
258: l_user_id NUMBER(15) := fnd_global.user_id;
259: l_resp_id NUMBER(15) := fnd_global.resp_id;
260: l_login_id NUMBER(15) := fnd_global.login_id;
261: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
262: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 259: l_resp_id NUMBER(15) := fnd_global.resp_id;

255: END assign;
256:
257: PROCEDURE update_error(x_physical_batch_id NUMBER) IS
258: l_user_id NUMBER(15) := fnd_global.user_id;
259: l_resp_id NUMBER(15) := fnd_global.resp_id;
260: l_login_id NUMBER(15) := fnd_global.login_id;
261: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
262: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
263: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

Line 260: l_login_id NUMBER(15) := fnd_global.login_id;

256:
257: PROCEDURE update_error(x_physical_batch_id NUMBER) IS
258: l_user_id NUMBER(15) := fnd_global.user_id;
259: l_resp_id NUMBER(15) := fnd_global.resp_id;
260: l_login_id NUMBER(15) := fnd_global.login_id;
261: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
262: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
263: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
264: BEGIN

Line 261: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

257: PROCEDURE update_error(x_physical_batch_id NUMBER) IS
258: l_user_id NUMBER(15) := fnd_global.user_id;
259: l_resp_id NUMBER(15) := fnd_global.resp_id;
260: l_login_id NUMBER(15) := fnd_global.login_id;
261: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
262: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
263: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
264: BEGIN
265: -- Giving the batch an 'ERROR' status prevents subsequent

Line 262: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

258: l_user_id NUMBER(15) := fnd_global.user_id;
259: l_resp_id NUMBER(15) := fnd_global.resp_id;
260: l_login_id NUMBER(15) := fnd_global.login_id;
261: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
262: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
263: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
264: BEGIN
265: -- Giving the batch an 'ERROR' status prevents subsequent
266: -- physical processes picking it up.

Line 263: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

259: l_resp_id NUMBER(15) := fnd_global.resp_id;
260: l_login_id NUMBER(15) := fnd_global.login_id;
261: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
262: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
263: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
264: BEGIN
265: -- Giving the batch an 'ERROR' status prevents subsequent
266: -- physical processes picking it up.
267: UPDATE cn_process_batches

Line 374: l_user_id NUMBER(15) := fnd_global.user_id;

370: l_call_status BOOLEAN;
371: l_next_process VARCHAR2(30);
372: l_dummy VARCHAR2(500);
373: unfinished BOOLEAN := TRUE;
374: l_user_id NUMBER(15) := fnd_global.user_id;
375: l_resp_id NUMBER(15) := fnd_global.resp_id;
376: l_login_id NUMBER(15) := fnd_global.login_id;
377: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
378: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 375: l_resp_id NUMBER(15) := fnd_global.resp_id;

371: l_next_process VARCHAR2(30);
372: l_dummy VARCHAR2(500);
373: unfinished BOOLEAN := TRUE;
374: l_user_id NUMBER(15) := fnd_global.user_id;
375: l_resp_id NUMBER(15) := fnd_global.resp_id;
376: l_login_id NUMBER(15) := fnd_global.login_id;
377: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
378: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
379: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

Line 376: l_login_id NUMBER(15) := fnd_global.login_id;

372: l_dummy VARCHAR2(500);
373: unfinished BOOLEAN := TRUE;
374: l_user_id NUMBER(15) := fnd_global.user_id;
375: l_resp_id NUMBER(15) := fnd_global.resp_id;
376: l_login_id NUMBER(15) := fnd_global.login_id;
377: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
378: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
379: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
380: x_debug NUMBER;

Line 377: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

373: unfinished BOOLEAN := TRUE;
374: l_user_id NUMBER(15) := fnd_global.user_id;
375: l_resp_id NUMBER(15) := fnd_global.resp_id;
376: l_login_id NUMBER(15) := fnd_global.login_id;
377: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
378: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
379: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
380: x_debug NUMBER;
381: debug_v NUMBER;

Line 378: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

374: l_user_id NUMBER(15) := fnd_global.user_id;
375: l_resp_id NUMBER(15) := fnd_global.resp_id;
376: l_login_id NUMBER(15) := fnd_global.login_id;
377: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
378: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
379: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
380: x_debug NUMBER;
381: debug_v NUMBER;
382: conc_status BOOLEAN;

Line 379: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;

375: l_resp_id NUMBER(15) := fnd_global.resp_id;
376: l_login_id NUMBER(15) := fnd_global.login_id;
377: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
378: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
379: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
380: x_debug NUMBER;
381: debug_v NUMBER;
382: conc_status BOOLEAN;
383: l_sleep_time NUMBER := 180;

Line 1189: , x_request_id => fnd_global.conc_request_id

1185: cn_message_pkg.begin_batch(
1186: x_process_type => 'LOADER'
1187: , x_parent_proc_audit_id => NULL
1188: , x_process_audit_id => l_process_audit_id
1189: , x_request_id => fnd_global.conc_request_id
1190: , p_org_id => p_org_id
1191: );
1192:
1193: debugmsg('Loader : Start of Loader');

Line 1275: , fnd_global.user_id

1271: , batch.trx_count
1272: , 'IN_USE' -- Status Code
1273: , 'CREATED_BY_LOADER' -- Process Batch Type
1274: , SYSDATE
1275: , fnd_global.user_id
1276: , SYSDATE
1277: , fnd_global.user_id
1278: , fnd_global.login_id
1279: , fnd_global.conc_request_id

Line 1277: , fnd_global.user_id

1273: , 'CREATED_BY_LOADER' -- Process Batch Type
1274: , SYSDATE
1275: , fnd_global.user_id
1276: , SYSDATE
1277: , fnd_global.user_id
1278: , fnd_global.login_id
1279: , fnd_global.conc_request_id
1280: , fnd_global.prog_appl_id
1281: , fnd_global.conc_program_id

Line 1278: , fnd_global.login_id

1274: , SYSDATE
1275: , fnd_global.user_id
1276: , SYSDATE
1277: , fnd_global.user_id
1278: , fnd_global.login_id
1279: , fnd_global.conc_request_id
1280: , fnd_global.prog_appl_id
1281: , fnd_global.conc_program_id
1282: , SYSDATE

Line 1279: , fnd_global.conc_request_id

1275: , fnd_global.user_id
1276: , SYSDATE
1277: , fnd_global.user_id
1278: , fnd_global.login_id
1279: , fnd_global.conc_request_id
1280: , fnd_global.prog_appl_id
1281: , fnd_global.conc_program_id
1282: , SYSDATE
1283: , p_org_id

Line 1280: , fnd_global.prog_appl_id

1276: , SYSDATE
1277: , fnd_global.user_id
1278: , fnd_global.login_id
1279: , fnd_global.conc_request_id
1280: , fnd_global.prog_appl_id
1281: , fnd_global.conc_program_id
1282: , SYSDATE
1283: , p_org_id
1284: FROM (

Line 1281: , fnd_global.conc_program_id

1277: , fnd_global.user_id
1278: , fnd_global.login_id
1279: , fnd_global.conc_request_id
1280: , fnd_global.prog_appl_id
1281: , fnd_global.conc_program_id
1282: , SYSDATE
1283: , p_org_id
1284: FROM (
1285: SELECT api.employee_number employee_number