117: -- p_payroll_action_id => pactid,
118: p_return_status => l_return_status);
119:
120: fnd_file.put_line(fnd_file.log, 'Insert into Template History failed '||sqlerrm);
121: raise fnd_api.g_exc_unexpected_error;
122:
123: END;
124:
125:
174: p_source_id => NULL,
175: p_error_message => l_msg_str,
176: -- p_payroll_action_id => pactid,
177: p_return_status => l_return_status);
178: raise fnd_api.g_exc_unexpected_error;
179: END IF;
180: END IF;
181:
182:
249:
250: fnd_message.set_name('PSP', 'PSP_COMP_EFF_MIG');
251: fnd_msg_pub.add;
252:
253: raise fnd_api.g_exc_unexpected_error;
254:
255: END IF;
256:
257:
260: EXCEPTION WHEN OTHERS THEN
261:
262: psp_message_s.print_error(p_mode=>FND_FILE.log,
263:
264: p_print_header=>FND_API.G_TRUE);
265:
266: sqlstr:= NULL;
267: commit;
268: raise fnd_api.g_exc_unexpected_error;
264: p_print_header=>FND_API.G_TRUE);
265:
266: sqlstr:= NULL;
267: commit;
268: raise fnd_api.g_exc_unexpected_error;
269: END;
270:
271:
272: