DBA Data[Home] [Help]

APPS.AMS_ACT_MESSAGES_PVT dependencies on FND_MSG_PUB

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

3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'AMS_Act_Messages_PVT';
5:
6: -- forward declaration of validate messages
7: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
8: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
9: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10:
11: PROCEDURE validate_act_messages

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

4: g_pkg_name CONSTANT VARCHAR2(30) := 'AMS_Act_Messages_PVT';
5:
6: -- forward declaration of validate messages
7: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
8: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
9: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10:
11: PROCEDURE validate_act_messages
12: (

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

5:
6: -- forward declaration of validate messages
7: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
8: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
9: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10:
11: PROCEDURE validate_act_messages
12: (
13: p_act_msg_id IN NUMBER,

Line 73: FND_MSG_PUB.initialize;

69:
70: END IF;
71:
72: IF FND_API.to_boolean(p_init_msg_list) THEN
73: FND_MSG_PUB.initialize;
74: END IF;
75:
76: IF NOT FND_API.compatible_api_call(
77: l_api_version,

Line 150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

146: );
147: /*
148: else
149: -- message that cannot be associated with this type of campaign.
150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
151: FND_MESSAGE.Set_Name ('AMS', 'AMS_ACTM_INVALID_USED_BY');
152: FND_MSG_PUB.Add;
153: END IF;
154: end if; */

Line 152: FND_MSG_PUB.Add;

148: else
149: -- message that cannot be associated with this type of campaign.
150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
151: FND_MESSAGE.Set_Name ('AMS', 'AMS_ACTM_INVALID_USED_BY');
152: FND_MSG_PUB.Add;
153: END IF;
154: end if; */
155: /* --commented by musman 03/29/01
156: -- added by julou on 03/08/2000

Line 187: FND_MSG_PUB.count_and_get(

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

Line 206: FND_MSG_PUB.count_and_get(

202:
203: WHEN FND_API.g_exc_error THEN
204: ROLLBACK TO create_act_messages;
205: x_return_status := FND_API.g_ret_sts_error;
206: FND_MSG_PUB.count_and_get(
207: p_encoded => FND_API.g_false,
208: p_count => x_msg_count,
209: p_data => x_msg_data
210: );

Line 215: FND_MSG_PUB.count_and_get(

211:
212: WHEN FND_API.g_exc_unexpected_error THEN
213: ROLLBACK TO create_act_messages;
214: x_return_status := FND_API.g_ret_sts_unexp_error ;
215: FND_MSG_PUB.count_and_get(
216: p_encoded => FND_API.g_false,
217: p_count => x_msg_count,
218: p_data => x_msg_data
219: );

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

222: WHEN OTHERS THEN
223: ROLLBACK TO create_act_messages;
224: x_return_status := FND_API.g_ret_sts_unexp_error ;
225:
226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
227: THEN
228: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
229: END IF;
230:

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

224: x_return_status := FND_API.g_ret_sts_unexp_error ;
225:
226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
227: THEN
228: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
229: END IF;
230:
231: FND_MSG_PUB.count_and_get(
232: p_encoded => FND_API.g_false,

Line 231: FND_MSG_PUB.count_and_get(

227: THEN
228: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
229: END IF;
230:
231: FND_MSG_PUB.count_and_get(
232: p_encoded => FND_API.g_false,
233: p_count => x_msg_count,
234: p_data => x_msg_data
235: );

Line 286: FND_MSG_PUB.initialize;

282:
283: END IF;
284:
285: IF FND_API.to_boolean(p_init_msg_list) THEN
286: FND_MSG_PUB.initialize;
287: END IF;
288:
289: IF NOT FND_API.compatible_api_call(
290: l_api_version,

Line 339: FND_MSG_PUB.count_and_get(

335: IF FND_API.to_boolean(p_commit) THEN
336: COMMIT;
337: END IF;
338:
339: FND_MSG_PUB.count_and_get(
340: p_encoded => FND_API.g_false,
341: p_count => x_msg_count,
342: p_data => x_msg_data
343: );

Line 358: FND_MSG_PUB.count_and_get(

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

Line 367: FND_MSG_PUB.count_and_get(

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

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

374: WHEN OTHERS THEN
375: ROLLBACK TO update_act_messages;
376: x_return_status := FND_API.g_ret_sts_unexp_error ;
377:
378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
379: THEN
380: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
381: END IF;
382:

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

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

Line 383: FND_MSG_PUB.count_and_get(

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

Line 447: FND_MSG_PUB.initialize;

443:
444: END IF;
445:
446: IF FND_API.to_boolean(p_init_msg_list) THEN
447: FND_MSG_PUB.initialize;
448: END IF;
449:
450: IF NOT FND_API.compatible_api_call(
451: l_api_version,

Line 514: FND_MSG_PUB.count_and_get(

510: IF FND_API.to_boolean(p_commit) THEN
511: COMMIT;
512: END IF;
513:
514: FND_MSG_PUB.count_and_get(
515: p_encoded => FND_API.g_false,
516: p_count => x_msg_count,
517: p_data => x_msg_data
518: );

Line 533: FND_MSG_PUB.count_and_get(

529:
530: WHEN FND_API.g_exc_error THEN
531: ROLLBACK TO delete_act_messages;
532: x_return_status := FND_API.g_ret_sts_error;
533: FND_MSG_PUB.count_and_get(
534: p_encoded => FND_API.g_false,
535: p_count => x_msg_count,
536: p_data => x_msg_data
537: );

Line 542: FND_MSG_PUB.count_and_get(

538:
539: WHEN FND_API.g_exc_unexpected_error THEN
540: ROLLBACK TO delete_act_messages;
541: x_return_status := FND_API.g_ret_sts_unexp_error ;
542: FND_MSG_PUB.count_and_get(
543: p_encoded => FND_API.g_false,
544: p_count => x_msg_count,
545: p_data => x_msg_data
546: );

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

549: WHEN OTHERS THEN
550: ROLLBACK TO delete_act_messages;
551: x_return_status := FND_API.g_ret_sts_unexp_error ;
552:
553: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
554: THEN
555: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
556: END IF;
557:

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

551: x_return_status := FND_API.g_ret_sts_unexp_error ;
552:
553: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
554: THEN
555: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
556: END IF;
557:
558: FND_MSG_PUB.count_and_get(
559: p_encoded => FND_API.g_false,

Line 558: FND_MSG_PUB.count_and_get(

554: THEN
555: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
556: END IF;
557:
558: FND_MSG_PUB.count_and_get(
559: p_encoded => FND_API.g_false,
560: p_count => x_msg_count,
561: p_data => x_msg_data
562: );

Line 611: FND_MSG_PUB.initialize;

607: AMS_Utility_PVT.debug_message(l_full_name||': start');
608: END IF;
609:
610: IF FND_API.to_boolean(p_init_msg_list) THEN
611: FND_MSG_PUB.initialize;
612: END IF;
613:
614: IF NOT FND_API.compatible_api_call(
615: l_api_version,

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

631: OPEN c_actm_lck;
632: FETCH c_actm_lck INTO l_act_msg_id;
633: IF (c_actm_lck%NOTFOUND) THEN
634: CLOSE c_actm_lck;
635: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
636: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
637: FND_MSG_PUB.add;
638: END IF;
639: RAISE FND_API.g_exc_error;

Line 637: FND_MSG_PUB.add;

633: IF (c_actm_lck%NOTFOUND) THEN
634: CLOSE c_actm_lck;
635: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
636: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
637: FND_MSG_PUB.add;
638: END IF;
639: RAISE FND_API.g_exc_error;
640: END IF;
641: CLOSE c_actm_lck;

Line 644: FND_MSG_PUB.count_and_get(

640: END IF;
641: CLOSE c_actm_lck;
642:
643: -------------------- finish --------------------------
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 662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

658: EXCEPTION
659:
660: WHEN AMS_Utility_PVT.resource_locked THEN
661: x_return_status := FND_API.g_ret_sts_error;
662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
663: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
664: FND_MSG_PUB.add;
665: END IF;
666:

Line 664: FND_MSG_PUB.add;

660: WHEN AMS_Utility_PVT.resource_locked THEN
661: x_return_status := FND_API.g_ret_sts_error;
662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
663: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
664: FND_MSG_PUB.add;
665: END IF;
666:
667: FND_MSG_PUB.count_and_get(
668: p_encoded => FND_API.g_false,

Line 667: FND_MSG_PUB.count_and_get(

663: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
664: FND_MSG_PUB.add;
665: END IF;
666:
667: FND_MSG_PUB.count_and_get(
668: p_encoded => FND_API.g_false,
669: p_count => x_msg_count,
670: p_data => x_msg_data
671: );

Line 675: FND_MSG_PUB.count_and_get(

671: );
672:
673: WHEN FND_API.g_exc_error THEN
674: x_return_status := FND_API.g_ret_sts_error;
675: FND_MSG_PUB.count_and_get(
676: p_encoded => FND_API.g_false,
677: p_count => x_msg_count,
678: p_data => x_msg_data
679: );

Line 683: FND_MSG_PUB.count_and_get(

679: );
680:
681: WHEN FND_API.g_exc_unexpected_error THEN
682: x_return_status := FND_API.g_ret_sts_unexp_error ;
683: FND_MSG_PUB.count_and_get(
684: p_encoded => FND_API.g_false,
685: p_count => x_msg_count,
686: p_data => x_msg_data
687: );

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

687: );
688:
689: WHEN OTHERS THEN
690: x_return_status := FND_API.g_ret_sts_unexp_error ;
691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
692: THEN
693: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
694: END IF;
695:

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

689: WHEN OTHERS THEN
690: x_return_status := FND_API.g_ret_sts_unexp_error ;
691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
692: THEN
693: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
694: END IF;
695:
696: FND_MSG_PUB.count_and_get(
697: p_encoded => FND_API.g_false,

Line 696: FND_MSG_PUB.count_and_get(

692: THEN
693: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
694: END IF;
695:
696: FND_MSG_PUB.count_and_get(
697: p_encoded => FND_API.g_false,
698: p_count => x_msg_count,
699: p_data => x_msg_data
700: );

Line 766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

762: fetch c_chk_message into l_dummy_char;
763: if c_chk_message%notfound
764: then
765: close c_chk_message;
766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
767: FND_MESSAGE.Set_Name ('AMS', 'AMS_MESSAGE_NOT_FOUND');
768: FND_MSG_PUB.Add;
769: END IF;
770: x_return_status := FND_API.G_RET_STS_ERROR;

Line 768: FND_MSG_PUB.Add;

764: then
765: close c_chk_message;
766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
767: FND_MESSAGE.Set_Name ('AMS', 'AMS_MESSAGE_NOT_FOUND');
768: FND_MSG_PUB.Add;
769: END IF;
770: x_return_status := FND_API.G_RET_STS_ERROR;
771: return;
772: end if;

Line 804: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

800: ,p_pk_data_type => l_pk_data_type
801: ,p_additional_where_clause => l_additional_where_clause
802: ) = FND_API.G_FALSE
803: THEN
804: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
805: FND_MESSAGE.Set_Name ('AMS', 'AMS_ACTM_INVALID_USED_BY');
806: FND_MESSAGE.Set_token('OBJTYPE', l_obj_type, FALSE);
807: FND_MSG_PUB.Add;
808: END IF;

Line 807: FND_MSG_PUB.Add;

803: THEN
804: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
805: FND_MESSAGE.Set_Name ('AMS', 'AMS_ACTM_INVALID_USED_BY');
806: FND_MESSAGE.Set_token('OBJTYPE', l_obj_type, FALSE);
807: FND_MSG_PUB.Add;
808: END IF;
809: x_return_status := FND_API.G_RET_STS_ERROR;
810: return;
811: END IF;

Line 824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

820: then
821: if ams_campaignrules_pvt.check_camp_attribute(
822: p_msg_used_by_id, 'MESG' ) = FND_API.G_FALSE
823: then
824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
825: FND_MESSAGE.Set_Name ('AMS', 'AMS_MESSAGE_NOT_AVAILABLE');
826: FND_MSG_PUB.Add;
827: END IF;
828: x_return_status := FND_API.G_RET_STS_ERROR;

Line 826: FND_MSG_PUB.Add;

822: p_msg_used_by_id, 'MESG' ) = FND_API.G_FALSE
823: then
824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
825: FND_MESSAGE.Set_Name ('AMS', 'AMS_MESSAGE_NOT_AVAILABLE');
826: FND_MSG_PUB.Add;
827: END IF;
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: return;
830: end if;

Line 847: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

843: fetch c_chk_actmsg into l_dummy_char;
844: if c_chk_actmsg%found
845: then
846: close c_chk_actmsg;
847: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
848: FND_MESSAGE.Set_Name ('AMS', 'AMS_MESSAGE_NOT_UNIQUE');
849: FND_MSG_PUB.Add;
850: END IF;
851: x_return_status := FND_API.G_RET_STS_ERROR;

Line 849: FND_MSG_PUB.Add;

845: then
846: close c_chk_actmsg;
847: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
848: FND_MESSAGE.Set_Name ('AMS', 'AMS_MESSAGE_NOT_UNIQUE');
849: FND_MSG_PUB.Add;
850: END IF;
851: x_return_status := FND_API.G_RET_STS_ERROR;
852: return;
853: end if;