eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_DENORM_QUERIES_PVT dependencies on FND_MSG_PUB

Line 57: FND_MSG_PUB.initialize;

53:
54: OZF_Utility_PVT.debug_message(l_full_name||': start');
55:
56: IF FND_API.to_boolean(p_init_msg_list) THEN
57: FND_MSG_PUB.initialize;
58: END IF;
59:
60: IF NOT FND_API.compatible_api_call(
61: l_api_version,

Line 173: FND_MSG_PUB.count_and_get(

169: IF FND_API.to_boolean(p_commit) THEN
170: COMMIT;
171: END IF;
172:
173: FND_MSG_PUB.count_and_get(
174: p_encoded => FND_API.g_false,
175: p_count => x_msg_count,
176: p_data => x_msg_data
177: );

Line 186: FND_MSG_PUB.count_and_get(

182:
183: WHEN FND_API.g_exc_error THEN
184: ROLLBACK TO create_denorm_queries;
185: x_return_status := FND_API.g_ret_sts_error;
186: FND_MSG_PUB.count_and_get(
187: p_encoded => FND_API.g_false,
188: p_count => x_msg_count,
189: p_data => x_msg_data
190: );

Line 195: FND_MSG_PUB.count_and_get(

191:
192: WHEN FND_API.g_exc_unexpected_error THEN
193: ROLLBACK TO create_denorm_queries;
194: x_return_status := FND_API.g_ret_sts_unexp_error ;
195: FND_MSG_PUB.count_and_get(
196: p_encoded => FND_API.g_false,
197: p_count => x_msg_count,
198: p_data => x_msg_data
199: );

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

203:
204: ROLLBACK TO create_denorm_queries;
205: x_return_status := FND_API.g_ret_sts_unexp_error ;
206:
207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
208: THEN
209: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
210: END IF;
211:

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

205: x_return_status := FND_API.g_ret_sts_unexp_error ;
206:
207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
208: THEN
209: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
210: END IF;
211:
212: FND_MSG_PUB.count_and_get(
213: p_encoded => FND_API.g_false,

Line 212: FND_MSG_PUB.count_and_get(

208: THEN
209: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
210: END IF;
211:
212: FND_MSG_PUB.count_and_get(
213: p_encoded => FND_API.g_false,
214: p_count => x_msg_count,
215: p_data => x_msg_data
216: );

Line 264: FND_MSG_PUB.initialize;

260:
261: OZF_Utility_PVT.debug_message(l_full_name||': start');
262:
263: IF FND_API.to_boolean(p_init_msg_list) THEN
264: FND_MSG_PUB.initialize;
265: END IF;
266:
267: IF NOT FND_API.compatible_api_call(
268: l_api_version,

Line 331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

327: AND object_version_number =temp_denorm_queries_rec.object_version_number;
328:
329:
330: IF (SQL%NOTFOUND) THEN
331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
332: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
333: FND_MSG_PUB.add;
334: END IF;
335: RAISE FND_API.g_exc_error;

Line 333: FND_MSG_PUB.add;

329:
330: IF (SQL%NOTFOUND) THEN
331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
332: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
333: FND_MSG_PUB.add;
334: END IF;
335: RAISE FND_API.g_exc_error;
336: END IF;
337:

Line 346: FND_MSG_PUB.count_and_get(

342: IF FND_API.to_boolean(p_commit) THEN
343: COMMIT;
344: END IF;
345:
346: FND_MSG_PUB.count_and_get(
347: p_encoded => FND_API.g_false,
348: p_count => x_msg_count,
349: p_data => x_msg_data
350: );

Line 359: FND_MSG_PUB.count_and_get(

355:
356: WHEN FND_API.g_exc_error THEN
357: ROLLBACK TO update_denorm_queries;
358: x_return_status := FND_API.g_ret_sts_error;
359: FND_MSG_PUB.count_and_get(
360: p_encoded => FND_API.g_false,
361: p_count => x_msg_count,
362: p_data => x_msg_data
363: );

Line 368: FND_MSG_PUB.count_and_get(

364:
365: WHEN FND_API.g_exc_unexpected_error THEN
366: ROLLBACK TO update_denorm_queries;
367: x_return_status := FND_API.g_ret_sts_unexp_error ;
368: FND_MSG_PUB.count_and_get(
369: p_encoded => FND_API.g_false,
370: p_count => x_msg_count,
371: p_data => x_msg_data
372: );

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

376:
377: ROLLBACK TO update_denorm_queries;
378: x_return_status := FND_API.g_ret_sts_unexp_error ;
379:
380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
381: THEN
382: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
383: END IF;
384:

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

378: x_return_status := FND_API.g_ret_sts_unexp_error ;
379:
380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
381: THEN
382: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
383: END IF;
384:
385: FND_MSG_PUB.count_and_get(
386: p_encoded => FND_API.g_false,

Line 385: FND_MSG_PUB.count_and_get(

381: THEN
382: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
383: END IF;
384:
385: FND_MSG_PUB.count_and_get(
386: p_encoded => FND_API.g_false,
387: p_count => x_msg_count,
388: p_data => x_msg_data
389: );

Line 428: FND_MSG_PUB.initialize;

424:
425: OZF_Utility_PVT.debug_message(l_full_name||': start');
426:
427: IF FND_API.to_boolean(p_init_msg_list) THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430:
431: IF NOT FND_API.compatible_api_call(
432: l_api_version,

Line 455: FND_MSG_PUB.count_and_get(

451: IF FND_API.to_boolean(p_commit) THEN
452: COMMIT;
453: END IF;
454:
455: FND_MSG_PUB.count_and_get(
456: p_encoded => FND_API.g_false,
457: p_count => x_msg_count,
458: p_data => x_msg_data
459: );

Line 468: FND_MSG_PUB.count_and_get(

464:
465: WHEN FND_API.g_exc_error THEN
466: ROLLBACK TO delete_denorm_queries;
467: x_return_status := FND_API.g_ret_sts_error;
468: FND_MSG_PUB.count_and_get(
469: p_encoded => FND_API.g_false,
470: p_count => x_msg_count,
471: p_data => x_msg_data
472: );

Line 477: FND_MSG_PUB.count_and_get(

473:
474: WHEN FND_API.g_exc_unexpected_error THEN
475: ROLLBACK TO delete_denorm_queries;
476: x_return_status := FND_API.g_ret_sts_unexp_error ;
477: FND_MSG_PUB.count_and_get(
478: p_encoded => FND_API.g_false,
479: p_count => x_msg_count,
480: p_data => x_msg_data
481: );

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

483: WHEN OTHERS THEN
484: ROLLBACK TO delete_denorm_queries;
485: x_return_status := FND_API.g_ret_sts_unexp_error ;
486:
487: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
488: THEN
489: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
490: END IF;
491:

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

485: x_return_status := FND_API.g_ret_sts_unexp_error ;
486:
487: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
488: THEN
489: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
490: END IF;
491:
492: FND_MSG_PUB.count_and_get(
493: p_encoded => FND_API.g_false,

Line 492: FND_MSG_PUB.count_and_get(

488: THEN
489: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
490: END IF;
491:
492: FND_MSG_PUB.count_and_get(
493: p_encoded => FND_API.g_false,
494: p_count => x_msg_count,
495: p_data => x_msg_data
496: );

Line 532: FND_MSG_PUB.initialize;

528: ----------------------- initialize --------------------
529: OZF_Utility_PVT.debug_message(l_full_name||': start');
530:
531: IF FND_API.to_boolean(p_init_msg_list) THEN
532: FND_MSG_PUB.initialize;
533: END IF;
534:
535: IF NOT FND_API.compatible_api_call(
536: l_api_version,

Line 568: FND_MSG_PUB.count_and_get(

564:
565:
566:
567: -------------------- finish --------------------------
568: FND_MSG_PUB.count_and_get(
569: p_encoded => FND_API.g_false,
570: p_count => x_msg_count,
571: p_data => x_msg_data
572: );

Line 580: FND_MSG_PUB.count_and_get(

576: EXCEPTION
577:
578: WHEN FND_API.g_exc_error THEN
579: x_return_status := FND_API.g_ret_sts_error;
580: FND_MSG_PUB.count_and_get(
581: p_encoded => FND_API.g_false,
582: p_count => x_msg_count,
583: p_data => x_msg_data
584: );

Line 588: FND_MSG_PUB.count_and_get(

584: );
585:
586: WHEN FND_API.g_exc_unexpected_error THEN
587: x_return_status := FND_API.g_ret_sts_unexp_error ;
588: FND_MSG_PUB.count_and_get(
589: p_encoded => FND_API.g_false,
590: p_count => x_msg_count,
591: p_data => x_msg_data
592: );

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

592: );
593:
594: WHEN OTHERS THEN
595: x_return_status := FND_API.g_ret_sts_unexp_error;
596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
597: THEN
598: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
599: END IF;
600:

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

594: WHEN OTHERS THEN
595: x_return_status := FND_API.g_ret_sts_unexp_error;
596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
597: THEN
598: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
599: END IF;
600:
601: FND_MSG_PUB.count_and_get(
602: p_encoded => FND_API.g_false,

Line 601: FND_MSG_PUB.count_and_get(

597: THEN
598: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
599: END IF;
600:
601: FND_MSG_PUB.count_and_get(
602: p_encoded => FND_API.g_false,
603: p_count => x_msg_count,
604: p_data => x_msg_data
605: );

Line 648: FND_MSG_PUB.add;

644: IF(l_denorm_query_id<>p_denorm_queries_rec.denorm_query_id)THEN
645: OZF_Utility_PVT.debug_message('This record already exists');
646: x_return_status:='E';
647: FND_MESSAGE.set_name('OZF', 'OZF_DENORM_QUERIES_EXISTS');
648: FND_MSG_PUB.add;
649: END IF;
650: END IF;
651: */
652: NULL;

Line 675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

671: BEGIN
672:
673: x_return_status := FND_API.g_ret_sts_success;
674: IF (p_denorm_queries_rec.query_for IS NULL OR p_denorm_queries_rec.query_for = FND_API.g_miss_char) THEN
675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
676: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUERY_FOR_TYPE');
677: FND_MSG_PUB.add;
678: END IF;
679: x_return_status := FND_API.g_ret_sts_error;

Line 677: FND_MSG_PUB.add;

673: x_return_status := FND_API.g_ret_sts_success;
674: IF (p_denorm_queries_rec.query_for IS NULL OR p_denorm_queries_rec.query_for = FND_API.g_miss_char) THEN
675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
676: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUERY_FOR_TYPE');
677: FND_MSG_PUB.add;
678: END IF;
679: x_return_status := FND_API.g_ret_sts_error;
680: RETURN;
681: END IF;

Line 683: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

679: x_return_status := FND_API.g_ret_sts_error;
680: RETURN;
681: END IF;
682: IF (p_denorm_queries_rec.context IS NULL OR p_denorm_queries_rec.context = FND_API.g_miss_char) THEN
683: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
684: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUALIFIER_CONTEXT');
685: FND_MSG_PUB.add;
686: END IF;
687: x_return_status := FND_API.g_ret_sts_error;

Line 685: FND_MSG_PUB.add;

681: END IF;
682: IF (p_denorm_queries_rec.context IS NULL OR p_denorm_queries_rec.context = FND_API.g_miss_char) THEN
683: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
684: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUALIFIER_CONTEXT');
685: FND_MSG_PUB.add;
686: END IF;
687: x_return_status := FND_API.g_ret_sts_error;
688: RETURN;
689: END IF;

Line 692: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

688: RETURN;
689: END IF;
690: ------------------------ qualifier_context_attribute --------------------------
691: IF (p_denorm_queries_rec.attribute IS NULL OR p_denorm_queries_rec.attribute = FND_API.g_miss_char) THEN
692: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
693: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUALIFIER_CONTEXT_ATTR');
694: FND_MSG_PUB.add;
695: END IF;
696: x_return_status := FND_API.g_ret_sts_error;

Line 694: FND_MSG_PUB.add;

690: ------------------------ qualifier_context_attribute --------------------------
691: IF (p_denorm_queries_rec.attribute IS NULL OR p_denorm_queries_rec.attribute = FND_API.g_miss_char) THEN
692: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
693: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUALIFIER_CONTEXT_ATTR');
694: FND_MSG_PUB.add;
695: END IF;
696: x_return_status := FND_API.g_ret_sts_error;
697: RETURN;
698:

Line 706: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

702:
703:
704:
705: IF (p_denorm_queries_rec.SQL_STATEMENT IS NULL ) OR (p_denorm_queries_rec.SQL_STATEMENT = FND_API.g_miss_char) THEN
706: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
707: FND_MESSAGE.set_name('OZF', 'OZF_NO_SQLSTATEMENT');
708: FND_MSG_PUB.add;
709: END IF;
710: x_return_status := FND_API.g_ret_sts_error;

Line 708: FND_MSG_PUB.add;

704:
705: IF (p_denorm_queries_rec.SQL_STATEMENT IS NULL ) OR (p_denorm_queries_rec.SQL_STATEMENT = FND_API.g_miss_char) THEN
706: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
707: FND_MESSAGE.set_name('OZF', 'OZF_NO_SQLSTATEMENT');
708: FND_MSG_PUB.add;
709: END IF;
710: x_return_status := FND_API.g_ret_sts_error;
711: RETURN;
712: END IF;

Line 758: FND_MSG_PUB.add;

754: EXCEPTION
755: when others then
756: x_return_status := FND_API.g_ret_sts_error;
757: FND_MESSAGE.set_name('OZF','OZF_NO_SQLSTATEMENT');
758: FND_MSG_PUB.add;
759: FND_MESSAGE.SET_NAME('OZF','OZF_API_DEBUG_MESSAGE');
760: FND_MESSAGE.SET_TOKEN('TEXT',SQLERRM);
761: FND_MSG_PUB.add;
762: END check_denorm_queries_req_items;

Line 761: FND_MSG_PUB.add;

757: FND_MESSAGE.set_name('OZF','OZF_NO_SQLSTATEMENT');
758: FND_MSG_PUB.add;
759: FND_MESSAGE.SET_NAME('OZF','OZF_API_DEBUG_MESSAGE');
760: FND_MESSAGE.SET_TOKEN('TEXT',SQLERRM);
761: FND_MSG_PUB.add;
762: END check_denorm_queries_req_items;
763:
764:
765: ---------------------------------------------------------------------

Line 865: FND_MSG_PUB.add;

861: ELSE
862: OZF_Utility_PVT.debug_message('This record already exists');
863: x_return_status:='E';
864: FND_MESSAGE.set_name('OZF', 'OZF_DENORM_QUERIES_EXISTS');
865: FND_MSG_PUB.add;
866: END IF;
867: */
868: NULL;
869: END check_denorm_queries_record;

Line 919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

915: OPEN c_denorm_queries;
916: FETCH c_denorm_queries INTO l_denorm_queries_rec;
917: IF c_denorm_queries%NOTFOUND THEN
918: CLOSE c_denorm_queries;
919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
920: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
921: FND_MSG_PUB.add;
922: END IF;
923: RAISE FND_API.g_exc_error;

Line 921: FND_MSG_PUB.add;

917: IF c_denorm_queries%NOTFOUND THEN
918: CLOSE c_denorm_queries;
919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
920: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
921: FND_MSG_PUB.add;
922: END IF;
923: RAISE FND_API.g_exc_error;
924: END IF;
925: CLOSE c_denorm_queries;