DBA Data[Home] [Help]

APPS.CSD_REPAIR_ESTIMATE_PUB dependencies on FND_MSG_PUB

Line 66: Fnd_Msg_Pub.initialize;

62: END IF;
63: -- Initialize message list if p_init_msg_list is set to TRUE.
64: IF Fnd_Api.to_Boolean(p_init_msg_list)
65: THEN
66: Fnd_Msg_Pub.initialize;
67: END IF;
68: -- Initialize API return status to success
69: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
70: --

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

94: THEN
95: COMMIT WORK;
96: END IF;
97: -- Standard call to get message count and if count is 1, get message info.
98: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
99: p_data => x_msg_data);
100: --
101: EXCEPTION
102: WHEN Fnd_Api.g_exc_error THEN

Line 105: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

101: EXCEPTION
102: WHEN Fnd_Api.g_exc_error THEN
103: x_return_status := Fnd_Api.g_ret_sts_error;
104: ROLLBACK TO CREATE_ESTIMATE_HEADER_PUB;
105: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
106: p_data => x_msg_data);
107:
108: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
109: THEN

Line 117: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

113: END IF;
114: WHEN Fnd_Api.g_exc_unexpected_error THEN
115: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
116: ROLLBACK TO CREATE_ESTIMATE_HEADER_PUB;
117: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
118: p_data => x_msg_data);
119:
120: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
121: THEN

Line 130: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)

126: WHEN OTHERS THEN
127: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
128: ROLLBACK TO CREATE_ESTIMATE_HEADER_PUB;
129:
130: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
131: THEN
132: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
133: END IF;
134:

Line 132: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);

128: ROLLBACK TO CREATE_ESTIMATE_HEADER_PUB;
129:
130: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
131: THEN
132: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
133: END IF;
134:
135: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
136: p_data => x_msg_data);

Line 135: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

131: THEN
132: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
133: END IF;
134:
135: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
136: p_data => x_msg_data);
137:
138: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
139: THEN

Line 191: Fnd_Msg_Pub.initialize;

187: END IF;
188: -- Initialize message list if p_init_msg_list is set to TRUE.
189: IF Fnd_Api.to_Boolean(p_init_msg_list)
190: THEN
191: Fnd_Msg_Pub.initialize;
192: END IF;
193: -- Initialize API return status to success
194: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
195: --

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

220: THEN
221: COMMIT WORK;
222: END IF;
223: -- Standard call to get message count and if count is 1, get message info.
224: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
225: p_data => x_msg_data);
226: --
227: EXCEPTION
228: WHEN Fnd_Api.g_exc_error THEN

Line 231: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

227: EXCEPTION
228: WHEN Fnd_Api.g_exc_error THEN
229: x_return_status := Fnd_Api.g_ret_sts_error;
230: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PUB;
231: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
232: p_data => x_msg_data);
233:
234: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
235: THEN

Line 243: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

239: END IF;
240: WHEN Fnd_Api.g_exc_unexpected_error THEN
241: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
242: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PUB;
243: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
244: p_data => x_msg_data);
245:
246: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
247: THEN

Line 256: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)

252: WHEN OTHERS THEN
253: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
254: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PUB;
255:
256: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
257: THEN
258: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
259: END IF;
260:

Line 258: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);

254: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PUB;
255:
256: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
257: THEN
258: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
259: END IF;
260:
261: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
262: p_data => x_msg_data);

Line 261: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

257: THEN
258: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
259: END IF;
260:
261: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
262: p_data => x_msg_data);
263:
264: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
265: THEN

Line 320: Fnd_Msg_Pub.initialize;

316: END IF;
317: -- Initialize message list if p_init_msg_list is set to TRUE.
318: IF Fnd_Api.to_Boolean(p_init_msg_list)
319: THEN
320: Fnd_Msg_Pub.initialize;
321: END IF;
322: -- Initialize API return status to success
323: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
324: --

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

348: THEN
349: COMMIT WORK;
350: END IF;
351: -- Standard call to get message count and if count is 1, get message info.
352: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
353: p_data => x_msg_data);
354: --
355: EXCEPTION
356: WHEN Fnd_Api.g_exc_error THEN

Line 359: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

355: EXCEPTION
356: WHEN Fnd_Api.g_exc_error THEN
357: x_return_status := Fnd_Api.g_ret_sts_error;
358: ROLLBACK TO CREATE_ESTIMATE_LINE_PUB;
359: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
360: p_data => x_msg_data);
361:
362: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
363: THEN

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

367: END IF;
368: WHEN Fnd_Api.g_exc_unexpected_error THEN
369: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
370: ROLLBACK TO CREATE_ESTIMATE_LINE_PUB;
371: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
372: p_data => x_msg_data);
373:
374: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
375: THEN

Line 384: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)

380: WHEN OTHERS THEN
381: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
382: ROLLBACK TO CREATE_ESTIMATE_LINE_PUB;
383:
384: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
385: THEN
386: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
387: END IF;
388:

Line 386: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);

382: ROLLBACK TO CREATE_ESTIMATE_LINE_PUB;
383:
384: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
385: THEN
386: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
387: END IF;
388:
389: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
390: p_data => x_msg_data);

Line 389: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

385: THEN
386: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
387: END IF;
388:
389: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
390: p_data => x_msg_data);
391:
392: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
393: THEN

Line 448: Fnd_Msg_Pub.initialize;

444: END IF;
445: -- Initialize message list if p_init_msg_list is set to TRUE.
446: IF Fnd_Api.to_Boolean(p_init_msg_list)
447: THEN
448: Fnd_Msg_Pub.initialize;
449: END IF;
450: -- Initialize API return status to success
451: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
452: --

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

476: THEN
477: COMMIT WORK;
478: END IF;
479: -- Standard call to get message count and if count is 1, get message info.
480: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
481: p_data => x_msg_data);
482: --
483: EXCEPTION
484: WHEN Fnd_Api.g_exc_error THEN

Line 487: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

483: EXCEPTION
484: WHEN Fnd_Api.g_exc_error THEN
485: x_return_status := Fnd_Api.g_ret_sts_error;
486: ROLLBACK TO UPDATE_ESTIMATE_LINE_PUB;
487: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
488: p_data => x_msg_data);
489:
490: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
491: THEN

Line 499: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

495: END IF;
496: WHEN Fnd_Api.g_exc_unexpected_error THEN
497: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
498: ROLLBACK TO UPDATE_ESTIMATE_LINE_PUB;
499: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
500: p_data => x_msg_data);
501:
502: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
503: THEN

Line 512: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)

508: WHEN OTHERS THEN
509: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
510: ROLLBACK TO UPDATE_ESTIMATE_LINE_PUB;
511:
512: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
513: THEN
514: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
515: END IF;
516:

Line 514: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);

510: ROLLBACK TO UPDATE_ESTIMATE_LINE_PUB;
511:
512: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
513: THEN
514: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
515: END IF;
516:
517: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
518: p_data => x_msg_data);

Line 517: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

513: THEN
514: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
515: END IF;
516:
517: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
518: p_data => x_msg_data);
519:
520: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
521: THEN