DBA Data[Home] [Help]

APPS.IEM_REROUTING_HISTS_PVT dependencies on FND_MSG_PUB

Line 52: FND_MSG_PUB.initialize;

48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50: IF p_init_msg_list ='T'
51: THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54: select iem_reroute_hists_s1.nextval into l_seq_id from dual;
55: INSERT INTO IEM_REROUTE_HISTS (
56: reroute_id,

Line 111: FND_MSG_PUB.Count_And_Get

107: IF p_commit='T' THEN
108: COMMIT WORK;
109: END IF;
110: -- Standard callto get message count and if count is 1, get message info.
111: FND_MSG_PUB.Count_And_Get
112: ( p_count => x_msg_count,
113: p_data => x_msg_data
114: );
115: EXCEPTION

Line 118: FND_MSG_PUB.Count_And_Get

114: );
115: EXCEPTION
116: WHEN FND_API.G_EXC_ERROR THEN
117: x_return_status := FND_API.G_RET_STS_ERROR ;
118: FND_MSG_PUB.Count_And_Get
119: ( p_count => x_msg_count,
120: p_data => x_msg_data
121: );
122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 124: FND_MSG_PUB.Count_And_Get

120: p_data => x_msg_data
121: );
122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count,
126: p_data => x_msg_data
127: );
128: WHEN OTHERS THEN

Line 130: IF FND_MSG_PUB.Check_Msg_Level

126: p_data => x_msg_data
127: );
128: WHEN OTHERS THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: IF FND_MSG_PUB.Check_Msg_Level
131: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
132: THEN
133: FND_MSG_PUB.Add_Exc_Msg
134: ( G_PKG_NAME ,

Line 131: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

127: );
128: WHEN OTHERS THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: IF FND_MSG_PUB.Check_Msg_Level
131: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
132: THEN
133: FND_MSG_PUB.Add_Exc_Msg
134: ( G_PKG_NAME ,
135: l_api_name

Line 133: FND_MSG_PUB.Add_Exc_Msg

129: x_return_status := FND_API.G_RET_STS_ERROR;
130: IF FND_MSG_PUB.Check_Msg_Level
131: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
132: THEN
133: FND_MSG_PUB.Add_Exc_Msg
134: ( G_PKG_NAME ,
135: l_api_name
136: );
137: END IF;

Line 138: FND_MSG_PUB.Count_And_Get

134: ( G_PKG_NAME ,
135: l_api_name
136: );
137: END IF;
138: FND_MSG_PUB.Count_And_Get
139: ( p_count => x_msg_count ,
140: p_data => x_msg_data
141: );
142:

Line 169: FND_MSG_PUB.initialize;

165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166: -- Initialize message list if p_init_msg_list is set to TRUE.
167: IF p_init_msg_list ='T'
168: THEN
169: FND_MSG_PUB.initialize;
170: END IF;
171: delete from IEM_REROUTE_HISTS
172: where message_id=p_message_id;
173:

Line 179: FND_MSG_PUB.Count_And_Get

175: IF p_commit='T' THEN
176: COMMIT WORK;
177: END IF;
178: -- Standard callto get message count and if count is 1, get message info.
179: FND_MSG_PUB.Count_And_Get
180: ( p_count => x_msg_count,
181: p_data => x_msg_data
182: );
183: EXCEPTION

Line 187: FND_MSG_PUB.Count_And_Get

183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN
185: ROLLBACK TO delete_item_PVT;
186: x_return_status := FND_API.G_RET_STS_ERROR ;
187: FND_MSG_PUB.Count_And_Get
188: ( p_count => x_msg_count,
189: p_data => x_msg_data
190: );
191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 194: FND_MSG_PUB.Count_And_Get

190: );
191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
192: ROLLBACK TO delete_item_PVT;
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
194: FND_MSG_PUB.Count_And_Get
195: ( p_count => x_msg_count,
196: p_data => x_msg_data
197: );
198: WHEN OTHERS THEN

Line 201: IF FND_MSG_PUB.Check_Msg_Level

197: );
198: WHEN OTHERS THEN
199: ROLLBACK TO delete_item_PVT;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: IF FND_MSG_PUB.Check_Msg_Level
202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: FND_MSG_PUB.Add_Exc_Msg
205: ( G_PKG_NAME ,

Line 202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

198: WHEN OTHERS THEN
199: ROLLBACK TO delete_item_PVT;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: IF FND_MSG_PUB.Check_Msg_Level
202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: FND_MSG_PUB.Add_Exc_Msg
205: ( G_PKG_NAME ,
206: l_api_name

Line 204: FND_MSG_PUB.Add_Exc_Msg

200: x_return_status := FND_API.G_RET_STS_ERROR;
201: IF FND_MSG_PUB.Check_Msg_Level
202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: FND_MSG_PUB.Add_Exc_Msg
205: ( G_PKG_NAME ,
206: l_api_name
207: );
208: END IF;

Line 209: FND_MSG_PUB.Count_And_Get

205: ( G_PKG_NAME ,
206: l_api_name
207: );
208: END IF;
209: FND_MSG_PUB.Count_And_Get
210: ( p_count => x_msg_count ,
211: p_data => x_msg_data
212: );
213: