DBA Data[Home] [Help]

APPS.AMS_RULE_GROUP_PUB dependencies on FND_MSG_PUB

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

16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Rule_Group_PUB';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsprgpb.pls';
19:
20: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: PROCEDURE Create_Rule_Group(

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

17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Rule_Group_PUB';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsprgpb.pls';
19:
20: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: PROCEDURE Create_Rule_Group(
25: p_api_version_number IN NUMBER,

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

18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsprgpb.pls';
19:
20: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: PROCEDURE Create_Rule_Group(
25: p_api_version_number IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 57: FND_MSG_PUB.initialize;

53:
54: -- Initialize message list if p_init_msg_list is set to TRUE.
55: IF FND_API.to_Boolean( p_init_msg_list )
56: THEN
57: FND_MSG_PUB.initialize;
58: END IF;
59:
60: -- Debug Message
61: IF (AMS_DEBUG_HIGH_ON) THEN

Line 111: FND_MSG_PUB.Count_And_Get

107: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
108: END IF;
109:
110: -- Standard call to get message count and if count is 1, get message info.
111: FND_MSG_PUB.Count_And_Get
112: (p_count => x_msg_count,
113: p_data => x_msg_data
114: );
115: EXCEPTION

Line 125: FND_MSG_PUB.Count_And_Get (

121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO CREATE_Rule_Group_PUB;
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: -- Standard call to get message count and if count=1, get the message
125: FND_MSG_PUB.Count_And_Get (
126: p_encoded => FND_API.G_FALSE,
127: p_count => x_msg_count,
128: p_data => x_msg_data
129: );

Line 135: FND_MSG_PUB.Count_And_Get (

131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO CREATE_Rule_Group_PUB;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: -- Standard call to get message count and if count=1, get the message
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 144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

140:
141: WHEN OTHERS THEN
142: ROLLBACK TO CREATE_Rule_Group_PUB;
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148: -- Standard call to get message count and if count=1, get the message

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

142: ROLLBACK TO CREATE_Rule_Group_PUB;
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148: -- Standard call to get message count and if count=1, get the message
149: FND_MSG_PUB.Count_And_Get (
150: p_encoded => FND_API.G_FALSE,

Line 149: FND_MSG_PUB.Count_And_Get (

145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148: -- Standard call to get message count and if count=1, get the message
149: FND_MSG_PUB.Count_And_Get (
150: p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count,
152: p_data => x_msg_data
153: );

Line 191: FND_MSG_PUB.initialize;

187:
188: -- Initialize message list if p_init_msg_list is set to TRUE.
189: IF FND_API.to_Boolean( p_init_msg_list )
190: THEN
191: FND_MSG_PUB.initialize;
192: END IF;
193:
194: -- Debug Message
195: IF (AMS_DEBUG_HIGH_ON) THEN

Line 243: FND_MSG_PUB.Count_And_Get

239: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
240: END IF;
241:
242: -- Standard call to get message count and if count is 1, get message info.
243: FND_MSG_PUB.Count_And_Get
244: (p_count => x_msg_count,
245: p_data => x_msg_data
246: );
247: EXCEPTION

Line 257: FND_MSG_PUB.Count_And_Get (

253: WHEN FND_API.G_EXC_ERROR THEN
254: ROLLBACK TO UPDATE_Rule_Group_PUB;
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: -- Standard call to get message count and if count=1, get the message
257: FND_MSG_PUB.Count_And_Get (
258: p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => x_msg_data
261: );

Line 267: FND_MSG_PUB.Count_And_Get (

263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264: ROLLBACK TO UPDATE_Rule_Group_PUB;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: -- Standard call to get message count and if count=1, get the message
267: FND_MSG_PUB.Count_And_Get (
268: p_encoded => FND_API.G_FALSE,
269: p_count => x_msg_count,
270: p_data => x_msg_data
271: );

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

272:
273: WHEN OTHERS THEN
274: ROLLBACK TO UPDATE_Rule_Group_PUB;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
277: THEN
278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
279: END IF;
280: -- Standard call to get message count and if count=1, get the message

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

274: ROLLBACK TO UPDATE_Rule_Group_PUB;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
277: THEN
278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
279: END IF;
280: -- Standard call to get message count and if count=1, get the message
281: FND_MSG_PUB.Count_And_Get (
282: p_encoded => FND_API.G_FALSE,

Line 281: FND_MSG_PUB.Count_And_Get (

277: THEN
278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
279: END IF;
280: -- Standard call to get message count and if count=1, get the message
281: FND_MSG_PUB.Count_And_Get (
282: p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,
284: p_data => x_msg_data
285: );

Line 322: FND_MSG_PUB.initialize;

318:
319: -- Initialize message list if p_init_msg_list is set to TRUE.
320: IF FND_API.to_Boolean( p_init_msg_list )
321: THEN
322: FND_MSG_PUB.initialize;
323: END IF;
324:
325: -- Debug Message
326: IF (AMS_DEBUG_HIGH_ON) THEN

Line 374: FND_MSG_PUB.Count_And_Get

370: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
371: END IF;
372:
373: -- Standard call to get message count and if count is 1, get message info.
374: FND_MSG_PUB.Count_And_Get
375: (p_count => x_msg_count,
376: p_data => x_msg_data
377: );
378: EXCEPTION

Line 388: FND_MSG_PUB.Count_And_Get (

384: WHEN FND_API.G_EXC_ERROR THEN
385: ROLLBACK TO DELETE_Rule_Group_PUB;
386: x_return_status := FND_API.G_RET_STS_ERROR;
387: -- Standard call to get message count and if count=1, get the message
388: FND_MSG_PUB.Count_And_Get (
389: p_encoded => FND_API.G_FALSE,
390: p_count => x_msg_count,
391: p_data => x_msg_data
392: );

Line 398: FND_MSG_PUB.Count_And_Get (

394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: ROLLBACK TO DELETE_Rule_Group_PUB;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: -- Standard call to get message count and if count=1, get the message
398: FND_MSG_PUB.Count_And_Get (
399: p_encoded => FND_API.G_FALSE,
400: p_count => x_msg_count,
401: p_data => x_msg_data
402: );

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

403:
404: WHEN OTHERS THEN
405: ROLLBACK TO DELETE_Rule_Group_PUB;
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
408: THEN
409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
410: END IF;
411: -- Standard call to get message count and if count=1, get the message

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

405: ROLLBACK TO DELETE_Rule_Group_PUB;
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
408: THEN
409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
410: END IF;
411: -- Standard call to get message count and if count=1, get the message
412: FND_MSG_PUB.Count_And_Get (
413: p_encoded => FND_API.G_FALSE,

Line 412: FND_MSG_PUB.Count_And_Get (

408: THEN
409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
410: END IF;
411: -- Standard call to get message count and if count=1, get the message
412: FND_MSG_PUB.Count_And_Get (
413: p_encoded => FND_API.G_FALSE,
414: p_count => x_msg_count,
415: p_data => x_msg_data
416: );

Line 449: FND_MSG_PUB.initialize;

445:
446: -- Initialize message list if p_init_msg_list is set to TRUE.
447: IF FND_API.to_Boolean( p_init_msg_list )
448: THEN
449: FND_MSG_PUB.initialize;
450: END IF;
451:
452: -- Debug Message
453: IF (AMS_DEBUG_HIGH_ON) THEN

Line 503: FND_MSG_PUB.Count_And_Get (

499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO LOCK_Rule_Group_PUB;
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get (
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data
507: );

Line 513: FND_MSG_PUB.Count_And_Get (

509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO LOCK_Rule_Group_PUB;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: -- Standard call to get message count and if count=1, get the message
513: FND_MSG_PUB.Count_And_Get (
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data
517: );

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

518:
519: WHEN OTHERS THEN
520: ROLLBACK TO LOCK_Rule_Group_PUB;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
523: THEN
524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
525: END IF;
526: -- Standard call to get message count and if count=1, get the message

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

520: ROLLBACK TO LOCK_Rule_Group_PUB;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
523: THEN
524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
525: END IF;
526: -- Standard call to get message count and if count=1, get the message
527: FND_MSG_PUB.Count_And_Get (
528: p_encoded => FND_API.G_FALSE,

Line 527: FND_MSG_PUB.Count_And_Get (

523: THEN
524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
525: END IF;
526: -- Standard call to get message count and if count=1, get the message
527: FND_MSG_PUB.Count_And_Get (
528: p_encoded => FND_API.G_FALSE,
529: p_count => x_msg_count,
530: p_data => x_msg_data
531: );