61: EXCEPTION
62:
63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
64: x_retcode := 2;
65: x_errbuff := substrb(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
66: RAISE;
67:
68: WHEN OTHERS THEN
69: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
65: x_errbuff := substrb(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
66: RAISE;
67:
68: WHEN OTHERS THEN
69: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
70: THEN
71: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
72: ,'consumption_txn_worker'
73: );
67:
68: WHEN OTHERS THEN
69: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
70: THEN
71: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
72: ,'consumption_txn_worker'
73: );
74: x_retcode := 2;
75: x_errbuff :=
72: ,'consumption_txn_worker'
73: );
74: x_retcode := 2;
75: x_errbuff :=
76: substrb(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
77: RAISE;
78:
79: END IF;
80:
116: EXCEPTION
117:
118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
119: x_retcode := 2;
120: x_errbuff := substrb(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
121: RAISE;
122:
123: WHEN OTHERS THEN
124: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
120: x_errbuff := substrb(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
121: RAISE;
122:
123: WHEN OTHERS THEN
124: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
125: THEN
126: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
127: , 'consumption_txn_manager'
128: );
122:
123: WHEN OTHERS THEN
124: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
125: THEN
126: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
127: , 'consumption_txn_manager'
128: );
129: x_retcode := 2;
130: x_errbuff :=
127: , 'consumption_txn_manager'
128: );
129: x_retcode := 2;
130: x_errbuff :=
131: substrb(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
132: RAISE;
133:
134: END IF;
135: