DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PUB dependencies on FND_MSG_PUB

Line 92: FND_MSG_PUB.initialize;

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

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

158: THEN
159: COMMIT WORK;
160: END IF;
161: -- Standard call to get message count and if count is 1, get message info.
162: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
163: p_data => x_msg_data);
164: --
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN

Line 169: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
168: P_PKG_NAME => G_PKG_NAME,
169: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
170: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
171: X_MSG_COUNT => X_MSG_COUNT,
172: X_MSG_DATA => X_MSG_DATA,
173: X_RETURN_STATUS => X_RETURN_STATUS);

Line 179: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

175: --
176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
177: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
178: P_PKG_NAME => G_PKG_NAME,
179: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
180: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
181: X_MSG_COUNT => X_MSG_COUNT,
182: X_MSG_DATA => X_MSG_DATA,
183: X_RETURN_STATUS => X_RETURN_STATUS);

Line 226: FND_MSG_PUB.initialize;

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

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

254: THEN
255: COMMIT WORK;
256: END IF;
257: -- Standard call to get message count and if count is 1, get message info.
258: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
259: p_data => x_msg_data);
260: --
261: EXCEPTION
262: WHEN FND_API.G_EXC_ERROR THEN

Line 265: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

261: EXCEPTION
262: WHEN FND_API.G_EXC_ERROR THEN
263: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
264: P_PKG_NAME => G_PKG_NAME,
265: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
266: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
267: X_MSG_COUNT => X_MSG_COUNT,
268: X_MSG_DATA => X_MSG_DATA,
269: X_RETURN_STATUS => X_RETURN_STATUS);

Line 275: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

271: --
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
274: P_PKG_NAME => G_PKG_NAME,
275: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
276: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
277: X_MSG_COUNT => X_MSG_COUNT,
278: X_MSG_DATA => X_MSG_DATA,
279: X_RETURN_STATUS => X_RETURN_STATUS);

Line 325: FND_MSG_PUB.initialize;

321: END IF;
322: -- Initialize message list if p_init_msg_list is set to TRUE.
323: IF FND_API.to_Boolean(p_init_msg_list)
324: THEN
325: FND_MSG_PUB.initialize;
326: END IF;
327: -- Initialize API return status to success
328: x_return_status := FND_API.G_RET_STS_SUCCESS;
329: --

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

360: THEN
361: COMMIT WORK;
362: END IF;
363: -- Standard call to get message count and if count is 1, get message info.
364: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
365: p_data => x_msg_data);
366: --
367: EXCEPTION
368: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 371: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

367: EXCEPTION
368: WHEN Fnd_Api.G_EXC_ERROR THEN
369: x_return_status := Fnd_Api.G_RET_STS_ERROR;
370: ROLLBACK TO UPDATE_REPAIR_TYPE_PUB;
371: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
372: p_data => x_msg_data);
373: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
374: THEN
375: Fnd_Log.STRING(Fnd_Log.level_error,

Line 383: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

379:
380: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
381: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
382: ROLLBACK TO UPDATE_REPAIR_TYPE_PUB;
383: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
384: p_data => x_msg_data);
385: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
386: THEN
387: Fnd_Log.STRING(Fnd_Log.level_exception,

Line 394: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

390: END IF;
391: WHEN OTHERS THEN
392: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
393: Rollback TO UPDATE_REPAIR_TYPE_PUB;
394: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
395: THEN
396: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
397: END IF;
398: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 396: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);

392: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
393: Rollback TO UPDATE_REPAIR_TYPE_PUB;
394: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
395: THEN
396: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
397: END IF;
398: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
399: p_data => x_msg_data);
400: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

Line 398: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

394: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
395: THEN
396: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
397: END IF;
398: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
399: p_data => x_msg_data);
400: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
401: THEN
402: Fnd_Log.STRING(Fnd_Log.level_exception,

Line 454: FND_MSG_PUB.initialize;

450: END IF;
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean(p_init_msg_list)
453: THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456: -- Initialize API return status to success
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458: --

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

483: THEN
484: COMMIT WORK;
485: END IF;
486: -- Standard call to get message count and if count is 1, get message info.
487: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
488: p_data => x_msg_data);
489: --
490: EXCEPTION
491: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 494: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

490: EXCEPTION
491: WHEN Fnd_Api.G_EXC_ERROR THEN
492: x_return_status := Fnd_Api.G_RET_STS_ERROR;
493: ROLLBACK TO UPDATE_RO_STATUS_PUB;
494: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
495: p_data => x_msg_data);
496: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
497: THEN
498: Fnd_Log.STRING(Fnd_Log.level_error,

Line 506: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

502:
503: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
505: ROLLBACK TO UPDATE_RO_STATUS_PUB;
506: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
507: p_data => x_msg_data);
508: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
509: THEN
510: Fnd_Log.STRING(Fnd_Log.level_exception,

Line 517: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

513: END IF;
514: WHEN OTHERS THEN
515: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
516: Rollback TO UPDATE_RO_STATUS_PUB;
517: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
518: THEN
519: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
520: END IF;
521: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 519: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);

515: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
516: Rollback TO UPDATE_RO_STATUS_PUB;
517: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
518: THEN
519: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
520: END IF;
521: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
522: p_data => x_msg_data);
523: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

Line 521: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

517: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
518: THEN
519: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
520: END IF;
521: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
522: p_data => x_msg_data);
523: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
524: THEN
525: Fnd_Log.STRING(Fnd_Log.level_exception,