DBA Data[Home] [Help]

APPS.AMS_METRIC_PUB dependencies on FND_MSG_PUB

Line 19: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

15: --
16: -- HISTORY
17: -- 10/14/99 ptendulk Created.
18: ---------------------------------------------------------------------
19: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
20: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
21: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
22:
23: PROCEDURE Create_Metric(

Line 20: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

16: -- HISTORY
17: -- 10/14/99 ptendulk Created.
18: ---------------------------------------------------------------------
19: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
20: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
21: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
22:
23: PROCEDURE Create_Metric(
24: p_api_version IN NUMBER,

Line 21: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

17: -- 10/14/99 ptendulk Created.
18: ---------------------------------------------------------------------
19: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
20: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
21: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
22:
23: PROCEDURE Create_Metric(
24: p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 49: FND_MSG_PUB.initialize;

45:
46: -- initialize the message list;
47: -- won't do it again when calling private API
48: IF FND_API.to_boolean(p_init_msg_list) THEN
49: FND_MSG_PUB.initialize;
50: END IF;
51:
52: -- call business API
53: AMS_Metric_PVT.Create_Metric(

Line 78: FND_MSG_PUB.count_and_get(

74: IF FND_API.to_boolean(p_commit) THEN
75: COMMIT;
76: END IF;
77: x_return_status := FND_API.g_ret_sts_success;
78: FND_MSG_PUB.count_and_get(
79: p_encoded => FND_API.g_false,
80: p_count => x_msg_count,
81: p_data => x_msg_data
82: );

Line 89: FND_MSG_PUB.count_and_get(

85:
86: WHEN FND_API.g_exc_error THEN
87: ROLLBACK TO create_metric_pub;
88: x_return_status := FND_API.g_ret_sts_error;
89: FND_MSG_PUB.count_and_get(
90: p_encoded => FND_API.g_false,
91: p_count => x_msg_count,
92: p_data => x_msg_data
93: );

Line 98: FND_MSG_PUB.count_and_get(

94:
95: WHEN FND_API.g_exc_unexpected_error THEN
96: ROLLBACK TO create_metric_pub;
97: x_return_status := FND_API.g_ret_sts_unexp_error ;
98: FND_MSG_PUB.count_and_get(
99: p_encoded => FND_API.g_false,
100: p_count => x_msg_count,
101: p_data => x_msg_data
102: );

Line 109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

105: WHEN OTHERS THEN
106: ROLLBACK TO create_metric_pub;
107: x_return_status := FND_API.g_ret_sts_unexp_error ;
108:
109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
110: THEN
111: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
112: END IF;
113:

Line 111: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

107: x_return_status := FND_API.g_ret_sts_unexp_error ;
108:
109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
110: THEN
111: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
112: END IF;
113:
114: FND_MSG_PUB.count_and_get(
115: p_encoded => FND_API.g_false,

Line 114: FND_MSG_PUB.count_and_get(

110: THEN
111: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
112: END IF;
113:
114: FND_MSG_PUB.count_and_get(
115: p_encoded => FND_API.g_false,
116: p_count => x_msg_count,
117: p_data => x_msg_data
118: );

Line 160: FND_MSG_PUB.initialize;

156:
157: -- initialize the message list;
158: -- won't do it again when calling private API
159: IF FND_API.to_boolean(p_init_msg_list) THEN
160: FND_MSG_PUB.initialize;
161: END IF;
162:
163: -- call business API
164: AMS_Metric_PVT.Delete_Metric(

Line 188: FND_MSG_PUB.count_and_get(

184: IF FND_API.to_boolean(p_commit) THEN
185: COMMIT;
186: END IF;
187: x_return_status := FND_API.g_ret_sts_success;
188: FND_MSG_PUB.count_and_get(
189: p_encoded => FND_API.g_false,
190: p_count => x_msg_count,
191: p_data => x_msg_data
192: );

Line 200: FND_MSG_PUB.count_and_get(

196:
197: WHEN FND_API.g_exc_error THEN
198: ROLLBACK TO delete_metric_pub;
199: x_return_status := FND_API.g_ret_sts_error;
200: FND_MSG_PUB.count_and_get(
201: p_encoded => FND_API.g_false,
202: p_count => x_msg_count,
203: p_data => x_msg_data
204: );

Line 209: FND_MSG_PUB.count_and_get(

205:
206: WHEN FND_API.g_exc_unexpected_error THEN
207: ROLLBACK TO delete_metric_pub;
208: x_return_status := FND_API.g_ret_sts_unexp_error ;
209: FND_MSG_PUB.count_and_get(
210: p_encoded => FND_API.g_false,
211: p_count => x_msg_count,
212: p_data => x_msg_data
213: );

Line 220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

216: WHEN OTHERS THEN
217: ROLLBACK TO delete_metric_pub;
218: x_return_status := FND_API.g_ret_sts_unexp_error ;
219:
220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
221: THEN
222: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
223: END IF;
224:

Line 222: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

218: x_return_status := FND_API.g_ret_sts_unexp_error ;
219:
220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
221: THEN
222: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
223: END IF;
224:
225: FND_MSG_PUB.count_and_get(
226: p_encoded => FND_API.g_false,

Line 225: FND_MSG_PUB.count_and_get(

221: THEN
222: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
223: END IF;
224:
225: FND_MSG_PUB.count_and_get(
226: p_encoded => FND_API.g_false,
227: p_count => x_msg_count,
228: p_data => x_msg_data
229: );

Line 270: FND_MSG_PUB.initialize;

266:
267: -- initialize the message list;
268: -- won't do it again when calling private API
269: IF FND_API.to_boolean(p_init_msg_list) THEN
270: FND_MSG_PUB.initialize;
271: END IF;
272:
273: -- call business API
274: AMS_Metric_PVT.Lock_Metric(

Line 293: FND_MSG_PUB.count_and_get(

289: RAISE FND_API.g_exc_unexpected_error;
290: END IF;
291:
292: x_return_status := FND_API.g_ret_sts_success;
293: FND_MSG_PUB.count_and_get(
294: p_encoded => FND_API.g_false,
295: p_count => x_msg_count,
296: p_data => x_msg_data
297: );

Line 304: FND_MSG_PUB.count_and_get(

300:
301: WHEN FND_API.g_exc_error THEN
302: ROLLBACK TO lock_metric_pub;
303: x_return_status := FND_API.g_ret_sts_error;
304: FND_MSG_PUB.count_and_get(
305: p_encoded => FND_API.g_false,
306: p_count => x_msg_count,
307: p_data => x_msg_data
308: );

Line 313: FND_MSG_PUB.count_and_get(

309:
310: WHEN FND_API.g_exc_unexpected_error THEN
311: ROLLBACK TO lock_metric_pub;
312: x_return_status := FND_API.g_ret_sts_unexp_error ;
313: FND_MSG_PUB.count_and_get(
314: p_encoded => FND_API.g_false,
315: p_count => x_msg_count,
316: p_data => x_msg_data
317: );

Line 324: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

320: WHEN OTHERS THEN
321: ROLLBACK TO lock_metric_pub;
322: x_return_status := FND_API.g_ret_sts_unexp_error ;
323:
324: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
325: THEN
326: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
327: END IF;
328:

Line 326: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

322: x_return_status := FND_API.g_ret_sts_unexp_error ;
323:
324: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
325: THEN
326: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
327: END IF;
328:
329: FND_MSG_PUB.count_and_get(
330: p_encoded => FND_API.g_false,

Line 329: FND_MSG_PUB.count_and_get(

325: THEN
326: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
327: END IF;
328:
329: FND_MSG_PUB.count_and_get(
330: p_encoded => FND_API.g_false,
331: p_count => x_msg_count,
332: p_data => x_msg_data
333: );

Line 374: FND_MSG_PUB.initialize;

370:
371: -- initialize the message list;
372: -- won't do it again when calling private API
373: IF FND_API.to_boolean(p_init_msg_list) THEN
374: FND_MSG_PUB.initialize;
375: END IF;
376:
377: -- call business API
378: AMS_Metric_PVT.Update_Metric(

Line 402: FND_MSG_PUB.count_and_get(

398: IF FND_API.to_boolean(p_commit) THEN
399: COMMIT;
400: END IF;
401: x_return_status := FND_API.g_ret_sts_success;
402: FND_MSG_PUB.count_and_get(
403: p_encoded => FND_API.g_false,
404: p_count => x_msg_count,
405: p_data => x_msg_data
406: );

Line 413: FND_MSG_PUB.count_and_get(

409:
410: WHEN FND_API.g_exc_error THEN
411: ROLLBACK TO update_metric_pub;
412: x_return_status := FND_API.g_ret_sts_error;
413: FND_MSG_PUB.count_and_get(
414: p_encoded => FND_API.g_false,
415: p_count => x_msg_count,
416: p_data => x_msg_data
417: );

Line 422: FND_MSG_PUB.count_and_get(

418:
419: WHEN FND_API.g_exc_unexpected_error THEN
420: ROLLBACK TO update_metric_pub;
421: x_return_status := FND_API.g_ret_sts_unexp_error ;
422: FND_MSG_PUB.count_and_get(
423: p_encoded => FND_API.g_false,
424: p_count => x_msg_count,
425: p_data => x_msg_data
426: );

Line 433: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

429: WHEN OTHERS THEN
430: ROLLBACK TO update_metric_pub;
431: x_return_status := FND_API.g_ret_sts_unexp_error ;
432:
433: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
434: THEN
435: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
436: END IF;
437:

Line 435: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

431: x_return_status := FND_API.g_ret_sts_unexp_error ;
432:
433: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
434: THEN
435: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
436: END IF;
437:
438: FND_MSG_PUB.count_and_get(
439: p_encoded => FND_API.g_false,

Line 438: FND_MSG_PUB.count_and_get(

434: THEN
435: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
436: END IF;
437:
438: FND_MSG_PUB.count_and_get(
439: p_encoded => FND_API.g_false,
440: p_count => x_msg_count,
441: p_data => x_msg_data
442: );

Line 482: FND_MSG_PUB.initialize;

478:
479: -- initialize the message list;
480: -- won't do it again when calling private API
481: IF FND_API.to_boolean(p_init_msg_list) THEN
482: FND_MSG_PUB.initialize;
483: END IF;
484:
485: -- call business API
486: AMS_Metric_PVT.Validate_Metric(

Line 505: FND_MSG_PUB.count_and_get(

501: RAISE FND_API.g_exc_unexpected_error;
502: END IF;
503:
504: x_return_status := FND_API.g_ret_sts_success;
505: FND_MSG_PUB.count_and_get(
506: p_encoded => FND_API.g_false,
507: p_count => x_msg_count,
508: p_data => x_msg_data
509: );

Line 516: FND_MSG_PUB.count_and_get(

512:
513: WHEN FND_API.g_exc_error THEN
514: ROLLBACK TO validate_metric_pub;
515: x_return_status := FND_API.g_ret_sts_error;
516: FND_MSG_PUB.count_and_get(
517: p_encoded => FND_API.g_false,
518: p_count => x_msg_count,
519: p_data => x_msg_data
520: );

Line 525: FND_MSG_PUB.count_and_get(

521:
522: WHEN FND_API.g_exc_unexpected_error THEN
523: ROLLBACK TO validate_metric_pub;
524: x_return_status := FND_API.g_ret_sts_unexp_error ;
525: FND_MSG_PUB.count_and_get(
526: p_encoded => FND_API.g_false,
527: p_count => x_msg_count,
528: p_data => x_msg_data
529: );

Line 536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

532: WHEN OTHERS THEN
533: ROLLBACK TO validate_metric_pub;
534: x_return_status := FND_API.g_ret_sts_unexp_error ;
535:
536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
537: THEN
538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
539: END IF;
540:

Line 538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

534: x_return_status := FND_API.g_ret_sts_unexp_error ;
535:
536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
537: THEN
538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
539: END IF;
540:
541: FND_MSG_PUB.count_and_get(
542: p_encoded => FND_API.g_false,

Line 541: FND_MSG_PUB.count_and_get(

537: THEN
538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
539: END IF;
540:
541: FND_MSG_PUB.count_and_get(
542: p_encoded => FND_API.g_false,
543: p_count => x_msg_count,
544: p_data => x_msg_data
545: );