DBA Data[Home] [Help]

APPS.IBE_MSITE_PRTY_ACCSS_MGR_PVT dependencies on FND_MSG_PUB

Line 76: FND_MSG_PUB.initialize;

72: END IF;
73:
74: -- Initialize message list if p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean(p_init_msg_list) THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: -- Initialize API return status to success
80: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 124: FND_MSG_PUB.Add;

120: );
121:
122: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
123: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_PRTY_FL');
124: FND_MSG_PUB.Add;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
127: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_PRTY_FL');
128: FND_MSG_PUB.Add;

Line 128: FND_MSG_PUB.Add;

124: FND_MSG_PUB.Add;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
127: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_PRTY_FL');
128: FND_MSG_PUB.Add;
129: RAISE FND_API.G_EXC_ERROR;
130: END IF;
131:
132: END IF;

Line 145: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

141: COMMIT WORK;
142: END IF;
143:
144: -- Standard call to get message count and if count is 1, get message info.
145: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
146: p_data => x_msg_data,
147: p_encoded => 'F');
148:
149: EXCEPTION

Line 154: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

150:
151: WHEN FND_API.G_EXC_ERROR THEN
152: ROLLBACK TO Associate_Parties_To_Msite_Pvt;
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
155: p_data => x_msg_data,
156: p_encoded => 'F');
157:
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 161: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

157:
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
159: ROLLBACK TO Associate_Parties_To_Msite_Pvt;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
162: p_data => x_msg_data,
163: p_encoded => 'F');
164:
165: WHEN OTHERS THEN

Line 171: FND_MSG_PUB.Add;

167: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
168: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
169: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
170: FND_MESSAGE.Set_Token('REASON', SQLERRM);
171: FND_MSG_PUB.Add;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173:
174: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN

Line 174: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

170: FND_MESSAGE.Set_Token('REASON', SQLERRM);
171: FND_MSG_PUB.Add;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173:
174: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
177: END IF;
178:

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

172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173:
174: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
177: END IF;
178:
179: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
180: p_data => x_msg_data,

Line 179: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

175: THEN
176: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
177: END IF;
178:
179: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
180: p_data => x_msg_data,
181: p_encoded => 'F');
182:
183: END Associate_Parties_To_MSite;

Line 227: FND_MSG_PUB.initialize;

223: END IF;
224:
225: -- Initialize message list if p_init_msg_list is set to TRUE.
226: IF FND_API.to_Boolean(p_init_msg_list) THEN
227: FND_MSG_PUB.initialize;
228: END IF;
229:
230: -- Initialize API return status to success
231: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 257: FND_MSG_PUB.Add;

253: );
254:
255: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
256: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_PRTY_FL');
257: FND_MSG_PUB.Add;
258: RAISE FND_API.G_EXC_ERROR;
259: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
260: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_PRTY_FL');
261: FND_MSG_PUB.Add;

Line 261: FND_MSG_PUB.Add;

257: FND_MSG_PUB.Add;
258: RAISE FND_API.G_EXC_ERROR;
259: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
260: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_PRTY_FL');
261: FND_MSG_PUB.Add;
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264:
265: ELSE

Line 286: FND_MSG_PUB.Add;

282: );
283:
284: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
285: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_PRTY_FL');
286: FND_MSG_PUB.Add;
287: RAISE FND_API.G_EXC_ERROR;
288: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
289: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_PRTY_FL');
290: FND_MSG_PUB.Add;

Line 290: FND_MSG_PUB.Add;

286: FND_MSG_PUB.Add;
287: RAISE FND_API.G_EXC_ERROR;
288: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
289: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_PRTY_FL');
290: FND_MSG_PUB.Add;
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:
294: END IF;

Line 306: FND_MSG_PUB.Add;

302: IF ((p_party_access_code IS NULL) OR
303: (p_party_access_code = FND_API.G_MISS_CHAR))
304: THEN
305: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INVLD_PRTY_ACSS_CODE');
306: FND_MSG_PUB.Add;
307: RAISE FND_API.G_EXC_ERROR;
308: END IF;
309:
310: BEGIN

Line 320: FND_MSG_PUB.Add;

316: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
317: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
318: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
319: FND_MESSAGE.Set_Token('REASON', SQLERRM);
320: FND_MSG_PUB.Add;
321:
322: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PRTY_ACCSS_CODE_FAIL');
323: FND_MESSAGE.Set_Token('PARTY_ACCESS_CODE', p_party_access_code);
324: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

Line 325: FND_MSG_PUB.Add;

321:
322: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PRTY_ACCSS_CODE_FAIL');
323: FND_MESSAGE.Set_Token('PARTY_ACCESS_CODE', p_party_access_code);
324: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
325: FND_MSG_PUB.Add;
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END;
328:
329: -- End of main API body.

Line 337: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

333: COMMIT WORK;
334: END IF;
335:
336: -- Standard call to get message count and if count is 1, get message info.
337: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
338: p_data => x_msg_data,
339: p_encoded => 'F');
340:
341: EXCEPTION

Line 346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO Update_Delete_Msite_Prty_Pvt;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
347: p_data => x_msg_data,
348: p_encoded => 'F');
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: ROLLBACK TO Update_Delete_Msite_Prty_Pvt;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
354: p_data => x_msg_data,
355: p_encoded => 'F');
356:
357: WHEN OTHERS THEN

Line 361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

357: WHEN OTHERS THEN
358: ROLLBACK TO Update_Delete_Msite_Prty_Pvt;
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360:
361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362: THEN
363: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
364: END IF;
365:

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

359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360:
361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362: THEN
363: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
364: END IF;
365:
366: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
367: p_data => x_msg_data,

Line 366: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

362: THEN
363: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
364: END IF;
365:
366: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
367: p_data => x_msg_data,
368: p_encoded => 'F');
369:
370: END Update_Delete_Msite_Prty;

Line 399: FND_MSG_PUB.initialize;

395: BEGIN
396:
397: -- Initialize message list if p_init_msg_list is set to TRUE.
398: IF FND_API.to_Boolean(p_init_msg_list) THEN
399: FND_MSG_PUB.initialize;
400: END IF;
401:
402: -- Initialize API return status to success
403: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 440: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

436: EXCEPTION
437:
438: WHEN FND_API.G_EXC_ERROR THEN
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
441: p_data => x_msg_data,
442: p_encoded => 'F');
443:
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 446: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

442: p_encoded => 'F');
443:
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
447: p_data => x_msg_data,
448: p_encoded => 'F');
449:
450: WHEN OTHERS THEN

Line 453: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

449:
450: WHEN OTHERS THEN
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
452:
453: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
456: END IF;
457:

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

451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
452:
453: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
456: END IF;
457:
458: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
459: p_data => x_msg_data,

Line 458: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

454: THEN
455: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
456: END IF;
457:
458: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
459: p_data => x_msg_data,
460: p_encoded => 'F');
461:
462: END Load_MsiteParties_For_Msite;