DBA Data[Home] [Help]

APPS.OZF_ACCTNG_EVENTS_PVT dependencies on FND_MSG_PUB

Line 20: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Acctng_Events_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvaceb.pls';
19:
20: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
21:
22: -- Hint: Primary key needs to be returned.
23: PROCEDURE Create_Acctng_Events(
24: p_api_version_number IN NUMBER,

Line 70: FND_MSG_PUB.initialize;

66:
67: -- Initialize message list if p_init_msg_list is set to TRUE.
68: IF FND_API.to_Boolean( p_init_msg_list )
69: THEN
70: FND_MSG_PUB.initialize;
71: END IF;
72:
73: -- Debug Message
74: IF g_debug THEN

Line 194: FND_MSG_PUB.Count_And_Get

190: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
191: END IF;
192:
193: -- Standard call to get message count and if count is 1, get message info.
194: FND_MSG_PUB.Count_And_Get
195: (p_count => x_msg_count,
196: p_data => x_msg_data
197: );
198: EXCEPTION

Line 206: FND_MSG_PUB.Count_And_Get (

202: WHEN FND_API.G_EXC_ERROR THEN
203: ROLLBACK TO CREATE_Acctng_Events_PVT;
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: -- Standard call to get message count and if count=1, get the message
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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: ROLLBACK TO CREATE_Acctng_Events_PVT;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214: -- Standard call to get message count and if count=1, get the message
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 223: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

219: );
220: WHEN OTHERS THEN
221: ROLLBACK TO CREATE_Acctng_Events_PVT;
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
224: THEN
225: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
226: END IF;
227: -- Standard call to get message count and if count=1, get the message

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

221: ROLLBACK TO CREATE_Acctng_Events_PVT;
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
224: THEN
225: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
226: END IF;
227: -- Standard call to get message count and if count=1, get the message
228: FND_MSG_PUB.Count_And_Get (
229: p_encoded => FND_API.G_FALSE,

Line 228: FND_MSG_PUB.Count_And_Get (

224: THEN
225: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
226: END IF;
227: -- Standard call to get message count and if count=1, get the message
228: FND_MSG_PUB.Count_And_Get (
229: p_encoded => FND_API.G_FALSE,
230: p_count => x_msg_count,
231: p_data => x_msg_data
232: );

Line 281: FND_MSG_PUB.initialize;

277:
278: -- Initialize message list if p_init_msg_list is set to TRUE.
279: IF FND_API.to_Boolean( p_init_msg_list )
280: THEN
281: FND_MSG_PUB.initialize;
282: END IF;
283:
284: -- Debug Message
285: IF g_debug THEN

Line 350: OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

346:
347:
348: -- Debug Message
349: IF g_debug THEN
350: OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
351: END IF;
352:
353: -- Invoke table handler(OZF_ACCTNG_EVENTS_PKG.Update_Row)
354: OZF_ACCTNG_EVENTS_PKG.Update_Row(

Line 404: FND_MSG_PUB.Count_And_Get

400: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
401: END IF;
402:
403: -- Standard call to get message count and if count is 1, get message info.
404: FND_MSG_PUB.Count_And_Get
405: (p_count => x_msg_count,
406: p_data => x_msg_data
407: );
408: EXCEPTION

Line 418: FND_MSG_PUB.Count_And_Get (

414: WHEN FND_API.G_EXC_ERROR THEN
415: ROLLBACK TO UPDATE_Acctng_Events_PVT;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: -- Standard call to get message count and if count=1, get the message
418: FND_MSG_PUB.Count_And_Get (
419: p_encoded => FND_API.G_FALSE,
420: p_count => x_msg_count,
421: p_data => x_msg_data
422: );

Line 428: FND_MSG_PUB.Count_And_Get (

424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425: ROLLBACK TO UPDATE_Acctng_Events_PVT;
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: -- Standard call to get message count and if count=1, get the message
428: FND_MSG_PUB.Count_And_Get (
429: p_encoded => FND_API.G_FALSE,
430: p_count => x_msg_count,
431: p_data => x_msg_data
432: );

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

433:
434: WHEN OTHERS THEN
435: ROLLBACK TO UPDATE_Acctng_Events_PVT;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
438: THEN
439: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
440: END IF;
441: -- Standard call to get message count and if count=1, get the message

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

435: ROLLBACK TO UPDATE_Acctng_Events_PVT;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
438: THEN
439: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
440: END IF;
441: -- Standard call to get message count and if count=1, get the message
442: FND_MSG_PUB.Count_And_Get (
443: p_encoded => FND_API.G_FALSE,

Line 442: FND_MSG_PUB.Count_And_Get (

438: THEN
439: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
440: END IF;
441: -- Standard call to get message count and if count=1, get the message
442: FND_MSG_PUB.Count_And_Get (
443: p_encoded => FND_API.G_FALSE,
444: p_count => x_msg_count,
445: p_data => x_msg_data
446: );

Line 483: FND_MSG_PUB.initialize;

479:
480: -- Initialize message list if p_init_msg_list is set to TRUE.
481: IF FND_API.to_Boolean( p_init_msg_list )
482: THEN
483: FND_MSG_PUB.initialize;
484: END IF;
485:
486: -- Debug Message
487: IF g_debug THEN

Line 523: FND_MSG_PUB.Count_And_Get

519: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
520: END IF;
521:
522: -- Standard call to get message count and if count is 1, get message info.
523: FND_MSG_PUB.Count_And_Get
524: (p_count => x_msg_count,
525: p_data => x_msg_data
526: );
527: EXCEPTION

Line 537: FND_MSG_PUB.Count_And_Get (

533: WHEN FND_API.G_EXC_ERROR THEN
534: ROLLBACK TO DELETE_Acctng_Events_PVT;
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: -- Standard call to get message count and if count=1, get the message
537: FND_MSG_PUB.Count_And_Get (
538: p_encoded => FND_API.G_FALSE,
539: p_count => x_msg_count,
540: p_data => x_msg_data
541: );

Line 547: FND_MSG_PUB.Count_And_Get (

543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544: ROLLBACK TO DELETE_Acctng_Events_PVT;
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: -- Standard call to get message count and if count=1, get the message
547: FND_MSG_PUB.Count_And_Get (
548: p_encoded => FND_API.G_FALSE,
549: p_count => x_msg_count,
550: p_data => x_msg_data
551: );

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

552:
553: WHEN OTHERS THEN
554: ROLLBACK TO DELETE_Acctng_Events_PVT;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
557: THEN
558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
559: END IF;
560: -- Standard call to get message count and if count=1, get the message

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

554: ROLLBACK TO DELETE_Acctng_Events_PVT;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
557: THEN
558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
559: END IF;
560: -- Standard call to get message count and if count=1, get the message
561: FND_MSG_PUB.Count_And_Get (
562: p_encoded => FND_API.G_FALSE,

Line 561: FND_MSG_PUB.Count_And_Get (

557: THEN
558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
559: END IF;
560: -- Standard call to get message count and if count=1, get the message
561: FND_MSG_PUB.Count_And_Get (
562: p_encoded => FND_API.G_FALSE,
563: p_count => x_msg_count,
564: p_data => x_msg_data
565: );

Line 606: FND_MSG_PUB.initialize;

602:
603: -- Initialize message list if p_init_msg_list is set to TRUE.
604: IF FND_API.to_Boolean( p_init_msg_list )
605: THEN
606: FND_MSG_PUB.initialize;
607: END IF;
608:
609: -- Standard call to check for call compatibility.
610: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

630: FETCH c_Acctng_Events INTO l_ACCOUNTING_EVENT_ID;
631:
632: IF (c_Acctng_Events%NOTFOUND) THEN
633: CLOSE c_Acctng_Events;
634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
635: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
636: FND_MSG_PUB.add;
637: END IF;
638: RAISE FND_API.g_exc_error;

Line 636: FND_MSG_PUB.add;

632: IF (c_Acctng_Events%NOTFOUND) THEN
633: CLOSE c_Acctng_Events;
634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
635: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
636: FND_MSG_PUB.add;
637: END IF;
638: RAISE FND_API.g_exc_error;
639: END IF;
640:

Line 644: FND_MSG_PUB.count_and_get(

640:
641: CLOSE c_Acctng_Events;
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: IF g_debug THEN

Line 661: FND_MSG_PUB.Count_And_Get (

657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO LOCK_Acctng_Events_PVT;
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: -- Standard call to get message count and if count=1, get the message
661: FND_MSG_PUB.Count_And_Get (
662: p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data
665: );

Line 671: FND_MSG_PUB.Count_And_Get (

667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO LOCK_Acctng_Events_PVT;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: -- Standard call to get message count and if count=1, get the message
671: FND_MSG_PUB.Count_And_Get (
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count,
674: p_data => x_msg_data
675: );

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

676:
677: WHEN OTHERS THEN
678: ROLLBACK TO LOCK_Acctng_Events_PVT;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
683: END IF;
684: -- Standard call to get message count and if count=1, get the message

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

678: ROLLBACK TO LOCK_Acctng_Events_PVT;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
683: END IF;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,

Line 685: FND_MSG_PUB.Count_And_Get (

681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
683: END IF;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data
689: );

Line 1287: FND_MSG_PUB.initialize;

1283:
1284: -- Initialize message list if p_init_msg_list is set to TRUE.
1285: IF FND_API.to_Boolean( p_init_msg_list )
1286: THEN
1287: FND_MSG_PUB.initialize;
1288: END IF;
1289: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1290: Check_acctng_event_Items(
1291: p_acctng_event_rec => p_acctng_event_rec,

Line 1341: FND_MSG_PUB.Count_And_Get

1337: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1338: END IF;
1339:
1340: -- Standard call to get message count and if count is 1, get message info.
1341: FND_MSG_PUB.Count_And_Get
1342: (p_count => x_msg_count,
1343: p_data => x_msg_data
1344: );
1345: EXCEPTION

Line 1355: FND_MSG_PUB.Count_And_Get (

1351: WHEN FND_API.G_EXC_ERROR THEN
1352: ROLLBACK TO VALIDATE_Acctng_Events_;
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: -- Standard call to get message count and if count=1, get the message
1355: FND_MSG_PUB.Count_And_Get (
1356: p_encoded => FND_API.G_FALSE,
1357: p_count => x_msg_count,
1358: p_data => x_msg_data
1359: );

Line 1365: FND_MSG_PUB.Count_And_Get (

1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: ROLLBACK TO VALIDATE_Acctng_Events_;
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: -- Standard call to get message count and if count=1, get the message
1365: FND_MSG_PUB.Count_And_Get (
1366: p_encoded => FND_API.G_FALSE,
1367: p_count => x_msg_count,
1368: p_data => x_msg_data
1369: );

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

1370:
1371: WHEN OTHERS THEN
1372: ROLLBACK TO VALIDATE_Acctng_Events_;
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1374: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1375: THEN
1376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1377: END IF;
1378: -- Standard call to get message count and if count=1, get the message

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

1372: ROLLBACK TO VALIDATE_Acctng_Events_;
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1374: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1375: THEN
1376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1377: END IF;
1378: -- Standard call to get message count and if count=1, get the message
1379: FND_MSG_PUB.Count_And_Get (
1380: p_encoded => FND_API.G_FALSE,

Line 1379: FND_MSG_PUB.Count_And_Get (

1375: THEN
1376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1377: END IF;
1378: -- Standard call to get message count and if count=1, get the message
1379: FND_MSG_PUB.Count_And_Get (
1380: p_encoded => FND_API.G_FALSE,
1381: p_count => x_msg_count,
1382: p_data => x_msg_data
1383: );

Line 1400: FND_MSG_PUB.initialize;

1396: BEGIN
1397: -- Initialize message list if p_init_msg_list is set to TRUE.
1398: IF FND_API.to_Boolean( p_init_msg_list )
1399: THEN
1400: FND_MSG_PUB.initialize;
1401: END IF;
1402:
1403: -- Initialize API return status to SUCCESS
1404: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1416: FND_MSG_PUB.Count_And_Get

1412: IF g_debug THEN
1413: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1414: END IF;
1415: -- Standard call to get message count and if count is 1, get message info.
1416: FND_MSG_PUB.Count_And_Get
1417: (p_count => x_msg_count,
1418: p_data => x_msg_data
1419: );
1420: END Validate_acctng_event_Rec;