DBA Data[Home] [Help]

APPS.IEM_TAG_RUN_PROC_PVT dependencies on FND_MSG_PUB

Line 91: FND_MSG_PUB.initialize;

87: END IF;
88:
89: --Initialize the message list if p_init_msg_list is set to TRUE
90: If FND_API.to_Boolean(p_init_msg_list) THEN
91: FND_MSG_PUB.initialize;
92: END IF;
93:
94: --Initialize API status return
95: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 147: FND_MSG_PUB.ADD;

143: ROLLBACK TO validProcedure;
144: x_return_status := FND_API.G_RET_STS_ERROR;
145: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_INVALID');
146:
147: FND_MSG_PUB.ADD;
148: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
149:
150: WHEN IEM_TAG_PROC_NOT_EXIST THEN
151: ROLLBACK TO validProcedure;

Line 148: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

144: x_return_status := FND_API.G_RET_STS_ERROR;
145: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_INVALID');
146:
147: FND_MSG_PUB.ADD;
148: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
149:
150: WHEN IEM_TAG_PROC_NOT_EXIST THEN
151: ROLLBACK TO validProcedure;
152: x_return_status := FND_API.G_RET_STS_ERROR;

Line 155: FND_MSG_PUB.ADD;

151: ROLLBACK TO validProcedure;
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_NOT_EXIST');
154:
155: FND_MSG_PUB.ADD;
156: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
157:
158: WHEN IEM_TAG_PROC_NOT_EXIST_PACK THEN
159: ROLLBACK TO validProcedure;

Line 156: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_NOT_EXIST');
154:
155: FND_MSG_PUB.ADD;
156: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
157:
158: WHEN IEM_TAG_PROC_NOT_EXIST_PACK THEN
159: ROLLBACK TO validProcedure;
160: x_return_status := FND_API.G_RET_STS_ERROR;

Line 162: FND_MSG_PUB.ADD;

158: WHEN IEM_TAG_PROC_NOT_EXIST_PACK THEN
159: ROLLBACK TO validProcedure;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_NOT_EXIST');
162: FND_MSG_PUB.ADD;
163: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
164:
165: WHEN IEM_TAG_PROC_SYNTAX_ERR THEN
166: ROLLBACK TO validProcedure;

Line 163: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

159: ROLLBACK TO validProcedure;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_NOT_EXIST');
162: FND_MSG_PUB.ADD;
163: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
164:
165: WHEN IEM_TAG_PROC_SYNTAX_ERR THEN
166: ROLLBACK TO validProcedure;
167: x_return_status := FND_API.G_RET_STS_ERROR;

Line 169: FND_MSG_PUB.ADD;

165: WHEN IEM_TAG_PROC_SYNTAX_ERR THEN
166: ROLLBACK TO validProcedure;
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_SYNTAX_ERR');
169: FND_MSG_PUB.ADD;
170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
171:
172: WHEN IEM_TAG_PROC_NOT_EXIST_PACK_1 THEN
173: ROLLBACK TO validProcedure;

Line 170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

166: ROLLBACK TO validProcedure;
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_SYNTAX_ERR');
169: FND_MSG_PUB.ADD;
170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
171:
172: WHEN IEM_TAG_PROC_NOT_EXIST_PACK_1 THEN
173: ROLLBACK TO validProcedure;
174: x_return_status := FND_API.G_RET_STS_ERROR;

Line 176: FND_MSG_PUB.ADD;

172: WHEN IEM_TAG_PROC_NOT_EXIST_PACK_1 THEN
173: ROLLBACK TO validProcedure;
174: x_return_status := FND_API.G_RET_STS_ERROR;
175: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_NOT_EXIST');
176: FND_MSG_PUB.ADD;
177: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
178:
179: WHEN IEM_TAG_PROC_INVALID_1 THEN
180: ROLLBACK TO validProcedure;

Line 177: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

173: ROLLBACK TO validProcedure;
174: x_return_status := FND_API.G_RET_STS_ERROR;
175: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_NOT_EXIST');
176: FND_MSG_PUB.ADD;
177: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
178:
179: WHEN IEM_TAG_PROC_INVALID_1 THEN
180: ROLLBACK TO validProcedure;
181: x_return_status := FND_API.G_RET_STS_ERROR;

Line 183: FND_MSG_PUB.ADD;

179: WHEN IEM_TAG_PROC_INVALID_1 THEN
180: ROLLBACK TO validProcedure;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_INVALID');
183: FND_MSG_PUB.ADD;
184: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
185:
186: WHEN IEM_TAG_PROC_WRONG_SIGNATURE THEN
187: ROLLBACK TO validProcedure;

Line 184: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

180: ROLLBACK TO validProcedure;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_INVALID');
183: FND_MSG_PUB.ADD;
184: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
185:
186: WHEN IEM_TAG_PROC_WRONG_SIGNATURE THEN
187: ROLLBACK TO validProcedure;
188: x_return_status := FND_API.G_RET_STS_ERROR;

Line 191: FND_MSG_PUB.ADD;

187: ROLLBACK TO validProcedure;
188: x_return_status := FND_API.G_RET_STS_ERROR;
189: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_WRONG_SIGNATURE');
190:
191: FND_MSG_PUB.ADD;
192: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
193:
194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO validProcedure;

Line 192: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

188: x_return_status := FND_API.G_RET_STS_ERROR;
189: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_PROC_WRONG_SIGNATURE');
190:
191: FND_MSG_PUB.ADD;
192: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
193:
194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO validProcedure;
196: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 197: FND_MSG_PUB.Count_And_Get

193:
194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO validProcedure;
196: x_return_status := FND_API.G_RET_STS_ERROR ;
197: FND_MSG_PUB.Count_And_Get
198: ( p_count => x_msg_count,p_data => x_msg_data);
199:
200:
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 204: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);

200:
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: ROLLBACK TO validProcedure;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
204: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
205:
206:
207: WHEN OTHERS THEN
208: ROLLBACK TO validProcedure;

Line 210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

206:
207: WHEN OTHERS THEN
208: ROLLBACK TO validProcedure;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
211: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
212: END IF;
213:
214: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

Line 211: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

207: WHEN OTHERS THEN
208: ROLLBACK TO validProcedure;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
211: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
212: END IF;
213:
214: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
215: END;

Line 214: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
211: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
212: END IF;
213:
214: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
215: END;
216:
217:
218:

Line 266: FND_MSG_PUB.initialize;

262:
263: -- Initialize message list if p_init_msg_list is set to TRUE.
264: IF FND_API.to_Boolean( p_init_msg_list )
265: THEN
266: FND_MSG_PUB.initialize;
267: END IF;
268:
269:
270: -- Initialize API return status to SUCCESS

Line 333: FND_MSG_PUB.Count_And_Get

329: COMMIT WORK;
330: END IF;
331:
332: -- Standard callto get message count and if count is 1, get message info.
333: FND_MSG_PUB.Count_And_Get
334: ( p_count => x_msg_count,
335: p_data => x_msg_data
336: );
337:

Line 351: FND_MSG_PUB.Count_And_Get

347:
348: WHEN FND_API.G_EXC_ERROR THEN
349: ROLLBACK TO run_Procedure_PVT;
350: x_return_status := FND_API.G_RET_STS_ERROR ;
351: FND_MSG_PUB.Count_And_Get
352: ( p_count => x_msg_count,
353: p_data => x_msg_data
354: );
355: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 362: FND_MSG_PUB.Count_And_Get

358: end if;
359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
360: ROLLBACK TO run_Procedure_PVT;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362: FND_MSG_PUB.Count_And_Get
363: ( p_count => x_msg_count,
364: p_data => x_msg_data
365: );
366: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 374: IF FND_MSG_PUB.Check_Msg_Level

370: WHEN OTHERS THEN
371: ROLLBACK TO run_Procedure_PVT;
372: x_return_status := FND_API.G_RET_STS_ERROR;
373:
374: IF FND_MSG_PUB.Check_Msg_Level
375: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
376: THEN
377: FND_MSG_PUB.Add_Exc_Msg
378: ( G_PKG_NAME ,

Line 375: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

371: ROLLBACK TO run_Procedure_PVT;
372: x_return_status := FND_API.G_RET_STS_ERROR;
373:
374: IF FND_MSG_PUB.Check_Msg_Level
375: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
376: THEN
377: FND_MSG_PUB.Add_Exc_Msg
378: ( G_PKG_NAME ,
379: l_api_name

Line 377: FND_MSG_PUB.Add_Exc_Msg

373:
374: IF FND_MSG_PUB.Check_Msg_Level
375: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
376: THEN
377: FND_MSG_PUB.Add_Exc_Msg
378: ( G_PKG_NAME ,
379: l_api_name
380: );
381: END IF;

Line 383: FND_MSG_PUB.Count_And_Get

379: l_api_name
380: );
381: END IF;
382:
383: FND_MSG_PUB.Count_And_Get
384: ( p_count => x_msg_count,
385: p_data => x_msg_data
386: );
387: