DBA Data[Home] [Help]

APPS.CSI_TRANSACTION_LINES_PVT dependencies on FND_GLOBAL

Line 60: l_request_id := FND_GLOBAL.conc_request_id;

56: --EXECUTE IMMEDIATE 'ALTER SESSION SET TRACEFILE_IDENTIFIER = ''HIMAL'' ';
57: --EXECUTE IMMEDIATE 'alter session set events=''10046 trace name context forever, level 12'' ';
58:
59: l_worker_start_date := SYSDATE;
60: l_request_id := FND_GLOBAL.conc_request_id;
61:
62: debug('BEGIN CSI_TRANSACTION_LINES_PVT.Process_Txn_Lines, Batch : '||p_batch_id);
63:
64: -- mark the rows as being processed by worker

Line 66: set processed_flag = 2,last_update_date = sysdate,last_updated_by = fnd_global.user_id

62: debug('BEGIN CSI_TRANSACTION_LINES_PVT.Process_Txn_Lines, Batch : '||p_batch_id);
63:
64: -- mark the rows as being processed by worker
65: update CSI_BATCH_TXN_LINES
66: set processed_flag = 2,last_update_date = sysdate,last_updated_by = fnd_global.user_id
67: where batch_id = p_batch_id
68: and processed_flag = 1;
69:
70: debug(' Updated '||SQL%ROWCOUNT ||' rows with batch id '||p_batch_id);

Line 102: SET processed_flag = 4,last_update_date = sysdate,last_updated_by = fnd_global.user_id

98: fnd_file.put_line(fnd_file.log,'Error Occured while processing Order Line '||l_line_id_tbl(i));
99: debug('Call to csi_inv_txnstub_pkg.execute_trx_dpl fails with status '||l_return_status);
100:
101: UPDATE CSI_BATCH_TXN_LINES
102: SET processed_flag = 4,last_update_date = sysdate,last_updated_by = fnd_global.user_id
103: WHERE batch_id = p_batch_id
104: AND processed_flag = 2
105: and order_line_id = l_line_id_tbl(i);
106:

Line 126: SET processed_flag = 4,last_update_date = sysdate,last_updated_by = fnd_global.user_id

122: fnd_file.put_line(fnd_file.log,'Error Occured while processing Order Line '||l_line_id_tbl(i));
123: debug('Call to csi_order_ship_pub.order_shipment fails with status '||l_return_status);
124:
125: UPDATE CSI_BATCH_TXN_LINES
126: SET processed_flag = 4,last_update_date = sysdate,last_updated_by = fnd_global.user_id
127: WHERE batch_id = p_batch_id
128: AND processed_flag = 2
129: AND order_line_id = l_line_id_tbl(i);
130:

Line 145: --VALUES( p_batch_id, l_header_id_tbl(i), l_line_id_tbl(i), l_start_date, sysdate,l_request_id,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id);

141: --debug('Timing information for order line '||l_line_id_tbl(i)||': '|| (SYSDATE - l_start_date)*(60*60*24) || ' seconds.');
142: debug('Timing information for order line '||l_line_id_tbl(i)||' using Timestamp: '||TO_CHAR(l_end_timestamp - l_start_timestamp));
143:
144: --INSERT INTO csi_batch_processing_times (worker_id, order_header_id, order_line_id, start_date, end_date,request_id,creation_date,created_by,last_update_date,last_updated_by)
145: --VALUES( p_batch_id, l_header_id_tbl(i), l_line_id_tbl(i), l_start_date, sysdate,l_request_id,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id);
146: end if;
147:
148: END Loop;
149: close transaction_lines_cur;

Line 162: SET processed_flag = 3,last_update_date = sysdate,last_updated_by = fnd_global.user_id

158: else
159:
160: -- mark the processed rows as success
161: UPDATE csi_batch_txn_lines
162: SET processed_flag = 3,last_update_date = sysdate,last_updated_by = fnd_global.user_id
163: where batch_id = p_batch_id
164: and processed_flag = 2;
165:
166: end if;

Line 176: (p_batch_id, l_worker_start_date, sysdate,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id);

172: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
173: INSERT INTO csi_batch_processing_times
174: (worker_id, start_date, end_date,creation_date,created_by,last_update_date,last_updated_by)
175: VALUES
176: (p_batch_id, l_worker_start_date, sysdate,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id);
177: END IF;*/
178:
179: --EXECUTE IMMEDIATE 'alter session set events=''10046 trace name context OFF'' ';
180:

Line 198: set batch_id = -1,processed_flag = 0,last_update_date = sysdate,last_updated_by = fnd_global.user_id

194:
195: ROLLBACK TO process_txn_lines;
196:
197: update csi_batch_txn_lines
198: set batch_id = -1,processed_flag = 0,last_update_date = sysdate,last_updated_by = fnd_global.user_id
199: where batch_id = p_batch_id;
200:
201: commit;
202: RAISE;