DBA Data[Home] [Help]

APPS.PV_GE_HIST_LOG_PVT dependencies on FND_MSG_PUB

Line 70: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

66: --
67: -- End of Comments
68: -- ==============================================================================
69:
70: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
71: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
72: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
73:
74: PROCEDURE Create_Ge_Hist_Log(

Line 71: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

67: -- End of Comments
68: -- ==============================================================================
69:
70: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
71: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
72: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
73:
74: PROCEDURE Create_Ge_Hist_Log(
75: p_api_version_number IN NUMBER,

Line 72: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

68: -- ==============================================================================
69:
70: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
71: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
72: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
73:
74: PROCEDURE Create_Ge_Hist_Log(
75: p_api_version_number IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 121: FND_MSG_PUB.initialize;

117:
118: -- Initialize message list if p_init_msg_list is set to TRUE.
119: IF FND_API.to_Boolean( p_init_msg_list )
120: THEN
121: FND_MSG_PUB.initialize;
122: END IF;
123:
124:
125:

Line 239: FND_MSG_PUB.Count_And_Get

235: END IF;
236:
237:
238: -- Standard call to get message count and if count is 1, get message info.
239: FND_MSG_PUB.Count_And_Get
240: (p_count => x_msg_count,
241: p_data => x_msg_data
242: );
243: EXCEPTION

Line 253: FND_MSG_PUB.Count_And_Get (

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

Line 263: FND_MSG_PUB.Count_And_Get (

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

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

268:
269: WHEN OTHERS THEN
270: ROLLBACK TO CREATE_Ge_Hist_Log_PVT;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
273: THEN
274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
275: END IF;
276: -- Standard call to get message count and if count=1, get the message

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

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

Line 277: FND_MSG_PUB.Count_And_Get (

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

Line 367: FND_MSG_PUB.initialize;

363:
364: -- Initialize message list if p_init_msg_list is set to TRUE.
365: IF FND_API.to_Boolean( p_init_msg_list )
366: THEN
367: FND_MSG_PUB.initialize;
368: END IF;
369:
370:
371:

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

447:
448: -- Debug Message
449: IF (PV_DEBUG_HIGH_ON) THEN
450:
451: PVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
452: END IF;
453:
454: -- Invoke table handler(Pv_Ge_Hist_Log_Pkg.Update_Row)
455: Pv_Ge_Hist_Log_Pkg.Update_Row(

Line 489: FND_MSG_PUB.Count_And_Get

485: END IF;
486:
487:
488: -- Standard call to get message count and if count is 1, get message info.
489: FND_MSG_PUB.Count_And_Get
490: (p_count => x_msg_count,
491: p_data => x_msg_data
492: );
493: EXCEPTION

Line 503: FND_MSG_PUB.Count_And_Get (

499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO UPDATE_Ge_Hist_Log_PVT;
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 UPDATE_Ge_Hist_Log_PVT;
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 UPDATE_Ge_Hist_Log_PVT;
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 UPDATE_Ge_Hist_Log_PVT;
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: );

Line 603: FND_MSG_PUB.initialize;

599:
600: -- Initialize message list if p_init_msg_list is set to TRUE.
601: IF FND_API.to_Boolean( p_init_msg_list )
602: THEN
603: FND_MSG_PUB.initialize;
604: END IF;
605:
606:
607:

Line 651: FND_MSG_PUB.Count_And_Get

647: END IF;
648:
649:
650: -- Standard call to get message count and if count is 1, get message info.
651: FND_MSG_PUB.Count_And_Get
652: (p_count => x_msg_count,
653: p_data => x_msg_data
654: );
655: EXCEPTION

Line 665: FND_MSG_PUB.Count_And_Get (

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

Line 675: FND_MSG_PUB.Count_And_Get (

671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
672: ROLLBACK TO DELETE_Ge_Hist_Log_PVT;
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
674: -- Standard call to get message count and if count=1, get the message
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 684: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

680:
681: WHEN OTHERS THEN
682: ROLLBACK TO DELETE_Ge_Hist_Log_PVT;
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
685: THEN
686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
687: END IF;
688: -- Standard call to get message count and if count=1, get the message

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

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

Line 689: FND_MSG_PUB.Count_And_Get (

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

Line 762: FND_MSG_PUB.initialize;

758:
759: -- Initialize message list if p_init_msg_list is set to TRUE.
760: IF FND_API.to_Boolean( p_init_msg_list )
761: THEN
762: FND_MSG_PUB.initialize;
763: END IF;
764:
765:
766:

Line 787: FND_MSG_PUB.count_and_get(

783: Pv_Ge_Hist_Log_Pkg.Lock_Row(l_entity_history_log_id,p_object_version);
784:
785:
786: -------------------- finish --------------------------
787: FND_MSG_PUB.count_and_get(
788: p_encoded => FND_API.g_false,
789: p_count => x_msg_count,
790: p_data => x_msg_data);
791: IF (PV_DEBUG_HIGH_ON) THEN

Line 805: FND_MSG_PUB.Count_And_Get (

801: WHEN FND_API.G_EXC_ERROR THEN
802: ROLLBACK TO LOCK_Ge_Hist_Log_PVT;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: -- Standard call to get message count and if count=1, get the message
805: FND_MSG_PUB.Count_And_Get (
806: p_encoded => FND_API.G_FALSE,
807: p_count => x_msg_count,
808: p_data => x_msg_data
809: );

Line 815: FND_MSG_PUB.Count_And_Get (

811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
812: ROLLBACK TO LOCK_Ge_Hist_Log_PVT;
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (
816: p_encoded => FND_API.G_FALSE,
817: p_count => x_msg_count,
818: p_data => x_msg_data
819: );

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

820:
821: WHEN OTHERS THEN
822: ROLLBACK TO LOCK_Ge_Hist_Log_PVT;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
825: THEN
826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
827: END IF;
828: -- Standard call to get message count and if count=1, get the message

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

822: ROLLBACK TO LOCK_Ge_Hist_Log_PVT;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
825: THEN
826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
827: END IF;
828: -- Standard call to get message count and if count=1, get the message
829: FND_MSG_PUB.Count_And_Get (
830: p_encoded => FND_API.G_FALSE,

Line 829: FND_MSG_PUB.Count_And_Get (

825: THEN
826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
827: END IF;
828: -- Standard call to get message count and if count=1, get the message
829: FND_MSG_PUB.Count_And_Get (
830: p_encoded => FND_API.G_FALSE,
831: p_count => x_msg_count,
832: p_data => x_msg_data
833: );

Line 1206: FND_MSG_PUB.initialize;

1202:
1203: -- Initialize message list if p_init_msg_list is set to TRUE.
1204: IF FND_API.to_Boolean( p_init_msg_list )
1205: THEN
1206: FND_MSG_PUB.initialize;
1207: END IF;
1208:
1209:
1210: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1274: FND_MSG_PUB.Count_And_Get

1270: END IF;
1271:
1272:
1273: -- Standard call to get message count and if count is 1, get message info.
1274: FND_MSG_PUB.Count_And_Get
1275: (p_count => x_msg_count,
1276: p_data => x_msg_data
1277: );
1278: EXCEPTION

Line 1288: FND_MSG_PUB.Count_And_Get (

1284: WHEN FND_API.G_EXC_ERROR THEN
1285: ROLLBACK TO VALIDATE_Ge_Hist_Log_;
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: -- Standard call to get message count and if count=1, get the message
1288: FND_MSG_PUB.Count_And_Get (
1289: p_encoded => FND_API.G_FALSE,
1290: p_count => x_msg_count,
1291: p_data => x_msg_data
1292: );

Line 1298: FND_MSG_PUB.Count_And_Get (

1294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1295: ROLLBACK TO VALIDATE_Ge_Hist_Log_;
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: -- Standard call to get message count and if count=1, get the message
1298: FND_MSG_PUB.Count_And_Get (
1299: p_encoded => FND_API.G_FALSE,
1300: p_count => x_msg_count,
1301: p_data => x_msg_data
1302: );

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

1303:
1304: WHEN OTHERS THEN
1305: ROLLBACK TO VALIDATE_Ge_Hist_Log_;
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1307: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1308: THEN
1309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1310: END IF;
1311: -- Standard call to get message count and if count=1, get the message

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

1305: ROLLBACK TO VALIDATE_Ge_Hist_Log_;
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1307: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1308: THEN
1309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1310: END IF;
1311: -- Standard call to get message count and if count=1, get the message
1312: FND_MSG_PUB.Count_And_Get (
1313: p_encoded => FND_API.G_FALSE,

Line 1312: FND_MSG_PUB.Count_And_Get (

1308: THEN
1309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1310: END IF;
1311: -- Standard call to get message count and if count=1, get the message
1312: FND_MSG_PUB.Count_And_Get (
1313: p_encoded => FND_API.G_FALSE,
1314: p_count => x_msg_count,
1315: p_data => x_msg_data
1316: );

Line 1333: FND_MSG_PUB.initialize;

1329: BEGIN
1330: -- Initialize message list if p_init_msg_list is set to TRUE.
1331: IF FND_API.to_Boolean( p_init_msg_list )
1332: THEN
1333: FND_MSG_PUB.initialize;
1334: END IF;
1335:
1336:
1337:

Line 1352: FND_MSG_PUB.Count_And_Get

1348:
1349: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1350: END IF;
1351: -- Standard call to get message count and if count is 1, get message info.
1352: FND_MSG_PUB.Count_And_Get
1353: (p_count => x_msg_count,
1354: p_data => x_msg_data
1355: );
1356: END Validate_ge_hist_log_Rec;