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.AMS_EVENTOFFER_PUB dependencies on FND_MSG_PUB

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

11: --
12: -- HISTORY
13: -- 10/01/99 holiu Created.
14: ---------------------------------------------------------------------
15: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
16: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
17: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
18:
19: PROCEDURE create_EventOffer(

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

12: -- HISTORY
13: -- 10/01/99 holiu Created.
14: ---------------------------------------------------------------------
15: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
16: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
17: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
18:
19: PROCEDURE create_EventOffer(
20: p_api_version IN NUMBER,

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

13: -- 10/01/99 holiu Created.
14: ---------------------------------------------------------------------
15: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
16: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
17: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
18:
19: PROCEDURE create_EventOffer(
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 45: FND_MSG_PUB.initialize;

41:
42: -- initialize the message list;
43: -- won't do it again when calling private API
44: IF FND_API.to_boolean(p_init_msg_list) THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: -- customer pre-processing
49: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')

Line 135: FND_MSG_PUB.count_and_get(

131: IF FND_API.to_boolean(p_commit) THEN
132: COMMIT;
133: END IF;
134: x_return_status := FND_API.g_ret_sts_success;
135: FND_MSG_PUB.count_and_get(
136: p_encoded => FND_API.g_false,
137: p_count => x_msg_count,
138: p_data => x_msg_data
139: );

Line 146: FND_MSG_PUB.count_and_get(

142:
143: WHEN FND_API.g_exc_error THEN
144: ROLLBACK TO create_EventOffer_pub;
145: x_return_status := FND_API.g_ret_sts_error;
146: FND_MSG_PUB.count_and_get(
147: p_encoded => FND_API.g_false,
148: p_count => x_msg_count,
149: p_data => x_msg_data
150: );

Line 155: FND_MSG_PUB.count_and_get(

151:
152: WHEN FND_API.g_exc_unexpected_error THEN
153: ROLLBACK TO create_EventOffer_pub;
154: x_return_status := FND_API.g_ret_sts_unexp_error ;
155: FND_MSG_PUB.count_and_get(
156: p_encoded => FND_API.g_false,
157: p_count => x_msg_count,
158: p_data => x_msg_data
159: );

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

162: WHEN OTHERS THEN
163: ROLLBACK TO create_EventOffer_pub;
164: x_return_status := FND_API.g_ret_sts_unexp_error ;
165:
166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
167: THEN
168: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
169: END IF;
170:

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

164: x_return_status := FND_API.g_ret_sts_unexp_error ;
165:
166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
167: THEN
168: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
169: END IF;
170:
171: FND_MSG_PUB.count_and_get(
172: p_encoded => FND_API.g_false,

Line 171: FND_MSG_PUB.count_and_get(

167: THEN
168: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
169: END IF;
170:
171: FND_MSG_PUB.count_and_get(
172: p_encoded => FND_API.g_false,
173: p_count => x_msg_count,
174: p_data => x_msg_data
175: );

Line 213: FND_MSG_PUB.initialize;

209:
210: -- initialize the message list;
211: -- won't do it again when calling private API
212: IF FND_API.to_boolean(p_init_msg_list) THEN
213: FND_MSG_PUB.initialize;
214: END IF;
215:
216: -- customer pre-processing
217: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')

Line 304: FND_MSG_PUB.count_and_get(

300: IF FND_API.to_boolean(p_commit) THEN
301: COMMIT;
302: END IF;
303: x_return_status := FND_API.g_ret_sts_success;
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 316: FND_MSG_PUB.count_and_get(

312:
313: WHEN FND_API.g_exc_error THEN
314: ROLLBACK TO delete_EventOffer_pub;
315: x_return_status := FND_API.g_ret_sts_error;
316: FND_MSG_PUB.count_and_get(
317: p_encoded => FND_API.g_false,
318: p_count => x_msg_count,
319: p_data => x_msg_data
320: );

Line 325: FND_MSG_PUB.count_and_get(

321:
322: WHEN FND_API.g_exc_unexpected_error THEN
323: ROLLBACK TO delete_EventOffer_pub;
324: x_return_status := FND_API.g_ret_sts_unexp_error ;
325: FND_MSG_PUB.count_and_get(
326: p_encoded => FND_API.g_false,
327: p_count => x_msg_count,
328: p_data => x_msg_data
329: );

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

332: WHEN OTHERS THEN
333: ROLLBACK TO delete_EventOffer_pub;
334: x_return_status := FND_API.g_ret_sts_unexp_error ;
335:
336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
337: THEN
338: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
339: END IF;
340:

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

334: x_return_status := FND_API.g_ret_sts_unexp_error ;
335:
336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
337: THEN
338: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
339: END IF;
340:
341: FND_MSG_PUB.count_and_get(
342: p_encoded => FND_API.g_false,

Line 341: FND_MSG_PUB.count_and_get(

337: THEN
338: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
339: END IF;
340:
341: FND_MSG_PUB.count_and_get(
342: p_encoded => FND_API.g_false,
343: p_count => x_msg_count,
344: p_data => x_msg_data
345: );

Line 382: FND_MSG_PUB.initialize;

378:
379: -- initialize the message list;
380: -- won't do it again when calling private API
381: IF FND_API.to_boolean(p_init_msg_list) THEN
382: FND_MSG_PUB.initialize;
383: END IF;
384:
385: -- customer pre-processing
386: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')

Line 469: FND_MSG_PUB.count_and_get(

465: END IF;
466: END IF;
467:
468: x_return_status := FND_API.g_ret_sts_success;
469: FND_MSG_PUB.count_and_get(
470: p_encoded => FND_API.g_false,
471: p_count => x_msg_count,
472: p_data => x_msg_data
473: );

Line 480: FND_MSG_PUB.count_and_get(

476:
477: WHEN FND_API.g_exc_error THEN
478: ROLLBACK TO lock_EventOffer_pub;
479: x_return_status := FND_API.g_ret_sts_error;
480: FND_MSG_PUB.count_and_get(
481: p_encoded => FND_API.g_false,
482: p_count => x_msg_count,
483: p_data => x_msg_data
484: );

Line 489: FND_MSG_PUB.count_and_get(

485:
486: WHEN FND_API.g_exc_unexpected_error THEN
487: ROLLBACK TO lock_EventOffer_pub;
488: x_return_status := FND_API.g_ret_sts_unexp_error ;
489: FND_MSG_PUB.count_and_get(
490: p_encoded => FND_API.g_false,
491: p_count => x_msg_count,
492: p_data => x_msg_data
493: );

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

496: WHEN OTHERS THEN
497: ROLLBACK TO lock_EventOffer_pub;
498: x_return_status := FND_API.g_ret_sts_unexp_error ;
499:
500: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
501: THEN
502: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
503: END IF;
504:

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

498: x_return_status := FND_API.g_ret_sts_unexp_error ;
499:
500: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
501: THEN
502: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
503: END IF;
504:
505: FND_MSG_PUB.count_and_get(
506: p_encoded => FND_API.g_false,

Line 505: FND_MSG_PUB.count_and_get(

501: THEN
502: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
503: END IF;
504:
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 546: FND_MSG_PUB.initialize;

542:
543: -- initialize the message list;
544: -- won't do it again when calling private API
545: IF FND_API.to_boolean(p_init_msg_list) THEN
546: FND_MSG_PUB.initialize;
547: END IF;
548:
549: -- customer pre-processing
550: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')

Line 633: FND_MSG_PUB.count_and_get(

629: IF FND_API.to_boolean(p_commit) THEN
630: COMMIT;
631: END IF;
632: x_return_status := FND_API.g_ret_sts_success;
633: FND_MSG_PUB.count_and_get(
634: p_encoded => FND_API.g_false,
635: p_count => x_msg_count,
636: p_data => x_msg_data
637: );

Line 644: FND_MSG_PUB.count_and_get(

640:
641: WHEN FND_API.g_exc_error THEN
642: ROLLBACK TO update_EventOffer_pub;
643: x_return_status := FND_API.g_ret_sts_error;
644: FND_MSG_PUB.count_and_get(
645: p_encoded => FND_API.g_false,
646: p_count => x_msg_count,
647: p_data => x_msg_data
648: );

Line 653: FND_MSG_PUB.count_and_get(

649:
650: WHEN FND_API.g_exc_unexpected_error THEN
651: ROLLBACK TO update_EventOffer_pub;
652: x_return_status := FND_API.g_ret_sts_unexp_error ;
653: FND_MSG_PUB.count_and_get(
654: p_encoded => FND_API.g_false,
655: p_count => x_msg_count,
656: p_data => x_msg_data
657: );

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

660: WHEN OTHERS THEN
661: ROLLBACK TO update_EventOffer_pub;
662: x_return_status := FND_API.g_ret_sts_unexp_error ;
663:
664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
665: THEN
666: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
667: END IF;
668:

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

662: x_return_status := FND_API.g_ret_sts_unexp_error ;
663:
664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
665: THEN
666: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
667: END IF;
668:
669: FND_MSG_PUB.count_and_get(
670: p_encoded => FND_API.g_false,

Line 669: FND_MSG_PUB.count_and_get(

665: THEN
666: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
667: END IF;
668:
669: FND_MSG_PUB.count_and_get(
670: p_encoded => FND_API.g_false,
671: p_count => x_msg_count,
672: p_data => x_msg_data
673: );

Line 709: FND_MSG_PUB.initialize;

705:
706: -- initialize the message list;
707: -- won't do it again when calling private API
708: IF FND_API.to_boolean(p_init_msg_list) THEN
709: FND_MSG_PUB.initialize;
710: END IF;
711:
712: -- customer pre-processing
713: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')

Line 792: FND_MSG_PUB.count_and_get(

788: END IF;
789: END IF;
790:
791: x_return_status := FND_API.g_ret_sts_success;
792: FND_MSG_PUB.count_and_get(
793: p_encoded => FND_API.g_false,
794: p_count => x_msg_count,
795: p_data => x_msg_data
796: );

Line 803: FND_MSG_PUB.count_and_get(

799:
800: WHEN FND_API.g_exc_error THEN
801: ROLLBACK TO validate_EventOffer_pub;
802: x_return_status := FND_API.g_ret_sts_error;
803: FND_MSG_PUB.count_and_get(
804: p_encoded => FND_API.g_false,
805: p_count => x_msg_count,
806: p_data => x_msg_data
807: );

Line 812: FND_MSG_PUB.count_and_get(

808:
809: WHEN FND_API.g_exc_unexpected_error THEN
810: ROLLBACK TO validate_EventOffer_pub;
811: x_return_status := FND_API.g_ret_sts_unexp_error ;
812: FND_MSG_PUB.count_and_get(
813: p_encoded => FND_API.g_false,
814: p_count => x_msg_count,
815: p_data => x_msg_data
816: );

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

819: WHEN OTHERS THEN
820: ROLLBACK TO validate_EventOffer_pub;
821: x_return_status := FND_API.g_ret_sts_unexp_error ;
822:
823: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
824: THEN
825: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
826: END IF;
827:

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

821: x_return_status := FND_API.g_ret_sts_unexp_error ;
822:
823: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
824: THEN
825: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
826: END IF;
827:
828: FND_MSG_PUB.count_and_get(
829: p_encoded => FND_API.g_false,

Line 828: FND_MSG_PUB.count_and_get(

824: THEN
825: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
826: END IF;
827:
828: FND_MSG_PUB.count_and_get(
829: p_encoded => FND_API.g_false,
830: p_count => x_msg_count,
831: p_data => x_msg_data
832: );