DBA Data[Home] [Help]

APPS.AMS_DMMODEL_PUB dependencies on FND_MSG_PUB

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

24:
25: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_DMModel_PUB';
26: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amspdmmb.pls';
27:
28: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
29: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
30: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
31:
32: PROCEDURE Create_Model(

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

25: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_DMModel_PUB';
26: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amspdmmb.pls';
27:
28: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
29: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
30: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
31:
32: PROCEDURE Create_Model(
33: p_api_version_number IN NUMBER,

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

26: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amspdmmb.pls';
27:
28: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
29: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
30: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
31:
32: PROCEDURE Create_Model(
33: p_api_version_number IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 64: FND_MSG_PUB.initialize;

60:
61: -- Initialize message list if p_init_msg_list is set to TRUE.
62: IF FND_API.to_Boolean( p_init_msg_list )
63: THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66:
67: -- Debug Message
68: IF (AMS_DEBUG_HIGH_ON) THEN

Line 164: FND_MSG_PUB.Count_And_Get

160: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
161: END IF;
162:
163: -- Standard call to get message count and if count is 1, get message info.
164: FND_MSG_PUB.Count_And_Get
165: (p_count => x_msg_count,
166: p_data => x_msg_data
167: );
168: EXCEPTION

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

168: EXCEPTION
169:
170: WHEN AMS_Utility_PVT.resource_locked THEN
171: x_return_status := FND_API.g_ret_sts_error;
172: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
173: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
174: FND_MSG_PUB.add;
175: END IF;
176:

Line 174: FND_MSG_PUB.add;

170: WHEN AMS_Utility_PVT.resource_locked THEN
171: x_return_status := FND_API.g_ret_sts_error;
172: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
173: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
174: FND_MSG_PUB.add;
175: END IF;
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO Create_Model_PUB;

Line 181: FND_MSG_PUB.Count_And_Get (

177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO Create_Model_PUB;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: -- Standard call to get message count and if count=1, get the message
181: FND_MSG_PUB.Count_And_Get (
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data
185: );

Line 191: FND_MSG_PUB.Count_And_Get (

187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO Create_Model_PUB;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: -- Standard call to get message count and if count=1, get the message
191: FND_MSG_PUB.Count_And_Get (
192: p_encoded => FND_API.G_FALSE,
193: p_count => x_msg_count,
194: p_data => x_msg_data
195: );

Line 200: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

196:
197: WHEN OTHERS THEN
198: ROLLBACK TO Create_Model_PUB;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
201: THEN
202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
203: END IF;
204: -- Standard call to get message count and if count=1, get the message

Line 202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

198: ROLLBACK TO Create_Model_PUB;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
201: THEN
202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
203: END IF;
204: -- Standard call to get message count and if count=1, get the message
205: FND_MSG_PUB.Count_And_Get (
206: p_encoded => FND_API.G_FALSE,

Line 205: FND_MSG_PUB.Count_And_Get (

201: THEN
202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
203: END IF;
204: -- Standard call to get message count and if count=1, get the message
205: FND_MSG_PUB.Count_And_Get (
206: p_encoded => FND_API.G_FALSE,
207: p_count => x_msg_count,
208: p_data => x_msg_data
209: );

Line 247: FND_MSG_PUB.initialize;

243:
244: -- Initialize message list if p_init_msg_list is set to TRUE.
245: IF FND_API.to_Boolean( p_init_msg_list )
246: THEN
247: FND_MSG_PUB.initialize;
248: END IF;
249:
250: -- Debug Message
251: IF (AMS_DEBUG_HIGH_ON) THEN

Line 346: FND_MSG_PUB.Count_And_Get

342: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
343: END IF;
344:
345: -- Standard call to get message count and if count is 1, get message info.
346: FND_MSG_PUB.Count_And_Get
347: (p_count => x_msg_count,
348: p_data => x_msg_data
349: );
350: EXCEPTION

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

350: EXCEPTION
351:
352: WHEN AMS_Utility_PVT.resource_locked THEN
353: x_return_status := FND_API.g_ret_sts_error;
354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
355: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
356: FND_MSG_PUB.add;
357: END IF;
358:

Line 356: FND_MSG_PUB.add;

352: WHEN AMS_Utility_PVT.resource_locked THEN
353: x_return_status := FND_API.g_ret_sts_error;
354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
355: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
356: FND_MSG_PUB.add;
357: END IF;
358:
359: WHEN FND_API.G_EXC_ERROR THEN
360: ROLLBACK TO Update_Model_PUB;

Line 363: FND_MSG_PUB.Count_And_Get (

359: WHEN FND_API.G_EXC_ERROR THEN
360: ROLLBACK TO Update_Model_PUB;
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: -- Standard call to get message count and if count=1, get the message
363: FND_MSG_PUB.Count_And_Get (
364: p_encoded => FND_API.G_FALSE,
365: p_count => x_msg_count,
366: p_data => x_msg_data
367: );

Line 373: FND_MSG_PUB.Count_And_Get (

369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: ROLLBACK TO Update_Model_PUB;
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
372: -- Standard call to get message count and if count=1, get the message
373: FND_MSG_PUB.Count_And_Get (
374: p_encoded => FND_API.G_FALSE,
375: p_count => x_msg_count,
376: p_data => x_msg_data
377: );

Line 382: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

378:
379: WHEN OTHERS THEN
380: ROLLBACK TO Update_Model_PUB;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
383: THEN
384: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
385: END IF;
386: -- Standard call to get message count and if count=1, get the message

Line 384: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

380: ROLLBACK TO Update_Model_PUB;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
383: THEN
384: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
385: END IF;
386: -- Standard call to get message count and if count=1, get the message
387: FND_MSG_PUB.Count_And_Get (
388: p_encoded => FND_API.G_FALSE,

Line 387: FND_MSG_PUB.Count_And_Get (

383: THEN
384: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
385: END IF;
386: -- Standard call to get message count and if count=1, get the message
387: FND_MSG_PUB.Count_And_Get (
388: p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,
390: p_data => x_msg_data
391: );

Line 428: FND_MSG_PUB.initialize;

424:
425: -- Initialize message list if p_init_msg_list is set to TRUE.
426: IF FND_API.to_Boolean( p_init_msg_list )
427: THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430:
431: -- Debug Message
432: IF (AMS_DEBUG_HIGH_ON) THEN

Line 480: FND_MSG_PUB.Count_And_Get

476: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
477: END IF;
478:
479: -- Standard call to get message count and if count is 1, get message info.
480: FND_MSG_PUB.Count_And_Get
481: (p_count => x_msg_count,
482: p_data => x_msg_data
483: );
484: EXCEPTION

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

484: EXCEPTION
485:
486: WHEN AMS_Utility_PVT.resource_locked THEN
487: x_return_status := FND_API.g_ret_sts_error;
488: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
489: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
490: FND_MSG_PUB.add;
491: END IF;
492:

Line 490: FND_MSG_PUB.add;

486: WHEN AMS_Utility_PVT.resource_locked THEN
487: x_return_status := FND_API.g_ret_sts_error;
488: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
489: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
490: FND_MSG_PUB.add;
491: END IF;
492:
493: WHEN FND_API.G_EXC_ERROR THEN
494: ROLLBACK TO Delete_Model_PUB;

Line 497: FND_MSG_PUB.Count_And_Get (

493: WHEN FND_API.G_EXC_ERROR THEN
494: ROLLBACK TO Delete_Model_PUB;
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: -- Standard call to get message count and if count=1, get the message
497: FND_MSG_PUB.Count_And_Get (
498: p_encoded => FND_API.G_FALSE,
499: p_count => x_msg_count,
500: p_data => x_msg_data
501: );

Line 507: FND_MSG_PUB.Count_And_Get (

503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: ROLLBACK TO Delete_Model_PUB;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: -- Standard call to get message count and if count=1, get the message
507: FND_MSG_PUB.Count_And_Get (
508: p_encoded => FND_API.G_FALSE,
509: p_count => x_msg_count,
510: p_data => x_msg_data
511: );

Line 516: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

512:
513: WHEN OTHERS THEN
514: ROLLBACK TO Delete_Model_PUB;
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
519: END IF;
520: -- Standard call to get message count and if count=1, get the message

Line 518: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

514: ROLLBACK TO Delete_Model_PUB;
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
519: END IF;
520: -- Standard call to get message count and if count=1, get the message
521: FND_MSG_PUB.Count_And_Get (
522: p_encoded => FND_API.G_FALSE,

Line 521: FND_MSG_PUB.Count_And_Get (

517: THEN
518: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
519: END IF;
520: -- Standard call to get message count and if count=1, get the message
521: FND_MSG_PUB.Count_And_Get (
522: p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data
525: );

Line 558: FND_MSG_PUB.initialize;

554:
555: -- Initialize message list if p_init_msg_list is set to TRUE.
556: IF FND_API.to_Boolean( p_init_msg_list )
557: THEN
558: FND_MSG_PUB.initialize;
559: END IF;
560:
561: -- Debug Message
562: IF (AMS_DEBUG_HIGH_ON) THEN

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

602: EXCEPTION
603:
604: WHEN AMS_Utility_PVT.resource_locked THEN
605: x_return_status := FND_API.g_ret_sts_error;
606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
607: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
608: FND_MSG_PUB.add;
609: END IF;
610:

Line 608: FND_MSG_PUB.add;

604: WHEN AMS_Utility_PVT.resource_locked THEN
605: x_return_status := FND_API.g_ret_sts_error;
606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
607: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
608: FND_MSG_PUB.add;
609: END IF;
610:
611: WHEN FND_API.G_EXC_ERROR THEN
612: ROLLBACK TO Lock_Model_PUB;

Line 615: FND_MSG_PUB.Count_And_Get (

611: WHEN FND_API.G_EXC_ERROR THEN
612: ROLLBACK TO Lock_Model_PUB;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: -- Standard call to get message count and if count=1, get the message
615: FND_MSG_PUB.Count_And_Get (
616: p_encoded => FND_API.G_FALSE,
617: p_count => x_msg_count,
618: p_data => x_msg_data
619: );

Line 625: FND_MSG_PUB.Count_And_Get (

621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
622: ROLLBACK TO Lock_Model_PUB;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: -- Standard call to get message count and if count=1, get the message
625: FND_MSG_PUB.Count_And_Get (
626: p_encoded => FND_API.G_FALSE,
627: p_count => x_msg_count,
628: p_data => x_msg_data
629: );

Line 634: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

630:
631: WHEN OTHERS THEN
632: ROLLBACK TO Lock_Model_PUB;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
635: THEN
636: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
637: END IF;
638: -- Standard call to get message count and if count=1, get the message

Line 636: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

632: ROLLBACK TO Lock_Model_PUB;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
635: THEN
636: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
637: END IF;
638: -- Standard call to get message count and if count=1, get the message
639: FND_MSG_PUB.Count_And_Get (
640: p_encoded => FND_API.G_FALSE,

Line 639: FND_MSG_PUB.Count_And_Get (

635: THEN
636: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
637: END IF;
638: -- Standard call to get message count and if count=1, get the message
639: FND_MSG_PUB.Count_And_Get (
640: p_encoded => FND_API.G_FALSE,
641: p_count => x_msg_count,
642: p_data => x_msg_data
643: );

Line 703: FND_MSG_PUB.initialize;

699: -- Initialize return status
700: x_return_status := FND_API.g_ret_sts_success;
701:
702: -- Initialize message buffer
703: FND_MSG_PUB.initialize;
704:
705:
706: -- construct record for validation
707: -- get a unique model id

Line 826: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: WHEN OTHERS THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
827: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
828: END IF;
829: END Create_Model;
830:

Line 827: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: WHEN OTHERS THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
827: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
828: END IF;
829: END Create_Model;
830:
831: