1: package body PJI_MAP_ROWSET_MEASURE as
2: -- $Header: PJIRWSTB.pls 120.1 2007/02/01 15:57:54 pschandr ship $
3:
4: g_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
5: g_last_update_date DATE := SYSDATE;
79: EXCEPTION
80: WHEN NULL_VALUE then
81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
82: x_msg_count := x_msg_count + 1;
83: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.insert_row');
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: x_msg_count := x_msg_count + 1;
87: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.insert_row');
83: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.insert_row');
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: x_msg_count := x_msg_count + 1;
87: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.insert_row');
88: ROLLBACK;
89: --return;
90: END insert_row;
91:
201: EXCEPTION
202: WHEN NULL_VALUE THEN
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: x_msg_count := x_msg_count + 1;
205: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.update_row');
206: RAISE;
207: WHEN OTHERS THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: x_msg_count := x_msg_count + 1;
206: RAISE;
207: WHEN OTHERS THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: x_msg_count := x_msg_count + 1;
210: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.update_row');
211: ROLLBACK;
212: RAISE;
213: END update_row;
214:
230: EXCEPTION
231: WHEN OTHERS THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: x_msg_count := x_msg_count + 1;
234: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.delete_row');
235: END delete_row;
236:
237: end PJI_MAP_ROWSET_MEASURE;
233: x_msg_count := x_msg_count + 1;
234: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.delete_row');
235: END delete_row;
236:
237: end PJI_MAP_ROWSET_MEASURE;