122: p_data => x_msg_data
123: );
124:
125: WHEN OTHERS THEN
126: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
127: fnd_message.set_token('P_SQLCODE',SQLCODE);
128: fnd_message.set_token('P_SQLERRM',SQLERRM);
129: fnd_message.set_token('P_API_NAME',l_api_name);
130: FND_MSG_PUB.add;
123: );
124:
125: WHEN OTHERS THEN
126: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
127: fnd_message.set_token('P_SQLCODE',SQLCODE);
128: fnd_message.set_token('P_SQLERRM',SQLERRM);
129: fnd_message.set_token('P_API_NAME',l_api_name);
130: FND_MSG_PUB.add;
131:
124:
125: WHEN OTHERS THEN
126: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
127: fnd_message.set_token('P_SQLCODE',SQLCODE);
128: fnd_message.set_token('P_SQLERRM',SQLERRM);
129: fnd_message.set_token('P_API_NAME',l_api_name);
130: FND_MSG_PUB.add;
131:
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
125: WHEN OTHERS THEN
126: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
127: fnd_message.set_token('P_SQLCODE',SQLCODE);
128: fnd_message.set_token('P_SQLERRM',SQLERRM);
129: fnd_message.set_token('P_API_NAME',l_api_name);
130: FND_MSG_PUB.add;
131:
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
251: p_data => x_msg_data
252: );
253:
254: WHEN OTHERS THEN
255: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
256: fnd_message.set_token('P_SQLCODE',SQLCODE);
257: fnd_message.set_token('P_SQLERRM',SQLERRM);
258: fnd_message.set_token('P_API_NAME',l_api_name);
259: FND_MSG_PUB.add;
252: );
253:
254: WHEN OTHERS THEN
255: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
256: fnd_message.set_token('P_SQLCODE',SQLCODE);
257: fnd_message.set_token('P_SQLERRM',SQLERRM);
258: fnd_message.set_token('P_API_NAME',l_api_name);
259: FND_MSG_PUB.add;
260:
253:
254: WHEN OTHERS THEN
255: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
256: fnd_message.set_token('P_SQLCODE',SQLCODE);
257: fnd_message.set_token('P_SQLERRM',SQLERRM);
258: fnd_message.set_token('P_API_NAME',l_api_name);
259: FND_MSG_PUB.add;
260:
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: WHEN OTHERS THEN
255: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
256: fnd_message.set_token('P_SQLCODE',SQLCODE);
257: fnd_message.set_token('P_SQLERRM',SQLERRM);
258: fnd_message.set_token('P_API_NAME',l_api_name);
259: FND_MSG_PUB.add;
260:
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
262: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
360: p_data => x_msg_data
361: );
362:
363: WHEN OTHERS THEN
364: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
365: fnd_message.set_token('P_SQLCODE',SQLCODE);
366: fnd_message.set_token('P_SQLERRM',SQLERRM);
367: fnd_message.set_token('P_API_NAME',l_api_name);
368: FND_MSG_PUB.add;
361: );
362:
363: WHEN OTHERS THEN
364: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
365: fnd_message.set_token('P_SQLCODE',SQLCODE);
366: fnd_message.set_token('P_SQLERRM',SQLERRM);
367: fnd_message.set_token('P_API_NAME',l_api_name);
368: FND_MSG_PUB.add;
369:
362:
363: WHEN OTHERS THEN
364: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
365: fnd_message.set_token('P_SQLCODE',SQLCODE);
366: fnd_message.set_token('P_SQLERRM',SQLERRM);
367: fnd_message.set_token('P_API_NAME',l_api_name);
368: FND_MSG_PUB.add;
369:
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
363: WHEN OTHERS THEN
364: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
365: fnd_message.set_token('P_SQLCODE',SQLCODE);
366: fnd_message.set_token('P_SQLERRM',SQLERRM);
367: fnd_message.set_token('P_API_NAME',l_api_name);
368: FND_MSG_PUB.add;
369:
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
371: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN