124: SET error_code = X_error_code
125: , error_explanation = X_error_msg
126: , pm_cost_collected = 'E'
127: , last_update_date = sysdate
128: , last_updated_by = fnd_global.user_id
129: , request_id = fnd_global.conc_request_id
130: , program_application_id = fnd_global.prog_appl_id
131: , program_id = fnd_global.conc_program_id
132: , program_update_date = sysdate
125: , error_explanation = X_error_msg
126: , pm_cost_collected = 'E'
127: , last_update_date = sysdate
128: , last_updated_by = fnd_global.user_id
129: , request_id = fnd_global.conc_request_id
130: , program_application_id = fnd_global.prog_appl_id
131: , program_id = fnd_global.conc_program_id
132: , program_update_date = sysdate
133: WHERE transaction_id = X_transaction_id;
126: , pm_cost_collected = 'E'
127: , last_update_date = sysdate
128: , last_updated_by = fnd_global.user_id
129: , request_id = fnd_global.conc_request_id
130: , program_application_id = fnd_global.prog_appl_id
131: , program_id = fnd_global.conc_program_id
132: , program_update_date = sysdate
133: WHERE transaction_id = X_transaction_id;
134:
127: , last_update_date = sysdate
128: , last_updated_by = fnd_global.user_id
129: , request_id = fnd_global.conc_request_id
130: , program_application_id = fnd_global.prog_appl_id
131: , program_id = fnd_global.conc_program_id
132: , program_update_date = sysdate
133: WHERE transaction_id = X_transaction_id;
134:
135: EXCEPTION
164: L_login_id NUMBER;
165: L_stmt_num NUMBER;
166: BEGIN
167:
168: L_user_id := fnd_global.user_id;
169: L_login_id := fnd_global.conc_login_id;
170: L_request_id := fnd_global.conc_request_id;
171: L_prog_appl_id := fnd_global.prog_appl_id;
172: L_prog_id := fnd_global.conc_program_id;
165: L_stmt_num NUMBER;
166: BEGIN
167:
168: L_user_id := fnd_global.user_id;
169: L_login_id := fnd_global.conc_login_id;
170: L_request_id := fnd_global.conc_request_id;
171: L_prog_appl_id := fnd_global.prog_appl_id;
172: L_prog_id := fnd_global.conc_program_id;
173:
166: BEGIN
167:
168: L_user_id := fnd_global.user_id;
169: L_login_id := fnd_global.conc_login_id;
170: L_request_id := fnd_global.conc_request_id;
171: L_prog_appl_id := fnd_global.prog_appl_id;
172: L_prog_id := fnd_global.conc_program_id;
173:
174: L_stmt_num := 10;
167:
168: L_user_id := fnd_global.user_id;
169: L_login_id := fnd_global.conc_login_id;
170: L_request_id := fnd_global.conc_request_id;
171: L_prog_appl_id := fnd_global.prog_appl_id;
172: L_prog_id := fnd_global.conc_program_id;
173:
174: L_stmt_num := 10;
175:
168: L_user_id := fnd_global.user_id;
169: L_login_id := fnd_global.conc_login_id;
170: L_request_id := fnd_global.conc_request_id;
171: L_prog_appl_id := fnd_global.prog_appl_id;
172: L_prog_id := fnd_global.conc_program_id;
173:
174: L_stmt_num := 10;
175:
176: UPDATE wip_transactions